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

Line 82: FEM_ENGINES_PKG.Tech_Message

78: A.ATTRIBUTE_VALUE = 'Y';
79:
80: BEGIN
81: pv_progress := 'Start';
82: FEM_ENGINES_PKG.Tech_Message
83: ( p_severity => pc_log_level_procedure
84: ,p_module => pc_module_name||c_func_name
85: ,p_app_name => 'FEM'
86: ,p_msg_name => 'FEM_GL_POST_201'

Line 118: FEM_ENGINES_PKG.Tech_Message

114: DECODE(R.DIMENSION_ID,
115: 0, 'COMPANY_COST_CENTER_ORG',
116: R.DIMENSION_ID);
117:
118: FEM_ENGINES_PKG.Tech_Message
119: ( p_severity => pc_log_level_procedure
120: ,p_module => pc_module_name||c_func_name
121: ,p_msg_text => 'Initialize pv_mapped_segs array');
122:

Line 131: FEM_ENGINES_PKG.Tech_Message

127: END LOOP;
128:
129: pv_progress := 'Initialize major package variables 1 of 3';
130:
131: FEM_ENGINES_PKG.Tech_Message
132: ( p_severity => pc_log_level_procedure
133: ,p_module => pc_module_name||c_func_name
134: ,p_msg_text => 'Initialize major package variables 1 of 3 ');
135:

Line 170: FEM_ENGINES_PKG.Tech_Message

166: LOOP
167: pv_mapped_segs(i).vs_id := -99;
168: END LOOP;
169:
170: FEM_ENGINES_PKG.Tech_Message
171: ( p_severity => pc_log_level_procedure
172: ,p_module => pc_module_name||c_func_name
173: ,p_msg_text => 'Initialize major package variables 2 of 3 ');
174:

Line 209: FEM_ENGINES_PKG.Tech_Message

205: AND V.FLEX_VALUE_SET_ID = NVL(S.FLEX_VALUE_SET_ID, -99)
206: AND T.FLEX_VALUE_SET_ID (+) = V.FLEX_VALUE_SET_ID;
207: EXCEPTION
208: WHEN OTHERS THEN
209: FEM_ENGINES_PKG.Tech_Message
210: ( p_severity => pc_log_level_procedure
211: ,p_module => pc_module_name||c_func_name
212: ,p_msg_text => 'Cannot find value set id in a given colum name');
213:

Line 357: FEM_ENGINES_PKG.Tech_Message

353: END IF;
354:
355: END IF;
356:
357: FEM_ENGINES_PKG.Tech_Message
358: ( p_severity => pc_log_level_procedure
359: ,p_module => pc_module_name||c_func_name
360: ,p_msg_text => 'Initialize major package variables 3 of 3 ');
361:

Line 386: FEM_ENGINES_PKG.Tech_Message

382: WHERE DIMENSION_ID = pv_dim_id;
383:
384: ELSE
385:
386: FEM_ENGINES_PKG.Tech_Message
387: ( p_severity => pc_log_level_procedure
388: ,p_module => pc_module_name||c_func_name
389: ,p_msg_text => '- Intercompany case - ');
390:

Line 418: FEM_ENGINES_PKG.Tech_Message

414: pv_member_col := 'INTERCOMPANY_ID';
415:
416: END IF;
417:
418: FEM_ENGINES_PKG.Tech_Message
419: (p_severity => pc_log_level_procedure,
420: p_module => pc_module_name || c_func_name,
421: p_app_name => 'FEM',
422: p_msg_name => 'FEM_GL_POST_202',

Line 429: FEM_ENGINES_PKG.Tech_Message

425: p_token2 => 'TIME',
426: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
427: EXCEPTION
428: WHEN FEMOGL_cctr_org_dim_missing THEN
429: FEM_ENGINES_PKG.Tech_Message
430: (p_severity => pc_log_level_error
431: ,p_module => pc_module_name||c_func_name||'.unexpected_exception'
432: ,p_msg_text => 'Cannot find CCTR-ORG dimension ID');
433:

Line 434: FEM_ENGINES_PKG.Tech_Message

430: (p_severity => pc_log_level_error
431: ,p_module => pc_module_name||c_func_name||'.unexpected_exception'
432: ,p_msg_text => 'Cannot find CCTR-ORG dimension ID');
433:
434: FEM_ENGINES_PKG.Tech_Message
435: (p_severity => pc_log_level_error
436: ,p_module => pc_module_name||c_func_name
437: ,p_app_name => 'FEM'
438: ,p_msg_name => 'FEM_INTG_DIM_ENG_101'

Line 442: FEM_ENGINES_PKG.Tech_Message

438: ,p_msg_name => 'FEM_INTG_DIM_ENG_101'
439: ,p_token1 => 'DIM_ID'
440: ,p_value1 => pv_dim_id);
441:
442: FEM_ENGINES_PKG.Tech_Message
443: (p_severity => pc_log_level_error
444: ,p_module => pc_module_name||c_func_name||'.unexpected_exception'
445: ,p_app_name => 'FEM'
446: ,p_msg_name => 'FEM_GL_POST_203'

Line 458: FEM_ENGINES_PKG.Tech_Message

454:
455: app_exception.raise_exception;
456:
457: WHEN FEMOGL_com_dim_missing THEN
458: FEM_ENGINES_PKG.Tech_Message
459: (p_severity => pc_log_level_error
460: ,p_module => pc_module_name||c_func_name||'.unexpected_exception'
461: ,p_msg_text => 'Cannot find company dimension ID');
462:

Line 463: FEM_ENGINES_PKG.Tech_Message

459: (p_severity => pc_log_level_error
460: ,p_module => pc_module_name||c_func_name||'.unexpected_exception'
461: ,p_msg_text => 'Cannot find company dimension ID');
462:
463: FEM_ENGINES_PKG.Tech_Message
464: (p_severity => pc_log_level_error
465: ,p_module => pc_module_name||c_func_name
466: ,p_app_name => 'FEM'
467: ,p_msg_name => 'FEM_INTG_DIM_ENG_102'

Line 471: FEM_ENGINES_PKG.Tech_Message

467: ,p_msg_name => 'FEM_INTG_DIM_ENG_102'
468: ,p_token1 => 'DIM_ID'
469: ,p_value1 => pv_dim_id);
470:
471: FEM_ENGINES_PKG.Tech_Message
472: (p_severity => pc_log_level_error
473: ,p_module => pc_module_name||c_func_name||'.unexpected_exception'
474: ,p_app_name => 'FEM'
475: ,p_msg_name => 'FEM_GL_POST_203'

Line 487: FEM_ENGINES_PKG.Tech_Message

483:
484: app_exception.raise_exception;
485:
486: WHEN FEMOGL_cc_dim_missing THEN
487: FEM_ENGINES_PKG.Tech_Message
488: (p_severity => pc_log_level_error
489: ,p_module => pc_module_name||c_func_name||'.unexpected_exception'
490: ,p_msg_text => 'Cannot find cost center dimension ID');
491:

Line 492: FEM_ENGINES_PKG.Tech_Message

488: (p_severity => pc_log_level_error
489: ,p_module => pc_module_name||c_func_name||'.unexpected_exception'
490: ,p_msg_text => 'Cannot find cost center dimension ID');
491:
492: FEM_ENGINES_PKG.Tech_Message
493: (p_severity => pc_log_level_error
494: ,p_module => pc_module_name||c_func_name
495: ,p_app_name => 'FEM'
496: ,p_msg_name => 'FEM_INTG_DIM_ENG_103'

Line 500: FEM_ENGINES_PKG.Tech_Message

496: ,p_msg_name => 'FEM_INTG_DIM_ENG_103'
497: ,p_token1 => 'DIM_ID'
498: ,p_value1 => pv_dim_id);
499:
500: FEM_ENGINES_PKG.Tech_Message
501: (p_severity => pc_log_level_error
502: ,p_module => pc_module_name||c_func_name||'.unexpected_exception'
503: ,p_app_name => 'FEM'
504: ,p_msg_name => 'FEM_GL_POST_203'

Line 516: FEM_ENGINES_PKG.Tech_Message

512:
513: app_exception.raise_exception;
514:
515: WHEN OTHERS THEN
516: FEM_ENGINES_PKG.Tech_Message
517: (p_severity => pc_log_level_unexpected
518: ,p_module => pc_module_name||c_func_name||'.unexpected_exception'
519: ,p_msg_text => sqlerrm);
520:

Line 521: FEM_ENGINES_PKG.Tech_Message

517: (p_severity => pc_log_level_unexpected
518: ,p_module => pc_module_name||c_func_name||'.unexpected_exception'
519: ,p_msg_text => sqlerrm);
520:
521: FEM_ENGINES_PKG.Tech_Message
522: (p_severity => pc_log_level_unexpected
523: ,p_module => pc_module_name||c_func_name||'.unexpected_exception'
524: ,p_msg_text => 'Location before failure: '||pv_progress);
525:

Line 526: FEM_ENGINES_PKG.User_Message

522: (p_severity => pc_log_level_unexpected
523: ,p_module => pc_module_name||c_func_name||'.unexpected_exception'
524: ,p_msg_text => 'Location before failure: '||pv_progress);
525:
526: FEM_ENGINES_PKG.User_Message
527: (p_msg_text => sqlerrm);
528:
529: FEM_ENGINES_PKG.Tech_Message
530: (p_severity => pc_log_level_procedure

Line 529: FEM_ENGINES_PKG.Tech_Message

525:
526: FEM_ENGINES_PKG.User_Message
527: (p_msg_text => sqlerrm);
528:
529: FEM_ENGINES_PKG.Tech_Message
530: (p_severity => pc_log_level_procedure
531: ,p_module => pc_module_name||c_func_name||'.unexpected_exception'
532: ,p_app_name => 'FEM'
533: ,p_msg_name => 'FEM_GL_POST_203'

Line 585: FEM_ENGINES_PKG.Tech_Message

581: TYPE INDEX_NAME is TABLE OF VARCHAR2(30);
582: pv_index_name INDEX_NAME;
583: BEGIN
584: pv_progress := 'Main Start';
585: FEM_ENGINES_PKG.Tech_Message
586: (p_severity => pc_log_level_procedure,
587: p_module => pc_module_name||c_func_name,
588: p_app_name => 'FEM',
589: p_msg_name => 'FEM_GL_POST_201',

Line 625: FEM_ENGINES_PKG.Tech_Message

621: -- -----------------------------------
622:
623: pv_progress := 'Calling FEM_GL_POST_PROCESS_PKG.Register_Process_Execution';
624:
625: FEM_ENGINES_PKG.Tech_Message
626: ( p_severity => pc_log_level_event
627: ,p_module => pc_module_name||c_func_name
628: ,p_msg_text => 'Before calling Process lock');
629:

Line 644: FEM_ENGINES_PKG.Tech_Message

640: x_completion_code => v_completion_code_register
641: );
642:
643: IF v_completion_code_register = 2 THEN
644: FEM_ENGINES_PKG.Tech_Message
645: ( p_severity => pc_log_level_error
646: ,p_module => pc_module_name||c_func_name
647: ,p_msg_text => 'Before calling Process lock');
648: RAISE FEMOGL_fatal_err;

Line 657: FEM_ENGINES_PKG.Tech_Message

653: -- ------------------------------------
654:
655: pv_progress := 'Calling to initialize';
656:
657: FEM_ENGINES_PKG.Tech_Message
658: ( p_severity => pc_log_level_error
659: ,p_module => pc_module_name||c_func_name
660: ,p_msg_text => 'Before calling Init');
661:

Line 662: FEM_ENGINES_PKG.User_Message(

658: ( p_severity => pc_log_level_error
659: ,p_module => pc_module_name||c_func_name
660: ,p_msg_text => 'Before calling Init');
661:
662: FEM_ENGINES_PKG.User_Message(
663: p_app_name => 'FEM',
664: p_msg_name => 'FEM_INTG_DIM_ENG_501'
665: );
666:

Line 752: FEM_ENGINES_PKG.Tech_Message

748: ,p_dim_id => pv_dim_id
749: ,x_status => v_status);
750: IF v_status = 0
751: THEN
752: FEM_ENGINES_PKG.Tech_Message
753: ( p_severity => pc_log_level_error
754: ,p_module => pc_module_name||c_func_name
755: ,p_msg_text => 'Unexpected error while registering FEM value set');
756: raise_application_error(-20001, fnd_message.get);

Line 760: FEM_ENGINES_PKG.Tech_Message

756: raise_application_error(-20001, fnd_message.get);
757: END IF;
758:
759: WHEN OTHERS THEN
760: FEM_ENGINES_PKG.Tech_Message
761: ( p_severity => pc_log_level_error
762: ,p_module => pc_module_name||c_func_name
763: ,p_msg_text => 'Following error during selecting fem VSID
764: from FEM_INTG_AOL_VALSET_MAP: '||sqlerrm);

Line 805: FEM_ENGINES_PKG.User_Message(

801:
802: IF (pv_segment_count <> v_cctr_seg_count)
803: OR (pv_dim_mapping_option_code <> v_cctr_map_option_code)
804: THEN
805: FEM_ENGINES_PKG.User_Message(
806: p_app_name => 'FEM',
807: p_msg_name => 'FEM_INTG_DIM_ENG_508'
808: );
809: fnd_message.set_name('FEM','FEM_INTG_DIM_ENG_508');

Line 836: FEM_ENGINES_PKG.Tech_Message

832: AND dimension_id = pv_cc_dim_id;
833:
834: EXCEPTION
835: WHEN OTHERS THEN
836: FEM_ENGINES_PKG.Tech_Message
837: ( p_severity => pc_log_level_procedure
838: ,p_module => pc_module_name||c_func_name
839: ,p_msg_text => 'varlable'||pv_dim_varchar_label);
840: raise_application_error(-20001, fnd_message.get);

Line 845: FEM_ENGINES_PKG.User_Message(

841: END;
842:
843: IF pv_fem_vs_id = -1
844: THEN
845: FEM_ENGINES_PKG.User_Message(
846: p_app_name => 'FEM',
847: p_msg_name => 'FEM_INTG_DIM_ENG_507'
848: );
849: fnd_message.set_name('FEM','FEM_INTG_DIM_ENG_507');

Line 882: FEM_ENGINES_PKG.Tech_Message

878: WHERE GLOBAL_VS_COMBO_ID = pv_gvsc_id
879: AND DIMENSION_ID = pv_dim_id;
880: EXCEPTION
881: WHEN NO_DATA_FOUND THEN
882: FEM_ENGINES_PKG.Tech_Message
883: ( p_severity => pc_log_level_error
884: ,p_module => pc_module_name||c_func_name
885: ,p_msg_text => 'Unexpected error while getting value set from FEM_GLOBAL_VS_COMBO_DEFS');
886: raise_application_error(-20001, fnd_message.get);

Line 1014: FEM_ENGINES_PKG.Tech_Message

1010: ,p_dim_id => pv_com_dim_id
1011: ,x_status => v_status);
1012: IF v_status = 0
1013: THEN
1014: FEM_ENGINES_PKG.Tech_Message
1015: ( p_severity => pc_log_level_error
1016: ,p_module => pc_module_name||c_func_name
1017: ,p_msg_text => 'Unexpected error while registering company value set');
1018: raise_application_error(-20001, fnd_message.get);

Line 1118: FEM_ENGINES_PKG.Tech_Message

1114: ,x_status => v_status);
1115:
1116: IF v_status = 0
1117: THEN
1118: FEM_ENGINES_PKG.Tech_Message
1119: ( p_severity => pc_log_level_error
1120: ,p_module => pc_module_name||c_func_name
1121: ,p_msg_text => 'Unexpected error while registering Cost-center value set');
1122: raise_application_error(-20001, fnd_message.get);

Line 1239: FEM_ENGINES_PKG.Tech_Message

1235: ,p_dim_id => pv_com_dim_id
1236: ,x_status => v_status);
1237: IF v_status = 0
1238: THEN
1239: FEM_ENGINES_PKG.Tech_Message
1240: ( p_severity => pc_log_level_error
1241: ,p_module => pc_module_name||c_func_name
1242: ,p_msg_text => 'Unexpected error while registering company value set');
1243: raise_application_error(-20001, fnd_message.get);

Line 1320: FEM_ENGINES_PKG.Tech_Message

1316: ,p_dim_id => pv_cc_dim_id
1317: ,x_status => v_status);
1318: IF v_status = 0
1319: THEN
1320: FEM_ENGINES_PKG.Tech_Message
1321: ( p_severity => pc_log_level_error
1322: ,p_module => pc_module_name||c_func_name
1323: ,p_msg_text => 'Unexpected error while registering cost center value set');
1324: raise_application_error(-20001, fnd_message.get);

Line 1343: FEM_ENGINES_PKG.Tech_Message

1339: END IF; /* IF pv_dim_varchar_label = 'COMPANY_COST_CENTER_ORG' */
1340:
1341: pv_progress := 'Before update fem_intg_dim_rule_defs';
1342:
1343: FEM_ENGINES_PKG.Tech_Message
1344: ( p_severity => pc_log_level_event
1345: ,p_module => pc_module_name||c_func_name
1346: ,p_msg_text => 'Before updating fem_global_vs_combo_defs with'
1347: ||pv_fem_vs_id||' for dimension '||pv_dim_id);

Line 1349: FEM_ENGINES_PKG.User_Message(

1345: ,p_module => pc_module_name||c_func_name
1346: ,p_msg_text => 'Before updating fem_global_vs_combo_defs with'
1347: ||pv_fem_vs_id||' for dimension '||pv_dim_id);
1348:
1349: FEM_ENGINES_PKG.User_Message(
1350: p_app_name => 'FEM',
1351: p_msg_name => 'FEM_INTG_DIM_ENG_502',
1352: p_token1 => 'VERSION_ID',
1353: p_value1 => p_dim_rule_obj_def_id,

Line 1367: FEM_ENGINES_PKG.Tech_Message

1363: * create place holder records in mapping table
1364: * =============================================
1365: */
1366:
1367: FEM_ENGINES_PKG.Tech_Message
1368: ( p_severity => pc_log_level_event
1369: ,p_module => pc_module_name||c_func_name
1370: ,p_msg_text => 'Before locking fem_intg_ogl_ccid_map');
1371:

Line 1392: FEM_ENGINES_PKG.Tech_Message

1388: WHERE CHART_OF_ACCOUNTS_ID = pv_coa_id;
1389:
1390: IF v_max_ccid_in_map_table < v_max_ccid_in_glccid_table
1391: THEN
1392: FEM_ENGINES_PKG.Tech_Message
1393: ( p_severity => pc_log_level_event
1394: ,p_module => pc_module_name||c_func_name
1395: ,p_msg_text => 'Before calling create_map_placeholder_records');
1396:

Line 1397: FEM_ENGINES_PKG.User_Message(

1393: ( p_severity => pc_log_level_event
1394: ,p_module => pc_module_name||c_func_name
1395: ,p_msg_text => 'Before calling create_map_placeholder_records');
1396:
1397: FEM_ENGINES_PKG.User_Message(
1398: p_app_name => 'FEM',
1399: p_msg_name => 'FEM_INTG_DIM_ENG_503');
1400:
1401: create_map_placeholder_records(

Line 1409: FEM_ENGINES_PKG.Tech_Message

1405: v_max_ccid_in_glccid_table,
1406: v_map_records_inserted_count
1407: );
1408: ELSE
1409: FEM_ENGINES_PKG.Tech_Message
1410: ( p_severity => pc_log_level_event
1411: ,p_module => pc_module_name||c_func_name
1412: ,p_msg_text => 'Not creating mapping records ');
1413: END IF;

Line 1438: FEM_ENGINES_PKG.Tech_Message

1434: pv_progress := 'Before Case';
1435: CASE pv_dim_mapping_option_code
1436: WHEN 'SINGLESEG'
1437: THEN
1438: FEM_ENGINES_PKG.Tech_Message
1439: ( p_severity => pc_log_level_event
1440: ,p_module => pc_module_name||c_func_name
1441: ,p_msg_text => 'Before calling Detail_Single_Segment');
1442:

Line 1443: FEM_ENGINES_PKG.User_Message(

1439: ( p_severity => pc_log_level_event
1440: ,p_module => pc_module_name||c_func_name
1441: ,p_msg_text => 'Before calling Detail_Single_Segment');
1442:
1443: FEM_ENGINES_PKG.User_Message(
1444: p_app_name => 'FEM',
1445: p_msg_name => 'FEM_INTG_DIM_ENG_504');
1446:
1447: FEM_INTG_NEW_DIM_MEMBER_PKG.Detail_Single_Segment (v_completion_code

Line 1455: FEM_ENGINES_PKG.Tech_Message

1451: -- we need to have entry point for launch workers incase intercompany is singleval segment
1452: WHEN 'SINGLEVAL'
1453: THEN
1454: IF pv_dim_varchar_label = 'INTERCOMPANY' THEN
1455: FEM_ENGINES_PKG.Tech_Message
1456: ( p_severity => pc_log_level_event
1457: ,p_module => pc_module_name||c_func_name
1458: ,p_msg_text => 'Before calling Detail_Single_Value');
1459:

Line 1460: FEM_ENGINES_PKG.User_Message(

1456: ( p_severity => pc_log_level_event
1457: ,p_module => pc_module_name||c_func_name
1458: ,p_msg_text => 'Before calling Detail_Single_Value');
1459:
1460: FEM_ENGINES_PKG.User_Message(
1461: p_app_name => 'FEM',
1462: p_msg_name => 'FEM_INTG_DIM_ENG_505');
1463:
1464: FEM_INTG_NEW_DIM_MEMBER_PKG.Detail_Single_Value (v_completion_code

Line 1472: FEM_ENGINES_PKG.Tech_Message

1468: -- end bug fix 5377544
1469:
1470: WHEN 'MULTISEG'
1471: THEN
1472: FEM_ENGINES_PKG.Tech_Message
1473: ( p_severity => pc_log_level_event
1474: ,p_module => pc_module_name||c_func_name
1475: ,p_msg_text => 'Before calling Detail_Multi_Segment');
1476:

Line 1477: FEM_ENGINES_PKG.User_Message(

1473: ( p_severity => pc_log_level_event
1474: ,p_module => pc_module_name||c_func_name
1475: ,p_msg_text => 'Before calling Detail_Multi_Segment');
1476:
1477: FEM_ENGINES_PKG.User_Message(
1478: p_app_name => 'FEM',
1479: p_msg_name => 'FEM_INTG_DIM_ENG_506');
1480:
1481: FEM_INTG_NEW_DIM_MEMBER_PKG.Detail_Multi_Segment (v_completion_code

Line 1484: FEM_ENGINES_PKG.Tech_Message

1480:
1481: FEM_INTG_NEW_DIM_MEMBER_PKG.Detail_Multi_Segment (v_completion_code
1482: ,v_dim_process_row_cnt);
1483: ELSE
1484: FEM_ENGINES_PKG.Tech_Message
1485: ( p_severity => pc_log_level_event
1486: ,p_module => pc_module_name||c_func_name
1487: ,p_msg_text => 'Case statement for calling segment population not
1488: satisfied: '||pv_dim_mapping_option_code);

Line 1495: FEM_ENGINES_PKG.Tech_Message

1491: THEN
1492: raise_application_error(-20001, fnd_message.get);
1493: END IF;
1494:
1495: FEM_ENGINES_PKG.Tech_Message
1496: (p_severity => pc_log_level_procedure,
1497: p_module => pc_module_name || c_func_name,
1498: p_app_name => 'FEM',
1499: p_msg_name => 'FEM_GL_POST_202',

Line 1539: FEM_ENGINES_PKG.Tech_Message

1535:
1536: commit;
1537:
1538:
1539: FEM_ENGINES_PKG.Tech_Message
1540: ( p_severity => pc_log_level_event
1541: ,p_module => pc_module_name||c_func_name
1542: ,p_msg_text => 'Gathering statistics for FEM');
1543:

Line 1544: FEM_ENGINES_PKG.User_Message

1540: ( p_severity => pc_log_level_event
1541: ,p_module => pc_module_name||c_func_name
1542: ,p_msg_text => 'Gathering statistics for FEM');
1543:
1544: FEM_ENGINES_PKG.User_Message
1545: ( p_msg_text => 'Before Gathering statistics for FEM');
1546:
1547: -- fnd_stats.gather_schema_statistics('FEM', null, null, null, null);
1548: -- Bug 5084804

Line 1582: FEM_ENGINES_PKG.User_Message

1578: fnd_stats.GATHER_INDEX_STATS('FEM',pv_index_name(i));
1579: END LOOP;
1580: END IF;
1581:
1582: FEM_ENGINES_PKG.User_Message
1583: ( p_msg_text => 'After Gathering statistics for FEM');
1584:
1585: --
1586: -- Bug#6238739: Added to maintain FEM_LEDGER_DIM_VS_MAPS mapping table.

Line 1588: FEM_ENGINES_PKG.Tech_Message

1584:
1585: --
1586: -- Bug#6238739: Added to maintain FEM_LEDGER_DIM_VS_MAPS mapping table.
1587: --
1588: FEM_ENGINES_PKG.Tech_Message
1589: ( p_severity => pc_log_level_event
1590: ,p_module => pc_module_name||c_func_name
1591: ,p_msg_text => 'Calling Refresh_ledger_vs_maps API'
1592: ) ;

Line 1607: FEM_ENGINES_PKG.Tech_Message(

1603: RAISE FND_API.G_EXC_ERROR;
1604: END IF ;
1605: -- Bug#6238739: End
1606:
1607: FEM_ENGINES_PKG.Tech_Message(
1608: p_severity => pc_log_level_statement,
1609: p_module => pc_module_name || '.return_values',
1610: p_msg_text => 'v_completion_code=' || v_completion_code_final ||
1611: ', v_dim_process_row_cnt=' || v_dim_process_row_cnt ||

Line 1620: FEM_ENGINES_PKG.User_Message

1616: WHEN app_exceptions.application_exception THEN
1617: ROLLBACK;
1618: print_pkg_variable_values;
1619:
1620: FEM_ENGINES_PKG.User_Message
1621: (p_msg_text => fnd_message.get);
1622:
1623: FEM_ENGINES_PKG.Tech_Message
1624: (p_severity => pc_log_level_unexpected

Line 1623: FEM_ENGINES_PKG.Tech_Message

1619:
1620: FEM_ENGINES_PKG.User_Message
1621: (p_msg_text => fnd_message.get);
1622:
1623: FEM_ENGINES_PKG.Tech_Message
1624: (p_severity => pc_log_level_unexpected
1625: ,p_module => pc_module_name||c_func_name||'.unexpected_exception'
1626: ,p_msg_text => sqlerrm);
1627:

Line 1628: FEM_ENGINES_PKG.Tech_Message

1624: (p_severity => pc_log_level_unexpected
1625: ,p_module => pc_module_name||c_func_name||'.unexpected_exception'
1626: ,p_msg_text => sqlerrm);
1627:
1628: FEM_ENGINES_PKG.Tech_Message
1629: (p_severity => pc_log_level_unexpected
1630: ,p_module => pc_module_name||c_func_name||'.unexpected_exception'
1631: ,p_msg_text => 'Location before failure: '||pv_progress);
1632:

Line 1633: FEM_ENGINES_PKG.Tech_Message

1629: (p_severity => pc_log_level_unexpected
1630: ,p_module => pc_module_name||c_func_name||'.unexpected_exception'
1631: ,p_msg_text => 'Location before failure: '||pv_progress);
1632:
1633: FEM_ENGINES_PKG.Tech_Message
1634: (p_severity => pc_log_level_procedure
1635: ,p_module => pc_module_name||c_func_name||'.unexpected_exception'
1636: ,p_app_name => 'FEM'
1637: ,p_msg_name => 'FEM_GL_POST_203'

Line 1663: FEM_ENGINES_PKG.Tech_Message

1659: WHEN OTHERS THEN
1660: ROLLBACK;
1661: print_pkg_variable_values;
1662:
1663: FEM_ENGINES_PKG.Tech_Message
1664: (p_severity => pc_log_level_unexpected
1665: ,p_module => pc_module_name||c_func_name||'.unexpected_exception'
1666: ,p_msg_text => sqlerrm);
1667:

Line 1668: FEM_ENGINES_PKG.Tech_Message

1664: (p_severity => pc_log_level_unexpected
1665: ,p_module => pc_module_name||c_func_name||'.unexpected_exception'
1666: ,p_msg_text => sqlerrm);
1667:
1668: FEM_ENGINES_PKG.Tech_Message
1669: (p_severity => pc_log_level_unexpected
1670: ,p_module => pc_module_name||c_func_name||'.unexpected_exception'
1671: ,p_msg_text => 'Location before failure: '||pv_progress);
1672:

Line 1673: FEM_ENGINES_PKG.User_Message

1669: (p_severity => pc_log_level_unexpected
1670: ,p_module => pc_module_name||c_func_name||'.unexpected_exception'
1671: ,p_msg_text => 'Location before failure: '||pv_progress);
1672:
1673: FEM_ENGINES_PKG.User_Message
1674: (p_msg_text => sqlerrm);
1675:
1676: FEM_ENGINES_PKG.Tech_Message
1677: (p_severity => pc_log_level_procedure

Line 1676: FEM_ENGINES_PKG.Tech_Message

1672:
1673: FEM_ENGINES_PKG.User_Message
1674: (p_msg_text => sqlerrm);
1675:
1676: FEM_ENGINES_PKG.Tech_Message
1677: (p_severity => pc_log_level_procedure
1678: ,p_module => pc_module_name||c_func_name||'.unexpected_exception'
1679: ,p_app_name => 'FEM'
1680: ,p_msg_name => 'FEM_GL_POST_203'

Line 1716: FEM_ENGINES_PKG.Tech_Message

1712: v_user_id number;
1713: v_login_id number;
1714: c_func_name constant varchar2(30) := 'create_map_placeholder_records';
1715: BEGIN
1716: FEM_ENGINES_PKG.Tech_Message
1717: (p_severity => pc_log_level_procedure,
1718: p_module => pc_module_name||c_func_name,
1719: p_app_name => 'FEM',
1720: p_msg_name => 'FEM_GL_POST_201',

Line 1791: FEM_ENGINES_PKG.Tech_Message

1787: AND CHART_OF_ACCOUNTS_ID = p_coa_id
1788: AND GLCC.SUMMARY_FLAG = 'N';
1789:
1790: x_rows_processed := SQL%ROWCOUNT;
1791: FEM_ENGINES_PKG.Tech_Message
1792: (p_severity => pc_log_level_statement
1793: ,p_module => pc_module_name||c_func_name
1794: ,p_app_name => 'FEM'
1795: ,p_msg_name => 'FEM_GL_POST_216'

Line 1801: FEM_ENGINES_PKG.Tech_Message

1797: ,p_value1 => 'FEM_INTG_OGL_CCID_MAP'
1798: ,p_token2 => 'NUM'
1799: ,p_value2 => x_rows_processed);
1800:
1801: FEM_ENGINES_PKG.Tech_Message
1802: (p_severity => pc_log_level_procedure,
1803: p_module => pc_module_name || c_func_name,
1804: p_app_name => 'FEM',
1805: p_msg_name => 'FEM_GL_POST_202',

Line 1812: FEM_ENGINES_PKG.Tech_Message

1808: p_token2 => 'TIME',
1809: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
1810: EXCEPTION
1811: WHEN OTHERS THEN
1812: FEM_ENGINES_PKG.Tech_Message
1813: (p_severity => pc_log_level_unexpected
1814: ,p_module => pc_module_name||c_func_name||'.unexpected_exception'
1815: ,p_msg_text => sqlerrm);
1816:

Line 1818: FEM_ENGINES_PKG.User_Message

1814: ,p_module => pc_module_name||c_func_name||'.unexpected_exception'
1815: ,p_msg_text => sqlerrm);
1816:
1817:
1818: FEM_ENGINES_PKG.User_Message
1819: (p_msg_text => sqlerrm);
1820:
1821: FEM_ENGINES_PKG.Tech_Message
1822: (p_severity => pc_log_level_procedure

Line 1821: FEM_ENGINES_PKG.Tech_Message

1817:
1818: FEM_ENGINES_PKG.User_Message
1819: (p_msg_text => sqlerrm);
1820:
1821: FEM_ENGINES_PKG.Tech_Message
1822: (p_severity => pc_log_level_procedure
1823: ,p_module => pc_module_name||c_func_name||'.unexpected_exception'
1824: ,p_app_name => 'FEM'
1825: ,p_msg_name => 'FEM_GL_POST_203'

Line 1849: FEM_ENGINES_PKG.Tech_Message

1845: v_return_status VARCHAR2(100);
1846: v_msg_count NUMBER;
1847: v_msg_data VARCHAR2(2000);
1848: BEGIN
1849: FEM_ENGINES_PKG.Tech_Message
1850: (p_severity => pc_log_level_procedure,
1851: p_module => pc_module_name||c_func_name,
1852: p_app_name => 'FEM',
1853: p_msg_name => 'FEM_GL_POST_201',

Line 1919: FEM_ENGINES_PKG.Tech_Message

1915:
1916: IF v_vs_count = 0
1917: THEN
1918: BEGIN
1919: FEM_ENGINES_PKG.Tech_Message
1920: ( p_severity => pc_log_level_statement
1921: ,p_module => pc_module_name||c_func_name
1922: ,p_msg_text => 'Calling FEM_VALUE_SETS_PKG.insert_row with' ||pv_crlf||
1923: 'X_VALUE_SET_ID => '||p_fem_value_set_id||pv_crlf||

Line 1952: FEM_ENGINES_PKG.Tech_Message

1948: , X_LAST_UPDATE_DATE => SYSDATE
1949: , X_LAST_UPDATED_BY => pv_user_id
1950: , X_LAST_UPDATE_LOGIN => pv_login_id);
1951:
1952: FEM_ENGINES_PKG.Tech_Message
1953: ( p_severity => pc_log_level_statement
1954: ,p_module => pc_module_name||c_func_name
1955: ,p_msg_text => 'Row ID returned'||v_rowid);
1956:

Line 1981: FEM_ENGINES_PKG.Tech_Message

1977:
1978: EXCEPTION
1979: WHEN OTHERS THEN
1980: x_status := 0;
1981: FEM_ENGINES_PKG.Tech_Message
1982: (p_severity => pc_log_level_unexpected
1983: ,p_module => pc_module_name||c_func_name||'.unexpected_exception'
1984: ,p_msg_text => sqlerrm);
1985: raise_application_error(-20001, fnd_message.get);

Line 1988: FEM_ENGINES_PKG.Tech_Message

1984: ,p_msg_text => sqlerrm);
1985: raise_application_error(-20001, fnd_message.get);
1986: END;
1987: ELSE
1988: FEM_ENGINES_PKG.Tech_Message
1989: ( p_severity => pc_log_level_statement
1990: ,p_module => pc_module_name||c_func_name
1991: ,p_msg_text => 'FEM valueset already exists for '||p_fem_value_set_id);
1992:

Line 1994: FEM_ENGINES_PKG.Tech_Message

1990: ,p_module => pc_module_name||c_func_name
1991: ,p_msg_text => 'FEM valueset already exists for '||p_fem_value_set_id);
1992:
1993: END IF;
1994: FEM_ENGINES_PKG.Tech_Message
1995: (p_severity => pc_log_level_procedure,
1996: p_module => pc_module_name || c_func_name,
1997: p_app_name => 'FEM',
1998: p_msg_name => 'FEM_GL_POST_202',

Line 2007: FEM_ENGINES_PKG.Tech_Message

2003:
2004: EXCEPTION
2005: WHEN OTHERS THEN
2006: x_status := 0;
2007: FEM_ENGINES_PKG.Tech_Message
2008: (p_severity => pc_log_level_unexpected
2009: ,p_module => pc_module_name||c_func_name||'.unexpected_exception'
2010: ,p_msg_text => sqlerrm);
2011:

Line 2012: FEM_ENGINES_PKG.User_Message

2008: (p_severity => pc_log_level_unexpected
2009: ,p_module => pc_module_name||c_func_name||'.unexpected_exception'
2010: ,p_msg_text => sqlerrm);
2011:
2012: FEM_ENGINES_PKG.User_Message
2013: (p_msg_text => sqlerrm);
2014:
2015: FEM_ENGINES_PKG.Tech_Message
2016: (p_severity => pc_log_level_procedure

Line 2015: FEM_ENGINES_PKG.Tech_Message

2011:
2012: FEM_ENGINES_PKG.User_Message
2013: (p_msg_text => sqlerrm);
2014:
2015: FEM_ENGINES_PKG.Tech_Message
2016: (p_severity => pc_log_level_procedure
2017: ,p_module => pc_module_name||c_func_name||'.unexpected_exception'
2018: ,p_app_name => 'FEM'
2019: ,p_msg_name => 'FEM_GL_POST_203'

Line 2032: FEM_ENGINES_PKG.Tech_Message

2028:
2029: PROCEDURE print_pkg_variable_values IS
2030: c_func_name CONSTANT VARCHAR2(30) := '.print_pkg_variable_values';
2031: BEGIN
2032: FEM_ENGINES_PKG.Tech_Message
2033: ( p_severity => pc_log_level_procedure
2034: ,p_module => pc_module_name||c_func_name
2035: ,p_msg_text => 'Values of package variables'||pv_crlf||
2036: 'pv_dim_rule_obj_id:'||pv_dim_rule_obj_id||pv_crlf||

Line 2079: FEM_ENGINES_PKG.Tech_Message

2075: 'pv_pgm_app_id:'||pv_pgm_app_id||pv_crlf||
2076: 'pv_login_id:'||pv_login_id);
2077: IF pv_mapped_segs.count() = 5
2078: THEN
2079: FEM_ENGINES_PKG.Tech_Message
2080: ( p_severity => pc_log_level_procedure
2081: ,p_module => pc_module_name||c_func_name
2082: ,p_msg_text => 'Map Seg Info Contents'||pv_crlf||
2083: '-->pv_mapped_segs(1).application_column_name:'||pv_mapped_segs(1).application_column_name||pv_crlf||

Line 2231: FEM_ENGINES_PKG.Tech_Message

2227: and value_set_id = c_val_set_id ;
2228:
2229: BEGIN
2230:
2231: FEM_ENGINES_PKG.Tech_Message
2232: (p_severity => pc_log_level_procedure,
2233: p_module => pc_module_name || l_func_name,
2234: p_app_name => 'FEM',
2235: p_msg_name => 'FEM_GL_POST_201',

Line 2263: FEM_ENGINES_PKG.Tech_Message

2259: INTO l_obj_def_id
2260: FROM fem_object_definition_b
2261: WHERE object_id = p_dim_rule_obj_id ;
2262:
2263: FEM_ENGINES_PKG.Tech_Message
2264: (p_severity => pc_log_level_statement,
2265: p_module => pc_module_name || l_func_name,
2266: p_msg_text => 'l_chart_of_accounts_id:= ' || l_chart_of_accounts_id
2267: ||' l_global_vs_combo_id := ' || l_global_vs_combo_id

Line 2279: FEM_ENGINES_PKG.Tech_Message

2275: INTO l_dim_mapping_Option_code
2276: FROM fem_intg_dim_rule_defs
2277: WHERE dim_rule_obj_def_id = l_obj_def_id;
2278:
2279: FEM_ENGINES_PKG.Tech_Message
2280: (p_severity => pc_log_level_statement,
2281: p_module => pc_module_name || l_func_name,
2282: p_msg_text => 'l_dim_mapping_Option_code:'|| l_dim_mapping_Option_code);
2283:

Line 2299: FEM_ENGINES_PKG.Tech_Message

2295: l_memb_col_name
2296: FROM fem_xdim_dimensions
2297: WHERE dimension_id = l_dim_id;
2298:
2299: FEM_ENGINES_PKG.Tech_Message
2300: (p_severity => pc_log_level_statement,
2301: p_module => pc_module_name || l_func_name,
2302: p_msg_text => 'dimension_id:' || l_dim_id ||
2303: 'MEMBER_B_TABLE_NAME:=' || l_memb_b_tab_name ||

Line 2317: FEM_ENGINES_PKG.Tech_Message

2313: FROM fem_global_vs_combo_defs
2314: WHERE global_vs_combo_Id = l_global_vs_combo_id
2315: and dimension_id = l_dim_id;
2316:
2317: FEM_ENGINES_PKG.Tech_Message
2318: (p_severity => pc_log_level_statement,
2319: p_module => pc_module_name || l_func_name,
2320: p_msg_text => 'l_value_set_id:'|| l_value_set_id);
2321:

Line 2350: FEM_ENGINES_PKG.Tech_Message

2346: WHERE odb.object_id = idr.dim_rule_obj_id
2347: And idr.chart_of_accounts_id = l_chart_of_accounts_id
2348: AND idr.dimension_id = 0;
2349:
2350: FEM_ENGINES_PKG.Tech_Message
2351: (p_severity => pc_log_level_statement,
2352: p_module => pc_module_name || l_func_name,
2353: p_msg_text => 'l_intercomp_obj_id:'|| l_intercomp_obj_id ||
2354: 'l_intercomp_obj_def_id:'|| l_intercomp_obj_def_id);

Line 2365: FEM_ENGINES_PKG.Tech_Message

2361: FETCH BalRuleExec INTO count1;
2362: IF BalRuleExec%FOUND THEN
2363: close BalRuleExec;
2364: -- throw error out
2365: FEM_ENGINES_PKG.Tech_Message
2366: (p_severity => pc_log_level_unexpected,
2367: p_module => pc_module_name || l_func_name ,
2368: p_msg_name => 'FEM_INTG_DIM_RULE_POST_05');
2369:

Line 2373: FEM_ENGINES_PKG.User_Message

2369:
2370: x_retcode:=2;
2371: x_errbuf:=FND_MESSAGE.Get_String('FEM', 'FEM_INTG_DIM_RULE_POST_05');
2372:
2373: FEM_ENGINES_PKG.User_Message
2374: (p_app_name => 'FEM',
2375: p_msg_text => x_errbuf);
2376:
2377: FEM_ENGINES_PKG.Tech_Message

Line 2377: FEM_ENGINES_PKG.Tech_Message

2373: FEM_ENGINES_PKG.User_Message
2374: (p_app_name => 'FEM',
2375: p_msg_text => x_errbuf);
2376:
2377: FEM_ENGINES_PKG.Tech_Message
2378: (p_severity => pc_log_level_procedure,
2379: p_module => pc_module_name || l_func_name,
2380: p_app_name => 'FEM',
2381: p_msg_name => 'FEM_GL_POST_203',

Line 2398: FEM_ENGINES_PKG.Tech_Message

2394: FETCH FemDataExists INTO count1;
2395: IF FemDataExists%FOUND THEN
2396: close FemDataExists;
2397: -- throw error out
2398: FEM_ENGINES_PKG.Tech_Message
2399: (p_severity => pc_log_level_unexpected,
2400: p_module => pc_module_name || l_func_name ,
2401: p_msg_name => 'FEM_INTG_DIM_RULE_POST_03');
2402:

Line 2406: FEM_ENGINES_PKG.User_Message

2402:
2403: x_retcode:=2;
2404: x_errbuf:=FND_MESSAGE.Get_String('FEM', 'FEM_INTG_DIM_RULE_POST_03');
2405:
2406: FEM_ENGINES_PKG.User_Message
2407: (p_app_name => 'FEM',
2408: p_msg_text => x_errbuf);
2409:
2410: FEM_ENGINES_PKG.Tech_Message

Line 2410: FEM_ENGINES_PKG.Tech_Message

2406: FEM_ENGINES_PKG.User_Message
2407: (p_app_name => 'FEM',
2408: p_msg_text => x_errbuf);
2409:
2410: FEM_ENGINES_PKG.Tech_Message
2411: (p_severity => pc_log_level_procedure,
2412: p_module => pc_module_name || l_func_name,
2413: p_app_name => 'FEM',
2414: p_msg_name => 'FEM_GL_POST_203',

Line 2428: FEM_ENGINES_PKG.User_Message

2424:
2425:
2426:
2427:
2428: FEM_ENGINES_PKG.User_Message
2429: (p_app_name => 'FEM',
2430: p_msg_name => 'FEM_INTG_DIM_RULE_POST_01');
2431:
2432: -- getting the max reuest ID

Line 2440: FEM_ENGINES_PKG.Tech_Message

2436: FROM fem_pl_object_executions o
2437: WHERE o.display_flag = 'Y'
2438: AND o.object_id = p_dim_rule_obj_id;
2439:
2440: FEM_ENGINES_PKG.Tech_Message
2441: (p_severity => pc_log_level_statement,
2442: p_module => pc_module_name || l_func_name,
2443: p_msg_text => 'Most recent request Id ' || l_request_id || ' for object id ' || p_dim_rule_obj_id);
2444:

Line 2458: FEM_ENGINES_PKG.User_Message

2454: argument3 => 1100,
2455: argument4 => 'Y',
2456: argument5 => 'N');
2457:
2458: FEM_ENGINES_PKG.User_Message
2459: (p_app_name => 'FEM',
2460: p_msg_name => 'FEM_INTG_DIM_RULE_POST_02',
2461: p_token1 => 'DIM_RULE_OBJ_ID',
2462: p_value1 => p_dim_rule_obj_id);

Line 2464: FEM_ENGINES_PKG.Tech_Message

2460: p_msg_name => 'FEM_INTG_DIM_RULE_POST_02',
2461: p_token1 => 'DIM_RULE_OBJ_ID',
2462: p_value1 => p_dim_rule_obj_id);
2463:
2464: FEM_ENGINES_PKG.Tech_Message
2465: (p_severity => pc_log_level_statement,
2466: p_module => pc_module_name || l_func_name,
2467: p_msg_name => 'FEM_INTG_DIM_RULE_POST_02',
2468: p_token1 => 'DIM_RULE_OBJ_ID',

Line 2475: FEM_ENGINES_PKG.Tech_Message

2471: -- Updating the FEM_INTG_OGL_CCID_MAP
2472:
2473: IF (l_dim_id <> 29) THEN
2474:
2475: FEM_ENGINES_PKG.Tech_Message
2476: (p_severity => pc_log_level_statement,
2477: p_module => pc_module_name || l_func_name,
2478: p_msg_text => 'Updating FEM_INTG_OGL_CCID_MAP setting ' || l_memb_col_name || ' to -1');
2479:

Line 2493: FEM_ENGINES_PKG.Tech_Message

2489: END IF;
2490:
2491: temp_stmt := temp_stmt || ' WHERE GLOBAL_VS_COMBO_ID =:1 ' ;
2492:
2493: FEM_ENGINES_PKG.Tech_Message
2494: (p_severity => pc_log_level_statement,
2495: p_module => pc_module_name || l_func_name,
2496: p_app_name => 'FEM',
2497: p_msg_name => 'FEM_GL_POST_204',

Line 2510: FEM_ENGINES_PKG.Tech_Message

2506: END IF;
2507:
2508: -- Updating the fem_global_vs_combo_defs
2509:
2510: FEM_ENGINES_PKG.Tech_Message
2511: (p_severity => pc_log_level_statement,
2512: p_module => pc_module_name || l_func_name,
2513: p_msg_text => 'Updating fem_global_vs_combo_defs setting value_set_id to -1 ');
2514:

Line 2529: FEM_ENGINES_PKG.Tech_Message

2525: END IF;
2526:
2527: -- updating the dimension rule defs.
2528:
2529: FEM_ENGINES_PKG.Tech_Message
2530: (p_severity => pc_log_level_statement,
2531: p_module => pc_module_name || l_func_name,
2532: p_msg_text => 'Updating fem_intg_dim_rule_defs setting MAX_CCID_PROCESSED,MAX_FLEX_VALUE_ID_PROCESSED,FEM_VALUE_SET_ID to null ');
2533:

Line 2543: FEM_ENGINES_PKG.Tech_Message

2539:
2540: -- set intercompany dimension rule definition values if dimension is organization
2541:
2542: IF(l_dim_id = 8) THEN
2543: FEM_ENGINES_PKG.Tech_Message
2544: (p_severity => pc_log_level_statement,
2545: p_module => pc_module_name || l_func_name,
2546: p_msg_text => 'Updating fem_intg_dim_rule_defs setting DEFAULT_MEMBER_ID,DEFAULT_MEMBER_VALUE_SET_ID to null for intercompany dimension');
2547:

Line 2571: FEM_ENGINES_PKG.Tech_Message

2567: FETCH GVSCExistsForFemValueSet INTO dummy_val;
2568: IF GVSCExistsForFemValueSet%NOTFOUND THEN
2569: close GVSCExistsForFemValueSet;
2570: l_gvsc_exist_flag := false;
2571: FEM_ENGINES_PKG.Tech_Message
2572: (p_severity => pc_log_level_statement,
2573: p_module => pc_module_name || l_func_name,
2574: p_msg_text => 'NO global value set combination exists for value set:= ' || l_value_set_id);
2575: ELSE

Line 2593: FEM_ENGINES_PKG.Tech_Message

2589: IF exec_cur%NOTFOUND THEN
2590: close exec_cur;
2591: l_found_hier_flag := false;
2592:
2593: FEM_ENGINES_PKG.Tech_Message
2594: (p_severity => pc_log_level_statement,
2595: p_module => pc_module_name || l_func_name,
2596: p_msg_text => 'no hierarchy exists that uses this fem value set');
2597: ELSE

Line 2606: FEM_ENGINES_PKG.Tech_Message

2602:
2603: temp_query := 'Delete from ' || l_memb_b_tab_name ||
2604: ' where value_set_id =:1 ';
2605:
2606: FEM_ENGINES_PKG.Tech_Message
2607: (p_severity => pc_log_level_statement,
2608: p_module => pc_module_name || l_func_name,
2609: p_app_name => 'FEM',
2610: p_msg_name => 'FEM_GL_POST_204',

Line 2621: FEM_ENGINES_PKG.Tech_Message

2617:
2618: temp_query := 'Delete from ' || l_memb_tl_tab_name ||
2619: ' where value_set_id =:1 ';
2620:
2621: FEM_ENGINES_PKG.Tech_Message
2622: (p_severity => pc_log_level_statement,
2623: p_module => pc_module_name || l_func_name,
2624: p_app_name => 'FEM',
2625: p_msg_name => 'FEM_GL_POST_204',

Line 2636: FEM_ENGINES_PKG.Tech_Message

2632:
2633: temp_query := 'Delete from ' || l_attr_tab_name ||
2634: ' where value_set_id =:1 ';
2635:
2636: FEM_ENGINES_PKG.Tech_Message
2637: (p_severity => pc_log_level_statement,
2638: p_module => pc_module_name || l_func_name,
2639: p_app_name => 'FEM',
2640: p_msg_name => 'FEM_GL_POST_204',

Line 2649: FEM_ENGINES_PKG.Tech_Message

2645:
2646: EXECUTE IMMEDIATE temp_query using l_value_set_id;
2647:
2648: -- removing the rows for value sets
2649: FEM_ENGINES_PKG.Tech_Message
2650: (p_severity => pc_log_level_statement,
2651: p_module => pc_module_name || l_func_name ,
2652: p_msg_text => 'removing the rows for value sets');
2653:

Line 2662: FEM_ENGINES_PKG.Tech_Message

2658:
2659: -- retriveing company value set_id for the retrieved global_value_set_id
2660:
2661: IF (comp_val_set_id<>-1) THEN
2662: FEM_ENGINES_PKG.Tech_Message
2663: (p_severity => pc_log_level_statement,
2664: p_module => pc_module_name || l_func_name ,
2665: p_msg_text => 'deleting the company value sets');
2666:

Line 2680: FEM_ENGINES_PKG.Tech_Message

2676:
2677: -- retriveing cost center value set_id for the retrieved global_value_set_id
2678:
2679: IF (cctr_val_set_id<>-1) THEN
2680: FEM_ENGINES_PKG.Tech_Message
2681: (p_severity => pc_log_level_statement,
2682: p_module => pc_module_name || l_func_name ,
2683: p_msg_text => 'deleting the cost center value sets');
2684:

Line 2697: FEM_ENGINES_PKG.Tech_Message

2693:
2694: END IF;
2695:
2696: -- remove row from fem_intg_aol_valset_map
2697: FEM_ENGINES_PKG.Tech_Message
2698: (p_severity => pc_log_level_statement,
2699: p_module => pc_module_name || l_func_name ,
2700: p_msg_text => 'removing row from fem_intg_aol_valset_map');
2701:

Line 2711: FEM_ENGINES_PKG.Tech_Message

2707: ELSIF (l_found_hier_flag) THEN
2708: x_errbuf:= FND_MESSAGE.Get_String('FEM', 'FEM_INTG_DIM_RULE_POST_04');
2709: END IF;
2710:
2711: FEM_ENGINES_PKG.Tech_Message
2712: (p_severity => pc_log_level_exception,
2713: p_module => pc_module_name || l_func_name ,
2714: p_msg_text => x_errbuf);
2715:

Line 2716: FEM_ENGINES_PKG.User_Message

2712: (p_severity => pc_log_level_exception,
2713: p_module => pc_module_name || l_func_name ,
2714: p_msg_text => x_errbuf);
2715:
2716: FEM_ENGINES_PKG.User_Message
2717: (p_app_name => 'FEM',
2718: p_msg_text => x_errbuf);
2719:
2720: x_retcode:=1;

Line 2726: FEM_ENGINES_PKG.Tech_Message

2722: END IF;
2723:
2724: END IF;
2725:
2726: FEM_ENGINES_PKG.Tech_Message
2727: (p_severity => pc_log_level_procedure,
2728: p_module => pc_module_name || l_func_name ,
2729: p_msg_name => 'FEM_GL_POST_202',
2730: p_token1 => 'FUNC_NAME',

Line 2743: FEM_ENGINES_PKG.Tech_Message

2739:
2740: x_retcode:=2;
2741: x_errbuf:=SQLERRM;
2742:
2743: FEM_ENGINES_PKG.Tech_Message
2744: (p_severity => pc_log_level_exception,
2745: p_module => pc_module_name || l_func_name,
2746: p_app_name => 'FEM',
2747: p_msg_name => 'FEM_GL_POST_215',

Line 2751: FEM_ENGINES_PKG.User_Message

2747: p_msg_name => 'FEM_GL_POST_215',
2748: p_token1 => 'ERR_MSG',
2749: p_value1 => SQLERRM);
2750:
2751: FEM_ENGINES_PKG.User_Message
2752: (p_app_name => 'FEM',
2753: p_msg_name => 'FEM_GL_POST_215',
2754: p_token1 => 'ERR_MSG',
2755: p_value1 => SQLERRM);

Line 2757: FEM_ENGINES_PKG.Tech_Message

2753: p_msg_name => 'FEM_GL_POST_215',
2754: p_token1 => 'ERR_MSG',
2755: p_value1 => SQLERRM);
2756:
2757: FEM_ENGINES_PKG.Tech_Message
2758: (p_severity => pc_log_level_procedure,
2759: p_module => pc_module_name || l_func_name,
2760: p_app_name => 'FEM',
2761: p_msg_name => 'FEM_GL_POST_203',