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 FND_LOG

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

20: pv_program_id NUMBER := FND_GLOBAL.Conc_Program_Id;
21: pv_program_app_id NUMBER := FND_GLOBAL.Prog_Appl_ID;
22: pv_concurrent_status BOOLEAN;
23:
24: pc_log_level_statement CONSTANT NUMBER := fnd_log.level_statement;
25: pc_log_level_procedure CONSTANT NUMBER := fnd_log.level_procedure;
26: pc_log_level_event CONSTANT NUMBER := fnd_log.level_event;
27: pc_log_level_exception CONSTANT NUMBER := fnd_log.level_exception;
28: pc_log_level_error CONSTANT NUMBER := fnd_log.level_error;

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

21: pv_program_app_id NUMBER := FND_GLOBAL.Prog_Appl_ID;
22: pv_concurrent_status BOOLEAN;
23:
24: pc_log_level_statement CONSTANT NUMBER := fnd_log.level_statement;
25: pc_log_level_procedure CONSTANT NUMBER := fnd_log.level_procedure;
26: pc_log_level_event CONSTANT NUMBER := fnd_log.level_event;
27: pc_log_level_exception CONSTANT NUMBER := fnd_log.level_exception;
28: pc_log_level_error CONSTANT NUMBER := fnd_log.level_error;
29: pc_log_level_unexpected CONSTANT NUMBER := fnd_log.level_unexpected;

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

22: pv_concurrent_status BOOLEAN;
23:
24: pc_log_level_statement CONSTANT NUMBER := fnd_log.level_statement;
25: pc_log_level_procedure CONSTANT NUMBER := fnd_log.level_procedure;
26: pc_log_level_event CONSTANT NUMBER := fnd_log.level_event;
27: pc_log_level_exception CONSTANT NUMBER := fnd_log.level_exception;
28: pc_log_level_error CONSTANT NUMBER := fnd_log.level_error;
29: pc_log_level_unexpected CONSTANT NUMBER := fnd_log.level_unexpected;
30:

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

23:
24: pc_log_level_statement CONSTANT NUMBER := fnd_log.level_statement;
25: pc_log_level_procedure CONSTANT NUMBER := fnd_log.level_procedure;
26: pc_log_level_event CONSTANT NUMBER := fnd_log.level_event;
27: pc_log_level_exception CONSTANT NUMBER := fnd_log.level_exception;
28: pc_log_level_error CONSTANT NUMBER := fnd_log.level_error;
29: pc_log_level_unexpected CONSTANT NUMBER := fnd_log.level_unexpected;
30:
31: -- Bug 4309949. Hardcode folder to the "Default" folder

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

24: pc_log_level_statement CONSTANT NUMBER := fnd_log.level_statement;
25: pc_log_level_procedure CONSTANT NUMBER := fnd_log.level_procedure;
26: pc_log_level_event CONSTANT NUMBER := fnd_log.level_event;
27: pc_log_level_exception CONSTANT NUMBER := fnd_log.level_exception;
28: pc_log_level_error CONSTANT NUMBER := fnd_log.level_error;
29: pc_log_level_unexpected CONSTANT NUMBER := fnd_log.level_unexpected;
30:
31: -- Bug 4309949. Hardcode folder to the "Default" folder
32: pc_undo_folder_id CONSTANT NUMBER := 1100;

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

25: pc_log_level_procedure CONSTANT NUMBER := fnd_log.level_procedure;
26: pc_log_level_event CONSTANT NUMBER := fnd_log.level_event;
27: pc_log_level_exception CONSTANT NUMBER := fnd_log.level_exception;
28: pc_log_level_error CONSTANT NUMBER := fnd_log.level_error;
29: pc_log_level_unexpected CONSTANT NUMBER := fnd_log.level_unexpected;
30:
31: -- Bug 4309949. Hardcode folder to the "Default" folder
32: pc_undo_folder_id CONSTANT NUMBER := 1100;
33:

Line 266: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

262: -- p_request_id - Request ID of the rule execution being removed
263: -- p_object_id - Object ID of the rule execution being removed
264: -- ============================================================================
265:
266: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
267: 'fem.plsql.fem_ud_pkg.raise_undo_business_event';
268: C_API_NAME CONSTANT VARCHAR2(30) := 'Raise_Undo_Business_Event';
269: v_calendar_id NUMBER;
270: v_cal_period_id NUMBER;

Line 289: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

285: v_display_flag FEM_PL_OBJECT_EXECUTIONS.display_flag%TYPE;
286:
287: BEGIN
288:
289: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
290: FEM_ENGINES_PKG.TECH_MESSAGE(
291: p_severity => FND_LOG.level_procedure,
292: p_module => C_MODULE,
293: p_msg_text => 'Begin Procedure');

Line 291: p_severity => FND_LOG.level_procedure,

287: BEGIN
288:
289: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
290: FEM_ENGINES_PKG.TECH_MESSAGE(
291: p_severity => FND_LOG.level_procedure,
292: p_module => C_MODULE,
293: p_msg_text => 'Begin Procedure');
294: END IF;
295:

Line 296: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

292: p_module => C_MODULE,
293: p_msg_text => 'Begin Procedure');
294: END IF;
295:
296: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
297: FEM_ENGINES_PKG.TECH_MESSAGE(
298: p_severity => FND_LOG.level_statement,
299: p_module => C_MODULE,
300: p_msg_text => 'p_event_name = '||p_event_name);

Line 298: p_severity => FND_LOG.level_statement,

294: END IF;
295:
296: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
297: FEM_ENGINES_PKG.TECH_MESSAGE(
298: p_severity => FND_LOG.level_statement,
299: p_module => C_MODULE,
300: p_msg_text => 'p_event_name = '||p_event_name);
301: FEM_ENGINES_PKG.TECH_MESSAGE(
302: p_severity => FND_LOG.level_statement,

Line 302: p_severity => FND_LOG.level_statement,

298: p_severity => FND_LOG.level_statement,
299: p_module => C_MODULE,
300: p_msg_text => 'p_event_name = '||p_event_name);
301: FEM_ENGINES_PKG.TECH_MESSAGE(
302: p_severity => FND_LOG.level_statement,
303: p_module => C_MODULE,
304: p_msg_text => 'p_request_id = '||to_char(p_request_id));
305: FEM_ENGINES_PKG.TECH_MESSAGE(
306: p_severity => FND_LOG.level_statement,

Line 306: p_severity => FND_LOG.level_statement,

302: p_severity => FND_LOG.level_statement,
303: p_module => C_MODULE,
304: p_msg_text => 'p_request_id = '||to_char(p_request_id));
305: FEM_ENGINES_PKG.TECH_MESSAGE(
306: p_severity => FND_LOG.level_statement,
307: p_module => C_MODULE,
308: p_msg_text => 'p_object_id = '||to_char(p_object_id));
309: FEM_ENGINES_PKG.TECH_MESSAGE(
310: p_severity => FND_LOG.level_statement,

Line 310: p_severity => FND_LOG.level_statement,

306: p_severity => FND_LOG.level_statement,
307: p_module => C_MODULE,
308: p_msg_text => 'p_object_id = '||to_char(p_object_id));
309: FEM_ENGINES_PKG.TECH_MESSAGE(
310: p_severity => FND_LOG.level_statement,
311: p_module => C_MODULE,
312: p_msg_text => 'p_status = '||p_status);
313: END IF;
314:

Line 552: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

548: );
549:
550: COMMIT;
551:
552: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
553: FEM_ENGINES_PKG.TECH_MESSAGE(
554: p_severity => FND_LOG.level_procedure,
555: p_module => C_MODULE,
556: p_msg_text => 'End Procedure');

Line 554: p_severity => FND_LOG.level_procedure,

550: COMMIT;
551:
552: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
553: FEM_ENGINES_PKG.TECH_MESSAGE(
554: p_severity => FND_LOG.level_procedure,
555: p_module => C_MODULE,
556: p_msg_text => 'End Procedure');
557: END IF;
558: --

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

781: -- Unexpected exceptions
782: x_return_status := pc_ret_sts_unexp_error;
783:
784: -- Log the call stack and the Oracle error message to
785: -- FND_LOG with the "unexpected exception" severity level.
786:
787: FEM_ENGINES_PKG.Tech_Message
788: (p_severity => pc_log_level_unexpected,
789: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,

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

986: -- Unexpected exceptions
987: x_return_status := pc_ret_sts_unexp_error;
988:
989: -- Log the call stack and the Oracle error message to
990: -- FND_LOG with the "unexpected exception" severity level.
991:
992: FEM_ENGINES_PKG.Tech_Message
993: (p_severity => pc_log_level_unexpected,
994: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,

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

1200: -- Unexpected exceptions
1201: x_return_status := pc_ret_sts_unexp_error;
1202:
1203: -- Log the call stack and the Oracle error message to
1204: -- FND_LOG with the "unexpected exception" severity level.
1205:
1206: FEM_ENGINES_PKG.Tech_Message
1207: (p_severity => pc_log_level_unexpected,
1208: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,

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

1593: -- Unexpected exceptions
1594: x_return_status := pc_ret_sts_unexp_error;
1595:
1596: -- Log the call stack and the Oracle error message to
1597: -- FND_LOG with the "unexpected exception" severity level.
1598:
1599: FEM_ENGINES_PKG.Tech_Message
1600: (p_severity => pc_log_level_unexpected,
1601: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,

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

1822: -- Unexpected exceptions
1823: x_return_status := pc_ret_sts_unexp_error;
1824:
1825: -- Log the call stack and the Oracle error message to
1826: -- FND_LOG with the "unexpected exception" severity level.
1827:
1828: FEM_ENGINES_PKG.Tech_Message
1829: (p_severity => pc_log_level_unexpected,
1830: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,

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

2084: -- Unexpected exceptions
2085: x_return_status := pc_ret_sts_unexp_error;
2086:
2087: -- Log the call stack and the Oracle error message to
2088: -- FND_LOG with the "unexpected exception" severity level.
2089:
2090: FEM_ENGINES_PKG.Tech_Message
2091: (p_severity => pc_log_level_unexpected,
2092: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,

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

2288: EXCEPTION
2289: WHEN OTHERS THEN
2290: -- Unexpected exceptions
2291: -- Log the call stack and the Oracle error message to
2292: -- FND_LOG with the "unexpected exception" severity level.
2293:
2294: FEM_ENGINES_PKG.Tech_Message
2295: (p_severity => pc_log_level_unexpected,
2296: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,

Line 2665: IF (pc_log_level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2661: -- candidate. Only perform this in the Preview mode.
2662: -- (Added to satisfy bug 5103063)
2663: -- ============================================================================
2664: IF p_preview_flag = 'Y' THEN
2665: IF (pc_log_level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2666: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
2667: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
2668: p_msg_text => 'STEP 3.5: Generate "REPEAT" dependents.');
2669: END IF;

Line 2688: IF (pc_log_level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2684: WHEN DUP_VAL_ON_INDEX THEN NULL;
2685: END;
2686: END LOOP;
2687:
2688: IF (pc_log_level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2689: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
2690: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
2691: p_msg_text => 'STEP 3.5: Number of REPEAT dependencies found: '||v_count);
2692: END IF;

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

2932: -- Unexpected exceptions
2933: x_return_status := pc_ret_sts_unexp_error;
2934:
2935: -- Log the call stack and the Oracle error message to
2936: -- FND_LOG with the "unexpected exception" severity level.
2937:
2938: FEM_ENGINES_PKG.Tech_Message
2939: (p_severity => pc_log_level_unexpected,
2940: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,

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

3390: -- Unexpected exceptions
3391: x_return_status := pc_ret_sts_unexp_error;
3392:
3393: -- Log the call stack and the Oracle error message to
3394: -- FND_LOG with the "unexpected exception" severity level.
3395:
3396: FEM_ENGINES_PKG.Tech_Message
3397: (p_severity => pc_log_level_unexpected,
3398: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,

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

4274: -- Unexpected exceptions
4275: x_return_status := pc_ret_sts_unexp_error;
4276:
4277: -- Log the call stack and the Oracle error message to
4278: -- FND_LOG with the "unexpected exception" severity level.
4279:
4280: FEM_ENGINES_PKG.Tech_Message
4281: (p_severity => pc_log_level_unexpected,
4282: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,

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

4472: WHEN OTHERS THEN
4473: -- Unexpected exceptions
4474:
4475: -- Log the call stack and the Oracle error message to
4476: -- FND_LOG with the "unexpected exception" severity level.
4477:
4478: FEM_ENGINES_PKG.Tech_Message
4479: (p_severity => pc_log_level_unexpected,
4480: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,

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

5094:
5095: WHEN OTHERS THEN
5096: -- Unexpected exceptions
5097: -- Log the call stack and the Oracle error message to
5098: -- FND_LOG with the "unexpected exception" severity level.
5099:
5100: FEM_ENGINES_PKG.Tech_Message
5101: (p_severity => pc_log_level_unexpected,
5102: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,

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

5225: EXCEPTION
5226: WHEN OTHERS THEN
5227: -- Unexpected exceptions
5228: -- Log the call stack and the Oracle error message to
5229: -- FND_LOG with the "unexpected exception" severity level.
5230:
5231: FEM_ENGINES_PKG.Tech_Message
5232: (p_severity => pc_log_level_unexpected,
5233: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,

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

5603:
5604: WHEN OTHERS THEN
5605: -- Unexpected exceptions
5606: -- Log the call stack and the Oracle error message to
5607: -- FND_LOG with the "unexpected exception" severity level.
5608:
5609: FEM_ENGINES_PKG.Tech_Message
5610: (p_severity => pc_log_level_unexpected,
5611: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,

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

6062:
6063: WHEN OTHERS THEN
6064: -- Unexpected exceptions
6065: -- Log the call stack and the Oracle error message to
6066: -- FND_LOG with the "unexpected exception" severity level.
6067:
6068: FEM_ENGINES_PKG.Tech_Message
6069: (p_severity => pc_log_level_unexpected,
6070: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,

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

6437:
6438: WHEN OTHERS THEN
6439: -- Unexpected exceptions
6440: -- Log the call stack and the Oracle error message to
6441: -- FND_LOG with the "unexpected exception" severity level.
6442: x_return_status := pc_ret_sts_unexp_error;
6443:
6444: FEM_ENGINES_PKG.Tech_Message
6445: (p_severity => pc_log_level_unexpected,

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

6579: -- Unexpected exceptions
6580: x_return_status := pc_ret_sts_unexp_error;
6581:
6582: -- Log the call stack and the Oracle error message to
6583: -- FND_LOG with the "unexpected exception" severity level.
6584:
6585: FEM_ENGINES_PKG.Tech_Message
6586: (p_severity => pc_log_level_unexpected,
6587: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,

Line 6650: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

6646: -- created the existing FEM Balances data are chained or are still running.
6647: -- Otherwise, set x_return_status to 'S' (Success) after deleting the
6648: -- balances and all related Process Locks and Data Locations related data.
6649: -- =========================================================================
6650: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
6651: 'fem.plsql.fem_ud_pkg.delete_balances';
6652: C_API_NAME CONSTANT VARCHAR2(30) := 'Delete_Balances';
6653: C_API_VERSION CONSTANT NUMBER := 1.0;
6654: C_FEM_BALANCES CONSTANT VARCHAR2(30) := 'FEM_BALANCES';

Line 6693: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

6689: --
6690: -- Standard Start of API savepoint
6691: SAVEPOINT delete_balances_pub;
6692:
6693: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6694: FEM_ENGINES_PKG.TECH_MESSAGE(
6695: p_severity => FND_LOG.level_procedure,
6696: p_module => C_MODULE,
6697: p_msg_text => 'Begin Procedure');

Line 6695: p_severity => FND_LOG.level_procedure,

6691: SAVEPOINT delete_balances_pub;
6692:
6693: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6694: FEM_ENGINES_PKG.TECH_MESSAGE(
6695: p_severity => FND_LOG.level_procedure,
6696: p_module => C_MODULE,
6697: p_msg_text => 'Begin Procedure');
6698: END IF;
6699:

Line 6709: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

6705: p_api_version,
6706: C_API_NAME,
6707: pc_pkg_name)
6708: THEN
6709: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6710: FEM_ENGINES_PKG.TECH_MESSAGE(
6711: p_severity => FND_LOG.level_unexpected,
6712: p_module => C_MODULE,
6713: p_msg_text => 'INTERNAL ERROR: API Version ('||C_API_VERSION||') not compatible with '

Line 6711: p_severity => FND_LOG.level_unexpected,

6707: pc_pkg_name)
6708: THEN
6709: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6710: FEM_ENGINES_PKG.TECH_MESSAGE(
6711: p_severity => FND_LOG.level_unexpected,
6712: p_module => C_MODULE,
6713: p_msg_text => 'INTERNAL ERROR: API Version ('||C_API_VERSION||') not compatible with '
6714: ||'passed in version ('||p_api_version||')');
6715: END IF;

Line 6727: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

6723: FROM fem_object_catalog_b
6724: WHERE object_id = p_object_id;
6725:
6726: IF nvl(v_object_type,'BADTYPE') <> 'TP_PROCESS_RULE' THEN
6727: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6728: FEM_ENGINES_PKG.TECH_MESSAGE(
6729: p_severity => FND_LOG.level_unexpected,
6730: p_module => C_MODULE,
6731: p_msg_text => 'INTERNAL ERROR: p_object_id ('||to_char(p_object_id)

Line 6729: p_severity => FND_LOG.level_unexpected,

6725:
6726: IF nvl(v_object_type,'BADTYPE') <> 'TP_PROCESS_RULE' THEN
6727: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6728: FEM_ENGINES_PKG.TECH_MESSAGE(
6729: p_severity => FND_LOG.level_unexpected,
6730: p_module => C_MODULE,
6731: p_msg_text => 'INTERNAL ERROR: p_object_id ('||to_char(p_object_id)
6732: ||') belongs to '||v_object_type||'. This API only '
6733: ||'operates on TP_PROCESS_RULE object types.');

Line 6739: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

6735: RAISE e_unexp_error;
6736: END IF;
6737:
6738: -- Log procedure param values
6739: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6740: FEM_ENGINES_PKG.TECH_MESSAGE(
6741: p_severity => FND_LOG.level_statement,
6742: p_module => C_MODULE,
6743: p_msg_text => 'p_current_request_id = '||to_char(p_current_request_id));

Line 6741: p_severity => FND_LOG.level_statement,

6737:
6738: -- Log procedure param values
6739: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6740: FEM_ENGINES_PKG.TECH_MESSAGE(
6741: p_severity => FND_LOG.level_statement,
6742: p_module => C_MODULE,
6743: p_msg_text => 'p_current_request_id = '||to_char(p_current_request_id));
6744: FEM_ENGINES_PKG.TECH_MESSAGE(
6745: p_severity => FND_LOG.level_statement,

Line 6745: p_severity => FND_LOG.level_statement,

6741: p_severity => FND_LOG.level_statement,
6742: p_module => C_MODULE,
6743: p_msg_text => 'p_current_request_id = '||to_char(p_current_request_id));
6744: FEM_ENGINES_PKG.TECH_MESSAGE(
6745: p_severity => FND_LOG.level_statement,
6746: p_module => C_MODULE,
6747: p_msg_text => 'p_object_id = '||to_char(p_object_id));
6748: FEM_ENGINES_PKG.TECH_MESSAGE(
6749: p_severity => FND_LOG.level_statement,

Line 6749: p_severity => FND_LOG.level_statement,

6745: p_severity => FND_LOG.level_statement,
6746: p_module => C_MODULE,
6747: p_msg_text => 'p_object_id = '||to_char(p_object_id));
6748: FEM_ENGINES_PKG.TECH_MESSAGE(
6749: p_severity => FND_LOG.level_statement,
6750: p_module => C_MODULE,
6751: p_msg_text => 'p_cal_period_id = '||to_char(p_cal_period_id));
6752: FEM_ENGINES_PKG.TECH_MESSAGE(
6753: p_severity => FND_LOG.level_statement,

Line 6753: p_severity => FND_LOG.level_statement,

6749: p_severity => FND_LOG.level_statement,
6750: p_module => C_MODULE,
6751: p_msg_text => 'p_cal_period_id = '||to_char(p_cal_period_id));
6752: FEM_ENGINES_PKG.TECH_MESSAGE(
6753: p_severity => FND_LOG.level_statement,
6754: p_module => C_MODULE,
6755: p_msg_text => 'p_ledger_id = '||to_char(p_ledger_id));
6756: FEM_ENGINES_PKG.TECH_MESSAGE(
6757: p_severity => FND_LOG.level_statement,

Line 6757: p_severity => FND_LOG.level_statement,

6753: p_severity => FND_LOG.level_statement,
6754: p_module => C_MODULE,
6755: p_msg_text => 'p_ledger_id = '||to_char(p_ledger_id));
6756: FEM_ENGINES_PKG.TECH_MESSAGE(
6757: p_severity => FND_LOG.level_statement,
6758: p_module => C_MODULE,
6759: p_msg_text => 'p_dataset_code = '||to_char(p_dataset_code));
6760: END IF;
6761:

Line 6820: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

6816: BEGIN
6817: EXECUTE IMMEDIATE v_sql;
6818: EXCEPTION
6819: WHEN others THEN
6820: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6821: FEM_ENGINES_PKG.TECH_MESSAGE(
6822: p_severity => FND_LOG.level_unexpected,
6823: p_module => C_MODULE,
6824: p_msg_text => 'The following SQL failed unexpected: '||v_sql);

Line 6822: p_severity => FND_LOG.level_unexpected,

6818: EXCEPTION
6819: WHEN others THEN
6820: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6821: FEM_ENGINES_PKG.TECH_MESSAGE(
6822: p_severity => FND_LOG.level_unexpected,
6823: p_module => C_MODULE,
6824: p_msg_text => 'The following SQL failed unexpected: '||v_sql);
6825: END IF;
6826: RAISE E_UNEXP_ERROR;

Line 6870: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

6866: IF (p_commit = FND_API.G_TRUE) THEN
6867: COMMIT;
6868: END IF;
6869:
6870: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6871: FEM_ENGINES_PKG.TECH_MESSAGE(
6872: p_severity => FND_LOG.level_procedure,
6873: p_module => C_MODULE,
6874: p_msg_text => 'End Procedure');

Line 6872: p_severity => FND_LOG.level_procedure,

6868: END IF;
6869:
6870: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6871: FEM_ENGINES_PKG.TECH_MESSAGE(
6872: p_severity => FND_LOG.level_procedure,
6873: p_module => C_MODULE,
6874: p_msg_text => 'End Procedure');
6875: END IF;
6876: --

Line 6928: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

6924: ROLLBACK TO delete_balances_pub;
6925: WHEN others THEN
6926: ROLLBACK TO delete_balances_pub;
6927:
6928: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6929: FEM_ENGINES_PKG.TECH_MESSAGE(
6930: p_severity => FND_LOG.level_unexpected,
6931: p_module => C_MODULE,
6932: p_msg_text => 'Unexpected error: '||SQLERRM);

Line 6930: p_severity => FND_LOG.level_unexpected,

6926: ROLLBACK TO delete_balances_pub;
6927:
6928: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6929: FEM_ENGINES_PKG.TECH_MESSAGE(
6930: p_severity => FND_LOG.level_unexpected,
6931: p_module => C_MODULE,
6932: p_msg_text => 'Unexpected error: '||SQLERRM);
6933: END IF;
6934: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 6934: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

6930: p_severity => FND_LOG.level_unexpected,
6931: p_module => C_MODULE,
6932: p_msg_text => 'Unexpected error: '||SQLERRM);
6933: END IF;
6934: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6935: FEM_ENGINES_PKG.TECH_MESSAGE(
6936: p_severity => FND_LOG.level_procedure,
6937: p_module => C_MODULE,
6938: p_msg_text => 'End Procedure');

Line 6936: p_severity => FND_LOG.level_procedure,

6932: p_msg_text => 'Unexpected error: '||SQLERRM);
6933: END IF;
6934: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6935: FEM_ENGINES_PKG.TECH_MESSAGE(
6936: p_severity => FND_LOG.level_procedure,
6937: p_module => C_MODULE,
6938: p_msg_text => 'End Procedure');
6939: END IF;
6940: x_return_status := pc_ret_sts_unexp_error;

Line 6978: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

6974: -- Set x_return_status to 'E' (Error) if the execution is still running.
6975: -- Otherwise, set x_return_status to 'S' (Success) after deleting
6976: -- all Process Locks data.
6977: -- =========================================================================
6978: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
6979: 'fem.plsql.fem_ud_pkg.remove_process_locks';
6980: C_API_NAME CONSTANT VARCHAR2(30) := 'Remove_Process_Locks';
6981: C_API_VERSION CONSTANT NUMBER := 1.0;
6982: --

Line 7000: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

6996: --
6997: -- Standard Start of API savepoint
6998: SAVEPOINT remove_process_locks_pub;
6999:
7000: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7001: FEM_ENGINES_PKG.TECH_MESSAGE(
7002: p_severity => FND_LOG.level_procedure,
7003: p_module => C_MODULE,
7004: p_msg_text => 'Begin Procedure');

Line 7002: p_severity => FND_LOG.level_procedure,

6998: SAVEPOINT remove_process_locks_pub;
6999:
7000: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7001: FEM_ENGINES_PKG.TECH_MESSAGE(
7002: p_severity => FND_LOG.level_procedure,
7003: p_module => C_MODULE,
7004: p_msg_text => 'Begin Procedure');
7005: END IF;
7006:

Line 7016: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

7012: p_api_version,
7013: C_API_NAME,
7014: pc_pkg_name)
7015: THEN
7016: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7017: FEM_ENGINES_PKG.TECH_MESSAGE(
7018: p_severity => FND_LOG.level_unexpected,
7019: p_module => C_MODULE,
7020: p_msg_text => 'INTERNAL ERROR: API Version ('||C_API_VERSION

Line 7018: p_severity => FND_LOG.level_unexpected,

7014: pc_pkg_name)
7015: THEN
7016: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7017: FEM_ENGINES_PKG.TECH_MESSAGE(
7018: p_severity => FND_LOG.level_unexpected,
7019: p_module => C_MODULE,
7020: p_msg_text => 'INTERNAL ERROR: API Version ('||C_API_VERSION
7021: ||') not compatible with '
7022: ||'passed in version ('||p_api_version||')');

Line 7033: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

7029: FND_MSG_PUB.Initialize;
7030: END IF;
7031:
7032: -- Log procedure param values
7033: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7034: FEM_ENGINES_PKG.TECH_MESSAGE(
7035: p_severity => FND_LOG.level_statement,
7036: p_module => C_MODULE,
7037: p_msg_text => 'p_request_id = '||to_char(p_request_id));

Line 7035: p_severity => FND_LOG.level_statement,

7031:
7032: -- Log procedure param values
7033: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7034: FEM_ENGINES_PKG.TECH_MESSAGE(
7035: p_severity => FND_LOG.level_statement,
7036: p_module => C_MODULE,
7037: p_msg_text => 'p_request_id = '||to_char(p_request_id));
7038: FEM_ENGINES_PKG.TECH_MESSAGE(
7039: p_severity => FND_LOG.level_statement,

Line 7039: p_severity => FND_LOG.level_statement,

7035: p_severity => FND_LOG.level_statement,
7036: p_module => C_MODULE,
7037: p_msg_text => 'p_request_id = '||to_char(p_request_id));
7038: FEM_ENGINES_PKG.TECH_MESSAGE(
7039: p_severity => FND_LOG.level_statement,
7040: p_module => C_MODULE,
7041: p_msg_text => 'p_object_id = '||to_char(p_object_id));
7042: END IF;
7043:

Line 7053: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

7049: WHERE oc.object_id = p_object_id
7050: AND oc.object_type_code = ot.object_type_code;
7051:
7052: IF nvl(v_undo_flag,'XX') <> 'N' THEN
7053: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7054: FEM_ENGINES_PKG.TECH_MESSAGE(
7055: p_severity => FND_LOG.level_unexpected,
7056: p_module => C_MODULE,
7057: p_msg_text => 'INTERNAL ERROR: p_object_id ('||to_char(p_object_id)

Line 7055: p_severity => FND_LOG.level_unexpected,

7051:
7052: IF nvl(v_undo_flag,'XX') <> 'N' THEN
7053: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7054: FEM_ENGINES_PKG.TECH_MESSAGE(
7055: p_severity => FND_LOG.level_unexpected,
7056: p_module => C_MODULE,
7057: p_msg_text => 'INTERNAL ERROR: p_object_id ('||to_char(p_object_id)
7058: ||') belongs to a rule type where its Undo Flag'
7059: ||' attribute is set to: '||v_undo_flag

Line 7075: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

7071: WHERE object_id = p_object_id
7072: AND request_id = p_request_id;
7073:
7074: IF v_count > 0 THEN
7075: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7076: FEM_ENGINES_PKG.TECH_MESSAGE(
7077: p_severity => FND_LOG.level_unexpected,
7078: p_module => C_MODULE,
7079: p_msg_text => 'INTERNAL ERROR: p_object_id ('||to_char(p_object_id)

Line 7077: p_severity => FND_LOG.level_unexpected,

7073:
7074: IF v_count > 0 THEN
7075: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7076: FEM_ENGINES_PKG.TECH_MESSAGE(
7077: p_severity => FND_LOG.level_unexpected,
7078: p_module => C_MODULE,
7079: p_msg_text => 'INTERNAL ERROR: p_object_id ('||to_char(p_object_id)
7080: ||') registered this many tables: '||v_count
7081: ||'. This API can only process against rules that do'

Line 7099: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

7095: p_object_id => p_object_id,
7096: x_exec_status_code => v_exec_status_code);
7097:
7098: IF x_return_status <> pc_ret_sts_success THEN
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'

Line 7101: p_severity => FND_LOG.level_unexpected,

7097:
7098: IF x_return_status <> pc_ret_sts_success THEN
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;

Line 7124: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

7120: p_request_id => p_request_id,
7121: p_object_id => p_object_id);
7122:
7123: IF x_return_status <> pc_ret_sts_success THEN
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'

Line 7126: p_severity => FND_LOG.level_unexpected,

7122:
7123: IF x_return_status <> pc_ret_sts_success THEN
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;

Line 7141: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

7137: IF (p_commit = FND_API.G_TRUE) THEN
7138: COMMIT;
7139: END IF;
7140:
7141: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7142: FEM_ENGINES_PKG.TECH_MESSAGE(
7143: p_severity => FND_LOG.level_procedure,
7144: p_module => C_MODULE,
7145: p_msg_text => 'End Procedure');

Line 7143: p_severity => FND_LOG.level_procedure,

7139: END IF;
7140:
7141: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7142: FEM_ENGINES_PKG.TECH_MESSAGE(
7143: p_severity => FND_LOG.level_procedure,
7144: p_module => C_MODULE,
7145: p_msg_text => 'End Procedure');
7146: END IF;
7147: --

Line 7175: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

7171: ROLLBACK TO remove_process_locks_pub;
7172: WHEN others THEN
7173: ROLLBACK TO remove_process_locks_pub;
7174:
7175: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7176: FEM_ENGINES_PKG.TECH_MESSAGE(
7177: p_severity => FND_LOG.level_unexpected,
7178: p_module => C_MODULE,
7179: p_msg_text => 'Unexpected error: '||SQLERRM);

Line 7177: p_severity => FND_LOG.level_unexpected,

7173: ROLLBACK TO remove_process_locks_pub;
7174:
7175: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7176: FEM_ENGINES_PKG.TECH_MESSAGE(
7177: p_severity => FND_LOG.level_unexpected,
7178: p_module => C_MODULE,
7179: p_msg_text => 'Unexpected error: '||SQLERRM);
7180: END IF;
7181: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 7181: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

7177: p_severity => FND_LOG.level_unexpected,
7178: p_module => C_MODULE,
7179: p_msg_text => 'Unexpected error: '||SQLERRM);
7180: END IF;
7181: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7182: FEM_ENGINES_PKG.TECH_MESSAGE(
7183: p_severity => FND_LOG.level_procedure,
7184: p_module => C_MODULE,
7185: p_msg_text => 'End Procedure');

Line 7183: p_severity => FND_LOG.level_procedure,

7179: p_msg_text => 'Unexpected error: '||SQLERRM);
7180: END IF;
7181: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7182: FEM_ENGINES_PKG.TECH_MESSAGE(
7183: p_severity => FND_LOG.level_procedure,
7184: p_module => C_MODULE,
7185: p_msg_text => 'End Procedure');
7186: END IF;
7187: x_return_status := pc_ret_sts_unexp_error;