DBA Data[Home] [Help]

APPS.IEU_TASKS_WR_MIG_PVT dependencies on FND_MESSAGE

Line 477: FND_MESSAGE.SET_NAME('IEU', 'IEU_ERROR_THRESHOLD');

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;

Line 478: FND_MESSAGE.SET_TOKEN('ERROR_COUNT', '1000');

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

Line 479: FND_MESSAGE.SET_TOKEN('WS_CODE', 'TASK');

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

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 493: FND_MESSAGE.SET_NAME('IEU', 'IEU_CREATE_UWQM_ITEM_FAILED');

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);

Line 494: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_TASKS_WR_MIG_PVT');

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;

Line 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));

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

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 509: FND_MESSAGE.SET_NAME('IEU', 'IEU_WS_ACTIVATE_FAILED');

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

Line 510: FND_MESSAGE.SET_TOKEN('WS_CODE', 'TASK');

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

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 573: FND_MESSAGE.SET_NAME('IEU', 'IEU_ERROR_THRESHOLD');

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;

Line 574: FND_MESSAGE.SET_TOKEN('ERROR_COUNT', '1000');

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

Line 575: FND_MESSAGE.SET_TOKEN('WS_CODE', 'TASK');

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

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 588: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');

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));

Line 589: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_TASKS_WR_MIG_PVT');

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);

Line 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));

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;

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 603: FND_MESSAGE.SET_NAME('IEU', 'IEU_WS_ACTIVATE_FAILED');

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

Line 604: FND_MESSAGE.SET_TOKEN('WS_CODE', 'TASK');

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

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 698: FND_MESSAGE.SET_NAME('IEU', 'IEU_ERROR_THRESHOLD');

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;

Line 699: FND_MESSAGE.SET_TOKEN('ERROR_COUNT', '1000');

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

Line 700: FND_MESSAGE.SET_TOKEN('WS_CODE', 'TASK');

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

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 713: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');

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));

Line 714: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_TASKS_WR_MIG_PVT');

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);

Line 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));

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;

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 726: FND_MESSAGE.SET_NAME('IEU', 'IEU_WS_ACTIVATE_FAILED');

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

Line 727: FND_MESSAGE.SET_TOKEN('WS_CODE', 'TASK');

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

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 787: FND_MESSAGE.SET_NAME('IEU', 'IEU_ERROR_THRESHOLD');

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;

Line 788: FND_MESSAGE.SET_TOKEN('ERROR_COUNT', '1000');

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

Line 789: FND_MESSAGE.SET_TOKEN('WS_CODE', 'TASK');

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

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 802: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');

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));

Line 803: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_TASKS_WR_MIG_PVT');

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);

Line 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));

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;

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 815: FND_MESSAGE.SET_NAME('IEU', 'IEU_WS_ACTIVATE_FAILED');

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

Line 816: FND_MESSAGE.SET_TOKEN('WS_CODE', 'TASK');

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

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 880: FND_MESSAGE.SET_NAME('IEU', 'IEU_ERROR_THRESHOLD');

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;

Line 881: FND_MESSAGE.SET_TOKEN('ERROR_COUNT', '1000');

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

Line 882: FND_MESSAGE.SET_TOKEN('WS_CODE', 'TASK');

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

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 896: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');

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));

Line 897: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_TASKS_WR_MIG_PVT');

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);

Line 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));

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;

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 909: FND_MESSAGE.SET_NAME('IEU', 'IEU_WS_ACTIVATE_FAILED');

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

Line 910: FND_MESSAGE.SET_TOKEN('WS_CODE', 'TASK');

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

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 965: FND_MESSAGE.SET_NAME('IEU', 'IEU_WS_ACTIVATED');

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);

Line 966: FND_MESSAGE.SET_TOKEN('WS_CODE', 'TASK');

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:

Line 967: l_ws_act_success_msg := FND_MESSAGE.GET;

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

Line 972: FND_MESSAGE.SET_NAME('IEU', 'IEU_WS_ACTIVATE_FAILED');

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;

Line 973: FND_MESSAGE.SET_TOKEN('WS_CODE', 'TASK');

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);

Line 974: l_ws_act_failed_msg := FND_MESSAGE.GET;

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;

Line 984: FND_MESSAGE.SET_NAME('IEU', 'IEU_SYNCH_WR_DIST_STATUS_SUM');

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:

Line 985: FND_MESSAGE.SET_TOKEN('SUCCESS_COUNT', (l_total - l_failed_counter));

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));

Line 986: FND_MESSAGE.SET_TOKEN('FAILED_COUNT', 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);

Line 987: FND_MESSAGE.SET_TOKEN('TOTAL_COUNT', l_total );

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 );

Line 993: l_workitem_sum_msg := FND_MESSAGE.GET;

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: