[Home] [Help]
484:
485:
486: -- This procedure checks if the specified Job name exists in the
487: -- specified organization. It checks if it exists in
488: -- wip_entities or wip_job_schedule_interface table.
489: -- If it exists, then an Error status is returned.
490: -- If it does not exist in either of the tables, then
491: -- a Sucess status is returned.
492: -- This procedure is used whenever a job_name is generated, to confirm that
507:
508: BEGIN
509:
510:
511: Select count(*) into l_job_count from wip_entities where wip_entity_name = p_job_name and
512: organization_id = p_organization_id ;
513:
514: If l_job_count = 0 Then
515:
512: organization_id = p_organization_id ;
513:
514: If l_job_count = 0 Then
515:
516: -- Job does not exist in WIP_entities, check if it is already inserted in the interface table by another
517: -- process and so may be in the process of getting into WIP.
518: -- If it exists, do not want to use this job name, so return Error
519:
520: Select count(*) into l_job_count from wip_job_schedule_interface where job_name = p_job_name and
521: organization_id = p_organization_id ;
522:
523: IF l_job_count = 0 THEN
524:
525: -- Generated job name does exist either in the interface or wip_entities table,
526: -- Success is returned
527:
528: x_return_status := FND_API.G_RET_STS_SUCCESS;
529: RETURN;
540:
541:
542: ELSE
543:
544: -- Job exists in wip_entities table, hence return Error status
545:
546: x_return_status := FND_API.G_RET_STS_ERROR;
547: RETURN;
548:
592: x_return_status => l_return_status ) ;
593:
594: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
595:
596: -- Generated job name does not exist both in the interface and wip_entities table, so exit the loop
597:
598: exit;
599:
600: END IF;
1099: -- crj.wip_entity_id may be null (until wip_update is done).
1100: select count(*)
1101: into l_num_other_jobs
1102: from csd_repair_job_xref crj,
1103: wip_entities we
1104: where crj.job_name = we.wip_entity_name
1105: and crj.organization_id = we.organization_id
1106: and crj.repair_line_id = p_repair_line_id
1107: and we.wip_entity_id <> l_wip_entity_id;
1183:
1184: IF l_job_bill_routing_rec.job_name is not NULL then
1185:
1186: -- job name is passed in, validate it for Uniqueness,
1187: -- Check if it already exists in WIP_ENTITIES or WIP interface table
1188:
1189: validate_job_name ( p_job_name => l_job_bill_routing_rec.Job_Name,
1190: p_organization_id => p_job_header_rec.organization_id,
1191: x_return_status => x_return_status ) ;
1192:
1193:
1194: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1195:
1196: -- Job name either exists in WIP_ENTITIES or in the interface table for the specified
1197: -- organization, So raise an error and exit
1198:
1199: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_NAME_EXISTS');
1200: FND_MESSAGE.SET_TOKEN('JOB_NAME', l_job_bill_routing_rec.job_name );
1289: -- crj.wip_entity_id may be null (until wip_update is done).
1290: select count(*)
1291: into l_num_other_jobs
1292: from csd_repair_job_xref crj,
1293: wip_entities we
1294: where crj.job_name = we.wip_entity_name
1295: and crj.organization_id = we.organization_id
1296: and crj.repair_line_id = p_repair_line_id
1297: and we.wip_entity_id <> l_wip_entity_id;
1558: (SELECT * FROM TABLE(CAST(l_repair_line_ids AS JTF_NUMBER_TABLE))) ro_lines,
1559: csd_repair_job_xref crj,
1560: wip_discrete_jobs wdj,
1561: mtl_system_items_b msi,
1562: wip_entities we
1563: WHERE crj.repair_line_id = ro_lines.column_value
1564: AND wdj.primary_item_id = crj.inventory_item_id
1565: AND crj.job_name = we.wip_entity_name
1566: AND crj.organization_id = we.organization_id