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.PO_HR_LOCATION dependencies on PO_DEBUG

Line 9: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;

5:
6: g_addr_prompt_query PO_HR_LOCATION.addr_prompt_query; --PL/SQL table for storing style code, query and prompt list.
7:
8: -- Debugging booleans used to bypass logging when turned off
9: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
10: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
11:
12: -- Logging constants
13: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_HR_LOCATION';

Line 10: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;

6: g_addr_prompt_query PO_HR_LOCATION.addr_prompt_query; --PL/SQL table for storing style code, query and prompt list.
7:
8: -- Debugging booleans used to bypass logging when turned off
9: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
10: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
11:
12: -- Logging constants
13: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_HR_LOCATION';
14: g_module_prefix CONSTANT VARCHAR2(100) := 'po.plsql.' || g_pkg_name || '.';

Line 41: PO_DEBUG.debug_begin(d_module);

37:
38: d_progress := '000';
39:
40: IF (g_debug_stmt) THEN
41: PO_DEBUG.debug_begin(d_module);
42: PO_DEBUG.debug_var(d_module, d_progress, 'p_location_id', p_location_id);
43: END IF;
44:
45: d_progress := '100';

Line 42: PO_DEBUG.debug_var(d_module, d_progress, 'p_location_id', p_location_id);

38: d_progress := '000';
39:
40: IF (g_debug_stmt) THEN
41: PO_DEBUG.debug_begin(d_module);
42: PO_DEBUG.debug_var(d_module, d_progress, 'p_location_id', p_location_id);
43: END IF;
44:
45: d_progress := '100';
46:

Line 64: PO_DEBUG.debug_var(d_module, d_progress, 'l_temp_location_id', l_temp_location_id);

60: l_temp_location_id := NULL;
61: END;
62:
63: IF (g_debug_stmt) THEN
64: PO_DEBUG.debug_var(d_module, d_progress, 'l_temp_location_id', l_temp_location_id);
65: END IF;
66:
67: d_progress := '130';
68:

Line 150: PO_DEBUG.debug_unexp(d_module, d_progress, 'Exception occurred retrieving location');

146:
147: EXCEPTION
148: WHEN OTHERS THEN
149: IF (g_debug_unexp) THEN
150: PO_DEBUG.debug_unexp(d_module, d_progress, 'Exception occurred retrieving location');
151: END IF;
152: x_address_line_1 := '';
153: x_address_line_2 := '';
154: x_address_line_3 := '';

Line 233: PO_DEBUG.debug_unexp(d_module, d_progress, 'Exception occurred retrieving location');

229:
230: EXCEPTION
231: WHEN OTHERS THEN
232: IF (g_debug_unexp) THEN
233: PO_DEBUG.debug_unexp(d_module, d_progress, 'Exception occurred retrieving location');
234: END IF;
235: x_address_line_1 := '';
236: x_address_line_2 := '';
237: x_address_line_3 := '';

Line 251: PO_DEBUG.debug_var(d_module, d_progress, 'x_address_line_1', x_address_line_1);

247:
248: d_progress := '140';
249:
250: IF (g_debug_stmt) THEN
251: PO_DEBUG.debug_var(d_module, d_progress, 'x_address_line_1', x_address_line_1);
252: PO_DEBUG.debug_var(d_module, d_progress, 'x_address_line_2', x_address_line_2);
253: PO_DEBUG.debug_var(d_module, d_progress, 'x_address_line_3', x_address_line_3);
254: PO_DEBUG.debug_var(d_module, d_progress, 'x_town_or_city', x_town_or_city);
255: PO_DEBUG.debug_var(d_module, d_progress, 'x_state_or_province', x_state_or_province);

Line 252: PO_DEBUG.debug_var(d_module, d_progress, 'x_address_line_2', x_address_line_2);

248: d_progress := '140';
249:
250: IF (g_debug_stmt) THEN
251: PO_DEBUG.debug_var(d_module, d_progress, 'x_address_line_1', x_address_line_1);
252: PO_DEBUG.debug_var(d_module, d_progress, 'x_address_line_2', x_address_line_2);
253: PO_DEBUG.debug_var(d_module, d_progress, 'x_address_line_3', x_address_line_3);
254: PO_DEBUG.debug_var(d_module, d_progress, 'x_town_or_city', x_town_or_city);
255: PO_DEBUG.debug_var(d_module, d_progress, 'x_state_or_province', x_state_or_province);
256: PO_DEBUG.debug_var(d_module, d_progress, 'x_postal_code', x_postal_code);

Line 253: PO_DEBUG.debug_var(d_module, d_progress, 'x_address_line_3', x_address_line_3);

249:
250: IF (g_debug_stmt) THEN
251: PO_DEBUG.debug_var(d_module, d_progress, 'x_address_line_1', x_address_line_1);
252: PO_DEBUG.debug_var(d_module, d_progress, 'x_address_line_2', x_address_line_2);
253: PO_DEBUG.debug_var(d_module, d_progress, 'x_address_line_3', x_address_line_3);
254: PO_DEBUG.debug_var(d_module, d_progress, 'x_town_or_city', x_town_or_city);
255: PO_DEBUG.debug_var(d_module, d_progress, 'x_state_or_province', x_state_or_province);
256: PO_DEBUG.debug_var(d_module, d_progress, 'x_postal_code', x_postal_code);
257: PO_DEBUG.debug_var(d_module, d_progress, 'x_territory_short_name', x_territory_short_name);

Line 254: PO_DEBUG.debug_var(d_module, d_progress, 'x_town_or_city', x_town_or_city);

250: IF (g_debug_stmt) THEN
251: PO_DEBUG.debug_var(d_module, d_progress, 'x_address_line_1', x_address_line_1);
252: PO_DEBUG.debug_var(d_module, d_progress, 'x_address_line_2', x_address_line_2);
253: PO_DEBUG.debug_var(d_module, d_progress, 'x_address_line_3', x_address_line_3);
254: PO_DEBUG.debug_var(d_module, d_progress, 'x_town_or_city', x_town_or_city);
255: PO_DEBUG.debug_var(d_module, d_progress, 'x_state_or_province', x_state_or_province);
256: PO_DEBUG.debug_var(d_module, d_progress, 'x_postal_code', x_postal_code);
257: PO_DEBUG.debug_var(d_module, d_progress, 'x_territory_short_name', x_territory_short_name);
258: PO_DEBUG.debug_var(d_module, d_progress, 'x_iso_territory_code', x_iso_territory_code);

Line 255: PO_DEBUG.debug_var(d_module, d_progress, 'x_state_or_province', x_state_or_province);

251: PO_DEBUG.debug_var(d_module, d_progress, 'x_address_line_1', x_address_line_1);
252: PO_DEBUG.debug_var(d_module, d_progress, 'x_address_line_2', x_address_line_2);
253: PO_DEBUG.debug_var(d_module, d_progress, 'x_address_line_3', x_address_line_3);
254: PO_DEBUG.debug_var(d_module, d_progress, 'x_town_or_city', x_town_or_city);
255: PO_DEBUG.debug_var(d_module, d_progress, 'x_state_or_province', x_state_or_province);
256: PO_DEBUG.debug_var(d_module, d_progress, 'x_postal_code', x_postal_code);
257: PO_DEBUG.debug_var(d_module, d_progress, 'x_territory_short_name', x_territory_short_name);
258: PO_DEBUG.debug_var(d_module, d_progress, 'x_iso_territory_code', x_iso_territory_code);
259: PO_DEBUG.debug_end(d_module);

Line 256: PO_DEBUG.debug_var(d_module, d_progress, 'x_postal_code', x_postal_code);

252: PO_DEBUG.debug_var(d_module, d_progress, 'x_address_line_2', x_address_line_2);
253: PO_DEBUG.debug_var(d_module, d_progress, 'x_address_line_3', x_address_line_3);
254: PO_DEBUG.debug_var(d_module, d_progress, 'x_town_or_city', x_town_or_city);
255: PO_DEBUG.debug_var(d_module, d_progress, 'x_state_or_province', x_state_or_province);
256: PO_DEBUG.debug_var(d_module, d_progress, 'x_postal_code', x_postal_code);
257: PO_DEBUG.debug_var(d_module, d_progress, 'x_territory_short_name', x_territory_short_name);
258: PO_DEBUG.debug_var(d_module, d_progress, 'x_iso_territory_code', x_iso_territory_code);
259: PO_DEBUG.debug_end(d_module);
260: END IF;

Line 257: PO_DEBUG.debug_var(d_module, d_progress, 'x_territory_short_name', x_territory_short_name);

253: PO_DEBUG.debug_var(d_module, d_progress, 'x_address_line_3', x_address_line_3);
254: PO_DEBUG.debug_var(d_module, d_progress, 'x_town_or_city', x_town_or_city);
255: PO_DEBUG.debug_var(d_module, d_progress, 'x_state_or_province', x_state_or_province);
256: PO_DEBUG.debug_var(d_module, d_progress, 'x_postal_code', x_postal_code);
257: PO_DEBUG.debug_var(d_module, d_progress, 'x_territory_short_name', x_territory_short_name);
258: PO_DEBUG.debug_var(d_module, d_progress, 'x_iso_territory_code', x_iso_territory_code);
259: PO_DEBUG.debug_end(d_module);
260: END IF;
261:

Line 258: PO_DEBUG.debug_var(d_module, d_progress, 'x_iso_territory_code', x_iso_territory_code);

254: PO_DEBUG.debug_var(d_module, d_progress, 'x_town_or_city', x_town_or_city);
255: PO_DEBUG.debug_var(d_module, d_progress, 'x_state_or_province', x_state_or_province);
256: PO_DEBUG.debug_var(d_module, d_progress, 'x_postal_code', x_postal_code);
257: PO_DEBUG.debug_var(d_module, d_progress, 'x_territory_short_name', x_territory_short_name);
258: PO_DEBUG.debug_var(d_module, d_progress, 'x_iso_territory_code', x_iso_territory_code);
259: PO_DEBUG.debug_end(d_module);
260: END IF;
261:
262: EXCEPTION

Line 259: PO_DEBUG.debug_end(d_module);

255: PO_DEBUG.debug_var(d_module, d_progress, 'x_state_or_province', x_state_or_province);
256: PO_DEBUG.debug_var(d_module, d_progress, 'x_postal_code', x_postal_code);
257: PO_DEBUG.debug_var(d_module, d_progress, 'x_territory_short_name', x_territory_short_name);
258: PO_DEBUG.debug_var(d_module, d_progress, 'x_iso_territory_code', x_iso_territory_code);
259: PO_DEBUG.debug_end(d_module);
260: END IF;
261:
262: EXCEPTION
263: WHEN OTHERS THEN

Line 265: PO_DEBUG.debug_unexp(d_module, d_progress, 'Exception occurred retrieving location');

261:
262: EXCEPTION
263: WHEN OTHERS THEN
264: IF (g_debug_unexp) THEN
265: PO_DEBUG.debug_unexp(d_module, d_progress, 'Exception occurred retrieving location');
266: END IF;
267:
268: x_address_line_1 := '';
269: x_address_line_2 := '';