473: If SQL%BULK_EXCEPTIONS(i).ERROR_CODE <> 1 then
474: l_error_count := l_error_count + 1;
475: --** checking for error threshold **--
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;
474: l_error_count := l_error_count + 1;
475: --** checking for error threshold **--
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
475: --** checking for error threshold **--
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: (
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,
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));
497: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
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));
497: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
498: fnd_msg_pub.ADD;
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));
497: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
498: fnd_msg_pub.ADD;
499: fnd_msg_pub.Count_and_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,
505: END LOOP;
506:
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
506:
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: (
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,
569: --** checking for error threshold **--
570:
571: l_error_count := l_error_count + 1;
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;
570:
571: l_error_count := l_error_count + 1;
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
571: l_error_count := l_error_count + 1;
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: (
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,
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:
592: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
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:
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);
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:
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;
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,
599: );
600:
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
600:
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: (
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,
694: --** checking for error threshold **--
695:
696: l_error_count := l_error_count +1;
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;
695:
696: l_error_count := l_error_count +1;
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
696: l_error_count := l_error_count +1;
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: (
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,
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:
717: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
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:
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);
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:
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;
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,
722: p_count => x_msg_count,
723: p_data => x_msg_data
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
723: p_data => x_msg_data
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: (
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,
783: --** checking for error threshold **--
784:
785: l_error_count := l_error_count + 1;
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;
784:
785: l_error_count := l_error_count + 1;
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
785: l_error_count := l_error_count + 1;
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: (
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,
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:
806: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
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:
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);
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:
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;
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,
811: p_count => x_msg_count,
812: p_data => x_msg_data
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
812: p_data => x_msg_data
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: (
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,
876: --** checking for error threshold **--
877:
878: l_error_count := l_error_count + 1;
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;
877:
878: l_error_count := l_error_count + 1;
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
878: l_error_count := l_error_count + 1;
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: (
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,
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:
900: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
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:
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);
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:
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;
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,
905: p_count => x_msg_count,
906: p_data => x_msg_data
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
906: p_data => x_msg_data
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: (
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,
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');
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);
962:
963: if (l_failed_counter = 0) and (l_return_status = 'S') then
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:
963: if (l_failed_counter = 0) and (l_return_status = 'S') then
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
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');
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;
969: -- dbms_output.put_line(l_ws_act_success_msg);
970:
971: else
972: FND_MESSAGE.SET_NAME('IEU', 'IEU_WS_ACTIVATE_FAILED');
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);
970:
971: else
972: FND_MESSAGE.SET_NAME('IEU', 'IEU_WS_ACTIVATE_FAILED');
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;
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 );
988:
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 );
988:
989: -- dbms_output.put_line('SUCCESS_COUNT'|| (l_total - l_failed_counter));
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 );
988:
989: -- dbms_output.put_line('SUCCESS_COUNT'|| (l_total - l_failed_counter));
990: -- dbms_output.put_line('FAILED_COUNT'||l_failed_counter);
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 );
988:
989: -- dbms_output.put_line('SUCCESS_COUNT'|| (l_total - l_failed_counter));
990: -- dbms_output.put_line('FAILED_COUNT'||l_failed_counter);
991: -- dbms_output.put_line('TOTAL_COUNT'|| l_total );
989: -- dbms_output.put_line('SUCCESS_COUNT'|| (l_total - l_failed_counter));
990: -- dbms_output.put_line('FAILED_COUNT'||l_failed_counter);
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: