DBA Data[Home] [Help]

APPS.WSH_BOLS_UTIL_PKG dependencies on WSH_DEBUG_SV

Line 34: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

30: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
31: --
32: IF l_debug_on IS NULL
33: THEN
34: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
35: END IF;
36: --
37: IF l_debug_on THEN
38: WSH_DEBUG_SV.push(l_module_name);

Line 38: WSH_DEBUG_SV.push(l_module_name);

34: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
35: END IF;
36: --
37: IF l_debug_on THEN
38: WSH_DEBUG_SV.push(l_module_name);
39: --
40: WSH_DEBUG_SV.log(l_module_name,'P_ORG_STRING',P_ORG_STRING);
41: WSH_DEBUG_SV.log(l_module_name,'P_MODE',P_MODE);
42: END IF;

Line 40: WSH_DEBUG_SV.log(l_module_name,'P_ORG_STRING',P_ORG_STRING);

36: --
37: IF l_debug_on THEN
38: WSH_DEBUG_SV.push(l_module_name);
39: --
40: WSH_DEBUG_SV.log(l_module_name,'P_ORG_STRING',P_ORG_STRING);
41: WSH_DEBUG_SV.log(l_module_name,'P_MODE',P_MODE);
42: END IF;
43: --
44: IF p_mode = 'WEB' THEN

Line 41: WSH_DEBUG_SV.log(l_module_name,'P_MODE',P_MODE);

37: IF l_debug_on THEN
38: WSH_DEBUG_SV.push(l_module_name);
39: --
40: WSH_DEBUG_SV.log(l_module_name,'P_ORG_STRING',P_ORG_STRING);
41: WSH_DEBUG_SV.log(l_module_name,'P_MODE',P_MODE);
42: END IF;
43: --
44: IF p_mode = 'WEB' THEN
45: l_org_string := (p_org_string || '
');

Line 54: WSH_DEBUG_SV.log(l_module_name,'L_ORG_STRING',l_org_string);

50: --
51: -- Debug Statements
52: --
53: IF l_debug_on THEN
54: WSH_DEBUG_SV.log(l_module_name,'L_ORG_STRING',l_org_string);
55: WSH_DEBUG_SV.pop(l_module_name);
56: END IF;
57: --
58: RETURN (l_org_string);

Line 55: WSH_DEBUG_SV.pop(l_module_name);

51: -- Debug Statements
52: --
53: IF l_debug_on THEN
54: WSH_DEBUG_SV.log(l_module_name,'L_ORG_STRING',l_org_string);
55: WSH_DEBUG_SV.pop(l_module_name);
56: END IF;
57: --
58: RETURN (l_org_string);
59: EXCEPTION

Line 66: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

62: --
63: -- Debug Statements
64: --
65: IF l_debug_on THEN
66: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
67: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
68: END IF;
69: --
70: END concat_eol;

Line 67: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

63: -- Debug Statements
64: --
65: IF l_debug_on THEN
66: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
67: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
68: END IF;
69: --
70: END concat_eol;
71:

Line 100: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

96: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
97: --
98: IF l_debug_on IS NULL
99: THEN
100: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
101: END IF;
102: --
103: IF l_debug_on THEN
104: WSH_DEBUG_SV.push(l_module_name);

Line 104: WSH_DEBUG_SV.push(l_module_name);

100: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
101: END IF;
102: --
103: IF l_debug_on THEN
104: WSH_DEBUG_SV.push(l_module_name);
105: --
106: WSH_DEBUG_SV.log(l_module_name,'P_ORG_STRING',P_ORG_STRING);
107: WSH_DEBUG_SV.log(l_module_name,'P_MODE',P_MODE);
108: END IF;

Line 106: WSH_DEBUG_SV.log(l_module_name,'P_ORG_STRING',P_ORG_STRING);

102: --
103: IF l_debug_on THEN
104: WSH_DEBUG_SV.push(l_module_name);
105: --
106: WSH_DEBUG_SV.log(l_module_name,'P_ORG_STRING',P_ORG_STRING);
107: WSH_DEBUG_SV.log(l_module_name,'P_MODE',P_MODE);
108: END IF;
109: --
110: IF p_mode = 'WEB' THEN

Line 107: WSH_DEBUG_SV.log(l_module_name,'P_MODE',P_MODE);

103: IF l_debug_on THEN
104: WSH_DEBUG_SV.push(l_module_name);
105: --
106: WSH_DEBUG_SV.log(l_module_name,'P_ORG_STRING',P_ORG_STRING);
107: WSH_DEBUG_SV.log(l_module_name,'P_MODE',P_MODE);
108: END IF;
109: --
110: IF p_mode = 'WEB' THEN
111: l_org_string := (p_org_string || '
');

Line 120: WSH_DEBUG_SV.log(l_module_name,'L_ORG_STRING',l_org_string);

116: --
117: -- Debug Statements
118: --
119: IF l_debug_on THEN
120: WSH_DEBUG_SV.log(l_module_name,'L_ORG_STRING',l_org_string);
121: WSH_DEBUG_SV.pop(l_module_name);
122: END IF;
123: --
124: RETURN (l_org_string);

Line 121: WSH_DEBUG_SV.pop(l_module_name);

117: -- Debug Statements
118: --
119: IF l_debug_on THEN
120: WSH_DEBUG_SV.log(l_module_name,'L_ORG_STRING',l_org_string);
121: WSH_DEBUG_SV.pop(l_module_name);
122: END IF;
123: --
124: RETURN (l_org_string);
125: EXCEPTION

Line 132: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

128: --
129: -- Debug Statements
130: --
131: IF l_debug_on THEN
132: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
133: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
134: END IF;
135: --
136: END concat_eol2;

Line 133: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

129: -- Debug Statements
130: --
131: IF l_debug_on THEN
132: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
133: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
134: END IF;
135: --
136: END concat_eol2;
137:

Line 173: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

169: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
170: --
171: IF l_debug_on IS NULL
172: THEN
173: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
174: END IF;
175: --
176: IF l_debug_on THEN
177: WSH_DEBUG_SV.push(l_module_name);

Line 177: WSH_DEBUG_SV.push(l_module_name);

173: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
174: END IF;
175: --
176: IF l_debug_on THEN
177: WSH_DEBUG_SV.push(l_module_name);
178: --
179: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION_MODE',P_DESCRIPTION_MODE);
180: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
181: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);

Line 179: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION_MODE',P_DESCRIPTION_MODE);

175: --
176: IF l_debug_on THEN
177: WSH_DEBUG_SV.push(l_module_name);
178: --
179: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION_MODE',P_DESCRIPTION_MODE);
180: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
181: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
182: WSH_DEBUG_SV.log(l_module_name,'P_ITEM_DESCRIPTION',P_ITEM_DESCRIPTION);
183: END IF;

Line 180: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);

176: IF l_debug_on THEN
177: WSH_DEBUG_SV.push(l_module_name);
178: --
179: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION_MODE',P_DESCRIPTION_MODE);
180: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
181: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
182: WSH_DEBUG_SV.log(l_module_name,'P_ITEM_DESCRIPTION',P_ITEM_DESCRIPTION);
183: END IF;
184: --

Line 181: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);

177: WSH_DEBUG_SV.push(l_module_name);
178: --
179: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION_MODE',P_DESCRIPTION_MODE);
180: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
181: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
182: WSH_DEBUG_SV.log(l_module_name,'P_ITEM_DESCRIPTION',P_ITEM_DESCRIPTION);
183: END IF;
184: --
185: IF p_description_mode = 'D' THEN

Line 182: WSH_DEBUG_SV.log(l_module_name,'P_ITEM_DESCRIPTION',P_ITEM_DESCRIPTION);

178: --
179: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION_MODE',P_DESCRIPTION_MODE);
180: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
181: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
182: WSH_DEBUG_SV.log(l_module_name,'P_ITEM_DESCRIPTION',P_ITEM_DESCRIPTION);
183: END IF;
184: --
185: IF p_description_mode = 'D' THEN
186: --

Line 190: WSH_DEBUG_SV.pop(l_module_name);

186: --
187: -- Debug Statements
188: --
189: IF l_debug_on THEN
190: WSH_DEBUG_SV.pop(l_module_name);
191: END IF;
192: -- Bug# 3306781
193: l_description := p_item_description;
194: IF p_inventory_item_id IS NOT NULL THEN

Line 210: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GENERIC_FLEX_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

206: --
207: -- Debug Statements
208: --
209: IF l_debug_on THEN
210: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GENERIC_FLEX_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
211: END IF;
212: --
213: -- Debug Statements
214: --

Line 216: WSH_DEBUG_SV.pop(l_module_name);

212: --
213: -- Debug Statements
214: --
215: IF l_debug_on THEN
216: WSH_DEBUG_SV.pop(l_module_name);
217: END IF;
218: --
219: -- LSP PROJECT :
220: /*RETURN wsh_util_core.generic_flex_name(p_inventory_item_id,

Line 240: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GENERIC_FLEX_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

236: --
237: -- Debug Statements
238: --
239: IF l_debug_on THEN
240: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GENERIC_FLEX_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
241: END IF;
242: --
243: -- Debug Statements
244: --

Line 246: WSH_DEBUG_SV.pop(l_module_name);

242: --
243: -- Debug Statements
244: --
245: IF l_debug_on THEN
246: WSH_DEBUG_SV.pop(l_module_name);
247: END IF;
248: --
249: -- Bug# 3306781
250: l_description := p_item_description;

Line 274: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

270: --
271: -- Debug Statements
272: --
273: IF l_debug_on THEN
274: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
275: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
276: END IF;
277: --
278: END encode_desc;

Line 275: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

271: -- Debug Statements
272: --
273: IF l_debug_on THEN
274: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
275: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
276: END IF;
277: --
278: END encode_desc;
279:

Line 433: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

429: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
430: --
431: IF l_debug_on IS NULL
432: THEN
433: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
434: END IF;
435: --
436: IF l_debug_on THEN
437: WSH_DEBUG_SV.push(l_module_name);

Line 437: WSH_DEBUG_SV.push(l_module_name);

433: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
434: END IF;
435: --
436: IF l_debug_on THEN
437: WSH_DEBUG_SV.push(l_module_name);
438: --
439: WSH_DEBUG_SV.log(l_module_name,'P_MASTER_CONTAINER_ID',P_MASTER_CONTAINER_ID);
440: WSH_DEBUG_SV.log(l_module_name,'P_OUTPUT_MODE',P_OUTPUT_MODE);
441: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION_MODE',P_DESCRIPTION_MODE);

Line 439: WSH_DEBUG_SV.log(l_module_name,'P_MASTER_CONTAINER_ID',P_MASTER_CONTAINER_ID);

435: --
436: IF l_debug_on THEN
437: WSH_DEBUG_SV.push(l_module_name);
438: --
439: WSH_DEBUG_SV.log(l_module_name,'P_MASTER_CONTAINER_ID',P_MASTER_CONTAINER_ID);
440: WSH_DEBUG_SV.log(l_module_name,'P_OUTPUT_MODE',P_OUTPUT_MODE);
441: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION_MODE',P_DESCRIPTION_MODE);
442: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
443: WSH_DEBUG_SV.log(l_module_name,'X_DATA_ITEM_CLASSIFICATION',X_DATA_ITEM_CLASSIFICATION);

Line 440: WSH_DEBUG_SV.log(l_module_name,'P_OUTPUT_MODE',P_OUTPUT_MODE);

436: IF l_debug_on THEN
437: WSH_DEBUG_SV.push(l_module_name);
438: --
439: WSH_DEBUG_SV.log(l_module_name,'P_MASTER_CONTAINER_ID',P_MASTER_CONTAINER_ID);
440: WSH_DEBUG_SV.log(l_module_name,'P_OUTPUT_MODE',P_OUTPUT_MODE);
441: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION_MODE',P_DESCRIPTION_MODE);
442: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
443: WSH_DEBUG_SV.log(l_module_name,'X_DATA_ITEM_CLASSIFICATION',X_DATA_ITEM_CLASSIFICATION);
444: WSH_DEBUG_SV.log(l_module_name,'X_CONTAINER_CONTENTS',X_CONTAINER_CONTENTS);

Line 441: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION_MODE',P_DESCRIPTION_MODE);

437: WSH_DEBUG_SV.push(l_module_name);
438: --
439: WSH_DEBUG_SV.log(l_module_name,'P_MASTER_CONTAINER_ID',P_MASTER_CONTAINER_ID);
440: WSH_DEBUG_SV.log(l_module_name,'P_OUTPUT_MODE',P_OUTPUT_MODE);
441: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION_MODE',P_DESCRIPTION_MODE);
442: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
443: WSH_DEBUG_SV.log(l_module_name,'X_DATA_ITEM_CLASSIFICATION',X_DATA_ITEM_CLASSIFICATION);
444: WSH_DEBUG_SV.log(l_module_name,'X_CONTAINER_CONTENTS',X_CONTAINER_CONTENTS);
445: WSH_DEBUG_SV.log(l_module_name,'X_HAZARD_CODE',X_HAZARD_CODE);

Line 442: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);

438: --
439: WSH_DEBUG_SV.log(l_module_name,'P_MASTER_CONTAINER_ID',P_MASTER_CONTAINER_ID);
440: WSH_DEBUG_SV.log(l_module_name,'P_OUTPUT_MODE',P_OUTPUT_MODE);
441: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION_MODE',P_DESCRIPTION_MODE);
442: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
443: WSH_DEBUG_SV.log(l_module_name,'X_DATA_ITEM_CLASSIFICATION',X_DATA_ITEM_CLASSIFICATION);
444: WSH_DEBUG_SV.log(l_module_name,'X_CONTAINER_CONTENTS',X_CONTAINER_CONTENTS);
445: WSH_DEBUG_SV.log(l_module_name,'X_HAZARD_CODE',X_HAZARD_CODE);
446: WSH_DEBUG_SV.log(l_module_name,'X_NUM_OF_PACKAGES',X_NUM_OF_PACKAGES);

Line 443: WSH_DEBUG_SV.log(l_module_name,'X_DATA_ITEM_CLASSIFICATION',X_DATA_ITEM_CLASSIFICATION);

439: WSH_DEBUG_SV.log(l_module_name,'P_MASTER_CONTAINER_ID',P_MASTER_CONTAINER_ID);
440: WSH_DEBUG_SV.log(l_module_name,'P_OUTPUT_MODE',P_OUTPUT_MODE);
441: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION_MODE',P_DESCRIPTION_MODE);
442: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
443: WSH_DEBUG_SV.log(l_module_name,'X_DATA_ITEM_CLASSIFICATION',X_DATA_ITEM_CLASSIFICATION);
444: WSH_DEBUG_SV.log(l_module_name,'X_CONTAINER_CONTENTS',X_CONTAINER_CONTENTS);
445: WSH_DEBUG_SV.log(l_module_name,'X_HAZARD_CODE',X_HAZARD_CODE);
446: WSH_DEBUG_SV.log(l_module_name,'X_NUM_OF_PACKAGES',X_NUM_OF_PACKAGES);
447: END IF;

Line 444: WSH_DEBUG_SV.log(l_module_name,'X_CONTAINER_CONTENTS',X_CONTAINER_CONTENTS);

440: WSH_DEBUG_SV.log(l_module_name,'P_OUTPUT_MODE',P_OUTPUT_MODE);
441: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION_MODE',P_DESCRIPTION_MODE);
442: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
443: WSH_DEBUG_SV.log(l_module_name,'X_DATA_ITEM_CLASSIFICATION',X_DATA_ITEM_CLASSIFICATION);
444: WSH_DEBUG_SV.log(l_module_name,'X_CONTAINER_CONTENTS',X_CONTAINER_CONTENTS);
445: WSH_DEBUG_SV.log(l_module_name,'X_HAZARD_CODE',X_HAZARD_CODE);
446: WSH_DEBUG_SV.log(l_module_name,'X_NUM_OF_PACKAGES',X_NUM_OF_PACKAGES);
447: END IF;
448: --

Line 445: WSH_DEBUG_SV.log(l_module_name,'X_HAZARD_CODE',X_HAZARD_CODE);

441: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION_MODE',P_DESCRIPTION_MODE);
442: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
443: WSH_DEBUG_SV.log(l_module_name,'X_DATA_ITEM_CLASSIFICATION',X_DATA_ITEM_CLASSIFICATION);
444: WSH_DEBUG_SV.log(l_module_name,'X_CONTAINER_CONTENTS',X_CONTAINER_CONTENTS);
445: WSH_DEBUG_SV.log(l_module_name,'X_HAZARD_CODE',X_HAZARD_CODE);
446: WSH_DEBUG_SV.log(l_module_name,'X_NUM_OF_PACKAGES',X_NUM_OF_PACKAGES);
447: END IF;
448: --
449: fnd_message.set_name('WSH','WSH_WEB_CONTAINS_LABEL');

Line 446: WSH_DEBUG_SV.log(l_module_name,'X_NUM_OF_PACKAGES',X_NUM_OF_PACKAGES);

442: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
443: WSH_DEBUG_SV.log(l_module_name,'X_DATA_ITEM_CLASSIFICATION',X_DATA_ITEM_CLASSIFICATION);
444: WSH_DEBUG_SV.log(l_module_name,'X_CONTAINER_CONTENTS',X_CONTAINER_CONTENTS);
445: WSH_DEBUG_SV.log(l_module_name,'X_HAZARD_CODE',X_HAZARD_CODE);
446: WSH_DEBUG_SV.log(l_module_name,'X_NUM_OF_PACKAGES',X_NUM_OF_PACKAGES);
447: END IF;
448: --
449: fnd_message.set_name('WSH','WSH_WEB_CONTAINS_LABEL');
450: l_contains_label := fnd_message.get;

Line 731: WSH_DEBUG_SV.log(l_module_name,'X_NUM_OF_PACKAGES',x_num_of_packages);

727: --
728: -- Debug Statements
729: --
730: IF l_debug_on THEN
731: WSH_DEBUG_SV.log(l_module_name,'X_NUM_OF_PACKAGES',x_num_of_packages);
732: WSH_DEBUG_SV.pop(l_module_name);
733: END IF;
734: --
735: EXCEPTION

Line 732: WSH_DEBUG_SV.pop(l_module_name);

728: -- Debug Statements
729: --
730: IF l_debug_on THEN
731: WSH_DEBUG_SV.log(l_module_name,'X_NUM_OF_PACKAGES',x_num_of_packages);
732: WSH_DEBUG_SV.pop(l_module_name);
733: END IF;
734: --
735: EXCEPTION
736: WHEN others THEN

Line 744: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

740: --
741: -- Debug Statements
742: --
743: IF l_debug_on THEN
744: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
745: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
746: END IF;
747: --
748: END get_master_container_contents;

Line 745: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

741: -- Debug Statements
742: --
743: IF l_debug_on THEN
744: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
745: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
746: END IF;
747: --
748: END get_master_container_contents;
749: