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_DOCUMENT_PVT dependencies on WSH_DEBUG_SV

Line 65: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

61: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
62: --
63: IF l_debug_on IS NULL
64: THEN
65: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
66: END IF;
67: --
68: IF l_debug_on THEN
69: WSH_DEBUG_SV.push(l_module_name);

Line 69: WSH_DEBUG_SV.push(l_module_name);

65: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
66: END IF;
67: --
68: IF l_debug_on THEN
69: WSH_DEBUG_SV.push(l_module_name);
70: --
71: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
72: END IF;
73: --

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

67: --
68: IF l_debug_on THEN
69: WSH_DEBUG_SV.push(l_module_name);
70: --
71: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
72: END IF;
73: --
74: x_child_delivery_tab := delivery_id_tabtype();
75: -- add children of this delivery id into the table

Line 82: WSH_DEBUG_SV.log(l_module_name,'X_CHILD_DELIVERY_TAB.COUNT',x_child_delivery_tab.count);

78: --
79: -- Debug Statements
80: --
81: IF l_debug_on THEN
82: WSH_DEBUG_SV.log(l_module_name,'X_CHILD_DELIVERY_TAB.COUNT',x_child_delivery_tab.count);
83: WSH_DEBUG_SV.pop(l_module_name);
84: END IF;
85: --
86: END Get_ChildDeliveryTab;

Line 83: WSH_DEBUG_SV.pop(l_module_name);

79: -- Debug Statements
80: --
81: IF l_debug_on THEN
82: WSH_DEBUG_SV.log(l_module_name,'X_CHILD_DELIVERY_TAB.COUNT',x_child_delivery_tab.count);
83: WSH_DEBUG_SV.pop(l_module_name);
84: END IF;
85: --
86: END Get_ChildDeliveryTab;
87:

Line 130: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

126: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
127: --
128: IF l_debug_on IS NULL
129: THEN
130: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
131: END IF;
132: --
133: IF l_debug_on THEN
134: WSH_DEBUG_SV.push(l_module_name);

Line 134: WSH_DEBUG_SV.push(l_module_name);

130: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
131: END IF;
132: --
133: IF l_debug_on THEN
134: WSH_DEBUG_SV.push(l_module_name);
135: --
136: WSH_DEBUG_SV.log(l_module_name,'P_DOC_SEQUENCE_ID',P_DOC_SEQUENCE_ID);
137: END IF;
138: --

Line 136: WSH_DEBUG_SV.log(l_module_name,'P_DOC_SEQUENCE_ID',P_DOC_SEQUENCE_ID);

132: --
133: IF l_debug_on THEN
134: WSH_DEBUG_SV.push(l_module_name);
135: --
136: WSH_DEBUG_SV.log(l_module_name,'P_DOC_SEQUENCE_ID',P_DOC_SEQUENCE_ID);
137: END IF;
138: --
139: OPEN type_csr;
140: FETCH type_csr INTO type_rec;

Line 147: WSH_DEBUG_SV.log(l_module_name,'TYPE',l_type);

143: --
144: -- Debug Statements
145: --
146: IF l_debug_on THEN
147: WSH_DEBUG_SV.log(l_module_name,'TYPE',l_type);
148: WSH_DEBUG_SV.pop(l_module_name);
149: END IF;
150: --
151: RETURN l_type;

Line 148: WSH_DEBUG_SV.pop(l_module_name);

144: -- Debug Statements
145: --
146: IF l_debug_on THEN
147: WSH_DEBUG_SV.log(l_module_name,'TYPE',l_type);
148: WSH_DEBUG_SV.pop(l_module_name);
149: END IF;
150: --
151: RETURN l_type;
152: END Get_Sequence_Type;

Line 190: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

186: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
187: --
188: IF l_debug_on IS NULL
189: THEN
190: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
191: END IF;
192: --
193: IF l_debug_on THEN
194: WSH_DEBUG_SV.push(l_module_name);

Line 194: WSH_DEBUG_SV.push(l_module_name);

190: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
191: END IF;
192: --
193: IF l_debug_on THEN
194: WSH_DEBUG_SV.push(l_module_name);
195: --
196: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
197: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
198: END IF;

Line 196: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);

192: --
193: IF l_debug_on THEN
194: WSH_DEBUG_SV.push(l_module_name);
195: --
196: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
197: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
198: END IF;
199: --
200: IF ( p_entity_name IS NOT NULL )

Line 197: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);

193: IF l_debug_on THEN
194: WSH_DEBUG_SV.push(l_module_name);
195: --
196: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
197: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
198: END IF;
199: --
200: IF ( p_entity_name IS NOT NULL )
201: THEN

Line 219: WSH_DEBUG_SV.log(l_module_name,'ENTITY_NAME',l_entity_name);

215: --
216: -- Debug Statements
217: --
218: IF l_debug_on THEN
219: WSH_DEBUG_SV.log(l_module_name,'ENTITY_NAME',l_entity_name);
220: WSH_DEBUG_SV.pop(l_module_name);
221: END IF;
222: --
223: RETURN l_entity_name;

Line 220: WSH_DEBUG_SV.pop(l_module_name);

216: -- Debug Statements
217: --
218: IF l_debug_on THEN
219: WSH_DEBUG_SV.log(l_module_name,'ENTITY_NAME',l_entity_name);
220: WSH_DEBUG_SV.pop(l_module_name);
221: END IF;
222: --
223: RETURN l_entity_name;
224: END Init_Entity_Name;

Line 274: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

270: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
271: --
272: IF l_debug_on IS NULL
273: THEN
274: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
275: END IF;
276: --
277: IF l_debug_on THEN
278: WSH_DEBUG_SV.push(l_module_name);

Line 278: WSH_DEBUG_SV.push(l_module_name);

274: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
275: END IF;
276: --
277: IF l_debug_on THEN
278: WSH_DEBUG_SV.push(l_module_name);
279: --
280: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
281: WSH_DEBUG_SV.log(l_module_name,'P_PICK_UP_STOP_ID',P_PICK_UP_STOP_ID);
282: WSH_DEBUG_SV.log(l_module_name,'P_DROP_OFF_STOP_ID',P_DROP_OFF_STOP_ID);

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

276: --
277: IF l_debug_on THEN
278: WSH_DEBUG_SV.push(l_module_name);
279: --
280: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
281: WSH_DEBUG_SV.log(l_module_name,'P_PICK_UP_STOP_ID',P_PICK_UP_STOP_ID);
282: WSH_DEBUG_SV.log(l_module_name,'P_DROP_OFF_STOP_ID',P_DROP_OFF_STOP_ID);
283: END IF;
284: --

Line 281: WSH_DEBUG_SV.log(l_module_name,'P_PICK_UP_STOP_ID',P_PICK_UP_STOP_ID);

277: IF l_debug_on THEN
278: WSH_DEBUG_SV.push(l_module_name);
279: --
280: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
281: WSH_DEBUG_SV.log(l_module_name,'P_PICK_UP_STOP_ID',P_PICK_UP_STOP_ID);
282: WSH_DEBUG_SV.log(l_module_name,'P_DROP_OFF_STOP_ID',P_DROP_OFF_STOP_ID);
283: END IF;
284: --
285: OPEN delivery_leg_csr;

Line 282: WSH_DEBUG_SV.log(l_module_name,'P_DROP_OFF_STOP_ID',P_DROP_OFF_STOP_ID);

278: WSH_DEBUG_SV.push(l_module_name);
279: --
280: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
281: WSH_DEBUG_SV.log(l_module_name,'P_PICK_UP_STOP_ID',P_PICK_UP_STOP_ID);
282: WSH_DEBUG_SV.log(l_module_name,'P_DROP_OFF_STOP_ID',P_DROP_OFF_STOP_ID);
283: END IF;
284: --
285: OPEN delivery_leg_csr;
286: FETCH delivery_leg_csr INTO l_delivery_leg_id;

Line 299: WSH_DEBUG_SV.log(l_module_name,'DELIVERY_LEG_ID',l_delivery_leg_id);

295: --
296: -- Debug Statements
297: --
298: IF l_debug_on THEN
299: WSH_DEBUG_SV.log(l_module_name,'DELIVERY_LEG_ID',l_delivery_leg_id);
300: WSH_DEBUG_SV.pop(l_module_name);
301: END IF;
302: --
303: RETURN l_delivery_leg_id;

Line 300: WSH_DEBUG_SV.pop(l_module_name);

296: -- Debug Statements
297: --
298: IF l_debug_on THEN
299: WSH_DEBUG_SV.log(l_module_name,'DELIVERY_LEG_ID',l_delivery_leg_id);
300: WSH_DEBUG_SV.pop(l_module_name);
301: END IF;
302: --
303: RETURN l_delivery_leg_id;
304: END Get_Delivery_Leg_Id;

Line 415: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

411: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
412: --
413: IF l_debug_on IS NULL
414: THEN
415: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
416: END IF;
417: --
418: IF l_debug_on THEN
419: WSH_DEBUG_SV.push(l_module_name);

Line 419: WSH_DEBUG_SV.push(l_module_name);

415: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
416: END IF;
417: --
418: IF l_debug_on THEN
419: WSH_DEBUG_SV.push(l_module_name);
420: --
421: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
422: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
423: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

Line 421: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);

417: --
418: IF l_debug_on THEN
419: WSH_DEBUG_SV.push(l_module_name);
420: --
421: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
422: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
423: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
424: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
425: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);

Line 422: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);

418: IF l_debug_on THEN
419: WSH_DEBUG_SV.push(l_module_name);
420: --
421: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
422: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
423: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
424: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
425: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);
426: WSH_DEBUG_SV.log(l_module_name,'P_LEDGER_ID',P_LEDGER_ID); -- LE Uptake

Line 423: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

419: WSH_DEBUG_SV.push(l_module_name);
420: --
421: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
422: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
423: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
424: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
425: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);
426: WSH_DEBUG_SV.log(l_module_name,'P_LEDGER_ID',P_LEDGER_ID); -- LE Uptake
427: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);

Line 424: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);

420: --
421: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
422: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
423: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
424: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
425: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);
426: WSH_DEBUG_SV.log(l_module_name,'P_LEDGER_ID',P_LEDGER_ID); -- LE Uptake
427: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
428: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_CODE',P_DOCUMENT_CODE);

Line 425: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);

421: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
422: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
423: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
424: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
425: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);
426: WSH_DEBUG_SV.log(l_module_name,'P_LEDGER_ID',P_LEDGER_ID); -- LE Uptake
427: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
428: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_CODE',P_DOCUMENT_CODE);
429: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);

Line 426: WSH_DEBUG_SV.log(l_module_name,'P_LEDGER_ID',P_LEDGER_ID); -- LE Uptake

422: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
423: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
424: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
425: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);
426: WSH_DEBUG_SV.log(l_module_name,'P_LEDGER_ID',P_LEDGER_ID); -- LE Uptake
427: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
428: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_CODE',P_DOCUMENT_CODE);
429: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
430: END IF;

Line 427: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);

423: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
424: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
425: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);
426: WSH_DEBUG_SV.log(l_module_name,'P_LEDGER_ID',P_LEDGER_ID); -- LE Uptake
427: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
428: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_CODE',P_DOCUMENT_CODE);
429: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
430: END IF;
431: --

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

424: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
425: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);
426: WSH_DEBUG_SV.log(l_module_name,'P_LEDGER_ID',P_LEDGER_ID); -- LE Uptake
427: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
428: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_CODE',P_DOCUMENT_CODE);
429: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
430: END IF;
431: --
432: IF NOT FND_API.Compatible_API_Call ( l_api_version,

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

425: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);
426: WSH_DEBUG_SV.log(l_module_name,'P_LEDGER_ID',P_LEDGER_ID); -- LE Uptake
427: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
428: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_CODE',P_DOCUMENT_CODE);
429: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
430: END IF;
431: --
432: IF NOT FND_API.Compatible_API_Call ( l_api_version,
433: p_api_version,

Line 479: WSH_DEBUG_SV.log(l_module_name,'TYPE',l_type);

475: --
476: -- Debug Statements
477: --
478: IF l_debug_on THEN
479: WSH_DEBUG_SV.log(l_module_name,'TYPE',l_type);
480: WSH_DEBUG_SV.pop(l_module_name);
481: END IF;
482: --
483: RETURN l_type;

Line 480: WSH_DEBUG_SV.pop(l_module_name);

476: -- Debug Statements
477: --
478: IF l_debug_on THEN
479: WSH_DEBUG_SV.log(l_module_name,'TYPE',l_type);
480: WSH_DEBUG_SV.pop(l_module_name);
481: END IF;
482: --
483: RETURN l_type;
484: EXCEPTION

Line 494: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

490: --
491: -- Debug Statements
492: --
493: IF l_debug_on THEN
494: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
495: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
496: END IF;
497: --
498: RETURN null;

Line 495: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

491: -- Debug Statements
492: --
493: IF l_debug_on THEN
494: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
495: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
496: END IF;
497: --
498: RETURN null;
499:

Line 508: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

504: --
505: -- Debug Statements
506: --
507: IF l_debug_on THEN
508: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
509: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
510: END IF;
511: --
512: RETURN null;

Line 509: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

505: -- Debug Statements
506: --
507: IF l_debug_on THEN
508: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
509: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
510: END IF;
511: --
512: RETURN null;
513:

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

521: --
522: -- Debug Statements
523: --
524: IF l_debug_on THEN
525: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
526: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
527: END IF;
528: --
529: RETURN null;

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

522: -- Debug Statements
523: --
524: IF l_debug_on THEN
525: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
526: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
527: END IF;
528: --
529: RETURN null;
530:

Line 603: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

599: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
600: --
601: IF l_debug_on IS NULL
602: THEN
603: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
604: END IF;
605: --
606: IF l_debug_on THEN
607: WSH_DEBUG_SV.push(l_module_name);

Line 607: WSH_DEBUG_SV.push(l_module_name);

603: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
604: END IF;
605: --
606: IF l_debug_on THEN
607: WSH_DEBUG_SV.push(l_module_name);
608: --
609: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
610: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
611: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

Line 609: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);

605: --
606: IF l_debug_on THEN
607: WSH_DEBUG_SV.push(l_module_name);
608: --
609: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
610: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
611: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
612: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
613: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);

Line 610: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);

606: IF l_debug_on THEN
607: WSH_DEBUG_SV.push(l_module_name);
608: --
609: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
610: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
611: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
612: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
613: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
614: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);

Line 611: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

607: WSH_DEBUG_SV.push(l_module_name);
608: --
609: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
610: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
611: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
612: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
613: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
614: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
615: END IF;

Line 612: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);

608: --
609: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
610: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
611: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
612: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
613: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
614: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
615: END IF;
616: --

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

609: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
610: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
611: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
612: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
613: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
614: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
615: END IF;
616: --
617: IF NOT FND_API.Compatible_API_Call ( l_api_version,

Line 614: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);

610: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
611: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
612: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
613: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
614: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
615: END IF;
616: --
617: IF NOT FND_API.Compatible_API_Call ( l_api_version,
618: p_api_version,

Line 651: WSH_DEBUG_SV.log(l_module_name,'IS FINAL',l_isfinal);

647: --
648: -- Debug Statements
649: --
650: IF l_debug_on THEN
651: WSH_DEBUG_SV.log(l_module_name,'IS FINAL',l_isfinal);
652: WSH_DEBUG_SV.pop(l_module_name);
653: END IF;
654: --
655: RETURN l_isfinal;

Line 652: WSH_DEBUG_SV.pop(l_module_name);

648: -- Debug Statements
649: --
650: IF l_debug_on THEN
651: WSH_DEBUG_SV.log(l_module_name,'IS FINAL',l_isfinal);
652: WSH_DEBUG_SV.pop(l_module_name);
653: END IF;
654: --
655: RETURN l_isfinal;
656:

Line 667: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

663: --
664: -- Debug Statements
665: --
666: IF l_debug_on THEN
667: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
668: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
669: END IF;
670: --
671: RETURN null;

Line 668: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

664: -- Debug Statements
665: --
666: IF l_debug_on THEN
667: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
668: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
669: END IF;
670: --
671: RETURN null;
672:

Line 681: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

677: --
678: -- Debug Statements
679: --
680: IF l_debug_on THEN
681: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
682: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
683: END IF;
684: --
685: RETURN null;

Line 682: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

678: -- Debug Statements
679: --
680: IF l_debug_on THEN
681: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
682: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
683: END IF;
684: --
685: RETURN null;
686:

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

694: --
695: -- Debug Statements
696: --
697: IF l_debug_on THEN
698: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
699: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
700: END IF;
701: --
702: RETURN null;

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

695: -- Debug Statements
696: --
697: IF l_debug_on THEN
698: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
699: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
700: END IF;
701: --
702: RETURN null;
703:

Line 774: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

770: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
771: --
772: IF l_debug_on IS NULL
773: THEN
774: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
775: END IF;
776: --
777: IF l_debug_on THEN
778: WSH_DEBUG_SV.push(l_module_name);

Line 778: WSH_DEBUG_SV.push(l_module_name);

774: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
775: END IF;
776: --
777: IF l_debug_on THEN
778: WSH_DEBUG_SV.push(l_module_name);
779: --
780: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
781: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
782: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

Line 780: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);

776: --
777: IF l_debug_on THEN
778: WSH_DEBUG_SV.push(l_module_name);
779: --
780: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
781: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
782: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
783: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
784: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);

Line 781: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);

777: IF l_debug_on THEN
778: WSH_DEBUG_SV.push(l_module_name);
779: --
780: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
781: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
782: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
783: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
784: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
785: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);

Line 782: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

778: WSH_DEBUG_SV.push(l_module_name);
779: --
780: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
781: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
782: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
783: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
784: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
785: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
786: WSH_DEBUG_SV.log(l_module_name,'P_FINAL_PRINT_DATE',P_FINAL_PRINT_DATE);

Line 783: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);

779: --
780: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
781: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
782: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
783: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
784: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
785: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
786: WSH_DEBUG_SV.log(l_module_name,'P_FINAL_PRINT_DATE',P_FINAL_PRINT_DATE);
787: END IF;

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

780: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
781: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
782: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
783: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
784: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
785: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
786: WSH_DEBUG_SV.log(l_module_name,'P_FINAL_PRINT_DATE',P_FINAL_PRINT_DATE);
787: END IF;
788: --

Line 785: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);

781: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
782: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
783: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
784: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
785: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
786: WSH_DEBUG_SV.log(l_module_name,'P_FINAL_PRINT_DATE',P_FINAL_PRINT_DATE);
787: END IF;
788: --
789: SAVEPOINT WSH_Document_PVT;

Line 786: WSH_DEBUG_SV.log(l_module_name,'P_FINAL_PRINT_DATE',P_FINAL_PRINT_DATE);

782: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
783: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
784: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
785: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
786: WSH_DEBUG_SV.log(l_module_name,'P_FINAL_PRINT_DATE',P_FINAL_PRINT_DATE);
787: END IF;
788: --
789: SAVEPOINT WSH_Document_PVT;
790:

Line 831: WSH_DEBUG_SV.pop(l_module_name);

827: --
828: -- Debug Statements
829: --
830: IF l_debug_on THEN
831: WSH_DEBUG_SV.pop(l_module_name);
832: END IF;
833: --
834: EXCEPTION
835:

Line 847: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

843: --
844: -- Debug Statements
845: --
846: IF l_debug_on THEN
847: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
848: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
849: END IF;
850: --
851: WHEN FND_API.g_exc_unexpected_error THEN

Line 848: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

844: -- Debug Statements
845: --
846: IF l_debug_on THEN
847: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
848: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
849: END IF;
850: --
851: WHEN FND_API.g_exc_unexpected_error THEN
852:

Line 861: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

857: --
858: -- Debug Statements
859: --
860: IF l_debug_on THEN
861: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
862: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
863: END IF;
864: --
865: WHEN others THEN

Line 862: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

858: -- Debug Statements
859: --
860: IF l_debug_on THEN
861: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
862: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
863: END IF;
864: --
865: WHEN others THEN
866:

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

877: --
878: -- Debug Statements
879: --
880: IF l_debug_on THEN
881: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
882: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
883: END IF;
884: --
885: END Set_Final_Print_Date;

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

878: -- Debug Statements
879: --
880: IF l_debug_on THEN
881: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
882: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
883: END IF;
884: --
885: END Set_Final_Print_Date;
886:

Line 1129: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1125: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1126: --
1127: IF l_debug_on IS NULL
1128: THEN
1129: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1130: END IF;
1131: --
1132: IF l_debug_on THEN
1133: WSH_DEBUG_SV.push(l_module_name);

Line 1133: WSH_DEBUG_SV.push(l_module_name);

1129: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1130: END IF;
1131: --
1132: IF l_debug_on THEN
1133: WSH_DEBUG_SV.push(l_module_name);
1134: --
1135: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1136: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1137: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

Line 1135: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);

1131: --
1132: IF l_debug_on THEN
1133: WSH_DEBUG_SV.push(l_module_name);
1134: --
1135: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1136: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1137: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1138: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1139: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);

Line 1136: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);

1132: IF l_debug_on THEN
1133: WSH_DEBUG_SV.push(l_module_name);
1134: --
1135: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1136: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1137: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1138: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1139: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
1140: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);

Line 1137: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

1133: WSH_DEBUG_SV.push(l_module_name);
1134: --
1135: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1136: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1137: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1138: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1139: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
1140: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
1141: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);

Line 1138: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);

1134: --
1135: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1136: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1137: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1138: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1139: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
1140: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
1141: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);
1142: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);

Line 1139: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);

1135: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1136: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1137: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1138: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1139: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
1140: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
1141: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);
1142: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
1143: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);

Line 1140: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);

1136: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1137: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1138: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1139: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
1140: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
1141: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);
1142: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
1143: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
1144: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_SUB_TYPE',P_DOCUMENT_SUB_TYPE);

Line 1141: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);

1137: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1138: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1139: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
1140: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
1141: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);
1142: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
1143: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
1144: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_SUB_TYPE',P_DOCUMENT_SUB_TYPE);
1145: WSH_DEBUG_SV.log(l_module_name,'P_LEDGER_ID',P_LEDGER_ID); -- LE Uptake

Line 1142: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);

1138: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1139: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
1140: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
1141: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);
1142: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
1143: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
1144: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_SUB_TYPE',P_DOCUMENT_SUB_TYPE);
1145: WSH_DEBUG_SV.log(l_module_name,'P_LEDGER_ID',P_LEDGER_ID); -- LE Uptake
1146: WSH_DEBUG_SV.log(l_module_name,'P_CONSOLIDATE_OPTION',P_CONSOLIDATE_OPTION);

Line 1143: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);

1139: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
1140: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
1141: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);
1142: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
1143: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
1144: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_SUB_TYPE',P_DOCUMENT_SUB_TYPE);
1145: WSH_DEBUG_SV.log(l_module_name,'P_LEDGER_ID',P_LEDGER_ID); -- LE Uptake
1146: WSH_DEBUG_SV.log(l_module_name,'P_CONSOLIDATE_OPTION',P_CONSOLIDATE_OPTION);
1147: WSH_DEBUG_SV.log(l_module_name,'P_MANUAL_SEQUENCE_NUMBER',P_MANUAL_SEQUENCE_NUMBER);

Line 1144: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_SUB_TYPE',P_DOCUMENT_SUB_TYPE);

1140: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
1141: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);
1142: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
1143: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
1144: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_SUB_TYPE',P_DOCUMENT_SUB_TYPE);
1145: WSH_DEBUG_SV.log(l_module_name,'P_LEDGER_ID',P_LEDGER_ID); -- LE Uptake
1146: WSH_DEBUG_SV.log(l_module_name,'P_CONSOLIDATE_OPTION',P_CONSOLIDATE_OPTION);
1147: WSH_DEBUG_SV.log(l_module_name,'P_MANUAL_SEQUENCE_NUMBER',P_MANUAL_SEQUENCE_NUMBER);
1148: END IF;

Line 1145: WSH_DEBUG_SV.log(l_module_name,'P_LEDGER_ID',P_LEDGER_ID); -- LE Uptake

1141: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);
1142: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
1143: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
1144: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_SUB_TYPE',P_DOCUMENT_SUB_TYPE);
1145: WSH_DEBUG_SV.log(l_module_name,'P_LEDGER_ID',P_LEDGER_ID); -- LE Uptake
1146: WSH_DEBUG_SV.log(l_module_name,'P_CONSOLIDATE_OPTION',P_CONSOLIDATE_OPTION);
1147: WSH_DEBUG_SV.log(l_module_name,'P_MANUAL_SEQUENCE_NUMBER',P_MANUAL_SEQUENCE_NUMBER);
1148: END IF;
1149: --

Line 1146: WSH_DEBUG_SV.log(l_module_name,'P_CONSOLIDATE_OPTION',P_CONSOLIDATE_OPTION);

1142: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
1143: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
1144: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_SUB_TYPE',P_DOCUMENT_SUB_TYPE);
1145: WSH_DEBUG_SV.log(l_module_name,'P_LEDGER_ID',P_LEDGER_ID); -- LE Uptake
1146: WSH_DEBUG_SV.log(l_module_name,'P_CONSOLIDATE_OPTION',P_CONSOLIDATE_OPTION);
1147: WSH_DEBUG_SV.log(l_module_name,'P_MANUAL_SEQUENCE_NUMBER',P_MANUAL_SEQUENCE_NUMBER);
1148: END IF;
1149: --
1150: SAVEPOINT WSH_Document_PVT;

Line 1147: WSH_DEBUG_SV.log(l_module_name,'P_MANUAL_SEQUENCE_NUMBER',P_MANUAL_SEQUENCE_NUMBER);

1143: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
1144: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_SUB_TYPE',P_DOCUMENT_SUB_TYPE);
1145: WSH_DEBUG_SV.log(l_module_name,'P_LEDGER_ID',P_LEDGER_ID); -- LE Uptake
1146: WSH_DEBUG_SV.log(l_module_name,'P_CONSOLIDATE_OPTION',P_CONSOLIDATE_OPTION);
1147: WSH_DEBUG_SV.log(l_module_name,'P_MANUAL_SEQUENCE_NUMBER',P_MANUAL_SEQUENCE_NUMBER);
1148: END IF;
1149: --
1150: SAVEPOINT WSH_Document_PVT;
1151:

Line 1307: WSH_DEBUG_SV.logmsg(l_module_name, 'Doc Number exists already');

1303: --Fix for bug 3878973
1304: --If document exists already, just return success
1305:
1306: IF l_debug_on THEN
1307: WSH_DEBUG_SV.logmsg(l_module_name, 'Doc Number exists already');
1308: WSH_DEBUG_SV.pop(l_module_name);
1309: END IF;
1310: RETURN;
1311: END IF;

Line 1308: WSH_DEBUG_SV.pop(l_module_name);

1304: --If document exists already, just return success
1305:
1306: IF l_debug_on THEN
1307: WSH_DEBUG_SV.logmsg(l_module_name, 'Doc Number exists already');
1308: WSH_DEBUG_SV.pop(l_module_name);
1309: END IF;
1310: RETURN;
1311: END IF;
1312: CLOSE document_csr;

Line 1534: WSH_DEBUG_SV.logmsg(l_module_name, 'Doc Number exists already');

1530:
1531: --Fix for bug 3878973
1532: --If document exists already, just return success
1533: IF l_debug_on THEN
1534: WSH_DEBUG_SV.logmsg(l_module_name, 'Doc Number exists already');
1535: WSH_DEBUG_SV.pop(l_module_name);
1536: END IF;
1537: RETURN;
1538: END IF;

Line 1535: WSH_DEBUG_SV.pop(l_module_name);

1531: --Fix for bug 3878973
1532: --If document exists already, just return success
1533: IF l_debug_on THEN
1534: WSH_DEBUG_SV.logmsg(l_module_name, 'Doc Number exists already');
1535: WSH_DEBUG_SV.pop(l_module_name);
1536: END IF;
1537: RETURN;
1538: END IF;
1539: CLOSE document_csr;

Line 1675: WSH_DEBUG_SV.pop(l_module_name);

1671: --
1672: -- Debug Statements
1673: --
1674: IF l_debug_on THEN
1675: WSH_DEBUG_SV.pop(l_module_name);
1676: END IF;
1677: --
1678: EXCEPTION
1679:

Line 1700: WSH_DEBUG_SV.logmsg(l_module_name,'Cannot lock delivery leg for update');

1696:
1697: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
1698: p_data => x_msg_data );
1699: IF l_debug_on THEN
1700: WSH_DEBUG_SV.logmsg(l_module_name,'Cannot lock delivery leg for update');
1701: END IF;
1702:
1703: WHEN FND_API.g_exc_error THEN
1704: --Bug 4284167 (FP Bug 4149501)

Line 1717: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1713: --
1714: -- Debug Statements
1715: --
1716: IF l_debug_on THEN
1717: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1718: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1719: END IF;
1720: --
1721: WHEN FND_API.g_exc_unexpected_error THEN

Line 1718: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

1714: -- Debug Statements
1715: --
1716: IF l_debug_on THEN
1717: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1718: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1719: END IF;
1720: --
1721: WHEN FND_API.g_exc_unexpected_error THEN
1722: --Bug 4284167 (FP Bug 4149501)

Line 1735: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1731: --
1732: -- Debug Statements
1733: --
1734: IF l_debug_on THEN
1735: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1736: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1737: END IF;
1738: --
1739: WHEN others THEN

Line 1736: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

1732: -- Debug Statements
1733: --
1734: IF l_debug_on THEN
1735: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1736: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1737: END IF;
1738: --
1739: WHEN others THEN
1740: --Bug 4284167 (FP Bug 4149501)

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

1755: --
1756: -- Debug Statements
1757: --
1758: IF l_debug_on THEN
1759: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1760: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1761: END IF;
1762: --
1763: END Create_Document;

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

1756: -- Debug Statements
1757: --
1758: IF l_debug_on THEN
1759: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1760: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1761: END IF;
1762: --
1763: END Create_Document;
1764:

Line 1908: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1904: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1905: --
1906: IF l_debug_on IS NULL
1907: THEN
1908: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1909: END IF;
1910: --
1911: IF l_debug_on THEN
1912: WSH_DEBUG_SV.push(l_module_name);

Line 1912: WSH_DEBUG_SV.push(l_module_name);

1908: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1909: END IF;
1910: --
1911: IF l_debug_on THEN
1912: WSH_DEBUG_SV.push(l_module_name);
1913: --
1914: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1915: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1916: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

Line 1914: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);

1910: --
1911: IF l_debug_on THEN
1912: WSH_DEBUG_SV.push(l_module_name);
1913: --
1914: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1915: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1916: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1917: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1918: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);

Line 1915: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);

1911: IF l_debug_on THEN
1912: WSH_DEBUG_SV.push(l_module_name);
1913: --
1914: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1915: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1916: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1917: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1918: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
1919: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);

Line 1916: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

1912: WSH_DEBUG_SV.push(l_module_name);
1913: --
1914: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1915: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1916: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1917: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1918: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
1919: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
1920: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);

Line 1917: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);

1913: --
1914: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1915: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1916: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1917: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1918: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
1919: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
1920: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
1921: WSH_DEBUG_SV.log(l_module_name,'P_LEDGER_ID',P_LEDGER_ID); -- LE Uptake

Line 1918: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);

1914: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1915: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1916: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1917: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1918: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
1919: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
1920: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
1921: WSH_DEBUG_SV.log(l_module_name,'P_LEDGER_ID',P_LEDGER_ID); -- LE Uptake
1922: WSH_DEBUG_SV.log(l_module_name,'P_CONSOLIDATE_OPTION',P_CONSOLIDATE_OPTION);

Line 1919: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);

1915: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1916: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1917: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1918: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
1919: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
1920: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
1921: WSH_DEBUG_SV.log(l_module_name,'P_LEDGER_ID',P_LEDGER_ID); -- LE Uptake
1922: WSH_DEBUG_SV.log(l_module_name,'P_CONSOLIDATE_OPTION',P_CONSOLIDATE_OPTION);
1923: END IF;

Line 1920: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);

1916: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1917: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1918: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
1919: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
1920: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
1921: WSH_DEBUG_SV.log(l_module_name,'P_LEDGER_ID',P_LEDGER_ID); -- LE Uptake
1922: WSH_DEBUG_SV.log(l_module_name,'P_CONSOLIDATE_OPTION',P_CONSOLIDATE_OPTION);
1923: END IF;
1924: --

Line 1921: WSH_DEBUG_SV.log(l_module_name,'P_LEDGER_ID',P_LEDGER_ID); -- LE Uptake

1917: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1918: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
1919: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
1920: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
1921: WSH_DEBUG_SV.log(l_module_name,'P_LEDGER_ID',P_LEDGER_ID); -- LE Uptake
1922: WSH_DEBUG_SV.log(l_module_name,'P_CONSOLIDATE_OPTION',P_CONSOLIDATE_OPTION);
1923: END IF;
1924: --
1925: SAVEPOINT WSH_Document_PVT;

Line 1922: WSH_DEBUG_SV.log(l_module_name,'P_CONSOLIDATE_OPTION',P_CONSOLIDATE_OPTION);

1918: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
1919: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
1920: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
1921: WSH_DEBUG_SV.log(l_module_name,'P_LEDGER_ID',P_LEDGER_ID); -- LE Uptake
1922: WSH_DEBUG_SV.log(l_module_name,'P_CONSOLIDATE_OPTION',P_CONSOLIDATE_OPTION);
1923: END IF;
1924: --
1925: SAVEPOINT WSH_Document_PVT;
1926:

Line 2065: WSH_DEBUG_SV.pop(l_module_name);

2061: --
2062: -- Debug Statements
2063: --
2064: IF l_debug_on THEN
2065: WSH_DEBUG_SV.pop(l_module_name);
2066: END IF;
2067: --
2068: EXCEPTION
2069:

Line 2080: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2076: --
2077: -- Debug Statements
2078: --
2079: IF l_debug_on THEN
2080: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2081: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2082: END IF;
2083: --
2084: WHEN FND_API.g_exc_unexpected_error THEN

Line 2081: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

2077: -- Debug Statements
2078: --
2079: IF l_debug_on THEN
2080: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2081: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2082: END IF;
2083: --
2084: WHEN FND_API.g_exc_unexpected_error THEN
2085: ROLLBACK to WSH_Document_PVT;

Line 2094: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2090: --
2091: -- Debug Statements
2092: --
2093: IF l_debug_on THEN
2094: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2095: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2096: END IF;
2097: --
2098: WHEN others THEN

Line 2095: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

2091: -- Debug Statements
2092: --
2093: IF l_debug_on THEN
2094: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2095: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2096: END IF;
2097: --
2098: WHEN others THEN
2099: ROLLBACK to WSH_Document_PVT;

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

2108: --
2109: -- Debug Statements
2110: --
2111: IF l_debug_on THEN
2112: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2113: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2114: END IF;
2115: --
2116: END Update_Document;

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

2109: -- Debug Statements
2110: --
2111: IF l_debug_on THEN
2112: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2113: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2114: END IF;
2115: --
2116: END Update_Document;
2117:

Line 2231: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2227: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2228: --
2229: IF l_debug_on IS NULL
2230: THEN
2231: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2232: END IF;
2233: --
2234: IF l_debug_on THEN
2235: WSH_DEBUG_SV.push(l_module_name);

Line 2235: WSH_DEBUG_SV.push(l_module_name);

2231: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2232: END IF;
2233: --
2234: IF l_debug_on THEN
2235: WSH_DEBUG_SV.push(l_module_name);
2236: --
2237: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
2238: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2239: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

Line 2237: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);

2233: --
2234: IF l_debug_on THEN
2235: WSH_DEBUG_SV.push(l_module_name);
2236: --
2237: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
2238: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2239: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
2240: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
2241: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);

Line 2238: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);

2234: IF l_debug_on THEN
2235: WSH_DEBUG_SV.push(l_module_name);
2236: --
2237: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
2238: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2239: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
2240: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
2241: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
2242: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);

Line 2239: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

2235: WSH_DEBUG_SV.push(l_module_name);
2236: --
2237: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
2238: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2239: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
2240: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
2241: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
2242: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
2243: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);

Line 2240: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);

2236: --
2237: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
2238: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2239: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
2240: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
2241: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
2242: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
2243: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
2244: WSH_DEBUG_SV.log(l_module_name,'P_CONSOLIDATE_OPTION',P_CONSOLIDATE_OPTION);

Line 2241: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);

2237: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
2238: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2239: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
2240: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
2241: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
2242: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
2243: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
2244: WSH_DEBUG_SV.log(l_module_name,'P_CONSOLIDATE_OPTION',P_CONSOLIDATE_OPTION);
2245: END IF;

Line 2242: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);

2238: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2239: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
2240: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
2241: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
2242: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
2243: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
2244: WSH_DEBUG_SV.log(l_module_name,'P_CONSOLIDATE_OPTION',P_CONSOLIDATE_OPTION);
2245: END IF;
2246: --

Line 2243: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);

2239: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
2240: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
2241: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
2242: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
2243: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
2244: WSH_DEBUG_SV.log(l_module_name,'P_CONSOLIDATE_OPTION',P_CONSOLIDATE_OPTION);
2245: END IF;
2246: --
2247: SAVEPOINT WSH_Document_PVT;

Line 2244: WSH_DEBUG_SV.log(l_module_name,'P_CONSOLIDATE_OPTION',P_CONSOLIDATE_OPTION);

2240: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
2241: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
2242: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
2243: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
2244: WSH_DEBUG_SV.log(l_module_name,'P_CONSOLIDATE_OPTION',P_CONSOLIDATE_OPTION);
2245: END IF;
2246: --
2247: SAVEPOINT WSH_Document_PVT;
2248:

Line 2393: WSH_DEBUG_SV.pop(l_module_name);

2389: --
2390: -- Debug Statements
2391: --
2392: IF l_debug_on THEN
2393: WSH_DEBUG_SV.pop(l_module_name);
2394: END IF;
2395: --
2396: EXCEPTION
2397:

Line 2408: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2404: --
2405: -- Debug Statements
2406: --
2407: IF l_debug_on THEN
2408: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2409: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2410: END IF;
2411: --
2412: WHEN FND_API.g_exc_unexpected_error THEN

Line 2409: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

2405: -- Debug Statements
2406: --
2407: IF l_debug_on THEN
2408: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2409: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2410: END IF;
2411: --
2412: WHEN FND_API.g_exc_unexpected_error THEN
2413: ROLLBACK to WSH_Document_PVT;

Line 2422: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2418: --
2419: -- Debug Statements
2420: --
2421: IF l_debug_on THEN
2422: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2423: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2424: END IF;
2425: --
2426: WHEN others THEN

Line 2423: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

2419: -- Debug Statements
2420: --
2421: IF l_debug_on THEN
2422: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2423: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2424: END IF;
2425: --
2426: WHEN others THEN
2427: ROLLBACK to WSH_Document_PVT;

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

2436: --
2437: -- Debug Statements
2438: --
2439: IF l_debug_on THEN
2440: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2441: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2442: END IF;
2443: --
2444: END Cancel_Document;

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

2437: -- Debug Statements
2438: --
2439: IF l_debug_on THEN
2440: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2441: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2442: END IF;
2443: --
2444: END Cancel_Document;
2445:

Line 2550: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2546: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2547: --
2548: IF l_debug_on IS NULL
2549: THEN
2550: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2551: END IF;
2552: --
2553: IF l_debug_on THEN
2554: WSH_DEBUG_SV.push(l_module_name);

Line 2554: WSH_DEBUG_SV.push(l_module_name);

2550: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2551: END IF;
2552: --
2553: IF l_debug_on THEN
2554: WSH_DEBUG_SV.push(l_module_name);
2555: --
2556: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
2557: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2558: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

Line 2556: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);

2552: --
2553: IF l_debug_on THEN
2554: WSH_DEBUG_SV.push(l_module_name);
2555: --
2556: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
2557: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2558: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
2559: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
2560: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);

Line 2557: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);

2553: IF l_debug_on THEN
2554: WSH_DEBUG_SV.push(l_module_name);
2555: --
2556: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
2557: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2558: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
2559: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
2560: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
2561: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);

Line 2558: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

2554: WSH_DEBUG_SV.push(l_module_name);
2555: --
2556: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
2557: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2558: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
2559: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
2560: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
2561: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
2562: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);

Line 2559: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);

2555: --
2556: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
2557: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2558: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
2559: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
2560: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
2561: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
2562: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
2563: WSH_DEBUG_SV.log(l_module_name,'P_CONSOLIDATE_OPTION',P_CONSOLIDATE_OPTION);

Line 2560: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);

2556: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
2557: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2558: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
2559: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
2560: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
2561: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
2562: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
2563: WSH_DEBUG_SV.log(l_module_name,'P_CONSOLIDATE_OPTION',P_CONSOLIDATE_OPTION);
2564: END IF;

Line 2561: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);

2557: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2558: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
2559: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
2560: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
2561: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
2562: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
2563: WSH_DEBUG_SV.log(l_module_name,'P_CONSOLIDATE_OPTION',P_CONSOLIDATE_OPTION);
2564: END IF;
2565: --

Line 2562: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);

2558: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
2559: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
2560: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
2561: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
2562: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
2563: WSH_DEBUG_SV.log(l_module_name,'P_CONSOLIDATE_OPTION',P_CONSOLIDATE_OPTION);
2564: END IF;
2565: --
2566: SAVEPOINT WSH_Document_PVT;

Line 2563: WSH_DEBUG_SV.log(l_module_name,'P_CONSOLIDATE_OPTION',P_CONSOLIDATE_OPTION);

2559: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
2560: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
2561: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
2562: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
2563: WSH_DEBUG_SV.log(l_module_name,'P_CONSOLIDATE_OPTION',P_CONSOLIDATE_OPTION);
2564: END IF;
2565: --
2566: SAVEPOINT WSH_Document_PVT;
2567:

Line 2696: WSH_DEBUG_SV.pop(l_module_name);

2692: --
2693: -- Debug Statements
2694: --
2695: IF l_debug_on THEN
2696: WSH_DEBUG_SV.pop(l_module_name);
2697: END IF;
2698: --
2699: EXCEPTION
2700:

Line 2711: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2707: --
2708: -- Debug Statements
2709: --
2710: IF l_debug_on THEN
2711: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2712: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2713: END IF;
2714: --
2715: WHEN FND_API.g_exc_unexpected_error THEN

Line 2712: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

2708: -- Debug Statements
2709: --
2710: IF l_debug_on THEN
2711: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2712: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2713: END IF;
2714: --
2715: WHEN FND_API.g_exc_unexpected_error THEN
2716: ROLLBACK to WSH_Document_PVT;

Line 2725: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2721: --
2722: -- Debug Statements
2723: --
2724: IF l_debug_on THEN
2725: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2726: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2727: END IF;
2728: --
2729: WHEN others THEN

Line 2726: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

2722: -- Debug Statements
2723: --
2724: IF l_debug_on THEN
2725: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2726: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2727: END IF;
2728: --
2729: WHEN others THEN
2730: ROLLBACK to WSH_Document_PVT;

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

2739: --
2740: -- Debug Statements
2741: --
2742: IF l_debug_on THEN
2743: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2744: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2745: END IF;
2746: --
2747: END Open_Document;

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

2740: -- Debug Statements
2741: --
2742: IF l_debug_on THEN
2743: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2744: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2745: END IF;
2746: --
2747: END Open_Document;
2748:

Line 2854: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2850: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2851: --
2852: IF l_debug_on IS NULL
2853: THEN
2854: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2855: END IF;
2856: --
2857: IF l_debug_on THEN
2858: WSH_DEBUG_SV.push(l_module_name);

Line 2858: WSH_DEBUG_SV.push(l_module_name);

2854: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2855: END IF;
2856: --
2857: IF l_debug_on THEN
2858: WSH_DEBUG_SV.push(l_module_name);
2859: --
2860: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
2861: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2862: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

Line 2860: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);

2856: --
2857: IF l_debug_on THEN
2858: WSH_DEBUG_SV.push(l_module_name);
2859: --
2860: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
2861: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2862: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
2863: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
2864: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);

Line 2861: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);

2857: IF l_debug_on THEN
2858: WSH_DEBUG_SV.push(l_module_name);
2859: --
2860: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
2861: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2862: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
2863: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
2864: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
2865: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);

Line 2862: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

2858: WSH_DEBUG_SV.push(l_module_name);
2859: --
2860: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
2861: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2862: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
2863: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
2864: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
2865: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
2866: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);

Line 2863: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);

2859: --
2860: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
2861: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2862: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
2863: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
2864: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
2865: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
2866: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
2867: WSH_DEBUG_SV.log(l_module_name,'P_CONSOLIDATE_OPTION',P_CONSOLIDATE_OPTION);

Line 2864: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);

2860: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
2861: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2862: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
2863: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
2864: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
2865: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
2866: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
2867: WSH_DEBUG_SV.log(l_module_name,'P_CONSOLIDATE_OPTION',P_CONSOLIDATE_OPTION);
2868: END IF;

Line 2865: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);

2861: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2862: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
2863: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
2864: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
2865: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
2866: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
2867: WSH_DEBUG_SV.log(l_module_name,'P_CONSOLIDATE_OPTION',P_CONSOLIDATE_OPTION);
2868: END IF;
2869: --

Line 2866: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);

2862: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
2863: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
2864: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
2865: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
2866: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
2867: WSH_DEBUG_SV.log(l_module_name,'P_CONSOLIDATE_OPTION',P_CONSOLIDATE_OPTION);
2868: END IF;
2869: --
2870: SAVEPOINT WSH_Document_PVT;

Line 2867: WSH_DEBUG_SV.log(l_module_name,'P_CONSOLIDATE_OPTION',P_CONSOLIDATE_OPTION);

2863: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
2864: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
2865: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
2866: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
2867: WSH_DEBUG_SV.log(l_module_name,'P_CONSOLIDATE_OPTION',P_CONSOLIDATE_OPTION);
2868: END IF;
2869: --
2870: SAVEPOINT WSH_Document_PVT;
2871:

Line 3000: WSH_DEBUG_SV.pop(l_module_name);

2996: --
2997: -- Debug Statements
2998: --
2999: IF l_debug_on THEN
3000: WSH_DEBUG_SV.pop(l_module_name);
3001: END IF;
3002: --
3003: EXCEPTION
3004:

Line 3015: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

3011: --
3012: -- Debug Statements
3013: --
3014: IF l_debug_on THEN
3015: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3016: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3017: END IF;
3018: --
3019: WHEN FND_API.g_exc_unexpected_error THEN

Line 3016: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

3012: -- Debug Statements
3013: --
3014: IF l_debug_on THEN
3015: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3016: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3017: END IF;
3018: --
3019: WHEN FND_API.g_exc_unexpected_error THEN
3020: ROLLBACK to WSH_Document_PVT;

Line 3029: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

3025: --
3026: -- Debug Statements
3027: --
3028: IF l_debug_on THEN
3029: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3030: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3031: END IF;
3032: --
3033: WHEN others THEN

Line 3030: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

3026: -- Debug Statements
3027: --
3028: IF l_debug_on THEN
3029: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3030: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3031: END IF;
3032: --
3033: WHEN others THEN
3034: ROLLBACK to WSH_Document_PVT;

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

3043: --
3044: -- Debug Statements
3045: --
3046: IF l_debug_on THEN
3047: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3048: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3049: END IF;
3050: --
3051: END Complete_Document;

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

3044: -- Debug Statements
3045: --
3046: IF l_debug_on THEN
3047: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3048: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3049: END IF;
3050: --
3051: END Complete_Document;
3052:

Line 3136: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

3132: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3133: --
3134: IF l_debug_on IS NULL
3135: THEN
3136: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3137: END IF;
3138: --
3139: IF l_debug_on THEN
3140: WSH_DEBUG_SV.push(l_module_name);

Line 3140: WSH_DEBUG_SV.push(l_module_name);

3136: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3137: END IF;
3138: --
3139: IF l_debug_on THEN
3140: WSH_DEBUG_SV.push(l_module_name);
3141: --
3142: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
3143: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3144: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

Line 3142: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);

3138: --
3139: IF l_debug_on THEN
3140: WSH_DEBUG_SV.push(l_module_name);
3141: --
3142: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
3143: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3144: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
3145: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3146: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);

Line 3143: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);

3139: IF l_debug_on THEN
3140: WSH_DEBUG_SV.push(l_module_name);
3141: --
3142: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
3143: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3144: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
3145: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3146: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
3147: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);

Line 3144: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

3140: WSH_DEBUG_SV.push(l_module_name);
3141: --
3142: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
3143: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3144: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
3145: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3146: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
3147: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
3148: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_LO',P_DEPARTURE_DATE_LO);

Line 3145: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);

3141: --
3142: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
3143: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3144: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
3145: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3146: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
3147: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
3148: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_LO',P_DEPARTURE_DATE_LO);
3149: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_HI',P_DEPARTURE_DATE_HI);

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

3142: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
3143: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3144: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
3145: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3146: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
3147: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
3148: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_LO',P_DEPARTURE_DATE_LO);
3149: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_HI',P_DEPARTURE_DATE_HI);
3150: WSH_DEBUG_SV.log(l_module_name,'P_ITEM_DISPLAY',P_ITEM_DISPLAY);

Line 3147: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);

3143: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3144: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
3145: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3146: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
3147: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
3148: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_LO',P_DEPARTURE_DATE_LO);
3149: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_HI',P_DEPARTURE_DATE_HI);
3150: WSH_DEBUG_SV.log(l_module_name,'P_ITEM_DISPLAY',P_ITEM_DISPLAY);
3151: WSH_DEBUG_SV.log(l_module_name,'P_PRINT_CUST_ITEM',P_PRINT_CUST_ITEM);

Line 3148: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_LO',P_DEPARTURE_DATE_LO);

3144: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
3145: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3146: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
3147: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
3148: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_LO',P_DEPARTURE_DATE_LO);
3149: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_HI',P_DEPARTURE_DATE_HI);
3150: WSH_DEBUG_SV.log(l_module_name,'P_ITEM_DISPLAY',P_ITEM_DISPLAY);
3151: WSH_DEBUG_SV.log(l_module_name,'P_PRINT_CUST_ITEM',P_PRINT_CUST_ITEM);
3152: WSH_DEBUG_SV.log(l_module_name,'P_PRINT_MODE',P_PRINT_MODE);

Line 3149: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_HI',P_DEPARTURE_DATE_HI);

3145: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3146: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
3147: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
3148: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_LO',P_DEPARTURE_DATE_LO);
3149: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_HI',P_DEPARTURE_DATE_HI);
3150: WSH_DEBUG_SV.log(l_module_name,'P_ITEM_DISPLAY',P_ITEM_DISPLAY);
3151: WSH_DEBUG_SV.log(l_module_name,'P_PRINT_CUST_ITEM',P_PRINT_CUST_ITEM);
3152: WSH_DEBUG_SV.log(l_module_name,'P_PRINT_MODE',P_PRINT_MODE);
3153: WSH_DEBUG_SV.log(l_module_name,'P_PRINT_ALL',P_PRINT_ALL);

Line 3150: WSH_DEBUG_SV.log(l_module_name,'P_ITEM_DISPLAY',P_ITEM_DISPLAY);

3146: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
3147: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
3148: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_LO',P_DEPARTURE_DATE_LO);
3149: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_HI',P_DEPARTURE_DATE_HI);
3150: WSH_DEBUG_SV.log(l_module_name,'P_ITEM_DISPLAY',P_ITEM_DISPLAY);
3151: WSH_DEBUG_SV.log(l_module_name,'P_PRINT_CUST_ITEM',P_PRINT_CUST_ITEM);
3152: WSH_DEBUG_SV.log(l_module_name,'P_PRINT_MODE',P_PRINT_MODE);
3153: WSH_DEBUG_SV.log(l_module_name,'P_PRINT_ALL',P_PRINT_ALL);
3154: WSH_DEBUG_SV.log(l_module_name,'P_SORT',P_SORT);

Line 3151: WSH_DEBUG_SV.log(l_module_name,'P_PRINT_CUST_ITEM',P_PRINT_CUST_ITEM);

3147: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
3148: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_LO',P_DEPARTURE_DATE_LO);
3149: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_HI',P_DEPARTURE_DATE_HI);
3150: WSH_DEBUG_SV.log(l_module_name,'P_ITEM_DISPLAY',P_ITEM_DISPLAY);
3151: WSH_DEBUG_SV.log(l_module_name,'P_PRINT_CUST_ITEM',P_PRINT_CUST_ITEM);
3152: WSH_DEBUG_SV.log(l_module_name,'P_PRINT_MODE',P_PRINT_MODE);
3153: WSH_DEBUG_SV.log(l_module_name,'P_PRINT_ALL',P_PRINT_ALL);
3154: WSH_DEBUG_SV.log(l_module_name,'P_SORT',P_SORT);
3155: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_CARRIER',P_FREIGHT_CARRIER);

Line 3152: WSH_DEBUG_SV.log(l_module_name,'P_PRINT_MODE',P_PRINT_MODE);

3148: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_LO',P_DEPARTURE_DATE_LO);
3149: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_HI',P_DEPARTURE_DATE_HI);
3150: WSH_DEBUG_SV.log(l_module_name,'P_ITEM_DISPLAY',P_ITEM_DISPLAY);
3151: WSH_DEBUG_SV.log(l_module_name,'P_PRINT_CUST_ITEM',P_PRINT_CUST_ITEM);
3152: WSH_DEBUG_SV.log(l_module_name,'P_PRINT_MODE',P_PRINT_MODE);
3153: WSH_DEBUG_SV.log(l_module_name,'P_PRINT_ALL',P_PRINT_ALL);
3154: WSH_DEBUG_SV.log(l_module_name,'P_SORT',P_SORT);
3155: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_CARRIER',P_FREIGHT_CARRIER);
3156: WSH_DEBUG_SV.log(l_module_name,'P_WAREHOUSE_ID',P_WAREHOUSE_ID);

Line 3153: WSH_DEBUG_SV.log(l_module_name,'P_PRINT_ALL',P_PRINT_ALL);

3149: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_HI',P_DEPARTURE_DATE_HI);
3150: WSH_DEBUG_SV.log(l_module_name,'P_ITEM_DISPLAY',P_ITEM_DISPLAY);
3151: WSH_DEBUG_SV.log(l_module_name,'P_PRINT_CUST_ITEM',P_PRINT_CUST_ITEM);
3152: WSH_DEBUG_SV.log(l_module_name,'P_PRINT_MODE',P_PRINT_MODE);
3153: WSH_DEBUG_SV.log(l_module_name,'P_PRINT_ALL',P_PRINT_ALL);
3154: WSH_DEBUG_SV.log(l_module_name,'P_SORT',P_SORT);
3155: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_CARRIER',P_FREIGHT_CARRIER);
3156: WSH_DEBUG_SV.log(l_module_name,'P_WAREHOUSE_ID',P_WAREHOUSE_ID);
3157: END IF;

Line 3154: WSH_DEBUG_SV.log(l_module_name,'P_SORT',P_SORT);

3150: WSH_DEBUG_SV.log(l_module_name,'P_ITEM_DISPLAY',P_ITEM_DISPLAY);
3151: WSH_DEBUG_SV.log(l_module_name,'P_PRINT_CUST_ITEM',P_PRINT_CUST_ITEM);
3152: WSH_DEBUG_SV.log(l_module_name,'P_PRINT_MODE',P_PRINT_MODE);
3153: WSH_DEBUG_SV.log(l_module_name,'P_PRINT_ALL',P_PRINT_ALL);
3154: WSH_DEBUG_SV.log(l_module_name,'P_SORT',P_SORT);
3155: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_CARRIER',P_FREIGHT_CARRIER);
3156: WSH_DEBUG_SV.log(l_module_name,'P_WAREHOUSE_ID',P_WAREHOUSE_ID);
3157: END IF;
3158: --

Line 3155: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_CARRIER',P_FREIGHT_CARRIER);

3151: WSH_DEBUG_SV.log(l_module_name,'P_PRINT_CUST_ITEM',P_PRINT_CUST_ITEM);
3152: WSH_DEBUG_SV.log(l_module_name,'P_PRINT_MODE',P_PRINT_MODE);
3153: WSH_DEBUG_SV.log(l_module_name,'P_PRINT_ALL',P_PRINT_ALL);
3154: WSH_DEBUG_SV.log(l_module_name,'P_SORT',P_SORT);
3155: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_CARRIER',P_FREIGHT_CARRIER);
3156: WSH_DEBUG_SV.log(l_module_name,'P_WAREHOUSE_ID',P_WAREHOUSE_ID);
3157: END IF;
3158: --
3159: IF NOT FND_API.Compatible_API_Call ( l_api_version,

Line 3156: WSH_DEBUG_SV.log(l_module_name,'P_WAREHOUSE_ID',P_WAREHOUSE_ID);

3152: WSH_DEBUG_SV.log(l_module_name,'P_PRINT_MODE',P_PRINT_MODE);
3153: WSH_DEBUG_SV.log(l_module_name,'P_PRINT_ALL',P_PRINT_ALL);
3154: WSH_DEBUG_SV.log(l_module_name,'P_SORT',P_SORT);
3155: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_CARRIER',P_FREIGHT_CARRIER);
3156: WSH_DEBUG_SV.log(l_module_name,'P_WAREHOUSE_ID',P_WAREHOUSE_ID);
3157: END IF;
3158: --
3159: IF NOT FND_API.Compatible_API_Call ( l_api_version,
3160: p_api_version,

Line 3215: WSH_DEBUG_SV.log(l_module_name,'REQUEST ID',x_conc_request_id);

3211: --
3212: -- Debug Statements
3213: --
3214: IF l_debug_on THEN
3215: WSH_DEBUG_SV.log(l_module_name,'REQUEST ID',x_conc_request_id);
3216: WSH_DEBUG_SV.pop(l_module_name);
3217: END IF;
3218: --
3219: EXCEPTION

Line 3216: WSH_DEBUG_SV.pop(l_module_name);

3212: -- Debug Statements
3213: --
3214: IF l_debug_on THEN
3215: WSH_DEBUG_SV.log(l_module_name,'REQUEST ID',x_conc_request_id);
3216: WSH_DEBUG_SV.pop(l_module_name);
3217: END IF;
3218: --
3219: EXCEPTION
3220:

Line 3230: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

3226: --
3227: -- Debug Statements
3228: --
3229: IF l_debug_on THEN
3230: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3231: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3232: END IF;
3233: --
3234: WHEN FND_API.g_exc_unexpected_error THEN

Line 3231: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

3227: -- Debug Statements
3228: --
3229: IF l_debug_on THEN
3230: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3231: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3232: END IF;
3233: --
3234: WHEN FND_API.g_exc_unexpected_error THEN
3235: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

Line 3242: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

3238: --
3239: -- Debug Statements
3240: --
3241: IF l_debug_on THEN
3242: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3243: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3244: END IF;
3245: --
3246: WHEN others THEN

Line 3243: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

3239: -- Debug Statements
3240: --
3241: IF l_debug_on THEN
3242: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3243: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3244: END IF;
3245: --
3246: WHEN others THEN
3247: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');

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

3255: --
3256: -- Debug Statements
3257: --
3258: IF l_debug_on THEN
3259: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3260: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3261: END IF;
3262: --
3263: END Print_Document;

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

3256: -- Debug Statements
3257: --
3258: IF l_debug_on THEN
3259: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3260: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3261: END IF;
3262: --
3263: END Print_Document;
3264:

Line 3346: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

3342: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3343: --
3344: IF l_debug_on IS NULL
3345: THEN
3346: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3347: END IF;
3348: --
3349: IF l_debug_on THEN
3350: WSH_DEBUG_SV.push(l_module_name);

Line 3350: WSH_DEBUG_SV.push(l_module_name);

3346: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3347: END IF;
3348: --
3349: IF l_debug_on THEN
3350: WSH_DEBUG_SV.push(l_module_name);
3351: --
3352: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
3353: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3354: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

Line 3352: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);

3348: --
3349: IF l_debug_on THEN
3350: WSH_DEBUG_SV.push(l_module_name);
3351: --
3352: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
3353: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3354: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
3355: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3356: WSH_DEBUG_SV.log(l_module_name,'P_CUSTOMER_ID',P_CUSTOMER_ID);

Line 3353: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);

3349: IF l_debug_on THEN
3350: WSH_DEBUG_SV.push(l_module_name);
3351: --
3352: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
3353: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3354: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
3355: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3356: WSH_DEBUG_SV.log(l_module_name,'P_CUSTOMER_ID',P_CUSTOMER_ID);
3357: WSH_DEBUG_SV.log(l_module_name,'P_OE_ORDER_LINE_ID',P_OE_ORDER_LINE_ID);

Line 3354: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

3350: WSH_DEBUG_SV.push(l_module_name);
3351: --
3352: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
3353: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3354: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
3355: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3356: WSH_DEBUG_SV.log(l_module_name,'P_CUSTOMER_ID',P_CUSTOMER_ID);
3357: WSH_DEBUG_SV.log(l_module_name,'P_OE_ORDER_LINE_ID',P_OE_ORDER_LINE_ID);
3358: END IF;

Line 3355: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);

3351: --
3352: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
3353: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3354: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
3355: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3356: WSH_DEBUG_SV.log(l_module_name,'P_CUSTOMER_ID',P_CUSTOMER_ID);
3357: WSH_DEBUG_SV.log(l_module_name,'P_OE_ORDER_LINE_ID',P_OE_ORDER_LINE_ID);
3358: END IF;
3359: --

Line 3356: WSH_DEBUG_SV.log(l_module_name,'P_CUSTOMER_ID',P_CUSTOMER_ID);

3352: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
3353: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3354: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
3355: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3356: WSH_DEBUG_SV.log(l_module_name,'P_CUSTOMER_ID',P_CUSTOMER_ID);
3357: WSH_DEBUG_SV.log(l_module_name,'P_OE_ORDER_LINE_ID',P_OE_ORDER_LINE_ID);
3358: END IF;
3359: --
3360: IF NOT FND_API.Compatible_API_Call ( l_api_version,

Line 3357: WSH_DEBUG_SV.log(l_module_name,'P_OE_ORDER_LINE_ID',P_OE_ORDER_LINE_ID);

3353: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3354: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
3355: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3356: WSH_DEBUG_SV.log(l_module_name,'P_CUSTOMER_ID',P_CUSTOMER_ID);
3357: WSH_DEBUG_SV.log(l_module_name,'P_OE_ORDER_LINE_ID',P_OE_ORDER_LINE_ID);
3358: END IF;
3359: --
3360: IF NOT FND_API.Compatible_API_Call ( l_api_version,
3361: p_api_version,

Line 3425: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit RLM_CUM_SV.GETCUMSTARTDATE',WSH_DEBUG_SV.C_PROC_LEVEL);

3421: --
3422: -- Debug Statements
3423: --
3424: IF l_debug_on THEN
3425: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit RLM_CUM_SV.GETCUMSTARTDATE',WSH_DEBUG_SV.C_PROC_LEVEL);
3426: END IF;
3427: --
3428: RLM_CUM_SV.GetCumStartDate(
3429: i_schedule_header_id => l_source_doc_hdr_id,

Line 3457: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit RLM_TPA_SV.CALCULATECUMKEY',WSH_DEBUG_SV.C_PROC_LEVEL);

3453: --
3454: -- Debug Statements
3455: --
3456: IF l_debug_on THEN
3457: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit RLM_TPA_SV.CALCULATECUMKEY',WSH_DEBUG_SV.C_PROC_LEVEL);
3458: END IF;
3459: --
3460: RLM_TPA_SV.CalculateCumKey( x_cum_key_record=>l_cum_key_record
3461: , x_cum_record=>l_cum_record);

Line 3468: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit RLM_TPA_SV.CALCULATESUPPLIERCUM',WSH_DEBUG_SV.C_PROC_LEVEL);

3464: --
3465: -- Debug Statements
3466: --
3467: IF l_debug_on THEN
3468: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit RLM_TPA_SV.CALCULATESUPPLIERCUM',WSH_DEBUG_SV.C_PROC_LEVEL);
3469: END IF;
3470: --
3471: RLM_TPA_SV.CalculateSupplierCum( x_cum_key_record=>l_cum_key_record
3472: , x_cum_record=>l_cum_record);

Line 3480: WSH_DEBUG_SV.log(l_module_name,'L_CUM_QTY',l_cum_qty);

3476: --
3477: -- Debug Statements
3478: --
3479: IF l_debug_on THEN
3480: WSH_DEBUG_SV.log(l_module_name,'L_CUM_QTY',l_cum_qty);
3481: WSH_DEBUG_SV.pop(l_module_name);
3482: END IF;
3483: --
3484: RETURN l_cum_qty;

Line 3481: WSH_DEBUG_SV.pop(l_module_name);

3477: -- Debug Statements
3478: --
3479: IF l_debug_on THEN
3480: WSH_DEBUG_SV.log(l_module_name,'L_CUM_QTY',l_cum_qty);
3481: WSH_DEBUG_SV.pop(l_module_name);
3482: END IF;
3483: --
3484: RETURN l_cum_qty;
3485:

Line 3496: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

3492: --
3493: -- Debug Statements
3494: --
3495: IF l_debug_on THEN
3496: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3497: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3498: END IF;
3499: --
3500: RETURN null;

Line 3497: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

3493: -- Debug Statements
3494: --
3495: IF l_debug_on THEN
3496: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3497: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3498: END IF;
3499: --
3500: RETURN null;
3501:

Line 3510: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

3506: --
3507: -- Debug Statements
3508: --
3509: IF l_debug_on THEN
3510: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3511: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3512: END IF;
3513: --
3514: RETURN null;

Line 3511: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

3507: -- Debug Statements
3508: --
3509: IF l_debug_on THEN
3510: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3511: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3512: END IF;
3513: --
3514: RETURN null;
3515:

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

3523: --
3524: -- Debug Statements
3525: --
3526: IF l_debug_on THEN
3527: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3528: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3529: END IF;
3530: --
3531: RETURN null;

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

3524: -- Debug Statements
3525: --
3526: IF l_debug_on THEN
3527: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3528: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3529: END IF;
3530: --
3531: RETURN null;
3532: END Get_CumQty;

Line 3597: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

3593: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3594: --
3595: IF l_debug_on IS NULL
3596: THEN
3597: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3598: END IF;
3599: --
3600: IF l_debug_on THEN
3601: WSH_DEBUG_SV.push(l_module_name);

Line 3601: WSH_DEBUG_SV.push(l_module_name);

3597: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3598: END IF;
3599: --
3600: IF l_debug_on THEN
3601: WSH_DEBUG_SV.push(l_module_name);
3602: --
3603: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
3604: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3605: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

Line 3603: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);

3599: --
3600: IF l_debug_on THEN
3601: WSH_DEBUG_SV.push(l_module_name);
3602: --
3603: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
3604: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3605: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
3606: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3607: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);

Line 3604: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);

3600: IF l_debug_on THEN
3601: WSH_DEBUG_SV.push(l_module_name);
3602: --
3603: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
3604: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3605: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
3606: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3607: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
3608: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);

Line 3605: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

3601: WSH_DEBUG_SV.push(l_module_name);
3602: --
3603: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
3604: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3605: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
3606: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3607: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
3608: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
3609: END IF;

Line 3606: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);

3602: --
3603: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
3604: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3605: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
3606: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3607: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
3608: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
3609: END IF;
3610: --

Line 3607: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);

3603: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
3604: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3605: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
3606: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3607: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
3608: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
3609: END IF;
3610: --
3611: SAVEPOINT WSH_Document_PVT;

Line 3608: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);

3604: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3605: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
3606: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3607: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
3608: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
3609: END IF;
3610: --
3611: SAVEPOINT WSH_Document_PVT;
3612:

Line 3649: WSH_DEBUG_SV.pop(l_module_name);

3645: --
3646: -- Debug Statements
3647: --
3648: IF l_debug_on THEN
3649: WSH_DEBUG_SV.pop(l_module_name);
3650: END IF;
3651: --
3652: EXCEPTION
3653:

Line 3664: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

3660: --
3661: -- Debug Statements
3662: --
3663: IF l_debug_on THEN
3664: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3665: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3666: END IF;
3667: --
3668: WHEN FND_API.g_exc_unexpected_error THEN

Line 3665: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

3661: -- Debug Statements
3662: --
3663: IF l_debug_on THEN
3664: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3665: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3666: END IF;
3667: --
3668: WHEN FND_API.g_exc_unexpected_error THEN
3669: ROLLBACK to WSH_Document_PVT;

Line 3678: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

3674: --
3675: -- Debug Statements
3676: --
3677: IF l_debug_on THEN
3678: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3679: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3680: END IF;
3681: --
3682: WHEN others THEN

Line 3679: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

3675: -- Debug Statements
3676: --
3677: IF l_debug_on THEN
3678: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3679: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3680: END IF;
3681: --
3682: WHEN others THEN
3683: ROLLBACK to WSH_Document_PVT;

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

3692: --
3693: -- Debug Statements
3694: --
3695: IF l_debug_on THEN
3696: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3697: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3698: END IF;
3699: --
3700: END Cancel_All_Documents;

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

3693: -- Debug Statements
3694: --
3695: IF l_debug_on THEN
3696: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3697: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3698: END IF;
3699: --
3700: END Cancel_All_Documents;
3701:

Line 3804: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

3800: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3801: --
3802: IF l_debug_on IS NULL
3803: THEN
3804: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3805: END IF;
3806: --
3807: IF l_debug_on THEN
3808: WSH_DEBUG_SV.push(l_module_name);

Line 3808: WSH_DEBUG_SV.push(l_module_name);

3804: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3805: END IF;
3806: --
3807: IF l_debug_on THEN
3808: WSH_DEBUG_SV.push(l_module_name);
3809: --
3810: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
3811: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3812: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

Line 3810: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);

3806: --
3807: IF l_debug_on THEN
3808: WSH_DEBUG_SV.push(l_module_name);
3809: --
3810: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
3811: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3812: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
3813: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3814: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);

Line 3811: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);

3807: IF l_debug_on THEN
3808: WSH_DEBUG_SV.push(l_module_name);
3809: --
3810: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
3811: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3812: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
3813: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3814: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
3815: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);

Line 3812: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

3808: WSH_DEBUG_SV.push(l_module_name);
3809: --
3810: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
3811: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3812: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
3813: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3814: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
3815: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
3816: END IF;

Line 3813: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);

3809: --
3810: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
3811: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3812: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
3813: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3814: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
3815: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
3816: END IF;
3817: --

Line 3814: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);

3810: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
3811: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3812: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
3813: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3814: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
3815: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
3816: END IF;
3817: --
3818: IF NOT FND_API.Compatible_API_Call ( l_api_version,

Line 3815: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);

3811: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3812: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
3813: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3814: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
3815: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
3816: END IF;
3817: --
3818: IF NOT FND_API.Compatible_API_Call ( l_api_version,
3819: p_api_version,

Line 3838: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DOCUMENT_PUB.DOCUMENT_TABTYPE',WSH_DEBUG_SV.C_PROC_LEVEL);

3834: --
3835: -- Debug Statements
3836: --
3837: IF l_debug_on THEN
3838: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DOCUMENT_PUB.DOCUMENT_TABTYPE',WSH_DEBUG_SV.C_PROC_LEVEL);
3839: END IF;
3840: --
3841: x_document_tab := wsh_document_pub.document_tabtype();
3842:

Line 3896: WSH_DEBUG_SV.log(l_module_name,'X_DOCUMENT_TAB.COUNT',x_document_tab.count);

3892: --
3893: -- Debug Statements
3894: --
3895: IF l_debug_on THEN
3896: WSH_DEBUG_SV.log(l_module_name,'X_DOCUMENT_TAB.COUNT',x_document_tab.count);
3897: WSH_DEBUG_SV.pop(l_module_name);
3898: END IF;
3899: --
3900: EXCEPTION

Line 3897: WSH_DEBUG_SV.pop(l_module_name);

3893: -- Debug Statements
3894: --
3895: IF l_debug_on THEN
3896: WSH_DEBUG_SV.log(l_module_name,'X_DOCUMENT_TAB.COUNT',x_document_tab.count);
3897: WSH_DEBUG_SV.pop(l_module_name);
3898: END IF;
3899: --
3900: EXCEPTION
3901:

Line 3911: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

3907: --
3908: -- Debug Statements
3909: --
3910: IF l_debug_on THEN
3911: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3912: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3913: END IF;
3914: --
3915: WHEN FND_API.g_exc_unexpected_error THEN

Line 3912: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

3908: -- Debug Statements
3909: --
3910: IF l_debug_on THEN
3911: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3912: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3913: END IF;
3914: --
3915: WHEN FND_API.g_exc_unexpected_error THEN
3916: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

Line 3924: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

3920: --
3921: -- Debug Statements
3922: --
3923: IF l_debug_on THEN
3924: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3925: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3926: END IF;
3927: --
3928: WHEN others THEN

Line 3925: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

3921: -- Debug Statements
3922: --
3923: IF l_debug_on THEN
3924: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3925: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3926: END IF;
3927: --
3928: WHEN others THEN
3929: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');

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

3937: --
3938: -- Debug Statements
3939: --
3940: IF l_debug_on THEN
3941: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3942: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3943: END IF;
3944: --
3945: END Get_All_Documents;

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

3938: -- Debug Statements
3939: --
3940: IF l_debug_on THEN
3941: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3942: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3943: END IF;
3944: --
3945: END Get_All_Documents;
3946:

Line 4136: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

4132: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4133: --
4134: IF l_debug_on IS NULL
4135: THEN
4136: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4137: END IF;
4138: --
4139: IF l_debug_on THEN
4140: WSH_DEBUG_SV.push(l_module_name);

Line 4140: WSH_DEBUG_SV.push(l_module_name);

4136: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4137: END IF;
4138: --
4139: IF l_debug_on THEN
4140: WSH_DEBUG_SV.push(l_module_name);
4141: --
4142: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
4143: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_INSTANCE_ID',P_DOCUMENT_INSTANCE_ID);
4144: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);

Line 4142: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);

4138: --
4139: IF l_debug_on THEN
4140: WSH_DEBUG_SV.push(l_module_name);
4141: --
4142: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
4143: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_INSTANCE_ID',P_DOCUMENT_INSTANCE_ID);
4144: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
4145: WSH_DEBUG_SV.log(l_module_name,'P_SEQUENCE_NUMBER',P_SEQUENCE_NUMBER);
4146: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);

Line 4143: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_INSTANCE_ID',P_DOCUMENT_INSTANCE_ID);

4139: IF l_debug_on THEN
4140: WSH_DEBUG_SV.push(l_module_name);
4141: --
4142: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
4143: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_INSTANCE_ID',P_DOCUMENT_INSTANCE_ID);
4144: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
4145: WSH_DEBUG_SV.log(l_module_name,'P_SEQUENCE_NUMBER',P_SEQUENCE_NUMBER);
4146: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
4147: WSH_DEBUG_SV.log(l_module_name,'P_FINAL_PRINT_DATE',P_FINAL_PRINT_DATE);

Line 4144: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);

4140: WSH_DEBUG_SV.push(l_module_name);
4141: --
4142: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
4143: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_INSTANCE_ID',P_DOCUMENT_INSTANCE_ID);
4144: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
4145: WSH_DEBUG_SV.log(l_module_name,'P_SEQUENCE_NUMBER',P_SEQUENCE_NUMBER);
4146: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
4147: WSH_DEBUG_SV.log(l_module_name,'P_FINAL_PRINT_DATE',P_FINAL_PRINT_DATE);
4148: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);

Line 4145: WSH_DEBUG_SV.log(l_module_name,'P_SEQUENCE_NUMBER',P_SEQUENCE_NUMBER);

4141: --
4142: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
4143: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_INSTANCE_ID',P_DOCUMENT_INSTANCE_ID);
4144: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
4145: WSH_DEBUG_SV.log(l_module_name,'P_SEQUENCE_NUMBER',P_SEQUENCE_NUMBER);
4146: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
4147: WSH_DEBUG_SV.log(l_module_name,'P_FINAL_PRINT_DATE',P_FINAL_PRINT_DATE);
4148: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
4149: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);

Line 4146: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);

4142: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
4143: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_INSTANCE_ID',P_DOCUMENT_INSTANCE_ID);
4144: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
4145: WSH_DEBUG_SV.log(l_module_name,'P_SEQUENCE_NUMBER',P_SEQUENCE_NUMBER);
4146: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
4147: WSH_DEBUG_SV.log(l_module_name,'P_FINAL_PRINT_DATE',P_FINAL_PRINT_DATE);
4148: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
4149: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
4150: WSH_DEBUG_SV.log(l_module_name,'P_DOC_SEQUENCE_CATEGORY_ID',P_DOC_SEQUENCE_CATEGORY_ID);

Line 4147: WSH_DEBUG_SV.log(l_module_name,'P_FINAL_PRINT_DATE',P_FINAL_PRINT_DATE);

4143: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_INSTANCE_ID',P_DOCUMENT_INSTANCE_ID);
4144: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
4145: WSH_DEBUG_SV.log(l_module_name,'P_SEQUENCE_NUMBER',P_SEQUENCE_NUMBER);
4146: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
4147: WSH_DEBUG_SV.log(l_module_name,'P_FINAL_PRINT_DATE',P_FINAL_PRINT_DATE);
4148: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
4149: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
4150: WSH_DEBUG_SV.log(l_module_name,'P_DOC_SEQUENCE_CATEGORY_ID',P_DOC_SEQUENCE_CATEGORY_ID);
4151: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);

Line 4148: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);

4144: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
4145: WSH_DEBUG_SV.log(l_module_name,'P_SEQUENCE_NUMBER',P_SEQUENCE_NUMBER);
4146: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
4147: WSH_DEBUG_SV.log(l_module_name,'P_FINAL_PRINT_DATE',P_FINAL_PRINT_DATE);
4148: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
4149: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
4150: WSH_DEBUG_SV.log(l_module_name,'P_DOC_SEQUENCE_CATEGORY_ID',P_DOC_SEQUENCE_CATEGORY_ID);
4151: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
4152: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);

Line 4149: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);

4145: WSH_DEBUG_SV.log(l_module_name,'P_SEQUENCE_NUMBER',P_SEQUENCE_NUMBER);
4146: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
4147: WSH_DEBUG_SV.log(l_module_name,'P_FINAL_PRINT_DATE',P_FINAL_PRINT_DATE);
4148: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
4149: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
4150: WSH_DEBUG_SV.log(l_module_name,'P_DOC_SEQUENCE_CATEGORY_ID',P_DOC_SEQUENCE_CATEGORY_ID);
4151: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
4152: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
4153: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);

Line 4150: WSH_DEBUG_SV.log(l_module_name,'P_DOC_SEQUENCE_CATEGORY_ID',P_DOC_SEQUENCE_CATEGORY_ID);

4146: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
4147: WSH_DEBUG_SV.log(l_module_name,'P_FINAL_PRINT_DATE',P_FINAL_PRINT_DATE);
4148: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
4149: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
4150: WSH_DEBUG_SV.log(l_module_name,'P_DOC_SEQUENCE_CATEGORY_ID',P_DOC_SEQUENCE_CATEGORY_ID);
4151: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
4152: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
4153: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
4154: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);

Line 4151: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);

4147: WSH_DEBUG_SV.log(l_module_name,'P_FINAL_PRINT_DATE',P_FINAL_PRINT_DATE);
4148: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
4149: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
4150: WSH_DEBUG_SV.log(l_module_name,'P_DOC_SEQUENCE_CATEGORY_ID',P_DOC_SEQUENCE_CATEGORY_ID);
4151: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
4152: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
4153: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
4154: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
4155: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);

Line 4152: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);

4148: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
4149: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
4150: WSH_DEBUG_SV.log(l_module_name,'P_DOC_SEQUENCE_CATEGORY_ID',P_DOC_SEQUENCE_CATEGORY_ID);
4151: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
4152: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
4153: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
4154: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
4155: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
4156: WSH_DEBUG_SV.log(l_module_name,'P_PROGRAM_APPLICATION_ID',P_PROGRAM_APPLICATION_ID);

Line 4153: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);

4149: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
4150: WSH_DEBUG_SV.log(l_module_name,'P_DOC_SEQUENCE_CATEGORY_ID',P_DOC_SEQUENCE_CATEGORY_ID);
4151: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
4152: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
4153: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
4154: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
4155: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
4156: WSH_DEBUG_SV.log(l_module_name,'P_PROGRAM_APPLICATION_ID',P_PROGRAM_APPLICATION_ID);
4157: WSH_DEBUG_SV.log(l_module_name,'P_PROGRAM_ID',P_PROGRAM_ID);

Line 4154: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);

4150: WSH_DEBUG_SV.log(l_module_name,'P_DOC_SEQUENCE_CATEGORY_ID',P_DOC_SEQUENCE_CATEGORY_ID);
4151: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
4152: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
4153: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
4154: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
4155: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
4156: WSH_DEBUG_SV.log(l_module_name,'P_PROGRAM_APPLICATION_ID',P_PROGRAM_APPLICATION_ID);
4157: WSH_DEBUG_SV.log(l_module_name,'P_PROGRAM_ID',P_PROGRAM_ID);
4158: WSH_DEBUG_SV.log(l_module_name,'P_PROGRAM_UPDATE_DATE',P_PROGRAM_UPDATE_DATE);

Line 4155: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);

4151: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
4152: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
4153: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
4154: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
4155: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
4156: WSH_DEBUG_SV.log(l_module_name,'P_PROGRAM_APPLICATION_ID',P_PROGRAM_APPLICATION_ID);
4157: WSH_DEBUG_SV.log(l_module_name,'P_PROGRAM_ID',P_PROGRAM_ID);
4158: WSH_DEBUG_SV.log(l_module_name,'P_PROGRAM_UPDATE_DATE',P_PROGRAM_UPDATE_DATE);
4159: WSH_DEBUG_SV.log(l_module_name,'P_REQUEST_ID',P_REQUEST_ID);

Line 4156: WSH_DEBUG_SV.log(l_module_name,'P_PROGRAM_APPLICATION_ID',P_PROGRAM_APPLICATION_ID);

4152: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
4153: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
4154: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
4155: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
4156: WSH_DEBUG_SV.log(l_module_name,'P_PROGRAM_APPLICATION_ID',P_PROGRAM_APPLICATION_ID);
4157: WSH_DEBUG_SV.log(l_module_name,'P_PROGRAM_ID',P_PROGRAM_ID);
4158: WSH_DEBUG_SV.log(l_module_name,'P_PROGRAM_UPDATE_DATE',P_PROGRAM_UPDATE_DATE);
4159: WSH_DEBUG_SV.log(l_module_name,'P_REQUEST_ID',P_REQUEST_ID);
4160: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);

Line 4157: WSH_DEBUG_SV.log(l_module_name,'P_PROGRAM_ID',P_PROGRAM_ID);

4153: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
4154: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
4155: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
4156: WSH_DEBUG_SV.log(l_module_name,'P_PROGRAM_APPLICATION_ID',P_PROGRAM_APPLICATION_ID);
4157: WSH_DEBUG_SV.log(l_module_name,'P_PROGRAM_ID',P_PROGRAM_ID);
4158: WSH_DEBUG_SV.log(l_module_name,'P_PROGRAM_UPDATE_DATE',P_PROGRAM_UPDATE_DATE);
4159: WSH_DEBUG_SV.log(l_module_name,'P_REQUEST_ID',P_REQUEST_ID);
4160: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
4161: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);

Line 4158: WSH_DEBUG_SV.log(l_module_name,'P_PROGRAM_UPDATE_DATE',P_PROGRAM_UPDATE_DATE);

4154: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
4155: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
4156: WSH_DEBUG_SV.log(l_module_name,'P_PROGRAM_APPLICATION_ID',P_PROGRAM_APPLICATION_ID);
4157: WSH_DEBUG_SV.log(l_module_name,'P_PROGRAM_ID',P_PROGRAM_ID);
4158: WSH_DEBUG_SV.log(l_module_name,'P_PROGRAM_UPDATE_DATE',P_PROGRAM_UPDATE_DATE);
4159: WSH_DEBUG_SV.log(l_module_name,'P_REQUEST_ID',P_REQUEST_ID);
4160: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
4161: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
4162: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);

Line 4159: WSH_DEBUG_SV.log(l_module_name,'P_REQUEST_ID',P_REQUEST_ID);

4155: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
4156: WSH_DEBUG_SV.log(l_module_name,'P_PROGRAM_APPLICATION_ID',P_PROGRAM_APPLICATION_ID);
4157: WSH_DEBUG_SV.log(l_module_name,'P_PROGRAM_ID',P_PROGRAM_ID);
4158: WSH_DEBUG_SV.log(l_module_name,'P_PROGRAM_UPDATE_DATE',P_PROGRAM_UPDATE_DATE);
4159: WSH_DEBUG_SV.log(l_module_name,'P_REQUEST_ID',P_REQUEST_ID);
4160: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
4161: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
4162: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
4163: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);

Line 4160: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);

4156: WSH_DEBUG_SV.log(l_module_name,'P_PROGRAM_APPLICATION_ID',P_PROGRAM_APPLICATION_ID);
4157: WSH_DEBUG_SV.log(l_module_name,'P_PROGRAM_ID',P_PROGRAM_ID);
4158: WSH_DEBUG_SV.log(l_module_name,'P_PROGRAM_UPDATE_DATE',P_PROGRAM_UPDATE_DATE);
4159: WSH_DEBUG_SV.log(l_module_name,'P_REQUEST_ID',P_REQUEST_ID);
4160: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
4161: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
4162: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
4163: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
4164: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);

Line 4161: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);

4157: WSH_DEBUG_SV.log(l_module_name,'P_PROGRAM_ID',P_PROGRAM_ID);
4158: WSH_DEBUG_SV.log(l_module_name,'P_PROGRAM_UPDATE_DATE',P_PROGRAM_UPDATE_DATE);
4159: WSH_DEBUG_SV.log(l_module_name,'P_REQUEST_ID',P_REQUEST_ID);
4160: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
4161: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
4162: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
4163: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
4164: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
4165: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);

Line 4162: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);

4158: WSH_DEBUG_SV.log(l_module_name,'P_PROGRAM_UPDATE_DATE',P_PROGRAM_UPDATE_DATE);
4159: WSH_DEBUG_SV.log(l_module_name,'P_REQUEST_ID',P_REQUEST_ID);
4160: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
4161: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
4162: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
4163: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
4164: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
4165: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
4166: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);

Line 4163: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);

4159: WSH_DEBUG_SV.log(l_module_name,'P_REQUEST_ID',P_REQUEST_ID);
4160: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
4161: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
4162: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
4163: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
4164: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
4165: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
4166: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
4167: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);

Line 4164: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);

4160: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
4161: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
4162: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
4163: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
4164: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
4165: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
4166: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
4167: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
4168: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);

Line 4165: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);

4161: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
4162: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
4163: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
4164: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
4165: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
4166: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
4167: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
4168: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
4169: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);

Line 4166: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);

4162: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
4163: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
4164: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
4165: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
4166: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
4167: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
4168: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
4169: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
4170: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);

Line 4167: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);

4163: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
4164: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
4165: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
4166: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
4167: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
4168: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
4169: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
4170: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
4171: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);

Line 4168: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);

4164: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
4165: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
4166: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
4167: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
4168: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
4169: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
4170: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
4171: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
4172: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);

Line 4169: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);

4165: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
4166: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
4167: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
4168: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
4169: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
4170: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
4171: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
4172: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
4173: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);

Line 4170: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);

4166: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
4167: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
4168: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
4169: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
4170: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
4171: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
4172: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
4173: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
4174: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);

Line 4171: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);

4167: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
4168: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
4169: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
4170: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
4171: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
4172: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
4173: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
4174: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
4175: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);

Line 4172: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);

4168: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
4169: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
4170: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
4171: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
4172: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
4173: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
4174: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
4175: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
4176: END IF;

Line 4173: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);

4169: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
4170: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
4171: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
4172: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
4173: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
4174: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
4175: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
4176: END IF;
4177: --

Line 4174: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);

4170: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
4171: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
4172: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
4173: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
4174: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
4175: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
4176: END IF;
4177: --
4178: OPEN lock_csr;

Line 4175: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);

4171: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
4172: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
4173: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
4174: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
4175: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
4176: END IF;
4177: --
4178: OPEN lock_csr;
4179: FETCH lock_csr INTO lock_rec;

Line 4280: WSH_DEBUG_SV.pop(l_module_name);

4276: --
4277: -- Debug Statements
4278: --
4279: IF l_debug_on THEN
4280: WSH_DEBUG_SV.pop(l_module_name);
4281: END IF;
4282: --
4283: return;
4284: ELSE

Line 4293: WSH_DEBUG_SV.pop(l_module_name);

4289: --
4290: -- Debug Statements
4291: --
4292: IF l_debug_on THEN
4293: WSH_DEBUG_SV.pop(l_module_name);
4294: END IF;
4295: --
4296: END Lock_Document;
4297:

Line 4354: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

4350: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4351: --
4352: IF l_debug_on IS NULL
4353: THEN
4354: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4355: END IF;
4356: --
4357: IF l_debug_on THEN
4358: WSH_DEBUG_SV.push(l_module_name);

Line 4358: WSH_DEBUG_SV.push(l_module_name);

4354: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4355: END IF;
4356: --
4357: IF l_debug_on THEN
4358: WSH_DEBUG_SV.push(l_module_name);
4359: --
4360: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
4361: WSH_DEBUG_SV.log(l_module_name,'P_REPORT',P_REPORT);
4362: END IF;

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

4356: --
4357: IF l_debug_on THEN
4358: WSH_DEBUG_SV.push(l_module_name);
4359: --
4360: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
4361: WSH_DEBUG_SV.log(l_module_name,'P_REPORT',P_REPORT);
4362: END IF;
4363: --
4364: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 4361: WSH_DEBUG_SV.log(l_module_name,'P_REPORT',P_REPORT);

4357: IF l_debug_on THEN
4358: WSH_DEBUG_SV.push(l_module_name);
4359: --
4360: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
4361: WSH_DEBUG_SV.log(l_module_name,'P_REPORT',P_REPORT);
4362: END IF;
4363: --
4364: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4365:

Line 4371: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get',WSH_DEBUG_SV.C_PROC_LEVEL);

4367: l_param_value_info.class_code(1) := 'XDO_TEMPLATE';
4368: l_param_value_info.param_name(1) := p_template_name;
4369:
4370: IF l_debug_on THEN
4371: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get',WSH_DEBUG_SV.C_PROC_LEVEL);
4372: END IF;
4373:
4374: wsh_shipping_params_pvt.get(l_param_value_info,l_return_status);
4375: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR))

Line 4378: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_SHIPPING_PARAMS_PVT.Get returned '||l_return_status);

4374: wsh_shipping_params_pvt.get(l_param_value_info,l_return_status);
4375: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR))
4376: THEN
4377: IF l_debug_on THEN
4378: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_SHIPPING_PARAMS_PVT.Get returned '||l_return_status);
4379: END IF;
4380: RAISE get_shipping_param_err;
4381: END IF;
4382: --

Line 4384: WSH_DEBUG_SV.logmsg(l_module_name,'param_name.count '||l_param_value_info.param_name.COUNT);

4380: RAISE get_shipping_param_err;
4381: END IF;
4382: --
4383: IF l_debug_on THEN
4384: WSH_DEBUG_SV.logmsg(l_module_name,'param_name.count '||l_param_value_info.param_name.COUNT);
4385: WSH_DEBUG_SV.logmsg(l_module_name,'param_name_chr.count '||l_param_value_info.param_value_chr.COUNT);
4386: END IF;
4387: --
4388: IF (l_param_value_info.param_value_chr.COUNT >0 and l_param_value_info.param_name.COUNT >0) THEN

Line 4385: WSH_DEBUG_SV.logmsg(l_module_name,'param_name_chr.count '||l_param_value_info.param_value_chr.COUNT);

4381: END IF;
4382: --
4383: IF l_debug_on THEN
4384: WSH_DEBUG_SV.logmsg(l_module_name,'param_name.count '||l_param_value_info.param_name.COUNT);
4385: WSH_DEBUG_SV.logmsg(l_module_name,'param_name_chr.count '||l_param_value_info.param_value_chr.COUNT);
4386: END IF;
4387: --
4388: IF (l_param_value_info.param_value_chr.COUNT >0 and l_param_value_info.param_name.COUNT >0) THEN
4389: IF (l_param_value_info.param_name(1) = p_template_name) THEN

Line 4394: WSH_DEBUG_SV.logmsg(l_module_name,'No Parameters returned from WSH_SHIPPING_PARAMS_PVT.Get ');

4390: l_report_template := l_param_value_info.param_value_chr(1);
4391: END IF;
4392: ELSE
4393: IF l_debug_on THEN
4394: WSH_DEBUG_SV.logmsg(l_module_name,'No Parameters returned from WSH_SHIPPING_PARAMS_PVT.Get ');
4395: END IF;
4396: RAISE get_shipping_param_err;
4397: END IF;
4398:

Line 4400: wsh_debug_sv.log(l_module_name, 'Report Template from Shipping Parameters ',l_report_template);

4396: RAISE get_shipping_param_err;
4397: END IF;
4398:
4399: IF l_debug_on THEN
4400: wsh_debug_sv.log(l_module_name, 'Report Template from Shipping Parameters ',l_report_template);
4401: END IF;
4402:
4403: IF (l_report_template IS NULL ) THEN
4404: l_conc_prog_name := 'WSHRD' || p_report;

Line 4413: wsh_debug_sv.log(l_module_name, 'language ', l_language);

4409: FROM FND_LANGUAGES
4410: WHERE LANGUAGE_CODE = userenv('LANG');
4411:
4412: IF l_debug_on THEN
4413: wsh_debug_sv.log(l_module_name, 'language ', l_language);
4414: wsh_debug_sv.log(l_module_name, 'territory ', l_territory);
4415: END IF;
4416:
4417: l_status := fnd_request.add_layout

Line 4414: wsh_debug_sv.log(l_module_name, 'territory ', l_territory);

4410: WHERE LANGUAGE_CODE = userenv('LANG');
4411:
4412: IF l_debug_on THEN
4413: wsh_debug_sv.log(l_module_name, 'language ', l_language);
4414: wsh_debug_sv.log(l_module_name, 'territory ', l_territory);
4415: END IF;
4416:
4417: l_status := fnd_request.add_layout
4418: ('WSH',

Line 4424: wsh_debug_sv.log(l_module_name,'Return Status After Calling fnd_request.add_layout ',l_status);

4420: l_language,
4421: l_territory,
4422: 'PDF');
4423: IF l_debug_on THEN
4424: wsh_debug_sv.log(l_module_name,'Return Status After Calling fnd_request.add_layout ',l_status);
4425: END IF;
4426: IF (l_status=FALSE) THEN
4427: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4428: wsh_util_core.add_message(x_return_status,l_module_name);

Line 4435: WSH_DEBUG_SV.pop(l_module_name);

4431: END IF;
4432: x_conc_prog_name := l_conc_prog_name;
4433:
4434: IF l_debug_on THEN
4435: WSH_DEBUG_SV.pop(l_module_name);
4436: END IF;
4437:
4438: EXCEPTION
4439: WHEN get_shipping_param_err THEN

Line 4448: WSH_DEBUG_SV.logmsg(l_module_name,'Failed to get Shipping Parameters',WSH_DEBUG_SV.C_EXCEP_LEVEL);

4444: wsh_util_core.add_message(x_return_status,l_module_name);
4445:
4446: --
4447: IF l_debug_on THEN
4448: WSH_DEBUG_SV.logmsg(l_module_name,'Failed to get Shipping Parameters',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4449: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:GET_SHIPPING_PARAM_ERR');
4450: END IF;
4451:
4452: WHEN OTHERS THEN

Line 4449: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:GET_SHIPPING_PARAM_ERR');

4445:
4446: --
4447: IF l_debug_on THEN
4448: WSH_DEBUG_SV.logmsg(l_module_name,'Failed to get Shipping Parameters',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4449: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:GET_SHIPPING_PARAM_ERR');
4450: END IF;
4451:
4452: WHEN OTHERS THEN
4453:

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

4454: wsh_util_core.default_handler('WSH_DOCUMENT_PVT.set_template',l_module_name);
4455: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
4456: --
4457: IF l_debug_on THEN
4458: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4459: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4460: END IF;
4461: End set_template;
4462:

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

4455: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
4456: --
4457: IF l_debug_on THEN
4458: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4459: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4460: END IF;
4461: End set_template;
4462:
4463: