DBA Data[Home] [Help]

APPS.IEU_TASKS_WR_MIG_PVT dependencies on FND_MSG_PUB

Line 481: fnd_msg_pub.ADD;

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,
485: p_data => x_msg_data

Line 482: fnd_msg_pub.Count_and_Get

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,
485: p_data => x_msg_data
486: );

Line 498: fnd_msg_pub.ADD;

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,
502: p_data => x_msg_data

Line 499: fnd_msg_pub.Count_and_Get

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,
502: p_data => x_msg_data
503: );

Line 512: fnd_msg_pub.ADD;

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,
516: p_data => x_msg_data

Line 513: fnd_msg_pub.Count_and_Get

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,
516: p_data => x_msg_data
517: );

Line 577: fnd_msg_pub.ADD;

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,
581: p_data => x_msg_data

Line 578: fnd_msg_pub.Count_and_Get

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,
581: p_data => x_msg_data
582: );

Line 594: fnd_msg_pub.ADD;

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,
598: p_data => x_msg_data

Line 595: fnd_msg_pub.Count_and_Get

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,
598: p_data => x_msg_data
599: );

Line 606: fnd_msg_pub.ADD;

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,
610: p_data => x_msg_data

Line 607: fnd_msg_pub.Count_and_Get

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,
610: p_data => x_msg_data
611: );

Line 702: fnd_msg_pub.ADD;

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,
706: p_data => x_msg_data

Line 703: fnd_msg_pub.Count_and_Get

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,
706: p_data => x_msg_data
707: );

Line 719: fnd_msg_pub.ADD;

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,
723: p_data => x_msg_data

Line 720: fnd_msg_pub.Count_and_Get

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,
723: p_data => x_msg_data
724: );

Line 729: fnd_msg_pub.ADD;

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,
733: p_data => x_msg_data);

Line 730: fnd_msg_pub.Count_and_Get

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,
733: p_data => x_msg_data);
734:

Line 791: fnd_msg_pub.ADD;

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,
795: p_data => x_msg_data

Line 792: fnd_msg_pub.Count_and_Get

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,
795: p_data => x_msg_data
796: );

Line 808: fnd_msg_pub.ADD;

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,
812: p_data => x_msg_data

Line 809: fnd_msg_pub.Count_and_Get

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,
812: p_data => x_msg_data
813: );

Line 818: fnd_msg_pub.ADD;

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,
822: p_data => x_msg_data);

Line 819: fnd_msg_pub.Count_and_Get

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,
822: p_data => x_msg_data);
823:

Line 884: fnd_msg_pub.ADD;

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,
888: p_data => x_msg_data

Line 885: fnd_msg_pub.Count_and_Get

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,
888: p_data => x_msg_data
889: );

Line 902: fnd_msg_pub.ADD;

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,
906: p_data => x_msg_data

Line 903: fnd_msg_pub.Count_and_Get

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,
906: p_data => x_msg_data
907: );

Line 912: fnd_msg_pub.ADD;

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,
916: p_data => x_msg_data);

Line 913: fnd_msg_pub.Count_and_Get

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,
916: p_data => x_msg_data);
917:

Line 1021: fnd_msg_pub.Count_and_Get

1017: x_msg_data => l_msg_data,
1018: x_return_status => l_return_status);
1019: retcode := 2;
1020:
1021: fnd_msg_pub.Count_and_Get
1022: (
1023: p_count => x_msg_count,
1024: p_data => x_msg_data
1025: );

Line 1041: fnd_msg_pub.Count_and_Get

1037: x_msg_data => l_msg_data,
1038: x_return_status => l_return_status);
1039: retcode := 2;
1040:
1041: fnd_msg_pub.Count_and_Get
1042: (
1043: p_count => x_msg_count,
1044: p_data => x_msg_data
1045: );

Line 1063: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 1066: fnd_msg_pub.Count_and_Get

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
1067: (
1068: p_count => x_msg_count,
1069: p_data => x_msg_data
1070: );