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.

[Home] [Help]

APPS.ARP_EXT_BANK_PKG dependencies on STANDARD

Line 28: arp_standard.debug('arp_ext_bank_pkg.strip_white_spaces()+');

24: len_credit_card_num number := 0;
25: l_cc_num_char character_tab_typ;
26: BEGIN
27: IF PG_DEBUG in ('Y', 'C') THEN
28: arp_standard.debug('arp_ext_bank_pkg.strip_white_spaces()+');
29: END IF;
30:
31: SELECT lengthb(p_credit_card_num)
32: INTO len_credit_card_num

Line 50: arp_standard.debug('arp_ext_bank_pkg.strip_white_spaces()-');

46: END IF;
47: END LOOP;
48:
49: IF PG_DEBUG in ('Y', 'C') THEN
50: arp_standard.debug('arp_ext_bank_pkg.strip_white_spaces()-');
51: END IF;
52: EXCEPTION
53: when OTHERS then
54: raise;

Line 71: arp_standard.debug('arp_ext_bank_pkg.Branch_Num_Format(+)');

67: l_msg_data VARCHAR2(2000);
68: l_branch_number ce_bank_branches_v.branch_number%TYPE ;
69: l_value_out varchar2(100);
70: BEGIN
71: arp_standard.debug('arp_ext_bank_pkg.Branch_Num_Format(+)');
72: arp_standard.debug('branch number '||p_branch_number);
73: CE_VALIDATE_BANKINFO.GET_BRANCH_NUM_FORMAT
74: (X_COUNTRY_NAME => p_country_code,
75: X_BRANCH_NUMBER => p_branch_number,

Line 72: arp_standard.debug('branch number '||p_branch_number);

68: l_branch_number ce_bank_branches_v.branch_number%TYPE ;
69: l_value_out varchar2(100);
70: BEGIN
71: arp_standard.debug('arp_ext_bank_pkg.Branch_Num_Format(+)');
72: arp_standard.debug('branch number '||p_branch_number);
73: CE_VALIDATE_BANKINFO.GET_BRANCH_NUM_FORMAT
74: (X_COUNTRY_NAME => p_country_code,
75: X_BRANCH_NUMBER => p_branch_number,
76: X_VALUE_OUT => p_value_out,

Line 82: arp_standard.debug ('IBY BRANCH NUM FORMAT API Return Status = ' || l_return_status);

78: x_msg_count => l_msg_count,
79: x_msg_data => l_msg_data,
80: x_return_status => l_return_status);
81:
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

Line 83: arp_standard.debug('IBY BRANCH NUMB FORMAT API Branch Number = '||p_value_out);

79: x_msg_data => l_msg_data,
80: x_return_status => l_return_status);
81:
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

Line 89: arp_standard.debug('Errors Reported By IBY Branch Num Format API: ');

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,
92: l_msg_count);
93: arp_standard.debug(l_msg_data);

Line 93: arp_standard.debug(l_msg_data);

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
96: arp_standard.debug('Branch Number from BRANCH NUM FORMAT API : ' || p_value_out);
97: END IF;

Line 96: arp_standard.debug('Branch Number from BRANCH NUM FORMAT API : ' || p_value_out);

92: l_msg_count);
93: arp_standard.debug(l_msg_data);
94: END LOOP;
95: ELSE
96: arp_standard.debug('Branch Number from BRANCH NUM FORMAT API : ' || p_value_out);
97: END IF;
98: arp_standard.debug('arp_ext_bank_pkg.Branch_Num_Format(-)');
99: EXCEPTION
100: WHEN OTHERS THEN

Line 98: arp_standard.debug('arp_ext_bank_pkg.Branch_Num_Format(-)');

94: END LOOP;
95: ELSE
96: arp_standard.debug('Branch Number from BRANCH NUM FORMAT API : ' || p_value_out);
97: END IF;
98: arp_standard.debug('arp_ext_bank_pkg.Branch_Num_Format(-)');
99: EXCEPTION
100: WHEN OTHERS THEN
101: arp_standard.debug('exception in arp_ext_bank_pkg.Branch_Num_Format');
102: RAISE;

Line 101: arp_standard.debug('exception in arp_ext_bank_pkg.Branch_Num_Format');

97: END IF;
98: arp_standard.debug('arp_ext_bank_pkg.Branch_Num_Format(-)');
99: EXCEPTION
100: WHEN OTHERS THEN
101: arp_standard.debug('exception in arp_ext_bank_pkg.Branch_Num_Format');
102: RAISE;
103: END Branch_Num_Format;
104: -- end bug5594142
105:

Line 116: | arp_standard.debug |

112: | |
113: | SCOPE - PUBLIC |
114: | |
115: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
116: | arp_standard.debug |
117: | iby_ext_bankacct_pub.create_ext_bank |
118: | iby_ext_bankacct_pub.create_ext_bank_branch |
119: | |
120: | ARGUMENTS : IN: p_bank_name Bank Name |

Line 174: arp_standard.debug('arp_ext_bank_pkg.insert_ext_bank_branch(+)');

170: l_msg_data VARCHAR2(2000);
171:
172: BEGIN
173:
174: arp_standard.debug('arp_ext_bank_pkg.insert_ext_bank_branch(+)');
175:
176: fnd_profile.get(
177: name => 'HZ_GENERATE_PARTY_NUMBER',
178: val => l_profile_value);

Line 198: arp_standard.debug('Calling iby_ext_bankacct_pub.create_ext_bank(+)');

194: l_ext_bank_rec.country_code := 'US';
195: l_ext_bank_rec.description := p_description;
196:
197:
198: arp_standard.debug('Calling iby_ext_bankacct_pub.create_ext_bank(+)');
199:
200: iby_ext_bankacct_pub.create_ext_bank(
201: -- IN parameters
202: p_api_version => l_api_version,

Line 212: arp_standard.debug ('IBY Bank API Return Status = ' || l_return_status);

208: x_msg_count => l_msg_count,
209: x_msg_data => l_msg_data,
210: x_response => l_bank_response );
211:
212: arp_standard.debug ('IBY Bank API Return Status = ' || l_return_status);
213: -- begin bug5594142
214: x_return_status := l_return_status ;
215: -- end bug5594142
216:

Line 220: arp_standard.debug('Errors Reported By Bank API: ');

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,
223: l_msg_count);
224: arp_standard.debug(l_msg_data);

Line 224: arp_standard.debug(l_msg_data);

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:
227: ELSE
228: arp_standard.debug('Bank Party ID : ' || l_bank_party_id);

Line 228: arp_standard.debug('Bank Party ID : ' || l_bank_party_id);

224: arp_standard.debug(l_msg_data);
225: END LOOP;
226:
227: ELSE
228: arp_standard.debug('Bank Party ID : ' || l_bank_party_id);
229: END IF;
230:
231: x_bank_party_id := l_bank_party_id;
232:

Line 242: arp_standard.debug('Calling iby_ext_bankacct_pub.create_ext_bank_branch(+)');

238: l_ext_branch_rec.branch_number := p_branch_number;
239: l_ext_branch_rec.branch_type := 'ABA';
240: l_ext_branch_rec.description := p_description;
241:
242: arp_standard.debug('Calling iby_ext_bankacct_pub.create_ext_bank_branch(+)');
243:
244: iby_ext_bankacct_pub.create_ext_bank_branch(
245: -- IN parameters
246: p_api_version => l_api_version,

Line 256: arp_standard.debug ('IBY Bank Branch API Return Status = ' || l_return_status);

252: x_msg_count => l_msg_count,
253: x_msg_data => l_msg_data,
254: x_response => l_branch_response);
255:
256: arp_standard.debug ('IBY Bank Branch API Return Status = ' || l_return_status);
257: -- begin bug5594142
258: x_return_status := l_return_status ;
259: -- end bug5594142
260:

Line 264: arp_standard.debug('Errors Reported By Bank Branch API: ');

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,
267: l_msg_count);
268: arp_standard.debug(l_msg_data);

Line 268: arp_standard.debug(l_msg_data);

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
271: arp_standard.debug('Branch Party ID : ' || l_branch_party_id);
272: END IF;

Line 271: arp_standard.debug('Branch Party ID : ' || l_branch_party_id);

267: l_msg_count);
268: arp_standard.debug(l_msg_data);
269: END LOOP;
270: ELSE
271: arp_standard.debug('Branch Party ID : ' || l_branch_party_id);
272: END IF;
273:
274: -- put the profile value back to the original value if changed
275: IF (l_profile_value = 'N') THEN

Line 283: arp_standard.debug('arp_ext_bank_pkg.insert_ext_bank_branch(-)');

279: END IF;
280:
281: x_branch_party_id := l_branch_party_id;
282:
283: arp_standard.debug('arp_ext_bank_pkg.insert_ext_bank_branch(-)');
284:
285: EXCEPTION
286: WHEN OTHERS THEN
287: arp_standard.debug('exception in arp_ext_bank_pkg.insert_ext_bank_branch');

Line 287: arp_standard.debug('exception in arp_ext_bank_pkg.insert_ext_bank_branch');

283: arp_standard.debug('arp_ext_bank_pkg.insert_ext_bank_branch(-)');
284:
285: EXCEPTION
286: WHEN OTHERS THEN
287: arp_standard.debug('exception in arp_ext_bank_pkg.insert_ext_bank_branch');
288: RAISE;
289:
290: END insert_ext_bank_branch;
291:

Line 301: | arp_standard.debug |

297: | |
298: | SCOPE - PUBLIC |
299: | |
300: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
301: | arp_standard.debug |
302: | iby_ext_bankacct_pub.create_ext_bank_acc |
303: | |
304: | ARGUMENTS : IN: |
305: | p_bank_account_name Account Name |

Line 346: arp_standard.debug('arp_ext_bank_pkg.insert_bank_account(+)');

342: l_msg_count NUMBER;
343: l_msg_data VARCHAR2(2000);
344:
345: BEGIN
346: arp_standard.debug('arp_ext_bank_pkg.insert_bank_account(+)');
347:
348: /* Bug 6799655 : Get the party_id from cust_account_id supplied */
349: SELECT party_id INTO l_party_id
350: FROM hz_cust_accounts

Line 363: arp_standard.debug('Calling iby_ext_bankacct_pub.create_ext_bank_acct(+)');

359: l_ext_bank_acct_rec.country_code := 'US';
360: l_ext_bank_acct_rec.description := p_description;
361:
362:
363: arp_standard.debug('Calling iby_ext_bankacct_pub.create_ext_bank_acct(+)');
364:
365: iby_ext_bankacct_pub.create_ext_bank_acct(
366: -- IN parameters
367: p_api_version => l_api_version,

Line 377: arp_standard.debug ('IBY Bank API Return Status = ' || l_return_status);

373: x_msg_count => l_msg_count,
374: x_msg_data => l_msg_data,
375: x_response => l_bank_acct_response );
376:
377: arp_standard.debug ('IBY Bank API Return Status = ' || l_return_status);
378: -- begin bug5594142
379: x_return_status := l_return_status ;
380: -- end bug5594142
381:

Line 385: arp_standard.debug('Errors Reported By Bank API: ');

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,
388: l_msg_count);
389: arp_standard.debug(l_msg_data);

Line 389: arp_standard.debug(l_msg_data);

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:
392: ELSE
393: arp_standard.debug('Bank Account ID : ' || l_bank_account_id);

Line 393: arp_standard.debug('Bank Account ID : ' || l_bank_account_id);

389: arp_standard.debug(l_msg_data);
390: END LOOP;
391:
392: ELSE
393: arp_standard.debug('Bank Account ID : ' || l_bank_account_id);
394: END IF;
395:
396: x_bank_account_id:= l_bank_account_id;
397: arp_standard.debug('arp_ext_bank_pkg.insert_bank_account(-)');

Line 397: arp_standard.debug('arp_ext_bank_pkg.insert_bank_account(-)');

393: arp_standard.debug('Bank Account ID : ' || l_bank_account_id);
394: END IF;
395:
396: x_bank_account_id:= l_bank_account_id;
397: arp_standard.debug('arp_ext_bank_pkg.insert_bank_account(-)');
398: EXCEPTION
399: WHEN NO_DATA_FOUND THEN
400: arp_standard.debug('Customer_id is invalid');
401: RAISE;

Line 400: arp_standard.debug('Customer_id is invalid');

396: x_bank_account_id:= l_bank_account_id;
397: arp_standard.debug('arp_ext_bank_pkg.insert_bank_account(-)');
398: EXCEPTION
399: WHEN NO_DATA_FOUND THEN
400: arp_standard.debug('Customer_id is invalid');
401: RAISE;
402: WHEN OTHERS THEN
403: arp_standard.debug('exception in arp_ext_bank_pkg.insert_bank_account');
404: RAISE;

Line 403: arp_standard.debug('exception in arp_ext_bank_pkg.insert_bank_account');

399: WHEN NO_DATA_FOUND THEN
400: arp_standard.debug('Customer_id is invalid');
401: RAISE;
402: WHEN OTHERS THEN
403: arp_standard.debug('exception in arp_ext_bank_pkg.insert_bank_account');
404: RAISE;
405: END insert_bank_account;
406:
407:

Line 417: | arp_standard.debug |

413: | routing_number and account_number. |
414: | SCOPE - PUBLIC |
415: | |
416: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
417: | arp_standard.debug |
418: | iby_ext_bankacct_pub.check_ext_acct_exist |
419: | |
420: | ARGUMENTS : IN: |
421: | p_routing_number Routing Number |

Line 461: arp_standard.debug('arp_ext_bank_pkg.check_bank_account(+)');

457: l_msg_count NUMBER;
458: l_msg_data VARCHAR2(2000);
459:
460: BEGIN
461: arp_standard.debug('arp_ext_bank_pkg.check_bank_account(+)');
462:
463:
464: iby_ext_bankacct_pub.check_ext_acct_exist(
465: -- IN parameters

Line 483: arp_standard.debug ('IBY Bank API Return Status = ' || l_return_status);

479: x_msg_count => l_msg_count,
480: x_msg_data => l_msg_data,
481: x_response => l_bank_acct_response );
482:
483: arp_standard.debug ('IBY Bank API Return Status = ' || l_return_status);
484: -- begin bug5594142
485: x_return_status := l_return_status ;
486: -- end bug5594142
487:

Line 491: arp_standard.debug('Errors Reported By Bank API: ');

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,
494: l_msg_count);
495: arp_standard.debug(l_msg_data);

Line 495: arp_standard.debug(l_msg_data);

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:
498: ELSE
499: arp_standard.debug('Bank Account ID : ' || l_bank_account_id);

Line 499: arp_standard.debug('Bank Account ID : ' || l_bank_account_id);

495: arp_standard.debug(l_msg_data);
496: END LOOP;
497:
498: ELSE
499: arp_standard.debug('Bank Account ID : ' || l_bank_account_id);
500: arp_standard.debug('Start Date : ' || l_start_date );
501: arp_standard.debug('End Date : ' || l_end_date );
502: END IF;
503:

Line 500: arp_standard.debug('Start Date : ' || l_start_date );

496: END LOOP;
497:
498: ELSE
499: arp_standard.debug('Bank Account ID : ' || l_bank_account_id);
500: arp_standard.debug('Start Date : ' || l_start_date );
501: arp_standard.debug('End Date : ' || l_end_date );
502: END IF;
503:
504: x_bank_account_id:= l_bank_account_id;

Line 501: arp_standard.debug('End Date : ' || l_end_date );

497:
498: ELSE
499: arp_standard.debug('Bank Account ID : ' || l_bank_account_id);
500: arp_standard.debug('Start Date : ' || l_start_date );
501: arp_standard.debug('End Date : ' || l_end_date );
502: END IF;
503:
504: x_bank_account_id:= l_bank_account_id;
505: x_start_date := l_start_date;

Line 507: arp_standard.debug('arp_ext_bank_pkg.check_bank_account(-)');

503:
504: x_bank_account_id:= l_bank_account_id;
505: x_start_date := l_start_date;
506: x_end_date := l_end_date;
507: arp_standard.debug('arp_ext_bank_pkg.check_bank_account(-)');
508: EXCEPTION
509: WHEN OTHERS THEN
510: arp_standard.debug('exception in arp_ext_bank_pkg.check_bank_account');
511: RAISE;

Line 510: arp_standard.debug('exception in arp_ext_bank_pkg.check_bank_account');

506: x_end_date := l_end_date;
507: arp_standard.debug('arp_ext_bank_pkg.check_bank_account(-)');
508: EXCEPTION
509: WHEN OTHERS THEN
510: arp_standard.debug('exception in arp_ext_bank_pkg.check_bank_account');
511: RAISE;
512: END check_bank_account;
513:
514: /*===========================================================================+

Line 523: | arp_standard.debug |

519: | found, then a new one is created. |
520: | SCOPE - PUBLIC |
521: | |
522: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
523: | arp_standard.debug |
524: | iby_ext_bankacct_pub.create_ext_bank_acc |
525: | |
526: | ARGUMENTS : IN: |
527: | p_routing_number Routing Number |

Line 573: arp_standard.debug('arp_ext_bank_pkg.create_bank_branch_acc(+)');

569: l_party_id NUMBER;
570: l_count NUMBER;
571:
572: BEGIN
573: arp_standard.debug('arp_ext_bank_pkg.create_bank_branch_acc(+)');
574: /*-----------------------------------------------------+
575: | Remove non-digit characters from the routing number |
576: +-----------------------------------------------------*/
577: strip_white_spaces(p_routing_number,l_routing_number);

Line 605: arp_standard.debug('Bank and Branch exist for this Routing Number'

601: l_branch_party_id := bank_branch_rec.branch_party_id;
602: x_bank_party_id := l_bank_party_id;
603: x_branch_party_id := l_branch_party_id;
604:
605: arp_standard.debug('Bank and Branch exist for this Routing Number'
606: ||p_routing_number);
607: arp_standard.debug('Bank Id '||x_bank_party_id);
608: arp_standard.debug('Branch Id '||x_branch_party_id);
609: /*-----------------------------------------------------------+

Line 607: arp_standard.debug('Bank Id '||x_bank_party_id);

603: x_branch_party_id := l_branch_party_id;
604:
605: arp_standard.debug('Bank and Branch exist for this Routing Number'
606: ||p_routing_number);
607: arp_standard.debug('Bank Id '||x_bank_party_id);
608: arp_standard.debug('Branch Id '||x_branch_party_id);
609: /*-----------------------------------------------------------+
610: | Try to find Account Id based on routing account number |
611: +-----------------------------------------------------------*/

Line 608: arp_standard.debug('Branch Id '||x_branch_party_id);

604:
605: arp_standard.debug('Bank and Branch exist for this Routing Number'
606: ||p_routing_number);
607: arp_standard.debug('Bank Id '||x_bank_party_id);
608: arp_standard.debug('Branch Id '||x_branch_party_id);
609: /*-----------------------------------------------------------+
610: | Try to find Account Id based on routing account number |
611: +-----------------------------------------------------------*/
612: check_bank_account(

Line 628: arp_standard.debug('Bank Account ID : ' || l_bank_account_id);

624: x_return_status := l_return_Status ;
625: If l_bank_account_id is NOT NULL
626: THEN
627: x_bank_account_id := l_bank_account_id;
628: arp_standard.debug('Bank Account ID : ' || l_bank_account_id);
629: ELSE
630: /*-----------------------------------------------------+
631: | Account not exists for this bank |
632: +-----------------------------------------------------*/

Line 649: arp_standard.debug('Bank Account ID : ' || l_bank_account_id);

645: x_return_status => l_return_status);
646:
647: x_return_status := l_return_status ;
648: x_bank_account_id := l_bank_account_id;
649: arp_standard.debug('Bank Account ID : ' || l_bank_account_id);
650: END IF;
651:
652: ELSE
653: CLOSE bank_branch_cur;

Line 657: arp_standard.debug('Bank and Branch does not exist for this Routing

653: CLOSE bank_branch_cur;
654: /*------------------------------------------------------+
655: | If bank branch could not be found, create new branch |
656: +------------------------------------------------------*/
657: arp_standard.debug('Bank and Branch does not exist for this Routing
658: Number'||p_routing_number);
659: Insert_ext_bank_branch(
660: -- IN parameters
661: p_bank_name => p_routing_number,

Line 675: arp_standard.debug('Bank ID : ' || l_bank_party_id);

671: x_return_status := l_return_status ;
672: x_bank_party_id := l_bank_party_id;
673: x_branch_party_id := l_branch_party_id;
674:
675: arp_standard.debug('Bank ID : ' || l_bank_party_id);
676: arp_standard.debug('Branch Party ID : ' || l_branch_party_id);
677:
678: /*-----------------------------------------------------+
679: | Now create bank account based on the bank branch |

Line 676: arp_standard.debug('Branch Party ID : ' || l_branch_party_id);

672: x_bank_party_id := l_bank_party_id;
673: x_branch_party_id := l_branch_party_id;
674:
675: arp_standard.debug('Bank ID : ' || l_bank_party_id);
676: arp_standard.debug('Branch Party ID : ' || l_branch_party_id);
677:
678: /*-----------------------------------------------------+
679: | Now create bank account based on the bank branch |
680: +-----------------------------------------------------*/

Line 700: arp_standard.debug('Bank Account ID : ' || l_bank_account_id);

696: x_return_status => l_return_status);
697:
698: x_return_status := l_return_status ;
699: x_bank_account_id := l_bank_account_id;
700: arp_standard.debug('Bank Account ID : ' || l_bank_account_id);
701: END IF;
702: END IF;
703:
704: -- Bug 7346354 - Start

Line 727: arp_standard.debug('l_assign_id '||l_assign_id);

723: x_return_status => l_return_status);
724: END IF;
725: END IF;
726: -- Bug 7346354 - End
727: arp_standard.debug('l_assign_id '||l_assign_id);
728: arp_standard.debug('arp_ext_bank_pkg.create_bank_branch_acc(-)');
729: EXCEPTION
730: WHEN OTHERS THEN
731: arp_standard.debug('exception in arp_ext_bank_pkg.create_bank_branch_acc');

Line 728: arp_standard.debug('arp_ext_bank_pkg.create_bank_branch_acc(-)');

724: END IF;
725: END IF;
726: -- Bug 7346354 - End
727: arp_standard.debug('l_assign_id '||l_assign_id);
728: arp_standard.debug('arp_ext_bank_pkg.create_bank_branch_acc(-)');
729: EXCEPTION
730: WHEN OTHERS THEN
731: arp_standard.debug('exception in arp_ext_bank_pkg.create_bank_branch_acc');
732: RAISE;

Line 731: arp_standard.debug('exception in arp_ext_bank_pkg.create_bank_branch_acc');

727: arp_standard.debug('l_assign_id '||l_assign_id);
728: arp_standard.debug('arp_ext_bank_pkg.create_bank_branch_acc(-)');
729: EXCEPTION
730: WHEN OTHERS THEN
731: arp_standard.debug('exception in arp_ext_bank_pkg.create_bank_branch_acc');
732: RAISE;
733: END create_bank_branch_acc;
734:
735: -- Bug 7346354 - Start

Line 745: | arp_standard.debug |

741: | bank account. |
742: | SCOPE - PUBLIC |
743: | |
744: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
745: | arp_standard.debug |
746: | IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment |
747: | |
748: | ARGUMENTS : IN: |
749: | p_party_id Party Id |

Line 781: arp_standard.debug('arp_ext_bank_pkg.insert_acct_instr_assignment(+)');

777: l_assign_id NUMBER;
778: l_branch_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
779:
780: BEGIN
781: arp_standard.debug('arp_ext_bank_pkg.insert_acct_instr_assignment(+)');
782: l_payer_context_rec.Payment_Function := 'CUSTOMER_PAYMENT';
783: l_payer_context_rec.Party_Id := p_party_id;
784: l_payer_context_rec.Cust_Account_Id := p_customer_id;
785:

Line 791: arp_standard.debug('Calling IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment(+)');

787: l_pmtInstrument_rec_type.Instrument_Id := p_instr_id;
788:
789: l_pmtInstrAssignment_rec.Instrument := l_pmtInstrument_rec_type;
790:
791: arp_standard.debug('Calling IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment(+)');
792:
793: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment(
794: -- IN parameters
795: p_api_version => l_api_version,

Line 806: arp_standard.debug('IBY IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment API Return Status = ' || l_return_status);

802: x_return_status => l_return_status,
803: x_msg_count => l_msg_count,
804: x_msg_data => l_msg_data,
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

Line 812: arp_standard.debug('Errors Reported By Instrument Assignment API: ');

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,
815: l_msg_count);
816: arp_standard.debug(l_msg_data);

Line 816: arp_standard.debug(l_msg_data);

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:
819: ELSE
820: arp_standard.debug('Instrument Assign Id : ' || l_assign_id);

Line 820: arp_standard.debug('Instrument Assign Id : ' || l_assign_id);

816: arp_standard.debug(l_msg_data);
817: END LOOP;
818:
819: ELSE
820: arp_standard.debug('Instrument Assign Id : ' || l_assign_id);
821: END IF;
822: x_instr_assign_id := l_assign_id;
823: arp_standard.debug('arp_ext_bank_pkg.insert_acct_instr_assignment(-)');
824: EXCEPTION

Line 823: arp_standard.debug('arp_ext_bank_pkg.insert_acct_instr_assignment(-)');

819: ELSE
820: arp_standard.debug('Instrument Assign Id : ' || l_assign_id);
821: END IF;
822: x_instr_assign_id := l_assign_id;
823: arp_standard.debug('arp_ext_bank_pkg.insert_acct_instr_assignment(-)');
824: EXCEPTION
825: WHEN OTHERS THEN
826: arp_standard.debug('exception in arp_ext_bank_pkg.insert_acct_instr_assignment');
827: RAISE;

Line 826: arp_standard.debug('exception in arp_ext_bank_pkg.insert_acct_instr_assignment');

822: x_instr_assign_id := l_assign_id;
823: arp_standard.debug('arp_ext_bank_pkg.insert_acct_instr_assignment(-)');
824: EXCEPTION
825: WHEN OTHERS THEN
826: arp_standard.debug('exception in arp_ext_bank_pkg.insert_acct_instr_assignment');
827: RAISE;
828: END insert_acct_instr_assignment;
829: -- Bug 7346354 - End
830:

Line 842: | arp_standard.debug |

838: | |
839: | SCOPE - PUBLIC |
840: | |
841: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
842: | arp_standard.debug |
843: | |
844: | |
845: | ARGUMENTS : IN: p_customer_id |
846: | p_site_use_id |

Line 907: arp_standard.debug('Primary Only..');

903: sql_stmt := site_sql_stmt;
904: --
905: IF p_primary THEN
906: --
907: arp_standard.debug('Primary Only..');
908: sql_stmt := sql_stmt || CRLF || primary_stmt;
909: --
910: END IF;
911: --

Line 913: arp_standard.debug('In CC Only..');

909: --
910: END IF;
911: --
912: IF p_cc_only THEN
913: arp_standard.debug('In CC Only..');
914: sql_stmt := sql_stmt || CRLF || cc_only_stmt;
915: null;
916: END IF;
917: --

Line 919: arp_standard.debug('Pay Method Only..');

915: null;
916: END IF;
917: --
918: IF p_pay_method_id IS NOT NULL THEN
919: arp_standard.debug('Pay Method Only..');
920: sql_stmt := sql_stmt || CRLF || pay_stmt;
921: null;
922: END IF;
923: --

Line 933: arp_standard.debug('In CC Only..');

929: --
930: END IF;
931: --
932: IF p_cc_only THEN
933: arp_standard.debug('In CC Only..');
934: sql_stmt := sql_stmt || CRLF || cc_only_stmt;
935: null;
936: END IF;
937: --

Line 939: arp_standard.debug('Pay Method Only..');

935: null;
936: END IF;
937: --
938: IF p_pay_method_id IS NOT NULL THEN
939: arp_standard.debug('Pay Method Only..');
940: sql_stmt := sql_stmt || CRLF || pay_stmt;
941: null;
942: END IF;
943: --

Line 944: arp_standard.debug(sql_stmt);

940: sql_stmt := sql_stmt || CRLF || pay_stmt;
941: null;
942: END IF;
943: --
944: arp_standard.debug(sql_stmt);
945:
946: IF p_pay_method_id IS NOT NULL THEN
947: OPEN pri_pay_method FOR sql_stmt USING p_customer_id, p_site_use_id, l_as_of_date,
948: l_as_of_date, p_pay_method_id,