DBA Data[Home] [Help]

APPS.FEM_DIM_HIER_LOADER_PKG dependencies on FND_MESSAGE

Line 891: fnd_message.set_name('FEM','FEM_DLLDR_DIMENSION_LOADED');

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');

Line 892: fnd_message.set_token('REQUEST_ID',dim_rec.request_id);

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);

Line 893: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);

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);

Line 895: fnd_message.set_name('FEM','FEM_DLLDR_DIMENSION_ERR');

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

Line 896: fnd_message.set_token('REQUEST_ID',dim_rec.request_id);

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');

Line 897: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);

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);

Line 900: fnd_message.set_name('FEM', 'FEM_DLLDR_DIMENSION_NO_DATA');

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);

Line 901: 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;

Line 903: fnd_message.set_name('FEM', 'FEM_DLLDR_DIM_CONC_PGM_ERR');

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');

Line 904: fnd_message.set_token('DIM_LABEL',dim_rec.dimension_varchar_label);

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:

Line 975: fnd_message.set_name('FEM','FEM_DLLDR_HIERARCHY_LOADED');

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));

Line 976: fnd_message.set_token('REQUEST_ID',hier_rec.request_id);

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

Line 977: fnd_message.set_token('HIERARCHY',hier_rec.hierarchy_object_name || '.' ||

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');

Line 979: fnd_message.set_token('DIM_LABEL',gs_hier_dim_label_tab(i));

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 || '.' ||

Line 981: fnd_message.set_name('FEM','FEM_DLLDR_HIERARCHY_ERR');

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));

Line 982: fnd_message.set_token('REQUEST_ID',hier_rec.request_id);

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;

Line 983: fnd_message.set_token('HIERARCHY',hier_rec.hierarchy_object_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;
987: ELSE

Line 985: fnd_message.set_token('DIM_LABEL',gs_hier_dim_label_tab(i));

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 || '.' ||

Line 988: fnd_message.set_name('FEM', 'FEM_DLLDR_HIER_CONC_PGM_ERR');

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;

Line 989: fnd_message.set_token('HIERARCHY',hier_rec.hierarchy_object_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;
993:

Line 991: fnd_message.set_token('DIM_LABEL',gs_hier_dim_label_tab(i));

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:

Line 999: fnd_message.set_name('FEM', 'FEM_DLLDR_HIER_NO_DATA');

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

Line 1027: fnd_message.set_token('HIERARCHY',l_hier_str);

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');

Line 1028: fnd_message.set_token('DIM_LABEL',gs_hier_dim_label_tab(i));

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:

Line 1064: fnd_message.set_name('FEM', 'FEM_ALL_TXT');

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;

Line 1065: g_all_str := fnd_message.get;

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: