DBA Data[Home] [Help]

APPS.GCS_LEX_MAP_API_PKG dependencies on GCS_LEX_MAP_API_PKG

Line 1: PACKAGE BODY GCS_LEX_MAP_API_PKG as

1: PACKAGE BODY GCS_LEX_MAP_API_PKG as
2: /* $Header: gcslmapb.pls 120.1 2005/10/30 05:19:00 appldev noship $ */
3:
4: --
5: -- PRIVATE GLOBAL VARIABLES

Line 17: g_api CONSTANT VARCHAR2(30) := 'gcs.plsql.GCS_LEX_MAP_API_PKG';

13: -- to hold the derivation number in the materialized function.
14: g_deriv_num CONSTANT VARCHAR2(10) := 'gcs_drv_';
15:
16: -- Name of this API package.
17: g_api CONSTANT VARCHAR2(30) := 'gcs.plsql.GCS_LEX_MAP_API_PKG';
18:
19: -- Action types for writing module information to the log file. Used for
20: -- the procedure log_file_module_write.
21: g_module_enter CONSTANT VARCHAR2(1) := 'E';

Line 2314: 'declare error_info GCS_LEX_MAP_API_PKG.error_record_type;' ||

2310: func_name :='gcs_lex_get_' || rule_set_id || '_' || rule_id;
2311: default_condition_made := 'N';
2312:
2313: exc_txt1 :=
2314: 'declare error_info GCS_LEX_MAP_API_PKG.error_record_type;' ||
2315: 'begin error_info.rule_id := ' || rule_id || ';' ||
2316: 'error_info.deriv_num := ' || g_deriv_num || ';' ||
2317: 'error_info.row_id := ' || func_name || '.row_id;' ||
2318: 'error_info.error_code := ''';

Line 2322: 'GCS_LEX_MAP_API_PKG.error_table(GCS_LEX_MAP_API_PKG' ||

2318: 'error_info.error_code := ''';
2319:
2320: exc_txt2 :=
2321: ''';' ||
2322: 'GCS_LEX_MAP_API_PKG.error_table(GCS_LEX_MAP_API_PKG' ||
2323: '.error_table.COUNT+1):=error_info;' ||
2324: 'end;';
2325:
2326: validation_check(rule_id, 'N');

Line 3070: 'FND_LOG.string(FND_LOG.LEVEL_ERROR, ''GCS_LEX_MAP_API_PKG.' || func_name ||

3066: AND d.rule_id = r.rule_id;
3067:
3068: log_error_text :=
3069: 'IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN ' ||
3070: 'FND_LOG.string(FND_LOG.LEVEL_ERROR, ''GCS_LEX_MAP_API_PKG.' || func_name ||
3071: ''', ''' || REPLACE(error_message, '''', '''''') || '''); END IF; ';
3072:
3073: -- first get the function header information
3074: func_body := 'CREATE OR REPLACE FUNCTION ' || func_name || '(' ||

Line 3375: gcs_lex_map_api_pkg.error_table.delete;

3371: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false,
3372: p_count => x_msg_count,
3373: p_data => x_msg_data);
3374:
3375: gcs_lex_map_api_pkg.error_table.delete;
3376:
3377: log_file_module_write(module, g_module_success);
3378:
3379: write_header_output(idt_name, p_staging_table_name, filter_text);

Line 3398: gcs_lex_map_api_pkg.error_table.delete;

3394: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3395: p_count => x_msg_count,
3396: p_data => x_msg_data);
3397: x_return_status := FND_API.G_RET_STS_ERROR;
3398: gcs_lex_map_api_pkg.error_table.delete;
3399: log_file_module_write(module, g_module_failure);
3400: ROLLBACK TO gcs_lex_before_mapping;
3401: WHEN gcs_lex_disabled THEN
3402: add_idt_failed_msg(p_rule_set_id, 'GCS_IDT_DISABLED',

Line 3403: 'GCS_LEX_MAP_API_PKG.Initial_Rule_Set_Check', 'Y');

3399: log_file_module_write(module, g_module_failure);
3400: ROLLBACK TO gcs_lex_before_mapping;
3401: WHEN gcs_lex_disabled THEN
3402: add_idt_failed_msg(p_rule_set_id, 'GCS_IDT_DISABLED',
3403: 'GCS_LEX_MAP_API_PKG.Initial_Rule_Set_Check', 'Y');
3404: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3405: p_count => x_msg_count,
3406: p_data => x_msg_data);
3407: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3408: gcs_lex_map_api_pkg.error_table.delete;

3404: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3405: p_count => x_msg_count,
3406: p_data => x_msg_data);
3407: x_return_status := FND_API.G_RET_STS_ERROR;
3408: gcs_lex_map_api_pkg.error_table.delete;
3409: log_file_module_write(module, g_module_failure);
3410: ROLLBACK TO gcs_lex_before_mapping;
3411: WHEN gcs_lex_validation_failed THEN
3412: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

Line 3496: gcs_lex_map_api_pkg.error_table.delete;

3492: ELSE
3493: ROLLBACK TO gcs_lex_before_mapping;
3494: END IF;
3495: x_return_status := FND_API.G_RET_STS_ERROR;
3496: gcs_lex_map_api_pkg.error_table.delete;
3497: log_file_module_write(module, g_module_failure);
3498: WHEN gcs_lex_stage_failed THEN
3499: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3500: p_count => x_msg_count,

Line 3603: gcs_lex_map_api_pkg.error_table.delete;

3599: ELSE
3600: ROLLBACK TO gcs_lex_before_mapping;
3601: END IF;
3602: x_return_status := FND_API.G_RET_STS_ERROR;
3603: gcs_lex_map_api_pkg.error_table.delete;
3604: log_file_module_write(module, g_module_failure);
3605: WHEN OTHERS THEN
3606: add_id_value_failed_msg(p_rule_set_id, 'GCS_IDT_UNEXPECTED_ERROR',
3607: module, 'Y');

Line 3612: gcs_lex_map_api_pkg.error_table.delete;

3608: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3609: p_count => x_msg_count,
3610: p_data => x_msg_data);
3611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3612: gcs_lex_map_api_pkg.error_table.delete;
3613: log_file_module_write(module, g_module_failure);
3614: ROLLBACK TO gcs_lex_before_mapping;
3615: END Apply_Map;
3616:

Line 3975: 'GCS_LEX_MAP_API_PKG.Initial_Rule_Set_Check', 'Y');

3971: x_return_status := FND_API.G_RET_STS_ERROR;
3972: log_file_module_write(module, g_module_failure);
3973: WHEN gcs_lex_disabled THEN
3974: add_idt_failed_msg(p_rule_set_id, 'GCS_IDT_DISABLED',
3975: 'GCS_LEX_MAP_API_PKG.Initial_Rule_Set_Check', 'Y');
3976: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3977: p_count => x_msg_count,
3978: p_data => x_msg_data);
3979: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4039: END GCS_LEX_MAP_API_PKG;

4035:
4036: END After_FEM_Refresh;
4037:
4038:
4039: END GCS_LEX_MAP_API_PKG;