DBA Data[Home] [Help]

APPS.WSH_ORG_CARRIER_SERVICES_PKG dependencies on WSH_UTIL_CORE

Line 110: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

106: WSH_DEBUG_SV.log(l_module_name,'X_ROWID',X_ROWID);
107: WSH_DEBUG_SV.log(l_module_name,'X_ORG_CARRIER_SERVICE_ID',X_ORG_CARRIER_SERVICE_ID);
108: END IF;
109: --
110: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
111:
112: IF p_org_Carrier_Service_Info.Enabled_Flag = 'N' THEN
113: l_disable_date := sysdate;
114: ELSE

Line 294: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

290: x_return_status => l_return_status
291: );
292:
293: IF (l_return_status <> 'S') THEN
294: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
295: -- RAISE Failed_In_CSM;
296: END IF;
297: IF l_debug_on THEN
298: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

Line 339: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

335: WHERE rowid = x_rowid;
336:
337: IF (SQL%NOTFOUND) THEN
338: RAISE NO_DATA_FOUND;
339: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
340: END IF;
341:
342: L_POSITION := 30;
343: L_PROCEDURE := 'Updating WSH_CARRIER_SHIP_METHODS';

Line 353: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

349: AND SHIP_METHOD_CODE = p_csm_info.ship_method_code;
350:
351: IF (SQL%NOTFOUND) THEN
352: RAISE NO_DATA_FOUND;
353: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
354: END IF;
355:
356: -- Bug 2796816 Start
357: OPEN c_distribution_account(p_carrier_info.p_freight_code,p_org_carrier_service_info.organization_id);

Line 474: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

470: END IF;
471:
472: IF (SQL%NOTFOUND) THEN
473: RAISE NO_DATA_FOUND;
474: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
475: END IF;
476:
477: END IF; -- End Update Allowled
478:

Line 496: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

492: x_position := l_position;
493: x_procedure := l_procedure;
494: x_sqlerr := sqlerrm;
495: x_sql_code := sqlcode;
496: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
497: --
498: IF l_debug_on THEN
499: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
500: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');

Line 509: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

505: x_position := l_position;
506: x_procedure := l_procedure;
507: x_sqlerr := sqlerrm;
508: x_sql_code := sqlcode;
509: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
510: --
511: IF l_debug_on THEN
512: WSH_DEBUG_SV.logmsg(l_module_name,'FAILED_IN_CSM exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
513: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FAILED_IN_CSM');

Line 522: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

518: x_position := l_position;
519: x_procedure := l_procedure;
520: x_sqlerr := sqlerrm;
521: x_sql_code := sqlcode;
522: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
523: --
524: IF l_debug_on THEN
525: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
526: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 569: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

565: --
566: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
567: END IF;
568: --
569: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
570: IF (p_rowid is not null) THEN
571: OPEN C_lock_row;
572: FETCH C_lock_row INTO Recinfo;
573:

Line 577: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

573:
574: IF (C_lock_row%NOTFOUND) THEN
575: CLOSE C_lock_row;
576: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
577: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
578: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
579: --
580: IF l_debug_on THEN
581: WSH_DEBUG_SV.pop(l_module_name,'x_return_status');

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

574: IF (C_lock_row%NOTFOUND) THEN
575: CLOSE C_lock_row;
576: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
577: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
578: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
579: --
580: IF l_debug_on THEN
581: WSH_DEBUG_SV.pop(l_module_name,'x_return_status');
582: END IF;

Line 659: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

655: END IF;
656: --
657: EXCEPTION
658: WHEN others THEN
659: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
660: WSH_UTIL_CORE.Default_Handler('WSH_org_Carrier_ServiceS_PKG.LockOrg_Carrier_Service',l_module_name);
661: --
662: IF l_debug_on THEN
663: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 660: WSH_UTIL_CORE.Default_Handler('WSH_org_Carrier_ServiceS_PKG.LockOrg_Carrier_Service',l_module_name);

656: --
657: EXCEPTION
658: WHEN others THEN
659: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
660: WSH_UTIL_CORE.Default_Handler('WSH_org_Carrier_ServiceS_PKG.LockOrg_Carrier_Service',l_module_name);
661: --
662: IF l_debug_on THEN
663: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
664: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');