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

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

102: p_global_vs_id IN NUMBER)
103: -------------------------------------------------------------------------------
104: IS
105: --
106: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
107: 'fem.plsql.fem_check_dis_mbr_pkg.find_root_rules';
108: --
109: v_return_status VARCHAR2(1);
110: v_msg_count NUMBER;

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

128: AND object_id = Nvl(p_object_id, object_id);
129: --
130: BEGIN
131: --
132: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
133: FEM_ENGINES_PKG.TECH_MESSAGE(
134: p_severity => FND_LOG.level_procedure,
135: p_module => C_MODULE,
136: p_msg_text => 'Begin Procedure');

Line 134: p_severity => FND_LOG.level_procedure,

130: BEGIN
131: --
132: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
133: FEM_ENGINES_PKG.TECH_MESSAGE(
134: p_severity => FND_LOG.level_procedure,
135: p_module => C_MODULE,
136: p_msg_text => 'Begin Procedure');
137: END IF;
138:

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

157: FROM fem_object_catalog_vl
158: WHERE object_id = p_object_id;
159:
160: IF (v_global_vs_id <> p_global_vs_id) THEN
161: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
162: FEM_ENGINES_PKG.TECH_MESSAGE(
163: p_severity => FND_LOG.level_unexpected,
164: p_module => C_MODULE,
165: p_msg_text => 'UNEXP ERROR: For rule name ('

Line 163: p_severity => FND_LOG.level_unexpected,

159:
160: IF (v_global_vs_id <> p_global_vs_id) THEN
161: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
162: FEM_ENGINES_PKG.TECH_MESSAGE(
163: p_severity => FND_LOG.level_unexpected,
164: p_module => C_MODULE,
165: p_msg_text => 'UNEXP ERROR: For rule name ('
166: || v_obj_name||'), its GVSC ('
167: || v_global_vs_id||') does not match the'

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

171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
172: END IF;
173:
174: IF (v_folder_id <> Nvl(p_folder_id, v_folder_id)) THEN
175: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
176: FEM_ENGINES_PKG.TECH_MESSAGE(
177: p_severity => FND_LOG.level_unexpected,
178: p_module => C_MODULE,
179: p_msg_text => 'UNEXP ERROR: For rule name ('

Line 177: p_severity => FND_LOG.level_unexpected,

173:
174: IF (v_folder_id <> Nvl(p_folder_id, v_folder_id)) THEN
175: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
176: FEM_ENGINES_PKG.TECH_MESSAGE(
177: p_severity => FND_LOG.level_unexpected,
178: p_module => C_MODULE,
179: p_msg_text => 'UNEXP ERROR: For rule name ('
180: || v_obj_name||'), its folder id ('
181: || v_folder_id||') does not match the'

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

185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
186: END IF;
187:
188: IF (v_rule_type <> p_rule_type) THEN
189: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
190: FEM_ENGINES_PKG.TECH_MESSAGE(
191: p_severity => FND_LOG.level_unexpected,
192: p_module => C_MODULE,
193: p_msg_text => 'UNEXP ERROR: For rule name ('

Line 191: p_severity => FND_LOG.level_unexpected,

187:
188: IF (v_rule_type <> p_rule_type) THEN
189: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
190: FEM_ENGINES_PKG.TECH_MESSAGE(
191: p_severity => FND_LOG.level_unexpected,
192: p_module => C_MODULE,
193: p_msg_text => 'UNEXP ERROR: For rule name ('
194: || v_obj_name||'), its rule type ('
195: || v_rule_type||') does not match the'

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

220: FEM_ENGINES_PKG.Put_Message(
221: p_app_name => 'FEM',
222: p_msg_name => 'FEM_MISSING_DATASET_GROUP');
223:
224: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
225: FEM_ENGINES_PKG.Tech_Message(
226: p_severity => FND_LOG.level_unexpected,
227: p_module => C_MODULE,
228: p_app_name => 'FEM',

Line 226: p_severity => FND_LOG.level_unexpected,

222: p_msg_name => 'FEM_MISSING_DATASET_GROUP');
223:
224: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
225: FEM_ENGINES_PKG.Tech_Message(
226: p_severity => FND_LOG.level_unexpected,
227: p_module => C_MODULE,
228: p_app_name => 'FEM',
229: p_msg_name => 'FEM_MISSING_DATASET_GROUP');
230: END IF;

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

231:
232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
233: END;
234:
235: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
236: FEM_ENGINES_PKG.TECH_MESSAGE(
237: p_severity => FND_LOG.level_statement,
238: p_module => C_MODULE,
239: p_msg_text => 'v_ds_io_def_id = '||v_ds_io_def_id);

Line 237: p_severity => FND_LOG.level_statement,

233: END;
234:
235: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
236: FEM_ENGINES_PKG.TECH_MESSAGE(
237: p_severity => FND_LOG.level_statement,
238: p_module => C_MODULE,
239: p_msg_text => 'v_ds_io_def_id = '||v_ds_io_def_id);
240: FEM_ENGINES_PKG.TECH_MESSAGE(
241: p_severity => FND_LOG.level_statement,

Line 241: p_severity => FND_LOG.level_statement,

237: p_severity => FND_LOG.level_statement,
238: p_module => C_MODULE,
239: p_msg_text => 'v_ds_io_def_id = '||v_ds_io_def_id);
240: FEM_ENGINES_PKG.TECH_MESSAGE(
241: p_severity => FND_LOG.level_statement,
242: p_module => C_MODULE,
243: p_msg_text => 'v_is_ruleset = '||v_is_rule_set);
244: END IF;
245:

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

259: p_Ledger_ID => p_ledger_id,
260: p_Continue_Process_On_Err_Flg => 'Y',
261: p_Execution_Mode => 'E');
262:
263: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
264: FEM_ENGINES_PKG.TECH_MESSAGE(
265: p_severity => FND_LOG.level_statement,
266: p_module => C_MODULE,
267: p_msg_text => 'FEM_RULE_SET_MANAGER.FEM_Preprocess_RuleSet_PVT'

Line 265: p_severity => FND_LOG.level_statement,

261: p_Execution_Mode => 'E');
262:
263: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
264: FEM_ENGINES_PKG.TECH_MESSAGE(
265: p_severity => FND_LOG.level_statement,
266: p_module => C_MODULE,
267: p_msg_text => 'FEM_RULE_SET_MANAGER.FEM_Preprocess_RuleSet_PVT'
268: ||' returned with status: '||v_return_status);
269: END IF;

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

287: x_msg_data => v_msg_data,
288: p_RuleSet_Object_ID => p_object_id);
289:
290: IF v_return_status <> FND_API.G_RET_STS_SUCCESS THEN
291: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
292: FEM_ENGINES_PKG.TECH_MESSAGE(
293: p_severity => FND_LOG.level_unexpected,
294: p_module => C_MODULE,
295: p_msg_text => 'INTERNAL ERROR: Call to'

Line 293: p_severity => FND_LOG.level_unexpected,

289:
290: IF v_return_status <> FND_API.G_RET_STS_SUCCESS THEN
291: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
292: FEM_ENGINES_PKG.TECH_MESSAGE(
293: p_severity => FND_LOG.level_unexpected,
294: p_module => C_MODULE,
295: p_msg_text => 'INTERNAL ERROR: Call to'
296: ||' FEM_RULE_SET_MANAGER.FEM_DeleteFlatRuleList_PVT'
297: ||' failed with return status: '||v_return_status);

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

303: ELSE -- ELSIF (v_is_ruleset = 'N')
304: -- If ruleset is not provided, find all rules limited by the
305: -- Rule Type, Ledger and Folder parameters.
306: FOR all_root_rules IN c_all_root_rules LOOP
307: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
308: FEM_ENGINES_PKG.TECH_MESSAGE(
309: p_severity => FND_LOG.level_statement,
310: p_module => C_MODULE,
311: p_msg_text => 'all_root_rules.object_id = '||all_root_rules.object_id);

Line 309: p_severity => FND_LOG.level_statement,

305: -- Rule Type, Ledger and Folder parameters.
306: FOR all_root_rules IN c_all_root_rules LOOP
307: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
308: FEM_ENGINES_PKG.TECH_MESSAGE(
309: p_severity => FND_LOG.level_statement,
310: p_module => C_MODULE,
311: p_msg_text => 'all_root_rules.object_id = '||all_root_rules.object_id);
312: END IF;
313:

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

322: p_Rule_Effective_Date => FND_DATE.Date_To_Canonical(p_effective_date),
323: p_Reference_Period_ID => NULL,
324: p_Ledger_ID => p_ledger_id);
325:
326: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
327: FEM_ENGINES_PKG.TECH_MESSAGE(
328: p_severity => FND_LOG.level_statement,
329: p_module => C_MODULE,
330: p_msg_text => 'FEM_RULE_SET_MANAGER.Validate_Rule_Public'

Line 328: p_severity => FND_LOG.level_statement,

324: p_Ledger_ID => p_ledger_id);
325:
326: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
327: FEM_ENGINES_PKG.TECH_MESSAGE(
328: p_severity => FND_LOG.level_statement,
329: p_module => C_MODULE,
330: p_msg_text => 'FEM_RULE_SET_MANAGER.Validate_Rule_Public'
331: ||' returned with status: '||v_return_status);
332: END IF;

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

345: VALUES(v_obj_def_id);
346: ELSE
347: -- If the rule passed validation, this routine should never error.
348: -- If it does, raise unexp error.
349: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
350: FEM_ENGINES_PKG.TECH_MESSAGE(
351: p_severity => FND_LOG.level_unexpected,
352: p_module => C_MODULE,
353: p_msg_text => 'UNEXPECTED ERROR: Call to'

Line 351: p_severity => FND_LOG.level_unexpected,

347: -- If the rule passed validation, this routine should never error.
348: -- If it does, raise unexp error.
349: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
350: FEM_ENGINES_PKG.TECH_MESSAGE(
351: p_severity => FND_LOG.level_unexpected,
352: p_module => C_MODULE,
353: p_msg_text => 'UNEXPECTED ERROR: Call to'
354: ||' FEM_RULE_SET_MANAGER.Get_ValidDefinition_Pub'
355: ||' failed with x_err_msg: '||v_msg_data);

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

366: END LOOP; -- c_all_root_rules
367:
368: END IF; -- IF (v_is_ruleset = 'Y')
369:
370: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
371: FEM_ENGINES_PKG.TECH_MESSAGE(
372: p_severity => FND_LOG.level_procedure,
373: p_module => C_MODULE,
374: p_msg_text => 'End Procedure');

Line 372: p_severity => FND_LOG.level_procedure,

368: END IF; -- IF (v_is_ruleset = 'Y')
369:
370: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
371: FEM_ENGINES_PKG.TECH_MESSAGE(
372: p_severity => FND_LOG.level_procedure,
373: p_module => C_MODULE,
374: p_msg_text => 'End Procedure');
375: END IF;
376: --

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

401: x_all_rules_are_valid OUT NOCOPY VARCHAR2)
402: -------------------------------------------------------------------------------
403: IS
404: --
405: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
406: 'fem.plsql.fem_check_dis_mbr_pkg.validate_root_rule';
407: --
408: v_module FND_LOG_MESSAGES.module%TYPE :=
409: 'fem.plsql.fem_check_dis_mbr_pkg.validate_root_rule.'||p_stack_level;

Line 408: v_module FND_LOG_MESSAGES.module%TYPE :=

404: --
405: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
406: 'fem.plsql.fem_check_dis_mbr_pkg.validate_root_rule';
407: --
408: v_module FND_LOG_MESSAGES.module%TYPE :=
409: 'fem.plsql.fem_check_dis_mbr_pkg.validate_root_rule.'||p_stack_level;
410: v_curr_report_id NUMBER;
411: v_ref_obj_def_id NUMBER;
412: v_err_code NUMBER;

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

427: WHERE c.object_id = d.required_object_id);
428: --
429: BEGIN
430: --
431: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
432: FEM_ENGINES_PKG.TECH_MESSAGE(
433: p_severity => FND_LOG.level_procedure,
434: p_module => v_module,
435: p_msg_text => 'Begin Procedure: '||p_stack_level);

Line 433: p_severity => FND_LOG.level_procedure,

429: BEGIN
430: --
431: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
432: FEM_ENGINES_PKG.TECH_MESSAGE(
433: p_severity => FND_LOG.level_procedure,
434: p_module => v_module,
435: p_msg_text => 'Begin Procedure: '||p_stack_level);
436: END IF;
437: --

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

434: p_module => v_module,
435: p_msg_text => 'Begin Procedure: '||p_stack_level);
436: END IF;
437: --
438: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
439: FEM_ENGINES_PKG.TECH_MESSAGE(
440: p_severity => FND_LOG.level_statement,
441: p_module => v_module,
442: p_msg_text => 'p_obj_def_id = '||p_obj_def_id

Line 440: p_severity => FND_LOG.level_statement,

436: END IF;
437: --
438: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
439: FEM_ENGINES_PKG.TECH_MESSAGE(
440: p_severity => FND_LOG.level_statement,
441: p_module => v_module,
442: p_msg_text => 'p_obj_def_id = '||p_obj_def_id
443: ||'; p_parent_report_row_id = '||p_parent_report_row_id);
444: END IF;

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

452:
453: -- Loop through all rules referenced by this current rule
454: -- and recursively check those rules for disabled members.
455: FOR ref_rules IN c_ref_rules(p_obj_def_id) LOOP
456: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
457: FEM_ENGINES_PKG.TECH_MESSAGE(
458: p_severity => FND_LOG.level_statement,
459: p_module => v_module,
460: p_msg_text => 'ref_rules.required_object_id = '

Line 458: p_severity => FND_LOG.level_statement,

454: -- and recursively check those rules for disabled members.
455: FOR ref_rules IN c_ref_rules(p_obj_def_id) LOOP
456: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
457: FEM_ENGINES_PKG.TECH_MESSAGE(
458: p_severity => FND_LOG.level_statement,
459: p_module => v_module,
460: p_msg_text => 'ref_rules.required_object_id = '
461: ||ref_rules.required_object_id);
462: END IF;

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

471:
472: IF (v_err_code <> 0) THEN
473: -- If the rule passed validation, this routine should never error.
474: -- If it does, raise unexp error.
475: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
476: FEM_ENGINES_PKG.TECH_MESSAGE(
477: p_severity => FND_LOG.level_unexpected,
478: p_module => v_module,
479: p_msg_text => 'UNEXPECTED ERROR: Call to'

Line 477: p_severity => FND_LOG.level_unexpected,

473: -- If the rule passed validation, this routine should never error.
474: -- If it does, raise unexp error.
475: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
476: FEM_ENGINES_PKG.TECH_MESSAGE(
477: p_severity => FND_LOG.level_unexpected,
478: p_module => v_module,
479: p_msg_text => 'UNEXPECTED ERROR: Call to'
480: ||' FEM_RULE_SET_MANAGER.Get_ValidDefinition_Pub'
481: ||' failed with x_err_msg: '||v_msg_data);

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

497: v_all_ref_rules_valid := 'N';
498: END IF;
499: END LOOP; -- FOR ref_rules IN c_ref_rules LOOP
500:
501: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
502: FEM_ENGINES_PKG.TECH_MESSAGE(
503: p_severity => FND_LOG.level_statement,
504: p_module => v_module,
505: p_msg_text => 'v_all_ref_rules_valid = '||v_all_ref_rules_valid);

Line 503: p_severity => FND_LOG.level_statement,

499: END LOOP; -- FOR ref_rules IN c_ref_rules LOOP
500:
501: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
502: FEM_ENGINES_PKG.TECH_MESSAGE(
503: p_severity => FND_LOG.level_statement,
504: p_module => v_module,
505: p_msg_text => 'v_all_ref_rules_valid = '||v_all_ref_rules_valid);
506: END IF;
507:

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

512: p_global_vs_id => p_global_vs_id,
513: p_param_dim_id => p_param_dim_id,
514: x_this_is_valid => v_this_rule_is_valid);
515:
516: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
517: FEM_ENGINES_PKG.TECH_MESSAGE(
518: p_severity => FND_LOG.level_statement,
519: p_module => v_module,
520: p_msg_text => 'v_this_rule_is_valid = '||v_this_rule_is_valid);

Line 518: p_severity => FND_LOG.level_statement,

514: x_this_is_valid => v_this_rule_is_valid);
515:
516: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
517: FEM_ENGINES_PKG.TECH_MESSAGE(
518: p_severity => FND_LOG.level_statement,
519: p_module => v_module,
520: p_msg_text => 'v_this_rule_is_valid = '||v_this_rule_is_valid);
521: END IF;
522:

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

595: ELSE
596: x_all_rules_are_valid := 'Y';
597: END IF; -- IF (v_this_rule_is_valid = 'N' OR v_all_ref_rules_valid = 'N')
598:
599: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
600: FEM_ENGINES_PKG.TECH_MESSAGE(
601: p_severity => FND_LOG.level_statement,
602: p_module => v_module,
603: p_msg_text => 'x_all_rules_are_valid = '||x_all_rules_are_valid);

Line 601: p_severity => FND_LOG.level_statement,

597: END IF; -- IF (v_this_rule_is_valid = 'N' OR v_all_ref_rules_valid = 'N')
598:
599: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
600: FEM_ENGINES_PKG.TECH_MESSAGE(
601: p_severity => FND_LOG.level_statement,
602: p_module => v_module,
603: p_msg_text => 'x_all_rules_are_valid = '||x_all_rules_are_valid);
604: END IF;
605: --

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

602: p_module => v_module,
603: p_msg_text => 'x_all_rules_are_valid = '||x_all_rules_are_valid);
604: END IF;
605: --
606: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
607: FEM_ENGINES_PKG.TECH_MESSAGE(
608: p_severity => FND_LOG.level_procedure,
609: p_module => v_module,
610: p_msg_text => 'End Procedure: '||p_stack_level);

Line 608: p_severity => FND_LOG.level_procedure,

604: END IF;
605: --
606: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
607: FEM_ENGINES_PKG.TECH_MESSAGE(
608: p_severity => FND_LOG.level_procedure,
609: p_module => v_module,
610: p_msg_text => 'End Procedure: '||p_stack_level);
611: END IF;
612: --

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

633: x_this_is_valid OUT NOCOPY VARCHAR2)
634: -------------------------------------------------------------------------------
635: IS
636: --
637: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
638: 'fem.plsql.fem_check_disabled_mbrs_pkg.validate_rule_wrapper';
639: --
640: v_rule_type FEM_OBJECT_TYPES_B.object_type_code%TYPE;
641: v_this_rule_is_valid VARCHAR2(1);

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

641: v_this_rule_is_valid VARCHAR2(1);
642: --
643: BEGIN
644: --
645: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
646: FEM_ENGINES_PKG.TECH_MESSAGE(
647: p_severity => FND_LOG.level_procedure,
648: p_module => C_MODULE,
649: p_msg_text => 'Begin Procedure');

Line 647: p_severity => FND_LOG.level_procedure,

643: BEGIN
644: --
645: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
646: FEM_ENGINES_PKG.TECH_MESSAGE(
647: p_severity => FND_LOG.level_procedure,
648: p_module => C_MODULE,
649: p_msg_text => 'Begin Procedure');
650: END IF;
651: --

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

660: WHEN others THEN NULL;
661: END;
662:
663: IF (x_this_is_valid IS NOT NULL) THEN
664: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
665: -- Add this to make debug log more readable
666: SELECT oc.object_type_code
667: INTO v_rule_type
668: FROM fem_object_catalog_b oc, fem_object_definition_b od

Line 673: p_severity => FND_LOG.level_statement,

669: WHERE oc.object_id = od.object_id
670: AND od.object_definition_id = p_obj_def_id;
671:
672: FEM_ENGINES_PKG.TECH_MESSAGE(
673: p_severity => FND_LOG.level_statement,
674: p_module => C_MODULE,
675:
676: p_msg_text => 'p_obj_def_id = '||p_obj_def_id
677: ||'; v_rule_type = '||v_rule_type);

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

676: p_msg_text => 'p_obj_def_id = '||p_obj_def_id
677: ||'; v_rule_type = '||v_rule_type);
678: END IF;
679:
680: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
681: FEM_ENGINES_PKG.TECH_MESSAGE(
682: p_severity => FND_LOG.level_procedure,
683: p_module => C_MODULE,
684: p_msg_text => 'End Procedure: RETURN: x_this_is_valid = '

Line 682: p_severity => FND_LOG.level_procedure,

678: END IF;
679:
680: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
681: FEM_ENGINES_PKG.TECH_MESSAGE(
682: p_severity => FND_LOG.level_procedure,
683: p_module => C_MODULE,
684: p_msg_text => 'End Procedure: RETURN: x_this_is_valid = '
685: ||x_this_is_valid);
686: END IF;

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

694: FROM fem_object_catalog_b oc, fem_object_definition_b od
695: WHERE oc.object_id = od.object_id
696: AND od.object_definition_id = p_obj_def_id;
697:
698: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
699: FEM_ENGINES_PKG.TECH_MESSAGE(
700: p_severity => FND_LOG.level_statement,
701: p_module => C_MODULE,
702: p_msg_text => 'v_rule_type = '||v_rule_type);

Line 700: p_severity => FND_LOG.level_statement,

696: AND od.object_definition_id = p_obj_def_id;
697:
698: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
699: FEM_ENGINES_PKG.TECH_MESSAGE(
700: p_severity => FND_LOG.level_statement,
701: p_module => C_MODULE,
702: p_msg_text => 'v_rule_type = '||v_rule_type);
703: END IF;
704:

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

751: v_this_rule_is_valid := 'Y';
752:
753: ELSE
754: -- Unsupported rule type - raise unexpected error
755: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
756: FEM_ENGINES_PKG.TECH_MESSAGE(
757: p_severity => FND_LOG.level_unexpected,
758: p_module => C_MODULE,
759: p_msg_text => 'This rule type is not supported: '||v_rule_type);

Line 757: p_severity => FND_LOG.level_unexpected,

753: ELSE
754: -- Unsupported rule type - raise unexpected error
755: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
756: FEM_ENGINES_PKG.TECH_MESSAGE(
757: p_severity => FND_LOG.level_unexpected,
758: p_module => C_MODULE,
759: p_msg_text => 'This rule type is not supported: '||v_rule_type);
760: END IF;
761:

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

767: VALUES (p_obj_def_id, v_this_rule_is_valid);
768:
769: x_this_is_valid := v_this_rule_is_valid;
770: --
771: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
772: FEM_ENGINES_PKG.TECH_MESSAGE(
773: p_severity => FND_LOG.level_procedure,
774: p_module => C_MODULE,
775: p_msg_text => 'End Procedure: x_this_is_valid = '||x_this_is_valid);

Line 773: p_severity => FND_LOG.level_procedure,

769: x_this_is_valid := v_this_rule_is_valid;
770: --
771: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
772: FEM_ENGINES_PKG.TECH_MESSAGE(
773: p_severity => FND_LOG.level_procedure,
774: p_module => C_MODULE,
775: p_msg_text => 'End Procedure: x_this_is_valid = '||x_this_is_valid);
776: END IF;
777: --

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

802: x_this_is_valid OUT NOCOPY VARCHAR2)
803: -------------------------------------------------------------------------------
804: IS
805: --
806: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
807: 'fem.plsql.fem_check_disabled_mbrs_pkg.validate_mapping';
808:
809: v_member_table FEM_TAB_COLUMNS_B.TABLE_NAME%TYPE;
810: v_member_column FEM_TAB_COLUMNS_B.COLUMN_NAME%TYPE;

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

865: AND f.object_definition_id = p_obj_def_id;
866:
867: BEGIN
868:
869: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
870: FEM_ENGINES_PKG.TECH_MESSAGE(
871: p_severity => FND_LOG.level_procedure,
872: p_module => C_MODULE,
873: p_msg_text => 'Begin Procedure');

Line 871: p_severity => FND_LOG.level_procedure,

867: BEGIN
868:
869: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
870: FEM_ENGINES_PKG.TECH_MESSAGE(
871: p_severity => FND_LOG.level_procedure,
872: p_module => C_MODULE,
873: p_msg_text => 'Begin Procedure');
874:
875: FEM_ENGINES_PKG.TECH_MESSAGE(

Line 876: p_severity => FND_LOG.level_procedure,

872: p_module => C_MODULE,
873: p_msg_text => 'Begin Procedure');
874:
875: FEM_ENGINES_PKG.TECH_MESSAGE(
876: p_severity => FND_LOG.level_procedure,
877: p_module => C_MODULE,
878: p_msg_text => 'p_obj_def_id is ' || p_obj_def_id);
879:
880: FEM_ENGINES_PKG.TECH_MESSAGE(

Line 881: p_severity => FND_LOG.level_procedure,

877: p_module => C_MODULE,
878: p_msg_text => 'p_obj_def_id is ' || p_obj_def_id);
879:
880: FEM_ENGINES_PKG.TECH_MESSAGE(
881: p_severity => FND_LOG.level_procedure,
882: p_module => C_MODULE,
883: p_msg_text => 'p_param_dim_id is ' || p_param_dim_id);
884:
885: FEM_ENGINES_PKG.TECH_MESSAGE(

Line 886: p_severity => FND_LOG.level_procedure,

882: p_module => C_MODULE,
883: p_msg_text => 'p_param_dim_id is ' || p_param_dim_id);
884:
885: FEM_ENGINES_PKG.TECH_MESSAGE(
886: p_severity => FND_LOG.level_procedure,
887: p_module => C_MODULE,
888: p_msg_text => 'p_global_vs_id is ' || p_global_vs_id);
889:
890: END IF;

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

893: FOR context_string IN c_get_context(p_obj_def_id) LOOP
894: v_func_cd := context_string.function_cd;
895:
896:
897: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
898: FEM_ENGINES_PKG.TECH_MESSAGE(
899: p_severity => FND_LOG.level_statement,
900: p_module => C_MODULE,
901: p_msg_text => 'the context code is := '

Line 899: p_severity => FND_LOG.level_statement,

895:
896:
897: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
898: FEM_ENGINES_PKG.TECH_MESSAGE(
899: p_severity => FND_LOG.level_statement,
900: p_module => C_MODULE,
901: p_msg_text => 'the context code is := '
902: || v_func_cd);
903: END IF;

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

941: (SELECT ' || v_member_column ||
942: ' FROM ' || v_member_table ||
943: ' WHERE enabled_flag = ''N'' ' || v_val_stmt || ')';
944:
945: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
946: FEM_ENGINES_PKG.TECH_MESSAGE(
947: p_severity => FND_LOG.level_statement,
948: p_module => C_MODULE,
949: p_msg_text => 'dynamic SQL statement is := ' || v_insert_stmt);

Line 947: p_severity => FND_LOG.level_statement,

943: ' WHERE enabled_flag = ''N'' ' || v_val_stmt || ')';
944:
945: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
946: FEM_ENGINES_PKG.TECH_MESSAGE(
947: p_severity => FND_LOG.level_statement,
948: p_module => C_MODULE,
949: p_msg_text => 'dynamic SQL statement is := ' || v_insert_stmt);
950: END IF;
951:

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

1019: v_insert_stmt := v_insert_stmt ||
1020: 'IN (SELECT ' || v_member_column || ' FROM ' ||
1021: v_member_table || ' WHERE enabled_flag = ''N'' ' || v_val_stmt || ')';
1022:
1023: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1024: FEM_ENGINES_PKG.TECH_MESSAGE(
1025: p_severity => FND_LOG.level_statement,
1026: p_module => C_MODULE,
1027: p_msg_text => 'dynamic SQL statement is := ' || v_insert_stmt);

Line 1025: p_severity => FND_LOG.level_statement,

1021: v_member_table || ' WHERE enabled_flag = ''N'' ' || v_val_stmt || ')';
1022:
1023: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1024: FEM_ENGINES_PKG.TECH_MESSAGE(
1025: p_severity => FND_LOG.level_statement,
1026: p_module => C_MODULE,
1027: p_msg_text => 'dynamic SQL statement is := ' || v_insert_stmt);
1028: END IF;
1029:

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

1042: IF (x_this_is_valid is null) THEN
1043: x_this_is_valid := 'Y';
1044: END IF;
1045:
1046: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1047: FEM_ENGINES_PKG.TECH_MESSAGE(
1048: p_severity => FND_LOG.level_procedure,
1049: p_module => C_MODULE,
1050: p_msg_text => 'End Procedure; x_this_is_valid: ' || x_this_is_valid);

Line 1048: p_severity => FND_LOG.level_procedure,

1044: END IF;
1045:
1046: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1047: FEM_ENGINES_PKG.TECH_MESSAGE(
1048: p_severity => FND_LOG.level_procedure,
1049: p_module => C_MODULE,
1050: p_msg_text => 'End Procedure; x_this_is_valid: ' || x_this_is_valid);
1051: END IF;
1052: --

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

1074: x_this_is_valid OUT NOCOPY VARCHAR2)
1075: -------------------------------------------------------------------------------
1076: IS
1077: --
1078: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1079: 'fem.plsql.fem_check_disabled_mbrs_pkg.validate_dim_component';
1080:
1081: v_member_table FEM_TAB_COLUMNS_B.TABLE_NAME%TYPE;
1082: v_member_column FEM_TAB_COLUMNS_B.COLUMN_NAME%TYPE;

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

1106: AND c.dim_id = nvl(p_param_dim_id, c.dim_id);
1107:
1108: BEGIN
1109:
1110: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1111: FEM_ENGINES_PKG.TECH_MESSAGE(
1112: p_severity => FND_LOG.level_procedure,
1113: p_module => C_MODULE,
1114: p_msg_text => 'Begin Procedure');

Line 1112: p_severity => FND_LOG.level_procedure,

1108: BEGIN
1109:
1110: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1111: FEM_ENGINES_PKG.TECH_MESSAGE(
1112: p_severity => FND_LOG.level_procedure,
1113: p_module => C_MODULE,
1114: p_msg_text => 'Begin Procedure');
1115:
1116: FEM_ENGINES_PKG.TECH_MESSAGE(

Line 1117: p_severity => FND_LOG.level_procedure,

1113: p_module => C_MODULE,
1114: p_msg_text => 'Begin Procedure');
1115:
1116: FEM_ENGINES_PKG.TECH_MESSAGE(
1117: p_severity => FND_LOG.level_procedure,
1118: p_module => C_MODULE,
1119: p_msg_text => 'p_obj_def_id is ' || p_obj_def_id);
1120:
1121: FEM_ENGINES_PKG.TECH_MESSAGE(

Line 1122: p_severity => FND_LOG.level_procedure,

1118: p_module => C_MODULE,
1119: p_msg_text => 'p_obj_def_id is ' || p_obj_def_id);
1120:
1121: FEM_ENGINES_PKG.TECH_MESSAGE(
1122: p_severity => FND_LOG.level_procedure,
1123: p_module => C_MODULE,
1124: p_msg_text => 'p_param_dim_id is ' || p_param_dim_id);
1125:
1126: FEM_ENGINES_PKG.TECH_MESSAGE(

Line 1127: p_severity => FND_LOG.level_procedure,

1123: p_module => C_MODULE,
1124: p_msg_text => 'p_param_dim_id is ' || p_param_dim_id);
1125:
1126: FEM_ENGINES_PKG.TECH_MESSAGE(
1127: p_severity => FND_LOG.level_procedure,
1128: p_module => C_MODULE,
1129: p_msg_text => 'p_global_vs_id is ' || p_global_vs_id);
1130:
1131: END IF;

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

1138:
1139: --We dont check for hierarchies. If its a hier, return valid.
1140: IF (v_context_flag = 'H') THEN
1141: x_this_is_valid := 'Y';
1142: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1143: FEM_ENGINES_PKG.TECH_MESSAGE(
1144: p_severity => FND_LOG.level_statement,
1145: p_module => C_MODULE,
1146: p_msg_text => 'context is hierarchy, x_this_is_valid is returning

Line 1144: p_severity => FND_LOG.level_statement,

1140: IF (v_context_flag = 'H') THEN
1141: x_this_is_valid := 'Y';
1142: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1143: FEM_ENGINES_PKG.TECH_MESSAGE(
1144: p_severity => FND_LOG.level_statement,
1145: p_module => C_MODULE,
1146: p_msg_text => 'context is hierarchy, x_this_is_valid is returning
1147: with value of ' || x_this_is_valid);
1148: END IF;

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

1184: (SELECT to_char(' || v_member_column ||
1185: ') FROM ' || v_member_table ||
1186: ' WHERE enabled_flag = ''N'' ' || v_val_stmt || ') ';
1187:
1188: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1189: FEM_ENGINES_PKG.TECH_MESSAGE(
1190: p_severity => FND_LOG.level_statement,
1191: p_module => C_MODULE,
1192: p_msg_text => 'dynamic SQL statement for context('

Line 1190: p_severity => FND_LOG.level_statement,

1186: ' WHERE enabled_flag = ''N'' ' || v_val_stmt || ') ';
1187:
1188: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1189: FEM_ENGINES_PKG.TECH_MESSAGE(
1190: p_severity => FND_LOG.level_statement,
1191: p_module => C_MODULE,
1192: p_msg_text => 'dynamic SQL statement for context('
1193: || C_CONTEXT || ') is := ' || v_insert_stmt);
1194: END IF;

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

1237: (SELECT to_char(' || v_member_column ||
1238: ') FROM ' || v_member_table ||
1239: ' WHERE enabled_flag = ''N'' ' || v_val_stmt || ') ';
1240:
1241: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1242: FEM_ENGINES_PKG.TECH_MESSAGE(
1243: p_severity => FND_LOG.level_statement,
1244: p_module => C_MODULE,
1245: p_msg_text => 'dynamic SQL statement for context('

Line 1243: p_severity => FND_LOG.level_statement,

1239: ' WHERE enabled_flag = ''N'' ' || v_val_stmt || ') ';
1240:
1241: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1242: FEM_ENGINES_PKG.TECH_MESSAGE(
1243: p_severity => FND_LOG.level_statement,
1244: p_module => C_MODULE,
1245: p_msg_text => 'dynamic SQL statement for context('
1246: || C_CONTEXT || ') is := ' || v_insert_stmt);
1247: END IF;

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

1262: IF (x_this_is_valid is null) THEN
1263: x_this_is_valid := 'Y';
1264: END IF;
1265:
1266: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1267: FEM_ENGINES_PKG.TECH_MESSAGE(
1268: p_severity => FND_LOG.level_procedure,
1269: p_module => C_MODULE,
1270: p_msg_text => 'End Procedure; x_this_is_valid: ' || x_this_is_valid);

Line 1268: p_severity => FND_LOG.level_procedure,

1264: END IF;
1265:
1266: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1267: FEM_ENGINES_PKG.TECH_MESSAGE(
1268: p_severity => FND_LOG.level_procedure,
1269: p_module => C_MODULE,
1270: p_msg_text => 'End Procedure; x_this_is_valid: ' || x_this_is_valid);
1271: END IF;
1272: --

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

1294: x_this_is_valid OUT NOCOPY VARCHAR2)
1295: -------------------------------------------------------------------------------
1296: IS
1297: --
1298: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1299: 'fem.plsql.fem_check_disabled_mbrs_pkg.validate_data_component';
1300:
1301: v_member_table FEM_TAB_COLUMNS_B.TABLE_NAME%TYPE;
1302: v_member_column FEM_TAB_COLUMNS_B.COLUMN_NAME%TYPE;

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

1330: AND B.dimension_id = nvl(p_param_dim_id, B.dimension_id);
1331:
1332: BEGIN
1333:
1334: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1335: FEM_ENGINES_PKG.TECH_MESSAGE(
1336: p_severity => FND_LOG.level_procedure,
1337: p_module => C_MODULE,
1338: p_msg_text => 'Begin Procedure');

Line 1336: p_severity => FND_LOG.level_procedure,

1332: BEGIN
1333:
1334: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1335: FEM_ENGINES_PKG.TECH_MESSAGE(
1336: p_severity => FND_LOG.level_procedure,
1337: p_module => C_MODULE,
1338: p_msg_text => 'Begin Procedure');
1339:
1340: FEM_ENGINES_PKG.TECH_MESSAGE(

Line 1341: p_severity => FND_LOG.level_procedure,

1337: p_module => C_MODULE,
1338: p_msg_text => 'Begin Procedure');
1339:
1340: FEM_ENGINES_PKG.TECH_MESSAGE(
1341: p_severity => FND_LOG.level_procedure,
1342: p_module => C_MODULE,
1343: p_msg_text => 'p_obj_def_id is ' || p_obj_def_id);
1344:
1345: FEM_ENGINES_PKG.TECH_MESSAGE(

Line 1346: p_severity => FND_LOG.level_procedure,

1342: p_module => C_MODULE,
1343: p_msg_text => 'p_obj_def_id is ' || p_obj_def_id);
1344:
1345: FEM_ENGINES_PKG.TECH_MESSAGE(
1346: p_severity => FND_LOG.level_procedure,
1347: p_module => C_MODULE,
1348: p_msg_text => 'p_param_dim_id is ' || p_param_dim_id);
1349:
1350: FEM_ENGINES_PKG.TECH_MESSAGE(

Line 1351: p_severity => FND_LOG.level_procedure,

1347: p_module => C_MODULE,
1348: p_msg_text => 'p_param_dim_id is ' || p_param_dim_id);
1349:
1350: FEM_ENGINES_PKG.TECH_MESSAGE(
1351: p_severity => FND_LOG.level_procedure,
1352: p_module => C_MODULE,
1353: p_msg_text => 'p_global_vs_id is ' || p_global_vs_id);
1354: END IF;
1355:

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

1393: (SELECT to_char(' || v_member_column ||
1394: ') FROM ' || v_member_table ||
1395: ' WHERE enabled_flag = ''N'' ' || v_val_stmt || ') ';
1396:
1397: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1398: FEM_ENGINES_PKG.TECH_MESSAGE(
1399: p_severity => FND_LOG.level_statement,
1400: p_module => C_MODULE,
1401: p_msg_text => 'dynamic SQL statement is := ' || v_insert_stmt);

Line 1399: p_severity => FND_LOG.level_statement,

1395: ' WHERE enabled_flag = ''N'' ' || v_val_stmt || ') ';
1396:
1397: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1398: FEM_ENGINES_PKG.TECH_MESSAGE(
1399: p_severity => FND_LOG.level_statement,
1400: p_module => C_MODULE,
1401: p_msg_text => 'dynamic SQL statement is := ' || v_insert_stmt);
1402: END IF;
1403:

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

1413: IF (x_this_is_valid is null) THEN
1414: x_this_is_valid := 'Y';
1415: END IF;
1416:
1417: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1418: FEM_ENGINES_PKG.TECH_MESSAGE(
1419: p_severity => FND_LOG.level_procedure,
1420: p_module => C_MODULE,
1421: p_msg_text => 'End Procedure; x_this_is_valid: ' || x_this_is_valid);

Line 1419: p_severity => FND_LOG.level_procedure,

1415: END IF;
1416:
1417: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1418: FEM_ENGINES_PKG.TECH_MESSAGE(
1419: p_severity => FND_LOG.level_procedure,
1420: p_module => C_MODULE,
1421: p_msg_text => 'End Procedure; x_this_is_valid: ' || x_this_is_valid);
1422: END IF;
1423: --

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

1445: x_this_is_valid OUT NOCOPY VARCHAR2)
1446: -------------------------------------------------------------------------------
1447: IS
1448: --
1449: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1450: 'fem.plsql.fem_check_disabled_mbrs_pkg.validate_statistic';
1451:
1452: v_member_table FEM_TAB_COLUMNS_B.TABLE_NAME%TYPE;
1453: v_member_column FEM_TAB_COLUMNS_B.COLUMN_NAME%TYPE;

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

1477: AND C.dimension_id = nvl(p_param_dim_id, C.dimension_id);
1478:
1479: BEGIN
1480:
1481: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1482: FEM_ENGINES_PKG.TECH_MESSAGE(
1483: p_severity => FND_LOG.level_procedure,
1484: p_module => C_MODULE,
1485: p_msg_text => 'Begin Procedure');

Line 1483: p_severity => FND_LOG.level_procedure,

1479: BEGIN
1480:
1481: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1482: FEM_ENGINES_PKG.TECH_MESSAGE(
1483: p_severity => FND_LOG.level_procedure,
1484: p_module => C_MODULE,
1485: p_msg_text => 'Begin Procedure');
1486:
1487: FEM_ENGINES_PKG.TECH_MESSAGE(

Line 1488: p_severity => FND_LOG.level_procedure,

1484: p_module => C_MODULE,
1485: p_msg_text => 'Begin Procedure');
1486:
1487: FEM_ENGINES_PKG.TECH_MESSAGE(
1488: p_severity => FND_LOG.level_procedure,
1489: p_module => C_MODULE,
1490: p_msg_text => 'p_obj_def_id is ' || p_obj_def_id);
1491:
1492: FEM_ENGINES_PKG.TECH_MESSAGE(

Line 1493: p_severity => FND_LOG.level_procedure,

1489: p_module => C_MODULE,
1490: p_msg_text => 'p_obj_def_id is ' || p_obj_def_id);
1491:
1492: FEM_ENGINES_PKG.TECH_MESSAGE(
1493: p_severity => FND_LOG.level_procedure,
1494: p_module => C_MODULE,
1495: p_msg_text => 'p_param_dim_id is ' || p_param_dim_id);
1496:
1497: FEM_ENGINES_PKG.TECH_MESSAGE(

Line 1498: p_severity => FND_LOG.level_procedure,

1494: p_module => C_MODULE,
1495: p_msg_text => 'p_param_dim_id is ' || p_param_dim_id);
1496:
1497: FEM_ENGINES_PKG.TECH_MESSAGE(
1498: p_severity => FND_LOG.level_procedure,
1499: p_module => C_MODULE,
1500: p_msg_text => 'p_global_vs_id is ' || p_global_vs_id);
1501:
1502: END IF;

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

1538: (SELECT to_char(' || v_member_column ||
1539: ') FROM ' || v_member_table ||
1540: ' WHERE enabled_flag = ''N'' ' || v_val_stmt || ') ';
1541:
1542: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1543: FEM_ENGINES_PKG.TECH_MESSAGE(
1544: p_severity => FND_LOG.level_statement,
1545: p_module => C_MODULE,
1546: p_msg_text => 'dynamic SQL statement is := ' || v_insert_stmt);

Line 1544: p_severity => FND_LOG.level_statement,

1540: ' WHERE enabled_flag = ''N'' ' || v_val_stmt || ') ';
1541:
1542: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1543: FEM_ENGINES_PKG.TECH_MESSAGE(
1544: p_severity => FND_LOG.level_statement,
1545: p_module => C_MODULE,
1546: p_msg_text => 'dynamic SQL statement is := ' || v_insert_stmt);
1547: END IF;
1548:

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

1557: IF (x_this_is_valid is null) THEN
1558: x_this_is_valid := 'Y';
1559: END IF;
1560:
1561: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1562: FEM_ENGINES_PKG.TECH_MESSAGE(
1563: p_severity => FND_LOG.level_procedure,
1564: p_module => C_MODULE,
1565: p_msg_text => 'End Procedure; x_this_is_valid: ' || x_this_is_valid);

Line 1563: p_severity => FND_LOG.level_procedure,

1559: END IF;
1560:
1561: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1562: FEM_ENGINES_PKG.TECH_MESSAGE(
1563: p_severity => FND_LOG.level_procedure,
1564: p_module => C_MODULE,
1565: p_msg_text => 'End Procedure; x_this_is_valid: ' || x_this_is_valid);
1566: END IF;
1567: --

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

1589: x_this_is_valid OUT NOCOPY VARCHAR2)
1590: -------------------------------------------------------------------------------
1591: IS
1592: --
1593: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1594: 'fem.plsql.fem_check_disabled_mbrs_pkg.validate_hierarchy';
1595:
1596: v_member_table FEM_TAB_COLUMNS_B.TABLE_NAME%TYPE;
1597: v_member_column FEM_TAB_COLUMNS_B.COLUMN_NAME%TYPE;

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

1618:
1619:
1620: BEGIN
1621:
1622: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1623: FEM_ENGINES_PKG.TECH_MESSAGE(
1624: p_severity => FND_LOG.level_procedure,
1625: p_module => C_MODULE,
1626: p_msg_text => 'Begin Procedure');

Line 1624: p_severity => FND_LOG.level_procedure,

1620: BEGIN
1621:
1622: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1623: FEM_ENGINES_PKG.TECH_MESSAGE(
1624: p_severity => FND_LOG.level_procedure,
1625: p_module => C_MODULE,
1626: p_msg_text => 'Begin Procedure');
1627:
1628: FEM_ENGINES_PKG.TECH_MESSAGE(

Line 1629: p_severity => FND_LOG.level_procedure,

1625: p_module => C_MODULE,
1626: p_msg_text => 'Begin Procedure');
1627:
1628: FEM_ENGINES_PKG.TECH_MESSAGE(
1629: p_severity => FND_LOG.level_procedure,
1630: p_module => C_MODULE,
1631: p_msg_text => 'p_obj_def_id is ' || p_obj_def_id);
1632:
1633: FEM_ENGINES_PKG.TECH_MESSAGE(

Line 1634: p_severity => FND_LOG.level_procedure,

1630: p_module => C_MODULE,
1631: p_msg_text => 'p_obj_def_id is ' || p_obj_def_id);
1632:
1633: FEM_ENGINES_PKG.TECH_MESSAGE(
1634: p_severity => FND_LOG.level_procedure,
1635: p_module => C_MODULE,
1636: p_msg_text => 'p_param_dim_id is ' || p_param_dim_id);
1637:
1638: FEM_ENGINES_PKG.TECH_MESSAGE(

Line 1639: p_severity => FND_LOG.level_procedure,

1635: p_module => C_MODULE,
1636: p_msg_text => 'p_param_dim_id is ' || p_param_dim_id);
1637:
1638: FEM_ENGINES_PKG.TECH_MESSAGE(
1639: p_severity => FND_LOG.level_procedure,
1640: p_module => C_MODULE,
1641: p_msg_text => 'p_global_vs_id is ' || p_global_vs_id);
1642: END IF;
1643:

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

1688: INTO v_hier_flattened
1689: FROM fem_hier_definitions
1690: WHERE hierarchy_obj_def_id = p_obj_def_id;
1691:
1692: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1693: FEM_ENGINES_PKG.TECH_MESSAGE(
1694: p_severity => FND_LOG.level_statement,
1695: p_module => C_MODULE,
1696: p_msg_text => 'v_hier_flattened is := ' || v_hier_flattened);

Line 1694: p_severity => FND_LOG.level_statement,

1690: WHERE hierarchy_obj_def_id = p_obj_def_id;
1691:
1692: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1693: FEM_ENGINES_PKG.TECH_MESSAGE(
1694: p_severity => FND_LOG.level_statement,
1695: p_module => C_MODULE,
1696: p_msg_text => 'v_hier_flattened is := ' || v_hier_flattened);
1697: END IF;
1698:

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

1711: FND_GLOBAL.login_id, ''' || v_value_set_name || ''', ''' ||
1712: v_value_set_name || ''',' || nvl(to_char(v_value_set_id), 'NULL')
1713: || ',' || nvl(to_char(v_value_set_id), 'NULL') || ',';
1714:
1715: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1716: FEM_ENGINES_PKG.TECH_MESSAGE(
1717: p_severity => FND_LOG.level_statement,
1718: p_module => C_MODULE,
1719: p_msg_text => 'dynamic SQL statement is := ' || v_insert_stmt);

Line 1717: p_severity => FND_LOG.level_statement,

1713: || ',' || nvl(to_char(v_value_set_id), 'NULL') || ',';
1714:
1715: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1716: FEM_ENGINES_PKG.TECH_MESSAGE(
1717: p_severity => FND_LOG.level_statement,
1718: p_module => C_MODULE,
1719: p_msg_text => 'dynamic SQL statement is := ' || v_insert_stmt);
1720: END IF;
1721:

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

1748: ' FROM ' || v_member_table ||
1749: ' WHERE enabled_flag = ''N''))';
1750:
1751:
1752: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1753: FEM_ENGINES_PKG.TECH_MESSAGE(
1754: p_severity => FND_LOG.level_statement,
1755: p_module => C_MODULE,
1756: p_msg_text => 'flattened insert dynamic SQL statement is := '

Line 1754: p_severity => FND_LOG.level_statement,

1750:
1751:
1752: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1753: FEM_ENGINES_PKG.TECH_MESSAGE(
1754: p_severity => FND_LOG.level_statement,
1755: p_module => C_MODULE,
1756: p_msg_text => 'flattened insert dynamic SQL statement is := '
1757: || v_insert_stmt);
1758: END IF;

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

1781: (SELECT ' || v_member_column ||
1782: ' FROM ' || v_member_table ||
1783: ' WHERE enabled_flag = ''N'')';
1784:
1785: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1786: FEM_ENGINES_PKG.TECH_MESSAGE(
1787: p_severity => FND_LOG.level_statement,
1788: p_module => C_MODULE,
1789: p_msg_text => 'update dynamic SQL statement is := ' || v_insert_stmt);

Line 1787: p_severity => FND_LOG.level_statement,

1783: ' WHERE enabled_flag = ''N'')';
1784:
1785: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1786: FEM_ENGINES_PKG.TECH_MESSAGE(
1787: p_severity => FND_LOG.level_statement,
1788: p_module => C_MODULE,
1789: p_msg_text => 'update dynamic SQL statement is := ' || v_insert_stmt);
1790: END IF;
1791:

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

1806: ' FROM ' || v_member_table ||
1807: ' WHERE enabled_flag = ''N'')';
1808:
1809:
1810: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1811: FEM_ENGINES_PKG.TECH_MESSAGE(
1812: p_severity => FND_LOG.level_statement,
1813: p_module => C_MODULE,
1814: p_msg_text => 'unflattened insert dynamic SQL statement is := '

Line 1812: p_severity => FND_LOG.level_statement,

1808:
1809:
1810: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1811: FEM_ENGINES_PKG.TECH_MESSAGE(
1812: p_severity => FND_LOG.level_statement,
1813: p_module => C_MODULE,
1814: p_msg_text => 'unflattened insert dynamic SQL statement is := '
1815: || v_insert_stmt);
1816: END IF;

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

1832: 'INSERT INTO fem_br_disabled_mbrs_gt
1833: (object_definition_id, context_code)
1834: VALUES (' || to_char(p_obj_def_id) || ', ''HIERARCHY'')';
1835:
1836: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1837: FEM_ENGINES_PKG.TECH_MESSAGE(
1838: p_severity => FND_LOG.level_statement,
1839: p_module => C_MODULE,
1840: p_msg_text => 'dis mbrs insert dynamic SQL statement is := '

Line 1838: p_severity => FND_LOG.level_statement,

1834: VALUES (' || to_char(p_obj_def_id) || ', ''HIERARCHY'')';
1835:
1836: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1837: FEM_ENGINES_PKG.TECH_MESSAGE(
1838: p_severity => FND_LOG.level_statement,
1839: p_module => C_MODULE,
1840: p_msg_text => 'dis mbrs insert dynamic SQL statement is := '
1841: || v_insert_stmt);
1842: END IF;

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

1844: EXECUTE IMMEDIATE v_insert_stmt;
1845: END IF;
1846:
1847:
1848: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1849: FEM_ENGINES_PKG.TECH_MESSAGE(
1850: p_severity => FND_LOG.level_procedure,
1851: p_module => C_MODULE,
1852: p_msg_text => 'End Procedure; x_this_is_valid: ' || x_this_is_valid);

Line 1850: p_severity => FND_LOG.level_procedure,

1846:
1847:
1848: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1849: FEM_ENGINES_PKG.TECH_MESSAGE(
1850: p_severity => FND_LOG.level_procedure,
1851: p_module => C_MODULE,
1852: p_msg_text => 'End Procedure; x_this_is_valid: ' || x_this_is_valid);
1853: END IF;
1854: --

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

1878: x_this_is_valid OUT NOCOPY VARCHAR2)
1879: -------------------------------------------------------------------------------
1880: IS
1881: --
1882: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1883: 'fem.plsql.fem_check_disabled_mbrs_pkg.validate_factor_table';
1884:
1885: v_member_table FEM_TAB_COLUMNS_B.TABLE_NAME%TYPE;
1886: v_member_column FEM_TAB_COLUMNS_B.COLUMN_NAME%TYPE;

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

1899: AND dimension_id = nvl(p_param_dim_id, dimension_id);
1900:
1901: BEGIN
1902:
1903: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1904: FEM_ENGINES_PKG.TECH_MESSAGE(
1905: p_severity => FND_LOG.level_procedure,
1906: p_module => C_MODULE,
1907: p_msg_text => 'Begin Procedure');

Line 1905: p_severity => FND_LOG.level_procedure,

1901: BEGIN
1902:
1903: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1904: FEM_ENGINES_PKG.TECH_MESSAGE(
1905: p_severity => FND_LOG.level_procedure,
1906: p_module => C_MODULE,
1907: p_msg_text => 'Begin Procedure');
1908:
1909: FEM_ENGINES_PKG.TECH_MESSAGE(

Line 1910: p_severity => FND_LOG.level_procedure,

1906: p_module => C_MODULE,
1907: p_msg_text => 'Begin Procedure');
1908:
1909: FEM_ENGINES_PKG.TECH_MESSAGE(
1910: p_severity => FND_LOG.level_procedure,
1911: p_module => C_MODULE,
1912: p_msg_text => 'p_obj_def_id is ' || p_obj_def_id);
1913:
1914: FEM_ENGINES_PKG.TECH_MESSAGE(

Line 1915: p_severity => FND_LOG.level_procedure,

1911: p_module => C_MODULE,
1912: p_msg_text => 'p_obj_def_id is ' || p_obj_def_id);
1913:
1914: FEM_ENGINES_PKG.TECH_MESSAGE(
1915: p_severity => FND_LOG.level_procedure,
1916: p_module => C_MODULE,
1917: p_msg_text => 'p_param_dim_id is ' || p_param_dim_id);
1918:
1919: FEM_ENGINES_PKG.TECH_MESSAGE(

Line 1920: p_severity => FND_LOG.level_procedure,

1916: p_module => C_MODULE,
1917: p_msg_text => 'p_param_dim_id is ' || p_param_dim_id);
1918:
1919: FEM_ENGINES_PKG.TECH_MESSAGE(
1920: p_severity => FND_LOG.level_procedure,
1921: p_module => C_MODULE,
1922: p_msg_text => 'p_global_vs_id is ' || p_global_vs_id);
1923: END IF;
1924:

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

1957: || ' (SELECT to_char(' || v_member_column || ')'
1958: || ' FROM ' || v_member_table
1959: || ' WHERE enabled_flag = ''N'' ' || v_val_stmt || ')';
1960:
1961: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1962: FEM_ENGINES_PKG.TECH_MESSAGE(
1963: p_severity => FND_LOG.level_statement,
1964: p_module => C_MODULE,
1965: p_msg_text => 'dynamic SQL statement is := ' || v_insert_stmt);

Line 1963: p_severity => FND_LOG.level_statement,

1959: || ' WHERE enabled_flag = ''N'' ' || v_val_stmt || ')';
1960:
1961: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1962: FEM_ENGINES_PKG.TECH_MESSAGE(
1963: p_severity => FND_LOG.level_statement,
1964: p_module => C_MODULE,
1965: p_msg_text => 'dynamic SQL statement is := ' || v_insert_stmt);
1966: END IF;
1967:

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

1977: IF (x_this_is_valid IS NULL) THEN
1978: x_this_is_valid := 'Y';
1979: END IF;
1980:
1981: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1982: FEM_ENGINES_PKG.TECH_MESSAGE(
1983: p_severity => FND_LOG.level_procedure,
1984: p_module => C_MODULE,
1985: p_msg_text => 'End Procedure; x_this_is_valid: ' || x_this_is_valid);

Line 1983: p_severity => FND_LOG.level_procedure,

1979: END IF;
1980:
1981: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1982: FEM_ENGINES_PKG.TECH_MESSAGE(
1983: p_severity => FND_LOG.level_procedure,
1984: p_module => C_MODULE,
1985: p_msg_text => 'End Procedure; x_this_is_valid: ' || x_this_is_valid);
1986: END IF;
1987: --

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

2001: PROCEDURE Get_Put_Messages
2002: -------------------------------------------------------------------------------
2003: IS
2004: --
2005: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2006: 'fem.plsql.fem_check_dis_mbr_pkg.get_put_messages';
2007: v_msg_count NUMBER;
2008: v_msg_data VARCHAR2(4000);
2009: v_msg_out NUMBER;

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

2010: v_message VARCHAR2(4000);
2011: --
2012: BEGIN
2013: --
2014: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2015: FEM_ENGINES_PKG.TECH_MESSAGE(
2016: p_severity => FND_LOG.level_procedure,
2017: p_module => C_MODULE,
2018: p_msg_text => 'Begin Procedure');

Line 2016: p_severity => FND_LOG.level_procedure,

2012: BEGIN
2013: --
2014: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2015: FEM_ENGINES_PKG.TECH_MESSAGE(
2016: p_severity => FND_LOG.level_procedure,
2017: p_module => C_MODULE,
2018: p_msg_text => 'Begin Procedure');
2019: END IF;
2020:

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

2021: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
2022: p_count => v_msg_count,
2023: p_data => v_msg_data);
2024:
2025: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2026: FEM_ENGINES_PKG.TECH_MESSAGE(
2027: p_severity => FND_LOG.level_statement,
2028: p_module => C_MODULE,
2029: p_msg_text => 'Message count is '||to_char(v_msg_count));

Line 2027: p_severity => FND_LOG.level_statement,

2023: p_data => v_msg_data);
2024:
2025: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2026: FEM_ENGINES_PKG.TECH_MESSAGE(
2027: p_severity => FND_LOG.level_statement,
2028: p_module => C_MODULE,
2029: p_msg_text => 'Message count is '||to_char(v_msg_count));
2030: END IF;
2031:

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

2037: v_message := FND_MESSAGE.Get;
2038:
2039: FEM_ENGINES_PKG.User_Message(p_msg_text => v_message);
2040:
2041: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2042: FEM_ENGINES_PKG.TECH_MESSAGE(
2043: p_severity => FND_LOG.level_statement,
2044: p_module => C_MODULE,
2045: p_msg_text => 'Message is '||v_message);

Line 2043: p_severity => FND_LOG.level_statement,

2039: FEM_ENGINES_PKG.User_Message(p_msg_text => v_message);
2040:
2041: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2042: FEM_ENGINES_PKG.TECH_MESSAGE(
2043: p_severity => FND_LOG.level_statement,
2044: p_module => C_MODULE,
2045: p_msg_text => 'Message is '||v_message);
2046: END IF;
2047:

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

2054: p_msg_index_out => v_msg_out);
2055:
2056: FEM_ENGINES_PKG.User_Message(p_msg_text => v_message);
2057:
2058: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2059: FEM_ENGINES_PKG.TECH_MESSAGE(
2060: p_severity => FND_LOG.level_statement,
2061: p_module => C_MODULE,
2062: p_msg_text => 'Message is '||v_message);

Line 2060: p_severity => FND_LOG.level_statement,

2056: FEM_ENGINES_PKG.User_Message(p_msg_text => v_message);
2057:
2058: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2059: FEM_ENGINES_PKG.TECH_MESSAGE(
2060: p_severity => FND_LOG.level_statement,
2061: p_module => C_MODULE,
2062: p_msg_text => 'Message is '||v_message);
2063: END IF;
2064: END LOOP;

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

2065: END IF; -- IF (v_msg_count = 1)
2066:
2067: FND_MSG_PUB.Initialize;
2068:
2069: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2070: FEM_ENGINES_PKG.TECH_MESSAGE(
2071: p_severity => FND_LOG.level_procedure,
2072: p_module => C_MODULE,
2073: p_msg_text => 'End Procedure');

Line 2071: p_severity => FND_LOG.level_procedure,

2067: FND_MSG_PUB.Initialize;
2068:
2069: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2070: FEM_ENGINES_PKG.TECH_MESSAGE(
2071: p_severity => FND_LOG.level_procedure,
2072: p_module => C_MODULE,
2073: p_msg_text => 'End Procedure');
2074: END IF;
2075: --

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

2089: PROCEDURE Populate_Dim_Info
2090: -------------------------------------------------------------------------------
2091: IS
2092: --
2093: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2094: 'fem.plsql.fem_check_dis_mbr_pkg.populate_dim_info';
2095: --
2096: v_sql VARCHAR2(18000);
2097: --

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

2106: WHERE request_id = p_request_id);
2107: --
2108: BEGIN
2109: --
2110: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2111: FEM_ENGINES_PKG.TECH_MESSAGE(
2112: p_severity => FND_LOG.level_procedure,
2113: p_module => C_MODULE,
2114: p_msg_text => 'Begin Procedure');

Line 2112: p_severity => FND_LOG.level_procedure,

2108: BEGIN
2109: --
2110: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2111: FEM_ENGINES_PKG.TECH_MESSAGE(
2112: p_severity => FND_LOG.level_procedure,
2113: p_module => C_MODULE,
2114: p_msg_text => 'Begin Procedure');
2115: END IF;
2116:

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

2139: v_sql := v_sql||')'
2140: ||' WHERE dimension_id = :dim_id'
2141: ||' AND request_id = :req_id';
2142:
2143: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2144: FEM_ENGINES_PKG.TECH_MESSAGE(
2145: p_severity => FND_LOG.level_statement,
2146: p_module => C_MODULE,
2147: p_msg_text => 'v_sql = '||v_sql);

Line 2145: p_severity => FND_LOG.level_statement,

2141: ||' AND request_id = :req_id';
2142:
2143: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2144: FEM_ENGINES_PKG.TECH_MESSAGE(
2145: p_severity => FND_LOG.level_statement,
2146: p_module => C_MODULE,
2147: p_msg_text => 'v_sql = '||v_sql);
2148: END IF;
2149:

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

2151: USING dims.dimension_id, FND_GLOBAL.Conc_Request_ID;
2152:
2153: END LOOP;
2154:
2155: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2156: FEM_ENGINES_PKG.TECH_MESSAGE(
2157: p_severity => FND_LOG.level_procedure,
2158: p_module => C_MODULE,
2159: p_msg_text => 'End Procedure');

Line 2157: p_severity => FND_LOG.level_procedure,

2153: END LOOP;
2154:
2155: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2156: FEM_ENGINES_PKG.TECH_MESSAGE(
2157: p_severity => FND_LOG.level_procedure,
2158: p_module => C_MODULE,
2159: p_msg_text => 'End Procedure');
2160: END IF;
2161: --

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

2180: FUNCTION Get_Unique_Report_Row RETURN NUMBER
2181: -------------------------------------------------------------------------------
2182: IS
2183: --
2184: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2185: 'fem.plsql.fem_check_dis_mbr_pkg.get_unique_report_row';
2186: --
2187: BEGIN
2188: --

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

2185: 'fem.plsql.fem_check_dis_mbr_pkg.get_unique_report_row';
2186: --
2187: BEGIN
2188: --
2189: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2190: FEM_ENGINES_PKG.TECH_MESSAGE(
2191: p_severity => FND_LOG.level_procedure,
2192: p_module => C_MODULE,
2193: p_msg_text => 'Begin Procedure');

Line 2191: p_severity => FND_LOG.level_procedure,

2187: BEGIN
2188: --
2189: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2190: FEM_ENGINES_PKG.TECH_MESSAGE(
2191: p_severity => FND_LOG.level_procedure,
2192: p_module => C_MODULE,
2193: p_msg_text => 'Begin Procedure');
2194: END IF;
2195: --

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

2198: ELSE
2199: pv_report_row_counter := pv_report_row_counter + 1;
2200: END IF;
2201:
2202: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2203: FEM_ENGINES_PKG.TECH_MESSAGE(
2204: p_severity => FND_LOG.level_statement,
2205: p_module => C_MODULE,
2206: p_msg_text => 'pv_report_row_counter = '||pv_report_row_counter);

Line 2204: p_severity => FND_LOG.level_statement,

2200: END IF;
2201:
2202: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2203: FEM_ENGINES_PKG.TECH_MESSAGE(
2204: p_severity => FND_LOG.level_statement,
2205: p_module => C_MODULE,
2206: p_msg_text => 'pv_report_row_counter = '||pv_report_row_counter);
2207: END IF;
2208:

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

2205: p_module => C_MODULE,
2206: p_msg_text => 'pv_report_row_counter = '||pv_report_row_counter);
2207: END IF;
2208:
2209: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2210: FEM_ENGINES_PKG.TECH_MESSAGE(
2211: p_severity => FND_LOG.level_procedure,
2212: p_module => C_MODULE,
2213: p_msg_text => 'End Procedure');

Line 2211: p_severity => FND_LOG.level_procedure,

2207: END IF;
2208:
2209: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2210: FEM_ENGINES_PKG.TECH_MESSAGE(
2211: p_severity => FND_LOG.level_procedure,
2212: p_module => C_MODULE,
2213: p_msg_text => 'End Procedure');
2214: END IF;
2215:

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

2243: p_request_name IN VARCHAR2)
2244: -------------------------------------------------------------------------------
2245: IS
2246: --
2247: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2248: 'fem.plsql.fem_check_br_dis_mbrs_pkg.report_invalid_rules';
2249: --
2250: l_effective_date DATE;
2251: v_return_status VARCHAR2(1);

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

2264: FROM fem_br_root_rules_gt;
2265: --
2266: BEGIN
2267: --
2268: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2269: FEM_ENGINES_PKG.TECH_MESSAGE(
2270: p_severity => FND_LOG.level_procedure,
2271: p_module => C_MODULE,
2272: p_msg_text => 'Begin Procedure');

Line 2270: p_severity => FND_LOG.level_procedure,

2266: BEGIN
2267: --
2268: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2269: FEM_ENGINES_PKG.TECH_MESSAGE(
2270: p_severity => FND_LOG.level_procedure,
2271: p_module => C_MODULE,
2272: p_msg_text => 'Begin Procedure');
2273: END IF;
2274:

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

2272: p_msg_text => 'Begin Procedure');
2273: END IF;
2274:
2275: -- Log procedure param values
2276: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2277: FEM_ENGINES_PKG.TECH_MESSAGE(
2278: p_severity => FND_LOG.level_statement,
2279: p_module => C_MODULE,
2280: p_msg_text => 'p_rule_type = '||p_rule_type);

Line 2278: p_severity => FND_LOG.level_statement,

2274:
2275: -- Log procedure param values
2276: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2277: FEM_ENGINES_PKG.TECH_MESSAGE(
2278: p_severity => FND_LOG.level_statement,
2279: p_module => C_MODULE,
2280: p_msg_text => 'p_rule_type = '||p_rule_type);
2281: FEM_ENGINES_PKG.TECH_MESSAGE(
2282: p_severity => FND_LOG.level_statement,

Line 2282: p_severity => FND_LOG.level_statement,

2278: p_severity => FND_LOG.level_statement,
2279: p_module => C_MODULE,
2280: p_msg_text => 'p_rule_type = '||p_rule_type);
2281: FEM_ENGINES_PKG.TECH_MESSAGE(
2282: p_severity => FND_LOG.level_statement,
2283: p_module => C_MODULE,
2284: p_msg_text => 'p_ledger_id = '||p_ledger_id);
2285: FEM_ENGINES_PKG.TECH_MESSAGE(
2286: p_severity => FND_LOG.level_statement,

Line 2286: p_severity => FND_LOG.level_statement,

2282: p_severity => FND_LOG.level_statement,
2283: p_module => C_MODULE,
2284: p_msg_text => 'p_ledger_id = '||p_ledger_id);
2285: FEM_ENGINES_PKG.TECH_MESSAGE(
2286: p_severity => FND_LOG.level_statement,
2287: p_module => C_MODULE,
2288: p_msg_text => 'p_effective_date = '||p_effective_date);
2289: FEM_ENGINES_PKG.TECH_MESSAGE(
2290: p_severity => FND_LOG.level_statement,

Line 2290: p_severity => FND_LOG.level_statement,

2286: p_severity => FND_LOG.level_statement,
2287: p_module => C_MODULE,
2288: p_msg_text => 'p_effective_date = '||p_effective_date);
2289: FEM_ENGINES_PKG.TECH_MESSAGE(
2290: p_severity => FND_LOG.level_statement,
2291: p_module => C_MODULE,
2292: p_msg_text => 'p_folder_id = '||p_folder_id);
2293: FEM_ENGINES_PKG.TECH_MESSAGE(
2294: p_severity => FND_LOG.level_statement,

Line 2294: p_severity => FND_LOG.level_statement,

2290: p_severity => FND_LOG.level_statement,
2291: p_module => C_MODULE,
2292: p_msg_text => 'p_folder_id = '||p_folder_id);
2293: FEM_ENGINES_PKG.TECH_MESSAGE(
2294: p_severity => FND_LOG.level_statement,
2295: p_module => C_MODULE,
2296: p_msg_text => 'p_object_id = '||p_object_id);
2297: FEM_ENGINES_PKG.TECH_MESSAGE(
2298: p_severity => FND_LOG.level_statement,

Line 2298: p_severity => FND_LOG.level_statement,

2294: p_severity => FND_LOG.level_statement,
2295: p_module => C_MODULE,
2296: p_msg_text => 'p_object_id = '||p_object_id);
2297: FEM_ENGINES_PKG.TECH_MESSAGE(
2298: p_severity => FND_LOG.level_statement,
2299: p_module => C_MODULE,
2300: p_msg_text => 'p_dim_id = '||p_dim_id);
2301: FEM_ENGINES_PKG.TECH_MESSAGE(
2302: p_severity => FND_LOG.level_statement,

Line 2302: p_severity => FND_LOG.level_statement,

2298: p_severity => FND_LOG.level_statement,
2299: p_module => C_MODULE,
2300: p_msg_text => 'p_dim_id = '||p_dim_id);
2301: FEM_ENGINES_PKG.TECH_MESSAGE(
2302: p_severity => FND_LOG.level_statement,
2303: p_module => C_MODULE,
2304: p_msg_text => 'p_request_name = '||p_request_name);
2305: END IF; -- IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2306:

Line 2305: END IF; -- IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

2301: FEM_ENGINES_PKG.TECH_MESSAGE(
2302: p_severity => FND_LOG.level_statement,
2303: p_module => C_MODULE,
2304: p_msg_text => 'p_request_name = '||p_request_name);
2305: END IF; -- IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2306:
2307: -- Convert effective date from VARCHAR2 to DATE
2308: l_effective_date := FND_DATE.Canonical_To_Date(p_effective_date);
2309:

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

2314: x_msg_count => v_msg_count,
2315: x_msg_data => v_msg_data,
2316: p_ledger_id => p_ledger_id);
2317:
2318: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2319: FEM_ENGINES_PKG.TECH_MESSAGE(
2320: p_severity => FND_LOG.level_statement,
2321: p_module => C_MODULE,
2322: p_msg_text => 'v_global_vs_id = '||v_global_vs_id);

Line 2320: p_severity => FND_LOG.level_statement,

2316: p_ledger_id => p_ledger_id);
2317:
2318: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2319: FEM_ENGINES_PKG.TECH_MESSAGE(
2320: p_severity => FND_LOG.level_statement,
2321: p_module => C_MODULE,
2322: p_msg_text => 'v_global_vs_id = '||v_global_vs_id);
2323: END IF;
2324:

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

2322: p_msg_text => 'v_global_vs_id = '||v_global_vs_id);
2323: END IF;
2324:
2325: IF v_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2326: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2327: FEM_ENGINES_PKG.TECH_MESSAGE(
2328: p_severity => FND_LOG.level_unexpected,
2329: p_module => C_MODULE,
2330: p_msg_text => 'INTERNAL ERROR: Call to'

Line 2328: p_severity => FND_LOG.level_unexpected,

2324:
2325: IF v_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2326: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2327: FEM_ENGINES_PKG.TECH_MESSAGE(
2328: p_severity => FND_LOG.level_unexpected,
2329: p_module => C_MODULE,
2330: p_msg_text => 'INTERNAL ERROR: Call to'
2331: ||' FEM_DIMENSION_UTIL_PKG.Global_VS_Combo_ID'
2332: ||' failed with return status: '||v_return_status);

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

2434:
2435: -- Set concurrent status to success (0)
2436: retcode := 0;
2437:
2438: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2439: FEM_ENGINES_PKG.TECH_MESSAGE(
2440: p_severity => FND_LOG.level_statement,
2441: p_module => C_MODULE,
2442: p_msg_text => 'retcode = '||retcode);

Line 2440: p_severity => FND_LOG.level_statement,

2436: retcode := 0;
2437:
2438: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2439: FEM_ENGINES_PKG.TECH_MESSAGE(
2440: p_severity => FND_LOG.level_statement,
2441: p_module => C_MODULE,
2442: p_msg_text => 'retcode = '||retcode);
2443: END IF;
2444: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

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

2440: p_severity => FND_LOG.level_statement,
2441: p_module => C_MODULE,
2442: p_msg_text => 'retcode = '||retcode);
2443: END IF;
2444: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2445: FEM_ENGINES_PKG.TECH_MESSAGE(
2446: p_severity => FND_LOG.level_procedure,
2447: p_module => C_MODULE,
2448: p_msg_text => 'End Procedure');

Line 2446: p_severity => FND_LOG.level_procedure,

2442: p_msg_text => 'retcode = '||retcode);
2443: END IF;
2444: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2445: FEM_ENGINES_PKG.TECH_MESSAGE(
2446: p_severity => FND_LOG.level_procedure,
2447: p_module => C_MODULE,
2448: p_msg_text => 'End Procedure');
2449: END IF;
2450: --

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

2456:
2457: -- If there are any messages on the stack, post them to concurrent log.
2458: Get_Put_Messages;
2459:
2460: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2461: FEM_ENGINES_PKG.TECH_MESSAGE(
2462: p_severity => FND_LOG.level_unexpected,
2463: p_module => C_MODULE,
2464: p_msg_text => 'Unexpected error: '||SQLERRM);

Line 2462: p_severity => FND_LOG.level_unexpected,

2458: Get_Put_Messages;
2459:
2460: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2461: FEM_ENGINES_PKG.TECH_MESSAGE(
2462: p_severity => FND_LOG.level_unexpected,
2463: p_module => C_MODULE,
2464: p_msg_text => 'Unexpected error: '||SQLERRM);
2465: END IF;
2466:

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

2482: p_execution_start_date IN VARCHAR2,
2483: p_execution_end_date IN VARCHAR2,
2484: p_request_id IN NUMBER) IS
2485:
2486: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2487: 'fem.plsql.fem_check_br_dis_mbrs_pkg.purge_report_data';
2488: l_start_date DATE;
2489: l_end_date DATE;
2490:

Line 2559: fem_engines_pkg.tech_message (p_severity => FND_LOG.level_unexpected

2555: ROLLBACK TO Purge_Report_Data;
2556: --
2557:
2558: retcode := 2;
2559: fem_engines_pkg.tech_message (p_severity => FND_LOG.level_unexpected
2560: ,p_module => C_MODULE
2561: ,p_msg_text => 'EXCEPTION in Purge_Report_Data: ' || sqlerrm);
2562: fnd_file.put_line(fnd_file.log, 'EXCEPTION in Purge_Report_Data: ' || sqlerrm);
2563: