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.IGF_SP_AWARD dependencies on FND_FILE

Line 256: fnd_file.put_line(fnd_file.log, p_v_parm_type || ' : ' || p_v_parm_code );

252: Who When What
253: (reverse chronological order - newest change first)
254: ----------------------------------------------------------------------------*/
255: BEGIN
256: fnd_file.put_line(fnd_file.log, p_v_parm_type || ' : ' || p_v_parm_code );
257: END log_parameters;
258:
259:
260: FUNCTION get_person_number (p_person_id igs_pe_person.person_id%TYPE)

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

565: p_message_name => l_v_message_name)) THEN
566: -- If there was any error in retrieving the calendar info, return 0
567: IF l_v_message_name IS NOT NULL THEN
568: fnd_message.set_name('IGS',l_v_message_name);
569: fnd_file.put_line(fnd_file.log,fnd_message.get);
570: RETURN 0;
571: END IF;
572: END IF;
573:

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

1103: -- No disb gross amount
1104: -- log the message only once
1105: log_parameters(g_v_disb_fee_class,igs_fi_gen_gl.get_lkp_meaning('FEE_CLASS',rec_std_fc.fee_class));
1106: fnd_message.set_name('IGF','IGF_SP_ELGB_FAIL');
1107: fnd_file.put_line(fnd_file.log,fnd_message.get);
1108: ELSE
1109: g_b_msg_logged := TRUE;
1110: l_n_cnt := NVL(l_n_cnt,0) + 1;
1111: g_rowid := NULL;

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

1161:
1162: -- Log Message only once and when the Fee Class Details are defined
1163: IF l_n_cnt = 1 THEN
1164: fnd_message.set_name('IGF','IGF_SP_CREATE_AWARD');
1165: fnd_file.put_line(fnd_file.log,fnd_message.get);
1166: log_parameters(g_v_award_id,l_award_id);
1167: END IF;
1168:
1169: fnd_message.set_name('IGF','IGF_SP_CREATE_DISB');

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

1167: END IF;
1168:
1169: fnd_message.set_name('IGF','IGF_SP_CREATE_DISB');
1170: fnd_message.set_token('DISB_TYPE',lookup_desc('IGF_DB_TRANS_TYPE',p_award_type));
1171: fnd_file.put_line(fnd_file.log,fnd_message.get);
1172:
1173: log_parameters(g_v_disb_fee_class,igs_fi_gen_gl.get_lkp_meaning('FEE_CLASS',rec_std_fc.fee_class));
1174: log_parameters(g_v_disb_amount,l_disb_gross_amt);
1175:

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

1254: x_publish_in_ss_flag => 'N'
1255: );
1256:
1257: fnd_message.set_name('IGF','IGF_SP_CREATE_AWARD');
1258: fnd_file.put_line(fnd_file.log,fnd_message.get);
1259: log_parameters(g_v_award_id,l_award_id);
1260:
1261: l_disb_num := get_disb_num (l_award_id);
1262: g_rowid := NULL;

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

1310: );
1311:
1312: fnd_message.set_name('IGF','IGF_SP_CREATE_DISB');
1313: fnd_message.set_token('DISB_TYPE',lookup_desc('IGF_DB_TRANS_TYPE',p_award_type));
1314: fnd_file.put_line(fnd_file.log,fnd_message.get);
1315: log_parameters(g_v_disb_fee_class,NULL);
1316: log_parameters(g_v_disb_amount,l_n_tot_spns_amt);
1317: log_parameters(g_v_award_amount,l_n_tot_spns_amt);
1318: -- create disb detail adjustment

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

1463: g_b_msg_logged := TRUE;
1464: END IF;
1465:
1466: fnd_message.set_name('IGF','IGF_SP_PLN_AWD_CNV_ACT_AWD');
1467: fnd_file.put_line(fnd_file.log,fnd_message.get);
1468: -- make trans type P to A
1469: igf_aw_awd_disb_pkg.update_row (x_rowid => rec_aw_awd_disb.row_id ,
1470: x_award_id => rec_aw_awd_disb.award_id ,
1471: x_disb_num => rec_aw_awd_disb.disb_num ,

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

1522: IF g_b_msg_logged THEN
1523: log_parameters(g_v_award_amount,get_award_amount(l_award_id));
1524: ELSE
1525: fnd_message.set_name('IGF','IGF_SP_AWD_NOT_UPDATED');
1526: fnd_file.put_line(fnd_file.log, fnd_message.get);
1527: log_parameters(g_v_award_id,l_award_id);
1528: END IF;
1529: ELSIF l_manual_update = 'N' AND p_n_total_spnsr_amt IS NOT NULL AND p_award_type = 'A' THEN
1530: -- When invoked in the Actual Mode then get all the Planned Disbursement Records and check if the

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

1536: p_ld_cal_type => p_ld_cal_type,
1537: p_ld_sequence_number => p_ld_sequence_number ) THEN
1538: log_parameters(g_v_disb_fee_class,NULL);
1539: fnd_message.set_name('IGF','IGF_SP_ELGB_FAIL');
1540: fnd_file.put_line(fnd_file.log,fnd_message.get);
1541: ELSE
1542: log_parameters(g_v_award_id,l_award_id);
1543:
1544: -- Fetch the Disbursement Amount using the following function.

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

1553: -- the award type is A
1554: FOR rec_aw_awd_disb IN c_aw_awd_disb (l_award_id,NULL,'P')
1555: LOOP
1556: fnd_message.set_name('IGF','IGF_SP_PLN_AWD_CNV_ACT_AWD');
1557: fnd_file.put_line(fnd_file.log,fnd_message.get);
1558: -- make trans type P to A
1559: igf_aw_awd_disb_pkg.update_row (x_rowid => rec_aw_awd_disb.row_id ,
1560: x_award_id => rec_aw_awd_disb.award_id ,
1561: x_disb_num => rec_aw_awd_disb.disb_num ,

Line 1918: fnd_file.put_line(fnd_file.log,l_v_upd_msg_text);

1914: -- If the award is updated then the message needs to be logged in the log file first
1915: -- then the Award ID needs to be logged
1916: -- Once the Award ID is logged, then the messages from the table needs to be logged in the log file
1917: IF l_v_upd_msg_text IS NOT NULL THEN
1918: fnd_file.put_line(fnd_file.log,l_v_upd_msg_text);
1919: i := i+1;
1920: l_v_msg(i) := g_v_ext_award_amount||' : '|| l_n_before_awd_amt;
1921: i := i+1;
1922: l_v_msg(i) := g_v_upd_award_amount||' : '|| get_award_amount(l_award_id);

Line 1944: fnd_file.put_line(fnd_file.log,l_v_msg(i));

1940: IF l_v_msg.COUNT > 0 THEN
1941: FOR i IN l_v_msg.FIRST .. l_v_msg.LAST LOOP
1942: IF l_v_msg.EXISTS(i) THEN
1943: IF l_v_msg(i) IS NOT NULL THEN
1944: fnd_file.put_line(fnd_file.log,l_v_msg(i));
1945: END IF;
1946: END IF;
1947: END LOOP;
1948: -- Once the messages are logged clear the table contents

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

1948: -- Once the messages are logged clear the table contents
1949: l_v_msg := l_v_msg_null;
1950: ELSE
1951: fnd_message.set_name('IGF','IGF_SP_AWD_NOT_UPDATED');
1952: fnd_file.put_line(fnd_file.log, fnd_message.get);
1953: log_parameters(g_v_award_id,l_award_id);
1954: END IF;
1955: ELSE
1956: fnd_message.set_name('IGF','IGF_SP_AWD_NOT_UPDATED');

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

1953: log_parameters(g_v_award_id,l_award_id);
1954: END IF;
1955: ELSE
1956: fnd_message.set_name('IGF','IGF_SP_AWD_NOT_UPDATED');
1957: fnd_file.put_line(fnd_file.log, fnd_message.get);
1958: log_parameters(g_v_award_id,l_award_id);
1959: END IF;-- check for manual update
1960: END LOOP;
1961: CLOSE c_manual_update;

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

1969: p_ld_cal_type,
1970: p_ld_sequence_number) THEN
1971: log_parameters(g_v_disb_fee_class,NULL);
1972: fnd_message.set_name('IGF','IGF_SP_ELGB_FAIL');
1973: fnd_file.put_line(fnd_file.log,fnd_message.get);
1974: ELSE
1975: create_aw_award (p_fund_id => p_fund_id,
1976: p_base_id => p_base_id,
1977: p_ld_cal_type => p_ld_cal_type,

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

2104: rec_sp_std_dtls.ld_cal_type,
2105: rec_sp_std_dtls.ld_sequence_number) THEN
2106: log_parameters(g_v_disb_fee_class,NULL);
2107: fnd_message.set_name('IGF','IGF_SP_ELGB_FAIL');
2108: fnd_file.put_line(fnd_file.log,fnd_message.get);
2109: fnd_file.put_line(fnd_file.log, RPAD('-',77,'-'));
2110: EXIT;
2111: ELSE
2112: loop_thru_spnsr_dtl_pvt(p_person_id => rec_sp_std_dtls.person_id,

Line 2109: fnd_file.put_line(fnd_file.log, RPAD('-',77,'-'));

2105: rec_sp_std_dtls.ld_sequence_number) THEN
2106: log_parameters(g_v_disb_fee_class,NULL);
2107: fnd_message.set_name('IGF','IGF_SP_ELGB_FAIL');
2108: fnd_file.put_line(fnd_file.log,fnd_message.get);
2109: fnd_file.put_line(fnd_file.log, RPAD('-',77,'-'));
2110: EXIT;
2111: ELSE
2112: loop_thru_spnsr_dtl_pvt(p_person_id => rec_sp_std_dtls.person_id,
2113: p_award_type => p_award_type,

Line 2137: fnd_file.put_line(fnd_file.log, RPAD('-',77,'-'));

2133: p_fee_type => rec_sp_std_dtls.fee_type,
2134: p_spnsr_stdnt_id => rec_sp_std_dtls.spnsr_stdnt_id,
2135: p_n_total_spnsr_amt => rec_sp_std_dtls.tot_spnsr_amount);
2136: END IF;
2137: fnd_file.put_line(fnd_file.log, RPAD('-',77,'-'));
2138: END LOOP;
2139: CLOSE c_sp_std_dtls;
2140: EXCEPTION
2141: -- close open cursor

Line 2404: fnd_file.put_line(fnd_file.log, RPAD('-',77,'-'));

2400: l_b_test_mode := FALSE;
2401: g_v_log_text := NULL;
2402: END IF;
2403: log_parameters(g_v_test_mode,g_v_log_text);
2404: fnd_file.put_line(fnd_file.log, RPAD('-',77,'-'));
2405:
2406: -- check if the input parameters are not valid
2407: -- when not valid then return from the process after logging which all parameters are not valid
2408: IF NOT l_b_award_year THEN

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

2408: IF NOT l_b_award_year THEN
2409: l_b_param_valid := FALSE;
2410: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
2411: fnd_message.set_token('PARAMETER',g_v_award_yr);
2412: fnd_file.put_line(fnd_file.log, fnd_message.get);
2413: END IF;
2414:
2415: IF NOT l_b_term THEN
2416: l_b_param_valid := FALSE;

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

2415: IF NOT l_b_term THEN
2416: l_b_param_valid := FALSE;
2417: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
2418: fnd_message.set_token('PARAMETER',g_v_term);
2419: fnd_file.put_line(fnd_file.log, fnd_message.get);
2420: END IF;
2421:
2422: IF NOT l_b_person_number THEN
2423: l_b_param_valid := FALSE;

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

2422: IF NOT l_b_person_number THEN
2423: l_b_param_valid := FALSE;
2424: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
2425: fnd_message.set_token('PARAMETER',g_v_person_num_pmt);
2426: fnd_file.put_line(fnd_file.log, fnd_message.get);
2427: END IF;
2428:
2429: -- If the person group validation has failed earlier or the person group
2430: -- is closed, then error message is logged

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

2431: IF NOT l_b_person_group OR NVL(l_c_pers_id_grp.closed_ind,'N') = 'Y' THEN
2432: l_b_param_valid := FALSE;
2433: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
2434: fnd_message.set_token('PARAMETER',g_v_person_group);
2435: fnd_file.put_line(fnd_file.log, fnd_message.get);
2436: END IF;
2437:
2438: IF NOT l_b_sponsor_code THEN
2439: l_b_param_valid := FALSE;

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

2438: IF NOT l_b_sponsor_code THEN
2439: l_b_param_valid := FALSE;
2440: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
2441: fnd_message.set_token('PARAMETER',g_v_spnr_cd);
2442: fnd_file.put_line(fnd_file.log, fnd_message.get);
2443: END IF;
2444:
2445: IF NOT l_b_award_type THEN
2446: l_b_param_valid := FALSE;

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

2445: IF NOT l_b_award_type THEN
2446: l_b_param_valid := FALSE;
2447: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
2448: fnd_message.set_token('PARAMETER',g_v_award_type);
2449: fnd_file.put_line(fnd_file.log, fnd_message.get);
2450: END IF;
2451:
2452: IF NOT l_b_test_mode THEN
2453: l_b_param_valid := FALSE;

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

2452: IF NOT l_b_test_mode THEN
2453: l_b_param_valid := FALSE;
2454: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
2455: fnd_message.set_token('PARAMETER',g_v_test_mode);
2456: fnd_file.put_line(fnd_file.log, fnd_message.get);
2457: END IF;
2458:
2459: IF NOT l_b_param_valid THEN
2460: RETURN;

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

2465: IF p_person_id IS NOT NULL AND p_person_group_id IS NOT NULL THEN
2466: retcode := 2;
2467: -- Removed assignment of error message to errbuf to prevent dual messages appearing in the log
2468: fnd_message.set_name('IGS','IGS_FI_PRS_OR_PRSIDGRP');
2469: fnd_file.put_line(fnd_file.log, fnd_message.get);
2470: RETURN;
2471: END IF;
2472:
2473: --Validate the Award Year Status. If the status is not open, log the message in log file and

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

2483: fnd_message.set_name('IGF',l_v_message_name);
2484: ELSE
2485: fnd_message.set_name('IGS',l_v_message_name);
2486: END IF;
2487: fnd_file.put_line(fnd_file.log,fnd_message.get);
2488: retcode := 2;
2489: RETURN;
2490: END IF;
2491:

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

2495: p_v_message_name => l_v_message_name);
2496: IF (l_v_manage_acc IS NULL) THEN
2497: retcode := 2;
2498: fnd_message.set_name('IGS',l_v_message_name);
2499: fnd_file.put_line(fnd_file.log,fnd_message.get);
2500: RETURN;
2501: END IF;
2502:
2503: -- Get the select statement when the person id Group is provided

Line 2509: fnd_file.put_line(fnd_file.log, l_dynamic_sql);

2505: --Bug #5021084
2506: l_dynamic_sql := igf_ap_ss_pkg.get_pid(p_person_group_id, l_v_status,lv_group_type);
2507:
2508: IF l_v_status <> 'S' THEN
2509: fnd_file.put_line(fnd_file.log, l_dynamic_sql);
2510: retcode := 2;
2511: RETURN;
2512: END IF;
2513: END IF;

Line 2558: fnd_file.put_line(fnd_file.log,'');

2554:
2555: -- if the job is run with test_mode set to Y, rollback the transaction
2556: IF g_b_records_found THEN
2557: IF p_test_mode = 'Y' THEN
2558: fnd_file.put_line(fnd_file.log,'');
2559: fnd_message.set_name('IGF','IGF_SP_TEST_MODE');
2560: fnd_file.put_line(fnd_file.log,fnd_message.get);
2561: END IF;
2562: ELSE

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

2556: IF g_b_records_found THEN
2557: IF p_test_mode = 'Y' THEN
2558: fnd_file.put_line(fnd_file.log,'');
2559: fnd_message.set_name('IGF','IGF_SP_TEST_MODE');
2560: fnd_file.put_line(fnd_file.log,fnd_message.get);
2561: END IF;
2562: ELSE
2563: fnd_file.put_line(fnd_file.log,'');
2564: fnd_message.set_name('IGS','IGS_GE_NO_DATA_FOUND');

Line 2563: fnd_file.put_line(fnd_file.log,'');

2559: fnd_message.set_name('IGF','IGF_SP_TEST_MODE');
2560: fnd_file.put_line(fnd_file.log,fnd_message.get);
2561: END IF;
2562: ELSE
2563: fnd_file.put_line(fnd_file.log,'');
2564: fnd_message.set_name('IGS','IGS_GE_NO_DATA_FOUND');
2565: fnd_file.put_line(fnd_file.log,fnd_message.get);
2566: END IF;
2567:

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

2561: END IF;
2562: ELSE
2563: fnd_file.put_line(fnd_file.log,'');
2564: fnd_message.set_name('IGS','IGS_GE_NO_DATA_FOUND');
2565: fnd_file.put_line(fnd_file.log,fnd_message.get);
2566: END IF;
2567:
2568: EXCEPTION
2569: WHEN OTHERS THEN

Line 2571: fnd_file.put_line(fnd_file.log,SQLERRM);

2567:
2568: EXCEPTION
2569: WHEN OTHERS THEN
2570: ROLLBACK;
2571: fnd_file.put_line(fnd_file.log,SQLERRM);
2572: retcode := 2 ;
2573: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2574: fnd_message.set_token('NAME','CREATE_AWARD_DISB');
2575: errbuf := fnd_message.get||' - '||SQLERRM;