eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GCS_LEX_MAP_API_PKG dependencies on FND_API

Line 3175: v_init_msg_list := nvl(p_init_msg_list, FND_API.G_FALSE);

3171: BEGIN
3172: module := g_api || '.Create_Map_Functions';
3173: create_func_failure := 'N';
3174:
3175: v_init_msg_list := nvl(p_init_msg_list, FND_API.G_FALSE);
3176:
3177: x_return_status := FND_API.G_RET_STS_SUCCESS;
3178:
3179: IF FND_API.to_boolean(v_init_msg_list) THEN

Line 3177: x_return_status := FND_API.G_RET_STS_SUCCESS;

3173: create_func_failure := 'N';
3174:
3175: v_init_msg_list := nvl(p_init_msg_list, FND_API.G_FALSE);
3176:
3177: x_return_status := FND_API.G_RET_STS_SUCCESS;
3178:
3179: IF FND_API.to_boolean(v_init_msg_list) THEN
3180: FND_MSG_PUB.initialize;
3181: END IF;

Line 3179: IF FND_API.to_boolean(v_init_msg_list) THEN

3175: v_init_msg_list := nvl(p_init_msg_list, FND_API.G_FALSE);
3176:
3177: x_return_status := FND_API.G_RET_STS_SUCCESS;
3178:
3179: IF FND_API.to_boolean(v_init_msg_list) THEN
3180: FND_MSG_PUB.initialize;
3181: END IF;
3182:
3183: idt_name := initial_rule_set_check(p_rule_set_id, 'TRANSFORMATION', 'N');

Line 3205: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false,

3201: IF create_func_failure = 'Y' THEN
3202: raise gcs_lex_func_failure;
3203: END IF;
3204:
3205: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false,
3206: p_count => x_msg_count,
3207: p_data => x_msg_data);
3208: EXCEPTION
3209: WHEN gcs_lex_init_failed THEN

Line 3210: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

3206: p_count => x_msg_count,
3207: p_data => x_msg_data);
3208: EXCEPTION
3209: WHEN gcs_lex_init_failed THEN
3210: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3211: p_count => x_msg_count,
3212: p_data => x_msg_data);
3213: x_return_status := FND_API.G_RET_STS_ERROR;
3214: WHEN gcs_lex_disabled THEN

Line 3213: x_return_status := FND_API.G_RET_STS_ERROR;

3209: WHEN gcs_lex_init_failed THEN
3210: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3211: p_count => x_msg_count,
3212: p_data => x_msg_data);
3213: x_return_status := FND_API.G_RET_STS_ERROR;
3214: WHEN gcs_lex_disabled THEN
3215: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3216: p_count => x_msg_count,
3217: p_data => x_msg_data);

Line 3215: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

3211: p_count => x_msg_count,
3212: p_data => x_msg_data);
3213: x_return_status := FND_API.G_RET_STS_ERROR;
3214: WHEN gcs_lex_disabled THEN
3215: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3216: p_count => x_msg_count,
3217: p_data => x_msg_data);
3218:
3219: -- It is fine to run this for a disabled mapping. It will simply

Line 3221: x_return_status := FND_API.G_RET_STS_SUCCESS;

3217: p_data => x_msg_data);
3218:
3219: -- It is fine to run this for a disabled mapping. It will simply
3220: -- remove the unnecessary rule functions.
3221: x_return_status := FND_API.G_RET_STS_SUCCESS;
3222: WHEN gcs_lex_func_failure THEN
3223: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3224: p_count => x_msg_count,
3225: p_data => x_msg_data);

Line 3223: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

3219: -- It is fine to run this for a disabled mapping. It will simply
3220: -- remove the unnecessary rule functions.
3221: x_return_status := FND_API.G_RET_STS_SUCCESS;
3222: WHEN gcs_lex_func_failure THEN
3223: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3224: p_count => x_msg_count,
3225: p_data => x_msg_data);
3226: x_return_status := FND_API.G_RET_STS_ERROR;
3227: WHEN gcs_lex_applsys_not_found THEN

Line 3226: x_return_status := FND_API.G_RET_STS_ERROR;

3222: WHEN gcs_lex_func_failure THEN
3223: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3224: p_count => x_msg_count,
3225: p_data => x_msg_data);
3226: x_return_status := FND_API.G_RET_STS_ERROR;
3227: WHEN gcs_lex_applsys_not_found THEN
3228: add_simple_failed_msg('GCS_APPLSYS_NOT_FOUND', module, 'N');
3229: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3230: p_count => x_msg_count,

Line 3229: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

3225: p_data => x_msg_data);
3226: x_return_status := FND_API.G_RET_STS_ERROR;
3227: WHEN gcs_lex_applsys_not_found THEN
3228: add_simple_failed_msg('GCS_APPLSYS_NOT_FOUND', module, 'N');
3229: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3230: p_count => x_msg_count,
3231: p_data => x_msg_data);
3232: x_return_status := FND_API.G_RET_STS_ERROR;
3233: WHEN OTHERS THEN

Line 3232: x_return_status := FND_API.G_RET_STS_ERROR;

3228: add_simple_failed_msg('GCS_APPLSYS_NOT_FOUND', module, 'N');
3229: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3230: p_count => x_msg_count,
3231: p_data => x_msg_data);
3232: x_return_status := FND_API.G_RET_STS_ERROR;
3233: WHEN OTHERS THEN
3234: add_id_value_failed_msg(p_rule_set_id, 'GCS_IDT_UNEXPECTED_ERROR',
3235: module, 'N');
3236: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

Line 3236: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

3232: x_return_status := FND_API.G_RET_STS_ERROR;
3233: WHEN OTHERS THEN
3234: add_id_value_failed_msg(p_rule_set_id, 'GCS_IDT_UNEXPECTED_ERROR',
3235: module, 'N');
3236: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3237: p_count => x_msg_count,
3238: p_data => x_msg_data);
3239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3240: END Create_Map_Functions;

Line 3239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3235: module, 'N');
3236: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3237: p_count => x_msg_count,
3238: p_data => x_msg_data);
3239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3240: END Create_Map_Functions;
3241:
3242:
3243: PROCEDURE Apply_Map(

Line 3307: v_init_msg_list := nvl(p_init_msg_list, FND_API.G_FALSE);

3303: BEGIN
3304: module := g_api || '.Apply_Map';
3305: l_api_name := 'Apply_Map';
3306:
3307: v_init_msg_list := nvl(p_init_msg_list, FND_API.G_FALSE);
3308: v_commit := nvl(p_commit, FND_API.G_FALSE);
3309: v_validation_level := nvl(p_validation_level, FND_API.G_VALID_LEVEL_FULL);
3310: v_debug_mode := nvl(p_debug_mode, 'N');
3311:

Line 3308: v_commit := nvl(p_commit, FND_API.G_FALSE);

3304: module := g_api || '.Apply_Map';
3305: l_api_name := 'Apply_Map';
3306:
3307: v_init_msg_list := nvl(p_init_msg_list, FND_API.G_FALSE);
3308: v_commit := nvl(p_commit, FND_API.G_FALSE);
3309: v_validation_level := nvl(p_validation_level, FND_API.G_VALID_LEVEL_FULL);
3310: v_debug_mode := nvl(p_debug_mode, 'N');
3311:
3312: log_file_module_write(module, g_module_enter);

Line 3309: v_validation_level := nvl(p_validation_level, FND_API.G_VALID_LEVEL_FULL);

3305: l_api_name := 'Apply_Map';
3306:
3307: v_init_msg_list := nvl(p_init_msg_list, FND_API.G_FALSE);
3308: v_commit := nvl(p_commit, FND_API.G_FALSE);
3309: v_validation_level := nvl(p_validation_level, FND_API.G_VALID_LEVEL_FULL);
3310: v_debug_mode := nvl(p_debug_mode, 'N');
3311:
3312: log_file_module_write(module, g_module_enter);
3313:

Line 3314: x_return_status := FND_API.G_RET_STS_SUCCESS;

3310: v_debug_mode := nvl(p_debug_mode, 'N');
3311:
3312: log_file_module_write(module, g_module_enter);
3313:
3314: x_return_status := FND_API.G_RET_STS_SUCCESS;
3315:
3316: -- This savepoint is used to roll all the way back if an error occurs
3317: -- during processing of the IDT.
3318: SAVEPOINT gcs_lex_before_mapping;

Line 3320: IF NOT FND_API.compatible_api_call( l_api_version, p_api_version,

3316: -- This savepoint is used to roll all the way back if an error occurs
3317: -- during processing of the IDT.
3318: SAVEPOINT gcs_lex_before_mapping;
3319:
3320: IF NOT FND_API.compatible_api_call( l_api_version, p_api_version,
3321: l_api_name, g_api) THEN
3322: raise FND_API.g_exc_unexpected_error;
3323: END IF;
3324:

Line 3322: raise FND_API.g_exc_unexpected_error;

3318: SAVEPOINT gcs_lex_before_mapping;
3319:
3320: IF NOT FND_API.compatible_api_call( l_api_version, p_api_version,
3321: l_api_name, g_api) THEN
3322: raise FND_API.g_exc_unexpected_error;
3323: END IF;
3324:
3325: IF FND_API.to_boolean(v_init_msg_list) THEN
3326: FND_MSG_PUB.initialize;

Line 3325: IF FND_API.to_boolean(v_init_msg_list) THEN

3321: l_api_name, g_api) THEN
3322: raise FND_API.g_exc_unexpected_error;
3323: END IF;
3324:
3325: IF FND_API.to_boolean(v_init_msg_list) THEN
3326: FND_MSG_PUB.initialize;
3327: END IF;
3328:
3329: idt_name := initial_rule_set_check(p_rule_set_id, 'TRANSFORMATION', 'Y');

Line 3367: IF FND_API.to_boolean(v_commit) THEN

3363: FND_MESSAGE.set_token('NUM_ROWS', num_rows_affected);
3364: FND_MESSAGE.set_token('STG_TBL', p_staging_table_name);
3365: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get);
3366:
3367: IF FND_API.to_boolean(v_commit) THEN
3368: COMMIT;
3369: END IF;
3370:
3371: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false,

Line 3371: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false,

3367: IF FND_API.to_boolean(v_commit) THEN
3368: COMMIT;
3369: END IF;
3370:
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;

Line 3394: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

3390: WHEN gcs_lex_error_column_not_set OR
3391: gcs_lex_init_failed OR
3392: gcs_lex_table_check_failed OR
3393: gcs_lex_filter_error THEN
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;

Line 3397: x_return_status := FND_API.G_RET_STS_ERROR;

3393: gcs_lex_filter_error THEN
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

Line 3404: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

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;
3408: gcs_lex_map_api_pkg.error_table.delete;

Line 3407: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 3412: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

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,
3413: p_count => x_msg_count,
3414: p_data => x_msg_data);
3415: IF error_table.COUNT > 0 THEN
3416: write_header_output(idt_name, p_staging_table_name, filter_text);

Line 3495: x_return_status := FND_API.G_RET_STS_ERROR;

3491: fill_error_column(p_rule_set_id, p_staging_table_name, filter_text);
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,

Line 3499: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

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,
3501: p_data => x_msg_data);
3502: IF error_table.COUNT > 0 THEN
3503: write_header_output(idt_name, p_staging_table_name, filter_text);

Line 3602: x_return_status := FND_API.G_RET_STS_ERROR;

3598: fill_error_column(p_rule_set_id, p_staging_table_name, filter_text);
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',

Line 3608: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

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

Line 3611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3607: module, 'Y');
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;

Line 3648: v_init_msg_list := nvl(p_init_msg_list, FND_API.G_FALSE);

3644: BEGIN
3645: module := g_api || '.Create_Validation_Functions';
3646: create_func_failure := 'N';
3647:
3648: v_init_msg_list := nvl(p_init_msg_list, FND_API.G_FALSE);
3649:
3650: x_return_status := FND_API.G_RET_STS_SUCCESS;
3651:
3652: IF FND_API.to_boolean(v_init_msg_list) THEN

Line 3650: x_return_status := FND_API.G_RET_STS_SUCCESS;

3646: create_func_failure := 'N';
3647:
3648: v_init_msg_list := nvl(p_init_msg_list, FND_API.G_FALSE);
3649:
3650: x_return_status := FND_API.G_RET_STS_SUCCESS;
3651:
3652: IF FND_API.to_boolean(v_init_msg_list) THEN
3653: FND_MSG_PUB.initialize;
3654: END IF;

Line 3652: IF FND_API.to_boolean(v_init_msg_list) THEN

3648: v_init_msg_list := nvl(p_init_msg_list, FND_API.G_FALSE);
3649:
3650: x_return_status := FND_API.G_RET_STS_SUCCESS;
3651:
3652: IF FND_API.to_boolean(v_init_msg_list) THEN
3653: FND_MSG_PUB.initialize;
3654: END IF;
3655:
3656: idt_name := initial_rule_set_check(p_rule_set_id, 'VALIDATION', 'N');

Line 3678: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false,

3674: IF create_func_failure = 'Y' THEN
3675: raise gcs_lex_func_failure;
3676: END IF;
3677:
3678: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false,
3679: p_count => x_msg_count,
3680: p_data => x_msg_data);
3681: EXCEPTION
3682: WHEN gcs_lex_init_failed THEN

Line 3683: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

3679: p_count => x_msg_count,
3680: p_data => x_msg_data);
3681: EXCEPTION
3682: WHEN gcs_lex_init_failed THEN
3683: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3684: p_count => x_msg_count,
3685: p_data => x_msg_data);
3686: x_return_status := FND_API.G_RET_STS_ERROR;
3687: WHEN gcs_lex_disabled THEN

Line 3686: x_return_status := FND_API.G_RET_STS_ERROR;

3682: WHEN gcs_lex_init_failed THEN
3683: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3684: p_count => x_msg_count,
3685: p_data => x_msg_data);
3686: x_return_status := FND_API.G_RET_STS_ERROR;
3687: WHEN gcs_lex_disabled THEN
3688: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3689: p_count => x_msg_count,
3690: p_data => x_msg_data);

Line 3688: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

3684: p_count => x_msg_count,
3685: p_data => x_msg_data);
3686: x_return_status := FND_API.G_RET_STS_ERROR;
3687: WHEN gcs_lex_disabled THEN
3688: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3689: p_count => x_msg_count,
3690: p_data => x_msg_data);
3691:
3692: -- It is fine to run this for a disabled mapping. It will simply

Line 3694: x_return_status := FND_API.G_RET_STS_SUCCESS;

3690: p_data => x_msg_data);
3691:
3692: -- It is fine to run this for a disabled mapping. It will simply
3693: -- remove the unnecessary rule functions.
3694: x_return_status := FND_API.G_RET_STS_SUCCESS;
3695: WHEN gcs_lex_func_failure THEN
3696: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3697: p_count => x_msg_count,
3698: p_data => x_msg_data);

Line 3696: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

3692: -- It is fine to run this for a disabled mapping. It will simply
3693: -- remove the unnecessary rule functions.
3694: x_return_status := FND_API.G_RET_STS_SUCCESS;
3695: WHEN gcs_lex_func_failure THEN
3696: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3697: p_count => x_msg_count,
3698: p_data => x_msg_data);
3699: x_return_status := FND_API.G_RET_STS_ERROR;
3700: WHEN gcs_lex_applsys_not_found THEN

Line 3699: x_return_status := FND_API.G_RET_STS_ERROR;

3695: WHEN gcs_lex_func_failure THEN
3696: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3697: p_count => x_msg_count,
3698: p_data => x_msg_data);
3699: x_return_status := FND_API.G_RET_STS_ERROR;
3700: WHEN gcs_lex_applsys_not_found THEN
3701: add_simple_failed_msg('GCS_APPLSYS_NOT_FOUND', module, 'N');
3702: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3703: p_count => x_msg_count,

Line 3702: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

3698: p_data => x_msg_data);
3699: x_return_status := FND_API.G_RET_STS_ERROR;
3700: WHEN gcs_lex_applsys_not_found THEN
3701: add_simple_failed_msg('GCS_APPLSYS_NOT_FOUND', module, 'N');
3702: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3703: p_count => x_msg_count,
3704: p_data => x_msg_data);
3705: x_return_status := FND_API.G_RET_STS_ERROR;
3706: WHEN OTHERS THEN

Line 3705: x_return_status := FND_API.G_RET_STS_ERROR;

3701: add_simple_failed_msg('GCS_APPLSYS_NOT_FOUND', module, 'N');
3702: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3703: p_count => x_msg_count,
3704: p_data => x_msg_data);
3705: x_return_status := FND_API.G_RET_STS_ERROR;
3706: WHEN OTHERS THEN
3707: add_id_value_failed_msg(p_rule_set_id, 'GCS_IDT_UNEXPECTED_ERROR',
3708: module, 'N');
3709: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

Line 3709: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

3705: x_return_status := FND_API.G_RET_STS_ERROR;
3706: WHEN OTHERS THEN
3707: add_id_value_failed_msg(p_rule_set_id, 'GCS_IDT_UNEXPECTED_ERROR',
3708: module, 'N');
3709: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3710: p_count => x_msg_count,
3711: p_data => x_msg_data);
3712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3713: END Create_Validation_Functions;

Line 3712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3708: module, 'N');
3709: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3710: p_count => x_msg_count,
3711: p_data => x_msg_data);
3712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3713: END Create_Validation_Functions;
3714:
3715:
3716:

Line 3788: v_init_msg_list := nvl(p_init_msg_list, FND_API.G_FALSE);

3784: BEGIN
3785: module := g_api || '.Apply_Validation';
3786: l_api_name := 'Apply_Validation';
3787:
3788: v_init_msg_list := nvl(p_init_msg_list, FND_API.G_FALSE);
3789: v_commit := nvl(p_commit, FND_API.G_FALSE);
3790: v_validation_level := nvl(p_validation_level, FND_API.G_VALID_LEVEL_FULL);
3791: v_debug_mode := nvl(p_debug_mode, 'N');
3792:

Line 3789: v_commit := nvl(p_commit, FND_API.G_FALSE);

3785: module := g_api || '.Apply_Validation';
3786: l_api_name := 'Apply_Validation';
3787:
3788: v_init_msg_list := nvl(p_init_msg_list, FND_API.G_FALSE);
3789: v_commit := nvl(p_commit, FND_API.G_FALSE);
3790: v_validation_level := nvl(p_validation_level, FND_API.G_VALID_LEVEL_FULL);
3791: v_debug_mode := nvl(p_debug_mode, 'N');
3792:
3793: log_file_module_write(module, g_module_enter);

Line 3790: v_validation_level := nvl(p_validation_level, FND_API.G_VALID_LEVEL_FULL);

3786: l_api_name := 'Apply_Validation';
3787:
3788: v_init_msg_list := nvl(p_init_msg_list, FND_API.G_FALSE);
3789: v_commit := nvl(p_commit, FND_API.G_FALSE);
3790: v_validation_level := nvl(p_validation_level, FND_API.G_VALID_LEVEL_FULL);
3791: v_debug_mode := nvl(p_debug_mode, 'N');
3792:
3793: log_file_module_write(module, g_module_enter);
3794:

Line 3795: x_return_status := FND_API.G_RET_STS_SUCCESS;

3791: v_debug_mode := nvl(p_debug_mode, 'N');
3792:
3793: log_file_module_write(module, g_module_enter);
3794:
3795: x_return_status := FND_API.G_RET_STS_SUCCESS;
3796:
3797: IF NOT FND_API.compatible_api_call( l_api_version, p_api_version,
3798: l_api_name, g_api) THEN
3799: raise FND_API.g_exc_unexpected_error;

Line 3797: IF NOT FND_API.compatible_api_call( l_api_version, p_api_version,

3793: log_file_module_write(module, g_module_enter);
3794:
3795: x_return_status := FND_API.G_RET_STS_SUCCESS;
3796:
3797: IF NOT FND_API.compatible_api_call( l_api_version, p_api_version,
3798: l_api_name, g_api) THEN
3799: raise FND_API.g_exc_unexpected_error;
3800: END IF;
3801:

Line 3799: raise FND_API.g_exc_unexpected_error;

3795: x_return_status := FND_API.G_RET_STS_SUCCESS;
3796:
3797: IF NOT FND_API.compatible_api_call( l_api_version, p_api_version,
3798: l_api_name, g_api) THEN
3799: raise FND_API.g_exc_unexpected_error;
3800: END IF;
3801:
3802: IF FND_API.to_boolean(v_init_msg_list) THEN
3803: FND_MSG_PUB.initialize;

Line 3802: IF FND_API.to_boolean(v_init_msg_list) THEN

3798: l_api_name, g_api) THEN
3799: raise FND_API.g_exc_unexpected_error;
3800: END IF;
3801:
3802: IF FND_API.to_boolean(v_init_msg_list) THEN
3803: FND_MSG_PUB.initialize;
3804: END IF;
3805:
3806: idt_name := initial_rule_set_check(p_rule_set_id, 'VALIDATION', 'Y');

Line 3917: FND_API.G_RET_STS_SUCCESS || ''', ''' || FND_API.G_RET_STS_ERROR ||

3913: END LOOP;
3914:
3915: EXECUTE IMMEDIATE
3916: 'SELECT decode(COUNT(*), ' || num_rows_total || ', ''' ||
3917: FND_API.G_RET_STS_SUCCESS || ''', ''' || FND_API.G_RET_STS_ERROR ||
3918: ''') FROM ' || p_staging_table_name || ' WHERE ' || filter_text
3919: INTO x_return_status;
3920:
3921:

Line 3933: IF FND_API.to_boolean(v_commit) THEN

3929: IF v_debug_mode = 'Y' THEN
3930: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get);
3931: END IF;
3932:
3933: IF FND_API.to_boolean(v_commit) THEN
3934: COMMIT;
3935: END IF;
3936:
3937: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false,

Line 3937: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false,

3933: IF FND_API.to_boolean(v_commit) THEN
3934: COMMIT;
3935: END IF;
3936:
3937: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false,
3938: p_count => x_msg_count,
3939: p_data => x_msg_data);
3940:
3941: log_file_module_write(module, g_module_success);

Line 3945: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

3941: log_file_module_write(module, g_module_success);
3942: EXCEPTION
3943: WHEN gcs_lex_vrs_no_rows THEN
3944: add_simple_failed_msg('GCS_IDT_VRS_NO_ROWS', module, 'Y');
3945: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3946: p_count => x_msg_count,
3947: p_data => x_msg_data);
3948: x_return_status := FND_API.G_RET_STS_ERROR;
3949: log_file_module_write(module, g_module_failure);

Line 3948: x_return_status := FND_API.G_RET_STS_ERROR;

3944: add_simple_failed_msg('GCS_IDT_VRS_NO_ROWS', module, 'Y');
3945: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3946: p_count => x_msg_count,
3947: p_data => x_msg_data);
3948: x_return_status := FND_API.G_RET_STS_ERROR;
3949: log_file_module_write(module, g_module_failure);
3950: WHEN gcs_lex_vrs_rule_failed THEN
3951: add_vrs_rule_failed_msg(rule_name,'GCS_IDT_VRS_RULE_FAILED',module,'Y');
3952: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

Line 3952: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

3948: x_return_status := FND_API.G_RET_STS_ERROR;
3949: log_file_module_write(module, g_module_failure);
3950: WHEN gcs_lex_vrs_rule_failed THEN
3951: add_vrs_rule_failed_msg(rule_name,'GCS_IDT_VRS_RULE_FAILED',module,'Y');
3952: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3953: p_count => x_msg_count,
3954: p_data => x_msg_data);
3955: x_return_status := FND_API.G_RET_STS_ERROR;
3956: log_file_module_write(module, g_module_failure);

Line 3955: x_return_status := FND_API.G_RET_STS_ERROR;

3951: add_vrs_rule_failed_msg(rule_name,'GCS_IDT_VRS_RULE_FAILED',module,'Y');
3952: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3953: p_count => x_msg_count,
3954: p_data => x_msg_data);
3955: x_return_status := FND_API.G_RET_STS_ERROR;
3956: log_file_module_write(module, g_module_failure);
3957: WHEN gcs_lex_rule_no_func THEN
3958: add_simple_failed_msg('GCS_IDT_NO_RULE_FUNCTION', module, 'Y');
3959: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

Line 3959: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

3955: x_return_status := FND_API.G_RET_STS_ERROR;
3956: log_file_module_write(module, g_module_failure);
3957: WHEN gcs_lex_rule_no_func THEN
3958: add_simple_failed_msg('GCS_IDT_NO_RULE_FUNCTION', module, 'Y');
3959: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3960: p_count => x_msg_count,
3961: p_data => x_msg_data);
3962: x_return_status := FND_API.G_RET_STS_ERROR;
3963: log_file_module_write(module, g_module_failure);

Line 3962: x_return_status := FND_API.G_RET_STS_ERROR;

3958: add_simple_failed_msg('GCS_IDT_NO_RULE_FUNCTION', module, 'Y');
3959: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3960: p_count => x_msg_count,
3961: p_data => x_msg_data);
3962: x_return_status := FND_API.G_RET_STS_ERROR;
3963: log_file_module_write(module, g_module_failure);
3964: WHEN gcs_lex_error_column_not_set OR
3965: gcs_lex_init_failed OR
3966: gcs_lex_table_check_failed OR

Line 3968: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

3964: WHEN gcs_lex_error_column_not_set OR
3965: gcs_lex_init_failed OR
3966: gcs_lex_table_check_failed OR
3967: gcs_lex_filter_error THEN
3968: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3969: p_count => x_msg_count,
3970: p_data => x_msg_data);
3971: x_return_status := FND_API.G_RET_STS_ERROR;
3972: log_file_module_write(module, g_module_failure);

Line 3971: x_return_status := FND_API.G_RET_STS_ERROR;

3967: gcs_lex_filter_error THEN
3968: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3969: p_count => x_msg_count,
3970: p_data => x_msg_data);
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');

Line 3976: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

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;
3980: log_file_module_write(module, g_module_failure);

Line 3979: x_return_status := FND_API.G_RET_STS_ERROR;

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;
3980: log_file_module_write(module, g_module_failure);
3981: WHEN OTHERS THEN
3982: add_id_value_failed_msg(p_rule_set_id, 'GCS_IDT_UNEXPECTED_ERROR',
3983: module, 'Y');

Line 3984: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

3980: log_file_module_write(module, g_module_failure);
3981: WHEN OTHERS THEN
3982: add_id_value_failed_msg(p_rule_set_id, 'GCS_IDT_UNEXPECTED_ERROR',
3983: module, 'Y');
3984: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3985: p_count => x_msg_count,
3986: p_data => x_msg_data);
3987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3988: log_file_module_write(module, g_module_failure);

Line 3987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3983: module, 'Y');
3984: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3985: p_count => x_msg_count,
3986: p_data => x_msg_data);
3987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3988: log_file_module_write(module, g_module_failure);
3989: END Apply_Validation;
3990:
3991: