eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_QUOTA_PUB dependencies on FND_MESSAGE

Line 59: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_PERIOD');

55: THEN
56: --
57: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
58: THEN
59: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_PERIOD');
60: fnd_message.set_token('VALUE', p_period_type_id);
61: fnd_msg_pub.add;
62: END IF;
63: x_return_status := fnd_api.g_ret_sts_error;

Line 60: fnd_message.set_token('VALUE', p_period_type_id);

56: --
57: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
58: THEN
59: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_PERIOD');
60: fnd_message.set_token('VALUE', p_period_type_id);
61: fnd_msg_pub.add;
62: END IF;
63: x_return_status := fnd_api.g_ret_sts_error;
64: ELSE

Line 81: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_TIMEID');

77: IF l_time_id IS NULL
78: THEN
79: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
80: THEN
81: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_TIMEID');
82: fnd_message.set_token('VALUE', p_time_id);
83: fnd_msg_pub.add;
84: END IF;
85: x_return_status := fnd_api.g_ret_sts_error;

Line 82: fnd_message.set_token('VALUE', p_time_id);

78: THEN
79: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
80: THEN
81: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_TIMEID');
82: fnd_message.set_token('VALUE', p_time_id);
83: fnd_msg_pub.add;
84: END IF;
85: x_return_status := fnd_api.g_ret_sts_error;
86: END IF;

Line 240: fnd_message.set_name('OZF', 'OZF_QUOTA_MISSING_COL_VALUE');

236: THEN
237: --
238: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
239: THEN
240: fnd_message.set_name('OZF', 'OZF_QUOTA_MISSING_COL_VALUE');
241: fnd_message.set_token('COL_NAME','SHORT_NAME');
242: fnd_msg_pub.add;
243: END IF;
244: x_return_status := fnd_api.g_ret_sts_error;

Line 241: fnd_message.set_token('COL_NAME','SHORT_NAME');

237: --
238: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
239: THEN
240: fnd_message.set_name('OZF', 'OZF_QUOTA_MISSING_COL_VALUE');
241: fnd_message.set_token('COL_NAME','SHORT_NAME');
242: fnd_msg_pub.add;
243: END IF;
244: x_return_status := fnd_api.g_ret_sts_error;
245: END IF;

Line 255: fnd_message.set_name('OZF', 'OZF_QUOTA_MISSING_COL_VALUE');

251: THEN
252: --
253: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
254: THEN
255: fnd_message.set_name('OZF', 'OZF_QUOTA_MISSING_COL_VALUE');
256: fnd_message.set_token('COL_NAME','CUSTOM_SETUP_ID');
257: fnd_msg_pub.add;
258: END IF;
259: x_return_status := fnd_api.g_ret_sts_error;

Line 256: fnd_message.set_token('COL_NAME','CUSTOM_SETUP_ID');

252: --
253: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
254: THEN
255: fnd_message.set_name('OZF', 'OZF_QUOTA_MISSING_COL_VALUE');
256: fnd_message.set_token('COL_NAME','CUSTOM_SETUP_ID');
257: fnd_msg_pub.add;
258: END IF;
259: x_return_status := fnd_api.g_ret_sts_error;
260: END IF;

Line 270: fnd_message.set_name('OZF', 'OZF_QUOTA_MISSING_COL_VALUE');

266: THEN
267: --
268: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
269: THEN
270: fnd_message.set_name('OZF', 'OZF_QUOTA_MISSING_COL_VALUE');
271: fnd_message.set_token('COL_NAME','USER_STATUS_ID');
272: fnd_msg_pub.add;
273: END IF;
274: x_return_status := fnd_api.g_ret_sts_error;

Line 271: fnd_message.set_token('COL_NAME','USER_STATUS_ID');

267: --
268: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
269: THEN
270: fnd_message.set_name('OZF', 'OZF_QUOTA_MISSING_COL_VALUE');
271: fnd_message.set_token('COL_NAME','USER_STATUS_ID');
272: fnd_msg_pub.add;
273: END IF;
274: x_return_status := fnd_api.g_ret_sts_error;
275: END IF;

Line 285: fnd_message.set_name('OZF', 'OZF_QUOTA_MISSING_COL_VALUE');

281: THEN
282: --
283: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
284: THEN
285: fnd_message.set_name('OZF', 'OZF_QUOTA_MISSING_COL_VALUE');
286: fnd_message.set_token('COL_NAME','START_PERIOD_NAME');
287: fnd_msg_pub.add;
288: END IF;
289: x_return_status := fnd_api.g_ret_sts_error;

Line 286: fnd_message.set_token('COL_NAME','START_PERIOD_NAME');

282: --
283: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
284: THEN
285: fnd_message.set_name('OZF', 'OZF_QUOTA_MISSING_COL_VALUE');
286: fnd_message.set_token('COL_NAME','START_PERIOD_NAME');
287: fnd_msg_pub.add;
288: END IF;
289: x_return_status := fnd_api.g_ret_sts_error;
290: END IF;

Line 300: fnd_message.set_name('OZF', 'OZF_QUOTA_MISSING_COL_VALUE');

296: THEN
297: --
298: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
299: THEN
300: fnd_message.set_name('OZF', 'OZF_QUOTA_MISSING_COL_VALUE');
301: fnd_message.set_token('COL_NAME','END_PERIOD_NAME');
302: fnd_msg_pub.add;
303: END IF;
304: x_return_status := fnd_api.g_ret_sts_error;

Line 301: fnd_message.set_token('COL_NAME','END_PERIOD_NAME');

297: --
298: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
299: THEN
300: fnd_message.set_name('OZF', 'OZF_QUOTA_MISSING_COL_VALUE');
301: fnd_message.set_token('COL_NAME','END_PERIOD_NAME');
302: fnd_msg_pub.add;
303: END IF;
304: x_return_status := fnd_api.g_ret_sts_error;
305: END IF;

Line 315: fnd_message.set_name('OZF', 'OZF_QUOTA_MISSING_COL_VALUE');

311: THEN
312: --
313: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
314: THEN
315: fnd_message.set_name('OZF', 'OZF_QUOTA_MISSING_COL_VALUE');
316: fnd_message.set_token('COL_NAME','QUOTA_AMOUNT');
317: fnd_msg_pub.add;
318: END IF;
319: x_return_status := fnd_api.g_ret_sts_error;

Line 316: fnd_message.set_token('COL_NAME','QUOTA_AMOUNT');

312: --
313: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
314: THEN
315: fnd_message.set_name('OZF', 'OZF_QUOTA_MISSING_COL_VALUE');
316: fnd_message.set_token('COL_NAME','QUOTA_AMOUNT');
317: fnd_msg_pub.add;
318: END IF;
319: x_return_status := fnd_api.g_ret_sts_error;
320: END IF;

Line 330: fnd_message.set_name('OZF', 'OZF_QUOTA_MISSING_COL_VALUE');

326: THEN
327: --
328: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
329: THEN
330: fnd_message.set_name('OZF', 'OZF_QUOTA_MISSING_COL_VALUE');
331: fnd_message.set_token('COL_NAME','OWNER');
332: fnd_msg_pub.add;
333: END IF;
334: x_return_status := fnd_api.g_ret_sts_error;

Line 331: fnd_message.set_token('COL_NAME','OWNER');

327: --
328: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
329: THEN
330: fnd_message.set_name('OZF', 'OZF_QUOTA_MISSING_COL_VALUE');
331: fnd_message.set_token('COL_NAME','OWNER');
332: fnd_msg_pub.add;
333: END IF;
334: x_return_status := fnd_api.g_ret_sts_error;
335: END IF;

Line 345: fnd_message.set_name('OZF', 'OZF_QUOTA_MISSING_COL_VALUE');

341: THEN
342: --
343: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
344: THEN
345: fnd_message.set_name('OZF', 'OZF_QUOTA_MISSING_COL_VALUE');
346: fnd_message.set_token('COL_NAME','PRODUCT_SPREAD_TIME_ID');
347: fnd_msg_pub.add;
348: END IF;
349: x_return_status := fnd_api.g_ret_sts_error;

Line 346: fnd_message.set_token('COL_NAME','PRODUCT_SPREAD_TIME_ID');

342: --
343: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
344: THEN
345: fnd_message.set_name('OZF', 'OZF_QUOTA_MISSING_COL_VALUE');
346: fnd_message.set_token('COL_NAME','PRODUCT_SPREAD_TIME_ID');
347: fnd_msg_pub.add;
348: END IF;
349: x_return_status := fnd_api.g_ret_sts_error;
350: END IF;

Line 377: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');

373: THEN
374: --
375: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
376: THEN
377: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');
378: fnd_message.set_token('COL_NAME', 'PARENT_QUOTA_ID');
379: fnd_msg_pub.add;
380: END IF;
381: x_return_status := fnd_api.g_ret_sts_error;

Line 378: fnd_message.set_token('COL_NAME', 'PARENT_QUOTA_ID');

374: --
375: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
376: THEN
377: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');
378: fnd_message.set_token('COL_NAME', 'PARENT_QUOTA_ID');
379: fnd_msg_pub.add;
380: END IF;
381: x_return_status := fnd_api.g_ret_sts_error;
382: RETURN;

Line 395: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');

391: THEN
392: --
393: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
394: THEN
395: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');
396: fnd_message.set_token('COL_NAME', 'PARENT_QUOTA_ID');
397: fnd_msg_pub.add;
398: END IF;
399: x_return_status := fnd_api.g_ret_sts_error;

Line 396: fnd_message.set_token('COL_NAME', 'PARENT_QUOTA_ID');

392: --
393: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
394: THEN
395: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');
396: fnd_message.set_token('COL_NAME', 'PARENT_QUOTA_ID');
397: fnd_msg_pub.add;
398: END IF;
399: x_return_status := fnd_api.g_ret_sts_error;
400: RETURN;

Line 420: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');

416: IF l_custom_setup_exists IS NULL
417: THEN
418: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
419: THEN
420: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');
421: fnd_message.set_token('COL_NAME', 'CUSTOM_SETUP_ID');
422: fnd_msg_pub.add;
423: END IF;
424: x_return_status := fnd_api.g_ret_sts_error;

Line 421: fnd_message.set_token('COL_NAME', 'CUSTOM_SETUP_ID');

417: THEN
418: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
419: THEN
420: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');
421: fnd_message.set_token('COL_NAME', 'CUSTOM_SETUP_ID');
422: fnd_msg_pub.add;
423: END IF;
424: x_return_status := fnd_api.g_ret_sts_error;
425: RETURN;

Line 443: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');

439: IF l_status_code IS NULL
440: THEN
441: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
442: THEN
443: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');
444: fnd_message.set_token('COL_NAME', 'USER_STATUS_ID');
445: fnd_msg_pub.add;
446: END IF;
447: x_return_status := fnd_api.g_ret_sts_error;

Line 444: fnd_message.set_token('COL_NAME', 'USER_STATUS_ID');

440: THEN
441: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
442: THEN
443: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');
444: fnd_message.set_token('COL_NAME', 'USER_STATUS_ID');
445: fnd_msg_pub.add;
446: END IF;
447: x_return_status := fnd_api.g_ret_sts_error;
448: RETURN;

Line 466: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');

462: IF l_start_date_active IS NULL
463: THEN
464: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
465: THEN
466: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');
467: fnd_message.set_token('COL_NAME', 'START_PERIOD_NAME');
468: fnd_msg_pub.add;
469: END IF;
470: x_return_status := fnd_api.g_ret_sts_error;

Line 467: fnd_message.set_token('COL_NAME', 'START_PERIOD_NAME');

463: THEN
464: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
465: THEN
466: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');
467: fnd_message.set_token('COL_NAME', 'START_PERIOD_NAME');
468: fnd_msg_pub.add;
469: END IF;
470: x_return_status := fnd_api.g_ret_sts_error;
471: RETURN;

Line 489: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');

485: IF l_end_date_active IS NULL
486: THEN
487: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
488: THEN
489: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');
490: fnd_message.set_token('COL_NAME', 'END_PERIOD_NAME');
491: fnd_msg_pub.add;
492: END IF;
493: x_return_status := fnd_api.g_ret_sts_error;

Line 490: fnd_message.set_token('COL_NAME', 'END_PERIOD_NAME');

486: THEN
487: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
488: THEN
489: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');
490: fnd_message.set_token('COL_NAME', 'END_PERIOD_NAME');
491: fnd_msg_pub.add;
492: END IF;
493: x_return_status := fnd_api.g_ret_sts_error;
494: RETURN;

Line 509: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');

505: IF p_quota_rec.product_spread_time_id NOT IN ('32', '64')
506: THEN
507: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
508: THEN
509: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');
510: fnd_message.set_token('COL_NAME', 'PRODUCT_SPREAD_TIME_ID');
511: fnd_msg_pub.add;
512: END IF;
513: x_return_status := fnd_api.g_ret_sts_error;

Line 510: fnd_message.set_token('COL_NAME', 'PRODUCT_SPREAD_TIME_ID');

506: THEN
507: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
508: THEN
509: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');
510: fnd_message.set_token('COL_NAME', 'PRODUCT_SPREAD_TIME_ID');
511: fnd_msg_pub.add;
512: END IF;
513: x_return_status := fnd_api.g_ret_sts_error;
514: RETURN;

Line 542: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');

538: IF l_owner_exists IS NULL
539: THEN
540: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
541: THEN
542: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');
543: fnd_message.set_token('COL_NAME', 'OWNER');
544: fnd_msg_pub.add;
545: END IF;
546: x_return_status := fnd_api.g_ret_sts_error;

Line 543: fnd_message.set_token('COL_NAME', 'OWNER');

539: THEN
540: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
541: THEN
542: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');
543: fnd_message.set_token('COL_NAME', 'OWNER');
544: fnd_msg_pub.add;
545: END IF;
546: x_return_status := fnd_api.g_ret_sts_error;
547: RETURN;

Line 567: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');

563: THEN
564: --
565: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
566: THEN
567: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');
568: fnd_message.set_token('COL_NAME', 'THRESHOLD_ID');
569: fnd_msg_pub.add;
570: END IF;
571: x_return_status := fnd_api.g_ret_sts_error;

Line 568: fnd_message.set_token('COL_NAME', 'THRESHOLD_ID');

564: --
565: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
566: THEN
567: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');
568: fnd_message.set_token('COL_NAME', 'THRESHOLD_ID');
569: fnd_msg_pub.add;
570: END IF;
571: x_return_status := fnd_api.g_ret_sts_error;
572: RETURN;

Line 589: fnd_message.set_name('OZF', 'OZF_NO_QUOTA_ID_NUM');

585: (p_quota_rec.quota_number = fnd_api.g_miss_char OR p_quota_rec.quota_number IS NULL)
586: THEN
587:
588: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
589: fnd_message.set_name('OZF', 'OZF_NO_QUOTA_ID_NUM');
590: fnd_msg_pub.add;
591: END IF;
592: x_return_status := fnd_api.g_ret_sts_error;
593: RETURN;

Line 608: fnd_message.set_name('OZF', 'OZF_INVALID_QUOTA_ID');

604: CLOSE c_quota_exists;
605:
606: IF l_quota_exists IS NULL THEN
607: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
608: fnd_message.set_name('OZF', 'OZF_INVALID_QUOTA_ID');
609: fnd_msg_pub.add;
610: END IF;
611: x_return_status := fnd_api.g_ret_sts_error;
612: RETURN;

Line 624: fnd_message.set_name('OZF', 'OZF_INVALID_QUOTA_NUM');

620: CLOSE c_quota_num_exists;
621:
622: IF p_quota_rec.quota_id IS NULL THEN
623: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
624: fnd_message.set_name('OZF', 'OZF_INVALID_QUOTA_NUM');
625: fnd_msg_pub.add;
626: END IF;
627: x_return_status := fnd_api.g_ret_sts_error;
628: RETURN;

Line 708: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');

704: THEN
705: --
706: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
707: THEN
708: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');
709: fnd_message.set_token('COL_NAME', 'ITEM_TYPE');
710: fnd_msg_pub.add;
711: END IF;
712: x_return_status := fnd_api.g_ret_sts_error;

Line 709: fnd_message.set_token('COL_NAME', 'ITEM_TYPE');

705: --
706: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
707: THEN
708: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');
709: fnd_message.set_token('COL_NAME', 'ITEM_TYPE');
710: fnd_msg_pub.add;
711: END IF;
712: x_return_status := fnd_api.g_ret_sts_error;
713: RETURN;

Line 732: fnd_message.set_name('OZF', 'OZF_QUOTA_MISSING_COL_VALUE');

728: ELSE
729: --
730: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
731: THEN
732: fnd_message.set_name('OZF', 'OZF_QUOTA_MISSING_COL_VALUE');
733: fnd_message.set_token('COL_NAME','ITEM_TYPE');
734: fnd_msg_pub.add;
735: END IF;
736: x_return_status := fnd_api.g_ret_sts_error;

Line 733: fnd_message.set_token('COL_NAME','ITEM_TYPE');

729: --
730: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
731: THEN
732: fnd_message.set_name('OZF', 'OZF_QUOTA_MISSING_COL_VALUE');
733: fnd_message.set_token('COL_NAME','ITEM_TYPE');
734: fnd_msg_pub.add;
735: END IF;
736: x_return_status := fnd_api.g_ret_sts_error;
737: --

Line 1058: fnd_message.set_name('OZF', 'OZF_NO_QUOTA_ID_NUM');

1054: IF (p_alloc_rec.quota_id = fnd_api.g_miss_num OR p_alloc_rec.quota_id IS NULL) AND
1055: (p_alloc_rec.quota_number = fnd_api.g_miss_char OR p_alloc_rec.quota_number IS NULL) THEN
1056:
1057: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1058: fnd_message.set_name('OZF', 'OZF_NO_QUOTA_ID_NUM');
1059: fnd_msg_pub.add;
1060: END IF;
1061: x_return_status := fnd_api.g_ret_sts_error;
1062: RETURN;

Line 1075: fnd_message.set_name('OZF', 'OZF_INVALID_QUOTA_ID');

1071: CLOSE c_quota_exists;
1072:
1073: IF l_quota_exists IS NULL THEN
1074: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1075: fnd_message.set_name('OZF', 'OZF_INVALID_QUOTA_ID');
1076: fnd_msg_pub.add;
1077: END IF;
1078: x_return_status := fnd_api.g_ret_sts_error;
1079: RETURN;

Line 1091: fnd_message.set_name('OZF', 'OZF_INVALID_QUOTA_NUM');

1087: CLOSE c_quota_num_exists;
1088:
1089: IF p_alloc_rec.quota_id IS NULL THEN
1090: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1091: fnd_message.set_name('OZF', 'OZF_INVALID_QUOTA_NUM');
1092: fnd_msg_pub.add;
1093: END IF;
1094: x_return_status := fnd_api.g_ret_sts_error;
1095: RETURN;

Line 1103: fnd_message.set_name('OZF', 'OZF_NO_HIER_ID');

1099:
1100: --if hierarchy id is null, then raise exception
1101: IF p_alloc_rec.hierarchy_id = fnd_api.g_miss_num OR p_alloc_rec.hierarchy_id IS NULL THEN
1102: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1103: fnd_message.set_name('OZF', 'OZF_NO_HIER_ID');
1104: fnd_msg_pub.add;
1105: END IF;
1106: x_return_status := fnd_api.g_ret_sts_error;
1107: RETURN;

Line 1116: fnd_message.set_name('OZF', 'OZF_INVALID_HIER_ID');

1112: CLOSE c_hier_id_exists;
1113:
1114: IF p_alloc_rec.hierarchy_id IS NULL THEN
1115: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1116: fnd_message.set_name('OZF', 'OZF_INVALID_HIER_ID');
1117: fnd_msg_pub.add;
1118: END IF;
1119: x_return_status := fnd_api.g_ret_sts_error;
1120: RETURN;

Line 1127: fnd_message.set_name('OZF', 'OZF_NO_FROM_LEVEL');

1123:
1124: --if from level is null, then raise exception
1125: IF p_alloc_rec.from_level = fnd_api.g_miss_num OR p_alloc_rec.from_level IS NULL THEN
1126: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1127: fnd_message.set_name('OZF', 'OZF_NO_FROM_LEVEL');
1128: fnd_msg_pub.add;
1129: END IF;
1130: x_return_status := fnd_api.g_ret_sts_error;
1131: RETURN;

Line 1140: fnd_message.set_name('OZF', 'OZF_INVALID_FROM_LEVEL');

1136: CLOSE c_from_level_exists;
1137:
1138: IF p_alloc_rec.from_level IS NULL THEN
1139: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1140: fnd_message.set_name('OZF', 'OZF_INVALID_FROM_LEVEL');
1141: fnd_msg_pub.add;
1142: END IF;
1143: x_return_status := fnd_api.g_ret_sts_error;
1144: RETURN;

Line 1151: fnd_message.set_name('OZF', 'OZF_NO_TO_LEVEL');

1147:
1148: --if to level is null, then raise exception
1149: IF p_alloc_rec.to_level = fnd_api.g_miss_num OR p_alloc_rec.to_level IS NULL THEN
1150: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1151: fnd_message.set_name('OZF', 'OZF_NO_TO_LEVEL');
1152: fnd_msg_pub.add;
1153: END IF;
1154: x_return_status := fnd_api.g_ret_sts_error;
1155: RETURN;

Line 1164: fnd_message.set_name('OZF', 'OZF_INVALID_TO_LEVEL');

1160: CLOSE c_to_level_exists;
1161:
1162: IF p_alloc_rec.to_level IS NULL THEN
1163: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1164: fnd_message.set_name('OZF', 'OZF_INVALID_TO_LEVEL');
1165: fnd_msg_pub.add;
1166: END IF;
1167: x_return_status := fnd_api.g_ret_sts_error;
1168: RETURN;

Line 1175: fnd_message.set_name('OZF', 'OZF_NO_START_NODE');

1171:
1172: --if start node is null, then raise exception
1173: IF p_alloc_rec.start_node = fnd_api.g_miss_num OR p_alloc_rec.start_node IS NULL THEN
1174: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1175: fnd_message.set_name('OZF', 'OZF_NO_START_NODE');
1176: fnd_msg_pub.add;
1177: END IF;
1178: x_return_status := fnd_api.g_ret_sts_error;
1179: RETURN;

Line 1188: fnd_message.set_name('OZF', 'OZF_INVALID_START_NODE');

1184: CLOSE c_start_node_exists;
1185:
1186: IF p_alloc_rec.start_node IS NULL THEN
1187: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1188: fnd_message.set_name('OZF', 'OZF_INVALID_START_NODE');
1189: fnd_msg_pub.add;
1190: END IF;
1191: x_return_status := fnd_api.g_ret_sts_error;
1192: RETURN;

Line 1199: fnd_message.set_name('OZF', 'OZF_NO_START_PERIOD');

1195:
1196: --if start period name is null
1197: IF p_alloc_rec.start_period_name = fnd_api.g_miss_char OR p_alloc_rec.start_period_name IS NULL THEN
1198: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1199: fnd_message.set_name('OZF', 'OZF_NO_START_PERIOD');
1200: fnd_msg_pub.add;
1201: END IF;
1202: x_return_status := fnd_api.g_ret_sts_error;
1203: RETURN;

Line 1212: fnd_message.set_name('OZF', 'OZF_INVALID_START_PERIOD');

1208: CLOSE c_period_exists;
1209:
1210: IF l_period_exists IS NULL THEN
1211: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1212: fnd_message.set_name('OZF', 'OZF_INVALID_START_PERIOD');
1213: fnd_msg_pub.add;
1214: END IF;
1215: x_return_status := fnd_api.g_ret_sts_error;
1216: RETURN;

Line 1224: fnd_message.set_name('OZF', 'OZF_NO_END_PERIOD');

1220:
1221: --if end period name is null
1222: IF p_alloc_rec.end_period_name = fnd_api.g_miss_char OR p_alloc_rec.end_period_name IS NULL THEN
1223: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1224: fnd_message.set_name('OZF', 'OZF_NO_END_PERIOD');
1225: fnd_msg_pub.add;
1226: END IF;
1227: x_return_status := fnd_api.g_ret_sts_error;
1228: RETURN;

Line 1237: fnd_message.set_name('OZF', 'OZF_INVALID_END_PERIOD');

1233: CLOSE c_period_exists;
1234:
1235: IF l_period_exists IS NULL THEN
1236: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1237: fnd_message.set_name('OZF', 'OZF_INVALID_END_PERIOD');
1238: fnd_msg_pub.add;
1239: END IF;
1240: x_return_status := fnd_api.g_ret_sts_error;
1241: RETURN;

Line 1256: fnd_message.set_name('OZF', 'OZF_NO_ALLOC_AMT');

1252:
1253: --if allocation amount is null, then raise exception
1254: IF p_alloc_rec.alloc_amount = fnd_api.g_miss_num OR p_alloc_rec.alloc_amount IS NULL THEN
1255: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1256: fnd_message.set_name('OZF', 'OZF_NO_ALLOC_AMT');
1257: fnd_msg_pub.add;
1258: END IF;
1259: x_return_status := fnd_api.g_ret_sts_error;
1260: RETURN;

Line 1266: fnd_message.set_name('OZF', 'OZF_NO_METHOD_CODE');

1262:
1263: --if method code is null, then raise exception
1264: IF p_alloc_rec.method_code = fnd_api.g_miss_char OR p_alloc_rec.method_code IS NULL THEN
1265: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1266: fnd_message.set_name('OZF', 'OZF_NO_METHOD_CODE');
1267: fnd_msg_pub.add;
1268: END IF;
1269: x_return_status := fnd_api.g_ret_sts_error;
1270: RETURN;

Line 1279: fnd_message.set_name('OZF', 'OZF_INVALID_METHOD_CODE');

1275: CLOSE c_method_code_exists;
1276:
1277: IF p_alloc_rec.method_code IS NULL THEN
1278: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1279: fnd_message.set_name('OZF', 'OZF_INVALID_METHOD_CODE');
1280: fnd_msg_pub.add;
1281: END IF;
1282: x_return_status := fnd_api.g_ret_sts_error;
1283: RETURN;

Line 1291: fnd_message.set_name('OZF', 'OZF_NO_BASIS_YEAR');

1287: --if basis year is null, then raise exception
1288: IF p_alloc_rec.basis_year = fnd_api.g_miss_num OR p_alloc_rec.basis_year IS NULL
1289: AND p_alloc_rec.method_code = 'PRIOR_SALES_TOTAL' THEN
1290: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1291: fnd_message.set_name('OZF', 'OZF_NO_BASIS_YEAR');
1292: fnd_msg_pub.add;
1293: END IF;
1294: x_return_status := fnd_api.g_ret_sts_error;
1295: RETURN;

Line 1745: FND_MESSAGE.Set_Name('OZF', 'OZF_QUOTA_MISSING_PROD_SPREAD');

1741: -- p_quota_products_tbl will already have record by now
1742:
1743: IF (p_quota_prod_spread_tbl.count = 0 ) Then
1744: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1745: FND_MESSAGE.Set_Name('OZF', 'OZF_QUOTA_MISSING_PROD_SPREAD');
1746: FND_MSG_PUB.ADD;
1747: END IF;
1748: x_return_status := FND_API.G_RET_STS_ERROR;
1749: RAISE FND_API.G_EXC_ERROR;

Line 1967: FND_MESSAGE.Set_Name('OZF', 'OZF_QUOTA_MISSING_ACCOUNTS');

1963: x_return_status := FND_API.G_RET_STS_SUCCESS;
1964:
1965: IF (p_quota_accounts_tbl.count = 0 ) Then
1966: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1967: FND_MESSAGE.Set_Name('OZF', 'OZF_QUOTA_MISSING_ACCOUNTS');
1968: FND_MSG_PUB.ADD;
1969: END IF;
1970: x_return_status := FND_API.G_RET_STS_ERROR;
1971: RAISE FND_API.G_EXC_ERROR;

Line 1976: FND_MESSAGE.Set_Name('OZF', 'OZF_QUOTA_MISSING_ACCT_SPREAD');

1972: END IF;
1973:
1974: IF (p_account_spread_tbl.count = 0 ) Then
1975: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1976: FND_MESSAGE.Set_Name('OZF', 'OZF_QUOTA_MISSING_ACCT_SPREAD');
1977: FND_MSG_PUB.ADD;
1978: END IF;
1979: x_return_status := FND_API.G_RET_STS_ERROR;
1980: RAISE FND_API.G_EXC_ERROR;

Line 2010: FND_MESSAGE.Set_Name('OZF', 'OZF_QUOTA_INVALID_SHIP_TO');

2006: END IF;
2007:
2008: IF (l_rollup_party_id IS NULL) Then
2009: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2010: FND_MESSAGE.Set_Name('OZF', 'OZF_QUOTA_INVALID_SHIP_TO');
2011: FND_MSG_PUB.ADD;
2012: END IF;
2013: x_return_status := FND_API.G_RET_STS_ERROR;
2014: RAISE FND_API.G_EXC_ERROR;

Line 2286: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');

2282: IF p_method NOT IN ('MANUAL', 'ALLOCATION')
2283: THEN
2284: --
2285: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2286: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');
2287: fnd_message.set_token('COL_NAME', 'P_METHOD');
2288: fnd_msg_pub.add;
2289: END IF;
2290: x_return_status := fnd_api.g_ret_sts_error;

Line 2287: fnd_message.set_token('COL_NAME', 'P_METHOD');

2283: THEN
2284: --
2285: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2286: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');
2287: fnd_message.set_token('COL_NAME', 'P_METHOD');
2288: fnd_msg_pub.add;
2289: END IF;
2290: x_return_status := fnd_api.g_ret_sts_error;
2291: RAISE fnd_api.g_exc_error;

Line 2301: FND_MESSAGE.Set_Name('OZF', 'OZF_QUOTA_MISSING_PRODUCTS');

2297: -- Products are always required
2298: IF (p_quota_products_tbl.COUNT = 0 )
2299: THEN
2300: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2301: FND_MESSAGE.Set_Name('OZF', 'OZF_QUOTA_MISSING_PRODUCTS');
2302: FND_MSG_PUB.ADD;
2303: END IF;
2304: x_return_status := FND_API.G_RET_STS_ERROR;
2305: raise FND_API.G_EXC_ERROR;

Line 2743: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');

2739: THEN
2740: --
2741: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
2742: THEN
2743: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');
2744: fnd_message.set_token('COL_NAME', 'PRODUCT_ALLOCATION_ID');
2745: fnd_msg_pub.add;
2746: END IF;
2747: x_return_status := fnd_api.g_ret_sts_error;

Line 2744: fnd_message.set_token('COL_NAME', 'PRODUCT_ALLOCATION_ID');

2740: --
2741: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
2742: THEN
2743: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');
2744: fnd_message.set_token('COL_NAME', 'PRODUCT_ALLOCATION_ID');
2745: fnd_msg_pub.add;
2746: END IF;
2747: x_return_status := fnd_api.g_ret_sts_error;
2748: RETURN;

Line 2781: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');

2777: THEN
2778: --
2779: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
2780: THEN
2781: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');
2782: fnd_message.set_token('COL_NAME', 'TIME_ALLOCATION_ID');
2783: fnd_msg_pub.add;
2784: END IF;
2785: x_return_status := fnd_api.g_ret_sts_error;

Line 2782: fnd_message.set_token('COL_NAME', 'TIME_ALLOCATION_ID');

2778: --
2779: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
2780: THEN
2781: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');
2782: fnd_message.set_token('COL_NAME', 'TIME_ALLOCATION_ID');
2783: fnd_msg_pub.add;
2784: END IF;
2785: x_return_status := fnd_api.g_ret_sts_error;
2786: RETURN;

Line 2904: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');

2900: THEN
2901: --
2902: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
2903: THEN
2904: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');
2905: fnd_message.set_token('COL_NAME', 'ACCOUNT_ALLOCATION_ID');
2906: fnd_msg_pub.add;
2907: END IF;
2908: x_return_status := fnd_api.g_ret_sts_error;

Line 2905: fnd_message.set_token('COL_NAME', 'ACCOUNT_ALLOCATION_ID');

2901: --
2902: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
2903: THEN
2904: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');
2905: fnd_message.set_token('COL_NAME', 'ACCOUNT_ALLOCATION_ID');
2906: fnd_msg_pub.add;
2907: END IF;
2908: x_return_status := fnd_api.g_ret_sts_error;
2909: RETURN;

Line 2942: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');

2938: THEN
2939: --
2940: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
2941: THEN
2942: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');
2943: fnd_message.set_token('COL_NAME', 'TIME_ALLOCATION_ID');
2944: fnd_msg_pub.add;
2945: END IF;
2946: x_return_status := fnd_api.g_ret_sts_error;

Line 2943: fnd_message.set_token('COL_NAME', 'TIME_ALLOCATION_ID');

2939: --
2940: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
2941: THEN
2942: fnd_message.set_name('OZF', 'OZF_QUOTA_INVALID_COL_VALUE');
2943: fnd_message.set_token('COL_NAME', 'TIME_ALLOCATION_ID');
2944: fnd_msg_pub.add;
2945: END IF;
2946: x_return_status := fnd_api.g_ret_sts_error;
2947: RETURN;

Line 3114: fnd_message.set_name('OZF', 'OZF_NO_QUOTA_ID');

3110: --if quota id is null, then raise exception
3111: IF (p_quota_id = fnd_api.g_miss_num OR p_quota_id IS NULL) THEN
3112:
3113: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3114: fnd_message.set_name('OZF', 'OZF_NO_QUOTA_ID');
3115: fnd_msg_pub.add;
3116: END IF;
3117: RAISE fnd_api.g_exc_error;
3118: END IF;

Line 3127: fnd_message.set_name('OZF', 'OZF_INVALID_QUOTA_ID');

3123: CLOSE c_valid_quota;
3124:
3125: IF l_object_version IS NULL THEN
3126: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3127: fnd_message.set_name('OZF', 'OZF_INVALID_QUOTA_ID');
3128: fnd_msg_pub.add;
3129: END IF;
3130: RAISE fnd_api.g_exc_error;
3131: END IF;

Line 3240: fnd_message.set_name('OZF', 'OZF_NO_QUOTA_ID');

3236: --if quota id is null, then raise exception
3237: IF (p_quota_id = fnd_api.g_miss_num OR p_quota_id IS NULL) THEN
3238:
3239: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3240: fnd_message.set_name('OZF', 'OZF_NO_QUOTA_ID');
3241: fnd_msg_pub.add;
3242: END IF;
3243: RAISE fnd_api.g_exc_error;
3244: END IF;

Line 3253: fnd_message.set_name('OZF', 'OZF_INVALID_QUOTA_ID');

3249: CLOSE c_valid_quota;
3250:
3251: IF l_valid_quota IS NULL THEN
3252: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3253: fnd_message.set_name('OZF', 'OZF_INVALID_QUOTA_ID');
3254: fnd_msg_pub.add;
3255: END IF;
3256: RAISE fnd_api.g_exc_error;
3257: END IF;

Line 3266: fnd_message.set_name('OZF', 'OZF_QUOTA_NO_PROD');

3262: CLOSE c_product_exists;
3263:
3264: IF l_prod_exists IS NULL THEN
3265: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3266: fnd_message.set_name('OZF', 'OZF_QUOTA_NO_PROD');
3267: fnd_msg_pub.add;
3268: END IF;
3269: RAISE fnd_api.g_exc_error;
3270: END IF;

Line 3375: fnd_message.set_name('OZF', 'OZF_NO_PROD_SPREAD'); -- product spread needs to be created before creating allocation

3371: CLOSE c_product_spread_exists;
3372:
3373: IF l_spread_exists IS NULL THEN
3374: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3375: fnd_message.set_name('OZF', 'OZF_NO_PROD_SPREAD'); -- product spread needs to be created before creating allocation
3376: fnd_msg_pub.add;
3377: END IF;
3378: RAISE fnd_api.g_exc_error;
3379: END IF;

Line 3523: fnd_message.set_name('OZF', 'OZF_INVALID_ALLOC_ID');

3519: CLOSE c_valid_alloc;
3520:
3521: IF l_valid_alloc IS NULL THEN
3522: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3523: fnd_message.set_name('OZF', 'OZF_INVALID_ALLOC_ID');
3524: fnd_msg_pub.add;
3525: END IF;
3526: RAISE fnd_api.g_exc_error;
3527: END IF;

Line 3653: fnd_message.set_name('OZF', 'OZF_INVALID_ALLOC_ID');

3649: CLOSE c_valid_alloc;
3650:
3651: IF l_alloc_obj_ver IS NULL THEN
3652: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3653: fnd_message.set_name('OZF', 'OZF_INVALID_ALLOC_ID');
3654: fnd_msg_pub.add;
3655: END IF;
3656: RAISE fnd_api.g_exc_error;
3657: END IF;