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

Line 157: hr_utility.set_message(800, 'HR_34865_NO_AUDIT_TABLE');

153: open csr_chk_tabname(substr(P_TABLE,1,24)||'_A',l_oracle_schema);
154: fetch csr_chk_tabname into l_dummy;
155: if csr_chk_tabname%notfound Then
156: close csr_chk_tabname;
157: hr_utility.set_message(800, 'HR_34865_NO_AUDIT_TABLE');
158: hr_utility.set_message_token('AUDIT_TABLE',substr(P_TABLE,1,24)||'_A');
159: hr_utility.set_message_token('BASE_TABLE',P_TABLE);
160: hr_utility.raise_error;
161: end if;

Line 158: hr_utility.set_message_token('AUDIT_TABLE',substr(P_TABLE,1,24)||'_A');

154: fetch csr_chk_tabname into l_dummy;
155: if csr_chk_tabname%notfound Then
156: close csr_chk_tabname;
157: hr_utility.set_message(800, 'HR_34865_NO_AUDIT_TABLE');
158: hr_utility.set_message_token('AUDIT_TABLE',substr(P_TABLE,1,24)||'_A');
159: hr_utility.set_message_token('BASE_TABLE',P_TABLE);
160: hr_utility.raise_error;
161: end if;
162: close csr_chk_tabname;

Line 159: hr_utility.set_message_token('BASE_TABLE',P_TABLE);

155: if csr_chk_tabname%notfound Then
156: close csr_chk_tabname;
157: hr_utility.set_message(800, 'HR_34865_NO_AUDIT_TABLE');
158: hr_utility.set_message_token('AUDIT_TABLE',substr(P_TABLE,1,24)||'_A');
159: hr_utility.set_message_token('BASE_TABLE',P_TABLE);
160: hr_utility.raise_error;
161: end if;
162: close csr_chk_tabname;
163: --

Line 160: hr_utility.raise_error;

156: close csr_chk_tabname;
157: hr_utility.set_message(800, 'HR_34865_NO_AUDIT_TABLE');
158: hr_utility.set_message_token('AUDIT_TABLE',substr(P_TABLE,1,24)||'_A');
159: hr_utility.set_message_token('BASE_TABLE',P_TABLE);
160: hr_utility.raise_error;
161: end if;
162: close csr_chk_tabname;
163: --
164: -- DATETRACK TABLE OPERATIONS

Line 762: 'hr_utility.set_location(''ERROR:''||' ||

758: -- commit operations and exception handling
759: --
760: dt_text14:= 'end if;commit;l_grkey_prv:=l_grkey_cur;end loop;exception ' ||
761: 'when others then close dt_curs;' ||
762: 'hr_utility.set_location(''ERROR:''||' ||
763: 'to_char(dbms_sql.last_sql_function_code),00);' ||
764: 'hr_utility.set_location(''ERROR:''||' ||
765: 'to_char(dbms_sql.last_error_position),00);' ||
766: 'l_err:=hr_utility.get_message;' ||

Line 764: 'hr_utility.set_location(''ERROR:''||' ||

760: dt_text14:= 'end if;commit;l_grkey_prv:=l_grkey_cur;end loop;exception ' ||
761: 'when others then close dt_curs;' ||
762: 'hr_utility.set_location(''ERROR:''||' ||
763: 'to_char(dbms_sql.last_sql_function_code),00);' ||
764: 'hr_utility.set_location(''ERROR:''||' ||
765: 'to_char(dbms_sql.last_error_position),00);' ||
766: 'l_err:=hr_utility.get_message;' ||
767: 'hr_utility.trace(l_err);' ||
768: 'raise;end;';

Line 766: 'l_err:=hr_utility.get_message;' ||

762: 'hr_utility.set_location(''ERROR:''||' ||
763: 'to_char(dbms_sql.last_sql_function_code),00);' ||
764: 'hr_utility.set_location(''ERROR:''||' ||
765: 'to_char(dbms_sql.last_error_position),00);' ||
766: 'l_err:=hr_utility.get_message;' ||
767: 'hr_utility.trace(l_err);' ||
768: 'raise;end;';
769: --
770: -- open the column_curs cursor fetching in column information and

Line 767: 'hr_utility.trace(l_err);' ||

763: 'to_char(dbms_sql.last_sql_function_code),00);' ||
764: 'hr_utility.set_location(''ERROR:''||' ||
765: 'to_char(dbms_sql.last_error_position),00);' ||
766: 'l_err:=hr_utility.get_message;' ||
767: 'hr_utility.trace(l_err);' ||
768: 'raise;end;';
769: --
770: -- open the column_curs cursor fetching in column information and
771: -- building up the dynamic text for each column

Line 783: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',10);

779: loop
780: --
781: -- fetch column information
782: --
783: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',10);
784: fetch column_curs into t_column_name,
785: t_column_id,
786: t_column_type,
787: t_column_width;

Line 898: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',20);

894: -- put this in its own block, so that if variable length is exceeded can raise
895: -- a specific error
896: --
897: BEGIN
898: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',20);
899: dt_proc_cursor_text := dt_text1 ||
900: dt_text2 ||
901: dt_text3 ||
902: dt_text4 ||

Line 924: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',30);

920: END;
921: --
922: -- open parse and execute the dynamic sql cursor text
923: --
924: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',30);
925: dt_proc_cursor := dbms_sql.open_cursor;
926: --
927: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',40);
928: dbms_sql.parse(dt_proc_cursor, dt_proc_cursor_text, dbms_sql.v7);

Line 927: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',40);

923: --
924: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',30);
925: dt_proc_cursor := dbms_sql.open_cursor;
926: --
927: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',40);
928: dbms_sql.parse(dt_proc_cursor, dt_proc_cursor_text, dbms_sql.v7);
929: --
930: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',50);
931: dt_proc_rows := dbms_sql.execute(dt_proc_cursor);

Line 930: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',50);

926: --
927: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',40);
928: dbms_sql.parse(dt_proc_cursor, dt_proc_cursor_text, dbms_sql.v7);
929: --
930: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',50);
931: dt_proc_rows := dbms_sql.execute(dt_proc_cursor);
932: --
933: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',60);
934: if dbms_sql.is_open(dt_proc_cursor) then

Line 933: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',60);

929: --
930: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',50);
931: dt_proc_rows := dbms_sql.execute(dt_proc_cursor);
932: --
933: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',60);
934: if dbms_sql.is_open(dt_proc_cursor) then
935: dbms_sql.close_cursor(dt_proc_cursor);
936: end if;
937: --

Line 1144: 'hr_utility.set_location(''ERROR:''||' ||

1140: --
1141: ndt_text21 := 'elsif l_type = ''I'' then null;end if;' ||
1142: 'commit;end if;l_prev_pk:=l_pkval;' ||
1143: 'end loop;exception when others then close ndt_curs;' ||
1144: 'hr_utility.set_location(''ERROR:''||' ||
1145: 'to_char(dbms_sql.last_sql_function_code),00);' ||
1146: 'hr_utility.set_location(''ERROR:''||' ||
1147: 'to_char(dbms_sql.last_error_position),00);' ||
1148: 'l_err:=hr_utility.get_message;' ||

Line 1146: 'hr_utility.set_location(''ERROR:''||' ||

1142: 'commit;end if;l_prev_pk:=l_pkval;' ||
1143: 'end loop;exception when others then close ndt_curs;' ||
1144: 'hr_utility.set_location(''ERROR:''||' ||
1145: 'to_char(dbms_sql.last_sql_function_code),00);' ||
1146: 'hr_utility.set_location(''ERROR:''||' ||
1147: 'to_char(dbms_sql.last_error_position),00);' ||
1148: 'l_err:=hr_utility.get_message;' ||
1149: 'hr_utility.trace(l_err);' ||
1150: 'end;';

Line 1148: 'l_err:=hr_utility.get_message;' ||

1144: 'hr_utility.set_location(''ERROR:''||' ||
1145: 'to_char(dbms_sql.last_sql_function_code),00);' ||
1146: 'hr_utility.set_location(''ERROR:''||' ||
1147: 'to_char(dbms_sql.last_error_position),00);' ||
1148: 'l_err:=hr_utility.get_message;' ||
1149: 'hr_utility.trace(l_err);' ||
1150: 'end;';
1151: --
1152: -- open the column_curs cursor fetching in column information and

Line 1149: 'hr_utility.trace(l_err);' ||

1145: 'to_char(dbms_sql.last_sql_function_code),00);' ||
1146: 'hr_utility.set_location(''ERROR:''||' ||
1147: 'to_char(dbms_sql.last_error_position),00);' ||
1148: 'l_err:=hr_utility.get_message;' ||
1149: 'hr_utility.trace(l_err);' ||
1150: 'end;';
1151: --
1152: -- open the column_curs cursor fetching in column information and
1153: -- building up the dynamic text for each column

Line 1165: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',60);

1161: loop
1162: --
1163: -- fetch column information
1164: --
1165: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',60);
1166: fetch column_curs into t_column_name,
1167: t_column_id,
1168: t_column_type,
1169: t_column_width;

Line 1334: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',70);

1330:
1331: --
1332: -- open parse and execute the dynamic sql cursor text
1333: --
1334: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',70);
1335: ndt_proc_cursor := dbms_sql.open_CURSOR;
1336: --
1337: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',80);
1338: dbms_sql.parse(ndt_proc_cursor, ndt_proc_cursor_text, dbms_sql.v7);

Line 1337: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',80);

1333: --
1334: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',70);
1335: ndt_proc_cursor := dbms_sql.open_CURSOR;
1336: --
1337: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',80);
1338: dbms_sql.parse(ndt_proc_cursor, ndt_proc_cursor_text, dbms_sql.v7);
1339: --
1340: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',90);
1341: ndt_proc_rows := dbms_sql.EXECUTE(ndt_proc_cursor);

Line 1340: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',90);

1336: --
1337: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',80);
1338: dbms_sql.parse(ndt_proc_cursor, ndt_proc_cursor_text, dbms_sql.v7);
1339: --
1340: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',90);
1341: ndt_proc_rows := dbms_sql.EXECUTE(ndt_proc_cursor);
1342: --
1343: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',100);
1344: if dbms_sql.is_open(ndt_proc_cursor) then

Line 1343: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',100);

1339: --
1340: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',90);
1341: ndt_proc_rows := dbms_sql.EXECUTE(ndt_proc_cursor);
1342: --
1343: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',100);
1344: if dbms_sql.is_open(ndt_proc_cursor) then
1345: dbms_sql.close_CURSOR(ndt_proc_cursor);
1346: end if;
1347: --

Line 1362: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',101);

1358: -- flemonni 630622
1359: --
1360: --
1361: WHEN g_parse_string_too_big THEN
1362: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',101);
1363: fnd_message.set_name('PER', 'PER_52348_AUDIT_SQL_TOO_LARGE');
1364: fnd_message.set_token ('AUDITTABLE', g_audit_table);
1365: --
1366: RAISE;

Line 1383: hr_utility.set_location('error is : ' ||

1379: end if;
1380: --
1381: -- display the error
1382: --
1383: hr_utility.set_location('error is : ' ||
1384: to_char(dbms_sql.last_sql_function_code),00);
1385: hr_utility.set_location('error is : ' ||
1386: to_char(dbms_sql.last_error_position),00);
1387: error_message := hr_utility.get_message;

Line 1385: hr_utility.set_location('error is : ' ||

1381: -- display the error
1382: --
1383: hr_utility.set_location('error is : ' ||
1384: to_char(dbms_sql.last_sql_function_code),00);
1385: hr_utility.set_location('error is : ' ||
1386: to_char(dbms_sql.last_error_position),00);
1387: error_message := hr_utility.get_message;
1388: hr_utility.trace(error_message);
1389: hr_utility.trace('all cursors closed');

Line 1387: error_message := hr_utility.get_message;

1383: hr_utility.set_location('error is : ' ||
1384: to_char(dbms_sql.last_sql_function_code),00);
1385: hr_utility.set_location('error is : ' ||
1386: to_char(dbms_sql.last_error_position),00);
1387: error_message := hr_utility.get_message;
1388: hr_utility.trace(error_message);
1389: hr_utility.trace('all cursors closed');
1390: raise;
1391: end py_audit_rep_proc;

Line 1388: hr_utility.trace(error_message);

1384: to_char(dbms_sql.last_sql_function_code),00);
1385: hr_utility.set_location('error is : ' ||
1386: to_char(dbms_sql.last_error_position),00);
1387: error_message := hr_utility.get_message;
1388: hr_utility.trace(error_message);
1389: hr_utility.trace('all cursors closed');
1390: raise;
1391: end py_audit_rep_proc;
1392: end py_audit_rep_pkg;

Line 1389: hr_utility.trace('all cursors closed');

1385: hr_utility.set_location('error is : ' ||
1386: to_char(dbms_sql.last_error_position),00);
1387: error_message := hr_utility.get_message;
1388: hr_utility.trace(error_message);
1389: hr_utility.trace('all cursors closed');
1390: raise;
1391: end py_audit_rep_proc;
1392: end py_audit_rep_pkg;