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_PL_PKG dependencies on STANDARD

Line 29: PROCEDURE Perform_Standard_API_Steps (

25: -- ***************************************************************************
26: -- Private procedure signatures:
27: -- ***************************************************************************
28:
29: PROCEDURE Perform_Standard_API_Steps (
30: p_current_api_version IN NUMBER,
31: p_caller_api_version IN NUMBER,
32: p_api_name IN VARCHAR2,
33: p_pkg_name IN VARCHAR2,

Line 57: PROCEDURE Perform_Standard_API_Steps (

53: -- ***************************************************************************
54: -- Private procedure bodies:
55: -- ***************************************************************************
56:
57: PROCEDURE Perform_Standard_API_Steps (
58: p_current_api_version IN NUMBER,
59: p_caller_api_version IN NUMBER,
60: p_api_name IN VARCHAR2,
61: p_pkg_name IN VARCHAR2,

Line 65: 'fem.plsql.'||g_pkg_name||'.perform_standard_api_steps';

61: p_pkg_name IN VARCHAR2,
62: p_init_msg_list IN VARCHAR2) IS
63: --
64: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
65: 'fem.plsql.'||g_pkg_name||'.perform_standard_api_steps';
66: --
67: BEGIN
68: -- ==========================================================================
69: -- Performs the common steps that all standard API's need to perform:

Line 69: -- Performs the common steps that all standard API's need to perform:

65: 'fem.plsql.'||g_pkg_name||'.perform_standard_api_steps';
66: --
67: BEGIN
68: -- ==========================================================================
69: -- Performs the common steps that all standard API's need to perform:
70: -- 1. Check API version compatibility.
71: -- 2. Initialize FND_MSG_PUB message queue if necessary.
72: -- ==========================================================================
73:

Line 95: END Perform_Standard_API_Steps;

91: IF p_init_msg_list = FND_API.G_TRUE then
92: FND_MSG_PUB.Initialize;
93: END IF;
94:
95: END Perform_Standard_API_Steps;
96:
97: -- ***************************************************************************
98:
99: PROCEDURE Get_Translated_Name (

Line 248: Perform_Standard_API_Steps(

244: ||' P_NEW_EFFECTIVE_END_DATE:'
245: ||fnd_date.date_to_displaydate(p_new_effective_end_date));
246: END IF;
247:
248: Perform_Standard_API_Steps(
249: p_current_api_version => C_API_VERSION,
250: p_caller_api_version => p_api_version,
251: p_api_name => C_API_NAME,
252: p_pkg_name => G_PKG_NAME,

Line 339: -- effective_date_incl_rslt_data that follows the FND API standards.

335: x_msg_data OUT NOCOPY VARCHAR2,
336: x_date_incl_rslt_data OUT NOCOPY VARCHAR2) IS
337: -- ==========================================================================
338: -- API signature kept for backward compatibility. It simply calls the
339: -- effective_date_incl_rslt_data that follows the FND API standards.
340: -- ==========================================================================
341: v_return_status VARCHAR2(1);
342: BEGIN
343: effective_date_incl_rslt_data (

Line 483: Perform_Standard_API_Steps(

479: p_msg_text => 'Begin. P_OBJECT_DEFINITION_ID:'||
480: p_object_definition_id||' P_PROCESS_TYPE:'||p_process_type);
481: END IF;
482:
483: Perform_Standard_API_Steps(
484: p_current_api_version => C_API_VERSION,
485: p_caller_api_version => p_api_version,
486: p_api_name => C_API_NAME,
487: p_pkg_name => G_PKG_NAME,

Line 683: -- can_delete_object_def that follows the FND API standards.

679: p_process_type IN NUMBER DEFAULT NULL,
680: p_calling_program IN VARCHAR2 DEFAULT NULL) IS
681: -- ==========================================================================
682: -- API signature kept for backward compatibility. It simply calls the
683: -- can_delete_object_def that follows the FND API standards.
684: -- ==========================================================================
685: v_return_status VARCHAR2(1);
686: BEGIN
687: can_delete_object_def (

Line 765: Perform_Standard_API_Steps(

761: p_msg_text => 'Begin. P_OBJECT_ID:'||
762: p_object_id||' P_PROCESS_TYPE:'||p_process_type);
763: END IF;
764:
765: Perform_Standard_API_Steps(
766: p_current_api_version => C_API_VERSION,
767: p_caller_api_version => p_api_version,
768: p_api_name => C_API_NAME,
769: p_pkg_name => G_PKG_NAME,

Line 941: -- can_delete_object that follows the FND API standards.

937: x_msg_count OUT NOCOPY NUMBER,
938: x_msg_data OUT NOCOPY VARCHAR2) IS
939: -- ==========================================================================
940: -- API signature kept for backward compatibility. It simply calls the
941: -- can_delete_object that follows the FND API standards.
942: -- ==========================================================================
943: v_return_status VARCHAR2(1);
944: BEGIN
945: can_delete_object (

Line 1203: -- Standard call to get message count and if count is 1, get message info.

1199: p_module => 'fem.plsql.'||g_pkg_name||'.obj_execution_lock_exists',
1200: p_msg_text => 'End. Object execution lock exists:'||x_exec_lock_exists||
1201: '; Execution state:'||x_exec_state||' X_PREV_REQUEST_ID:'||x_prev_request_id);
1202:
1203: -- Standard call to get message count and if count is 1, get message info.
1204: FND_MSG_PUB.Count_And_Get
1205: (p_count => x_msg_count,
1206: p_data => x_msg_data);
1207:

Line 1290: -- Standard Start of API savepoint

1286: p_msg_text => 'Begin. P_USER_ID:'||p_user_id||
1287: ' P_REQUEST_ID:'||p_request_id||' P_OBJECT_ID:'||p_object_id||
1288: ' P_EXEC_OBJECT_DEFINITION_ID:'||p_exec_object_definition_id);
1289:
1290: -- Standard Start of API savepoint
1291: SAVEPOINT register_object_execution_pub;
1292:
1293: -- Standard call to check for call compatibility.
1294: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 1293: -- Standard call to check for call compatibility.

1289:
1290: -- Standard Start of API savepoint
1291: SAVEPOINT register_object_execution_pub;
1292:
1293: -- Standard call to check for call compatibility.
1294: IF NOT FND_API.Compatible_API_Call (l_api_version,
1295: p_api_version,
1296: l_api_name,
1297: g_pkg_name)

Line 1462: -- Standard call to get message count and if count is 1, get message info.

1458: END IF;
1459:
1460: END IF;
1461:
1462: -- Standard call to get message count and if count is 1, get message info.
1463: FND_MSG_PUB.Count_And_Get
1464: (p_count => x_msg_count,
1465: p_data => x_msg_data);
1466:

Line 1585: -- Standard Start of API savepoint

1581: ' P_OUTPUT_DATASET_CODE:'||p_output_dataset_code||
1582: ' P_DIMENSION_ID:'||p_dimension_id||' P_TABLE_NAME:'||p_table_name||
1583: ' P_HIERARCHY_NAME:'||p_hierarchy_name||' P_EXEC_MODE_CODE:'||p_exec_mode_code);
1584:
1585: -- Standard Start of API savepoint
1586: SAVEPOINT register_request_pub;
1587:
1588: -- Standard call to check for call compatibility.
1589: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 1588: -- Standard call to check for call compatibility.

1584:
1585: -- Standard Start of API savepoint
1586: SAVEPOINT register_request_pub;
1587:
1588: -- Standard call to check for call compatibility.
1589: IF NOT FND_API.Compatible_API_Call (l_api_version,
1590: p_api_version,
1591: l_api_name,
1592: g_pkg_name)

Line 1623: -- Standard call to get message count and if count is 1, get message info.

1619: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
1620: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1621: p_msg_text => 'End. Registered request. X_RETURN_STATUS:'||x_return_status);
1622:
1623: -- Standard call to get message count and if count is 1, get message info.
1624: FND_MSG_PUB.Count_And_Get
1625: (p_count => x_msg_count,
1626: p_data => x_msg_data);
1627:

Line 1685: -- Standard Start of API savepoint

1681: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1682: p_msg_text => 'Begin. REQUEST_ID: '||p_request_id||
1683: ' P_COMMIT:'||p_commit);
1684:
1685: -- Standard Start of API savepoint
1686: SAVEPOINT unregister_request_pub;
1687:
1688: -- Standard call to check for call compatibility.
1689: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 1688: -- Standard call to check for call compatibility.

1684:
1685: -- Standard Start of API savepoint
1686: SAVEPOINT unregister_request_pub;
1687:
1688: -- Standard call to check for call compatibility.
1689: IF NOT FND_API.Compatible_API_Call (l_api_version,
1690: p_api_version,
1691: l_api_name,
1692: g_pkg_name)

Line 1756: -- Standard Start of API savepoint

1752: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1753: p_msg_text => 'Begin. REQUEST_ID: '||p_request_id||
1754: ' P_COMMIT:'||p_commit||' P_EXEC_STATUS_CODE:'||p_exec_status_code);
1755:
1756: -- Standard Start of API savepoint
1757: SAVEPOINT update_request_status_pub;
1758:
1759: -- Standard call to check for call compatibility.
1760: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 1759: -- Standard call to check for call compatibility.

1755:
1756: -- Standard Start of API savepoint
1757: SAVEPOINT update_request_status_pub;
1758:
1759: -- Standard call to check for call compatibility.
1760: IF NOT FND_API.Compatible_API_Call (l_api_version,
1761: p_api_version,
1762: l_api_name,
1763: g_pkg_name)

Line 1818: -- Standard Start of API savepoint

1814: p_msg_text => 'Begin. REQUEST_ID: '||p_request_id||
1815: ' P_OBJECT_ID:'||p_object_id||' P_COMMIT:'||p_commit||
1816: ' P_EXEC_STATUS_CODE:'||p_exec_status_code);
1817:
1818: -- Standard Start of API savepoint
1819: SAVEPOINT update_obj_exec_status_pub;
1820:
1821: -- Standard call to check for call compatibility.
1822: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 1821: -- Standard call to check for call compatibility.

1817:
1818: -- Standard Start of API savepoint
1819: SAVEPOINT update_obj_exec_status_pub;
1820:
1821: -- Standard call to check for call compatibility.
1822: IF NOT FND_API.Compatible_API_Call (l_api_version,
1823: p_api_version,
1824: l_api_name,
1825: g_pkg_name)

Line 1883: -- Standard Start of API savepoint

1879: ' P_OBJECT_ID:'||p_object_id||' P_COMMIT:'||p_commit||
1880: ' P_ERRORS_REPORTED:'||p_errors_reported||
1881: ' P_ERRORS_REPROCESSED:'||p_errors_reprocessed);
1882:
1883: -- Standard Start of API savepoint
1884: SAVEPOINT update_obj_exec_errors_pub;
1885:
1886: -- Standard call to check for call compatibility.
1887: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 1886: -- Standard call to check for call compatibility.

1882:
1883: -- Standard Start of API savepoint
1884: SAVEPOINT update_obj_exec_errors_pub;
1885:
1886: -- Standard call to check for call compatibility.
1887: IF NOT FND_API.Compatible_API_Call (l_api_version,
1888: p_api_version,
1889: l_api_name,
1890: g_pkg_name)

Line 1948: -- Standard Start of API savepoint

1944: p_msg_text => 'Begin. REQUEST_ID: '||p_request_id||
1945: ' P_OBJECT_ID:'||p_object_id||' P_COMMIT:'||p_commit||
1946: ' P_OBJECT_DEFINITION_ID:'||p_object_definition_id);
1947:
1948: -- Standard Start of API savepoint
1949: SAVEPOINT register_object_def_pub;
1950:
1951: -- Standard call to check for call compatibility.
1952: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 1951: -- Standard call to check for call compatibility.

1947:
1948: -- Standard Start of API savepoint
1949: SAVEPOINT register_object_def_pub;
1950:
1951: -- Standard call to check for call compatibility.
1952: IF NOT FND_API.Compatible_API_Call (l_api_version,
1953: p_api_version,
1954: l_api_name,
1955: g_pkg_name)

Line 2049: -- Standard Start of API savepoint

2045: ' P_OBJECT_ID:'||p_object_id||
2046: ' P_EFFECTIVE_DATE:'||fnd_date.date_to_displaydate(p_effective_date)||
2047: ' P_COMMIT:'||p_commit);
2048:
2049: -- Standard Start of API savepoint
2050: SAVEPOINT register_dependent_objdefs_pub;
2051:
2052: -- Standard call to check for call compatibility.
2053: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 2052: -- Standard call to check for call compatibility.

2048:
2049: -- Standard Start of API savepoint
2050: SAVEPOINT register_dependent_objdefs_pub;
2051:
2052: -- Standard call to check for call compatibility.
2053: IF NOT FND_API.Compatible_API_Call (l_api_version,
2054: p_api_version,
2055: l_api_name,
2056: g_pkg_name)

Line 2158: -- Standard Start of API savepoint

2154: ' P_TABLE_NAME:'||p_table_name||
2155: ' P_STATEMENT_TYPE:'||p_statement_type||
2156: ' P_NUM_OF_OUTPUT_ROWS:'||p_num_of_output_rows);
2157:
2158: -- Standard Start of API savepoint
2159: SAVEPOINT register_table_pub;
2160:
2161: -- Standard call to check for call compatibility.
2162: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 2161: -- Standard call to check for call compatibility.

2157:
2158: -- Standard Start of API savepoint
2159: SAVEPOINT register_table_pub;
2160:
2161: -- Standard call to check for call compatibility.
2162: IF NOT FND_API.Compatible_API_Call (l_api_version,
2163: p_api_version,
2164: l_api_name,
2165: g_pkg_name)

Line 2242: -- Standard Start of API savepoint

2238: ' P_TABLE_NAME:'||p_table_name||
2239: ' P_STATEMENT_TYPE:'||p_statement_type||
2240: ' P_NUM_OF_OUTPUT_ROWS:'||p_num_of_output_rows);
2241:
2242: -- Standard Start of API savepoint
2243: SAVEPOINT update_num_of_output_rows_pub;
2244:
2245: -- Standard call to check for call compatibility.
2246: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 2245: -- Standard call to check for call compatibility.

2241:
2242: -- Standard Start of API savepoint
2243: SAVEPOINT update_num_of_output_rows_pub;
2244:
2245: -- Standard call to check for call compatibility.
2246: IF NOT FND_API.Compatible_API_Call (l_api_version,
2247: p_api_version,
2248: l_api_name,
2249: g_pkg_name)

Line 2373: -- Standard Start of API savepoint

2369: ' P_TABLE_NAME:'||p_table_name||
2370: ' P_STATEMENT_TYPE:'||p_statement_type||
2371: ' P_COLUMN_NAME:'||p_column_name);
2372:
2373: -- Standard Start of API savepoint
2374: SAVEPOINT register_updated_column_pub;
2375:
2376: -- Standard call to check for call compatibility.
2377: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 2376: -- Standard call to check for call compatibility.

2372:
2373: -- Standard Start of API savepoint
2374: SAVEPOINT register_updated_column_pub;
2375:
2376: -- Standard call to check for call compatibility.
2377: IF NOT FND_API.Compatible_API_Call (l_api_version,
2378: p_api_version,
2379: l_api_name,
2380: g_pkg_name)

Line 2457: -- Standard Start of API savepoint

2453: ' P_OBJECT_ID:'||p_object_id||' P_COMMIT:'||p_commit||
2454: ' P_SOURCE_CREATED_BY_REQUEST_ID:'||p_source_created_by_request_id||
2455: ' P_SOURCE_CREATED_BY_OBJECT_ID:'||p_source_created_by_object_id);
2456:
2457: -- Standard Start of API savepoint
2458: SAVEPOINT register_chain_pub;
2459:
2460: -- Standard call to check for call compatibility.
2461: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 2460: -- Standard call to check for call compatibility.

2456:
2457: -- Standard Start of API savepoint
2458: SAVEPOINT register_chain_pub;
2459:
2460: -- Standard call to check for call compatibility.
2461: IF NOT FND_API.Compatible_API_Call (l_api_version,
2462: p_api_version,
2463: l_api_name,
2464: g_pkg_name)

Line 2540: -- Standard Start of API savepoint

2536: ' P_OBJECT_ID:'||p_object_id||' P_COMMIT:'||p_commit||
2537: ' P_OBJECT_TYPE:'||p_object_type||
2538: ' P_OBJECT_NAME:'||p_object_name);
2539:
2540: -- Standard Start of API savepoint
2541: SAVEPOINT register_temp_object_pub;
2542:
2543: -- Standard call to check for call compatibility.
2544: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 2543: -- Standard call to check for call compatibility.

2539:
2540: -- Standard Start of API savepoint
2541: SAVEPOINT register_temp_object_pub;
2542:
2543: -- Standard call to check for call compatibility.
2544: IF NOT FND_API.Compatible_API_Call (l_api_version,
2545: p_api_version,
2546: l_api_name,
2547: g_pkg_name)

Line 2620: -- Standard Start of API savepoint

2616: p_msg_text => 'Begin. REQUEST_ID: '||p_request_id||
2617: ' P_OBJECT_ID:'||p_object_id||' P_COMMIT:'||p_commit||
2618: ' P_NUM_OF_INPUT_ROWS:'||p_num_of_input_rows);
2619:
2620: -- Standard Start of API savepoint
2621: SAVEPOINT update_num_of_input_rows_pub;
2622:
2623: -- Standard call to check for call compatibility.
2624: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 2623: -- Standard call to check for call compatibility.

2619:
2620: -- Standard Start of API savepoint
2621: SAVEPOINT update_num_of_input_rows_pub;
2622:
2623: -- Standard call to check for call compatibility.
2624: IF NOT FND_API.Compatible_API_Call (l_api_version,
2625: p_api_version,
2626: l_api_name,
2627: g_pkg_name)

Line 2685: -- Standard Start of API savepoint

2681: ' P_OBJECT_ID:'||p_object_id||' P_COMMIT:'||p_commit||
2682: ' P_EXEC_STEP:'||p_exec_step||
2683: ' P_EXEC_STATUS_CODE:'||p_exec_status_code);
2684:
2685: -- Standard Start of API savepoint
2686: SAVEPOINT register_obj_exec_step_pub;
2687:
2688: -- Standard call to check for call compatibility.
2689: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 2688: -- Standard call to check for call compatibility.

2684:
2685: -- Standard Start of API savepoint
2686: SAVEPOINT register_obj_exec_step_pub;
2687:
2688: -- Standard call to check for call compatibility.
2689: IF NOT FND_API.Compatible_API_Call (l_api_version,
2690: p_api_version,
2691: l_api_name,
2692: g_pkg_name)

Line 2761: -- Standard Start of API savepoint

2757: p_msg_text => 'Begin. REQUEST_ID: '||p_request_id||
2758: ' P_OBJECT_ID:'||p_object_id||' P_COMMIT:'||p_commit||
2759: ' P_EXEC_STEP:'||p_exec_step);
2760:
2761: -- Standard Start of API savepoint
2762: SAVEPOINT unregister_obj_exec_step_pub;
2763:
2764: -- Standard call to check for call compatibility.
2765: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 2764: -- Standard call to check for call compatibility.

2760:
2761: -- Standard Start of API savepoint
2762: SAVEPOINT unregister_obj_exec_step_pub;
2763:
2764: -- Standard call to check for call compatibility.
2765: IF NOT FND_API.Compatible_API_Call (l_api_version,
2766: p_api_version,
2767: l_api_name,
2768: g_pkg_name)

Line 2819: -- Standard Start of API savepoint

2815: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2816: p_msg_text => 'Begin. REQUEST_ID: '||p_request_id||
2817: ' P_OBJECT_ID:'||p_object_id||' P_COMMIT:'||p_commit);
2818:
2819: -- Standard Start of API savepoint
2820: SAVEPOINT unregister_obj_exec_steps_pub;
2821:
2822: -- Standard call to check for call compatibility.
2823: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 2822: -- Standard call to check for call compatibility.

2818:
2819: -- Standard Start of API savepoint
2820: SAVEPOINT unregister_obj_exec_steps_pub;
2821:
2822: -- Standard call to check for call compatibility.
2823: IF NOT FND_API.Compatible_API_Call (l_api_version,
2824: p_api_version,
2825: l_api_name,
2826: g_pkg_name)

Line 2882: -- Standard Start of API savepoint

2878: ' P_OBJECT_ID:'||p_object_id||' P_COMMIT:'||p_commit||
2879: ' P_EXEC_STEP:'||p_exec_step||
2880: ' P_EXEC_STATUS_CODE:'||p_exec_status_code);
2881:
2882: -- Standard Start of API savepoint
2883: SAVEPOINT update_obj_exec_step_statu_pub;
2884:
2885: -- Standard call to check for call compatibility.
2886: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 2885: -- Standard call to check for call compatibility.

2881:
2882: -- Standard Start of API savepoint
2883: SAVEPOINT update_obj_exec_step_statu_pub;
2884:
2885: -- Standard call to check for call compatibility.
2886: IF NOT FND_API.Compatible_API_Call (l_api_version,
2887: p_api_version,
2888: l_api_name,
2889: g_pkg_name)

Line 2955: -- Standard Start of API savepoint

2951: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2952: p_msg_text => 'Begin. P_REQUEST_ID: '||p_request_id||
2953: ' P_OBJECT_ID:'||p_object_id||' P_COMMIT:'||p_commit);
2954:
2955: -- Standard Start of API savepoint
2956: SAVEPOINT set_exec_state_pub;
2957:
2958: -- Standard call to check for call compatibility.
2959: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 2958: -- Standard call to check for call compatibility.

2954:
2955: -- Standard Start of API savepoint
2956: SAVEPOINT set_exec_state_pub;
2957:
2958: -- Standard call to check for call compatibility.
2959: IF NOT FND_API.Compatible_API_Call (l_api_version,
2960: p_api_version,
2961: l_api_name,
2962: g_pkg_name)

Line 4230: -- Standard Start of API savepoint

4226: IF p_init_msg_list = FND_API.G_TRUE then
4227: FND_MSG_PUB.Initialize;
4228: END IF;
4229:
4230: -- Standard Start of API savepoint
4231: SAVEPOINT get_exec_status_pub;
4232:
4233: -- Get the exec status code as recorded in FEM_PL_OBJECT_EXECUTIONS
4234: BEGIN