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 236: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

232: CLOSE c_parent_number;
233:
234: IF l_par_number IS NULL THEN
235: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
236: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
237: fnd_msg_pub.add;
238: END IF;
239:
240: x_return_status := fnd_api.g_ret_sts_error;

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

537:
538: IF g_universal_currency IS NULL THEN
539:
540: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
541: fnd_message.set_name('OZF', 'OZF_UNIV_CURR_NOT_FOUND');
542: fnd_msg_pub.add;
543: END IF;
544:
545: RAISE fnd_api.g_exc_error;

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

1215: AND object_version_number = p_object_version;
1216:
1217: IF (SQL%NOTFOUND) THEN
1218: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1219: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1220: fnd_msg_pub.add;
1221: END IF;
1222:
1223: RAISE fnd_api.g_exc_error;

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

1228: WHERE fund_id = p_fund_id;
1229:
1230: IF (SQL%NOTFOUND) THEN
1231: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1232: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1233: fnd_msg_pub.add;
1234: END IF;
1235:
1236: RAISE fnd_api.g_exc_error;

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

1340: IF (c_fund_b%NOTFOUND) THEN
1341: CLOSE c_fund_b;
1342:
1343: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1344: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1345: fnd_msg_pub.add;
1346: END IF;
1347:
1348: RAISE fnd_api.g_exc_error;

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

1363: WHEN ozf_utility_pvt.resource_locked THEN
1364: x_return_status := fnd_api.g_ret_sts_error;
1365:
1366: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1367: fnd_message.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');
1368: fnd_msg_pub.add;
1369: END IF;
1370:
1371: fnd_msg_pub.count_and_get(

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

1688: l_fund_rec.status_code := l_status_code;
1689: END IF;
1690:
1691: --Added for bug 7425189
1692: l_fund_reconc_msg := fnd_message.get_string ('OZF', 'OZF_FUND_RECONCILE');
1693: l_act_bud_cst_msg := fnd_message.get_string ('OZF', 'OZF_ACT_BUDG_CST_UTIL');
1694:
1695: --changed by mpande
1696: -- Fetch the old status code and old parentID

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

1689: END IF;
1690:
1691: --Added for bug 7425189
1692: l_fund_reconc_msg := fnd_message.get_string ('OZF', 'OZF_FUND_RECONCILE');
1693: l_act_bud_cst_msg := fnd_message.get_string ('OZF', 'OZF_ACT_BUDG_CST_UTIL');
1694:
1695: --changed by mpande
1696: -- Fetch the old status code and old parentID
1697: OPEN c_old_status(p_fund_rec.fund_id);

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

2494: AND object_version_number = l_fund_rec.object_version_number;
2495:
2496: IF (SQL%NOTFOUND) THEN
2497: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2498: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
2499: fnd_msg_pub.add;
2500: END IF;
2501:
2502: RAISE fnd_api.g_exc_error;

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

2518: AND USERENV('LANG') IN(language, source_lang);
2519:
2520: IF (SQL%NOTFOUND) THEN
2521: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2522: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
2523: fnd_msg_pub.add;
2524: END IF;
2525:
2526: RAISE fnd_api.g_exc_error;

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

3069: ------------------------ fund_number --------------------------
3070: /* IF p_fund_rec.fund_number IS NULL THEN -- check for fund number
3071: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3072: IF p_fund_rec.fund_type = 'QUOTA' THEN
3073: fnd_message.set_name('OZF', 'OZF_TP_NO_QUOTA_NUMBER');
3074: ELSE
3075: fnd_message.set_name('OZF', 'OZF_FUND_NO_FUND_NUMBER');
3076: END IF;
3077: fnd_msg_pub.add;

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

3071: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3072: IF p_fund_rec.fund_type = 'QUOTA' THEN
3073: fnd_message.set_name('OZF', 'OZF_TP_NO_QUOTA_NUMBER');
3074: ELSE
3075: fnd_message.set_name('OZF', 'OZF_FUND_NO_FUND_NUMBER');
3076: END IF;
3077: fnd_msg_pub.add;
3078: END IF;
3079:

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

3084: ------------------------ owner -------------------------------
3085: IF p_fund_rec.owner IS NULL THEN -- check for fund owner
3086: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3087: IF p_fund_rec.fund_type = 'QUOTA' THEN
3088: fnd_message.set_name('OZF', 'OZF_TP_NO_QUOTA_OWNER');
3089: ELSE
3090: fnd_message.set_name('OZF', 'OZF_FUND_NO_FUND_OWNER');
3091: END IF;
3092: fnd_msg_pub.add;

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

3086: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3087: IF p_fund_rec.fund_type = 'QUOTA' THEN
3088: fnd_message.set_name('OZF', 'OZF_TP_NO_QUOTA_OWNER');
3089: ELSE
3090: fnd_message.set_name('OZF', 'OZF_FUND_NO_FUND_OWNER');
3091: END IF;
3092: fnd_msg_pub.add;
3093: END IF;
3094:

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

3097: END IF;
3098:
3099: IF p_fund_rec.fund_type IS NULL THEN -- check for fund owner
3100: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3101: fnd_message.set_name('OZF', 'OZF_FUND_NO_FUND_TYPE');
3102: fnd_msg_pub.add;
3103: END IF;
3104:
3105: x_return_status := fnd_api.g_ret_sts_error;

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

3108:
3109: -- 09/20/2000 Mumu Pande for user status
3110: IF p_fund_rec.user_status_id IS NULL THEN -- check for fund user status
3111: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3112: fnd_message.set_name('OZF', 'OZF_FUND_NO_USER_STATUS');
3113: fnd_msg_pub.add;
3114: END IF;
3115:
3116: x_return_status := fnd_api.g_ret_sts_error;

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

3119:
3120: -- 01/20/2001 Mumu Pande for category
3121: IF p_fund_rec.fund_type <> 'QUOTA' AND p_fund_rec.category_id IS NULL THEN -- check for fund category
3122: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3123: fnd_message.set_name('OZF', 'OZF_FUND_NO_CATEGORY');
3124: fnd_msg_pub.add;
3125: END IF;
3126:
3127: x_return_status := fnd_api.g_ret_sts_error;

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

3129: END IF;
3130: -- 01/20/2001 Mumu Pande for custom_setup_id
3131: IF p_fund_rec.custom_setup_id IS NULL THEN -- check for fund category
3132: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3133: fnd_message.set_name('OZF', 'OZF_FUND_NO_CUSTOM_SETUP');
3134: fnd_msg_pub.add;
3135: END IF;
3136:
3137: x_return_status := fnd_api.g_ret_sts_error;

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

3146: -- rimehrot changed back to <= for bug fix 3580531
3147: IF NVL(p_fund_rec.original_budget,0) <= 0 THEN -- check for fund amount
3148: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3149: IF p_fund_rec.fund_type = 'QUOTA' THEN
3150: fnd_message.set_name('OZF', 'OZF_TP_NO_ORG_QUOTA');
3151: ELSE
3152: fnd_message.set_name('OZF', 'OZF_FUND_NO_ORG_BUDGET');
3153: END IF;
3154: fnd_msg_pub.add;

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

3148: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3149: IF p_fund_rec.fund_type = 'QUOTA' THEN
3150: fnd_message.set_name('OZF', 'OZF_TP_NO_ORG_QUOTA');
3151: ELSE
3152: fnd_message.set_name('OZF', 'OZF_FUND_NO_ORG_BUDGET');
3153: END IF;
3154: fnd_msg_pub.add;
3155: END IF;
3156:

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

3161:
3162: --kdass 25-APR-2006 bug 5176819 - Ledger is required field
3163: IF p_fund_rec.fund_type <> 'QUOTA' AND p_fund_rec.ledger_id IS NULL THEN
3164: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3165: fnd_message.set_name('OZF', 'OZF_FUND_NO_LEDGER');
3166: fnd_msg_pub.add;
3167: END IF;
3168:
3169: x_return_status := fnd_api.g_ret_sts_error;

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

3173: /* yzhao: bug 4669461: R12 budget is org aware, but not org stripped. quota is not org aware
3174: so org_id is not required
3175: IF p_fund_rec.org_id IS NULL THEN -- check for org id
3176: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3177: fnd_message.set_name('OZF', 'OZF_NO_DEFAULT_ORG_ID');
3178: fnd_msg_pub.add;
3179: END IF;
3180:
3181: x_return_status := fnd_api.g_ret_sts_error;

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

3225: ,'fund_id = ' || p_fund_rec.fund_id) =
3226: fnd_api.g_false THEN
3227: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3228: IF p_fund_rec.fund_type = 'QUOTA' THEN
3229: fnd_message.set_name('OZF', 'OZF_TP_DUPLICATE_ID');
3230: ELSE
3231: fnd_message.set_name('OZF', 'OZF_FUND_DUPLICATE_ID');
3232: END IF;
3233: fnd_msg_pub.add;

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

3227: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3228: IF p_fund_rec.fund_type = 'QUOTA' THEN
3229: fnd_message.set_name('OZF', 'OZF_TP_DUPLICATE_ID');
3230: ELSE
3231: fnd_message.set_name('OZF', 'OZF_FUND_DUPLICATE_ID');
3232: END IF;
3233: fnd_msg_pub.add;
3234: END IF;
3235:

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

3263:
3264: IF l_valid_flag = 1 THEN
3265: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3266: IF p_fund_rec.fund_type = 'QUOTA' THEN
3267: fnd_message.set_name('OZF', 'OZF_TP_DUPLICATE_NUMBER');
3268: ELSE
3269: fnd_message.set_name('OZF', 'OZF_FUND_DUPLICATE_NUMBER');
3270: END IF;
3271: fnd_msg_pub.add;

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

3265: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3266: IF p_fund_rec.fund_type = 'QUOTA' THEN
3267: fnd_message.set_name('OZF', 'OZF_TP_DUPLICATE_NUMBER');
3268: ELSE
3269: fnd_message.set_name('OZF', 'OZF_FUND_DUPLICATE_NUMBER');
3270: END IF;
3271: fnd_msg_pub.add;
3272: END IF;
3273:

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

3296:
3297: IF l_valid_flag = fnd_api.g_false THEN
3298: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3299: IF p_fund_rec.fund_type = 'QUOTA' THEN
3300: fnd_message.set_name('OZF', 'OZF_TP_DUPLICATE_NAME');
3301: ELSE
3302: fnd_message.set_name('OZF', 'OZF_FUND_DUPLICATE_NAME');
3303: END IF;
3304: fnd_msg_pub.add;

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

3298: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3299: IF p_fund_rec.fund_type = 'QUOTA' THEN
3300: fnd_message.set_name('OZF', 'OZF_TP_DUPLICATE_NAME');
3301: ELSE
3302: fnd_message.set_name('OZF', 'OZF_FUND_DUPLICATE_NAME');
3303: END IF;
3304: fnd_msg_pub.add;
3305: END IF;
3306:

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

3334: ,'user_status_id'
3335: ,p_fund_rec.user_status_id) =
3336: fnd_api.g_false THEN
3337: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3338: fnd_message.set_name('OZF', 'OZF_FUND_BAD_USER_STATUS_ID');
3339: fnd_msg_pub.add;
3340: END IF;
3341:
3342: x_return_status := fnd_api.g_ret_sts_error;

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

3354: ,'category_id'
3355: ,p_fund_rec.category_id) =
3356: fnd_api.g_false THEN
3357: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3358: fnd_message.set_name('OZF', 'OZF_FUND_BAD_CAT_ID');
3359: fnd_msg_pub.add;
3360: END IF;
3361:
3362: x_return_status := fnd_api.g_ret_sts_error;

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

3393: ,p_lookup_code => p_fund_rec.fund_type) =
3394: fnd_api.g_false THEN
3395: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3396: IF p_fund_rec.fund_type = 'QUOTA' THEN
3397: fnd_message.set_name('OZF', 'OZF_TP_BAD_QUOTA_TYPE');
3398: ELSE
3399: fnd_message.set_name('OZF', 'OZF_FUND_BAD_FUND_TYPE');
3400: END IF;
3401: fnd_msg_pub.add;

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

3395: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3396: IF p_fund_rec.fund_type = 'QUOTA' THEN
3397: fnd_message.set_name('OZF', 'OZF_TP_BAD_QUOTA_TYPE');
3398: ELSE
3399: fnd_message.set_name('OZF', 'OZF_FUND_BAD_FUND_TYPE');
3400: END IF;
3401: fnd_msg_pub.add;
3402: END IF;
3403:

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

3415: ,p_lookup_code => p_fund_rec.status_code) =
3416: fnd_api.g_false THEN
3417: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3418: IF p_fund_rec.fund_type = 'QUOTA' THEN
3419: fnd_message.set_name('OZF', 'OZF_TP_BAD_STATUS_CODE');
3420: ELSE
3421: fnd_message.set_name('OZF', 'OZF_FUND_BAD_STATUS_CODE');
3422: END IF;
3423: fnd_msg_pub.add;

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

3417: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3418: IF p_fund_rec.fund_type = 'QUOTA' THEN
3419: fnd_message.set_name('OZF', 'OZF_TP_BAD_STATUS_CODE');
3420: ELSE
3421: fnd_message.set_name('OZF', 'OZF_FUND_BAD_STATUS_CODE');
3422: END IF;
3423: fnd_msg_pub.add;
3424: END IF;
3425:

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

3451: IF p_fund_rec.liability_flag <> fnd_api.g_miss_char
3452: AND p_fund_rec.liability_flag IS NOT NULL THEN
3453: IF ozf_utility_pvt.is_y_or_n(p_fund_rec.liability_flag) = fnd_api.g_false THEN
3454: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3455: fnd_message.set_name('OZF', 'OZF_FUND_BAD_LIABILITY_FLAG');
3456: fnd_msg_pub.add;
3457: END IF;
3458:
3459: x_return_status := fnd_api.g_ret_sts_error;

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

3466: AND p_fund_rec.budget_flag IS NOT NULL THEN
3467: IF ozf_utility_pvt.is_y_or_n(p_fund_rec.budget_flag) = fnd_api.g_false THEN
3468: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3469: IF p_fund_rec.fund_type = 'QUOTA' THEN
3470: fnd_message.set_name('OZF', 'OZF_TP_BAD_QUOTA_FLAG');
3471: ELSE
3472: fnd_message.set_name('OZF', 'OZF_FUND_BAD_BUDGET_FLAG');
3473: END IF;
3474: fnd_msg_pub.add;

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

3468: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3469: IF p_fund_rec.fund_type = 'QUOTA' THEN
3470: fnd_message.set_name('OZF', 'OZF_TP_BAD_QUOTA_FLAG');
3471: ELSE
3472: fnd_message.set_name('OZF', 'OZF_FUND_BAD_BUDGET_FLAG');
3473: END IF;
3474: fnd_msg_pub.add;
3475: END IF;
3476:

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

3483: IF p_fund_rec.earned_flag <> fnd_api.g_miss_char
3484: AND p_fund_rec.earned_flag IS NOT NULL THEN
3485: IF ozf_utility_pvt.is_y_or_n(p_fund_rec.earned_flag) = fnd_api.g_false THEN
3486: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3487: fnd_message.set_name('OZF', 'OZF_FUND_BAD_EARNED_FLAG');
3488: fnd_msg_pub.add;
3489: END IF;
3490:
3491: x_return_status := fnd_api.g_ret_sts_error;

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

3606: -- yzhao 07/15/2002 fix bug 2457199 UNABLE TO CREATE FULLY ACCRUED BUDGET DUE TO START DATE PROB
3607: -- start date passed in is midnight of the selected day. So trunc sysdate to get midnight time
3608: IF NVL(l_start_date, sysdate) < trunc(sysdate) THEN
3609: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3610: fnd_message.set_name('OZF', 'OZF_FUND_STARTDATE_MISMATCH');
3611: fnd_msg_pub.add;
3612: END IF;
3613:
3614: x_return_status := fnd_api.g_ret_sts_error;

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

3640: --IF NVL(l_end_date,sysdate) < trunc(sysdate) THEN
3641: IF NVL(l_end_date,sysdate) < trunc(sysdate) AND p_fund_rec.prev_fund_id IS NULL THEN
3642: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3643: IF p_fund_rec.fund_type = 'QUOTA' THEN
3644: fnd_message.set_name('OZF', 'OZF_TP_ENDDATE_MISMATCH');
3645: ELSE
3646: fnd_message.set_name('OZF', 'OZF_FUND_ENDDATE_MISMATCH');
3647: END IF;
3648: fnd_msg_pub.add;

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

3642: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3643: IF p_fund_rec.fund_type = 'QUOTA' THEN
3644: fnd_message.set_name('OZF', 'OZF_TP_ENDDATE_MISMATCH');
3645: ELSE
3646: fnd_message.set_name('OZF', 'OZF_FUND_ENDDATE_MISMATCH');
3647: END IF;
3648: fnd_msg_pub.add;
3649: END IF;
3650: x_return_status := fnd_api.g_ret_sts_error;

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

3658: FETCH c_old_status INTO l_fund_old_status, l_fund_old_amount;
3659: CLOSE c_old_status;
3660:
3661: IF l_fund_old_status = 'ACTIVE' AND p_complete_rec.original_budget <> l_fund_old_amount THEN
3662: fnd_message.set_name('OZF', 'OZF_ACTIVE_FUND_AMT');
3663: fnd_msg_pub.add;
3664: x_return_status := fnd_api.g_ret_sts_error;
3665: END IF;
3666: END IF;

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

3667: */
3668: --original amount should be within 15 digits
3669: IF p_complete_rec.original_budget > 999999999999999 THEN
3670: IF p_fund_rec.fund_type = 'QUOTA' THEN
3671: fnd_message.set_name('OZF', 'OZF_TP_MAX_AMT_EXCEEDED');
3672: ELSE
3673: fnd_message.set_name('OZF', 'OZF_FUND_MAX_AMT_EXCEEDED');
3674: END IF;
3675: fnd_msg_pub.add;

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

3669: IF p_complete_rec.original_budget > 999999999999999 THEN
3670: IF p_fund_rec.fund_type = 'QUOTA' THEN
3671: fnd_message.set_name('OZF', 'OZF_TP_MAX_AMT_EXCEEDED');
3672: ELSE
3673: fnd_message.set_name('OZF', 'OZF_FUND_MAX_AMT_EXCEEDED');
3674: END IF;
3675: fnd_msg_pub.add;
3676: x_return_status := fnd_api.g_ret_sts_error;
3677: END IF;

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

3677: END IF;
3678:
3679: IF l_start_date > l_end_date THEN
3680: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3681: fnd_message.set_name('OZF', 'OZF_FUND_DATE_MISMATCH');
3682: fnd_msg_pub.add;
3683: END IF;
3684:
3685: x_return_status := fnd_api.g_ret_sts_error;

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

3690: AND p_fund_rec.parent_fund_id IS NOT NULL THEN
3691: IF p_complete_rec.fund_id = p_complete_rec.parent_fund_id THEN
3692: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3693: IF p_fund_rec.fund_type = 'QUOTA' THEN
3694: fnd_message.set_name('OZF', 'OZF_TP_WRONG_PARENT');
3695: ELSE
3696: fnd_message.set_name('OZF', 'OZF_FUND_WRONG_PARENT');
3697: END IF;
3698: fnd_msg_pub.add;

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

3692: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3693: IF p_fund_rec.fund_type = 'QUOTA' THEN
3694: fnd_message.set_name('OZF', 'OZF_TP_WRONG_PARENT');
3695: ELSE
3696: fnd_message.set_name('OZF', 'OZF_FUND_WRONG_PARENT');
3697: END IF;
3698: fnd_msg_pub.add;
3699: x_return_status := fnd_api.g_ret_sts_error;
3700: END IF;

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

3715: ( NVL(p_complete_rec.original_budget, 0) +
3716: NVL(p_complete_rec.transfered_in_amt, 0) -
3717: NVL(p_complete_rec.transfered_out_amt, 0)) THEN
3718: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3719: fnd_message.set_name('OZF', 'OZF_EXCESS_HOLDBACK_AMT');
3720: fnd_msg_pub.add;
3721: END IF;
3722: x_return_status := fnd_api.g_ret_sts_error;
3723: END IF;

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

3724: END IF;
3725:
3726: -- hold back amount should not be negative fix for bug#3352216
3727: IF p_complete_rec.holdback_amt < 0 THEN
3728: fnd_message.set_name('OZF', 'OZF_FUND_NO_HOLDBACK_BUDGET');
3729: fnd_msg_pub.add;
3730: x_return_status := fnd_api.g_ret_sts_error;
3731: END IF;
3732:

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

3732:
3733: ELSE
3734: IF p_complete_rec.holdback_amt > (NVL(p_complete_rec.original_budget, 0)) THEN
3735: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3736: fnd_message.set_name('OZF', 'OZF_EXCESS_HOLDBACK_AMT');
3737: fnd_msg_pub.add;
3738: END IF;
3739:
3740: x_return_status := fnd_api.g_ret_sts_error;

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

3742: END IF;
3743:
3744: -- holdback amount should not be negative. Fix for bug#3352216
3745: IF p_complete_rec.holdback_amt < 0 THEN
3746: fnd_message.set_name('OZF', 'OZF_FUND_NO_HOLDBACK_BUDGET');
3747: fnd_msg_pub.add;
3748: x_return_status := fnd_api.g_ret_sts_error;
3749: END IF;
3750:

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

3759: IF NVL(p_complete_rec.original_budget, 0) <> 0 AND p_complete_rec.status_code IN ('DRAFT','CLOSED','CANCELLED','ARCHIVED') THEN
3760: */
3761: IF NVL(p_complete_rec.original_budget, 0) <> 0 AND p_complete_rec.status_code = 'DRAFT' THEN
3762: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3763: fnd_message.set_name('OZF', 'OZF_ACCRUAL_NO_ORG_BUDGET');
3764: fnd_msg_pub.add;
3765: END IF;
3766:
3767: x_return_status := fnd_api.g_ret_sts_error;

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

3768: END IF;
3769: /* 11.5.9
3770: IF p_complete_rec.accrual_basis IS NULL THEN
3771: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3772: fnd_message.set_name('OZF', 'OZF_ACCRUAL_NO_BASIS');
3773: fnd_msg_pub.add;
3774: END IF;
3775:
3776: x_return_status := fnd_api.g_ret_sts_error;

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

3777: END IF;*/
3778: /*
3779: IF p_complete_rec.accrual_operand IS NULL THEN
3780: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3781: fnd_message.set_name('OZF', 'OZF_ACCRUAL_NO_OPERAND');
3782: fnd_msg_pub.add;
3783: END IF;
3784:
3785: x_return_status := fnd_api.g_ret_sts_error;

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

3787: */
3788: /* -- we donot need to give the UOM
3789: IF p_complete_rec.accrual_uom IS NULL THEN
3790: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3791: fnd_message.set_name('OZF', 'OZF_ACCRUAL_NO_UOM');
3792: fnd_msg_pub.add;
3793: END IF;
3794:
3795: x_return_status := fnd_api.g_ret_sts_error;

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

3798: /*
3799: -- sangara - R12 enhancement - not mandatory, as they are moved to Market Options cuecard
3800: IF p_complete_rec.accrual_phase IS NULL THEN
3801: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3802: fnd_message.set_name('OZF', 'OZF_ACCRUAL_NO_PHASE');
3803: fnd_msg_pub.add;
3804: END IF;
3805:
3806: x_return_status := fnd_api.g_ret_sts_error;

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

3808: */
3809: /*
3810: IF NVL(p_complete_rec.accrual_rate, 0) <= 0 THEN
3811: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3812: fnd_message.set_name('OZF', 'OZF_ACCRUAL_NO_RATE');
3813: fnd_msg_pub.add;
3814: END IF;
3815:
3816: x_return_status := fnd_api.g_ret_sts_error;

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

3818: -- default the quantity to 1
3819: /*
3820: IF NVL(p_complete_rec.accrual_quantity, 0) <= 0 THEN
3821: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3822: fnd_message.set_name('OZF', 'OZF_ACCRUAL_NO_QUANTITY');
3823: fnd_msg_pub.add;
3824: END IF;
3825:
3826: x_return_status := fnd_api.g_ret_sts_error;

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

3857: ,'USER') <>
3858: 'F' THEN
3859: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3860: IF p_fund_rec.fund_type = 'QUOTA' THEN
3861: fnd_message.set_name('OZF', 'OZF_TP_ILLEGAL_OWNER');
3862: ELSE
3863: fnd_message.set_name('OZF', 'OZF_FUND_ILLEGAL_OWNER');
3864: END IF;
3865: fnd_msg_pub.add;

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

3859: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3860: IF p_fund_rec.fund_type = 'QUOTA' THEN
3861: fnd_message.set_name('OZF', 'OZF_TP_ILLEGAL_OWNER');
3862: ELSE
3863: fnd_message.set_name('OZF', 'OZF_FUND_ILLEGAL_OWNER');
3864: END IF;
3865: fnd_msg_pub.add;
3866: END IF;
3867:

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

3868: x_return_status := fnd_api.g_ret_sts_error;
3869: END IF;
3870: ELSIF l_resource_id = -1 THEN
3871: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3872: fnd_message.set_name('OZF', 'OZF_NO_RESOURCE_ID');
3873: fnd_msg_pub.add;
3874: END IF;
3875:
3876: x_return_status := fnd_api.g_ret_sts_error;

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

3889: p_ledger_name => l_offer_ledgerName
3890: );
3891: IF p_complete_rec.ledger_id <> l_offer_ledger THEN
3892: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3893: fnd_message.set_name('OZF', 'OZF_BUDGET_OFFR_LEDG_MISMATCH');
3894: fnd_msg_pub.add;
3895: END IF;
3896: x_return_status := fnd_api.g_ret_sts_error;
3897: END IF;

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

4118: IF c_fund%NOTFOUND THEN
4119: CLOSE c_fund;
4120:
4121: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
4122: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
4123: fnd_msg_pub.add;
4124: END IF;
4125:
4126: RAISE fnd_api.g_exc_error;

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

5404: AND object_version_number = fund.object_version_number;
5405:
5406: IF (SQL%NOTFOUND) THEN
5407: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
5408: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
5409: fnd_msg_pub.add;
5410: END IF;
5411:
5412: RAISE fnd_api.g_exc_error;