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_BILLS_MAINTAIN_STATUS_PUB dependencies on AR_BILLS_MAINTAIN_STATUS_PUB

Line 1: PACKAGE BODY AR_BILLS_MAINTAIN_STATUS_PUB AS

1: PACKAGE BODY AR_BILLS_MAINTAIN_STATUS_PUB AS
2: /* $Header: ARBRSVEB.pls 115.12 2003/11/04 16:43:34 mraymond ship $ */
3:
4:
5: /* =======================================================================

Line 94: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Is_Payment_Schedule_Reduced()+');

90:
91: BEGIN
92:
93: IF PG_DEBUG in ('Y', 'C') THEN
94: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Is_Payment_Schedule_Reduced()+');
95: END IF;
96:
97: IF (p_ps_rec.amount_due_original = p_ps_rec.amount_due_remaining)
98: THEN

Line 110: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Is_Payment_Schedule_Reduced()-');

106: RETURN (TRUE);
107: END IF;
108:
109: IF PG_DEBUG in ('Y', 'C') THEN
110: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Is_Payment_Schedule_Reduced()-');
111: END IF;
112:
113: EXCEPTION
114: WHEN OTHERS THEN

Line 116: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_STATUS_PUB.Is_Payment_Schedule_Reduced () ');

112:
113: EXCEPTION
114: WHEN OTHERS THEN
115: IF PG_DEBUG in ('Y', 'C') THEN
116: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_STATUS_PUB.Is_Payment_Schedule_Reduced () ');
117: END IF;
118: RAISE;
119:
120: END Is_Payment_Schedule_Reduced;

Line 140: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Reserved()+');

136:
137: BEGIN
138:
139: IF PG_DEBUG in ('Y', 'C') THEN
140: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Reserved()+');
141: END IF;
142:
143:
144: IF (p_ps_rec.reserved_type IS NULL AND p_ps_rec.reserved_value IS NULL)

Line 159: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Reserved()-');

155: RETURN (TRUE);
156: END IF;
157:
158: IF PG_DEBUG in ('Y', 'C') THEN
159: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Reserved()-');
160: END IF;
161:
162: EXCEPTION
163: WHEN OTHERS THEN

Line 165: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Reserved () ');

161:
162: EXCEPTION
163: WHEN OTHERS THEN
164: IF PG_DEBUG in ('Y', 'C') THEN
165: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Reserved () ');
166: END IF;
167: RAISE;
168:
169: END Is_BR_Reserved;

Line 188: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Hold()+');

184:
185: BEGIN
186:
187: IF PG_DEBUG in ('Y', 'C') THEN
188: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Hold()+');
189: END IF;
190:
191: IF (p_ps_rec.reserved_type = 'USER')
192: THEN

Line 202: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Hold()-');

198: RETURN (FALSE);
199: END IF;
200:
201: IF PG_DEBUG in ('Y', 'C') THEN
202: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Hold()-');
203: END IF;
204:
205: EXCEPTION
206: WHEN OTHERS THEN

Line 208: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Hold () ');

204:
205: EXCEPTION
206: WHEN OTHERS THEN
207: IF PG_DEBUG in ('Y', 'C') THEN
208: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Hold () ');
209: END IF;
210: RAISE;
211:
212: END Is_BR_Hold;

Line 256: arp_util.debug ('AR_BILLS_MAINTAIN_STATUS_PUB.Find_Prev_posted_trh()+');

252:
253: BEGIN
254:
255: IF PG_DEBUG in ('Y', 'C') THEN
256: arp_util.debug ('AR_BILLS_MAINTAIN_STATUS_PUB.Find_Prev_posted_trh()+');
257: END IF;
258:
259: /*------------------------------------------------------+
260: | Fetch Previous posted transaction history record |

Line 276: arp_util.debug ('AR_BILLS_MAINTAIN_STATUS_PUB.Find_Prev_posted_trh()-');

272:
273: CLOSE Prev_trh_cur;
274:
275: IF PG_DEBUG in ('Y', 'C') THEN
276: arp_util.debug ('AR_BILLS_MAINTAIN_STATUS_PUB.Find_Prev_posted_trh()-');
277: END IF;
278:
279: EXCEPTION
280: WHEN OTHERS THEN

Line 282: arp_util.debug ('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_STATUS_PUB.Find_Prev_posted_trh ' || SQLERRM);

278:
279: EXCEPTION
280: WHEN OTHERS THEN
281: IF PG_DEBUG in ('Y', 'C') THEN
282: arp_util.debug ('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_STATUS_PUB.Find_Prev_posted_trh ' || SQLERRM);
283: END IF;
284: IF (Prev_trh_cur%ISOPEN)
285: THEN
286: CLOSE Prev_trh_cur;

Line 335: arp_util.debug ('AR_BILLS_MAINTAIN_STATUS_PUB.Find_Last_relevant_trh()+');

331:
332: BEGIN
333:
334: IF PG_DEBUG in ('Y', 'C') THEN
335: arp_util.debug ('AR_BILLS_MAINTAIN_STATUS_PUB.Find_Last_relevant_trh()+');
336: END IF;
337:
338: /*------------------------------------------------------+
339: | Fetch last relevant transaction history record |

Line 360: arp_util.debug ('AR_BILLS_MAINTAIN_STATUS_PUB.Find_Last_relevant_trh()-');

356:
357: CLOSE Prev_trh_cur;
358:
359: IF PG_DEBUG in ('Y', 'C') THEN
360: arp_util.debug ('AR_BILLS_MAINTAIN_STATUS_PUB.Find_Last_relevant_trh()-');
361: END IF;
362:
363: EXCEPTION
364: WHEN OTHERS THEN

Line 366: arp_util.debug ('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_STATUS_PUB.Find_Last_relevant_trh ()' || SQLERRM);

362:
363: EXCEPTION
364: WHEN OTHERS THEN
365: IF PG_DEBUG in ('Y', 'C') THEN
366: arp_util.debug ('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_STATUS_PUB.Find_Last_relevant_trh ()' || SQLERRM);
367: END IF;
368: IF (Prev_trh_cur%ISOPEN)
369: THEN
370: CLOSE Prev_trh_cur;

Line 395: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Remit_Selected()+');

391:
392: BEGIN
393:
394: IF PG_DEBUG in ('Y', 'C') THEN
395: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Remit_Selected()+');
396: END IF;
397:
398: /*----------------------------------------------+
399: | Find Current Relevant History Information |

Line 416: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Remit_Selected()-');

412: RETURN (FALSE);
413: END IF;
414:
415: IF PG_DEBUG in ('Y', 'C') THEN
416: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Remit_Selected()-');
417: END IF;
418:
419: EXCEPTION
420: WHEN OTHERS THEN

Line 422: arp_util.debug ('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Remit_Selected () ');

418:
419: EXCEPTION
420: WHEN OTHERS THEN
421: IF PG_DEBUG in ('Y', 'C') THEN
422: arp_util.debug ('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Remit_Selected () ');
423: arp_util.debug ('Is_BR_Remit_Selected: ' || ' p_trh_id : ' || p_trh_id);
424: END IF;
425: RAISE;
426:

Line 451: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Risk_Eliminated()+');

447: BEGIN
448:
449:
450: IF PG_DEBUG in ('Y', 'C') THEN
451: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Risk_Eliminated()+');
452: END IF;
453:
454: l_trh_rec.transaction_history_id := p_trh_id;
455: Find_Last_relevant_trh (l_trh_rec);

Line 478: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Risk_Eliminated()-');

474:
475: RETURN (FALSE);
476:
477: IF PG_DEBUG in ('Y', 'C') THEN
478: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Risk_Eliminated()-');
479: END IF;
480:
481: EXCEPTION
482: WHEN OTHERS THEN

Line 484: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Risk_Eliminated () ');

480:
481: EXCEPTION
482: WHEN OTHERS THEN
483: IF PG_DEBUG in ('Y', 'C') THEN
484: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Risk_Eliminated () ');
485: arp_util.debug('Is_BR_Risk_Eliminated: ' || 'p_trh_id : ' || p_trh_id);
486: END IF;
487: RAISE;
488:

Line 510: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Matured()+');

506:
507: BEGIN
508:
509: IF PG_DEBUG in ('Y', 'C') THEN
510: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Matured()+');
511: END IF;
512:
513:
514: IF trunc(p_maturity_date) <= trunc(SYSDATE)

Line 528: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Matured()-');

524: RETURN (FALSE);
525: END IF;
526:
527: IF PG_DEBUG in ('Y', 'C') THEN
528: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Matured()-');
529: END IF;
530:
531: EXCEPTION
532: WHEN OTHERS THEN

Line 534: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Matured () ');

530:
531: EXCEPTION
532: WHEN OTHERS THEN
533: IF PG_DEBUG in ('Y', 'C') THEN
534: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Matured () ');
535: arp_util.debug('Is_BR_Matured: ' || 'p_maturity_date : ' || p_maturity_date);
536: END IF;
537: RAISE;
538:

Line 561: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Is_Receipt_Cleared()+');

557:
558: BEGIN
559:
560: IF PG_DEBUG in ('Y', 'C') THEN
561: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Is_Receipt_Cleared()+');
562: END IF;
563:
564: SELECT max(cash_receipt_id)
565: INTO l_cr_id

Line 581: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Is_Receipt_Cleared()-');

577: END IF;
578:
579:
580: IF PG_DEBUG in ('Y', 'C') THEN
581: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Is_Receipt_Cleared()-');
582: END IF;
583:
584: EXCEPTION
585: WHEN NO_DATA_FOUND THEN

Line 587: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_STATUS_PUB.Is_Receipt_Cleared () ');

583:
584: EXCEPTION
585: WHEN NO_DATA_FOUND THEN
586: IF PG_DEBUG in ('Y', 'C') THEN
587: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_STATUS_PUB.Is_Receipt_Cleared () ');
588: arp_util.debug('Is_Receipt_Cleared: ' || 'No receipt application has been found for the BR');
589: arp_util.debug('Is_Receipt_Cleared: ' || 'p_customer_trx_id : ' || p_customer_trx_id);
590: END IF;
591: RAISE;

Line 595: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_STATUS_PUB.Is_Receipt_Cleared () ');

591: RAISE;
592:
593: WHEN OTHERS THEN
594: IF PG_DEBUG in ('Y', 'C') THEN
595: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_STATUS_PUB.Is_Receipt_Cleared () ');
596: arp_util.debug('Is_Receipt_Cleared: ' || 'p_customer_trx_id : ' || p_customer_trx_id);
597: END IF;
598: RAISE;
599:

Line 625: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Paid_In_One_Time()+');

621:
622: BEGIN
623:
624: IF PG_DEBUG in ('Y', 'C') THEN
625: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Paid_In_One_Time()+');
626: END IF;
627:
628: /*----------------------------------------------+
629: | Find Previous Relevant History Information |

Line 688: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Paid_In_One_Time()-');

684:
685: RETURN (FALSE);
686:
687: IF PG_DEBUG in ('Y', 'C') THEN
688: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Paid_In_One_Time()-');
689: END IF;
690:
691: EXCEPTION
692: WHEN NO_DATA_FOUND THEN

Line 694: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Paid_In_One_Time () ');

690:
691: EXCEPTION
692: WHEN NO_DATA_FOUND THEN
693: IF PG_DEBUG in ('Y', 'C') THEN
694: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Paid_In_One_Time () ');
695: arp_util.debug('Is_BR_Paid_In_One_Time: ' || 'No receipt application could be found for the BR');
696: END IF;
697: RETURN (FALSE);
698:

Line 701: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Paid_In_One_Time () ');

697: RETURN (FALSE);
698:
699: WHEN OTHERS THEN
700: IF PG_DEBUG in ('Y', 'C') THEN
701: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_STATUS_PUB.Is_BR_Paid_In_One_Time () ');
702: END IF;
703: RAISE;
704:
705: END Is_BR_Paid_In_One_Time;

Line 729: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Activities_Exist()+');

725:
726: BEGIN
727:
728: IF PG_DEBUG in ('Y', 'C') THEN
729: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Activities_Exist()+');
730: END IF;
731:
732: /*----------------------------------------------+
733: | Check if the BR has receipt applications |

Line 766: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Activities_Exist()-');

762: RETURN (FALSE);
763: END IF;
764:
765: IF PG_DEBUG in ('Y', 'C') THEN
766: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Activities_Exist()-');
767: END IF;
768:
769: EXCEPTION
770: WHEN Others THEN

Line 795: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Has_been_posted()+');

791: l_count NUMBER;
792:
793: BEGIN
794: IF PG_DEBUG in ('Y', 'C') THEN
795: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Has_been_posted()+');
796: END IF;
797:
798: /*----------------------------------------------+
799: | If posting_control_id is <> -3, the BR has |

Line 820: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Has_been_posted()-');

816: RETURN FALSE;
817: END IF;
818:
819: IF PG_DEBUG in ('Y', 'C') THEN
820: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Has_been_posted()-');
821: END IF;
822:
823: EXCEPTION
824: WHEN OTHERS THEN

Line 826: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_STATUS_PUB.Has_been_posted () ');

822:
823: EXCEPTION
824: WHEN OTHERS THEN
825: IF PG_DEBUG in ('Y', 'C') THEN
826: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_STATUS_PUB.Has_been_posted () ');
827: arp_util.debug('Has_been_posted: ' || 'p_customer_trx_id = ' || p_customer_trx_id);
828: END IF;
829: RAISE;
830:

Line 853: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Is_Acceptance_Required()+');

849:
850: BEGIN
851:
852: IF PG_DEBUG in ('Y', 'C') THEN
853: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Is_Acceptance_Required()+');
854: END IF;
855:
856: SELECT signed_flag , drawee_issued_flag
857: INTO l_signed_flag, l_drawee_issued_flag

Line 879: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Is_Acceptance_Required()-');

875: return(false);
876: END IF;
877:
878: IF PG_DEBUG in ('Y', 'C') THEN
879: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.Is_Acceptance_Required()-');
880: END IF;
881:
882: EXCEPTION
883: WHEN NO_DATA_FOUND THEN

Line 885: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_STATUS_PUB.Is_Acceptance_Required () ');

881:
882: EXCEPTION
883: WHEN NO_DATA_FOUND THEN
884: IF PG_DEBUG in ('Y', 'C') THEN
885: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_STATUS_PUB.Is_Acceptance_Required () ');
886: arp_util.debug('Is_Acceptance_Required: ' || '>>>>>>>>>> Invalid Transaction Type');
887: arp_util.debug('Is_Acceptance_Required: ' || ' p_cust_trx_type_id = ' || p_cust_trx_type_id);
888: END IF;
889: FND_MESSAGE.SET_NAME ('AR', 'AR_BR_INVALID_TRX_TYPE');

Line 895: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_STATUS_PUB.Is_Acceptance_Required () ');

891:
892:
893: WHEN OTHERS THEN
894: IF PG_DEBUG in ('Y', 'C') THEN
895: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_STATUS_PUB.Is_Acceptance_Required () ');
896: arp_util.debug('Is_Acceptance_Required: ' || 'p_cust_trx_type_id = ' || p_cust_trx_type_id);
897: END IF;
898: RAISE;
899:

Line 919: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.BR_Has_Assignment()+');

915: l_count NUMBER;
916:
917: BEGIN
918: IF PG_DEBUG in ('Y', 'C') THEN
919: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.BR_Has_Assignment()+');
920: END IF;
921:
922: SELECT count(*)
923: INTO l_count

Line 935: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.BR_Has_Assignment()-');

931: RETURN (FALSE);
932: END IF;
933:
934: IF PG_DEBUG in ('Y', 'C') THEN
935: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.BR_Has_Assignment()-');
936: END IF;
937:
938: EXCEPTION
939: WHEN OTHERS THEN

Line 941: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_STATUS_PUB.BR_Has_Assignment () ');

937:
938: EXCEPTION
939: WHEN OTHERS THEN
940: IF PG_DEBUG in ('Y', 'C') THEN
941: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_STATUS_PUB.BR_Has_Assignment () ');
942: arp_util.debug('BR_Has_Assignment: ' || 'p_customer_trx_id = ' || p_customer_trx_id);
943: END IF;
944: RAISE;
945:

Line 992: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.validate_actions()+');

988:
989: BEGIN
990:
991: IF PG_DEBUG in ('Y', 'C') THEN
992: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.validate_actions()+');
993: END IF;
994:
995: p_complete_flag := 'N';
996: p_uncomplete_flag := 'N';

Line 1248: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.validate_actions()-');

1244: END IF;
1245:
1246:
1247: IF PG_DEBUG in ('Y', 'C') THEN
1248: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.validate_actions()-');
1249: END IF;
1250:
1251: EXCEPTION
1252: WHEN OTHERS THEN

Line 1284: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.New_Status_Event()+');

1280:
1281: BEGIN
1282:
1283: IF PG_DEBUG in ('Y', 'C') THEN
1284: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.New_Status_Event()+');
1285: END IF;
1286:
1287: p_new_status := NULL;
1288: p_new_event := NULL;

Line 1563: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_STATUS_PUB.New_Status_Event () ');

1559: ELSE
1560:
1561: IF PG_DEBUG in ('Y', 'C') THEN
1562: arp_util.debug ('New_Status_Event: ' || '>>>>>>>>>> The action ' || p_action || ' is invalid ');
1563: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_STATUS_PUB.New_Status_Event () ');
1564: END IF;
1565: FND_MESSAGE.SET_NAME ('AR', 'AR_BR_ACTION_FORBIDDEN');
1566: FND_MESSAGE.SET_TOKEN('ACTION', p_action);
1567: FND_MESSAGE.SET_TOKEN('BRNUM', p_trx_rec.trx_number);

Line 1575: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.New_Status_Event()-');

1571:
1572: IF PG_DEBUG in ('Y', 'C') THEN
1573: arp_util.debug ('New_Status_Event: ' || 'New Status : ' || p_new_status);
1574: arp_util.debug ('New_Status_Event: ' || 'New Event : ' || p_new_event);
1575: arp_util.debug('AR_BILLS_MAINTAIN_STATUS_PUB.New_Status_Event()-');
1576: END IF;
1577:
1578: EXCEPTION
1579: WHEN OTHERS THEN

Line 1610: END AR_BILLS_MAINTAIN_STATUS_PUB ;

1606: END revision;
1607: --
1608:
1609:
1610: END AR_BILLS_MAINTAIN_STATUS_PUB ;