477: END IF;
478:
479: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');
480: FND_MESSAGE.SET_TOKEN('NAME','igf_se_gen_001.send_work_auth:igf_se_auth.insert') ;
481: IGS_GE_MSG_STACK.ADD;
482:
483: IF p_call = 'JOB' THEN -- continue for next student dont stop
484: RAISE NEXT_RECORD; -- user defined exception
485: ELSE -- this means its called from FORM
511: END IF;
512:
513: FND_MESSAGE.SET_NAME('IGF','IGF_AW_PARAM_ERR');
514: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
515: IGS_GE_MSG_STACK.ADD;
516: APP_EXCEPTION.RAISE_EXCEPTION;
517: END IF;
518:
519: -- get fund setup details.
699: END IF;
700:
701: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');
702: FND_MESSAGE.SET_TOKEN('NAME','igf_se_gen_001.send_work_auth:igf_se_auth.update');
703: IGS_GE_MSG_STACK.ADD;
704:
705: IF p_call = 'JOB' THEN -- continue for next student dont stop
706: RAISE next_record; -- user defined exception
707: ELSE -- this means its called from FORM
757: FND_MESSAGE.SET_TOKEN('PLACE',TRIM(tokens_rec.meaning));
758: CLOSE c_get_tokens;
759: END IF;
760:
761: IGS_GE_MSG_STACK.ADD;
762:
763: -- Bug #3536039. Raise exception IGFSEGEN001
764: IF p_call = 'LEGACY' THEN -- throw exception
765: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
775: WHEN OTHERS THEN
776: fnd_file.put_line(fnd_file.log,SQLERRM);
777: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');
778: FND_MESSAGE.SET_TOKEN('NAME','igf_se_gen_001.send_work_auth' || SQLERRM);
779: IGS_GE_MSG_STACK.ADD;
780:
781: APP_EXCEPTION.RAISE_EXCEPTION;
782: END send_work_auth;
783:
956: WHEN OTHERS THEN
957: ROLLBACK;
958: retcode:=2;
959: FND_MESSAGE.SET_TOKEN('NAME','igf_se_gen_001.send_work_auth_job');
960: IGS_GE_MSG_STACK.ADD;
961: errbuf := FND_MESSAGE.GET ;
962: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL ;
963: END send_work_auth_job;
964:
958: retcode:=2;
959: FND_MESSAGE.SET_TOKEN('NAME','igf_se_gen_001.send_work_auth_job');
960: IGS_GE_MSG_STACK.ADD;
961: errbuf := FND_MESSAGE.GET ;
962: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL ;
963: END send_work_auth_job;
964:
965:
966: PROCEDURE payroll_uplaod(errbuf OUT NOCOPY VARCHAR2,
1074: WHEN OTHERS THEN
1075: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');
1076: FND_MESSAGE.SET_TOKEN('NAME','igf_se_gen_001.payroll_upload:igf_se_payment_int.update');
1077: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
1078: IGS_GE_MSG_STACK.ADD;
1079: -- app_exception.raise_exception;
1080:
1081: END update_record;
1082:
1098: -- batch_id is mandatory parameter.
1099: IF l_batch_id IS NULL THEN
1100: FND_MESSAGE.SET_NAME('IGF','IGF_AW_PARAM_ERR');
1101: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
1102: IGS_GE_MSG_STACK.ADD;
1103: APP_EXCEPTION.RAISE_EXCEPTION;
1104: END IF;
1105:
1106: -- loop for all records. If auth_id is present then there will be only one record with the combination
1181: WHEN OTHERS THEN
1182: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');
1183: FND_MESSAGE.SET_TOKEN('NAME','igf_se_gen_001.payroll_upload: delete record');
1184: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1185: IGS_GE_MSG_STACK.ADD;
1186: END;
1187:
1188: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1189:
1205: WHEN OTHERS THEN
1206: ROLLBACK ;
1207: retcode:=2;
1208: FND_MESSAGE.SET_TOKEN('NAME','igf_se_gen_001.payroll_upload');
1209: IGS_GE_MSG_STACK.ADD;
1210: errbuf := FND_MESSAGE.GET ;
1211: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL ;
1212:
1213: END payroll_uplaod;
1207: retcode:=2;
1208: FND_MESSAGE.SET_TOKEN('NAME','igf_se_gen_001.payroll_upload');
1209: IGS_GE_MSG_STACK.ADD;
1210: errbuf := FND_MESSAGE.GET ;
1211: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL ;
1212:
1213: END payroll_uplaod;
1214:
1215:
1700: EXCEPTION
1701: WHEN OTHERS THEN
1702: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');
1703: FND_MESSAGE.SET_TOKEN('NAME','igf_se_gen_001.se_notify');
1704: IGS_GE_MSG_STACK.ADD;
1705: APP_EXCEPTION.RAISE_EXCEPTION;
1706: END se_notify;
1707:
1708: END igf_se_gen_001;