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.ARP_EXT_BANK_PKG dependencies on STANDARD

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 94: arp_standard.debug(l_msg_data);

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

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

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

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

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

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

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

Line 117: | arp_standard.debug |

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

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

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

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

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

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

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

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

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

Line 225: arp_standard.debug(l_msg_data);

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

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

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

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

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

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

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

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

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

Line 269: arp_standard.debug(l_msg_data);

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

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

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

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

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

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

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

Line 302: | arp_standard.debug |

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

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

345: l_msg_count NUMBER;
346: l_msg_data VARCHAR2(2000);
347:
348: BEGIN
349: arp_standard.debug('arp_ext_bank_pkg.insert_bank_account(+)');
350:
351: /* Bug 6799655 : Get the party_id from cust_account_id supplied */
352: IF p_customer_id IS NOT NULL THEN
353: SELECT party_id INTO l_party_id

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

369: l_ext_bank_acct_rec.start_date := p_start_date;
370:
371: -- fnd_file.put_line(FND_FILE.LOG,'The start date is ' || p_start_date);
372:
373: arp_standard.debug('Calling iby_ext_bankacct_pub.create_ext_bank_acct(+)');
374:
375: iby_ext_bankacct_pub.create_ext_bank_acct(
376: -- IN parameters
377: p_api_version => l_api_version,

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

383: x_msg_count => l_msg_count,
384: x_msg_data => l_msg_data,
385: x_response => l_bank_acct_response );
386:
387: arp_standard.debug ('IBY Bank API Return Status = ' || l_return_status);
388: -- begin bug5594142
389: x_return_status := l_return_status ;
390: -- end bug5594142
391:

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

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

Line 399: arp_standard.debug(l_msg_data);

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

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

399: arp_standard.debug(l_msg_data);
400: END LOOP;
401:
402: ELSE
403: arp_standard.debug('Bank Account ID : ' || l_bank_account_id);
404: END IF;
405:
406: x_bank_account_id:= l_bank_account_id;
407: arp_standard.debug('arp_ext_bank_pkg.insert_bank_account(-)');

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

403: arp_standard.debug('Bank Account ID : ' || l_bank_account_id);
404: END IF;
405:
406: x_bank_account_id:= l_bank_account_id;
407: arp_standard.debug('arp_ext_bank_pkg.insert_bank_account(-)');
408: EXCEPTION
409: WHEN NO_DATA_FOUND THEN
410: arp_standard.debug('Customer_id is invalid');
411: RAISE;

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

406: x_bank_account_id:= l_bank_account_id;
407: arp_standard.debug('arp_ext_bank_pkg.insert_bank_account(-)');
408: EXCEPTION
409: WHEN NO_DATA_FOUND THEN
410: arp_standard.debug('Customer_id is invalid');
411: RAISE;
412: WHEN OTHERS THEN
413: arp_standard.debug('exception in arp_ext_bank_pkg.insert_bank_account');
414: RAISE;

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

409: WHEN NO_DATA_FOUND THEN
410: arp_standard.debug('Customer_id is invalid');
411: RAISE;
412: WHEN OTHERS THEN
413: arp_standard.debug('exception in arp_ext_bank_pkg.insert_bank_account');
414: RAISE;
415: END insert_bank_account;
416:
417:

Line 427: | arp_standard.debug |

423: | routing_number and account_number. |
424: | SCOPE - PUBLIC |
425: | |
426: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
427: | arp_standard.debug |
428: | iby_ext_bankacct_pub.check_ext_acct_exist |
429: | |
430: | ARGUMENTS : IN: |
431: | p_routing_number Routing Number |

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

468: l_msg_count NUMBER;
469: l_msg_data VARCHAR2(2000);
470:
471: BEGIN
472: arp_standard.debug('arp_ext_bank_pkg.check_bank_account(+)');
473:
474:
475: iby_ext_bankacct_pub.check_ext_acct_exist(
476: -- IN parameters

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

490: x_msg_count => l_msg_count,
491: x_msg_data => l_msg_data,
492: x_response => l_bank_acct_response );
493:
494: arp_standard.debug ('IBY Bank API Return Status = ' || l_return_status);
495: -- begin bug5594142
496: x_return_status := l_return_status ;
497: -- end bug5594142
498:

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

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

Line 506: arp_standard.debug(l_msg_data);

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

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

506: arp_standard.debug(l_msg_data);
507: END LOOP;
508:
509: ELSE
510: arp_standard.debug('Bank Account ID : ' || l_bank_account_id);
511: arp_standard.debug('Start Date : ' || l_start_date );
512: arp_standard.debug('End Date : ' || l_end_date );
513: END IF;
514:

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

507: END LOOP;
508:
509: ELSE
510: arp_standard.debug('Bank Account ID : ' || l_bank_account_id);
511: arp_standard.debug('Start Date : ' || l_start_date );
512: arp_standard.debug('End Date : ' || l_end_date );
513: END IF;
514:
515: x_bank_account_id:= l_bank_account_id;

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

508:
509: ELSE
510: arp_standard.debug('Bank Account ID : ' || l_bank_account_id);
511: arp_standard.debug('Start Date : ' || l_start_date );
512: arp_standard.debug('End Date : ' || l_end_date );
513: END IF;
514:
515: x_bank_account_id:= l_bank_account_id;
516: x_start_date := l_start_date;

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

514:
515: x_bank_account_id:= l_bank_account_id;
516: x_start_date := l_start_date;
517: x_end_date := l_end_date;
518: arp_standard.debug('arp_ext_bank_pkg.check_bank_account(-)');
519: EXCEPTION
520: WHEN OTHERS THEN
521: arp_standard.debug('exception in arp_ext_bank_pkg.check_bank_account');
522: RAISE;

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

517: x_end_date := l_end_date;
518: arp_standard.debug('arp_ext_bank_pkg.check_bank_account(-)');
519: EXCEPTION
520: WHEN OTHERS THEN
521: arp_standard.debug('exception in arp_ext_bank_pkg.check_bank_account');
522: RAISE;
523: END check_bank_account;
524:
525: /*===========================================================================+

Line 534: | arp_standard.debug |

530: | found, then a new one is created. |
531: | SCOPE - PUBLIC |
532: | |
533: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
534: | arp_standard.debug |
535: | iby_ext_bankacct_pub.create_ext_bank_acc |
536: | |
537: | ARGUMENTS : IN: |
538: | p_routing_number Routing Number |

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

582: l_party_id NUMBER;
583: l_count NUMBER;
584:
585: BEGIN
586: arp_standard.debug('arp_ext_bank_pkg.create_bank_branch_acc(+)');
587: /*-----------------------------------------------------+
588: | Remove non-digit characters from the routing number |
589: +-----------------------------------------------------*/
590: strip_white_spaces(p_routing_number,l_routing_number);

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

614: l_branch_party_id := bank_branch_rec.branch_party_id;
615: x_bank_party_id := l_bank_party_id;
616: x_branch_party_id := l_branch_party_id;
617:
618: arp_standard.debug('Bank and Branch exist for this Routing Number'
619: ||p_routing_number);
620: arp_standard.debug('Bank Id '||x_bank_party_id);
621: arp_standard.debug('Branch Id '||x_branch_party_id);
622: /*-----------------------------------------------------------+

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

616: x_branch_party_id := l_branch_party_id;
617:
618: arp_standard.debug('Bank and Branch exist for this Routing Number'
619: ||p_routing_number);
620: arp_standard.debug('Bank Id '||x_bank_party_id);
621: arp_standard.debug('Branch Id '||x_branch_party_id);
622: /*-----------------------------------------------------------+
623: | Try to find Account Id based on routing account number |
624: +-----------------------------------------------------------*/

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

617:
618: arp_standard.debug('Bank and Branch exist for this Routing Number'
619: ||p_routing_number);
620: arp_standard.debug('Bank Id '||x_bank_party_id);
621: arp_standard.debug('Branch Id '||x_branch_party_id);
622: /*-----------------------------------------------------------+
623: | Try to find Account Id based on routing account number |
624: +-----------------------------------------------------------*/
625: check_bank_account(

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

638: x_return_status := l_return_Status ;
639: If l_bank_account_id is NOT NULL
640: THEN
641: x_bank_account_id := l_bank_account_id;
642: arp_standard.debug('Bank Account ID : ' || l_bank_account_id);
643: ELSE
644: /*-----------------------------------------------------+
645: | Account not exists for this bank |
646: +-----------------------------------------------------*/

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

661: x_return_status => l_return_status);
662:
663: x_return_status := l_return_status ;
664: x_bank_account_id := l_bank_account_id;
665: arp_standard.debug('Bank Account ID : ' || l_bank_account_id);
666: END IF;
667:
668: ELSE
669: CLOSE bank_branch_cur;

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

669: CLOSE bank_branch_cur;
670: /*------------------------------------------------------+
671: | If bank branch could not be found, create new branch |
672: +------------------------------------------------------*/
673: arp_standard.debug('Bank and Branch does not exist for this Routing
674: Number'||p_routing_number);
675: Insert_ext_bank_branch(
676: -- IN parameters
677: p_bank_name => p_routing_number,

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

687: x_return_status := l_return_status ;
688: x_bank_party_id := l_bank_party_id;
689: x_branch_party_id := l_branch_party_id;
690:
691: arp_standard.debug('Bank ID : ' || l_bank_party_id);
692: arp_standard.debug('Branch Party ID : ' || l_branch_party_id);
693:
694: /*-----------------------------------------------------+
695: | Now create bank account based on the bank branch |

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

688: x_bank_party_id := l_bank_party_id;
689: x_branch_party_id := l_branch_party_id;
690:
691: arp_standard.debug('Bank ID : ' || l_bank_party_id);
692: arp_standard.debug('Branch Party ID : ' || l_branch_party_id);
693:
694: /*-----------------------------------------------------+
695: | Now create bank account based on the bank branch |
696: +-----------------------------------------------------*/

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

714: x_return_status => l_return_status);
715:
716: x_return_status := l_return_status ;
717: x_bank_account_id := l_bank_account_id;
718: arp_standard.debug('Bank Account ID : ' || l_bank_account_id);
719: END IF;
720: END IF;
721:
722: -- Bug 7346354 - Start

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

742: x_return_status => l_return_status);
743: END IF;
744: END IF;
745: -- Bug 7346354 - End
746: arp_standard.debug('l_assign_id '||l_assign_id);
747: arp_standard.debug('arp_ext_bank_pkg.create_bank_branch_acc(-)');
748: EXCEPTION
749: WHEN OTHERS THEN
750: arp_standard.debug('exception in arp_ext_bank_pkg.create_bank_branch_acc');

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

743: END IF;
744: END IF;
745: -- Bug 7346354 - End
746: arp_standard.debug('l_assign_id '||l_assign_id);
747: arp_standard.debug('arp_ext_bank_pkg.create_bank_branch_acc(-)');
748: EXCEPTION
749: WHEN OTHERS THEN
750: arp_standard.debug('exception in arp_ext_bank_pkg.create_bank_branch_acc');
751: RAISE;

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

746: arp_standard.debug('l_assign_id '||l_assign_id);
747: arp_standard.debug('arp_ext_bank_pkg.create_bank_branch_acc(-)');
748: EXCEPTION
749: WHEN OTHERS THEN
750: arp_standard.debug('exception in arp_ext_bank_pkg.create_bank_branch_acc');
751: RAISE;
752: END create_bank_branch_acc;
753:
754: -- Bug 7346354 - Start

Line 764: | arp_standard.debug |

760: | bank account. |
761: | SCOPE - PUBLIC |
762: | |
763: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
764: | arp_standard.debug |
765: | IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment |
766: | |
767: | ARGUMENTS : IN: |
768: | p_party_id Party Id |

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

797: l_assign_id NUMBER;
798: l_branch_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
799:
800: BEGIN
801: arp_standard.debug('arp_ext_bank_pkg.insert_acct_instr_assignment(+)');
802: l_payer_context_rec.Payment_Function := 'CUSTOMER_PAYMENT';
803: l_payer_context_rec.Party_Id := p_party_id;
804: l_payer_context_rec.Cust_Account_Id := p_customer_id;
805:

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

808:
809: l_pmtInstrAssignment_rec.Instrument := l_pmtInstrument_rec_type;
810: l_pmtInstrAssignment_rec.Start_date := p_assignment_start_date;
811:
812: arp_standard.debug('Calling IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment(+)');
813:
814: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment(
815: -- IN parameters
816: p_api_version => l_api_version,

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

823: x_return_status => l_return_status,
824: x_msg_count => l_msg_count,
825: x_msg_data => l_msg_data,
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

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

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

Line 837: arp_standard.debug(l_msg_data);

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

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

837: arp_standard.debug(l_msg_data);
838: END LOOP;
839:
840: ELSE
841: arp_standard.debug('Instrument Assign Id : ' || l_assign_id);
842: END IF;
843: x_instr_assign_id := l_assign_id;
844: arp_standard.debug('arp_ext_bank_pkg.insert_acct_instr_assignment(-)');
845: EXCEPTION

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

840: ELSE
841: arp_standard.debug('Instrument Assign Id : ' || l_assign_id);
842: END IF;
843: x_instr_assign_id := l_assign_id;
844: arp_standard.debug('arp_ext_bank_pkg.insert_acct_instr_assignment(-)');
845: EXCEPTION
846: WHEN OTHERS THEN
847: arp_standard.debug('exception in arp_ext_bank_pkg.insert_acct_instr_assignment');
848: RAISE;

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

843: x_instr_assign_id := l_assign_id;
844: arp_standard.debug('arp_ext_bank_pkg.insert_acct_instr_assignment(-)');
845: EXCEPTION
846: WHEN OTHERS THEN
847: arp_standard.debug('exception in arp_ext_bank_pkg.insert_acct_instr_assignment');
848: RAISE;
849: END insert_acct_instr_assignment;
850: -- Bug 7346354 - End
851:

Line 863: | arp_standard.debug |

859: | |
860: | SCOPE - PUBLIC |
861: | |
862: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
863: | arp_standard.debug |
864: | |
865: | |
866: | ARGUMENTS : IN: p_customer_id |
867: | p_site_use_id |

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

924: sql_stmt := site_sql_stmt;
925: --
926: IF p_primary THEN
927: --
928: arp_standard.debug('Primary Only..');
929: sql_stmt := sql_stmt || CRLF || primary_stmt;
930: --
931: END IF;
932: --

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

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

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

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

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

950: --
951: END IF;
952: --
953: IF p_cc_only THEN
954: arp_standard.debug('In CC Only..');
955: sql_stmt := sql_stmt || CRLF || cc_only_stmt;
956: null;
957: END IF;
958: --

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

956: null;
957: END IF;
958: --
959: IF p_pay_method_id IS NOT NULL THEN
960: arp_standard.debug('Pay Method Only..');
961: sql_stmt := sql_stmt || CRLF || pay_stmt;
962: null;
963: END IF;
964: --

Line 965: arp_standard.debug(sql_stmt);

961: sql_stmt := sql_stmt || CRLF || pay_stmt;
962: null;
963: END IF;
964: --
965: arp_standard.debug(sql_stmt);
966:
967: IF p_pay_method_id IS NOT NULL THEN
968: OPEN pri_pay_method FOR sql_stmt USING p_customer_id, p_site_use_id, l_as_of_date,
969: l_as_of_date, p_pay_method_id,

Line 1120: arp_standard.debug('Default Country to create bank accounts for New MICR Numbers: '||g_default_country);

1116: BEGIN
1117: SELECT NVL(DEFAULT_COUNTRY, 'US') INTO g_default_country
1118: FROM AR_SYSTEM_PARAMETERS;
1119:
1120: arp_standard.debug('Default Country to create bank accounts for New MICR Numbers: '||g_default_country);
1121: EXCEPTION
1122: WHEN OTHERS THEN
1123: arp_standard.debug('Exception: Default Country to create bank accounts for New MICR Numbers');
1124: g_default_country := 'US';

Line 1123: arp_standard.debug('Exception: Default Country to create bank accounts for New MICR Numbers');

1119:
1120: arp_standard.debug('Default Country to create bank accounts for New MICR Numbers: '||g_default_country);
1121: EXCEPTION
1122: WHEN OTHERS THEN
1123: arp_standard.debug('Exception: Default Country to create bank accounts for New MICR Numbers');
1124: g_default_country := 'US';
1125: END;
1126:
1127: END ARP_EXT_BANK_PKG;