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.AR_INVOICE_API_PUB dependencies on AR_INVOICE_UTILS

Line 21: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_header(+)' );

17: BEGIN
18:
19: x_return_status := FND_API.G_RET_STS_SUCCESS;
20: IF pg_debug = 'Y' THEN
21: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_header(+)' );
22: ar_invoice_utils.debug ('All Default Values ' );
23: ar_invoice_utils.debug ('Set of Books Id '||
24: p_trx_system_param_rec.set_of_books_id);
25: ar_invoice_utils.debug ('Trx Currency '||

Line 22: ar_invoice_utils.debug ('All Default Values ' );

18:
19: x_return_status := FND_API.G_RET_STS_SUCCESS;
20: IF pg_debug = 'Y' THEN
21: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_header(+)' );
22: ar_invoice_utils.debug ('All Default Values ' );
23: ar_invoice_utils.debug ('Set of Books Id '||
24: p_trx_system_param_rec.set_of_books_id);
25: ar_invoice_utils.debug ('Trx Currency '||
26: p_trx_system_param_rec.base_currency_code);

Line 23: ar_invoice_utils.debug ('Set of Books Id '||

19: x_return_status := FND_API.G_RET_STS_SUCCESS;
20: IF pg_debug = 'Y' THEN
21: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_header(+)' );
22: ar_invoice_utils.debug ('All Default Values ' );
23: ar_invoice_utils.debug ('Set of Books Id '||
24: p_trx_system_param_rec.set_of_books_id);
25: ar_invoice_utils.debug ('Trx Currency '||
26: p_trx_system_param_rec.base_currency_code);
27: ar_invoice_utils.debug ('Batch Source '||

Line 25: ar_invoice_utils.debug ('Trx Currency '||

21: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_header(+)' );
22: ar_invoice_utils.debug ('All Default Values ' );
23: ar_invoice_utils.debug ('Set of Books Id '||
24: p_trx_system_param_rec.set_of_books_id);
25: ar_invoice_utils.debug ('Trx Currency '||
26: p_trx_system_param_rec.base_currency_code);
27: ar_invoice_utils.debug ('Batch Source '||
28: p_trx_profile_rec.ar_ra_batch_source);
29: ar_invoice_utils.debug ('GL Date '|| p_batch_source_rec.default_date);

Line 27: ar_invoice_utils.debug ('Batch Source '||

23: ar_invoice_utils.debug ('Set of Books Id '||
24: p_trx_system_param_rec.set_of_books_id);
25: ar_invoice_utils.debug ('Trx Currency '||
26: p_trx_system_param_rec.base_currency_code);
27: ar_invoice_utils.debug ('Batch Source '||
28: p_trx_profile_rec.ar_ra_batch_source);
29: ar_invoice_utils.debug ('GL Date '|| p_batch_source_rec.default_date);
30: ar_invoice_utils.debug ('Exchange Rate Type '
31: || p_trx_profile_rec.default_exchange_rate_type);

Line 29: ar_invoice_utils.debug ('GL Date '|| p_batch_source_rec.default_date);

25: ar_invoice_utils.debug ('Trx Currency '||
26: p_trx_system_param_rec.base_currency_code);
27: ar_invoice_utils.debug ('Batch Source '||
28: p_trx_profile_rec.ar_ra_batch_source);
29: ar_invoice_utils.debug ('GL Date '|| p_batch_source_rec.default_date);
30: ar_invoice_utils.debug ('Exchange Rate Type '
31: || p_trx_profile_rec.default_exchange_rate_type);
32: END IF;
33:

Line 30: ar_invoice_utils.debug ('Exchange Rate Type '

26: p_trx_system_param_rec.base_currency_code);
27: ar_invoice_utils.debug ('Batch Source '||
28: p_trx_profile_rec.ar_ra_batch_source);
29: ar_invoice_utils.debug ('GL Date '|| p_batch_source_rec.default_date);
30: ar_invoice_utils.debug ('Exchange Rate Type '
31: || p_trx_profile_rec.default_exchange_rate_type);
32: END IF;
33:
34: -- First populate the global header table with the user parameter.

Line 49: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_header(-)' );

45: /* 5921925 - Removed defaulting UPDATE statement and integrated it
46: into ar_trx_global_process_header.insert_row */
47:
48: IF pg_debug = 'Y' THEN
49: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_header(-)' );
50: END IF;
51:
52: EXCEPTION
53: WHEN OTHERS THEN

Line 83: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_lines(+)' );

79:
80: BEGIN
81:
82: IF pg_debug = 'Y' THEN
83: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_lines(+)' );
84: END IF;
85:
86: x_return_status := FND_API.G_RET_STS_SUCCESS;
87:

Line 113: ar_invoice_utils.debug ('Cust Trx Line Id in Link Loop ' ||

109: FETCH line INTO l_customer_trx_line_id;
110: CLOSE line;
111:
112: IF pg_debug = 'Y' THEN
113: ar_invoice_utils.debug ('Cust Trx Line Id in Link Loop ' ||
114: l_customer_trx_line_id);
115: ar_invoice_utils.debug ('Link to Line Id in Link Loop ' ||
116: clinkRec.link_to_trx_line_id );
117: ar_invoice_utils.debug ('Trx Line Id in Link Loop ' ||

Line 115: ar_invoice_utils.debug ('Link to Line Id in Link Loop ' ||

111:
112: IF pg_debug = 'Y' THEN
113: ar_invoice_utils.debug ('Cust Trx Line Id in Link Loop ' ||
114: l_customer_trx_line_id);
115: ar_invoice_utils.debug ('Link to Line Id in Link Loop ' ||
116: clinkRec.link_to_trx_line_id );
117: ar_invoice_utils.debug ('Trx Line Id in Link Loop ' ||
118: clinkRec.trx_line_id );
119: END IF;

Line 117: ar_invoice_utils.debug ('Trx Line Id in Link Loop ' ||

113: ar_invoice_utils.debug ('Cust Trx Line Id in Link Loop ' ||
114: l_customer_trx_line_id);
115: ar_invoice_utils.debug ('Link to Line Id in Link Loop ' ||
116: clinkRec.link_to_trx_line_id );
117: ar_invoice_utils.debug ('Trx Line Id in Link Loop ' ||
118: clinkRec.trx_line_id );
119: END IF;
120:
121: UPDATE ar_trx_lines_gt gt

Line 137: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_lines(-)' );

133: request_id = AR_INVOICE_TABLE_HANDLER.g_request_id;
134:
135: IF pg_debug = 'Y'
136: THEN
137: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_lines(-)' );
138: END IF;
139:
140: EXCEPTION
141: WHEN OTHERS THEN

Line 165: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_distributions(+)' );

161:
162: BEGIN
163:
164: IF pg_debug = 'Y' THEN
165: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_distributions(+)' );
166: END IF;
167:
168: x_return_status := FND_API.G_RET_STS_SUCCESS;
169:

Line 207: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_distributions(-)' );

203: AND dist.account_class = 'REC');
204:
205:
206: IF pg_debug = 'Y' THEN
207: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_distributions(-)' );
208: END IF;
209:
210: EXCEPTION
211: WHEN OTHERS THEN

Line 229: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_salescredits(+)' );

225:
226: BEGIN
227: IF pg_debug = 'Y'
228: THEN
229: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_salescredits(+)' );
230: END IF;
231: x_return_status := FND_API.G_RET_STS_SUCCESS;
232: --populate global dist. table
233: AR_TRX_GLOBAL_PROCESS_SALESCR.INSERT_ROW(

Line 259: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_salescredits(-)' );

255:
256:
257: IF pg_debug = 'Y'
258: THEN
259: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_salescredits(-)' );
260: END IF;
261: EXCEPTION
262: WHEN OTHERS THEN
263: x_errmsg := 'Error in AR_INVOICE_API_PUB.populate sales credits '||sqlerrm;

Line 281: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_contingencies(+)' );

277:
278: BEGIN
279:
280: IF pg_debug = 'Y' THEN
281: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_contingencies(+)' );
282: END IF;
283:
284: x_return_status := FND_API.G_RET_STS_SUCCESS;
285: -- populate global contingencies table

Line 309: ar_invoice_utils.debug ('ar_invoice_api_pub.populate_contingencies(-)' );

305: WHERE tlg.trx_line_id = tcg.trx_line_id
306: AND rownum = 1);
307:
308: IF pg_debug = 'Y' THEN
309: ar_invoice_utils.debug ('ar_invoice_api_pub.populate_contingencies(-)' );
310: END IF;
311:
312: EXCEPTION
313: WHEN OTHERS THEN

Line 382: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.CREATE_INVOICE(2)(+)' );

378: BEGIN
379:
380: IF pg_debug = 'Y'
381: THEN
382: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.CREATE_INVOICE(2)(+)' );
383: END IF;
384:
385: SAVEPOINT Create_Invoice;
386: /*--------------------------------------------------+

Line 422: ar_invoice_utils.debug ('Before looping thru invoice headers....' );

418:
419:
420: IF pg_debug = 'Y'
421: THEN
422: ar_invoice_utils.debug ('Before looping thru invoice headers....' );
423: ar_invoice_utils.debug ('x_return_status = '|| x_return_status);
424: ar_invoice_utils.debug ('x_errmsg = '|| x_errmsg);
425: END IF;
426:

Line 423: ar_invoice_utils.debug ('x_return_status = '|| x_return_status);

419:
420: IF pg_debug = 'Y'
421: THEN
422: ar_invoice_utils.debug ('Before looping thru invoice headers....' );
423: ar_invoice_utils.debug ('x_return_status = '|| x_return_status);
424: ar_invoice_utils.debug ('x_errmsg = '|| x_errmsg);
425: END IF;
426:
427: FOR org_rec in org_cur LOOP

Line 424: ar_invoice_utils.debug ('x_errmsg = '|| x_errmsg);

420: IF pg_debug = 'Y'
421: THEN
422: ar_invoice_utils.debug ('Before looping thru invoice headers....' );
423: ar_invoice_utils.debug ('x_return_status = '|| x_return_status);
424: ar_invoice_utils.debug ('x_errmsg = '|| x_errmsg);
425: END IF;
426:
427: FOR org_rec in org_cur LOOP
428: AR_TRX_GLOBAL_PROCESS_TMP.GET_ROWS (

Line 437: ar_invoice_utils.debug ('Looping thru invoice headers....' );

433: p_trx_salescredits_tbl => l_trx_salescredits_tbl,
434: x_errmsg => x_errmsg,
435: x_return_status => x_return_status);
436:
437: ar_invoice_utils.debug ('Looping thru invoice headers....' );
438: ar_invoice_utils.debug ('x_return_status = '|| x_return_status);
439: ar_invoice_utils.debug ('x_errmsg = '|| x_errmsg);
440:
441: l_org_id := org_rec.org_id;

Line 438: ar_invoice_utils.debug ('x_return_status = '|| x_return_status);

434: x_errmsg => x_errmsg,
435: x_return_status => x_return_status);
436:
437: ar_invoice_utils.debug ('Looping thru invoice headers....' );
438: ar_invoice_utils.debug ('x_return_status = '|| x_return_status);
439: ar_invoice_utils.debug ('x_errmsg = '|| x_errmsg);
440:
441: l_org_id := org_rec.org_id;
442: l_org_return_status := FND_API.G_RET_STS_SUCCESS;

Line 439: ar_invoice_utils.debug ('x_errmsg = '|| x_errmsg);

435: x_return_status => x_return_status);
436:
437: ar_invoice_utils.debug ('Looping thru invoice headers....' );
438: ar_invoice_utils.debug ('x_return_status = '|| x_return_status);
439: ar_invoice_utils.debug ('x_errmsg = '|| x_errmsg);
440:
441: l_org_id := org_rec.org_id;
442: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
443: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,

Line 445: ar_invoice_utils.debug ('l_org_id = '|| l_org_id);

441: l_org_id := org_rec.org_id;
442: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
443: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
444: p_return_status =>l_org_return_status);
445: ar_invoice_utils.debug ('l_org_id = '|| l_org_id);
446: ar_invoice_utils.debug ('l_org_return_status = '|| l_org_return_status);
447:
448: /* 6006015 - this logic differs from 11.5 because
449: the transactions are processed by org. So we

Line 446: ar_invoice_utils.debug ('l_org_return_status = '|| l_org_return_status);

442: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
443: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
444: p_return_status =>l_org_return_status);
445: ar_invoice_utils.debug ('l_org_id = '|| l_org_id);
446: ar_invoice_utils.debug ('l_org_return_status = '|| l_org_return_status);
447:
448: /* 6006015 - this logic differs from 11.5 because
449: the transactions are processed by org. So we
450: have to init each time the org changes */

Line 495: ar_invoice_utils.debug ('Calling Default Rtn from ar_invoice_pub(-)' );

491: END IF;
492:
493: IF pg_debug = 'Y'
494: THEN
495: ar_invoice_utils.debug ('Calling Default Rtn from ar_invoice_pub(-)' );
496: ar_invoice_utils.debug ('Create Batch(+)' );
497: END IF;
498:
499: /* 5921925 - only create a batch if they are not calling in single invoice

Line 496: ar_invoice_utils.debug ('Create Batch(+)' );

492:
493: IF pg_debug = 'Y'
494: THEN
495: ar_invoice_utils.debug ('Calling Default Rtn from ar_invoice_pub(-)' );
496: ar_invoice_utils.debug ('Create Batch(+)' );
497: END IF;
498:
499: /* 5921925 - only create a batch if they are not calling in single invoice
500: mode */

Line 530: ar_invoice_utils.debug ('Create Batch(-)' );

526: --first popolate the global temp. table based on user passed variables and
527: -- default system parameters and profile values.
528: IF pg_debug = 'Y'
529: THEN
530: ar_invoice_utils.debug ('Create Batch(-)' );
531: ar_invoice_utils.debug ('populate header(+)' );
532: END IF;
533: populate_header( p_trx_header_tbl => l_trx_header_tbl,
534: p_trx_system_param_rec => l_trx_system_parameters_rec,

Line 531: ar_invoice_utils.debug ('populate header(+)' );

527: -- default system parameters and profile values.
528: IF pg_debug = 'Y'
529: THEN
530: ar_invoice_utils.debug ('Create Batch(-)' );
531: ar_invoice_utils.debug ('populate header(+)' );
532: END IF;
533: populate_header( p_trx_header_tbl => l_trx_header_tbl,
534: p_trx_system_param_rec => l_trx_system_parameters_rec,
535: p_trx_profile_rec => l_trx_profile_rec,

Line 547: ar_invoice_utils.debug ('populate header (-)' );

543: return;
544: END IF;
545: IF pg_debug = 'Y'
546: THEN
547: ar_invoice_utils.debug ('populate header (-)' );
548: ar_invoice_utils.debug ('populate lines (+)' );
549: END IF;
550:
551: populate_lines ( p_trx_lines_tbl => l_trx_lines_tbl,

Line 548: ar_invoice_utils.debug ('populate lines (+)' );

544: END IF;
545: IF pg_debug = 'Y'
546: THEN
547: ar_invoice_utils.debug ('populate header (-)' );
548: ar_invoice_utils.debug ('populate lines (+)' );
549: END IF;
550:
551: populate_lines ( p_trx_lines_tbl => l_trx_lines_tbl,
552: p_trx_system_param_rec => l_trx_system_parameters_rec,

Line 565: ar_invoice_utils.debug ('validate_master_detail' );

561:
562: -- Check for validations that spans across header and lines.
563:
564: IF pg_debug = 'Y' THEN
565: ar_invoice_utils.debug ('validate_master_detail' );
566: END IF;
567:
568: ar_invoice_utils.validate_master_detail
569: ( x_errmsg => x_errmsg,

Line 568: ar_invoice_utils.validate_master_detail

564: IF pg_debug = 'Y' THEN
565: ar_invoice_utils.debug ('validate_master_detail' );
566: END IF;
567:
568: ar_invoice_utils.validate_master_detail
569: ( x_errmsg => x_errmsg,
570: x_return_status => x_return_status);
571:
572: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 580: ar_invoice_utils.debug ('populate lines (-)' );

576: END IF;
577:
578: IF pg_debug = 'Y'
579: THEN
580: ar_invoice_utils.debug ('populate lines (-)' );
581: ar_invoice_utils.debug ('populate distributions (+)' );
582: END IF;
583:
584: /* 5921925 - only execute if there are rows */

Line 581: ar_invoice_utils.debug ('populate distributions (+)' );

577:
578: IF pg_debug = 'Y'
579: THEN
580: ar_invoice_utils.debug ('populate lines (-)' );
581: ar_invoice_utils.debug ('populate distributions (+)' );
582: END IF;
583:
584: /* 5921925 - only execute if there are rows */
585: IF p_trx_dist_tbl.count > 0

Line 606: ar_invoice_utils.debug ('populate distributions (-)' );

602: END IF;
603:
604: IF pg_debug = 'Y'
605: THEN
606: ar_invoice_utils.debug ('populate distributions (-)' );
607: ar_invoice_utils.debug ('populate sales credits (+)' );
608: END IF;
609:
610: /* 5921925 - only execute if rows exist */

Line 607: ar_invoice_utils.debug ('populate sales credits (+)' );

603:
604: IF pg_debug = 'Y'
605: THEN
606: ar_invoice_utils.debug ('populate distributions (-)' );
607: ar_invoice_utils.debug ('populate sales credits (+)' );
608: END IF;
609:
610: /* 5921925 - only execute if rows exist */
611: IF p_trx_salescredits_tbl.count > 0

Line 630: ar_invoice_utils.debug('populate sales credits(-)' );

626: g_sc_exist := FALSE;
627: END IF;
628:
629: IF pg_debug = 'Y' THEN
630: ar_invoice_utils.debug('populate sales credits(-)' );
631: ar_invoice_utils.debug('populate contingencies(+)' );
632: END IF;
633:
634: /* 5921925 - only populate if rows exist */

Line 631: ar_invoice_utils.debug('populate contingencies(+)' );

627: END IF;
628:
629: IF pg_debug = 'Y' THEN
630: ar_invoice_utils.debug('populate sales credits(-)' );
631: ar_invoice_utils.debug('populate contingencies(+)' );
632: END IF;
633:
634: /* 5921925 - only populate if rows exist */
635: IF p_trx_contingencies_tbl.count > 0

Line 664: ar_invoice_utils.debug ('populate contingencies(-)' );

660: -- ORASHID 20-Sep-2004
661: -- END
662:
663: IF pg_debug = 'Y' THEN
664: ar_invoice_utils.debug ('populate contingencies(-)' );
665: END IF;
666:
667: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
668: ROLLBACK to Create_Invoice;

Line 676: ar_invoice_utils.debug ('validate_dependend_parameter' );

672:
673: -- Validate all inter-dependent parameters
674: IF pg_debug = 'Y'
675: THEN
676: ar_invoice_utils.debug ('validate_dependend_parameter' );
677: END IF;
678: ar_invoice_utils.validate_dependent_parameters
679: ( p_trx_system_param_rec => l_trx_system_parameters_rec,
680: x_errmsg => x_errmsg,

Line 678: ar_invoice_utils.validate_dependent_parameters

674: IF pg_debug = 'Y'
675: THEN
676: ar_invoice_utils.debug ('validate_dependend_parameter' );
677: END IF;
678: ar_invoice_utils.validate_dependent_parameters
679: ( p_trx_system_param_rec => l_trx_system_parameters_rec,
680: x_errmsg => x_errmsg,
681: x_return_status => x_return_status);
682:

Line 694: ar_invoice_utils.debug ('validate_header from ar_invoice_pub (+)' );

690: -- Now validate all the values which user has passed and populate
691: -- any dependent fields.
692: IF pg_debug = 'Y'
693: THEN
694: ar_invoice_utils.debug ('validate_header from ar_invoice_pub (+)' );
695: END IF;
696:
697: ar_invoice_utils.validate_header
698: ( p_trx_system_param_rec => l_trx_system_parameters_rec,

Line 697: ar_invoice_utils.validate_header

693: THEN
694: ar_invoice_utils.debug ('validate_header from ar_invoice_pub (+)' );
695: END IF;
696:
697: ar_invoice_utils.validate_header
698: ( p_trx_system_param_rec => l_trx_system_parameters_rec,
699: p_trx_profile_rec => l_trx_profile_rec,
700: x_errmsg => x_errmsg,
701: x_return_status => x_return_status);

Line 713: ar_invoice_utils.debug ('validate_header from ar_invoice_pub (-)' );

709:
710:
711: IF pg_debug = 'Y'
712: THEN
713: ar_invoice_utils.debug ('validate_header from ar_invoice_pub (-)' );
714: ar_invoice_utils.debug ('validate_lines from ar_invoice_pub (+)' );
715: END IF;
716:
717: ar_invoice_utils.validate_lines

Line 714: ar_invoice_utils.debug ('validate_lines from ar_invoice_pub (+)' );

710:
711: IF pg_debug = 'Y'
712: THEN
713: ar_invoice_utils.debug ('validate_header from ar_invoice_pub (-)' );
714: ar_invoice_utils.debug ('validate_lines from ar_invoice_pub (+)' );
715: END IF;
716:
717: ar_invoice_utils.validate_lines
718: ( x_errmsg => x_errmsg,

Line 717: ar_invoice_utils.validate_lines

713: ar_invoice_utils.debug ('validate_header from ar_invoice_pub (-)' );
714: ar_invoice_utils.debug ('validate_lines from ar_invoice_pub (+)' );
715: END IF;
716:
717: ar_invoice_utils.validate_lines
718: ( x_errmsg => x_errmsg,
719: x_return_status => x_return_status);
720:
721: /* Bug9356903 When creating Credit Memo, Quantity_Credited

Line 742: ar_invoice_utils.debug ('validate_lines from ar_invoice_pub (-)' );

738: return;
739: END IF;
740: IF pg_debug = 'Y'
741: THEN
742: ar_invoice_utils.debug ('validate_lines from ar_invoice_pub (-)' );
743: ar_invoice_utils.debug ('validate_distributions from ar_invoice_pub (+)' );
744: END IF;
745:
746: /* 5921925 - prevent this call if no distributions passed */

Line 743: ar_invoice_utils.debug ('validate_distributions from ar_invoice_pub (+)' );

739: END IF;
740: IF pg_debug = 'Y'
741: THEN
742: ar_invoice_utils.debug ('validate_lines from ar_invoice_pub (-)' );
743: ar_invoice_utils.debug ('validate_distributions from ar_invoice_pub (+)' );
744: END IF;
745:
746: /* 5921925 - prevent this call if no distributions passed */
747: IF g_dist_exist

Line 749: ar_invoice_utils.validate_distributions

745:
746: /* 5921925 - prevent this call if no distributions passed */
747: IF g_dist_exist
748: THEN
749: ar_invoice_utils.validate_distributions
750: ( p_trx_system_parameters_rec => l_trx_system_parameters_rec,
751: x_errmsg => x_errmsg,
752: x_return_status => x_return_status);
753:

Line 764: ar_invoice_utils.debug ('validate_distributions from ar_invoice_pub (-)' );

760: END IF;
761:
762: IF pg_debug = 'Y'
763: THEN
764: ar_invoice_utils.debug ('validate_distributions from ar_invoice_pub (-)' );
765: ar_invoice_utils.debug ('validate_salescredits from ar_invoice_pub (+)' );
766: END IF;
767:
768: IF g_sc_exist

Line 765: ar_invoice_utils.debug ('validate_salescredits from ar_invoice_pub (+)' );

761:
762: IF pg_debug = 'Y'
763: THEN
764: ar_invoice_utils.debug ('validate_distributions from ar_invoice_pub (-)' );
765: ar_invoice_utils.debug ('validate_salescredits from ar_invoice_pub (+)' );
766: END IF;
767:
768: IF g_sc_exist
769: THEN

Line 770: ar_invoice_utils.validate_salescredits(

766: END IF;
767:
768: IF g_sc_exist
769: THEN
770: ar_invoice_utils.validate_salescredits(
771: p_trx_system_param_rec => l_trx_system_parameters_rec,
772: x_errmsg => x_errmsg,
773: x_return_status => x_return_status);
774:

Line 785: ar_invoice_utils.debug ('validate_salescredits from ar_invoice_pub (-)' );

781: END IF;
782:
783: IF pg_debug = 'Y'
784: THEN
785: ar_invoice_utils.debug ('validate_salescredits from ar_invoice_pub (-)' );
786: ar_invoice_utils.debug ('vaidate_gdf (+) ');
787: END IF;
788:
789: ar_invoice_utils.validate_gdf(

Line 786: ar_invoice_utils.debug ('vaidate_gdf (+) ');

782:
783: IF pg_debug = 'Y'
784: THEN
785: ar_invoice_utils.debug ('validate_salescredits from ar_invoice_pub (-)' );
786: ar_invoice_utils.debug ('vaidate_gdf (+) ');
787: END IF;
788:
789: ar_invoice_utils.validate_gdf(
790: p_request_id => AR_INVOICE_TABLE_HANDLER.g_request_id,

Line 789: ar_invoice_utils.validate_gdf(

785: ar_invoice_utils.debug ('validate_salescredits from ar_invoice_pub (-)' );
786: ar_invoice_utils.debug ('vaidate_gdf (+) ');
787: END IF;
788:
789: ar_invoice_utils.validate_gdf(
790: p_request_id => AR_INVOICE_TABLE_HANDLER.g_request_id,
791: x_errmsg => x_errmsg,
792: x_return_status => x_return_status);
793:

Line 802: ar_invoice_utils.debug ('validate_gdf (-)' );

798: return;
799: END IF;
800: IF pg_debug = 'Y'
801: THEN
802: ar_invoice_utils.debug ('validate_gdf (-)' );
803: ar_invoice_utils.debug ('Calling Table Handler ar_invoice_table_handler.insert_row (+) ');
804: END IF;
805:
806: AR_INVOICE_TABLE_HANDLER.insert_row(

Line 803: ar_invoice_utils.debug ('Calling Table Handler ar_invoice_table_handler.insert_row (+) ');

799: END IF;
800: IF pg_debug = 'Y'
801: THEN
802: ar_invoice_utils.debug ('validate_gdf (-)' );
803: ar_invoice_utils.debug ('Calling Table Handler ar_invoice_table_handler.insert_row (+) ');
804: END IF;
805:
806: AR_INVOICE_TABLE_HANDLER.insert_row(
807: p_trx_system_parameters_rec => l_trx_system_parameters_rec,

Line 820: ar_invoice_utils.debug('calling: jg_zz_ar_trx_pkg.is_reg_loc_enabled');

816: x_msg_data := x_errmsg;
817: return;
818: END IF;
819: IF jg_zz_ar_trx_pkg.is_reg_loc_enabled THEN
820: ar_invoice_utils.debug('calling: jg_zz_ar_trx_pkg.is_reg_loc_enabled');
821: DECLARE
822: temp_customer_trx_id ra_customer_trx_all.customer_trx_id%type;
823: p_return_flag boolean;
824: p_return_code number;

Line 832: ar_invoice_utils.debug('Creating the invoices in Complete Status ');

828:
829: jg_zz_ar_trx_pkg.do_trx_complete(null,temp_customer_trx_id,'INVOICEAPI',p_return_flag, p_return_code,p_return_message);
830:
831: IF (p_return_flag = FALSE) THEN
832: ar_invoice_utils.debug('Creating the invoices in Complete Status ');
833: ar_invoice_utils.debug('Issue at the time of signature generation for localization');
834: ar_invoice_utils.debug('Message : '||p_return_message);
835: x_msg_data := p_return_message;
836: x_return_status :=FND_API.G_RET_STS_ERROR;

Line 833: ar_invoice_utils.debug('Issue at the time of signature generation for localization');

829: jg_zz_ar_trx_pkg.do_trx_complete(null,temp_customer_trx_id,'INVOICEAPI',p_return_flag, p_return_code,p_return_message);
830:
831: IF (p_return_flag = FALSE) THEN
832: ar_invoice_utils.debug('Creating the invoices in Complete Status ');
833: ar_invoice_utils.debug('Issue at the time of signature generation for localization');
834: ar_invoice_utils.debug('Message : '||p_return_message);
835: x_msg_data := p_return_message;
836: x_return_status :=FND_API.G_RET_STS_ERROR;
837: x_msg_count :=-99;

Line 834: ar_invoice_utils.debug('Message : '||p_return_message);

830:
831: IF (p_return_flag = FALSE) THEN
832: ar_invoice_utils.debug('Creating the invoices in Complete Status ');
833: ar_invoice_utils.debug('Issue at the time of signature generation for localization');
834: ar_invoice_utils.debug('Message : '||p_return_message);
835: x_msg_data := p_return_message;
836: x_return_status :=FND_API.G_RET_STS_ERROR;
837: x_msg_count :=-99;
838: END IF;

Line 841: ar_invoice_utils.debug (' Exiting from PT Code Hook');

837: x_msg_count :=-99;
838: END IF;
839:
840: END;
841: ar_invoice_utils.debug (' Exiting from PT Code Hook');
842: END IF;
843:
844: /*
845: Fixed bug 12562413 and add JL TRANSACTION NUMBERING MECHANISM while execting the

Line 849: ar_invoice_utils.debug (' Calling JL Code Hook');

845: Fixed bug 12562413 and add JL TRANSACTION NUMBERING MECHANISM while execting the
846: Invoice AIP to create transaction
847: */
848: IF JG_ZZ_AR_AUTO_INVOICE.is_reg_loc_enabled THEN
849: ar_invoice_utils.debug (' Calling JL Code Hook');
850: DECLARE
851: temp_customer_trx_id ra_customer_trx_all.customer_trx_id%type;
852: t_code number;
853: t_errmsg varchar2(1024);

Line 867: ar_invoice_utils.debug (' Error Calling JL Code Hook');

863: WHEN OTHERS THEN
864: t_code :=sqlcode;
865: t_errmsg := sqlerrm;
866: ROLLBACK to Create_Invoice;
867: ar_invoice_utils.debug (' Error Calling JL Code Hook');
868: ar_invoice_utils.debug (t_code||t_errmsg);
869: raise;
870: END;
871: ar_invoice_utils.debug (' Exiting from JL Code Hook');

Line 868: ar_invoice_utils.debug (t_code||t_errmsg);

864: t_code :=sqlcode;
865: t_errmsg := sqlerrm;
866: ROLLBACK to Create_Invoice;
867: ar_invoice_utils.debug (' Error Calling JL Code Hook');
868: ar_invoice_utils.debug (t_code||t_errmsg);
869: raise;
870: END;
871: ar_invoice_utils.debug (' Exiting from JL Code Hook');
872: END IF;

Line 871: ar_invoice_utils.debug (' Exiting from JL Code Hook');

867: ar_invoice_utils.debug (' Error Calling JL Code Hook');
868: ar_invoice_utils.debug (t_code||t_errmsg);
869: raise;
870: END;
871: ar_invoice_utils.debug (' Exiting from JL Code Hook');
872: END IF;
873:
874: -- Standard check of p_commit.
875: IF FND_API.To_Boolean( p_commit )

Line 886: ar_invoice_utils.debug ('Call creation of XLA events in bulk mode +' );

882:
883:
884: --{Call creation of the events should outside the loop as not org striped
885: --
886: ar_invoice_utils.debug ('Call creation of XLA events in bulk mode +' );
887: ar_invoice_utils.debug (' Using the request_id :'||AR_INVOICE_TABLE_HANDLER.g_request_id);
888:
889: arp_xla_events.Create_Events_Req(p_request_id => AR_INVOICE_TABLE_HANDLER.g_request_id,
890: p_doc_table => 'CT',

Line 887: ar_invoice_utils.debug (' Using the request_id :'||AR_INVOICE_TABLE_HANDLER.g_request_id);

883:
884: --{Call creation of the events should outside the loop as not org striped
885: --
886: ar_invoice_utils.debug ('Call creation of XLA events in bulk mode +' );
887: ar_invoice_utils.debug (' Using the request_id :'||AR_INVOICE_TABLE_HANDLER.g_request_id);
888:
889: arp_xla_events.Create_Events_Req(p_request_id => AR_INVOICE_TABLE_HANDLER.g_request_id,
890: p_doc_table => 'CT',
891: p_mode => 'B',

Line 893: ar_invoice_utils.debug ('Call creation of XLA events in bulk mode -' );

889: arp_xla_events.Create_Events_Req(p_request_id => AR_INVOICE_TABLE_HANDLER.g_request_id,
890: p_doc_table => 'CT',
891: p_mode => 'B',
892: p_call => 'B');
893: ar_invoice_utils.debug ('Call creation of XLA events in bulk mode -' );
894: --}
895:
896: IF pg_debug = 'Y'
897: THEN

Line 898: ar_invoice_utils.debug ('Calling Table Handler ar_invoice_table_handler.insert_row (-) ');

894: --}
895:
896: IF pg_debug = 'Y'
897: THEN
898: ar_invoice_utils.debug ('Calling Table Handler ar_invoice_table_handler.insert_row (-) ');
899: ar_invoice_utils.debug ('ar_invoice_api_pub.create_invoice(-)' );
900: END IF;
901:
902:

Line 899: ar_invoice_utils.debug ('ar_invoice_api_pub.create_invoice(-)' );

895:
896: IF pg_debug = 'Y'
897: THEN
898: ar_invoice_utils.debug ('Calling Table Handler ar_invoice_table_handler.insert_row (-) ');
899: ar_invoice_utils.debug ('ar_invoice_api_pub.create_invoice(-)' );
900: END IF;
901:
902:
903: END CREATE_INVOICE;

Line 928: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE(2)(+)' );

924:
925: BEGIN
926: IF pg_debug = 'Y'
927: THEN
928: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE(2)(+)' );
929: END IF;
930:
931: x_return_status := FND_API.G_RET_STS_SUCCESS;
932:

Line 970: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE(-)' );

966: END IF;
967:
968: IF pg_debug = 'Y'
969: THEN
970: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE(-)' );
971: END IF;
972:
973: END CREATE_SINGLE_INVOICE;
974:

Line 998: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE(+)' );

994:
995: BEGIN
996:
997: IF pg_debug = 'Y' THEN
998: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE(+)' );
999: END IF;
1000:
1001: -- call the api with a null trx_contingencies_tbl
1002:

Line 1018: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE(-)' );

1014: x_msg_count => x_msg_count,
1015: x_msg_data => x_msg_data);
1016:
1017: IF pg_debug = 'Y' THEN
1018: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE(-)' );
1019: END IF;
1020:
1021: END create_invoice;
1022:

Line 1043: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE(+)' );

1039:
1040: BEGIN
1041:
1042: IF pg_debug = 'Y' THEN
1043: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE(+)' );
1044: END IF;
1045:
1046: -- call the api with a null trx_contingencies_tbl
1047:

Line 1064: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE(-)' );

1060: x_msg_count => x_msg_count,
1061: x_msg_data => x_msg_data);
1062:
1063: IF pg_debug = 'Y' THEN
1064: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE(-)' );
1065: END IF;
1066:
1067: END create_single_invoice;
1068:

Line 1114: ar_invoice_utils.debug('Cache_Transaction_Type()+');

1110: l_dummy_type ra_cust_trx_types%rowtype;
1111:
1112: BEGIN
1113:
1114: ar_invoice_utils.debug('Cache_Transaction_Type()+');
1115:
1116: IF ( p_cust_trx_type_id IS NOT NULL )
1117: THEN
1118:

Line 1133: ar_invoice_utils.debug('Transaction Type: ' ||

1129: INTO Type_Cache_Tbl( p_cust_trx_type_id )
1130: FROM ra_cust_trx_types
1131: WHERE cust_trx_type_id = p_cust_trx_type_id;
1132:
1133: ar_invoice_utils.debug('Transaction Type: ' ||
1134: Type_Cache_Tbl( p_cust_trx_type_id ).name ||
1135: ' found.');
1136:
1137: EXCEPTION

Line 1151: ar_invoice_utils.debug('Transaction Type not found');

1147: +---------------------------------------------*/
1148:
1149: Type_Cache_Tbl( p_cust_trx_type_id ) :=
1150: l_dummy_type;
1151: ar_invoice_utils.debug('Transaction Type not found');
1152:
1153: WHEN OTHERS THEN
1154: RAISE;
1155: END;

Line 1161: ar_invoice_utils.debug('Cache_Transaction_type()-');

1157: END IF;
1158:
1159: END IF;
1160:
1161: ar_invoice_utils.debug('Cache_Transaction_type()-');
1162:
1163: EXCEPTION
1164: WHEN NO_DATA_FOUND THEN NULL;
1165:

Line 1167: ar_invoice_utils.debug('EXCEPTION: Cache_Transaction_Type() ');

1163: EXCEPTION
1164: WHEN NO_DATA_FOUND THEN NULL;
1165:
1166: WHEN OTHERS THEN
1167: ar_invoice_utils.debug('EXCEPTION: Cache_Transaction_Type() ');
1168: ar_invoice_utils.debug('p_cust_trx_type_id = ' ||
1169: TO_CHAR(p_cust_trx_type_id));
1170: RAISE;
1171:

Line 1168: ar_invoice_utils.debug('p_cust_trx_type_id = ' ||

1164: WHEN NO_DATA_FOUND THEN NULL;
1165:
1166: WHEN OTHERS THEN
1167: ar_invoice_utils.debug('EXCEPTION: Cache_Transaction_Type() ');
1168: ar_invoice_utils.debug('p_cust_trx_type_id = ' ||
1169: TO_CHAR(p_cust_trx_type_id));
1170: RAISE;
1171:
1172: END Cache_Transaction_Type;

Line 1223: ar_invoice_utils.debug('Get_Flags()+');

1219: l_index BINARY_INTEGER;
1220:
1221: BEGIN
1222:
1223: ar_invoice_utils.debug('Get_Flags()+');
1224:
1225: p_posted_flag := 'N';
1226: p_activity_flag := 'N';
1227: p_dm_reversal := 'N';

Line 1262: ar_invoice_utils.debug('. posted_flag = ' ||

1258: END IF;
1259:
1260: END LOOP;
1261:
1262: ar_invoice_utils.debug('. posted_flag = ' ||
1263: p_posted_flag);
1264:
1265: ar_invoice_utils.debug('. activity_flag = ' ||
1266: p_activity_flag);

Line 1265: ar_invoice_utils.debug('. activity_flag = ' ||

1261:
1262: ar_invoice_utils.debug('. posted_flag = ' ||
1263: p_posted_flag);
1264:
1265: ar_invoice_utils.debug('. activity_flag = ' ||
1266: p_activity_flag);
1267:
1268: ar_invoice_utils.debug('. printed_flag = ' ||
1269: p_printed_flag);

Line 1268: ar_invoice_utils.debug('. printed_flag = ' ||

1264:
1265: ar_invoice_utils.debug('. activity_flag = ' ||
1266: p_activity_flag);
1267:
1268: ar_invoice_utils.debug('. printed_flag = ' ||
1269: p_printed_flag);
1270:
1271: ar_invoice_utils.debug('. p_rev_recog_run_flag = ' ||
1272: p_rev_recog_run_flag);

Line 1271: ar_invoice_utils.debug('. p_rev_recog_run_flag = ' ||

1267:
1268: ar_invoice_utils.debug('. printed_flag = ' ||
1269: p_printed_flag);
1270:
1271: ar_invoice_utils.debug('. p_rev_recog_run_flag = ' ||
1272: p_rev_recog_run_flag);
1273:
1274: ar_invoice_utils.debug('. Class = ' ||
1275: p_type_rec.type);

Line 1274: ar_invoice_utils.debug('. Class = ' ||

1270:
1271: ar_invoice_utils.debug('. p_rev_recog_run_flag = ' ||
1272: p_rev_recog_run_flag);
1273:
1274: ar_invoice_utils.debug('. Class = ' ||
1275: p_type_rec.type);
1276:
1277: ar_invoice_utils.debug('. created_from = ' ||
1278: p_trx_rec.created_from);

Line 1277: ar_invoice_utils.debug('. created_from = ' ||

1273:
1274: ar_invoice_utils.debug('. Class = ' ||
1275: p_type_rec.type);
1276:
1277: ar_invoice_utils.debug('. created_from = ' ||
1278: p_trx_rec.created_from);
1279:
1280: IF ( p_trx_rec.created_from IN ('ARXREV', 'REL9_ARXREV') )
1281: THEN

Line 1290: ar_invoice_utils.debug('Get_Flags()-');

1286: THEN
1287: p_cb := 'Y';
1288: END IF;
1289:
1290: ar_invoice_utils.debug('Get_Flags()-');
1291:
1292: EXCEPTION
1293: WHEN OTHERS THEN
1294:

Line 1295: ar_invoice_utils.debug('EXCEPTION: Get_Flags()');

1291:
1292: EXCEPTION
1293: WHEN OTHERS THEN
1294:
1295: ar_invoice_utils.debug('EXCEPTION: Get_Flags()');
1296: RAISE;
1297:
1298: END Get_Flags;
1299:

Line 1346: ar_invoice_utils.debug('Validate_Delete_Transaction()+');

1342: l_cb_flag VARCHAR2(1);
1343:
1344: BEGIN
1345:
1346: ar_invoice_utils.debug('Validate_Delete_Transaction()+');
1347:
1348: p_return_status := FND_API.G_RET_STS_SUCCESS;
1349:
1350: /*------------------------------------------------------------+

Line 1384: ar_invoice_utils.debug('. invoice_deletion_flag = ' ||

1380: /*--------------------------------------------------------------------+
1381: | The invoice_deletion_flag must be Y for transactions to be deleted |
1382: +--------------------------------------------------------------------*/
1383:
1384: ar_invoice_utils.debug('. invoice_deletion_flag = ' ||
1385: arp_global.sysparam.invoice_deletion_flag);
1386:
1387: IF ( arp_global.sysparam.invoice_deletion_flag <> 'Y' )
1388: THEN

Line 1423: ar_invoice_utils.debug('. complete_flag = ' ||

1419: | o It has not been posted to GL and |
1420: | o There is no activity against it. |
1421: +--------------------------------------------------------------*/
1422:
1423: ar_invoice_utils.debug('. complete_flag = ' ||
1424: p_trx_rec.complete_flag);
1425:
1426: IF ( p_trx_rec.complete_flag = 'Y' )
1427: THEN

Line 1509: ar_invoice_utils.debug('Validate_Delete_Transaction()-');

1505: END IF; -- complete case
1506:
1507: END IF;
1508:
1509: ar_invoice_utils.debug('Validate_Delete_Transaction()-');
1510:
1511: EXCEPTION
1512: WHEN OTHERS THEN
1513: ar_invoice_utils.debug('EXCEPTION: Validate_Delete_Transaction()');

Line 1513: ar_invoice_utils.debug('EXCEPTION: Validate_Delete_Transaction()');

1509: ar_invoice_utils.debug('Validate_Delete_Transaction()-');
1510:
1511: EXCEPTION
1512: WHEN OTHERS THEN
1513: ar_invoice_utils.debug('EXCEPTION: Validate_Delete_Transaction()');
1514: ar_invoice_utils.debug('p_customer_trx_id = ' ||
1515: p_customer_trx_id);
1516:
1517: RAISE;

Line 1514: ar_invoice_utils.debug('p_customer_trx_id = ' ||

1510:
1511: EXCEPTION
1512: WHEN OTHERS THEN
1513: ar_invoice_utils.debug('EXCEPTION: Validate_Delete_Transaction()');
1514: ar_invoice_utils.debug('p_customer_trx_id = ' ||
1515: p_customer_trx_id);
1516:
1517: RAISE;
1518:

Line 1561: ar_invoice_utils.debug('AR_INVOICE_API_PUB.Delete_Trxn_Extn_Details()+ ');

1557: x_return_status VARCHAR2(240);
1558: l_payment_trxn_extn_id ra_customer_trx.PAYMENT_TRXN_EXTENSION_ID%TYPE;
1559: l_fnd_api_constants_rec ar_bills_main.fnd_api_constants_type := ar_bills_main.get_fnd_api_constants_rec;
1560: Begin
1561: ar_invoice_utils.debug('AR_INVOICE_API_PUB.Delete_Trxn_Extn_Details()+ ');
1562:
1563: p_return_status := FND_API.G_RET_STS_SUCCESS;
1564:
1565:

Line 1580: ar_invoice_utils.debug('Call TO IBY API ()+ ');

1576:
1577: /*-------------------------+
1578: | Call the IBY API |
1579: +-------------------------*/
1580: ar_invoice_utils.debug('Call TO IBY API ()+ ');
1581:
1582:
1583: IBY_FNDCPT_TRXN_PUB.delete_transaction_extension(
1584: p_api_version => 1.0,

Line 1599: ar_invoice_utils.debug('Payment_Trxn_Extension_Id : ' || l_payment_trxn_extn_id);

1595:
1596:
1597: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1598: THEN
1599: ar_invoice_utils.debug('Payment_Trxn_Extension_Id : ' || l_payment_trxn_extn_id);
1600: Else
1601: ar_invoice_utils.debug('Errors Reported by IBY API:Delete Transaction Extension ');
1602: p_return_status := FND_API.G_RET_STS_ERROR;
1603: END IF;

Line 1601: ar_invoice_utils.debug('Errors Reported by IBY API:Delete Transaction Extension ');

1597: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1598: THEN
1599: ar_invoice_utils.debug('Payment_Trxn_Extension_Id : ' || l_payment_trxn_extn_id);
1600: Else
1601: ar_invoice_utils.debug('Errors Reported by IBY API:Delete Transaction Extension ');
1602: p_return_status := FND_API.G_RET_STS_ERROR;
1603: END IF;
1604: EXCEPTION
1605: WHEN OTHERS THEN

Line 1606: ar_invoice_utils.debug('exception in AR_INVOICE_API_PUB.Delete_Trxn_Extn_Detail ');

1602: p_return_status := FND_API.G_RET_STS_ERROR;
1603: END IF;
1604: EXCEPTION
1605: WHEN OTHERS THEN
1606: ar_invoice_utils.debug('exception in AR_INVOICE_API_PUB.Delete_Trxn_Extn_Detail ');
1607: p_return_status := FND_API.G_RET_STS_ERROR;
1608: END Delete_Trxn_Extn_Details;
1609:
1610:

Line 1692: ar_invoice_utils.debug('p_api_name = ' || p_api_name);

1688: l_delete_pmt_ext_status VARCHAR2(10);
1689:
1690: PROCEDURE Display_Parameters IS
1691: BEGIN
1692: ar_invoice_utils.debug('p_api_name = ' || p_api_name);
1693: ar_invoice_utils.debug('p_api_version = ' || p_api_version);
1694: ar_invoice_utils.debug('p_init_msg_list = ' || p_init_msg_list);
1695: ar_invoice_utils.debug('p_commit = ' || p_commit);
1696: ar_invoice_utils.debug('p_validation_level = ' || p_validation_level);

Line 1693: ar_invoice_utils.debug('p_api_version = ' || p_api_version);

1689:
1690: PROCEDURE Display_Parameters IS
1691: BEGIN
1692: ar_invoice_utils.debug('p_api_name = ' || p_api_name);
1693: ar_invoice_utils.debug('p_api_version = ' || p_api_version);
1694: ar_invoice_utils.debug('p_init_msg_list = ' || p_init_msg_list);
1695: ar_invoice_utils.debug('p_commit = ' || p_commit);
1696: ar_invoice_utils.debug('p_validation_level = ' || p_validation_level);
1697: ar_invoice_utils.debug('p_customer_trx_id = ' || p_customer_trx_id);

Line 1694: ar_invoice_utils.debug('p_init_msg_list = ' || p_init_msg_list);

1690: PROCEDURE Display_Parameters IS
1691: BEGIN
1692: ar_invoice_utils.debug('p_api_name = ' || p_api_name);
1693: ar_invoice_utils.debug('p_api_version = ' || p_api_version);
1694: ar_invoice_utils.debug('p_init_msg_list = ' || p_init_msg_list);
1695: ar_invoice_utils.debug('p_commit = ' || p_commit);
1696: ar_invoice_utils.debug('p_validation_level = ' || p_validation_level);
1697: ar_invoice_utils.debug('p_customer_trx_id = ' || p_customer_trx_id);
1698: END;

Line 1695: ar_invoice_utils.debug('p_commit = ' || p_commit);

1691: BEGIN
1692: ar_invoice_utils.debug('p_api_name = ' || p_api_name);
1693: ar_invoice_utils.debug('p_api_version = ' || p_api_version);
1694: ar_invoice_utils.debug('p_init_msg_list = ' || p_init_msg_list);
1695: ar_invoice_utils.debug('p_commit = ' || p_commit);
1696: ar_invoice_utils.debug('p_validation_level = ' || p_validation_level);
1697: ar_invoice_utils.debug('p_customer_trx_id = ' || p_customer_trx_id);
1698: END;
1699:

Line 1696: ar_invoice_utils.debug('p_validation_level = ' || p_validation_level);

1692: ar_invoice_utils.debug('p_api_name = ' || p_api_name);
1693: ar_invoice_utils.debug('p_api_version = ' || p_api_version);
1694: ar_invoice_utils.debug('p_init_msg_list = ' || p_init_msg_list);
1695: ar_invoice_utils.debug('p_commit = ' || p_commit);
1696: ar_invoice_utils.debug('p_validation_level = ' || p_validation_level);
1697: ar_invoice_utils.debug('p_customer_trx_id = ' || p_customer_trx_id);
1698: END;
1699:
1700: BEGIN

Line 1697: ar_invoice_utils.debug('p_customer_trx_id = ' || p_customer_trx_id);

1693: ar_invoice_utils.debug('p_api_version = ' || p_api_version);
1694: ar_invoice_utils.debug('p_init_msg_list = ' || p_init_msg_list);
1695: ar_invoice_utils.debug('p_commit = ' || p_commit);
1696: ar_invoice_utils.debug('p_validation_level = ' || p_validation_level);
1697: ar_invoice_utils.debug('p_customer_trx_id = ' || p_customer_trx_id);
1698: END;
1699:
1700: BEGIN
1701:

Line 1743: ar_invoice_utils.debug('AR_INVOICE_API_PUB.Delete_Transaction(+)' );

1739: /*---------------------------------------------+
1740: | ========== Start of API Body ========== |
1741: +---------------------------------------------*/
1742:
1743: ar_invoice_utils.debug('AR_INVOICE_API_PUB.Delete_Transaction(+)' );
1744:
1745:
1746: Validate_Delete_Transaction(
1747: p_customer_trx_id,

Line 1760: ar_invoice_utils.debug('Making the transaction incomplete ' );

1756: THEN
1757:
1758: IF pg_debug = 'Y'
1759: THEN
1760: ar_invoice_utils.debug('Making the transaction incomplete ' );
1761: END IF;
1762:
1763: /*-------------------------------------------+
1764: | Try to make the transaction incomplete. |

Line 1778: ar_invoice_utils.debug ('. gl_date = ' || TO_CHAR(l_gl_date, 'DD-MON-YYYY'));

1774: AND latest_rec_flag = 'Y';
1775:
1776: IF pg_debug = 'Y'
1777: THEN
1778: ar_invoice_utils.debug ('. gl_date = ' || TO_CHAR(l_gl_date, 'DD-MON-YYYY'));
1779: END IF;
1780:
1781: IF pg_debug = 'Y'
1782: THEN

Line 1783: ar_invoice_utils.debug ('. amount = ' ||TO_CHAR(l_amount));

1779: END IF;
1780:
1781: IF pg_debug = 'Y'
1782: THEN
1783: ar_invoice_utils.debug ('. amount = ' ||TO_CHAR(l_amount));
1784: END IF;
1785:
1786: l_trx_rec.complete_flag := 'N';
1787:

Line 1813: ar_invoice_utils.debug('post_commit()+ ');

1809: +-----------------------*/
1810:
1811: IF pg_debug = 'Y'
1812: THEN
1813: ar_invoice_utils.debug('post_commit()+ ');
1814: END IF;
1815:
1816: arp_process_header_post_commit.post_commit(
1817: 'ARTPTRXB',

Line 1834: ar_invoice_utils.debug('post_commit()- ');

1830:
1831:
1832: IF pg_debug = 'Y'
1833: THEN
1834: ar_invoice_utils.debug('post_commit()- ');
1835: END IF;
1836:
1837: END IF; -- end complete_flag = 'Y' case
1838:

Line 1846: ar_invoice_utils.debug ('. update_status = ' || l_update_status);

1842: +-----------------------------------------------------*/
1843:
1844: IF pg_debug = 'Y'
1845: THEN
1846: ar_invoice_utils.debug ('. update_status = ' || l_update_status);
1847: END IF;
1848:
1849: IF (
1850: l_return_status = FND_API.G_RET_STS_SUCCESS

Line 1856: ar_invoice_utils.debug('Deleting the transaction');

1852: )
1853: THEN
1854: IF pg_debug = 'Y'
1855: THEN
1856: ar_invoice_utils.debug('Deleting the transaction');
1857: END IF;
1858:
1859:
1860: IF l_trx_rec.payment_trxn_extension_id IS NOT NULL THEN

Line 1944: ar_invoice_utils.debug ('Error(s) occurred. Rolling back and setting status to ERROR');

1940: p_return_status := FND_API.G_RET_STS_ERROR ;
1941:
1942: IF pg_debug = 'Y'
1943: THEN
1944: ar_invoice_utils.debug ('Error(s) occurred. Rolling back and setting status to ERROR');
1945: ar_invoice_utils.debug ('Number Of Messages: ' || TO_CHAR( arp_trx_validate.pg_message_tbl.COUNT) );
1946: END IF;
1947:
1948:

Line 1945: ar_invoice_utils.debug ('Number Of Messages: ' || TO_CHAR( arp_trx_validate.pg_message_tbl.COUNT) );

1941:
1942: IF pg_debug = 'Y'
1943: THEN
1944: ar_invoice_utils.debug ('Error(s) occurred. Rolling back and setting status to ERROR');
1945: ar_invoice_utils.debug ('Number Of Messages: ' || TO_CHAR( arp_trx_validate.pg_message_tbl.COUNT) );
1946: END IF;
1947:
1948:
1949:

Line 1957: THEN ar_invoice_utils.debug('committing');

1953: | Standard check of p_commit |
1954: +--------------------------------*/
1955:
1956: IF FND_API.To_Boolean( p_commit )
1957: THEN ar_invoice_utils.debug('committing');
1958: Commit;
1959: END IF;
1960:
1961: ar_invoice_utils.debug('AR_INVOICE_API_PUB.Delete_Transaction(-)' );

Line 1961: ar_invoice_utils.debug('AR_INVOICE_API_PUB.Delete_Transaction(-)' );

1957: THEN ar_invoice_utils.debug('committing');
1958: Commit;
1959: END IF;
1960:
1961: ar_invoice_utils.debug('AR_INVOICE_API_PUB.Delete_Transaction(-)' );
1962:
1963:
1964: EXCEPTION
1965: WHEN NO_DATA_FOUND THEN

Line 1976: ar_invoice_utils.debug(SQLCODE);

1972: p_data => p_msg_data
1973: );
1974:
1975: WHEN FND_API.G_EXC_ERROR THEN
1976: ar_invoice_utils.debug(SQLCODE);
1977: ar_invoice_utils.debug(SQLERRM);
1978:
1979:
1980: ROLLBACK TO Delete_Transaction_PUB;

Line 1977: ar_invoice_utils.debug(SQLERRM);

1973: );
1974:
1975: WHEN FND_API.G_EXC_ERROR THEN
1976: ar_invoice_utils.debug(SQLCODE);
1977: ar_invoice_utils.debug(SQLERRM);
1978:
1979:
1980: ROLLBACK TO Delete_Transaction_PUB;
1981: p_return_status := FND_API.G_RET_STS_ERROR ;

Line 1990: ar_invoice_utils.debug(SQLCODE);

1986: );
1987:
1988: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1989:
1990: ar_invoice_utils.debug(SQLCODE);
1991: ar_invoice_utils.debug(SQLERRM);
1992: ROLLBACK TO Delete_Transaction_PUB;
1993: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1994: Display_Parameters;

Line 1991: ar_invoice_utils.debug(SQLERRM);

1987:
1988: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1989:
1990: ar_invoice_utils.debug(SQLCODE);
1991: ar_invoice_utils.debug(SQLERRM);
1992: ROLLBACK TO Delete_Transaction_PUB;
1993: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1994: Display_Parameters;
1995:

Line 2001: ar_invoice_utils.debug(SQLCODE);

1997: p_data => p_msg_data
1998: );
1999:
2000: WHEN OTHERS THEN
2001: ar_invoice_utils.debug(SQLCODE);
2002: ar_invoice_utils.debug(SQLERRM);
2003: /*-------------------------------------------------------+
2004: | Handle application errors that result from trapable |
2005: | error conditions. The error messages have already |

Line 2002: ar_invoice_utils.debug(SQLERRM);

1998: );
1999:
2000: WHEN OTHERS THEN
2001: ar_invoice_utils.debug(SQLCODE);
2002: ar_invoice_utils.debug(SQLERRM);
2003: /*-------------------------------------------------------+
2004: | Handle application errors that result from trapable |
2005: | error conditions. The error messages have already |
2006: | been put on the error stack. |

Line 2017: ar_invoice_utils.debug('Completion validation error(s) occurred. ' ||

2013: ROLLBACK TO Delete_Transaction_PUB;
2014:
2015: p_return_status := FND_API.G_RET_STS_ERROR ;
2016:
2017: ar_invoice_utils.debug('Completion validation error(s) occurred. ' ||
2018: 'Rolling back and setting status to ERROR');
2019:
2020: RETURN;
2021:

Line 2062: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.GET_TRXN_LINE_BALANCE (+)' );

2058: l_count NUMBER;
2059:
2060: BEGIN
2061: IF pg_debug = 'Y' THEN
2062: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.GET_TRXN_LINE_BALANCE (+)' );
2063: ar_invoice_utils.debug ('Customer_trx_id: ' || p_customer_trx_id);
2064: ar_invoice_utils.debug ('interface_line_attribute6: ' || p_interface_line_attribute6);
2065: END IF;
2066:

Line 2063: ar_invoice_utils.debug ('Customer_trx_id: ' || p_customer_trx_id);

2059:
2060: BEGIN
2061: IF pg_debug = 'Y' THEN
2062: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.GET_TRXN_LINE_BALANCE (+)' );
2063: ar_invoice_utils.debug ('Customer_trx_id: ' || p_customer_trx_id);
2064: ar_invoice_utils.debug ('interface_line_attribute6: ' || p_interface_line_attribute6);
2065: END IF;
2066:
2067: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2064: ar_invoice_utils.debug ('interface_line_attribute6: ' || p_interface_line_attribute6);

2060: BEGIN
2061: IF pg_debug = 'Y' THEN
2062: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.GET_TRXN_LINE_BALANCE (+)' );
2063: ar_invoice_utils.debug ('Customer_trx_id: ' || p_customer_trx_id);
2064: ar_invoice_utils.debug ('interface_line_attribute6: ' || p_interface_line_attribute6);
2065: END IF;
2066:
2067: x_return_status := FND_API.G_RET_STS_SUCCESS;
2068:

Line 2136: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.GET_TRXN_LINE_BALANCE (-)' );

2132: END;
2133: END IF;
2134:
2135: IF pg_debug = 'Y' THEN
2136: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.GET_TRXN_LINE_BALANCE (-)' );
2137: END IF;
2138: END;
2139:
2140: