DBA Data[Home] [Help]

APPS.WIP_JOB_DETAILS dependencies on WIP_JOB_DTLS_SUBSTITUTIONS

Line 344: WIP_JOB_DTLS_SUBSTITUTIONS.ADD_OPERATION

340: end;
341:
342:
343: BEGIN
344: WIP_JOB_DTLS_SUBSTITUTIONS.ADD_OPERATION
345: (p_group_id,
346: cur_job.wip_entity_id,
347: cur_job.organization_id,
348: x_err_code ,

Line 353: wip_logger.log('Error in WIP_JOB_DTLS_SUBSTITUTIONS.ADD_OPERATION,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);

349: x_err_msg,
350: x_return_status);
351: EXCEPTION
352: when others then
353: wip_logger.log('Error in WIP_JOB_DTLS_SUBSTITUTIONS.ADD_OPERATION,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);
354: wip_logger.log(SQLERRM,l_dummy2);
355: raise;
356: end;
357:

Line 359: WIP_JOB_DTLS_SUBSTITUTIONS.CHANGE_OPERATION

355: raise;
356: end;
357:
358: begin
359: WIP_JOB_DTLS_SUBSTITUTIONS.CHANGE_OPERATION
360: (p_group_id,
361: cur_job.wip_entity_id,
362: cur_job.organization_id,
363: x_err_code ,

Line 368: wip_logger.log('Error in WIP_JOB_DTLS_SUBSTITUTIONS.CHANGE_OPERATION,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);

364: x_err_msg,
365: x_return_status);
366: EXCEPTION
367: when others then
368: wip_logger.log('Error in WIP_JOB_DTLS_SUBSTITUTIONS.CHANGE_OPERATION,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);
369: wip_logger.log(SQLERRM,l_dummy2);
370: raise;
371: end;
372:

Line 453: WIP_JOB_DTLS_SUBSTITUTIONS.DELETE_RESOURCE(

449: end;
450:
451:
452: BEGIN
453: WIP_JOB_DTLS_SUBSTITUTIONS.DELETE_RESOURCE(
454: p_group_id,
455: cur_job.wip_entity_id,
456: cur_job.organization_id,
457: x_err_code,

Line 462: wip_logger.log('Error in WIP_JOB_DTLS_SUBSTITUTIONS.DELETE_RESOURCE,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);

458: x_err_msg);
459:
460: EXCEPTION
461: when others then
462: wip_logger.log('Error in WIP_JOB_DTLS_SUBSTITUTIONS.DELETE_RESOURCE,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);
463: wip_logger.log(SQLERRM,l_dummy2);
464: raise;
465: end;
466:

Line 468: WIP_JOB_DTLS_SUBSTITUTIONS.ADD_RESOURCE(

464: raise;
465: end;
466:
467: BEGIN
468: WIP_JOB_DTLS_SUBSTITUTIONS.ADD_RESOURCE(
469: p_group_id,
470: cur_job.wip_entity_id,
471: cur_job.organization_id,
472: x_err_code,

Line 477: wip_logger.log('Error in WIP_JOB_DTLS_SUBSTITUTIONS.ADD_RESOURCE,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);

473: x_err_msg);
474:
475: EXCEPTION
476: when others then
477: wip_logger.log('Error in WIP_JOB_DTLS_SUBSTITUTIONS.ADD_RESOURCE,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);
478: wip_logger.log(SQLERRM,l_dummy2);
479: raise;
480: end;
481:

Line 483: WIP_JOB_DTLS_SUBSTITUTIONS.CHANGE_RESOURCE(

479: raise;
480: end;
481:
482: BEGIN
483: WIP_JOB_DTLS_SUBSTITUTIONS.CHANGE_RESOURCE(
484: p_group_id,
485: cur_job.wip_entity_id,
486: cur_job.organization_id,
487: x_err_code,

Line 491: wip_logger.log('Error in WIP_JOB_DTLS_SUBSTITUTIONS.CHANGE_RESOURCE,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);

487: x_err_code,
488: x_err_msg);
489: EXCEPTION
490: when others then
491: wip_logger.log('Error in WIP_JOB_DTLS_SUBSTITUTIONS.CHANGE_RESOURCE,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);
492: wip_logger.log(SQLERRM,l_dummy2);
493: raise;
494: end;
495:

Line 571: WIP_JOB_DTLS_SUBSTITUTIONS.DELETE_RESOURCE_INSTANCE(

567: end;
568:
569:
570: BEGIN
571: WIP_JOB_DTLS_SUBSTITUTIONS.DELETE_RESOURCE_INSTANCE(
572: p_group_id,
573: cur_job.wip_entity_id,
574: cur_job.organization_id,
575: WIP_JOB_DETAILS.WIP_DELETE,

Line 580: wip_logger.log('Error in WIP_JOB_DTLS_SUBSTITUTIONS.DELETE_RESOURCE_INSTANCE,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);

576: x_err_code,
577: x_err_msg);
578: EXCEPTION
579: when others then
580: wip_logger.log('Error in WIP_JOB_DTLS_SUBSTITUTIONS.DELETE_RESOURCE_INSTANCE,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);
581: wip_logger.log(SQLERRM,l_dummy2);
582: raise;
583: end;
584:

Line 586: WIP_JOB_DTLS_SUBSTITUTIONS.ADD_RESOURCE_INSTANCE(

582: raise;
583: end;
584:
585: BEGIN
586: WIP_JOB_DTLS_SUBSTITUTIONS.ADD_RESOURCE_INSTANCE(
587: p_group_id,
588: cur_job.wip_entity_id,
589: cur_job.organization_id,
590: x_err_code,

Line 594: wip_logger.log('Error in WIP_JOB_DTLS_SUBSTITUTIONS.ADD_RESOURCE_INSTANCE,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);

590: x_err_code,
591: x_err_msg);
592: EXCEPTION
593: when others then
594: wip_logger.log('Error in WIP_JOB_DTLS_SUBSTITUTIONS.ADD_RESOURCE_INSTANCE,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);
595: wip_logger.log(SQLERRM,l_dummy2);
596: raise;
597: end;
598:

Line 600: WIP_JOB_DTLS_SUBSTITUTIONS.CHANGE_RESOURCE_INSTANCE(

596: raise;
597: end;
598:
599: BEGIN
600: WIP_JOB_DTLS_SUBSTITUTIONS.CHANGE_RESOURCE_INSTANCE(
601: p_group_id,
602: cur_job.wip_entity_id,
603: cur_job.organization_id,
604: x_err_code,

Line 608: wip_logger.log('Error in WIP_JOB_DTLS_SUBSTITUTIONS.CHANGE_RESOURCE_INSTANCE,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);

604: x_err_code,
605: x_err_msg);
606: EXCEPTION
607: when others then
608: wip_logger.log('Error in WIP_JOB_DTLS_SUBSTITUTIONS.CHANGE_RESOURCE_INSTANCE,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);
609: wip_logger.log(SQLERRM,l_dummy2);
610: raise;
611: end;
612:

Line 695: WIP_JOB_DTLS_SUBSTITUTIONS.DELETE_REQUIREMENT(

691: end;
692:
693:
694: BEGIN
695: WIP_JOB_DTLS_SUBSTITUTIONS.DELETE_REQUIREMENT(
696: p_group_id,
697: cur_job.wip_entity_id,
698: cur_job.organization_id,
699: x_err_code,

Line 703: wip_logger.log('Error in WIP_JOB_DTLS_SUBSTITUTIONS.DELETE_REQUIREMENT,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);

699: x_err_code,
700: x_err_msg);
701: EXCEPTION
702: when others then
703: wip_logger.log('Error in WIP_JOB_DTLS_SUBSTITUTIONS.DELETE_REQUIREMENT,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);
704: wip_logger.log(SQLERRM,l_dummy2);
705: raise;
706: end;
707:

Line 710: WIP_JOB_DTLS_SUBSTITUTIONS.ADD_REQUIREMENT(

706: end;
707:
708:
709: BEGIN
710: WIP_JOB_DTLS_SUBSTITUTIONS.ADD_REQUIREMENT(
711: p_group_id,
712: cur_job.wip_entity_id,
713: cur_job.organization_id,
714: x_err_code,

Line 719: wip_logger.log('Error in WIP_JOB_DTLS_SUBSTITUTIONS.ADD_REQUIREMENT,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);

715: x_err_msg);
716:
717: EXCEPTION
718: when others then
719: wip_logger.log('Error in WIP_JOB_DTLS_SUBSTITUTIONS.ADD_REQUIREMENT,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);
720: wip_logger.log(SQLERRM,l_dummy2);
721: raise;
722: end;
723:

Line 725: WIP_JOB_DTLS_SUBSTITUTIONS.CHANGE_REQUIREMENT(

721: raise;
722: end;
723:
724: BEGIN
725: WIP_JOB_DTLS_SUBSTITUTIONS.CHANGE_REQUIREMENT(
726: p_group_id,
727: cur_job.wip_entity_id,
728: cur_job.organization_id,
729: x_err_code,

Line 733: wip_logger.log('Error in WIP_JOB_DTLS_SUBSTITUTIONS.CHANGE_REQUIREMENT,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);

729: x_err_code,
730: x_err_msg);
731: EXCEPTION
732: when others then
733: wip_logger.log('Error in WIP_JOB_DTLS_SUBSTITUTIONS.CHANGE_REQUIREMENT,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);
734: wip_logger.log(SQLERRM,l_dummy2);
735: raise;
736: end;
737:

Line 793: WIP_JOB_DTLS_SUBSTITUTIONS.Substitution_Res_Usages

789: end;
790:
791: BEGIN
792:
793: WIP_JOB_DTLS_SUBSTITUTIONS.Substitution_Res_Usages
794: (p_group_id,
795: cur_job.wip_entity_id,
796: cur_job.organization_id,
797: x_err_code ,

Line 803: wip_logger.log('Error in WIP_JOB_DTLS_SUBSTITUTIONS.Substitution_Res_Usages,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);

799: x_return_status);
800:
801: EXCEPTION
802: when others then
803: wip_logger.log('Error in WIP_JOB_DTLS_SUBSTITUTIONS.Substitution_Res_Usages,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);
804: wip_logger.log(SQLERRM,l_dummy2);
805: raise;
806: end;
807:

Line 861: WIP_JOB_DTLS_SUBSTITUTIONS.DELETE_SUB_RESOURCE(

857:
858:
859:
860:
861: WIP_JOB_DTLS_SUBSTITUTIONS.DELETE_SUB_RESOURCE(
862: p_group_id,
863: cur_job.wip_entity_id,
864: cur_job.organization_id,
865: x_err_code,

Line 870: WIP_JOB_DTLS_SUBSTITUTIONS.ADD_SUB_RESOURCE(

866: x_err_msg);
867:
868:
869:
870: WIP_JOB_DTLS_SUBSTITUTIONS.ADD_SUB_RESOURCE(
871: p_group_id,
872: cur_job.wip_entity_id,
873: cur_job.organization_id,
874: x_err_code,

Line 877: WIP_JOB_DTLS_SUBSTITUTIONS.CHANGE_SUB_RESOURCE(

873: cur_job.organization_id,
874: x_err_code,
875: x_err_msg);
876:
877: WIP_JOB_DTLS_SUBSTITUTIONS.CHANGE_SUB_RESOURCE(
878: p_group_id,
879: cur_job.wip_entity_id,
880: cur_job.organization_id,
881: x_err_code,

Line 936: WIP_JOB_DTLS_SUBSTITUTIONS.DELETE_OP_LINK(

932: cur_job.wip_entity_id,
933: cur_job.organization_id);
934:
935:
936: WIP_JOB_DTLS_SUBSTITUTIONS.DELETE_OP_LINK(
937: p_group_id,
938: cur_job.wip_entity_id,
939: cur_job.organization_id,
940: x_err_code,

Line 944: WIP_JOB_DTLS_SUBSTITUTIONS.ADD_OP_LINK(

940: x_err_code,
941: x_err_msg);
942:
943:
944: WIP_JOB_DTLS_SUBSTITUTIONS.ADD_OP_LINK(
945: p_group_id,
946: cur_job.wip_entity_id,
947: cur_job.organization_id,
948: x_err_code,

Line 987: WIP_JOB_DTLS_SUBSTITUTIONS.DELETE_SERIAL_ASSOCIATION(

983: p_parent_header_id,
984: cur_job.wip_entity_id,
985: cur_job.organization_id);
986:
987: WIP_JOB_DTLS_SUBSTITUTIONS.DELETE_SERIAL_ASSOCIATION(
988: p_group_id,
989: cur_job.wip_entity_id,
990: cur_job.organization_id,
991: x_err_code,

Line 995: WIP_JOB_DTLS_SUBSTITUTIONS.ADD_SERIAL_ASSOCIATION(

991: x_err_code,
992: x_err_msg,
993: x_return_status);
994:
995: WIP_JOB_DTLS_SUBSTITUTIONS.ADD_SERIAL_ASSOCIATION(
996: p_group_id,
997: cur_job.wip_entity_id,
998: cur_job.organization_id,
999: x_err_code,

Line 1003: WIP_JOB_DTLS_SUBSTITUTIONS.CHANGE_SERIAL_ASSOCIATION(

999: x_err_code,
1000: x_err_msg,
1001: x_return_status);
1002:
1003: WIP_JOB_DTLS_SUBSTITUTIONS.CHANGE_SERIAL_ASSOCIATION(
1004: p_group_id,
1005: cur_job.wip_entity_id,
1006: cur_job.organization_id,
1007: x_err_code,

Line 1027: WIP_JOB_DTLS_SUBSTITUTIONS.VERIFY_OPERATION

1023: ' Cm Dt '||to_date(wor_rec.completion_date,WIP_CONSTANTS.DATETIME_FMT) ,l_dummy2);
1024: end loop;
1025: end if;
1026:
1027: WIP_JOB_DTLS_SUBSTITUTIONS.VERIFY_OPERATION
1028: (p_group_id,
1029: cur_job.wip_entity_id,
1030: cur_job.organization_id,
1031: x_err_code ,