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

Line 41: fnd_file.put_line(fnd_file.log,'Calling Procedure to Populate New and Terminated Report');

37: -- Changing the date parameters from canonical format to date format.
38: --l_from_date:= fnd_date.canonical_to_date(p_from_date);
39: --l_to_date := fnd_date.canonical_to_date(p_to_date);
40: -- Populate the Part 1 of 462 Report
41: fnd_file.put_line(fnd_file.log,'Calling Procedure to Populate New and Terminated Report');
42: /*Write message in temporary table*/
43: /* Hardcode The values for the call to report5*/
44: --populate_new_and_term_wrks(2821,'JAN',2003);
45: /*End of call to report5*/

Line 48: fnd_file.put_line(fnd_file.log,'Calling Procedure to write into XML File');

44: --populate_new_and_term_wrks(2821,'JAN',2003);
45: /*End of call to report5*/
46: /*Write message in temporary table*/
47: -- Write the values to XML File
48: fnd_file.put_line(fnd_file.log,'Calling Procedure to write into XML File');
49: /* WritetoXML(
50: p_request_id,
51: l_report,
52: l_file_name);*/

Line 54: fnd_file.put_line(fnd_file.log,'------------Output XML File----------------');

50: p_request_id,
51: l_report,
52: l_file_name);*/
53: p_output_fname := l_file_name;
54: fnd_file.put_line(fnd_file.log,'------------Output XML File----------------');
55: fnd_file.put_line(fnd_file.log,'File' || l_file_name );
56: fnd_file.put_line(fnd_file.log,'-------------------------------------------');
57: EXCEPTION
58: WHEN utl_file.invalid_path then

Line 55: fnd_file.put_line(fnd_file.log,'File' || l_file_name );

51: l_report,
52: l_file_name);*/
53: p_output_fname := l_file_name;
54: fnd_file.put_line(fnd_file.log,'------------Output XML File----------------');
55: fnd_file.put_line(fnd_file.log,'File' || l_file_name );
56: fnd_file.put_line(fnd_file.log,'-------------------------------------------');
57: EXCEPTION
58: WHEN utl_file.invalid_path then
59: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');

Line 56: fnd_file.put_line(fnd_file.log,'-------------------------------------------');

52: l_file_name);*/
53: p_output_fname := l_file_name;
54: fnd_file.put_line(fnd_file.log,'------------Output XML File----------------');
55: fnd_file.put_line(fnd_file.log,'File' || l_file_name );
56: fnd_file.put_line(fnd_file.log,'-------------------------------------------');
57: EXCEPTION
58: WHEN utl_file.invalid_path then
59: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
60: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 60: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

56: fnd_file.put_line(fnd_file.log,'-------------------------------------------');
57: EXCEPTION
58: WHEN utl_file.invalid_path then
59: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
60: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
61: hr_utility.raise_error;
62: --
63: WHEN utl_file.invalid_mode then
64: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

Line 65: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

61: hr_utility.raise_error;
62: --
63: WHEN utl_file.invalid_mode then
64: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
65: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
66: hr_utility.raise_error;
67: --
68: WHEN utl_file.invalid_filehandle then
69: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

Line 70: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

66: hr_utility.raise_error;
67: --
68: WHEN utl_file.invalid_filehandle then
69: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
70: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
71: hr_utility.raise_error;
72: --
73: WHEN utl_file.invalid_operation then
74: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

Line 75: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

71: hr_utility.raise_error;
72: --
73: WHEN utl_file.invalid_operation then
74: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
75: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
76: hr_utility.raise_error;
77: --
78: WHEN utl_file.read_error then
79: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

Line 80: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

76: hr_utility.raise_error;
77: --
78: WHEN utl_file.read_error then
79: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
80: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
81: hr_utility.raise_error;
82: --
83: WHEN others THEN
84: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

Line 86: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

82: --
83: WHEN others THEN
84: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
85: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
86: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
87: hr_utility.raise_error;
88: END populate_sum;
89: --------------------------------------------
90: -- Procedure to populate the new and terminated report

Line 1040: /* fnd_file.put_line(fnd_file.log,'Calling Procedure to write into XML File');

1036: END LOOP;
1037: /*Msg in the temorary table*/
1038: WritetoCLOB ( l_xfdf_blob );
1039: -- Write the values to XML File
1040: /* fnd_file.put_line(fnd_file.log,'Calling Procedure to write into XML File');
1041: WritetoXML(
1042: p_request_id,
1043: p_report,
1044: p_output_fname);

Line 1046: fnd_file.put_line(fnd_file.log,'------------Output XML File----------------');

1042: p_request_id,
1043: p_report,
1044: p_output_fname);
1045: --p_output_fname := l_file_name;
1046: fnd_file.put_line(fnd_file.log,'------------Output XML File----------------');
1047: fnd_file.put_line(fnd_file.log,'File' || p_output_fname );
1048: fnd_file.put_line(fnd_file.log,'-------------------------------------------');*/
1049: /*
1050: EXCEPTION

Line 1047: fnd_file.put_line(fnd_file.log,'File' || p_output_fname );

1043: p_report,
1044: p_output_fname);
1045: --p_output_fname := l_file_name;
1046: fnd_file.put_line(fnd_file.log,'------------Output XML File----------------');
1047: fnd_file.put_line(fnd_file.log,'File' || p_output_fname );
1048: fnd_file.put_line(fnd_file.log,'-------------------------------------------');*/
1049: /*
1050: EXCEPTION
1051: WHEN utl_file.invalid_path then

Line 1048: fnd_file.put_line(fnd_file.log,'-------------------------------------------');*/

1044: p_output_fname);
1045: --p_output_fname := l_file_name;
1046: fnd_file.put_line(fnd_file.log,'------------Output XML File----------------');
1047: fnd_file.put_line(fnd_file.log,'File' || p_output_fname );
1048: fnd_file.put_line(fnd_file.log,'-------------------------------------------');*/
1049: /*
1050: EXCEPTION
1051: WHEN utl_file.invalid_path then
1052: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');

Line 1053: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

1049: /*
1050: EXCEPTION
1051: WHEN utl_file.invalid_path then
1052: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
1053: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1054: hr_utility.raise_error;
1055: --
1056: WHEN utl_file.invalid_mode then
1057: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

Line 1058: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

1054: hr_utility.raise_error;
1055: --
1056: WHEN utl_file.invalid_mode then
1057: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
1058: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1059: hr_utility.raise_error;
1060: --
1061: WHEN utl_file.invalid_filehandle then
1062: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

Line 1063: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

1059: hr_utility.raise_error;
1060: --
1061: WHEN utl_file.invalid_filehandle then
1062: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
1063: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1064: hr_utility.raise_error;
1065: --
1066: WHEN utl_file.invalid_operation then
1067: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

Line 1068: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

1064: hr_utility.raise_error;
1065: --
1066: WHEN utl_file.invalid_operation then
1067: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
1068: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1069: hr_utility.raise_error;
1070: --
1071: WHEN utl_file.read_error then
1072: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

Line 1073: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

1069: hr_utility.raise_error;
1070: --
1071: WHEN utl_file.read_error then
1072: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
1073: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1074: hr_utility.raise_error;
1075: --
1076: WHEN others THEN
1077: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

Line 1079: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

1075: --
1076: WHEN others THEN
1077: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1078: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
1079: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1080: hr_utility.raise_error;
1081: */
1082: END populate_new_and_term_wrks;
1083: -------------------------------------------

Line 2511: /* fnd_file.put_line(fnd_file.log,'Calling Procedure to write into XML File');

2507: END LOOP;
2508: /*End of call to report5*/
2509: WritetoCLOB ( l_xfdf_blob );
2510: -- Write the values to XML File
2511: /* fnd_file.put_line(fnd_file.log,'Calling Procedure to write into XML File');
2512: WritetoXML(
2513: p_request_id,
2514: p_report,
2515: l_file_name);

Line 2517: fnd_file.put_line(fnd_file.log,'------------Output XML File----------------');

2513: p_request_id,
2514: p_report,
2515: l_file_name);
2516: p_output_fname := l_file_name;
2517: fnd_file.put_line(fnd_file.log,'------------Output XML File----------------');
2518: fnd_file.put_line(fnd_file.log,'File' || l_file_name );
2519: fnd_file.put_line(fnd_file.log,'-------------------------------------------');
2520: p_output_fname := l_file_name;*/
2521: /*

Line 2518: fnd_file.put_line(fnd_file.log,'File' || l_file_name );

2514: p_report,
2515: l_file_name);
2516: p_output_fname := l_file_name;
2517: fnd_file.put_line(fnd_file.log,'------------Output XML File----------------');
2518: fnd_file.put_line(fnd_file.log,'File' || l_file_name );
2519: fnd_file.put_line(fnd_file.log,'-------------------------------------------');
2520: p_output_fname := l_file_name;*/
2521: /*
2522: EXCEPTION

Line 2519: fnd_file.put_line(fnd_file.log,'-------------------------------------------');

2515: l_file_name);
2516: p_output_fname := l_file_name;
2517: fnd_file.put_line(fnd_file.log,'------------Output XML File----------------');
2518: fnd_file.put_line(fnd_file.log,'File' || l_file_name );
2519: fnd_file.put_line(fnd_file.log,'-------------------------------------------');
2520: p_output_fname := l_file_name;*/
2521: /*
2522: EXCEPTION
2523: WHEN utl_file.invalid_path then

Line 2525: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

2521: /*
2522: EXCEPTION
2523: WHEN utl_file.invalid_path then
2524: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
2525: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2526: hr_utility.raise_error;
2527: --
2528: WHEN utl_file.invalid_mode then
2529: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

Line 2530: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

2526: hr_utility.raise_error;
2527: --
2528: WHEN utl_file.invalid_mode then
2529: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
2530: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2531: hr_utility.raise_error;
2532: --
2533: WHEN utl_file.invalid_filehandle then
2534: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

Line 2535: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

2531: hr_utility.raise_error;
2532: --
2533: WHEN utl_file.invalid_filehandle then
2534: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
2535: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2536: hr_utility.raise_error;
2537: --
2538: WHEN utl_file.invalid_operation then
2539: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

Line 2540: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

2536: hr_utility.raise_error;
2537: --
2538: WHEN utl_file.invalid_operation then
2539: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
2540: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2541: hr_utility.raise_error;
2542: --
2543: WHEN utl_file.read_error then
2544: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

Line 2545: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

2541: hr_utility.raise_error;
2542: --
2543: WHEN utl_file.read_error then
2544: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
2545: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2546: hr_utility.raise_error;
2547: --
2548: WHEN others THEN
2549: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

Line 2551: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

2547: --
2548: WHEN others THEN
2549: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2550: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
2551: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2552: hr_utility.raise_error;
2553: */
2554: end populate_monthly_contributions;
2555: ----------------------------------------------

Line 3760: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

3756: /*
3757: EXCEPTION
3758: WHEN utl_file.invalid_path then
3759: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
3760: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3761: hr_utility.raise_error;
3762: --
3763: WHEN utl_file.invalid_mode then
3764: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

Line 3765: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

3761: hr_utility.raise_error;
3762: --
3763: WHEN utl_file.invalid_mode then
3764: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
3765: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3766: hr_utility.raise_error;
3767: --
3768: WHEN utl_file.invalid_filehandle then
3769: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

Line 3770: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

3766: hr_utility.raise_error;
3767: --
3768: WHEN utl_file.invalid_filehandle then
3769: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
3770: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3771: hr_utility.raise_error;
3772: --
3773: WHEN utl_file.invalid_operation then
3774: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

Line 3775: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

3771: hr_utility.raise_error;
3772: --
3773: WHEN utl_file.invalid_operation then
3774: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
3775: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3776: hr_utility.raise_error;
3777: --
3778: WHEN utl_file.read_error then
3779: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

Line 3780: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

3776: hr_utility.raise_error;
3777: --
3778: WHEN utl_file.read_error then
3779: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
3780: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3781: hr_utility.raise_error;
3782: --
3783: WHEN others THEN
3784: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

Line 3786: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

3782: --
3783: WHEN others THEN
3784: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
3785: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
3786: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3787: hr_utility.raise_error;
3788: */
3789: end populate_workers_movement;
3790: /*End of SA Worker Movement Report*/