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_MSG_PUB

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

123: -- addded 08/14/2001 mpande
124: g_activity_type CONSTANT VARCHAR2(30) := 'RFRQ';
125: -- added 02/08/2002 by feliu
126: g_universal_currency CONSTANT VARCHAR2 (15) := fnd_profile.VALUE ('OZF_UNIV_CURR_CODE');
127: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
128:
129:
130: -----------------------------------------------------------------------
131: -- PROCEDURE

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

239: FETCH c_parent_number INTO l_par_number;
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:

Line 245: fnd_msg_pub.add;

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

Line 416: fnd_msg_pub.initialize;

412: END IF;
413: x_return_status := fnd_api.g_ret_sts_success;
414:
415: IF fnd_api.to_boolean(p_init_msg_list) THEN
416: fnd_msg_pub.initialize;
417: END IF;
418:
419: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
420: RAISE fnd_api.g_exc_unexpected_error;

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

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

Line 550: fnd_msg_pub.add;

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;
554:

Line 1141: fnd_msg_pub.count_and_get(

1137: -- raise business event.
1138: --nepanda : fix for bug # 9616725
1139: raise_business_event(p_object_id => l_fund_rec.fund_id ,p_event_type =>'CREATE');
1140:
1141: fnd_msg_pub.count_and_get(
1142: p_encoded => fnd_api.g_false
1143: ,p_count => x_msg_count
1144: ,p_data => x_msg_data);
1145: IF G_DEBUG THEN

Line 1153: fnd_msg_pub.count_and_get(

1149: EXCEPTION
1150: WHEN fnd_api.g_exc_error THEN
1151: ROLLBACK TO create_fund;
1152: x_return_status := fnd_api.g_ret_sts_error;
1153: fnd_msg_pub.count_and_get(
1154: p_encoded => fnd_api.g_false
1155: ,p_count => x_msg_count
1156: ,p_data => x_msg_data);
1157: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1160: fnd_msg_pub.count_and_get(

1156: ,p_data => x_msg_data);
1157: WHEN fnd_api.g_exc_unexpected_error THEN
1158: ROLLBACK TO create_fund;
1159: x_return_status := fnd_api.g_ret_sts_unexp_error;
1160: fnd_msg_pub.count_and_get(
1161: p_encoded => fnd_api.g_false
1162: ,p_count => x_msg_count
1163: ,p_data => x_msg_data);
1164: WHEN OTHERS THEN

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

1164: WHEN OTHERS THEN
1165: ROLLBACK TO create_fund;
1166: x_return_status := fnd_api.g_ret_sts_unexp_error;
1167:
1168: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1169: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1170: END IF;
1171:
1172: fnd_msg_pub.count_and_get(

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

1165: ROLLBACK TO create_fund;
1166: x_return_status := fnd_api.g_ret_sts_unexp_error;
1167:
1168: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1169: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1170: END IF;
1171:
1172: fnd_msg_pub.count_and_get(
1173: p_encoded => fnd_api.g_false

Line 1172: fnd_msg_pub.count_and_get(

1168: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1169: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1170: END IF;
1171:
1172: fnd_msg_pub.count_and_get(
1173: p_encoded => fnd_api.g_false
1174: ,p_count => x_msg_count
1175: ,p_data => x_msg_data);
1176: END create_fund;

Line 1208: fnd_msg_pub.initialize;

1204: ozf_utility_pvt.debug_message(l_full_name || ': start');
1205: END IF;
1206:
1207: IF fnd_api.to_boolean(p_init_msg_list) THEN
1208: fnd_msg_pub.initialize;
1209: END IF;
1210:
1211: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1212: RAISE fnd_api.g_exc_unexpected_error;

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

1223: WHERE fund_id = p_fund_id
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:

Line 1229: fnd_msg_pub.add;

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

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

1236: FROM ozf_funds_all_tl
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:

Line 1242: fnd_msg_pub.add;

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

Line 1253: fnd_msg_pub.count_and_get(

1249: IF fnd_api.to_boolean(p_commit) THEN
1250: COMMIT;
1251: END IF;
1252:
1253: fnd_msg_pub.count_and_get(
1254: p_encoded => fnd_api.g_false
1255: ,p_count => x_msg_count
1256: ,p_data => x_msg_data);
1257: IF G_DEBUG THEN

Line 1264: fnd_msg_pub.count_and_get(

1260: EXCEPTION
1261: WHEN fnd_api.g_exc_error THEN
1262: ROLLBACK TO delete_fund;
1263: x_return_status := fnd_api.g_ret_sts_error;
1264: fnd_msg_pub.count_and_get(
1265: p_encoded => fnd_api.g_false
1266: ,p_count => x_msg_count
1267: ,p_data => x_msg_data);
1268: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1271: fnd_msg_pub.count_and_get(

1267: ,p_data => x_msg_data);
1268: WHEN fnd_api.g_exc_unexpected_error THEN
1269: ROLLBACK TO delete_fund;
1270: x_return_status := fnd_api.g_ret_sts_unexp_error;
1271: fnd_msg_pub.count_and_get(
1272: p_encoded => fnd_api.g_false
1273: ,p_count => x_msg_count
1274: ,p_data => x_msg_data);
1275: WHEN OTHERS THEN

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

1275: WHEN OTHERS THEN
1276: ROLLBACK TO delete_fund;
1277: x_return_status := fnd_api.g_ret_sts_unexp_error;
1278:
1279: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1280: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1281: END IF;
1282:
1283: fnd_msg_pub.count_and_get(

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

1276: ROLLBACK TO delete_fund;
1277: x_return_status := fnd_api.g_ret_sts_unexp_error;
1278:
1279: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1280: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1281: END IF;
1282:
1283: fnd_msg_pub.count_and_get(
1284: p_encoded => fnd_api.g_false

Line 1283: fnd_msg_pub.count_and_get(

1279: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1280: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1281: END IF;
1282:
1283: fnd_msg_pub.count_and_get(
1284: p_encoded => fnd_api.g_false
1285: ,p_count => x_msg_count
1286: ,p_data => x_msg_data);
1287: END delete_fund;

Line 1334: fnd_msg_pub.initialize;

1330: ozf_utility_pvt.debug_message(l_full_name || ': start');
1331: END IF;
1332:
1333: IF fnd_api.to_boolean(p_init_msg_list) THEN
1334: fnd_msg_pub.initialize;
1335: END IF;
1336:
1337: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1338: RAISE fnd_api.g_exc_unexpected_error;

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

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

Line 1354: fnd_msg_pub.add;

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

Line 1364: fnd_msg_pub.count_and_get(

1360: CLOSE c_fund_b;
1361: OPEN c_fund_tl;
1362: CLOSE c_fund_tl;
1363: -------------------- finish --------------------------
1364: fnd_msg_pub.count_and_get(
1365: p_encoded => fnd_api.g_false
1366: ,p_count => x_msg_count
1367: ,p_data => x_msg_data);
1368: IF G_DEBUG THEN

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

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

Line 1377: fnd_msg_pub.add;

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

Line 1380: fnd_msg_pub.count_and_get(

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(
1381: p_encoded => fnd_api.g_false
1382: ,p_count => x_msg_count
1383: ,p_data => x_msg_data);
1384: WHEN fnd_api.g_exc_error THEN

Line 1386: fnd_msg_pub.count_and_get(

1382: ,p_count => x_msg_count
1383: ,p_data => x_msg_data);
1384: WHEN fnd_api.g_exc_error THEN
1385: x_return_status := fnd_api.g_ret_sts_error;
1386: fnd_msg_pub.count_and_get(
1387: p_encoded => fnd_api.g_false
1388: ,p_count => x_msg_count
1389: ,p_data => x_msg_data);
1390: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1392: fnd_msg_pub.count_and_get(

1388: ,p_count => x_msg_count
1389: ,p_data => x_msg_data);
1390: WHEN fnd_api.g_exc_unexpected_error THEN
1391: x_return_status := fnd_api.g_ret_sts_unexp_error;
1392: fnd_msg_pub.count_and_get(
1393: p_encoded => fnd_api.g_false
1394: ,p_count => x_msg_count
1395: ,p_data => x_msg_data);
1396: WHEN OTHERS THEN

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

1395: ,p_data => x_msg_data);
1396: WHEN OTHERS THEN
1397: x_return_status := fnd_api.g_ret_sts_unexp_error;
1398:
1399: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1400: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1401: END IF;
1402:
1403: fnd_msg_pub.count_and_get(

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

1396: WHEN OTHERS THEN
1397: x_return_status := fnd_api.g_ret_sts_unexp_error;
1398:
1399: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1400: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1401: END IF;
1402:
1403: fnd_msg_pub.count_and_get(
1404: p_encoded => fnd_api.g_false

Line 1403: fnd_msg_pub.count_and_get(

1399: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1400: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1401: END IF;
1402:
1403: fnd_msg_pub.count_and_get(
1404: p_encoded => fnd_api.g_false
1405: ,p_count => x_msg_count
1406: ,p_data => x_msg_data);
1407: END lock_fund;

Line 1683: fnd_msg_pub.initialize;

1679: ozf_utility_pvt.debug_message(l_full_name || ': start');
1680: END IF;
1681:
1682: IF fnd_api.to_boolean(p_init_msg_list) THEN
1683: fnd_msg_pub.initialize;
1684: END IF;
1685:
1686: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1687: RAISE fnd_api.g_exc_unexpected_error;

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

2731: WHERE fund_id = l_fund_rec.fund_id
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:

Line 2737: fnd_msg_pub.add;

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

Line 3283: fnd_msg_pub.count_and_get(

3279: IF fnd_api.to_boolean(p_commit) THEN
3280: COMMIT;
3281: END IF;
3282:
3283: fnd_msg_pub.count_and_get(
3284: p_encoded => fnd_api.g_false
3285: ,p_count => x_msg_count
3286: ,p_data => x_msg_data);
3287: IF G_DEBUG THEN

Line 3294: fnd_msg_pub.count_and_get(

3290: EXCEPTION
3291: WHEN fnd_api.g_exc_error THEN
3292: ROLLBACK TO update_fund;
3293: x_return_status := fnd_api.g_ret_sts_error;
3294: fnd_msg_pub.count_and_get(
3295: p_encoded => fnd_api.g_false
3296: ,p_count => x_msg_count
3297: ,p_data => x_msg_data);
3298: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3301: fnd_msg_pub.count_and_get(

3297: ,p_data => x_msg_data);
3298: WHEN fnd_api.g_exc_unexpected_error THEN
3299: ROLLBACK TO update_fund;
3300: x_return_status := fnd_api.g_ret_sts_unexp_error;
3301: fnd_msg_pub.count_and_get(
3302: p_encoded => fnd_api.g_false
3303: ,p_count => x_msg_count
3304: ,p_data => x_msg_data);
3305: WHEN OTHERS THEN

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

3305: WHEN OTHERS THEN
3306: ROLLBACK TO update_fund;
3307: x_return_status := fnd_api.g_ret_sts_unexp_error;
3308:
3309: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3310: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3311: END IF;
3312:
3313: fnd_msg_pub.count_and_get(

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

3306: ROLLBACK TO update_fund;
3307: x_return_status := fnd_api.g_ret_sts_unexp_error;
3308:
3309: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3310: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3311: END IF;
3312:
3313: fnd_msg_pub.count_and_get(
3314: p_encoded => fnd_api.g_false

Line 3313: fnd_msg_pub.count_and_get(

3309: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3310: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3311: END IF;
3312:
3313: fnd_msg_pub.count_and_get(
3314: p_encoded => fnd_api.g_false
3315: ,p_count => x_msg_count
3316: ,p_data => x_msg_data);
3317: END update_fund;

Line 3349: fnd_msg_pub.initialize;

3345: ozf_utility_pvt.debug_message(l_full_name || ': start');
3346: END IF;
3347:
3348: IF fnd_api.to_boolean(p_init_msg_list) THEN
3349: fnd_msg_pub.initialize;
3350: END IF;
3351:
3352: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3353: RAISE fnd_api.g_exc_unexpected_error;

Line 3415: fnd_msg_pub.count_and_get(

3411: END IF;
3412: END IF;
3413:
3414: -------------------- finish --------------------------
3415: fnd_msg_pub.count_and_get(
3416: p_encoded => fnd_api.g_false
3417: ,p_count => x_msg_count
3418: ,p_data => x_msg_data);
3419: IF G_DEBUG THEN

Line 3425: fnd_msg_pub.count_and_get(

3421: END IF;
3422: EXCEPTION
3423: WHEN fnd_api.g_exc_error THEN
3424: x_return_status := fnd_api.g_ret_sts_error;
3425: fnd_msg_pub.count_and_get(
3426: p_encoded => fnd_api.g_false
3427: ,p_count => x_msg_count
3428: ,p_data => x_msg_data);
3429: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3431: fnd_msg_pub.count_and_get(

3427: ,p_count => x_msg_count
3428: ,p_data => x_msg_data);
3429: WHEN fnd_api.g_exc_unexpected_error THEN
3430: x_return_status := fnd_api.g_ret_sts_unexp_error;
3431: fnd_msg_pub.count_and_get(
3432: p_encoded => fnd_api.g_false
3433: ,p_count => x_msg_count
3434: ,p_data => x_msg_data);
3435: WHEN OTHERS THEN

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

3434: ,p_data => x_msg_data);
3435: WHEN OTHERS THEN
3436: x_return_status := fnd_api.g_ret_sts_unexp_error;
3437:
3438: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3439: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3440: END IF;
3441:
3442: fnd_msg_pub.count_and_get(

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

3435: WHEN OTHERS THEN
3436: x_return_status := fnd_api.g_ret_sts_unexp_error;
3437:
3438: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3439: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3440: END IF;
3441:
3442: fnd_msg_pub.count_and_get(
3443: p_encoded => fnd_api.g_false

Line 3442: fnd_msg_pub.count_and_get(

3438: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3439: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3440: END IF;
3441:
3442: fnd_msg_pub.count_and_get(
3443: p_encoded => fnd_api.g_false
3444: ,p_count => x_msg_count
3445: ,p_data => x_msg_data);
3446: END validate_fund;

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

3466:
3467: -- Commented by mpande 02/16/2001 We are going to generate the number if it is null
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');

Line 3476: fnd_msg_pub.add;

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:
3479: x_return_status := fnd_api.g_ret_sts_error;
3480: RETURN;

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

3481: END IF;
3482: */
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');

Line 3491: fnd_msg_pub.add;

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:
3494: x_return_status := fnd_api.g_ret_sts_error;
3495: RETURN;

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

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

Line 3501: fnd_msg_pub.add;

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

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

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

Line 3512: fnd_msg_pub.add;

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

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

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

Line 3523: fnd_msg_pub.add;

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

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

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

Line 3533: fnd_msg_pub.add;

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

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

3543: IF p_fund_rec.prev_fund_id IS NULL AND p_fund_rec.parent_fund_id IS NULL AND p_fund_rec.fund_type = 'FIXED' AND (p_mode is NULL OR p_mode <> 'SETTLE') THEN
3544: -- niprakas changed <= to <
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');

Line 3553: fnd_msg_pub.add;

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:
3556: x_return_status := fnd_api.g_ret_sts_error;
3557: RETURN;

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

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

Line 3565: fnd_msg_pub.add;

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

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

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

Line 3577: fnd_msg_pub.add;

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

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

3622: IF ozf_utility_pvt.check_uniqueness(
3623: 'ozf_funds_all_vl'
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');

Line 3632: fnd_msg_pub.add;

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:
3635: x_return_status := fnd_api.g_ret_sts_error;
3636: RETURN;

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

3660: CLOSE c_prog_fund_number_update;
3661: END IF;
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');

Line 3670: fnd_msg_pub.add;

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:
3673: x_return_status := fnd_api.g_ret_sts_error;
3674: RETURN;

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

3693: p_fund_rec.fund_id);
3694: END IF;
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');

Line 3703: fnd_msg_pub.add;

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:
3706: x_return_status := fnd_api.g_ret_sts_error;
3707: RETURN;

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

3732: 'ams_user_statuses_vl'
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:

Line 3738: fnd_msg_pub.add;

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

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

3752: 'ams_categories_vl'
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:

Line 3758: fnd_msg_pub.add;

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

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

3790: p_lookup_table_name => 'OZF_LOOKUPS'
3791: ,p_lookup_type => 'OZF_FUND_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');

Line 3800: fnd_msg_pub.add;

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:
3803: x_return_status := fnd_api.g_ret_sts_error;
3804: RETURN;

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

3812: p_lookup_table_name => 'OZF_LOOKUPS'
3813: ,p_lookup_type => 'OZF_FUND_STATUS'
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');

Line 3822: fnd_msg_pub.add;

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:
3825: x_return_status := fnd_api.g_ret_sts_error;
3826: RETURN;

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

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

Line 3855: fnd_msg_pub.add;

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

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

3863: ----------------------- budget_flag ------------------------
3864: IF p_fund_rec.budget_flag <> fnd_api.g_miss_char
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');

Line 3873: fnd_msg_pub.add;

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:
3876: x_return_status := fnd_api.g_ret_sts_error;
3877: RETURN;

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

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

Line 3887: fnd_msg_pub.add;

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

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

4007: IF p_fund_rec.fund_type = 'FULLY_ACCRUED' THEN
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:

Line 4013: fnd_msg_pub.add;

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

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

4040: /* kdass 28-Dec-2004 fix for 11.5.10 bug 4089720, when the fund is created from mass transfer,
4041: do not check for end date */
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');

Line 4050: fnd_msg_pub.add;

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

Line 4065: fnd_msg_pub.add;

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;
4069: */

Line 4077: fnd_msg_pub.add;

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;
4080:
4081: IF l_start_date > l_end_date THEN

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

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

Line 4084: fnd_msg_pub.add;

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

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

4090: IF p_mode = jtf_plsql_api.g_update THEN
4091: IF p_fund_rec.parent_fund_id <> fnd_api.g_miss_num
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');

Line 4100: fnd_msg_pub.add;

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

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

4116: IF p_complete_rec.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;

Line 4122: fnd_msg_pub.add;

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

Line 4131: fnd_msg_pub.add;

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:
4135: ELSE

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

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

Line 4139: fnd_msg_pub.add;

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;
4143: --RAISE FND_API.g_exc_error;

Line 4149: fnd_msg_pub.add;

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

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

4160: /* yzhao: 02/04/2003 fix bug: can not close an accrual budget if it already accrued some fund
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:

Line 4166: fnd_msg_pub.add;

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

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

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

Line 4175: fnd_msg_pub.add;

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;
4179: END IF;*/

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

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

Line 4184: fnd_msg_pub.add;

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

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

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

Line 4194: fnd_msg_pub.add;

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

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

4199: */
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:

Line 4205: fnd_msg_pub.add;

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

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

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

Line 4215: fnd_msg_pub.add;

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

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

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

Line 4225: fnd_msg_pub.add;

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

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

4257: ,'FUND'
4258: ,l_resource_id
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');

Line 4267: fnd_msg_pub.add;

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:
4270: x_return_status := fnd_api.g_ret_sts_error;
4271: END IF;

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

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

Line 4275: fnd_msg_pub.add;

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

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

4290: p_ledger_id => l_offer_ledger,
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;

Line 4296: fnd_msg_pub.add;

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

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

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

Line 4525: fnd_msg_pub.add;

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

Line 5430: FND_MSG_PUB.initialize;

5426: END IF;
5427:
5428: -- Initialize message list if p_init_msg_list is set to TRUE.
5429: IF FND_API.to_Boolean( p_init_msg_list )THEN
5430: FND_MSG_PUB.initialize;
5431: END IF;
5432:
5433: IF G_DEBUG THEN
5434: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');

Line 5708: FND_MSG_PUB.Count_And_Get (

5704: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
5705: END IF;
5706:
5707: -- Standard call to get message count and if count is 1, get message info.
5708: FND_MSG_PUB.Count_And_Get (
5709: p_count => x_msg_count,
5710: p_data => x_msg_data
5711: );
5712: EXCEPTION

Line 5717: FND_MSG_PUB.Count_And_Get (

5713: WHEN FND_API.G_EXC_ERROR THEN
5714: ROLLBACK TO copy_fund;
5715: x_return_status := FND_API.G_RET_STS_ERROR;
5716: -- Standard call to get message count and if count=1, get the message
5717: FND_MSG_PUB.Count_And_Get (
5718: p_encoded => FND_API.G_FALSE,
5719: p_count => x_msg_count,
5720: p_data => x_msg_data
5721: );

Line 5726: FND_MSG_PUB.Count_And_Get (

5722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5723: ROLLBACK TO copy_fund;
5724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5725: -- Standard call to get message count and if count=1, get the message
5726: FND_MSG_PUB.Count_And_Get (
5727: p_encoded => FND_API.G_FALSE,
5728: p_count => x_msg_count,
5729: p_data => x_msg_data
5730: );

Line 5734: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

5730: );
5731: WHEN OTHERS THEN
5732: ROLLBACK TO copy_fund;
5733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5734: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5735: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5736: END IF;
5737: -- Standard call to get message count and if count=1, get the message
5738: FND_MSG_PUB.Count_And_Get (

Line 5735: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

5731: WHEN OTHERS THEN
5732: ROLLBACK TO copy_fund;
5733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5734: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5735: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5736: END IF;
5737: -- Standard call to get message count and if count=1, get the message
5738: FND_MSG_PUB.Count_And_Get (
5739: p_encoded => FND_API.G_FALSE,

Line 5738: FND_MSG_PUB.Count_And_Get (

5734: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5735: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5736: END IF;
5737: -- Standard call to get message count and if count=1, get the message
5738: FND_MSG_PUB.Count_And_Get (
5739: p_encoded => FND_API.G_FALSE,
5740: p_count => x_msg_count,
5741: p_data => x_msg_data
5742: );

Line 5805: FND_MSG_PUB.initialize;

5801: END IF;
5802:
5803: -- Initialize message list if p_init_msg_list is set to TRUE.
5804: IF FND_API.to_Boolean( p_init_msg_list )THEN
5805: FND_MSG_PUB.initialize;
5806: END IF;
5807:
5808: IF G_DEBUG THEN
5809: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');

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

5831: WHERE fund_id = fund.fund_id
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:

Line 5837: fnd_msg_pub.add;

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

Line 5845: fnd_msg_pub.count_and_get(

5841: END IF;
5842: END IF;
5843: END LOOP;
5844: -------------------- finish --------------------------
5845: fnd_msg_pub.count_and_get(
5846: p_encoded => fnd_api.g_false
5847: ,p_count => x_msg_count
5848: ,p_data => x_msg_data);
5849: IF G_DEBUG THEN

Line 5855: fnd_msg_pub.count_and_get(

5851: END IF;
5852: EXCEPTION
5853: WHEN fnd_api.g_exc_error THEN
5854: x_return_status := fnd_api.g_ret_sts_error;
5855: fnd_msg_pub.count_and_get(
5856: p_encoded => fnd_api.g_false
5857: ,p_count => x_msg_count
5858: ,p_data => x_msg_data);
5859: WHEN fnd_api.g_exc_unexpected_error THEN

Line 5861: fnd_msg_pub.count_and_get(

5857: ,p_count => x_msg_count
5858: ,p_data => x_msg_data);
5859: WHEN fnd_api.g_exc_unexpected_error THEN
5860: x_return_status := fnd_api.g_ret_sts_unexp_error;
5861: fnd_msg_pub.count_and_get(
5862: p_encoded => fnd_api.g_false
5863: ,p_count => x_msg_count
5864: ,p_data => x_msg_data);
5865: WHEN OTHERS THEN

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

5864: ,p_data => x_msg_data);
5865: WHEN OTHERS THEN
5866: x_return_status := fnd_api.g_ret_sts_unexp_error;
5867:
5868: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5869: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5870: END IF;
5871:
5872: fnd_msg_pub.count_and_get(

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

5865: WHEN OTHERS THEN
5866: x_return_status := fnd_api.g_ret_sts_unexp_error;
5867:
5868: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5869: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5870: END IF;
5871:
5872: fnd_msg_pub.count_and_get(
5873: p_encoded => fnd_api.g_false

Line 5872: fnd_msg_pub.count_and_get(

5868: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5869: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5870: END IF;
5871:
5872: fnd_msg_pub.count_and_get(
5873: p_encoded => fnd_api.g_false
5874: ,p_count => x_msg_count
5875: ,p_data => x_msg_data);
5876:

Line 5954: FND_MSG_PUB.initialize;

5950: END IF;
5951:
5952: -- Initialize message list if p_init_msg_list is set to TRUE.
5953: IF FND_API.to_Boolean( p_init_msg_list )THEN
5954: FND_MSG_PUB.initialize;
5955: END IF;
5956:
5957: IF G_DEBUG THEN
5958: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');

Line 6035: fnd_msg_pub.count_and_get(

6031: END IF; -- end delete access mode.
6032: END IF;
6033: END LOOP;
6034: -------------------- finish --------------------------
6035: fnd_msg_pub.count_and_get(
6036: p_encoded => fnd_api.g_false
6037: ,p_count => x_msg_count
6038: ,p_data => x_msg_data);
6039: IF G_DEBUG THEN

Line 6046: fnd_msg_pub.count_and_get(

6042:
6043: EXCEPTION
6044: WHEN fnd_api.g_exc_error THEN
6045: x_return_status := fnd_api.g_ret_sts_error;
6046: fnd_msg_pub.count_and_get(
6047: p_encoded => fnd_api.g_false
6048: ,p_count => x_msg_count
6049: ,p_data => x_msg_data);
6050: WHEN fnd_api.g_exc_unexpected_error THEN

Line 6052: fnd_msg_pub.count_and_get(

6048: ,p_count => x_msg_count
6049: ,p_data => x_msg_data);
6050: WHEN fnd_api.g_exc_unexpected_error THEN
6051: x_return_status := fnd_api.g_ret_sts_unexp_error;
6052: fnd_msg_pub.count_and_get(
6053: p_encoded => fnd_api.g_false
6054: ,p_count => x_msg_count
6055: ,p_data => x_msg_data);
6056: WHEN OTHERS THEN

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

6055: ,p_data => x_msg_data);
6056: WHEN OTHERS THEN
6057: x_return_status := fnd_api.g_ret_sts_unexp_error;
6058:
6059: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6060: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
6061: END IF;
6062:
6063: fnd_msg_pub.count_and_get(

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

6056: WHEN OTHERS THEN
6057: x_return_status := fnd_api.g_ret_sts_unexp_error;
6058:
6059: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6060: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
6061: END IF;
6062:
6063: fnd_msg_pub.count_and_get(
6064: p_encoded => fnd_api.g_false

Line 6063: fnd_msg_pub.count_and_get(

6059: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6060: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
6061: END IF;
6062:
6063: fnd_msg_pub.count_and_get(
6064: p_encoded => fnd_api.g_false
6065: ,p_count => x_msg_count
6066: ,p_data => x_msg_data);
6067: