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

Line 29: l_del_rows wsh_util_core.id_tab_type;

25: IS
26:
27: --pragma AUTONOMOUS_TRANSACTION;
28:
29: l_del_rows wsh_util_core.id_tab_type;
30: l_planned_flag varchar2(1);
31:
32: wsh_plan_error EXCEPTION;
33: wsh_unplan_error EXCEPTION;

Line 60: l_return_status :=wsh_util_core.g_ret_sts_success;

56: wsh_debug_sv.log(l_module_name, 'p_action_code',p_action_code);
57: wsh_debug_sv.log(l_module_name, 'p_document_type',p_document_type);
58: END IF;
59:
60: l_return_status :=wsh_util_core.g_ret_sts_success;
61:
62: -- It unlocks the delivery and sets it to 'OP' status if p_action_code is null
63: -- Plan and Unplan APIs do not recognize the new statuses, therefore we have
64: -- to call them only after the delivery status is set to 'OP'

Line 81: IF ( l_return_status not in (wsh_util_core.g_ret_sts_success,wsh_util_core.g_ret_sts_warning) ) THEN

77: IF l_debug_on THEN
78: wsh_debug_sv.log (l_module_name,'Unplan->x_return_status: ',l_return_status);
79: END IF;
80:
81: IF ( l_return_status not in (wsh_util_core.g_ret_sts_success,wsh_util_core.g_ret_sts_warning) ) THEN
82: raise wsh_unplan_error;
83: ELSE
84: IF (l_return_status = wsh_util_core.g_ret_sts_warning) THEN
85: WSH_DELIVERY_VALIDATIONS.check_smc(p_delivery_id => p_delivery_id,

Line 84: IF (l_return_status = wsh_util_core.g_ret_sts_warning) THEN

80:
81: IF ( l_return_status not in (wsh_util_core.g_ret_sts_success,wsh_util_core.g_ret_sts_warning) ) THEN
82: raise wsh_unplan_error;
83: ELSE
84: IF (l_return_status = wsh_util_core.g_ret_sts_warning) THEN
85: WSH_DELIVERY_VALIDATIONS.check_smc(p_delivery_id => p_delivery_id,
86: x_valid_flag => l_valid_flag,
87: x_return_status => l_return_status);
88: IF l_debug_on THEN

Line 92: IF (l_return_status <> wsh_util_core.g_ret_sts_success) THEN

88: IF l_debug_on THEN
89: wsh_debug_sv.log (l_module_name,'check_smc->x_return_status: ',l_return_status);
90: END IF;
91:
92: IF (l_return_status <> wsh_util_core.g_ret_sts_success) THEN
93: raise wsh_plan_error;
94: ELSE
95: l_warning_count:=l_warning_count + 1;
96: END IF;

Line 118: IF ( l_return_status not in (wsh_util_core.g_ret_sts_success,wsh_util_core.g_ret_sts_warning) ) THEN

114: IF l_debug_on THEN
115: wsh_debug_sv.log (l_module_name,'plan->x_return_status: ',l_return_status);
116: END IF;
117:
118: IF ( l_return_status not in (wsh_util_core.g_ret_sts_success,wsh_util_core.g_ret_sts_warning) ) THEN
119: raise wsh_plan_error;
120: ELSE
121: IF (l_return_status = wsh_util_core.g_ret_sts_warning) THEN
122: WSH_DELIVERY_VALIDATIONS.check_smc(p_delivery_id => p_delivery_id,

Line 121: IF (l_return_status = wsh_util_core.g_ret_sts_warning) THEN

117:
118: IF ( l_return_status not in (wsh_util_core.g_ret_sts_success,wsh_util_core.g_ret_sts_warning) ) THEN
119: raise wsh_plan_error;
120: ELSE
121: IF (l_return_status = wsh_util_core.g_ret_sts_warning) THEN
122: WSH_DELIVERY_VALIDATIONS.check_smc(p_delivery_id => p_delivery_id,
123: x_valid_flag => l_valid_flag,
124: x_return_status => l_return_status);
125: IF l_debug_on THEN

Line 129: IF (l_return_status <> wsh_util_core.g_ret_sts_success) THEN

125: IF l_debug_on THEN
126: wsh_debug_sv.log (l_module_name,'check_smc->x_return_status: ',l_return_status);
127: END IF;
128:
129: IF (l_return_status <> wsh_util_core.g_ret_sts_success) THEN
130: raise wsh_plan_error;
131: ELSE
132: l_warning_count:=l_warning_count + 1;
133: END IF;

Line 163: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING ;

159: wsh_debug_sv.log (l_module_name,'l_return_status: ',l_return_status);
160: END IF;
161:
162: IF (l_warning_count > 0 ) THEN
163: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING ;
164: ELSE
165: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
166: END IF;
167:

Line 165: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

161:
162: IF (l_warning_count > 0 ) THEN
163: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING ;
164: ELSE
165: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
166: END IF;
167:
168: IF l_debug_on THEN
169: wsh_debug_sv.pop (l_module_name);

Line 187: x_return_status := wsh_util_core.g_ret_sts_error;

183: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_unplan_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
184: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_unplan_error');
185: END IF;
186: WHEN wsh_invalid_doc_type THEN
187: x_return_status := wsh_util_core.g_ret_sts_error;
188: IF l_debug_on THEN
189: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_doc_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
190: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_doc_type');
191: END IF;

Line 193: x_return_status := wsh_util_core.g_ret_sts_error;

189: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_doc_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
190: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_doc_type');
191: END IF;
192: WHEN wsh_invalid_action_type THEN
193: x_return_status := wsh_util_core.g_ret_sts_error;
194: IF l_debug_on THEN
195: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_action_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
196: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_action_type');
197: END IF;

Line 199: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

195: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_action_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
196: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_action_type');
197: END IF;
198: WHEN others THEN
199: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
200: IF l_debug_on THEN
201: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
202: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
203: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 365: x_return_status := wsh_util_core.g_ret_sts_success;

361: END IF;
362: ELSE
363: raise wsh_invalid_action_code;
364: END IF;
365: x_return_status := wsh_util_core.g_ret_sts_success;
366:
367: IF l_debug_on THEN
368: wsh_debug_sv.pop (l_module_name);
369: END IF;

Line 372: x_return_status := wsh_util_core.g_ret_sts_error;

368: wsh_debug_sv.pop (l_module_name);
369: END IF;
370: EXCEPTION
371: WHEN wsh_del_not_found THEN
372: x_return_status := wsh_util_core.g_ret_sts_error;
373: FND_MESSAGE.Set_Name('WSH', 'WSH_DEL_NOT_FOUND');
374: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
375: IF l_debug_on THEN
376: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_del_not_found exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 374: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);

370: EXCEPTION
371: WHEN wsh_del_not_found THEN
372: x_return_status := wsh_util_core.g_ret_sts_error;
373: FND_MESSAGE.Set_Name('WSH', 'WSH_DEL_NOT_FOUND');
374: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
375: IF l_debug_on THEN
376: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_del_not_found exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
377: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_del_not_found');
378: END IF;

Line 381: x_return_status := wsh_util_core.g_ret_sts_error;

377: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_del_not_found');
378: END IF;
379: RETURN FALSE;
380: WHEN wsh_invalid_action_code THEN
381: x_return_status := wsh_util_core.g_ret_sts_error;
382: IF l_debug_on THEN
383: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_action_code exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
384: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_action_code');
385: END IF;

Line 388: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

384: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_action_code');
385: END IF;
386: RETURN FALSE;
387: WHEN others THEN
388: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
389: IF l_debug_on THEN
390: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
391: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
392: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 430: l_del_rows wsh_util_core.id_tab_type;

426: l_organization_id NUMBER;
427: l_delivery_detail_id NUMBER;
428: l_wh_type VARCHAR2(30);
429:
430: l_del_rows wsh_util_core.id_tab_type;
431: l_status_code_tab wsh_util_core.id_tab_type;
432: l_planned_flag_tab wsh_util_core.id_tab_type;
433:
434: l_char_temp VARCHAR2(1);

Line 431: l_status_code_tab wsh_util_core.id_tab_type;

427: l_delivery_detail_id NUMBER;
428: l_wh_type VARCHAR2(30);
429:
430: l_del_rows wsh_util_core.id_tab_type;
431: l_status_code_tab wsh_util_core.id_tab_type;
432: l_planned_flag_tab wsh_util_core.id_tab_type;
433:
434: l_char_temp VARCHAR2(1);
435: l_return_status VARCHAR2(1);

Line 432: l_planned_flag_tab wsh_util_core.id_tab_type;

428: l_wh_type VARCHAR2(30);
429:
430: l_del_rows wsh_util_core.id_tab_type;
431: l_status_code_tab wsh_util_core.id_tab_type;
432: l_planned_flag_tab wsh_util_core.id_tab_type;
433:
434: l_char_temp VARCHAR2(1);
435: l_return_status VARCHAR2(1);
436: l_source_line_id NUMBER;

Line 459: l_return_status := wsh_util_core.g_ret_sts_success;

455: wsh_debug_sv.push(l_module_name, 'Check_Updates_Allowed');
456: wsh_debug_sv.log (l_module_name, 'p_source_code',p_source_code);
457: END IF;
458:
459: l_return_status := wsh_util_core.g_ret_sts_success;
460:
461: IF not WSH_DELIVERY_UTIL.G_INBOUND_FLAG THEN
462:
463: FOR l_counter IN p_changed_attributes.FIRST ..p_changed_attributes.LAST LOOP

Line 494: IF ( l_return_status <> wsh_util_core.g_ret_sts_success ) THEN

490: IF l_debug_on THEN
491: wsh_debug_sv.log(l_module_name,'l_wh_type,l_return_status',l_wh_type||','||l_return_status);
492: END IF;
493:
494: IF ( l_return_status <> wsh_util_core.g_ret_sts_success ) THEN
495: raise wsh_invalid_org;
496: END IF;
497: -- if the warehouse is either a Third Party Warehouse or a Carrier Manifesting System.
498: IF ( nvl(l_wh_type, FND_API.G_MISS_CHAR) IN ( 'TPW', 'CMS' )) THEN

Line 513: IF l_return_status = wsh_util_core.g_ret_sts_success THEN

509: END IF;
510: END IF;
511: END LOOP;
512: END IF;
513: IF l_return_status = wsh_util_core.g_ret_sts_success THEN
514: x_update_allowed := 'Y';
515: END IF;
516: x_return_status := l_return_status;
517: IF l_debug_on THEN

Line 522: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

518: wsh_debug_sv.pop (l_module_name);
519: END IF;
520: EXCEPTION
521: WHEN wsh_update_not_allowed THEN
522: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
523: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_NOT_ALLOWED');
524: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
525: x_update_allowed := 'N';
526: IF l_debug_on THEN

Line 524: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

520: EXCEPTION
521: WHEN wsh_update_not_allowed THEN
522: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
523: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_NOT_ALLOWED');
524: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
525: x_update_allowed := 'N';
526: IF l_debug_on THEN
527: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_update_not_allowed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
528: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_update_not_allowed');

Line 538: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

534: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_org exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
535: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_org');
536: END IF;
537: WHEN OTHERS THEN
538: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
539: x_update_allowed := 'N';
540: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_DELIVERY_UTIL.Check_Updates_Allowed',l_module_name);
541: IF l_debug_on THEN
542: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,

Line 540: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_DELIVERY_UTIL.Check_Updates_Allowed',l_module_name);

536: END IF;
537: WHEN OTHERS THEN
538: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
539: x_update_allowed := 'N';
540: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_DELIVERY_UTIL.Check_Updates_Allowed',l_module_name);
541: IF l_debug_on THEN
542: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
543: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
544: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 548: PROCEDURE Check_Actions_Allowed(x_entity_ids IN OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,

544: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
545: END IF;
546: END Check_Updates_Allowed;
547:
548: PROCEDURE Check_Actions_Allowed(x_entity_ids IN OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
549: p_entity_name IN VARCHAR2,
550: p_action IN VARCHAR2,
551: p_delivery_id IN NUMBER,
552: x_err_entity_ids OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,

Line 552: x_err_entity_ids OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,

548: PROCEDURE Check_Actions_Allowed(x_entity_ids IN OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
549: p_entity_name IN VARCHAR2,
550: p_action IN VARCHAR2,
551: p_delivery_id IN NUMBER,
552: x_err_entity_ids OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
553: x_return_status OUT NOCOPY VARCHAR2
554: )
555: IS
556:

Line 686: l_entity_ids WSH_UTIL_CORE.Id_Tab_Type;

682: and document_direction='I'
683: and action_type = 'A';
684:
685:
686: l_entity_ids WSH_UTIL_CORE.Id_Tab_Type;
687: l_err_entity_ids WSH_UTIL_CORE.Id_Tab_Type;
688:
689: l_organization_id NUMBER;
690: l_delivery_id NUMBER;

Line 687: l_err_entity_ids WSH_UTIL_CORE.Id_Tab_Type;

683: and action_type = 'A';
684:
685:
686: l_entity_ids WSH_UTIL_CORE.Id_Tab_Type;
687: l_err_entity_ids WSH_UTIL_CORE.Id_Tab_Type;
688:
689: l_organization_id NUMBER;
690: l_delivery_id NUMBER;
691: l_delivery_detail_id NUMBER;

Line 1238: l_return_status := wsh_util_core.g_ret_sts_success;

1234: END LOOP;
1235: END IF;
1236:
1237: IF ( l_entity_ids.COUNT = x_entity_ids.COUNT ) THEN
1238: l_return_status := wsh_util_core.g_ret_sts_success;
1239: ELSIF ( l_entity_ids.COUNT = 0 ) THEN
1240: raise wsh_delivery_locked;
1241: ELSIF ( l_entity_ids.COUNT < x_entity_ids.COUNT ) THEN
1242: x_entity_ids := l_entity_ids;

Line 1244: l_return_status := wsh_util_core.g_ret_sts_warning;

1240: raise wsh_delivery_locked;
1241: ELSIF ( l_entity_ids.COUNT < x_entity_ids.COUNT ) THEN
1242: x_entity_ids := l_entity_ids;
1243: x_err_entity_ids := l_err_entity_ids;
1244: l_return_status := wsh_util_core.g_ret_sts_warning;
1245: END IF;
1246: x_return_status := l_return_status;
1247: IF l_debug_on THEN
1248: wsh_debug_sv.pop (l_module_name);

Line 1252: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1248: wsh_debug_sv.pop (l_module_name);
1249: END IF;
1250: EXCEPTION
1251: WHEN wsh_delivery_locked THEN
1252: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1253: IF l_debug_on THEN
1254: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_delivery_locked exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1255: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_delivery_locked');
1256: END IF;

Line 1258: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1254: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_delivery_locked exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1255: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_delivery_locked');
1256: END IF;
1257: WHEN others THEN
1258: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1259: IF l_debug_on THEN
1260: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
1261: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1262: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');