eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_FUND_REQUEST_APR_PVT dependencies on FND_MSG_PUB

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

39: g_workflow_process CONSTANT VARCHAR2(30) := 'AMSGAPP';
40: g_item_type CONSTANT VARCHAR2(30) := 'AMSGAPP';
41: -- addded 08/14/2001 mpande
42: g_activity_type CONSTANT VARCHAR2(30) := 'FREQ';
43: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
44: ---------------------------------------------------------------------
45: -- PROCEDURE
46: -- Approve_Request
47: --

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

170: l_source_rec.committed_amt;
171: IF (c_fund_detail%NOTFOUND) THEN
172: CLOSE c_fund_detail;
173:
174: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
175: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
176: fnd_msg_pub.add;
177: END IF;
178:

Line 176: fnd_msg_pub.add;

172: CLOSE c_fund_detail;
173:
174: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
175: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
176: fnd_msg_pub.add;
177: END IF;
178:
179: RAISE fnd_api.g_exc_error;
180: END IF;

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

189: NVL(l_source_rec.source_trans_out_amt, 0)-
190: NVL(l_source_rec.committed_amt, 0)
191: ,0)) <
192: p_approved_amount THEN
193: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
194: fnd_message.set_name('OZF', 'OZF_AMT_UNAVAILABLE');
195: fnd_msg_pub.add;
196: END IF;
197:

Line 195: fnd_msg_pub.add;

191: ,0)) <
192: p_approved_amount THEN
193: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
194: fnd_message.set_name('OZF', 'OZF_AMT_UNAVAILABLE');
195: fnd_msg_pub.add;
196: END IF;
197:
198: RAISE fnd_api.g_exc_error;
199: END IF;

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

204:
205: IF (c_to_fund_currency%NOTFOUND) THEN
206: CLOSE c_to_fund_currency;
207:
208: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
209: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
210: fnd_msg_pub.add;
211: END IF;
212:

Line 210: fnd_msg_pub.add;

206: CLOSE c_to_fund_currency;
207:
208: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
209: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
210: fnd_msg_pub.add;
211: END IF;
212:
213: RAISE fnd_api.g_exc_error;
214: END IF;

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

273:
274: IF (c_target_fund_detail%NOTFOUND) THEN
275: CLOSE c_target_fund_detail;
276:
277: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
278: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
279: fnd_msg_pub.add;
280: END IF;
281:

Line 279: fnd_msg_pub.add;

275: CLOSE c_target_fund_detail;
276:
277: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
278: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
279: fnd_msg_pub.add;
280: END IF;
281:
282: RAISE fnd_api.g_exc_error;
283: END IF;

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

338:
339: IF (c_act_budget_detail%NOTFOUND) THEN
340: CLOSE c_act_budget_detail;
341:
342: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
343: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
344: fnd_msg_pub.add;
345: END IF;
346:

Line 344: fnd_msg_pub.add;

340: CLOSE c_act_budget_detail;
341:
342: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
343: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
344: fnd_msg_pub.add;
345: END IF;
346:
347: RAISE fnd_api.g_exc_error;
348: END IF;

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

408:
409: IF (c_act_budget_detail%NOTFOUND) THEN
410: CLOSE c_act_budget_detail;
411:
412: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
413: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
414: fnd_msg_pub.add;
415: END IF;
416:

Line 414: fnd_msg_pub.add;

410: CLOSE c_act_budget_detail;
411:
412: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
413: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
414: fnd_msg_pub.add;
415: END IF;
416:
417: RAISE fnd_api.g_exc_error;
418: END IF;

Line 450: fnd_msg_pub.count_and_get(

446: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
447: RAISE fnd_api.g_exc_unexpected_error;
448: END IF;
449: END IF ;
450: fnd_msg_pub.count_and_get(
451: p_encoded => fnd_api.g_false
452: ,p_count => x_msg_count
453: ,p_data => x_msg_data);
454:

Line 464: fnd_msg_pub.count_and_get(

460: EXCEPTION
461: WHEN fnd_api.g_exc_error THEN
462: ROLLBACK TO approve_request;
463: x_return_status := fnd_api.g_ret_sts_error;
464: fnd_msg_pub.count_and_get(
465: p_encoded => fnd_api.g_false
466: ,p_count => x_msg_count
467: ,p_data => x_msg_data);
468: WHEN fnd_api.g_exc_unexpected_error THEN

Line 471: fnd_msg_pub.count_and_get(

467: ,p_data => x_msg_data);
468: WHEN fnd_api.g_exc_unexpected_error THEN
469: ROLLBACK TO approve_request;
470: x_return_status := fnd_api.g_ret_sts_unexp_error;
471: fnd_msg_pub.count_and_get(
472: p_encoded => fnd_api.g_false
473: ,p_count => x_msg_count
474: ,p_data => x_msg_data);
475: WHEN OTHERS THEN

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

475: WHEN OTHERS THEN
476: ROLLBACK TO approve_request;
477: x_return_status := fnd_api.g_ret_sts_unexp_error;
478:
479: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
480: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
481: END IF;
482:
483: fnd_msg_pub.count_and_get(

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

476: ROLLBACK TO approve_request;
477: x_return_status := fnd_api.g_ret_sts_unexp_error;
478:
479: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
480: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
481: END IF;
482:
483: fnd_msg_pub.count_and_get(
484: p_encoded => fnd_api.g_false

Line 483: fnd_msg_pub.count_and_get(

479: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
480: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
481: END IF;
482:
483: fnd_msg_pub.count_and_get(
484: p_encoded => fnd_api.g_false
485: ,p_count => x_msg_count
486: ,p_data => x_msg_data);
487: END approve_request;

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

602:
603: IF (c_target_fund_detail%NOTFOUND) THEN
604: CLOSE c_target_fund_detail;
605:
606: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
607: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
608: fnd_msg_pub.add;
609: END IF;
610:

Line 608: fnd_msg_pub.add;

604: CLOSE c_target_fund_detail;
605:
606: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
607: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
608: fnd_msg_pub.add;
609: END IF;
610:
611: RAISE fnd_api.g_exc_error;
612: END IF;

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

673:
674: IF (c_act_budget_detail%NOTFOUND) THEN
675: CLOSE c_act_budget_detail;
676:
677: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
678: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
679: fnd_msg_pub.add;
680: END IF;
681:

Line 679: fnd_msg_pub.add;

675: CLOSE c_act_budget_detail;
676:
677: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
678: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
679: fnd_msg_pub.add;
680: END IF;
681:
682: RAISE fnd_api.g_exc_error;
683: END IF;

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

738:
739: IF (c_act_budget_detail%NOTFOUND) THEN
740: CLOSE c_act_budget_detail;
741:
742: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
743: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
744: fnd_msg_pub.add;
745: END IF;
746:

Line 744: fnd_msg_pub.add;

740: CLOSE c_act_budget_detail;
741:
742: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
743: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
744: fnd_msg_pub.add;
745: END IF;
746:
747: RAISE fnd_api.g_exc_error;
748: END IF;

Line 780: fnd_msg_pub.count_and_get(

776: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
777: RAISE fnd_api.g_exc_unexpected_error;
778: END IF;
779:
780: fnd_msg_pub.count_and_get(
781: p_encoded => fnd_api.g_false
782: ,p_count => x_msg_count
783: ,p_data => x_msg_data);
784:

Line 794: fnd_msg_pub.count_and_get(

790: EXCEPTION
791: WHEN fnd_api.g_exc_error THEN
792: ROLLBACK TO negative_request;
793: x_return_status := fnd_api.g_ret_sts_error;
794: fnd_msg_pub.count_and_get(
795: p_encoded => fnd_api.g_false
796: ,p_count => x_msg_count
797: ,p_data => x_msg_data);
798: WHEN fnd_api.g_exc_unexpected_error THEN

Line 801: fnd_msg_pub.count_and_get(

797: ,p_data => x_msg_data);
798: WHEN fnd_api.g_exc_unexpected_error THEN
799: ROLLBACK TO negative_request;
800: x_return_status := fnd_api.g_ret_sts_unexp_error;
801: fnd_msg_pub.count_and_get(
802: p_encoded => fnd_api.g_false
803: ,p_count => x_msg_count
804: ,p_data => x_msg_data);
805: WHEN OTHERS THEN

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

805: WHEN OTHERS THEN
806: ROLLBACK TO negative_request;
807: x_return_status := fnd_api.g_ret_sts_unexp_error;
808:
809: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
810: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
811: END IF;
812:
813: fnd_msg_pub.count_and_get(

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

806: ROLLBACK TO negative_request;
807: x_return_status := fnd_api.g_ret_sts_unexp_error;
808:
809: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
810: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
811: END IF;
812:
813: fnd_msg_pub.count_and_get(
814: p_encoded => fnd_api.g_false

Line 813: fnd_msg_pub.count_and_get(

809: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
810: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
811: END IF;
812:
813: fnd_msg_pub.count_and_get(
814: p_encoded => fnd_api.g_false
815: ,p_count => x_msg_count
816: ,p_data => x_msg_data);
817: END negative_request;

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

1000:
1001: IF (c_parent_fund_owner%NOTFOUND) THEN
1002: CLOSE c_parent_fund_owner;
1003:
1004: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1005: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1006: fnd_msg_pub.add;
1007: END IF;
1008:

Line 1006: fnd_msg_pub.add;

1002: CLOSE c_parent_fund_owner;
1003:
1004: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1005: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1006: fnd_msg_pub.add;
1007: END IF;
1008:
1009: RAISE fnd_api.g_exc_error;
1010: END IF;

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

1018:
1019: IF (c_parent_fund_owner%NOTFOUND) THEN
1020: CLOSE c_parent_fund_owner;
1021:
1022: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1023: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1024: fnd_msg_pub.add;
1025: END IF;
1026:

Line 1024: fnd_msg_pub.add;

1020: CLOSE c_parent_fund_owner;
1021:
1022: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1023: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1024: fnd_msg_pub.add;
1025: END IF;
1026:
1027: RAISE fnd_api.g_exc_error;
1028: END IF;

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

1047:
1048: IF (c_fm_fund_currency%NOTFOUND) THEN
1049: CLOSE c_fm_fund_currency;
1050:
1051: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1052: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1053: fnd_msg_pub.add;
1054: END IF;
1055:

Line 1053: fnd_msg_pub.add;

1049: CLOSE c_fm_fund_currency;
1050:
1051: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1052: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1053: fnd_msg_pub.add;
1054: END IF;
1055:
1056: RAISE fnd_api.g_exc_error;
1057: END IF;

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

1062:
1063: IF (c_to_fund_currency%NOTFOUND) THEN
1064: CLOSE c_to_fund_currency;
1065:
1066: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1067: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1068: fnd_msg_pub.add;
1069: END IF;
1070:

Line 1068: fnd_msg_pub.add;

1064: CLOSE c_to_fund_currency;
1065:
1066: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1067: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1068: fnd_msg_pub.add;
1069: END IF;
1070:
1071: RAISE fnd_api.g_exc_error;
1072: END IF;

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

1098:
1099: IF (c_act_budget_rec%NOTFOUND) THEN
1100: CLOSE c_act_budget_rec;
1101:
1102: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1103: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1104: fnd_msg_pub.add;
1105: END IF;
1106:

Line 1104: fnd_msg_pub.add;

1100: CLOSE c_act_budget_rec;
1101:
1102: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1103: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1104: fnd_msg_pub.add;
1105: END IF;
1106:
1107: RAISE fnd_api.g_exc_error;
1108: END IF;

Line 1209: fnd_msg_pub.count_and_get(

1205: AND x_return_status = fnd_api.g_ret_sts_success THEN
1206: COMMIT WORK;
1207: END IF;
1208:
1209: fnd_msg_pub.count_and_get(
1210: p_encoded => fnd_api.g_false
1211: ,p_count => x_msg_count
1212: ,p_data => x_msg_data);
1213: EXCEPTION

Line 1217: fnd_msg_pub.count_and_get(

1213: EXCEPTION
1214: WHEN fnd_api.g_exc_error THEN
1215: ROLLBACK TO create_fund_request;
1216: x_return_status := fnd_api.g_ret_sts_error;
1217: fnd_msg_pub.count_and_get(
1218: p_encoded => fnd_api.g_false
1219: ,p_count => x_msg_count
1220: ,p_data => x_msg_data);
1221: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1224: fnd_msg_pub.count_and_get(

1220: ,p_data => x_msg_data);
1221: WHEN fnd_api.g_exc_unexpected_error THEN
1222: ROLLBACK TO create_fund_request;
1223: x_return_status := fnd_api.g_ret_sts_unexp_error;
1224: fnd_msg_pub.count_and_get(
1225: p_encoded => fnd_api.g_false
1226: ,p_count => x_msg_count
1227: ,p_data => x_msg_data);
1228: WHEN OTHERS THEN

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

1228: WHEN OTHERS THEN
1229: ROLLBACK TO create_fund_request;
1230: x_return_status := fnd_api.g_ret_sts_unexp_error;
1231:
1232: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1233: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1234: END IF;
1235:
1236: fnd_msg_pub.count_and_get(

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

1229: ROLLBACK TO create_fund_request;
1230: x_return_status := fnd_api.g_ret_sts_unexp_error;
1231:
1232: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1233: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1234: END IF;
1235:
1236: fnd_msg_pub.count_and_get(
1237: p_encoded => fnd_api.g_false

Line 1236: fnd_msg_pub.count_and_get(

1232: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1233: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1234: END IF;
1235:
1236: fnd_msg_pub.count_and_get(
1237: p_encoded => fnd_api.g_false
1238: ,p_count => x_msg_count
1239: ,p_data => x_msg_data);
1240: END create_fund_request;

Line 2286: fnd_msg_pub.initialize;

2282: AND note_type = 'AMS_JUSTIFICATION'
2283: AND source_object_id = p_act_budget_id;
2284:
2285: BEGIN
2286: fnd_msg_pub.initialize;
2287: l_activity_id :=
2288: wf_engine.getitemattrnumber(
2289: itemtype => itemtype
2290: ,itemkey => itemkey

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

2302:
2303: IF (c_act_budget_rec%NOTFOUND) THEN
2304: CLOSE c_act_budget_rec;
2305:
2306: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2307: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
2308: fnd_msg_pub.add;
2309: END IF;
2310:

Line 2308: fnd_msg_pub.add;

2304: CLOSE c_act_budget_rec;
2305:
2306: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2307: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
2308: fnd_msg_pub.add;
2309: END IF;
2310:
2311: RAISE fnd_api.g_exc_error;
2312: END IF;

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

2324:
2325: IF (c_fund_rec%NOTFOUND) THEN
2326: CLOSE c_fund_rec;
2327:
2328: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2329: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
2330: fnd_msg_pub.add;
2331: END IF;
2332:

Line 2330: fnd_msg_pub.add;

2326: CLOSE c_fund_rec;
2327:
2328: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2329: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
2330: fnd_msg_pub.add;
2331: END IF;
2332:
2333: RAISE fnd_api.g_exc_error;
2334: END IF;

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

2346: l_object_details.currency;
2347: IF (c_transfer_rec%NOTFOUND) THEN
2348: CLOSE c_fund_rec;
2349:
2350: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2351: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
2352: fnd_msg_pub.add;
2353: END IF;
2354:

Line 2352: fnd_msg_pub.add;

2348: CLOSE c_fund_rec;
2349:
2350: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2351: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
2352: fnd_msg_pub.add;
2353: END IF;
2354:
2355: RAISE fnd_api.g_exc_error;
2356: END IF;

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

2364:
2365: IF (c_budget_src_rec%NOTFOUND) THEN
2366: CLOSE c_budget_src_rec;
2367:
2368: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2369: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
2370: fnd_msg_pub.add;
2371: END IF;
2372:

Line 2370: fnd_msg_pub.add;

2366: CLOSE c_budget_src_rec;
2367:
2368: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2369: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
2370: fnd_msg_pub.add;
2371: END IF;
2372:
2373: RAISE fnd_api.g_exc_error;
2374: END IF;

Line 2506: fnd_msg_pub.count_and_get(

2502:
2503:
2504: resultout := 'COMPLETE:SUCCESS';
2505: ELSE
2506: fnd_msg_pub.count_and_get(
2507: p_encoded => fnd_api.g_false
2508: ,p_count => l_msg_count
2509: ,p_data => l_msg_data);
2510: ams_gen_approval_pvt.handle_err(

Line 2559: fnd_msg_pub.count_and_get(

2555: ,funcmode
2556: ,l_error_msg);
2557: RAISE;
2558: WHEN OTHERS THEN
2559: fnd_msg_pub.count_and_get(
2560: p_encoded => fnd_api.g_false
2561: ,p_count => l_msg_count
2562: ,p_data => l_msg_data);
2563: ams_gen_approval_pvt.handle_err(

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

2857: FETCH c_act_budget_rec INTO l_approval_fm_id, l_approval_for_id, l_to_currency, l_from_currency;
2858: IF (c_act_budget_rec%NOTFOUND) THEN
2859: CLOSE c_act_budget_rec;
2860:
2861: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2862: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
2863: fnd_msg_pub.add;
2864: END IF;
2865:

Line 2863: fnd_msg_pub.add;

2859: CLOSE c_act_budget_rec;
2860:
2861: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2862: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
2863: fnd_msg_pub.add;
2864: END IF;
2865:
2866: RAISE fnd_api.g_exc_error;
2867: END IF;

Line 2971: fnd_msg_pub.count_and_get(

2967: resultout := 'COMPLETE:';
2968: RETURN;
2969: END IF;
2970:
2971: fnd_msg_pub.count_and_get(
2972: p_encoded => fnd_api.g_false
2973: ,p_count => l_msg_count
2974: ,p_data => l_msg_data);
2975: IF G_DEBUG THEN

Line 2981: fnd_msg_pub.count_and_get(

2977: END IF;
2978: EXCEPTION
2979: WHEN OTHERS THEN
2980: -- x_return_status := fnd_api.g_ret_sts_error;
2981: fnd_msg_pub.count_and_get(
2982: p_encoded => fnd_api.g_false
2983: ,p_count => l_msg_count
2984: ,p_data => l_msg_data);
2985: ams_gen_approval_pvt.handle_err(

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

3098:
3099: IF (c_fund_detail%NOTFOUND) THEN
3100: CLOSE c_fund_detail;
3101:
3102: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3103: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
3104: fnd_msg_pub.add;
3105: END IF;
3106:

Line 3104: fnd_msg_pub.add;

3100: CLOSE c_fund_detail;
3101:
3102: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3103: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
3104: fnd_msg_pub.add;
3105: END IF;
3106:
3107: RAISE fnd_api.g_exc_error;
3108: END IF;

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

3113: ozf_funds_pvt.init_fund_rec(x_fund_rec => l_fund_rec);
3114:
3115: IF p_transfer_type = 'RESERVE' THEN
3116: IF NVL(l_available_amt, 0) < NVL(p_requested_amount, 0) THEN
3117: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3118: fnd_message.set_name('OZF', 'OZF_AMT_UNAVAILABLE');
3119: fnd_msg_pub.add;
3120: END IF;
3121:

Line 3119: fnd_msg_pub.add;

3115: IF p_transfer_type = 'RESERVE' THEN
3116: IF NVL(l_available_amt, 0) < NVL(p_requested_amount, 0) THEN
3117: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3118: fnd_message.set_name('OZF', 'OZF_AMT_UNAVAILABLE');
3119: fnd_msg_pub.add;
3120: END IF;
3121:
3122: RAISE fnd_api.g_exc_error;
3123: END IF;

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

3124:
3125: l_fund_rec.holdback_amt := NVL(l_holdback_amt, 0) + NVL(p_requested_amount, 0); -- HOLDBACK AMT
3126: ELSIF p_transfer_type = 'RELEASE' THEN
3127: IF NVL(l_holdback_amt, 0) < NVL(p_requested_amount, 0) THEN
3128: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3129: fnd_message.set_name('OZF', 'OZF_AMT_UNAVAILABLE');
3130: fnd_msg_pub.add;
3131: END IF;
3132:

Line 3130: fnd_msg_pub.add;

3126: ELSIF p_transfer_type = 'RELEASE' THEN
3127: IF NVL(l_holdback_amt, 0) < NVL(p_requested_amount, 0) THEN
3128: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3129: fnd_message.set_name('OZF', 'OZF_AMT_UNAVAILABLE');
3130: fnd_msg_pub.add;
3131: END IF;
3132:
3133: RAISE fnd_api.g_exc_error;
3134: END IF;

Line 3167: fnd_msg_pub.count_and_get(

3163: AND l_return_status = fnd_api.g_ret_sts_success THEN
3164: COMMIT WORK;
3165: END IF;
3166:
3167: fnd_msg_pub.count_and_get(
3168: p_encoded => fnd_api.g_false
3169: ,p_count => x_msg_count
3170: ,p_data => x_msg_data);
3171: EXCEPTION

Line 3174: fnd_msg_pub.count_and_get(

3170: ,p_data => x_msg_data);
3171: EXCEPTION
3172: WHEN fnd_api.g_exc_error THEN
3173: x_return_status := fnd_api.g_ret_sts_error;
3174: fnd_msg_pub.count_and_get(
3175: p_encoded => fnd_api.g_false
3176: ,p_count => x_msg_count
3177: ,p_data => x_msg_data);
3178: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3180: fnd_msg_pub.count_and_get(

3176: ,p_count => x_msg_count
3177: ,p_data => x_msg_data);
3178: WHEN fnd_api.g_exc_unexpected_error THEN
3179: x_return_status := fnd_api.g_ret_sts_unexp_error;
3180: fnd_msg_pub.count_and_get(
3181: p_encoded => fnd_api.g_false
3182: ,p_count => x_msg_count
3183: ,p_data => x_msg_data);
3184: WHEN OTHERS THEN

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

3183: ,p_data => x_msg_data);
3184: WHEN OTHERS THEN
3185: x_return_status := fnd_api.g_ret_sts_unexp_error;
3186:
3187: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3188: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3189: END IF;
3190:
3191: fnd_msg_pub.count_and_get(

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

3184: WHEN OTHERS THEN
3185: x_return_status := fnd_api.g_ret_sts_unexp_error;
3186:
3187: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3188: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3189: END IF;
3190:
3191: fnd_msg_pub.count_and_get(
3192: p_encoded => fnd_api.g_false

Line 3191: fnd_msg_pub.count_and_get(

3187: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3188: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3189: END IF;
3190:
3191: fnd_msg_pub.count_and_get(
3192: p_encoded => fnd_api.g_false
3193: ,p_count => x_msg_count
3194: ,p_data => x_msg_data);
3195: END approve_holdback;