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_TP_RELEASE dependencies on FND_MESSAGE

Line 275: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_IGNOREPLAN_ERROR');

271: GOTO next_deltrip;
272: END IF;
273: END LOOP;
274: IF l_okay='F' THEN -- atleast one of the trips the del is assigned to is not in list of ids
275: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_IGNOREPLAN_ERROR');
276: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
277: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_del_cur.delivery_name);
278: FND_MESSAGE.SET_TOKEN('REL_TRIP_NAME',cur_othertrip.trip_name);
279: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

Line 276: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_in_ids(i)));

272: END IF;
273: END LOOP;
274: IF l_okay='F' THEN -- atleast one of the trips the del is assigned to is not in list of ids
275: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_IGNOREPLAN_ERROR');
276: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
277: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_del_cur.delivery_name);
278: FND_MESSAGE.SET_TOKEN('REL_TRIP_NAME',cur_othertrip.trip_name);
279: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
280:

Line 277: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_del_cur.delivery_name);

273: END LOOP;
274: IF l_okay='F' THEN -- atleast one of the trips the del is assigned to is not in list of ids
275: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_IGNOREPLAN_ERROR');
276: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
277: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_del_cur.delivery_name);
278: FND_MESSAGE.SET_TOKEN('REL_TRIP_NAME',cur_othertrip.trip_name);
279: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
280:
281: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');

Line 278: FND_MESSAGE.SET_TOKEN('REL_TRIP_NAME',cur_othertrip.trip_name);

274: IF l_okay='F' THEN -- atleast one of the trips the del is assigned to is not in list of ids
275: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_IGNOREPLAN_ERROR');
276: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
277: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_del_cur.delivery_name);
278: FND_MESSAGE.SET_TOKEN('REL_TRIP_NAME',cur_othertrip.trip_name);
279: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
280:
281: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');
282: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');

Line 281: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');

277: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_del_cur.delivery_name);
278: FND_MESSAGE.SET_TOKEN('REL_TRIP_NAME',cur_othertrip.trip_name);
279: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
280:
281: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');
282: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
283: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
284: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
285: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 282: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');

278: FND_MESSAGE.SET_TOKEN('REL_TRIP_NAME',cur_othertrip.trip_name);
279: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
280:
281: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');
282: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
283: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
284: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
285: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
286: IF l_debug_on THEN

Line 283: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);

279: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
280:
281: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');
282: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
283: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
284: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
285: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
286: IF l_debug_on THEN
287: WSH_DEBUG_SV.pop(l_module_name);

Line 310: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_TPW_ERROR');

306: IF l_debug_on THEN
307: WSH_DEBUG_SV.log(l_module_name,'Get_Warehouse_Type cur.organization_id,l_wh_type,l_return_status',cur.organization_id||l_wh_type||l_return_status);
308: END IF;
309:
310: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_TPW_ERROR');
311: FND_MESSAGE.SET_TOKEN('DEL_NAME',cur.delivery_name);
312: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
313: l_num_error:=l_num_error+1;
314: GOTO next_trip;

Line 311: FND_MESSAGE.SET_TOKEN('DEL_NAME',cur.delivery_name);

307: WSH_DEBUG_SV.log(l_module_name,'Get_Warehouse_Type cur.organization_id,l_wh_type,l_return_status',cur.organization_id||l_wh_type||l_return_status);
308: END IF;
309:
310: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_TPW_ERROR');
311: FND_MESSAGE.SET_TOKEN('DEL_NAME',cur.delivery_name);
312: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
313: l_num_error:=l_num_error+1;
314: GOTO next_trip;
315: END IF;

Line 317: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_MDC_ERROR');

313: l_num_error:=l_num_error+1;
314: GOTO next_trip;
315: END IF;
316: IF cur.delivery_type = 'CONSOLIDATION' THEN
317: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_MDC_ERROR');
318: FND_MESSAGE.SET_TOKEN('DEL_NAME',cur.delivery_name);
319: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
320: l_num_error:=l_num_error+1;
321: GOTO next_trip;

Line 318: FND_MESSAGE.SET_TOKEN('DEL_NAME',cur.delivery_name);

314: GOTO next_trip;
315: END IF;
316: IF cur.delivery_type = 'CONSOLIDATION' THEN
317: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_MDC_ERROR');
318: FND_MESSAGE.SET_TOKEN('DEL_NAME',cur.delivery_name);
319: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
320: l_num_error:=l_num_error+1;
321: GOTO next_trip;
322: END IF;

Line 333: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_TPW_ERROR');

329: IF l_ignoreplan='N' AND l_det_cur.source_code='WSH'
330: and l_det_cur.container_flag='N'
331: AND l_gc3_is_installed = 'N' THEN -- OTM R12
332: --do not allow lines in thrid party instance to be set to include for planning
333: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_TPW_ERROR');
334: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_del_cur.delivery_id));
335: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
336: l_num_error:=l_num_error+1;
337: GOTO next_trip;

Line 334: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_del_cur.delivery_id));

330: and l_det_cur.container_flag='N'
331: AND l_gc3_is_installed = 'N' THEN -- OTM R12
332: --do not allow lines in thrid party instance to be set to include for planning
333: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_TPW_ERROR');
334: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_del_cur.delivery_id));
335: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
336: l_num_error:=l_num_error+1;
337: GOTO next_trip;
338: ELSE

Line 478: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');

474: last_updated_by = FND_GLOBAL.USER_ID
475: WHERE delivery_detail_id=l_tmp_detail_ids(i);
476: IF (SQL%NOTFOUND) THEN
477: rollback to before_update;
478: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
479: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
480: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
481: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
482: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

Line 479: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');

475: WHERE delivery_detail_id=l_tmp_detail_ids(i);
476: IF (SQL%NOTFOUND) THEN
477: rollback to before_update;
478: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
479: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
480: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
481: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
482: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
483: l_num_error:=l_num_error+1;

Line 480: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);

476: IF (SQL%NOTFOUND) THEN
477: rollback to before_update;
478: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
479: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
480: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
481: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
482: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
483: l_num_error:=l_num_error+1;
484: GOTO next_trip;

Line 481: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));

477: rollback to before_update;
478: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
479: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
480: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
481: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
482: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
483: l_num_error:=l_num_error+1;
484: GOTO next_trip;
485: END IF;

Line 509: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');

505: WHERE delivery_id=l_tmp_del_ids(i);
506:
507: IF (SQL%NOTFOUND) THEN
508: rollback to before_update;
509: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
510: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
511: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
512: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
513: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

Line 510: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');

506:
507: IF (SQL%NOTFOUND) THEN
508: rollback to before_update;
509: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
510: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
511: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
512: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
513: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
514: l_num_error:=l_num_error+1;

Line 511: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);

507: IF (SQL%NOTFOUND) THEN
508: rollback to before_update;
509: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
510: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
511: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
512: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
513: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
514: l_num_error:=l_num_error+1;
515: GOTO next_trip;

Line 512: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));

508: rollback to before_update;
509: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
510: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
511: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
512: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
513: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
514: l_num_error:=l_num_error+1;
515: GOTO next_trip;
516: END IF;

Line 562: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');

558: --
559:
560: IF (SQL%NOTFOUND) THEN
561: rollback to before_update;
562: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
563: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
564: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
565: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
566: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

Line 563: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');

559:
560: IF (SQL%NOTFOUND) THEN
561: rollback to before_update;
562: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
563: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
564: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
565: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
566: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
567: l_num_error:=l_num_error+1;

Line 564: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);

560: IF (SQL%NOTFOUND) THEN
561: rollback to before_update;
562: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
563: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
564: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
565: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
566: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
567: l_num_error:=l_num_error+1;
568: END IF;

Line 565: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));

561: rollback to before_update;
562: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
563: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
564: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
565: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
566: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
567: l_num_error:=l_num_error+1;
568: END IF;
569:

Line 576: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');

572: END LOOP;
573:
574: --if all trips have problem show as error
575: IF l_num_error>0 AND l_num_error=p_in_ids.COUNT THEN
576: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');
577: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
578: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
579: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
580: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 577: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');

573:
574: --if all trips have problem show as error
575: IF l_num_error>0 AND l_num_error=p_in_ids.COUNT THEN
576: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');
577: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
578: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
579: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
580: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
581: IF l_debug_on THEN

Line 578: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);

574: --if all trips have problem show as error
575: IF l_num_error>0 AND l_num_error=p_in_ids.COUNT THEN
576: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');
577: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
578: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
579: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
580: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
581: IF l_debug_on THEN
582: WSH_DEBUG_SV.pop(l_module_name);

Line 600: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_ERROR');

596: l_tmp_detail_ids.delete;
597:
598: --1. check if trip the del is assigned to has diff ignore_plan value or is firm
599: FOR cur IN c_get_del_ignoreflag_difftrip(p_in_ids(i), l_ignoreplan) LOOP
600: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_ERROR');
601: FND_MESSAGE.SET_TOKEN('DEL_NAME',cur.delivery_name);
602: FND_MESSAGE.SET_TOKEN('TRIP_NAME',cur.trip_name);
603: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
604: l_num_error:=l_num_error+1;

Line 601: FND_MESSAGE.SET_TOKEN('DEL_NAME',cur.delivery_name);

597:
598: --1. check if trip the del is assigned to has diff ignore_plan value or is firm
599: FOR cur IN c_get_del_ignoreflag_difftrip(p_in_ids(i), l_ignoreplan) LOOP
600: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_ERROR');
601: FND_MESSAGE.SET_TOKEN('DEL_NAME',cur.delivery_name);
602: FND_MESSAGE.SET_TOKEN('TRIP_NAME',cur.trip_name);
603: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
604: l_num_error:=l_num_error+1;
605: GOTO next_del;

Line 602: FND_MESSAGE.SET_TOKEN('TRIP_NAME',cur.trip_name);

598: --1. check if trip the del is assigned to has diff ignore_plan value or is firm
599: FOR cur IN c_get_del_ignoreflag_difftrip(p_in_ids(i), l_ignoreplan) LOOP
600: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_ERROR');
601: FND_MESSAGE.SET_TOKEN('DEL_NAME',cur.delivery_name);
602: FND_MESSAGE.SET_TOKEN('TRIP_NAME',cur.trip_name);
603: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
604: l_num_error:=l_num_error+1;
605: GOTO next_del;
606: END LOOP;

Line 626: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_TPW_ERROR');

622: IF l_debug_on THEN
623: WSH_DEBUG_SV.log(l_module_name,'Get_Warehouse_Type cur.organization_id,l_wh_type,l_return_status',cur.organization_id||l_wh_type||l_return_status);
624: END IF;
625:
626: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_TPW_ERROR');
627: FND_MESSAGE.SET_TOKEN('DEL_NAME',cur.delivery_name);
628: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
629: l_num_error:=l_num_error+1;
630: GOTO next_del;

Line 627: FND_MESSAGE.SET_TOKEN('DEL_NAME',cur.delivery_name);

623: WSH_DEBUG_SV.log(l_module_name,'Get_Warehouse_Type cur.organization_id,l_wh_type,l_return_status',cur.organization_id||l_wh_type||l_return_status);
624: END IF;
625:
626: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_TPW_ERROR');
627: FND_MESSAGE.SET_TOKEN('DEL_NAME',cur.delivery_name);
628: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
629: l_num_error:=l_num_error+1;
630: GOTO next_del;
631: END IF;

Line 633: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_MDC_ERROR');

629: l_num_error:=l_num_error+1;
630: GOTO next_del;
631: END IF;
632: IF cur.delivery_type = 'CONSOLIDATION' THEN
633: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_MDC_ERROR');
634: FND_MESSAGE.SET_TOKEN('DEL_NAME',cur.delivery_name);
635: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
636: l_num_error:=l_num_error+1;
637: GOTO next_del;

Line 634: FND_MESSAGE.SET_TOKEN('DEL_NAME',cur.delivery_name);

630: GOTO next_del;
631: END IF;
632: IF cur.delivery_type = 'CONSOLIDATION' THEN
633: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_MDC_ERROR');
634: FND_MESSAGE.SET_TOKEN('DEL_NAME',cur.delivery_name);
635: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
636: l_num_error:=l_num_error+1;
637: GOTO next_del;
638: END IF;

Line 650: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_TPW_ERROR');

646: IF l_ignoreplan='N' AND l_det_cur.source_code='WSH'
647: and l_det_cur.container_flag='N'
648: and l_gc3_is_installed = 'N' THEN -- OTM R12
649: --do not allow lines in thrid party instance to be set to include for planning
650: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_TPW_ERROR');
651: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_del_cur.delivery_id));
652: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
653: l_num_error:=l_num_error+1;
654: GOTO next_del;

Line 651: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_del_cur.delivery_id));

647: and l_det_cur.container_flag='N'
648: and l_gc3_is_installed = 'N' THEN -- OTM R12
649: --do not allow lines in thrid party instance to be set to include for planning
650: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_TPW_ERROR');
651: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_del_cur.delivery_id));
652: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
653: l_num_error:=l_num_error+1;
654: GOTO next_del;
655: ELSE

Line 795: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');

791: last_updated_by = FND_GLOBAL.USER_ID
792: WHERE delivery_detail_id=l_tmp_detail_ids(i);
793: IF (SQL%NOTFOUND) THEN
794: ROLLBACK to before_update;
795: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
796: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
797: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
798: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
799: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

Line 796: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');

792: WHERE delivery_detail_id=l_tmp_detail_ids(i);
793: IF (SQL%NOTFOUND) THEN
794: ROLLBACK to before_update;
795: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
796: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
797: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
798: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
799: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
800: l_num_error:=l_num_error+1;

Line 797: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);

793: IF (SQL%NOTFOUND) THEN
794: ROLLBACK to before_update;
795: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
796: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
797: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
798: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
799: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
800: l_num_error:=l_num_error+1;
801: GOTO next_del;

Line 798: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));

794: ROLLBACK to before_update;
795: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
796: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
797: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
798: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
799: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
800: l_num_error:=l_num_error+1;
801: GOTO next_del;
802: END IF;

Line 953: FND_MESSAGE.SET_NAME(l_del_trip_tab(l_temp).r_message_appl,

949: l_temp := l_del_trip_tab.LAST;
950: IF (l_del_trip_tab(l_temp).r_message_code = 'WMS_DELIVERY_LOADED_TO_DOCK')
951: THEN--{
952: ROLLBACK to before_update;
953: FND_MESSAGE.SET_NAME(l_del_trip_tab(l_temp).r_message_appl,
954: l_del_trip_tab(l_temp).r_message_code);
955: FND_MESSAGE.SET_TOKEN(l_del_trip_tab(l_temp).r_message_token_name,
956: l_del_trip_tab(l_temp).r_message_token);
957: wsh_util_core.add_message(l_del_trip_tab(l_temp).r_message_type, l_module_name);

Line 955: FND_MESSAGE.SET_TOKEN(l_del_trip_tab(l_temp).r_message_token_name,

951: THEN--{
952: ROLLBACK to before_update;
953: FND_MESSAGE.SET_NAME(l_del_trip_tab(l_temp).r_message_appl,
954: l_del_trip_tab(l_temp).r_message_code);
955: FND_MESSAGE.SET_TOKEN(l_del_trip_tab(l_temp).r_message_token_name,
956: l_del_trip_tab(l_temp).r_message_token);
957: wsh_util_core.add_message(l_del_trip_tab(l_temp).r_message_type, l_module_name);
958: l_num_error:=l_num_error+1;
959: GOTO next_del;

Line 983: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');

979: WHERE delivery_id=p_in_ids(i);
980:
981: IF (SQL%NOTFOUND) THEN
982: ROLLBACK to before_update;
983: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
984: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
985: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
986: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
987: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

Line 984: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');

980:
981: IF (SQL%NOTFOUND) THEN
982: ROLLBACK to before_update;
983: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
984: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
985: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
986: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
987: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
988: l_num_error:=l_num_error+1;

Line 985: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);

981: IF (SQL%NOTFOUND) THEN
982: ROLLBACK to before_update;
983: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
984: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
985: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
986: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
987: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
988: l_num_error:=l_num_error+1;
989: END IF;

Line 986: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));

982: ROLLBACK to before_update;
983: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
984: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
985: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
986: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
987: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
988: l_num_error:=l_num_error+1;
989: END IF;
990:

Line 1028: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');

1024: END LOOP;
1025:
1026: --if all dels have problem show as error
1027: IF l_num_error>0 AND l_num_error=p_in_ids.COUNT THEN
1028: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');
1029: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1030: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1031: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1032: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1029: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');

1025:
1026: --if all dels have problem show as error
1027: IF l_num_error>0 AND l_num_error=p_in_ids.COUNT THEN
1028: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');
1029: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1030: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1031: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1032: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1033: IF l_debug_on THEN

Line 1030: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);

1026: --if all dels have problem show as error
1027: IF l_num_error>0 AND l_num_error=p_in_ids.COUNT THEN
1028: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');
1029: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1030: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1031: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1032: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1033: IF l_debug_on THEN
1034: WSH_DEBUG_SV.pop(l_module_name);

Line 1048: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_ERROR_DETAIL');

1044:
1045: FOR i in 1..p_in_ids.COUNT LOOP
1046: --1. check if del the detail is assigned to has diff ignore_plan value or the del is planned/firm
1047: FOR cur IN c_get_det_ignoreflag_diff_del(p_in_ids(i), l_ignoreplan) LOOP
1048: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_ERROR_DETAIL');
1049: FND_MESSAGE.SET_TOKEN('DET_ID',p_in_ids(i));
1050: FND_MESSAGE.SET_TOKEN('DEL_NAME',cur.delivery_name);
1051: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1052: l_num_error:=l_num_error+1;

Line 1049: FND_MESSAGE.SET_TOKEN('DET_ID',p_in_ids(i));

1045: FOR i in 1..p_in_ids.COUNT LOOP
1046: --1. check if del the detail is assigned to has diff ignore_plan value or the del is planned/firm
1047: FOR cur IN c_get_det_ignoreflag_diff_del(p_in_ids(i), l_ignoreplan) LOOP
1048: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_ERROR_DETAIL');
1049: FND_MESSAGE.SET_TOKEN('DET_ID',p_in_ids(i));
1050: FND_MESSAGE.SET_TOKEN('DEL_NAME',cur.delivery_name);
1051: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1052: l_num_error:=l_num_error+1;
1053: GOTO next_det;

Line 1050: FND_MESSAGE.SET_TOKEN('DEL_NAME',cur.delivery_name);

1046: --1. check if del the detail is assigned to has diff ignore_plan value or the del is planned/firm
1047: FOR cur IN c_get_det_ignoreflag_diff_del(p_in_ids(i), l_ignoreplan) LOOP
1048: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_ERROR_DETAIL');
1049: FND_MESSAGE.SET_TOKEN('DET_ID',p_in_ids(i));
1050: FND_MESSAGE.SET_TOKEN('DEL_NAME',cur.delivery_name);
1051: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1052: l_num_error:=l_num_error+1;
1053: GOTO next_det;
1054: END LOOP;

Line 1075: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_DETTPW_ERROR');

1071: WSH_DEBUG_SV.log(l_module_name,'Get_Warehouse_Type cur.organization_id,l_wh_type,l_return_status',cur.organization_id||l_wh_type||l_return_status);
1072: WSH_DEBUG_SV.log(l_module_name,'source_code, container_flag',cur.source_code||cur.container_flag);
1073: END IF;
1074:
1075: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_DETTPW_ERROR');
1076: FND_MESSAGE.SET_TOKEN('DET_ID',p_in_ids(i));
1077: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1078: l_num_error:=l_num_error+1;
1079: GOTO next_det;

Line 1076: FND_MESSAGE.SET_TOKEN('DET_ID',p_in_ids(i));

1072: WSH_DEBUG_SV.log(l_module_name,'source_code, container_flag',cur.source_code||cur.container_flag);
1073: END IF;
1074:
1075: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_DETTPW_ERROR');
1076: FND_MESSAGE.SET_TOKEN('DET_ID',p_in_ids(i));
1077: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1078: l_num_error:=l_num_error+1;
1079: GOTO next_det;
1080: END IF;

Line 1087: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_DET_ASSN_CONT');

1083: END IF;
1084:
1085: --3. check if line is assigned to a container. if so, user has to perform from topmost entity
1086: FOR cur IN c_get_det_ignoreflag_diff_cont(p_in_ids(i), l_ignoreplan) LOOP
1087: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_DET_ASSN_CONT');
1088: FND_MESSAGE.SET_TOKEN('DET_ID',p_in_ids(i));
1089: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1090: l_num_error:=l_num_error+1;
1091: GOTO next_det;

Line 1088: FND_MESSAGE.SET_TOKEN('DET_ID',p_in_ids(i));

1084:
1085: --3. check if line is assigned to a container. if so, user has to perform from topmost entity
1086: FOR cur IN c_get_det_ignoreflag_diff_cont(p_in_ids(i), l_ignoreplan) LOOP
1087: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_DET_ASSN_CONT');
1088: FND_MESSAGE.SET_TOKEN('DET_ID',p_in_ids(i));
1089: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1090: l_num_error:=l_num_error+1;
1091: GOTO next_det;
1092: END LOOP;

Line 1123: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');

1119: WHERE delivery_detail_id=l_tmp_detail_ids(i)
1120: RETURNING container_flag, organization_id, line_direction bulk collect into l_cont_flag_tbl, l_orgn_id_tbl, l_line_dir_tbl; -- LPN CONV. rv
1121: IF (SQL%NOTFOUND) THEN
1122: rollback to before_update;
1123: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1124: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_CONTAINER');
1125: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1126: FND_MESSAGE.SET_TOKEN('NAME',l_container_name);
1127: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

Line 1124: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_CONTAINER');

1120: RETURNING container_flag, organization_id, line_direction bulk collect into l_cont_flag_tbl, l_orgn_id_tbl, l_line_dir_tbl; -- LPN CONV. rv
1121: IF (SQL%NOTFOUND) THEN
1122: rollback to before_update;
1123: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1124: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_CONTAINER');
1125: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1126: FND_MESSAGE.SET_TOKEN('NAME',l_container_name);
1127: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1128: l_num_error:=l_num_error+1;

Line 1125: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);

1121: IF (SQL%NOTFOUND) THEN
1122: rollback to before_update;
1123: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1124: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_CONTAINER');
1125: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1126: FND_MESSAGE.SET_TOKEN('NAME',l_container_name);
1127: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1128: l_num_error:=l_num_error+1;
1129: GOTO next_det;

Line 1126: FND_MESSAGE.SET_TOKEN('NAME',l_container_name);

1122: rollback to before_update;
1123: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1124: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_CONTAINER');
1125: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1126: FND_MESSAGE.SET_TOKEN('NAME',l_container_name);
1127: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1128: l_num_error:=l_num_error+1;
1129: GOTO next_det;
1130: END IF;

Line 1275: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');

1271: last_updated_by = FND_GLOBAL.USER_ID
1272: WHERE delivery_detail_id=p_in_ids(i);
1273: IF (SQL%NOTFOUND) THEN
1274: rollback to before_update;
1275: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1276: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_LINE');
1277: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1278: FND_MESSAGE.SET_TOKEN('NAME',p_in_ids(i));
1279: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

Line 1276: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_LINE');

1272: WHERE delivery_detail_id=p_in_ids(i);
1273: IF (SQL%NOTFOUND) THEN
1274: rollback to before_update;
1275: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1276: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_LINE');
1277: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1278: FND_MESSAGE.SET_TOKEN('NAME',p_in_ids(i));
1279: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1280: l_num_error:=l_num_error+1;

Line 1277: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);

1273: IF (SQL%NOTFOUND) THEN
1274: rollback to before_update;
1275: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1276: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_LINE');
1277: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1278: FND_MESSAGE.SET_TOKEN('NAME',p_in_ids(i));
1279: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1280: l_num_error:=l_num_error+1;
1281: END IF;

Line 1278: FND_MESSAGE.SET_TOKEN('NAME',p_in_ids(i));

1274: rollback to before_update;
1275: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1276: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_LINE');
1277: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1278: FND_MESSAGE.SET_TOKEN('NAME',p_in_ids(i));
1279: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1280: l_num_error:=l_num_error+1;
1281: END IF;
1282: Check_Shipset_Ignoreflag( p_delivery_detail_id=>p_in_ids(i),

Line 1300: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');

1296: END LOOP;
1297:
1298: --if all details have problem show as error
1299: IF l_num_error>0 AND l_num_error=p_in_ids.COUNT THEN
1300: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');
1301: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_LINE');
1302: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1303: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1304: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1301: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_LINE');

1297:
1298: --if all details have problem show as error
1299: IF l_num_error>0 AND l_num_error=p_in_ids.COUNT THEN
1300: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');
1301: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_LINE');
1302: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1303: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1304: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1305: IF l_debug_on THEN

Line 1302: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);

1298: --if all details have problem show as error
1299: IF l_num_error>0 AND l_num_error=p_in_ids.COUNT THEN
1300: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');
1301: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_LINE');
1302: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1303: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1304: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1305: IF l_debug_on THEN
1306: WSH_DEBUG_SV.pop(l_module_name);

Line 1314: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_WARN');

1310: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1311: END IF;
1312: end if; --entity
1313: IF l_warn>0 THEN
1314: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_WARN');
1315: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_warning,l_module_name);
1316: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1317: END IF;
1318:

Line 1438: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_CANNOT_FIRM');

1434: wsh_delivery_validations.check_plan(p_delivery_id => del_cur.delivery_id,
1435: x_return_status => x_return_status);
1436: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1437: rollback to before_firm;
1438: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_CANNOT_FIRM');
1439: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));
1440: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1441: wsh_util_core.add_message(x_return_status);
1442: IF l_debug_on THEN

Line 1439: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));

1435: x_return_status => x_return_status);
1436: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1437: rollback to before_firm;
1438: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_CANNOT_FIRM');
1439: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));
1440: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1441: wsh_util_core.add_message(x_return_status);
1442: IF l_debug_on THEN
1443: WSH_DEBUG_SV.pop(l_module_name);

Line 1456: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');

1452: last_updated_by = FND_GLOBAL.USER_ID
1453: WHERE delivery_id = del_cur.delivery_id;
1454: --raise error to avoid inconsistency
1455: IF (SQL%NOTFOUND) THEN
1456: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1457: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1458: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1459: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));
1460: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1457: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');

1453: WHERE delivery_id = del_cur.delivery_id;
1454: --raise error to avoid inconsistency
1455: IF (SQL%NOTFOUND) THEN
1456: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1457: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1458: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1459: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));
1460: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1461: wsh_util_core.add_message(x_return_status);

Line 1458: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);

1454: --raise error to avoid inconsistency
1455: IF (SQL%NOTFOUND) THEN
1456: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1457: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1458: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1459: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));
1460: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1461: wsh_util_core.add_message(x_return_status);
1462: IF l_debug_on THEN

Line 1459: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));

1455: IF (SQL%NOTFOUND) THEN
1456: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1457: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1458: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1459: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));
1460: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1461: wsh_util_core.add_message(x_return_status);
1462: IF l_debug_on THEN
1463: WSH_DEBUG_SV.pop(l_module_name);

Line 1476: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_CANNOT_FIRM');

1472: wsh_trip_validations.check_plan(p_trip_id => l_trips_cur.trip_id,
1473: x_return_status => x_return_status);
1474: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1475: rollback to before_firm;
1476: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_CANNOT_FIRM');
1477: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1478: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1479: wsh_util_core.add_message(x_return_status);
1480: IF l_debug_on THEN

Line 1477: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));

1473: x_return_status => x_return_status);
1474: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1475: rollback to before_firm;
1476: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_CANNOT_FIRM');
1477: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1478: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1479: wsh_util_core.add_message(x_return_status);
1480: IF l_debug_on THEN
1481: WSH_DEBUG_SV.pop(l_module_name);

Line 1496: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');

1492: last_updated_by = FND_GLOBAL.USER_ID
1493: WHERE trip_id = l_trips_cur.trip_id;
1494: --return error to avoid inconsistency
1495: IF (SQL%NOTFOUND) THEN
1496: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1497: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1498: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1499: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1500: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1497: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');

1493: WHERE trip_id = l_trips_cur.trip_id;
1494: --return error to avoid inconsistency
1495: IF (SQL%NOTFOUND) THEN
1496: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1497: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1498: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1499: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1500: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1501: wsh_util_core.add_message(x_return_status);

Line 1498: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);

1494: --return error to avoid inconsistency
1495: IF (SQL%NOTFOUND) THEN
1496: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1497: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1498: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1499: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1500: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1501: wsh_util_core.add_message(x_return_status);
1502: IF l_debug_on THEN

Line 1499: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));

1495: IF (SQL%NOTFOUND) THEN
1496: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1497: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1498: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1499: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1500: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1501: wsh_util_core.add_message(x_return_status);
1502: IF l_debug_on THEN
1503: WSH_DEBUG_SV.pop(l_module_name);

Line 1514: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_TRIP_ERROR');

1510: END LOOP;
1511:
1512: --if l_deliveries_exist is null, no deliveries exist for trip => trip can't be firmed
1513: IF l_deliveries_exist IS null THEN
1514: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_TRIP_ERROR');
1515: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_entity_id));
1516: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1517: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1518: IF l_debug_on THEN

Line 1515: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_entity_id));

1511:
1512: --if l_deliveries_exist is null, no deliveries exist for trip => trip can't be firmed
1513: IF l_deliveries_exist IS null THEN
1514: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_TRIP_ERROR');
1515: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_entity_id));
1516: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1517: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1518: IF l_debug_on THEN
1519: WSH_DEBUG_SV.pop(l_module_name);

Line 1530: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NOT_FOUND');

1526: last_update_date = sysdate,
1527: last_updated_by = FND_GLOBAL.USER_ID
1528: WHERE trip_id = p_entity_id;
1529: IF (SQL%NOTFOUND) THEN
1530: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NOT_FOUND');
1531: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1532: wsh_util_core.add_message(x_return_status);
1533: IF l_debug_on THEN
1534: WSH_DEBUG_SV.pop(l_module_name);

Line 1558: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_CANNOT_FIRM');

1554: wsh_trip_validations.check_plan(p_trip_id => l_trips_cur.trip_id,
1555: x_return_status => x_return_status);
1556: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1557: rollback to before_firm;
1558: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_CANNOT_FIRM');
1559: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1560: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1561: wsh_util_core.add_message(x_return_status);
1562: IF l_debug_on THEN

Line 1559: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));

1555: x_return_status => x_return_status);
1556: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1557: rollback to before_firm;
1558: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_CANNOT_FIRM');
1559: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1560: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1561: wsh_util_core.add_message(x_return_status);
1562: IF l_debug_on THEN
1563: WSH_DEBUG_SV.pop(l_module_name);

Line 1576: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');

1572: WHERE trip_id = l_trips_cur.trip_id;
1573:
1574: --return error to avoid inconsistency
1575: IF (SQL%NOTFOUND) THEN
1576: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1577: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1578: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1579: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1580: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1577: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');

1573:
1574: --return error to avoid inconsistency
1575: IF (SQL%NOTFOUND) THEN
1576: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1577: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1578: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1579: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1580: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1581: wsh_util_core.add_message(x_return_status);

Line 1578: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);

1574: --return error to avoid inconsistency
1575: IF (SQL%NOTFOUND) THEN
1576: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1577: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1578: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1579: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1580: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1581: wsh_util_core.add_message(x_return_status);
1582: IF l_debug_on THEN

Line 1579: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));

1575: IF (SQL%NOTFOUND) THEN
1576: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1577: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1578: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1579: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1580: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1581: wsh_util_core.add_message(x_return_status);
1582: IF l_debug_on THEN
1583: WSH_DEBUG_SV.pop(l_module_name);

Line 1594: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_DELIVERY_ERROR');

1590: END LOOP;
1591:
1592: --if l_plannedflag is null, no trip is associated => delivery can't be firmed
1593: IF l_plannedflag IS null THEN
1594: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_DELIVERY_ERROR');
1595: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_entity_id));
1596: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1597: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1598: IF l_debug_on THEN

Line 1595: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_entity_id));

1591:
1592: --if l_plannedflag is null, no trip is associated => delivery can't be firmed
1593: IF l_plannedflag IS null THEN
1594: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_DELIVERY_ERROR');
1595: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_entity_id));
1596: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1597: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1598: IF l_debug_on THEN
1599: WSH_DEBUG_SV.pop(l_module_name);

Line 1611: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_NOT_FOUND');

1607: last_updated_by = FND_GLOBAL.USER_ID
1608: WHERE delivery_id = p_entity_id;
1609:
1610: IF (SQL%NOTFOUND) THEN
1611: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_NOT_FOUND');
1612: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1613: wsh_util_core.add_message(x_return_status);
1614: IF l_debug_on THEN
1615: WSH_DEBUG_SV.pop(l_module_name);

Line 1748: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NOT_FOUND');

1744: last_updated_by = FND_GLOBAL.USER_ID
1745: WHERE trip_id = p_entity_id;
1746:
1747: IF (SQL%NOTFOUND) THEN
1748: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NOT_FOUND');
1749: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1750: wsh_util_core.add_message(x_return_status);
1751: IF l_debug_on THEN
1752: WSH_DEBUG_SV.pop(l_module_name);

Line 1774: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');

1770: last_updated_by = FND_GLOBAL.USER_ID
1771: WHERE delivery_id = del_cur.delivery_id;
1772: --raise error to avoid inconsistency
1773: IF (SQL%NOTFOUND) THEN
1774: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1775: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1776: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1777: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));
1778: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1775: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');

1771: WHERE delivery_id = del_cur.delivery_id;
1772: --raise error to avoid inconsistency
1773: IF (SQL%NOTFOUND) THEN
1774: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1775: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1776: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1777: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));
1778: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1779: wsh_util_core.add_message(x_return_status);

Line 1776: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);

1772: --raise error to avoid inconsistency
1773: IF (SQL%NOTFOUND) THEN
1774: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1775: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1776: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1777: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));
1778: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1779: wsh_util_core.add_message(x_return_status);
1780: IF l_debug_on THEN

Line 1777: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));

1773: IF (SQL%NOTFOUND) THEN
1774: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1775: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1776: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1777: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));
1778: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1779: wsh_util_core.add_message(x_return_status);
1780: IF l_debug_on THEN
1781: WSH_DEBUG_SV.pop(l_module_name);

Line 1796: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');

1792: last_updated_by = FND_GLOBAL.USER_ID
1793: WHERE trip_id = l_trips_cur.trip_id;
1794: --raise error to avoid inconsistency
1795: IF (SQL%NOTFOUND) THEN
1796: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1797: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1798: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1799: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1800: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1797: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');

1793: WHERE trip_id = l_trips_cur.trip_id;
1794: --raise error to avoid inconsistency
1795: IF (SQL%NOTFOUND) THEN
1796: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1797: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1798: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1799: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1800: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1801: wsh_util_core.add_message(x_return_status);

Line 1798: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);

1794: --raise error to avoid inconsistency
1795: IF (SQL%NOTFOUND) THEN
1796: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1797: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1798: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1799: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1800: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1801: wsh_util_core.add_message(x_return_status);
1802: IF l_debug_on THEN

Line 1799: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));

1795: IF (SQL%NOTFOUND) THEN
1796: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1797: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1798: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1799: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1800: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1801: wsh_util_core.add_message(x_return_status);
1802: IF l_debug_on THEN
1803: WSH_DEBUG_SV.pop(l_module_name);

Line 1821: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_NOT_FOUND');

1817: last_updated_by = FND_GLOBAL.USER_ID
1818: WHERE delivery_id = p_entity_id;
1819:
1820: IF (SQL%NOTFOUND) THEN
1821: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_NOT_FOUND');
1822: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1823: wsh_util_core.add_message(x_return_status);
1824: IF l_debug_on THEN
1825: WSH_DEBUG_SV.pop(l_module_name);

Line 1840: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');

1836: WHERE trip_id = cur_deltrip.trip_id;
1837:
1838: --raise error to avoid inconsistency
1839: IF (SQL%NOTFOUND) THEN
1840: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1841: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1842: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1843: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_entity_id));
1844: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1841: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');

1837:
1838: --raise error to avoid inconsistency
1839: IF (SQL%NOTFOUND) THEN
1840: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1841: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1842: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1843: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_entity_id));
1844: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1845: wsh_util_core.add_message(x_return_status);

Line 1842: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);

1838: --raise error to avoid inconsistency
1839: IF (SQL%NOTFOUND) THEN
1840: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1841: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1842: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1843: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_entity_id));
1844: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1845: wsh_util_core.add_message(x_return_status);
1846: IF l_debug_on THEN

Line 1843: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_entity_id));

1839: IF (SQL%NOTFOUND) THEN
1840: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1841: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1842: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1843: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_entity_id));
1844: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1845: wsh_util_core.add_message(x_return_status);
1846: IF l_debug_on THEN
1847: WSH_DEBUG_SV.pop(l_module_name);

Line 3087: FND_MESSAGE.SET_NAME('WSH','WSH_NO_LOCK');

3083: IF is_inbound_dropshp%ISOPEN THEN
3084: CLOSE is_inbound_dropshp;
3085: END IF;
3086:
3087: FND_MESSAGE.SET_NAME('WSH','WSH_NO_LOCK');
3088: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
3089: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
3090:
3091: IF l_debug_on THEN

Line 3458: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_TPDATES_SHIP');

3454: l_exception_name := 'WSH_INVALID_TPDATES';
3455: l_logging_entity := 'SHIPPER';
3456:
3457: IF p_pick_up THEN
3458: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_TPDATES_SHIP');
3459: FND_MESSAGE.SET_TOKEN('EARLIEST', FND_DATE.DATE_TO_CANONICAL(early_date));
3460: FND_MESSAGE.SET_TOKEN('LATEST', FND_DATE.DATE_TO_CANONICAL(latest_date));
3461: l_exception_message := FND_MESSAGE.GET;
3462: ELSE

Line 3459: FND_MESSAGE.SET_TOKEN('EARLIEST', FND_DATE.DATE_TO_CANONICAL(early_date));

3455: l_logging_entity := 'SHIPPER';
3456:
3457: IF p_pick_up THEN
3458: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_TPDATES_SHIP');
3459: FND_MESSAGE.SET_TOKEN('EARLIEST', FND_DATE.DATE_TO_CANONICAL(early_date));
3460: FND_MESSAGE.SET_TOKEN('LATEST', FND_DATE.DATE_TO_CANONICAL(latest_date));
3461: l_exception_message := FND_MESSAGE.GET;
3462: ELSE
3463: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_TPDATES_DELIVERY');

Line 3460: FND_MESSAGE.SET_TOKEN('LATEST', FND_DATE.DATE_TO_CANONICAL(latest_date));

3456:
3457: IF p_pick_up THEN
3458: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_TPDATES_SHIP');
3459: FND_MESSAGE.SET_TOKEN('EARLIEST', FND_DATE.DATE_TO_CANONICAL(early_date));
3460: FND_MESSAGE.SET_TOKEN('LATEST', FND_DATE.DATE_TO_CANONICAL(latest_date));
3461: l_exception_message := FND_MESSAGE.GET;
3462: ELSE
3463: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_TPDATES_DELIVERY');
3464: FND_MESSAGE.SET_TOKEN('EARLIEST', FND_DATE.DATE_TO_CANONICAL(early_date));

Line 3461: l_exception_message := FND_MESSAGE.GET;

3457: IF p_pick_up THEN
3458: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_TPDATES_SHIP');
3459: FND_MESSAGE.SET_TOKEN('EARLIEST', FND_DATE.DATE_TO_CANONICAL(early_date));
3460: FND_MESSAGE.SET_TOKEN('LATEST', FND_DATE.DATE_TO_CANONICAL(latest_date));
3461: l_exception_message := FND_MESSAGE.GET;
3462: ELSE
3463: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_TPDATES_DELIVERY');
3464: FND_MESSAGE.SET_TOKEN('EARLIEST', FND_DATE.DATE_TO_CANONICAL(early_date));
3465: FND_MESSAGE.SET_TOKEN('LATEST', FND_DATE.DATE_TO_CANONICAL(latest_date));

Line 3463: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_TPDATES_DELIVERY');

3459: FND_MESSAGE.SET_TOKEN('EARLIEST', FND_DATE.DATE_TO_CANONICAL(early_date));
3460: FND_MESSAGE.SET_TOKEN('LATEST', FND_DATE.DATE_TO_CANONICAL(latest_date));
3461: l_exception_message := FND_MESSAGE.GET;
3462: ELSE
3463: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_TPDATES_DELIVERY');
3464: FND_MESSAGE.SET_TOKEN('EARLIEST', FND_DATE.DATE_TO_CANONICAL(early_date));
3465: FND_MESSAGE.SET_TOKEN('LATEST', FND_DATE.DATE_TO_CANONICAL(latest_date));
3466: l_exception_message := FND_MESSAGE.GET;
3467: END IF;

Line 3464: FND_MESSAGE.SET_TOKEN('EARLIEST', FND_DATE.DATE_TO_CANONICAL(early_date));

3460: FND_MESSAGE.SET_TOKEN('LATEST', FND_DATE.DATE_TO_CANONICAL(latest_date));
3461: l_exception_message := FND_MESSAGE.GET;
3462: ELSE
3463: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_TPDATES_DELIVERY');
3464: FND_MESSAGE.SET_TOKEN('EARLIEST', FND_DATE.DATE_TO_CANONICAL(early_date));
3465: FND_MESSAGE.SET_TOKEN('LATEST', FND_DATE.DATE_TO_CANONICAL(latest_date));
3466: l_exception_message := FND_MESSAGE.GET;
3467: END IF;
3468:

Line 3465: FND_MESSAGE.SET_TOKEN('LATEST', FND_DATE.DATE_TO_CANONICAL(latest_date));

3461: l_exception_message := FND_MESSAGE.GET;
3462: ELSE
3463: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_TPDATES_DELIVERY');
3464: FND_MESSAGE.SET_TOKEN('EARLIEST', FND_DATE.DATE_TO_CANONICAL(early_date));
3465: FND_MESSAGE.SET_TOKEN('LATEST', FND_DATE.DATE_TO_CANONICAL(latest_date));
3466: l_exception_message := FND_MESSAGE.GET;
3467: END IF;
3468:
3469: IF p_entity = 'DLVY' THEN

Line 3466: l_exception_message := FND_MESSAGE.GET;

3462: ELSE
3463: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_TPDATES_DELIVERY');
3464: FND_MESSAGE.SET_TOKEN('EARLIEST', FND_DATE.DATE_TO_CANONICAL(early_date));
3465: FND_MESSAGE.SET_TOKEN('LATEST', FND_DATE.DATE_TO_CANONICAL(latest_date));
3466: l_exception_message := FND_MESSAGE.GET;
3467: END IF;
3468:
3469: IF p_entity = 'DLVY' THEN
3470:

Line 3599: FND_MESSAGE.SET_NAME('WSH','WSH_SHIPSET_IGNORE_FOR_PLANG');

3595: IF l_debug_on THEN
3596: WSH_DEBUG_SV.log(l_module_name,'Log exception l_location_id',l_location_id);
3597: END IF;
3598: IF l_location_id IS NOT NULL THEN
3599: FND_MESSAGE.SET_NAME('WSH','WSH_SHIPSET_IGNORE_FOR_PLANG');
3600: FND_MESSAGE.SET_TOKEN('ENTITY',l_delivery_detail_id);
3601: l_exception_message := FND_MESSAGE.GET;
3602: WSH_XC_UTIL.log_exception(
3603: p_api_version => l_api_version,

Line 3600: FND_MESSAGE.SET_TOKEN('ENTITY',l_delivery_detail_id);

3596: WSH_DEBUG_SV.log(l_module_name,'Log exception l_location_id',l_location_id);
3597: END IF;
3598: IF l_location_id IS NOT NULL THEN
3599: FND_MESSAGE.SET_NAME('WSH','WSH_SHIPSET_IGNORE_FOR_PLANG');
3600: FND_MESSAGE.SET_TOKEN('ENTITY',l_delivery_detail_id);
3601: l_exception_message := FND_MESSAGE.GET;
3602: WSH_XC_UTIL.log_exception(
3603: p_api_version => l_api_version,
3604: p_init_msg_list => FND_API.G_FALSE,

Line 3601: l_exception_message := FND_MESSAGE.GET;

3597: END IF;
3598: IF l_location_id IS NOT NULL THEN
3599: FND_MESSAGE.SET_NAME('WSH','WSH_SHIPSET_IGNORE_FOR_PLANG');
3600: FND_MESSAGE.SET_TOKEN('ENTITY',l_delivery_detail_id);
3601: l_exception_message := FND_MESSAGE.GET;
3602: WSH_XC_UTIL.log_exception(
3603: p_api_version => l_api_version,
3604: p_init_msg_list => FND_API.G_FALSE,
3605: p_commit => FND_API.G_FALSE,

Line 3633: FND_MESSAGE.SET_NAME('WSH','WSH_SHIPSET_IGNORE_FOR_PLANG');

3629: IF l_debug_on THEN
3630: WSH_DEBUG_SV.log(l_module_name,'Log waring l_delivery_detail_id',l_delivery_detail_id);
3631: END IF;
3632: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3633: FND_MESSAGE.SET_NAME('WSH','WSH_SHIPSET_IGNORE_FOR_PLANG');
3634: FND_MESSAGE.SET_TOKEN('ENTITY',l_delivery_detail_id);
3635: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
3636: END IF;
3637: END IF;

Line 3634: FND_MESSAGE.SET_TOKEN('ENTITY',l_delivery_detail_id);

3630: WSH_DEBUG_SV.log(l_module_name,'Log waring l_delivery_detail_id',l_delivery_detail_id);
3631: END IF;
3632: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3633: FND_MESSAGE.SET_NAME('WSH','WSH_SHIPSET_IGNORE_FOR_PLANG');
3634: FND_MESSAGE.SET_TOKEN('ENTITY',l_delivery_detail_id);
3635: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
3636: END IF;
3637: END IF;
3638: CLOSE c_check_ignore_for_planning;