DBA Data[Home] [Help]

APPS.IBY_FD_USER_API_PUB dependencies on FND_MSG_PUB

Line 104: FND_MSG_PUB.initialize;

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

Line 134: FND_MSG_PUB.Add;

130:
131: FND_MESSAGE.set_name('IBY', 'IBY_AP_VLDT_METHOD_LE');
132: FND_MESSAGE.SET_TOKEN('METHOD', l_method_name);
133: FND_MESSAGE.SET_TOKEN('OBJECT', l_le_name);
134: FND_MSG_PUB.Add;
135:
136: x_return_status := FND_API.G_RET_STS_ERROR;
137: END IF;
138: END LOOP;

Line 157: FND_MSG_PUB.Add;

153:
154: FND_MESSAGE.set_name('IBY', 'IBY_AP_VLDT_METHOD_ORG');
155: FND_MESSAGE.SET_TOKEN('METHOD', l_method_name);
156: FND_MESSAGE.SET_TOKEN('OBJECT', l_org_name);
157: FND_MSG_PUB.Add;
158:
159: x_return_status := FND_API.G_RET_STS_ERROR;
160: END IF;
161: END LOOP;

Line 190: FND_MSG_PUB.Add;

186:
187: FND_MESSAGE.set_name('IBY', 'IBY_AP_VLDT_PROF_ACC');
188: FND_MESSAGE.SET_TOKEN('PROFILE', l_profile_name);
189: FND_MESSAGE.SET_TOKEN('OBJECT', l_acc_name);
190: FND_MSG_PUB.Add;
191:
192: x_return_status := FND_API.G_RET_STS_ERROR;
193: END IF;
194: END LOOP;

Line 213: FND_MSG_PUB.Add;

209:
210: FND_MESSAGE.set_name('IBY', 'IBY_AP_VLDT_PROF_ORG');
211: FND_MESSAGE.SET_TOKEN('PROFILE', l_profile_name);
212: FND_MESSAGE.SET_TOKEN('OBJECT', l_org_name);
213: FND_MSG_PUB.Add;
214:
215: x_return_status := FND_API.G_RET_STS_ERROR;
216: END IF;
217: END LOOP;

Line 231: FND_MSG_PUB.Add;

227: IF l_count = 0 THEN
228: FND_MESSAGE.set_name('IBY', 'IBY_AP_VLDT_PROF_CURR');
229: FND_MESSAGE.SET_TOKEN('PROFILE', l_profile_name);
230: FND_MESSAGE.SET_TOKEN('OBJECT', p_curr_arr(i));
231: FND_MSG_PUB.Add;
232:
233: x_return_status := FND_API.G_RET_STS_ERROR;
234: END IF;
235: END LOOP;

Line 253: FND_MSG_PUB.Add;

249: IF l_count = 0 THEN
250: FND_MESSAGE.set_name('IBY', 'IBY_AP_VLDT_PROF_METHOD');
251: FND_MESSAGE.SET_TOKEN('PROFILE', l_profile_name);
252: FND_MESSAGE.SET_TOKEN('OBJECT', l_method_name);
253: FND_MSG_PUB.Add;
254:
255: x_return_status := FND_API.G_RET_STS_ERROR;
256: END IF;
257: END IF;

Line 266: FND_MSG_PUB.Add;

262: IF p_crt_instr_flag = 'Y' THEN
263: IF p_ppp_id is null THEN
264: /*
265: FND_MESSAGE.set_name('IBY', 'IBY_BUILD_INV_PARAMS');
266: FND_MSG_PUB.Add;
267:
268: x_return_status := FND_API.G_RET_STS_ERROR;*/
269: print_debuginfo(l_module_name,'Payment profile entry considered optional after bug 8781032');
270: ELSE

Line 282: FND_MSG_PUB.Add;

278:
279: IF (l_payment_document_id = -1) and
280: (l_proc_type = 'PRINTED') THEN
281: FND_MESSAGE.set_name('IBY', 'IBY_APSUB_NO_DEFAULT_PMT_DOC');
282: FND_MSG_PUB.Add;
283:
284: x_return_status := FND_API.G_RET_STS_ERROR;
285: END IF;
286: END IF;

Line 293: FND_MSG_PUB.Add;

289:
290: IF p_payment_document_id is not null THEN
291: IF p_ppp_id is null OR p_int_bank_acc_arr.COUNT = 0 THEN
292: FND_MESSAGE.set_name('IBY', 'IBY_BUILD_MISS_PMT_DOC_REL_PAR');
293: FND_MSG_PUB.Add;
294:
295: x_return_status := FND_API.G_RET_STS_ERROR;
296: END IF;
297: END IF;

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

298:
299: -- End of API body.
300:
301: -- Standard call to get message count and if count is 1, get message info.
302: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
303:
304: print_debuginfo(l_module_name, 'RETURN Validate_Method_Profile');
305:
306: EXCEPTION

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

305:
306: EXCEPTION
307: WHEN FND_API.G_EXC_ERROR THEN
308: x_return_status := FND_API.G_RET_STS_ERROR;
309: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
310: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
311: print_debuginfo(l_module_name,'SQLerr is :' || substr(SQLERRM, 1, 150));
312:
313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

311: print_debuginfo(l_module_name,'SQLerr is :' || substr(SQLERRM, 1, 150));
312:
313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
315: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
316: print_debuginfo(l_module_name,'Unexpected ERROR: Exception occured during call to API ');
317: print_debuginfo(l_module_name,'SQLerr is :' || substr(SQLERRM, 1, 150));
318:
319: WHEN OTHERS THEN

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

317: print_debuginfo(l_module_name,'SQLerr is :' || substr(SQLERRM, 1, 150));
318:
319: WHEN OTHERS THEN
320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
321: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
322: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
323: END IF;
324: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
325: print_debuginfo(l_module_name,'Other ERROR: Exception occured during call to API ');

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

318:
319: WHEN OTHERS THEN
320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
321: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
322: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
323: END IF;
324: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
325: print_debuginfo(l_module_name,'Other ERROR: Exception occured during call to API ');
326: print_debuginfo(l_module_name,'SQLerr is :' || substr(SQLERRM, 1, 150));

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

320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
321: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
322: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
323: END IF;
324: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
325: print_debuginfo(l_module_name,'Other ERROR: Exception occured during call to API ');
326: print_debuginfo(l_module_name,'SQLerr is :' || substr(SQLERRM, 1, 150));
327:
328: END Validate_Method_and_Profile;

Line 593: FND_MSG_PUB.initialize;

589: END IF;
590:
591: -- Initialize message list if p_init_msg_list is set to TRUE.
592: IF FND_API.to_Boolean(p_init_msg_list) THEN
593: FND_MSG_PUB.initialize;
594: END IF;
595:
596: -- Initialize API return status to success
597: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 602: FND_MSG_PUB.Add;

598:
599: IF p_instr_id is null THEN
600: FND_MESSAGE.set_name('IBY', 'IBY_SRA_SUBMIT_INVALID_INSTR');
601: FND_MESSAGE.SET_TOKEN('INSTR_ID', p_instr_id);
602: FND_MSG_PUB.Add;
603: raise SRA_INVALID_INSTR;
604: END IF;
605:
606: select count(*)

Line 618: FND_MSG_PUB.Add;

614:
615: IF l_instr_sra_ok = 0 THEN
616: FND_MESSAGE.set_name('IBY', 'IBY_SRA_SUBMIT_INVALID_INSTR');
617: FND_MESSAGE.SET_TOKEN('INSTR_ID', p_instr_id);
618: FND_MSG_PUB.Add;
619: raise SRA_INVALID_INSTR;
620: ELSE
621: select sra_setup.remittance_advice_format_code,
622: f.format_name

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

634:
635: -- End of API body.
636:
637: -- Standard call to get message count and if count is 1, get message info.
638: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
639:
640: print_debuginfo(l_module_name, 'RETURN retrieve_default_sra_format');
641:
642: EXCEPTION

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

641:
642: EXCEPTION
643: WHEN FND_API.G_EXC_ERROR THEN
644: x_return_status := FND_API.G_RET_STS_ERROR;
645: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
646: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
647: print_debuginfo(l_module_name,'SQLerr is :' || substr(SQLERRM, 1, 150));
648:
649: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

647: print_debuginfo(l_module_name,'SQLerr is :' || substr(SQLERRM, 1, 150));
648:
649: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
651: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
652: print_debuginfo(l_module_name,'Unexpected ERROR: Exception occured during call to API ');
653: print_debuginfo(l_module_name,'SQLerr is :' || substr(SQLERRM, 1, 150));
654:
655: WHEN SRA_INVALID_INSTR THEN

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

653: print_debuginfo(l_module_name,'SQLerr is :' || substr(SQLERRM, 1, 150));
654:
655: WHEN SRA_INVALID_INSTR THEN
656: x_return_status := FND_API.G_RET_STS_ERROR;
657: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
658: print_debuginfo(l_module_name,'ERROR: The payment instruction is not available for SRA. ');
659:
660: WHEN OTHERS THEN
661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

658: print_debuginfo(l_module_name,'ERROR: The payment instruction is not available for SRA. ');
659:
660: WHEN OTHERS THEN
661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
662: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
663: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
664: END IF;
665: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
666: print_debuginfo(l_module_name,'Other ERROR: Exception occured during call to API ');

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

659:
660: WHEN OTHERS THEN
661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
662: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
663: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
664: END IF;
665: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
666: print_debuginfo(l_module_name,'Other ERROR: Exception occured during call to API ');
667: print_debuginfo(l_module_name,'SQLerr is :' || substr(SQLERRM, 1, 150));

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

661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
662: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
663: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
664: END IF;
665: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
666: print_debuginfo(l_module_name,'Other ERROR: Exception occured during call to API ');
667: print_debuginfo(l_module_name,'SQLerr is :' || substr(SQLERRM, 1, 150));
668:
669: END retrieve_default_sra_format;

Line 753: FND_MSG_PUB.initialize;

749: BEGIN
750:
751: print_debuginfo(l_module_name,'Enter');
752:
753: FND_MSG_PUB.initialize;
754:
755: print_debuginfo(l_module_name,'Instruction Id::'||p_instruction_id);
756:
757:

Line 777: FND_MSG_PUB.Add;

773:
774: IF(l_instruction_status = 'SUBMITTED_FOR_PRINTING')
775: THEN
776: FND_MESSAGE.set_name('IBY', 'IBY_INSTR_TERM_SUB_PRNT');
777: FND_MSG_PUB.Add;
778: ELSIF(l_process_type = 'IMMEDIATE')
779: THEN
780: FND_MESSAGE.set_name('IBY', 'IBY_INSTR_TERM_SING_PMT');
781: FND_MSG_PUB.Add;

Line 781: FND_MSG_PUB.Add;

777: FND_MSG_PUB.Add;
778: ELSIF(l_process_type = 'IMMEDIATE')
779: THEN
780: FND_MESSAGE.set_name('IBY', 'IBY_INSTR_TERM_SING_PMT');
781: FND_MSG_PUB.Add;
782: ELSIF(l_pmt_complete_code = 'YES')
783: THEN
784: FND_MESSAGE.set_name('IBY', 'IBY_INSTR_TERM_COMP');
785: FND_MSG_PUB.Add;

Line 785: FND_MSG_PUB.Add;

781: FND_MSG_PUB.Add;
782: ELSIF(l_pmt_complete_code = 'YES')
783: THEN
784: FND_MESSAGE.set_name('IBY', 'IBY_INSTR_TERM_COMP');
785: FND_MSG_PUB.Add;
786: ELSIF(l_instruction_status IN ('CREATION_ERROR',
787: 'FORMATTED_READY_TO_TRANSMIT' ,
788: 'TRANSMISSION_FAILED',
789: 'FORMATTED_READY_FOR_PRINTING',

Line 805: FND_MSG_PUB.Add;

801: ELSIF (l_request_status = 'ERROR') THEN
802: l_allowed := 'YES';
803: ELSE
804: FND_MESSAGE.set_name('IBY', 'IBY_INSTR_TERM_FRMT_PRG');
805: FND_MSG_PUB.Add;
806: END IF;
807: ELSE
808: l_allowed := 'YES';
809: END IF;

Line 843: FND_MSG_PUB.initialize;

839: print_debuginfo(l_module_name,'Instruction Id::'||p_instruction_id);
840: print_debuginfo(l_module_name,'Org Id::'||p_org_id);
841: print_debuginfo(l_module_name,'Payment Complete Code::'||p_pmt_complete_code);
842: print_debuginfo(l_module_name,'Request Id::'||p_request_id);
843: FND_MSG_PUB.initialize;
844:
845:
846: if p_org_id is null then
847:

Line 879: FND_MSG_PUB.Add;

875: -- If not MOAC access to all payments
876: l_allowed := 'NO';
877: IF(p_msg_req = 'Y') THEN
878: FND_MESSAGE.set_name('IBY', 'IBY_INSTR_TERM_INV_ACCESS');
879: FND_MSG_PUB.Add;
880: END IF;
881:
882: ELSE
883:

Line 890: FND_MSG_PUB.Add;

886: THEN
887: l_allowed := 'NO';
888: IF(p_msg_req = 'Y') THEN
889: FND_MESSAGE.set_name('IBY', 'IBY_INSTR_TERM_SUB_PRNT');
890: FND_MSG_PUB.Add;
891: END IF;
892: ELSIF(p_process_type = 'IMMEDIATE')
893: THEN
894: l_allowed := 'NO';

Line 897: FND_MSG_PUB.Add;

893: THEN
894: l_allowed := 'NO';
895: IF(p_msg_req = 'Y') THEN
896: FND_MESSAGE.set_name('IBY', 'IBY_INSTR_TERM_SING_PMT');
897: FND_MSG_PUB.Add;
898: END IF;
899: ELSIF(p_pmt_complete_code = 'YES')
900: THEN
901: l_allowed := 'NO';

Line 904: FND_MSG_PUB.Add;

900: THEN
901: l_allowed := 'NO';
902: IF(p_msg_req = 'Y') THEN
903: FND_MESSAGE.set_name('IBY', 'IBY_INSTR_TERM_COMP');
904: FND_MSG_PUB.Add;
905: END IF;
906: ELSIF(p_instruction_status IN ('CREATION_ERROR',
907: 'FORMATTED_READY_TO_TRANSMIT' ,
908: 'TRANSMISSION_FAILED',

Line 927: FND_MSG_PUB.Add;

923: ELSE
924: l_allowed := 'NO';
925: IF(p_msg_req = 'Y') THEN
926: FND_MESSAGE.set_name('IBY', 'IBY_INSTR_TERM_FRMT_PRG');
927: FND_MSG_PUB.Add;
928: END IF;
929:
930: END IF;
931: ELSE

Line 970: FND_MSG_PUB.initialize;

966: WHERE PMT.PAYMENT_SERVICE_REQUEST_ID= ppr_id
967: AND PMT.PAYMENT_INSTRUCTION_ID = InStr.PAYMENT_INSTRUCTION_ID);
968:
969: BEGIN
970: FND_MSG_PUB.initialize;
971:
972: OPEN instr_for_ppr(p_pay_service_req_id);
973: loop
974: FETCH instr_for_ppr INTO l_instruction_status,