DBA Data[Home] [Help]

APPS.IGS_UC_EXPORT_DECISION_REPLY dependencies on FND_FILE

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 */