eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_PAYMENT_TRXN_UTIL dependencies on FND_API

Line 167: RAISE FND_API.G_EXC_ERROR;

163: oe_debug_pub.add('Invoice to org id'||l_invoice_to_org_id);
164: oe_debug_pub.add('Org id'||l_org_id);
165: oe_debug_pub.add('payment_number'||p_payment_number);
166: oe_debug_pub.add('Return status'||l_return_status||l_msg_data);
167: RAISE FND_API.G_EXC_ERROR;
168: END IF;
169: END;
170:
171: --Getting the instrument type based on

Line 222: p_commit => FND_API.G_FALSE,

218: END IF;
219:
220: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment
221: (p_api_version => 1.0,
222: p_commit => FND_API.G_FALSE,
223: X_return_status => l_return_status,
224: X_msg_count => l_msg_count,
225: X_msg_data => l_msg_data,
226: P_payer => l_payer,

Line 231: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

227: P_assignment_attribs => l_assignment_attribs,
228: X_assign_id => l_assign_id,
229: X_response => l_response_code);
230:
231: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
232: IF l_debug_level > 0 THEN
233: oe_debug_pub.add('Result error code in set payer instr assignment'||l_response_code.result_code);
234: END IF;
235: RAISE FND_API.G_EXC_ERROR;

Line 235: RAISE FND_API.G_EXC_ERROR;

231: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
232: IF l_debug_level > 0 THEN
233: oe_debug_pub.add('Result error code in set payer instr assignment'||l_response_code.result_code);
234: END IF;
235: RAISE FND_API.G_EXC_ERROR;
236: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
237: IF l_debug_level > 0 THEN
238: oe_debug_pub.add('Result error code in set payer instr assignment'||l_response_code.result_code);
239: END IF;

Line 236: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

232: IF l_debug_level > 0 THEN
233: oe_debug_pub.add('Result error code in set payer instr assignment'||l_response_code.result_code);
234: END IF;
235: RAISE FND_API.G_EXC_ERROR;
236: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
237: IF l_debug_level > 0 THEN
238: oe_debug_pub.add('Result error code in set payer instr assignment'||l_response_code.result_code);
239: END IF;
240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

236: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
237: IF l_debug_level > 0 THEN
238: oe_debug_pub.add('Result error code in set payer instr assignment'||l_response_code.result_code);
239: END IF;
240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
241: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
242: IF l_debug_level > 0 THEN
243: oe_debug_pub.add('Set Payer instr assignment Successful....');
244: oe_debug_pub.add('After calling Set_Payer_Instr_Assignment');

Line 241: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN

237: IF l_debug_level > 0 THEN
238: oe_debug_pub.add('Result error code in set payer instr assignment'||l_response_code.result_code);
239: END IF;
240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
241: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
242: IF l_debug_level > 0 THEN
243: oe_debug_pub.add('Set Payer instr assignment Successful....');
244: oe_debug_pub.add('After calling Set_Payer_Instr_Assignment');
245: oe_debug_pub.add('Instr assignment id'||l_assign_id);

Line 264: p_init_msg_list => FND_API.G_TRUE,

260: END IF;
261: IBY_FNDCPT_SETUP_PUB.Update_Card
262: (
263: p_api_version => 1.0,
264: p_init_msg_list => FND_API.G_TRUE,
265: p_commit => FND_API.G_FALSE,
266: x_return_status => l_return_status,
267: X_msg_count => l_msg_count,
268: X_msg_data => l_msg_data,

Line 265: p_commit => FND_API.G_FALSE,

261: IBY_FNDCPT_SETUP_PUB.Update_Card
262: (
263: p_api_version => 1.0,
264: p_init_msg_list => FND_API.G_TRUE,
265: p_commit => FND_API.G_FALSE,
266: x_return_status => l_return_status,
267: X_msg_count => l_msg_count,
268: X_msg_data => l_msg_data,
269: p_card_instrument => l_credit_card_rec,

Line 273: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

269: p_card_instrument => l_credit_card_rec,
270: x_response => l_response_code
271: );
272: --oe_msg_pub.add_text(p_message_text => l_response_code.result_message);
273: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
274: IF l_debug_level > 0 THEN
275: oe_debug_pub.add('Result error code in Update_Card exp'||l_response_code.result_code);
276: END IF;
277: RAISE FND_API.G_EXC_ERROR;

Line 277: RAISE FND_API.G_EXC_ERROR;

273: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
274: IF l_debug_level > 0 THEN
275: oe_debug_pub.add('Result error code in Update_Card exp'||l_response_code.result_code);
276: END IF;
277: RAISE FND_API.G_EXC_ERROR;
278: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
279: IF l_debug_level > 0 THEN
280: oe_debug_pub.add('Result error code in Update_Card unxc'||l_response_code.result_code);
281: END IF;

Line 278: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

274: IF l_debug_level > 0 THEN
275: oe_debug_pub.add('Result error code in Update_Card exp'||l_response_code.result_code);
276: END IF;
277: RAISE FND_API.G_EXC_ERROR;
278: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
279: IF l_debug_level > 0 THEN
280: oe_debug_pub.add('Result error code in Update_Card unxc'||l_response_code.result_code);
281: END IF;
282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

278: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
279: IF l_debug_level > 0 THEN
280: oe_debug_pub.add('Result error code in Update_Card unxc'||l_response_code.result_code);
281: END IF;
282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
283: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
284: IF l_debug_level > 0 THEN
285: oe_debug_pub.add('Update_Card Successful....');
286: oe_debug_pub.add('Return status '||l_return_status);

Line 283: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN

279: IF l_debug_level > 0 THEN
280: oe_debug_pub.add('Result error code in Update_Card unxc'||l_response_code.result_code);
281: END IF;
282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
283: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
284: IF l_debug_level > 0 THEN
285: oe_debug_pub.add('Update_Card Successful....');
286: oe_debug_pub.add('Return status '||l_return_status);
287: END IF;

Line 301: p_commit => FND_API.G_FALSE,

297: END IF;
298:
299: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment
300: (p_api_version => 1.0,
301: p_commit => FND_API.G_FALSE,
302: X_return_status => l_return_status,
303: X_msg_count => l_msg_count,
304: X_msg_data => l_msg_data,
305: P_payer => l_payer,

Line 310: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

306: P_assignment_attribs => l_assignment_attribs,
307: X_assign_id => l_assign_id,
308: X_response => l_response_code);
309:
310: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
311: IF l_debug_level > 0 THEN
312: oe_debug_pub.add('Result error code in set payer instr assignment'||l_response_code.result_code);
313: END IF;
314: RAISE FND_API.G_EXC_ERROR;

Line 314: RAISE FND_API.G_EXC_ERROR;

310: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
311: IF l_debug_level > 0 THEN
312: oe_debug_pub.add('Result error code in set payer instr assignment'||l_response_code.result_code);
313: END IF;
314: RAISE FND_API.G_EXC_ERROR;
315: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
316: IF l_debug_level > 0 THEN
317: oe_debug_pub.add('Result error code in set payer instr assignment'||l_response_code.result_code);
318: END IF;

Line 315: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

311: IF l_debug_level > 0 THEN
312: oe_debug_pub.add('Result error code in set payer instr assignment'||l_response_code.result_code);
313: END IF;
314: RAISE FND_API.G_EXC_ERROR;
315: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
316: IF l_debug_level > 0 THEN
317: oe_debug_pub.add('Result error code in set payer instr assignment'||l_response_code.result_code);
318: END IF;
319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

315: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
316: IF l_debug_level > 0 THEN
317: oe_debug_pub.add('Result error code in set payer instr assignment'||l_response_code.result_code);
318: END IF;
319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
320: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
321: IF l_debug_level > 0 THEN
322: oe_debug_pub.add('Set Payer instr assignment Successful....');
323: oe_debug_pub.add('After calling Set_Payer_Instr_Assignment');

Line 320: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN

316: IF l_debug_level > 0 THEN
317: oe_debug_pub.add('Result error code in set payer instr assignment'||l_response_code.result_code);
318: END IF;
319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
320: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
321: IF l_debug_level > 0 THEN
322: oe_debug_pub.add('Set Payer instr assignment Successful....');
323: oe_debug_pub.add('After calling Set_Payer_Instr_Assignment');
324: oe_debug_pub.add('Instr assignment id'||l_assign_id);

Line 354: p_commit => FND_API.G_FALSE,

350: IF L_credit_card_rec.card_number IS NOT NULL THEN
351: IBY_FNDCPT_SETUP_PUB.Process_Credit_Card
352: (
353: p_api_version => 1.0,
354: p_commit => FND_API.G_FALSE,
355: X_return_status => l_return_status,
356: X_msg_count => l_msg_count,
357: X_msg_data => l_msg_data,
358: P_payer => l_payer,

Line 366: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

362: X_response => l_response_code
363: );
364: --oe_msg_pub.add_text(p_message_text => l_response_code.result_message);
365:
366: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
367: IF l_debug_level > 0 THEN
368: oe_debug_pub.add('Result error code in Process_Credit_Card -->'||l_response_code.result_code);
369: END IF;
370: IF l_response_code.result_code = 'INVALID_CARD_NUMBER' THEN

Line 395: RAISE FND_API.G_EXC_ERROR;

391: IF l_debug_level > 0 THEN
392: oe_debug_pub.add( 'OEXUPTXB: Setting the generic message' ) ;
393: END IF;
394: END IF;
395: RAISE FND_API.G_EXC_ERROR;
396: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
397: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET'); --bug 5244099
398: OE_MSG_PUB.ADD;
399: IF l_debug_level > 0 THEN

Line 396: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

392: oe_debug_pub.add( 'OEXUPTXB: Setting the generic message' ) ;
393: END IF;
394: END IF;
395: RAISE FND_API.G_EXC_ERROR;
396: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
397: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET'); --bug 5244099
398: OE_MSG_PUB.ADD;
399: IF l_debug_level > 0 THEN
400: oe_debug_pub.add('Unexpected result error code in Process_Credit_Card-->'||l_response_code.result_code);

Line 402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

398: OE_MSG_PUB.ADD;
399: IF l_debug_level > 0 THEN
400: oe_debug_pub.add('Unexpected result error code in Process_Credit_Card-->'||l_response_code.result_code);
401: END IF;
402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
403: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
404: IF l_debug_level > 0 THEN
405: oe_debug_pub.add('Process_Credit_Card assignment Successful....');
406: oe_debug_pub.add('After calling Process_Credit_Card');

Line 403: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN

399: IF l_debug_level > 0 THEN
400: oe_debug_pub.add('Unexpected result error code in Process_Credit_Card-->'||l_response_code.result_code);
401: END IF;
402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
403: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
404: IF l_debug_level > 0 THEN
405: oe_debug_pub.add('Process_Credit_Card assignment Successful....');
406: oe_debug_pub.add('After calling Process_Credit_Card');
407: oe_debug_pub.add('Instr assignment id'||l_assign_id);

Line 452: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

448: X_trxn_attribs => l_trxn_attribs,
449: --x_authorized => l_authorized,
450: --x_settled => l_settled,
451: X_response => l_response_code);
452: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
453: IF l_debug_level > 0 THEN
454: oe_debug_pub.add('Result error code in Get_Transaction_Extension'||l_response_code.result_code);
455: END IF;
456: RAISE FND_API.G_EXC_ERROR;

Line 456: RAISE FND_API.G_EXC_ERROR;

452: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
453: IF l_debug_level > 0 THEN
454: oe_debug_pub.add('Result error code in Get_Transaction_Extension'||l_response_code.result_code);
455: END IF;
456: RAISE FND_API.G_EXC_ERROR;
457: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
458: IF l_debug_level > 0 THEN
459: oe_debug_pub.add('Result error code in Get_Transaction_Extension'||l_response_code.result_code);
460: END IF;

Line 457: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

453: IF l_debug_level > 0 THEN
454: oe_debug_pub.add('Result error code in Get_Transaction_Extension'||l_response_code.result_code);
455: END IF;
456: RAISE FND_API.G_EXC_ERROR;
457: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
458: IF l_debug_level > 0 THEN
459: oe_debug_pub.add('Result error code in Get_Transaction_Extension'||l_response_code.result_code);
460: END IF;
461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

457: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
458: IF l_debug_level > 0 THEN
459: oe_debug_pub.add('Result error code in Get_Transaction_Extension'||l_response_code.result_code);
460: END IF;
461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
462: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
463: IF l_debug_level > 0 THEN
464: oe_debug_pub.add('Get_Transaction_Extension assignment Successful....');
465: oe_debug_pub.add('After call to Get Transaction Extension'||l_return_status);

Line 462: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN

458: IF l_debug_level > 0 THEN
459: oe_debug_pub.add('Result error code in Get_Transaction_Extension'||l_response_code.result_code);
460: END IF;
461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
462: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
463: IF l_debug_level > 0 THEN
464: oe_debug_pub.add('Get_Transaction_Extension assignment Successful....');
465: oe_debug_pub.add('After call to Get Transaction Extension'||l_return_status);
466: oe_debug_pub.add('After call to get trxn...instr sec code'||l_trxn_attribs.instrument_security_code);

Line 526: p_init_msg_list => FND_API.G_TRUE,

522: END IF;
523:
524: IBY_Fndcpt_Trxn_Pub.Create_Transaction_Extension
525: (p_api_version => 1.0,
526: p_init_msg_list => FND_API.G_TRUE,
527: p_commit => FND_API.G_FALSE,
528: X_return_status => l_return_status,
529: X_msg_count => l_msg_count,
530: X_msg_data => l_msg_data,

Line 527: p_commit => FND_API.G_FALSE,

523:
524: IBY_Fndcpt_Trxn_Pub.Create_Transaction_Extension
525: (p_api_version => 1.0,
526: p_init_msg_list => FND_API.G_TRUE,
527: p_commit => FND_API.G_FALSE,
528: X_return_status => l_return_status,
529: X_msg_count => l_msg_count,
530: X_msg_data => l_msg_data,
531: P_payer => l_payer,

Line 547: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

543: oe_debug_pub.add('Result code'||l_Response_code.result_code);
544: oe_debug_pub.add('Return status'||l_Return_Status);
545: END IF;
546:
547: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
548: IF l_debug_level > 0 THEN
549: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
550: END IF;
551: RAISE FND_API.G_EXC_ERROR;

Line 551: RAISE FND_API.G_EXC_ERROR;

547: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
548: IF l_debug_level > 0 THEN
549: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
550: END IF;
551: RAISE FND_API.G_EXC_ERROR;
552: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
553: IF l_debug_level > 0 THEN
554: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
555: END IF;

Line 552: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

548: IF l_debug_level > 0 THEN
549: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
550: END IF;
551: RAISE FND_API.G_EXC_ERROR;
552: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
553: IF l_debug_level > 0 THEN
554: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
555: END IF;
556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

552: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
553: IF l_debug_level > 0 THEN
554: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
555: END IF;
556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
557: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
558: IF l_debug_level > 0 THEN
559: oe_debug_pub.add('Create_Transaction_Extension assignment Successful....');
560: oe_debug_pub.add('After call to Create_Transaction_Extension'||l_return_status);

Line 557: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN

553: IF l_debug_level > 0 THEN
554: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
555: END IF;
556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
557: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
558: IF l_debug_level > 0 THEN
559: oe_debug_pub.add('Create_Transaction_Extension assignment Successful....');
560: oe_debug_pub.add('After call to Create_Transaction_Extension'||l_return_status);
561: oe_debug_pub.add('After call to create Transaction Extension');

Line 581: X_return_status := FND_API.G_RET_STS_SUCCESS;

577: END IF;
578: END IF;
579: --bug 5176015
580: P_x_trxn_extension_id := l_trxn_extension_id;
581: X_return_status := FND_API.G_RET_STS_SUCCESS;
582: IF l_debug_level > 0 THEN
583: oe_debug_pub.add('Exiting Create_Payment_Trxn.....');
584: END IF;
585: EXCEPTION

Line 587: WHEN FND_API.G_EXC_ERROR THEN

583: oe_debug_pub.add('Exiting Create_Payment_Trxn.....');
584: END IF;
585: EXCEPTION
586:
587: WHEN FND_API.G_EXC_ERROR THEN
588: l_err_message := SQLERRM;
589: IF l_debug_level > 0 THEN
590: oe_debug_pub.add('Create_Transaction_Extension assignment error....exc');
591: oe_debug_pub.add('After call to Create_Transaction_Extension'||l_return_status);

Line 596: X_return_status := FND_API.G_RET_STS_ERROR;

592: oe_debug_pub.add('Result code'||l_response_code.result_code);
593: oe_debug_pub.add('Error'||l_err_message);
594: END IF;
595:
596: X_return_status := FND_API.G_RET_STS_ERROR;
597: OE_MSG_PUB.Count_And_Get
598: ( p_count => l_msg_count,
599: p_data => l_msg_data
600: );

Line 601: RAISE FND_API.G_EXC_ERROR;

597: OE_MSG_PUB.Count_And_Get
598: ( p_count => l_msg_count,
599: p_data => l_msg_data
600: );
601: RAISE FND_API.G_EXC_ERROR;
602:
603: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
604: l_err_message := SQLERRM;
605: IF l_debug_level > 0 THEN

Line 603: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

599: p_data => l_msg_data
600: );
601: RAISE FND_API.G_EXC_ERROR;
602:
603: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
604: l_err_message := SQLERRM;
605: IF l_debug_level > 0 THEN
606: oe_debug_pub.add('Create_Transaction_Extension assignment error....unxc');
607: oe_debug_pub.add('After call to Create_Transaction_Extension'||l_return_status);

Line 612: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

608: oe_debug_pub.add('Result code'||l_response_code.result_code);
609: oe_debug_pub.add('f Error'||l_err_message);
610: END IF;
611:
612: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
613: OE_MSG_PUB.Count_And_Get
614: ( p_count => l_msg_count,
615: p_data => l_msg_data
616: );

Line 617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

613: OE_MSG_PUB.Count_And_Get
614: ( p_count => l_msg_count,
615: p_data => l_msg_data
616: );
617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
618:
619: WHEN OTHERS THEN
620: l_err_message := SQLERRM;
621: IF l_debug_level > 0 THEN

Line 628: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

624: oe_debug_pub.add('Result code'||l_response_code.result_code);
625: oe_debug_pub.add('trx Error'||l_err_message);
626: END IF;
627:
628: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
629: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
630: THEN
631: FND_MSG_PUB.Add_Exc_Msg
632: ( G_PKG_NAME

Line 641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

637: OE_MSG_PUB.Count_And_Get
638: ( p_count => l_msg_count,
639: p_data => l_msg_data
640: );
641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
642: END Create_Payment_Trxn;
643:
644: Procedure Update_Payment_Trxn
645: (p_header_id IN NUMBER,

Line 843: p_commit => FND_API.G_FALSE,

839:
840: --
841: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment
842: (p_api_version => 1.0,
843: p_commit => FND_API.G_FALSE,
844: X_return_status => l_return_status,
845: X_msg_count => l_msg_count,
846: X_msg_data => l_msg_data,
847: P_payer => l_payer,

Line 854: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

850: X_response => l_response_code);
851:
852: --oe_msg_pub.add_text(p_message_text => l_response_code.result_message);
853:
854: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
855: IF l_debug_level > 0 THEN
856: oe_debug_pub.add('Result error code in Set_Payer_Instr_Assignment'||l_response_code.result_code);
857: END IF;
858: IF l_response_code.result_code = 'INVALID_CARD_NUMBER' THEN

Line 877: RAISE FND_API.G_EXC_ERROR;

873: IF l_debug_level > 0 THEN
874: oe_debug_pub.add( 'OEXUPTXB: Invalid billing address' ) ;
875: END IF;
876: END IF;
877: RAISE FND_API.G_EXC_ERROR;
878: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
879: IF l_debug_level > 0 THEN
880: oe_debug_pub.add('Result error code in Set_Payer_Instr_Assignment'||l_response_code.result_code);
881: END IF;

Line 878: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

874: oe_debug_pub.add( 'OEXUPTXB: Invalid billing address' ) ;
875: END IF;
876: END IF;
877: RAISE FND_API.G_EXC_ERROR;
878: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
879: IF l_debug_level > 0 THEN
880: oe_debug_pub.add('Result error code in Set_Payer_Instr_Assignment'||l_response_code.result_code);
881: END IF;
882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

878: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
879: IF l_debug_level > 0 THEN
880: oe_debug_pub.add('Result error code in Set_Payer_Instr_Assignment'||l_response_code.result_code);
881: END IF;
882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
883: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
884: IF l_debug_level > 0 THEN
885: oe_debug_pub.add('Set_Payer_Instr_Assignment assignment Successful....');
886: oe_debug_pub.add('After calling Set_Payer_Instr_Assignment');

Line 883: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN

879: IF l_debug_level > 0 THEN
880: oe_debug_pub.add('Result error code in Set_Payer_Instr_Assignment'||l_response_code.result_code);
881: END IF;
882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
883: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
884: IF l_debug_level > 0 THEN
885: oe_debug_pub.add('Set_Payer_Instr_Assignment assignment Successful....');
886: oe_debug_pub.add('After calling Set_Payer_Instr_Assignment');
887: oe_debug_pub.add('Instr assignment id'||l_assign_id);

Line 913: p_init_msg_list => FND_API.G_TRUE,

909: l_credit_Card_rec.card_id := l_instrument_id;
910: IBY_FNDCPT_SETUP_PUB.Update_Card
911: (
912: p_api_version => 1.0,
913: p_init_msg_list => FND_API.G_TRUE,
914: p_commit => FND_API.G_FALSE,
915: x_return_status => l_return_status,
916: X_msg_count => l_msg_count,
917: X_msg_data => l_msg_data,

Line 914: p_commit => FND_API.G_FALSE,

910: IBY_FNDCPT_SETUP_PUB.Update_Card
911: (
912: p_api_version => 1.0,
913: p_init_msg_list => FND_API.G_TRUE,
914: p_commit => FND_API.G_FALSE,
915: x_return_status => l_return_status,
916: X_msg_count => l_msg_count,
917: X_msg_data => l_msg_data,
918: p_card_instrument => l_credit_card_rec,

Line 923: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

919: x_response => l_response_code
920: );
921: --oe_msg_pub.add_text(p_message_text => l_response_code.result_message);
922:
923: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
924: IF l_debug_level > 0 THEN
925: oe_debug_pub.add('Result error code in Update_Card exp'||l_response_code.result_code);
926: END IF;
927: RAISE FND_API.G_EXC_ERROR;

Line 927: RAISE FND_API.G_EXC_ERROR;

923: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
924: IF l_debug_level > 0 THEN
925: oe_debug_pub.add('Result error code in Update_Card exp'||l_response_code.result_code);
926: END IF;
927: RAISE FND_API.G_EXC_ERROR;
928: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
929: IF l_debug_level > 0 THEN
930: oe_debug_pub.add('Result error code in Update_Card unxc'||l_response_code.result_code);
931: END IF;

Line 928: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

924: IF l_debug_level > 0 THEN
925: oe_debug_pub.add('Result error code in Update_Card exp'||l_response_code.result_code);
926: END IF;
927: RAISE FND_API.G_EXC_ERROR;
928: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
929: IF l_debug_level > 0 THEN
930: oe_debug_pub.add('Result error code in Update_Card unxc'||l_response_code.result_code);
931: END IF;
932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

928: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
929: IF l_debug_level > 0 THEN
930: oe_debug_pub.add('Result error code in Update_Card unxc'||l_response_code.result_code);
931: END IF;
932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
933: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
934: IF l_debug_level > 0 THEN
935: oe_debug_pub.add('Update_Card Successful....');
936: oe_debug_pub.add('Return status '||l_return_status);

Line 933: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN

929: IF l_debug_level > 0 THEN
930: oe_debug_pub.add('Result error code in Update_Card unxc'||l_response_code.result_code);
931: END IF;
932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
933: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
934: IF l_debug_level > 0 THEN
935: oe_debug_pub.add('Update_Card Successful....');
936: oe_debug_pub.add('Return status '||l_return_status);
937: END IF;

Line 954: p_commit => FND_API.G_FALSE,

950: l_assignment_attribs.instrument := l_instrument;
951:
952: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment
953: (p_api_version => 1.0,
954: p_commit => FND_API.G_FALSE,
955: X_return_status => l_return_status,
956: X_msg_count => l_msg_count,
957: X_msg_data => l_msg_data,
958: P_payer => l_payer,

Line 963: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

959: P_assignment_attribs => l_assignment_attribs,
960: X_assign_id => l_assign_id,
961: X_response => l_response_code);
962:
963: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
964: IF l_debug_level > 0 THEN
965: oe_debug_pub.add('Result error code in set payer instr assignment'||l_response_code.result_code);
966: END IF;
967: RAISE FND_API.G_EXC_ERROR;

Line 967: RAISE FND_API.G_EXC_ERROR;

963: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
964: IF l_debug_level > 0 THEN
965: oe_debug_pub.add('Result error code in set payer instr assignment'||l_response_code.result_code);
966: END IF;
967: RAISE FND_API.G_EXC_ERROR;
968: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
969: IF l_debug_level > 0 THEN
970: oe_debug_pub.add('Result error code in set payer instr assignment'||l_response_code.result_code);
971: END IF;

Line 968: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

964: IF l_debug_level > 0 THEN
965: oe_debug_pub.add('Result error code in set payer instr assignment'||l_response_code.result_code);
966: END IF;
967: RAISE FND_API.G_EXC_ERROR;
968: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
969: IF l_debug_level > 0 THEN
970: oe_debug_pub.add('Result error code in set payer instr assignment'||l_response_code.result_code);
971: END IF;
972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

968: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
969: IF l_debug_level > 0 THEN
970: oe_debug_pub.add('Result error code in set payer instr assignment'||l_response_code.result_code);
971: END IF;
972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
973: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
974: IF l_debug_level > 0 THEN
975: oe_debug_pub.add('Set Payer instr assignment Successful....');
976: oe_debug_pub.add('After calling Set_Payer_Instr_Assignment');

Line 973: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN

969: IF l_debug_level > 0 THEN
970: oe_debug_pub.add('Result error code in set payer instr assignment'||l_response_code.result_code);
971: END IF;
972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
973: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
974: IF l_debug_level > 0 THEN
975: oe_debug_pub.add('Set Payer instr assignment Successful....');
976: oe_debug_pub.add('After calling Set_Payer_Instr_Assignment');
977: oe_debug_pub.add('Instr assignment id'||l_assign_id);

Line 1004: p_commit => FND_API.G_FALSE,

1000: END IF;
1001:
1002: IBY_FNDCPT_SETUP_PUB.Process_Credit_Card
1003: (p_api_version => 1.0,
1004: p_commit => FND_API.G_FALSE,
1005: X_return_status => l_return_status,
1006: X_msg_count => l_msg_count,
1007: X_msg_data => l_msg_data,
1008: P_payer => l_payer,

Line 1021: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1017: oe_debug_pub.add('After call to process credit card....');
1018: END IF;
1019:
1020:
1021: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1022: IF l_debug_level > 0 THEN
1023: oe_debug_pub.add('Result error code in Process_Credit_Card -->'||l_response_code.result_code);
1024: END IF;
1025: IF l_response_code.result_code = 'INVALID_CARD_NUMBER' THEN

Line 1050: RAISE FND_API.G_EXC_ERROR;

1046: IF l_debug_level > 0 THEN
1047: oe_debug_pub.add( 'OEXUPTXB: Setting the generic message' ) ;
1048: END IF;
1049: END IF;
1050: RAISE FND_API.G_EXC_ERROR;
1051: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1052: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET'); --bug 5244099
1053: OE_MSG_PUB.ADD;
1054: IF l_debug_level > 0 THEN

Line 1051: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1047: oe_debug_pub.add( 'OEXUPTXB: Setting the generic message' ) ;
1048: END IF;
1049: END IF;
1050: RAISE FND_API.G_EXC_ERROR;
1051: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1052: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET'); --bug 5244099
1053: OE_MSG_PUB.ADD;
1054: IF l_debug_level > 0 THEN
1055: oe_debug_pub.add('Unexpected result error code in Process_Credit_Card-->'||l_response_code.result_code);

Line 1057: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1053: OE_MSG_PUB.ADD;
1054: IF l_debug_level > 0 THEN
1055: oe_debug_pub.add('Unexpected result error code in Process_Credit_Card-->'||l_response_code.result_code);
1056: END IF;
1057: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1058: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1059: IF l_debug_level > 0 THEN
1060: oe_debug_pub.add('Process_Credit_Card assignment Successful....');
1061: oe_debug_pub.add('After calling Process_Credit_Card');

Line 1058: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN

1054: IF l_debug_level > 0 THEN
1055: oe_debug_pub.add('Unexpected result error code in Process_Credit_Card-->'||l_response_code.result_code);
1056: END IF;
1057: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1058: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1059: IF l_debug_level > 0 THEN
1060: oe_debug_pub.add('Process_Credit_Card assignment Successful....');
1061: oe_debug_pub.add('After calling Process_Credit_Card');
1062: oe_debug_pub.add('Instr assignment id'||l_assign_id);

Line 1095: l_trxn_attribs.Instrument_Security_Code := FND_API.G_MISS_CHAR;

1091: --the value appropriately.
1092: IF p_instrument_security_code is not null then
1093: l_trxn_attribs.Instrument_Security_Code := p_instrument_security_code;
1094: ELSE
1095: l_trxn_attribs.Instrument_Security_Code := FND_API.G_MISS_CHAR;
1096: END IF;
1097: END IF;
1098:
1099: IF l_debug_level > 0 THEN

Line 1147: NOT OE_GLOBALS.Equal(l_approval_code,FND_API.G_MISS_CHAR))

1143: --If approval code is not null then the transaction
1144: --extension has already been authorized once. So cannot
1145: --call update_transaction API for this trxn_extension_id
1146: IF (l_approval_code IS NOT NULL AND
1147: NOT OE_GLOBALS.Equal(l_approval_code,FND_API.G_MISS_CHAR))
1148: OR l_settled_flag = 'Y' THEN
1149:
1150: IF l_settled_flag = 'N' THEN
1151: -- need to re-authorize if the authorization has expired.

Line 1196: OE_GLOBALS.Equal(l_trxn_attribs.Instrument_Security_Code,FND_API.G_MISS_CHAR))

1192: END IF;
1193:
1194: IF Oe_Payment_Trxn_Util.Get_CC_Security_Code_Use = 'REQUIRED'
1195: AND (l_trxn_attribs.Instrument_Security_Code IS NULL OR
1196: OE_GLOBALS.Equal(l_trxn_attribs.Instrument_Security_Code,FND_API.G_MISS_CHAR))
1197: THEN
1198:
1199: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
1200: OE_Msg_Pub.Add;

Line 1201: RAISE FND_API.G_EXC_ERROR;

1197: THEN
1198:
1199: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
1200: OE_Msg_Pub.Add;
1201: RAISE FND_API.G_EXC_ERROR;
1202:
1203: ELSIF Oe_Payment_Trxn_Util.Get_CC_Security_Code_Use = 'REQUIRED'
1204: AND l_trxn_attribs.Instrument_Security_Code IS NOT NULL
1205: AND NOT OE_GLOBALS.Equal(l_trxn_attribs.Instrument_Security_Code,FND_API.G_MISS_CHAR)

Line 1205: AND NOT OE_GLOBALS.Equal(l_trxn_attribs.Instrument_Security_Code,FND_API.G_MISS_CHAR)

1201: RAISE FND_API.G_EXC_ERROR;
1202:
1203: ELSIF Oe_Payment_Trxn_Util.Get_CC_Security_Code_Use = 'REQUIRED'
1204: AND l_trxn_attribs.Instrument_Security_Code IS NOT NULL
1205: AND NOT OE_GLOBALS.Equal(l_trxn_attribs.Instrument_Security_Code,FND_API.G_MISS_CHAR)
1206: THEN
1207:
1208: -- need to create a new payment transaction extension as the old one has been settled.
1209: IF l_debug_level > 0 THEN

Line 1226: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1222: x_msg_count => x_msg_count,
1223: x_msg_data => x_msg_data,
1224: x_return_status => x_return_status);
1225:
1226: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1227: IF l_debug_level > 0 THEN
1228: oe_debug_pub.add( 'OEXUPTXB.pls: Exp. error in call to Create_New_Payment_Trxn');
1229: oe_debug_pub.add( 'SQL ERRM ----> '||sqlerrm);
1230: END IF;

Line 1231: RAISE FND_API.G_EXC_ERROR;

1227: IF l_debug_level > 0 THEN
1228: oe_debug_pub.add( 'OEXUPTXB.pls: Exp. error in call to Create_New_Payment_Trxn');
1229: oe_debug_pub.add( 'SQL ERRM ----> '||sqlerrm);
1230: END IF;
1231: RAISE FND_API.G_EXC_ERROR;
1232: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1233: IF l_debug_level > 0 THEN
1234: oe_debug_pub.add( 'OEXUPTXB.pls: Unexp. error in call to Create_New_Payment_Trxn');
1235: oe_debug_pub.add( 'SQL ERRM ----> '||sqlerrm);

Line 1232: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1228: oe_debug_pub.add( 'OEXUPTXB.pls: Exp. error in call to Create_New_Payment_Trxn');
1229: oe_debug_pub.add( 'SQL ERRM ----> '||sqlerrm);
1230: END IF;
1231: RAISE FND_API.G_EXC_ERROR;
1232: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1233: IF l_debug_level > 0 THEN
1234: oe_debug_pub.add( 'OEXUPTXB.pls: Unexp. error in call to Create_New_Payment_Trxn');
1235: oe_debug_pub.add( 'SQL ERRM ----> '||sqlerrm);
1236: END IF;

Line 1237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1233: IF l_debug_level > 0 THEN
1234: oe_debug_pub.add( 'OEXUPTXB.pls: Unexp. error in call to Create_New_Payment_Trxn');
1235: oe_debug_pub.add( 'SQL ERRM ----> '||sqlerrm);
1236: END IF;
1237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1238: END IF;
1239:
1240: IF l_debug_level > 0 THEN
1241: oe_debug_pub.add( 'OEXUPTXB.pls: After successful call to Create_New_Payment_Trxn');

Line 1302: p_init_msg_list => FND_API.G_TRUE,

1298: END IF;
1299:
1300: IBY_Fndcpt_Trxn_Pub.Create_Transaction_Extension
1301: (p_api_version => 1.0,
1302: p_init_msg_list => FND_API.G_TRUE,
1303: p_commit => FND_API.G_FALSE,
1304: X_return_status => l_return_status,
1305: X_msg_count => l_msg_count,
1306: X_msg_data => l_msg_data,

Line 1303: p_commit => FND_API.G_FALSE,

1299:
1300: IBY_Fndcpt_Trxn_Pub.Create_Transaction_Extension
1301: (p_api_version => 1.0,
1302: p_init_msg_list => FND_API.G_TRUE,
1303: p_commit => FND_API.G_FALSE,
1304: X_return_status => l_return_status,
1305: X_msg_count => l_msg_count,
1306: X_msg_data => l_msg_data,
1307: P_payer => l_payer,

Line 1323: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1319: oe_debug_pub.add('Result code'||l_Response_code.result_code);
1320: oe_debug_pub.add('Return status'||l_Return_Status);
1321: END IF;
1322:
1323: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1324: IF l_debug_level > 0 THEN
1325: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
1326: END IF;
1327: RAISE FND_API.G_EXC_ERROR;

Line 1327: RAISE FND_API.G_EXC_ERROR;

1323: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1324: IF l_debug_level > 0 THEN
1325: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
1326: END IF;
1327: RAISE FND_API.G_EXC_ERROR;
1328: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1329: IF l_debug_level > 0 THEN
1330: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
1331: END IF;

Line 1328: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1324: IF l_debug_level > 0 THEN
1325: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
1326: END IF;
1327: RAISE FND_API.G_EXC_ERROR;
1328: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1329: IF l_debug_level > 0 THEN
1330: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
1331: END IF;
1332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1328: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1329: IF l_debug_level > 0 THEN
1330: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
1331: END IF;
1332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1333: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1334: --Setting the trxn extension id to the new value
1335: --as the old trxn extension id was deleted
1336: p_trxn_extension_id := l_trxn_extension_id ;

Line 1333: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN

1329: IF l_debug_level > 0 THEN
1330: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
1331: END IF;
1332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1333: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1334: --Setting the trxn extension id to the new value
1335: --as the old trxn extension id was deleted
1336: p_trxn_extension_id := l_trxn_extension_id ;
1337: IF l_debug_level > 0 THEN

Line 1370: p_init_msg_list => FND_API.G_TRUE,

1366: --Bug 7460481 ends
1367:
1368: IBY_Fndcpt_Trxn_Pub.Update_Transaction_Extension
1369: (p_api_version => 1.0,
1370: p_init_msg_list => FND_API.G_TRUE,
1371: p_commit => FND_API.G_FALSE,
1372: X_return_status => l_return_status,
1373: X_msg_count => l_msg_count,
1374: X_msg_data => l_msg_data,

Line 1371: p_commit => FND_API.G_FALSE,

1367:
1368: IBY_Fndcpt_Trxn_Pub.Update_Transaction_Extension
1369: (p_api_version => 1.0,
1370: p_init_msg_list => FND_API.G_TRUE,
1371: p_commit => FND_API.G_FALSE,
1372: X_return_status => l_return_status,
1373: X_msg_count => l_msg_count,
1374: X_msg_data => l_msg_data,
1375: P_payer => l_payer,

Line 1388: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1384: IF l_debug_level > 0 THEN
1385: oe_debug_pub.add('After calling update transaction extension...');
1386: END IF;
1387:
1388: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1389: IF l_debug_level > 0 THEN
1390: oe_debug_pub.add('Result error code in Update_Transaction_Extension'||l_response_code.result_code);
1391: END IF;
1392: RAISE FND_API.G_EXC_ERROR;

Line 1392: RAISE FND_API.G_EXC_ERROR;

1388: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1389: IF l_debug_level > 0 THEN
1390: oe_debug_pub.add('Result error code in Update_Transaction_Extension'||l_response_code.result_code);
1391: END IF;
1392: RAISE FND_API.G_EXC_ERROR;
1393: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1394: IF l_debug_level > 0 THEN
1395: oe_debug_pub.add('Result error code in Update_Transaction_Extension'||l_response_code.result_code);
1396: END IF;

Line 1393: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1389: IF l_debug_level > 0 THEN
1390: oe_debug_pub.add('Result error code in Update_Transaction_Extension'||l_response_code.result_code);
1391: END IF;
1392: RAISE FND_API.G_EXC_ERROR;
1393: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1394: IF l_debug_level > 0 THEN
1395: oe_debug_pub.add('Result error code in Update_Transaction_Extension'||l_response_code.result_code);
1396: END IF;
1397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1393: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1394: IF l_debug_level > 0 THEN
1395: oe_debug_pub.add('Result error code in Update_Transaction_Extension'||l_response_code.result_code);
1396: END IF;
1397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1398: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1399: IF l_debug_level > 0 THEN
1400: oe_debug_pub.add('Update_Transaction_Extension assignment Successful....');
1401: oe_debug_pub.add('After calling Update_Transaction_Extension');

Line 1398: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN

1394: IF l_debug_level > 0 THEN
1395: oe_debug_pub.add('Result error code in Update_Transaction_Extension'||l_response_code.result_code);
1396: END IF;
1397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1398: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1399: IF l_debug_level > 0 THEN
1400: oe_debug_pub.add('Update_Transaction_Extension assignment Successful....');
1401: oe_debug_pub.add('After calling Update_Transaction_Extension');
1402: END IF;

Line 1429: p_commit => FND_API.G_FALSE,

1425: p_api_version => 1.0,
1426: X_return_status => l_return_status,
1427: X_msg_count => l_msg_count,
1428: X_msg_data => l_msg_data,
1429: p_commit => FND_API.G_FALSE,
1430: P_payer => l_payer,
1431: p_payer_equivalency => IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_IMMEDIATE,
1432: X_response => l_response_code,
1433: p_entity_id => p_trxn_extension_id);

Line 1435: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1431: p_payer_equivalency => IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_IMMEDIATE,
1432: X_response => l_response_code,
1433: p_entity_id => p_trxn_extension_id);
1434:
1435: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1436: IF l_debug_level > 0 THEN
1437: oe_debug_pub.add('Result error code in Delete_Transaction_Extension'||l_response_code.result_code);
1438: oe_debug_pub.add('sql error'||sqlerrm);
1439: oe_debug_pub.add('msg data'||l_msg_data);

Line 1441: RAISE FND_API.G_EXC_ERROR;

1437: oe_debug_pub.add('Result error code in Delete_Transaction_Extension'||l_response_code.result_code);
1438: oe_debug_pub.add('sql error'||sqlerrm);
1439: oe_debug_pub.add('msg data'||l_msg_data);
1440: END IF;
1441: RAISE FND_API.G_EXC_ERROR;
1442: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1443: IF l_debug_level > 0 THEN
1444: oe_debug_pub.add('Result error code in Delete_Transaction_Extension'||l_response_code.result_code);
1445: oe_debug_pub.add('sql error'||sqlerrm);

Line 1442: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1438: oe_debug_pub.add('sql error'||sqlerrm);
1439: oe_debug_pub.add('msg data'||l_msg_data);
1440: END IF;
1441: RAISE FND_API.G_EXC_ERROR;
1442: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1443: IF l_debug_level > 0 THEN
1444: oe_debug_pub.add('Result error code in Delete_Transaction_Extension'||l_response_code.result_code);
1445: oe_debug_pub.add('sql error'||sqlerrm);
1446: oe_debug_pub.add('msg data'||l_msg_data);

Line 1448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1444: oe_debug_pub.add('Result error code in Delete_Transaction_Extension'||l_response_code.result_code);
1445: oe_debug_pub.add('sql error'||sqlerrm);
1446: oe_debug_pub.add('msg data'||l_msg_data);
1447: END IF;
1448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1449: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1450: IF l_debug_level > 0 THEN
1451: oe_debug_pub.add('Delete_Transaction_Extension Successful....');
1452: oe_debug_pub.add('After calling Delete_Transaction_Extension');

Line 1449: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN

1445: oe_debug_pub.add('sql error'||sqlerrm);
1446: oe_debug_pub.add('msg data'||l_msg_data);
1447: END IF;
1448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1449: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1450: IF l_debug_level > 0 THEN
1451: oe_debug_pub.add('Delete_Transaction_Extension Successful....');
1452: oe_debug_pub.add('After calling Delete_Transaction_Extension');
1453: oe_debug_pub.add('sql error'||sqlerrm);

Line 1464: NOT OE_GLOBALS.Equal(p_instrument_security_code,FND_API.G_MISS_CHAR) THEN

1460: ELSIF p_payment_type_code = 'CREDIT_CARD' THEN
1461: l_trxn_attribs.Originating_Application_Id := 660;
1462: l_trxn_attribs.Instrument_Security_Code := p_instrument_security_code;
1463: /*IF p_instrument_security_code IS NOT NULL AND
1464: NOT OE_GLOBALS.Equal(p_instrument_security_code,FND_API.G_MISS_CHAR) THEN
1465: --The bill to site has changed and a new credit card
1466: --has been brought in. Since the CVV2 value used here
1467: --would be of the previous cards', displaying this message
1468: --to the user.

Line 1490: p_init_msg_list => FND_API.G_TRUE,

1486: END IF;
1487:
1488: IBY_Fndcpt_Trxn_Pub.Create_Transaction_Extension
1489: (p_api_version => 1.0,
1490: p_init_msg_list => FND_API.G_TRUE,
1491: p_commit => FND_API.G_FALSE,
1492: X_return_status => l_return_status,
1493: X_msg_count => l_msg_count,
1494: X_msg_data => l_msg_data,

Line 1491: p_commit => FND_API.G_FALSE,

1487:
1488: IBY_Fndcpt_Trxn_Pub.Create_Transaction_Extension
1489: (p_api_version => 1.0,
1490: p_init_msg_list => FND_API.G_TRUE,
1491: p_commit => FND_API.G_FALSE,
1492: X_return_status => l_return_status,
1493: X_msg_count => l_msg_count,
1494: X_msg_data => l_msg_data,
1495: P_payer => l_payer,

Line 1511: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1507: oe_debug_pub.add('Result code'||l_Response_code.result_code);
1508: oe_debug_pub.add('Return status'||l_Return_Status);
1509: END IF;
1510:
1511: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1512: IF l_debug_level > 0 THEN
1513: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
1514: END IF;
1515: RAISE FND_API.G_EXC_ERROR;

Line 1515: RAISE FND_API.G_EXC_ERROR;

1511: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1512: IF l_debug_level > 0 THEN
1513: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
1514: END IF;
1515: RAISE FND_API.G_EXC_ERROR;
1516: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1517: IF l_debug_level > 0 THEN
1518: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
1519: END IF;

Line 1516: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1512: IF l_debug_level > 0 THEN
1513: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
1514: END IF;
1515: RAISE FND_API.G_EXC_ERROR;
1516: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1517: IF l_debug_level > 0 THEN
1518: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
1519: END IF;
1520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1516: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1517: IF l_debug_level > 0 THEN
1518: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
1519: END IF;
1520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1521: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1522: --Setting the trxn extension id to the new value
1523: --as the old trxn extension id was deleted
1524: p_trxn_extension_id := l_trxn_extension_id ;

Line 1521: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN

1517: IF l_debug_level > 0 THEN
1518: oe_debug_pub.add('Result error code in Create_Transaction_Extension'||l_response_code.result_code);
1519: END IF;
1520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1521: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1522: --Setting the trxn extension id to the new value
1523: --as the old trxn extension id was deleted
1524: p_trxn_extension_id := l_trxn_extension_id ;
1525: IF l_debug_level > 0 THEN

Line 1540: X_return_status := FND_API.G_RET_STS_SUCCESS;

1536: IF l_debug_level > 0 THEN
1537: oe_debug_pub.add('Exiting Update_Payment_Trxn.....');
1538: END IF;
1539:
1540: X_return_status := FND_API.G_RET_STS_SUCCESS;
1541:
1542: EXCEPTION
1543:
1544: WHEN FND_API.G_EXC_ERROR THEN

Line 1544: WHEN FND_API.G_EXC_ERROR THEN

1540: X_return_status := FND_API.G_RET_STS_SUCCESS;
1541:
1542: EXCEPTION
1543:
1544: WHEN FND_API.G_EXC_ERROR THEN
1545: X_return_status := FND_API.G_RET_STS_ERROR;
1546: OE_MSG_PUB.Count_And_Get
1547: ( p_count => l_msg_count,
1548: p_data => l_msg_data

Line 1545: X_return_status := FND_API.G_RET_STS_ERROR;

1541:
1542: EXCEPTION
1543:
1544: WHEN FND_API.G_EXC_ERROR THEN
1545: X_return_status := FND_API.G_RET_STS_ERROR;
1546: OE_MSG_PUB.Count_And_Get
1547: ( p_count => l_msg_count,
1548: p_data => l_msg_data
1549: );

Line 1550: RAISE FND_API.G_EXC_ERROR;

1546: OE_MSG_PUB.Count_And_Get
1547: ( p_count => l_msg_count,
1548: p_data => l_msg_data
1549: );
1550: RAISE FND_API.G_EXC_ERROR;
1551:
1552: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1553: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1554: OE_MSG_PUB.Count_And_Get

Line 1552: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1548: p_data => l_msg_data
1549: );
1550: RAISE FND_API.G_EXC_ERROR;
1551:
1552: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1553: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1554: OE_MSG_PUB.Count_And_Get
1555: ( p_count => l_msg_count,
1556: p_data => l_msg_data

Line 1553: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1549: );
1550: RAISE FND_API.G_EXC_ERROR;
1551:
1552: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1553: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1554: OE_MSG_PUB.Count_And_Get
1555: ( p_count => l_msg_count,
1556: p_data => l_msg_data
1557: );

Line 1558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1554: OE_MSG_PUB.Count_And_Get
1555: ( p_count => l_msg_count,
1556: p_data => l_msg_data
1557: );
1558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1559:
1560: WHEN OTHERS THEN
1561: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1562: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1561: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1557: );
1558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1559:
1560: WHEN OTHERS THEN
1561: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1562: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1563: THEN
1564: FND_MSG_PUB.Add_Exc_Msg
1565: ( G_PKG_NAME

Line 1574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1570: OE_MSG_PUB.Count_And_Get
1571: ( p_count => l_msg_count,
1572: p_data => l_msg_data
1573: );
1574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1575:
1576: END Update_Payment_Trxn;
1577:
1578: Procedure Copy_Payment_Trxn( p_header_id IN NUMBER,

Line 1707: p_init_msg_list => FND_API.G_TRUE,

1703: END IF;
1704:
1705: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment
1706: (p_api_version => 1.0,
1707: p_init_msg_list => FND_API.G_TRUE,
1708: p_commit => FND_API.G_FALSE,
1709: X_return_status => l_return_status,
1710: X_msg_count => l_msg_count,
1711: X_msg_data => l_msg_data,

Line 1708: p_commit => FND_API.G_FALSE,

1704:
1705: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment
1706: (p_api_version => 1.0,
1707: p_init_msg_list => FND_API.G_TRUE,
1708: p_commit => FND_API.G_FALSE,
1709: X_return_status => l_return_status,
1710: X_msg_count => l_msg_count,
1711: X_msg_data => l_msg_data,
1712: P_payer => l_payer,

Line 1717: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1713: P_assignment_attribs => l_assignment_attribs,
1714: X_assign_id => l_assign_id,
1715: X_response => l_response_code);
1716:
1717: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1718: IF l_debug_level > 0 THEN
1719: oe_debug_pub.add('Result error code in Set_Payer_Instr_Assignment'||l_response_code.result_code);
1720: END IF;
1721: --IF l_response_code.result_code = '

Line 1722: RAISE FND_API.G_EXC_ERROR;

1718: IF l_debug_level > 0 THEN
1719: oe_debug_pub.add('Result error code in Set_Payer_Instr_Assignment'||l_response_code.result_code);
1720: END IF;
1721: --IF l_response_code.result_code = '
1722: RAISE FND_API.G_EXC_ERROR;
1723: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1724: IF l_debug_level > 0 THEN
1725: oe_debug_pub.add('Result error code in Set_Payer_Instr_Assignment'||l_response_code.result_code);
1726: END IF;

Line 1723: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1719: oe_debug_pub.add('Result error code in Set_Payer_Instr_Assignment'||l_response_code.result_code);
1720: END IF;
1721: --IF l_response_code.result_code = '
1722: RAISE FND_API.G_EXC_ERROR;
1723: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1724: IF l_debug_level > 0 THEN
1725: oe_debug_pub.add('Result error code in Set_Payer_Instr_Assignment'||l_response_code.result_code);
1726: END IF;
1727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1723: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1724: IF l_debug_level > 0 THEN
1725: oe_debug_pub.add('Result error code in Set_Payer_Instr_Assignment'||l_response_code.result_code);
1726: END IF;
1727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1728: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1729: IF l_debug_level > 0 THEN
1730: oe_debug_pub.add('Result code in Set_Payer_Instr_Assignment'||l_response_code.result_code);
1731: oe_debug_pub.add('new assignment id is: '||l_assign_id,1);

Line 1728: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1724: IF l_debug_level > 0 THEN
1725: oe_debug_pub.add('Result error code in Set_Payer_Instr_Assignment'||l_response_code.result_code);
1726: END IF;
1727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1728: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1729: IF l_debug_level > 0 THEN
1730: oe_debug_pub.add('Result code in Set_Payer_Instr_Assignment'||l_response_code.result_code);
1731: oe_debug_pub.add('new assignment id is: '||l_assign_id,1);
1732: END IF;

Line 1767: p_init_msg_list => FND_API.G_TRUE,

1763: oe_debug_pub.add('l_trxn_attribs.copy_instr_assign_id ---->'||l_assign_id);
1764: END IF;
1765: IBY_Fndcpt_Trxn_Pub.Copy_Transaction_Extension
1766: (p_api_version => 1.0,
1767: p_init_msg_list => FND_API.G_TRUE,
1768: p_commit => FND_API.G_FALSE,
1769: X_return_status => l_return_status,
1770: X_msg_count => l_msg_count,
1771: X_msg_data => l_msg_data,

Line 1768: p_commit => FND_API.G_FALSE,

1764: END IF;
1765: IBY_Fndcpt_Trxn_Pub.Copy_Transaction_Extension
1766: (p_api_version => 1.0,
1767: p_init_msg_list => FND_API.G_TRUE,
1768: p_commit => FND_API.G_FALSE,
1769: X_return_status => l_return_status,
1770: X_msg_count => l_msg_count,
1771: X_msg_data => l_msg_data,
1772: P_payer => l_payer,

Line 1783: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1779: IF l_debug_level > 0 THEN
1780: oe_debug_pub.add('Return status from Copy_Transaction_Extension'||l_return_status);
1781: END IF;
1782:
1783: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1784: IF l_debug_level > 0 THEN
1785: oe_debug_pub.add('Result error code in Copy_Transaction_Extension'||l_response_code.result_code);
1786: END IF;
1787: --IF l_response_code.result_code = '

Line 1788: RAISE FND_API.G_EXC_ERROR;

1784: IF l_debug_level > 0 THEN
1785: oe_debug_pub.add('Result error code in Copy_Transaction_Extension'||l_response_code.result_code);
1786: END IF;
1787: --IF l_response_code.result_code = '
1788: RAISE FND_API.G_EXC_ERROR;
1789: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1790: IF l_debug_level > 0 THEN
1791: oe_debug_pub.add('Result error code in Copy_Transaction_Extension'||l_response_code.result_code);
1792: END IF;

Line 1789: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1785: oe_debug_pub.add('Result error code in Copy_Transaction_Extension'||l_response_code.result_code);
1786: END IF;
1787: --IF l_response_code.result_code = '
1788: RAISE FND_API.G_EXC_ERROR;
1789: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1790: IF l_debug_level > 0 THEN
1791: oe_debug_pub.add('Result error code in Copy_Transaction_Extension'||l_response_code.result_code);
1792: END IF;
1793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1789: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1790: IF l_debug_level > 0 THEN
1791: oe_debug_pub.add('Result error code in Copy_Transaction_Extension'||l_response_code.result_code);
1792: END IF;
1793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1794: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1795: IF l_debug_level > 0 THEN
1796: oe_debug_pub.add('Result code in Copy_Transaction_Extension'||l_response_code.result_code);
1797: END IF;

Line 1794: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1790: IF l_debug_level > 0 THEN
1791: oe_debug_pub.add('Result error code in Copy_Transaction_Extension'||l_response_code.result_code);
1792: END IF;
1793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1794: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1795: IF l_debug_level > 0 THEN
1796: oe_debug_pub.add('Result code in Copy_Transaction_Extension'||l_response_code.result_code);
1797: END IF;
1798: END IF;

Line 1804: X_return_status := FND_API.G_RET_STS_SUCCESS;

1800: IF l_debug_level > 0 THEN
1801: oe_debug_pub.add('Exiting OE_PAYMENT_TRXN_UTIL.Copy_Payment_Trxn.', 1);
1802: END IF;
1803:
1804: X_return_status := FND_API.G_RET_STS_SUCCESS;
1805:
1806: EXCEPTION
1807:
1808: WHEN FND_API.G_EXC_ERROR THEN

Line 1808: WHEN FND_API.G_EXC_ERROR THEN

1804: X_return_status := FND_API.G_RET_STS_SUCCESS;
1805:
1806: EXCEPTION
1807:
1808: WHEN FND_API.G_EXC_ERROR THEN
1809: l_err_message := SQLERRM;
1810: IF l_debug_level > 0 THEN
1811: oe_debug_pub.add('Copy_Transaction_Extension error....exc');
1812: oe_debug_pub.add('After call to Copy_Transaction_Extension'||l_return_status);

Line 1817: X_return_status := FND_API.G_RET_STS_ERROR;

1813: oe_debug_pub.add('Result code'||l_response_code.result_code);
1814: oe_debug_pub.add('Error'||l_err_message);
1815: END IF;
1816:
1817: X_return_status := FND_API.G_RET_STS_ERROR;
1818: OE_MSG_PUB.Count_And_Get
1819: ( p_count => l_msg_count,
1820: p_data => l_msg_data
1821: );

Line 1822: RAISE FND_API.G_EXC_ERROR;

1818: OE_MSG_PUB.Count_And_Get
1819: ( p_count => l_msg_count,
1820: p_data => l_msg_data
1821: );
1822: RAISE FND_API.G_EXC_ERROR;
1823: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1824: l_err_message := SQLERRM;
1825: IF l_debug_level > 0 THEN
1826: oe_debug_pub.add('Copy_Transaction_Extension error....unxc');

Line 1823: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1819: ( p_count => l_msg_count,
1820: p_data => l_msg_data
1821: );
1822: RAISE FND_API.G_EXC_ERROR;
1823: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1824: l_err_message := SQLERRM;
1825: IF l_debug_level > 0 THEN
1826: oe_debug_pub.add('Copy_Transaction_Extension error....unxc');
1827: oe_debug_pub.add('After call to Copy_Transaction_Extension'||l_return_status);

Line 1832: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1828: oe_debug_pub.add('Result code'||l_response_code.result_code);
1829: oe_debug_pub.add('f Error'||l_err_message);
1830: END IF;
1831:
1832: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1833: OE_MSG_PUB.Count_And_Get
1834: ( p_count => l_msg_count,
1835: p_data => l_msg_data
1836: );

Line 1837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1833: OE_MSG_PUB.Count_And_Get
1834: ( p_count => l_msg_count,
1835: p_data => l_msg_data
1836: );
1837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1838:
1839: WHEN OTHERS THEN
1840: l_err_message := SQLERRM;
1841: IF l_debug_level > 0 THEN

Line 1848: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1844: oe_debug_pub.add('Result code'||l_response_code.result_code);
1845: oe_debug_pub.add('trx Error'||l_err_message);
1846: END IF;
1847:
1848: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1849: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1850: THEN
1851: FND_MSG_PUB.Add_Exc_Msg
1852: ( G_PKG_NAME

Line 1861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1857: OE_MSG_PUB.Count_And_Get
1858: ( p_count => l_msg_count,
1859: p_data => l_msg_data
1860: );
1861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1862: --R12 CC Encryption
1863: END Copy_Payment_Trxn;
1864:
1865: Procedure Get_Payment_Trxn_Info(p_header_id IN NUMBER,

Line 1906: x_return_status := FND_API.G_RET_STS_SUCCESS;

1902: BEGIN
1903:
1904: IF l_debug_level > 0 THEN
1905: oe_debug_pub.add('Entering Get_Payment_Trxn_Info...');
1906: x_return_status := FND_API.G_RET_STS_SUCCESS;
1907: END IF;
1908:
1909: --< if l_trxn_extension_id is null, this might be called from sales order header>
1910: IF l_trxn_extension_id IS NULL THEN

Line 1981: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1977: IF l_debug_level > 0 THEN
1978: oe_debug_pub.add('Return status from Get_Authorization'||l_return_status);
1979: END IF;
1980:
1981: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1982: IF l_debug_level > 0 THEN
1983: oe_debug_pub.add('Result error code in Get_Authorization'||l_response.result_code);
1984: END IF;
1985: --IF l_response_code.result_code = '

Line 1986: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1982: IF l_debug_level > 0 THEN
1983: oe_debug_pub.add('Result error code in Get_Authorization'||l_response.result_code);
1984: END IF;
1985: --IF l_response_code.result_code = '
1986: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1987: IF l_debug_level > 0 THEN
1988: oe_debug_pub.add('Result error code in Get_Authorization'||l_response.result_code);
1989: END IF;
1990: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 1990: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1986: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1987: IF l_debug_level > 0 THEN
1988: oe_debug_pub.add('Result error code in Get_Authorization'||l_response.result_code);
1989: END IF;
1990: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1991: IF l_debug_level > 0 THEN
1992: oe_debug_pub.add('Success in Get_Authorization'||l_response.result_code);
1993: oe_debug_pub.add('approval code ----> '||l_auth_result.auth_code);
1994: oe_debug_pub.add('x_credit_card_approval_date ---> '||l_auth_result.auth_date);

Line 2005: X_return_status := FND_API.G_RET_STS_SUCCESS;

2001: END IF; --Payment type code = 'Credit_card'
2002:
2003: END IF; --trxn extension id not null
2004:
2005: X_return_status := FND_API.G_RET_STS_SUCCESS;
2006:
2007: IF l_debug_level > 0 THEN
2008: oe_debug_pub.add('Exiting Get_Payment_Trxn_Info....');
2009: END IF;

Line 2013: WHEN FND_API.G_EXC_ERROR THEN

2009: END IF;
2010:
2011: EXCEPTION
2012:
2013: WHEN FND_API.G_EXC_ERROR THEN
2014: l_err_message := SQLERRM;
2015: IF l_debug_level > 0 THEN
2016: oe_debug_pub.add('Get_Payment_Trxn_Info error....exc');
2017: oe_debug_pub.add('After call to Get_Payment_Trxn_Info'||l_return_status);

Line 2028: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2024: ( p_count => l_msg_count,
2025: p_data => l_msg_data
2026: );
2027:
2028: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2029: l_err_message := SQLERRM;
2030: IF l_debug_level > 0 THEN
2031: oe_debug_pub.add('Get_Payment_Trxn_Info error....unxc');
2032: oe_debug_pub.add('After call to Get_Payment_Trxn_Info'||l_return_status);

Line 2207: p_commit => FND_API.G_FALSE,

2203: p_api_version => 1.0,
2204: X_return_status => l_return_status,
2205: X_msg_count => l_msg_count,
2206: X_msg_data => l_msg_data,
2207: p_commit => FND_API.G_FALSE,
2208: P_payer => l_payer,
2209: p_payer_equivalency => IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_IMMEDIATE,
2210: X_response => l_response_code,
2211: p_entity_id => p_trxn_extension_id);

Line 2213: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2209: p_payer_equivalency => IBY_FNDCPT_COMMON_PUB.G_PAYER_EQUIV_IMMEDIATE,
2210: X_response => l_response_code,
2211: p_entity_id => p_trxn_extension_id);
2212:
2213: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2214: IF l_debug_level > 0 THEN
2215: oe_debug_pub.add('Result error code in Delete_Transaction_Extension'||l_response_code.result_code);
2216: oe_debug_pub.add('sql error'||sqlerrm);
2217: oe_debug_pub.add('msg data'||l_msg_data);

Line 2219: RAISE FND_API.G_EXC_ERROR;

2215: oe_debug_pub.add('Result error code in Delete_Transaction_Extension'||l_response_code.result_code);
2216: oe_debug_pub.add('sql error'||sqlerrm);
2217: oe_debug_pub.add('msg data'||l_msg_data);
2218: END IF;
2219: RAISE FND_API.G_EXC_ERROR;
2220: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2221: IF l_debug_level > 0 THEN
2222: oe_debug_pub.add('Result error code in Delete_Transaction_Extension'||l_response_code.result_code);
2223: oe_debug_pub.add('sql error'||sqlerrm);

Line 2220: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2216: oe_debug_pub.add('sql error'||sqlerrm);
2217: oe_debug_pub.add('msg data'||l_msg_data);
2218: END IF;
2219: RAISE FND_API.G_EXC_ERROR;
2220: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2221: IF l_debug_level > 0 THEN
2222: oe_debug_pub.add('Result error code in Delete_Transaction_Extension'||l_response_code.result_code);
2223: oe_debug_pub.add('sql error'||sqlerrm);
2224: oe_debug_pub.add('msg data'||l_msg_data);

Line 2226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2222: oe_debug_pub.add('Result error code in Delete_Transaction_Extension'||l_response_code.result_code);
2223: oe_debug_pub.add('sql error'||sqlerrm);
2224: oe_debug_pub.add('msg data'||l_msg_data);
2225: END IF;
2226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2227: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
2228: IF l_debug_level > 0 THEN
2229: oe_debug_pub.add('Delete_Transaction_Extension Successful....');
2230: oe_debug_pub.add('After calling Delete_Transaction_Extension');

Line 2227: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN

2223: oe_debug_pub.add('sql error'||sqlerrm);
2224: oe_debug_pub.add('msg data'||l_msg_data);
2225: END IF;
2226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2227: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
2228: IF l_debug_level > 0 THEN
2229: oe_debug_pub.add('Delete_Transaction_Extension Successful....');
2230: oe_debug_pub.add('After calling Delete_Transaction_Extension');
2231: oe_debug_pub.add('sql error'||sqlerrm);

Line 2234: x_return_status := FND_API.G_RET_STS_SUCCESS;

2230: oe_debug_pub.add('After calling Delete_Transaction_Extension');
2231: oe_debug_pub.add('sql error'||sqlerrm);
2232: oe_debug_pub.add('msg data'||l_msg_data);
2233: END IF;
2234: x_return_status := FND_API.G_RET_STS_SUCCESS;
2235: END IF;
2236: END IF;
2237: -- bug 5194228
2238: END;

Line 2241: WHEN FND_API.G_EXC_ERROR THEN

2237: -- bug 5194228
2238: END;
2239: EXCEPTION
2240:
2241: WHEN FND_API.G_EXC_ERROR THEN
2242: l_err_message := SQLERRM;
2243: IF l_debug_level > 0 THEN
2244: oe_debug_pub.add('Delete_Payment_Trxn error....exc');
2245: oe_debug_pub.add('After call to Delete_Payment_Trxn'||l_return_status);

Line 2250: X_return_status := FND_API.G_RET_STS_ERROR;

2246: oe_debug_pub.add('Result code'||l_response_code.result_code);
2247: oe_debug_pub.add('Error'||l_err_message);
2248: END IF;
2249:
2250: X_return_status := FND_API.G_RET_STS_ERROR;
2251: OE_MSG_PUB.Count_And_Get
2252: ( p_count => l_msg_count,
2253: p_data => l_msg_data
2254: );

Line 2255: RAISE FND_API.G_EXC_ERROR;

2251: OE_MSG_PUB.Count_And_Get
2252: ( p_count => l_msg_count,
2253: p_data => l_msg_data
2254: );
2255: RAISE FND_API.G_EXC_ERROR;
2256:
2257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2258: l_err_message := SQLERRM;
2259: IF l_debug_level > 0 THEN

Line 2257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2253: p_data => l_msg_data
2254: );
2255: RAISE FND_API.G_EXC_ERROR;
2256:
2257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2258: l_err_message := SQLERRM;
2259: IF l_debug_level > 0 THEN
2260: oe_debug_pub.add('Delete_Payment_Trxn error....unxc');
2261: oe_debug_pub.add('After call to Delete_Payment_Trxn'||l_return_status);

Line 2266: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2262: oe_debug_pub.add('Result code'||l_response_code.result_code);
2263: oe_debug_pub.add('f Error'||l_err_message);
2264: END IF;
2265:
2266: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2267: OE_MSG_PUB.Count_And_Get
2268: ( p_count => l_msg_count,
2269: p_data => l_msg_data
2270: );

Line 2271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2267: OE_MSG_PUB.Count_And_Get
2268: ( p_count => l_msg_count,
2269: p_data => l_msg_data
2270: );
2271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2272:
2273: WHEN OTHERS THEN
2274: l_err_message := SQLERRM;
2275: IF l_debug_level > 0 THEN

Line 2282: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2278: oe_debug_pub.add('Result code'||l_response_code.result_code);
2279: oe_debug_pub.add('trx Error'||l_err_message);
2280: END IF;
2281:
2282: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2283: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2284: THEN
2285: FND_MSG_PUB.Add_Exc_Msg
2286: ( G_PKG_NAME

Line 2298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2294: OE_MSG_PUB.Count_And_Get
2295: ( p_count => l_msg_count,
2296: p_data => l_msg_data
2297: );
2298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2299: END Delete_Payment_Trxn;
2300:
2301: FUNCTION Get_Settled_Flag(p_Trxn_Extension_Id Number)
2302: RETURN VARCHAR2

Line 2314: NOT OE_GLOBALS.Equal(p_trxn_Extension_id, FND_API.G_MISS_NUM) THEN

2310: END IF;
2311:
2312: BEGIN
2313: IF p_trxn_extension_id IS NOT NULL AND
2314: NOT OE_GLOBALS.Equal(p_trxn_Extension_id, FND_API.G_MISS_NUM) THEN
2315: select settled_flag
2316: into l_Settled_flag
2317: from iby_trxn_extensions_v
2318: where trxn_Extension_id = p_trxn_extension_id;

Line 2398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2394: 'Get_CC_Security_Code_Use'
2395: );
2396: END IF;
2397:
2398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2399:
2400: END Get_CC_Security_Code_Use;
2401:
2402: