DBA Data[Home] [Help]

APPS.ARP_EXT_BANK_PKG dependencies on FND_API

Line 65: l_init_msg_list VARCHAR2(30) DEFAULT FND_API.G_TRUE;

61: p_Branch_Number IN VARCHAR2,
62: p_value_out OUT NOCOPY VARCHAR2,
63: x_return_status OUT NOCOPY VARCHAR2)
64: IS
65: l_init_msg_list VARCHAR2(30) DEFAULT FND_API.G_TRUE;
66: l_return_status VARCHAR2(30);
67: l_msg_count NUMBER;
68: l_msg_data VARCHAR2(2000);
69: l_branch_number ce_bank_branches_v.branch_number%TYPE ;

Line 87: IF l_return_status = fnd_api.g_ret_sts_error OR

83: arp_standard.debug ('IBY BRANCH NUM FORMAT API Return Status = ' || l_return_status);
84: arp_standard.debug('IBY BRANCH NUMB FORMAT API Branch Number = '||p_value_out);
85: x_return_status := l_return_status ;
86:
87: IF l_return_status = fnd_api.g_ret_sts_error OR
88: l_return_status = fnd_api.g_ret_sts_unexp_error THEN
89:
90: arp_standard.debug('Errors Reported By IBY Branch Num Format API: ');
91: FOR i in 1 .. l_msg_count LOOP

Line 88: l_return_status = fnd_api.g_ret_sts_unexp_error THEN

84: arp_standard.debug('IBY BRANCH NUMB FORMAT API Branch Number = '||p_value_out);
85: x_return_status := l_return_status ;
86:
87: IF l_return_status = fnd_api.g_ret_sts_error OR
88: l_return_status = fnd_api.g_ret_sts_unexp_error THEN
89:
90: arp_standard.debug('Errors Reported By IBY Branch Num Format API: ');
91: FOR i in 1 .. l_msg_count LOOP
92: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false, l_msg_data,

Line 92: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false, l_msg_data,

88: l_return_status = fnd_api.g_ret_sts_unexp_error THEN
89:
90: arp_standard.debug('Errors Reported By IBY Branch Num Format API: ');
91: FOR i in 1 .. l_msg_count LOOP
92: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false, l_msg_data,
93: l_msg_count);
94: arp_standard.debug(l_msg_data);
95: END LOOP;
96: ELSE

Line 167: l_init_msg_list VARCHAR2(30) DEFAULT FND_API.G_TRUE;

163: l_ext_branch_rec IBY_EXT_BANKACCT_PUB.ExtBankBranch_rec_type;
164: l_branch_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
165:
166: l_api_version NUMBER := 1.0;
167: l_init_msg_list VARCHAR2(30) DEFAULT FND_API.G_TRUE;
168: l_commit VARCHAR2(30) DEFAULT FND_API.G_FALSE;
169: l_return_status VARCHAR2(30);
170: l_msg_count NUMBER;
171: l_msg_data VARCHAR2(2000);

Line 168: l_commit VARCHAR2(30) DEFAULT FND_API.G_FALSE;

164: l_branch_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
165:
166: l_api_version NUMBER := 1.0;
167: l_init_msg_list VARCHAR2(30) DEFAULT FND_API.G_TRUE;
168: l_commit VARCHAR2(30) DEFAULT FND_API.G_FALSE;
169: l_return_status VARCHAR2(30);
170: l_msg_count NUMBER;
171: l_msg_data VARCHAR2(2000);
172:

Line 218: IF l_return_status = fnd_api.g_ret_sts_error OR

214: -- begin bug5594142
215: x_return_status := l_return_status ;
216: -- end bug5594142
217:
218: IF l_return_status = fnd_api.g_ret_sts_error OR
219: l_return_status = fnd_api.g_ret_sts_unexp_error THEN
220:
221: arp_standard.debug('Errors Reported By Bank API: ');
222: FOR i in 1 .. l_msg_count LOOP

Line 219: l_return_status = fnd_api.g_ret_sts_unexp_error THEN

215: x_return_status := l_return_status ;
216: -- end bug5594142
217:
218: IF l_return_status = fnd_api.g_ret_sts_error OR
219: l_return_status = fnd_api.g_ret_sts_unexp_error THEN
220:
221: arp_standard.debug('Errors Reported By Bank API: ');
222: FOR i in 1 .. l_msg_count LOOP
223: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false, l_msg_data,

Line 223: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false, l_msg_data,

219: l_return_status = fnd_api.g_ret_sts_unexp_error THEN
220:
221: arp_standard.debug('Errors Reported By Bank API: ');
222: FOR i in 1 .. l_msg_count LOOP
223: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false, l_msg_data,
224: l_msg_count);
225: arp_standard.debug(l_msg_data);
226: END LOOP;
227:

Line 262: IF l_return_status = fnd_api.g_ret_sts_error OR

258: -- begin bug5594142
259: x_return_status := l_return_status ;
260: -- end bug5594142
261:
262: IF l_return_status = fnd_api.g_ret_sts_error OR
263: l_return_status = fnd_api.g_ret_sts_unexp_error THEN
264:
265: arp_standard.debug('Errors Reported By Bank Branch API: ');
266: FOR i in 1 .. l_msg_count LOOP

Line 263: l_return_status = fnd_api.g_ret_sts_unexp_error THEN

259: x_return_status := l_return_status ;
260: -- end bug5594142
261:
262: IF l_return_status = fnd_api.g_ret_sts_error OR
263: l_return_status = fnd_api.g_ret_sts_unexp_error THEN
264:
265: arp_standard.debug('Errors Reported By Bank Branch API: ');
266: FOR i in 1 .. l_msg_count LOOP
267: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false, l_msg_data,

Line 267: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false, l_msg_data,

263: l_return_status = fnd_api.g_ret_sts_unexp_error THEN
264:
265: arp_standard.debug('Errors Reported By Bank Branch API: ');
266: FOR i in 1 .. l_msg_count LOOP
267: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false, l_msg_data,
268: l_msg_count);
269: arp_standard.debug(l_msg_data);
270: END LOOP;
271: ELSE

Line 342: l_init_msg_list VARCHAR2(30) DEFAULT FND_API.G_TRUE;

338: l_bank_acct_response iby_fndcpt_common_pub.result_rec_type;
339: l_party_id iby_ext_bank_accounts_v.primary_acct_owner_party_id%type;
340:
341: l_api_version NUMBER := 1.0;
342: l_init_msg_list VARCHAR2(30) DEFAULT FND_API.G_TRUE;
343: l_commit VARCHAR2(30) DEFAULT FND_API.G_FALSE;
344: l_return_status VARCHAR2(30);
345: l_msg_count NUMBER;
346: l_msg_data VARCHAR2(2000);

Line 343: l_commit VARCHAR2(30) DEFAULT FND_API.G_FALSE;

339: l_party_id iby_ext_bank_accounts_v.primary_acct_owner_party_id%type;
340:
341: l_api_version NUMBER := 1.0;
342: l_init_msg_list VARCHAR2(30) DEFAULT FND_API.G_TRUE;
343: l_commit VARCHAR2(30) DEFAULT FND_API.G_FALSE;
344: l_return_status VARCHAR2(30);
345: l_msg_count NUMBER;
346: l_msg_data VARCHAR2(2000);
347:

Line 392: IF l_return_status = fnd_api.g_ret_sts_error OR

388: -- begin bug5594142
389: x_return_status := l_return_status ;
390: -- end bug5594142
391:
392: IF l_return_status = fnd_api.g_ret_sts_error OR
393: l_return_status = fnd_api.g_ret_sts_unexp_error THEN
394:
395: arp_standard.debug('Errors Reported By Bank API: ');
396: FOR i in 1 .. l_msg_count LOOP

Line 393: l_return_status = fnd_api.g_ret_sts_unexp_error THEN

389: x_return_status := l_return_status ;
390: -- end bug5594142
391:
392: IF l_return_status = fnd_api.g_ret_sts_error OR
393: l_return_status = fnd_api.g_ret_sts_unexp_error THEN
394:
395: arp_standard.debug('Errors Reported By Bank API: ');
396: FOR i in 1 .. l_msg_count LOOP
397: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false, l_msg_data,

Line 397: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false, l_msg_data,

393: l_return_status = fnd_api.g_ret_sts_unexp_error THEN
394:
395: arp_standard.debug('Errors Reported By Bank API: ');
396: FOR i in 1 .. l_msg_count LOOP
397: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false, l_msg_data,
398: l_msg_count);
399: arp_standard.debug(l_msg_data);
400: END LOOP;
401:

Line 465: l_init_msg_list VARCHAR2(30) DEFAULT FND_API.G_TRUE;

461: l_end_date iby_ext_bank_accounts_v.end_date%TYPE;
462: l_bank_acct_response iby_fndcpt_common_pub.result_rec_type;
463:
464: l_api_version NUMBER := 1.0;
465: l_init_msg_list VARCHAR2(30) DEFAULT FND_API.G_TRUE;
466: l_commit VARCHAR2(30) DEFAULT FND_API.G_FALSE;
467: l_return_status VARCHAR2(30);
468: l_msg_count NUMBER;
469: l_msg_data VARCHAR2(2000);

Line 466: l_commit VARCHAR2(30) DEFAULT FND_API.G_FALSE;

462: l_bank_acct_response iby_fndcpt_common_pub.result_rec_type;
463:
464: l_api_version NUMBER := 1.0;
465: l_init_msg_list VARCHAR2(30) DEFAULT FND_API.G_TRUE;
466: l_commit VARCHAR2(30) DEFAULT FND_API.G_FALSE;
467: l_return_status VARCHAR2(30);
468: l_msg_count NUMBER;
469: l_msg_data VARCHAR2(2000);
470:

Line 499: IF l_return_status = fnd_api.g_ret_sts_error OR

495: -- begin bug5594142
496: x_return_status := l_return_status ;
497: -- end bug5594142
498:
499: IF l_return_status = fnd_api.g_ret_sts_error OR
500: l_return_status = fnd_api.g_ret_sts_unexp_error THEN
501:
502: arp_standard.debug('Errors Reported By Bank API: ');
503: FOR i in 1 .. l_msg_count LOOP

Line 500: l_return_status = fnd_api.g_ret_sts_unexp_error THEN

496: x_return_status := l_return_status ;
497: -- end bug5594142
498:
499: IF l_return_status = fnd_api.g_ret_sts_error OR
500: l_return_status = fnd_api.g_ret_sts_unexp_error THEN
501:
502: arp_standard.debug('Errors Reported By Bank API: ');
503: FOR i in 1 .. l_msg_count LOOP
504: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false, l_msg_data,

Line 504: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false, l_msg_data,

500: l_return_status = fnd_api.g_ret_sts_unexp_error THEN
501:
502: arp_standard.debug('Errors Reported By Bank API: ');
503: FOR i in 1 .. l_msg_count LOOP
504: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false, l_msg_data,
505: l_msg_count);
506: arp_standard.debug(l_msg_data);
507: END LOOP;
508:

Line 792: l_init_msg_list VARCHAR2(30) DEFAULT FND_API.G_TRUE;

788: l_payer_context_rec IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
789: l_pmtInstrAssignment_rec IBY_FNDCPT_SETUP_PUB.PmtInstrAssignment_rec_type;
790: l_pmtInstrument_rec_type IBY_FNDCPT_SETUP_PUB.PmtInstrument_rec_type;
791: l_api_version NUMBER := 1.0;
792: l_init_msg_list VARCHAR2(30) DEFAULT FND_API.G_TRUE;
793: l_commit VARCHAR2(30) DEFAULT FND_API.G_FALSE;
794: l_return_status VARCHAR2(30);
795: l_msg_count NUMBER;
796: l_msg_data VARCHAR2(2000);

Line 793: l_commit VARCHAR2(30) DEFAULT FND_API.G_FALSE;

789: l_pmtInstrAssignment_rec IBY_FNDCPT_SETUP_PUB.PmtInstrAssignment_rec_type;
790: l_pmtInstrument_rec_type IBY_FNDCPT_SETUP_PUB.PmtInstrument_rec_type;
791: l_api_version NUMBER := 1.0;
792: l_init_msg_list VARCHAR2(30) DEFAULT FND_API.G_TRUE;
793: l_commit VARCHAR2(30) DEFAULT FND_API.G_FALSE;
794: l_return_status VARCHAR2(30);
795: l_msg_count NUMBER;
796: l_msg_data VARCHAR2(2000);
797: l_assign_id NUMBER;

Line 830: IF l_return_status = fnd_api.g_ret_sts_error OR

826: x_response => l_branch_response);
827: arp_standard.debug('IBY IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment API Return Status = ' || l_return_status);
828: x_return_status := l_return_status ;
829:
830: IF l_return_status = fnd_api.g_ret_sts_error OR
831: l_return_status = fnd_api.g_ret_sts_unexp_error THEN
832:
833: arp_standard.debug('Errors Reported By Instrument Assignment API: ');
834: FOR i in 1 .. l_msg_count LOOP

Line 831: l_return_status = fnd_api.g_ret_sts_unexp_error THEN

827: arp_standard.debug('IBY IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment API Return Status = ' || l_return_status);
828: x_return_status := l_return_status ;
829:
830: IF l_return_status = fnd_api.g_ret_sts_error OR
831: l_return_status = fnd_api.g_ret_sts_unexp_error THEN
832:
833: arp_standard.debug('Errors Reported By Instrument Assignment API: ');
834: FOR i in 1 .. l_msg_count LOOP
835: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false, l_msg_data,

Line 835: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false, l_msg_data,

831: l_return_status = fnd_api.g_ret_sts_unexp_error THEN
832:
833: arp_standard.debug('Errors Reported By Instrument Assignment API: ');
834: FOR i in 1 .. l_msg_count LOOP
835: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false, l_msg_data,
836: l_msg_count);
837: arp_standard.debug(l_msg_data);
838: END LOOP;
839: