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.FEM_UD_PKG dependencies on FND_API

Line 12: pc_ret_sts_success CONSTANT VARCHAR2(1):= fnd_api.g_ret_sts_success;

8: G_FEM constant varchar2(3) := 'FEM';
9: G_YES CONSTANT VARCHAR2(1) := 'Y';
10: G_NO CONSTANT VARCHAR2(1) := 'N';
11:
12: pc_ret_sts_success CONSTANT VARCHAR2(1):= fnd_api.g_ret_sts_success;
13: pc_ret_sts_error CONSTANT VARCHAR2(1):= fnd_api.g_ret_sts_error;
14: pc_ret_sts_unexp_error CONSTANT VARCHAR2(1):= fnd_api.g_ret_sts_unexp_error;
15:
16: pv_resp_app_id NUMBER := FND_GLOBAL.RESP_APPL_ID;

Line 13: pc_ret_sts_error CONSTANT VARCHAR2(1):= fnd_api.g_ret_sts_error;

9: G_YES CONSTANT VARCHAR2(1) := 'Y';
10: G_NO CONSTANT VARCHAR2(1) := 'N';
11:
12: pc_ret_sts_success CONSTANT VARCHAR2(1):= fnd_api.g_ret_sts_success;
13: pc_ret_sts_error CONSTANT VARCHAR2(1):= fnd_api.g_ret_sts_error;
14: pc_ret_sts_unexp_error CONSTANT VARCHAR2(1):= fnd_api.g_ret_sts_unexp_error;
15:
16: pv_resp_app_id NUMBER := FND_GLOBAL.RESP_APPL_ID;
17: pv_login_id NUMBER := FND_GLOBAL.Login_Id;

Line 14: pc_ret_sts_unexp_error CONSTANT VARCHAR2(1):= fnd_api.g_ret_sts_unexp_error;

10: G_NO CONSTANT VARCHAR2(1) := 'N';
11:
12: pc_ret_sts_success CONSTANT VARCHAR2(1):= fnd_api.g_ret_sts_success;
13: pc_ret_sts_error CONSTANT VARCHAR2(1):= fnd_api.g_ret_sts_error;
14: pc_ret_sts_unexp_error CONSTANT VARCHAR2(1):= fnd_api.g_ret_sts_unexp_error;
15:
16: pv_resp_app_id NUMBER := FND_GLOBAL.RESP_APPL_ID;
17: pv_login_id NUMBER := FND_GLOBAL.Login_Id;
18: pv_apps_user_id NUMBER := FND_GLOBAL.USER_ID;

Line 228: p_encoded => FND_API.G_FALSE,

224: FOR i IN 1..p_msg_count
225: LOOP
226: FND_MSG_PUB.Get(
227: p_msg_index => i,
228: p_encoded => FND_API.G_FALSE,
229: p_data => v_message,
230: p_msg_index_out => v_msg_out);
231:
232: IF p_user_msg = 'Y' THEN

Line 615: IF NOT FND_API.Compatible_API_Call (c_api_version,

611: -- Standard Start of API savepoint
612: SAVEPOINT delete_execution_log_pub;
613:
614: -- Standard call to check for call compatibility.
615: IF NOT FND_API.Compatible_API_Call (c_api_version,
616: p_api_version,
617: c_api_name,
618: pc_pkg_name)
619: THEN

Line 620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

616: p_api_version,
617: c_api_name,
618: pc_pkg_name)
619: THEN
620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
621: END IF;
622:
623: -- Initialize API return status to success
624: x_return_status := pc_ret_sts_success;

Line 658: p_init_msg_list => FND_API.G_FALSE,

654: v_pb_object_id := p_object_id;
655: END IF;
656:
657: FEM_DATABASE_UTIL_PKG.Drop_Temp_DB_Objects (
658: p_init_msg_list => FND_API.G_FALSE,
659: p_commit => FND_API.G_FALSE,
660: p_encoded => FND_API.G_TRUE,
661: x_return_status => x_return_status,
662: x_msg_count => x_msg_count,

Line 659: p_commit => FND_API.G_FALSE,

655: END IF;
656:
657: FEM_DATABASE_UTIL_PKG.Drop_Temp_DB_Objects (
658: p_init_msg_list => FND_API.G_FALSE,
659: p_commit => FND_API.G_FALSE,
660: p_encoded => FND_API.G_TRUE,
661: x_return_status => x_return_status,
662: x_msg_count => x_msg_count,
663: x_msg_data => x_msg_data,

Line 660: p_encoded => FND_API.G_TRUE,

656:
657: FEM_DATABASE_UTIL_PKG.Drop_Temp_DB_Objects (
658: p_init_msg_list => FND_API.G_FALSE,
659: p_commit => FND_API.G_FALSE,
660: p_encoded => FND_API.G_TRUE,
661: x_return_status => x_return_status,
662: x_msg_count => x_msg_count,
663: x_msg_data => x_msg_data,
664: p_request_id => p_request_id,

Line 748: IF FND_API.To_Boolean( p_commit ) THEN

744: AND request_id NOT IN
745: (select request_id FROM fem_pl_object_executions);
746: END IF; -- OGL object type
747:
748: IF FND_API.To_Boolean( p_commit ) THEN
749: COMMIT WORK;
750: END IF;
751:
752: fem_engines_pkg.tech_message(p_severity => pc_log_level_procedure,

Line 761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

757: (p_count => x_msg_count,
758: p_data => x_msg_data);
759:
760: EXCEPTION
761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
762: ROLLBACK TO delete_execution_log_pub;
763: x_return_status := pc_ret_sts_unexp_error;
764:
765: fem_engines_pkg.tech_message(p_severity => pc_log_level_unexpected,

Line 851: IF NOT FND_API.Compatible_API_Call (c_api_version,

847: -- Standard Start of API savepoint
848: SAVEPOINT create_undo_list_pub;
849:
850: -- Standard call to check for call compatibility.
851: IF NOT FND_API.Compatible_API_Call (c_api_version,
852: p_api_version,
853: c_api_name,
854: pc_pkg_name)
855: THEN

Line 856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

852: p_api_version,
853: c_api_name,
854: pc_pkg_name)
855: THEN
856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
857: END IF;
858:
859: -- Initialize API return status to success
860: x_return_status := pc_ret_sts_success;

Line 874: ELSIF p_commit NOT IN (FND_API.G_FALSE, FND_API.G_TRUE) THEN

870: ELSIF p_include_dependencies_flag NOT IN ('Y','N') THEN
871: RAISE e_invalid_dependencies_flag;
872: ELSIF p_ignore_dependency_errs_flag NOT IN ('Y','N') THEN
873: RAISE e_invalid_dependency_errs_flag;
874: ELSIF p_commit NOT IN (FND_API.G_FALSE, FND_API.G_TRUE) THEN
875: RAISE e_invalid_p_commit;
876: END IF;
877:
878: -- ============================================================================

Line 882: p_commit => FND_API.G_FALSE,

878: -- ============================================================================
879: -- Create object and object definition
880: -- ============================================================================
881: fem_object_catalog_util_pkg.create_object(p_api_version => 1.0,
882: p_commit => FND_API.G_FALSE,
883: p_object_type_code => 'UNDO',
884: p_folder_id => pc_undo_folder_id,
885: p_local_vs_combo_id => NULL,
886: p_object_access_code => 'W',

Line 917: IF FND_API.To_Boolean( p_commit ) THEN

913: RAISE e_cannot_create_object;
914: END IF;
915:
916:
917: IF FND_API.To_Boolean( p_commit ) THEN
918: COMMIT WORK;
919: END IF;
920:
921: fem_engines_pkg.tech_message(p_severity => pc_log_level_procedure,

Line 975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

971: FND_MSG_PUB.Count_And_Get
972: (p_count => x_msg_count,
973: p_data => x_msg_data);
974:
975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
976: ROLLBACK TO create_undo_list_pub;
977: x_return_status := pc_ret_sts_unexp_error;
978:
979: fem_engines_pkg.tech_message(p_severity => pc_log_level_unexpected,

Line 1039: IF NOT FND_API.Compatible_API_Call (c_api_version,

1035: -- Standard Start of API savepoint
1036: SAVEPOINT delete_undo_list_pub;
1037:
1038: -- Standard call to check for call compatibility.
1039: IF NOT FND_API.Compatible_API_Call (c_api_version,
1040: p_api_version,
1041: c_api_name,
1042: pc_pkg_name)
1043: THEN

Line 1044: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1040: p_api_version,
1041: c_api_name,
1042: pc_pkg_name)
1043: THEN
1044: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1045: END IF;
1046:
1047: -- Initialize API return status to success
1048: x_return_status := pc_ret_sts_success;

Line 1114: p_commit => FND_API.G_FALSE,

1110: -- object.)
1111: -- ============================================================================
1112:
1113: fem_object_catalog_util_pkg.delete_object(p_api_version => 1.0,
1114: p_commit => FND_API.G_FALSE,
1115: p_object_id => p_undo_list_obj_id,
1116: x_msg_count => x_msg_count,
1117: x_msg_data => x_msg_data,
1118: x_return_status => x_return_status);

Line 1140: IF FND_API.To_Boolean( p_commit ) THEN

1136: RAISE e_cannot_delete_object;
1137: END IF;
1138:
1139:
1140: IF FND_API.To_Boolean( p_commit ) THEN
1141: COMMIT WORK;
1142: END IF;
1143:
1144: fem_engines_pkg.tech_message(p_severity => pc_log_level_procedure,

Line 1189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1185: FND_MSG_PUB.Count_And_Get
1186: (p_count => x_msg_count,
1187: p_data => x_msg_data);
1188:
1189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1190: ROLLBACK TO delete_undo_list_pub;
1191: x_return_status := pc_ret_sts_unexp_error;
1192:
1193: fem_engines_pkg.tech_message(p_severity => pc_log_level_unexpected,

Line 1292: IF NOT FND_API.Compatible_API_Call (c_api_version,

1288: -- Standard Start of API savepoint
1289: SAVEPOINT add_candidate_pub;
1290:
1291: -- Standard call to check for call compatibility.
1292: IF NOT FND_API.Compatible_API_Call (c_api_version,
1293: p_api_version,
1294: c_api_name,
1295: pc_pkg_name)
1296: THEN

Line 1297: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1293: p_api_version,
1294: c_api_name,
1295: pc_pkg_name)
1296: THEN
1297: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1298: END IF;
1299:
1300: -- Initialize API return status to success
1301: x_return_status := pc_ret_sts_success;

Line 1444: p_commit => FND_API.G_FALSE,

1440: x_return_status => x_return_status,
1441: x_msg_count => x_msg_count,
1442: x_msg_data => x_msg_data,
1443: p_api_version => 2.0,
1444: p_commit => FND_API.G_FALSE,
1445: p_undo_list_obj_def_id => p_undo_list_obj_def_id,
1446: p_request_id => p_request_id,
1447: p_object_id => p_object_id,
1448: p_dependency_type => v_dependency_type);

Line 1479: p_commit => FND_API.G_FALSE,

1475: x_return_status => x_return_status,
1476: x_msg_count => x_msg_count,
1477: x_msg_data => x_msg_data,
1478: p_api_version => 2.0,
1479: p_commit => FND_API.G_FALSE,
1480: p_undo_list_obj_def_id => p_undo_list_obj_def_id,
1481: p_request_id => an_integration_load_exec.request_id,
1482: p_object_id => an_integration_load_exec.object_id,
1483: p_dependency_type => v_dependency_type);

Line 1491: IF FND_API.To_Boolean( p_commit ) THEN

1487: END IF;
1488:
1489: END LOOP;
1490:
1491: IF FND_API.To_Boolean( p_commit ) THEN
1492: COMMIT WORK;
1493: END IF;
1494:
1495: fem_engines_pkg.tech_message(p_severity => pc_log_level_procedure,

Line 1582: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1578: FND_MSG_PUB.Count_And_Get
1579: (p_count => x_msg_count,
1580: p_data => x_msg_data);
1581:
1582: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1583: ROLLBACK TO add_candidate_pub;
1584: x_return_status := pc_ret_sts_unexp_error;
1585:
1586: fem_engines_pkg.tech_message(p_severity => pc_log_level_unexpected,

Line 1682: IF NOT FND_API.Compatible_API_Call (c_api_version,

1678: -- Standard Start of API savepoint
1679: SAVEPOINT remove_candidate_pub;
1680:
1681: -- Standard call to check for call compatibility.
1682: IF NOT FND_API.Compatible_API_Call (c_api_version,
1683: p_api_version,
1684: c_api_name,
1685: pc_pkg_name)
1686: THEN

Line 1687: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1683: p_api_version,
1684: c_api_name,
1685: pc_pkg_name)
1686: THEN
1687: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1688: END IF;
1689:
1690: -- Initialize API return status to success
1691: x_return_status := pc_ret_sts_success;

Line 1766: IF FND_API.To_Boolean( p_commit ) THEN

1762: AND object_id = an_integration_load_exec.object_id;
1763:
1764: END LOOP;
1765:
1766: IF FND_API.To_Boolean( p_commit ) THEN
1767: COMMIT WORK;
1768: END IF;
1769:
1770: fem_engines_pkg.tech_message(p_severity => pc_log_level_procedure,

Line 1811: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1807: FND_MSG_PUB.Count_And_Get
1808: (p_count => x_msg_count,
1809: p_data => x_msg_data);
1810:
1811: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1812: ROLLBACK TO remove_candidate_pub;
1813: x_return_status := pc_ret_sts_unexp_error;
1814:
1815: fem_engines_pkg.tech_message(p_severity => pc_log_level_unexpected,

Line 2436: IF NOT FND_API.Compatible_API_Call (c_api_version,

2432: -- Standard Start of API savepoint
2433: SAVEPOINT generate_cand_dependents_pub;
2434:
2435: -- Standard call to check for call compatibility.
2436: IF NOT FND_API.Compatible_API_Call (c_api_version,
2437: p_api_version,
2438: c_api_name,
2439: pc_pkg_name)
2440: THEN

Line 2441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2437: p_api_version,
2438: c_api_name,
2439: pc_pkg_name)
2440: THEN
2441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2442: END IF;
2443:
2444: -- Initialize API return status to success
2445: x_return_status := pc_ret_sts_success;

Line 2732: p_commit => fnd_api.g_true,

2728: IF v_exec_status_code = 'RUNNING' THEN
2729: -- Verify that the request is still running using
2730: -- fem_pl_pkg.set_exec_state
2731: fem_pl_pkg.set_exec_state (p_api_version => 1.0,
2732: p_commit => fnd_api.g_true,
2733: p_request_id => a_dep.dependent_request_id,
2734: p_object_id => a_dep.dependent_object_id,
2735: x_msg_count => x_msg_count,
2736: x_msg_data => x_msg_data,

Line 2795: p_commit => fnd_api.g_true,

2791: IF v_exec_status_code = 'RUNNING' THEN
2792: -- Verify that the request is still running using fem_pl_pkg.set_exec_state
2793:
2794: fem_pl_pkg.set_exec_state (p_api_version => 1.0,
2795: p_commit => fnd_api.g_true,
2796: p_request_id => a_prvw_dep.dependent_request_id,
2797: p_object_id => a_prvw_dep.dependent_object_id,
2798: x_msg_count => x_msg_count,
2799: x_msg_data => x_msg_data,

Line 2839: IF FND_API.To_Boolean( p_commit ) THEN

2835: AND validation_status_code IS NULL;
2836:
2837: END IF;
2838:
2839: IF FND_API.To_Boolean( p_commit ) THEN
2840: COMMIT WORK;
2841: END IF;
2842:
2843: fem_engines_pkg.tech_message(p_severity => pc_log_level_procedure,

Line 2852: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2848: (p_count => x_msg_count,
2849: p_data => x_msg_data);
2850:
2851: EXCEPTION
2852: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2853: ROLLBACK TO generate_cand_dependents_pub;
2854: x_return_status := pc_ret_sts_unexp_error;
2855:
2856: fem_engines_pkg.tech_message(p_severity => pc_log_level_unexpected,

Line 3010: IF NOT FND_API.Compatible_API_Call (c_api_version,

3006: -- Standard Start of API savepoint
3007: SAVEPOINT validate_candidates_pub;
3008:
3009: -- Standard call to check for call compatibility.
3010: IF NOT FND_API.Compatible_API_Call (c_api_version,
3011: p_api_version,
3012: c_api_name,
3013: pc_pkg_name)
3014: THEN

Line 3015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3011: p_api_version,
3012: c_api_name,
3013: pc_pkg_name)
3014: THEN
3015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3016: END IF;
3017:
3018: -- Initialize API return status to success
3019: x_return_status := pc_ret_sts_success;

Line 3300: IF FND_API.To_Boolean( p_commit ) THEN

3296: ELSE
3297: x_return_status := pc_ret_sts_success;
3298: END IF;
3299:
3300: IF FND_API.To_Boolean( p_commit ) THEN
3301: COMMIT WORK;
3302: END IF;
3303:
3304: fem_engines_pkg.tech_message(p_severity => pc_log_level_procedure,

Line 3379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3375: FND_MSG_PUB.Count_And_Get
3376: (p_count => x_msg_count,
3377: p_data => x_msg_data);
3378:
3379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3380: ROLLBACK TO validate_candidates_pub;
3381: x_return_status := pc_ret_sts_unexp_error;
3382:
3383: fem_engines_pkg.tech_message(p_severity => pc_log_level_unexpected,

Line 4059: p_commit => FND_API.G_TRUE,

4055: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4056: p_msg_text => 'STEP 5: Remove object execution log.');
4057:
4058: delete_execution_log (
4059: p_commit => FND_API.G_TRUE,
4060: p_api_version => 1.0,
4061: p_request_id => p_request_id,
4062: p_object_id => p_object_id,
4063: x_return_status => x_return_status,

Line 4358: P_COMMIT => FND_API.G_TRUE,

4354:
4355: -- Update Object Execution Status
4356: FEM_PL_PKG.Update_Obj_Exec_Status(
4357: P_API_VERSION => 1.0,
4358: P_COMMIT => FND_API.G_TRUE,
4359: P_REQUEST_ID => pv_request_id,
4360: P_OBJECT_ID => p_undo_list_obj_id,
4361: P_EXEC_STATUS_CODE => p_execution_status,
4362: P_USER_ID => pv_apps_user_id,

Line 4398: P_COMMIT => FND_API.G_TRUE,

4394:
4395: -- Update Request Status
4396: FEM_PL_PKG.Update_Request_Status(
4397: P_API_VERSION => 1.0,
4398: P_COMMIT => FND_API.G_TRUE,
4399: P_REQUEST_ID => pv_request_id,
4400: P_EXEC_STATUS_CODE => p_execution_status,
4401: P_USER_ID => pv_apps_user_id,
4402: P_LAST_UPDATE_LOGIN => null,

Line 4649: P_COMMIT => FND_API.G_FALSE,

4645: -- R01: Register request
4646: -- ============================================================================
4647: FEM_PL_PKG.Register_Request
4648: (P_API_VERSION => 1.0,
4649: P_COMMIT => FND_API.G_FALSE,
4650: P_REQUEST_ID => pv_request_id,
4651: P_USER_ID => pv_apps_user_id,
4652: P_LAST_UPDATE_LOGIN => pv_login_id,
4653: P_PROGRAM_ID => pv_program_id,

Line 4676: P_COMMIT => FND_API.G_FALSE,

4672: -- R02: Register object execution
4673: -- ============================================================================
4674: FEM_PL_PKG.Register_Object_Execution
4675: (P_API_VERSION => 1.0,
4676: P_COMMIT => FND_API.G_FALSE,
4677: P_REQUEST_ID => pv_request_id,
4678: P_OBJECT_ID => p_undo_list_obj_id,
4679: P_EXEC_OBJECT_DEFINITION_ID => v_undo_list_obj_def_id,
4680: P_USER_ID => pv_apps_user_id,

Line 4704: P_COMMIT => FND_API.G_FALSE,

4700: -- R02: Register undo list in FEM_PL_OBJECT_DEFS
4701: -- ============================================================================
4702: FEM_PL_PKG.Register_Object_Def
4703: (P_API_VERSION => 1.0,
4704: P_COMMIT => FND_API.G_FALSE,
4705: P_REQUEST_ID => pv_request_id,
4706: P_OBJECT_ID => p_undo_list_obj_id,
4707: P_OBJECT_DEFINITION_ID => v_undo_list_obj_def_id,
4708: P_USER_ID => pv_apps_user_id,

Line 4762: p_commit => FND_API.G_TRUE,

4758: x_return_status => v_return_status,
4759: x_msg_count => v_msg_count,
4760: x_msg_data => v_msg_data,
4761: p_api_version => 2.0,
4762: p_commit => FND_API.G_TRUE,
4763: p_undo_list_obj_def_id => v_undo_list_obj_def_id,
4764: p_dependency_type => v_dependency_type);
4765: */
4766:

Line 4773: p_commit => FND_API.G_TRUE,

4769: x_return_status => v_return_status,
4770: x_msg_count => v_msg_count,
4771: x_msg_data => v_msg_data,
4772: p_api_version => 2.0,
4773: p_commit => FND_API.G_TRUE,
4774: p_undo_list_obj_def_id => v_undo_list_obj_def_id,
4775: p_dependency_type => v_dependency_type);
4776:
4777: IF v_return_status <> pc_ret_sts_success THEN

Line 4887: p_commit => FND_API.G_TRUE,

4883:
4884: FOR undo_objexec IN c3 LOOP
4885:
4886: delete_execution_log (
4887: p_commit => FND_API.G_TRUE,
4888: p_api_version => 1.0,
4889: p_request_id => undo_objexec.request_id,
4890: p_object_id => p_undo_list_obj_id,
4891: x_return_status => v_return_status,

Line 4919: p_commit => FND_API.G_TRUE,

4915: COMMIT;
4916:
4917: delete_undo_list(
4918: p_api_version => 1.0,
4919: p_commit => FND_API.G_TRUE,
4920: p_undo_list_obj_id => p_undo_list_obj_id,
4921: x_return_status => v_return_status,
4922: x_msg_count => v_msg_count,
4923: x_msg_data => v_msg_data);

Line 5362: p_commit => fnd_api.g_true,

5358: IF v_exec_status_code = 'RUNNING' THEN
5359: -- Verify that the request is still running using fem_pl_pkg.set_exec_state
5360:
5361: fem_pl_pkg.set_exec_state (p_api_version => 1.0,
5362: p_commit => fnd_api.g_true,
5363: p_request_id => p_request_id,
5364: p_object_id => p_object_id,
5365: x_msg_count => v_msg_count,
5366: x_msg_data => v_msg_data,

Line 5410: p_commit => FND_API.G_TRUE,

5406: -- ============================================================================
5407: -- C1: Create undo list if it does not exist
5408: -- ============================================================================
5409: create_undo_list (p_api_version => 1.0,
5410: p_commit => FND_API.G_TRUE,
5411: p_undo_list_name => 'UNDO - REQUEST_ID: '||p_request_id||' OBJECT_ID: '||p_object_id,
5412: p_folder_id => pc_undo_folder_id,
5413: p_include_dependencies_flag => NVL(p_include_dependencies_flag,'Y'),
5414: p_ignore_dependency_errs_flag => NVL(p_ignore_dependency_errs_flag,'N'),

Line 5443: p_commit => FND_API.G_TRUE,

5439: -- ============================================================================
5440: -- C2: Add object execution to undo list as candidate
5441: -- ============================================================================
5442: add_candidate (p_api_version => 1.0,
5443: p_commit => FND_API.G_TRUE,
5444: p_undo_list_obj_def_id => v_undo_list_obj_def_id,
5445: p_request_id => p_request_id,
5446: p_object_id => p_object_id,
5447: x_return_status => v_return_status,

Line 5748: p_commit => FND_API.G_TRUE,

5744: -- then unregister the request.
5745:
5746: fem_pl_pkg.unregister_request (
5747: p_api_version => 1.0,
5748: p_commit => FND_API.G_TRUE,
5749: p_request_id => p_request_id,
5750: x_msg_count => v_msg_count,
5751: x_msg_data => v_msg_data,
5752: x_return_status => v_return_status);

Line 5840: p_commit => FND_API.G_TRUE,

5836: -- ============================================================================
5837: -- C1: Create undo list
5838: -- ============================================================================
5839: create_undo_list (p_api_version => 1.0,
5840: p_commit => FND_API.G_TRUE,
5841: p_undo_list_name => 'UNDO - REQUEST_ID: '||p_request_id,
5842: p_folder_id => pc_undo_folder_id,
5843: p_include_dependencies_flag => NVL(p_include_dependencies_flag,'Y'),
5844: p_ignore_dependency_errs_flag => NVL(p_ignore_dependency_errs_flag,'N'),

Line 5877: p_commit => FND_API.G_TRUE,

5873:
5874: FOR acandidate IN c1 LOOP
5875: v_count := c1%ROWCOUNT;
5876: add_candidate (p_api_version => 1.0,
5877: p_commit => FND_API.G_TRUE,
5878: p_undo_list_obj_def_id => v_undo_list_obj_def_id,
5879: p_request_id => p_request_id,
5880: p_object_id => acandidate.object_id,
5881: x_return_status => v_return_status,

Line 6190: p_commit => fnd_api.g_true,

6186: IF cand_num.exec_status_code = 'RUNNING' THEN
6187: -- Verify that the request is still running using fem_pl_pkg.set_exec_state
6188:
6189: fem_pl_pkg.set_exec_state (p_api_version => 1.0,
6190: p_commit => fnd_api.g_true,
6191: p_request_id => cand_num.request_id,
6192: p_object_id => cand_num.object_id,
6193: x_msg_count => x_msg_count,
6194: x_msg_data => x_msg_data,

Line 6240: p_commit => FND_API.G_FALSE,

6236: -- ============================================================================
6237: -- C1: Create undo list if it does not exist
6238: -- ============================================================================
6239: create_undo_list (p_api_version => 1.0,
6240: p_commit => FND_API.G_FALSE,
6241: p_undo_list_name => p_undo_list_name,
6242: p_folder_id => pc_undo_folder_id,
6243: p_include_dependencies_flag => ('Y'),
6244: p_ignore_dependency_errs_flag => ('N'),

Line 6273: p_commit => FND_API.G_FALSE,

6269: -- C2: Add object executions to undo list as candidates
6270: -- ============================================================================
6271: FOR cand_num IN c1 LOOP
6272: add_candidate (p_api_version => 1.0,
6273: p_commit => FND_API.G_FALSE,
6274: p_undo_list_obj_def_id => v_undo_list_obj_def_id,
6275: p_request_id => cand_num.request_id,
6276: p_object_id => cand_num.object_id,
6277: x_return_status => x_return_status,

Line 6421: p_commit => FND_API.G_TRUE,

6417: x_return_status => x_return_status,
6418: x_msg_count => x_msg_count,
6419: x_msg_data => x_msg_data,
6420: p_api_version => 1.0,
6421: p_commit => FND_API.G_TRUE,
6422: p_undo_list_obj_id => v_undo_list_obj_id);
6423:
6424: IF x_msg_count > 0 THEN
6425: Get_Put_Messages(

Line 6495: IF NOT FND_API.Compatible_API_Call (c_api_version,

6491: -- Standard Start of API savepoint
6492: SAVEPOINT insert_preview_candidates_pub;
6493:
6494: -- Standard call to check for call compatibility.
6495: IF NOT FND_API.Compatible_API_Call (c_api_version,
6496: p_api_version,
6497: c_api_name,
6498: pc_pkg_name)
6499: THEN

Line 6500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6496: p_api_version,
6497: c_api_name,
6498: pc_pkg_name)
6499: THEN
6500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6501: END IF;
6502:
6503: -- ============================================================================
6504: -- STEP V2: Validate p_ud_session_id

Line 6533: IF FND_API.To_Boolean( p_commit ) THEN

6529: ELSE
6530: x_return_status := pc_ret_sts_success;
6531: END IF;
6532:
6533: IF FND_API.To_Boolean( p_commit ) THEN
6534: COMMIT WORK;
6535: END IF;
6536:
6537: fem_engines_pkg.tech_message(p_severity => pc_log_level_procedure,

Line 6568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6564: FND_MSG_PUB.Count_And_Get
6565: (p_count => x_msg_count,
6566: p_data => x_msg_data);
6567:
6568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6569: ROLLBACK TO insert_preview_candidates_pub;
6570: x_return_status := pc_ret_sts_unexp_error;
6571:
6572: fem_engines_pkg.tech_message(p_severity => pc_log_level_unexpected,

Line 6611: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

6607: -- ****************************************************************************
6608:
6609: PROCEDURE Delete_Balances (
6610: p_api_version IN NUMBER DEFAULT 1.0,
6611: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
6612: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
6613: p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE,
6614: x_return_status OUT NOCOPY VARCHAR2,
6615: x_msg_count OUT NOCOPY NUMBER,

Line 6612: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

6608:
6609: PROCEDURE Delete_Balances (
6610: p_api_version IN NUMBER DEFAULT 1.0,
6611: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
6612: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
6613: p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE,
6614: x_return_status OUT NOCOPY VARCHAR2,
6615: x_msg_count OUT NOCOPY NUMBER,
6616: x_msg_data OUT NOCOPY VARCHAR2,

Line 6613: p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE,

6609: PROCEDURE Delete_Balances (
6610: p_api_version IN NUMBER DEFAULT 1.0,
6611: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
6612: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
6613: p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE,
6614: x_return_status OUT NOCOPY VARCHAR2,
6615: x_msg_count OUT NOCOPY NUMBER,
6616: x_msg_data OUT NOCOPY VARCHAR2,
6617: p_current_request_id IN NUMBER,

Line 6704: IF NOT FND_API.Compatible_API_Call (C_API_VERSION,

6700: -- Initialize return status to unexpected error
6701: x_return_status := pc_ret_sts_unexp_error;
6702:
6703: -- Check for call compatibility.
6704: IF NOT FND_API.Compatible_API_Call (C_API_VERSION,
6705: p_api_version,
6706: C_API_NAME,
6707: pc_pkg_name)
6708: THEN

Line 6763: IF p_init_msg_list = FND_API.G_TRUE then

6759: p_msg_text => 'p_dataset_code = '||to_char(p_dataset_code));
6760: END IF;
6761:
6762: -- Initialize FND message queue
6763: IF p_init_msg_list = FND_API.G_TRUE then
6764: FND_MSG_PUB.Initialize;
6765: END IF;
6766:
6767: -- For now, only restrict to FEM_BALANCES since that is the

Line 6780: p_commit => FND_API.G_FALSE,

6776: p_ledger_id, p_dataset_code) LOOP
6777:
6778: -- Check to make sure object execution is not chained.
6779: FEM_PL_PKG.check_chaining (
6780: p_commit => FND_API.G_FALSE,
6781: p_encoded => p_encoded,
6782: x_return_status => v_return_status,
6783: x_msg_count => x_msg_count,
6784: x_msg_data => x_msg_data,

Line 6791: IF v_chain_exists = FND_API.G_TRUE THEN

6787: x_dep_request_id => v_dep_req_id,
6788: x_dep_object_id => v_dep_obj_id,
6789: x_chain_exists => v_chain_exists);
6790:
6791: IF v_chain_exists = FND_API.G_TRUE THEN
6792: v_request_id := obj_execs.request_id;
6793: RAISE e_chain_exists;
6794: END IF;
6795:

Line 6798: p_commit => FND_API.G_FALSE,

6794: END IF;
6795:
6796: -- Check to make sure object execution is not RUNNING.
6797: FEM_PL_PKG.Get_Exec_Status (
6798: p_commit => FND_API.G_FALSE,
6799: p_encoded => p_encoded,
6800: x_return_status => v_return_status,
6801: x_msg_count => x_msg_count,
6802: x_msg_data => x_msg_data,

Line 6855: p_commit => FND_API.G_FALSE,

6851: delete_execution_log (x_return_status => x_return_status,
6852: x_msg_count => x_msg_count,
6853: x_msg_data => x_msg_data,
6854: p_api_version => 1.0,
6855: p_commit => FND_API.G_FALSE,
6856: p_request_id => obj_execs.request_id,
6857: p_object_id => obj_execs.object_id);
6858: IF x_return_status <> pc_ret_sts_success THEN
6859: RAISE e_api_error;

Line 6866: IF (p_commit = FND_API.G_TRUE) THEN

6862: END LOOP;
6863:
6864: x_return_status := pc_ret_sts_success;
6865:
6866: IF (p_commit = FND_API.G_TRUE) THEN
6867: COMMIT;
6868: END IF;
6869:
6870: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 6947: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

6943: -- ****************************************************************************
6944:
6945: PROCEDURE Remove_Process_Locks (
6946: p_api_version IN NUMBER,
6947: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
6948: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
6949: p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE,
6950: x_return_status OUT NOCOPY VARCHAR2,
6951: x_msg_count OUT NOCOPY NUMBER,

Line 6948: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

6944:
6945: PROCEDURE Remove_Process_Locks (
6946: p_api_version IN NUMBER,
6947: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
6948: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
6949: p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE,
6950: x_return_status OUT NOCOPY VARCHAR2,
6951: x_msg_count OUT NOCOPY NUMBER,
6952: x_msg_data OUT NOCOPY VARCHAR2,

Line 6949: p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE,

6945: PROCEDURE Remove_Process_Locks (
6946: p_api_version IN NUMBER,
6947: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
6948: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
6949: p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE,
6950: x_return_status OUT NOCOPY VARCHAR2,
6951: x_msg_count OUT NOCOPY NUMBER,
6952: x_msg_data OUT NOCOPY VARCHAR2,
6953: p_request_id IN NUMBER,

Line 7011: IF NOT FND_API.Compatible_API_Call (C_API_VERSION,

7007: -- Initialize return status to unexpected error
7008: x_return_status := pc_ret_sts_unexp_error;
7009:
7010: -- Check for call compatibility.
7011: IF NOT FND_API.Compatible_API_Call (C_API_VERSION,
7012: p_api_version,
7013: C_API_NAME,
7014: pc_pkg_name)
7015: THEN

Line 7028: IF p_init_msg_list = FND_API.G_TRUE then

7024: RAISE e_unexp_error;
7025: END IF;
7026:
7027: -- Initialize FND message queue
7028: IF p_init_msg_list = FND_API.G_TRUE then
7029: FND_MSG_PUB.Initialize;
7030: END IF;
7031:
7032: -- Log procedure param values

Line 7089: p_commit => FND_API.G_FALSE,

7085: END IF;
7086:
7087: -- Check to make sure object execution is not RUNNING.
7088: FEM_PL_PKG.Get_Exec_Status (
7089: p_commit => FND_API.G_FALSE,
7090: p_encoded => p_encoded,
7091: x_return_status => x_return_status,
7092: x_msg_count => x_msg_count,
7093: x_msg_data => x_msg_data,

Line 7119: p_commit => FND_API.G_FALSE,

7115: delete_execution_log (x_return_status => x_return_status,
7116: x_msg_count => x_msg_count,
7117: x_msg_data => x_msg_data,
7118: p_api_version => 1.0,
7119: p_commit => FND_API.G_FALSE,
7120: p_request_id => p_request_id,
7121: p_object_id => p_object_id);
7122:
7123: IF x_return_status <> pc_ret_sts_success THEN

Line 7137: IF (p_commit = FND_API.G_TRUE) THEN

7133: END IF;
7134:
7135: x_return_status := pc_ret_sts_success;
7136:
7137: IF (p_commit = FND_API.G_TRUE) THEN
7138: COMMIT;
7139: END IF;
7140:
7141: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 7385: ,p_commit => FND_API.G_FALSE

7381: );
7382:
7383: FEM_PL_PKG.Register_Request (
7384: p_api_version => 1.0
7385: ,p_commit => FND_API.G_FALSE
7386: ,p_cal_period_id => l_reg_rec.cal_period_id
7387: ,p_ledger_id => l_reg_rec.ledger_id
7388: ,p_dataset_io_obj_def_id => l_reg_rec.dataset_io_obj_def_id
7389: ,p_output_dataset_code => l_reg_rec.output_dataset_code

Line 7477: ,p_commit => FND_API.G_FALSE

7473: );
7474:
7475: FEM_PL_PKG.Register_Object_Execution (
7476: p_api_version => 1.0
7477: ,p_commit => FND_API.G_FALSE
7478: ,p_request_id => l_reg_rec.request_id
7479: ,p_object_id => l_reg_rec.object_id
7480: ,p_exec_object_definition_id => l_obj_def_id
7481: ,p_user_id => l_reg_rec.user_id

Line 7513: P_COMMIT => FND_API.G_FALSE,

7509: -- || l_msg_count || ' l_msg_data:' || l_msg_data);
7510: ELSE
7511: FEM_PL_PKG.Update_Obj_Exec_Status(
7512: P_API_VERSION => 1.0,
7513: P_COMMIT => FND_API.G_FALSE,
7514: P_REQUEST_ID => l_reg_rec.request_id,
7515: P_OBJECT_ID => l_reg_rec.object_id,
7516: P_EXEC_STATUS_CODE => 'SUCCESS',
7517: P_USER_ID => l_reg_rec.user_id,

Line 7553: ,p_commit => FND_API.G_FALSE

7549: );
7550:
7551: FEM_PL_PKG.Register_Object_Def (
7552: p_api_version => 1.0
7553: ,p_commit => FND_API.G_FALSE
7554: ,p_request_id => l_reg_rec.request_id
7555: ,p_object_id => l_reg_rec.object_id
7556: ,p_object_definition_id => l_obj_def_id
7557: ,p_user_id => l_reg_rec.user_id

Line 7600: ,p_commit => FND_API.G_FALSE

7596: );
7597:
7598: FEM_PL_PKG.Register_Table (
7599: p_api_version => 1.0
7600: ,p_commit => FND_API.G_FALSE
7601: ,p_request_id => l_reg_rec.request_id
7602: ,p_object_id => l_reg_rec.object_id
7603: ,p_table_name => 'FEM_BALANCES'
7604: ,p_statement_type => 'INSERT'