DBA Data[Home] [Help]

APPS.CE_INTEREST_SCHED_PKG dependencies on FND_MSG_PUB

Line 68: fnd_msg_pub.add;

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;
69: END IF;
70:
71: IF l_DEBUG in ('Y', 'C') THEN
72: cep_standard.debug('<< CE_INTEREST_SCHED_PKG.xtr_schedule_update');

Line 82: fnd_msg_pub.add;

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;
83: END xtr_schedule_update;
84:
85: /* --------------------------------------------------------------------
86: | PRIVATE PROCEDURE |

Line 141: FND_MSG_PUB.Count_And_Get(

137: x_msg_data => x_msg_data);
138: END LOOP; -- SCHED_XTR_ACCTS
139: CLOSE SCHED_XTR_ACCTS;
140: END IF;
141: FND_MSG_PUB.Count_And_Get(
142: p_encoded => FND_API.G_FALSE,
143: p_count => x_msg_count,
144: p_data => x_msg_data);
145:

Line 162: fnd_msg_pub.add;

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;
163: END remove_schedule_account;
164:
165: /* --------------------------------------------------------------------
166: | PRIVATE PROCEDURE |

Line 207: fnd_msg_pub.add;

203:
204: IF (x_ba_count > 0) THEN
205: FND_MESSAGE.Set_Name('CE', 'CE_ACCT_IS_ASSIGNED');
206: --FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_SCHED_PKG.assign_schedule_account');
207: fnd_msg_pub.add;
208: ELSE
209: UPDATE CE_BANK_ACCOUNTS
210: SET INTEREST_SCHEDULE_ID = p_interest_schedule_id
211: WHERE INTEREST_SCHEDULE_ID is null

Line 237: fnd_msg_pub.add;

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;
238: END IF;
239:
240: FND_MSG_PUB.Count_And_Get(
241: p_encoded => FND_API.G_FALSE,

Line 240: FND_MSG_PUB.Count_And_Get(

236: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_SCHED_PKG.assign_schedule_account');
237: fnd_msg_pub.add;
238: END IF;
239:
240: FND_MSG_PUB.Count_And_Get(
241: p_encoded => FND_API.G_FALSE,
242: p_count => x_msg_count,
243: p_data => x_msg_data);
244:

Line 260: fnd_msg_pub.add;

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;
261: END assign_schedule_account;
262:
263: /* --------------------------------------------------------------------
264: | PRIVATE PROCEDURE |

Line 297: fnd_msg_pub.add;

293: IF (x_interest_rate_count < 1) THEN
294:
295: FND_MESSAGE.Set_Name('CE', 'CE_INT_RATE_DATE_NOT_EXIST');
296: FND_MESSAGE.Set_Token('EFFECTIVE_DATE',p_effective_date );
297: fnd_msg_pub.add;
298: END IF;
299: END IF;
300: IF (p_interest_schedule_id is not null and p_effective_date is not null) THEN
301: DELETE FROM CE_INTEREST_RATES

Line 325: fnd_msg_pub.add;

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;
326: END delete_interest_rates;
327: /* --------------------------------------------------------------------
328: | PRIVATE PROCEDURE |
329: | delete_bal_ranges;

Line 361: fnd_msg_pub.add;

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;
362: END delete_bal_ranges;
363:
364: /* --------------------------------------------------------------------
365: | PRIVATE PROCEDURE |

Line 413: fnd_msg_pub.add;

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;
414: END IF;
415:
416: FND_MSG_PUB.Count_And_Get(
417: p_encoded => FND_API.G_FALSE,

Line 416: FND_MSG_PUB.Count_And_Get(

412: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_SCHED_PKG.delete_schedule');
413: fnd_msg_pub.add;
414: END IF;
415:
416: FND_MSG_PUB.Count_And_Get(
417: p_encoded => FND_API.G_FALSE,
418: p_count => x_msg_count,
419: p_data => x_msg_data);
420:

Line 436: fnd_msg_pub.add;

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;
437: END delete_schedule;
438:
439: /* --------------------------------------------------------------------
440: | PRIVATE PROCEDURE |

Line 519: fnd_msg_pub.add;

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;
520: END IF;
521:
522: FND_MSG_PUB.Count_And_Get(
523: p_encoded => FND_API.G_FALSE,

Line 522: FND_MSG_PUB.Count_And_Get(

518: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_SCHED_PKG.update_schedule');
519: fnd_msg_pub.add;
520: END IF;
521:
522: FND_MSG_PUB.Count_And_Get(
523: p_encoded => FND_API.G_FALSE,
524: p_count => x_msg_count,
525: p_data => x_msg_data);
526:

Line 542: fnd_msg_pub.add;

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;
543: END update_schedule;
544:
545: END CE_INTEREST_SCHED_PKG;