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_GL_POST_PROCESS_PKG dependencies on FND_LOG

Line 8: pc_log_level_statement CONSTANT NUMBER := fnd_log.level_statement;

4: /**************************************************************************
5: -- Private Package Variables and exceptions
6: **************************************************************************/
7:
8: pc_log_level_statement CONSTANT NUMBER := fnd_log.level_statement;
9: pc_log_level_procedure CONSTANT NUMBER := fnd_log.level_procedure;
10: pc_log_level_event CONSTANT NUMBER := fnd_log.level_event;
11: pc_log_level_exception CONSTANT NUMBER := fnd_log.level_exception;
12: pc_log_level_error CONSTANT NUMBER := fnd_log.level_error;

Line 9: pc_log_level_procedure CONSTANT NUMBER := fnd_log.level_procedure;

5: -- Private Package Variables and exceptions
6: **************************************************************************/
7:
8: pc_log_level_statement CONSTANT NUMBER := fnd_log.level_statement;
9: pc_log_level_procedure CONSTANT NUMBER := fnd_log.level_procedure;
10: pc_log_level_event CONSTANT NUMBER := fnd_log.level_event;
11: pc_log_level_exception CONSTANT NUMBER := fnd_log.level_exception;
12: pc_log_level_error CONSTANT NUMBER := fnd_log.level_error;
13: pc_log_level_unexpected CONSTANT NUMBER := fnd_log.level_unexpected;

Line 10: pc_log_level_event CONSTANT NUMBER := fnd_log.level_event;

6: **************************************************************************/
7:
8: pc_log_level_statement CONSTANT NUMBER := fnd_log.level_statement;
9: pc_log_level_procedure CONSTANT NUMBER := fnd_log.level_procedure;
10: pc_log_level_event CONSTANT NUMBER := fnd_log.level_event;
11: pc_log_level_exception CONSTANT NUMBER := fnd_log.level_exception;
12: pc_log_level_error CONSTANT NUMBER := fnd_log.level_error;
13: pc_log_level_unexpected CONSTANT NUMBER := fnd_log.level_unexpected;
14:

Line 11: pc_log_level_exception CONSTANT NUMBER := fnd_log.level_exception;

7:
8: pc_log_level_statement CONSTANT NUMBER := fnd_log.level_statement;
9: pc_log_level_procedure CONSTANT NUMBER := fnd_log.level_procedure;
10: pc_log_level_event CONSTANT NUMBER := fnd_log.level_event;
11: pc_log_level_exception CONSTANT NUMBER := fnd_log.level_exception;
12: pc_log_level_error CONSTANT NUMBER := fnd_log.level_error;
13: pc_log_level_unexpected CONSTANT NUMBER := fnd_log.level_unexpected;
14:
15: pc_API_version CONSTANT NUMBER := 1.0;

Line 12: pc_log_level_error CONSTANT NUMBER := fnd_log.level_error;

8: pc_log_level_statement CONSTANT NUMBER := fnd_log.level_statement;
9: pc_log_level_procedure CONSTANT NUMBER := fnd_log.level_procedure;
10: pc_log_level_event CONSTANT NUMBER := fnd_log.level_event;
11: pc_log_level_exception CONSTANT NUMBER := fnd_log.level_exception;
12: pc_log_level_error CONSTANT NUMBER := fnd_log.level_error;
13: pc_log_level_unexpected CONSTANT NUMBER := fnd_log.level_unexpected;
14:
15: pc_API_version CONSTANT NUMBER := 1.0;
16:

Line 13: pc_log_level_unexpected CONSTANT NUMBER := fnd_log.level_unexpected;

9: pc_log_level_procedure CONSTANT NUMBER := fnd_log.level_procedure;
10: pc_log_level_event CONSTANT NUMBER := fnd_log.level_event;
11: pc_log_level_exception CONSTANT NUMBER := fnd_log.level_exception;
12: pc_log_level_error CONSTANT NUMBER := fnd_log.level_error;
13: pc_log_level_unexpected CONSTANT NUMBER := fnd_log.level_unexpected;
14:
15: pc_API_version CONSTANT NUMBER := 1.0;
16:
17: pv_proc_name VARCHAR2(30);

Line 350: -- FND_LOG with the "unexpected exception" severity level.

346:
347: x_completion_code := 2;
348:
349: -- Log the call stack and the Oracle error message to
350: -- FND_LOG with the "unexpected exception" severity level.
351:
352: FEM_ENGINES_PKG.Tech_Message
353: (p_severity => pc_log_level_unexpected,
354: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

Line 692: -- FND_LOG with the "unexpected exception" severity level.

688: pv_sqlerrm := SQLERRM;
689: pv_callstack := dbms_utility.format_call_stack;
690:
691: -- Log the call stack and the Oracle error message to
692: -- FND_LOG with the "unexpected exception" severity level.
693:
694: FEM_ENGINES_PKG.Tech_Message
695: (p_severity => pc_log_level_unexpected,
696: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

Line 1081: -- FND_LOG with the "unexpected exception" severity level.

1077: pv_sqlerrm := SQLERRM;
1078: pv_callstack := dbms_utility.format_call_stack;
1079:
1080: -- Log the call stack and the Oracle error message to
1081: -- FND_LOG with the "unexpected exception" severity level.
1082:
1083: FEM_ENGINES_PKG.Tech_Message
1084: (P_SEVERITY => pc_log_level_unexpected,
1085: P_MODULE => 'fem.plsql.fem_gl_post_process_pkg.' ||

Line 1398: -- FND_LOG with the "unexpected exception" severity level.

1394: pv_sqlerrm := SQLERRM;
1395: pv_callstack := dbms_utility.format_call_stack;
1396:
1397: -- Log the call stack and the Oracle error message to
1398: -- FND_LOG with the "unexpected exception" severity level.
1399:
1400: FEM_ENGINES_PKG.Tech_Message
1401: (p_severity => pc_log_level_unexpected,
1402: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

Line 4064: -- tokens in the messages logged to FND_LOG and Concurrent

4060: EXCEPTION
4061: ------------------------------------------------------------------
4062: -- For each exception, try to get the translated names for the
4063: -- dimensions (parameters) and dimension attributes used as
4064: -- tokens in the messages logged to FND_LOG and Concurrent
4065: -- Request Log.
4066: ------------------------------------------------------------------
4067:
4068: WHEN Invalid_Budget_ID THEN

Line 4324: (p_severity => fnd_log.level_error,

4320: -- (Incremental), and 'E' (Error Reprocessing Only).
4321: ------------------------------------------------------------------
4322:
4323: FEM_ENGINES_PKG.Tech_Message
4324: (p_severity => fnd_log.level_error,
4325: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
4326: pv_proc_name || '.invalid_exec_mode',
4327: p_app_name => 'FEM',
4328: p_msg_name => 'FEM_GL_POST_014');

Line 4504: -- FND_LOG with the "unexpected exception" severity level.

4500:
4501: END IF;
4502:
4503: -- Log the call stack and the Oracle error message to
4504: -- FND_LOG with the "unexpected exception" severity level.
4505:
4506: FEM_ENGINES_PKG.Tech_Message
4507: (p_severity => pc_log_level_unexpected,
4508: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||

Line 4582: -- Log the function entry time to FND_LOG

4578: BEGIN
4579: v_module := 'fem.plsql.fem_gl_post_process_pkg.validate_ogl_eng_parameters';
4580: v_func_name := 'FEM_GL_POST_PROCESS_PKG.Validate_OGL_Eng_Parameters';
4581:
4582: -- Log the function entry time to FND_LOG
4583: FEM_ENGINES_PKG.Tech_Message
4584: (p_severity => pc_log_level_procedure,
4585: p_module => v_module,
4586: p_app_name => 'FEM',

Line 4604: -- Set Request ID and then print its value to FND_LOG

4600: -- Bug 4394404 hkaniven start - package variable to store the no of valid rows
4601: pv_num_rows_valid := 0;
4602: -- Bug 4394404 hkaniven end - package variable to store the no of valid rows
4603:
4604: -- Set Request ID and then print its value to FND_LOG
4605: pv_req_id := FND_GLOBAL.Conc_Request_Id;
4606: FEM_ENGINES_PKG.Tech_Message
4607: (p_severity => pc_log_level_statement,
4608: p_module => v_module,

Line 4616: -- Set User ID and then print its value to FND_LOG

4612: p_value1 => 'pv_req_id',
4613: p_token2 => 'VAR_VAL',
4614: p_value2 => TO_CHAR(pv_req_id));
4615:
4616: -- Set User ID and then print its value to FND_LOG
4617: pv_user_id := FND_GLOBAL.User_Id;
4618: FEM_ENGINES_PKG.Tech_Message
4619: (p_severity => pc_log_level_statement,
4620: p_module => v_module,

Line 4628: -- Set Login ID and then print its value to FND_LOG

4624: p_value1 => 'pv_user_id',
4625: p_token2 => 'VAR_VAL',
4626: p_value2 => TO_CHAR(pv_user_id));
4627:
4628: -- Set Login ID and then print its value to FND_LOG
4629: pv_login_id := FND_GLOBAL.Login_Id;
4630: FEM_ENGINES_PKG.Tech_Message
4631: (p_severity => pc_log_level_statement,
4632: p_module => v_module,

Line 4640: -- Set Concurrent Program ID and then print its value to FND_LOG

4636: p_value1 => 'pv_login_id',
4637: p_token2 => 'VAR_VAL',
4638: p_value2 => TO_CHAR(pv_login_id));
4639:
4640: -- Set Concurrent Program ID and then print its value to FND_LOG
4641: pv_pgm_id := FND_GLOBAL.Conc_Program_Id;
4642: FEM_ENGINES_PKG.Tech_Message
4643: (p_severity => pc_log_level_statement,
4644: p_module => v_module,

Line 4652: -- Set Program Application ID and then print its value to FND_LOG

4648: p_value1 => 'pv_pgm_id',
4649: p_token2 => 'VAR_VAL',
4650: p_value2 => TO_CHAR(pv_pgm_id));
4651:
4652: -- Set Program Application ID and then print its value to FND_LOG
4653: pv_pgm_app_id := FND_GLOBAL.Prog_Appl_ID;
4654: FEM_ENGINES_PKG.Tech_Message
4655: (p_severity => pc_log_level_statement,
4656: p_module => v_module,

Line 4671: -- Print the error message to FND_LOG and concurrent program log

4667: -- Bug 4294018 - hkaniven start - If Signage Methodology is not set,
4668: -- then error out
4669: IF (v_signage_method IS NULL)
4670: THEN
4671: -- Print the error message to FND_LOG and concurrent program log
4672: FEM_ENGINES_PKG.Tech_Message
4673: (p_severity => pc_log_level_event,
4674: p_module => v_module,
4675: p_app_name => 'FEM',

Line 4729: -- print its value to FND_LOG

4725: p_token2 => 'VAR_VAL',
4726: p_value2 => TO_CHAR(v_signage_method));
4727:
4728: -- Set Advanced Line Item and Financial Element Mappings Flag and then
4729: -- print its value to FND_LOG
4730: FND_PROFILE.GET('FEM_GL_ADV_MAPPING_FLAG', pv_adv_li_fe_mappings_flag);
4731:
4732: -- If it is not set, default it as 'N'
4733: IF (pv_adv_li_fe_mappings_flag IS NULL)

Line 4735: -- Print the warning message to FND_LOG and concurrent program log

4731:
4732: -- If it is not set, default it as 'N'
4733: IF (pv_adv_li_fe_mappings_flag IS NULL)
4734: THEN
4735: -- Print the warning message to FND_LOG and concurrent program log
4736: FEM_ENGINES_PKG.Tech_Message
4737: (p_severity => pc_log_level_event,
4738: p_module => v_module,
4739: p_app_name => 'FEM',

Line 4843: -- List out the balances rule setup to FND_LOG

4839: p_msg_text => 'Raising Invalid_Object_Def_ID exception');
4840: RAISE Invalid_Object_Def_ID;
4841: END;
4842:
4843: -- List out the balances rule setup to FND_LOG
4844: FEM_ENGINES_PKG.Tech_Message
4845: (p_severity => pc_log_level_statement,
4846: p_module => v_module,
4847: p_app_name => 'FEM',

Line 5321: -- Log a warning message to FND_LOG as well as the concurrent request log

5317: -- If the As-Of-Date parameter is not provided or it is not within the To
5318: -- Period, we set it as the end date of the To Period
5319: p_effective_date := pv_to_date;
5320:
5321: -- Log a warning message to FND_LOG as well as the concurrent request log
5322: FEM_ENGINES_PKG.Tech_Message
5323: (p_severity => pc_log_level_event,
5324: p_module => v_module,
5325: p_app_name => 'FEM',

Line 5542: -- Get the number of rows inserted and log it to FND_LOG

5538: -- Bug 4394404 hkaniven end - to get latest encumbrance year
5539:
5540: END IF; -- IF (pv_ds_balance_type_cd = 'ACTUAL')
5541:
5542: -- Get the number of rows inserted and log it to FND_LOG
5543: pv_num_rows := SQL%ROWCOUNT;
5544: FEM_ENGINES_PKG.Tech_Message
5545: (p_severity => pc_log_level_statement,
5546: p_module => v_module,

Line 5725: -- Log a warning message to FND_LOG as well as the concurrent request log

5721: -- At least one but not all peroid are invalid, so set the return code to
5722: -- 1 i.e. indicating warning
5723: x_completion_code := 1;
5724:
5725: -- Log a warning message to FND_LOG as well as the concurrent request log
5726: -- Bug fix 4170124: The message is changed and doesn't have any tockens.
5727: FEM_ENGINES_PKG.Tech_Message
5728: (p_severity => pc_log_level_exception,
5729: p_module => v_module,

Line 5759: -- Log the function exit time to FND_LOG (successful completion)

5755: -- ----------------------------
5756: -- 7. Exit with success/warning
5757: -- ----------------------------
5758:
5759: -- Log the function exit time to FND_LOG (successful completion)
5760: FEM_ENGINES_PKG.Tech_Message
5761: (p_severity => pc_log_level_procedure,
5762: p_module => v_module,
5763: p_app_name => 'FEM',

Line 5790: -- Log the function exit time to FND_LOG (with error)

5786: p_token1 => 'DIMENSION_NAME',
5787: p_value1 => 'FEM_OBJECT_DEF_ID_TXT',
5788: p_trans1 => 'Y');
5789:
5790: -- Log the function exit time to FND_LOG (with error)
5791: FEM_ENGINES_PKG.Tech_Message
5792: (p_severity => pc_log_level_procedure,
5793: p_module => v_module,
5794: p_app_name => 'FEM',

Line 5814: -- Log the function exit time to FND_LOG (with error)

5810: FEM_ENGINES_PKG.User_Message
5811: (p_app_name => 'FEM',
5812: p_msg_name => 'FEM_INTG_BAL_INVALID_RULE');
5813:
5814: -- Log the function exit time to FND_LOG (with error)
5815: FEM_ENGINES_PKG.Tech_Message
5816: (p_severity => pc_log_level_procedure,
5817: p_module => v_module,
5818: p_app_name => 'FEM',

Line 5838: -- Log the function exit time to FND_LOG (with error)

5834: FEM_ENGINES_PKG.User_Message
5835: (p_app_name => 'FEM',
5836: p_msg_name => 'FEM_GL_POST_011');
5837:
5838: -- Log the function exit time to FND_LOG (with error)
5839: FEM_ENGINES_PKG.Tech_Message
5840: (p_severity => pc_log_level_procedure,
5841: p_module => v_module,
5842: p_app_name => 'FEM',

Line 5917: -- Log the function exit time to FND_LOG (with error)

5913: p_value2 => v_dim_name);
5914:
5915: END IF; -- IF pv_attr_label IS NOT NULL
5916:
5917: -- Log the function exit time to FND_LOG (with error)
5918: FEM_ENGINES_PKG.Tech_Message
5919: (p_severity => pc_log_level_procedure,
5920: p_module => v_module,
5921: p_app_name => 'FEM',

Line 5933: -- time to FND_LOG (with error)

5929: -- <<< Fatal error >>>
5930: x_completion_code := 2; -- Indicating fatal error
5931:
5932: -- The error messages were printed, so just need to log the function exit
5933: -- time to FND_LOG (with error)
5934: FEM_ENGINES_PKG.Tech_Message
5935: (p_severity => pc_log_level_procedure,
5936: p_module => v_module,
5937: p_app_name => 'FEM',

Line 5955: -- FND_LOG with the "unexpected exception" severity level.

5951: pv_callstack := dbms_utility.format_call_stack;
5952: END IF;
5953:
5954: -- Log the call stack and the Oracle error message to
5955: -- FND_LOG with the "unexpected exception" severity level.
5956: FEM_ENGINES_PKG.Tech_Message
5957: (p_severity => pc_log_level_unexpected,
5958: p_module => 'fem.plsql.fem_gl_post_process_pkg.' || pv_proc_name,
5959: p_msg_text => pv_sqlerrm);

Line 5970: -- Log the function exit time to FND_LOG (with error)

5966: FEM_ENGINES_PKG.User_Message
5967: (p_app_name => 'FEM',
5968: p_msg_text => pv_sqlerrm);
5969:
5970: -- Log the function exit time to FND_LOG (with error)
5971: FEM_ENGINES_PKG.Tech_Message
5972: (p_severity => pc_log_level_procedure,
5973: p_module => v_module,
5974: p_app_name => 'FEM',

Line 6064: -- Log the function entry time to FND_LOG

6060: BEGIN
6061: v_module := 'fem.plsql.fem_gl_post_process_pkg.register_ogl_process_execution';
6062: v_func_name := 'FEM_GL_POST_PROCESS_PKG.Register_OGL_Process_Execution';
6063:
6064: -- Log the function entry time to FND_LOG
6065: FEM_ENGINES_PKG.Tech_Message
6066: (p_severity => pc_log_level_procedure,
6067: p_module => v_module,
6068: p_app_name => 'FEM',

Line 6580: -- Print the request ID to FND Log

6576: SELECT FND_CONCURRENT_REQUESTS_S.nextval
6577: INTO v_req_id
6578: FROM DUAL;
6579:
6580: -- Print the request ID to FND Log
6581: FEM_ENGINES_PKG.Tech_Message
6582: (p_severity => pc_log_level_statement,
6583: p_module => v_module,
6584: p_app_name => 'FEM',

Line 7031: -- Log the function exit time to FND_LOG (successful completion)

7027: -- ----------------------------
7028: -- 7. Exit with success/warning
7029: -- ----------------------------
7030:
7031: -- Log the function exit time to FND_LOG (successful completion)
7032: FEM_ENGINES_PKG.Tech_Message
7033: (p_severity => pc_log_level_procedure,
7034: p_module => v_module,
7035: p_app_name => 'FEM',

Line 7092: -- Log the function exit time to FND_LOG (with error)

7088: p_value2 => v_cal_per_name,
7089: p_token3 => 'DIM_NAME',
7090: p_value3 => v_dim_name);
7091:
7092: -- Log the function exit time to FND_LOG (with error)
7093: FEM_ENGINES_PKG.Tech_Message
7094: (p_severity => pc_log_level_procedure,
7095: p_module => v_module,
7096: p_app_name => 'FEM',

Line 7127: -- Log the function exit time to FND_LOG (with error)

7123: END LOOP;
7124:
7125: END IF; -- IF v_msg_count = 1
7126:
7127: -- Log the function exit time to FND_LOG (with error)
7128: FEM_ENGINES_PKG.Tech_Message
7129: (p_severity => pc_log_level_procedure,
7130: p_module => v_module,
7131: p_app_name => 'FEM',

Line 7146: -- FND_LOG with the "unexpected exception" severity level.

7142: pv_sqlerrm := SQLERRM;
7143: pv_callstack := dbms_utility.format_call_stack;
7144:
7145: -- Log the call stack and the Oracle error message to
7146: -- FND_LOG with the "unexpected exception" severity level.
7147: FEM_ENGINES_PKG.Tech_Message
7148: (p_severity => pc_log_level_unexpected,
7149: p_module => v_module,
7150: p_msg_text => pv_sqlerrm);

Line 7161: -- Log the function exit time to FND_LOG (with error)

7157: FEM_ENGINES_PKG.User_Message
7158: (p_app_name => 'FEM',
7159: p_msg_text => pv_sqlerrm);
7160:
7161: -- Log the function exit time to FND_LOG (with error)
7162: FEM_ENGINES_PKG.Tech_Message
7163: (p_severity => pc_log_level_procedure,
7164: p_module => v_module,
7165: p_app_name => 'FEM',

Line 7245: -- Log the function entry time to FND_LOG

7241: BEGIN
7242: v_module := 'fem.plsql.fem_gl_post_process_pkg.final_ogl_process_logging';
7243: v_func_name := 'FEM_GL_POST_PROCESS_PKG.Final_OGL_Process_Logging';
7244:
7245: -- Log the function entry time to FND_LOG
7246: FEM_ENGINES_PKG.Tech_Message
7247: (p_severity => pc_log_level_procedure,
7248: p_module => v_module,
7249: p_app_name => 'FEM',

Line 7256: -- List the IN parameters to FND_LOG

7252: p_value1 => v_func_name,
7253: p_token2 => 'TIME',
7254: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
7255:
7256: -- List the IN parameters to FND_LOG
7257: FEM_ENGINES_PKG.Tech_Message
7258: (p_severity => pc_log_level_statement,
7259: p_module => v_module,
7260: p_app_name => 'FEM',

Line 7685: -- Log the function exit time to FND_LOG (successful completion)

7681: FEM_ENGINES_PKG.User_Message
7682: (P_APP_NAME => 'FEM',
7683: P_MSG_NAME => p_final_message_name);
7684:
7685: -- Log the function exit time to FND_LOG (successful completion)
7686: FEM_ENGINES_PKG.Tech_Message
7687: (p_severity => pc_log_level_procedure,
7688: p_module => v_module,
7689: p_app_name => 'FEM',

Line 7703: -- FND_LOG with the "unexpected exception" severity level.

7699: pv_sqlerrm := SQLERRM;
7700: pv_callstack := dbms_utility.format_call_stack;
7701:
7702: -- Log the call stack and the Oracle error message to
7703: -- FND_LOG with the "unexpected exception" severity level.
7704: FEM_ENGINES_PKG.Tech_Message
7705: (p_severity => pc_log_level_unexpected,
7706: p_module => v_module,
7707: p_msg_text => pv_sqlerrm);

Line 7718: -- Log the function exit time to FND_LOG (with error)

7714: FEM_ENGINES_PKG.User_Message
7715: (p_app_name => 'FEM',
7716: p_msg_text => pv_sqlerrm);
7717:
7718: -- Log the function exit time to FND_LOG (with error)
7719: FEM_ENGINES_PKG.Tech_Message
7720: (p_severity => pc_log_level_procedure,
7721: p_module => v_module,
7722: p_app_name => 'FEM',