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_OR_INST_IMP_001 dependencies on FND_FILE

Line 20: -- 1. Logging mechanism introduced, FND_FILE.PUT_LINE replaced with methods in FND_LOG package

16: -- Modified the validation for INST_PRIORITY_CODE_ID, GOVT_INSTITUTION_CD, INST_CONTROL_TYPE to refer
17: -- the new lookups instead of the tables.
18: -- ssawhney 2nd jan No of updates reduced, performance tuning done, gather stats function used.
19: -- ssaleem 24-SEP-03 The following changes have been done for IGS.L
20: -- 1. Logging mechanism introduced, FND_FILE.PUT_LINE replaced with methods in FND_LOG package
21: -- log writer procedure modified for this purpose and package level variables declared, intialised
22: -- to control logging.
23: -- 2. Cursors that utilise variables in SELECT statements are replaced with cursor parameters
24: -- 3. Gather statistics done for IGS_OR_ADRUSGE_INT table

Line 280: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

276:
277: --
278: IF p_ds_match IS NULL AND p_numeric = 'N' THEN
279: FND_MESSAGE.Set_Name('IGS','IGS_OR_SIMPLE_ALT_ID');
280: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
281: simpleAltidcomp(p_batch_id,p_data_source,p_addr_usage,p_person_type);
282: ELSIF p_ds_match IS NOT NULL AND p_numeric = 'N' THEN
283: FND_MESSAGE.Set_Name('IGS','IGS_OR_EXACT_ALT_ID');
284: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

Line 284: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

280: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
281: simpleAltidcomp(p_batch_id,p_data_source,p_addr_usage,p_person_type);
282: ELSIF p_ds_match IS NOT NULL AND p_numeric = 'N' THEN
283: FND_MESSAGE.Set_Name('IGS','IGS_OR_EXACT_ALT_ID');
284: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
285: exactAltidcomp(p_batch_id,p_data_source,p_ds_match,p_addr_usage,p_person_type);
286: ELSIF p_ds_match IS NOT NULL AND p_numeric = 'Y' THEN
287: FND_MESSAGE.Set_Name('IGS','IGS_OR_NUMERIC_ALT_ID');
288: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

Line 288: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

284: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
285: exactAltidcomp(p_batch_id,p_data_source,p_ds_match,p_addr_usage,p_person_type);
286: ELSIF p_ds_match IS NOT NULL AND p_numeric = 'Y' THEN
287: FND_MESSAGE.Set_Name('IGS','IGS_OR_NUMERIC_ALT_ID');
288: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
289: numericAltidcomp(p_batch_id,p_data_source,p_ds_match,p_addr_usage,p_person_type);
290: ELSE
291: FND_MESSAGE.Set_Name('IGS','IGS_AD_INVALID_PARAM_COMB');
292: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

Line 292: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

288: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
289: numericAltidcomp(p_batch_id,p_data_source,p_ds_match,p_addr_usage,p_person_type);
290: ELSE
291: FND_MESSAGE.Set_Name('IGS','IGS_AD_INVALID_PARAM_COMB');
292: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
293: END IF;
294:
295: --Raise Bulk address process notification
296: IGS_PE_WF_GEN.ADDR_BULK_SYNCHRONIZATION(IGS_PE_WF_GEN.TI_ADDR_CHG_PERSONS);

Line 1672: IF l_cwlkinst_rec.inst_code IS NOT NULL THEN -- The Institution Code in the Crosswalk table not null fnd_file.put_line(fnd_file.log,'fould in dtl');

1668: IF l_Errind = 'N' THEN
1669:
1670: IF l_cwlkinst_rec.crosswalk_dtl_id IS NOT NULL THEN
1671:
1672: IF l_cwlkinst_rec.inst_code IS NOT NULL THEN -- The Institution Code in the Crosswalk table not null fnd_file.put_line(fnd_file.log,'fould in dtl');
1673:
1674: IF validate_inst_code(v_inst_rec.new_institution_cd,
1675: v_inst_rec.exst_institution_cd,
1676: l_cwlkinst_rec.inst_code,

Line 2446: FND_FILE.Put_Line(FND_FILE.Log,'');

2442: -- previous steps.
2443:
2444: DELETE FROM IGS_OR_INST_INT WHERE STATUS = '1';
2445:
2446: FND_FILE.Put_Line(FND_FILE.Log,'');
2447:
2448: FND_FILE.Put_Line(FND_FILE.Log,l_inst_rec_err_meaning);
2449: FND_FILE.Put_Line(FND_FILE.Log,'-------------------------------------------');
2450: FND_FILE.Put_Line(FND_FILE.Log,'');

Line 2448: FND_FILE.Put_Line(FND_FILE.Log,l_inst_rec_err_meaning);

2444: DELETE FROM IGS_OR_INST_INT WHERE STATUS = '1';
2445:
2446: FND_FILE.Put_Line(FND_FILE.Log,'');
2447:
2448: FND_FILE.Put_Line(FND_FILE.Log,l_inst_rec_err_meaning);
2449: FND_FILE.Put_Line(FND_FILE.Log,'-------------------------------------------');
2450: FND_FILE.Put_Line(FND_FILE.Log,'');
2451:
2452: FND_MESSAGE.Set_Name('IGS','IGS_OR_INST_IMP_HEADER');

Line 2449: FND_FILE.Put_Line(FND_FILE.Log,'-------------------------------------------');

2445:
2446: FND_FILE.Put_Line(FND_FILE.Log,'');
2447:
2448: FND_FILE.Put_Line(FND_FILE.Log,l_inst_rec_err_meaning);
2449: FND_FILE.Put_Line(FND_FILE.Log,'-------------------------------------------');
2450: FND_FILE.Put_Line(FND_FILE.Log,'');
2451:
2452: FND_MESSAGE.Set_Name('IGS','IGS_OR_INST_IMP_HEADER');
2453: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

Line 2450: FND_FILE.Put_Line(FND_FILE.Log,'');

2446: FND_FILE.Put_Line(FND_FILE.Log,'');
2447:
2448: FND_FILE.Put_Line(FND_FILE.Log,l_inst_rec_err_meaning);
2449: FND_FILE.Put_Line(FND_FILE.Log,'-------------------------------------------');
2450: FND_FILE.Put_Line(FND_FILE.Log,'');
2451:
2452: FND_MESSAGE.Set_Name('IGS','IGS_OR_INST_IMP_HEADER');
2453: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2454: FND_FILE.Put_Line(FND_FILE.Log,'-------------------------------------------');

Line 2453: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

2449: FND_FILE.Put_Line(FND_FILE.Log,'-------------------------------------------');
2450: FND_FILE.Put_Line(FND_FILE.Log,'');
2451:
2452: FND_MESSAGE.Set_Name('IGS','IGS_OR_INST_IMP_HEADER');
2453: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2454: FND_FILE.Put_Line(FND_FILE.Log,'-------------------------------------------');
2455:
2456: FOR l_inst_err_rec IN log_inst_err_cur(p_batch_id,'3','4') LOOP
2457: FND_FILE.Put_Line(FND_FILE.Log,l_inst_err_rec.EREC);

Line 2454: FND_FILE.Put_Line(FND_FILE.Log,'-------------------------------------------');

2450: FND_FILE.Put_Line(FND_FILE.Log,'');
2451:
2452: FND_MESSAGE.Set_Name('IGS','IGS_OR_INST_IMP_HEADER');
2453: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2454: FND_FILE.Put_Line(FND_FILE.Log,'-------------------------------------------');
2455:
2456: FOR l_inst_err_rec IN log_inst_err_cur(p_batch_id,'3','4') LOOP
2457: FND_FILE.Put_Line(FND_FILE.Log,l_inst_err_rec.EREC);
2458: END LOOP;

Line 2457: FND_FILE.Put_Line(FND_FILE.Log,l_inst_err_rec.EREC);

2453: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2454: FND_FILE.Put_Line(FND_FILE.Log,'-------------------------------------------');
2455:
2456: FOR l_inst_err_rec IN log_inst_err_cur(p_batch_id,'3','4') LOOP
2457: FND_FILE.Put_Line(FND_FILE.Log,l_inst_err_rec.EREC);
2458: END LOOP;
2459: FND_FILE.Put_Line(FND_FILE.Log,'');
2460:
2461: FND_FILE.Put_Line(FND_FILE.Log,l_inst_meaning);

Line 2459: FND_FILE.Put_Line(FND_FILE.Log,'');

2455:
2456: FOR l_inst_err_rec IN log_inst_err_cur(p_batch_id,'3','4') LOOP
2457: FND_FILE.Put_Line(FND_FILE.Log,l_inst_err_rec.EREC);
2458: END LOOP;
2459: FND_FILE.Put_Line(FND_FILE.Log,'');
2460:
2461: FND_FILE.Put_Line(FND_FILE.Log,l_inst_meaning);
2462: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_PRC');
2463: FND_MESSAGE.Set_Token('RCOUNT',l_tot_inst);

Line 2461: FND_FILE.Put_Line(FND_FILE.Log,l_inst_meaning);

2457: FND_FILE.Put_Line(FND_FILE.Log,l_inst_err_rec.EREC);
2458: END LOOP;
2459: FND_FILE.Put_Line(FND_FILE.Log,'');
2460:
2461: FND_FILE.Put_Line(FND_FILE.Log,l_inst_meaning);
2462: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_PRC');
2463: FND_MESSAGE.Set_Token('RCOUNT',l_tot_inst);
2464: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2465:

Line 2464: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

2460:
2461: FND_FILE.Put_Line(FND_FILE.Log,l_inst_meaning);
2462: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_PRC');
2463: FND_MESSAGE.Set_Token('RCOUNT',l_tot_inst);
2464: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2465:
2466: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_SUCC');
2467: FND_MESSAGE.Set_Token('RCOUNT',l_comp_inst);
2468: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

Line 2468: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

2464: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2465:
2466: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_SUCC');
2467: FND_MESSAGE.Set_Token('RCOUNT',l_comp_inst);
2468: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2469:
2470: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_FAIL');
2471: FND_MESSAGE.Set_Token('RCOUNT',l_err_inst);
2472: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

Line 2472: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

2468: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2469:
2470: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_FAIL');
2471: FND_MESSAGE.Set_Token('RCOUNT',l_err_inst);
2472: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2473:
2474: FND_MESSAGE.Set_Name('IGS','IGS_OR_TOT_REC_WARN');
2475: FND_MESSAGE.Set_Token('RCOUNT',l_warn_inst);
2476: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

Line 2476: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

2472: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2473:
2474: FND_MESSAGE.Set_Name('IGS','IGS_OR_TOT_REC_WARN');
2475: FND_MESSAGE.Set_Token('RCOUNT',l_warn_inst);
2476: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2477: FND_FILE.Put_Line(FND_FILE.Log,'');
2478:
2479: FND_FILE.Put_Line(FND_FILE.Log,l_inst_note_meaning);
2480: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_PRC');

Line 2477: FND_FILE.Put_Line(FND_FILE.Log,'');

2473:
2474: FND_MESSAGE.Set_Name('IGS','IGS_OR_TOT_REC_WARN');
2475: FND_MESSAGE.Set_Token('RCOUNT',l_warn_inst);
2476: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2477: FND_FILE.Put_Line(FND_FILE.Log,'');
2478:
2479: FND_FILE.Put_Line(FND_FILE.Log,l_inst_note_meaning);
2480: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_PRC');
2481: FND_MESSAGE.Set_Token('RCOUNT',l_tot_inst_note);

Line 2479: FND_FILE.Put_Line(FND_FILE.Log,l_inst_note_meaning);

2475: FND_MESSAGE.Set_Token('RCOUNT',l_warn_inst);
2476: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2477: FND_FILE.Put_Line(FND_FILE.Log,'');
2478:
2479: FND_FILE.Put_Line(FND_FILE.Log,l_inst_note_meaning);
2480: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_PRC');
2481: FND_MESSAGE.Set_Token('RCOUNT',l_tot_inst_note);
2482: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2483:

Line 2482: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

2478:
2479: FND_FILE.Put_Line(FND_FILE.Log,l_inst_note_meaning);
2480: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_PRC');
2481: FND_MESSAGE.Set_Token('RCOUNT',l_tot_inst_note);
2482: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2483:
2484: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_SUCC');
2485: FND_MESSAGE.Set_Token('RCOUNT',l_comp_inst_note);
2486: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

Line 2486: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

2482: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2483:
2484: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_SUCC');
2485: FND_MESSAGE.Set_Token('RCOUNT',l_comp_inst_note);
2486: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2487:
2488: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_FAIL');
2489: FND_MESSAGE.Set_Token('RCOUNT',l_err_inst_note);
2490: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

Line 2490: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

2486: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2487:
2488: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_FAIL');
2489: FND_MESSAGE.Set_Token('RCOUNT',l_err_inst_note);
2490: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2491:
2492: FND_MESSAGE.Set_Name('IGS','IGS_OR_TOT_REC_WARN');
2493: FND_MESSAGE.Set_Token('RCOUNT',l_warn_inst_note);
2494: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

Line 2494: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

2490: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2491:
2492: FND_MESSAGE.Set_Name('IGS','IGS_OR_TOT_REC_WARN');
2493: FND_MESSAGE.Set_Token('RCOUNT',l_warn_inst_note);
2494: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2495: FND_FILE.Put_Line(FND_FILE.Log,'');
2496:
2497: FND_FILE.Put_Line(FND_FILE.Log,l_inst_stat_meaning);
2498: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_PRC');

Line 2495: FND_FILE.Put_Line(FND_FILE.Log,'');

2491:
2492: FND_MESSAGE.Set_Name('IGS','IGS_OR_TOT_REC_WARN');
2493: FND_MESSAGE.Set_Token('RCOUNT',l_warn_inst_note);
2494: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2495: FND_FILE.Put_Line(FND_FILE.Log,'');
2496:
2497: FND_FILE.Put_Line(FND_FILE.Log,l_inst_stat_meaning);
2498: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_PRC');
2499: FND_MESSAGE.Set_Token('RCOUNT',l_tot_inst_stat);

Line 2497: FND_FILE.Put_Line(FND_FILE.Log,l_inst_stat_meaning);

2493: FND_MESSAGE.Set_Token('RCOUNT',l_warn_inst_note);
2494: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2495: FND_FILE.Put_Line(FND_FILE.Log,'');
2496:
2497: FND_FILE.Put_Line(FND_FILE.Log,l_inst_stat_meaning);
2498: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_PRC');
2499: FND_MESSAGE.Set_Token('RCOUNT',l_tot_inst_stat);
2500: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2501:

Line 2500: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

2496:
2497: FND_FILE.Put_Line(FND_FILE.Log,l_inst_stat_meaning);
2498: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_PRC');
2499: FND_MESSAGE.Set_Token('RCOUNT',l_tot_inst_stat);
2500: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2501:
2502: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_SUCC');
2503: FND_MESSAGE.Set_Token('RCOUNT',l_comp_inst_stat);
2504: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

Line 2504: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

2500: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2501:
2502: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_SUCC');
2503: FND_MESSAGE.Set_Token('RCOUNT',l_comp_inst_stat);
2504: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2505:
2506: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_FAIL');
2507: FND_MESSAGE.Set_Token('RCOUNT',l_err_inst_stat);
2508: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

Line 2508: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

2504: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2505:
2506: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_FAIL');
2507: FND_MESSAGE.Set_Token('RCOUNT',l_err_inst_stat);
2508: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2509:
2510: FND_MESSAGE.Set_Name('IGS','IGS_OR_TOT_REC_WARN');
2511: FND_MESSAGE.Set_Token('RCOUNT',l_warn_inst_stat);
2512: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

Line 2512: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

2508: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2509:
2510: FND_MESSAGE.Set_Name('IGS','IGS_OR_TOT_REC_WARN');
2511: FND_MESSAGE.Set_Token('RCOUNT',l_warn_inst_stat);
2512: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2513: FND_FILE.Put_Line(FND_FILE.Log,'');
2514:
2515: FND_FILE.Put_Line(FND_FILE.Log,l_inst_stat_dtl_meaning);
2516: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_PRC');

Line 2513: FND_FILE.Put_Line(FND_FILE.Log,'');

2509:
2510: FND_MESSAGE.Set_Name('IGS','IGS_OR_TOT_REC_WARN');
2511: FND_MESSAGE.Set_Token('RCOUNT',l_warn_inst_stat);
2512: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2513: FND_FILE.Put_Line(FND_FILE.Log,'');
2514:
2515: FND_FILE.Put_Line(FND_FILE.Log,l_inst_stat_dtl_meaning);
2516: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_PRC');
2517: FND_MESSAGE.Set_Token('RCOUNT',l_tot_inst_sdtl);

Line 2515: FND_FILE.Put_Line(FND_FILE.Log,l_inst_stat_dtl_meaning);

2511: FND_MESSAGE.Set_Token('RCOUNT',l_warn_inst_stat);
2512: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2513: FND_FILE.Put_Line(FND_FILE.Log,'');
2514:
2515: FND_FILE.Put_Line(FND_FILE.Log,l_inst_stat_dtl_meaning);
2516: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_PRC');
2517: FND_MESSAGE.Set_Token('RCOUNT',l_tot_inst_sdtl);
2518: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2519:

Line 2518: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

2514:
2515: FND_FILE.Put_Line(FND_FILE.Log,l_inst_stat_dtl_meaning);
2516: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_PRC');
2517: FND_MESSAGE.Set_Token('RCOUNT',l_tot_inst_sdtl);
2518: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2519:
2520: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_SUCC');
2521: FND_MESSAGE.Set_Token('RCOUNT',l_comp_inst_sdtl);
2522: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

Line 2522: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

2518: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2519:
2520: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_SUCC');
2521: FND_MESSAGE.Set_Token('RCOUNT',l_comp_inst_sdtl);
2522: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2523:
2524: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_FAIL');
2525: FND_MESSAGE.Set_Token('RCOUNT',l_err_inst_sdtl);
2526: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

Line 2526: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

2522: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2523:
2524: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_FAIL');
2525: FND_MESSAGE.Set_Token('RCOUNT',l_err_inst_sdtl);
2526: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2527:
2528: FND_MESSAGE.Set_Name('IGS','IGS_OR_TOT_REC_WARN');
2529: FND_MESSAGE.Set_Token('RCOUNT',l_warn_inst_sdtl);
2530: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

Line 2530: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

2526: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2527:
2528: FND_MESSAGE.Set_Name('IGS','IGS_OR_TOT_REC_WARN');
2529: FND_MESSAGE.Set_Token('RCOUNT',l_warn_inst_sdtl);
2530: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2531: FND_FILE.Put_Line(FND_FILE.Log,'');
2532:
2533: FND_FILE.Put_Line(FND_FILE.Log,l_inst_cont_meaning);
2534: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_PRC');

Line 2531: FND_FILE.Put_Line(FND_FILE.Log,'');

2527:
2528: FND_MESSAGE.Set_Name('IGS','IGS_OR_TOT_REC_WARN');
2529: FND_MESSAGE.Set_Token('RCOUNT',l_warn_inst_sdtl);
2530: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2531: FND_FILE.Put_Line(FND_FILE.Log,'');
2532:
2533: FND_FILE.Put_Line(FND_FILE.Log,l_inst_cont_meaning);
2534: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_PRC');
2535: FND_MESSAGE.Set_Token('RCOUNT',l_tot_inst_con);

Line 2533: FND_FILE.Put_Line(FND_FILE.Log,l_inst_cont_meaning);

2529: FND_MESSAGE.Set_Token('RCOUNT',l_warn_inst_sdtl);
2530: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2531: FND_FILE.Put_Line(FND_FILE.Log,'');
2532:
2533: FND_FILE.Put_Line(FND_FILE.Log,l_inst_cont_meaning);
2534: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_PRC');
2535: FND_MESSAGE.Set_Token('RCOUNT',l_tot_inst_con);
2536: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2537:

Line 2536: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

2532:
2533: FND_FILE.Put_Line(FND_FILE.Log,l_inst_cont_meaning);
2534: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_PRC');
2535: FND_MESSAGE.Set_Token('RCOUNT',l_tot_inst_con);
2536: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2537:
2538: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_SUCC');
2539: FND_MESSAGE.Set_Token('RCOUNT',l_comp_inst_con);
2540: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

Line 2540: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

2536: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2537:
2538: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_SUCC');
2539: FND_MESSAGE.Set_Token('RCOUNT',l_comp_inst_con);
2540: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2541:
2542: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_FAIL');
2543: FND_MESSAGE.Set_Token('RCOUNT',l_err_inst_con);
2544: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

Line 2544: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

2540: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2541:
2542: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_FAIL');
2543: FND_MESSAGE.Set_Token('RCOUNT',l_err_inst_con);
2544: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2545:
2546: FND_MESSAGE.Set_Name('IGS','IGS_OR_TOT_REC_WARN');
2547: FND_MESSAGE.Set_Token('RCOUNT',l_warn_inst_con);
2548: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

Line 2548: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

2544: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2545:
2546: FND_MESSAGE.Set_Name('IGS','IGS_OR_TOT_REC_WARN');
2547: FND_MESSAGE.Set_Token('RCOUNT',l_warn_inst_con);
2548: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2549: FND_FILE.Put_Line(FND_FILE.Log,'');
2550:
2551: FND_FILE.Put_Line(FND_FILE.Log,l_inst_cont_phone_meaning);
2552: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_PRC');

Line 2549: FND_FILE.Put_Line(FND_FILE.Log,'');

2545:
2546: FND_MESSAGE.Set_Name('IGS','IGS_OR_TOT_REC_WARN');
2547: FND_MESSAGE.Set_Token('RCOUNT',l_warn_inst_con);
2548: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2549: FND_FILE.Put_Line(FND_FILE.Log,'');
2550:
2551: FND_FILE.Put_Line(FND_FILE.Log,l_inst_cont_phone_meaning);
2552: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_PRC');
2553: FND_MESSAGE.Set_Token('RCOUNT',l_tot_inst_cphn);

Line 2551: FND_FILE.Put_Line(FND_FILE.Log,l_inst_cont_phone_meaning);

2547: FND_MESSAGE.Set_Token('RCOUNT',l_warn_inst_con);
2548: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2549: FND_FILE.Put_Line(FND_FILE.Log,'');
2550:
2551: FND_FILE.Put_Line(FND_FILE.Log,l_inst_cont_phone_meaning);
2552: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_PRC');
2553: FND_MESSAGE.Set_Token('RCOUNT',l_tot_inst_cphn);
2554: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2555:

Line 2554: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

2550:
2551: FND_FILE.Put_Line(FND_FILE.Log,l_inst_cont_phone_meaning);
2552: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_PRC');
2553: FND_MESSAGE.Set_Token('RCOUNT',l_tot_inst_cphn);
2554: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2555:
2556: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_SUCC');
2557: FND_MESSAGE.Set_Token('RCOUNT',l_comp_inst_cphn);
2558: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

Line 2558: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

2554: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2555:
2556: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_SUCC');
2557: FND_MESSAGE.Set_Token('RCOUNT',l_comp_inst_cphn);
2558: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2559:
2560: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_FAIL');
2561: FND_MESSAGE.Set_Token('RCOUNT',l_err_inst_cphn);
2562: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

Line 2562: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

2558: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2559:
2560: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_FAIL');
2561: FND_MESSAGE.Set_Token('RCOUNT',l_err_inst_cphn);
2562: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2563:
2564: FND_MESSAGE.Set_Name('IGS','IGS_OR_TOT_REC_WARN');
2565: FND_MESSAGE.Set_Token('RCOUNT',l_warn_inst_cphn);
2566: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

Line 2566: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

2562: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2563:
2564: FND_MESSAGE.Set_Name('IGS','IGS_OR_TOT_REC_WARN');
2565: FND_MESSAGE.Set_Token('RCOUNT',l_warn_inst_cphn);
2566: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2567: FND_FILE.Put_Line(FND_FILE.Log,'');
2568:
2569: FND_FILE.Put_Line(FND_FILE.Log,l_inst_addr_meaning);
2570: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_PRC');

Line 2567: FND_FILE.Put_Line(FND_FILE.Log,'');

2563:
2564: FND_MESSAGE.Set_Name('IGS','IGS_OR_TOT_REC_WARN');
2565: FND_MESSAGE.Set_Token('RCOUNT',l_warn_inst_cphn);
2566: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2567: FND_FILE.Put_Line(FND_FILE.Log,'');
2568:
2569: FND_FILE.Put_Line(FND_FILE.Log,l_inst_addr_meaning);
2570: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_PRC');
2571: FND_MESSAGE.Set_Token('RCOUNT',l_tot_inst_adr);

Line 2569: FND_FILE.Put_Line(FND_FILE.Log,l_inst_addr_meaning);

2565: FND_MESSAGE.Set_Token('RCOUNT',l_warn_inst_cphn);
2566: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2567: FND_FILE.Put_Line(FND_FILE.Log,'');
2568:
2569: FND_FILE.Put_Line(FND_FILE.Log,l_inst_addr_meaning);
2570: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_PRC');
2571: FND_MESSAGE.Set_Token('RCOUNT',l_tot_inst_adr);
2572: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2573:

Line 2572: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

2568:
2569: FND_FILE.Put_Line(FND_FILE.Log,l_inst_addr_meaning);
2570: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_PRC');
2571: FND_MESSAGE.Set_Token('RCOUNT',l_tot_inst_adr);
2572: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2573:
2574: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_SUCC');
2575: FND_MESSAGE.Set_Token('RCOUNT',l_comp_inst_adr);
2576: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

Line 2576: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

2572: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2573:
2574: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_SUCC');
2575: FND_MESSAGE.Set_Token('RCOUNT',l_comp_inst_adr);
2576: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2577:
2578: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_FAIL');
2579: FND_MESSAGE.Set_Token('RCOUNT',l_err_inst_adr);
2580: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

Line 2580: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

2576: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2577:
2578: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_FAIL');
2579: FND_MESSAGE.Set_Token('RCOUNT',l_err_inst_adr);
2580: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2581:
2582: FND_MESSAGE.Set_Name('IGS','IGS_OR_TOT_REC_WARN');
2583: FND_MESSAGE.Set_Token('RCOUNT',l_warn_inst_adr);
2584: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

Line 2584: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

2580: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2581:
2582: FND_MESSAGE.Set_Name('IGS','IGS_OR_TOT_REC_WARN');
2583: FND_MESSAGE.Set_Token('RCOUNT',l_warn_inst_adr);
2584: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2585: FND_FILE.Put_Line(FND_FILE.Log,'');
2586:
2587: FND_FILE.Put_Line(FND_FILE.Log,l_inst_addr_usage_meaning);
2588: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_PRC');

Line 2585: FND_FILE.Put_Line(FND_FILE.Log,'');

2581:
2582: FND_MESSAGE.Set_Name('IGS','IGS_OR_TOT_REC_WARN');
2583: FND_MESSAGE.Set_Token('RCOUNT',l_warn_inst_adr);
2584: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2585: FND_FILE.Put_Line(FND_FILE.Log,'');
2586:
2587: FND_FILE.Put_Line(FND_FILE.Log,l_inst_addr_usage_meaning);
2588: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_PRC');
2589: FND_MESSAGE.Set_Token('RCOUNT',l_tot_inst_adru);

Line 2587: FND_FILE.Put_Line(FND_FILE.Log,l_inst_addr_usage_meaning);

2583: FND_MESSAGE.Set_Token('RCOUNT',l_warn_inst_adr);
2584: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2585: FND_FILE.Put_Line(FND_FILE.Log,'');
2586:
2587: FND_FILE.Put_Line(FND_FILE.Log,l_inst_addr_usage_meaning);
2588: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_PRC');
2589: FND_MESSAGE.Set_Token('RCOUNT',l_tot_inst_adru);
2590: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2591:

Line 2590: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

2586:
2587: FND_FILE.Put_Line(FND_FILE.Log,l_inst_addr_usage_meaning);
2588: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_PRC');
2589: FND_MESSAGE.Set_Token('RCOUNT',l_tot_inst_adru);
2590: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2591:
2592: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_SUCC');
2593: FND_MESSAGE.Set_Token('RCOUNT',l_comp_inst_adru);
2594: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

Line 2594: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

2590: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2591:
2592: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_SUCC');
2593: FND_MESSAGE.Set_Token('RCOUNT',l_comp_inst_adru);
2594: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2595:
2596: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_FAIL');
2597: FND_MESSAGE.Set_Token('RCOUNT',l_err_inst_adru);
2598: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

Line 2598: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

2594: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2595:
2596: FND_MESSAGE.Set_Name('IGS','IGS_AD_TOT_REC_FAIL');
2597: FND_MESSAGE.Set_Token('RCOUNT',l_err_inst_adru);
2598: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2599:
2600: FND_MESSAGE.Set_Name('IGS','IGS_OR_TOT_REC_WARN');
2601: FND_MESSAGE.Set_Token('RCOUNT',l_warn_inst_adru);
2602: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

Line 2602: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

2598: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2599:
2600: FND_MESSAGE.Set_Name('IGS','IGS_OR_TOT_REC_WARN');
2601: FND_MESSAGE.Set_Token('RCOUNT',l_warn_inst_adru);
2602: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2603: FND_FILE.Put_Line(FND_FILE.Log,'');
2604:
2605: EXCEPTION
2606: WHEN OTHERS THEN

Line 2603: FND_FILE.Put_Line(FND_FILE.Log,'');

2599:
2600: FND_MESSAGE.Set_Name('IGS','IGS_OR_TOT_REC_WARN');
2601: FND_MESSAGE.Set_Token('RCOUNT',l_warn_inst_adru);
2602: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
2603: FND_FILE.Put_Line(FND_FILE.Log,'');
2604:
2605: EXCEPTION
2606: WHEN OTHERS THEN
2607: IF gb_write_exception_log1 THEN