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: IF (l_debugon = l_true) THEN
101: IBE_UTIL.debug('save_credit_card : Input parameters' );
102: IBE_UTIL.debug('save_credit_card : p_operation_code '||p_operation_code );

Line 196: ,p_init_msg_list => FND_API.G_FALSE

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

Line 197: ,p_commit => FND_API.G_FALSE

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

Line 209: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 210: RAISE FND_API.G_EXC_ERROR;

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

Line 211: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 339: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 340: RAISE FND_API.G_EXC_ERROR;

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

Line 341: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 370: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 376: RAISE FND_API.G_EXC_ERROR;

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

Line 377: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 398: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 399: RAISE FND_API.G_EXC_ERROR;

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

Line 400: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 426: l_oneclick_id := FND_API.g_miss_num;

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

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

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

Line 454: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 455: RAISE FND_API.G_EXC_ERROR;

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

Line 456: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 463: IF FND_API.to_boolean(p_commit) THEN

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

Line 469: p_encoded => FND_API.G_FALSE,

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

Line 475: WHEN FND_API.G_EXC_ERROR THEN

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

Line 482: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

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

Line 542: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

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

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

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

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

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

Line 591: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 607: x_cvv2_setup := FND_API.G_TRUE;

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

Line 610: x_cvv2_setup := FND_API.G_FALSE;

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

Line 619: x_statement_address_setup := FND_API.G_TRUE;

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

Line 621: x_statement_address_setup := FND_API.G_FALSE;

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

Line 630: WHEN FND_API.G_EXC_ERROR THEN

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

Line 639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1185: ,p_debug_flag => FND_API.G_TRUE

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

Line 1193: ,p_debug_flag => FND_API.G_TRUE

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