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 IBE_UTIL

Line 14: l_debugon VARCHAR2(1) := IBE_UTIL.G_DEBUGON;

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:
16: procedure save_credit_card
17: (p_api_version IN Number
18: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

Line 79: --IBE_UTIL.enable_debug();

75: rec_check_address_owner c_check_address_owner%rowtype;
76:
77:
78: BEGIN
79: --IBE_UTIL.enable_debug();
80: IF (l_debugon = l_true) THEN
81: IBE_UTIL.debug('enter IBE_PAYMENT_INT_PVT.save_credit_card');
82: END IF;
83: -- standard start of API savepoint

Line 81: IBE_UTIL.debug('enter IBE_PAYMENT_INT_PVT.save_credit_card');

77:
78: BEGIN
79: --IBE_UTIL.enable_debug();
80: IF (l_debugon = l_true) THEN
81: IBE_UTIL.debug('enter IBE_PAYMENT_INT_PVT.save_credit_card');
82: END IF;
83: -- standard start of API savepoint
84: SAVEPOINT save_credit_card;
85:

Line 102: IBE_UTIL.debug('save_credit_card : Input parameters' );

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' );
103: IBE_UTIL.debug('save_credit_card : p_operation_code '||p_operation_code );
104: IBE_UTIL.debug('save_credit_card : p_credit_card_id '||p_credit_card_id );
105: IBE_UTIL.debug('save_credit_card : p_assignment_id '||p_assignment_id );
106: IBE_UTIL.debug('save_credit_card : p_currency_code '||p_currency_code );

Line 103: IBE_UTIL.debug('save_credit_card : p_operation_code '||p_operation_code );

99:
100: --8529175
101: IF (l_debugon = l_true) THEN
102: IBE_UTIL.debug('save_credit_card : Input parameters' );
103: IBE_UTIL.debug('save_credit_card : p_operation_code '||p_operation_code );
104: IBE_UTIL.debug('save_credit_card : p_credit_card_id '||p_credit_card_id );
105: IBE_UTIL.debug('save_credit_card : p_assignment_id '||p_assignment_id );
106: IBE_UTIL.debug('save_credit_card : p_currency_code '||p_currency_code );
107: -- IBE_UTIL.debug('save_credit_card : p_credit_card_type_code '||p_credit_card_type_code ); -- bug 9169370, scnagara

Line 104: IBE_UTIL.debug('save_credit_card : p_credit_card_id '||p_credit_card_id );

100: --8529175
101: IF (l_debugon = l_true) THEN
102: IBE_UTIL.debug('save_credit_card : Input parameters' );
103: IBE_UTIL.debug('save_credit_card : p_operation_code '||p_operation_code );
104: IBE_UTIL.debug('save_credit_card : p_credit_card_id '||p_credit_card_id );
105: IBE_UTIL.debug('save_credit_card : p_assignment_id '||p_assignment_id );
106: IBE_UTIL.debug('save_credit_card : p_currency_code '||p_currency_code );
107: -- IBE_UTIL.debug('save_credit_card : p_credit_card_type_code '||p_credit_card_type_code ); -- bug 9169370, scnagara
108: IBE_UTIL.debug('save_credit_card : p_party_id '||p_party_id );

Line 105: IBE_UTIL.debug('save_credit_card : p_assignment_id '||p_assignment_id );

101: IF (l_debugon = l_true) THEN
102: IBE_UTIL.debug('save_credit_card : Input parameters' );
103: IBE_UTIL.debug('save_credit_card : p_operation_code '||p_operation_code );
104: IBE_UTIL.debug('save_credit_card : p_credit_card_id '||p_credit_card_id );
105: IBE_UTIL.debug('save_credit_card : p_assignment_id '||p_assignment_id );
106: IBE_UTIL.debug('save_credit_card : p_currency_code '||p_currency_code );
107: -- IBE_UTIL.debug('save_credit_card : p_credit_card_type_code '||p_credit_card_type_code ); -- bug 9169370, scnagara
108: IBE_UTIL.debug('save_credit_card : p_party_id '||p_party_id );
109: IBE_UTIL.debug('save_credit_card : p_cust_id '||p_cust_id );

Line 106: IBE_UTIL.debug('save_credit_card : p_currency_code '||p_currency_code );

102: IBE_UTIL.debug('save_credit_card : Input parameters' );
103: IBE_UTIL.debug('save_credit_card : p_operation_code '||p_operation_code );
104: IBE_UTIL.debug('save_credit_card : p_credit_card_id '||p_credit_card_id );
105: IBE_UTIL.debug('save_credit_card : p_assignment_id '||p_assignment_id );
106: IBE_UTIL.debug('save_credit_card : p_currency_code '||p_currency_code );
107: -- IBE_UTIL.debug('save_credit_card : p_credit_card_type_code '||p_credit_card_type_code ); -- bug 9169370, scnagara
108: IBE_UTIL.debug('save_credit_card : p_party_id '||p_party_id );
109: IBE_UTIL.debug('save_credit_card : p_cust_id '||p_cust_id );
110: IBE_UTIL.debug('save_credit_card : p_statement_address_id '||p_statement_address_id );

Line 107: -- IBE_UTIL.debug('save_credit_card : p_credit_card_type_code '||p_credit_card_type_code ); -- bug 9169370, scnagara

103: IBE_UTIL.debug('save_credit_card : p_operation_code '||p_operation_code );
104: IBE_UTIL.debug('save_credit_card : p_credit_card_id '||p_credit_card_id );
105: IBE_UTIL.debug('save_credit_card : p_assignment_id '||p_assignment_id );
106: IBE_UTIL.debug('save_credit_card : p_currency_code '||p_currency_code );
107: -- IBE_UTIL.debug('save_credit_card : p_credit_card_type_code '||p_credit_card_type_code ); -- bug 9169370, scnagara
108: IBE_UTIL.debug('save_credit_card : p_party_id '||p_party_id );
109: IBE_UTIL.debug('save_credit_card : p_cust_id '||p_cust_id );
110: IBE_UTIL.debug('save_credit_card : p_statement_address_id '||p_statement_address_id );
111: END IF;

Line 108: IBE_UTIL.debug('save_credit_card : p_party_id '||p_party_id );

104: IBE_UTIL.debug('save_credit_card : p_credit_card_id '||p_credit_card_id );
105: IBE_UTIL.debug('save_credit_card : p_assignment_id '||p_assignment_id );
106: IBE_UTIL.debug('save_credit_card : p_currency_code '||p_currency_code );
107: -- IBE_UTIL.debug('save_credit_card : p_credit_card_type_code '||p_credit_card_type_code ); -- bug 9169370, scnagara
108: IBE_UTIL.debug('save_credit_card : p_party_id '||p_party_id );
109: IBE_UTIL.debug('save_credit_card : p_cust_id '||p_cust_id );
110: IBE_UTIL.debug('save_credit_card : p_statement_address_id '||p_statement_address_id );
111: END IF;
112:

Line 109: IBE_UTIL.debug('save_credit_card : p_cust_id '||p_cust_id );

105: IBE_UTIL.debug('save_credit_card : p_assignment_id '||p_assignment_id );
106: IBE_UTIL.debug('save_credit_card : p_currency_code '||p_currency_code );
107: -- IBE_UTIL.debug('save_credit_card : p_credit_card_type_code '||p_credit_card_type_code ); -- bug 9169370, scnagara
108: IBE_UTIL.debug('save_credit_card : p_party_id '||p_party_id );
109: IBE_UTIL.debug('save_credit_card : p_cust_id '||p_cust_id );
110: IBE_UTIL.debug('save_credit_card : p_statement_address_id '||p_statement_address_id );
111: END IF;
112:
113: IF (l_debugon = l_true) THEN

Line 110: IBE_UTIL.debug('save_credit_card : p_statement_address_id '||p_statement_address_id );

106: IBE_UTIL.debug('save_credit_card : p_currency_code '||p_currency_code );
107: -- IBE_UTIL.debug('save_credit_card : p_credit_card_type_code '||p_credit_card_type_code ); -- bug 9169370, scnagara
108: IBE_UTIL.debug('save_credit_card : p_party_id '||p_party_id );
109: IBE_UTIL.debug('save_credit_card : p_cust_id '||p_cust_id );
110: IBE_UTIL.debug('save_credit_card : p_statement_address_id '||p_statement_address_id );
111: END IF;
112:
113: IF (l_debugon = l_true) THEN
114: IBE_UTIL.debug('call process_credit_card - setup recStructs');

Line 114: IBE_UTIL.debug('call process_credit_card - setup recStructs');

110: IBE_UTIL.debug('save_credit_card : p_statement_address_id '||p_statement_address_id );
111: END IF;
112:
113: IF (l_debugon = l_true) THEN
114: IBE_UTIL.debug('call process_credit_card - setup recStructs');
115: END IF;
116:
117: ---------- calling IBY api: START ----------------------------------------------
118: -- *. Need to make sure that IBY takes in Gmiss values

Line 159: IBE_UTIL.debug('Save_Credit_card: l_location_id from cursor '||l_location_id);

155: EXIT when c_check_address_owner%NOTFOUND;
156: END LOOP;
157:
158: IF (l_debugon = l_true) THEN
159: IBE_UTIL.debug('Save_Credit_card: l_location_id from cursor '||l_location_id);
160: IBE_UTIL.debug('Save_Credit_card:l_location_party_id from cursor '||l_location_party_id);
161: END IF;
162:
163: IF (p_party_id <> l_location_party_id) THEN

Line 160: IBE_UTIL.debug('Save_Credit_card:l_location_party_id from cursor '||l_location_party_id);

156: END LOOP;
157:
158: IF (l_debugon = l_true) THEN
159: IBE_UTIL.debug('Save_Credit_card: l_location_id from cursor '||l_location_id);
160: IBE_UTIL.debug('Save_Credit_card:l_location_party_id from cursor '||l_location_party_id);
161: END IF;
162:
163: IF (p_party_id <> l_location_party_id) THEN
164:

Line 166: IBE_UTIL.debug('Save_Credit_card: Input party id and location party id do not match');

162:
163: IF (p_party_id <> l_location_party_id) THEN
164:
165: IF (l_debugon = l_true) THEN
166: IBE_UTIL.debug('Save_Credit_card: Input party id and location party id do not match');
167: END IF;
168:
169: l_location.location_id := l_location_id;
170: l_location.address_effective_date := sysdate;

Line 178: IBE_UTIL.debug('Save_Credit_card: Ready to call IBE_ADDRESS_V2PVT.create_address');

174: l_party_site.status := 'A';
175: l_party_site.created_by_module := 'USER PROFILE';
176:
177: IF (l_debugon = l_true) THEN
178: IBE_UTIL.debug('Save_Credit_card: Ready to call IBE_ADDRESS_V2PVT.create_address');
179: END IF;
180:
181:
182: /*IBE_ADDRESS_V2PVT.create_address(

Line 204: IBE_UTIL.debug('Save_Credit_card: Done calling IBE_ADDRESS_V2PVT.create_address: x_return_status '||x_return_status);

200: ,x_msg_count => x_msg_count
201: ,x_msg_data => x_msg_data);
202:
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;

Line 215: IBE_UTIL.debug('Save_Credit_card: Done calling IBE_ADDRESS_V2PVT.create_address: No error');

211: END IF;
212:
213:
214: IF (l_debugon = l_true) THEN
215: IBE_UTIL.debug('Save_Credit_card: Done calling IBE_ADDRESS_V2PVT.create_address: No error');
216: IBE_UTIL.debug('Save_Credit_card: Done calling IBE_ADDRESS_V2PVT.create_address: new billing_address_id '||l_billing_address_id);
217: END IF;
218:
219: l_card_instrument.billing_address_id := l_billing_address_id;

Line 216: IBE_UTIL.debug('Save_Credit_card: Done calling IBE_ADDRESS_V2PVT.create_address: new billing_address_id '||l_billing_address_id);

212:
213:
214: IF (l_debugon = l_true) THEN
215: IBE_UTIL.debug('Save_Credit_card: Done calling IBE_ADDRESS_V2PVT.create_address: No error');
216: IBE_UTIL.debug('Save_Credit_card: Done calling IBE_ADDRESS_V2PVT.create_address: new billing_address_id '||l_billing_address_id);
217: END IF;
218:
219: l_card_instrument.billing_address_id := l_billing_address_id;
220:

Line 225: IBE_UTIL.debug('Save_Credit_card: Party ids match');

221: ELSE
222:
223: l_card_instrument.billing_address_id := p_statement_address_id;
224: IF (l_debugon = l_true) THEN
225: IBE_UTIL.debug('Save_Credit_card: Party ids match');
226: END IF;
227:
228: END IF;
229:

Line 320: IBE_UTIL.debug('SaveCC: Set primary opration: l_assignment_attr.assignment_id '||l_assignment_attr.assignment_id);

316: l_assignment_attr.Priority := 1;
317: l_assignment_attr.assignment_id := p_assignment_id;
318:
319: IF (l_debugon = l_true) THEN
320: IBE_UTIL.debug('SaveCC: Set primary opration: l_assignment_attr.assignment_id '||l_assignment_attr.assignment_id);
321: IBE_UTIL.debug('call IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment - before calling api');
322: END IF;
323:
324:

Line 321: IBE_UTIL.debug('call IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment - before calling api');

317: l_assignment_attr.assignment_id := p_assignment_id;
318:
319: IF (l_debugon = l_true) THEN
320: IBE_UTIL.debug('SaveCC: Set primary opration: l_assignment_attr.assignment_id '||l_assignment_attr.assignment_id);
321: IBE_UTIL.debug('call IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment - before calling api');
322: END IF;
323:
324:
325: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment (

Line 344: IBE_UTIL.debug('call IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment - after calling api');

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');
345: END IF;
346:
347: end if;
348:

Line 350: IBE_UTIL.debug('call process_credit_card - before calling api');

346:
347: end if;
348:
349: IF (l_debugon = l_true) THEN
350: IBE_UTIL.debug('call process_credit_card - before calling api');
351: END IF;
352:
353: if (p_operation_code = 'CREATE_AND_SET_PRIMARY' or p_operation_code = 'CREATE' ) then
354:

Line 370: IBE_UTIL.debug('call process_credit_card - Expected error');

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;
373:
374: RAISE FND_API.G_EXC_ERROR;

Line 371: IBE_UTIL.debug('call process_credit_card - Expected error: '||lx_response.Result_Code);

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;
373:
374: RAISE FND_API.G_EXC_ERROR;
375: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 377: IBE_UTIL.debug('call process_credit_card - UnExpected error');

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;
380: END IF;
381: x_assignment_id := lx_assign_id;

Line 404: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

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:
404: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
405: ibe_util.debug('p_operation_code :'||p_operation_code);
406: ibe_util.debug('l_oneclick_enabled :'||l_oneclick_enabled);
407: ibe_util.debug('p_party_id :'||p_party_id);
408: ibe_util.debug('p_cust_id :'||p_cust_id);

Line 405: ibe_util.debug('p_operation_code :'||p_operation_code);

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:
404: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
405: ibe_util.debug('p_operation_code :'||p_operation_code);
406: ibe_util.debug('l_oneclick_enabled :'||l_oneclick_enabled);
407: ibe_util.debug('p_party_id :'||p_party_id);
408: ibe_util.debug('p_cust_id :'||p_cust_id);
409: END IF;

Line 406: ibe_util.debug('l_oneclick_enabled :'||l_oneclick_enabled);

402: -- as the one deleted. If so, disable the Express Chkout
403:
404: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
405: ibe_util.debug('p_operation_code :'||p_operation_code);
406: ibe_util.debug('l_oneclick_enabled :'||l_oneclick_enabled);
407: ibe_util.debug('p_party_id :'||p_party_id);
408: ibe_util.debug('p_cust_id :'||p_cust_id);
409: END IF;
410:

Line 407: ibe_util.debug('p_party_id :'||p_party_id);

403:
404: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
405: ibe_util.debug('p_operation_code :'||p_operation_code);
406: ibe_util.debug('l_oneclick_enabled :'||l_oneclick_enabled);
407: ibe_util.debug('p_party_id :'||p_party_id);
408: ibe_util.debug('p_cust_id :'||p_cust_id);
409: END IF;
410:
411: if l_oneclick_enabled = 'Y' and p_operation_code = 'DELETE' then

Line 408: ibe_util.debug('p_cust_id :'||p_cust_id);

404: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
405: ibe_util.debug('p_operation_code :'||p_operation_code);
406: ibe_util.debug('l_oneclick_enabled :'||l_oneclick_enabled);
407: ibe_util.debug('p_party_id :'||p_party_id);
408: ibe_util.debug('p_cust_id :'||p_cust_id);
409: END IF;
410:
411: if l_oneclick_enabled = 'Y' and p_operation_code = 'DELETE' then
412:

Line 413: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

409: END IF;
410:
411: if l_oneclick_enabled = 'Y' and p_operation_code = 'DELETE' then
412:
413: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
414: ibe_util.debug('Entering the loop :'||p_operation_code);
415: END IF;
416:
417: OPEN c_get_oneclick_settings(p_party_id, p_cust_id);

Line 414: ibe_util.debug('Entering the loop :'||p_operation_code);

410:
411: if l_oneclick_enabled = 'Y' and p_operation_code = 'DELETE' then
412:
413: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
414: ibe_util.debug('Entering the loop :'||p_operation_code);
415: END IF;
416:
417: OPEN c_get_oneclick_settings(p_party_id, p_cust_id);
418: FETCH c_get_oneclick_settings

Line 428: IF (IBE_UTIL.G_DEBUGON = l_true) 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
429: ibe_util.debug('l_oneclick_id :'||l_oneclick_id);
430: ibe_util.debug('l_enabled_flag :'||l_enabled_flag);
431: END IF;
432:

Line 429: ibe_util.debug('l_oneclick_id :'||l_oneclick_id);

425: end if;
426: CLOSE c_get_oneclick_settings;
427:
428: IF (IBE_UTIL.G_DEBUGON = l_true) 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

Line 430: ibe_util.debug('l_enabled_flag :'||l_enabled_flag);

426: CLOSE c_get_oneclick_settings;
427:
428: IF (IBE_UTIL.G_DEBUGON = l_true) 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

Line 435: IBE_UTIL.debug('call process_credit_card - Going to call ibe_ord_oneclick_pvt.Update_Settings()');

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);
438: IBE_UTIL.debug('call process_credit_card - p_assignment_id'||l_assignment_attr.Assignment_Id);
439: END IF;

Line 436: IBE_UTIL.debug('call process_credit_card - p_party_id ' ||p_party_id);

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);
438: IBE_UTIL.debug('call process_credit_card - p_assignment_id'||l_assignment_attr.Assignment_Id);
439: END IF;
440:

Line 437: IBE_UTIL.debug('call process_credit_card - p_cust_id '||p_cust_id);

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);
438: IBE_UTIL.debug('call process_credit_card - p_assignment_id'||l_assignment_attr.Assignment_Id);
439: END IF;
440:
441: ibe_ord_oneclick_pvt.Update_Settings(

Line 438: IBE_UTIL.debug('call process_credit_card - p_assignment_id'||l_assignment_attr.Assignment_Id);

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);
438: IBE_UTIL.debug('call process_credit_card - p_assignment_id'||l_assignment_attr.Assignment_Id);
439: END IF;
440:
441: ibe_ord_oneclick_pvt.Update_Settings(
442: p_api_version => p_api_version

Line 474: -- IBE_UTIL.enable_debug();

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');
478: END IF;

Line 477: IBE_UTIL.debug('G_EXC_ERROR exception');

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');
478: END IF;
479:
480: x_return_status := FND_API.G_RET_STS_ERROR;
481: FND_MSG_PUB.Add;

Line 490: IBE_UTIL.debug('Error msg: '||substr(lx_msg_data,1,240));

486: for k in 1..x_msg_count loop
487: lx_msg_data := fnd_msg_pub.get( p_msg_index => k,
488: p_encoded => 'F');
489: IF (l_debugon = l_true) THEN
490: IBE_UTIL.debug('Error msg: '||substr(lx_msg_data,1,240));
491: END IF;
492: end loop;
493:
494: IF (l_debugon = l_true) THEN

Line 495: IBE_UTIL.debug('G_EXC_ERROR exception');

491: END IF;
492: end loop;
493:
494: IF (l_debugon = l_true) THEN
495: IBE_UTIL.debug('G_EXC_ERROR exception');
496: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
497: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
498: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
499: IBE_UTIL.debug('error text : '|| SQLERRM);

Line 496: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));

492: end loop;
493:
494: IF (l_debugon = l_true) THEN
495: IBE_UTIL.debug('G_EXC_ERROR exception');
496: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
497: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
498: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
499: IBE_UTIL.debug('error text : '|| SQLERRM);
500: END IF;

Line 497: IBE_UTIL.debug('x_msg_data ' || x_msg_data);

493:
494: IF (l_debugon = l_true) THEN
495: IBE_UTIL.debug('G_EXC_ERROR exception');
496: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
497: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
498: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
499: IBE_UTIL.debug('error text : '|| SQLERRM);
500: END IF;
501: --IBE_UTIL.disable_debug();

Line 498: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));

494: IF (l_debugon = l_true) THEN
495: IBE_UTIL.debug('G_EXC_ERROR exception');
496: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
497: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
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

Line 499: IBE_UTIL.debug('error text : '|| SQLERRM);

495: IBE_UTIL.debug('G_EXC_ERROR exception');
496: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
497: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
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();

Line 501: --IBE_UTIL.disable_debug();

497: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
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:

Line 503: --IBE_UTIL.enable_debug();

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
507: IBE_UTIL.debug('G_UNEXC_ERROR exception');

Line 507: IBE_UTIL.debug('G_UNEXC_ERROR exception');

503: --IBE_UTIL.enable_debug();
504: ROLLBACK TO save_credit_card;
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,

Line 515: IBE_UTIL.debug('G_EXC_UNEXPECTED_ERROR exception');

511: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
512: p_data => x_msg_data,
513: p_encoded => 'F');
514: IF (l_debugon = l_true) THEN
515: IBE_UTIL.debug('G_EXC_UNEXPECTED_ERROR exception');
516: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
517: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
518: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
519: IBE_UTIL.debug('error text : '|| SQLERRM);

Line 516: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));

512: p_data => x_msg_data,
513: p_encoded => 'F');
514: IF (l_debugon = l_true) THEN
515: IBE_UTIL.debug('G_EXC_UNEXPECTED_ERROR exception');
516: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
517: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
518: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
519: IBE_UTIL.debug('error text : '|| SQLERRM);
520: END IF;

Line 517: IBE_UTIL.debug('x_msg_data ' || x_msg_data);

513: p_encoded => 'F');
514: IF (l_debugon = l_true) THEN
515: IBE_UTIL.debug('G_EXC_UNEXPECTED_ERROR exception');
516: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
517: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
518: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
519: IBE_UTIL.debug('error text : '|| SQLERRM);
520: END IF;
521: --IBE_UTIL.disable_debug();

Line 518: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));

514: IF (l_debugon = l_true) THEN
515: IBE_UTIL.debug('G_EXC_UNEXPECTED_ERROR exception');
516: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
517: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
518: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
519: IBE_UTIL.debug('error text : '|| SQLERRM);
520: END IF;
521: --IBE_UTIL.disable_debug();
522: WHEN OTHERS THEN

Line 519: IBE_UTIL.debug('error text : '|| SQLERRM);

515: IBE_UTIL.debug('G_EXC_UNEXPECTED_ERROR exception');
516: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
517: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
518: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
519: IBE_UTIL.debug('error text : '|| SQLERRM);
520: END IF;
521: --IBE_UTIL.disable_debug();
522: WHEN OTHERS THEN
523: --IBE_UTIL.enable_debug();

Line 521: --IBE_UTIL.disable_debug();

517: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
518: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
519: IBE_UTIL.debug('error text : '|| SQLERRM);
520: END IF;
521: --IBE_UTIL.disable_debug();
522: WHEN OTHERS THEN
523: --IBE_UTIL.enable_debug();
524: ROLLBACK TO save_credit_card;
525: IF (l_debugon = l_true) THEN

Line 523: --IBE_UTIL.enable_debug();

519: IBE_UTIL.debug('error text : '|| SQLERRM);
520: END IF;
521: --IBE_UTIL.disable_debug();
522: WHEN OTHERS THEN
523: --IBE_UTIL.enable_debug();
524: ROLLBACK TO save_credit_card;
525: IF (l_debugon = l_true) THEN
526: IBE_UTIL.debug('Others exception');
527: END IF;

Line 526: IBE_UTIL.debug('Others exception');

522: WHEN OTHERS THEN
523: --IBE_UTIL.enable_debug();
524: ROLLBACK TO save_credit_card;
525: IF (l_debugon = l_true) THEN
526: IBE_UTIL.debug('Others exception');
527: END IF;
528:
529: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
530: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

Line 542: IBE_UTIL.debug('outside -20001 error code : '|| to_char(SQLCODE));

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;
545: IF (l_debugon = l_true) THEN
546: IBE_UTIL.debug('OTHER exception');

Line 543: IBE_UTIL.debug('outside -20001 error text : '|| SQLERRM);

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;
545: IF (l_debugon = l_true) THEN
546: IBE_UTIL.debug('OTHER exception');
547: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));

Line 546: IBE_UTIL.debug('OTHER exception');

542: IBE_UTIL.debug('outside -20001 error code : '|| to_char(SQLCODE));
543: IBE_UTIL.debug('outside -20001 error text : '|| SQLERRM);
544: END IF;
545: IF (l_debugon = l_true) THEN
546: IBE_UTIL.debug('OTHER exception');
547: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
548: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
549: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
550: IBE_UTIL.debug('error text : '|| SQLERRM);

Line 547: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));

543: IBE_UTIL.debug('outside -20001 error text : '|| SQLERRM);
544: END IF;
545: IF (l_debugon = l_true) THEN
546: IBE_UTIL.debug('OTHER exception');
547: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
548: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
549: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
550: IBE_UTIL.debug('error text : '|| SQLERRM);
551: END IF;

Line 548: IBE_UTIL.debug('x_msg_data ' || x_msg_data);

544: END IF;
545: IF (l_debugon = l_true) THEN
546: IBE_UTIL.debug('OTHER exception');
547: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
548: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
549: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
550: IBE_UTIL.debug('error text : '|| SQLERRM);
551: END IF;
552: --IBE_UTIL.disable_debug();

Line 549: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));

545: IF (l_debugon = l_true) THEN
546: IBE_UTIL.debug('OTHER exception');
547: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
548: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
549: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
550: IBE_UTIL.debug('error text : '|| SQLERRM);
551: END IF;
552: --IBE_UTIL.disable_debug();
553:

Line 550: IBE_UTIL.debug('error text : '|| SQLERRM);

546: IBE_UTIL.debug('OTHER exception');
547: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
548: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
549: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
550: IBE_UTIL.debug('error text : '|| SQLERRM);
551: END IF;
552: --IBE_UTIL.disable_debug();
553:
554: END save_credit_card;

Line 552: --IBE_UTIL.disable_debug();

548: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
549: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
550: IBE_UTIL.debug('error text : '|| SQLERRM);
551: END IF;
552: --IBE_UTIL.disable_debug();
553:
554: END save_credit_card;
555:
556: PROCEDURE check_Payment_channel_setups(

Line 576: IBE_UTIL.debug('check_Payment_channel_setups: Begin ');

572: l_msg_data VARCHAR2(2000);
573: l_result_rec_type IBY_FNDCPT_COMMON_PUB.Result_rec_type;
574: BEGIN
575: IF (l_debugon = l_true) THEN
576: IBE_UTIL.debug('check_Payment_channel_setups: Begin ');
577: END IF;
578:
579: IBY_FNDCPT_SETUP_PUB.Get_Payment_Channel_Attribs(
580: p_api_version => l_api_version,

Line 596: IBE_UTIL.debug('check_Payment_channel_setups:lx_channel_attrib_uses.Instr_SecCode_Use '||lx_channel_attrib_uses.Instr_SecCode_Use);

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;
598:
599: IF (l_debugon = l_true) THEN
600: IBE_UTIL.debug('check_Payment_channel_setups:lx_channel_attrib_uses.Instr_Billing_Address '||lx_channel_attrib_uses.Instr_Billing_Address);

Line 600: IBE_UTIL.debug('check_Payment_channel_setups:lx_channel_attrib_uses.Instr_Billing_Address '||lx_channel_attrib_uses.Instr_Billing_Address);

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;
598:
599: IF (l_debugon = l_true) THEN
600: IBE_UTIL.debug('check_Payment_channel_setups:lx_channel_attrib_uses.Instr_Billing_Address '||lx_channel_attrib_uses.Instr_Billing_Address);
601: END IF;
602:
603:
604: IF(lx_channel_attrib_uses.Instr_SecCode_Use = 'REQUIRED') then

Line 612: IBE_UTIL.debug('check_Payment_channel_setups: lx_channel_attrib_uses.Instr_SecCode_Use '||lx_channel_attrib_uses.Instr_SecCode_Use);

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);
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

Line 613: IBE_UTIL.debug('check_Payment_channel_setups: x_cvv2_status '||x_cvv2_setup);

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);
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;

Line 623: IBE_UTIL.debug('check_Payment_channel_setups: lx_channel_attrib_uses.Instr_Billing_Address '||lx_channel_attrib_uses.Instr_Billing_Address);

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);
624: IBE_UTIL.debug('check_Payment_channel_setups: x_statement_address_setup '||x_statement_address_setup);
625: END IF;
626:
627: EXCEPTION

Line 624: IBE_UTIL.debug('check_Payment_channel_setups: x_statement_address_setup '||x_statement_address_setup);

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);
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

Line 630: IBE_UTIL.debug('G_EXC_ERROR exception');

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);
633: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
634: IBE_UTIL.debug('error text : '|| SQLERRM);

Line 631: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));

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);
633: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
634: IBE_UTIL.debug('error text : '|| SQLERRM);
635: END IF;

Line 632: IBE_UTIL.debug('x_msg_data ' || x_msg_data);

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);
633: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
634: IBE_UTIL.debug('error text : '|| SQLERRM);
635: END IF;
636: --IBE_UTIL.disable_debug();

Line 633: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));

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);
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

Line 634: IBE_UTIL.debug('error text : '|| SQLERRM);

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);
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

Line 636: --IBE_UTIL.disable_debug();

632: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
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));

Line 639: IBE_UTIL.debug('G_EXC_UNEXPECTED_ERROR exception');

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);
642: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
643: IBE_UTIL.debug('error text : '|| SQLERRM);

Line 640: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));

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);
642: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
643: IBE_UTIL.debug('error text : '|| SQLERRM);
644: END IF;

Line 641: IBE_UTIL.debug('x_msg_data ' || x_msg_data);

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);
642: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
643: IBE_UTIL.debug('error text : '|| SQLERRM);
644: END IF;
645: --IBE_UTIL.disable_debug();

Line 642: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));

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);
642: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
643: IBE_UTIL.debug('error text : '|| SQLERRM);
644: END IF;
645: --IBE_UTIL.disable_debug();
646: WHEN OTHERS THEN

Line 643: IBE_UTIL.debug('error text : '|| SQLERRM);

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);
642: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
643: IBE_UTIL.debug('error text : '|| SQLERRM);
644: END IF;
645: --IBE_UTIL.disable_debug();
646: WHEN OTHERS THEN
647: IF (l_debugon = l_true) THEN

Line 645: --IBE_UTIL.disable_debug();

641: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
642: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
643: IBE_UTIL.debug('error text : '|| SQLERRM);
644: END IF;
645: --IBE_UTIL.disable_debug();
646: WHEN OTHERS THEN
647: IF (l_debugon = l_true) THEN
648: IBE_UTIL.debug('outside -20001 error code : '|| to_char(SQLCODE));
649: IBE_UTIL.debug('outside -20001 error text : '|| SQLERRM);

Line 648: IBE_UTIL.debug('outside -20001 error code : '|| to_char(SQLCODE));

644: END IF;
645: --IBE_UTIL.disable_debug();
646: WHEN OTHERS THEN
647: IF (l_debugon = l_true) THEN
648: IBE_UTIL.debug('outside -20001 error code : '|| to_char(SQLCODE));
649: IBE_UTIL.debug('outside -20001 error text : '|| SQLERRM);
650: END IF;
651: IF (l_debugon = l_true) THEN
652: IBE_UTIL.debug('OTHER exception');

Line 649: IBE_UTIL.debug('outside -20001 error text : '|| SQLERRM);

645: --IBE_UTIL.disable_debug();
646: WHEN OTHERS THEN
647: IF (l_debugon = l_true) THEN
648: IBE_UTIL.debug('outside -20001 error code : '|| to_char(SQLCODE));
649: IBE_UTIL.debug('outside -20001 error text : '|| SQLERRM);
650: END IF;
651: IF (l_debugon = l_true) THEN
652: IBE_UTIL.debug('OTHER exception');
653: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));

Line 652: IBE_UTIL.debug('OTHER exception');

648: IBE_UTIL.debug('outside -20001 error code : '|| to_char(SQLCODE));
649: IBE_UTIL.debug('outside -20001 error text : '|| SQLERRM);
650: END IF;
651: IF (l_debugon = l_true) THEN
652: IBE_UTIL.debug('OTHER exception');
653: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
654: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
655: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
656: IBE_UTIL.debug('error text : '|| SQLERRM);

Line 653: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));

649: IBE_UTIL.debug('outside -20001 error text : '|| SQLERRM);
650: END IF;
651: IF (l_debugon = l_true) THEN
652: IBE_UTIL.debug('OTHER exception');
653: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
654: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
655: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
656: IBE_UTIL.debug('error text : '|| SQLERRM);
657: END IF;

Line 654: IBE_UTIL.debug('x_msg_data ' || x_msg_data);

650: END IF;
651: IF (l_debugon = l_true) THEN
652: IBE_UTIL.debug('OTHER exception');
653: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
654: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
655: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
656: IBE_UTIL.debug('error text : '|| SQLERRM);
657: END IF;
658: END check_Payment_channel_setups;

Line 655: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));

651: IF (l_debugon = l_true) THEN
652: IBE_UTIL.debug('OTHER exception');
653: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
654: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
655: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
656: IBE_UTIL.debug('error text : '|| SQLERRM);
657: END IF;
658: END check_Payment_channel_setups;
659:

Line 656: IBE_UTIL.debug('error text : '|| SQLERRM);

652: IBE_UTIL.debug('OTHER exception');
653: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
654: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
655: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
656: IBE_UTIL.debug('error text : '|| SQLERRM);
657: END IF;
658: END check_Payment_channel_setups;
659:
660: PROCEDURE print_debug_log(p_debug_str IN VARCHAR2) IS

Line 665: IBE_UTIL.debug(p_debug_str);

661:
662: BEGIN
663:
664: FND_FILE.PUT_LINE(FND_FILE.LOG,p_debug_str);
665: IBE_UTIL.debug(p_debug_str);
666:
667: END print_Debug_Log;
668:
669: PROCEDURE print_output(p_message IN VARCHAR2) IS