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.IGF_SE_GEN_001 dependencies on FND_MESSAGE

Line 479: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');

475: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
476: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth',' Unhandled Exception ->' || SQLERRM);
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

Line 480: FND_MESSAGE.SET_TOKEN('NAME','igf_se_gen_001.send_work_auth:igf_se_auth.insert') ;

476: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth',' Unhandled Exception ->' || SQLERRM);
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

Line 513: FND_MESSAGE.SET_NAME('IGF','IGF_AW_PARAM_ERR');

509: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
510: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth',' Parameter Error');
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;

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

510: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth',' Parameter Error');
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:

Line 701: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');

697: IF c_auth_check%ISOPEN THEN
698: CLOSE c_auth_check;
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

Line 702: FND_MESSAGE.SET_TOKEN('NAME','igf_se_gen_001.send_work_auth:igf_se_auth.update');

698: CLOSE c_auth_check;
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

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

715: END IF;
716:
717: EXCEPTION -- for auth creation
718: WHEN next_record THEN
719: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
720: ROLLBACK TO se_payment;
721: END ; -- for auth generation
722:
723: IF p_call IN ('JOB','SE003') THEN

Line 728: fnd_message.set_name('IGF','IGF_SE_REQUERY_AUTH');

724: /*
725: If called from AW016, COMMIT should not be issued.
726: */
727: COMMIT; --Committing the Transaction
728: fnd_message.set_name('IGF','IGF_SE_REQUERY_AUTH');
729: fnd_file.put_line(fnd_file.log,fnd_message.get);
730: END IF;
731:
732: EXCEPTION -- for main block

Line 729: fnd_file.put_line(fnd_file.log,fnd_message.get);

725: If called from AW016, COMMIT should not be issued.
726: */
727: COMMIT; --Committing the Transaction
728: fnd_message.set_name('IGF','IGF_SE_REQUERY_AUTH');
729: fnd_file.put_line(fnd_file.log,fnd_message.get);
730: END IF;
731:
732: EXCEPTION -- for main block
733: WHEN no_data_found THEN

Line 735: FND_MESSAGE.SET_NAME('IGF','IGF_SE_INVALID_SETUP');

731:
732: EXCEPTION -- for main block
733: WHEN no_data_found THEN
734:
735: FND_MESSAGE.SET_NAME('IGF','IGF_SE_INVALID_SETUP');
736: IF l_place = 'FUND' THEN
737: FND_MESSAGE.SET_TOKEN('PLACE','FUND');
738: ELSIF l_place = 'HZ' THEN
739: FND_MESSAGE.SET_TOKEN('PLACE','HZ:PERSON');

Line 737: FND_MESSAGE.SET_TOKEN('PLACE','FUND');

733: WHEN no_data_found THEN
734:
735: FND_MESSAGE.SET_NAME('IGF','IGF_SE_INVALID_SETUP');
736: IF l_place = 'FUND' THEN
737: FND_MESSAGE.SET_TOKEN('PLACE','FUND');
738: ELSIF l_place = 'HZ' THEN
739: FND_MESSAGE.SET_TOKEN('PLACE','HZ:PERSON');
740: ELSIF l_place = 'PE' THEN
741: FND_MESSAGE.SET_TOKEN('PLACE','PERSON');

Line 739: FND_MESSAGE.SET_TOKEN('PLACE','HZ:PERSON');

735: FND_MESSAGE.SET_NAME('IGF','IGF_SE_INVALID_SETUP');
736: IF l_place = 'FUND' THEN
737: FND_MESSAGE.SET_TOKEN('PLACE','FUND');
738: ELSIF l_place = 'HZ' THEN
739: FND_MESSAGE.SET_TOKEN('PLACE','HZ:PERSON');
740: ELSIF l_place = 'PE' THEN
741: FND_MESSAGE.SET_TOKEN('PLACE','PERSON');
742: ELSIF l_place = 'VISA' THEN
743: FND_MESSAGE.SET_TOKEN('PLACE','VISA');

Line 741: FND_MESSAGE.SET_TOKEN('PLACE','PERSON');

737: FND_MESSAGE.SET_TOKEN('PLACE','FUND');
738: ELSIF l_place = 'HZ' THEN
739: FND_MESSAGE.SET_TOKEN('PLACE','HZ:PERSON');
740: ELSIF l_place = 'PE' THEN
741: FND_MESSAGE.SET_TOKEN('PLACE','PERSON');
742: ELSIF l_place = 'VISA' THEN
743: FND_MESSAGE.SET_TOKEN('PLACE','VISA');
744:
745: ELSIF l_place = 'COUNTRY' THEN

Line 743: FND_MESSAGE.SET_TOKEN('PLACE','VISA');

739: FND_MESSAGE.SET_TOKEN('PLACE','HZ:PERSON');
740: ELSIF l_place = 'PE' THEN
741: FND_MESSAGE.SET_TOKEN('PLACE','PERSON');
742: ELSIF l_place = 'VISA' THEN
743: FND_MESSAGE.SET_TOKEN('PLACE','VISA');
744:
745: ELSIF l_place = 'COUNTRY' THEN
746: FND_MESSAGE.SET_TOKEN('PLACE',IGF_AP_GEN.GET_LOOKUP_MEANING('IGF_AP_MAP_PROFILE','COUNTRY'));
747: ELSIF l_place = 'MARITAL' THEN

Line 746: FND_MESSAGE.SET_TOKEN('PLACE',IGF_AP_GEN.GET_LOOKUP_MEANING('IGF_AP_MAP_PROFILE','COUNTRY'));

742: ELSIF l_place = 'VISA' THEN
743: FND_MESSAGE.SET_TOKEN('PLACE','VISA');
744:
745: ELSIF l_place = 'COUNTRY' THEN
746: FND_MESSAGE.SET_TOKEN('PLACE',IGF_AP_GEN.GET_LOOKUP_MEANING('IGF_AP_MAP_PROFILE','COUNTRY'));
747: ELSIF l_place = 'MARITAL' THEN
748: FND_MESSAGE.SET_TOKEN('PLACE',IGF_AP_GEN.GET_LOOKUP_MEANING('IGF_AP_MAP_PROFILE','MARITAL_STATUS'));
749: ELSIF l_place = 'F_NAME' THEN
750: FND_MESSAGE.SET_TOKEN('PLACE',IGF_AP_GEN.GET_LOOKUP_MEANING('IGF_AP_MAP_PROFILE','FIRST_NAME'));

Line 748: FND_MESSAGE.SET_TOKEN('PLACE',IGF_AP_GEN.GET_LOOKUP_MEANING('IGF_AP_MAP_PROFILE','MARITAL_STATUS'));

744:
745: ELSIF l_place = 'COUNTRY' THEN
746: FND_MESSAGE.SET_TOKEN('PLACE',IGF_AP_GEN.GET_LOOKUP_MEANING('IGF_AP_MAP_PROFILE','COUNTRY'));
747: ELSIF l_place = 'MARITAL' THEN
748: FND_MESSAGE.SET_TOKEN('PLACE',IGF_AP_GEN.GET_LOOKUP_MEANING('IGF_AP_MAP_PROFILE','MARITAL_STATUS'));
749: ELSIF l_place = 'F_NAME' THEN
750: FND_MESSAGE.SET_TOKEN('PLACE',IGF_AP_GEN.GET_LOOKUP_MEANING('IGF_AP_MAP_PROFILE','FIRST_NAME'));
751: ELSIF l_place = 'L_NAME' THEN
752: FND_MESSAGE.SET_TOKEN('PLACE',IGF_AP_GEN.GET_LOOKUP_MEANING('IGF_AP_MAP_PROFILE','LAST_NAME'));

Line 750: FND_MESSAGE.SET_TOKEN('PLACE',IGF_AP_GEN.GET_LOOKUP_MEANING('IGF_AP_MAP_PROFILE','FIRST_NAME'));

746: FND_MESSAGE.SET_TOKEN('PLACE',IGF_AP_GEN.GET_LOOKUP_MEANING('IGF_AP_MAP_PROFILE','COUNTRY'));
747: ELSIF l_place = 'MARITAL' THEN
748: FND_MESSAGE.SET_TOKEN('PLACE',IGF_AP_GEN.GET_LOOKUP_MEANING('IGF_AP_MAP_PROFILE','MARITAL_STATUS'));
749: ELSIF l_place = 'F_NAME' THEN
750: FND_MESSAGE.SET_TOKEN('PLACE',IGF_AP_GEN.GET_LOOKUP_MEANING('IGF_AP_MAP_PROFILE','FIRST_NAME'));
751: ELSIF l_place = 'L_NAME' THEN
752: FND_MESSAGE.SET_TOKEN('PLACE',IGF_AP_GEN.GET_LOOKUP_MEANING('IGF_AP_MAP_PROFILE','LAST_NAME'));
753:
754: ELSIF l_place = 'SSN' THEN

Line 752: FND_MESSAGE.SET_TOKEN('PLACE',IGF_AP_GEN.GET_LOOKUP_MEANING('IGF_AP_MAP_PROFILE','LAST_NAME'));

748: FND_MESSAGE.SET_TOKEN('PLACE',IGF_AP_GEN.GET_LOOKUP_MEANING('IGF_AP_MAP_PROFILE','MARITAL_STATUS'));
749: ELSIF l_place = 'F_NAME' THEN
750: FND_MESSAGE.SET_TOKEN('PLACE',IGF_AP_GEN.GET_LOOKUP_MEANING('IGF_AP_MAP_PROFILE','FIRST_NAME'));
751: ELSIF l_place = 'L_NAME' THEN
752: FND_MESSAGE.SET_TOKEN('PLACE',IGF_AP_GEN.GET_LOOKUP_MEANING('IGF_AP_MAP_PROFILE','LAST_NAME'));
753:
754: ELSIF l_place = 'SSN' THEN
755: OPEN c_get_tokens;
756: FETCH c_get_tokens INTO tokens_rec;

Line 757: FND_MESSAGE.SET_TOKEN('PLACE',TRIM(tokens_rec.meaning));

753:
754: ELSIF l_place = 'SSN' THEN
755: OPEN c_get_tokens;
756: FETCH c_get_tokens INTO tokens_rec;
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;

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

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);
766: RAISE IGFSEGEN001;
767: END IF;
768:
769: IF p_call = 'JOB' THEN -- continue for next student dont stop

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

766: RAISE IGFSEGEN001;
767: END IF;
768:
769: IF p_call = 'JOB' THEN -- continue for next student dont stop
770: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
771: ELSE -- this means its called from FORM
772: APP_EXCEPTION.RAISE_EXCEPTION;
773: END IF;
774:

Line 777: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');

773: END IF;
774:
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;

Line 778: FND_MESSAGE.SET_TOKEN('NAME','igf_se_gen_001.send_work_auth' || SQLERRM);

774:
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;

Line 915: fnd_message.set_name('IGF','IGF_SE_AUTH_GENERATED');

911:
912: IF l_amounts.accepted_amt = l_amounts.accepted_amnt THEN
913: --no need to recreate authorization
914: --log a message
915: fnd_message.set_name('IGF','IGF_SE_AUTH_GENERATED');
916: fnd_file.put_line(fnd_file.log,fnd_message.get);
917: ELSE
918: igf_se_gen_001.send_work_auth(
919: auth_rec.base_id,

Line 916: fnd_file.put_line(fnd_file.log,fnd_message.get);

912: IF l_amounts.accepted_amt = l_amounts.accepted_amnt THEN
913: --no need to recreate authorization
914: --log a message
915: fnd_message.set_name('IGF','IGF_SE_AUTH_GENERATED');
916: fnd_file.put_line(fnd_file.log,fnd_message.get);
917: ELSE
918: igf_se_gen_001.send_work_auth(
919: auth_rec.base_id,
920: auth_rec.person_id,

Line 950: FND_MESSAGE.SET_NAME('IGF','IGF_SE_WRK_ATUH_NO_MATCH');

946: CLOSE c_auth;
947: END IF;
948:
949: IF lb_rec_found = FALSE THEN
950: FND_MESSAGE.SET_NAME('IGF','IGF_SE_WRK_ATUH_NO_MATCH');
951: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
952: END IF;
953: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
954:

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

947: END IF;
948:
949: IF lb_rec_found = FALSE THEN
950: FND_MESSAGE.SET_NAME('IGF','IGF_SE_WRK_ATUH_NO_MATCH');
951: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
952: END IF;
953: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
954:
955: EXCEPTION

Line 959: FND_MESSAGE.SET_TOKEN('NAME','igf_se_gen_001.send_work_auth_job');

955: EXCEPTION
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;

Line 961: errbuf := FND_MESSAGE.GET ;

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

Line 1075: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');

1071: );
1072:
1073: EXCEPTION
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;

Line 1076: FND_MESSAGE.SET_TOKEN('NAME','igf_se_gen_001.payroll_upload:igf_se_payment_int.update');

1072:
1073: EXCEPTION
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:

Line 1077: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);

1073: EXCEPTION
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;

Line 1100: FND_MESSAGE.SET_NAME('IGF','IGF_AW_PARAM_ERR');

1096: display_payroll_params(l_batch_id, l_auth_id, l_level);
1097:
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;

Line 1101: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);

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

Line 1135: fnd_file.put_line(fnd_file.log,fnd_message.get);

1131: x_source => l_source
1132: );
1133: EXCEPTION
1134: WHEN OTHERS THEN
1135: fnd_file.put_line(fnd_file.log,fnd_message.get);
1136: ROLLBACK TO se_adjust;
1137: l_error_cd := 'SE005';
1138: update_record(payment_rec,l_error_cd);
1139: RAISE SKIP_RECORD;

Line 1157: FND_MESSAGE.SET_NAME('IGF','IGF_SE_SUCCESS');

1153: BEGIN
1154:
1155: FOR cur_pymt_int_rec IN cur_pymt_int LOOP
1156: IF cur_pymt_int_rec.status = 'DONE' THEN
1157: FND_MESSAGE.SET_NAME('IGF','IGF_SE_SUCCESS');
1158: FND_MESSAGE.SET_TOKEN('NUMBER',cur_pymt_int_rec.party_number);
1159: FND_MESSAGE.SET_TOKEN('AUTHID',cur_pymt_int_rec.auth_id);
1160: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
1161:

Line 1158: FND_MESSAGE.SET_TOKEN('NUMBER',cur_pymt_int_rec.party_number);

1154:
1155: FOR cur_pymt_int_rec IN cur_pymt_int LOOP
1156: IF cur_pymt_int_rec.status = 'DONE' THEN
1157: FND_MESSAGE.SET_NAME('IGF','IGF_SE_SUCCESS');
1158: FND_MESSAGE.SET_TOKEN('NUMBER',cur_pymt_int_rec.party_number);
1159: FND_MESSAGE.SET_TOKEN('AUTHID',cur_pymt_int_rec.auth_id);
1160: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
1161:
1162: ELSIF cur_pymt_int_rec.status = 'ERROR' THEN

Line 1159: FND_MESSAGE.SET_TOKEN('AUTHID',cur_pymt_int_rec.auth_id);

1155: FOR cur_pymt_int_rec IN cur_pymt_int LOOP
1156: IF cur_pymt_int_rec.status = 'DONE' THEN
1157: FND_MESSAGE.SET_NAME('IGF','IGF_SE_SUCCESS');
1158: FND_MESSAGE.SET_TOKEN('NUMBER',cur_pymt_int_rec.party_number);
1159: FND_MESSAGE.SET_TOKEN('AUTHID',cur_pymt_int_rec.auth_id);
1160: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
1161:
1162: ELSIF cur_pymt_int_rec.status = 'ERROR' THEN
1163: OPEN c_get_se_errors( cur_pymt_int_rec.error_code);

Line 1160: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);

1156: IF cur_pymt_int_rec.status = 'DONE' THEN
1157: FND_MESSAGE.SET_NAME('IGF','IGF_SE_SUCCESS');
1158: FND_MESSAGE.SET_TOKEN('NUMBER',cur_pymt_int_rec.party_number);
1159: FND_MESSAGE.SET_TOKEN('AUTHID',cur_pymt_int_rec.auth_id);
1160: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
1161:
1162: ELSIF cur_pymt_int_rec.status = 'ERROR' THEN
1163: OPEN c_get_se_errors( cur_pymt_int_rec.error_code);
1164: FETCH c_get_se_errors INTO l_error_meaming;

Line 1167: FND_MESSAGE.SET_NAME('IGF','IGF_SE_NOT_SUCCESS');

1163: OPEN c_get_se_errors( cur_pymt_int_rec.error_code);
1164: FETCH c_get_se_errors INTO l_error_meaming;
1165: CLOSE c_get_se_errors;
1166:
1167: FND_MESSAGE.SET_NAME('IGF','IGF_SE_NOT_SUCCESS');
1168: FND_MESSAGE.SET_TOKEN('NUMBER',cur_pymt_int_rec.party_number);
1169: FND_MESSAGE.SET_TOKEN('AUTHID',cur_pymt_int_rec.auth_id);
1170: FND_MESSAGE.SET_TOKEN('ERROR',l_error_meaming);
1171: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);

Line 1168: FND_MESSAGE.SET_TOKEN('NUMBER',cur_pymt_int_rec.party_number);

1164: FETCH c_get_se_errors INTO l_error_meaming;
1165: CLOSE c_get_se_errors;
1166:
1167: FND_MESSAGE.SET_NAME('IGF','IGF_SE_NOT_SUCCESS');
1168: FND_MESSAGE.SET_TOKEN('NUMBER',cur_pymt_int_rec.party_number);
1169: FND_MESSAGE.SET_TOKEN('AUTHID',cur_pymt_int_rec.auth_id);
1170: FND_MESSAGE.SET_TOKEN('ERROR',l_error_meaming);
1171: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
1172:

Line 1169: FND_MESSAGE.SET_TOKEN('AUTHID',cur_pymt_int_rec.auth_id);

1165: CLOSE c_get_se_errors;
1166:
1167: FND_MESSAGE.SET_NAME('IGF','IGF_SE_NOT_SUCCESS');
1168: FND_MESSAGE.SET_TOKEN('NUMBER',cur_pymt_int_rec.party_number);
1169: FND_MESSAGE.SET_TOKEN('AUTHID',cur_pymt_int_rec.auth_id);
1170: FND_MESSAGE.SET_TOKEN('ERROR',l_error_meaming);
1171: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
1172:
1173: END IF;

Line 1170: FND_MESSAGE.SET_TOKEN('ERROR',l_error_meaming);

1166:
1167: FND_MESSAGE.SET_NAME('IGF','IGF_SE_NOT_SUCCESS');
1168: FND_MESSAGE.SET_TOKEN('NUMBER',cur_pymt_int_rec.party_number);
1169: FND_MESSAGE.SET_TOKEN('AUTHID',cur_pymt_int_rec.auth_id);
1170: FND_MESSAGE.SET_TOKEN('ERROR',l_error_meaming);
1171: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
1172:
1173: END IF;
1174: END LOOP;

Line 1171: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);

1167: FND_MESSAGE.SET_NAME('IGF','IGF_SE_NOT_SUCCESS');
1168: FND_MESSAGE.SET_TOKEN('NUMBER',cur_pymt_int_rec.party_number);
1169: FND_MESSAGE.SET_TOKEN('AUTHID',cur_pymt_int_rec.auth_id);
1170: FND_MESSAGE.SET_TOKEN('ERROR',l_error_meaming);
1171: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
1172:
1173: END IF;
1174: END LOOP;
1175:

Line 1182: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');

1178: AND batch_id = l_batch_id;
1179:
1180: EXCEPTION
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;

Line 1183: FND_MESSAGE.SET_TOKEN('NAME','igf_se_gen_001.payroll_upload: delete record');

1179:
1180: EXCEPTION
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:

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

1180: EXCEPTION
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,' ');

Line 1192: FND_MESSAGE.SET_NAME('IGS','IGS_UC_HE_NO_DATA');

1188: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1189:
1190: IF l_rec_count = 0 THEN
1191: -- There are no Records to process
1192: FND_MESSAGE.SET_NAME('IGS','IGS_UC_HE_NO_DATA');
1193: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
1194:
1195: ELSE
1196: -- Total Records Processed : RCOUNT

Line 1193: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);

1189:
1190: IF l_rec_count = 0 THEN
1191: -- There are no Records to process
1192: FND_MESSAGE.SET_NAME('IGS','IGS_UC_HE_NO_DATA');
1193: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
1194:
1195: ELSE
1196: -- Total Records Processed : RCOUNT
1197: FND_MESSAGE.SET_NAME('IGS','IGS_AD_TOT_REC_PRC');

Line 1197: FND_MESSAGE.SET_NAME('IGS','IGS_AD_TOT_REC_PRC');

1193: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
1194:
1195: ELSE
1196: -- Total Records Processed : RCOUNT
1197: FND_MESSAGE.SET_NAME('IGS','IGS_AD_TOT_REC_PRC');
1198: FND_MESSAGE.SET_TOKEN('RCOUNT',l_rec_count);
1199: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
1200:
1201: END IF;

Line 1198: FND_MESSAGE.SET_TOKEN('RCOUNT',l_rec_count);

1194:
1195: ELSE
1196: -- Total Records Processed : RCOUNT
1197: FND_MESSAGE.SET_NAME('IGS','IGS_AD_TOT_REC_PRC');
1198: FND_MESSAGE.SET_TOKEN('RCOUNT',l_rec_count);
1199: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
1200:
1201: END IF;
1202: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

Line 1199: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);

1195: ELSE
1196: -- Total Records Processed : RCOUNT
1197: FND_MESSAGE.SET_NAME('IGS','IGS_AD_TOT_REC_PRC');
1198: FND_MESSAGE.SET_TOKEN('RCOUNT',l_rec_count);
1199: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
1200:
1201: END IF;
1202: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1203:

Line 1208: FND_MESSAGE.SET_TOKEN('NAME','igf_se_gen_001.payroll_upload');

1204: EXCEPTION -- main exception handling
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:

Line 1210: errbuf := FND_MESSAGE.GET ;

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;
1214:

Line 1639: fnd_message.set_name('IGF','IGF_SE_MSG_SUBJ');

1635: pParameterList => l_wf_parameter_list_t
1636: );
1637:
1638: -- Pass Person Number, Person Name, Fund Code, Earned Amount and threshold percentage or value that is marked at the Fund Level as the event parameters
1639: fnd_message.set_name('IGF','IGF_SE_MSG_SUBJ');
1640: wf_event.addparametertolist(
1641: p_name => 'SUBJECT',
1642: p_value => fnd_message.get,
1643: p_parameterlist => l_wf_parameter_list_t

Line 1642: p_value => fnd_message.get,

1638: -- Pass Person Number, Person Name, Fund Code, Earned Amount and threshold percentage or value that is marked at the Fund Level as the event parameters
1639: fnd_message.set_name('IGF','IGF_SE_MSG_SUBJ');
1640: wf_event.addparametertolist(
1641: p_name => 'SUBJECT',
1642: p_value => fnd_message.get,
1643: p_parameterlist => l_wf_parameter_list_t
1644: );
1645:
1646: -- Get the body of the mail from fnd_new_messages and assign it to the attribute defined in the workflow definition

Line 1647: fnd_message.set_name('IGF','IGF_AP_SAP_MSG_SUBJ');

1643: p_parameterlist => l_wf_parameter_list_t
1644: );
1645:
1646: -- Get the body of the mail from fnd_new_messages and assign it to the attribute defined in the workflow definition
1647: fnd_message.set_name('IGF','IGF_AP_SAP_MSG_SUBJ');
1648: wf_event.addparametertolist(
1649: p_name => 'MESSGAE_BODY',
1650: p_value => fnd_message.get,
1651: p_parameterlist => l_wf_parameter_list_t

Line 1650: p_value => fnd_message.get,

1646: -- Get the body of the mail from fnd_new_messages and assign it to the attribute defined in the workflow definition
1647: fnd_message.set_name('IGF','IGF_AP_SAP_MSG_SUBJ');
1648: wf_event.addparametertolist(
1649: p_name => 'MESSGAE_BODY',
1650: p_value => fnd_message.get,
1651: p_parameterlist => l_wf_parameter_list_t
1652: );
1653:
1654:

Line 1702: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');

1698: END IF;
1699:
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;

Line 1703: FND_MESSAGE.SET_TOKEN('NAME','igf_se_gen_001.se_notify');

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