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.IBY_DISBURSEMENT_COMP_PUB dependencies on FND_MSG_PUB

Line 105: FND_MSG_PUB.initialize;

101: END IF;
102:
103: -- Initialize message list if p_init_msg_list is set to TRUE.
104: IF FND_API.to_Boolean(p_init_msg_list) THEN
105: FND_MSG_PUB.initialize;
106: END IF;
107:
108: -- Initialize API return status to success
109: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 115: FND_MSG_PUB.Add;

111: IF (p_trxn_attributes_rec.payer_legal_entity_id IS NULL) THEN
112: print_debuginfo(l_module_name,'Error: Mandatory Parameter ''First party legal entity Id'' missing.');
113: FND_MESSAGE.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
114: FND_MESSAGE.SET_TOKEN('PARAM', 'First party legal entity Id');
115: FND_MSG_PUB.Add;
116: RAISE FND_API.G_EXC_ERROR;
117: END IF;
118:
119: OPEN payer_country_csr(p_trxn_attributes_rec.payer_legal_entity_id);

Line 127: FND_MSG_PUB.Add;

123: IF (l_payer_country IS NULL) THEN
124: print_debuginfo(l_module_name,'Error: First party legal entity country not populated.');
125: FND_MESSAGE.set_name('IBY', 'IBY_MISSING_DATA');
126: FND_MESSAGE.SET_TOKEN('PARAM', 'First party legal entity country');
127: FND_MSG_PUB.Add;
128: RAISE FND_API.G_EXC_ERROR;
129: END IF;
130:
131: OPEN delivery_channels_csr(l_payer_country);

Line 145: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

141:
142: -- End of API body.
143:
144: -- Standard call to get message count and if count is 1, get message info.
145: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
146:
147: print_debuginfo(l_module_name, 'RETURN');
148:
149: EXCEPTION

Line 152: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

148:
149: EXCEPTION
150: WHEN FND_API.G_EXC_ERROR THEN
151: x_return_status := FND_API.G_RET_STS_ERROR;
152: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
153: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
154: print_debuginfo(l_module_name,'SQLerr is :'
155: || substr(SQLERRM, 1, 150));
156: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 158: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

154: print_debuginfo(l_module_name,'SQLerr is :'
155: || substr(SQLERRM, 1, 150));
156: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
158: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
159: print_debuginfo(l_module_name,'Unexpected ERROR: Exception occured during call to API ');
160: print_debuginfo(l_module_name,'SQLerr is :'
161: || substr(SQLERRM, 1, 150));
162: WHEN OTHERS THEN

Line 165: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

161: || substr(SQLERRM, 1, 150));
162: WHEN OTHERS THEN
163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
164:
165: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
166: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
167: END IF;
168: print_debuginfo(l_module_name,'Other ERROR: Exception occured during call to API ');
169: print_debuginfo(l_module_name,'SQLerr is :'

Line 166: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

162: WHEN OTHERS THEN
163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
164:
165: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
166: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
167: END IF;
168: print_debuginfo(l_module_name,'Other ERROR: Exception occured during call to API ');
169: print_debuginfo(l_module_name,'SQLerr is :'
170: || substr(SQLERRM, 1, 150));

Line 171: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

167: END IF;
168: print_debuginfo(l_module_name,'Other ERROR: Exception occured during call to API ');
169: print_debuginfo(l_module_name,'SQLerr is :'
170: || substr(SQLERRM, 1, 150));
171: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
172:
173: END Get_Appl_Delivery_Channels;
174:
175:

Line 277: FND_MSG_PUB.initialize;

273: END IF;
274:
275: -- Initialize message list if p_init_msg_list is set to TRUE.
276: IF FND_API.to_Boolean(p_init_msg_list) THEN
277: FND_MSG_PUB.initialize;
278: END IF;
279:
280: -- Initialize API return status to success
281: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 288: FND_MSG_PUB.Add;

284: IF (p_trxn_attributes_rec.payee_party_id IS NULL) THEN
285: print_debuginfo(l_module_name,'Error: Mandatory Parameter ''Payee Party Id'' missing.');
286: FND_MESSAGE.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
287: FND_MESSAGE.SET_TOKEN('PARAM', 'Payee Party Id');
288: FND_MSG_PUB.Add;
289: RAISE FND_API.G_EXC_ERROR;
290: END IF;
291:
292: IF (p_trxn_attributes_rec.payment_currency IS NULL) THEN

Line 296: FND_MSG_PUB.Add;

292: IF (p_trxn_attributes_rec.payment_currency IS NULL) THEN
293: print_debuginfo(l_module_name,'Error: Mandatory Parameter ''Payment Currency'' missing.');
294: FND_MESSAGE.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
295: FND_MESSAGE.SET_TOKEN('PARAM', 'Payment Currency');
296: FND_MSG_PUB.Add;
297: RAISE FND_API.G_EXC_ERROR;
298: END IF;
299:
300: IF (p_trxn_attributes_rec.payment_function IS NULL) THEN

Line 304: FND_MSG_PUB.Add;

300: IF (p_trxn_attributes_rec.payment_function IS NULL) THEN
301: print_debuginfo(l_module_name,'Error: Mandatory Parameter ''Account Usage'' missing.');
302: FND_MESSAGE.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
303: FND_MESSAGE.SET_TOKEN('PARAM', 'Account Usage');
304: FND_MSG_PUB.Add;
305: RAISE FND_API.G_EXC_ERROR;
306: END IF;
307:
308: -- Start of API body.

Line 330: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

326:
327: -- End of API body.
328:
329: -- Standard call to get message count and if count is 1, get message info.
330: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
331:
332: print_debuginfo(l_module_name, 'RETURN');
333:
334: EXCEPTION

Line 337: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

333:
334: EXCEPTION
335: WHEN FND_API.G_EXC_ERROR THEN
336: x_return_status := FND_API.G_RET_STS_ERROR;
337: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
338: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
339: print_debuginfo(l_module_name,'SQLerr is :'
340: || substr(SQLERRM, 1, 150));
341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 343: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

339: print_debuginfo(l_module_name,'SQLerr is :'
340: || substr(SQLERRM, 1, 150));
341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
343: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
344: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
345: print_debuginfo(l_module_name,'SQLerr is :'
346: || substr(SQLERRM, 1, 150));
347: WHEN OTHERS THEN

Line 350: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR))

346: || substr(SQLERRM, 1, 150));
347: WHEN OTHERS THEN
348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
349:
350: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR))
351: THEN
352: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
353: END IF;
354: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');

Line 352: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
349:
350: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR))
351: THEN
352: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
353: END IF;
354: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
355: print_debuginfo(l_module_name,'SQLerr is :'
356: || substr(SQLERRM, 1, 150));

Line 357: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

353: END IF;
354: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
355: print_debuginfo(l_module_name,'SQLerr is :'
356: || substr(SQLERRM, 1, 150));
357: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
358:
359: END Get_Applicable_Payee_BankAccts;
360:
361: -- Start of comments

Line 430: FND_MSG_PUB.initialize;

426: END IF;
427:
428: -- Initialize message list if p_init_msg_list is set to TRUE.
429: IF FND_API.to_Boolean(p_init_msg_list) THEN
430: FND_MSG_PUB.initialize;
431: END IF;
432:
433: -- Initialize API return status to success
434: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 452: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

448:
449: -- End of API body.
450:
451: -- Standard call to get message count and if count is 1, get message info.
452: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
453:
454: print_debuginfo(l_module_name, 'RETURN');
455:
456: EXCEPTION

Line 459: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

455:
456: EXCEPTION
457: WHEN FND_API.G_EXC_ERROR THEN
458: x_return_status := FND_API.G_RET_STS_ERROR;
459: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
460: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
461: print_debuginfo(l_module_name,'SQLerr is :'
462: || substr(SQLERRM, 1, 150));
463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 465: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

461: print_debuginfo(l_module_name,'SQLerr is :'
462: || substr(SQLERRM, 1, 150));
463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
465: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
466: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
467: print_debuginfo(l_module_name,'SQLerr is :'
468: || substr(SQLERRM, 1, 150));
469: WHEN OTHERS THEN

Line 472: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR))

468: || substr(SQLERRM, 1, 150));
469: WHEN OTHERS THEN
470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
471:
472: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR))
473: THEN
474: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
475: END IF;
476: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');

Line 474: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
471:
472: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR))
473: THEN
474: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
475: END IF;
476: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
477: print_debuginfo(l_module_name,'SQLerr is :'
478: || substr(SQLERRM, 1, 150));

Line 479: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

475: END IF;
476: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
477: print_debuginfo(l_module_name,'SQLerr is :'
478: || substr(SQLERRM, 1, 150));
479: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
480:
481: END Get_Applicable_Payment_Formats;
482:
483: -- Start of comments

Line 675: FND_MSG_PUB.initialize;

671: END IF;
672:
673: -- Initialize message list if p_init_msg_list is set to TRUE.
674: IF FND_API.to_Boolean(p_init_msg_list) THEN
675: FND_MSG_PUB.initialize;
676: END IF;
677:
678: -- Initialize API return status to success
679: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 686: FND_MSG_PUB.Add;

682: IF (p_trxn_attributes_rec.application_id IS NULL) THEN
683: print_debuginfo(l_module_name,'Error: Mandatory Parameter ''Application Id'' missing.');
684: FND_MESSAGE.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
685: FND_MESSAGE.SET_TOKEN('PARAM', 'Application Id');
686: FND_MSG_PUB.Add;
687: RAISE FND_API.G_EXC_ERROR;
688: END IF;
689:
690: IF (p_trxn_attributes_rec.payer_legal_entity_id IS NULL) THEN

Line 694: FND_MSG_PUB.Add;

690: IF (p_trxn_attributes_rec.payer_legal_entity_id IS NULL) THEN
691: print_debuginfo(l_module_name,'Error: Mandatory Parameter ''First party legal entity Id'' missing.');
692: FND_MESSAGE.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
693: FND_MESSAGE.SET_TOKEN('PARAM', 'First party legal entity Id');
694: FND_MSG_PUB.Add;
695: RAISE FND_API.G_EXC_ERROR;
696: END IF;
697:
698: IF (p_trxn_attributes_rec.payee_party_id IS NULL) THEN

Line 702: FND_MSG_PUB.Add;

698: IF (p_trxn_attributes_rec.payee_party_id IS NULL) THEN
699: print_debuginfo(l_module_name,'Error: Mandatory Parameter ''Payee Party Id'' missing.');
700: FND_MESSAGE.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
701: FND_MESSAGE.SET_TOKEN('PARAM', 'Payee Party Id');
702: FND_MSG_PUB.Add;
703: RAISE FND_API.G_EXC_ERROR;
704: END IF;
705:
706: IF (p_trxn_attributes_rec.pay_proc_trxn_type_code IS NULL) THEN

Line 710: FND_MSG_PUB.Add;

706: IF (p_trxn_attributes_rec.pay_proc_trxn_type_code IS NULL) THEN
707: print_debuginfo(l_module_name,'Error: Mandatory Parameter ''Transaction Type Id'' missing.');
708: FND_MESSAGE.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
709: FND_MESSAGE.SET_TOKEN('PARAM', 'Transaction Type Id');
710: FND_MSG_PUB.Add;
711: RAISE FND_API.G_EXC_ERROR;
712: END IF;
713:
714: IF (p_trxn_attributes_rec.payment_currency IS NULL) THEN

Line 718: FND_MSG_PUB.Add;

714: IF (p_trxn_attributes_rec.payment_currency IS NULL) THEN
715: print_debuginfo(l_module_name,'Error: Mandatory Parameter ''Payment Currency'' missing.');
716: FND_MESSAGE.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
717: FND_MESSAGE.SET_TOKEN('PARAM', 'Payment Currency');
718: FND_MSG_PUB.Add;
719: RAISE FND_API.G_EXC_ERROR;
720: END IF;
721:
722: IF (p_trxn_attributes_rec.payment_function IS NULL) THEN

Line 726: FND_MSG_PUB.Add;

722: IF (p_trxn_attributes_rec.payment_function IS NULL) THEN
723: print_debuginfo(l_module_name,'Error: Mandatory Parameter ''Account Usage'' missing.');
724: FND_MESSAGE.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
725: FND_MESSAGE.SET_TOKEN('PARAM', 'Account Usage');
726: FND_MSG_PUB.Add;
727: RAISE FND_API.G_EXC_ERROR;
728: END IF;
729:
730: -- Fetch Accounting Currency and 1st part Payer country

Line 873: FND_MSG_PUB.Add;

869: IF (l_pmtmthd_table.COUNT = 0) THEN
870: print_debuginfo(l_module_name,'Error: No Payment Methods Applicable');
871:
872: FND_MESSAGE.set_name('IBY', 'IBY_NO_APPLICABLE_PAYMENT_METHODS');
873: FND_MSG_PUB.Add;
874: raise FND_API.G_EXC_ERROR;
875: ELSE
876: print_debuginfo(l_module_name,'Applicable Payment Methods Count : '|| l_pmtmthd_table.COUNT);
877: x_payment_methods_tbl := l_pmtmthd_table;

Line 882: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

878: END IF;
879:
880: -- End of API body.
881: -- Standard call to get message count and if count is 1, get message info.
882: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
883:
884: print_debuginfo(l_module_name, 'RETURN');
885:
886: EXCEPTION

Line 889: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

885:
886: EXCEPTION
887: WHEN FND_API.G_EXC_ERROR THEN
888: x_return_status := FND_API.G_RET_STS_ERROR;
889: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
890: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
891: print_debuginfo(l_module_name,'SQLerr is :'
892: || substr(SQLERRM, 1, 150));
893: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 895: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

891: print_debuginfo(l_module_name,'SQLerr is :'
892: || substr(SQLERRM, 1, 150));
893: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
895: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
896: print_debuginfo(l_module_name,'Unexpected ERROR: Exception occured during call to API ');
897: print_debuginfo(l_module_name,'SQLerr is :'
898: || substr(SQLERRM, 1, 150));
899: WHEN OTHERS THEN

Line 902: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR))

898: || substr(SQLERRM, 1, 150));
899: WHEN OTHERS THEN
900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
901:
902: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR))
903: THEN
904: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
905: END IF;
906: print_debuginfo(l_module_name,'Other ERROR: Exception occured during call to API ');

Line 904: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
901:
902: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR))
903: THEN
904: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
905: END IF;
906: print_debuginfo(l_module_name,'Other ERROR: Exception occured during call to API ');
907: print_debuginfo(l_module_name,'SQLerr is :'
908: || substr(SQLERRM, 1, 150));

Line 909: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

905: END IF;
906: print_debuginfo(l_module_name,'Other ERROR: Exception occured during call to API ');
907: print_debuginfo(l_module_name,'SQLerr is :'
908: || substr(SQLERRM, 1, 150));
909: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
910:
911: END Get_Applicable_Payment_Methods;
912:
913: -- Start of comments

Line 1084: FND_MSG_PUB.initialize;

1080: END IF;
1081:
1082: -- Initialize message list if p_init_msg_list is set to TRUE.
1083: IF FND_API.to_Boolean(p_init_msg_list) THEN
1084: FND_MSG_PUB.initialize;
1085: END IF;
1086:
1087: -- Initialize API return status to success
1088: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1106: FND_MSG_PUB.Add;

1102: IF (l_pmt_profs_tab.COUNT = 0) THEN
1103: print_debuginfo(l_module_name,'Error: No applicable payment profiles '
1104: || 'were found.');
1105: FND_MESSAGE.set_name('IBY', 'IBY_NO_APPLICABLE_PAYMENT_PROFILES');
1106: FND_MSG_PUB.Add;
1107: raise FND_API.G_EXC_ERROR;
1108: ELSE
1109: print_debuginfo(l_module_name, 'Count of applicable payment profiles: '
1110: || l_pmt_profs_tab.COUNT);

Line 1118: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1114:
1115: -- End of API body.
1116:
1117: -- Standard call to get message count and if count is 1, get message info.
1118: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1119:
1120: print_debuginfo(l_module_name, 'RETURN');
1121:
1122: EXCEPTION

Line 1126: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1122: EXCEPTION
1123:
1124: WHEN FND_API.G_EXC_ERROR THEN
1125: x_return_status := FND_API.G_RET_STS_ERROR;
1126: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1127: print_debuginfo(l_module_name, 'ERROR: Exception occured '
1128: || 'during call to API ');
1129: print_debuginfo(l_module_name, 'SQLerr is :'
1130: || substr(SQLERRM, 1, 150));

Line 1134: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1130: || substr(SQLERRM, 1, 150));
1131:
1132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1134: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1135: print_debuginfo(l_module_name, 'ERROR: Exception occured during '
1136: || 'call to API ');
1137: print_debuginfo(l_module_name,'SQLerr is :'
1138: || substr(SQLERRM, 1, 150));

Line 1143: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

1139:
1140: WHEN OTHERS THEN
1141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1142:
1143: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
1144: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1145: END IF;
1146:
1147: print_debuginfo(l_module_name, 'ERROR: Exception occured during '

Line 1144: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1140: WHEN OTHERS THEN
1141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1142:
1143: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
1144: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1145: END IF;
1146:
1147: print_debuginfo(l_module_name, 'ERROR: Exception occured during '
1148: || 'call to API ');

Line 1151: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1147: print_debuginfo(l_module_name, 'ERROR: Exception occured during '
1148: || 'call to API ');
1149: print_debuginfo(l_module_name,'SQLerr is :'
1150: || substr(SQLERRM, 1, 150));
1151: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1152:
1153: END Get_Applicable_Pmt_Profiles;
1154:
1155: -- Start of comments

Line 1225: FND_MSG_PUB.initialize;

1221: END IF;
1222:
1223: -- Initialize message list if p_init_msg_list is set to TRUE.
1224: IF FND_API.to_Boolean(p_init_msg_list) THEN
1225: FND_MSG_PUB.initialize;
1226: END IF;
1227:
1228: -- Initialize API return status to success
1229: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1458: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1454: x_payment_profiles_tbl := l_prof_intsct_tab;
1455:
1456: -- End of API body.
1457: -- Standard call to get message count and if count is 1, get message info.
1458: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1459:
1460: print_debuginfo(l_module_name, 'RETURN');
1461:
1462: EXCEPTION

Line 1466: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1462: EXCEPTION
1463:
1464: WHEN FND_API.G_EXC_ERROR THEN
1465: x_return_status := FND_API.G_RET_STS_ERROR;
1466: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1467: print_debuginfo(l_module_name, 'ERROR: Exception occured '
1468: || 'during call to API ');
1469: print_debuginfo(l_module_name, 'SQLerr is :'
1470: || substr(SQLERRM, 1, 150));

Line 1474: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1470: || substr(SQLERRM, 1, 150));
1471:
1472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1474: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1475: print_debuginfo(l_module_name, 'ERROR: Exception occured during '
1476: || 'call to API ');
1477: print_debuginfo(l_module_name,'SQLerr is :'
1478: || substr(SQLERRM, 1, 150));

Line 1483: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR))

1479:
1480: WHEN OTHERS THEN
1481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1482:
1483: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR))
1484: THEN
1485:
1486: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1487:

Line 1486: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1482:
1483: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR))
1484: THEN
1485:
1486: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1487:
1488: END IF;
1489:
1490: print_debuginfo(l_module_name, 'ERROR: Exception occured during '

Line 1494: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1490: print_debuginfo(l_module_name, 'ERROR: Exception occured during '
1491: || 'call to API ');
1492: print_debuginfo(l_module_name,'SQLerr is :'
1493: || substr(SQLERRM, 1, 150));
1494: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1495:
1496: END Get_Pmt_Profiles_Intersect;
1497:
1498: -- Start of comments

Line 1564: FND_MSG_PUB.initialize;

1560: END IF;
1561:
1562: -- Initialize message list if p_init_msg_list is set to TRUE
1563: IF FND_API.to_Boolean(p_init_msg_list) THEN
1564: FND_MSG_PUB.initialize;
1565: END IF;
1566:
1567: -- Initialize API return status to success
1568: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1574: FND_MSG_PUB.Add;

1570: IF (p_trxn_attributes_rec.payer_legal_entity_id IS NULL) THEN
1571: print_debuginfo(l_module_name,'Error: Mandatory Parameter ''First party legal entity Id'' missing.');
1572: FND_MESSAGE.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
1573: FND_MESSAGE.SET_TOKEN('PARAM', 'First party legal entity Id');
1574: FND_MSG_PUB.Add;
1575: RAISE FND_API.G_EXC_ERROR;
1576: END IF;
1577:
1578: OPEN payer_country_csr(p_trxn_attributes_rec.payer_legal_entity_id);

Line 1586: FND_MSG_PUB.Add;

1582: IF (l_payer_country IS NULL) THEN
1583: print_debuginfo(l_module_name,'Error: First party country Not populated.');
1584: FND_MESSAGE.set_name('IBY', 'IBY_MISSING_DATA');
1585: FND_MESSAGE.SET_TOKEN('PARAM', 'First party country');
1586: FND_MSG_PUB.Add;
1587: RAISE FND_API.G_EXC_ERROR;
1588: END IF;
1589:
1590: OPEN payment_reason_csr(l_payer_country);

Line 1604: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1600:
1601: -- End of API body.
1602:
1603: -- Standard call to get message count and if count is 1, get message info.
1604: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1605:
1606: print_debuginfo(l_module_name, 'RETURN');
1607:
1608: EXCEPTION

Line 1611: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1607:
1608: EXCEPTION
1609: WHEN FND_API.G_EXC_ERROR THEN
1610: x_return_status := FND_API.G_RET_STS_ERROR;
1611: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1612: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
1613: print_debuginfo(l_module_name,'SQLerr is :'
1614: || substr(SQLERRM, 1, 150));
1615: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1617: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1613: print_debuginfo(l_module_name,'SQLerr is :'
1614: || substr(SQLERRM, 1, 150));
1615: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1617: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1618: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
1619: print_debuginfo(l_module_name,'SQLerr is :'
1620: || substr(SQLERRM, 1, 150));
1621: WHEN OTHERS THEN

Line 1624: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

1620: || substr(SQLERRM, 1, 150));
1621: WHEN OTHERS THEN
1622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1623:
1624: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
1625: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1626: END IF;
1627: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
1628: print_debuginfo(l_module_name,'SQLerr is :'

Line 1625: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1621: WHEN OTHERS THEN
1622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1623:
1624: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
1625: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1626: END IF;
1627: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
1628: print_debuginfo(l_module_name,'SQLerr is :'
1629: || substr(SQLERRM, 1, 150));

Line 1630: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1626: END IF;
1627: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
1628: print_debuginfo(l_module_name,'SQLerr is :'
1629: || substr(SQLERRM, 1, 150));
1630: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1631:
1632: END Get_Applicable_Payment_Reasons;
1633:
1634: -- Start of comments

Line 2005: FND_MSG_PUB.initialize;

2001: END IF;
2002:
2003: -- Initialize message list if p_init_msg_list is set to TRUE.
2004: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2005: FND_MSG_PUB.initialize;
2006: END IF;
2007:
2008: -- Initialize API return status to success
2009: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2295: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2291: x_default_pmt_attrs_rec.payment_reason_comments :=l_payment_reason_comments;
2292: -- End of API body.
2293:
2294: -- Standard call to get message count and if count is 1, get message info.
2295: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2296: p_data => x_msg_data);
2297:
2298: print_debuginfo(l_module_name, 'RETURN');
2299:

Line 2306: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2302: x_return_status := FND_API.G_RET_STS_ERROR ;
2303: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
2304: print_debuginfo(l_module_name,'SQLerr is :'
2305: || substr(SQLERRM, 1, 150));
2306: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2307: p_data => x_msg_data);
2308:
2309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2314: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2311: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
2312: print_debuginfo(l_module_name,'SQLerr is :'
2313: || substr(SQLERRM, 1, 150));
2314: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2315: p_data => x_msg_data);
2316:
2317: WHEN OTHERS THEN
2318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2322: IF (FND_MSG_PUB.Check_Msg_Level

2318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2319: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
2320: print_debuginfo(l_module_name,'SQLerr is :'
2321: || substr(SQLERRM, 1, 150));
2322: IF (FND_MSG_PUB.Check_Msg_Level
2323: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
2324: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
2325: l_api_name);
2326: END IF;

Line 2323: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

2319: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
2320: print_debuginfo(l_module_name,'SQLerr is :'
2321: || substr(SQLERRM, 1, 150));
2322: IF (FND_MSG_PUB.Check_Msg_Level
2323: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
2324: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
2325: l_api_name);
2326: END IF;
2327: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

Line 2324: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

2320: print_debuginfo(l_module_name,'SQLerr is :'
2321: || substr(SQLERRM, 1, 150));
2322: IF (FND_MSG_PUB.Check_Msg_Level
2323: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
2324: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
2325: l_api_name);
2326: END IF;
2327: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2328: p_data => x_msg_data);

Line 2327: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2323: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
2324: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
2325: l_api_name);
2326: END IF;
2327: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2328: p_data => x_msg_data);
2329:
2330: END Get_Default_Payment_Attributes;
2331:

Line 2433: FND_MSG_PUB.initialize;

2429: END IF;
2430:
2431: -- Initialize message list if p_init_msg_list is set to TRUE.
2432: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2433: FND_MSG_PUB.initialize;
2434: END IF;
2435:
2436: -- Initialize API return status to success
2437: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2453: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2449: x_payee_bankaccount := l_payee_bankaccount_rec;
2450: -- End of API body.
2451:
2452: -- Standard call to get message count and if count is 1, get message info.
2453: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2454: p_data => x_msg_data);
2455:
2456: print_debuginfo(l_module_name, 'RETURN');
2457:

Line 2464: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2460: x_return_status := FND_API.G_RET_STS_ERROR ;
2461: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
2462: print_debuginfo(l_module_name,'SQLerr is :'
2463: || substr(SQLERRM, 1, 150));
2464: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2465: p_data => x_msg_data);
2466:
2467: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2472: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2469: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
2470: print_debuginfo(l_module_name,'SQLerr is :'
2471: || substr(SQLERRM, 1, 150));
2472: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2473: p_data => x_msg_data);
2474:
2475: WHEN OTHERS THEN
2476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2480: IF (FND_MSG_PUB.Check_Msg_Level

2476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2477: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
2478: print_debuginfo(l_module_name,'SQLerr is :'
2479: || substr(SQLERRM, 1, 150));
2480: IF (FND_MSG_PUB.Check_Msg_Level
2481: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
2482: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
2483: l_api_name);
2484: END IF;

Line 2481: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

2477: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
2478: print_debuginfo(l_module_name,'SQLerr is :'
2479: || substr(SQLERRM, 1, 150));
2480: IF (FND_MSG_PUB.Check_Msg_Level
2481: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
2482: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
2483: l_api_name);
2484: END IF;
2485: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

Line 2482: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

2478: print_debuginfo(l_module_name,'SQLerr is :'
2479: || substr(SQLERRM, 1, 150));
2480: IF (FND_MSG_PUB.Check_Msg_Level
2481: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
2482: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
2483: l_api_name);
2484: END IF;
2485: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2486: p_data => x_msg_data);

Line 2485: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2481: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
2482: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
2483: l_api_name);
2484: END IF;
2485: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2486: p_data => x_msg_data);
2487:
2488: END Get_Default_Payee_Bank_Acc;
2489:

Line 2563: FND_MSG_PUB.initialize;

2559: END IF;
2560:
2561: -- Initialize message list if p_init_msg_list is set to TRUE.
2562: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2563: FND_MSG_PUB.initialize;
2564: END IF;
2565:
2566: -- Initialize API return status to success
2567: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2577: FND_MSG_PUB.Add;

2573: IF (trunc(sysdate) < NVL(l_Payment_Field_Properties.inactive_date, trunc(sysdate))) THEN
2574: print_debuginfo(l_module_name,'Error: Payment Method is inactive.');
2575: FND_MESSAGE.set_name('IBY', 'IBY_INACTIVE_ATTRIBUTE');
2576: FND_MESSAGE.SET_TOKEN('PARAM', 'Payment Method');
2577: FND_MSG_PUB.Add;
2578: RAISE FND_API.G_EXC_ERROR;
2579: ELSE
2580: x_Payment_Field_Properties := l_Payment_Field_Properties;
2581: END IF;

Line 2588: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2584:
2585: -- End of API body.
2586:
2587: -- Standard call to get message count and if count is 1, get message info.
2588: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2589: p_data => x_msg_data);
2590:
2591: print_debuginfo(l_module_name, 'RETURN');
2592: EXCEPTION

Line 2598: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2594: x_return_status := FND_API.G_RET_STS_ERROR ;
2595: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
2596: print_debuginfo(l_module_name,'SQLerr is :'
2597: || substr(SQLERRM, 1, 150));
2598: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2599: p_data => x_msg_data);
2600:
2601: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2606: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2603: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
2604: print_debuginfo(l_module_name,'SQLerr is :'
2605: || substr(SQLERRM, 1, 150));
2606: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2607: p_data => x_msg_data);
2608:
2609: WHEN OTHERS THEN
2610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2614: IF (FND_MSG_PUB.Check_Msg_Level

2610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2611: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
2612: print_debuginfo(l_module_name,'SQLerr is :'
2613: || substr(SQLERRM, 1, 150));
2614: IF (FND_MSG_PUB.Check_Msg_Level
2615: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
2616: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
2617: l_api_name);
2618: END IF;

Line 2615: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

2611: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
2612: print_debuginfo(l_module_name,'SQLerr is :'
2613: || substr(SQLERRM, 1, 150));
2614: IF (FND_MSG_PUB.Check_Msg_Level
2615: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
2616: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
2617: l_api_name);
2618: END IF;
2619: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

Line 2616: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

2612: print_debuginfo(l_module_name,'SQLerr is :'
2613: || substr(SQLERRM, 1, 150));
2614: IF (FND_MSG_PUB.Check_Msg_Level
2615: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
2616: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
2617: l_api_name);
2618: END IF;
2619: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2620: p_data => x_msg_data);

Line 2619: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2615: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
2616: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
2617: l_api_name);
2618: END IF;
2619: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2620: p_data => x_msg_data);
2621:
2622: END Get_Payment_Field_Properties;
2623:

Line 2677: FND_MSG_PUB.initialize;

2673: END IF;
2674:
2675: -- Initialize message list if p_init_msg_list is set to TRUE.
2676: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2677: FND_MSG_PUB.initialize;
2678: END IF;
2679:
2680: -- Initialize API return status to success
2681: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2696: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2692:
2693: -- End of API body.
2694:
2695: -- Standard call to get message count and if count is 1, get message info.
2696: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2697: p_data => x_msg_data);
2698:
2699: print_debuginfo(l_module_name, 'RETURN');
2700:

Line 2707: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2703: x_return_status := FND_API.G_RET_STS_ERROR ;
2704: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
2705: print_debuginfo(l_module_name,'SQLerr is :'
2706: || substr(SQLERRM, 1, 150));
2707: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2708: p_data => x_msg_data);
2709:
2710: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2715: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2712: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
2713: print_debuginfo(l_module_name,'SQLerr is :'
2714: || substr(SQLERRM, 1, 150));
2715: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2716: p_data => x_msg_data);
2717:
2718: WHEN OTHERS THEN
2719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2723: IF (FND_MSG_PUB.Check_Msg_Level

2719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2720: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
2721: print_debuginfo(l_module_name,'SQLerr is :'
2722: || substr(SQLERRM, 1, 150));
2723: IF (FND_MSG_PUB.Check_Msg_Level
2724: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
2725: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
2726: l_api_name);
2727: END IF;

Line 2724: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

2720: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
2721: print_debuginfo(l_module_name,'SQLerr is :'
2722: || substr(SQLERRM, 1, 150));
2723: IF (FND_MSG_PUB.Check_Msg_Level
2724: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
2725: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
2726: l_api_name);
2727: END IF;
2728: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

Line 2725: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

2721: print_debuginfo(l_module_name,'SQLerr is :'
2722: || substr(SQLERRM, 1, 150));
2723: IF (FND_MSG_PUB.Check_Msg_Level
2724: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
2725: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
2726: l_api_name);
2727: END IF;
2728: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2729: p_data => x_msg_data);

Line 2728: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2724: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
2725: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
2726: l_api_name);
2727: END IF;
2728: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2729: p_data => x_msg_data);
2730:
2731: END Validate_Documents;
2732: