DBA Data[Home] [Help]

APPS.GCS_LEX_MAP_API_PKG dependencies on FND_MSG_PUB

Line 373: FND_MSG_PUB.add;

369: FND_MESSAGE.set_encoded(encoded_message);
370: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get);
371: FND_MESSAGE.set_encoded(encoded_message);
372: END IF;
373: FND_MSG_PUB.add;
374: END Write_To_Log;
375:
376: --
377: -- Procedure

Line 3180: FND_MSG_PUB.initialize;

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

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 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 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 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 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 3326: FND_MSG_PUB.initialize;

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');
3330: staging_table_check(p_staging_table_name, p_rule_set_id);

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 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 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 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 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 3653: FND_MSG_PUB.initialize;

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

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 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 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 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 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 3803: FND_MSG_PUB.initialize;

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');
3807: staging_table_check(p_staging_table_name, p_rule_set_id);

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