[Home] [Help]
33: L_return_status VARCHAR2(30);
34: L_msg_count NUMBER;
35: L_msg_data VARCHAR2(2000);
36: L_party_id NUMBER;
37: L_response_code IBY_FNDCPT_COMMON_PUB.Result_rec_type;
38: l_org_id NUMBER;
39: l_org_type VARCHAR2(80) := 'OPERATING_UNIT'; --Verify
40: L_card_id NUMBER;
41: L_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
37: L_response_code IBY_FNDCPT_COMMON_PUB.Result_rec_type;
38: l_org_id NUMBER;
39: l_org_type VARCHAR2(80) := 'OPERATING_UNIT'; --Verify
40: L_card_id NUMBER;
41: L_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
42: L_assignment_attribs IBY_FNDCPT_SETUP_PUB.PmtInstrAssignment_rec_type;
43: L_instrument IBY_FNDCPT_SETUP_PUB.PmtInstrument_rec_type;
44: L_assign_id NUMBER;
45: L_trxn_attribs IBY_FNDCPT_TRXN_PUB.TrxnExtension_rec_type;
528: X_return_status => l_return_status,
529: X_msg_count => l_msg_count,
530: X_msg_data => l_msg_data,
531: P_payer => l_payer,
532: P_payer_equivalency => IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,
533: P_pmt_channel => l_pmt_channel_code,
534: P_instr_assignment => l_assign_id,
535: P_trxn_attribs => l_trxn_attribs,
536: x_entity_id => l_trxn_extension_id,
673: L_msg_count NUMBER;
674: L_msg_data VARCHAR2(2000);
675: L_party_id NUMBER;
676: p_card_type VARCHAR2(80);
677: L_response_code IBY_FNDCPT_COMMON_PUB.Result_rec_type;
678: L_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
679: L_trxn_attribs IBY_FNDCPT_TRXN_PUB.TrxnExtension_rec_type;
680: l_org_id NUMBER;
681: l_org_type VARCHAR2(80) := 'OPERATING_UNIT';
674: L_msg_data VARCHAR2(2000);
675: L_party_id NUMBER;
676: p_card_type VARCHAR2(80);
677: L_response_code IBY_FNDCPT_COMMON_PUB.Result_rec_type;
678: L_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
679: L_trxn_attribs IBY_FNDCPT_TRXN_PUB.TrxnExtension_rec_type;
680: l_org_id NUMBER;
681: l_org_type VARCHAR2(80) := 'OPERATING_UNIT';
682: l_instrument_type IBY_FNDCPT_PMT_CHNNLS_VL.instrument_type%TYPE;
1304: X_return_status => l_return_status,
1305: X_msg_count => l_msg_count,
1306: X_msg_data => l_msg_data,
1307: P_payer => l_payer,
1308: P_payer_equivalency => IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,
1309: P_pmt_channel => l_pmt_channel_code,
1310: P_instr_assignment => l_assign_id,
1311: P_trxn_attribs => l_trxn_attribs,
1312: x_entity_id => l_trxn_extension_id,
1408: IF l_debug_level > 0 THEN
1409: oe_debug_pub.add('Bill to has changed....Need to delete this trxn id as context has changed!');
1410: oe_debug_pub.add('Before calling Delete Transaction Extension API...');
1411: oe_debug_pub.add('Trxn extension id --------> '||p_trxn_extension_id);
1412: oe_debug_pub.add('Payer equivalency --------> '||IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_IMMEDIATE);
1413: END IF;
1414: --Setting the context corresponding to the old bill to
1415: --site as the trxn extension id was created for that site.
1416: l_payer.account_site_id := OE_Payment_Trxn_Util.g_old_bill_to_site;
1427: X_msg_count => l_msg_count,
1428: X_msg_data => l_msg_data,
1429: p_commit => FND_API.G_FALSE,
1430: P_payer => l_payer,
1431: p_payer_equivalency => IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_IMMEDIATE,
1432: X_response => l_response_code,
1433: p_entity_id => p_trxn_extension_id);
1434:
1435: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1492: X_return_status => l_return_status,
1493: X_msg_count => l_msg_count,
1494: X_msg_data => l_msg_data,
1495: P_payer => l_payer,
1496: P_payer_equivalency => IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,
1497: P_pmt_channel => l_pmt_channel_code,
1498: P_instr_assignment => l_assign_id,
1499: P_trxn_attribs => l_trxn_attribs,
1500: x_entity_id => l_trxn_extension_id,
1590: L_msg_count NUMBER;
1591: L_msg_data VARCHAR2(2000);
1592: L_party_id NUMBER;
1593: L_trxn_attribs IBY_FNDCPT_TRXN_PUB.TrxnExtension_rec_type;
1594: L_response_code IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1595: L_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
1596: l_org_id NUMBER;
1597: l_org_type VARCHAR2(80) := 'OPERATING_UNIT';
1598: p_entities IBY_FNDCPT_COMMON_PUB.Id_tbl_type;
1591: L_msg_data VARCHAR2(2000);
1592: L_party_id NUMBER;
1593: L_trxn_attribs IBY_FNDCPT_TRXN_PUB.TrxnExtension_rec_type;
1594: L_response_code IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1595: L_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
1596: l_org_id NUMBER;
1597: l_org_type VARCHAR2(80) := 'OPERATING_UNIT';
1598: p_entities IBY_FNDCPT_COMMON_PUB.Id_tbl_type;
1599: l_invoice_to_org_id OE_ORDER_LINES_ALL.invoice_to_org_id%TYPE;
1594: L_response_code IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1595: L_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
1596: l_org_id NUMBER;
1597: l_org_type VARCHAR2(80) := 'OPERATING_UNIT';
1598: p_entities IBY_FNDCPT_COMMON_PUB.Id_tbl_type;
1599: l_invoice_to_org_id OE_ORDER_LINES_ALL.invoice_to_org_id%TYPE;
1600: l_cust_account_id NUMBER; --New
1601: l_err_message VARCHAR2(2000);
1602: l_assignment_attribs IBY_FNDCPT_SETUP_PUB.PmtInstrAssignment_rec_type;
1769: X_return_status => l_return_status,
1770: X_msg_count => l_msg_count,
1771: X_msg_data => l_msg_data,
1772: P_payer => l_payer,
1773: P_payer_equivalency => IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,
1774: p_entities => p_entities,
1775: p_trxn_attribs => l_trxn_attribs,
1776: X_entity_id => x_trxn_extension_id,
1777: x_response => l_response_code);
1884: L_trxn_extension_id NUMBER := P_trxn_extension_id;
1885: l_return_status VARCHAR2(30) := NULL ;
1886: l_msg_count NUMBER := 0 ;
1887: l_msg_data VARCHAR2(2000) := NULL ;
1888: l_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
1889: l_party_id NUMBER;
1890:
1891: l_auth_result IBY_FNDCPT_TRXN_PUB.AuthResult_rec_type;
1892: l_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1888: l_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
1889: l_party_id NUMBER;
1890:
1891: l_auth_result IBY_FNDCPT_TRXN_PUB.AuthResult_rec_type;
1892: l_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1893: l_cust_account_id NUMBER;
1894: l_acct_site_use_id NUMBER;
1895: l_org_type VARCHAR2(80);
1896: l_payment_function VARCHAR2(80);
2078: p_trxn_extension_id IN NUMBER,
2079: P_site_use_id IN NUMBER
2080: )
2081: IS
2082: L_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
2083: l_org_id NUMBER;
2084: l_org_type VARCHAR2(80) := 'OPERATING_UNIT';
2085: L_return_status VARCHAR2(30);
2086: L_msg_count NUMBER;
2085: L_return_status VARCHAR2(30);
2086: L_msg_count NUMBER;
2087: L_msg_data VARCHAR2(2000);
2088: L_party_id NUMBER;
2089: L_response_code IBY_FNDCPT_COMMON_PUB.Result_rec_type;
2090: l_cust_account_id NUMBER;
2091: l_err_message VARCHAR2(2000);
2092: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2093: l_site_use_id NUMBER := p_site_use_id;
2193: BEGIN
2194: IF l_debug_level > 0 THEN
2195: oe_debug_pub.add('Before calling Delete Transaction Extension API...');
2196: oe_debug_pub.add('Trxn extension id --------> '||p_trxn_extension_id);
2197: oe_debug_pub.add('Payer equivalency --------> '||IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_IMMEDIATE);
2198: END IF;
2199: -- bug 5194228
2200: IF nvl(l_authorized_flag,'N') = 'N' and nvl(l_Settled_flag,'N') = 'N' THEN
2201: IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension
2205: X_msg_count => l_msg_count,
2206: X_msg_data => l_msg_data,
2207: p_commit => FND_API.G_FALSE,
2208: P_payer => l_payer,
2209: p_payer_equivalency => IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_IMMEDIATE,
2210: X_response => l_response_code,
2211: p_entity_id => p_trxn_extension_id);
2212:
2213: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2349: IS
2350: l_return_status VARCHAR2(30) := NULL ;
2351: l_msg_count NUMBER := 0 ;
2352: l_msg_data VARCHAR2(2000) := NULL ;
2353: L_response_code IBY_FNDCPT_COMMON_PUB.Result_rec_type;
2354: l_channel_attrib_uses IBY_FNDCPT_SETUP_PUB.PmtChannel_AttribUses_rec_type;
2355:
2356: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2357: