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 1128: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 1132: WSH_DEBUG_SV.push(l_module_name);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1307: WSH_DEBUG_SV.pop(l_module_name);

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

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

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

Line 1534: WSH_DEBUG_SV.pop(l_module_name);

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

Line 1674: WSH_DEBUG_SV.pop(l_module_name);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1907: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 1911: WSH_DEBUG_SV.push(l_module_name);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2064: WSH_DEBUG_SV.pop(l_module_name);

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2230: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 2234: WSH_DEBUG_SV.push(l_module_name);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2392: WSH_DEBUG_SV.pop(l_module_name);

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2549: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 2553: WSH_DEBUG_SV.push(l_module_name);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2695: WSH_DEBUG_SV.pop(l_module_name);

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2853: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 2857: WSH_DEBUG_SV.push(l_module_name);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2999: WSH_DEBUG_SV.pop(l_module_name);

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3135: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 3139: WSH_DEBUG_SV.push(l_module_name);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3215: WSH_DEBUG_SV.pop(l_module_name);

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3345: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 3349: WSH_DEBUG_SV.push(l_module_name);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3480: WSH_DEBUG_SV.pop(l_module_name);

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3596: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 3600: WSH_DEBUG_SV.push(l_module_name);

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3648: WSH_DEBUG_SV.pop(l_module_name);

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3803: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 3807: WSH_DEBUG_SV.push(l_module_name);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3896: WSH_DEBUG_SV.pop(l_module_name);

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 4135: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 4139: WSH_DEBUG_SV.push(l_module_name);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 4279: WSH_DEBUG_SV.pop(l_module_name);

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

Line 4292: WSH_DEBUG_SV.pop(l_module_name);

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

Line 4353: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 4357: WSH_DEBUG_SV.push(l_module_name);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 4434: WSH_DEBUG_SV.pop(l_module_name);

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

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

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

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

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

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

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

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

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