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

Line 76: x_return_status := wsh_util_core.g_ret_sts_error;

72:
73: EXCEPTION
74:
75: WHEN wsh_invalid_doc_type THEN
76: x_return_status := wsh_util_core.g_ret_sts_error;
77: IF l_debug_on THEN
78: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_doc_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
79: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_doc_type');
80: END IF;

Line 82: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

78: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_doc_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
79: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_doc_type');
80: END IF;
81: WHEN OTHERS THEN
82: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
83: IF l_debug_on THEN
84: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
85: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
86: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 340: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

336: IF l_debug_on THEN
337: wsh_debug_sv.log(l_module_name, 'check_credit_holds x_return_status',x_return_status);
338: END IF;
339:
340: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
341: raise wsh_details_credit_hold;
342: END IF;
343:
344: END LOOP;

Line 368: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

364:
365: IF l_debug_on THEN
366: wsh_debug_sv.log(l_module_name, 'Del_Assigned_To_Trip x_return_status',x_return_status);
367: END IF;
368: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
369: IF l_debug_on THEN
370: wsh_debug_sv.pop(l_module_name, 'RETURN');
371: END IF;
372: RETURN;

Line 420: IF ( x_return_status not in (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) ) THEN

416: IF l_debug_on THEN
417: wsh_debug_sv.log (l_module_name,'Update_Dlvy_Status-> x_return_status: ',x_return_status);
418: END IF;
419:
420: IF ( x_return_status not in (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) ) THEN
421: raise wsh_insert_history_error;
422: ELSE
423: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
424: l_warning_count := l_warning_count + 1;

Line 423: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

419:
420: IF ( x_return_status not in (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) ) THEN
421: raise wsh_insert_history_error;
422: ELSE
423: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
424: l_warning_count := l_warning_count + 1;
425: END IF;
426: END IF;
427: WSH_EXTERNAL_INTERFACE_SV.RAISE_EVENT(l_txns_history_rec,

Line 433: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN

429: x_return_status);
430: IF l_debug_on THEN
431: wsh_debug_sv.log (l_module_name,'RAISE_EVENT x_return_status: ',x_return_status);
432: END IF;
433: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
434: raise wsh_raise_event_error;
435: END IF;
436: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
437: ELSE

Line 436: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

432: END IF;
433: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
434: raise wsh_raise_event_error;
435: END IF;
436: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
437: ELSE
438: raise wsh_delivery_locked;
439: END IF;
440:

Line 485: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN

481: x_return_status);
482: IF l_debug_on THEN
483: wsh_debug_sv.log (l_module_name,'RAISE_EVENT x_return_status: ',x_return_status);
484: END IF;
485: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
486: raise wsh_raise_event_error;
487: END IF;
488: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
489:

Line 488: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

484: END IF;
485: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
486: raise wsh_raise_event_error;
487: END IF;
488: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
489:
490: --bmso l_txns_history_rec.transaction_status := 'ST';
491: ELSE --}{
492: raise wsh_cancel_disallowed;

Line 498: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

494:
495: END IF; --}
496:
497: IF (l_warning_count > 0 ) THEN
498: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
499: END IF;
500:
501: IF l_debug_on THEN
502: wsh_debug_sv.pop (l_module_name);

Line 506: x_return_status := wsh_util_core.g_ret_sts_error;

502: wsh_debug_sv.pop (l_module_name);
503: END IF;
504: EXCEPTION
505: WHEN wsh_incorrect_org THEN
506: x_return_status := wsh_util_core.g_ret_sts_error;
507: FND_MESSAGE.Set_Name('WSH', 'WSH_INCORRECT_ORG');
508: FND_MESSAGE.Set_Token('ORG_CODE', l_org_code);
509: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
510: IF l_debug_on THEN

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

505: WHEN wsh_incorrect_org THEN
506: x_return_status := wsh_util_core.g_ret_sts_error;
507: FND_MESSAGE.Set_Name('WSH', 'WSH_INCORRECT_ORG');
508: FND_MESSAGE.Set_Token('ORG_CODE', l_org_code);
509: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
510: IF l_debug_on THEN
511: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_incorrect_org exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
512: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_incorrect_org');
513: END IF;

Line 515: x_return_status := wsh_util_core.g_ret_sts_error;

511: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_incorrect_org exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
512: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_incorrect_org');
513: END IF;
514: WHEN wsh_invalid_delivery THEN
515: x_return_status := wsh_util_core.g_ret_sts_error;
516: FND_MESSAGE.Set_Name('WSH', 'WSH_INCOMPLETE_DELIVERY');
517: FND_MESSAGE.Set_Token('DEL_NAME', l_entity_number);
518: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
519: IF l_debug_on THEN

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

514: WHEN wsh_invalid_delivery THEN
515: x_return_status := wsh_util_core.g_ret_sts_error;
516: FND_MESSAGE.Set_Name('WSH', 'WSH_INCOMPLETE_DELIVERY');
517: FND_MESSAGE.Set_Token('DEL_NAME', l_entity_number);
518: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
519: IF l_debug_on THEN
520: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_delivery exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
521: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_delivery');
522: END IF;

Line 524: x_return_status := wsh_util_core.g_ret_sts_error;

520: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_delivery exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
521: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_delivery');
522: END IF;
523: WHEN wsh_details_not_packed THEN
524: x_return_status := wsh_util_core.g_ret_sts_error;
525: FND_MESSAGE.Set_Name('WSH', 'WSH_DEL_PACK_ITEMS_UNPACKED');
526: FND_MESSAGE.Set_Token('DEL_NAME', l_entity_number);
527: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
528: IF l_debug_on THEN

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

523: WHEN wsh_details_not_packed THEN
524: x_return_status := wsh_util_core.g_ret_sts_error;
525: FND_MESSAGE.Set_Name('WSH', 'WSH_DEL_PACK_ITEMS_UNPACKED');
526: FND_MESSAGE.Set_Token('DEL_NAME', l_entity_number);
527: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
528: IF l_debug_on THEN
529: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_details_not_packed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
530: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_details_not_packed');
531: END IF;

Line 533: x_return_status := wsh_util_core.g_ret_sts_error;

529: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_details_not_packed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
530: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_details_not_packed');
531: END IF;
532: WHEN wsh_tpw_del_det_rel_stat THEN
533: x_return_status := wsh_util_core.g_ret_sts_error;
534: FND_MESSAGE.Set_Name('WSH', 'WSH_TPW_DEL_DET_REL_STAT');
535: FND_MESSAGE.Set_Token('DEL_NAME', l_entity_number);
536: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
537: IF l_debug_on THEN

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

532: WHEN wsh_tpw_del_det_rel_stat THEN
533: x_return_status := wsh_util_core.g_ret_sts_error;
534: FND_MESSAGE.Set_Name('WSH', 'WSH_TPW_DEL_DET_REL_STAT');
535: FND_MESSAGE.Set_Token('DEL_NAME', l_entity_number);
536: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
537: IF l_debug_on THEN
538: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_tpw_del_det_rel_stat exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
539: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_tpw_del_det_rel_stat');
540: END IF;

Line 542: x_return_status := wsh_util_core.g_ret_sts_error;

538: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_tpw_del_det_rel_stat exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
539: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_tpw_del_det_rel_stat');
540: END IF;
541: WHEN wsh_cms_del_det_rel_stat THEN
542: x_return_status := wsh_util_core.g_ret_sts_error;
543: FND_MESSAGE.Set_Name('WSH', 'WSH_CMS_DEL_DET_REL_STAT');
544: FND_MESSAGE.Set_Token('DEL_NAME', l_entity_number);
545: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
546: IF l_debug_on THEN

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

541: WHEN wsh_cms_del_det_rel_stat THEN
542: x_return_status := wsh_util_core.g_ret_sts_error;
543: FND_MESSAGE.Set_Name('WSH', 'WSH_CMS_DEL_DET_REL_STAT');
544: FND_MESSAGE.Set_Token('DEL_NAME', l_entity_number);
545: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
546: IF l_debug_on THEN
547: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_cms_del_det_rel_stat exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
548: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_cms_del_det_rel_stat');
549: END IF;

Line 557: x_return_status := wsh_util_core.g_ret_sts_error;

553: NULL,
554: p_document_type,
555: x_return_status);
556: --commit;
557: x_return_status := wsh_util_core.g_ret_sts_error;
558: ELSIF ( p_action_type = 'D' ) THEN
559: WSH_DELIVERY_UTIL.Update_Dlvy_Status (p_entity_id,
560: 'A',
561: p_document_type,

Line 564: x_return_status := wsh_util_core.g_ret_sts_error;

560: 'A',
561: p_document_type,
562: x_return_status);
563: --commit;
564: x_return_status := wsh_util_core.g_ret_sts_error;
565: END IF;
566: IF l_debug_on THEN
567: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_insert_history_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
568: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_insert_history_error');

Line 577: x_return_status := wsh_util_core.g_ret_sts_error;

573: NULL,
574: p_document_type,
575: x_return_status);
576: --commit;
577: x_return_status := wsh_util_core.g_ret_sts_error;
578: ELSIF ( p_action_type = 'D' ) THEN
579: WSH_DELIVERY_UTIL.Update_Dlvy_Status (p_entity_id,
580: 'A',
581: p_document_type,

Line 584: x_return_status := wsh_util_core.g_ret_sts_error;

580: 'A',
581: p_document_type,
582: x_return_status);
583: --commit;
584: x_return_status := wsh_util_core.g_ret_sts_error;
585: ELSE
586: x_return_status := wsh_util_core.g_ret_sts_error;
587: END IF;
588: IF l_debug_on THEN

Line 586: x_return_status := wsh_util_core.g_ret_sts_error;

582: x_return_status);
583: --commit;
584: x_return_status := wsh_util_core.g_ret_sts_error;
585: ELSE
586: x_return_status := wsh_util_core.g_ret_sts_error;
587: END IF;
588: IF l_debug_on THEN
589: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_raise_event_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
590: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_raise_event_error');

Line 593: x_return_status := wsh_util_core.g_ret_sts_error;

589: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_raise_event_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
590: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_raise_event_error');
591: END IF;
592: WHEN wsh_delivery_locked THEN
593: x_return_status := wsh_util_core.g_ret_sts_error;
594: FND_MESSAGE.Set_Name('WSH', 'WSH_DELIVERY_LOCKED');
595: FND_MESSAGE.Set_Token('DEL_NAME', l_entity_number);
596: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
597: IF l_debug_on THEN

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

592: WHEN wsh_delivery_locked THEN
593: x_return_status := wsh_util_core.g_ret_sts_error;
594: FND_MESSAGE.Set_Name('WSH', 'WSH_DELIVERY_LOCKED');
595: FND_MESSAGE.Set_Token('DEL_NAME', l_entity_number);
596: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
597: IF l_debug_on THEN
598: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_delivery_locked exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
599: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_delivery_locked');
600: END IF;

Line 602: x_return_status := wsh_util_core.g_ret_sts_error;

598: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_delivery_locked exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
599: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_delivery_locked');
600: END IF;
601: WHEN wsh_cancel_disallowed THEN
602: x_return_status := wsh_util_core.g_ret_sts_error;
603: FND_MESSAGE.Set_Name('WSH', 'WSH_CANCEL_DISALLOWED');
604: FND_MESSAGE.Set_Token('DEL_NAME', l_entity_number);
605: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
606: IF l_debug_on THEN

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

601: WHEN wsh_cancel_disallowed THEN
602: x_return_status := wsh_util_core.g_ret_sts_error;
603: FND_MESSAGE.Set_Name('WSH', 'WSH_CANCEL_DISALLOWED');
604: FND_MESSAGE.Set_Token('DEL_NAME', l_entity_number);
605: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
606: IF l_debug_on THEN
607: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_cancel_disallowed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
608: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_cancel_disallowed');
609: END IF;

Line 613: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

609: END IF;
610: WHEN wsh_del_assign_to_trip THEN
611: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_OUTBOUND_FAILED_TRIP');
612: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_entity_id));
613: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
614: wsh_util_core.add_message(x_return_status,l_module_name);
615: IF l_debug_on THEN
616: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_del_assign_to_trip exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
617: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_del_assign_to_trip');

Line 614: wsh_util_core.add_message(x_return_status,l_module_name);

610: WHEN wsh_del_assign_to_trip THEN
611: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_OUTBOUND_FAILED_TRIP');
612: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_entity_id));
613: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
614: wsh_util_core.add_message(x_return_status,l_module_name);
615: IF l_debug_on THEN
616: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_del_assign_to_trip exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
617: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_del_assign_to_trip');
618: END IF;

Line 622: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

618: END IF;
619: WHEN wsh_details_exceptions THEN
620: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_DET');
621: FND_MESSAGE.SET_TOKEN('DEL_DET_ID', to_char(l_delivery_detail_id));
622: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
623: wsh_util_core.add_message(x_return_status,l_module_name);
624: IF l_debug_on THEN
625: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_details_exceptions exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
626: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_details_exceptions');

Line 623: wsh_util_core.add_message(x_return_status,l_module_name);

619: WHEN wsh_details_exceptions THEN
620: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_DET');
621: FND_MESSAGE.SET_TOKEN('DEL_DET_ID', to_char(l_delivery_detail_id));
622: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
623: wsh_util_core.add_message(x_return_status,l_module_name);
624: IF l_debug_on THEN
625: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_details_exceptions exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
626: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_details_exceptions');
627: END IF;

Line 632: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

628: WHEN wsh_details_credit_hold THEN
629: FND_MESSAGE.SET_NAME('WSH','WSH_SR_CREDIT_HOLD_ERR');
630: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_entity_number);
631: FND_MESSAGE.SET_TOKEN('DET_NAME',to_char(l_delivery_detail_id));
632: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
633: wsh_util_core.add_message(x_return_status,l_module_name);
634: IF l_debug_on THEN
635: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_details_credit_hold exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
636: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_details_credit_hold ');

Line 633: wsh_util_core.add_message(x_return_status,l_module_name);

629: FND_MESSAGE.SET_NAME('WSH','WSH_SR_CREDIT_HOLD_ERR');
630: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_entity_number);
631: FND_MESSAGE.SET_TOKEN('DET_NAME',to_char(l_delivery_detail_id));
632: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
633: wsh_util_core.add_message(x_return_status,l_module_name);
634: IF l_debug_on THEN
635: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_details_credit_hold exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
636: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_details_credit_hold ');
637: END IF;

Line 641: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

637: END IF;
638: WHEN wsh_invalid_customer THEN
639: FND_MESSAGE.SET_NAME('WSH','WSH_NO_CUST_DEF_ERROR');
640: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_entity_id));
641: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
642: wsh_util_core.add_message(x_return_status,l_module_name);
643: IF l_debug_on THEN
644: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_customer exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
645: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_customer');

Line 642: wsh_util_core.add_message(x_return_status,l_module_name);

638: WHEN wsh_invalid_customer THEN
639: FND_MESSAGE.SET_NAME('WSH','WSH_NO_CUST_DEF_ERROR');
640: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_entity_id));
641: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
642: wsh_util_core.add_message(x_return_status,l_module_name);
643: IF l_debug_on THEN
644: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_customer exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
645: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_customer');
646: END IF;

Line 648: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

644: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_customer exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
645: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_customer');
646: END IF;
647: WHEN others THEN
648: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
649: IF l_debug_on THEN
650: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
651: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
652: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 710: x_return_status := wsh_util_core.g_ret_sts_success;

706: wsh_debug_sv.log (l_module_name, 'Delivery Name ' , p_delivery_name);
707: wsh_debug_sv.log (l_module_name, 'Event Code ' , l_event_code);
708: END IF;
709:
710: x_return_status := wsh_util_core.g_ret_sts_success;
711: l_event_code := UPPER(SUBSTRB (p_event_name, INSTRB(p_event_name, '.', -1) + 1));
712: IF l_event_code IN ('SPWF','SSAI','SSAO','CONFIRM') THEN
713: -- R12.1.1 STANDALONE PROJECT
714: -- LSP PROJECT : Consider LSP mode also.

Line 777: x_return_status := wsh_util_core.g_ret_sts_error;

773: END IF;
774: EXCEPTION
775:
776: WHEN wsh_invalid_event_name THEN
777: x_return_status := wsh_util_core.g_ret_sts_error;
778: IF l_debug_on THEN
779: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_event_name exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
780: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_event_name');
781: END IF;

Line 783: x_return_status := wsh_util_core.g_ret_sts_error;

779: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_event_name exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
780: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_event_name');
781: END IF;
782: WHEN wsh_invalid_delivery_name THEN
783: x_return_status := wsh_util_core.g_ret_sts_error;
784: IF l_debug_on THEN
785: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_delivery_name exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
786: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_delivery_name');
787: END IF;

Line 789: x_return_status := wsh_util_core.g_ret_sts_error;

785: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_delivery_name exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
786: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_delivery_name');
787: END IF;
788: WHEN wsh_invalid_batch_name THEN--Fulfillment Batch XML Project
789: x_return_status := wsh_util_core.g_ret_sts_error;
790: IF l_debug_on THEN
791: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_batch_name exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
792: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_batch_name ');
793: END IF;

Line 795: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

791: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_batch_name exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
792: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_batch_name ');
793: END IF;
794: WHEN others THEN
795: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
796: IF l_debug_on THEN
797: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
798: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
799: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 867: IF ( l_return_status not in (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) ) THEN

863: IF l_debug_on THEN
864: wsh_debug_sv.log(l_module_name, 'l_return_status',l_return_status);
865: END IF;
866:
867: IF ( l_return_status not in (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) ) THEN
868: raise wsh_unlock_error;
869: ELSE
870: resultout := 'COMPLETE:SUCCESS';
871: IF l_debug_on THEN

Line 1085: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN

1081: );
1082: IF l_debug_on THEN
1083: wsh_debug_sv.log(l_module_name, 'Get_Txns_History l_return_status ',l_return_status);
1084: END IF;
1085: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
1086: raise wsh_process_inbound;
1087: END IF;
1088: --k proj
1089: --Modified if condition for Fulfillment Batch XML Project

Line 1119: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1115: wsh_debug_sv.log(l_module_name, 'l_cancellation_in_progress',
1116: l_cancellation_in_progress);
1117: END IF;
1118:
1119: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1120: RAISE fnd_api.g_exc_error;
1121: END IF;
1122:
1123: IF l_cancellation_in_progress THEN

Line 1139: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN

1135: IF l_debug_on THEN
1136: wsh_debug_sv.log(l_module_name, 'Process_Inbound l_return_status ',l_return_status);
1137: END IF;
1138:
1139: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
1140: --Fulfillment Batch XML Project
1141: IF l_txns_history_rec.event_name = 'oracle.apps.wsh.batch.bsai' AND l_txns_history_rec.item_type='WSHBATI' THEN
1142: RAISE wsh_batch_process_inbound;
1143: ELSE

Line 1162: wsh_util_core.api_post_call(

1158: WSH_EXTERNAL_INTERFACE_SV.Raise_Event (
1159: l_cancel_history_rec,
1160: '99',
1161: l_Return_Status );
1162: wsh_util_core.api_post_call(
1163: p_return_status => l_return_status,
1164: x_num_warnings => l_num_warn,
1165: x_num_errors => l_num_err);
1166:

Line 1282: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN

1278: );
1279: IF l_debug_on THEN
1280: wsh_debug_sv.log(l_module_name, 'Get_Txns_History l_return_status ',l_return_status);
1281: END IF;
1282: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
1283: raise wsh_process_inbound;
1284: END IF;
1285:
1286: WSH_PROCESS_INTERFACED_PKG.Process_Inbound(l_txns_history_rec,

Line 1292: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN

1288: IF l_debug_on THEN
1289: wsh_debug_sv.log(l_module_name, 'Process_Inbound l_return_status ',l_return_status);
1290: END IF;
1291:
1292: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
1293: raise wsh_process_inbound;
1294: ELSE
1295: resultout := 'COMPLETE:SUCCESS';
1296: IF l_debug_on THEN

Line 1377: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN

1373: IF l_debug_on THEN
1374: wsh_debug_sv.log(l_module_name, 'Update_Txn_History l_return_status ',l_return_status);
1375: END IF;
1376:
1377: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
1378: raise wsh_update_history;
1379: ELSE
1380: resultout := 'COMPLETE:SUCCESS';
1381: IF l_debug_on THEN

Line 1452: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN

1448: );
1449: IF l_debug_on THEN
1450: wsh_debug_sv.log(l_module_name, 'Update_Txn_History l_return_status ',l_return_status);
1451: END IF;
1452: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
1453: raise wsh_update_history;
1454: ELSE
1455: resultout := 'COMPLETE:SUCCESS';
1456: IF l_debug_on THEN

Line 1538: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN

1534: );
1535: IF l_debug_on THEN
1536: wsh_debug_sv.log(l_module_name, 'Update_Txn_History l_return_status ',l_return_status);
1537: END IF;
1538: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
1539: raise wsh_update_history;
1540: ELSE
1541: resultout := 'COMPLETE:SUCCESS';
1542: IF l_debug_on THEN

Line 1634: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN

1630: wsh_debug_sv.log(l_module_name, 'Get_Txns_History x_return_status',x_return_status);
1631: END IF;
1632:
1633: l_txns_history_rec.transaction_status := p_transaction_status;
1634: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
1635: raise wsh_update_history;
1636: END IF;
1637:
1638: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History ( l_txns_history_rec,

Line 1645: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN

1641: IF l_debug_on THEN
1642: wsh_debug_sv.log(l_module_name, 'Create_Update_Txns_History x_return_status',x_return_status);
1643: END IF;
1644:
1645: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
1646: raise wsh_update_history;
1647: ELSE
1648: IF p_item_type = 'WSHBATO' THEN --Fulfillment Batch XML Project
1649: UPDATE wsh_shipment_batches

Line 1662: x_return_status := wsh_util_core.g_ret_sts_error;

1658: wsh_debug_sv.pop (l_module_name);
1659: END IF;
1660: EXCEPTION
1661: WHEN wsh_update_history THEN
1662: x_return_status := wsh_util_core.g_ret_sts_error;
1663: IF l_debug_on THEN
1664: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_update_history exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1665: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_update_history');
1666: END IF;

Line 1668: x_return_status := wsh_util_core.g_ret_sts_error;

1664: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_update_history exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1665: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_update_history');
1666: END IF;
1667: WHEN OTHERS THEN
1668: x_return_status := wsh_util_core.g_ret_sts_error;
1669: IF l_debug_on THEN
1670: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
1671: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1672: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1825: wsh_util_core.default_handler('WSH_TRANSACTIONS_UTIL.branch_cms_tpw_flow');

1821:
1822: EXCEPTION
1823:
1824: WHEN OTHERS THEN
1825: wsh_util_core.default_handler('WSH_TRANSACTIONS_UTIL.branch_cms_tpw_flow');
1826: IF l_debug_on THEN
1827: WSH_DEBUG_SV.logmsg(l_module_name,
1828: 'Unexpected error has occured. Oracle error message is '||
1829: substr(SQLERRM,1,200), WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1908: WSH_UTIL_CORE.add_message (wsh_util_core.g_ret_sts_error,l_module_name);

1904: IF l_debug_on THEN
1905: wsh_debug_sv.logmsg(l_module_name, 'ERROR Invalid delivery');
1906: END IF;
1907: FND_MESSAGE.Set_Name('WSH', 'WSH_DEL_NOT_FOUND');
1908: WSH_UTIL_CORE.add_message (wsh_util_core.g_ret_sts_error,l_module_name);
1909: CLOSE c_del_status;
1910: RAISE fnd_api.g_exc_error;
1911: END IF;
1912: IF l_debug_on THEN

Line 1964: x_return_status := wsh_util_core.g_ret_sts_success;

1960:
1961: END IF; --}
1962:
1963:
1964: x_return_status := wsh_util_core.g_ret_sts_success;
1965:
1966: IF l_debug_on THEN
1967: wsh_debug_sv.log(l_module_name, 'x_cancellation_in_progress',
1968: x_cancellation_in_progress);

Line 1976: x_return_status := wsh_util_core.g_ret_sts_success;

1972:
1973: EXCEPTION
1974:
1975: WHEN e_success THEN
1976: x_return_status := wsh_util_core.g_ret_sts_success;
1977: --
1978: IF l_debug_on THEN
1979: wsh_debug_sv.log(l_module_name, 'x_cancellation_in_progress',
1980: x_cancellation_in_progress);

Line 1992: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

1988: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
1989: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
1990: END IF;
1991: WHEN OTHERS THEN
1992: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1993: wsh_util_core.default_handler('WSH_TRANSACTIONS_UTIL.check_cancellation_inprogress',l_module_name);
1994: IF l_debug_on THEN
1995: WSH_DEBUG_SV.logmsg(l_module_name,
1996: 'Unexpected error has occured. Oracle error message is '||

Line 1993: wsh_util_core.default_handler('WSH_TRANSACTIONS_UTIL.check_cancellation_inprogress',l_module_name);

1989: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
1990: END IF;
1991: WHEN OTHERS THEN
1992: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1993: wsh_util_core.default_handler('WSH_TRANSACTIONS_UTIL.check_cancellation_inprogress',l_module_name);
1994: IF l_debug_on THEN
1995: WSH_DEBUG_SV.logmsg(l_module_name,
1996: 'Unexpected error has occured. Oracle error message is '||
1997: substr(SQLERRM,1,200), WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2111: wsh_util_core.api_post_call(

2107: l_cancellation_in_progress,
2108: x_return_status => l_return_status
2109: );
2110:
2111: wsh_util_core.api_post_call(
2112: p_return_status => l_return_status,
2113: x_num_warnings => l_num_warn,
2114: x_num_errors => l_num_err);
2115:

Line 2189: wsh_util_core.default_handler('WSH_TRANSACTIONS_UTIL.check_cancellation_wf');

2185:
2186: RAISE;
2187: WHEN OTHERS THEN
2188: resultout := 'COMPLETE:FAILURE';
2189: wsh_util_core.default_handler('WSH_TRANSACTIONS_UTIL.check_cancellation_wf');
2190: IF l_debug_on THEN
2191: WSH_DEBUG_SV.logmsg(l_module_name,
2192: 'Unexpected error has occured. Oracle error message is '||
2193: substr(SQLERRM,1,200), WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2403: WSH_UTIL_CORE.add_message (wsh_util_core.g_ret_sts_error,l_module_name);

2399: OPEN c_get_del_status (l_entity_number);
2400: FETCH c_get_del_status INTO l_status;
2401: IF c_get_del_status%NOTFOUND THEN
2402: FND_MESSAGE.Set_Name('WSH', 'WSH_DEL_NOT_FOUND');
2403: WSH_UTIL_CORE.add_message (wsh_util_core.g_ret_sts_error,l_module_name);
2404: CLOSE c_get_del_status;
2405: RAISE e_send_false;
2406: END IF;
2407: CLOSE c_get_del_status;

Line 2485: IF (l_Return_Status NOT IN (WSH_UTIL_CORE.g_ret_sts_success,

2481: p_delivery_interface_id => l_del_interface_id,
2482: x_return_status => l_Return_Status
2483: ) ;
2484:
2485: IF (l_Return_Status NOT IN (WSH_UTIL_CORE.g_ret_sts_success,
2486: WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
2487: RAISE e_send_false;
2488: END IF;
2489:

Line 2486: WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

2482: x_return_status => l_Return_Status
2483: ) ;
2484:
2485: IF (l_Return_Status NOT IN (WSH_UTIL_CORE.g_ret_sts_success,
2486: WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
2487: RAISE e_send_false;
2488: END IF;
2489:
2490: --Update the status_code for shipment advice record to 'SX'

Line 2513: IF (l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN

2509: IF l_debug_on THEN
2510: wsh_debug_sv.log (l_module_name, 'Return status after Raise_Event ', l_Return_Status);
2511: END IF;
2512:
2513: IF (l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
2514: RAISE e_send_false;
2515: END IF;
2516:
2517:

Line 2571: wsh_util_core.default_handler('WSH_TRANSACTIONS_UTIL.process_cbod_wf');

2567: END IF;
2568:
2569: WHEN OTHERS THEN
2570: resultout := 'COMPLETE:FAILURE';
2571: wsh_util_core.default_handler('WSH_TRANSACTIONS_UTIL.process_cbod_wf');
2572: IF l_debug_on THEN
2573: WSH_DEBUG_SV.logmsg(l_module_name,
2574: 'Unexpected error has occured. Oracle error message is '||
2575: substr(SQLERRM,1,200), WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);