APPS.ICX_CAT_SQE_PVT dependencies on ICX_CAT_SCHEMA_UPLOAD_PVT

Line 930: ICX_CAT_SCHEMA_UPLOAD_PVT.update_job_status(l_request_id, 'RUNNING');

926: l_request_id := fnd_global.conc_request_id;
927:
928: l_err_loc := 300;
929: -- update the job status to running
930: ICX_CAT_SCHEMA_UPLOAD_PVT.update_job_status(l_request_id, 'RUNNING');
931:
932: l_err_loc := 400;
933: -- call the main API to do the sync
934: sync_sqes_hier_change_internal(l_return_status, l_errored_zone_name_list);

Line 947: ICX_CAT_SCHEMA_UPLOAD_PVT.update_job_status(l_request_id, 'ERROR');

943: END IF;
944: l_err_loc := 600;
945: -- update the job status to error
946: x_retcode := 1;
947: ICX_CAT_SCHEMA_UPLOAD_PVT.update_job_status(l_request_id, 'ERROR');
948:
949: l_err_loc := 700;
950: l_token_list := 'ZONE_NAMES:' || l_errored_zone_name_list;
951:

Line 961: ICX_CAT_SCHEMA_UPLOAD_PVT.update_job_status(l_request_id, 'COMPLETED');

957: fnd_global.conc_program_id, fnd_global.prog_appl_id, fnd_global.conc_login_id);
958: ELSE
959: l_err_loc := 900;
960: -- update the job status to completed
961: ICX_CAT_SCHEMA_UPLOAD_PVT.update_job_status(l_request_id, 'COMPLETED');
962: END IF;
963:
964: l_err_loc := 1000;
965:

Line 983: ICX_CAT_SCHEMA_UPLOAD_PVT.update_job_status(l_request_id, 'ERROR');

979: x_errbuf := 'Exception at ICX_CAT_SQE_PVT.sync_sqes_for_hierarchy_change(' ||
980: l_err_loc || '), ' || SQLERRM;
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)