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 302: --IBE_UTIL.enable_debug();

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 406: --IBE_UTIL.disable_debug();

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

Line 411: --IBE_UTIL.enable_debug();

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 430: --IBE_UTIL.disable_debug();

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

Line 436: --IBE_UTIL.enable_debug();

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 453: --IBE_UTIL.disable_debug();

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

Line 459: --IBE_UTIL.enable_debug();

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 482: --IBE_UTIL.disable_debug();

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

Line 520: --IBE_UTIL.enable_debug();

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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