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_FUNDS_PVT dependencies on FND_MESSAGE

Line 244: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

240: CLOSE c_parent_number;
241:
242: IF l_par_number IS NULL THEN
243: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
244: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
245: fnd_msg_pub.add;
246: END IF;
247:
248: x_return_status := fnd_api.g_ret_sts_error;

Line 549: fnd_message.set_name('OZF', 'OZF_UNIV_CURR_NOT_FOUND');

545:
546: IF g_universal_currency IS NULL THEN
547:
548: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
549: fnd_message.set_name('OZF', 'OZF_UNIV_CURR_NOT_FOUND');
550: fnd_msg_pub.add;
551: END IF;
552:
553: RAISE fnd_api.g_exc_error;

Line 1228: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

1224: AND object_version_number = p_object_version;
1225:
1226: IF (SQL%NOTFOUND) THEN
1227: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1228: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1229: fnd_msg_pub.add;
1230: END IF;
1231:
1232: RAISE fnd_api.g_exc_error;

Line 1241: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

1237: WHERE fund_id = p_fund_id;
1238:
1239: IF (SQL%NOTFOUND) THEN
1240: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1241: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1242: fnd_msg_pub.add;
1243: END IF;
1244:
1245: RAISE fnd_api.g_exc_error;

Line 1353: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

1349: IF (c_fund_b%NOTFOUND) THEN
1350: CLOSE c_fund_b;
1351:
1352: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1353: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1354: fnd_msg_pub.add;
1355: END IF;
1356:
1357: RAISE fnd_api.g_exc_error;

Line 1376: fnd_message.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');

1372: WHEN ozf_utility_pvt.resource_locked THEN
1373: x_return_status := fnd_api.g_ret_sts_error;
1374:
1375: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1376: fnd_message.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');
1377: fnd_msg_pub.add;
1378: END IF;
1379:
1380: fnd_msg_pub.count_and_get(

Line 1757: l_fund_reconc_msg := fnd_message.get_string ('OZF', 'OZF_FUND_RECONCILE');

1753: l_fund_rec.status_code := l_status_code;
1754: END IF;
1755:
1756: --Added for bug 7425189
1757: l_fund_reconc_msg := fnd_message.get_string ('OZF', 'OZF_FUND_RECONCILE');
1758: l_act_bud_cst_msg := fnd_message.get_string ('OZF', 'OZF_ACT_BUDG_CST_UTIL');
1759:
1760: --changed by mpande
1761: -- Fetch the old status code and old parentID

Line 1758: l_act_bud_cst_msg := fnd_message.get_string ('OZF', 'OZF_ACT_BUDG_CST_UTIL');

1754: END IF;
1755:
1756: --Added for bug 7425189
1757: l_fund_reconc_msg := fnd_message.get_string ('OZF', 'OZF_FUND_RECONCILE');
1758: l_act_bud_cst_msg := fnd_message.get_string ('OZF', 'OZF_ACT_BUDG_CST_UTIL');
1759:
1760: --changed by mpande
1761: -- Fetch the old status code and old parentID
1762: OPEN c_old_status(p_fund_rec.fund_id);

Line 2736: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

2732: AND object_version_number = l_fund_rec.object_version_number;
2733:
2734: IF (SQL%NOTFOUND) THEN
2735: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2736: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
2737: fnd_msg_pub.add;
2738: END IF;
2739:
2740: RAISE fnd_api.g_exc_error;

Line 3472: fnd_message.set_name('OZF', 'OZF_TP_NO_QUOTA_NUMBER');

3468: ------------------------ fund_number --------------------------
3469: /* IF p_fund_rec.fund_number IS NULL THEN -- check for fund number
3470: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3471: IF p_fund_rec.fund_type = 'QUOTA' THEN
3472: fnd_message.set_name('OZF', 'OZF_TP_NO_QUOTA_NUMBER');
3473: ELSE
3474: fnd_message.set_name('OZF', 'OZF_FUND_NO_FUND_NUMBER');
3475: END IF;
3476: fnd_msg_pub.add;

Line 3474: fnd_message.set_name('OZF', 'OZF_FUND_NO_FUND_NUMBER');

3470: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3471: IF p_fund_rec.fund_type = 'QUOTA' THEN
3472: fnd_message.set_name('OZF', 'OZF_TP_NO_QUOTA_NUMBER');
3473: ELSE
3474: fnd_message.set_name('OZF', 'OZF_FUND_NO_FUND_NUMBER');
3475: END IF;
3476: fnd_msg_pub.add;
3477: END IF;
3478:

Line 3487: fnd_message.set_name('OZF', 'OZF_TP_NO_QUOTA_OWNER');

3483: ------------------------ owner -------------------------------
3484: IF p_fund_rec.owner IS NULL THEN -- check for fund owner
3485: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3486: IF p_fund_rec.fund_type = 'QUOTA' THEN
3487: fnd_message.set_name('OZF', 'OZF_TP_NO_QUOTA_OWNER');
3488: ELSE
3489: fnd_message.set_name('OZF', 'OZF_FUND_NO_FUND_OWNER');
3490: END IF;
3491: fnd_msg_pub.add;

Line 3489: fnd_message.set_name('OZF', 'OZF_FUND_NO_FUND_OWNER');

3485: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3486: IF p_fund_rec.fund_type = 'QUOTA' THEN
3487: fnd_message.set_name('OZF', 'OZF_TP_NO_QUOTA_OWNER');
3488: ELSE
3489: fnd_message.set_name('OZF', 'OZF_FUND_NO_FUND_OWNER');
3490: END IF;
3491: fnd_msg_pub.add;
3492: END IF;
3493:

Line 3500: fnd_message.set_name('OZF', 'OZF_FUND_NO_FUND_TYPE');

3496: END IF;
3497:
3498: IF p_fund_rec.fund_type IS NULL THEN -- check for fund owner
3499: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3500: fnd_message.set_name('OZF', 'OZF_FUND_NO_FUND_TYPE');
3501: fnd_msg_pub.add;
3502: END IF;
3503:
3504: x_return_status := fnd_api.g_ret_sts_error;

Line 3511: fnd_message.set_name('OZF', 'OZF_FUND_NO_USER_STATUS');

3507:
3508: -- 09/20/2000 Mumu Pande for user status
3509: IF p_fund_rec.user_status_id IS NULL THEN -- check for fund user status
3510: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3511: fnd_message.set_name('OZF', 'OZF_FUND_NO_USER_STATUS');
3512: fnd_msg_pub.add;
3513: END IF;
3514:
3515: x_return_status := fnd_api.g_ret_sts_error;

Line 3522: fnd_message.set_name('OZF', 'OZF_FUND_NO_CATEGORY');

3518:
3519: -- 01/20/2001 Mumu Pande for category
3520: IF p_fund_rec.fund_type <> 'QUOTA' AND p_fund_rec.category_id IS NULL THEN -- check for fund category
3521: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3522: fnd_message.set_name('OZF', 'OZF_FUND_NO_CATEGORY');
3523: fnd_msg_pub.add;
3524: END IF;
3525:
3526: x_return_status := fnd_api.g_ret_sts_error;

Line 3532: fnd_message.set_name('OZF', 'OZF_FUND_NO_CUSTOM_SETUP');

3528: END IF;
3529: -- 01/20/2001 Mumu Pande for custom_setup_id
3530: IF p_fund_rec.custom_setup_id IS NULL THEN -- check for fund category
3531: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3532: fnd_message.set_name('OZF', 'OZF_FUND_NO_CUSTOM_SETUP');
3533: fnd_msg_pub.add;
3534: END IF;
3535:
3536: x_return_status := fnd_api.g_ret_sts_error;

Line 3549: fnd_message.set_name('OZF', 'OZF_TP_NO_ORG_QUOTA');

3545: -- rimehrot changed back to <= for bug fix 3580531
3546: IF NVL(p_fund_rec.original_budget,0) <= 0 THEN -- check for fund amount
3547: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3548: IF p_fund_rec.fund_type = 'QUOTA' THEN
3549: fnd_message.set_name('OZF', 'OZF_TP_NO_ORG_QUOTA');
3550: ELSE
3551: fnd_message.set_name('OZF', 'OZF_FUND_NO_ORG_BUDGET');
3552: END IF;
3553: fnd_msg_pub.add;

Line 3551: fnd_message.set_name('OZF', 'OZF_FUND_NO_ORG_BUDGET');

3547: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3548: IF p_fund_rec.fund_type = 'QUOTA' THEN
3549: fnd_message.set_name('OZF', 'OZF_TP_NO_ORG_QUOTA');
3550: ELSE
3551: fnd_message.set_name('OZF', 'OZF_FUND_NO_ORG_BUDGET');
3552: END IF;
3553: fnd_msg_pub.add;
3554: END IF;
3555:

Line 3564: fnd_message.set_name('OZF', 'OZF_FUND_NO_LEDGER');

3560:
3561: --kdass 25-APR-2006 bug 5176819 - Ledger is required field
3562: IF p_fund_rec.fund_type <> 'QUOTA' AND p_fund_rec.ledger_id IS NULL THEN
3563: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3564: fnd_message.set_name('OZF', 'OZF_FUND_NO_LEDGER');
3565: fnd_msg_pub.add;
3566: END IF;
3567:
3568: x_return_status := fnd_api.g_ret_sts_error;

Line 3576: fnd_message.set_name('OZF', 'OZF_NO_DEFAULT_ORG_ID');

3572: /* yzhao: bug 4669461: R12 budget is org aware, but not org stripped. quota is not org aware
3573: so org_id is not required
3574: IF p_fund_rec.org_id IS NULL THEN -- check for org id
3575: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3576: fnd_message.set_name('OZF', 'OZF_NO_DEFAULT_ORG_ID');
3577: fnd_msg_pub.add;
3578: END IF;
3579:
3580: x_return_status := fnd_api.g_ret_sts_error;

Line 3628: fnd_message.set_name('OZF', 'OZF_TP_DUPLICATE_ID');

3624: ,'fund_id = ' || p_fund_rec.fund_id) =
3625: fnd_api.g_false THEN
3626: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3627: IF p_fund_rec.fund_type = 'QUOTA' THEN
3628: fnd_message.set_name('OZF', 'OZF_TP_DUPLICATE_ID');
3629: ELSE
3630: fnd_message.set_name('OZF', 'OZF_FUND_DUPLICATE_ID');
3631: END IF;
3632: fnd_msg_pub.add;

Line 3630: fnd_message.set_name('OZF', 'OZF_FUND_DUPLICATE_ID');

3626: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3627: IF p_fund_rec.fund_type = 'QUOTA' THEN
3628: fnd_message.set_name('OZF', 'OZF_TP_DUPLICATE_ID');
3629: ELSE
3630: fnd_message.set_name('OZF', 'OZF_FUND_DUPLICATE_ID');
3631: END IF;
3632: fnd_msg_pub.add;
3633: END IF;
3634:

Line 3666: fnd_message.set_name('OZF', 'OZF_TP_DUPLICATE_NUMBER');

3662:
3663: IF l_valid_flag = 1 THEN
3664: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3665: IF p_fund_rec.fund_type = 'QUOTA' THEN
3666: fnd_message.set_name('OZF', 'OZF_TP_DUPLICATE_NUMBER');
3667: ELSE
3668: fnd_message.set_name('OZF', 'OZF_FUND_DUPLICATE_NUMBER');
3669: END IF;
3670: fnd_msg_pub.add;

Line 3668: fnd_message.set_name('OZF', 'OZF_FUND_DUPLICATE_NUMBER');

3664: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3665: IF p_fund_rec.fund_type = 'QUOTA' THEN
3666: fnd_message.set_name('OZF', 'OZF_TP_DUPLICATE_NUMBER');
3667: ELSE
3668: fnd_message.set_name('OZF', 'OZF_FUND_DUPLICATE_NUMBER');
3669: END IF;
3670: fnd_msg_pub.add;
3671: END IF;
3672:

Line 3699: fnd_message.set_name('OZF', 'OZF_TP_DUPLICATE_NAME');

3695:
3696: IF l_valid_flag = fnd_api.g_false THEN
3697: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3698: IF p_fund_rec.fund_type = 'QUOTA' THEN
3699: fnd_message.set_name('OZF', 'OZF_TP_DUPLICATE_NAME');
3700: ELSE
3701: fnd_message.set_name('OZF', 'OZF_FUND_DUPLICATE_NAME');
3702: END IF;
3703: fnd_msg_pub.add;

Line 3701: fnd_message.set_name('OZF', 'OZF_FUND_DUPLICATE_NAME');

3697: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3698: IF p_fund_rec.fund_type = 'QUOTA' THEN
3699: fnd_message.set_name('OZF', 'OZF_TP_DUPLICATE_NAME');
3700: ELSE
3701: fnd_message.set_name('OZF', 'OZF_FUND_DUPLICATE_NAME');
3702: END IF;
3703: fnd_msg_pub.add;
3704: END IF;
3705:

Line 3737: fnd_message.set_name('OZF', 'OZF_FUND_BAD_USER_STATUS_ID');

3733: ,'user_status_id'
3734: ,p_fund_rec.user_status_id) =
3735: fnd_api.g_false THEN
3736: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3737: fnd_message.set_name('OZF', 'OZF_FUND_BAD_USER_STATUS_ID');
3738: fnd_msg_pub.add;
3739: END IF;
3740:
3741: x_return_status := fnd_api.g_ret_sts_error;

Line 3757: fnd_message.set_name('OZF', 'OZF_FUND_BAD_CAT_ID');

3753: ,'category_id'
3754: ,p_fund_rec.category_id) =
3755: fnd_api.g_false THEN
3756: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3757: fnd_message.set_name('OZF', 'OZF_FUND_BAD_CAT_ID');
3758: fnd_msg_pub.add;
3759: END IF;
3760:
3761: x_return_status := fnd_api.g_ret_sts_error;

Line 3796: fnd_message.set_name('OZF', 'OZF_TP_BAD_QUOTA_TYPE');

3792: ,p_lookup_code => p_fund_rec.fund_type) =
3793: fnd_api.g_false THEN
3794: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3795: IF p_fund_rec.fund_type = 'QUOTA' THEN
3796: fnd_message.set_name('OZF', 'OZF_TP_BAD_QUOTA_TYPE');
3797: ELSE
3798: fnd_message.set_name('OZF', 'OZF_FUND_BAD_FUND_TYPE');
3799: END IF;
3800: fnd_msg_pub.add;

Line 3798: fnd_message.set_name('OZF', 'OZF_FUND_BAD_FUND_TYPE');

3794: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3795: IF p_fund_rec.fund_type = 'QUOTA' THEN
3796: fnd_message.set_name('OZF', 'OZF_TP_BAD_QUOTA_TYPE');
3797: ELSE
3798: fnd_message.set_name('OZF', 'OZF_FUND_BAD_FUND_TYPE');
3799: END IF;
3800: fnd_msg_pub.add;
3801: END IF;
3802:

Line 3818: fnd_message.set_name('OZF', 'OZF_TP_BAD_STATUS_CODE');

3814: ,p_lookup_code => p_fund_rec.status_code) =
3815: fnd_api.g_false THEN
3816: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3817: IF p_fund_rec.fund_type = 'QUOTA' THEN
3818: fnd_message.set_name('OZF', 'OZF_TP_BAD_STATUS_CODE');
3819: ELSE
3820: fnd_message.set_name('OZF', 'OZF_FUND_BAD_STATUS_CODE');
3821: END IF;
3822: fnd_msg_pub.add;

Line 3820: fnd_message.set_name('OZF', 'OZF_FUND_BAD_STATUS_CODE');

3816: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3817: IF p_fund_rec.fund_type = 'QUOTA' THEN
3818: fnd_message.set_name('OZF', 'OZF_TP_BAD_STATUS_CODE');
3819: ELSE
3820: fnd_message.set_name('OZF', 'OZF_FUND_BAD_STATUS_CODE');
3821: END IF;
3822: fnd_msg_pub.add;
3823: END IF;
3824:

Line 3854: fnd_message.set_name('OZF', 'OZF_FUND_BAD_LIABILITY_FLAG');

3850: IF p_fund_rec.liability_flag <> fnd_api.g_miss_char
3851: AND p_fund_rec.liability_flag IS NOT NULL THEN
3852: IF ozf_utility_pvt.is_y_or_n(p_fund_rec.liability_flag) = fnd_api.g_false THEN
3853: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3854: fnd_message.set_name('OZF', 'OZF_FUND_BAD_LIABILITY_FLAG');
3855: fnd_msg_pub.add;
3856: END IF;
3857:
3858: x_return_status := fnd_api.g_ret_sts_error;

Line 3869: fnd_message.set_name('OZF', 'OZF_TP_BAD_QUOTA_FLAG');

3865: AND p_fund_rec.budget_flag IS NOT NULL THEN
3866: IF ozf_utility_pvt.is_y_or_n(p_fund_rec.budget_flag) = fnd_api.g_false THEN
3867: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3868: IF p_fund_rec.fund_type = 'QUOTA' THEN
3869: fnd_message.set_name('OZF', 'OZF_TP_BAD_QUOTA_FLAG');
3870: ELSE
3871: fnd_message.set_name('OZF', 'OZF_FUND_BAD_BUDGET_FLAG');
3872: END IF;
3873: fnd_msg_pub.add;

Line 3871: fnd_message.set_name('OZF', 'OZF_FUND_BAD_BUDGET_FLAG');

3867: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3868: IF p_fund_rec.fund_type = 'QUOTA' THEN
3869: fnd_message.set_name('OZF', 'OZF_TP_BAD_QUOTA_FLAG');
3870: ELSE
3871: fnd_message.set_name('OZF', 'OZF_FUND_BAD_BUDGET_FLAG');
3872: END IF;
3873: fnd_msg_pub.add;
3874: END IF;
3875:

Line 3886: fnd_message.set_name('OZF', 'OZF_FUND_BAD_EARNED_FLAG');

3882: IF p_fund_rec.earned_flag <> fnd_api.g_miss_char
3883: AND p_fund_rec.earned_flag IS NOT NULL THEN
3884: IF ozf_utility_pvt.is_y_or_n(p_fund_rec.earned_flag) = fnd_api.g_false THEN
3885: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3886: fnd_message.set_name('OZF', 'OZF_FUND_BAD_EARNED_FLAG');
3887: fnd_msg_pub.add;
3888: END IF;
3889:
3890: x_return_status := fnd_api.g_ret_sts_error;

Line 4012: fnd_message.set_name('OZF', 'OZF_FUND_STARTDATE_MISMATCH');

4008: -- yzhao 07/15/2002 fix bug 2457199 UNABLE TO CREATE FULLY ACCRUED BUDGET DUE TO START DATE PROB
4009: -- start date passed in is midnight of the selected day. So trunc sysdate to get midnight time
4010: IF NVL(l_start_date, sysdate) < trunc(sysdate) THEN
4011: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
4012: fnd_message.set_name('OZF', 'OZF_FUND_STARTDATE_MISMATCH');
4013: fnd_msg_pub.add;
4014: END IF;
4015:
4016: x_return_status := fnd_api.g_ret_sts_error;

Line 4046: fnd_message.set_name('OZF', 'OZF_TP_ENDDATE_MISMATCH');

4042: --IF NVL(l_end_date,sysdate) < trunc(sysdate) THEN
4043: IF NVL(l_end_date,sysdate) < trunc(sysdate) AND p_fund_rec.prev_fund_id IS NULL THEN
4044: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
4045: IF p_fund_rec.fund_type = 'QUOTA' THEN
4046: fnd_message.set_name('OZF', 'OZF_TP_ENDDATE_MISMATCH');
4047: ELSE
4048: fnd_message.set_name('OZF', 'OZF_FUND_ENDDATE_MISMATCH');
4049: END IF;
4050: fnd_msg_pub.add;

Line 4048: fnd_message.set_name('OZF', 'OZF_FUND_ENDDATE_MISMATCH');

4044: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
4045: IF p_fund_rec.fund_type = 'QUOTA' THEN
4046: fnd_message.set_name('OZF', 'OZF_TP_ENDDATE_MISMATCH');
4047: ELSE
4048: fnd_message.set_name('OZF', 'OZF_FUND_ENDDATE_MISMATCH');
4049: END IF;
4050: fnd_msg_pub.add;
4051: END IF;
4052: x_return_status := fnd_api.g_ret_sts_error;

Line 4064: fnd_message.set_name('OZF', 'OZF_ACTIVE_FUND_AMT');

4060: FETCH c_old_status INTO l_fund_old_status, l_fund_old_amount;
4061: CLOSE c_old_status;
4062:
4063: IF l_fund_old_status = 'ACTIVE' AND p_complete_rec.original_budget <> l_fund_old_amount THEN
4064: fnd_message.set_name('OZF', 'OZF_ACTIVE_FUND_AMT');
4065: fnd_msg_pub.add;
4066: x_return_status := fnd_api.g_ret_sts_error;
4067: END IF;
4068: END IF;

Line 4073: fnd_message.set_name('OZF', 'OZF_TP_MAX_AMT_EXCEEDED');

4069: */
4070: --original amount should be within 15 digits
4071: IF p_complete_rec.original_budget > 999999999999999 THEN
4072: IF p_fund_rec.fund_type = 'QUOTA' THEN
4073: fnd_message.set_name('OZF', 'OZF_TP_MAX_AMT_EXCEEDED');
4074: ELSE
4075: fnd_message.set_name('OZF', 'OZF_FUND_MAX_AMT_EXCEEDED');
4076: END IF;
4077: fnd_msg_pub.add;

Line 4075: fnd_message.set_name('OZF', 'OZF_FUND_MAX_AMT_EXCEEDED');

4071: IF p_complete_rec.original_budget > 999999999999999 THEN
4072: IF p_fund_rec.fund_type = 'QUOTA' THEN
4073: fnd_message.set_name('OZF', 'OZF_TP_MAX_AMT_EXCEEDED');
4074: ELSE
4075: fnd_message.set_name('OZF', 'OZF_FUND_MAX_AMT_EXCEEDED');
4076: END IF;
4077: fnd_msg_pub.add;
4078: x_return_status := fnd_api.g_ret_sts_error;
4079: END IF;

Line 4083: fnd_message.set_name('OZF', 'OZF_FUND_DATE_MISMATCH');

4079: END IF;
4080:
4081: IF l_start_date > l_end_date THEN
4082: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
4083: fnd_message.set_name('OZF', 'OZF_FUND_DATE_MISMATCH');
4084: fnd_msg_pub.add;
4085: END IF;
4086:
4087: x_return_status := fnd_api.g_ret_sts_error;

Line 4096: fnd_message.set_name('OZF', 'OZF_TP_WRONG_PARENT');

4092: AND p_fund_rec.parent_fund_id IS NOT NULL THEN
4093: IF p_complete_rec.fund_id = p_complete_rec.parent_fund_id THEN
4094: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
4095: IF p_fund_rec.fund_type = 'QUOTA' THEN
4096: fnd_message.set_name('OZF', 'OZF_TP_WRONG_PARENT');
4097: ELSE
4098: fnd_message.set_name('OZF', 'OZF_FUND_WRONG_PARENT');
4099: END IF;
4100: fnd_msg_pub.add;

Line 4098: fnd_message.set_name('OZF', 'OZF_FUND_WRONG_PARENT');

4094: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
4095: IF p_fund_rec.fund_type = 'QUOTA' THEN
4096: fnd_message.set_name('OZF', 'OZF_TP_WRONG_PARENT');
4097: ELSE
4098: fnd_message.set_name('OZF', 'OZF_FUND_WRONG_PARENT');
4099: END IF;
4100: fnd_msg_pub.add;
4101: x_return_status := fnd_api.g_ret_sts_error;
4102: END IF;

Line 4121: fnd_message.set_name('OZF', 'OZF_EXCESS_HOLDBACK_AMT');

4117: ( NVL(p_complete_rec.original_budget, 0) +
4118: NVL(p_complete_rec.transfered_in_amt, 0) -
4119: NVL(p_complete_rec.transfered_out_amt, 0)) THEN
4120: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
4121: fnd_message.set_name('OZF', 'OZF_EXCESS_HOLDBACK_AMT');
4122: fnd_msg_pub.add;
4123: END IF;
4124: x_return_status := fnd_api.g_ret_sts_error;
4125: END IF;

Line 4130: fnd_message.set_name('OZF', 'OZF_FUND_NO_HOLDBACK_BUDGET');

4126: END IF;
4127:
4128: -- hold back amount should not be negative fix for bug#3352216
4129: IF p_complete_rec.holdback_amt < 0 THEN
4130: fnd_message.set_name('OZF', 'OZF_FUND_NO_HOLDBACK_BUDGET');
4131: fnd_msg_pub.add;
4132: x_return_status := fnd_api.g_ret_sts_error;
4133: END IF;
4134:

Line 4138: fnd_message.set_name('OZF', 'OZF_EXCESS_HOLDBACK_AMT');

4134:
4135: ELSE
4136: IF p_complete_rec.holdback_amt > (NVL(p_complete_rec.original_budget, 0)) THEN
4137: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
4138: fnd_message.set_name('OZF', 'OZF_EXCESS_HOLDBACK_AMT');
4139: fnd_msg_pub.add;
4140: END IF;
4141:
4142: x_return_status := fnd_api.g_ret_sts_error;

Line 4148: fnd_message.set_name('OZF', 'OZF_FUND_NO_HOLDBACK_BUDGET');

4144: END IF;
4145:
4146: -- holdback amount should not be negative. Fix for bug#3352216
4147: IF p_complete_rec.holdback_amt < 0 THEN
4148: fnd_message.set_name('OZF', 'OZF_FUND_NO_HOLDBACK_BUDGET');
4149: fnd_msg_pub.add;
4150: x_return_status := fnd_api.g_ret_sts_error;
4151: END IF;
4152:

Line 4165: fnd_message.set_name('OZF', 'OZF_ACCRUAL_NO_ORG_BUDGET');

4161: IF NVL(p_complete_rec.original_budget, 0) <> 0 AND p_complete_rec.status_code IN ('DRAFT','CLOSED','CANCELLED','ARCHIVED') THEN
4162: */
4163: IF NVL(p_complete_rec.original_budget, 0) <> 0 AND p_complete_rec.status_code = 'DRAFT' THEN
4164: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
4165: fnd_message.set_name('OZF', 'OZF_ACCRUAL_NO_ORG_BUDGET');
4166: fnd_msg_pub.add;
4167: END IF;
4168:
4169: x_return_status := fnd_api.g_ret_sts_error;

Line 4174: fnd_message.set_name('OZF', 'OZF_ACCRUAL_NO_BASIS');

4170: END IF;
4171: /* 11.5.9
4172: IF p_complete_rec.accrual_basis IS NULL THEN
4173: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
4174: fnd_message.set_name('OZF', 'OZF_ACCRUAL_NO_BASIS');
4175: fnd_msg_pub.add;
4176: END IF;
4177:
4178: x_return_status := fnd_api.g_ret_sts_error;

Line 4183: fnd_message.set_name('OZF', 'OZF_ACCRUAL_NO_OPERAND');

4179: END IF;*/
4180: /*
4181: IF p_complete_rec.accrual_operand IS NULL THEN
4182: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
4183: fnd_message.set_name('OZF', 'OZF_ACCRUAL_NO_OPERAND');
4184: fnd_msg_pub.add;
4185: END IF;
4186:
4187: x_return_status := fnd_api.g_ret_sts_error;

Line 4193: fnd_message.set_name('OZF', 'OZF_ACCRUAL_NO_UOM');

4189: */
4190: /* -- we donot need to give the UOM
4191: IF p_complete_rec.accrual_uom IS NULL THEN
4192: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
4193: fnd_message.set_name('OZF', 'OZF_ACCRUAL_NO_UOM');
4194: fnd_msg_pub.add;
4195: END IF;
4196:
4197: x_return_status := fnd_api.g_ret_sts_error;

Line 4204: fnd_message.set_name('OZF', 'OZF_ACCRUAL_NO_PHASE');

4200: /*
4201: -- sangara - R12 enhancement - not mandatory, as they are moved to Market Options cuecard
4202: IF p_complete_rec.accrual_phase IS NULL THEN
4203: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
4204: fnd_message.set_name('OZF', 'OZF_ACCRUAL_NO_PHASE');
4205: fnd_msg_pub.add;
4206: END IF;
4207:
4208: x_return_status := fnd_api.g_ret_sts_error;

Line 4214: fnd_message.set_name('OZF', 'OZF_ACCRUAL_NO_RATE');

4210: */
4211: /*
4212: IF NVL(p_complete_rec.accrual_rate, 0) <= 0 THEN
4213: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
4214: fnd_message.set_name('OZF', 'OZF_ACCRUAL_NO_RATE');
4215: fnd_msg_pub.add;
4216: END IF;
4217:
4218: x_return_status := fnd_api.g_ret_sts_error;

Line 4224: fnd_message.set_name('OZF', 'OZF_ACCRUAL_NO_QUANTITY');

4220: -- default the quantity to 1
4221: /*
4222: IF NVL(p_complete_rec.accrual_quantity, 0) <= 0 THEN
4223: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
4224: fnd_message.set_name('OZF', 'OZF_ACCRUAL_NO_QUANTITY');
4225: fnd_msg_pub.add;
4226: END IF;
4227:
4228: x_return_status := fnd_api.g_ret_sts_error;

Line 4263: fnd_message.set_name('OZF', 'OZF_TP_ILLEGAL_OWNER');

4259: ,'USER') <>
4260: 'F' THEN
4261: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
4262: IF p_fund_rec.fund_type = 'QUOTA' THEN
4263: fnd_message.set_name('OZF', 'OZF_TP_ILLEGAL_OWNER');
4264: ELSE
4265: fnd_message.set_name('OZF', 'OZF_FUND_ILLEGAL_OWNER');
4266: END IF;
4267: fnd_msg_pub.add;

Line 4265: fnd_message.set_name('OZF', 'OZF_FUND_ILLEGAL_OWNER');

4261: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
4262: IF p_fund_rec.fund_type = 'QUOTA' THEN
4263: fnd_message.set_name('OZF', 'OZF_TP_ILLEGAL_OWNER');
4264: ELSE
4265: fnd_message.set_name('OZF', 'OZF_FUND_ILLEGAL_OWNER');
4266: END IF;
4267: fnd_msg_pub.add;
4268: END IF;
4269:

Line 4274: fnd_message.set_name('OZF', 'OZF_NO_RESOURCE_ID');

4270: x_return_status := fnd_api.g_ret_sts_error;
4271: END IF;
4272: ELSIF l_resource_id = -1 THEN
4273: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
4274: fnd_message.set_name('OZF', 'OZF_NO_RESOURCE_ID');
4275: fnd_msg_pub.add;
4276: END IF;
4277:
4278: x_return_status := fnd_api.g_ret_sts_error;

Line 4295: fnd_message.set_name('OZF', 'OZF_BUDGET_OFFR_LEDG_MISMATCH');

4291: p_ledger_name => l_offer_ledgerName
4292: );
4293: IF p_complete_rec.ledger_id <> l_offer_ledger THEN
4294: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
4295: fnd_message.set_name('OZF', 'OZF_BUDGET_OFFR_LEDG_MISMATCH');
4296: fnd_msg_pub.add;
4297: END IF;
4298: x_return_status := fnd_api.g_ret_sts_error;
4299: END IF;

Line 4524: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

4520: IF c_fund%NOTFOUND THEN
4521: CLOSE c_fund;
4522:
4523: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
4524: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
4525: fnd_msg_pub.add;
4526: END IF;
4527:
4528: RAISE fnd_api.g_exc_error;

Line 5836: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

5832: AND object_version_number = fund.object_version_number;
5833:
5834: IF (SQL%NOTFOUND) THEN
5835: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
5836: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
5837: fnd_msg_pub.add;
5838: END IF;
5839:
5840: RAISE fnd_api.g_exc_error;