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_DS_WHERE_CLAUSE_GENERATOR dependencies on FEM_UTILS

Line 25: z_master_err_state NUMBER := FEM_UTILS.G_RSM_NO_ERR;

21: G_MODULE_NAME CONSTANT VARCHAR2(70) := 'fem.plsql.' || G_PKG_NAME || '.';
22:
23: -- these variables must be kept in numerical order, with the lowest number indicating 'no error',
24: -- and each variable after indicating a higher level of error (with the highest being utterly fatal..
25: z_master_err_state NUMBER := FEM_UTILS.G_RSM_NO_ERR;
26:
27: G_ERRMSG_NO_ODS_FOR_DSG CONSTANT varchar2(40) := 'FEM_DSWG_NO_ODS_FOR_DSG ';
28: G_ERRMSG_UNEXPECTED_SQLERROR CONSTANT varchar2(40) := 'FEM_RSM_UNEXPECTED_SQLERROR';
29: G_ERRMAC_ROUTINE_NAME CONSTANT varchar2(40) := 'ROUTINE_NAME';

Line 45: z_master_err_state := FEM_UTILS.G_RSM_NO_ERR;

41: --
42: -- *******************************************************************************************
43: PROCEDURE reset_master_err_state IS
44: BEGIN
45: z_master_err_state := FEM_UTILS.G_RSM_NO_ERR;
46: END reset_master_err_state;
47:
48:
49: ---------------------------------------------------------------

Line 104: FEM_UTILS.set_master_err_state( z_master_err_state,

100: RETURN l_Table_Classification_Code;
101:
102: EXCEPTION
103: WHEN OTHERS THEN
104: FEM_UTILS.set_master_err_state( z_master_err_state,
105: FEM_UTILS.G_RSM_FATAL_ERR,
106: G_APP_NAME,
107: G_ERRMSG_UNEXPECTED_SQLERROR,
108: G_ERRMAC_ROUTINE_NAME,

Line 105: FEM_UTILS.G_RSM_FATAL_ERR,

101:
102: EXCEPTION
103: WHEN OTHERS THEN
104: FEM_UTILS.set_master_err_state( z_master_err_state,
105: FEM_UTILS.G_RSM_FATAL_ERR,
106: G_APP_NAME,
107: G_ERRMSG_UNEXPECTED_SQLERROR,
108: G_ERRMAC_ROUTINE_NAME,
109: l_module_name,

Line 183: FEM_UTILS.set_master_err_state( z_master_err_state,

179: -- if not found
180: RETURN TRUE;
181:
182: WHEN OTHERS THEN
183: FEM_UTILS.set_master_err_state( z_master_err_state,
184: FEM_UTILS.G_RSM_FATAL_ERR,
185: G_APP_NAME,
186: G_ERRMSG_UNEXPECTED_SQLERROR,
187: G_ERRMAC_ROUTINE_NAME,

Line 184: FEM_UTILS.G_RSM_FATAL_ERR,

180: RETURN TRUE;
181:
182: WHEN OTHERS THEN
183: FEM_UTILS.set_master_err_state( z_master_err_state,
184: FEM_UTILS.G_RSM_FATAL_ERR,
185: G_APP_NAME,
186: G_ERRMSG_UNEXPECTED_SQLERROR,
187: G_ERRMAC_ROUTINE_NAME,
188: l_module_name,

Line 251: FEM_UTILS.set_master_err_state( z_master_err_state,

247: p_module=> l_module_name,
248: p_msg_text=> 'EXIT');
249: EXCEPTION
250: WHEN OTHERS THEN
251: FEM_UTILS.set_master_err_state( z_master_err_state,
252: FEM_UTILS.G_RSM_FATAL_ERR,
253: G_APP_NAME,
254: G_ERRMSG_UNEXPECTED_SQLERROR,
255: G_ERRMAC_ROUTINE_NAME,

Line 252: FEM_UTILS.G_RSM_FATAL_ERR,

248: p_msg_text=> 'EXIT');
249: EXCEPTION
250: WHEN OTHERS THEN
251: FEM_UTILS.set_master_err_state( z_master_err_state,
252: FEM_UTILS.G_RSM_FATAL_ERR,
253: G_APP_NAME,
254: G_ERRMSG_UNEXPECTED_SQLERROR,
255: G_ERRMAC_ROUTINE_NAME,
256: l_module_name,

Line 362: FEM_UTILS.set_master_err_state( z_master_err_state,

358: p_msg_text=> 'EXIT');
359:
360: EXCEPTION
361: WHEN OTHERS THEN
362: FEM_UTILS.set_master_err_state( z_master_err_state,
363: FEM_UTILS.G_RSM_FATAL_ERR,
364: G_APP_NAME,
365: G_ERRMSG_UNEXPECTED_SQLERROR,
366: G_ERRMAC_ROUTINE_NAME,

Line 363: FEM_UTILS.G_RSM_FATAL_ERR,

359:
360: EXCEPTION
361: WHEN OTHERS THEN
362: FEM_UTILS.set_master_err_state( z_master_err_state,
363: FEM_UTILS.G_RSM_FATAL_ERR,
364: G_APP_NAME,
365: G_ERRMSG_UNEXPECTED_SQLERROR,
366: G_ERRMAC_ROUTINE_NAME,
367: l_module_name,

Line 438: FEM_UTILS.set_master_err_state( z_master_err_state,

434: p_module=> l_module_name,
435: p_msg_text=> 'EXIT');
436: EXCEPTION
437: WHEN OTHERS THEN
438: FEM_UTILS.set_master_err_state( z_master_err_state,
439: FEM_UTILS.G_RSM_FATAL_ERR,
440: G_APP_NAME,
441: G_ERRMSG_UNEXPECTED_SQLERROR,
442: G_ERRMAC_ROUTINE_NAME,

Line 439: FEM_UTILS.G_RSM_FATAL_ERR,

435: p_msg_text=> 'EXIT');
436: EXCEPTION
437: WHEN OTHERS THEN
438: FEM_UTILS.set_master_err_state( z_master_err_state,
439: FEM_UTILS.G_RSM_FATAL_ERR,
440: G_APP_NAME,
441: G_ERRMSG_UNEXPECTED_SQLERROR,
442: G_ERRMAC_ROUTINE_NAME,
443: l_module_name,

Line 499: FEM_UTILS.set_master_err_state( z_master_err_state,

495: RETURN l_Dim_Grp_Name;
496:
497: EXCEPTION
498: WHEN OTHERS THEN
499: FEM_UTILS.set_master_err_state( z_master_err_state,
500: FEM_UTILS.G_RSM_FATAL_ERR,
501: G_APP_NAME,
502: G_ERRMSG_UNEXPECTED_SQLERROR,
503: G_ERRMAC_ROUTINE_NAME,

Line 500: FEM_UTILS.G_RSM_FATAL_ERR,

496:
497: EXCEPTION
498: WHEN OTHERS THEN
499: FEM_UTILS.set_master_err_state( z_master_err_state,
500: FEM_UTILS.G_RSM_FATAL_ERR,
501: G_APP_NAME,
502: G_ERRMSG_UNEXPECTED_SQLERROR,
503: G_ERRMAC_ROUTINE_NAME,
504: l_module_name,

Line 561: FEM_UTILS.set_master_err_state( z_master_err_state,

557: RETURN l_Dataset_Name;
558:
559: EXCEPTION
560: WHEN OTHERS THEN
561: FEM_UTILS.set_master_err_state( z_master_err_state,
562: FEM_UTILS.G_RSM_FATAL_ERR,
563: G_APP_NAME,
564: G_ERRMSG_UNEXPECTED_SQLERROR,
565: G_ERRMAC_ROUTINE_NAME,

Line 562: FEM_UTILS.G_RSM_FATAL_ERR,

558:
559: EXCEPTION
560: WHEN OTHERS THEN
561: FEM_UTILS.set_master_err_state( z_master_err_state,
562: FEM_UTILS.G_RSM_FATAL_ERR,
563: G_APP_NAME,
564: G_ERRMSG_UNEXPECTED_SQLERROR,
565: G_ERRMAC_ROUTINE_NAME,
566: l_module_name,

Line 623: FEM_UTILS.set_master_err_state( z_master_err_state,

619: RETURN l_Cal_Period_Name;
620:
621: EXCEPTION
622: WHEN OTHERS THEN
623: FEM_UTILS.set_master_err_state( z_master_err_state,
624: FEM_UTILS.G_RSM_FATAL_ERR,
625: G_APP_NAME,
626: G_ERRMSG_UNEXPECTED_SQLERROR,
627: G_ERRMAC_ROUTINE_NAME,

Line 624: FEM_UTILS.G_RSM_FATAL_ERR,

620:
621: EXCEPTION
622: WHEN OTHERS THEN
623: FEM_UTILS.set_master_err_state( z_master_err_state,
624: FEM_UTILS.G_RSM_FATAL_ERR,
625: G_APP_NAME,
626: G_ERRMSG_UNEXPECTED_SQLERROR,
627: G_ERRMAC_ROUTINE_NAME,
628: l_module_name,

Line 730: FEM_UTILS.set_master_err_state( z_master_err_state,

726: p_module=> l_module_name,
727: p_msg_text=> 'EXIT');
728: EXCEPTION
729: WHEN OTHERS THEN
730: FEM_UTILS.set_master_err_state( z_master_err_state,
731: FEM_UTILS.G_RSM_FATAL_ERR,
732: G_APP_NAME,
733: G_ERRMSG_UNEXPECTED_SQLERROR,
734: G_ERRMAC_ROUTINE_NAME,

Line 731: FEM_UTILS.G_RSM_FATAL_ERR,

727: p_msg_text=> 'EXIT');
728: EXCEPTION
729: WHEN OTHERS THEN
730: FEM_UTILS.set_master_err_state( z_master_err_state,
731: FEM_UTILS.G_RSM_FATAL_ERR,
732: G_APP_NAME,
733: G_ERRMSG_UNEXPECTED_SQLERROR,
734: G_ERRMAC_ROUTINE_NAME,
735: l_module_name,

Line 936: FEM_UTILS.set_master_err_state( z_master_err_state,

932: ,p_Eff_Cal_Period_Name => 'No Eff Cal Period Found'
933: ,p_Missing_Entry_Type => 'NO_EFF_CAL_PER'
934: );
935:
936: FEM_UTILS.set_master_err_state( z_master_err_state,
937: FEM_UTILS.G_RSM_NONFATAL_ERR,
938: G_APP_NAME,
939: G_NO_EFFECTIVE_CAL_PERIOD );
940: -- The following offset information in the Dataset Input List doesn't

Line 937: FEM_UTILS.G_RSM_NONFATAL_ERR,

933: ,p_Missing_Entry_Type => 'NO_EFF_CAL_PER'
934: );
935:
936: FEM_UTILS.set_master_err_state( z_master_err_state,
937: FEM_UTILS.G_RSM_NONFATAL_ERR,
938: G_APP_NAME,
939: G_NO_EFFECTIVE_CAL_PERIOD );
940: -- The following offset information in the Dataset Input List doesn't
941: -- resolve to an Effective Input Calendar Period

Line 982: FEM_UTILS.set_master_err_state( z_master_err_state,

978: ,p_Rel_Cal_Period_Offset => l_Rel_Cal_Period_Offset
979: ,p_Eff_Cal_Period_Name => l_Effective_Cal_Period_Name
980: ,p_Missing_Entry_Type => 'DUP_ENTRY' );
981:
982: FEM_UTILS.set_master_err_state( z_master_err_state,
983: FEM_UTILS.G_RSM_NONFATAL_ERR,
984: G_APP_NAME,
985: G_DUPLICATE_INPUT_LIST_ENTRY,
986: G_MACRO_DATASET,

Line 983: FEM_UTILS.G_RSM_NONFATAL_ERR,

979: ,p_Eff_Cal_Period_Name => l_Effective_Cal_Period_Name
980: ,p_Missing_Entry_Type => 'DUP_ENTRY' );
981:
982: FEM_UTILS.set_master_err_state( z_master_err_state,
983: FEM_UTILS.G_RSM_NONFATAL_ERR,
984: G_APP_NAME,
985: G_DUPLICATE_INPUT_LIST_ENTRY,
986: G_MACRO_DATASET,
987: l_Input_Dataset_Name,

Line 1011: FEM_UTILS.set_master_err_state( z_master_err_state,

1007: p_module=> l_module_name,
1008: p_msg_text=> 'EXIT');
1009: EXCEPTION
1010: WHEN OTHERS THEN
1011: FEM_UTILS.set_master_err_state( z_master_err_state,
1012: FEM_UTILS.G_RSM_FATAL_ERR,
1013: G_APP_NAME,
1014: G_ERRMSG_UNEXPECTED_SQLERROR,
1015: G_ERRMAC_ROUTINE_NAME,

Line 1012: FEM_UTILS.G_RSM_FATAL_ERR,

1008: p_msg_text=> 'EXIT');
1009: EXCEPTION
1010: WHEN OTHERS THEN
1011: FEM_UTILS.set_master_err_state( z_master_err_state,
1012: FEM_UTILS.G_RSM_FATAL_ERR,
1013: G_APP_NAME,
1014: G_ERRMSG_UNEXPECTED_SQLERROR,
1015: G_ERRMAC_ROUTINE_NAME,
1016: l_module_name,

Line 1124: FEM_UTILS.set_master_err_state( z_master_err_state,

1120: FETCH GetOutputDS INTO
1121: x_Output_DS_ID;
1122:
1123: IF GetOutputDS%NOTFOUND THEN
1124: FEM_UTILS.set_master_err_state( z_master_err_state,
1125: FEM_UTILS.G_RSM_FATAL_ERR,
1126: G_APP_NAME,
1127: G_ERRMSG_NO_ODS_FOR_DSG );
1128: -- this one and only error is utterly fatal if we get it (no output ds!!!)

Line 1125: FEM_UTILS.G_RSM_FATAL_ERR,

1121: x_Output_DS_ID;
1122:
1123: IF GetOutputDS%NOTFOUND THEN
1124: FEM_UTILS.set_master_err_state( z_master_err_state,
1125: FEM_UTILS.G_RSM_FATAL_ERR,
1126: G_APP_NAME,
1127: G_ERRMSG_NO_ODS_FOR_DSG );
1128: -- this one and only error is utterly fatal if we get it (no output ds!!!)
1129: RAISE FND_API.G_EXC_ERROR;

Line 1165: FEM_UTILS.set_master_err_state( z_master_err_state,

1161:
1162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1163:
1164: WHEN OTHERS THEN
1165: FEM_UTILS.set_master_err_state( z_master_err_state,
1166: FEM_UTILS.G_RSM_FATAL_ERR,
1167: G_APP_NAME,
1168: G_ERRMSG_UNEXPECTED_SQLERROR,
1169: G_ERRMAC_ROUTINE_NAME,

Line 1166: FEM_UTILS.G_RSM_FATAL_ERR,

1162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1163:
1164: WHEN OTHERS THEN
1165: FEM_UTILS.set_master_err_state( z_master_err_state,
1166: FEM_UTILS.G_RSM_FATAL_ERR,
1167: G_APP_NAME,
1168: G_ERRMSG_UNEXPECTED_SQLERROR,
1169: G_ERRMAC_ROUTINE_NAME,
1170: l_module_name,

Line 1327: FEM_UTILS.set_master_err_state( z_master_err_state,

1323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1324: END IF;
1325:
1326: If (p_Ledger_Id is NULL) then
1327: FEM_UTILS.set_master_err_state( z_master_err_state,
1328: FEM_UTILS.G_RSM_NONFATAL_ERR,
1329: G_APP_NAME,
1330: G_LEDGER_REQD_FOR_LEDG_TABS );
1331: ELSE

Line 1328: FEM_UTILS.G_RSM_NONFATAL_ERR,

1324: END IF;
1325:
1326: If (p_Ledger_Id is NULL) then
1327: FEM_UTILS.set_master_err_state( z_master_err_state,
1328: FEM_UTILS.G_RSM_NONFATAL_ERR,
1329: G_APP_NAME,
1330: G_LEDGER_REQD_FOR_LEDG_TABS );
1331: ELSE
1332:

Line 1389: IF (z_master_err_state = FEM_UTILS.G_RSM_FATAL_ERR) THEN

1385: p_module=> l_module_name,
1386: p_msg_text=> 'EXIT');
1387:
1388:
1389: IF (z_master_err_state = FEM_UTILS.G_RSM_FATAL_ERR) THEN
1390: RAISE FND_API.G_EXC_ERROR;
1391: END IF;
1392:
1393: FND_MSG_PUB.Count_And_Get ( p_encoded,

Line 1412: FEM_UTILS.set_master_err_state( z_master_err_state,

1408:
1409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1410:
1411: WHEN OTHERS THEN
1412: FEM_UTILS.set_master_err_state( z_master_err_state,
1413: FEM_UTILS.G_RSM_FATAL_ERR,
1414: G_APP_NAME,
1415: G_ERRMSG_UNEXPECTED_SQLERROR,
1416: G_ERRMAC_ROUTINE_NAME,

Line 1413: FEM_UTILS.G_RSM_FATAL_ERR,

1409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1410:
1411: WHEN OTHERS THEN
1412: FEM_UTILS.set_master_err_state( z_master_err_state,
1413: FEM_UTILS.G_RSM_FATAL_ERR,
1414: G_APP_NAME,
1415: G_ERRMSG_UNEXPECTED_SQLERROR,
1416: G_ERRMAC_ROUTINE_NAME,
1417: l_module_name,