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 HR_UTILITY

Line 59: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');

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);
61: hr_utility.raise_error;
62: --
63: WHEN utl_file.invalid_mode then

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 61: hr_utility.raise_error;

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');
65: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 64: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

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');
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

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 66: 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');
70: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 69: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

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');
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

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 71: 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');
75: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 74: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

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');
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

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 76: 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');
80: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 79: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

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');
80: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
81: hr_utility.raise_error;
82: --
83: WHEN others THEN

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 81: 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');
85: hr_utility.set_message_token('2',substr(sqlerrm,1,200));

Line 84: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_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');
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;

Line 85: hr_utility.set_message_token('2',substr(sqlerrm,1,200));

81: hr_utility.raise_error;
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: --------------------------------------------

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 87: hr_utility.raise_error;

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
91: PROCEDURE populate_new_and_term_wrks

Line 486: hr_utility.set_location('Before Hierarchy logic',10);

482: loop
483: fetch csr_org_hierarchy into rec_org_id;
484: exit when csr_org_hierarchy%notfound;
485: hr_sa_org_info.get_employer_name(rec_org_id.org,l_gre_name,p_business_group_id,p_org_structure_version_id);
486: hr_utility.set_location('Before Hierarchy logic',10);
487: begin
488: select organization_id
489: into l_gre_id
490: from hr_all_organization_units

Line 560: hr_utility.set_location('Calling Procedure to Populate New and Terminated Report',20);

556: -- New code ends
557: end if;
558: vXMLTable.DELETE;
559: vCtr := 1;
560: hr_utility.set_location('Calling Procedure to Populate New and Terminated Report',20);
561: FOR i in t_legal_entity.first..t_legal_entity.last
562: LOOP
563: l_org_id := t_legal_entity(i).gre_id;
564: OPEN get_lower_base(l_effective_date_p);

Line 1023: hr_utility.set_location('Finished populating New and Terminated Report ',30);

1019: l_n := 0;
1020: l_t := 0;
1021: l_sum :=0;
1022: l_sum_term:=0;
1023: hr_utility.set_location('Finished populating New and Terminated Report ',30);
1024: new_count := 0;
1025: term_count :=0;
1026: l_new_count := 1;
1027: l_term_count := 1;

Line 1052: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');

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');
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

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 1054: hr_utility.raise_error;

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');
1058: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 1057: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

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');
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

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 1059: 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');
1063: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 1062: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

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');
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

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 1064: 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');
1068: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 1067: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

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');
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

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 1069: 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');
1073: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 1072: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

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');
1073: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1074: hr_utility.raise_error;
1075: --
1076: WHEN others THEN

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 1074: 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');
1078: hr_utility.set_message_token('2',substr(sqlerrm,1,200));

Line 1077: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_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');
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: */

Line 1078: hr_utility.set_message_token('2',substr(sqlerrm,1,200));

1074: hr_utility.raise_error;
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;

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 1080: hr_utility.raise_error;

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

Line 1367: hr_utility.set_location('Before hierarchy logic ',40);

1363: insert into fnd_sessions(session_id,effective_date) values(userenv('sessionid'),l_effective_date);
1364: -- To clear the PL/SQL Table values.
1365: vXMLTable.DELETE;
1366: vCtr := 1;
1367: hr_utility.set_location('Before hierarchy logic ',40);
1368: /*Commented the hierarchy part on 15-Jan-2004 */
1369: /*
1370: if p_org_structure_version_id is not null then
1371: if p_organisation_id is null then

Line 1504: hr_utility.set_location('Calling Procedure to Populate Monthly Contribution Report ',50);

1500: t_legal_entity(1).gre_id := l_gre_id;
1501: t_legal_entity(1).gre_name := l_gre_name;
1502: -- New code ends
1503: end if;
1504: hr_utility.set_location('Calling Procedure to Populate Monthly Contribution Report ',50);
1505: FOR i in t_legal_entity.first..t_legal_entity.last
1506: LOOP
1507: l_tax_unit_id := t_legal_entity(i).gre_id;
1508: /*Get details for section A*/

Line 2459: hr_utility.set_location('Finished Procedure Populate Monthly Contribution Report ',60);

2455: vXMLTable(vCtr).TagValue := substr(l_fm_total,1,length(l_fm_total)-3);
2456: vctr := vctr + 1;
2457: ***********************************************************************/
2458: /*Msg in the temorary table*/
2459: hr_utility.set_location('Finished Procedure Populate Monthly Contribution Report ',60);
2460: /* -----------------------------------------------------------------------------
2461: -- Writing into XML File
2462: -----------------------------------------------------------------------------
2463: -- Assigning the File name.

Line 2524: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');

2520: p_output_fname := l_file_name;*/
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

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 2526: hr_utility.raise_error;

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');
2530: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 2529: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

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');
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

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 2531: 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');
2535: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 2534: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

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');
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

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 2536: 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');
2540: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 2539: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

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');
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

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 2541: 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');
2545: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 2544: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

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');
2545: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2546: hr_utility.raise_error;
2547: --
2548: WHEN others THEN

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 2546: 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');
2550: hr_utility.set_message_token('2',substr(sqlerrm,1,200));

Line 2549: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_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');
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: */

Line 2550: hr_utility.set_message_token('2',substr(sqlerrm,1,200));

2546: hr_utility.raise_error;
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;

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 2552: hr_utility.raise_error;

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

Line 2942: hr_utility.set_location('Before hierarchy logic',70);

2938: loop
2939: l_form := t_form_type(m);
2940: T_EMP.DELETE;
2941: T_LEGAL_ENTITY.DELETE;
2942: hr_utility.set_location('Before hierarchy logic',70);
2943: If p_assignment_id is not null then
2944: if p_assignment_set_id is not null then
2945: begin
2946: select 1 into i

Line 3026: hr_utility.set_location('Entering procedure workers movement Report ',80);

3022: t_emp(i).emp_id := valid_assignments.assignment_id;
3023: i := i + 1;
3024: end loop;
3025: end if;
3026: hr_utility.set_location('Entering procedure workers movement Report ',80);
3027: if t_emp.count > 0 then
3028: for j in t_emp.first..t_emp.last loop
3029: /*Reset the local variables */
3030: l_employer_GOSI_office_name := null;

Line 3754: hr_utility.set_location('Finished Procedure Workers movement Report ',90);

3750: end loop; --t_emp
3751: end if;
3752: end loop; --(t_form_type);
3753: WritetoCLOB ( l_xfdf_blob );
3754: hr_utility.set_location('Finished Procedure Workers movement Report ',90);
3755: /*Write the values to xml file*/
3756: /*
3757: EXCEPTION
3758: WHEN utl_file.invalid_path then

Line 3759: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');

3755: /*Write the values to xml file*/
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

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 3761: hr_utility.raise_error;

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');
3765: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 3764: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

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');
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

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 3766: 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');
3770: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 3769: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

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');
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

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 3771: 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');
3775: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 3774: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

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');
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

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 3776: 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');
3780: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

Line 3779: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

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');
3780: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
3781: hr_utility.raise_error;
3782: --
3783: WHEN others THEN

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 3781: 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');
3785: hr_utility.set_message_token('2',substr(sqlerrm,1,200));

Line 3784: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_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');
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: */

Line 3785: hr_utility.set_message_token('2',substr(sqlerrm,1,200));

3781: hr_utility.raise_error;
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;

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

Line 3787: hr_utility.raise_error;

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

Line 3806: hr_utility.set_location('Entered Procedure Write to clob ',100);

3802: l_str7 varchar2(1000);
3803: l_str8 varchar2(240);
3804: l_str9 varchar2(240);
3805: begin
3806: hr_utility.set_location('Entered Procedure Write to clob ',100);
3807: l_str1 := '
3808:
3809: ' ;
3810: l_str2 := '