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

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

398: END IF;
399:
400: EXCEPTION
401: WHEN OTHERS THEN
402: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
403: fnd_message.set_token('NAME','IGS_UC_EXPORT_DECISION_REPLY.GET_BATCHID_LOC'||' - '||SQLERRM);
404: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
405: App_Exception.Raise_Exception;
406:

Line 403: fnd_message.set_token('NAME','IGS_UC_EXPORT_DECISION_REPLY.GET_BATCHID_LOC'||' - '||SQLERRM);

399:
400: EXCEPTION
401: WHEN OTHERS THEN
402: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
403: fnd_message.set_token('NAME','IGS_UC_EXPORT_DECISION_REPLY.GET_BATCHID_LOC'||' - '||SQLERRM);
404: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
405: App_Exception.Raise_Exception;
406:
407: END get_batchid_loc;

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

400: EXCEPTION
401: WHEN OTHERS THEN
402: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
403: fnd_message.set_token('NAME','IGS_UC_EXPORT_DECISION_REPLY.GET_BATCHID_LOC'||' - '||SQLERRM);
404: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
405: App_Exception.Raise_Exception;
406:
407: END get_batchid_loc;
408:

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

444: CLOSE cur_apc_det;
445:
446: -- We need to create a separate batch id for each of the UCAS System's calendars
447: -- Get the Batch ID Description value from the Message,IGS_UC_DEC_BATCH
448: fnd_message.set_name('IGS','IGS_UC_DEC_BATCH');
449: l_description := fnd_message.get;
450: l_rowid := NULL ;
451: l_batch_id := NULL;
452:

Line 449: l_description := fnd_message.get;

445:
446: -- We need to create a separate batch id for each of the UCAS System's calendars
447: -- Get the Batch ID Description value from the Message,IGS_UC_DEC_BATCH
448: fnd_message.set_name('IGS','IGS_UC_DEC_BATCH');
449: l_description := fnd_message.get;
450: l_rowid := NULL ;
451: l_batch_id := NULL;
452:
453: --Get the Calendar details for the given System, Entry Month and Entry Year from System Calendards table.

Line 541: fnd_message.set_name('IGS','IGS_UC_APP_INST_NOTFOUND');

537: l_app_choice_error_code := 'D002' ;
538: l_export_to_oss_status := cur_ucas_app_choice_rec.export_to_oss_status ;
539: l_ch_batch_id := NULL ;
540: -- Write the error message to the Log file indicating the error occurred
541: fnd_message.set_name('IGS','IGS_UC_APP_INST_NOTFOUND');
542: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
543: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
544: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
545:

Line 542: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));

538: l_export_to_oss_status := cur_ucas_app_choice_rec.export_to_oss_status ;
539: l_ch_batch_id := NULL ;
540: -- Write the error message to the Log file indicating the error occurred
541: fnd_message.set_name('IGS','IGS_UC_APP_INST_NOTFOUND');
542: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
543: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
544: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
545:
546: ELSE /* OSS Application Instance Found */

Line 543: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));

539: l_ch_batch_id := NULL ;
540: -- Write the error message to the Log file indicating the error occurred
541: fnd_message.set_name('IGS','IGS_UC_APP_INST_NOTFOUND');
542: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
543: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
544: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
545:
546: ELSE /* OSS Application Instance Found */
547:

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

540: -- Write the error message to the Log file indicating the error occurred
541: fnd_message.set_name('IGS','IGS_UC_APP_INST_NOTFOUND');
542: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
543: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
544: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
545:
546: ELSE /* OSS Application Instance Found */
547:
548: -- jchin - bug 3691277 and 3691250

Line 567: fnd_message.set_name('IGS','IGS_UC_APP_INST_NOTFOUND');

563: l_app_choice_error_code := 'D002' ;
564: l_export_to_oss_status := cur_ucas_app_choice_rec.export_to_oss_status ;
565: l_ch_batch_id := NULL ;
566: -- Write the error message to the Log file indicating the error occurred
567: fnd_message.set_name('IGS','IGS_UC_APP_INST_NOTFOUND');
568: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
569: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
570: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
571: ELSE /* OSS Application Instance and unit-set-code found */

Line 568: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));

564: l_export_to_oss_status := cur_ucas_app_choice_rec.export_to_oss_status ;
565: l_ch_batch_id := NULL ;
566: -- Write the error message to the Log file indicating the error occurred
567: fnd_message.set_name('IGS','IGS_UC_APP_INST_NOTFOUND');
568: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
569: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
570: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
571: ELSE /* OSS Application Instance and unit-set-code found */
572:

Line 569: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));

565: l_ch_batch_id := NULL ;
566: -- Write the error message to the Log file indicating the error occurred
567: fnd_message.set_name('IGS','IGS_UC_APP_INST_NOTFOUND');
568: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
569: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
570: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
571: ELSE /* OSS Application Instance and unit-set-code found */
572:
573: -- Get the System Admission Outcome status of the current admission Application Outcome status

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

566: -- Write the error message to the Log file indicating the error occurred
567: fnd_message.set_name('IGS','IGS_UC_APP_INST_NOTFOUND');
568: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
569: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
570: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
571: ELSE /* OSS Application Instance and unit-set-code found */
572:
573: -- Get the System Admission Outcome status of the current admission Application Outcome status
574: -- This will be used in the following code

Line 631: fnd_message.set_name('IGS','IGS_UC_TRAN_NOT_FOUND');

627: igs_uc_old_oustat_pkg.delete_row(
628: X_ROWID => cur_prev_ou_captured_rec.ROWID ) ;
629:
630: -- Write the error message to the Log file indicating the error occurred
631: fnd_message.set_name('IGS','IGS_UC_TRAN_NOT_FOUND');
632: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no) );
633: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no) );
634: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
635:

Line 632: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no) );

628: X_ROWID => cur_prev_ou_captured_rec.ROWID ) ;
629:
630: -- Write the error message to the Log file indicating the error occurred
631: fnd_message.set_name('IGS','IGS_UC_TRAN_NOT_FOUND');
632: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no) );
633: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no) );
634: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
635:
636: ELSE /* Latest Transaction was found */

Line 633: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no) );

629:
630: -- Write the error message to the Log file indicating the error occurred
631: fnd_message.set_name('IGS','IGS_UC_TRAN_NOT_FOUND');
632: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no) );
633: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no) );
634: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
635:
636: ELSE /* Latest Transaction was found */
637:

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

630: -- Write the error message to the Log file indicating the error occurred
631: fnd_message.set_name('IGS','IGS_UC_TRAN_NOT_FOUND');
632: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no) );
633: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no) );
634: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
635:
636: ELSE /* Latest Transaction was found */
637:
638: --anwest 06-JUN-06 Bug #5190520 UCTD320 - UCAS 2006 CLEARING ISSUES

Line 781: fnd_message.set_name('IGS','IGS_UC_TRANS_DEC_NOT_MAPPED');

777: l_export_to_oss_status := cur_ucas_app_choice_rec.export_to_oss_status;
778: l_ch_batch_id := NULL ;
779:
780: -- Write the error message to the Log file indicating the error occurred
781: fnd_message.set_name('IGS','IGS_UC_TRANS_DEC_NOT_MAPPED');
782: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no ));
783: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
784: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
785:

Line 782: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no ));

778: l_ch_batch_id := NULL ;
779:
780: -- Write the error message to the Log file indicating the error occurred
781: fnd_message.set_name('IGS','IGS_UC_TRANS_DEC_NOT_MAPPED');
782: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no ));
783: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
784: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
785:
786: END IF; /* End of mapping found */

Line 783: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));

779:
780: -- Write the error message to the Log file indicating the error occurred
781: fnd_message.set_name('IGS','IGS_UC_TRANS_DEC_NOT_MAPPED');
782: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no ));
783: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
784: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
785:
786: END IF; /* End of mapping found */
787:

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

780: -- Write the error message to the Log file indicating the error occurred
781: fnd_message.set_name('IGS','IGS_UC_TRANS_DEC_NOT_MAPPED');
782: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no ));
783: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
784: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
785:
786: END IF; /* End of mapping found */
787:
788: END IF; /* Latest Transaction Found */

Line 860: fnd_message.set_name('IGS','IGS_UC_EXP_BULK_REJ_DEC_FAIL');

856: l_export_to_oss_status := cur_ucas_app_choice_rec.export_to_oss_status;
857: l_ch_batch_id := NULL ;
858:
859: -- Write the error message to the Log file indicating the error occurred
860: fnd_message.set_name('IGS','IGS_UC_EXP_BULK_REJ_DEC_FAIL');
861: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
862: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
863: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
864:

Line 861: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));

857: l_ch_batch_id := NULL ;
858:
859: -- Write the error message to the Log file indicating the error occurred
860: fnd_message.set_name('IGS','IGS_UC_EXP_BULK_REJ_DEC_FAIL');
861: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
862: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
863: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
864:
865: END IF ;

Line 862: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));

858:
859: -- Write the error message to the Log file indicating the error occurred
860: fnd_message.set_name('IGS','IGS_UC_EXP_BULK_REJ_DEC_FAIL');
861: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
862: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
863: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
864:
865: END IF ;
866: CLOSE cur_unprocess_trans_exist ;

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

859: -- Write the error message to the Log file indicating the error occurred
860: fnd_message.set_name('IGS','IGS_UC_EXP_BULK_REJ_DEC_FAIL');
861: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
862: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
863: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
864:
865: END IF ;
866: CLOSE cur_unprocess_trans_exist ;
867:

Line 965: fnd_message.set_name('IGS','IGS_UC_APP_INST_COMPLETED');

961: l_app_choice_error_code := 'D004' ;
962: l_export_to_oss_status := cur_ucas_app_choice_rec.export_to_oss_status;
963: l_ch_batch_id := NULL ;
964: -- Write the error message to the Log file indicating the error occurred
965: fnd_message.set_name('IGS','IGS_UC_APP_INST_COMPLETED');
966: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
967: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
968: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
969:

Line 966: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));

962: l_export_to_oss_status := cur_ucas_app_choice_rec.export_to_oss_status;
963: l_ch_batch_id := NULL ;
964: -- Write the error message to the Log file indicating the error occurred
965: fnd_message.set_name('IGS','IGS_UC_APP_INST_COMPLETED');
966: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
967: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
968: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
969:
970: ELSE

Line 967: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));

963: l_ch_batch_id := NULL ;
964: -- Write the error message to the Log file indicating the error occurred
965: fnd_message.set_name('IGS','IGS_UC_APP_INST_COMPLETED');
966: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
967: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
968: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
969:
970: ELSE
971:

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

964: -- Write the error message to the Log file indicating the error occurred
965: fnd_message.set_name('IGS','IGS_UC_APP_INST_COMPLETED');
966: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
967: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
968: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
969:
970: ELSE
971:
972: -- If the latest decision setting transaction is processed successfully,

Line 1030: fnd_message.set_name('IGS','IGS_UC_APPCH_DEC_NOT_MAPPED');

1026: l_export_to_oss_status := cur_ucas_app_choice_rec.export_to_oss_status;
1027: l_ch_batch_id := NULL ;
1028:
1029: -- Write the error message to the Log file indicating the error occurred
1030: fnd_message.set_name('IGS','IGS_UC_APPCH_DEC_NOT_MAPPED');
1031: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
1032: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
1033: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
1034: END IF;

Line 1031: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));

1027: l_ch_batch_id := NULL ;
1028:
1029: -- Write the error message to the Log file indicating the error occurred
1030: fnd_message.set_name('IGS','IGS_UC_APPCH_DEC_NOT_MAPPED');
1031: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
1032: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
1033: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
1034: END IF;
1035:

Line 1032: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));

1028:
1029: -- Write the error message to the Log file indicating the error occurred
1030: fnd_message.set_name('IGS','IGS_UC_APPCH_DEC_NOT_MAPPED');
1031: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
1032: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
1033: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
1034: END IF;
1035:
1036: ELSE /* If the latest decision setting transaction is NOT processed successfully,

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

1029: -- Write the error message to the Log file indicating the error occurred
1030: fnd_message.set_name('IGS','IGS_UC_APPCH_DEC_NOT_MAPPED');
1031: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
1032: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
1033: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
1034: END IF;
1035:
1036: ELSE /* If the latest decision setting transaction is NOT processed successfully,
1037: then populate the OSS admission outcome ststaus corresponding to UCAS Transaction Decision*/

Line 1098: fnd_message.set_name('IGS','IGS_UC_TRANS_DEC_NOT_MAPPED');

1094: l_export_to_oss_status := cur_ucas_app_choice_rec.export_to_oss_status;
1095: l_ch_batch_id := NULL ;
1096:
1097: -- Write the error message to the Log file indicating the error occurred
1098: fnd_message.set_name('IGS','IGS_UC_TRANS_DEC_NOT_MAPPED');
1099: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
1100: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
1101: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
1102:

Line 1099: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));

1095: l_ch_batch_id := NULL ;
1096:
1097: -- Write the error message to the Log file indicating the error occurred
1098: fnd_message.set_name('IGS','IGS_UC_TRANS_DEC_NOT_MAPPED');
1099: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
1100: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
1101: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
1102:
1103: END IF;

Line 1100: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));

1096:
1097: -- Write the error message to the Log file indicating the error occurred
1098: fnd_message.set_name('IGS','IGS_UC_TRANS_DEC_NOT_MAPPED');
1099: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
1100: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
1101: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
1102:
1103: END IF;
1104: CLOSE cur_ou_mapping;

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

1097: -- Write the error message to the Log file indicating the error occurred
1098: fnd_message.set_name('IGS','IGS_UC_TRANS_DEC_NOT_MAPPED');
1099: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
1100: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
1101: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
1102:
1103: END IF;
1104: CLOSE cur_ou_mapping;
1105:

Line 1187: fnd_message.set_name('IGS','IGS_UC_DEC_IMP_ERR');

1183: l_export_to_oss_status :='DP';
1184: l_ch_batch_id := l_batch_id ;
1185:
1186: -- Write the error message to the Log file indicating the error occurred
1187: fnd_message.set_name('IGS','IGS_UC_DEC_IMP_ERR');
1188: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
1189: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
1190: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
1191:

Line 1188: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));

1184: l_ch_batch_id := l_batch_id ;
1185:
1186: -- Write the error message to the Log file indicating the error occurred
1187: fnd_message.set_name('IGS','IGS_UC_DEC_IMP_ERR');
1188: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
1189: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
1190: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
1191:
1192: ELSE /* If l_error_message IS NULL, that means Decision Process was successfull */

Line 1189: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));

1185:
1186: -- Write the error message to the Log file indicating the error occurred
1187: fnd_message.set_name('IGS','IGS_UC_DEC_IMP_ERR');
1188: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
1189: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
1190: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
1191:
1192: ELSE /* If l_error_message IS NULL, that means Decision Process was successfull */
1193: l_app_choice_error_code := NULL ;

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

1186: -- Write the error message to the Log file indicating the error occurred
1187: fnd_message.set_name('IGS','IGS_UC_DEC_IMP_ERR');
1188: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
1189: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
1190: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
1191:
1192: ELSE /* If l_error_message IS NULL, that means Decision Process was successfull */
1193: l_app_choice_error_code := NULL ;
1194: l_export_to_oss_status :='DC';

Line 1393: fnd_message.set_name('IGS','IGS_UC_DEC_IMP_ERR');

1389:
1390: ELSE
1391:
1392: -- Write the error message to the Log file indicating the error occurred
1393: fnd_message.set_name('IGS','IGS_UC_DEC_IMP_ERR');
1394: fnd_message.set_token('APP_NO',TO_CHAR(cur_dp_app_choice_rec.app_no));
1395: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_dp_app_choice_rec.choice_no));
1396: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
1397:

Line 1394: fnd_message.set_token('APP_NO',TO_CHAR(cur_dp_app_choice_rec.app_no));

1390: ELSE
1391:
1392: -- Write the error message to the Log file indicating the error occurred
1393: fnd_message.set_name('IGS','IGS_UC_DEC_IMP_ERR');
1394: fnd_message.set_token('APP_NO',TO_CHAR(cur_dp_app_choice_rec.app_no));
1395: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_dp_app_choice_rec.choice_no));
1396: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
1397:
1398: END IF;

Line 1395: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_dp_app_choice_rec.choice_no));

1391:
1392: -- Write the error message to the Log file indicating the error occurred
1393: fnd_message.set_name('IGS','IGS_UC_DEC_IMP_ERR');
1394: fnd_message.set_token('APP_NO',TO_CHAR(cur_dp_app_choice_rec.app_no));
1395: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_dp_app_choice_rec.choice_no));
1396: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
1397:
1398: END IF;
1399: CLOSE cur_dec_import_error;

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

1392: -- Write the error message to the Log file indicating the error occurred
1393: fnd_message.set_name('IGS','IGS_UC_DEC_IMP_ERR');
1394: fnd_message.set_token('APP_NO',TO_CHAR(cur_dp_app_choice_rec.app_no));
1395: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_dp_app_choice_rec.choice_no));
1396: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
1397:
1398: END IF;
1399: CLOSE cur_dec_import_error;
1400:

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

1410:
1411: EXCEPTION
1412: WHEN OTHERS THEN
1413:
1414: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
1415: fnd_message.set_token('NAME','IGS_UC_EXPORT_DECISION_REPLY.EXPORT_DECISION'||' - '||SQLERRM);
1416: IGS_GE_MSG_STACK.ADD;
1417: App_Exception.Raise_Exception;
1418:

Line 1415: fnd_message.set_token('NAME','IGS_UC_EXPORT_DECISION_REPLY.EXPORT_DECISION'||' - '||SQLERRM);

1411: EXCEPTION
1412: WHEN OTHERS THEN
1413:
1414: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
1415: fnd_message.set_token('NAME','IGS_UC_EXPORT_DECISION_REPLY.EXPORT_DECISION'||' - '||SQLERRM);
1416: IGS_GE_MSG_STACK.ADD;
1417: App_Exception.Raise_Exception;
1418:
1419: END export_decision;

Line 1691: fnd_message.set_name('IGS','IGS_UC_OFF_BATCH');

1687: l_last_updated_by := NVL(FND_GLOBAL.USER_ID,-1) ;
1688: l_last_update_login := NVL(FND_GLOBAL.LOGIN_ID,-1) ;
1689:
1690: -- Get the Description value from the Message,IGS_UC_OFF_BATCH
1691: fnd_message.set_name('IGS','IGS_UC_OFF_BATCH');
1692: l_description := fnd_message.get;
1693:
1694: INSERT INTO igs_ad_offresp_batch
1695: ( batch_id,

Line 1692: l_description := fnd_message.get;

1688: l_last_update_login := NVL(FND_GLOBAL.LOGIN_ID,-1) ;
1689:
1690: -- Get the Description value from the Message,IGS_UC_OFF_BATCH
1691: fnd_message.set_name('IGS','IGS_UC_OFF_BATCH');
1692: l_description := fnd_message.get;
1693:
1694: INSERT INTO igs_ad_offresp_batch
1695: ( batch_id,
1696: batch_desc,

Line 1769: fnd_message.set_name('IGS','IGS_UC_APP_INST_NOTFOUND');

1765: l_app_choice_error_code := 'R002' ;
1766: l_export_to_oss := cur_ucas_app_choice_rec.export_to_oss_status ;
1767: l_ch_batch_id := NULL ;
1768: -- Write the error message to the Log file indicating the error occurred
1769: fnd_message.set_name('IGS','IGS_UC_APP_INST_NOTFOUND');
1770: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
1771: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
1772: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
1773:

Line 1770: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));

1766: l_export_to_oss := cur_ucas_app_choice_rec.export_to_oss_status ;
1767: l_ch_batch_id := NULL ;
1768: -- Write the error message to the Log file indicating the error occurred
1769: fnd_message.set_name('IGS','IGS_UC_APP_INST_NOTFOUND');
1770: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
1771: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
1772: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
1773:
1774: ELSE /* OSS Application Instance Found */

Line 1771: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));

1767: l_ch_batch_id := NULL ;
1768: -- Write the error message to the Log file indicating the error occurred
1769: fnd_message.set_name('IGS','IGS_UC_APP_INST_NOTFOUND');
1770: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
1771: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
1772: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
1773:
1774: ELSE /* OSS Application Instance Found */
1775:

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

1768: -- Write the error message to the Log file indicating the error occurred
1769: fnd_message.set_name('IGS','IGS_UC_APP_INST_NOTFOUND');
1770: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
1771: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
1772: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
1773:
1774: ELSE /* OSS Application Instance Found */
1775:
1776: -- jchin - Bug 3691277 and 3691250

Line 1795: fnd_message.set_name('IGS','IGS_UC_APP_INST_NOTFOUND');

1791: l_app_choice_error_code := 'D002' ;
1792: l_export_to_oss := cur_ucas_app_choice_rec.export_to_oss_status ;
1793: l_ch_batch_id := NULL ;
1794: -- Write the error message to the Log file indicating the error occurred
1795: fnd_message.set_name('IGS','IGS_UC_APP_INST_NOTFOUND');
1796: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
1797: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
1798: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
1799: ELSE /* OSS Application Instance and unit-set-code found */

Line 1796: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));

1792: l_export_to_oss := cur_ucas_app_choice_rec.export_to_oss_status ;
1793: l_ch_batch_id := NULL ;
1794: -- Write the error message to the Log file indicating the error occurred
1795: fnd_message.set_name('IGS','IGS_UC_APP_INST_NOTFOUND');
1796: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
1797: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
1798: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
1799: ELSE /* OSS Application Instance and unit-set-code found */
1800:

Line 1797: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));

1793: l_ch_batch_id := NULL ;
1794: -- Write the error message to the Log file indicating the error occurred
1795: fnd_message.set_name('IGS','IGS_UC_APP_INST_NOTFOUND');
1796: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
1797: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
1798: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
1799: ELSE /* OSS Application Instance and unit-set-code found */
1800:
1801:

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

1794: -- Write the error message to the Log file indicating the error occurred
1795: fnd_message.set_name('IGS','IGS_UC_APP_INST_NOTFOUND');
1796: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
1797: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
1798: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
1799: ELSE /* OSS Application Instance and unit-set-code found */
1800:
1801:
1802: -- Check whether UCAS reply needs to exported to OSS or not

Line 1818: fnd_message.set_name('IGS','IGS_UC_DEC_REPLY_NOT_MAPPED');

1814: l_app_choice_error_code := 'R003' ;
1815: l_export_to_oss := cur_ucas_app_choice_rec.export_to_oss_status ;
1816: l_ch_batch_id := NULL ;
1817: -- Write the error message to the Log file indicating the error occurred
1818: fnd_message.set_name('IGS','IGS_UC_DEC_REPLY_NOT_MAPPED');
1819: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
1820: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
1821: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
1822:

Line 1819: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));

1815: l_export_to_oss := cur_ucas_app_choice_rec.export_to_oss_status ;
1816: l_ch_batch_id := NULL ;
1817: -- Write the error message to the Log file indicating the error occurred
1818: fnd_message.set_name('IGS','IGS_UC_DEC_REPLY_NOT_MAPPED');
1819: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
1820: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
1821: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
1822:
1823: ELSE /* OSS user Offer Response mapping to the UCAS system decision and reply found */

Line 1820: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));

1816: l_ch_batch_id := NULL ;
1817: -- Write the error message to the Log file indicating the error occurred
1818: fnd_message.set_name('IGS','IGS_UC_DEC_REPLY_NOT_MAPPED');
1819: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
1820: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
1821: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
1822:
1823: ELSE /* OSS user Offer Response mapping to the UCAS system decision and reply found */
1824: CLOSE cur_map_offr_resp;

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

1817: -- Write the error message to the Log file indicating the error occurred
1818: fnd_message.set_name('IGS','IGS_UC_DEC_REPLY_NOT_MAPPED');
1819: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
1820: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
1821: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
1822:
1823: ELSE /* OSS user Offer Response mapping to the UCAS system decision and reply found */
1824: CLOSE cur_map_offr_resp;
1825: -- Check whether the OSS Application Instance system outcome status is 'OFFER' or 'COND-OFFER'

Line 1835: fnd_message.set_name('IGS','IGS_UC_APP_NOT_OFFERED');

1831: l_app_choice_error_code := 'R004' ;
1832: l_export_to_oss := cur_ucas_app_choice_rec.export_to_oss_status ;
1833: l_ch_batch_id := NULL ;
1834: -- Write the error message to the Log file indicating the error occurred
1835: fnd_message.set_name('IGS','IGS_UC_APP_NOT_OFFERED');
1836: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
1837: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
1838: fnd_file.put_line( fnd_file.LOG ,fnd_message.get );
1839:

Line 1836: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));

1832: l_export_to_oss := cur_ucas_app_choice_rec.export_to_oss_status ;
1833: l_ch_batch_id := NULL ;
1834: -- Write the error message to the Log file indicating the error occurred
1835: fnd_message.set_name('IGS','IGS_UC_APP_NOT_OFFERED');
1836: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
1837: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
1838: fnd_file.put_line( fnd_file.LOG ,fnd_message.get );
1839:
1840: ELSE /* OSS Application Instnace system Offer Response status is 'OFFER' or 'COND-OFFER' */

Line 1837: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));

1833: l_ch_batch_id := NULL ;
1834: -- Write the error message to the Log file indicating the error occurred
1835: fnd_message.set_name('IGS','IGS_UC_APP_NOT_OFFERED');
1836: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
1837: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
1838: fnd_file.put_line( fnd_file.LOG ,fnd_message.get );
1839:
1840: ELSE /* OSS Application Instnace system Offer Response status is 'OFFER' or 'COND-OFFER' */
1841:

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

1834: -- Write the error message to the Log file indicating the error occurred
1835: fnd_message.set_name('IGS','IGS_UC_APP_NOT_OFFERED');
1836: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
1837: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
1838: fnd_file.put_line( fnd_file.LOG ,fnd_message.get );
1839:
1840: ELSE /* OSS Application Instnace system Offer Response status is 'OFFER' or 'COND-OFFER' */
1841:
1842: -- If the OSS User Admission Offer Response Status mapped to the

Line 1920: fnd_message.set_name('IGS','IGS_UC_EXP_APP_COMPLETED');

1916: l_export_to_oss := 'COMP' ;
1917: l_app_choice_error_code := NULL ;
1918: l_ch_batch_id := NULL ;
1919: -- Write the error message to the Log file indicating the error occurred
1920: fnd_message.set_name('IGS','IGS_UC_EXP_APP_COMPLETED');
1921: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
1922: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
1923: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
1924: END IF;

Line 1921: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));

1917: l_app_choice_error_code := NULL ;
1918: l_ch_batch_id := NULL ;
1919: -- Write the error message to the Log file indicating the error occurred
1920: fnd_message.set_name('IGS','IGS_UC_EXP_APP_COMPLETED');
1921: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
1922: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
1923: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
1924: END IF;
1925:

Line 1922: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));

1918: l_ch_batch_id := NULL ;
1919: -- Write the error message to the Log file indicating the error occurred
1920: fnd_message.set_name('IGS','IGS_UC_EXP_APP_COMPLETED');
1921: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
1922: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
1923: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
1924: END IF;
1925:
1926: END IF; /* End of checking OSS Application Instnace system Offer Response status */

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

1919: -- Write the error message to the Log file indicating the error occurred
1920: fnd_message.set_name('IGS','IGS_UC_EXP_APP_COMPLETED');
1921: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
1922: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
1923: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
1924: END IF;
1925:
1926: END IF; /* End of checking OSS Application Instnace system Offer Response status */
1927:

Line 1936: fnd_message.set_name('IGS','IGS_UC_EXP_APP_COMPLETED');

1932: l_export_to_oss := 'COMP' ;
1933: l_app_choice_error_code := NULL ;
1934: l_ch_batch_id := NULL ;
1935: -- Write the error message to the Log file indicating the error occurred
1936: fnd_message.set_name('IGS','IGS_UC_EXP_APP_COMPLETED');
1937: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
1938: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
1939: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
1940:

Line 1937: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));

1933: l_app_choice_error_code := NULL ;
1934: l_ch_batch_id := NULL ;
1935: -- Write the error message to the Log file indicating the error occurred
1936: fnd_message.set_name('IGS','IGS_UC_EXP_APP_COMPLETED');
1937: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
1938: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
1939: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
1940:
1941: END IF; /* End of UCAS reply exported to OSS */

Line 1938: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));

1934: l_ch_batch_id := NULL ;
1935: -- Write the error message to the Log file indicating the error occurred
1936: fnd_message.set_name('IGS','IGS_UC_EXP_APP_COMPLETED');
1937: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
1938: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
1939: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
1940:
1941: END IF; /* End of UCAS reply exported to OSS */
1942:

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

1935: -- Write the error message to the Log file indicating the error occurred
1936: fnd_message.set_name('IGS','IGS_UC_EXP_APP_COMPLETED');
1937: fnd_message.set_token('APP_NO',TO_CHAR(cur_ucas_app_choice_rec.app_no));
1938: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_ucas_app_choice_rec.choice_no));
1939: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
1940:
1941: END IF; /* End of UCAS reply exported to OSS */
1942:
1943: --jchin - bug 3691277 and 3691250

Line 2021: fnd_message.set_name('IGS','IGS_UC_OFFRESP_IMP_PROC_LAUNCH');

2017: Then submit the request for 'Admissions Offer Response Import Process' */
2018: IF l_exp_reply_flag THEN
2019:
2020: -- Display the information message in the log file
2021: fnd_message.set_name('IGS','IGS_UC_OFFRESP_IMP_PROC_LAUNCH');
2022: fnd_message.set_token('REQ_ID',TO_CHAR(l_batch_id));
2023: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2024:
2025: -- Invoke the Admission Import Offer Response Process

Line 2022: fnd_message.set_token('REQ_ID',TO_CHAR(l_batch_id));

2018: IF l_exp_reply_flag THEN
2019:
2020: -- Display the information message in the log file
2021: fnd_message.set_name('IGS','IGS_UC_OFFRESP_IMP_PROC_LAUNCH');
2022: fnd_message.set_token('REQ_ID',TO_CHAR(l_batch_id));
2023: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2024:
2025: -- Invoke the Admission Import Offer Response Process
2026: BEGIN

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

2019:
2020: -- Display the information message in the log file
2021: fnd_message.set_name('IGS','IGS_UC_OFFRESP_IMP_PROC_LAUNCH');
2022: fnd_message.set_token('REQ_ID',TO_CHAR(l_batch_id));
2023: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2024:
2025: -- Invoke the Admission Import Offer Response Process
2026: BEGIN
2027:

Line 2082: fnd_message.set_name('IGS','IGS_UC_OFFRESP_IMP_ERR');

2078: -- If there are any errors in Offer Response import,
2079: -- update the Application Choice Record with error code 'ROO1'
2080: IF cur_reply_import_error%FOUND THEN
2081: -- log message in log file
2082: fnd_message.set_name('IGS','IGS_UC_OFFRESP_IMP_ERR');
2083: fnd_message.set_token('APP_NO',TO_CHAR(cur_rp_app_choice_rec.app_no));
2084: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_rp_app_choice_rec.choice_no));
2085: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2086:

Line 2083: fnd_message.set_token('APP_NO',TO_CHAR(cur_rp_app_choice_rec.app_no));

2079: -- update the Application Choice Record with error code 'ROO1'
2080: IF cur_reply_import_error%FOUND THEN
2081: -- log message in log file
2082: fnd_message.set_name('IGS','IGS_UC_OFFRESP_IMP_ERR');
2083: fnd_message.set_token('APP_NO',TO_CHAR(cur_rp_app_choice_rec.app_no));
2084: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_rp_app_choice_rec.choice_no));
2085: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2086:
2087: -- If the error was generated during the current run, then update the record with error code

Line 2084: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_rp_app_choice_rec.choice_no));

2080: IF cur_reply_import_error%FOUND THEN
2081: -- log message in log file
2082: fnd_message.set_name('IGS','IGS_UC_OFFRESP_IMP_ERR');
2083: fnd_message.set_token('APP_NO',TO_CHAR(cur_rp_app_choice_rec.app_no));
2084: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_rp_app_choice_rec.choice_no));
2085: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2086:
2087: -- If the error was generated during the current run, then update the record with error code
2088: IF cur_rp_app_choice_rec.batch_id IS NULL THEN

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

2081: -- log message in log file
2082: fnd_message.set_name('IGS','IGS_UC_OFFRESP_IMP_ERR');
2083: fnd_message.set_token('APP_NO',TO_CHAR(cur_rp_app_choice_rec.app_no));
2084: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_rp_app_choice_rec.choice_no));
2085: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2086:
2087: -- If the error was generated during the current run, then update the record with error code
2088: IF cur_rp_app_choice_rec.batch_id IS NULL THEN
2089: l_export_to_oss := cur_rp_app_choice_rec.export_to_oss_status ;

Line 2104: fnd_message.set_name('IGS','IGS_UC_EXP_APP_COMPLETED');

2100: l_export_to_oss := 'COMP' ;
2101: l_app_choice_error_code := NULL ;
2102: l_ch_batch_id := NULL ;
2103: -- Write the error message to the Log file indicating the error occurred
2104: fnd_message.set_name('IGS','IGS_UC_EXP_APP_COMPLETED');
2105: fnd_message.set_token('APP_NO',TO_CHAR(cur_rp_app_choice_rec.app_no));
2106: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_rp_app_choice_rec.choice_no));
2107: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2108: END IF;

Line 2105: fnd_message.set_token('APP_NO',TO_CHAR(cur_rp_app_choice_rec.app_no));

2101: l_app_choice_error_code := NULL ;
2102: l_ch_batch_id := NULL ;
2103: -- Write the error message to the Log file indicating the error occurred
2104: fnd_message.set_name('IGS','IGS_UC_EXP_APP_COMPLETED');
2105: fnd_message.set_token('APP_NO',TO_CHAR(cur_rp_app_choice_rec.app_no));
2106: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_rp_app_choice_rec.choice_no));
2107: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2108: END IF;
2109: CLOSE cur_reply_import_error;

Line 2106: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_rp_app_choice_rec.choice_no));

2102: l_ch_batch_id := NULL ;
2103: -- Write the error message to the Log file indicating the error occurred
2104: fnd_message.set_name('IGS','IGS_UC_EXP_APP_COMPLETED');
2105: fnd_message.set_token('APP_NO',TO_CHAR(cur_rp_app_choice_rec.app_no));
2106: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_rp_app_choice_rec.choice_no));
2107: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2108: END IF;
2109: CLOSE cur_reply_import_error;
2110: -- jchin - bug 3691277 and 3691250

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

2103: -- Write the error message to the Log file indicating the error occurred
2104: fnd_message.set_name('IGS','IGS_UC_EXP_APP_COMPLETED');
2105: fnd_message.set_token('APP_NO',TO_CHAR(cur_rp_app_choice_rec.app_no));
2106: fnd_message.set_token('CHOICE_NO',TO_CHAR(cur_rp_app_choice_rec.choice_no));
2107: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
2108: END IF;
2109: CLOSE cur_reply_import_error;
2110: -- jchin - bug 3691277 and 3691250
2111: END IF; /* End If for cur_unit_set_cd%FOUND */

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

2180: /******* End of processing the Offer Response exported Application Choices ********/
2181:
2182: EXCEPTION
2183: WHEN OTHERS THEN
2184: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
2185: fnd_message.set_token('NAME','IGS_UC_EXPORT_DECISION_REPLY.EXPORT_REPLY'||' - '||SQLERRM);
2186: igs_ge_msg_stack.add;
2187: App_Exception.Raise_Exception;
2188:

Line 2185: fnd_message.set_token('NAME','IGS_UC_EXPORT_DECISION_REPLY.EXPORT_REPLY'||' - '||SQLERRM);

2181:
2182: EXCEPTION
2183: WHEN OTHERS THEN
2184: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
2185: fnd_message.set_token('NAME','IGS_UC_EXPORT_DECISION_REPLY.EXPORT_REPLY'||' - '||SQLERRM);
2186: igs_ge_msg_stack.add;
2187: App_Exception.Raise_Exception;
2188:
2189: END export_reply ;