DBA Data[Home] [Help]

APPS.OE_PAYMENT_TRXN_UTIL dependencies on IBY_FNDCPT_SETUP_PUB

Line 31: L_credit_card_rec IBY_FNDCPT_SETUP_PUB.CreditCard_rec_Type;

27: X_msg_data OUT NOCOPY VARCHAR2)
28:
29: IS
30: --R12 CC Encryption
31: L_credit_card_rec IBY_FNDCPT_SETUP_PUB.CreditCard_rec_Type;
32: L_card_exists VARCHAR2(1) := 'N';
33: L_return_status VARCHAR2(30);
34: L_msg_count NUMBER;
35: L_msg_data VARCHAR2(2000);

Line 42: L_assignment_attribs IBY_FNDCPT_SETUP_PUB.PmtInstrAssignment_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;
46: L_pmt_channel_code IBY_FNDCPT_PMT_CHNNLS_VL.payment_channel_code%TYPE;

Line 43: L_instrument IBY_FNDCPT_SETUP_PUB.PmtInstrument_rec_type;

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;
46: L_pmt_channel_code IBY_FNDCPT_PMT_CHNNLS_VL.payment_channel_code%TYPE;
47: l_instrument_type IBY_FNDCPT_PMT_CHNNLS_VL.instrument_type%TYPE;

Line 220: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment

216: oe_debug_pub.add('l_instrument.instrument_id ---> '||p_instrument_id);
217: oe_debug_pub.add('l_instrument.instrument_type -> '||l_instrument_type);
218: END IF;
219:
220: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment
221: (p_api_version => 1.0,
222: p_commit => FND_API.G_FALSE,
223: X_return_status => l_return_status,
224: X_msg_count => l_msg_count,

Line 261: IBY_FNDCPT_SETUP_PUB.Update_Card

257: oe_debug_pub.add('Expiration date --> '||p_exp_date);
258: oe_debug_pub.add('Holder Name ------> '||p_card_holder_name);
259: oe_debug_pub.add('Instrument id ----> '||p_instrument_id);
260: END IF;
261: IBY_FNDCPT_SETUP_PUB.Update_Card
262: (
263: p_api_version => 1.0,
264: p_init_msg_list => FND_API.G_TRUE,
265: p_commit => FND_API.G_FALSE,

Line 299: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment

295: oe_debug_pub.add('l_instrument.instrument_id ---> '||p_instrument_id);
296: oe_debug_pub.add('l_instrument.instrument_type -> '||l_instrument_type);
297: END IF;
298:
299: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment
300: (p_api_version => 1.0,
301: p_commit => FND_API.G_FALSE,
302: X_return_status => l_return_status,
303: X_msg_count => l_msg_count,

Line 351: IBY_FNDCPT_SETUP_PUB.Process_Credit_Card

347: L_credit_card_rec.Card_Issuer := p_card_code;
348: l_credit_card_rec.Card_Holder_Name := p_card_holder_name;
349: --bug 5176015
350: IF L_credit_card_rec.card_number IS NOT NULL THEN
351: IBY_FNDCPT_SETUP_PUB.Process_Credit_Card
352: (
353: p_api_version => 1.0,
354: p_commit => FND_API.G_FALSE,
355: X_return_status => l_return_status,

Line 685: L_credit_card_rec IBY_FNDCPT_SETUP_PUB.CreditCard_rec_Type;

681: l_org_type VARCHAR2(80) := 'OPERATING_UNIT';
682: l_instrument_type IBY_FNDCPT_PMT_CHNNLS_VL.instrument_type%TYPE;
683: l_instrument_id IBY_FNDCPT_PAYER_ALL_INSTRS_V.instrument_id%TYPE := p_instrument_id;
684: l_instrument_assignment_id IBY_FNDCPT_PAYER_ASSGN_INSTR_V.instr_assignment_id%TYPE := p_instrument_assignment_id;
685: L_credit_card_rec IBY_FNDCPT_SETUP_PUB.CreditCard_rec_Type;
686: L_assignment_attribs IBY_FNDCPT_SETUP_PUB.PmtInstrAssignment_rec_type;
687: L_instrument IBY_FNDCPT_SETUP_PUB.PmtInstrument_rec_type;
688: L_assign_id NUMBER;
689: l_invoice_to_org_id OE_ORDER_LINES_ALL.invoice_to_org_id%TYPE;

Line 686: L_assignment_attribs IBY_FNDCPT_SETUP_PUB.PmtInstrAssignment_rec_type;

682: l_instrument_type IBY_FNDCPT_PMT_CHNNLS_VL.instrument_type%TYPE;
683: l_instrument_id IBY_FNDCPT_PAYER_ALL_INSTRS_V.instrument_id%TYPE := p_instrument_id;
684: l_instrument_assignment_id IBY_FNDCPT_PAYER_ASSGN_INSTR_V.instr_assignment_id%TYPE := p_instrument_assignment_id;
685: L_credit_card_rec IBY_FNDCPT_SETUP_PUB.CreditCard_rec_Type;
686: L_assignment_attribs IBY_FNDCPT_SETUP_PUB.PmtInstrAssignment_rec_type;
687: L_instrument IBY_FNDCPT_SETUP_PUB.PmtInstrument_rec_type;
688: L_assign_id NUMBER;
689: l_invoice_to_org_id OE_ORDER_LINES_ALL.invoice_to_org_id%TYPE;
690: L_pmt_channel_code IBY_FNDCPT_PMT_CHNNLS_VL.payment_channel_code%TYPE;

Line 687: L_instrument IBY_FNDCPT_SETUP_PUB.PmtInstrument_rec_type;

683: l_instrument_id IBY_FNDCPT_PAYER_ALL_INSTRS_V.instrument_id%TYPE := p_instrument_id;
684: l_instrument_assignment_id IBY_FNDCPT_PAYER_ASSGN_INSTR_V.instr_assignment_id%TYPE := p_instrument_assignment_id;
685: L_credit_card_rec IBY_FNDCPT_SETUP_PUB.CreditCard_rec_Type;
686: L_assignment_attribs IBY_FNDCPT_SETUP_PUB.PmtInstrAssignment_rec_type;
687: L_instrument IBY_FNDCPT_SETUP_PUB.PmtInstrument_rec_type;
688: L_assign_id NUMBER;
689: l_invoice_to_org_id OE_ORDER_LINES_ALL.invoice_to_org_id%TYPE;
690: L_pmt_channel_code IBY_FNDCPT_PMT_CHNNLS_VL.payment_channel_code%TYPE;
691: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 841: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment

837: oe_debug_pub.add('l_instrument.instrument_type -> '||l_instrument_type);
838: END IF;
839:
840: --
841: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment
842: (p_api_version => 1.0,
843: p_commit => FND_API.G_FALSE,
844: X_return_status => l_return_status,
845: X_msg_count => l_msg_count,

Line 910: IBY_FNDCPT_SETUP_PUB.Update_Card

906: END IF;
907: L_credit_card_rec.expiration_date := p_exp_date;
908: l_credit_card_rec.Card_Holder_Name := p_card_holder_name;
909: l_credit_Card_rec.card_id := l_instrument_id;
910: IBY_FNDCPT_SETUP_PUB.Update_Card
911: (
912: p_api_version => 1.0,
913: p_init_msg_list => FND_API.G_TRUE,
914: p_commit => FND_API.G_FALSE,

Line 952: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment

948: l_instrument.instrument_id := l_instrument_id;
949: l_instrument.instrument_type := l_instrument_type;
950: l_assignment_attribs.instrument := l_instrument;
951:
952: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment
953: (p_api_version => 1.0,
954: p_commit => FND_API.G_FALSE,
955: X_return_status => l_return_status,
956: X_msg_count => l_msg_count,

Line 1002: IBY_FNDCPT_SETUP_PUB.Process_Credit_Card

998: oe_debug_pub.add('Holder name'||p_card_holder_name);
999: oe_debug_pub.add('call to process credit card');
1000: END IF;
1001:
1002: IBY_FNDCPT_SETUP_PUB.Process_Credit_Card
1003: (p_api_version => 1.0,
1004: p_commit => FND_API.G_FALSE,
1005: X_return_status => l_return_status,
1006: X_msg_count => l_msg_count,

Line 1602: l_assignment_attribs IBY_FNDCPT_SETUP_PUB.PmtInstrAssignment_rec_type;

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;
1603: l_instr_assignment_id IBY_FNDCPT_PAYER_ASSGN_INSTR_V.instr_assignment_id%TYPE;
1604: l_instrument_id IBY_FNDCPT_PAYER_ALL_INSTRS_V.instrument_id%TYPE;
1605: l_instrument_type IBY_FNDCPT_PMT_CHNNLS_VL.instrument_type%TYPE;
1606: l_instrument IBY_FNDCPT_SETUP_PUB.PmtInstrument_rec_type;

Line 1606: l_instrument IBY_FNDCPT_SETUP_PUB.PmtInstrument_rec_type;

1602: l_assignment_attribs IBY_FNDCPT_SETUP_PUB.PmtInstrAssignment_rec_type;
1603: l_instr_assignment_id IBY_FNDCPT_PAYER_ASSGN_INSTR_V.instr_assignment_id%TYPE;
1604: l_instrument_id IBY_FNDCPT_PAYER_ALL_INSTRS_V.instrument_id%TYPE;
1605: l_instrument_type IBY_FNDCPT_PMT_CHNNLS_VL.instrument_type%TYPE;
1606: l_instrument IBY_FNDCPT_SETUP_PUB.PmtInstrument_rec_type;
1607: l_exists_assignment VARCHAR2(1) := 'N';
1608: l_assign_id IBY_FNDCPT_PAYER_ASSGN_INSTR_V.instr_assignment_id%TYPE;
1609:
1610: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1705: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment

1701: oe_debug_pub.add('l_instrument.instrument_id ---> '||l_instrument_id);
1702: oe_debug_pub.add('l_instrument.instrument_type -> '||l_instrument_type);
1703: END IF;
1704:
1705: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment
1706: (p_api_version => 1.0,
1707: p_init_msg_list => FND_API.G_TRUE,
1708: p_commit => FND_API.G_FALSE,
1709: X_return_status => l_return_status,

Line 2354: l_channel_attrib_uses IBY_FNDCPT_SETUP_PUB.PmtChannel_AttribUses_rec_type;

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:
2358: BEGIN

Line 2364: IBY_FNDCPT_SETUP_PUB.Get_Payment_Channel_Attribs

2360: oe_debug_pub.add('Before calling Get_Payment_Channel_Attribs API...');
2361: oe_debug_pub.add('Payment channel ---> CREDIT_CARD');
2362: END IF;
2363:
2364: IBY_FNDCPT_SETUP_PUB.Get_Payment_Channel_Attribs
2365: (p_api_version => 1.0,
2366: X_return_status => l_return_status,
2367: X_msg_count => l_msg_count,
2368: X_msg_data => l_msg_data,