eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_RUNTIME_PROD_PVT dependencies on FND_API

Line 93: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

89: --
90: -- End of comments
91: PROCEDURE getRelatedItems(
92: p_api_version_number IN NUMBER ,
93: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
94: p_application_id IN NUMBER ,
95: p_msite_id IN NUMBER ,
96: p_top_section_id IN NUMBER ,
97: p_incl_section IN VARCHAR2 := NULL ,

Line 202: IF NOT FND_API.Compatible_API_Call( l_api_version,

198:
199:
200: BEGIN
201: -- Standard call to check for call compatibility.
202: IF NOT FND_API.Compatible_API_Call( l_api_version,
203: p_api_version_number,
204: l_api_name,
205: G_PKG_NAME )
206: THEN

Line 207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

203: p_api_version_number,
204: l_api_name,
205: G_PKG_NAME )
206: THEN
207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
208: END IF;
209:
210: -- Initialize message list if p_init_msg_list is set to TRUE.
211: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 211: IF FND_API.to_Boolean( p_init_msg_list ) THEN

207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
208: END IF;
209:
210: -- Initialize message list if p_init_msg_list is set to TRUE.
211: IF FND_API.to_Boolean( p_init_msg_list ) THEN
212: FND_MSG_PUB.initialize;
213: END IF;
214:
215: -- Initialize API return status to success

Line 216: x_return_status := FND_API.G_RET_STS_SUCCESS;

212: FND_MSG_PUB.initialize;
213: END IF;
214:
215: -- Initialize API return status to success
216: x_return_status := FND_API.G_RET_STS_SUCCESS;
217:
218: IF (AMS_DEBUG_HIGH_ON) THEN
219:
220:

Line 268: ELSIF (p_incl_section = FND_API.G_TRUE) THEN

264: EXECUTE IMMEDIATE l_without_mtl_bulk_stmt ||
265: l_minisite_stmt ||
266: '; END;'
267: USING OUT x_items_tbl, p_rel_type_code, p_org_id, p_prod_lst, p_msite_id;
268: ELSIF (p_incl_section = FND_API.G_TRUE) THEN
269: --Include Items in top Section and Minisite
270: EXECUTE IMMEDIATE l_without_mtl_bulk_stmt ||
271: l_minisite_section_stmt ||
272: '; END;'

Line 298: ELSIF (p_incl_section = FND_API.G_TRUE) THEN

294: l_minisite_stmt ||
295: l_with_mtl_stmt4 ||
296: ')'
297: USING p_rel_type_code, p_org_id, p_prod_lst, p_msite_id, p_rel_type_code, p_prod_lst;
298: ELSIF (p_incl_section = FND_API.G_TRUE) THEN
299: --Include Items in top Section and Minisite
300: OPEN l_rel_items_csr FOR
301: l_with_mtl_stmt1 ||
302: l_minisite_section_stmt ||

Line 329: ELSIF (p_incl_section = FND_API.G_TRUE) THEN

325: OPEN l_rel_items_csr FOR
326: l_without_mtl_stmt ||
327: l_minisite_stmt
328: USING p_rel_type_code, p_org_id, p_prod_lst, p_msite_id;
329: ELSIF (p_incl_section = FND_API.G_TRUE) THEN
330: --Include Items in top Section and Minisite
331: OPEN l_rel_items_csr FOR
332: l_without_mtl_stmt ||
333: l_minisite_section_stmt

Line 387: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

383: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getRelatedItems ends');
384: END IF;
385:
386: -- Standard call to get message count and if count is 1, get message info.
387: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
388: p_count => x_msg_count,
389: p_data => x_msg_data);
390:
391: EXCEPTION

Line 392: WHEN FND_API.G_EXC_ERROR THEN

388: p_count => x_msg_count,
389: p_data => x_msg_data);
390:
391: EXCEPTION
392: WHEN FND_API.G_EXC_ERROR THEN
393: x_return_status := FND_API.G_RET_STS_ERROR;
394: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
395: p_count => x_msg_count,
396: p_data => x_msg_data);

Line 393: x_return_status := FND_API.G_RET_STS_ERROR;

389: p_data => x_msg_data);
390:
391: EXCEPTION
392: WHEN FND_API.G_EXC_ERROR THEN
393: x_return_status := FND_API.G_RET_STS_ERROR;
394: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
395: p_count => x_msg_count,
396: p_data => x_msg_data);
397:

Line 394: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

390:
391: EXCEPTION
392: WHEN FND_API.G_EXC_ERROR THEN
393: x_return_status := FND_API.G_RET_STS_ERROR;
394: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
395: p_count => x_msg_count,
396: p_data => x_msg_data);
397:
398: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 398: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

394: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
395: p_count => x_msg_count,
396: p_data => x_msg_data);
397:
398: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
400: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
401: p_count => x_msg_count,
402: p_data => x_msg_data);

Line 399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

395: p_count => x_msg_count,
396: p_data => x_msg_data);
397:
398: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
400: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
401: p_count => x_msg_count,
402: p_data => x_msg_data);
403:

Line 400: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

396: p_data => x_msg_data);
397:
398: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
400: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
401: p_count => x_msg_count,
402: p_data => x_msg_data);
403:
404: WHEN OTHERS THEN

Line 405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

401: p_count => x_msg_count,
402: p_data => x_msg_data);
403:
404: WHEN OTHERS THEN
405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
406:
407: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
408: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
409: l_api_name );

Line 411: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

407: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
408: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
409: l_api_name );
410: END IF;
411: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
412: p_count => x_msg_count,
413: p_data => x_msg_data);
414:
415: END getRelatedItems;

Line 428: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

424: --
425: -- End of comments
426: PROCEDURE getRelatedItems(
427: p_api_version_number IN NUMBER ,
428: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
429: p_application_id IN NUMBER ,
430: p_prod_lst IN JTF_NUMBER_TABLE ,
431: p_rel_type_code IN VARCHAR2 ,
432: p_org_id IN NUMBER ,

Line 548: IF NOT FND_API.Compatible_API_Call( l_api_version,

544:
545:
546: BEGIN
547: -- Standard call to check for call compatibility.
548: IF NOT FND_API.Compatible_API_Call( l_api_version,
549: p_api_version_number,
550: l_api_name,
551: G_PKG_NAME )
552: THEN

Line 553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

549: p_api_version_number,
550: l_api_name,
551: G_PKG_NAME )
552: THEN
553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
554: END IF;
555:
556: -- Initialize message list if p_init_msg_list is set to TRUE.
557: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 557: IF FND_API.to_Boolean( p_init_msg_list ) THEN

553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
554: END IF;
555:
556: -- Initialize message list if p_init_msg_list is set to TRUE.
557: IF FND_API.to_Boolean( p_init_msg_list ) THEN
558: FND_MSG_PUB.initialize;
559: END IF;
560:
561: -- Initialize API return status to success

Line 562: x_return_status := FND_API.G_RET_STS_SUCCESS;

558: FND_MSG_PUB.initialize;
559: END IF;
560:
561: -- Initialize API return status to success
562: x_return_status := FND_API.G_RET_STS_SUCCESS;
563:
564: IF (AMS_DEBUG_HIGH_ON) THEN
565:
566:

Line 679: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

675: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getRelatedItems ends');
676: END IF;
677:
678: -- Standard call to get message count and if count is 1, get message info.
679: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
680: p_count => x_msg_count,
681: p_data => x_msg_data);
682:
683: EXCEPTION

Line 684: WHEN FND_API.G_EXC_ERROR THEN

680: p_count => x_msg_count,
681: p_data => x_msg_data);
682:
683: EXCEPTION
684: WHEN FND_API.G_EXC_ERROR THEN
685: x_return_status := FND_API.G_RET_STS_ERROR;
686: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
687: p_count => x_msg_count,
688: p_data => x_msg_data);

Line 685: x_return_status := FND_API.G_RET_STS_ERROR;

681: p_data => x_msg_data);
682:
683: EXCEPTION
684: WHEN FND_API.G_EXC_ERROR THEN
685: x_return_status := FND_API.G_RET_STS_ERROR;
686: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
687: p_count => x_msg_count,
688: p_data => x_msg_data);
689:

Line 686: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

682:
683: EXCEPTION
684: WHEN FND_API.G_EXC_ERROR THEN
685: x_return_status := FND_API.G_RET_STS_ERROR;
686: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
687: p_count => x_msg_count,
688: p_data => x_msg_data);
689:
690: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 690: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

686: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
687: p_count => x_msg_count,
688: p_data => x_msg_data);
689:
690: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
692: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
693: p_count => x_msg_count,
694: p_data => x_msg_data);

Line 691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

687: p_count => x_msg_count,
688: p_data => x_msg_data);
689:
690: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
692: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
693: p_count => x_msg_count,
694: p_data => x_msg_data);
695:

Line 692: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

688: p_data => x_msg_data);
689:
690: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
692: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
693: p_count => x_msg_count,
694: p_data => x_msg_data);
695:
696:

Line 698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

694: p_data => x_msg_data);
695:
696:
697: WHEN OTHERS THEN
698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
699:
700: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
701: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
702: l_api_name );

Line 704: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

700: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
701: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
702: l_api_name );
703: END IF;
704: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
705: p_count => x_msg_count,
706: p_data => x_msg_data);
707:
708: END getRelatedItems;

Line 806: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,

802: (p_api_version_number IN NUMBER,
803: p_init_msg_list IN VARCHAR2,
804: p_application_id IN NUMBER,
805: p_party_id IN NUMBER,
806: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
807: p_currency_code IN VARCHAR2 := NULL,
808: p_prod_lst IN JTF_NUMBER_TABLE,
809: p_msite_id IN NUMBER := NULL,
810: p_top_section_id IN NUMBER := NULL,

Line 897: IF NOT FND_API.Compatible_API_Call( l_api_version,

893: l_random NUMBER;
894:
895: BEGIN
896: -- Standard call to check for call compatibility.
897: IF NOT FND_API.Compatible_API_Call( l_api_version,
898: p_api_version_number,
899: l_api_name,
900: G_PKG_NAME )
901: THEN

Line 902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

898: p_api_version_number,
899: l_api_name,
900: G_PKG_NAME )
901: THEN
902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
903: END IF;
904:
905: -- Initialize message list if p_init_msg_list is set to TRUE.
906: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 906: IF FND_API.to_Boolean( p_init_msg_list ) THEN

902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
903: END IF;
904:
905: -- Initialize message list if p_init_msg_list is set to TRUE.
906: IF FND_API.to_Boolean( p_init_msg_list ) THEN
907: FND_MSG_PUB.initialize;
908: END IF;
909:
910: -- Initialize API return status to success

Line 911: x_return_status := FND_API.G_RET_STS_SUCCESS;

907: FND_MSG_PUB.initialize;
908: END IF;
909:
910: -- Initialize API return status to success
911: x_return_status := FND_API.G_RET_STS_SUCCESS;
912:
913: IF (AMS_DEBUG_HIGH_ON) THEN
914: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getFilteredProdsFromList starts');
915: END IF;

Line 1045: , FND_API.G_FALSE

1041: -- 4. Get Prioritized Products if any Product Priority is given
1042: IF(p_bus_prior = 'PROD_LIST_PRICE' AND p_price_list_id IS NOT NULL) THEN
1043: getPrioritizedProds(
1044: p_api_version_number
1045: , FND_API.G_FALSE
1046: , p_application_id
1047: , p_party_id
1048: , p_cust_account_id
1049: , p_currency_code

Line 1078: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1074: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getFilteredProdsFromList ends');
1075: END IF;
1076:
1077: -- Standard call to get message count and if count is 1, get message info.
1078: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1079: p_count => x_msg_count,
1080: p_data => x_msg_data);
1081:
1082: EXCEPTION

Line 1083: WHEN FND_API.G_EXC_ERROR THEN

1079: p_count => x_msg_count,
1080: p_data => x_msg_data);
1081:
1082: EXCEPTION
1083: WHEN FND_API.G_EXC_ERROR THEN
1084: x_return_status := FND_API.G_RET_STS_ERROR;
1085: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1086: p_count => x_msg_count,
1087: p_data => x_msg_data);

Line 1084: x_return_status := FND_API.G_RET_STS_ERROR;

1080: p_data => x_msg_data);
1081:
1082: EXCEPTION
1083: WHEN FND_API.G_EXC_ERROR THEN
1084: x_return_status := FND_API.G_RET_STS_ERROR;
1085: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1086: p_count => x_msg_count,
1087: p_data => x_msg_data);
1088:

Line 1085: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1081:
1082: EXCEPTION
1083: WHEN FND_API.G_EXC_ERROR THEN
1084: x_return_status := FND_API.G_RET_STS_ERROR;
1085: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1086: p_count => x_msg_count,
1087: p_data => x_msg_data);
1088:
1089: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1089: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1085: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1086: p_count => x_msg_count,
1087: p_data => x_msg_data);
1088:
1089: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1090: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1091: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1092: p_count => x_msg_count,
1093: p_data => x_msg_data);

Line 1090: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1086: p_count => x_msg_count,
1087: p_data => x_msg_data);
1088:
1089: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1090: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1091: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1092: p_count => x_msg_count,
1093: p_data => x_msg_data);
1094:

Line 1091: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1087: p_data => x_msg_data);
1088:
1089: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1090: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1091: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1092: p_count => x_msg_count,
1093: p_data => x_msg_data);
1094:
1095:

Line 1097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1093: p_data => x_msg_data);
1094:
1095:
1096: WHEN OTHERS THEN
1097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1098:
1099: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1100: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1101: l_api_name);

Line 1103: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1099: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1100: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1101: l_api_name);
1102: END IF;
1103: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1104: p_count => x_msg_count,
1105: p_data => x_msg_data);
1106:
1107: END getFilteredProdsFromList;

Line 1116: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,

1112: (p_api_version_number IN NUMBER,
1113: p_init_msg_list IN VARCHAR2,
1114: p_application_id IN NUMBER,
1115: p_party_id IN NUMBER,
1116: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
1117: p_currency_code IN VARCHAR2 := NULL,
1118: p_quote_id IN NUMBER,
1119: p_msite_id IN NUMBER,
1120: p_top_section_id IN NUMBER,

Line 1151: IF NOT FND_API.Compatible_API_Call( l_api_version,

1147: l_limit NUMBER;
1148:
1149: BEGIN
1150: -- Standard call to check for call compatibility.
1151: IF NOT FND_API.Compatible_API_Call( l_api_version,
1152: p_api_version_number,
1153: l_api_name,
1154: G_PKG_NAME )
1155: THEN

Line 1156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1152: p_api_version_number,
1153: l_api_name,
1154: G_PKG_NAME )
1155: THEN
1156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1157: END IF;
1158:
1159: -- Initialize message list if p_init_msg_list is set to TRUE.
1160: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1160: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1157: END IF;
1158:
1159: -- Initialize message list if p_init_msg_list is set to TRUE.
1160: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1161: FND_MSG_PUB.initialize;
1162: END IF;
1163:
1164: -- Initialize API return status to success

Line 1165: x_return_status := FND_API.G_RET_STS_SUCCESS;

1161: FND_MSG_PUB.initialize;
1162: END IF;
1163:
1164: -- Initialize API return status to success
1165: x_return_status := FND_API.G_RET_STS_SUCCESS;
1166:
1167: IF (AMS_DEBUG_HIGH_ON) THEN
1168: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getRelProdsForQuoteAndCust starts');
1169: END IF;

Line 1181: RAISE FND_API.G_EXC_ERROR;

1177: END IF;
1178: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_VALID');
1179: FND_MESSAGE.Set_Token('RELATIONSHIP', p_rel_type_code);
1180: FND_MSG_PUB.Add;
1181: RAISE FND_API.G_EXC_ERROR;
1182: END IF;
1183:
1184: IF (p_filter_ref_code = 'INCL_PROD_SECTION') THEN
1185: l_incl_top_section := FND_API.G_TRUE;

Line 1185: l_incl_top_section := FND_API.G_TRUE;

1181: RAISE FND_API.G_EXC_ERROR;
1182: END IF;
1183:
1184: IF (p_filter_ref_code = 'INCL_PROD_SECTION') THEN
1185: l_incl_top_section := FND_API.G_TRUE;
1186: ELSIF(p_filter_ref_code = 'EXCL_PROD_SECTION') THEN
1187: l_incl_top_section := FND_API.G_FALSE;
1188: END IF;
1189:

Line 1187: l_incl_top_section := FND_API.G_FALSE;

1183:
1184: IF (p_filter_ref_code = 'INCL_PROD_SECTION') THEN
1185: l_incl_top_section := FND_API.G_TRUE;
1186: ELSIF(p_filter_ref_code = 'EXCL_PROD_SECTION') THEN
1187: l_incl_top_section := FND_API.G_FALSE;
1188: END IF;
1189:
1190: IF(p_bus_prior = 'RANDOM'
1191: OR (p_bus_prior = 'PROD_LIST_PRICE' AND p_price_list_id IS NOT NULL)) THEN

Line 1223: USING IN l_api_version, IN FND_API.G_FALSE,

1219: -- 3. Collect related items
1220: IF (p_msite_id IS NULL) THEN
1221: EXECUTE IMMEDIATE 'BEGIN AMS_RUNTIME_PROD_PVT.getRelatedItems( :1, :2, :3, :4, :5,
1222: :6, :7, :8, :9, :10, :11, :12 ); END;'
1223: USING IN l_api_version, IN FND_API.G_FALSE,
1224: IN p_application_id, IN l_quote_prod_lst,
1225: IN p_rel_type_code, IN p_org_id,
1226: IN l_max, IN l_null,
1227: OUT l_prod_lst,

Line 1232: USING IN l_api_version, IN FND_API.G_FALSE,

1228: OUT l_return_status, OUT l_msg_count, OUT l_msg_data;
1229: ELSE
1230: EXECUTE IMMEDIATE 'BEGIN AMS_RUNTIME_PROD_PVT.getRelatedItems( :1, :2, :3, :4, :5,
1231: :6, :7, :8, :9, :10, :11, :12, :13, :14, :15 ); END;'
1232: USING IN l_api_version, IN FND_API.G_FALSE,
1233: IN p_application_id, IN p_msite_id,
1234: IN p_top_section_id, IN l_incl_top_section,
1235: IN l_quote_prod_lst, IN p_rel_type_code,
1236: IN p_org_id, IN l_max,

Line 1245: , FND_API.G_FALSE

1241: -- 4. Get Prioritized Products if any Product Priority is given
1242: IF(p_bus_prior = 'PROD_LIST_PRICE' AND p_price_list_id IS NOT NULL) THEN
1243: getPrioritizedProds(
1244: p_api_version_number
1245: , FND_API.G_FALSE
1246: , p_application_id
1247: , p_party_id
1248: , p_cust_account_id
1249: , p_currency_code

Line 1280: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1276: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getRelProdsForQuoteAndCust ends');
1277: END IF;
1278:
1279: -- Standard call to get message count and if count is 1, get message info.
1280: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1281: p_count => x_msg_count,
1282: p_data => x_msg_data);
1283:
1284: EXCEPTION

Line 1285: WHEN FND_API.G_EXC_ERROR THEN

1281: p_count => x_msg_count,
1282: p_data => x_msg_data);
1283:
1284: EXCEPTION
1285: WHEN FND_API.G_EXC_ERROR THEN
1286: x_return_status := FND_API.G_RET_STS_ERROR;
1287: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1288: p_count => x_msg_count,
1289: p_data => x_msg_data);

Line 1286: x_return_status := FND_API.G_RET_STS_ERROR;

1282: p_data => x_msg_data);
1283:
1284: EXCEPTION
1285: WHEN FND_API.G_EXC_ERROR THEN
1286: x_return_status := FND_API.G_RET_STS_ERROR;
1287: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1288: p_count => x_msg_count,
1289: p_data => x_msg_data);
1290:

Line 1287: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1283:
1284: EXCEPTION
1285: WHEN FND_API.G_EXC_ERROR THEN
1286: x_return_status := FND_API.G_RET_STS_ERROR;
1287: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1288: p_count => x_msg_count,
1289: p_data => x_msg_data);
1290:
1291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1287: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1288: p_count => x_msg_count,
1289: p_data => x_msg_data);
1290:
1291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1293: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1294: p_count => x_msg_count,
1295: p_data => x_msg_data);

Line 1292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1288: p_count => x_msg_count,
1289: p_data => x_msg_data);
1290:
1291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1293: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1294: p_count => x_msg_count,
1295: p_data => x_msg_data);
1296:

Line 1293: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1289: p_data => x_msg_data);
1290:
1291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1293: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1294: p_count => x_msg_count,
1295: p_data => x_msg_data);
1296:
1297:

Line 1299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1295: p_data => x_msg_data);
1296:
1297:
1298: WHEN OTHERS THEN
1299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1300:
1301: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1302: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1303: l_api_name );

Line 1305: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1301: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1302: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1303: l_api_name );
1304: END IF;
1305: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1306: p_count => x_msg_count ,
1307: p_data => x_msg_data );
1308:
1309: END getRelProdsForQuoteAndCust;

Line 1318: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,

1314: (p_api_version_number IN NUMBER,
1315: p_init_msg_list IN VARCHAR2,
1316: p_application_id IN NUMBER,
1317: p_party_id IN NUMBER,
1318: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
1319: p_currency_code IN VARCHAR2 := NULL,
1320: p_prod_lst IN JTF_NUMBER_TABLE,
1321: p_msite_id IN NUMBER,
1322: p_top_section_id IN NUMBER,

Line 1352: IF NOT FND_API.Compatible_API_Call( l_api_version,

1348: l_limit NUMBER;
1349:
1350: BEGIN
1351: -- Standard call to check for call compatibility.
1352: IF NOT FND_API.Compatible_API_Call( l_api_version,
1353: p_api_version_number,
1354: l_api_name,
1355: G_PKG_NAME )
1356: THEN

Line 1357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1353: p_api_version_number,
1354: l_api_name,
1355: G_PKG_NAME )
1356: THEN
1357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1358: END IF;
1359:
1360: -- Initialize message list if p_init_msg_list is set to TRUE.
1361: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1361: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1358: END IF;
1359:
1360: -- Initialize message list if p_init_msg_list is set to TRUE.
1361: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1362: FND_MSG_PUB.initialize;
1363: END IF;
1364:
1365: -- Initialize API return status to success

Line 1366: x_return_status := FND_API.G_RET_STS_SUCCESS;

1362: FND_MSG_PUB.initialize;
1363: END IF;
1364:
1365: -- Initialize API return status to success
1366: x_return_status := FND_API.G_RET_STS_SUCCESS;
1367:
1368: IF (AMS_DEBUG_HIGH_ON) THEN
1369: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getRelProdsForProdAndCust starts');
1370: END IF;

Line 1382: RAISE FND_API.G_EXC_ERROR;

1378: END IF;
1379: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_VALID');
1380: FND_MESSAGE.Set_Token('RELATIONSHIP', p_rel_type_code);
1381: FND_MSG_PUB.Add;
1382: RAISE FND_API.G_EXC_ERROR;
1383: END IF;
1384:
1385: IF (p_filter_ref_code = 'INCL_PROD_SECTION') THEN
1386: l_incl_top_section := FND_API.G_TRUE;

Line 1386: l_incl_top_section := FND_API.G_TRUE;

1382: RAISE FND_API.G_EXC_ERROR;
1383: END IF;
1384:
1385: IF (p_filter_ref_code = 'INCL_PROD_SECTION') THEN
1386: l_incl_top_section := FND_API.G_TRUE;
1387: ELSIF(p_filter_ref_code = 'EXCL_PROD_SECTION') THEN
1388: l_incl_top_section := FND_API.G_FALSE;
1389: END IF;
1390:

Line 1388: l_incl_top_section := FND_API.G_FALSE;

1384:
1385: IF (p_filter_ref_code = 'INCL_PROD_SECTION') THEN
1386: l_incl_top_section := FND_API.G_TRUE;
1387: ELSIF(p_filter_ref_code = 'EXCL_PROD_SECTION') THEN
1388: l_incl_top_section := FND_API.G_FALSE;
1389: END IF;
1390:
1391: IF(p_bus_prior = 'RANDOM'
1392: OR (p_bus_prior = 'PROD_LIST_PRICE' AND p_price_list_id IS NOT NULL)) THEN

Line 1402: USING IN l_api_version, IN FND_API.G_FALSE,

1398: -- 2. Collect related items
1399: IF (p_msite_id IS NULL) THEN
1400: EXECUTE IMMEDIATE 'BEGIN AMS_RUNTIME_PROD_PVT.getRelatedItems( :1, :2, :3, :4, :5,
1401: :6, :7, :8, :9, :10, :11, :12 ); END;'
1402: USING IN l_api_version, IN FND_API.G_FALSE,
1403: IN p_application_id, IN p_prod_lst,
1404: IN p_rel_type_code, IN p_org_id,
1405: IN l_max, IN l_null,
1406: OUT l_prod_lst,

Line 1411: USING IN l_api_version, IN FND_API.G_FALSE,

1407: OUT l_return_status, OUT l_msg_count, OUT l_msg_data;
1408: ELSE
1409: EXECUTE IMMEDIATE 'BEGIN AMS_RUNTIME_PROD_PVT.getRelatedItems( :1, :2, :3, :4, :5,
1410: :6, :7, :8, :9, :10, :11, :12, :13, :14, :15 ); END;'
1411: USING IN l_api_version, IN FND_API.G_FALSE,
1412: IN p_application_id, IN p_msite_id,
1413: IN p_top_section_id, IN l_incl_top_section,
1414: IN p_prod_lst, IN p_rel_type_code,
1415: IN p_org_id, IN l_max,

Line 1428: , FND_API.G_FALSE

1424: AMS_UTILITY_PVT.debug_message('Calling Price priority');
1425: END IF;
1426: getPrioritizedProds(
1427: p_api_version_number
1428: , FND_API.G_FALSE
1429: , p_application_id
1430: , p_party_id
1431: , p_cust_account_id
1432: , p_currency_code

Line 1469: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1465:
1466: END IF;
1467:
1468: -- Standard call to get message count and if count is 1, get message info.
1469: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1470: p_count => x_msg_count ,
1471: p_data => x_msg_data );
1472:
1473: EXCEPTION

Line 1474: WHEN FND_API.G_EXC_ERROR THEN

1470: p_count => x_msg_count ,
1471: p_data => x_msg_data );
1472:
1473: EXCEPTION
1474: WHEN FND_API.G_EXC_ERROR THEN
1475: x_return_status := FND_API.G_RET_STS_ERROR;
1476: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1477: p_count => x_msg_count ,
1478: p_data => x_msg_data );

Line 1475: x_return_status := FND_API.G_RET_STS_ERROR;

1471: p_data => x_msg_data );
1472:
1473: EXCEPTION
1474: WHEN FND_API.G_EXC_ERROR THEN
1475: x_return_status := FND_API.G_RET_STS_ERROR;
1476: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1477: p_count => x_msg_count ,
1478: p_data => x_msg_data );
1479:

Line 1476: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1472:
1473: EXCEPTION
1474: WHEN FND_API.G_EXC_ERROR THEN
1475: x_return_status := FND_API.G_RET_STS_ERROR;
1476: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1477: p_count => x_msg_count ,
1478: p_data => x_msg_data );
1479:
1480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1476: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1477: p_count => x_msg_count ,
1478: p_data => x_msg_data );
1479:
1480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1482: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1483: p_count => x_msg_count ,
1484: p_data => x_msg_data );

Line 1481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1477: p_count => x_msg_count ,
1478: p_data => x_msg_data );
1479:
1480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1482: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1483: p_count => x_msg_count ,
1484: p_data => x_msg_data );
1485:

Line 1482: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1478: p_data => x_msg_data );
1479:
1480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1482: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1483: p_count => x_msg_count ,
1484: p_data => x_msg_data );
1485:
1486:

Line 1488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1484: p_data => x_msg_data );
1485:
1486:
1487: WHEN OTHERS THEN
1488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1489:
1490: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1491: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1492: l_api_name );

Line 1494: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1490: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1491: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1492: l_api_name );
1493: END IF;
1494: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1495: p_count => x_msg_count ,
1496: p_data => x_msg_data );
1497:
1498: END getRelProdsForProdAndCust;

Line 1506: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,

1502: (p_api_version_number IN NUMBER,
1503: p_init_msg_list IN VARCHAR2,
1504: p_application_id IN NUMBER,
1505: p_party_id IN NUMBER,
1506: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
1507: p_currency_code IN VARCHAR2 := NULL,
1508: p_prod_lst IN JTF_NUMBER_TABLE,
1509: p_org_id IN NUMBER,
1510: p_bus_prior IN VARCHAR2,

Line 1548: IF NOT FND_API.Compatible_API_Call( l_api_version,

1544: p_in_prod_lst JTF_VARCHAR2_TABLE_100;
1545:
1546: BEGIN
1547: -- Standard call to check for call compatibility.
1548: IF NOT FND_API.Compatible_API_Call( l_api_version,
1549: p_api_version_number,
1550: l_api_name,
1551: G_PKG_NAME )
1552: THEN

Line 1553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1549: p_api_version_number,
1550: l_api_name,
1551: G_PKG_NAME )
1552: THEN
1553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1554: END IF;
1555:
1556: -- Initialize message list if p_init_msg_list is set to TRUE.
1557: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1557: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1554: END IF;
1555:
1556: -- Initialize message list if p_init_msg_list is set to TRUE.
1557: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1558: FND_MSG_PUB.initialize;
1559: END IF;
1560:
1561: -- Initialize API return status to success

Line 1562: x_return_status := FND_API.G_RET_STS_SUCCESS;

1558: FND_MSG_PUB.initialize;
1559: END IF;
1560:
1561: -- Initialize API return status to success
1562: x_return_status := FND_API.G_RET_STS_SUCCESS;
1563:
1564: IF (AMS_DEBUG_HIGH_ON) THEN
1565: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getPrioritizedProds starts');
1566: END IF;

Line 1715: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1711:
1712: -- End of API body.
1713:
1714: -- Standard call to get message count and if count is 1, get message info.
1715: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1716: p_count => x_msg_count,
1717: p_data => x_msg_data);
1718:
1719: EXCEPTION

Line 1720: WHEN FND_API.G_EXC_ERROR THEN

1716: p_count => x_msg_count,
1717: p_data => x_msg_data);
1718:
1719: EXCEPTION
1720: WHEN FND_API.G_EXC_ERROR THEN
1721: x_return_status := FND_API.G_RET_STS_ERROR;
1722: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1723: p_count => x_msg_count,
1724: p_data => x_msg_data);

Line 1721: x_return_status := FND_API.G_RET_STS_ERROR;

1717: p_data => x_msg_data);
1718:
1719: EXCEPTION
1720: WHEN FND_API.G_EXC_ERROR THEN
1721: x_return_status := FND_API.G_RET_STS_ERROR;
1722: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1723: p_count => x_msg_count,
1724: p_data => x_msg_data);
1725:

Line 1722: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1718:
1719: EXCEPTION
1720: WHEN FND_API.G_EXC_ERROR THEN
1721: x_return_status := FND_API.G_RET_STS_ERROR;
1722: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1723: p_count => x_msg_count,
1724: p_data => x_msg_data);
1725:
1726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1722: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1723: p_count => x_msg_count,
1724: p_data => x_msg_data);
1725:
1726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1728: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1729: p_count => x_msg_count,
1730: p_data => x_msg_data);

Line 1727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1723: p_count => x_msg_count,
1724: p_data => x_msg_data);
1725:
1726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1728: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1729: p_count => x_msg_count,
1730: p_data => x_msg_data);
1731:

Line 1728: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1724: p_data => x_msg_data);
1725:
1726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1728: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1729: p_count => x_msg_count,
1730: p_data => x_msg_data);
1731:
1732:

Line 1734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1730: p_data => x_msg_data);
1731:
1732:
1733: WHEN OTHERS THEN
1734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1735:
1736: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1737: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1738: l_api_name );

Line 1740: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1736: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1737: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1738: l_api_name );
1739: END IF;
1740: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1741: p_count => x_msg_count,
1742: p_data => x_msg_data);
1743:
1744: END getPrioritizedProds;

Line 1749: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1745:
1746:
1747: procedure loadItemDetails
1748: (p_api_version IN NUMBER,
1749: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1750: p_application_id IN NUMBER,
1751: p_party_id IN NUMBER,
1752: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
1753: p_currency_code IN VARCHAR2 := NULL,

Line 1752: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,

1748: (p_api_version IN NUMBER,
1749: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1750: p_application_id IN NUMBER,
1751: p_party_id IN NUMBER,
1752: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
1753: p_currency_code IN VARCHAR2 := NULL,
1754: p_itmid_tbl IN JTF_NUMBER_TABLE,
1755: p_organization_id IN NUMBER,
1756: p_category_set_id IN NUMBER,

Line 1757: p_retrieve_price IN VARCHAR2 := FND_API.G_FALSE,

1753: p_currency_code IN VARCHAR2 := NULL,
1754: p_itmid_tbl IN JTF_NUMBER_TABLE,
1755: p_organization_id IN NUMBER,
1756: p_category_set_id IN NUMBER,
1757: p_retrieve_price IN VARCHAR2 := FND_API.G_FALSE,
1758: p_price_list_id IN NUMBER := NULL,
1759: p_price_request_type IN VARCHAR2 := NULL,
1760: p_price_event IN VARCHAR2 := NULL,
1761: x_item_csr OUT NOCOPY prod_cursor,

Line 1816: IF NOT FND_API.Compatible_API_Call( l_api_version,

1812: l_uomcode_tbl JTF_VARCHAR2_TABLE_100;
1813:
1814: BEGIN
1815: -- Standard call to check for call compatibility.
1816: IF NOT FND_API.Compatible_API_Call( l_api_version,
1817: p_api_version,
1818: l_api_name,
1819: G_PKG_NAME )
1820: THEN

Line 1821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1817: p_api_version,
1818: l_api_name,
1819: G_PKG_NAME )
1820: THEN
1821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1822: END IF;
1823:
1824: -- Initialize message list if p_init_msg_list is set to TRUE.
1825: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1825: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1822: END IF;
1823:
1824: -- Initialize message list if p_init_msg_list is set to TRUE.
1825: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1826: FND_MSG_PUB.initialize;
1827: END IF;
1828:
1829: -- Initialize API return status to success

Line 1830: x_item_return_status := FND_API.G_RET_STS_SUCCESS;

1826: FND_MSG_PUB.initialize;
1827: END IF;
1828:
1829: -- Initialize API return status to success
1830: x_item_return_status := FND_API.G_RET_STS_SUCCESS;
1831:
1832: IF (AMS_DEBUG_HIGH_ON) THEN
1833: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.loadItemDetails starts');
1834: END IF;

Line 1846: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1842: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.loadItemDetails ends');
1843: END IF;
1844:
1845: -- Standard call to get message count and if count is 1, get message info.
1846: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1847: p_count => x_msg_count ,
1848: p_data => x_msg_data );
1849: return;
1850: END IF;

Line 1872: IF FND_API.to_Boolean(p_retrieve_price) THEN

1868: USING p_organization_id, p_category_set_id,p_itmid_tbl;
1869: END IF;
1870:
1871: -- calls pricing engine APIs if retrieve price is true
1872: IF FND_API.to_Boolean(p_retrieve_price) THEN
1873:
1874: l_uomcode_tbl := JTF_VARCHAR2_TABLE_100();
1875:
1876: FOR l_Index IN 1..p_itmid_tbl.COUNT LOOP

Line 1886: l_uomcode_tbl(l_Index) := FND_API.G_MISS_CHAR;

1882: l_uomcode_tbl.EXTEND;
1883: IF l_uom_csr%FOUND THEN
1884: l_uomcode_tbl(l_Index) := l_uomcode;
1885: ELSE
1886: l_uomcode_tbl(l_Index) := FND_API.G_MISS_CHAR;
1887: END IF;
1888: CLOSE l_uom_csr;
1889:
1890: END LOOP;

Line 1916: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1912:
1913: -- End of API body.
1914:
1915: -- Standard call to get message count and if count is 1, get message info.
1916: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1917: p_count => x_msg_count,
1918: p_data => x_msg_data);
1919:
1920: EXCEPTION

Line 1921: WHEN FND_API.G_EXC_ERROR THEN

1917: p_count => x_msg_count,
1918: p_data => x_msg_data);
1919:
1920: EXCEPTION
1921: WHEN FND_API.G_EXC_ERROR THEN
1922: x_item_return_status := FND_API.G_RET_STS_ERROR;
1923: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1924: p_count => x_msg_count,
1925: p_data => x_msg_data);

Line 1922: x_item_return_status := FND_API.G_RET_STS_ERROR;

1918: p_data => x_msg_data);
1919:
1920: EXCEPTION
1921: WHEN FND_API.G_EXC_ERROR THEN
1922: x_item_return_status := FND_API.G_RET_STS_ERROR;
1923: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1924: p_count => x_msg_count,
1925: p_data => x_msg_data);
1926:

Line 1923: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1919:
1920: EXCEPTION
1921: WHEN FND_API.G_EXC_ERROR THEN
1922: x_item_return_status := FND_API.G_RET_STS_ERROR;
1923: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1924: p_count => x_msg_count,
1925: p_data => x_msg_data);
1926:
1927: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1927: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1923: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1924: p_count => x_msg_count,
1925: p_data => x_msg_data);
1926:
1927: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1928: x_item_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1929: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1930: p_count => x_msg_count,
1931: p_data => x_msg_data);

Line 1928: x_item_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1924: p_count => x_msg_count,
1925: p_data => x_msg_data);
1926:
1927: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1928: x_item_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1929: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1930: p_count => x_msg_count,
1931: p_data => x_msg_data);
1932:

Line 1929: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1925: p_data => x_msg_data);
1926:
1927: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1928: x_item_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1929: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1930: p_count => x_msg_count,
1931: p_data => x_msg_data);
1932:
1933:

Line 1935: x_item_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1931: p_data => x_msg_data);
1932:
1933:
1934: WHEN OTHERS THEN
1935: x_item_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1936:
1937: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1938: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1939: END IF;

Line 1941: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1937: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1938: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1939: END IF;
1940:
1941: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1942: p_count => x_msg_count,
1943: p_data => x_msg_data);
1944:
1945: END loadItemDetails;

Line 1955: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,

1951: (p_api_version_number IN NUMBER,
1952: p_init_msg_list IN VARCHAR2,
1953: p_application_id IN NUMBER,
1954: p_party_id IN NUMBER,
1955: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
1956: p_currency_code IN VARCHAR2 := NULL,
1957: p_quote_id IN NUMBER,
1958: p_msite_id IN NUMBER,
1959: p_top_section_id IN NUMBER,

Line 1988: IF NOT FND_API.Compatible_API_Call( l_api_version,

1984:
1985: BEGIN
1986:
1987: -- Standard call to check for call compatibility.
1988: IF NOT FND_API.Compatible_API_Call( l_api_version,
1989: p_api_version_number,
1990: l_api_name,
1991: G_PKG_NAME )
1992: THEN

Line 1993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1989: p_api_version_number,
1990: l_api_name,
1991: G_PKG_NAME )
1992: THEN
1993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1994: END IF;
1995:
1996: -- Initialize message list if p_init_msg_list is set to TRUE.
1997:

Line 1998: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1994: END IF;
1995:
1996: -- Initialize message list if p_init_msg_list is set to TRUE.
1997:
1998: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1999: FND_MSG_PUB.initialize;
2000: END IF;
2001:
2002: -- Initialize API return status to success

Line 2004: x_return_status := FND_API.G_RET_STS_SUCCESS;

2000: END IF;
2001:
2002: -- Initialize API return status to success
2003:
2004: x_return_status := FND_API.G_RET_STS_SUCCESS;
2005:
2006: IF (AMS_DEBUG_HIGH_ON) THEN
2007: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getRelProdsForCart starts');
2008: END IF;

Line 2023: RAISE FND_API.G_EXC_ERROR;

2019: END IF;
2020: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_VALID');
2021: FND_MESSAGE.Set_Token('RELATIONSHIP', p_rel_type_code);
2022: FND_MSG_PUB.Add;
2023: RAISE FND_API.G_EXC_ERROR;
2024: END IF;
2025:
2026: l_max := p_max_ret_num;
2027:

Line 2054: USING IN l_api_version, IN FND_API.G_FALSE,

2050: -- 3. Collect related items
2051: IF (p_msite_id IS NULL) THEN
2052: EXECUTE IMMEDIATE 'BEGIN AMS_RUNTIME_PROD_PVT.getRelatedItems( :1, :2, :3, :4, :5,
2053: :6, :7, :8, :9, :10, :11, :12 ); END;'
2054: USING IN l_api_version, IN FND_API.G_FALSE,
2055: IN p_application_id, IN l_quote_prod_lst,
2056: IN p_rel_type_code, IN p_org_id,
2057: IN l_max, IN l_null,
2058: OUT l_prod_lst,

Line 2063: USING IN l_api_version, IN FND_API.G_FALSE,

2059: OUT l_return_status, OUT l_msg_count, OUT l_msg_data;
2060: ELSE
2061: EXECUTE IMMEDIATE 'BEGIN AMS_RUNTIME_PROD_PVT.getRelatedItems( :1, :2, :3, :4, :5,
2062: :6, :7, :8, :9, :10, :11, :12, :13, :14, :15 ); END;'
2063: USING IN l_api_version, IN FND_API.G_FALSE,
2064: IN p_application_id, IN p_msite_id,
2065: IN p_top_section_id, IN l_incl_top_section,
2066: IN l_quote_prod_lst, IN p_rel_type_code,
2067: IN p_org_id, IN l_max,

Line 2091: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2087: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getRelProdsForQuoteAndCust ends');
2088: END IF;
2089:
2090: -- Standard call to get message count and if count is 1, get message info.
2091: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2092: p_count => x_msg_count,
2093: p_data => x_msg_data);
2094:
2095: EXCEPTION

Line 2096: WHEN FND_API.G_EXC_ERROR THEN

2092: p_count => x_msg_count,
2093: p_data => x_msg_data);
2094:
2095: EXCEPTION
2096: WHEN FND_API.G_EXC_ERROR THEN
2097: x_return_status := FND_API.G_RET_STS_ERROR;
2098: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2099: p_count => x_msg_count,
2100: p_data => x_msg_data);

Line 2097: x_return_status := FND_API.G_RET_STS_ERROR;

2093: p_data => x_msg_data);
2094:
2095: EXCEPTION
2096: WHEN FND_API.G_EXC_ERROR THEN
2097: x_return_status := FND_API.G_RET_STS_ERROR;
2098: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2099: p_count => x_msg_count,
2100: p_data => x_msg_data);
2101:

Line 2098: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2094:
2095: EXCEPTION
2096: WHEN FND_API.G_EXC_ERROR THEN
2097: x_return_status := FND_API.G_RET_STS_ERROR;
2098: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2099: p_count => x_msg_count,
2100: p_data => x_msg_data);
2101:
2102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2098: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2099: p_count => x_msg_count,
2100: p_data => x_msg_data);
2101:
2102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2104: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2105: p_count => x_msg_count,
2106: p_data => x_msg_data);

Line 2103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2099: p_count => x_msg_count,
2100: p_data => x_msg_data);
2101:
2102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2104: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2105: p_count => x_msg_count,
2106: p_data => x_msg_data);
2107:

Line 2104: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2100: p_data => x_msg_data);
2101:
2102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2104: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2105: p_count => x_msg_count,
2106: p_data => x_msg_data);
2107:
2108:

Line 2110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2106: p_data => x_msg_data);
2107:
2108:
2109: WHEN OTHERS THEN
2110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2111:
2112: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2113: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2114: l_api_name );

Line 2116: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2112: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2113: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2114: l_api_name );
2115: END IF;
2116: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2117: p_count => x_msg_count ,
2118: p_data => x_msg_data );
2119:
2120: END getRelProdsForCart;

Line 2129: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,

2125: (p_api_version_number IN NUMBER,
2126: p_init_msg_list IN VARCHAR2,
2127: p_application_id IN NUMBER,
2128: p_party_id IN NUMBER,
2129: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
2130: p_currency_code IN VARCHAR2 := NULL,
2131: p_prod_lst IN JTF_NUMBER_TABLE,
2132: p_msite_id IN NUMBER,
2133: p_top_section_id IN NUMBER,

Line 2160: IF NOT FND_API.Compatible_API_Call( l_api_version,

2156: l_index BINARY_INTEGER;
2157:
2158: BEGIN
2159: -- Standard call to check for call compatibility.
2160: IF NOT FND_API.Compatible_API_Call( l_api_version,
2161: p_api_version_number,
2162: l_api_name,
2163: G_PKG_NAME )
2164: THEN

Line 2165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2161: p_api_version_number,
2162: l_api_name,
2163: G_PKG_NAME )
2164: THEN
2165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2166: END IF;
2167:
2168:
2169: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2170: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2166: END IF;
2167:
2168:
2169: -- Initialize message list if p_init_msg_list is set to TRUE.
2170: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2171: FND_MSG_PUB.initialize;
2172: END IF;
2173:
2174: -- Initialize API return status to success

Line 2175: -- x_return_status := FND_API.G_RET_STS_SUCCESS;

2171: FND_MSG_PUB.initialize;
2172: END IF;
2173:
2174: -- Initialize API return status to success
2175: -- x_return_status := FND_API.G_RET_STS_SUCCESS;
2176:
2177: IF (AMS_DEBUG_HIGH_ON) THEN
2178: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getRelProdsForProd starts');
2179: END IF;

Line 2191: RAISE FND_API.G_EXC_ERROR;

2187:
2188: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_VALID');
2189: FND_MESSAGE.Set_Token('RELATIONSHIP', p_rel_type_code);
2190: FND_MSG_PUB.Add;
2191: RAISE FND_API.G_EXC_ERROR;
2192:
2193: END IF;
2194:
2195: l_max := p_max_ret_num;

Line 2202: USING IN l_api_version, IN FND_API.G_FALSE,

2198:
2199: IF (p_msite_id IS NULL) THEN
2200:
2201: EXECUTE IMMEDIATE 'BEGIN AMS_RUNTIME_PROD_PVT.getRelatedItems( :1, :2, :3, :4, :5,:6, :7, :8, :9, :10, :11, :12 ); END;'
2202: USING IN l_api_version, IN FND_API.G_FALSE,
2203: IN p_application_id, IN p_prod_lst,
2204: IN p_rel_type_code, IN p_org_id,
2205: IN l_max, IN l_null,
2206: OUT l_prod_lst,

Line 2212: USING IN l_api_version, IN FND_API.G_FALSE,

2208:
2209: ELSE
2210:
2211: EXECUTE IMMEDIATE 'BEGIN AMS_RUNTIME_PROD_PVT.getRelatedItems( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15 ); END;'
2212: USING IN l_api_version, IN FND_API.G_FALSE,
2213: IN p_application_id, IN p_msite_id,
2214: IN p_top_section_id, IN l_incl_top_section,
2215: IN p_prod_lst, IN p_rel_type_code,
2216: IN p_org_id, IN l_max,

Line 2237: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2233: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getRelProdsForProdAndCust ends');
2234: END IF;
2235:
2236: -- Standard call to get message count and if count is 1, get message info.
2237: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2238: p_count => x_msg_count ,
2239: p_data => x_msg_data );
2240:
2241: EXCEPTION

Line 2242: WHEN FND_API.G_EXC_ERROR THEN

2238: p_count => x_msg_count ,
2239: p_data => x_msg_data );
2240:
2241: EXCEPTION
2242: WHEN FND_API.G_EXC_ERROR THEN
2243: x_return_status := FND_API.G_RET_STS_ERROR;
2244: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2245: p_count => x_msg_count ,
2246: p_data => x_msg_data );

Line 2243: x_return_status := FND_API.G_RET_STS_ERROR;

2239: p_data => x_msg_data );
2240:
2241: EXCEPTION
2242: WHEN FND_API.G_EXC_ERROR THEN
2243: x_return_status := FND_API.G_RET_STS_ERROR;
2244: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2245: p_count => x_msg_count ,
2246: p_data => x_msg_data );
2247:

Line 2244: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2240:
2241: EXCEPTION
2242: WHEN FND_API.G_EXC_ERROR THEN
2243: x_return_status := FND_API.G_RET_STS_ERROR;
2244: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2245: p_count => x_msg_count ,
2246: p_data => x_msg_data );
2247:
2248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2244: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2245: p_count => x_msg_count ,
2246: p_data => x_msg_data );
2247:
2248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2250: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2251: p_count => x_msg_count ,
2252: p_data => x_msg_data );

Line 2249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2245: p_count => x_msg_count ,
2246: p_data => x_msg_data );
2247:
2248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2250: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2251: p_count => x_msg_count ,
2252: p_data => x_msg_data );
2253:

Line 2250: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2246: p_data => x_msg_data );
2247:
2248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2250: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2251: p_count => x_msg_count ,
2252: p_data => x_msg_data );
2253:
2254:

Line 2256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2252: p_data => x_msg_data );
2253:
2254:
2255: WHEN OTHERS THEN
2256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2257:
2258: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2259: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2260: l_api_name );

Line 2262: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2258: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2259: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2260: l_api_name );
2261: END IF;
2262: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2263: p_count => x_msg_count ,
2264: p_data => x_msg_data );
2265:
2266: