DBA Data[Home] [Help]

APPS.ICX_CAT_SQE_PVT dependencies on ICX_POR_FAILED_LINE_MESSAGES

Line 953: INSERT INTO icx_por_failed_line_messages

949: l_err_loc := 700;
950: l_token_list := 'ZONE_NAMES:' || l_errored_zone_name_list;
951:
952: l_err_loc := 800;
953: INSERT INTO icx_por_failed_line_messages
954: (job_number, descriptor_key, message_name, token_list, line_number, request_id, program_id,
955: program_application_id, program_login_id)
956: VALUES (l_request_id, 'OTHER', 'ICX_CAT_CANNOT_UPDATE_CZS_ERR', l_token_list, 1, l_request_id,
957: fnd_global.conc_program_id, fnd_global.prog_appl_id, fnd_global.conc_login_id);

Line 985: INSERT INTO icx_por_failed_line_messages

981:
982: -- update the job status to error
983: ICX_CAT_SCHEMA_UPLOAD_PVT.update_job_status(l_request_id, 'ERROR');
984:
985: INSERT INTO icx_por_failed_line_messages
986: (job_number, descriptor_key, message_name, token_list, line_number, request_id, program_id,
987: program_application_id, program_login_id)
988: VALUES (l_request_id, 'OTHER', 'ICX_CAT_HIER_UNEXPECTED_ERR', l_token_list, 1, l_request_id,
989: fnd_global.conc_program_id, fnd_global.prog_appl_id, fnd_global.conc_login_id);

Line 1031: INSERT INTO icx_por_failed_line_messages

1027: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1028: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
1029: END IF;
1030: l_err_loc := 800;
1031: INSERT INTO icx_por_failed_line_messages
1032: (job_number, descriptor_key, message_name, token_list, line_number, request_id, program_id,
1033: program_application_id, program_login_id)
1034: VALUES (p_request_id, 'ICX_CAT_CONTENT_ZONES', 'ICX_CAT_CANNOT_UPDATE_ZONES', null, p_line_number, p_request_id,
1035: fnd_global.conc_program_id, fnd_global.prog_appl_id, fnd_global.conc_login_id);