DBA Data[Home] [Help]

APPS.OE_PAYMENT_TRXN_UTIL dependencies on IBY_FNDCPT_SETUP_PUB

Line 9: , p_credit_card IN IBY_FNDCPT_SETUP_PUB.CreditCard_rec_Type

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
13: , p_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 10: , p_assignment_attribs IN IBY_FNDCPT_SETUP_PUB.PmtInstrAssignment_rec_type

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
13: , p_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
14: , p_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 27: IBY_FNDCPT_SETUP_PUB.Process_Credit_Card

23: BEGIN
24:
25: p_return_status := FND_API.G_RET_STS_SUCCESS;
26:
27: IBY_FNDCPT_SETUP_PUB.Process_Credit_Card
28: (
29: p_api_version => 1.0,
30: p_commit => FND_API.G_FALSE,
31: X_return_status => p_return_status,

Line 89: L_credit_card_rec IBY_FNDCPT_SETUP_PUB.CreditCard_rec_Type;

85: X_msg_data OUT NOCOPY VARCHAR2)
86:
87: IS
88: --R12 CC Encryption
89: L_credit_card_rec IBY_FNDCPT_SETUP_PUB.CreditCard_rec_Type;
90: L_card_exists VARCHAR2(1) := 'N';
91: L_return_status VARCHAR2(30);
92: L_msg_count NUMBER;
93: L_msg_data VARCHAR2(2000);

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

Line 101: L_instrument IBY_FNDCPT_SETUP_PUB.PmtInstrument_rec_type;

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

Line 279: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment

275: oe_debug_pub.add('l_instrument.instrument_id ---> '||p_instrument_id);
276: oe_debug_pub.add('l_instrument.instrument_type -> '||l_instrument_type);
277: END IF;
278:
279: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment
280: (p_api_version => 1.0,
281: p_commit => FND_API.G_FALSE,
282: X_return_status => l_return_status,
283: X_msg_count => l_msg_count,

Line 350: IBY_FNDCPT_SETUP_PUB.Update_Card

346: --oe_debug_pub.add('Expiration date --> '||p_exp_date);
347: --oe_debug_pub.add('Holder Name ------> '||p_card_holder_name);
348: oe_debug_pub.add('Instrument id ----> '||p_instrument_id);
349: END IF;
350: IBY_FNDCPT_SETUP_PUB.Update_Card
351: (
352: p_api_version => 1.0,
353: p_init_msg_list => FND_API.G_TRUE,
354: p_commit => FND_API.G_FALSE,

Line 388: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment

384: oe_debug_pub.add('l_instrument.instrument_id ---> '||p_instrument_id);
385: oe_debug_pub.add('l_instrument.instrument_type -> '||l_instrument_type);
386: END IF;
387:
388: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment
389: (p_api_version => 1.0,
390: p_commit => FND_API.G_FALSE,
391: X_return_status => l_return_status,
392: X_msg_count => l_msg_count,

Line 470: IBY_FNDCPT_SETUP_PUB.Process_Credit_Card

466: l_credit_card_rec.Card_Holder_Name := p_card_holder_name;
467: --bug 5176015
468: IF L_credit_card_rec.card_number IS NOT NULL THEN
469: --13488830 /*9092936 start
470: IBY_FNDCPT_SETUP_PUB.Process_Credit_Card
471: (
472: p_api_version => 1.0,
473: p_commit => FND_API.G_FALSE,
474: X_return_status => l_return_status,

Line 822: L_credit_card_rec IBY_FNDCPT_SETUP_PUB.CreditCard_rec_Type;

818: l_org_type VARCHAR2(80) := 'OPERATING_UNIT';
819: l_instrument_type IBY_FNDCPT_PMT_CHNNLS_VL.instrument_type%TYPE;
820: l_instrument_id IBY_FNDCPT_PAYER_ALL_INSTRS_V.instrument_id%TYPE := p_instrument_id;
821: l_instrument_assignment_id IBY_FNDCPT_PAYER_ASSGN_INSTR_V.instr_assignment_id%TYPE := p_instrument_assignment_id;
822: L_credit_card_rec IBY_FNDCPT_SETUP_PUB.CreditCard_rec_Type;
823: L_assignment_attribs IBY_FNDCPT_SETUP_PUB.PmtInstrAssignment_rec_type;
824: L_instrument IBY_FNDCPT_SETUP_PUB.PmtInstrument_rec_type;
825: L_assign_id NUMBER;
826: l_invoice_to_org_id OE_ORDER_LINES_ALL.invoice_to_org_id%TYPE;

Line 823: L_assignment_attribs IBY_FNDCPT_SETUP_PUB.PmtInstrAssignment_rec_type;

819: l_instrument_type IBY_FNDCPT_PMT_CHNNLS_VL.instrument_type%TYPE;
820: l_instrument_id IBY_FNDCPT_PAYER_ALL_INSTRS_V.instrument_id%TYPE := p_instrument_id;
821: l_instrument_assignment_id IBY_FNDCPT_PAYER_ASSGN_INSTR_V.instr_assignment_id%TYPE := p_instrument_assignment_id;
822: L_credit_card_rec IBY_FNDCPT_SETUP_PUB.CreditCard_rec_Type;
823: L_assignment_attribs IBY_FNDCPT_SETUP_PUB.PmtInstrAssignment_rec_type;
824: L_instrument IBY_FNDCPT_SETUP_PUB.PmtInstrument_rec_type;
825: L_assign_id NUMBER;
826: l_invoice_to_org_id OE_ORDER_LINES_ALL.invoice_to_org_id%TYPE;
827: L_pmt_channel_code IBY_FNDCPT_PMT_CHNNLS_VL.payment_channel_code%TYPE;

Line 824: L_instrument IBY_FNDCPT_SETUP_PUB.PmtInstrument_rec_type;

820: l_instrument_id IBY_FNDCPT_PAYER_ALL_INSTRS_V.instrument_id%TYPE := p_instrument_id;
821: l_instrument_assignment_id IBY_FNDCPT_PAYER_ASSGN_INSTR_V.instr_assignment_id%TYPE := p_instrument_assignment_id;
822: L_credit_card_rec IBY_FNDCPT_SETUP_PUB.CreditCard_rec_Type;
823: L_assignment_attribs IBY_FNDCPT_SETUP_PUB.PmtInstrAssignment_rec_type;
824: L_instrument IBY_FNDCPT_SETUP_PUB.PmtInstrument_rec_type;
825: L_assign_id NUMBER;
826: l_invoice_to_org_id OE_ORDER_LINES_ALL.invoice_to_org_id%TYPE;
827: L_pmt_channel_code IBY_FNDCPT_PMT_CHNNLS_VL.payment_channel_code%TYPE;
828: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 983: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment

979: oe_debug_pub.add('l_instrument.instrument_type -> '||l_instrument_type);
980: END IF;
981:
982: --
983: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment
984: (p_api_version => 1.0,
985: p_commit => FND_API.G_FALSE,
986: X_return_status => l_return_status,
987: X_msg_count => l_msg_count,

Line 1053: IBY_FNDCPT_SETUP_PUB.Update_Card

1049: END IF;
1050: L_credit_card_rec.expiration_date := p_exp_date;
1051: l_credit_card_rec.Card_Holder_Name := p_card_holder_name;
1052: l_credit_Card_rec.card_id := l_instrument_id;
1053: IBY_FNDCPT_SETUP_PUB.Update_Card
1054: (
1055: p_api_version => 1.0,
1056: p_init_msg_list => FND_API.G_TRUE,
1057: p_commit => FND_API.G_FALSE,

Line 1097: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment

1093: l_instrument.instrument_id := l_instrument_id;
1094: l_instrument.instrument_type := l_instrument_type;
1095: l_assignment_attribs.instrument := l_instrument;
1096:
1097: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment
1098: (p_api_version => 1.0,
1099: p_commit => FND_API.G_FALSE,
1100: X_return_status => l_return_status,
1101: X_msg_count => l_msg_count,

Line 1177: IBY_FNDCPT_SETUP_PUB.Process_Credit_Card

1173: oe_debug_pub.add('call to process credit card');
1174: END IF;
1175:
1176: --13488830 /*9092936 start
1177: IBY_FNDCPT_SETUP_PUB.Process_Credit_Card
1178: (p_api_version => 1.0,
1179: p_commit => FND_API.G_FALSE,
1180: X_return_status => l_return_status,
1181: X_msg_count => l_msg_count,

Line 1905: l_assignment_attribs IBY_FNDCPT_SETUP_PUB.PmtInstrAssignment_rec_type;

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;
1906: l_instr_assignment_id IBY_FNDCPT_PAYER_ASSGN_INSTR_V.instr_assignment_id%TYPE;
1907: l_instrument_id IBY_FNDCPT_PAYER_ALL_INSTRS_V.instrument_id%TYPE;
1908: l_instrument_type IBY_FNDCPT_PMT_CHNNLS_VL.instrument_type%TYPE;
1909: l_instrument IBY_FNDCPT_SETUP_PUB.PmtInstrument_rec_type;

Line 1909: l_instrument IBY_FNDCPT_SETUP_PUB.PmtInstrument_rec_type;

1905: l_assignment_attribs IBY_FNDCPT_SETUP_PUB.PmtInstrAssignment_rec_type;
1906: l_instr_assignment_id IBY_FNDCPT_PAYER_ASSGN_INSTR_V.instr_assignment_id%TYPE;
1907: l_instrument_id IBY_FNDCPT_PAYER_ALL_INSTRS_V.instrument_id%TYPE;
1908: l_instrument_type IBY_FNDCPT_PMT_CHNNLS_VL.instrument_type%TYPE;
1909: l_instrument IBY_FNDCPT_SETUP_PUB.PmtInstrument_rec_type;
1910: l_exists_assignment VARCHAR2(1) := 'N';
1911: l_assign_id IBY_FNDCPT_PAYER_ASSGN_INSTR_V.instr_assignment_id%TYPE;
1912:
1913: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2009: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment

2005: oe_debug_pub.add('l_instrument.instrument_id ---> '||l_instrument_id);
2006: oe_debug_pub.add('l_instrument.instrument_type -> '||l_instrument_type);
2007: END IF;
2008:
2009: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment
2010: (p_api_version => 1.0,
2011: p_init_msg_list => FND_API.G_TRUE,
2012: p_commit => FND_API.G_FALSE,
2013: X_return_status => l_return_status,

Line 2835: l_channel_attrib_uses IBY_FNDCPT_SETUP_PUB.PmtChannel_AttribUses_rec_type;

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

Line 2845: IBY_FNDCPT_SETUP_PUB.Get_Payment_Channel_Attribs

2841: oe_debug_pub.add('Before calling Get_Payment_Channel_Attribs API...');
2842: oe_debug_pub.add('Payment channel ---> CREDIT_CARD');
2843: END IF;
2844:
2845: IBY_FNDCPT_SETUP_PUB.Get_Payment_Channel_Attribs
2846: (p_api_version => 1.0,
2847: X_return_status => l_return_status,
2848: X_msg_count => l_msg_count,
2849: X_msg_data => l_msg_data,