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_CAMP_PVT dependencies on FND_API

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

101: (p_api_version_number IN NUMBER,
102: p_init_msg_list IN VARCHAR2,
103: p_application_id IN NUMBER,
104: p_party_id IN NUMBER,
105: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
106: p_currency_code IN VARCHAR2 := NULL,
107: p_offer_lst IN JTF_NUMBER_TABLE,
108: p_org_id IN NUMBER,
109: p_max_ret_num IN NUMBER,

Line 139: IF NOT FND_API.Compatible_API_Call( l_api_version,

135:
136: BEGIN
137:
138: -- Standard call to check for call compatibility.
139: IF NOT FND_API.Compatible_API_Call( l_api_version,
140: p_api_version_number,
141: l_api_name,
142: G_PKG_NAME )
143: THEN

Line 144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

140: p_api_version_number,
141: l_api_name,
142: G_PKG_NAME )
143: THEN
144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
145: END IF;
146:
147: -- Initialize message list if p_init_msg_list is set to TRUE.
148: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 148: IF FND_API.to_Boolean( p_init_msg_list ) THEN

144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
145: END IF;
146:
147: -- Initialize message list if p_init_msg_list is set to TRUE.
148: IF FND_API.to_Boolean( p_init_msg_list ) THEN
149: FND_MSG_PUB.initialize;
150: END IF;
151:
152: -- Initialize API return status to success

Line 153: x_return_status := FND_API.G_RET_STS_SUCCESS;

149: FND_MSG_PUB.initialize;
150: END IF;
151:
152: -- Initialize API return status to success
153: x_return_status := FND_API.G_RET_STS_SUCCESS;
154:
155:
156: IF (AMS_DEBUG_HIGH_ON) THEN
157: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getFilteredOfferIds starts');

Line 186: WHEN FND_API.G_EXC_ERROR THEN

182: END IF;
183:
184: EXCEPTION
185:
186: WHEN FND_API.G_EXC_ERROR THEN
187: x_return_status := FND_API.G_RET_STS_ERROR;
188: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
189: p_count => x_msg_count,
190: p_data => x_msg_data);

Line 187: x_return_status := FND_API.G_RET_STS_ERROR;

183:
184: EXCEPTION
185:
186: WHEN FND_API.G_EXC_ERROR THEN
187: x_return_status := FND_API.G_RET_STS_ERROR;
188: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
189: p_count => x_msg_count,
190: p_data => x_msg_data);
191:

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

184: EXCEPTION
185:
186: WHEN FND_API.G_EXC_ERROR THEN
187: x_return_status := FND_API.G_RET_STS_ERROR;
188: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
189: p_count => x_msg_count,
190: p_data => x_msg_data);
191:
192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

188: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
189: p_count => x_msg_count,
190: p_data => x_msg_data);
191:
192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
194: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
195: p_count => x_msg_count,
196: p_data => x_msg_data);

Line 193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

189: p_count => x_msg_count,
190: p_data => x_msg_data);
191:
192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
194: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
195: p_count => x_msg_count,
196: p_data => x_msg_data);
197:

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

190: p_data => x_msg_data);
191:
192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
194: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
195: p_count => x_msg_count,
196: p_data => x_msg_data);
197:
198: WHEN OTHERS THEN

Line 199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

195: p_count => x_msg_count,
196: p_data => x_msg_data);
197:
198: WHEN OTHERS THEN
199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
200: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
201: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
202: END IF;
203: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
200: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
201: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
202: END IF;
203: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
204: p_count => x_msg_count,
205: p_data => x_msg_data);
206:
207: END getFilteredOfferIds;

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

212: (p_api_version_number IN NUMBER,
213: p_init_msg_list IN VARCHAR2,
214: p_application_id IN NUMBER,
215: p_party_id IN NUMBER,
216: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
217: p_sched_lst IN JTF_NUMBER_TABLE,
218: p_org_id IN NUMBER,
219: p_bus_prior IN VARCHAR2 := NULL,
220: p_bus_prior_order IN VARCHAR2 := NULL,

Line 347: IF NOT FND_API.Compatible_API_Call( l_api_version,

343: l_sched_lst2 JTF_Number_Table;
344:
345: BEGIN
346: -- Standard call to check for call compatibility.
347: IF NOT FND_API.Compatible_API_Call( l_api_version,
348: p_api_version_number,
349: l_api_name,
350: G_PKG_NAME )
351: THEN

Line 352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

348: p_api_version_number,
349: l_api_name,
350: G_PKG_NAME )
351: THEN
352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
353: END IF;
354:
355: -- Initialize message list if p_init_msg_list is set to TRUE.
356: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 356: IF FND_API.to_Boolean( p_init_msg_list ) THEN

352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
353: END IF;
354:
355: -- Initialize message list if p_init_msg_list is set to TRUE.
356: IF FND_API.to_Boolean( p_init_msg_list ) THEN
357: FND_MSG_PUB.initialize;
358: END IF;
359:
360: -- Initialize API return status to success

Line 361: x_return_status := FND_API.G_RET_STS_SUCCESS;

357: FND_MSG_PUB.initialize;
358: END IF;
359:
360: -- Initialize API return status to success
361: x_return_status := FND_API.G_RET_STS_SUCCESS;
362:
363: IF (AMS_DEBUG_HIGH_ON) THEN
364: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getFilteredSchedulesFromList starts '||p_party_id);
365: END IF;

Line 369: x_return_status := FND_API.G_RET_STS_ERROR;

365: END IF;
366:
367: IF(p_max_ret_num IS NULL) THEN
368: --max return no is null
369: x_return_status := FND_API.G_RET_STS_ERROR;
370: RAISE FND_API.G_EXC_ERROR;
371: END IF;
372:
373: -- Initialize the return value table

Line 370: RAISE FND_API.G_EXC_ERROR;

366:
367: IF(p_max_ret_num IS NULL) THEN
368: --max return no is null
369: x_return_status := FND_API.G_RET_STS_ERROR;
370: RAISE FND_API.G_EXC_ERROR;
371: END IF;
372:
373: -- Initialize the return value table
374: x_sched_lst := JTF_Number_Table();

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

539:
540: END IF;
541:
542: -- Standard call to get message count and if count is 1, get message info.
543: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
544: p_count => x_msg_count ,
545: p_data => x_msg_data );
546:
547: EXCEPTION

Line 548: WHEN FND_API.G_EXC_ERROR THEN

544: p_count => x_msg_count ,
545: p_data => x_msg_data );
546:
547: EXCEPTION
548: WHEN FND_API.G_EXC_ERROR THEN
549: x_return_status := FND_API.G_RET_STS_ERROR;
550: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
551: p_count => x_msg_count ,
552: p_data => x_msg_data );

Line 549: x_return_status := FND_API.G_RET_STS_ERROR;

545: p_data => x_msg_data );
546:
547: EXCEPTION
548: WHEN FND_API.G_EXC_ERROR THEN
549: x_return_status := FND_API.G_RET_STS_ERROR;
550: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
551: p_count => x_msg_count ,
552: p_data => x_msg_data );
553:

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

546:
547: EXCEPTION
548: WHEN FND_API.G_EXC_ERROR THEN
549: x_return_status := FND_API.G_RET_STS_ERROR;
550: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
551: p_count => x_msg_count ,
552: p_data => x_msg_data );
553:
554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

550: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
551: p_count => x_msg_count ,
552: p_data => x_msg_data );
553:
554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
556: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
557: p_count => x_msg_count ,
558: p_data => x_msg_data );

Line 555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

551: p_count => x_msg_count ,
552: p_data => x_msg_data );
553:
554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
556: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
557: p_count => x_msg_count ,
558: p_data => x_msg_data );
559:

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

552: p_data => x_msg_data );
553:
554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
556: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
557: p_count => x_msg_count ,
558: p_data => x_msg_data );
559:
560:

Line 562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

558: p_data => x_msg_data );
559:
560:
561: WHEN OTHERS THEN
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
563:
564: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
565: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
566: l_api_name );

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

564: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
565: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
566: l_api_name );
567: END IF;
568: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
569: p_count => x_msg_count ,
570: p_data => x_msg_data );
571:
572: END getFilteredSchedulesFromList;

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

577: (p_api_version_number IN NUMBER,
578: p_init_msg_list IN VARCHAR2,
579: p_application_id IN NUMBER,
580: p_party_id IN NUMBER,
581: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
582: p_currency_code IN VARCHAR2 := NULL,
583: p_quote_id IN NUMBER,
584: p_msite_id IN NUMBER,
585: p_top_section_id IN NUMBER,

Line 721: IF NOT FND_API.Compatible_API_Call( l_api_version,

717:
718:
719: BEGIN
720: -- Standard call to check for call compatibility.
721: IF NOT FND_API.Compatible_API_Call( l_api_version,
722: p_api_version_number,
723: l_api_name,
724: G_PKG_NAME )
725: THEN

Line 726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

722: p_api_version_number,
723: l_api_name,
724: G_PKG_NAME )
725: THEN
726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
727: END IF;
728:
729: -- Initialize message list if p_init_msg_list is set to TRUE.
730: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 730: IF FND_API.to_Boolean( p_init_msg_list ) THEN

726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
727: END IF;
728:
729: -- Initialize message list if p_init_msg_list is set to TRUE.
730: IF FND_API.to_Boolean( p_init_msg_list ) THEN
731: FND_MSG_PUB.initialize;
732: END IF;
733:
734: -- Initialize API return status to success

Line 735: x_return_status := FND_API.G_RET_STS_SUCCESS;

731: FND_MSG_PUB.initialize;
732: END IF;
733:
734: -- Initialize API return status to success
735: x_return_status := FND_API.G_RET_STS_SUCCESS;
736:
737: IF (AMS_DEBUG_HIGH_ON) THEN
738:
739:

Line 747: x_return_status := FND_API.G_RET_STS_ERROR;

743: END IF;
744:
745: IF(p_max_ret_num IS NULL) THEN
746: --max return no is null
747: x_return_status := FND_API.G_RET_STS_ERROR;
748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
749: END IF;
750:
751: IF(p_bus_prior <> 'RANDOM') THEN

Line 748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

744:
745: IF(p_max_ret_num IS NULL) THEN
746: --max return no is null
747: x_return_status := FND_API.G_RET_STS_ERROR;
748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
749: END IF;
750:
751: IF(p_bus_prior <> 'RANDOM') THEN
752: l_bus_prior := p_bus_prior;

Line 767: FND_API.G_FALSE,

763: ELSE
764:
765: AMS_RUNTIME_PROD_PVT.getRelProdsForQuoteAndCust(
766: p_api_version_number,
767: FND_API.G_FALSE,
768: p_application_id,
769: p_party_id,
770: p_cust_account_id,
771: p_currency_code,

Line 788: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

784: x_msg_count,
785: x_msg_data);
786: END IF;
787:
788: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
789: IF (AMS_DEBUG_HIGH_ON) THEN
790:
791: AMS_UTILITY_PVT.debug_message('Problem in AMS_RUNTIME_PROD_PVT.getRelProdsForQuoteAndCust');
792: END IF;

Line 793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

789: IF (AMS_DEBUG_HIGH_ON) THEN
790:
791: AMS_UTILITY_PVT.debug_message('Problem in AMS_RUNTIME_PROD_PVT.getRelProdsForQuoteAndCust');
792: END IF;
793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
794: END IF;
795:
796: IF l_quote_prod_lst.COUNT = 0 THEN
797: IF (AMS_DEBUG_HIGH_ON) THEN

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

803: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelSchedulesForQuoteAndCust ends');
804: END IF;
805:
806: -- Standard call to get message count and if count is 1, get message info.
807: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
808: p_count => x_msg_count ,
809: p_data => x_msg_data );
810: return;
811: END IF;

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

924:
925: END IF;
926:
927: -- Standard call to get message count and if count is 1, get message info.
928: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
929: p_count => x_msg_count ,
930: p_data => x_msg_data );
931:
932: EXCEPTION

Line 933: WHEN FND_API.G_EXC_ERROR THEN

929: p_count => x_msg_count ,
930: p_data => x_msg_data );
931:
932: EXCEPTION
933: WHEN FND_API.G_EXC_ERROR THEN
934: x_return_status := FND_API.G_RET_STS_ERROR;
935: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
936: p_count => x_msg_count ,
937: p_data => x_msg_data );

Line 934: x_return_status := FND_API.G_RET_STS_ERROR;

930: p_data => x_msg_data );
931:
932: EXCEPTION
933: WHEN FND_API.G_EXC_ERROR THEN
934: x_return_status := FND_API.G_RET_STS_ERROR;
935: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
936: p_count => x_msg_count ,
937: p_data => x_msg_data );
938:

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

931:
932: EXCEPTION
933: WHEN FND_API.G_EXC_ERROR THEN
934: x_return_status := FND_API.G_RET_STS_ERROR;
935: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
936: p_count => x_msg_count ,
937: p_data => x_msg_data );
938:
939: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 939: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

935: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
936: p_count => x_msg_count ,
937: p_data => x_msg_data );
938:
939: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
941: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
942: p_count => x_msg_count ,
943: p_data => x_msg_data );

Line 940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

936: p_count => x_msg_count ,
937: p_data => x_msg_data );
938:
939: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
941: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
942: p_count => x_msg_count ,
943: p_data => x_msg_data );
944:

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

937: p_data => x_msg_data );
938:
939: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
941: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
942: p_count => x_msg_count ,
943: p_data => x_msg_data );
944:
945:

Line 947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

943: p_data => x_msg_data );
944:
945:
946: WHEN OTHERS THEN
947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
948:
949: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
950: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
951: l_api_name );

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

949: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
950: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
951: l_api_name );
952: END IF;
953: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
954: p_count => x_msg_count ,
955: p_data => x_msg_data );
956:
957: END getRelSchedulesForQuoteAndCust;

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

962: (p_api_version_number IN NUMBER,
963: p_init_msg_list IN VARCHAR2,
964: p_application_id IN NUMBER,
965: p_party_id IN NUMBER,
966: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
967: p_currency_code IN VARCHAR2 := NULL,
968: p_prod_lst IN JTF_NUMBER_TABLE,
969: p_msite_id IN NUMBER,
970: p_top_section_id IN NUMBER,

Line 1107: IF NOT FND_API.Compatible_API_Call( l_api_version,

1103: order_items_in_clause1 VARCHAR2(38);
1104:
1105: BEGIN
1106: -- Standard call to check for call compatibility.
1107: IF NOT FND_API.Compatible_API_Call( l_api_version,
1108: p_api_version_number,
1109: l_api_name,
1110: G_PKG_NAME )
1111: THEN

Line 1112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1108: p_api_version_number,
1109: l_api_name,
1110: G_PKG_NAME )
1111: THEN
1112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1113: END IF;
1114:
1115: -- Initialize message list if p_init_msg_list is set to TRUE.
1116: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1116: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1113: END IF;
1114:
1115: -- Initialize message list if p_init_msg_list is set to TRUE.
1116: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1117: FND_MSG_PUB.initialize;
1118: END IF;
1119:
1120: -- Initialize API return status to success

Line 1121: x_return_status := FND_API.G_RET_STS_SUCCESS;

1117: FND_MSG_PUB.initialize;
1118: END IF;
1119:
1120: -- Initialize API return status to success
1121: x_return_status := FND_API.G_RET_STS_SUCCESS;
1122:
1123: IF (AMS_DEBUG_HIGH_ON) THEN
1124:
1125:

Line 1133: x_return_status := FND_API.G_RET_STS_ERROR;

1129: END IF;
1130:
1131: IF(p_max_ret_num IS NULL) THEN
1132: --max return no is null
1133: x_return_status := FND_API.G_RET_STS_ERROR;
1134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1135: END IF;
1136:
1137: IF(p_bus_prior <> 'RANDOM') THEN

Line 1134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1130:
1131: IF(p_max_ret_num IS NULL) THEN
1132: --max return no is null
1133: x_return_status := FND_API.G_RET_STS_ERROR;
1134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1135: END IF;
1136:
1137: IF(p_bus_prior <> 'RANDOM') THEN
1138: l_bus_prior := p_bus_prior;

Line 1150: FND_API.G_FALSE,

1146: ELSE
1147:
1148: AMS_RUNTIME_PROD_PVT.getRelProdsForProdAndCust(
1149: p_api_version_number,
1150: FND_API.G_FALSE,
1151: p_application_id,
1152: p_party_id,
1153: p_cust_account_id,
1154: p_currency_code,

Line 1171: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1167: x_msg_count,
1168: x_msg_data);
1169: END IF;
1170:
1171: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1172: IF (AMS_DEBUG_HIGH_ON) THEN
1173:
1174: AMS_UTILITY_PVT.debug_message('Problem in AMS_RUNTIME_PROD_PVT.getRelProdsForProdAndCust');
1175: END IF;

Line 1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1172: IF (AMS_DEBUG_HIGH_ON) THEN
1173:
1174: AMS_UTILITY_PVT.debug_message('Problem in AMS_RUNTIME_PROD_PVT.getRelProdsForProdAndCust');
1175: END IF;
1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1177: END IF;
1178:
1179: IF l_prod_lst.COUNT = 0 THEN
1180: IF (AMS_DEBUG_HIGH_ON) THEN

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

1186: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelSchedulesForProdAndCust ends');
1187: END IF;
1188:
1189: -- Standard call to get message count and if count is 1, get message info.
1190: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1191: p_count => x_msg_count ,
1192: p_data => x_msg_data );
1193: return;
1194: END IF;

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

1365:
1366: END IF;
1367:
1368: -- Standard call to get message count and if count is 1, get message info.
1369: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1370: p_count => x_msg_count,
1371: p_data => x_msg_data);
1372:
1373: EXCEPTION

Line 1374: WHEN FND_API.G_EXC_ERROR THEN

1370: p_count => x_msg_count,
1371: p_data => x_msg_data);
1372:
1373: EXCEPTION
1374: WHEN FND_API.G_EXC_ERROR THEN
1375: x_return_status := FND_API.G_RET_STS_ERROR;
1376: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1377: p_count => x_msg_count,
1378: p_data => x_msg_data);

Line 1375: x_return_status := FND_API.G_RET_STS_ERROR;

1371: p_data => x_msg_data);
1372:
1373: EXCEPTION
1374: WHEN FND_API.G_EXC_ERROR THEN
1375: x_return_status := FND_API.G_RET_STS_ERROR;
1376: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1377: p_count => x_msg_count,
1378: p_data => x_msg_data);
1379:

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

1372:
1373: EXCEPTION
1374: WHEN FND_API.G_EXC_ERROR THEN
1375: x_return_status := FND_API.G_RET_STS_ERROR;
1376: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1377: p_count => x_msg_count,
1378: p_data => x_msg_data);
1379:
1380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1376: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1377: p_count => x_msg_count,
1378: p_data => x_msg_data);
1379:
1380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1382: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1383: p_count => x_msg_count,
1384: p_data => x_msg_data);

Line 1381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1377: p_count => x_msg_count,
1378: p_data => x_msg_data);
1379:
1380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1382: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1383: p_count => x_msg_count,
1384: p_data => x_msg_data);
1385:

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

1378: p_data => x_msg_data);
1379:
1380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1382: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1383: p_count => x_msg_count,
1384: p_data => x_msg_data);
1385:
1386:

Line 1388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1384: p_data => x_msg_data);
1385:
1386:
1387: WHEN OTHERS THEN
1388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1389:
1390: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1391: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1392: END IF;

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

1390: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1391: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1392: END IF;
1393:
1394: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1395: p_count => x_msg_count,
1396: p_data => x_msg_data);
1397:
1398: END getRelSchedulesForProdAndCust;

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

1402: (p_api_version_number IN NUMBER,
1403: p_init_msg_list IN VARCHAR2,
1404: p_application_id IN NUMBER,
1405: p_party_id IN NUMBER,
1406: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
1407: p_currency_code IN VARCHAR2 := NULL,
1408: p_offer_lst IN JTF_NUMBER_TABLE,
1409: p_org_id IN NUMBER,
1410: p_bus_prior IN VARCHAR2 := NULL,

Line 1478: IF NOT FND_API.Compatible_API_Call( l_api_version,

1474: l_qp_rec_type_tbl AMS_RUNTIME_CAMP_PVT.qp_rec_type_tbl;
1475:
1476: BEGIN
1477: -- Standard call to check for call compatibility.
1478: IF NOT FND_API.Compatible_API_Call( l_api_version,
1479: p_api_version_number,
1480: l_api_name,
1481: G_PKG_NAME )
1482: THEN

Line 1483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1479: p_api_version_number,
1480: l_api_name,
1481: G_PKG_NAME )
1482: THEN
1483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1484: END IF;
1485:
1486: -- Initialize message list if p_init_msg_list is set to TRUE.
1487: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1487: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1484: END IF;
1485:
1486: -- Initialize message list if p_init_msg_list is set to TRUE.
1487: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1488: FND_MSG_PUB.initialize;
1489: END IF;
1490:
1491: -- Initialize API return status to success

Line 1492: x_return_status := FND_API.G_RET_STS_SUCCESS;

1488: FND_MSG_PUB.initialize;
1489: END IF;
1490:
1491: -- Initialize API return status to success
1492: x_return_status := FND_API.G_RET_STS_SUCCESS;
1493:
1494:
1495: IF (AMS_DEBUG_HIGH_ON) THEN
1496: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getFilteredOffersFromList starts');

Line 1504: x_return_status := FND_API.G_RET_STS_ERROR;

1500: -- Validation on the required parameters
1501:
1502: IF (p_party_id is NULL) THEN
1503: -- party id is null
1504: x_return_status := FND_API.G_RET_STS_ERROR;
1505: RAISE FND_API.G_EXC_ERROR;
1506: ELSE
1507: l_party_id := p_party_id;
1508: END IF;

Line 1505: RAISE FND_API.G_EXC_ERROR;

1501:
1502: IF (p_party_id is NULL) THEN
1503: -- party id is null
1504: x_return_status := FND_API.G_RET_STS_ERROR;
1505: RAISE FND_API.G_EXC_ERROR;
1506: ELSE
1507: l_party_id := p_party_id;
1508: END IF;
1509:

Line 1514: x_return_status := FND_API.G_RET_STS_ERROR;

1510:
1511:
1512: IF (p_offer_lst.count = 0) THEN
1513: -- Offer ids is 0
1514: x_return_status := FND_API.G_RET_STS_ERROR;
1515: RAISE FND_API.G_EXC_ERROR;
1516: ELSE
1517: getFilteredOfferIds (p_api_version_number,
1518: p_init_msg_list,

Line 1515: RAISE FND_API.G_EXC_ERROR;

1511:
1512: IF (p_offer_lst.count = 0) THEN
1513: -- Offer ids is 0
1514: x_return_status := FND_API.G_RET_STS_ERROR;
1515: RAISE FND_API.G_EXC_ERROR;
1516: ELSE
1517: getFilteredOfferIds (p_api_version_number,
1518: p_init_msg_list,
1519: p_application_id,

Line 1536: x_return_status := FND_API.G_RET_STS_ERROR;

1532:
1533:
1534: IF (x_offer_qp_lst.count = 0) THEN
1535: -- Offer ids is 0
1536: x_return_status := FND_API.G_RET_STS_ERROR;
1537: RAISE FND_API.G_EXC_ERROR;
1538: ELSE
1539:
1540: -- convert user defined TABLE to num_tbl_type

Line 1537: RAISE FND_API.G_EXC_ERROR;

1533:
1534: IF (x_offer_qp_lst.count = 0) THEN
1535: -- Offer ids is 0
1536: x_return_status := FND_API.G_RET_STS_ERROR;
1537: RAISE FND_API.G_EXC_ERROR;
1538: ELSE
1539:
1540: -- convert user defined TABLE to num_tbl_type
1541:

Line 1564: p_init_msg_list => FND_API.G_FALSE,

1560: p_party_id => l_party_id,
1561: p_cust_acct_id => l_cust_account_id,
1562: p_cust_site_id => NULL,
1563: p_api_version => 1.0,
1564: p_init_msg_list => FND_API.G_FALSE,
1565: p_commit => FND_API.G_FALSE,
1566: x_return_status => x_return_status,
1567: x_msg_count => x_msg_count,
1568: x_msg_data => x_msg_data ,

Line 1565: p_commit => FND_API.G_FALSE,

1561: p_cust_acct_id => l_cust_account_id,
1562: p_cust_site_id => NULL,
1563: p_api_version => 1.0,
1564: p_init_msg_list => FND_API.G_FALSE,
1565: p_commit => FND_API.G_FALSE,
1566: x_return_status => x_return_status,
1567: x_msg_count => x_msg_count,
1568: x_msg_data => x_msg_data ,
1569: x_offers_tbl => x_offers_tbl

Line 1580: p_init_msg_list => FND_API.G_FALSE,

1576: p_party_id => l_party_id,
1577: p_cust_acct_id => l_cust_account_id,
1578: p_cust_site_id => NULL,
1579: p_api_version => 1.0,
1580: p_init_msg_list => FND_API.G_FALSE,
1581: p_commit => FND_API.G_FALSE,
1582: x_return_status => x_return_status,
1583: x_msg_count => x_msg_count,
1584: x_msg_data => x_msg_data ,

Line 1581: p_commit => FND_API.G_FALSE,

1577: p_cust_acct_id => l_cust_account_id,
1578: p_cust_site_id => NULL,
1579: p_api_version => 1.0,
1580: p_init_msg_list => FND_API.G_FALSE,
1581: p_commit => FND_API.G_FALSE,
1582: x_return_status => x_return_status,
1583: x_msg_count => x_msg_count,
1584: x_msg_data => x_msg_data ,
1585: x_offers_tbl => x_offers_tbl

Line 1591: IF NOT FND_API.Compatible_API_Call( l_api_version,

1587:
1588:
1589: -- Standard call to check for call compatibility.
1590:
1591: IF NOT FND_API.Compatible_API_Call( l_api_version,
1592: p_api_version_number,
1593: l_api_name,
1594: G_PKG_NAME )
1595: THEN

Line 1596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1592: p_api_version_number,
1593: l_api_name,
1594: G_PKG_NAME )
1595: THEN
1596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1597: END IF;
1598:
1599:
1600: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1600: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1597: END IF;
1598:
1599:
1600: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1601: IF (AMS_DEBUG_HIGH_ON) THEN
1602:
1603: --AMS_UTILITY_PVT.debug_message('Problem in AMS_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig');
1604: AMS_UTILITY_PVT.debug_message('Problem in OZF_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig');

Line 1606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1602:
1603: --AMS_UTILITY_PVT.debug_message('Problem in AMS_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig');
1604: AMS_UTILITY_PVT.debug_message('Problem in OZF_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig');
1605: END IF;
1606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1607: END IF;
1608:
1609: x_return_status := FND_API.g_ret_sts_success;
1610:

Line 1609: x_return_status := FND_API.g_ret_sts_success;

1605: END IF;
1606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1607: END IF;
1608:
1609: x_return_status := FND_API.g_ret_sts_success;
1610:
1611: l_offer_lst := JTF_NUMBER_TABLE();
1612:
1613: l_in_offer_lst := JTF_NUMBER_TABLE();

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

1623: AMS_UTILITY_PVT.debug_message('OZF_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig ends');
1624: END IF;
1625:
1626: -- Standard call to get message count and if count is 1, get message info.
1627: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1628: p_count => x_msg_count ,
1629: p_data => x_msg_data );
1630:
1631: return;

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

1820: END IF;
1821:
1822: -- Standard call to get message count and if count is 1, get message info.
1823:
1824: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1825: p_count => x_msg_count,
1826: p_data => x_msg_data);
1827:
1828: EXCEPTION

Line 1830: WHEN FND_API.G_EXC_ERROR THEN

1826: p_data => x_msg_data);
1827:
1828: EXCEPTION
1829:
1830: WHEN FND_API.G_EXC_ERROR THEN
1831: x_return_status := FND_API.G_RET_STS_ERROR;
1832: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1833: p_count => x_msg_count,
1834: p_data => x_msg_data);

Line 1831: x_return_status := FND_API.G_RET_STS_ERROR;

1827:
1828: EXCEPTION
1829:
1830: WHEN FND_API.G_EXC_ERROR THEN
1831: x_return_status := FND_API.G_RET_STS_ERROR;
1832: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1833: p_count => x_msg_count,
1834: p_data => x_msg_data);
1835:

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

1828: EXCEPTION
1829:
1830: WHEN FND_API.G_EXC_ERROR THEN
1831: x_return_status := FND_API.G_RET_STS_ERROR;
1832: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1833: p_count => x_msg_count,
1834: p_data => x_msg_data);
1835:
1836:

Line 1837: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1833: p_count => x_msg_count,
1834: p_data => x_msg_data);
1835:
1836:
1837: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1839: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1840: p_count => x_msg_count,
1841: p_data => x_msg_data);

Line 1838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1834: p_data => x_msg_data);
1835:
1836:
1837: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1839: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1840: p_count => x_msg_count,
1841: p_data => x_msg_data);
1842:

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

1835:
1836:
1837: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1839: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1840: p_count => x_msg_count,
1841: p_data => x_msg_data);
1842:
1843:

Line 1845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1841: p_data => x_msg_data);
1842:
1843:
1844: WHEN OTHERS THEN
1845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1846:
1847: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1848: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1849: l_api_name);

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

1847: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1848: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1849: l_api_name);
1850: END IF;
1851: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1852: p_count => x_msg_count,
1853: p_data => x_msg_data);
1854:
1855: END getFilteredOffersFromList;

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

1860: (p_api_version_number IN NUMBER,
1861: p_init_msg_list IN VARCHAR2,
1862: p_application_id IN NUMBER,
1863: p_party_id IN NUMBER,
1864: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
1865: p_currency_code IN VARCHAR2 := NULL,
1866: p_quote_id IN NUMBER,
1867: p_msite_id IN NUMBER,
1868: p_top_section_id IN NUMBER,

Line 1945: IF NOT FND_API.Compatible_API_Call( l_api_version,

1941: l_qp_rec_type AMS_RUNTIME_CAMP_PVT.qp_rec_type;
1942:
1943: BEGIN
1944: -- Standard call to check for call compatibility.
1945: IF NOT FND_API.Compatible_API_Call( l_api_version,
1946: p_api_version_number,
1947: l_api_name,
1948: G_PKG_NAME )
1949: THEN

Line 1950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1946: p_api_version_number,
1947: l_api_name,
1948: G_PKG_NAME )
1949: THEN
1950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1951: END IF;
1952:
1953: -- Initialize message list if p_init_msg_list is set to TRUE.
1954: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1954: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1951: END IF;
1952:
1953: -- Initialize message list if p_init_msg_list is set to TRUE.
1954: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1955: FND_MSG_PUB.initialize;
1956: END IF;
1957:
1958: -- Initialize API return status to success

Line 1959: x_return_status := FND_API.G_RET_STS_SUCCESS;

1955: FND_MSG_PUB.initialize;
1956: END IF;
1957:
1958: -- Initialize API return status to success
1959: x_return_status := FND_API.G_RET_STS_SUCCESS;
1960:
1961: IF (AMS_DEBUG_HIGH_ON) THEN
1962:
1963: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelOffersForQuoteAndCust starts');

Line 1969: x_return_status := FND_API.G_RET_STS_ERROR;

1965: END IF;
1966:
1967: IF(p_max_ret_num IS NULL) THEN
1968: --max return no is null
1969: x_return_status := FND_API.G_RET_STS_ERROR;
1970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1971: END IF;
1972:
1973: IF(p_bus_prior <> 'RANDOM') THEN

Line 1970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1966:
1967: IF(p_max_ret_num IS NULL) THEN
1968: --max return no is null
1969: x_return_status := FND_API.G_RET_STS_ERROR;
1970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1971: END IF;
1972:
1973: IF(p_bus_prior <> 'RANDOM') THEN
1974: l_bus_prior := p_bus_prior;

Line 1987: FND_API.G_FALSE,

1983: where quote_header_id = p_quote_id;
1984: ELSE
1985: AMS_RUNTIME_PROD_PVT.getRelProdsForQuoteAndCust(
1986: p_api_version_number,
1987: FND_API.G_FALSE,
1988: p_application_id,
1989: p_party_id,
1990: p_cust_account_id,
1991: p_currency_code,

Line 2008: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2004: x_msg_count,
2005: x_msg_data);
2006: END IF;
2007:
2008: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2009: IF (AMS_DEBUG_HIGH_ON) THEN
2010: AMS_UTILITY_PVT.debug_message('Problem in AMS_RUNTIME_PROD_PVT.getRelProdsForQuoteAndCust');
2011: END IF;
2012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2008: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2009: IF (AMS_DEBUG_HIGH_ON) THEN
2010: AMS_UTILITY_PVT.debug_message('Problem in AMS_RUNTIME_PROD_PVT.getRelProdsForQuoteAndCust');
2011: END IF;
2012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2013: END IF;
2014:
2015: IF l_quote_prod_lst.COUNT = 0 THEN
2016: IF (AMS_DEBUG_HIGH_ON) THEN

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

2020: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelSchedulesForQuoteAndCust ends');
2021: END IF;
2022:
2023: -- Standard call to get message count and if count is 1, get message info.
2024: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2025: p_count => x_msg_count,
2026: p_data => x_msg_data);
2027: return;
2028: ELSE

Line 2044: FND_API.G_FALSE, --p_init_msg_list

2040: p_party_id,
2041: p_cust_account_id,
2042: NULL, --p_cust_site_id
2043: l_api_version,
2044: FND_API.G_FALSE, --p_init_msg_list
2045: FND_API.G_FALSE, --p_commit
2046: x_return_status,
2047: x_msg_count,
2048: x_msg_data,

Line 2045: FND_API.G_FALSE, --p_commit

2041: p_cust_account_id,
2042: NULL, --p_cust_site_id
2043: l_api_version,
2044: FND_API.G_FALSE, --p_init_msg_list
2045: FND_API.G_FALSE, --p_commit
2046: x_return_status,
2047: x_msg_count,
2048: x_msg_data,
2049: l_offer_tbl

Line 2058: FND_API.G_FALSE, --p_init_msg_list

2054: p_party_id,
2055: p_cust_account_id,
2056: NULL, --p_cust_site_id
2057: l_api_version,
2058: FND_API.G_FALSE, --p_init_msg_list
2059: FND_API.G_FALSE, --p_commit
2060: x_return_status,
2061: x_msg_count,
2062: x_msg_data,

Line 2059: FND_API.G_FALSE, --p_commit

2055: p_cust_account_id,
2056: NULL, --p_cust_site_id
2057: l_api_version,
2058: FND_API.G_FALSE, --p_init_msg_list
2059: FND_API.G_FALSE, --p_commit
2060: x_return_status,
2061: x_msg_count,
2062: x_msg_data,
2063: l_offer_tbl

Line 2066: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2062: x_msg_data,
2063: l_offer_tbl
2064: );
2065:
2066: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2067: IF (AMS_DEBUG_HIGH_ON) THEN
2068: --AMS_UTILITY_PVT.debug_message('Problem in AMS_OFFR_ELIG_PROD_DENORM_PVT.find_product_elig');
2069: AMS_UTILITY_PVT.debug_message('Problem in OZF_OFFR_ELIG_PROD_DENORM_PVT.find_product_elig');
2070: END IF;

Line 2071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2067: IF (AMS_DEBUG_HIGH_ON) THEN
2068: --AMS_UTILITY_PVT.debug_message('Problem in AMS_OFFR_ELIG_PROD_DENORM_PVT.find_product_elig');
2069: AMS_UTILITY_PVT.debug_message('Problem in OZF_OFFR_ELIG_PROD_DENORM_PVT.find_product_elig');
2070: END IF;
2071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2072: END IF;
2073: x_return_status := FND_API.G_RET_STS_SUCCESS;
2074: IF l_offer_tbl.COUNT = 0 THEN
2075: IF (AMS_DEBUG_HIGH_ON) THEN

Line 2073: x_return_status := FND_API.G_RET_STS_SUCCESS;

2069: AMS_UTILITY_PVT.debug_message('Problem in OZF_OFFR_ELIG_PROD_DENORM_PVT.find_product_elig');
2070: END IF;
2071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2072: END IF;
2073: x_return_status := FND_API.G_RET_STS_SUCCESS;
2074: IF l_offer_tbl.COUNT = 0 THEN
2075: IF (AMS_DEBUG_HIGH_ON) THEN
2076: AMS_UTILITY_PVT.debug_message('No Offers for the products being viewed');
2077: END IF;

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

2079: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelOffersForQuotAndCust ends');
2080: END IF;
2081:
2082: -- Standard call to get message count and if count is 1, get message info.
2083: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2084: p_count => x_msg_count,
2085: p_data => x_msg_data);
2086: RETURN;
2087:

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

2239:
2240: END IF;
2241:
2242: -- Standard call to get message count and if count is 1, get message info.
2243: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2244: p_count => x_msg_count,
2245: p_data => x_msg_data);
2246:
2247: EXCEPTION

Line 2248: WHEN FND_API.G_EXC_ERROR THEN

2244: p_count => x_msg_count,
2245: p_data => x_msg_data);
2246:
2247: EXCEPTION
2248: WHEN FND_API.G_EXC_ERROR THEN
2249: x_return_status := FND_API.G_RET_STS_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_ERROR;

2245: p_data => x_msg_data);
2246:
2247: EXCEPTION
2248: WHEN FND_API.G_EXC_ERROR THEN
2249: x_return_status := FND_API.G_RET_STS_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:
2247: EXCEPTION
2248: WHEN FND_API.G_EXC_ERROR THEN
2249: x_return_status := FND_API.G_RET_STS_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: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2256: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2257: p_count => x_msg_count,
2258: p_data => x_msg_data);

Line 2255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2251: p_count => x_msg_count,
2252: p_data => x_msg_data);
2253:
2254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2256: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2257: p_count => x_msg_count,
2258: p_data => x_msg_data);
2259:

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

2252: p_data => x_msg_data);
2253:
2254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2256: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2257: p_count => x_msg_count,
2258: p_data => x_msg_data);
2259:
2260: WHEN OTHERS THEN

Line 2261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2257: p_count => x_msg_count,
2258: p_data => x_msg_data);
2259:
2260: WHEN OTHERS THEN
2261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2262:
2263: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2264: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);
2265: END IF;

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

2262:
2263: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2264: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);
2265: END IF;
2266: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2267: p_count => x_msg_count,
2268: p_data => x_msg_data);
2269:
2270: END getRelOffersForQuoteAndCust;

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

2274: (p_api_version_number IN NUMBER,
2275: p_init_msg_list IN VARCHAR2,
2276: p_application_id IN NUMBER,
2277: p_party_id IN NUMBER,
2278: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
2279: p_currency_code IN VARCHAR2 := NULL,
2280: p_prod_lst IN JTF_NUMBER_TABLE,
2281: p_msite_id IN NUMBER,
2282: p_top_section_id IN NUMBER,

Line 2348: IF NOT FND_API.Compatible_API_Call( l_api_version,

2344:
2345: BEGIN
2346:
2347: -- Standard call to check for call compatibility.
2348: IF NOT FND_API.Compatible_API_Call( l_api_version,
2349: p_api_version_number,
2350: l_api_name,
2351: G_PKG_NAME )
2352: THEN

Line 2353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2349: p_api_version_number,
2350: l_api_name,
2351: G_PKG_NAME )
2352: THEN
2353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2354: END IF;
2355:
2356:
2357: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2358: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2354: END IF;
2355:
2356:
2357: -- Initialize message list if p_init_msg_list is set to TRUE.
2358: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2359: FND_MSG_PUB.initialize;
2360: END IF;
2361:
2362: -- Initialize API return status to success

Line 2363: x_return_status := FND_API.G_RET_STS_SUCCESS;

2359: FND_MSG_PUB.initialize;
2360: END IF;
2361:
2362: -- Initialize API return status to success
2363: x_return_status := FND_API.G_RET_STS_SUCCESS;
2364:
2365: IF (AMS_DEBUG_HIGH_ON) THEN
2366:
2367:

Line 2375: x_return_status := FND_API.G_RET_STS_ERROR;

2371: END IF;
2372:
2373: IF(p_max_ret_num IS NULL) THEN
2374: --max return no is null
2375: x_return_status := FND_API.G_RET_STS_ERROR;
2376: IF (AMS_DEBUG_HIGH_ON) THEN
2377:
2378: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelOffersForProdAndCust starts max ret null');
2379: END IF;

Line 2380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2376: IF (AMS_DEBUG_HIGH_ON) THEN
2377:
2378: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelOffersForProdAndCust starts max ret null');
2379: END IF;
2380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2381: END IF;
2382:
2383:
2384: -- CHANGED THE DATATYPE SAME AS LOCAL

Line 2397: FND_API.G_FALSE,

2393: l_prod_lst := p_prod_lst;
2394: ELSE
2395: AMS_RUNTIME_PROD_PVT.getRelProdsForProdAndCust(
2396: l_api_version,
2397: FND_API.G_FALSE,
2398: p_application_id,
2399: p_party_id,
2400: p_cust_account_id,
2401: p_currency_code,

Line 2421: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2417: END IF;
2418:
2419: -- May have to check if the p_max_ret_num is applied properly
2420:
2421: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2422: IF (AMS_DEBUG_HIGH_ON) THEN
2423:
2424: AMS_UTILITY_PVT.debug_message('Problem in AMS_RUNTIME_PROD_PVT.getRelProdsForProdAndCust');
2425: END IF;

Line 2426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2422: IF (AMS_DEBUG_HIGH_ON) THEN
2423:
2424: AMS_UTILITY_PVT.debug_message('Problem in AMS_RUNTIME_PROD_PVT.getRelProdsForProdAndCust');
2425: END IF;
2426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2427: END IF;
2428:
2429:
2430: IF l_prod_lst.COUNT = 0 THEN

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

2437: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelSchedulesForProdAndCust ends');
2438: END IF;
2439:
2440: -- Standard call to get message count and if count is 1, get message info.
2441: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2442: p_count => x_msg_count,
2443: p_data => x_msg_data);
2444: RETURN;
2445:

Line 2478: FND_API.G_FALSE, --p_init_msg_list

2474: p_party_id,
2475: p_cust_account_id,
2476: NULL, --p_cust_site_id
2477: l_api_version,
2478: FND_API.G_FALSE, --p_init_msg_list
2479: FND_API.G_FALSE, --p_commit
2480: x_return_status,
2481: x_msg_count,
2482: x_msg_data,

Line 2479: FND_API.G_FALSE, --p_commit

2475: p_cust_account_id,
2476: NULL, --p_cust_site_id
2477: l_api_version,
2478: FND_API.G_FALSE, --p_init_msg_list
2479: FND_API.G_FALSE, --p_commit
2480: x_return_status,
2481: x_msg_count,
2482: x_msg_data,
2483: l_offer_tbl

Line 2493: FND_API.G_FALSE, --p_init_msg_list

2489: p_party_id,
2490: p_cust_account_id,
2491: NULL, --p_cust_site_id
2492: l_api_version,
2493: FND_API.G_FALSE, --p_init_msg_list
2494: FND_API.G_FALSE, --p_commit
2495: x_return_status,
2496: x_msg_count,
2497: x_msg_data,

Line 2494: FND_API.G_FALSE, --p_commit

2490: p_cust_account_id,
2491: NULL, --p_cust_site_id
2492: l_api_version,
2493: FND_API.G_FALSE, --p_init_msg_list
2494: FND_API.G_FALSE, --p_commit
2495: x_return_status,
2496: x_msg_count,
2497: x_msg_data,
2498: l_offer_tbl

Line 2506: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2502: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelOffersForProdAndCust Get all the offer for the products ends find_product_elig');
2503: END IF;
2504:
2505:
2506: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2507: IF (AMS_DEBUG_HIGH_ON) THEN
2508:
2509: -- AMS_UTILITY_PVT.debug_message('Problem in AMS_OFFR_ELIG_PROD_DENORM_PVT.find_product_elig');
2510: AMS_UTILITY_PVT.debug_message('Problem in OZF_OFFR_ELIG_PROD_DENORM_PVT.find_product_elig');

Line 2512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2508:
2509: -- AMS_UTILITY_PVT.debug_message('Problem in AMS_OFFR_ELIG_PROD_DENORM_PVT.find_product_elig');
2510: AMS_UTILITY_PVT.debug_message('Problem in OZF_OFFR_ELIG_PROD_DENORM_PVT.find_product_elig');
2511: END IF;
2512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2513: END IF;
2514:
2515: x_return_status := FND_API.G_RET_STS_SUCCESS;
2516:

Line 2515: x_return_status := FND_API.G_RET_STS_SUCCESS;

2511: END IF;
2512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2513: END IF;
2514:
2515: x_return_status := FND_API.G_RET_STS_SUCCESS;
2516:
2517: IF l_offer_tbl.COUNT = 0 THEN
2518: IF (AMS_DEBUG_HIGH_ON) THEN
2519:

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

2528:
2529: END IF;
2530:
2531: -- Standard call to get message count and if count is 1, get message info.
2532: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2533: p_count => x_msg_count,
2534: p_data => x_msg_data);
2535: return;
2536:

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

2767:
2768: END IF;
2769:
2770: -- Standard call to get message count and if count is 1, get message info.
2771: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2772: p_count => x_msg_count,
2773: p_data => x_msg_data);
2774:
2775: EXCEPTION

Line 2777: WHEN FND_API.G_EXC_ERROR THEN

2773: p_data => x_msg_data);
2774:
2775: EXCEPTION
2776:
2777: WHEN FND_API.G_EXC_ERROR THEN
2778: x_return_status := FND_API.G_RET_STS_ERROR;
2779: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2780: p_count => x_msg_count,
2781: p_data => x_msg_data);

Line 2778: x_return_status := FND_API.G_RET_STS_ERROR;

2774:
2775: EXCEPTION
2776:
2777: WHEN FND_API.G_EXC_ERROR THEN
2778: x_return_status := FND_API.G_RET_STS_ERROR;
2779: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2780: p_count => x_msg_count,
2781: p_data => x_msg_data);
2782:

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

2775: EXCEPTION
2776:
2777: WHEN FND_API.G_EXC_ERROR THEN
2778: x_return_status := FND_API.G_RET_STS_ERROR;
2779: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2780: p_count => x_msg_count,
2781: p_data => x_msg_data);
2782:
2783: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2783: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2779: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2780: p_count => x_msg_count,
2781: p_data => x_msg_data);
2782:
2783: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2785: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2786: p_count => x_msg_count,
2787: p_data => x_msg_data);

Line 2784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2780: p_count => x_msg_count,
2781: p_data => x_msg_data);
2782:
2783: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2785: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2786: p_count => x_msg_count,
2787: p_data => x_msg_data);
2788:

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

2781: p_data => x_msg_data);
2782:
2783: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2785: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2786: p_count => x_msg_count,
2787: p_data => x_msg_data);
2788:
2789: WHEN OTHERS THEN

Line 2790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2786: p_count => x_msg_count,
2787: p_data => x_msg_data);
2788:
2789: WHEN OTHERS THEN
2790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2791:
2792: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2793: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2794: END IF;

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

2791:
2792: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2793: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2794: END IF;
2795: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2796: p_count => x_msg_count,
2797: p_data => x_msg_data);
2798:
2799: END getRelOffersForProdAndCust;