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

Line 417: FEM_ENGINES_PKG.Tech_Message (

413:
414: -- Initialize Message Stack on FND_MSG_PUB
415: FND_MSG_PUB.Initialize;
416:
417: FEM_ENGINES_PKG.Tech_Message (
418: p_severity => G_LOG_LEVEL_2
419: ,p_module => G_BLOCK||'.'||l_api_name
420: ,p_msg_text => 'BEGIN'
421: );

Line 438: FEM_ENGINES_PKG.tech_message (

434:
435: ------------------------------------------------------------------------------
436: -- STEP 1: Request Preparation
437: ------------------------------------------------------------------------------
438: FEM_ENGINES_PKG.tech_message (
439: p_severity => G_LOG_LEVEL_1
440: ,p_module => G_BLOCK||'.'||l_api_name
441: ,p_msg_text => 'Step 1: Request Preperation'
442: );

Line 461: FEM_ENGINES_PKG.Tech_Message (

457:
458: ------------------------------------------------------------------------------
459: -- STEP 2: Dynamic SQL Statments Preparation
460: ------------------------------------------------------------------------------
461: FEM_ENGINES_PKG.Tech_Message (
462: p_severity => G_LOG_LEVEL_1
463: ,p_module => G_BLOCK||'.'||l_api_name
464: ,p_msg_text => 'Step 2: Dynamic SQL Statments Preparation'
465: );

Line 475: FEM_ENGINES_PKG.Tech_Message (

471:
472: ------------------------------------------------------------------------------
473: -- STEP 3: Register Request
474: ------------------------------------------------------------------------------
475: FEM_ENGINES_PKG.Tech_Message (
476: p_severity => G_LOG_LEVEL_1
477: ,p_module => G_BLOCK||'.'||l_api_name
478: ,p_msg_text => 'Step 3: Register Request'
479: );

Line 488: FEM_ENGINES_PKG.Tech_Message (

484:
485: ------------------------------------------------------------------------------
486: -- STEP 4: Start Rollup Processing
487: ------------------------------------------------------------------------------
488: FEM_ENGINES_PKG.Tech_Message (
489: p_severity => G_LOG_LEVEL_1
490: ,p_module => G_BLOCK||'.'||l_api_name
491: ,p_msg_text => 'Step 4: Start Rollup Processing'
492: );

Line 504: FEM_ENGINES_PKG.Tech_Message (

500:
501: ----------------------------------------------------------------------------
502: -- STEP 4.1: Single Rule Submit Processing
503: ----------------------------------------------------------------------------
504: FEM_ENGINES_PKG.Tech_Message (
505: p_severity => G_LOG_LEVEL_1
506: ,p_module => G_BLOCK||'.'||l_api_name
507: ,p_msg_text => 'Step 4.1: Single Rule Submit Processing'
508: );

Line 516: FEM_ENGINES_PKG.Tech_Message (

512:
513: ----------------------------------------------------------------------------
514: -- STEP 4.1.1: Validate Single Rule Submit
515: ----------------------------------------------------------------------------
516: FEM_ENGINES_PKG.Tech_Message (
517: p_severity => G_LOG_LEVEL_1
518: ,p_module => G_BLOCK||'.'||l_api_name
519: ,p_msg_text => 'Step 4.1.1: Single Rule Submit Processing'
520: );

Line 533: FEM_ENGINES_PKG.User_Message (

529: ,p_ledger_id => l_request_rec.ledger_id
530: );
531:
532: if (l_err_code <> 0) then
533: FEM_ENGINES_PKG.User_Message (
534: p_app_name => G_FEM
535: ,p_msg_name => l_err_msg
536: );
537: raise g_rollup_request_error;

Line 543: FEM_ENGINES_PKG.Tech_Message (

539:
540: ----------------------------------------------------------------------------
541: -- STEP 4.1.2: Rollup Single Rule
542: ----------------------------------------------------------------------------
543: FEM_ENGINES_PKG.Tech_Message (
544: p_severity => G_LOG_LEVEL_1
545: ,p_module => G_BLOCK||'.'||l_api_name
546: ,p_msg_text => 'Step 4.1.2: Rollup Single Rule'
547: );

Line 573: FEM_ENGINES_PKG.Tech_Message (

569:
570: ----------------------------------------------------------------------------
571: -- STEP 4.2: Rule Set Processing
572: ----------------------------------------------------------------------------
573: FEM_ENGINES_PKG.Tech_Message (
574: p_severity => G_LOG_LEVEL_1
575: ,p_module => G_BLOCK||'.'||l_api_name
576: ,p_msg_text => 'Step 4.2: Rule Set Processing'
577: );

Line 582: FEM_ENGINES_PKG.Tech_Message (

578:
579: ----------------------------------------------------------------------------
580: -- STEP 4.2.1: Rule Set Pre Processing
581: ----------------------------------------------------------------------------
582: FEM_ENGINES_PKG.Tech_Message (
583: p_severity => G_LOG_LEVEL_1
584: ,p_module => G_BLOCK||'.'||l_api_name
585: ,p_msg_text => 'Step 4.2.1: Rule Set Pre Processing'
586: );

Line 616: FEM_ENGINES_PKG.Tech_Message (

612:
613: ----------------------------------------------------------------------------
614: -- STEP 4.2.2: Loop through all Rule Set Rules
615: ----------------------------------------------------------------------------
616: FEM_ENGINES_PKG.Tech_Message (
617: p_severity => G_LOG_LEVEL_1
618: ,p_module => G_BLOCK||'.'||l_api_name
619: ,p_msg_text => 'Step 4.2.2: Loop through all Rule Set Rules'
620: );

Line 648: FEM_ENGINES_PKG.Tech_Message (

644:
645: ------------------------------------------------------------------------
646: -- STEP 4.2.3: Rollup Rule Set Rule
647: ------------------------------------------------------------------------
648: FEM_ENGINES_PKG.Tech_Message (
649: p_severity => G_LOG_LEVEL_1
650: ,p_module => G_BLOCK||'.'||l_api_name
651: ,p_msg_text => 'Step 4.2.3: Rollup Rule Set Rule #'||to_char(l_rollup_sequence)
652: );

Line 693: FEM_ENGINES_PKG.Tech_Message (

689:
690: ------------------------------------------------------------------------------
691: -- STEP 5: Request Post Processing.
692: ------------------------------------------------------------------------------
693: FEM_ENGINES_PKG.Tech_Message (
694: p_severity => G_LOG_LEVEL_1
695: ,p_module => G_BLOCK||'.'||l_api_name
696: ,p_msg_text => 'Step 5: Request Post Processing'
697: );

Line 704: FEM_ENGINES_PKG.Tech_Message (

700: p_request_rec => l_request_rec
701: ,p_exec_status_code => G_EXEC_STATUS_SUCCESS
702: );
703:
704: FEM_ENGINES_PKG.Tech_Message (
705: p_severity => G_LOG_LEVEL_2
706: ,p_module => G_BLOCK||'.'||l_api_name
707: ,p_msg_text => 'END'
708: );

Line 725: FEM_ENGINES_PKG.Tech_Message (

721: );
722:
723: l_completion_status := FND_CONCURRENT.Set_Completion_Status('ERROR',null);
724:
725: FEM_ENGINES_PKG.Tech_Message (
726: p_severity => G_LOG_LEVEL_6
727: ,p_module => G_BLOCK||'.'||l_api_name
728: ,p_msg_text => 'Rollup Request Exception'
729: );

Line 747: FEM_ENGINES_PKG.Tech_Message (

743: );
744:
745: l_completion_status := FND_CONCURRENT.Set_Completion_Status('ERROR',null);
746:
747: FEM_ENGINES_PKG.Tech_Message (
748: p_severity => G_LOG_LEVEL_6
749: ,p_module => G_BLOCK||'.'||l_api_name||'.Unexpected_Exception'
750: ,p_msg_text => g_prg_msg
751: );

Line 753: FEM_ENGINES_PKG.Tech_Message (

749: ,p_module => G_BLOCK||'.'||l_api_name||'.Unexpected_Exception'
750: ,p_msg_text => g_prg_msg
751: );
752:
753: FEM_ENGINES_PKG.Tech_Message (
754: p_severity => G_LOG_LEVEL_6
755: ,p_module => G_BLOCK||'.'||l_api_name||'.Unexpected_Exception'
756: ,p_msg_text => g_callstack
757: );

Line 759: FEM_ENGINES_PKG.User_Message (

755: ,p_module => G_BLOCK||'.'||l_api_name||'.Unexpected_Exception'
756: ,p_msg_text => g_callstack
757: );
758:
759: FEM_ENGINES_PKG.User_Message (
760: p_app_name => G_FEM
761: ,p_msg_name => G_UNEXPECTED_ERROR
762: ,p_token1 => 'ERR_MSG'
763: ,p_value1 => g_prg_msg

Line 814: FEM_ENGINES_PKG.Tech_Message (

810: l_request_prep_error exception;
811:
812: BEGIN
813:
814: FEM_ENGINES_PKG.Tech_Message (
815: p_severity => G_LOG_LEVEL_2
816: ,p_module => G_BLOCK||'.'||l_api_name
817: ,p_msg_text => 'BEGIN'
818: );

Line 880: FEM_ENGINES_PKG.User_Message (

876: ,x_request_rec.pgm_app_id
877: );
878:
879: if (g_currency_conv_type is null) then
880: FEM_ENGINES_PKG.User_Message (
881: p_app_name => G_FEM
882: ,p_msg_name => G_ENG_NO_PROF_OPTION_VAL_ERR
883: ,p_token1 => 'PROFILE_OPTION_NAME'
884: ,p_value1 => 'FEM_CURRENCY_CONVERSION_TYPE'

Line 903: FEM_ENGINES_PKG.User_Message (

899: from fem_object_catalog_b
900: where object_id = x_request_rec.submit_obj_id;
901: exception
902: when others then
903: FEM_ENGINES_PKG.User_Message (
904: p_app_name => G_FEM
905: ,p_msg_name => G_ENG_NO_SUBMIT_OBJ_ERR
906: ,p_token1 => 'OBJECT_ID'
907: ,p_value1 => x_request_rec.submit_obj_id

Line 923: FEM_ENGINES_PKG.User_Message (

919: from fem_object_catalog_vl
920: where object_id = x_request_rec.ruleset_obj_id;
921: exception
922: when others then
923: FEM_ENGINES_PKG.User_Message (
924: p_app_name => G_FEM
925: ,p_msg_name => G_ENG_NO_OBJ_ERR
926: ,p_token1 => 'OBJECT_TYPE_MEANING'
927: ,p_value1 => Get_Object_Type_Name('RULE_SET')

Line 949: FEM_ENGINES_PKG.User_Message (

945: from fem_rule_sets
946: where rule_set_obj_def_id = x_request_rec.ruleset_obj_def_id;
947: exception
948: when others then
949: FEM_ENGINES_PKG.User_Message (
950: p_app_name => G_FEM
951: ,p_msg_name => G_ENG_NO_OBJ_DEF_DTL_ERR
952: ,p_token1 => 'TABLE_NAME'
953: ,p_value1 => 'FEM_RULE_SETS'

Line 1019: FEM_ENGINES_PKG.User_Message (

1015: ' where stat_rollup_obj_def_id = :b_rollup_obj_def_id';
1016:
1017: else
1018:
1019: FEM_ENGINES_PKG.User_Message (
1020: p_app_name => G_FEM
1021: ,p_msg_name => G_ENG_BAD_OBJ_TYPE_ERR
1022: ,p_token1 => 'OBJECT_TYPE_CODE'
1023: ,p_value1 => x_request_rec.rollup_obj_type_code

Line 1049: FEM_ENGINES_PKG.User_Message (

1045: where table_classification_code = 'ABM_LEDGER'
1046: and table_name = 'FEM_BALANCES';
1047: exception
1048: when no_data_found then
1049: FEM_ENGINES_PKG.User_Message (
1050: p_app_name => G_FEM
1051: ,p_msg_name => G_NO_TABLE_CLASS_ERR
1052: ,p_token1 => 'TABLE_NAME'
1053: ,p_value1 => 'FEM_BALANCES'

Line 1098: FEM_ENGINES_PKG.User_Message (

1094: from fem_source_systems_b
1095: where source_system_display_code = G_PFT_SOURCE_SYSTEM_DC;
1096: exception
1097: when others then
1098: FEM_ENGINES_PKG.User_Message (
1099: p_app_name => G_FEM
1100: ,p_msg_name => G_ENG_NO_DIM_MEMBER_ERR
1101: ,p_token1 => 'TABLE_NAME'
1102: ,p_value1 => 'FEM_SOURCE_SYSTEMS_B'

Line 1121: FEM_ENGINES_PKG.User_Message (

1117: from fem_object_definition_b
1118: where object_definition_id = x_request_rec.dataset_grp_obj_def_id;
1119: exception
1120: when others then
1121: FEM_ENGINES_PKG.User_Message (
1122: p_app_name => G_FEM
1123: ,p_msg_name => G_ENG_NO_OBJ_ERR
1124: ,p_token1 => 'OBJECT_TYPE_MEANING'
1125: ,p_value1 => Get_Object_Type_Name('DATASET_IO_DEFINITION')

Line 1152: FEM_ENGINES_PKG.User_Message (

1148: ,fem_folders_vl f
1149: where obj.object_id = x_request_rec.dataset_grp_obj_id
1150: and f.folder_id = obj.folder_id;
1151:
1152: FEM_ENGINES_PKG.User_Message (
1153: p_app_name => G_FEM
1154: ,p_msg_name => G_ENG_NO_OUTPUT_DS_ERR
1155: ,p_token1 => 'FOLDER_NAME'
1156: ,p_value1 => l_folder_name

Line 1190: FEM_ENGINES_PKG.User_Message (

1186: raise l_request_prep_error;
1187: end if;
1188:
1189: if (x_input_ds_b_where_clause is null) then
1190: FEM_ENGINES_PKG.User_Message (
1191: p_app_name => G_FEM
1192: ,p_msg_name => G_ENG_BAD_DS_WCLAUSE_ERR
1193: ,p_token1 => 'DATASET_GRP_OBJ_DEF_ID'
1194: ,p_value1 => x_request_rec.dataset_grp_obj_def_id

Line 1234: FEM_ENGINES_PKG.User_Message (

1230: raise l_request_prep_error;
1231: end if;
1232:
1233: if (x_input_ds_q_where_clause is null) then
1234: FEM_ENGINES_PKG.User_Message (
1235: p_app_name => G_FEM
1236: ,p_msg_name => G_ENG_BAD_DS_WCLAUSE_ERR
1237: ,p_token1 => 'DATASET_GRP_OBJ_DEF_ID'
1238: ,p_value1 => x_request_rec.dataset_grp_obj_def_id

Line 1297: FEM_ENGINES_PKG.Tech_Message (

1293:
1294: -- Log all Request Record Parameters if we have low level debugging
1295: if ( FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) ) then
1296:
1297: FEM_ENGINES_PKG.Tech_Message (
1298: p_severity => G_LOG_LEVEL_1
1299: ,p_module => G_BLOCK||'.'||l_api_name||'.x_request_rec'
1300: ,p_msg_text =>
1301: ' dataset_grp_obj_def_id='||x_request_rec.dataset_grp_obj_def_id||

Line 1330: FEM_ENGINES_PKG.Tech_Message (

1326: );
1327:
1328: end if;
1329:
1330: FEM_ENGINES_PKG.Tech_Message (
1331: p_severity => G_LOG_LEVEL_2
1332: ,p_module => G_BLOCK||'.'||l_api_name
1333: ,p_msg_text => 'END'
1334: );

Line 1340: FEM_ENGINES_PKG.Tech_Message (

1336: EXCEPTION
1337:
1338: when l_request_prep_error then
1339:
1340: FEM_ENGINES_PKG.Tech_Message (
1341: p_severity => G_LOG_LEVEL_6
1342: ,p_module => G_BLOCK||'.'||l_api_name
1343: ,p_msg_text => 'Request Preperation Exception'
1344: );

Line 1379: FEM_ENGINES_PKG.Tech_Message (

1375: l_object_type_code varchar2(30);
1376:
1377: BEGIN
1378:
1379: FEM_ENGINES_PKG.Tech_Message (
1380: p_severity => G_LOG_LEVEL_2
1381: ,p_module => G_BLOCK||'.'||l_api_name
1382: ,p_msg_text => 'BEGIN'
1383: );

Line 1395: FEM_ENGINES_PKG.Tech_Message (

1391: and d.object_id = o.object_id
1392: and p_effective_date between d.effective_start_date and d.effective_end_date
1393: and d.old_approved_copy_flag = 'N';
1394:
1395: FEM_ENGINES_PKG.Tech_Message (
1396: p_severity => G_LOG_LEVEL_2
1397: ,p_module => G_BLOCK||'.'||l_api_name
1398: ,p_msg_text => 'END'
1399: );

Line 1412: FEM_ENGINES_PKG.User_Message (

1408: ,l_object_type_code
1409: from fem_object_catalog_vl
1410: where object_id = p_object_id;
1411:
1412: FEM_ENGINES_PKG.User_Message (
1413: p_app_name => G_FEM
1414: ,p_msg_name => G_ENG_NO_OBJ_DEF_ERR
1415: ,p_token1 => 'OBJECT_TYPE_MEANING'
1416: ,p_value1 => Get_Object_Type_Name(l_object_type_code)

Line 1451: FEM_ENGINES_PKG.Tech_Message (

1447: l_api_name constant varchar2(30) := 'Get_Dimension_Record';
1448:
1449: BEGIN
1450:
1451: FEM_ENGINES_PKG.Tech_Message (
1452: p_severity => G_LOG_LEVEL_2
1453: ,p_module => G_BLOCK||'.'||l_api_name
1454: ,p_msg_text => 'BEGIN'
1455: );

Line 1483: FEM_ENGINES_PKG.Tech_Message (

1479: x_dimension_rec.hier_rollup_table := 'FEM_RU_ACTIVITIES_HIER_T';
1480:
1481: end if;
1482:
1483: FEM_ENGINES_PKG.Tech_Message (
1484: p_severity => G_LOG_LEVEL_2
1485: ,p_module => G_BLOCK||'.'||l_api_name
1486: ,p_msg_text => 'END'
1487: );

Line 1493: FEM_ENGINES_PKG.User_Message (

1489: EXCEPTION
1490:
1491: when no_data_found then
1492:
1493: FEM_ENGINES_PKG.User_Message (
1494: p_app_name => G_FEM
1495: ,p_msg_name => G_ENG_NO_DIM_DTL_ERR
1496: ,p_token1 => 'DIMENSION_VARCHAR_LABEL'
1497: ,p_value1 => p_dimension_varchar_label

Line 1539: FEM_ENGINES_PKG.Tech_Message (

1535: l_get_dim_attr_val_error exception;
1536:
1537: BEGIN
1538:
1539: FEM_ENGINES_PKG.Tech_Message (
1540: p_severity => G_LOG_LEVEL_2
1541: ,p_module => G_BLOCK||'.'||l_api_name
1542: ,p_msg_text => 'BEGIN'
1543: );

Line 1568: FEM_ENGINES_PKG.User_Message (

1564: ,l_attr_version_id
1565: ,p_member_id;
1566: exception
1567: when others then
1568: FEM_ENGINES_PKG.User_Message (
1569: p_app_name => G_FEM
1570: ,p_msg_name => G_ENG_NO_DIM_ATTR_VAL_ERR
1571: ,p_token1 => 'DIMENSION_VARCHAR_LABEL'
1572: ,p_value1 => p_dimension_varchar_label

Line 1579: FEM_ENGINES_PKG.Tech_Message (

1575: );
1576: raise l_get_dim_attr_val_error;
1577: end;
1578:
1579: FEM_ENGINES_PKG.Tech_Message (
1580: p_severity => G_LOG_LEVEL_2
1581: ,p_module => G_BLOCK||'.'||l_api_name
1582: ,p_msg_text => 'END'
1583: );

Line 1589: FEM_ENGINES_PKG.Tech_Message (

1585: EXCEPTION
1586:
1587: when l_get_dim_attr_val_error then
1588:
1589: FEM_ENGINES_PKG.Tech_Message (
1590: p_severity => G_LOG_LEVEL_6
1591: ,p_module => G_BLOCK||'.'||l_api_name
1592: ,p_msg_text => 'Get Dimension Attribute Value Exception'
1593: );

Line 1630: FEM_ENGINES_PKG.Tech_Message (

1626: l_get_ledger_curr_code_error exception;
1627:
1628: BEGIN
1629:
1630: FEM_ENGINES_PKG.Tech_Message (
1631: p_severity => G_LOG_LEVEL_2
1632: ,p_module => G_BLOCK||'.'||l_api_name
1633: ,p_msg_text => 'BEGIN'
1634: );

Line 1659: FEM_ENGINES_PKG.User_Message (

1655: and version_id = g_ledger_curr_attr_version_id
1656: and ledger_id = p_ledger_id;
1657: exception
1658: when others then
1659: FEM_ENGINES_PKG.User_Message (
1660: p_app_name => G_FEM
1661: ,p_msg_name => G_ENG_NO_DIM_ATTR_VAL_ERR
1662: ,p_token1 => 'DIMENSION_VARCHAR_LABEL'
1663: ,p_value1 => 'LEDGER'

Line 1670: FEM_ENGINES_PKG.Tech_Message (

1666: );
1667: raise l_get_ledger_curr_code_error;
1668: end;
1669:
1670: FEM_ENGINES_PKG.Tech_Message (
1671: p_severity => G_LOG_LEVEL_2
1672: ,p_module => G_BLOCK||'.'||l_api_name
1673: ,p_msg_text => 'END'
1674: );

Line 1680: FEM_ENGINES_PKG.Tech_Message (

1676: EXCEPTION
1677:
1678: when l_get_ledger_curr_code_error then
1679:
1680: FEM_ENGINES_PKG.Tech_Message (
1681: p_severity => G_LOG_LEVEL_6
1682: ,p_module => G_BLOCK||'.'||l_api_name
1683: ,p_msg_text => 'Get Ledger Currency Code Exception'
1684: );

Line 1719: FEM_ENGINES_PKG.Tech_Message (

1715: l_get_dim_attr_error exception;
1716:
1717: BEGIN
1718:
1719: FEM_ENGINES_PKG.Tech_Message (
1720: p_severity => G_LOG_LEVEL_2
1721: ,p_module => G_BLOCK||'.'||l_api_name
1722: ,p_msg_text => 'BEGIN'
1723: );

Line 1743: FEM_ENGINES_PKG.User_Message (

1739: and ver.attribute_id = att.attribute_id
1740: and ver.default_version_flag = 'Y';
1741: exception
1742: when others then
1743: FEM_ENGINES_PKG.User_Message (
1744: p_app_name => G_FEM
1745: ,p_msg_name => G_ENG_NO_DIM_ATTR_VER_ERR
1746: ,p_token1 => 'DIMENSION_VARCHAR_LABEL'
1747: ,p_value1 => p_dimension_varchar_label

Line 1754: FEM_ENGINES_PKG.Tech_Message (

1750: );
1751: raise l_get_dim_attr_error;
1752: end;
1753:
1754: FEM_ENGINES_PKG.Tech_Message (
1755: p_severity => G_LOG_LEVEL_2
1756: ,p_module => G_BLOCK||'.'||l_api_name
1757: ,p_msg_text => 'END'
1758: );

Line 1764: FEM_ENGINES_PKG.Tech_Message (

1760: EXCEPTION
1761:
1762: when l_get_dim_attr_error then
1763:
1764: FEM_ENGINES_PKG.Tech_Message (
1765: p_severity => G_LOG_LEVEL_6
1766: ,p_module => G_BLOCK||'.'||l_api_name
1767: ,p_msg_text => 'Get Dimension Attribute Value Exception'
1768: );

Line 1814: FEM_ENGINES_PKG.Tech_Message (

1810: l_sql_stmts_prep_error exception;
1811:
1812: BEGIN
1813:
1814: FEM_ENGINES_PKG.Tech_Message (
1815: p_severity => G_LOG_LEVEL_2
1816: ,p_module => G_BLOCK||'.'||l_api_name
1817: ,p_msg_text => 'BEGIN'
1818: );

Line 1830: FEM_ENGINES_PKG.User_Message (

1826: l_comp_dim_req_col := 'activity';
1827:
1828: else
1829:
1830: FEM_ENGINES_PKG.User_Message (
1831: p_app_name => G_FEM
1832: ,p_msg_name => G_RU_NO_ROLLUP_DIM_ERR
1833: ,p_token1 => 'DIMENSION_VARCHAR_LABEL'
1834: ,p_value1 => p_request_rec.dimension_rec.dimension_varchar_label

Line 1970: FEM_ENGINES_PKG.Tech_Message (

1966: x_sql_rec.comp_dim_data_cols_insert := l_comp_dim_data_cols_insert;
1967: x_sql_rec.comp_dim_comp_cols_values := l_comp_dim_comp_cols_values;
1968: x_sql_rec.comp_dim_data_cols_values := l_comp_dim_data_cols_values;
1969:
1970: FEM_ENGINES_PKG.Tech_Message (
1971: p_severity => G_LOG_LEVEL_2
1972: ,p_module => G_BLOCK||'.'||l_api_name
1973: ,p_msg_text => 'END'
1974: );

Line 1980: FEM_ENGINES_PKG.Tech_Message (

1976: EXCEPTION
1977:
1978: when l_sql_stmts_prep_error then
1979:
1980: FEM_ENGINES_PKG.Tech_Message (
1981: p_severity => G_LOG_LEVEL_6
1982: ,p_module => G_BLOCK||'.'||l_api_name
1983: ,p_msg_text => 'SQL Statements Preparation Exception'
1984: );

Line 2018: FEM_ENGINES_PKG.Tech_Message (

2014: l_register_request_error exception;
2015:
2016: BEGIN
2017:
2018: FEM_ENGINES_PKG.Tech_Message (
2019: p_severity => G_LOG_LEVEL_2
2020: ,p_module => G_BLOCK||'.'||l_api_name
2021: ,p_msg_text => 'BEGIN'
2022: );

Line 2065: FEM_ENGINES_PKG.Tech_Message (

2061: end if;
2062:
2063: commit;
2064:
2065: FEM_ENGINES_PKG.Tech_Message (
2066: p_severity => G_LOG_LEVEL_2
2067: ,p_module => G_BLOCK||'.'||l_api_name
2068: ,p_msg_text => 'END'
2069: );

Line 2077: FEM_ENGINES_PKG.Tech_Message (

2073: when l_register_request_error then
2074:
2075: rollback to register_request_pub;
2076:
2077: FEM_ENGINES_PKG.Tech_Message (
2078: p_severity => G_LOG_LEVEL_6
2079: ,p_module => G_BLOCK||'.'||l_api_name
2080: ,p_msg_text => 'Register Request Exception'
2081: );

Line 2175: FEM_ENGINES_PKG.Tech_Message (

2171: l_rollup_rule_error exception;
2172:
2173: BEGIN
2174:
2175: FEM_ENGINES_PKG.Tech_Message (
2176: p_severity => G_LOG_LEVEL_2
2177: ,p_module => G_BLOCK||'.'||l_api_name
2178: ,p_msg_text => 'BEGIN'
2179: );

Line 2187: FEM_ENGINES_PKG.tech_message (

2183:
2184: ------------------------------------------------------------------------------
2185: -- STEP 1: Rule Pre Processing
2186: ------------------------------------------------------------------------------
2187: FEM_ENGINES_PKG.tech_message (
2188: p_severity => G_LOG_LEVEL_1
2189: ,p_module => G_BLOCK||'.'||l_api_name
2190: ,p_msg_text => 'Step 1: Rule Pre Processing'
2191: );

Line 2205: FEM_ENGINES_PKG.tech_message (

2201:
2202: ------------------------------------------------------------------------------
2203: -- STEP 2: Build Dynamic SQL
2204: ------------------------------------------------------------------------------
2205: FEM_ENGINES_PKG.tech_message (
2206: p_severity => G_LOG_LEVEL_1
2207: ,p_module => G_BLOCK||'.'||l_api_name
2208: ,p_msg_text => 'Step 2: Build Dynamic SQL'
2209: );

Line 2226: FEM_ENGINES_PKG.tech_message (

2222:
2223: ------------------------------------------------------------------------------
2224: -- STEP 3: Register Rule under the same parent request
2225: ------------------------------------------------------------------------------
2226: FEM_ENGINES_PKG.tech_message (
2227: p_severity => G_LOG_LEVEL_1
2228: ,p_module => G_BLOCK||'.'||l_api_name
2229: ,p_msg_text => 'Step 3: Register Rule'
2230: );

Line 2240: FEM_ENGINES_PKG.tech_message (

2236:
2237: ------------------------------------------------------------------------------
2238: -- STEP 4: Create Temporary Objects
2239: ------------------------------------------------------------------------------
2240: FEM_ENGINES_PKG.tech_message (
2241: p_severity => G_LOG_LEVEL_1
2242: ,p_module => G_BLOCK||'.'||l_api_name
2243: ,p_msg_text => 'Step 4: Create Temporary Objects'
2244: );

Line 2256: FEM_ENGINES_PKG.Tech_Message (

2252:
2253: ----------------------------------------------------------------------------
2254: -- STEP 5.1: Find Condition Nodes
2255: ----------------------------------------------------------------------------
2256: FEM_ENGINES_PKG.Tech_Message (
2257: p_severity => G_LOG_LEVEL_1
2258: ,p_module => G_BLOCK||'.'||l_api_name
2259: ,p_msg_text => 'Step 5.1: Find Condition Nodes'
2260: );

Line 2272: FEM_ENGINES_PKG.Tech_Message (

2268:
2269: ----------------------------------------------------------------------------
2270: -- STEP 5.2: Find Root Nodes
2271: ----------------------------------------------------------------------------
2272: FEM_ENGINES_PKG.Tech_Message (
2273: p_severity => G_LOG_LEVEL_1
2274: ,p_module => G_BLOCK||'.'||l_api_name
2275: ,p_msg_text => 'Step 5.2: Find Root Nodes'
2276: );

Line 2288: FEM_ENGINES_PKG.Tech_Message (

2284:
2285: ------------------------------------------------------------------------------
2286: -- STEP 6: Rollup Root Nodes
2287: ------------------------------------------------------------------------------
2288: FEM_ENGINES_PKG.Tech_Message (
2289: p_severity => G_LOG_LEVEL_1
2290: ,p_module => G_BLOCK||'.'||l_api_name
2291: ,p_msg_text => 'Step 6: Rollup Root Nodes'
2292: );

Line 2338: FEM_ENGINES_PKG.Tech_Message (

2334: -- STEP 7: Rollup Condition Nodes
2335: ------------------------------------------------------------------------------
2336: if (l_rule_rec.cond_exists) then
2337:
2338: FEM_ENGINES_PKG.Tech_Message (
2339: p_severity => G_LOG_LEVEL_1
2340: ,p_module => G_BLOCK||'.'||l_api_name
2341: ,p_msg_text => 'Step 7: Rollup Condition Nodes'
2342: );

Line 2388: FEM_ENGINES_PKG.Tech_Message (

2384:
2385: ------------------------------------------------------------------------------
2386: -- STEP 8: Check for Uncosted Nodes
2387: ------------------------------------------------------------------------------
2388: FEM_ENGINES_PKG.Tech_Message (
2389: p_severity => G_LOG_LEVEL_1
2390: ,p_module => G_BLOCK||'.'||l_api_name
2391: ,p_msg_text => 'Step 8: Check for Uncosted Nodes'
2392: );

Line 2404: FEM_ENGINES_PKG.User_Message(

2400: and costed_flag = 'N';
2401:
2402: if (l_uncosted_node_count > 0) then
2403:
2404: FEM_ENGINES_PKG.User_Message(
2405: p_app_name => G_FEM
2406: ,p_msg_name => G_RU_UNCOSTED_NODES_ERR
2407: );
2408: raise l_rollup_rule_error;

Line 2415: FEM_ENGINES_PKG.Tech_Message (

2411:
2412: ------------------------------------------------------------------------------
2413: -- STEP 9: Rule Post Processing
2414: ------------------------------------------------------------------------------
2415: FEM_ENGINES_PKG.Tech_Message (
2416: p_severity => G_LOG_LEVEL_1
2417: ,p_module => G_BLOCK||'.'||l_api_name
2418: ,p_msg_text => 'Step 9: Rule Post Processing'
2419: );

Line 2428: FEM_ENGINES_PKG.Tech_Message (

2424: ,p_num_of_input_rows_stmt => l_num_of_input_rows_stmt
2425: ,p_exec_status_code => G_EXEC_STATUS_SUCCESS
2426: );
2427:
2428: FEM_ENGINES_PKG.Tech_Message (
2429: p_severity => G_LOG_LEVEL_2
2430: ,p_module => G_BLOCK||'.'||l_api_name
2431: ,p_msg_text => 'END'
2432: );

Line 2438: FEM_ENGINES_PKG.Tech_Message (

2434: EXCEPTION
2435:
2436: when l_rollup_rule_error then
2437:
2438: FEM_ENGINES_PKG.Tech_Message (
2439: p_severity => G_LOG_LEVEL_6
2440: ,p_module => G_BLOCK||'.'||l_api_name
2441: ,p_msg_text => 'Rollup Rule Exception'
2442: );

Line 2495: FEM_ENGINES_PKG.Tech_Message (

2491:
2492: g_prg_msg := SQLERRM;
2493: g_callstack := DBMS_UTILITY.Format_Call_Stack;
2494:
2495: FEM_ENGINES_PKG.Tech_Message (
2496: p_severity => G_LOG_LEVEL_6
2497: ,p_module => G_BLOCK||'.'||l_api_name||'.Unexpected_Exception'
2498: ,p_msg_text => g_prg_msg
2499: );

Line 2501: FEM_ENGINES_PKG.User_Message (

2497: ,p_module => G_BLOCK||'.'||l_api_name||'.Unexpected_Exception'
2498: ,p_msg_text => g_prg_msg
2499: );
2500:
2501: FEM_ENGINES_PKG.User_Message (
2502: p_app_name => G_FEM
2503: ,p_msg_name => G_UNEXPECTED_ERROR
2504: ,p_token1 => 'ERR_MSG'
2505: ,p_value1 => g_prg_msg

Line 2563: FEM_ENGINES_PKG.Tech_Message (

2559: l_rule_prep_error exception;
2560:
2561: BEGIN
2562:
2563: FEM_ENGINES_PKG.Tech_Message (
2564: p_severity => G_LOG_LEVEL_2
2565: ,p_module => G_BLOCK||'.'||l_api_name
2566: ,p_msg_text => 'BEGIN'
2567: );

Line 2587: FEM_ENGINES_PKG.User_Message (

2583: from fem_object_catalog_vl
2584: where object_id = x_rule_rec.rollup_obj_id;
2585: exception
2586: when others then
2587: FEM_ENGINES_PKG.User_Message (
2588: p_app_name => G_FEM
2589: ,p_msg_name => G_ENG_NO_OBJ_ERR
2590: ,p_token1 => 'OBJECT_TYPE_MEANING'
2591: ,p_value1 => Get_Object_Type_Name(p_request_rec.rollup_obj_type_code)

Line 2606: FEM_ENGINES_PKG.User_Message (

2602: if (p_request_rec.submit_obj_type_code = 'RULE_SET') then
2603:
2604: -- For rule sets processing, post to log file when starting to process a
2605: -- rule set rule.
2606: FEM_ENGINES_PKG.User_Message (
2607: p_app_name => G_FEM
2608: ,p_msg_name => G_ENG_RS_RULE_PROCESSING_TXT
2609: ,p_token1 => 'RULE_NAME'
2610: ,p_value1 => x_rule_rec.rollup_obj_name

Line 2615: FEM_ENGINES_PKG.User_Message (

2611: );
2612:
2613: if (p_request_rec.rollup_obj_type_code <> x_rule_rec.rollup_obj_type_code) then
2614:
2615: FEM_ENGINES_PKG.User_Message (
2616: p_app_name => G_FEM
2617: ,p_msg_name => G_ENG_BAD_RS_OBJ_TYPE_ERR
2618: ,p_token1 => 'RS_OBJECT_TYPE_CODE'
2619: ,p_value1 => p_request_rec.rollup_obj_type_code

Line 2631: FEM_ENGINES_PKG.User_Message (

2627: end if;
2628:
2629: if (p_request_rec.local_vs_combo_id <> x_rule_rec.local_vs_combo_id) then
2630:
2631: FEM_ENGINES_PKG.User_Message (
2632: p_app_name => G_FEM
2633: ,p_msg_name => G_ENG_BAD_LCL_VS_COMBO_ERR
2634: ,p_token1 => 'OBJECT_TYPE_MEANING'
2635: ,p_value1 => Get_Object_Type_Name(x_rule_rec.rollup_obj_type_code)

Line 2671: FEM_ENGINES_PKG.User_Message (

2667: ,x_rule_rec.statistic_basis_id
2668: using x_rule_rec.rollup_obj_def_id;
2669: exception
2670: when others then
2671: FEM_ENGINES_PKG.User_Message (
2672: p_app_name => G_FEM
2673: ,p_msg_name => G_ENG_NO_OBJ_DEF_DTL_ERR
2674: ,p_token1 => 'TABLE_NAME'
2675: ,p_value1 => p_request_rec.rollup_rule_def_table

Line 2721: FEM_ENGINES_PKG.User_Message (

2717: from fem_hierarchies h
2718: where h.hierarchy_obj_id = x_rule_rec.hier_obj_id;
2719: exception
2720: when others then
2721: FEM_ENGINES_PKG.User_Message (
2722: p_app_name => G_FEM
2723: ,p_msg_name => G_ENG_NO_OBJ_DTL_ERR
2724: ,p_token1 => 'TABLE_NAME'
2725: ,p_value1 => 'FEM_HIERARCHIES'

Line 2737: FEM_ENGINES_PKG.User_Message (

2733:
2734: -- Check that the dimension Id matches that of the Request
2735: if (p_request_rec.dimension_rec.dimension_id <> l_dimension_id) then
2736:
2737: FEM_ENGINES_PKG.User_Message (
2738: p_app_name => G_FEM
2739: ,p_msg_name => G_ENG_BAD_HIER_DIM_ERR
2740: ,p_token1 => 'OBJECT_TYPE_MEANING'
2741: ,p_value1 => Get_Object_Type_Name(x_rule_rec.rollup_obj_type_code)

Line 2840: FEM_ENGINES_PKG.User_Message (

2836: ,x_rate => x_rule_rec.entered_exch_rate
2837: );
2838: exception
2839: when GL_CURRENCY_API.NO_RATE then
2840: FEM_ENGINES_PKG.User_Message (
2841: p_app_name => G_FEM
2842: ,p_msg_name => G_ENG_NO_EXCH_RATE_ERR
2843: ,p_token1 => 'FROM_CURRENCY_CODE'
2844: ,p_value1 => p_request_rec.functional_currency_code

Line 2855: FEM_ENGINES_PKG.User_Message (

2851: );
2852: raise l_rule_prep_error;
2853:
2854: when GL_CURRENCY_API.INVALID_CURRENCY then
2855: FEM_ENGINES_PKG.User_Message (
2856: p_app_name => G_FEM
2857: ,p_msg_name => G_ENG_BAD_CURRENCY_ERR
2858: ,p_token1 => 'FROM_CURRENCY_CODE'
2859: ,p_value1 => p_request_rec.functional_currency_code

Line 2880: FEM_ENGINES_PKG.Tech_Message (

2876:
2877: -- Log all Rule Record Parameters if we have low level debugging
2878: if ( FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) ) then
2879:
2880: FEM_ENGINES_PKG.Tech_Message (
2881: p_severity => G_LOG_LEVEL_1
2882: ,p_module => G_BLOCK||'.'||l_api_name||'.x_rule_rec'
2883: ,p_msg_text =>
2884: ' cond_obj_def_id='||x_rule_rec.cond_obj_def_id||

Line 2904: FEM_ENGINES_PKG.Tech_Message (

2900: );
2901:
2902: end if;
2903:
2904: FEM_ENGINES_PKG.Tech_Message (
2905: p_severity => G_LOG_LEVEL_2
2906: ,p_module => G_BLOCK||'.'||l_api_name
2907: ,p_msg_text => 'END'
2908: );

Line 2914: FEM_ENGINES_PKG.Tech_Message (

2910: EXCEPTION
2911:
2912: when l_rule_prep_error then
2913:
2914: FEM_ENGINES_PKG.Tech_Message (
2915: p_severity => G_LOG_LEVEL_6
2916: ,p_module => G_BLOCK||'.'||l_api_name
2917: ,p_msg_text => 'Rule Preparation Exception'
2918: );

Line 2961: FEM_ENGINES_PKG.Tech_Message (

2957: l_sql_stmts_build_error exception;
2958:
2959: BEGIN
2960:
2961: FEM_ENGINES_PKG.Tech_Message (
2962: p_severity => G_LOG_LEVEL_2
2963: ,p_module => G_BLOCK||'.'||l_api_name
2964: ,p_msg_text => 'BEGIN'
2965: );

Line 3270: FEM_ENGINES_PKG.Tech_Message (

3266: ' )';
3267:
3268: end if;
3269:
3270: FEM_ENGINES_PKG.Tech_Message (
3271: p_severity => G_LOG_LEVEL_1
3272: ,p_module => G_BLOCK||'.'||l_api_name||'.x_find_children_stmt'
3273: ,p_msg_text => x_find_children_stmt
3274: );

Line 3276: FEM_ENGINES_PKG.Tech_Message (

3272: ,p_module => G_BLOCK||'.'||l_api_name||'.x_find_children_stmt'
3273: ,p_msg_text => x_find_children_stmt
3274: );
3275:
3276: FEM_ENGINES_PKG.Tech_Message (
3277: p_severity => G_LOG_LEVEL_1
3278: ,p_module => G_BLOCK||'.'||l_api_name||'.x_rollup_parent_stmt'
3279: ,p_msg_text => x_rollup_parent_stmt
3280: );

Line 3282: FEM_ENGINES_PKG.Tech_Message (

3278: ,p_module => G_BLOCK||'.'||l_api_name||'.x_rollup_parent_stmt'
3279: ,p_msg_text => x_rollup_parent_stmt
3280: );
3281:
3282: FEM_ENGINES_PKG.Tech_Message (
3283: p_severity => G_LOG_LEVEL_1
3284: ,p_module => G_BLOCK||'.'||l_api_name||'.x_find_child_chains_stmt'
3285: ,p_msg_text => x_find_child_chains_stmt
3286: );

Line 3288: FEM_ENGINES_PKG.Tech_Message (

3284: ,p_module => G_BLOCK||'.'||l_api_name||'.x_find_child_chains_stmt'
3285: ,p_msg_text => x_find_child_chains_stmt
3286: );
3287:
3288: FEM_ENGINES_PKG.Tech_Message (
3289: p_severity => G_LOG_LEVEL_1
3290: ,p_module => G_BLOCK||'.'||l_api_name||'.x_num_of_input_rows_stmt'
3291: ,p_msg_text => x_num_of_input_rows_stmt
3292: );

Line 3294: FEM_ENGINES_PKG.Tech_Message (

3290: ,p_module => G_BLOCK||'.'||l_api_name||'.x_num_of_input_rows_stmt'
3291: ,p_msg_text => x_num_of_input_rows_stmt
3292: );
3293:
3294: FEM_ENGINES_PKG.Tech_Message (
3295: p_severity => G_LOG_LEVEL_2
3296: ,p_module => G_BLOCK||'.'||l_api_name
3297: ,p_msg_text => 'END'
3298: );

Line 3304: FEM_ENGINES_PKG.Tech_Message (

3300: EXCEPTION
3301:
3302: when l_sql_stmts_build_error then
3303:
3304: FEM_ENGINES_PKG.Tech_Message (
3305: p_severity => G_LOG_LEVEL_6
3306: ,p_module => G_BLOCK||'.'||l_api_name
3307: ,p_msg_text => 'SQL Statements Build Exception'
3308: );

Line 3348: FEM_ENGINES_PKG.Tech_Message (

3344: l_register_rule_error exception;
3345:
3346: BEGIN
3347:
3348: FEM_ENGINES_PKG.Tech_Message (
3349: p_severity => G_LOG_LEVEL_2
3350: ,p_module => G_BLOCK||'.'||l_api_name
3351: ,p_msg_text => 'BEGIN'
3352: );

Line 3485: FEM_ENGINES_PKG.Tech_Message (

3481: end if;
3482:
3483: commit;
3484:
3485: FEM_ENGINES_PKG.Tech_Message (
3486: p_severity => G_LOG_LEVEL_2
3487: ,p_module => G_BLOCK||'.'||l_api_name
3488: ,p_msg_text => 'END'
3489: );

Line 3497: FEM_ENGINES_PKG.Tech_Message (

3493: when l_register_rule_error then
3494:
3495: rollback to register_rule_pub;
3496:
3497: FEM_ENGINES_PKG.Tech_Message (
3498: p_severity => G_LOG_LEVEL_6
3499: ,p_module => G_BLOCK||'.'||l_api_name
3500: ,p_msg_text => 'Register Rule Exception'
3501: );

Line 3547: FEM_ENGINES_PKG.Tech_Message (

3543: l_register_obj_def_error exception;
3544:
3545: BEGIN
3546:
3547: FEM_ENGINES_PKG.Tech_Message (
3548: p_severity => G_LOG_LEVEL_2
3549: ,p_module => G_BLOCK||'.'||l_api_name
3550: ,p_msg_text => 'BEGIN'
3551: );

Line 3578: FEM_ENGINES_PKG.Tech_Message (

3574: );
3575: raise l_register_obj_def_error;
3576: end if;
3577:
3578: FEM_ENGINES_PKG.Tech_Message (
3579: p_severity => G_LOG_LEVEL_2
3580: ,p_module => G_BLOCK||'.'||l_api_name
3581: ,p_msg_text => 'END'
3582: );

Line 3588: FEM_ENGINES_PKG.Tech_Message (

3584: EXCEPTION
3585:
3586: when l_register_obj_def_error then
3587:
3588: FEM_ENGINES_PKG.Tech_Message (
3589: p_severity => G_LOG_LEVEL_6
3590: ,p_module => G_BLOCK||'.'||l_api_name
3591: ,p_msg_text => 'Register Object Definition Exception'
3592: );

Line 3629: FEM_ENGINES_PKG.Tech_Message (

3625: l_register_table_error exception;
3626:
3627: BEGIN
3628:
3629: FEM_ENGINES_PKG.Tech_Message (
3630: p_severity => G_LOG_LEVEL_2
3631: ,p_module => G_BLOCK||'.'||l_api_name
3632: ,p_msg_text => 'BEGIN'
3633: );

Line 3660: FEM_ENGINES_PKG.Tech_Message (

3656: );
3657: raise l_register_table_error;
3658: end if;
3659:
3660: FEM_ENGINES_PKG.Tech_Message (
3661: p_severity => G_LOG_LEVEL_2
3662: ,p_module => G_BLOCK||'.'||l_api_name
3663: ,p_msg_text => 'END'
3664: );

Line 3670: FEM_ENGINES_PKG.Tech_Message (

3666: EXCEPTION
3667:
3668: when l_register_table_error then
3669:
3670: FEM_ENGINES_PKG.Tech_Message (
3671: p_severity => G_LOG_LEVEL_6
3672: ,p_module => G_BLOCK||'.'||l_api_name
3673: ,p_msg_text => 'Register Table Exception'
3674: );

Line 3709: FEM_ENGINES_PKG.Tech_Message (

3705: l_create_temp_objects_error exception;
3706:
3707: BEGIN
3708:
3709: FEM_ENGINES_PKG.Tech_Message (
3710: p_severity => G_LOG_LEVEL_2
3711: ,p_module => G_BLOCK||'.'||l_api_name
3712: ,p_msg_text => 'BEGIN'
3713: );

Line 3724: FEM_ENGINES_PKG.User_Message (

3720: -- allow hardcoded schemas.
3721: execute immediate 'create sequence '||p_rule_rec.sequence_name;
3722: exception
3723: when others then
3724: FEM_ENGINES_PKG.User_Message (
3725: p_app_name => G_FEM
3726: ,p_msg_name => G_ENG_CREATE_SEQUENCE_ERR
3727: ,p_token1 => 'SEQUENCE_NAME'
3728: ,p_value1 => p_rule_rec.sequence_name

Line 3759: FEM_ENGINES_PKG.Tech_Message (

3755: end if;
3756:
3757: commit;
3758:
3759: FEM_ENGINES_PKG.Tech_Message (
3760: p_severity => G_LOG_LEVEL_2
3761: ,p_module => G_BLOCK||'.'||l_api_name
3762: ,p_msg_text => 'END'
3763: );

Line 3769: FEM_ENGINES_PKG.Tech_Message (

3765: EXCEPTION
3766:
3767: when l_create_temp_objects_error then
3768:
3769: FEM_ENGINES_PKG.Tech_Message (
3770: p_severity => G_LOG_LEVEL_6
3771: ,p_module => G_BLOCK||'.'||l_api_name
3772: ,p_msg_text => 'Create Temporary Objects Exception'
3773: );

Line 3808: FEM_ENGINES_PKG.Tech_Message (

3804: l_drop_temp_objects_error exception;
3805:
3806: BEGIN
3807:
3808: FEM_ENGINES_PKG.Tech_Message (
3809: p_severity => G_LOG_LEVEL_2
3810: ,p_module => G_BLOCK||'.'||l_api_name
3811: ,p_msg_text => 'BEGIN'
3812: );

Line 3847: FEM_ENGINES_PKG.User_Message (

3843:
3844: exception
3845: when others then
3846: l_completion_status := FND_CONCURRENT.Set_Completion_Status('WARNING',null);
3847: FEM_ENGINES_PKG.User_Message (
3848: p_app_name => G_FEM
3849: ,p_msg_name => G_ENG_DROP_SEQUENCE_WRN
3850: ,p_token1 => 'SEQUENCE_NAME'
3851: ,p_value1 => p_rule_rec.sequence_name

Line 3859: FEM_ENGINES_PKG.Tech_Message (

3855: commit;
3856:
3857: end if;
3858:
3859: FEM_ENGINES_PKG.Tech_Message (
3860: p_severity => G_LOG_LEVEL_2
3861: ,p_module => G_BLOCK||'.'||l_api_name
3862: ,p_msg_text => 'END'
3863: );

Line 3869: FEM_ENGINES_PKG.Tech_Message (

3865: EXCEPTION
3866:
3867: when l_drop_temp_objects_error then
3868:
3869: FEM_ENGINES_PKG.Tech_Message (
3870: p_severity => G_LOG_LEVEL_6
3871: ,p_module => G_BLOCK||'.'||l_api_name
3872: ,p_msg_text => 'Drop Temp Objects Exception'
3873: );

Line 3919: FEM_ENGINES_PKG.Tech_Message (

3915: l_find_cond_nodes_error exception;
3916:
3917: BEGIN
3918:
3919: FEM_ENGINES_PKG.Tech_Message (
3920: p_severity => G_LOG_LEVEL_2
3921: ,p_module => G_BLOCK||'.'||l_api_name
3922: ,p_msg_text => 'BEGIN'
3923: );

Line 3930: FEM_ENGINES_PKG.Tech_Message (

3926:
3927: ------------------------------------------------------------------------------
3928: -- STEP 1: Generate Condition Where Clause Predicate
3929: ------------------------------------------------------------------------------
3930: FEM_ENGINES_PKG.Tech_Message (
3931: p_severity => G_LOG_LEVEL_1
3932: ,p_module => G_BLOCK||'.'||l_api_name
3933: ,p_msg_text => 'Step 1: Generate Condition Where Clause Predicate'
3934: );

Line 3964: FEM_ENGINES_PKG.User_Message (

3960: end if;
3961:
3962: if (l_cond_where_clause is null) then
3963:
3964: FEM_ENGINES_PKG.User_Message (
3965: p_app_name => G_FEM
3966: ,p_msg_name => G_ENG_COND_WHERE_CLAUSE_ERR
3967: ,p_token1 => 'CONDITION_OBJECT_ID'
3968: ,p_value1 => p_rule_rec.cond_obj_id

Line 3981: FEM_ENGINES_PKG.Tech_Message (

3977:
3978: ------------------------------------------------------------------------------
3979: -- STEP 2: Find "Parent" Condition Nodes
3980: ------------------------------------------------------------------------------
3981: FEM_ENGINES_PKG.Tech_Message (
3982: p_severity => G_LOG_LEVEL_1
3983: ,p_module => G_BLOCK||'.'||l_api_name
3984: ,p_msg_text => 'Step 2: Find "Parent" Condition Nodes'
3985: );

Line 4065: FEM_ENGINES_PKG.User_Message (

4061: ,p_rule_rec.hier_obj_def_id;
4062:
4063: else
4064:
4065: FEM_ENGINES_PKG.User_Message (
4066: p_app_name => G_FEM
4067: ,p_msg_name => G_RU_NO_ROLLUP_DIM_ERR
4068: ,p_token1 => 'DIMENSION_VARCHAR_LABEL'
4069: ,p_value1 => l_dimension_rec.dimension_varchar_label

Line 4080: FEM_ENGINES_PKG.Tech_Message (

4076:
4077: ------------------------------------------------------------------------------
4078: -- STEP 3: Count "Parent" Conditions Nodes
4079: ------------------------------------------------------------------------------
4080: FEM_ENGINES_PKG.Tech_Message (
4081: p_severity => G_LOG_LEVEL_1
4082: ,p_module => G_BLOCK||'.'||l_api_name
4083: ,p_msg_text => 'Step 3: Count "Parent" Condition Nodes'
4084: );

Line 4098: FEM_ENGINES_PKG.Tech_Message (

4094:
4095: ----------------------------------------------------------------------------
4096: -- STEP 3.a: Count "Leaf" Condition Nodes
4097: ----------------------------------------------------------------------------
4098: FEM_ENGINES_PKG.Tech_Message (
4099: p_severity => G_LOG_LEVEL_1
4100: ,p_module => G_BLOCK||'.'||l_api_name
4101: ,p_msg_text => 'Step 3.a: Count "Leaf" Condition Nodes'
4102: );

Line 4152: FEM_ENGINES_PKG.User_Message (

4148: ,p_rule_rec.hier_obj_def_id;
4149:
4150: else
4151:
4152: FEM_ENGINES_PKG.User_Message (
4153: p_app_name => G_FEM
4154: ,p_msg_name => G_RU_NO_ROLLUP_DIM_ERR
4155: ,p_token1 => 'DIMENSION_VARCHAR_LABEL'
4156: ,p_value1 => l_dimension_rec.dimension_varchar_label

Line 4165: FEM_ENGINES_PKG.User_Message (

4161:
4162: if (l_leaf_count = 0) then
4163:
4164: -- No Condition Nodes were found in the specified hierarchy
4165: FEM_ENGINES_PKG.User_Message (
4166: p_app_name => G_FEM
4167: ,p_msg_name => G_RU_NO_COND_NODES_FOUND_ERR
4168: );
4169: raise l_find_cond_nodes_error;

Line 4175: FEM_ENGINES_PKG.User_Message (

4171: else
4172:
4173: -- Only "Leaf" Condition Nodes were found in the specified hierarchy.
4174: -- Rollup is not necessary on leaf nodes.
4175: FEM_ENGINES_PKG.User_Message (
4176: p_app_name => G_FEM
4177: ,p_msg_name => G_RU_COND_NODES_LEAFS_ERR
4178: );
4179: raise l_find_cond_nodes_error;

Line 4188: FEM_ENGINES_PKG.Tech_Message (

4184:
4185: ------------------------------------------------------------------------------
4186: -- STEP 4: Find "Root" Condition Nodes
4187: ------------------------------------------------------------------------------
4188: FEM_ENGINES_PKG.Tech_Message (
4189: p_severity => G_LOG_LEVEL_1
4190: ,p_module => G_BLOCK||'.'||l_api_name
4191: ,p_msg_text => 'Step 4: Find "Root" Condition Nodes'
4192: );

Line 4251: FEM_ENGINES_PKG.Tech_Message (

4247: end if;
4248:
4249: commit;
4250:
4251: FEM_ENGINES_PKG.Tech_Message (
4252: p_severity => G_LOG_LEVEL_2
4253: ,p_module => G_BLOCK||'.'||l_api_name
4254: ,p_msg_text => 'END'
4255: );

Line 4261: FEM_ENGINES_PKG.Tech_Message (

4257: EXCEPTION
4258:
4259: when l_find_cond_nodes_error then
4260:
4261: FEM_ENGINES_PKG.Tech_Message (
4262: p_severity => G_LOG_LEVEL_6
4263: ,p_module => G_BLOCK||'.'||l_api_name
4264: ,p_msg_text => 'Find Condition Nodes Exception'
4265: );

Line 4302: FEM_ENGINES_PKG.Tech_Message (

4298: l_find_root_nodes_error exception;
4299:
4300: BEGIN
4301:
4302: FEM_ENGINES_PKG.Tech_Message (
4303: p_severity => G_LOG_LEVEL_2
4304: ,p_module => G_BLOCK||'.'||l_api_name
4305: ,p_msg_text => 'BEGIN'
4306: );

Line 4313: FEM_ENGINES_PKG.Tech_Message (

4309:
4310: ------------------------------------------------------------------------------
4311: -- STEP 1: Find Root Nodes
4312: ------------------------------------------------------------------------------
4313: FEM_ENGINES_PKG.Tech_Message (
4314: p_severity => G_LOG_LEVEL_1
4315: ,p_module => G_BLOCK||'.'||l_api_name
4316: ,p_msg_text => 'Step 1: Find Root Nodes'
4317: );

Line 4409: FEM_ENGINES_PKG.User_Message (

4405: ,p_rule_rec.hier_obj_def_id;
4406:
4407: else
4408:
4409: FEM_ENGINES_PKG.User_Message (
4410: p_app_name => G_FEM
4411: ,p_msg_name => G_RU_NO_ROLLUP_DIM_ERR
4412: ,p_token1 => 'DIMENSION_VARCHAR_LABEL'
4413: ,p_value1 => l_dimension_rec.dimension_varchar_label

Line 4424: FEM_ENGINES_PKG.Tech_Message (

4420:
4421: ------------------------------------------------------------------------------
4422: -- STEP 2: Count Root Nodes
4423: ------------------------------------------------------------------------------
4424: FEM_ENGINES_PKG.Tech_Message (
4425: p_severity => G_LOG_LEVEL_1
4426: ,p_module => G_BLOCK||'.'||l_api_name
4427: ,p_msg_text => 'Step 2: Count Root Nodes'
4428: );

Line 4439: FEM_ENGINES_PKG.User_Message (

4435: and root_flag = 'Y';
4436:
4437: if (l_node_count = 0) then
4438:
4439: FEM_ENGINES_PKG.User_Message (
4440: p_app_name => G_FEM
4441: ,p_msg_name => G_RU_NO_ROOT_NODES_FOUND_ERR
4442: );
4443: raise l_find_root_nodes_error;

Line 4447: FEM_ENGINES_PKG.Tech_Message (

4443: raise l_find_root_nodes_error;
4444:
4445: end if;
4446:
4447: FEM_ENGINES_PKG.Tech_Message (
4448: p_severity => G_LOG_LEVEL_2
4449: ,p_module => G_BLOCK||'.'||l_api_name
4450: ,p_msg_text => 'END'
4451: );

Line 4457: FEM_ENGINES_PKG.Tech_Message (

4453: EXCEPTION
4454:
4455: when l_find_root_nodes_error then
4456:
4457: FEM_ENGINES_PKG.Tech_Message (
4458: p_severity => G_LOG_LEVEL_6
4459: ,p_module => G_BLOCK||'.'||l_api_name
4460: ,p_msg_text => 'Find Root Nodes Exception'
4461: );

Line 4539: FEM_ENGINES_PKG.Tech_Message (

4535: l_rollup_top_node_error exception;
4536:
4537: BEGIN
4538:
4539: FEM_ENGINES_PKG.Tech_Message (
4540: p_severity => G_LOG_LEVEL_2
4541: ,p_module => G_BLOCK||'.'||l_api_name
4542: ,p_msg_text => 'BEGIN'
4543: );

Line 4550: FEM_ENGINES_PKG.Tech_Message (

4546:
4547: ------------------------------------------------------------------------------
4548: -- STEP 1: Check to see if the top has been costed
4549: ------------------------------------------------------------------------------
4550: FEM_ENGINES_PKG.Tech_Message (
4551: p_severity => G_LOG_LEVEL_1
4552: ,p_module => G_BLOCK||'.'||l_api_name
4553: ,p_msg_text => 'Step 1: Check if Top Node has been costed'
4554: );

Line 4573: FEM_ENGINES_PKG.Tech_Message (

4569: ----------------------------------------------------------------------------
4570: -- STEP 1.a: Flatten the Cost Object hierarchy into the
4571: -- FEM_RU_COST_OBJ_HIER_T table.
4572: ----------------------------------------------------------------------------
4573: FEM_ENGINES_PKG.Tech_Message (
4574: p_severity => G_LOG_LEVEL_1
4575: ,p_module => G_BLOCK||'.'||l_api_name
4576: ,p_msg_text => 'Step 1.a: Flatten Cost Object Hierarchy'
4577: );

Line 4640: FEM_ENGINES_PKG.User_Message (

4636: where child.cost_object_id = ru.child_id;
4637:
4638: exception
4639: when g_connect_by_loop_error then
4640: FEM_ENGINES_PKG.User_Message (
4641: p_app_name => G_FEM
4642: ,p_msg_name => G_RU_HIER_CIRC_REF_ERR
4643: );
4644: raise l_rollup_top_node_error;

Line 4656: FEM_ENGINES_PKG.Tech_Message (

4652: ----------------------------------------------------------------------------
4653: -- STEP 1.b: Flatten the Activity hierarchy into the FEM_RU_ACTIVITIES_HIER_T
4654: -- table if condition exists.
4655: ----------------------------------------------------------------------------
4656: FEM_ENGINES_PKG.Tech_Message (
4657: p_severity => G_LOG_LEVEL_1
4658: ,p_module => G_BLOCK||'.'||l_api_name
4659: ,p_msg_text => 'Step 1.b: Flatten Activity Hierarchy'
4660: );

Line 4710: FEM_ENGINES_PKG.User_Message (

4706: and prior costed_flag = 'N';
4707:
4708: exception
4709: when g_connect_by_loop_error then
4710: FEM_ENGINES_PKG.User_Message (
4711: p_app_name => G_FEM
4712: ,p_msg_name => G_RU_HIER_CIRC_REF_ERR
4713: );
4714: raise l_rollup_top_node_error;

Line 4724: FEM_ENGINES_PKG.Tech_Message (

4720:
4721: ------------------------------------------------------------------------------
4722: -- STEP 2: Find Child Nodes not in FEM_RU_NODES_T table
4723: ------------------------------------------------------------------------------
4724: FEM_ENGINES_PKG.Tech_Message (
4725: p_severity => G_LOG_LEVEL_1
4726: ,p_module => G_BLOCK||'.'||l_api_name
4727: ,p_msg_text => 'Step 2: Find Child Nodes'
4728: );

Line 4838: FEM_ENGINES_PKG.User_Message (

4834: end if;
4835:
4836: else
4837:
4838: FEM_ENGINES_PKG.User_Message (
4839: p_app_name => G_FEM
4840: ,p_msg_name => G_RU_NO_ROLLUP_DIM_ERR
4841: ,p_token1 => 'DIMENSION_VARCHAR_LABEL'
4842: ,p_value1 => l_dimension_rec.dimension_varchar_label

Line 4853: FEM_ENGINES_PKG.Tech_Message (

4849:
4850: ------------------------------------------------------------------------------
4851: -- STEP 3: Pre-Populate COST_OBJECT_ID or ACTIVITY_ID on FEM_BALANCES
4852: ------------------------------------------------------------------------------
4853: FEM_ENGINES_PKG.Tech_Message (
4854: p_severity => G_LOG_LEVEL_1
4855: ,p_module => G_BLOCK||'.'||l_api_name
4856: ,p_msg_text => 'Step 3: Pre-Populate COST_OBJECT_ID or ACTIVITY_ID on FEM_BALANCES'
4857: );

Line 4969: FEM_ENGINES_PKG.Tech_Message (

4965:
4966: ------------------------------------------------------------------------------
4967: -- STEP 4: Get the Minimum and Maximum Parent Node Depths for the Top Node
4968: ------------------------------------------------------------------------------
4969: FEM_ENGINES_PKG.Tech_Message (
4970: p_severity => G_LOG_LEVEL_1
4971: ,p_module => G_BLOCK||'.'||l_api_name
4972: ,p_msg_text => 'Step 4: Get the Minimum and Maximum Parent Node Depths for the Top Node'
4973: );

Line 5036: FEM_ENGINES_PKG.User_Message (

5032: end if;
5033:
5034: else
5035:
5036: FEM_ENGINES_PKG.User_Message (
5037: p_app_name => G_FEM
5038: ,p_msg_name => G_RU_NO_ROLLUP_DIM_ERR
5039: ,p_token1 => 'DIMENSION_VARCHAR_LABEL'
5040: ,p_value1 => l_dimension_rec.dimension_varchar_label

Line 5049: FEM_ENGINES_PKG.Tech_Message (

5045:
5046: ------------------------------------------------------------------------------
5047: -- STEP 5: Build Parent Node Query at specified Parent Depth Number
5048: ------------------------------------------------------------------------------
5049: FEM_ENGINES_PKG.Tech_Message (
5050: p_severity => G_LOG_LEVEL_1
5051: ,p_module => G_BLOCK||'.'||l_api_name
5052: ,p_msg_text => 'Step 5: Build Parent Node Query at specified Parent Depth Number'
5053: );

Line 5111: FEM_ENGINES_PKG.User_Message (

5107: end if;
5108:
5109: else
5110:
5111: FEM_ENGINES_PKG.User_Message (
5112: p_app_name => G_FEM
5113: ,p_msg_name => G_RU_NO_ROLLUP_DIM_ERR
5114: ,p_token1 => 'DIMENSION_VARCHAR_LABEL'
5115: ,p_value1 => l_dimension_rec.dimension_varchar_label

Line 5124: FEM_ENGINES_PKG.Tech_Message (

5120:
5121: ------------------------------------------------------------------------------
5122: -- STEP 6: Loop through all Parent Depth Levels
5123: ------------------------------------------------------------------------------
5124: FEM_ENGINES_PKG.Tech_Message (
5125: p_severity => G_LOG_LEVEL_1
5126: ,p_module => G_BLOCK||'.'||l_api_name
5127: ,p_msg_text => 'Step 6: Loop through all Parent Depth Levels'
5128: );

Line 5216: FEM_ENGINES_PKG.Tech_Message (

5212:
5213: ----------------------------------------------------------------------------
5214: -- STEP 7.a: Purge all records in FEM_RU_COST_OBJ_HIER_T
5215: ----------------------------------------------------------------------------
5216: FEM_ENGINES_PKG.Tech_Message (
5217: p_severity => G_LOG_LEVEL_1
5218: ,p_module => G_BLOCK||'.'||l_api_name
5219: ,p_msg_text => 'Step 7.a: Purge all records in FEM_RU_COST_OBJ_HIER_T'
5220: );

Line 5234: FEM_ENGINES_PKG.Tech_Message (

5230:
5231: ----------------------------------------------------------------------------
5232: -- STEP 7.b: Purge all records in FEM_RU_ACTIVITIES_HIER_T
5233: ----------------------------------------------------------------------------
5234: FEM_ENGINES_PKG.Tech_Message (
5235: p_severity => G_LOG_LEVEL_1
5236: ,p_module => G_BLOCK||'.'||l_api_name
5237: ,p_msg_text => 'Step 7.b: Purge all records in FEM_RU_ACTIVITIES_HIER_T'
5238: );

Line 5248: FEM_ENGINES_PKG.Tech_Message (

5244: commit;
5245:
5246: end if;
5247:
5248: FEM_ENGINES_PKG.Tech_Message (
5249: p_severity => G_LOG_LEVEL_2
5250: ,p_module => G_BLOCK||'.'||l_api_name
5251: ,p_msg_text => 'END'
5252: );

Line 5262: FEM_ENGINES_PKG.Tech_Message (

5258: if (l_find_parent_nodes_csr%ISOPEN) then
5259: close l_find_parent_nodes_csr;
5260: end if;
5261:
5262: FEM_ENGINES_PKG.Tech_Message (
5263: p_severity => G_LOG_LEVEL_6
5264: ,p_module => G_BLOCK||'.'||l_api_name
5265: ,p_msg_text => 'Rollup Top Node Exception'
5266: );

Line 5287: FEM_ENGINES_PKG.Tech_Message (

5283: if (l_find_parent_nodes_csr%ISOPEN) then
5284: close l_find_parent_nodes_csr;
5285: end if;
5286:
5287: FEM_ENGINES_PKG.Tech_Message (
5288: p_severity => G_LOG_LEVEL_6
5289: ,p_module => G_BLOCK||'.'||l_api_name||'.Unexpected_Exception'
5290: ,p_msg_text => g_prg_msg
5291: );

Line 5293: FEM_ENGINES_PKG.Tech_Message (

5289: ,p_module => G_BLOCK||'.'||l_api_name||'.Unexpected_Exception'
5290: ,p_msg_text => g_prg_msg
5291: );
5292:
5293: FEM_ENGINES_PKG.Tech_Message (
5294: p_severity => G_LOG_LEVEL_6
5295: ,p_module => G_BLOCK||'.'||l_api_name||'.Unexpected_Exception'
5296: ,p_msg_text => g_callstack
5297: );

Line 5299: FEM_ENGINES_PKG.User_Message (

5295: ,p_module => G_BLOCK||'.'||l_api_name||'.Unexpected_Exception'
5296: ,p_msg_text => g_callstack
5297: );
5298:
5299: FEM_ENGINES_PKG.User_Message (
5300: p_app_name => G_FEM
5301: ,p_msg_name => G_UNEXPECTED_ERROR
5302: ,p_token1 => 'ERR_MSG'
5303: ,p_value1 => g_prg_msg

Line 5385: FEM_ENGINES_PKG.Tech_Message (

5381: l_rollup_parent_node_error exception;
5382:
5383: BEGIN
5384:
5385: FEM_ENGINES_PKG.Tech_Message (
5386: p_severity => G_LOG_LEVEL_2
5387: ,p_module => G_BLOCK||'.'||l_api_name
5388: ,p_msg_text => 'BEGIN'
5389: );

Line 5397: FEM_ENGINES_PKG.Tech_Message (

5393: ----------------------------------------------------------------------------
5394: -- STEP 1: Check to see if the parent has been costed in a Cost Object
5395: -- hierarchy
5396: ----------------------------------------------------------------------------
5397: FEM_ENGINES_PKG.Tech_Message (
5398: p_severity => G_LOG_LEVEL_1
5399: ,p_module => G_BLOCK||'.'||l_api_name
5400: ,p_msg_text => 'Step 1: Check if Parent Cost Object has been costed'
5401: );

Line 5420: FEM_ENGINES_PKG.Tech_Message (

5416: ------------------------------------------------------------------------------
5417: -- STEP 2: Find All Parent-Child Relationships for a hierarchy at the
5418: -- specified parent node id and parent depth num
5419: ------------------------------------------------------------------------------
5420: FEM_ENGINES_PKG.Tech_Message (
5421: p_severity => G_LOG_LEVEL_1
5422: ,p_module => G_BLOCK||'.'||l_api_name
5423: ,p_msg_text => 'Step 2: Find All Parent-Child Relationships'
5424: );

Line 5462: FEM_ENGINES_PKG.User_Message (

5458: end if;
5459:
5460: else
5461:
5462: FEM_ENGINES_PKG.User_Message (
5463: p_app_name => G_FEM
5464: ,p_msg_name => G_RU_NO_ROLLUP_DIM_ERR
5465: ,p_token1 => 'DIMENSION_VARCHAR_LABEL'
5466: ,p_value1 => p_dimension_varchar_label

Line 5495: FEM_ENGINES_PKG.Tech_Message (

5491:
5492: ----------------------------------------------------------------------
5493: -- STEP 3: Child Cross Ledger Processing
5494: ----------------------------------------------------------------------
5495: FEM_ENGINES_PKG.Tech_Message (
5496: p_severity => G_LOG_LEVEL_1
5497: ,p_module => G_BLOCK||'.'||l_api_name
5498: ,p_msg_text => 'Step 3: Child Cross Ledger Processing'
5499: );

Line 5539: FEM_ENGINES_PKG.User_Message (

5535: ,x_rate => g_xledger_tbl(l_xledger_id).exch_rate
5536: );
5537: exception
5538: when GL_CURRENCY_API.NO_RATE then
5539: FEM_ENGINES_PKG.User_Message (
5540: p_app_name => G_FEM
5541: ,p_msg_name => G_ENG_NO_EXCH_RATE_ERR
5542: ,p_token1 => 'FROM_CURRENCY_CODE'
5543: ,p_value1 => g_xledger_tbl(l_xledger_id).currency_code

Line 5553: FEM_ENGINES_PKG.User_Message (

5549: ,p_value4 => g_currency_conv_type
5550: );
5551: raise l_rollup_parent_node_error;
5552: when GL_CURRENCY_API.INVALID_CURRENCY then
5553: FEM_ENGINES_PKG.User_Message (
5554: p_app_name => G_FEM
5555: ,p_msg_name => G_ENG_BAD_CURRENCY_ERR
5556: ,p_token1 => 'FROM_CURRENCY_CODE'
5557: ,p_value1 => g_xledger_tbl(l_xledger_id).currency_code

Line 5593: FEM_ENGINES_PKG.Tech_Message (

5589:
5590: ------------------------------------------------------------------------
5591: -- STEP 4: Register Child Chains
5592: ------------------------------------------------------------------------
5593: FEM_ENGINES_PKG.Tech_Message (
5594: p_severity => G_LOG_LEVEL_1
5595: ,p_module => G_BLOCK||'.'||l_api_name
5596: ,p_msg_text => 'Step 4: Register Child Chains'
5597: );

Line 5618: FEM_ENGINES_PKG.Tech_Message (

5614: --------------------------------------------------------------------------
5615: -- STEP 5: Rollup to the specified parent all data records in FEM_BALANCES
5616: -- of the specified child
5617: --------------------------------------------------------------------------
5618: FEM_ENGINES_PKG.Tech_Message (
5619: p_severity => G_LOG_LEVEL_1
5620: ,p_module => G_BLOCK||'.'||l_api_name
5621: ,p_msg_text => 'Step 5.'||to_char(i)||': Rollup Child ID = '||to_char(l_child_id_tbl(i))
5622: );

Line 5732: FEM_ENGINES_PKG.Tech_Message (

5728:
5729: ----------------------------------------------------------------------------
5730: -- STEP 6: Mark all the uncosted children that were processes as costed
5731: ----------------------------------------------------------------------------
5732: FEM_ENGINES_PKG.Tech_Message (
5733: p_severity => G_LOG_LEVEL_1
5734: ,p_module => G_BLOCK||'.'||l_api_name
5735: ,p_msg_text => 'Step 6: Mark All Uncosted Children Just Processed as Costed'
5736: );

Line 5757: FEM_ENGINES_PKG.Tech_Message (

5753:
5754: ------------------------------------------------------------------------------
5755: -- STEP 7: Mark the parent as costed
5756: ------------------------------------------------------------------------------
5757: FEM_ENGINES_PKG.Tech_Message (
5758: p_severity => G_LOG_LEVEL_1
5759: ,p_module => G_BLOCK||'.'||l_api_name
5760: ,p_msg_text => 'Step 7: Mark the Parent as Costed'
5761: );

Line 5771: FEM_ENGINES_PKG.Tech_Message (

5767: and node_id = p_parent_id;
5768:
5769: commit;
5770:
5771: FEM_ENGINES_PKG.Tech_Message (
5772: p_severity => G_LOG_LEVEL_2
5773: ,p_module => G_BLOCK||'.'||l_api_name
5774: ,p_msg_text => 'END'
5775: );

Line 5785: FEM_ENGINES_PKG.Tech_Message (

5781: if (l_find_children_csr%ISOPEN) then
5782: close l_find_children_csr;
5783: end if;
5784:
5785: FEM_ENGINES_PKG.Tech_Message (
5786: p_severity => G_LOG_LEVEL_6
5787: ,p_module => G_BLOCK||'.'||l_api_name
5788: ,p_msg_text => 'Rollup Parent Node Exception'
5789: );

Line 5810: FEM_ENGINES_PKG.Tech_Message (

5806: if (l_find_children_csr%ISOPEN) then
5807: close l_find_children_csr;
5808: end if;
5809:
5810: FEM_ENGINES_PKG.Tech_Message (
5811: p_severity => G_LOG_LEVEL_6
5812: ,p_module => G_BLOCK||'.'||l_api_name||'.Unexpected_Exception'
5813: ,p_msg_text => g_prg_msg
5814: );

Line 5816: FEM_ENGINES_PKG.Tech_Message (

5812: ,p_module => G_BLOCK||'.'||l_api_name||'.Unexpected_Exception'
5813: ,p_msg_text => g_prg_msg
5814: );
5815:
5816: FEM_ENGINES_PKG.Tech_Message (
5817: p_severity => G_LOG_LEVEL_6
5818: ,p_module => G_BLOCK||'.'||l_api_name||'.Unexpected_Exception'
5819: ,p_msg_text => g_callstack
5820: );

Line 5822: FEM_ENGINES_PKG.User_Message (

5818: ,p_module => G_BLOCK||'.'||l_api_name||'.Unexpected_Exception'
5819: ,p_msg_text => g_callstack
5820: );
5821:
5822: FEM_ENGINES_PKG.User_Message (
5823: p_app_name => G_FEM
5824: ,p_msg_name => G_UNEXPECTED_ERROR
5825: ,p_token1 => 'ERR_MSG'
5826: ,p_value1 => g_prg_msg

Line 5875: FEM_ENGINES_PKG.Tech_Message (

5871: l_register_child_chains_error exception;
5872:
5873: BEGIN
5874:
5875: FEM_ENGINES_PKG.Tech_Message (
5876: p_severity => G_LOG_LEVEL_2
5877: ,p_module => G_BLOCK||'.'||l_api_name
5878: ,p_msg_text => 'BEGIN'
5879: );

Line 5970: FEM_ENGINES_PKG.Tech_Message (

5966: end loop;
5967:
5968: close l_find_child_chains_csr;
5969:
5970: FEM_ENGINES_PKG.Tech_Message (
5971: p_severity => G_LOG_LEVEL_2
5972: ,p_module => G_BLOCK||'.'||l_api_name
5973: ,p_msg_text => 'END'
5974: );

Line 5984: FEM_ENGINES_PKG.Tech_Message (

5980: if (l_find_child_chains_csr%ISOPEN) then
5981: close l_find_child_chains_csr;
5982: end if;
5983:
5984: FEM_ENGINES_PKG.Tech_Message (
5985: p_severity => G_LOG_LEVEL_6
5986: ,p_module => G_BLOCK||'.'||l_api_name
5987: ,p_msg_text => 'Register Child Chains Exception'
5988: );

Line 6009: FEM_ENGINES_PKG.Tech_Message (

6005: if (l_find_child_chains_csr%ISOPEN) then
6006: close l_find_child_chains_csr;
6007: end if;
6008:
6009: FEM_ENGINES_PKG.Tech_Message (
6010: p_severity => G_LOG_LEVEL_6
6011: ,p_module => G_BLOCK||'.'||l_api_name||'.Unexpected_Exception'
6012: ,p_msg_text => g_prg_msg
6013: );

Line 6015: FEM_ENGINES_PKG.Tech_Message (

6011: ,p_module => G_BLOCK||'.'||l_api_name||'.Unexpected_Exception'
6012: ,p_msg_text => g_prg_msg
6013: );
6014:
6015: FEM_ENGINES_PKG.Tech_Message (
6016: p_severity => G_LOG_LEVEL_6
6017: ,p_module => G_BLOCK||'.'||l_api_name||'.Unexpected_Exception'
6018: ,p_msg_text => g_callstack
6019: );

Line 6021: FEM_ENGINES_PKG.User_Message (

6017: ,p_module => G_BLOCK||'.'||l_api_name||'.Unexpected_Exception'
6018: ,p_msg_text => g_callstack
6019: );
6020:
6021: FEM_ENGINES_PKG.User_Message (
6022: p_app_name => G_FEM
6023: ,p_msg_name => G_UNEXPECTED_ERROR
6024: ,p_token1 => 'ERR_MSG'
6025: ,p_value1 => g_prg_msg

Line 6069: FEM_ENGINES_PKG.Tech_Message (

6065: l_rule_post_proc_error exception;
6066:
6067: BEGIN
6068:
6069: FEM_ENGINES_PKG.Tech_Message (
6070: p_severity => G_LOG_LEVEL_2
6071: ,p_module => G_BLOCK||'.'||l_api_name
6072: ,p_msg_text => 'BEGIN'
6073: );

Line 6080: FEM_ENGINES_PKG.Tech_Message (

6076:
6077: ------------------------------------------------------------------------------
6078: -- STEP 1: Drop all Temp Objects created for the Rollup Rule
6079: ------------------------------------------------------------------------------
6080: FEM_ENGINES_PKG.Tech_Message (
6081: p_severity => G_LOG_LEVEL_1
6082: ,p_module => G_BLOCK||'.'||l_api_name
6083: ,p_msg_text => 'Step 1: Drop all Temp Objects'
6084: );

Line 6097: FEM_ENGINES_PKG.Tech_Message (

6093: ----------------------------------------------------------------------------
6094: -- STEP 2: If a successful object execution, update number of input rows in
6095: -- FEM_BALANCES before purging FEM_RU_NODES_T.
6096: ----------------------------------------------------------------------------
6097: FEM_ENGINES_PKG.Tech_Message (
6098: p_severity => G_LOG_LEVEL_1
6099: ,p_module => G_BLOCK||'.'||l_api_name
6100: ,p_msg_text => 'Step 2: Update Number of Input Rows'
6101: );

Line 6169: FEM_ENGINES_PKG.Tech_Message (

6165: -- STEP 3: Delete all records in the FEM_RU_NODES_T table
6166: ------------------------------------------------------------------------------
6167: --todo: should only delete records for p_exec_status_code = SUCCESS. But
6168: --until we bring in error reprocessing, must always delete temp data.
6169: FEM_ENGINES_PKG.Tech_Message (
6170: p_severity => G_LOG_LEVEL_1
6171: ,p_module => G_BLOCK||'.'||l_api_name
6172: ,p_msg_text => 'Step 3: Purging Records in FEM_RU_NODES_T'
6173: );

Line 6191: FEM_ENGINES_PKG.Tech_Message (

6187: -- STEP 4.a: For a COUC rollup, need to delete all records for this
6188: -- request id in the FEM_RU_COST_OBJ_HIER_T table
6189: --------------------------------------------------------------------------
6190: --todo: Until we bring in error reprocessing, must all ways delete temp data.
6191: FEM_ENGINES_PKG.Tech_Message (
6192: p_severity => G_LOG_LEVEL_1
6193: ,p_module => G_BLOCK||'.'||l_api_name
6194: ,p_msg_text => 'Step 4.a: Purging Records in FEM_RU_COST_OBJ_HIER_T'
6195: );

Line 6212: FEM_ENGINES_PKG.Tech_Message (

6208: -- delete all records for this request id in the FEM_RU_ACTIVITIES_HIER_T
6209: -- table.
6210: --------------------------------------------------------------------------
6211: --todo: Until we bring in error reprocessing, must all ways delete temp data.
6212: FEM_ENGINES_PKG.Tech_Message (
6213: p_severity => G_LOG_LEVEL_1
6214: ,p_module => G_BLOCK||'.'||l_api_name
6215: ,p_msg_text => 'Step 4.b: Purging Records in FEM_RU_ACTIVITIES_HIER_T'
6216: );

Line 6231: FEM_ENGINES_PKG.Tech_Message (

6227:
6228: ------------------------------------------------------------------------------
6229: -- STEP 5: Update Number of Output Rows.
6230: ------------------------------------------------------------------------------
6231: FEM_ENGINES_PKG.Tech_Message (
6232: p_severity => G_LOG_LEVEL_1
6233: ,p_module => G_BLOCK||'.'||l_api_name
6234: ,p_msg_text => 'Step 5: Update Number of Output Rows'
6235: );

Line 6284: FEM_ENGINES_PKG.Tech_Message (

6280:
6281: ------------------------------------------------------------------------------
6282: -- STEP 6: Update Object Execution Status.
6283: ------------------------------------------------------------------------------
6284: FEM_ENGINES_PKG.Tech_Message (
6285: p_severity => G_LOG_LEVEL_1
6286: ,p_module => G_BLOCK||'.'||l_api_name
6287: ,p_msg_text => 'Step 6: Update Object Execution Status'
6288: );

Line 6316: FEM_ENGINES_PKG.Tech_Message (

6312:
6313: ----------------------------------------------------------------------------
6314: -- STEP 7: Update Object Execution Errors.
6315: ----------------------------------------------------------------------------
6316: FEM_ENGINES_PKG.Tech_Message (
6317: p_severity => G_LOG_LEVEL_1
6318: ,p_module => G_BLOCK||'.'||l_api_name
6319: ,p_msg_text => 'Step 7: Update Object Execution Errors'
6320: );

Line 6349: FEM_ENGINES_PKG.Tech_Message (

6345: end if;
6346:
6347: commit;
6348:
6349: FEM_ENGINES_PKG.Tech_Message (
6350: p_severity => G_LOG_LEVEL_2
6351: ,p_module => G_BLOCK||'.'||l_api_name
6352: ,p_msg_text => 'END'
6353: );

Line 6359: FEM_ENGINES_PKG.Tech_Message (

6355: EXCEPTION
6356:
6357: when l_rule_post_proc_error then
6358:
6359: FEM_ENGINES_PKG.Tech_Message (
6360: p_severity => G_LOG_LEVEL_6
6361: ,p_module => G_BLOCK||'.'||l_api_name
6362: ,p_msg_text => 'Rule Post Process Exception'
6363: );

Line 6365: FEM_ENGINES_PKG.User_Message (

6361: ,p_module => G_BLOCK||'.'||l_api_name
6362: ,p_msg_text => 'Rule Post Process Exception'
6363: );
6364:
6365: FEM_ENGINES_PKG.User_Message (
6366: p_app_name => G_FEM
6367: ,p_msg_name => G_ENG_RULE_POST_PROC_ERR
6368: ,p_token1 => 'OBJECT_ID'
6369: ,p_value1 => p_rule_rec.rollup_obj_id

Line 6405: FEM_ENGINES_PKG.Tech_Message (

6401: l_request_post_proc_error exception;
6402:
6403: BEGIN
6404:
6405: FEM_ENGINES_PKG.Tech_Message (
6406: p_severity => G_LOG_LEVEL_2
6407: ,p_module => G_BLOCK||'.'||l_api_name
6408: ,p_msg_text => 'BEGIN'
6409: );

Line 6416: FEM_ENGINES_PKG.Tech_Message (

6412:
6413: ----------------------------------------------------------------------------
6414: -- STEP 1: Purge RULE_SET_PROCESS_DATA table
6415: ----------------------------------------------------------------------------
6416: FEM_ENGINES_PKG.Tech_Message (
6417: p_severity => G_LOG_LEVEL_1
6418: ,p_module => G_BLOCK||'.'||l_api_name
6419: ,p_msg_text => 'Step 1: Purge RULE_SET_PROCESS_DATA table'
6420: );

Line 6446: FEM_ENGINES_PKG.Tech_Message (

6442:
6443: ------------------------------------------------------------------------------
6444: -- STEP 2: Update Request Status.
6445: ------------------------------------------------------------------------------
6446: FEM_ENGINES_PKG.Tech_Message (
6447: p_severity => G_LOG_LEVEL_1
6448: ,p_module => G_BLOCK||'.'||l_api_name
6449: ,p_msg_text => 'Step 2: Update Request Status'
6450: );

Line 6477: FEM_ENGINES_PKG.Tech_Message (

6473:
6474: ------------------------------------------------------------------------------
6475: -- STEP 3: Set the final execution status message in the log file.
6476: ------------------------------------------------------------------------------
6477: FEM_ENGINES_PKG.Tech_Message (
6478: p_severity => G_LOG_LEVEL_1
6479: ,p_module => G_BLOCK||'.'||l_api_name
6480: ,p_msg_text => 'Step 3: Set the final execution message in the Log File'
6481: );

Line 6484: FEM_ENGINES_PKG.user_message (

6480: ,p_msg_text => 'Step 3: Set the final execution message in the Log File'
6481: );
6482:
6483: if (p_exec_status_code = G_EXEC_STATUS_SUCCESS) then
6484: FEM_ENGINES_PKG.user_message (
6485: p_app_name => G_FEM
6486: ,p_msg_name => G_EXEC_SUCCESS
6487: );
6488: else

Line 6489: FEM_ENGINES_PKG.user_message (

6485: p_app_name => G_FEM
6486: ,p_msg_name => G_EXEC_SUCCESS
6487: );
6488: else
6489: FEM_ENGINES_PKG.user_message (
6490: p_app_name => G_FEM
6491: ,p_msg_name => G_EXEC_RERUN
6492: );
6493: end if;

Line 6495: FEM_ENGINES_PKG.Tech_Message (

6491: ,p_msg_name => G_EXEC_RERUN
6492: );
6493: end if;
6494:
6495: FEM_ENGINES_PKG.Tech_Message (
6496: p_severity => G_LOG_LEVEL_2
6497: ,p_module => G_BLOCK||'.'||l_api_name
6498: ,p_msg_text => 'END'
6499: );

Line 6505: FEM_ENGINES_PKG.Tech_Message (

6501: EXCEPTION
6502:
6503: when l_request_post_proc_error then
6504:
6505: FEM_ENGINES_PKG.Tech_Message (
6506: p_severity => G_LOG_LEVEL_6
6507: ,p_module => G_BLOCK||'.'||l_api_name
6508: ,p_msg_text => 'Request Post Process Exception'
6509: );

Line 6511: FEM_ENGINES_PKG.User_Message (

6507: ,p_module => G_BLOCK||'.'||l_api_name
6508: ,p_msg_text => 'Request Post Process Exception'
6509: );
6510:
6511: FEM_ENGINES_PKG.User_Message (
6512: p_app_name => G_FEM
6513: ,p_msg_name => G_ENG_REQ_POST_PROC_ERR
6514: );
6515:

Line 6631: FEM_ENGINES_PKG.Tech_Message (

6627: l_message t_msg_data%TYPE;
6628:
6629: BEGIN
6630:
6631: FEM_ENGINES_PKG.Tech_Message (
6632: p_severity => G_LOG_LEVEL_2
6633: ,p_module => G_BLOCK||'.'||l_api_name
6634: ,p_msg_text => 'msg_count='||p_msg_count
6635: );

Line 6644: FEM_ENGINES_PKG.User_Message (

6640:
6641: FND_MESSAGE.Set_Encoded(l_msg_data);
6642: l_message := FND_MESSAGE.Get;
6643:
6644: FEM_ENGINES_PKG.User_Message (
6645: p_msg_text => l_message
6646: );
6647:
6648: FEM_ENGINES_PKG.Tech_Message (

Line 6648: FEM_ENGINES_PKG.Tech_Message (

6644: FEM_ENGINES_PKG.User_Message (
6645: p_msg_text => l_message
6646: );
6647:
6648: FEM_ENGINES_PKG.Tech_Message (
6649: p_severity => G_LOG_LEVEL_2
6650: ,p_module => G_BLOCK||'.'||l_api_name
6651: ,p_msg_text => 'msg_data='||l_message
6652: );

Line 6665: FEM_ENGINES_PKG.User_Message (

6661: ,p_data => l_message
6662: ,p_msg_index_out => l_msg_out
6663: );
6664:
6665: FEM_ENGINES_PKG.User_Message (
6666: p_msg_text => l_message
6667: );
6668:
6669: FEM_ENGINES_PKG.Tech_Message (

Line 6669: FEM_ENGINES_PKG.Tech_Message (

6665: FEM_ENGINES_PKG.User_Message (
6666: p_msg_text => l_message
6667: );
6668:
6669: FEM_ENGINES_PKG.Tech_Message (
6670: p_severity => G_LOG_LEVEL_2
6671: ,p_module => G_BLOCK||'.'||l_api_name
6672: ,p_msg_text => 'msg_data='||l_message
6673: );