DBA Data[Home] [Help]

APPS.OE_PAYMENT_TRXN_UTIL dependencies on IBY_FNDCPT_COMMON_PUB

Line 8: (p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type

4:
5:
6: --9092936 start
7: PROCEDURE Process_Credit_Card
8: (p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type
9: , p_credit_card IN IBY_FNDCPT_SETUP_PUB.CreditCard_rec_Type
10: , p_assignment_attribs IN IBY_FNDCPT_SETUP_PUB.PmtInstrAssignment_rec_type
11: , p_assign_id OUT NOCOPY /* file.sql.39 change */ NUMBER
12: , p_response OUT NOCOPY /* file.sql.39 change */ IBY_FNDCPT_COMMON_PUB.Result_rec_type

Line 12: , p_response OUT NOCOPY /* file.sql.39 change */ IBY_FNDCPT_COMMON_PUB.Result_rec_type

8: (p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type
9: , p_credit_card IN IBY_FNDCPT_SETUP_PUB.CreditCard_rec_Type
10: , p_assignment_attribs IN IBY_FNDCPT_SETUP_PUB.PmtInstrAssignment_rec_type
11: , p_assign_id OUT NOCOPY /* file.sql.39 change */ NUMBER
12: , p_response OUT NOCOPY /* file.sql.39 change */ IBY_FNDCPT_COMMON_PUB.Result_rec_type
13: , p_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
14: , p_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
15: , p_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
16: )

Line 95: L_response_code IBY_FNDCPT_COMMON_PUB.Result_rec_type;

91: L_return_status VARCHAR2(30);
92: L_msg_count NUMBER;
93: L_msg_data VARCHAR2(2000);
94: L_party_id NUMBER;
95: L_response_code IBY_FNDCPT_COMMON_PUB.Result_rec_type;
96: l_org_id NUMBER;
97: l_org_type VARCHAR2(80) := 'OPERATING_UNIT'; --Verify
98: L_card_id NUMBER;
99: L_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;

Line 99: L_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;

95: L_response_code IBY_FNDCPT_COMMON_PUB.Result_rec_type;
96: l_org_id NUMBER;
97: l_org_type VARCHAR2(80) := 'OPERATING_UNIT'; --Verify
98: L_card_id NUMBER;
99: L_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
100: L_assignment_attribs IBY_FNDCPT_SETUP_PUB.PmtInstrAssignment_rec_type;
101: L_instrument IBY_FNDCPT_SETUP_PUB.PmtInstrument_rec_type;
102: L_assign_id NUMBER;
103: L_trxn_attribs IBY_FNDCPT_TRXN_PUB.TrxnExtension_rec_type;

Line 669: P_payer_equivalency => IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,

665: X_return_status => l_return_status,
666: X_msg_count => l_msg_count,
667: X_msg_data => l_msg_data,
668: P_payer => l_payer,
669: P_payer_equivalency => IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,
670: P_pmt_channel => l_pmt_channel_code,
671: P_instr_assignment => l_assign_id,
672: P_trxn_attribs => l_trxn_attribs,
673: x_entity_id => l_trxn_extension_id,

Line 814: L_response_code IBY_FNDCPT_COMMON_PUB.Result_rec_type;

810: L_msg_count NUMBER;
811: L_msg_data VARCHAR2(2000);
812: L_party_id NUMBER;
813: p_card_type VARCHAR2(80);
814: L_response_code IBY_FNDCPT_COMMON_PUB.Result_rec_type;
815: L_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
816: L_trxn_attribs IBY_FNDCPT_TRXN_PUB.TrxnExtension_rec_type;
817: l_org_id NUMBER;
818: l_org_type VARCHAR2(80) := 'OPERATING_UNIT';

Line 815: L_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;

811: L_msg_data VARCHAR2(2000);
812: L_party_id NUMBER;
813: p_card_type VARCHAR2(80);
814: L_response_code IBY_FNDCPT_COMMON_PUB.Result_rec_type;
815: L_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
816: L_trxn_attribs IBY_FNDCPT_TRXN_PUB.TrxnExtension_rec_type;
817: l_org_id NUMBER;
818: l_org_type VARCHAR2(80) := 'OPERATING_UNIT';
819: l_instrument_type IBY_FNDCPT_PMT_CHNNLS_VL.instrument_type%TYPE;

Line 1545: P_payer_equivalency => IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,

1541: X_return_status => l_return_status,
1542: X_msg_count => l_msg_count,
1543: X_msg_data => l_msg_data,
1544: P_payer => l_payer,
1545: P_payer_equivalency => IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,
1546: P_pmt_channel => l_pmt_channel_code,
1547: P_instr_assignment => l_assign_id,
1548: P_trxn_attribs => l_trxn_attribs,
1549: x_entity_id => l_trxn_extension_id,

Line 1685: oe_debug_pub.add('Payer equivalency --------> '||IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_IMMEDIATE);

1681: IF l_debug_level > 0 THEN
1682: oe_debug_pub.add('Bill to has changed....Need to delete this trxn id as context has changed!');
1683: oe_debug_pub.add('Before calling Delete Transaction Extension API...');
1684: oe_debug_pub.add('Trxn extension id --------> '||p_trxn_extension_id);
1685: oe_debug_pub.add('Payer equivalency --------> '||IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_IMMEDIATE);
1686: END IF;
1687: --Setting the context corresponding to the old bill to
1688: --site as the trxn extension id was created for that site.
1689: l_payer.account_site_id := OE_Payment_Trxn_Util.g_old_bill_to_site;

Line 1704: p_payer_equivalency => IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_IMMEDIATE,

1700: X_msg_count => l_msg_count,
1701: X_msg_data => l_msg_data,
1702: p_commit => FND_API.G_FALSE,
1703: P_payer => l_payer,
1704: p_payer_equivalency => IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_IMMEDIATE,
1705: X_response => l_response_code,
1706: p_entity_id => p_trxn_extension_id);
1707:
1708: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1769: P_payer_equivalency => IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,

1765: X_return_status => l_return_status,
1766: X_msg_count => l_msg_count,
1767: X_msg_data => l_msg_data,
1768: P_payer => l_payer,
1769: P_payer_equivalency => IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,
1770: P_pmt_channel => l_pmt_channel_code,
1771: P_instr_assignment => l_assign_id,
1772: P_trxn_attribs => l_trxn_attribs,
1773: x_entity_id => l_trxn_extension_id,

Line 1897: L_response_code IBY_FNDCPT_COMMON_PUB.Result_rec_type;

1893: L_msg_count NUMBER;
1894: L_msg_data VARCHAR2(2000);
1895: L_party_id NUMBER;
1896: L_trxn_attribs IBY_FNDCPT_TRXN_PUB.TrxnExtension_rec_type;
1897: L_response_code IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1898: L_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
1899: l_org_id NUMBER;
1900: l_org_type VARCHAR2(80) := 'OPERATING_UNIT';
1901: p_entities IBY_FNDCPT_COMMON_PUB.Id_tbl_type;

Line 1898: L_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;

1894: L_msg_data VARCHAR2(2000);
1895: L_party_id NUMBER;
1896: L_trxn_attribs IBY_FNDCPT_TRXN_PUB.TrxnExtension_rec_type;
1897: L_response_code IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1898: L_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
1899: l_org_id NUMBER;
1900: l_org_type VARCHAR2(80) := 'OPERATING_UNIT';
1901: p_entities IBY_FNDCPT_COMMON_PUB.Id_tbl_type;
1902: l_invoice_to_org_id OE_ORDER_LINES_ALL.invoice_to_org_id%TYPE;

Line 1901: p_entities IBY_FNDCPT_COMMON_PUB.Id_tbl_type;

1897: L_response_code IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1898: L_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
1899: l_org_id NUMBER;
1900: l_org_type VARCHAR2(80) := 'OPERATING_UNIT';
1901: p_entities IBY_FNDCPT_COMMON_PUB.Id_tbl_type;
1902: l_invoice_to_org_id OE_ORDER_LINES_ALL.invoice_to_org_id%TYPE;
1903: l_cust_account_id NUMBER; --New
1904: l_err_message VARCHAR2(2000);
1905: l_assignment_attribs IBY_FNDCPT_SETUP_PUB.PmtInstrAssignment_rec_type;

Line 2105: P_payer_equivalency => IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,

2101: X_return_status => l_return_status,
2102: X_msg_count => l_msg_count,
2103: X_msg_data => l_msg_data,
2104: P_payer => l_payer,
2105: P_payer_equivalency => IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,
2106: p_entities => p_entities,
2107: p_trxn_attribs => l_trxn_attribs,
2108: X_entity_id => x_trxn_extension_id,
2109: x_response => l_response_code);

Line 2220: l_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;

2216: L_trxn_extension_id NUMBER := P_trxn_extension_id;
2217: l_return_status VARCHAR2(30) := NULL ;
2218: l_msg_count NUMBER := 0 ;
2219: l_msg_data VARCHAR2(2000) := NULL ;
2220: l_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
2221: l_party_id NUMBER;
2222:
2223: l_auth_result IBY_FNDCPT_TRXN_PUB.AuthResult_rec_type;
2224: l_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;

Line 2224: l_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;

2220: l_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
2221: l_party_id NUMBER;
2222:
2223: l_auth_result IBY_FNDCPT_TRXN_PUB.AuthResult_rec_type;
2224: l_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
2225: l_cust_account_id NUMBER;
2226: l_acct_site_use_id NUMBER;
2227: l_org_type VARCHAR2(80);
2228: l_payment_function VARCHAR2(80);

Line 2461: L_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;

2457: p_trxn_extension_id IN NUMBER,
2458: P_site_use_id IN NUMBER
2459: )
2460: IS
2461: L_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
2462: l_org_id NUMBER;
2463: l_org_type VARCHAR2(80) := 'OPERATING_UNIT';
2464: L_return_status VARCHAR2(30);
2465: L_msg_count NUMBER;

Line 2468: L_response_code IBY_FNDCPT_COMMON_PUB.Result_rec_type;

2464: L_return_status VARCHAR2(30);
2465: L_msg_count NUMBER;
2466: L_msg_data VARCHAR2(2000);
2467: L_party_id NUMBER;
2468: L_response_code IBY_FNDCPT_COMMON_PUB.Result_rec_type;
2469: l_cust_account_id NUMBER;
2470: l_err_message VARCHAR2(2000);
2471: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2472: l_site_use_id NUMBER := p_site_use_id;

Line 2593: oe_debug_pub.add('Payer equivalency --------> '||IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_IMMEDIATE);

2589: BEGIN
2590: IF l_debug_level > 0 THEN
2591: oe_debug_pub.add('Before calling Delete Transaction Extension API...');
2592: oe_debug_pub.add('Trxn extension id --------> '||p_trxn_extension_id);
2593: oe_debug_pub.add('Payer equivalency --------> '||IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_IMMEDIATE);
2594: END IF;
2595: -- bug 5194228
2596: IF nvl(l_authorized_flag,'N') = 'N' and nvl(l_Settled_flag,'N') = 'N' THEN
2597: IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension

Line 2605: p_payer_equivalency => IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_IMMEDIATE,

2601: X_msg_count => l_msg_count,
2602: X_msg_data => l_msg_data,
2603: p_commit => FND_API.G_FALSE,
2604: P_payer => l_payer,
2605: p_payer_equivalency => IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_IMMEDIATE,
2606: X_response => l_response_code,
2607: p_entity_id => p_trxn_extension_id);
2608:
2609: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 2834: L_response_code IBY_FNDCPT_COMMON_PUB.Result_rec_type;

2830: IS
2831: l_return_status VARCHAR2(30) := NULL ;
2832: l_msg_count NUMBER := 0 ;
2833: l_msg_data VARCHAR2(2000) := NULL ;
2834: L_response_code IBY_FNDCPT_COMMON_PUB.Result_rec_type;
2835: l_channel_attrib_uses IBY_FNDCPT_SETUP_PUB.PmtChannel_AttribUses_rec_type;
2836:
2837: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2838:

Line 2893: l_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;

2889: , p_return_status OUT NOCOPY VARCHAR2
2890: , p_new_trxn_extension_id IN NUMBER DEFAULT NULL
2891: )
2892: IS
2893: l_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
2894: l_payment_function VARCHAR2(30) := 'CUSTOMER_PAYMENT';
2895: l_invoice_to_org_id NUMBER;
2896: l_party_id NUMBER;
2897: l_cust_account_id NUMBER;

Line 2908: l_reversal_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;

2904: --l_result_status VARCHAR2(30) := NULL;
2905: l_msg_count NUMBER := 0 ;
2906: l_msg_data VARCHAR2(2000) := NULL ;
2907: l_err_message VARCHAR2(2000);
2908: l_reversal_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
2909: l_reauth_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
2910: l_reauth_result IBY_FNDCPT_TRXN_PUB.AuthResult_rec_type;
2911: l_authorized_amt number:=0;
2912: l_cancelled_flag VARCHAR2(1) := 'N';

Line 2909: l_reauth_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;

2905: l_msg_count NUMBER := 0 ;
2906: l_msg_data VARCHAR2(2000) := NULL ;
2907: l_err_message VARCHAR2(2000);
2908: l_reversal_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
2909: l_reauth_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
2910: l_reauth_result IBY_FNDCPT_TRXN_PUB.AuthResult_rec_type;
2911: l_authorized_amt number:=0;
2912: l_cancelled_flag VARCHAR2(1) := 'N';
2913: l_reversal_allowed VARCHAR2(1) :='N';

Line 3129: p_payer_equivalency => IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,

3125: IBY_Fndcpt_Trxn_Pub.Create_Reversal
3126: (p_api_version => 1.0,
3127: p_init_msg_list => FND_API.G_FALSE,
3128: p_payer => l_payer,
3129: p_payer_equivalency => IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,
3130: p_trxn_entity_id => l_trxn_extension_id,
3131: p_rev_attribs => l_rev_attribs,
3132: x_return_status => l_return_status,
3133: x_msg_count => l_msg_count,