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_SOURCE_DATA_LOADER_PKG dependencies on FND_API

Line 15: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

11: G_LOG_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.level_error;
12: G_LOG_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.level_unexpected;
13:
14: G_API_VERSION CONSTANT NUMBER := 1.0;
15: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
16: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
17: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
19: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

Line 16: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;

12: G_LOG_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.level_unexpected;
13:
14: G_API_VERSION CONSTANT NUMBER := 1.0;
15: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
16: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
17: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
19: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
20: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FEM_SOURCE_DATA_LOADER_PKG';

Line 17: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

13:
14: G_API_VERSION CONSTANT NUMBER := 1.0;
15: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
16: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
17: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
19: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
20: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FEM_SOURCE_DATA_LOADER_PKG';
21:

Line 18: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

14: G_API_VERSION CONSTANT NUMBER := 1.0;
15: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
16: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
17: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
19: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
20: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FEM_SOURCE_DATA_LOADER_PKG';
21:
22: G_DEFAULT_DIM_GRP_SIZE CONSTANT NUMBER := 5;

Line 19: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

15: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
16: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
17: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
19: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
20: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FEM_SOURCE_DATA_LOADER_PKG';
21:
22: G_DEFAULT_DIM_GRP_SIZE CONSTANT NUMBER := 5;
23: G_MAX_DIMS CONSTANT NUMBER := 150;

Line 560: -- (look at FND_API for the possible statuses)

556: -- x_dataset_dc : Dataset display code
557: -- x_source_system_dc : Source system display code
558: -- x_ledger_dc : Ledger display code
559: -- x_return_status : Return status
560: -- (look at FND_API for the possible statuses)
561: --
562: -- Notes
563: --
564: PROCEDURE Validate_Loader_Parameters (

Line 774: -- (look at FND_API for the possible statuses)

770: -- request ID
771: -- x_exec_state : Object execution status set by call to
772: -- FEM_PL_PKG.Register_Object_Execution
773: -- x_return_status : Return status
774: -- (look at FND_API for the possible statuses)
775: -- Notes
776: --
777: PROCEDURE Register_Process_Execution (
778: p_object_id IN NUMBER,

Line 1098: -- (look at FND_API for the possible statuses)

1094: -- Arguments
1095: -- p_table_name : Table for which xdim info will be looked up
1096: -- p_ledger_id : Ledger ID need to find the Global VS Combo
1097: -- x_return_status : Return status
1098: -- (look at FND_API for the possible statuses)
1099: -- Notes
1100: --
1101: PROCEDURE Populate_xDim_Info_Tbl(
1102: p_table_name IN VARCHAR2,

Line 1260: -- (look at FND_API for the possible statuses)

1256: -- p_ledger_dc : Ledger display code
1257: -- x_condition : Multiprocessing p_condition
1258: -- dimension validation
1259: -- x_return_status : Return status
1260: -- (look at FND_API for the possible statuses)
1261: -- Notes
1262: --
1263: PROCEDURE Set_MP_Condition (
1264: p_exec_mode IN VARCHAR2,

Line 1364: -- (look at FND_API for the possible statuses)

1360: -- dimension validation errors
1361: -- x_insert_target_sql : SQL to insert/replace validated rows into the
1362: -- target table
1363: -- x_return_status : Return status
1364: -- (look at FND_API for the possible statuses)
1365: -- Notes
1366: --
1367: PROCEDURE Prepare_Dynamic_Sql (
1368: p_object_id IN NUMBER,

Line 2870: -- (look at FND_API for the possible statuses)

2866: -- p_request_id : Concurrent request ID
2867: -- p_user_id : User ID
2868: -- p_login_id : Login ID
2869: -- x_return_status : Return status
2870: -- (look at FND_API for the possible statuses)
2871: -- Notes
2872: --
2873: PROCEDURE Post_Process (
2874: p_object_id IN NUMBER,

Line 3268: -- (look at FND_API for the possible statuses)

3264: -- x_table_name : Source data target table name
3265: -- x_msg_count : Message count
3266: -- x_msg_data : Message text (if msg count = 1)
3267: -- x_return_status : Return status
3268: -- (look at FND_API for the possible statuses)
3269: -- Notes
3270: --
3271: PROCEDURE Validate_Obj_Def (
3272: p_api_version IN NUMBER,

Line 3307: IF NOT FND_API.Compatible_API_Call (C_API_VERSION,

3303: p_msg_text => 'Parameter: Object definition ID is '||p_obj_def_id);
3304: END IF;
3305:
3306: -- Check for call compatibility.
3307: IF NOT FND_API.Compatible_API_Call (C_API_VERSION,
3308: p_api_version,
3309: C_API_NAME,
3310: G_PKG_NAME)
3311: THEN

Line 3312: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3308: p_api_version,
3309: C_API_NAME,
3310: G_PKG_NAME)
3311: THEN
3312: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3313: END IF;
3314:
3315: -- --------------------------------------------------------------------
3316: -- Validate the Object Definition ID engine parameter by making sure it

Line 3438: -- (look at FND_API for the possible statuses)

3434: -- p_table_classification : Table classification
3435: -- x_msg_count : Message count
3436: -- x_msg_data : Message text (if msg count = 1)
3437: -- x_return_status : Return status
3438: -- (look at FND_API for the possible statuses)
3439: -- Notes
3440: --
3441: PROCEDURE Validate_Table (
3442: p_api_version IN NUMBER,

Line 3478: IF NOT FND_API.Compatible_API_Call (C_API_VERSION,

3474: p_msg_text => 'Parameter: Table classification is '||p_table_classification);
3475: END IF;
3476:
3477: -- Check for call compatibility.
3478: IF NOT FND_API.Compatible_API_Call (C_API_VERSION,
3479: p_api_version,
3480: C_API_NAME,
3481: G_PKG_NAME)
3482: THEN

Line 3483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3479: p_api_version,
3480: C_API_NAME,
3481: G_PKG_NAME)
3482: THEN
3483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3484: END IF;
3485:
3486: SELECT COUNT(*)
3487: INTO l_count

Line 3559: -- (look at FND_API for the possible statuses)

3555: -- p_exec_mode : Execution mode
3556: -- x_msg_count : Message count
3557: -- x_msg_data : Message text (if msg count = 1)
3558: -- x_return_status : Return status
3559: -- (look at FND_API for the possible statuses)
3560: -- Notes
3561: --
3562: PROCEDURE Validate_Exec_Mode (
3563: p_api_version IN NUMBER,

Line 3597: IF NOT FND_API.Compatible_API_Call (C_API_VERSION,

3593: p_msg_text => 'Parameter: Exec Mode is '||p_exec_mode);
3594: END IF;
3595:
3596: -- Check for call compatibility.
3597: IF NOT FND_API.Compatible_API_Call (C_API_VERSION,
3598: p_api_version,
3599: C_API_NAME,
3600: G_PKG_NAME)
3601: THEN

Line 3602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3598: p_api_version,
3599: C_API_NAME,
3600: G_PKG_NAME)
3601: THEN
3602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3603: END IF;
3604:
3605: -- Start of Replacement mode enhancement
3606:

Line 3695: -- (look at FND_API for the possible statuses)

3691: -- x_ledger_dc : Ledger display code
3692: -- x_msg_count : Message count
3693: -- x_msg_data : Message text (if msg count = 1)
3694: -- x_return_status : Return status
3695: -- (look at FND_API for the possible statuses)
3696: -- Notes
3697: --
3698: PROCEDURE Validate_Ledger (
3699: p_api_version IN NUMBER,

Line 3723: IF NOT FND_API.Compatible_API_Call (C_API_VERSION,

3719: e_inv_ledger EXCEPTION;
3720: BEGIN
3721:
3722: -- Check for call compatibility.
3723: IF NOT FND_API.Compatible_API_Call (C_API_VERSION,
3724: p_api_version,
3725: C_API_NAME,
3726: G_PKG_NAME)
3727: THEN

Line 3728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3724: p_api_version,
3725: C_API_NAME,
3726: G_PKG_NAME)
3727: THEN
3728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3729: END IF;
3730:
3731: IF G_LOG_LEVEL_PROCEDURE >= g_log_current_level THEN
3732: FEM_ENGINES_PKG.TECH_MESSAGE(

Line 3953: -- (look at FND_API for the possible statuses)

3949: -- x_cal_per_number : Cal period number
3950: -- x_msg_count : Message count
3951: -- x_msg_data : Message text (if msg count = 1)
3952: -- x_return_status : Return status
3953: -- (look at FND_API for the possible statuses)
3954: -- Notes
3955: --
3956: PROCEDURE Validate_Cal_Period (
3957: p_api_version IN NUMBER,

Line 4005: IF NOT FND_API.Compatible_API_Call (C_API_VERSION,

4001: p_msg_text => 'Parameter: Calendar Period ID is '||p_cal_period_id);
4002: END IF;
4003:
4004: -- Check for call compatibility.
4005: IF NOT FND_API.Compatible_API_Call (C_API_VERSION,
4006: p_api_version,
4007: C_API_NAME,
4008: G_PKG_NAME)
4009: THEN

Line 4010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4006: p_api_version,
4007: C_API_NAME,
4008: G_PKG_NAME)
4009: THEN
4010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4011: END IF;
4012:
4013: -- Get the calendar of the cal period
4014: BEGIN

Line 4269: -- (look at FND_API for the possible statuses)

4265: -- x_dateset_dc : Dataset display code
4266: -- x_msg_count : Message count
4267: -- x_msg_data : Message text (if msg count = 1)
4268: -- x_return_status : Return status
4269: -- (look at FND_API for the possible statuses)
4270: -- Notes
4271: --
4272: PROCEDURE Validate_Dataset (
4273: p_api_version IN NUMBER,

Line 4309: IF NOT FND_API.Compatible_API_Call (C_API_VERSION,

4305: p_msg_text => 'Parameter: Dataset code is '||p_dataset_code);
4306: END IF;
4307:
4308: -- Check for call compatibility.
4309: IF NOT FND_API.Compatible_API_Call (C_API_VERSION,
4310: p_api_version,
4311: C_API_NAME,
4312: G_PKG_NAME)
4313: THEN

Line 4314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4310: p_api_version,
4311: C_API_NAME,
4312: G_PKG_NAME)
4313: THEN
4314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4315: END IF;
4316:
4317: x_return_status := G_RET_STS_SUCCESS;
4318:

Line 4462: -- (look at FND_API for the possible statuses)

4458: -- x_source_system_dc : Source system display code
4459: -- x_msg_count : Message count
4460: -- x_msg_data : Message text (if msg count = 1)
4461: -- x_return_status : Return status
4462: -- (look at FND_API for the possible statuses)
4463: -- Notes
4464: --
4465: PROCEDURE Validate_Source_System (
4466: p_api_version IN NUMBER,

Line 4498: IF NOT FND_API.Compatible_API_Call (C_API_VERSION,

4494: p_msg_text => 'Parameter: Source system code is '||p_source_system_code);
4495: END IF;
4496:
4497: -- Check for call compatibility.
4498: IF NOT FND_API.Compatible_API_Call (C_API_VERSION,
4499: p_api_version,
4500: C_API_NAME,
4501: G_PKG_NAME)
4502: THEN

Line 4503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4499: p_api_version,
4500: C_API_NAME,
4501: G_PKG_NAME)
4502: THEN
4503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4504: END IF;
4505:
4506: x_return_status := G_RET_STS_SUCCESS;
4507: