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

Line 274: FEM_ENGINES_PKG.Tech_Message(

270: ELSE
271: v_member_col := FEM_INTG_DIM_RULE_ENG_PKG.pv_member_col;
272: END IF;
273:
274: FEM_ENGINES_PKG.Tech_Message(
275: p_severity => pc_log_level_procedure,
276: p_module => v_module_name || '.begin',
277: p_app_name => 'FEM',
278: p_msg_name => 'FEM_GL_POST_201',

Line 302: FEM_ENGINES_PKG.Tech_Message(

298: IF v_attribute_num <> 0 THEN
299:
300: --piush_util.put_line('begin preparation 1 for attribute population');
301:
302: FEM_ENGINES_PKG.Tech_Message(
303: p_severity => pc_log_level_statement,
304: p_module => v_module_name || '.begin_prep1_populate_attribute',
305: p_msg_text => 'begin preparation 1 for attribute population'
306: );

Line 327: FEM_ENGINES_PKG.Tech_Message(

323: );
324: FETCH SegmentQualifierPosition INTO v_budget_pos;
325: CLOSE SegmentQualifierPosition;
326:
327: FEM_ENGINES_PKG.Tech_Message(
328: p_severity => pc_log_level_statement,
329: p_module => v_module_name || '.segment_qualifier_positions',
330: p_msg_text => 'v_account_type_pos=' || v_account_type_pos || ', ' ||
331: 'v_budget_pos=' || v_budget_pos

Line 345: FEM_ENGINES_PKG.Tech_Message(

341: );
342: FETCH SegmentQualifierPosition INTO v_account_type_pos;
343: CLOSE SegmentQualifierPosition;
344:
345: FEM_ENGINES_PKG.Tech_Message(
346: p_severity => pc_log_level_statement,
347: p_module => v_module_name || '.segment_qualifier_positions',
348: p_msg_text => 'v_account_type_pos=' || v_account_type_pos
349: );

Line 620: FEM_ENGINES_PKG.Tech_Message(

616: b_gt_dim_id := FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_id;
617:
618: END IF;
619:
620: FEM_ENGINES_PKG.Tech_Message(
621: p_severity => pc_log_level_statement,
622: p_module => v_module_name || '.end_prep1_populate_attribute',
623: p_msg_text => 'end preparation 1 for attribute population'
624: );

Line 635: FEM_ENGINES_PKG.Tech_Message(

631: -- by FND logging
632: --
633: -- Set Attributes
634: --
635: FEM_ENGINES_PKG.Tech_Message(
636: p_severity => pc_log_level_statement,
637: p_module => v_module_name || '.begin_prep2_populate_attribute',
638: p_msg_text => 'begin preparation 2 for attribute population'
639: );

Line 858: FEM_ENGINES_PKG.Tech_Message(

854: )';
855:
856: END IF;
857:
858: FEM_ENGINES_PKG.Tech_Message(
859: p_severity => pc_log_level_statement,
860: p_module => v_module_name || '.end_prep2_populate_attribute',
861: p_msg_text => 'end preparation 2 for attribute population'
862: );

Line 945: FEM_ENGINES_PKG.Tech_Message(

941: S.LAST_UPDATED_BY,
942: S.LAST_UPDATE_LOGIN
943: )';
944:
945: FEM_ENGINES_PKG.Tech_Message(
946: p_severity => pc_log_level_statement,
947: p_module => v_module_name || '.dsql_insert_merge_into_' ||
948: FEM_INTG_DIM_RULE_ENG_PKG.pv_attr_table_name,
949: p_msg_text => v_stmt1

Line 952: FEM_ENGINES_PKG.Tech_Message(

948: FEM_INTG_DIM_RULE_ENG_PKG.pv_attr_table_name,
949: p_msg_text => v_stmt1
950: );
951:
952: FEM_ENGINES_PKG.Tech_Message(
953: p_severity => pc_log_level_statement,
954: p_module => v_module_name || '.dsql_insert_merge_into_' ||
955: FEM_INTG_DIM_RULE_ENG_PKG.pv_attr_table_name,
956: p_msg_text => v_stmt2

Line 959: FEM_ENGINES_PKG.Tech_Message(

955: FEM_INTG_DIM_RULE_ENG_PKG.pv_attr_table_name,
956: p_msg_text => v_stmt2
957: );
958:
959: FEM_ENGINES_PKG.Tech_Message(
960: p_severity => pc_log_level_statement,
961: p_module => v_module_name || '.dsql_insert_merge_into_' ||
962: FEM_INTG_DIM_RULE_ENG_PKG.pv_attr_table_name,
963: p_msg_text => v_stmt3

Line 966: FEM_ENGINES_PKG.Tech_Message(

962: FEM_INTG_DIM_RULE_ENG_PKG.pv_attr_table_name,
963: p_msg_text => v_stmt3
964: );
965:
966: FEM_ENGINES_PKG.Tech_Message(
967: p_severity => pc_log_level_statement,
968: p_module => v_module_name || '.dsql_insert_merge_into_' ||
969: FEM_INTG_DIM_RULE_ENG_PKG.pv_attr_table_name,
970: p_msg_text => v_stmt4

Line 973: FEM_ENGINES_PKG.Tech_Message(

969: FEM_INTG_DIM_RULE_ENG_PKG.pv_attr_table_name,
970: p_msg_text => v_stmt4
971: );
972:
973: FEM_ENGINES_PKG.Tech_Message(
974: p_severity => pc_log_level_statement,
975: p_module => v_module_name || '.dsql_insert_merge_into_' ||
976: FEM_INTG_DIM_RULE_ENG_PKG.pv_attr_table_name,
977: p_msg_text => v_stmt5

Line 980: FEM_ENGINES_PKG.Tech_Message(

976: FEM_INTG_DIM_RULE_ENG_PKG.pv_attr_table_name,
977: p_msg_text => v_stmt5
978: );
979:
980: FEM_ENGINES_PKG.Tech_Message(
981: p_severity => pc_log_level_statement,
982: p_module => v_module_name || '.dsql_insert_merge_into_' ||
983: FEM_INTG_DIM_RULE_ENG_PKG.pv_attr_table_name,
984: p_msg_text => v_stmt6

Line 987: FEM_ENGINES_PKG.Tech_Message(

983: FEM_INTG_DIM_RULE_ENG_PKG.pv_attr_table_name,
984: p_msg_text => v_stmt6
985: );
986:
987: FEM_ENGINES_PKG.Tech_Message(
988: p_severity => pc_log_level_statement,
989: p_module => v_module_name || '.dsql_insert_merge_into_' ||
990: FEM_INTG_DIM_RULE_ENG_PKG.pv_attr_table_name,
991: p_msg_text => 'USING ' ||

Line 1045: FEM_ENGINES_PKG.Tech_Message(

1041: x_row_count_tot := SQL%ROWCOUNT;
1042:
1043: --piush_util.put_line('SQL%ROWCOUNT = ' || SQL%ROWCOUNT);
1044:
1045: FEM_ENGINES_PKG.Tech_Message(
1046: p_severity => pc_log_level_statement,
1047: p_module => v_module_name || '.cnt_insert_merge_into_' ||
1048: FEM_INTG_DIM_RULE_ENG_PKG.pv_attr_table_name,
1049: p_msg_text => x_row_count_tot

Line 1054: FEM_ENGINES_PKG.Tech_Message(

1050: );
1051:
1052: END IF;
1053:
1054: FEM_ENGINES_PKG.Tech_Message(
1055: p_severity => pc_log_level_procedure,
1056: p_module => v_module_name || '.end',
1057: p_app_name => 'FEM',
1058: p_msg_name => 'FEM_GL_POST_202',

Line 1071: FEM_ENGINES_PKG.Tech_Message(

1067: WHEN FEM_INTG_DIM_RULE_fatal_err THEN
1068:
1069: ROLLBACK;
1070:
1071: FEM_ENGINES_PKG.Tech_Message(
1072: p_severity => pc_log_level_procedure,
1073: p_module => v_module_name || 'unexpected_exception',
1074: p_app_name => 'FEM',
1075: p_msg_name => 'FEM_GL_POST_203',

Line 1088: FEM_ENGINES_PKG.Tech_Message(

1084: WHEN OTHERS THEN
1085:
1086: ROLLBACK;
1087:
1088: FEM_ENGINES_PKG.Tech_Message(
1089: p_severity => pc_log_level_unexpected,
1090: p_module => v_module_name || '.unexpected_exception',
1091: p_app_name => 'FEM',
1092: p_msg_name => 'FEM_GL_POST_215',

Line 1097: FEM_ENGINES_PKG.User_Message(

1093: p_token1 => 'ERR_MSG',
1094: p_value1 => SQLERRM
1095: );
1096:
1097: FEM_ENGINES_PKG.User_Message(
1098: p_app_name => 'FEM',
1099: p_msg_name => 'FEM_GL_POST_215',
1100: p_token1 => 'ERR_MSG',
1101: p_value1 => SQLERRM

Line 1104: FEM_ENGINES_PKG.Tech_Message(

1100: p_token1 => 'ERR_MSG',
1101: p_value1 => SQLERRM
1102: );
1103:
1104: FEM_ENGINES_PKG.Tech_Message(
1105: p_severity => pc_log_level_procedure,
1106: p_module => v_module_name || 'unexpected_exception',
1107: p_app_name => 'FEM',
1108: p_msg_name => 'FEM_GL_POST_203',

Line 1164: FEM_ENGINES_PKG.Tech_Message

1160:
1161: -- End bug Fix 5579716
1162:
1163: BEGIN
1164: FEM_ENGINES_PKG.Tech_Message
1165: ( p_severity => pc_log_level_procedure
1166: ,p_module => pc_module_name||c_func_name
1167: ,p_app_name => 'FEM'
1168: ,p_msg_name => 'FEM_GL_POST_201'

Line 1189: FEM_ENGINES_PKG.Tech_Message(

1185: LOOP
1186: IF v_loop_counter > pc_loop_counter_max
1187: THEN
1188:
1189: FEM_ENGINES_PKG.Tech_Message(
1190: p_severity => pc_log_level_statement
1191: ,p_module => pc_module_name||c_func_name
1192: ,p_msg_text => 'raising FEM_INTG_DIM_RULE_ulock_err'
1193: );

Line 1210: FEM_ENGINES_PKG.Tech_Message(

1206: EXIT;
1207: ELSE
1208: v_loop_counter := v_loop_counter + 1;
1209:
1210: FEM_ENGINES_PKG.Tech_Message(
1211: p_severity => pc_log_level_statement
1212: ,p_module => pc_module_name||c_func_name
1213: ,p_msg_text => 'sleeping ' || pc_sleep_second || ' second'
1214: );

Line 1260: FEM_ENGINES_PKG.Tech_Message

1256: WHERE fiocm.code_combination_id between
1257: :v_low and :v_high
1258: AND fiocm.global_vs_combo_id = :v_gvsc_id';
1259:
1260: FEM_ENGINES_PKG.Tech_Message
1261: (p_severity => pc_log_level_statement
1262: ,p_module => pc_module_name||c_func_name
1263: ,p_app_name => 'FEM'
1264: ,p_msg_name => 'FEM_GL_POST_204'

Line 1277: FEM_ENGINES_PKG.Tech_Message

1273: ,FEM_INTG_DIM_RULE_ENG_PKG.pv_gvsc_id;
1274:
1275: v_rows_processed := v_rows_processed + SQL%ROWCOUNT;
1276:
1277: FEM_ENGINES_PKG.Tech_Message
1278: (p_severity => pc_log_level_statement
1279: ,p_module => pc_module_name||c_func_name
1280: ,p_app_name => 'FEM'
1281: ,p_msg_name => 'FEM_GL_POST_216'

Line 1319: FEM_ENGINES_PKG.User_Message(

1315: v_request_id := FND_REQUEST.submit_request( application => 'GCS',
1316: program => 'FCH_UPDATE_ENTITY_ORGS',
1317: sub_request => FALSE);
1318:
1319: FEM_ENGINES_PKG.User_Message(
1320: p_app_name => 'FEM',
1321: p_msg_text => 'Submitted Update Entity Organizations Request ' || v_request_id
1322: );
1323:

Line 1332: FEM_ENGINES_PKG.Tech_Message

1328: EXCEPTION WHEN OTHERS THEN NULL;
1329: END;
1330: -- End bug Fix 5579716
1331:
1332: FEM_ENGINES_PKG.Tech_Message
1333: (p_severity => pc_log_level_procedure,
1334: p_module => pc_module_name || c_func_name,
1335: p_app_name => 'FEM',
1336: p_msg_name => 'FEM_GL_POST_202',

Line 1346: FEM_ENGINES_PKG.Tech_Message(

1342: WHEN FEM_INTG_DIM_RULE_ulock_err THEN
1343:
1344: ROLLBACK;
1345:
1346: FEM_ENGINES_PKG.Tech_Message(
1347: p_severity => pc_log_level_exception,
1348: p_module => pc_module_name||c_func_name || '.ulock_err_exception',
1349: p_app_name => 'FEM',
1350: p_msg_name => 'FEM_INTG_DIM_RULE_ULOCK_EXISTS'

Line 1353: FEM_ENGINES_PKG.User_Message(

1349: p_app_name => 'FEM',
1350: p_msg_name => 'FEM_INTG_DIM_RULE_ULOCK_EXISTS'
1351: );
1352:
1353: FEM_ENGINES_PKG.User_Message(
1354: p_app_name => 'FEM',
1355: p_msg_name => 'FEM_INTG_DIM_RULE_ULOCK_EXISTS'
1356: );
1357:

Line 1358: FEM_ENGINES_PKG.Tech_Message(

1354: p_app_name => 'FEM',
1355: p_msg_name => 'FEM_INTG_DIM_RULE_ULOCK_EXISTS'
1356: );
1357:
1358: FEM_ENGINES_PKG.Tech_Message(
1359: p_severity => pc_log_level_procedure,
1360: p_module => pc_module_name||c_func_name||'.ulock_err_exception',
1361: p_app_name => 'FEM',
1362: p_msg_name => 'FEM_GL_POST_203',

Line 1372: FEM_ENGINES_PKG.Tech_Message

1368:
1369: x_completion_code := 2;
1370:
1371: WHEN OTHERS THEN
1372: FEM_ENGINES_PKG.Tech_Message
1373: (p_severity => pc_log_level_statement
1374: ,p_module => pc_module_name||c_func_name
1375: ,p_msg_text => 'Error: ' || pv_progress);
1376:

Line 1377: FEM_ENGINES_PKG.Tech_Message

1373: (p_severity => pc_log_level_statement
1374: ,p_module => pc_module_name||c_func_name
1375: ,p_msg_text => 'Error: ' || pv_progress);
1376:
1377: FEM_ENGINES_PKG.Tech_Message
1378: (p_severity => pc_log_level_statement
1379: ,p_module => pc_module_name||c_func_name
1380: ,p_msg_text => 'Error: ' || sqlerrm);
1381:

Line 1382: FEM_ENGINES_PKG.User_Message

1378: (p_severity => pc_log_level_statement
1379: ,p_module => pc_module_name||c_func_name
1380: ,p_msg_text => 'Error: ' || sqlerrm);
1381:
1382: FEM_ENGINES_PKG.User_Message
1383: (p_msg_text => sqlerrm);
1384:
1385: FEM_ENGINES_PKG.Tech_Message
1386: (p_severity => pc_log_level_procedure

Line 1385: FEM_ENGINES_PKG.Tech_Message

1381:
1382: FEM_ENGINES_PKG.User_Message
1383: (p_msg_text => sqlerrm);
1384:
1385: FEM_ENGINES_PKG.Tech_Message
1386: (p_severity => pc_log_level_procedure
1387: ,p_module => pc_module_name||c_func_name||'.unexpected_exception'
1388: ,p_app_name => 'FEM'
1389: ,p_msg_name => 'FEM_GL_POST_203'

Line 1488: FEM_ENGINES_PKG.Tech_Message(

1484: BEGIN
1485: v_module_name := 'fem.plsql.fem_intg_dim.populate_single_segment';
1486: v_func_name := 'FEM_INTG_NEW_DIM_MEMBER_PKG.Populate_Single_Segment';
1487:
1488: FEM_ENGINES_PKG.Tech_Message(
1489: p_severity => pc_log_level_procedure,
1490: p_module => v_module_name || '.begin',
1491: p_app_name => 'FEM',
1492: p_msg_name => 'FEM_GL_POST_201',

Line 1667: FEM_ENGINES_PKG.Tech_Message(

1663: :pv_user_id,
1664: :pv_login_id
1665: )';
1666:
1667: FEM_ENGINES_PKG.Tech_Message(
1668: p_severity => pc_log_level_statement,
1669: p_module => v_module_name || '.dsql_merge_into_' ||
1670: p_member_b_table_name,
1671: p_msg_text => v_stmt1

Line 1674: FEM_ENGINES_PKG.Tech_Message(

1670: p_member_b_table_name,
1671: p_msg_text => v_stmt1
1672: );
1673:
1674: FEM_ENGINES_PKG.Tech_Message(
1675: p_severity => pc_log_level_statement,
1676: p_module => v_module_name || '.dsql_merge_into_' ||
1677: p_member_b_table_name,
1678: p_msg_text => v_stmt2

Line 1681: FEM_ENGINES_PKG.Tech_Message(

1677: p_member_b_table_name,
1678: p_msg_text => v_stmt2
1679: );
1680:
1681: FEM_ENGINES_PKG.Tech_Message(
1682: p_severity => pc_log_level_statement,
1683: p_module => v_module_name || '.dsql_merge_into_' ||
1684: p_member_b_table_name,
1685: p_msg_text => 'USING ' ||

Line 1707: FEM_ENGINES_PKG.Tech_Message(

1703: pv_login_id;
1704:
1705: v_row_count_tot1 := SQL%ROWCOUNT;
1706:
1707: FEM_ENGINES_PKG.Tech_Message(
1708: p_severity => pc_log_level_statement,
1709: p_module => v_module_name || '.cnt_merge_into_' ||
1710: p_member_tl_table_name,
1711: p_msg_text => v_row_count_tot1

Line 1714: FEM_ENGINES_PKG.Tech_Message(

1710: p_member_tl_table_name,
1711: p_msg_text => v_row_count_tot1
1712: );
1713:
1714: FEM_ENGINES_PKG.Tech_Message(
1715: p_severity => pc_log_level_statement,
1716: p_module => v_module_name || '.dsql_merge_into_' ||
1717: p_member_tl_table_name,
1718: p_msg_text => v_stmt3

Line 1721: FEM_ENGINES_PKG.Tech_Message(

1717: p_member_tl_table_name,
1718: p_msg_text => v_stmt3
1719: );
1720:
1721: FEM_ENGINES_PKG.Tech_Message(
1722: p_severity => pc_log_level_statement,
1723: p_module => v_module_name || '.dsql_merge_into_' ||
1724: p_member_tl_table_name,
1725: p_msg_text => v_stmt4

Line 1728: FEM_ENGINES_PKG.Tech_Message(

1724: p_member_tl_table_name,
1725: p_msg_text => v_stmt4
1726: );
1727:
1728: FEM_ENGINES_PKG.Tech_Message(
1729: p_severity => pc_log_level_statement,
1730: p_module => v_module_name || '.dsql_merge_into_' ||
1731: p_member_tl_table_name,
1732: p_msg_text => 'USING ' ||

Line 1754: FEM_ENGINES_PKG.Tech_Message(

1750: pv_login_id;
1751:
1752: v_row_count_tot2 := SQL%ROWCOUNT;
1753:
1754: FEM_ENGINES_PKG.Tech_Message(
1755: p_severity => pc_log_level_statement,
1756: p_module => v_module_name || '.cnt_merge_into_' ||
1757: p_member_tl_table_name,
1758: p_msg_text => v_row_count_tot2

Line 1763: FEM_ENGINES_PKG.Tech_Message(

1759: );
1760:
1761: x_row_count_tot := v_row_count_tot1 + v_row_count_tot2;
1762:
1763: FEM_ENGINES_PKG.Tech_Message(
1764: p_severity => pc_log_level_procedure,
1765: p_module => v_module_name || '.end',
1766: p_app_name => 'FEM',
1767: p_msg_name => 'FEM_GL_POST_202',

Line 1883: FEM_ENGINES_PKG.Tech_Message(

1879:
1880: v_module_name := 'fem.plsql.fem_intg_dim.detail_single_segment';
1881: v_func_name := 'FEM_INTG_NEW_DIM_MEMBER_PKG.Detail_Single_Segment';
1882:
1883: FEM_ENGINES_PKG.Tech_Message(
1884: p_severity => pc_log_level_procedure,
1885: p_module => v_module_name || '.begin',
1886: p_app_name => 'FEM',
1887: p_msg_name => 'FEM_GL_POST_201',

Line 1897: FEM_ENGINES_PKG.Tech_Message(

1893:
1894: x_completion_code := 0;
1895: x_row_count_tot := 0;
1896:
1897: FEM_ENGINES_PKG.Tech_Message(
1898: p_severity => pc_log_level_statement,
1899: p_module => v_module_name || '.begin_dim_member_populate_' ||
1900: LOWER(FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label),
1901: p_msg_text => 'begin '||FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label||

Line 1916: FEM_ENGINES_PKG.Tech_Message(

1912:
1913: LOOP
1914: IF v_loop_counter > pc_loop_counter_max THEN
1915:
1916: FEM_ENGINES_PKG.Tech_Message(
1917: p_severity => pc_log_level_statement,
1918: p_module => v_module_name || '.ulock_err',
1919: p_msg_text => 'raising FEM_INTG_DIM_RULE_ulock_err'
1920: );

Line 1937: FEM_ENGINES_PKG.Tech_Message(

1933: EXIT;
1934: ELSE
1935: v_loop_counter := v_loop_counter + 1;
1936:
1937: FEM_ENGINES_PKG.Tech_Message(
1938: p_severity => pc_log_level_statement,
1939: p_module => v_module_name || '.ulock_sleep',
1940: p_msg_text => 'sleeping ' || pc_sleep_second || ' second'
1941: );

Line 2012: FEM_ENGINES_PKG.User_Message(

2008: --
2009: -- Populate dimension attributes
2010: -- (COMPANY and CCTR do not have attributes to populate)
2011: --
2012: FEM_ENGINES_PKG.User_Message(
2013: p_app_name => 'FEM',
2014: p_msg_name => 'FEM_INTG_DIM_MEMB_501'
2015: );
2016:

Line 2025: FEM_ENGINES_PKG.Tech_Message(

2021: );
2022:
2023: IF v_completion_code = 2 THEN
2024:
2025: FEM_ENGINES_PKG.Tech_Message(
2026: p_severity => pc_log_level_statement,
2027: p_module => v_module_name || '.populate_attribute_err',
2028: p_msg_text => 'raising FEM_INTG_DIM_RULE_attr_err'
2029: );

Line 2034: FEM_ENGINES_PKG.Tech_Message(

2030:
2031: RAISE FEM_INTG_DIM_RULE_attr_err;
2032: END IF;
2033:
2034: FEM_ENGINES_PKG.Tech_Message(
2035: p_severity => pc_log_level_statement,
2036: p_module => v_module_name || '.populate_attribute_err_return',
2037: p_msg_text => 'v_completion_code=' || v_completion_code ||
2038: ', v_row_count_tot=' || v_row_count_tot

Line 2045: FEM_ENGINES_PKG.Tech_Message(

2041: x_row_count_tot := x_row_count_tot + v_row_count_tot;
2042:
2043: COMMIT;
2044:
2045: FEM_ENGINES_PKG.Tech_Message(
2046: p_severity => pc_log_level_statement,
2047: p_module => v_module_name || '.end_dim_member_populate_' ||
2048: lower(FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label),
2049: p_msg_text => 'end ' || FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_varchar_label

Line 2115: FEM_ENGINES_PKG.User_Message(

2111: into v_Num_Workers
2112: from v$parameter
2113: where name = 'cpu_count';
2114:
2115: FEM_ENGINES_PKG.User_Message(
2116: p_app_name => 'FEM',
2117: p_msg_text => 'Kicking off '||v_Num_Workers||' workers requests at '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')
2118: );
2119:

Line 2120: FEM_ENGINES_PKG.Tech_Message(

2116: p_app_name => 'FEM',
2117: p_msg_text => 'Kicking off '||v_Num_Workers||' workers requests at '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')
2118: );
2119:
2120: FEM_ENGINES_PKG.Tech_Message(
2121: p_severity => pc_log_level_statement,
2122: p_module => v_module_name || '.dsql_update_fem_intg_ogl_ccid_map',
2123: p_msg_text => 'USING ' ||
2124: TO_CHAR(FEM_INTG_DIM_RULE_ENG_PKG.pv_coa_id) || ', ' ||

Line 2185: FEM_ENGINES_PKG.Tech_Message(

2181:
2182:
2183: v_row_count_tot := SQL%ROWCOUNT;
2184:
2185: FEM_ENGINES_PKG.Tech_Message(
2186: p_severity => pc_log_level_statement,
2187: p_module => v_module_name || '.cnt_update_FEM_INTG_DIM_RULE_DEFS',
2188: p_msg_text => v_row_count_tot
2189: );

Line 2205: FEM_ENGINES_PKG.Tech_Message(

2201: -- end bug fix 5377544
2202:
2203: COMMIT;
2204:
2205: FEM_ENGINES_PKG.Tech_Message(
2206: p_severity => pc_log_level_statement,
2207: p_module => v_module_name || '.end_mapping_table',
2208: p_msg_text => 'end update mapping table'
2209: );

Line 2211: FEM_ENGINES_PKG.Tech_Message(

2207: p_module => v_module_name || '.end_mapping_table',
2208: p_msg_text => 'end update mapping table'
2209: );
2210:
2211: FEM_ENGINES_PKG.Tech_Message(
2212: p_severity => pc_log_level_procedure,
2213: p_module => v_module_name || '.end',
2214: p_app_name => 'FEM',
2215: p_msg_name => 'FEM_GL_POST_202',

Line 2228: FEM_ENGINES_PKG.Tech_Message(

2224: WHEN FEM_INTG_DIM_RULE_fatal_err THEN
2225:
2226: ROLLBACK;
2227:
2228: FEM_ENGINES_PKG.Tech_Message(
2229: p_severity => pc_log_level_procedure,
2230: p_module => v_module_name || 'unexpected_exception',
2231: p_app_name => 'FEM',
2232: p_msg_name => 'FEM_GL_POST_203',

Line 2245: FEM_ENGINES_PKG.Tech_Message(

2241: WHEN FEM_INTG_DIM_RULE_ulock_err THEN
2242:
2243: ROLLBACK;
2244:
2245: FEM_ENGINES_PKG.Tech_Message(
2246: p_severity => pc_log_level_exception,
2247: p_module => v_module_name || '.ulock_err_exception',
2248: p_app_name => 'FEM',
2249: p_msg_name => 'FEM_INTG_DIM_RULE_ULOCK_EXISTS'

Line 2252: FEM_ENGINES_PKG.User_Message(

2248: p_app_name => 'FEM',
2249: p_msg_name => 'FEM_INTG_DIM_RULE_ULOCK_EXISTS'
2250: );
2251:
2252: FEM_ENGINES_PKG.User_Message(
2253: p_app_name => 'FEM',
2254: p_msg_name => 'FEM_INTG_DIM_RULE_ULOCK_EXISTS'
2255: );
2256:

Line 2257: FEM_ENGINES_PKG.Tech_Message(

2253: p_app_name => 'FEM',
2254: p_msg_name => 'FEM_INTG_DIM_RULE_ULOCK_EXISTS'
2255: );
2256:
2257: FEM_ENGINES_PKG.Tech_Message(
2258: p_severity => pc_log_level_procedure,
2259: p_module => v_module_name || '.ulock_err_exception',
2260: p_app_name => 'FEM',
2261: p_msg_name => 'FEM_GL_POST_203',

Line 2274: FEM_ENGINES_PKG.Tech_Message(

2270: WHEN FEM_INTG_DIM_RULE_attr_err THEN
2271:
2272: ROLLBACK;
2273:
2274: FEM_ENGINES_PKG.Tech_Message(
2275: p_severity => pc_log_level_exception,
2276: p_module => v_module_name || '.attr_err_exception',
2277: p_app_name => 'FEM',
2278: p_msg_name => 'FEM_INTG_DIM_RULE_ATTR_FAILURE'

Line 2281: FEM_ENGINES_PKG.User_Message(

2277: p_app_name => 'FEM',
2278: p_msg_name => 'FEM_INTG_DIM_RULE_ATTR_FAILURE'
2279: );
2280:
2281: FEM_ENGINES_PKG.User_Message(
2282: p_app_name => 'FEM',
2283: p_msg_name => 'FEM_INTG_DIM_RULE_ATTR_FAILURE'
2284: );
2285:

Line 2286: FEM_ENGINES_PKG.Tech_Message(

2282: p_app_name => 'FEM',
2283: p_msg_name => 'FEM_INTG_DIM_RULE_ATTR_FAILURE'
2284: );
2285:
2286: FEM_ENGINES_PKG.Tech_Message(
2287: p_severity => pc_log_level_procedure,
2288: p_module => v_module_name || '.attr_err_exception',
2289: p_app_name => 'FEM',
2290: p_msg_name => 'FEM_GL_POST_203',

Line 2303: FEM_ENGINES_PKG.Tech_Message(

2299: WHEN FEM_INTG_DIM_RULE_worker_err THEN
2300:
2301: ROLLBACK;
2302:
2303: FEM_ENGINES_PKG.Tech_Message(
2304: p_severity => pc_log_level_statement,
2305: p_module => v_module_name || '.worker_err',
2306: p_msg_text => 'Dimension Rule Worker Error: ' || X_errbuf
2307: );

Line 2309: FEM_ENGINES_PKG.User_Message(

2305: p_module => v_module_name || '.worker_err',
2306: p_msg_text => 'Dimension Rule Worker Error: ' || X_errbuf
2307: );
2308:
2309: FEM_ENGINES_PKG.User_Message(
2310: p_app_name => 'FEM',
2311: p_msg_text => 'Dimension Rule Worker Error: ' || X_errbuf
2312: );
2313:

Line 2320: FEM_ENGINES_PKG.Tech_Message(

2316: WHEN OTHERS THEN
2317:
2318: ROLLBACK;
2319:
2320: FEM_ENGINES_PKG.Tech_Message(
2321: p_severity => pc_log_level_unexpected,
2322: p_module => v_module_name || '.unexpected_exception',
2323: p_app_name => 'FEM',
2324: p_msg_name => 'FEM_GL_POST_215',

Line 2329: FEM_ENGINES_PKG.User_Message(

2325: p_token1 => 'ERR_MSG',
2326: p_value1 => SQLERRM
2327: );
2328:
2329: FEM_ENGINES_PKG.User_Message(
2330: p_app_name => 'FEM',
2331: p_msg_name => 'FEM_GL_POST_215',
2332: p_token1 => 'ERR_MSG',
2333: p_value1 => SQLERRM

Line 2336: FEM_ENGINES_PKG.Tech_Message(

2332: p_token1 => 'ERR_MSG',
2333: p_value1 => SQLERRM
2334: );
2335:
2336: FEM_ENGINES_PKG.Tech_Message(
2337: p_severity => pc_log_level_procedure,
2338: p_module => v_module_name || '.unexpected_exception',
2339: p_app_name => 'FEM',
2340: p_msg_name => 'FEM_GL_POST_203',

Line 2437: FEM_ENGINES_PKG.Tech_Message

2433: --piush_util.put_line('Now entering FEM_INTG_NEW_DIM_MEMBER_PKG.Detail_Multi_Segment ********************');
2434:
2435: x_completion_code := 0;
2436:
2437: FEM_ENGINES_PKG.Tech_Message
2438: ( p_severity => pc_log_level_procedure
2439: ,p_module => pc_module_name||c_func_name
2440: ,p_app_name => 'FEM'
2441: ,p_msg_name => 'FEM_GL_POST_201'

Line 2461: FEM_ENGINES_PKG.Tech_Message(

2457: LOOP
2458: IF v_loop_counter > pc_loop_counter_max
2459: THEN
2460:
2461: FEM_ENGINES_PKG.Tech_Message(
2462: p_severity => pc_log_level_statement
2463: ,p_module => pc_module_name||c_func_name
2464: ,p_msg_text => 'raising FEM_INTG_DIM_RULE_ulock_err'
2465: );

Line 2483: FEM_ENGINES_PKG.Tech_Message(

2479: EXIT;
2480: ELSE
2481: v_loop_counter := v_loop_counter + 1;
2482:
2483: FEM_ENGINES_PKG.Tech_Message(
2484: p_severity => pc_log_level_statement
2485: ,p_module => pc_module_name||c_func_name
2486: ,p_msg_text => 'sleeping ' || pc_sleep_second || ' second'
2487: );

Line 2579: FEM_ENGINES_PKG.Tech_Message

2575: WHERE code_combination_id <= :v_high
2576: AND summary_flag = ''N''
2577: AND chart_of_accounts_id = :v_coa_id';
2578:
2579: FEM_ENGINES_PKG.Tech_Message
2580: (p_severity => pc_log_level_statement
2581: ,p_module => pc_module_name||c_func_name
2582: ,p_app_name => 'FEM'
2583: ,p_msg_name => 'FEM_GL_POST_204'

Line 2642: FEM_ENGINES_PKG.Tech_Message

2638:
2639: --piush_util.put_line('v_main_gt_insert_stmt = ' || v_main_gt_insert_stmt);
2640:
2641:
2642: FEM_ENGINES_PKG.Tech_Message
2643: (p_severity => pc_log_level_statement
2644: ,p_module => pc_module_name||c_func_name
2645: ,p_app_name => 'FEM'
2646: ,p_msg_name => 'FEM_GL_POST_204'

Line 2664: FEM_ENGINES_PKG.Tech_Message

2660: v_main_insert_gt_count := SQL%ROWCOUNT;
2661:
2662: --piush_util.put_line('Number of rows inserted = ' || SQL%ROWCOUNT);
2663:
2664: FEM_ENGINES_PKG.Tech_Message
2665: (p_severity => pc_log_level_statement
2666: ,p_module => pc_module_name||c_func_name
2667: ,p_app_name => 'FEM'
2668: ,p_msg_name => 'FEM_GL_POST_216'

Line 2728: FEM_ENGINES_PKG.Tech_Message

2724: pv_progress := 'Before executing member_b population';
2725: --piush_util.put_line(pv_progress);
2726: --piush_util.put_line('v_insert_member_b_stmt = ' || v_insert_member_b_stmt);
2727:
2728: FEM_ENGINES_PKG.Tech_Message
2729: (p_severity => pc_log_level_statement
2730: ,p_module => pc_module_name||c_func_name
2731: ,p_app_name => 'FEM'
2732: ,p_msg_name => 'FEM_GL_POST_204'

Line 2748: FEM_ENGINES_PKG.Tech_Message

2744: ,FEM_INTG_DIM_RULE_ENG_PKG.pv_fem_vs_id;
2745:
2746: v_insert_member_b_count := SQL%ROWCOUNT;
2747:
2748: FEM_ENGINES_PKG.Tech_Message
2749: (p_severity => pc_log_level_statement
2750: ,p_module => pc_module_name||c_func_name
2751: ,p_app_name => 'FEM'
2752: ,p_msg_name => 'FEM_GL_POST_216'

Line 3104: FEM_ENGINES_PKG.Tech_Message

3100: D.UPDATED_DATE,
3101: D.UPDATE_LOGIN)';
3102:
3103:
3104: FEM_ENGINES_PKG.Tech_Message
3105: (
3106: p_severity => pc_log_level_statement
3107: ,p_module => pc_module_name||c_func_name
3108: ,p_msg_text => v_merge_stmt);

Line 3184: FEM_ENGINES_PKG.Tech_Message

3180:
3181: v_merge_count := SQL%ROWCOUNT;
3182:
3183:
3184: FEM_ENGINES_PKG.Tech_Message
3185: (p_severity => pc_log_level_statement
3186: ,p_module => pc_module_name||c_func_name
3187: ,p_app_name => 'FEM'
3188: ,p_msg_name => 'FEM_GL_POST_216'

Line 3206: FEM_ENGINES_PKG.Tech_Message

3202: */
3203:
3204: IF upper( FEM_INTG_DIM_RULE_ENG_PKG.pv_member_b_table_name) = 'FEM_CCTR_ORGS_B'
3205: THEN
3206: FEM_ENGINES_PKG.Tech_Message
3207: (
3208: p_severity => pc_log_level_event
3209: ,p_module => pc_module_name||c_func_name
3210: ,p_msg_text => 'Processing dimension is of type CCTR-ORG');

Line 3235: FEM_ENGINES_PKG.Tech_Message

3231: FROM FEM_INTG_DIM_MEMBERS_GT GT2
3232: WHERE GT2.dimension_id = :v_dim_id';
3233:
3234:
3235: FEM_ENGINES_PKG.Tech_Message
3236: (p_severity => pc_log_level_statement
3237: ,p_module => pc_module_name||c_func_name
3238: ,p_app_name => 'FEM'
3239: ,p_msg_name => 'FEM_GL_POST_204'

Line 3251: FEM_ENGINES_PKG.Tech_Message

3247: USING FEM_INTG_DIM_RULE_ENG_PKG.pv_com_dim_id
3248: ,FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_id;
3249:
3250: v_comp_insert_gt_count := SQL%ROWCOUNT;
3251: FEM_ENGINES_PKG.Tech_Message
3252: (p_severity => pc_log_level_statement
3253: ,p_module => pc_module_name||c_func_name
3254: ,p_app_name => 'FEM'
3255: ,p_msg_name => 'FEM_GL_POST_216'

Line 3307: FEM_ENGINES_PKG.Tech_Message

3303: AND tab1.concat_segment_value = tab2.company_display_code);
3304:
3305: v_comp_member_b_count := SQL%ROWCOUNT;
3306:
3307: FEM_ENGINES_PKG.Tech_Message
3308: (p_severity => pc_log_level_statement
3309: ,p_module => pc_module_name||c_func_name
3310: ,p_app_name => 'FEM'
3311: ,p_msg_name => 'FEM_GL_POST_216'

Line 3357: FEM_ENGINES_PKG.Tech_Message

3353: AND TL.language = tab2.language );
3354:
3355: v_comp_member_tl_count := SQL%ROWCOUNT;
3356:
3357: FEM_ENGINES_PKG.Tech_Message
3358: (p_severity => pc_log_level_statement
3359: ,p_module => pc_module_name||c_func_name
3360: ,p_app_name => 'FEM'
3361: ,p_msg_name => 'FEM_GL_POST_216'

Line 3421: FEM_ENGINES_PKG.Tech_Message

3417: FROM fem_companies_vl tab2
3418: WHERE :v_seg1_vs_id = tab2.value_set_id
3419: AND tab1.concat_segment_value = tab2.company_display_code)';
3420:
3421: FEM_ENGINES_PKG.Tech_Message
3422: (p_severity => pc_log_level_statement
3423: ,p_module => pc_module_name||c_func_name
3424: ,p_msg_text => 'Executing SQL Statement: '||v_insert_comp_vl_stmt||
3425: 'Using: '||fem_intg_dim_rule_eng_pkg.pv_mapped_segs(1).vs_id

Line 3442: FEM_ENGINES_PKG.Tech_Message

3438: fem_intg_dim_rule_eng_pkg.pv_com_vs_id;
3439:
3440: v_comp_member_vl_count := SQL%ROWCOUNT;
3441:
3442: FEM_ENGINES_PKG.Tech_Message
3443: (p_severity => pc_log_level_statement
3444: ,p_module => pc_module_name||c_func_name
3445: ,p_app_name => 'FEM'
3446: ,p_msg_name => 'FEM_GL_POST_216'

Line 3488: FEM_ENGINES_PKG.Tech_Message

3484: ,FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_id;
3485:
3486: v_cc_insert_gt_count := SQL%ROWCOUNT;
3487:
3488: FEM_ENGINES_PKG.Tech_Message
3489: (p_severity => pc_log_level_statement
3490: ,p_module => pc_module_name||c_func_name
3491: ,p_app_name => 'FEM'
3492: ,p_msg_name => 'FEM_GL_POST_216'

Line 3587: FEM_ENGINES_PKG.Tech_Message

3583:
3584: v_cc_member_b_count := SQL%ROWCOUNT;
3585: END IF;
3586:
3587: FEM_ENGINES_PKG.Tech_Message
3588: (p_severity => pc_log_level_statement
3589: ,p_module => pc_module_name||c_func_name
3590: ,p_app_name => 'FEM'
3591: ,p_msg_name => 'FEM_GL_POST_216'

Line 3635: FEM_ENGINES_PKG.Tech_Message

3631: AND tab1.cost_center_id = tab2.cost_center_id
3632: AND TL.language = tab2.language );
3633:
3634: v_cc_member_tl_count := SQL%ROWCOUNT;
3635: FEM_ENGINES_PKG.Tech_Message
3636: (p_severity => pc_log_level_statement
3637: ,p_module => pc_module_name||c_func_name
3638: ,p_app_name => 'FEM'
3639: ,p_msg_name => 'FEM_GL_POST_216'

Line 3699: FEM_ENGINES_PKG.Tech_Message

3695: FROM fem_cost_centers_vl tab2
3696: WHERE :v_seg2_vs_id = tab2.value_set_id
3697: AND tab1.concat_segment_value = tab2.cost_center_display_code)';
3698:
3699: FEM_ENGINES_PKG.Tech_Message
3700: (p_severity => pc_log_level_statement
3701: ,p_module => pc_module_name||c_func_name
3702: ,p_msg_text => 'Executing SQL Statement: '||v_insert_cc_vl_stmt||
3703: 'Using: '||fem_intg_dim_rule_eng_pkg.pv_mapped_segs(2).vs_id

Line 3720: FEM_ENGINES_PKG.Tech_Message

3716: fem_intg_dim_rule_eng_pkg.pv_cc_vs_id;
3717:
3718: v_cc_member_vl_count := SQL%ROWCOUNT;
3719:
3720: FEM_ENGINES_PKG.Tech_Message
3721: (p_severity => pc_log_level_statement
3722: ,p_module => pc_module_name||c_func_name
3723: ,p_app_name => 'FEM'
3724: ,p_msg_name => 'FEM_GL_POST_216'

Line 3732: FEM_ENGINES_PKG.Tech_Message

3728: ,p_value2 => v_cc_member_vl_count);
3729:
3730: END IF;
3731: ELSE /* Not of CCTR type */
3732: FEM_ENGINES_PKG.Tech_Message
3733: (
3734: p_severity => pc_log_level_event
3735: ,p_module => pc_module_name||c_func_name
3736: ,p_msg_text => 'Processing dimension is not of type CCTR-ORG');

Line 3741: FEM_ENGINES_PKG.User_Message(

3737:
3738: END IF;
3739:
3740: v_attr_completion_code := 0;
3741: FEM_ENGINES_PKG.User_Message(
3742: p_app_name => 'FEM',
3743: p_msg_name => 'FEM_INTG_DIM_MEMB_501'
3744: );
3745:

Line 3755: FEM_ENGINES_PKG.Tech_Message

3751: ,x_row_count_tot => v_attr_row_count
3752: );
3753: IF v_attr_completion_code <> 0
3754: THEN
3755: FEM_ENGINES_PKG.Tech_Message
3756: (
3757: p_severity => pc_log_level_event
3758: ,p_module => pc_module_name||c_func_name
3759: ,p_msg_text => 'Unexpected error from Populate_Dimension_Attribute');

Line 3777: FEM_ENGINES_PKG.Tech_Message

3773: SET max_flex_value_id_processed
3774: = FEM_INTG_DIM_RULE_ENG_PKG.pv_max_ccid_to_be_mapped
3775: WHERE dim_rule_obj_def_id = FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_rule_obj_def_id;
3776:
3777: FEM_ENGINES_PKG.Tech_Message
3778: (
3779: p_severity => pc_log_level_procedure
3780: ,p_module => pc_module_name||c_func_name
3781: ,p_msg_text => 'Update fem_intg_dim_rule_defs.max_flex_value_id_processed'||

Line 3849: FEM_ENGINES_PKG.Tech_Message

3845: v_column_list := '(' || TRIM(TRAILING ',' FROM v_column_list) || ')';
3846: v_value_list := TRIM(TRAILING ',' FROM v_value_list);
3847: END IF;
3848:
3849: FEM_ENGINES_PKG.Tech_Message
3850: (
3851: p_severity => pc_log_level_procedure
3852: ,p_module => pc_module_name||c_func_name
3853: ,p_msg_text => 'Columns '||v_column_list||' will be updated in mapping table');

Line 3942: FEM_ENGINES_PKG.Tech_Message

3938: --
3939: pv_progress := 'Before executing update map';
3940: --piush_util.put_line(pv_progress);
3941:
3942: FEM_ENGINES_PKG.Tech_Message
3943: (p_severity => pc_log_level_statement
3944: ,p_module => pc_module_name||c_func_name
3945: ,p_app_name => 'FEM'
3946: ,p_msg_name => 'FEM_GL_POST_204'

Line 3973: FEM_ENGINES_PKG.Tech_Message

3969: END IF;
3970:
3971: v_upd_map_table_count := SQL%ROWCOUNT;
3972: v_rows_processed := v_rows_processed + v_upd_map_table_count;
3973: FEM_ENGINES_PKG.Tech_Message
3974: (p_severity => pc_log_level_statement
3975: ,p_module => pc_module_name||c_func_name
3976: ,p_app_name => 'FEM'
3977: ,p_msg_name => 'FEM_GL_POST_217'

Line 4038: FEM_ENGINES_PKG.User_Message(

4034: into v_Num_Workers
4035: from v$parameter
4036: where name = 'cpu_count';
4037:
4038: FEM_ENGINES_PKG.User_Message(
4039: p_app_name => 'FEM',
4040: p_msg_text => 'Kicking off '||v_Num_Workers||' workers requests at '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')
4041: );
4042:

Line 4043: FEM_ENGINES_PKG.Tech_Message(

4039: p_app_name => 'FEM',
4040: p_msg_text => 'Kicking off '||v_Num_Workers||' workers requests at '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')
4041: );
4042:
4043: FEM_ENGINES_PKG.Tech_Message(
4044: p_severity => pc_log_level_statement,
4045: p_module => pc_module_name||c_func_name,
4046: p_msg_text => 'USING ' ||
4047: TO_CHAR(FEM_INTG_DIM_RULE_ENG_PKG.pv_coa_id) || ', ' ||

Line 4110: FEM_ENGINES_PKG.Tech_Message(

4106: v_rows_processed := SQL%ROWCOUNT;
4107:
4108: COMMIT;
4109:
4110: FEM_ENGINES_PKG.Tech_Message(
4111: p_severity => pc_log_level_statement,
4112: p_module => pc_module_name || '.cnt_update_FEM_INTG_DIM_RULE_DEFS',
4113: p_msg_text => v_rows_processed
4114: );

Line 4130: FEM_ENGINES_PKG.User_Message(

4126: v_request_id := FND_REQUEST.submit_request( application => 'GCS',
4127: program => 'FCH_UPDATE_ENTITY_ORGS',
4128: sub_request => FALSE);
4129:
4130: FEM_ENGINES_PKG.User_Message(
4131: p_app_name => 'FEM',
4132: p_msg_text => 'Submitted Update Entity Organizations Request ' || v_request_id
4133: );
4134:

Line 4148: FEM_ENGINES_PKG.Tech_Message

4144:
4145: x_completion_code := v_completion_code;
4146: -- end bug fix 5377544
4147:
4148: FEM_ENGINES_PKG.Tech_Message
4149: (p_severity => pc_log_level_procedure,
4150: p_module => pc_module_name || c_func_name,
4151: p_app_name => 'FEM',
4152: p_msg_name => 'FEM_GL_POST_202',

Line 4163: FEM_ENGINES_PKG.Tech_Message(

4159: WHEN FEM_INTG_DIM_RULE_ulock_err THEN
4160:
4161: ROLLBACK;
4162:
4163: FEM_ENGINES_PKG.Tech_Message(
4164: p_severity => pc_log_level_exception,
4165: p_module => PC_module_name || c_func_name|| '.ulock_err_exception',
4166: p_app_name => 'FEM',
4167: p_msg_name => 'FEM_INTG_DIM_RULE_ULOCK_EXISTS'

Line 4170: FEM_ENGINES_PKG.User_Message(

4166: p_app_name => 'FEM',
4167: p_msg_name => 'FEM_INTG_DIM_RULE_ULOCK_EXISTS'
4168: );
4169:
4170: FEM_ENGINES_PKG.User_Message(
4171: p_app_name => 'FEM',
4172: p_msg_name => 'FEM_INTG_DIM_RULE_ULOCK_EXISTS'
4173: );
4174:

Line 4175: FEM_ENGINES_PKG.Tech_Message(

4171: p_app_name => 'FEM',
4172: p_msg_name => 'FEM_INTG_DIM_RULE_ULOCK_EXISTS'
4173: );
4174:
4175: FEM_ENGINES_PKG.Tech_Message(
4176: p_severity => pc_log_level_procedure,
4177: p_module => pc_module_name || c_func_name|| '.ulock_err_exception',
4178: p_app_name => 'FEM',
4179: p_msg_name => 'FEM_GL_POST_203',

Line 4192: FEM_ENGINES_PKG.Tech_Message(

4188: WHEN FEM_INTG_DIM_RULE_worker_err THEN
4189:
4190: ROLLBACK;
4191:
4192: FEM_ENGINES_PKG.Tech_Message(
4193: p_severity => pc_log_level_statement,
4194: p_module => pc_module_name || '.worker_err',
4195: p_msg_text => 'Dimension Rule Worker Error: ' || X_errbuf
4196: );

Line 4198: FEM_ENGINES_PKG.User_Message(

4194: p_module => pc_module_name || '.worker_err',
4195: p_msg_text => 'Dimension Rule Worker Error: ' || X_errbuf
4196: );
4197:
4198: FEM_ENGINES_PKG.User_Message(
4199: p_app_name => 'FEM',
4200: p_msg_text => 'Dimension Rule Worker Error: ' || X_errbuf
4201: );
4202:

Line 4211: FEM_ENGINES_PKG.Tech_Message

4207: --piush_util.put_line('SQLCODE = ' || SQLCODE);
4208: --piush_util.put_line('SQLERRM = ' || SQLERRM);
4209: --raise;
4210: ROLLBACK;
4211: FEM_ENGINES_PKG.Tech_Message
4212: (p_severity => pc_log_level_statement
4213: ,p_module => pc_module_name||c_func_name
4214: ,p_msg_text => 'Error: ' || pv_progress);
4215:

Line 4216: FEM_ENGINES_PKG.Tech_Message

4212: (p_severity => pc_log_level_statement
4213: ,p_module => pc_module_name||c_func_name
4214: ,p_msg_text => 'Error: ' || pv_progress);
4215:
4216: FEM_ENGINES_PKG.Tech_Message
4217: (p_severity => pc_log_level_statement
4218: ,p_module => pc_module_name||c_func_name
4219: ,p_msg_text => 'Error: ' || sqlerrm);
4220: FEM_ENGINES_PKG.Tech_Message

Line 4220: FEM_ENGINES_PKG.Tech_Message

4216: FEM_ENGINES_PKG.Tech_Message
4217: (p_severity => pc_log_level_statement
4218: ,p_module => pc_module_name||c_func_name
4219: ,p_msg_text => 'Error: ' || sqlerrm);
4220: FEM_ENGINES_PKG.Tech_Message
4221: (p_severity => pc_log_level_unexpected
4222: ,p_module => pc_module_name||c_func_name||'.unexpected_exception'
4223: ,p_msg_text => sqlerrm);
4224:

Line 4226: FEM_ENGINES_PKG.User_Message

4222: ,p_module => pc_module_name||c_func_name||'.unexpected_exception'
4223: ,p_msg_text => sqlerrm);
4224:
4225:
4226: FEM_ENGINES_PKG.User_Message
4227: (p_msg_text => sqlerrm);
4228:
4229: FEM_ENGINES_PKG.Tech_Message
4230: (p_severity => pc_log_level_procedure

Line 4229: FEM_ENGINES_PKG.Tech_Message

4225:
4226: FEM_ENGINES_PKG.User_Message
4227: (p_msg_text => sqlerrm);
4228:
4229: FEM_ENGINES_PKG.Tech_Message
4230: (p_severity => pc_log_level_procedure
4231: ,p_module => pc_module_name||c_func_name||'.unexpected_exception'
4232: ,p_app_name => 'FEM'
4233: ,p_msg_name => 'FEM_GL_POST_203'

Line 4266: FEM_ENGINES_PKG.Tech_Message

4262: v_row_count_tot NUMBER := 0;
4263:
4264: BEGIN
4265:
4266: FEM_ENGINES_PKG.Tech_Message
4267: (p_severity => pc_log_level_procedure,
4268: p_module => 'fem.plsql.fem_intg_new_dim_member.Create_Parent_Members',
4269: p_app_name => 'FEM',
4270: p_msg_name => 'FEM_GL_POST_201',

Line 4304: FEM_ENGINES_PKG.Tech_Message

4300: AND ff.flex_value = hgt.child_display_code';
4301:
4302:
4303:
4304: FEM_ENGINES_PKG.Tech_Message
4305: (p_severity => pc_log_level_procedure,
4306: p_module => 'fem.plsql.fem_intg_new_dim_member.Create_Parent_Members',
4307: p_app_name => 'FEM',
4308: p_msg_name => 'FEM_GL_POST_204',

Line 4360: FEM_ENGINES_PKG.Tech_Message

4356: SYSDATE,
4357: ''N'',
4358: 1)';
4359:
4360: FEM_ENGINES_PKG.Tech_Message
4361: (p_severity => pc_log_level_procedure,
4362: p_module => 'fem.plsql.fem_intg_new_dim_member.Create_Parent_Members.',
4363: p_app_name => 'FEM',
4364: p_msg_name => 'FEM_GL_POST_204',

Line 4420: FEM_ENGINES_PKG.Tech_Message

4416: :pv_login_id,
4417: SYSDATE,
4418: s.description)';
4419:
4420: FEM_ENGINES_PKG.Tech_Message
4421: (p_severity => pc_log_level_procedure,
4422: p_module => 'fem.plsql.fem_intg_new_dim_member.Create_Parent_Members.',
4423: p_app_name => 'FEM',
4424: p_msg_name => 'FEM_GL_POST_204',

Line 4448: FEM_ENGINES_PKG.User_Message(

4444: FEM_INTG_DIM_RULE_ENG_PKG.pv_user_id := pv_user_id;
4445:
4446: FEM_INTG_DIM_RULE_ENG_PKG.Init;
4447:
4448: FEM_ENGINES_PKG.User_Message(
4449: p_app_name => 'FEM',
4450: p_msg_name => 'FEM_INTG_DIM_MEMB_501');
4451:
4452: -- Call FEM_INTG_NEW_MEMBER_PKG.Populate_Attr( ).

Line 4466: FEM_ENGINES_PKG.Tech_Message

4462: COMMIT;
4463:
4464: x_completion_code := 0;
4465:
4466: FEM_ENGINES_PKG.Tech_Message
4467: (p_severity => pc_log_level_procedure,
4468: p_module => 'fem.plsql.fem_intg_new_dim_member.Create_Parent_Members',
4469: p_app_name => 'FEM',
4470: p_msg_name => 'FEM_GL_POST_202',

Line 4483: FEM_ENGINES_PKG.Tech_Message

4479:
4480: WHEN FEM_INTG_fatal_err THEN
4481: ROLLBACk;
4482:
4483: FEM_ENGINES_PKG.Tech_Message
4484: (p_severity => pc_log_level_unexpected,
4485: p_module => 'fem.plsql.fem_intg_new_dim_member.Create_Parent_Members',
4486: p_app_name => 'FEM',
4487: p_msg_name => 'FEM_GL_POST_215',

Line 4491: FEM_ENGINES_PKG.User_Message

4487: p_msg_name => 'FEM_GL_POST_215',
4488: p_token1 => 'ERR_MSG',
4489: p_value1 => SQLERRM);
4490:
4491: FEM_ENGINES_PKG.User_Message
4492: (p_app_name => 'FEM',
4493: p_msg_name => 'FEM_GL_POST_215',
4494: p_token1 => 'ERR_MSG',
4495: p_value1 => SQLERRM);

Line 4497: FEM_ENGINES_PKG.Tech_Message

4493: p_msg_name => 'FEM_GL_POST_215',
4494: p_token1 => 'ERR_MSG',
4495: p_value1 => SQLERRM);
4496:
4497: FEM_ENGINES_PKG.Tech_Message
4498: (p_severity => pc_log_level_procedure,
4499: p_module => 'fem.plsql.fem_intg_new_dim_member.Create_Parent_Members',
4500: p_app_name => 'FEM',
4501: p_msg_name => 'FEM_GL_POST_203',

Line 4514: FEM_ENGINES_PKG.Tech_Message

4510: WHEN OTHERS THEN
4511:
4512: ROLLBACK;
4513:
4514: FEM_ENGINES_PKG.Tech_Message
4515: (p_severity => pc_log_level_unexpected,
4516: p_module => 'fem.plsql.fem_intg_new_dim_member.Create_Parent_Members',
4517: p_app_name => 'FEM',
4518: p_msg_name => 'FEM_GL_POST_215',

Line 4522: FEM_ENGINES_PKG.User_Message

4518: p_msg_name => 'FEM_GL_POST_215',
4519: p_token1 => 'ERR_MSG',
4520: p_value1 => SQLERRM);
4521:
4522: FEM_ENGINES_PKG.User_Message
4523: (p_app_name => 'FEM',
4524: p_msg_name => 'FEM_GL_POST_215',
4525: p_token1 => 'ERR_MSG',
4526: p_value1 => SQLERRM);

Line 4528: FEM_ENGINES_PKG.Tech_Message

4524: p_msg_name => 'FEM_GL_POST_215',
4525: p_token1 => 'ERR_MSG',
4526: p_value1 => SQLERRM);
4527:
4528: FEM_ENGINES_PKG.Tech_Message
4529: (p_severity => pc_log_level_procedure,
4530: p_module => 'fem.plsql.fem_intg_new_dim_member.Create_Parent_Members',
4531: p_app_name => 'FEM',
4532: p_msg_name => 'FEM_GL_POST_203',

Line 4644: FEM_ENGINES_PKG.Tech_Message(

4640: BEGIN
4641:
4642: v_module_name := 'fem.plsql.fem_intg_dim.FEM_INTG_DIM_RULE_WORKER';
4643:
4644: FEM_ENGINES_PKG.Tech_Message(
4645: p_severity => pc_log_level_procedure,
4646: p_module => v_module_name || '.start_worker',
4647: p_msg_text => 'Start of mapping table update worker id : '||p_Worker_Id
4648: );

Line 4650: FEM_ENGINES_PKG.User_Message(

4646: p_module => v_module_name || '.start_worker',
4647: p_msg_text => 'Start of mapping table update worker id : '||p_Worker_Id
4648: );
4649:
4650: FEM_ENGINES_PKG.User_Message(
4651: p_app_name => 'FEM',
4652: p_msg_text => '<< Start of mapping table update worker >>'
4653: );
4654: FEM_ENGINES_PKG.User_Message(

Line 4654: FEM_ENGINES_PKG.User_Message(

4650: FEM_ENGINES_PKG.User_Message(
4651: p_app_name => 'FEM',
4652: p_msg_text => '<< Start of mapping table update worker >>'
4653: );
4654: FEM_ENGINES_PKG.User_Message(
4655: p_app_name => 'FEM',
4656: p_msg_text => 'p_Worker_Id : '||p_Worker_Id
4657: );
4658: FEM_ENGINES_PKG.User_Message(

Line 4658: FEM_ENGINES_PKG.User_Message(

4654: FEM_ENGINES_PKG.User_Message(
4655: p_app_name => 'FEM',
4656: p_msg_text => 'p_Worker_Id : '||p_Worker_Id
4657: );
4658: FEM_ENGINES_PKG.User_Message(
4659: p_app_name => 'FEM',
4660: p_msg_text => 'p_coa_id : '||p_coa_id
4661: );
4662: FEM_ENGINES_PKG.User_Message(

Line 4662: FEM_ENGINES_PKG.User_Message(

4658: FEM_ENGINES_PKG.User_Message(
4659: p_app_name => 'FEM',
4660: p_msg_text => 'p_coa_id : '||p_coa_id
4661: );
4662: FEM_ENGINES_PKG.User_Message(
4663: p_app_name => 'FEM',
4664: p_msg_text => 'p_gvsc_id : '||p_gvsc_id
4665: );
4666: FEM_ENGINES_PKG.User_Message(

Line 4666: FEM_ENGINES_PKG.User_Message(

4662: FEM_ENGINES_PKG.User_Message(
4663: p_app_name => 'FEM',
4664: p_msg_text => 'p_gvsc_id : '||p_gvsc_id
4665: );
4666: FEM_ENGINES_PKG.User_Message(
4667: p_app_name => 'FEM',
4668: p_msg_text => 'p_Num_Workers : '||p_Num_Workers
4669: );
4670: FEM_ENGINES_PKG.User_Message(

Line 4670: FEM_ENGINES_PKG.User_Message(

4666: FEM_ENGINES_PKG.User_Message(
4667: p_app_name => 'FEM',
4668: p_msg_text => 'p_Num_Workers : '||p_Num_Workers
4669: );
4670: FEM_ENGINES_PKG.User_Message(
4671: p_app_name => 'FEM',
4672: p_msg_text => 'p_Worker_Id : '||p_Worker_Id
4673: );
4674: FEM_ENGINES_PKG.User_Message(

Line 4674: FEM_ENGINES_PKG.User_Message(

4670: FEM_ENGINES_PKG.User_Message(
4671: p_app_name => 'FEM',
4672: p_msg_text => 'p_Worker_Id : '||p_Worker_Id
4673: );
4674: FEM_ENGINES_PKG.User_Message(
4675: p_app_name => 'FEM',
4676: p_msg_text => 'p_max_ccid_processed : '||p_max_ccid_processed
4677: );
4678: FEM_ENGINES_PKG.User_Message(

Line 4678: FEM_ENGINES_PKG.User_Message(

4674: FEM_ENGINES_PKG.User_Message(
4675: p_app_name => 'FEM',
4676: p_msg_text => 'p_max_ccid_processed : '||p_max_ccid_processed
4677: );
4678: FEM_ENGINES_PKG.User_Message(
4679: p_app_name => 'FEM',
4680: p_msg_text => 'p_max_ccid_to_be_mapped : '||p_max_ccid_to_be_mapped
4681: );
4682:

Line 4719: FEM_ENGINES_PKG.User_Message(

4715: TRUE);
4716:
4717: WHILE (v_any_rows_to_process = TRUE) LOOP
4718:
4719: FEM_ENGINES_PKG.User_Message(
4720: p_app_name => 'FEM',
4721: p_msg_text => 'Processing rowid from ' || v_start_rowid || ' to '|| v_end_rowid || pv_crlf
4722: );
4723:

Line 4809: FEM_ENGINES_PKG.User_Message(

4805: AND rowid BETWEEN :rowid_low and :rowid_high';
4806:
4807: IF (v_ccid_cur_stmt IS NOT NULL AND v_ccid_update_stmt IS NOT NULL) THEN
4808:
4809: FEM_ENGINES_PKG.User_Message(
4810: p_app_name => 'FEM',
4811: p_msg_text => 'v_ccid_cur_stmt : '||v_ccid_cur_stmt
4812: );
4813:

Line 4814: FEM_ENGINES_PKG.User_Message(

4810: p_app_name => 'FEM',
4811: p_msg_text => 'v_ccid_cur_stmt : '||v_ccid_cur_stmt
4812: );
4813:
4814: FEM_ENGINES_PKG.User_Message(
4815: p_app_name => 'FEM',
4816: p_msg_text => 'v_ccid_update_stmt : '
4817: );
4818:

Line 4823: FEM_ENGINES_PKG.User_Message(

4819: v_start_pos := 1;
4820:
4821: LOOP
4822:
4823: FEM_ENGINES_PKG.User_Message(
4824: p_app_name => 'FEM',
4825: p_msg_text => substr(v_ccid_update_stmt, v_start_pos, 4000)
4826: );
4827:

Line 4869: FEM_ENGINES_PKG.Tech_Message(

4865: END LOOP;
4866:
4867: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
4868:
4869: FEM_ENGINES_PKG.Tech_Message(
4870: p_severity => pc_log_level_procedure,
4871: p_module => v_module_name || '.end_worker',
4872: p_msg_text => '<< end of mapping table update worker >>'
4873: );

Line 4875: FEM_ENGINES_PKG.User_Message(

4871: p_module => v_module_name || '.end_worker',
4872: p_msg_text => '<< end of mapping table update worker >>'
4873: );
4874:
4875: FEM_ENGINES_PKG.User_Message(
4876: p_app_name => 'FEM',
4877: p_msg_text => '<< end of mapping table update worker >>'
4878: );
4879:

Line 4882: FEM_ENGINES_PKG.Tech_Message(

4878: );
4879:
4880: EXCEPTION
4881: WHEN OTHERS THEN
4882: FEM_ENGINES_PKG.Tech_Message(
4883: p_severity => pc_log_level_exception,
4884: p_module => v_module_name || '.err_worker',
4885: p_msg_text => 'Worker Error '||SQLERRM
4886: );

Line 4888: FEM_ENGINES_PKG.User_Message(

4884: p_module => v_module_name || '.err_worker',
4885: p_msg_text => 'Worker Error '||SQLERRM
4886: );
4887:
4888: FEM_ENGINES_PKG.User_Message(
4889: p_app_name => 'FEM',
4890: p_msg_text => 'Worker Error '||SQLERRM
4891: );
4892: