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.

[Home] [Help]

APPS.CN_RT_QUOTA_ASGN_PVT dependencies on FND_API

Line 159: x_return_status := fnd_api.g_ret_sts_success;

155: l_old_rt_name VARCHAR2 (200);
156:
157: BEGIN
158: -- Initialize to success
159: x_return_status := fnd_api.g_ret_sts_success;
160: -- Initialize other fields
161: x_msg_data := fnd_api.g_null_char;
162: x_msg_count := fnd_api.g_null_num;
163: -- Getting the rate table name

Line 161: x_msg_data := fnd_api.g_null_char;

157: BEGIN
158: -- Initialize to success
159: x_return_status := fnd_api.g_ret_sts_success;
160: -- Initialize other fields
161: x_msg_data := fnd_api.g_null_char;
162: x_msg_count := fnd_api.g_null_num;
163: -- Getting the rate table name
164: SELECT NAME INTO l_temp_old
165: FROM CN_RATE_SCHEDULES

Line 162: x_msg_count := fnd_api.g_null_num;

158: -- Initialize to success
159: x_return_status := fnd_api.g_ret_sts_success;
160: -- Initialize other fields
161: x_msg_data := fnd_api.g_null_char;
162: x_msg_count := fnd_api.g_null_num;
163: -- Getting the rate table name
164: SELECT NAME INTO l_temp_old
165: FROM CN_RATE_SCHEDULES
166: WHERE RATE_SCHEDULE_ID = p_rt_quota_asgn.rate_schedule_id

Line 216: WHEN fnd_api.g_exc_error

212: p_note_type => 'CN_SYSGEN', -- for system generated
213: x_jtf_note_id => l_note_id -- returned
214: );
215: EXCEPTION
216: WHEN fnd_api.g_exc_error
217: THEN
218: x_return_status := fnd_api.g_ret_sts_error;
219: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
220: WHEN fnd_api.g_exc_unexpected_error

Line 218: x_return_status := fnd_api.g_ret_sts_error;

214: );
215: EXCEPTION
216: WHEN fnd_api.g_exc_error
217: THEN
218: x_return_status := fnd_api.g_ret_sts_error;
219: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
220: WHEN fnd_api.g_exc_unexpected_error
221: THEN
222: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 219: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

215: EXCEPTION
216: WHEN fnd_api.g_exc_error
217: THEN
218: x_return_status := fnd_api.g_ret_sts_error;
219: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
220: WHEN fnd_api.g_exc_unexpected_error
221: THEN
222: x_return_status := fnd_api.g_ret_sts_unexp_error;
223: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 220: WHEN fnd_api.g_exc_unexpected_error

216: WHEN fnd_api.g_exc_error
217: THEN
218: x_return_status := fnd_api.g_ret_sts_error;
219: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
220: WHEN fnd_api.g_exc_unexpected_error
221: THEN
222: x_return_status := fnd_api.g_ret_sts_unexp_error;
223: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
224: WHEN OTHERS

Line 222: x_return_status := fnd_api.g_ret_sts_unexp_error;

218: x_return_status := fnd_api.g_ret_sts_error;
219: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
220: WHEN fnd_api.g_exc_unexpected_error
221: THEN
222: x_return_status := fnd_api.g_ret_sts_unexp_error;
223: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
224: WHEN OTHERS
225: THEN
226: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 223: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

219: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
220: WHEN fnd_api.g_exc_unexpected_error
221: THEN
222: x_return_status := fnd_api.g_ret_sts_unexp_error;
223: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
224: WHEN OTHERS
225: THEN
226: x_return_status := fnd_api.g_ret_sts_unexp_error;
227: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

Line 226: x_return_status := fnd_api.g_ret_sts_unexp_error;

222: x_return_status := fnd_api.g_ret_sts_unexp_error;
223: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
224: WHEN OTHERS
225: THEN
226: x_return_status := fnd_api.g_ret_sts_unexp_error;
227: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
228: THEN
229: fnd_msg_pub.add_exc_msg (g_pkg_name, 'add_system_note');
230: END IF;

Line 231: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

227: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
228: THEN
229: fnd_msg_pub.add_exc_msg (g_pkg_name, 'add_system_note');
230: END IF;
231: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
232:
233: END add_system_note;
234:
235: -- Start of comments

Line 243: -- Default = FND_API.G_FALSE

239: -- Pre-reqs : None.
240: -- Parameters :
241: -- IN : p_api_version IN NUMBER Required
242: -- p_init_msg_list IN VARCHAR2 Optional
243: -- Default = FND_API.G_FALSE
244: -- p_commit IN VARCHAR2 Optional
245: -- Default = FND_API.G_FALSE
246: -- p_validation_level IN NUMBER Optional
247: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 245: -- Default = FND_API.G_FALSE

241: -- IN : p_api_version IN NUMBER Required
242: -- p_init_msg_list IN VARCHAR2 Optional
243: -- Default = FND_API.G_FALSE
244: -- p_commit IN VARCHAR2 Optional
245: -- Default = FND_API.G_FALSE
246: -- p_validation_level IN NUMBER Optional
247: -- Default = FND_API.G_VALID_LEVEL_FULL
248: -- p_rt_quota_asgn IN rt_quota_asgn_rec_type
249: -- OUT : x_return_status OUT VARCHAR2(1)

Line 247: -- Default = FND_API.G_VALID_LEVEL_FULL

243: -- Default = FND_API.G_FALSE
244: -- p_commit IN VARCHAR2 Optional
245: -- Default = FND_API.G_FALSE
246: -- p_validation_level IN NUMBER Optional
247: -- Default = FND_API.G_VALID_LEVEL_FULL
248: -- p_rt_quota_asgn IN rt_quota_asgn_rec_type
249: -- OUT : x_return_status OUT VARCHAR2(1)
250: -- x_msg_count OUT NUMBER
251: -- x_msg_data OUT VARCHAR2(2000)

Line 259: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

255: --
256: -- End of comments
257: PROCEDURE create_rate_table_assignment (
258: p_api_version IN NUMBER,
259: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
260: p_commit IN VARCHAR2 := fnd_api.g_false,
261: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
262: p_rt_quota_asgn IN OUT NOCOPY rt_quota_asgn_rec_type,
263: x_return_status OUT NOCOPY VARCHAR2,

Line 260: p_commit IN VARCHAR2 := fnd_api.g_false,

256: -- End of comments
257: PROCEDURE create_rate_table_assignment (
258: p_api_version IN NUMBER,
259: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
260: p_commit IN VARCHAR2 := fnd_api.g_false,
261: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
262: p_rt_quota_asgn IN OUT NOCOPY rt_quota_asgn_rec_type,
263: x_return_status OUT NOCOPY VARCHAR2,
264: x_msg_count OUT NOCOPY NUMBER,

Line 261: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

257: PROCEDURE create_rate_table_assignment (
258: p_api_version IN NUMBER,
259: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
260: p_commit IN VARCHAR2 := fnd_api.g_false,
261: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
262: p_rt_quota_asgn IN OUT NOCOPY rt_quota_asgn_rec_type,
263: x_return_status OUT NOCOPY VARCHAR2,
264: x_msg_count OUT NOCOPY NUMBER,
265: x_msg_data OUT NOCOPY VARCHAR2

Line 309: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

305: -- Standard Start of API savepoint
306: SAVEPOINT create_rt_quota_asgn;
307:
308: -- Standard call to check for call compatibility.
309: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
310: THEN
311: RAISE fnd_api.g_exc_unexpected_error;
312: END IF;
313:

Line 311: RAISE fnd_api.g_exc_unexpected_error;

307:
308: -- Standard call to check for call compatibility.
309: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
310: THEN
311: RAISE fnd_api.g_exc_unexpected_error;
312: END IF;
313:
314: -- Initialize message list if p_init_msg_list is set to TRUE.
315: IF fnd_api.to_boolean (p_init_msg_list)

Line 315: IF fnd_api.to_boolean (p_init_msg_list)

311: RAISE fnd_api.g_exc_unexpected_error;
312: END IF;
313:
314: -- Initialize message list if p_init_msg_list is set to TRUE.
315: IF fnd_api.to_boolean (p_init_msg_list)
316: THEN
317: fnd_msg_pub.initialize;
318: END IF;
319:

Line 321: x_return_status := fnd_api.g_ret_sts_success;

317: fnd_msg_pub.initialize;
318: END IF;
319:
320: -- Initialize API return status to success
321: x_return_status := fnd_api.g_ret_sts_success;
322:
323: -- API body
324: SELECT NULL,
325: fnd_global.user_id,

Line 349: IF x_return_status <> fnd_api.g_ret_sts_success

345: x_msg_count => x_msg_count,
346: x_msg_data => x_msg_data
347: );
348:
349: IF x_return_status <> fnd_api.g_ret_sts_success
350: THEN
351: RAISE fnd_api.g_exc_error;
352: END IF;
353:

Line 351: RAISE fnd_api.g_exc_error;

347: );
348:
349: IF x_return_status <> fnd_api.g_ret_sts_success
350: THEN
351: RAISE fnd_api.g_exc_error;
352: END IF;
353:
354: cn_rt_quota_asgns_pkg.begin_record (x_org_id => p_rt_quota_asgn.org_id,
355: x_operation => 'INSERT',

Line 397: IF (x_return_status <> fnd_api.g_ret_sts_success)

393: x_return_status,
394: x_msg_count,
395: x_msg_data
396: );
397: IF (x_return_status <> fnd_api.g_ret_sts_success)
398: THEN
399: RAISE fnd_api.g_exc_error;
400: END IF;
401:

Line 399: RAISE fnd_api.g_exc_error;

395: x_msg_data
396: );
397: IF (x_return_status <> fnd_api.g_ret_sts_success)
398: THEN
399: RAISE fnd_api.g_exc_error;
400: END IF;
401:
402:
403:

Line 406: IF fnd_api.to_boolean (p_commit)

402:
403:
404: -- End of API body.
405: -- Standard check of p_commit.
406: IF fnd_api.to_boolean (p_commit)
407: THEN
408: COMMIT WORK;
409: END IF;
410:

Line 412: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

408: COMMIT WORK;
409: END IF;
410:
411: -- Standard call to get message count and if count is 1, get message info.
412: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
413: EXCEPTION
414: WHEN fnd_api.g_exc_error
415: THEN
416: ROLLBACK TO create_rt_quota_asgn;

Line 414: WHEN fnd_api.g_exc_error

410:
411: -- Standard call to get message count and if count is 1, get message info.
412: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
413: EXCEPTION
414: WHEN fnd_api.g_exc_error
415: THEN
416: ROLLBACK TO create_rt_quota_asgn;
417: x_return_status := fnd_api.g_ret_sts_error;
418: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 417: x_return_status := fnd_api.g_ret_sts_error;

413: EXCEPTION
414: WHEN fnd_api.g_exc_error
415: THEN
416: ROLLBACK TO create_rt_quota_asgn;
417: x_return_status := fnd_api.g_ret_sts_error;
418: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
419: WHEN fnd_api.g_exc_unexpected_error
420: THEN
421: ROLLBACK TO create_rt_quota_asgn;

Line 418: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

414: WHEN fnd_api.g_exc_error
415: THEN
416: ROLLBACK TO create_rt_quota_asgn;
417: x_return_status := fnd_api.g_ret_sts_error;
418: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
419: WHEN fnd_api.g_exc_unexpected_error
420: THEN
421: ROLLBACK TO create_rt_quota_asgn;
422: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 419: WHEN fnd_api.g_exc_unexpected_error

415: THEN
416: ROLLBACK TO create_rt_quota_asgn;
417: x_return_status := fnd_api.g_ret_sts_error;
418: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
419: WHEN fnd_api.g_exc_unexpected_error
420: THEN
421: ROLLBACK TO create_rt_quota_asgn;
422: x_return_status := fnd_api.g_ret_sts_unexp_error;
423: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 422: x_return_status := fnd_api.g_ret_sts_unexp_error;

418: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
419: WHEN fnd_api.g_exc_unexpected_error
420: THEN
421: ROLLBACK TO create_rt_quota_asgn;
422: x_return_status := fnd_api.g_ret_sts_unexp_error;
423: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
424: WHEN OTHERS
425: THEN
426: ROLLBACK TO create_rt_quota_asgn;

Line 423: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

419: WHEN fnd_api.g_exc_unexpected_error
420: THEN
421: ROLLBACK TO create_rt_quota_asgn;
422: x_return_status := fnd_api.g_ret_sts_unexp_error;
423: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
424: WHEN OTHERS
425: THEN
426: ROLLBACK TO create_rt_quota_asgn;
427: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 427: x_return_status := fnd_api.g_ret_sts_unexp_error;

423: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
424: WHEN OTHERS
425: THEN
426: ROLLBACK TO create_rt_quota_asgn;
427: x_return_status := fnd_api.g_ret_sts_unexp_error;
428:
429: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
430: THEN
431: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 434: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

430: THEN
431: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
432: END IF;
433:
434: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
435: END create_rate_table_assignment;
436:
437: -- Start of comments
438: -- API name : Update_Rt_Quota_Asgn

Line 445: -- Default = FND_API.G_FALSE

441: -- Pre-reqs : None.
442: -- Parameters :
443: -- IN : p_api_version IN NUMBER Required
444: -- p_init_msg_list IN VARCHAR2 Optional
445: -- Default = FND_API.G_FALSE
446: -- p_commit IN VARCHAR2 Optional
447: -- Default = FND_API.G_FALSE
448: -- p_validation_level IN NUMBER Optional
449: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 447: -- Default = FND_API.G_FALSE

443: -- IN : p_api_version IN NUMBER Required
444: -- p_init_msg_list IN VARCHAR2 Optional
445: -- Default = FND_API.G_FALSE
446: -- p_commit IN VARCHAR2 Optional
447: -- Default = FND_API.G_FALSE
448: -- p_validation_level IN NUMBER Optional
449: -- Default = FND_API.G_VALID_LEVEL_FULL
450: -- p_rt_quota_asgn IN rt_quota_asgn_rec_type
451: -- OUT : x_return_status OUT VARCHAR2(1)

Line 449: -- Default = FND_API.G_VALID_LEVEL_FULL

445: -- Default = FND_API.G_FALSE
446: -- p_commit IN VARCHAR2 Optional
447: -- Default = FND_API.G_FALSE
448: -- p_validation_level IN NUMBER Optional
449: -- Default = FND_API.G_VALID_LEVEL_FULL
450: -- p_rt_quota_asgn IN rt_quota_asgn_rec_type
451: -- OUT : x_return_status OUT VARCHAR2(1)
452: -- x_msg_count OUT NUMBER
453: -- x_msg_data OUT VARCHAR2(2000)

Line 460: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

456: --
457: -- End of comments
458: PROCEDURE update_rate_table_assignment (
459: p_api_version IN NUMBER,
460: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
461: p_commit IN VARCHAR2 := fnd_api.g_false,
462: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
463: p_rt_quota_asgn IN OUT NOCOPY rt_quota_asgn_rec_type,
464: x_return_status OUT NOCOPY VARCHAR2,

Line 461: p_commit IN VARCHAR2 := fnd_api.g_false,

457: -- End of comments
458: PROCEDURE update_rate_table_assignment (
459: p_api_version IN NUMBER,
460: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
461: p_commit IN VARCHAR2 := fnd_api.g_false,
462: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
463: p_rt_quota_asgn IN OUT NOCOPY rt_quota_asgn_rec_type,
464: x_return_status OUT NOCOPY VARCHAR2,
465: x_msg_count OUT NOCOPY NUMBER,

Line 462: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

458: PROCEDURE update_rate_table_assignment (
459: p_api_version IN NUMBER,
460: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
461: p_commit IN VARCHAR2 := fnd_api.g_false,
462: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
463: p_rt_quota_asgn IN OUT NOCOPY rt_quota_asgn_rec_type,
464: x_return_status OUT NOCOPY VARCHAR2,
465: x_msg_count OUT NOCOPY NUMBER,
466: x_msg_data OUT NOCOPY VARCHAR2

Line 521: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

517: -- Standard Start of API savepoint
518: SAVEPOINT update_rt_quota_asgn;
519:
520: -- Standard call to check for call compatibility.
521: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
522: THEN
523: RAISE fnd_api.g_exc_unexpected_error;
524: END IF;
525:

Line 523: RAISE fnd_api.g_exc_unexpected_error;

519:
520: -- Standard call to check for call compatibility.
521: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
522: THEN
523: RAISE fnd_api.g_exc_unexpected_error;
524: END IF;
525:
526: -- Initialize message list if p_init_msg_list is set to TRUE.
527: IF fnd_api.to_boolean (p_init_msg_list)

Line 527: IF fnd_api.to_boolean (p_init_msg_list)

523: RAISE fnd_api.g_exc_unexpected_error;
524: END IF;
525:
526: -- Initialize message list if p_init_msg_list is set to TRUE.
527: IF fnd_api.to_boolean (p_init_msg_list)
528: THEN
529: fnd_msg_pub.initialize;
530: END IF;
531:

Line 533: x_return_status := fnd_api.g_ret_sts_success;

529: fnd_msg_pub.initialize;
530: END IF;
531:
532: -- Initialize API return status to success
533: x_return_status := fnd_api.g_ret_sts_success;
534:
535: -- API body
536: OPEN l_old_rt_quota_asgn_cr;
537:

Line 543: SELECT DECODE (p_rt_quota_asgn.org_id, fnd_api.g_miss_num, l_old_rt_quota_asgn.org_id, p_rt_quota_asgn.org_id),

539: INTO l_old_rt_quota_asgn;
540:
541: CLOSE l_old_rt_quota_asgn_cr;
542:
543: SELECT DECODE (p_rt_quota_asgn.org_id, fnd_api.g_miss_num, l_old_rt_quota_asgn.org_id, p_rt_quota_asgn.org_id),
544: DECODE (p_rt_quota_asgn.rt_quota_asgn_id, fnd_api.g_miss_num, l_old_rt_quota_asgn.rt_quota_asgn_id, p_rt_quota_asgn.rt_quota_asgn_id),
545: DECODE (p_rt_quota_asgn.quota_id, fnd_api.g_miss_num, l_old_rt_quota_asgn.quota_id, p_rt_quota_asgn.quota_id),
546: DECODE (p_rt_quota_asgn.start_date, fnd_api.g_miss_date, TRUNC (l_old_rt_quota_asgn.start_date), TRUNC (p_rt_quota_asgn.start_date)),
547: DECODE (p_rt_quota_asgn.end_date, fnd_api.g_miss_date, TRUNC (l_old_rt_quota_asgn.end_date), TRUNC (p_rt_quota_asgn.end_date)),

Line 544: DECODE (p_rt_quota_asgn.rt_quota_asgn_id, fnd_api.g_miss_num, l_old_rt_quota_asgn.rt_quota_asgn_id, p_rt_quota_asgn.rt_quota_asgn_id),

540:
541: CLOSE l_old_rt_quota_asgn_cr;
542:
543: SELECT DECODE (p_rt_quota_asgn.org_id, fnd_api.g_miss_num, l_old_rt_quota_asgn.org_id, p_rt_quota_asgn.org_id),
544: DECODE (p_rt_quota_asgn.rt_quota_asgn_id, fnd_api.g_miss_num, l_old_rt_quota_asgn.rt_quota_asgn_id, p_rt_quota_asgn.rt_quota_asgn_id),
545: DECODE (p_rt_quota_asgn.quota_id, fnd_api.g_miss_num, l_old_rt_quota_asgn.quota_id, p_rt_quota_asgn.quota_id),
546: DECODE (p_rt_quota_asgn.start_date, fnd_api.g_miss_date, TRUNC (l_old_rt_quota_asgn.start_date), TRUNC (p_rt_quota_asgn.start_date)),
547: DECODE (p_rt_quota_asgn.end_date, fnd_api.g_miss_date, TRUNC (l_old_rt_quota_asgn.end_date), TRUNC (p_rt_quota_asgn.end_date)),
548: DECODE (p_rt_quota_asgn.rate_schedule_id, fnd_api.g_miss_num, l_old_rt_quota_asgn.rate_schedule_id, p_rt_quota_asgn.rate_schedule_id),

Line 545: DECODE (p_rt_quota_asgn.quota_id, fnd_api.g_miss_num, l_old_rt_quota_asgn.quota_id, p_rt_quota_asgn.quota_id),

541: CLOSE l_old_rt_quota_asgn_cr;
542:
543: SELECT DECODE (p_rt_quota_asgn.org_id, fnd_api.g_miss_num, l_old_rt_quota_asgn.org_id, p_rt_quota_asgn.org_id),
544: DECODE (p_rt_quota_asgn.rt_quota_asgn_id, fnd_api.g_miss_num, l_old_rt_quota_asgn.rt_quota_asgn_id, p_rt_quota_asgn.rt_quota_asgn_id),
545: DECODE (p_rt_quota_asgn.quota_id, fnd_api.g_miss_num, l_old_rt_quota_asgn.quota_id, p_rt_quota_asgn.quota_id),
546: DECODE (p_rt_quota_asgn.start_date, fnd_api.g_miss_date, TRUNC (l_old_rt_quota_asgn.start_date), TRUNC (p_rt_quota_asgn.start_date)),
547: DECODE (p_rt_quota_asgn.end_date, fnd_api.g_miss_date, TRUNC (l_old_rt_quota_asgn.end_date), TRUNC (p_rt_quota_asgn.end_date)),
548: DECODE (p_rt_quota_asgn.rate_schedule_id, fnd_api.g_miss_num, l_old_rt_quota_asgn.rate_schedule_id, p_rt_quota_asgn.rate_schedule_id),
549: DECODE (p_rt_quota_asgn.calc_formula_id, fnd_api.g_miss_num, l_old_rt_quota_asgn.calc_formula_id, p_rt_quota_asgn.calc_formula_id),

Line 546: DECODE (p_rt_quota_asgn.start_date, fnd_api.g_miss_date, TRUNC (l_old_rt_quota_asgn.start_date), TRUNC (p_rt_quota_asgn.start_date)),

542:
543: SELECT DECODE (p_rt_quota_asgn.org_id, fnd_api.g_miss_num, l_old_rt_quota_asgn.org_id, p_rt_quota_asgn.org_id),
544: DECODE (p_rt_quota_asgn.rt_quota_asgn_id, fnd_api.g_miss_num, l_old_rt_quota_asgn.rt_quota_asgn_id, p_rt_quota_asgn.rt_quota_asgn_id),
545: DECODE (p_rt_quota_asgn.quota_id, fnd_api.g_miss_num, l_old_rt_quota_asgn.quota_id, p_rt_quota_asgn.quota_id),
546: DECODE (p_rt_quota_asgn.start_date, fnd_api.g_miss_date, TRUNC (l_old_rt_quota_asgn.start_date), TRUNC (p_rt_quota_asgn.start_date)),
547: DECODE (p_rt_quota_asgn.end_date, fnd_api.g_miss_date, TRUNC (l_old_rt_quota_asgn.end_date), TRUNC (p_rt_quota_asgn.end_date)),
548: DECODE (p_rt_quota_asgn.rate_schedule_id, fnd_api.g_miss_num, l_old_rt_quota_asgn.rate_schedule_id, p_rt_quota_asgn.rate_schedule_id),
549: DECODE (p_rt_quota_asgn.calc_formula_id, fnd_api.g_miss_num, l_old_rt_quota_asgn.calc_formula_id, p_rt_quota_asgn.calc_formula_id),
550: DECODE (p_rt_quota_asgn.attribute_category,

Line 547: DECODE (p_rt_quota_asgn.end_date, fnd_api.g_miss_date, TRUNC (l_old_rt_quota_asgn.end_date), TRUNC (p_rt_quota_asgn.end_date)),

543: SELECT DECODE (p_rt_quota_asgn.org_id, fnd_api.g_miss_num, l_old_rt_quota_asgn.org_id, p_rt_quota_asgn.org_id),
544: DECODE (p_rt_quota_asgn.rt_quota_asgn_id, fnd_api.g_miss_num, l_old_rt_quota_asgn.rt_quota_asgn_id, p_rt_quota_asgn.rt_quota_asgn_id),
545: DECODE (p_rt_quota_asgn.quota_id, fnd_api.g_miss_num, l_old_rt_quota_asgn.quota_id, p_rt_quota_asgn.quota_id),
546: DECODE (p_rt_quota_asgn.start_date, fnd_api.g_miss_date, TRUNC (l_old_rt_quota_asgn.start_date), TRUNC (p_rt_quota_asgn.start_date)),
547: DECODE (p_rt_quota_asgn.end_date, fnd_api.g_miss_date, TRUNC (l_old_rt_quota_asgn.end_date), TRUNC (p_rt_quota_asgn.end_date)),
548: DECODE (p_rt_quota_asgn.rate_schedule_id, fnd_api.g_miss_num, l_old_rt_quota_asgn.rate_schedule_id, p_rt_quota_asgn.rate_schedule_id),
549: DECODE (p_rt_quota_asgn.calc_formula_id, fnd_api.g_miss_num, l_old_rt_quota_asgn.calc_formula_id, p_rt_quota_asgn.calc_formula_id),
550: DECODE (p_rt_quota_asgn.attribute_category,
551: fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute_category,

Line 548: DECODE (p_rt_quota_asgn.rate_schedule_id, fnd_api.g_miss_num, l_old_rt_quota_asgn.rate_schedule_id, p_rt_quota_asgn.rate_schedule_id),

544: DECODE (p_rt_quota_asgn.rt_quota_asgn_id, fnd_api.g_miss_num, l_old_rt_quota_asgn.rt_quota_asgn_id, p_rt_quota_asgn.rt_quota_asgn_id),
545: DECODE (p_rt_quota_asgn.quota_id, fnd_api.g_miss_num, l_old_rt_quota_asgn.quota_id, p_rt_quota_asgn.quota_id),
546: DECODE (p_rt_quota_asgn.start_date, fnd_api.g_miss_date, TRUNC (l_old_rt_quota_asgn.start_date), TRUNC (p_rt_quota_asgn.start_date)),
547: DECODE (p_rt_quota_asgn.end_date, fnd_api.g_miss_date, TRUNC (l_old_rt_quota_asgn.end_date), TRUNC (p_rt_quota_asgn.end_date)),
548: DECODE (p_rt_quota_asgn.rate_schedule_id, fnd_api.g_miss_num, l_old_rt_quota_asgn.rate_schedule_id, p_rt_quota_asgn.rate_schedule_id),
549: DECODE (p_rt_quota_asgn.calc_formula_id, fnd_api.g_miss_num, l_old_rt_quota_asgn.calc_formula_id, p_rt_quota_asgn.calc_formula_id),
550: DECODE (p_rt_quota_asgn.attribute_category,
551: fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute_category,
552: p_rt_quota_asgn.attribute_category

Line 549: DECODE (p_rt_quota_asgn.calc_formula_id, fnd_api.g_miss_num, l_old_rt_quota_asgn.calc_formula_id, p_rt_quota_asgn.calc_formula_id),

545: DECODE (p_rt_quota_asgn.quota_id, fnd_api.g_miss_num, l_old_rt_quota_asgn.quota_id, p_rt_quota_asgn.quota_id),
546: DECODE (p_rt_quota_asgn.start_date, fnd_api.g_miss_date, TRUNC (l_old_rt_quota_asgn.start_date), TRUNC (p_rt_quota_asgn.start_date)),
547: DECODE (p_rt_quota_asgn.end_date, fnd_api.g_miss_date, TRUNC (l_old_rt_quota_asgn.end_date), TRUNC (p_rt_quota_asgn.end_date)),
548: DECODE (p_rt_quota_asgn.rate_schedule_id, fnd_api.g_miss_num, l_old_rt_quota_asgn.rate_schedule_id, p_rt_quota_asgn.rate_schedule_id),
549: DECODE (p_rt_quota_asgn.calc_formula_id, fnd_api.g_miss_num, l_old_rt_quota_asgn.calc_formula_id, p_rt_quota_asgn.calc_formula_id),
550: DECODE (p_rt_quota_asgn.attribute_category,
551: fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute_category,
552: p_rt_quota_asgn.attribute_category
553: ),

Line 551: fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute_category,

547: DECODE (p_rt_quota_asgn.end_date, fnd_api.g_miss_date, TRUNC (l_old_rt_quota_asgn.end_date), TRUNC (p_rt_quota_asgn.end_date)),
548: DECODE (p_rt_quota_asgn.rate_schedule_id, fnd_api.g_miss_num, l_old_rt_quota_asgn.rate_schedule_id, p_rt_quota_asgn.rate_schedule_id),
549: DECODE (p_rt_quota_asgn.calc_formula_id, fnd_api.g_miss_num, l_old_rt_quota_asgn.calc_formula_id, p_rt_quota_asgn.calc_formula_id),
550: DECODE (p_rt_quota_asgn.attribute_category,
551: fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute_category,
552: p_rt_quota_asgn.attribute_category
553: ),
554: DECODE (p_rt_quota_asgn.attribute1, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute1, p_rt_quota_asgn.attribute1),
555: DECODE (p_rt_quota_asgn.attribute2, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute2, p_rt_quota_asgn.attribute2),

Line 554: DECODE (p_rt_quota_asgn.attribute1, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute1, p_rt_quota_asgn.attribute1),

550: DECODE (p_rt_quota_asgn.attribute_category,
551: fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute_category,
552: p_rt_quota_asgn.attribute_category
553: ),
554: DECODE (p_rt_quota_asgn.attribute1, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute1, p_rt_quota_asgn.attribute1),
555: DECODE (p_rt_quota_asgn.attribute2, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute2, p_rt_quota_asgn.attribute2),
556: DECODE (p_rt_quota_asgn.attribute3, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute3, p_rt_quota_asgn.attribute3),
557: DECODE (p_rt_quota_asgn.attribute4, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute4, p_rt_quota_asgn.attribute4),
558: DECODE (p_rt_quota_asgn.attribute5, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute5, p_rt_quota_asgn.attribute5),

Line 555: DECODE (p_rt_quota_asgn.attribute2, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute2, p_rt_quota_asgn.attribute2),

551: fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute_category,
552: p_rt_quota_asgn.attribute_category
553: ),
554: DECODE (p_rt_quota_asgn.attribute1, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute1, p_rt_quota_asgn.attribute1),
555: DECODE (p_rt_quota_asgn.attribute2, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute2, p_rt_quota_asgn.attribute2),
556: DECODE (p_rt_quota_asgn.attribute3, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute3, p_rt_quota_asgn.attribute3),
557: DECODE (p_rt_quota_asgn.attribute4, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute4, p_rt_quota_asgn.attribute4),
558: DECODE (p_rt_quota_asgn.attribute5, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute5, p_rt_quota_asgn.attribute5),
559: DECODE (p_rt_quota_asgn.attribute6, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute6, p_rt_quota_asgn.attribute6),

Line 556: DECODE (p_rt_quota_asgn.attribute3, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute3, p_rt_quota_asgn.attribute3),

552: p_rt_quota_asgn.attribute_category
553: ),
554: DECODE (p_rt_quota_asgn.attribute1, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute1, p_rt_quota_asgn.attribute1),
555: DECODE (p_rt_quota_asgn.attribute2, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute2, p_rt_quota_asgn.attribute2),
556: DECODE (p_rt_quota_asgn.attribute3, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute3, p_rt_quota_asgn.attribute3),
557: DECODE (p_rt_quota_asgn.attribute4, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute4, p_rt_quota_asgn.attribute4),
558: DECODE (p_rt_quota_asgn.attribute5, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute5, p_rt_quota_asgn.attribute5),
559: DECODE (p_rt_quota_asgn.attribute6, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute6, p_rt_quota_asgn.attribute6),
560: DECODE (p_rt_quota_asgn.attribute7, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute7, p_rt_quota_asgn.attribute7),

Line 557: DECODE (p_rt_quota_asgn.attribute4, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute4, p_rt_quota_asgn.attribute4),

553: ),
554: DECODE (p_rt_quota_asgn.attribute1, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute1, p_rt_quota_asgn.attribute1),
555: DECODE (p_rt_quota_asgn.attribute2, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute2, p_rt_quota_asgn.attribute2),
556: DECODE (p_rt_quota_asgn.attribute3, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute3, p_rt_quota_asgn.attribute3),
557: DECODE (p_rt_quota_asgn.attribute4, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute4, p_rt_quota_asgn.attribute4),
558: DECODE (p_rt_quota_asgn.attribute5, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute5, p_rt_quota_asgn.attribute5),
559: DECODE (p_rt_quota_asgn.attribute6, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute6, p_rt_quota_asgn.attribute6),
560: DECODE (p_rt_quota_asgn.attribute7, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute7, p_rt_quota_asgn.attribute7),
561: DECODE (p_rt_quota_asgn.attribute8, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute8, p_rt_quota_asgn.attribute8),

Line 558: DECODE (p_rt_quota_asgn.attribute5, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute5, p_rt_quota_asgn.attribute5),

554: DECODE (p_rt_quota_asgn.attribute1, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute1, p_rt_quota_asgn.attribute1),
555: DECODE (p_rt_quota_asgn.attribute2, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute2, p_rt_quota_asgn.attribute2),
556: DECODE (p_rt_quota_asgn.attribute3, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute3, p_rt_quota_asgn.attribute3),
557: DECODE (p_rt_quota_asgn.attribute4, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute4, p_rt_quota_asgn.attribute4),
558: DECODE (p_rt_quota_asgn.attribute5, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute5, p_rt_quota_asgn.attribute5),
559: DECODE (p_rt_quota_asgn.attribute6, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute6, p_rt_quota_asgn.attribute6),
560: DECODE (p_rt_quota_asgn.attribute7, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute7, p_rt_quota_asgn.attribute7),
561: DECODE (p_rt_quota_asgn.attribute8, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute8, p_rt_quota_asgn.attribute8),
562: DECODE (p_rt_quota_asgn.attribute9, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute9, p_rt_quota_asgn.attribute9),

Line 559: DECODE (p_rt_quota_asgn.attribute6, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute6, p_rt_quota_asgn.attribute6),

555: DECODE (p_rt_quota_asgn.attribute2, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute2, p_rt_quota_asgn.attribute2),
556: DECODE (p_rt_quota_asgn.attribute3, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute3, p_rt_quota_asgn.attribute3),
557: DECODE (p_rt_quota_asgn.attribute4, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute4, p_rt_quota_asgn.attribute4),
558: DECODE (p_rt_quota_asgn.attribute5, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute5, p_rt_quota_asgn.attribute5),
559: DECODE (p_rt_quota_asgn.attribute6, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute6, p_rt_quota_asgn.attribute6),
560: DECODE (p_rt_quota_asgn.attribute7, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute7, p_rt_quota_asgn.attribute7),
561: DECODE (p_rt_quota_asgn.attribute8, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute8, p_rt_quota_asgn.attribute8),
562: DECODE (p_rt_quota_asgn.attribute9, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute9, p_rt_quota_asgn.attribute9),
563: DECODE (p_rt_quota_asgn.attribute10, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute10, p_rt_quota_asgn.attribute10),

Line 560: DECODE (p_rt_quota_asgn.attribute7, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute7, p_rt_quota_asgn.attribute7),

556: DECODE (p_rt_quota_asgn.attribute3, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute3, p_rt_quota_asgn.attribute3),
557: DECODE (p_rt_quota_asgn.attribute4, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute4, p_rt_quota_asgn.attribute4),
558: DECODE (p_rt_quota_asgn.attribute5, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute5, p_rt_quota_asgn.attribute5),
559: DECODE (p_rt_quota_asgn.attribute6, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute6, p_rt_quota_asgn.attribute6),
560: DECODE (p_rt_quota_asgn.attribute7, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute7, p_rt_quota_asgn.attribute7),
561: DECODE (p_rt_quota_asgn.attribute8, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute8, p_rt_quota_asgn.attribute8),
562: DECODE (p_rt_quota_asgn.attribute9, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute9, p_rt_quota_asgn.attribute9),
563: DECODE (p_rt_quota_asgn.attribute10, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute10, p_rt_quota_asgn.attribute10),
564: DECODE (p_rt_quota_asgn.attribute11, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute11, p_rt_quota_asgn.attribute11),

Line 561: DECODE (p_rt_quota_asgn.attribute8, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute8, p_rt_quota_asgn.attribute8),

557: DECODE (p_rt_quota_asgn.attribute4, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute4, p_rt_quota_asgn.attribute4),
558: DECODE (p_rt_quota_asgn.attribute5, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute5, p_rt_quota_asgn.attribute5),
559: DECODE (p_rt_quota_asgn.attribute6, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute6, p_rt_quota_asgn.attribute6),
560: DECODE (p_rt_quota_asgn.attribute7, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute7, p_rt_quota_asgn.attribute7),
561: DECODE (p_rt_quota_asgn.attribute8, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute8, p_rt_quota_asgn.attribute8),
562: DECODE (p_rt_quota_asgn.attribute9, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute9, p_rt_quota_asgn.attribute9),
563: DECODE (p_rt_quota_asgn.attribute10, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute10, p_rt_quota_asgn.attribute10),
564: DECODE (p_rt_quota_asgn.attribute11, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute11, p_rt_quota_asgn.attribute11),
565: DECODE (p_rt_quota_asgn.attribute12, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute12, p_rt_quota_asgn.attribute12),

Line 562: DECODE (p_rt_quota_asgn.attribute9, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute9, p_rt_quota_asgn.attribute9),

558: DECODE (p_rt_quota_asgn.attribute5, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute5, p_rt_quota_asgn.attribute5),
559: DECODE (p_rt_quota_asgn.attribute6, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute6, p_rt_quota_asgn.attribute6),
560: DECODE (p_rt_quota_asgn.attribute7, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute7, p_rt_quota_asgn.attribute7),
561: DECODE (p_rt_quota_asgn.attribute8, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute8, p_rt_quota_asgn.attribute8),
562: DECODE (p_rt_quota_asgn.attribute9, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute9, p_rt_quota_asgn.attribute9),
563: DECODE (p_rt_quota_asgn.attribute10, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute10, p_rt_quota_asgn.attribute10),
564: DECODE (p_rt_quota_asgn.attribute11, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute11, p_rt_quota_asgn.attribute11),
565: DECODE (p_rt_quota_asgn.attribute12, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute12, p_rt_quota_asgn.attribute12),
566: DECODE (p_rt_quota_asgn.attribute13, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute13, p_rt_quota_asgn.attribute13),

Line 563: DECODE (p_rt_quota_asgn.attribute10, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute10, p_rt_quota_asgn.attribute10),

559: DECODE (p_rt_quota_asgn.attribute6, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute6, p_rt_quota_asgn.attribute6),
560: DECODE (p_rt_quota_asgn.attribute7, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute7, p_rt_quota_asgn.attribute7),
561: DECODE (p_rt_quota_asgn.attribute8, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute8, p_rt_quota_asgn.attribute8),
562: DECODE (p_rt_quota_asgn.attribute9, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute9, p_rt_quota_asgn.attribute9),
563: DECODE (p_rt_quota_asgn.attribute10, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute10, p_rt_quota_asgn.attribute10),
564: DECODE (p_rt_quota_asgn.attribute11, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute11, p_rt_quota_asgn.attribute11),
565: DECODE (p_rt_quota_asgn.attribute12, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute12, p_rt_quota_asgn.attribute12),
566: DECODE (p_rt_quota_asgn.attribute13, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute13, p_rt_quota_asgn.attribute13),
567: DECODE (p_rt_quota_asgn.attribute14, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute14, p_rt_quota_asgn.attribute14),

Line 564: DECODE (p_rt_quota_asgn.attribute11, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute11, p_rt_quota_asgn.attribute11),

560: DECODE (p_rt_quota_asgn.attribute7, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute7, p_rt_quota_asgn.attribute7),
561: DECODE (p_rt_quota_asgn.attribute8, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute8, p_rt_quota_asgn.attribute8),
562: DECODE (p_rt_quota_asgn.attribute9, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute9, p_rt_quota_asgn.attribute9),
563: DECODE (p_rt_quota_asgn.attribute10, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute10, p_rt_quota_asgn.attribute10),
564: DECODE (p_rt_quota_asgn.attribute11, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute11, p_rt_quota_asgn.attribute11),
565: DECODE (p_rt_quota_asgn.attribute12, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute12, p_rt_quota_asgn.attribute12),
566: DECODE (p_rt_quota_asgn.attribute13, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute13, p_rt_quota_asgn.attribute13),
567: DECODE (p_rt_quota_asgn.attribute14, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute14, p_rt_quota_asgn.attribute14),
568: DECODE (p_rt_quota_asgn.attribute15, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute15, p_rt_quota_asgn.attribute15),

Line 565: DECODE (p_rt_quota_asgn.attribute12, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute12, p_rt_quota_asgn.attribute12),

561: DECODE (p_rt_quota_asgn.attribute8, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute8, p_rt_quota_asgn.attribute8),
562: DECODE (p_rt_quota_asgn.attribute9, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute9, p_rt_quota_asgn.attribute9),
563: DECODE (p_rt_quota_asgn.attribute10, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute10, p_rt_quota_asgn.attribute10),
564: DECODE (p_rt_quota_asgn.attribute11, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute11, p_rt_quota_asgn.attribute11),
565: DECODE (p_rt_quota_asgn.attribute12, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute12, p_rt_quota_asgn.attribute12),
566: DECODE (p_rt_quota_asgn.attribute13, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute13, p_rt_quota_asgn.attribute13),
567: DECODE (p_rt_quota_asgn.attribute14, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute14, p_rt_quota_asgn.attribute14),
568: DECODE (p_rt_quota_asgn.attribute15, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute15, p_rt_quota_asgn.attribute15),
569: fnd_global.user_id,

Line 566: DECODE (p_rt_quota_asgn.attribute13, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute13, p_rt_quota_asgn.attribute13),

562: DECODE (p_rt_quota_asgn.attribute9, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute9, p_rt_quota_asgn.attribute9),
563: DECODE (p_rt_quota_asgn.attribute10, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute10, p_rt_quota_asgn.attribute10),
564: DECODE (p_rt_quota_asgn.attribute11, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute11, p_rt_quota_asgn.attribute11),
565: DECODE (p_rt_quota_asgn.attribute12, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute12, p_rt_quota_asgn.attribute12),
566: DECODE (p_rt_quota_asgn.attribute13, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute13, p_rt_quota_asgn.attribute13),
567: DECODE (p_rt_quota_asgn.attribute14, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute14, p_rt_quota_asgn.attribute14),
568: DECODE (p_rt_quota_asgn.attribute15, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute15, p_rt_quota_asgn.attribute15),
569: fnd_global.user_id,
570: SYSDATE,

Line 567: DECODE (p_rt_quota_asgn.attribute14, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute14, p_rt_quota_asgn.attribute14),

563: DECODE (p_rt_quota_asgn.attribute10, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute10, p_rt_quota_asgn.attribute10),
564: DECODE (p_rt_quota_asgn.attribute11, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute11, p_rt_quota_asgn.attribute11),
565: DECODE (p_rt_quota_asgn.attribute12, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute12, p_rt_quota_asgn.attribute12),
566: DECODE (p_rt_quota_asgn.attribute13, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute13, p_rt_quota_asgn.attribute13),
567: DECODE (p_rt_quota_asgn.attribute14, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute14, p_rt_quota_asgn.attribute14),
568: DECODE (p_rt_quota_asgn.attribute15, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute15, p_rt_quota_asgn.attribute15),
569: fnd_global.user_id,
570: SYSDATE,
571: fnd_global.login_id,

Line 568: DECODE (p_rt_quota_asgn.attribute15, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute15, p_rt_quota_asgn.attribute15),

564: DECODE (p_rt_quota_asgn.attribute11, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute11, p_rt_quota_asgn.attribute11),
565: DECODE (p_rt_quota_asgn.attribute12, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute12, p_rt_quota_asgn.attribute12),
566: DECODE (p_rt_quota_asgn.attribute13, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute13, p_rt_quota_asgn.attribute13),
567: DECODE (p_rt_quota_asgn.attribute14, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute14, p_rt_quota_asgn.attribute14),
568: DECODE (p_rt_quota_asgn.attribute15, fnd_api.g_miss_char, l_old_rt_quota_asgn.attribute15, p_rt_quota_asgn.attribute15),
569: fnd_global.user_id,
570: SYSDATE,
571: fnd_global.login_id,
572: SYSDATE,

Line 615: IF x_return_status <> fnd_api.g_ret_sts_success

611: x_msg_count => x_msg_count,
612: x_msg_data => x_msg_data
613: );
614:
615: IF x_return_status <> fnd_api.g_ret_sts_success
616: THEN
617: RAISE fnd_api.g_exc_error;
618: END IF;
619:

Line 617: RAISE fnd_api.g_exc_error;

613: );
614:
615: IF x_return_status <> fnd_api.g_ret_sts_success
616: THEN
617: RAISE fnd_api.g_exc_error;
618: END IF;
619:
620: -- 3. check object version number
621: IF l_old_rt_quota_asgn.object_version_number <> p_rt_quota_asgn.object_version_number

Line 625: RAISE fnd_api.g_exc_error;

621: IF l_old_rt_quota_asgn.object_version_number <> p_rt_quota_asgn.object_version_number
622: THEN
623: fnd_message.set_name ('CN', 'CN_RECORD_CHANGED');
624: fnd_msg_pub.ADD;
625: RAISE fnd_api.g_exc_error;
626: END IF;
627:
628: cn_rt_quota_asgns_pkg.begin_record (x_org_id => p_rt_quota_asgn.org_id,
629: x_operation => 'UPDATE',

Line 671: IF (x_return_status <> fnd_api.g_ret_sts_success)

667: x_return_status,
668: x_msg_count,
669: x_msg_data
670: );
671: IF (x_return_status <> fnd_api.g_ret_sts_success)
672: THEN
673: RAISE fnd_api.g_exc_error;
674: END IF;
675:

Line 673: RAISE fnd_api.g_exc_error;

669: x_msg_data
670: );
671: IF (x_return_status <> fnd_api.g_ret_sts_success)
672: THEN
673: RAISE fnd_api.g_exc_error;
674: END IF;
675:
676:
677: -- End of API body.

Line 679: IF fnd_api.to_boolean (p_commit)

675:
676:
677: -- End of API body.
678: -- Standard check of p_commit.
679: IF fnd_api.to_boolean (p_commit)
680: THEN
681: COMMIT WORK;
682: END IF;
683:

Line 685: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

681: COMMIT WORK;
682: END IF;
683:
684: -- Standard call to get message count and if count is 1, get message info.
685: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
686: EXCEPTION
687: WHEN fnd_api.g_exc_error
688: THEN
689: ROLLBACK TO update_rt_quota_asgn;

Line 687: WHEN fnd_api.g_exc_error

683:
684: -- Standard call to get message count and if count is 1, get message info.
685: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
686: EXCEPTION
687: WHEN fnd_api.g_exc_error
688: THEN
689: ROLLBACK TO update_rt_quota_asgn;
690: x_return_status := fnd_api.g_ret_sts_error;
691: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 690: x_return_status := fnd_api.g_ret_sts_error;

686: EXCEPTION
687: WHEN fnd_api.g_exc_error
688: THEN
689: ROLLBACK TO update_rt_quota_asgn;
690: x_return_status := fnd_api.g_ret_sts_error;
691: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
692: WHEN fnd_api.g_exc_unexpected_error
693: THEN
694: ROLLBACK TO update_rt_quota_asgn;

Line 691: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

687: WHEN fnd_api.g_exc_error
688: THEN
689: ROLLBACK TO update_rt_quota_asgn;
690: x_return_status := fnd_api.g_ret_sts_error;
691: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
692: WHEN fnd_api.g_exc_unexpected_error
693: THEN
694: ROLLBACK TO update_rt_quota_asgn;
695: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 692: WHEN fnd_api.g_exc_unexpected_error

688: THEN
689: ROLLBACK TO update_rt_quota_asgn;
690: x_return_status := fnd_api.g_ret_sts_error;
691: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
692: WHEN fnd_api.g_exc_unexpected_error
693: THEN
694: ROLLBACK TO update_rt_quota_asgn;
695: x_return_status := fnd_api.g_ret_sts_unexp_error;
696: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 695: x_return_status := fnd_api.g_ret_sts_unexp_error;

691: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
692: WHEN fnd_api.g_exc_unexpected_error
693: THEN
694: ROLLBACK TO update_rt_quota_asgn;
695: x_return_status := fnd_api.g_ret_sts_unexp_error;
696: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
697: WHEN OTHERS
698: THEN
699: ROLLBACK TO update_rt_quota_asgn;

Line 696: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

692: WHEN fnd_api.g_exc_unexpected_error
693: THEN
694: ROLLBACK TO update_rt_quota_asgn;
695: x_return_status := fnd_api.g_ret_sts_unexp_error;
696: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
697: WHEN OTHERS
698: THEN
699: ROLLBACK TO update_rt_quota_asgn;
700: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 700: x_return_status := fnd_api.g_ret_sts_unexp_error;

696: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
697: WHEN OTHERS
698: THEN
699: ROLLBACK TO update_rt_quota_asgn;
700: x_return_status := fnd_api.g_ret_sts_unexp_error;
701:
702: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
703: THEN
704: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 707: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

703: THEN
704: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
705: END IF;
706:
707: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
708: END update_rate_table_assignment;
709:
710: -- Start of comments
711: -- API name : Delete_Rt_Quota_Asgn

Line 718: -- Default = FND_API.G_FALSE

714: -- Pre-reqs : None.
715: -- Parameters :
716: -- IN : p_api_version IN NUMBER Required
717: -- p_init_msg_list IN VARCHAR2 Optional
718: -- Default = FND_API.G_FALSE
719: -- p_commit IN VARCHAR2 Optional
720: -- Default = FND_API.G_FALSE
721: -- p_validation_level IN NUMBER Optional
722: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 720: -- Default = FND_API.G_FALSE

716: -- IN : p_api_version IN NUMBER Required
717: -- p_init_msg_list IN VARCHAR2 Optional
718: -- Default = FND_API.G_FALSE
719: -- p_commit IN VARCHAR2 Optional
720: -- Default = FND_API.G_FALSE
721: -- p_validation_level IN NUMBER Optional
722: -- Default = FND_API.G_VALID_LEVEL_FULL
723: -- p_rt_quota_asgn IN quota_asgn_rec_type
724: -- OUT : x_return_status OUT VARCHAR2(1)

Line 722: -- Default = FND_API.G_VALID_LEVEL_FULL

718: -- Default = FND_API.G_FALSE
719: -- p_commit IN VARCHAR2 Optional
720: -- Default = FND_API.G_FALSE
721: -- p_validation_level IN NUMBER Optional
722: -- Default = FND_API.G_VALID_LEVEL_FULL
723: -- p_rt_quota_asgn IN quota_asgn_rec_type
724: -- OUT : x_return_status OUT VARCHAR2(1)
725: -- x_msg_count OUT NUMBER
726: -- x_msg_data OUT VARCHAR2(2000)

Line 733: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

729: --
730: -- End of comments
731: PROCEDURE delete_rate_table_assignment (
732: p_api_version IN NUMBER,
733: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
734: p_commit IN VARCHAR2 := fnd_api.g_false,
735: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
736: p_rt_quota_asgn IN OUT NOCOPY rt_quota_asgn_rec_type,
737: x_return_status OUT NOCOPY VARCHAR2,

Line 734: p_commit IN VARCHAR2 := fnd_api.g_false,

730: -- End of comments
731: PROCEDURE delete_rate_table_assignment (
732: p_api_version IN NUMBER,
733: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
734: p_commit IN VARCHAR2 := fnd_api.g_false,
735: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
736: p_rt_quota_asgn IN OUT NOCOPY rt_quota_asgn_rec_type,
737: x_return_status OUT NOCOPY VARCHAR2,
738: x_msg_count OUT NOCOPY NUMBER,

Line 735: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

731: PROCEDURE delete_rate_table_assignment (
732: p_api_version IN NUMBER,
733: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
734: p_commit IN VARCHAR2 := fnd_api.g_false,
735: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
736: p_rt_quota_asgn IN OUT NOCOPY rt_quota_asgn_rec_type,
737: x_return_status OUT NOCOPY VARCHAR2,
738: x_msg_count OUT NOCOPY NUMBER,
739: x_msg_data OUT NOCOPY VARCHAR2

Line 788: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

784: -- Standard Start of API savepoint
785: SAVEPOINT delete_rt_quota_asgn;
786:
787: -- Standard call to check for call compatibility.
788: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
789: THEN
790: RAISE fnd_api.g_exc_unexpected_error;
791: END IF;
792:

Line 790: RAISE fnd_api.g_exc_unexpected_error;

786:
787: -- Standard call to check for call compatibility.
788: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
789: THEN
790: RAISE fnd_api.g_exc_unexpected_error;
791: END IF;
792:
793: -- Initialize message list if p_init_msg_list is set to TRUE.
794: IF fnd_api.to_boolean (p_init_msg_list)

Line 794: IF fnd_api.to_boolean (p_init_msg_list)

790: RAISE fnd_api.g_exc_unexpected_error;
791: END IF;
792:
793: -- Initialize message list if p_init_msg_list is set to TRUE.
794: IF fnd_api.to_boolean (p_init_msg_list)
795: THEN
796: fnd_msg_pub.initialize;
797: END IF;
798:

Line 800: x_return_status := fnd_api.g_ret_sts_success;

796: fnd_msg_pub.initialize;
797: END IF;
798:
799: -- Initialize API return status to success
800: x_return_status := fnd_api.g_ret_sts_success;
801:
802: -- API body
803:
804: /*select count(1)

Line 816: RAISE FND_API.G_EXC_ERROR ;

812: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
813: FND_MESSAGE.SET_NAME ('CN' , 'CN_QUOTA_RULE_ASGNED');
814: FND_MSG_PUB.Add;
815: END IF;
816: RAISE FND_API.G_EXC_ERROR ;
817: END IF;*/
818: SELECT p_rt_quota_asgn.org_id,
819: p_rt_quota_asgn.rt_quota_asgn_id,
820: p_rt_quota_asgn.quota_id,

Line 927: IF (x_return_status <> fnd_api.g_ret_sts_success)

923: x_return_status,
924: x_msg_count,
925: x_msg_data
926: );
927: IF (x_return_status <> fnd_api.g_ret_sts_success)
928: THEN
929: RAISE fnd_api.g_exc_error;
930: END IF;
931:

Line 929: RAISE fnd_api.g_exc_error;

925: x_msg_data
926: );
927: IF (x_return_status <> fnd_api.g_ret_sts_success)
928: THEN
929: RAISE fnd_api.g_exc_error;
930: END IF;
931:
932:
933: -- End of API body.

Line 935: IF fnd_api.to_boolean (p_commit)

931:
932:
933: -- End of API body.
934: -- Standard check of p_commit.
935: IF fnd_api.to_boolean (p_commit)
936: THEN
937: COMMIT WORK;
938: END IF;
939:

Line 941: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

937: COMMIT WORK;
938: END IF;
939:
940: -- Standard call to get message count and if count is 1, get message info.
941: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
942: EXCEPTION
943: WHEN fnd_api.g_exc_error
944: THEN
945: ROLLBACK TO delete_rt_quota_asgn;

Line 943: WHEN fnd_api.g_exc_error

939:
940: -- Standard call to get message count and if count is 1, get message info.
941: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
942: EXCEPTION
943: WHEN fnd_api.g_exc_error
944: THEN
945: ROLLBACK TO delete_rt_quota_asgn;
946: x_return_status := fnd_api.g_ret_sts_error;
947: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 946: x_return_status := fnd_api.g_ret_sts_error;

942: EXCEPTION
943: WHEN fnd_api.g_exc_error
944: THEN
945: ROLLBACK TO delete_rt_quota_asgn;
946: x_return_status := fnd_api.g_ret_sts_error;
947: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
948: WHEN fnd_api.g_exc_unexpected_error
949: THEN
950: ROLLBACK TO delete_rt_quota_asgn;

Line 947: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

943: WHEN fnd_api.g_exc_error
944: THEN
945: ROLLBACK TO delete_rt_quota_asgn;
946: x_return_status := fnd_api.g_ret_sts_error;
947: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
948: WHEN fnd_api.g_exc_unexpected_error
949: THEN
950: ROLLBACK TO delete_rt_quota_asgn;
951: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 948: WHEN fnd_api.g_exc_unexpected_error

944: THEN
945: ROLLBACK TO delete_rt_quota_asgn;
946: x_return_status := fnd_api.g_ret_sts_error;
947: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
948: WHEN fnd_api.g_exc_unexpected_error
949: THEN
950: ROLLBACK TO delete_rt_quota_asgn;
951: x_return_status := fnd_api.g_ret_sts_unexp_error;
952: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 951: x_return_status := fnd_api.g_ret_sts_unexp_error;

947: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
948: WHEN fnd_api.g_exc_unexpected_error
949: THEN
950: ROLLBACK TO delete_rt_quota_asgn;
951: x_return_status := fnd_api.g_ret_sts_unexp_error;
952: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
953: WHEN OTHERS
954: THEN
955: ROLLBACK TO delete_rt_quota_asgn;

Line 952: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

948: WHEN fnd_api.g_exc_unexpected_error
949: THEN
950: ROLLBACK TO delete_rt_quota_asgn;
951: x_return_status := fnd_api.g_ret_sts_unexp_error;
952: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
953: WHEN OTHERS
954: THEN
955: ROLLBACK TO delete_rt_quota_asgn;
956: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 956: x_return_status := fnd_api.g_ret_sts_unexp_error;

952: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
953: WHEN OTHERS
954: THEN
955: ROLLBACK TO delete_rt_quota_asgn;
956: x_return_status := fnd_api.g_ret_sts_unexp_error;
957:
958: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
959: THEN
960: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 963: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

959: THEN
960: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
961: END IF;
962:
963: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
964: END delete_rate_table_assignment;
965:
966: -- Start of comments
967: -- API name : get_formula_rate_tables

Line 974: -- Default = FND_API.G_FALSE

970: -- Pre-reqs : None.
971: -- Parameters :
972: -- IN : p_api_version IN NUMBER Required
973: -- p_init_msg_list IN VARCHAR2 Optional
974: -- Default = FND_API.G_FALSE
975: -- p_commit IN VARCHAR2 Optional
976: -- Default = FND_API.G_FALSE
977: -- p_validation_level IN NUMBER Optional
978: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 976: -- Default = FND_API.G_FALSE

972: -- IN : p_api_version IN NUMBER Required
973: -- p_init_msg_list IN VARCHAR2 Optional
974: -- Default = FND_API.G_FALSE
975: -- p_commit IN VARCHAR2 Optional
976: -- Default = FND_API.G_FALSE
977: -- p_validation_level IN NUMBER Optional
978: -- Default = FND_API.G_VALID_LEVEL_FULL
979: -- p_quota_id IN NUMBER
980: -- OUT : x_return_status OUT VARCHAR2(1)

Line 978: -- Default = FND_API.G_VALID_LEVEL_FULL

974: -- Default = FND_API.G_FALSE
975: -- p_commit IN VARCHAR2 Optional
976: -- Default = FND_API.G_FALSE
977: -- p_validation_level IN NUMBER Optional
978: -- Default = FND_API.G_VALID_LEVEL_FULL
979: -- p_quota_id IN NUMBER
980: -- OUT : x_return_status OUT VARCHAR2(1)
981: -- x_msg_count OUT NUMBER
982: -- x_msg_data OUT VARCHAR2(2000)

Line 990: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

986: --
987: -- End of comments
988: PROCEDURE get_formula_rate_tables (
989: p_api_version IN NUMBER,
990: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
991: p_commit IN VARCHAR2 := fnd_api.g_false,
992: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
993: p_type IN VARCHAR2 := 'FORMULA',
994: p_quota_id IN NUMBER,

Line 991: p_commit IN VARCHAR2 := fnd_api.g_false,

987: -- End of comments
988: PROCEDURE get_formula_rate_tables (
989: p_api_version IN NUMBER,
990: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
991: p_commit IN VARCHAR2 := fnd_api.g_false,
992: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
993: p_type IN VARCHAR2 := 'FORMULA',
994: p_quota_id IN NUMBER,
995: p_calc_formula_id IN NUMBER,

Line 992: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

988: PROCEDURE get_formula_rate_tables (
989: p_api_version IN NUMBER,
990: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
991: p_commit IN VARCHAR2 := fnd_api.g_false,
992: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
993: p_type IN VARCHAR2 := 'FORMULA',
994: p_quota_id IN NUMBER,
995: p_calc_formula_id IN NUMBER,
996: x_calc_formulas OUT NOCOPY calc_formulas_tbl_type,

Line 1044: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

1040: -- Standard Start of API savepoint
1041: SAVEPOINT get_formula_rate_tables;
1042:
1043: -- Standard call to check for call compatibility.
1044: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1045: THEN
1046: RAISE fnd_api.g_exc_unexpected_error;
1047: END IF;
1048:

Line 1046: RAISE fnd_api.g_exc_unexpected_error;

1042:
1043: -- Standard call to check for call compatibility.
1044: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1045: THEN
1046: RAISE fnd_api.g_exc_unexpected_error;
1047: END IF;
1048:
1049: -- Initialize message list if p_init_msg_list is set to TRUE.
1050: IF fnd_api.to_boolean (p_init_msg_list)

Line 1050: IF fnd_api.to_boolean (p_init_msg_list)

1046: RAISE fnd_api.g_exc_unexpected_error;
1047: END IF;
1048:
1049: -- Initialize message list if p_init_msg_list is set to TRUE.
1050: IF fnd_api.to_boolean (p_init_msg_list)
1051: THEN
1052: fnd_msg_pub.initialize;
1053: END IF;
1054:

Line 1056: x_return_status := fnd_api.g_ret_sts_success;

1052: fnd_msg_pub.initialize;
1053: END IF;
1054:
1055: -- Initialize API return status to success
1056: x_return_status := fnd_api.g_ret_sts_success;
1057:
1058: IF p_calc_formula_id IS NOT NULL
1059: THEN
1060: l_stack := stack_type (p_calc_formula_id);

Line 1114: IF fnd_api.to_boolean (p_commit)

1110: x_calc_formulas := l_calc_formulas;
1111:
1112: -- End of API body.
1113: -- Standard check of p_commit.
1114: IF fnd_api.to_boolean (p_commit)
1115: THEN
1116: COMMIT WORK;
1117: END IF;
1118:

Line 1120: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1116: COMMIT WORK;
1117: END IF;
1118:
1119: -- Standard call to get message count and if count is 1, get message info.
1120: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1121: EXCEPTION
1122: WHEN fnd_api.g_exc_error
1123: THEN
1124: ROLLBACK TO get_formula_rate_tables;

Line 1122: WHEN fnd_api.g_exc_error

1118:
1119: -- Standard call to get message count and if count is 1, get message info.
1120: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1121: EXCEPTION
1122: WHEN fnd_api.g_exc_error
1123: THEN
1124: ROLLBACK TO get_formula_rate_tables;
1125: x_return_status := fnd_api.g_ret_sts_error;
1126: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 1125: x_return_status := fnd_api.g_ret_sts_error;

1121: EXCEPTION
1122: WHEN fnd_api.g_exc_error
1123: THEN
1124: ROLLBACK TO get_formula_rate_tables;
1125: x_return_status := fnd_api.g_ret_sts_error;
1126: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1127: WHEN fnd_api.g_exc_unexpected_error
1128: THEN
1129: ROLLBACK TO get_formula_rate_tables;

Line 1126: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1122: WHEN fnd_api.g_exc_error
1123: THEN
1124: ROLLBACK TO get_formula_rate_tables;
1125: x_return_status := fnd_api.g_ret_sts_error;
1126: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1127: WHEN fnd_api.g_exc_unexpected_error
1128: THEN
1129: ROLLBACK TO get_formula_rate_tables;
1130: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1127: WHEN fnd_api.g_exc_unexpected_error

1123: THEN
1124: ROLLBACK TO get_formula_rate_tables;
1125: x_return_status := fnd_api.g_ret_sts_error;
1126: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1127: WHEN fnd_api.g_exc_unexpected_error
1128: THEN
1129: ROLLBACK TO get_formula_rate_tables;
1130: x_return_status := fnd_api.g_ret_sts_unexp_error;
1131: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 1130: x_return_status := fnd_api.g_ret_sts_unexp_error;

1126: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1127: WHEN fnd_api.g_exc_unexpected_error
1128: THEN
1129: ROLLBACK TO get_formula_rate_tables;
1130: x_return_status := fnd_api.g_ret_sts_unexp_error;
1131: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1132: WHEN OTHERS
1133: THEN
1134: ROLLBACK TO get_formula_rate_tables;

Line 1131: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1127: WHEN fnd_api.g_exc_unexpected_error
1128: THEN
1129: ROLLBACK TO get_formula_rate_tables;
1130: x_return_status := fnd_api.g_ret_sts_unexp_error;
1131: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1132: WHEN OTHERS
1133: THEN
1134: ROLLBACK TO get_formula_rate_tables;
1135: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1135: x_return_status := fnd_api.g_ret_sts_unexp_error;

1131: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1132: WHEN OTHERS
1133: THEN
1134: ROLLBACK TO get_formula_rate_tables;
1135: x_return_status := fnd_api.g_ret_sts_unexp_error;
1136:
1137: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1138: THEN
1139: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 1142: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1138: THEN
1139: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1140: END IF;
1141:
1142: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1143: END get_formula_rate_tables;
1144:
1145: -- Start of comments
1146: -- API name : validate_rate_table_assignment

Line 1153: -- Default = FND_API.G_FALSE

1149: -- Pre-reqs : None.
1150: -- Parameters :
1151: -- IN : p_api_version IN NUMBER Required
1152: -- p_init_msg_list IN VARCHAR2 Optional
1153: -- Default = FND_API.G_FALSE
1154: -- p_commit IN VARCHAR2 Optional
1155: -- Default = FND_API.G_FALSE
1156: -- p_validation_level IN NUMBER Optional
1157: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 1155: -- Default = FND_API.G_FALSE

1151: -- IN : p_api_version IN NUMBER Required
1152: -- p_init_msg_list IN VARCHAR2 Optional
1153: -- Default = FND_API.G_FALSE
1154: -- p_commit IN VARCHAR2 Optional
1155: -- Default = FND_API.G_FALSE
1156: -- p_validation_level IN NUMBER Optional
1157: -- Default = FND_API.G_VALID_LEVEL_FULL
1158: -- p_rt_quota_asgn IN quota_asgn_rec_type
1159: -- OUT : x_return_status OUT VARCHAR2(1)

Line 1157: -- Default = FND_API.G_VALID_LEVEL_FULL

1153: -- Default = FND_API.G_FALSE
1154: -- p_commit IN VARCHAR2 Optional
1155: -- Default = FND_API.G_FALSE
1156: -- p_validation_level IN NUMBER Optional
1157: -- Default = FND_API.G_VALID_LEVEL_FULL
1158: -- p_rt_quota_asgn IN quota_asgn_rec_type
1159: -- OUT : x_return_status OUT VARCHAR2(1)
1160: -- x_msg_count OUT NUMBER
1161: -- x_msg_data OUT VARCHAR2(2000)

Line 1168: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1164: --
1165: -- End of comments
1166: PROCEDURE validate_rate_table_assignment (
1167: p_api_version IN NUMBER,
1168: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1169: p_commit IN VARCHAR2 := fnd_api.g_false,
1170: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1171: p_action IN VARCHAR2,
1172: p_rt_quota_asgn IN OUT NOCOPY rt_quota_asgn_rec_type,

Line 1169: p_commit IN VARCHAR2 := fnd_api.g_false,

1165: -- End of comments
1166: PROCEDURE validate_rate_table_assignment (
1167: p_api_version IN NUMBER,
1168: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1169: p_commit IN VARCHAR2 := fnd_api.g_false,
1170: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1171: p_action IN VARCHAR2,
1172: p_rt_quota_asgn IN OUT NOCOPY rt_quota_asgn_rec_type,
1173: p_old_rt_quota_asgn IN rt_quota_asgn_rec_type := g_miss_rt_quota_asgn_rec,

Line 1170: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

1166: PROCEDURE validate_rate_table_assignment (
1167: p_api_version IN NUMBER,
1168: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1169: p_commit IN VARCHAR2 := fnd_api.g_false,
1170: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1171: p_action IN VARCHAR2,
1172: p_rt_quota_asgn IN OUT NOCOPY rt_quota_asgn_rec_type,
1173: p_old_rt_quota_asgn IN rt_quota_asgn_rec_type := g_miss_rt_quota_asgn_rec,
1174: x_return_status OUT NOCOPY VARCHAR2,

Line 1192: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

1188: -- Standard Start of API savepoint
1189: SAVEPOINT check_rt_quota_asgn;
1190:
1191: -- Standard call to check for call compatibility.
1192: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1193: THEN
1194: RAISE fnd_api.g_exc_unexpected_error;
1195: END IF;
1196:

Line 1194: RAISE fnd_api.g_exc_unexpected_error;

1190:
1191: -- Standard call to check for call compatibility.
1192: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1193: THEN
1194: RAISE fnd_api.g_exc_unexpected_error;
1195: END IF;
1196:
1197: -- Initialize message list if p_init_msg_list is set to TRUE.
1198: IF fnd_api.to_boolean (p_init_msg_list)

Line 1198: IF fnd_api.to_boolean (p_init_msg_list)

1194: RAISE fnd_api.g_exc_unexpected_error;
1195: END IF;
1196:
1197: -- Initialize message list if p_init_msg_list is set to TRUE.
1198: IF fnd_api.to_boolean (p_init_msg_list)
1199: THEN
1200: fnd_msg_pub.initialize;
1201: END IF;
1202:

Line 1204: x_return_status := fnd_api.g_ret_sts_success;

1200: fnd_msg_pub.initialize;
1201: END IF;
1202:
1203: -- Initialize API return status to success
1204: x_return_status := fnd_api.g_ret_sts_success;
1205:
1206: IF p_action = 'DELETE'
1207: THEN
1208: NULL;

Line 1212: RAISE fnd_api.g_exc_error;

1208: NULL;
1209: ELSE
1210: IF NOT cn_plan_element_pvt.is_valid_org(p_rt_quota_asgn.org_id,p_rt_quota_asgn.quota_id)
1211: THEN
1212: RAISE fnd_api.g_exc_error;
1213: END IF;
1214:
1215: IF p_rt_quota_asgn.rate_schedule_id IS NULL
1216: THEN

Line 1222: RAISE fnd_api.g_exc_error;

1218: THEN
1219: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
1220: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('CALC_FORMULA_ID', 'PE_OBJECT_TYPE'));
1221: fnd_msg_pub.ADD;
1222: RAISE fnd_api.g_exc_error;
1223: END IF;
1224: ELSE
1225: BEGIN
1226: SELECT NAME

Line 1239: RAISE fnd_api.g_exc_error;

1235: fnd_message.set_name ('CN', 'CN_RATE_SCH_NOT_EXIST');
1236: fnd_msg_pub.ADD;
1237: END IF;
1238:
1239: RAISE fnd_api.g_exc_error;
1240: END;
1241: END IF;
1242:
1243: IF p_rt_quota_asgn.quota_id IS NULL

Line 1250: RAISE fnd_api.g_exc_error;

1246: THEN
1247: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
1248: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('PE_NAME', 'INPUT_TOKEN'));
1249: fnd_msg_pub.ADD;
1250: RAISE fnd_api.g_exc_error;
1251: END IF;
1252: ELSE
1253: BEGIN
1254: SELECT name, quota_type_code

Line 1268: RAISE fnd_api.g_exc_error;

1264: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('PE_NAME', 'INPUT_TOKEN'));
1265: fnd_msg_pub.ADD;
1266: END IF;
1267:
1268: RAISE fnd_api.g_exc_error;
1269: END;
1270: END IF;
1271:
1272: IF p_rt_quota_asgn.calc_formula_id IS NULL

Line 1280: RAISE fnd_api.g_exc_error;

1276: THEN
1277: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
1278: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('CALC_FORMULA_ID', 'PE_OBJECT_TYPE'));
1279: fnd_msg_pub.ADD;
1280: RAISE fnd_api.g_exc_error;
1281: END IF;
1282: END IF ;
1283: ELSE
1284: BEGIN

Line 1299: RAISE fnd_api.g_exc_error;

1295: fnd_message.set_token ('FORMULA_NAME', p_rt_quota_asgn.calc_formula_id);
1296: fnd_msg_pub.ADD;
1297: END IF;
1298:
1299: RAISE fnd_api.g_exc_error;
1300: END;
1301: END IF;
1302:
1303: IF (p_rt_quota_asgn.start_date IS NULL)

Line 1312: RAISE fnd_api.g_exc_error;

1308: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('START_DATE', 'PE_OBJECT_TYPE'));
1309: fnd_msg_pub.ADD;
1310: END IF;
1311:
1312: RAISE fnd_api.g_exc_error;
1313: END IF;
1314:
1315: -- 3.Start Date > End Date
1316: IF (p_rt_quota_asgn.end_date IS NOT NULL) AND (p_rt_quota_asgn.start_date > p_rt_quota_asgn.end_date)

Line 1324: RAISE fnd_api.g_exc_error;

1320: fnd_message.set_name ('CN', 'CN_DATE_RANGE_ERROR');
1321: fnd_msg_pub.ADD;
1322: END IF;
1323:
1324: RAISE fnd_api.g_exc_error;
1325: END IF;
1326:
1327: -- 4. Check date Effetcivity, quota rate assigns start date and end must
1328: -- be with start date and end date of the quota date

Line 1338: IF x_return_status <> fnd_api.g_ret_sts_success

1334: p_loading_status => l_loading_status,
1335: x_loading_status => l_loading_status
1336: );
1337:
1338: IF x_return_status <> fnd_api.g_ret_sts_success
1339: THEN
1340: RAISE fnd_api.g_exc_error;
1341: END IF;
1342:

Line 1340: RAISE fnd_api.g_exc_error;

1336: );
1337:
1338: IF x_return_status <> fnd_api.g_ret_sts_success
1339: THEN
1340: RAISE fnd_api.g_exc_error;
1341: END IF;
1342:
1343: -- check that you dont have any rate table in the same date range
1344: SELECT COUNT (*)

Line 1359: RAISE fnd_api.g_exc_error;

1355: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1356: THEN
1357: fnd_message.set_name ('CN', 'CN_DATE_OVERLAP');
1358: fnd_msg_pub.ADD;
1359: RAISE fnd_api.g_exc_error;
1360: END IF;
1361: END IF;
1362:
1363: -- CHECK THAT NUMBER OF FORMULA DIMS = NUMBER OF RATE DIMS

Line 1374: RAISE fnd_api.g_exc_error;

1370: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1371: THEN
1372: fnd_message.set_name ('CN', 'CN_PE_DIMS_NOT_EQUAL');
1373: fnd_msg_pub.ADD;
1374: RAISE fnd_api.g_exc_error;
1375: END IF;
1376: END IF;
1377:
1378: END IF;

Line 1383: IF fnd_api.to_boolean (p_commit)

1379: END IF;
1380:
1381: -- End of API body.
1382: -- Standard check of p_commit.
1383: IF fnd_api.to_boolean (p_commit)
1384: THEN
1385: COMMIT WORK;
1386: END IF;
1387:

Line 1389: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1385: COMMIT WORK;
1386: END IF;
1387:
1388: -- Standard call to get message count and if count is 1, get message info.
1389: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1390: EXCEPTION
1391: WHEN fnd_api.g_exc_error
1392: THEN
1393: ROLLBACK TO check_rt_quota_asgn;

Line 1391: WHEN fnd_api.g_exc_error

1387:
1388: -- Standard call to get message count and if count is 1, get message info.
1389: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1390: EXCEPTION
1391: WHEN fnd_api.g_exc_error
1392: THEN
1393: ROLLBACK TO check_rt_quota_asgn;
1394: x_return_status := fnd_api.g_ret_sts_error;
1395: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 1394: x_return_status := fnd_api.g_ret_sts_error;

1390: EXCEPTION
1391: WHEN fnd_api.g_exc_error
1392: THEN
1393: ROLLBACK TO check_rt_quota_asgn;
1394: x_return_status := fnd_api.g_ret_sts_error;
1395: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1396: WHEN fnd_api.g_exc_unexpected_error
1397: THEN
1398: ROLLBACK TO check_rt_quota_asgn;

Line 1395: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1391: WHEN fnd_api.g_exc_error
1392: THEN
1393: ROLLBACK TO check_rt_quota_asgn;
1394: x_return_status := fnd_api.g_ret_sts_error;
1395: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1396: WHEN fnd_api.g_exc_unexpected_error
1397: THEN
1398: ROLLBACK TO check_rt_quota_asgn;
1399: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1396: WHEN fnd_api.g_exc_unexpected_error

1392: THEN
1393: ROLLBACK TO check_rt_quota_asgn;
1394: x_return_status := fnd_api.g_ret_sts_error;
1395: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1396: WHEN fnd_api.g_exc_unexpected_error
1397: THEN
1398: ROLLBACK TO check_rt_quota_asgn;
1399: x_return_status := fnd_api.g_ret_sts_unexp_error;
1400: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 1399: x_return_status := fnd_api.g_ret_sts_unexp_error;

1395: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1396: WHEN fnd_api.g_exc_unexpected_error
1397: THEN
1398: ROLLBACK TO check_rt_quota_asgn;
1399: x_return_status := fnd_api.g_ret_sts_unexp_error;
1400: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1401: WHEN OTHERS
1402: THEN
1403: ROLLBACK TO check_rt_quota_asgn;

Line 1400: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1396: WHEN fnd_api.g_exc_unexpected_error
1397: THEN
1398: ROLLBACK TO check_rt_quota_asgn;
1399: x_return_status := fnd_api.g_ret_sts_unexp_error;
1400: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1401: WHEN OTHERS
1402: THEN
1403: ROLLBACK TO check_rt_quota_asgn;
1404: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1404: x_return_status := fnd_api.g_ret_sts_unexp_error;

1400: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1401: WHEN OTHERS
1402: THEN
1403: ROLLBACK TO check_rt_quota_asgn;
1404: x_return_status := fnd_api.g_ret_sts_unexp_error;
1405:
1406: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1407: THEN
1408: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 1411: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1407: THEN
1408: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1409: END IF;
1410:
1411: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1412: END validate_rate_table_assignment;
1413: END cn_rt_quota_asgn_pvt;