eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_ITM_EXPORT_SCREENING dependencies on WSH_DEBUG_SV

Line 70: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

66: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
67:
68: IF l_debug_on IS NULL
69: THEN
70: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
71: END IF;
72: IF l_debug_on THEN
73: WSH_DEBUG_SV.log(l_module_name,'ENTERING '||l_module_name);
74: END IF;

Line 73: WSH_DEBUG_SV.log(l_module_name,'ENTERING '||l_module_name);

69: THEN
70: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
71: END IF;
72: IF l_debug_on THEN
73: WSH_DEBUG_SV.log(l_module_name,'ENTERING '||l_module_name);
74: END IF;
75:
76: IF p_sn_range_rec_type.from_serial_number IS NOT NULL THEN
77:

Line 82: WSH_DEBUG_SV.log(l_module_name,'l_from_serial_num ',l_from_serial_num);

78: l_from_serial_num := p_sn_range_rec_type.from_serial_number;
79: l_to_serial_num := p_sn_range_rec_type.to_serial_number;
80:
81: IF l_debug_on THEN
82: WSH_DEBUG_SV.log(l_module_name,'l_from_serial_num ',l_from_serial_num);
83: END IF;
84:
85: IF l_debug_on THEN
86: WSH_DEBUG_SV.log(l_module_name,'l_to_serial_num ',l_to_serial_num);

Line 86: WSH_DEBUG_SV.log(l_module_name,'l_to_serial_num ',l_to_serial_num);

82: WSH_DEBUG_SV.log(l_module_name,'l_from_serial_num ',l_from_serial_num);
83: END IF;
84:
85: IF l_debug_on THEN
86: WSH_DEBUG_SV.log(l_module_name,'l_to_serial_num ',l_to_serial_num);
87: END IF;
88:
89: --Addded in bug 9265708.Trim function here will return null if serial number ends with a number ,will return
90: --last chracter of the serial number if serial number ends with a character.

Line 98: WSH_DEBUG_SV.log(l_module_name,'l_real_serial_prefix ',l_real_serial_prefix);

94: l_real_serial_prefix := RTRIM(p_sn_range_rec_type.from_serial_number,
95: '0123456789');
96:
97: IF l_debug_on THEN
98: WSH_DEBUG_SV.log(l_module_name,'l_real_serial_prefix ',l_real_serial_prefix);
99: END IF;
100:
101: l_prefix_length := NVL(LENGTH(l_real_serial_prefix), 0);
102:

Line 104: WSH_DEBUG_SV.log(l_module_name,'l_prefix_length ',l_prefix_length);

100:
101: l_prefix_length := NVL(LENGTH(l_real_serial_prefix), 0);
102:
103: IF l_debug_on THEN
104: WSH_DEBUG_SV.log(l_module_name,'l_prefix_length ',l_prefix_length);
105: END IF;
106:
107: l_from_numeric := TO_NUMBER(SUBSTR(p_sn_range_rec_type.from_serial_number,
108: l_prefix_length + 1));

Line 111: WSH_DEBUG_SV.log(l_module_name,'l_from_numeric ',l_from_numeric);

107: l_from_numeric := TO_NUMBER(SUBSTR(p_sn_range_rec_type.from_serial_number,
108: l_prefix_length + 1));
109:
110: IF l_debug_on THEN
111: WSH_DEBUG_SV.log(l_module_name,'l_from_numeric ',l_from_numeric);
112: END IF;
113:
114: l_to_numeric := TO_NUMBER(SUBSTR(p_sn_range_rec_type.to_serial_number,
115: l_prefix_length + 1));

Line 118: WSH_DEBUG_SV.log(l_module_name,'l_to_numeric ',l_to_numeric);

114: l_to_numeric := TO_NUMBER(SUBSTR(p_sn_range_rec_type.to_serial_number,
115: l_prefix_length + 1));
116:
117: IF l_debug_on THEN
118: WSH_DEBUG_SV.log(l_module_name,'l_to_numeric ',l_to_numeric);
119: END IF;
120:
121: l_range_count := l_to_numeric - l_from_numeric ;
122: --}

Line 130: WSH_DEBUG_SV.log(l_module_name,'l_range_count ',l_range_count);

126: --}
127: END IF;
128:
129: IF l_debug_on THEN
130: WSH_DEBUG_SV.log(l_module_name,'l_range_count ',l_range_count);
131: END IF;
132:
133: -- If range count is zero, means from and to are same and no new
134: -- serial numbers need to be generated

Line 138: WSH_DEBUG_SV.log(l_module_name,'Inside l_range_count ',l_range_count);

134: -- serial numbers need to be generated
135: IF l_range_count = 0 THEN
136:
137: IF l_debug_on THEN
138: WSH_DEBUG_SV.log(l_module_name,'Inside l_range_count ',l_range_count);
139: END IF;
140: IF l_debug_on THEN
141: WSH_DEBUG_SV.log(l_module_name,'l_from_serial_num ',l_from_serial_num);
142: END IF;

Line 141: WSH_DEBUG_SV.log(l_module_name,'l_from_serial_num ',l_from_serial_num);

137: IF l_debug_on THEN
138: WSH_DEBUG_SV.log(l_module_name,'Inside l_range_count ',l_range_count);
139: END IF;
140: IF l_debug_on THEN
141: WSH_DEBUG_SV.log(l_module_name,'l_from_serial_num ',l_from_serial_num);
142: END IF;
143:
144: -- Only one serial number needs to go in either From or to as both are same.
145: INSERT INTO WSH_ITM_SERIAL_NUMBERS

Line 166: WSH_DEBUG_SV.log(l_module_name,'New Serial Number ',l_new_serial_number);

162: LENGTH(p_sn_range_rec_type.from_serial_number)
163: - l_prefix_length, '0');
164:
165: IF l_debug_on THEN
166: WSH_DEBUG_SV.log(l_module_name,'New Serial Number ',l_new_serial_number);
167: END IF;
168:
169: INSERT INTO WSH_ITM_SERIAL_NUMBERS
170: (request_control_id,

Line 189: WSH_DEBUG_SV.log(l_module_name,'The unexpected Error Code ' || SQLCODE || ' : ' || SQLERRM);

185: WHEN OTHERS THEN
186: ROLLBACK TO WSH_ITM_EXPORT_COMPLIANCE;
187: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
188: IF l_debug_on THEN
189: WSH_DEBUG_SV.log(l_module_name,'The unexpected Error Code ' || SQLCODE || ' : ' || SQLERRM);
190: WSH_DEBUG_SV.pop(l_module_name);
191: END IF;
192:
193: IF l_debug_on THEN

Line 190: WSH_DEBUG_SV.pop(l_module_name);

186: ROLLBACK TO WSH_ITM_EXPORT_COMPLIANCE;
187: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
188: IF l_debug_on THEN
189: WSH_DEBUG_SV.log(l_module_name,'The unexpected Error Code ' || SQLCODE || ' : ' || SQLERRM);
190: WSH_DEBUG_SV.pop(l_module_name);
191: END IF;
192:
193: IF l_debug_on THEN
194: WSH_DEBUG_SV.log(l_module_name,'EXITING '||l_module_name);

Line 194: WSH_DEBUG_SV.log(l_module_name,'EXITING '||l_module_name);

190: WSH_DEBUG_SV.pop(l_module_name);
191: END IF;
192:
193: IF l_debug_on THEN
194: WSH_DEBUG_SV.log(l_module_name,'EXITING '||l_module_name);
195: END IF;
196:
197:
198: END PROCESS_SERIAL_NUMBERS;

Line 245: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

241: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
242:
243: IF l_debug_on IS NULL
244: THEN
245: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
246: END IF;
247: IF l_debug_on THEN
248: WSH_DEBUG_SV.log(l_module_name,'ENTERING '||l_module_name);
249: END IF;

Line 248: WSH_DEBUG_SV.log(l_module_name,'ENTERING '||l_module_name);

244: THEN
245: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
246: END IF;
247: IF l_debug_on THEN
248: WSH_DEBUG_SV.log(l_module_name,'ENTERING '||l_module_name);
249: END IF;
250:
251:
252:

Line 258: WSH_DEBUG_SV.push(l_module_name);

254: LOOP
255: FETCH c_get_delivery_details INTO l_delv_detail_rec;
256: EXIT WHEN c_get_delivery_details%NOTFOUND;
257: IF l_debug_on THEN
258: WSH_DEBUG_SV.push(l_module_name);
259: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',
260: l_delv_detail_rec.delivery_detail_id);
261: WSH_DEBUG_SV.log(l_module_name,'transaction_temp_id',
262: l_delv_detail_rec.transaction_temp_id);

Line 259: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',

255: FETCH c_get_delivery_details INTO l_delv_detail_rec;
256: EXIT WHEN c_get_delivery_details%NOTFOUND;
257: IF l_debug_on THEN
258: WSH_DEBUG_SV.push(l_module_name);
259: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',
260: l_delv_detail_rec.delivery_detail_id);
261: WSH_DEBUG_SV.log(l_module_name,'transaction_temp_id',
262: l_delv_detail_rec.transaction_temp_id);
263: END IF;

Line 261: WSH_DEBUG_SV.log(l_module_name,'transaction_temp_id',

257: IF l_debug_on THEN
258: WSH_DEBUG_SV.push(l_module_name);
259: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',
260: l_delv_detail_rec.delivery_detail_id);
261: WSH_DEBUG_SV.log(l_module_name,'transaction_temp_id',
262: l_delv_detail_rec.transaction_temp_id);
263: END IF;
264:
265: IF l_delv_detail_rec.transaction_temp_id IS NULL THEN

Line 267: WSH_DEBUG_SV.log(l_module_name,'TRANSACTION_TEMP_ID IS NULL');

263: END IF;
264:
265: IF l_delv_detail_rec.transaction_temp_id IS NULL THEN
266: IF l_debug_on THEN
267: WSH_DEBUG_SV.log(l_module_name,'TRANSACTION_TEMP_ID IS NULL');
268: END IF;
269:
270: OPEN c_get_serial_number_from_wdd (l_delv_detail_rec.delivery_detail_id);
271: LOOP

Line 276: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',

272: FETCH c_get_serial_number_from_wdd INTO l_sn_range_rec_type;
273:
274: EXIT WHEN c_get_serial_number_from_wdd%NOTFOUND;
275: IF l_debug_on THEN
276: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',
277: l_sn_range_rec_type.delivery_detail_id);
278: WSH_DEBUG_SV.log(l_module_name,'to_serial_number',
279: l_sn_range_rec_type.to_serial_number);
280: WSH_DEBUG_SV.log(l_module_name,'from_serial_number',

Line 278: WSH_DEBUG_SV.log(l_module_name,'to_serial_number',

274: EXIT WHEN c_get_serial_number_from_wdd%NOTFOUND;
275: IF l_debug_on THEN
276: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',
277: l_sn_range_rec_type.delivery_detail_id);
278: WSH_DEBUG_SV.log(l_module_name,'to_serial_number',
279: l_sn_range_rec_type.to_serial_number);
280: WSH_DEBUG_SV.log(l_module_name,'from_serial_number',
281: l_sn_range_rec_type.from_serial_number);
282: END IF;

Line 280: WSH_DEBUG_SV.log(l_module_name,'from_serial_number',

276: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',
277: l_sn_range_rec_type.delivery_detail_id);
278: WSH_DEBUG_SV.log(l_module_name,'to_serial_number',
279: l_sn_range_rec_type.to_serial_number);
280: WSH_DEBUG_SV.log(l_module_name,'from_serial_number',
281: l_sn_range_rec_type.from_serial_number);
282: END IF;
283: PROCESS_SERIAL_NUMBERS(
284: p_sn_range_rec_type => l_sn_range_rec_type,

Line 292: WSH_DEBUG_SV.log(l_module_name,'TRANSACTION_TEMP_ID IS NOT NULL');

288: END LOOP;
289: CLOSE c_get_serial_number_from_wdd;
290: ELSE
291: IF l_debug_on THEN
292: WSH_DEBUG_SV.log(l_module_name,'TRANSACTION_TEMP_ID IS NOT NULL');
293: END IF;
294:
295: OPEN c_get_serial_num_range (l_delv_detail_rec.transaction_temp_id,l_delv_detail_rec.delivery_detail_id);
296: LOOP

Line 301: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',

297: FETCH c_get_serial_num_range INTO l_sn_range_rec_type;
298:
299: EXIT WHEN c_get_serial_num_range%NOTFOUND;
300: IF l_debug_on THEN
301: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',
302: l_sn_range_rec_type.delivery_detail_id);
303: WSH_DEBUG_SV.log(l_module_name,'to_serial_number',
304: l_sn_range_rec_type.to_serial_number);
305: WSH_DEBUG_SV.log(l_module_name,'from_serial_number',

Line 303: WSH_DEBUG_SV.log(l_module_name,'to_serial_number',

299: EXIT WHEN c_get_serial_num_range%NOTFOUND;
300: IF l_debug_on THEN
301: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',
302: l_sn_range_rec_type.delivery_detail_id);
303: WSH_DEBUG_SV.log(l_module_name,'to_serial_number',
304: l_sn_range_rec_type.to_serial_number);
305: WSH_DEBUG_SV.log(l_module_name,'from_serial_number',
306: l_sn_range_rec_type.from_serial_number);
307: END IF;

Line 305: WSH_DEBUG_SV.log(l_module_name,'from_serial_number',

301: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',
302: l_sn_range_rec_type.delivery_detail_id);
303: WSH_DEBUG_SV.log(l_module_name,'to_serial_number',
304: l_sn_range_rec_type.to_serial_number);
305: WSH_DEBUG_SV.log(l_module_name,'from_serial_number',
306: l_sn_range_rec_type.from_serial_number);
307: END IF;
308: PROCESS_SERIAL_NUMBERS(
309: p_sn_range_rec_type => l_sn_range_rec_type,

Line 324: WSH_DEBUG_SV.log(l_module_name,'The unexpected Error Code ' || SQLCODE || ' : ' || SQLERRM);

320: WHEN OTHERS THEN
321: ROLLBACK TO WSH_ITM_EXPORT_COMPLIANCE;
322: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
323: IF l_debug_on THEN
324: WSH_DEBUG_SV.log(l_module_name,'The unexpected Error Code ' || SQLCODE || ' : ' || SQLERRM);
325: WSH_DEBUG_SV.pop(l_module_name);
326: END IF;
327:
328: IF l_debug_on THEN

Line 325: WSH_DEBUG_SV.pop(l_module_name);

321: ROLLBACK TO WSH_ITM_EXPORT_COMPLIANCE;
322: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
323: IF l_debug_on THEN
324: WSH_DEBUG_SV.log(l_module_name,'The unexpected Error Code ' || SQLCODE || ' : ' || SQLERRM);
325: WSH_DEBUG_SV.pop(l_module_name);
326: END IF;
327:
328: IF l_debug_on THEN
329: WSH_DEBUG_SV.log(l_module_name,'EXITING '||l_module_name);

Line 329: WSH_DEBUG_SV.log(l_module_name,'EXITING '||l_module_name);

325: WSH_DEBUG_SV.pop(l_module_name);
326: END IF;
327:
328: IF l_debug_on THEN
329: WSH_DEBUG_SV.log(l_module_name,'EXITING '||l_module_name);
330: END IF;
331:
332:
333: END POPULATE_SERIAL_NUMBERS;

Line 472: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

468: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
469:
470: IF l_debug_on IS NULL
471: THEN
472: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
473: END IF;
474:
475: IF l_debug_on THEN
476: WSH_DEBUG_SV.push(l_module_name);

Line 476: WSH_DEBUG_SV.push(l_module_name);

472: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
473: END IF;
474:
475: IF l_debug_on THEN
476: WSH_DEBUG_SV.push(l_module_name);
477: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',p_organization_id);
478: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FROM_ID',p_delivery_from_id);
479: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_TO_ID',p_delivery_to_id);
480: WSH_DEBUG_SV.log(l_module_name,'P_EVENT_NAME',p_event_name);

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

473: END IF;
474:
475: IF l_debug_on THEN
476: WSH_DEBUG_SV.push(l_module_name);
477: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',p_organization_id);
478: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FROM_ID',p_delivery_from_id);
479: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_TO_ID',p_delivery_to_id);
480: WSH_DEBUG_SV.log(l_module_name,'P_EVENT_NAME',p_event_name);
481: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',p_ship_method_code);

Line 478: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FROM_ID',p_delivery_from_id);

474:
475: IF l_debug_on THEN
476: WSH_DEBUG_SV.push(l_module_name);
477: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',p_organization_id);
478: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FROM_ID',p_delivery_from_id);
479: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_TO_ID',p_delivery_to_id);
480: WSH_DEBUG_SV.log(l_module_name,'P_EVENT_NAME',p_event_name);
481: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',p_ship_method_code);
482: WSH_DEBUG_SV.log(l_module_name,'P_PICKUP_DATE_FROM',p_pickup_date_from);

Line 479: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_TO_ID',p_delivery_to_id);

475: IF l_debug_on THEN
476: WSH_DEBUG_SV.push(l_module_name);
477: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',p_organization_id);
478: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FROM_ID',p_delivery_from_id);
479: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_TO_ID',p_delivery_to_id);
480: WSH_DEBUG_SV.log(l_module_name,'P_EVENT_NAME',p_event_name);
481: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',p_ship_method_code);
482: WSH_DEBUG_SV.log(l_module_name,'P_PICKUP_DATE_FROM',p_pickup_date_from);
483: WSH_DEBUG_SV.log(l_module_name,'P_PICKUP_DATE_TO',p_pickup_date_to);

Line 480: WSH_DEBUG_SV.log(l_module_name,'P_EVENT_NAME',p_event_name);

476: WSH_DEBUG_SV.push(l_module_name);
477: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',p_organization_id);
478: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FROM_ID',p_delivery_from_id);
479: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_TO_ID',p_delivery_to_id);
480: WSH_DEBUG_SV.log(l_module_name,'P_EVENT_NAME',p_event_name);
481: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',p_ship_method_code);
482: WSH_DEBUG_SV.log(l_module_name,'P_PICKUP_DATE_FROM',p_pickup_date_from);
483: WSH_DEBUG_SV.log(l_module_name,'P_PICKUP_DATE_TO',p_pickup_date_to);
484: END IF;

Line 481: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',p_ship_method_code);

477: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',p_organization_id);
478: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FROM_ID',p_delivery_from_id);
479: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_TO_ID',p_delivery_to_id);
480: WSH_DEBUG_SV.log(l_module_name,'P_EVENT_NAME',p_event_name);
481: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',p_ship_method_code);
482: WSH_DEBUG_SV.log(l_module_name,'P_PICKUP_DATE_FROM',p_pickup_date_from);
483: WSH_DEBUG_SV.log(l_module_name,'P_PICKUP_DATE_TO',p_pickup_date_to);
484: END IF;
485:

Line 482: WSH_DEBUG_SV.log(l_module_name,'P_PICKUP_DATE_FROM',p_pickup_date_from);

478: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FROM_ID',p_delivery_from_id);
479: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_TO_ID',p_delivery_to_id);
480: WSH_DEBUG_SV.log(l_module_name,'P_EVENT_NAME',p_event_name);
481: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',p_ship_method_code);
482: WSH_DEBUG_SV.log(l_module_name,'P_PICKUP_DATE_FROM',p_pickup_date_from);
483: WSH_DEBUG_SV.log(l_module_name,'P_PICKUP_DATE_TO',p_pickup_date_to);
484: END IF;
485:
486: -------------------------------------------------------------------------------

Line 483: WSH_DEBUG_SV.log(l_module_name,'P_PICKUP_DATE_TO',p_pickup_date_to);

479: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_TO_ID',p_delivery_to_id);
480: WSH_DEBUG_SV.log(l_module_name,'P_EVENT_NAME',p_event_name);
481: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',p_ship_method_code);
482: WSH_DEBUG_SV.log(l_module_name,'P_PICKUP_DATE_FROM',p_pickup_date_from);
483: WSH_DEBUG_SV.log(l_module_name,'P_PICKUP_DATE_TO',p_pickup_date_to);
484: END IF;
485:
486: -------------------------------------------------------------------------------
487: -- Pickup Deliveries which require export screening

Line 490: WSH_DEBUG_SV.log(l_module_name,'This Section Picks up the Deliveries Which Require Screeenig For '||p_event_name||' event ');

486: -------------------------------------------------------------------------------
487: -- Pickup Deliveries which require export screening
488: -------------------------------------------------------------------------------
489: IF l_debug_on THEN
490: WSH_DEBUG_SV.log(l_module_name,'This Section Picks up the Deliveries Which Require Screeenig For '||p_event_name||' event ');
491: END IF;
492:
493: -- This sub section prepares the query to pick up the Deliveries which require screening
494: IF p_event_name = G_PICK_RELEASE_EVENT THEN

Line 551: WSH_DEBUG_SV.log(l_module_name,' The Query executed ',l_exp_compliance_dlvy_query);

547:
548:
549: l_exp_compliance_dlvy_query := l_exp_compliance_dlvy_query||l_tempStr||' ';
550: IF l_debug_on THEN
551: WSH_DEBUG_SV.log(l_module_name,' The Query executed ',l_exp_compliance_dlvy_query);
552: END IF;
553:
554:
555:

Line 589: WSH_DEBUG_SV.log(l_module_name,' No Of Deliveries Selected For Screening ',l_num_delivery_id_tab.count);

585:
586: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
587:
588: IF l_debug_on THEN
589: WSH_DEBUG_SV.log(l_module_name,' No Of Deliveries Selected For Screening ',l_num_delivery_id_tab.count);
590: END IF;
591:
592: IF l_num_delivery_id_tab.count < 1 THEN
593: IF l_debug_on THEN

Line 594: WSH_DEBUG_SV.pop(l_module_name);

590: END IF;
591:
592: IF l_num_delivery_id_tab.count < 1 THEN
593: IF l_debug_on THEN
594: WSH_DEBUG_SV.pop(l_module_name);
595: END IF;
596: RETURN;
597: END IF;
598:

Line 605: WSH_DEBUG_SV.log(l_module_name,'This Section Handles The REQUIRE Export Screening Exception for'||p_event_name||' event ');

601: ---------------------------------------------------------------------------------
602: -- Handling Require Export Screening Exceptions
603: ---------------------------------------------------------------------------------
604: IF l_debug_on THEN
605: WSH_DEBUG_SV.log(l_module_name,'This Section Handles The REQUIRE Export Screening Exception for'||p_event_name||' event ');
606: END IF;
607:
608: l_return_status := NULL;
609: l_msg_count := NULL;

Line 634: WSH_DEBUG_SV.log(l_module_name,' Error Handling the exception for Delivery Id : '||l_num_delivery_id_tab(j));

630: -- Error Handling Section
631:
632: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
633: IF l_debug_on THEN
634: WSH_DEBUG_SV.log(l_module_name,' Error Handling the exception for Delivery Id : '||l_num_delivery_id_tab(j));
635: END IF;
636:
637: IF l_msg_count IS NOT NULL THEN
638: WSH_UTIL_CORE.Add_Message(l_return_status);

Line 646: WSH_DEBUG_SV.log(l_module_name,l_msg_data);

642: p_msg_index => i,
643: p_encoded => 'F'
644: );
645: IF l_debug_on THEN
646: WSH_DEBUG_SV.log(l_module_name,l_msg_data);
647: END IF;
648: END LOOP;
649: END IF;
650:

Line 656: WSH_DEBUG_SV.pop(l_module_name);

652: ROLLBACK TO WSH_ITM_EXPORT_COMPLIANCE;
653:
654: x_return_status := l_return_status;
655: IF l_debug_on THEN
656: WSH_DEBUG_SV.pop(l_module_name);
657: END IF;
658: RETURN;
659: END IF;
660:

Line 666: WSH_DEBUG_SV.log(l_module_name,'This Section Logs a Submitted For Export Screening For Delivery which Require Export Screening and Handles the Existing Require Export Screening Exceptions for '||p_event_name||' event ');

662: -- Logging exceptions for Deliveries submitted for export screening
663: ---------------------------------------------------------------------------------------------------------
664:
665: IF l_debug_on THEN
666: WSH_DEBUG_SV.log(l_module_name,'This Section Logs a Submitted For Export Screening For Delivery which Require Export Screening and Handles the Existing Require Export Screening Exceptions for '||p_event_name||' event ');
667: END IF;
668:
669: l_return_status := NULL;
670: l_msg_count := NULL;

Line 707: WSH_DEBUG_SV.log(l_module_name,' Error Logging the exception for Delivery Id : ',l_num_delivery_id_tab(j));

703:
704: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
705:
706: IF l_debug_on THEN
707: WSH_DEBUG_SV.log(l_module_name,' Error Logging the exception for Delivery Id : ',l_num_delivery_id_tab(j));
708: END IF;
709:
710: IF l_msg_count IS NOT NULL THEN
711: WSH_UTIL_CORE.Add_Message(l_return_status);

Line 719: WSH_DEBUG_SV.log(l_module_name,l_msg_data);

715: p_msg_index => i,
716: p_encoded => 'F'
717: );
718: IF l_debug_on THEN
719: WSH_DEBUG_SV.log(l_module_name,l_msg_data);
720: END IF;
721: END LOOP;
722: END IF;
723:

Line 729: WSH_DEBUG_SV.pop(l_module_name);

725: ROLLBACK TO WSH_ITM_EXPORT_COMPLIANCE;
726:
727: x_return_status := l_return_status;
728: IF l_debug_on THEN
729: WSH_DEBUG_SV.pop(l_module_name);
730: END IF;
731: RETURN;
732: END IF;
733:

Line 743: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_WF_STD.RAISE_EVENT => ',l_wf_return_status);

739: x_return_status => l_wf_return_status
740: );
741:
742: IF l_debug_on THEN
743: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_WF_STD.RAISE_EVENT => ',l_wf_return_status);
744: END IF;
745:
746: END LOOP;
747:

Line 752: WSH_DEBUG_SV.log(l_module_name,'This Section Populates The Delivery Information Into Request Control Table for '||p_event_name||' event ');

748: -------------------------------------------------------------------------------
749: -- Populates Deliveries Into ITM Request Control Tables
750: -------------------------------------------------------------------------------
751: IF l_debug_on THEN
752: WSH_DEBUG_SV.log(l_module_name,'This Section Populates The Delivery Information Into Request Control Table for '||p_event_name||' event ');
753: END IF;
754:
755: -- This sub section Prepares the data to be inserted into ITM Request Control Table
756: -- Fetch user and login information

Line 783: WSH_DEBUG_SV.log(l_module_name,'Records found for delivery ' || l_rec_found);

779: WHEN NO_DATA_FOUND THEN
780: NULL;
781: END;
782: IF l_debug_on THEN
783: WSH_DEBUG_SV.log(l_module_name,'Records found for delivery ' || l_rec_found);
784: END IF;
785:
786: IF (l_rec_found = 0) THEN
787: -- Get the ORGANIZATION_IF of the delivery

Line 817: WSH_DEBUG_SV.log(l_module_name,'Create_Update_Txns_History failed ' || x_return_status);

813: );
814: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
815: ROLLBACK TO WSH_ITM_EXPORT_COMPLIANCE;
816: IF l_debug_on THEN
817: WSH_DEBUG_SV.log(l_module_name,'Create_Update_Txns_History failed ' || x_return_status);
818: WSH_DEBUG_SV.pop(l_module_name);
819: END IF;
820: RETURN;
821: END IF;

Line 818: WSH_DEBUG_SV.pop(l_module_name);

814: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
815: ROLLBACK TO WSH_ITM_EXPORT_COMPLIANCE;
816: IF l_debug_on THEN
817: WSH_DEBUG_SV.log(l_module_name,'Create_Update_Txns_History failed ' || x_return_status);
818: WSH_DEBUG_SV.pop(l_module_name);
819: END IF;
820: RETURN;
821: END IF;
822:

Line 824: WSH_DEBUG_SV.log(l_module_name,'Created Transaction for Delivery txns_id = ' || x_txns_id );

820: RETURN;
821: END IF;
822:
823: IF l_debug_on THEN
824: WSH_DEBUG_SV.log(l_module_name,'Created Transaction for Delivery txns_id = ' || x_txns_id );
825: END IF;
826: END IF;
827: END LOOP;
828:

Line 880: WSH_DEBUG_SV.log(l_module_name,'Create_Serial_numbers_failed ' || x_return_status);

876:
877: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
878: ROLLBACK TO WSH_ITM_EXPORT_COMPLIANCE;
879: IF l_debug_on THEN
880: WSH_DEBUG_SV.log(l_module_name,'Create_Serial_numbers_failed ' || x_return_status);
881: WSH_DEBUG_SV.pop(l_module_name);
882: END IF;
883: RETURN;
884: END IF;

Line 881: WSH_DEBUG_SV.pop(l_module_name);

877: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
878: ROLLBACK TO WSH_ITM_EXPORT_COMPLIANCE;
879: IF l_debug_on THEN
880: WSH_DEBUG_SV.log(l_module_name,'Create_Serial_numbers_failed ' || x_return_status);
881: WSH_DEBUG_SV.pop(l_module_name);
882: END IF;
883: RETURN;
884: END IF;
885:

Line 887: WSH_DEBUG_SV.pop(l_module_name);

883: RETURN;
884: END IF;
885:
886: IF l_debug_on THEN
887: WSH_DEBUG_SV.pop(l_module_name);
888: END IF;
889: IF l_debug_on THEN
890: WSH_DEBUG_SV.log(l_module_name,'Before Calling WSH_ITM_CUSTOM_PROCESS.PRE_PROCESS_WSH_REQUEST');
891: END IF;

Line 890: WSH_DEBUG_SV.log(l_module_name,'Before Calling WSH_ITM_CUSTOM_PROCESS.PRE_PROCESS_WSH_REQUEST');

886: IF l_debug_on THEN
887: WSH_DEBUG_SV.pop(l_module_name);
888: END IF;
889: IF l_debug_on THEN
890: WSH_DEBUG_SV.log(l_module_name,'Before Calling WSH_ITM_CUSTOM_PROCESS.PRE_PROCESS_WSH_REQUEST');
891: END IF;
892:
893: WSH_ITM_CUSTOM_PROCESS.PRE_PROCESS_WSH_REQUEST
894: (

Line 899: WSH_DEBUG_SV.log(l_module_name,'After Calling WSH_ITM_CUSTOM_PROCESS.PRE_PROCESS_WSH_REQUEST');

895: p_request_control_id => l_request_control_id_s
896: );
897:
898: IF l_debug_on THEN
899: WSH_DEBUG_SV.log(l_module_name,'After Calling WSH_ITM_CUSTOM_PROCESS.PRE_PROCESS_WSH_REQUEST');
900: END IF;
901: END LOOP;
902:
903: EXCEPTION

Line 910: WSH_DEBUG_SV.log(l_module_name,'The unexpected Error Code ' || SQLCODE || ' : ' || SQLERRM);

906:
907: ROLLBACK TO WSH_ITM_EXPORT_COMPLIANCE;
908: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
909: IF l_debug_on THEN
910: WSH_DEBUG_SV.log(l_module_name,'The unexpected Error Code ' || SQLCODE || ' : ' || SQLERRM);
911: WSH_DEBUG_SV.pop(l_module_name);
912: END IF;
913:
914: END SCREEN_EVENT_DELIVERIES;

Line 911: WSH_DEBUG_SV.pop(l_module_name);

907: ROLLBACK TO WSH_ITM_EXPORT_COMPLIANCE;
908: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
909: IF l_debug_on THEN
910: WSH_DEBUG_SV.log(l_module_name,'The unexpected Error Code ' || SQLCODE || ' : ' || SQLERRM);
911: WSH_DEBUG_SV.pop(l_module_name);
912: END IF;
913:
914: END SCREEN_EVENT_DELIVERIES;
915:

Line 957: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

953: --
954: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
955: --
956: IF l_debug_on IS NULL THEN
957: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
958: END IF;
959:
960: IF l_debug_on THEN
961: WSH_DEBUG_SV.push(l_module_name);

Line 961: WSH_DEBUG_SV.push(l_module_name);

957: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
958: END IF;
959:
960: IF l_debug_on THEN
961: WSH_DEBUG_SV.push(l_module_name);
962: WSH_DEBUG_SV.log(l_module_name,'P_EVENT_NAME',p_event_name);
963: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',p_delivery_id);
964: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',p_organization_id);
965: END IF;

Line 962: WSH_DEBUG_SV.log(l_module_name,'P_EVENT_NAME',p_event_name);

958: END IF;
959:
960: IF l_debug_on THEN
961: WSH_DEBUG_SV.push(l_module_name);
962: WSH_DEBUG_SV.log(l_module_name,'P_EVENT_NAME',p_event_name);
963: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',p_delivery_id);
964: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',p_organization_id);
965: END IF;
966:

Line 963: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',p_delivery_id);

959:
960: IF l_debug_on THEN
961: WSH_DEBUG_SV.push(l_module_name);
962: WSH_DEBUG_SV.log(l_module_name,'P_EVENT_NAME',p_event_name);
963: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',p_delivery_id);
964: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',p_organization_id);
965: END IF;
966:
967: wf_event.AddParameterToList(

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

960: IF l_debug_on THEN
961: WSH_DEBUG_SV.push(l_module_name);
962: WSH_DEBUG_SV.log(l_module_name,'P_EVENT_NAME',p_event_name);
963: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',p_delivery_id);
964: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',p_organization_id);
965: END IF;
966:
967: wf_event.AddParameterToList(
968: p_name=>'ORGANIZATION_ID',

Line 982: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);

978: x_return_status => x_return_status);
979:
980: --Debug message added in bug 9226895
981: IF l_debug_on THEN
982: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
983: WSH_DEBUG_SV.pop(l_module_name);
984: END IF;
985: --
986:

Line 983: WSH_DEBUG_SV.pop(l_module_name);

979:
980: --Debug message added in bug 9226895
981: IF l_debug_on THEN
982: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
983: WSH_DEBUG_SV.pop(l_module_name);
984: END IF;
985: --
986:
987: EXCEPTION

Line 991: WSH_DEBUG_SV.log(l_module_name,'The unexpected Error Code ' || SQLCODE || ' : ' || SQLERRM);

987: EXCEPTION
988: WHEN OTHERS THEN
989: ROLLBACK TO RAISE_ITM_EVENT;
990: IF l_debug_on THEN
991: WSH_DEBUG_SV.log(l_module_name,'The unexpected Error Code ' || SQLCODE || ' : ' || SQLERRM);
992: WSH_DEBUG_SV.pop(l_module_name);
993: END IF;
994: END RAISE_ITM_EVENT;
995:

Line 992: WSH_DEBUG_SV.pop(l_module_name);

988: WHEN OTHERS THEN
989: ROLLBACK TO RAISE_ITM_EVENT;
990: IF l_debug_on THEN
991: WSH_DEBUG_SV.log(l_module_name,'The unexpected Error Code ' || SQLCODE || ' : ' || SQLERRM);
992: WSH_DEBUG_SV.pop(l_module_name);
993: END IF;
994: END RAISE_ITM_EVENT;
995:
996:

Line 1047: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1043: --
1044: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1045: --
1046: IF l_debug_on IS NULL THEN
1047: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1048: END IF;
1049:
1050: IF l_debug_on THEN
1051: WSH_DEBUG_SV.push(l_module_name);

Line 1051: WSH_DEBUG_SV.push(l_module_name);

1047: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1048: END IF;
1049:
1050: IF l_debug_on THEN
1051: WSH_DEBUG_SV.push(l_module_name);
1052: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION ID',p_organization_id);
1053: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FROM_ID',p_delivery_from_id);
1054: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_TO_ID',p_delivery_to_id);
1055: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',p_ship_method_code);

Line 1052: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION ID',p_organization_id);

1048: END IF;
1049:
1050: IF l_debug_on THEN
1051: WSH_DEBUG_SV.push(l_module_name);
1052: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION ID',p_organization_id);
1053: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FROM_ID',p_delivery_from_id);
1054: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_TO_ID',p_delivery_to_id);
1055: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',p_ship_method_code);
1056: WSH_DEBUG_SV.log(l_module_name,'P_PICKUP_DATE_FROM',p_pickup_date_from);

Line 1053: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FROM_ID',p_delivery_from_id);

1049:
1050: IF l_debug_on THEN
1051: WSH_DEBUG_SV.push(l_module_name);
1052: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION ID',p_organization_id);
1053: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FROM_ID',p_delivery_from_id);
1054: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_TO_ID',p_delivery_to_id);
1055: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',p_ship_method_code);
1056: WSH_DEBUG_SV.log(l_module_name,'P_PICKUP_DATE_FROM',p_pickup_date_from);
1057: WSH_DEBUG_SV.log(l_module_name,'P_PICKUP_DATE_TO',p_pickup_date_to);

Line 1054: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_TO_ID',p_delivery_to_id);

1050: IF l_debug_on THEN
1051: WSH_DEBUG_SV.push(l_module_name);
1052: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION ID',p_organization_id);
1053: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FROM_ID',p_delivery_from_id);
1054: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_TO_ID',p_delivery_to_id);
1055: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',p_ship_method_code);
1056: WSH_DEBUG_SV.log(l_module_name,'P_PICKUP_DATE_FROM',p_pickup_date_from);
1057: WSH_DEBUG_SV.log(l_module_name,'P_PICKUP_DATE_TO',p_pickup_date_to);
1058: END IF;

Line 1055: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',p_ship_method_code);

1051: WSH_DEBUG_SV.push(l_module_name);
1052: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION ID',p_organization_id);
1053: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FROM_ID',p_delivery_from_id);
1054: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_TO_ID',p_delivery_to_id);
1055: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',p_ship_method_code);
1056: WSH_DEBUG_SV.log(l_module_name,'P_PICKUP_DATE_FROM',p_pickup_date_from);
1057: WSH_DEBUG_SV.log(l_module_name,'P_PICKUP_DATE_TO',p_pickup_date_to);
1058: END IF;
1059:

Line 1056: WSH_DEBUG_SV.log(l_module_name,'P_PICKUP_DATE_FROM',p_pickup_date_from);

1052: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION ID',p_organization_id);
1053: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FROM_ID',p_delivery_from_id);
1054: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_TO_ID',p_delivery_to_id);
1055: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',p_ship_method_code);
1056: WSH_DEBUG_SV.log(l_module_name,'P_PICKUP_DATE_FROM',p_pickup_date_from);
1057: WSH_DEBUG_SV.log(l_module_name,'P_PICKUP_DATE_TO',p_pickup_date_to);
1058: END IF;
1059:
1060: ------------------------------------------------------------------------------------------

Line 1057: WSH_DEBUG_SV.log(l_module_name,'P_PICKUP_DATE_TO',p_pickup_date_to);

1053: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_FROM_ID',p_delivery_from_id);
1054: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_TO_ID',p_delivery_to_id);
1055: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',p_ship_method_code);
1056: WSH_DEBUG_SV.log(l_module_name,'P_PICKUP_DATE_FROM',p_pickup_date_from);
1057: WSH_DEBUG_SV.log(l_module_name,'P_PICKUP_DATE_TO',p_pickup_date_to);
1058: END IF;
1059:
1060: ------------------------------------------------------------------------------------------
1061: -- Performs Export Screening For Deliveries on Pick Release Event

Line 1072: WSH_DEBUG_SV.pop(l_module_name);

1068: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1069: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error in procedure WSH_ITM_EXPORT_SCREENING.SCREEN_DELIVERIES for Pick Release event ');
1070: retcode := 2;
1071: IF l_debug_on THEN
1072: WSH_DEBUG_SV.pop(l_module_name);
1073: END IF;
1074: RETURN;
1075: END IF;
1076:

Line 1088: WSH_DEBUG_SV.pop(l_module_name);

1084: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1085: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error in procedure WSH_ITM_EXPORT_SCREENING.SCREEN_DELIVERIES for Ship Confirm event ');
1086: retcode := 2;
1087: IF l_debug_on THEN
1088: WSH_DEBUG_SV.pop(l_module_name);
1089: END IF;
1090: RETURN;
1091: END IF;
1092:

Line 1094: WSH_DEBUG_SV.pop(l_module_name);

1090: RETURN;
1091: END IF;
1092:
1093: IF l_debug_on THEN
1094: WSH_DEBUG_SV.pop(l_module_name);
1095: END IF;
1096:
1097: EXCEPTION
1098: WHEN OTHERS THEN

Line 1102: WSH_DEBUG_SV.log(l_module_name,'The unexpected Error Code ' || SQLCODE || ' : ' || SQLERRM);

1098: WHEN OTHERS THEN
1099:
1100: ROLLBACK TO WSH_ITM_EXPORT_COMPLIANCE;
1101: IF l_debug_on THEN
1102: WSH_DEBUG_SV.log(l_module_name,'The unexpected Error Code ' || SQLCODE || ' : ' || SQLERRM);
1103: END IF;
1104: retcode := 2;
1105:
1106: IF l_debug_on THEN

Line 1107: WSH_DEBUG_SV.pop(l_module_name);

1103: END IF;
1104: retcode := 2;
1105:
1106: IF l_debug_on THEN
1107: WSH_DEBUG_SV.pop(l_module_name);
1108: END IF;
1109:
1110: END SCREEN_DELIVERIES;
1111: