83: Begin
84:
85: SAVEPOINT CREATE_IBY_PAYMENT_INT;
86:
87: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
88:
89: IF aso_debug_pub.g_debug_flag = 'Y' THEN
90: aso_debug_pub.add('Begin create_iby_payment ', 1, 'Y');
91: END IF;
85: SAVEPOINT CREATE_IBY_PAYMENT_INT;
86:
87: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
88:
89: IF aso_debug_pub.g_debug_flag = 'Y' THEN
90: aso_debug_pub.add('Begin create_iby_payment ', 1, 'Y');
91: END IF;
92:
93: x_return_status := FND_API.G_RET_STS_SUCCESS;
86:
87: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
88:
89: IF aso_debug_pub.g_debug_flag = 'Y' THEN
90: aso_debug_pub.add('Begin create_iby_payment ', 1, 'Y');
91: END IF;
92:
93: x_return_status := FND_API.G_RET_STS_SUCCESS;
94:
107: and
108: l_payment_rec.payment_ref_number is not null and
109: l_payment_rec.payment_ref_number <> fnd_api.g_miss_char then
110:
111: IF aso_debug_pub.g_debug_flag = 'Y' THEN
112: aso_debug_pub.add('Inside if for payment type credit card', 1, 'Y');
113: END IF;
114:
115: If (l_payment_rec.instr_assignment_id is null or l_payment_rec.instr_assignment_id = fnd_api.g_miss_num ) then
108: l_payment_rec.payment_ref_number is not null and
109: l_payment_rec.payment_ref_number <> fnd_api.g_miss_char then
110:
111: IF aso_debug_pub.g_debug_flag = 'Y' THEN
112: aso_debug_pub.add('Inside if for payment type credit card', 1, 'Y');
113: END IF;
114:
115: If (l_payment_rec.instr_assignment_id is null or l_payment_rec.instr_assignment_id = fnd_api.g_miss_num ) then
116:
144: l_assignment_attribs.priority := null;
145: l_assignment_attribs.start_date := sysdate;
146: l_assignment_attribs.end_date := null;
147:
148: IF aso_debug_pub.g_debug_flag = 'Y' THEN
149: aso_debug_pub.add('Before calling IBY_FNDCPT_SETUP_PUB.Process_Credit_Card ', 1, 'Y');
150: aso_debug_pub.add('l_credit_card.card_number: '|| l_credit_card.card_number, 1, 'Y');
151: aso_debug_pub.add('l_credit_card.expiration_date: '|| l_credit_card.expiration_date, 1, 'Y');
152: aso_debug_pub.add('l_credit_card.card_issuer: '|| l_credit_card.card_issuer, 1, 'Y');
145: l_assignment_attribs.start_date := sysdate;
146: l_assignment_attribs.end_date := null;
147:
148: IF aso_debug_pub.g_debug_flag = 'Y' THEN
149: aso_debug_pub.add('Before calling IBY_FNDCPT_SETUP_PUB.Process_Credit_Card ', 1, 'Y');
150: aso_debug_pub.add('l_credit_card.card_number: '|| l_credit_card.card_number, 1, 'Y');
151: aso_debug_pub.add('l_credit_card.expiration_date: '|| l_credit_card.expiration_date, 1, 'Y');
152: aso_debug_pub.add('l_credit_card.card_issuer: '|| l_credit_card.card_issuer, 1, 'Y');
153: aso_debug_pub.add('l_credit_card.card_holder_name:'|| l_credit_card.card_holder_name, 1, 'Y');
146: l_assignment_attribs.end_date := null;
147:
148: IF aso_debug_pub.g_debug_flag = 'Y' THEN
149: aso_debug_pub.add('Before calling IBY_FNDCPT_SETUP_PUB.Process_Credit_Card ', 1, 'Y');
150: aso_debug_pub.add('l_credit_card.card_number: '|| l_credit_card.card_number, 1, 'Y');
151: aso_debug_pub.add('l_credit_card.expiration_date: '|| l_credit_card.expiration_date, 1, 'Y');
152: aso_debug_pub.add('l_credit_card.card_issuer: '|| l_credit_card.card_issuer, 1, 'Y');
153: aso_debug_pub.add('l_credit_card.card_holder_name:'|| l_credit_card.card_holder_name, 1, 'Y');
154: aso_debug_pub.add('l_credit_card.owner_id: '|| l_credit_card.owner_id, 1, 'Y');
147:
148: IF aso_debug_pub.g_debug_flag = 'Y' THEN
149: aso_debug_pub.add('Before calling IBY_FNDCPT_SETUP_PUB.Process_Credit_Card ', 1, 'Y');
150: aso_debug_pub.add('l_credit_card.card_number: '|| l_credit_card.card_number, 1, 'Y');
151: aso_debug_pub.add('l_credit_card.expiration_date: '|| l_credit_card.expiration_date, 1, 'Y');
152: aso_debug_pub.add('l_credit_card.card_issuer: '|| l_credit_card.card_issuer, 1, 'Y');
153: aso_debug_pub.add('l_credit_card.card_holder_name:'|| l_credit_card.card_holder_name, 1, 'Y');
154: aso_debug_pub.add('l_credit_card.owner_id: '|| l_credit_card.owner_id, 1, 'Y');
155: aso_debug_pub.add('p_payer.party_id: '|| p_payer.party_id, 1, 'Y');
148: IF aso_debug_pub.g_debug_flag = 'Y' THEN
149: aso_debug_pub.add('Before calling IBY_FNDCPT_SETUP_PUB.Process_Credit_Card ', 1, 'Y');
150: aso_debug_pub.add('l_credit_card.card_number: '|| l_credit_card.card_number, 1, 'Y');
151: aso_debug_pub.add('l_credit_card.expiration_date: '|| l_credit_card.expiration_date, 1, 'Y');
152: aso_debug_pub.add('l_credit_card.card_issuer: '|| l_credit_card.card_issuer, 1, 'Y');
153: aso_debug_pub.add('l_credit_card.card_holder_name:'|| l_credit_card.card_holder_name, 1, 'Y');
154: aso_debug_pub.add('l_credit_card.owner_id: '|| l_credit_card.owner_id, 1, 'Y');
155: aso_debug_pub.add('p_payer.party_id: '|| p_payer.party_id, 1, 'Y');
156: END IF;
149: aso_debug_pub.add('Before calling IBY_FNDCPT_SETUP_PUB.Process_Credit_Card ', 1, 'Y');
150: aso_debug_pub.add('l_credit_card.card_number: '|| l_credit_card.card_number, 1, 'Y');
151: aso_debug_pub.add('l_credit_card.expiration_date: '|| l_credit_card.expiration_date, 1, 'Y');
152: aso_debug_pub.add('l_credit_card.card_issuer: '|| l_credit_card.card_issuer, 1, 'Y');
153: aso_debug_pub.add('l_credit_card.card_holder_name:'|| l_credit_card.card_holder_name, 1, 'Y');
154: aso_debug_pub.add('l_credit_card.owner_id: '|| l_credit_card.owner_id, 1, 'Y');
155: aso_debug_pub.add('p_payer.party_id: '|| p_payer.party_id, 1, 'Y');
156: END IF;
157:
150: aso_debug_pub.add('l_credit_card.card_number: '|| l_credit_card.card_number, 1, 'Y');
151: aso_debug_pub.add('l_credit_card.expiration_date: '|| l_credit_card.expiration_date, 1, 'Y');
152: aso_debug_pub.add('l_credit_card.card_issuer: '|| l_credit_card.card_issuer, 1, 'Y');
153: aso_debug_pub.add('l_credit_card.card_holder_name:'|| l_credit_card.card_holder_name, 1, 'Y');
154: aso_debug_pub.add('l_credit_card.owner_id: '|| l_credit_card.owner_id, 1, 'Y');
155: aso_debug_pub.add('p_payer.party_id: '|| p_payer.party_id, 1, 'Y');
156: END IF;
157:
158: IBY_FNDCPT_SETUP_PUB.Process_Credit_Card
151: aso_debug_pub.add('l_credit_card.expiration_date: '|| l_credit_card.expiration_date, 1, 'Y');
152: aso_debug_pub.add('l_credit_card.card_issuer: '|| l_credit_card.card_issuer, 1, 'Y');
153: aso_debug_pub.add('l_credit_card.card_holder_name:'|| l_credit_card.card_holder_name, 1, 'Y');
154: aso_debug_pub.add('l_credit_card.owner_id: '|| l_credit_card.owner_id, 1, 'Y');
155: aso_debug_pub.add('p_payer.party_id: '|| p_payer.party_id, 1, 'Y');
156: END IF;
157:
158: IBY_FNDCPT_SETUP_PUB.Process_Credit_Card
159: (
168: p_assignment_attribs => l_assignment_attribs,
169: x_assign_id => lx_assign_id,
170: x_response => lx_response);
171:
172: IF aso_debug_pub.g_debug_flag = 'Y' THEN
173: aso_debug_pub.add('after calling IBY_FNDCPT_SETUP_PUB.Process_Credit_Card ', 1, 'Y');
174: aso_debug_pub.add('IBY Process_Credit_Card Return Status: '||x_return_status, 1, 'Y');
175: aso_debug_pub.add('IBY Process_Credit_Card x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
176: aso_debug_pub.add('IBY Process_Credit_Card x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
169: x_assign_id => lx_assign_id,
170: x_response => lx_response);
171:
172: IF aso_debug_pub.g_debug_flag = 'Y' THEN
173: aso_debug_pub.add('after calling IBY_FNDCPT_SETUP_PUB.Process_Credit_Card ', 1, 'Y');
174: aso_debug_pub.add('IBY Process_Credit_Card Return Status: '||x_return_status, 1, 'Y');
175: aso_debug_pub.add('IBY Process_Credit_Card x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
176: aso_debug_pub.add('IBY Process_Credit_Card x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
177: aso_debug_pub.add('IBY Process_Credit_Card x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
170: x_response => lx_response);
171:
172: IF aso_debug_pub.g_debug_flag = 'Y' THEN
173: aso_debug_pub.add('after calling IBY_FNDCPT_SETUP_PUB.Process_Credit_Card ', 1, 'Y');
174: aso_debug_pub.add('IBY Process_Credit_Card Return Status: '||x_return_status, 1, 'Y');
175: aso_debug_pub.add('IBY Process_Credit_Card x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
176: aso_debug_pub.add('IBY Process_Credit_Card x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
177: aso_debug_pub.add('IBY Process_Credit_Card x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
178: aso_debug_pub.add('IBY Process_Credit_Card x_assign_id: '|| to_char(lx_assign_id), 1, 'Y');
171:
172: IF aso_debug_pub.g_debug_flag = 'Y' THEN
173: aso_debug_pub.add('after calling IBY_FNDCPT_SETUP_PUB.Process_Credit_Card ', 1, 'Y');
174: aso_debug_pub.add('IBY Process_Credit_Card Return Status: '||x_return_status, 1, 'Y');
175: aso_debug_pub.add('IBY Process_Credit_Card x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
176: aso_debug_pub.add('IBY Process_Credit_Card x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
177: aso_debug_pub.add('IBY Process_Credit_Card x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
178: aso_debug_pub.add('IBY Process_Credit_Card x_assign_id: '|| to_char(lx_assign_id), 1, 'Y');
179: END IF;
172: IF aso_debug_pub.g_debug_flag = 'Y' THEN
173: aso_debug_pub.add('after calling IBY_FNDCPT_SETUP_PUB.Process_Credit_Card ', 1, 'Y');
174: aso_debug_pub.add('IBY Process_Credit_Card Return Status: '||x_return_status, 1, 'Y');
175: aso_debug_pub.add('IBY Process_Credit_Card x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
176: aso_debug_pub.add('IBY Process_Credit_Card x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
177: aso_debug_pub.add('IBY Process_Credit_Card x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
178: aso_debug_pub.add('IBY Process_Credit_Card x_assign_id: '|| to_char(lx_assign_id), 1, 'Y');
179: END IF;
180:
173: aso_debug_pub.add('after calling IBY_FNDCPT_SETUP_PUB.Process_Credit_Card ', 1, 'Y');
174: aso_debug_pub.add('IBY Process_Credit_Card Return Status: '||x_return_status, 1, 'Y');
175: aso_debug_pub.add('IBY Process_Credit_Card x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
176: aso_debug_pub.add('IBY Process_Credit_Card x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
177: aso_debug_pub.add('IBY Process_Credit_Card x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
178: aso_debug_pub.add('IBY Process_Credit_Card x_assign_id: '|| to_char(lx_assign_id), 1, 'Y');
179: END IF;
180:
181: if x_return_status <> fnd_api.g_ret_sts_success then
174: aso_debug_pub.add('IBY Process_Credit_Card Return Status: '||x_return_status, 1, 'Y');
175: aso_debug_pub.add('IBY Process_Credit_Card x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
176: aso_debug_pub.add('IBY Process_Credit_Card x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
177: aso_debug_pub.add('IBY Process_Credit_Card x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
178: aso_debug_pub.add('IBY Process_Credit_Card x_assign_id: '|| to_char(lx_assign_id), 1, 'Y');
179: END IF;
180:
181: if x_return_status <> fnd_api.g_ret_sts_success then
182: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
195:
196: end if;-- for instrument id check
197: end if; -- for payment type check
198:
199: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
200: aso_debug_pub.ADD ('END create_iby_payment',1,'N');
201: END IF;
202:
203: EXCEPTION
196: end if;-- for instrument id check
197: end if; -- for payment type check
198:
199: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
200: aso_debug_pub.ADD ('END create_iby_payment',1,'N');
201: END IF;
202:
203: EXCEPTION
204: WHEN FND_API.G_EXC_ERROR THEN
279: Begin
280:
281: SAVEPOINT CREATE_PAYMENT_ROW_INT;
282:
283: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
284:
285: IF aso_debug_pub.g_debug_flag = 'Y' THEN
286: aso_debug_pub.add('Begin create_payment_row ', 1, 'Y');
287: END IF;
281: SAVEPOINT CREATE_PAYMENT_ROW_INT;
282:
283: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
284:
285: IF aso_debug_pub.g_debug_flag = 'Y' THEN
286: aso_debug_pub.add('Begin create_payment_row ', 1, 'Y');
287: END IF;
288:
289: x_return_status := FND_API.G_RET_STS_SUCCESS;
282:
283: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
284:
285: IF aso_debug_pub.g_debug_flag = 'Y' THEN
286: aso_debug_pub.add('Begin create_payment_row ', 1, 'Y');
287: END IF;
288:
289: x_return_status := FND_API.G_RET_STS_SUCCESS;
290:
287: END IF;
288:
289: x_return_status := FND_API.G_RET_STS_SUCCESS;
290:
291: IF aso_debug_pub.g_debug_flag = 'Y' THEN
292: aso_debug_pub.add('l_payment_rec.Quote_Header_Id: '||l_payment_rec.Quote_Header_Id, 1, 'Y');
293: aso_debug_pub.add('l_payment_rec.Quote_Line_Id: '||l_payment_rec.Quote_Line_Id, 1, 'Y');
294: aso_debug_pub.add('l_payment_rec.payment_type_code: '||l_payment_rec.payment_type_code, 1, 'Y');
295: aso_debug_pub.add('l_payment_rec.instr_assignment_id: '||l_payment_rec.instr_assignment_id, 1, 'Y');
288:
289: x_return_status := FND_API.G_RET_STS_SUCCESS;
290:
291: IF aso_debug_pub.g_debug_flag = 'Y' THEN
292: aso_debug_pub.add('l_payment_rec.Quote_Header_Id: '||l_payment_rec.Quote_Header_Id, 1, 'Y');
293: aso_debug_pub.add('l_payment_rec.Quote_Line_Id: '||l_payment_rec.Quote_Line_Id, 1, 'Y');
294: aso_debug_pub.add('l_payment_rec.payment_type_code: '||l_payment_rec.payment_type_code, 1, 'Y');
295: aso_debug_pub.add('l_payment_rec.instr_assignment_id: '||l_payment_rec.instr_assignment_id, 1, 'Y');
296: END IF;
289: x_return_status := FND_API.G_RET_STS_SUCCESS;
290:
291: IF aso_debug_pub.g_debug_flag = 'Y' THEN
292: aso_debug_pub.add('l_payment_rec.Quote_Header_Id: '||l_payment_rec.Quote_Header_Id, 1, 'Y');
293: aso_debug_pub.add('l_payment_rec.Quote_Line_Id: '||l_payment_rec.Quote_Line_Id, 1, 'Y');
294: aso_debug_pub.add('l_payment_rec.payment_type_code: '||l_payment_rec.payment_type_code, 1, 'Y');
295: aso_debug_pub.add('l_payment_rec.instr_assignment_id: '||l_payment_rec.instr_assignment_id, 1, 'Y');
296: END IF;
297:
290:
291: IF aso_debug_pub.g_debug_flag = 'Y' THEN
292: aso_debug_pub.add('l_payment_rec.Quote_Header_Id: '||l_payment_rec.Quote_Header_Id, 1, 'Y');
293: aso_debug_pub.add('l_payment_rec.Quote_Line_Id: '||l_payment_rec.Quote_Line_Id, 1, 'Y');
294: aso_debug_pub.add('l_payment_rec.payment_type_code: '||l_payment_rec.payment_type_code, 1, 'Y');
295: aso_debug_pub.add('l_payment_rec.instr_assignment_id: '||l_payment_rec.instr_assignment_id, 1, 'Y');
296: END IF;
297:
298: -- Check for duplicate payments see bug 5118000
291: IF aso_debug_pub.g_debug_flag = 'Y' THEN
292: aso_debug_pub.add('l_payment_rec.Quote_Header_Id: '||l_payment_rec.Quote_Header_Id, 1, 'Y');
293: aso_debug_pub.add('l_payment_rec.Quote_Line_Id: '||l_payment_rec.Quote_Line_Id, 1, 'Y');
294: aso_debug_pub.add('l_payment_rec.payment_type_code: '||l_payment_rec.payment_type_code, 1, 'Y');
295: aso_debug_pub.add('l_payment_rec.instr_assignment_id: '||l_payment_rec.instr_assignment_id, 1, 'Y');
296: END IF;
297:
298: -- Check for duplicate payments see bug 5118000
299: IF ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then
296: END IF;
297:
298: -- Check for duplicate payments see bug 5118000
299: IF ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then
300: IF aso_debug_pub.g_debug_flag = 'Y' THEN
301: aso_debug_pub.add('Checking for duplicate payment records at line level', 1, 'Y');
302: END IF;
303: open c_get_db_line_payment(l_payment_rec.Quote_Header_Id,l_payment_rec.Quote_Line_Id);
304: fetch c_get_db_line_payment into l_existing_payment_id;
297:
298: -- Check for duplicate payments see bug 5118000
299: IF ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then
300: IF aso_debug_pub.g_debug_flag = 'Y' THEN
301: aso_debug_pub.add('Checking for duplicate payment records at line level', 1, 'Y');
302: END IF;
303: open c_get_db_line_payment(l_payment_rec.Quote_Header_Id,l_payment_rec.Quote_Line_Id);
304: fetch c_get_db_line_payment into l_existing_payment_id;
305: if c_get_db_line_payment%FOUND THEN
310: RAISE FND_API.G_EXC_ERROR;
311: end if;
312: close c_get_db_line_payment;
313: ELSE
314: IF aso_debug_pub.g_debug_flag = 'Y' THEN
315: aso_debug_pub.add('Checking for duplicate payment records at Header level', 1, 'Y');
316: END IF;
317: open c_get_db_hdr_payment(l_payment_rec.Quote_Header_Id);
318: fetch c_get_db_hdr_payment into l_existing_payment_id;
311: end if;
312: close c_get_db_line_payment;
313: ELSE
314: IF aso_debug_pub.g_debug_flag = 'Y' THEN
315: aso_debug_pub.add('Checking for duplicate payment records at Header level', 1, 'Y');
316: END IF;
317: open c_get_db_hdr_payment(l_payment_rec.Quote_Header_Id);
318: fetch c_get_db_hdr_payment into l_existing_payment_id;
319: if c_get_db_hdr_payment%FOUND THEN
328:
329:
330: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row (l_payment_rec.Quote_Header_Id );
331:
332: IF aso_debug_pub.g_debug_flag = 'Y' THEN
333: aso_debug_pub.add('After querying the header row', 1, 'Y');
334: aso_debug_pub.add('l_qte_header_rec.quote_header_id: ' || l_qte_header_rec.quote_header_id, 1, 'Y');
335: END IF;
336:
329:
330: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row (l_payment_rec.Quote_Header_Id );
331:
332: IF aso_debug_pub.g_debug_flag = 'Y' THEN
333: aso_debug_pub.add('After querying the header row', 1, 'Y');
334: aso_debug_pub.add('l_qte_header_rec.quote_header_id: ' || l_qte_header_rec.quote_header_id, 1, 'Y');
335: END IF;
336:
337: IF ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then
330: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row (l_payment_rec.Quote_Header_Id );
331:
332: IF aso_debug_pub.g_debug_flag = 'Y' THEN
333: aso_debug_pub.add('After querying the header row', 1, 'Y');
334: aso_debug_pub.add('l_qte_header_rec.quote_header_id: ' || l_qte_header_rec.quote_header_id, 1, 'Y');
335: END IF;
336:
337: IF ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then
338: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row ( l_payment_rec.Quote_Line_Id );
337: IF ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then
338: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row ( l_payment_rec.Quote_Line_Id );
339: END IF;
340:
341: IF aso_debug_pub.g_debug_flag = 'Y' THEN
342: aso_debug_pub.add('After querying the line row', 1, 'Y');
343: END IF;
344:
345: if ( l_payment_rec.payment_type_code = 'CREDIT_CARD' and
338: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row ( l_payment_rec.Quote_Line_Id );
339: END IF;
340:
341: IF aso_debug_pub.g_debug_flag = 'Y' THEN
342: aso_debug_pub.add('After querying the line row', 1, 'Y');
343: END IF;
344:
345: if ( l_payment_rec.payment_type_code = 'CREDIT_CARD' and
346: ((l_payment_rec.payment_ref_number is not null and l_payment_rec.payment_ref_number <> fnd_api.g_miss_char) or
345: if ( l_payment_rec.payment_type_code = 'CREDIT_CARD' and
346: ((l_payment_rec.payment_ref_number is not null and l_payment_rec.payment_ref_number <> fnd_api.g_miss_char) or
347: (l_payment_rec.instr_assignment_id is not null and l_payment_rec.instr_assignment_id <> fnd_api.g_miss_num)) ) then
348:
349: IF aso_debug_pub.g_debug_flag = 'Y' THEN
350: aso_debug_pub.add('Inside if for payment type credit card', 1, 'Y');
351: END IF;
352:
353: -- do the validation for the payment record
346: ((l_payment_rec.payment_ref_number is not null and l_payment_rec.payment_ref_number <> fnd_api.g_miss_char) or
347: (l_payment_rec.instr_assignment_id is not null and l_payment_rec.instr_assignment_id <> fnd_api.g_miss_num)) ) then
348:
349: IF aso_debug_pub.g_debug_flag = 'Y' THEN
350: aso_debug_pub.add('Inside if for payment type credit card', 1, 'Y');
351: END IF;
352:
353: -- do the validation for the payment record
354: IF aso_debug_pub.g_debug_flag = 'Y' THEN
350: aso_debug_pub.add('Inside if for payment type credit card', 1, 'Y');
351: END IF;
352:
353: -- do the validation for the payment record
354: IF aso_debug_pub.g_debug_flag = 'Y' THEN
355: aso_debug_pub.add('Before calling Validate_cc_info ', 1, 'Y');
356: END IF;
357: aso_validate_pvt.Validate_cc_info
358: (
351: END IF;
352:
353: -- do the validation for the payment record
354: IF aso_debug_pub.g_debug_flag = 'Y' THEN
355: aso_debug_pub.add('Before calling Validate_cc_info ', 1, 'Y');
356: END IF;
357: aso_validate_pvt.Validate_cc_info
358: (
359: p_init_msg_list => fnd_api.g_false,
363: x_return_status => x_return_status,
364: x_msg_count => x_msg_count,
365: x_msg_data => x_msg_data);
366:
367: IF aso_debug_pub.g_debug_flag = 'Y' THEN
368: aso_debug_pub.add('after calling Validate_cc_info ', 1, 'Y');
369: aso_debug_pub.add('Validate_cc_info Return Status: '||x_return_status, 1, 'Y');
370: END IF;
371:
364: x_msg_count => x_msg_count,
365: x_msg_data => x_msg_data);
366:
367: IF aso_debug_pub.g_debug_flag = 'Y' THEN
368: aso_debug_pub.add('after calling Validate_cc_info ', 1, 'Y');
369: aso_debug_pub.add('Validate_cc_info Return Status: '||x_return_status, 1, 'Y');
370: END IF;
371:
372: if x_return_status <> fnd_api.g_ret_sts_success then
365: x_msg_data => x_msg_data);
366:
367: IF aso_debug_pub.g_debug_flag = 'Y' THEN
368: aso_debug_pub.add('after calling Validate_cc_info ', 1, 'Y');
369: aso_debug_pub.add('Validate_cc_info Return Status: '||x_return_status, 1, 'Y');
370: END IF;
371:
372: if x_return_status <> fnd_api.g_ret_sts_success then
373: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
392: l_payer.party_id := l_qte_header_rec.invoice_to_cust_party_id;
393: End If;
394:
395: -- call api to create credit card and assigment , if needed
396: IF aso_debug_pub.g_debug_flag = 'Y' THEN
397: aso_debug_pub.add('Before calling create_iby_payment' , 1, 'Y');
398: END IF;
399:
400: aso_payment_int.create_iby_payment(p_payment_rec => p_payment_rec,
393: End If;
394:
395: -- call api to create credit card and assigment , if needed
396: IF aso_debug_pub.g_debug_flag = 'Y' THEN
397: aso_debug_pub.add('Before calling create_iby_payment' , 1, 'Y');
398: END IF;
399:
400: aso_payment_int.create_iby_payment(p_payment_rec => p_payment_rec,
401: p_payer => l_payer,
403: x_return_status => x_return_status ,
404: x_msg_count => x_msg_count,
405: x_msg_data => x_msg_data);
406:
407: IF aso_debug_pub.g_debug_flag = 'Y' THEN
408: aso_debug_pub.add('after calling create_iby_payment ', 1, 'Y');
409: aso_debug_pub.add('create_iby_payment Return Status: '||x_return_status, 1, 'Y');
410: END IF;
411:
404: x_msg_count => x_msg_count,
405: x_msg_data => x_msg_data);
406:
407: IF aso_debug_pub.g_debug_flag = 'Y' THEN
408: aso_debug_pub.add('after calling create_iby_payment ', 1, 'Y');
409: aso_debug_pub.add('create_iby_payment Return Status: '||x_return_status, 1, 'Y');
410: END IF;
411:
412: if x_return_status <> fnd_api.g_ret_sts_success then
405: x_msg_data => x_msg_data);
406:
407: IF aso_debug_pub.g_debug_flag = 'Y' THEN
408: aso_debug_pub.add('after calling create_iby_payment ', 1, 'Y');
409: aso_debug_pub.add('create_iby_payment Return Status: '||x_return_status, 1, 'Y');
410: END IF;
411:
412: if x_return_status <> fnd_api.g_ret_sts_success then
413: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
423: open c_get_payer_id(p_payment_rec.instr_assignment_id);
424: fetch c_get_payer_id into l_payer.party_id;
425: close c_get_payer_id;
426:
427: IF aso_debug_pub.g_debug_flag = 'Y' THEN
428: aso_debug_pub.add('l_payer.party_id: '|| l_payer.party_id, 1, 'Y');
429: END IF;
430:
431: end if;
424: fetch c_get_payer_id into l_payer.party_id;
425: close c_get_payer_id;
426:
427: IF aso_debug_pub.g_debug_flag = 'Y' THEN
428: aso_debug_pub.add('l_payer.party_id: '|| l_payer.party_id, 1, 'Y');
429: END IF;
430:
431: end if;
432:
449: l_trxn_attribs.Trxn_Ref_Number2 := l_payment_rec.quote_line_id;
450: End if;
451:
452: -- Check to see if cvv2 is mandatory or not
453: IF aso_debug_pub.g_debug_flag = 'Y' THEN
454: aso_debug_pub.add('Before calling IBY_FNDCPT_TRXN_PUB.Get_Payment_Channel_Attribs ', 1, 'Y');
455: END IF;
456:
457: IBY_FNDCPT_SETUP_PUB.Get_Payment_Channel_Attribs
450: End if;
451:
452: -- Check to see if cvv2 is mandatory or not
453: IF aso_debug_pub.g_debug_flag = 'Y' THEN
454: aso_debug_pub.add('Before calling IBY_FNDCPT_TRXN_PUB.Get_Payment_Channel_Attribs ', 1, 'Y');
455: END IF;
456:
457: IBY_FNDCPT_SETUP_PUB.Get_Payment_Channel_Attribs
458: (
464: p_channel_code => 'CREDIT_CARD',
465: x_channel_attrib_uses => lx_channel_attrib_uses,
466: x_response => lx_response);
467:
468: IF aso_debug_pub.g_debug_flag = 'Y' THEN
469: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Get_Payment_Channel_Attribs ', 1, 'Y');
470: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
471: aso_debug_pub.add('cvv2 use: '||lx_channel_attrib_uses.Instr_SecCode_Use, 1, 'Y');
472: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
465: x_channel_attrib_uses => lx_channel_attrib_uses,
466: x_response => lx_response);
467:
468: IF aso_debug_pub.g_debug_flag = 'Y' THEN
469: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Get_Payment_Channel_Attribs ', 1, 'Y');
470: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
471: aso_debug_pub.add('cvv2 use: '||lx_channel_attrib_uses.Instr_SecCode_Use, 1, 'Y');
472: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
473: aso_debug_pub.add('x_response.result_category:'|| to_char(lx_response.result_category), 1, 'Y');
466: x_response => lx_response);
467:
468: IF aso_debug_pub.g_debug_flag = 'Y' THEN
469: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Get_Payment_Channel_Attribs ', 1, 'Y');
470: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
471: aso_debug_pub.add('cvv2 use: '||lx_channel_attrib_uses.Instr_SecCode_Use, 1, 'Y');
472: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
473: aso_debug_pub.add('x_response.result_category:'|| to_char(lx_response.result_category), 1, 'Y');
474: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
467:
468: IF aso_debug_pub.g_debug_flag = 'Y' THEN
469: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Get_Payment_Channel_Attribs ', 1, 'Y');
470: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
471: aso_debug_pub.add('cvv2 use: '||lx_channel_attrib_uses.Instr_SecCode_Use, 1, 'Y');
472: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
473: aso_debug_pub.add('x_response.result_category:'|| to_char(lx_response.result_category), 1, 'Y');
474: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
475: END IF;
468: IF aso_debug_pub.g_debug_flag = 'Y' THEN
469: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Get_Payment_Channel_Attribs ', 1, 'Y');
470: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
471: aso_debug_pub.add('cvv2 use: '||lx_channel_attrib_uses.Instr_SecCode_Use, 1, 'Y');
472: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
473: aso_debug_pub.add('x_response.result_category:'|| to_char(lx_response.result_category), 1, 'Y');
474: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
475: END IF;
476:
469: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Get_Payment_Channel_Attribs ', 1, 'Y');
470: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
471: aso_debug_pub.add('cvv2 use: '||lx_channel_attrib_uses.Instr_SecCode_Use, 1, 'Y');
472: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
473: aso_debug_pub.add('x_response.result_category:'|| to_char(lx_response.result_category), 1, 'Y');
474: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
475: END IF;
476:
477: IF (nvl(lx_channel_attrib_uses.Instr_SecCode_Use,'null') = 'REQUIRED' and
470: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
471: aso_debug_pub.add('cvv2 use: '||lx_channel_attrib_uses.Instr_SecCode_Use, 1, 'Y');
472: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
473: aso_debug_pub.add('x_response.result_category:'|| to_char(lx_response.result_category), 1, 'Y');
474: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
475: END IF;
476:
477: IF (nvl(lx_channel_attrib_uses.Instr_SecCode_Use,'null') = 'REQUIRED' and
478: (l_payment_rec.cvv2 is null or l_payment_rec.cvv2 = fnd_api.g_miss_char)) then
495: l_trxn_attribs.VoiceAuth_Code := null;
496: l_trxn_attribs.Additional_Info := null;
497:
498:
499: IF aso_debug_pub.g_debug_flag = 'Y' THEN
500: aso_debug_pub.add('Before calling IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', 1, 'Y');
501: aso_debug_pub.add('Instrument Assignment id: '|| l_payment_rec.instr_assignment_id, 1, 'Y');
502: END IF;
503:
496: l_trxn_attribs.Additional_Info := null;
497:
498:
499: IF aso_debug_pub.g_debug_flag = 'Y' THEN
500: aso_debug_pub.add('Before calling IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', 1, 'Y');
501: aso_debug_pub.add('Instrument Assignment id: '|| l_payment_rec.instr_assignment_id, 1, 'Y');
502: END IF;
503:
504: IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension
497:
498:
499: IF aso_debug_pub.g_debug_flag = 'Y' THEN
500: aso_debug_pub.add('Before calling IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', 1, 'Y');
501: aso_debug_pub.add('Instrument Assignment id: '|| l_payment_rec.instr_assignment_id, 1, 'Y');
502: END IF;
503:
504: IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension
505: (
516: p_trxn_attribs => l_trxn_attribs,
517: x_entity_id => lx_entity_id,
518: x_response => lx_response);
519:
520: IF aso_debug_pub.g_debug_flag = 'Y' THEN
521: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', 1, 'Y');
522: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
523: aso_debug_pub.add('lx_entity_id: '||lx_entity_id, 1, 'Y');
524: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
517: x_entity_id => lx_entity_id,
518: x_response => lx_response);
519:
520: IF aso_debug_pub.g_debug_flag = 'Y' THEN
521: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', 1, 'Y');
522: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
523: aso_debug_pub.add('lx_entity_id: '||lx_entity_id, 1, 'Y');
524: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
525: aso_debug_pub.add('x_response.result_category:'|| to_char(lx_response.result_category), 1, 'Y');
518: x_response => lx_response);
519:
520: IF aso_debug_pub.g_debug_flag = 'Y' THEN
521: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', 1, 'Y');
522: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
523: aso_debug_pub.add('lx_entity_id: '||lx_entity_id, 1, 'Y');
524: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
525: aso_debug_pub.add('x_response.result_category:'|| to_char(lx_response.result_category), 1, 'Y');
526: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
519:
520: IF aso_debug_pub.g_debug_flag = 'Y' THEN
521: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', 1, 'Y');
522: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
523: aso_debug_pub.add('lx_entity_id: '||lx_entity_id, 1, 'Y');
524: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
525: aso_debug_pub.add('x_response.result_category:'|| to_char(lx_response.result_category), 1, 'Y');
526: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
527: END IF;
520: IF aso_debug_pub.g_debug_flag = 'Y' THEN
521: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', 1, 'Y');
522: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
523: aso_debug_pub.add('lx_entity_id: '||lx_entity_id, 1, 'Y');
524: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
525: aso_debug_pub.add('x_response.result_category:'|| to_char(lx_response.result_category), 1, 'Y');
526: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
527: END IF;
528:
521: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', 1, 'Y');
522: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
523: aso_debug_pub.add('lx_entity_id: '||lx_entity_id, 1, 'Y');
524: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
525: aso_debug_pub.add('x_response.result_category:'|| to_char(lx_response.result_category), 1, 'Y');
526: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
527: END IF;
528:
529: if x_return_status <> fnd_api.g_ret_sts_success then
522: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
523: aso_debug_pub.add('lx_entity_id: '||lx_entity_id, 1, 'Y');
524: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
525: aso_debug_pub.add('x_response.result_category:'|| to_char(lx_response.result_category), 1, 'Y');
526: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
527: END IF;
528:
529: if x_return_status <> fnd_api.g_ret_sts_success then
530: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
549: l_payment_ref_number := l_payment_rec.PAYMENT_REF_NUMBER;
550: END IF;
551:
552:
553: IF aso_debug_pub.g_debug_flag = 'Y' THEN
554: aso_debug_pub.add('Before calling the table handler to insert the data ', 1, 'Y');
555: END IF;
556:
557:
550: END IF;
551:
552:
553: IF aso_debug_pub.g_debug_flag = 'Y' THEN
554: aso_debug_pub.add('Before calling the table handler to insert the data ', 1, 'Y');
555: END IF;
556:
557:
558: ASO_PAYMENTS_PKG.Insert_Row(
615: ( p_count => x_msg_count,
616: p_data => x_msg_data
617: );
618:
619: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
620: aso_debug_pub.ADD ('END create_payment_row',1,'N');
621: END IF;
622:
623: EXCEPTION
616: p_data => x_msg_data
617: );
618:
619: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
620: aso_debug_pub.ADD ('END create_payment_row',1,'N');
621: END IF;
622:
623: EXCEPTION
624: WHEN FND_API.G_EXC_ERROR THEN
694: Begin
695:
696: SAVEPOINT UPDATE_PAYMENT_ROW_INT;
697:
698: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
699:
700: IF aso_debug_pub.g_debug_flag = 'Y' THEN
701: aso_debug_pub.add('Begin update_payment_row ', 1, 'Y');
702: END IF;
696: SAVEPOINT UPDATE_PAYMENT_ROW_INT;
697:
698: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
699:
700: IF aso_debug_pub.g_debug_flag = 'Y' THEN
701: aso_debug_pub.add('Begin update_payment_row ', 1, 'Y');
702: END IF;
703:
704: x_return_status := FND_API.G_RET_STS_SUCCESS;
697:
698: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
699:
700: IF aso_debug_pub.g_debug_flag = 'Y' THEN
701: aso_debug_pub.add('Begin update_payment_row ', 1, 'Y');
702: END IF;
703:
704: x_return_status := FND_API.G_RET_STS_SUCCESS;
705:
719: l_payment_tbl := aso_utility_pvt.Query_Payment_Rows(l_payment_rec.quote_header_id,l_payment_rec.quote_line_id);
720: l_db_payment_rec := l_payment_tbl(1);
721:
722:
723: IF aso_debug_pub.g_debug_flag = 'Y' THEN
724: aso_debug_pub.add('Database payment_type_code is : '||l_db_payment_rec.payment_type_code, 1, 'Y');
725: aso_debug_pub.add('Database trxn_extension_id is : '||l_db_payment_rec.trxn_extension_id, 1, 'Y');
726: aso_debug_pub.add('Input payment_type_code is : '|| l_payment_rec.payment_type_code, 1, 'Y');
727: aso_debug_pub.add('Input instr_assignment_id is : '|| l_payment_rec.instr_assignment_id, 1, 'Y');
720: l_db_payment_rec := l_payment_tbl(1);
721:
722:
723: IF aso_debug_pub.g_debug_flag = 'Y' THEN
724: aso_debug_pub.add('Database payment_type_code is : '||l_db_payment_rec.payment_type_code, 1, 'Y');
725: aso_debug_pub.add('Database trxn_extension_id is : '||l_db_payment_rec.trxn_extension_id, 1, 'Y');
726: aso_debug_pub.add('Input payment_type_code is : '|| l_payment_rec.payment_type_code, 1, 'Y');
727: aso_debug_pub.add('Input instr_assignment_id is : '|| l_payment_rec.instr_assignment_id, 1, 'Y');
728: aso_debug_pub.add('Input payment_ref_number is : '|| l_payment_rec.payment_ref_number, 1, 'Y');
721:
722:
723: IF aso_debug_pub.g_debug_flag = 'Y' THEN
724: aso_debug_pub.add('Database payment_type_code is : '||l_db_payment_rec.payment_type_code, 1, 'Y');
725: aso_debug_pub.add('Database trxn_extension_id is : '||l_db_payment_rec.trxn_extension_id, 1, 'Y');
726: aso_debug_pub.add('Input payment_type_code is : '|| l_payment_rec.payment_type_code, 1, 'Y');
727: aso_debug_pub.add('Input instr_assignment_id is : '|| l_payment_rec.instr_assignment_id, 1, 'Y');
728: aso_debug_pub.add('Input payment_ref_number is : '|| l_payment_rec.payment_ref_number, 1, 'Y');
729: aso_debug_pub.add('Input trxn_extension_id is : '|| l_payment_rec.trxn_extension_id, 1, 'Y');
722:
723: IF aso_debug_pub.g_debug_flag = 'Y' THEN
724: aso_debug_pub.add('Database payment_type_code is : '||l_db_payment_rec.payment_type_code, 1, 'Y');
725: aso_debug_pub.add('Database trxn_extension_id is : '||l_db_payment_rec.trxn_extension_id, 1, 'Y');
726: aso_debug_pub.add('Input payment_type_code is : '|| l_payment_rec.payment_type_code, 1, 'Y');
727: aso_debug_pub.add('Input instr_assignment_id is : '|| l_payment_rec.instr_assignment_id, 1, 'Y');
728: aso_debug_pub.add('Input payment_ref_number is : '|| l_payment_rec.payment_ref_number, 1, 'Y');
729: aso_debug_pub.add('Input trxn_extension_id is : '|| l_payment_rec.trxn_extension_id, 1, 'Y');
730: aso_debug_pub.add('Input instrument_id is : '|| l_payment_rec.instrument_id, 1, 'Y');
723: IF aso_debug_pub.g_debug_flag = 'Y' THEN
724: aso_debug_pub.add('Database payment_type_code is : '||l_db_payment_rec.payment_type_code, 1, 'Y');
725: aso_debug_pub.add('Database trxn_extension_id is : '||l_db_payment_rec.trxn_extension_id, 1, 'Y');
726: aso_debug_pub.add('Input payment_type_code is : '|| l_payment_rec.payment_type_code, 1, 'Y');
727: aso_debug_pub.add('Input instr_assignment_id is : '|| l_payment_rec.instr_assignment_id, 1, 'Y');
728: aso_debug_pub.add('Input payment_ref_number is : '|| l_payment_rec.payment_ref_number, 1, 'Y');
729: aso_debug_pub.add('Input trxn_extension_id is : '|| l_payment_rec.trxn_extension_id, 1, 'Y');
730: aso_debug_pub.add('Input instrument_id is : '|| l_payment_rec.instrument_id, 1, 'Y');
731: aso_debug_pub.add('Input cvv2 is : '|| l_payment_rec.cvv2, 1, 'Y');
724: aso_debug_pub.add('Database payment_type_code is : '||l_db_payment_rec.payment_type_code, 1, 'Y');
725: aso_debug_pub.add('Database trxn_extension_id is : '||l_db_payment_rec.trxn_extension_id, 1, 'Y');
726: aso_debug_pub.add('Input payment_type_code is : '|| l_payment_rec.payment_type_code, 1, 'Y');
727: aso_debug_pub.add('Input instr_assignment_id is : '|| l_payment_rec.instr_assignment_id, 1, 'Y');
728: aso_debug_pub.add('Input payment_ref_number is : '|| l_payment_rec.payment_ref_number, 1, 'Y');
729: aso_debug_pub.add('Input trxn_extension_id is : '|| l_payment_rec.trxn_extension_id, 1, 'Y');
730: aso_debug_pub.add('Input instrument_id is : '|| l_payment_rec.instrument_id, 1, 'Y');
731: aso_debug_pub.add('Input cvv2 is : '|| l_payment_rec.cvv2, 1, 'Y');
732: END IF;
725: aso_debug_pub.add('Database trxn_extension_id is : '||l_db_payment_rec.trxn_extension_id, 1, 'Y');
726: aso_debug_pub.add('Input payment_type_code is : '|| l_payment_rec.payment_type_code, 1, 'Y');
727: aso_debug_pub.add('Input instr_assignment_id is : '|| l_payment_rec.instr_assignment_id, 1, 'Y');
728: aso_debug_pub.add('Input payment_ref_number is : '|| l_payment_rec.payment_ref_number, 1, 'Y');
729: aso_debug_pub.add('Input trxn_extension_id is : '|| l_payment_rec.trxn_extension_id, 1, 'Y');
730: aso_debug_pub.add('Input instrument_id is : '|| l_payment_rec.instrument_id, 1, 'Y');
731: aso_debug_pub.add('Input cvv2 is : '|| l_payment_rec.cvv2, 1, 'Y');
732: END IF;
733:
726: aso_debug_pub.add('Input payment_type_code is : '|| l_payment_rec.payment_type_code, 1, 'Y');
727: aso_debug_pub.add('Input instr_assignment_id is : '|| l_payment_rec.instr_assignment_id, 1, 'Y');
728: aso_debug_pub.add('Input payment_ref_number is : '|| l_payment_rec.payment_ref_number, 1, 'Y');
729: aso_debug_pub.add('Input trxn_extension_id is : '|| l_payment_rec.trxn_extension_id, 1, 'Y');
730: aso_debug_pub.add('Input instrument_id is : '|| l_payment_rec.instrument_id, 1, 'Y');
731: aso_debug_pub.add('Input cvv2 is : '|| l_payment_rec.cvv2, 1, 'Y');
732: END IF;
733:
734:
727: aso_debug_pub.add('Input instr_assignment_id is : '|| l_payment_rec.instr_assignment_id, 1, 'Y');
728: aso_debug_pub.add('Input payment_ref_number is : '|| l_payment_rec.payment_ref_number, 1, 'Y');
729: aso_debug_pub.add('Input trxn_extension_id is : '|| l_payment_rec.trxn_extension_id, 1, 'Y');
730: aso_debug_pub.add('Input instrument_id is : '|| l_payment_rec.instrument_id, 1, 'Y');
731: aso_debug_pub.add('Input cvv2 is : '|| l_payment_rec.cvv2, 1, 'Y');
732: END IF;
733:
734:
735: -- do the validation for the payment record
733:
734:
735: -- do the validation for the payment record
736: IF l_payment_rec.payment_type_code = 'CREDIT_CARD' THEN
737: IF aso_debug_pub.g_debug_flag = 'Y' THEN
738: aso_debug_pub.add('Before calling Validate_cc_info ', 1, 'Y');
739: END IF;
740: aso_validate_pvt.Validate_cc_info
741: (
734:
735: -- do the validation for the payment record
736: IF l_payment_rec.payment_type_code = 'CREDIT_CARD' THEN
737: IF aso_debug_pub.g_debug_flag = 'Y' THEN
738: aso_debug_pub.add('Before calling Validate_cc_info ', 1, 'Y');
739: END IF;
740: aso_validate_pvt.Validate_cc_info
741: (
742: p_init_msg_list => fnd_api.g_false,
746: x_return_status => x_return_status,
747: x_msg_count => x_msg_count,
748: x_msg_data => x_msg_data);
749:
750: IF aso_debug_pub.g_debug_flag = 'Y' THEN
751: aso_debug_pub.add('after calling Validate_cc_info ', 1, 'Y');
752: aso_debug_pub.add('Validate_cc_info Return Status: '||x_return_status, 1, 'Y');
753: END IF;
754:
747: x_msg_count => x_msg_count,
748: x_msg_data => x_msg_data);
749:
750: IF aso_debug_pub.g_debug_flag = 'Y' THEN
751: aso_debug_pub.add('after calling Validate_cc_info ', 1, 'Y');
752: aso_debug_pub.add('Validate_cc_info Return Status: '||x_return_status, 1, 'Y');
753: END IF;
754:
755: if x_return_status <> fnd_api.g_ret_sts_success then
748: x_msg_data => x_msg_data);
749:
750: IF aso_debug_pub.g_debug_flag = 'Y' THEN
751: aso_debug_pub.add('after calling Validate_cc_info ', 1, 'Y');
752: aso_debug_pub.add('Validate_cc_info Return Status: '||x_return_status, 1, 'Y');
753: END IF;
754:
755: if x_return_status <> fnd_api.g_ret_sts_success then
756: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
774:
775: If (l_payment_rec.instr_assignment_id is null or l_payment_rec.instr_assignment_id = fnd_api.g_miss_num ) then
776: -- this is quoting flow
777: -- call api to create credit card and assigment , if needed
778: IF aso_debug_pub.g_debug_flag = 'Y' THEN
779: aso_debug_pub.add('Before calling create_iby_payment' , 1, 'Y');
780: END IF;
781:
782: If ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then
775: If (l_payment_rec.instr_assignment_id is null or l_payment_rec.instr_assignment_id = fnd_api.g_miss_num ) then
776: -- this is quoting flow
777: -- call api to create credit card and assigment , if needed
778: IF aso_debug_pub.g_debug_flag = 'Y' THEN
779: aso_debug_pub.add('Before calling create_iby_payment' , 1, 'Y');
780: END IF;
781:
782: If ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then
783: l_payer.party_id := l_qte_line_rec.invoice_to_cust_party_id;
791: x_return_status => x_return_status ,
792: x_msg_count => x_msg_count,
793: x_msg_data => x_msg_data);
794:
795: IF aso_debug_pub.g_debug_flag = 'Y' THEN
796: aso_debug_pub.add('after calling create_iby_payment ', 1, 'Y');
797: aso_debug_pub.add('create_iby_payment Return Status: '||x_return_status, 1, 'Y');
798: END IF;
799:
792: x_msg_count => x_msg_count,
793: x_msg_data => x_msg_data);
794:
795: IF aso_debug_pub.g_debug_flag = 'Y' THEN
796: aso_debug_pub.add('after calling create_iby_payment ', 1, 'Y');
797: aso_debug_pub.add('create_iby_payment Return Status: '||x_return_status, 1, 'Y');
798: END IF;
799:
800: if x_return_status <> fnd_api.g_ret_sts_success then
793: x_msg_data => x_msg_data);
794:
795: IF aso_debug_pub.g_debug_flag = 'Y' THEN
796: aso_debug_pub.add('after calling create_iby_payment ', 1, 'Y');
797: aso_debug_pub.add('create_iby_payment Return Status: '||x_return_status, 1, 'Y');
798: END IF;
799:
800: if x_return_status <> fnd_api.g_ret_sts_success then
801: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
826: End if;
827:
828:
829: -- Check to see if cvv2 is mandatory or not
830: IF aso_debug_pub.g_debug_flag = 'Y' THEN
831: aso_debug_pub.add('Before calling IBY_FNDCPT_TRXN_PUB.Get_Payment_Channel_Attribs ', 1, 'Y');
832: END IF;
833:
834: IBY_FNDCPT_SETUP_PUB.Get_Payment_Channel_Attribs
827:
828:
829: -- Check to see if cvv2 is mandatory or not
830: IF aso_debug_pub.g_debug_flag = 'Y' THEN
831: aso_debug_pub.add('Before calling IBY_FNDCPT_TRXN_PUB.Get_Payment_Channel_Attribs ', 1, 'Y');
832: END IF;
833:
834: IBY_FNDCPT_SETUP_PUB.Get_Payment_Channel_Attribs
835: (
841: p_channel_code => 'CREDIT_CARD',
842: x_channel_attrib_uses => lx_channel_attrib_uses,
843: x_response => lx_response);
844:
845: IF aso_debug_pub.g_debug_flag = 'Y' THEN
846: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Get_Payment_Channel_Attribs ', 1, 'Y');
847: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
848: aso_debug_pub.add('cvv2 use: '||lx_channel_attrib_uses.Instr_SecCode_Use, 1, 'Y');
849: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
842: x_channel_attrib_uses => lx_channel_attrib_uses,
843: x_response => lx_response);
844:
845: IF aso_debug_pub.g_debug_flag = 'Y' THEN
846: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Get_Payment_Channel_Attribs ', 1, 'Y');
847: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
848: aso_debug_pub.add('cvv2 use: '||lx_channel_attrib_uses.Instr_SecCode_Use, 1, 'Y');
849: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
850: aso_debug_pub.add('x_response.result_category:'|| to_char(lx_response.result_category), 1, 'Y');
843: x_response => lx_response);
844:
845: IF aso_debug_pub.g_debug_flag = 'Y' THEN
846: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Get_Payment_Channel_Attribs ', 1, 'Y');
847: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
848: aso_debug_pub.add('cvv2 use: '||lx_channel_attrib_uses.Instr_SecCode_Use, 1, 'Y');
849: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
850: aso_debug_pub.add('x_response.result_category:'|| to_char(lx_response.result_category), 1, 'Y');
851: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
844:
845: IF aso_debug_pub.g_debug_flag = 'Y' THEN
846: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Get_Payment_Channel_Attribs ', 1, 'Y');
847: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
848: aso_debug_pub.add('cvv2 use: '||lx_channel_attrib_uses.Instr_SecCode_Use, 1, 'Y');
849: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
850: aso_debug_pub.add('x_response.result_category:'|| to_char(lx_response.result_category), 1, 'Y');
851: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
852: END IF;
845: IF aso_debug_pub.g_debug_flag = 'Y' THEN
846: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Get_Payment_Channel_Attribs ', 1, 'Y');
847: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
848: aso_debug_pub.add('cvv2 use: '||lx_channel_attrib_uses.Instr_SecCode_Use, 1, 'Y');
849: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
850: aso_debug_pub.add('x_response.result_category:'|| to_char(lx_response.result_category), 1, 'Y');
851: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
852: END IF;
853:
846: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Get_Payment_Channel_Attribs ', 1, 'Y');
847: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
848: aso_debug_pub.add('cvv2 use: '||lx_channel_attrib_uses.Instr_SecCode_Use, 1, 'Y');
849: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
850: aso_debug_pub.add('x_response.result_category:'|| to_char(lx_response.result_category), 1, 'Y');
851: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
852: END IF;
853:
854: IF (nvl(lx_channel_attrib_uses.Instr_SecCode_Use,'null') = 'REQUIRED' and
847: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
848: aso_debug_pub.add('cvv2 use: '||lx_channel_attrib_uses.Instr_SecCode_Use, 1, 'Y');
849: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
850: aso_debug_pub.add('x_response.result_category:'|| to_char(lx_response.result_category), 1, 'Y');
851: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
852: END IF;
853:
854: IF (nvl(lx_channel_attrib_uses.Instr_SecCode_Use,'null') = 'REQUIRED' and
855: (l_payment_rec.cvv2 is null or l_payment_rec.cvv2 = fnd_api.g_miss_char)) then
871: l_trxn_attribs.VoiceAuth_Code := null;
872: l_trxn_attribs.Additional_Info := null;
873:
874:
875: IF aso_debug_pub.g_debug_flag = 'Y' THEN
876: aso_debug_pub.add('Before calling IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', 1, 'Y');
877: aso_debug_pub.add('Instrument Assignment id: '|| l_payment_rec.instr_assignment_id, 1, 'Y');
878: END IF;
879:
872: l_trxn_attribs.Additional_Info := null;
873:
874:
875: IF aso_debug_pub.g_debug_flag = 'Y' THEN
876: aso_debug_pub.add('Before calling IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', 1, 'Y');
877: aso_debug_pub.add('Instrument Assignment id: '|| l_payment_rec.instr_assignment_id, 1, 'Y');
878: END IF;
879:
880: --bug 5154775
873:
874:
875: IF aso_debug_pub.g_debug_flag = 'Y' THEN
876: aso_debug_pub.add('Before calling IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', 1, 'Y');
877: aso_debug_pub.add('Instrument Assignment id: '|| l_payment_rec.instr_assignment_id, 1, 'Y');
878: END IF;
879:
880: --bug 5154775
881: IF (l_payment_rec.instr_assignment_id is not null and l_payment_rec.instr_assignment_id <> fnd_api.g_miss_num) then
894: p_trxn_attribs => l_trxn_attribs,
895: x_entity_id => lx_entity_id,
896: x_response => lx_response);
897:
898: IF aso_debug_pub.g_debug_flag = 'Y' THEN
899: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', 1, 'Y');
900: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
901: aso_debug_pub.add('lx_entity_id: '||lx_entity_id, 1, 'Y');
902: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
895: x_entity_id => lx_entity_id,
896: x_response => lx_response);
897:
898: IF aso_debug_pub.g_debug_flag = 'Y' THEN
899: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', 1, 'Y');
900: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
901: aso_debug_pub.add('lx_entity_id: '||lx_entity_id, 1, 'Y');
902: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
903: aso_debug_pub.add('x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
896: x_response => lx_response);
897:
898: IF aso_debug_pub.g_debug_flag = 'Y' THEN
899: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', 1, 'Y');
900: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
901: aso_debug_pub.add('lx_entity_id: '||lx_entity_id, 1, 'Y');
902: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
903: aso_debug_pub.add('x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
904: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
897:
898: IF aso_debug_pub.g_debug_flag = 'Y' THEN
899: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', 1, 'Y');
900: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
901: aso_debug_pub.add('lx_entity_id: '||lx_entity_id, 1, 'Y');
902: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
903: aso_debug_pub.add('x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
904: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
905: END IF;
898: IF aso_debug_pub.g_debug_flag = 'Y' THEN
899: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', 1, 'Y');
900: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
901: aso_debug_pub.add('lx_entity_id: '||lx_entity_id, 1, 'Y');
902: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
903: aso_debug_pub.add('x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
904: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
905: END IF;
906:
899: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', 1, 'Y');
900: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
901: aso_debug_pub.add('lx_entity_id: '||lx_entity_id, 1, 'Y');
902: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
903: aso_debug_pub.add('x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
904: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
905: END IF;
906:
907: if x_return_status <> fnd_api.g_ret_sts_success then
900: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
901: aso_debug_pub.add('lx_entity_id: '||lx_entity_id, 1, 'Y');
902: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
903: aso_debug_pub.add('x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
904: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
905: END IF;
906:
907: if x_return_status <> fnd_api.g_ret_sts_success then
908: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
926: open c_get_payer_from_trxn(l_db_payment_rec.trxn_extension_id);
927: fetch c_get_payer_from_trxn into l_payer.party_id;
928: close c_get_payer_from_trxn;
929:
930: IF aso_debug_pub.g_debug_flag = 'Y' THEN
931: aso_debug_pub.add('Before Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension ', 1, 'Y');
932: aso_debug_pub.add('l_payer.party_id: '|| l_payer.party_id, 1, 'Y');
933: aso_debug_pub.add('l_payment_rec.trxn_extension_id: '|| l_db_payment_rec.trxn_extension_id, 1, 'Y');
934: END IF;
927: fetch c_get_payer_from_trxn into l_payer.party_id;
928: close c_get_payer_from_trxn;
929:
930: IF aso_debug_pub.g_debug_flag = 'Y' THEN
931: aso_debug_pub.add('Before Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension ', 1, 'Y');
932: aso_debug_pub.add('l_payer.party_id: '|| l_payer.party_id, 1, 'Y');
933: aso_debug_pub.add('l_payment_rec.trxn_extension_id: '|| l_db_payment_rec.trxn_extension_id, 1, 'Y');
934: END IF;
935:
928: close c_get_payer_from_trxn;
929:
930: IF aso_debug_pub.g_debug_flag = 'Y' THEN
931: aso_debug_pub.add('Before Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension ', 1, 'Y');
932: aso_debug_pub.add('l_payer.party_id: '|| l_payer.party_id, 1, 'Y');
933: aso_debug_pub.add('l_payment_rec.trxn_extension_id: '|| l_db_payment_rec.trxn_extension_id, 1, 'Y');
934: END IF;
935:
936: IF (l_db_payment_rec.trxn_extension_id is not null and l_db_payment_rec.trxn_extension_id <> fnd_api.g_miss_num ) then
929:
930: IF aso_debug_pub.g_debug_flag = 'Y' THEN
931: aso_debug_pub.add('Before Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension ', 1, 'Y');
932: aso_debug_pub.add('l_payer.party_id: '|| l_payer.party_id, 1, 'Y');
933: aso_debug_pub.add('l_payment_rec.trxn_extension_id: '|| l_db_payment_rec.trxn_extension_id, 1, 'Y');
934: END IF;
935:
936: IF (l_db_payment_rec.trxn_extension_id is not null and l_db_payment_rec.trxn_extension_id <> fnd_api.g_miss_num ) then
937: IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension
947: p_payer_equivalency => IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,
948: x_response => lx_response
949: );
950:
951: IF aso_debug_pub.g_debug_flag = 'Y' THEN
952: aso_debug_pub.add('After Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension ', 1, 'Y');
953: aso_debug_pub.add('Return Status from IBY Delete API: '||x_return_status, 1, 'Y');
954: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
955: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
948: x_response => lx_response
949: );
950:
951: IF aso_debug_pub.g_debug_flag = 'Y' THEN
952: aso_debug_pub.add('After Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension ', 1, 'Y');
953: aso_debug_pub.add('Return Status from IBY Delete API: '||x_return_status, 1, 'Y');
954: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
955: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
956: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
949: );
950:
951: IF aso_debug_pub.g_debug_flag = 'Y' THEN
952: aso_debug_pub.add('After Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension ', 1, 'Y');
953: aso_debug_pub.add('Return Status from IBY Delete API: '||x_return_status, 1, 'Y');
954: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
955: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
956: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
957: END IF;
950:
951: IF aso_debug_pub.g_debug_flag = 'Y' THEN
952: aso_debug_pub.add('After Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension ', 1, 'Y');
953: aso_debug_pub.add('Return Status from IBY Delete API: '||x_return_status, 1, 'Y');
954: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
955: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
956: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
957: END IF;
958:
951: IF aso_debug_pub.g_debug_flag = 'Y' THEN
952: aso_debug_pub.add('After Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension ', 1, 'Y');
953: aso_debug_pub.add('Return Status from IBY Delete API: '||x_return_status, 1, 'Y');
954: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
955: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
956: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
957: END IF;
958:
959: if x_return_status <> fnd_api.g_ret_sts_success then
952: aso_debug_pub.add('After Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension ', 1, 'Y');
953: aso_debug_pub.add('Return Status from IBY Delete API: '||x_return_status, 1, 'Y');
954: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
955: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
956: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
957: END IF;
958:
959: if x_return_status <> fnd_api.g_ret_sts_success then
960: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
981: if (l_payment_rec.payment_ref_number is not null and l_payment_rec.payment_ref_number <> fnd_api.g_miss_char ) then
982: -- this is again similar to create flow , create card and assignment, if needed and update extension
983: -- this is the quoting flow
984: -- call api to create credit card and assigment , if needed
985: IF aso_debug_pub.g_debug_flag = 'Y' THEN
986: aso_debug_pub.add('Before calling create_iby_payment' , 1, 'Y');
987: END IF;
988:
989: If ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then
982: -- this is again similar to create flow , create card and assignment, if needed and update extension
983: -- this is the quoting flow
984: -- call api to create credit card and assigment , if needed
985: IF aso_debug_pub.g_debug_flag = 'Y' THEN
986: aso_debug_pub.add('Before calling create_iby_payment' , 1, 'Y');
987: END IF;
988:
989: If ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then
990: l_payer.party_id := l_qte_line_rec.invoice_to_cust_party_id;
999: x_return_status => x_return_status ,
1000: x_msg_count => x_msg_count,
1001: x_msg_data => x_msg_data);
1002:
1003: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1004: aso_debug_pub.add('after calling create_iby_payment ', 1, 'Y');
1005: aso_debug_pub.add('create_iby_payment Return Status: '||x_return_status, 1, 'Y');
1006: END IF;
1007:
1000: x_msg_count => x_msg_count,
1001: x_msg_data => x_msg_data);
1002:
1003: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1004: aso_debug_pub.add('after calling create_iby_payment ', 1, 'Y');
1005: aso_debug_pub.add('create_iby_payment Return Status: '||x_return_status, 1, 'Y');
1006: END IF;
1007:
1008: if x_return_status <> fnd_api.g_ret_sts_success then
1001: x_msg_data => x_msg_data);
1002:
1003: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1004: aso_debug_pub.add('after calling create_iby_payment ', 1, 'Y');
1005: aso_debug_pub.add('create_iby_payment Return Status: '||x_return_status, 1, 'Y');
1006: END IF;
1007:
1008: if x_return_status <> fnd_api.g_ret_sts_success then
1009: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1054: l_card_instrument.card_issuer := l_payment_rec.credit_card_code;
1055: end if;
1056:
1057:
1058: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1059: aso_debug_pub.add('Before calling IBY_FNDCPT_SETUP_PUB.Update_Card', 1, 'Y');
1060: aso_debug_pub.add('Instrument id: '|| l_payment_rec.instrument_id, 1, 'Y');
1061: END IF;
1062: IBY_FNDCPT_SETUP_PUB.Update_Card
1055: end if;
1056:
1057:
1058: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1059: aso_debug_pub.add('Before calling IBY_FNDCPT_SETUP_PUB.Update_Card', 1, 'Y');
1060: aso_debug_pub.add('Instrument id: '|| l_payment_rec.instrument_id, 1, 'Y');
1061: END IF;
1062: IBY_FNDCPT_SETUP_PUB.Update_Card
1063: (
1056:
1057:
1058: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1059: aso_debug_pub.add('Before calling IBY_FNDCPT_SETUP_PUB.Update_Card', 1, 'Y');
1060: aso_debug_pub.add('Instrument id: '|| l_payment_rec.instrument_id, 1, 'Y');
1061: END IF;
1062: IBY_FNDCPT_SETUP_PUB.Update_Card
1063: (
1064: p_api_version => 1.0,
1068: x_msg_count => x_msg_count,
1069: x_msg_data => x_msg_data,
1070: p_card_instrument => l_card_instrument,
1071: x_response => lx_response);
1072: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1073: aso_debug_pub.add('after calling IBY_FNDCPT_SETUP_PUB.Update_Card', 1, 'Y');
1074: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
1075: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1076: aso_debug_pub.add('x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
1069: x_msg_data => x_msg_data,
1070: p_card_instrument => l_card_instrument,
1071: x_response => lx_response);
1072: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1073: aso_debug_pub.add('after calling IBY_FNDCPT_SETUP_PUB.Update_Card', 1, 'Y');
1074: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
1075: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1076: aso_debug_pub.add('x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
1077: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1070: p_card_instrument => l_card_instrument,
1071: x_response => lx_response);
1072: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1073: aso_debug_pub.add('after calling IBY_FNDCPT_SETUP_PUB.Update_Card', 1, 'Y');
1074: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
1075: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1076: aso_debug_pub.add('x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
1077: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1078: END IF;
1071: x_response => lx_response);
1072: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1073: aso_debug_pub.add('after calling IBY_FNDCPT_SETUP_PUB.Update_Card', 1, 'Y');
1074: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
1075: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1076: aso_debug_pub.add('x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
1077: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1078: END IF;
1079:
1072: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1073: aso_debug_pub.add('after calling IBY_FNDCPT_SETUP_PUB.Update_Card', 1, 'Y');
1074: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
1075: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1076: aso_debug_pub.add('x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
1077: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1078: END IF;
1079:
1080: if x_return_status <> fnd_api.g_ret_sts_success then
1073: aso_debug_pub.add('after calling IBY_FNDCPT_SETUP_PUB.Update_Card', 1, 'Y');
1074: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
1075: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1076: aso_debug_pub.add('x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
1077: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1078: END IF;
1079:
1080: if x_return_status <> fnd_api.g_ret_sts_success then
1081: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1107:
1108: END IF; -- trxn_extension_id not null check
1109: end if;
1110:
1111: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1112: aso_debug_pub.add('l_payer.party_id: '|| l_payer.party_id, 1, 'Y');
1113: aso_debug_pub.add('l_orig_party_id: '|| l_orig_party_id, 1, 'Y');
1114: aso_debug_pub.add('l_shared_cart_scenario: '|| l_shared_cart_scenario, 1, 'Y');
1115: END IF;
1108: END IF; -- trxn_extension_id not null check
1109: end if;
1110:
1111: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1112: aso_debug_pub.add('l_payer.party_id: '|| l_payer.party_id, 1, 'Y');
1113: aso_debug_pub.add('l_orig_party_id: '|| l_orig_party_id, 1, 'Y');
1114: aso_debug_pub.add('l_shared_cart_scenario: '|| l_shared_cart_scenario, 1, 'Y');
1115: END IF;
1116:
1109: end if;
1110:
1111: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1112: aso_debug_pub.add('l_payer.party_id: '|| l_payer.party_id, 1, 'Y');
1113: aso_debug_pub.add('l_orig_party_id: '|| l_orig_party_id, 1, 'Y');
1114: aso_debug_pub.add('l_shared_cart_scenario: '|| l_shared_cart_scenario, 1, 'Y');
1115: END IF;
1116:
1117: l_trxn_attribs.Originating_Application_Id := 697;
1110:
1111: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1112: aso_debug_pub.add('l_payer.party_id: '|| l_payer.party_id, 1, 'Y');
1113: aso_debug_pub.add('l_orig_party_id: '|| l_orig_party_id, 1, 'Y');
1114: aso_debug_pub.add('l_shared_cart_scenario: '|| l_shared_cart_scenario, 1, 'Y');
1115: END IF;
1116:
1117: l_trxn_attribs.Originating_Application_Id := 697;
1118: l_trxn_attribs.Order_Id := to_char(l_payment_rec.payment_id)||'-'||l_qte_header_rec.quote_number;
1126: End if;
1127:
1128: -- Check to see if cvv2 is mandatory or not
1129: /* In case of updating the trxn no need to check for cvv2 see bug 4746260
1130: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1131: aso_debug_pub.add('Before calling IBY_FNDCPT_TRXN_PUB.Get_Payment_Channel_Attribs ', 1, 'Y');
1132: END IF;
1133:
1134: IBY_FNDCPT_SETUP_PUB.Get_Payment_Channel_Attribs
1127:
1128: -- Check to see if cvv2 is mandatory or not
1129: /* In case of updating the trxn no need to check for cvv2 see bug 4746260
1130: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1131: aso_debug_pub.add('Before calling IBY_FNDCPT_TRXN_PUB.Get_Payment_Channel_Attribs ', 1, 'Y');
1132: END IF;
1133:
1134: IBY_FNDCPT_SETUP_PUB.Get_Payment_Channel_Attribs
1135: (
1141: p_channel_code => 'CREDIT_CARD',
1142: x_channel_attrib_uses => lx_channel_attrib_uses,
1143: x_response => lx_response);
1144:
1145: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1146: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Get_Payment_Channel_Attribs ', 1, 'Y');
1147: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
1148: aso_debug_pub.add('cvv2 use: '||lx_channel_attrib_uses.Instr_SecCode_Use, 1, 'Y');
1149: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1142: x_channel_attrib_uses => lx_channel_attrib_uses,
1143: x_response => lx_response);
1144:
1145: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1146: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Get_Payment_Channel_Attribs ', 1, 'Y');
1147: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
1148: aso_debug_pub.add('cvv2 use: '||lx_channel_attrib_uses.Instr_SecCode_Use, 1, 'Y');
1149: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1150: aso_debug_pub.add('x_response.result_category:'|| to_char(lx_response.result_category), 1, 'Y');
1143: x_response => lx_response);
1144:
1145: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1146: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Get_Payment_Channel_Attribs ', 1, 'Y');
1147: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
1148: aso_debug_pub.add('cvv2 use: '||lx_channel_attrib_uses.Instr_SecCode_Use, 1, 'Y');
1149: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1150: aso_debug_pub.add('x_response.result_category:'|| to_char(lx_response.result_category), 1, 'Y');
1151: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1144:
1145: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1146: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Get_Payment_Channel_Attribs ', 1, 'Y');
1147: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
1148: aso_debug_pub.add('cvv2 use: '||lx_channel_attrib_uses.Instr_SecCode_Use, 1, 'Y');
1149: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1150: aso_debug_pub.add('x_response.result_category:'|| to_char(lx_response.result_category), 1, 'Y');
1151: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1152: END IF;
1145: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1146: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Get_Payment_Channel_Attribs ', 1, 'Y');
1147: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
1148: aso_debug_pub.add('cvv2 use: '||lx_channel_attrib_uses.Instr_SecCode_Use, 1, 'Y');
1149: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1150: aso_debug_pub.add('x_response.result_category:'|| to_char(lx_response.result_category), 1, 'Y');
1151: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1152: END IF;
1153:
1146: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Get_Payment_Channel_Attribs ', 1, 'Y');
1147: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
1148: aso_debug_pub.add('cvv2 use: '||lx_channel_attrib_uses.Instr_SecCode_Use, 1, 'Y');
1149: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1150: aso_debug_pub.add('x_response.result_category:'|| to_char(lx_response.result_category), 1, 'Y');
1151: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1152: END IF;
1153:
1154: IF (nvl(lx_channel_attrib_uses.Instr_SecCode_Use,'null') = 'REQUIRED' and
1147: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
1148: aso_debug_pub.add('cvv2 use: '||lx_channel_attrib_uses.Instr_SecCode_Use, 1, 'Y');
1149: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1150: aso_debug_pub.add('x_response.result_category:'|| to_char(lx_response.result_category), 1, 'Y');
1151: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1152: END IF;
1153:
1154: IF (nvl(lx_channel_attrib_uses.Instr_SecCode_Use,'null') = 'REQUIRED' and
1155: (l_payment_rec.cvv2 is null or l_payment_rec.cvv2 = fnd_api.g_miss_char)) then
1177: IF ( (l_db_payment_rec.trxn_extension_id is not null and l_db_payment_rec.trxn_extension_id <> fnd_api.g_miss_num) and
1178: (l_payment_rec.instr_assignment_id IS NOT NULL AND l_payment_rec.instr_assignment_id <> fnd_api.g_miss_num) and
1179: (l_shared_cart_scenario = 'N')) then
1180:
1181: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1182: aso_debug_pub.add('Before calling IBY_FNDCPT_TRXN_PUB.Update_Transaction_Extension ', 1, 'Y');
1183: aso_debug_pub.add('Instrument Assignment id: '|| l_payment_rec.instr_assignment_id, 1, 'Y');
1184: END IF;
1185:
1178: (l_payment_rec.instr_assignment_id IS NOT NULL AND l_payment_rec.instr_assignment_id <> fnd_api.g_miss_num) and
1179: (l_shared_cart_scenario = 'N')) then
1180:
1181: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1182: aso_debug_pub.add('Before calling IBY_FNDCPT_TRXN_PUB.Update_Transaction_Extension ', 1, 'Y');
1183: aso_debug_pub.add('Instrument Assignment id: '|| l_payment_rec.instr_assignment_id, 1, 'Y');
1184: END IF;
1185:
1186: IBY_FNDCPT_TRXN_PUB.Update_Transaction_Extension
1179: (l_shared_cart_scenario = 'N')) then
1180:
1181: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1182: aso_debug_pub.add('Before calling IBY_FNDCPT_TRXN_PUB.Update_Transaction_Extension ', 1, 'Y');
1183: aso_debug_pub.add('Instrument Assignment id: '|| l_payment_rec.instr_assignment_id, 1, 'Y');
1184: END IF;
1185:
1186: IBY_FNDCPT_TRXN_PUB.Update_Transaction_Extension
1187: (
1198: p_instr_assignment => l_payment_rec.instr_assignment_id,
1199: p_trxn_attribs => l_trxn_attribs,
1200: x_response => lx_response);
1201:
1202: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1203: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Update_Transaction_Extension ', 1, 'Y');
1204: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
1205: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1206: aso_debug_pub.add('x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
1199: p_trxn_attribs => l_trxn_attribs,
1200: x_response => lx_response);
1201:
1202: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1203: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Update_Transaction_Extension ', 1, 'Y');
1204: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
1205: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1206: aso_debug_pub.add('x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
1207: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1200: x_response => lx_response);
1201:
1202: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1203: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Update_Transaction_Extension ', 1, 'Y');
1204: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
1205: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1206: aso_debug_pub.add('x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
1207: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1208: END IF;
1201:
1202: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1203: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Update_Transaction_Extension ', 1, 'Y');
1204: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
1205: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1206: aso_debug_pub.add('x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
1207: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1208: END IF;
1209:
1202: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1203: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Update_Transaction_Extension ', 1, 'Y');
1204: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
1205: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1206: aso_debug_pub.add('x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
1207: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1208: END IF;
1209:
1210: IF x_return_status <> fnd_api.g_ret_sts_success then
1203: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Update_Transaction_Extension ', 1, 'Y');
1204: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
1205: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1206: aso_debug_pub.add('x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
1207: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1208: END IF;
1209:
1210: IF x_return_status <> fnd_api.g_ret_sts_success then
1211: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1227: and l_db_payment_rec.trxn_extension_id <> fnd_api.g_miss_num ) THEN
1228:
1229: -- set the party id to that of the orig user for deleting the trxn
1230: l_payer.party_id := l_orig_party_id;
1231: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1232: aso_debug_pub.add('Before Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension ', 1, 'Y');
1233: aso_debug_pub.add('l_payer.party_id: '|| l_payer.party_id, 1, 'Y');
1234: aso_debug_pub.add('l_db_payment_rec.trxn_extension_id: '|| l_db_payment_rec.trxn_extension_id, 1, 'Y');
1235: END IF;
1228:
1229: -- set the party id to that of the orig user for deleting the trxn
1230: l_payer.party_id := l_orig_party_id;
1231: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1232: aso_debug_pub.add('Before Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension ', 1, 'Y');
1233: aso_debug_pub.add('l_payer.party_id: '|| l_payer.party_id, 1, 'Y');
1234: aso_debug_pub.add('l_db_payment_rec.trxn_extension_id: '|| l_db_payment_rec.trxn_extension_id, 1, 'Y');
1235: END IF;
1236:
1229: -- set the party id to that of the orig user for deleting the trxn
1230: l_payer.party_id := l_orig_party_id;
1231: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1232: aso_debug_pub.add('Before Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension ', 1, 'Y');
1233: aso_debug_pub.add('l_payer.party_id: '|| l_payer.party_id, 1, 'Y');
1234: aso_debug_pub.add('l_db_payment_rec.trxn_extension_id: '|| l_db_payment_rec.trxn_extension_id, 1, 'Y');
1235: END IF;
1236:
1237: IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension
1230: l_payer.party_id := l_orig_party_id;
1231: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1232: aso_debug_pub.add('Before Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension ', 1, 'Y');
1233: aso_debug_pub.add('l_payer.party_id: '|| l_payer.party_id, 1, 'Y');
1234: aso_debug_pub.add('l_db_payment_rec.trxn_extension_id: '|| l_db_payment_rec.trxn_extension_id, 1, 'Y');
1235: END IF;
1236:
1237: IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension
1238: (
1247: p_payer_equivalency => IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,
1248: x_response => lx_response
1249: );
1250:
1251: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1252: aso_debug_pub.add('After Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension ', 1, 'Y');
1253: aso_debug_pub.add('Return Status from IBY Delete API: '||x_return_status, 1, 'Y');
1254: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1255: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
1248: x_response => lx_response
1249: );
1250:
1251: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1252: aso_debug_pub.add('After Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension ', 1, 'Y');
1253: aso_debug_pub.add('Return Status from IBY Delete API: '||x_return_status, 1, 'Y');
1254: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1255: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
1256: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1249: );
1250:
1251: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1252: aso_debug_pub.add('After Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension ', 1, 'Y');
1253: aso_debug_pub.add('Return Status from IBY Delete API: '||x_return_status, 1, 'Y');
1254: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1255: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
1256: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1257: END IF;
1250:
1251: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1252: aso_debug_pub.add('After Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension ', 1, 'Y');
1253: aso_debug_pub.add('Return Status from IBY Delete API: '||x_return_status, 1, 'Y');
1254: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1255: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
1256: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1257: END IF;
1258:
1251: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1252: aso_debug_pub.add('After Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension ', 1, 'Y');
1253: aso_debug_pub.add('Return Status from IBY Delete API: '||x_return_status, 1, 'Y');
1254: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1255: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
1256: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1257: END IF;
1258:
1259: if x_return_status <> fnd_api.g_ret_sts_success then
1252: aso_debug_pub.add('After Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension ', 1, 'Y');
1253: aso_debug_pub.add('Return Status from IBY Delete API: '||x_return_status, 1, 'Y');
1254: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1255: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
1256: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1257: END IF;
1258:
1259: if x_return_status <> fnd_api.g_ret_sts_success then
1260: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1278: end if; -- end if for the l_shared_cart_scenario flag check
1279:
1280: -- The earlier card stored in the db had no transaction ext id so it must be an Istore Fax CC scenario
1281: -- or this is a shared card scenario and cc has been created by shared user, hence create a new trxn ext
1282: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1283: aso_debug_pub.add('No trx ext id exists for cc iStore Fax CC being updated ', 1, 'Y');
1284: aso_debug_pub.add('Before calling IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', 1, 'Y');
1285: aso_debug_pub.add('Instrument Assignment id: '|| l_payment_rec.instr_assignment_id, 1, 'Y');
1286: aso_debug_pub.add('l_payer.party_id: '|| l_payer.party_id,1,'Y');
1279:
1280: -- The earlier card stored in the db had no transaction ext id so it must be an Istore Fax CC scenario
1281: -- or this is a shared card scenario and cc has been created by shared user, hence create a new trxn ext
1282: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1283: aso_debug_pub.add('No trx ext id exists for cc iStore Fax CC being updated ', 1, 'Y');
1284: aso_debug_pub.add('Before calling IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', 1, 'Y');
1285: aso_debug_pub.add('Instrument Assignment id: '|| l_payment_rec.instr_assignment_id, 1, 'Y');
1286: aso_debug_pub.add('l_payer.party_id: '|| l_payer.party_id,1,'Y');
1287: END IF;
1280: -- The earlier card stored in the db had no transaction ext id so it must be an Istore Fax CC scenario
1281: -- or this is a shared card scenario and cc has been created by shared user, hence create a new trxn ext
1282: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1283: aso_debug_pub.add('No trx ext id exists for cc iStore Fax CC being updated ', 1, 'Y');
1284: aso_debug_pub.add('Before calling IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', 1, 'Y');
1285: aso_debug_pub.add('Instrument Assignment id: '|| l_payment_rec.instr_assignment_id, 1, 'Y');
1286: aso_debug_pub.add('l_payer.party_id: '|| l_payer.party_id,1,'Y');
1287: END IF;
1288:
1281: -- or this is a shared card scenario and cc has been created by shared user, hence create a new trxn ext
1282: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1283: aso_debug_pub.add('No trx ext id exists for cc iStore Fax CC being updated ', 1, 'Y');
1284: aso_debug_pub.add('Before calling IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', 1, 'Y');
1285: aso_debug_pub.add('Instrument Assignment id: '|| l_payment_rec.instr_assignment_id, 1, 'Y');
1286: aso_debug_pub.add('l_payer.party_id: '|| l_payer.party_id,1,'Y');
1287: END IF;
1288:
1289: -- Check to see if cvv2 is mandatory or not
1282: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1283: aso_debug_pub.add('No trx ext id exists for cc iStore Fax CC being updated ', 1, 'Y');
1284: aso_debug_pub.add('Before calling IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', 1, 'Y');
1285: aso_debug_pub.add('Instrument Assignment id: '|| l_payment_rec.instr_assignment_id, 1, 'Y');
1286: aso_debug_pub.add('l_payer.party_id: '|| l_payer.party_id,1,'Y');
1287: END IF;
1288:
1289: -- Check to see if cvv2 is mandatory or not
1290: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1286: aso_debug_pub.add('l_payer.party_id: '|| l_payer.party_id,1,'Y');
1287: END IF;
1288:
1289: -- Check to see if cvv2 is mandatory or not
1290: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1291: aso_debug_pub.add('Before calling IBY_FNDCPT_TRXN_PUB.Get_Payment_Channel_Attribs ', 1, 'Y');
1292: END IF;
1293:
1294: IBY_FNDCPT_SETUP_PUB.Get_Payment_Channel_Attribs
1287: END IF;
1288:
1289: -- Check to see if cvv2 is mandatory or not
1290: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1291: aso_debug_pub.add('Before calling IBY_FNDCPT_TRXN_PUB.Get_Payment_Channel_Attribs ', 1, 'Y');
1292: END IF;
1293:
1294: IBY_FNDCPT_SETUP_PUB.Get_Payment_Channel_Attribs
1295: (
1301: p_channel_code => 'CREDIT_CARD',
1302: x_channel_attrib_uses => lx_channel_attrib_uses,
1303: x_response => lx_response);
1304:
1305: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1306: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Get_Payment_Channel_Attribs ', 1, 'Y');
1307: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
1308: aso_debug_pub.add('cvv2 use: '||lx_channel_attrib_uses.Instr_SecCode_Use, 1, 'Y');
1309: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1302: x_channel_attrib_uses => lx_channel_attrib_uses,
1303: x_response => lx_response);
1304:
1305: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1306: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Get_Payment_Channel_Attribs ', 1, 'Y');
1307: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
1308: aso_debug_pub.add('cvv2 use: '||lx_channel_attrib_uses.Instr_SecCode_Use, 1, 'Y');
1309: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1310: aso_debug_pub.add('x_response.result_category:'|| to_char(lx_response.result_category), 1, 'Y');
1303: x_response => lx_response);
1304:
1305: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1306: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Get_Payment_Channel_Attribs ', 1, 'Y');
1307: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
1308: aso_debug_pub.add('cvv2 use: '||lx_channel_attrib_uses.Instr_SecCode_Use, 1, 'Y');
1309: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1310: aso_debug_pub.add('x_response.result_category:'|| to_char(lx_response.result_category), 1, 'Y');
1311: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1304:
1305: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1306: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Get_Payment_Channel_Attribs ', 1, 'Y');
1307: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
1308: aso_debug_pub.add('cvv2 use: '||lx_channel_attrib_uses.Instr_SecCode_Use, 1, 'Y');
1309: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1310: aso_debug_pub.add('x_response.result_category:'|| to_char(lx_response.result_category), 1, 'Y');
1311: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1312: END IF;
1305: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1306: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Get_Payment_Channel_Attribs ', 1, 'Y');
1307: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
1308: aso_debug_pub.add('cvv2 use: '||lx_channel_attrib_uses.Instr_SecCode_Use, 1, 'Y');
1309: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1310: aso_debug_pub.add('x_response.result_category:'|| to_char(lx_response.result_category), 1, 'Y');
1311: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1312: END IF;
1313:
1306: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Get_Payment_Channel_Attribs ', 1, 'Y');
1307: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
1308: aso_debug_pub.add('cvv2 use: '||lx_channel_attrib_uses.Instr_SecCode_Use, 1, 'Y');
1309: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1310: aso_debug_pub.add('x_response.result_category:'|| to_char(lx_response.result_category), 1, 'Y');
1311: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1312: END IF;
1313:
1314: IF (nvl(lx_channel_attrib_uses.Instr_SecCode_Use,'null') = 'REQUIRED' and
1307: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
1308: aso_debug_pub.add('cvv2 use: '||lx_channel_attrib_uses.Instr_SecCode_Use, 1, 'Y');
1309: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1310: aso_debug_pub.add('x_response.result_category:'|| to_char(lx_response.result_category), 1, 'Y');
1311: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1312: END IF;
1313:
1314: IF (nvl(lx_channel_attrib_uses.Instr_SecCode_Use,'null') = 'REQUIRED' and
1315: (l_payment_rec.cvv2 is null or l_payment_rec.cvv2 = fnd_api.g_miss_char)) then
1336: p_trxn_attribs => l_trxn_attribs,
1337: x_entity_id => lx_entity_id,
1338: x_response => lx_response);
1339:
1340: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1341: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', 1, 'Y');
1342: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
1343: aso_debug_pub.add('lx_entity_id: '||lx_entity_id, 1, 'Y');
1344: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1337: x_entity_id => lx_entity_id,
1338: x_response => lx_response);
1339:
1340: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1341: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', 1, 'Y');
1342: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
1343: aso_debug_pub.add('lx_entity_id: '||lx_entity_id, 1, 'Y');
1344: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1345: aso_debug_pub.add('x_response.result_category:'|| to_char(lx_response.result_category), 1, 'Y');
1338: x_response => lx_response);
1339:
1340: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1341: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', 1, 'Y');
1342: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
1343: aso_debug_pub.add('lx_entity_id: '||lx_entity_id, 1, 'Y');
1344: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1345: aso_debug_pub.add('x_response.result_category:'|| to_char(lx_response.result_category), 1, 'Y');
1346: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1339:
1340: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1341: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', 1, 'Y');
1342: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
1343: aso_debug_pub.add('lx_entity_id: '||lx_entity_id, 1, 'Y');
1344: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1345: aso_debug_pub.add('x_response.result_category:'|| to_char(lx_response.result_category), 1, 'Y');
1346: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1347: END IF;
1340: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1341: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', 1, 'Y');
1342: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
1343: aso_debug_pub.add('lx_entity_id: '||lx_entity_id, 1, 'Y');
1344: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1345: aso_debug_pub.add('x_response.result_category:'|| to_char(lx_response.result_category), 1, 'Y');
1346: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1347: END IF;
1348:
1341: aso_debug_pub.add('after calling IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', 1, 'Y');
1342: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
1343: aso_debug_pub.add('lx_entity_id: '||lx_entity_id, 1, 'Y');
1344: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1345: aso_debug_pub.add('x_response.result_category:'|| to_char(lx_response.result_category), 1, 'Y');
1346: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1347: END IF;
1348:
1349: if x_return_status <> fnd_api.g_ret_sts_success then
1342: aso_debug_pub.add('Return Status: '||x_return_status, 1, 'Y');
1343: aso_debug_pub.add('lx_entity_id: '||lx_entity_id, 1, 'Y');
1344: aso_debug_pub.add('x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1345: aso_debug_pub.add('x_response.result_category:'|| to_char(lx_response.result_category), 1, 'Y');
1346: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1347: END IF;
1348:
1349: if x_return_status <> fnd_api.g_ret_sts_success then
1350: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1371: else
1372: l_payment_ref_number := l_payment_rec.PAYMENT_REF_NUMBER;
1373: END IF;
1374:
1375: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1376: aso_debug_pub.add('before calling the table handler to update the data ', 1, 'Y');
1377: END IF;
1378:
1379: ASO_PAYMENTS_PKG.Update_Row(
1372: l_payment_ref_number := l_payment_rec.PAYMENT_REF_NUMBER;
1373: END IF;
1374:
1375: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1376: aso_debug_pub.add('before calling the table handler to update the data ', 1, 'Y');
1377: END IF;
1378:
1379: ASO_PAYMENTS_PKG.Update_Row(
1380: p_PAYMENT_ID => l_payment_rec.PAYMENT_ID,
1445: ( p_count => x_msg_count,
1446: p_data => x_msg_data
1447: );
1448:
1449: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1450: aso_debug_pub.ADD ('END update_payment_row',1,'N');
1451: END IF;
1452:
1453: EXCEPTION
1446: p_data => x_msg_data
1447: );
1448:
1449: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1450: aso_debug_pub.ADD ('END update_payment_row',1,'N');
1451: END IF;
1452:
1453: EXCEPTION
1454: WHEN FND_API.G_EXC_ERROR THEN
1506:
1507: Begin
1508:
1509: SAVEPOINT DELETE_PAYMENT_ROW_INT;
1510: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1511:
1512: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1513: aso_debug_pub.add('Begin delete_payment_row ', 1, 'Y');
1514: END IF;
1508:
1509: SAVEPOINT DELETE_PAYMENT_ROW_INT;
1510: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1511:
1512: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1513: aso_debug_pub.add('Begin delete_payment_row ', 1, 'Y');
1514: END IF;
1515:
1516: x_return_status := FND_API.G_RET_STS_SUCCESS;
1509: SAVEPOINT DELETE_PAYMENT_ROW_INT;
1510: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1511:
1512: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1513: aso_debug_pub.add('Begin delete_payment_row ', 1, 'Y');
1514: END IF;
1515:
1516: x_return_status := FND_API.G_RET_STS_SUCCESS;
1517:
1530: l_payment_rec := l_payment_tbl(1);
1531:
1532: if l_payment_tbl.count > 0 and l_payment_rec.payment_type_code = 'CREDIT_CARD' then
1533:
1534: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1535: aso_debug_pub.add('Database payment_type_code is : '|| l_payment_rec.payment_type_code, 1, 'Y');
1536: END IF;
1537:
1538: l_payer.payment_function := 'CUSTOMER_PAYMENT';
1531:
1532: if l_payment_tbl.count > 0 and l_payment_rec.payment_type_code = 'CREDIT_CARD' then
1533:
1534: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1535: aso_debug_pub.add('Database payment_type_code is : '|| l_payment_rec.payment_type_code, 1, 'Y');
1536: END IF;
1537:
1538: l_payer.payment_function := 'CUSTOMER_PAYMENT';
1539: l_payer.cust_account_id := null;
1543: fetch c_get_payer_from_trxn into l_payer.party_id;
1544: close c_get_payer_from_trxn;
1545:
1546:
1547: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1548: aso_debug_pub.add('Before Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension ', 1, 'Y');
1549: aso_debug_pub.add('l_payer.party_id: '|| l_payer.party_id, 1, 'Y');
1550: aso_debug_pub.add('l_payment_rec.trxn_extension_id: '|| l_payment_rec.trxn_extension_id, 1, 'Y');
1551: END IF;
1544: close c_get_payer_from_trxn;
1545:
1546:
1547: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1548: aso_debug_pub.add('Before Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension ', 1, 'Y');
1549: aso_debug_pub.add('l_payer.party_id: '|| l_payer.party_id, 1, 'Y');
1550: aso_debug_pub.add('l_payment_rec.trxn_extension_id: '|| l_payment_rec.trxn_extension_id, 1, 'Y');
1551: END IF;
1552:
1545:
1546:
1547: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1548: aso_debug_pub.add('Before Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension ', 1, 'Y');
1549: aso_debug_pub.add('l_payer.party_id: '|| l_payer.party_id, 1, 'Y');
1550: aso_debug_pub.add('l_payment_rec.trxn_extension_id: '|| l_payment_rec.trxn_extension_id, 1, 'Y');
1551: END IF;
1552:
1553: IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension
1546:
1547: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1548: aso_debug_pub.add('Before Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension ', 1, 'Y');
1549: aso_debug_pub.add('l_payer.party_id: '|| l_payer.party_id, 1, 'Y');
1550: aso_debug_pub.add('l_payment_rec.trxn_extension_id: '|| l_payment_rec.trxn_extension_id, 1, 'Y');
1551: END IF;
1552:
1553: IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension
1554: (
1563: p_payer_equivalency => IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_UPWARD,
1564: x_response => lx_response
1565: );
1566:
1567: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1568: aso_debug_pub.add('After Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension ', 1, 'Y');
1569: aso_debug_pub.add('Return Status from IBY Delete API: '||x_return_status, 1, 'Y');
1570: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1571: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
1564: x_response => lx_response
1565: );
1566:
1567: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1568: aso_debug_pub.add('After Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension ', 1, 'Y');
1569: aso_debug_pub.add('Return Status from IBY Delete API: '||x_return_status, 1, 'Y');
1570: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1571: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
1572: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1565: );
1566:
1567: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1568: aso_debug_pub.add('After Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension ', 1, 'Y');
1569: aso_debug_pub.add('Return Status from IBY Delete API: '||x_return_status, 1, 'Y');
1570: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1571: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
1572: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1573: END IF;
1566:
1567: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1568: aso_debug_pub.add('After Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension ', 1, 'Y');
1569: aso_debug_pub.add('Return Status from IBY Delete API: '||x_return_status, 1, 'Y');
1570: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1571: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
1572: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1573: END IF;
1574:
1567: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1568: aso_debug_pub.add('After Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension ', 1, 'Y');
1569: aso_debug_pub.add('Return Status from IBY Delete API: '||x_return_status, 1, 'Y');
1570: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1571: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
1572: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1573: END IF;
1574:
1575: if x_return_status <> fnd_api.g_ret_sts_success then
1568: aso_debug_pub.add('After Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension ', 1, 'Y');
1569: aso_debug_pub.add('Return Status from IBY Delete API: '||x_return_status, 1, 'Y');
1570: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_code: '|| to_char(lx_response.result_code), 1, 'Y');
1571: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
1572: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1573: END IF;
1574:
1575: if x_return_status <> fnd_api.g_ret_sts_success then
1576: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1599: ( p_count => x_msg_count,
1600: p_data => x_msg_data
1601: );
1602:
1603: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1604: aso_debug_pub.ADD ('END delete_payment_row',1,'N');
1605: END IF;
1606:
1607: EXCEPTION
1600: p_data => x_msg_data
1601: );
1602:
1603: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1604: aso_debug_pub.ADD ('END delete_payment_row',1,'N');
1605: END IF;
1606:
1607: EXCEPTION
1608: WHEN FND_API.G_EXC_ERROR THEN