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_FILE

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 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 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 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 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 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 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 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 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 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 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 1833: fnd_file.put_line(fnd_file.LOG, SQLERRM);

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' ;
1837: l_ch_batch_id := NULL;

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 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 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 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 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 2437: fnd_file.put_line( fnd_file.LOG ,' ');

2433: IF c_ap_ch%FOUND AND l_imp_batch_id IS NOT NULL THEN
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 ,'-----------------------------------');

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 2441: fnd_file.put_line( fnd_file.LOG ,'-----------------------------------');

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);
2445:

Line 2450: fnd_file.put_line( fnd_file.LOG ,' ');

2446: END IF ;
2447: CLOSE c_ap_ch ;
2448:
2449: -- Insert space in log file
2450: fnd_file.put_line( fnd_file.LOG ,' ');
2451:
2452: -- check if the application import has been successful for all application choices with status AP
2453: FOR c_ap_ch_rec IN c_ap_ch LOOP
2454:

Line 2463: fnd_file.put_line( fnd_file.LOG ,' ');

2459: c_ap_ch_rec.app_no, c_ap_ch_rec.choice_no);
2460: FETCH c_appl_int INTO c_appl_int_rec ;
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) ;

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 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 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 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 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 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 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 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 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 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 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 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 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 2870: fnd_file.put_line( fnd_file.LOG ,' ');

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

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 2873: fnd_file.put_line( fnd_file.LOG ,'-----------------------------------');

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:
2877: -- Call the sub process to create new application/instance or update the existing admissionapplication

Line 2879: fnd_file.put_line( fnd_file.LOG ,' ');

2875: obsolete_applications( p_app_no, p_choice_no) ;
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:

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 2882: fnd_file.put_line( fnd_file.LOG ,'-----------------------------------');

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:
2886: -- Call the process to import the UCAS decision field into oss outcome status field

Line 2888: fnd_file.put_line( fnd_file.LOG ,' ');

2884: export_applications( p_app_no, p_choice_no) ;
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:

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 2891: fnd_file.put_line( fnd_file.LOG ,'-----------------------------------');

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:
2895: -- Call the process to import the UCAS Reply field into oss offer response status field

Line 2897: fnd_file.put_line( fnd_file.LOG ,' ');

2893: igs_uc_export_decision_reply.export_decision( p_app_no, p_choice_no) ;
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:

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 2900: fnd_file.put_line( fnd_file.LOG ,'-----------------------------------');

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:
2904: -- log message that the Export applications to oss process has completed

Line 2905: fnd_file.put_line( fnd_file.LOG ,' ');

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

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 2908: fnd_file.put_line( fnd_file.LOG ,'-----------------------------------');

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 ;
2912: l_rep_request_id := Fnd_Request.Submit_Request

Line 2935: fnd_file.put_line( fnd_file.LOG ,' ');

2931: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
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

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