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);
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;
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
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 || '
');
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);
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
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;
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:
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);
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;
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
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 || '
');
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);
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
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;
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:
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);
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);
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;
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: --
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
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: --
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
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: --
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,
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: --
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;
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;
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:
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);
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);
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);
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);
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);
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);
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;
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: --
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');
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;
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
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
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;
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: