DBA Data[Home] [Help]

APPS.CE_INTEREST_SCHED_PKG dependencies on STANDARD

Line 47: cep_standard.debug('>> CE_INTEREST_SCHED_PKG.xtr_schedule_update');

43: x_msg_data OUT NOCOPY varchar2
44: ) IS
45: BEGIN
46: IF l_DEBUG in ('Y', 'C') THEN
47: cep_standard.debug('>> CE_INTEREST_SCHED_PKG.xtr_schedule_update');
48: END IF;
49:
50: IF (p_ce_bank_account_id is not null ) THEN
51:

Line 64: cep_standard.debug('EXCEPTION: CE_INTEREST_SCHED_PKG.xtr_schedule_update p_ce_bank_account_id missing');

60: x_msg_data => x_msg_data);
61:
62: ELSE
63: IF l_DEBUG in ('Y', 'C') THEN
64: cep_standard.debug('EXCEPTION: CE_INTEREST_SCHED_PKG.xtr_schedule_update p_ce_bank_account_id missing');
65: END IF;
66: FND_MESSAGE.Set_Name('CE', 'CE_BANK_ACCOUNT_ID_MISSING');
67: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_SCHED_PKG.xtr_schedule_update');
68: fnd_msg_pub.add;

Line 72: cep_standard.debug('<< CE_INTEREST_SCHED_PKG.xtr_schedule_update');

68: fnd_msg_pub.add;
69: END IF;
70:
71: IF l_DEBUG in ('Y', 'C') THEN
72: cep_standard.debug('<< CE_INTEREST_SCHED_PKG.xtr_schedule_update');
73: END IF;
74:
75: EXCEPTION
76: when others then

Line 78: cep_standard.debug('EXCEPTION: CE_INTEREST_SCHED_PKG.xtr_schedule_update');

74:
75: EXCEPTION
76: when others then
77: IF l_DEBUG in ('Y', 'C') THEN
78: cep_standard.debug('EXCEPTION: CE_INTEREST_SCHED_PKG.xtr_schedule_update');
79: END IF;
80: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
81: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_SCHED_PKG.xtr_schedule_update');
82: fnd_msg_pub.add;

Line 107: cep_standard.debug('>> CE_INTEREST_SCHED_PKG.remove_schedule_account');

103:
104: x_bank_account_id NUMBER;
105: BEGIN
106: IF l_DEBUG in ('Y', 'C') THEN
107: cep_standard.debug('>> CE_INTEREST_SCHED_PKG.remove_schedule_account');
108: END IF;
109: -- initialize API return status to success.
110: x_return_status := fnd_api.g_ret_sts_success;
111:

Line 152: cep_standard.debug('<< CE_INTEREST_SCHED_PKG.remove_schedule_account');

148: END IF;
149:
150:
151: IF l_DEBUG in ('Y', 'C') THEN
152: cep_standard.debug('<< CE_INTEREST_SCHED_PKG.remove_schedule_account');
153: END IF;
154:
155: EXCEPTION
156: when others then

Line 158: cep_standard.debug('EXCEPTION: CE_INTEREST_SCHED_PKG.remove_schedule_account');

154:
155: EXCEPTION
156: when others then
157: IF l_DEBUG in ('Y', 'C') THEN
158: cep_standard.debug('EXCEPTION: CE_INTEREST_SCHED_PKG.remove_schedule_account');
159: END IF;
160: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
161: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_SCHED_PKG.remove_schedule_account');
162: fnd_msg_pub.add;

Line 191: cep_standard.debug('>> CE_INTEREST_SCHED_PKG.assign_schedule_account');

187: x_bank_account_id NUMBER;
188: x_ba_count NUMBER;
189: BEGIN
190: IF l_DEBUG in ('Y', 'C') THEN
191: cep_standard.debug('>> CE_INTEREST_SCHED_PKG.assign_schedule_account');
192: END IF;
193: -- initialize API return status to success.
194: x_return_status := fnd_api.g_ret_sts_success;
195:

Line 233: cep_standard.debug('EXCEPTION: CE_INTEREST_SCHED_PKG.assign_schedule_account INTEREST_SCHEDULE_ID missing');

229:
230: END IF;
231: ELSE
232: IF l_DEBUG in ('Y', 'C') THEN
233: cep_standard.debug('EXCEPTION: CE_INTEREST_SCHED_PKG.assign_schedule_account INTEREST_SCHEDULE_ID missing');
234: END IF;
235: FND_MESSAGE.Set_Name('CE', 'CE_INT_SCHED_ID_MISSING');
236: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_SCHED_PKG.assign_schedule_account');
237: fnd_msg_pub.add;

Line 250: cep_standard.debug('<< CE_INTEREST_SCHED_PKG.assign_schedule_account');

246: x_return_status := fnd_api.g_ret_sts_error;
247: END IF;
248:
249: IF l_DEBUG in ('Y', 'C') THEN
250: cep_standard.debug('<< CE_INTEREST_SCHED_PKG.assign_schedule_account');
251: END IF;
252:
253: EXCEPTION
254: when others then

Line 256: cep_standard.debug('EXCEPTION: CE_INTEREST_SCHED_PKG.assign_schedule_account');

252:
253: EXCEPTION
254: when others then
255: IF l_DEBUG in ('Y', 'C') THEN
256: cep_standard.debug('EXCEPTION: CE_INTEREST_SCHED_PKG.assign_schedule_account');
257: END IF;
258: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
259: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_SCHED_PKG.assign_schedule_account');
260: fnd_msg_pub.add;

Line 281: cep_standard.debug('>> CE_INTEREST_SCHED_PKG.delete_interest_rates');

277: x_bank_account_id NUMBER;
278: x_interest_rate_count NUMBER;
279: BEGIN
280: IF l_DEBUG in ('Y', 'C') THEN
281: cep_standard.debug('>> CE_INTEREST_SCHED_PKG.delete_interest_rates');
282: END IF;
283:
284: IF (p_effective_date is not null) THEN
285: select count(*)

Line 315: cep_standard.debug('<< CE_INTEREST_SCHED_PKG.delete_interest_rates');

311: END IF;
312:
313:
314: IF l_DEBUG in ('Y', 'C') THEN
315: cep_standard.debug('<< CE_INTEREST_SCHED_PKG.delete_interest_rates');
316: END IF;
317:
318: EXCEPTION
319: when others then

Line 321: cep_standard.debug('EXCEPTION: CE_INTEREST_SCHED_PKG.delete_interest_rates');

317:
318: EXCEPTION
319: when others then
320: IF l_DEBUG in ('Y', 'C') THEN
321: cep_standard.debug('EXCEPTION: CE_INTEREST_SCHED_PKG.delete_interest_rates');
322: END IF;
323: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
324: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_SCHED_PKG.delete_interest_rates');
325: fnd_msg_pub.add;

Line 341: cep_standard.debug('>> CE_INTEREST_SCHED_PKG.delete_bal_ranges');

337: --------------------------------------------------------------------- */
338: PROCEDURE delete_bal_ranges( p_interest_schedule_id number) IS
339: BEGIN
340: IF l_DEBUG in ('Y', 'C') THEN
341: cep_standard.debug('>> CE_INTEREST_SCHED_PKG.delete_bal_ranges');
342: END IF;
343:
344: IF (p_interest_schedule_id is not null) THEN
345: DELETE FROM CE_INTEREST_BAL_RANGES

Line 351: cep_standard.debug('<< CE_INTEREST_SCHED_PKG.delete_bal_ranges');

347:
348: END IF;
349:
350: IF l_DEBUG in ('Y', 'C') THEN
351: cep_standard.debug('<< CE_INTEREST_SCHED_PKG.delete_bal_ranges');
352: END IF;
353:
354: EXCEPTION
355: when others then

Line 357: cep_standard.debug('EXCEPTION: CE_INTEREST_SCHED_PKG.delete_bal_ranges');

353:
354: EXCEPTION
355: when others then
356: IF l_DEBUG in ('Y', 'C') THEN
357: cep_standard.debug('EXCEPTION: CE_INTEREST_SCHED_PKG.delete_bal_ranges');
358: END IF;
359: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
360: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_SCHED_PKG.delete_bal_ranges');
361: fnd_msg_pub.add;

Line 384: cep_standard.debug('>> CE_INTEREST_SCHED_PKG.delete_schedule');

380: p_effective_date date ;
381: p_bank_account_id number;
382: BEGIN
383: IF l_DEBUG in ('Y', 'C') THEN
384: cep_standard.debug('>> CE_INTEREST_SCHED_PKG.delete_schedule');
385: END IF;
386: -- initialize API return status to success.
387: x_return_status := fnd_api.g_ret_sts_success;
388:

Line 409: cep_standard.debug('EXCEPTION: CE_INTEREST_SCHED_PKG.delete_schedule INTEREST_SCHEDULE_ID missing');

405: x_msg_data);
406:
407: ELSE
408: IF l_DEBUG in ('Y', 'C') THEN
409: cep_standard.debug('EXCEPTION: CE_INTEREST_SCHED_PKG.delete_schedule INTEREST_SCHEDULE_ID missing');
410: END IF;
411: FND_MESSAGE.Set_Name('CE', 'CE_INT_SCHED_ID_MISSING');
412: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_SCHED_PKG.delete_schedule');
413: fnd_msg_pub.add;

Line 426: cep_standard.debug('<< CE_INTEREST_SCHED_PKG.delete_schedule');

422: x_return_status := fnd_api.g_ret_sts_error;
423: END IF;
424:
425: IF l_DEBUG in ('Y', 'C') THEN
426: cep_standard.debug('<< CE_INTEREST_SCHED_PKG.delete_schedule');
427: END IF;
428:
429: EXCEPTION
430: when others then

Line 432: cep_standard.debug('EXCEPTION: CE_INTEREST_SCHED_PKG.delete_schedule');

428:
429: EXCEPTION
430: when others then
431: IF l_DEBUG in ('Y', 'C') THEN
432: cep_standard.debug('EXCEPTION: CE_INTEREST_SCHED_PKG.delete_schedule');
433: END IF;
434: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
435: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_SCHED_PKG.delete_schedule');
436: fnd_msg_pub.add;

Line 469: cep_standard.debug('>> CE_INTEREST_SCHED_PKG.update_schedule');

465: --X_return_status
466:
467: BEGIN
468: IF l_DEBUG in ('Y', 'C') THEN
469: cep_standard.debug('>> CE_INTEREST_SCHED_PKG.update_schedule');
470: END IF;
471: -- initialize API return status to success.
472: x_return_status := fnd_api.g_ret_sts_success;
473:

Line 515: cep_standard.debug('EXCEPTION: CE_INTEREST_SCHED_PKG.update_schedule INTEREST_SCHEDULE_ID missing');

511:
512: END IF;
513: ELSE
514: IF l_DEBUG in ('Y', 'C') THEN
515: cep_standard.debug('EXCEPTION: CE_INTEREST_SCHED_PKG.update_schedule INTEREST_SCHEDULE_ID missing');
516: END IF;
517: FND_MESSAGE.Set_Name('CE', 'CE_INT_SCHED_ID_MISSING');
518: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_SCHED_PKG.update_schedule');
519: fnd_msg_pub.add;

Line 532: cep_standard.debug('<< CE_INTEREST_SCHED_PKG.update_schedule');

528: x_return_status := fnd_api.g_ret_sts_error;
529: END IF;
530:
531: IF l_DEBUG in ('Y', 'C') THEN
532: cep_standard.debug('<< CE_INTEREST_SCHED_PKG.update_schedule');
533: END IF;
534:
535: EXCEPTION
536: when others then

Line 538: cep_standard.debug('EXCEPTION: CE_INTEREST_SCHED_PKG.update_schedule');

534:
535: EXCEPTION
536: when others then
537: IF l_DEBUG in ('Y', 'C') THEN
538: cep_standard.debug('EXCEPTION: CE_INTEREST_SCHED_PKG.update_schedule');
539: END IF;
540: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
541: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_SCHED_PKG.update_schedule');
542: fnd_msg_pub.add;