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_PO_CMG_PVT dependencies on WSH_UTIL_CORE

Line 64: l_dd_id_unassigned wsh_util_core.id_tab_type;

60:
61: l_return_status VARCHAR2(10);
62: l_num_warnings NUMBER := 0;
63: l_num_errors NUMBER := 0;
64: l_dd_id_unassigned wsh_util_core.id_tab_type;
65: l_wt_vol_dd_id wsh_util_core.id_tab_type;
66: l_init_msg_list VARCHAR2(30) := NULL;
67: l_msg_count NUMBER;
68: l_msg_data VARCHAR2(3000);

Line 65: l_wt_vol_dd_id wsh_util_core.id_tab_type;

61: l_return_status VARCHAR2(10);
62: l_num_warnings NUMBER := 0;
63: l_num_errors NUMBER := 0;
64: l_dd_id_unassigned wsh_util_core.id_tab_type;
65: l_wt_vol_dd_id wsh_util_core.id_tab_type;
66: l_init_msg_list VARCHAR2(30) := NULL;
67: l_msg_count NUMBER;
68: l_msg_data VARCHAR2(3000);
69: l_commit VARCHAR2(1);

Line 99: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

95: END IF;
96: --
97: SAVEPOINT Reapprove_PO_PVT;
98:
99: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
100:
101: IF p_action_prms.action_code = 'REAPPROVE_PO' OR
102: p_action_prms.action_code = 'CANCEL_ASN' THEN
103:

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

120: --
121: -- Debug Statements
122: --
123: IF l_debug_on THEN
124: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
125: END IF;
126: --
127: wsh_util_core.api_post_call(
128: p_return_status => l_return_status,

Line 127: wsh_util_core.api_post_call(

123: IF l_debug_on THEN
124: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
125: END IF;
126: --
127: wsh_util_core.api_post_call(
128: p_return_status => l_return_status,
129: x_num_warnings => l_num_warnings,
130: x_num_errors => l_num_errors);
131:

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

159: --
160: -- Debug Statements
161: --
162: IF l_debug_on THEN
163: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
164: END IF;
165: --
166: wsh_util_core.api_post_call(
167: p_return_status => l_return_status,

Line 166: wsh_util_core.api_post_call(

162: IF l_debug_on THEN
163: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
164: END IF;
165: --
166: wsh_util_core.api_post_call(
167: p_return_status => l_return_status,
168: x_num_warnings => l_num_warnings,
169: x_num_errors => l_num_errors);
170: END IF;

Line 181: l_action_prms.caller := wsh_util_core.C_IB_PO_PREFIX;

177: IF l_debug_on THEN
178: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_MULTIPLE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
179: END IF;
180:
181: l_action_prms.caller := wsh_util_core.C_IB_PO_PREFIX;
182:
183: WSH_DELIVERY_DETAILS_ACTIONS.unassign_multiple_details(
184: p_rec_of_detail_ids => l_dd_id_unassigned,
185: p_from_delivery => 'Y',

Line 191: wsh_util_core.api_post_call(

187: x_return_status => l_return_status,
188: p_validate_flag => 'N',
189: p_action_prms => l_action_prms);
190:
191: wsh_util_core.api_post_call(
192: p_return_status => l_return_status,
193: x_num_warnings => l_num_warnings,
194: x_num_errors => l_num_errors);
195:

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

214: p_calc_wv_if_frozen => 'N',
215: x_return_status => l_return_status);
216:
217: IF l_debug_on THEN
218: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
219: END IF;
220: --
221: wsh_util_core.api_post_call(
222: p_return_status => l_return_status,

Line 221: wsh_util_core.api_post_call(

217: IF l_debug_on THEN
218: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
219: END IF;
220: --
221: wsh_util_core.api_post_call(
222: p_return_status => l_return_status,
223: x_num_warnings => l_num_warnings,
224: x_num_errors => l_num_errors);
225:

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

235: --
236: -- Debug Statements
237: --
238: IF l_debug_on THEN
239: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
240: END IF;
241: --
242: wsh_util_core.api_post_call(
243: p_return_status => l_return_status,

Line 242: wsh_util_core.api_post_call(

238: IF l_debug_on THEN
239: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
240: END IF;
241: --
242: wsh_util_core.api_post_call(
243: p_return_status => l_return_status,
244: x_num_warnings => l_num_warnings,
245: x_num_errors => l_num_errors);
246: --END IF;

Line 261: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

257: WSH_DEBUG_SV.pop(l_module_name);
258: END IF;
259: --
260: IF l_num_errors > 0 THEN
261: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
262: ELSIF l_num_warnings > 0 THEN
263: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
264: END IF;
265:

Line 263: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

259: --
260: IF l_num_errors > 0 THEN
261: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
262: ELSIF l_num_warnings > 0 THEN
263: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
264: END IF;
265:
266:
267: EXCEPTION

Line 270: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

266:
267: EXCEPTION
268: WHEN FND_API.G_EXC_ERROR THEN
269: ROLLBACK TO Reapprove_PO_PVT;
270: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
271: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
272:
273: --
274: -- Debug Statements

Line 271: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);

267: EXCEPTION
268: WHEN FND_API.G_EXC_ERROR THEN
269: ROLLBACK TO Reapprove_PO_PVT;
270: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
271: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
272:
273: --
274: -- Debug Statements
275: --

Line 283: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

279: END IF;
280: --
281: WHEN OTHERS THEN
282: ROLLBACK TO Reapprove_PO_PVT;
283: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
284: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_CMG_PVT.Reapprove_PO',l_module_name);
285:
286: --
287: -- Debug Statements

Line 284: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_CMG_PVT.Reapprove_PO',l_module_name);

280: --
281: WHEN OTHERS THEN
282: ROLLBACK TO Reapprove_PO_PVT;
283: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
284: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_CMG_PVT.Reapprove_PO',l_module_name);
285:
286: --
287: -- Debug Statements
288: --

Line 320: -- p_dd_id_unassigned IN OUT NOCOPY wsh_util_core.id_tab_type

316: -- p_line_rec IN OE_WSH_BULK_GRP.line_rec_type DEFAULT NULL
317: -- This record structure contains information about the lines to be updated.
318: -- The information may include header id,line id ,line location id and other po
319: -- attributes..
320: -- p_dd_id_unassigned IN OUT NOCOPY wsh_util_core.id_tab_type
321: -- This contains the list of delviery details that needs to be unassigned from
322: -- the respective delivery.
323: -- p_wt_vol_dd_id IN OUT NOCOPY wsh_util_core.id_tab_type,
324: -- This contains the list of delviery details for which weight and volume needs to

Line 323: -- p_wt_vol_dd_id IN OUT NOCOPY wsh_util_core.id_tab_type,

319: -- attributes..
320: -- p_dd_id_unassigned IN OUT NOCOPY wsh_util_core.id_tab_type
321: -- This contains the list of delviery details that needs to be unassigned from
322: -- the respective delivery.
323: -- p_wt_vol_dd_id IN OUT NOCOPY wsh_util_core.id_tab_type,
324: -- This contains the list of delviery details for which weight and volume needs to
325: -- be re-calculated.
326: -- p_action_prms IN OUT NOCOPY WSH_BULK_TYPES_GRP.action_parameters_rectype
327: -- The record which specifies the caller, actio to be performed(REAPPROVE,CANCEL_ASN,RECEIPT,ASN)

Line 344: p_dd_id_unassigned IN OUT NOCOPY wsh_util_core.id_tab_type,

340: Procedure Update_Attributes(
341: p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.line_rec_type,
342: p_action_prms IN WSH_BULK_TYPES_GRP.action_parameters_rectype,
343: p_dd_list IN dd_list_type,
344: p_dd_id_unassigned IN OUT NOCOPY wsh_util_core.id_tab_type,
345: p_wt_vol_dd_id IN OUT NOCOPY wsh_util_core.id_tab_type,
346: x_return_status OUT NOCOPY VARCHAR2) IS
347:
348: l_api_version CONSTANT NUMBER := 1.0;

Line 345: p_wt_vol_dd_id IN OUT NOCOPY wsh_util_core.id_tab_type,

341: p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.line_rec_type,
342: p_action_prms IN WSH_BULK_TYPES_GRP.action_parameters_rectype,
343: p_dd_list IN dd_list_type,
344: p_dd_id_unassigned IN OUT NOCOPY wsh_util_core.id_tab_type,
345: p_wt_vol_dd_id IN OUT NOCOPY wsh_util_core.id_tab_type,
346: x_return_status OUT NOCOPY VARCHAR2) IS
347:
348: l_api_version CONSTANT NUMBER := 1.0;
349: l_msg_count NUMBER := 0;

Line 386: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

382: END IF;
383: --
384: SAVEPOINT Update_Attributes_PVT;
385:
386: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
387:
388: IF p_dd_list.delivery_detail_id.count = 0 THEN
389: -- If this routine is being called from the PO Reapproval Case
390: -- the p_dd_list is null.Only p_line_rec will be populated.

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

407: --
408: -- Debug Statements
409: --
410: IF l_debug_on THEN
411: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
412: END IF;
413: --
414: wsh_util_core.api_post_call(
415: p_return_status => l_return_status,

Line 414: wsh_util_core.api_post_call(

410: IF l_debug_on THEN
411: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
412: END IF;
413: --
414: wsh_util_core.api_post_call(
415: p_return_status => l_return_status,
416: x_num_warnings => l_num_warnings,
417: x_num_errors => l_num_errors);
418:

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

446: --
447: -- Debug Statements
448: --
449: IF l_debug_on THEN
450: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
451: END IF;
452: --
453: wsh_util_core.api_post_call(
454: p_return_status => l_return_status,

Line 453: wsh_util_core.api_post_call(

449: IF l_debug_on THEN
450: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
451: END IF;
452: --
453: wsh_util_core.api_post_call(
454: p_return_status => l_return_status,
455: x_num_warnings => l_num_warnings,
456: x_num_errors => l_num_errors);
457:

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

477: --
478: -- Debug Statements
479: --
480: IF l_debug_on THEN
481: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
482: END IF;
483: --
484: wsh_util_core.api_post_call(
485: p_return_status => l_return_status,

Line 484: wsh_util_core.api_post_call(

480: IF l_debug_on THEN
481: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
482: END IF;
483: --
484: wsh_util_core.api_post_call(
485: p_return_status => l_return_status,
486: x_num_warnings => l_num_warnings,
487: x_num_errors => l_num_errors);
488:

Line 501: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

497: WSH_DEBUG_SV.pop(l_module_name);
498: END IF;
499: --
500: IF l_num_errors > 0 THEN
501: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
502: ELSIF l_num_warnings > 0 THEN
503: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
504: END IF;
505:

Line 503: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

499: --
500: IF l_num_errors > 0 THEN
501: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
502: ELSIF l_num_warnings > 0 THEN
503: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
504: END IF;
505:
506:
507: EXCEPTION

Line 510: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

506:
507: EXCEPTION
508: WHEN FND_API.G_EXC_ERROR THEN
509: ROLLBACK TO Update_Attributes_PVT;
510: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
511: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
512:
513: --
514: -- Debug Statements

Line 511: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);

507: EXCEPTION
508: WHEN FND_API.G_EXC_ERROR THEN
509: ROLLBACK TO Update_Attributes_PVT;
510: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
511: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
512:
513: --
514: -- Debug Statements
515: --

Line 523: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

519: END IF;
520: --
521: WHEN OTHERS THEN
522: ROLLBACK TO Update_Attributes_PVT;
523: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
524: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_CMG_PVT.Update_Attributes',l_module_name);
525:
526: --
527: -- Debug Statements

Line 524: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_CMG_PVT.Update_Attributes',l_module_name);

520: --
521: WHEN OTHERS THEN
522: ROLLBACK TO Update_Attributes_PVT;
523: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
524: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_CMG_PVT.Update_Attributes',l_module_name);
525:
526: --
527: -- Debug Statements
528: --

Line 589: -- p_dd_id_unassigned IN OUT NOCOPY wsh_util_core.id_tab_type

585: -- p_line_rec IN OE_WSH_BULK_GRP.line_rec_type DEFAULT NULL
586: -- This record structure contains information about the lines to be updated.
587: -- The information may include header id,line id ,line location id and other po
588: -- attributes..
589: -- p_dd_id_unassigned IN OUT NOCOPY wsh_util_core.id_tab_type
590: -- This contains the list of delviery details that needs to be unassigned from
591: -- the respective delivery.
592: -- p_wt_vol_dd_id IN OUT NOCOPY wsh_util_core.id_tab_type,
593: -- This contains the list of delviery details for which weight and volume needs to

Line 592: -- p_wt_vol_dd_id IN OUT NOCOPY wsh_util_core.id_tab_type,

588: -- attributes..
589: -- p_dd_id_unassigned IN OUT NOCOPY wsh_util_core.id_tab_type
590: -- This contains the list of delviery details that needs to be unassigned from
591: -- the respective delivery.
592: -- p_wt_vol_dd_id IN OUT NOCOPY wsh_util_core.id_tab_type,
593: -- This contains the list of delviery details for which weight and volume needs to
594: -- be re-calculated.
595: -- p_action_prms IN OUT NOCOPY
596: -- WSH_BULK_TYPES_GRP.action_parameters_rectype

Line 617: p_dd_id_unassigned IN OUT NOCOPY wsh_util_core.id_tab_type,

613: p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.line_rec_type,
614: p_action_prms IN WSH_BULK_TYPES_GRP.action_parameters_rectype,
615: p_dd_id IN NUMBER,
616: p_line_rec_index IN NUMBER,
617: p_dd_id_unassigned IN OUT NOCOPY wsh_util_core.id_tab_type,
618: p_wt_vol_dd_id IN OUT NOCOPY wsh_util_core.id_tab_type,
619: x_return_status OUT NOCOPY VARCHAR2) IS
620:
621: -- Cursor to fetch the delivery grouping attributes and other critical attributes

Line 618: p_wt_vol_dd_id IN OUT NOCOPY wsh_util_core.id_tab_type,

614: p_action_prms IN WSH_BULK_TYPES_GRP.action_parameters_rectype,
615: p_dd_id IN NUMBER,
616: p_line_rec_index IN NUMBER,
617: p_dd_id_unassigned IN OUT NOCOPY wsh_util_core.id_tab_type,
618: p_wt_vol_dd_id IN OUT NOCOPY wsh_util_core.id_tab_type,
619: x_return_status OUT NOCOPY VARCHAR2) IS
620:
621: -- Cursor to fetch the delivery grouping attributes and other critical attributes
622: -- like shipping control, freight term,fob,ultimate_drop_off_date of delivery.

Line 766: l_tp_del_id wsh_util_core.id_tab_type;

762: l_msg_data VARCHAR2(3000);
763: l_commit VARCHAR2(1);
764: l_validation_level NUMBER;
765: l_delivery_id NUMBER;
766: l_tp_del_id wsh_util_core.id_tab_type;
767:
768: l_delivery_name VARCHAR2(150);
769: l_num_warnings NUMBER := 0;
770: l_num_errors NUMBER := 0;

Line 773: l_del_fgt_terms_tbl wsh_util_core.id_tab_type;

769: l_num_warnings NUMBER := 0;
770: l_num_errors NUMBER := 0;
771: l_fgt_terms_code VARCHAR2(30);
772:
773: l_del_fgt_terms_tbl wsh_util_core.id_tab_type;
774: l_del_fgt_terms_tbl_cache WSH_UTIL_CORE.key_value_tab_type;
775: l_del_fgt_terms_tbl_ext_cache WSH_UTIL_CORE.key_value_tab_type;
776: l_ind NUMBER;
777: l_req_res_id NUMBER;

Line 774: l_del_fgt_terms_tbl_cache WSH_UTIL_CORE.key_value_tab_type;

770: l_num_errors NUMBER := 0;
771: l_fgt_terms_code VARCHAR2(30);
772:
773: l_del_fgt_terms_tbl wsh_util_core.id_tab_type;
774: l_del_fgt_terms_tbl_cache WSH_UTIL_CORE.key_value_tab_type;
775: l_del_fgt_terms_tbl_ext_cache WSH_UTIL_CORE.key_value_tab_type;
776: l_ind NUMBER;
777: l_req_res_id NUMBER;
778: l_msg varchar2(2000);

Line 775: l_del_fgt_terms_tbl_ext_cache WSH_UTIL_CORE.key_value_tab_type;

771: l_fgt_terms_code VARCHAR2(30);
772:
773: l_del_fgt_terms_tbl wsh_util_core.id_tab_type;
774: l_del_fgt_terms_tbl_cache WSH_UTIL_CORE.key_value_tab_type;
775: l_del_fgt_terms_tbl_ext_cache WSH_UTIL_CORE.key_value_tab_type;
776: l_ind NUMBER;
777: l_req_res_id NUMBER;
778: l_msg varchar2(2000);
779: l_check_routing_res varchar2(1);

Line 819: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

815: END IF;
816: --
817: SAVEPOINT Update_dd_Attributes_PVT;
818:
819: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
820:
821: IF (p_action_prms.action_code ='REAPPROVE_PO'
822: OR p_action_prms.action_code ='CANCEL_ASN') THEN
823: --{

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

881: --
882: -- Debug Statements
883: --
884: IF l_debug_on THEN
885: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
886: END IF;
887: --
888: wsh_util_core.api_post_call(
889: p_return_status => l_return_status,

Line 888: wsh_util_core.api_post_call(

884: IF l_debug_on THEN
885: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
886: END IF;
887: --
888: wsh_util_core.api_post_call(
889: p_return_status => l_return_status,
890: x_num_warnings => l_num_warnings,
891: x_num_errors => l_num_errors);
892:

Line 929: wsh_util_core.api_post_call(

925: IF l_debug_on THEN
926: WSH_DEBUG_SV.log(l_module_name,'After Log_Exception l_return_status',l_return_status);
927: END IF;
928:
929: wsh_util_core.api_post_call(
930: p_return_status => l_return_status,
931: x_num_warnings => l_num_warnings,
932: x_num_errors => l_num_errors);
933:

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

999: --
1000: -- Debug Statements
1001: --
1002: IF l_debug_on THEN
1003: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1004: END IF;
1005: --
1006: wsh_util_core.api_post_call(
1007: p_return_status => l_return_status,

Line 1006: wsh_util_core.api_post_call(

1002: IF l_debug_on THEN
1003: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1004: END IF;
1005: --
1006: wsh_util_core.api_post_call(
1007: p_return_status => l_return_status,
1008: x_num_warnings => l_num_warnings,
1009: x_num_errors => l_num_errors);
1010:

Line 1035: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

1031: IF l_debug_on THEN
1032: WSH_DEBUG_SV.log(l_module_name,'SQL%ROWCOUNT',SQL%ROWCOUNT);
1033: END IF;
1034: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_LINES_CHANGED');
1035: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1036: RAISE FND_API.G_EXC_ERROR;
1037: END IF;
1038:
1039: END IF;

Line 1068: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

1064: IF l_debug_on THEN
1065: WSH_DEBUG_SV.log(l_module_name,'SQL%ROWCOUNT',SQL%ROWCOUNT);
1066: END IF;
1067: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_LINES_CHANGED');
1068: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1069: RAISE FND_API.G_EXC_ERROR;
1070: END IF;
1071:
1072: --}

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

1137: --
1138: -- Debug Statements
1139: --
1140: IF l_debug_on THEN
1141: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1142: END IF;
1143: --
1144: wsh_util_core.api_post_call(
1145: p_return_status => l_return_status,

Line 1144: wsh_util_core.api_post_call(

1140: IF l_debug_on THEN
1141: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1142: END IF;
1143: --
1144: wsh_util_core.api_post_call(
1145: p_return_status => l_return_status,
1146: x_num_warnings => l_num_warnings,
1147: x_num_errors => l_num_errors);
1148:

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

1178: --
1179: -- Debug Statements
1180: --
1181: IF l_debug_on THEN
1182: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1183: END IF;
1184: --
1185: wsh_util_core.api_post_call(
1186: p_return_status => l_return_status,

Line 1185: wsh_util_core.api_post_call(

1181: IF l_debug_on THEN
1182: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1183: END IF;
1184: --
1185: wsh_util_core.api_post_call(
1186: p_return_status => l_return_status,
1187: x_num_warnings => l_num_warnings,
1188: x_num_errors => l_num_errors);
1189:

Line 1233: wsh_util_core.api_post_call(

1229: IF l_debug_on THEN
1230: WSH_DEBUG_SV.log(l_module_name,'Log_Exception l_return_status',l_return_status);
1231: END IF;
1232:
1233: wsh_util_core.api_post_call(
1234: p_return_status => l_return_status,
1235: x_num_warnings => l_num_warnings,
1236: x_num_errors => l_num_errors);
1237:

Line 1254: wsh_util_core.api_post_call(

1250: IF l_debug_on THEN
1251: WSH_DEBUG_SV.log(l_module_name,'Log_Exception l_return_status',l_return_status);
1252: END IF;
1253:
1254: wsh_util_core.api_post_call(
1255: p_return_status => l_return_status,
1256: x_num_warnings => l_num_warnings,
1257: x_num_errors => l_num_errors);
1258:

Line 1283: wsh_util_core.get_cached_value(

1279: (p_line_rec.source_blanket_reference_id(p_line_rec_index) IS NULL)
1280: THEN
1281: --{
1282: IF nvl(v_dd_attr.del_fgt,'!!!') <> nvl(p_line_rec.freight_terms_code(p_line_rec_index),'!!!') THEN
1283: wsh_util_core.get_cached_value(
1284: p_cache_tbl => l_del_fgt_terms_tbl_cache,
1285: p_cache_ext_tbl => l_del_fgt_terms_tbl_ext_cache,
1286: p_value => v_dd_attr.delivery_id,
1287: p_key => v_dd_attr.delivery_id,

Line 1291: wsh_util_core.api_post_call(

1287: p_key => v_dd_attr.delivery_id,
1288: p_action => 'PUT',
1289: x_return_status => l_return_status);
1290:
1291: wsh_util_core.api_post_call(
1292: p_return_status => l_return_status,
1293: x_num_warnings => l_num_warnings,
1294: x_num_errors => l_num_errors);
1295: END IF;

Line 1546: wsh_util_core.api_post_call(

1542: p_entity => 'DLVY',
1543: p_entity_ids => l_tp_del_id,
1544: x_return_status => l_return_status);
1545:
1546: wsh_util_core.api_post_call(
1547: p_return_status =>l_return_status,
1548: x_num_warnings => l_num_warnings,
1549: x_num_errors => l_num_errors);
1550:

Line 1590: wsh_util_core.api_post_call(

1586: p_action_code => 'ASSIGN',
1587: x_freight_terms_Code => l_fgt_terms_code,
1588: x_return_status => l_return_status);
1589:
1590: wsh_util_core.api_post_call(
1591: p_return_status => l_return_status,
1592: x_num_warnings => l_num_warnings,
1593: x_num_errors => l_num_errors);
1594:

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

1621: --
1622: --
1623: IF l_debug_on THEN
1624: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1625: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1626: END IF;
1627: --
1628: wsh_util_core.api_post_call
1629: (

Line 1628: wsh_util_core.api_post_call

1624: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1625: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1626: END IF;
1627: --
1628: wsh_util_core.api_post_call
1629: (
1630: p_return_status => l_return_status,
1631: x_num_warnings => l_num_warnings,
1632: x_num_errors => l_num_errors

Line 1647: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1643: WSH_DEBUG_SV.pop(l_module_name);
1644: END IF;
1645: --
1646: IF l_num_errors > 0 THEN
1647: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1648: ELSIF l_num_warnings > 0 THEN
1649: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1650: END IF;
1651:

Line 1649: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1645: --
1646: IF l_num_errors > 0 THEN
1647: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1648: ELSIF l_num_warnings > 0 THEN
1649: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1650: END IF;
1651:
1652:
1653: EXCEPTION

Line 1656: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1652:
1653: EXCEPTION
1654: WHEN e_wdd_locked THEN
1655: ROLLBACK TO Update_dd_Attributes_PVT;
1656: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1657: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_LINES_LOCKED');
1658: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
1659:
1660: --

Line 1658: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);

1654: WHEN e_wdd_locked THEN
1655: ROLLBACK TO Update_dd_Attributes_PVT;
1656: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1657: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_LINES_LOCKED');
1658: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
1659:
1660: --
1661: -- Debug Statements
1662: --

Line 1669: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1665: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:e_Wdd_locked');
1666: END IF;
1667: WHEN FND_API.G_EXC_ERROR THEN
1668: ROLLBACK TO Update_dd_Attributes_PVT;
1669: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1670: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
1671:
1672: --
1673: -- Debug Statements

Line 1670: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);

1666: END IF;
1667: WHEN FND_API.G_EXC_ERROR THEN
1668: ROLLBACK TO Update_dd_Attributes_PVT;
1669: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1670: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
1671:
1672: --
1673: -- Debug Statements
1674: --

Line 1682: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

1678: END IF;
1679: --
1680: WHEN OTHERS THEN
1681: ROLLBACK TO Update_dd_Attributes_PVT;
1682: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1683: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_CMG_PVT.Update_dd_Attributes',l_module_name);
1684:
1685: --
1686: -- Debug Statements

Line 1683: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_CMG_PVT.Update_dd_Attributes',l_module_name);

1679: --
1680: WHEN OTHERS THEN
1681: ROLLBACK TO Update_dd_Attributes_PVT;
1682: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1683: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_CMG_PVT.Update_dd_Attributes',l_module_name);
1684:
1685: --
1686: -- Debug Statements
1687: --

Line 1741: -- p_dd_id_unassigned IN OUT NOCOPY wsh_util_core.id_tab_type

1737: -- p_line_rec IN OE_WSH_BULK_GRP.line_rec_type DEFAULT NULL
1738: -- This record structure contains information about the lines to be updated.
1739: -- The information may include header id,line id ,line location id and other po
1740: -- attributes..
1741: -- p_dd_id_unassigned IN OUT NOCOPY wsh_util_core.id_tab_type
1742: -- This contains the list of delviery details that needs to be unassigned from
1743: -- the respective delivery.
1744: -- p_wt_vol_dd_id IN OUT NOCOPY wsh_util_core.id_tab_type,
1745: -- This contains the list of delviery details for which weight and volume needs to

Line 1744: -- p_wt_vol_dd_id IN OUT NOCOPY wsh_util_core.id_tab_type,

1740: -- attributes..
1741: -- p_dd_id_unassigned IN OUT NOCOPY wsh_util_core.id_tab_type
1742: -- This contains the list of delviery details that needs to be unassigned from
1743: -- the respective delivery.
1744: -- p_wt_vol_dd_id IN OUT NOCOPY wsh_util_core.id_tab_type,
1745: -- This contains the list of delviery details for which weight and volume needs to
1746: -- be re-calculated.
1747: -- p_action_prms IN OUT NOCOPY WSH_BULK_TYPES_GRP.action_parameters_rectype
1748: -- The record which specifies the caller, actio to be performed(REAPPROVE,CANCEL_ASN,RECEIPT,ASN)

Line 1759: p_dd_id_unassigned IN OUT NOCOPY wsh_util_core.id_tab_type,

1755:
1756: PROCEDURE Update_Quantity(
1757: p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.line_rec_type,
1758: p_action_prms IN OUT NOCOPY WSH_BULK_TYPES_GRP.action_parameters_rectype,
1759: p_dd_id_unassigned IN OUT NOCOPY wsh_util_core.id_tab_type,
1760: p_wt_vol_dd_id IN OUT NOCOPY wsh_util_core.id_tab_type,
1761: x_return_status OUT NOCOPY VARCHAR2) IS
1762:
1763: -- Cursor to get the source requested quantity corresponding to the

Line 1760: p_wt_vol_dd_id IN OUT NOCOPY wsh_util_core.id_tab_type,

1756: PROCEDURE Update_Quantity(
1757: p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.line_rec_type,
1758: p_action_prms IN OUT NOCOPY WSH_BULK_TYPES_GRP.action_parameters_rectype,
1759: p_dd_id_unassigned IN OUT NOCOPY wsh_util_core.id_tab_type,
1760: p_wt_vol_dd_id IN OUT NOCOPY wsh_util_core.id_tab_type,
1761: x_return_status OUT NOCOPY VARCHAR2) IS
1762:
1763: -- Cursor to get the source requested quantity corresponding to the
1764: -- po_line_location_id.

Line 1950: l_ratio_tbl WSH_UTIL_CORE.id_tab_type;

1946: l_num_errors NUMBER := 0;
1947: l_dd_id NUMBER;
1948: v_item_info_rec wsh_util_validate.item_info_rec_type;
1949: l_ratio NUMBER;
1950: l_ratio_tbl WSH_UTIL_CORE.id_tab_type;
1951: l_sum_req_qty NUMBER;
1952: l_requested_qty2 NUMBER;
1953: temp_qty2 NUMBER;
1954: l_diff_qty2 NUMBER;

Line 1956: l_dd_ids_dd_ids_cache WSH_UTIL_CORE.key_value_tab_type;

1952: l_requested_qty2 NUMBER;
1953: temp_qty2 NUMBER;
1954: l_diff_qty2 NUMBER;
1955:
1956: l_dd_ids_dd_ids_cache WSH_UTIL_CORE.key_value_tab_type;
1957: l_dd_ids_dd_ids_ext_cache WSH_UTIL_CORE.key_value_tab_type;
1958:
1959: -- Bug 3395410 : Added the following variable.
1960: l_routing_response_send VARCHAR2(1);

Line 1957: l_dd_ids_dd_ids_ext_cache WSH_UTIL_CORE.key_value_tab_type;

1953: temp_qty2 NUMBER;
1954: l_diff_qty2 NUMBER;
1955:
1956: l_dd_ids_dd_ids_cache WSH_UTIL_CORE.key_value_tab_type;
1957: l_dd_ids_dd_ids_ext_cache WSH_UTIL_CORE.key_value_tab_type;
1958:
1959: -- Bug 3395410 : Added the following variable.
1960: l_routing_response_send VARCHAR2(1);
1961:

Line 1989: l_detail_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project

1985: --
1986: e_wdd_locked EXCEPTION ;
1987: PRAGMA EXCEPTION_INIT(e_wdd_locked,-54);
1988:
1989: l_detail_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project
1990: l_dbi_rs VARCHAR2(1); -- Return Status from DBI API
1991: l_debug_on BOOLEAN;
1992: --
1993: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'UPDATE_QUANTITY';

Line 2014: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2010: END IF;
2011: --
2012: SAVEPOINT Update_Quantity_PVT;
2013:
2014: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2015:
2016:
2017:
2018: --code to copy to cache tables

Line 2024: wsh_util_core.get_cached_value(

2020:
2021: l_ind := p_wt_vol_dd_id.FIRST;
2022: WHILE l_ind IS NOT NULL
2023: LOOP
2024: wsh_util_core.get_cached_value(
2025: p_cache_tbl => l_dd_ids_dd_ids_cache,
2026: p_cache_ext_tbl => l_dd_ids_dd_ids_ext_cache,
2027: p_value => p_wt_vol_dd_id(l_ind),
2028: p_key => p_wt_vol_dd_id(l_ind),

Line 2032: wsh_util_core.api_post_call(

2028: p_key => p_wt_vol_dd_id(l_ind),
2029: p_action => 'PUT',
2030: x_return_status => l_return_status);
2031:
2032: wsh_util_core.api_post_call(
2033: p_return_status => l_return_status,
2034: x_num_warnings => l_num_warnings,
2035: x_num_errors => l_num_errors);
2036:

Line 2134: wsh_util_core.api_post_call(

2130: WSH_DEBUG_SV.log(l_module_name,'convert_quantity l_return_status',l_return_status);
2131: WSH_DEBUG_SV.log(l_module_name,'l_src_qty_to_change',l_src_qty_to_change);
2132: END IF;
2133:
2134: wsh_util_core.api_post_call(
2135: p_return_status => l_return_status,
2136: x_num_warnings => l_num_warnings,
2137: x_num_errors => l_num_errors);
2138:

Line 2161: wsh_util_core.api_post_call(

2157:
2158: IF l_debug_on THEN
2159: WSH_DEBUG_SV.log(l_module_name,'convert_quantity l_return_status,l_qty_to_change',l_return_status||','||l_qty_to_change);
2160: END IF;
2161: wsh_util_core.api_post_call(
2162: p_return_status => l_return_status,
2163: x_num_warnings => l_num_warnings,
2164: x_num_errors => l_num_errors);
2165:

Line 2195: wsh_util_core.api_post_call(

2191: WSH_DEBUG_SV.log(l_module_name,'convert_quantity l_return_status',l_return_status);
2192: WSH_DEBUG_SV.log(l_module_name,'l_src_qty_to_change',l_src_qty_to_change);
2193: END IF;
2194:
2195: wsh_util_core.api_post_call(
2196: p_return_status => l_return_status,
2197: x_num_warnings => l_num_warnings,
2198: x_num_errors => l_num_errors);
2199:

Line 2319: wsh_util_core.get_cached_value(

2315:
2316: --Collecting the list of delviery_detail_ids if the req qty is not
2317: --updated to 0.
2318: IF l_requested_qty <> 0 THEN
2319: wsh_util_core.get_cached_value(
2320: p_cache_tbl => l_dd_ids_dd_ids_cache,
2321: p_cache_ext_tbl => l_dd_ids_dd_ids_ext_cache,
2322: p_value => v_lines_without_rr.delivery_detail_id,
2323: p_key => v_lines_without_rr.delivery_detail_id,

Line 2327: wsh_util_core.api_post_call(

2323: p_key => v_lines_without_rr.delivery_detail_id,
2324: p_action => 'PUT',
2325: x_return_status => l_return_status);
2326:
2327: wsh_util_core.api_post_call(
2328: p_return_status => l_return_status,
2329: x_num_warnings => l_num_warnings,
2330: x_num_errors => l_num_errors);
2331:

Line 2363: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

2359: END IF;
2360:
2361: IF SQL%ROWCOUNT <> 1 THEN
2362: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_LINES_CHANGED');
2363: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
2364: RAISE FND_API.G_EXC_ERROR;
2365: END IF;
2366:
2367: --

Line 2384: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

2380:
2381: IF l_debug_on THEN
2382: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
2383: END IF;
2384: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2385: -- just pass this return status to caller API
2386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2387: END IF;
2388: -- End of Code for DBI Project

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

2526: --
2527: -- Debug Statements
2528: --
2529: IF l_debug_on THEN
2530: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2531: END IF;
2532: --
2533: wsh_util_core.api_post_call(
2534: p_return_status => x_return_status,

Line 2533: wsh_util_core.api_post_call(

2529: IF l_debug_on THEN
2530: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2531: END IF;
2532: --
2533: wsh_util_core.api_post_call(
2534: p_return_status => x_return_status,
2535: x_num_warnings => l_num_warnings,
2536: x_num_errors => l_num_errors);
2537:

Line 2578: wsh_util_core.api_post_call(

2574: IF l_debug_on THEN
2575: WSH_DEBUG_SV.log(l_module_name,'Log_Exception l_return_status',l_return_status);
2576: END IF;
2577:
2578: wsh_util_core.api_post_call(
2579: p_return_status => x_return_status,
2580: x_num_warnings => l_num_warnings,
2581: x_num_errors => l_num_errors);
2582: END IF;

Line 2589: wsh_util_core.get_cached_value(

2585:
2586:
2587:
2588: IF l_requested_qty <> 0 THEN
2589: wsh_util_core.get_cached_value(
2590: p_cache_tbl => l_dd_ids_dd_ids_cache,
2591: p_cache_ext_tbl => l_dd_ids_dd_ids_ext_cache,
2592: p_value => v_lines_with_rr.delivery_detail_id,
2593: p_key => v_lines_with_rr.delivery_detail_id,

Line 2597: wsh_util_core.api_post_call(

2593: p_key => v_lines_with_rr.delivery_detail_id,
2594: p_action => 'PUT',
2595: x_return_status => l_return_status);
2596:
2597: wsh_util_core.api_post_call(
2598: p_return_status => l_return_status,
2599: x_num_warnings => l_num_warnings,
2600: x_num_errors => l_num_errors);
2601:

Line 2625: wsh_util_core.api_post_call(

2621: WSH_DEBUG_SV.log(l_module_name,'convert_quantity l_return_status',l_return_status);
2622: WSH_DEBUG_SV.log(l_module_name,'l_conv_pick_qty',l_conv_pick_qty);
2623: END IF;
2624: --
2625: wsh_util_core.api_post_call(
2626: p_return_status => x_return_status,
2627: x_num_warnings => l_num_warnings,
2628: x_num_errors => l_num_errors);
2629:

Line 2673: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

2669: IF l_debug_on THEN
2670: WSH_DEBUG_SV.log(l_module_name,'SQL%ROWCOUNT',SQL%ROWCOUNT);
2671: END IF;
2672: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_LINES_CHANGED');
2673: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
2674: RAISE FND_API.G_EXC_ERROR;
2675: END IF;
2676:
2677: --

Line 2694: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

2690:
2691: IF l_debug_on THEN
2692: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
2693: END IF;
2694: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2695: -- just pass this return status to caller API
2696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2697: END IF;
2698: -- End of Code for DBI Project

Line 2746: wsh_util_core.api_post_call(

2742: IF l_debug_on THEN
2743: WSH_DEBUG_SV.log(l_module_name,'Log_Exception l_return_status',l_return_status);
2744: END IF;
2745:
2746: wsh_util_core.api_post_call(
2747: p_return_status => x_return_status,
2748: x_num_warnings => l_num_warnings,
2749: x_num_errors => l_num_errors);
2750:

Line 2765: wsh_util_core.api_post_call(

2761: IF l_debug_on THEN
2762: WSH_DEBUG_SV.log(l_module_name,'Log_Exception l_return_status',l_return_status);
2763: END IF;
2764:
2765: wsh_util_core.api_post_call(
2766: p_return_status => x_return_status,
2767: x_num_warnings => l_num_warnings,
2768: x_num_errors => l_num_errors);
2769:

Line 2793: wsh_util_core.api_post_call(

2789:
2790: IF l_debug_on THEN
2791: WSH_DEBUG_SV.log(l_module_name,'Log_Exception l_return_status',l_return_status);
2792: END IF;
2793: wsh_util_core.api_post_call(
2794: p_return_status => x_return_status,
2795: x_num_warnings => l_num_warnings,
2796: x_num_errors => l_num_errors);
2797:

Line 2841: wsh_util_core.get_cached_value(

2837: FETCH c_inc_qty INTO l_delivery_detail_id, l_requested_qty,
2838: l_requested_quantity_uom, l_inventory_item_id, l_last_update_date; --HACMS
2839: CLOSE c_inc_qty;
2840:
2841: wsh_util_core.get_cached_value(
2842: p_cache_tbl => l_dd_ids_dd_ids_cache,
2843: p_cache_ext_tbl => l_dd_ids_dd_ids_ext_cache,
2844: p_value => l_delivery_detail_id,
2845: p_key => l_delivery_detail_id,

Line 2849: wsh_util_core.api_post_call(

2845: p_key => l_delivery_detail_id,
2846: p_action => 'PUT',
2847: x_return_status => l_return_status);
2848:
2849: wsh_util_core.api_post_call(
2850: p_return_status => l_return_status,
2851: x_num_warnings => l_num_warnings,
2852: x_num_errors => l_num_errors);
2853:

Line 2910: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

2906: IF l_debug_on THEN
2907: WSH_DEBUG_SV.log(l_module_name,'SQL%ROWCOUNT',SQL%ROWCOUNT);
2908: END IF;
2909: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_LINES_CHANGED');
2910: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
2911: RAISE FND_API.G_EXC_ERROR;
2912: END IF;
2913: l_update_flag := TRUE;
2914:

Line 2932: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

2928:
2929: IF l_debug_on THEN
2930: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
2931: END IF;
2932: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2933: -- just pass this return status to caller API
2934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2935: END IF;
2936: -- End of Code for DBI Project

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

2963: --
2964: -- Debug Statements
2965: --
2966: IF l_debug_on THEN
2967: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2968: END IF;
2969: --
2970: wsh_util_core.api_post_call(
2971: p_return_status => l_return_status,

Line 2970: wsh_util_core.api_post_call(

2966: IF l_debug_on THEN
2967: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2968: END IF;
2969: --
2970: wsh_util_core.api_post_call(
2971: p_return_status => l_return_status,
2972: x_num_warnings => l_num_warnings,
2973: x_num_errors => l_num_errors);
2974:

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

3000: --
3001: -- Debug Statements
3002: --
3003: IF l_debug_on THEN
3004: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
3005: END IF;
3006: --
3007: wsh_util_core.api_post_call(
3008: p_return_status => l_return_status,

Line 3007: wsh_util_core.api_post_call(

3003: IF l_debug_on THEN
3004: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
3005: END IF;
3006: --
3007: wsh_util_core.api_post_call(
3008: p_return_status => l_return_status,
3009: x_num_warnings => l_num_warnings,
3010: x_num_errors => l_num_errors);
3011:

Line 3012: wsh_util_core.get_cached_value(

3008: p_return_status => l_return_status,
3009: x_num_warnings => l_num_warnings,
3010: x_num_errors => l_num_errors);
3011:
3012: wsh_util_core.get_cached_value(
3013: p_cache_tbl => l_dd_ids_dd_ids_cache,
3014: p_cache_ext_tbl => l_dd_ids_dd_ids_ext_cache,
3015: p_value => p_line_rec.delivery_detail_id(i),
3016: p_key => p_line_rec.delivery_detail_id(i),

Line 3020: wsh_util_core.api_post_call(

3016: p_key => p_line_rec.delivery_detail_id(i),
3017: p_action => 'PUT',
3018: x_return_status => l_return_status);
3019:
3020: wsh_util_core.api_post_call(
3021: p_return_status => l_return_status,
3022: x_num_warnings => l_num_warnings,
3023: x_num_errors => l_num_errors);
3024:

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

3057: --
3058: -- Debug Statements
3059: --
3060: IF l_debug_on THEN
3061: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
3062: END IF;
3063: --
3064: wsh_util_core.api_post_call(
3065: p_return_status => l_return_status,

Line 3064: wsh_util_core.api_post_call(

3060: IF l_debug_on THEN
3061: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
3062: END IF;
3063: --
3064: wsh_util_core.api_post_call(
3065: p_return_status => l_return_status,
3066: x_num_warnings => l_num_warnings,
3067: x_num_errors => l_num_errors);
3068:

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

3092: --
3093: -- Debug Statements
3094: --
3095: IF l_debug_on THEN
3096: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
3097: END IF;
3098: --
3099: wsh_util_core.api_post_call(
3100: p_return_status => l_return_status,

Line 3099: wsh_util_core.api_post_call(

3095: IF l_debug_on THEN
3096: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
3097: END IF;
3098: --
3099: wsh_util_core.api_post_call(
3100: p_return_status => l_return_status,
3101: x_num_warnings => l_num_warnings,
3102: x_num_errors => l_num_errors);
3103:

Line 3127: wsh_util_core.api_post_call(

3123: IF l_debug_on THEN
3124: WSH_DEBUG_SV.log(l_module_name,'convert_quantity Req Qty l_return_status,l_qty_to_change',l_return_status||','||l_qty_to_change);
3125: END IF;
3126:
3127: wsh_util_core.api_post_call(
3128: p_return_status => l_return_status,
3129: x_num_warnings => l_num_warnings,
3130: x_num_errors => l_num_errors);
3131:

Line 3148: wsh_util_core.api_post_call(

3144: WSH_DEBUG_SV.log(l_module_name,'convert_quantity Pick Qty l_return_status',l_return_status);
3145: WSH_DEBUG_SV.log(l_module_name,'l_pick_qty',l_pick_qty);
3146: END IF;
3147: --
3148: wsh_util_core.api_post_call(
3149: p_return_status => x_return_status,
3150: x_num_warnings => l_num_warnings,
3151: x_num_errors => l_num_errors);
3152:

Line 3177: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

3173: IF l_debug_on THEN
3174: WSH_DEBUG_SV.log(l_module_name,'SQL%ROWCOUNT',SQL%ROWCOUNT);
3175: END IF;
3176: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_LINES_CHANGED');
3177: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
3178: RAISE FND_API.G_EXC_ERROR;
3179: END IF;
3180: --
3181: -- DBI Project

Line 3197: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

3193:
3194: IF l_debug_on THEN
3195: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
3196: END IF;
3197: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3198: -- just pass this return status to caller API
3199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3200: END IF;
3201: -- End of Code for DBI Project

Line 3230: requested_quantity2 = decode(released_status,'X',ROUND(l_ratio_tbl(i) * requested_quantity ,WSH_UTIL_CORE.C_MAX_DECIMAL_DIGITS_INV),requested_quantity2),

3226: Set src_requested_quantity = nvl(p_line_rec.ordered_quantity(i),src_requested_quantity),
3227: src_requested_quantity_uom = nvl(p_line_rec.order_quantity_uom(i),src_requested_quantity_uom),
3228: --HACMS
3229: -- HW OPMCONV - No need to use OPM precision. Use current INV which is 5
3230: requested_quantity2 = decode(released_status,'X',ROUND(l_ratio_tbl(i) * requested_quantity ,WSH_UTIL_CORE.C_MAX_DECIMAL_DIGITS_INV),requested_quantity2),
3231: cancelled_quantity2 = decode(released_status,'X',ROUND(l_ratio_tbl(i) * cancelled_quantity ,WSH_UTIL_CORE.C_MAX_DECIMAL_DIGITS_INV),cancelled_quantity2),
3232: picked_quantity2 = decode(released_status,'X',ROUND(l_ratio_tbl(i) * picked_quantity ,WSH_UTIL_CORE.C_MAX_DECIMAL_DIGITS_INV),picked_quantity2),
3233: src_requested_quantity2 = nvl(p_line_rec.ordered_quantity2(i),src_requested_quantity2),
3234: src_requested_quantity_uom2 = nvl(p_line_rec.ordered_quantity_uom2(i),src_requested_quantity_uom2),

Line 3231: cancelled_quantity2 = decode(released_status,'X',ROUND(l_ratio_tbl(i) * cancelled_quantity ,WSH_UTIL_CORE.C_MAX_DECIMAL_DIGITS_INV),cancelled_quantity2),

3227: src_requested_quantity_uom = nvl(p_line_rec.order_quantity_uom(i),src_requested_quantity_uom),
3228: --HACMS
3229: -- HW OPMCONV - No need to use OPM precision. Use current INV which is 5
3230: requested_quantity2 = decode(released_status,'X',ROUND(l_ratio_tbl(i) * requested_quantity ,WSH_UTIL_CORE.C_MAX_DECIMAL_DIGITS_INV),requested_quantity2),
3231: cancelled_quantity2 = decode(released_status,'X',ROUND(l_ratio_tbl(i) * cancelled_quantity ,WSH_UTIL_CORE.C_MAX_DECIMAL_DIGITS_INV),cancelled_quantity2),
3232: picked_quantity2 = decode(released_status,'X',ROUND(l_ratio_tbl(i) * picked_quantity ,WSH_UTIL_CORE.C_MAX_DECIMAL_DIGITS_INV),picked_quantity2),
3233: src_requested_quantity2 = nvl(p_line_rec.ordered_quantity2(i),src_requested_quantity2),
3234: src_requested_quantity_uom2 = nvl(p_line_rec.ordered_quantity_uom2(i),src_requested_quantity_uom2),
3235: --HACMS

Line 3232: picked_quantity2 = decode(released_status,'X',ROUND(l_ratio_tbl(i) * picked_quantity ,WSH_UTIL_CORE.C_MAX_DECIMAL_DIGITS_INV),picked_quantity2),

3228: --HACMS
3229: -- HW OPMCONV - No need to use OPM precision. Use current INV which is 5
3230: requested_quantity2 = decode(released_status,'X',ROUND(l_ratio_tbl(i) * requested_quantity ,WSH_UTIL_CORE.C_MAX_DECIMAL_DIGITS_INV),requested_quantity2),
3231: cancelled_quantity2 = decode(released_status,'X',ROUND(l_ratio_tbl(i) * cancelled_quantity ,WSH_UTIL_CORE.C_MAX_DECIMAL_DIGITS_INV),cancelled_quantity2),
3232: picked_quantity2 = decode(released_status,'X',ROUND(l_ratio_tbl(i) * picked_quantity ,WSH_UTIL_CORE.C_MAX_DECIMAL_DIGITS_INV),picked_quantity2),
3233: src_requested_quantity2 = nvl(p_line_rec.ordered_quantity2(i),src_requested_quantity2),
3234: src_requested_quantity_uom2 = nvl(p_line_rec.ordered_quantity_uom2(i),src_requested_quantity_uom2),
3235: --HACMS
3236: source_line_number = p_line_rec.source_line_number(i),

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

3247: (p_line_rec.source_blanket_reference_id(i) IS NOT NULL AND source_blanket_reference_id = p_line_rec.source_blanket_reference_id(i))) ;
3248:
3249:
3250: IF l_debug_on THEN
3251: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
3252: END IF;
3253: --
3254: END IF;
3255:

Line 3298: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3294: WSH_DEBUG_SV.pop(l_module_name);
3295: END IF;
3296: --
3297: IF l_num_errors > 0 THEN
3298: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3299: ELSIF l_num_warnings > 0 THEN
3300: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3301: END IF;
3302:

Line 3300: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3296: --
3297: IF l_num_errors > 0 THEN
3298: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3299: ELSIF l_num_warnings > 0 THEN
3300: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3301: END IF;
3302:
3303:
3304: EXCEPTION

Line 3307: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3303:
3304: EXCEPTION
3305: WHEN e_wdd_locked THEN
3306: ROLLBACK TO Update_quantity_PVT;
3307: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3308: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_LINES_LOCKED');
3309: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
3310:
3311: --

Line 3309: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);

3305: WHEN e_wdd_locked THEN
3306: ROLLBACK TO Update_quantity_PVT;
3307: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3308: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_LINES_LOCKED');
3309: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
3310:
3311: --
3312: -- Debug Statements
3313: --

Line 3320: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3316: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:e_Wdd_locked');
3317: END IF;
3318: WHEN FND_API.G_EXC_ERROR THEN
3319: ROLLBACK TO Update_quantity_PVT;
3320: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3321: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
3322: --
3323: -- Debug Statements
3324: --

Line 3321: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);

3317: END IF;
3318: WHEN FND_API.G_EXC_ERROR THEN
3319: ROLLBACK TO Update_quantity_PVT;
3320: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3321: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
3322: --
3323: -- Debug Statements
3324: --
3325: IF l_debug_on THEN

Line 3333: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

3329: --
3330: -- Added for DBI Project to handle Unexpected error
3331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3332: ROLLBACK TO Update_quantity_PVT;
3333: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3334: --
3335: IF l_debug_on THEN
3336: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3337: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 3343: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

3339: --
3340: -- End of Code Added for DBI Project to handle Unexpected error
3341: WHEN OTHERS THEN
3342: ROLLBACK TO Update_quantity_PVT;
3343: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3344: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_CMG_PVT.Update_quantity',l_module_name);
3345:
3346: --
3347: -- Debug Statements

Line 3344: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_CMG_PVT.Update_quantity',l_module_name);

3340: -- End of Code Added for DBI Project to handle Unexpected error
3341: WHEN OTHERS THEN
3342: ROLLBACK TO Update_quantity_PVT;
3343: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3344: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_CMG_PVT.Update_quantity',l_module_name);
3345:
3346: --
3347: -- Debug Statements
3348: --

Line 3422: dd_ids_tab WSH_UTIL_CORE.ID_TAB_TYPE;

3418: l_return_status VARCHAR2(1);
3419: l_num_warnings NUMBER := 0;
3420: l_num_errors NUMBER := 0;
3421: l_index NUMBER := 0;
3422: dd_ids_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3423: dd_ids_tab_for_unassign WSH_UTIL_CORE.ID_TAB_TYPE;
3424: req_qty_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3425: req_qty2_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3426: last_update_date_tab WSH_UTIL_CORE.date_tab_type;

Line 3423: dd_ids_tab_for_unassign WSH_UTIL_CORE.ID_TAB_TYPE;

3419: l_num_warnings NUMBER := 0;
3420: l_num_errors NUMBER := 0;
3421: l_index NUMBER := 0;
3422: dd_ids_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3423: dd_ids_tab_for_unassign WSH_UTIL_CORE.ID_TAB_TYPE;
3424: req_qty_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3425: req_qty2_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3426: last_update_date_tab WSH_UTIL_CORE.date_tab_type;
3427:

Line 3424: req_qty_tab WSH_UTIL_CORE.ID_TAB_TYPE;

3420: l_num_errors NUMBER := 0;
3421: l_index NUMBER := 0;
3422: dd_ids_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3423: dd_ids_tab_for_unassign WSH_UTIL_CORE.ID_TAB_TYPE;
3424: req_qty_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3425: req_qty2_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3426: last_update_date_tab WSH_UTIL_CORE.date_tab_type;
3427:
3428: l_api_version NUMBER := 1.0;

Line 3425: req_qty2_tab WSH_UTIL_CORE.ID_TAB_TYPE;

3421: l_index NUMBER := 0;
3422: dd_ids_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3423: dd_ids_tab_for_unassign WSH_UTIL_CORE.ID_TAB_TYPE;
3424: req_qty_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3425: req_qty2_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3426: last_update_date_tab WSH_UTIL_CORE.date_tab_type;
3427:
3428: l_api_version NUMBER := 1.0;
3429: l_init_msg_list VARCHAR2(30) := NULL;

Line 3426: last_update_date_tab WSH_UTIL_CORE.date_tab_type;

3422: dd_ids_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3423: dd_ids_tab_for_unassign WSH_UTIL_CORE.ID_TAB_TYPE;
3424: req_qty_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3425: req_qty2_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3426: last_update_date_tab WSH_UTIL_CORE.date_tab_type;
3427:
3428: l_api_version NUMBER := 1.0;
3429: l_init_msg_list VARCHAR2(30) := NULL;
3430: l_msg_count NUMBER;

Line 3437: l_detail_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project

3433: l_validation_level NUMBER;
3434: l_delivery_id NUMBER;
3435: l_action_prms wsh_glbl_var_strct_grp.dd_action_parameters_rec_type;
3436:
3437: l_detail_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project
3438: l_dbi_rs VARCHAR2(1); -- Return Status from DBI API
3439:
3440: e_wdd_locked EXCEPTION ;
3441: PRAGMA EXCEPTION_INIT(e_wdd_locked,-54);

Line 3464: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS ;

3460: WSH_DEBUG_SV.push(l_module_name);
3461: END IF;
3462: --
3463: SAVEPOINT cancel_close_PO_PVT;
3464: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS ;
3465:
3466: l_index := p_line_rec.line_id.FIRST;
3467: IF l_debug_on THEN
3468: WSH_DEBUG_SV.log(l_module_name,'action code is :',p_action_prms.action_code);

Line 3527: l_action_prms.caller := wsh_util_core.C_IB_PO_PREFIX;

3523: IF l_debug_on THEN
3524: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_MULTIPLE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
3525: END IF;
3526:
3527: l_action_prms.caller := wsh_util_core.C_IB_PO_PREFIX;
3528:
3529: WSH_DELIVERY_DETAILS_ACTIONS.unassign_multiple_details(
3530: p_rec_of_detail_ids => dd_ids_tab_for_unassign,
3531: p_from_delivery => 'Y',

Line 3537: wsh_util_core.api_post_call(

3533: x_return_status => l_return_status,
3534: p_validate_flag => 'N',
3535: p_action_prms => l_action_prms);
3536:
3537: wsh_util_core.api_post_call(
3538: p_return_status => l_return_status,
3539: x_num_warnings => l_num_warnings,
3540: x_num_errors => l_num_errors);
3541: END IF;

Line 3600: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

3596: IF l_debug_on THEN
3597: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
3598: END IF;
3599: -- Only Handle Unexpected error
3600: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3601: x_return_status := l_dbi_rs;
3602: --
3603: IF l_debug_on THEN
3604: WSH_DEBUG_SV.pop(l_module_name);

Line 3621: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3617: WSH_DEBUG_SV.pop(l_module_name);
3618: END IF;
3619: --
3620: IF l_num_errors > 0 THEN
3621: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3622: ELSIF l_num_warnings > 0 THEN
3623: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3624: END IF;
3625:

Line 3623: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3619: --
3620: IF l_num_errors > 0 THEN
3621: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3622: ELSIF l_num_warnings > 0 THEN
3623: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3624: END IF;
3625:
3626:
3627: EXCEPTION

Line 3630: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3626:
3627: EXCEPTION
3628: WHEN e_wdd_locked THEN
3629: ROLLBACK TO cancel_close_PO_PVT;
3630: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3631: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_LINES_LOCKED');
3632: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
3633:
3634: --

Line 3632: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);

3628: WHEN e_wdd_locked THEN
3629: ROLLBACK TO cancel_close_PO_PVT;
3630: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3631: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_LINES_LOCKED');
3632: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
3633:
3634: --
3635: -- Debug Statements
3636: --

Line 3643: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3639: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:e_Wdd_locked');
3640: END IF;
3641: WHEN FND_API.G_EXC_ERROR THEN
3642: ROLLBACK TO cancel_close_PO_PVT;
3643: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3644: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
3645:
3646: --
3647: -- Debug Statements

Line 3644: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);

3640: END IF;
3641: WHEN FND_API.G_EXC_ERROR THEN
3642: ROLLBACK TO cancel_close_PO_PVT;
3643: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3644: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
3645:
3646: --
3647: -- Debug Statements
3648: --

Line 3656: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

3652: END IF;
3653: --
3654: WHEN OTHERS THEN
3655: ROLLBACK TO cancel_close_PO_PVT;
3656: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3657: WSH_UTIL_CORE.Default_Handler('WSH_PO_CMG_PVT.CANCEL_CLOSE_PO',l_module_name);
3658:
3659: --
3660: -- Debug Statements

Line 3657: WSH_UTIL_CORE.Default_Handler('WSH_PO_CMG_PVT.CANCEL_CLOSE_PO',l_module_name);

3653: --
3654: WHEN OTHERS THEN
3655: ROLLBACK TO cancel_close_PO_PVT;
3656: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3657: WSH_UTIL_CORE.Default_Handler('WSH_PO_CMG_PVT.CANCEL_CLOSE_PO',l_module_name);
3658:
3659: --
3660: -- Debug Statements
3661: --

Line 3702: l_detail_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project

3698:
3699: l_num_warnings NUMBER;
3700: l_num_errors NUMBER;
3701:
3702: l_detail_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project
3703: l_dbi_rs VARCHAR2(1); -- Return Status from DBI API
3704: --
3705: l_debug_on BOOLEAN;
3706: --

Line 3728: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3724: END IF;
3725: --
3726: SAVEPOINT REOPEN_PO_PVT;
3727:
3728: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3729:
3730: FORALL i IN p_line_rec.header_id.FIRST..p_line_rec.header_id.LAST
3731: UPDATE wsh_delivery_details
3732: SET released_status = 'X'

Line 3763: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

3759: IF l_debug_on THEN
3760: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
3761: END IF;
3762: -- Only Handle Unexpected error
3763: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3764: x_return_status := l_dbi_rs;
3765: --
3766: ROLLBACK TO REOPEN_PO_PVT;
3767: IF l_debug_on THEN

Line 3776: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3772: END IF;
3773: -- End of Code for DBI Project
3774: --
3775: IF l_num_errors > 0 THEN
3776: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3777: ELSIF l_num_warnings > 0 THEN
3778: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3779: END IF;
3780:

Line 3778: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3774: --
3775: IF l_num_errors > 0 THEN
3776: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3777: ELSIF l_num_warnings > 0 THEN
3778: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3779: END IF;
3780:
3781: --
3782: -- Debug Statements

Line 3792: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

3788:
3789: EXCEPTION
3790: WHEN OTHERS THEN
3791: ROLLBACK TO REOPEN_PO_PVT;
3792: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3793: WSH_UTIL_CORE.Default_Handler('WSH_PO_CMG_PVT.Reopen_po',l_module_name);
3794:
3795: --
3796: -- Debug Statements

Line 3793: WSH_UTIL_CORE.Default_Handler('WSH_PO_CMG_PVT.Reopen_po',l_module_name);

3789: EXCEPTION
3790: WHEN OTHERS THEN
3791: ROLLBACK TO REOPEN_PO_PVT;
3792: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3793: WSH_UTIL_CORE.Default_Handler('WSH_PO_CMG_PVT.Reopen_po',l_module_name);
3794:
3795: --
3796: -- Debug Statements
3797: --

Line 3883: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3879: WSH_DEBUG_SV.log(l_module_name,'p_location_id',p_location_id);
3880: WSH_DEBUG_SV.log(l_module_name,'p_message',p_message);
3881: END IF;
3882: --
3883: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3884:
3885: IF p_logging_entity_name = 'DELIVERY' THEN
3886: --
3887: -- Debug Statements

Line 3906: wsh_util_core.api_post_call(

3902: p_logging_entity_name => p_logging_entity_name,
3903: x_exceptions_tab => l_exceptions_tab
3904: );
3905:
3906: wsh_util_core.api_post_call(
3907: p_return_status => l_return_status,
3908: x_num_warnings => l_num_warnings,
3909: x_num_errors => l_num_errors);
3910:

Line 3931: wsh_util_core.api_post_call(

3927: p_logging_entity_name => p_logging_entity_name,
3928: x_exceptions_tab => l_exceptions_tab
3929: );
3930:
3931: wsh_util_core.api_post_call(
3932: p_return_status => l_return_status,
3933: x_num_warnings => l_num_warnings,
3934: x_num_errors => l_num_errors);
3935: END IF;

Line 3996: wsh_util_core.api_post_call(

3992: p_message => p_message,
3993: p_delivery_id => p_entity_id,
3994: p_error_message => l_exception_error_message);
3995:
3996: wsh_util_core.api_post_call(
3997: p_return_status => l_return_status,
3998: x_num_warnings => l_num_warnings,
3999: x_num_errors => l_num_errors);
4000: ELSIF p_logging_entity_name = 'STOP' THEN

Line 4030: wsh_util_core.api_post_call(

4026: p_message => p_message,
4027: p_trip_stop_id => p_entity_id,
4028: p_error_message => l_exception_error_message);
4029:
4030: wsh_util_core.api_post_call(
4031: p_return_status => l_return_status,
4032: x_num_warnings => l_num_warnings,
4033: x_num_errors => l_num_errors);
4034:

Line 4061: wsh_util_core.api_post_call(

4057:
4058: IF l_debug_on THEN
4059: WSH_DEBUG_SV.log(l_module_name,'wsh_xc_util.log_exception l_return_status',l_return_status);
4060: END IF;
4061: wsh_util_core.api_post_call(
4062: p_return_status => l_return_status,
4063: x_num_warnings => l_num_warnings,
4064: x_num_errors => l_num_errors);
4065: IF l_debug_on THEN

Line 4066: WSH_DEBUG_SV.logmsg(l_module_name,'after wsh_util_core.api_post_call');

4062: p_return_status => l_return_status,
4063: x_num_warnings => l_num_warnings,
4064: x_num_errors => l_num_errors);
4065: IF l_debug_on THEN
4066: WSH_DEBUG_SV.logmsg(l_module_name,'after wsh_util_core.api_post_call');
4067: END IF;
4068: END IF;
4069: --HACMS }
4070:

Line 4076: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4072: WSH_DEBUG_SV.pop(l_module_name);
4073: END IF;
4074: --
4075: IF l_num_errors > 0 THEN
4076: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4077: ELSIF l_num_warnings > 0 THEN
4078: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4079: END IF;
4080:

Line 4078: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

4074: --
4075: IF l_num_errors > 0 THEN
4076: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4077: ELSIF l_num_warnings > 0 THEN
4078: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4079: END IF;
4080:
4081: EXCEPTION
4082: WHEN FND_API.G_EXC_ERROR THEN

Line 4083: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4079: END IF;
4080:
4081: EXCEPTION
4082: WHEN FND_API.G_EXC_ERROR THEN
4083: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4084: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
4085:
4086: --
4087: -- Debug Statements

Line 4084: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);

4080:
4081: EXCEPTION
4082: WHEN FND_API.G_EXC_ERROR THEN
4083: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4084: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
4085:
4086: --
4087: -- Debug Statements
4088: --

Line 4095: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

4091: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4092: END IF;
4093: --
4094: WHEN OTHERS THEN
4095: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4096: WSH_UTIL_CORE.Default_Handler('WSH_PO_CMG_PVT.LOG_EXCEPTION',l_module_name);
4097:
4098: --
4099: -- Debug Statements

Line 4096: WSH_UTIL_CORE.Default_Handler('WSH_PO_CMG_PVT.LOG_EXCEPTION',l_module_name);

4092: END IF;
4093: --
4094: WHEN OTHERS THEN
4095: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4096: WSH_UTIL_CORE.Default_Handler('WSH_PO_CMG_PVT.LOG_EXCEPTION',l_module_name);
4097:
4098: --
4099: -- Debug Statements
4100: --

Line 4233: WSH_UTIL_CORE.Default_Handler('WSH_PO_CMG_PVT.check_pending_txns',l_module_name);

4229:
4230:
4231: EXCEPTION
4232: WHEN OTHERS THEN
4233: WSH_UTIL_CORE.Default_Handler('WSH_PO_CMG_PVT.check_pending_txns',l_module_name);
4234: --
4235: -- Debug Statements
4236: --
4237: IF l_debug_on THEN

Line 4295: l_cache_tbl wsh_util_core.char500_tab_type;

4291: l_num_errors NUMBER := 0;
4292: v_item_info_rec wsh_util_validate.item_info_rec_type;
4293: l_vendor_party_exists VARCHAR2(1);
4294: l_index NUMBER;
4295: l_cache_tbl wsh_util_core.char500_tab_type;
4296: l_cache_ext_tbl wsh_util_core.char500_tab_type;
4297: --
4298: l_debug_on BOOLEAN;
4299: --

Line 4296: l_cache_ext_tbl wsh_util_core.char500_tab_type;

4292: v_item_info_rec wsh_util_validate.item_info_rec_type;
4293: l_vendor_party_exists VARCHAR2(1);
4294: l_index NUMBER;
4295: l_cache_tbl wsh_util_core.char500_tab_type;
4296: l_cache_ext_tbl wsh_util_core.char500_tab_type;
4297: --
4298: l_debug_on BOOLEAN;
4299: --
4300: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'POPULATE_ADDITIONAL_LINE_INFO';

Line 4321: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4317: --
4318: WSH_DEBUG_SV.log(l_module_name,'P_INDEX',P_INDEX);
4319: END IF;
4320: --
4321: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4322:
4323: --
4324: -- Debug Statements
4325: --

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

4338: --
4339: -- Debug Statements
4340: --
4341: IF l_debug_on THEN
4342: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
4343: END IF;
4344: --
4345: Wsh_util_core.api_post_call(
4346: p_return_status => x_return_status,

Line 4345: Wsh_util_core.api_post_call(

4341: IF l_debug_on THEN
4342: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
4343: END IF;
4344: --
4345: Wsh_util_core.api_post_call(
4346: p_return_status => x_return_status,
4347: x_num_warnings => l_num_warnings,
4348: x_num_errors => l_num_errors);
4349:

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

4423: p_index => l_index,
4424: x_return_status => l_return_status);
4425:
4426: IF l_debug_on THEN
4427: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
4428: END IF;
4429:
4430: wsh_util_core.api_post_call(
4431: p_return_status => l_return_status,

Line 4430: wsh_util_core.api_post_call(

4426: IF l_debug_on THEN
4427: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
4428: END IF;
4429:
4430: wsh_util_core.api_post_call(
4431: p_return_status => l_return_status,
4432: x_num_warnings => l_num_warnings,
4433: x_num_errors => l_num_errors);
4434:

Line 4478: wsh_util_core.api_post_call(

4474: p_index => i,
4475: p_additional_line_info_rec => p_additional_line_info_rec,
4476: x_return_status => l_return_status);
4477:
4478: wsh_util_core.api_post_call(
4479: p_return_status => l_return_status,
4480: x_num_warnings => l_num_warnings,
4481: x_num_errors => l_num_errors);
4482: --}

Line 4559: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4555: WSH_DEBUG_SV.pop(l_module_name);
4556: END IF;
4557: --
4558: IF l_num_errors > 0 THEN
4559: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4560: ELSIF l_num_warnings > 0 THEN
4561: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4562: END IF;
4563:

Line 4561: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

4557: --
4558: IF l_num_errors > 0 THEN
4559: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4560: ELSIF l_num_warnings > 0 THEN
4561: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4562: END IF;
4563:
4564:
4565: EXCEPTION

Line 4567: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4563:
4564:
4565: EXCEPTION
4566: WHEN FND_API.G_EXC_ERROR THEN
4567: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4568: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
4569: --
4570: -- Debug Statements
4571: --

Line 4568: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);

4564:
4565: EXCEPTION
4566: WHEN FND_API.G_EXC_ERROR THEN
4567: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4568: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
4569: --
4570: -- Debug Statements
4571: --
4572: IF l_debug_on THEN

Line 4578: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

4574: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4575: END IF;
4576: --
4577: WHEN OTHERS THEN
4578: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4579: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_CMG_PVT.populate_additional_line_info',l_module_name);
4580:
4581: --
4582: -- Debug Statements

Line 4579: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_CMG_PVT.populate_additional_line_info',l_module_name);

4575: END IF;
4576: --
4577: WHEN OTHERS THEN
4578: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4579: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_CMG_PVT.populate_additional_line_info',l_module_name);
4580:
4581: --
4582: -- Debug Statements
4583: --

Line 4633: x_return_status := wsh_util_core.g_ret_sts_success;

4629: --
4630:
4631: BEGIN
4632:
4633: x_return_status := wsh_util_core.g_ret_sts_success;
4634: --
4635: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4636: --
4637: IF l_debug_on IS NULL

Line 4666: wsh_util_core.api_post_call(

4662: p_inventory_item_id => p_line_rec.inventory_item_id(p_index),
4663: x_Item_info_rec => l_item_info_rec,
4664: x_return_status => l_return_status);
4665:
4666: wsh_util_core.api_post_call(
4667: p_return_status => l_return_status,
4668: x_num_warnings => l_num_warnings,
4669: x_num_errors => l_num_errors);
4670:

Line 4694: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4690: END IF;--}
4691:
4692: EXCEPTION
4693: WHEN FND_API.G_EXC_ERROR THEN
4694: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4695: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
4696:
4697: --
4698: -- Debug Statements

Line 4695: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);

4691:
4692: EXCEPTION
4693: WHEN FND_API.G_EXC_ERROR THEN
4694: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4695: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
4696:
4697: --
4698: -- Debug Statements
4699: --

Line 4706: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

4702: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4703: END IF;
4704: --
4705: WHEN OTHERS THEN
4706: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4707: WSH_UTIL_CORE.Default_Handler('WSH_PO_CMG_PVT.Calculate_Wt_Vol');
4708:
4709: --
4710: -- Debug Statements

Line 4707: WSH_UTIL_CORE.Default_Handler('WSH_PO_CMG_PVT.Calculate_Wt_Vol');

4703: END IF;
4704: --
4705: WHEN OTHERS THEN
4706: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4707: WSH_UTIL_CORE.Default_Handler('WSH_PO_CMG_PVT.Calculate_Wt_Vol');
4708:
4709: --
4710: -- Debug Statements
4711: --