APPS.ICX_CAT_SQE_PVT dependencies on ICX_CAT_SCHEMA_UPLOAD_PVT

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

937: l_request_id := fnd_global.conc_request_id;
938:
939: l_err_loc := 300;
940: -- update the job status to running
941: ICX_CAT_SCHEMA_UPLOAD_PVT.update_job_status(l_request_id, 'RUNNING');
942:
943: l_err_loc := 400;
944: -- call the main API to do the sync
945: sync_sqes_hier_change_internal(l_return_status, l_errored_zone_name_list);

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

954: END IF;
955: l_err_loc := 600;
956: -- update the job status to error
957: x_retcode := 1;
958: ICX_CAT_SCHEMA_UPLOAD_PVT.update_job_status(l_request_id, 'ERROR');
959:
960: l_err_loc := 700;
961: l_token_list := 'ZONE_NAMES:' || l_errored_zone_name_list;
962:

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

968: fnd_global.conc_program_id, fnd_global.prog_appl_id, fnd_global.conc_login_id);
969: ELSE
970: l_err_loc := 900;
971: -- update the job status to completed
972: ICX_CAT_SCHEMA_UPLOAD_PVT.update_job_status(l_request_id, 'COMPLETED');
973: END IF;
974:
975: l_err_loc := 1000;
976:

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

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