DBA Data[Home] [Help]

APPS.FEM_COMP_DIM_MEMBER_LOADER_PKG dependencies on FEM_ENGINES_PKG

Line 53: fem_engines_pkg.tech_message (

49: i NUMBER; -- counting variable for no:of segments of Flex Field
50:
51: BEGIN
52:
53: fem_engines_pkg.tech_message (
54: p_severity => c_log_level_1
55: ,p_module => c_block||'.'||c_proc_name||'.Begin'
56: ,p_msg_text => 'Dimension'||p_dimension_varchar_label);
57:

Line 139: fem_engines_pkg.tech_message (

135: t_metadata(j).member_sql := NULL;
136:
137: END LOOP;
138:
139: fem_engines_pkg.tech_message (
140: p_severity => c_log_level_1
141: ,p_module => c_block||'.'||c_proc_name||'.End'
142: ,p_msg_text => 'Dimension'||p_dimension_varchar_label);
143:

Line 148: fem_engines_pkg.tech_message (

144: EXCEPTION
145:
146: WHEN others THEN
147:
148: fem_engines_pkg.tech_message (
149: p_severity => c_log_level_4
150: ,p_module => c_block||'.'||c_proc_name||'.Exception'
151: ,p_msg_text => 'Dimension'||p_dimension_varchar_label||
152: 'Code'||SQLCODE||'Err'||SQLERRM);

Line 198: fem_engines_pkg.tech_message (

194: v_last_row NUMBER;
195:
196: BEGIN
197:
198: fem_engines_pkg.tech_message (
199: p_severity => c_log_level_1
200: ,p_module => c_block||'.'||c_proc_name||'.Begin'
201: ,p_msg_text => 'Dimension'||p_dimension_varchar_label);
202:

Line 366: fem_engines_pkg.tech_message (

362: -----------------------------------------------------------------------------
363: ---End Concatenate the segments
364: -----------------------------------------------------------------------------
365:
366: fem_engines_pkg.tech_message (
367: p_severity => c_log_level_1
368: ,p_module => c_block||'.'||c_proc_name||'.End'
369: ,p_msg_text => 'Dimension'||p_dimension_varchar_label);
370:

Line 374: fem_engines_pkg.tech_message (

370:
371: EXCEPTION
372:
373: WHEN others THEN
374: fem_engines_pkg.tech_message (
375: p_severity => c_log_level_4
376: ,p_module => c_block||'.'||c_proc_name||'.Exception'
377: ,p_msg_text => 'Dimension'||p_dimension_varchar_label||
378: 'Code'||SQLCODE||'Err'||SQLERRM);

Line 432: fem_engines_pkg.tech_message (

428:
429: -- Initialize the return status
430: x_pre_process_status := 'SUCCESS';
431:
432: fem_engines_pkg.tech_message (
433: p_severity => c_log_level_1
434: ,p_module => c_block||'.'||c_proc_name||'.Begin'
435: ,p_msg_text => 'Mode'||p_execution_mode
436: ||'Dimension'||p_dimension_varchar_label);

Line 452: fem_engines_pkg.tech_message (

448:
449: EXCEPTION
450:
451: WHEN no_data_found THEN
452: fem_engines_pkg.tech_message (
453: p_severity => c_log_level_4
454: ,p_module => c_block||'.'||c_proc_name||'.Freeze_Exception'
455: ,p_msg_text => 'Dimension'||p_dimension_varchar_label||
456: 'Code'||SQLCODE||'Err'||SQLERRM);

Line 461: fem_engines_pkg.tech_message (

457: END;
458:
459: IF l_dim_active_flag = 'N' THEN
460:
461: fem_engines_pkg.tech_message (
462: p_severity => c_log_level_5
463: ,p_module => c_block||'.'||c_proc_name
464: ,p_msg_text => 'Dimension'||p_dimension_varchar_label||' Flex Field
465: Definition Not Freezed');

Line 481: fem_engines_pkg.tech_message (

477: --Initialize the TABLE TYPE Variable which holds the metadata information
478: ---------------------------------------------------------------------------
479: Metadata_Initialize(p_dimension_varchar_label);
480:
481: fem_engines_pkg.tech_message (
482: p_severity => c_log_level_1
483: ,p_module => c_block||'.'||c_proc_name
484: ,p_msg_text => 'After Metadata_Initialize');
485:

Line 677: fem_engines_pkg.tech_message (

673: /* IF (p_execution_mode = 'S') THEN
674: g_select_statement := g_select_statement||' AND status = ''LOAD''';
675: END IF; */
676:
677: fem_engines_pkg.tech_message (
678: p_severity => c_log_level_1
679: ,p_module => c_block||'.'||c_proc_name||'.End'
680: ,p_msg_text => 'Mode'||p_execution_mode
681: ||'Dimension'||p_dimension_varchar_label);

Line 687: fem_engines_pkg.tech_message (

683: EXCEPTION
684:
685: WHEN e_no_structure_defined THEN
686:
687: fem_engines_pkg.tech_message (
688: p_severity => c_log_level_4
689: ,p_module => c_block||'.'||c_proc_name||'.Exception'
690: ,p_app_name => c_fem
691: ,p_msg_name => G_NO_STRUCTURE_DEFINED

Line 699: fem_engines_pkg.tech_message (

695: x_pre_process_status := 'ERROR';
696:
697: WHEN others THEN
698:
699: fem_engines_pkg.tech_message (
700: p_severity => c_log_level_4
701: ,p_module => c_block||'.'||c_proc_name||'.Exception'
702: ,p_msg_text => 'Mode'||p_execution_mode||
703: 'Dimension'||p_dimension_varchar_label||

Line 1108: fem_engines_pkg.tech_message(

1104:
1105:
1106: BEGIN
1107:
1108: fem_engines_pkg.tech_message(
1109: p_severity => c_log_level_2
1110: ,p_module => c_block||'.'||c_proc_name||'.Begin'
1111: ,p_msg_text => 'Execution Mode' || p_execution_mode||
1112: 'Dimension' || p_dimension_varchar_label);

Line 1126: fem_engines_pkg.tech_message(

1122: ,p_dimension_varchar_label);
1123:
1124:
1125:
1126: fem_engines_pkg.tech_message(
1127: p_severity => c_log_level_5
1128: ,p_module => c_block||'.'||c_proc_name||'.After Pre_Process'
1129: ,p_msg_text => 'Pre_Process Error '||x_pre_process_status);
1130:

Line 1139: fem_engines_pkg.tech_message (

1135:
1136:
1137: IF x_pre_process_status = 'ERROR' THEN
1138:
1139: fem_engines_pkg.tech_message (
1140: p_severity => c_log_level_4
1141: ,p_module => c_block||'.'||c_proc_name||'Pre_Process Error'
1142: ,p_msg_text => 'Code'||SQLCODE||'Err'||SQLERRM);
1143:

Line 1190: fem_engines_pkg.tech_message (

1186:
1187: END IF;
1188:
1189:
1190: fem_engines_pkg.tech_message (
1191: p_severity => c_log_level_1
1192: ,p_module => c_block||'.'||c_proc_name
1193: ,p_msg_text => 'v_update_stmt '||v_update_stmt||
1194: 'v_member_table_name '||v_member_table_name);

Line 1197: fem_engines_pkg.tech_message (

1193: ,p_msg_text => 'v_update_stmt '||v_update_stmt||
1194: 'v_member_table_name '||v_member_table_name);
1195:
1196:
1197: fem_engines_pkg.tech_message (
1198: p_severity => c_log_level_1
1199: ,p_module => c_block||'.'||c_proc_name
1200: ,p_msg_text => 'v_delete_stmt '||v_delete_stmt||
1201: 'v_member_table_name '||v_member_table_name);

Line 1215: fem_engines_pkg.tech_message (

1211: x_part_name => v_part_name,
1212: p_req_id => p_req_id,
1213: p_proc_num => p_proc_num);
1214:
1215: fem_engines_pkg.tech_message (
1216: p_severity => c_log_level_1
1217: ,p_module=> c_block||'.'||c_proc_name||'.Get_Data_Slice'
1218: ,p_msg_text => 'v_slc_id '||v_slc_id||
1219: 'v_slc_val2'||v_slc_val2||

Line 1276: fem_engines_pkg.tech_message (

1272: USING v_slc_val1;
1273: ELSE
1274: EXIT;
1275: END IF;
1276: fem_engines_pkg.tech_message (
1277: p_severity => c_log_level_1
1278: ,p_module => c_block||'.'||c_proc_name||'.Error Reproceesing Mode'
1279: ,p_msg_text => 'v_data_slc '||v_data_slc||
1280: 'v_member_table_name'||v_member_table_name);

Line 1291: fem_engines_pkg.tech_message (

1287: This validation checks whether the values in GLOBAL_VS_COMBO_DISPLAY_CODE
1288: column of interface table is valid.
1289: -------------------------------------------------------------------------------*/
1290:
1291: fem_engines_pkg.tech_message (
1292: p_severity => c_log_level_1
1293: ,p_module => c_block||'.'||c_proc_name||'.Start of Validation#1'
1294: ,p_msg_text => 'v_data_slc '||v_data_slc||
1295: 'v_member_table_name'||v_member_table_name);

Line 1359: fem_engines_pkg.tech_message (

1355: END IF; -- v_last_row
1356:
1357: END LOOP;
1358:
1359: fem_engines_pkg.tech_message (
1360: p_severity => c_log_level_1
1361: ,p_module => c_block||'.'||c_proc_name||'.Validation#1 - End'
1362: ,p_msg_text => 'v_data_slc '||v_data_slc||
1363: 'v_member_table_name'||v_member_table_name||

Line 1465: fem_engines_pkg.tech_message (

1461: END LOOP;
1462:
1463: CLOSE cv_get_invalid_fin_elems;
1464:
1465: fem_engines_pkg.tech_message (
1466: p_severity => c_log_level_1
1467: ,p_module => c_block||'.'||c_proc_name||'.Validation#2.1'
1468: ,p_msg_text => 'v_data_slc '||v_data_slc||
1469: 'v_member_table_name'||v_member_table_name||

Line 1511: fem_engines_pkg.tech_message (

1507: END LOOP;
1508:
1509: CLOSE cv_get_invalid_fin_elems;
1510:
1511: fem_engines_pkg.tech_message (
1512: p_severity => c_log_level_1
1513: ,p_module => c_block||'.'||c_proc_name||'.Validation#2.2'
1514: ,p_msg_text => 'v_data_slc '||v_data_slc||
1515: 'v_member_table_name'||v_member_table_name||

Line 1587: fem_engines_pkg.tech_message (

1583: END LOOP;
1584:
1585: CLOSE cv_get_invalid_ledgers;
1586:
1587: fem_engines_pkg.tech_message (
1588: p_severity => c_log_level_1
1589: ,p_module=> c_block||'.'||c_proc_name||'.Validation#2.3'
1590: ,p_msg_text => 'v_data_slc '||v_data_slc||
1591: 'v_member_table_name'||v_member_table_name||

Line 1718: fem_engines_pkg.tech_message (

1714: END LOOP; -- FOR LOOP
1715:
1716: COMMIT;
1717:
1718: fem_engines_pkg.tech_message (
1719: p_severity => c_log_level_1
1720: ,p_module=> c_block||'.'||c_proc_name||'.Validation#3'
1721: ,p_msg_text => 'v_data_slc '||v_data_slc||
1722: 'v_member_table_name'||v_member_table_name||

Line 1815: fem_engines_pkg.tech_message (

1811:
1812: -- Get the no:of rows this fetch
1813: v_mbr_last_row := t_status.COUNT;
1814:
1815: fem_engines_pkg.tech_message (
1816: p_severity => c_log_level_1
1817: ,p_module=> c_block||'.'||c_proc_name||'.Validation#3'
1818: ,p_msg_text => 'v_data_slc '||v_data_slc||
1819: 'v_member_table_name'||v_member_table_name||

Line 2176: fem_engines_pkg.tech_message (

2172: END IF; -- Cost Object
2173:
2174: END LOOP; -- 1...v_member_last_row.(j)
2175:
2176: fem_engines_pkg.tech_message (
2177: p_severity => c_log_level_1
2178: ,p_module=> c_block||'.'||c_proc_name||'.Validation#4 - End');
2179:
2180:

Line 2205: fem_engines_pkg.tech_message (

2201: END LOOP;
2202: END LOOP;
2203:
2204:
2205: fem_engines_pkg.tech_message (
2206: p_severity => c_log_level_1
2207: ,p_module=> c_block||'.'||c_proc_name||'.Validation#5 - End');
2208:
2209: ----------------------------------------------------------------------------

Line 2239: fem_engines_pkg.tech_message (

2235: END IF;
2236: END LOOP;
2237:
2238:
2239: fem_engines_pkg.tech_message (
2240: p_severity => c_log_level_1
2241: ,p_module=> c_block||'.'||c_proc_name||'.Validation#6 - End');
2242:
2243: ----------------------------------------------------------------------------

Line 2410: fem_engines_pkg.tech_message (

2406:
2407: CLOSE cv_get_rows;
2408:
2409:
2410: fem_engines_pkg.tech_message (
2411: p_severity => c_log_level_4
2412: ,p_module => c_block||'.'||c_proc_name
2413: ,p_msg_text => 'Dimension'||p_dimension_varchar_label||
2414: 'Data Slice'||v_data_slc||

Line 2475: FEM_ENGINES_PKG.PUT_MESSAGE

2471: t_status.DELETE;
2472:
2473: IF (v_rows_rejected > 0)
2474: THEN
2475: FEM_ENGINES_PKG.PUT_MESSAGE
2476: (p_app_name => 'FEM',
2477: p_msg_name => 'FEM_DATAX_LDR_BAD_DATA_ERR',
2478: p_token1 => 'COUNT',
2479: p_value1 => v_rows_rejected);

Line 2481: fem_engines_pkg.tech_message (

2477: p_msg_name => 'FEM_DATAX_LDR_BAD_DATA_ERR',
2478: p_token1 => 'COUNT',
2479: p_value1 => v_rows_rejected);
2480: v_message := FND_MSG_PUB.GET(p_encoded => c_false);
2481: fem_engines_pkg.tech_message (
2482: p_severity => c_log_level_2
2483: ,p_module => c_block||'.'||c_proc_name
2484: ,p_msg_text =>'FEM_DATAX_LDR_BAD_DATA_ERR');
2485:

Line 2506: fem_engines_pkg.tech_message(

2502:
2503: EXCEPTION
2504: WHEN e_terminate THEN
2505:
2506: fem_engines_pkg.tech_message(
2507: p_severity => c_log_level_4
2508: ,p_module => c_block||'.'||c_proc_name||'Exception');
2509:
2510: IF cv_get_rows%ISOPEN THEN

Line 2533: fem_engines_pkg.tech_message (

2529:
2530: RAISE FEM_DIM_MEMBER_LOADER_PKG.e_main_terminate;
2531:
2532: WHEN OTHERS THEN
2533: fem_engines_pkg.tech_message (
2534: p_severity => c_log_level_4
2535: ,p_module => c_block||'.'||c_proc_name||'.Exception'
2536: ,p_msg_text => 'Dimension'||p_dimension_varchar_label||
2537: 'Code'||SQLCODE||'Err'||SQLERRM);