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.IBE_PAYMENT_INT_PVT dependencies on FND_API

Line 11: l_true VARCHAR2(1) := FND_API.G_TRUE;

7:
8: -- End of Comments
9:
10:
11: l_true VARCHAR2(1) := FND_API.G_TRUE;
12: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_PAYMENT_INT_PVT';
13: G_FILE_NAME CONSTANT VARCHAR2(12) := 'IBEVPMTB.pls';
14: l_debugon VARCHAR2(1) := IBE_UTIL.G_DEBUGON;
15:

Line 18: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

14: l_debugon VARCHAR2(1) := IBE_UTIL.G_DEBUGON;
15:
16: procedure save_credit_card
17: (p_api_version IN Number
18: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
19: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
20: ,p_operation_code IN VARCHAR2
21: ,p_credit_card_id IN NUMBER
22: ,p_assignment_id IN NUMBER

Line 19: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

15:
16: procedure save_credit_card
17: (p_api_version IN Number
18: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
19: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
20: ,p_operation_code IN VARCHAR2
21: ,p_credit_card_id IN NUMBER
22: ,p_assignment_id IN NUMBER
23: ,p_currency_code IN VARCHAR2

Line 30: ,p_statement_address_id IN NUMBER := FND_API.G_MISS_NUM

26: ,p_exp_date IN DATE
27: ,p_credit_card_type_code IN VARCHAR2
28: ,p_party_id IN NUMBER
29: ,p_cust_id IN NUMBER
30: ,p_statement_address_id IN NUMBER := FND_API.G_MISS_NUM
31: ,x_credit_card_id OUT NOCOPY NUMBER
32: ,x_assignment_id OUT NOCOPY NUMBER
33: ,x_return_status OUT NOCOPY VARCHAR2
34: ,x_msg_count OUT NOCOPY NUMBER

Line 60: l_oneclick_id NUMBER := FND_API.G_MISS_NUM;

56: l_location HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;
57: l_party_site HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE;
58: lx_msg_data VARCHAR2(2100);
59: l_billing_address_id NUMBER;
60: l_oneclick_id NUMBER := FND_API.G_MISS_NUM;
61: l_enabled_flag VARCHAR2(1) := 'N';
62: l_oneclick_enabled VARCHAR2(1) := NVL(FND_PROFILE.VALUE('IBE_USE_ONE_CLICK'),'Y');
63:
64: cursor c_check_address_owner(c_party_site_id NUMBER) is

Line 86: IF NOT FND_API.compatible_api_call(l_api_version,

82: END IF;
83: -- standard start of API savepoint
84: SAVEPOINT save_credit_card;
85:
86: IF NOT FND_API.compatible_api_call(l_api_version,
87: p_api_version,
88: l_api_name,
89: G_PKG_NAME)
90: THEN

Line 91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

87: p_api_version,
88: l_api_name,
89: G_PKG_NAME)
90: THEN
91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
92: END IF;
93: -- initialize message list if p_init_msg_list is set to TRUE.
94: IF FND_API.to_boolean(p_init_msg_list) THEN
95: FND_MSG_PUB.initialize;

Line 94: IF FND_API.to_boolean(p_init_msg_list) THEN

90: THEN
91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
92: END IF;
93: -- initialize message list if p_init_msg_list is set to TRUE.
94: IF FND_API.to_boolean(p_init_msg_list) THEN
95: FND_MSG_PUB.initialize;
96: END IF;
97: -- Initialize API return status to success
98: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 98: x_return_status := FND_API.G_RET_STS_SUCCESS;

94: IF FND_API.to_boolean(p_init_msg_list) THEN
95: FND_MSG_PUB.initialize;
96: END IF;
97: -- Initialize API return status to success
98: x_return_status := FND_API.G_RET_STS_SUCCESS;
99:
100: --8529175
101: IF (l_debugon = l_true) THEN
102: IBE_UTIL.debug('save_credit_card : Input parameters' );

Line 194: ,p_init_msg_list => FND_API.G_FALSE

190: ,x_party_site_id => l_card_instrument.billing_address_id);*/
191:
192: IBE_ADDRESS_V2PVT.copy_party_site (
193: p_api_version => 1.0
194: ,p_init_msg_list => FND_API.G_FALSE
195: ,p_commit => FND_API.G_FALSE
196: ,p_party_site => l_party_site
197: ,p_location => l_location
198: ,x_party_site_id => l_billing_address_id

Line 195: ,p_commit => FND_API.G_FALSE

191:
192: IBE_ADDRESS_V2PVT.copy_party_site (
193: p_api_version => 1.0
194: ,p_init_msg_list => FND_API.G_FALSE
195: ,p_commit => FND_API.G_FALSE
196: ,p_party_site => l_party_site
197: ,p_location => l_location
198: ,x_party_site_id => l_billing_address_id
199: ,x_return_status => x_return_status

Line 207: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

203: IF (l_debugon = l_true) THEN
204: IBE_UTIL.debug('Save_Credit_card: Done calling IBE_ADDRESS_V2PVT.create_address: x_return_status '||x_return_status);
205: END IF;
206:
207: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
208: RAISE FND_API.G_EXC_ERROR;
209: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
211: END IF;

Line 208: RAISE FND_API.G_EXC_ERROR;

204: IBE_UTIL.debug('Save_Credit_card: Done calling IBE_ADDRESS_V2PVT.create_address: x_return_status '||x_return_status);
205: END IF;
206:
207: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
208: RAISE FND_API.G_EXC_ERROR;
209: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
211: END IF;
212:

Line 209: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

205: END IF;
206:
207: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
208: RAISE FND_API.G_EXC_ERROR;
209: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
211: END IF;
212:
213:

Line 210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

206:
207: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
208: RAISE FND_API.G_EXC_ERROR;
209: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
211: END IF;
212:
213:
214: IF (l_debugon = l_true) THEN

Line 337: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

333: ,p_assignment_attribs => l_assignment_attr
334: ,x_assign_id => lx_assign_id
335: ,x_response => lx_response );
336:
337: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
338: RAISE FND_API.G_EXC_ERROR;
339: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
341: END IF;

Line 338: RAISE FND_API.G_EXC_ERROR;

334: ,x_assign_id => lx_assign_id
335: ,x_response => lx_response );
336:
337: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
338: RAISE FND_API.G_EXC_ERROR;
339: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
341: END IF;
342:

Line 339: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

335: ,x_response => lx_response );
336:
337: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
338: RAISE FND_API.G_EXC_ERROR;
339: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
341: END IF;
342:
343: IF (l_debugon = l_true) THEN

Line 340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

336:
337: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
338: RAISE FND_API.G_EXC_ERROR;
339: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
341: END IF;
342:
343: IF (l_debugon = l_true) THEN
344: IBE_UTIL.debug('call IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment - after calling api');

Line 368: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

364: ,p_assignment_attribs => l_assignment_attr
365: ,x_assign_id => lx_assign_id
366: ,x_response => lx_response );
367:
368: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
369: IF (l_debugon = l_true) THEN
370: IBE_UTIL.debug('call process_credit_card - Expected error');
371: IBE_UTIL.debug('call process_credit_card - Expected error: '||lx_response.Result_Code);
372: END IF;

Line 374: RAISE FND_API.G_EXC_ERROR;

370: IBE_UTIL.debug('call process_credit_card - Expected error');
371: IBE_UTIL.debug('call process_credit_card - Expected error: '||lx_response.Result_Code);
372: END IF;
373:
374: RAISE FND_API.G_EXC_ERROR;
375: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
376: IF (l_debugon = l_true) THEN
377: IBE_UTIL.debug('call process_credit_card - UnExpected error');
378: END IF;

Line 375: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

371: IBE_UTIL.debug('call process_credit_card - Expected error: '||lx_response.Result_Code);
372: END IF;
373:
374: RAISE FND_API.G_EXC_ERROR;
375: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
376: IF (l_debugon = l_true) THEN
377: IBE_UTIL.debug('call process_credit_card - UnExpected error');
378: END IF;
379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

375: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
376: IF (l_debugon = l_true) THEN
377: IBE_UTIL.debug('call process_credit_card - UnExpected error');
378: END IF;
379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
380: END IF;
381: x_assignment_id := lx_assign_id;
382: end if;
383: if (p_operation_code = 'UPDATE' or p_operation_code = 'DELETE') then

Line 396: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

392: ,p_card_instrument => l_card_instrument
393: ,x_response => lx_response);
394:
395:
396: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
397: RAISE FND_API.G_EXC_ERROR;
398: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
400: END IF;

Line 397: RAISE FND_API.G_EXC_ERROR;

393: ,x_response => lx_response);
394:
395:
396: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
397: RAISE FND_API.G_EXC_ERROR;
398: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
400: END IF;
401: -- We need to call the Experss Checkout api to check if the Express Chkout CC is the same

Line 398: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

394:
395:
396: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
397: RAISE FND_API.G_EXC_ERROR;
398: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
400: END IF;
401: -- We need to call the Experss Checkout api to check if the Express Chkout CC is the same
402: -- as the one deleted. If so, disable the Express Chkout

Line 399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

395:
396: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
397: RAISE FND_API.G_EXC_ERROR;
398: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
400: END IF;
401: -- We need to call the Experss Checkout api to check if the Express Chkout CC is the same
402: -- as the one deleted. If so, disable the Express Chkout
403:

Line 424: l_oneclick_id := FND_API.g_miss_num;

420: l_oneclick_id,
421: l_enabled_flag;
422:
423: if c_get_oneclick_settings%NOTFOUND then
424: l_oneclick_id := FND_API.g_miss_num;
425: end if;
426: CLOSE c_get_oneclick_settings;
427:
428: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 433: IF l_oneclick_id <> FND_API.g_miss_num and l_enabled_flag = 'Y' then

429: ibe_util.debug('l_oneclick_id :'||l_oneclick_id);
430: ibe_util.debug('l_enabled_flag :'||l_enabled_flag);
431: END IF;
432:
433: IF l_oneclick_id <> FND_API.g_miss_num and l_enabled_flag = 'Y' then
434: IF (l_debugon = l_true) THEN
435: IBE_UTIL.debug('call process_credit_card - Going to call ibe_ord_oneclick_pvt.Update_Settings()');
436: IBE_UTIL.debug('call process_credit_card - p_party_id ' ||p_party_id);
437: IBE_UTIL.debug('call process_credit_card - p_cust_id '||p_cust_id);

Line 452: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

448: ,p_party_id => p_party_id
449: ,p_acct_id => p_cust_id
450: ,p_assignment_id => l_assignment_attr.Assignment_Id);
451:
452: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
453: RAISE FND_API.G_EXC_ERROR;
454: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
456: END IF;

Line 453: RAISE FND_API.G_EXC_ERROR;

449: ,p_acct_id => p_cust_id
450: ,p_assignment_id => l_assignment_attr.Assignment_Id);
451:
452: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
453: RAISE FND_API.G_EXC_ERROR;
454: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
456: END IF;
457: END IF;

Line 454: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

450: ,p_assignment_id => l_assignment_attr.Assignment_Id);
451:
452: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
453: RAISE FND_API.G_EXC_ERROR;
454: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
456: END IF;
457: END IF;
458: END IF; --l_oneclick_enabled

Line 455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

451:
452: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
453: RAISE FND_API.G_EXC_ERROR;
454: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
456: END IF;
457: END IF;
458: END IF; --l_oneclick_enabled
459: end if;

Line 461: IF FND_API.to_boolean(p_commit) THEN

457: END IF;
458: END IF; --l_oneclick_enabled
459: end if;
460:
461: IF FND_API.to_boolean(p_commit) THEN
462: commit;
463: END IF;
464:
465: -- standard call to get message count and if count is 1, get message info

Line 467: p_encoded => FND_API.G_FALSE,

463: END IF;
464:
465: -- standard call to get message count and if count is 1, get message info
466: FND_MSG_PUB.count_and_get(
467: p_encoded => FND_API.G_FALSE,
468: p_count => x_msg_count,
469: p_data => x_msg_data );
470:
471: EXCEPTION

Line 473: WHEN FND_API.G_EXC_ERROR THEN

469: p_data => x_msg_data );
470:
471: EXCEPTION
472:
473: WHEN FND_API.G_EXC_ERROR THEN
474: -- IBE_UTIL.enable_debug();
475: ROLLBACK TO save_credit_card;
476: IF (l_debugon = l_true) THEN
477: IBE_UTIL.debug('G_EXC_ERROR exception');

Line 480: x_return_status := FND_API.G_RET_STS_ERROR;

476: IF (l_debugon = l_true) THEN
477: IBE_UTIL.debug('G_EXC_ERROR exception');
478: END IF;
479:
480: x_return_status := FND_API.G_RET_STS_ERROR;
481: FND_MSG_PUB.Add;
482: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
483: p_data => x_msg_data,
484: p_encoded => 'F');

Line 502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

498: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
499: IBE_UTIL.debug('error text : '|| SQLERRM);
500: END IF;
501: --IBE_UTIL.disable_debug();
502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
503: --IBE_UTIL.enable_debug();
504: ROLLBACK TO save_credit_card;
505:
506: IF (l_debugon = l_true) THEN

Line 509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

505:
506: IF (l_debugon = l_true) THEN
507: IBE_UTIL.debug('G_UNEXC_ERROR exception');
508: END IF;
509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
510: FND_MSG_PUB.Add;
511: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
512: p_data => x_msg_data,
513: p_encoded => 'F');

Line 539: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

535: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
536: p_data => x_msg_data,
537: p_encoded => 'F');
538: --bug 2617273
539: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
540: x_return_status := FND_API.G_RET_STS_ERROR;
541: IF (l_debugon = l_true) THEN
542: IBE_UTIL.debug('outside -20001 error code : '|| to_char(SQLCODE));
543: IBE_UTIL.debug('outside -20001 error text : '|| SQLERRM);

Line 540: x_return_status := FND_API.G_RET_STS_ERROR;

536: p_data => x_msg_data,
537: p_encoded => 'F');
538: --bug 2617273
539: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
540: x_return_status := FND_API.G_RET_STS_ERROR;
541: IF (l_debugon = l_true) THEN
542: IBE_UTIL.debug('outside -20001 error code : '|| to_char(SQLCODE));
543: IBE_UTIL.debug('outside -20001 error text : '|| SQLERRM);
544: END IF;

Line 558: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

554: END save_credit_card;
555:
556: PROCEDURE check_Payment_channel_setups(
557: p_api_version IN Number
558: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
559: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
560: ,x_cvv2_setup OUT NOCOPY VARCHAR2
561: ,x_statement_address_setup OUT NOCOPY VARCHAR2
562: ,x_return_status OUT NOCOPY VARCHAR2

Line 559: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

555:
556: PROCEDURE check_Payment_channel_setups(
557: p_api_version IN Number
558: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
559: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
560: ,x_cvv2_setup OUT NOCOPY VARCHAR2
561: ,x_statement_address_setup OUT NOCOPY VARCHAR2
562: ,x_return_status OUT NOCOPY VARCHAR2
563: ,x_msg_count OUT NOCOPY NUMBER

Line 588: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

584: p_channel_code => 'CREDIT_CARD',
585: x_channel_attrib_uses => lx_channel_attrib_uses,
586: x_response => l_result_rec_type);
587:
588: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
589: RAISE FND_API.G_EXC_ERROR;
590: END IF;
591:
592: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 589: RAISE FND_API.G_EXC_ERROR;

585: x_channel_attrib_uses => lx_channel_attrib_uses,
586: x_response => l_result_rec_type);
587:
588: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
589: RAISE FND_API.G_EXC_ERROR;
590: END IF;
591:
592: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 592: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

588: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
589: RAISE FND_API.G_EXC_ERROR;
590: END IF;
591:
592: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
594: END IF;
595: IF (l_debugon = l_true) THEN
596: IBE_UTIL.debug('check_Payment_channel_setups:lx_channel_attrib_uses.Instr_SecCode_Use '||lx_channel_attrib_uses.Instr_SecCode_Use);

Line 593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

589: RAISE FND_API.G_EXC_ERROR;
590: END IF;
591:
592: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
594: END IF;
595: IF (l_debugon = l_true) THEN
596: IBE_UTIL.debug('check_Payment_channel_setups:lx_channel_attrib_uses.Instr_SecCode_Use '||lx_channel_attrib_uses.Instr_SecCode_Use);
597: END IF;

Line 605: x_cvv2_setup := FND_API.G_TRUE;

601: END IF;
602:
603:
604: IF(lx_channel_attrib_uses.Instr_SecCode_Use = 'REQUIRED') then
605: x_cvv2_setup := FND_API.G_TRUE;
606:
607: ELSIF(lx_channel_attrib_uses.Instr_SecCode_Use = 'OPTIONAL') then
608: x_cvv2_setup := FND_API.G_FALSE;
609: END IF;

Line 608: x_cvv2_setup := FND_API.G_FALSE;

604: IF(lx_channel_attrib_uses.Instr_SecCode_Use = 'REQUIRED') then
605: x_cvv2_setup := FND_API.G_TRUE;
606:
607: ELSIF(lx_channel_attrib_uses.Instr_SecCode_Use = 'OPTIONAL') then
608: x_cvv2_setup := FND_API.G_FALSE;
609: END IF;
610:
611: IF (l_debugon = l_true) THEN
612: IBE_UTIL.debug('check_Payment_channel_setups: lx_channel_attrib_uses.Instr_SecCode_Use '||lx_channel_attrib_uses.Instr_SecCode_Use);

Line 617: x_statement_address_setup := FND_API.G_TRUE;

613: IBE_UTIL.debug('check_Payment_channel_setups: x_cvv2_status '||x_cvv2_setup);
614: END IF;
615:
616: IF(lx_channel_attrib_uses.Instr_Billing_Address = 'REQUIRED') then
617: x_statement_address_setup := FND_API.G_TRUE;
618: ELSIF(lx_channel_attrib_uses.Instr_Billing_Address = 'OPTIONAL') then
619: x_statement_address_setup := FND_API.G_FALSE;
620: END IF;
621:

Line 619: x_statement_address_setup := FND_API.G_FALSE;

615:
616: IF(lx_channel_attrib_uses.Instr_Billing_Address = 'REQUIRED') then
617: x_statement_address_setup := FND_API.G_TRUE;
618: ELSIF(lx_channel_attrib_uses.Instr_Billing_Address = 'OPTIONAL') then
619: x_statement_address_setup := FND_API.G_FALSE;
620: END IF;
621:
622: IF (l_debugon = l_true) THEN
623: IBE_UTIL.debug('check_Payment_channel_setups: lx_channel_attrib_uses.Instr_Billing_Address '||lx_channel_attrib_uses.Instr_Billing_Address);

Line 628: WHEN FND_API.G_EXC_ERROR THEN

624: IBE_UTIL.debug('check_Payment_channel_setups: x_statement_address_setup '||x_statement_address_setup);
625: END IF;
626:
627: EXCEPTION
628: WHEN FND_API.G_EXC_ERROR THEN
629: IF (l_debugon = l_true) THEN
630: IBE_UTIL.debug('G_EXC_ERROR exception');
631: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
632: IBE_UTIL.debug('x_msg_data ' || x_msg_data);

Line 637: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

633: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
634: IBE_UTIL.debug('error text : '|| SQLERRM);
635: END IF;
636: --IBE_UTIL.disable_debug();
637: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
638: IF (l_debugon = l_true) THEN
639: IBE_UTIL.debug('G_EXC_UNEXPECTED_ERROR exception');
640: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
641: IBE_UTIL.debug('x_msg_data ' || x_msg_data);

Line 1183: ,p_debug_flag => FND_API.G_TRUE

1179:
1180: mig_exp_checkout_pay_setup
1181: (errbuf => errbuf
1182: ,retcode => retcode
1183: ,p_debug_flag => FND_API.G_TRUE
1184: ,p_commit_size => 2000);
1185:
1186: print_debug_log('IBE_PAYMENT_INT_PVT.Migrate_ibe_cc_data: Calling migrate_primary_CC');
1187:

Line 1191: ,p_debug_flag => FND_API.G_TRUE

1187:
1188: migrate_primary_CC
1189: (errbuf => errbuf
1190: ,retcode => retcode
1191: ,p_debug_flag => FND_API.G_TRUE
1192: ,p_commit_size => 2000);
1193:
1194: print_debug_log('migrate_ibe_cc_data: Done with all processing . Returning a success status ');
1195: