APPS.WIP_JOB_DETAILS dependencies on WIP_LOGGER

Line 156: l_params wip_logger.param_tbl_t;

152: cur_job job_cur%ROWTYPE ;
153:
154: l_dummy2 VARCHAR2(1);
155: l_logLevel number;
156: l_params wip_logger.param_tbl_t;
157:
158: BEGIN
159: l_params(1).paramName := 'p_groupID';
160: l_params(1).paramValue := p_group_id;

Line 166: wip_logger.entryPoint(p_procName => 'WIP_JOB_DETAILS.Load_All_Details',

162: l_params(2).paramValue := p_parent_header_id;
163: l_params(3).paramName := 'p_std_alone';
164: l_params(3).paramValue := p_std_alone;
165:
166: wip_logger.entryPoint(p_procName => 'WIP_JOB_DETAILS.Load_All_Details',
167: p_params => l_params,
168: x_returnStatus => l_dummy2);
169:
170: begin

Line 282: wip_logger.log('Error in WIP_OPERATION_DEFAULT.Default_Operations,l_cur.wip_entity_id='||l_cur.wip_entity_id,l_dummy2);

278: x_err_msg ,
279: x_return_status );
280: exception
281: when others then
282: wip_logger.log('Error in WIP_OPERATION_DEFAULT.Default_Operations,l_cur.wip_entity_id='||l_cur.wip_entity_id,l_dummy2);
283: wip_logger.log(SQLERRM,l_dummy2);
284: raise;
285: end;
286:

Line 283: wip_logger.log(SQLERRM,l_dummy2);

279: x_return_status );
280: exception
281: when others then
282: wip_logger.log('Error in WIP_OPERATION_DEFAULT.Default_Operations,l_cur.wip_entity_id='||l_cur.wip_entity_id,l_dummy2);
283: wip_logger.log(SQLERRM,l_dummy2);
284: raise;
285: end;
286:
287:

Line 303: wip_logger.log('Error in WIP_OPERATION_VALIDATE.Add_Operation,l_cur.wip_entity_id='||l_cur.wip_entity_id||' , substitution_type= '||WIP_JOB_DETAILS.WIP_ADD,l_dummy2);

299: x_err_code, x_err_msg,
300: x_return_status);
301: exception
302: when others then
303: wip_logger.log('Error in WIP_OPERATION_VALIDATE.Add_Operation,l_cur.wip_entity_id='||l_cur.wip_entity_id||' , substitution_type= '||WIP_JOB_DETAILS.WIP_ADD,l_dummy2);
304: wip_logger.log(SQLERRM,l_dummy2);
305: raise;
306: end;
307: /* validate operation records */

Line 304: wip_logger.log(SQLERRM,l_dummy2);

300: x_return_status);
301: exception
302: when others then
303: wip_logger.log('Error in WIP_OPERATION_VALIDATE.Add_Operation,l_cur.wip_entity_id='||l_cur.wip_entity_id||' , substitution_type= '||WIP_JOB_DETAILS.WIP_ADD,l_dummy2);
304: wip_logger.log(SQLERRM,l_dummy2);
305: raise;
306: end;
307: /* validate operation records */
308:

Line 321: wip_logger.log('Error in WIP_OPERATION_VALIDATE.Change_Operation,l_cur.wip_entity_id='||l_cur.wip_entity_id||' , substitution_type= '||WIP_JOB_DETAILS.WIP_CHANGE,l_dummy2);

317: x_return_status);
318:
319: EXCEPTION
320: when others then
321: wip_logger.log('Error in WIP_OPERATION_VALIDATE.Change_Operation,l_cur.wip_entity_id='||l_cur.wip_entity_id||' , substitution_type= '||WIP_JOB_DETAILS.WIP_CHANGE,l_dummy2);
322: wip_logger.log(SQLERRM,l_dummy2);
323: raise;
324: end;
325:

Line 322: wip_logger.log(SQLERRM,l_dummy2);

318:
319: EXCEPTION
320: when others then
321: wip_logger.log('Error in WIP_OPERATION_VALIDATE.Change_Operation,l_cur.wip_entity_id='||l_cur.wip_entity_id||' , substitution_type= '||WIP_JOB_DETAILS.WIP_CHANGE,l_dummy2);
322: wip_logger.log(SQLERRM,l_dummy2);
323: raise;
324: end;
325:
326: END IF; /* end of operation validation */

Line 337: wip_logger.log('Error in WIP_JOB_DTLS_VALIDATIONS.Error_All_If_Any,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);

333: cur_job.wip_entity_id,
334: cur_job.organization_id);
335: EXCEPTION
336: when others then
337: wip_logger.log('Error in WIP_JOB_DTLS_VALIDATIONS.Error_All_If_Any,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);
338: wip_logger.log(SQLERRM,l_dummy2);
339: raise;
340: end;
341:

Line 338: wip_logger.log(SQLERRM,l_dummy2);

334: cur_job.organization_id);
335: EXCEPTION
336: when others then
337: wip_logger.log('Error in WIP_JOB_DTLS_VALIDATIONS.Error_All_If_Any,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);
338: wip_logger.log(SQLERRM,l_dummy2);
339: raise;
340: end;
341:
342:

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 354: wip_logger.log(SQLERRM,l_dummy2);

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:
358: begin

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 369: wip_logger.log(SQLERRM,l_dummy2);

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:
373: /*************END PROCESSING OPERATIONS********************/

Line 381: wip_logger.log('Error in WIP_JOB_DTLS_VALIDATIONS.OP_Seq_Num,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);

377: cur_job.wip_entity_id,
378: cur_job.organization_id);
379: EXCEPTION
380: when others then
381: wip_logger.log('Error in WIP_JOB_DTLS_VALIDATIONS.OP_Seq_Num,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);
382: wip_logger.log(SQLERRM,l_dummy2);
383: raise;
384: end;
385:

Line 382: wip_logger.log(SQLERRM,l_dummy2);

378: cur_job.organization_id);
379: EXCEPTION
380: when others then
381: wip_logger.log('Error in WIP_JOB_DTLS_VALIDATIONS.OP_Seq_Num,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);
382: wip_logger.log(SQLERRM,l_dummy2);
383: raise;
384: end;
385:
386: FOR l_cur IN RES_CUR (cur_job.wip_entity_id,

Line 399: wip_logger.log('Error in WIP_RESOURCE_VALIDATIONS.Delete_Resource,l_cur.wip_entity_id='||l_cur.wip_entity_id,l_dummy2);

395: l_cur.substitution_type);
396:
397: EXCEPTION
398: when others then
399: wip_logger.log('Error in WIP_RESOURCE_VALIDATIONS.Delete_Resource,l_cur.wip_entity_id='||l_cur.wip_entity_id,l_dummy2);
400: wip_logger.log(SQLERRM,l_dummy2);
401: raise;
402: end;
403:

Line 400: wip_logger.log(SQLERRM,l_dummy2);

396:
397: EXCEPTION
398: when others then
399: wip_logger.log('Error in WIP_RESOURCE_VALIDATIONS.Delete_Resource,l_cur.wip_entity_id='||l_cur.wip_entity_id,l_dummy2);
400: wip_logger.log(SQLERRM,l_dummy2);
401: raise;
402: end;
403:
404: ELSIF l_cur.substitution_type = WIP_ADD THEN

Line 414: wip_logger.log('Error in WIP_RESOURCE_VALIDATIONS.Add_Resource,l_cur.wip_entity_id='||l_cur.wip_entity_id,l_dummy2);

410: l_cur.substitution_type);
411:
412: EXCEPTION
413: when others then
414: wip_logger.log('Error in WIP_RESOURCE_VALIDATIONS.Add_Resource,l_cur.wip_entity_id='||l_cur.wip_entity_id,l_dummy2);
415: wip_logger.log(SQLERRM,l_dummy2);
416: raise;
417: end;
418:

Line 415: wip_logger.log(SQLERRM,l_dummy2);

411:
412: EXCEPTION
413: when others then
414: wip_logger.log('Error in WIP_RESOURCE_VALIDATIONS.Add_Resource,l_cur.wip_entity_id='||l_cur.wip_entity_id,l_dummy2);
415: wip_logger.log(SQLERRM,l_dummy2);
416: raise;
417: end;
418:
419: ELSIF l_cur.substitution_type = WIP_CHANGE THEN

Line 428: wip_logger.log('Error in WIP_RESOURCE_VALIDATIONS.Change_Resource,l_cur.wip_entity_id='||l_cur.wip_entity_id,l_dummy2);

424: l_cur.organization_id,
425: l_cur.substitution_type);
426: EXCEPTION
427: when others then
428: wip_logger.log('Error in WIP_RESOURCE_VALIDATIONS.Change_Resource,l_cur.wip_entity_id='||l_cur.wip_entity_id,l_dummy2);
429: wip_logger.log(SQLERRM,l_dummy2);
430: raise;
431: end;
432:

Line 429: wip_logger.log(SQLERRM,l_dummy2);

425: l_cur.substitution_type);
426: EXCEPTION
427: when others then
428: wip_logger.log('Error in WIP_RESOURCE_VALIDATIONS.Change_Resource,l_cur.wip_entity_id='||l_cur.wip_entity_id,l_dummy2);
429: wip_logger.log(SQLERRM,l_dummy2);
430: raise;
431: end;
432:
433: END IF;

Line 446: wip_logger.log('Error in WIP_JOB_DTLS_VALIDATIONS.Error_All_If_Any,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);

442: cur_job.organization_id);
443:
444: EXCEPTION
445: when others then
446: wip_logger.log('Error in WIP_JOB_DTLS_VALIDATIONS.Error_All_If_Any,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);
447: wip_logger.log(SQLERRM,l_dummy2);
448: raise;
449: end;
450:

Line 447: wip_logger.log(SQLERRM,l_dummy2);

443:
444: EXCEPTION
445: when others then
446: wip_logger.log('Error in WIP_JOB_DTLS_VALIDATIONS.Error_All_If_Any,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);
447: wip_logger.log(SQLERRM,l_dummy2);
448: raise;
449: end;
450:
451:

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 463: wip_logger.log(SQLERRM,l_dummy2);

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:
467: BEGIN

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 478: wip_logger.log(SQLERRM,l_dummy2);

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:
482: BEGIN

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 492: wip_logger.log(SQLERRM,l_dummy2);

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:
496: FOR l_cur IN RESINST_CUR (cur_job.wip_entity_id,

Line 511: wip_logger.log('Error in WIP_RES_INST_VALIDATIONS.Delete_Resource_Instance,l_cur.wip_entity_id='||l_cur.wip_entity_id,l_dummy2);

507: x_err_msg);
508:
509: EXCEPTION
510: when others then
511: wip_logger.log('Error in WIP_RES_INST_VALIDATIONS.Delete_Resource_Instance,l_cur.wip_entity_id='||l_cur.wip_entity_id,l_dummy2);
512: wip_logger.log(SQLERRM,l_dummy2);
513: raise;
514: end;
515: if (l_logLevel <= wip_constants.trace_logging) then

Line 512: wip_logger.log(SQLERRM,l_dummy2);

508:
509: EXCEPTION
510: when others then
511: wip_logger.log('Error in WIP_RES_INST_VALIDATIONS.Delete_Resource_Instance,l_cur.wip_entity_id='||l_cur.wip_entity_id,l_dummy2);
512: wip_logger.log(SQLERRM,l_dummy2);
513: raise;
514: end;
515: if (l_logLevel <= wip_constants.trace_logging) then
516: IF x_err_code IS NOT NULL THEN

Line 517: wip_logger.log(x_err_code, l_dummy2);

513: raise;
514: end;
515: if (l_logLevel <= wip_constants.trace_logging) then
516: IF x_err_code IS NOT NULL THEN
517: wip_logger.log(x_err_code, l_dummy2);
518: wip_logger.log(x_err_msg, l_dummy2);
519: end if;
520: end if;
521:

Line 518: wip_logger.log(x_err_msg, l_dummy2);

514: end;
515: if (l_logLevel <= wip_constants.trace_logging) then
516: IF x_err_code IS NOT NULL THEN
517: wip_logger.log(x_err_code, l_dummy2);
518: wip_logger.log(x_err_msg, l_dummy2);
519: end if;
520: end if;
521:
522: ELSIF l_cur.substitution_type = WIP_ADD THEN

Line 532: wip_logger.log(x_err_code, l_dummy2);

528: x_err_code,
529: x_err_msg);
530: if (l_logLevel <= wip_constants.trace_logging) then
531: IF x_err_code IS NOT NULL THEN
532: wip_logger.log(x_err_code, l_dummy2);
533: wip_logger.log(x_err_msg, l_dummy2);
534: end if;
535: end if;
536:

Line 533: wip_logger.log(x_err_msg, l_dummy2);

529: x_err_msg);
530: if (l_logLevel <= wip_constants.trace_logging) then
531: IF x_err_code IS NOT NULL THEN
532: wip_logger.log(x_err_code, l_dummy2);
533: wip_logger.log(x_err_msg, l_dummy2);
534: end if;
535: end if;
536:
537: ELSIF l_cur.substitution_type = WIP_CHANGE THEN

Line 547: wip_logger.log(x_err_code, l_dummy2);

543: x_err_code,
544: x_err_msg);
545: if (l_logLevel <= wip_constants.trace_logging) then
546: IF x_err_code IS NOT NULL THEN
547: wip_logger.log(x_err_code, l_dummy2);
548: wip_logger.log(x_err_msg, l_dummy2);
549: end if;
550: end if;
551: END IF;

Line 548: wip_logger.log(x_err_msg, l_dummy2);

544: x_err_msg);
545: if (l_logLevel <= wip_constants.trace_logging) then
546: IF x_err_code IS NOT NULL THEN
547: wip_logger.log(x_err_code, l_dummy2);
548: wip_logger.log(x_err_msg, l_dummy2);
549: end if;
550: end if;
551: END IF;
552: END LOOP;

Line 564: wip_logger.log('Error in WIP_JOB_DTLS_VALIDATIONS.Error_All_If_Any,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);

560: cur_job.organization_id);
561:
562: EXCEPTION
563: when others then
564: wip_logger.log('Error in WIP_JOB_DTLS_VALIDATIONS.Error_All_If_Any,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);
565: wip_logger.log(SQLERRM,l_dummy2);
566: raise;
567: end;
568:

Line 565: wip_logger.log(SQLERRM,l_dummy2);

561:
562: EXCEPTION
563: when others then
564: wip_logger.log('Error in WIP_JOB_DTLS_VALIDATIONS.Error_All_If_Any,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);
565: wip_logger.log(SQLERRM,l_dummy2);
566: raise;
567: end;
568:
569:

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 581: wip_logger.log(SQLERRM,l_dummy2);

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:
585: BEGIN

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 595: wip_logger.log(SQLERRM,l_dummy2);

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:
599: BEGIN

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 609: wip_logger.log(SQLERRM,l_dummy2);

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:
613: BEGIN

Line 621: wip_logger.log('Error in WIP_JOB_DTLS_VALIDATIONS.Error_All_If_Any,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);

617: cur_job.wip_entity_id,
618: cur_job.organization_id);
619: EXCEPTION
620: when others then
621: wip_logger.log('Error in WIP_JOB_DTLS_VALIDATIONS.Error_All_If_Any,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);
622: wip_logger.log(SQLERRM,l_dummy2);
623: raise;
624: end;
625:

Line 622: wip_logger.log(SQLERRM,l_dummy2);

618: cur_job.organization_id);
619: EXCEPTION
620: when others then
621: wip_logger.log('Error in WIP_JOB_DTLS_VALIDATIONS.Error_All_If_Any,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);
622: wip_logger.log(SQLERRM,l_dummy2);
623: raise;
624: end;
625:
626: /****** MATERAIL REQUIREMENTS processing ******************/

Line 642: wip_logger.log('Error in WIP_REQUIREMENT_VALIDATIONS.Delete_Req,l_cur.wip_entity_id='||l_cur.wip_entity_id,l_dummy2);

638: l_cur.substitution_type);
639:
640: EXCEPTION
641: when others then
642: wip_logger.log('Error in WIP_REQUIREMENT_VALIDATIONS.Delete_Req,l_cur.wip_entity_id='||l_cur.wip_entity_id,l_dummy2);
643: wip_logger.log(SQLERRM,l_dummy2);
644: raise;
645: end;
646: ELSIF l_cur.substitution_type = WIP_ADD THEN

Line 643: wip_logger.log(SQLERRM,l_dummy2);

639:
640: EXCEPTION
641: when others then
642: wip_logger.log('Error in WIP_REQUIREMENT_VALIDATIONS.Delete_Req,l_cur.wip_entity_id='||l_cur.wip_entity_id,l_dummy2);
643: wip_logger.log(SQLERRM,l_dummy2);
644: raise;
645: end;
646: ELSIF l_cur.substitution_type = WIP_ADD THEN
647:

Line 657: wip_logger.log('Error in WIP_REQUIREMENT_VALIDATIONS.Add_Req,l_cur.wip_entity_id='||l_cur.wip_entity_id,l_dummy2);

653: l_cur.substitution_type);
654:
655: EXCEPTION
656: when others then
657: wip_logger.log('Error in WIP_REQUIREMENT_VALIDATIONS.Add_Req,l_cur.wip_entity_id='||l_cur.wip_entity_id,l_dummy2);
658: wip_logger.log(SQLERRM,l_dummy2);
659: raise;
660: end;
661: ELSIF l_cur.substitution_type = WIP_CHANGE THEN

Line 658: wip_logger.log(SQLERRM,l_dummy2);

654:
655: EXCEPTION
656: when others then
657: wip_logger.log('Error in WIP_REQUIREMENT_VALIDATIONS.Add_Req,l_cur.wip_entity_id='||l_cur.wip_entity_id,l_dummy2);
658: wip_logger.log(SQLERRM,l_dummy2);
659: raise;
660: end;
661: ELSIF l_cur.substitution_type = WIP_CHANGE THEN
662:

Line 672: wip_logger.log('Error in WIP_REQUIREMENT_VALIDATIONS.Change_Req,l_cur.wip_entity_id='||l_cur.wip_entity_id,l_dummy2);

668: l_cur.substitution_type);
669:
670: EXCEPTION
671: when others then
672: wip_logger.log('Error in WIP_REQUIREMENT_VALIDATIONS.Change_Req,l_cur.wip_entity_id='||l_cur.wip_entity_id,l_dummy2);
673: wip_logger.log(SQLERRM,l_dummy2);
674: raise;
675: end;
676:

Line 673: wip_logger.log(SQLERRM,l_dummy2);

669:
670: EXCEPTION
671: when others then
672: wip_logger.log('Error in WIP_REQUIREMENT_VALIDATIONS.Change_Req,l_cur.wip_entity_id='||l_cur.wip_entity_id,l_dummy2);
673: wip_logger.log(SQLERRM,l_dummy2);
674: raise;
675: end;
676:
677: END IF; /* End requirement processing */

Line 688: wip_logger.log('Error in WIP_JOB_DTLS_VALIDATIONS.Error_All_If_Any,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);

684: cur_job.wip_entity_id,
685: cur_job.organization_id);
686: EXCEPTION
687: when others then
688: wip_logger.log('Error in WIP_JOB_DTLS_VALIDATIONS.Error_All_If_Any,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);
689: wip_logger.log(SQLERRM,l_dummy2);
690: raise;
691: end;
692:

Line 689: wip_logger.log(SQLERRM,l_dummy2);

685: cur_job.organization_id);
686: EXCEPTION
687: when others then
688: wip_logger.log('Error in WIP_JOB_DTLS_VALIDATIONS.Error_All_If_Any,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);
689: wip_logger.log(SQLERRM,l_dummy2);
690: raise;
691: end;
692:
693:

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 704: wip_logger.log(SQLERRM,l_dummy2);

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:
708:

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 720: wip_logger.log(SQLERRM,l_dummy2);

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:
724: BEGIN

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 734: wip_logger.log(SQLERRM,l_dummy2);

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:
738:

Line 755: wip_logger.log('Error in WIP_RES_USAGE_DEFAULT.Default_Resource_Usages,l_cur.wip_entity_id='||l_cur.wip_entity_id,l_dummy2);

751: x_return_status);
752:
753: EXCEPTION
754: when others then
755: wip_logger.log('Error in WIP_RES_USAGE_DEFAULT.Default_Resource_Usages,l_cur.wip_entity_id='||l_cur.wip_entity_id,l_dummy2);
756: wip_logger.log(SQLERRM,l_dummy2);
757: raise;
758: end;
759: BEGIN

Line 756: wip_logger.log(SQLERRM,l_dummy2);

752:
753: EXCEPTION
754: when others then
755: wip_logger.log('Error in WIP_RES_USAGE_DEFAULT.Default_Resource_Usages,l_cur.wip_entity_id='||l_cur.wip_entity_id,l_dummy2);
756: wip_logger.log(SQLERRM,l_dummy2);
757: raise;
758: end;
759: BEGIN
760:

Line 770: wip_logger.log('Error in WIP_RES_USAGE_VALIDATE.Validate_Usage,l_cur.wip_entity_id='||l_cur.wip_entity_id,l_dummy2);

766: x_return_status);
767:
768: EXCEPTION
769: when others then
770: wip_logger.log('Error in WIP_RES_USAGE_VALIDATE.Validate_Usage,l_cur.wip_entity_id='||l_cur.wip_entity_id,l_dummy2);
771: wip_logger.log(SQLERRM,l_dummy2);
772: raise;
773: end;
774: END LOOP; /* End req_cur loop for validation */

Line 771: wip_logger.log(SQLERRM,l_dummy2);

767:
768: EXCEPTION
769: when others then
770: wip_logger.log('Error in WIP_RES_USAGE_VALIDATE.Validate_Usage,l_cur.wip_entity_id='||l_cur.wip_entity_id,l_dummy2);
771: wip_logger.log(SQLERRM,l_dummy2);
772: raise;
773: end;
774: END LOOP; /* End req_cur loop for validation */
775:

Line 786: wip_logger.log('Error in WIP_JOB_DTLS_VALIDATIONS.Error_All_If_Any,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);

782: cur_job.organization_id);
783:
784: EXCEPTION
785: when others then
786: wip_logger.log('Error in WIP_JOB_DTLS_VALIDATIONS.Error_All_If_Any,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);
787: wip_logger.log(SQLERRM,l_dummy2);
788: raise;
789: end;
790:

Line 787: wip_logger.log(SQLERRM,l_dummy2);

783:
784: EXCEPTION
785: when others then
786: wip_logger.log('Error in WIP_JOB_DTLS_VALIDATIONS.Error_All_If_Any,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);
787: wip_logger.log(SQLERRM,l_dummy2);
788: raise;
789: end;
790:
791: BEGIN

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 804: wip_logger.log(SQLERRM,l_dummy2);

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:
808:

Line 820: wip_logger.log('Error in WIP_JOB_DTLS_VALIDATIONS.OP_Seq_Num,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);

816: cur_job.organization_id);
817:
818: EXCEPTION
819: when others then
820: wip_logger.log('Error in WIP_JOB_DTLS_VALIDATIONS.OP_Seq_Num,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);
821: wip_logger.log(SQLERRM,l_dummy2);
822: raise;
823: end;
824:

Line 821: wip_logger.log(SQLERRM,l_dummy2);

817:
818: EXCEPTION
819: when others then
820: wip_logger.log('Error in WIP_JOB_DTLS_VALIDATIONS.OP_Seq_Num,l_cur.wip_entity_id='||cur_job.wip_entity_id,l_dummy2);
821: wip_logger.log(SQLERRM,l_dummy2);
822: raise;
823: end;
824:
825: FOR l_cur IN SUBRES_CUR (cur_job.wip_entity_id,

Line 1012: wip_logger.log('wip_operations',l_dummy2);

1008: x_err_msg,
1009: x_return_status);
1010:
1011: if (l_logLevel <= wip_constants.trace_logging) then
1012: wip_logger.log('wip_operations',l_dummy2);
1013: for wo_rec in (select * from wip_operations where wip_entity_id = cur_job.wip_entity_id and organization_id = cur_job.organization_id order by operation_seq_num) loop
1014: wip_logger.log('Op Seq '||wo_rec.operation_seq_num||' FUSD '||to_date(wo_rec.first_unit_start_date,WIP_CONSTANTS.DATETIME_FMT)||
1015: ' FUCD '||to_date(wo_rec.first_unit_completion_date,WIP_CONSTANTS.DATETIME_FMT) ||
1016: ' LUSD '||to_date(wo_rec.last_unit_start_date,WIP_CONSTANTS.DATETIME_FMT) ||

Line 1014: wip_logger.log('Op Seq '||wo_rec.operation_seq_num||' FUSD '||to_date(wo_rec.first_unit_start_date,WIP_CONSTANTS.DATETIME_FMT)||

1010:
1011: if (l_logLevel <= wip_constants.trace_logging) then
1012: wip_logger.log('wip_operations',l_dummy2);
1013: for wo_rec in (select * from wip_operations where wip_entity_id = cur_job.wip_entity_id and organization_id = cur_job.organization_id order by operation_seq_num) loop
1014: wip_logger.log('Op Seq '||wo_rec.operation_seq_num||' FUSD '||to_date(wo_rec.first_unit_start_date,WIP_CONSTANTS.DATETIME_FMT)||
1015: ' FUCD '||to_date(wo_rec.first_unit_completion_date,WIP_CONSTANTS.DATETIME_FMT) ||
1016: ' LUSD '||to_date(wo_rec.last_unit_start_date,WIP_CONSTANTS.DATETIME_FMT) ||
1017: ' LUCD '||to_date(wo_rec.last_unit_completion_date,WIP_CONSTANTS.DATETIME_FMT) ,l_dummy2);
1018: end loop;

Line 1019: wip_logger.log('wip_operation_resources',l_dummy2);

1015: ' FUCD '||to_date(wo_rec.first_unit_completion_date,WIP_CONSTANTS.DATETIME_FMT) ||
1016: ' LUSD '||to_date(wo_rec.last_unit_start_date,WIP_CONSTANTS.DATETIME_FMT) ||
1017: ' LUCD '||to_date(wo_rec.last_unit_completion_date,WIP_CONSTANTS.DATETIME_FMT) ,l_dummy2);
1018: end loop;
1019: wip_logger.log('wip_operation_resources',l_dummy2);
1020: for wor_rec in (select * from wip_operation_resources where wip_entity_id = cur_job.wip_entity_id and organization_id = cur_job.organization_id order by operation_seq_num) loop
1021: wip_logger.log('Op Seq '||wor_rec.operation_seq_num||' Res Seq '||wor_rec.resource_seq_num||
1022: ' St Dt '||to_date(wor_rec.start_date,WIP_CONSTANTS.DATETIME_FMT) ||
1023: ' Cm Dt '||to_date(wor_rec.completion_date,WIP_CONSTANTS.DATETIME_FMT) ,l_dummy2);

Line 1021: wip_logger.log('Op Seq '||wor_rec.operation_seq_num||' Res Seq '||wor_rec.resource_seq_num||

1017: ' LUCD '||to_date(wo_rec.last_unit_completion_date,WIP_CONSTANTS.DATETIME_FMT) ,l_dummy2);
1018: end loop;
1019: wip_logger.log('wip_operation_resources',l_dummy2);
1020: for wor_rec in (select * from wip_operation_resources where wip_entity_id = cur_job.wip_entity_id and organization_id = cur_job.organization_id order by operation_seq_num) loop
1021: wip_logger.log('Op Seq '||wor_rec.operation_seq_num||' Res Seq '||wor_rec.resource_seq_num||
1022: ' St Dt '||to_date(wor_rec.start_date,WIP_CONSTANTS.DATETIME_FMT) ||
1023: ' Cm Dt '||to_date(wor_rec.completion_date,WIP_CONSTANTS.DATETIME_FMT) ,l_dummy2);
1024: end loop;
1025: end if;