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

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

16: FUNCTION G_MISS_OE_AK_HPAYMENT_REC
17: RETURN OE_AK_HEADER_PAYMENTS_V%ROWTYPE IS
18: l_rowtype_rec OE_AK_HEADER_PAYMENTS_V%ROWTYPE;
19: --
20: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
21: --
22: BEGIN
23:
24: l_rowtype_rec.ATTRIBUTE1 := FND_API.G_MISS_CHAR;

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

79: ( p_HEADER_Payment_rec IN OE_Order_PUB.HEADER_PAYMENT_Rec_Type
80: , x_rowtype_rec IN OUT NOCOPY OE_AK_HEADER_PAYMENTS_V%ROWTYPE
81: ) IS
82: --
83: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
84: --
85: BEGIN
86:
87: x_rowtype_rec.ATTRIBUTE1 := p_header_Payment_rec.ATTRIBUTE1;

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

141: ( p_record IN OE_AK_HEADER_PaymentS_V%ROWTYPE
142: , x_api_rec IN OUT NOCOPY OE_Order_PUB.HEADER_Payment_Rec_Type
143: ) IS
144: --
145: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
146: --
147: BEGIN
148:
149: x_api_rec.ATTRIBUTE1 := p_record.ATTRIBUTE1;

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

211: l_index NUMBER :=0;
212: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
213: l_dep_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
214: --
215: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
216: --
217: BEGIN
218:
219: -- Load out record

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

805: IS
806: l_Header_Payment_rec OE_AK_HEADER_PaymentS_V%ROWTYPE;
807: l_old_Header_Payment_rec OE_AK_HEADER_PaymentS_V%ROWTYPE;
808: --
809: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
810: --
811: BEGIN
812:
813: API_Rec_To_Rowtype_Rec(p_x_Header_Payment_rec, l_Header_Payment_rec);

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

850: AND OP.line_id IS NULL;
851:
852: l_order_hold_id OE_ORDER_HOLDS.ORDER_HOLD_ID%TYPE;
853: l_hold_release_id OE_ORDER_HOLDS.HOLD_RELEASE_ID%TYPE;
854: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
855:
856: BEGIN
857: x_return_status := FND_API.G_RET_STS_SUCCESS;
858:

Line 860: oe_debug_pub.add( 'Entering Delete_PaymentType_Hold' , 3 ) ;

856: BEGIN
857: x_return_status := FND_API.G_RET_STS_SUCCESS;
858:
859: IF l_debug_level > 0 THEN
860: oe_debug_pub.add( 'Entering Delete_PaymentType_Hold' , 3 ) ;
861: END IF;
862:
863: OPEN order_paytype_hold;
864:

Line 872: oe_debug_pub.add( 'DELETING HEADER PAYMENT TYPE HOLD' ) ;

868: EXIT;
869: END IF;
870:
871: IF l_debug_level > 0 THEN
872: oe_debug_pub.add( 'DELETING HEADER PAYMENT TYPE HOLD' ) ;
873: END IF;
874:
875: DELETE FROM OE_ORDER_HOLDS
876: WHERE order_hold_id = l_order_hold_id;

Line 886: oe_debug_pub.add( 'Exiting Delete_PaymentType_Hold' , 3 ) ;

882:
883: CLOSE order_paytype_hold;
884:
885: IF l_debug_level > 0 THEN
886: oe_debug_pub.add( 'Exiting Delete_PaymentType_Hold' , 3 ) ;
887: END IF;
888:
889: EXCEPTION
890: WHEN FND_API.G_EXC_ERROR THEN

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

920: )
921: IS
922: l_return_status Varchar2(10);
923: --
924: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
925: --
926: l_payments_update_flag VARCHAR2(1) := 'N';
927: --bug3507871
928: l_booked_flag VARCHAR2(1) :='N';

Line 990: oe_debug_pub.add('Trxn_extension id ksurendr'||p_x_Header_Payment_rec.trxn_extension_id);

986: BEGIN
987:
988: -- Load out record
989:
990: oe_debug_pub.add('Trxn_extension id ksurendr'||p_x_Header_Payment_rec.trxn_extension_id);
991: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute1,p_old_Header_Payment_rec.attribute1)
992: THEN
993: NULL;
994: END IF;

Line 1116: --oe_debug_pub.add('Old Expiration date in apply attribute changes '||p_old_Header_Payment_rec.credit_card_expiration_date);

1112: THEN
1113: l_payments_update_flag := 'Y';
1114: END IF;
1115: --IF l_debug_level > 0 THEN
1116: --oe_debug_pub.add('Old Expiration date in apply attribute changes '||p_old_Header_Payment_rec.credit_card_expiration_date);
1117: --oe_debug_pub.add('New Expiration date'||p_x_Header_Payment_rec.credit_card_expiration_date);
1118: --END IF;
1119:
1120: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.credit_card_expiration_date,p_old_Header_Payment_rec.credit_card_expiration_date)

Line 1117: --oe_debug_pub.add('New Expiration date'||p_x_Header_Payment_rec.credit_card_expiration_date);

1113: l_payments_update_flag := 'Y';
1114: END IF;
1115: --IF l_debug_level > 0 THEN
1116: --oe_debug_pub.add('Old Expiration date in apply attribute changes '||p_old_Header_Payment_rec.credit_card_expiration_date);
1117: --oe_debug_pub.add('New Expiration date'||p_x_Header_Payment_rec.credit_card_expiration_date);
1118: --END IF;
1119:
1120: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.credit_card_expiration_date,p_old_Header_Payment_rec.credit_card_expiration_date)
1121: THEN

Line 1125: --oe_debug_pub.add('Old cc holder name'||p_old_Header_Payment_rec.credit_card_holder_name);

1121: THEN
1122: l_payments_update_flag := 'Y';
1123: END IF;
1124: --IF l_debug_level > 0 THEN
1125: --oe_debug_pub.add('Old cc holder name'||p_old_Header_Payment_rec.credit_card_holder_name);
1126: --oe_debug_pub.add('New cc holder name'||p_x_Header_Payment_rec.credit_card_holder_name);
1127: --END IF;
1128:
1129: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.credit_card_holder_name,p_old_Header_Payment_rec.credit_card_holder_name)

Line 1126: --oe_debug_pub.add('New cc holder name'||p_x_Header_Payment_rec.credit_card_holder_name);

1122: l_payments_update_flag := 'Y';
1123: END IF;
1124: --IF l_debug_level > 0 THEN
1125: --oe_debug_pub.add('Old cc holder name'||p_old_Header_Payment_rec.credit_card_holder_name);
1126: --oe_debug_pub.add('New cc holder name'||p_x_Header_Payment_rec.credit_card_holder_name);
1127: --END IF;
1128:
1129: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.credit_card_holder_name,p_old_Header_Payment_rec.credit_card_holder_name)
1130: THEN

Line 1144: oe_debug_pub.add('after is_same_credit_card ---> changed cc number');

1140: p_old_Header_Payment_rec.cc_instrument_id,
1141: p_x_Header_Payment_rec.cc_instrument_id)
1142: THEN
1143: IF l_debug_level > 0 THEN
1144: oe_debug_pub.add('after is_same_credit_card ---> changed cc number');
1145: END IF;
1146: l_payments_update_flag := 'Y';
1147: --CC Reversal ER#16014135 start
1148: IF (p_x_Header_Payment_rec.operation ='UPDATE'

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

1164: NULL;
1165: --CC Reversal ER#16014135 start
1166: l_verify_payment_flag:='Y';
1167: IF l_debug_level > 0 THEN
1168: oe_debug_pub.add('in commitment_applied_amount' );
1169: END IF;
1170: --CC Reversal ER#16014135 end
1171: END IF;
1172:

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

1175: NULL;
1176: --CC Reversal ER#16014135 start
1177: l_verify_payment_flag:='Y';
1178: IF l_debug_level > 0 THEN
1179: oe_debug_pub.add('in commitment_interfaced_amount' );
1180: END IF;
1181: --CC Reversal ER#16014135 end
1182: END IF;
1183:

Line 1206: oe_debug_pub.add('in trxn_extension_id' );

1202: NULL;
1203: --CC Reversal ER#16014135 start
1204: l_verify_payment_flag:='Y';
1205: IF l_debug_level > 0 THEN
1206: oe_debug_pub.add('in trxn_extension_id' );
1207: END IF;
1208: --CC Reversal ER#16014135 end
1209: END IF;
1210:

Line 1230: oe_debug_pub.add('pviprana: logging a new payment delayed request for making the order go on payment hold', 1);

1226: FROM oe_order_headers_all
1227: WHERE header_id=p_x_header_Payment_rec.header_id;
1228: IF (l_booked_flag = 'Y') THEN
1229: IF( l_debug_level > 0) THEN
1230: oe_debug_pub.add('pviprana: logging a new payment delayed request for making the order go on payment hold', 1);
1231: END IF;
1232:
1233:
1234: OE_delayed_requests_Pvt.log_request

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

1325: THEN
1326:
1327: IF( l_debug_level > 0) THEN
1328:
1329: oe_debug_pub.add('pviprana: logging a new payment delayed request for processing the payment', 1);
1330: END IF;
1331:
1332: OE_delayed_requests_Pvt.log_request
1333: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_PAYMENT,

Line 1415: oe_debug_pub.add('p_x_header_payment_rec.payment_collection_event ' || p_x_header_payment_rec.payment_collection_event);

1411: -- p_credit_card_approval_code;
1412:
1413: close header_payment_cur;
1414: /*
1415: oe_debug_pub.add('p_x_header_payment_rec.payment_collection_event ' || p_x_header_payment_rec.payment_collection_event);
1416: oe_debug_pub.add('p_old_Header_Payment_rec.payment_collection_event ' || p_old_Header_Payment_rec.payment_collection_event);
1417: oe_debug_pub.add('p_payment_type_code ' || p_payment_type_code);
1418: oe_debug_pub.add('p_x_header_payment_rec.payment_type_code ' || p_x_header_payment_rec.payment_type_code);
1419: oe_debug_pub.add('p_payment_amount ' || p_payment_amount);

Line 1416: oe_debug_pub.add('p_old_Header_Payment_rec.payment_collection_event ' || p_old_Header_Payment_rec.payment_collection_event);

1412:
1413: close header_payment_cur;
1414: /*
1415: oe_debug_pub.add('p_x_header_payment_rec.payment_collection_event ' || p_x_header_payment_rec.payment_collection_event);
1416: oe_debug_pub.add('p_old_Header_Payment_rec.payment_collection_event ' || p_old_Header_Payment_rec.payment_collection_event);
1417: oe_debug_pub.add('p_payment_type_code ' || p_payment_type_code);
1418: oe_debug_pub.add('p_x_header_payment_rec.payment_type_code ' || p_x_header_payment_rec.payment_type_code);
1419: oe_debug_pub.add('p_payment_amount ' || p_payment_amount);
1420: oe_debug_pub.add('p_x_header_payment_rec.payment_amount ' || p_x_header_payment_rec.payment_amount);

Line 1417: oe_debug_pub.add('p_payment_type_code ' || p_payment_type_code);

1413: close header_payment_cur;
1414: /*
1415: oe_debug_pub.add('p_x_header_payment_rec.payment_collection_event ' || p_x_header_payment_rec.payment_collection_event);
1416: oe_debug_pub.add('p_old_Header_Payment_rec.payment_collection_event ' || p_old_Header_Payment_rec.payment_collection_event);
1417: oe_debug_pub.add('p_payment_type_code ' || p_payment_type_code);
1418: oe_debug_pub.add('p_x_header_payment_rec.payment_type_code ' || p_x_header_payment_rec.payment_type_code);
1419: oe_debug_pub.add('p_payment_amount ' || p_payment_amount);
1420: oe_debug_pub.add('p_x_header_payment_rec.payment_amount ' || p_x_header_payment_rec.payment_amount);
1421: oe_debug_pub.add('p_check_number ' || p_check_number);

Line 1418: oe_debug_pub.add('p_x_header_payment_rec.payment_type_code ' || p_x_header_payment_rec.payment_type_code);

1414: /*
1415: oe_debug_pub.add('p_x_header_payment_rec.payment_collection_event ' || p_x_header_payment_rec.payment_collection_event);
1416: oe_debug_pub.add('p_old_Header_Payment_rec.payment_collection_event ' || p_old_Header_Payment_rec.payment_collection_event);
1417: oe_debug_pub.add('p_payment_type_code ' || p_payment_type_code);
1418: oe_debug_pub.add('p_x_header_payment_rec.payment_type_code ' || p_x_header_payment_rec.payment_type_code);
1419: oe_debug_pub.add('p_payment_amount ' || p_payment_amount);
1420: oe_debug_pub.add('p_x_header_payment_rec.payment_amount ' || p_x_header_payment_rec.payment_amount);
1421: oe_debug_pub.add('p_check_number ' || p_check_number);
1422: oe_debug_pub.add('p_x_header_payment_rec.check_number ' || p_x_header_payment_rec.check_number);

Line 1419: oe_debug_pub.add('p_payment_amount ' || p_payment_amount);

1415: oe_debug_pub.add('p_x_header_payment_rec.payment_collection_event ' || p_x_header_payment_rec.payment_collection_event);
1416: oe_debug_pub.add('p_old_Header_Payment_rec.payment_collection_event ' || p_old_Header_Payment_rec.payment_collection_event);
1417: oe_debug_pub.add('p_payment_type_code ' || p_payment_type_code);
1418: oe_debug_pub.add('p_x_header_payment_rec.payment_type_code ' || p_x_header_payment_rec.payment_type_code);
1419: oe_debug_pub.add('p_payment_amount ' || p_payment_amount);
1420: oe_debug_pub.add('p_x_header_payment_rec.payment_amount ' || p_x_header_payment_rec.payment_amount);
1421: oe_debug_pub.add('p_check_number ' || p_check_number);
1422: oe_debug_pub.add('p_x_header_payment_rec.check_number ' || p_x_header_payment_rec.check_number);
1423: oe_debug_pub.add('p_credit_card_code ' || p_credit_card_code);

Line 1420: oe_debug_pub.add('p_x_header_payment_rec.payment_amount ' || p_x_header_payment_rec.payment_amount);

1416: oe_debug_pub.add('p_old_Header_Payment_rec.payment_collection_event ' || p_old_Header_Payment_rec.payment_collection_event);
1417: oe_debug_pub.add('p_payment_type_code ' || p_payment_type_code);
1418: oe_debug_pub.add('p_x_header_payment_rec.payment_type_code ' || p_x_header_payment_rec.payment_type_code);
1419: oe_debug_pub.add('p_payment_amount ' || p_payment_amount);
1420: oe_debug_pub.add('p_x_header_payment_rec.payment_amount ' || p_x_header_payment_rec.payment_amount);
1421: oe_debug_pub.add('p_check_number ' || p_check_number);
1422: oe_debug_pub.add('p_x_header_payment_rec.check_number ' || p_x_header_payment_rec.check_number);
1423: oe_debug_pub.add('p_credit_card_code ' || p_credit_card_code);
1424: oe_debug_pub.add('p_x_header_payment_rec.credit_card_code ' || p_x_header_payment_rec.credit_card_code);

Line 1421: oe_debug_pub.add('p_check_number ' || p_check_number);

1417: oe_debug_pub.add('p_payment_type_code ' || p_payment_type_code);
1418: oe_debug_pub.add('p_x_header_payment_rec.payment_type_code ' || p_x_header_payment_rec.payment_type_code);
1419: oe_debug_pub.add('p_payment_amount ' || p_payment_amount);
1420: oe_debug_pub.add('p_x_header_payment_rec.payment_amount ' || p_x_header_payment_rec.payment_amount);
1421: oe_debug_pub.add('p_check_number ' || p_check_number);
1422: oe_debug_pub.add('p_x_header_payment_rec.check_number ' || p_x_header_payment_rec.check_number);
1423: oe_debug_pub.add('p_credit_card_code ' || p_credit_card_code);
1424: oe_debug_pub.add('p_x_header_payment_rec.credit_card_code ' || p_x_header_payment_rec.credit_card_code);
1425: oe_debug_pub.add('p_credit_card_holder_name ' || p_credit_card_holder_name);

Line 1422: oe_debug_pub.add('p_x_header_payment_rec.check_number ' || p_x_header_payment_rec.check_number);

1418: oe_debug_pub.add('p_x_header_payment_rec.payment_type_code ' || p_x_header_payment_rec.payment_type_code);
1419: oe_debug_pub.add('p_payment_amount ' || p_payment_amount);
1420: oe_debug_pub.add('p_x_header_payment_rec.payment_amount ' || p_x_header_payment_rec.payment_amount);
1421: oe_debug_pub.add('p_check_number ' || p_check_number);
1422: oe_debug_pub.add('p_x_header_payment_rec.check_number ' || p_x_header_payment_rec.check_number);
1423: oe_debug_pub.add('p_credit_card_code ' || p_credit_card_code);
1424: oe_debug_pub.add('p_x_header_payment_rec.credit_card_code ' || p_x_header_payment_rec.credit_card_code);
1425: oe_debug_pub.add('p_credit_card_holder_name ' || p_credit_card_holder_name);
1426: oe_debug_pub.add('p_x_header_payment_rec.credit_card_holder_name ' || p_x_header_payment_rec.credit_card_holder_name);

Line 1423: oe_debug_pub.add('p_credit_card_code ' || p_credit_card_code);

1419: oe_debug_pub.add('p_payment_amount ' || p_payment_amount);
1420: oe_debug_pub.add('p_x_header_payment_rec.payment_amount ' || p_x_header_payment_rec.payment_amount);
1421: oe_debug_pub.add('p_check_number ' || p_check_number);
1422: oe_debug_pub.add('p_x_header_payment_rec.check_number ' || p_x_header_payment_rec.check_number);
1423: oe_debug_pub.add('p_credit_card_code ' || p_credit_card_code);
1424: oe_debug_pub.add('p_x_header_payment_rec.credit_card_code ' || p_x_header_payment_rec.credit_card_code);
1425: oe_debug_pub.add('p_credit_card_holder_name ' || p_credit_card_holder_name);
1426: oe_debug_pub.add('p_x_header_payment_rec.credit_card_holder_name ' || p_x_header_payment_rec.credit_card_holder_name);
1427: oe_debug_pub.add('p_credit_card_number ' || p_credit_card_number);

Line 1424: oe_debug_pub.add('p_x_header_payment_rec.credit_card_code ' || p_x_header_payment_rec.credit_card_code);

1420: oe_debug_pub.add('p_x_header_payment_rec.payment_amount ' || p_x_header_payment_rec.payment_amount);
1421: oe_debug_pub.add('p_check_number ' || p_check_number);
1422: oe_debug_pub.add('p_x_header_payment_rec.check_number ' || p_x_header_payment_rec.check_number);
1423: oe_debug_pub.add('p_credit_card_code ' || p_credit_card_code);
1424: oe_debug_pub.add('p_x_header_payment_rec.credit_card_code ' || p_x_header_payment_rec.credit_card_code);
1425: oe_debug_pub.add('p_credit_card_holder_name ' || p_credit_card_holder_name);
1426: oe_debug_pub.add('p_x_header_payment_rec.credit_card_holder_name ' || p_x_header_payment_rec.credit_card_holder_name);
1427: oe_debug_pub.add('p_credit_card_number ' || p_credit_card_number);
1428: oe_debug_pub.add('p_x_header_payment_rec.credit_card_number ' || p_x_header_payment_rec.credit_card_number);

Line 1425: oe_debug_pub.add('p_credit_card_holder_name ' || p_credit_card_holder_name);

1421: oe_debug_pub.add('p_check_number ' || p_check_number);
1422: oe_debug_pub.add('p_x_header_payment_rec.check_number ' || p_x_header_payment_rec.check_number);
1423: oe_debug_pub.add('p_credit_card_code ' || p_credit_card_code);
1424: oe_debug_pub.add('p_x_header_payment_rec.credit_card_code ' || p_x_header_payment_rec.credit_card_code);
1425: oe_debug_pub.add('p_credit_card_holder_name ' || p_credit_card_holder_name);
1426: oe_debug_pub.add('p_x_header_payment_rec.credit_card_holder_name ' || p_x_header_payment_rec.credit_card_holder_name);
1427: oe_debug_pub.add('p_credit_card_number ' || p_credit_card_number);
1428: oe_debug_pub.add('p_x_header_payment_rec.credit_card_number ' || p_x_header_payment_rec.credit_card_number);
1429: oe_debug_pub.add('p_credit_card_expiration_date ' || p_credit_card_expiration_date);

Line 1426: oe_debug_pub.add('p_x_header_payment_rec.credit_card_holder_name ' || p_x_header_payment_rec.credit_card_holder_name);

1422: oe_debug_pub.add('p_x_header_payment_rec.check_number ' || p_x_header_payment_rec.check_number);
1423: oe_debug_pub.add('p_credit_card_code ' || p_credit_card_code);
1424: oe_debug_pub.add('p_x_header_payment_rec.credit_card_code ' || p_x_header_payment_rec.credit_card_code);
1425: oe_debug_pub.add('p_credit_card_holder_name ' || p_credit_card_holder_name);
1426: oe_debug_pub.add('p_x_header_payment_rec.credit_card_holder_name ' || p_x_header_payment_rec.credit_card_holder_name);
1427: oe_debug_pub.add('p_credit_card_number ' || p_credit_card_number);
1428: oe_debug_pub.add('p_x_header_payment_rec.credit_card_number ' || p_x_header_payment_rec.credit_card_number);
1429: oe_debug_pub.add('p_credit_card_expiration_date ' || p_credit_card_expiration_date);
1430: oe_debug_pub.add('p_x_header_payment_rec.credit_card_expiration_date ' || p_x_header_payment_rec.credit_card_expiration_date);

Line 1427: oe_debug_pub.add('p_credit_card_number ' || p_credit_card_number);

1423: oe_debug_pub.add('p_credit_card_code ' || p_credit_card_code);
1424: oe_debug_pub.add('p_x_header_payment_rec.credit_card_code ' || p_x_header_payment_rec.credit_card_code);
1425: oe_debug_pub.add('p_credit_card_holder_name ' || p_credit_card_holder_name);
1426: oe_debug_pub.add('p_x_header_payment_rec.credit_card_holder_name ' || p_x_header_payment_rec.credit_card_holder_name);
1427: oe_debug_pub.add('p_credit_card_number ' || p_credit_card_number);
1428: oe_debug_pub.add('p_x_header_payment_rec.credit_card_number ' || p_x_header_payment_rec.credit_card_number);
1429: oe_debug_pub.add('p_credit_card_expiration_date ' || p_credit_card_expiration_date);
1430: oe_debug_pub.add('p_x_header_payment_rec.credit_card_expiration_date ' || p_x_header_payment_rec.credit_card_expiration_date);
1431:

Line 1428: oe_debug_pub.add('p_x_header_payment_rec.credit_card_number ' || p_x_header_payment_rec.credit_card_number);

1424: oe_debug_pub.add('p_x_header_payment_rec.credit_card_code ' || p_x_header_payment_rec.credit_card_code);
1425: oe_debug_pub.add('p_credit_card_holder_name ' || p_credit_card_holder_name);
1426: oe_debug_pub.add('p_x_header_payment_rec.credit_card_holder_name ' || p_x_header_payment_rec.credit_card_holder_name);
1427: oe_debug_pub.add('p_credit_card_number ' || p_credit_card_number);
1428: oe_debug_pub.add('p_x_header_payment_rec.credit_card_number ' || p_x_header_payment_rec.credit_card_number);
1429: oe_debug_pub.add('p_credit_card_expiration_date ' || p_credit_card_expiration_date);
1430: oe_debug_pub.add('p_x_header_payment_rec.credit_card_expiration_date ' || p_x_header_payment_rec.credit_card_expiration_date);
1431:
1432: oe_debug_pub.add('p_x_header_payment_rec.payment_collection_event ' || p_x_header_payment_rec.payment_collection_event);

Line 1429: oe_debug_pub.add('p_credit_card_expiration_date ' || p_credit_card_expiration_date);

1425: oe_debug_pub.add('p_credit_card_holder_name ' || p_credit_card_holder_name);
1426: oe_debug_pub.add('p_x_header_payment_rec.credit_card_holder_name ' || p_x_header_payment_rec.credit_card_holder_name);
1427: oe_debug_pub.add('p_credit_card_number ' || p_credit_card_number);
1428: oe_debug_pub.add('p_x_header_payment_rec.credit_card_number ' || p_x_header_payment_rec.credit_card_number);
1429: oe_debug_pub.add('p_credit_card_expiration_date ' || p_credit_card_expiration_date);
1430: oe_debug_pub.add('p_x_header_payment_rec.credit_card_expiration_date ' || p_x_header_payment_rec.credit_card_expiration_date);
1431:
1432: oe_debug_pub.add('p_x_header_payment_rec.payment_collection_event ' || p_x_header_payment_rec.payment_collection_event);
1433: */

Line 1430: oe_debug_pub.add('p_x_header_payment_rec.credit_card_expiration_date ' || p_x_header_payment_rec.credit_card_expiration_date);

1426: oe_debug_pub.add('p_x_header_payment_rec.credit_card_holder_name ' || p_x_header_payment_rec.credit_card_holder_name);
1427: oe_debug_pub.add('p_credit_card_number ' || p_credit_card_number);
1428: oe_debug_pub.add('p_x_header_payment_rec.credit_card_number ' || p_x_header_payment_rec.credit_card_number);
1429: oe_debug_pub.add('p_credit_card_expiration_date ' || p_credit_card_expiration_date);
1430: oe_debug_pub.add('p_x_header_payment_rec.credit_card_expiration_date ' || p_x_header_payment_rec.credit_card_expiration_date);
1431:
1432: oe_debug_pub.add('p_x_header_payment_rec.payment_collection_event ' || p_x_header_payment_rec.payment_collection_event);
1433: */
1434: if p_x_header_payment_rec.payment_type_code IS NOT NULL and

Line 1432: oe_debug_pub.add('p_x_header_payment_rec.payment_collection_event ' || p_x_header_payment_rec.payment_collection_event);

1428: oe_debug_pub.add('p_x_header_payment_rec.credit_card_number ' || p_x_header_payment_rec.credit_card_number);
1429: oe_debug_pub.add('p_credit_card_expiration_date ' || p_credit_card_expiration_date);
1430: oe_debug_pub.add('p_x_header_payment_rec.credit_card_expiration_date ' || p_x_header_payment_rec.credit_card_expiration_date);
1431:
1432: oe_debug_pub.add('p_x_header_payment_rec.payment_collection_event ' || p_x_header_payment_rec.payment_collection_event);
1433: */
1434: if p_x_header_payment_rec.payment_type_code IS NOT NULL and
1435: (((nvl(p_payment_type_code, '-1') <> nvl(p_x_header_payment_rec.payment_type_code, '-1') or
1436: -- nvl(p_payment_amount, -1) <> nvl(p_x_header_payment_rec.payment_amount,-1) or

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

1446: p_x_header_payment_rec.operation = 'UPDATE')) then
1447: --bug3781675 end
1448:
1449:
1450: oe_debug_pub.add('logging synch from UHPMB.pls payment delayed request', 1);
1451:
1452: OE_delayed_requests_Pvt.log_request
1453: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_PAYMENT,
1454: p_entity_id => p_x_Header_Payment_rec.header_id,

Line 1467: oe_debug_pub.add('logging request to release payment related holds', 3);

1463:
1464: END IF;
1465:
1466: IF l_delete_payment_hold = 'Y' THEN
1467: oe_debug_pub.add('logging request to release payment related holds', 3);
1468: IF nvl(p_old_Header_Payment_rec.payment_collection_event,'PREPAY')
1469: = 'PREPAY' THEN
1470: l_delete_pmt_param1 := 'PREPAYMENT';
1471: ELSE

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

1485: --ER#7479609 start
1486: --ER#7479609 start
1487: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.payment_type_code,p_old_Header_Payment_rec.payment_type_code)
1488: THEN
1489: oe_debug_pub.add('logging Delayed request for evaluation of payments hold', 1);
1490:
1491: OE_delayed_requests_Pvt.log_request
1492: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_PAYMENT,
1493: p_entity_id => p_x_Header_Payment_rec.header_id,

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

1503: --CC Reversal ER#16014135 start
1504: IF OE_VERIFY_PAYMENT_PUB.Get_CC_Rev_Reauth_Code(p_x_Header_Payment_rec.header_id) IS NOT NULL
1505: AND l_verify_payment_flag='Y' THEN
1506: IF l_debug_level > 0 THEN
1507: oe_debug_pub.ADD('OEXUHPMB: Logging delayed request for Verify Payment CC Reversal',5);
1508: END IF;
1509: oe_verify_payment_pub.G_credit_check_flag := 'N' ;
1510: OE_delayed_requests_Pvt.log_request
1511: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

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

1526: , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type
1527: )
1528: IS
1529: --
1530: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1531: --
1532: BEGIN
1533:
1534: IF p_x_Header_Payment_rec.attribute1 = FND_API.G_MISS_CHAR THEN

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

1760: )
1761: IS
1762:
1763: --
1764: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1765: --
1766: BEGIN
1767:
1768: IF p_x_Header_Payment_rec.attribute1 = FND_API.G_MISS_CHAR THEN

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

1995: l_return_status VARCHAR2(1);
1996:
1997:
1998: --
1999: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2000: --
2001: BEGIN
2002:
2003: SELECT lock_control

Line 2016: oe_debug_pub.add( 'JFC: payment_number' || P_HEADER_Payment_REC.payment_number ) ;

2012: --calling notification framework to update global picture
2013: --check code release level first. Notification framework is at Pack H level
2014: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
2015: IF l_debug_level > 0 THEN
2016: oe_debug_pub.add( 'JFC: payment_number' || P_HEADER_Payment_REC.payment_number ) ;
2017: END IF;
2018: -- Sasi: this should be added by Renga
2019: /* OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
2020: p_Hdr_pmt_rec =>p_header_Payment_rec,

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

2021: p_hdr_pmt_id => p_header_Payment_rec.payment_number,
2022: x_index => l_index,
2023: x_return_status => l_return_status);*/
2024: IF l_debug_level > 0 THEN
2025: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_Payment_UTIL.UPDATE_ROW IS: ' || L_RETURN_STATUS ) ;
2026: END IF;
2027: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2028: IF l_debug_level > 0 THEN
2029: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;

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

2025: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_Payment_UTIL.UPDATE_ROW IS: ' || L_RETURN_STATUS ) ;
2026: END IF;
2027: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2028: IF l_debug_level > 0 THEN
2029: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2030: END IF;
2031: IF l_debug_level > 0 THEN
2032: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.UPDATE_ROW' , 1 ) ;
2033: END IF;

Line 2032: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.UPDATE_ROW' , 1 ) ;

2028: IF l_debug_level > 0 THEN
2029: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2030: END IF;
2031: IF l_debug_level > 0 THEN
2032: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.UPDATE_ROW' , 1 ) ;
2033: END IF;
2034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2035: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2036: IF l_debug_level > 0 THEN

Line 2037: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.UPDATE_ROW' ) ;

2033: END IF;
2034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2035: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2036: IF l_debug_level > 0 THEN
2037: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.UPDATE_ROW' ) ;
2038: END IF;
2039: IF l_debug_level > 0 THEN
2040: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.UPDATE_ROW' , 1 ) ;
2041: END IF;

Line 2040: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.UPDATE_ROW' , 1 ) ;

2036: IF l_debug_level > 0 THEN
2037: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.UPDATE_ROW' ) ;
2038: END IF;
2039: IF l_debug_level > 0 THEN
2040: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.UPDATE_ROW' , 1 ) ;
2041: END IF;
2042: RAISE FND_API.G_EXC_ERROR;
2043: END IF;
2044: END IF; /*code_release_level*/

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

2131: l_lock_control NUMBER:= 1;
2132: l_index NUMBER;
2133: l_return_status VARCHAR2(1);
2134: --
2135: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2136: --
2137: BEGIN
2138: IF l_debug_level > 0 THEN
2139: oe_debug_pub.add( 'ENTERING OE_HEADER_Payment_UTIL.INSERT_ROW' , 1 ) ;

Line 2139: oe_debug_pub.add( 'ENTERING OE_HEADER_Payment_UTIL.INSERT_ROW' , 1 ) ;

2135: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2136: --
2137: BEGIN
2138: IF l_debug_level > 0 THEN
2139: oe_debug_pub.add( 'ENTERING OE_HEADER_Payment_UTIL.INSERT_ROW' , 1 ) ;
2140: END IF;
2141:
2142: INSERT INTO OE_PAYMENTS
2143: ( ATTRIBUTE1

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

2258: p_hdr_pmt_id => p_header_Payment_rec.payment_number,
2259: x_index => l_index,
2260: x_return_status => l_return_status); */
2261: IF l_debug_level > 0 THEN
2262: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_Payment_UTIL.INSERT_ROW IS: ' || L_RETURN_STATUS ) ;
2263: END IF;
2264: IF l_debug_level > 0 THEN
2265: oe_debug_pub.add( 'RETURNED INDEX IS: ' || L_INDEX , 1 ) ;
2266: END IF;

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

2261: IF l_debug_level > 0 THEN
2262: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_Payment_UTIL.INSERT_ROW IS: ' || L_RETURN_STATUS ) ;
2263: END IF;
2264: IF l_debug_level > 0 THEN
2265: oe_debug_pub.add( 'RETURNED INDEX IS: ' || L_INDEX , 1 ) ;
2266: END IF;
2267:
2268: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2269: IF l_debug_level > 0 THEN

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

2266: END IF;
2267:
2268: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2269: IF l_debug_level > 0 THEN
2270: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2271: END IF;
2272: IF l_debug_level > 0 THEN
2273: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.INSERT_ROW' , 1 ) ;
2274: END IF;

Line 2273: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.INSERT_ROW' , 1 ) ;

2269: IF l_debug_level > 0 THEN
2270: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2271: END IF;
2272: IF l_debug_level > 0 THEN
2273: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.INSERT_ROW' , 1 ) ;
2274: END IF;
2275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2276: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2277: IF l_debug_level > 0 THEN

Line 2278: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.INSERT_ROW' ) ;

2274: END IF;
2275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2276: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2277: IF l_debug_level > 0 THEN
2278: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.INSERT_ROW' ) ;
2279: END IF;
2280: IF l_debug_level > 0 THEN
2281: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.INSERT_ROW' , 1 ) ;
2282: END IF;

Line 2281: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.INSERT_ROW' , 1 ) ;

2277: IF l_debug_level > 0 THEN
2278: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.INSERT_ROW' ) ;
2279: END IF;
2280: IF l_debug_level > 0 THEN
2281: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.INSERT_ROW' , 1 ) ;
2282: END IF;
2283: RAISE FND_API.G_EXC_ERROR;
2284: END IF;
2285: END IF; /*code_release_level*/

Line 2289: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.INSERT_ROW' , 1 ) ;

2285: END IF; /*code_release_level*/
2286: -- notification framework end
2287:
2288: IF l_debug_level > 0 THEN
2289: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.INSERT_ROW' , 1 ) ;
2290: END IF;
2291:
2292: EXCEPTION
2293:

Line 2295: oe_debug_pub.add('Sql error'||sqlerrm);

2291:
2292: EXCEPTION
2293:
2294: WHEN OTHERS THEN
2295: oe_debug_pub.add('Sql error'||sqlerrm);
2296: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2297: THEN
2298: oe_msg_pub.Add_Exc_Msg
2299: ( G_PKG_NAME

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

2329: -- added for notification framework
2330: l_new_header_Payment_rec OE_Order_PUB.Header_Payment_Rec_Type;
2331: l_index NUMBER;
2332: --
2333: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2334: --R12 CC Encryption
2335: l_trxn_extension_id NUMBER;
2336: l_invoice_to_org_id NUMBER;
2337: l_payment_type_code VARCHAR2(80);

Line 2341: oe_debug_pub.add( 'ENTERING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;

2337: l_payment_type_code VARCHAR2(80);
2338: --R12 CC Encryption
2339: BEGIN
2340: IF l_debug_level > 0 THEN
2341: oe_debug_pub.add( 'ENTERING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2342: END IF;
2343:
2344: IF p_header_id <> FND_API.G_MISS_NUM AND
2345: nvl(p_payment_number, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM

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

2364: x_index => l_index,
2365: x_return_status => l_return_status); */
2366:
2367: IF l_debug_level > 0 THEN
2368: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_Payment_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
2369: END IF;
2370: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2371: IF l_debug_level > 0 THEN
2372: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;

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

2368: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_Payment_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
2369: END IF;
2370: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2371: IF l_debug_level > 0 THEN
2372: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2373: END IF;
2374: IF l_debug_level > 0 THEN
2375: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2376: END IF;

Line 2375: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;

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

Line 2380: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.DELETE_ROW' ) ;

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

Line 2383: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;

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

Line 2401: oe_debug_pub.add('Deleting trxn id...'||l_pmt.trxn_extension_id);

2397: /*select invoice_to_org_id into l_invoice_to_org_id --Verify
2398: from oe_order_headers_all where
2399: header_id = p_header_id;*/
2400: IF l_debug_level > 0 THEN
2401: oe_debug_pub.add('Deleting trxn id...'||l_pmt.trxn_extension_id);
2402: oe_debug_pub.add('Invoice to org.'||l_invoice_to_org_id);
2403: END IF;
2404:
2405: OE_PAYMENT_TRXN_UTIL.Delete_Payment_Trxn

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

2398: from oe_order_headers_all where
2399: header_id = p_header_id;*/
2400: IF l_debug_level > 0 THEN
2401: oe_debug_pub.add('Deleting trxn id...'||l_pmt.trxn_extension_id);
2402: oe_debug_pub.add('Invoice to org.'||l_invoice_to_org_id);
2403: END IF;
2404:
2405: OE_PAYMENT_TRXN_UTIL.Delete_Payment_Trxn
2406: (p_header_id => p_header_id,

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

2413: x_msg_data => l_msg_data);
2414:
2415: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2416: IF l_debug_level > 0 THEN
2417: oe_debug_pub.add( 'Delete Payment at Header - UNEXPECTED ERROR' ) ;
2418: oe_debug_pub.add('Error message'||sqlerrm);
2419: oe_debug_pub.add('Msg data'||l_msg_data);
2420: END IF;
2421: IF l_debug_level > 0 THEN

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

2414:
2415: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2416: IF l_debug_level > 0 THEN
2417: oe_debug_pub.add( 'Delete Payment at Header - UNEXPECTED ERROR' ) ;
2418: oe_debug_pub.add('Error message'||sqlerrm);
2419: oe_debug_pub.add('Msg data'||l_msg_data);
2420: END IF;
2421: IF l_debug_level > 0 THEN
2422: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;

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

2415: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2416: IF l_debug_level > 0 THEN
2417: oe_debug_pub.add( 'Delete Payment at Header - UNEXPECTED ERROR' ) ;
2418: oe_debug_pub.add('Error message'||sqlerrm);
2419: oe_debug_pub.add('Msg data'||l_msg_data);
2420: END IF;
2421: IF l_debug_level > 0 THEN
2422: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2423: END IF;

Line 2422: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;

2418: oe_debug_pub.add('Error message'||sqlerrm);
2419: oe_debug_pub.add('Msg data'||l_msg_data);
2420: END IF;
2421: IF l_debug_level > 0 THEN
2422: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2423: END IF;
2424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2425: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2426: IF l_debug_level > 0 THEN

Line 2427: oe_debug_pub.add( 'Delete Payment at Header - OE_HEADER_Payment_UTIL.DELETE_ROW' ) ;

2423: END IF;
2424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2425: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2426: IF l_debug_level > 0 THEN
2427: oe_debug_pub.add( 'Delete Payment at Header - OE_HEADER_Payment_UTIL.DELETE_ROW' ) ;
2428: oe_debug_pub.add('Error message'||sqlerrm);
2429: oe_debug_pub.add('Msg data'||l_msg_data);
2430: END IF;
2431: IF l_debug_level > 0 THEN

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

2424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2425: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2426: IF l_debug_level > 0 THEN
2427: oe_debug_pub.add( 'Delete Payment at Header - OE_HEADER_Payment_UTIL.DELETE_ROW' ) ;
2428: oe_debug_pub.add('Error message'||sqlerrm);
2429: oe_debug_pub.add('Msg data'||l_msg_data);
2430: END IF;
2431: IF l_debug_level > 0 THEN
2432: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;

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

2425: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2426: IF l_debug_level > 0 THEN
2427: oe_debug_pub.add( 'Delete Payment at Header - OE_HEADER_Payment_UTIL.DELETE_ROW' ) ;
2428: oe_debug_pub.add('Error message'||sqlerrm);
2429: oe_debug_pub.add('Msg data'||l_msg_data);
2430: END IF;
2431: IF l_debug_level > 0 THEN
2432: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2433: END IF;

Line 2432: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;

2428: oe_debug_pub.add('Error message'||sqlerrm);
2429: oe_debug_pub.add('Msg data'||l_msg_data);
2430: END IF;
2431: IF l_debug_level > 0 THEN
2432: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2433: END IF;
2434: RAISE FND_API.G_EXC_ERROR;
2435: END IF;
2436: END IF;

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

2448: AND LINE_ID IS NULL;
2449:
2450: --3382262
2451: IF l_debug_level > 0 THEN
2452: oe_debug_pub.add('1: after executing delete statement against oe_payments - before delete_payment_at_header');
2453: END IF;
2454: Delete_Payment_at_header(p_header_id => p_header_id,
2455: x_return_status => l_return_status,
2456: x_msg_count => l_msg_count,

Line 2461: oe_debug_pub.add( 'Releasing all payment related holds.' , 3 ) ;

2457: x_msg_data => l_msg_data);
2458: --3382262
2459: -- Release all Prepayment holds;
2460: IF l_debug_level > 0 THEN
2461: oe_debug_pub.add( 'Releasing all payment related holds.' , 3 ) ;
2462: END IF;
2463:
2464: OE_Prepayment_PVT.Release_Prepayment_Hold
2465: ( p_header_id => p_header_id

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

2521: --ER#7479609 end
2522:
2523:
2524: IF l_debug_level > 0 THEN
2525: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_Payment_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
2526: END IF;
2527:
2528: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2529: IF l_debug_level > 0 THEN

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

2526: END IF;
2527:
2528: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2529: IF l_debug_level > 0 THEN
2530: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2531: END IF;
2532: IF l_debug_level > 0 THEN
2533: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2534: END IF;

Line 2533: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;

2529: IF l_debug_level > 0 THEN
2530: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2531: END IF;
2532: IF l_debug_level > 0 THEN
2533: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2534: END IF;
2535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2536: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2537: IF l_debug_level > 0 THEN

Line 2538: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.DELETE_ROW' ) ;

2534: END IF;
2535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2536: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2537: IF l_debug_level > 0 THEN
2538: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.DELETE_ROW' ) ;
2539: END IF;
2540: IF l_debug_level > 0 THEN
2541: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2542: END IF;

Line 2541: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;

2537: IF l_debug_level > 0 THEN
2538: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.DELETE_ROW' ) ;
2539: END IF;
2540: IF l_debug_level > 0 THEN
2541: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2542: END IF;
2543: RAISE FND_API.G_EXC_ERROR;
2544: END IF;
2545: END IF; /*code_release_level*/

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

2571:
2572: /*select invoice_to_org_id into l_invoice_to_org_id
2573: from oe_order_headers_all where header_id = p_header_id;*/
2574: IF l_debug_level > 0 THEN
2575: oe_debug_pub.add('Deleting trxn id...'||l_trxn_extension_id);
2576: oe_debug_pub.add('Invoice to org.'||l_invoice_to_org_id);
2577: END IF;
2578:
2579: OE_PAYMENT_TRXN_UTIL.Delete_Payment_Trxn

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

2572: /*select invoice_to_org_id into l_invoice_to_org_id
2573: from oe_order_headers_all where header_id = p_header_id;*/
2574: IF l_debug_level > 0 THEN
2575: oe_debug_pub.add('Deleting trxn id...'||l_trxn_extension_id);
2576: oe_debug_pub.add('Invoice to org.'||l_invoice_to_org_id);
2577: END IF;
2578:
2579: OE_PAYMENT_TRXN_UTIL.Delete_Payment_Trxn
2580: (p_header_id => p_header_id,

Line 2592: oe_debug_pub.add( '2:Delete Payment at Header - UNEXPECTED ERROR' ) ;

2588:
2589:
2590: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2591: IF l_debug_level > 0 THEN
2592: oe_debug_pub.add( '2:Delete Payment at Header - UNEXPECTED ERROR' ) ;
2593: END IF;
2594: IF l_debug_level > 0 THEN
2595: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2596: END IF;

Line 2595: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;

2591: IF l_debug_level > 0 THEN
2592: oe_debug_pub.add( '2:Delete Payment at Header - UNEXPECTED ERROR' ) ;
2593: END IF;
2594: IF l_debug_level > 0 THEN
2595: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2596: END IF;
2597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2598: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2599: IF l_debug_level > 0 THEN

Line 2600: oe_debug_pub.add( '2:Delete Payment at Header - OE_HEADER_Payment_UTIL.DELETE_ROW' ) ;

2596: END IF;
2597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2598: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2599: IF l_debug_level > 0 THEN
2600: oe_debug_pub.add( '2:Delete Payment at Header - OE_HEADER_Payment_UTIL.DELETE_ROW' ) ;
2601: END IF;
2602: IF l_debug_level > 0 THEN
2603: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2604: END IF;

Line 2603: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;

2599: IF l_debug_level > 0 THEN
2600: oe_debug_pub.add( '2:Delete Payment at Header - OE_HEADER_Payment_UTIL.DELETE_ROW' ) ;
2601: END IF;
2602: IF l_debug_level > 0 THEN
2603: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2604: END IF;
2605: RAISE FND_API.G_EXC_ERROR;
2606: END IF;
2607: END IF;

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

2613: ;
2614:
2615: --3382262
2616: IF l_debug_level > 0 THEN
2617: oe_debug_pub.add('2: after executing delete statement against oe_payments - before delete_payment_at_header');
2618: END IF;
2619: Delete_Payment_at_header(p_header_id => p_header_id,
2620: x_return_status => l_return_status,
2621: x_msg_count => l_msg_count,

Line 2629: oe_debug_pub.add( 'releasing all authorization related holds.', 3 ) ;

2625:
2626: IF l_pmt_collection_event = 'INVOICE' THEN
2627: -- release any authorization related holds.
2628: IF l_debug_level > 0 THEN
2629: oe_debug_pub.add( 'releasing all authorization related holds.', 3 ) ;
2630: END IF;
2631: OE_Verify_Payment_PUB.Release_Verify_Hold
2632: ( p_header_id => p_header_id
2633: , p_epayment_hold => 'Y'

Line 2660: oe_debug_pub.add( 'releasing all prepayment related holds.', 3 ) ;

2656:
2657: IF l_prepay_count = 0 THEN
2658: -- Release all Prepayment holds if no prepayment exists any more.
2659: IF l_debug_level > 0 THEN
2660: oe_debug_pub.add( 'releasing all prepayment related holds.', 3 ) ;
2661: END IF;
2662:
2663: OE_Prepayment_PVT.Release_Prepayment_Hold
2664: ( p_header_id => p_header_id

Line 2679: oe_debug_pub.add('exiting oe_header_Payment_util.delete_row ',1);

2675: END IF;
2676:
2677: END IF;
2678:
2679: oe_debug_pub.add('exiting oe_header_Payment_util.delete_row ',1);
2680:
2681: END IF;
2682:
2683: EXCEPTION

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

2760: AND HEADER_ID = p_header_id
2761: AND LINE_ID IS NULL);
2762:
2763: --
2764: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2765: --R12 CC Encryption Verify
2766: x_bank_account_number VARCHAR2(100);
2767: x_check_number varchar2(100);
2768: l_return_status VARCHAR2(30) := NULL ;

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

2965: AND LINE_ID IS NULL
2966: ;
2967:
2968: --
2969: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2970: --
2971: --R12 CC Encryption Verify
2972: x_bank_account_number VARCHAR2(100); --bug 5170754
2973: x_check_number varchar2(100);

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

3099: l_header_id NUMBER;
3100: l_Header_Payment_rec OE_Order_PUB.Header_Payment_Rec_Type;
3101: l_lock_control NUMBER;
3102: --
3103: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3104: --
3105: BEGIN
3106:
3107: IF l_debug_level > 0 THEN

Line 3108: oe_debug_pub.add( 'ENTERING OE_HEADER_Payment_UTIL.LOCK_ROW' , 1 ) ;

3104: --
3105: BEGIN
3106:
3107: IF l_debug_level > 0 THEN
3108: oe_debug_pub.add( 'ENTERING OE_HEADER_Payment_UTIL.LOCK_ROW' , 1 ) ;
3109: END IF;
3110:
3111: SAVEPOINT Lock_Row;
3112:

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

3131: AND line_id is null
3132: FOR UPDATE NOWAIT;
3133:
3134: IF l_debug_level > 0 THEN
3135: oe_debug_pub.add( 'SELECTED FOR UPDATE' , 1 ) ;
3136: END IF;
3137:
3138: OE_Header_Payment_Util.Query_Row
3139: (p_payment_number => l_payment_number

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

3248: FOR UPDATE NOWAIT;
3249:
3250: l_payment_number NUMBER;
3251: --
3252: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3253: --
3254: BEGIN
3255:
3256: IF l_debug_level > 0 THEN

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

3253: --
3254: BEGIN
3255:
3256: IF l_debug_level > 0 THEN
3257: oe_debug_pub.add( 'ENTERING OE_HEADER_PaymentS_UTIL.LOCK_ROWS' , 1 ) ;
3258: END IF;
3259: /*
3260: IF (p_payment_number IS NOT NULL AND
3261: p_payment_number <> FND_API.G_MISS_NUM) AND

Line 3331: oe_debug_pub.add( 'EXITING OE_HEADER_PaymentS_UTIL.LOCK_ROWS' , 1 ) ;

3327:
3328: x_return_status := FND_API.G_RET_STS_SUCCESS;
3329:
3330: IF l_debug_level > 0 THEN
3331: oe_debug_pub.add( 'EXITING OE_HEADER_PaymentS_UTIL.LOCK_ROWS' , 1 ) ;
3332: END IF;
3333:
3334: EXCEPTION
3335: WHEN NO_DATA_FOUND THEN

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

3375: )RETURN OE_Order_PUB.Header_Payment_Val_Rec_Type
3376: IS
3377: l_Header_Payment_val_rec OE_Order_PUB.Header_Payment_Val_Rec_Type;
3378: --
3379: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3380: --
3381: BEGIN
3382:
3383: IF (p_Header_Payment_rec.payment_collection_event IS NULL OR

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

3422: )
3423: IS
3424:
3425: --
3426: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3427: --
3428: BEGIN
3429:
3430: -- initialize return_status.

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

3567: l_bank_acct_uses_id NUMBER;
3568: l_hdr_inv_to_cust_id NUMBER;
3569: l_trx_date DATE;
3570: --
3571: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3572: --
3573: --R12 CC Encryption
3574: l_update_card_flag VARCHAR2(1) := 'N';
3575: l_trxn_extension_id NUMBER;

Line 3586: oe_debug_pub.add( 'entering oe_header_payment_util.Pre_Write_Process. payment_type_code'||p_x_header_Payment_rec.payment_type_code);

3582:
3583: BEGIN
3584:
3585: IF l_debug_level > 0 THEN
3586: oe_debug_pub.add( 'entering oe_header_payment_util.Pre_Write_Process. payment_type_code'||p_x_header_Payment_rec.payment_type_code);
3587: END IF;
3588: --R12 CC Encryption
3589: --Querying the invoice to org id before checking the payment type
3590: --as it is needed for both credit card and check payments.

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

3593: from oe_order_headers
3594: where header_id=p_x_header_Payment_rec.header_id;
3595:
3596: IF l_debug_level > 0 THEN
3597: oe_debug_pub.add( 'l_transactional_curr_code:'||l_transactional_curr_code||':l_invoice_to_org_id:'||l_invoice_to_org_id);
3598: oe_debug_pub.add(' old trxn extn id ksurendr'||p_old_header_Payment_rec.trxn_extension_id);
3599: END IF;
3600:
3601: --For payment types like Credit Card, ACH and Direct Debit, the processing

Line 3598: oe_debug_pub.add(' old trxn extn id ksurendr'||p_old_header_Payment_rec.trxn_extension_id);

3594: where header_id=p_x_header_Payment_rec.header_id;
3595:
3596: IF l_debug_level > 0 THEN
3597: oe_debug_pub.add( 'l_transactional_curr_code:'||l_transactional_curr_code||':l_invoice_to_org_id:'||l_invoice_to_org_id);
3598: oe_debug_pub.add(' old trxn extn id ksurendr'||p_old_header_Payment_rec.trxn_extension_id);
3599: END IF;
3600:
3601: --For payment types like Credit Card, ACH and Direct Debit, the processing
3602: --is handled in OE_PAYMENT_TRXN_UTIL package. So need to modify this part

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

3611: WHERE organization_id = l_invoice_to_org_id;
3612: EXCEPTION
3613: WHEN OTHERS THEN
3614: IF l_debug_level > 0 THEN
3615: oe_debug_pub.add( 'IN OTHERS EXCEPTION ( OE_INVOICE_TO_ORGS_V ) '||SQLERRM , 1 ) ;
3616: END IF;
3617: END;
3618:
3619: IF l_debug_level > 0 THEN

Line 3620: oe_debug_pub.add('l_hdr_inv_to_cust_id -->' || l_hdr_inv_to_cust_id );

3616: END IF;
3617: END;
3618:
3619: IF l_debug_level > 0 THEN
3620: oe_debug_pub.add('l_hdr_inv_to_cust_id -->' || l_hdr_inv_to_cust_id );
3621: oe_debug_pub.add('p_site_use_id --->'||l_invoice_to_org_id);
3622: --oe_debug_pub.add('cc number : ' || p_x_header_payment_rec.credit_card_number );
3623: --oe_debug_pub.add('cc name : ' || p_x_header_payment_rec.credit_card_holder_name );
3624: --oe_debug_pub.add('exp date : ' || to_char(p_x_header_payment_rec.credit_card_expiration_date, 'DD-MON-YYYY') );

Line 3621: oe_debug_pub.add('p_site_use_id --->'||l_invoice_to_org_id);

3617: END;
3618:
3619: IF l_debug_level > 0 THEN
3620: oe_debug_pub.add('l_hdr_inv_to_cust_id -->' || l_hdr_inv_to_cust_id );
3621: oe_debug_pub.add('p_site_use_id --->'||l_invoice_to_org_id);
3622: --oe_debug_pub.add('cc number : ' || p_x_header_payment_rec.credit_card_number );
3623: --oe_debug_pub.add('cc name : ' || p_x_header_payment_rec.credit_card_holder_name );
3624: --oe_debug_pub.add('exp date : ' || to_char(p_x_header_payment_rec.credit_card_expiration_date, 'DD-MON-YYYY') );
3625: oe_debug_pub.add('instr id...'||p_x_header_payment_rec.cc_instrument_id);

Line 3622: --oe_debug_pub.add('cc number : ' || p_x_header_payment_rec.credit_card_number );

3618:
3619: IF l_debug_level > 0 THEN
3620: oe_debug_pub.add('l_hdr_inv_to_cust_id -->' || l_hdr_inv_to_cust_id );
3621: oe_debug_pub.add('p_site_use_id --->'||l_invoice_to_org_id);
3622: --oe_debug_pub.add('cc number : ' || p_x_header_payment_rec.credit_card_number );
3623: --oe_debug_pub.add('cc name : ' || p_x_header_payment_rec.credit_card_holder_name );
3624: --oe_debug_pub.add('exp date : ' || to_char(p_x_header_payment_rec.credit_card_expiration_date, 'DD-MON-YYYY') );
3625: oe_debug_pub.add('instr id...'||p_x_header_payment_rec.cc_instrument_id);
3626: oe_debug_pub.add('instr assgn id'||p_x_header_payment_rec.cc_instrument_assignment_id);

Line 3623: --oe_debug_pub.add('cc name : ' || p_x_header_payment_rec.credit_card_holder_name );

3619: IF l_debug_level > 0 THEN
3620: oe_debug_pub.add('l_hdr_inv_to_cust_id -->' || l_hdr_inv_to_cust_id );
3621: oe_debug_pub.add('p_site_use_id --->'||l_invoice_to_org_id);
3622: --oe_debug_pub.add('cc number : ' || p_x_header_payment_rec.credit_card_number );
3623: --oe_debug_pub.add('cc name : ' || p_x_header_payment_rec.credit_card_holder_name );
3624: --oe_debug_pub.add('exp date : ' || to_char(p_x_header_payment_rec.credit_card_expiration_date, 'DD-MON-YYYY') );
3625: oe_debug_pub.add('instr id...'||p_x_header_payment_rec.cc_instrument_id);
3626: oe_debug_pub.add('instr assgn id'||p_x_header_payment_rec.cc_instrument_assignment_id);
3627: oe_debug_pub.add('Operation...'||p_x_header_Payment_rec.operation);

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

3620: oe_debug_pub.add('l_hdr_inv_to_cust_id -->' || l_hdr_inv_to_cust_id );
3621: oe_debug_pub.add('p_site_use_id --->'||l_invoice_to_org_id);
3622: --oe_debug_pub.add('cc number : ' || p_x_header_payment_rec.credit_card_number );
3623: --oe_debug_pub.add('cc name : ' || p_x_header_payment_rec.credit_card_holder_name );
3624: --oe_debug_pub.add('exp date : ' || to_char(p_x_header_payment_rec.credit_card_expiration_date, 'DD-MON-YYYY') );
3625: oe_debug_pub.add('instr id...'||p_x_header_payment_rec.cc_instrument_id);
3626: oe_debug_pub.add('instr assgn id'||p_x_header_payment_rec.cc_instrument_assignment_id);
3627: oe_debug_pub.add('Operation...'||p_x_header_Payment_rec.operation);
3628: oe_debug_pub.add('trxn extn id'||p_x_header_Payment_rec.trxn_extension_id);

Line 3625: oe_debug_pub.add('instr id...'||p_x_header_payment_rec.cc_instrument_id);

3621: oe_debug_pub.add('p_site_use_id --->'||l_invoice_to_org_id);
3622: --oe_debug_pub.add('cc number : ' || p_x_header_payment_rec.credit_card_number );
3623: --oe_debug_pub.add('cc name : ' || p_x_header_payment_rec.credit_card_holder_name );
3624: --oe_debug_pub.add('exp date : ' || to_char(p_x_header_payment_rec.credit_card_expiration_date, 'DD-MON-YYYY') );
3625: oe_debug_pub.add('instr id...'||p_x_header_payment_rec.cc_instrument_id);
3626: oe_debug_pub.add('instr assgn id'||p_x_header_payment_rec.cc_instrument_assignment_id);
3627: oe_debug_pub.add('Operation...'||p_x_header_Payment_rec.operation);
3628: oe_debug_pub.add('trxn extn id'||p_x_header_Payment_rec.trxn_extension_id);
3629: --oe_debug_pub.add('New name'||p_x_header_Payment_rec.credit_card_holder_name);

Line 3626: oe_debug_pub.add('instr assgn id'||p_x_header_payment_rec.cc_instrument_assignment_id);

3622: --oe_debug_pub.add('cc number : ' || p_x_header_payment_rec.credit_card_number );
3623: --oe_debug_pub.add('cc name : ' || p_x_header_payment_rec.credit_card_holder_name );
3624: --oe_debug_pub.add('exp date : ' || to_char(p_x_header_payment_rec.credit_card_expiration_date, 'DD-MON-YYYY') );
3625: oe_debug_pub.add('instr id...'||p_x_header_payment_rec.cc_instrument_id);
3626: oe_debug_pub.add('instr assgn id'||p_x_header_payment_rec.cc_instrument_assignment_id);
3627: oe_debug_pub.add('Operation...'||p_x_header_Payment_rec.operation);
3628: oe_debug_pub.add('trxn extn id'||p_x_header_Payment_rec.trxn_extension_id);
3629: --oe_debug_pub.add('New name'||p_x_header_Payment_rec.credit_card_holder_name);
3630: --oe_debug_pub.add('Old name'||p_old_header_Payment_rec.credit_card_holder_name);

Line 3627: oe_debug_pub.add('Operation...'||p_x_header_Payment_rec.operation);

3623: --oe_debug_pub.add('cc name : ' || p_x_header_payment_rec.credit_card_holder_name );
3624: --oe_debug_pub.add('exp date : ' || to_char(p_x_header_payment_rec.credit_card_expiration_date, 'DD-MON-YYYY') );
3625: oe_debug_pub.add('instr id...'||p_x_header_payment_rec.cc_instrument_id);
3626: oe_debug_pub.add('instr assgn id'||p_x_header_payment_rec.cc_instrument_assignment_id);
3627: oe_debug_pub.add('Operation...'||p_x_header_Payment_rec.operation);
3628: oe_debug_pub.add('trxn extn id'||p_x_header_Payment_rec.trxn_extension_id);
3629: --oe_debug_pub.add('New name'||p_x_header_Payment_rec.credit_card_holder_name);
3630: --oe_debug_pub.add('Old name'||p_old_header_Payment_rec.credit_card_holder_name);
3631: --Bug 7460481

Line 3628: oe_debug_pub.add('trxn extn id'||p_x_header_Payment_rec.trxn_extension_id);

3624: --oe_debug_pub.add('exp date : ' || to_char(p_x_header_payment_rec.credit_card_expiration_date, 'DD-MON-YYYY') );
3625: oe_debug_pub.add('instr id...'||p_x_header_payment_rec.cc_instrument_id);
3626: oe_debug_pub.add('instr assgn id'||p_x_header_payment_rec.cc_instrument_assignment_id);
3627: oe_debug_pub.add('Operation...'||p_x_header_Payment_rec.operation);
3628: oe_debug_pub.add('trxn extn id'||p_x_header_Payment_rec.trxn_extension_id);
3629: --oe_debug_pub.add('New name'||p_x_header_Payment_rec.credit_card_holder_name);
3630: --oe_debug_pub.add('Old name'||p_old_header_Payment_rec.credit_card_holder_name);
3631: --Bug 7460481
3632: --oe_debug_pub.add('New Approval Code'||p_x_header_Payment_rec.credit_card_approval_code);

Line 3629: --oe_debug_pub.add('New name'||p_x_header_Payment_rec.credit_card_holder_name);

3625: oe_debug_pub.add('instr id...'||p_x_header_payment_rec.cc_instrument_id);
3626: oe_debug_pub.add('instr assgn id'||p_x_header_payment_rec.cc_instrument_assignment_id);
3627: oe_debug_pub.add('Operation...'||p_x_header_Payment_rec.operation);
3628: oe_debug_pub.add('trxn extn id'||p_x_header_Payment_rec.trxn_extension_id);
3629: --oe_debug_pub.add('New name'||p_x_header_Payment_rec.credit_card_holder_name);
3630: --oe_debug_pub.add('Old name'||p_old_header_Payment_rec.credit_card_holder_name);
3631: --Bug 7460481
3632: --oe_debug_pub.add('New Approval Code'||p_x_header_Payment_rec.credit_card_approval_code);
3633: --oe_debug_pub.add('Old Approval Code'||p_old_header_Payment_rec.credit_card_approval_code);

Line 3630: --oe_debug_pub.add('Old name'||p_old_header_Payment_rec.credit_card_holder_name);

3626: oe_debug_pub.add('instr assgn id'||p_x_header_payment_rec.cc_instrument_assignment_id);
3627: oe_debug_pub.add('Operation...'||p_x_header_Payment_rec.operation);
3628: oe_debug_pub.add('trxn extn id'||p_x_header_Payment_rec.trxn_extension_id);
3629: --oe_debug_pub.add('New name'||p_x_header_Payment_rec.credit_card_holder_name);
3630: --oe_debug_pub.add('Old name'||p_old_header_Payment_rec.credit_card_holder_name);
3631: --Bug 7460481
3632: --oe_debug_pub.add('New Approval Code'||p_x_header_Payment_rec.credit_card_approval_code);
3633: --oe_debug_pub.add('Old Approval Code'||p_old_header_Payment_rec.credit_card_approval_code);
3634: --oe_debug_pub.add('New Approval Date'||p_x_header_Payment_rec.credit_card_approval_date);

Line 3632: --oe_debug_pub.add('New Approval Code'||p_x_header_Payment_rec.credit_card_approval_code);

3628: oe_debug_pub.add('trxn extn id'||p_x_header_Payment_rec.trxn_extension_id);
3629: --oe_debug_pub.add('New name'||p_x_header_Payment_rec.credit_card_holder_name);
3630: --oe_debug_pub.add('Old name'||p_old_header_Payment_rec.credit_card_holder_name);
3631: --Bug 7460481
3632: --oe_debug_pub.add('New Approval Code'||p_x_header_Payment_rec.credit_card_approval_code);
3633: --oe_debug_pub.add('Old Approval Code'||p_old_header_Payment_rec.credit_card_approval_code);
3634: --oe_debug_pub.add('New Approval Date'||p_x_header_Payment_rec.credit_card_approval_date);
3635: --oe_debug_pub.add('Old Approval Date'||p_old_header_Payment_rec.credit_card_approval_date);
3636: END IF;

Line 3633: --oe_debug_pub.add('Old Approval Code'||p_old_header_Payment_rec.credit_card_approval_code);

3629: --oe_debug_pub.add('New name'||p_x_header_Payment_rec.credit_card_holder_name);
3630: --oe_debug_pub.add('Old name'||p_old_header_Payment_rec.credit_card_holder_name);
3631: --Bug 7460481
3632: --oe_debug_pub.add('New Approval Code'||p_x_header_Payment_rec.credit_card_approval_code);
3633: --oe_debug_pub.add('Old Approval Code'||p_old_header_Payment_rec.credit_card_approval_code);
3634: --oe_debug_pub.add('New Approval Date'||p_x_header_Payment_rec.credit_card_approval_date);
3635: --oe_debug_pub.add('Old Approval Date'||p_old_header_Payment_rec.credit_card_approval_date);
3636: END IF;
3637:

Line 3634: --oe_debug_pub.add('New Approval Date'||p_x_header_Payment_rec.credit_card_approval_date);

3630: --oe_debug_pub.add('Old name'||p_old_header_Payment_rec.credit_card_holder_name);
3631: --Bug 7460481
3632: --oe_debug_pub.add('New Approval Code'||p_x_header_Payment_rec.credit_card_approval_code);
3633: --oe_debug_pub.add('Old Approval Code'||p_old_header_Payment_rec.credit_card_approval_code);
3634: --oe_debug_pub.add('New Approval Date'||p_x_header_Payment_rec.credit_card_approval_date);
3635: --oe_debug_pub.add('Old Approval Date'||p_old_header_Payment_rec.credit_card_approval_date);
3636: END IF;
3637:
3638: IF p_x_header_Payment_rec.trxn_extension_id IS NOT NULL AND

Line 3635: --oe_debug_pub.add('Old Approval Date'||p_old_header_Payment_rec.credit_card_approval_date);

3631: --Bug 7460481
3632: --oe_debug_pub.add('New Approval Code'||p_x_header_Payment_rec.credit_card_approval_code);
3633: --oe_debug_pub.add('Old Approval Code'||p_old_header_Payment_rec.credit_card_approval_code);
3634: --oe_debug_pub.add('New Approval Date'||p_x_header_Payment_rec.credit_card_approval_date);
3635: --oe_debug_pub.add('Old Approval Date'||p_old_header_Payment_rec.credit_card_approval_date);
3636: END IF;
3637:
3638: IF p_x_header_Payment_rec.trxn_extension_id IS NOT NULL AND
3639: p_x_header_Payment_rec.trxn_extension_id <> FND_API.G_MISS_NUM

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

3654: X_return_status => l_return_status,
3655: X_msg_count => l_msg_count,
3656: X_msg_data => l_msg_data);
3657: IF l_debug_level>0 THEN
3658: oe_debug_pub.add('New trxn extension id after calling Copy_Payment_TRXN:'||l_trxn_extension_id);
3659: END IF;
3660: EXCEPTION
3661: WHEN FND_API.G_EXC_ERROR THEN
3662: l_return_status := FND_API.G_RET_STS_ERROR;

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

3662: l_return_status := FND_API.G_RET_STS_ERROR;
3663: RAISE FND_API.G_EXC_ERROR;
3664: WHEN OTHERS THEN
3665: IF l_debug_level>0 THEN
3666: oe_debug_pub.add('After call to copy payment trxn - exception');
3667: END IF;
3668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3669: END;
3670:

Line 3676: oe_debug_pub.add('trxn id'||p_x_header_payment_rec.trxn_Extension_id);

3672:
3673: ELSIF p_x_header_payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3674:
3675: IF l_debug_level > 0 THEN
3676: oe_debug_pub.add('trxn id'||p_x_header_payment_rec.trxn_Extension_id);
3677: oe_debug_pub.add('payemnt type'||p_x_header_payment_rec.payment_type_Code);
3678: IF OE_GLOBALS.Is_Same_Credit_Card(p_old_Header_Payment_rec.credit_card_number,
3679: p_x_Header_Payment_rec.credit_card_number,
3680: p_old_Header_Payment_rec.cc_instrument_id,

Line 3677: oe_debug_pub.add('payemnt type'||p_x_header_payment_rec.payment_type_Code);

3673: ELSIF p_x_header_payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3674:
3675: IF l_debug_level > 0 THEN
3676: oe_debug_pub.add('trxn id'||p_x_header_payment_rec.trxn_Extension_id);
3677: oe_debug_pub.add('payemnt type'||p_x_header_payment_rec.payment_type_Code);
3678: IF OE_GLOBALS.Is_Same_Credit_Card(p_old_Header_Payment_rec.credit_card_number,
3679: p_x_Header_Payment_rec.credit_card_number,
3680: p_old_Header_Payment_rec.cc_instrument_id,
3681: p_x_Header_Payment_rec.cc_instrument_id) THEN

Line 3682: oe_debug_pub.add('same cc true');

3678: IF OE_GLOBALS.Is_Same_Credit_Card(p_old_Header_Payment_rec.credit_card_number,
3679: p_x_Header_Payment_rec.credit_card_number,
3680: p_old_Header_Payment_rec.cc_instrument_id,
3681: p_x_Header_Payment_rec.cc_instrument_id) THEN
3682: oe_debug_pub.add('same cc true');
3683: ELSE
3684: oe_debug_pub.add('diff cc');
3685: END IF;
3686: if OE_GLOBALS.Equal(p_old_header_Payment_rec.credit_card_holder_name,

Line 3684: oe_debug_pub.add('diff cc');

3680: p_old_Header_Payment_rec.cc_instrument_id,
3681: p_x_Header_Payment_rec.cc_instrument_id) THEN
3682: oe_debug_pub.add('same cc true');
3683: ELSE
3684: oe_debug_pub.add('diff cc');
3685: END IF;
3686: if OE_GLOBALS.Equal(p_old_header_Payment_rec.credit_card_holder_name,
3687: p_x_header_Payment_rec.credit_card_holder_name) THEN
3688: oe_debug_pub.add('Same name');

Line 3688: oe_debug_pub.add('Same name');

3684: oe_debug_pub.add('diff cc');
3685: END IF;
3686: if OE_GLOBALS.Equal(p_old_header_Payment_rec.credit_card_holder_name,
3687: p_x_header_Payment_rec.credit_card_holder_name) THEN
3688: oe_debug_pub.add('Same name');
3689: ELSE
3690: oe_debug_pub.add('Diff name');
3691: END IF;
3692: if OE_GLOBALS.Equal(p_old_header_Payment_rec.credit_card_expiration_date,

Line 3690: oe_debug_pub.add('Diff name');

3686: if OE_GLOBALS.Equal(p_old_header_Payment_rec.credit_card_holder_name,
3687: p_x_header_Payment_rec.credit_card_holder_name) THEN
3688: oe_debug_pub.add('Same name');
3689: ELSE
3690: oe_debug_pub.add('Diff name');
3691: END IF;
3692: if OE_GLOBALS.Equal(p_old_header_Payment_rec.credit_card_expiration_date,
3693: p_x_header_Payment_rec.credit_card_expiration_date) THEN
3694: oe_debug_pub.add('Same date');

Line 3694: oe_debug_pub.add('Same date');

3690: oe_debug_pub.add('Diff name');
3691: END IF;
3692: if OE_GLOBALS.Equal(p_old_header_Payment_rec.credit_card_expiration_date,
3693: p_x_header_Payment_rec.credit_card_expiration_date) THEN
3694: oe_debug_pub.add('Same date');
3695: ELSE
3696: oe_debug_pub.add('Diff date');
3697: END IF;
3698: if OE_GLOBALS.Equal(p_old_header_payment_rec.instrument_security_code,

Line 3696: oe_debug_pub.add('Diff date');

3692: if OE_GLOBALS.Equal(p_old_header_Payment_rec.credit_card_expiration_date,
3693: p_x_header_Payment_rec.credit_card_expiration_date) THEN
3694: oe_debug_pub.add('Same date');
3695: ELSE
3696: oe_debug_pub.add('Diff date');
3697: END IF;
3698: if OE_GLOBALS.Equal(p_old_header_payment_rec.instrument_security_code,
3699: p_x_header_payment_rec.instrument_security_code) THEN
3700: oe_debug_pub.add('Same cvv2');

Line 3700: oe_debug_pub.add('Same cvv2');

3696: oe_debug_pub.add('Diff date');
3697: END IF;
3698: if OE_GLOBALS.Equal(p_old_header_payment_rec.instrument_security_code,
3699: p_x_header_payment_rec.instrument_security_code) THEN
3700: oe_debug_pub.add('Same cvv2');
3701: ELSE
3702: oe_debug_pub.add('Diff cvv2');
3703: END IF;
3704: if OE_GLOBALS.Equal(p_x_header_Payment_rec.payment_trx_id,

Line 3702: oe_debug_pub.add('Diff cvv2');

3698: if OE_GLOBALS.Equal(p_old_header_payment_rec.instrument_security_code,
3699: p_x_header_payment_rec.instrument_security_code) THEN
3700: oe_debug_pub.add('Same cvv2');
3701: ELSE
3702: oe_debug_pub.add('Diff cvv2');
3703: END IF;
3704: if OE_GLOBALS.Equal(p_x_header_Payment_rec.payment_trx_id,
3705: p_old_header_Payment_rec.payment_trx_id) THEN
3706: oe_debug_pub.add('Same trxid');

Line 3706: oe_debug_pub.add('Same trxid');

3702: oe_debug_pub.add('Diff cvv2');
3703: END IF;
3704: if OE_GLOBALS.Equal(p_x_header_Payment_rec.payment_trx_id,
3705: p_old_header_Payment_rec.payment_trx_id) THEN
3706: oe_debug_pub.add('Same trxid');
3707: ELSE
3708: oe_debug_pub.add('Diff trxid');
3709: END IF;
3710: --Bug 7460481

Line 3708: oe_debug_pub.add('Diff trxid');

3704: if OE_GLOBALS.Equal(p_x_header_Payment_rec.payment_trx_id,
3705: p_old_header_Payment_rec.payment_trx_id) THEN
3706: oe_debug_pub.add('Same trxid');
3707: ELSE
3708: oe_debug_pub.add('Diff trxid');
3709: END IF;
3710: --Bug 7460481
3711: IF OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_approval_code,
3712: p_old_header_Payment_rec.credit_card_approval_code) THEN

Line 3713: oe_debug_pub.add('Same approval code');

3709: END IF;
3710: --Bug 7460481
3711: IF OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_approval_code,
3712: p_old_header_Payment_rec.credit_card_approval_code) THEN
3713: oe_debug_pub.add('Same approval code');
3714: ELSE
3715: oe_debug_pub.add('Diff approval code');
3716: END IF;
3717: END IF;

Line 3715: oe_debug_pub.add('Diff approval code');

3711: IF OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_approval_code,
3712: p_old_header_Payment_rec.credit_card_approval_code) THEN
3713: oe_debug_pub.add('Same approval code');
3714: ELSE
3715: oe_debug_pub.add('Diff approval code');
3716: END IF;
3717: END IF;
3718: IF p_x_header_payment_rec.trxn_extension_id IS NOT NULL
3719: AND p_x_header_payment_rec.trxn_extension_id <> FND_API.G_MISS_NUM

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

3738: OR (p_x_header_Payment_rec.payment_type_code IN ('CASH','WIRE_TRANSFER'))) THEN
3739:
3740: --no operation is needed as payment information did not change
3741: IF l_debug_level > 0 THEN
3742: oe_debug_pub.add('No change to payments attributes...');
3743: END IF;
3744: NULL;
3745:
3746: --While changing the payment type from cash, check etc to

Line 3752: oe_debug_pub.add( 'getting payment_trx_id as cc details changed');

3748: --transaction extension id would be null.
3749: ELSIF p_x_header_payment_rec.trxn_extension_id is null or
3750: p_x_header_payment_rec.trxn_extension_id =FND_API.G_MISS_NUM THEN
3751: IF l_debug_level > 0 THEN
3752: oe_debug_pub.add( 'getting payment_trx_id as cc details changed');
3753: oe_debug_pub.add('Operation is Update and trxn extension id is null');
3754: oe_debug_pub.add('Payment type has changed from check or cash to one which requires trxn extension id...');
3755: END IF;
3756:

Line 3753: oe_debug_pub.add('Operation is Update and trxn extension id is null');

3749: ELSIF p_x_header_payment_rec.trxn_extension_id is null or
3750: p_x_header_payment_rec.trxn_extension_id =FND_API.G_MISS_NUM THEN
3751: IF l_debug_level > 0 THEN
3752: oe_debug_pub.add( 'getting payment_trx_id as cc details changed');
3753: oe_debug_pub.add('Operation is Update and trxn extension id is null');
3754: oe_debug_pub.add('Payment type has changed from check or cash to one which requires trxn extension id...');
3755: END IF;
3756:
3757: -- validate cc security code

Line 3754: oe_debug_pub.add('Payment type has changed from check or cash to one which requires trxn extension id...');

3750: p_x_header_payment_rec.trxn_extension_id =FND_API.G_MISS_NUM THEN
3751: IF l_debug_level > 0 THEN
3752: oe_debug_pub.add( 'getting payment_trx_id as cc details changed');
3753: oe_debug_pub.add('Operation is Update and trxn extension id is null');
3754: oe_debug_pub.add('Payment type has changed from check or cash to one which requires trxn extension id...');
3755: END IF;
3756:
3757: -- validate cc security code
3758: IF p_x_Header_Payment_rec.payment_type_code = 'CREDIT_CARD' THEN

Line 3821: oe_debug_pub.add('New trxn extension id after calling Create_Payment_TRXN:'||p_x_header_payment_rec.trxn_extension_id);

3817: X_msg_count => l_msg_count,
3818: X_msg_data => l_msg_data);
3819:
3820: IF l_debug_level > 0 THEN
3821: oe_debug_pub.add('New trxn extension id after calling Create_Payment_TRXN:'||p_x_header_payment_rec.trxn_extension_id);
3822: END IF;
3823: Exception
3824: WHEN FND_API.G_EXC_ERROR THEN
3825: OE_MSG_PUB.Count_And_Get

Line 3840: oe_debug_pub.add( 'OEXUHPMB: ERROR IN ARP_BANK_PKG.PROCESS_CUST_BANK_ACCOUNT'||l_msg_data ) ;

3836: );
3837: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
3838: OE_MSG_PUB.ADD;
3839: IF l_debug_level > 0 THEN
3840: oe_debug_pub.add( 'OEXUHPMB: ERROR IN ARP_BANK_PKG.PROCESS_CUST_BANK_ACCOUNT'||l_msg_data ) ;
3841: oe_debug_pub.add('Error messsge ksurendr'||l_return_status);
3842: END IF;
3843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3844: end;

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

3837: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
3838: OE_MSG_PUB.ADD;
3839: IF l_debug_level > 0 THEN
3840: oe_debug_pub.add( 'OEXUHPMB: ERROR IN ARP_BANK_PKG.PROCESS_CUST_BANK_ACCOUNT'||l_msg_data ) ;
3841: oe_debug_pub.add('Error messsge ksurendr'||l_return_status);
3842: END IF;
3843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3844: end;
3845:

Line 3847: oe_debug_pub.add( 'Return status...'||l_return_status );

3843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3844: end;
3845:
3846: IF l_debug_level > 0 THEN
3847: oe_debug_pub.add( 'Return status...'||l_return_status );
3848: END IF;
3849:
3850: p_x_header_payment_rec.payment_trx_id := l_bank_acct_id;
3851: ELSE

Line 3892: oe_debug_pub.add('b4 call to update pay...');

3888: OR NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_expiration_date,
3889: p_old_header_Payment_rec.credit_card_expiration_date) THEN
3890: l_update_card_flag := 'Y';
3891: END IF;
3892: oe_debug_pub.add('b4 call to update pay...');
3893: oe_debug_pub.add('Payment trx id'||p_x_header_payment_rec.payment_trx_id);
3894: OE_PAYMENT_TRXN_UTIL.Update_Payment_TRXN
3895: (P_header_id => p_x_header_Payment_rec.header_id,
3896: p_line_id => p_x_header_payment_rec.line_id,

Line 3893: oe_debug_pub.add('Payment trx id'||p_x_header_payment_rec.payment_trx_id);

3889: p_old_header_Payment_rec.credit_card_expiration_date) THEN
3890: l_update_card_flag := 'Y';
3891: END IF;
3892: oe_debug_pub.add('b4 call to update pay...');
3893: oe_debug_pub.add('Payment trx id'||p_x_header_payment_rec.payment_trx_id);
3894: OE_PAYMENT_TRXN_UTIL.Update_Payment_TRXN
3895: (P_header_id => p_x_header_Payment_rec.header_id,
3896: p_line_id => p_x_header_payment_rec.line_id,
3897: p_cust_id => l_hdr_inv_to_cust_id,

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

3916: X_return_status => l_return_status,
3917: X_msg_count => l_msg_count,
3918: X_msg_data => l_msg_data);
3919: IF l_debug_level > 0 THEN
3920: oe_debug_pub.add('trxn extension id after calling Update_Payment_TRXN:'||p_x_header_payment_rec.trxn_extension_id);
3921: END IF;
3922: EXCEPTION
3923: WHEN FND_API.G_EXC_ERROR THEN
3924:

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

3922: EXCEPTION
3923: WHEN FND_API.G_EXC_ERROR THEN
3924:
3925: IF l_debug_level > 0 THEN
3926: oe_debug_pub.add('Update_Payment_TRXN error....exc');
3927: oe_debug_pub.add('After call to Update_Payment_TRXN'||l_return_status);
3928: oe_debug_pub.add('Error'||sqlerrm);
3929: END IF;
3930: l_return_status := FND_API.G_RET_STS_ERROR;

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

3923: WHEN FND_API.G_EXC_ERROR THEN
3924:
3925: IF l_debug_level > 0 THEN
3926: oe_debug_pub.add('Update_Payment_TRXN error....exc');
3927: oe_debug_pub.add('After call to Update_Payment_TRXN'||l_return_status);
3928: oe_debug_pub.add('Error'||sqlerrm);
3929: END IF;
3930: l_return_status := FND_API.G_RET_STS_ERROR;
3931: OE_MSG_PUB.Count_And_Get

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

3924:
3925: IF l_debug_level > 0 THEN
3926: oe_debug_pub.add('Update_Payment_TRXN error....exc');
3927: oe_debug_pub.add('After call to Update_Payment_TRXN'||l_return_status);
3928: oe_debug_pub.add('Error'||sqlerrm);
3929: END IF;
3930: l_return_status := FND_API.G_RET_STS_ERROR;
3931: OE_MSG_PUB.Count_And_Get
3932: ( p_count => l_msg_count,

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

3939: ( p_count => l_msg_count,
3940: p_data => l_msg_data
3941: );
3942: IF l_debug_level > 0 THEN
3943: oe_debug_pub.add('After call to Update_Payment_TRXN --> Unexpected error');
3944: oe_debug_pub.add('Error message '||sqlerrm);
3945: END IF;
3946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3947: END;

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

3940: p_data => l_msg_data
3941: );
3942: IF l_debug_level > 0 THEN
3943: oe_debug_pub.add('After call to Update_Payment_TRXN --> Unexpected error');
3944: oe_debug_pub.add('Error message '||sqlerrm);
3945: END IF;
3946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3947: END;
3948:

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

3948:
3949: END IF;
3950:
3951: IF l_debug_level > 0 THEN
3952: oe_debug_pub.add( 'id already derived for this credit card');
3953: END IF;
3954:
3955: ELSIF p_x_header_payment_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN --not a copy order Verify
3956:

Line 3958: oe_debug_pub.add( 'getting payment_trx_id as cc details changed');

3954:
3955: ELSIF p_x_header_payment_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN --not a copy order Verify
3956:
3957: IF l_debug_level > 0 THEN
3958: oe_debug_pub.add( 'getting payment_trx_id as cc details changed');
3959: END IF;
3960:
3961: /*l_trx_date := nvl(l_ordered_date, sysdate)
3962: - nvl( to_number(fnd_profile.value('ONT_DAYS_TO_BACKDATE_BANK_ACCT')), 0);*/

Line 3988: oe_debug_pub.add('credit card details changed!');

3984: p_x_Header_Payment_rec.cc_instrument_id)
3985: OR NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_code,
3986: p_old_header_Payment_rec.credit_card_code) THEN
3987: IF l_debug_level > 0 THEN
3988: oe_debug_pub.add('credit card details changed!');
3989: END IF;
3990:
3991: IF NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_holder_name,
3992: p_old_header_Payment_rec.credit_card_holder_name)

Line 3996: oe_debug_pub.add('Need to call update_card API');

3992: p_old_header_Payment_rec.credit_card_holder_name)
3993: OR NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_expiration_date,
3994: p_old_header_Payment_rec.credit_card_expiration_date) THEN
3995: IF l_debug_level > 0 THEN
3996: oe_debug_pub.add('Need to call update_card API');
3997: END IF;
3998:
3999: l_update_card_flag := 'Y';
4000: ELSE

Line 4002: oe_debug_pub.add('Need not call update_card API');

3998:
3999: l_update_card_flag := 'Y';
4000: ELSE
4001: IF l_debug_level > 0 THEN
4002: oe_debug_pub.add('Need not call update_card API');
4003: END IF;
4004:
4005: l_update_card_flag := 'N';
4006: END IF;

Line 4012: oe_debug_pub.add('Need to call update_card API 1');

4008: p_old_header_Payment_rec.credit_card_holder_name)
4009: OR NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_expiration_date,
4010: p_old_header_Payment_rec.credit_card_expiration_date) THEN
4011: IF l_debug_level > 0 THEN
4012: oe_debug_pub.add('Need to call update_card API 1');
4013: END IF;
4014:
4015: l_update_card_flag := 'Y';
4016: END IF;

Line 4021: oe_debug_pub.add('Before calling create_payment_trxn API');

4017:
4018:
4019: Begin
4020: IF l_debug_level > 0 THEN
4021: oe_debug_pub.add('Before calling create_payment_trxn API');
4022: END IF;
4023: OE_PAYMENT_TRXN_UTIL.Create_Payment_TRXN
4024: (p_header_id => p_x_header_Payment_rec.header_id,
4025: p_line_id => p_x_header_payment_rec.line_id,

Line 4047: oe_debug_pub.add('New trxn extension id after calling Create_Payment_TRXN:'||p_x_header_payment_rec.trxn_extension_id);

4043: X_return_status => l_return_status,
4044: X_msg_count => l_msg_count,
4045: X_msg_data => l_msg_data);
4046:
4047: oe_debug_pub.add('New trxn extension id after calling Create_Payment_TRXN:'||p_x_header_payment_rec.trxn_extension_id);
4048:
4049: Exception
4050: WHEN FND_API.G_EXC_ERROR THEN
4051: OE_MSG_PUB.Count_And_Get

Line 4070: oe_debug_pub.add( 'OEXUHPMB: ERROR IN ARP_BANK_PKG.PROCESS_CUST_BANK_ACCOUNT'||l_msg_data ) ;

4066: );
4067: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
4068: OE_MSG_PUB.ADD;
4069: IF l_debug_level > 0 THEN
4070: oe_debug_pub.add( 'OEXUHPMB: ERROR IN ARP_BANK_PKG.PROCESS_CUST_BANK_ACCOUNT'||l_msg_data ) ;
4071: oe_debug_pub.add('Error messsge ksurendr'||l_return_status);
4072: END IF;
4073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4074: end;

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

4067: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
4068: OE_MSG_PUB.ADD;
4069: IF l_debug_level > 0 THEN
4070: oe_debug_pub.add( 'OEXUHPMB: ERROR IN ARP_BANK_PKG.PROCESS_CUST_BANK_ACCOUNT'||l_msg_data ) ;
4071: oe_debug_pub.add('Error messsge ksurendr'||l_return_status);
4072: END IF;
4073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4074: end;
4075:

Line 4077: oe_debug_pub.add( 'after calling process_cust_bank_account. l_bank_acct_id:'||l_bank_acct_id);

4073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4074: end;
4075:
4076: IF l_debug_level > 0 THEN
4077: oe_debug_pub.add( 'after calling process_cust_bank_account. l_bank_acct_id:'||l_bank_acct_id);
4078: END IF;
4079:
4080: p_x_header_payment_rec.payment_trx_id := l_bank_acct_id;
4081: END IF;

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

4086: --For update operation, the trxn extension id of the original
4087: --transaction needs to be deleted if it already exists as
4088: --there is no trxn extension id for check payments.
4089: IF l_debug_level > 0 THEN
4090: oe_debug_pub.add(' Before calling delete payment trxn....');
4091: oe_debug_pub.add(' Trxn extension to delete'||p_old_header_Payment_rec.trxn_extension_id);
4092: END IF;
4093: --Passing the invoice to org id as null as in case of
4094: --deleting payments due to bill to change, we would need the

Line 4091: oe_debug_pub.add(' Trxn extension to delete'||p_old_header_Payment_rec.trxn_extension_id);

4087: --transaction needs to be deleted if it already exists as
4088: --there is no trxn extension id for check payments.
4089: IF l_debug_level > 0 THEN
4090: oe_debug_pub.add(' Before calling delete payment trxn....');
4091: oe_debug_pub.add(' Trxn extension to delete'||p_old_header_Payment_rec.trxn_extension_id);
4092: END IF;
4093: --Passing the invoice to org id as null as in case of
4094: --deleting payments due to bill to change, we would need the
4095: --old invoice to org id.

Line 4113: oe_debug_pub.add('Before setting the trxn extension id to null...');

4109: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4111: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4112: IF l_debug_level > 0 THEN
4113: oe_debug_pub.add('Before setting the trxn extension id to null...');
4114: oe_debug_pub.add('Id that was deleted from iby tables...'||p_old_header_Payment_rec.trxn_extension_id);
4115: END IF;
4116: END IF;
4117:

Line 4114: oe_debug_pub.add('Id that was deleted from iby tables...'||p_old_header_Payment_rec.trxn_extension_id);

4110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4111: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4112: IF l_debug_level > 0 THEN
4113: oe_debug_pub.add('Before setting the trxn extension id to null...');
4114: oe_debug_pub.add('Id that was deleted from iby tables...'||p_old_header_Payment_rec.trxn_extension_id);
4115: END IF;
4116: END IF;
4117:
4118: IF l_debug_level > 0 THEN

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

4115: END IF;
4116: END IF;
4117:
4118: IF l_debug_level > 0 THEN
4119: oe_debug_pub.add('Successful deletion of trxn extension');
4120: oe_debug_pub.add('Return status after delete trxn in pre write process '|| l_return_status);
4121: oe_debug_pub.add('msg data'||l_msg_data);
4122: END IF;
4123: --Setting the trxn extension id as null as for transactions

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

4116: END IF;
4117:
4118: IF l_debug_level > 0 THEN
4119: oe_debug_pub.add('Successful deletion of trxn extension');
4120: oe_debug_pub.add('Return status after delete trxn in pre write process '|| l_return_status);
4121: oe_debug_pub.add('msg data'||l_msg_data);
4122: END IF;
4123: --Setting the trxn extension id as null as for transactions
4124: --coming from sales order others tab, the trxn extension id would

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

4117:
4118: IF l_debug_level > 0 THEN
4119: oe_debug_pub.add('Successful deletion of trxn extension');
4120: oe_debug_pub.add('Return status after delete trxn in pre write process '|| l_return_status);
4121: oe_debug_pub.add('msg data'||l_msg_data);
4122: END IF;
4123: --Setting the trxn extension id as null as for transactions
4124: --coming from sales order others tab, the trxn extension id would
4125: --be updated in oe_payments table during updation.

Line 4142: oe_debug_pub.add('EXITING OE_HEADER_PAYMENT_UTIL.PRE_WRITE_PROCESS');

4138: := ROUND(p_x_header_payment_rec.payment_amount, OE_ORDER_UTIL.G_Precision);
4139: END IF;
4140:
4141: IF l_debug_level > 0 THEN
4142: oe_debug_pub.add('EXITING OE_HEADER_PAYMENT_UTIL.PRE_WRITE_PROCESS');
4143: END IF;
4144:
4145: EXCEPTION
4146: WHEN FND_API.G_EXC_ERROR THEN

Line 4148: Oe_debug_pub.add('OEXUHPMB.pls - pre_write_process error ');

4144:
4145: EXCEPTION
4146: WHEN FND_API.G_EXC_ERROR THEN
4147: IF L_DEBUG_LEVEL > 0 THEN
4148: Oe_debug_pub.add('OEXUHPMB.pls - pre_write_process error ');
4149: END if;
4150: p_x_header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
4151: RAISE FND_API.G_EXC_ERROR;
4152: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4154: Oe_debug_pub.add('OEXUHPMB.pls - pre_write_process unexpected error ');

4150: p_x_header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
4151: RAISE FND_API.G_EXC_ERROR;
4152: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4153: IF L_DEBUG_LEVEL > 0 THEN
4154: Oe_debug_pub.add('OEXUHPMB.pls - pre_write_process unexpected error ');
4155: END if;
4156: p_x_header_payment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4158:

Line 4161: Oe_debug_pub.add('OEXUHPMB.pls - pre_write_process unexpected error ');

4157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4158:
4159: WHEN OTHERS THEN
4160: IF L_DEBUG_LEVEL > 0 THEN
4161: Oe_debug_pub.add('OEXUHPMB.pls - pre_write_process unexpected error ');
4162: END if;
4163: raise fnD_API.G_EXC_UNEXPECTED_ERROR;
4164:
4165: END Pre_Write_Process;

Line 4192: oe_debug_pub.add('could not find any records');

4188:
4189: Exception
4190:
4191: when others then
4192: oe_debug_pub.add('could not find any records');
4193: return;
4194:
4195: End;
4196:

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

4209: END IF;
4210:
4211: l_header_rec := l_old_header_rec;
4212:
4213: oe_debug_pub.add('before updating oe_order_headers_all ');
4214:
4215: update oe_order_headers_all
4216: set payment_type_code = null,
4217: payment_amount = null,