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.OE_PREPAYMENT_UTIL dependencies on OE_DEBUG_PUB

Line 21: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

17: l_prepayment_flag VARCHAR2(1);
18: l_payment_type_code varchar2(30);
19: l_payment_term_id NUMBER;
20: --
21: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
22: --
23: BEGIN
24: IF l_debug_level > 0 THEN
25: oe_debug_pub.add( 'ENTERING OE_PREPAYMENT_UTIL.IS_PREPAID' ) ;

Line 25: oe_debug_pub.add( 'ENTERING OE_PREPAYMENT_UTIL.IS_PREPAID' ) ;

21: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
22: --
23: BEGIN
24: IF l_debug_level > 0 THEN
25: oe_debug_pub.add( 'ENTERING OE_PREPAYMENT_UTIL.IS_PREPAID' ) ;
26: END IF;
27: IF OE_CODE_CONTROL.Get_Code_Release_Level < '110508' THEN
28: IF l_debug_level > 0 THEN
29: oe_debug_pub.add( 'OEXUPPY: BELOW PACKH , PREPAYMENTS NOT ENABLED' ) ;

Line 29: oe_debug_pub.add( 'OEXUPPY: BELOW PACKH , PREPAYMENTS NOT ENABLED' ) ;

25: oe_debug_pub.add( 'ENTERING OE_PREPAYMENT_UTIL.IS_PREPAID' ) ;
26: END IF;
27: IF OE_CODE_CONTROL.Get_Code_Release_Level < '110508' THEN
28: IF l_debug_level > 0 THEN
29: oe_debug_pub.add( 'OEXUPPY: BELOW PACKH , PREPAYMENTS NOT ENABLED' ) ;
30: END IF;
31: p_result := 0;
32: RETURN;
33: END IF;

Line 42: oe_debug_pub.add( 'L_HEADER_ID: '||L_HEADER_ID ||' :L_PAYMENT_TYPE_CODE='||L_PAYMENT_TYPE_CODE||':L_PAYMENT_TERM_ID='||L_PAYMENT_TERM_ID ) ;

38: l_header_id := oe_header_security.g_record.header_id;
39: l_payment_type_code := oe_header_security.g_record.payment_type_code;
40: l_payment_term_id := oe_header_security.g_record.payment_term_id;
41: IF l_debug_level > 0 THEN
42: oe_debug_pub.add( 'L_HEADER_ID: '||L_HEADER_ID ||' :L_PAYMENT_TYPE_CODE='||L_PAYMENT_TYPE_CODE||':L_PAYMENT_TERM_ID='||L_PAYMENT_TERM_ID ) ;
43: END IF;
44: ELSIF p_validation_entity_short_name = 'LINE' THEN
45: l_header_id := oe_line_security.g_record.header_id;
46: END IF;

Line 56: oe_debug_pub.add( 'P_VALIDATION_ENTITY_SHORT_NAME: '||P_VALIDATION_ENTITY_SHORT_NAME ) ;

52: p_result := 0;
53: END IF;
54:
55: IF l_debug_level > 0 THEN
56: oe_debug_pub.add( 'P_VALIDATION_ENTITY_SHORT_NAME: '||P_VALIDATION_ENTITY_SHORT_NAME ) ;
57: END IF;
58: IF p_validation_entity_short_name = 'HEADER' THEN
59: BEGIN
60: SELECT 1

Line 70: oe_debug_pub.add( 'L_PREPAID: '||L_PREPAID ) ;

66: WHEN NO_DATA_FOUND THEN
67: l_prepaid := 0;
68: END;
69: IF l_debug_level > 0 THEN
70: oe_debug_pub.add( 'L_PREPAID: '||L_PREPAID ) ;
71: END IF;
72:
73: IF l_prepaid = 1 THEN
74: p_result := 1;

Line 92: oe_debug_pub.add( 'L_PREPAID: '||L_PREPAID ) ;

88: l_prepaid := 0;
89: END;
90:
91: IF l_debug_level > 0 THEN
92: oe_debug_pub.add( 'L_PREPAID: '||L_PREPAID ) ;
93: END IF;
94:
95: IF l_prepaid = 1 THEN
96: p_result := 1;

Line 114: oe_debug_pub.add( 'P_VALIDATION_ENTITY_SHORT_NAME: '||P_VALIDATION_ENTITY_SHORT_NAME||':header_id:'||l_header_id ) ;

110: l_header_id := oe_line_security.g_record.header_id;
111: END IF;
112:
113: IF l_debug_level > 0 THEN
114: oe_debug_pub.add( 'P_VALIDATION_ENTITY_SHORT_NAME: '||P_VALIDATION_ENTITY_SHORT_NAME||':header_id:'||l_header_id ) ;
115: END IF;
116:
117: -- 3726282 Added the outer If loop alone
118: IF p_validation_entity_short_name in ('HEADER','LINE') THEN

Line 164: oe_debug_pub.add( 'EXITING OE_PREPAYMENT_UTIL.IS_PREPAID WITH RESULT: '||P_RESULT ) ;

160: -- 3726282 End
161: END IF;
162: --serla end
163: IF l_debug_level > 0 THEN
164: oe_debug_pub.add( 'EXITING OE_PREPAYMENT_UTIL.IS_PREPAID WITH RESULT: '||P_RESULT ) ;
165: END IF;
166: END Is_prepaid;
167:
168: PROCEDURE Get_PrePayment_Info

Line 179: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

175: l_payment_type_code VARCHAR2(30);
176: l_payment_term_id NUMBER;
177: l_prepayment_flag VARCHAR2(1);
178: --
179: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
180: --
181: BEGIN
182: IF l_debug_level > 0 THEN
183: oe_debug_pub.add( 'ENTERING OE_PAYMENT_UTIL.GET_PREPAYMENT_INFO' ) ;

Line 183: oe_debug_pub.add( 'ENTERING OE_PAYMENT_UTIL.GET_PREPAYMENT_INFO' ) ;

179: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
180: --
181: BEGIN
182: IF l_debug_level > 0 THEN
183: oe_debug_pub.add( 'ENTERING OE_PAYMENT_UTIL.GET_PREPAYMENT_INFO' ) ;
184: END IF;
185:
186: --serla begin
187: IF IS_MULTIPLE_PAYMENTS_ENABLED THEN

Line 199: oe_debug_pub.add( 'IN NODATA FOUND - OE_PAYMENT_UTIL.GET_PREPAYMENT_INFO' ) ;

195: AND payment_set_id IS NOT NULL;
196: EXCEPTION
197: WHEN NO_DATA_FOUND THEN
198: IF l_debug_level > 0 THEN
199: oe_debug_pub.add( 'IN NODATA FOUND - OE_PAYMENT_UTIL.GET_PREPAYMENT_INFO' ) ;
200: END IF;
201: x_payment_set_id := NULL;
202: x_prepaid_amount := NULL;
203: END;

Line 210: oe_debug_pub.add( 'NOT PREPAID TERMS , RETURNING NULL PAYMENT_SET_ID' ) ;

206: IF Is_Prepaid_Order(p_header_id) = 'N' THEN
207: x_payment_set_id := NULL;
208: x_prepaid_amount := NULL;
209: IF l_debug_level > 0 THEN
210: oe_debug_pub.add( 'NOT PREPAID TERMS , RETURNING NULL PAYMENT_SET_ID' ) ;
211: END IF;
212: ELSE
213: BEGIN
214: SELECT payment_set_id

Line 222: oe_debug_pub.add( 'PREPAID ORDER. X_PAYMENT_SET_ID: '||X_PAYMENT_SET_ID||' , X_PREPAID_AMOUNT: '||X_PREPAID_AMOUNT ) ;

218: FROM oe_payments
219: WHERE header_id = p_header_id
220: AND payment_type_code = 'CREDIT_CARD';
221: IF l_debug_level > 0 THEN
222: oe_debug_pub.add( 'PREPAID ORDER. X_PAYMENT_SET_ID: '||X_PAYMENT_SET_ID||' , X_PREPAID_AMOUNT: '||X_PREPAID_AMOUNT ) ;
223: END IF;
224: EXCEPTION
225: WHEN NO_DATA_FOUND THEN
226: IF l_debug_level > 0 THEN

Line 227: oe_debug_pub.add( 'IN NODATA FOUND - OE_PAYMENT_UTIL.GET_PREPAYMENT_INFO' ) ;

223: END IF;
224: EXCEPTION
225: WHEN NO_DATA_FOUND THEN
226: IF l_debug_level > 0 THEN
227: oe_debug_pub.add( 'IN NODATA FOUND - OE_PAYMENT_UTIL.GET_PREPAYMENT_INFO' ) ;
228: END IF;
229: x_payment_set_id := NULL;
230: x_prepaid_amount := NULL;
231: WHEN Too_many_rows THEN

Line 233: oe_debug_pub.add( 'IN TOO MANY ROWS - OE_PAYMENT_UTIL.GET_PREPAYMENT_INFO' ) ;

229: x_payment_set_id := NULL;
230: x_prepaid_amount := NULL;
231: WHEN Too_many_rows THEN
232: IF l_debug_level > 0 THEN
233: oe_debug_pub.add( 'IN TOO MANY ROWS - OE_PAYMENT_UTIL.GET_PREPAYMENT_INFO' ) ;
234: END IF;
235: x_payment_set_id := NULL;
236: x_prepaid_amount := NULL;
237: END;

Line 244: oe_debug_pub.add( 'EXITING OE_PAYMENT_UTIL.GET_PREPAYMENT_INFO - PAYMENT_SET_ID: '|| X_PAYMENT_SET_ID||' PREPAID_AMOUNT : '||X_PREPAID_AMOUNT ) ;

240: END IF;
241: --serla end
242:
243: IF l_debug_level > 0 THEN
244: oe_debug_pub.add( 'EXITING OE_PAYMENT_UTIL.GET_PREPAYMENT_INFO - PAYMENT_SET_ID: '|| X_PAYMENT_SET_ID||' PREPAID_AMOUNT : '||X_PREPAID_AMOUNT ) ;
245: END IF;
246:
247: EXCEPTION
248: WHEN OTHERS THEN

Line 535: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

531: AND b.language = oe_globals.g_lang
532: ORDER BY a.order_source_id, a.original_sys_document_ref, a.header_id;
533:
534: --
535: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
536: l_access_mode VARCHAR2(40); --R12 MOAC Changes
537: l_org_id NUMBER;
538: --
539: BEGIN

Line 542: oe_debug_pub.add( 'ENTERING OE_PAYMENTS_UTIL.PENDPROCESSPAYMENTS_CONC_PROG' ) ;

538: --
539: BEGIN
540:
541: IF l_debug_level > 0 THEN
542: oe_debug_pub.add( 'ENTERING OE_PAYMENTS_UTIL.PENDPROCESSPAYMENTS_CONC_PROG' ) ;
543: oe_debug_pub.add('Operating unit passed -->'||p_operating_unit);
544: END IF;
545: --R12 MOAC Changes
546: --MOAC set policy context for single Org

Line 543: oe_debug_pub.add('Operating unit passed -->'||p_operating_unit);

539: BEGIN
540:
541: IF l_debug_level > 0 THEN
542: oe_debug_pub.add( 'ENTERING OE_PAYMENTS_UTIL.PENDPROCESSPAYMENTS_CONC_PROG' ) ;
543: oe_debug_pub.add('Operating unit passed -->'||p_operating_unit);
544: END IF;
545: --R12 MOAC Changes
546: --MOAC set policy context for single Org
547: IF p_operating_unit IS NOT NULL THEN

Line 554: oe_debug_pub.add('Access Mode:'|| l_access_mode);

550:
551: IF l_debug_level >0 THEN
552: l_org_id := MO_GLOBAL.get_current_org_id;
553: l_access_mode := MO_GLOBAL.get_access_mode;
554: oe_debug_pub.add('Access Mode:'|| l_access_mode);
555: oe_debug_pub.add('Operating unit returned from mo_global-->'|| l_org_id);
556: END IF;
557: --R12 MOAC Changes
558:

Line 555: oe_debug_pub.add('Operating unit returned from mo_global-->'|| l_org_id);

551: IF l_debug_level >0 THEN
552: l_org_id := MO_GLOBAL.get_current_org_id;
553: l_access_mode := MO_GLOBAL.get_access_mode;
554: oe_debug_pub.add('Access Mode:'|| l_access_mode);
555: oe_debug_pub.add('Operating unit returned from mo_global-->'|| l_org_id);
556: END IF;
557: --R12 MOAC Changes
558:
559: IF OE_CODE_CONTROL.Get_Code_Release_Level < '110508' THEN

Line 561: oe_debug_pub.add( 'OEXUPPY: BELOW PACKH , PREPAYMENTS NOT ENABLED' ) ;

557: --R12 MOAC Changes
558:
559: IF OE_CODE_CONTROL.Get_Code_Release_Level < '110508' THEN
560: IF l_debug_level > 0 THEN
561: oe_debug_pub.add( 'OEXUPPY: BELOW PACKH , PREPAYMENTS NOT ENABLED' ) ;
562: END IF;
563: fnd_file.put_line(FND_FILE.OUTPUT, 'Pack H or above must be installed to use this concurrent program');
564: RETURN;
565: END IF;

Line 615: l_filename := OE_DEBUG_PUB.set_debug_mode ('FILE');

611: -- commenting out as debug mode will be set to 'CONC' automatically when
612: -- debug level is > 0 and the debug messages can be seen in the conc program log file
613: /*
614: IF nvl(p_debug_level, 1) > 0 THEN
615: l_filename := OE_DEBUG_PUB.set_debug_mode ('FILE');
616: FND_FILE.Put_Line(FND_FILE.OUTPUT,'Debug File: ' || l_filename);
617: FND_FILE.Put_Line(FND_FILE.OUTPUT, '');
618: END IF;
619:

Line 620: l_filename := OE_DEBUG_PUB.set_debug_mode ('CONC');

616: FND_FILE.Put_Line(FND_FILE.OUTPUT,'Debug File: ' || l_filename);
617: FND_FILE.Put_Line(FND_FILE.OUTPUT, '');
618: END IF;
619:
620: l_filename := OE_DEBUG_PUB.set_debug_mode ('CONC');
621: */
622: /* -----------------------------------------------------------
623: Get Concurrent Request Id
624: -----------------------------------------------------------

Line 627: oe_debug_pub.add( 'BEFORE GETTING REQUEST ID' ) ;

623: Get Concurrent Request Id
624: -----------------------------------------------------------
625: */
626: IF l_debug_level > 0 THEN
627: oe_debug_pub.add( 'BEFORE GETTING REQUEST ID' ) ;
628: END IF;
629:
630: FND_PROFILE.Get('CONC_REQUEST_ID', l_request_id);
631:

Line 633: oe_debug_pub.add( 'REQUEST ID: '|| TO_CHAR ( L_REQUEST_ID ) ) ;

629:
630: FND_PROFILE.Get('CONC_REQUEST_ID', l_request_id);
631:
632: IF l_debug_level > 0 THEN
633: oe_debug_pub.add( 'REQUEST ID: '|| TO_CHAR ( L_REQUEST_ID ) ) ;
634: END IF;
635: fnd_file.put_line(FND_FILE.OUTPUT, 'Request Id: '|| to_char(l_request_id));
636: -- fnd_file.put_line(FND_FILE.OUTPUT, 'l_hold1:l_hold2:l_hold3 : '|| l_hold1||':'||l_hold2||':'||l_hold3);
637:

Line 661: oe_debug_pub.add('Setting the context for org_id ' || l_org_id);

657: IF p_operating_unit is NULL THEN
658: IF l_org_id <> l_old_org_id THEN
659: MO_GLOBAL.set_policy_context('S',l_org_id);
660: IF l_debug_level > 0 THEN
661: oe_debug_pub.add('Setting the context for org_id ' || l_org_id);
662: END IF;
663: l_old_org_id := l_org_id;
664: END IF;
665: END IF;

Line 712: oe_debug_pub.add( 'CALLING PROCESS_PAYMENT FOR HEADER_ID: '||L_HEADER_ID ) ;

708: OR p_epay_server_failure_hold = 'Y' THEN
709: p_process_prepayment := 'Y';
710: END IF;
711: IF l_debug_level > 0 THEN
712: oe_debug_pub.add( 'CALLING PROCESS_PAYMENT FOR HEADER_ID: '||L_HEADER_ID ) ;
713: END IF;
714:
715: oe_prepayment_pvt.process_payments(p_header_id => l_header_id
716: ,p_calling_action => NULL

Line 726: oe_debug_pub.add( 'AFTER CALLING PROCESS_PAYMENT, L_RETURN_STATUS: '||L_RETURN_STATUS ) ;

722: ,x_msg_data => l_msg_data
723: ,x_return_status => l_return_status);
724:
725: IF l_debug_level > 0 THEN
726: oe_debug_pub.add( 'AFTER CALLING PROCESS_PAYMENT, L_RETURN_STATUS: '||L_RETURN_STATUS ) ;
727: END IF;
728: ELSE
729:
730: IF l_debug_level > 0 THEN

Line 731: oe_debug_pub.add( 'CALLING VERIFY_PAYMENT FOR HEADER_ID: '||L_HEADER_ID ) ;

727: END IF;
728: ELSE
729:
730: IF l_debug_level > 0 THEN
731: oe_debug_pub.add( 'CALLING VERIFY_PAYMENT FOR HEADER_ID: '||L_HEADER_ID ) ;
732: END IF;
733: OE_Verify_Payment_PUB.Verify_Payment(p_header_id => l_header_id
734: ,p_calling_action => NULL
735: ,p_delayed_request => NULL

Line 740: oe_debug_pub.add( 'AFTER CALLING VERIFY_PAYMENT , L_RETURN_STATUS: '||L_RETURN_STATUS ) ;

736: ,p_msg_count => l_msg_count
737: ,p_msg_data => l_msg_data
738: ,p_return_status => l_return_status);
739: IF l_debug_level > 0 THEN
740: oe_debug_pub.add( 'AFTER CALLING VERIFY_PAYMENT , L_RETURN_STATUS: '||L_RETURN_STATUS ) ;
741: END IF;
742: END IF;
743:
744: IF l_return_status = FND_API.G_RET_STS_ERROR OR

Line 762: oe_debug_pub.add( 'UNEXPECTED ERROR' ) ;

758: END IF;
759:
760: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
761: IF l_debug_level > 0 THEN
762: oe_debug_pub.add( 'UNEXPECTED ERROR' ) ;
763: END IF;
764: -- OE_MSG_PUB.Save_Messages(p_request_id => l_request_id);
765: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
766: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 768: oe_debug_pub.add( 'EXPECTED ERROR' ) ;

764: -- OE_MSG_PUB.Save_Messages(p_request_id => l_request_id);
765: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
766: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
767: IF l_debug_level > 0 THEN
768: oe_debug_pub.add( 'EXPECTED ERROR' ) ;
769: END IF;
770: -- OE_MSG_PUB.Save_Messages(p_request_id => l_request_id);
771: -- RAISE FND_API.G_EXC_ERROR;
772: END IF;

Line 781: oe_debug_pub.add( 'OEXUPPYB: releasing payment hold.' ) ;

777: IF l_return_status = FND_API.G_RET_STS_SUCCESS
778: AND IS_MULTIPLE_PAYMENTS_ENABLED THEN
779:
780: IF l_debug_level > 0 THEN
781: oe_debug_pub.add( 'OEXUPPYB: releasing payment hold.' ) ;
782: END IF;
783:
784: IF p_ppp_hold = 'Y' THEN
785: OE_Prepayment_PVT.Release_Payment_Hold

Line 854: oe_debug_pub.add( 'NO. OF ORDERS FOUND: ' || L_COUNT_HEADER ) ;

850: OE_MSG_PUB.Save_Messages(p_request_id => l_request_id);
851: END LOOP;
852:
853: IF l_debug_level > 0 THEN
854: oe_debug_pub.add( 'NO. OF ORDERS FOUND: ' || L_COUNT_HEADER ) ;
855: END IF;
856: IF l_debug_level > 0 THEN
857: oe_debug_pub.add( 'NO. OF ORDERS SUCCESSFUL: '|| L_COUNT_HEADER_SUCCESS ) ;
858: END IF;

Line 857: oe_debug_pub.add( 'NO. OF ORDERS SUCCESSFUL: '|| L_COUNT_HEADER_SUCCESS ) ;

853: IF l_debug_level > 0 THEN
854: oe_debug_pub.add( 'NO. OF ORDERS FOUND: ' || L_COUNT_HEADER ) ;
855: END IF;
856: IF l_debug_level > 0 THEN
857: oe_debug_pub.add( 'NO. OF ORDERS SUCCESSFUL: '|| L_COUNT_HEADER_SUCCESS ) ;
858: END IF;
859: IF l_debug_level > 0 THEN
860: oe_debug_pub.add( 'NO. OF ORDERS FAILED: ' || L_COUNT_HEADER_FAILURE ) ;
861: END IF;

Line 860: oe_debug_pub.add( 'NO. OF ORDERS FAILED: ' || L_COUNT_HEADER_FAILURE ) ;

856: IF l_debug_level > 0 THEN
857: oe_debug_pub.add( 'NO. OF ORDERS SUCCESSFUL: '|| L_COUNT_HEADER_SUCCESS ) ;
858: END IF;
859: IF l_debug_level > 0 THEN
860: oe_debug_pub.add( 'NO. OF ORDERS FAILED: ' || L_COUNT_HEADER_FAILURE ) ;
861: END IF;
862:
863: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders found: ' ||l_count_header);
864: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders processed successfully: '||l_count_header_success);

Line 873: oe_debug_pub.add( 'BEFORE MESSAGES LOOP' ) ;

869: Messages
870: -----------------------------------------------------------
871: */
872: IF l_debug_level > 0 THEN
873: oe_debug_pub.add( 'BEFORE MESSAGES LOOP' ) ;
874: END IF;
875:
876: fnd_file.put_line(FND_FILE.OUTPUT,'');
877: fnd_file.put_line(FND_FILE.OUTPUT,'Source/Order/Seq/Line Message');

Line 902: oe_debug_pub.add( 'EXITING OE_PAYMENTS_UTIL.PENDPROCESSPAYMENTS_CONC_PROG' ) ;

898: END LOOP;
899:
900: retcode := 0;
901: IF l_debug_level > 0 THEN
902: oe_debug_pub.add( 'EXITING OE_PAYMENTS_UTIL.PENDPROCESSPAYMENTS_CONC_PROG' ) ;
903: END IF;
904: --rollback;
905: EXCEPTION
906:

Line 910: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;

906:
907: WHEN FND_API.G_EXC_ERROR THEN
908: l_return_status := FND_API.G_RET_STS_ERROR ;
909: IF l_debug_level > 0 THEN
910: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
911: END IF;
912: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
913: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'PendProcessPayments_Conc_Prog');
914: END IF;

Line 931: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;

927: );
928:
929: WHEN OTHERS THEN
930: IF l_debug_level > 0 THEN
931: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
932: END IF;
933: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
934: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'PendProcessPayments_Conc_Prog');
935: END IF;

Line 955: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

951: l_payment_term_rec Payment_Term_Rec_Type;
952: l_count NUMBER;
953: l_header_id NUMBER ;
954: --
955: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
956: --
957: BEGIN
958:
959: IF l_debug_level > 0 THEN

Line 960: oe_debug_pub.add( 'OEXUPPYB: IN IS_PREPAID_ORDER' ) ;

956: --
957: BEGIN
958:
959: IF l_debug_level > 0 THEN
960: oe_debug_pub.add( 'OEXUPPYB: IN IS_PREPAID_ORDER' ) ;
961: END IF;
962:
963: -- OM code level is below Pack H.
964: IF OE_CODE_CONTROL.Get_Code_Release_Level < '110508' THEN

Line 966: oe_debug_pub.add( 'PREPAYMENT IS NOT SUPPORTED: OM PACK H IS NOT INSTALLED.' , 3 ) ;

962:
963: -- OM code level is below Pack H.
964: IF OE_CODE_CONTROL.Get_Code_Release_Level < '110508' THEN
965: IF l_debug_level > 0 THEN
966: oe_debug_pub.add( 'PREPAYMENT IS NOT SUPPORTED: OM PACK H IS NOT INSTALLED.' , 3 ) ;
967: END IF;
968: RETURN ('N');
969: END IF;
970: IF IS_MULTIPLE_PAYMENTS_ENABLED THEN

Line 981: oe_debug_pub.add( 'There are prepayments for the order-'||l_count , 3 ) ;

977: AND payment_type_code <> 'COMMITMENT'
978: AND nvl(payment_collection_event, 'PREPAY') = 'PREPAY';
979: IF l_count > 0 THEN
980: IF l_debug_level > 0 THEN
981: oe_debug_pub.add( 'There are prepayments for the order-'||l_count , 3 ) ;
982: END IF;
983: RETURN ('Y');
984: ELSE
985: IF l_debug_level > 0 THEN

Line 986: oe_debug_pub.add( 'No prepayments for the order' , 3 ) ;

982: END IF;
983: RETURN ('Y');
984: ELSE
985: IF l_debug_level > 0 THEN
986: oe_debug_pub.add( 'No prepayments for the order' , 3 ) ;
987: END IF;
988: RETURN ('N');
989: END IF;
990: EXCEPTION

Line 993: oe_debug_pub.add( 'In when others.. returning N' , 3);

989: END IF;
990: EXCEPTION
991: WHEN OTHERS THEN
992: IF l_debug_level > 0 THEN
993: oe_debug_pub.add( 'In when others.. returning N' , 3);
994: END IF;
995: RETURN ('N');
996: END;
997: ELSE

Line 1000: oe_debug_pub.add( 'PREPAYMENT IS NOT SUPPORTED: PAYMENT TYPE IS NOT CREDIT CARD.' , 3 ) ;

996: END;
997: ELSE
998: IF nvl(p_header_rec.payment_type_code, 'NULL') <> 'CREDIT_CARD' THEN
999: IF l_debug_level > 0 THEN
1000: oe_debug_pub.add( 'PREPAYMENT IS NOT SUPPORTED: PAYMENT TYPE IS NOT CREDIT CARD.' , 3 ) ;
1001: END IF;
1002: RETURN ('N');
1003:
1004: ELSIF p_header_rec.payment_type_code = 'CREDIT_CARD' THEN

Line 1007: oe_debug_pub.add( 'VALUE FOR IS_PREPAID_ORDER IS: ' ||G_PAYMENT_TERM_TBL ( P_HEADER_REC.PAYMENT_TERM_ID ) .IS_PREPAID_ORDER , 3 ) ;

1003:
1004: ELSIF p_header_rec.payment_type_code = 'CREDIT_CARD' THEN
1005: IF g_payment_term_tbl.exists(p_header_rec.payment_term_id) THEN
1006: IF l_debug_level > 0 THEN
1007: oe_debug_pub.add( 'VALUE FOR IS_PREPAID_ORDER IS: ' ||G_PAYMENT_TERM_TBL ( P_HEADER_REC.PAYMENT_TERM_ID ) .IS_PREPAID_ORDER , 3 ) ;
1008: END IF;
1009: RETURN g_payment_term_tbl(p_header_rec.payment_term_id).is_prepaid_order;
1010: ELSE
1011: l_prepayment_flag := AR_PUBLIC_UTILS.Check_Prepay_Payment_Term(

Line 1023: oe_debug_pub.add( 'OEXUPPYB: VALUE FOR IS_PREPAID_ORDER IS Y.' , 3 ) ;

1019: g_payment_term_tbl(p_header_rec.payment_term_id) := l_payment_term_rec;
1020:
1021:
1022: IF l_debug_level > 0 THEN
1023: oe_debug_pub.add( 'OEXUPPYB: VALUE FOR IS_PREPAID_ORDER IS Y.' , 3 ) ;
1024: END IF;
1025: RETURN ('Y') ;
1026: ELSE
1027: l_payment_term_rec.payment_term_id := p_header_rec.payment_term_id;

Line 1033: oe_debug_pub.add( 'OEXUPPYB: VALUE FOR IS_PREPAID_ORDER IS N.' , 3 ) ;

1029:
1030: g_payment_term_tbl(p_header_rec.payment_term_id) := l_payment_term_rec;
1031:
1032: IF l_debug_level > 0 THEN
1033: oe_debug_pub.add( 'OEXUPPYB: VALUE FOR IS_PREPAID_ORDER IS N.' , 3 ) ;
1034: END IF;
1035: RETURN ('N') ;
1036:
1037: END IF;

Line 1043: oe_debug_pub.add( 'OEXUPPYB: EXITING IS_PREPAID_ORDER.' , 3 ) ;

1039:
1040: END IF;
1041: END IF; -- multiple payments enabled
1042: IF l_debug_level > 0 THEN
1043: oe_debug_pub.add( 'OEXUPPYB: EXITING IS_PREPAID_ORDER.' , 3 ) ;
1044: END IF;
1045:
1046: END Is_Prepaid_Order;
1047:

Line 1059: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1055: l_payment_term_id NUMBER;
1056: l_payment_term_rec Payment_Term_Rec_Type;
1057: l_count NUMBER;
1058: --
1059: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1060: --
1061: BEGIN
1062:
1063: IF l_debug_level > 0 THEN

Line 1064: oe_debug_pub.add( 'OEXUPPYB: IN IS_PREPAID_ORDER' ) ;

1060: --
1061: BEGIN
1062:
1063: IF l_debug_level > 0 THEN
1064: oe_debug_pub.add( 'OEXUPPYB: IN IS_PREPAID_ORDER' ) ;
1065: END IF;
1066:
1067: -- OM code level is below Pack H.
1068: IF OE_CODE_CONTROL.Get_Code_Release_Level < '110508' THEN

Line 1070: oe_debug_pub.add( 'PREPAYMENT IS NOT SUPPORTED: OM PACK H IS NOT INSTALLED.' , 3 ) ;

1066:
1067: -- OM code level is below Pack H.
1068: IF OE_CODE_CONTROL.Get_Code_Release_Level < '110508' THEN
1069: IF l_debug_level > 0 THEN
1070: oe_debug_pub.add( 'PREPAYMENT IS NOT SUPPORTED: OM PACK H IS NOT INSTALLED.' , 3 ) ;
1071: END IF;
1072: RETURN ('N');
1073: END IF;
1074:

Line 1085: oe_debug_pub.add( 'There are prepayments for the order-'||l_count, 3 ) ;

1081: AND payment_type_code <> 'COMMITMENT'
1082: AND nvl(payment_collection_event, 'PREPAY') = 'PREPAY';
1083: IF l_count > 0 THEN
1084: IF l_debug_level > 0 THEN
1085: oe_debug_pub.add( 'There are prepayments for the order-'||l_count, 3 ) ;
1086: END IF;
1087: RETURN ('Y');
1088: ELSE
1089: IF l_debug_level > 0 THEN

Line 1090: oe_debug_pub.add( 'No prepayments for the order' , 3 ) ;

1086: END IF;
1087: RETURN ('Y');
1088: ELSE
1089: IF l_debug_level > 0 THEN
1090: oe_debug_pub.add( 'No prepayments for the order' , 3 ) ;
1091: END IF;
1092: RETURN ('N');
1093: END IF;
1094: EXCEPTION

Line 1097: oe_debug_pub.add( 'In when others.. returning N' , 3);

1093: END IF;
1094: EXCEPTION
1095: WHEN OTHERS THEN
1096: IF l_debug_level > 0 THEN
1097: oe_debug_pub.add( 'In when others.. returning N' , 3);
1098: END IF;
1099: RETURN ('N');
1100: END;
1101: ELSE

Line 1114: oe_debug_pub.add( 'PREPAYMENT IS NOT SUPPORTED: PAYMENT TYPE IS NOT CREDIT CARD.' , 3 ) ;

1110: END;
1111:
1112: IF nvl(l_payment_type_code, 'NULL') <> 'CREDIT_CARD' THEN
1113: IF l_debug_level > 0 THEN
1114: oe_debug_pub.add( 'PREPAYMENT IS NOT SUPPORTED: PAYMENT TYPE IS NOT CREDIT CARD.' , 3 ) ;
1115: END IF;
1116: RETURN ('N');
1117:
1118: ELSIF l_payment_type_code = 'CREDIT_CARD' THEN

Line 1122: oe_debug_pub.add( 'VALUE FOR IS_PREPAID_ORDER IS: ' ||G_PAYMENT_TERM_TBL ( L_PAYMENT_TERM_ID ) .IS_PREPAID_ORDER , 3 ) ;

1118: ELSIF l_payment_type_code = 'CREDIT_CARD' THEN
1119:
1120: IF g_payment_term_tbl.exists(l_payment_term_id) THEN
1121: IF l_debug_level > 0 THEN
1122: oe_debug_pub.add( 'VALUE FOR IS_PREPAID_ORDER IS: ' ||G_PAYMENT_TERM_TBL ( L_PAYMENT_TERM_ID ) .IS_PREPAID_ORDER , 3 ) ;
1123: END IF;
1124: RETURN g_payment_term_tbl(l_payment_term_id).is_prepaid_order;
1125: ELSE
1126: l_prepayment_flag := AR_PUBLIC_UTILS.Check_Prepay_Payment_Term(

Line 1138: oe_debug_pub.add( 'OEXUPPYB: EXITING IS_PREPAID_ORDER IS TRUE' ) ;

1134: g_payment_term_tbl(l_payment_term_id) := l_payment_term_rec;
1135:
1136:
1137: IF l_debug_level > 0 THEN
1138: oe_debug_pub.add( 'OEXUPPYB: EXITING IS_PREPAID_ORDER IS TRUE' ) ;
1139: END IF;
1140: IF l_debug_level > 0 THEN
1141: oe_debug_pub.add( 'OEXUPPYB: VALUE FOR IS_PREPAID_ORDER IS Y.' , 3 ) ;
1142: END IF;

Line 1141: oe_debug_pub.add( 'OEXUPPYB: VALUE FOR IS_PREPAID_ORDER IS Y.' , 3 ) ;

1137: IF l_debug_level > 0 THEN
1138: oe_debug_pub.add( 'OEXUPPYB: EXITING IS_PREPAID_ORDER IS TRUE' ) ;
1139: END IF;
1140: IF l_debug_level > 0 THEN
1141: oe_debug_pub.add( 'OEXUPPYB: VALUE FOR IS_PREPAID_ORDER IS Y.' , 3 ) ;
1142: END IF;
1143: RETURN ('Y') ;
1144: ELSE
1145: l_payment_term_rec.payment_term_id := l_payment_term_id;

Line 1152: oe_debug_pub.add( 'OEXUPPYB: EXITING IS_PREPAID_ORDER IS FALSE' ) ;

1148: g_payment_term_tbl(l_payment_term_id) := l_payment_term_rec;
1149:
1150:
1151: IF l_debug_level > 0 THEN
1152: oe_debug_pub.add( 'OEXUPPYB: EXITING IS_PREPAID_ORDER IS FALSE' ) ;
1153: END IF;
1154: IF l_debug_level > 0 THEN
1155: oe_debug_pub.add( 'OEXUPPYB: VALUE FOR IS_PREPAID_ORDER IS N.' , 3 ) ;
1156: END IF;

Line 1155: oe_debug_pub.add( 'OEXUPPYB: VALUE FOR IS_PREPAID_ORDER IS N.' , 3 ) ;

1151: IF l_debug_level > 0 THEN
1152: oe_debug_pub.add( 'OEXUPPYB: EXITING IS_PREPAID_ORDER IS FALSE' ) ;
1153: END IF;
1154: IF l_debug_level > 0 THEN
1155: oe_debug_pub.add( 'OEXUPPYB: VALUE FOR IS_PREPAID_ORDER IS N.' , 3 ) ;
1156: END IF;
1157: RETURN ('N') ;
1158:
1159: END IF;

Line 1165: oe_debug_pub.add( 'OEXUPPYB: EXITING IS_PREPAID_ORDER.' , 3 ) ;

1161:
1162: END IF;
1163: END IF; -- multiple payments enabled
1164: IF l_debug_level > 0 THEN
1165: oe_debug_pub.add( 'OEXUPPYB: EXITING IS_PREPAID_ORDER.' , 3 ) ;
1166: END IF;
1167:
1168: END Is_Prepaid_Order; -- end of overloaded function
1169:

Line 1176: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1172: l_code_release varchar2(30) := NULL;
1173: l_multiple_payments varchar2(1) := NULL;
1174:
1175: --
1176: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1177: --
1178: l_lookup_code varchar2(30) := NULL;
1179: BEGIN
1180:

Line 1182: oe_debug_pub.add( 'OEXUPPYB: IN IS_MULTIPLE_PAYMENTS_ENABLED' ) ;

1178: l_lookup_code varchar2(30) := NULL;
1179: BEGIN
1180:
1181: IF l_debug_level > 0 THEN
1182: oe_debug_pub.add( 'OEXUPPYB: IN IS_MULTIPLE_PAYMENTS_ENABLED' ) ;
1183: END IF;
1184:
1185: /***
1186: -- commented out the following code as this is not needed for R12.

Line 1191: oe_debug_pub.add( 'LESS THAN PACK J' , 3 ) ;

1187: l_code_release := OE_CODE_CONTROL.Get_Code_Release_Level;
1188:
1189: IF l_code_release < '110510' THEN
1190: IF l_debug_level > 0 THEN
1191: oe_debug_pub.add( 'LESS THAN PACK J' , 3 ) ;
1192: END IF;
1193: Return False;
1194: END IF;
1195:

Line 1230: oe_debug_pub.add( 'Multiple Payments is not enabled ' , 3 ) ;

1226: l_multiple_payments := nvl(OE_Sys_Parameters.Value('MULTIPLE_PAYMENTS'), 'N');
1227:
1228: IF l_multiple_payments = 'N' THEN
1229: IF l_debug_level > 0 THEN
1230: oe_debug_pub.add( 'Multiple Payments is not enabled ' , 3 ) ;
1231: END IF;
1232: Return False;
1233: END IF;
1234: ***/

Line 1256: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1252: IS
1253: l_payment_count NUMBER := 0;
1254: l_multipay_count NUMBER := 0;
1255: --
1256: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1257: --
1258:
1259: BEGIN
1260:

Line 1262: oe_debug_pub.add( 'Entering OE_Prepayment_Util.Is_Multipayments_Order. ' , 3 ) ;

1258:
1259: BEGIN
1260:
1261: IF l_debug_level > 0 THEN
1262: oe_debug_pub.add( 'Entering OE_Prepayment_Util.Is_Multipayments_Order. ' , 3 ) ;
1263: END IF;
1264:
1265: -- if exists any full prepaid orders.
1266: BEGIN

Line 1277: oe_debug_pub.add( 'l_payment_count is: '||l_payment_count , 3 ) ;

1273: l_payment_count := 0;
1274: END;
1275:
1276: IF l_debug_level > 0 THEN
1277: oe_debug_pub.add( 'l_payment_count is: '||l_payment_count , 3 ) ;
1278: END IF;
1279:
1280: IF l_payment_count = 1 THEN
1281:

Line 1295: oe_debug_pub.add( 'l_multipay_count is: '||l_multipay_count , 3 ) ;

1291: l_multipay_count := 0;
1292: END;
1293:
1294: IF l_debug_level > 0 THEN
1295: oe_debug_pub.add( 'l_multipay_count is: '||l_multipay_count , 3 ) ;
1296: END IF;
1297:
1298: IF l_multipay_count = 0 THEN
1299: return 'N';

Line 1311: oe_debug_pub.add( 'Entering OE_Prepayment_Util.Is_Multipayments_Order. ' , 3 ) ;

1307: return 'N';
1308: END IF;
1309:
1310: IF l_debug_level > 0 THEN
1311: oe_debug_pub.add( 'Entering OE_Prepayment_Util.Is_Multipayments_Order. ' , 3 ) ;
1312: END IF;
1313:
1314: END Is_MultiPayments_Order;
1315:

Line 1381: oe_debug_pub.add('term id : ' || l_term_id);

1377: /* get prepayment flag for this payment term - l_term_id */
1378:
1379: /* comment out for bug 3524195
1380: if l_term_id is not null then
1381: oe_debug_pub.add('term id : ' || l_term_id);
1382:
1383: l_prepayment_flag := AR_PUBLIC_UTILS.Check_Prepay_Payment_Term(l_term_id);
1384:
1385: oe_debug_pub.add('prepayment_flag is : ' || l_prepayment_flag );

Line 1385: oe_debug_pub.add('prepayment_flag is : ' || l_prepayment_flag );

1381: oe_debug_pub.add('term id : ' || l_term_id);
1382:
1383: l_prepayment_flag := AR_PUBLIC_UTILS.Check_Prepay_Payment_Term(l_term_id);
1384:
1385: oe_debug_pub.add('prepayment_flag is : ' || l_prepayment_flag );
1386: end if;
1387: */
1388:
1389: IF p_order_total is null THEN

Line 1402: oe_debug_pub.add('order total is : ' || l_order_total);

1398: );
1399:
1400: l_order_total := nvl(l_subtotal,0) + nvl(l_charges,0) + nvl(l_tax,0);
1401:
1402: oe_debug_pub.add('order total is : ' || l_order_total);
1403:
1404: ELSE
1405: l_order_total := p_order_total;
1406: END IF; -- if p_order_total is null

Line 1409: oe_debug_pub.add('currency code is : ' || l_curr_code);

1405: l_order_total := p_order_total;
1406: END IF; -- if p_order_total is null
1407:
1408:
1409: oe_debug_pub.add('currency code is : ' || l_curr_code);
1410:
1411: IF l_term_id is not null and
1412: l_order_total is not null and
1413: l_curr_code is not null

Line 1417: oe_debug_pub.add('before calling AR');

1413: l_curr_code is not null
1414: -- and nvl(l_prepayment_flag, 'N') = 'Y'
1415: THEN
1416:
1417: oe_debug_pub.add('before calling AR');
1418:
1419: AR_PREPAYMENTS_PUB.get_installment(
1420: p_term_id => l_term_id,
1421: p_amount => l_order_total,

Line 1428: oe_debug_pub.add('after calling AR');

1424: x_return_status => l_return_status,
1425: x_msg_count => l_msg_count,
1426: x_msg_data => l_msg_data );
1427:
1428: oe_debug_pub.add('after calling AR');
1429:
1430: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1431: NULL;
1432: oe_debug_pub.add('return status is failure ');

Line 1432: oe_debug_pub.add('return status is failure ');

1428: oe_debug_pub.add('after calling AR');
1429:
1430: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1431: NULL;
1432: oe_debug_pub.add('return status is failure ');
1433: l_downpayment := 0;
1434: --RAISE FORM_TRIGGER_FAILURE;
1435: ELSE
1436:

Line 1437: oe_debug_pub.add('installment api succeeded ');

1433: l_downpayment := 0;
1434: --RAISE FORM_TRIGGER_FAILURE;
1435: ELSE
1436:
1437: oe_debug_pub.add('installment api succeeded ');
1438:
1439: IF l_installment_tbl.count > 0 THEN
1440: i := l_installment_tbl.first;
1441: while i is not null loop

Line 1452: oe_debug_pub.add('downpayment is equal to order total ');

1448: i := l_installment_tbl.next(i);
1449:
1450: end loop; -- end of while loop
1451: ELSE
1452: oe_debug_pub.add('downpayment is equal to order total ');
1453: l_downpayment := l_order_total;
1454: END IF; -- if l_installment_tbl.count > 0
1455:
1456: END IF; -- end of l_return_status

Line 1468: oe_debug_pub.add('exception handling ');

1464:
1465: Exception
1466:
1467: When others then
1468: oe_debug_pub.add('exception handling ');
1469: l_downpayment := 0;
1470: return l_downpayment;
1471:
1472: END get_downpayment_amount;

Line 1482: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1478: p_record_set_tmplt_short_name in VARCHAR2,
1479: p_scope in VARCHAR2,
1480: p_result OUT NOCOPY NUMBER ) IS
1481: --
1482: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1483: --
1484: BEGIN
1485: IF l_debug_level > 0 THEN
1486: oe_debug_pub.add( 'ENTERING OE_PREPAYMENT_UTIL.IS_PREPAID_FOR_PAYMENT_TERM' ) ;

Line 1486: oe_debug_pub.add( 'ENTERING OE_PREPAYMENT_UTIL.IS_PREPAID_FOR_PAYMENT_TERM' ) ;

1482: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1483: --
1484: BEGIN
1485: IF l_debug_level > 0 THEN
1486: oe_debug_pub.add( 'ENTERING OE_PREPAYMENT_UTIL.IS_PREPAID_FOR_PAYMENT_TERM' ) ;
1487: END IF;
1488: IF OE_CODE_CONTROL.Get_Code_Release_Level < '110508' THEN
1489: IF l_debug_level > 0 THEN
1490: oe_debug_pub.add( 'OEXUPPY: BELOW PACKH , PREPAYMENTS NOT ENABLED' )

Line 1490: oe_debug_pub.add( 'OEXUPPY: BELOW PACKH , PREPAYMENTS NOT ENABLED' )

1486: oe_debug_pub.add( 'ENTERING OE_PREPAYMENT_UTIL.IS_PREPAID_FOR_PAYMENT_TERM' ) ;
1487: END IF;
1488: IF OE_CODE_CONTROL.Get_Code_Release_Level < '110508' THEN
1489: IF l_debug_level > 0 THEN
1490: oe_debug_pub.add( 'OEXUPPY: BELOW PACKH , PREPAYMENTS NOT ENABLED' )
1491: ;
1492: END IF;
1493: p_result := 0;
1494: RETURN;

Line 1499: oe_debug_pub.add( 'Multiple payment enabled. Should not fire the constraint hence setting result to 0', 5);

1495: END IF;
1496: --serla begin
1497: IF IS_MULTIPLE_PAYMENTS_ENABLED THEN
1498: IF l_debug_level > 0 THEN
1499: oe_debug_pub.add( 'Multiple payment enabled. Should not fire the constraint hence setting result to 0', 5);
1500: END IF;
1501: p_result := 0;
1502: ELSE
1503: IF l_debug_level > 0 THEN

Line 1504: oe_debug_pub.add( 'Calling Is_Prepaid', 5);

1500: END IF;
1501: p_result := 0;
1502: ELSE
1503: IF l_debug_level > 0 THEN
1504: oe_debug_pub.add( 'Calling Is_Prepaid', 5);
1505: END IF;
1506: Is_Prepaid(p_application_id => p_application_id,
1507: p_entity_short_name => p_entity_short_name,
1508: p_validation_entity_short_name => p_validation_entity_short_name,

Line 1514: oe_debug_pub.add( 'p_result after call to Is_Prepaid:'||p_result, 5);

1510: p_record_set_tmplt_short_name => p_record_set_tmplt_short_name,
1511: p_scope => p_scope,
1512: p_result => p_result );
1513: IF l_debug_level > 0 THEN
1514: oe_debug_pub.add( 'p_result after call to Is_Prepaid:'||p_result, 5);
1515: END IF;
1516: END IF;
1517: IF l_debug_level > 0 THEN
1518: oe_debug_pub.add( 'EXITING OE_PREPAYMENT_UTIL.IS_PREPAID_FOR_PAYMENT_TERM WITH RESULT: '||P_RESULT ) ;

Line 1518: oe_debug_pub.add( 'EXITING OE_PREPAYMENT_UTIL.IS_PREPAID_FOR_PAYMENT_TERM WITH RESULT: '||P_RESULT ) ;

1514: oe_debug_pub.add( 'p_result after call to Is_Prepaid:'||p_result, 5);
1515: END IF;
1516: END IF;
1517: IF l_debug_level > 0 THEN
1518: oe_debug_pub.add( 'EXITING OE_PREPAYMENT_UTIL.IS_PREPAID_FOR_PAYMENT_TERM WITH RESULT: '||P_RESULT ) ;
1519: END IF;
1520:
1521: END Is_Prepaid_for_payment_term;
1522:

Line 1550: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1546: l_pay_now_commitment NUMBER :=0;
1547: l_msg_count NUMBER;
1548: l_msg_data VARCHAR2(2000);
1549: l_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS;
1550: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1551:
1552: BEGIN
1553: BEGIN
1554: SELECT header_id

Line 1561: oe_debug_pub.add('No data found for line_id : '||p_line_id);

1557: WHERE line_id = p_line_id;
1558: EXCEPTION
1559: WHEN NO_DATA_FOUND THEN
1560: IF l_debug_level > 0 THEN
1561: oe_debug_pub.add('No data found for line_id : '||p_line_id);
1562: END IF;
1563: RETURN FALSE;
1564: END;
1565:

Line 1581: oe_debug_pub.add('OE_Prepayment_PVT.Get_Pay_Now_Amounts returned with errors');

1577: );
1578:
1579: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1580: IF l_debug_level > 0 THEN
1581: oe_debug_pub.add('OE_Prepayment_PVT.Get_Pay_Now_Amounts returned with errors');
1582: END IF;
1583: RETURN FALSE;
1584: END IF;
1585: