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_ADJVALIDATE_PVT dependencies on ARP_UTIL

Line 153: arp_util.debug('Init_Context_Rec()+' , G_MSG_HIGH);

149:
150:
151: BEGIN
152: IF PG_DEBUG in ('Y', 'C') THEN
153: arp_util.debug('Init_Context_Rec()+' , G_MSG_HIGH);
154: END IF;
155:
156:
157: /*---------------------------+

Line 181: arp_util.debug('Init_Context_Rec()-' , G_MSG_HIGH);

177:
178: p_return_status := FND_API.G_RET_STS_SUCCESS;
179:
180: IF PG_DEBUG in ('Y', 'C') THEN
181: arp_util.debug('Init_Context_Rec()-' , G_MSG_HIGH);
182: END IF;
183:
184: EXCEPTION
185: WHEN OTHERS THEN

Line 187: arp_util.debug('EXCEPTION: Init_Context_Rec() ', G_MSG_UERROR);

183:
184: EXCEPTION
185: WHEN OTHERS THEN
186: IF PG_DEBUG in ('Y', 'C') THEN
187: arp_util.debug('EXCEPTION: Init_Context_Rec() ', G_MSG_UERROR);
188: END IF;
189:
190: FND_MSG_PUB.Add_Exc_Msg (
191: G_PKG_NAME,

Line 247: arp_util.debug('Cache_Gl_Periods()+' , G_MSG_HIGH);

243:
244: BEGIN
245:
246: IF PG_DEBUG in ('Y', 'C') THEN
247: arp_util.debug('Cache_Gl_Periods()+' , G_MSG_HIGH);
248: END IF;
249:
250: p_return_status := FND_API.G_RET_STS_SUCCESS;
251:

Line 259: arp_util.debug('Cache_Gl_Periods: ' || 'No Open/Future Enterable GL periods exist',G_MSG_HIGH);

255: FROM ar_system_parameters ;
256: EXCEPTION
257: WHEN NO_DATA_FOUND THEN
258: IF PG_DEBUG in ('Y', 'C') THEN
259: arp_util.debug('Cache_Gl_Periods: ' || 'No Open/Future Enterable GL periods exist',G_MSG_HIGH);
260: END IF;
261: /*-----------------------------------------------+
262: | Set the message |
263: +-----------------------------------------------*/

Line 272: arp_util.debug('EXCEPTION: Cache_Gl_Periods()', G_MSG_UERROR);

268: p_return_status := FND_API.G_RET_STS_ERROR;
269:
270: WHEN OTHERS THEN
271: IF PG_DEBUG in ('Y', 'C') THEN
272: arp_util.debug('EXCEPTION: Cache_Gl_Periods()', G_MSG_UERROR);
273: END IF;
274: /*-----------------------------------------------+
275: | Set unexpected error message and status |
276: +-----------------------------------------------*/

Line 292: arp_util.debug ('Cache_Gl_Periods: ' || 'G_GLPERIOD_TBL count = '|| to_char(g_glperiod_tbl.count), G_MSG_HIGH);

288: G_GLPERIOD_TBL(l_index) := l_temp_rec;
289: END LOOP;
290:
291: IF PG_DEBUG in ('Y', 'C') THEN
292: arp_util.debug ('Cache_Gl_Periods: ' || 'G_GLPERIOD_TBL count = '|| to_char(g_glperiod_tbl.count), G_MSG_HIGH);
293: arp_util.debug ('Cache_Gl_Periods()-' , G_MSG_HIGH);
294: END IF;
295:
296: RETURN;

Line 293: arp_util.debug ('Cache_Gl_Periods()-' , G_MSG_HIGH);

289: END LOOP;
290:
291: IF PG_DEBUG in ('Y', 'C') THEN
292: arp_util.debug ('Cache_Gl_Periods: ' || 'G_GLPERIOD_TBL count = '|| to_char(g_glperiod_tbl.count), G_MSG_HIGH);
293: arp_util.debug ('Cache_Gl_Periods()-' , G_MSG_HIGH);
294: END IF;
295:
296: RETURN;
297:

Line 301: arp_util.debug('Cache_Gl_Periods: ' || 'No Open/Future Enterable GL periods exist',G_MSG_HIGH);

297:
298: EXCEPTION
299: WHEN NO_DATA_FOUND THEN
300: IF PG_DEBUG in ('Y', 'C') THEN
301: arp_util.debug('Cache_Gl_Periods: ' || 'No Open/Future Enterable GL periods exist',G_MSG_HIGH);
302: END IF;
303: /*-----------------------------------------------+
304: | Set the message |
305: +-----------------------------------------------*/

Line 313: arp_util.debug('EXCEPTION: Cache_Gl_Periods()', G_MSG_UERROR);

309:
310: p_return_status := FND_API.G_RET_STS_ERROR;
311: WHEN OTHERS THEN
312: IF PG_DEBUG in ('Y', 'C') THEN
313: arp_util.debug('EXCEPTION: Cache_Gl_Periods()', G_MSG_UERROR);
314: END IF;
315: /*-----------------------------------------------+
316: | Set unexpected error message and status |
317: +-----------------------------------------------*/

Line 357: arp_util.debug('Cache_Approval_Type()+' , G_MSG_HIGH);

353:
354: BEGIN
355:
356: IF PG_DEBUG in ('Y', 'C') THEN
357: arp_util.debug('Cache_Approval_Type()+' , G_MSG_HIGH);
358: END IF;
359:
360: p_return_status := FND_API.G_RET_STS_SUCCESS;
361:

Line 368: arp_util.debug ('Cache_Approval_Type: ' || 'G_APPROVAL_TBL count = '|| to_char(G_APPROVAL_TBL.count), G_MSG_HIGH);

364: G_APPROVAL_TBL(l_index) := l_temp_rec;
365: END LOOP;
366:
367: IF PG_DEBUG in ('Y', 'C') THEN
368: arp_util.debug ('Cache_Approval_Type: ' || 'G_APPROVAL_TBL count = '|| to_char(G_APPROVAL_TBL.count), G_MSG_HIGH);
369: arp_util.debug ('Cache_Approval_Type()-' , G_MSG_HIGH);
370: END IF;
371:
372: RETURN;

Line 369: arp_util.debug ('Cache_Approval_Type()-' , G_MSG_HIGH);

365: END LOOP;
366:
367: IF PG_DEBUG in ('Y', 'C') THEN
368: arp_util.debug ('Cache_Approval_Type: ' || 'G_APPROVAL_TBL count = '|| to_char(G_APPROVAL_TBL.count), G_MSG_HIGH);
369: arp_util.debug ('Cache_Approval_Type()-' , G_MSG_HIGH);
370: END IF;
371:
372: RETURN;
373:

Line 377: arp_util.debug('Cache_Approval_Type: ' || 'No Approval Codes exist ', G_MSG_HIGH);

373:
374: EXCEPTION
375: WHEN NO_DATA_FOUND THEN
376: IF PG_DEBUG in ('Y', 'C') THEN
377: arp_util.debug('Cache_Approval_Type: ' || 'No Approval Codes exist ', G_MSG_HIGH);
378: END IF;
379: /*-----------------------------------------------+
380: | Set the message |
381: +-----------------------------------------------*/

Line 390: arp_util.debug('EXCEPTION: Cache_Approval_Type()', G_MSG_UERROR);

386: p_return_status := FND_API.G_RET_STS_ERROR ;
387:
388: WHEN OTHERS THEN
389: IF PG_DEBUG in ('Y', 'C') THEN
390: arp_util.debug('EXCEPTION: Cache_Approval_Type()', G_MSG_UERROR);
391: END IF;
392: /*-----------------------------------------------+
393: | Set unexpected error message and status |
394: +-----------------------------------------------*/

Line 433: arp_util.debug('Cache_Adjustment_Type()+' , G_MSG_HIGH);

429:
430: BEGIN
431:
432: IF PG_DEBUG in ('Y', 'C') THEN
433: arp_util.debug('Cache_Adjustment_Type()+' , G_MSG_HIGH);
434: END IF;
435:
436: p_return_status := FND_API.G_RET_STS_SUCCESS;
437:

Line 444: arp_util.debug ('Cache_Adjustment_Type: ' || 'G_ADJTYPE_TBL count = '|| to_char(G_ADJTYPE_TBL.count), G_MSG_HIGH);

440: G_ADJTYPE_TBL(l_index) := l_temp_rec;
441: END LOOP;
442:
443: IF PG_DEBUG in ('Y', 'C') THEN
444: arp_util.debug ('Cache_Adjustment_Type: ' || 'G_ADJTYPE_TBL count = '|| to_char(G_ADJTYPE_TBL.count), G_MSG_HIGH);
445: arp_util.debug ('Cache_Adjustment_Type()-' , G_MSG_HIGH);
446: END IF;
447:
448: RETURN;

Line 445: arp_util.debug ('Cache_Adjustment_Type()-' , G_MSG_HIGH);

441: END LOOP;
442:
443: IF PG_DEBUG in ('Y', 'C') THEN
444: arp_util.debug ('Cache_Adjustment_Type: ' || 'G_ADJTYPE_TBL count = '|| to_char(G_ADJTYPE_TBL.count), G_MSG_HIGH);
445: arp_util.debug ('Cache_Adjustment_Type()-' , G_MSG_HIGH);
446: END IF;
447:
448: RETURN;
449:

Line 453: arp_util.debug('Cache_Adjustment_Type: ' || 'No Adjustment Type codes', G_MSG_HIGH);

449:
450: EXCEPTION
451: WHEN NO_DATA_FOUND THEN
452: IF PG_DEBUG in ('Y', 'C') THEN
453: arp_util.debug('Cache_Adjustment_Type: ' || 'No Adjustment Type codes', G_MSG_HIGH);
454: END IF;
455: /*-----------------------------------------------+
456: | Set the message |
457: +-----------------------------------------------*/

Line 465: arp_util.debug('EXCEPTION: Cache_Adjustment_Type()', G_MSG_UERROR);

461: p_return_status := FND_API.G_RET_STS_ERROR ;
462:
463: WHEN OTHERS THEN
464: IF PG_DEBUG in ('Y', 'C') THEN
465: arp_util.debug('EXCEPTION: Cache_Adjustment_Type()', G_MSG_UERROR);
466: END IF;
467: /*-----------------------------------------------+
468: | Set unexpected error message and status |
469: +-----------------------------------------------*/

Line 508: arp_util.debug('Cache_Adjustment_Reason()+' , G_MSG_HIGH);

504:
505: BEGIN
506:
507: IF PG_DEBUG in ('Y', 'C') THEN
508: arp_util.debug('Cache_Adjustment_Reason()+' , G_MSG_HIGH);
509: END IF;
510:
511: p_return_status := FND_API.G_RET_STS_SUCCESS;
512:

Line 519: arp_util.debug ('Cache_Adjustment_Reason: ' || 'G_REASON_TBL count = '|| to_char(G_REASON_TBL.count), G_MSG_HIGH);

515: G_REASON_TBL(l_index) := l_temp_rec;
516: END LOOP;
517:
518: IF PG_DEBUG in ('Y', 'C') THEN
519: arp_util.debug ('Cache_Adjustment_Reason: ' || 'G_REASON_TBL count = '|| to_char(G_REASON_TBL.count), G_MSG_HIGH);
520: arp_util.debug ('Cache_Adjustment_Reason()-' , G_MSG_HIGH);
521: END IF;
522:
523: RETURN;

Line 520: arp_util.debug ('Cache_Adjustment_Reason()-' , G_MSG_HIGH);

516: END LOOP;
517:
518: IF PG_DEBUG in ('Y', 'C') THEN
519: arp_util.debug ('Cache_Adjustment_Reason: ' || 'G_REASON_TBL count = '|| to_char(G_REASON_TBL.count), G_MSG_HIGH);
520: arp_util.debug ('Cache_Adjustment_Reason()-' , G_MSG_HIGH);
521: END IF;
522:
523: RETURN;
524:

Line 528: arp_util.debug('Cache_Adjustment_Reason: ' || 'No Adjustment Reason codes', G_MSG_HIGH);

524:
525: EXCEPTION
526: WHEN NO_DATA_FOUND THEN
527: IF PG_DEBUG in ('Y', 'C') THEN
528: arp_util.debug('Cache_Adjustment_Reason: ' || 'No Adjustment Reason codes', G_MSG_HIGH);
529: END IF;
530: /*-----------------------------------------------+
531: | Set the message |
532: +-----------------------------------------------*/

Line 540: arp_util.debug('EXCEPTION: Cache_Adjustment_Reason()', G_MSG_UERROR);

536: p_return_status := FND_API.G_RET_STS_ERROR ;
537:
538: WHEN OTHERS THEN
539: IF PG_DEBUG in ('Y', 'C') THEN
540: arp_util.debug('EXCEPTION: Cache_Adjustment_Reason()', G_MSG_UERROR);
541: END IF;
542: /*-----------------------------------------------+
543: | Set unexpected error message and status |
544: +-----------------------------------------------*/

Line 606: arp_util.debug('Cache_Receivables_Trx()+' , G_MSG_HIGH);

602:
603: BEGIN
604:
605: IF PG_DEBUG in ('Y', 'C') THEN
606: arp_util.debug('Cache_Receivables_Trx()+' , G_MSG_HIGH);
607: END IF;
608:
609: p_return_status := FND_API.G_RET_STS_SUCCESS;
610:

Line 617: arp_util.debug ('Cache_Receivables_Trx: ' || 'G_RCVTRX_TBL count = '|| to_char(G_RCVTRX_TBL.count), G_MSG_HIGH);

613: G_RCVTRX_TBL(l_index) := l_temp_rec;
614: END LOOP;
615:
616: IF PG_DEBUG in ('Y', 'C') THEN
617: arp_util.debug ('Cache_Receivables_Trx: ' || 'G_RCVTRX_TBL count = '|| to_char(G_RCVTRX_TBL.count), G_MSG_HIGH);
618: arp_util.debug ('Cache_Receivables_Trx()-' , G_MSG_HIGH);
619: END IF;
620:
621: RETURN;

Line 618: arp_util.debug ('Cache_Receivables_Trx()-' , G_MSG_HIGH);

614: END LOOP;
615:
616: IF PG_DEBUG in ('Y', 'C') THEN
617: arp_util.debug ('Cache_Receivables_Trx: ' || 'G_RCVTRX_TBL count = '|| to_char(G_RCVTRX_TBL.count), G_MSG_HIGH);
618: arp_util.debug ('Cache_Receivables_Trx()-' , G_MSG_HIGH);
619: END IF;
620:
621: RETURN;
622:

Line 626: arp_util.debug('Cache_Receivables_Trx: ' || 'No Adjustment Reason codes', G_MSG_HIGH);

622:
623: EXCEPTION
624: WHEN NO_DATA_FOUND THEN
625: IF PG_DEBUG in ('Y', 'C') THEN
626: arp_util.debug('Cache_Receivables_Trx: ' || 'No Adjustment Reason codes', G_MSG_HIGH);
627: END IF;
628: /*-----------------------------------------------+
629: | Set the message |
630: +-----------------------------------------------*/

Line 639: arp_util.debug('EXCEPTION: Cache_Receivables_Trx()', G_MSG_UERROR);

635: p_return_status := FND_API.G_RET_STS_ERROR ;
636:
637: WHEN OTHERS THEN
638: IF PG_DEBUG in ('Y', 'C') THEN
639: arp_util.debug('EXCEPTION: Cache_Receivables_Trx()', G_MSG_UERROR);
640: END IF;
641: /*-----------------------------------------------+
642: | Set unexpected error message and status |
643: +-----------------------------------------------*/

Line 691: arp_util.debug('Cache_Ussgl_Code()+' , G_MSG_HIGH);

687:
688: BEGIN
689:
690: IF PG_DEBUG in ('Y', 'C') THEN
691: arp_util.debug('Cache_Ussgl_Code()+' , G_MSG_HIGH);
692: END IF;
693:
694: p_return_status := FND_API.G_RET_STS_SUCCESS;
695:

Line 711: arp_util.debug ('Cache_Ussgl_Code: ' || 'G_USSGL_TBL count = '|| to_char(G_USSGL_TBL.count), G_MSG_HIGH);

707: G_USSGL_TBL(l_index) := l_temp_rec;
708: END LOOP;
709:
710: IF PG_DEBUG in ('Y', 'C') THEN
711: arp_util.debug ('Cache_Ussgl_Code: ' || 'G_USSGL_TBL count = '|| to_char(G_USSGL_TBL.count), G_MSG_HIGH);
712: arp_util.debug ('Cache_Ussgl_Code()-' , G_MSG_HIGH);
713: END IF;
714:
715: RETURN;

Line 712: arp_util.debug ('Cache_Ussgl_Code()-' , G_MSG_HIGH);

708: END LOOP;
709:
710: IF PG_DEBUG in ('Y', 'C') THEN
711: arp_util.debug ('Cache_Ussgl_Code: ' || 'G_USSGL_TBL count = '|| to_char(G_USSGL_TBL.count), G_MSG_HIGH);
712: arp_util.debug ('Cache_Ussgl_Code()-' , G_MSG_HIGH);
713: END IF;
714:
715: RETURN;
716:

Line 720: arp_util.debug('Cache_Ussgl_Code: ' || 'No USSGL codes', G_MSG_HIGH);

716:
717: EXCEPTION
718: WHEN NO_DATA_FOUND THEN
719: IF PG_DEBUG in ('Y', 'C') THEN
720: arp_util.debug('Cache_Ussgl_Code: ' || 'No USSGL codes', G_MSG_HIGH);
721: END IF;
722: /*-----------------------------------------------+
723: | Set the message |
724: +-----------------------------------------------*/

Line 733: arp_util.debug('EXCEPTION: Cache_Ussgl_Code()', G_MSG_UERROR);

729: p_return_status := FND_API.G_RET_STS_SUCCESS ;
730:
731: WHEN OTHERS THEN
732: IF PG_DEBUG in ('Y', 'C') THEN
733: arp_util.debug('EXCEPTION: Cache_Ussgl_Code()', G_MSG_UERROR);
734: END IF;
735: /*-----------------------------------------------+
736: | Set unexpected error message and status |
737: +-----------------------------------------------*/

Line 792: arp_util.debug('Cache_Code_Combination()+' , G_MSG_HIGH);

788:
789: BEGIN
790:
791: IF PG_DEBUG in ('Y', 'C') THEN
792: arp_util.debug('Cache_Code_Combination()+' , G_MSG_HIGH);
793: END IF;
794:
795: p_return_status := FND_API.G_RET_STS_SUCCESS;
796:

Line 807: arp_util.debug ('Cache_Code_Combination: ' || 'G_CCID_TBL count = '|| to_char(G_CCID_TBL.count), G_MSG_HIGH);

803: G_CCID_TBL(l_ccid_rec.code_combination_id).dummy := FND_API.G_TRUE;
804: END LOOP;
805:
806: IF PG_DEBUG in ('Y', 'C') THEN
807: arp_util.debug ('Cache_Code_Combination: ' || 'G_CCID_TBL count = '|| to_char(G_CCID_TBL.count), G_MSG_HIGH);
808: arp_util.debug ('Cache_Code_Combination()-' , G_MSG_HIGH);
809: END IF;
810:
811: RETURN;

Line 808: arp_util.debug ('Cache_Code_Combination()-' , G_MSG_HIGH);

804: END LOOP;
805:
806: IF PG_DEBUG in ('Y', 'C') THEN
807: arp_util.debug ('Cache_Code_Combination: ' || 'G_CCID_TBL count = '|| to_char(G_CCID_TBL.count), G_MSG_HIGH);
808: arp_util.debug ('Cache_Code_Combination()-' , G_MSG_HIGH);
809: END IF;
810:
811: RETURN;
812:

Line 816: arp_util.debug('Cache_Code_Combination: ' || 'No USSGL codes', G_MSG_HIGH);

812:
813: EXCEPTION
814: WHEN NO_DATA_FOUND THEN
815: IF PG_DEBUG in ('Y', 'C') THEN
816: arp_util.debug('Cache_Code_Combination: ' || 'No USSGL codes', G_MSG_HIGH);
817: END IF;
818: /*-----------------------------------------------+
819: | Set the message |
820: +-----------------------------------------------*/

Line 829: arp_util.debug('EXCEPTION: Cache_Code_Combination()', G_MSG_UERROR);

825: p_return_status := FND_API.G_RET_STS_ERROR ;
826:
827: WHEN OTHERS THEN
828: IF PG_DEBUG in ('Y', 'C') THEN
829: arp_util.debug('EXCEPTION: Cache_Code_Combination()', G_MSG_UERROR);
830: END IF;
831: /*-----------------------------------------------+
832: | Set unexpected error message and status |
833: +-----------------------------------------------*/

Line 895: arp_util.debug('Cache_Details()+' , G_MSG_HIGH);

891:
892: BEGIN
893:
894: IF PG_DEBUG in ('Y', 'C') THEN
895: arp_util.debug('Cache_Details()+' , G_MSG_HIGH);
896: END IF;
897:
898: /*--------------------------------------------------+
899: | Check if caching is needed. Caching is needed if|

Line 906: arp_util.debug ('Cache_Details: ' || 'G_Caching done = ' || G_caching_done, G_MSG_HIGH);

902:
903: l_tobe_cached_flag := FND_API.G_FALSE ;
904:
905: IF PG_DEBUG in ('Y', 'C') THEN
906: arp_util.debug ('Cache_Details: ' || 'G_Caching done = ' || G_caching_done, G_MSG_HIGH);
907: arp_util.debug ('Cache_Details: ' || 'G_Cache_date = ' || to_char(G_cache_date,'DD-MON-YY'),
908: G_MSG_HIGH);
909: arp_util.debug ('Cache_Details: ' || 'Sysdate = ' || to_char(sysdate,'DD-MON-YY'),G_MSG_HIGH);
910: END IF;

Line 907: arp_util.debug ('Cache_Details: ' || 'G_Cache_date = ' || to_char(G_cache_date,'DD-MON-YY'),

903: l_tobe_cached_flag := FND_API.G_FALSE ;
904:
905: IF PG_DEBUG in ('Y', 'C') THEN
906: arp_util.debug ('Cache_Details: ' || 'G_Caching done = ' || G_caching_done, G_MSG_HIGH);
907: arp_util.debug ('Cache_Details: ' || 'G_Cache_date = ' || to_char(G_cache_date,'DD-MON-YY'),
908: G_MSG_HIGH);
909: arp_util.debug ('Cache_Details: ' || 'Sysdate = ' || to_char(sysdate,'DD-MON-YY'),G_MSG_HIGH);
910: END IF;
911:

Line 909: arp_util.debug ('Cache_Details: ' || 'Sysdate = ' || to_char(sysdate,'DD-MON-YY'),G_MSG_HIGH);

905: IF PG_DEBUG in ('Y', 'C') THEN
906: arp_util.debug ('Cache_Details: ' || 'G_Caching done = ' || G_caching_done, G_MSG_HIGH);
907: arp_util.debug ('Cache_Details: ' || 'G_Cache_date = ' || to_char(G_cache_date,'DD-MON-YY'),
908: G_MSG_HIGH);
909: arp_util.debug ('Cache_Details: ' || 'Sysdate = ' || to_char(sysdate,'DD-MON-YY'),G_MSG_HIGH);
910: END IF;
911:
912: IF ( G_caching_done = FND_API.G_FALSE )
913: THEN

Line 933: arp_util.debug ('Cache_Details: ' || 'Caching Flag : '|| l_tobe_cached_flag,G_MSG_HIGH);

929: l_tobe_cached_flag := FND_API.G_TRUE;
930: END IF;
931:
932: IF PG_DEBUG in ('Y', 'C') THEN
933: arp_util.debug ('Cache_Details: ' || 'Caching Flag : '|| l_tobe_cached_flag,G_MSG_HIGH);
934: END IF;
935:
936: IF ( l_tobe_cached_flag = FND_API.G_FALSE )
937: THEN

Line 970: arp_util.debug('Cache_Details: ' || ' failed to cache approval_type');

966: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
967: THEN
968: p_return_status := l_return_status;
969: IF PG_DEBUG in ('Y', 'C') THEN
970: arp_util.debug('Cache_Details: ' || ' failed to cache approval_type');
971: END IF;
972: END IF;
973: /*-------------------------------------------------+
974: | Cache reason codes for adjustment. To be used |

Line 983: arp_util.debug ('Cache_Details: ' || ' failed to cache adjustment_reason');

979: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
980: THEN
981: p_return_status := l_return_status;
982: IF PG_DEBUG in ('Y', 'C') THEN
983: arp_util.debug ('Cache_Details: ' || ' failed to cache adjustment_reason');
984: END IF;
985: END IF;
986:
987: /*-------------------------------------------------+

Line 997: arp_util.debug ('Cache_Details: ' || ' failed to cache adjustment_type');

993: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
994: THEN
995: p_return_status := l_return_status;
996: IF PG_DEBUG in ('Y', 'C') THEN
997: arp_util.debug ('Cache_Details: ' || ' failed to cache adjustment_type');
998: END IF;
999: END IF;
1000:
1001: /*-------------------------------------------------+

Line 1012: arp_util.debug ('Cache_Details: ' || ' failed to cache receivables_trx');

1008: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
1009: THEN
1010: p_return_status := l_return_status;
1011: IF PG_DEBUG in ('Y', 'C') THEN
1012: arp_util.debug ('Cache_Details: ' || ' failed to cache receivables_trx');
1013: END IF;
1014: END IF;
1015:
1016: /*-------------------------------------------------+

Line 1026: arp_util.debug ('Cache_Details: ' || ' failed to cache ussgl_code');

1022: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
1023: THEN
1024: p_return_status := l_return_status;
1025: IF PG_DEBUG in ('Y', 'C') THEN
1026: arp_util.debug ('Cache_Details: ' || ' failed to cache ussgl_code');
1027: END IF;
1028: END IF;
1029:
1030: /*--------------------------------------------------+

Line 1040: arp_util.debug ('Cache_Details: ' || ' failed to cache gl_periods');

1036: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
1037: THEN
1038: p_return_status := l_return_status;
1039: IF PG_DEBUG in ('Y', 'C') THEN
1040: arp_util.debug ('Cache_Details: ' || ' failed to cache gl_periods');
1041: END IF;
1042: END IF;
1043:
1044: /*--------------------------------------------------+

Line 1054: arp_util.debug ('Cache_Details: ' || ' failed to cache code_combination');

1050: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
1051: THEN
1052: p_return_status := l_return_status;
1053: IF PG_DEBUG in ('Y', 'C') THEN
1054: arp_util.debug ('Cache_Details: ' || ' failed to cache code_combination');
1055: END IF;
1056: END IF;
1057:
1058: G_caching_done := FND_API.G_TRUE ;

Line 1061: arp_util.debug('Cache_Details ()-' , G_MSG_HIGH);

1057:
1058: G_caching_done := FND_API.G_TRUE ;
1059:
1060: IF PG_DEBUG in ('Y', 'C') THEN
1061: arp_util.debug('Cache_Details ()-' , G_MSG_HIGH);
1062: END IF;
1063:
1064: EXCEPTION
1065: WHEN OTHERS THEN

Line 1067: arp_util.debug('EXCEPTION: Cache_Details() ', G_MSG_UERROR);

1063:
1064: EXCEPTION
1065: WHEN OTHERS THEN
1066: IF PG_DEBUG in ('Y', 'C') THEN
1067: arp_util.debug('EXCEPTION: Cache_Details() ', G_MSG_UERROR);
1068: END IF;
1069:
1070: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Cache_Details');
1071: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1088: | arp_util.disable_debug |

1084: | |
1085: | SCOPE - PRIVATE |
1086: | |
1087: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1088: | arp_util.disable_debug |
1089: | arp_util.enable_debug |
1090: | fnd_api.g_exc_unexpected_error |
1091: | fnd_api.g_ret_sts_error |
1092: | fnd_api.g_ret_sts_error |

Line 1089: | arp_util.enable_debug |

1085: | SCOPE - PRIVATE |
1086: | |
1087: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1088: | arp_util.disable_debug |
1089: | arp_util.enable_debug |
1090: | fnd_api.g_exc_unexpected_error |
1091: | fnd_api.g_ret_sts_error |
1092: | fnd_api.g_ret_sts_error |
1093: | fnd_api.g_ret_sts_success |

Line 1128: arp_util.debug('Within_approval_limits()+', G_MSG_MEDIUM);

1124:
1125: BEGIN
1126:
1127: IF PG_DEBUG in ('Y', 'C') THEN
1128: arp_util.debug('Within_approval_limits()+', G_MSG_MEDIUM);
1129: END IF;
1130:
1131: /*------------------------------------------+
1132: | Initialize the return status to SUCCESS |

Line 1159: arp_util.debug ('Within_approval_limits: ' || 'User Id : ' || l_user_id);

1155: EXCEPTION
1156: WHEN NO_DATA_FOUND THEN
1157:
1158: IF PG_DEBUG in ('Y', 'C') THEN
1159: arp_util.debug ('Within_approval_limits: ' || 'User Id : ' || l_user_id);
1160: arp_util.debug ('Within_approval_limits: ' ||
1161: 'User does not have approval limits for currency ' ||
1162: p_inv_curr_code, G_MSG_HIGH
1163: );

Line 1160: arp_util.debug ('Within_approval_limits: ' ||

1156: WHEN NO_DATA_FOUND THEN
1157:
1158: IF PG_DEBUG in ('Y', 'C') THEN
1159: arp_util.debug ('Within_approval_limits: ' || 'User Id : ' || l_user_id);
1160: arp_util.debug ('Within_approval_limits: ' ||
1161: 'User does not have approval limits for currency ' ||
1162: p_inv_curr_code, G_MSG_HIGH
1163: );
1164: END IF;

Line 1174: arp_util.debug ('EXCEPTION: Within_approval_limits',G_MSG_UERROR);

1170:
1171: WHEN OTHERS THEN
1172:
1173: IF PG_DEBUG in ('Y', 'C') THEN
1174: arp_util.debug ('EXCEPTION: Within_approval_limits',G_MSG_UERROR);
1175: END IF;
1176:
1177: /*-------------------------------------------------+
1178: | Set unexpected error message, status and return |

Line 1199: arp_util.debug('Within_approval_limits: ' || 'User ID: ' || l_user_id ||

1195: IF (( p_adj_amount > l_approval_amount_to ) OR
1196: ( p_adj_amount < l_approval_amount_from ))
1197: THEN
1198: IF PG_DEBUG in ('Y', 'C') THEN
1199: arp_util.debug('Within_approval_limits: ' || 'User ID: ' || l_user_id ||
1200: ' Amount: ' || p_adj_amount ||
1201: ' From: ' || l_approval_amount_from ||
1202: ' To: ' || l_approval_amount_to ||
1203: ' exceeds approval limit', G_MSG_HIGH );

Line 1219: arp_util.debug('Within_approval_limits()-', G_MSG_HIGH);

1215:
1216: END IF;
1217:
1218: IF PG_DEBUG in ('Y', 'C') THEN
1219: arp_util.debug('Within_approval_limits()-', G_MSG_HIGH);
1220: END IF;
1221: RETURN ;
1222:
1223: EXCEPTION

Line 1227: arp_util.debug('EXCEPTION: Within_approval_limits()', G_MSG_UERROR);

1223: EXCEPTION
1224: WHEN OTHERS THEN
1225:
1226: IF PG_DEBUG in ('Y', 'C') THEN
1227: arp_util.debug('EXCEPTION: Within_approval_limits()', G_MSG_UERROR);
1228: END IF;
1229: /*-----------------------------------------------+
1230: | Set unexpected error message and status |
1231: +-----------------------------------------------*/

Line 1277: arp_util.debug('Validate buckets()+', G_MSG_MEDIUM);

1273:
1274: BEGIN
1275:
1276: IF PG_DEBUG in ('Y', 'C') THEN
1277: arp_util.debug('Validate buckets()+', G_MSG_MEDIUM);
1278: END IF;
1279:
1280: /*------------------------------------------+
1281: | Initialize the return status to SUCCESS |

Line 1374: arp_util.debug('Validate buckets()-', G_MSG_MEDIUM);

1370: END IF;
1371: END IF;
1372:
1373: IF PG_DEBUG in ('Y', 'C') THEN
1374: arp_util.debug('Validate buckets()-', G_MSG_MEDIUM);
1375: END IF;
1376:
1377: RETURN;
1378:

Line 1383: arp_util.debug('EXCEPTION: Validate_buckets()', G_MSG_UERROR);

1379: EXCEPTION
1380: WHEN OTHERS THEN
1381:
1382: IF PG_DEBUG in ('Y', 'C') THEN
1383: arp_util.debug('EXCEPTION: Validate_buckets()', G_MSG_UERROR);
1384: END IF;
1385: /*-----------------------------------------------+
1386: | Set unexpected error message and status |
1387: +-----------------------------------------------*/

Line 1408: | arp_util.disable_debug |

1404: | |
1405: | SCOPE - PUBLIC |
1406: | |
1407: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1408: | arp_util.disable_debug |
1409: | arp_util.enable_debug |
1410: | fnd_api.g_exc_unexpected_error |
1411: | fnd_api.g_ret_sts_error |
1412: | fnd_api.g_ret_sts_error |

Line 1409: | arp_util.enable_debug |

1405: | SCOPE - PUBLIC |
1406: | |
1407: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1408: | arp_util.disable_debug |
1409: | arp_util.enable_debug |
1410: | fnd_api.g_exc_unexpected_error |
1411: | fnd_api.g_ret_sts_error |
1412: | fnd_api.g_ret_sts_error |
1413: | fnd_api.g_ret_sts_success |

Line 1442: arp_util.debug('Validate_Type()+', G_MSG_HIGH);

1438: l_index number;
1439: BEGIN
1440:
1441: IF PG_DEBUG in ('Y', 'C') THEN
1442: arp_util.debug('Validate_Type()+', G_MSG_HIGH);
1443: END IF;
1444:
1445: /*------------------------------------------+
1446: | Initialize the return status to ERROR |

Line 1474: arp_util.debug('Validate_Type()-', G_MSG_MEDIUM);

1470:
1471: END IF;
1472:
1473: IF PG_DEBUG in ('Y', 'C') THEN
1474: arp_util.debug('Validate_Type()-', G_MSG_MEDIUM);
1475: END IF;
1476:
1477:
1478: EXCEPTION

Line 1482: arp_util.debug('EXCEPTION: Validate_Type()', G_MSG_UERROR );

1478: EXCEPTION
1479: WHEN OTHERS THEN
1480:
1481: IF PG_DEBUG in ('Y', 'C') THEN
1482: arp_util.debug('EXCEPTION: Validate_Type()', G_MSG_UERROR );
1483: arp_util.debug('Validate_Type for type = ' ||p_adj_rec.type,G_MSG_HIGH);
1484: END IF;
1485:
1486: /*-----------------------------------------------+

Line 1483: arp_util.debug('Validate_Type for type = ' ||p_adj_rec.type,G_MSG_HIGH);

1479: WHEN OTHERS THEN
1480:
1481: IF PG_DEBUG in ('Y', 'C') THEN
1482: arp_util.debug('EXCEPTION: Validate_Type()', G_MSG_UERROR );
1483: arp_util.debug('Validate_Type for type = ' ||p_adj_rec.type,G_MSG_HIGH);
1484: END IF;
1485:
1486: /*-----------------------------------------------+
1487: | Set unexpected error message and status |

Line 1556: arp_util.debug('Validate_Payschd()+', G_MSG_MEDIUM);

1552:
1553: BEGIN
1554:
1555: IF PG_DEBUG in ('Y', 'C') THEN
1556: arp_util.debug('Validate_Payschd()+', G_MSG_MEDIUM);
1557: arp_util.debug('p_from_llca_call :'|| p_from_llca_call);
1558: END IF;
1559:
1560: /*------------------------------------------+

Line 1557: arp_util.debug('p_from_llca_call :'|| p_from_llca_call);

1553: BEGIN
1554:
1555: IF PG_DEBUG in ('Y', 'C') THEN
1556: arp_util.debug('Validate_Payschd()+', G_MSG_MEDIUM);
1557: arp_util.debug('p_from_llca_call :'|| p_from_llca_call);
1558: END IF;
1559:
1560: /*------------------------------------------+
1561: | Initialize the return status to SUCCESS |

Line 1591: arp_util.debug('Validate_Payschd: ' || 'payment schedule id is invalid');

1587:
1588: p_return_status := FND_API.G_RET_STS_ERROR;
1589:
1590: IF PG_DEBUG in ('Y', 'C') THEN
1591: arp_util.debug('Validate_Payschd: ' || 'payment schedule id is invalid');
1592: END IF;
1593:
1594: END IF ;
1595:

Line 1621: arp_util.debug('Validate_Payschd: ' || 'payment schedule id is invalid');

1617: FND_MESSAGE.SET_TOKEN('PAYMENT_SCHEDULE_ID',to_char(p_adj_rec.payment_schedule_id)) ;
1618: FND_MSG_PUB.ADD ;
1619: p_return_status := FND_API.G_RET_STS_ERROR;
1620: IF PG_DEBUG in ('Y', 'C') THEN
1621: arp_util.debug('Validate_Payschd: ' || 'payment schedule id is invalid');
1622: END IF;
1623: END ;
1624:
1625: /*-----------------------------------------------+

Line 1641: arp_util.debug('Validate_Payschd: ' || 'class of transaction is invalid');

1637: FND_MSG_PUB.ADD ;
1638:
1639: p_return_status := FND_API.G_RET_STS_ERROR;
1640: IF PG_DEBUG in ('Y', 'C') THEN
1641: arp_util.debug('Validate_Payschd: ' || 'class of transaction is invalid');
1642: END IF;
1643: END IF;
1644:
1645: /*-----------------------------------------------+

Line 1662: arp_util.debug('Validate_Payschd: ' || 'there is no valid customer trx id for the paysch id');

1658: FND_MESSAGE.SET_TOKEN('PAYMENT_SCHEDULE_ID',to_char(p_adj_rec.payment_schedule_id));
1659: FND_MSG_PUB.ADD ;
1660: p_return_status := FND_API.G_RET_STS_ERROR;
1661: IF PG_DEBUG in ('Y', 'C') THEN
1662: arp_util.debug('Validate_Payschd: ' || 'there is no valid customer trx id for the paysch id');
1663: END IF;
1664:
1665: END IF;
1666:

Line 1685: arp_util.debug('Validate_Payschd: ' || 'there is no valid customer id for the paysch id');

1681: FND_MSG_PUB.ADD ;
1682:
1683: p_return_status := FND_API.G_RET_STS_ERROR;
1684: IF PG_DEBUG in ('Y', 'C') THEN
1685: arp_util.debug('Validate_Payschd: ' || 'there is no valid customer id for the paysch id');
1686: END IF;
1687:
1688: END IF;
1689:

Line 1717: arp_util.debug('Validate_Payschd: ' ||

1713:
1714: EXCEPTION
1715: WHEN OTHERS THEN
1716: IF PG_DEBUG in ('Y', 'C') THEN
1717: arp_util.debug('Validate_Payschd: ' ||
1718: 'EXCEPTION: Validate_Payschd() for CustTrxLineId = '||
1719: to_char(p_adj_rec.customer_trx_line_id), G_MSG_HIGH);
1720: END IF;
1721:

Line 1763: arp_util.debug('Validate_Payschd: ' || 'customer trx line id is invalid');

1759: FND_MSG_PUB.ADD ;
1760:
1761: p_return_status := FND_API.G_RET_STS_ERROR;
1762: IF PG_DEBUG in ('Y', 'C') THEN
1763: arp_util.debug('Validate_Payschd: ' || 'customer trx line id is invalid');
1764: END IF;
1765:
1766: ELSE
1767: insert into ar_llca_adj_trx_errors_gt

Line 1808: arp_util.debug('Validate_Payschd: ' || 'customer trx line id is missing for adj type = LINE');

1804:
1805: p_return_status := FND_API.G_RET_STS_ERROR;
1806:
1807: IF PG_DEBUG in ('Y', 'C') THEN
1808: arp_util.debug('Validate_Payschd: ' || 'customer trx line id is missing for adj type = LINE');
1809: END IF;
1810: END IF;
1811: */
1812: END IF ;

Line 1830: arp_util.debug('Validate_Payschd: ' || 'customer trx line id is not required for adj type ');

1826: FND_MSG_PUB.ADD ;
1827:
1828: p_return_status := FND_API.G_RET_STS_ERROR;
1829: IF PG_DEBUG in ('Y', 'C') THEN
1830: arp_util.debug('Validate_Payschd: ' || 'customer trx line id is not required for adj type ');
1831: END IF;
1832: END IF;
1833:
1834: END IF;

Line 1837: arp_util.debug('Validate_Payschd()-', G_MSG_MEDIUM);

1833:
1834: END IF;
1835:
1836: IF PG_DEBUG in ('Y', 'C') THEN
1837: arp_util.debug('Validate_Payschd()-', G_MSG_MEDIUM);
1838: END IF;
1839:
1840: RETURN ;
1841:

Line 1848: arp_util.debug('EXCEPTION: Validate_Payschd() ', G_MSG_UERROR);

1844:
1845: WHEN OTHERS THEN
1846:
1847: IF PG_DEBUG in ('Y', 'C') THEN
1848: arp_util.debug('EXCEPTION: Validate_Payschd() ', G_MSG_UERROR);
1849: arp_util.debug('Validate_Payschd: ' || 'Payment Schedule = ' ||
1850: p_adj_rec.payment_schedule_id, G_MSG_HIGH);
1851: END IF;
1852: /*-----------------------------------------------+

Line 1849: arp_util.debug('Validate_Payschd: ' || 'Payment Schedule = ' ||

1845: WHEN OTHERS THEN
1846:
1847: IF PG_DEBUG in ('Y', 'C') THEN
1848: arp_util.debug('EXCEPTION: Validate_Payschd() ', G_MSG_UERROR);
1849: arp_util.debug('Validate_Payschd: ' || 'Payment Schedule = ' ||
1850: p_adj_rec.payment_schedule_id, G_MSG_HIGH);
1851: END IF;
1852: /*-----------------------------------------------+
1853: | Set unexpected error message and status |

Line 1875: | arp_util.disable_debug |

1871: | |
1872: | SCOPE - PUBLIC |
1873: | |
1874: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1875: | arp_util.disable_debug |
1876: | arp_util.enable_debug |
1877: | fnd_api.g_exc_unexpected_error |
1878: | fnd_api.g_ret_sts_error |
1879: | fnd_api.g_ret_sts_error |

Line 1876: | arp_util.enable_debug |

1872: | SCOPE - PUBLIC |
1873: | |
1874: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1875: | arp_util.disable_debug |
1876: | arp_util.enable_debug |
1877: | fnd_api.g_exc_unexpected_error |
1878: | fnd_api.g_ret_sts_error |
1879: | fnd_api.g_ret_sts_error |
1880: | fnd_api.g_ret_sts_success |

Line 1939: arp_util.debug('Validate_amount()+', G_MSG_MEDIUM);

1935:
1936: BEGIN
1937:
1938: IF PG_DEBUG in ('Y', 'C') THEN
1939: arp_util.debug('Validate_amount()+', G_MSG_MEDIUM);
1940: END IF;
1941:
1942: /*------------------------------------------+
1943: | Initialize the return status to SUCCESS |

Line 2105: arp_util.debug('Validate_Amount()-', G_MSG_MEDIUM);

2101:
2102: END IF;
2103:
2104: IF PG_DEBUG in ('Y', 'C') THEN
2105: arp_util.debug('Validate_Amount()-', G_MSG_MEDIUM);
2106: END IF;
2107:
2108: RETURN ;
2109:

Line 2114: arp_util.debug('EXCEPTION: Validate_Amount() ', G_MSG_UERROR);

2110: EXCEPTION
2111: WHEN OTHERS THEN
2112:
2113: IF PG_DEBUG in ('Y', 'C') THEN
2114: arp_util.debug('EXCEPTION: Validate_Amount() ', G_MSG_UERROR);
2115: END IF;
2116:
2117: /*-----------------------------------------------+
2118: | Set unexpected error message and status |

Line 2139: | arp_util.disable_debug |

2135: | |
2136: | SCOPE - PUBLIC |
2137: | |
2138: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
2139: | arp_util.disable_debug |
2140: | arp_util.enable_debug |
2141: | fnd_api.g_exc_unexpected_error |
2142: | fnd_api.g_ret_sts_error |
2143: | fnd_api.g_ret_sts_error |

Line 2140: | arp_util.enable_debug |

2136: | SCOPE - PUBLIC |
2137: | |
2138: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
2139: | arp_util.disable_debug |
2140: | arp_util.enable_debug |
2141: | fnd_api.g_exc_unexpected_error |
2142: | fnd_api.g_ret_sts_error |
2143: | fnd_api.g_ret_sts_error |
2144: | fnd_api.g_ret_sts_success |

Line 2197: arp_util.debug('Validate_Rcvtrxccid()+', G_MSG_MEDIUM);

2193:
2194: BEGIN
2195:
2196: IF PG_DEBUG in ('Y', 'C') THEN
2197: arp_util.debug('Validate_Rcvtrxccid()+', G_MSG_MEDIUM);
2198: arp_util.debug('p_from_llca_call : ' || p_from_llca_call);
2199: END IF;
2200:
2201: /*------------------------------------------+

Line 2198: arp_util.debug('p_from_llca_call : ' || p_from_llca_call);

2194: BEGIN
2195:
2196: IF PG_DEBUG in ('Y', 'C') THEN
2197: arp_util.debug('Validate_Rcvtrxccid()+', G_MSG_MEDIUM);
2198: arp_util.debug('p_from_llca_call : ' || p_from_llca_call);
2199: END IF;
2200:
2201: /*------------------------------------------+
2202: | Initialize the return status to SUCCESS |

Line 2242: arp_util.debug('Validate_Rcvtrxccid: ' || 'For Payment schedule class BR,Receivable trx id

2238: IF (p_ps_rec.class = 'BR' and ((l_receivable_trx_type <> 'ENDORSEMENT')AND
2239: (p_adj_rec.receivables_trx_id <> -15 )))
2240: THEN
2241: IF PG_DEBUG in ('Y', 'C') THEN
2242: arp_util.debug('Validate_Rcvtrxccid: ' || 'For Payment schedule class BR,Receivable trx id
2243: should be of type ENDORSEMENT or -15',G_MSG_HIGH);
2244: END IF;
2245:
2246: IF p_from_llca_call <> 'Y' THEN

Line 2329: arp_util.debug('Validate_Rcvtrxccid: ' || 'for adj without accounting information - do not check the ccid');

2325: +---------------------------------------------------------------------------*/
2326: IF (l_accounting_affect_flag = 'N')
2327: THEN
2328: IF PG_DEBUG in ('Y', 'C') THEN
2329: arp_util.debug('Validate_Rcvtrxccid: ' || 'for adj without accounting information - do not check the ccid');
2330: END IF;
2331: p_adj_rec.code_combination_id := NULL;
2332: return;
2333: END IF;

Line 2507: arp_util.debug('Validate_Rcvtrxccid()-', G_MSG_MEDIUM);

2503: +-----------------------------------------------*/
2504:
2505: p_adj_rec.set_of_books_id := arp_global.set_of_books_id ;
2506: IF PG_DEBUG in ('Y', 'C') THEN
2507: arp_util.debug('Validate_Rcvtrxccid()-', G_MSG_MEDIUM);
2508: END IF;
2509: RETURN ;
2510:
2511: EXCEPTION

Line 2515: arp_util.debug('EXCEPTION: Validate_Rcvtrxccid', G_MSG_UERROR);

2511: EXCEPTION
2512: WHEN OTHERS THEN
2513:
2514: IF PG_DEBUG in ('Y', 'C') THEN
2515: arp_util.debug('EXCEPTION: Validate_Rcvtrxccid', G_MSG_UERROR);
2516: END IF;
2517: /*-----------------------------------------------+
2518: | Set unexpected error message and status |
2519: +-----------------------------------------------*/

Line 2568: arp_util.debug('Validate_dates()+', G_MSG_MEDIUM);

2564:
2565: BEGIN
2566:
2567: IF PG_DEBUG in ('Y', 'C') THEN
2568: arp_util.debug('Validate_dates()+', G_MSG_MEDIUM);
2569: END IF;
2570:
2571: /*------------------------------------------+
2572: | Initialize the return status to SUCCESS |

Line 2697: arp_util.debug('Validate_dates()-', G_MSG_MEDIUM);

2693: p_return_status := FND_API.G_RET_STS_ERROR;
2694: END IF;
2695:
2696: IF PG_DEBUG in ('Y', 'C') THEN
2697: arp_util.debug('Validate_dates()-', G_MSG_MEDIUM);
2698: END IF;
2699:
2700: RETURN ;
2701:

Line 2706: arp_util.debug('EXCEPTION: Validate_dates ', G_MSG_UERROR);

2702: EXCEPTION
2703: WHEN OTHERS THEN
2704:
2705: IF PG_DEBUG in ('Y', 'C') THEN
2706: arp_util.debug('EXCEPTION: Validate_dates ', G_MSG_UERROR);
2707: END IF;
2708: /*-----------------------------------------------+
2709: | Set unexpected error message and status |
2710: +-----------------------------------------------*/

Line 2731: | arp_util.disable_debug |

2727: | |
2728: | SCOPE - PRIVATE |
2729: | |
2730: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
2731: | arp_util.disable_debug |
2732: | arp_util.enable_debug |
2733: | fnd_api.g_exc_unexpected_error |
2734: | fnd_api.g_ret_sts_error |
2735: | fnd_api.g_ret_sts_error |

Line 2732: | arp_util.enable_debug |

2728: | SCOPE - PRIVATE |
2729: | |
2730: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
2731: | arp_util.disable_debug |
2732: | arp_util.enable_debug |
2733: | fnd_api.g_exc_unexpected_error |
2734: | fnd_api.g_ret_sts_error |
2735: | fnd_api.g_ret_sts_error |
2736: | fnd_api.g_ret_sts_success |

Line 2777: arp_util.debug('Validate_doc_seq()+', G_MSG_MEDIUM);

2773:
2774: BEGIN
2775:
2776: IF PG_DEBUG in ('Y', 'C') THEN
2777: arp_util.debug('Validate_doc_seq()+', G_MSG_MEDIUM);
2778: END IF;
2779:
2780: /*------------------------------------------+
2781: | Initialize the return status to SUCCESS |

Line 2791: arp_util.debug('Validate_doc_seq():'|| g_context_rec.unique_seq_numbers );

2787: | Document sequences are only applicable if the |
2788: | unique seq number option is not equal to N |
2789: +------------------------------------------------*/
2790: IF PG_DEBUG in ('Y', 'C') THEN
2791: arp_util.debug('Validate_doc_seq():'|| g_context_rec.unique_seq_numbers );
2792: END IF;
2793:
2794: IF ( NVL(g_context_rec.unique_seq_numbers, 'N') = 'N' )
2795: THEN

Line 2829: arp_util.debug('Validate_doc_seq():'|| p_adj_rec.doc_sequence_id );

2825: l_prod_table_name,
2826: l_audit_table_name,
2827: l_mesg_flag,'y','y');
2828: IF PG_DEBUG in ('Y', 'C') THEN
2829: arp_util.debug('Validate_doc_seq():'|| p_adj_rec.doc_sequence_id );
2830: END IF;
2831: EXCEPTION
2832: WHEN OTHERS THEN
2833: arp_util.debug('Validate_doc_seq() : Exception raised by get_seq_info');

Line 2833: arp_util.debug('Validate_doc_seq() : Exception raised by get_seq_info');

2829: arp_util.debug('Validate_doc_seq():'|| p_adj_rec.doc_sequence_id );
2830: END IF;
2831: EXCEPTION
2832: WHEN OTHERS THEN
2833: arp_util.debug('Validate_doc_seq() : Exception raised by get_seq_info');
2834: p_return_status := FND_API.G_RET_STS_ERROR;
2835: END;
2836:
2837:

Line 2880: arp_util.debug('Validate_doc_seq():'|| p_adj_rec.doc_sequence_value );

2876: p_adj_rec.doc_sequence_value ,
2877: p_adj_rec.doc_sequence_id
2878: );
2879: IF PG_DEBUG in ('Y', 'C') THEN
2880: arp_util.debug('Validate_doc_seq():'|| p_adj_rec.doc_sequence_value );
2881: END IF;
2882: EXCEPTION
2883: WHEN OTHERS THEN
2884: arp_util.debug('Validate_doc_seq() : Exception raised by get_seq_val');

Line 2884: arp_util.debug('Validate_doc_seq() : Exception raised by get_seq_val');

2880: arp_util.debug('Validate_doc_seq():'|| p_adj_rec.doc_sequence_value );
2881: END IF;
2882: EXCEPTION
2883: WHEN OTHERS THEN
2884: arp_util.debug('Validate_doc_seq() : Exception raised by get_seq_val');
2885: p_return_status := FND_API.G_RET_STS_ERROR;
2886: END;
2887:
2888: END IF;

Line 2891: arp_util.debug('Validate_doc_seq() : No active document sequence assignments',

2887:
2888: END IF;
2889: ELSE
2890: IF PG_DEBUG in ('Y', 'C') THEN
2891: arp_util.debug('Validate_doc_seq() : No active document sequence assignments',
2892: G_MSG_MEDIUM);
2893: END IF;
2894: p_adj_rec.doc_sequence_value := NULL;
2895: IF (g_context_rec.unique_seq_numbers = 'A'

Line 2912: arp_util.debug('Validate_doc_seq()-', G_MSG_MEDIUM);

2908: END IF; ---Handled all combinations of Seq Numbering...
2909:
2910:
2911: IF PG_DEBUG in ('Y', 'C') THEN
2912: arp_util.debug('Validate_doc_seq()-', G_MSG_MEDIUM);
2913: END IF;
2914:
2915: RETURN ;
2916: EXCEPTION

Line 2939: arp_util.debug('EXCEPTION: Validate_doc_seq ', G_MSG_UERROR);

2935: RETURN;
2936: WHEN OTHERS THEN
2937:
2938: IF PG_DEBUG in ('Y', 'C') THEN
2939: arp_util.debug('EXCEPTION: Validate_doc_seq ', G_MSG_UERROR);
2940: END IF;
2941: /*-----------------------------------------------+
2942: | Set unexpected error message and status |
2943: +-----------------------------------------------*/

Line 2962: | arp_util.disable_debug |

2958: | |
2959: | SCOPE - PUBLIC |
2960: | |
2961: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
2962: | arp_util.disable_debug |
2963: | arp_util.enable_debug |
2964: | fnd_api.g_exc_unexpected_error |
2965: | fnd_api.g_ret_sts_error |
2966: | fnd_api.g_ret_sts_error |

Line 2963: | arp_util.enable_debug |

2959: | SCOPE - PUBLIC |
2960: | |
2961: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
2962: | arp_util.disable_debug |
2963: | arp_util.enable_debug |
2964: | fnd_api.g_exc_unexpected_error |
2965: | fnd_api.g_ret_sts_error |
2966: | fnd_api.g_ret_sts_error |
2967: | fnd_api.g_ret_sts_success |

Line 2998: arp_util.debug('Validate_Reason_code()+', G_MSG_MEDIUM);

2994: l_found BOOLEAN;
2995: BEGIN
2996:
2997: IF PG_DEBUG in ('Y', 'C') THEN
2998: arp_util.debug('Validate_Reason_code()+', G_MSG_MEDIUM);
2999: END IF;
3000:
3001: /*------------------------------------------+
3002: | Initialize the return status to SUCCESS |

Line 3042: arp_util.debug('Validate_Reason_Code()-', G_MSG_MEDIUM);

3038:
3039: END IF ;
3040:
3041: IF PG_DEBUG in ('Y', 'C') THEN
3042: arp_util.debug('Validate_Reason_Code()-', G_MSG_MEDIUM);
3043: END IF;
3044:
3045: RETURN ;
3046:

Line 3051: arp_util.debug('EXCEPTION: Validate_Reason_code ', G_MSG_UERROR);

3047: EXCEPTION
3048: WHEN OTHERS THEN
3049:
3050: IF PG_DEBUG in ('Y', 'C') THEN
3051: arp_util.debug('EXCEPTION: Validate_Reason_code ', G_MSG_UERROR);
3052: END IF;
3053: /*-----------------------------------------------+
3054: | Set unexpected error message and status |
3055: +-----------------------------------------------*/

Line 3089: | to call arp_util.Validate_Desc_Flexfield

3085: | |
3086: | MODIFICATION HISTORY |
3087: | Vivek Halder 01-JUL-97 Created |
3088: | Satheesh Nambiar 16-Jun-00 Bug 1290698. Modified Validate_Desc_Flexfield
3089: | to call arp_util.Validate_Desc_Flexfield
3090: | |
3091: +===========================================================================*/
3092:
3093: PROCEDURE Validate_Desc_Flexfield(

Line 3101: p_desc_flex_rec arp_util.attribute_rec_type;

3097:
3098: l_flex_name fnd_descriptive_flexs.descriptive_flexfield_name%type;
3099: l_count NUMBER;
3100: l_col_name VARCHAR2(50);
3101: p_desc_flex_rec arp_util.attribute_rec_type;
3102:
3103: BEGIN
3104:
3105: IF PG_DEBUG in ('Y', 'C') THEN

Line 3106: arp_util.debug('Validate_Desc_Flexfield()+', G_MSG_MEDIUM);

3102:
3103: BEGIN
3104:
3105: IF PG_DEBUG in ('Y', 'C') THEN
3106: arp_util.debug('Validate_Desc_Flexfield()+', G_MSG_MEDIUM);
3107: END IF;
3108:
3109: /*------------------------------------------+
3110: | Initialize the return status to SUCCESS |

Line 3133: arp_util.debug('EXCEPTION: Validate_Desc_Flexfield', G_MSG_UERROR);

3129: RETURN;
3130:
3131: WHEN OTHERS THEN
3132: IF PG_DEBUG in ('Y', 'C') THEN
3133: arp_util.debug('EXCEPTION: Validate_Desc_Flexfield', G_MSG_UERROR);
3134: END IF;
3135: /*-----------------------------------------------+
3136: | Set unexpected error message and status |
3137: +-----------------------------------------------*/

Line 3162: arp_util.Validate_Desc_Flexfield(p_desc_flex_rec ,

3158: p_desc_flex_rec.attribute13 := p_adj_rec.attribute13;
3159: p_desc_flex_rec.attribute14 := p_adj_rec.attribute14;
3160: p_desc_flex_rec.attribute15 := p_adj_rec.attribute15;
3161:
3162: arp_util.Validate_Desc_Flexfield(p_desc_flex_rec ,
3163: l_flex_name,
3164: p_return_status);
3165:
3166: IF ( p_return_status <>FND_API.G_RET_STS_SUCCESS)

Line 3169: arp_util.debug('arp_util.Validate_Desc_Flexfield - Failed', G_MSG_UERROR);

3165:
3166: IF ( p_return_status <>FND_API.G_RET_STS_SUCCESS)
3167: THEN
3168: IF PG_DEBUG in ('Y', 'C') THEN
3169: arp_util.debug('arp_util.Validate_Desc_Flexfield - Failed', G_MSG_UERROR);
3170: END IF;
3171: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_DESC_FLEX');
3172: FND_MSG_PUB.ADD ;
3173: p_return_status := FND_API.G_RET_STS_ERROR;

Line 3194: arp_util.debug('Validate_Desc_Flexfield()-', G_MSG_MEDIUM);

3190: p_adj_rec.attribute14 := p_desc_flex_rec.attribute14;
3191: p_adj_rec.attribute15 := p_desc_flex_rec.attribute15;
3192:
3193: IF PG_DEBUG in ('Y', 'C') THEN
3194: arp_util.debug('Validate_Desc_Flexfield()-', G_MSG_MEDIUM);
3195: END IF;
3196:
3197: EXCEPTION
3198: WHEN OTHERS THEN

Line 3200: arp_util.debug('EXCEPTION: Validate_Desc_Flexfield', G_MSG_UERROR);

3196:
3197: EXCEPTION
3198: WHEN OTHERS THEN
3199: IF PG_DEBUG in ('Y', 'C') THEN
3200: arp_util.debug('EXCEPTION: Validate_Desc_Flexfield', G_MSG_UERROR);
3201: END IF;
3202: /*-----------------------------------------------+
3203: | Set unexpected error message and status |
3204: +-----------------------------------------------*/

Line 3223: | arp_util.disable_debug |

3219: | |
3220: | SCOPE - PRIVATE |
3221: | |
3222: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
3223: | arp_util.disable_debug |
3224: | arp_util.enable_debug |
3225: | fnd_api.g_exc_unexpected_error |
3226: | fnd_api.g_ret_sts_error |
3227: | fnd_api.g_ret_sts_error |

Line 3224: | arp_util.enable_debug |

3220: | SCOPE - PRIVATE |
3221: | |
3222: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
3223: | arp_util.disable_debug |
3224: | arp_util.enable_debug |
3225: | fnd_api.g_exc_unexpected_error |
3226: | fnd_api.g_ret_sts_error |
3227: | fnd_api.g_ret_sts_error |
3228: | fnd_api.g_ret_sts_success |

Line 3255: arp_util.debug('Validate_Created_From()+', G_MSG_MEDIUM);

3251:
3252: BEGIN
3253:
3254: IF PG_DEBUG in ('Y', 'C') THEN
3255: arp_util.debug('Validate_Created_From()+', G_MSG_MEDIUM);
3256: END IF;
3257:
3258: /*------------------------------------------+
3259: | Initialize the return status to SUCCESS |

Line 3277: arp_util.debug('Validate_Created_From ()-', G_MSG_MEDIUM);

3273: END IF;
3274:
3275:
3276: IF PG_DEBUG in ('Y', 'C') THEN
3277: arp_util.debug('Validate_Created_From ()-', G_MSG_MEDIUM);
3278: END IF;
3279:
3280: RETURN ;
3281:

Line 3286: arp_util.debug('EXCEPTION: Validate_Created_From()', G_MSG_UERROR);

3282: EXCEPTION
3283: WHEN OTHERS THEN
3284:
3285: IF PG_DEBUG in ('Y', 'C') THEN
3286: arp_util.debug('EXCEPTION: Validate_Created_From()', G_MSG_UERROR);
3287: END IF;
3288: /*-----------------------------------------------+
3289: | Set unexpected error message and status |
3290: +-----------------------------------------------*/

Line 3310: | arp_util.disable_debug |

3306: | |
3307: | SCOPE - PRIVATE |
3308: | |
3309: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
3310: | arp_util.disable_debug |
3311: | arp_util.enable_debug |
3312: | fnd_api.g_exc_unexpected_error |
3313: | fnd_api.g_ret_sts_error |
3314: | fnd_api.g_ret_sts_error |

Line 3311: | arp_util.enable_debug |

3307: | SCOPE - PRIVATE |
3308: | |
3309: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
3310: | arp_util.disable_debug |
3311: | arp_util.enable_debug |
3312: | fnd_api.g_exc_unexpected_error |
3313: | fnd_api.g_ret_sts_error |
3314: | fnd_api.g_ret_sts_error |
3315: | fnd_api.g_ret_sts_success |

Line 3344: arp_util.debug('Validate_Ussgl_code()+', G_MSG_MEDIUM);

3340:
3341: BEGIN
3342:
3343: IF PG_DEBUG in ('Y', 'C') THEN
3344: arp_util.debug('Validate_Ussgl_code()+', G_MSG_MEDIUM);
3345: END IF;
3346:
3347: /*------------------------------------------+
3348: | Initialize the return status to ERROR |

Line 3404: arp_util.debug('Validate_Ussgl_Code()-', G_MSG_MEDIUM);

3400: END IF ;
3401: END IF ;
3402:
3403: IF PG_DEBUG in ('Y', 'C') THEN
3404: arp_util.debug('Validate_Ussgl_Code()-', G_MSG_MEDIUM);
3405: END IF;
3406:
3407: RETURN ;
3408:

Line 3413: arp_util.debug('EXCEPTION: Validate_Ussgl_code ', G_MSG_UERROR);

3409: EXCEPTION
3410: WHEN OTHERS THEN
3411:
3412: IF PG_DEBUG in ('Y', 'C') THEN
3413: arp_util.debug('EXCEPTION: Validate_Ussgl_code ', G_MSG_UERROR);
3414: END IF;
3415: /*-----------------------------------------------+
3416: | Set unexpected error message and status |
3417: +-----------------------------------------------*/

Line 3436: | arp_util.disable_debug |

3432: | |
3433: | SCOPE - PUBLIC |
3434: | |
3435: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
3436: | arp_util.disable_debug |
3437: | arp_util.enable_debug |
3438: | fnd_api.g_exc_unexpected_error |
3439: | fnd_api.g_ret_sts_error |
3440: | fnd_api.g_ret_sts_error |

Line 3437: | arp_util.enable_debug |

3433: | SCOPE - PUBLIC |
3434: | |
3435: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
3436: | arp_util.disable_debug |
3437: | arp_util.enable_debug |
3438: | fnd_api.g_exc_unexpected_error |
3439: | fnd_api.g_ret_sts_error |
3440: | fnd_api.g_ret_sts_error |
3441: | fnd_api.g_ret_sts_success |

Line 3472: arp_util.debug('Validate_Associated_Receipt()+', G_MSG_MEDIUM);

3468:
3469: BEGIN
3470:
3471: IF PG_DEBUG in ('Y', 'C') THEN
3472: arp_util.debug('Validate_Associated_Receipt()+', G_MSG_MEDIUM);
3473: END IF;
3474:
3475: /*------------------------------------------+
3476: | Initialize the return status to SUCCESS |

Line 3510: arp_util.debug('Validate_Associated_Receipt()-', G_MSG_MEDIUM);

3506:
3507: END IF ;
3508:
3509: IF PG_DEBUG in ('Y', 'C') THEN
3510: arp_util.debug('Validate_Associated_Receipt()-', G_MSG_MEDIUM);
3511: END IF;
3512:
3513: RETURN ;
3514:

Line 3519: arp_util.debug('EXCEPTION: Validate_Associated_Receipt', G_MSG_UERROR);

3515: EXCEPTION
3516: WHEN OTHERS THEN
3517:
3518: IF PG_DEBUG in ('Y', 'C') THEN
3519: arp_util.debug('EXCEPTION: Validate_Associated_Receipt', G_MSG_UERROR);
3520: arp_util.debug('EXCEPTION: Validate_Associated_Receipt for Receipt Id '
3521: || p_adj_rec.associated_cash_receipt_id, G_MSG_HIGH );
3522: END IF;
3523: /*-----------------------------------------------+

Line 3520: arp_util.debug('EXCEPTION: Validate_Associated_Receipt for Receipt Id '

3516: WHEN OTHERS THEN
3517:
3518: IF PG_DEBUG in ('Y', 'C') THEN
3519: arp_util.debug('EXCEPTION: Validate_Associated_Receipt', G_MSG_UERROR);
3520: arp_util.debug('EXCEPTION: Validate_Associated_Receipt for Receipt Id '
3521: || p_adj_rec.associated_cash_receipt_id, G_MSG_HIGH );
3522: END IF;
3523: /*-----------------------------------------------+
3524: | Set unexpected error message and status |

Line 3544: | arp_util.disable_debug |

3540: | |
3541: | SCOPE - PUBLIC |
3542: | |
3543: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
3544: | arp_util.disable_debug |
3545: | fnd_api.g_exc_unexpected_error |
3546: | fnd_api.g_ret_sts_error |
3547: | fnd_api.g_ret_sts_error |
3548: | fnd_api.g_ret_sts_success |

Line 3585: arp_util.debug('Validate_Over_Application()+', G_MSG_MEDIUM);

3581: l_message_name varchar2(50);
3582: BEGIN
3583:
3584: IF PG_DEBUG in ('Y', 'C') THEN
3585: arp_util.debug('Validate_Over_Application()+', G_MSG_MEDIUM);
3586: END IF;
3587:
3588: p_return_status := FND_API.G_RET_STS_SUCCESS;
3589:

Line 3709: arp_util.debug('EXCEPTION: Validate_Over_Application', G_MSG_UERROR);

3705:
3706: EXCEPTION
3707: WHEN OTHERS THEN
3708: IF PG_DEBUG in ('Y', 'C') THEN
3709: arp_util.debug('EXCEPTION: Validate_Over_Application', G_MSG_UERROR);
3710: arp_util.debug('EXCEPTION: Validate_Over_Application '
3711: || p_adj_rec.customer_trx_id, G_MSG_HIGH );
3712: END IF;
3713: /*-----------------------------------------------+

Line 3710: arp_util.debug('EXCEPTION: Validate_Over_Application '

3706: EXCEPTION
3707: WHEN OTHERS THEN
3708: IF PG_DEBUG in ('Y', 'C') THEN
3709: arp_util.debug('EXCEPTION: Validate_Over_Application', G_MSG_UERROR);
3710: arp_util.debug('EXCEPTION: Validate_Over_Application '
3711: || p_adj_rec.customer_trx_id, G_MSG_HIGH );
3712: END IF;
3713: /*-----------------------------------------------+
3714: | Set unexpected error message and status |

Line 3734: | arp_util.disable_debug |

3730: | |
3731: | SCOPE - PUBLIC |
3732: | |
3733: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
3734: | arp_util.disable_debug |
3735: | fnd_api.g_exc_unexpected_error |
3736: | fnd_api.g_ret_sts_error |
3737: | fnd_api.g_ret_sts_error |
3738: | fnd_api.g_ret_sts_success |

Line 3783: arp_util.debug('Validate_Over_Application_llca()+', G_MSG_MEDIUM);

3779:
3780: BEGIN
3781:
3782: IF PG_DEBUG in ('Y', 'C') THEN
3783: arp_util.debug('Validate_Over_Application_llca()+', G_MSG_MEDIUM);
3784: END IF;
3785:
3786: p_return_status := FND_API.G_RET_STS_SUCCESS;
3787:

Line 3925: arp_util.debug('EXCEPTION: Validate_Over_Application_llca', G_MSG_UERROR);

3921:
3922: EXCEPTION
3923: WHEN OTHERS THEN
3924: IF PG_DEBUG in ('Y', 'C') THEN
3925: arp_util.debug('EXCEPTION: Validate_Over_Application_llca', G_MSG_UERROR);
3926: arp_util.debug('EXCEPTION: Validate_Over_Application_llca '
3927: || p_adj_rec.customer_trx_id, G_MSG_HIGH );
3928: END IF;
3929: /*-----------------------------------------------+

Line 3926: arp_util.debug('EXCEPTION: Validate_Over_Application_llca '

3922: EXCEPTION
3923: WHEN OTHERS THEN
3924: IF PG_DEBUG in ('Y', 'C') THEN
3925: arp_util.debug('EXCEPTION: Validate_Over_Application_llca', G_MSG_UERROR);
3926: arp_util.debug('EXCEPTION: Validate_Over_Application_llca '
3927: || p_adj_rec.customer_trx_id, G_MSG_HIGH );
3928: END IF;
3929: /*-----------------------------------------------+
3930: | Set unexpected error message and status |

Line 3938: arp_util.debug('initialization section of ar_adjvalidate_pvt');

3934: RETURN;
3935: END Validate_Over_Application_llca;
3936:
3937: BEGIN
3938: arp_util.debug('initialization section of ar_adjvalidate_pvt');
3939: G_cache_org_id := -99999;
3940:
3941: END AR_ADJVALIDATE_PVT;