887: FROM fem_ld_dim_requests_gt)
888: LOOP
889: IF dim_rec.request_id > 0 THEN
890: IF dim_rec.status = 'Y' THEN
891: fnd_message.set_name('FEM','FEM_DLLDR_DIMENSION_LOADED');
892: fnd_message.set_token('REQUEST_ID',dim_rec.request_id);
893: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);
894: ELSE
895: fnd_message.set_name('FEM','FEM_DLLDR_DIMENSION_ERR');
888: LOOP
889: IF dim_rec.request_id > 0 THEN
890: IF dim_rec.status = 'Y' THEN
891: fnd_message.set_name('FEM','FEM_DLLDR_DIMENSION_LOADED');
892: fnd_message.set_token('REQUEST_ID',dim_rec.request_id);
893: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);
894: ELSE
895: fnd_message.set_name('FEM','FEM_DLLDR_DIMENSION_ERR');
896: fnd_message.set_token('REQUEST_ID',dim_rec.request_id);
889: IF dim_rec.request_id > 0 THEN
890: IF dim_rec.status = 'Y' THEN
891: fnd_message.set_name('FEM','FEM_DLLDR_DIMENSION_LOADED');
892: fnd_message.set_token('REQUEST_ID',dim_rec.request_id);
893: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);
894: ELSE
895: fnd_message.set_name('FEM','FEM_DLLDR_DIMENSION_ERR');
896: fnd_message.set_token('REQUEST_ID',dim_rec.request_id);
897: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);
891: fnd_message.set_name('FEM','FEM_DLLDR_DIMENSION_LOADED');
892: fnd_message.set_token('REQUEST_ID',dim_rec.request_id);
893: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);
894: ELSE
895: fnd_message.set_name('FEM','FEM_DLLDR_DIMENSION_ERR');
896: fnd_message.set_token('REQUEST_ID',dim_rec.request_id);
897: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);
898: END IF;
899: ELSIF dim_rec.request_id < 0 THEN
892: fnd_message.set_token('REQUEST_ID',dim_rec.request_id);
893: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);
894: ELSE
895: fnd_message.set_name('FEM','FEM_DLLDR_DIMENSION_ERR');
896: fnd_message.set_token('REQUEST_ID',dim_rec.request_id);
897: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);
898: END IF;
899: ELSIF dim_rec.request_id < 0 THEN
900: fnd_message.set_name('FEM', 'FEM_DLLDR_DIMENSION_NO_DATA');
893: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);
894: ELSE
895: fnd_message.set_name('FEM','FEM_DLLDR_DIMENSION_ERR');
896: fnd_message.set_token('REQUEST_ID',dim_rec.request_id);
897: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);
898: END IF;
899: ELSIF dim_rec.request_id < 0 THEN
900: fnd_message.set_name('FEM', 'FEM_DLLDR_DIMENSION_NO_DATA');
901: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);
896: fnd_message.set_token('REQUEST_ID',dim_rec.request_id);
897: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);
898: END IF;
899: ELSIF dim_rec.request_id < 0 THEN
900: fnd_message.set_name('FEM', 'FEM_DLLDR_DIMENSION_NO_DATA');
901: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);
902: ELSE
903: fnd_message.set_name('FEM', 'FEM_DLLDR_DIM_CONC_PGM_ERR');
904: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);
897: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);
898: END IF;
899: ELSIF dim_rec.request_id < 0 THEN
900: fnd_message.set_name('FEM', 'FEM_DLLDR_DIMENSION_NO_DATA');
901: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);
902: ELSE
903: fnd_message.set_name('FEM', 'FEM_DLLDR_DIM_CONC_PGM_ERR');
904: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);
905: END IF;
899: ELSIF dim_rec.request_id < 0 THEN
900: fnd_message.set_name('FEM', 'FEM_DLLDR_DIMENSION_NO_DATA');
901: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);
902: ELSE
903: fnd_message.set_name('FEM', 'FEM_DLLDR_DIM_CONC_PGM_ERR');
904: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);
905: END IF;
906:
907: fem_data_loader_pkg.trace('MESSAGE');
900: fnd_message.set_name('FEM', 'FEM_DLLDR_DIMENSION_NO_DATA');
901: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);
902: ELSE
903: fnd_message.set_name('FEM', 'FEM_DLLDR_DIM_CONC_PGM_ERR');
904: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);
905: END IF;
906:
907: fem_data_loader_pkg.trace('MESSAGE');
908:
971: l_row_exists := TRUE;
972:
973: IF hier_rec.request_id > 0 THEN
974: IF hier_rec.status = 'Y' THEN
975: fnd_message.set_name('FEM','FEM_DLLDR_HIERARCHY_LOADED');
976: fnd_message.set_token('REQUEST_ID',hier_rec.request_id);
977: fnd_message.set_token('HIERARCHY',hier_rec.hierarchy_object_name || '.' ||
978: hier_rec.hier_obj_def_display_name);
979: fnd_message.set_token('DIM_LABEL',gs_hier_dim_label_tab(i));
972:
973: IF hier_rec.request_id > 0 THEN
974: IF hier_rec.status = 'Y' THEN
975: fnd_message.set_name('FEM','FEM_DLLDR_HIERARCHY_LOADED');
976: fnd_message.set_token('REQUEST_ID',hier_rec.request_id);
977: fnd_message.set_token('HIERARCHY',hier_rec.hierarchy_object_name || '.' ||
978: hier_rec.hier_obj_def_display_name);
979: fnd_message.set_token('DIM_LABEL',gs_hier_dim_label_tab(i));
980: ELSE
973: IF hier_rec.request_id > 0 THEN
974: IF hier_rec.status = 'Y' THEN
975: fnd_message.set_name('FEM','FEM_DLLDR_HIERARCHY_LOADED');
976: fnd_message.set_token('REQUEST_ID',hier_rec.request_id);
977: fnd_message.set_token('HIERARCHY',hier_rec.hierarchy_object_name || '.' ||
978: hier_rec.hier_obj_def_display_name);
979: fnd_message.set_token('DIM_LABEL',gs_hier_dim_label_tab(i));
980: ELSE
981: fnd_message.set_name('FEM','FEM_DLLDR_HIERARCHY_ERR');
975: fnd_message.set_name('FEM','FEM_DLLDR_HIERARCHY_LOADED');
976: fnd_message.set_token('REQUEST_ID',hier_rec.request_id);
977: fnd_message.set_token('HIERARCHY',hier_rec.hierarchy_object_name || '.' ||
978: hier_rec.hier_obj_def_display_name);
979: fnd_message.set_token('DIM_LABEL',gs_hier_dim_label_tab(i));
980: ELSE
981: fnd_message.set_name('FEM','FEM_DLLDR_HIERARCHY_ERR');
982: fnd_message.set_token('REQUEST_ID',hier_rec.request_id);
983: fnd_message.set_token('HIERARCHY',hier_rec.hierarchy_object_name || '.' ||
977: fnd_message.set_token('HIERARCHY',hier_rec.hierarchy_object_name || '.' ||
978: hier_rec.hier_obj_def_display_name);
979: fnd_message.set_token('DIM_LABEL',gs_hier_dim_label_tab(i));
980: ELSE
981: fnd_message.set_name('FEM','FEM_DLLDR_HIERARCHY_ERR');
982: fnd_message.set_token('REQUEST_ID',hier_rec.request_id);
983: fnd_message.set_token('HIERARCHY',hier_rec.hierarchy_object_name || '.' ||
984: hier_rec.hier_obj_def_display_name);
985: fnd_message.set_token('DIM_LABEL',gs_hier_dim_label_tab(i));
978: hier_rec.hier_obj_def_display_name);
979: fnd_message.set_token('DIM_LABEL',gs_hier_dim_label_tab(i));
980: ELSE
981: fnd_message.set_name('FEM','FEM_DLLDR_HIERARCHY_ERR');
982: fnd_message.set_token('REQUEST_ID',hier_rec.request_id);
983: fnd_message.set_token('HIERARCHY',hier_rec.hierarchy_object_name || '.' ||
984: hier_rec.hier_obj_def_display_name);
985: fnd_message.set_token('DIM_LABEL',gs_hier_dim_label_tab(i));
986: END IF;
979: fnd_message.set_token('DIM_LABEL',gs_hier_dim_label_tab(i));
980: ELSE
981: fnd_message.set_name('FEM','FEM_DLLDR_HIERARCHY_ERR');
982: fnd_message.set_token('REQUEST_ID',hier_rec.request_id);
983: fnd_message.set_token('HIERARCHY',hier_rec.hierarchy_object_name || '.' ||
984: hier_rec.hier_obj_def_display_name);
985: fnd_message.set_token('DIM_LABEL',gs_hier_dim_label_tab(i));
986: END IF;
987: ELSE
981: fnd_message.set_name('FEM','FEM_DLLDR_HIERARCHY_ERR');
982: fnd_message.set_token('REQUEST_ID',hier_rec.request_id);
983: fnd_message.set_token('HIERARCHY',hier_rec.hierarchy_object_name || '.' ||
984: hier_rec.hier_obj_def_display_name);
985: fnd_message.set_token('DIM_LABEL',gs_hier_dim_label_tab(i));
986: END IF;
987: ELSE
988: fnd_message.set_name('FEM', 'FEM_DLLDR_HIER_CONC_PGM_ERR');
989: fnd_message.set_token('HIERARCHY',hier_rec.hierarchy_object_name || '.' ||
984: hier_rec.hier_obj_def_display_name);
985: fnd_message.set_token('DIM_LABEL',gs_hier_dim_label_tab(i));
986: END IF;
987: ELSE
988: fnd_message.set_name('FEM', 'FEM_DLLDR_HIER_CONC_PGM_ERR');
989: fnd_message.set_token('HIERARCHY',hier_rec.hierarchy_object_name || '.' ||
990: hier_rec.hier_obj_def_display_name);
991: fnd_message.set_token('DIM_LABEL',gs_hier_dim_label_tab(i));
992: END IF;
985: fnd_message.set_token('DIM_LABEL',gs_hier_dim_label_tab(i));
986: END IF;
987: ELSE
988: fnd_message.set_name('FEM', 'FEM_DLLDR_HIER_CONC_PGM_ERR');
989: fnd_message.set_token('HIERARCHY',hier_rec.hierarchy_object_name || '.' ||
990: hier_rec.hier_obj_def_display_name);
991: fnd_message.set_token('DIM_LABEL',gs_hier_dim_label_tab(i));
992: END IF;
993:
987: ELSE
988: fnd_message.set_name('FEM', 'FEM_DLLDR_HIER_CONC_PGM_ERR');
989: fnd_message.set_token('HIERARCHY',hier_rec.hierarchy_object_name || '.' ||
990: hier_rec.hier_obj_def_display_name);
991: fnd_message.set_token('DIM_LABEL',gs_hier_dim_label_tab(i));
992: END IF;
993:
994: END LOOP; -- hier_rec
995:
995:
996: IF l_row_exists THEN
997: l_row_exists := FALSE;
998: ELSE
999: fnd_message.set_name('FEM', 'FEM_DLLDR_HIER_NO_DATA');
1000:
1001: IF gs_hier_obj_id_tab(i) = -1 AND gs_hier_obj_def_id_tab(i) = -1 THEN
1002: l_hier_str := g_all_str || '.' || g_all_str;
1003: ELSIF gs_hier_obj_id_tab(i) <> -1 AND gs_hier_obj_def_id_tab(i) = -1 THEN
1023:
1024: l_hier_str := l_hier_name || '.' || l_hier_def_name;
1025: END IF; -- gs_hier_obj_id_tab(i)
1026:
1027: fnd_message.set_token('HIERARCHY',l_hier_str);
1028: fnd_message.set_token('DIM_LABEL',gs_hier_dim_label_tab(i));
1029: END IF; -- l_row_exists
1030:
1031: fem_data_loader_pkg.trace('MESSAGE');
1024: l_hier_str := l_hier_name || '.' || l_hier_def_name;
1025: END IF; -- gs_hier_obj_id_tab(i)
1026:
1027: fnd_message.set_token('HIERARCHY',l_hier_str);
1028: fnd_message.set_token('DIM_LABEL',gs_hier_dim_label_tab(i));
1029: END IF; -- l_row_exists
1030:
1031: fem_data_loader_pkg.trace('MESSAGE');
1032:
1060:
1061: g_load_dimensions := FALSE;
1062: g_load_hierarchies := FALSE;
1063:
1064: fnd_message.set_name('FEM', 'FEM_ALL_TXT');
1065: g_all_str := fnd_message.get;
1066:
1067:
1068: DELETE fem_ld_dim_requests_gt;
1061: g_load_dimensions := FALSE;
1062: g_load_hierarchies := FALSE;
1063:
1064: fnd_message.set_name('FEM', 'FEM_ALL_TXT');
1065: g_all_str := fnd_message.get;
1066:
1067:
1068: DELETE fem_ld_dim_requests_gt;
1069: