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_UC_EXPORT_TO_OSS dependencies on FND_MESSAGE

Line 275: fnd_message.set_name('IGS','IGS_UC_NO_OSS_PERS');

271: OPEN c_pe_person;
272: FETCH c_pe_person INTO c_pe_person_rec;
273: IF c_pe_person%NOTFOUND THEN
274: -- This applicant is not present in OSS ,hence log error and skip this person
275: fnd_message.set_name('IGS','IGS_UC_NO_OSS_PERS');
276: fnd_message.set_token('APP_NO',p_app_no);
277: fnd_file.put_line( fnd_file.LOG ,fnd_message.get );
278: ELSE
279: -- Since person is present in OSS , get his person details to populate person interface tables

Line 276: fnd_message.set_token('APP_NO',p_app_no);

272: FETCH c_pe_person INTO c_pe_person_rec;
273: IF c_pe_person%NOTFOUND THEN
274: -- This applicant is not present in OSS ,hence log error and skip this person
275: fnd_message.set_name('IGS','IGS_UC_NO_OSS_PERS');
276: fnd_message.set_token('APP_NO',p_app_no);
277: fnd_file.put_line( fnd_file.LOG ,fnd_message.get );
278: ELSE
279: -- Since person is present in OSS , get his person details to populate person interface tables
280:

Line 277: fnd_file.put_line( fnd_file.LOG ,fnd_message.get );

273: IF c_pe_person%NOTFOUND THEN
274: -- This applicant is not present in OSS ,hence log error and skip this person
275: fnd_message.set_name('IGS','IGS_UC_NO_OSS_PERS');
276: fnd_message.set_token('APP_NO',p_app_no);
277: fnd_file.put_line( fnd_file.LOG ,fnd_message.get );
278: ELSE
279: -- Since person is present in OSS , get his person details to populate person interface tables
280:
281: -- Get the interface ID for this person to be used to create record in igs_ad_interface table

Line 400: fnd_message.set_name('IGS','IGS_UC_NO_OSS_PROG_MAPPED');

396: END IF;
397:
398: -- If ucas program of this choice is not mapped to any oss pop then log an error and skip the choice
399: IF j.oss_program_code IS NULL OR j.oss_location IS NULL OR j.oss_attendance_mode IS NULL OR j.oss_attendance_type IS NULL THEN
400: fnd_message.set_name('IGS','IGS_UC_NO_OSS_PROG_MAPPED');
401: fnd_message.set_token('APP_NO',TO_CHAR(j.app_no));
402: fnd_message.set_token('CHOICE_NO',TO_CHAR(j.choice_no));
403: fnd_message.set_token('SYSTEM_CODE',j.system_code);
404: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);

Line 401: fnd_message.set_token('APP_NO',TO_CHAR(j.app_no));

397:
398: -- If ucas program of this choice is not mapped to any oss pop then log an error and skip the choice
399: IF j.oss_program_code IS NULL OR j.oss_location IS NULL OR j.oss_attendance_mode IS NULL OR j.oss_attendance_type IS NULL THEN
400: fnd_message.set_name('IGS','IGS_UC_NO_OSS_PROG_MAPPED');
401: fnd_message.set_token('APP_NO',TO_CHAR(j.app_no));
402: fnd_message.set_token('CHOICE_NO',TO_CHAR(j.choice_no));
403: fnd_message.set_token('SYSTEM_CODE',j.system_code);
404: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
405:

Line 402: fnd_message.set_token('CHOICE_NO',TO_CHAR(j.choice_no));

398: -- If ucas program of this choice is not mapped to any oss pop then log an error and skip the choice
399: IF j.oss_program_code IS NULL OR j.oss_location IS NULL OR j.oss_attendance_mode IS NULL OR j.oss_attendance_type IS NULL THEN
400: fnd_message.set_name('IGS','IGS_UC_NO_OSS_PROG_MAPPED');
401: fnd_message.set_token('APP_NO',TO_CHAR(j.app_no));
402: fnd_message.set_token('CHOICE_NO',TO_CHAR(j.choice_no));
403: fnd_message.set_token('SYSTEM_CODE',j.system_code);
404: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
405:
406: -- set the choice record error code to A002 and export status to OC to indicate that

Line 403: fnd_message.set_token('SYSTEM_CODE',j.system_code);

399: IF j.oss_program_code IS NULL OR j.oss_location IS NULL OR j.oss_attendance_mode IS NULL OR j.oss_attendance_type IS NULL THEN
400: fnd_message.set_name('IGS','IGS_UC_NO_OSS_PROG_MAPPED');
401: fnd_message.set_token('APP_NO',TO_CHAR(j.app_no));
402: fnd_message.set_token('CHOICE_NO',TO_CHAR(j.choice_no));
403: fnd_message.set_token('SYSTEM_CODE',j.system_code);
404: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
405:
406: -- set the choice record error code to A002 and export status to OC to indicate that
407: -- import interface tables have not been successfully populated but an error was encountered

Line 404: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);

400: fnd_message.set_name('IGS','IGS_UC_NO_OSS_PROG_MAPPED');
401: fnd_message.set_token('APP_NO',TO_CHAR(j.app_no));
402: fnd_message.set_token('CHOICE_NO',TO_CHAR(j.choice_no));
403: fnd_message.set_token('SYSTEM_CODE',j.system_code);
404: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
405:
406: -- set the choice record error code to A002 and export status to OC to indicate that
407: -- import interface tables have not been successfully populated but an error was encountered
408: l_ch_error := 'A002' ;

Line 434: fnd_message.set_name('IGS','IGS_UC_NO_UNIT_SET_CD');

430:
431: IF c_unit_set_cd%NOTFOUND THEN
432: -- If the point of entry doesnot correspond to a valid Unit set cd then log error and skip the choice
433: CLOSE c_unit_set_cd;
434: fnd_message.set_name('IGS','IGS_UC_NO_UNIT_SET_CD');
435: fnd_message.set_token('APP_NO',TO_CHAR(j.app_no));
436: fnd_message.set_token('CHOICE_NO',TO_CHAR(j.choice_no));
437: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
438: -- set the choice record error code to A003 and export status to OC to indicate that

Line 435: fnd_message.set_token('APP_NO',TO_CHAR(j.app_no));

431: IF c_unit_set_cd%NOTFOUND THEN
432: -- If the point of entry doesnot correspond to a valid Unit set cd then log error and skip the choice
433: CLOSE c_unit_set_cd;
434: fnd_message.set_name('IGS','IGS_UC_NO_UNIT_SET_CD');
435: fnd_message.set_token('APP_NO',TO_CHAR(j.app_no));
436: fnd_message.set_token('CHOICE_NO',TO_CHAR(j.choice_no));
437: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
438: -- set the choice record error code to A003 and export status to OC to indicate that
439: -- import interface tables have not been successfully populated but an error was encountered

Line 436: fnd_message.set_token('CHOICE_NO',TO_CHAR(j.choice_no));

432: -- If the point of entry doesnot correspond to a valid Unit set cd then log error and skip the choice
433: CLOSE c_unit_set_cd;
434: fnd_message.set_name('IGS','IGS_UC_NO_UNIT_SET_CD');
435: fnd_message.set_token('APP_NO',TO_CHAR(j.app_no));
436: fnd_message.set_token('CHOICE_NO',TO_CHAR(j.choice_no));
437: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
438: -- set the choice record error code to A003 and export status to OC to indicate that
439: -- import interface tables have not been successfully populated but an error was encountered
440: l_ch_error := 'A003' ;

Line 437: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);

433: CLOSE c_unit_set_cd;
434: fnd_message.set_name('IGS','IGS_UC_NO_UNIT_SET_CD');
435: fnd_message.set_token('APP_NO',TO_CHAR(j.app_no));
436: fnd_message.set_token('CHOICE_NO',TO_CHAR(j.choice_no));
437: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
438: -- set the choice record error code to A003 and export status to OC to indicate that
439: -- import interface tables have not been successfully populated but an error was encountered
440: l_ch_error := 'A003' ;
441: l_export_to_oss_status := 'OC' ;

Line 671: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');

667:
668: EXCEPTION
669: WHEN OTHERS THEN
670: ROLLBACK TO sp_current_person;
671: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
672: fnd_message.set_token('NAME','IGS_UCAS_EXPORT_TO_OSS.POPULATE_IMP_INT'||' - '||SQLERRM);
673: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
674: IGS_GE_MSG_STACK.ADD;
675: App_Exception.Raise_Exception;

Line 672: fnd_message.set_token('NAME','IGS_UCAS_EXPORT_TO_OSS.POPULATE_IMP_INT'||' - '||SQLERRM);

668: EXCEPTION
669: WHEN OTHERS THEN
670: ROLLBACK TO sp_current_person;
671: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
672: fnd_message.set_token('NAME','IGS_UCAS_EXPORT_TO_OSS.POPULATE_IMP_INT'||' - '||SQLERRM);
673: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
674: IGS_GE_MSG_STACK.ADD;
675: App_Exception.Raise_Exception;
676:

Line 673: fnd_file.put_line(fnd_file.LOG,fnd_message.get());

669: WHEN OTHERS THEN
670: ROLLBACK TO sp_current_person;
671: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
672: fnd_message.set_token('NAME','IGS_UCAS_EXPORT_TO_OSS.POPULATE_IMP_INT'||' - '||SQLERRM);
673: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
674: IGS_GE_MSG_STACK.ADD;
675: App_Exception.Raise_Exception;
676:
677: END populate_imp_int;

Line 741: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');

737:
738: EXCEPTION
739: WHEN OTHERS THEN
740: -- even though the admission import process completes in error , this process should continue processing
741: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
742: fnd_message.set_token('NAME','IGS_UCAS_EXPORT_TO_OSS.IMPORT_PROCESS'||' - '||SQLERRM);
743: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
744:
745: END import_process;

Line 742: fnd_message.set_token('NAME','IGS_UCAS_EXPORT_TO_OSS.IMPORT_PROCESS'||' - '||SQLERRM);

738: EXCEPTION
739: WHEN OTHERS THEN
740: -- even though the admission import process completes in error , this process should continue processing
741: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
742: fnd_message.set_token('NAME','IGS_UCAS_EXPORT_TO_OSS.IMPORT_PROCESS'||' - '||SQLERRM);
743: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
744:
745: END import_process;
746:

Line 743: fnd_file.put_line(fnd_file.LOG,fnd_message.get());

739: WHEN OTHERS THEN
740: -- even though the admission import process completes in error , this process should continue processing
741: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
742: fnd_message.set_token('NAME','IGS_UCAS_EXPORT_TO_OSS.IMPORT_PROCESS'||' - '||SQLERRM);
743: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
744:
745: END import_process;
746:
747: PROCEDURE obsolete_applications(

Line 1271: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');

1267: END IF;
1268:
1269: EXCEPTION
1270: WHEN OTHERS THEN
1271: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
1272: fnd_message.set_token('NAME','IGS_UCAS_EXPORT_TO_OSS.GET_BATCHID_LOC'||' - '||SQLERRM);
1273: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
1274: App_Exception.Raise_Exception;
1275:

Line 1272: fnd_message.set_token('NAME','IGS_UCAS_EXPORT_TO_OSS.GET_BATCHID_LOC'||' - '||SQLERRM);

1268:
1269: EXCEPTION
1270: WHEN OTHERS THEN
1271: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
1272: fnd_message.set_token('NAME','IGS_UCAS_EXPORT_TO_OSS.GET_BATCHID_LOC'||' - '||SQLERRM);
1273: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
1274: App_Exception.Raise_Exception;
1275:
1276: END get_batchid_loc;

Line 1273: fnd_file.put_line(fnd_file.LOG,fnd_message.get());

1269: EXCEPTION
1270: WHEN OTHERS THEN
1271: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
1272: fnd_message.set_token('NAME','IGS_UCAS_EXPORT_TO_OSS.GET_BATCHID_LOC'||' - '||SQLERRM);
1273: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
1274: App_Exception.Raise_Exception;
1275:
1276: END get_batchid_loc;
1277:

Line 1297: fnd_message.set_name('IGS','IGS_UC_DEC_BATCH');

1293: CLOSE cur_apc_det;
1294:
1295: -- We need to create a separate batch id for each of the UCAS System's calendars
1296: -- Get the Batch ID Description value from the Message,IGS_UC_DEC_BATCH
1297: fnd_message.set_name('IGS','IGS_UC_DEC_BATCH');
1298: l_description := fnd_message.Get() ;
1299: l_rowid := NULL ;
1300: l_batch_id := NULL;
1301:

Line 1298: l_description := fnd_message.Get() ;

1294:
1295: -- We need to create a separate batch id for each of the UCAS System's calendars
1296: -- Get the Batch ID Description value from the Message,IGS_UC_DEC_BATCH
1297: fnd_message.set_name('IGS','IGS_UC_DEC_BATCH');
1298: l_description := fnd_message.Get() ;
1299: l_rowid := NULL ;
1300: l_batch_id := NULL;
1301:
1302: --Get the Calendar details for the given System, Entry Month and Entry Year from System Calendards table.

Line 1467: fnd_message.set_name('IGS','IGS_UC_NO_UNIT_SET_CD');

1463: c_new_app_ch_rec.oss_attendance_type );
1464: FETCH c_unit_set_cd INTO c_unit_set_cd_rec;
1465: IF c_unit_set_cd%NOTFOUND THEN
1466: -- If the point of entry doesnot correspond to a valid Unit set cd then log error and skip the choice
1467: fnd_message.set_name('IGS','IGS_UC_NO_UNIT_SET_CD');
1468: fnd_message.set_token('APP_NO',TO_CHAR(c_new_app_ch_rec.app_no));
1469: fnd_message.set_token('CHOICE_NO',TO_CHAR(c_new_app_ch_rec.choice_no));
1470: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
1471: -- set the choice record error code to A003 and export status to OC to indicate that

Line 1468: fnd_message.set_token('APP_NO',TO_CHAR(c_new_app_ch_rec.app_no));

1464: FETCH c_unit_set_cd INTO c_unit_set_cd_rec;
1465: IF c_unit_set_cd%NOTFOUND THEN
1466: -- If the point of entry doesnot correspond to a valid Unit set cd then log error and skip the choice
1467: fnd_message.set_name('IGS','IGS_UC_NO_UNIT_SET_CD');
1468: fnd_message.set_token('APP_NO',TO_CHAR(c_new_app_ch_rec.app_no));
1469: fnd_message.set_token('CHOICE_NO',TO_CHAR(c_new_app_ch_rec.choice_no));
1470: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
1471: -- set the choice record error code to A003 and export status to OC to indicate that
1472: -- import interface tables have not been successfully populated but an error was encountered

Line 1469: fnd_message.set_token('CHOICE_NO',TO_CHAR(c_new_app_ch_rec.choice_no));

1465: IF c_unit_set_cd%NOTFOUND THEN
1466: -- If the point of entry doesnot correspond to a valid Unit set cd then log error and skip the choice
1467: fnd_message.set_name('IGS','IGS_UC_NO_UNIT_SET_CD');
1468: fnd_message.set_token('APP_NO',TO_CHAR(c_new_app_ch_rec.app_no));
1469: fnd_message.set_token('CHOICE_NO',TO_CHAR(c_new_app_ch_rec.choice_no));
1470: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
1471: -- set the choice record error code to A003 and export status to OC to indicate that
1472: -- import interface tables have not been successfully populated but an error was encountered
1473: l_ch_error := 'A003' ;

Line 1470: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);

1466: -- If the point of entry doesnot correspond to a valid Unit set cd then log error and skip the choice
1467: fnd_message.set_name('IGS','IGS_UC_NO_UNIT_SET_CD');
1468: fnd_message.set_token('APP_NO',TO_CHAR(c_new_app_ch_rec.app_no));
1469: fnd_message.set_token('CHOICE_NO',TO_CHAR(c_new_app_ch_rec.choice_no));
1470: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
1471: -- set the choice record error code to A003 and export status to OC to indicate that
1472: -- import interface tables have not been successfully populated but an error was encountered
1473: l_ch_error := 'A003' ;
1474: l_export_to_oss_status := c_new_app_ch_rec.export_to_oss_status ;

Line 1605: fnd_message.set_name('IGS','IGS_UC_CANCEL_APP_DEC_IMP_ERR');

1601:
1602: -- if the decision import completed in error then set appropriate error code in app choice record
1603: IF l_error_message IS NOT NULL OR l_return_status = 'FALSE' THEN
1604: /* raise the error with code 'O002' */
1605: fnd_message.set_name('IGS','IGS_UC_CANCEL_APP_DEC_IMP_ERR');
1606: fnd_message.set_token('APP_NO', c_new_app_ch_rec.app_no);
1607: fnd_message.set_token('CHOICE_NO', c_new_app_ch_rec.choice_no);
1608: fnd_message.set_token('BATCH_ID', l_dec_batch_id);
1609: fnd_file.put_line(fnd_file.LOG,fnd_message.get());

Line 1606: fnd_message.set_token('APP_NO', c_new_app_ch_rec.app_no);

1602: -- if the decision import completed in error then set appropriate error code in app choice record
1603: IF l_error_message IS NOT NULL OR l_return_status = 'FALSE' THEN
1604: /* raise the error with code 'O002' */
1605: fnd_message.set_name('IGS','IGS_UC_CANCEL_APP_DEC_IMP_ERR');
1606: fnd_message.set_token('APP_NO', c_new_app_ch_rec.app_no);
1607: fnd_message.set_token('CHOICE_NO', c_new_app_ch_rec.choice_no);
1608: fnd_message.set_token('BATCH_ID', l_dec_batch_id);
1609: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
1610: l_ch_error := 'O002' ;

Line 1607: fnd_message.set_token('CHOICE_NO', c_new_app_ch_rec.choice_no);

1603: IF l_error_message IS NOT NULL OR l_return_status = 'FALSE' THEN
1604: /* raise the error with code 'O002' */
1605: fnd_message.set_name('IGS','IGS_UC_CANCEL_APP_DEC_IMP_ERR');
1606: fnd_message.set_token('APP_NO', c_new_app_ch_rec.app_no);
1607: fnd_message.set_token('CHOICE_NO', c_new_app_ch_rec.choice_no);
1608: fnd_message.set_token('BATCH_ID', l_dec_batch_id);
1609: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
1610: l_ch_error := 'O002' ;
1611: l_ch_batch_id := l_dec_batch_id ;

Line 1608: fnd_message.set_token('BATCH_ID', l_dec_batch_id);

1604: /* raise the error with code 'O002' */
1605: fnd_message.set_name('IGS','IGS_UC_CANCEL_APP_DEC_IMP_ERR');
1606: fnd_message.set_token('APP_NO', c_new_app_ch_rec.app_no);
1607: fnd_message.set_token('CHOICE_NO', c_new_app_ch_rec.choice_no);
1608: fnd_message.set_token('BATCH_ID', l_dec_batch_id);
1609: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
1610: l_ch_error := 'O002' ;
1611: l_ch_batch_id := l_dec_batch_id ;
1612: l_export_to_oss_status := 'OO' ;

Line 1609: fnd_file.put_line(fnd_file.LOG,fnd_message.get());

1605: fnd_message.set_name('IGS','IGS_UC_CANCEL_APP_DEC_IMP_ERR');
1606: fnd_message.set_token('APP_NO', c_new_app_ch_rec.app_no);
1607: fnd_message.set_token('CHOICE_NO', c_new_app_ch_rec.choice_no);
1608: fnd_message.set_token('BATCH_ID', l_dec_batch_id);
1609: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
1610: l_ch_error := 'O002' ;
1611: l_ch_batch_id := l_dec_batch_id ;
1612: l_export_to_oss_status := 'OO' ;
1613: ELSE

Line 1620: fnd_message.set_name('IGS','IGS_UC_CANCEL_APP_DEC_IMP_SUC');

1616: l_ch_batch_id := NULL ;
1617: l_export_to_oss_status := 'OC' ;
1618:
1619: -- Log a message that the application choice has been successfully obsoleted
1620: fnd_message.set_name('IGS','IGS_UC_CANCEL_APP_DEC_IMP_SUC');
1621: fnd_message.set_token('APP_NO', c_new_app_ch_rec.app_no);
1622: fnd_message.set_token('CHOICE_NO', c_new_app_ch_rec.choice_no);
1623: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
1624: END IF ; -- decision import failed or passed

Line 1621: fnd_message.set_token('APP_NO', c_new_app_ch_rec.app_no);

1617: l_export_to_oss_status := 'OC' ;
1618:
1619: -- Log a message that the application choice has been successfully obsoleted
1620: fnd_message.set_name('IGS','IGS_UC_CANCEL_APP_DEC_IMP_SUC');
1621: fnd_message.set_token('APP_NO', c_new_app_ch_rec.app_no);
1622: fnd_message.set_token('CHOICE_NO', c_new_app_ch_rec.choice_no);
1623: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
1624: END IF ; -- decision import failed or passed
1625:

Line 1622: fnd_message.set_token('CHOICE_NO', c_new_app_ch_rec.choice_no);

1618:
1619: -- Log a message that the application choice has been successfully obsoleted
1620: fnd_message.set_name('IGS','IGS_UC_CANCEL_APP_DEC_IMP_SUC');
1621: fnd_message.set_token('APP_NO', c_new_app_ch_rec.app_no);
1622: fnd_message.set_token('CHOICE_NO', c_new_app_ch_rec.choice_no);
1623: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
1624: END IF ; -- decision import failed or passed
1625:
1626: END IF; -- if c_cancel_appl%FOUND

Line 1623: fnd_file.put_line(fnd_file.LOG,fnd_message.get());

1619: -- Log a message that the application choice has been successfully obsoleted
1620: fnd_message.set_name('IGS','IGS_UC_CANCEL_APP_DEC_IMP_SUC');
1621: fnd_message.set_token('APP_NO', c_new_app_ch_rec.app_no);
1622: fnd_message.set_token('CHOICE_NO', c_new_app_ch_rec.choice_no);
1623: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
1624: END IF ; -- decision import failed or passed
1625:
1626: END IF; -- if c_cancel_appl%FOUND
1627: CLOSE c_cancel_appl;

Line 1658: fnd_message.set_name('IGS','IGS_UC_MANY_APPL');

1654: CLOSE c_obsol_appl_cnt ;
1655:
1656: -- If More than one application instances is active for the application log error message .
1657: IF l_obsol_appl_cnt > 1 THEN
1658: fnd_message.set_name('IGS','IGS_UC_MANY_APPL');
1659: fnd_message.set_token('APP_NO', c_new_app_ch_rec.app_no);
1660: fnd_message.set_token('CHOICE_NO', c_new_app_ch_rec.choice_no);
1661: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
1662: l_ch_error := 'O003' ;

Line 1659: fnd_message.set_token('APP_NO', c_new_app_ch_rec.app_no);

1655:
1656: -- If More than one application instances is active for the application log error message .
1657: IF l_obsol_appl_cnt > 1 THEN
1658: fnd_message.set_name('IGS','IGS_UC_MANY_APPL');
1659: fnd_message.set_token('APP_NO', c_new_app_ch_rec.app_no);
1660: fnd_message.set_token('CHOICE_NO', c_new_app_ch_rec.choice_no);
1661: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
1662: l_ch_error := 'O003' ;
1663: l_export_to_oss_status:= c_new_app_ch_rec.export_to_oss_status ;

Line 1660: fnd_message.set_token('CHOICE_NO', c_new_app_ch_rec.choice_no);

1656: -- If More than one application instances is active for the application log error message .
1657: IF l_obsol_appl_cnt > 1 THEN
1658: fnd_message.set_name('IGS','IGS_UC_MANY_APPL');
1659: fnd_message.set_token('APP_NO', c_new_app_ch_rec.app_no);
1660: fnd_message.set_token('CHOICE_NO', c_new_app_ch_rec.choice_no);
1661: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
1662: l_ch_error := 'O003' ;
1663: l_export_to_oss_status:= c_new_app_ch_rec.export_to_oss_status ;
1664: l_ch_batch_id := NULL;

Line 1661: fnd_file.put_line(fnd_file.LOG,fnd_message.get());

1657: IF l_obsol_appl_cnt > 1 THEN
1658: fnd_message.set_name('IGS','IGS_UC_MANY_APPL');
1659: fnd_message.set_token('APP_NO', c_new_app_ch_rec.app_no);
1660: fnd_message.set_token('CHOICE_NO', c_new_app_ch_rec.choice_no);
1661: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
1662: l_ch_error := 'O003' ;
1663: l_export_to_oss_status:= c_new_app_ch_rec.export_to_oss_status ;
1664: l_ch_batch_id := NULL;
1665:

Line 1828: fnd_message.set_name('IGS','IGS_UC_OBS_APP_INC_PREF_ERR');

1824: END LOOP ;
1825: EXCEPTION
1826: WHEN OTHERS THEN
1827: ROLLBACK TO pref;
1828: fnd_message.set_name('IGS','IGS_UC_OBS_APP_INC_PREF_ERR');
1829: fnd_message.set_token('APP_NO', c_new_app_ch_rec.app_no);
1830: fnd_message.set_token('CHOICE_NO', c_new_app_ch_rec.choice_no);
1831: fnd_message.set_token('ADM_APPL', c_new_app_ch_rec.choice_no);
1832: fnd_file.put_line(fnd_file.LOG,fnd_message.get());

Line 1829: fnd_message.set_token('APP_NO', c_new_app_ch_rec.app_no);

1825: EXCEPTION
1826: WHEN OTHERS THEN
1827: ROLLBACK TO pref;
1828: fnd_message.set_name('IGS','IGS_UC_OBS_APP_INC_PREF_ERR');
1829: fnd_message.set_token('APP_NO', c_new_app_ch_rec.app_no);
1830: fnd_message.set_token('CHOICE_NO', c_new_app_ch_rec.choice_no);
1831: fnd_message.set_token('ADM_APPL', c_new_app_ch_rec.choice_no);
1832: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
1833: fnd_file.put_line(fnd_file.LOG, SQLERRM);

Line 1830: fnd_message.set_token('CHOICE_NO', c_new_app_ch_rec.choice_no);

1826: WHEN OTHERS THEN
1827: ROLLBACK TO pref;
1828: fnd_message.set_name('IGS','IGS_UC_OBS_APP_INC_PREF_ERR');
1829: fnd_message.set_token('APP_NO', c_new_app_ch_rec.app_no);
1830: fnd_message.set_token('CHOICE_NO', c_new_app_ch_rec.choice_no);
1831: fnd_message.set_token('ADM_APPL', c_new_app_ch_rec.choice_no);
1832: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
1833: fnd_file.put_line(fnd_file.LOG, SQLERRM);
1834:

Line 1831: fnd_message.set_token('ADM_APPL', c_new_app_ch_rec.choice_no);

1827: ROLLBACK TO pref;
1828: fnd_message.set_name('IGS','IGS_UC_OBS_APP_INC_PREF_ERR');
1829: fnd_message.set_token('APP_NO', c_new_app_ch_rec.app_no);
1830: fnd_message.set_token('CHOICE_NO', c_new_app_ch_rec.choice_no);
1831: fnd_message.set_token('ADM_APPL', c_new_app_ch_rec.choice_no);
1832: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
1833: fnd_file.put_line(fnd_file.LOG, SQLERRM);
1834:
1835: l_export_to_oss_status := c_new_app_ch_rec.export_to_oss_status;

Line 1832: fnd_file.put_line(fnd_file.LOG,fnd_message.get());

1828: fnd_message.set_name('IGS','IGS_UC_OBS_APP_INC_PREF_ERR');
1829: fnd_message.set_token('APP_NO', c_new_app_ch_rec.app_no);
1830: fnd_message.set_token('CHOICE_NO', c_new_app_ch_rec.choice_no);
1831: fnd_message.set_token('ADM_APPL', c_new_app_ch_rec.choice_no);
1832: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
1833: fnd_file.put_line(fnd_file.LOG, SQLERRM);
1834:
1835: l_export_to_oss_status := c_new_app_ch_rec.export_to_oss_status;
1836: l_ch_error := 'O001' ;

Line 1948: fnd_message.set_name('IGS','IGS_UC_OBS_APP_DEC_IMP_ERR');

1944:
1945: -- if the decision import completed in error then set appropriate error code in app choice record
1946: IF l_error_message IS NOT NULL OR l_return_status = 'FALSE' THEN
1947: /* raise the error with code 'O002' */
1948: fnd_message.set_name('IGS','IGS_UC_OBS_APP_DEC_IMP_ERR');
1949: fnd_message.set_token('APP_NO', c_new_app_ch_rec.app_no);
1950: fnd_message.set_token('CHOICE_NO', c_new_app_ch_rec.choice_no);
1951: fnd_message.set_token('BATCH_ID', l_dec_batch_id);
1952: fnd_file.put_line(fnd_file.LOG,fnd_message.get());

Line 1949: fnd_message.set_token('APP_NO', c_new_app_ch_rec.app_no);

1945: -- if the decision import completed in error then set appropriate error code in app choice record
1946: IF l_error_message IS NOT NULL OR l_return_status = 'FALSE' THEN
1947: /* raise the error with code 'O002' */
1948: fnd_message.set_name('IGS','IGS_UC_OBS_APP_DEC_IMP_ERR');
1949: fnd_message.set_token('APP_NO', c_new_app_ch_rec.app_no);
1950: fnd_message.set_token('CHOICE_NO', c_new_app_ch_rec.choice_no);
1951: fnd_message.set_token('BATCH_ID', l_dec_batch_id);
1952: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
1953: l_ch_error := 'O002' ;

Line 1950: fnd_message.set_token('CHOICE_NO', c_new_app_ch_rec.choice_no);

1946: IF l_error_message IS NOT NULL OR l_return_status = 'FALSE' THEN
1947: /* raise the error with code 'O002' */
1948: fnd_message.set_name('IGS','IGS_UC_OBS_APP_DEC_IMP_ERR');
1949: fnd_message.set_token('APP_NO', c_new_app_ch_rec.app_no);
1950: fnd_message.set_token('CHOICE_NO', c_new_app_ch_rec.choice_no);
1951: fnd_message.set_token('BATCH_ID', l_dec_batch_id);
1952: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
1953: l_ch_error := 'O002' ;
1954: l_ch_batch_id := l_dec_batch_id ;

Line 1951: fnd_message.set_token('BATCH_ID', l_dec_batch_id);

1947: /* raise the error with code 'O002' */
1948: fnd_message.set_name('IGS','IGS_UC_OBS_APP_DEC_IMP_ERR');
1949: fnd_message.set_token('APP_NO', c_new_app_ch_rec.app_no);
1950: fnd_message.set_token('CHOICE_NO', c_new_app_ch_rec.choice_no);
1951: fnd_message.set_token('BATCH_ID', l_dec_batch_id);
1952: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
1953: l_ch_error := 'O002' ;
1954: l_ch_batch_id := l_dec_batch_id ;
1955: l_export_to_oss_status := 'OO' ;

Line 1952: fnd_file.put_line(fnd_file.LOG,fnd_message.get());

1948: fnd_message.set_name('IGS','IGS_UC_OBS_APP_DEC_IMP_ERR');
1949: fnd_message.set_token('APP_NO', c_new_app_ch_rec.app_no);
1950: fnd_message.set_token('CHOICE_NO', c_new_app_ch_rec.choice_no);
1951: fnd_message.set_token('BATCH_ID', l_dec_batch_id);
1952: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
1953: l_ch_error := 'O002' ;
1954: l_ch_batch_id := l_dec_batch_id ;
1955: l_export_to_oss_status := 'OO' ;
1956: ELSE

Line 1963: fnd_message.set_name('IGS','IGS_UC_OBS_APP_DEC_IMP_SUC');

1959: l_ch_batch_id := NULL ;
1960: l_export_to_oss_status := 'OC' ;
1961:
1962: -- Log a message that the application choice has been successfully obsoleted
1963: fnd_message.set_name('IGS','IGS_UC_OBS_APP_DEC_IMP_SUC');
1964: fnd_message.set_token('APP_NO', c_new_app_ch_rec.app_no);
1965: fnd_message.set_token('CHOICE_NO', c_new_app_ch_rec.choice_no);
1966: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
1967: END IF ; -- decision import failed or passed

Line 1964: fnd_message.set_token('APP_NO', c_new_app_ch_rec.app_no);

1960: l_export_to_oss_status := 'OC' ;
1961:
1962: -- Log a message that the application choice has been successfully obsoleted
1963: fnd_message.set_name('IGS','IGS_UC_OBS_APP_DEC_IMP_SUC');
1964: fnd_message.set_token('APP_NO', c_new_app_ch_rec.app_no);
1965: fnd_message.set_token('CHOICE_NO', c_new_app_ch_rec.choice_no);
1966: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
1967: END IF ; -- decision import failed or passed
1968:

Line 1965: fnd_message.set_token('CHOICE_NO', c_new_app_ch_rec.choice_no);

1961:
1962: -- Log a message that the application choice has been successfully obsoleted
1963: fnd_message.set_name('IGS','IGS_UC_OBS_APP_DEC_IMP_SUC');
1964: fnd_message.set_token('APP_NO', c_new_app_ch_rec.app_no);
1965: fnd_message.set_token('CHOICE_NO', c_new_app_ch_rec.choice_no);
1966: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
1967: END IF ; -- decision import failed or passed
1968:
1969: END IF ; -- preference increment raised exception

Line 1966: fnd_file.put_line(fnd_file.LOG,fnd_message.get());

1962: -- Log a message that the application choice has been successfully obsoleted
1963: fnd_message.set_name('IGS','IGS_UC_OBS_APP_DEC_IMP_SUC');
1964: fnd_message.set_token('APP_NO', c_new_app_ch_rec.app_no);
1965: fnd_message.set_token('CHOICE_NO', c_new_app_ch_rec.choice_no);
1966: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
1967: END IF ; -- decision import failed or passed
1968:
1969: END IF ; -- preference increment raised exception
1970:

Line 2095: fnd_message.set_name('IGS','IGS_UC_OBS_APP_DEC_IMP_ERR');

2091: FETCH c_dec_int INTO c_dec_int_rec ;
2092: CLOSE c_dec_int ;
2093: -- if the decision import completed in error then set appropriate error code in app choice record
2094: IF c_dec_int_rec.error_code IS NOT NULL OR c_dec_int_rec.status IN ('2','3') THEN
2095: fnd_message.set_name('IGS','IGS_UC_OBS_APP_DEC_IMP_ERR');
2096: fnd_message.set_token('APP_NO', c_oo_ch_rec.app_no);
2097: fnd_message.set_token('CHOICE_NO', c_oo_ch_rec.choice_no);
2098: fnd_message.set_token('BATCH_ID', c_oo_ch_rec.batch_id );
2099: fnd_file.put_line(fnd_file.LOG,fnd_message.get());

Line 2096: fnd_message.set_token('APP_NO', c_oo_ch_rec.app_no);

2092: CLOSE c_dec_int ;
2093: -- if the decision import completed in error then set appropriate error code in app choice record
2094: IF c_dec_int_rec.error_code IS NOT NULL OR c_dec_int_rec.status IN ('2','3') THEN
2095: fnd_message.set_name('IGS','IGS_UC_OBS_APP_DEC_IMP_ERR');
2096: fnd_message.set_token('APP_NO', c_oo_ch_rec.app_no);
2097: fnd_message.set_token('CHOICE_NO', c_oo_ch_rec.choice_no);
2098: fnd_message.set_token('BATCH_ID', c_oo_ch_rec.batch_id );
2099: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
2100: ELSE

Line 2097: fnd_message.set_token('CHOICE_NO', c_oo_ch_rec.choice_no);

2093: -- if the decision import completed in error then set appropriate error code in app choice record
2094: IF c_dec_int_rec.error_code IS NOT NULL OR c_dec_int_rec.status IN ('2','3') THEN
2095: fnd_message.set_name('IGS','IGS_UC_OBS_APP_DEC_IMP_ERR');
2096: fnd_message.set_token('APP_NO', c_oo_ch_rec.app_no);
2097: fnd_message.set_token('CHOICE_NO', c_oo_ch_rec.choice_no);
2098: fnd_message.set_token('BATCH_ID', c_oo_ch_rec.batch_id );
2099: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
2100: ELSE
2101: l_ch_error := NULL ;

Line 2098: fnd_message.set_token('BATCH_ID', c_oo_ch_rec.batch_id );

2094: IF c_dec_int_rec.error_code IS NOT NULL OR c_dec_int_rec.status IN ('2','3') THEN
2095: fnd_message.set_name('IGS','IGS_UC_OBS_APP_DEC_IMP_ERR');
2096: fnd_message.set_token('APP_NO', c_oo_ch_rec.app_no);
2097: fnd_message.set_token('CHOICE_NO', c_oo_ch_rec.choice_no);
2098: fnd_message.set_token('BATCH_ID', c_oo_ch_rec.batch_id );
2099: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
2100: ELSE
2101: l_ch_error := NULL ;
2102: l_ch_batch_id := NULL ;

Line 2099: fnd_file.put_line(fnd_file.LOG,fnd_message.get());

2095: fnd_message.set_name('IGS','IGS_UC_OBS_APP_DEC_IMP_ERR');
2096: fnd_message.set_token('APP_NO', c_oo_ch_rec.app_no);
2097: fnd_message.set_token('CHOICE_NO', c_oo_ch_rec.choice_no);
2098: fnd_message.set_token('BATCH_ID', c_oo_ch_rec.batch_id );
2099: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
2100: ELSE
2101: l_ch_error := NULL ;
2102: l_ch_batch_id := NULL ;
2103: l_export_to_oss_status := 'OC' ;

Line 2106: fnd_message.set_name('IGS','IGS_UC_OBS_APP_DEC_IMP_SUC');

2102: l_ch_batch_id := NULL ;
2103: l_export_to_oss_status := 'OC' ;
2104:
2105: -- Log a message that the application choice has been successfully obsoleted
2106: fnd_message.set_name('IGS','IGS_UC_OBS_APP_DEC_IMP_SUC');
2107: fnd_message.set_token('APP_NO', c_oo_ch_rec.app_no);
2108: fnd_message.set_token('CHOICE_NO', c_oo_ch_rec.choice_no);
2109: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
2110:

Line 2107: fnd_message.set_token('APP_NO', c_oo_ch_rec.app_no);

2103: l_export_to_oss_status := 'OC' ;
2104:
2105: -- Log a message that the application choice has been successfully obsoleted
2106: fnd_message.set_name('IGS','IGS_UC_OBS_APP_DEC_IMP_SUC');
2107: fnd_message.set_token('APP_NO', c_oo_ch_rec.app_no);
2108: fnd_message.set_token('CHOICE_NO', c_oo_ch_rec.choice_no);
2109: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
2110:
2111: -- 1. Update the Application Choice Record with export_to_oss_status=OP/OO/OC and Concurrent Request ID

Line 2108: fnd_message.set_token('CHOICE_NO', c_oo_ch_rec.choice_no);

2104:
2105: -- Log a message that the application choice has been successfully obsoleted
2106: fnd_message.set_name('IGS','IGS_UC_OBS_APP_DEC_IMP_SUC');
2107: fnd_message.set_token('APP_NO', c_oo_ch_rec.app_no);
2108: fnd_message.set_token('CHOICE_NO', c_oo_ch_rec.choice_no);
2109: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
2110:
2111: -- 1. Update the Application Choice Record with export_to_oss_status=OP/OO/OC and Concurrent Request ID
2112: c_upd_ch_rec := NULL ;

Line 2109: fnd_file.put_line(fnd_file.LOG,fnd_message.get());

2105: -- Log a message that the application choice has been successfully obsoleted
2106: fnd_message.set_name('IGS','IGS_UC_OBS_APP_DEC_IMP_SUC');
2107: fnd_message.set_token('APP_NO', c_oo_ch_rec.app_no);
2108: fnd_message.set_token('CHOICE_NO', c_oo_ch_rec.choice_no);
2109: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
2110:
2111: -- 1. Update the Application Choice Record with export_to_oss_status=OP/OO/OC and Concurrent Request ID
2112: c_upd_ch_rec := NULL ;
2113: OPEN c_upd_ch( c_oo_ch_rec.app_no , c_oo_ch_rec.choice_no, c_oo_ch_rec.ucas_cycle) ;

Line 2186: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

2182: EXCEPTION
2183:
2184: WHEN OTHERS THEN
2185: Rollback;
2186: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2187: fnd_message.set_token('NAME','IGS_UCAS_EXPORT_TO_OSS.OBSOLETE_APPLICATIONS'||' - '||SQLERRM);
2188: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
2189: IGS_GE_MSG_STACK.ADD;
2190: App_Exception.Raise_Exception;

Line 2187: fnd_message.set_token('NAME','IGS_UCAS_EXPORT_TO_OSS.OBSOLETE_APPLICATIONS'||' - '||SQLERRM);

2183:
2184: WHEN OTHERS THEN
2185: Rollback;
2186: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2187: fnd_message.set_token('NAME','IGS_UCAS_EXPORT_TO_OSS.OBSOLETE_APPLICATIONS'||' - '||SQLERRM);
2188: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
2189: IGS_GE_MSG_STACK.ADD;
2190: App_Exception.Raise_Exception;
2191: END obsolete_applications ;

Line 2188: fnd_file.put_line(fnd_file.LOG,fnd_message.get());

2184: WHEN OTHERS THEN
2185: Rollback;
2186: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2187: fnd_message.set_token('NAME','IGS_UCAS_EXPORT_TO_OSS.OBSOLETE_APPLICATIONS'||' - '||SQLERRM);
2188: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
2189: IGS_GE_MSG_STACK.ADD;
2190: App_Exception.Raise_Exception;
2191: END obsolete_applications ;
2192:

Line 2400: fnd_message.get_string('IGS','IGS_UC_EXP_TO_OSS_BATCH_ID'),

2396: program_application_id,
2397: program_update_date,
2398: program_id)
2399: VALUES ( l_imp_batch_id,
2400: fnd_message.get_string('IGS','IGS_UC_EXP_TO_OSS_BATCH_ID'),
2401: fnd_global.user_id,
2402: SYSDATE,
2403: fnd_global.user_id,
2404: SYSDATE,

Line 2438: fnd_message.set_name('IGS','IGS_UC_ADM_IMP_PROC_LAUNCH');

2434:
2435: -- call the application import process to create new application /instance
2436: -- or update the old application instance
2437: fnd_file.put_line( fnd_file.LOG ,' ');
2438: fnd_message.set_name('IGS','IGS_UC_ADM_IMP_PROC_LAUNCH');
2439: fnd_message.set_token('REQ_ID',TO_CHAR(l_imp_batch_id));
2440: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2441: fnd_file.put_line( fnd_file.LOG ,'-----------------------------------');
2442:

Line 2439: fnd_message.set_token('REQ_ID',TO_CHAR(l_imp_batch_id));

2435: -- call the application import process to create new application /instance
2436: -- or update the old application instance
2437: fnd_file.put_line( fnd_file.LOG ,' ');
2438: fnd_message.set_name('IGS','IGS_UC_ADM_IMP_PROC_LAUNCH');
2439: fnd_message.set_token('REQ_ID',TO_CHAR(l_imp_batch_id));
2440: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2441: fnd_file.put_line( fnd_file.LOG ,'-----------------------------------');
2442:
2443: COMMIT ;

Line 2440: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);

2436: -- or update the old application instance
2437: fnd_file.put_line( fnd_file.LOG ,' ');
2438: fnd_message.set_name('IGS','IGS_UC_ADM_IMP_PROC_LAUNCH');
2439: fnd_message.set_token('REQ_ID',TO_CHAR(l_imp_batch_id));
2440: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2441: fnd_file.put_line( fnd_file.LOG ,'-----------------------------------');
2442:
2443: COMMIT ;
2444: import_process(c_src_type_id_rec.source_type_id, l_imp_batch_id, l_org_id);

Line 2465: fnd_message.set_name('IGS','IGS_UC_EXPORT_APP_ERR');

2461: IF c_appl_int%FOUND THEN
2462: -- Import of this application has completed in error
2463: fnd_file.put_line( fnd_file.LOG ,' ');
2464: -- Bug No: 2898153. Removed the space from the message name IGS_UC_EXPORT_APP_ERR.
2465: fnd_message.set_name('IGS','IGS_UC_EXPORT_APP_ERR');
2466: fnd_message.set_token('APP_NO',c_ap_ch_rec.app_no) ;
2467: fnd_message.set_token('CHOICE_NO',c_ap_ch_rec.choice_no) ;
2468: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2469:

Line 2466: fnd_message.set_token('APP_NO',c_ap_ch_rec.app_no) ;

2462: -- Import of this application has completed in error
2463: fnd_file.put_line( fnd_file.LOG ,' ');
2464: -- Bug No: 2898153. Removed the space from the message name IGS_UC_EXPORT_APP_ERR.
2465: fnd_message.set_name('IGS','IGS_UC_EXPORT_APP_ERR');
2466: fnd_message.set_token('APP_NO',c_ap_ch_rec.app_no) ;
2467: fnd_message.set_token('CHOICE_NO',c_ap_ch_rec.choice_no) ;
2468: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2469:
2470: l_ch_error := 'A001' ;

Line 2467: fnd_message.set_token('CHOICE_NO',c_ap_ch_rec.choice_no) ;

2463: fnd_file.put_line( fnd_file.LOG ,' ');
2464: -- Bug No: 2898153. Removed the space from the message name IGS_UC_EXPORT_APP_ERR.
2465: fnd_message.set_name('IGS','IGS_UC_EXPORT_APP_ERR');
2466: fnd_message.set_token('APP_NO',c_ap_ch_rec.app_no) ;
2467: fnd_message.set_token('CHOICE_NO',c_ap_ch_rec.choice_no) ;
2468: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2469:
2470: l_ch_error := 'A001' ;
2471: l_ch_batch_id := NVL(c_ap_ch_rec.batch_id,l_imp_batch_id ) ;

Line 2468: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);

2464: -- Bug No: 2898153. Removed the space from the message name IGS_UC_EXPORT_APP_ERR.
2465: fnd_message.set_name('IGS','IGS_UC_EXPORT_APP_ERR');
2466: fnd_message.set_token('APP_NO',c_ap_ch_rec.app_no) ;
2467: fnd_message.set_token('CHOICE_NO',c_ap_ch_rec.choice_no) ;
2468: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2469:
2470: l_ch_error := 'A001' ;
2471: l_ch_batch_id := NVL(c_ap_ch_rec.batch_id,l_imp_batch_id ) ;
2472: l_export_to_oss_status := 'AP';

Line 2551: FND_MESSAGE.Set_Name('IGS','IGS_UC_NO_DOM_MAPPING');

2547: END IF ; -- l_count = 0
2548:
2549: ELSE
2550: -- Was unable to map domicile code so log warning
2551: FND_MESSAGE.Set_Name('IGS','IGS_UC_NO_DOM_MAPPING');
2552: FND_MESSAGE.Set_Token('PERSON_ID',l_app_dtls.party_number);
2553: FND_MESSAGE.Set_Token('CODE',l_app_dtls.domicile_apr);
2554: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.get );
2555:

Line 2552: FND_MESSAGE.Set_Token('PERSON_ID',l_app_dtls.party_number);

2548:
2549: ELSE
2550: -- Was unable to map domicile code so log warning
2551: FND_MESSAGE.Set_Name('IGS','IGS_UC_NO_DOM_MAPPING');
2552: FND_MESSAGE.Set_Token('PERSON_ID',l_app_dtls.party_number);
2553: FND_MESSAGE.Set_Token('CODE',l_app_dtls.domicile_apr);
2554: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.get );
2555:
2556: END IF; -- l_dom_cd IS NOT NULL

Line 2553: FND_MESSAGE.Set_Token('CODE',l_app_dtls.domicile_apr);

2549: ELSE
2550: -- Was unable to map domicile code so log warning
2551: FND_MESSAGE.Set_Name('IGS','IGS_UC_NO_DOM_MAPPING');
2552: FND_MESSAGE.Set_Token('PERSON_ID',l_app_dtls.party_number);
2553: FND_MESSAGE.Set_Token('CODE',l_app_dtls.domicile_apr);
2554: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.get );
2555:
2556: END IF; -- l_dom_cd IS NOT NULL
2557:

Line 2554: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.get );

2550: -- Was unable to map domicile code so log warning
2551: FND_MESSAGE.Set_Name('IGS','IGS_UC_NO_DOM_MAPPING');
2552: FND_MESSAGE.Set_Token('PERSON_ID',l_app_dtls.party_number);
2553: FND_MESSAGE.Set_Token('CODE',l_app_dtls.domicile_apr);
2554: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.get );
2555:
2556: END IF; -- l_dom_cd IS NOT NULL
2557:
2558: END IF; -- cur_proc_applicant_rec.domicile_apr IS NOT NULL

Line 2632: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

2628:
2629: EXCEPTION
2630: WHEN OTHERS THEN
2631: Rollback;
2632: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2633: fnd_message.set_token('NAME','IGS_UCAS_EXPORT_TO_OSS.EXPORT_APPLICATIONS'||' - '||SQLERRM);
2634: fnd_file.put_line(fnd_file.log,fnd_message.get());
2635: IGS_GE_MSG_STACK.ADD;
2636: App_Exception.Raise_Exception;

Line 2633: fnd_message.set_token('NAME','IGS_UCAS_EXPORT_TO_OSS.EXPORT_APPLICATIONS'||' - '||SQLERRM);

2629: EXCEPTION
2630: WHEN OTHERS THEN
2631: Rollback;
2632: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2633: fnd_message.set_token('NAME','IGS_UCAS_EXPORT_TO_OSS.EXPORT_APPLICATIONS'||' - '||SQLERRM);
2634: fnd_file.put_line(fnd_file.log,fnd_message.get());
2635: IGS_GE_MSG_STACK.ADD;
2636: App_Exception.Raise_Exception;
2637:

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

2630: WHEN OTHERS THEN
2631: Rollback;
2632: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2633: fnd_message.set_token('NAME','IGS_UCAS_EXPORT_TO_OSS.EXPORT_APPLICATIONS'||' - '||SQLERRM);
2634: fnd_file.put_line(fnd_file.log,fnd_message.get());
2635: IGS_GE_MSG_STACK.ADD;
2636: App_Exception.Raise_Exception;
2637:
2638: END export_applications ;

Line 2751: fnd_message.set_name('IGS','IGS_UC_SETUP_ADM_APPL_TYPE');

2747: CLOSE c_defaults ;
2748:
2749: -- Check if the set up data for admission Application Type is found in ucas defaults form
2750: IF c_defaults_rec.application_type IS NULL THEN
2751: fnd_message.set_name('IGS','IGS_UC_SETUP_ADM_APPL_TYPE');
2752: fnd_message.set_token('SYSTEM', c_ch_system_rec.system_code);
2753: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2754: l_no_setup := TRUE ;
2755: END IF ;

Line 2752: fnd_message.set_token('SYSTEM', c_ch_system_rec.system_code);

2748:
2749: -- Check if the set up data for admission Application Type is found in ucas defaults form
2750: IF c_defaults_rec.application_type IS NULL THEN
2751: fnd_message.set_name('IGS','IGS_UC_SETUP_ADM_APPL_TYPE');
2752: fnd_message.set_token('SYSTEM', c_ch_system_rec.system_code);
2753: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2754: l_no_setup := TRUE ;
2755: END IF ;
2756:

Line 2753: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);

2749: -- Check if the set up data for admission Application Type is found in ucas defaults form
2750: IF c_defaults_rec.application_type IS NULL THEN
2751: fnd_message.set_name('IGS','IGS_UC_SETUP_ADM_APPL_TYPE');
2752: fnd_message.set_token('SYSTEM', c_ch_system_rec.system_code);
2753: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2754: l_no_setup := TRUE ;
2755: END IF ;
2756:
2757: --Check if the set up data for admission Application Type is found in ucas defaults form but the Application Type is closed.

Line 2765: fnd_message.set_name('IGS','IGS_UC_SETUP_ADM_APC');

2761: OPEN cur_apc_det(c_defaults_rec.application_type);
2762: FETCH cur_apc_det INTO l_apc_det_rec;
2763: CLOSE cur_apc_det;
2764: IF l_apc_det_rec.admission_cat IS NULL OR l_apc_det_rec.s_admission_process_type IS NULL THEN
2765: fnd_message.set_name('IGS','IGS_UC_SETUP_ADM_APC');
2766: fnd_message.set_token('SYSTEM', c_ch_system_rec.system_code);
2767: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2768: l_no_setup := TRUE ;
2769: ELSE

Line 2766: fnd_message.set_token('SYSTEM', c_ch_system_rec.system_code);

2762: FETCH cur_apc_det INTO l_apc_det_rec;
2763: CLOSE cur_apc_det;
2764: IF l_apc_det_rec.admission_cat IS NULL OR l_apc_det_rec.s_admission_process_type IS NULL THEN
2765: fnd_message.set_name('IGS','IGS_UC_SETUP_ADM_APC');
2766: fnd_message.set_token('SYSTEM', c_ch_system_rec.system_code);
2767: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2768: l_no_setup := TRUE ;
2769: ELSE
2770: l_found_flag := NULL;

Line 2767: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);

2763: CLOSE cur_apc_det;
2764: IF l_apc_det_rec.admission_cat IS NULL OR l_apc_det_rec.s_admission_process_type IS NULL THEN
2765: fnd_message.set_name('IGS','IGS_UC_SETUP_ADM_APC');
2766: fnd_message.set_token('SYSTEM', c_ch_system_rec.system_code);
2767: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2768: l_no_setup := TRUE ;
2769: ELSE
2770: l_found_flag := NULL;
2771: --Check whether APC defined for the System includes the step "Reconsideration" or not.

Line 2778: fnd_message.set_name('IGS','IGS_UC_APC_RECNSDR_NOT_INCL');

2774: CLOSE cur_prcs_cat_step;
2775:
2776: --Log the error if Admission Process Category Step "Reconsideration" not exists for the given APC details.
2777: IF l_found_flag IS NULL THEN
2778: fnd_message.set_name('IGS','IGS_UC_APC_RECNSDR_NOT_INCL');
2779: fnd_message.set_token('PROCCAT', l_apc_det_rec.admission_cat);
2780: fnd_message.set_token('PROCTYPE', l_apc_det_rec.s_admission_process_type);
2781: fnd_message.set_token('SYSTEM', c_ch_system_rec.system_code);
2782: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);

Line 2779: fnd_message.set_token('PROCCAT', l_apc_det_rec.admission_cat);

2775:
2776: --Log the error if Admission Process Category Step "Reconsideration" not exists for the given APC details.
2777: IF l_found_flag IS NULL THEN
2778: fnd_message.set_name('IGS','IGS_UC_APC_RECNSDR_NOT_INCL');
2779: fnd_message.set_token('PROCCAT', l_apc_det_rec.admission_cat);
2780: fnd_message.set_token('PROCTYPE', l_apc_det_rec.s_admission_process_type);
2781: fnd_message.set_token('SYSTEM', c_ch_system_rec.system_code);
2782: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2783: l_no_setup := TRUE ;

Line 2780: fnd_message.set_token('PROCTYPE', l_apc_det_rec.s_admission_process_type);

2776: --Log the error if Admission Process Category Step "Reconsideration" not exists for the given APC details.
2777: IF l_found_flag IS NULL THEN
2778: fnd_message.set_name('IGS','IGS_UC_APC_RECNSDR_NOT_INCL');
2779: fnd_message.set_token('PROCCAT', l_apc_det_rec.admission_cat);
2780: fnd_message.set_token('PROCTYPE', l_apc_det_rec.s_admission_process_type);
2781: fnd_message.set_token('SYSTEM', c_ch_system_rec.system_code);
2782: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2783: l_no_setup := TRUE ;
2784: END IF;

Line 2781: fnd_message.set_token('SYSTEM', c_ch_system_rec.system_code);

2777: IF l_found_flag IS NULL THEN
2778: fnd_message.set_name('IGS','IGS_UC_APC_RECNSDR_NOT_INCL');
2779: fnd_message.set_token('PROCCAT', l_apc_det_rec.admission_cat);
2780: fnd_message.set_token('PROCTYPE', l_apc_det_rec.s_admission_process_type);
2781: fnd_message.set_token('SYSTEM', c_ch_system_rec.system_code);
2782: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2783: l_no_setup := TRUE ;
2784: END IF;
2785: END IF;

Line 2782: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);

2778: fnd_message.set_name('IGS','IGS_UC_APC_RECNSDR_NOT_INCL');
2779: fnd_message.set_token('PROCCAT', l_apc_det_rec.admission_cat);
2780: fnd_message.set_token('PROCTYPE', l_apc_det_rec.s_admission_process_type);
2781: fnd_message.set_token('SYSTEM', c_ch_system_rec.system_code);
2782: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2783: l_no_setup := TRUE ;
2784: END IF;
2785: END IF;
2786:

Line 2801: fnd_message.set_name('IGS','IGS_UC_NO_SYS_CAL_MAP_EXIST');

2797:
2798: --Log the error if calendar details are not found.
2799: IF l_sys_entry_cal_det_rec.adm_cal_type IS NULL OR l_sys_entry_cal_det_rec.adm_cal_seq_no IS NULL OR
2800: l_sys_entry_cal_det_rec.aca_cal_type IS NULL OR l_sys_entry_cal_det_rec.aca_cal_seq_no IS NULL THEN
2801: fnd_message.set_name('IGS','IGS_UC_NO_SYS_CAL_MAP_EXIST');
2802: fnd_message.set_token('SYSTEM', c_ch_system_rec.system_code);
2803: fnd_message.set_token('ENTRYYEAR', app_choice_entry_det_rec.entry_year);
2804: fnd_message.set_token('ENTRYMONTH', app_choice_entry_det_rec.entry_month);
2805: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);

Line 2802: fnd_message.set_token('SYSTEM', c_ch_system_rec.system_code);

2798: --Log the error if calendar details are not found.
2799: IF l_sys_entry_cal_det_rec.adm_cal_type IS NULL OR l_sys_entry_cal_det_rec.adm_cal_seq_no IS NULL OR
2800: l_sys_entry_cal_det_rec.aca_cal_type IS NULL OR l_sys_entry_cal_det_rec.aca_cal_seq_no IS NULL THEN
2801: fnd_message.set_name('IGS','IGS_UC_NO_SYS_CAL_MAP_EXIST');
2802: fnd_message.set_token('SYSTEM', c_ch_system_rec.system_code);
2803: fnd_message.set_token('ENTRYYEAR', app_choice_entry_det_rec.entry_year);
2804: fnd_message.set_token('ENTRYMONTH', app_choice_entry_det_rec.entry_month);
2805: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2806: l_no_setup := TRUE ;

Line 2803: fnd_message.set_token('ENTRYYEAR', app_choice_entry_det_rec.entry_year);

2799: IF l_sys_entry_cal_det_rec.adm_cal_type IS NULL OR l_sys_entry_cal_det_rec.adm_cal_seq_no IS NULL OR
2800: l_sys_entry_cal_det_rec.aca_cal_type IS NULL OR l_sys_entry_cal_det_rec.aca_cal_seq_no IS NULL THEN
2801: fnd_message.set_name('IGS','IGS_UC_NO_SYS_CAL_MAP_EXIST');
2802: fnd_message.set_token('SYSTEM', c_ch_system_rec.system_code);
2803: fnd_message.set_token('ENTRYYEAR', app_choice_entry_det_rec.entry_year);
2804: fnd_message.set_token('ENTRYMONTH', app_choice_entry_det_rec.entry_month);
2805: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2806: l_no_setup := TRUE ;
2807: END IF ;

Line 2804: fnd_message.set_token('ENTRYMONTH', app_choice_entry_det_rec.entry_month);

2800: l_sys_entry_cal_det_rec.aca_cal_type IS NULL OR l_sys_entry_cal_det_rec.aca_cal_seq_no IS NULL THEN
2801: fnd_message.set_name('IGS','IGS_UC_NO_SYS_CAL_MAP_EXIST');
2802: fnd_message.set_token('SYSTEM', c_ch_system_rec.system_code);
2803: fnd_message.set_token('ENTRYYEAR', app_choice_entry_det_rec.entry_year);
2804: fnd_message.set_token('ENTRYMONTH', app_choice_entry_det_rec.entry_month);
2805: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2806: l_no_setup := TRUE ;
2807: END IF ;
2808:

Line 2805: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);

2801: fnd_message.set_name('IGS','IGS_UC_NO_SYS_CAL_MAP_EXIST');
2802: fnd_message.set_token('SYSTEM', c_ch_system_rec.system_code);
2803: fnd_message.set_token('ENTRYYEAR', app_choice_entry_det_rec.entry_year);
2804: fnd_message.set_token('ENTRYMONTH', app_choice_entry_det_rec.entry_month);
2805: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2806: l_no_setup := TRUE ;
2807: END IF ;
2808:
2809: END LOOP;

Line 2813: fnd_message.set_name('IGS','IGS_UC_SETUP_OBS_OUSTAT');

2809: END LOOP;
2810:
2811: -- Check if the set up data for obsolete outcome status is found in ucas defaults form
2812: IF c_defaults_rec.obsolete_outcome_status IS NULL THEN
2813: fnd_message.set_name('IGS','IGS_UC_SETUP_OBS_OUSTAT');
2814: fnd_message.set_token('SYSTEM', c_ch_system_rec.system_code);
2815: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2816: l_no_setup := TRUE ;
2817: END IF;

Line 2814: fnd_message.set_token('SYSTEM', c_ch_system_rec.system_code);

2810:
2811: -- Check if the set up data for obsolete outcome status is found in ucas defaults form
2812: IF c_defaults_rec.obsolete_outcome_status IS NULL THEN
2813: fnd_message.set_name('IGS','IGS_UC_SETUP_OBS_OUSTAT');
2814: fnd_message.set_token('SYSTEM', c_ch_system_rec.system_code);
2815: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2816: l_no_setup := TRUE ;
2817: END IF;
2818:

Line 2815: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);

2811: -- Check if the set up data for obsolete outcome status is found in ucas defaults form
2812: IF c_defaults_rec.obsolete_outcome_status IS NULL THEN
2813: fnd_message.set_name('IGS','IGS_UC_SETUP_OBS_OUSTAT');
2814: fnd_message.set_token('SYSTEM', c_ch_system_rec.system_code);
2815: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2816: l_no_setup := TRUE ;
2817: END IF;
2818:
2819: -- Check if the set up data for pending outcome status is found in ucas defaults form

Line 2821: fnd_message.set_name('IGS','IGS_UC_SETUP_PENDING_OUSTAT');

2817: END IF;
2818:
2819: -- Check if the set up data for pending outcome status is found in ucas defaults form
2820: IF c_defaults_rec.pending_outcome_status IS NULL THEN
2821: fnd_message.set_name('IGS','IGS_UC_SETUP_PENDING_OUSTAT');
2822: fnd_message.set_token('SYSTEM', c_ch_system_rec.system_code);
2823: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2824: l_no_setup := TRUE ;
2825: END IF;

Line 2822: fnd_message.set_token('SYSTEM', c_ch_system_rec.system_code);

2818:
2819: -- Check if the set up data for pending outcome status is found in ucas defaults form
2820: IF c_defaults_rec.pending_outcome_status IS NULL THEN
2821: fnd_message.set_name('IGS','IGS_UC_SETUP_PENDING_OUSTAT');
2822: fnd_message.set_token('SYSTEM', c_ch_system_rec.system_code);
2823: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2824: l_no_setup := TRUE ;
2825: END IF;
2826:

Line 2823: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);

2819: -- Check if the set up data for pending outcome status is found in ucas defaults form
2820: IF c_defaults_rec.pending_outcome_status IS NULL THEN
2821: fnd_message.set_name('IGS','IGS_UC_SETUP_PENDING_OUSTAT');
2822: fnd_message.set_token('SYSTEM', c_ch_system_rec.system_code);
2823: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2824: l_no_setup := TRUE ;
2825: END IF;
2826:
2827: -- Check if the set up data for rejected outcome status is found in ucas defaults form

Line 2829: fnd_message.set_name('IGS','IGS_UC_SETUP_REJC_OUSTAT');

2825: END IF;
2826:
2827: -- Check if the set up data for rejected outcome status is found in ucas defaults form
2828: IF c_defaults_rec.rejected_outcome_status IS NULL THEN
2829: fnd_message.set_name('IGS','IGS_UC_SETUP_REJC_OUSTAT');
2830: fnd_message.set_token('SYSTEM', c_ch_system_rec.system_code);
2831: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2832: l_no_setup := TRUE ;
2833: END IF;

Line 2830: fnd_message.set_token('SYSTEM', c_ch_system_rec.system_code);

2826:
2827: -- Check if the set up data for rejected outcome status is found in ucas defaults form
2828: IF c_defaults_rec.rejected_outcome_status IS NULL THEN
2829: fnd_message.set_name('IGS','IGS_UC_SETUP_REJC_OUSTAT');
2830: fnd_message.set_token('SYSTEM', c_ch_system_rec.system_code);
2831: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2832: l_no_setup := TRUE ;
2833: END IF;
2834:

Line 2831: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);

2827: -- Check if the set up data for rejected outcome status is found in ucas defaults form
2828: IF c_defaults_rec.rejected_outcome_status IS NULL THEN
2829: fnd_message.set_name('IGS','IGS_UC_SETUP_REJC_OUSTAT');
2830: fnd_message.set_token('SYSTEM', c_ch_system_rec.system_code);
2831: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2832: l_no_setup := TRUE ;
2833: END IF;
2834:
2835: -- Check if the set up data for decision maker is found in ucas defaults form

Line 2837: fnd_message.set_name('IGS','IGS_UC_SETUP_DEC_MAKE');

2833: END IF;
2834:
2835: -- Check if the set up data for decision maker is found in ucas defaults form
2836: IF c_defaults_rec.decision_make_id IS NULL THEN
2837: fnd_message.set_name('IGS','IGS_UC_SETUP_DEC_MAKE');
2838: fnd_message.set_token('SYSTEM', c_ch_system_rec.system_code);
2839: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2840: l_no_setup := TRUE ;
2841: END IF;

Line 2838: fnd_message.set_token('SYSTEM', c_ch_system_rec.system_code);

2834:
2835: -- Check if the set up data for decision maker is found in ucas defaults form
2836: IF c_defaults_rec.decision_make_id IS NULL THEN
2837: fnd_message.set_name('IGS','IGS_UC_SETUP_DEC_MAKE');
2838: fnd_message.set_token('SYSTEM', c_ch_system_rec.system_code);
2839: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2840: l_no_setup := TRUE ;
2841: END IF;
2842:

Line 2839: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);

2835: -- Check if the set up data for decision maker is found in ucas defaults form
2836: IF c_defaults_rec.decision_make_id IS NULL THEN
2837: fnd_message.set_name('IGS','IGS_UC_SETUP_DEC_MAKE');
2838: fnd_message.set_token('SYSTEM', c_ch_system_rec.system_code);
2839: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2840: l_no_setup := TRUE ;
2841: END IF;
2842:
2843: -- Check if the set up data for decision reason is found in ucas defaults form

Line 2845: fnd_message.set_name('IGS','IGS_UC_SETUP_DEC_REASON');

2841: END IF;
2842:
2843: -- Check if the set up data for decision reason is found in ucas defaults form
2844: IF c_defaults_rec.decision_reason_id IS NULL THEN
2845: fnd_message.set_name('IGS','IGS_UC_SETUP_DEC_REASON');
2846: fnd_message.set_token('SYSTEM', c_ch_system_rec.system_code);
2847: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2848: l_no_setup := TRUE ;
2849: END IF;

Line 2846: fnd_message.set_token('SYSTEM', c_ch_system_rec.system_code);

2842:
2843: -- Check if the set up data for decision reason is found in ucas defaults form
2844: IF c_defaults_rec.decision_reason_id IS NULL THEN
2845: fnd_message.set_name('IGS','IGS_UC_SETUP_DEC_REASON');
2846: fnd_message.set_token('SYSTEM', c_ch_system_rec.system_code);
2847: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2848: l_no_setup := TRUE ;
2849: END IF;
2850:

Line 2847: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);

2843: -- Check if the set up data for decision reason is found in ucas defaults form
2844: IF c_defaults_rec.decision_reason_id IS NULL THEN
2845: fnd_message.set_name('IGS','IGS_UC_SETUP_DEC_REASON');
2846: fnd_message.set_token('SYSTEM', c_ch_system_rec.system_code);
2847: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2848: l_no_setup := TRUE ;
2849: END IF;
2850:
2851: END LOOP ; -- checking for setup

Line 2855: fnd_message.set_name('IGS','IGS_UC_SETUP_CANCEL_OUSTAT');

2851: END LOOP ; -- checking for setup
2852:
2853: --add check for checking whether CANCELLED system status has been mapped
2854: IF IGS_AD_GEN_009.Admp_Get_Sys_Aos('CANCELLED') IS NULL THEN
2855: fnd_message.set_name('IGS','IGS_UC_SETUP_CANCEL_OUSTAT');
2856: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2857: l_no_setup := TRUE ;
2858: END IF;
2859:

Line 2856: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);

2852:
2853: --add check for checking whether CANCELLED system status has been mapped
2854: IF IGS_AD_GEN_009.Admp_Get_Sys_Aos('CANCELLED') IS NULL THEN
2855: fnd_message.set_name('IGS','IGS_UC_SETUP_CANCEL_OUSTAT');
2856: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2857: l_no_setup := TRUE ;
2858: END IF;
2859:
2860: IF l_no_setup THEN

Line 2871: FND_MESSAGE.SET_NAME('IGS','IGS_UC_OBSOL_APP');

2867: -- Call the sub process to obsolete the old admission application when
2868: -- the application choice results in a new application/instance
2869: -- for all application choices in status New
2870: fnd_file.put_line( fnd_file.LOG ,' ');
2871: FND_MESSAGE.SET_NAME('IGS','IGS_UC_OBSOL_APP');
2872: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2873: fnd_file.put_line( fnd_file.LOG ,'-----------------------------------');
2874:
2875: obsolete_applications( p_app_no, p_choice_no) ;

Line 2872: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);

2868: -- the application choice results in a new application/instance
2869: -- for all application choices in status New
2870: fnd_file.put_line( fnd_file.LOG ,' ');
2871: FND_MESSAGE.SET_NAME('IGS','IGS_UC_OBSOL_APP');
2872: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2873: fnd_file.put_line( fnd_file.LOG ,'-----------------------------------');
2874:
2875: obsolete_applications( p_app_no, p_choice_no) ;
2876:

Line 2880: FND_MESSAGE.SET_NAME('IGS','IGS_UC_CRE_APP');

2876:
2877: -- Call the sub process to create new application/instance or update the existing admissionapplication
2878: -- for all application choices in status OC
2879: fnd_file.put_line( fnd_file.LOG ,' ');
2880: FND_MESSAGE.SET_NAME('IGS','IGS_UC_CRE_APP');
2881: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2882: fnd_file.put_line( fnd_file.LOG ,'-----------------------------------');
2883:
2884: export_applications( p_app_no, p_choice_no) ;

Line 2881: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);

2877: -- Call the sub process to create new application/instance or update the existing admissionapplication
2878: -- for all application choices in status OC
2879: fnd_file.put_line( fnd_file.LOG ,' ');
2880: FND_MESSAGE.SET_NAME('IGS','IGS_UC_CRE_APP');
2881: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2882: fnd_file.put_line( fnd_file.LOG ,'-----------------------------------');
2883:
2884: export_applications( p_app_no, p_choice_no) ;
2885:

Line 2889: FND_MESSAGE.SET_NAME('IGS','IGS_UC_DEC_IMP');

2885:
2886: -- Call the process to import the UCAS decision field into oss outcome status field
2887: -- for all application choices in status AC
2888: fnd_file.put_line( fnd_file.LOG ,' ');
2889: FND_MESSAGE.SET_NAME('IGS','IGS_UC_DEC_IMP');
2890: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2891: fnd_file.put_line( fnd_file.LOG ,'-----------------------------------');
2892:
2893: igs_uc_export_decision_reply.export_decision( p_app_no, p_choice_no) ;

Line 2890: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);

2886: -- Call the process to import the UCAS decision field into oss outcome status field
2887: -- for all application choices in status AC
2888: fnd_file.put_line( fnd_file.LOG ,' ');
2889: FND_MESSAGE.SET_NAME('IGS','IGS_UC_DEC_IMP');
2890: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2891: fnd_file.put_line( fnd_file.LOG ,'-----------------------------------');
2892:
2893: igs_uc_export_decision_reply.export_decision( p_app_no, p_choice_no) ;
2894:

Line 2898: FND_MESSAGE.SET_NAME('IGS','IGS_UC_OFR_IMP');

2894:
2895: -- Call the process to import the UCAS Reply field into oss offer response status field
2896: -- for all application choices in status DC
2897: fnd_file.put_line( fnd_file.LOG ,' ');
2898: FND_MESSAGE.SET_NAME('IGS','IGS_UC_OFR_IMP');
2899: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2900: fnd_file.put_line( fnd_file.LOG ,'-----------------------------------');
2901:
2902: igs_uc_export_decision_reply.export_reply( p_app_no, p_choice_no) ;

Line 2899: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);

2895: -- Call the process to import the UCAS Reply field into oss offer response status field
2896: -- for all application choices in status DC
2897: fnd_file.put_line( fnd_file.LOG ,' ');
2898: FND_MESSAGE.SET_NAME('IGS','IGS_UC_OFR_IMP');
2899: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2900: fnd_file.put_line( fnd_file.LOG ,'-----------------------------------');
2901:
2902: igs_uc_export_decision_reply.export_reply( p_app_no, p_choice_no) ;
2903:

Line 2906: fnd_message.set_name('IGS','IGS_UC_EXP_APP_PROC_COMP');

2902: igs_uc_export_decision_reply.export_reply( p_app_no, p_choice_no) ;
2903:
2904: -- log message that the Export applications to oss process has completed
2905: fnd_file.put_line( fnd_file.LOG ,' ');
2906: fnd_message.set_name('IGS','IGS_UC_EXP_APP_PROC_COMP');
2907: fnd_file.put_line(fnd_file.log,fnd_message.get());
2908: fnd_file.put_line( fnd_file.LOG ,'-----------------------------------');
2909:
2910: -- Submit the Error report to show the errors generated while exporting applications

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

2903:
2904: -- log message that the Export applications to oss process has completed
2905: fnd_file.put_line( fnd_file.LOG ,' ');
2906: fnd_message.set_name('IGS','IGS_UC_EXP_APP_PROC_COMP');
2907: fnd_file.put_line(fnd_file.log,fnd_message.get());
2908: fnd_file.put_line( fnd_file.LOG ,'-----------------------------------');
2909:
2910: -- Submit the Error report to show the errors generated while exporting applications
2911: l_rep_request_id := NULL ;

Line 2936: fnd_message.set_name('IGS','IGS_UC_REP_SUBM');

2932: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
2933: IF l_rep_request_id > 0 THEN
2934: -- if error report successfully submitted then log message
2935: fnd_file.put_line( fnd_file.LOG ,' ');
2936: fnd_message.set_name('IGS','IGS_UC_REP_SUBM');
2937: fnd_message.set_token('REQ_ID',TO_CHAR(l_rep_request_id));
2938: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2939: ELSE
2940: -- if error report failed to be launched then log message

Line 2937: fnd_message.set_token('REQ_ID',TO_CHAR(l_rep_request_id));

2933: IF l_rep_request_id > 0 THEN
2934: -- if error report successfully submitted then log message
2935: fnd_file.put_line( fnd_file.LOG ,' ');
2936: fnd_message.set_name('IGS','IGS_UC_REP_SUBM');
2937: fnd_message.set_token('REQ_ID',TO_CHAR(l_rep_request_id));
2938: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2939: ELSE
2940: -- if error report failed to be launched then log message
2941: fnd_message.set_name('IGS','IGS_UC_REP_SUBM_ERR');

Line 2938: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);

2934: -- if error report successfully submitted then log message
2935: fnd_file.put_line( fnd_file.LOG ,' ');
2936: fnd_message.set_name('IGS','IGS_UC_REP_SUBM');
2937: fnd_message.set_token('REQ_ID',TO_CHAR(l_rep_request_id));
2938: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2939: ELSE
2940: -- if error report failed to be launched then log message
2941: fnd_message.set_name('IGS','IGS_UC_REP_SUBM_ERR');
2942: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);

Line 2941: fnd_message.set_name('IGS','IGS_UC_REP_SUBM_ERR');

2937: fnd_message.set_token('REQ_ID',TO_CHAR(l_rep_request_id));
2938: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2939: ELSE
2940: -- if error report failed to be launched then log message
2941: fnd_message.set_name('IGS','IGS_UC_REP_SUBM_ERR');
2942: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2943: END IF;
2944:
2945: END IF; -- If ucas setup proper or not

Line 2942: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);

2938: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2939: ELSE
2940: -- if error report failed to be launched then log message
2941: fnd_message.set_name('IGS','IGS_UC_REP_SUBM_ERR');
2942: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2943: END IF;
2944:
2945: END IF; -- If ucas setup proper or not
2946:

Line 2951: Errbuf := fnd_message.get_string ('IGS', 'IGS_UC_HE_NOT_ENABLED');

2947:
2948: EXCEPTION
2949: WHEN IGS_UC_HE_NOT_ENABLED_EXCEP THEN
2950: -- ucas functionality is not enabled
2951: Errbuf := fnd_message.get_string ('IGS', 'IGS_UC_HE_NOT_ENABLED');
2952: Retcode := 2 ;
2953: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
2954:
2955: WHEN OTHERS THEN

Line 2957: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

2953: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
2954:
2955: WHEN OTHERS THEN
2956: Rollback;
2957: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2958: fnd_message.set_token('NAME','IGS_UCAS_EXPORT_TO_OSS.MAIN_PROCESS'||' - '||SQLERRM);
2959: fnd_message.retrieve (Errbuf);
2960: Retcode := 2 ;
2961: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;

Line 2958: fnd_message.set_token('NAME','IGS_UCAS_EXPORT_TO_OSS.MAIN_PROCESS'||' - '||SQLERRM);

2954:
2955: WHEN OTHERS THEN
2956: Rollback;
2957: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2958: fnd_message.set_token('NAME','IGS_UCAS_EXPORT_TO_OSS.MAIN_PROCESS'||' - '||SQLERRM);
2959: fnd_message.retrieve (Errbuf);
2960: Retcode := 2 ;
2961: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
2962:

Line 2959: fnd_message.retrieve (Errbuf);

2955: WHEN OTHERS THEN
2956: Rollback;
2957: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2958: fnd_message.set_token('NAME','IGS_UCAS_EXPORT_TO_OSS.MAIN_PROCESS'||' - '||SQLERRM);
2959: fnd_message.retrieve (Errbuf);
2960: Retcode := 2 ;
2961: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
2962:
2963: END main_process ;