APPS.PN_LOCATION_ALIAS_PKG dependencies on PNP_DEBUG_PKG

Line 28: pnp_debug_pkg.debug(l_desc ||' (+)');

24: l_info VARCHAR2(300);
25: l_desc VARCHAR2(300) := 'pn_location_alias_pkg.get_parent_location_code';
26: l_result pn_locations.location_code%TYPE := '';
27: BEGIN
28: pnp_debug_pkg.debug(l_desc ||' (+)');
29:
30: l_info := 'starting loop ';
31: FOR i IN REVERSE 0 .. p_id_tbl.COUNT - 1 LOOP
32: IF p_id_tbl(i) = p_loc_id THEN

Line 40: pnp_debug_pkg.debug(l_desc ||' (-)');

36: END LOOP;
37:
38: RETURN l_result;
39:
40: pnp_debug_pkg.debug(l_desc ||' (-)');
41:
42: EXCEPTION
43: WHEN OTHERS THEN
44: pnp_debug_pkg.log(l_desc || ': Error while ' || l_info);

Line 44: pnp_debug_pkg.log(l_desc || ': Error while ' || l_info);

40: pnp_debug_pkg.debug(l_desc ||' (-)');
41:
42: EXCEPTION
43: WHEN OTHERS THEN
44: pnp_debug_pkg.log(l_desc || ': Error while ' || l_info);
45: raise;
46: END get_parent_location_code;
47:
48: ------------------------------------------------------------------------------+

Line 108: pnp_debug_pkg.debug(l_desc ||' (+)');

104: INVALID_LOC_CODE EXCEPTION; --Bug#5571818
105: l_new_loc_code VARCHAR2(300); -- Bug#16098151
106:
107: BEGIN
108: pnp_debug_pkg.debug(l_desc ||' (+)');
109:
110: l_info := 'initializing pl/sql tables ';
111: loc_id_tbl.delete;
112: als_nm_tbl.delete;

Line 173: pnp_debug_pkg.debug(l_desc ||' (-)');

169: last_updated_by = nvl(fnd_profile.value('USER_ID'), -1),
170: last_update_login = nvl(fnd_profile.value('USER_ID'), -1)
171: WHERE location_id = loc_id_tbl(i);
172:
173: pnp_debug_pkg.debug(l_desc ||' (-)');
174:
175: EXCEPTION
176: --Bug#5571818
177: WHEN INVALID_LOC_CODE THEN

Line 179: pnp_debug_pkg.put_log_msg(fnd_message.get);

175: EXCEPTION
176: --Bug#5571818
177: WHEN INVALID_LOC_CODE THEN
178: fnd_message.set_name ('PN','PN_LOCN_TYPE_CODE_DUP');
179: pnp_debug_pkg.put_log_msg(fnd_message.get);
180: raise;
181: WHEN OTHERS THEN
182: pnp_debug_pkg.log(l_desc || ': Error while ' || l_info);
183: raise;

Line 182: pnp_debug_pkg.log(l_desc || ': Error while ' || l_info);

178: fnd_message.set_name ('PN','PN_LOCN_TYPE_CODE_DUP');
179: pnp_debug_pkg.put_log_msg(fnd_message.get);
180: raise;
181: WHEN OTHERS THEN
182: pnp_debug_pkg.log(l_desc || ': Error while ' || l_info);
183: raise;
184:
185: END change_alias;
186: