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_LINE_PAYMENT_UTIL dependencies on OE_DEBUG_PUB

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

20: FUNCTION G_MISS_OE_AK_LPAYMENT_REC
21: RETURN OE_AK_LINE_PAYMENTS_V%ROWTYPE IS
22: l_rowtype_rec OE_AK_LINE_PAYMENTS_V%ROWTYPE;
23: --
24: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
25: --
26: BEGIN
27:
28: l_rowtype_rec.ATTRIBUTE1 := FND_API.G_MISS_CHAR;

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

83: ( p_Line_Payment_rec IN OE_Order_PUB.LINE_PAYMENT_Rec_Type
84: , x_rowtype_rec IN OUT NOCOPY OE_AK_LINE_PAYMENTS_V%ROWTYPE
85: ) IS
86: --
87: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
88: --
89: BEGIN
90:
91: x_rowtype_rec.ATTRIBUTE1 := p_line_Payment_rec.ATTRIBUTE1;

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

145: ( p_record IN OE_AK_LINE_PAYMENTS_V%ROWTYPE
146: , x_api_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
147: ) IS
148: --
149: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
150: --
151: BEGIN
152:
153: x_api_rec.ATTRIBUTE1 := p_record.ATTRIBUTE1;

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

215: l_index NUMBER :=0;
216: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
217: l_dep_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
218: --
219: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
220: --
221: BEGIN
222:
223: -- Load out record

Line 738: --oe_debug_pub.add('Old exp date'||p_old_Line_Payment_rec.credit_card_expiration_date);

734: p_x_Line_PAYMENT_rec.CREDIT_CARD_CODE := FND_API.G_MISS_CHAR;
735: END IF;
736: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CREDIT_CARD_EXPIRATION_DATE THEN
737: --IF l_debug_level > 0 THEN
738: --oe_debug_pub.add('Old exp date'||p_old_Line_Payment_rec.credit_card_expiration_date);
739: --oe_debug_pub.add('New exp date'||p_x_Line_PAYMENT_rec.CREDIT_CARD_EXPIRATION_DATE);
740: --END IF;
741: IF (OE_GLOBALS.Equal(p_x_Line_PAYMENT_rec.CREDIT_CARD_EXPIRATION_DATE, p_old_Line_Payment_rec.CREDIT_CARD_EXPIRATION_DATE)
742: AND (p_old_Line_Payment_rec.header_id IS NOT NULL OR

Line 739: --oe_debug_pub.add('New exp date'||p_x_Line_PAYMENT_rec.CREDIT_CARD_EXPIRATION_DATE);

735: END IF;
736: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CREDIT_CARD_EXPIRATION_DATE THEN
737: --IF l_debug_level > 0 THEN
738: --oe_debug_pub.add('Old exp date'||p_old_Line_Payment_rec.credit_card_expiration_date);
739: --oe_debug_pub.add('New exp date'||p_x_Line_PAYMENT_rec.CREDIT_CARD_EXPIRATION_DATE);
740: --END IF;
741: IF (OE_GLOBALS.Equal(p_x_Line_PAYMENT_rec.CREDIT_CARD_EXPIRATION_DATE, p_old_Line_Payment_rec.CREDIT_CARD_EXPIRATION_DATE)
742: AND (p_old_Line_Payment_rec.header_id IS NOT NULL OR
743: p_x_Line_PAYMENT_rec.CREDIT_CARD_EXPIRATION_DATE IS NOT NULL)

Line 750: --oe_debug_pub.add('Old holder name'||p_old_Line_Payment_rec.CREDIT_CARD_HOLDER_NAME);

746: p_x_Line_PAYMENT_rec.CREDIT_CARD_EXPIRATION_DATE := FND_API.G_MISS_DATE;
747: END IF;
748: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CREDIT_CARD_HOLDER_NAME THEN
749: --IF l_debug_level > 0 THEN
750: --oe_debug_pub.add('Old holder name'||p_old_Line_Payment_rec.CREDIT_CARD_HOLDER_NAME);
751: --oe_debug_pub.add('New holder name'||p_x_Line_PAYMENT_rec.CREDIT_CARD_HOLDER_NAME);
752: --END IF;
753: IF (OE_GLOBALS.Equal(p_x_Line_PAYMENT_rec.CREDIT_CARD_HOLDER_NAME, p_old_Line_Payment_rec.CREDIT_CARD_HOLDER_NAME)
754: AND (p_old_Line_Payment_rec.header_id IS NOT NULL OR

Line 751: --oe_debug_pub.add('New holder name'||p_x_Line_PAYMENT_rec.CREDIT_CARD_HOLDER_NAME);

747: END IF;
748: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CREDIT_CARD_HOLDER_NAME THEN
749: --IF l_debug_level > 0 THEN
750: --oe_debug_pub.add('Old holder name'||p_old_Line_Payment_rec.CREDIT_CARD_HOLDER_NAME);
751: --oe_debug_pub.add('New holder name'||p_x_Line_PAYMENT_rec.CREDIT_CARD_HOLDER_NAME);
752: --END IF;
753: IF (OE_GLOBALS.Equal(p_x_Line_PAYMENT_rec.CREDIT_CARD_HOLDER_NAME, p_old_Line_Payment_rec.CREDIT_CARD_HOLDER_NAME)
754: AND (p_old_Line_Payment_rec.header_id IS NOT NULL OR
755: p_x_Line_PAYMENT_rec.CREDIT_CARD_HOLDER_NAME IS NOT NULL)

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

818: IS
819: l_Line_Payment_rec OE_AK_LINE_PAYMENTS_V%ROWTYPE;
820: l_old_Line_Payment_rec OE_AK_LINE_PAYMENTS_V%ROWTYPE;
821: --
822: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
823: --
824: BEGIN
825:
826: API_Rec_To_Rowtype_Rec(p_x_Line_Payment_rec, l_Line_Payment_rec);

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

865: AND OH.line_id=p_line_id;
866:
867: l_order_hold_id OE_ORDER_HOLDS.ORDER_HOLD_ID%TYPE;
868: l_hold_release_id OE_ORDER_HOLDS.HOLD_RELEASE_ID%TYPE;
869: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
870:
871: BEGIN
872: x_return_status := FND_API.G_RET_STS_SUCCESS;
873:

Line 875: oe_debug_pub.add( 'Entering Delete_Line_PaymentType_Hold' , 3 ) ;

871: BEGIN
872: x_return_status := FND_API.G_RET_STS_SUCCESS;
873:
874: IF l_debug_level > 0 THEN
875: oe_debug_pub.add( 'Entering Delete_Line_PaymentType_Hold' , 3 ) ;
876: END IF;
877:
878: OPEN line_paytype_hold;
879:

Line 887: oe_debug_pub.add( 'DELETING LINE PAYMENT TYPE HOLD' ) ;

883: EXIT;
884: END IF;
885:
886: IF l_debug_level > 0 THEN
887: oe_debug_pub.add( 'DELETING LINE PAYMENT TYPE HOLD' ) ;
888: END IF;
889:
890: DELETE FROM OE_ORDER_HOLDS
891: WHERE order_hold_id = l_order_hold_id;

Line 901: oe_debug_pub.add( 'Exiting Delete_Line_PaymentType_Hold' , 3 ) ;

897:
898: CLOSE line_paytype_hold;
899:
900: IF l_debug_level > 0 THEN
901: oe_debug_pub.add( 'Exiting Delete_Line_PaymentType_Hold' , 3 ) ;
902: END IF;
903:
904: EXCEPTION
905: WHEN FND_API.G_EXC_ERROR THEN

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

935: )
936: IS
937: l_return_status Varchar2(10);
938: --
939: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
940: --
941: l_payments_update_flag VARCHAR2(1) := 'N';
942: --bug3625027 start
943: l_invoke_credit_checking VARCHAR2(1) := 'N';

Line 1099: --oe_debug_pub.add('Old cc number'||p_old_Line_Payment_rec.credit_card_number);

1095: --Since the credit card numbers are encrypted, passing both the credit card
1096: --numbers as well as instrument ids to determine if both the old and new
1097: --values point to the same credit card number.
1098: IF l_debug_level > 0 THEN
1099: --oe_debug_pub.add('Old cc number'||p_old_Line_Payment_rec.credit_card_number);
1100: --oe_debug_pub.add('New cc number'||p_x_Line_Payment_rec.credit_card_number);
1101: oe_debug_pub.add('Old instr id'||p_old_Line_Payment_rec.cc_instrument_id);
1102: oe_debug_pub.add('New instr id'||p_x_Line_Payment_rec.cc_instrument_id);
1103: END IF;

Line 1100: --oe_debug_pub.add('New cc number'||p_x_Line_Payment_rec.credit_card_number);

1096: --numbers as well as instrument ids to determine if both the old and new
1097: --values point to the same credit card number.
1098: IF l_debug_level > 0 THEN
1099: --oe_debug_pub.add('Old cc number'||p_old_Line_Payment_rec.credit_card_number);
1100: --oe_debug_pub.add('New cc number'||p_x_Line_Payment_rec.credit_card_number);
1101: oe_debug_pub.add('Old instr id'||p_old_Line_Payment_rec.cc_instrument_id);
1102: oe_debug_pub.add('New instr id'||p_x_Line_Payment_rec.cc_instrument_id);
1103: END IF;
1104:

Line 1101: oe_debug_pub.add('Old instr id'||p_old_Line_Payment_rec.cc_instrument_id);

1097: --values point to the same credit card number.
1098: IF l_debug_level > 0 THEN
1099: --oe_debug_pub.add('Old cc number'||p_old_Line_Payment_rec.credit_card_number);
1100: --oe_debug_pub.add('New cc number'||p_x_Line_Payment_rec.credit_card_number);
1101: oe_debug_pub.add('Old instr id'||p_old_Line_Payment_rec.cc_instrument_id);
1102: oe_debug_pub.add('New instr id'||p_x_Line_Payment_rec.cc_instrument_id);
1103: END IF;
1104:
1105: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_Line_Payment_rec.credit_card_number,

Line 1102: oe_debug_pub.add('New instr id'||p_x_Line_Payment_rec.cc_instrument_id);

1098: IF l_debug_level > 0 THEN
1099: --oe_debug_pub.add('Old cc number'||p_old_Line_Payment_rec.credit_card_number);
1100: --oe_debug_pub.add('New cc number'||p_x_Line_Payment_rec.credit_card_number);
1101: oe_debug_pub.add('Old instr id'||p_old_Line_Payment_rec.cc_instrument_id);
1102: oe_debug_pub.add('New instr id'||p_x_Line_Payment_rec.cc_instrument_id);
1103: END IF;
1104:
1105: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_Line_Payment_rec.credit_card_number,
1106: p_x_Line_Payment_rec.credit_card_number,

Line 1115: oe_debug_pub.add('in Is_Same_Credit_Card' );

1111: --CC Reversal ER#16014135 start
1112: IF p_x_Line_Payment_rec.operation ='UPDATE' AND OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_type_code,p_old_Line_Payment_rec.payment_type_code) THEN
1113: l_verify_payment_flag:='Y';
1114: IF l_debug_level > 0 THEN
1115: oe_debug_pub.add('in Is_Same_Credit_Card' );
1116: END IF;
1117: END IF;
1118: --CC Reversal ER#16014135 end
1119: END IF;

Line 1132: oe_debug_pub.add('in commitment_applied_amount' );

1128: NULL;
1129: --CC Reversal ER#16014135 start
1130: l_verify_payment_flag:='Y';
1131: IF l_debug_level > 0 THEN
1132: oe_debug_pub.add('in commitment_applied_amount' );
1133: END IF;
1134: --CC Reversal ER#16014135 end
1135: END IF;
1136:

Line 1143: oe_debug_pub.add('in commitment_interfaced_amount' );

1139: NULL;
1140: --CC Reversal ER#16014135 start
1141: l_verify_payment_flag:='Y';
1142: IF l_debug_level > 0 THEN
1143: oe_debug_pub.add('in commitment_interfaced_amount' );
1144: END IF;
1145: --CC Reversal ER#16014135 end
1146: END IF;
1147:

Line 1185: oe_debug_pub.add('in trxn_extension_id '||p_x_Line_Payment_rec.trxn_extension_id );

1181: NULL;
1182: --CC Reversal ER#16014135 start
1183: l_verify_payment_flag:='Y';
1184: IF l_debug_level > 0 THEN
1185: oe_debug_pub.add('in trxn_extension_id '||p_x_Line_Payment_rec.trxn_extension_id );
1186: oe_debug_pub.add('in trxn_extension_id '||p_old_Line_Payment_rec.trxn_extension_id );
1187: END IF;
1188: --CC Reversal ER#16014135 end
1189: END IF;

Line 1186: oe_debug_pub.add('in trxn_extension_id '||p_old_Line_Payment_rec.trxn_extension_id );

1182: --CC Reversal ER#16014135 start
1183: l_verify_payment_flag:='Y';
1184: IF l_debug_level > 0 THEN
1185: oe_debug_pub.add('in trxn_extension_id '||p_x_Line_Payment_rec.trxn_extension_id );
1186: oe_debug_pub.add('in trxn_extension_id '||p_old_Line_Payment_rec.trxn_extension_id );
1187: END IF;
1188: --CC Reversal ER#16014135 end
1189: END IF;
1190:

Line 1217: oe_debug_pub.add('in payment_type_code '||p_x_Line_Payment_rec.payment_type_code );

1213: IF (p_x_Line_Payment_rec.operation ='UPDATE'AND p_x_Line_Payment_rec.payment_type_code<>'CREDIT_CARD')
1214: THEN
1215: l_verify_payment_flag:='Y';
1216: IF l_debug_level > 0 THEN
1217: oe_debug_pub.add('in payment_type_code '||p_x_Line_Payment_rec.payment_type_code );
1218: oe_debug_pub.add('in payment_type_code '||p_old_Line_Payment_rec.payment_type_code );
1219: END IF;
1220: END IF;
1221:

Line 1218: oe_debug_pub.add('in payment_type_code '||p_old_Line_Payment_rec.payment_type_code );

1214: THEN
1215: l_verify_payment_flag:='Y';
1216: IF l_debug_level > 0 THEN
1217: oe_debug_pub.add('in payment_type_code '||p_x_Line_Payment_rec.payment_type_code );
1218: oe_debug_pub.add('in payment_type_code '||p_old_Line_Payment_rec.payment_type_code );
1219: END IF;
1220: END IF;
1221:
1222: IF (p_x_Line_Payment_rec.operation ='CREATE'AND p_x_Line_Payment_rec.payment_type_code<>'CREDIT_CARD' ) THEN

Line 1240: oe_debug_pub.add('in payment_type_code '||p_x_Line_Payment_rec.payment_type_code );

1236: END;
1237: IF l_header_inv_cc_payment ='Y' THEN
1238: l_verify_payment_flag:='Y';
1239: IF l_debug_level > 0 THEN
1240: oe_debug_pub.add('in payment_type_code '||p_x_Line_Payment_rec.payment_type_code );
1241: oe_debug_pub.add('in payment_type_code '||p_old_Line_Payment_rec.payment_type_code );
1242: END IF;
1243: END IF;
1244: END IF;

Line 1241: oe_debug_pub.add('in payment_type_code '||p_old_Line_Payment_rec.payment_type_code );

1237: IF l_header_inv_cc_payment ='Y' THEN
1238: l_verify_payment_flag:='Y';
1239: IF l_debug_level > 0 THEN
1240: oe_debug_pub.add('in payment_type_code '||p_x_Line_Payment_rec.payment_type_code );
1241: oe_debug_pub.add('in payment_type_code '||p_old_Line_Payment_rec.payment_type_code );
1242: END IF;
1243: END IF;
1244: END IF;
1245: --CC Reversal ER#16014135 end

Line 1282: oe_debug_pub.add('l_invoke_credit_checking is: '||l_invoke_credit_checking, 3);

1278: IF l_booked_flag = 'Y' AND
1279: NOT OE_GLOBALS.Equal(l_cc_flag_old,l_cc_flag_new) THEN
1280:
1281: IF( l_debug_level > 0) THEN
1282: oe_debug_pub.add('l_invoke_credit_checking is: '||l_invoke_credit_checking, 3);
1283: END IF;
1284:
1285: l_invoke_credit_checking := 'Y';
1286:

Line 1353: oe_debug_pub.add('logging synch from ULPMB.pls payment delayed request', 1);

1349:
1350: IF l_payments_update_flag = 'Y' and
1351: OE_PrePayment_UTIL.IS_MULTIPLE_PAYMENTS_ENABLED = TRUE then
1352:
1353: oe_debug_pub.add('logging synch from ULPMB.pls payment delayed request', 1);
1354:
1355: oe_debug_pub.add('line_id is: ' || p_x_Line_Payment_rec.line_id);
1356:
1357: OE_delayed_requests_Pvt.log_request

Line 1355: oe_debug_pub.add('line_id is: ' || p_x_Line_Payment_rec.line_id);

1351: OE_PrePayment_UTIL.IS_MULTIPLE_PAYMENTS_ENABLED = TRUE then
1352:
1353: oe_debug_pub.add('logging synch from ULPMB.pls payment delayed request', 1);
1354:
1355: oe_debug_pub.add('line_id is: ' || p_x_Line_Payment_rec.line_id);
1356:
1357: OE_delayed_requests_Pvt.log_request
1358: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,
1359: p_entity_id => p_x_Line_Payment_rec.line_id,

Line 1371: oe_debug_pub.add('OEXULPMB: Logging delayed request for Commitment.', 1);

1367: END IF;
1368:
1369: IF l_calculate_commitment_flag = 'Y' THEN
1370: IF l_debug_level > 0 then
1371: oe_debug_pub.add('OEXULPMB: Logging delayed request for Commitment.', 1);
1372: END IF;
1373:
1374: OE_Delayed_Requests_Pvt.Log_Request(
1375: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,

Line 1387: oe_debug_pub.add('pviprana: logging a new payment delayed request for processing the payment', 1);

1383: --bug3625027 start
1384: IF l_invoke_credit_checking = 'Y'
1385: AND OE_PrePayment_UTIL.IS_MULTIPLE_PAYMENTS_ENABLED = TRUE THEN
1386: IF( l_debug_level > 0) THEN
1387: oe_debug_pub.add('pviprana: logging a new payment delayed request for processing the payment', 1);
1388: oe_debug_pub.add('line_id is: ' || p_x_Line_Payment_rec.line_id);
1389: END IF;
1390: OE_delayed_requests_Pvt.log_request
1391: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,

Line 1388: oe_debug_pub.add('line_id is: ' || p_x_Line_Payment_rec.line_id);

1384: IF l_invoke_credit_checking = 'Y'
1385: AND OE_PrePayment_UTIL.IS_MULTIPLE_PAYMENTS_ENABLED = TRUE THEN
1386: IF( l_debug_level > 0) THEN
1387: oe_debug_pub.add('pviprana: logging a new payment delayed request for processing the payment', 1);
1388: oe_debug_pub.add('line_id is: ' || p_x_Line_Payment_rec.line_id);
1389: END IF;
1390: OE_delayed_requests_Pvt.log_request
1391: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,
1392: p_entity_id => p_x_Line_Payment_rec.header_id,

Line 1403: oe_debug_pub.add('OEXULPMB: Logging delayed request for Delete_Payment_Hold.', 3);

1399: --bug3625027 end
1400:
1401: IF l_delete_pmt_hold = 'Y' THEN
1402: IF l_debug_level > 0 then
1403: oe_debug_pub.add('OEXULPMB: Logging delayed request for Delete_Payment_Hold.', 3);
1404: END IF;
1405:
1406: OE_delayed_requests_Pvt.log_request
1407: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,

Line 1418: oe_debug_pub.add('OEXULPMB.pls : exiting apply attribute changes');

1414: x_return_status => l_return_status);
1415: END IF;
1416:
1417:
1418: oe_debug_pub.add('OEXULPMB.pls : exiting apply attribute changes');
1419:
1420: --ER#7479609 start
1421: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_type_code,p_old_Line_Payment_rec.payment_type_code)
1422: THEN

Line 1423: oe_debug_pub.add('logging Delayed request for evaluation of payments hold', 1);

1419:
1420: --ER#7479609 start
1421: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_type_code,p_old_Line_Payment_rec.payment_type_code)
1422: THEN
1423: oe_debug_pub.add('logging Delayed request for evaluation of payments hold', 1);
1424:
1425: OE_delayed_requests_Pvt.log_request
1426: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,
1427: p_entity_id => p_x_Line_Payment_rec.line_id,

Line 1441: oe_debug_pub.ADD('OEXULPMB: Logging delayed request for Verify Payment CC Reversal',5);

1437: --CC Reversal ER#16014135 Start
1438: IF OE_VERIFY_PAYMENT_PUB.Get_CC_Rev_Reauth_Code(p_x_Line_Payment_rec.header_id) IS NOT NULL
1439: AND l_verify_payment_flag='Y' THEN
1440: IF l_debug_level > 0 THEN
1441: oe_debug_pub.ADD('OEXULPMB: Logging delayed request for Verify Payment CC Reversal',5);
1442: END IF;
1443: oe_verify_payment_pub.G_credit_check_flag := 'N' ;
1444: OE_delayed_requests_Pvt.log_request
1445: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

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

1459: , p_old_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type
1460: )
1461: IS
1462: --
1463: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1464: --
1465: BEGIN
1466:
1467: IF p_x_Line_Payment_rec.attribute1 = FND_API.G_MISS_CHAR THEN

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

1676: )
1677: IS
1678:
1679: --
1680: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1681: --
1682: BEGIN
1683:
1684: IF p_x_Line_Payment_rec.attribute1 = FND_API.G_MISS_CHAR THEN

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

1893: l_return_status VARCHAR2(1);
1894:
1895:
1896: --
1897: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1898: --
1899: BEGIN
1900:
1901: SELECT lock_control

Line 1914: oe_debug_pub.add( 'JFC: payment_number' || P_LINE_Payment_REC.payment_number ) ;

1910: --calling notification framework to update global picture
1911: --check code release level first. Notification framework is at Pack H level
1912: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
1913: IF l_debug_level > 0 THEN
1914: oe_debug_pub.add( 'JFC: payment_number' || P_LINE_Payment_REC.payment_number ) ;
1915: END IF;
1916: -- Sasi: this should be added by Renga
1917: /* OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
1918: p_Line_pmt_rec =>p_line_Payment_rec,

Line 1923: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_PAYMENT_UTIL.UPDATE_ROW IS: ' || L_RETURN_STATUS ) ;

1919: p_line_pmt_id => p_line_Payment_rec.payment_number,
1920: x_index => l_index,
1921: x_return_status => l_return_status); */
1922: IF l_debug_level > 0 THEN
1923: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_PAYMENT_UTIL.UPDATE_ROW IS: ' || L_RETURN_STATUS ) ;
1924: END IF;
1925: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1926: IF l_debug_level > 0 THEN
1927: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;

Line 1927: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;

1923: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_PAYMENT_UTIL.UPDATE_ROW IS: ' || L_RETURN_STATUS ) ;
1924: END IF;
1925: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1926: IF l_debug_level > 0 THEN
1927: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
1928: END IF;
1929: IF l_debug_level > 0 THEN
1930: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.UPDATE_ROW' , 1 ) ;
1931: END IF;

Line 1930: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.UPDATE_ROW' , 1 ) ;

1926: IF l_debug_level > 0 THEN
1927: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
1928: END IF;
1929: IF l_debug_level > 0 THEN
1930: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.UPDATE_ROW' , 1 ) ;
1931: END IF;
1932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1933: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1934: IF l_debug_level > 0 THEN

Line 1935: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_PAYMENT_UTIL.UPDATE_ROW' ) ;

1931: END IF;
1932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1933: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1934: IF l_debug_level > 0 THEN
1935: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_PAYMENT_UTIL.UPDATE_ROW' ) ;
1936: END IF;
1937: IF l_debug_level > 0 THEN
1938: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.UPDATE_ROW' , 1 ) ;
1939: END IF;

Line 1938: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.UPDATE_ROW' , 1 ) ;

1934: IF l_debug_level > 0 THEN
1935: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_PAYMENT_UTIL.UPDATE_ROW' ) ;
1936: END IF;
1937: IF l_debug_level > 0 THEN
1938: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.UPDATE_ROW' , 1 ) ;
1939: END IF;
1940: RAISE FND_API.G_EXC_ERROR;
1941: END IF;
1942: END IF; /*code_release_level*/

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

2025: l_index NUMBER;
2026: l_return_status VARCHAR2(1);
2027: l_transaction_phase_code VARCHAR2(30);
2028: --
2029: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2030: --
2031: BEGIN
2032: IF l_debug_level > 0 THEN
2033: oe_debug_pub.add( 'ENTERING OE_LINE_PAYMENT_UTIL.INSERT_ROW' , 1 ) ;

Line 2033: oe_debug_pub.add( 'ENTERING OE_LINE_PAYMENT_UTIL.INSERT_ROW' , 1 ) ;

2029: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2030: --
2031: BEGIN
2032: IF l_debug_level > 0 THEN
2033: oe_debug_pub.add( 'ENTERING OE_LINE_PAYMENT_UTIL.INSERT_ROW' , 1 ) ;
2034: END IF;
2035:
2036: -- QUOTING change
2037: -- No need to insert commitment for orders in negotiation phase

Line 2051: oe_debug_pub.add('trxn phase :'||l_transaction_phase_code);

2047: null;
2048: END;
2049:
2050: if l_debug_level > 0 then
2051: oe_debug_pub.add('trxn phase :'||l_transaction_phase_code);
2052: end if;
2053: IF nvl(l_transaction_phase_code, 'F') = 'N' THEN
2054: RETURN;
2055: END IF;

Line 2176: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_PAYMENT_UTIL.INSERT_ROW IS: ' || L_RETURN_STATUS ) ;

2172: p_lin_pmt_id => p_line_Payment_rec.payment_number,
2173: x_index => l_index,
2174: x_return_status => l_return_status); */
2175: IF l_debug_level > 0 THEN
2176: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_PAYMENT_UTIL.INSERT_ROW IS: ' || L_RETURN_STATUS ) ;
2177: END IF;
2178: IF l_debug_level > 0 THEN
2179: oe_debug_pub.add( 'RETURNED INDEX IS: ' || L_INDEX , 1 ) ;
2180: END IF;

Line 2179: oe_debug_pub.add( 'RETURNED INDEX IS: ' || L_INDEX , 1 ) ;

2175: IF l_debug_level > 0 THEN
2176: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_PAYMENT_UTIL.INSERT_ROW IS: ' || L_RETURN_STATUS ) ;
2177: END IF;
2178: IF l_debug_level > 0 THEN
2179: oe_debug_pub.add( 'RETURNED INDEX IS: ' || L_INDEX , 1 ) ;
2180: END IF;
2181:
2182: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2183: IF l_debug_level > 0 THEN

Line 2184: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;

2180: END IF;
2181:
2182: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2183: IF l_debug_level > 0 THEN
2184: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2185: END IF;
2186: IF l_debug_level > 0 THEN
2187: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.INSERT_ROW' , 1 ) ;
2188: END IF;

Line 2187: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.INSERT_ROW' , 1 ) ;

2183: IF l_debug_level > 0 THEN
2184: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2185: END IF;
2186: IF l_debug_level > 0 THEN
2187: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.INSERT_ROW' , 1 ) ;
2188: END IF;
2189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2190: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2191: IF l_debug_level > 0 THEN

Line 2192: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_PAYMENT_UTIL.INSERT_ROW' ) ;

2188: END IF;
2189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2190: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2191: IF l_debug_level > 0 THEN
2192: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_PAYMENT_UTIL.INSERT_ROW' ) ;
2193: END IF;
2194: IF l_debug_level > 0 THEN
2195: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.INSERT_ROW' , 1 ) ;
2196: END IF;

Line 2195: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.INSERT_ROW' , 1 ) ;

2191: IF l_debug_level > 0 THEN
2192: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_PAYMENT_UTIL.INSERT_ROW' ) ;
2193: END IF;
2194: IF l_debug_level > 0 THEN
2195: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.INSERT_ROW' , 1 ) ;
2196: END IF;
2197: RAISE FND_API.G_EXC_ERROR;
2198: END IF;
2199: END IF; /*code_release_level*/

Line 2203: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.INSERT_ROW' , 1 ) ;

2199: END IF; /*code_release_level*/
2200: -- notification framework end
2201:
2202: IF l_debug_level > 0 THEN
2203: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.INSERT_ROW' , 1 ) ;
2204: END IF;
2205:
2206: EXCEPTION
2207:

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

2249: -- added for notification framework
2250: l_new_line_Payment_rec OE_Order_PUB.Line_Payment_Rec_Type;
2251: l_index NUMBER;
2252: --
2253: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2254: --
2255: BEGIN
2256: IF l_debug_level > 0 THEN
2257: oe_debug_pub.add( 'ENTERING OE_LINE_PAYMENT_UTIL.DELETE_ROW' , 1 ) ;

Line 2257: oe_debug_pub.add( 'ENTERING OE_LINE_PAYMENT_UTIL.DELETE_ROW' , 1 ) ;

2253: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2254: --
2255: BEGIN
2256: IF l_debug_level > 0 THEN
2257: oe_debug_pub.add( 'ENTERING OE_LINE_PAYMENT_UTIL.DELETE_ROW' , 1 ) ;
2258: END IF;
2259:
2260: IF p_line_id <> FND_API.G_MISS_NUM AND
2261: nvl(p_payment_number, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM

Line 2288: oe_debug_pub.add('Deleting trxn id...'||l_trxn_extension_id);

2284: from oe_order_lines_all where
2285: header_id = p_header_id
2286: and line_id = p_line_id;
2287: IF l_debug_level > 0 THEN
2288: oe_debug_pub.add('Deleting trxn id...'||l_trxn_extension_id);
2289: oe_debug_pub.add('Invoice to org.'||l_invoice_to_org_id);
2290: END IF;
2291:
2292: OE_PAYMENT_TRXN_UTIL.Delete_Payment_Trxn

Line 2289: oe_debug_pub.add('Invoice to org.'||l_invoice_to_org_id);

2285: header_id = p_header_id
2286: and line_id = p_line_id;
2287: IF l_debug_level > 0 THEN
2288: oe_debug_pub.add('Deleting trxn id...'||l_trxn_extension_id);
2289: oe_debug_pub.add('Invoice to org.'||l_invoice_to_org_id);
2290: END IF;
2291:
2292: OE_PAYMENT_TRXN_UTIL.Delete_Payment_Trxn
2293: (p_header_id => p_header_id,

Line 2304: oe_debug_pub.add( 'Delete Payment at OE_LINE_Payment_UTIL.DELETE_ROW - UNEXPECTED ERROR' ) ;

2300: x_msg_data => l_msg_data);
2301:
2302: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2303: IF l_debug_level > 0 THEN
2304: oe_debug_pub.add( 'Delete Payment at OE_LINE_Payment_UTIL.DELETE_ROW - UNEXPECTED ERROR' ) ;
2305: oe_debug_pub.add('Error message'||sqlerrm);
2306: oe_debug_pub.add('Msg data'||l_msg_data);
2307: END IF;
2308: IF l_debug_level > 0 THEN

Line 2305: oe_debug_pub.add('Error message'||sqlerrm);

2301:
2302: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2303: IF l_debug_level > 0 THEN
2304: oe_debug_pub.add( 'Delete Payment at OE_LINE_Payment_UTIL.DELETE_ROW - UNEXPECTED ERROR' ) ;
2305: oe_debug_pub.add('Error message'||sqlerrm);
2306: oe_debug_pub.add('Msg data'||l_msg_data);
2307: END IF;
2308: IF l_debug_level > 0 THEN
2309: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;

Line 2306: oe_debug_pub.add('Msg data'||l_msg_data);

2302: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2303: IF l_debug_level > 0 THEN
2304: oe_debug_pub.add( 'Delete Payment at OE_LINE_Payment_UTIL.DELETE_ROW - UNEXPECTED ERROR' ) ;
2305: oe_debug_pub.add('Error message'||sqlerrm);
2306: oe_debug_pub.add('Msg data'||l_msg_data);
2307: END IF;
2308: IF l_debug_level > 0 THEN
2309: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2310: END IF;

Line 2309: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;

2305: oe_debug_pub.add('Error message'||sqlerrm);
2306: oe_debug_pub.add('Msg data'||l_msg_data);
2307: END IF;
2308: IF l_debug_level > 0 THEN
2309: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2310: END IF;
2311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2312: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2313: IF l_debug_level > 0 THEN

Line 2314: oe_debug_pub.add( 'Delete Payment at OE_LINE_Payment_UTIL.DELETE_ROW' ) ;

2310: END IF;
2311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2312: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2313: IF l_debug_level > 0 THEN
2314: oe_debug_pub.add( 'Delete Payment at OE_LINE_Payment_UTIL.DELETE_ROW' ) ;
2315: oe_debug_pub.add('Error message'||sqlerrm);
2316: oe_debug_pub.add('Msg data'||l_msg_data);
2317: END IF;
2318: IF l_debug_level > 0 THEN

Line 2315: oe_debug_pub.add('Error message'||sqlerrm);

2311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2312: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2313: IF l_debug_level > 0 THEN
2314: oe_debug_pub.add( 'Delete Payment at OE_LINE_Payment_UTIL.DELETE_ROW' ) ;
2315: oe_debug_pub.add('Error message'||sqlerrm);
2316: oe_debug_pub.add('Msg data'||l_msg_data);
2317: END IF;
2318: IF l_debug_level > 0 THEN
2319: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;

Line 2316: oe_debug_pub.add('Msg data'||l_msg_data);

2312: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2313: IF l_debug_level > 0 THEN
2314: oe_debug_pub.add( 'Delete Payment at OE_LINE_Payment_UTIL.DELETE_ROW' ) ;
2315: oe_debug_pub.add('Error message'||sqlerrm);
2316: oe_debug_pub.add('Msg data'||l_msg_data);
2317: END IF;
2318: IF l_debug_level > 0 THEN
2319: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2320: END IF;

Line 2319: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;

2315: oe_debug_pub.add('Error message'||sqlerrm);
2316: oe_debug_pub.add('Msg data'||l_msg_data);
2317: END IF;
2318: IF l_debug_level > 0 THEN
2319: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2320: END IF;
2321: RAISE FND_API.G_EXC_ERROR;
2322: END IF;
2323: END IF;

Line 2333: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_PAYMENT_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;

2329: p_lin_pmt_id => l_pmt.payment_number,
2330: x_index => l_index,
2331: x_return_status => l_return_status);
2332: IF l_debug_level > 0 THEN
2333: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_PAYMENT_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
2334: END IF;
2335: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2336: IF l_debug_level > 0 THEN
2337: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;

Line 2337: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;

2333: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_PAYMENT_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
2334: END IF;
2335: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2336: IF l_debug_level > 0 THEN
2337: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2338: END IF;
2339: IF l_debug_level > 0 THEN
2340: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.DELETE_ROW' , 1 ) ;
2341: END IF;

Line 2340: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.DELETE_ROW' , 1 ) ;

2336: IF l_debug_level > 0 THEN
2337: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2338: END IF;
2339: IF l_debug_level > 0 THEN
2340: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.DELETE_ROW' , 1 ) ;
2341: END IF;
2342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2343: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2344: IF l_debug_level > 0 THEN

Line 2345: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_PAYMENT_UTIL.DELETE_ROW' ) ;

2341: END IF;
2342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2343: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2344: IF l_debug_level > 0 THEN
2345: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_PAYMENT_UTIL.DELETE_ROW' ) ;
2346: END IF;
2347: IF l_debug_level > 0 THEN
2348: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.DELETE_ROW' , 1 ) ;
2349: END IF;

Line 2348: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.DELETE_ROW' , 1 ) ;

2344: IF l_debug_level > 0 THEN
2345: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_PAYMENT_UTIL.DELETE_ROW' ) ;
2346: END IF;
2347: IF l_debug_level > 0 THEN
2348: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.DELETE_ROW' , 1 ) ;
2349: END IF;
2350: RAISE FND_API.G_EXC_ERROR;
2351: END IF;*/
2352: END IF; /*code_release_level*/

Line 2369: oe_debug_pub.add('1: after executing delete statement against oe_payments - before delete_payment_at_line');

2365: AND HEADER_ID = p_header_id;
2366:
2367: --3382262
2368: IF l_debug_level > 0 THEN
2369: oe_debug_pub.add('1: after executing delete statement against oe_payments - before delete_payment_at_line');
2370: END IF;
2371:
2372:
2373: Delete_Payment_at_line(p_line_id => p_line_id,

Line 2381: oe_debug_pub.add( 'Delete Payment at Line - UNEXPECTED ERROR' ) ;

2377: x_msg_data => l_msg_data);
2378:
2379: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2380: IF l_debug_level > 0 THEN
2381: oe_debug_pub.add( 'Delete Payment at Line - UNEXPECTED ERROR' ) ;
2382: END IF;
2383: IF l_debug_level > 0 THEN
2384: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2385: END IF;

Line 2384: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;

2380: IF l_debug_level > 0 THEN
2381: oe_debug_pub.add( 'Delete Payment at Line - UNEXPECTED ERROR' ) ;
2382: END IF;
2383: IF l_debug_level > 0 THEN
2384: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2385: END IF;
2386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2387: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2388: IF l_debug_level > 0 THEN

Line 2389: oe_debug_pub.add( 'Delete Payment at Line - OE_LINE_Payment_UTIL.DELETE_ROW' ) ;

2385: END IF;
2386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2387: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2388: IF l_debug_level > 0 THEN
2389: oe_debug_pub.add( 'Delete Payment at Line - OE_LINE_Payment_UTIL.DELETE_ROW' ) ;
2390: END IF;
2391: IF l_debug_level > 0 THEN
2392: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2393: END IF;

Line 2392: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;

2388: IF l_debug_level > 0 THEN
2389: oe_debug_pub.add( 'Delete Payment at Line - OE_LINE_Payment_UTIL.DELETE_ROW' ) ;
2390: END IF;
2391: IF l_debug_level > 0 THEN
2392: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2393: END IF;
2394: RAISE FND_API.G_EXC_ERROR;
2395: END IF;
2396: --3382262

Line 2399: oe_debug_pub.add( 'Releasing line level authorization hold.' , 3 ) ;

2395: END IF;
2396: --3382262
2397:
2398: IF l_debug_level > 0 THEN
2399: oe_debug_pub.add( 'Releasing line level authorization hold.' , 3 ) ;
2400: END IF;
2401: OE_Verify_Payment_PUB.Release_Verify_Line_Hold
2402: ( p_header_id => p_header_id
2403: , p_line_id => p_line_id

Line 2448: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_PAYMENT_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;

2444: END IF;
2445: --ER#7479609 end
2446:
2447: IF l_debug_level > 0 THEN
2448: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_PAYMENT_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
2449: END IF;
2450:
2451: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2452: IF l_debug_level > 0 THEN

Line 2453: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;

2449: END IF;
2450:
2451: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2452: IF l_debug_level > 0 THEN
2453: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2454: END IF;
2455: IF l_debug_level > 0 THEN
2456: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.DELETE_ROW' , 1 ) ;
2457: END IF;

Line 2456: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.DELETE_ROW' , 1 ) ;

2452: IF l_debug_level > 0 THEN
2453: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2454: END IF;
2455: IF l_debug_level > 0 THEN
2456: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.DELETE_ROW' , 1 ) ;
2457: END IF;
2458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2459: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2460: IF l_debug_level > 0 THEN

Line 2461: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_PAYMENT_UTIL.DELETE_ROW' ) ;

2457: END IF;
2458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2459: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2460: IF l_debug_level > 0 THEN
2461: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_PAYMENT_UTIL.DELETE_ROW' ) ;
2462: END IF;
2463: IF l_debug_level > 0 THEN
2464: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.DELETE_ROW' , 1 ) ;
2465: END IF;

Line 2464: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.DELETE_ROW' , 1 ) ;

2460: IF l_debug_level > 0 THEN
2461: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_PAYMENT_UTIL.DELETE_ROW' ) ;
2462: END IF;
2463: IF l_debug_level > 0 THEN
2464: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.DELETE_ROW' , 1 ) ;
2465: END IF;
2466: RAISE FND_API.G_EXC_ERROR;
2467: END IF;
2468: END IF; /*code_release_level*/

Line 2497: oe_debug_pub.add('ULPMB.pls: delete_row - could not find the row');

2493:
2494: Exception
2495: when no_data_found then
2496:
2497: oe_debug_pub.add('ULPMB.pls: delete_row - could not find the row');
2498: Raise;
2499: when too_many_rows then
2500: oe_debug_pub.add('ULPMB.pls : delete row - too many rows - should not happen');
2501: Raise;

Line 2500: oe_debug_pub.add('ULPMB.pls : delete row - too many rows - should not happen');

2496:
2497: oe_debug_pub.add('ULPMB.pls: delete_row - could not find the row');
2498: Raise;
2499: when too_many_rows then
2500: oe_debug_pub.add('ULPMB.pls : delete row - too many rows - should not happen');
2501: Raise;
2502: End;
2503:
2504: END;

Line 2517: oe_debug_pub.add('Deleting trxn id...'||l_trxn_extension_id);

2513: select invoice_to_org_id into l_invoice_to_org_id
2514: from oe_order_lines_all where header_id = p_header_id
2515: and line_id = p_line_id;
2516: IF l_debug_level > 0 THEN
2517: oe_debug_pub.add('Deleting trxn id...'||l_trxn_extension_id);
2518: oe_debug_pub.add('Invoice to org.'||l_invoice_to_org_id);
2519: END IF;
2520:
2521: OE_PAYMENT_TRXN_UTIL.Delete_Payment_Trxn

Line 2518: oe_debug_pub.add('Invoice to org.'||l_invoice_to_org_id);

2514: from oe_order_lines_all where header_id = p_header_id
2515: and line_id = p_line_id;
2516: IF l_debug_level > 0 THEN
2517: oe_debug_pub.add('Deleting trxn id...'||l_trxn_extension_id);
2518: oe_debug_pub.add('Invoice to org.'||l_invoice_to_org_id);
2519: END IF;
2520:
2521: OE_PAYMENT_TRXN_UTIL.Delete_Payment_Trxn
2522: (p_header_id => p_header_id,

Line 2534: oe_debug_pub.add( '2:Delete Payment OE_LINE_Payment_UTIL.DELETE_ROW - UNEXPECTED ERROR' ) ;

2530:
2531:
2532: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2533: IF l_debug_level > 0 THEN
2534: oe_debug_pub.add( '2:Delete Payment OE_LINE_Payment_UTIL.DELETE_ROW - UNEXPECTED ERROR' ) ;
2535: END IF;
2536: IF l_debug_level > 0 THEN
2537: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2538: END IF;

Line 2537: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;

2533: IF l_debug_level > 0 THEN
2534: oe_debug_pub.add( '2:Delete Payment OE_LINE_Payment_UTIL.DELETE_ROW - UNEXPECTED ERROR' ) ;
2535: END IF;
2536: IF l_debug_level > 0 THEN
2537: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2538: END IF;
2539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2540: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2541: IF l_debug_level > 0 THEN

Line 2542: oe_debug_pub.add( '2:Delete Payment OE_LINE_Payment_UTIL.DELETE_ROW' ) ;

2538: END IF;
2539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2540: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2541: IF l_debug_level > 0 THEN
2542: oe_debug_pub.add( '2:Delete Payment OE_LINE_Payment_UTIL.DELETE_ROW' ) ;
2543: END IF;
2544: IF l_debug_level > 0 THEN
2545: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2546: END IF;

Line 2545: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;

2541: IF l_debug_level > 0 THEN
2542: oe_debug_pub.add( '2:Delete Payment OE_LINE_Payment_UTIL.DELETE_ROW' ) ;
2543: END IF;
2544: IF l_debug_level > 0 THEN
2545: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2546: END IF;
2547: RAISE FND_API.G_EXC_ERROR;
2548: END IF;
2549: END IF;

Line 2560: oe_debug_pub.add('2: after executing delete statement against oe_payments - before delete_payment_at_line');

2556: ;
2557:
2558: --3382262
2559: IF l_debug_level > 0 THEN
2560: oe_debug_pub.add('2: after executing delete statement against oe_payments - before delete_payment_at_line');
2561: END IF;
2562:
2563:
2564: Delete_Payment_at_line(p_line_id => p_line_id,

Line 2574: oe_debug_pub.add( 'Delete Payment at Line - UNEXPECTED ERROR' ) ;

2570: x_msg_data => l_msg_data);
2571:
2572: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2573: IF l_debug_level > 0 THEN
2574: oe_debug_pub.add( 'Delete Payment at Line - UNEXPECTED ERROR' ) ;
2575: END IF;
2576: IF l_debug_level > 0 THEN
2577: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2578: END IF;

Line 2577: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;

2573: IF l_debug_level > 0 THEN
2574: oe_debug_pub.add( 'Delete Payment at Line - UNEXPECTED ERROR' ) ;
2575: END IF;
2576: IF l_debug_level > 0 THEN
2577: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2578: END IF;
2579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2580: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2581: IF l_debug_level > 0 THEN

Line 2582: oe_debug_pub.add( 'Delete Payment at Line - OE_LINE_Payment_UTIL.DELETE_ROW' ) ;

2578: END IF;
2579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2580: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2581: IF l_debug_level > 0 THEN
2582: oe_debug_pub.add( 'Delete Payment at Line - OE_LINE_Payment_UTIL.DELETE_ROW' ) ;
2583: END IF;
2584: IF l_debug_level > 0 THEN
2585: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2586: END IF;

Line 2585: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;

2581: IF l_debug_level > 0 THEN
2582: oe_debug_pub.add( 'Delete Payment at Line - OE_LINE_Payment_UTIL.DELETE_ROW' ) ;
2583: END IF;
2584: IF l_debug_level > 0 THEN
2585: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2586: END IF;
2587: RAISE FND_API.G_EXC_ERROR;
2588: END IF;
2589: --3382262

Line 2593: oe_debug_pub.add( 'Releasing line level authorization hold.' , 3 ) ;

2589: --3382262
2590:
2591: IF p_payment_type_code = 'CREDIT_CARD' THEN
2592: IF l_debug_level > 0 THEN
2593: oe_debug_pub.add( 'Releasing line level authorization hold.' , 3 ) ;
2594: END IF;
2595: OE_Verify_Payment_PUB.Release_Verify_Line_Hold
2596: ( p_header_id => p_header_id
2597: , p_line_id => p_line_id

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

2692: AND HEADER_ID = p_header_id
2693: );
2694:
2695: --
2696: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2697: --
2698: --R12 CC Encryption Verify
2699: x_bank_account_number VARCHAR2(100); --bug 5170754
2700: x_check_number varchar2(100);

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

2900: AND HEADER_ID = p_header_id
2901: ;
2902:
2903: --
2904: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2905: --
2906: --R12 CC Encryption Verify
2907: x_bank_account_number VARCHAR2(100); --bug 5170754
2908: x_check_number varchar2(100);

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

3034: l_header_id NUMBER;
3035: l_Line_Payment_rec OE_Order_PUB.Line_Payment_Rec_Type;
3036: l_lock_control NUMBER;
3037: --
3038: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3039: --
3040: BEGIN
3041:
3042: IF l_debug_level > 0 THEN

Line 3043: oe_debug_pub.add( 'ENTERING OE_LINE_PAYMENT_UTIL.LOCK_ROW' , 1 ) ;

3039: --
3040: BEGIN
3041:
3042: IF l_debug_level > 0 THEN
3043: oe_debug_pub.add( 'ENTERING OE_LINE_PAYMENT_UTIL.LOCK_ROW' , 1 ) ;
3044: END IF;
3045:
3046: SAVEPOINT Lock_Row;
3047:

Line 3071: oe_debug_pub.add( 'SELECTED FOR UPDATE' , 1 ) ;

3067: AND header_id = l_header_id
3068: FOR UPDATE NOWAIT;
3069:
3070: IF l_debug_level > 0 THEN
3071: oe_debug_pub.add( 'SELECTED FOR UPDATE' , 1 ) ;
3072: END IF;
3073:
3074: OE_Line_Payment_Util.Query_Row
3075: (p_payment_number => l_payment_number

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

3187: FOR UPDATE NOWAIT;
3188:
3189: l_payment_number NUMBER;
3190: --
3191: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3192: --
3193: BEGIN
3194:
3195: IF l_debug_level > 0 THEN

Line 3196: oe_debug_pub.add( 'ENTERING OE_HEADER_PaymentS_UTIL.LOCK_ROWS' , 1 ) ;

3192: --
3193: BEGIN
3194:
3195: IF l_debug_level > 0 THEN
3196: oe_debug_pub.add( 'ENTERING OE_HEADER_PaymentS_UTIL.LOCK_ROWS' , 1 ) ;
3197: END IF;
3198: /*
3199: IF (p_payment_number IS NOT NULL AND
3200: p_payment_number <> FND_API.G_MISS_NUM) AND

Line 3270: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENTS_UTIL.LOCK_ROWS' , 1 ) ;

3266:
3267: x_return_status := FND_API.G_RET_STS_SUCCESS;
3268:
3269: IF l_debug_level > 0 THEN
3270: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENTS_UTIL.LOCK_ROWS' , 1 ) ;
3271: END IF;
3272:
3273: EXCEPTION
3274: WHEN NO_DATA_FOUND THEN

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

3314: )RETURN OE_Order_PUB.Line_Payment_Val_Rec_Type
3315: IS
3316: l_Line_Payment_val_rec OE_Order_PUB.Line_Payment_Val_Rec_Type;
3317: --
3318: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3319: --
3320: BEGIN
3321:
3322: IF (p_Line_Payment_rec.payment_collection_event IS NULL OR

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

3361: )
3362: IS
3363:
3364: --
3365: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3366: --
3367: BEGIN
3368:
3369: -- initialize return_status.

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

3491: --
3492: l_new_commitment_bal NUMBER;
3493: l_commitment VARCHAR2(20);
3494: --
3495: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3496: --
3497: --R12 CC Encryption
3498: l_order_source_doc_id NUMBER;
3499: l_trxn_extension_id NUMBER;

Line 3510: oe_debug_pub.add( 'entering oe_line_payment_util.Pre_Write_Process. payment_type_code'||p_x_line_Payment_rec.payment_type_code);

3506:
3507: BEGIN
3508:
3509: IF l_debug_level > 0 THEN
3510: oe_debug_pub.add( 'entering oe_line_payment_util.Pre_Write_Process. payment_type_code'||p_x_line_Payment_rec.payment_type_code);
3511: END IF;
3512:
3513:
3514: --bug 3560198

Line 3517: oe_debug_pub.add('To log commitment balance message');

3513:
3514: --bug 3560198
3515: IF p_x_line_Payment_rec.payment_type_code = 'COMMITMENT' THEN
3516: IF l_debug_level > 0 THEN
3517: oe_debug_pub.add('To log commitment balance message');
3518: END IF;
3519: BEGIN
3520: -- QUOTING change
3521: SELECT l.transaction_phase_code

Line 3534: oe_debug_pub.add('trxn phase :'||l_transaction_phase_code);

3530: END;
3531: -- QUOTING change
3532: -- No need to calculate commitment for orders in negotiation phase
3533: if l_debug_level > 0 then
3534: oe_debug_pub.add('trxn phase :'||l_transaction_phase_code);
3535: end if;
3536: IF l_transaction_phase_code = 'N' THEN
3537: RETURN;
3538: END IF;

Line 3562: oe_debug_pub.add('payment_trx_id : '||p_x_line_Payment_rec.payment_trx_id);

3558: );
3559: END IF;
3560:
3561: IF l_debug_level > 0 THEN
3562: oe_debug_pub.add('payment_trx_id : '||p_x_line_Payment_rec.payment_trx_id);
3563: END IF;
3564: IF p_x_line_Payment_rec.payment_trx_id IS NOT NULL THEN
3565: l_class := NULL;
3566: l_so_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE');

Line 3575: oe_debug_pub.add( 'COMMITMENT BALANCE IS: '||L_COMMITMENT_BAL ) ;

3571: ,l_so_source_code
3572: ,l_oe_installed_flag );
3573: END IF;
3574: IF l_debug_level > 0 THEN
3575: oe_debug_pub.add( 'COMMITMENT BALANCE IS: '||L_COMMITMENT_BAL ) ;
3576: END IF;
3577: IF p_x_line_Payment_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
3578: l_new_commitment_bal := l_commitment_bal - p_x_line_Payment_rec.commitment_applied_amount;
3579: ELSIF p_x_line_Payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

Line 3583: oe_debug_pub.add('l_new_commitment_bal : '||l_new_commitment_bal);

3579: ELSIF p_x_line_Payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3580: l_new_commitment_bal := l_commitment_bal + p_old_line_Payment_rec.commitment_applied_amount - p_x_line_Payment_rec.commitment_applied_amount;
3581: END IF;
3582: IF l_debug_level > 0 THEN
3583: oe_debug_pub.add('l_new_commitment_bal : '||l_new_commitment_bal);
3584: END IF;
3585: -- Added if condition of the Bug #3742103
3586: IF l_new_commitment_bal IS NOT NULL THEN
3587: FND_MESSAGE.Set_Name('ONT','OE_COM_BALANCE');

Line 3639: oe_debug_pub.add( 'l_transactional_curr_code:'||l_transactional_curr_code||':l_invoice_to_org_id:'||l_invoice_to_org_id);

3635: l_ordered_date := OE_Order_Cache.g_header_rec.ordered_date;
3636: l_transactional_curr_code := OE_Order_Cache.g_header_rec.transactional_curr_code;
3637:
3638: IF l_debug_level > 0 THEN
3639: oe_debug_pub.add( 'l_transactional_curr_code:'||l_transactional_curr_code||':l_invoice_to_org_id:'||l_invoice_to_org_id);
3640: END IF;
3641:
3642: BEGIN
3643: SELECT customer_id

Line 3650: oe_debug_pub.add( 'IN OTHERS EXCEPTION ( OE_INVOICE_TO_ORGS_V ) '||SQLERRM , 1 ) ;

3646: WHERE organization_id = l_invoice_to_org_id;
3647: EXCEPTION
3648: WHEN OTHERS THEN
3649: IF l_debug_level > 0 THEN
3650: oe_debug_pub.add( 'IN OTHERS EXCEPTION ( OE_INVOICE_TO_ORGS_V ) '||SQLERRM , 1 ) ;
3651: END IF;
3652: END;
3653: IF l_debug_level > 0 THEN
3654: oe_debug_pub.add('invoice to cust id : ' || l_hdr_inv_to_cust_id );

Line 3654: oe_debug_pub.add('invoice to cust id : ' || l_hdr_inv_to_cust_id );

3650: oe_debug_pub.add( 'IN OTHERS EXCEPTION ( OE_INVOICE_TO_ORGS_V ) '||SQLERRM , 1 ) ;
3651: END IF;
3652: END;
3653: IF l_debug_level > 0 THEN
3654: oe_debug_pub.add('invoice to cust id : ' || l_hdr_inv_to_cust_id );
3655: --oe_debug_pub.add('cc number : ' || p_x_line_Payment_rec.credit_card_number );
3656: --oe_debug_pub.add('cc name : ' || p_x_line_Payment_rec.credit_card_holder_name );
3657: --oe_debug_pub.add('exp date : ' || to_char(p_x_line_Payment_rec.credit_card_expiration_date, 'DD-MON-YYYY') );
3658: oe_debug_pub.add('instr id...'||p_x_line_Payment_rec.cc_instrument_id);

Line 3655: --oe_debug_pub.add('cc number : ' || p_x_line_Payment_rec.credit_card_number );

3651: END IF;
3652: END;
3653: IF l_debug_level > 0 THEN
3654: oe_debug_pub.add('invoice to cust id : ' || l_hdr_inv_to_cust_id );
3655: --oe_debug_pub.add('cc number : ' || p_x_line_Payment_rec.credit_card_number );
3656: --oe_debug_pub.add('cc name : ' || p_x_line_Payment_rec.credit_card_holder_name );
3657: --oe_debug_pub.add('exp date : ' || to_char(p_x_line_Payment_rec.credit_card_expiration_date, 'DD-MON-YYYY') );
3658: oe_debug_pub.add('instr id...'||p_x_line_Payment_rec.cc_instrument_id);
3659: oe_debug_pub.add('instr assgn id'||p_x_line_Payment_rec.cc_instrument_assignment_id);

Line 3656: --oe_debug_pub.add('cc name : ' || p_x_line_Payment_rec.credit_card_holder_name );

3652: END;
3653: IF l_debug_level > 0 THEN
3654: oe_debug_pub.add('invoice to cust id : ' || l_hdr_inv_to_cust_id );
3655: --oe_debug_pub.add('cc number : ' || p_x_line_Payment_rec.credit_card_number );
3656: --oe_debug_pub.add('cc name : ' || p_x_line_Payment_rec.credit_card_holder_name );
3657: --oe_debug_pub.add('exp date : ' || to_char(p_x_line_Payment_rec.credit_card_expiration_date, 'DD-MON-YYYY') );
3658: oe_debug_pub.add('instr id...'||p_x_line_Payment_rec.cc_instrument_id);
3659: oe_debug_pub.add('instr assgn id'||p_x_line_Payment_rec.cc_instrument_assignment_id);
3660: END IF;

Line 3657: --oe_debug_pub.add('exp date : ' || to_char(p_x_line_Payment_rec.credit_card_expiration_date, 'DD-MON-YYYY') );

3653: IF l_debug_level > 0 THEN
3654: oe_debug_pub.add('invoice to cust id : ' || l_hdr_inv_to_cust_id );
3655: --oe_debug_pub.add('cc number : ' || p_x_line_Payment_rec.credit_card_number );
3656: --oe_debug_pub.add('cc name : ' || p_x_line_Payment_rec.credit_card_holder_name );
3657: --oe_debug_pub.add('exp date : ' || to_char(p_x_line_Payment_rec.credit_card_expiration_date, 'DD-MON-YYYY') );
3658: oe_debug_pub.add('instr id...'||p_x_line_Payment_rec.cc_instrument_id);
3659: oe_debug_pub.add('instr assgn id'||p_x_line_Payment_rec.cc_instrument_assignment_id);
3660: END IF;
3661:

Line 3658: oe_debug_pub.add('instr id...'||p_x_line_Payment_rec.cc_instrument_id);

3654: oe_debug_pub.add('invoice to cust id : ' || l_hdr_inv_to_cust_id );
3655: --oe_debug_pub.add('cc number : ' || p_x_line_Payment_rec.credit_card_number );
3656: --oe_debug_pub.add('cc name : ' || p_x_line_Payment_rec.credit_card_holder_name );
3657: --oe_debug_pub.add('exp date : ' || to_char(p_x_line_Payment_rec.credit_card_expiration_date, 'DD-MON-YYYY') );
3658: oe_debug_pub.add('instr id...'||p_x_line_Payment_rec.cc_instrument_id);
3659: oe_debug_pub.add('instr assgn id'||p_x_line_Payment_rec.cc_instrument_assignment_id);
3660: END IF;
3661:
3662: Select SOURCE_DOCUMENT_TYPE_ID

Line 3659: oe_debug_pub.add('instr assgn id'||p_x_line_Payment_rec.cc_instrument_assignment_id);

3655: --oe_debug_pub.add('cc number : ' || p_x_line_Payment_rec.credit_card_number );
3656: --oe_debug_pub.add('cc name : ' || p_x_line_Payment_rec.credit_card_holder_name );
3657: --oe_debug_pub.add('exp date : ' || to_char(p_x_line_Payment_rec.credit_card_expiration_date, 'DD-MON-YYYY') );
3658: oe_debug_pub.add('instr id...'||p_x_line_Payment_rec.cc_instrument_id);
3659: oe_debug_pub.add('instr assgn id'||p_x_line_Payment_rec.cc_instrument_assignment_id);
3660: END IF;
3661:
3662: Select SOURCE_DOCUMENT_TYPE_ID
3663: Into l_order_source_doc_id

Line 3675: oe_debug_pub.add('Before calling copy payment trxn...');

3671: AND (p_x_line_payment_rec.operation = OE_GLOBALS.G_OPR_CREATE)
3672: AND nvl(l_order_source_doc_id, -99) <> 2 THEN
3673:
3674: IF l_debug_level > 0 THEN
3675: oe_debug_pub.add('Before calling copy payment trxn...');
3676: END IF;
3677:
3678: --For orders coming from outside of Order Management through Process Order API,
3679: --we need to call Oracle Payments Copy Transaction API to get a new transaction

Line 3701: oe_debug_pub.add('After call to copy payment trxn - exception'||sqlerrm);

3697: RAISE FND_API.G_EXC_ERROR;
3698:
3699: WHEN OTHERS THEN
3700: IF l_debug_level>0 THEN
3701: oe_debug_pub.add('After call to copy payment trxn - exception'||sqlerrm);
3702: END IF;
3703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3704: END;
3705: ELSIF p_x_line_payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

Line 3722: oe_debug_pub.add('No change to payments attributes...');

3718: OR (p_x_line_Payment_rec.payment_type_code IN ('CASH','WIRE_TRANSFER')))
3719: THEN
3720: --
3721: IF l_debug_level > 0 THEN
3722: oe_debug_pub.add('No change to payments attributes...');
3723: END IF;
3724: NULL;
3725: --While changing the payment type from cash, check etc to
3726: --credit card payment type, the operation would be update but the

Line 3732: oe_debug_pub.add( 'Inside trxn extension id creation part....');

3728: ELSIF p_x_line_payment_rec.trxn_extension_id IS NULL OR
3729: p_x_line_payment_rec.trxn_extension_id = FND_API.G_MISS_NUM THEN
3730:
3731: IF l_debug_level > 0 THEN
3732: oe_debug_pub.add( 'Inside trxn extension id creation part....');
3733: oe_debug_pub.add(' Operation is UPDATE and Trxn extension id is null...');
3734: oe_debug_pub.add(' Creating a new trxn extension id ');
3735: END IF;
3736:

Line 3733: oe_debug_pub.add(' Operation is UPDATE and Trxn extension id is null...');

3729: p_x_line_payment_rec.trxn_extension_id = FND_API.G_MISS_NUM THEN
3730:
3731: IF l_debug_level > 0 THEN
3732: oe_debug_pub.add( 'Inside trxn extension id creation part....');
3733: oe_debug_pub.add(' Operation is UPDATE and Trxn extension id is null...');
3734: oe_debug_pub.add(' Creating a new trxn extension id ');
3735: END IF;
3736:
3737:

Line 3734: oe_debug_pub.add(' Creating a new trxn extension id ');

3730:
3731: IF l_debug_level > 0 THEN
3732: oe_debug_pub.add( 'Inside trxn extension id creation part....');
3733: oe_debug_pub.add(' Operation is UPDATE and Trxn extension id is null...');
3734: oe_debug_pub.add(' Creating a new trxn extension id ');
3735: END IF;
3736:
3737:
3738: /*l_trx_date := nvl(l_ordered_date, sysdate)

Line 3779: oe_debug_pub.add( 'Before calling create payment trxn....');

3775: l_update_card_flag := 'Y';
3776: END IF;
3777:
3778: IF l_debug_level > 0 THEN
3779: oe_debug_pub.add( 'Before calling create payment trxn....');
3780: oe_debug_pub.add('Update card flag..'||l_update_card_flag);
3781: END IF;
3782:
3783: BEGIN

Line 3780: oe_debug_pub.add('Update card flag..'||l_update_card_flag);

3776: END IF;
3777:
3778: IF l_debug_level > 0 THEN
3779: oe_debug_pub.add( 'Before calling create payment trxn....');
3780: oe_debug_pub.add('Update card flag..'||l_update_card_flag);
3781: END IF;
3782:
3783: BEGIN
3784: OE_PAYMENT_TRXN_UTIL.Create_Payment_TRXN

Line 3808: oe_debug_pub.add('New trxn extension id after calling Create_Payment_TRXN:'||l_trxn_extension_id);

3804: X_msg_data => l_msg_data);
3805:
3806: --p_x_line_payment_rec.trxn_extension_id := l_trxn_extension_id;
3807: IF l_debug_level>0 THEN
3808: oe_debug_pub.add('New trxn extension id after calling Create_Payment_TRXN:'||l_trxn_extension_id);
3809: END IF;
3810: EXCEPTION
3811: WHEN FND_API.G_EXC_ERROR THEN
3812: OE_MSG_PUB.Count_And_Get

Line 3827: oe_debug_pub.add( 'OEXUHPMB: ERROR IN CREATE PAYMENT trxn...'||sqlerrm) ;

3823: );
3824: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
3825: OE_MSG_PUB.ADD;
3826: IF l_debug_level > 0 THEN
3827: oe_debug_pub.add( 'OEXUHPMB: ERROR IN CREATE PAYMENT trxn...'||sqlerrm) ;
3828: oe_debug_pub.add('Error messsge ksurendr'||l_return_status);
3829: END IF;
3830: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3831: END;

Line 3828: oe_debug_pub.add('Error messsge ksurendr'||l_return_status);

3824: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
3825: OE_MSG_PUB.ADD;
3826: IF l_debug_level > 0 THEN
3827: oe_debug_pub.add( 'OEXUHPMB: ERROR IN CREATE PAYMENT trxn...'||sqlerrm) ;
3828: oe_debug_pub.add('Error messsge ksurendr'||l_return_status);
3829: END IF;
3830: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3831: END;
3832: --Trxn extension id exists and an update to some of the

Line 3851: oe_debug_pub.add('Verifying whether to call update card API...');

3847: RAISE FND_API.G_EXC_ERROR;
3848: END IF;
3849: END IF;*/
3850: IF l_debug_level > 0 THEN
3851: oe_debug_pub.add('Verifying whether to call update card API...');
3852: END IF;
3853:
3854: --R12 CC Encryption
3855: --Since the credit card numbers are encrypted, passing both the credit card

Line 3879: oe_debug_pub.add('Before calling update payment trxn...');

3875: p_old_line_Payment_rec.credit_card_expiration_date) THEN
3876: l_update_card_flag := 'Y';
3877: END IF;
3878: IF l_debug_level > 0 THEN
3879: oe_debug_pub.add('Before calling update payment trxn...');
3880: oe_debug_pub.add('Update card flag...'||l_update_card_flag);
3881: END IF;
3882:
3883: --

Line 3880: oe_debug_pub.add('Update card flag...'||l_update_card_flag);

3876: l_update_card_flag := 'Y';
3877: END IF;
3878: IF l_debug_level > 0 THEN
3879: oe_debug_pub.add('Before calling update payment trxn...');
3880: oe_debug_pub.add('Update card flag...'||l_update_card_flag);
3881: END IF;
3882:
3883: -- 3884: --extenstion table>

Line 3909: oe_debug_pub.add('trxn extension id after calling Update_Payment_TRXN:'||p_x_line_payment_rec.trxn_extension_id);

3905: X_msg_data => l_msg_data);
3906:
3907:
3908: IF l_debug_level > 0 THEN
3909: oe_debug_pub.add('trxn extension id after calling Update_Payment_TRXN:'||p_x_line_payment_rec.trxn_extension_id);
3910: oe_debug_pub.add( 'id already derived for this credit card');
3911: END IF;
3912: EXCEPTION
3913: WHEN FND_API.G_EXC_ERROR THEN

Line 3910: oe_debug_pub.add( 'id already derived for this credit card');

3906:
3907:
3908: IF l_debug_level > 0 THEN
3909: oe_debug_pub.add('trxn extension id after calling Update_Payment_TRXN:'||p_x_line_payment_rec.trxn_extension_id);
3910: oe_debug_pub.add( 'id already derived for this credit card');
3911: END IF;
3912: EXCEPTION
3913: WHEN FND_API.G_EXC_ERROR THEN
3914: IF l_debug_level > 0 THEN

Line 3915: oe_debug_pub.add('Update_Payment_TRXN error....exc');

3911: END IF;
3912: EXCEPTION
3913: WHEN FND_API.G_EXC_ERROR THEN
3914: IF l_debug_level > 0 THEN
3915: oe_debug_pub.add('Update_Payment_TRXN error....exc');
3916: oe_debug_pub.add('After call to Update_Payment_TRXN'||l_return_status);
3917: oe_debug_pub.add('Error'||sqlerrm);
3918: END IF;
3919: l_return_status := FND_API.G_RET_STS_ERROR;

Line 3916: oe_debug_pub.add('After call to Update_Payment_TRXN'||l_return_status);

3912: EXCEPTION
3913: WHEN FND_API.G_EXC_ERROR THEN
3914: IF l_debug_level > 0 THEN
3915: oe_debug_pub.add('Update_Payment_TRXN error....exc');
3916: oe_debug_pub.add('After call to Update_Payment_TRXN'||l_return_status);
3917: oe_debug_pub.add('Error'||sqlerrm);
3918: END IF;
3919: l_return_status := FND_API.G_RET_STS_ERROR;
3920: OE_MSG_PUB.Count_And_Get

Line 3917: oe_debug_pub.add('Error'||sqlerrm);

3913: WHEN FND_API.G_EXC_ERROR THEN
3914: IF l_debug_level > 0 THEN
3915: oe_debug_pub.add('Update_Payment_TRXN error....exc');
3916: oe_debug_pub.add('After call to Update_Payment_TRXN'||l_return_status);
3917: oe_debug_pub.add('Error'||sqlerrm);
3918: END IF;
3919: l_return_status := FND_API.G_RET_STS_ERROR;
3920: OE_MSG_PUB.Count_And_Get
3921: ( p_count => l_msg_count,

Line 3928: oe_debug_pub.add('After call to Update_Payment_TRXN --> Unexpected error');

3924: RAISE FND_API.G_EXC_ERROR;
3925:
3926: WHEN OTHERS THEN
3927: IF l_debug_level > 0 THEN
3928: oe_debug_pub.add('After call to Update_Payment_TRXN --> Unexpected error');
3929: oe_debug_pub.add('Error message '||sqlerrm);
3930: END IF;
3931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3932: END;

Line 3929: oe_debug_pub.add('Error message '||sqlerrm);

3925:
3926: WHEN OTHERS THEN
3927: IF l_debug_level > 0 THEN
3928: oe_debug_pub.add('After call to Update_Payment_TRXN --> Unexpected error');
3929: oe_debug_pub.add('Error message '||sqlerrm);
3930: END IF;
3931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3932: END;
3933: END IF;

Line 3939: oe_debug_pub.add( 'Inside trxn extension id creation part....');

3935: --by calling the Create_trxn_extension API.
3936: ELSIF p_x_line_payment_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN --not a copy order Verify
3937:
3938: IF l_debug_level > 0 THEN
3939: oe_debug_pub.add( 'Inside trxn extension id creation part....');
3940: END IF;
3941:
3942:
3943: /*l_trx_date := nvl(l_ordered_date, sysdate)

Line 3980: oe_debug_pub.add( 'Before calling create payment trxn....');

3976: l_update_card_flag := 'Y';
3977: END IF;
3978:
3979: IF l_debug_level > 0 THEN
3980: oe_debug_pub.add( 'Before calling create payment trxn....');
3981: oe_debug_pub.add('Update card flag..'||l_update_card_flag);
3982: END IF;
3983:
3984: --Begin

Line 3981: oe_debug_pub.add('Update card flag..'||l_update_card_flag);

3977: END IF;
3978:
3979: IF l_debug_level > 0 THEN
3980: oe_debug_pub.add( 'Before calling create payment trxn....');
3981: oe_debug_pub.add('Update card flag..'||l_update_card_flag);
3982: END IF;
3983:
3984: --Begin
3985: --IF p_x_line_payment_rec.trxn_extension_id IS NULL THEN

Line 4012: oe_debug_pub.add('New trxn extension id after calling Create_Payment_TRXN:'||l_trxn_extension_id);

4008: X_msg_data => l_msg_data);
4009:
4010: --p_x_line_payment_rec.trxn_extension_id := l_trxn_extension_id;
4011: IF l_debug_level>0 THEN
4012: oe_debug_pub.add('New trxn extension id after calling Create_Payment_TRXN:'||l_trxn_extension_id);
4013: END IF;
4014: Exception
4015: WHEN FND_API.G_EXC_ERROR THEN
4016: OE_MSG_PUB.Count_And_Get

Line 4031: oe_debug_pub.add( 'OEXUHPMB: ERROR IN CREATE PAYMENT trxn...'||sqlerrm) ;

4027: );
4028: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
4029: OE_MSG_PUB.ADD;
4030: IF l_debug_level > 0 THEN
4031: oe_debug_pub.add( 'OEXUHPMB: ERROR IN CREATE PAYMENT trxn...'||sqlerrm) ;
4032: oe_debug_pub.add('Error messsge ksurendr'||l_return_status);
4033: END IF;
4034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4035: end;

Line 4032: oe_debug_pub.add('Error messsge ksurendr'||l_return_status);

4028: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
4029: OE_MSG_PUB.ADD;
4030: IF l_debug_level > 0 THEN
4031: oe_debug_pub.add( 'OEXUHPMB: ERROR IN CREATE PAYMENT trxn...'||sqlerrm) ;
4032: oe_debug_pub.add('Error messsge ksurendr'||l_return_status);
4033: END IF;
4034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4035: end;
4036: END IF; --Operation

Line 4045: oe_debug_pub.add(' Before calling delete payment trxn....');

4041: --For update operation, the trxn extension id of the original
4042: --transaction needs to be deleted if it already exists as
4043: --there is no trxn extension id for check payments.
4044: IF l_debug_level > 0 THEN
4045: oe_debug_pub.add(' Before calling delete payment trxn....');
4046: oe_debug_pub.add(' Trxn extension to delete'||p_old_line_Payment_rec.trxn_extension_id);
4047: oe_debug_pub.add(' Header id '||p_x_line_payment_rec.line_id);
4048: END IF;
4049:

Line 4046: oe_debug_pub.add(' Trxn extension to delete'||p_old_line_Payment_rec.trxn_extension_id);

4042: --transaction needs to be deleted if it already exists as
4043: --there is no trxn extension id for check payments.
4044: IF l_debug_level > 0 THEN
4045: oe_debug_pub.add(' Before calling delete payment trxn....');
4046: oe_debug_pub.add(' Trxn extension to delete'||p_old_line_Payment_rec.trxn_extension_id);
4047: oe_debug_pub.add(' Header id '||p_x_line_payment_rec.line_id);
4048: END IF;
4049:
4050: OE_PAYMENT_TRXN_UTIL.Delete_Payment_Trxn

Line 4047: oe_debug_pub.add(' Header id '||p_x_line_payment_rec.line_id);

4043: --there is no trxn extension id for check payments.
4044: IF l_debug_level > 0 THEN
4045: oe_debug_pub.add(' Before calling delete payment trxn....');
4046: oe_debug_pub.add(' Trxn extension to delete'||p_old_line_Payment_rec.trxn_extension_id);
4047: oe_debug_pub.add(' Header id '||p_x_line_payment_rec.line_id);
4048: END IF;
4049:
4050: OE_PAYMENT_TRXN_UTIL.Delete_Payment_Trxn
4051: (p_header_id => p_x_line_payment_rec.header_id,

Line 4068: oe_debug_pub.add('Successful deletion of trxn extension');

4064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4065: END IF;
4066:
4067: IF l_debug_level > 0 THEN
4068: oe_debug_pub.add('Successful deletion of trxn extension');
4069: oe_debug_pub.add('Return status after delete trxn in pre write process '|| l_return_status);
4070: oe_debug_pub.add('msg data'||l_msg_data);
4071: END IF;
4072:

Line 4069: oe_debug_pub.add('Return status after delete trxn in pre write process '|| l_return_status);

4065: END IF;
4066:
4067: IF l_debug_level > 0 THEN
4068: oe_debug_pub.add('Successful deletion of trxn extension');
4069: oe_debug_pub.add('Return status after delete trxn in pre write process '|| l_return_status);
4070: oe_debug_pub.add('msg data'||l_msg_data);
4071: END IF;
4072:
4073: --Setting the trxn extension id as null as for transactions

Line 4070: oe_debug_pub.add('msg data'||l_msg_data);

4066:
4067: IF l_debug_level > 0 THEN
4068: oe_debug_pub.add('Successful deletion of trxn extension');
4069: oe_debug_pub.add('Return status after delete trxn in pre write process '|| l_return_status);
4070: oe_debug_pub.add('msg data'||l_msg_data);
4071: END IF;
4072:
4073: --Setting the trxn extension id as null as for transactions
4074: --coming from sales order others tab, the trxn extension id would

Line 4082: Oe_debug_pub.add('OEXULPMB.pls - pre_write_process error ');

4078: --R12 CC Encryption
4079: EXCEPTION
4080: WHEN FND_API.G_EXC_ERROR THEN
4081: IF L_DEBUG_LEVEL > 0 THEN
4082: Oe_debug_pub.add('OEXULPMB.pls - pre_write_process error ');
4083: END if;
4084: p_x_line_payment_rec.return_status := FND_API.G_RET_STS_ERROR;
4085: RAISE FND_API.G_EXC_ERROR;
4086: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4088: Oe_debug_pub.add('OEXULPMB.pls - pre_write_process unexpected error ');

4084: p_x_line_payment_rec.return_status := FND_API.G_RET_STS_ERROR;
4085: RAISE FND_API.G_EXC_ERROR;
4086: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4087: IF L_DEBUG_LEVEL > 0 THEN
4088: Oe_debug_pub.add('OEXULPMB.pls - pre_write_process unexpected error ');
4089: END if;
4090: p_x_line_payment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4092: WHEN OTHERS THEN

Line 4094: oe_debug_pub.add('OEXULPMB.pls - pre_write_process unexpected error ');

4090: p_x_line_payment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4092: WHEN OTHERS THEN
4093: if l_debug_level > 0 then
4094: oe_debug_pub.add('OEXULPMB.pls - pre_write_process unexpected error ');
4095: end if;
4096: p_x_line_payment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4098:

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

4114: l_return_status varchar2(30) := NULL;
4115: l_payment_type_code varchar2(30) := null;
4116: l_upd_commitment number := 0;
4117: l_upd_payment number := 0;
4118: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4119:
4120: Begin
4121:
4122:

Line 4156: oe_debug_pub.add('before updating oe_order_headers_all ');

4152:
4153: l_line_rec := l_old_line_rec;
4154:
4155: if l_debug_level > 0 then
4156: oe_debug_pub.add('before updating oe_order_headers_all ');
4157: end if;
4158:
4159: if l_upd_commitment = 1 and l_upd_payment = 1 then
4160:

Line 4162: oe_debug_pub.add('update commitment and payment type ');

4158:
4159: if l_upd_commitment = 1 and l_upd_payment = 1 then
4160:
4161: if l_debug_level > 0 then
4162: oe_debug_pub.add('update commitment and payment type ');
4163: end if;
4164:
4165: update oe_order_lines_all
4166: set payment_type_code = null,

Line 4173: oe_debug_pub.add('update payment type ');

4169:
4170: elsif l_upd_payment = 1 then
4171:
4172: if l_debug_level > 0 then
4173: oe_debug_pub.add('update payment type ');
4174: end if;
4175:
4176: update oe_order_lines_all
4177: set payment_type_code = null

Line 4183: oe_debug_pub.add('update commitment ');

4179:
4180: elsif l_upd_commitment = 1 then
4181:
4182: if l_debug_level > 0 then
4183: oe_debug_pub.add('update commitment ');
4184: end if;
4185:
4186: update oe_order_lines_all
4187: set commitment_id = null