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: RETURN wsh_util_core.generic_flex_name(p_inventory_item_id,
220: p_organization_id,

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

229: --
230: -- Debug Statements
231: --
232: IF l_debug_on THEN
233: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GENERIC_FLEX_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
234: END IF;
235: --
236: -- Debug Statements
237: --

Line 239: WSH_DEBUG_SV.pop(l_module_name);

235: --
236: -- Debug Statements
237: --
238: IF l_debug_on THEN
239: WSH_DEBUG_SV.pop(l_module_name);
240: END IF;
241: --
242: -- Bug# 3306781
243: l_description := p_item_description;

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

259: --
260: -- Debug Statements
261: --
262: IF l_debug_on THEN
263: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
264: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
265: END IF;
266: --
267: END encode_desc;

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

260: -- Debug Statements
261: --
262: IF l_debug_on THEN
263: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
264: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
265: END IF;
266: --
267: END encode_desc;
268:

Line 422: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

418: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
419: --
420: IF l_debug_on IS NULL
421: THEN
422: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
423: END IF;
424: --
425: IF l_debug_on THEN
426: WSH_DEBUG_SV.push(l_module_name);

Line 426: WSH_DEBUG_SV.push(l_module_name);

422: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
423: END IF;
424: --
425: IF l_debug_on THEN
426: WSH_DEBUG_SV.push(l_module_name);
427: --
428: WSH_DEBUG_SV.log(l_module_name,'P_MASTER_CONTAINER_ID',P_MASTER_CONTAINER_ID);
429: WSH_DEBUG_SV.log(l_module_name,'P_OUTPUT_MODE',P_OUTPUT_MODE);
430: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION_MODE',P_DESCRIPTION_MODE);

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

424: --
425: IF l_debug_on THEN
426: WSH_DEBUG_SV.push(l_module_name);
427: --
428: WSH_DEBUG_SV.log(l_module_name,'P_MASTER_CONTAINER_ID',P_MASTER_CONTAINER_ID);
429: WSH_DEBUG_SV.log(l_module_name,'P_OUTPUT_MODE',P_OUTPUT_MODE);
430: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION_MODE',P_DESCRIPTION_MODE);
431: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
432: WSH_DEBUG_SV.log(l_module_name,'X_DATA_ITEM_CLASSIFICATION',X_DATA_ITEM_CLASSIFICATION);

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

425: IF l_debug_on THEN
426: WSH_DEBUG_SV.push(l_module_name);
427: --
428: WSH_DEBUG_SV.log(l_module_name,'P_MASTER_CONTAINER_ID',P_MASTER_CONTAINER_ID);
429: WSH_DEBUG_SV.log(l_module_name,'P_OUTPUT_MODE',P_OUTPUT_MODE);
430: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION_MODE',P_DESCRIPTION_MODE);
431: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
432: WSH_DEBUG_SV.log(l_module_name,'X_DATA_ITEM_CLASSIFICATION',X_DATA_ITEM_CLASSIFICATION);
433: WSH_DEBUG_SV.log(l_module_name,'X_CONTAINER_CONTENTS',X_CONTAINER_CONTENTS);

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

426: WSH_DEBUG_SV.push(l_module_name);
427: --
428: WSH_DEBUG_SV.log(l_module_name,'P_MASTER_CONTAINER_ID',P_MASTER_CONTAINER_ID);
429: WSH_DEBUG_SV.log(l_module_name,'P_OUTPUT_MODE',P_OUTPUT_MODE);
430: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION_MODE',P_DESCRIPTION_MODE);
431: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
432: WSH_DEBUG_SV.log(l_module_name,'X_DATA_ITEM_CLASSIFICATION',X_DATA_ITEM_CLASSIFICATION);
433: WSH_DEBUG_SV.log(l_module_name,'X_CONTAINER_CONTENTS',X_CONTAINER_CONTENTS);
434: WSH_DEBUG_SV.log(l_module_name,'X_HAZARD_CODE',X_HAZARD_CODE);

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

427: --
428: WSH_DEBUG_SV.log(l_module_name,'P_MASTER_CONTAINER_ID',P_MASTER_CONTAINER_ID);
429: WSH_DEBUG_SV.log(l_module_name,'P_OUTPUT_MODE',P_OUTPUT_MODE);
430: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION_MODE',P_DESCRIPTION_MODE);
431: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
432: WSH_DEBUG_SV.log(l_module_name,'X_DATA_ITEM_CLASSIFICATION',X_DATA_ITEM_CLASSIFICATION);
433: WSH_DEBUG_SV.log(l_module_name,'X_CONTAINER_CONTENTS',X_CONTAINER_CONTENTS);
434: WSH_DEBUG_SV.log(l_module_name,'X_HAZARD_CODE',X_HAZARD_CODE);
435: WSH_DEBUG_SV.log(l_module_name,'X_NUM_OF_PACKAGES',X_NUM_OF_PACKAGES);

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

428: WSH_DEBUG_SV.log(l_module_name,'P_MASTER_CONTAINER_ID',P_MASTER_CONTAINER_ID);
429: WSH_DEBUG_SV.log(l_module_name,'P_OUTPUT_MODE',P_OUTPUT_MODE);
430: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION_MODE',P_DESCRIPTION_MODE);
431: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
432: WSH_DEBUG_SV.log(l_module_name,'X_DATA_ITEM_CLASSIFICATION',X_DATA_ITEM_CLASSIFICATION);
433: WSH_DEBUG_SV.log(l_module_name,'X_CONTAINER_CONTENTS',X_CONTAINER_CONTENTS);
434: WSH_DEBUG_SV.log(l_module_name,'X_HAZARD_CODE',X_HAZARD_CODE);
435: WSH_DEBUG_SV.log(l_module_name,'X_NUM_OF_PACKAGES',X_NUM_OF_PACKAGES);
436: END IF;

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

429: WSH_DEBUG_SV.log(l_module_name,'P_OUTPUT_MODE',P_OUTPUT_MODE);
430: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION_MODE',P_DESCRIPTION_MODE);
431: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
432: WSH_DEBUG_SV.log(l_module_name,'X_DATA_ITEM_CLASSIFICATION',X_DATA_ITEM_CLASSIFICATION);
433: WSH_DEBUG_SV.log(l_module_name,'X_CONTAINER_CONTENTS',X_CONTAINER_CONTENTS);
434: WSH_DEBUG_SV.log(l_module_name,'X_HAZARD_CODE',X_HAZARD_CODE);
435: WSH_DEBUG_SV.log(l_module_name,'X_NUM_OF_PACKAGES',X_NUM_OF_PACKAGES);
436: END IF;
437: --

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

430: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION_MODE',P_DESCRIPTION_MODE);
431: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
432: WSH_DEBUG_SV.log(l_module_name,'X_DATA_ITEM_CLASSIFICATION',X_DATA_ITEM_CLASSIFICATION);
433: WSH_DEBUG_SV.log(l_module_name,'X_CONTAINER_CONTENTS',X_CONTAINER_CONTENTS);
434: WSH_DEBUG_SV.log(l_module_name,'X_HAZARD_CODE',X_HAZARD_CODE);
435: WSH_DEBUG_SV.log(l_module_name,'X_NUM_OF_PACKAGES',X_NUM_OF_PACKAGES);
436: END IF;
437: --
438: fnd_message.set_name('WSH','WSH_WEB_CONTAINS_LABEL');

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

431: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
432: WSH_DEBUG_SV.log(l_module_name,'X_DATA_ITEM_CLASSIFICATION',X_DATA_ITEM_CLASSIFICATION);
433: WSH_DEBUG_SV.log(l_module_name,'X_CONTAINER_CONTENTS',X_CONTAINER_CONTENTS);
434: WSH_DEBUG_SV.log(l_module_name,'X_HAZARD_CODE',X_HAZARD_CODE);
435: WSH_DEBUG_SV.log(l_module_name,'X_NUM_OF_PACKAGES',X_NUM_OF_PACKAGES);
436: END IF;
437: --
438: fnd_message.set_name('WSH','WSH_WEB_CONTAINS_LABEL');
439: l_contains_label := fnd_message.get;

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

716: --
717: -- Debug Statements
718: --
719: IF l_debug_on THEN
720: WSH_DEBUG_SV.log(l_module_name,'X_NUM_OF_PACKAGES',x_num_of_packages);
721: WSH_DEBUG_SV.pop(l_module_name);
722: END IF;
723: --
724: EXCEPTION

Line 721: WSH_DEBUG_SV.pop(l_module_name);

717: -- Debug Statements
718: --
719: IF l_debug_on THEN
720: WSH_DEBUG_SV.log(l_module_name,'X_NUM_OF_PACKAGES',x_num_of_packages);
721: WSH_DEBUG_SV.pop(l_module_name);
722: END IF;
723: --
724: EXCEPTION
725: WHEN others THEN

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

729: --
730: -- Debug Statements
731: --
732: IF l_debug_on THEN
733: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
734: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
735: END IF;
736: --
737: END get_master_container_contents;

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

730: -- Debug Statements
731: --
732: IF l_debug_on THEN
733: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
734: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
735: END IF;
736: --
737: END get_master_container_contents;
738: