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.IEU_TASKS_WR_MIG_PVT dependencies on FND_FILE

Line 313: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);

309: errbuf := 'Work Source does not exist';
310: retcode := 2;
311: l_message := errbuf;
312: -- dbms_output.put_line('err msg: '||l_message);
313: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);
314: raise;
315: end;
316:
317: BEGIN

Line 468: --fnd_file.put_line(FND_FILE.LOG,'insert failed..');

464:
465: EXCEPTION
466: WHEN dml_errors THEN
467: errors := SQL%BULK_EXCEPTIONS.COUNT;
468: --fnd_file.put_line(FND_FILE.LOG,'insert failed..');
469: FOR i IN 1..errors LOOP
470: l_task_det_rec.l_ins_flag(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) := 0;
471: --dbms_output.put_line(SQLERRM(-1*SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
472:

Line 480: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

476: IF l_error_count > 1000 THEN
477: FND_MESSAGE.SET_NAME('IEU', 'IEU_ERROR_THRESHOLD');
478: FND_MESSAGE.SET_TOKEN('ERROR_COUNT', '1000');
479: FND_MESSAGE.SET_TOKEN('WS_CODE', 'TASK');
480: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
481: fnd_msg_pub.ADD;
482: fnd_msg_pub.Count_and_Get
483: (
484: p_count => x_msg_count,

Line 492: fnd_file.new_line(FND_FILE.LOG, 1);

488: RAISE fnd_api.g_exc_error;
489: END IF;
490:
491: err_flag := 'Y';
492: fnd_file.new_line(FND_FILE.LOG, 1);
493: FND_MESSAGE.SET_NAME('IEU', 'IEU_CREATE_UWQM_ITEM_FAILED');
494: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_TASKS_WR_MIG_PVT');
495: FND_MESSAGE.SET_TOKEN('DETAILS', 'WORKITEM_PK_ID:'||l_task_det_rec.l_task_id_list(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
496: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));

Line 496: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));

492: fnd_file.new_line(FND_FILE.LOG, 1);
493: FND_MESSAGE.SET_NAME('IEU', 'IEU_CREATE_UWQM_ITEM_FAILED');
494: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_TASKS_WR_MIG_PVT');
495: FND_MESSAGE.SET_TOKEN('DETAILS', 'WORKITEM_PK_ID:'||l_task_det_rec.l_task_id_list(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
496: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
497: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
498: fnd_msg_pub.ADD;
499: fnd_msg_pub.Count_and_Get
500: (

Line 497: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

493: FND_MESSAGE.SET_NAME('IEU', 'IEU_CREATE_UWQM_ITEM_FAILED');
494: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_TASKS_WR_MIG_PVT');
495: FND_MESSAGE.SET_TOKEN('DETAILS', 'WORKITEM_PK_ID:'||l_task_det_rec.l_task_id_list(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
496: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
497: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
498: fnd_msg_pub.ADD;
499: fnd_msg_pub.Count_and_Get
500: (
501: p_count => x_msg_count,

Line 511: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

507: IF err_flag = 'Y' THEN
508:
509: FND_MESSAGE.SET_NAME('IEU', 'IEU_WS_ACTIVATE_FAILED');
510: FND_MESSAGE.SET_TOKEN('WS_CODE', 'TASK');
511: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
512: fnd_msg_pub.ADD;
513: fnd_msg_pub.Count_and_Get
514: (
515: p_count => x_msg_count,

Line 526: -- fnd_file.put_line(FND_FILE.LOG,' errors: '||errors);

522:
523:
524:
525:
526: -- fnd_file.put_line(FND_FILE.LOG,' errors: '||errors);
527: if (errors > 0)
528: then
529: -- fnd_file.put_line(FND_FILE.LOG,'begin update');
530: BEGIN

Line 529: -- fnd_file.put_line(FND_FILE.LOG,'begin update');

525:
526: -- fnd_file.put_line(FND_FILE.LOG,' errors: '||errors);
527: if (errors > 0)
528: then
529: -- fnd_file.put_line(FND_FILE.LOG,'begin update');
530: BEGIN
531: FORALL i in 1..l_task_det_rec.l_task_id_list.COUNT SAVE EXCEPTIONS
532: UPDATE IEU_UWQM_ITEMS
533: set

Line 576: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

572: IF l_error_count > 1000 THEN
573: FND_MESSAGE.SET_NAME('IEU', 'IEU_ERROR_THRESHOLD');
574: FND_MESSAGE.SET_TOKEN('ERROR_COUNT', '1000');
575: FND_MESSAGE.SET_TOKEN('WS_CODE', 'TASK');
576: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
577: fnd_msg_pub.ADD;
578: fnd_msg_pub.Count_and_Get
579: (
580: p_count => x_msg_count,

Line 587: fnd_file.new_line(FND_FILE.LOG, 1);

583:
584: RAISE fnd_api.g_exc_error;
585: END IF;
586:
587: fnd_file.new_line(FND_FILE.LOG, 1);
588: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');
589: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_TASKS_WR_MIG_PVT');
590: FND_MESSAGE.SET_TOKEN('DETAILS', ' WORKITEM_PK_ID:'||l_task_det_rec.l_task_id_list(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
591:

Line 592: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));

588: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');
589: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_TASKS_WR_MIG_PVT');
590: FND_MESSAGE.SET_TOKEN('DETAILS', ' WORKITEM_PK_ID:'||l_task_det_rec.l_task_id_list(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
591:
592: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
593: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
594: fnd_msg_pub.ADD;
595: fnd_msg_pub.Count_and_Get
596: (

Line 593: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

589: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_TASKS_WR_MIG_PVT');
590: FND_MESSAGE.SET_TOKEN('DETAILS', ' WORKITEM_PK_ID:'||l_task_det_rec.l_task_id_list(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
591:
592: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
593: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
594: fnd_msg_pub.ADD;
595: fnd_msg_pub.Count_and_Get
596: (
597: p_count => x_msg_count,

Line 605: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

601: END LOOP;
602:
603: FND_MESSAGE.SET_NAME('IEU', 'IEU_WS_ACTIVATE_FAILED');
604: FND_MESSAGE.SET_TOKEN('WS_CODE', 'TASK');
605: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
606: fnd_msg_pub.ADD;
607: fnd_msg_pub.Count_and_Get
608: (
609: p_count => x_msg_count,

Line 674: fnd_file.put_line(FND_FILE.LOG,'due date task id cnt: '||l_task_duedate_rec.l_task_id_list.COUNT);

670: l_task_duedate_rec.l_due_date_list,
671: l_task_duedate_rec.l_task_id_list
672: LIMIT l_array_size;
673:
674: fnd_file.put_line(FND_FILE.LOG,'due date task id cnt: '||l_task_duedate_rec.l_task_id_list.COUNT);
675: l_done := c_task_due_date%NOTFOUND;
676:
677: BEGIN
678: -- fnd_file.put_line(FND_FILE.LOG,'Begin update');

Line 678: -- fnd_file.put_line(FND_FILE.LOG,'Begin update');

674: fnd_file.put_line(FND_FILE.LOG,'due date task id cnt: '||l_task_duedate_rec.l_task_id_list.COUNT);
675: l_done := c_task_due_date%NOTFOUND;
676:
677: BEGIN
678: -- fnd_file.put_line(FND_FILE.LOG,'Begin update');
679: FORALL i in 1..l_task_duedate_rec.l_task_id_list.COUNT SAVE EXCEPTIONS
680: update IEU_UWQM_ITEMS
681: set due_date = l_task_duedate_rec.l_due_date_list(i)
682: where workitem_pk_id = l_task_duedate_rec.l_task_id_list(i)

Line 689: /* fnd_file.put_line(FND_FILE.LOG,'Error ' || i || ' occurred during '||

685: EXCEPTION
686: WHEN dml_errors THEN
687: errors := SQL%BULK_EXCEPTIONS.COUNT;
688: FOR i IN 1..errors LOOP
689: /* fnd_file.put_line(FND_FILE.LOG,'Error ' || i || ' occurred during '||
690: 'assignee update for workitem_pk_id ' || l_task_asg_rec.l_asg_task_id_list(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||
691: 'Oracle error is ' ||
692: SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE)); */
693:

Line 701: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

697: IF l_error_count > 1000 THEN
698: FND_MESSAGE.SET_NAME('IEU', 'IEU_ERROR_THRESHOLD');
699: FND_MESSAGE.SET_TOKEN('ERROR_COUNT', '1000');
700: FND_MESSAGE.SET_TOKEN('WS_CODE', 'TASK');
701: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
702: fnd_msg_pub.ADD;
703: fnd_msg_pub.Count_and_Get
704: (
705: p_count => x_msg_count,

Line 712: fnd_file.new_line(FND_FILE.LOG, 1);

708:
709: RAISE fnd_api.g_exc_error;
710: END IF;
711:
712: fnd_file.new_line(FND_FILE.LOG, 1);
713: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');
714: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_TASKS_WR_MIG_PVT');
715: FND_MESSAGE.SET_TOKEN('DETAILS', ' WORKITEM_PK_ID:'||l_task_duedate_rec.l_task_id_list(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
716:

Line 717: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));

713: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');
714: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_TASKS_WR_MIG_PVT');
715: FND_MESSAGE.SET_TOKEN('DETAILS', ' WORKITEM_PK_ID:'||l_task_duedate_rec.l_task_id_list(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
716:
717: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
718: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
719: fnd_msg_pub.ADD;
720: fnd_msg_pub.Count_and_Get
721: (

Line 718: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

714: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_TASKS_WR_MIG_PVT');
715: FND_MESSAGE.SET_TOKEN('DETAILS', ' WORKITEM_PK_ID:'||l_task_duedate_rec.l_task_id_list(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
716:
717: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
718: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
719: fnd_msg_pub.ADD;
720: fnd_msg_pub.Count_and_Get
721: (
722: p_count => x_msg_count,

Line 728: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

724: );
725: END LOOP;
726: FND_MESSAGE.SET_NAME('IEU', 'IEU_WS_ACTIVATE_FAILED');
727: FND_MESSAGE.SET_TOKEN('WS_CODE', 'TASK');
728: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
729: fnd_msg_pub.ADD;
730: fnd_msg_pub.Count_and_Get
731: (
732: p_count => x_msg_count,

Line 764: fnd_file.put_line(FND_FILE.LOG,'status task id cnt: '||l_task_status_rec.l_task_id_list.COUNT);

760: l_task_status_rec.l_task_id_list,
761: l_task_status_rec.l_status_id_list
762: LIMIT l_array_size;
763:
764: fnd_file.put_line(FND_FILE.LOG,'status task id cnt: '||l_task_status_rec.l_task_id_list.COUNT);
765: l_done := c_task_status%NOTFOUND;
766:
767: BEGIN
768: -- fnd_file.put_line(FND_FILE.LOG,'Begin update');

Line 768: -- fnd_file.put_line(FND_FILE.LOG,'Begin update');

764: fnd_file.put_line(FND_FILE.LOG,'status task id cnt: '||l_task_status_rec.l_task_id_list.COUNT);
765: l_done := c_task_status%NOTFOUND;
766:
767: BEGIN
768: -- fnd_file.put_line(FND_FILE.LOG,'Begin update');
769: FORALL i in 1..l_task_status_rec.l_task_id_list.COUNT SAVE EXCEPTIONS
770: update IEU_UWQM_ITEMS
771: set status_id = l_task_status_rec.l_status_id_list(i),
772: LAST_UPDATED_BY = l_user_id,

Line 790: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

786: IF l_error_count > 1000 THEN
787: FND_MESSAGE.SET_NAME('IEU', 'IEU_ERROR_THRESHOLD');
788: FND_MESSAGE.SET_TOKEN('ERROR_COUNT', '1000');
789: FND_MESSAGE.SET_TOKEN('WS_CODE', 'TASK');
790: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
791: fnd_msg_pub.ADD;
792: fnd_msg_pub.Count_and_Get
793: (
794: p_count => x_msg_count,

Line 801: fnd_file.new_line(FND_FILE.LOG, 1);

797:
798: RAISE fnd_api.g_exc_error;
799: END IF;
800:
801: fnd_file.new_line(FND_FILE.LOG, 1);
802: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');
803: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_TASKS_WR_MIG_PVT');
804: FND_MESSAGE.SET_TOKEN('DETAILS', ' WORKITEM_PK_ID:'||l_task_status_rec.l_task_id_list(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
805:

Line 806: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));

802: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');
803: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_TASKS_WR_MIG_PVT');
804: FND_MESSAGE.SET_TOKEN('DETAILS', ' WORKITEM_PK_ID:'||l_task_status_rec.l_task_id_list(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
805:
806: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
807: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
808: fnd_msg_pub.ADD;
809: fnd_msg_pub.Count_and_Get
810: (

Line 807: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

803: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_TASKS_WR_MIG_PVT');
804: FND_MESSAGE.SET_TOKEN('DETAILS', ' WORKITEM_PK_ID:'||l_task_status_rec.l_task_id_list(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
805:
806: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
807: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
808: fnd_msg_pub.ADD;
809: fnd_msg_pub.Count_and_Get
810: (
811: p_count => x_msg_count,

Line 817: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

813: );
814: END LOOP;
815: FND_MESSAGE.SET_NAME('IEU', 'IEU_WS_ACTIVATE_FAILED');
816: FND_MESSAGE.SET_TOKEN('WS_CODE', 'TASK');
817: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
818: fnd_msg_pub.ADD;
819: fnd_msg_pub.Count_and_Get
820: (
821: p_count => x_msg_count,

Line 852: fnd_file.put_line(FND_FILE.LOG,'asg task id cnt: '||l_task_asg_rec.l_asg_task_id_list.COUNT||

848: l_task_asg_rec.l_asg_task_id_list,
849: l_task_asg_rec.l_asg_type_act_list
850: LIMIT l_array_size;
851:
852: fnd_file.put_line(FND_FILE.LOG,'asg task id cnt: '||l_task_asg_rec.l_asg_task_id_list.COUNT||
853: ' asg id cnt: '||l_task_asg_rec.l_asg_id_list.COUNT|| ' asg type cnt: '||l_task_asg_rec.l_asg_type_act_list.COUNT );
854: l_done := c_task_asg_det%NOTFOUND;
855:
856: BEGIN

Line 857: -- fnd_file.put_line(FND_FILE.LOG,'Begin update');

853: ' asg id cnt: '||l_task_asg_rec.l_asg_id_list.COUNT|| ' asg type cnt: '||l_task_asg_rec.l_asg_type_act_list.COUNT );
854: l_done := c_task_asg_det%NOTFOUND;
855:
856: BEGIN
857: -- fnd_file.put_line(FND_FILE.LOG,'Begin update');
858: FORALL i in 1..l_task_asg_rec.l_asg_task_id_list.COUNT SAVE EXCEPTIONS
859: update IEU_UWQM_ITEMS
860: set assignee_id = l_task_asg_rec.l_asg_id_list(i),
861: assignee_type = 'RS_INDIVIDUAL',

Line 871: /* fnd_file.put_line(FND_FILE.LOG,'Error ' || i || ' occurred during '||

867: EXCEPTION
868: WHEN dml_errors THEN
869: errors := SQL%BULK_EXCEPTIONS.COUNT;
870: FOR i IN 1..errors LOOP
871: /* fnd_file.put_line(FND_FILE.LOG,'Error ' || i || ' occurred during '||
872: 'assignee update for workitem_pk_id ' || l_task_asg_rec.l_asg_task_id_list(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||
873: 'Oracle error is ' ||
874: SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE)); */
875:

Line 883: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

879: IF l_error_count > 1000 THEN
880: FND_MESSAGE.SET_NAME('IEU', 'IEU_ERROR_THRESHOLD');
881: FND_MESSAGE.SET_TOKEN('ERROR_COUNT', '1000');
882: FND_MESSAGE.SET_TOKEN('WS_CODE', 'TASK');
883: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
884: fnd_msg_pub.ADD;
885: fnd_msg_pub.Count_and_Get
886: (
887: p_count => x_msg_count,

Line 895: fnd_file.new_line(FND_FILE.LOG, 1);

891: RAISE fnd_api.g_exc_error;
892: END IF;
893:
894:
895: fnd_file.new_line(FND_FILE.LOG, 1);
896: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');
897: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_TASKS_WR_MIG_PVT');
898: FND_MESSAGE.SET_TOKEN('DETAILS', ' WORKITEM_PK_ID:'||l_task_asg_rec.l_asg_task_id_list(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
899:

Line 900: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));

896: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');
897: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_TASKS_WR_MIG_PVT');
898: FND_MESSAGE.SET_TOKEN('DETAILS', ' WORKITEM_PK_ID:'||l_task_asg_rec.l_asg_task_id_list(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
899:
900: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
901: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
902: fnd_msg_pub.ADD;
903: fnd_msg_pub.Count_and_Get
904: (

Line 901: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

897: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_TASKS_WR_MIG_PVT');
898: FND_MESSAGE.SET_TOKEN('DETAILS', ' WORKITEM_PK_ID:'||l_task_asg_rec.l_asg_task_id_list(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
899:
900: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
901: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
902: fnd_msg_pub.ADD;
903: fnd_msg_pub.Count_and_Get
904: (
905: p_count => x_msg_count,

Line 911: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

907: );
908: END LOOP;
909: FND_MESSAGE.SET_NAME('IEU', 'IEU_WS_ACTIVATE_FAILED');
910: FND_MESSAGE.SET_TOKEN('WS_CODE', 'TASK');
911: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
912: fnd_msg_pub.ADD;
913: fnd_msg_pub.Count_and_Get
914: (
915: p_count => x_msg_count,

Line 961: fnd_file.new_line(FND_FILE.LOG, 1);

957: x_msg_data => l_msg_data,
958: x_return_status => l_return_status);
959: end if;
960:
961: fnd_file.new_line(FND_FILE.LOG, 1);
962:
963: if (l_failed_counter = 0) and (l_return_status = 'S') then
964:
965: FND_MESSAGE.SET_NAME('IEU', 'IEU_WS_ACTIVATED');

Line 968: fnd_file.put_line(FND_FILE.LOG, l_ws_act_success_msg);

964:
965: FND_MESSAGE.SET_NAME('IEU', 'IEU_WS_ACTIVATED');
966: FND_MESSAGE.SET_TOKEN('WS_CODE', 'TASK');
967: l_ws_act_success_msg := FND_MESSAGE.GET;
968: fnd_file.put_line(FND_FILE.LOG, l_ws_act_success_msg);
969: -- dbms_output.put_line(l_ws_act_success_msg);
970:
971: else
972: FND_MESSAGE.SET_NAME('IEU', 'IEU_WS_ACTIVATE_FAILED');

Line 977: fnd_file.put_line(FND_FILE.LOG, l_ws_act_failed_msg);

973: FND_MESSAGE.SET_TOKEN('WS_CODE', 'TASK');
974: l_ws_act_failed_msg := FND_MESSAGE.GET;
975:
976: l_ws_act_failed_msg := l_ws_act_failed_msg||' '||l_msg_data;
977: fnd_file.put_line(FND_FILE.LOG, l_ws_act_failed_msg);
978: RAISE fnd_api.g_exc_error;
979:
980: -- dbms_output.put_line(l_ws_act_failed_msg);
981: end if;

Line 983: fnd_file.new_line(FND_FILE.LOG, 1);

979:
980: -- dbms_output.put_line(l_ws_act_failed_msg);
981: end if;
982:
983: fnd_file.new_line(FND_FILE.LOG, 1);
984: FND_MESSAGE.SET_NAME('IEU', 'IEU_SYNCH_WR_DIST_STATUS_SUM');
985: FND_MESSAGE.SET_TOKEN('SUCCESS_COUNT', (l_total - l_failed_counter));
986: FND_MESSAGE.SET_TOKEN('FAILED_COUNT', l_failed_counter);
987: FND_MESSAGE.SET_TOKEN('TOTAL_COUNT', l_total );

Line 995: fnd_file.put_line(FND_FILE.LOG, l_workitem_sum_msg);

991: -- dbms_output.put_line('TOTAL_COUNT'|| l_total );
992:
993: l_workitem_sum_msg := FND_MESSAGE.GET;
994:
995: fnd_file.put_line(FND_FILE.LOG, l_workitem_sum_msg);
996: -- dbms_output.put_line(l_workitem_sum_msg);
997:
998: DBMS_STATS.DELETE_TABLE_STATS (
999: ownname => 'IEU',

Line 1062: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);

1058:
1059: errbuf := sqlcode||' '||sqlerrm;
1060: retcode := 2;
1061: l_message := sqlcode || ' '||sqlerrm;
1062: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);
1063: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1064: THEN
1065:
1066: fnd_msg_pub.Count_and_Get