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_CREATION_LIB_PVT dependencies on AR_BILLS_CREATION_LIB_PVT

Line 1: PACKAGE BODY AR_BILLS_CREATION_LIB_PVT AS

1: PACKAGE BODY AR_BILLS_CREATION_LIB_PVT AS
2: /* $Header: ARBRCRLB.pls 120.6 2005/11/11 12:33:42 sgnagara ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AR_BILLS_CREATION_LIB_PVT';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AR_BILLS_CREATION_LIB_PVT';

1: PACKAGE BODY AR_BILLS_CREATION_LIB_PVT AS
2: /* $Header: ARBRCRLB.pls 120.6 2005/11/11 12:33:42 sgnagara ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AR_BILLS_CREATION_LIB_PVT';
5:
6:
7: API_EXCEPTION EXCEPTION;
8:

Line 31: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Default_gl_date ()+');

27: l_default_gl_date DATE;
28:
29: BEGIN
30: IF PG_DEBUG in ('Y', 'C') THEN
31: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Default_gl_date ()+');
32: END IF;
33:
34: p_return_status := FND_API.G_RET_STS_SUCCESS;
35:

Line 67: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Default_gl_date ()-');

63:
64: END IF;
65:
66: IF PG_DEBUG in ('Y', 'C') THEN
67: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Default_gl_date ()-');
68: END IF;
69:
70: EXCEPTION
71: WHEN OTHERS THEN

Line 73: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_LIB_PVT.default_gl_date () ');

69:
70: EXCEPTION
71: WHEN OTHERS THEN
72: IF PG_DEBUG in ('Y', 'C') THEN
73: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_LIB_PVT.default_gl_date () ');
74: arp_util.debug('Default_GL_date: ' || ' p_entered_date = ' || p_entered_date);
75: END IF;
76: RAISE;
77:

Line 99: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Default_Drawee_Location ()+');

95: l_drawee_site_use_id NUMBER;
96:
97: BEGIN
98: IF PG_DEBUG in ('Y', 'C') THEN
99: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Default_Drawee_Location ()+');
100: END IF;
101:
102: /* modified for tca uptake */
103: SELECT site_uses.SITE_USE_ID

Line 114: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Default_Drawee_Location ()-');

110: AND site_uses.status = 'A'
111: AND site_uses.primary_flag = 'Y';
112:
113: IF PG_DEBUG in ('Y', 'C') THEN
114: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Default_Drawee_Location ()-');
115: END IF;
116:
117: EXCEPTION
118: WHEN NO_DATA_FOUND THEN

Line 160: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Default_Drawee_Contact ()+');

156:
157:
158: BEGIN
159: IF PG_DEBUG in ('Y', 'C') THEN
160: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Default_Drawee_Contact ()+');
161: END IF;
162:
163: /* modified for tca uptake */
164: /* fix bug 1883538: replace current role state with status column */

Line 179: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Default_Drawee_Contact ()-');

175: AND role_res.responsibility_type = 'BILL_TO'
176: AND role_res.primary_flag = 'Y';
177:
178: IF PG_DEBUG in ('Y', 'C') THEN
179: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Default_Drawee_Contact ()-');
180: END IF;
181:
182: EXCEPTION
183: WHEN NO_DATA_FOUND THEN

Line 199: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_LIB_PVT.Default_Drawee_Contact () ');

195: END IF;
196:
197: WHEN OTHERS THEN
198: IF PG_DEBUG in ('Y', 'C') THEN
199: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_LIB_PVT.Default_Drawee_Contact () ');
200: arp_util.debug('Default_Drawee_Contact: ' || ' p_drawee_id = ' || p_drawee_id );
201: arp_util.debug('Default_Drawee_Contact: ' || ' p_drawee_site_use_id = ' || p_drawee_site_use_id);
202: END IF;
203: RAISE;

Line 224: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Default_Printing_Option ()+');

220:
221:
222: BEGIN
223: IF PG_DEBUG in ('Y', 'C') THEN
224: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Default_Printing_Option ()+');
225: END IF;
226:
227: SELECT default_printing_option
228: INTO p_printing_option

Line 233: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Default_Printing_Option ()-');

229: FROM RA_CUST_TRX_TYPES
230: WHERE cust_trx_type_id = p_cust_trx_type_id;
231:
232: IF PG_DEBUG in ('Y', 'C') THEN
233: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Default_Printing_Option ()-');
234: END IF;
235:
236: EXCEPTION
237: WHEN NO_DATA_FOUND THEN

Line 239: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_LIB_PVT.Default_Printing_Option () () ');

235:
236: EXCEPTION
237: WHEN NO_DATA_FOUND THEN
238: IF PG_DEBUG in ('Y', 'C') THEN
239: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_LIB_PVT.Default_Printing_Option () () ');
240: arp_util.debug('Default_Printing_Option: ' || '>>>>>>>>>> Invalid Transaction Type');
241: arp_util.debug('Default_Printing_Option: ' || ' p_cust_trx_type_id = ' || p_cust_trx_type_id);
242: END IF;
243: FND_MESSAGE.SET_NAME ('AR', 'AR_BR_INVALID_TRX_TYPE');

Line 248: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_LIB_PVT.Default_Printing_Option () ');

244: app_exception.raise_exception;
245:
246: WHEN OTHERS THEN
247: IF PG_DEBUG in ('Y', 'C') THEN
248: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_LIB_PVT.Default_Printing_Option () ');
249: arp_util.debug('Default_Printing_Option: ' || ' p_cust_trx_type_id = ' || p_cust_trx_type_id);
250: END IF;
251: RAISE;
252:

Line 274: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Default_Drawee_Account ()+');

270:
271: BEGIN
272: /* PAYMENT_UPTAKE */
273: IF PG_DEBUG in ('Y', 'C') THEN
274: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Default_Drawee_Account ()+');
275: arp_util.debug('Default_Drawee_Account: ' || '>>>>> No Drawee Account could be defaulted');
276: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Default_Drawee_Account ()-');
277: END IF;
278:

Line 276: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Default_Drawee_Account ()-');

272: /* PAYMENT_UPTAKE */
273: IF PG_DEBUG in ('Y', 'C') THEN
274: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Default_Drawee_Account ()+');
275: arp_util.debug('Default_Drawee_Account: ' || '>>>>> No Drawee Account could be defaulted');
276: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Default_Drawee_Account ()-');
277: END IF;
278:
279: END Default_Drawee_Account;
280:

Line 302: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Get_Payment_Schedule_Id()+ ');

298:
299: BEGIN
300:
301: IF PG_DEBUG in ('Y', 'C') THEN
302: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Get_Payment_Schedule_Id()+ ');
303: END IF;
304:
305: SELECT payment_schedule_id
306: INTO p_payment_schedule_id

Line 312: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Get_Payment_Schedule_Id()- ');

308: WHERE customer_trx_id = p_customer_trx_id;
309:
310: IF PG_DEBUG in ('Y', 'C') THEN
311: arp_util.debug('Get_Payment_Schedule_ID: ' || 'Payment Schedule Id : ' || p_payment_schedule_id);
312: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Get_Payment_Schedule_Id()- ');
313: END IF;
314:
315: EXCEPTION
316: WHEN NO_DATA_FOUND THEN

Line 324: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_LIB_PVT.Get_Payment_Schedule_Id () ');

320: END IF;
321:
322: WHEN OTHERS THEN
323: IF PG_DEBUG in ('Y', 'C') THEN
324: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_LIB_PVT.Get_Payment_Schedule_Id () ');
325: arp_util.debug('Get_Payment_Schedule_ID: ' || ' p_customer_trx_id = ' || p_customer_trx_id);
326: END IF;
327: RAISE;
328:

Line 349: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Check_Header_Mandatory_Data ()+ ');

345: IS
346: BEGIN
347:
348: IF PG_DEBUG in ('Y', 'C') THEN
349: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Check_Header_Mandatory_Data ()+ ');
350: END IF;
351:
352: IF (p_trx_rec.batch_source_id IS NULL) THEN
353: IF PG_DEBUG in ('Y', 'C') THEN

Line 396: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Check_Header_Mandatory_Data ()- ');

392: app_exception.raise_exception;
393: END IF;
394:
395: IF PG_DEBUG in ('Y', 'C') THEN
396: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Check_Header_Mandatory_Data ()- ');
397: END IF;
398:
399: EXCEPTION
400: WHEN OTHERS THEN

Line 402: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_LIB_PVT.Check_Header_Mandatory_Data () ');

398:
399: EXCEPTION
400: WHEN OTHERS THEN
401: IF PG_DEBUG in ('Y', 'C') THEN
402: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_LIB_PVT.Check_Header_Mandatory_Data () ');
403: END IF;
404: RAISE;
405:
406: END Check_Header_Mandatory_Data;

Line 448: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Validate_Desc_Flexfield ()+');

444:
445: BEGIN
446:
447: IF PG_DEBUG in ('Y', 'C') THEN
448: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Validate_Desc_Flexfield ()+');
449: END IF;
450:
451: p_desc_flex_rec.attribute_category := p_attribute_category ;
452: p_desc_flex_rec.attribute1 := p_attribute1 ;

Line 500: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Validate_Desc_Flexfield()-');

496: p_attribute14 := p_desc_flex_rec.attribute14 ;
497: p_attribute15 := p_desc_flex_rec.attribute15 ;
498:
499: IF PG_DEBUG in ('Y', 'C') THEN
500: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Validate_Desc_Flexfield()-');
501: END IF;
502:
503: EXCEPTION
504: WHEN OTHERS THEN

Line 506: arp_util.debug('EXCEPTION: AR_BILLS_CREATION_LIB_PVT.Validate_Desc_Flexfield');

502:
503: EXCEPTION
504: WHEN OTHERS THEN
505: IF PG_DEBUG in ('Y', 'C') THEN
506: arp_util.debug('EXCEPTION: AR_BILLS_CREATION_LIB_PVT.Validate_Desc_Flexfield');
507: END IF;
508: RAISE;
509:
510: END Validate_Desc_Flexfield;

Line 535: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Default_Create_BR_Header()+ ');

531:
532: BEGIN
533:
534: IF PG_DEBUG in ('Y', 'C') THEN
535: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Default_Create_BR_Header()+ ');
536: END IF;
537:
538:
539: Check_Header_Mandatory_Data (p_trx_rec);

Line 701: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Default_Create_BR_Header ()-');

697: END IF;
698:
699:
700: IF PG_DEBUG in ('Y', 'C') THEN
701: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Default_Create_BR_Header ()-');
702: END IF;
703:
704: EXCEPTION
705: WHEN OTHERS THEN

Line 707: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_LIB_PVT.Default_Create_BR_Header () ');

703:
704: EXCEPTION
705: WHEN OTHERS THEN
706: IF PG_DEBUG in ('Y', 'C') THEN
707: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_LIB_PVT.Default_Create_BR_Header () ');
708: END IF;
709: RAISE;
710:
711:

Line 732: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Default_Update_BR_Header()+ ');

728:
729: BEGIN
730:
731: IF PG_DEBUG in ('Y', 'C') THEN
732: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Default_Update_BR_Header()+ ');
733: END IF;
734:
735: /*----------------------------------------------+
736: | Default the Batch Source ID |

Line 746: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Default_Update_BR_Header()- ');

742: WHERE customer_trx_id = p_trx_rec.customer_trx_id;
743:
744:
745: IF PG_DEBUG in ('Y', 'C') THEN
746: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Default_Update_BR_Header()- ');
747: END IF;
748:
749: EXCEPTION
750: WHEN NO_DATA_FOUND THEN

Line 757: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_LIB_PVT.Default_Update_BR_Header () ');

753: END IF;
754:
755: WHEN OTHERS THEN
756: IF PG_DEBUG in ('Y', 'C') THEN
757: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_LIB_PVT.Default_Update_BR_Header () ');
758: END IF;
759: RAISE;
760:
761: END Default_Update_BR_Header;

Line 787: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Default_Create_BR_Assignment()+ ');

783: l_count NUMBER;
784:
785: BEGIN
786: IF PG_DEBUG in ('Y', 'C') THEN
787: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Default_Create_BR_Assignment()+ ');
788: END IF;
789:
790: /*----------------------------------------------+
791: | Check that the transaction is not already |

Line 834: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Default_Create_BR_Assignment()-');

830: p_trl_rec.br_ref_customer_trx_id := p_ps_rec.customer_trx_id;
831:
832:
833: IF PG_DEBUG in ('Y', 'C') THEN
834: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Default_Create_BR_Assignment()-');
835: END IF;
836:
837: EXCEPTION
838: WHEN OTHERS THEN

Line 840: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_LIB_PVT.Default_Create_BR_Assignment () ');

836:
837: EXCEPTION
838: WHEN OTHERS THEN
839: IF PG_DEBUG in ('Y', 'C') THEN
840: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_LIB_PVT.Default_Create_BR_Assignment () ');
841: END IF;
842: RAISE;
843:
844: END Default_Create_BR_Assignment;

Line 873: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.DeAssign_BR()+ ');

869: l_msg_data VARCHAR2(2000);
870:
871: BEGIN
872: IF PG_DEBUG in ('Y', 'C') THEN
873: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.DeAssign_BR()+ ');
874: END IF;
875:
876: FOR assignment_rec IN assignment_cur LOOP
877:

Line 898: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.DeAssign_BR()- ');

894:
895: END LOOP;
896:
897: IF PG_DEBUG in ('Y', 'C') THEN
898: arp_util.debug('AR_BILLS_CREATION_LIB_PVT.DeAssign_BR()- ');
899: END IF;
900:
901: EXCEPTION
902: WHEN OTHERS THEN

Line 904: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_LIB_PVT.DeAssign_BR () ');

900:
901: EXCEPTION
902: WHEN OTHERS THEN
903: IF PG_DEBUG in ('Y', 'C') THEN
904: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_LIB_PVT.DeAssign_BR () ');
905: END IF;
906: IF (assignment_cur%ISOPEN)
907: THEN
908: CLOSE assignment_cur;

Line 915: END AR_BILLS_CREATION_LIB_PVT ;

911:
912: END DeAssign_BR;
913:
914:
915: END AR_BILLS_CREATION_LIB_PVT ;