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_CUSTOMER_PVT dependencies on IBE_UTIL

Line 39: --IBE_UTIL.enable_debug();

35: l_date DATE;
36: l_obj_ver NUMBER;
37:
38: BEGIN
39: --IBE_UTIL.enable_debug();
40: -- standard start of API savepoint
41: SAVEPOINT setOptInOutPreference;
42:
43: -- standard call to check for call compatibility

Line 108: --IBE_UTIL.disable_debug();

104: p_encoded => FND_API.G_FALSE,
105: p_count => x_msg_count,
106: p_data => x_msg_data
107: );
108: --IBE_UTIL.disable_debug();
109:
110: --standard exception catching for main body
111: EXCEPTION
112: WHEN FND_API.G_EXC_ERROR THEN

Line 113: --IBE_UTIL.enable_debug();

109:
110: --standard exception catching for main body
111: EXCEPTION
112: WHEN FND_API.G_EXC_ERROR THEN
113: --IBE_UTIL.enable_debug();
114:
115: ROLLBACK TO setOptInOutPreference;
116: x_return_status := FND_API.G_RET_STS_ERROR;
117: FND_MSG_PUB.count_and_get(

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

118: p_encoded => FND_API.G_FALSE,
119: p_count => x_msg_count,
120: p_data => x_msg_data
121: );
122: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
123: IBE_UTIL.debug('G_EXC_ERROR exception');
124: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
125: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
126: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));

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

119: p_count => x_msg_count,
120: p_data => x_msg_data
121: );
122: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
123: IBE_UTIL.debug('G_EXC_ERROR exception');
124: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
125: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
126: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
127: IBE_UTIL.debug('error text : '|| SQLERRM);

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

120: p_data => x_msg_data
121: );
122: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
123: IBE_UTIL.debug('G_EXC_ERROR exception');
124: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
125: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
126: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
127: IBE_UTIL.debug('error text : '|| SQLERRM);
128: END IF;

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

121: );
122: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
123: IBE_UTIL.debug('G_EXC_ERROR exception');
124: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
125: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
126: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
127: IBE_UTIL.debug('error text : '|| SQLERRM);
128: END IF;
129:

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

122: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
123: IBE_UTIL.debug('G_EXC_ERROR exception');
124: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
125: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
126: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
127: IBE_UTIL.debug('error text : '|| SQLERRM);
128: END IF;
129:
130: --IBE_UTIL.disable_debug();

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

123: IBE_UTIL.debug('G_EXC_ERROR exception');
124: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
125: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
126: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
127: IBE_UTIL.debug('error text : '|| SQLERRM);
128: END IF;
129:
130: --IBE_UTIL.disable_debug();
131:

Line 130: --IBE_UTIL.disable_debug();

126: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
127: IBE_UTIL.debug('error text : '|| SQLERRM);
128: END IF;
129:
130: --IBE_UTIL.disable_debug();
131:
132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
133: --IBE_UTIL.enable_debug();
134:

Line 133: --IBE_UTIL.enable_debug();

129:
130: --IBE_UTIL.disable_debug();
131:
132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
133: --IBE_UTIL.enable_debug();
134:
135: ROLLBACK TO setOptInOutPreference;
136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
137: FND_MSG_PUB.count_and_get(

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

138: p_encoded => FND_API.G_FALSE,
139: p_count => x_msg_count,
140: p_data => x_msg_data
141: );
142: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
143: IBE_UTIL.debug('G_EXC_UNEXPECTED_ERROR exception');
144: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
145: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
146: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));

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

139: p_count => x_msg_count,
140: p_data => x_msg_data
141: );
142: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
143: IBE_UTIL.debug('G_EXC_UNEXPECTED_ERROR exception');
144: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
145: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
146: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
147: IBE_UTIL.debug('error text : '|| SQLERRM);

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

140: p_data => x_msg_data
141: );
142: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
143: IBE_UTIL.debug('G_EXC_UNEXPECTED_ERROR exception');
144: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
145: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
146: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
147: IBE_UTIL.debug('error text : '|| SQLERRM);
148: END IF;

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

141: );
142: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
143: IBE_UTIL.debug('G_EXC_UNEXPECTED_ERROR exception');
144: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
145: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
146: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
147: IBE_UTIL.debug('error text : '|| SQLERRM);
148: END IF;
149:

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

142: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
143: IBE_UTIL.debug('G_EXC_UNEXPECTED_ERROR exception');
144: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
145: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
146: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
147: IBE_UTIL.debug('error text : '|| SQLERRM);
148: END IF;
149:
150: --IBE_UTIL.disable_debug();

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

143: IBE_UTIL.debug('G_EXC_UNEXPECTED_ERROR exception');
144: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
145: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
146: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
147: IBE_UTIL.debug('error text : '|| SQLERRM);
148: END IF;
149:
150: --IBE_UTIL.disable_debug();
151:

Line 150: --IBE_UTIL.disable_debug();

146: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
147: IBE_UTIL.debug('error text : '|| SQLERRM);
148: END IF;
149:
150: --IBE_UTIL.disable_debug();
151:
152: WHEN OTHERS THEN
153: --IBE_UTIL.enable_debug();
154:

Line 153: --IBE_UTIL.enable_debug();

149:
150: --IBE_UTIL.disable_debug();
151:
152: WHEN OTHERS THEN
153: --IBE_UTIL.enable_debug();
154:
155: ROLLBACK TO setOptInOutPreference;
156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
157: FND_MSG_PUB.count_and_get(

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

158: p_encoded => FND_API.G_FALSE,
159: p_count => x_msg_count,
160: p_data => x_msg_data
161: );
162: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
163: IBE_UTIL.debug('OTHER exception');
164: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
165: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
166: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));

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

159: p_count => x_msg_count,
160: p_data => x_msg_data
161: );
162: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
163: IBE_UTIL.debug('OTHER exception');
164: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
165: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
166: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
167: IBE_UTIL.debug('error text : '|| SQLERRM);

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

160: p_data => x_msg_data
161: );
162: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
163: IBE_UTIL.debug('OTHER exception');
164: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
165: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
166: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
167: IBE_UTIL.debug('error text : '|| SQLERRM);
168: END IF;

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

161: );
162: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
163: IBE_UTIL.debug('OTHER exception');
164: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
165: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
166: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
167: IBE_UTIL.debug('error text : '|| SQLERRM);
168: END IF;
169:

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

162: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
163: IBE_UTIL.debug('OTHER exception');
164: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
165: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
166: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
167: IBE_UTIL.debug('error text : '|| SQLERRM);
168: END IF;
169:
170: --IBE_UTIL.disable_debug();

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

163: IBE_UTIL.debug('OTHER exception');
164: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
165: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
166: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
167: IBE_UTIL.debug('error text : '|| SQLERRM);
168: END IF;
169:
170: --IBE_UTIL.disable_debug();
171:

Line 170: --IBE_UTIL.disable_debug();

166: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
167: IBE_UTIL.debug('error text : '|| SQLERRM);
168: END IF;
169:
170: --IBE_UTIL.disable_debug();
171:
172: END setOptInOutPreference;
173:
174:

Line 304: --IBE_UTIL.enable_debug();

300: l_def_cc_assignment_id NUMBER;
301: l_cc_assignment_id NUMBER;
302: BEGIN
303:
304: --IBE_UTIL.enable_debug();
305:
306: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
307: IBE_UTIL.debug('enter ibe_customer_pvt.get_default_credit_card_info');
308: END IF;

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

302: BEGIN
303:
304: --IBE_UTIL.enable_debug();
305:
306: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
307: IBE_UTIL.debug('enter ibe_customer_pvt.get_default_credit_card_info');
308: END IF;
309:
310:

Line 307: IBE_UTIL.debug('enter ibe_customer_pvt.get_default_credit_card_info');

303:
304: --IBE_UTIL.enable_debug();
305:
306: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
307: IBE_UTIL.debug('enter ibe_customer_pvt.get_default_credit_card_info');
308: END IF;
309:
310:
311: IF NOT FND_API.compatible_api_call(l_api_version,

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

324: -- Initialize API return status to success
325: x_return_status := FND_API.G_RET_STS_SUCCESS;
326:
327:
328: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
329: IBE_UTIL.debug('call cursor c_getPrimaryCCInfo()');
330: END IF;
331: -- call cursor c_getPrimaryInfo
332:

Line 329: IBE_UTIL.debug('call cursor c_getPrimaryCCInfo()');

325: x_return_status := FND_API.G_RET_STS_SUCCESS;
326:
327:
328: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
329: IBE_UTIL.debug('call cursor c_getPrimaryCCInfo()');
330: END IF;
331: -- call cursor c_getPrimaryInfo
332:
333: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

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

329: IBE_UTIL.debug('call cursor c_getPrimaryCCInfo()');
330: END IF;
331: -- call cursor c_getPrimaryInfo
332:
333: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
334: IBE_UTIL.debug('cust_acct_id = '||p_cust_account_id||'party_id = '||p_party_id||' minisite_id : '||p_mini_site_id);
335: END IF;
336:
337: OPEN c_getPrimaryCCInfo(p_cust_account_id,p_party_id,p_mini_site_id);

Line 334: IBE_UTIL.debug('cust_acct_id = '||p_cust_account_id||'party_id = '||p_party_id||' minisite_id : '||p_mini_site_id);

330: END IF;
331: -- call cursor c_getPrimaryInfo
332:
333: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
334: IBE_UTIL.debug('cust_acct_id = '||p_cust_account_id||'party_id = '||p_party_id||' minisite_id : '||p_mini_site_id);
335: END IF;
336:
337: OPEN c_getPrimaryCCInfo(p_cust_account_id,p_party_id,p_mini_site_id);
338:

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

337: OPEN c_getPrimaryCCInfo(p_cust_account_id,p_party_id,p_mini_site_id);
338:
339: FETCH c_getPrimaryCCInfo INTO l_cc_assignment_id ;
340:
341: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
342: IBE_UTIL.debug('call cursor c_getFirstCCInfo()');
343: END IF;
344: OPEN c_getFirstCCInfo(p_cust_account_id,p_party_id,p_mini_site_id);
345:

Line 342: IBE_UTIL.debug('call cursor c_getFirstCCInfo()');

338:
339: FETCH c_getPrimaryCCInfo INTO l_cc_assignment_id ;
340:
341: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
342: IBE_UTIL.debug('call cursor c_getFirstCCInfo()');
343: END IF;
344: OPEN c_getFirstCCInfo(p_cust_account_id,p_party_id,p_mini_site_id);
345:
346: FETCH c_getFirstCCInfo INTO l_def_cc_assignment_id;

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

345:
346: FETCH c_getFirstCCInfo INTO l_def_cc_assignment_id;
347:
348: if c_getPrimaryCCInfo%FOUND then
349: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
350: IBE_UTIL.debug('Primary CC found');
351: END IF;
352:
353: x_cc_assignment_id:= l_cc_assignment_id;

Line 350: IBE_UTIL.debug('Primary CC found');

346: FETCH c_getFirstCCInfo INTO l_def_cc_assignment_id;
347:
348: if c_getPrimaryCCInfo%FOUND then
349: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
350: IBE_UTIL.debug('Primary CC found');
351: END IF;
352:
353: x_cc_assignment_id:= l_cc_assignment_id;
354: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

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

350: IBE_UTIL.debug('Primary CC found');
351: END IF;
352:
353: x_cc_assignment_id:= l_cc_assignment_id;
354: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
355: IBE_UTIL.debug('x_cc_assign_id : '||l_cc_assignment_id);
356: END IF;
357: --else
358: --IBE_UTIL.debug('No Primary Info found');

Line 355: IBE_UTIL.debug('x_cc_assign_id : '||l_cc_assignment_id);

351: END IF;
352:
353: x_cc_assignment_id:= l_cc_assignment_id;
354: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
355: IBE_UTIL.debug('x_cc_assign_id : '||l_cc_assignment_id);
356: END IF;
357: --else
358: --IBE_UTIL.debug('No Primary Info found');
359: --close c_getPrimaryCCInfo;

Line 358: --IBE_UTIL.debug('No Primary Info found');

354: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
355: IBE_UTIL.debug('x_cc_assign_id : '||l_cc_assignment_id);
356: END IF;
357: --else
358: --IBE_UTIL.debug('No Primary Info found');
359: --close c_getPrimaryCCInfo;
360: --end if;
361: elsif (c_getFirstCCInfo%FOUND) then
362:

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

359: --close c_getPrimaryCCInfo;
360: --end if;
361: elsif (c_getFirstCCInfo%FOUND) then
362:
363: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
364: IBE_UTIL.debug('Default CC found ');
365: END IF;
366:
367: x_cc_assignment_id := l_def_cc_assignment_id;

Line 364: IBE_UTIL.debug('Default CC found ');

360: --end if;
361: elsif (c_getFirstCCInfo%FOUND) then
362:
363: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
364: IBE_UTIL.debug('Default CC found ');
365: END IF;
366:
367: x_cc_assignment_id := l_def_cc_assignment_id;
368: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

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

364: IBE_UTIL.debug('Default CC found ');
365: END IF;
366:
367: x_cc_assignment_id := l_def_cc_assignment_id;
368: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
369: IBE_UTIL.debug('x_def_cc_assign_id : '||l_def_cc_assignment_id);
370: END IF;
371: else
372:

Line 369: IBE_UTIL.debug('x_def_cc_assign_id : '||l_def_cc_assignment_id);

365: END IF;
366:
367: x_cc_assignment_id := l_def_cc_assignment_id;
368: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
369: IBE_UTIL.debug('x_def_cc_assign_id : '||l_def_cc_assignment_id);
370: END IF;
371: else
372:
373: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

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

369: IBE_UTIL.debug('x_def_cc_assign_id : '||l_def_cc_assignment_id);
370: END IF;
371: else
372:
373: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
374: IBE_UTIL.debug(' No default Credit card info found ');
375: END IF;
376: close c_getFirstCCInfo;
377: close c_getPrimaryCCInfo;

Line 374: IBE_UTIL.debug(' No default Credit card info found ');

370: END IF;
371: else
372:
373: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
374: IBE_UTIL.debug(' No default Credit card info found ');
375: END IF;
376: close c_getFirstCCInfo;
377: close c_getPrimaryCCInfo;
378: end if;

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

377: close c_getPrimaryCCInfo;
378: end if;
379:
380: /* 3/3/05: comment out
381: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
382: IBE_UTIL.debug('x_credit_card_num : '||x_credit_card_num);
383: IBE_UTIL.debug('x_card_holder_name : '||x_card_holder_name);
384: IBE_UTIL.debug('x_credit_card_exp_date : '||x_credit_card_exp_date);
385: IBE_UTIL.debug('x_credit_card_type : '||x_credit_card_type);

Line 382: IBE_UTIL.debug('x_credit_card_num : '||x_credit_card_num);

378: end if;
379:
380: /* 3/3/05: comment out
381: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
382: IBE_UTIL.debug('x_credit_card_num : '||x_credit_card_num);
383: IBE_UTIL.debug('x_card_holder_name : '||x_card_holder_name);
384: IBE_UTIL.debug('x_credit_card_exp_date : '||x_credit_card_exp_date);
385: IBE_UTIL.debug('x_credit_card_type : '||x_credit_card_type);
386: END IF;

Line 383: IBE_UTIL.debug('x_card_holder_name : '||x_card_holder_name);

379:
380: /* 3/3/05: comment out
381: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
382: IBE_UTIL.debug('x_credit_card_num : '||x_credit_card_num);
383: IBE_UTIL.debug('x_card_holder_name : '||x_card_holder_name);
384: IBE_UTIL.debug('x_credit_card_exp_date : '||x_credit_card_exp_date);
385: IBE_UTIL.debug('x_credit_card_type : '||x_credit_card_type);
386: END IF;
387: */

Line 384: IBE_UTIL.debug('x_credit_card_exp_date : '||x_credit_card_exp_date);

380: /* 3/3/05: comment out
381: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
382: IBE_UTIL.debug('x_credit_card_num : '||x_credit_card_num);
383: IBE_UTIL.debug('x_card_holder_name : '||x_card_holder_name);
384: IBE_UTIL.debug('x_credit_card_exp_date : '||x_credit_card_exp_date);
385: IBE_UTIL.debug('x_credit_card_type : '||x_credit_card_type);
386: END IF;
387: */
388:

Line 385: IBE_UTIL.debug('x_credit_card_type : '||x_credit_card_type);

381: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
382: IBE_UTIL.debug('x_credit_card_num : '||x_credit_card_num);
383: IBE_UTIL.debug('x_card_holder_name : '||x_card_holder_name);
384: IBE_UTIL.debug('x_credit_card_exp_date : '||x_credit_card_exp_date);
385: IBE_UTIL.debug('x_credit_card_type : '||x_credit_card_type);
386: END IF;
387: */
388:
389:

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

400: p_data => x_msg_data
401: );
402:
403:
404: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
405: IBE_UTIL.debug('exit ibe_customer_pvt.get_default_credit_card_info');
406: END IF;
407:
408: --IBE_UTIL.disable_debug();

Line 405: IBE_UTIL.debug('exit ibe_customer_pvt.get_default_credit_card_info');

401: );
402:
403:
404: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
405: IBE_UTIL.debug('exit ibe_customer_pvt.get_default_credit_card_info');
406: END IF;
407:
408: --IBE_UTIL.disable_debug();
409:

Line 408: --IBE_UTIL.disable_debug();

404: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
405: IBE_UTIL.debug('exit ibe_customer_pvt.get_default_credit_card_info');
406: END IF;
407:
408: --IBE_UTIL.disable_debug();
409:
410: EXCEPTION
411:
412: WHEN FND_API.G_EXC_ERROR THEN

Line 413: --IBE_UTIL.enable_debug();

409:
410: EXCEPTION
411:
412: WHEN FND_API.G_EXC_ERROR THEN
413: --IBE_UTIL.enable_debug();
414:
415: --ROLLBACK TO create_credit_card;
416:
417: x_return_status := FND_API.G_RET_STS_ERROR;

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

419: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
420: p_data => x_msg_data,
421: p_encoded => 'F');
422:
423: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
424: IBE_UTIL.debug('G_EXC_ERROR exception');
425: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
426: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
427: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));

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

420: p_data => x_msg_data,
421: p_encoded => 'F');
422:
423: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
424: IBE_UTIL.debug('G_EXC_ERROR exception');
425: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
426: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
427: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
428: IBE_UTIL.debug('error text : '|| SQLERRM);

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

421: p_encoded => 'F');
422:
423: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
424: IBE_UTIL.debug('G_EXC_ERROR exception');
425: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
426: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
427: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
428: IBE_UTIL.debug('error text : '|| SQLERRM);
429: END IF;

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

422:
423: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
424: IBE_UTIL.debug('G_EXC_ERROR exception');
425: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
426: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
427: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
428: IBE_UTIL.debug('error text : '|| SQLERRM);
429: END IF;
430:

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

423: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
424: IBE_UTIL.debug('G_EXC_ERROR exception');
425: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
426: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
427: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
428: IBE_UTIL.debug('error text : '|| SQLERRM);
429: END IF;
430:
431:

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

424: IBE_UTIL.debug('G_EXC_ERROR exception');
425: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
426: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
427: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
428: IBE_UTIL.debug('error text : '|| SQLERRM);
429: END IF;
430:
431:
432: --IBE_UTIL.disable_debug();

Line 432: --IBE_UTIL.disable_debug();

428: IBE_UTIL.debug('error text : '|| SQLERRM);
429: END IF;
430:
431:
432: --IBE_UTIL.disable_debug();
433:
434:
435:
436:

Line 438: --IBE_UTIL.enable_debug();

434:
435:
436:
437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
438: --IBE_UTIL.enable_debug();
439:
440: --ROLLBACK TO create_credit_card;
441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
442: FND_MSG_PUB.ADD;

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

443: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
444: p_data => x_msg_data,
445: p_encoded => 'F');
446:
447: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
448: IBE_UTIL.debug('G_EXC_UNEXPECTED_ERROR exception');
449: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
450: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
451: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));

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

444: p_data => x_msg_data,
445: p_encoded => 'F');
446:
447: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
448: IBE_UTIL.debug('G_EXC_UNEXPECTED_ERROR exception');
449: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
450: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
451: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
452: IBE_UTIL.debug('error text : '|| SQLERRM);

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

445: p_encoded => 'F');
446:
447: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
448: IBE_UTIL.debug('G_EXC_UNEXPECTED_ERROR exception');
449: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
450: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
451: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
452: IBE_UTIL.debug('error text : '|| SQLERRM);
453: END IF;

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

446:
447: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
448: IBE_UTIL.debug('G_EXC_UNEXPECTED_ERROR exception');
449: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
450: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
451: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
452: IBE_UTIL.debug('error text : '|| SQLERRM);
453: END IF;
454:

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

447: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
448: IBE_UTIL.debug('G_EXC_UNEXPECTED_ERROR exception');
449: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
450: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
451: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
452: IBE_UTIL.debug('error text : '|| SQLERRM);
453: END IF;
454:
455: --IBE_UTIL.disable_debug();

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

448: IBE_UTIL.debug('G_EXC_UNEXPECTED_ERROR exception');
449: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
450: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
451: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
452: IBE_UTIL.debug('error text : '|| SQLERRM);
453: END IF;
454:
455: --IBE_UTIL.disable_debug();
456:

Line 455: --IBE_UTIL.disable_debug();

451: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
452: IBE_UTIL.debug('error text : '|| SQLERRM);
453: END IF;
454:
455: --IBE_UTIL.disable_debug();
456:
457:
458:
459:

Line 461: --IBE_UTIL.enable_debug();

457:
458:
459:
460: WHEN OTHERS THEN
461: --IBE_UTIL.enable_debug();
462:
463: --ROLLBACK TO create_credit_card;
464: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
465: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

Line 476: --IBE_UTIL.debug('OTHER exception');

472: p_data => x_msg_data,
473: p_encoded => 'F');
474:
475:
476: --IBE_UTIL.debug('OTHER exception');
477: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
478: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
479: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
480: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));

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

473: p_encoded => 'F');
474:
475:
476: --IBE_UTIL.debug('OTHER exception');
477: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
478: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
479: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
480: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
481: IBE_UTIL.debug('error text : '|| SQLERRM);

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

474:
475:
476: --IBE_UTIL.debug('OTHER exception');
477: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
478: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
479: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
480: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
481: IBE_UTIL.debug('error text : '|| SQLERRM);
482: END IF;

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

475:
476: --IBE_UTIL.debug('OTHER exception');
477: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
478: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
479: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
480: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
481: IBE_UTIL.debug('error text : '|| SQLERRM);
482: END IF;
483:

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

476: --IBE_UTIL.debug('OTHER exception');
477: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
478: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
479: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
480: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
481: IBE_UTIL.debug('error text : '|| SQLERRM);
482: END IF;
483:
484: --IBE_UTIL.disable_debug();

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

477: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
478: IBE_UTIL.debug('x_msg_count ' || to_char(x_msg_count));
479: IBE_UTIL.debug('x_msg_data ' || x_msg_data);
480: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
481: IBE_UTIL.debug('error text : '|| SQLERRM);
482: END IF;
483:
484: --IBE_UTIL.disable_debug();
485:

Line 484: --IBE_UTIL.disable_debug();

480: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
481: IBE_UTIL.debug('error text : '|| SQLERRM);
482: END IF;
483:
484: --IBE_UTIL.disable_debug();
485:
486:
487:
488:

Line 522: --IBE_UTIL.enable_debug();

518: l_assignment_id NUMBER;
519: l_party_to_use NUMBER;
520:
521: BEGIN
522: --IBE_UTIL.enable_debug();
523:
524: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
525: IBE_UTIL.debug('enter ibe_customer_pvt.get_primary_credit_card_id');
526: END IF;

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

520:
521: BEGIN
522: --IBE_UTIL.enable_debug();
523:
524: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
525: IBE_UTIL.debug('enter ibe_customer_pvt.get_primary_credit_card_id');
526: END IF;
527:
528: FOR rec_get_party_cust_accnt in C_get_party_cust_accnt(p_username) LOOP

Line 525: IBE_UTIL.debug('enter ibe_customer_pvt.get_primary_credit_card_id');

521: BEGIN
522: --IBE_UTIL.enable_debug();
523:
524: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
525: IBE_UTIL.debug('enter ibe_customer_pvt.get_primary_credit_card_id');
526: END IF;
527:
528: FOR rec_get_party_cust_accnt in C_get_party_cust_accnt(p_username) LOOP
529: l_customer_id := rec_get_party_cust_accnt.customer_id;

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

532: END LOOP;
533:
534: IF (l_customer_id is null) THEN
535: l_party_to_use := l_person_party_id;
536: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
537: IBE_UTIL.debug('customer_id does not have any value, using the person_party_id');
538: END IF;
539: ELSE
540: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 537: IBE_UTIL.debug('customer_id does not have any value, using the person_party_id');

533:
534: IF (l_customer_id is null) THEN
535: l_party_to_use := l_person_party_id;
536: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
537: IBE_UTIL.debug('customer_id does not have any value, using the person_party_id');
538: END IF;
539: ELSE
540: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
541: IBE_UTIL.debug('customer_id has a value,l_party_to_use: '||l_customer_id);

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

536: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
537: IBE_UTIL.debug('customer_id does not have any value, using the person_party_id');
538: END IF;
539: ELSE
540: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
541: IBE_UTIL.debug('customer_id has a value,l_party_to_use: '||l_customer_id);
542: END IF;
543: l_party_to_use := l_customer_id;
544: END IF;

Line 541: IBE_UTIL.debug('customer_id has a value,l_party_to_use: '||l_customer_id);

537: IBE_UTIL.debug('customer_id does not have any value, using the person_party_id');
538: END IF;
539: ELSE
540: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
541: IBE_UTIL.debug('customer_id has a value,l_party_to_use: '||l_customer_id);
542: END IF;
543: l_party_to_use := l_customer_id;
544: END IF;
545:

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

547: l_assignment_id := rec_get_primary_credit_card.instr_assignment_id;
548: EXIT when c_get_primary_credit_card%NOTFOUND;
549: END LOOP;
550:
551: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
552: IBE_UTIL.debug('primary card asignment id is '||l_assignment_id);
553: END IF;
554: x_credit_card_id := l_assignment_id;
555: END ;

Line 552: IBE_UTIL.debug('primary card asignment id is '||l_assignment_id);

548: EXIT when c_get_primary_credit_card%NOTFOUND;
549: END LOOP;
550:
551: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
552: IBE_UTIL.debug('primary card asignment id is '||l_assignment_id);
553: END IF;
554: x_credit_card_id := l_assignment_id;
555: END ;
556: