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 119: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

115: -- addded 08/14/2001 mpande
116: g_activity_type CONSTANT VARCHAR2(30) := 'RFRQ';
117: -- added 02/08/2002 by feliu
118: g_universal_currency CONSTANT VARCHAR2 (15) := fnd_profile.VALUE ('OZF_UNIV_CURR_CODE');
119: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
120:
121:
122: -----------------------------------------------------------------------
123: -- PROCEDURE

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

231: FETCH c_parent_number INTO l_par_number;
232: CLOSE c_parent_number;
233:
234: IF l_par_number IS NULL THEN
235: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
236: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
237: fnd_msg_pub.add;
238: END IF;
239:

Line 237: fnd_msg_pub.add;

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

Line 408: fnd_msg_pub.initialize;

404: END IF;
405: x_return_status := fnd_api.g_ret_sts_success;
406:
407: IF fnd_api.to_boolean(p_init_msg_list) THEN
408: fnd_msg_pub.initialize;
409: END IF;
410:
411: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
412: RAISE fnd_api.g_exc_unexpected_error;

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

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

Line 542: fnd_msg_pub.add;

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

Line 1132: fnd_msg_pub.count_and_get(

1128:
1129: -- raise business event.
1130: raise_business_event(p_object_id => p_fund_rec.fund_id ,p_event_type =>'CREATE');
1131:
1132: fnd_msg_pub.count_and_get(
1133: p_encoded => fnd_api.g_false
1134: ,p_count => x_msg_count
1135: ,p_data => x_msg_data);
1136: IF G_DEBUG THEN

Line 1144: fnd_msg_pub.count_and_get(

1140: EXCEPTION
1141: WHEN fnd_api.g_exc_error THEN
1142: ROLLBACK TO create_fund;
1143: x_return_status := fnd_api.g_ret_sts_error;
1144: fnd_msg_pub.count_and_get(
1145: p_encoded => fnd_api.g_false
1146: ,p_count => x_msg_count
1147: ,p_data => x_msg_data);
1148: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1151: fnd_msg_pub.count_and_get(

1147: ,p_data => x_msg_data);
1148: WHEN fnd_api.g_exc_unexpected_error THEN
1149: ROLLBACK TO create_fund;
1150: x_return_status := fnd_api.g_ret_sts_unexp_error;
1151: fnd_msg_pub.count_and_get(
1152: p_encoded => fnd_api.g_false
1153: ,p_count => x_msg_count
1154: ,p_data => x_msg_data);
1155: WHEN OTHERS THEN

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

1155: WHEN OTHERS THEN
1156: ROLLBACK TO create_fund;
1157: x_return_status := fnd_api.g_ret_sts_unexp_error;
1158:
1159: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1160: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1161: END IF;
1162:
1163: fnd_msg_pub.count_and_get(

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

1156: ROLLBACK TO create_fund;
1157: x_return_status := fnd_api.g_ret_sts_unexp_error;
1158:
1159: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1160: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1161: END IF;
1162:
1163: fnd_msg_pub.count_and_get(
1164: p_encoded => fnd_api.g_false

Line 1163: fnd_msg_pub.count_and_get(

1159: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1160: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1161: END IF;
1162:
1163: fnd_msg_pub.count_and_get(
1164: p_encoded => fnd_api.g_false
1165: ,p_count => x_msg_count
1166: ,p_data => x_msg_data);
1167: END create_fund;

Line 1199: fnd_msg_pub.initialize;

1195: ozf_utility_pvt.debug_message(l_full_name || ': start');
1196: END IF;
1197:
1198: IF fnd_api.to_boolean(p_init_msg_list) THEN
1199: fnd_msg_pub.initialize;
1200: END IF;
1201:
1202: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1203: RAISE fnd_api.g_exc_unexpected_error;

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

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

Line 1220: fnd_msg_pub.add;

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

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

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

Line 1233: fnd_msg_pub.add;

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

Line 1244: fnd_msg_pub.count_and_get(

1240: IF fnd_api.to_boolean(p_commit) THEN
1241: COMMIT;
1242: END IF;
1243:
1244: fnd_msg_pub.count_and_get(
1245: p_encoded => fnd_api.g_false
1246: ,p_count => x_msg_count
1247: ,p_data => x_msg_data);
1248: IF G_DEBUG THEN

Line 1255: fnd_msg_pub.count_and_get(

1251: EXCEPTION
1252: WHEN fnd_api.g_exc_error THEN
1253: ROLLBACK TO delete_fund;
1254: x_return_status := fnd_api.g_ret_sts_error;
1255: fnd_msg_pub.count_and_get(
1256: p_encoded => fnd_api.g_false
1257: ,p_count => x_msg_count
1258: ,p_data => x_msg_data);
1259: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1262: fnd_msg_pub.count_and_get(

1258: ,p_data => x_msg_data);
1259: WHEN fnd_api.g_exc_unexpected_error THEN
1260: ROLLBACK TO delete_fund;
1261: x_return_status := fnd_api.g_ret_sts_unexp_error;
1262: fnd_msg_pub.count_and_get(
1263: p_encoded => fnd_api.g_false
1264: ,p_count => x_msg_count
1265: ,p_data => x_msg_data);
1266: WHEN OTHERS THEN

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

1266: WHEN OTHERS THEN
1267: ROLLBACK TO delete_fund;
1268: x_return_status := fnd_api.g_ret_sts_unexp_error;
1269:
1270: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1271: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1272: END IF;
1273:
1274: fnd_msg_pub.count_and_get(

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

1267: ROLLBACK TO delete_fund;
1268: x_return_status := fnd_api.g_ret_sts_unexp_error;
1269:
1270: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1271: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1272: END IF;
1273:
1274: fnd_msg_pub.count_and_get(
1275: p_encoded => fnd_api.g_false

Line 1274: fnd_msg_pub.count_and_get(

1270: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1271: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1272: END IF;
1273:
1274: fnd_msg_pub.count_and_get(
1275: p_encoded => fnd_api.g_false
1276: ,p_count => x_msg_count
1277: ,p_data => x_msg_data);
1278: END delete_fund;

Line 1325: fnd_msg_pub.initialize;

1321: ozf_utility_pvt.debug_message(l_full_name || ': start');
1322: END IF;
1323:
1324: IF fnd_api.to_boolean(p_init_msg_list) THEN
1325: fnd_msg_pub.initialize;
1326: END IF;
1327:
1328: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1329: RAISE fnd_api.g_exc_unexpected_error;

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

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

Line 1345: fnd_msg_pub.add;

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

Line 1355: fnd_msg_pub.count_and_get(

1351: CLOSE c_fund_b;
1352: OPEN c_fund_tl;
1353: CLOSE c_fund_tl;
1354: -------------------- finish --------------------------
1355: fnd_msg_pub.count_and_get(
1356: p_encoded => fnd_api.g_false
1357: ,p_count => x_msg_count
1358: ,p_data => x_msg_data);
1359: IF G_DEBUG THEN

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

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

Line 1368: fnd_msg_pub.add;

1364: x_return_status := fnd_api.g_ret_sts_error;
1365:
1366: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1367: fnd_message.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');
1368: fnd_msg_pub.add;
1369: END IF;
1370:
1371: fnd_msg_pub.count_and_get(
1372: p_encoded => fnd_api.g_false

Line 1371: fnd_msg_pub.count_and_get(

1367: fnd_message.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');
1368: fnd_msg_pub.add;
1369: END IF;
1370:
1371: fnd_msg_pub.count_and_get(
1372: p_encoded => fnd_api.g_false
1373: ,p_count => x_msg_count
1374: ,p_data => x_msg_data);
1375: WHEN fnd_api.g_exc_error THEN

Line 1377: fnd_msg_pub.count_and_get(

1373: ,p_count => x_msg_count
1374: ,p_data => x_msg_data);
1375: WHEN fnd_api.g_exc_error THEN
1376: x_return_status := fnd_api.g_ret_sts_error;
1377: fnd_msg_pub.count_and_get(
1378: p_encoded => fnd_api.g_false
1379: ,p_count => x_msg_count
1380: ,p_data => x_msg_data);
1381: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1383: fnd_msg_pub.count_and_get(

1379: ,p_count => x_msg_count
1380: ,p_data => x_msg_data);
1381: WHEN fnd_api.g_exc_unexpected_error THEN
1382: x_return_status := fnd_api.g_ret_sts_unexp_error;
1383: fnd_msg_pub.count_and_get(
1384: p_encoded => fnd_api.g_false
1385: ,p_count => x_msg_count
1386: ,p_data => x_msg_data);
1387: WHEN OTHERS THEN

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

1386: ,p_data => x_msg_data);
1387: WHEN OTHERS THEN
1388: x_return_status := fnd_api.g_ret_sts_unexp_error;
1389:
1390: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1391: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1392: END IF;
1393:
1394: fnd_msg_pub.count_and_get(

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

1387: WHEN OTHERS THEN
1388: x_return_status := fnd_api.g_ret_sts_unexp_error;
1389:
1390: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1391: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1392: END IF;
1393:
1394: fnd_msg_pub.count_and_get(
1395: p_encoded => fnd_api.g_false

Line 1394: fnd_msg_pub.count_and_get(

1390: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1391: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1392: END IF;
1393:
1394: fnd_msg_pub.count_and_get(
1395: p_encoded => fnd_api.g_false
1396: ,p_count => x_msg_count
1397: ,p_data => x_msg_data);
1398: END lock_fund;

Line 1618: fnd_msg_pub.initialize;

1614: ozf_utility_pvt.debug_message(l_full_name || ': start');
1615: END IF;
1616:
1617: IF fnd_api.to_boolean(p_init_msg_list) THEN
1618: fnd_msg_pub.initialize;
1619: END IF;
1620:
1621: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1622: RAISE fnd_api.g_exc_unexpected_error;

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

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

Line 2499: fnd_msg_pub.add;

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

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

2517: WHERE fund_id = l_fund_rec.fund_id
2518: AND USERENV('LANG') IN(language, source_lang);
2519:
2520: IF (SQL%NOTFOUND) THEN
2521: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2522: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
2523: fnd_msg_pub.add;
2524: END IF;
2525:

Line 2523: fnd_msg_pub.add;

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

Line 2886: fnd_msg_pub.count_and_get(

2882: IF fnd_api.to_boolean(p_commit) THEN
2883: COMMIT;
2884: END IF;
2885:
2886: fnd_msg_pub.count_and_get(
2887: p_encoded => fnd_api.g_false
2888: ,p_count => x_msg_count
2889: ,p_data => x_msg_data);
2890: IF G_DEBUG THEN

Line 2897: fnd_msg_pub.count_and_get(

2893: EXCEPTION
2894: WHEN fnd_api.g_exc_error THEN
2895: ROLLBACK TO update_fund;
2896: x_return_status := fnd_api.g_ret_sts_error;
2897: fnd_msg_pub.count_and_get(
2898: p_encoded => fnd_api.g_false
2899: ,p_count => x_msg_count
2900: ,p_data => x_msg_data);
2901: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2904: fnd_msg_pub.count_and_get(

2900: ,p_data => x_msg_data);
2901: WHEN fnd_api.g_exc_unexpected_error THEN
2902: ROLLBACK TO update_fund;
2903: x_return_status := fnd_api.g_ret_sts_unexp_error;
2904: fnd_msg_pub.count_and_get(
2905: p_encoded => fnd_api.g_false
2906: ,p_count => x_msg_count
2907: ,p_data => x_msg_data);
2908: WHEN OTHERS THEN

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

2908: WHEN OTHERS THEN
2909: ROLLBACK TO update_fund;
2910: x_return_status := fnd_api.g_ret_sts_unexp_error;
2911:
2912: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2913: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2914: END IF;
2915:
2916: fnd_msg_pub.count_and_get(

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

2909: ROLLBACK TO update_fund;
2910: x_return_status := fnd_api.g_ret_sts_unexp_error;
2911:
2912: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2913: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2914: END IF;
2915:
2916: fnd_msg_pub.count_and_get(
2917: p_encoded => fnd_api.g_false

Line 2916: fnd_msg_pub.count_and_get(

2912: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2913: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2914: END IF;
2915:
2916: fnd_msg_pub.count_and_get(
2917: p_encoded => fnd_api.g_false
2918: ,p_count => x_msg_count
2919: ,p_data => x_msg_data);
2920: END update_fund;

Line 2952: fnd_msg_pub.initialize;

2948: ozf_utility_pvt.debug_message(l_full_name || ': start');
2949: END IF;
2950:
2951: IF fnd_api.to_boolean(p_init_msg_list) THEN
2952: fnd_msg_pub.initialize;
2953: END IF;
2954:
2955: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2956: RAISE fnd_api.g_exc_unexpected_error;

Line 3018: fnd_msg_pub.count_and_get(

3014: END IF;
3015: END IF;
3016:
3017: -------------------- finish --------------------------
3018: fnd_msg_pub.count_and_get(
3019: p_encoded => fnd_api.g_false
3020: ,p_count => x_msg_count
3021: ,p_data => x_msg_data);
3022: IF G_DEBUG THEN

Line 3028: fnd_msg_pub.count_and_get(

3024: END IF;
3025: EXCEPTION
3026: WHEN fnd_api.g_exc_error THEN
3027: x_return_status := fnd_api.g_ret_sts_error;
3028: fnd_msg_pub.count_and_get(
3029: p_encoded => fnd_api.g_false
3030: ,p_count => x_msg_count
3031: ,p_data => x_msg_data);
3032: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3034: fnd_msg_pub.count_and_get(

3030: ,p_count => x_msg_count
3031: ,p_data => x_msg_data);
3032: WHEN fnd_api.g_exc_unexpected_error THEN
3033: x_return_status := fnd_api.g_ret_sts_unexp_error;
3034: fnd_msg_pub.count_and_get(
3035: p_encoded => fnd_api.g_false
3036: ,p_count => x_msg_count
3037: ,p_data => x_msg_data);
3038: WHEN OTHERS THEN

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

3037: ,p_data => x_msg_data);
3038: WHEN OTHERS THEN
3039: x_return_status := fnd_api.g_ret_sts_unexp_error;
3040:
3041: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3042: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3043: END IF;
3044:
3045: fnd_msg_pub.count_and_get(

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

3038: WHEN OTHERS THEN
3039: x_return_status := fnd_api.g_ret_sts_unexp_error;
3040:
3041: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3042: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3043: END IF;
3044:
3045: fnd_msg_pub.count_and_get(
3046: p_encoded => fnd_api.g_false

Line 3045: fnd_msg_pub.count_and_get(

3041: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3042: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3043: END IF;
3044:
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: END validate_fund;

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

3067:
3068: -- Commented by mpande 02/16/2001 We are going to generate the number if it is null
3069: ------------------------ fund_number --------------------------
3070: /* IF p_fund_rec.fund_number IS NULL THEN -- check for fund number
3071: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3072: IF p_fund_rec.fund_type = 'QUOTA' THEN
3073: fnd_message.set_name('OZF', 'OZF_TP_NO_QUOTA_NUMBER');
3074: ELSE
3075: fnd_message.set_name('OZF', 'OZF_FUND_NO_FUND_NUMBER');

Line 3077: fnd_msg_pub.add;

3073: fnd_message.set_name('OZF', 'OZF_TP_NO_QUOTA_NUMBER');
3074: ELSE
3075: fnd_message.set_name('OZF', 'OZF_FUND_NO_FUND_NUMBER');
3076: END IF;
3077: fnd_msg_pub.add;
3078: END IF;
3079:
3080: x_return_status := fnd_api.g_ret_sts_error;
3081: RETURN;

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

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

Line 3092: fnd_msg_pub.add;

3088: fnd_message.set_name('OZF', 'OZF_TP_NO_QUOTA_OWNER');
3089: ELSE
3090: fnd_message.set_name('OZF', 'OZF_FUND_NO_FUND_OWNER');
3091: END IF;
3092: fnd_msg_pub.add;
3093: END IF;
3094:
3095: x_return_status := fnd_api.g_ret_sts_error;
3096: RETURN;

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

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

Line 3102: fnd_msg_pub.add;

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

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

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

Line 3113: fnd_msg_pub.add;

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

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

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

Line 3124: fnd_msg_pub.add;

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

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

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

Line 3134: fnd_msg_pub.add;

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

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

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

Line 3154: fnd_msg_pub.add;

3150: fnd_message.set_name('OZF', 'OZF_TP_NO_ORG_QUOTA');
3151: ELSE
3152: fnd_message.set_name('OZF', 'OZF_FUND_NO_ORG_BUDGET');
3153: END IF;
3154: fnd_msg_pub.add;
3155: END IF;
3156:
3157: x_return_status := fnd_api.g_ret_sts_error;
3158: RETURN;

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

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

Line 3166: fnd_msg_pub.add;

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

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

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

Line 3178: fnd_msg_pub.add;

3174: so org_id is not required
3175: IF p_fund_rec.org_id IS NULL THEN -- check for org id
3176: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3177: fnd_message.set_name('OZF', 'OZF_NO_DEFAULT_ORG_ID');
3178: fnd_msg_pub.add;
3179: END IF;
3180:
3181: x_return_status := fnd_api.g_ret_sts_error;
3182: RETURN;

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

3223: IF ozf_utility_pvt.check_uniqueness(
3224: 'ozf_funds_all_vl'
3225: ,'fund_id = ' || p_fund_rec.fund_id) =
3226: fnd_api.g_false THEN
3227: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3228: IF p_fund_rec.fund_type = 'QUOTA' THEN
3229: fnd_message.set_name('OZF', 'OZF_TP_DUPLICATE_ID');
3230: ELSE
3231: fnd_message.set_name('OZF', 'OZF_FUND_DUPLICATE_ID');

Line 3233: fnd_msg_pub.add;

3229: fnd_message.set_name('OZF', 'OZF_TP_DUPLICATE_ID');
3230: ELSE
3231: fnd_message.set_name('OZF', 'OZF_FUND_DUPLICATE_ID');
3232: END IF;
3233: fnd_msg_pub.add;
3234: END IF;
3235:
3236: x_return_status := fnd_api.g_ret_sts_error;
3237: RETURN;

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

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

Line 3271: fnd_msg_pub.add;

3267: fnd_message.set_name('OZF', 'OZF_TP_DUPLICATE_NUMBER');
3268: ELSE
3269: fnd_message.set_name('OZF', 'OZF_FUND_DUPLICATE_NUMBER');
3270: END IF;
3271: fnd_msg_pub.add;
3272: END IF;
3273:
3274: x_return_status := fnd_api.g_ret_sts_error;
3275: RETURN;

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

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

Line 3304: fnd_msg_pub.add;

3300: fnd_message.set_name('OZF', 'OZF_TP_DUPLICATE_NAME');
3301: ELSE
3302: fnd_message.set_name('OZF', 'OZF_FUND_DUPLICATE_NAME');
3303: END IF;
3304: fnd_msg_pub.add;
3305: END IF;
3306:
3307: x_return_status := fnd_api.g_ret_sts_error;
3308: RETURN;

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

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

Line 3339: fnd_msg_pub.add;

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

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

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

Line 3359: fnd_msg_pub.add;

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

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

3391: p_lookup_table_name => 'OZF_LOOKUPS'
3392: ,p_lookup_type => 'OZF_FUND_TYPE'
3393: ,p_lookup_code => p_fund_rec.fund_type) =
3394: fnd_api.g_false THEN
3395: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3396: IF p_fund_rec.fund_type = 'QUOTA' THEN
3397: fnd_message.set_name('OZF', 'OZF_TP_BAD_QUOTA_TYPE');
3398: ELSE
3399: fnd_message.set_name('OZF', 'OZF_FUND_BAD_FUND_TYPE');

Line 3401: fnd_msg_pub.add;

3397: fnd_message.set_name('OZF', 'OZF_TP_BAD_QUOTA_TYPE');
3398: ELSE
3399: fnd_message.set_name('OZF', 'OZF_FUND_BAD_FUND_TYPE');
3400: END IF;
3401: fnd_msg_pub.add;
3402: END IF;
3403:
3404: x_return_status := fnd_api.g_ret_sts_error;
3405: RETURN;

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

3413: p_lookup_table_name => 'OZF_LOOKUPS'
3414: ,p_lookup_type => 'OZF_FUND_STATUS'
3415: ,p_lookup_code => p_fund_rec.status_code) =
3416: fnd_api.g_false THEN
3417: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3418: IF p_fund_rec.fund_type = 'QUOTA' THEN
3419: fnd_message.set_name('OZF', 'OZF_TP_BAD_STATUS_CODE');
3420: ELSE
3421: fnd_message.set_name('OZF', 'OZF_FUND_BAD_STATUS_CODE');

Line 3423: fnd_msg_pub.add;

3419: fnd_message.set_name('OZF', 'OZF_TP_BAD_STATUS_CODE');
3420: ELSE
3421: fnd_message.set_name('OZF', 'OZF_FUND_BAD_STATUS_CODE');
3422: END IF;
3423: fnd_msg_pub.add;
3424: END IF;
3425:
3426: x_return_status := fnd_api.g_ret_sts_error;
3427: RETURN;

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

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

Line 3456: fnd_msg_pub.add;

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

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

3464: ----------------------- budget_flag ------------------------
3465: IF p_fund_rec.budget_flag <> fnd_api.g_miss_char
3466: AND p_fund_rec.budget_flag IS NOT NULL THEN
3467: IF ozf_utility_pvt.is_y_or_n(p_fund_rec.budget_flag) = fnd_api.g_false THEN
3468: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3469: IF p_fund_rec.fund_type = 'QUOTA' THEN
3470: fnd_message.set_name('OZF', 'OZF_TP_BAD_QUOTA_FLAG');
3471: ELSE
3472: fnd_message.set_name('OZF', 'OZF_FUND_BAD_BUDGET_FLAG');

Line 3474: fnd_msg_pub.add;

3470: fnd_message.set_name('OZF', 'OZF_TP_BAD_QUOTA_FLAG');
3471: ELSE
3472: fnd_message.set_name('OZF', 'OZF_FUND_BAD_BUDGET_FLAG');
3473: END IF;
3474: fnd_msg_pub.add;
3475: END IF;
3476:
3477: x_return_status := fnd_api.g_ret_sts_error;
3478: RETURN;

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

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

Line 3488: fnd_msg_pub.add;

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

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

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

Line 3611: fnd_msg_pub.add;

3607: -- start date passed in is midnight of the selected day. So trunc sysdate to get midnight time
3608: IF NVL(l_start_date, sysdate) < trunc(sysdate) THEN
3609: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3610: fnd_message.set_name('OZF', 'OZF_FUND_STARTDATE_MISMATCH');
3611: fnd_msg_pub.add;
3612: END IF;
3613:
3614: x_return_status := fnd_api.g_ret_sts_error;
3615: END IF;

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

3638: /* kdass 28-Dec-2004 fix for 11.5.10 bug 4089720, when the fund is created from mass transfer,
3639: do not check for end date */
3640: --IF NVL(l_end_date,sysdate) < trunc(sysdate) THEN
3641: IF NVL(l_end_date,sysdate) < trunc(sysdate) AND p_fund_rec.prev_fund_id IS NULL THEN
3642: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3643: IF p_fund_rec.fund_type = 'QUOTA' THEN
3644: fnd_message.set_name('OZF', 'OZF_TP_ENDDATE_MISMATCH');
3645: ELSE
3646: fnd_message.set_name('OZF', 'OZF_FUND_ENDDATE_MISMATCH');

Line 3648: fnd_msg_pub.add;

3644: fnd_message.set_name('OZF', 'OZF_TP_ENDDATE_MISMATCH');
3645: ELSE
3646: fnd_message.set_name('OZF', 'OZF_FUND_ENDDATE_MISMATCH');
3647: END IF;
3648: fnd_msg_pub.add;
3649: END IF;
3650: x_return_status := fnd_api.g_ret_sts_error;
3651: END IF;
3652: END IF;

Line 3663: fnd_msg_pub.add;

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

Line 3675: fnd_msg_pub.add;

3671: fnd_message.set_name('OZF', 'OZF_TP_MAX_AMT_EXCEEDED');
3672: ELSE
3673: fnd_message.set_name('OZF', 'OZF_FUND_MAX_AMT_EXCEEDED');
3674: END IF;
3675: fnd_msg_pub.add;
3676: x_return_status := fnd_api.g_ret_sts_error;
3677: END IF;
3678:
3679: IF l_start_date > l_end_date THEN

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

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

Line 3682: fnd_msg_pub.add;

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

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

3688: IF p_mode = jtf_plsql_api.g_update THEN
3689: IF p_fund_rec.parent_fund_id <> fnd_api.g_miss_num
3690: AND p_fund_rec.parent_fund_id IS NOT NULL THEN
3691: IF p_complete_rec.fund_id = p_complete_rec.parent_fund_id THEN
3692: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3693: IF p_fund_rec.fund_type = 'QUOTA' THEN
3694: fnd_message.set_name('OZF', 'OZF_TP_WRONG_PARENT');
3695: ELSE
3696: fnd_message.set_name('OZF', 'OZF_FUND_WRONG_PARENT');

Line 3698: fnd_msg_pub.add;

3694: fnd_message.set_name('OZF', 'OZF_TP_WRONG_PARENT');
3695: ELSE
3696: fnd_message.set_name('OZF', 'OZF_FUND_WRONG_PARENT');
3697: END IF;
3698: fnd_msg_pub.add;
3699: x_return_status := fnd_api.g_ret_sts_error;
3700: END IF;
3701: END IF;
3702: END IF;

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

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

Line 3720: fnd_msg_pub.add;

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

Line 3729: fnd_msg_pub.add;

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

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

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

Line 3737: fnd_msg_pub.add;

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

Line 3747: fnd_msg_pub.add;

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

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

3758: /* yzhao: 02/04/2003 fix bug: can not close an accrual budget if it already accrued some fund
3759: IF NVL(p_complete_rec.original_budget, 0) <> 0 AND p_complete_rec.status_code IN ('DRAFT','CLOSED','CANCELLED','ARCHIVED') THEN
3760: */
3761: IF NVL(p_complete_rec.original_budget, 0) <> 0 AND p_complete_rec.status_code = 'DRAFT' THEN
3762: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3763: fnd_message.set_name('OZF', 'OZF_ACCRUAL_NO_ORG_BUDGET');
3764: fnd_msg_pub.add;
3765: END IF;
3766:

Line 3764: fnd_msg_pub.add;

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

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

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

Line 3773: fnd_msg_pub.add;

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

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

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

Line 3782: fnd_msg_pub.add;

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

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

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

Line 3792: fnd_msg_pub.add;

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

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

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

Line 3803: fnd_msg_pub.add;

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

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

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

Line 3813: fnd_msg_pub.add;

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

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

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

Line 3823: fnd_msg_pub.add;

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

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

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

Line 3865: fnd_msg_pub.add;

3861: fnd_message.set_name('OZF', 'OZF_TP_ILLEGAL_OWNER');
3862: ELSE
3863: fnd_message.set_name('OZF', 'OZF_FUND_ILLEGAL_OWNER');
3864: END IF;
3865: fnd_msg_pub.add;
3866: END IF;
3867:
3868: x_return_status := fnd_api.g_ret_sts_error;
3869: END IF;

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

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

Line 3873: fnd_msg_pub.add;

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

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

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

Line 3894: fnd_msg_pub.add;

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

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

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

Line 4123: fnd_msg_pub.add;

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

Line 5028: FND_MSG_PUB.initialize;

5024: END IF;
5025:
5026: -- Initialize message list if p_init_msg_list is set to TRUE.
5027: IF FND_API.to_Boolean( p_init_msg_list )THEN
5028: FND_MSG_PUB.initialize;
5029: END IF;
5030:
5031: IF G_DEBUG THEN
5032: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');

Line 5280: FND_MSG_PUB.Count_And_Get (

5276: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
5277: END IF;
5278:
5279: -- Standard call to get message count and if count is 1, get message info.
5280: FND_MSG_PUB.Count_And_Get (
5281: p_count => x_msg_count,
5282: p_data => x_msg_data
5283: );
5284: EXCEPTION

Line 5289: FND_MSG_PUB.Count_And_Get (

5285: WHEN FND_API.G_EXC_ERROR THEN
5286: ROLLBACK TO copy_fund;
5287: x_return_status := FND_API.G_RET_STS_ERROR;
5288: -- Standard call to get message count and if count=1, get the message
5289: FND_MSG_PUB.Count_And_Get (
5290: p_encoded => FND_API.G_FALSE,
5291: p_count => x_msg_count,
5292: p_data => x_msg_data
5293: );

Line 5298: FND_MSG_PUB.Count_And_Get (

5294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5295: ROLLBACK TO copy_fund;
5296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5297: -- Standard call to get message count and if count=1, get the message
5298: FND_MSG_PUB.Count_And_Get (
5299: p_encoded => FND_API.G_FALSE,
5300: p_count => x_msg_count,
5301: p_data => x_msg_data
5302: );

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

5302: );
5303: WHEN OTHERS THEN
5304: ROLLBACK TO copy_fund;
5305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5306: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5307: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5308: END IF;
5309: -- Standard call to get message count and if count=1, get the message
5310: FND_MSG_PUB.Count_And_Get (

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

5303: WHEN OTHERS THEN
5304: ROLLBACK TO copy_fund;
5305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5306: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5307: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5308: END IF;
5309: -- Standard call to get message count and if count=1, get the message
5310: FND_MSG_PUB.Count_And_Get (
5311: p_encoded => FND_API.G_FALSE,

Line 5310: FND_MSG_PUB.Count_And_Get (

5306: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5307: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5308: END IF;
5309: -- Standard call to get message count and if count=1, get the message
5310: FND_MSG_PUB.Count_And_Get (
5311: p_encoded => FND_API.G_FALSE,
5312: p_count => x_msg_count,
5313: p_data => x_msg_data
5314: );

Line 5377: FND_MSG_PUB.initialize;

5373: END IF;
5374:
5375: -- Initialize message list if p_init_msg_list is set to TRUE.
5376: IF FND_API.to_Boolean( p_init_msg_list )THEN
5377: FND_MSG_PUB.initialize;
5378: END IF;
5379:
5380: IF G_DEBUG THEN
5381: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');

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

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

Line 5409: fnd_msg_pub.add;

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

Line 5417: fnd_msg_pub.count_and_get(

5413: END IF;
5414: END IF;
5415: END LOOP;
5416: -------------------- finish --------------------------
5417: fnd_msg_pub.count_and_get(
5418: p_encoded => fnd_api.g_false
5419: ,p_count => x_msg_count
5420: ,p_data => x_msg_data);
5421: IF G_DEBUG THEN

Line 5427: fnd_msg_pub.count_and_get(

5423: END IF;
5424: EXCEPTION
5425: WHEN fnd_api.g_exc_error THEN
5426: x_return_status := fnd_api.g_ret_sts_error;
5427: fnd_msg_pub.count_and_get(
5428: p_encoded => fnd_api.g_false
5429: ,p_count => x_msg_count
5430: ,p_data => x_msg_data);
5431: WHEN fnd_api.g_exc_unexpected_error THEN

Line 5433: fnd_msg_pub.count_and_get(

5429: ,p_count => x_msg_count
5430: ,p_data => x_msg_data);
5431: WHEN fnd_api.g_exc_unexpected_error THEN
5432: x_return_status := fnd_api.g_ret_sts_unexp_error;
5433: fnd_msg_pub.count_and_get(
5434: p_encoded => fnd_api.g_false
5435: ,p_count => x_msg_count
5436: ,p_data => x_msg_data);
5437: WHEN OTHERS THEN

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

5436: ,p_data => x_msg_data);
5437: WHEN OTHERS THEN
5438: x_return_status := fnd_api.g_ret_sts_unexp_error;
5439:
5440: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5441: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5442: END IF;
5443:
5444: fnd_msg_pub.count_and_get(

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

5437: WHEN OTHERS THEN
5438: x_return_status := fnd_api.g_ret_sts_unexp_error;
5439:
5440: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5441: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5442: END IF;
5443:
5444: fnd_msg_pub.count_and_get(
5445: p_encoded => fnd_api.g_false

Line 5444: fnd_msg_pub.count_and_get(

5440: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5441: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5442: END IF;
5443:
5444: fnd_msg_pub.count_and_get(
5445: p_encoded => fnd_api.g_false
5446: ,p_count => x_msg_count
5447: ,p_data => x_msg_data);
5448:

Line 5526: FND_MSG_PUB.initialize;

5522: END IF;
5523:
5524: -- Initialize message list if p_init_msg_list is set to TRUE.
5525: IF FND_API.to_Boolean( p_init_msg_list )THEN
5526: FND_MSG_PUB.initialize;
5527: END IF;
5528:
5529: IF G_DEBUG THEN
5530: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');

Line 5607: fnd_msg_pub.count_and_get(

5603: END IF; -- end delete access mode.
5604: END IF;
5605: END LOOP;
5606: -------------------- finish --------------------------
5607: fnd_msg_pub.count_and_get(
5608: p_encoded => fnd_api.g_false
5609: ,p_count => x_msg_count
5610: ,p_data => x_msg_data);
5611: IF G_DEBUG THEN

Line 5618: fnd_msg_pub.count_and_get(

5614:
5615: EXCEPTION
5616: WHEN fnd_api.g_exc_error THEN
5617: x_return_status := fnd_api.g_ret_sts_error;
5618: fnd_msg_pub.count_and_get(
5619: p_encoded => fnd_api.g_false
5620: ,p_count => x_msg_count
5621: ,p_data => x_msg_data);
5622: WHEN fnd_api.g_exc_unexpected_error THEN

Line 5624: fnd_msg_pub.count_and_get(

5620: ,p_count => x_msg_count
5621: ,p_data => x_msg_data);
5622: WHEN fnd_api.g_exc_unexpected_error THEN
5623: x_return_status := fnd_api.g_ret_sts_unexp_error;
5624: fnd_msg_pub.count_and_get(
5625: p_encoded => fnd_api.g_false
5626: ,p_count => x_msg_count
5627: ,p_data => x_msg_data);
5628: WHEN OTHERS THEN

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

5627: ,p_data => x_msg_data);
5628: WHEN OTHERS THEN
5629: x_return_status := fnd_api.g_ret_sts_unexp_error;
5630:
5631: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5632: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5633: END IF;
5634:
5635: fnd_msg_pub.count_and_get(

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

5628: WHEN OTHERS THEN
5629: x_return_status := fnd_api.g_ret_sts_unexp_error;
5630:
5631: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5632: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5633: END IF;
5634:
5635: fnd_msg_pub.count_and_get(
5636: p_encoded => fnd_api.g_false

Line 5635: fnd_msg_pub.count_and_get(

5631: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5632: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5633: END IF;
5634:
5635: fnd_msg_pub.count_and_get(
5636: p_encoded => fnd_api.g_false
5637: ,p_count => x_msg_count
5638: ,p_data => x_msg_data);
5639: