DBA Data[Home] [Help]

APPS.ICX_CAT_SQE_PVT dependencies on ICX_POR_FAILED_LINE_MESSAGES

Line 964: INSERT INTO icx_por_failed_line_messages

960: l_err_loc := 700;
961: l_token_list := 'ZONE_NAMES:' || l_errored_zone_name_list;
962:
963: l_err_loc := 800;
964: INSERT INTO icx_por_failed_line_messages
965: (job_number, descriptor_key, message_name, token_list, line_number, request_id, program_id,
966: program_application_id, program_login_id)
967: VALUES (l_request_id, 'OTHER', 'ICX_CAT_CANNOT_UPDATE_CZS_ERR', l_token_list, 1, l_request_id,
968: fnd_global.conc_program_id, fnd_global.prog_appl_id, fnd_global.conc_login_id);

Line 996: INSERT INTO icx_por_failed_line_messages

992:
993: -- update the job status to error
994: ICX_CAT_SCHEMA_UPLOAD_PVT.update_job_status(l_request_id, 'ERROR');
995:
996: INSERT INTO icx_por_failed_line_messages
997: (job_number, descriptor_key, message_name, token_list, line_number, request_id, program_id,
998: program_application_id, program_login_id)
999: VALUES (l_request_id, 'OTHER', 'ICX_CAT_HIER_UNEXPECTED_ERR', l_token_list, 1, l_request_id,
1000: fnd_global.conc_program_id, fnd_global.prog_appl_id, fnd_global.conc_login_id);

Line 1042: INSERT INTO icx_por_failed_line_messages

1038: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1039: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
1040: END IF;
1041: l_err_loc := 800;
1042: INSERT INTO icx_por_failed_line_messages
1043: (job_number, descriptor_key, message_name, token_list, line_number, request_id, program_id,
1044: program_application_id, program_login_id)
1045: VALUES (p_request_id, 'ICX_CAT_CONTENT_ZONES', 'ICX_CAT_CANNOT_UPDATE_ZONES', null, p_line_number, p_request_id,
1046: fnd_global.conc_program_id, fnd_global.prog_appl_id, fnd_global.conc_login_id);