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: open get_key;
714: Fetch get_key into x_event_key;

Line 747: x_return_status := wsh_util_core.g_ret_sts_error;

743: END IF;
744: EXCEPTION
745:
746: WHEN wsh_invalid_event_name THEN
747: x_return_status := wsh_util_core.g_ret_sts_error;
748: IF l_debug_on THEN
749: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_event_name exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
750: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_event_name');
751: END IF;

Line 753: x_return_status := wsh_util_core.g_ret_sts_error;

749: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_event_name exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
750: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_event_name');
751: END IF;
752: WHEN wsh_invalid_delivery_name THEN
753: x_return_status := wsh_util_core.g_ret_sts_error;
754: IF l_debug_on THEN
755: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_delivery_name exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
756: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_delivery_name');
757: END IF;

Line 759: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

755: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_delivery_name exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
756: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_delivery_name');
757: END IF;
758: WHEN others THEN
759: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
760: IF l_debug_on THEN
761: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
762: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
763: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

827: IF l_debug_on THEN
828: wsh_debug_sv.log(l_module_name, 'l_return_status',l_return_status);
829: END IF;
830:
831: IF ( l_return_status not in (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) ) THEN
832: raise wsh_unlock_error;
833: ELSE
834: resultout := 'COMPLETE:SUCCESS';
835: IF l_debug_on THEN

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

1039: );
1040: IF l_debug_on THEN
1041: wsh_debug_sv.log(l_module_name, 'Get_Txns_History l_return_status ',l_return_status);
1042: END IF;
1043: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
1044: raise wsh_process_inbound;
1045: END IF;
1046: --k proj
1047: IF l_document_type = 'SA' AND branch_cms_tpw_flow(p_event_key => item_key)

Line 1076: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1072: wsh_debug_sv.log(l_module_name, 'l_cancellation_in_progress',
1073: l_cancellation_in_progress);
1074: END IF;
1075:
1076: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1077: RAISE fnd_api.g_exc_error;
1078: END IF;
1079:
1080: IF l_cancellation_in_progress THEN

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

1092: IF l_debug_on THEN
1093: wsh_debug_sv.log(l_module_name, 'Process_Inbound l_return_status ',l_return_status);
1094: END IF;
1095:
1096: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
1097: raise wsh_process_inbound;
1098: ELSE
1099: -- send a CBOD to close the cancellation workflow instance bmso k proj
1100:

Line 1114: wsh_util_core.api_post_call(

1110: WSH_EXTERNAL_INTERFACE_SV.Raise_Event (
1111: l_cancel_history_rec,
1112: '99',
1113: l_Return_Status );
1114: wsh_util_core.api_post_call(
1115: p_return_status => l_return_status,
1116: x_num_warnings => l_num_warn,
1117: x_num_errors => l_num_err);
1118:

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

1202: IF l_debug_on THEN
1203: wsh_debug_sv.log(l_module_name, 'Update_Txn_History l_return_status ',l_return_status);
1204: END IF;
1205:
1206: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
1207: raise wsh_update_history;
1208: ELSE
1209: resultout := 'COMPLETE:SUCCESS';
1210: IF l_debug_on THEN

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

1277: );
1278: IF l_debug_on THEN
1279: wsh_debug_sv.log(l_module_name, 'Update_Txn_History l_return_status ',l_return_status);
1280: END IF;
1281: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
1282: raise wsh_update_history;
1283: ELSE
1284: resultout := 'COMPLETE:SUCCESS';
1285: IF l_debug_on THEN

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

1368: wsh_debug_sv.log(l_module_name, 'Get_Txns_History x_return_status',x_return_status);
1369: END IF;
1370:
1371: l_txns_history_rec.transaction_status := p_transaction_status;
1372: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
1373: raise wsh_update_history;
1374: END IF;
1375:
1376: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History ( l_txns_history_rec,

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

1379: IF l_debug_on THEN
1380: wsh_debug_sv.log(l_module_name, 'Create_Update_Txns_History x_return_status',x_return_status);
1381: END IF;
1382:
1383: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
1384: raise wsh_update_history;
1385: ELSE
1386: COMMIT;
1387: END IF;

Line 1394: x_return_status := wsh_util_core.g_ret_sts_error;

1390: wsh_debug_sv.pop (l_module_name);
1391: END IF;
1392: EXCEPTION
1393: WHEN wsh_update_history THEN
1394: x_return_status := wsh_util_core.g_ret_sts_error;
1395: IF l_debug_on THEN
1396: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_update_history exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1397: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_update_history');
1398: END IF;

Line 1400: x_return_status := wsh_util_core.g_ret_sts_error;

1396: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_update_history exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1397: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_update_history');
1398: END IF;
1399: WHEN OTHERS THEN
1400: x_return_status := wsh_util_core.g_ret_sts_error;
1401: IF l_debug_on THEN
1402: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
1403: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1404: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

1539:
1540: EXCEPTION
1541:
1542: WHEN OTHERS THEN
1543: wsh_util_core.default_handler('WSH_TRANSACTIONS_UTIL.branch_cms_tpw_flow');
1544: IF l_debug_on THEN
1545: WSH_DEBUG_SV.logmsg(l_module_name,
1546: 'Unexpected error has occured. Oracle error message is '||
1547: substr(SQLERRM,1,200), WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

1622: IF l_debug_on THEN
1623: wsh_debug_sv.logmsg(l_module_name, 'ERROR Invalid delivery');
1624: END IF;
1625: FND_MESSAGE.Set_Name('WSH', 'WSH_DEL_NOT_FOUND');
1626: WSH_UTIL_CORE.add_message (wsh_util_core.g_ret_sts_error,l_module_name);
1627: CLOSE c_del_status;
1628: RAISE fnd_api.g_exc_error;
1629: END IF;
1630: IF l_debug_on THEN

Line 1682: x_return_status := wsh_util_core.g_ret_sts_success;

1678:
1679: END IF; --}
1680:
1681:
1682: x_return_status := wsh_util_core.g_ret_sts_success;
1683:
1684: IF l_debug_on THEN
1685: wsh_debug_sv.log(l_module_name, 'x_cancellation_in_progress',
1686: x_cancellation_in_progress);

Line 1694: x_return_status := wsh_util_core.g_ret_sts_success;

1690:
1691: EXCEPTION
1692:
1693: WHEN e_success THEN
1694: x_return_status := wsh_util_core.g_ret_sts_success;
1695: --
1696: IF l_debug_on THEN
1697: wsh_debug_sv.log(l_module_name, 'x_cancellation_in_progress',
1698: x_cancellation_in_progress);

Line 1710: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

1706: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
1707: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
1708: END IF;
1709: WHEN OTHERS THEN
1710: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1711: wsh_util_core.default_handler('WSH_TRANSACTIONS_UTIL.check_cancellation_inprogress',l_module_name);
1712: IF l_debug_on THEN
1713: WSH_DEBUG_SV.logmsg(l_module_name,
1714: 'Unexpected error has occured. Oracle error message is '||

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

1707: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
1708: END IF;
1709: WHEN OTHERS THEN
1710: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1711: wsh_util_core.default_handler('WSH_TRANSACTIONS_UTIL.check_cancellation_inprogress',l_module_name);
1712: IF l_debug_on THEN
1713: WSH_DEBUG_SV.logmsg(l_module_name,
1714: 'Unexpected error has occured. Oracle error message is '||
1715: substr(SQLERRM,1,200), WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1829: wsh_util_core.api_post_call(

1825: l_cancellation_in_progress,
1826: x_return_status => l_return_status
1827: );
1828:
1829: wsh_util_core.api_post_call(
1830: p_return_status => l_return_status,
1831: x_num_warnings => l_num_warn,
1832: x_num_errors => l_num_err);
1833:

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

1903:
1904: RAISE;
1905: WHEN OTHERS THEN
1906: resultout := 'COMPLETE:FAILURE';
1907: wsh_util_core.default_handler('WSH_TRANSACTIONS_UTIL.check_cancellation_wf');
1908: IF l_debug_on THEN
1909: WSH_DEBUG_SV.logmsg(l_module_name,
1910: 'Unexpected error has occured. Oracle error message is '||
1911: substr(SQLERRM,1,200), WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

2114: OPEN c_get_del_status (l_entity_number);
2115: FETCH c_get_del_status INTO l_status;
2116: IF c_get_del_status%NOTFOUND THEN
2117: FND_MESSAGE.Set_Name('WSH', 'WSH_DEL_NOT_FOUND');
2118: WSH_UTIL_CORE.add_message (wsh_util_core.g_ret_sts_error,l_module_name);
2119: CLOSE c_get_del_status;
2120: RAISE e_send_false;
2121: END IF;
2122: CLOSE c_get_del_status;

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

2196: p_delivery_interface_id => l_del_interface_id,
2197: x_return_status => l_Return_Status
2198: ) ;
2199:
2200: IF (l_Return_Status NOT IN (WSH_UTIL_CORE.g_ret_sts_success,
2201: WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
2202: RAISE e_send_false;
2203: END IF;
2204:

Line 2201: WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

2197: x_return_status => l_Return_Status
2198: ) ;
2199:
2200: IF (l_Return_Status NOT IN (WSH_UTIL_CORE.g_ret_sts_success,
2201: WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
2202: RAISE e_send_false;
2203: END IF;
2204:
2205: --Update the status_code for shipment advice record to 'SX'

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

2224: IF l_debug_on THEN
2225: wsh_debug_sv.log (l_module_name, 'Return status after Raise_Event ', l_Return_Status);
2226: END IF;
2227:
2228: IF (l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
2229: RAISE e_send_false;
2230: END IF;
2231:
2232:

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

2282: END IF;
2283:
2284: WHEN OTHERS THEN
2285: resultout := 'COMPLETE:FAILURE';
2286: wsh_util_core.default_handler('WSH_TRANSACTIONS_UTIL.process_cbod_wf');
2287: IF l_debug_on THEN
2288: WSH_DEBUG_SV.logmsg(l_module_name,
2289: 'Unexpected error has occured. Oracle error message is '||
2290: substr(SQLERRM,1,200), WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);