eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_PROD_INDICATORS dependencies on FND_FILE

Line 178: FND_FILE.PUT_LINE (fnd_file.log, 'Capture Production Indicators has terminated with an exception');

174: retcode := to_char(x_errnum);
175:
176: EXCEPTION
177: WHEN OTHERS THEN
178: FND_FILE.PUT_LINE (fnd_file.log, 'Capture Production Indicators has terminated with an exception');
179: FND_FILE.PUT_LINE (fnd_file.log, SQLERRM);
180: rollback;
181: errbuf := SQLERRM;
182: retcode := to_char (-1);

Line 179: FND_FILE.PUT_LINE (fnd_file.log, SQLERRM);

175:
176: EXCEPTION
177: WHEN OTHERS THEN
178: FND_FILE.PUT_LINE (fnd_file.log, 'Capture Production Indicators has terminated with an exception');
179: FND_FILE.PUT_LINE (fnd_file.log, SQLERRM);
180: rollback;
181: errbuf := SQLERRM;
182: retcode := to_char (-1);
183:

Line 298: fnd_file.put_line (fnd_file.log,

294:
295: -- always print debug messages to log.
296: g_debug := 1;
297:
298: fnd_file.put_line (fnd_file.log,
299: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
300: fnd_file.put_line(fnd_file.log,'Commencing WIP Capture Production Indicators.');
301:
302: -- Step 0: Determine if old data needs to be backed up

Line 300: fnd_file.put_line(fnd_file.log,'Commencing WIP Capture Production Indicators.');

296: g_debug := 1;
297:
298: fnd_file.put_line (fnd_file.log,
299: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
300: fnd_file.put_line(fnd_file.log,'Commencing WIP Capture Production Indicators.');
301:
302: -- Step 0: Determine if old data needs to be backed up
303: l_backup_old_data := check_backup_needed ();
304:

Line 307: fnd_file.put_line (fnd_file.log,

303: l_backup_old_data := check_backup_needed ();
304:
305: -- Step 5: Backup of old data
306: if g_debug = 1 then
307: fnd_file.put_line (fnd_file.log,
308: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
309: fnd_file.put_line(fnd_file.log,'Previous Data Backup - Stage 5');
310: end if ;
311:

Line 309: fnd_file.put_line(fnd_file.log,'Previous Data Backup - Stage 5');

305: -- Step 5: Backup of old data
306: if g_debug = 1 then
307: fnd_file.put_line (fnd_file.log,
308: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
309: fnd_file.put_line(fnd_file.log,'Previous Data Backup - Stage 5');
310: end if ;
311:
312: -- Previously, the this program used to throw away all the existing
313: -- data in the tables:

Line 348: fnd_file.put_line (fnd_file.log,

344:
345:
346: -- Step 1: Clean up of work tables
347: if g_debug = 1 then
348: fnd_file.put_line (fnd_file.log,
349: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
350: fnd_file.put_line(fnd_file.log,'Initial Clean up - Stage 1');
351: end if ;
352: --dbms_output.put_line (to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));

Line 350: fnd_file.put_line(fnd_file.log,'Initial Clean up - Stage 1');

346: -- Step 1: Clean up of work tables
347: if g_debug = 1 then
348: fnd_file.put_line (fnd_file.log,
349: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
350: fnd_file.put_line(fnd_file.log,'Initial Clean up - Stage 1');
351: end if ;
352: --dbms_output.put_line (to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
353: --dbms_output.put_line('Initial Clean Up - Stage 1');
354:

Line 371: fnd_file.put_line (fnd_file.log,

367: end if ;
368:
369: -- Step 2: Collection of efficiency data into temp table
370: if g_debug = 1 then
371: fnd_file.put_line (fnd_file.log,
372: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
373: fnd_file.put_line(fnd_file.log, 'Before Stage 2');
374: end if ;
375: --dbms_output.put_line (to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));

Line 373: fnd_file.put_line(fnd_file.log, 'Before Stage 2');

369: -- Step 2: Collection of efficiency data into temp table
370: if g_debug = 1 then
371: fnd_file.put_line (fnd_file.log,
372: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
373: fnd_file.put_line(fnd_file.log, 'Before Stage 2');
374: end if ;
375: --dbms_output.put_line (to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
376: --dbms_output.put_line('Before Stage 2');
377:

Line 398: fnd_file.put_line (fnd_file.log,

394: end if ;
395:
396: -- Step 3: collection of utilization data into temp table
397: if g_debug = 1 then
398: fnd_file.put_line (fnd_file.log,
399: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
400: fnd_file.put_line(fnd_file.log, 'Before Stage 3');
401: end if ;
402: --dbms_output.put_line (to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));

Line 400: fnd_file.put_line(fnd_file.log, 'Before Stage 3');

396: -- Step 3: collection of utilization data into temp table
397: if g_debug = 1 then
398: fnd_file.put_line (fnd_file.log,
399: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
400: fnd_file.put_line(fnd_file.log, 'Before Stage 3');
401: end if ;
402: --dbms_output.put_line (to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
403: --dbms_output.put_line('Before Stage 3');
404:

Line 426: fnd_file.put_line (fnd_file.log,

422:
423:
424: -- Step 4: Collection of Yield data into temp table
425: if g_debug = 1 then
426: fnd_file.put_line (fnd_file.log,
427: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
428: fnd_file.put_line(fnd_file.log, 'Before Stage 4');
429: end if ;
430: --dbms_output.put_line (to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));

Line 428: fnd_file.put_line(fnd_file.log, 'Before Stage 4');

424: -- Step 4: Collection of Yield data into temp table
425: if g_debug = 1 then
426: fnd_file.put_line (fnd_file.log,
427: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
428: fnd_file.put_line(fnd_file.log, 'Before Stage 4');
429: end if ;
430: --dbms_output.put_line (to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
431: --dbms_output.put_line('Before Stage 4');
432:

Line 454: fnd_file.put_line (fnd_file.log,

450:
451: -- Step 5: Populate efficiency, resource, utilization data into
452: -- summary table
453: if g_debug = 1 then
454: fnd_file.put_line (fnd_file.log,
455: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
456: fnd_file.put_line(fnd_file.log, 'Before Stage 5');
457: end if ;
458: --dbms_output.put_line (to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));

Line 456: fnd_file.put_line(fnd_file.log, 'Before Stage 5');

452: -- summary table
453: if g_debug = 1 then
454: fnd_file.put_line (fnd_file.log,
455: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
456: fnd_file.put_line(fnd_file.log, 'Before Stage 5');
457: end if ;
458: --dbms_output.put_line (to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
459: --dbms_output.put_line('Before Stage 5');
460:

Line 476: fnd_file.put_line (fnd_file.log,

472:
473: -- Step 6: Move the resource yield information into its
474: -- summary table.
475: if g_debug = 1 then
476: fnd_file.put_line (fnd_file.log,
477: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
478: fnd_file.put_line(fnd_file.log, 'Before Stage 6');
479: end if ;
480: --dbms_output.put_line (to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));

Line 478: fnd_file.put_line(fnd_file.log, 'Before Stage 6');

474: -- summary table.
475: if g_debug = 1 then
476: fnd_file.put_line (fnd_file.log,
477: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
478: fnd_file.put_line(fnd_file.log, 'Before Stage 6');
479: end if ;
480: --dbms_output.put_line (to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
481: --dbms_output.put_line('Before Stage 6');
482:

Line 500: fnd_file.put_line (fnd_file.log,

496:
497: -- Stage 8: Collect and populate the assembly yield data into
498: -- summary table
499: if g_debug = 1 then
500: fnd_file.put_line (fnd_file.log,
501: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
502: fnd_file.put_line(fnd_file.log, 'Before Stage 8');
503: end if ;
504: --dbms_output.put_line (to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));

Line 502: fnd_file.put_line(fnd_file.log, 'Before Stage 8');

498: -- summary table
499: if g_debug = 1 then
500: fnd_file.put_line (fnd_file.log,
501: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
502: fnd_file.put_line(fnd_file.log, 'Before Stage 8');
503: end if ;
504: --dbms_output.put_line (to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
505: --dbms_output.put_line('Before Stage 8');
506:

Line 526: fnd_file.put_line (fnd_file.log,

522:
523: -- Stage 9: Clean up all temp tables since all data has been
524: -- transferred to summary tables.
525: if g_debug = 1 then
526: fnd_file.put_line (fnd_file.log,
527: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
528: fnd_file.put_line(fnd_file.log, 'Before Stage 9');
529: end if ;
530: --dbms_output.put_line (to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));

Line 528: fnd_file.put_line(fnd_file.log, 'Before Stage 9');

524: -- transferred to summary tables.
525: if g_debug = 1 then
526: fnd_file.put_line (fnd_file.log,
527: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
528: fnd_file.put_line(fnd_file.log, 'Before Stage 9');
529: end if ;
530: --dbms_output.put_line (to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
531: --dbms_output.put_line('Before Stage 9');
532:

Line 547: fnd_file.put_line (fnd_file.log,

543:
544: -- Stage 10: Denormalize the organization, item, time and
545: -- geographical location info in the summary tables.
546: if g_debug = 1 then
547: fnd_file.put_line (fnd_file.log,
548: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
549: fnd_file.put_line(fnd_file.log, 'Before Stage 10');
550: end if ;
551: --dbms_output.put_line (to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));

Line 549: fnd_file.put_line(fnd_file.log, 'Before Stage 10');

545: -- geographical location info in the summary tables.
546: if g_debug = 1 then
547: fnd_file.put_line (fnd_file.log,
548: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
549: fnd_file.put_line(fnd_file.log, 'Before Stage 10');
550: end if ;
551: --dbms_output.put_line (to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
552: --dbms_output.put_line('Before Stage 10');
553:

Line 573: fnd_file.put_line (fnd_file.log,

569: -- and wip_bis_prod_dept_yield_v.
570: -- Bugfix 3387800.
571:
572: if g_debug = 1 then
573: fnd_file.put_line (fnd_file.log,
574: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
575: fnd_file.put_line(fnd_file.log, 'Before Stage 10.5');
576: end if ;
577:

Line 575: fnd_file.put_line(fnd_file.log, 'Before Stage 10.5');

571:
572: if g_debug = 1 then
573: fnd_file.put_line (fnd_file.log,
574: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
575: fnd_file.put_line(fnd_file.log, 'Before Stage 10.5');
576: end if ;
577:
578: update_existing_flag (p_errnum => p_errnum,
579: p_errmesg => p_errmesg);

Line 591: fnd_file.put_line (fnd_file.log,

587: -- Stage 11: Merge back data from previous runs that was not
588: -- recollected. This was not part of the original functionality
589: -- of the program, but was added later.
590: if g_debug = 1 then
591: fnd_file.put_line (fnd_file.log,
592: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
593: fnd_file.put_line(fnd_file.log, 'Before Stage 11');
594: end if ;
595: --dbms_output.put_line (to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));

Line 593: fnd_file.put_line(fnd_file.log, 'Before Stage 11');

589: -- of the program, but was added later.
590: if g_debug = 1 then
591: fnd_file.put_line (fnd_file.log,
592: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
593: fnd_file.put_line(fnd_file.log, 'Before Stage 11');
594: end if ;
595: --dbms_output.put_line (to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
596: --dbms_output.put_line('Before Stage 11');
597:

Line 615: fnd_file.put_line(fnd_file.log, 'Before Stage 12');

611: commit;
612:
613: -- Stage 12: Delete the temp staging table, wip_indicators_temp.
614: if g_debug = 1 then
615: fnd_file.put_line(fnd_file.log, 'Before Stage 12');
616: fnd_file.put_line (fnd_file.log,
617: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
618: end if ;
619: --dbms_output.put_line (to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));

Line 616: fnd_file.put_line (fnd_file.log,

612:
613: -- Stage 12: Delete the temp staging table, wip_indicators_temp.
614: if g_debug = 1 then
615: fnd_file.put_line(fnd_file.log, 'Before Stage 12');
616: fnd_file.put_line (fnd_file.log,
617: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
618: end if ;
619: --dbms_output.put_line (to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
620: --dbms_output.put_line('Before Stage 12');

Line 626: fnd_file.put_line (fnd_file.log,

622: -- Delete any existing data with this group ID
623: Delete_Temp_Info(p_group_id => x_group_id);
624: commit ;
625:
626: fnd_file.put_line (fnd_file.log,
627: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
628: fnd_file.put_line (fnd_file.log,
629: 'Capture Production indicators has terminated successfully.');
630: fnd_file.put_line (fnd_file.log,

Line 628: fnd_file.put_line (fnd_file.log,

624: commit ;
625:
626: fnd_file.put_line (fnd_file.log,
627: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
628: fnd_file.put_line (fnd_file.log,
629: 'Capture Production indicators has terminated successfully.');
630: fnd_file.put_line (fnd_file.log,
631: 'Dates collected: ' ||
632: to_char (x_date_from, 'DD-MON-YYYY') || ' to ' ||

Line 630: fnd_file.put_line (fnd_file.log,

626: fnd_file.put_line (fnd_file.log,
627: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
628: fnd_file.put_line (fnd_file.log,
629: 'Capture Production indicators has terminated successfully.');
630: fnd_file.put_line (fnd_file.log,
631: 'Dates collected: ' ||
632: to_char (x_date_from, 'DD-MON-YYYY') || ' to ' ||
633: to_char (x_date_to, 'DD-MON-YYYY'));
634: p_errnum := 0;

Line 646: fnd_file.put_line(fnd_file.log, SQLCODE);

642:
643: when collection_stage_failed then
644:
645: if g_debug = 1 then
646: fnd_file.put_line(fnd_file.log, SQLCODE);
647: fnd_file.put_line(fnd_file.log,SQLERRM);
648: fnd_file.put_line (fnd_file.log,
649: 'A collection stage has failed. ' ||
650: 'All data starting from ' || x_date_from ||

Line 647: fnd_file.put_line(fnd_file.log,SQLERRM);

643: when collection_stage_failed then
644:
645: if g_debug = 1 then
646: fnd_file.put_line(fnd_file.log, SQLCODE);
647: fnd_file.put_line(fnd_file.log,SQLERRM);
648: fnd_file.put_line (fnd_file.log,
649: 'A collection stage has failed. ' ||
650: 'All data starting from ' || x_date_from ||
651: ' is being purged and must be recollected.'

Line 648: fnd_file.put_line (fnd_file.log,

644:
645: if g_debug = 1 then
646: fnd_file.put_line(fnd_file.log, SQLCODE);
647: fnd_file.put_line(fnd_file.log,SQLERRM);
648: fnd_file.put_line (fnd_file.log,
649: 'A collection stage has failed. ' ||
650: 'All data starting from ' || x_date_from ||
651: ' is being purged and must be recollected.'
652: );

Line 684: fnd_file.put_line(fnd_file.log, SQLCODE);

680:
681: when others then
682:
683: if g_debug = 1 then
684: fnd_file.put_line(fnd_file.log, SQLCODE);
685: fnd_file.put_line(fnd_file.log, SQLERRM);
686: fnd_file.put_line(fnd_file.log,'Clean up of collected/staged data');
687: end if ;
688: --dbms_output.put_line(SQLCODE);

Line 685: fnd_file.put_line(fnd_file.log, SQLERRM);

681: when others then
682:
683: if g_debug = 1 then
684: fnd_file.put_line(fnd_file.log, SQLCODE);
685: fnd_file.put_line(fnd_file.log, SQLERRM);
686: fnd_file.put_line(fnd_file.log,'Clean up of collected/staged data');
687: end if ;
688: --dbms_output.put_line(SQLCODE);
689: --dbms_output.put_line(SQLERRM);

Line 686: fnd_file.put_line(fnd_file.log,'Clean up of collected/staged data');

682:
683: if g_debug = 1 then
684: fnd_file.put_line(fnd_file.log, SQLCODE);
685: fnd_file.put_line(fnd_file.log, SQLERRM);
686: fnd_file.put_line(fnd_file.log,'Clean up of collected/staged data');
687: end if ;
688: --dbms_output.put_line(SQLCODE);
689: --dbms_output.put_line(SQLERRM);
690:

Line 813: fnd_file.put_line(fnd_file.log, 'Before Stage 2 Phase I');

809:
810: -- Phase I: Calculate Standard Quantities
811: x_phase := 'I';
812: if g_debug = 1 then
813: fnd_file.put_line(fnd_file.log, 'Before Stage 2 Phase I');
814: end if ;
815: ----dbms_output.put_line('Before Stage 2 Phase I');
816:
817: -- Calculate the Standard Quantities for the various departments

Line 830: fnd_file.put_line(fnd_file.log, 'Before Stage 2 Phase II');

826:
827: -- Phase II: Calculate Std Units
828: x_phase := 'II' ;
829: if g_debug = 1 then
830: fnd_file.put_line(fnd_file.log, 'Before Stage 2 Phase II');
831: end if ;
832: ----dbms_output.put_line('Before Stage 2 Phase II');
833:
834: -- Calculate the standard units for the various resources in the

Line 847: fnd_file.put_line(fnd_file.log, 'Before Stage 2 Phase III');

843:
844: -- Phase III: Calculate efficiency applied units
845: x_phase := 'III';
846: if g_debug = 1 then
847: fnd_file.put_line(fnd_file.log, 'Before Stage 2 Phase III');
848: end if ;
849:
850: -- Calculate the Efficiency applied units.
851: -- Technically this function should not being doing anything

Line 863: fnd_file.put_line(fnd_file.log, 'Before Stage 2 Phase IV');

859:
860: -- Phase IV: Calculate miscellaneous applied units.
861: x_phase := 'IV';
862: if g_debug = 1 then
863: fnd_file.put_line(fnd_file.log, 'Before Stage 2 Phase IV');
864: end if ;
865: ----dbms_output.put_line('Before Stage 2 Phase IV');
866:
867: /*

Line 898: fnd_file.put_line(fnd_file.log,'Failed in Stage 2 phase : '||x_phase);

894:
895: WHEN OTHERS THEN
896:
897: if g_debug = 1 then
898: fnd_file.put_line(fnd_file.log,'Failed in Stage 2 phase : '||x_phase);
899: fnd_file.put_line(fnd_file.log, to_char(SQLCODE));
900: fnd_file.put_line(fnd_file.log,SQLERRM);
901: end if ;
902:

Line 899: fnd_file.put_line(fnd_file.log, to_char(SQLCODE));

895: WHEN OTHERS THEN
896:
897: if g_debug = 1 then
898: fnd_file.put_line(fnd_file.log,'Failed in Stage 2 phase : '||x_phase);
899: fnd_file.put_line(fnd_file.log, to_char(SQLCODE));
900: fnd_file.put_line(fnd_file.log,SQLERRM);
901: end if ;
902:
903: -- to make sure there is no garbage returned to SFCB,

Line 900: fnd_file.put_line(fnd_file.log,SQLERRM);

896:
897: if g_debug = 1 then
898: fnd_file.put_line(fnd_file.log,'Failed in Stage 2 phase : '||x_phase);
899: fnd_file.put_line(fnd_file.log, to_char(SQLCODE));
900: fnd_file.put_line(fnd_file.log,SQLERRM);
901: end if ;
902:
903: -- to make sure there is no garbage returned to SFCB,
904: -- truncate wip_indicators_temp

Line 1051: fnd_file.put_line(fnd_file.log, 'Before Stage 3 Phase I');

1047:
1048: -- Phase I: calculate the resource availability for each org
1049: x_phase := 'I';
1050: if g_debug = 1 then
1051: fnd_file.put_line(fnd_file.log, 'Before Stage 3 Phase I');
1052: end if ;
1053: --dbms_output.put_line('Before Stage 3 Phase I');
1054:
1055: -- Populate the fresh resource availability data into the

Line 1103: fnd_file.put_line(fnd_file.log, 'Before Stage 3 Phase II');

1099: -- Phase II: Pre-aggregate resource availability info
1100: -- for quick access in later SQLs since MNRA is a big table.
1101: x_phase := 'II';
1102: if g_debug = 1 then
1103: fnd_file.put_line(fnd_file.log, 'Before Stage 3 Phase II');
1104: end if ;
1105: --dbms_output.put_line('Before Stage 3 Phase II');
1106:
1107: -- Pre-aggregate all the information needed from

Line 1206: fnd_file.put_line(fnd_file.log, 'Before Stage 3 Phase III');

1202: end if;
1203: -- Phase III: Insert all the utilization data into the temp table.
1204: x_phase := 'III';
1205: if g_debug = 1 then
1206: fnd_file.put_line(fnd_file.log, 'Before Stage 3 Phase III');
1207: end if ;
1208: --dbms_output.put_line('Before Stage 3 Phase III');
1209:
1210: -- Insert all the data into the wip_indicators_temp table.

Line 1323: fnd_file.put_line(fnd_file.log, 'Before Stage 3 Phase IV');

1319: End If;
1320: -- Phase IV: SFCB
1321: x_phase := 'IV';
1322: if g_debug = 1 then
1323: fnd_file.put_line(fnd_file.log, 'Before Stage 3 Phase IV');
1324: end if ;
1325: --dbms_output.put_line('Before Stage 3 Phase IV');
1326: IF (p_sfcb IS NOT NULL) THEN
1327:

Line 1398: fnd_file.put_line(fnd_file.log,

1394: WHEN OTHERS THEN
1395:
1396: if g_debug = 1 then
1397: if x_org_id <> 0 then
1398: fnd_file.put_line(fnd_file.log,
1399: 'Failed in Stage 3 phase : '||x_phase ||
1400: ' for Organization Id : ' ||
1401: to_char(x_org_id) );
1402:

Line 1408: fnd_file.put_line(fnd_file.log,

1404: -- x_phase ||
1405: -- ' for Organization Id : ' ||
1406: -- to_char(x_org_id) );
1407: else
1408: fnd_file.put_line(fnd_file.log,
1409: 'Failed in Stage 3 phase : '||x_phase);
1410: end if;
1411: fnd_file.put_line(fnd_file.log, SQLCODE);
1412: fnd_file.put_line(fnd_file.log,SQLERRM);

Line 1411: fnd_file.put_line(fnd_file.log, SQLCODE);

1407: else
1408: fnd_file.put_line(fnd_file.log,
1409: 'Failed in Stage 3 phase : '||x_phase);
1410: end if;
1411: fnd_file.put_line(fnd_file.log, SQLCODE);
1412: fnd_file.put_line(fnd_file.log,SQLERRM);
1413: end if ;
1414:
1415: --dbms_output.put_line('Failed in Stage 3 phase : '||x_phase);

Line 1412: fnd_file.put_line(fnd_file.log,SQLERRM);

1408: fnd_file.put_line(fnd_file.log,
1409: 'Failed in Stage 3 phase : '||x_phase);
1410: end if;
1411: fnd_file.put_line(fnd_file.log, SQLCODE);
1412: fnd_file.put_line(fnd_file.log,SQLERRM);
1413: end if ;
1414:
1415: --dbms_output.put_line('Failed in Stage 3 phase : '||x_phase);
1416: --dbms_output.put_line(SQLCODE);

Line 1548: fnd_file.put_line(fnd_file.log, 'Before Stage 4 Phase I');

1544: -- Phase I: Calculate the Total Quantities Produced
1545: -- by the various departments
1546: x_phase := 'I';
1547: if g_debug = 1 then
1548: fnd_file.put_line(fnd_file.log, 'Before Stage 4 Phase I');
1549: end if ;
1550: ----dbms_output.put_line('Before Stage 4 Phase I');
1551:
1552: Calculate_Total_Quantity(

Line 1564: fnd_file.put_line(fnd_file.log, 'Before Stage 4 Phase II');

1560:
1561: -- Phase II: Calculate the Scrap Quantity by the various departments
1562: x_phase := 'II';
1563: if g_debug = 1 then
1564: fnd_file.put_line(fnd_file.log, 'Before Stage 4 Phase II');
1565: end if ;
1566: ----dbms_output.put_line('Before Stage 4 Phase II');
1567:
1568: Calculate_Scrap_Quantity(

Line 1585: fnd_file.put_line(fnd_file.log, 'Before Stage 4 Phase III');

1581:
1582: -- Phase III: Incorporate the resource information for the yield
1583: x_phase := 'III';
1584: if g_debug = 1 then
1585: fnd_file.put_line(fnd_file.log, 'Before Stage 4 Phase III');
1586: end if ;
1587: ----dbms_output.put_line('Before Stage 4 Phase III');
1588:
1589: Resource_Yield( p_group_id => x_group_id,

Line 1608: fnd_file.put_line(fnd_file.log,'Failed in Stage 4 phase : '||x_phase);

1604:
1605: when others then
1606:
1607: if g_debug = 1 then
1608: fnd_file.put_line(fnd_file.log,'Failed in Stage 4 phase : '||x_phase);
1609: fnd_file.put_line(fnd_file.log, SQLCODE);
1610: fnd_file.put_line(fnd_file.log,SQLERRM);
1611: end if ;
1612: ----dbms_output.put_line('Failed in Stage 4 phase : '||x_phase);

Line 1609: fnd_file.put_line(fnd_file.log, SQLCODE);

1605: when others then
1606:
1607: if g_debug = 1 then
1608: fnd_file.put_line(fnd_file.log,'Failed in Stage 4 phase : '||x_phase);
1609: fnd_file.put_line(fnd_file.log, SQLCODE);
1610: fnd_file.put_line(fnd_file.log,SQLERRM);
1611: end if ;
1612: ----dbms_output.put_line('Failed in Stage 4 phase : '||x_phase);
1613: ----dbms_output.put_line(SQLCODE);

Line 1610: fnd_file.put_line(fnd_file.log,SQLERRM);

1606:
1607: if g_debug = 1 then
1608: fnd_file.put_line(fnd_file.log,'Failed in Stage 4 phase : '||x_phase);
1609: fnd_file.put_line(fnd_file.log, SQLCODE);
1610: fnd_file.put_line(fnd_file.log,SQLERRM);
1611: end if ;
1612: ----dbms_output.put_line('Failed in Stage 4 phase : '||x_phase);
1613: ----dbms_output.put_line(SQLCODE);
1614: ----dbms_output.put_line(SQLERRM);

Line 1866: FND_FILE.PUT_LINE (fnd_file.log, proc_name || ':' || sqlerrm);

1862: EXCEPTION
1863:
1864: WHEN OTHERS
1865: THEN
1866: FND_FILE.PUT_LINE (fnd_file.log, proc_name || ':' || sqlerrm);
1867: RAISE; -- propagate to calling function
1868:
1869: END Calculate_Std_Quantity;
1870:

Line 1922: fnd_file.put_line(fnd_file.log,

1918: -- wip_entity_id, OP Seq, Dept, Res, Txn Date
1919: -- and insert into WIT
1920: x_step := 1;
1921: if g_debug = 1 then
1922: fnd_file.put_line(fnd_file.log,
1923: 'Before Stage 2 Phase II Step : ' || x_step);
1924: end if ;
1925: ----dbms_output.put_line('Before Stage 2 Phase II Step : ' || x_step);
1926:

Line 2023: fnd_file.put_line(fnd_file.log, 'Before Stage 2 Phase II Step : ' || x_step);

2019: -- for the first transaction across this particular
2020: -- resource.
2021: x_step := 2;
2022: if g_debug = 1 then
2023: fnd_file.put_line(fnd_file.log, 'Before Stage 2 Phase II Step : ' || x_step);
2024: end if ;
2025: ----dbms_output.put_line('Before Stage 2 Phase II Step : ' || x_step);
2026:
2027: delete from wip_indicators_temp wit

Line 2054: FND_FILE.PUT_LINE (fnd_file.log, proc_name || ':' || sqlerrm);

2050: EXCEPTION
2051:
2052: WHEN OTHERS
2053: THEN
2054: FND_FILE.PUT_LINE (fnd_file.log, proc_name || ':' || sqlerrm);
2055: p_errnum := -1;
2056: p_errmesg := (proc_name || ':' || sqlerrm);
2057: RAISE; -- propagate to calling function
2058:

Line 2114: FND_FILE.PUT_LINE (fnd_file.log, proc_name || ':' || sqlerrm);

2110: EXCEPTION
2111:
2112: WHEN OTHERS
2113: THEN
2114: FND_FILE.PUT_LINE (fnd_file.log, proc_name || ':' || sqlerrm);
2115: p_errnum := -1;
2116: p_errmesg := (proc_name || ':' || sqlerrm);
2117: RAISE; -- propagate to calling function
2118:

Line 2229: FND_FILE.PUT_LINE (fnd_file.log, proc_name || ':' || sqlerrm);

2225: EXCEPTION
2226:
2227: WHEN OTHERS
2228: THEN
2229: FND_FILE.PUT_LINE (fnd_file.log, proc_name || ':' || sqlerrm);
2230: p_errnum := -1;
2231: p_errmesg := (proc_name || ':' || sqlerrm);
2232: RAISE; -- propagate to calling function
2233:

Line 2456: FND_FILE.PUT_LINE (fnd_file.log, proc_name || ':' || sqlerrm);

2452: EXCEPTION
2453:
2454: WHEN OTHERS
2455: THEN
2456: FND_FILE.PUT_LINE (fnd_file.log, proc_name || ':' || sqlerrm);
2457: RAISE; -- propagate to calling function
2458:
2459: END Calculate_Total_Quantity;
2460:

Line 2519: fnd_file.put_line(fnd_file.log, 'Before Stage 4 Phase II Step : ' || x_step);

2515: proc_name := 'Calculate_Scrap_Quantity';
2516: -- Step 1:
2517: x_step := 1;
2518: if g_debug = 1 then
2519: fnd_file.put_line(fnd_file.log, 'Before Stage 4 Phase II Step : ' || x_step);
2520: end if ;
2521: ----dbms_output.put_line('Before Stage 4 Phase II Step : ' || x_step);
2522:
2523: -- Update the Scrap Quantitied for the various departments.

Line 2559: fnd_file.put_line(fnd_file.log, 'Before Stage 4 Phase II Step : '

2555: -- Take into account the scrap quantities that are moved from one
2556: -- department to the other
2557: x_step := 2;
2558: if g_debug = 1 then
2559: fnd_file.put_line(fnd_file.log, 'Before Stage 4 Phase II Step : '
2560: || x_step);
2561: end if ;
2562: ----dbms_output.put_line('Before Stage 4 Phase II Step : ' || x_step);
2563: FOR Adj_Rec IN Scrap_Adjustment(

Line 2625: FND_FILE.PUT_LINE (fnd_file.log, proc_name || ':' || sqlerrm);

2621: EXCEPTION
2622:
2623: WHEN OTHERS
2624: THEN
2625: FND_FILE.PUT_LINE (fnd_file.log, proc_name || ':' || sqlerrm);
2626: p_errnum := -1;
2627: p_errmesg := (proc_name || ':' || sqlerrm);
2628: RAISE; -- propagate to calling function
2629:

Line 2739: FND_FILE.PUT_LINE (fnd_file.log, proc_name || ':' || sqlerrm);

2735: EXCEPTION
2736:
2737: WHEN OTHERS
2738: THEN
2739: FND_FILE.PUT_LINE (fnd_file.log, proc_name || ':' || sqlerrm);
2740: p_errnum := -1;
2741: p_errmesg := (proc_name || ':' || sqlerrm);
2742: RAISE; -- propagate to calling function
2743:

Line 2780: fnd_file.put_line (fnd_file.log,

2776: -- Phase I: Move records that have utilization, yield and
2777: -- efficiency info into summary table.
2778: x_phase := 'I';
2779: if g_debug = 1 then
2780: fnd_file.put_line (fnd_file.log,
2781: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
2782: fnd_file.put_line(fnd_file.log, 'Before Stage 5 Phase I');
2783: end if ;
2784: --dbms_output.put_line (to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));

Line 2782: fnd_file.put_line(fnd_file.log, 'Before Stage 5 Phase I');

2778: x_phase := 'I';
2779: if g_debug = 1 then
2780: fnd_file.put_line (fnd_file.log,
2781: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
2782: fnd_file.put_line(fnd_file.log, 'Before Stage 5 Phase I');
2783: end if ;
2784: --dbms_output.put_line (to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
2785: --dbms_output.put_line('Before Stage 5 Phase I');
2786:

Line 2798: fnd_file.put_line (fnd_file.log,

2794: -- for all the org_id, wip_id, op_seq, dept_id, res_id,
2795: -- txn_date that did not get moved in Phase I
2796: x_phase := 'II';
2797: if g_debug = 1 then
2798: fnd_file.put_line (fnd_file.log,
2799: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
2800: fnd_file.put_line(fnd_file.log, 'Before Stage 5 Phase II');
2801: end if ;
2802: --dbms_output.put_line (to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));

Line 2800: fnd_file.put_line(fnd_file.log, 'Before Stage 5 Phase II');

2796: x_phase := 'II';
2797: if g_debug = 1 then
2798: fnd_file.put_line (fnd_file.log,
2799: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
2800: fnd_file.put_line(fnd_file.log, 'Before Stage 5 Phase II');
2801: end if ;
2802: --dbms_output.put_line (to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
2803: --dbms_output.put_line('Before Stage 5 Phase II');
2804:

Line 2876: fnd_file.put_line (fnd_file.log,

2872: -- the summary table for the new efficiency records added.
2873:
2874: x_phase := 'III';
2875: if g_debug = 1 then
2876: fnd_file.put_line (fnd_file.log,
2877: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
2878: fnd_file.put_line(fnd_file.log, 'Before Stage 5 Phase III');
2879: end if ;
2880: --dbms_output.put_line (to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));

Line 2878: fnd_file.put_line(fnd_file.log, 'Before Stage 5 Phase III');

2874: x_phase := 'III';
2875: if g_debug = 1 then
2876: fnd_file.put_line (fnd_file.log,
2877: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
2878: fnd_file.put_line(fnd_file.log, 'Before Stage 5 Phase III');
2879: end if ;
2880: --dbms_output.put_line (to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
2881: --dbms_output.put_line('Before Stage 5 Phase III');
2882:

Line 2931: fnd_file.put_line (fnd_file.log,

2927: -- Update Yield/Scrap information into
2928: -- the summary table for the new efficiency records added
2929: x_phase := 'IV';
2930: if g_debug = 1 then
2931: fnd_file.put_line (fnd_file.log,
2932: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
2933: fnd_file.put_line(fnd_file.log, 'Before Stage 5 Phase IV');
2934: end if ;
2935: --dbms_output.put_line (to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));

Line 2933: fnd_file.put_line(fnd_file.log, 'Before Stage 5 Phase IV');

2929: x_phase := 'IV';
2930: if g_debug = 1 then
2931: fnd_file.put_line (fnd_file.log,
2932: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
2933: fnd_file.put_line(fnd_file.log, 'Before Stage 5 Phase IV');
2934: end if ;
2935: --dbms_output.put_line (to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
2936: --dbms_output.put_line('Before Stage 5 Phase IV');
2937:

Line 2961: fnd_file.put_line (fnd_file.log,

2957: -- Phase V:
2958: -- Insert all utilization records that have not been inserted yet.
2959: x_phase := 'V';
2960: if g_debug = 1 then
2961: fnd_file.put_line (fnd_file.log,
2962: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
2963: fnd_file.put_line(fnd_file.log, 'Before Stage 5 Phase V');
2964: end if ;
2965: --dbms_output.put_line (to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));

Line 2963: fnd_file.put_line(fnd_file.log, 'Before Stage 5 Phase V');

2959: x_phase := 'V';
2960: if g_debug = 1 then
2961: fnd_file.put_line (fnd_file.log,
2962: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
2963: fnd_file.put_line(fnd_file.log, 'Before Stage 5 Phase V');
2964: end if ;
2965: --dbms_output.put_line (to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
2966: --dbms_output.put_line('Before Stage 5 Phase V');
2967:

Line 3037: fnd_file.put_line (fnd_file.log,

3033: -- the summary table for the new utilization records added
3034:
3035: x_phase := 'VI';
3036: if g_debug = 1 then
3037: fnd_file.put_line (fnd_file.log,
3038: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
3039: fnd_file.put_line(fnd_file.log, 'Before Stage 5 Phase VI');
3040: end if ;
3041: --dbms_output.put_line (to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));

Line 3039: fnd_file.put_line(fnd_file.log, 'Before Stage 5 Phase VI');

3035: x_phase := 'VI';
3036: if g_debug = 1 then
3037: fnd_file.put_line (fnd_file.log,
3038: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
3039: fnd_file.put_line(fnd_file.log, 'Before Stage 5 Phase VI');
3040: end if ;
3041: --dbms_output.put_line (to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
3042: --dbms_output.put_line('Before Stage 5 Phase VI');
3043:

Line 3069: fnd_file.put_line(fnd_file.log, 'Before Stage 5 Phase VII');

3065: -- into the summary table.
3066:
3067: x_phase := 'VII';
3068: if g_debug = 1 then
3069: fnd_file.put_line(fnd_file.log, 'Before Stage 5 Phase VII');
3070: fnd_file.put_line (fnd_file.log,
3071: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
3072: end if ;
3073: --dbms_output.put_line (to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));

Line 3070: fnd_file.put_line (fnd_file.log,

3066:
3067: x_phase := 'VII';
3068: if g_debug = 1 then
3069: fnd_file.put_line(fnd_file.log, 'Before Stage 5 Phase VII');
3070: fnd_file.put_line (fnd_file.log,
3071: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
3072: end if ;
3073: --dbms_output.put_line (to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
3074: --dbms_output.put_line('Before Stage 5 Phase VII');

Line 3147: fnd_file.put_line(fnd_file.log, 'Before Stage 5 Phase VIII');

3143: -- the Summary table wip_bis_prod_indicators
3144:
3145: x_phase := 'VIII';
3146: if g_debug = 1 then
3147: fnd_file.put_line(fnd_file.log, 'Before Stage 5 Phase VIII');
3148: fnd_file.put_line (fnd_file.log,
3149: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
3150: end if ;
3151: --dbms_output.put_line (to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));

Line 3148: fnd_file.put_line (fnd_file.log,

3144:
3145: x_phase := 'VIII';
3146: if g_debug = 1 then
3147: fnd_file.put_line(fnd_file.log, 'Before Stage 5 Phase VIII');
3148: fnd_file.put_line (fnd_file.log,
3149: to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
3150: end if ;
3151: --dbms_output.put_line (to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
3152: --dbms_output.put_line('Before Stage 5 Phase VIII');

Line 3171: fnd_file.put_line(fnd_file.log,

3167:
3168: when others then
3169:
3170: if g_debug = 1 then
3171: fnd_file.put_line(fnd_file.log,
3172: 'Failed in Move_Info_Into_Summary in Stage 5 phase : '
3173: ||x_phase);
3174: fnd_file.put_line(fnd_file.log, SQLCODE);
3175: fnd_file.put_line(fnd_file.log,SQLERRM);

Line 3174: fnd_file.put_line(fnd_file.log, SQLCODE);

3170: if g_debug = 1 then
3171: fnd_file.put_line(fnd_file.log,
3172: 'Failed in Move_Info_Into_Summary in Stage 5 phase : '
3173: ||x_phase);
3174: fnd_file.put_line(fnd_file.log, SQLCODE);
3175: fnd_file.put_line(fnd_file.log,SQLERRM);
3176: end if ;
3177:
3178: -- dbms_output.put_line('Failed in Stage 5 phase : '||x_phase);

Line 3175: fnd_file.put_line(fnd_file.log,SQLERRM);

3171: fnd_file.put_line(fnd_file.log,
3172: 'Failed in Move_Info_Into_Summary in Stage 5 phase : '
3173: ||x_phase);
3174: fnd_file.put_line(fnd_file.log, SQLCODE);
3175: fnd_file.put_line(fnd_file.log,SQLERRM);
3176: end if ;
3177:
3178: -- dbms_output.put_line('Failed in Stage 5 phase : '||x_phase);
3179: -- dbms_output.put_line(SQLCODE);

Line 3212: fnd_file.put_line(fnd_file.log, 'Before Stage 6 Phase I');

3208: proc_name := 'Move_Yield_Info';
3209:
3210: x_phase := 'I';
3211: IF g_debug = 1 THEN
3212: fnd_file.put_line(fnd_file.log, 'Before Stage 6 Phase I');
3213: END IF ;
3214: ----dbms_output.put_line('Before Stage 6 Phase I');
3215:
3216: -- insert efficiency into the summary table

Line 3272: fnd_file.put_line(fnd_file.log,

3268:
3269: WHEN OTHERS THEN
3270:
3271: IF g_debug = 1 THEN
3272: fnd_file.put_line(fnd_file.log,
3273: 'Failed in Move_Yield_Info in Stage 6 phase : '||
3274: x_phase);
3275: fnd_file.put_line(fnd_file.log, SQLCODE);
3276: fnd_file.put_line(fnd_file.log,SQLERRM);

Line 3275: fnd_file.put_line(fnd_file.log, SQLCODE);

3271: IF g_debug = 1 THEN
3272: fnd_file.put_line(fnd_file.log,
3273: 'Failed in Move_Yield_Info in Stage 6 phase : '||
3274: x_phase);
3275: fnd_file.put_line(fnd_file.log, SQLCODE);
3276: fnd_file.put_line(fnd_file.log,SQLERRM);
3277: END IF ;
3278: ----dbms_output.put_line('Failed in Stage 6 phase : '||x_phase);
3279: ----dbms_output.put_line(SQLCODE);

Line 3276: fnd_file.put_line(fnd_file.log,SQLERRM);

3272: fnd_file.put_line(fnd_file.log,
3273: 'Failed in Move_Yield_Info in Stage 6 phase : '||
3274: x_phase);
3275: fnd_file.put_line(fnd_file.log, SQLCODE);
3276: fnd_file.put_line(fnd_file.log,SQLERRM);
3277: END IF ;
3278: ----dbms_output.put_line('Failed in Stage 6 phase : '||x_phase);
3279: ----dbms_output.put_line(SQLCODE);
3280: ----dbms_output.put_line(SQLERRM);

Line 3440: FND_FILE.PUT_LINE (fnd_file.log, proc_name || ':' || sqlerrm);

3436: EXCEPTION
3437:
3438: WHEN OTHERS
3439: THEN
3440: FND_FILE.PUT_LINE (fnd_file.log, proc_name || ':' || sqlerrm);
3441: p_errnum := -1;
3442: p_errmesg := (proc_name || ':' || sqlerrm);
3443: RAISE; -- propagate to calling function
3444:

Line 3480: fnd_file.put_line(fnd_file.log, 'Before Stage 7 Phase I');

3476: */
3477:
3478: x_phase := 'I';
3479: if g_debug = 1 then
3480: fnd_file.put_line(fnd_file.log, 'Before Stage 7 Phase I');
3481: end if ;
3482:
3483:
3484: FOR Org_Rec IN All_Orgs LOOP

Line 3580: fnd_file.put_line(fnd_file.log,'Failed in Stage 7 phase : '||x_phase ||

3576: exception
3577:
3578: when others then
3579: if g_debug = 1 then
3580: fnd_file.put_line(fnd_file.log,'Failed in Stage 7 phase : '||x_phase ||
3581: ' for Organization_id : '|| to_char(x_org_id) );
3582: fnd_file.put_line(fnd_file.log, SQLCODE);
3583: fnd_file.put_line(fnd_file.log,SQLERRM);
3584: end if ;

Line 3582: fnd_file.put_line(fnd_file.log, SQLCODE);

3578: when others then
3579: if g_debug = 1 then
3580: fnd_file.put_line(fnd_file.log,'Failed in Stage 7 phase : '||x_phase ||
3581: ' for Organization_id : '|| to_char(x_org_id) );
3582: fnd_file.put_line(fnd_file.log, SQLCODE);
3583: fnd_file.put_line(fnd_file.log,SQLERRM);
3584: end if ;
3585: ----dbms_output.put_line('Failed in Stage 7 phase : '||x_phase ||
3586: -- ' for Organization_id : ' || to_char(x_org_id));

Line 3583: fnd_file.put_line(fnd_file.log,SQLERRM);

3579: if g_debug = 1 then
3580: fnd_file.put_line(fnd_file.log,'Failed in Stage 7 phase : '||x_phase ||
3581: ' for Organization_id : '|| to_char(x_org_id) );
3582: fnd_file.put_line(fnd_file.log, SQLCODE);
3583: fnd_file.put_line(fnd_file.log,SQLERRM);
3584: end if ;
3585: ----dbms_output.put_line('Failed in Stage 7 phase : '||x_phase ||
3586: -- ' for Organization_id : ' || to_char(x_org_id));
3587: ----dbms_output.put_line(SQLCODE);

Line 3617: fnd_file.put_line(fnd_file.log, 'Before Stage 9 Phase I');

3613:
3614:
3615: x_phase := 'I';
3616: IF g_debug = 1 THEN
3617: fnd_file.put_line(fnd_file.log, 'Before Stage 9 Phase I');
3618: END IF ;
3619:
3620: -- clean out all the temp tables.
3621: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_wip_schema ||

Line 3634: fnd_file.put_line(fnd_file.log, 'After Stage 9 Phase I');

3630: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_wip_schema ||
3631: '.WIP_BIS_YLD_TEMP';
3632:
3633: IF g_debug = 1 THEN
3634: fnd_file.put_line(fnd_file.log, 'After Stage 9 Phase I');
3635: END IF ;
3636:
3637: p_errnum := 0;
3638: p_errmesg := '';

Line 3647: fnd_file.put_line(fnd_file.log,

3643:
3644: WHEN OTHERS THEN
3645:
3646: IF g_debug = 1 THEN
3647: fnd_file.put_line(fnd_file.log,
3648: 'Failed in Post_Move_Cleanup in Stage 9 phase : '||x_phase);
3649: fnd_file.put_line(fnd_file.log, SQLCODE);
3650: fnd_file.put_line(fnd_file.log,SQLERRM);
3651: END IF ;

Line 3649: fnd_file.put_line(fnd_file.log, SQLCODE);

3645:
3646: IF g_debug = 1 THEN
3647: fnd_file.put_line(fnd_file.log,
3648: 'Failed in Post_Move_Cleanup in Stage 9 phase : '||x_phase);
3649: fnd_file.put_line(fnd_file.log, SQLCODE);
3650: fnd_file.put_line(fnd_file.log,SQLERRM);
3651: END IF ;
3652: ----dbms_output.put_line('Failed in Stage 9 phase : '||x_phase);
3653: ----dbms_output.put_line(SQLCODE);

Line 3650: fnd_file.put_line(fnd_file.log,SQLERRM);

3646: IF g_debug = 1 THEN
3647: fnd_file.put_line(fnd_file.log,
3648: 'Failed in Post_Move_Cleanup in Stage 9 phase : '||x_phase);
3649: fnd_file.put_line(fnd_file.log, SQLCODE);
3650: fnd_file.put_line(fnd_file.log,SQLERRM);
3651: END IF ;
3652: ----dbms_output.put_line('Failed in Stage 9 phase : '||x_phase);
3653: ----dbms_output.put_line(SQLCODE);
3654: ----dbms_output.put_line(SQLERRM);

Line 3685: fnd_file.put_line(fnd_file.log,'Failed in Delete_Temp_Info.');

3681: '.WIP_INDICATORS_TEMP';
3682:
3683: EXCEPTION
3684: WHEN OTHERS THEN
3685: fnd_file.put_line(fnd_file.log,'Failed in Delete_Temp_Info.');
3686: fnd_file.put_line(fnd_file.log, SQLCODE);
3687: fnd_file.put_line(fnd_file.log,SQLERRM);
3688: ----dbms_output.put_line('Failed in Delete_Temp_Info. ');
3689: ----dbms_output.put_line(SQLCODE);

Line 3686: fnd_file.put_line(fnd_file.log, SQLCODE);

3682:
3683: EXCEPTION
3684: WHEN OTHERS THEN
3685: fnd_file.put_line(fnd_file.log,'Failed in Delete_Temp_Info.');
3686: fnd_file.put_line(fnd_file.log, SQLCODE);
3687: fnd_file.put_line(fnd_file.log,SQLERRM);
3688: ----dbms_output.put_line('Failed in Delete_Temp_Info. ');
3689: ----dbms_output.put_line(SQLCODE);
3690: ----dbms_output.put_line(SQLERRM);

Line 3687: fnd_file.put_line(fnd_file.log,SQLERRM);

3683: EXCEPTION
3684: WHEN OTHERS THEN
3685: fnd_file.put_line(fnd_file.log,'Failed in Delete_Temp_Info.');
3686: fnd_file.put_line(fnd_file.log, SQLCODE);
3687: fnd_file.put_line(fnd_file.log,SQLERRM);
3688: ----dbms_output.put_line('Failed in Delete_Temp_Info. ');
3689: ----dbms_output.put_line(SQLCODE);
3690: ----dbms_output.put_line(SQLERRM);
3691:

Line 3746: fnd_file.put_line(fnd_file.log,'Failed in pre-program Clean Up');

3742:
3743: WHEN OTHERS THEN
3744:
3745: IF g_debug = 1 THEN
3746: fnd_file.put_line(fnd_file.log,'Failed in pre-program Clean Up');
3747: fnd_file.put_line(fnd_file.log, SQLCODE);
3748: fnd_file.put_line(fnd_file.log,SQLERRM);
3749: END IF;
3750:

Line 3747: fnd_file.put_line(fnd_file.log, SQLCODE);

3743: WHEN OTHERS THEN
3744:
3745: IF g_debug = 1 THEN
3746: fnd_file.put_line(fnd_file.log,'Failed in pre-program Clean Up');
3747: fnd_file.put_line(fnd_file.log, SQLCODE);
3748: fnd_file.put_line(fnd_file.log,SQLERRM);
3749: END IF;
3750:
3751: ----dbms_output.put_line('Failed in pre-program Clean Up');

Line 3748: fnd_file.put_line(fnd_file.log,SQLERRM);

3744:
3745: IF g_debug = 1 THEN
3746: fnd_file.put_line(fnd_file.log,'Failed in pre-program Clean Up');
3747: fnd_file.put_line(fnd_file.log, SQLCODE);
3748: fnd_file.put_line(fnd_file.log,SQLERRM);
3749: END IF;
3750:
3751: ----dbms_output.put_line('Failed in pre-program Clean Up');
3752: ----dbms_output.put_line(SQLCODE);

Line 3816: fnd_file.put_line(fnd_file.log, 'Before Stage 8 Phase I');

3812: g_applicationid := x_appl_id ;
3813:
3814: x_phase := 'I';
3815: if g_debug = 1 then
3816: fnd_file.put_line(fnd_file.log, 'Before Stage 8 Phase I');
3817: end if ;
3818: ----dbms_output.put_line('Before Stage 8 Phase I');
3819:
3820:

Line 3865: fnd_file.put_line(fnd_file.log, 'Before Stage 8 Phase II');

3861:
3862:
3863: x_phase := 'II';
3864: IF g_debug = 1 THEN
3865: fnd_file.put_line(fnd_file.log, 'Before Stage 8 Phase II');
3866: END IF ;
3867: ----dbms_output.put_line('Before Stage 8 Phase II');
3868:
3869: /* We will not be interested in a movement transaction between

Line 3892: fnd_file.put_line(fnd_file.log, 'Before Stage 8 Phase III');

3888: -- AND wmt.to_intraoperation_step_type <> 5 )));
3889:
3890: x_phase := 'III';
3891: IF g_debug = 1 THEN
3892: fnd_file.put_line(fnd_file.log, 'Before Stage 8 Phase III');
3893: END IF ;
3894: ----dbms_output.put_line('Before Stage 8 Phase III');
3895:
3896: /* This SQL has a full table scan on wip_bis_prod_assy_yield

Line 3968: fnd_file.put_line(fnd_file.log, 'Before Stage 8 Phase IV');

3964: COMMIT ;
3965:
3966: x_phase := 'IV';
3967: IF g_debug = 1 THEN
3968: fnd_file.put_line(fnd_file.log, 'Before Stage 8 Phase IV');
3969: END IF ;
3970: ----dbms_output.put_line('Before Stage 8 Phase IV');
3971:
3972: COMMIT ;

Line 3984: fnd_file.put_line(fnd_file.log,

3980:
3981: WHEN OTHERS THEN
3982:
3983: IF g_debug = 1 THEN
3984: fnd_file.put_line(fnd_file.log,
3985: 'Failed in Populate_Assy_Yield in Stage 8 phase : '||x_phase);
3986: fnd_file.put_line(fnd_file.log, SQLCODE);
3987: fnd_file.put_line(fnd_file.log,SQLERRM);
3988: END IF ;

Line 3986: fnd_file.put_line(fnd_file.log, SQLCODE);

3982:
3983: IF g_debug = 1 THEN
3984: fnd_file.put_line(fnd_file.log,
3985: 'Failed in Populate_Assy_Yield in Stage 8 phase : '||x_phase);
3986: fnd_file.put_line(fnd_file.log, SQLCODE);
3987: fnd_file.put_line(fnd_file.log,SQLERRM);
3988: END IF ;
3989: ----dbms_output.put_line('Failed in Stage 8 phase : '||x_phase);
3990: ----dbms_output.put_line(SQLCODE);

Line 3987: fnd_file.put_line(fnd_file.log,SQLERRM);

3983: IF g_debug = 1 THEN
3984: fnd_file.put_line(fnd_file.log,
3985: 'Failed in Populate_Assy_Yield in Stage 8 phase : '||x_phase);
3986: fnd_file.put_line(fnd_file.log, SQLCODE);
3987: fnd_file.put_line(fnd_file.log,SQLERRM);
3988: END IF ;
3989: ----dbms_output.put_line('Failed in Stage 8 phase : '||x_phase);
3990: ----dbms_output.put_line(SQLCODE);
3991: ----dbms_output.put_line(SQLERRM);

Line 4056: fnd_file.put_line(fnd_file.log,

4052:
4053:
4054: IF (x_to_count = 0 ) OR (x_from_count = 0) THEN
4055: IF g_debug = 1 THEN
4056: fnd_file.put_line(fnd_file.log,
4057: 'Before the MRP calling Phase for Org Id : '
4058: || p_organization_id );
4059: END IF ;
4060:

Line 4219: fnd_file.put_line(fnd_file.log, 'Before Stage PROD Phase I');

4215:
4216:
4217: x_phase := 'I';
4218: /* if g_debug = 1 then
4219: fnd_file.put_line(fnd_file.log, 'Before Stage PROD Phase I');
4220: end if ;
4221: */
4222: --dbms_output.put_line('Before Stage PROD Phase I');
4223:

Line 4237: fnd_file.put_line(fnd_file.log, 'Before Stage PROD Phase II');

4233:
4234:
4235: x_phase := 'II';
4236: /* if g_debug = 1 then
4237: fnd_file.put_line(fnd_file.log, 'Before Stage PROD Phase II');
4238: end if ;
4239: */
4240: --dbms_output.put_line('Before Stage PROD Phase II');
4241:

Line 4252: fnd_file.put_line(fnd_file.log, 'Before Stage PROD Phase III');

4248:
4249:
4250: x_phase := 'III';
4251: /* if g_debug = 1 then
4252: fnd_file.put_line(fnd_file.log, 'Before Stage PROD Phase III');
4253: end if ;
4254: */
4255: --dbms_output.put_line('Before Stage PROD Phase III');
4256:

Line 4330: fnd_file.put_line(fnd_file.log, 'Before Stage PROD Phase IV');

4326: End If;
4327:
4328: x_phase := 'IV';
4329: /* if g_debug = 1 then
4330: fnd_file.put_line(fnd_file.log, 'Before Stage PROD Phase IV');
4331: end if ;
4332: */
4333: --dbms_output.put_line('Before Stage PROD Phase IV');
4334:

Line 4358: fnd_file.put_line(fnd_file.log, 'Before Stage PROD Phase V');

4354:
4355:
4356: x_phase := 'V';
4357: /* if g_debug = 1 then
4358: fnd_file.put_line(fnd_file.log, 'Before Stage PROD Phase V');
4359: end if ;
4360: */
4361: --dbms_output.put_line('Before Stage PROD Phase V');
4362:

Line 4378: fnd_file.put_line(fnd_file.log, 'Before Stage PROD Phase VI');

4374:
4375:
4376: x_phase := 'VI';
4377: /* if g_debug = 1 then
4378: fnd_file.put_line(fnd_file.log, 'Before Stage PROD Phase VI');
4379: end if ;
4380: */
4381: --dbms_output.put_line('Before Stage PROD Phase VI');
4382:

Line 4414: fnd_file.put_line(fnd_file.log, 'Before Stage PROD Phase VII');

4410:
4411:
4412: x_phase := 'VII';
4413: /* if g_debug = 1 then
4414: fnd_file.put_line(fnd_file.log, 'Before Stage PROD Phase VII');
4415: end if ;
4416: */
4417: --dbms_output.put_line('Before Stage PROD Phase VII');
4418:

Line 4516: fnd_file.put_line(fnd_file.log,'Failed in Productivity phase : '||x_phase);

4512: EXCEPTION
4513: WHEN OTHERS THEN
4514: /*
4515: if g_debug = 1 then
4516: fnd_file.put_line(fnd_file.log,'Failed in Productivity phase : '||x_phase);
4517: fnd_file.put_line(fnd_file.log, SQLCODE);
4518: fnd_file.put_line(fnd_file.log,SQLERRM);
4519: end if ;
4520: */

Line 4517: fnd_file.put_line(fnd_file.log, SQLCODE);

4513: WHEN OTHERS THEN
4514: /*
4515: if g_debug = 1 then
4516: fnd_file.put_line(fnd_file.log,'Failed in Productivity phase : '||x_phase);
4517: fnd_file.put_line(fnd_file.log, SQLCODE);
4518: fnd_file.put_line(fnd_file.log,SQLERRM);
4519: end if ;
4520: */
4521: --dbms_output.put_line('Failed in Productivity phase : '||x_phase);

Line 4518: fnd_file.put_line(fnd_file.log,SQLERRM);

4514: /*
4515: if g_debug = 1 then
4516: fnd_file.put_line(fnd_file.log,'Failed in Productivity phase : '||x_phase);
4517: fnd_file.put_line(fnd_file.log, SQLCODE);
4518: fnd_file.put_line(fnd_file.log,SQLERRM);
4519: end if ;
4520: */
4521: --dbms_output.put_line('Failed in Productivity phase : '||x_phase);
4522: --dbms_output.put_line(SQLCODE);

Line 4711: fnd_file.put_line(fnd_file.log, 'Before Stage RL Phase I');

4707: -- from SFCB dsoosai 11/10/98
4708:
4709: x_phase := 'I';
4710: /* if g_debug = 1 then
4711: fnd_file.put_line(fnd_file.log, 'Before Stage RL Phase I');
4712: end if ;
4713: */
4714: --dbms_output.put_line('Before Stage RL Phase I');
4715:

Line 4738: fnd_file.put_line(fnd_file.log, 'Before Stage RL Phase II');

4734:
4735: x_phase := 'II';
4736: /*
4737: if g_debug = 1 then
4738: fnd_file.put_line(fnd_file.log, 'Before Stage RL Phase II');
4739: end if ;
4740: */
4741:
4742: insert into wip_indicators_temp (

Line 4861: fnd_file.put_line(fnd_file.log, 'Before Stage RL Phase III');

4857:
4858: /*
4859: x_phase := 'III';
4860: if g_debug = 1 then
4861: fnd_file.put_line(fnd_file.log, 'Before Stage RL Phase III');
4862: end if ;
4863: */
4864:
4865:

Line 4901: fnd_file.put_line(fnd_file.log, 'Before Stage RL Phase IV');

4897:
4898: /*
4899: x_phase := 'IV';
4900: if g_debug = 1 then
4901: fnd_file.put_line(fnd_file.log, 'Before Stage RL Phase IV');
4902: end if ;
4903: */
4904:
4905:

Line 5000: fnd_file.put_line(fnd_file.log,'Failed in Resource Load phase : '||x_phase);

4996: EXCEPTION
4997: WHEN OTHERS THEN
4998: /*
4999: if g_debug = 1 then
5000: fnd_file.put_line(fnd_file.log,'Failed in Resource Load phase : '||x_phase);
5001: fnd_file.put_line(fnd_file.log, SQLCODE);
5002: fnd_file.put_line(fnd_file.log,SQLERRM);
5003: end if ;
5004: */

Line 5001: fnd_file.put_line(fnd_file.log, SQLCODE);

4997: WHEN OTHERS THEN
4998: /*
4999: if g_debug = 1 then
5000: fnd_file.put_line(fnd_file.log,'Failed in Resource Load phase : '||x_phase);
5001: fnd_file.put_line(fnd_file.log, SQLCODE);
5002: fnd_file.put_line(fnd_file.log,SQLERRM);
5003: end if ;
5004: */
5005: --dbms_output.put_line('Failed in Resource Load phase : '||x_phase);

Line 5002: fnd_file.put_line(fnd_file.log,SQLERRM);

4998: /*
4999: if g_debug = 1 then
5000: fnd_file.put_line(fnd_file.log,'Failed in Resource Load phase : '||x_phase);
5001: fnd_file.put_line(fnd_file.log, SQLCODE);
5002: fnd_file.put_line(fnd_file.log,SQLERRM);
5003: end if ;
5004: */
5005: --dbms_output.put_line('Failed in Resource Load phase : '||x_phase);
5006: --dbms_output.put_line(SQLCODE);

Line 5073: fnd_file.put_line(fnd_file.log, 'Before Stage MSUI Phase IN I');

5069:
5070:
5071: x_phase := 'I';
5072: if g_debug = 1 then
5073: fnd_file.put_line(fnd_file.log, 'Before Stage MSUI Phase IN I');
5074: end if ;
5075:
5076:
5077: --dbms_output.put_line('Before Stage MSUI Phase I');

Line 5182: fnd_file.put_line(fnd_file.log,'Failed in MSUI phase : '||x_phase);

5178: EXCEPTION
5179:
5180: WHEN OTHERS THEN
5181: if g_debug = 1 then
5182: fnd_file.put_line(fnd_file.log,'Failed in MSUI phase : '||x_phase);
5183: fnd_file.put_line(fnd_file.log, SQLCODE);
5184: fnd_file.put_line(fnd_file.log,SQLERRM);
5185: end if ;
5186:

Line 5183: fnd_file.put_line(fnd_file.log, SQLCODE);

5179:
5180: WHEN OTHERS THEN
5181: if g_debug = 1 then
5182: fnd_file.put_line(fnd_file.log,'Failed in MSUI phase : '||x_phase);
5183: fnd_file.put_line(fnd_file.log, SQLCODE);
5184: fnd_file.put_line(fnd_file.log,SQLERRM);
5185: end if ;
5186:
5187: --dbms_output.put_line('Failed in MSUI phase : '||x_phase);

Line 5184: fnd_file.put_line(fnd_file.log,SQLERRM);

5180: WHEN OTHERS THEN
5181: if g_debug = 1 then
5182: fnd_file.put_line(fnd_file.log,'Failed in MSUI phase : '||x_phase);
5183: fnd_file.put_line(fnd_file.log, SQLCODE);
5184: fnd_file.put_line(fnd_file.log,SQLERRM);
5185: end if ;
5186:
5187: --dbms_output.put_line('Failed in MSUI phase : '||x_phase);
5188: --dbms_output.put_line(SQLCODE);

Line 5303: fnd_file.put_line(fnd_file.log, 'Before Stage 10 Phase IN I');

5299: **********************/
5300: x_phase := 'I';
5301:
5302: if g_debug = 1 then
5303: fnd_file.put_line(fnd_file.log, 'Before Stage 10 Phase IN I');
5304: end if ;
5305:
5306: denormalize_item_dimension(
5307: p_table_name => 'wip_bis_prod_indicators',

Line 5315: fnd_file.put_line(fnd_file.log, 'Before Stage 10 Phase IN II');

5311:
5312: x_phase := 'II';
5313:
5314: if g_debug = 1 then
5315: fnd_file.put_line(fnd_file.log, 'Before Stage 10 Phase IN II');
5316: end if ;
5317:
5318: denormalize_org_dimension(
5319: p_table_name => 'wip_bis_prod_indicators',

Line 5331: fnd_file.put_line(fnd_file.log, 'Before Stage 10 Phase IN III');

5327:
5328: x_phase := 'III';
5329:
5330: if g_debug = 1 then
5331: fnd_file.put_line(fnd_file.log, 'Before Stage 10 Phase IN III');
5332: end if ;
5333: denormalize_time_dimension(
5334: p_table_name => 'wip_bis_prod_indicators',
5335: p_errnum => p_errnum,

Line 5346: fnd_file.put_line(fnd_file.log, 'Before Stage 10 Phase IN IV');

5342:
5343: x_phase := 'IV';
5344:
5345: if g_debug = 1 then
5346: fnd_file.put_line(fnd_file.log, 'Before Stage 10 Phase IN IV');
5347: end if ;
5348:
5349: denormalize_geo_dimension(
5350: p_table_name => 'wip_bis_prod_indicators',

Line 5363: fnd_file.put_line(fnd_file.log, 'Before Stage 10 Phase IN V');

5359:
5360: x_phase := 'V';
5361:
5362: if g_debug = 1 then
5363: fnd_file.put_line(fnd_file.log, 'Before Stage 10 Phase IN V');
5364: end if ;
5365: denormalize_org_dimension(
5366: p_table_name => 'wip_bis_prod_dept_yield',
5367: p_errnum => p_errnum,

Line 5378: fnd_file.put_line(fnd_file.log, 'Before Stage 10 Phase IN VI');

5374:
5375: x_phase := 'VI';
5376:
5377: if g_debug = 1 then
5378: fnd_file.put_line(fnd_file.log, 'Before Stage 10 Phase IN VI');
5379: end if ;
5380: denormalize_time_dimension(
5381: p_table_name => 'wip_bis_prod_dept_yield',
5382: p_errnum => p_errnum,

Line 5393: fnd_file.put_line(fnd_file.log, 'Before Stage 10 Phase IN VII');

5389:
5390: x_phase := 'VII';
5391:
5392: if g_debug = 1 then
5393: fnd_file.put_line(fnd_file.log, 'Before Stage 10 Phase IN VII');
5394: end if ;
5395:
5396: denormalize_geo_dimension(
5397: p_table_name => 'wip_bis_prod_dept_yield',

Line 5410: fnd_file.put_line(fnd_file.log, 'Before Stage 10 Phase IN VIII');

5406:
5407: x_phase := 'VIII';
5408:
5409: if g_debug = 1 then
5410: fnd_file.put_line(fnd_file.log, 'Before Stage 10 Phase IN VIII');
5411: end if ;
5412:
5413: denormalize_item_dimension(
5414: p_table_name => 'wip_bis_prod_assy_yield',

Line 5422: fnd_file.put_line(fnd_file.log, 'Before Stage 10 Phase IN IX');

5418:
5419: x_phase := 'IX';
5420:
5421: if g_debug = 1 then
5422: fnd_file.put_line(fnd_file.log, 'Before Stage 10 Phase IN IX');
5423: end if ;
5424: denormalize_org_dimension(
5425: p_table_name => 'wip_bis_prod_assy_yield',
5426: p_errnum => p_errnum,

Line 5437: fnd_file.put_line(fnd_file.log, 'Before Stage 10 Phase IN X');

5433:
5434: x_phase := 'X';
5435:
5436: if g_debug = 1 then
5437: fnd_file.put_line(fnd_file.log, 'Before Stage 10 Phase IN X');
5438: end if ;
5439: denormalize_time_dimension(
5440: p_table_name => 'wip_bis_prod_assy_yield',
5441: p_errnum => p_errnum,

Line 5452: fnd_file.put_line(fnd_file.log, 'Before Stage 10 Phase IN XI');

5448:
5449: x_phase := 'XI';
5450:
5451: if g_debug = 1 then
5452: fnd_file.put_line(fnd_file.log, 'Before Stage 10 Phase IN XI');
5453: end if ;
5454:
5455: denormalize_geo_dimension(
5456: p_table_name => 'wip_bis_prod_assy_yield',

Line 5470: fnd_file.put_line(fnd_file.log,'Failed in PDD phase : '||

5466: EXCEPTION
5467:
5468: WHEN OTHERS THEN
5469: if g_debug = 1 then
5470: fnd_file.put_line(fnd_file.log,'Failed in PDD phase : '||
5471: x_phase);
5472: fnd_file.put_line(fnd_file.log, SQLCODE);
5473: fnd_file.put_line(fnd_file.log,SQLERRM);
5474: end if ;

Line 5472: fnd_file.put_line(fnd_file.log, SQLCODE);

5468: WHEN OTHERS THEN
5469: if g_debug = 1 then
5470: fnd_file.put_line(fnd_file.log,'Failed in PDD phase : '||
5471: x_phase);
5472: fnd_file.put_line(fnd_file.log, SQLCODE);
5473: fnd_file.put_line(fnd_file.log,SQLERRM);
5474: end if ;
5475: p_errnum := -1 ;
5476: p_errmesg := 'Failed in PDD Phase : '||x_phase||substr(SQLERRM,1,125);

Line 5473: fnd_file.put_line(fnd_file.log,SQLERRM);

5469: if g_debug = 1 then
5470: fnd_file.put_line(fnd_file.log,'Failed in PDD phase : '||
5471: x_phase);
5472: fnd_file.put_line(fnd_file.log, SQLCODE);
5473: fnd_file.put_line(fnd_file.log,SQLERRM);
5474: end if ;
5475: p_errnum := -1 ;
5476: p_errmesg := 'Failed in PDD Phase : '||x_phase||substr(SQLERRM,1,125);
5477:

Line 5547: FND_FILE.PUT_LINE (fnd_file.log, proc_name || ':' || sqlerrm);

5543: EXCEPTION
5544:
5545: WHEN OTHERS
5546: THEN
5547: FND_FILE.PUT_LINE (fnd_file.log, proc_name || ':' || sqlerrm);
5548: p_errnum := -1;
5549: p_errmesg := (proc_name || ':' || sqlerrm);
5550: RAISE;
5551:

Line 5628: FND_FILE.PUT_LINE (fnd_file.log, proc_name || ':' || sqlerrm);

5624: EXCEPTION
5625:
5626: WHEN OTHERS
5627: THEN
5628: FND_FILE.PUT_LINE (fnd_file.log, proc_name || ':' || sqlerrm);
5629: p_errnum := -1;
5630: p_errmesg := (proc_name || ':' || sqlerrm);
5631: RAISE;
5632:

Line 5714: FND_FILE.PUT_LINE (fnd_file.log, proc_name || ':' || sqlerrm);

5710: EXCEPTION
5711:
5712: WHEN OTHERS
5713: THEN
5714: FND_FILE.PUT_LINE (fnd_file.log, proc_name || ':' || sqlerrm);
5715: p_errnum := -1;
5716: p_errmesg := (proc_name || ':' || sqlerrm);
5717: RAISE;
5718:

Line 5845: FND_FILE.PUT_LINE (fnd_file.log, proc_name || ':' || sqlerrm);

5841: EXCEPTION
5842:
5843: WHEN OTHERS
5844: THEN
5845: FND_FILE.PUT_LINE (fnd_file.log, proc_name || ':' || sqlerrm);
5846: p_errnum := -1;
5847: p_errmesg := (proc_name || ':' || sqlerrm);
5848: RAISE;
5849:

Line 5950: FND_FILE.PUT_LINE (fnd_file.log, proc_name || ':' || sqlerrm);

5946: WHERE wit.indicator_type = ' || p_indicator);
5947: EXCEPTION
5948: WHEN OTHERS
5949: THEN
5950: FND_FILE.PUT_LINE (fnd_file.log, proc_name || ':' || sqlerrm);
5951: RAISE;
5952:
5953: END populate_temp_table;
5954: ---------------------------------BUG 3280647 -----------------------------------------

Line 6064: FND_FILE.PUT_LINE (fnd_file.log, proc_name || ':' || sqlerrm);

6060:
6061: EXCEPTION
6062: WHEN OTHERS
6063: THEN
6064: FND_FILE.PUT_LINE (fnd_file.log, proc_name || ':' || sqlerrm);
6065: RAISE;
6066:
6067: END populate_eff_temp_table;
6068:

Line 6164: FND_FILE.PUT_LINE (fnd_file.log, proc_name || ':' || sqlerrm);

6160:
6161: EXCEPTION
6162: WHEN OTHERS
6163: THEN
6164: FND_FILE.PUT_LINE (fnd_file.log, proc_name || ':' || sqlerrm);
6165: RAISE; -- exceptions handled in calling routine.
6166:
6167: END simple_decomp;
6168:

Line 6295: fnd_file.put_line(fnd_file.log,'Backing up old data (if any)...');

6291:
6292: IF (l_wip_bis_prod_indicators <> 0 AND l_wip_bis_prod_assy_yield <> 0 AND l_wip_bis_prod_dept_yield <> 0) THEN
6293:
6294: IF g_debug = 1 THEN
6295: fnd_file.put_line(fnd_file.log,'Backing up old data (if any)...');
6296: END IF ;
6297: clear_temp_summary_tables (p_errnum, p_errmesg);
6298: IF (p_errnum < 0) THEN
6299: return;

Line 6578: FND_FILE.PUT_LINE (fnd_file.log, proc_name || ':' || sqlerrm);

6574: EXCEPTION
6575:
6576: WHEN OTHERS
6577: THEN
6578: FND_FILE.PUT_LINE (fnd_file.log, proc_name || ':' || sqlerrm);
6579: p_errnum := -1;
6580: p_errmesg := (proc_name || ':' || sqlerrm);
6581: if g_debug = 1 then
6582: fnd_file.put_line(fnd_file.log,'Failed in Backup of old data. Please run the collection after fixing the issue.');

Line 6582: fnd_file.put_line(fnd_file.log,'Failed in Backup of old data. Please run the collection after fixing the issue.');

6578: FND_FILE.PUT_LINE (fnd_file.log, proc_name || ':' || sqlerrm);
6579: p_errnum := -1;
6580: p_errmesg := (proc_name || ':' || sqlerrm);
6581: if g_debug = 1 then
6582: fnd_file.put_line(fnd_file.log,'Failed in Backup of old data. Please run the collection after fixing the issue.');
6583: end if ;
6584: raise ; -- Added by Suhasini for Bug 5132779
6585:
6586: -- RS: This used to return to populate_summary_table and not raise

Line 6633: FND_FILE.PUT_LINE (fnd_file.log, proc_name || ':' || sqlerrm);

6629: EXCEPTION
6630:
6631: WHEN OTHERS
6632: THEN
6633: FND_FILE.PUT_LINE (fnd_file.log, proc_name || ':' || sqlerrm);
6634: p_errnum := -1;
6635: p_errmesg := (proc_name || ':' || sqlerrm);
6636:
6637: -- returns to populate_summary_table, so don't raise exception.

Line 6927: FND_FILE.PUT_LINE (fnd_file.log, proc_name || ':' || sqlerrm);

6923: EXCEPTION
6924:
6925: WHEN OTHERS
6926: THEN
6927: FND_FILE.PUT_LINE (fnd_file.log, proc_name || ':' || sqlerrm);
6928: p_errnum := -1;
6929: p_errmesg := (proc_name || ':' || sqlerrm);
6930: if g_debug = 1 then
6931: fnd_file.put_line(fnd_file.log,'Failed during merging old data. Data for the present collection range is being truncated.');

Line 6931: fnd_file.put_line(fnd_file.log,'Failed during merging old data. Data for the present collection range is being truncated.');

6927: FND_FILE.PUT_LINE (fnd_file.log, proc_name || ':' || sqlerrm);
6928: p_errnum := -1;
6929: p_errmesg := (proc_name || ':' || sqlerrm);
6930: if g_debug = 1 then
6931: fnd_file.put_line(fnd_file.log,'Failed during merging old data. Data for the present collection range is being truncated.');
6932: fnd_file.put_line(fnd_file.log,'Please run the collection after fixing the issue.');
6933: end if ;
6934:
6935: -- truncate the 3 summary tables

Line 6932: fnd_file.put_line(fnd_file.log,'Please run the collection after fixing the issue.');

6928: p_errnum := -1;
6929: p_errmesg := (proc_name || ':' || sqlerrm);
6930: if g_debug = 1 then
6931: fnd_file.put_line(fnd_file.log,'Failed during merging old data. Data for the present collection range is being truncated.');
6932: fnd_file.put_line(fnd_file.log,'Please run the collection after fixing the issue.');
6933: end if ;
6934:
6935: -- truncate the 3 summary tables
6936: execute immediate 'truncate table ' || g_wip_schema ||

Line 6978: FND_FILE.PUT_LINE (fnd_file.log, proc_name || ':' || sqlerrm);

6974: EXCEPTION
6975:
6976: WHEN OTHERS
6977: THEN
6978: FND_FILE.PUT_LINE (fnd_file.log, proc_name || ':' || sqlerrm);
6979: p_errnum := -1;
6980: p_errmesg := (proc_name || ':' || sqlerrm);
6981: RAISE;
6982: