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 101: pnp_debug_pkg.debug(l_desc ||' (+)');

97: l_uniq_loc_count NUMBER := 0; --Bug#5571818
98: INVALID_LOC_CODE EXCEPTION; --Bug#5571818
99:
100: BEGIN
101: pnp_debug_pkg.debug(l_desc ||' (+)');
102:
103: l_info := 'initializing pl/sql tables ';
104: loc_id_tbl.delete;
105: als_nm_tbl.delete;

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

158: last_update_login = nvl(fnd_profile.value('USER_ID'), -1)
159: WHERE location_id = loc_id_tbl(i)
160: AND NVL(TRUNC(ACTIVE_END_DATE), TRUNC(SYSDATE)) >= TRUNC(SYSDATE); /* Bug 6735518 */
161:
162: pnp_debug_pkg.debug(l_desc ||' (-)');
163:
164: EXCEPTION
165: --Bug#5571818
166: WHEN INVALID_LOC_CODE THEN

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

164: EXCEPTION
165: --Bug#5571818
166: WHEN INVALID_LOC_CODE THEN
167: fnd_message.set_name ('PN','PN_LOCN_TYPE_CODE_DUP');
168: pnp_debug_pkg.put_log_msg(fnd_message.get);
169: raise;
170: WHEN OTHERS THEN
171: pnp_debug_pkg.log(l_desc || ': Error while ' || l_info);
172: raise;

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

167: fnd_message.set_name ('PN','PN_LOCN_TYPE_CODE_DUP');
168: pnp_debug_pkg.put_log_msg(fnd_message.get);
169: raise;
170: WHEN OTHERS THEN
171: pnp_debug_pkg.log(l_desc || ': Error while ' || l_info);
172: raise;
173:
174: END change_alias;
175: