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_MSG_PUB

Line 6: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

2: /* $Header: ozfvfutb.pls 120.46.12020000.2 2013/01/31 07:00:59 ninarasi ship $ */
3: g_pkg_name CONSTANT VARCHAR2 (30) := 'OZF_Fund_Utilized_PVT';
4: g_cons_fund_mode CONSTANT VARCHAR2 (30) := 'ADJUST'; --JTF_PLSQL_API.G_UPDATE
5: g_universal_currency CONSTANT VARCHAR2 (15) := fnd_profile.VALUE ('OZF_UNIV_CURR_CODE');
6: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
7:
8:
9: -----------------------------------------------------------------------
10: -- PROCEDURE

Line 511: fnd_msg_pub.initialize;

507: || ': start' || p_utilization_rec.utilization_type);
508: END IF;
509:
510: IF fnd_api.to_boolean (p_init_msg_list) THEN
511: fnd_msg_pub.initialize;
512: END IF;
513:
514: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
515: RAISE fnd_api.g_exc_unexpected_error;

Line 737: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

733: || l_utilization_rec.plan_type
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;

Line 741: fnd_msg_pub.ADD;

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;
745: END IF;

Line 975: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

971: LOOP
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;

Line 979: fnd_msg_pub.ADD;

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;
983: CLOSE c_getClosedPeriods;

Line 1024: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

1020: ,l_ozf_funds_old_rectype.ROLLUP_UTILIZED_AMT;
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:

Line 1026: fnd_msg_pub.ADD;

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;
1030: END IF;

Line 1162: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

1158: OPEN c_accrual_budget_reqeust(l_utilization_rec.fund_id, l_plan_id);
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;

Line 1164: fnd_msg_pub.ADD;

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;
1168: CLOSE c_accrual_budget_reqeust;

Line 1256: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

1252: OPEN c_budget_request_utilrec(l_utilization_rec.fund_id, l_plan_id, l_act_budget_id);
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;

Line 1258: fnd_msg_pub.ADD;

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;
1262: CLOSE c_budget_request_utilrec;

Line 2094: fnd_msg_pub.ADD;

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

Line 2097: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) 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
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;

Line 2100: fnd_msg_pub.ADD;

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;
2104: END IF; -- END IF

Line 2246: fnd_msg_pub.count_and_get (

2242: IF fnd_api.to_boolean (p_commit) THEN
2243: COMMIT;
2244: END IF;
2245:
2246: fnd_msg_pub.count_and_get (
2247: p_encoded=> fnd_api.g_false
2248: ,p_count=> x_msg_count
2249: ,p_data=> x_msg_data
2250: );

Line 2259: fnd_msg_pub.count_and_get (

2255: EXCEPTION
2256: WHEN fnd_api.g_exc_error THEN
2257: ROLLBACK TO create_utilization;
2258: x_return_status := fnd_api.g_ret_sts_error;
2259: fnd_msg_pub.count_and_get (
2260: p_encoded=> fnd_api.g_false
2261: ,p_count=> x_msg_count
2262: ,p_data=> x_msg_data
2263: );

Line 2267: fnd_msg_pub.count_and_get (

2263: );
2264: WHEN fnd_api.g_exc_unexpected_error THEN
2265: ROLLBACK TO create_utilization;
2266: x_return_status := fnd_api.g_ret_sts_unexp_error;
2267: fnd_msg_pub.count_and_get (
2268: p_encoded=> fnd_api.g_false
2269: ,p_count=> x_msg_count
2270: ,p_data=> x_msg_data
2271: );

Line 2276: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2272: WHEN OTHERS THEN
2273: ROLLBACK TO create_utilization;
2274: x_return_status := fnd_api.g_ret_sts_unexp_error;
2275:
2276: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2277: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2278: END IF;
2279:
2280: fnd_msg_pub.count_and_get (

Line 2277: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

2273: ROLLBACK TO create_utilization;
2274: x_return_status := fnd_api.g_ret_sts_unexp_error;
2275:
2276: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2277: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2278: END IF;
2279:
2280: fnd_msg_pub.count_and_get (
2281: p_encoded=> fnd_api.g_false

Line 2280: fnd_msg_pub.count_and_get (

2276: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2277: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2278: END IF;
2279:
2280: fnd_msg_pub.count_and_get (
2281: p_encoded=> fnd_api.g_false
2282: ,p_count=> x_msg_count
2283: ,p_data=> x_msg_data
2284: );

Line 2319: fnd_msg_pub.initialize;

2315: || ': start');
2316: END IF;
2317:
2318: IF fnd_api.to_boolean (p_init_msg_list) THEN
2319: fnd_msg_pub.initialize;
2320: END IF;
2321:
2322: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2323: RAISE fnd_api.g_exc_unexpected_error;

Line 2339: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

2335: WHERE utilization_id = p_utilization_id
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:

Line 2341: fnd_msg_pub.ADD;

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;
2345: END IF;

Line 2351: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

2347: DELETE FROM ozf_funds_utilized_all_tl
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:

Line 2353: fnd_msg_pub.ADD;

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;
2357: END IF;

Line 2365: fnd_msg_pub.count_and_get (

2361: IF fnd_api.to_boolean (p_commit) THEN
2362: COMMIT;
2363: END IF;
2364:
2365: fnd_msg_pub.count_and_get (
2366: p_encoded=> fnd_api.g_false
2367: ,p_count=> x_msg_count
2368: ,p_data=> x_msg_data
2369: );

Line 2378: fnd_msg_pub.count_and_get (

2374: EXCEPTION
2375: WHEN fnd_api.g_exc_error THEN
2376: ROLLBACK TO delete_utilization;
2377: x_return_status := fnd_api.g_ret_sts_error;
2378: fnd_msg_pub.count_and_get (
2379: p_encoded=> fnd_api.g_false
2380: ,p_count=> x_msg_count
2381: ,p_data=> x_msg_data
2382: );

Line 2386: fnd_msg_pub.count_and_get (

2382: );
2383: WHEN fnd_api.g_exc_unexpected_error THEN
2384: ROLLBACK TO delete_utilization;
2385: x_return_status := fnd_api.g_ret_sts_unexp_error;
2386: fnd_msg_pub.count_and_get (
2387: p_encoded=> fnd_api.g_false
2388: ,p_count=> x_msg_count
2389: ,p_data=> x_msg_data
2390: );

Line 2395: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2391: WHEN OTHERS THEN
2392: ROLLBACK TO delete_utilization;
2393: x_return_status := fnd_api.g_ret_sts_unexp_error;
2394:
2395: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2396: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2397: END IF;
2398:
2399: fnd_msg_pub.count_and_get (

Line 2396: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

2392: ROLLBACK TO delete_utilization;
2393: x_return_status := fnd_api.g_ret_sts_unexp_error;
2394:
2395: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2396: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2397: END IF;
2398:
2399: fnd_msg_pub.count_and_get (
2400: p_encoded=> fnd_api.g_false

Line 2399: fnd_msg_pub.count_and_get (

2395: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2396: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2397: END IF;
2398:
2399: fnd_msg_pub.count_and_get (
2400: p_encoded=> fnd_api.g_false
2401: ,p_count=> x_msg_count
2402: ,p_data=> x_msg_data
2403: );

Line 2453: fnd_msg_pub.initialize;

2449: || ': start');
2450: END IF;
2451:
2452: IF fnd_api.to_boolean (p_init_msg_list) THEN
2453: fnd_msg_pub.initialize;
2454: END IF;
2455:
2456: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2457: RAISE fnd_api.g_exc_unexpected_error;

Line 2473: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

2469:
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:

Line 2475: fnd_msg_pub.ADD;

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;
2479: END IF;

Line 2486: fnd_msg_pub.count_and_get (

2482: OPEN c_utilization_tl;
2483: CLOSE c_utilization_tl;
2484:
2485: -------------------- finish --------------------------
2486: fnd_msg_pub.count_and_get (
2487: p_encoded=> fnd_api.g_false
2488: ,p_count=> x_msg_count
2489: ,p_data=> x_msg_data
2490: );

Line 2499: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

2495: EXCEPTION
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:

Line 2501: fnd_msg_pub.ADD;

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 (
2505: p_encoded=> fnd_api.g_false

Line 2504: fnd_msg_pub.count_and_get (

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 (
2505: p_encoded=> fnd_api.g_false
2506: ,p_count=> x_msg_count
2507: ,p_data=> x_msg_data
2508: );

Line 2511: fnd_msg_pub.count_and_get (

2507: ,p_data=> x_msg_data
2508: );
2509: WHEN fnd_api.g_exc_error THEN
2510: x_return_status := fnd_api.g_ret_sts_error;
2511: fnd_msg_pub.count_and_get (
2512: p_encoded=> fnd_api.g_false
2513: ,p_count=> x_msg_count
2514: ,p_data=> x_msg_data
2515: );

Line 2518: fnd_msg_pub.count_and_get (

2514: ,p_data=> x_msg_data
2515: );
2516: WHEN fnd_api.g_exc_unexpected_error THEN
2517: x_return_status := fnd_api.g_ret_sts_unexp_error;
2518: fnd_msg_pub.count_and_get (
2519: p_encoded=> fnd_api.g_false
2520: ,p_count=> x_msg_count
2521: ,p_data=> x_msg_data
2522: );

Line 2526: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2522: );
2523: WHEN OTHERS THEN
2524: x_return_status := fnd_api.g_ret_sts_unexp_error;
2525:
2526: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2527: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2528: END IF;
2529:
2530: fnd_msg_pub.count_and_get (

Line 2527: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

2523: WHEN OTHERS THEN
2524: x_return_status := fnd_api.g_ret_sts_unexp_error;
2525:
2526: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2527: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2528: END IF;
2529:
2530: fnd_msg_pub.count_and_get (
2531: p_encoded=> fnd_api.g_false

Line 2530: fnd_msg_pub.count_and_get (

2526: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2527: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2528: END IF;
2529:
2530: fnd_msg_pub.count_and_get (
2531: p_encoded=> fnd_api.g_false
2532: ,p_count=> x_msg_count
2533: ,p_data=> x_msg_data
2534: );

Line 2598: fnd_msg_pub.initialize;

2594: || ': start');
2595: END IF;
2596:
2597: IF fnd_api.to_boolean (p_init_msg_list) THEN
2598: fnd_msg_pub.initialize;
2599: END IF;
2600:
2601: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2602: RAISE fnd_api.g_exc_unexpected_error;

Line 2826: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

2822: WHERE utilization_id = l_utilization_rec.utilization_id
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:

Line 2828: fnd_msg_pub.ADD;

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;
2832: END IF;

Line 2849: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

2845: WHERE utilization_id = l_utilization_rec.utilization_id
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:

Line 2851: fnd_msg_pub.ADD;

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;
2855: END IF;

Line 2863: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

2859:
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:

Line 2865: fnd_msg_pub.ADD;

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;
2869: END IF;

Line 2909: fnd_msg_pub.count_and_get (

2905: IF fnd_api.to_boolean (p_commit) THEN
2906: COMMIT;
2907: END IF;
2908:
2909: fnd_msg_pub.count_and_get (
2910: p_encoded=> fnd_api.g_false
2911: ,p_count=> x_msg_count
2912: ,p_data=> x_msg_data
2913: );

Line 2922: fnd_msg_pub.count_and_get (

2918: EXCEPTION
2919: WHEN fnd_api.g_exc_error THEN
2920: ROLLBACK TO update_utilization;
2921: x_return_status := fnd_api.g_ret_sts_error;
2922: fnd_msg_pub.count_and_get (
2923: p_encoded=> fnd_api.g_false
2924: ,p_count=> x_msg_count
2925: ,p_data=> x_msg_data
2926: );

Line 2930: fnd_msg_pub.count_and_get (

2926: );
2927: WHEN fnd_api.g_exc_unexpected_error THEN
2928: ROLLBACK TO update_utilization;
2929: x_return_status := fnd_api.g_ret_sts_unexp_error;
2930: fnd_msg_pub.count_and_get (
2931: p_encoded=> fnd_api.g_false
2932: ,p_count=> x_msg_count
2933: ,p_data=> x_msg_data
2934: );

Line 2939: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2935: WHEN OTHERS THEN
2936: ROLLBACK TO update_utilization;
2937: x_return_status := fnd_api.g_ret_sts_unexp_error;
2938:
2939: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2940: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2941: END IF;
2942:
2943: fnd_msg_pub.count_and_get (

Line 2940: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

2936: ROLLBACK TO update_utilization;
2937: x_return_status := fnd_api.g_ret_sts_unexp_error;
2938:
2939: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2940: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2941: END IF;
2942:
2943: fnd_msg_pub.count_and_get (
2944: p_encoded=> fnd_api.g_false

Line 2943: fnd_msg_pub.count_and_get (

2939: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2940: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2941: END IF;
2942:
2943: fnd_msg_pub.count_and_get (
2944: p_encoded=> fnd_api.g_false
2945: ,p_count=> x_msg_count
2946: ,p_data=> x_msg_data
2947: );

Line 2983: fnd_msg_pub.initialize;

2979: || ': start');
2980: END IF;
2981:
2982: IF fnd_api.to_boolean (p_init_msg_list) THEN
2983: fnd_msg_pub.initialize;
2984: END IF;
2985:
2986: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2987: RAISE fnd_api.g_exc_unexpected_error;

Line 3033: fnd_msg_pub.count_and_get (

3029: END IF;
3030:
3031:
3032: -------------------- finish --------------------------
3033: fnd_msg_pub.count_and_get (
3034: p_encoded=> fnd_api.g_false
3035: ,p_count=> x_msg_count
3036: ,p_data=> x_msg_data
3037: );

Line 3045: fnd_msg_pub.count_and_get (

3041: END IF;
3042: EXCEPTION
3043: WHEN fnd_api.g_exc_error THEN
3044: x_return_status := fnd_api.g_ret_sts_error;
3045: fnd_msg_pub.count_and_get (
3046: p_encoded=> fnd_api.g_false
3047: ,p_count=> x_msg_count
3048: ,p_data=> x_msg_data
3049: );

Line 3052: fnd_msg_pub.count_and_get (

3048: ,p_data=> x_msg_data
3049: );
3050: WHEN fnd_api.g_exc_unexpected_error THEN
3051: x_return_status := fnd_api.g_ret_sts_unexp_error;
3052: fnd_msg_pub.count_and_get (
3053: p_encoded=> fnd_api.g_false
3054: ,p_count=> x_msg_count
3055: ,p_data=> x_msg_data
3056: );

Line 3060: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

3056: );
3057: WHEN OTHERS THEN
3058: x_return_status := fnd_api.g_ret_sts_unexp_error;
3059:
3060: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3061: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3062: END IF;
3063:
3064: fnd_msg_pub.count_and_get (

Line 3061: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

3057: WHEN OTHERS THEN
3058: x_return_status := fnd_api.g_ret_sts_unexp_error;
3059:
3060: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3061: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3062: END IF;
3063:
3064: fnd_msg_pub.count_and_get (
3065: p_encoded=> fnd_api.g_false

Line 3064: fnd_msg_pub.count_and_get (

3060: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3061: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3062: END IF;
3063:
3064: fnd_msg_pub.count_and_get (
3065: p_encoded=> fnd_api.g_false
3066: ,p_count=> x_msg_count
3067: ,p_data=> x_msg_data
3068: );

Line 3091: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

3087:
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:

Line 3093: fnd_msg_pub.ADD;

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;
3097: RETURN;

Line 3101: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

3097: RETURN;
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:

Line 3103: fnd_msg_pub.ADD;

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;
3107: RETURN;

Line 3110: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

3106: x_return_status := fnd_api.g_ret_sts_error;
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:

Line 3112: fnd_msg_pub.ADD;

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;
3116: RETURN;

Line 3121: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

3117: END IF;
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;

Line 3123: fnd_msg_pub.ADD;

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;
3127: END IF;

Line 3129: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

3125: x_return_status := fnd_api.g_ret_sts_error;
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:

Line 3131: fnd_msg_pub.ADD;

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;
3135: RETURN;

Line 3168: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

3164: 'ozf_funds_UTILIZED_all_b'
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:

Line 3170: fnd_msg_pub.ADD;

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;
3174: RETURN;

Line 3209: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

3205: '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:

Line 3211: fnd_msg_pub.ADD;

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;
3215: RETURN;

Line 3228: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

3224: 'claim_type_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:

Line 3230: fnd_msg_pub.ADD;

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;
3234: RETURN;

Line 3269: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

3265: p_lookup_table_name=> 'OZF_LOOKUPS'
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:

Line 3271: fnd_msg_pub.ADD;

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;
3275: RETURN;

Line 3286: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

3282: p_lookup_table_name=> 'OZF_LOOKUPS'
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:

Line 3288: fnd_msg_pub.ADD;

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;
3292: RETURN;

Line 3678: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

3674: ,p_complete_rec.plan_type
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:

Line 3680: fnd_msg_pub.ADD;

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;
3684: RETURN;

Line 3690: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

3686: END IF;
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;

Line 3692: fnd_msg_pub.ADD;

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;
3696: END IF;

Line 3704: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

3700: IF l_dummy IS NULL THEN
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:

Line 3706: fnd_msg_pub.ADD;

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;
3710: RETURN;

Line 3714: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

3710: RETURN;
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:

Line 3716: fnd_msg_pub.ADD;

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;
3720: RETURN;

Line 3770: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

3766:
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:

Line 3772: fnd_msg_pub.ADD;

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;
3776: END IF;

Line 4388: fnd_msg_pub.initialize;

4384: || ': start');
4385: END IF;
4386:
4387: IF fnd_api.to_boolean (p_init_msg_list) THEN
4388: fnd_msg_pub.initialize;
4389: END IF;
4390:
4391: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
4392: RAISE fnd_api.g_exc_unexpected_error;

Line 4586: fnd_msg_pub.count_and_get (

4582: IF fnd_api.to_boolean (p_commit) THEN
4583: COMMIT;
4584: END IF;
4585:
4586: fnd_msg_pub.count_and_get (
4587: p_encoded=> fnd_api.g_false
4588: ,p_count=> x_msg_count
4589: ,p_data=> x_msg_data
4590: );

Line 4600: fnd_msg_pub.count_and_get (

4596: EXCEPTION
4597: WHEN fnd_api.g_exc_error THEN
4598: ROLLBACK TO create_act_utilization;
4599: x_return_status := fnd_api.g_ret_sts_error;
4600: fnd_msg_pub.count_and_get (
4601: p_encoded=> fnd_api.g_false
4602: ,p_count=> x_msg_count
4603: ,p_data=> x_msg_data
4604: );

Line 4608: fnd_msg_pub.count_and_get (

4604: );
4605: WHEN fnd_api.g_exc_unexpected_error THEN
4606: ROLLBACK TO create_act_utilization;
4607: x_return_status := fnd_api.g_ret_sts_unexp_error;
4608: fnd_msg_pub.count_and_get (
4609: p_encoded=> fnd_api.g_false
4610: ,p_count=> x_msg_count
4611: ,p_data=> x_msg_data
4612: );

Line 4617: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

4613: WHEN OTHERS THEN
4614: ROLLBACK TO create_act_utilization;
4615: x_return_status := fnd_api.g_ret_sts_unexp_error;
4616:
4617: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4618: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4619: END IF;
4620:
4621: fnd_msg_pub.count_and_get (

Line 4618: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

4614: ROLLBACK TO create_act_utilization;
4615: x_return_status := fnd_api.g_ret_sts_unexp_error;
4616:
4617: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4618: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4619: END IF;
4620:
4621: fnd_msg_pub.count_and_get (
4622: p_encoded=> fnd_api.g_false

Line 4621: fnd_msg_pub.count_and_get (

4617: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4618: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4619: END IF;
4620:
4621: fnd_msg_pub.count_and_get (
4622: p_encoded=> fnd_api.g_false
4623: ,p_count=> x_msg_count
4624: ,p_data=> x_msg_data
4625: );