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.PER_RI_RT_UTIL_PKG dependencies on HR_UTILITY

Line 171: hr_utility.trace('Value Set Id is ' || l_value_set_id);

167: if (l_value_set_id = -999 or l_value_set_id is null) then
168: return p_value;
169: end if;
170: if (p_value is null) then return null; end if;
171: hr_utility.trace('Value Set Id is ' || l_value_set_id);
172: IF (l_value_set_id <> -999) THEN
173: OPEN get_sel_set_type(l_value_set_id);
174: FETCH get_sel_set_type INTO l_value_set_type;
175: CLOSE get_sel_set_type;

Line 176: hr_utility.trace('Value set type is ' || l_value_set_type);

172: IF (l_value_set_id <> -999) THEN
173: OPEN get_sel_set_type(l_value_set_id);
174: FETCH get_sel_set_type INTO l_value_set_type;
175: CLOSE get_sel_set_type;
176: hr_utility.trace('Value set type is ' || l_value_set_type);
177: IF (l_value_set_type = 'F' OR l_value_set_type = 'I') THEN
178: l_sql_stmt := make_sql_stmt(p_value_set_id => l_value_set_id,
179: p_value_set_type =>l_value_set_type,
180: p_choice => l_choice);

Line 182: hr_utility.trace('Null');

178: l_sql_stmt := make_sql_stmt(p_value_set_id => l_value_set_id,
179: p_value_set_type =>l_value_set_type,
180: p_choice => l_choice);
181: IF (l_sql_stmt is null ) then
182: hr_utility.trace('Null');
183: RETURN NULL;
184: END IF;
185: hr_utility.trace(l_sql_stmt);
186:

Line 185: hr_utility.trace(l_sql_stmt);

181: IF (l_sql_stmt is null ) then
182: hr_utility.trace('Null');
183: RETURN NULL;
184: END IF;
185: hr_utility.trace(l_sql_stmt);
186:
187: IF l_choice = TRUE THEN
188:
189: l_new_sql_stmt := 'select display_value from (' || l_sql_stmt || ') where id_value = to_char(:p_value)';

Line 254: hr_utility.trace('.................1');

250: l_sample_size := 5;
251: else
252: l_sample_size := p_sample_size;
253: end if;
254: hr_utility.trace('.................1');
255:
256: hr_utility.trace('Entering ...........1');
257: IF (p_entity_code = 'ORGANIZATION_HIERARCHY') THEN
258: l_query_str := 'SELECT pos.name OrganizationStructureName,' ||

Line 256: hr_utility.trace('Entering ...........1');

252: l_sample_size := p_sample_size;
253: end if;
254: hr_utility.trace('.................1');
255:
256: hr_utility.trace('Entering ...........1');
257: IF (p_entity_code = 'ORGANIZATION_HIERARCHY') THEN
258: l_query_str := 'SELECT pos.name OrganizationStructureName,' ||
259: ' pos.primary_structure_flag primaryflag,' ||
260: ' pos.POSITION_CONTROL_STRUCTURE_FLG PosnCtrlStrFlg,' ||

Line 583: hr_utility.trace('Elements.........1');

579:
580: l_entityset := 'Payrolls';
581: l_entity := 'Payroll';
582: ELSIF (p_entity_code = 'ELEMENTS') THEN
583: hr_utility.trace('Elements.........1');
584: l_query_str := 'SELECT pet.element_name ElementName,' ||
585: ' pet.reporting_name ReportingName,' ||
586: ' pet.description Description,' ||
587: ' pet.classification_name Classification,' ||

Line 666: hr_utility.trace('Salary Bases.........1');

662:
663: l_entityset := 'Elements';
664: l_entity := 'Element';
665: ELSIF (p_entity_code = 'SALARY_BASES') THEN
666: hr_utility.trace('Salary Bases.........1');
667: l_query_str := 'select ppb.name Name, ' ||
668: ' hl.meaning PayBasis, ' ||
669: ' ppb.pay_annualization_factor AnnualFactor, ' ||
670: ' pet.element_name Element, ' ||

Line 863: hr_utility.trace('Element Link.........1');

859:
860: l_entityset := 'PositionHierarchies';
861: l_entity := 'PositionHierarchy';
862: ELSIF (p_entity_code = 'ELEMENT_LINKS') THEN
863: hr_utility.trace('Element Link.........1');
864: l_query_str := 'select pel.element_name ElementName, ' ||
865: ' pel.description Description, ' ||
866: ' pel.classification_name Classification, ' ||
867: ' pel.processing_type ProcessingType, ' ||

Line 1257: hr_utility.trace(l_entityset || '.........2');

1253: ELSE
1254: p_xmldata := null;
1255: RETURN;
1256: END IF;
1257: hr_utility.trace(l_entityset || '.........2');
1258: --hr_utility.trace('Query is ' || l_query_str);
1259:
1260: queryCtx := DBMS_XMLQuery.newContext(l_query_str);
1261: DBMS_XMLQuery.setMaxRows(queryCtx,l_sample_size);

Line 1258: --hr_utility.trace('Query is ' || l_query_str);

1254: p_xmldata := null;
1255: RETURN;
1256: END IF;
1257: hr_utility.trace(l_entityset || '.........2');
1258: --hr_utility.trace('Query is ' || l_query_str);
1259:
1260: queryCtx := DBMS_XMLQuery.newContext(l_query_str);
1261: DBMS_XMLQuery.setMaxRows(queryCtx,l_sample_size);
1262: DBMS_XMLQuery.setRowsetTag(queryctx,l_entityset);

Line 1264: hr_utility.trace(l_entityset || '.........3');

1260: queryCtx := DBMS_XMLQuery.newContext(l_query_str);
1261: DBMS_XMLQuery.setMaxRows(queryCtx,l_sample_size);
1262: DBMS_XMLQuery.setRowsetTag(queryctx,l_entityset);
1263:
1264: hr_utility.trace(l_entityset || '.........3');
1265: DBMS_XMLQuery.setRowTag(queryctx,l_entityset);
1266:
1267: DBMS_XMLQuery.setBindValue(queryCtx,'business_group_id',p_business_group_id);
1268:

Line 1270: hr_utility.trace(l_entityset || '.........4');

1266:
1267: DBMS_XMLQuery.setBindValue(queryCtx,'business_group_id',p_business_group_id);
1268:
1269: p_xmldata := DBMS_XMLQuery.getXML(queryCtx);
1270: hr_utility.trace(l_entityset || '.........4');
1271:
1272: IF (instr(p_xmldata,(l_entityset || '/')) <>0 ) THEN
1273: p_xmldata := null;
1274: END IF;

Line 1275: hr_utility.trace('Returned' );

1271:
1272: IF (instr(p_xmldata,(l_entityset || '/')) <>0 ) THEN
1273: p_xmldata := null;
1274: END IF;
1275: hr_utility.trace('Returned' );
1276: EXCEPTION
1277: WHEN OTHERS THEN
1278: hr_utility.trace(substr(SQLERRM,1,1000));
1279: hr_utility.trace(l_entityset || '.........5');

Line 1278: hr_utility.trace(substr(SQLERRM,1,1000));

1274: END IF;
1275: hr_utility.trace('Returned' );
1276: EXCEPTION
1277: WHEN OTHERS THEN
1278: hr_utility.trace(substr(SQLERRM,1,1000));
1279: hr_utility.trace(l_entityset || '.........5');
1280: RAISE;
1281: END generate_xml;
1282: PROCEDURE apps_initialise IS

Line 1279: hr_utility.trace(l_entityset || '.........5');

1275: hr_utility.trace('Returned' );
1276: EXCEPTION
1277: WHEN OTHERS THEN
1278: hr_utility.trace(substr(SQLERRM,1,1000));
1279: hr_utility.trace(l_entityset || '.........5');
1280: RAISE;
1281: END generate_xml;
1282: PROCEDURE apps_initialise IS
1283: begin

Line 1287: hr_utility.trace(substr(SQLERRM,1,100));

1283: begin
1284: insert into fnd_sessions(session_id,effective_date) values (userenv('SESSIONID'),sysdate);
1285: exception
1286: when others then
1287: hr_utility.trace(substr(SQLERRM,1,100));
1288: raise;
1289: end;
1290: END per_ri_rt_util_pkg;