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

Line 149: wsh_util_core.default_handler (

145:
146: EXCEPTION
147:
148: WHEN OTHERS THEN
149: wsh_util_core.default_handler (
150: 'WSH_TRIP_STOPS_GRP.Rtrim_delivery', l_module_name);
151: IF l_debug_on THEN
152: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||
153: ' Oracle error message is '|| SQLERRM,

Line 196: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

192: IF l_debug_on THEN
193: wsh_debug_sv.push (l_module_name, 'Validate_Delivery');
194: END IF;
195: --
196: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
197:
198: IF (p_action_code <> 'CREATE') THEN
199:
200: IF (p_delivery_info.delivery_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.name <> FND_API.G_MISS_CHAR) THEN

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

207: p_delivery_info.delivery_id,
208: p_delivery_info.name,
209: x_return_status);
210:
211: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
212: RETURN;
213: END IF;
214:
215: END IF;

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

226: p_delivery_info.organization_id,
227: p_delivery_info.organization_code,
228: x_return_status);
229:
230: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
231: RETURN;
232: END IF;
233: END IF;
234:

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

247: p_delivery_info.loading_order_flag,
248: p_delivery_info.loading_order_desc,
249: x_return_status);
250:
251: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
252: RETURN;
253: END IF;
254: END IF;
255:

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

263: p_delivery_info.initial_pickup_location_id,
264: p_delivery_info.initial_pickup_location_code,
265: x_return_status);
266:
267: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
268: RETURN;
269: END IF;
270: END IF;
271:

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

279: p_delivery_info.ultimate_dropoff_location_id,
280: p_delivery_info.ultimate_dropoff_location_code,
281: x_return_status);
282:
283: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
284: RETURN;
285: END IF;
286: END IF;
287:

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

295: p_delivery_info.intmed_ship_to_location_id,
296: p_delivery_info.intmed_ship_to_location_code,
297: x_return_status);
298:
299: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
300: RETURN;
301: END IF;
302: END IF;
303:

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

311: p_delivery_info.pooled_ship_to_location_id,
312: p_delivery_info.pooled_ship_to_location_code,
313: x_return_status);
314:
315: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
316: RETURN;
317: END IF;
318: END IF;
319:

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

327: p_delivery_info.customer_id,
328: p_delivery_info.customer_number,
329: x_return_status);
330:
331: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
332: RETURN;
333: END IF;
334: END IF;
335:

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

345: p_delivery_info.ship_method_code,
346: p_delivery_info.ship_method_name,
347: x_return_status);
348:
349: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
350: RETURN;
351: END IF;
352: END IF;
353:

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

361: p_delivery_info.freight_terms_code,
362: p_delivery_info.freight_terms_name,
363: x_return_status);
364:
365: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
366: RETURN;
367: END IF;
368: END IF;
369:

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

377: p_delivery_info.fob_code,
378: p_delivery_info.fob_name,
379: x_return_status);
380:
381: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
382: RETURN;
383: END IF;
384: END IF;
385:

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

393: p_delivery_info.fob_location_id,
394: p_delivery_info.fob_location_code,
395: x_return_status);
396:
397: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
398: RETURN;
399: END IF;
400: END IF;
401:

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

411: p_delivery_info.weight_uom_code,
412: p_delivery_info.weight_uom_desc,
413: x_return_status);
414:
415: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
416: RETURN;
417: END IF;
418: END IF;
419:

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

429: p_delivery_info.volume_uom_code,
430: p_delivery_info.volume_uom_desc,
431: x_return_status);
432:
433: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
434: RETURN;
435: END IF;
436: END IF;
437:

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

448: p_amount => NULL,
449: x_return_status => x_return_status,
450: x_adjusted_amount => l_adjusted_amount); -- OTM R12,glog project
451:
452: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
453: RETURN;
454: END IF;
455: END IF;
456:

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

468: l_assigned_to_trip := WSH_Delivery_Validations.Del_Assigned_To_Trip
469: (p_delivery_id => p_delivery_info.delivery_id,
470: x_return_status => x_return_status);
471:
472: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
473:
474: RETURN;
475:
476: ELSIF l_assigned_to_trip = 'Y' THEN

Line 479: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

475:
476: ELSIF l_assigned_to_trip = 'Y' THEN
477: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_ASSIGNED_ERROR');
478: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_info.delivery_id));
479: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
480: wsh_util_core.add_message(x_return_status);
481: RETURN;
482: END IF;
483: END IF;

Line 480: wsh_util_core.add_message(x_return_status);

476: ELSIF l_assigned_to_trip = 'Y' THEN
477: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_ASSIGNED_ERROR');
478: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_info.delivery_id));
479: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
480: wsh_util_core.add_message(x_return_status);
481: RETURN;
482: END IF;
483: END IF;
484:

Line 489: wsh_util_core.default_handler('WSH_DELIVERIES_PUB.Validate_Delivery');

485:
486:
487: EXCEPTION
488: WHEN others THEN
489: wsh_util_core.default_handler('WSH_DELIVERIES_PUB.Validate_Delivery');
490: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
491:
492: END Validate_Delivery;
493:

Line 490: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

486:
487: EXCEPTION
488: WHEN others THEN
489: wsh_util_core.default_handler('WSH_DELIVERIES_PUB.Validate_Delivery');
490: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
491:
492: END Validate_Delivery;
493:
494: /* I Harmonization -- rvishnuv */

Line 516: x_return_status := wsh_util_core.g_ret_sts_success;

512: --
513: IF l_debug_on THEN
514: WSH_DEBUG_SV.push(l_module_name);
515: END IF;
516: x_return_status := wsh_util_core.g_ret_sts_success;
517: --
518: x_pvt_rec.DELIVERY_ID := p_pub_rec.DELIVERY_ID;
519: x_pvt_rec.NAME := p_pub_rec.NAME;
520: x_pvt_rec.DELIVERY_TYPE := p_pub_rec.DELIVERY_TYPE;

Line 662: x_pvt_rec.prorate_wt_flag := WSH_UTIL_CORE.FTE_Is_Installed ;

658: x_pvt_rec.DESCRIPTION := p_pub_rec.DESCRIPTION;
659: -- Non Database field added for "Proration of weight from Delivery to delivery lines" Project(Bug#4254552).
660: IF p_pub_rec.prorate_wt_flag = FND_API.G_MISS_CHAR THEN
661: --{
662: x_pvt_rec.prorate_wt_flag := WSH_UTIL_CORE.FTE_Is_Installed ;
663: ELSIF p_pub_rec.prorate_wt_flag = 'Y' THEN
664: x_pvt_rec.prorate_wt_flag := 'Y';
665: ELSE
666: x_pvt_rec.prorate_wt_flag := 'N';

Line 683: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_DELIVERIES_PUB.map_pub_to_pvt',l_module_name);

679: WSH_DEBUG_SV.pop(l_module_name);
680: END IF;
681: EXCEPTION
682: WHEN OTHERS THEN
683: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_DELIVERIES_PUB.map_pub_to_pvt',l_module_name);
684: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
685: --
686: IF l_debug_on THEN
687: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 684: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

680: END IF;
681: EXCEPTION
682: WHEN OTHERS THEN
683: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_DELIVERIES_PUB.map_pub_to_pvt',l_module_name);
684: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
685: --
686: IF l_debug_on THEN
687: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
688: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 781: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

777: END IF;
778: ELSIF ( p_action_code <> 'CREATE' ) THEN
779: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_ACTION_CODE');
780: FND_MESSAGE.SET_TOKEN('ACTION_CODE',p_action_code);
781: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
782: wsh_util_core.add_message(x_return_status);
783: END IF;
784: --
785: map_pub_to_pvt(

Line 782: wsh_util_core.add_message(x_return_status);

778: ELSIF ( p_action_code <> 'CREATE' ) THEN
779: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_ACTION_CODE');
780: FND_MESSAGE.SET_TOKEN('ACTION_CODE',p_action_code);
781: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
782: wsh_util_core.add_message(x_return_status);
783: END IF;
784: --
785: map_pub_to_pvt(
786: p_pub_rec => p_delivery_info,

Line 794: wsh_util_core.api_post_call(

790: IF l_debug_on THEN
791: wsh_debug_sv.log(l_module_name,'Return Status After Calling map_pub_to_pvt',l_return_status);
792: END IF;
793: --
794: wsh_util_core.api_post_call(
795: p_return_status => l_return_status,
796: x_num_errors => l_num_errors,
797: x_num_warnings => l_num_warnings);
798: --

Line 810: wsh_util_core.api_post_call(

806: IF l_debug_on THEN
807: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_delivery_name',l_return_status);
808: END IF;
809: --
810: wsh_util_core.api_post_call(
811: p_return_status => l_return_status,
812: x_num_errors => l_num_errors,
813: x_num_warnings => l_num_warnings);
814: --

Line 824: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

820: WSH_NEW_DELIVERIES_PVT.Lock_Dlvy_No_Compare(l_rec_attr_tab(1).delivery_id);
821: EXCEPTION
822:
823: WHEN OTHERS THEN
824: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
825: FND_MESSAGE.Set_Name('WSH', 'WSH_NO_LOCK');
826: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.G_RET_STS_ERROR);
827: IF l_debug_on THEN
828: WSH_DEBUG_SV.log(l_module_name,'Could not lock delivery: ',p_delivery_info.delivery_id);

Line 826: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.G_RET_STS_ERROR);

822:
823: WHEN OTHERS THEN
824: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
825: FND_MESSAGE.Set_Name('WSH', 'WSH_NO_LOCK');
826: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.G_RET_STS_ERROR);
827: IF l_debug_on THEN
828: WSH_DEBUG_SV.log(l_module_name,'Could not lock delivery: ',p_delivery_info.delivery_id);
829: END IF;
830: goto count_messasge;

Line 861: wsh_util_core.api_post_call(p_return_status => l_return_status,

857: IF l_debug_on THEN
858: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_org',l_return_status);
859: END IF;
860: --
861: wsh_util_core.api_post_call(p_return_status => l_return_status,
862: x_num_errors => l_num_errors,
863: x_num_warnings => l_num_warnings );
864: --
865: wsh_wv_utils.get_default_uoms( p_organization_id => l_rec_attr_tab(1).ORGANIZATION_ID,

Line 874: wsh_util_core.api_post_call(p_return_status => l_return_status,

870: IF l_debug_on THEN
871: wsh_debug_sv.log(l_module_name,'Return Status After Calling get_default_uoms',l_return_status);
872: END IF;
873: --
874: wsh_util_core.api_post_call(p_return_status => l_return_status,
875: x_num_errors => l_num_errors,
876: x_num_warnings => l_num_warnings );
877: --
878: IF l_rec_attr_tab(1).WEIGHT_UOM_CODE = FND_API.G_MISS_CHAR THEN

Line 906: wsh_util_core.api_post_call(

902: IF l_debug_on THEN
903: wsh_debug_sv.log(l_module_name,'Return Status After Calling create_update_delivery',l_return_status);
904: END IF;
905: --
906: wsh_util_core.api_post_call(
907: p_return_status => l_return_status,
908: x_num_errors => l_num_errors,
909: x_num_warnings => l_num_warnings,
910: p_msg_data => x_msg_data);

Line 921: x_return_status := wsh_util_core.g_ret_sts_warning;

917: --
918: END IF;
919: --
920: IF l_num_warnings > 0 THEN
921: x_return_status := wsh_util_core.g_ret_sts_warning;
922: ELSE
923: x_return_status := wsh_util_core.g_ret_sts_success; --bug 2398628
924: END IF;
925: --

Line 923: x_return_status := wsh_util_core.g_ret_sts_success; --bug 2398628

919: --
920: IF l_num_warnings > 0 THEN
921: x_return_status := wsh_util_core.g_ret_sts_warning;
922: ELSE
923: x_return_status := wsh_util_core.g_ret_sts_success; --bug 2398628
924: END IF;
925: --
926: <>--Added for bug 9772252
927: FND_MSG_PUB.Count_And_Get

Line 1037: l_delivery_id_tab wsh_util_core.id_tab_type;

1033: --
1034: --
1035: l_action_prms wsh_deliveries_grp.action_parameters_rectype;
1036: l_del_action_out_rec wsh_deliveries_grp.Delivery_Action_Out_Rec_Type;
1037: l_delivery_id_tab wsh_util_core.id_tab_type;
1038: --
1039: l_delivery_id NUMBER := p_delivery_id;
1040: --
1041: l_num_errors NUMBER := 0;

Line 1086: wsh_util_core.api_post_call(

1082: IF l_debug_on THEN
1083: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_delivery_name',l_return_status);
1084: END IF;
1085: --
1086: wsh_util_core.api_post_call(
1087: p_return_status => l_return_status,
1088: x_num_errors => l_num_errors,
1089: x_num_warnings => l_num_warnings);
1090: --

Line 1144: wsh_util_core.api_post_call(

1140: IF l_debug_on THEN
1141: wsh_debug_sv.log(l_module_name,'Return Status After Calling Delivery_Action Wrapper',x_return_status);
1142: END IF;
1143: --
1144: wsh_util_core.api_post_call(
1145: p_return_status => x_return_status,
1146: x_num_errors => l_num_errors,
1147: x_num_warnings => l_num_warnings);
1148: --

Line 1160: x_return_status := wsh_util_core.g_ret_sts_warning;

1156: END IF;
1157: END IF;
1158: --
1159: IF l_num_warnings > 0 THEN
1160: x_return_status := wsh_util_core.g_ret_sts_warning;
1161: ELSE
1162: x_return_status := wsh_util_core.g_ret_sts_success; --bug 2398628
1163: END IF;
1164: --

Line 1162: x_return_status := wsh_util_core.g_ret_sts_success; --bug 2398628

1158: --
1159: IF l_num_warnings > 0 THEN
1160: x_return_status := wsh_util_core.g_ret_sts_warning;
1161: ELSE
1162: x_return_status := wsh_util_core.g_ret_sts_success; --bug 2398628
1163: END IF;
1164: --
1165: FND_MSG_PUB.Count_And_Get
1166: ( p_count => x_msg_count

Line 1249: p_delivery_name IN WSH_UTIL_CORE.Column_Tab_Type,

1245:
1246: PROCEDURE Generate_Documents
1247: ( p_report_set_name IN VARCHAR2,
1248: p_organization_code IN VARCHAR2,
1249: p_delivery_name IN WSH_UTIL_CORE.Column_Tab_Type,
1250: x_msg_count OUT NOCOPY NUMBER,
1251: x_msg_data OUT NOCOPY VARCHAR2,
1252: x_return_status OUT NOCOPY VARCHAR2
1253: ) IS

Line 1276: l_delivery_ids WSH_UTIL_CORE.Id_Tab_Type;

1272: l_trip_name WSH_TRIPS.Name%TYPE;
1273: l_msg_count NUMBER;
1274: l_msg_data VARCHAR2(500);
1275: l_return_status VARCHAR2(1);
1276: l_delivery_ids WSH_UTIL_CORE.Id_Tab_Type;
1277: l_document_param_info WSH_DOCUMENT_SETS.Document_Set_Tab_Type;
1278:
1279: -- Exception
1280: WSH_INVALID_ORGANIZATION EXCEPTION;

Line 1305: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1301: END IF;
1302: END IF;
1303:
1304: -- Assigning Success to x_return_status Initially
1305: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1306: l_count := 0;
1307:
1308: -- Validation of Organization_Code
1309: WSH_UTIL_VALIDATE.Validate_Org(

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

1313: IF l_debug_on THEN
1314: WSH_DEBUG_SV.Logmsg(l_module_name, 'Return status from Validate_Org : ' || x_return_status);
1315: END IF;
1316:
1317: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1318: RAISE WSH_INVALID_ORGANIZATION;
1319: END IF;
1320:
1321: -- Validation of Delivery Names

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

1335: WSH_DEBUG_SV.Logmsg(l_module_name, 'Return status for Delivery Name (' ||
1336: l_delivery_name || ') : ' || x_return_status);
1337: END IF;
1338:
1339: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1340: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_DELIVERY');
1341: FND_MESSAGE.Set_Token('DELIVERY', l_delivery_name);
1342: WSH_UTIL_CORE.Add_Message(x_return_status);
1343: ELSE

Line 1342: WSH_UTIL_CORE.Add_Message(x_return_status);

1338:
1339: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1340: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_DELIVERY');
1341: FND_MESSAGE.Set_Token('DELIVERY', l_delivery_name);
1342: WSH_UTIL_CORE.Add_Message(x_return_status);
1343: ELSE
1344: l_count := l_count + 1;
1345: l_delivery_ids(l_count) := l_delivery_id;
1346: END IF;

Line 1371: WSH_UTIL_CORE.Api_Post_Call(

1367: x_trip_id => l_trip_id ,
1368: x_trip_name => l_trip_name,
1369: x_return_status => l_return_status);
1370:
1371: WSH_UTIL_CORE.Api_Post_Call(
1372: p_return_status => l_return_status,
1373: x_num_errors => l_num_errors ,
1374: x_num_warnings => l_num_warnings );
1375:

Line 1384: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1380:
1381: END LOOP; -- } l_Count For Loop.
1382:
1383: IF l_num_warnings > 0 THEN
1384: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1385: ELSE
1386: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1387: END IF;
1388:

Line 1386: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1382:
1383: IF l_num_warnings > 0 THEN
1384: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1385: ELSE
1386: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1387: END IF;
1388:
1389: ELSE
1390: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1390: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1386: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1387: END IF;
1388:
1389: ELSE
1390: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1391: IF l_debug_on THEN
1392: WSH_DEBUG_SV.Logmsg(l_module_name,
1393: 'Deliveries passed are Invalid for generating ' || upper(p_report_set_name));
1394: END IF;

Line 1433: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1429: p_count => x_msg_count,
1430: p_data => x_msg_data );
1431:
1432: WHEN WSH_INVALID_ORGANIZATION THEN
1433: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1434: IF l_debug_on THEN
1435: WSH_DEBUG_SV.Logmsg(l_module_name, 'WSH_INVALID_ORGANIZATION : ' || x_return_status);
1436: END IF;
1437: FND_MSG_PUB.Count_And_Get(

Line 1443: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1439: p_data => x_msg_data );
1440:
1441: WHEN WSH_INVALID_DELIVERY THEN
1442: FND_MESSAGE.Set_Name('WSH', 'WSH_DOC_INVALID_DELIVERY');
1443: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1444: IF l_debug_on THEN
1445: WSH_DEBUG_SV.Logmsg(l_module_name, 'WSH_INVALID_DELIVERY : ' || x_return_status);
1446: END IF;
1447: WSH_UTIL_CORE.Add_Message(x_return_status);

Line 1447: WSH_UTIL_CORE.Add_Message(x_return_status);

1443: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1444: IF l_debug_on THEN
1445: WSH_DEBUG_SV.Logmsg(l_module_name, 'WSH_INVALID_DELIVERY : ' || x_return_status);
1446: END IF;
1447: WSH_UTIL_CORE.Add_Message(x_return_status);
1448: FND_MSG_PUB.Count_And_Get(
1449: p_count => x_msg_count,
1450: p_data => x_msg_data );
1451:

Line 1453: WSH_UTIL_CORE.Default_Handler('WSH_DELIVERIES_PUB.GENEREATE_DOCUMENTS');

1449: p_count => x_msg_count,
1450: p_data => x_msg_data );
1451:
1452: WHEN OTHERS THEN
1453: WSH_UTIL_CORE.Default_Handler('WSH_DELIVERIES_PUB.GENEREATE_DOCUMENTS');
1454: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1455: IF l_debug_on THEN
1456: WSH_DEBUG_SV.Logmsg(l_module_name, 'Unexpected Error : ' || x_return_status);
1457: WSH_DEBUG_SV.Logmsg(l_module_name, 'Error Message : ' || SQLERRM);

Line 1454: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1450: p_data => x_msg_data );
1451:
1452: WHEN OTHERS THEN
1453: WSH_UTIL_CORE.Default_Handler('WSH_DELIVERIES_PUB.GENEREATE_DOCUMENTS');
1454: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1455: IF l_debug_on THEN
1456: WSH_DEBUG_SV.Logmsg(l_module_name, 'Unexpected Error : ' || x_return_status);
1457: WSH_DEBUG_SV.Logmsg(l_module_name, 'Error Message : ' || SQLERRM);
1458: END IF;