DBA Data[Home] [Help]

APPS.ARP_EXT_BANK_PKG dependencies on FND_API

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

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

Line 86: IF l_return_status = fnd_api.g_ret_sts_error OR

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

Line 87: l_return_status = fnd_api.g_ret_sts_unexp_error THEN

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

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

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

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

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

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

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

Line 217: IF l_return_status = fnd_api.g_ret_sts_error OR

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

Line 218: l_return_status = fnd_api.g_ret_sts_unexp_error THEN

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

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

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

Line 261: IF l_return_status = fnd_api.g_ret_sts_error OR

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

Line 262: l_return_status = fnd_api.g_ret_sts_unexp_error THEN

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

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

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

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

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

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

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

Line 382: IF l_return_status = fnd_api.g_ret_sts_error OR

378: -- begin bug5594142
379: x_return_status := l_return_status ;
380: -- end bug5594142
381:
382: IF l_return_status = fnd_api.g_ret_sts_error OR
383: l_return_status = fnd_api.g_ret_sts_unexp_error THEN
384:
385: arp_standard.debug('Errors Reported By Bank API: ');
386: FOR i in 1 .. l_msg_count LOOP

Line 383: l_return_status = fnd_api.g_ret_sts_unexp_error THEN

379: x_return_status := l_return_status ;
380: -- end bug5594142
381:
382: IF l_return_status = fnd_api.g_ret_sts_error OR
383: l_return_status = fnd_api.g_ret_sts_unexp_error THEN
384:
385: arp_standard.debug('Errors Reported By Bank API: ');
386: FOR i in 1 .. l_msg_count LOOP
387: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false, l_msg_data,

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

383: l_return_status = fnd_api.g_ret_sts_unexp_error THEN
384:
385: arp_standard.debug('Errors Reported By Bank API: ');
386: FOR i in 1 .. l_msg_count LOOP
387: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false, l_msg_data,
388: l_msg_count);
389: arp_standard.debug(l_msg_data);
390: END LOOP;
391:

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

450: l_end_date iby_ext_bank_accounts_v.end_date%TYPE;
451: l_bank_acct_response iby_fndcpt_common_pub.result_rec_type;
452:
453: l_api_version NUMBER := 1.0;
454: l_init_msg_list VARCHAR2(30) DEFAULT FND_API.G_TRUE;
455: l_commit VARCHAR2(30) DEFAULT FND_API.G_FALSE;
456: l_return_status VARCHAR2(30);
457: l_msg_count NUMBER;
458: l_msg_data VARCHAR2(2000);

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

451: l_bank_acct_response iby_fndcpt_common_pub.result_rec_type;
452:
453: l_api_version NUMBER := 1.0;
454: l_init_msg_list VARCHAR2(30) DEFAULT FND_API.G_TRUE;
455: l_commit VARCHAR2(30) DEFAULT FND_API.G_FALSE;
456: l_return_status VARCHAR2(30);
457: l_msg_count NUMBER;
458: l_msg_data VARCHAR2(2000);
459:

Line 488: IF l_return_status = fnd_api.g_ret_sts_error OR

484: -- begin bug5594142
485: x_return_status := l_return_status ;
486: -- end bug5594142
487:
488: IF l_return_status = fnd_api.g_ret_sts_error OR
489: l_return_status = fnd_api.g_ret_sts_unexp_error THEN
490:
491: arp_standard.debug('Errors Reported By Bank API: ');
492: FOR i in 1 .. l_msg_count LOOP

Line 489: l_return_status = fnd_api.g_ret_sts_unexp_error THEN

485: x_return_status := l_return_status ;
486: -- end bug5594142
487:
488: IF l_return_status = fnd_api.g_ret_sts_error OR
489: l_return_status = fnd_api.g_ret_sts_unexp_error THEN
490:
491: arp_standard.debug('Errors Reported By Bank API: ');
492: FOR i in 1 .. l_msg_count LOOP
493: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false, l_msg_data,

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

489: l_return_status = fnd_api.g_ret_sts_unexp_error THEN
490:
491: arp_standard.debug('Errors Reported By Bank API: ');
492: FOR i in 1 .. l_msg_count LOOP
493: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false, l_msg_data,
494: l_msg_count);
495: arp_standard.debug(l_msg_data);
496: END LOOP;
497:

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

768: l_payer_context_rec IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
769: l_pmtInstrAssignment_rec IBY_FNDCPT_SETUP_PUB.PmtInstrAssignment_rec_type;
770: l_pmtInstrument_rec_type IBY_FNDCPT_SETUP_PUB.PmtInstrument_rec_type;
771: l_api_version NUMBER := 1.0;
772: l_init_msg_list VARCHAR2(30) DEFAULT FND_API.G_TRUE;
773: l_commit VARCHAR2(30) DEFAULT FND_API.G_FALSE;
774: l_return_status VARCHAR2(30);
775: l_msg_count NUMBER;
776: l_msg_data VARCHAR2(2000);

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

769: l_pmtInstrAssignment_rec IBY_FNDCPT_SETUP_PUB.PmtInstrAssignment_rec_type;
770: l_pmtInstrument_rec_type IBY_FNDCPT_SETUP_PUB.PmtInstrument_rec_type;
771: l_api_version NUMBER := 1.0;
772: l_init_msg_list VARCHAR2(30) DEFAULT FND_API.G_TRUE;
773: l_commit VARCHAR2(30) DEFAULT FND_API.G_FALSE;
774: l_return_status VARCHAR2(30);
775: l_msg_count NUMBER;
776: l_msg_data VARCHAR2(2000);
777: l_assign_id NUMBER;

Line 809: IF l_return_status = fnd_api.g_ret_sts_error OR

805: x_response => l_branch_response);
806: arp_standard.debug('IBY IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment API Return Status = ' || l_return_status);
807: x_return_status := l_return_status ;
808:
809: IF l_return_status = fnd_api.g_ret_sts_error OR
810: l_return_status = fnd_api.g_ret_sts_unexp_error THEN
811:
812: arp_standard.debug('Errors Reported By Instrument Assignment API: ');
813: FOR i in 1 .. l_msg_count LOOP

Line 810: l_return_status = fnd_api.g_ret_sts_unexp_error THEN

806: arp_standard.debug('IBY IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment API Return Status = ' || l_return_status);
807: x_return_status := l_return_status ;
808:
809: IF l_return_status = fnd_api.g_ret_sts_error OR
810: l_return_status = fnd_api.g_ret_sts_unexp_error THEN
811:
812: arp_standard.debug('Errors Reported By Instrument Assignment API: ');
813: FOR i in 1 .. l_msg_count LOOP
814: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false, l_msg_data,

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

810: l_return_status = fnd_api.g_ret_sts_unexp_error THEN
811:
812: arp_standard.debug('Errors Reported By Instrument Assignment API: ');
813: FOR i in 1 .. l_msg_count LOOP
814: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false, l_msg_data,
815: l_msg_count);
816: arp_standard.debug(l_msg_data);
817: END LOOP;
818: