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 139: PO_DEBUG.debug_unexp(d_module, d_progress, 'Exception occurred retrieving location');

135:
136: EXCEPTION
137: WHEN OTHERS THEN
138: IF (g_debug_unexp) THEN
139: PO_DEBUG.debug_unexp(d_module, d_progress, 'Exception occurred retrieving location');
140: END IF;
141: x_address_line_1 := '';
142: x_address_line_2 := '';
143: x_address_line_3 := '';

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

218:
219: EXCEPTION
220: WHEN OTHERS THEN
221: IF (g_debug_unexp) THEN
222: PO_DEBUG.debug_unexp(d_module, d_progress, 'Exception occurred retrieving location');
223: END IF;
224: x_address_line_1 := '';
225: x_address_line_2 := '';
226: x_address_line_3 := '';

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

236:
237: d_progress := '140';
238:
239: IF (g_debug_stmt) THEN
240: PO_DEBUG.debug_var(d_module, d_progress, 'x_address_line_1', x_address_line_1);
241: PO_DEBUG.debug_var(d_module, d_progress, 'x_address_line_2', x_address_line_2);
242: PO_DEBUG.debug_var(d_module, d_progress, 'x_address_line_3', x_address_line_3);
243: PO_DEBUG.debug_var(d_module, d_progress, 'x_town_or_city', x_town_or_city);
244: PO_DEBUG.debug_var(d_module, d_progress, 'x_state_or_province', x_state_or_province);

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

237: d_progress := '140';
238:
239: IF (g_debug_stmt) THEN
240: PO_DEBUG.debug_var(d_module, d_progress, 'x_address_line_1', x_address_line_1);
241: PO_DEBUG.debug_var(d_module, d_progress, 'x_address_line_2', x_address_line_2);
242: PO_DEBUG.debug_var(d_module, d_progress, 'x_address_line_3', x_address_line_3);
243: PO_DEBUG.debug_var(d_module, d_progress, 'x_town_or_city', x_town_or_city);
244: PO_DEBUG.debug_var(d_module, d_progress, 'x_state_or_province', x_state_or_province);
245: PO_DEBUG.debug_var(d_module, d_progress, 'x_postal_code', x_postal_code);

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

238:
239: IF (g_debug_stmt) THEN
240: PO_DEBUG.debug_var(d_module, d_progress, 'x_address_line_1', x_address_line_1);
241: PO_DEBUG.debug_var(d_module, d_progress, 'x_address_line_2', x_address_line_2);
242: PO_DEBUG.debug_var(d_module, d_progress, 'x_address_line_3', x_address_line_3);
243: PO_DEBUG.debug_var(d_module, d_progress, 'x_town_or_city', x_town_or_city);
244: PO_DEBUG.debug_var(d_module, d_progress, 'x_state_or_province', x_state_or_province);
245: PO_DEBUG.debug_var(d_module, d_progress, 'x_postal_code', x_postal_code);
246: PO_DEBUG.debug_var(d_module, d_progress, 'x_territory_short_name', x_territory_short_name);

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

239: IF (g_debug_stmt) THEN
240: PO_DEBUG.debug_var(d_module, d_progress, 'x_address_line_1', x_address_line_1);
241: PO_DEBUG.debug_var(d_module, d_progress, 'x_address_line_2', x_address_line_2);
242: PO_DEBUG.debug_var(d_module, d_progress, 'x_address_line_3', x_address_line_3);
243: PO_DEBUG.debug_var(d_module, d_progress, 'x_town_or_city', x_town_or_city);
244: PO_DEBUG.debug_var(d_module, d_progress, 'x_state_or_province', x_state_or_province);
245: PO_DEBUG.debug_var(d_module, d_progress, 'x_postal_code', x_postal_code);
246: PO_DEBUG.debug_var(d_module, d_progress, 'x_territory_short_name', x_territory_short_name);
247: PO_DEBUG.debug_var(d_module, d_progress, 'x_iso_territory_code', x_iso_territory_code);

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

240: PO_DEBUG.debug_var(d_module, d_progress, 'x_address_line_1', x_address_line_1);
241: PO_DEBUG.debug_var(d_module, d_progress, 'x_address_line_2', x_address_line_2);
242: PO_DEBUG.debug_var(d_module, d_progress, 'x_address_line_3', x_address_line_3);
243: PO_DEBUG.debug_var(d_module, d_progress, 'x_town_or_city', x_town_or_city);
244: PO_DEBUG.debug_var(d_module, d_progress, 'x_state_or_province', x_state_or_province);
245: PO_DEBUG.debug_var(d_module, d_progress, 'x_postal_code', x_postal_code);
246: PO_DEBUG.debug_var(d_module, d_progress, 'x_territory_short_name', x_territory_short_name);
247: PO_DEBUG.debug_var(d_module, d_progress, 'x_iso_territory_code', x_iso_territory_code);
248: PO_DEBUG.debug_end(d_module);

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

241: PO_DEBUG.debug_var(d_module, d_progress, 'x_address_line_2', x_address_line_2);
242: PO_DEBUG.debug_var(d_module, d_progress, 'x_address_line_3', x_address_line_3);
243: PO_DEBUG.debug_var(d_module, d_progress, 'x_town_or_city', x_town_or_city);
244: PO_DEBUG.debug_var(d_module, d_progress, 'x_state_or_province', x_state_or_province);
245: PO_DEBUG.debug_var(d_module, d_progress, 'x_postal_code', x_postal_code);
246: PO_DEBUG.debug_var(d_module, d_progress, 'x_territory_short_name', x_territory_short_name);
247: PO_DEBUG.debug_var(d_module, d_progress, 'x_iso_territory_code', x_iso_territory_code);
248: PO_DEBUG.debug_end(d_module);
249: END IF;

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

242: PO_DEBUG.debug_var(d_module, d_progress, 'x_address_line_3', x_address_line_3);
243: PO_DEBUG.debug_var(d_module, d_progress, 'x_town_or_city', x_town_or_city);
244: PO_DEBUG.debug_var(d_module, d_progress, 'x_state_or_province', x_state_or_province);
245: PO_DEBUG.debug_var(d_module, d_progress, 'x_postal_code', x_postal_code);
246: PO_DEBUG.debug_var(d_module, d_progress, 'x_territory_short_name', x_territory_short_name);
247: PO_DEBUG.debug_var(d_module, d_progress, 'x_iso_territory_code', x_iso_territory_code);
248: PO_DEBUG.debug_end(d_module);
249: END IF;
250:

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

243: PO_DEBUG.debug_var(d_module, d_progress, 'x_town_or_city', x_town_or_city);
244: PO_DEBUG.debug_var(d_module, d_progress, 'x_state_or_province', x_state_or_province);
245: PO_DEBUG.debug_var(d_module, d_progress, 'x_postal_code', x_postal_code);
246: PO_DEBUG.debug_var(d_module, d_progress, 'x_territory_short_name', x_territory_short_name);
247: PO_DEBUG.debug_var(d_module, d_progress, 'x_iso_territory_code', x_iso_territory_code);
248: PO_DEBUG.debug_end(d_module);
249: END IF;
250:
251: EXCEPTION

Line 248: PO_DEBUG.debug_end(d_module);

244: PO_DEBUG.debug_var(d_module, d_progress, 'x_state_or_province', x_state_or_province);
245: PO_DEBUG.debug_var(d_module, d_progress, 'x_postal_code', x_postal_code);
246: PO_DEBUG.debug_var(d_module, d_progress, 'x_territory_short_name', x_territory_short_name);
247: PO_DEBUG.debug_var(d_module, d_progress, 'x_iso_territory_code', x_iso_territory_code);
248: PO_DEBUG.debug_end(d_module);
249: END IF;
250:
251: EXCEPTION
252: WHEN OTHERS THEN

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

250:
251: EXCEPTION
252: WHEN OTHERS THEN
253: IF (g_debug_unexp) THEN
254: PO_DEBUG.debug_unexp(d_module, d_progress, 'Exception occurred retrieving location');
255: END IF;
256:
257: x_address_line_1 := '';
258: x_address_line_2 := '';