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_INTG_HIER_RULE_ENG_PKG dependencies on FEM_ENGINES_PKG

Line 73: FEM_ENGINES_PKG.Tech_Message

69: v_traversal_info c_traversal_info%ROWTYPE;
70: l_rec r_hier_traversal;
71: FEM_INTG_fatal_err EXCEPTION;
72: BEGIN
73: FEM_ENGINES_PKG.Tech_Message
74: (p_severity => pc_log_level_procedure,
75: p_module => 'fem.plsql.fem_intg.hier_eng.Init',
76: p_app_name => 'FEM',
77: p_msg_name => 'FEM_GL_POST_201',

Line 111: FEM_ENGINES_PKG.Tech_Message

107: WHEN NO_DATA_FOUND THEN
108: pv_hier_obj_def_id := -1;
109: END;
110: END IF;
111: FEM_ENGINES_PKG.Tech_Message
112: (p_severity => pc_log_level_statement,
113: p_module => 'fem.plsql.fem_intg_hier_rule_eng_pkg',
114: p_msg_text => 'pv_hier_obj_id:' || pv_hier_obj_id
115: ||' pv_hier_rule_obj_name:'||pv_hier_rule_obj_name

Line 131: FEM_ENGINES_PKG.Tech_Message

127: EXCEPTION
128: WHEN NO_DATA_FOUND THEN
129: RAISE FEM_INTG_fatal_err;
130: END;
131: FEM_ENGINES_PKG.Tech_Message
132: (p_severity => pc_log_level_statement,
133: p_module => 'fem.plsql.fem_intg_hier_rule_eng_pkg.get_mapping_option',
134: p_msg_text => 'pv_dim_mapping_option_code:'||pv_dim_mapping_option_code);
135: BEGIN

Line 302: FEM_ENGINES_PKG.Tech_Message

298: pv_traversal_rarray.extend;
299: pv_traversal_rarray(c_traversal_info%ROWCOUNT) := l_rec;
300: v_Num_hiers := c_traversal_info%ROWCOUNT;
301: END LOOP;
302: FEM_ENGINES_PKG.Tech_Message
303: (p_severity => pc_log_level_event,
304: p_module => 'fem.plsql.fem_intg_hier_eng.Init.traversal_rarray_set',
305: p_msg_text => ' v_Num_hiers:' || v_num_hiers ||
306: ' pv_dim_mapping_option_code:' || pv_dim_mapping_option_code,

Line 311: FEM_ENGINES_PKG.Tech_Message

307: p_token1 => 'TIME',
308: p_value1 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
309: -- Mult seg definition only has one sgement
310: if v_num_hiers < 2 then
311: FEM_ENGINES_PKG.Tech_Message
312: (p_severity => pc_log_level_unexpected,
313: p_module => 'fem.plsql.fem_intg_hier_eng.Init.traversal_rarray_set' ,
314: p_msg_text => 'Cannot initialize MULTISEG option with < two hierarchies.'
315: ||' pv_dim_mapping_option_code:'||pv_dim_mapping_option_code);

Line 320: FEM_ENGINES_PKG.Tech_Message

316: RAISE FEM_INTG_fatal_err;
317: end if;
318: ELSE
319: -- if no MULTISEG or SINGLESEG case then error
320: FEM_ENGINES_PKG.Tech_Message
321: (p_severity => pc_log_level_unexpected,
322: p_module => 'fem.plsql.fem_intg_hier_eng' ,
323: p_msg_text => 'Cannot initialize dimension rule information'
324: ||' pv_dim_mapping_option_code:'||pv_dim_mapping_option_code);

Line 329: FEM_ENGINES_PKG.Tech_Message

325: RAISE FEM_INTG_fatal_err;
326: END CASE;
327: EXCEPTION
328: WHEN NO_DATA_FOUND THEN
329: FEM_ENGINES_PKG.Tech_Message
330: (p_severity => pc_log_level_unexpected,
331: p_module => 'fem.plsql.fem_intg_hier_eng' ,
332: p_msg_text => 'Cannot initialize dimension rule information');
333: RAISE FEM_INTG_fatal_err;

Line 335: FEM_ENGINES_PKG.Tech_Message

331: p_module => 'fem.plsql.fem_intg_hier_eng' ,
332: p_msg_text => 'Cannot initialize dimension rule information');
333: RAISE FEM_INTG_fatal_err;
334: END;
335: FEM_ENGINES_PKG.Tech_Message
336: (p_severity => pc_log_level_statement,
337: p_module => 'fem.plsql.fem_intg_hier_rule_eng_pkg',
338: p_msg_text => 'pv_coa_id:' || pv_coa_id
339: ||' pv_dim_id:'||pv_dim_id

Line 344: FEM_ENGINES_PKG.Tech_Message

340: ||' pv_dim_vs_id:'||pv_dim_vs_id
341: ||' pv_aol_vs_id:'||pv_aol_vs_id
342: ||' pv_top_parent_disp_code:'||pv_top_parent_disp_code
343: ||' pv_top_parent_id:'||pv_top_parent_id);
344: FEM_ENGINES_PKG.Tech_Message
345: (p_severity => pc_log_level_statement,
346: p_module => 'fem.plsql.fem_intg_hier_rule_eng_pkg',
347: p_msg_text => 'pv_dim_memb_vl_obj:'||pv_dim_memb_vl_obj
348: ||' pv_dim_memb_tl_tab:'||pv_dim_memb_tl_tab

Line 354: FEM_ENGINES_PKG.Tech_Message

350: ||' pv_dim_memb_col:'||pv_dim_memb_col
351: ||' pv_dim_memb_disp_col:'||pv_dim_memb_disp_col
352: ||' pv_dim_memb_name_col:'||pv_dim_memb_name_col
353: ||' pv_dim_memb_desc_col:'||pv_dim_memb_desc_col);
354: FEM_ENGINES_PKG.Tech_Message
355: (p_severity => pc_log_level_statement,
356: p_module => 'fem.plsql.fem_intg_hier_rule_eng_pkg',
357: p_msg_text =>'pv_dim_hier_tab:'||pv_dim_hier_tab
358: ||' pv_dim_attr_tab:'||pv_dim_attr_tab

Line 363: FEM_ENGINES_PKG.Tech_Message

359: ||' pv_dim_mapping_option_code:'||pv_dim_mapping_option_code
360: ||' pv_segment_count:'||pv_segment_count
361: ||' pv_dim_rule_obj_def_id:'||pv_dim_rule_obj_def_id
362: ||' pv_dim_rule_obj_id:'||pv_dim_rule_obj_id);
363: FEM_ENGINES_PKG.Tech_Message
364: (p_severity => pc_log_level_statement,
365: p_module => 'fem.plsql.fem_intg_hier_rule_eng_pkg',
366: p_msg_text => 'pv_hier_rule_start_date:' ||pv_hier_rule_start_date
367: ||' pv_hier_rule_end_date:'||pv_hier_rule_end_date);

Line 368: FEM_ENGINES_PKG.Tech_Message

364: (p_severity => pc_log_level_statement,
365: p_module => 'fem.plsql.fem_intg_hier_rule_eng_pkg',
366: p_msg_text => 'pv_hier_rule_start_date:' ||pv_hier_rule_start_date
367: ||' pv_hier_rule_end_date:'||pv_hier_rule_end_date);
368: FEM_ENGINES_PKG.Tech_Message
369: (p_severity => pc_log_level_statement,
370: p_module => 'fem.plsql.fem_intg_hier_rule_eng_pkg',
371: p_msg_text => 'pv_flatten_hier_flag:' ||pv_flatten_hier_flag);
372: -- Initialize global value set combo ID

Line 382: FEM_ENGINES_PKG.Tech_Message

378: AND effective_start_date <= pv_hier_rule_start_date
379: AND effective_end_date >= pv_hier_rule_end_date;
380: EXCEPTION
381: WHEN NO_DATA_FOUND THEN
382: FEM_ENGINES_PKG.Tech_Message
383: (p_severity => pc_log_level_unexpected,
384: p_module => 'fem.plsql.fem_intg_hier_eng' ,
385: p_msg_text => 'Cannot find Global Value Set Combination');
386: RAISE FEM_INTG_fatal_err;

Line 388: FEM_ENGINES_PKG.Tech_Message

384: p_module => 'fem.plsql.fem_intg_hier_eng' ,
385: p_msg_text => 'Cannot find Global Value Set Combination');
386: RAISE FEM_INTG_fatal_err;
387: END;
388: FEM_ENGINES_PKG.Tech_Message
389: (p_severity => pc_log_level_statement,
390: p_module => 'fem.plsql.fem_intg_hier_rule_eng_pkg',
391: p_msg_text => 'pv_gvsc_id:'||pv_gvsc_id);
392: -- Initialize the variables requred for FEM_INTG_DIM_RULE_ENG_PKG.Init

Line 396: FEM_ENGINES_PKG.Tech_Message

392: -- Initialize the variables requred for FEM_INTG_DIM_RULE_ENG_PKG.Init
393: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_rule_obj_id := pv_dim_rule_obj_id;
394: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_rule_obj_def_id := pv_dim_rule_obj_def_id;
395: FEM_INTG_DIM_RULE_ENG_PKG.Init;
396: FEM_ENGINES_PKG.Tech_Message
397: (p_severity => pc_log_level_procedure,
398: p_module => 'fem.plsql.fem_intg_hier_eng.Init.',
399: p_msg_text => ' pv_dim_varchar_label:' || FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label);
400: x_completion_code := 0;

Line 401: FEM_ENGINES_PKG.Tech_Message

397: (p_severity => pc_log_level_procedure,
398: p_module => 'fem.plsql.fem_intg_hier_eng.Init.',
399: p_msg_text => ' pv_dim_varchar_label:' || FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label);
400: x_completion_code := 0;
401: FEM_ENGINES_PKG.Tech_Message
402: (p_severity => pc_log_level_procedure,
403: p_module => 'fem.plsql.fem_intg_hier_eng.init.',
404: p_app_name => 'FEM',
405: p_msg_name => 'FEM_GL_POST_202',

Line 414: FEM_ENGINES_PKG.Tech_Message

410: return;
411: EXCEPTION
412: WHEN FEM_INTG_fatal_err THEN
413: ROLLBACk;
414: FEM_ENGINES_PKG.Tech_Message
415: (p_severity => pc_log_level_unexpected,
416: p_module => 'fem.plsql.fem_intg_hier_eng.init.'||'exception ',
417: p_app_name => 'FEM',
418: p_msg_name => 'FEM_GL_POST_215',

Line 421: FEM_ENGINES_PKG.User_Message

417: p_app_name => 'FEM',
418: p_msg_name => 'FEM_GL_POST_215',
419: p_token1 => 'ERR_MSG',
420: p_value1 => SQLERRM);
421: FEM_ENGINES_PKG.User_Message
422: (p_app_name => 'FEM',
423: p_msg_name => 'FEM_GL_POST_215',
424: p_token1 => 'ERR_MSG',
425: p_value1 => SQLERRM);

Line 426: FEM_ENGINES_PKG.Tech_Message

422: (p_app_name => 'FEM',
423: p_msg_name => 'FEM_GL_POST_215',
424: p_token1 => 'ERR_MSG',
425: p_value1 => SQLERRM);
426: FEM_ENGINES_PKG.Tech_Message
427: (p_severity => pc_log_level_procedure,
428: p_module => 'fem.plsql.fem_intg_hier_eng.init.'||'exception ',
429: p_app_name => 'FEM',
430: p_msg_name => 'FEM_GL_POST_203',

Line 440: FEM_ENGINES_PKG.Tech_Message

436: return;
437: WHEN OTHERS THEN
438: ROLLBACK;
439: --raise;
440: FEM_ENGINES_PKG.Tech_Message
441: (p_severity => pc_log_level_unexpected,
442: p_module => 'fem.plsql.fem_intg_hier_eng.init.' ||'exception others',
443: p_app_name => 'FEM',
444: p_msg_name => 'FEM_GL_POST_215',

Line 447: FEM_ENGINES_PKG.Tech_Message

443: p_app_name => 'FEM',
444: p_msg_name => 'FEM_GL_POST_215',
445: p_token1 => 'ERR_MSG',
446: p_value1 => SQLERRM);
447: FEM_ENGINES_PKG.Tech_Message
448: (p_severity => pc_log_level_procedure,
449: p_module => 'fem.plsql.fem_intg_hier_eng.init.' || '',
450: p_app_name => 'FEM',
451: p_msg_name => 'FEM_GL_POST_203',

Line 493: FEM_ENGINES_PKG.Tech_Message

489: v_dimension_group_id NUMBER;
490: v_dim_group_name_seq NUMBER;
491: v_rel_dim_group_seq NUMBER;
492: BEGIN
493: FEM_ENGINES_PKG.Tech_Message
494: (p_severity => pc_log_level_procedure,
495: p_module => 'fem.plsql.fem_intg.hier_eng.Bld_Hier_Single_Segment',
496: p_app_name => 'FEM',
497: p_msg_name => 'FEM_GL_POST_201',

Line 504: FEM_ENGINES_PKG.Tech_Message

500: p_token2 => 'TIME',
501: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
502: x_completion_code := 0;
503: x_row_count_tot := 0;
504: FEM_ENGINES_PKG.Tech_Message
505: (p_severity => pc_log_level_procedure,
506: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Hier_Single_Segment.',
507: p_msg_text => ' pv_hier_obj_def_id:' || pv_hier_obj_def_id ||
508: ' pv_top_parent_id:' || pv_top_parent_id ||

Line 539: FEM_ENGINES_PKG.Tech_Message

535:
536:
537: v_row_count := SQL%ROWCOUNT;
538: x_row_count_tot := x_row_count_tot + v_row_count;
539: FEM_ENGINES_PKG.Tech_Message
540: (p_severity => pc_log_level_procedure,
541: p_module => 'fem.plsql.fem_intg_hier_eng.row_count.',
542: p_msg_text => 'v_row_count:' || v_row_count ||
543: ' x_row_count_tot:' || x_row_count_tot);

Line 548: FEM_ENGINES_PKG.Tech_Message

544: COMMIT;
545: v_parent_level := 1;
546: v_seq_name := 'FEM_INTG_HIER_SEQ_' || pv_req_id || '_S';
547: v_seq_stmt := 'CREATE SEQUENCE '||v_seq_name||' START WITH 2';
548: FEM_ENGINES_PKG.Tech_Message
549: (p_severity => pc_log_level_procedure,
550: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Hier_Single_Segment.',
551: p_app_name => 'FEM',
552: p_msg_name => 'FEM_GL_POST_204',

Line 566: FEM_ENGINES_PKG.Tech_Message

562: -- The exit condition is when the inserted number of row is 0
563: LOOP
564: -- to create level-based hierarchy
565: v_dim_group_name_seq := (v_parent_level+1)*100;
566: FEM_ENGINES_PKG.Tech_Message
567: (p_severity => pc_log_level_procedure,
568: p_module => 'fem.plsql.fem_intg_hier_eng.Infinite loop.',
569: p_msg_text => 'v_dim_group_name_seq:' || v_dim_group_name_seq);
570: -- Call API to create new dimension group

Line 591: FEM_ENGINES_PKG.Tech_Message

587: p_dim_group_description =>
588: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq);
589: END IF;
590:
591: FEM_ENGINES_PKG.Tech_Message
592: (p_severity => pc_log_level_procedure,
593: p_module => 'fem.plsql.fem_intg_hier_eng.Infinite loop.',
594: p_msg_text => 'v_dimension_group_id:' || v_dimension_group_id);
595: IF (v_API_return_status NOT IN ('S')) THEN

Line 596: FEM_ENGINES_PKG.Tech_Message

592: (p_severity => pc_log_level_procedure,
593: p_module => 'fem.plsql.fem_intg_hier_eng.Infinite loop.',
594: p_msg_text => 'v_dimension_group_id:' || v_dimension_group_id);
595: IF (v_API_return_status NOT IN ('S')) THEN
596: FEM_ENGINES_PKG.Tech_Message
597: (p_severity => pc_log_level_statement,
598: p_module => 'fem.plsql.fem_intg_hier_rule_eng_pkg.'||'return_status',
599: p_msg_text => 'v_API_return_status:' || v_API_return_status);
600: FEM_ENGINES_PKG.Tech_Message

Line 600: FEM_ENGINES_PKG.Tech_Message

596: FEM_ENGINES_PKG.Tech_Message
597: (p_severity => pc_log_level_statement,
598: p_module => 'fem.plsql.fem_intg_hier_rule_eng_pkg.'||'return_status',
599: p_msg_text => 'v_API_return_status:' || v_API_return_status);
600: FEM_ENGINES_PKG.Tech_Message
601: (p_severity => pc_log_level_statement,
602: p_module => 'fem.plsql.fem_intg_hier_rule_eng_pkg.'||'After create_dim_group',
603: p_msg_text => 'v_msg_data:' || v_msg_data);
604: FEM_ENGINES_PKG.User_Message

Line 604: FEM_ENGINES_PKG.User_Message

600: FEM_ENGINES_PKG.Tech_Message
601: (p_severity => pc_log_level_statement,
602: p_module => 'fem.plsql.fem_intg_hier_rule_eng_pkg.'||'After create_dim_group',
603: p_msg_text => 'v_msg_data:' || v_msg_data);
604: FEM_ENGINES_PKG.User_Message
605: (p_app_name => 'FEM',
606: p_msg_text => v_msg_data);
607: FEM_ENGINES_PKG.User_Message
608: (p_app_name => 'FEM',

Line 607: FEM_ENGINES_PKG.User_Message

603: p_msg_text => 'v_msg_data:' || v_msg_data);
604: FEM_ENGINES_PKG.User_Message
605: (p_app_name => 'FEM',
606: p_msg_text => v_msg_data);
607: FEM_ENGINES_PKG.User_Message
608: (p_app_name => 'FEM',
609: p_msg_name => 'FEM_INTG_FAIL_DIM_GRP');
610: RAISE FEM_INTG_fatal_err;
611: END IF;

Line 612: FEM_ENGINES_PKG.Tech_Message

608: (p_app_name => 'FEM',
609: p_msg_name => 'FEM_INTG_FAIL_DIM_GRP');
610: RAISE FEM_INTG_fatal_err;
611: END IF;
612: FEM_ENGINES_PKG.Tech_Message
613: (p_severity => pc_log_level_procedure,
614: p_module => 'fem.plsql.fem_intg_hier_eng.Infinite loop.',
615: p_msg_text => 'pv_hier_obj_def_id:' || pv_hier_obj_def_id ||
616: ' v_parent_level:' || v_parent_level ||

Line 654: FEM_ENGINES_PKG.Tech_Message

650: AND ff.flex_value
651: BETWEEN vh.child_flex_value_low
652: AND vh.child_flex_value_high
653: ORDER BY ff.flex_value';
654: FEM_ENGINES_PKG.Tech_Message
655: (p_severity => pc_log_level_procedure,
656: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Hier_Single_Segment.',
657: p_app_name => 'FEM',
658: p_msg_name => 'FEM_GL_POST_204',

Line 675: FEM_ENGINES_PKG.Tech_Message

671:
672:
673: x_row_count_tot := x_row_count_tot + v_row_count2;
674: COMMIT;
675: FEM_ENGINES_PKG.Tech_Message
676: (p_severity => pc_log_level_procedure,
677: p_module => 'fem.plsql.fem_intg_hier_eng.row_count.',
678: p_msg_text => 'v_row_count2:' || v_row_count2 ||
679: ' x_row_count_tot:' || x_row_count_tot);

Line 691: FEM_ENGINES_PKG.Tech_Message

687: from fem_intg_dim_hier_gt)
688: AND display_order_num = -1';
689:
690:
691: FEM_ENGINES_PKG.Tech_Message
692: (p_severity => pc_log_level_procedure,
693: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Hier_Single_Segment.seq.nextval',
694: p_app_name => 'FEM',
695: p_msg_name => 'FEM_GL_POST_204',

Line 708: FEM_ENGINES_PKG.Tech_Message

704: EXIT;
705: END IF;
706: IF (pv_new_hier_obj_created) THEN
707: v_rel_dim_group_seq := v_parent_level+1;
708: FEM_ENGINES_PKG.Tech_Message
709: (p_severity => pc_log_level_statement,
710: p_module => 'fem.plsql.'||'insert into fem_hier_dimension_grps',
711: p_msg_text => 'v_dimension_group_id:' || v_dimension_group_id ||
712: ' v_rel_dim_group_seq:' || v_rel_dim_group_seq);

Line 738: FEM_ENGINES_PKG.Tech_Message

734: pv_login_id,
735: 1);
736: END IF;
737: END IF;
738: FEM_ENGINES_PKG.Tech_Message
739: (p_severity => pc_log_level_procedure,
740: p_module => 'fem.plsql.fem_intg_hier_eng.',
741: p_msg_text => 'v_parent_level :' || v_parent_level );
742: v_parent_level := v_parent_level + 1;

Line 752: FEM_ENGINES_PKG.Tech_Message

748: RAISE FEM_INTG_fatal_err;
749: END IF;
750: -- to create level-based hierarchy for bottom level children
751: v_dim_group_name_seq := (v_parent_level+1)*100;
752: FEM_ENGINES_PKG.Tech_Message
753: (p_severity => pc_log_level_procedure,
754: p_module => 'fem.plsql.fem_intg_hier_eng.Infinite loop.',
755: p_msg_text => 'v_dim_group_name_seq:' || v_dim_group_name_seq);
756: -- Call API to create new dimension group

Line 777: FEM_ENGINES_PKG.Tech_Message

773: p_dim_group_description =>
774: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq);
775: END IF;
776:
777: FEM_ENGINES_PKG.Tech_Message
778: (p_severity => pc_log_level_procedure,
779: p_module => 'fem.plsql.fem_intg_hier_eng.',
780: p_msg_text => 'v_dimension_group_id:' || v_dimension_group_id);
781: IF (v_API_return_status NOT IN ('S')) THEN

Line 782: FEM_ENGINES_PKG.Tech_Message

778: (p_severity => pc_log_level_procedure,
779: p_module => 'fem.plsql.fem_intg_hier_eng.',
780: p_msg_text => 'v_dimension_group_id:' || v_dimension_group_id);
781: IF (v_API_return_status NOT IN ('S')) THEN
782: FEM_ENGINES_PKG.Tech_Message
783: (p_severity => pc_log_level_statement,
784: p_module => 'fem.plsql.fem_intg_hier_rule_eng_pkg.'||'return_status',
785: p_msg_text => 'v_API_return_status:' || v_API_return_status);
786: FEM_ENGINES_PKG.Tech_Message

Line 786: FEM_ENGINES_PKG.Tech_Message

782: FEM_ENGINES_PKG.Tech_Message
783: (p_severity => pc_log_level_statement,
784: p_module => 'fem.plsql.fem_intg_hier_rule_eng_pkg.'||'return_status',
785: p_msg_text => 'v_API_return_status:' || v_API_return_status);
786: FEM_ENGINES_PKG.Tech_Message
787: (p_severity => pc_log_level_statement,
788: p_module => 'fem.plsql.fem_intg_hier_rule_eng_pkg.'||'After create_dim_group',
789: p_msg_text => 'v_msg_data:' || v_msg_data);
790: FEM_ENGINES_PKG.User_Message

Line 790: FEM_ENGINES_PKG.User_Message

786: FEM_ENGINES_PKG.Tech_Message
787: (p_severity => pc_log_level_statement,
788: p_module => 'fem.plsql.fem_intg_hier_rule_eng_pkg.'||'After create_dim_group',
789: p_msg_text => 'v_msg_data:' || v_msg_data);
790: FEM_ENGINES_PKG.User_Message
791: (p_app_name => 'FEM',
792: p_msg_text => v_msg_data);
793: FEM_ENGINES_PKG.User_Message
794: (p_app_name => 'FEM',

Line 793: FEM_ENGINES_PKG.User_Message

789: p_msg_text => 'v_msg_data:' || v_msg_data);
790: FEM_ENGINES_PKG.User_Message
791: (p_app_name => 'FEM',
792: p_msg_text => v_msg_data);
793: FEM_ENGINES_PKG.User_Message
794: (p_app_name => 'FEM',
795: p_msg_name => 'FEM_INTG_FAIL_DIM_GRP');
796: RAISE FEM_INTG_fatal_err;
797: END IF;

Line 800: FEM_ENGINES_PKG.Tech_Message

796: RAISE FEM_INTG_fatal_err;
797: END IF;
798: IF (pv_new_hier_obj_created) THEN
799: v_rel_dim_group_seq := v_parent_level+1 ;
800: FEM_ENGINES_PKG.Tech_Message
801: (p_severity => pc_log_level_statement,
802: p_module => 'fem.plsql.'||'insert into fem_hier_dimension_grps',
803: p_msg_text => 'v_dimension_group_id:' || v_dimension_group_id ||
804: ' v_rel_dim_group_seq:' || v_rel_dim_group_seq);

Line 831: FEM_ENGINES_PKG.Tech_Message

827: 1);
828: END IF;
829: END IF;
830:
831: FEM_ENGINES_PKG.Tech_Message
832: (p_severity => pc_log_level_procedure,
833: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Hier_Single_Segment.',
834: p_msg_text => 'pv_hier_obj_def_id:' || pv_hier_obj_def_id ||
835: ' pv_dim_memb_col:' ||pv_dim_memb_col ||

Line 895: FEM_ENGINES_PKG.Tech_Message

891:
892:
893: v_row_count3 := SQL%ROWCOUNT;
894: x_row_count_tot := x_row_count_tot + v_row_count3;
895: FEM_ENGINES_PKG.Tech_Message
896: (p_severity => pc_log_level_procedure,
897: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Hier_Single_Segment',
898: p_app_name => 'FEM',
899: p_msg_name => 'FEM_GL_POST_204',

Line 915: FEM_ENGINES_PKG.Tech_Message

911: WHERE rowid in
912: (select rowid
913: from fem_intg_dim_hier_gt)
914: AND display_order_num = -1';
915: FEM_ENGINES_PKG.Tech_Message
916: (p_severity => pc_log_level_procedure,
917: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Hier_Single_Segment.seq.nextval',
918: p_app_name => 'FEM',
919: p_msg_name => 'FEM_GL_POST_204',

Line 926: FEM_ENGINES_PKG.Tech_Message

922: p_token2 => 'VAR_VAL',
923: p_value2 => v_sql_stmt);
924: EXECUTE IMMEDIATE v_sql_stmt;
925: v_seq_stmt := 'DROP SEQUENCE ' || v_seq_name;
926: FEM_ENGINES_PKG.Tech_Message
927: (p_severity => pc_log_level_procedure,
928: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Hier_Single_Segment',
929: p_app_name => 'FEM',
930: p_msg_name => 'FEM_GL_POST_204',

Line 938: FEM_ENGINES_PKG.Tech_Message

934: p_value2 => v_seq_stmt);
935: EXECUTE IMMEDIATE v_seq_stmt;
936: COMMIT;
937: x_completion_code := 0;
938: FEM_ENGINES_PKG.Tech_Message
939: (p_severity => pc_log_level_procedure,
940: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Hier_Single_Segment.',
941: p_app_name => 'FEM',
942: p_msg_name => 'FEM_GL_POST_202',

Line 951: FEM_ENGINES_PKG.Tech_Message

947: return;
948: EXCEPTION
949: WHEN FEM_INTG_fatal_err THEN
950: ROLLBACk;
951: FEM_ENGINES_PKG.Tech_Message
952: (p_severity => pc_log_level_unexpected,
953: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Hier_Single_Segment.' ||'FEM_INTG_fatal_err',
954: p_app_name => 'FEM',
955: p_msg_name => 'FEM_GL_POST_215',

Line 958: FEM_ENGINES_PKG.User_Message

954: p_app_name => 'FEM',
955: p_msg_name => 'FEM_GL_POST_215',
956: p_token1 => 'ERR_MSG',
957: p_value1 => SQLERRM);
958: FEM_ENGINES_PKG.User_Message
959: (p_app_name => 'FEM',
960: p_msg_name => 'FEM_GL_POST_215',
961: p_token1 => 'ERR_MSG',
962: p_value1 => SQLERRM);

Line 963: FEM_ENGINES_PKG.Tech_Message

959: (p_app_name => 'FEM',
960: p_msg_name => 'FEM_GL_POST_215',
961: p_token1 => 'ERR_MSG',
962: p_value1 => SQLERRM);
963: FEM_ENGINES_PKG.Tech_Message
964: (p_severity => pc_log_level_procedure,
965: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Hier_Single_Segment.' || 'FEM_INTG_fatal_err',
966: p_app_name => 'FEM',
967: p_msg_name => 'FEM_GL_POST_203',

Line 978: FEM_ENGINES_PKG.Tech_Message

974: WHEN OTHERS THEN
975: ROLLBACK;
976: IF (v_seq_name IS NOT NULL) THEN
977: v_seq_stmt := 'DROP SEQUENCE ' || v_seq_name;
978: FEM_ENGINES_PKG.Tech_Message
979: (p_severity => pc_log_level_procedure,
980: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Hier_Single_Segment.'
981: || 'exceptoin others',
982: p_app_name => 'FEM',

Line 991: FEM_ENGINES_PKG.Tech_Message

987: p_value2 => v_seq_stmt);
988: EXECUTE IMMEDIATE v_seq_stmt;
989: COMMIT;
990: END IF;
991: FEM_ENGINES_PKG.Tech_Message
992: (p_severity => pc_log_level_unexpected,
993: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Hier_Single_Segment.' || 'exceptoin others',
994: p_app_name => 'FEM',
995: p_msg_name => 'FEM_GL_POST_215',

Line 998: FEM_ENGINES_PKG.User_Message

994: p_app_name => 'FEM',
995: p_msg_name => 'FEM_GL_POST_215',
996: p_token1 => 'ERR_MSG',
997: p_value1 => SQLERRM);
998: FEM_ENGINES_PKG.User_Message
999: (p_app_name => 'FEM',
1000: p_msg_name => 'FEM_GL_POST_215',
1001: p_token1 => 'ERR_MSG',
1002: p_value1 => SQLERRM);

Line 1003: FEM_ENGINES_PKG.Tech_Message

999: (p_app_name => 'FEM',
1000: p_msg_name => 'FEM_GL_POST_215',
1001: p_token1 => 'ERR_MSG',
1002: p_value1 => SQLERRM);
1003: FEM_ENGINES_PKG.Tech_Message
1004: (p_severity => pc_log_level_procedure,
1005: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Hier_Single_Segment.' || 'exceptoin others',
1006: p_app_name => 'FEM',
1007: p_msg_name => 'FEM_GL_POST_203',

Line 1065: FEM_ENGINES_PKG.Tech_Message

1061: -- bug fix 4563603
1062:
1063: BEGIN
1064:
1065: FEM_ENGINES_PKG.Tech_Message
1066: (p_severity => pc_log_level_procedure,
1067: p_module => 'fem.plsql.fem_intg.hier_eng.Bld_Component_Hier',
1068: p_app_name => 'FEM',
1069: p_msg_name => 'FEM_GL_POST_201',

Line 1076: FEM_ENGINES_PKG.Tech_Message

1072: p_token2 => 'TIME',
1073: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
1074: x_completion_code := 0;
1075:
1076: FEM_ENGINES_PKG.Tech_Message
1077: (p_severity => pc_log_level_procedure,
1078: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Component_Hier.Dimension_Init.',
1079: p_msg_text => ' pv_hier_obj_def_id:' || pv_hier_obj_def_id ||
1080: ' pv_dim_rule_obj_id:' || pv_dim_rule_obj_id ||

Line 1138: FEM_ENGINES_PKG.Tech_Message

1134: if pv_traversal_rarray(i_hier_ctr).aol_vs_id <>
1135: FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(i_Concat).vs_id THEN
1136:
1137: -- set messages and have fatial error.
1138: FEM_ENGINES_PKG.Tech_Message
1139: (p_severity => pc_log_level_unexpected,
1140: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Component_Hier.VSID_MISSMATCH.' ,
1141: p_msg_text => 'Structure pv_mapped_segs().vs_id does not correspond to pv_traversal_rarray().aol_vs_id');
1142: RAISE FEM_INTG_fatal_err;

Line 1147: FEM_ENGINES_PKG.Tech_Message

1143:
1144: else
1145:
1146: -- Insert top node
1147: FEM_ENGINES_PKG.Tech_Message
1148: (p_severity => pc_log_level_procedure,
1149: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Component_Hier.Main_Loop.',
1150: p_msg_text => ' pv_hier_obj_def_id:' || pv_hier_obj_def_id ||
1151: ' traversal display_order:' || pv_traversal_rarray(i_hier_ctr).display_order ||

Line 1271: FEM_ENGINES_PKG.Tech_Message

1267: END CASE; -- End initial insert
1268:
1269: v_row_count := SQL%ROWCOUNT;
1270:
1271: FEM_ENGINES_PKG.Tech_Message
1272: (p_severity => pc_log_level_procedure,
1273: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Component_Hier.row_count.',
1274: p_msg_text => 'traversal hierarchy_obj_def_id:' || pv_traversal_rarray(i_hier_ctr).display_order ||
1275: ' v_row_count:' || v_row_count);

Line 1285: FEM_ENGINES_PKG.Tech_Message

1281: v_parent_level := 1;
1282: v_seq_name := 'FEM_INTG_HIER_SEQ_' || pv_req_id || '_S';
1283: v_seq_stmt := 'CREATE SEQUENCE '||v_seq_name||' START WITH 2';
1284:
1285: FEM_ENGINES_PKG.Tech_Message
1286: (p_severity => pc_log_level_procedure,
1287: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Component_Hier.',
1288: p_app_name => 'FEM',
1289: p_msg_name => 'FEM_GL_POST_204',

Line 1299: FEM_ENGINES_PKG.Tech_Message

1295:
1296: -- Insert immediate children for each parent into the _GT table
1297: LOOP
1298:
1299: FEM_ENGINES_PKG.Tech_Message
1300: (p_severity => pc_log_level_procedure,
1301: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Component_Hier.Intermediate_Loop.',
1302: p_msg_text => 'pv_hier_obj_def_id:' || pv_hier_obj_def_id ||
1303: ' traversal hierarchy_obj_def_id:' || pv_traversal_rarray(i_hier_ctr).display_order ||

Line 1481: FEM_ENGINES_PKG.Tech_Message

1477: END CASE; -- Finish finding immediate children that are also parent values
1478:
1479: v_row_count2 := SQL%ROWCOUNT;
1480:
1481: FEM_ENGINES_PKG.Tech_Message
1482: (p_severity => pc_log_level_procedure,
1483: p_module => 'fem.plsql.fem_intg.hier_eng.Bld_Component_Hier.Intermediate_Inserted.',
1484: p_msg_text => ' v_row_count2:' || v_row_count2 ||
1485: ' v_parent_level :' || v_parent_level );

Line 1499: FEM_ENGINES_PKG.Tech_Message

1495: 'UPDATE fem_intg_dim_hier_c' || pv_traversal_rarray(i_hier_ctr).display_order || '_gt
1496: SET display_order_num = '||v_seq_name||'.nextval
1497: WHERE display_order_num = -1';
1498:
1499: FEM_ENGINES_PKG.Tech_Message
1500: (p_severity => pc_log_level_procedure,
1501: p_module => 'fem.plsql.fem_intg_hier_eng.hier_eng.Bld_Component_Hier.seq.nextval',
1502: p_app_name => 'FEM',
1503: p_msg_name => 'FEM_GL_POST_204',

Line 1521: FEM_ENGINES_PKG.Tech_Message

1517: WHEN 'N' THEN
1518:
1519: -- bottom level detail from fnd_flex_values
1520:
1521: FEM_ENGINES_PKG.Tech_Message
1522: (p_severity => pc_log_level_procedure,
1523: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Component_Hier.Bottom_Standard.',
1524: p_msg_text => 'pv_hier_obj_def_id:' || pv_hier_obj_def_id ||
1525: ' traversal hierarchy_obj_def_id:' || pv_traversal_rarray(i_hier_ctr).display_order);

Line 1734: FEM_ENGINES_PKG.Tech_Message

1730: AND vh.child_flex_value_high
1731: ORDER BY MEANING
1732: */
1733:
1734: FEM_ENGINES_PKG.Tech_Message
1735: (p_severity => pc_log_level_procedure,
1736: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Component_Hier.Bottom_User_table.',
1737: p_msg_text => 'pv_hier_obj_def_id:' || pv_hier_obj_def_id ||
1738: ' traversal hierarchy_obj_def_id:' || pv_traversal_rarray(i_hier_ctr).display_order);

Line 1792: FEM_ENGINES_PKG.Tech_Message

1788: ORDER BY ' || FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(i_Concat).val_col_name ;
1789: -- concatenate three sections
1790: V_sql_stmt := V_sql_stmt_start || v_where || V_sql_stmt_end;
1791:
1792: FEM_ENGINES_PKG.Tech_Message
1793: (p_severity => pc_log_level_procedure,
1794: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Component_Hier',
1795: p_app_name => 'FEM',
1796: p_msg_name => 'FEM_GL_POST_204',

Line 1807: FEM_ENGINES_PKG.Tech_Message

1803: v_row_count3 := SQL%ROWCOUNT;
1804:
1805: END CASE; -- end bottom leaf inserts
1806:
1807: FEM_ENGINES_PKG.Tech_Message
1808: (p_severity => pc_log_level_procedure,
1809: p_module => 'fem.plsql.fem_intg.hier_eng.Bld_Component_Hier.Bottom_level.',
1810: p_msg_text => ' v_row_count3:' || v_row_count3 ||
1811: ' v_parent_level :' || v_parent_level);

Line 1895: FEM_ENGINES_PKG.Tech_Message

1891: null;
1892: END;
1893:
1894: IF (v_duplicate_parent = 'Duplicate') THEN
1895: FEM_ENGINES_PKG.Tech_Message
1896: (p_severity => pc_log_level_procedure,
1897: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Component_Hier.' || 'duplicate',
1898: p_app_name => 'FEM',
1899: p_msg_name => 'FEM_INTG_HIER_MULTI_PARENT_ERR',

Line 1904: FEM_ENGINES_PKG.User_Message

1900: p_token1 => 'VAR_NAME',
1901: p_value1 => 'v_duplicate_parent',
1902: p_token2 => 'VAR_VAL',
1903: p_value2 => v_duplicate_parent);
1904: FEM_ENGINES_PKG.User_Message
1905: (p_app_name => 'FEM',
1906: p_msg_name => 'FEM_INTG_HIER_MULTI_PARENT_ERR');
1907:
1908: --bug fix 4563603

Line 1909: FEM_ENGINES_PKG.Tech_Message

1905: (p_app_name => 'FEM',
1906: p_msg_name => 'FEM_INTG_HIER_MULTI_PARENT_ERR');
1907:
1908: --bug fix 4563603
1909: FEM_ENGINES_PKG.Tech_Message
1910: (p_severity => pc_log_level_procedure,
1911: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Component_Hier.' || 'duplicate',
1912: p_app_name => 'FEM',
1913: p_msg_text => ' ');

Line 1915: FEM_ENGINES_PKG.User_Message

1911: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Component_Hier.' || 'duplicate',
1912: p_app_name => 'FEM',
1913: p_msg_text => ' ');
1914:
1915: FEM_ENGINES_PKG.User_Message
1916: (p_app_name => 'FEM',
1917: p_msg_text => ' ');
1918:
1919: FEM_ENGINES_PKG.Tech_Message

Line 1919: FEM_ENGINES_PKG.Tech_Message

1915: FEM_ENGINES_PKG.User_Message
1916: (p_app_name => 'FEM',
1917: p_msg_text => ' ');
1918:
1919: FEM_ENGINES_PKG.Tech_Message
1920: (p_severity => pc_log_level_procedure,
1921: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Component_Hier.' || 'duplicate',
1922: p_app_name => 'FEM',
1923: p_msg_name => 'FEM_INTG_HIER_MULT_PARENTS');

Line 1925: FEM_ENGINES_PKG.User_Message

1921: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Component_Hier.' || 'duplicate',
1922: p_app_name => 'FEM',
1923: p_msg_name => 'FEM_INTG_HIER_MULT_PARENTS');
1924:
1925: FEM_ENGINES_PKG.User_Message
1926: (p_app_name => 'FEM',
1927: p_msg_name => 'FEM_INTG_HIER_MULT_PARENTS');
1928:
1929: OPEN c_child_of_multi_parent FOR

Line 1957: FEM_ENGINES_PKG.Tech_Message

1953: END LOOP;
1954: CLOSE c_multi_parent;
1955: v_offending_parents_list := SUBSTR(v_offending_parents_list,1,LENGTH(v_offending_parents_list)-2);
1956:
1957: FEM_ENGINES_PKG.Tech_Message
1958: (p_severity => pc_log_level_procedure,
1959: p_module => 'fem.plsql.fem_intg.hier_eng.',
1960: p_app_name => 'FEM',
1961: p_msg_name => 'FEM_INTG_HIER_PARENT_CHILD_LST',

Line 1966: FEM_ENGINES_PKG.User_Message

1962: p_token1 => 'CHILD',
1963: p_value1 => v_display_code,
1964: p_token2 => 'PARENTS',
1965: p_value2 => v_offending_parents_list);
1966: FEM_ENGINES_PKG.User_Message
1967: (p_app_name => 'FEM',
1968: p_msg_name => 'FEM_INTG_HIER_PARENT_CHILD_LST',
1969: p_token1 => 'CHILD',
1970: p_value1 => v_display_code,

Line 1977: FEM_ENGINES_PKG.Tech_Message

1973:
1974: END LOOP;
1975:
1976: CLOSE c_child_of_multi_parent;
1977: FEM_ENGINES_PKG.Tech_Message
1978: (p_severity => pc_log_level_procedure,
1979: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Component_Hier.' || 'duplicate',
1980: p_app_name => 'FEM',
1981: p_msg_text => ' ');

Line 1983: FEM_ENGINES_PKG.User_Message

1979: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Component_Hier.' || 'duplicate',
1980: p_app_name => 'FEM',
1981: p_msg_text => ' ');
1982:
1983: FEM_ENGINES_PKG.User_Message
1984: (p_app_name => 'FEM',
1985: p_msg_text => ' ');
1986: --bug fix 4563603
1987:

Line 1998: FEM_ENGINES_PKG.Tech_Message

1994: END loop; -- Main Loop for traversing each component hierarchy
1995:
1996: x_completion_code := 0;
1997:
1998: FEM_ENGINES_PKG.Tech_Message
1999: (p_severity => pc_log_level_procedure,
2000: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Component_Hier.',
2001: p_app_name => 'FEM',
2002: p_msg_name => 'FEM_GL_POST_202',

Line 2014: FEM_ENGINES_PKG.Tech_Message

2010:
2011: EXCEPTION
2012: WHEN FEM_INTG_fatal_err THEN
2013: ROLLBACK;
2014: FEM_ENGINES_PKG.Tech_Message
2015: (p_severity => pc_log_level_unexpected,
2016: p_module => 'fem.plsql.fem_intg.hier_eng.Bld_Component_Hier.' ||'FEM_INTG_fatal_err',
2017: p_app_name => 'FEM',
2018: p_msg_name => 'FEM_GL_POST_215',

Line 2021: FEM_ENGINES_PKG.User_Message

2017: p_app_name => 'FEM',
2018: p_msg_name => 'FEM_GL_POST_215',
2019: p_token1 => 'ERR_MSG',
2020: p_value1 => SQLERRM);
2021: FEM_ENGINES_PKG.User_Message
2022: (p_app_name => 'FEM',
2023: p_msg_name => 'FEM_GL_POST_215',
2024: p_token1 => 'ERR_MSG',
2025: p_value1 => SQLERRM);

Line 2026: FEM_ENGINES_PKG.Tech_Message

2022: (p_app_name => 'FEM',
2023: p_msg_name => 'FEM_GL_POST_215',
2024: p_token1 => 'ERR_MSG',
2025: p_value1 => SQLERRM);
2026: FEM_ENGINES_PKG.Tech_Message
2027: (p_severity => pc_log_level_procedure,
2028: p_module => 'fem.plsql.fem_intg.hier_eng.Bld_Component_Hier.' || 'FEM_INTG_fatal_err',
2029: p_app_name => 'FEM',
2030: p_msg_name => 'FEM_GL_POST_203',

Line 2041: FEM_ENGINES_PKG.Tech_Message

2037: WHEN OTHERS THEN
2038: ROLLBACK;
2039: IF (v_seq_name IS NOT NULL) THEN
2040: v_seq_stmt := 'DROP SEQUENCE ' || v_seq_name;
2041: FEM_ENGINES_PKG.Tech_Message
2042: (p_severity => pc_log_level_procedure,
2043: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Component_Hier.'
2044: || 'exceptoin others',
2045: p_app_name => 'FEM',

Line 2054: FEM_ENGINES_PKG.Tech_Message

2050: p_value2 => v_seq_stmt);
2051: EXECUTE IMMEDIATE v_seq_stmt;
2052: COMMIT;
2053: END IF;
2054: FEM_ENGINES_PKG.Tech_Message
2055: (p_severity => pc_log_level_unexpected,
2056: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Component_Hier.' || 'exceptoin others',
2057: p_app_name => 'FEM',
2058: p_msg_name => 'FEM_GL_POST_215',

Line 2061: FEM_ENGINES_PKG.User_Message

2057: p_app_name => 'FEM',
2058: p_msg_name => 'FEM_GL_POST_215',
2059: p_token1 => 'ERR_MSG',
2060: p_value1 => SQLERRM);
2061: FEM_ENGINES_PKG.User_Message
2062: (p_app_name => 'FEM',
2063: p_msg_name => 'FEM_GL_POST_215',
2064: p_token1 => 'ERR_MSG',
2065: p_value1 => SQLERRM);

Line 2066: FEM_ENGINES_PKG.Tech_Message

2062: (p_app_name => 'FEM',
2063: p_msg_name => 'FEM_GL_POST_215',
2064: p_token1 => 'ERR_MSG',
2065: p_value1 => SQLERRM);
2066: FEM_ENGINES_PKG.Tech_Message
2067: (p_severity => pc_log_level_procedure,
2068: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Component_Hier.' || 'exceptoin others',
2069: p_app_name => 'FEM',
2070: p_msg_name => 'FEM_GL_POST_203',

Line 2119: FEM_ENGINES_PKG.Tech_Message

2115: v_seq_name VARCHAR2(30);
2116: v_seq_stmt VARCHAR2(2000);
2117: v_sql_stmt VARCHAR2(2000);
2118: BEGIN
2119: FEM_ENGINES_PKG.Tech_Message
2120: (p_severity => pc_log_level_procedure,
2121: p_module => 'fem.plsql.fem_intg.hier_eng.Bld_Hier_Multi_Segment',
2122: p_app_name => 'FEM',
2123: p_msg_name => 'FEM_GL_POST_201',

Line 2306: FEM_ENGINES_PKG.Tech_Message(

2302:
2303: -- execute the SQL to insert the leaf nodes
2304: select count(*) into v_debug from FEM_INTG_DIM_HIER_GT;
2305:
2306: FEM_ENGINES_PKG.Tech_Message(
2307: p_severity => pc_log_level_statement,
2308: p_module => 'fem.plsql.Bld_Hier_Multi_Segment1',
2309: p_msg_text => v_sql);
2310:

Line 2450: FEM_ENGINES_PKG.Tech_Message(

2446: AND gts.child_display_code <> gts.parent_display_code
2447: and not exists (select 1 from FEM_INTG_DIM_HIER_GT gte where gte.child_display_code = gtm.parent_display_code))';
2448: select count(*) into v_debug from FEM_INTG_DIM_HIER_GT;
2449:
2450: FEM_ENGINES_PKG.Tech_Message(
2451: p_severity => pc_log_level_statement,
2452: p_module => 'fem.plsql.Bld_Hier_Multi_Segment2',
2453: p_msg_text => v_sql);
2454:

Line 2515: FEM_ENGINES_PKG.Tech_Message

2511: p_dim_group_description => FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label ||' '|| v_dim_group_name_seq
2512: );
2513: END IF;
2514: IF (v_API_return_status NOT IN ('S')) THEN
2515: FEM_ENGINES_PKG.Tech_Message
2516: (p_severity => pc_log_level_statement,
2517: p_module => 'fem.plsql.fem_intg_hier_rule_eng_pkg.'||'return_status',
2518: p_msg_text => 'v_API_return_status:' || v_API_return_status);
2519: FEM_ENGINES_PKG.Tech_Message

Line 2519: FEM_ENGINES_PKG.Tech_Message

2515: FEM_ENGINES_PKG.Tech_Message
2516: (p_severity => pc_log_level_statement,
2517: p_module => 'fem.plsql.fem_intg_hier_rule_eng_pkg.'||'return_status',
2518: p_msg_text => 'v_API_return_status:' || v_API_return_status);
2519: FEM_ENGINES_PKG.Tech_Message
2520: (p_severity => pc_log_level_statement,
2521: p_module => 'fem.plsql.fem_intg_hier_rule_eng_pkg.'||'After create_dim_group',
2522: p_msg_text => 'v_msg_data:' || v_msg_data);
2523: FEM_ENGINES_PKG.User_Message

Line 2523: FEM_ENGINES_PKG.User_Message

2519: FEM_ENGINES_PKG.Tech_Message
2520: (p_severity => pc_log_level_statement,
2521: p_module => 'fem.plsql.fem_intg_hier_rule_eng_pkg.'||'After create_dim_group',
2522: p_msg_text => 'v_msg_data:' || v_msg_data);
2523: FEM_ENGINES_PKG.User_Message
2524: (p_app_name => 'FEM',
2525: p_msg_text => v_msg_data);
2526: FEM_ENGINES_PKG.User_Message
2527: (p_app_name => 'FEM',

Line 2526: FEM_ENGINES_PKG.User_Message

2522: p_msg_text => 'v_msg_data:' || v_msg_data);
2523: FEM_ENGINES_PKG.User_Message
2524: (p_app_name => 'FEM',
2525: p_msg_text => v_msg_data);
2526: FEM_ENGINES_PKG.User_Message
2527: (p_app_name => 'FEM',
2528: p_msg_name => 'FEM_INTG_FAIL_DIM_GRP');
2529: RAISE FEM_INTG_fatal_err;
2530: END IF;

Line 2546: FEM_ENGINES_PKG.Tech_Message(

2542: 'UPDATE fem_intg_dim_hier_gt
2543: SET display_order_num = '||v_seq_name||'.nextval
2544: WHERE child_depth_num = '||v_counter||' AND display_order_num = -1';
2545:
2546: FEM_ENGINES_PKG.Tech_Message(
2547: p_severity => pc_log_level_statement,
2548: p_module => 'fem.plsql.Bld_Hier_Multi_Segment3',
2549: p_msg_text => v_sql_stmt);
2550:

Line 2554: FEM_ENGINES_PKG.Tech_Message(

2550:
2551: EXECUTE IMMEDIATE v_sql_stmt;
2552: COMMIT;
2553: IF (pv_new_hier_obj_created) THEN
2554: FEM_ENGINES_PKG.Tech_Message(
2555: p_severity => pc_log_level_statement,
2556: p_module => 'fem.plsql.'||'insert into fem_hier_dimension_grps',
2557: p_msg_text => 'v_dimension_group_id:' || v_dimension_group_id || ' v_rel_dim_group_seq:' || v_counter);
2558: -- 14OCT2005 b4652450 first is already added from call in Main()

Line 2603: FEM_ENGINES_PKG.Tech_Message(

2599: v_sql := v_sql || ' where b1.' || FEM_INTG_DIM_RULE_ENG_PKG.pv_member_display_code_col || ' = gt.parent_display_code and b1.VALUE_SET_ID = :pv_dim_vs_id)';
2600: v_sql := v_sql || ', gt.child_id = (select distinct b2.' || fem_intg_new_dim_member_pkg.pv_local_member_col || ' from ' || FEM_INTG_DIM_RULE_ENG_PKG.pv_member_b_table_name || ' b2 ';
2601: v_sql := v_sql || ' where b2.' || FEM_INTG_DIM_RULE_ENG_PKG.pv_member_display_code_col || ' = gt.child_display_code and b2.VALUE_SET_ID = :pv_dim_vs_id)';
2602:
2603: FEM_ENGINES_PKG.Tech_Message(
2604: p_severity => pc_log_level_statement,
2605: p_module => 'fem.plsql.Bld_Hier_Multi_Segment4',
2606: p_msg_text => v_sql);
2607:

Line 2704: FEM_ENGINES_PKG.Tech_Message

2700: -- FEM_INTG_PROC_SUCCESS and the number of output rows will be the
2701: -- return row count from the hierarchy building routine
2702: -- 8. Call the Concurrent Program DHMHVFLW to flatten out every hierarchy
2703: -- version after it has been pushed in FEM
2704: FEM_ENGINES_PKG.Tech_Message
2705: (p_severity => pc_log_level_procedure,
2706: p_module => 'fem.plsql.fem_intg.hier_eng.main',
2707: p_app_name => 'FEM',
2708: p_msg_name => 'FEM_GL_POST_201',

Line 2731: FEM_ENGINES_PKG.Tech_Message

2727: AND o.object_type_code='OGL_INTG_HIER_RULE';
2728: EXCEPTION
2729: -- p_hier_rule_obj_def_id is invalid
2730: WHEN NO_DATA_FOUND THEN
2731: FEM_ENGINES_PKG.Tech_Message
2732: (p_severity => pc_log_level_procedure,
2733: p_module => 'fem.plsql.fem_intg.hier_eng.main.no_data_found',
2734: p_app_name => 'FEM',
2735: p_msg_name => 'FEM_INTG_HIER_OBJ_NOTFOUND_ERR',

Line 2738: FEM_ENGINES_PKG.User_Message

2734: p_app_name => 'FEM',
2735: p_msg_name => 'FEM_INTG_HIER_OBJ_NOTFOUND_ERR',
2736: p_token1 => 'ERR_MSG',
2737: p_value1 => SQLERRM);
2738: FEM_ENGINES_PKG.User_Message
2739: (p_app_name => 'FEM',
2740: p_msg_name => 'FEM_INTG_HIER_OBJ_NOTFOUND_ERR',
2741: p_token1 => 'ERR_MSG',
2742: p_value1 => SQLERRM);

Line 2745: FEM_ENGINES_PKG.Tech_Message

2741: p_token1 => 'ERR_MSG',
2742: p_value1 => SQLERRM);
2743: RAISE FEM_INTG_fatal_err;
2744: END;
2745: FEM_ENGINES_PKG.Tech_Message
2746: (p_severity => pc_log_level_statement,
2747: p_module => 'fem.plsql.fem_intg_hier_rule_eng_pkg',
2748: p_msg_text => 'pv_user_id:' || pv_user_id
2749: ||' pv_folder_id:'||pv_folder_id);

Line 2751: FEM_ENGINES_PKG.Tech_Message

2747: p_module => 'fem.plsql.fem_intg_hier_rule_eng_pkg',
2748: p_msg_text => 'pv_user_id:' || pv_user_id
2749: ||' pv_folder_id:'||pv_folder_id);
2750:
2751: FEM_ENGINES_PKG.Tech_Message
2752: (p_severity => pc_log_level_statement,
2753: p_module => 'fem.plsql.fem_intg_hier_rule_eng_pkg',
2754: p_msg_text => 'pv_hier_rule_obj_id:' || pv_hier_rule_obj_id
2755: ||' pv_hier_rule_obj_def_id:'|| pv_hier_rule_obj_def_id);

Line 2801: FEM_ENGINES_PKG.Tech_Message

2797: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label || ' 100',
2798: p_dim_group_description =>
2799: FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label || ' 100');
2800: END IF;
2801: FEM_ENGINES_PKG.Tech_Message
2802: (p_severity => pc_log_level_procedure,
2803: p_module => 'fem.plsql.fem_intg_hier_eng.Infinite loop.',
2804: p_msg_text => 'pv_top_dimension_group_id:' || pv_top_dimension_group_id);
2805: IF (v_API_return_status NOT IN ('S')) THEN

Line 2806: FEM_ENGINES_PKG.Tech_Message

2802: (p_severity => pc_log_level_procedure,
2803: p_module => 'fem.plsql.fem_intg_hier_eng.Infinite loop.',
2804: p_msg_text => 'pv_top_dimension_group_id:' || pv_top_dimension_group_id);
2805: IF (v_API_return_status NOT IN ('S')) THEN
2806: FEM_ENGINES_PKG.Tech_Message
2807: (p_severity => pc_log_level_statement,
2808: p_module => 'fem.plsql.fem_intg_hier_rule_eng_pkg.'||'return_status',
2809: p_msg_text => 'v_API_return_status:' || v_API_return_status);
2810: FEM_ENGINES_PKG.Tech_Message

Line 2810: FEM_ENGINES_PKG.Tech_Message

2806: FEM_ENGINES_PKG.Tech_Message
2807: (p_severity => pc_log_level_statement,
2808: p_module => 'fem.plsql.fem_intg_hier_rule_eng_pkg.'||'return_status',
2809: p_msg_text => 'v_API_return_status:' || v_API_return_status);
2810: FEM_ENGINES_PKG.Tech_Message
2811: (p_severity => pc_log_level_statement,
2812: p_module => 'fem.plsql.fem_intg_hier_rule_eng_pkg.'||'After create_dim_group',
2813: p_msg_text => 'v_msg_data:' || v_msg_data);
2814: FEM_ENGINES_PKG.User_Message

Line 2814: FEM_ENGINES_PKG.User_Message

2810: FEM_ENGINES_PKG.Tech_Message
2811: (p_severity => pc_log_level_statement,
2812: p_module => 'fem.plsql.fem_intg_hier_rule_eng_pkg.'||'After create_dim_group',
2813: p_msg_text => 'v_msg_data:' || v_msg_data);
2814: FEM_ENGINES_PKG.User_Message
2815: (p_app_name => 'FEM',
2816: p_msg_text => v_msg_data);
2817: FEM_ENGINES_PKG.User_Message
2818: (p_app_name => 'FEM',

Line 2817: FEM_ENGINES_PKG.User_Message

2813: p_msg_text => 'v_msg_data:' || v_msg_data);
2814: FEM_ENGINES_PKG.User_Message
2815: (p_app_name => 'FEM',
2816: p_msg_text => v_msg_data);
2817: FEM_ENGINES_PKG.User_Message
2818: (p_app_name => 'FEM',
2819: p_msg_name => 'FEM_INTG_FAIL_DIM_GRP');
2820: RAISE FEM_INTG_fatal_err;
2821: END IF;

Line 2862: FEM_ENGINES_PKG.Tech_Message

2858: p_val_set_id1 => pv_dim_vs_id,
2859: p_dim_grp_id1 => l_temp_top_dimension_group_id,
2860: p_flat_rows_flag => pv_flatten_hier_flag);
2861: IF (v_API_return_status NOT IN ('S')) THEN
2862: FEM_ENGINES_PKG.Tech_Message
2863: (p_severity => pc_log_level_statement,
2864: p_module => 'fem.plsql.fem_intg_hier_rule_eng_pkg.'||'return_status',
2865: p_msg_text => 'v_API_return_status:' || v_API_return_status);
2866: FEM_ENGINES_PKG.Tech_Message

Line 2866: FEM_ENGINES_PKG.Tech_Message

2862: FEM_ENGINES_PKG.Tech_Message
2863: (p_severity => pc_log_level_statement,
2864: p_module => 'fem.plsql.fem_intg_hier_rule_eng_pkg.'||'return_status',
2865: p_msg_text => 'v_API_return_status:' || v_API_return_status);
2866: FEM_ENGINES_PKG.Tech_Message
2867: (p_severity => pc_log_level_statement,
2868: p_module => 'fem.plsql.fem_intg_hier_eng.' ||'after New_Hier_Object',
2869: p_msg_text => 'v_msg_data:' || v_msg_data);
2870: FEM_ENGINES_PKG.User_Message

Line 2870: FEM_ENGINES_PKG.User_Message

2866: FEM_ENGINES_PKG.Tech_Message
2867: (p_severity => pc_log_level_statement,
2868: p_module => 'fem.plsql.fem_intg_hier_eng.' ||'after New_Hier_Object',
2869: p_msg_text => 'v_msg_data:' || v_msg_data);
2870: FEM_ENGINES_PKG.User_Message
2871: (p_app_name => 'FEM',
2872: p_msg_text => v_msg_data);
2873: FEM_ENGINES_PKG.User_Message
2874: (p_app_name => 'FEM',

Line 2873: FEM_ENGINES_PKG.User_Message

2869: p_msg_text => 'v_msg_data:' || v_msg_data);
2870: FEM_ENGINES_PKG.User_Message
2871: (p_app_name => 'FEM',
2872: p_msg_text => v_msg_data);
2873: FEM_ENGINES_PKG.User_Message
2874: (p_app_name => 'FEM',
2875: p_msg_name => 'FEM_INTG_FAIL_NEW_HIER');
2876: RAISE FEM_INTG_fatal_err;
2877: END IF;

Line 2879: FEM_ENGINES_PKG.Tech_Message

2875: p_msg_name => 'FEM_INTG_FAIL_NEW_HIER');
2876: RAISE FEM_INTG_fatal_err;
2877: END IF;
2878: pv_new_hier_obj_created := TRUE;
2879: FEM_ENGINES_PKG.Tech_Message
2880: (p_severity => pc_log_level_statement,
2881: p_module => 'fem.plsql.fem_intg_hier_eng.' ||'after New_Hier_Object',
2882: p_msg_text => 'pv_hier_obj_id:' || pv_hier_obj_id||
2883: ' pv_hier_obj_def_id:' || pv_hier_obj_def_id);

Line 2923: FEM_ENGINES_PKG.Tech_Message

2919: p_effective_start_date => pv_hier_rule_start_date,
2920: p_effective_end_date => pv_hier_rule_end_date,
2921: p_object_origin_code => 'USER');
2922: IF (v_API_return_status NOT IN ('S')) THEN
2923: FEM_ENGINES_PKG.Tech_Message
2924: (p_severity => pc_log_level_statement,
2925: p_module => 'fem.plsql.fem_intg_hier_rule_eng_pkg.'||'return_status',
2926: p_msg_text => 'v_API_return_status:' || v_API_return_status);
2927: FEM_ENGINES_PKG.Tech_Message

Line 2927: FEM_ENGINES_PKG.Tech_Message

2923: FEM_ENGINES_PKG.Tech_Message
2924: (p_severity => pc_log_level_statement,
2925: p_module => 'fem.plsql.fem_intg_hier_rule_eng_pkg.'||'return_status',
2926: p_msg_text => 'v_API_return_status:' || v_API_return_status);
2927: FEM_ENGINES_PKG.Tech_Message
2928: (p_severity => pc_log_level_statement,
2929: p_module => 'fem.plsql.fem_intg_hier_eng.' ||'after New_Hier_Object_Def',
2930: p_msg_text => 'v_msg_data:' || v_msg_data);
2931: FEM_ENGINES_PKG.User_Message

Line 2931: FEM_ENGINES_PKG.User_Message

2927: FEM_ENGINES_PKG.Tech_Message
2928: (p_severity => pc_log_level_statement,
2929: p_module => 'fem.plsql.fem_intg_hier_eng.' ||'after New_Hier_Object_Def',
2930: p_msg_text => 'v_msg_data:' || v_msg_data);
2931: FEM_ENGINES_PKG.User_Message
2932: (p_app_name => 'FEM',
2933: p_msg_text => v_msg_data);
2934: FEM_ENGINES_PKG.User_Message
2935: (p_app_name => 'FEM',

Line 2934: FEM_ENGINES_PKG.User_Message

2930: p_msg_text => 'v_msg_data:' || v_msg_data);
2931: FEM_ENGINES_PKG.User_Message
2932: (p_app_name => 'FEM',
2933: p_msg_text => v_msg_data);
2934: FEM_ENGINES_PKG.User_Message
2935: (p_app_name => 'FEM',
2936: p_msg_name => 'FEM_INTG_FAIL_NEW_HIER');
2937: RAISE FEM_INTG_fatal_err;
2938: END IF;

Line 2939: FEM_ENGINES_PKG.Tech_Message

2935: (p_app_name => 'FEM',
2936: p_msg_name => 'FEM_INTG_FAIL_NEW_HIER');
2937: RAISE FEM_INTG_fatal_err;
2938: END IF;
2939: FEM_ENGINES_PKG.Tech_Message
2940: (p_severity => pc_log_level_statement,
2941: p_module => 'fem.plsql.fem_intg_hier_eng.' ||'after New_Hier_Object_Def',
2942: p_msg_text => 'pv_hier_obj_id:' || pv_hier_obj_id||
2943: ' pv_hier_obj_def_id:' || pv_hier_obj_def_id);

Line 2961: FEM_ENGINES_PKG.User_Message

2957: FEM_PL_PKG.Obj_Def_Data_Edit_Lock_Exists(
2958: p_object_definition_id => pv_hier_obj_def_id,
2959: x_data_edit_lock_exists => v_data_edit_lock_exists);
2960: IF (v_data_edit_lock_exists = 'T') THEN
2961: FEM_ENGINES_PKG.User_Message
2962: (p_app_name => 'FEM',
2963: p_msg_name => 'FEM_INTG_DATA_LOCK_EXIST');
2964: RAISE FEM_INTG_fatal_err;
2965: END IF;

Line 2968: FEM_ENGINES_PKG.Tech_Message

2964: RAISE FEM_INTG_fatal_err;
2965: END IF;
2966: END IF;
2967: IF (pv_dim_mapping_option_code = 'SINGLESEG') THEN
2968: FEM_ENGINES_PKG.Tech_Message
2969: (p_severity => pc_log_level_statement,
2970: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Hier_Single_Segment',
2971: p_msg_text => 'pv_dim_mapping_option_code:' || pv_dim_mapping_option_code);
2972: Bld_Hier_Single_Segment

Line 2981: FEM_ENGINES_PKG.Tech_Message

2977: RAISE FEM_INTG_fatal_err;
2978: END IF;
2979: -- MULTISEG Hierarchy case
2980: ELSIF (pv_dim_mapping_option_code = 'MULTISEG') THEN
2981: FEM_ENGINES_PKG.Tech_Message
2982: (p_severity => pc_log_level_statement,
2983: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_component_Hiers',
2984: p_msg_text => 'pv_dim_mapping_option_code:' || pv_dim_mapping_option_code);
2985: -- Build single segment component hierarchies as basis for concatenated hierarcy

Line 3000: FEM_ENGINES_PKG.Tech_Message

2996: RAISE FEM_INTG_fatal_err;
2997: END IF;
2998: ELSE
2999: -- Not single seg or multi seg so raise error
3000: FEM_ENGINES_PKG.Tech_Message
3001: (p_severity => pc_log_level_procedure,
3002: p_module => 'fem.plsql.fem_intg_hier_eng.main.',
3003: p_app_name => 'FEM',
3004: p_msg_name => 'FEM_INTG_HIER_MULTISEG_ERR',

Line 3009: FEM_ENGINES_PKG.User_Message

3005: p_token1 => 'VAR_NAME',
3006: p_value1 => 'pv_dim_mapping_option_code',
3007: p_token2 => 'VAR_VAL',
3008: p_value2 => pv_dim_mapping_option_code);
3009: FEM_ENGINES_PKG.User_Message
3010: (p_app_name => 'FEM',
3011: p_msg_name => 'FEM_INTG_HIER_MULTISEG_ERR');
3012: RAISE FEM_INTG_fatal_err;
3013: END IF;

Line 3033: FEM_ENGINES_PKG.Tech_Message

3029: WHEN NO_DATA_FOUND THEN
3030: null;
3031: END;
3032: IF (v_duplicate_parent = 'Duplicate') THEN
3033: FEM_ENGINES_PKG.Tech_Message
3034: (p_severity => pc_log_level_procedure,
3035: p_module => 'fem.plsql.fem_intg_hier_eng.main.' || 'duplicate',
3036: p_app_name => 'FEM',
3037: p_msg_name => 'FEM_INTG_HIER_MULTI_PARENT_ERR',

Line 3042: FEM_ENGINES_PKG.User_Message

3038: p_token1 => 'VAR_NAME',
3039: p_value1 => 'v_duplicate_parent',
3040: p_token2 => 'VAR_VAL',
3041: p_value2 => v_duplicate_parent);
3042: FEM_ENGINES_PKG.User_Message
3043: (p_app_name => 'FEM',
3044: p_msg_name => 'FEM_INTG_HIER_MULTI_PARENT_ERR');
3045: --bug fix 4563603
3046: FEM_ENGINES_PKG.Tech_Message

Line 3046: FEM_ENGINES_PKG.Tech_Message

3042: FEM_ENGINES_PKG.User_Message
3043: (p_app_name => 'FEM',
3044: p_msg_name => 'FEM_INTG_HIER_MULTI_PARENT_ERR');
3045: --bug fix 4563603
3046: FEM_ENGINES_PKG.Tech_Message
3047: (p_severity => pc_log_level_procedure,
3048: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Component_Hier.' || 'duplicate',
3049: p_app_name => 'FEM',
3050: p_msg_text => ' ');

Line 3052: FEM_ENGINES_PKG.User_Message

3048: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Component_Hier.' || 'duplicate',
3049: p_app_name => 'FEM',
3050: p_msg_text => ' ');
3051:
3052: FEM_ENGINES_PKG.User_Message
3053: (p_app_name => 'FEM',
3054: p_msg_text => ' ');
3055:
3056: FEM_ENGINES_PKG.Tech_Message

Line 3056: FEM_ENGINES_PKG.Tech_Message

3052: FEM_ENGINES_PKG.User_Message
3053: (p_app_name => 'FEM',
3054: p_msg_text => ' ');
3055:
3056: FEM_ENGINES_PKG.Tech_Message
3057: (p_severity => pc_log_level_procedure,
3058: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Component_Hier.' || 'duplicate',
3059: p_app_name => 'FEM',
3060: p_msg_name => 'FEM_INTG_HIER_MULT_PARENTS');

Line 3062: FEM_ENGINES_PKG.User_Message

3058: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Component_Hier.' || 'duplicate',
3059: p_app_name => 'FEM',
3060: p_msg_name => 'FEM_INTG_HIER_MULT_PARENTS');
3061:
3062: FEM_ENGINES_PKG.User_Message
3063: (p_app_name => 'FEM',
3064: p_msg_name => 'FEM_INTG_HIER_MULT_PARENTS');
3065:
3066: OPEN c_child_of_multi_parent;

Line 3083: FEM_ENGINES_PKG.Tech_Message

3079: END LOOP;
3080: CLOSE c_multi_parent;
3081: v_offending_parents_list := SUBSTR(v_offending_parents_list,1,LENGTH(v_offending_parents_list)-2);
3082:
3083: FEM_ENGINES_PKG.Tech_Message
3084: (p_severity => pc_log_level_procedure,
3085: p_module => 'fem.plsql.fem_intg.hier_eng.',
3086: p_app_name => 'FEM',
3087: p_msg_name => 'FEM_INTG_HIER_PARENT_CHILD_LST',

Line 3093: FEM_ENGINES_PKG.User_Message

3089: p_value1 => v_display_code,
3090: p_token2 => 'PARENTS',
3091: p_value2 => v_offending_parents_list);
3092:
3093: FEM_ENGINES_PKG.User_Message
3094: (p_app_name => 'FEM',
3095: p_msg_name => 'FEM_INTG_HIER_PARENT_CHILD_LST',
3096: p_token1 => 'CHILD',
3097: p_value1 => v_display_code,

Line 3103: FEM_ENGINES_PKG.Tech_Message

3099: p_value2 => v_offending_parents_list);
3100:
3101: END LOOP;
3102: CLOSE c_child_of_multi_parent;
3103: FEM_ENGINES_PKG.Tech_Message
3104: (p_severity => pc_log_level_procedure,
3105: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Component_Hier.' || 'duplicate',
3106: p_app_name => 'FEM',
3107: p_msg_text => ' ');

Line 3109: FEM_ENGINES_PKG.User_Message

3105: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Component_Hier.' || 'duplicate',
3106: p_app_name => 'FEM',
3107: p_msg_text => ' ');
3108:
3109: FEM_ENGINES_PKG.User_Message
3110: (p_app_name => 'FEM',
3111: p_msg_text => ' ');
3112: --bug fix 4563603
3113:

Line 3125: FEM_ENGINES_PKG.Tech_Message

3121: fem_intg_dim_hier_gt gt
3122: WHERE b.'||pv_dim_memb_disp_col ||'= gt.child_display_code
3123: AND b.value_set_id = '||pv_dim_vs_id||'
3124: AND b.dimension_group_id <> gt.dimension_group_id';
3125: FEM_ENGINES_PKG.Tech_Message
3126: (p_severity => pc_log_level_procedure,
3127: p_module => 'fem.plsql.fem_intg_hier_eng.main.' ,
3128: p_app_name => 'FEM',
3129: p_msg_name => 'FEM_GL_POST_204',

Line 3139: FEM_ENGINES_PKG.Tech_Message

3135: LOOP
3136: FETCH DimensionGroupID INTO v_child_display_code;
3137: EXIT WHEN DimensionGroupID%NOTFOUND;
3138: v_dim_group_conflict := TRUE;
3139: FEM_ENGINES_PKG.Tech_Message
3140: (p_severity => pc_log_level_procedure,
3141: p_module => 'fem.plsql.fem_intg.hier_eng.',
3142: p_app_name => 'FEM',
3143: p_msg_name => 'FEM_INTG_HIER_CONFLICT_DIM_GRP',

Line 3146: FEM_ENGINES_PKG.User_Message

3142: p_app_name => 'FEM',
3143: p_msg_name => 'FEM_INTG_HIER_CONFLICT_DIM_GRP',
3144: p_token1 => 'DISP_CODE',
3145: p_value1 => v_child_display_code);
3146: FEM_ENGINES_PKG.User_Message
3147: (p_app_name => 'FEM',
3148: p_msg_name => 'FEM_INTG_HIER_CONFLICT_DIM_GRP',
3149: p_token1 => 'DISP_CODE',
3150: p_value1 => v_child_display_code);

Line 3171: FEM_ENGINES_PKG.Tech_Message

3167: WHERE value_set_id = :pv_dim_vs_id
3168: AND '||pv_dim_memb_col||' IN
3169: (SELECT child_id
3170: FROM fem_intg_dim_hier_gt)';
3171: FEM_ENGINES_PKG.Tech_Message
3172: (p_severity => pc_log_level_procedure,
3173: p_module => 'fem.plsql.fem_intg_hier_eng.main.' ,
3174: p_app_name => 'FEM',
3175: p_msg_name => 'FEM_GL_POST_204',

Line 3216: FEM_ENGINES_PKG.Tech_Message

3212: :pv_login_id,
3213: 1
3214: FROM fem_intg_dim_hier_gt gt
3215: WHERE hierarchy_obj_def_id = :pv_hier_obj_def_id';
3216: FEM_ENGINES_PKG.Tech_Message
3217: (p_severity => pc_log_level_procedure,
3218: p_module => 'fem.plsql.fem_intg_hier_eng.main.' ,
3219: p_app_name => 'FEM',
3220: p_msg_name => 'FEM_GL_POST_204',

Line 3239: FEM_ENGINES_PKG.Tech_Message

3235: -- Call DELETE statement to delete existing hierarchy structure
3236: -- for the hierarchy object definition.
3237: v_sql_stmt := 'DELETE FROM '||pv_dim_hier_tab||'
3238: WHERE hierarchy_obj_def_id = :pv_hier_obj_def_id';
3239: FEM_ENGINES_PKG.Tech_Message
3240: (p_severity => pc_log_level_procedure,
3241: p_module => 'fem.plsql.fem_intg_hier_eng.main.',
3242: p_app_name => 'FEM',
3243: p_msg_name => 'FEM_GL_POST_204',

Line 3278: FEM_ENGINES_PKG.Tech_Message

3274: :pv_login_id,
3275: 1
3276: FROM fem_intg_dim_hier_gt gt
3277: WHERE gt.hierarchy_obj_def_id = :pv_hier_obj_def_id';
3278: FEM_ENGINES_PKG.Tech_Message
3279: (p_severity => pc_log_level_procedure,
3280: p_module => 'fem.plsql.fem_intg_hier_eng.main.',
3281: p_app_name => 'FEM',
3282: p_msg_name => 'FEM_GL_POST_204',

Line 3297: FEM_ENGINES_PKG.Tech_Message

3293: pv_login_id,
3294: pv_hier_obj_def_id;
3295: END IF;
3296: COMMIT;
3297: FEM_ENGINES_PKG.Tech_Message
3298: (p_severity => pc_log_level_procedure,
3299: p_module => 'fem.plsql.fem_intg_hier_eng.',
3300: p_msg_text => 'before the Final_Process_Logging');
3301: FEM_ENGINES_PKG.Tech_Message

Line 3301: FEM_ENGINES_PKG.Tech_Message

3297: FEM_ENGINES_PKG.Tech_Message
3298: (p_severity => pc_log_level_procedure,
3299: p_module => 'fem.plsql.fem_intg_hier_eng.',
3300: p_msg_text => 'before the Final_Process_Logging');
3301: FEM_ENGINES_PKG.Tech_Message
3302: (p_severity => pc_log_level_procedure,
3303: p_module => 'fem.plsql.fem_intg_hier_eng.',
3304: p_msg_text => 'pv_hier_rule_obj_id: ' ||pv_hier_rule_obj_id||
3305: ' pv_hier_rule_obj_def_id:' ||pv_hier_rule_obj_def_id ||

Line 3326: FEM_ENGINES_PKG.Tech_Message

3322: p_final_msg_name => 'FEM_INTG_PROC_SUCCESS',
3323: p_module_name =>'fem.plsql.fem_intg_hier_eng_pkg.' ||
3324: 'final_process_logging',
3325: x_completion_code => v_compl_code);
3326: FEM_ENGINES_PKG.Tech_Message
3327: (p_severity => pc_log_level_procedure,
3328: p_module => 'fem.plsql.fem_intg_hier_eng.',
3329: p_msg_text => 'after the Final_Process_Logging');
3330: FEM_ENGINES_PKG.Tech_Message

Line 3330: FEM_ENGINES_PKG.Tech_Message

3326: FEM_ENGINES_PKG.Tech_Message
3327: (p_severity => pc_log_level_procedure,
3328: p_module => 'fem.plsql.fem_intg_hier_eng.',
3329: p_msg_text => 'after the Final_Process_Logging');
3330: FEM_ENGINES_PKG.Tech_Message
3331: (p_severity => pc_log_level_procedure,
3332: p_module => 'fem.plsql.fem_intg_hier_eng.',
3333: p_msg_text => 'v_row_count_tot:' || v_row_count_tot||
3334: ' v_err_count_tot:' || v_err_count_tot||

Line 3337: FEM_ENGINES_PKG.Tech_Message

3333: p_msg_text => 'v_row_count_tot:' || v_row_count_tot||
3334: ' v_err_count_tot:' || v_err_count_tot||
3335: ' v_compl_code:' ||v_compl_code);
3336: COMMIT;
3337: FEM_ENGINES_PKG.Tech_Message
3338: (p_severity => pc_log_level_procedure,
3339: p_module => 'fem.plsql.fem_intg_hier_eng.main.' ,
3340: p_app_name => 'FEM',
3341: p_msg_name => 'FEM_GL_POST_202',

Line 3356: FEM_ENGINES_PKG.Tech_Message

3352: (application => 'FEM',
3353: program => 'DHMHVFLW',
3354: argument1 => pv_hier_obj_id,
3355: argument2 => pv_hier_obj_def_id);
3356: FEM_ENGINES_PKG.Tech_Message
3357: (p_severity => pc_log_level_procedure,
3358: p_module => 'fem.plsql.fem_intg.hier_eng.Main',
3359: p_app_name => 'FEM',
3360: p_msg_name => 'FEM_INTG_HIER_DHMHVFLW_SUBMIT',

Line 3363: FEM_ENGINES_PKG.User_Message

3359: p_app_name => 'FEM',
3360: p_msg_name => 'FEM_INTG_HIER_DHMHVFLW_SUBMIT',
3361: p_token1 => 'REQ_ID',
3362: p_value1 => v_req_id);
3363: FEM_ENGINES_PKG.User_Message
3364: (p_app_name => 'FEM',
3365: p_msg_name => 'FEM_INTG_HIER_DHMHVFLW_SUBMIT',
3366: p_token1 => 'REQ_ID',
3367: p_value1 => v_req_id);

Line 3386: FEM_ENGINES_PKG.Tech_Message

3382: p_final_msg_name => 'FEM_INTG_PROC_FAILURE',
3383: p_module_name =>'fem.plsql.fem_intg_hier_eng_pkg.' ||
3384: 'final_process_logging',
3385: x_completion_code => v_compl_code);
3386: FEM_ENGINES_PKG.Tech_Message
3387: (p_severity => pc_log_level_procedure,
3388: p_module => 'fem.plsql.fem_intg_hier_eng.main.',
3389: p_app_name => 'FEM',
3390: p_msg_name => 'FEM_GL_POST_203',

Line 3399: FEM_ENGINES_PKG.Tech_Message

3395: v_ret_status := FND_CONCURRENT.Set_Completion_Status
3396: (status => 'ERROR', message => NULL);
3397: WHEN OTHERS THEN
3398: ROLLBACK;
3399: FEM_ENGINES_PKG.Tech_Message
3400: (p_severity => pc_log_level_unexpected,
3401: p_module => 'fem.plsql.fem_intg_hier_eng.main.' ,
3402: p_app_name => 'FEM',
3403: p_msg_name => 'FEM_GL_POST_215',

Line 3406: FEM_ENGINES_PKG.User_Message

3402: p_app_name => 'FEM',
3403: p_msg_name => 'FEM_GL_POST_215',
3404: p_token1 => 'ERR_MSG',
3405: p_value1 => SQLERRM);
3406: FEM_ENGINES_PKG.User_Message
3407: (p_app_name => 'FEM',
3408: p_msg_name => 'FEM_GL_POST_215',
3409: p_token1 => 'ERR_MSG',
3410: p_value1 => SQLERRM);

Line 3424: FEM_ENGINES_PKG.Tech_Message

3420: p_final_msg_name => 'FEM_INTG_PROC_FAILURE',
3421: p_module_name =>'fem.plsql.fem_intg_hier_eng_pkg.' ||
3422: 'final_process_logging',
3423: x_completion_code => v_compl_code);
3424: FEM_ENGINES_PKG.Tech_Message
3425: (p_severity => pc_log_level_procedure,
3426: p_module => 'fem.plsql.fem_intg_hier_eng.main.',
3427: p_app_name => 'FEM',
3428: p_msg_name => 'FEM_GL_POST_203',