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 FEM_PL_PKG

Line 1325: fem_pl_pkg.get_object_def_edit_locks (

1321: -- STEP V2: Check edit locks. Cannot update list if it has ever been run, or
1322: -- if it is edit locked.
1323: -- ============================================================================
1324: -- Check for edit locks. Cannot update list if it is locked.
1325: fem_pl_pkg.get_object_def_edit_locks (
1326: p_object_definition_id => p_undo_list_obj_def_id,
1327: x_approval_edit_lock_exists => v_approval_edit_lock_exists,
1328: x_data_edit_lock_exists => v_data_edit_lock_exists);
1329:

Line 1396: -- Verify that the request is still running using fem_pl_pkg.set_exec_state

1392: WHERE request_id = p_request_id
1393: AND object_id = p_object_id;
1394:
1395: IF v_exec_status_code = 'RUNNING' THEN
1396: -- Verify that the request is still running using fem_pl_pkg.set_exec_state
1397:
1398: fem_pl_pkg.set_exec_state (p_api_version => 1.0,
1399: p_commit => p_commit,
1400: p_request_id => p_request_id,

Line 1398: fem_pl_pkg.set_exec_state (p_api_version => 1.0,

1394:
1395: IF v_exec_status_code = 'RUNNING' THEN
1396: -- Verify that the request is still running using fem_pl_pkg.set_exec_state
1397:
1398: fem_pl_pkg.set_exec_state (p_api_version => 1.0,
1399: p_commit => p_commit,
1400: p_request_id => p_request_id,
1401: p_object_id => p_object_id,
1402: x_msg_count => x_msg_count,

Line 1701: fem_pl_pkg.get_object_def_edit_locks (

1697: -- The list is locked if it has an entry in the FEM_PL tables, OR if
1698: -- it has been processed at least once, and the execution
1699: -- was not successful.
1700: -- ============================================================================
1701: fem_pl_pkg.get_object_def_edit_locks (
1702: p_object_definition_id => p_undo_list_obj_def_id,
1703: x_approval_edit_lock_exists => v_approval_edit_lock_exists,
1704: x_data_edit_lock_exists => v_data_edit_lock_exists);
1705:

Line 2730: -- fem_pl_pkg.set_exec_state

2726: AND object_id = a_dep.dependent_object_id;
2727:
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,

Line 2731: fem_pl_pkg.set_exec_state (p_api_version => 1.0,

2727:
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,

Line 2792: -- Verify that the request is still running using fem_pl_pkg.set_exec_state

2788: WHERE request_id = a_prvw_dep.dependent_request_id
2789: AND object_id = a_prvw_dep.dependent_object_id;
2790:
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,

Line 2794: fem_pl_pkg.set_exec_state (p_api_version => 1.0,

2790:
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,

Line 3094: -- fem_pl_pkg.set_exec_state

3090: AND object_id = a_candidate.object_id;
3091:
3092: IF v_exec_status_code = 'RUNNING' THEN
3093: -- Verify that the request is still running using
3094: -- fem_pl_pkg.set_exec_state
3095: fem_pl_pkg.set_exec_state (p_api_version => 1.0,
3096: p_commit => p_commit,
3097: p_request_id => a_candidate.request_id,
3098: p_object_id => a_candidate.object_id,

Line 3095: fem_pl_pkg.set_exec_state (p_api_version => 1.0,

3091:
3092: IF v_exec_status_code = 'RUNNING' THEN
3093: -- Verify that the request is still running using
3094: -- fem_pl_pkg.set_exec_state
3095: fem_pl_pkg.set_exec_state (p_api_version => 1.0,
3096: p_commit => p_commit,
3097: p_request_id => a_candidate.request_id,
3098: p_object_id => a_candidate.object_id,
3099: x_msg_count => x_msg_count,

Line 3195: --fem_pl_pkg.set_exec_state

3191: AND object_id = a_candidate.object_id;
3192:
3193: IF v_exec_status_code = 'RUNNING' THEN
3194: -- Verify that the request is still running using
3195: --fem_pl_pkg.set_exec_state
3196: fem_pl_pkg.set_exec_state (p_api_version => 1.0,
3197: p_commit => p_commit,
3198: p_request_id => a_candidate.request_id,
3199: p_object_id => a_candidate.object_id,

Line 3196: fem_pl_pkg.set_exec_state (p_api_version => 1.0,

3192:
3193: IF v_exec_status_code = 'RUNNING' THEN
3194: -- Verify that the request is still running using
3195: --fem_pl_pkg.set_exec_state
3196: fem_pl_pkg.set_exec_state (p_api_version => 1.0,
3197: p_commit => p_commit,
3198: p_request_id => a_candidate.request_id,
3199: p_object_id => a_candidate.object_id,
3200: x_msg_count => x_msg_count,

Line 4356: FEM_PL_PKG.Update_Obj_Exec_Status(

4352: last_update_date = sysdate, last_Updated_by = pv_apps_user_id
4353: WHERE undo_list_obj_def_id = p_undo_list_obj_def_id;
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,

Line 4396: FEM_PL_PKG.Update_Request_Status(

4392:
4393: END IF;
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,

Line 4647: FEM_PL_PKG.Register_Request

4643:
4644: -- ============================================================================
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,

Line 4674: FEM_PL_PKG.Register_Object_Execution

4670: END IF;
4671: -- ============================================================================
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,

Line 4702: FEM_PL_PKG.Register_Object_Def

4698: END IF;
4699: -- ============================================================================
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,

Line 5359: -- Verify that the request is still running using fem_pl_pkg.set_exec_state

5355: WHERE request_id = p_request_id
5356: AND object_id = p_object_id;
5357:
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,

Line 5361: fem_pl_pkg.set_exec_state (p_api_version => 1.0,

5357:
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,

Line 5746: fem_pl_pkg.unregister_request (

5742: IF v_count = 0 THEN
5743: -- IF there are no candidates (no object executions) for this request,
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,

Line 6187: -- Verify that the request is still running using fem_pl_pkg.set_exec_state

6183: p_msg_text => 'Candidate Number:'||c1%ROWCOUNT||' REQUEST_ID:'||cand_num.request_id||
6184: ' OBJECT_ID:'||cand_num.object_id||to_char(sysdate,'MM/DD/YYYY HH:MI:SS'));
6185:
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,

Line 6189: fem_pl_pkg.set_exec_state (p_api_version => 1.0,

6185:
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,

Line 6779: FEM_PL_PKG.check_chaining (

6775: C_FEM_BALANCES, p_cal_period_id,
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,

Line 6797: FEM_PL_PKG.Get_Exec_Status (

6793: RAISE e_chain_exists;
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,

Line 7088: FEM_PL_PKG.Get_Exec_Status (

7084: RAISE e_unexp_error;
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,

Line 7103: p_msg_text => 'INTERNAL ERROR: Call to FEM_PL_PKG.Get_Exec_Status'

7099: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7100: FEM_ENGINES_PKG.TECH_MESSAGE(
7101: p_severity => FND_LOG.level_unexpected,
7102: p_module => C_MODULE,
7103: p_msg_text => 'INTERNAL ERROR: Call to FEM_PL_PKG.Get_Exec_Status'
7104: ||' failed with return status: '||x_return_status);
7105: END IF;
7106:
7107: RAISE e_api_error;

Line 7128: p_msg_text => 'INTERNAL ERROR: Call to FEM_PL_PKG.Get_Exec_Status'

7124: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7125: FEM_ENGINES_PKG.TECH_MESSAGE(
7126: p_severity => FND_LOG.level_unexpected,
7127: p_module => C_MODULE,
7128: p_msg_text => 'INTERNAL ERROR: Call to FEM_PL_PKG.Get_Exec_Status'
7129: ||' failed with return status: '||x_return_status);
7130: END IF;
7131:
7132: RAISE e_api_error;

Line 7345: --Call the rountine FEM_PL_PKG.Register_Request to register the request if the request entry is missing

7341: || l_reg_rec.output_dataset_code,
7342: p_user_msg => 'N',
7343: p_module => 'fem.plsql.'||pc_pkg_name||'.'||l_api_name
7344: );
7345: --Call the rountine FEM_PL_PKG.Register_Request to register the request if the request entry is missing
7346: IF (missing_entry.request_request_id IS NULL) THEN
7347: write_debug(
7348: p_msg_data => ' Repair_PL_Request 4',
7349: p_user_msg => 'N',

Line 7378: p_msg_data => ' Repair_PL_Request 5, before calling FEM_PL_PKG.Register_Request ',

7374: END IF;
7375:
7376: IF (l_exe_ok) THEN
7377: write_debug(
7378: p_msg_data => ' Repair_PL_Request 5, before calling FEM_PL_PKG.Register_Request ',
7379: p_user_msg => 'N',
7380: p_module => 'fem.plsql.'||pc_pkg_name||'.'||l_api_name
7381: );
7382:

Line 7383: FEM_PL_PKG.Register_Request (

7379: p_user_msg => 'N',
7380: p_module => 'fem.plsql.'||pc_pkg_name||'.'||l_api_name
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

Line 7427: --write_debug (' Repair_PL_Request 6, fail to call FEM_PL_PKG.Register_Request, l_msg_count:'

7423: p_msg_data => l_msg_data,
7424: p_user_msg => G_YES,
7425: p_module => 'fem.plsql.'||pc_pkg_name||'.'||l_api_name);
7426:
7427: --write_debug (' Repair_PL_Request 6, fail to call FEM_PL_PKG.Register_Request, l_msg_count:'
7428: -- || l_msg_count || ' l_msg_data:' || l_msg_data);
7429: l_exe_ok := FALSE;
7430: end if;
7431: END IF; --(l_exe_ok)

Line 7451: --Call the process lock API FEM_PL_PKG.Register_Object_Execution to register

7447: );
7448:
7449: END IF;
7450:
7451: --Call the process lock API FEM_PL_PKG.Register_Object_Execution to register
7452: --the object executions, also call the process lock API FEM_PL_PKG.Register_Object_Def
7453: --to register object definition if the entry in the fem_pl_object_executions is missing
7454: IF (l_exe_ok AND
7455: missing_entry.execution_request_id IS NULL) THEN

Line 7452: --the object executions, also call the process lock API FEM_PL_PKG.Register_Object_Def

7448:
7449: END IF;
7450:
7451: --Call the process lock API FEM_PL_PKG.Register_Object_Execution to register
7452: --the object executions, also call the process lock API FEM_PL_PKG.Register_Object_Def
7453: --to register object definition if the entry in the fem_pl_object_executions is missing
7454: IF (l_exe_ok AND
7455: missing_entry.execution_request_id IS NULL) THEN
7456: write_debug(

Line 7468: p_msg_data => ' Repair_PL_Request 8, before FEM_PL_PKG.Register_Object_Execution, l_reg_rec.user_id:'

7464: ,x_obj_def_id => l_obj_def_id
7465: );
7466: IF (l_obj_def_id IS NOT NULL) THEN
7467: write_debug(
7468: p_msg_data => ' Repair_PL_Request 8, before FEM_PL_PKG.Register_Object_Execution, l_reg_rec.user_id:'
7469: || l_reg_rec.user_id || ' l_reg_rec.login_id:'
7470: || l_reg_rec.login_id || ' l_obj_def_id:' || l_obj_def_id,
7471: p_user_msg => 'N',
7472: p_module => 'fem.plsql.'||pc_pkg_name||'.'||l_api_name

Line 7475: FEM_PL_PKG.Register_Object_Execution (

7471: p_user_msg => 'N',
7472: p_module => 'fem.plsql.'||pc_pkg_name||'.'||l_api_name
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

Line 7508: --write_debug (' Repair_PL_Request 10, fail to call FEM_PL_PKG.Register_Object_Execution, l_msg_count:'

7504: p_msg_data => l_msg_data,
7505: p_user_msg => G_YES,
7506: p_module => 'fem.plsql.'||pc_pkg_name||'.'||l_api_name);
7507: l_exe_ok := FALSE;
7508: --write_debug (' Repair_PL_Request 10, fail to call FEM_PL_PKG.Register_Object_Execution, l_msg_count:'
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,

Line 7511: FEM_PL_PKG.Update_Obj_Exec_Status(

7507: l_exe_ok := FALSE;
7508: --write_debug (' Repair_PL_Request 10, fail to call FEM_PL_PKG.Register_Object_Execution, l_msg_count:'
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,

Line 7551: FEM_PL_PKG.Register_Object_Def (

7547: p_user_msg => 'N',
7548: p_module => 'fem.plsql.'||pc_pkg_name||'.'||l_api_name
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

Line 7588: --Call the process lock API FEM_PL_PKG.Register_Table to register the FEM_BALANCES

7584: END IF;
7585: END IF;
7586: END IF;--l_exe_ok AND missing_entry.execution_request_id IS NULL
7587:
7588: --Call the process lock API FEM_PL_PKG.Register_Table to register the FEM_BALANCES
7589: --table if the corresponding entry is missing from the fem_pl_tables
7590: IF (l_exe_ok AND missing_entry.tab_request_id IS NULL) THEN
7591: --write_debug (' Repair_PL_Request 13, before Register_Table');
7592: write_debug(

Line 7598: FEM_PL_PKG.Register_Table (

7594: p_user_msg => 'N',
7595: p_module => 'fem.plsql.'||pc_pkg_name||'.'||l_api_name
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