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

Line 311: FND_FILE.PUT_LINE(FND_FILE.LOG,'SQL Error Message :'||SQLERRM);

307: END IF;
308:
309: EXCEPTION
310: WHEN OTHERS THEN
311: FND_FILE.PUT_LINE(FND_FILE.LOG,'SQL Error Message :'||SQLERRM);
312: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
313: FND_MESSAGE.SET_TOKEN('NAME','IGS_AS_ANON_GRD_PKG.MNT_ANON_ID.SUB_GET_INSERT');
314: IGS_GE_MSG_STACK.ADD;
315: APP_EXCEPTION.RAISE_EXCEPTION;

Line 662: FND_FILE.PUT_LINE(FND_FILE.LOG,'+-------------------------Parameters Passed---------------------------------+');

658: CLOSE c_cal;
659:
660: /* Print the Parameters Passed */
661:
662: FND_FILE.PUT_LINE(FND_FILE.LOG,'+-------------------------Parameters Passed---------------------------------+');
663: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
664: FND_FILE.PUT_LINE(FND_FILE.LOG,'Load Calendar : ' || l_ld_cal_type);
665: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calendar Start Date : ' || TO_CHAR(c_cal_rec.start_dt,'DD-MON-YYYY'));
666: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calendar End Date : ' || TO_CHAR(c_cal_rec.end_dt,'DD-MON-YYYY')) ;

Line 663: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

659:
660: /* Print the Parameters Passed */
661:
662: FND_FILE.PUT_LINE(FND_FILE.LOG,'+-------------------------Parameters Passed---------------------------------+');
663: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
664: FND_FILE.PUT_LINE(FND_FILE.LOG,'Load Calendar : ' || l_ld_cal_type);
665: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calendar Start Date : ' || TO_CHAR(c_cal_rec.start_dt,'DD-MON-YYYY'));
666: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calendar End Date : ' || TO_CHAR(c_cal_rec.end_dt,'DD-MON-YYYY')) ;
667: FND_FILE.PUT_LINE(FND_FILE.LOG,'Minimum limit of Range : ' || TO_CHAR(p_min_number));

Line 664: FND_FILE.PUT_LINE(FND_FILE.LOG,'Load Calendar : ' || l_ld_cal_type);

660: /* Print the Parameters Passed */
661:
662: FND_FILE.PUT_LINE(FND_FILE.LOG,'+-------------------------Parameters Passed---------------------------------+');
663: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
664: FND_FILE.PUT_LINE(FND_FILE.LOG,'Load Calendar : ' || l_ld_cal_type);
665: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calendar Start Date : ' || TO_CHAR(c_cal_rec.start_dt,'DD-MON-YYYY'));
666: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calendar End Date : ' || TO_CHAR(c_cal_rec.end_dt,'DD-MON-YYYY')) ;
667: FND_FILE.PUT_LINE(FND_FILE.LOG,'Minimum limit of Range : ' || TO_CHAR(p_min_number));
668: FND_FILE.PUT_LINE(FND_FILE.LOG,'Maximum limit of Range : ' || TO_CHAR(p_max_number));

Line 665: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calendar Start Date : ' || TO_CHAR(c_cal_rec.start_dt,'DD-MON-YYYY'));

661:
662: FND_FILE.PUT_LINE(FND_FILE.LOG,'+-------------------------Parameters Passed---------------------------------+');
663: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
664: FND_FILE.PUT_LINE(FND_FILE.LOG,'Load Calendar : ' || l_ld_cal_type);
665: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calendar Start Date : ' || TO_CHAR(c_cal_rec.start_dt,'DD-MON-YYYY'));
666: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calendar End Date : ' || TO_CHAR(c_cal_rec.end_dt,'DD-MON-YYYY')) ;
667: FND_FILE.PUT_LINE(FND_FILE.LOG,'Minimum limit of Range : ' || TO_CHAR(p_min_number));
668: FND_FILE.PUT_LINE(FND_FILE.LOG,'Maximum limit of Range : ' || TO_CHAR(p_max_number));
669: FND_FILE.PUT_LINE(FND_FILE.LOG,'Reallocate Anonymous ID : ' || c_reallocate_rec.meaning );

Line 666: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calendar End Date : ' || TO_CHAR(c_cal_rec.end_dt,'DD-MON-YYYY')) ;

662: FND_FILE.PUT_LINE(FND_FILE.LOG,'+-------------------------Parameters Passed---------------------------------+');
663: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
664: FND_FILE.PUT_LINE(FND_FILE.LOG,'Load Calendar : ' || l_ld_cal_type);
665: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calendar Start Date : ' || TO_CHAR(c_cal_rec.start_dt,'DD-MON-YYYY'));
666: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calendar End Date : ' || TO_CHAR(c_cal_rec.end_dt,'DD-MON-YYYY')) ;
667: FND_FILE.PUT_LINE(FND_FILE.LOG,'Minimum limit of Range : ' || TO_CHAR(p_min_number));
668: FND_FILE.PUT_LINE(FND_FILE.LOG,'Maximum limit of Range : ' || TO_CHAR(p_max_number));
669: FND_FILE.PUT_LINE(FND_FILE.LOG,'Reallocate Anonymous ID : ' || c_reallocate_rec.meaning );
670:

Line 667: FND_FILE.PUT_LINE(FND_FILE.LOG,'Minimum limit of Range : ' || TO_CHAR(p_min_number));

663: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
664: FND_FILE.PUT_LINE(FND_FILE.LOG,'Load Calendar : ' || l_ld_cal_type);
665: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calendar Start Date : ' || TO_CHAR(c_cal_rec.start_dt,'DD-MON-YYYY'));
666: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calendar End Date : ' || TO_CHAR(c_cal_rec.end_dt,'DD-MON-YYYY')) ;
667: FND_FILE.PUT_LINE(FND_FILE.LOG,'Minimum limit of Range : ' || TO_CHAR(p_min_number));
668: FND_FILE.PUT_LINE(FND_FILE.LOG,'Maximum limit of Range : ' || TO_CHAR(p_max_number));
669: FND_FILE.PUT_LINE(FND_FILE.LOG,'Reallocate Anonymous ID : ' || c_reallocate_rec.meaning );
670:
671: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

Line 668: FND_FILE.PUT_LINE(FND_FILE.LOG,'Maximum limit of Range : ' || TO_CHAR(p_max_number));

664: FND_FILE.PUT_LINE(FND_FILE.LOG,'Load Calendar : ' || l_ld_cal_type);
665: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calendar Start Date : ' || TO_CHAR(c_cal_rec.start_dt,'DD-MON-YYYY'));
666: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calendar End Date : ' || TO_CHAR(c_cal_rec.end_dt,'DD-MON-YYYY')) ;
667: FND_FILE.PUT_LINE(FND_FILE.LOG,'Minimum limit of Range : ' || TO_CHAR(p_min_number));
668: FND_FILE.PUT_LINE(FND_FILE.LOG,'Maximum limit of Range : ' || TO_CHAR(p_max_number));
669: FND_FILE.PUT_LINE(FND_FILE.LOG,'Reallocate Anonymous ID : ' || c_reallocate_rec.meaning );
670:
671: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
672:

Line 669: FND_FILE.PUT_LINE(FND_FILE.LOG,'Reallocate Anonymous ID : ' || c_reallocate_rec.meaning );

665: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calendar Start Date : ' || TO_CHAR(c_cal_rec.start_dt,'DD-MON-YYYY'));
666: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calendar End Date : ' || TO_CHAR(c_cal_rec.end_dt,'DD-MON-YYYY')) ;
667: FND_FILE.PUT_LINE(FND_FILE.LOG,'Minimum limit of Range : ' || TO_CHAR(p_min_number));
668: FND_FILE.PUT_LINE(FND_FILE.LOG,'Maximum limit of Range : ' || TO_CHAR(p_max_number));
669: FND_FILE.PUT_LINE(FND_FILE.LOG,'Reallocate Anonymous ID : ' || c_reallocate_rec.meaning );
670:
671: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
672:
673: -- Find Anonymous Grading Method for the Load Cal Type supplied

Line 671: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

667: FND_FILE.PUT_LINE(FND_FILE.LOG,'Minimum limit of Range : ' || TO_CHAR(p_min_number));
668: FND_FILE.PUT_LINE(FND_FILE.LOG,'Maximum limit of Range : ' || TO_CHAR(p_max_number));
669: FND_FILE.PUT_LINE(FND_FILE.LOG,'Reallocate Anonymous ID : ' || c_reallocate_rec.meaning );
670:
671: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
672:
673: -- Find Anonymous Grading Method for the Load Cal Type supplied
674: OPEN c_method(l_ld_cal_type);
675: FETCH c_method INTO c_method_rec;

Line 769: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

765: -- and existing Anonymous Numbers will be used.
766: IF l_anon_id_count > 0 THEN
767:
768: FND_MESSAGE.SET_NAME('IGS','IGS_AS_ANON_RANGE_N_USE');
769: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
770: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
771: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
772:
773: -- Check if the available anonymous numbers cover the required number

Line 770: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

766: IF l_anon_id_count > 0 THEN
767:
768: FND_MESSAGE.SET_NAME('IGS','IGS_AS_ANON_RANGE_N_USE');
769: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
770: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
771: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
772:
773: -- Check if the available anonymous numbers cover the required number
774: -- If enough Anonymous Numbers are not present then show ERROR with proper Message.

Line 771: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

767:
768: FND_MESSAGE.SET_NAME('IGS','IGS_AS_ANON_RANGE_N_USE');
769: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
770: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
771: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
772:
773: -- Check if the available anonymous numbers cover the required number
774: -- If enough Anonymous Numbers are not present then show ERROR with proper Message.
775:

Line 860: FND_FILE.PUT_LINE(FND_FILE.LOG,'+-------------------------Persons Processed---------------------------------+');

856: temp_table.DELETE;
857:
858: END IF;
859:
860: FND_FILE.PUT_LINE(FND_FILE.LOG,'+-------------------------Persons Processed---------------------------------+');
861:
862: IF l_method = 'PROGRAM' THEN
863: FOR c_spa_rec IN c_spa
864: LOOP

Line 869: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

865: OPEN c_person(c_spa_rec.person_id);
866: FETCH c_person INTO c_person_rec;
867: CLOSE c_person;
868:
869: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
870: FND_FILE.PUT_LINE(FND_FILE.LOG,'Person Number : ' || c_person_rec.party_number);
871: FND_FILE.PUT_LINE(FND_FILE.LOG,'Course Code : ' || c_spa_rec.course_cd);
872: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
873:

Line 870: FND_FILE.PUT_LINE(FND_FILE.LOG,'Person Number : ' || c_person_rec.party_number);

866: FETCH c_person INTO c_person_rec;
867: CLOSE c_person;
868:
869: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
870: FND_FILE.PUT_LINE(FND_FILE.LOG,'Person Number : ' || c_person_rec.party_number);
871: FND_FILE.PUT_LINE(FND_FILE.LOG,'Course Code : ' || c_spa_rec.course_cd);
872: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
873:
874: sub_get_insert( p_method => l_method,

Line 871: FND_FILE.PUT_LINE(FND_FILE.LOG,'Course Code : ' || c_spa_rec.course_cd);

867: CLOSE c_person;
868:
869: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
870: FND_FILE.PUT_LINE(FND_FILE.LOG,'Person Number : ' || c_person_rec.party_number);
871: FND_FILE.PUT_LINE(FND_FILE.LOG,'Course Code : ' || c_spa_rec.course_cd);
872: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
873:
874: sub_get_insert( p_method => l_method,
875: p_person_id => c_spa_rec.person_id,

Line 872: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

868:
869: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
870: FND_FILE.PUT_LINE(FND_FILE.LOG,'Person Number : ' || c_person_rec.party_number);
871: FND_FILE.PUT_LINE(FND_FILE.LOG,'Course Code : ' || c_spa_rec.course_cd);
872: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
873:
874: sub_get_insert( p_method => l_method,
875: p_person_id => c_spa_rec.person_id,
876: p_course_cd => c_spa_rec.course_cd,

Line 896: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

892: OPEN c_person(c_sua_rec.person_id);
893: FETCH c_person INTO c_person_rec;
894: CLOSE c_person;
895:
896: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
897: FND_FILE.PUT_LINE(FND_FILE.LOG,'Person Number : ' || c_person_rec.party_number);
898: FND_FILE.PUT_LINE(FND_FILE.LOG,'Course Code : ' || c_sua_rec.course_cd);
899: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unit Code : ' || c_sua_rec.unit_cd);
900: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unit Offering Option ID: ' || c_sua_rec.uoo_id);

Line 897: FND_FILE.PUT_LINE(FND_FILE.LOG,'Person Number : ' || c_person_rec.party_number);

893: FETCH c_person INTO c_person_rec;
894: CLOSE c_person;
895:
896: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
897: FND_FILE.PUT_LINE(FND_FILE.LOG,'Person Number : ' || c_person_rec.party_number);
898: FND_FILE.PUT_LINE(FND_FILE.LOG,'Course Code : ' || c_sua_rec.course_cd);
899: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unit Code : ' || c_sua_rec.unit_cd);
900: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unit Offering Option ID: ' || c_sua_rec.uoo_id);
901: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

Line 898: FND_FILE.PUT_LINE(FND_FILE.LOG,'Course Code : ' || c_sua_rec.course_cd);

894: CLOSE c_person;
895:
896: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
897: FND_FILE.PUT_LINE(FND_FILE.LOG,'Person Number : ' || c_person_rec.party_number);
898: FND_FILE.PUT_LINE(FND_FILE.LOG,'Course Code : ' || c_sua_rec.course_cd);
899: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unit Code : ' || c_sua_rec.unit_cd);
900: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unit Offering Option ID: ' || c_sua_rec.uoo_id);
901: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
902:

Line 899: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unit Code : ' || c_sua_rec.unit_cd);

895:
896: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
897: FND_FILE.PUT_LINE(FND_FILE.LOG,'Person Number : ' || c_person_rec.party_number);
898: FND_FILE.PUT_LINE(FND_FILE.LOG,'Course Code : ' || c_sua_rec.course_cd);
899: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unit Code : ' || c_sua_rec.unit_cd);
900: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unit Offering Option ID: ' || c_sua_rec.uoo_id);
901: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
902:
903: sub_get_insert( p_method => l_method,

Line 900: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unit Offering Option ID: ' || c_sua_rec.uoo_id);

896: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
897: FND_FILE.PUT_LINE(FND_FILE.LOG,'Person Number : ' || c_person_rec.party_number);
898: FND_FILE.PUT_LINE(FND_FILE.LOG,'Course Code : ' || c_sua_rec.course_cd);
899: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unit Code : ' || c_sua_rec.unit_cd);
900: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unit Offering Option ID: ' || c_sua_rec.uoo_id);
901: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
902:
903: sub_get_insert( p_method => l_method,
904: p_person_id => c_sua_rec.person_id,

Line 901: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

897: FND_FILE.PUT_LINE(FND_FILE.LOG,'Person Number : ' || c_person_rec.party_number);
898: FND_FILE.PUT_LINE(FND_FILE.LOG,'Course Code : ' || c_sua_rec.course_cd);
899: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unit Code : ' || c_sua_rec.unit_cd);
900: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unit Offering Option ID: ' || c_sua_rec.uoo_id);
901: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
902:
903: sub_get_insert( p_method => l_method,
904: p_person_id => c_sua_rec.person_id,
905: p_course_cd => c_sua_rec.course_cd,

Line 925: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

921: OPEN c_person(c_suaai_rec.person_id);
922: FETCH c_person INTO c_person_rec;
923: CLOSE c_person;
924:
925: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
926: FND_FILE.PUT_LINE(FND_FILE.LOG,'Person Number : ' || c_person_rec.party_number);
927: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assessment Type : ' || c_suaai_rec.assessment_type);
928: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
929:

Line 926: FND_FILE.PUT_LINE(FND_FILE.LOG,'Person Number : ' || c_person_rec.party_number);

922: FETCH c_person INTO c_person_rec;
923: CLOSE c_person;
924:
925: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
926: FND_FILE.PUT_LINE(FND_FILE.LOG,'Person Number : ' || c_person_rec.party_number);
927: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assessment Type : ' || c_suaai_rec.assessment_type);
928: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
929:
930: sub_get_insert( p_method => l_method,

Line 927: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assessment Type : ' || c_suaai_rec.assessment_type);

923: CLOSE c_person;
924:
925: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
926: FND_FILE.PUT_LINE(FND_FILE.LOG,'Person Number : ' || c_person_rec.party_number);
927: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assessment Type : ' || c_suaai_rec.assessment_type);
928: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
929:
930: sub_get_insert( p_method => l_method,
931: p_person_id => c_suaai_rec.person_id,

Line 928: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

924:
925: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
926: FND_FILE.PUT_LINE(FND_FILE.LOG,'Person Number : ' || c_person_rec.party_number);
927: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assessment Type : ' || c_suaai_rec.assessment_type);
928: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
929:
930: sub_get_insert( p_method => l_method,
931: p_person_id => c_suaai_rec.person_id,
932: p_course_cd => NULL,

Line 951: FND_FILE.PUT_LINE(fnd_file.log,' ');

947: WHEN PARAM_ERROR THEN
948: ROLLBACK ;
949: retcode := 1 ;
950:
951: FND_FILE.PUT_LINE(fnd_file.log,' ');
952: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
953: FND_FILE.PUT_LINE(fnd_file.log,' ');
954:
955:

Line 952: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

948: ROLLBACK ;
949: retcode := 1 ;
950:
951: FND_FILE.PUT_LINE(fnd_file.log,' ');
952: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
953: FND_FILE.PUT_LINE(fnd_file.log,' ');
954:
955:
956: WHEN OTHERS THEN

Line 953: FND_FILE.PUT_LINE(fnd_file.log,' ');

949: retcode := 1 ;
950:
951: FND_FILE.PUT_LINE(fnd_file.log,' ');
952: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
953: FND_FILE.PUT_LINE(fnd_file.log,' ');
954:
955:
956: WHEN OTHERS THEN
957: ROLLBACK ;

Line 959: FND_FILE.PUT_LINE(FND_FILE.LOG,'SQL Error Message :'||SQLERRM);

955:
956: WHEN OTHERS THEN
957: ROLLBACK ;
958: retcode := 2 ;
959: FND_FILE.PUT_LINE(FND_FILE.LOG,'SQL Error Message :'||SQLERRM);
960: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
961: FND_MESSAGE.SET_TOKEN('NAME','IGS_AS_ANON_GRD_PKG.MNT_ANON_ID');
962: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
963: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL ;

Line 962: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

958: retcode := 2 ;
959: FND_FILE.PUT_LINE(FND_FILE.LOG,'SQL Error Message :'||SQLERRM);
960: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
961: FND_MESSAGE.SET_TOKEN('NAME','IGS_AS_ANON_GRD_PKG.MNT_ANON_ID');
962: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
963: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL ;
964:
965: END mnt_anon_id;
966: