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

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

526: );
527: END IF;
528:
529: --Added for bug 7425189
530: l_fund_reconc_msg := fnd_message.get_string ('OZF', 'OZF_FUND_RECONCILE');
531: l_act_bud_cst_msg := fnd_message.get_string ('OZF', 'OZF_ACT_BUDG_CST_UTIL');
532:
533: -- if the utlization type is adjustment then the adjustment type is mandatory
534: IF l_utilization_rec.utilization_type IN ('ADJUSTMENT', 'CHARGEBACK', 'LEAD_ADJUSTMENT') THEN -- yzhao: 11.5.10 added CHARGEBACK, LEAD_ADJUSTMENT

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

527: END IF;
528:
529: --Added for bug 7425189
530: l_fund_reconc_msg := fnd_message.get_string ('OZF', 'OZF_FUND_RECONCILE');
531: l_act_bud_cst_msg := fnd_message.get_string ('OZF', 'OZF_ACT_BUDG_CST_UTIL');
532:
533: -- if the utlization type is adjustment then the adjustment type is mandatory
534: IF l_utilization_rec.utilization_type IN ('ADJUSTMENT', 'CHARGEBACK', 'LEAD_ADJUSTMENT') THEN -- yzhao: 11.5.10 added CHARGEBACK, LEAD_ADJUSTMENT
535: OPEN c_adj_type (l_utilization_rec.adjustment_type_id);

Line 738: fnd_message.set_name ('OZF', 'OZF_NO_LEDGER_FOUND');

734: || ' id('
735: || l_utilization_rec.plan_id);
736: END IF;
737: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
738: fnd_message.set_name ('OZF', 'OZF_NO_LEDGER_FOUND');
739: fnd_message.set_token('OBJECT_TYPE', l_utilization_rec.plan_type);
740: fnd_message.set_token('OBJECT_ID', l_utilization_rec.plan_id);
741: fnd_msg_pub.ADD;
742: END IF;

Line 739: fnd_message.set_token('OBJECT_TYPE', l_utilization_rec.plan_type);

735: || l_utilization_rec.plan_id);
736: END IF;
737: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
738: fnd_message.set_name ('OZF', 'OZF_NO_LEDGER_FOUND');
739: fnd_message.set_token('OBJECT_TYPE', l_utilization_rec.plan_type);
740: fnd_message.set_token('OBJECT_ID', l_utilization_rec.plan_id);
741: fnd_msg_pub.ADD;
742: END IF;
743: x_return_status := fnd_api.g_ret_sts_error;

Line 740: fnd_message.set_token('OBJECT_ID', l_utilization_rec.plan_id);

736: END IF;
737: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
738: fnd_message.set_name ('OZF', 'OZF_NO_LEDGER_FOUND');
739: fnd_message.set_token('OBJECT_TYPE', l_utilization_rec.plan_type);
740: fnd_message.set_token('OBJECT_ID', l_utilization_rec.plan_id);
741: fnd_msg_pub.ADD;
742: END IF;
743: x_return_status := fnd_api.g_ret_sts_error;
744: RAISE fnd_api.g_exc_error;

Line 976: fnd_message.set_name ('OZF', 'OZF_GLT_PERIOD_CLOSED');

972: FETCH c_getClosedPeriods INTO l_periods, l_begin_date, l_end_date, l_period_status;
973: EXIT WHEN c_getClosedPeriods%NOTFOUND;
974:
975: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
976: fnd_message.set_name ('OZF', 'OZF_GLT_PERIOD_CLOSED');
977: fnd_message.set_token('PERIOD', l_periods);
978: fnd_message.set_token('SOB_NAME', l_ledger_name);
979: fnd_msg_pub.ADD;
980: END IF;

Line 977: fnd_message.set_token('PERIOD', l_periods);

973: EXIT WHEN c_getClosedPeriods%NOTFOUND;
974:
975: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
976: fnd_message.set_name ('OZF', 'OZF_GLT_PERIOD_CLOSED');
977: fnd_message.set_token('PERIOD', l_periods);
978: fnd_message.set_token('SOB_NAME', l_ledger_name);
979: fnd_msg_pub.ADD;
980: END IF;
981: RAISE fnd_api.g_exc_error;

Line 978: fnd_message.set_token('SOB_NAME', l_ledger_name);

974:
975: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
976: fnd_message.set_name ('OZF', 'OZF_GLT_PERIOD_CLOSED');
977: fnd_message.set_token('PERIOD', l_periods);
978: fnd_message.set_token('SOB_NAME', l_ledger_name);
979: fnd_msg_pub.ADD;
980: END IF;
981: RAISE fnd_api.g_exc_error;
982: END LOOP;

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

1021: IF (c_fund_b%NOTFOUND) THEN
1022: CLOSE c_fund_b;
1023:
1024: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1025: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
1026: fnd_msg_pub.ADD;
1027: END IF;
1028:
1029: RAISE fnd_api.g_exc_error;

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

1159: FETCH c_accrual_budget_reqeust INTO l_act_budget_id, l_act_budget_objver;
1160: IF (c_accrual_budget_reqeust%NOTFOUND) THEN
1161: CLOSE c_accrual_budget_reqeust;
1162: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1163: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
1164: fnd_msg_pub.ADD;
1165: END IF;
1166: RAISE fnd_api.g_exc_error;
1167: END IF;

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

1253: FETCH c_budget_request_utilrec INTO l_act_budget_id, l_act_budget_objver;
1254: IF (c_budget_request_utilrec%NOTFOUND) THEN
1255: CLOSE c_budget_request_utilrec;
1256: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1257: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
1258: fnd_msg_pub.ADD;
1259: END IF;
1260: RAISE fnd_api.g_exc_error;
1261: END IF;

Line 2093: fnd_message.set_name ('OZF', 'OZF_GL_POST_FAILURE');

2089: l_gl_posted_flag := ozf_accrual_engine.G_GL_FLAG_FAIL; -- 'F';
2090: -- yzhao: 11/20 raise exception if gl posting failed for manual adjust earned amount
2091: IF l_utilization_rec.utilization_type IN ('ADJUSTMENT', 'CHARGEBACK', 'LEAD_ADJUSTMENT') AND
2092: l_utilization_rec.adjustment_type IN ('STANDARD', 'DECREASE_EARNED', 'DECREASE_COMM_EARNED') THEN
2093: fnd_message.set_name ('OZF', 'OZF_GL_POST_FAILURE');
2094: fnd_msg_pub.ADD;
2095: RAISE fnd_api.g_exc_error;
2096: ELSE
2097: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

Line 2098: fnd_message.set_name ('OZF', 'OZF_API_DEBUG_MESSAGE');

2094: fnd_msg_pub.ADD;
2095: RAISE fnd_api.g_exc_error;
2096: ELSE
2097: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2098: fnd_message.set_name ('OZF', 'OZF_API_DEBUG_MESSAGE');
2099: fnd_message.set_token ('TEXT', 'Failed to post to GL for utilization id ' || l_utilization_rec.utilization_id);
2100: fnd_msg_pub.ADD;
2101: END IF;
2102: END IF;

Line 2099: fnd_message.set_token ('TEXT', 'Failed to post to GL for utilization id ' || l_utilization_rec.utilization_id);

2095: RAISE fnd_api.g_exc_error;
2096: ELSE
2097: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2098: fnd_message.set_name ('OZF', 'OZF_API_DEBUG_MESSAGE');
2099: fnd_message.set_token ('TEXT', 'Failed to post to GL for utilization id ' || l_utilization_rec.utilization_id);
2100: fnd_msg_pub.ADD;
2101: END IF;
2102: END IF;
2103: END IF;

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

2336: AND object_version_number = p_object_version;
2337:
2338: IF (SQL%NOTFOUND) THEN
2339: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2340: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
2341: fnd_msg_pub.ADD;
2342: END IF;
2343:
2344: RAISE fnd_api.g_exc_error;

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

2348: WHERE utilization_id = p_utilization_id;
2349:
2350: IF (SQL%NOTFOUND) THEN
2351: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2352: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
2353: fnd_msg_pub.ADD;
2354: END IF;
2355:
2356: RAISE fnd_api.g_exc_error;

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

2470: IF (c_utilization_b%NOTFOUND) THEN
2471: CLOSE c_utilization_b;
2472:
2473: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2474: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
2475: fnd_msg_pub.ADD;
2476: END IF;
2477:
2478: RAISE fnd_api.g_exc_error;

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

2496: WHEN ozf_utility_pvt.resource_locked THEN
2497: x_return_status := fnd_api.g_ret_sts_error;
2498:
2499: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2500: fnd_message.set_name ('OZF', 'OZF_API_RESOURCE_LOCKED');
2501: fnd_msg_pub.ADD;
2502: END IF;
2503:
2504: fnd_msg_pub.count_and_get (

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

2823: AND object_version_number = l_utilization_rec.object_version_number;
2824:
2825: IF (SQL%NOTFOUND) THEN
2826: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2827: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
2828: fnd_msg_pub.ADD;
2829: END IF;
2830:
2831: RAISE fnd_api.g_exc_error;

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

2846: AND USERENV ('LANG') IN (language, source_lang);
2847:
2848: IF (SQL%NOTFOUND) THEN
2849: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2850: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
2851: fnd_msg_pub.ADD;
2852: END IF;
2853:
2854: RAISE fnd_api.g_exc_error;

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

2860: IF (c_fund_b%NOTFOUND) THEN
2861: CLOSE c_fund_b;
2862:
2863: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2864: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
2865: fnd_msg_pub.ADD;
2866: END IF;
2867:
2868: RAISE fnd_api.g_exc_error;

Line 3092: fnd_message.set_name ('OZF', 'OZF_NO_FUND_ID');

3088:
3089: ------------------------ fund_id --------------------------
3090: IF p_utilization_rec.fund_id IS NULL THEN -- check for fund id
3091: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3092: fnd_message.set_name ('OZF', 'OZF_NO_FUND_ID');
3093: fnd_msg_pub.ADD;
3094: END IF;
3095:
3096: x_return_status := fnd_api.g_ret_sts_error;

Line 3102: fnd_message.set_name ('OZF', 'OZF_NO_UTILIZED_AMOUNT');

3098:
3099: ------------------------ AMOUNT -------------------------------
3100: ELSIF p_utilization_rec.amount IS NULL THEN -- check for amount
3101: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3102: fnd_message.set_name ('OZF', 'OZF_NO_UTILIZED_AMOUNT');
3103: fnd_msg_pub.ADD;
3104: END IF;
3105:
3106: x_return_status := fnd_api.g_ret_sts_error;

Line 3111: fnd_message.set_name ('OZF', 'OZF_FUND_NO_ADJUSTMENT_TYPE');

3107: RETURN;
3108: ELSIF p_utilization_rec.utilization_type IN ('ADJUSTMENT', 'CHARGEBACK', 'LEAD_ADJUSTMENT') THEN
3109: IF p_utilization_rec.adjustment_type IS NULL THEN -- check for utilization
3110: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3111: fnd_message.set_name ('OZF', 'OZF_FUND_NO_ADJUSTMENT_TYPE');
3112: fnd_msg_pub.ADD;
3113: END IF;
3114:
3115: x_return_status := fnd_api.g_ret_sts_error;

Line 3122: fnd_message.set_name ('OZF', 'OZF_FUND_NO_CUST_ID');

3118: -- added for customer id for offers 8/14/2002 mpande
3119: IF p_utilization_rec.adjustment_type IN ('DECREASE_EARNED' ,'DECREASE_COMM_EARNED','STANDARD')
3120: AND p_utilization_rec.plan_type = 'OFFR' AND p_utilization_rec.cust_account_id IS NULL THEN -- check for utilization type
3121: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3122: fnd_message.set_name ('OZF', 'OZF_FUND_NO_CUST_ID');
3123: fnd_msg_pub.ADD;
3124: END IF;
3125: x_return_status := fnd_api.g_ret_sts_error;
3126: RETURN;

Line 3130: fnd_message.set_name ('OZF', 'OZF_FUND_NO_UTILIZATION_TYPE');

3126: RETURN;
3127: END IF;
3128: ELSIF p_utilization_rec.utilization_type IS NULL THEN -- check for utilization type
3129: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3130: fnd_message.set_name ('OZF', 'OZF_FUND_NO_UTILIZATION_TYPE');
3131: fnd_msg_pub.ADD;
3132: END IF;
3133:
3134: x_return_status := fnd_api.g_ret_sts_error;

Line 3169: fnd_message.set_name ('OZF', 'OZF_UTILIZED_DUPLICATE_ID');

3165: , 'utilization_id = '
3166: || p_utilization_rec.utilization_id
3167: ) = fnd_api.g_false THEN
3168: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3169: fnd_message.set_name ('OZF', 'OZF_UTILIZED_DUPLICATE_ID');
3170: fnd_msg_pub.ADD;
3171: END IF;
3172:
3173: x_return_status := fnd_api.g_ret_sts_error;

Line 3210: fnd_message.set_name ('OZF', 'OZF_BAD_FUND_ID');

3206: , -- Column name in the parent object that maps to the fk value
3207: p_utilization_rec.fund_id -- Value of fk to be validated against the parent object's pk column
3208: ) = fnd_api.g_false THEN
3209: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3210: fnd_message.set_name ('OZF', 'OZF_BAD_FUND_ID');
3211: fnd_msg_pub.ADD;
3212: END IF;
3213:
3214: x_return_status := fnd_api.g_ret_sts_error;

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

3225: , -- Column name in the parent object that maps to the fk value
3226: p_utilization_rec.adjustment_type_id -- Value of fk to be validated against the parent object's pk column
3227: ) = fnd_api.g_false THEN
3228: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3229: fnd_message.set_name ('OZF', 'OZFBAD_ADJUSTMENT_ID');
3230: fnd_msg_pub.ADD;
3231: END IF;
3232:
3233: x_return_status := fnd_api.g_ret_sts_error;

Line 3270: fnd_message.set_name ('OZF', 'OZF_BAD_UTILIZED_CODE');

3266: ,p_lookup_type=> 'OZF_UTILIZATION_TYPE'
3267: ,p_lookup_code=> p_utilization_rec.utilization_type
3268: ) = fnd_api.g_false THEN
3269: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3270: fnd_message.set_name ('OZF', 'OZF_BAD_UTILIZED_CODE');
3271: fnd_msg_pub.ADD;
3272: END IF;
3273:
3274: x_return_status := fnd_api.g_ret_sts_error;

Line 3287: fnd_message.set_name ('OZF', 'OZF_BAD_ADJUSTMENT_CODE');

3283: ,p_lookup_type=> 'OZF_ADJUSTMENT_TYPE'
3284: ,p_lookup_code=> p_utilization_rec.adjustment_type
3285: ) = fnd_api.g_false THEN
3286: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3287: fnd_message.set_name ('OZF', 'OZF_BAD_ADJUSTMENT_CODE');
3288: fnd_msg_pub.ADD;
3289: END IF;
3290:
3291: x_return_status := fnd_api.g_ret_sts_error;

Line 3679: fnd_message.set_name ('OZF', 'OZF_FUND_NO_COMMITTMENT');

3675: ,p_complete_rec.fund_id
3676: ,p_complete_rec.component_id
3677: ) = fnd_api.g_false THEN
3678: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3679: fnd_message.set_name ('OZF', 'OZF_FUND_NO_COMMITTMENT');
3680: fnd_msg_pub.ADD;
3681: END IF;
3682:
3683: x_return_status := fnd_api.g_ret_sts_error;

Line 3691: fnd_message.set_name ('OZF', 'OZF_FUND_NO_ADJUST');

3687:
3688:
3689: IF check_fund_active (p_complete_rec.fund_id) = fnd_api.g_false THEN
3690: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3691: fnd_message.set_name ('OZF', 'OZF_FUND_NO_ADJUST');
3692: fnd_msg_pub.ADD;
3693: END IF;
3694: x_return_status := fnd_api.g_ret_sts_error;
3695: RETURN;

Line 3705: fnd_message.set_name ('OZF', 'OZF_UTIL_NO_AMOUNT');

3701: IF p_complete_rec.adjustment_type = ('DECREASE_EARNED') THEN
3702: -- amount should be positive always
3703: IF NVL (p_complete_rec.amount, 0) <= 0 THEN
3704: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3705: fnd_message.set_name ('OZF', 'OZF_UTIL_NO_AMOUNT');
3706: fnd_msg_pub.ADD;
3707: END IF;
3708:
3709: x_return_status := fnd_api.g_ret_sts_error;

Line 3715: fnd_message.set_name ('OZF', 'OZF_UTIL_NO_AMOUNT');

3711: END IF;
3712: ELSE
3713: IF NVL (p_complete_rec.amount, 0) = 0 THEN
3714: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3715: fnd_message.set_name ('OZF', 'OZF_UTIL_NO_AMOUNT');
3716: fnd_msg_pub.ADD;
3717: END IF;
3718:
3719: x_return_status := fnd_api.g_ret_sts_error;

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

3767: IF c_utilization%NOTFOUND THEN
3768: CLOSE c_utilization;
3769:
3770: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3771: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
3772: fnd_msg_pub.ADD;
3773: END IF;
3774:
3775: RAISE fnd_api.g_exc_error;