DBA Data[Home] [Help]

APPS.GCS_WEBADI_PKG dependencies on FND_MESSAGE

Line 1141: --fnd_message.set_name('GCS', 'GCS_AD_TB_UNEXPECTED_ERR');

1137: EXCEPTION
1138: WHEN OTHERS THEN
1139: ROLLBACK;
1140: --Bugfix 5052607: Commented calling WF_CORE APIs and setting message name
1141: --fnd_message.set_name('GCS', 'GCS_AD_TB_UNEXPECTED_ERR');
1142:
1143: -- Write the appropriate information to the execution report
1144: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1145: fnd_log.STRING(fnd_log.level_error,

Line 1399: FND_MESSAGE.set_name( 'GCS', 'GCS_DM_IMPORT_FEM_LDR_ERR' );

1395: l_member_attr_table_name
1396: FROM fem_xdim_dimensions fxd
1397: WHERE fxd.dimension_id = g_dimension_info(p_dimension_varchar_label).dimension_id ;
1398:
1399: FND_MESSAGE.set_name( 'GCS', 'GCS_DM_IMPORT_FEM_LDR_ERR' );
1400: FND_MESSAGE.set_token( 'DIM_B_TABLE' , g_dimension_info(p_dimension_varchar_label).b_table_name );
1401: FND_MESSAGE.set_token( 'DIM_TL_TABLE' , l_member_tl_table_name);
1402: FND_MESSAGE.set_token( 'DIM_ATTR_TABLE', l_member_attr_table_name );
1403:

Line 1400: FND_MESSAGE.set_token( 'DIM_B_TABLE' , g_dimension_info(p_dimension_varchar_label).b_table_name );

1396: FROM fem_xdim_dimensions fxd
1397: WHERE fxd.dimension_id = g_dimension_info(p_dimension_varchar_label).dimension_id ;
1398:
1399: FND_MESSAGE.set_name( 'GCS', 'GCS_DM_IMPORT_FEM_LDR_ERR' );
1400: FND_MESSAGE.set_token( 'DIM_B_TABLE' , g_dimension_info(p_dimension_varchar_label).b_table_name );
1401: FND_MESSAGE.set_token( 'DIM_TL_TABLE' , l_member_tl_table_name);
1402: FND_MESSAGE.set_token( 'DIM_ATTR_TABLE', l_member_attr_table_name );
1403:
1404: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< Beginning of Error >>>>');

Line 1401: FND_MESSAGE.set_token( 'DIM_TL_TABLE' , l_member_tl_table_name);

1397: WHERE fxd.dimension_id = g_dimension_info(p_dimension_varchar_label).dimension_id ;
1398:
1399: FND_MESSAGE.set_name( 'GCS', 'GCS_DM_IMPORT_FEM_LDR_ERR' );
1400: FND_MESSAGE.set_token( 'DIM_B_TABLE' , g_dimension_info(p_dimension_varchar_label).b_table_name );
1401: FND_MESSAGE.set_token( 'DIM_TL_TABLE' , l_member_tl_table_name);
1402: FND_MESSAGE.set_token( 'DIM_ATTR_TABLE', l_member_attr_table_name );
1403:
1404: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< Beginning of Error >>>>');
1405: FND_FILE.NEW_LINE(FND_FILE.LOG);

Line 1402: FND_MESSAGE.set_token( 'DIM_ATTR_TABLE', l_member_attr_table_name );

1398:
1399: FND_MESSAGE.set_name( 'GCS', 'GCS_DM_IMPORT_FEM_LDR_ERR' );
1400: FND_MESSAGE.set_token( 'DIM_B_TABLE' , g_dimension_info(p_dimension_varchar_label).b_table_name );
1401: FND_MESSAGE.set_token( 'DIM_TL_TABLE' , l_member_tl_table_name);
1402: FND_MESSAGE.set_token( 'DIM_ATTR_TABLE', l_member_attr_table_name );
1403:
1404: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< Beginning of Error >>>>');
1405: FND_FILE.NEW_LINE(FND_FILE.LOG);
1406: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get );

Line 1406: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get );

1402: FND_MESSAGE.set_token( 'DIM_ATTR_TABLE', l_member_attr_table_name );
1403:
1404: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< Beginning of Error >>>>');
1405: FND_FILE.NEW_LINE(FND_FILE.LOG);
1406: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get );
1407: FND_FILE.NEW_LINE(FND_FILE.LOG);
1408: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< End of Error >>>>');
1409: FND_FILE.NEW_LINE(FND_FILE.LOG);
1410:

Line 1413: g_pkg_name || '.' || l_api_name, FND_MESSAGE.get );

1409: FND_FILE.NEW_LINE(FND_FILE.LOG);
1410:
1411: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1412: fnd_log.STRING(fnd_log.level_procedure,
1413: g_pkg_name || '.' || l_api_name, FND_MESSAGE.get );
1414: END IF;
1415:
1416: ELSE
1417:

Line 1430: FND_MESSAGE.set_name( 'GCS', 'GCS_DM_IMPORT_DUP_VAL_ERR' );

1426: -- Bug Fix : 5232709 , Start
1427: -- Catch the Unique Constraint Validation exception on the interface tables and display the error message.
1428: WHEN DUP_VAL_ON_INDEX THEN
1429: ROLLBACK TO dm_import_start;
1430: FND_MESSAGE.set_name( 'GCS', 'GCS_DM_IMPORT_DUP_VAL_ERR' );
1431: FND_MESSAGE.set_token( 'DIM_B_TABLE' , g_dimension_info(p_dimension_varchar_label).b_t_table_name );
1432: FND_MESSAGE.set_token( 'DIM_TL_TABLE' , g_dimension_info(p_dimension_varchar_label).tl_t_table_name );
1433: FND_MESSAGE.set_token( 'DIM_ATTR_TABLE' ,g_dimension_info(p_dimension_varchar_label).attr_t_table_name );
1434:

Line 1431: FND_MESSAGE.set_token( 'DIM_B_TABLE' , g_dimension_info(p_dimension_varchar_label).b_t_table_name );

1427: -- Catch the Unique Constraint Validation exception on the interface tables and display the error message.
1428: WHEN DUP_VAL_ON_INDEX THEN
1429: ROLLBACK TO dm_import_start;
1430: FND_MESSAGE.set_name( 'GCS', 'GCS_DM_IMPORT_DUP_VAL_ERR' );
1431: FND_MESSAGE.set_token( 'DIM_B_TABLE' , g_dimension_info(p_dimension_varchar_label).b_t_table_name );
1432: FND_MESSAGE.set_token( 'DIM_TL_TABLE' , g_dimension_info(p_dimension_varchar_label).tl_t_table_name );
1433: FND_MESSAGE.set_token( 'DIM_ATTR_TABLE' ,g_dimension_info(p_dimension_varchar_label).attr_t_table_name );
1434:
1435: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< Beginning of Error >>>>');

Line 1432: FND_MESSAGE.set_token( 'DIM_TL_TABLE' , g_dimension_info(p_dimension_varchar_label).tl_t_table_name );

1428: WHEN DUP_VAL_ON_INDEX THEN
1429: ROLLBACK TO dm_import_start;
1430: FND_MESSAGE.set_name( 'GCS', 'GCS_DM_IMPORT_DUP_VAL_ERR' );
1431: FND_MESSAGE.set_token( 'DIM_B_TABLE' , g_dimension_info(p_dimension_varchar_label).b_t_table_name );
1432: FND_MESSAGE.set_token( 'DIM_TL_TABLE' , g_dimension_info(p_dimension_varchar_label).tl_t_table_name );
1433: FND_MESSAGE.set_token( 'DIM_ATTR_TABLE' ,g_dimension_info(p_dimension_varchar_label).attr_t_table_name );
1434:
1435: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< Beginning of Error >>>>');
1436: FND_FILE.NEW_LINE(FND_FILE.LOG);

Line 1433: FND_MESSAGE.set_token( 'DIM_ATTR_TABLE' ,g_dimension_info(p_dimension_varchar_label).attr_t_table_name );

1429: ROLLBACK TO dm_import_start;
1430: FND_MESSAGE.set_name( 'GCS', 'GCS_DM_IMPORT_DUP_VAL_ERR' );
1431: FND_MESSAGE.set_token( 'DIM_B_TABLE' , g_dimension_info(p_dimension_varchar_label).b_t_table_name );
1432: FND_MESSAGE.set_token( 'DIM_TL_TABLE' , g_dimension_info(p_dimension_varchar_label).tl_t_table_name );
1433: FND_MESSAGE.set_token( 'DIM_ATTR_TABLE' ,g_dimension_info(p_dimension_varchar_label).attr_t_table_name );
1434:
1435: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< Beginning of Error >>>>');
1436: FND_FILE.NEW_LINE(FND_FILE.LOG);
1437: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get );

Line 1437: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get );

1433: FND_MESSAGE.set_token( 'DIM_ATTR_TABLE' ,g_dimension_info(p_dimension_varchar_label).attr_t_table_name );
1434:
1435: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< Beginning of Error >>>>');
1436: FND_FILE.NEW_LINE(FND_FILE.LOG);
1437: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get );
1438: FND_FILE.NEW_LINE(FND_FILE.LOG);
1439: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< End of Error >>>>');
1440: FND_FILE.NEW_LINE(FND_FILE.LOG);
1441: