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 1098: oe_debug_pub.add('Old cc number'||p_old_Line_Payment_rec.credit_card_number);

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

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

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

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

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

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

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

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

1216: IF l_booked_flag = 'Y' AND
1217: NOT OE_GLOBALS.Equal(l_cc_flag_old,l_cc_flag_new) THEN
1218:
1219: IF( l_debug_level > 0) THEN
1220: oe_debug_pub.add('l_invoke_credit_checking is: '||l_invoke_credit_checking, 3);
1221: END IF;
1222:
1223: l_invoke_credit_checking := 'Y';
1224:

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

1287:
1288: IF l_payments_update_flag = 'Y' and
1289: OE_PrePayment_UTIL.IS_MULTIPLE_PAYMENTS_ENABLED = TRUE then
1290:
1291: oe_debug_pub.add('logging synch from ULPMB.pls payment delayed request', 1);
1292:
1293: oe_debug_pub.add('line_id is: ' || p_x_Line_Payment_rec.line_id);
1294:
1295: OE_delayed_requests_Pvt.log_request

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

1289: OE_PrePayment_UTIL.IS_MULTIPLE_PAYMENTS_ENABLED = TRUE then
1290:
1291: oe_debug_pub.add('logging synch from ULPMB.pls payment delayed request', 1);
1292:
1293: oe_debug_pub.add('line_id is: ' || p_x_Line_Payment_rec.line_id);
1294:
1295: OE_delayed_requests_Pvt.log_request
1296: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,
1297: p_entity_id => p_x_Line_Payment_rec.line_id,

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

1305: END IF;
1306:
1307: IF l_calculate_commitment_flag = 'Y' THEN
1308: IF l_debug_level > 0 then
1309: oe_debug_pub.add('OEXULPMB: Logging delayed request for Commitment.', 1);
1310: END IF;
1311:
1312: OE_Delayed_Requests_Pvt.Log_Request(
1313: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,

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

1321: --bug3625027 start
1322: IF l_invoke_credit_checking = 'Y'
1323: AND OE_PrePayment_UTIL.IS_MULTIPLE_PAYMENTS_ENABLED = TRUE THEN
1324: IF( l_debug_level > 0) THEN
1325: oe_debug_pub.add('pviprana: logging a new payment delayed request for processing the payment', 1);
1326: oe_debug_pub.add('line_id is: ' || p_x_Line_Payment_rec.line_id);
1327: END IF;
1328: OE_delayed_requests_Pvt.log_request
1329: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,

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

1322: IF l_invoke_credit_checking = 'Y'
1323: AND OE_PrePayment_UTIL.IS_MULTIPLE_PAYMENTS_ENABLED = TRUE THEN
1324: IF( l_debug_level > 0) THEN
1325: oe_debug_pub.add('pviprana: logging a new payment delayed request for processing the payment', 1);
1326: oe_debug_pub.add('line_id is: ' || p_x_Line_Payment_rec.line_id);
1327: END IF;
1328: OE_delayed_requests_Pvt.log_request
1329: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,
1330: p_entity_id => p_x_Line_Payment_rec.header_id,

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

1337: --bug3625027 end
1338:
1339: IF l_delete_pmt_hold = 'Y' THEN
1340: IF l_debug_level > 0 then
1341: oe_debug_pub.add('OEXULPMB: Logging delayed request for Delete_Payment_Hold.', 3);
1342: END IF;
1343:
1344: OE_delayed_requests_Pvt.log_request
1345: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,

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

1352: x_return_status => l_return_status);
1353: END IF;
1354:
1355:
1356: oe_debug_pub.add('OEXULPMB.pls : exiting apply attribute changes');
1357:
1358: --ER#7479609 start
1359: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_type_code,p_old_Line_Payment_rec.payment_type_code)
1360: THEN

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

1357:
1358: --ER#7479609 start
1359: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_type_code,p_old_Line_Payment_rec.payment_type_code)
1360: THEN
1361: oe_debug_pub.add('logging Delayed request for evaluation of payments hold', 1);
1362:
1363: OE_delayed_requests_Pvt.log_request
1364: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,
1365: p_entity_id => p_x_Line_Payment_rec.line_id,

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

1381: , p_old_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type
1382: )
1383: IS
1384: --
1385: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1386: --
1387: BEGIN
1388:
1389: IF p_x_Line_Payment_rec.attribute1 = FND_API.G_MISS_CHAR THEN

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

1598: )
1599: IS
1600:
1601: --
1602: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1603: --
1604: BEGIN
1605:
1606: IF p_x_Line_Payment_rec.attribute1 = FND_API.G_MISS_CHAR THEN

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

1815: l_return_status VARCHAR2(1);
1816:
1817:
1818: --
1819: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1820: --
1821: BEGIN
1822:
1823: SELECT lock_control

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

1832: --calling notification framework to update global picture
1833: --check code release level first. Notification framework is at Pack H level
1834: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
1835: IF l_debug_level > 0 THEN
1836: oe_debug_pub.add( 'JFC: payment_number' || P_LINE_Payment_REC.payment_number ) ;
1837: END IF;
1838: -- Sasi: this should be added by Renga
1839: /* OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
1840: p_Line_pmt_rec =>p_line_Payment_rec,

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

1841: p_line_pmt_id => p_line_Payment_rec.payment_number,
1842: x_index => l_index,
1843: x_return_status => l_return_status); */
1844: IF l_debug_level > 0 THEN
1845: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_PAYMENT_UTIL.UPDATE_ROW IS: ' || L_RETURN_STATUS ) ;
1846: END IF;
1847: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1848: IF l_debug_level > 0 THEN
1849: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;

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

1845: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_PAYMENT_UTIL.UPDATE_ROW IS: ' || L_RETURN_STATUS ) ;
1846: END IF;
1847: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1848: IF l_debug_level > 0 THEN
1849: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
1850: END IF;
1851: IF l_debug_level > 0 THEN
1852: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.UPDATE_ROW' , 1 ) ;
1853: END IF;

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

1848: IF l_debug_level > 0 THEN
1849: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
1850: END IF;
1851: IF l_debug_level > 0 THEN
1852: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.UPDATE_ROW' , 1 ) ;
1853: END IF;
1854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1855: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1856: IF l_debug_level > 0 THEN

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

1853: END IF;
1854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1855: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1856: IF l_debug_level > 0 THEN
1857: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_PAYMENT_UTIL.UPDATE_ROW' ) ;
1858: END IF;
1859: IF l_debug_level > 0 THEN
1860: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.UPDATE_ROW' , 1 ) ;
1861: END IF;

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

1856: IF l_debug_level > 0 THEN
1857: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_PAYMENT_UTIL.UPDATE_ROW' ) ;
1858: END IF;
1859: IF l_debug_level > 0 THEN
1860: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.UPDATE_ROW' , 1 ) ;
1861: END IF;
1862: RAISE FND_API.G_EXC_ERROR;
1863: END IF;
1864: END IF; /*code_release_level*/

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

1947: l_index NUMBER;
1948: l_return_status VARCHAR2(1);
1949: l_transaction_phase_code VARCHAR2(30);
1950: --
1951: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1952: --
1953: BEGIN
1954: IF l_debug_level > 0 THEN
1955: oe_debug_pub.add( 'ENTERING OE_LINE_PAYMENT_UTIL.INSERT_ROW' , 1 ) ;

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

1951: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1952: --
1953: BEGIN
1954: IF l_debug_level > 0 THEN
1955: oe_debug_pub.add( 'ENTERING OE_LINE_PAYMENT_UTIL.INSERT_ROW' , 1 ) ;
1956: END IF;
1957:
1958: -- QUOTING change
1959: -- No need to insert commitment for orders in negotiation phase

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

1969: null;
1970: END;
1971:
1972: if l_debug_level > 0 then
1973: oe_debug_pub.add('trxn phase :'||l_transaction_phase_code);
1974: end if;
1975: IF nvl(l_transaction_phase_code, 'F') = 'N' THEN
1976: RETURN;
1977: END IF;

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

2094: p_lin_pmt_id => p_line_Payment_rec.payment_number,
2095: x_index => l_index,
2096: x_return_status => l_return_status); */
2097: IF l_debug_level > 0 THEN
2098: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_PAYMENT_UTIL.INSERT_ROW IS: ' || L_RETURN_STATUS ) ;
2099: END IF;
2100: IF l_debug_level > 0 THEN
2101: oe_debug_pub.add( 'RETURNED INDEX IS: ' || L_INDEX , 1 ) ;
2102: END IF;

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

2097: IF l_debug_level > 0 THEN
2098: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_PAYMENT_UTIL.INSERT_ROW IS: ' || L_RETURN_STATUS ) ;
2099: END IF;
2100: IF l_debug_level > 0 THEN
2101: oe_debug_pub.add( 'RETURNED INDEX IS: ' || L_INDEX , 1 ) ;
2102: END IF;
2103:
2104: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2105: IF l_debug_level > 0 THEN

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

2102: END IF;
2103:
2104: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2105: IF l_debug_level > 0 THEN
2106: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2107: END IF;
2108: IF l_debug_level > 0 THEN
2109: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.INSERT_ROW' , 1 ) ;
2110: END IF;

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

2105: IF l_debug_level > 0 THEN
2106: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2107: END IF;
2108: IF l_debug_level > 0 THEN
2109: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.INSERT_ROW' , 1 ) ;
2110: END IF;
2111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2112: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2113: IF l_debug_level > 0 THEN

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

2110: END IF;
2111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2112: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2113: IF l_debug_level > 0 THEN
2114: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_PAYMENT_UTIL.INSERT_ROW' ) ;
2115: END IF;
2116: IF l_debug_level > 0 THEN
2117: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.INSERT_ROW' , 1 ) ;
2118: END IF;

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

2113: IF l_debug_level > 0 THEN
2114: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_PAYMENT_UTIL.INSERT_ROW' ) ;
2115: END IF;
2116: IF l_debug_level > 0 THEN
2117: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.INSERT_ROW' , 1 ) ;
2118: END IF;
2119: RAISE FND_API.G_EXC_ERROR;
2120: END IF;
2121: END IF; /*code_release_level*/

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

2121: END IF; /*code_release_level*/
2122: -- notification framework end
2123:
2124: IF l_debug_level > 0 THEN
2125: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.INSERT_ROW' , 1 ) ;
2126: END IF;
2127:
2128: EXCEPTION
2129:

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

2171: -- added for notification framework
2172: l_new_line_Payment_rec OE_Order_PUB.Line_Payment_Rec_Type;
2173: l_index NUMBER;
2174: --
2175: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2176: --
2177: BEGIN
2178: IF l_debug_level > 0 THEN
2179: oe_debug_pub.add( 'ENTERING OE_LINE_PAYMENT_UTIL.DELETE_ROW' , 1 ) ;

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

2175: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2176: --
2177: BEGIN
2178: IF l_debug_level > 0 THEN
2179: oe_debug_pub.add( 'ENTERING OE_LINE_PAYMENT_UTIL.DELETE_ROW' , 1 ) ;
2180: END IF;
2181:
2182: IF p_line_id <> FND_API.G_MISS_NUM AND
2183: nvl(p_payment_number, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM

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

2206: from oe_order_lines_all where
2207: header_id = p_header_id
2208: and line_id = p_line_id;
2209: IF l_debug_level > 0 THEN
2210: oe_debug_pub.add('Deleting trxn id...'||l_trxn_extension_id);
2211: oe_debug_pub.add('Invoice to org.'||l_invoice_to_org_id);
2212: END IF;
2213:
2214: OE_PAYMENT_TRXN_UTIL.Delete_Payment_Trxn

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

2207: header_id = p_header_id
2208: and line_id = p_line_id;
2209: IF l_debug_level > 0 THEN
2210: oe_debug_pub.add('Deleting trxn id...'||l_trxn_extension_id);
2211: oe_debug_pub.add('Invoice to org.'||l_invoice_to_org_id);
2212: END IF;
2213:
2214: OE_PAYMENT_TRXN_UTIL.Delete_Payment_Trxn
2215: (p_header_id => p_header_id,

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

2222: x_msg_data => l_msg_data);
2223:
2224: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2225: IF l_debug_level > 0 THEN
2226: oe_debug_pub.add( 'Delete Payment at OE_LINE_Payment_UTIL.DELETE_ROW - UNEXPECTED ERROR' ) ;
2227: oe_debug_pub.add('Error message'||sqlerrm);
2228: oe_debug_pub.add('Msg data'||l_msg_data);
2229: END IF;
2230: IF l_debug_level > 0 THEN

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

2223:
2224: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2225: IF l_debug_level > 0 THEN
2226: oe_debug_pub.add( 'Delete Payment at OE_LINE_Payment_UTIL.DELETE_ROW - UNEXPECTED ERROR' ) ;
2227: oe_debug_pub.add('Error message'||sqlerrm);
2228: oe_debug_pub.add('Msg data'||l_msg_data);
2229: END IF;
2230: IF l_debug_level > 0 THEN
2231: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;

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

2224: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2225: IF l_debug_level > 0 THEN
2226: oe_debug_pub.add( 'Delete Payment at OE_LINE_Payment_UTIL.DELETE_ROW - UNEXPECTED ERROR' ) ;
2227: oe_debug_pub.add('Error message'||sqlerrm);
2228: oe_debug_pub.add('Msg data'||l_msg_data);
2229: END IF;
2230: IF l_debug_level > 0 THEN
2231: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2232: END IF;

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

2227: oe_debug_pub.add('Error message'||sqlerrm);
2228: oe_debug_pub.add('Msg data'||l_msg_data);
2229: END IF;
2230: IF l_debug_level > 0 THEN
2231: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2232: END IF;
2233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2234: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2235: IF l_debug_level > 0 THEN

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

2232: END IF;
2233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2234: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2235: IF l_debug_level > 0 THEN
2236: oe_debug_pub.add( 'Delete Payment at OE_LINE_Payment_UTIL.DELETE_ROW' ) ;
2237: oe_debug_pub.add('Error message'||sqlerrm);
2238: oe_debug_pub.add('Msg data'||l_msg_data);
2239: END IF;
2240: IF l_debug_level > 0 THEN

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

2233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2234: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2235: IF l_debug_level > 0 THEN
2236: oe_debug_pub.add( 'Delete Payment at OE_LINE_Payment_UTIL.DELETE_ROW' ) ;
2237: oe_debug_pub.add('Error message'||sqlerrm);
2238: oe_debug_pub.add('Msg data'||l_msg_data);
2239: END IF;
2240: IF l_debug_level > 0 THEN
2241: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;

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

2234: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2235: IF l_debug_level > 0 THEN
2236: oe_debug_pub.add( 'Delete Payment at OE_LINE_Payment_UTIL.DELETE_ROW' ) ;
2237: oe_debug_pub.add('Error message'||sqlerrm);
2238: oe_debug_pub.add('Msg data'||l_msg_data);
2239: END IF;
2240: IF l_debug_level > 0 THEN
2241: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2242: END IF;

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

2237: oe_debug_pub.add('Error message'||sqlerrm);
2238: oe_debug_pub.add('Msg data'||l_msg_data);
2239: END IF;
2240: IF l_debug_level > 0 THEN
2241: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2242: END IF;
2243: RAISE FND_API.G_EXC_ERROR;
2244: END IF;
2245: END IF;

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

2251: p_lin_pmt_id => l_pmt.payment_number,
2252: x_index => l_index,
2253: x_return_status => l_return_status);
2254: IF l_debug_level > 0 THEN
2255: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_PAYMENT_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
2256: END IF;
2257: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2258: IF l_debug_level > 0 THEN
2259: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;

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

2255: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_PAYMENT_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
2256: END IF;
2257: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2258: IF l_debug_level > 0 THEN
2259: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2260: END IF;
2261: IF l_debug_level > 0 THEN
2262: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.DELETE_ROW' , 1 ) ;
2263: END IF;

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

2258: IF l_debug_level > 0 THEN
2259: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2260: END IF;
2261: IF l_debug_level > 0 THEN
2262: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.DELETE_ROW' , 1 ) ;
2263: END IF;
2264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2265: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2266: IF l_debug_level > 0 THEN

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

2263: END IF;
2264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2265: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2266: IF l_debug_level > 0 THEN
2267: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_PAYMENT_UTIL.DELETE_ROW' ) ;
2268: END IF;
2269: IF l_debug_level > 0 THEN
2270: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.DELETE_ROW' , 1 ) ;
2271: END IF;

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

2266: IF l_debug_level > 0 THEN
2267: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_PAYMENT_UTIL.DELETE_ROW' ) ;
2268: END IF;
2269: IF l_debug_level > 0 THEN
2270: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.DELETE_ROW' , 1 ) ;
2271: END IF;
2272: RAISE FND_API.G_EXC_ERROR;
2273: END IF;*/
2274: END IF; /*code_release_level*/

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

2287: AND HEADER_ID = p_header_id;
2288:
2289: --3382262
2290: IF l_debug_level > 0 THEN
2291: oe_debug_pub.add('1: after executing delete statement against oe_payments - before delete_payment_at_line');
2292: END IF;
2293:
2294:
2295: Delete_Payment_at_line(p_line_id => p_line_id,

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

2299: x_msg_data => l_msg_data);
2300:
2301: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2302: IF l_debug_level > 0 THEN
2303: oe_debug_pub.add( 'Delete Payment at Line - UNEXPECTED ERROR' ) ;
2304: END IF;
2305: IF l_debug_level > 0 THEN
2306: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2307: END IF;

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

2302: IF l_debug_level > 0 THEN
2303: oe_debug_pub.add( 'Delete Payment at Line - UNEXPECTED ERROR' ) ;
2304: END IF;
2305: IF l_debug_level > 0 THEN
2306: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2307: END IF;
2308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2309: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2310: IF l_debug_level > 0 THEN

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

2307: END IF;
2308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2309: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2310: IF l_debug_level > 0 THEN
2311: oe_debug_pub.add( 'Delete Payment at Line - OE_LINE_Payment_UTIL.DELETE_ROW' ) ;
2312: END IF;
2313: IF l_debug_level > 0 THEN
2314: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2315: END IF;

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

2310: IF l_debug_level > 0 THEN
2311: oe_debug_pub.add( 'Delete Payment at Line - OE_LINE_Payment_UTIL.DELETE_ROW' ) ;
2312: END IF;
2313: IF l_debug_level > 0 THEN
2314: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2315: END IF;
2316: RAISE FND_API.G_EXC_ERROR;
2317: END IF;
2318: --3382262

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

2317: END IF;
2318: --3382262
2319:
2320: IF l_debug_level > 0 THEN
2321: oe_debug_pub.add( 'Releasing line level authorization hold.' , 3 ) ;
2322: END IF;
2323: OE_Verify_Payment_PUB.Release_Verify_Line_Hold
2324: ( p_header_id => p_header_id
2325: , p_line_id => p_line_id

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

2366: END IF;
2367: --ER#7479609 end
2368:
2369: IF l_debug_level > 0 THEN
2370: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_PAYMENT_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
2371: END IF;
2372:
2373: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2374: IF l_debug_level > 0 THEN

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

2371: END IF;
2372:
2373: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2374: IF l_debug_level > 0 THEN
2375: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2376: END IF;
2377: IF l_debug_level > 0 THEN
2378: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.DELETE_ROW' , 1 ) ;
2379: END IF;

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

2374: IF l_debug_level > 0 THEN
2375: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2376: END IF;
2377: IF l_debug_level > 0 THEN
2378: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.DELETE_ROW' , 1 ) ;
2379: END IF;
2380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2381: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2382: IF l_debug_level > 0 THEN

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

2379: END IF;
2380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2381: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2382: IF l_debug_level > 0 THEN
2383: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_PAYMENT_UTIL.DELETE_ROW' ) ;
2384: END IF;
2385: IF l_debug_level > 0 THEN
2386: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.DELETE_ROW' , 1 ) ;
2387: END IF;

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

2382: IF l_debug_level > 0 THEN
2383: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_PAYMENT_UTIL.DELETE_ROW' ) ;
2384: END IF;
2385: IF l_debug_level > 0 THEN
2386: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.DELETE_ROW' , 1 ) ;
2387: END IF;
2388: RAISE FND_API.G_EXC_ERROR;
2389: END IF;
2390: END IF; /*code_release_level*/

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

2415:
2416: Exception
2417: when no_data_found then
2418:
2419: oe_debug_pub.add('ULPMB.pls: delete_row - could not find the row');
2420: Raise;
2421: when too_many_rows then
2422: oe_debug_pub.add('ULPMB.pls : delete row - too many rows - should not happen');
2423: Raise;

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

2418:
2419: oe_debug_pub.add('ULPMB.pls: delete_row - could not find the row');
2420: Raise;
2421: when too_many_rows then
2422: oe_debug_pub.add('ULPMB.pls : delete row - too many rows - should not happen');
2423: Raise;
2424: End;
2425:
2426: END;

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

2435: select invoice_to_org_id into l_invoice_to_org_id
2436: from oe_order_lines_all where header_id = p_header_id
2437: and line_id = p_line_id;
2438: IF l_debug_level > 0 THEN
2439: oe_debug_pub.add('Deleting trxn id...'||l_trxn_extension_id);
2440: oe_debug_pub.add('Invoice to org.'||l_invoice_to_org_id);
2441: END IF;
2442:
2443: OE_PAYMENT_TRXN_UTIL.Delete_Payment_Trxn

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

2436: from oe_order_lines_all where header_id = p_header_id
2437: and line_id = p_line_id;
2438: IF l_debug_level > 0 THEN
2439: oe_debug_pub.add('Deleting trxn id...'||l_trxn_extension_id);
2440: oe_debug_pub.add('Invoice to org.'||l_invoice_to_org_id);
2441: END IF;
2442:
2443: OE_PAYMENT_TRXN_UTIL.Delete_Payment_Trxn
2444: (p_header_id => p_header_id,

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

2452:
2453:
2454: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2455: IF l_debug_level > 0 THEN
2456: oe_debug_pub.add( '2:Delete Payment OE_LINE_Payment_UTIL.DELETE_ROW - UNEXPECTED ERROR' ) ;
2457: END IF;
2458: IF l_debug_level > 0 THEN
2459: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2460: END IF;

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

2455: IF l_debug_level > 0 THEN
2456: oe_debug_pub.add( '2:Delete Payment OE_LINE_Payment_UTIL.DELETE_ROW - UNEXPECTED ERROR' ) ;
2457: END IF;
2458: IF l_debug_level > 0 THEN
2459: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2460: END IF;
2461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2462: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2463: IF l_debug_level > 0 THEN

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

2460: END IF;
2461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2462: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2463: IF l_debug_level > 0 THEN
2464: oe_debug_pub.add( '2:Delete Payment OE_LINE_Payment_UTIL.DELETE_ROW' ) ;
2465: END IF;
2466: IF l_debug_level > 0 THEN
2467: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2468: END IF;

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

2463: IF l_debug_level > 0 THEN
2464: oe_debug_pub.add( '2:Delete Payment OE_LINE_Payment_UTIL.DELETE_ROW' ) ;
2465: END IF;
2466: IF l_debug_level > 0 THEN
2467: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2468: END IF;
2469: RAISE FND_API.G_EXC_ERROR;
2470: END IF;
2471: END IF;

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

2478: ;
2479:
2480: --3382262
2481: IF l_debug_level > 0 THEN
2482: oe_debug_pub.add('2: after executing delete statement against oe_payments - before delete_payment_at_line');
2483: END IF;
2484:
2485:
2486: Delete_Payment_at_line(p_line_id => p_line_id,

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

2492: x_msg_data => l_msg_data);
2493:
2494: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2495: IF l_debug_level > 0 THEN
2496: oe_debug_pub.add( 'Delete Payment at Line - UNEXPECTED ERROR' ) ;
2497: END IF;
2498: IF l_debug_level > 0 THEN
2499: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2500: END IF;

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

2495: IF l_debug_level > 0 THEN
2496: oe_debug_pub.add( 'Delete Payment at Line - UNEXPECTED ERROR' ) ;
2497: END IF;
2498: IF l_debug_level > 0 THEN
2499: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2500: END IF;
2501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2502: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2503: IF l_debug_level > 0 THEN

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

2500: END IF;
2501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2502: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2503: IF l_debug_level > 0 THEN
2504: oe_debug_pub.add( 'Delete Payment at Line - OE_LINE_Payment_UTIL.DELETE_ROW' ) ;
2505: END IF;
2506: IF l_debug_level > 0 THEN
2507: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2508: END IF;

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

2503: IF l_debug_level > 0 THEN
2504: oe_debug_pub.add( 'Delete Payment at Line - OE_LINE_Payment_UTIL.DELETE_ROW' ) ;
2505: END IF;
2506: IF l_debug_level > 0 THEN
2507: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2508: END IF;
2509: RAISE FND_API.G_EXC_ERROR;
2510: END IF;
2511: --3382262

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

2511: --3382262
2512:
2513: IF p_payment_type_code = 'CREDIT_CARD' THEN
2514: IF l_debug_level > 0 THEN
2515: oe_debug_pub.add( 'Releasing line level authorization hold.' , 3 ) ;
2516: END IF;
2517: OE_Verify_Payment_PUB.Release_Verify_Line_Hold
2518: ( p_header_id => p_header_id
2519: , p_line_id => p_line_id

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

2614: AND HEADER_ID = p_header_id
2615: );
2616:
2617: --
2618: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2619: --
2620: --R12 CC Encryption Verify
2621: x_bank_account_number VARCHAR2(100); --bug 5170754
2622: x_check_number varchar2(100);

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

2822: AND HEADER_ID = p_header_id
2823: ;
2824:
2825: --
2826: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2827: --
2828: --R12 CC Encryption Verify
2829: x_bank_account_number VARCHAR2(100); --bug 5170754
2830: x_check_number varchar2(100);

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

2956: l_header_id NUMBER;
2957: l_Line_Payment_rec OE_Order_PUB.Line_Payment_Rec_Type;
2958: l_lock_control NUMBER;
2959: --
2960: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2961: --
2962: BEGIN
2963:
2964: IF l_debug_level > 0 THEN

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

2961: --
2962: BEGIN
2963:
2964: IF l_debug_level > 0 THEN
2965: oe_debug_pub.add( 'ENTERING OE_LINE_PAYMENT_UTIL.LOCK_ROW' , 1 ) ;
2966: END IF;
2967:
2968: SAVEPOINT Lock_Row;
2969:

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

2989: AND header_id = l_header_id
2990: FOR UPDATE NOWAIT;
2991:
2992: IF l_debug_level > 0 THEN
2993: oe_debug_pub.add( 'SELECTED FOR UPDATE' , 1 ) ;
2994: END IF;
2995:
2996: OE_Line_Payment_Util.Query_Row
2997: (p_payment_number => l_payment_number

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

3109: FOR UPDATE NOWAIT;
3110:
3111: l_payment_number NUMBER;
3112: --
3113: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3114: --
3115: BEGIN
3116:
3117: IF l_debug_level > 0 THEN

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

3114: --
3115: BEGIN
3116:
3117: IF l_debug_level > 0 THEN
3118: oe_debug_pub.add( 'ENTERING OE_HEADER_PaymentS_UTIL.LOCK_ROWS' , 1 ) ;
3119: END IF;
3120: /*
3121: IF (p_payment_number IS NOT NULL AND
3122: p_payment_number <> FND_API.G_MISS_NUM) AND

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

3188:
3189: x_return_status := FND_API.G_RET_STS_SUCCESS;
3190:
3191: IF l_debug_level > 0 THEN
3192: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENTS_UTIL.LOCK_ROWS' , 1 ) ;
3193: END IF;
3194:
3195: EXCEPTION
3196: WHEN NO_DATA_FOUND THEN

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

3236: )RETURN OE_Order_PUB.Line_Payment_Val_Rec_Type
3237: IS
3238: l_Line_Payment_val_rec OE_Order_PUB.Line_Payment_Val_Rec_Type;
3239: --
3240: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3241: --
3242: BEGIN
3243:
3244: IF (p_Line_Payment_rec.payment_collection_event IS NULL OR

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

3283: )
3284: IS
3285:
3286: --
3287: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3288: --
3289: BEGIN
3290:
3291: -- initialize return_status.

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

3413: --
3414: l_new_commitment_bal NUMBER;
3415: l_commitment VARCHAR2(20);
3416: --
3417: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3418: --
3419: --R12 CC Encryption
3420: l_order_source_doc_id NUMBER;
3421: l_trxn_extension_id NUMBER;

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

3428:
3429: BEGIN
3430:
3431: IF l_debug_level > 0 THEN
3432: oe_debug_pub.add( 'entering oe_line_payment_util.Pre_Write_Process. payment_type_code'||p_x_line_Payment_rec.payment_type_code);
3433: END IF;
3434:
3435:
3436: --bug 3560198

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

3435:
3436: --bug 3560198
3437: IF p_x_line_Payment_rec.payment_type_code = 'COMMITMENT' THEN
3438: IF l_debug_level > 0 THEN
3439: oe_debug_pub.add('To log commitment balance message');
3440: END IF;
3441: BEGIN
3442: -- QUOTING change
3443: SELECT l.transaction_phase_code

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

3452: END;
3453: -- QUOTING change
3454: -- No need to calculate commitment for orders in negotiation phase
3455: if l_debug_level > 0 then
3456: oe_debug_pub.add('trxn phase :'||l_transaction_phase_code);
3457: end if;
3458: IF l_transaction_phase_code = 'N' THEN
3459: RETURN;
3460: END IF;

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

3480: );
3481: END IF;
3482:
3483: IF l_debug_level > 0 THEN
3484: oe_debug_pub.add('payment_trx_id : '||p_x_line_Payment_rec.payment_trx_id);
3485: END IF;
3486: IF p_x_line_Payment_rec.payment_trx_id IS NOT NULL THEN
3487: l_class := NULL;
3488: l_so_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE');

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

3493: ,l_so_source_code
3494: ,l_oe_installed_flag );
3495: END IF;
3496: IF l_debug_level > 0 THEN
3497: oe_debug_pub.add( 'COMMITMENT BALANCE IS: '||L_COMMITMENT_BAL ) ;
3498: END IF;
3499: IF p_x_line_Payment_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
3500: l_new_commitment_bal := l_commitment_bal - p_x_line_Payment_rec.commitment_applied_amount;
3501: ELSIF p_x_line_Payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

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

3501: ELSIF p_x_line_Payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3502: l_new_commitment_bal := l_commitment_bal + p_old_line_Payment_rec.commitment_applied_amount - p_x_line_Payment_rec.commitment_applied_amount;
3503: END IF;
3504: IF l_debug_level > 0 THEN
3505: oe_debug_pub.add('l_new_commitment_bal : '||l_new_commitment_bal);
3506: END IF;
3507: -- Added if condition of the Bug #3742103
3508: IF l_new_commitment_bal IS NOT NULL THEN
3509: FND_MESSAGE.Set_Name('ONT','OE_COM_BALANCE');

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

3557: l_ordered_date := OE_Order_Cache.g_header_rec.ordered_date;
3558: l_transactional_curr_code := OE_Order_Cache.g_header_rec.transactional_curr_code;
3559:
3560: IF l_debug_level > 0 THEN
3561: oe_debug_pub.add( 'l_transactional_curr_code:'||l_transactional_curr_code||':l_invoice_to_org_id:'||l_invoice_to_org_id);
3562: END IF;
3563:
3564: BEGIN
3565: SELECT customer_id

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

3568: WHERE organization_id = l_invoice_to_org_id;
3569: EXCEPTION
3570: WHEN OTHERS THEN
3571: IF l_debug_level > 0 THEN
3572: oe_debug_pub.add( 'IN OTHERS EXCEPTION ( OE_INVOICE_TO_ORGS_V ) '||SQLERRM , 1 ) ;
3573: END IF;
3574: END;
3575: IF l_debug_level > 0 THEN
3576: oe_debug_pub.add('invoice to cust id : ' || l_hdr_inv_to_cust_id );

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

3572: oe_debug_pub.add( 'IN OTHERS EXCEPTION ( OE_INVOICE_TO_ORGS_V ) '||SQLERRM , 1 ) ;
3573: END IF;
3574: END;
3575: IF l_debug_level > 0 THEN
3576: oe_debug_pub.add('invoice to cust id : ' || l_hdr_inv_to_cust_id );
3577: oe_debug_pub.add('cc number : ' || p_x_line_Payment_rec.credit_card_number );
3578: oe_debug_pub.add('cc name : ' || p_x_line_Payment_rec.credit_card_holder_name );
3579: oe_debug_pub.add('exp date : ' || to_char(p_x_line_Payment_rec.credit_card_expiration_date, 'DD-MON-YYYY') );
3580: oe_debug_pub.add('instr id...'||p_x_line_Payment_rec.cc_instrument_id);

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

3573: END IF;
3574: END;
3575: IF l_debug_level > 0 THEN
3576: oe_debug_pub.add('invoice to cust id : ' || l_hdr_inv_to_cust_id );
3577: oe_debug_pub.add('cc number : ' || p_x_line_Payment_rec.credit_card_number );
3578: oe_debug_pub.add('cc name : ' || p_x_line_Payment_rec.credit_card_holder_name );
3579: oe_debug_pub.add('exp date : ' || to_char(p_x_line_Payment_rec.credit_card_expiration_date, 'DD-MON-YYYY') );
3580: oe_debug_pub.add('instr id...'||p_x_line_Payment_rec.cc_instrument_id);
3581: oe_debug_pub.add('instr assgn id'||p_x_line_Payment_rec.cc_instrument_assignment_id);

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

3574: END;
3575: IF l_debug_level > 0 THEN
3576: oe_debug_pub.add('invoice to cust id : ' || l_hdr_inv_to_cust_id );
3577: oe_debug_pub.add('cc number : ' || p_x_line_Payment_rec.credit_card_number );
3578: oe_debug_pub.add('cc name : ' || p_x_line_Payment_rec.credit_card_holder_name );
3579: oe_debug_pub.add('exp date : ' || to_char(p_x_line_Payment_rec.credit_card_expiration_date, 'DD-MON-YYYY') );
3580: oe_debug_pub.add('instr id...'||p_x_line_Payment_rec.cc_instrument_id);
3581: oe_debug_pub.add('instr assgn id'||p_x_line_Payment_rec.cc_instrument_assignment_id);
3582: END IF;

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

3575: IF l_debug_level > 0 THEN
3576: oe_debug_pub.add('invoice to cust id : ' || l_hdr_inv_to_cust_id );
3577: oe_debug_pub.add('cc number : ' || p_x_line_Payment_rec.credit_card_number );
3578: oe_debug_pub.add('cc name : ' || p_x_line_Payment_rec.credit_card_holder_name );
3579: oe_debug_pub.add('exp date : ' || to_char(p_x_line_Payment_rec.credit_card_expiration_date, 'DD-MON-YYYY') );
3580: oe_debug_pub.add('instr id...'||p_x_line_Payment_rec.cc_instrument_id);
3581: oe_debug_pub.add('instr assgn id'||p_x_line_Payment_rec.cc_instrument_assignment_id);
3582: END IF;
3583:

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

3576: oe_debug_pub.add('invoice to cust id : ' || l_hdr_inv_to_cust_id );
3577: oe_debug_pub.add('cc number : ' || p_x_line_Payment_rec.credit_card_number );
3578: oe_debug_pub.add('cc name : ' || p_x_line_Payment_rec.credit_card_holder_name );
3579: oe_debug_pub.add('exp date : ' || to_char(p_x_line_Payment_rec.credit_card_expiration_date, 'DD-MON-YYYY') );
3580: oe_debug_pub.add('instr id...'||p_x_line_Payment_rec.cc_instrument_id);
3581: oe_debug_pub.add('instr assgn id'||p_x_line_Payment_rec.cc_instrument_assignment_id);
3582: END IF;
3583:
3584: Select SOURCE_DOCUMENT_TYPE_ID

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

3577: oe_debug_pub.add('cc number : ' || p_x_line_Payment_rec.credit_card_number );
3578: oe_debug_pub.add('cc name : ' || p_x_line_Payment_rec.credit_card_holder_name );
3579: oe_debug_pub.add('exp date : ' || to_char(p_x_line_Payment_rec.credit_card_expiration_date, 'DD-MON-YYYY') );
3580: oe_debug_pub.add('instr id...'||p_x_line_Payment_rec.cc_instrument_id);
3581: oe_debug_pub.add('instr assgn id'||p_x_line_Payment_rec.cc_instrument_assignment_id);
3582: END IF;
3583:
3584: Select SOURCE_DOCUMENT_TYPE_ID
3585: Into l_order_source_doc_id

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

3593: AND (p_x_line_payment_rec.operation = OE_GLOBALS.G_OPR_CREATE)
3594: AND nvl(l_order_source_doc_id, -99) <> 2 THEN
3595:
3596: IF l_debug_level > 0 THEN
3597: oe_debug_pub.add('Before calling copy payment trxn...');
3598: END IF;
3599:
3600: --For orders coming from outside of Order Management through Process Order API,
3601: --we need to call Oracle Payments Copy Transaction API to get a new transaction

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

3619: RAISE FND_API.G_EXC_ERROR;
3620:
3621: WHEN OTHERS THEN
3622: IF l_debug_level>0 THEN
3623: oe_debug_pub.add('After call to copy payment trxn - exception'||sqlerrm);
3624: END IF;
3625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3626: END;
3627: ELSIF p_x_line_payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

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

3640: OR (p_x_line_Payment_rec.payment_type_code IN ('CASH','WIRE_TRANSFER')))
3641: THEN
3642: --
3643: IF l_debug_level > 0 THEN
3644: oe_debug_pub.add('No change to payments attributes...');
3645: END IF;
3646: NULL;
3647: --While changing the payment type from cash, check etc to
3648: --credit card payment type, the operation would be update but the

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

3650: ELSIF p_x_line_payment_rec.trxn_extension_id IS NULL OR
3651: p_x_line_payment_rec.trxn_extension_id = FND_API.G_MISS_NUM THEN
3652:
3653: IF l_debug_level > 0 THEN
3654: oe_debug_pub.add( 'Inside trxn extension id creation part....');
3655: oe_debug_pub.add(' Operation is UPDATE and Trxn extension id is null...');
3656: oe_debug_pub.add(' Creating a new trxn extension id ');
3657: END IF;
3658:

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

3651: p_x_line_payment_rec.trxn_extension_id = FND_API.G_MISS_NUM THEN
3652:
3653: IF l_debug_level > 0 THEN
3654: oe_debug_pub.add( 'Inside trxn extension id creation part....');
3655: oe_debug_pub.add(' Operation is UPDATE and Trxn extension id is null...');
3656: oe_debug_pub.add(' Creating a new trxn extension id ');
3657: END IF;
3658:
3659:

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

3652:
3653: IF l_debug_level > 0 THEN
3654: oe_debug_pub.add( 'Inside trxn extension id creation part....');
3655: oe_debug_pub.add(' Operation is UPDATE and Trxn extension id is null...');
3656: oe_debug_pub.add(' Creating a new trxn extension id ');
3657: END IF;
3658:
3659:
3660: /*l_trx_date := nvl(l_ordered_date, sysdate)

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

3697: l_update_card_flag := 'Y';
3698: END IF;
3699:
3700: IF l_debug_level > 0 THEN
3701: oe_debug_pub.add( 'Before calling create payment trxn....');
3702: oe_debug_pub.add('Update card flag..'||l_update_card_flag);
3703: END IF;
3704:
3705: BEGIN

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

3698: END IF;
3699:
3700: IF l_debug_level > 0 THEN
3701: oe_debug_pub.add( 'Before calling create payment trxn....');
3702: oe_debug_pub.add('Update card flag..'||l_update_card_flag);
3703: END IF;
3704:
3705: BEGIN
3706: OE_PAYMENT_TRXN_UTIL.Create_Payment_TRXN

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

3726: X_msg_data => l_msg_data);
3727:
3728: --p_x_line_payment_rec.trxn_extension_id := l_trxn_extension_id;
3729: IF l_debug_level>0 THEN
3730: oe_debug_pub.add('New trxn extension id after calling Create_Payment_TRXN:'||l_trxn_extension_id);
3731: END IF;
3732: EXCEPTION
3733: WHEN FND_API.G_EXC_ERROR THEN
3734: OE_MSG_PUB.Count_And_Get

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

3745: );
3746: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
3747: OE_MSG_PUB.ADD;
3748: IF l_debug_level > 0 THEN
3749: oe_debug_pub.add( 'OEXUHPMB: ERROR IN CREATE PAYMENT trxn...'||sqlerrm) ;
3750: oe_debug_pub.add('Error messsge ksurendr'||l_return_status);
3751: END IF;
3752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3753: END;

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

3746: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
3747: OE_MSG_PUB.ADD;
3748: IF l_debug_level > 0 THEN
3749: oe_debug_pub.add( 'OEXUHPMB: ERROR IN CREATE PAYMENT trxn...'||sqlerrm) ;
3750: oe_debug_pub.add('Error messsge ksurendr'||l_return_status);
3751: END IF;
3752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3753: END;
3754: --Trxn extension id exists and an update to some of the

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

3769: RAISE FND_API.G_EXC_ERROR;
3770: END IF;
3771: END IF;*/
3772: IF l_debug_level > 0 THEN
3773: oe_debug_pub.add('Verifying whether to call update card API...');
3774: END IF;
3775:
3776: --R12 CC Encryption
3777: --Since the credit card numbers are encrypted, passing both the credit card

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

3797: p_old_line_Payment_rec.credit_card_expiration_date) THEN
3798: l_update_card_flag := 'Y';
3799: END IF;
3800: IF l_debug_level > 0 THEN
3801: oe_debug_pub.add('Before calling update payment trxn...');
3802: oe_debug_pub.add('Update card flag...'||l_update_card_flag);
3803: END IF;
3804:
3805: --

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

3798: l_update_card_flag := 'Y';
3799: END IF;
3800: IF l_debug_level > 0 THEN
3801: oe_debug_pub.add('Before calling update payment trxn...');
3802: oe_debug_pub.add('Update card flag...'||l_update_card_flag);
3803: END IF;
3804:
3805: -- 3806: --extenstion table>

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

3827: X_msg_data => l_msg_data);
3828:
3829:
3830: IF l_debug_level > 0 THEN
3831: oe_debug_pub.add('trxn extension id after calling Update_Payment_TRXN:'||p_x_line_payment_rec.trxn_extension_id);
3832: oe_debug_pub.add( 'id already derived for this credit card');
3833: END IF;
3834: EXCEPTION
3835: WHEN FND_API.G_EXC_ERROR THEN

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

3828:
3829:
3830: IF l_debug_level > 0 THEN
3831: oe_debug_pub.add('trxn extension id after calling Update_Payment_TRXN:'||p_x_line_payment_rec.trxn_extension_id);
3832: oe_debug_pub.add( 'id already derived for this credit card');
3833: END IF;
3834: EXCEPTION
3835: WHEN FND_API.G_EXC_ERROR THEN
3836: IF l_debug_level > 0 THEN

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

3833: END IF;
3834: EXCEPTION
3835: WHEN FND_API.G_EXC_ERROR THEN
3836: IF l_debug_level > 0 THEN
3837: oe_debug_pub.add('Update_Payment_TRXN error....exc');
3838: oe_debug_pub.add('After call to Update_Payment_TRXN'||l_return_status);
3839: oe_debug_pub.add('Error'||sqlerrm);
3840: END IF;
3841: l_return_status := FND_API.G_RET_STS_ERROR;

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

3834: EXCEPTION
3835: WHEN FND_API.G_EXC_ERROR THEN
3836: IF l_debug_level > 0 THEN
3837: oe_debug_pub.add('Update_Payment_TRXN error....exc');
3838: oe_debug_pub.add('After call to Update_Payment_TRXN'||l_return_status);
3839: oe_debug_pub.add('Error'||sqlerrm);
3840: END IF;
3841: l_return_status := FND_API.G_RET_STS_ERROR;
3842: OE_MSG_PUB.Count_And_Get

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

3835: WHEN FND_API.G_EXC_ERROR THEN
3836: IF l_debug_level > 0 THEN
3837: oe_debug_pub.add('Update_Payment_TRXN error....exc');
3838: oe_debug_pub.add('After call to Update_Payment_TRXN'||l_return_status);
3839: oe_debug_pub.add('Error'||sqlerrm);
3840: END IF;
3841: l_return_status := FND_API.G_RET_STS_ERROR;
3842: OE_MSG_PUB.Count_And_Get
3843: ( p_count => l_msg_count,

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

3846: RAISE FND_API.G_EXC_ERROR;
3847:
3848: WHEN OTHERS THEN
3849: IF l_debug_level > 0 THEN
3850: oe_debug_pub.add('After call to Update_Payment_TRXN --> Unexpected error');
3851: oe_debug_pub.add('Error message '||sqlerrm);
3852: END IF;
3853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3854: END;

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

3847:
3848: WHEN OTHERS THEN
3849: IF l_debug_level > 0 THEN
3850: oe_debug_pub.add('After call to Update_Payment_TRXN --> Unexpected error');
3851: oe_debug_pub.add('Error message '||sqlerrm);
3852: END IF;
3853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3854: END;
3855: END IF;

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

3857: --by calling the Create_trxn_extension API.
3858: ELSIF p_x_line_payment_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN --not a copy order Verify
3859:
3860: IF l_debug_level > 0 THEN
3861: oe_debug_pub.add( 'Inside trxn extension id creation part....');
3862: END IF;
3863:
3864:
3865: /*l_trx_date := nvl(l_ordered_date, sysdate)

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

3898: l_update_card_flag := 'Y';
3899: END IF;
3900:
3901: IF l_debug_level > 0 THEN
3902: oe_debug_pub.add( 'Before calling create payment trxn....');
3903: oe_debug_pub.add('Update card flag..'||l_update_card_flag);
3904: END IF;
3905:
3906: --Begin

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

3899: END IF;
3900:
3901: IF l_debug_level > 0 THEN
3902: oe_debug_pub.add( 'Before calling create payment trxn....');
3903: oe_debug_pub.add('Update card flag..'||l_update_card_flag);
3904: END IF;
3905:
3906: --Begin
3907: --IF p_x_line_payment_rec.trxn_extension_id IS NULL THEN

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

3930: X_msg_data => l_msg_data);
3931:
3932: --p_x_line_payment_rec.trxn_extension_id := l_trxn_extension_id;
3933: IF l_debug_level>0 THEN
3934: oe_debug_pub.add('New trxn extension id after calling Create_Payment_TRXN:'||l_trxn_extension_id);
3935: END IF;
3936: Exception
3937: WHEN FND_API.G_EXC_ERROR THEN
3938: OE_MSG_PUB.Count_And_Get

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

3949: );
3950: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
3951: OE_MSG_PUB.ADD;
3952: IF l_debug_level > 0 THEN
3953: oe_debug_pub.add( 'OEXUHPMB: ERROR IN CREATE PAYMENT trxn...'||sqlerrm) ;
3954: oe_debug_pub.add('Error messsge ksurendr'||l_return_status);
3955: END IF;
3956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3957: end;

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

3950: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
3951: OE_MSG_PUB.ADD;
3952: IF l_debug_level > 0 THEN
3953: oe_debug_pub.add( 'OEXUHPMB: ERROR IN CREATE PAYMENT trxn...'||sqlerrm) ;
3954: oe_debug_pub.add('Error messsge ksurendr'||l_return_status);
3955: END IF;
3956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3957: end;
3958: END IF; --Operation

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

3963: --For update operation, the trxn extension id of the original
3964: --transaction needs to be deleted if it already exists as
3965: --there is no trxn extension id for check payments.
3966: IF l_debug_level > 0 THEN
3967: oe_debug_pub.add(' Before calling delete payment trxn....');
3968: oe_debug_pub.add(' Trxn extension to delete'||p_old_line_Payment_rec.trxn_extension_id);
3969: oe_debug_pub.add(' Header id '||p_x_line_payment_rec.line_id);
3970: END IF;
3971:

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

3964: --transaction needs to be deleted if it already exists as
3965: --there is no trxn extension id for check payments.
3966: IF l_debug_level > 0 THEN
3967: oe_debug_pub.add(' Before calling delete payment trxn....');
3968: oe_debug_pub.add(' Trxn extension to delete'||p_old_line_Payment_rec.trxn_extension_id);
3969: oe_debug_pub.add(' Header id '||p_x_line_payment_rec.line_id);
3970: END IF;
3971:
3972: OE_PAYMENT_TRXN_UTIL.Delete_Payment_Trxn

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

3965: --there is no trxn extension id for check payments.
3966: IF l_debug_level > 0 THEN
3967: oe_debug_pub.add(' Before calling delete payment trxn....');
3968: oe_debug_pub.add(' Trxn extension to delete'||p_old_line_Payment_rec.trxn_extension_id);
3969: oe_debug_pub.add(' Header id '||p_x_line_payment_rec.line_id);
3970: END IF;
3971:
3972: OE_PAYMENT_TRXN_UTIL.Delete_Payment_Trxn
3973: (p_header_id => p_x_line_payment_rec.header_id,

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

3986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3987: END IF;
3988:
3989: IF l_debug_level > 0 THEN
3990: oe_debug_pub.add('Successful deletion of trxn extension');
3991: oe_debug_pub.add('Return status after delete trxn in pre write process '|| l_return_status);
3992: oe_debug_pub.add('msg data'||l_msg_data);
3993: END IF;
3994:

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

3987: END IF;
3988:
3989: IF l_debug_level > 0 THEN
3990: oe_debug_pub.add('Successful deletion of trxn extension');
3991: oe_debug_pub.add('Return status after delete trxn in pre write process '|| l_return_status);
3992: oe_debug_pub.add('msg data'||l_msg_data);
3993: END IF;
3994:
3995: --Setting the trxn extension id as null as for transactions

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

3988:
3989: IF l_debug_level > 0 THEN
3990: oe_debug_pub.add('Successful deletion of trxn extension');
3991: oe_debug_pub.add('Return status after delete trxn in pre write process '|| l_return_status);
3992: oe_debug_pub.add('msg data'||l_msg_data);
3993: END IF;
3994:
3995: --Setting the trxn extension id as null as for transactions
3996: --coming from sales order others tab, the trxn extension id would

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

4000: --R12 CC Encryption
4001: EXCEPTION
4002: WHEN FND_API.G_EXC_ERROR THEN
4003: IF L_DEBUG_LEVEL > 0 THEN
4004: Oe_debug_pub.add('OEXULPMB.pls - pre_write_process error ');
4005: END if;
4006: p_x_line_payment_rec.return_status := FND_API.G_RET_STS_ERROR;
4007: RAISE FND_API.G_EXC_ERROR;
4008: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

4006: p_x_line_payment_rec.return_status := FND_API.G_RET_STS_ERROR;
4007: RAISE FND_API.G_EXC_ERROR;
4008: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4009: IF L_DEBUG_LEVEL > 0 THEN
4010: Oe_debug_pub.add('OEXULPMB.pls - pre_write_process unexpected error ');
4011: END if;
4012: p_x_line_payment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4014: WHEN OTHERS THEN

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

4012: p_x_line_payment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4014: WHEN OTHERS THEN
4015: if l_debug_level > 0 then
4016: oe_debug_pub.add('OEXULPMB.pls - pre_write_process unexpected error ');
4017: end if;
4018: p_x_line_payment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4020:

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

4036: l_return_status varchar2(30) := NULL;
4037: l_payment_type_code varchar2(30) := null;
4038: l_upd_commitment number := 0;
4039: l_upd_payment number := 0;
4040: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4041:
4042: Begin
4043:
4044:

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

4074:
4075: l_line_rec := l_old_line_rec;
4076:
4077: if l_debug_level > 0 then
4078: oe_debug_pub.add('before updating oe_order_headers_all ');
4079: end if;
4080:
4081: if l_upd_commitment = 1 and l_upd_payment = 1 then
4082:

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

4080:
4081: if l_upd_commitment = 1 and l_upd_payment = 1 then
4082:
4083: if l_debug_level > 0 then
4084: oe_debug_pub.add('update commitment and payment type ');
4085: end if;
4086:
4087: update oe_order_lines_all
4088: set payment_type_code = null,

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

4091:
4092: elsif l_upd_payment = 1 then
4093:
4094: if l_debug_level > 0 then
4095: oe_debug_pub.add('update payment type ');
4096: end if;
4097:
4098: update oe_order_lines_all
4099: set payment_type_code = null

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

4101:
4102: elsif l_upd_commitment = 1 then
4103:
4104: if l_debug_level > 0 then
4105: oe_debug_pub.add('update commitment ');
4106: end if;
4107:
4108: update oe_order_lines_all
4109: set commitment_id = null