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: ELSE --Added for bug 7611042 .More than zero rows updated. So calling the API to update the hash string

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

530: END IF;
531: --
532: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
533: rollback to before_update;
534: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
535: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
536: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
537: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
538: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

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

531: --
532: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
533: rollback to before_update;
534: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
535: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
536: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
537: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
538: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
539: l_num_error:=l_num_error+1;

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

532: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
533: rollback to before_update;
534: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
535: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
536: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
537: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
538: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
539: l_num_error:=l_num_error+1;
540: goto next_trip;

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

533: rollback to before_update;
534: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
535: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
536: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
537: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
538: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
539: l_num_error:=l_num_error+1;
540: goto next_trip;
541: END IF;

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

552: END IF;
553: --
554: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
555: rollback to before_update;
556: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
557: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
558: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
559: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
560: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

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

553: --
554: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
555: rollback to before_update;
556: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
557: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
558: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
559: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
560: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
561: l_num_error:=l_num_error+1;

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

554: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
555: rollback to before_update;
556: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
557: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
558: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
559: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
560: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
561: l_num_error:=l_num_error+1;
562: goto next_trip;

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

555: rollback to before_update;
556: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
557: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
558: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
559: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
560: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
561: l_num_error:=l_num_error+1;
562: goto next_trip;
563: END IF;

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

575: END IF;
576: --
577: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
578: rollback to before_update;
579: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
580: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
581: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
582: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
583: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

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

576: --
577: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
578: rollback to before_update;
579: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
580: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
581: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
582: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
583: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
584: l_num_error:=l_num_error+1;

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

577: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
578: rollback to before_update;
579: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
580: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
581: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
582: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
583: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
584: l_num_error:=l_num_error+1;
585: goto next_trip;

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

578: rollback to before_update;
579: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
580: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
581: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
582: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
583: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
584: l_num_error:=l_num_error+1;
585: goto next_trip;
586: END IF;

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

631: --
632:
633: IF (SQL%NOTFOUND) THEN
634: rollback to before_update;
635: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
636: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
637: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
638: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
639: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

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

632:
633: IF (SQL%NOTFOUND) THEN
634: rollback to before_update;
635: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
636: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
637: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
638: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
639: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
640: l_num_error:=l_num_error+1;

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

633: IF (SQL%NOTFOUND) THEN
634: rollback to before_update;
635: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
636: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
637: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
638: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
639: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
640: l_num_error:=l_num_error+1;
641: END IF;

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

634: rollback to before_update;
635: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
636: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
637: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
638: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
639: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
640: l_num_error:=l_num_error+1;
641: END IF;
642:

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

645: END LOOP;
646:
647: --if all trips have problem show as error
648: IF l_num_error>0 AND l_num_error=p_in_ids.COUNT THEN
649: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');
650: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
651: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
652: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
653: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

646:
647: --if all trips have problem show as error
648: IF l_num_error>0 AND l_num_error=p_in_ids.COUNT THEN
649: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');
650: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
651: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
652: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
653: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
654: IF l_debug_on THEN

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

647: --if all trips have problem show as error
648: IF l_num_error>0 AND l_num_error=p_in_ids.COUNT THEN
649: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');
650: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
651: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
652: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
653: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
654: IF l_debug_on THEN
655: WSH_DEBUG_SV.pop(l_module_name);

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

669: l_tmp_detail_ids.delete;
670:
671: --1. check if trip the del is assigned to has diff ignore_plan value or is firm
672: FOR cur IN c_get_del_ignoreflag_difftrip(p_in_ids(i), l_ignoreplan) LOOP
673: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_ERROR');
674: FND_MESSAGE.SET_TOKEN('DEL_NAME',cur.delivery_name);
675: FND_MESSAGE.SET_TOKEN('TRIP_NAME',cur.trip_name);
676: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
677: l_num_error:=l_num_error+1;

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

670:
671: --1. check if trip the del is assigned to has diff ignore_plan value or is firm
672: FOR cur IN c_get_del_ignoreflag_difftrip(p_in_ids(i), l_ignoreplan) LOOP
673: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_ERROR');
674: FND_MESSAGE.SET_TOKEN('DEL_NAME',cur.delivery_name);
675: FND_MESSAGE.SET_TOKEN('TRIP_NAME',cur.trip_name);
676: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
677: l_num_error:=l_num_error+1;
678: GOTO next_del;

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

671: --1. check if trip the del is assigned to has diff ignore_plan value or is firm
672: FOR cur IN c_get_del_ignoreflag_difftrip(p_in_ids(i), l_ignoreplan) LOOP
673: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_ERROR');
674: FND_MESSAGE.SET_TOKEN('DEL_NAME',cur.delivery_name);
675: FND_MESSAGE.SET_TOKEN('TRIP_NAME',cur.trip_name);
676: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
677: l_num_error:=l_num_error+1;
678: GOTO next_del;
679: END LOOP;

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

695: IF l_debug_on THEN
696: 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);
697: END IF;
698:
699: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_TPW_ERROR');
700: FND_MESSAGE.SET_TOKEN('DEL_NAME',cur.delivery_name);
701: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
702: l_num_error:=l_num_error+1;
703: GOTO next_del;

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

696: 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);
697: END IF;
698:
699: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_TPW_ERROR');
700: FND_MESSAGE.SET_TOKEN('DEL_NAME',cur.delivery_name);
701: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
702: l_num_error:=l_num_error+1;
703: GOTO next_del;
704: END IF;

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

702: l_num_error:=l_num_error+1;
703: GOTO next_del;
704: END IF;
705: IF cur.delivery_type = 'CONSOLIDATION' THEN
706: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_MDC_ERROR');
707: FND_MESSAGE.SET_TOKEN('DEL_NAME',cur.delivery_name);
708: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
709: l_num_error:=l_num_error+1;
710: GOTO next_del;

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

703: GOTO next_del;
704: END IF;
705: IF cur.delivery_type = 'CONSOLIDATION' THEN
706: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_MDC_ERROR');
707: FND_MESSAGE.SET_TOKEN('DEL_NAME',cur.delivery_name);
708: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
709: l_num_error:=l_num_error+1;
710: GOTO next_del;
711: END IF;

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

719: IF l_ignoreplan='N' AND l_det_cur.source_code='WSH'
720: and l_det_cur.container_flag='N'
721: and l_gc3_is_installed = 'N' THEN -- OTM R12
722: --do not allow lines in thrid party instance to be set to include for planning
723: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_TPW_ERROR');
724: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_del_cur.delivery_id));
725: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
726: l_num_error:=l_num_error+1;
727: GOTO next_del;

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

720: and l_det_cur.container_flag='N'
721: and l_gc3_is_installed = 'N' THEN -- OTM R12
722: --do not allow lines in thrid party instance to be set to include for planning
723: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_TPW_ERROR');
724: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_del_cur.delivery_id));
725: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
726: l_num_error:=l_num_error+1;
727: GOTO next_del;
728: ELSE

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

864: last_updated_by = FND_GLOBAL.USER_ID
865: WHERE delivery_detail_id=l_tmp_detail_ids(i);
866: IF (SQL%NOTFOUND) THEN
867: ROLLBACK to before_update;
868: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
869: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
870: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
871: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
872: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

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

865: WHERE delivery_detail_id=l_tmp_detail_ids(i);
866: IF (SQL%NOTFOUND) THEN
867: ROLLBACK to before_update;
868: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
869: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
870: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
871: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
872: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
873: l_num_error:=l_num_error+1;

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

866: IF (SQL%NOTFOUND) THEN
867: ROLLBACK to before_update;
868: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
869: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
870: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
871: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
872: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
873: l_num_error:=l_num_error+1;
874: GOTO next_del;

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

867: ROLLBACK to before_update;
868: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
869: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
870: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
871: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
872: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
873: l_num_error:=l_num_error+1;
874: GOTO next_del;
875: END IF;

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

1022: l_temp := l_del_trip_tab.LAST;
1023: IF (l_del_trip_tab(l_temp).r_message_code = 'WMS_DELIVERY_LOADED_TO_DOCK')
1024: THEN--{
1025: ROLLBACK to before_update;
1026: FND_MESSAGE.SET_NAME(l_del_trip_tab(l_temp).r_message_appl,
1027: l_del_trip_tab(l_temp).r_message_code);
1028: FND_MESSAGE.SET_TOKEN(l_del_trip_tab(l_temp).r_message_token_name,
1029: l_del_trip_tab(l_temp).r_message_token);
1030: wsh_util_core.add_message(l_del_trip_tab(l_temp).r_message_type, l_module_name);

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

1024: THEN--{
1025: ROLLBACK to before_update;
1026: FND_MESSAGE.SET_NAME(l_del_trip_tab(l_temp).r_message_appl,
1027: l_del_trip_tab(l_temp).r_message_code);
1028: FND_MESSAGE.SET_TOKEN(l_del_trip_tab(l_temp).r_message_token_name,
1029: l_del_trip_tab(l_temp).r_message_token);
1030: wsh_util_core.add_message(l_del_trip_tab(l_temp).r_message_type, l_module_name);
1031: l_num_error:=l_num_error+1;
1032: GOTO next_del;

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

1052: WHERE delivery_id=p_in_ids(i);
1053:
1054: IF (SQL%NOTFOUND) THEN
1055: ROLLBACK to before_update;
1056: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1057: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1058: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1059: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
1060: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

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

1053:
1054: IF (SQL%NOTFOUND) THEN
1055: ROLLBACK to before_update;
1056: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1057: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1058: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1059: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
1060: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1061: l_num_error:=l_num_error+1;

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

1054: IF (SQL%NOTFOUND) THEN
1055: ROLLBACK to before_update;
1056: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1057: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1058: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1059: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
1060: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1061: l_num_error:=l_num_error+1;
1062: goto next_del;

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

1055: ROLLBACK to before_update;
1056: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1057: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1058: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1059: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
1060: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1061: l_num_error:=l_num_error+1;
1062: goto next_del;
1063: ELSE --Added for bug 7611042 .More than zero rows updated. So calling the API to update the hash string

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

1076: END IF;
1077: --
1078: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1079: rollback to before_update;
1080: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1081: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1082: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1083: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
1084: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

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

1077: --
1078: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1079: rollback to before_update;
1080: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1081: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1082: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1083: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
1084: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1085: l_num_error:=l_num_error+1;

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

1078: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1079: rollback to before_update;
1080: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1081: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1082: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1083: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
1084: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1085: l_num_error:=l_num_error+1;
1086: goto next_del;

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

1079: rollback to before_update;
1080: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1081: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1082: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1083: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
1084: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1085: l_num_error:=l_num_error+1;
1086: goto next_del;
1087: END IF;

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

1098: END IF;
1099: --
1100: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1101: rollback to before_update;
1102: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1103: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1104: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1105: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
1106: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

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

1099: --
1100: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1101: rollback to before_update;
1102: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1103: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1104: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1105: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
1106: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1107: l_num_error:=l_num_error+1;

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

1100: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1101: rollback to before_update;
1102: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1103: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1104: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1105: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
1106: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1107: l_num_error:=l_num_error+1;
1108: goto next_del;

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

1101: rollback to before_update;
1102: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1103: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1104: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1105: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
1106: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1107: l_num_error:=l_num_error+1;
1108: goto next_del;
1109: END IF;

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

1121: END IF;
1122: --
1123: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1124: rollback to before_update;
1125: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1126: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1127: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1128: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
1129: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

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

1122: --
1123: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1124: rollback to before_update;
1125: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1126: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1127: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1128: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
1129: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1130: l_num_error:=l_num_error+1;

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

1123: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1124: rollback to before_update;
1125: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1126: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1127: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1128: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
1129: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1130: l_num_error:=l_num_error+1;
1131: goto next_del;

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

1124: rollback to before_update;
1125: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1126: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1127: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1128: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
1129: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1130: l_num_error:=l_num_error+1;
1131: goto next_del;
1132: END IF;

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

1169: END LOOP;
1170:
1171: --if all dels have problem show as error
1172: IF l_num_error>0 AND l_num_error=p_in_ids.COUNT THEN
1173: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');
1174: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1175: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1176: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1177: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

1170:
1171: --if all dels have problem show as error
1172: IF l_num_error>0 AND l_num_error=p_in_ids.COUNT THEN
1173: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');
1174: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1175: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1176: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1177: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1178: IF l_debug_on THEN

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

1171: --if all dels have problem show as error
1172: IF l_num_error>0 AND l_num_error=p_in_ids.COUNT THEN
1173: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');
1174: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1175: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1176: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1177: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1178: IF l_debug_on THEN
1179: WSH_DEBUG_SV.pop(l_module_name);

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

1189:
1190: FOR i in 1..p_in_ids.COUNT LOOP
1191: --1. check if del the detail is assigned to has diff ignore_plan value or the del is planned/firm
1192: FOR cur IN c_get_det_ignoreflag_diff_del(p_in_ids(i), l_ignoreplan) LOOP
1193: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_ERROR_DETAIL');
1194: FND_MESSAGE.SET_TOKEN('DET_ID',p_in_ids(i));
1195: FND_MESSAGE.SET_TOKEN('DEL_NAME',cur.delivery_name);
1196: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1197: l_num_error:=l_num_error+1;

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

1190: FOR i in 1..p_in_ids.COUNT LOOP
1191: --1. check if del the detail is assigned to has diff ignore_plan value or the del is planned/firm
1192: FOR cur IN c_get_det_ignoreflag_diff_del(p_in_ids(i), l_ignoreplan) LOOP
1193: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_ERROR_DETAIL');
1194: FND_MESSAGE.SET_TOKEN('DET_ID',p_in_ids(i));
1195: FND_MESSAGE.SET_TOKEN('DEL_NAME',cur.delivery_name);
1196: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1197: l_num_error:=l_num_error+1;
1198: GOTO next_det;

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

1191: --1. check if del the detail is assigned to has diff ignore_plan value or the del is planned/firm
1192: FOR cur IN c_get_det_ignoreflag_diff_del(p_in_ids(i), l_ignoreplan) LOOP
1193: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_ERROR_DETAIL');
1194: FND_MESSAGE.SET_TOKEN('DET_ID',p_in_ids(i));
1195: FND_MESSAGE.SET_TOKEN('DEL_NAME',cur.delivery_name);
1196: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1197: l_num_error:=l_num_error+1;
1198: GOTO next_det;
1199: END LOOP;

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

1216: 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);
1217: WSH_DEBUG_SV.log(l_module_name,'source_code, container_flag',cur.source_code||cur.container_flag);
1218: END IF;
1219:
1220: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_DETTPW_ERROR');
1221: FND_MESSAGE.SET_TOKEN('DET_ID',p_in_ids(i));
1222: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1223: l_num_error:=l_num_error+1;
1224: GOTO next_det;

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

1217: WSH_DEBUG_SV.log(l_module_name,'source_code, container_flag',cur.source_code||cur.container_flag);
1218: END IF;
1219:
1220: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_DETTPW_ERROR');
1221: FND_MESSAGE.SET_TOKEN('DET_ID',p_in_ids(i));
1222: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1223: l_num_error:=l_num_error+1;
1224: GOTO next_det;
1225: END IF;

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

1228: END IF;
1229:
1230: --3. check if line is assigned to a container. if so, user has to perform from topmost entity
1231: FOR cur IN c_get_det_ignoreflag_diff_cont(p_in_ids(i), l_ignoreplan) LOOP
1232: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_DET_ASSN_CONT');
1233: FND_MESSAGE.SET_TOKEN('DET_ID',p_in_ids(i));
1234: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1235: l_num_error:=l_num_error+1;
1236: GOTO next_det;

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

1229:
1230: --3. check if line is assigned to a container. if so, user has to perform from topmost entity
1231: FOR cur IN c_get_det_ignoreflag_diff_cont(p_in_ids(i), l_ignoreplan) LOOP
1232: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_DET_ASSN_CONT');
1233: FND_MESSAGE.SET_TOKEN('DET_ID',p_in_ids(i));
1234: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1235: l_num_error:=l_num_error+1;
1236: GOTO next_det;
1237: END LOOP;

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

1264: WHERE delivery_detail_id=l_tmp_detail_ids(i)
1265: 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
1266: IF (SQL%NOTFOUND) THEN
1267: rollback to before_update;
1268: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1269: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_CONTAINER');
1270: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1271: FND_MESSAGE.SET_TOKEN('NAME',l_container_name);
1272: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

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

1265: 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
1266: IF (SQL%NOTFOUND) THEN
1267: rollback to before_update;
1268: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1269: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_CONTAINER');
1270: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1271: FND_MESSAGE.SET_TOKEN('NAME',l_container_name);
1272: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1273: l_num_error:=l_num_error+1;

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

1266: IF (SQL%NOTFOUND) THEN
1267: rollback to before_update;
1268: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1269: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_CONTAINER');
1270: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1271: FND_MESSAGE.SET_TOKEN('NAME',l_container_name);
1272: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1273: l_num_error:=l_num_error+1;
1274: GOTO next_det;

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

1267: rollback to before_update;
1268: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1269: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_CONTAINER');
1270: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1271: FND_MESSAGE.SET_TOKEN('NAME',l_container_name);
1272: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1273: l_num_error:=l_num_error+1;
1274: GOTO next_det;
1275: END IF;

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

1416: last_updated_by = FND_GLOBAL.USER_ID
1417: WHERE delivery_detail_id=p_in_ids(i);
1418: IF (SQL%NOTFOUND) THEN
1419: rollback to before_update;
1420: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1421: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_LINE');
1422: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1423: FND_MESSAGE.SET_TOKEN('NAME',p_in_ids(i));
1424: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

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

1417: WHERE delivery_detail_id=p_in_ids(i);
1418: IF (SQL%NOTFOUND) THEN
1419: rollback to before_update;
1420: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1421: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_LINE');
1422: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1423: FND_MESSAGE.SET_TOKEN('NAME',p_in_ids(i));
1424: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1425: l_num_error:=l_num_error+1;

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

1418: IF (SQL%NOTFOUND) THEN
1419: rollback to before_update;
1420: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1421: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_LINE');
1422: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1423: FND_MESSAGE.SET_TOKEN('NAME',p_in_ids(i));
1424: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1425: l_num_error:=l_num_error+1;
1426: END IF;

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

1419: rollback to before_update;
1420: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1421: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_LINE');
1422: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1423: FND_MESSAGE.SET_TOKEN('NAME',p_in_ids(i));
1424: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1425: l_num_error:=l_num_error+1;
1426: END IF;
1427: Check_Shipset_Ignoreflag( p_delivery_detail_id=>p_in_ids(i),

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

1441: END LOOP;
1442:
1443: --if all details have problem show as error
1444: IF l_num_error>0 AND l_num_error=p_in_ids.COUNT THEN
1445: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');
1446: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_LINE');
1447: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1448: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1449: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

1442:
1443: --if all details have problem show as error
1444: IF l_num_error>0 AND l_num_error=p_in_ids.COUNT THEN
1445: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');
1446: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_LINE');
1447: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1448: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1449: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1450: IF l_debug_on THEN

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

1443: --if all details have problem show as error
1444: IF l_num_error>0 AND l_num_error=p_in_ids.COUNT THEN
1445: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');
1446: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_LINE');
1447: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1448: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1449: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1450: IF l_debug_on THEN
1451: WSH_DEBUG_SV.pop(l_module_name);

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

1455: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1456: END IF;
1457: end if; --entity
1458: IF l_warn>0 THEN
1459: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_WARN');
1460: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_warning,l_module_name);
1461: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1462: END IF;
1463:

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

1579: wsh_delivery_validations.check_plan(p_delivery_id => del_cur.delivery_id,
1580: x_return_status => x_return_status);
1581: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1582: rollback to before_firm;
1583: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_CANNOT_FIRM');
1584: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));
1585: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1586: wsh_util_core.add_message(x_return_status);
1587: IF l_debug_on THEN

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

1580: x_return_status => x_return_status);
1581: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1582: rollback to before_firm;
1583: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_CANNOT_FIRM');
1584: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));
1585: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1586: wsh_util_core.add_message(x_return_status);
1587: IF l_debug_on THEN
1588: WSH_DEBUG_SV.pop(l_module_name);

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

1597: last_updated_by = FND_GLOBAL.USER_ID
1598: WHERE delivery_id = del_cur.delivery_id;
1599: --raise error to avoid inconsistency
1600: IF (SQL%NOTFOUND) THEN
1601: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1602: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1603: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1604: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));
1605: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

1598: WHERE delivery_id = del_cur.delivery_id;
1599: --raise error to avoid inconsistency
1600: IF (SQL%NOTFOUND) THEN
1601: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1602: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1603: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1604: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));
1605: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1606: wsh_util_core.add_message(x_return_status);

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

1599: --raise error to avoid inconsistency
1600: IF (SQL%NOTFOUND) THEN
1601: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1602: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1603: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1604: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));
1605: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1606: wsh_util_core.add_message(x_return_status);
1607: IF l_debug_on THEN

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

1600: IF (SQL%NOTFOUND) THEN
1601: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1602: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1603: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1604: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));
1605: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1606: wsh_util_core.add_message(x_return_status);
1607: IF l_debug_on THEN
1608: WSH_DEBUG_SV.pop(l_module_name);

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

1617: wsh_trip_validations.check_plan(p_trip_id => l_trips_cur.trip_id,
1618: x_return_status => x_return_status);
1619: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1620: rollback to before_firm;
1621: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_CANNOT_FIRM');
1622: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1623: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1624: wsh_util_core.add_message(x_return_status);
1625: IF l_debug_on THEN

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

1618: x_return_status => x_return_status);
1619: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1620: rollback to before_firm;
1621: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_CANNOT_FIRM');
1622: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1623: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1624: wsh_util_core.add_message(x_return_status);
1625: IF l_debug_on THEN
1626: WSH_DEBUG_SV.pop(l_module_name);

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

1637: last_updated_by = FND_GLOBAL.USER_ID
1638: WHERE trip_id = l_trips_cur.trip_id;
1639: --return error to avoid inconsistency
1640: IF (SQL%NOTFOUND) THEN
1641: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1642: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1643: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1644: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1645: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

1638: WHERE trip_id = l_trips_cur.trip_id;
1639: --return error to avoid inconsistency
1640: IF (SQL%NOTFOUND) THEN
1641: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1642: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1643: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1644: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1645: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1646: wsh_util_core.add_message(x_return_status);

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

1639: --return error to avoid inconsistency
1640: IF (SQL%NOTFOUND) THEN
1641: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1642: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1643: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1644: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1645: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1646: wsh_util_core.add_message(x_return_status);
1647: IF l_debug_on THEN

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

1640: IF (SQL%NOTFOUND) THEN
1641: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1642: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1643: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1644: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1645: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1646: wsh_util_core.add_message(x_return_status);
1647: IF l_debug_on THEN
1648: WSH_DEBUG_SV.pop(l_module_name);

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

1655: END LOOP;
1656:
1657: --if l_deliveries_exist is null, no deliveries exist for trip => trip can't be firmed
1658: IF l_deliveries_exist IS null THEN
1659: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_TRIP_ERROR');
1660: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_entity_id));
1661: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1662: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1663: IF l_debug_on THEN

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

1656:
1657: --if l_deliveries_exist is null, no deliveries exist for trip => trip can't be firmed
1658: IF l_deliveries_exist IS null THEN
1659: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_TRIP_ERROR');
1660: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_entity_id));
1661: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1662: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1663: IF l_debug_on THEN
1664: WSH_DEBUG_SV.pop(l_module_name);

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

1671: last_update_date = sysdate,
1672: last_updated_by = FND_GLOBAL.USER_ID
1673: WHERE trip_id = p_entity_id;
1674: IF (SQL%NOTFOUND) THEN
1675: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NOT_FOUND');
1676: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1677: wsh_util_core.add_message(x_return_status);
1678: IF l_debug_on THEN
1679: WSH_DEBUG_SV.pop(l_module_name);

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

1699: wsh_trip_validations.check_plan(p_trip_id => l_trips_cur.trip_id,
1700: x_return_status => x_return_status);
1701: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1702: rollback to before_firm;
1703: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_CANNOT_FIRM');
1704: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1705: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1706: wsh_util_core.add_message(x_return_status);
1707: IF l_debug_on THEN

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

1700: x_return_status => x_return_status);
1701: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1702: rollback to before_firm;
1703: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_CANNOT_FIRM');
1704: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1705: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1706: wsh_util_core.add_message(x_return_status);
1707: IF l_debug_on THEN
1708: WSH_DEBUG_SV.pop(l_module_name);

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

1717: WHERE trip_id = l_trips_cur.trip_id;
1718:
1719: --return error to avoid inconsistency
1720: IF (SQL%NOTFOUND) THEN
1721: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1722: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1723: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1724: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1725: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

1718:
1719: --return error to avoid inconsistency
1720: IF (SQL%NOTFOUND) THEN
1721: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1722: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1723: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1724: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1725: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1726: wsh_util_core.add_message(x_return_status);

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

1719: --return error to avoid inconsistency
1720: IF (SQL%NOTFOUND) THEN
1721: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1722: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1723: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1724: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1725: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1726: wsh_util_core.add_message(x_return_status);
1727: IF l_debug_on THEN

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

1720: IF (SQL%NOTFOUND) THEN
1721: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1722: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1723: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1724: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1725: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1726: wsh_util_core.add_message(x_return_status);
1727: IF l_debug_on THEN
1728: WSH_DEBUG_SV.pop(l_module_name);

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

1735: END LOOP;
1736:
1737: --if l_plannedflag is null, no trip is associated => delivery can't be firmed
1738: IF l_plannedflag IS null THEN
1739: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_DELIVERY_ERROR');
1740: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_entity_id));
1741: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1742: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1743: IF l_debug_on THEN

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

1736:
1737: --if l_plannedflag is null, no trip is associated => delivery can't be firmed
1738: IF l_plannedflag IS null THEN
1739: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_DELIVERY_ERROR');
1740: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_entity_id));
1741: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1742: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1743: IF l_debug_on THEN
1744: WSH_DEBUG_SV.pop(l_module_name);

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

1752: last_updated_by = FND_GLOBAL.USER_ID
1753: WHERE delivery_id = p_entity_id;
1754:
1755: IF (SQL%NOTFOUND) THEN
1756: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_NOT_FOUND');
1757: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1758: wsh_util_core.add_message(x_return_status);
1759: IF l_debug_on THEN
1760: WSH_DEBUG_SV.pop(l_module_name);

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

1889: last_updated_by = FND_GLOBAL.USER_ID
1890: WHERE trip_id = p_entity_id;
1891:
1892: IF (SQL%NOTFOUND) THEN
1893: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NOT_FOUND');
1894: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1895: wsh_util_core.add_message(x_return_status);
1896: IF l_debug_on THEN
1897: WSH_DEBUG_SV.pop(l_module_name);

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

1915: last_updated_by = FND_GLOBAL.USER_ID
1916: WHERE delivery_id = del_cur.delivery_id;
1917: --raise error to avoid inconsistency
1918: IF (SQL%NOTFOUND) THEN
1919: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1920: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1921: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1922: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));
1923: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

1916: WHERE delivery_id = del_cur.delivery_id;
1917: --raise error to avoid inconsistency
1918: IF (SQL%NOTFOUND) THEN
1919: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1920: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1921: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1922: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));
1923: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1924: wsh_util_core.add_message(x_return_status);

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

1917: --raise error to avoid inconsistency
1918: IF (SQL%NOTFOUND) THEN
1919: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1920: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1921: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1922: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));
1923: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1924: wsh_util_core.add_message(x_return_status);
1925: IF l_debug_on THEN

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

1918: IF (SQL%NOTFOUND) THEN
1919: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1920: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1921: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1922: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));
1923: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1924: wsh_util_core.add_message(x_return_status);
1925: IF l_debug_on THEN
1926: WSH_DEBUG_SV.pop(l_module_name);

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

1937: last_updated_by = FND_GLOBAL.USER_ID
1938: WHERE trip_id = l_trips_cur.trip_id;
1939: --raise error to avoid inconsistency
1940: IF (SQL%NOTFOUND) THEN
1941: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1942: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1943: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1944: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1945: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

1938: WHERE trip_id = l_trips_cur.trip_id;
1939: --raise error to avoid inconsistency
1940: IF (SQL%NOTFOUND) THEN
1941: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1942: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1943: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1944: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1945: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1946: wsh_util_core.add_message(x_return_status);

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

1939: --raise error to avoid inconsistency
1940: IF (SQL%NOTFOUND) THEN
1941: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1942: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1943: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1944: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1945: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1946: wsh_util_core.add_message(x_return_status);
1947: IF l_debug_on THEN

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

1940: IF (SQL%NOTFOUND) THEN
1941: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1942: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1943: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1944: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1945: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1946: wsh_util_core.add_message(x_return_status);
1947: IF l_debug_on THEN
1948: WSH_DEBUG_SV.pop(l_module_name);

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

1962: last_updated_by = FND_GLOBAL.USER_ID
1963: WHERE delivery_id = p_entity_id;
1964:
1965: IF (SQL%NOTFOUND) THEN
1966: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_NOT_FOUND');
1967: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1968: wsh_util_core.add_message(x_return_status);
1969: IF l_debug_on THEN
1970: WSH_DEBUG_SV.pop(l_module_name);

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

1981: WHERE trip_id = cur_deltrip.trip_id;
1982:
1983: --raise error to avoid inconsistency
1984: IF (SQL%NOTFOUND) THEN
1985: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1986: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1987: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1988: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_entity_id));
1989: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

1982:
1983: --raise error to avoid inconsistency
1984: IF (SQL%NOTFOUND) THEN
1985: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1986: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1987: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1988: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_entity_id));
1989: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1990: wsh_util_core.add_message(x_return_status);

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

1983: --raise error to avoid inconsistency
1984: IF (SQL%NOTFOUND) THEN
1985: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1986: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1987: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1988: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_entity_id));
1989: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1990: wsh_util_core.add_message(x_return_status);
1991: IF l_debug_on THEN

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

1984: IF (SQL%NOTFOUND) THEN
1985: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1986: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1987: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1988: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_entity_id));
1989: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1990: wsh_util_core.add_message(x_return_status);
1991: IF l_debug_on THEN
1992: WSH_DEBUG_SV.pop(l_module_name);

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

3230: IF is_inbound_dropshp%ISOPEN THEN
3231: CLOSE is_inbound_dropshp;
3232: END IF;
3233:
3234: FND_MESSAGE.SET_NAME('WSH','WSH_NO_LOCK');
3235: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
3236: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
3237:
3238: IF l_debug_on THEN

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

3601: l_exception_name := 'WSH_INVALID_TPDATES';
3602: l_logging_entity := 'SHIPPER';
3603:
3604: IF p_pick_up THEN
3605: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_TPDATES_SHIP');
3606: FND_MESSAGE.SET_TOKEN('EARLIEST', FND_DATE.DATE_TO_CANONICAL(early_date));
3607: FND_MESSAGE.SET_TOKEN('LATEST', FND_DATE.DATE_TO_CANONICAL(latest_date));
3608: l_exception_message := FND_MESSAGE.GET;
3609: ELSE

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

3602: l_logging_entity := 'SHIPPER';
3603:
3604: IF p_pick_up THEN
3605: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_TPDATES_SHIP');
3606: FND_MESSAGE.SET_TOKEN('EARLIEST', FND_DATE.DATE_TO_CANONICAL(early_date));
3607: FND_MESSAGE.SET_TOKEN('LATEST', FND_DATE.DATE_TO_CANONICAL(latest_date));
3608: l_exception_message := FND_MESSAGE.GET;
3609: ELSE
3610: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_TPDATES_DELIVERY');

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

3603:
3604: IF p_pick_up THEN
3605: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_TPDATES_SHIP');
3606: FND_MESSAGE.SET_TOKEN('EARLIEST', FND_DATE.DATE_TO_CANONICAL(early_date));
3607: FND_MESSAGE.SET_TOKEN('LATEST', FND_DATE.DATE_TO_CANONICAL(latest_date));
3608: l_exception_message := FND_MESSAGE.GET;
3609: ELSE
3610: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_TPDATES_DELIVERY');
3611: FND_MESSAGE.SET_TOKEN('EARLIEST', FND_DATE.DATE_TO_CANONICAL(early_date));

Line 3608: l_exception_message := FND_MESSAGE.GET;

3604: IF p_pick_up THEN
3605: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_TPDATES_SHIP');
3606: FND_MESSAGE.SET_TOKEN('EARLIEST', FND_DATE.DATE_TO_CANONICAL(early_date));
3607: FND_MESSAGE.SET_TOKEN('LATEST', FND_DATE.DATE_TO_CANONICAL(latest_date));
3608: l_exception_message := FND_MESSAGE.GET;
3609: ELSE
3610: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_TPDATES_DELIVERY');
3611: FND_MESSAGE.SET_TOKEN('EARLIEST', FND_DATE.DATE_TO_CANONICAL(early_date));
3612: FND_MESSAGE.SET_TOKEN('LATEST', FND_DATE.DATE_TO_CANONICAL(latest_date));

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

3606: FND_MESSAGE.SET_TOKEN('EARLIEST', FND_DATE.DATE_TO_CANONICAL(early_date));
3607: FND_MESSAGE.SET_TOKEN('LATEST', FND_DATE.DATE_TO_CANONICAL(latest_date));
3608: l_exception_message := FND_MESSAGE.GET;
3609: ELSE
3610: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_TPDATES_DELIVERY');
3611: FND_MESSAGE.SET_TOKEN('EARLIEST', FND_DATE.DATE_TO_CANONICAL(early_date));
3612: FND_MESSAGE.SET_TOKEN('LATEST', FND_DATE.DATE_TO_CANONICAL(latest_date));
3613: l_exception_message := FND_MESSAGE.GET;
3614: END IF;

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

3607: FND_MESSAGE.SET_TOKEN('LATEST', FND_DATE.DATE_TO_CANONICAL(latest_date));
3608: l_exception_message := FND_MESSAGE.GET;
3609: ELSE
3610: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_TPDATES_DELIVERY');
3611: FND_MESSAGE.SET_TOKEN('EARLIEST', FND_DATE.DATE_TO_CANONICAL(early_date));
3612: FND_MESSAGE.SET_TOKEN('LATEST', FND_DATE.DATE_TO_CANONICAL(latest_date));
3613: l_exception_message := FND_MESSAGE.GET;
3614: END IF;
3615:

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

3608: l_exception_message := FND_MESSAGE.GET;
3609: ELSE
3610: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_TPDATES_DELIVERY');
3611: FND_MESSAGE.SET_TOKEN('EARLIEST', FND_DATE.DATE_TO_CANONICAL(early_date));
3612: FND_MESSAGE.SET_TOKEN('LATEST', FND_DATE.DATE_TO_CANONICAL(latest_date));
3613: l_exception_message := FND_MESSAGE.GET;
3614: END IF;
3615:
3616: IF p_entity = 'DLVY' THEN

Line 3613: l_exception_message := FND_MESSAGE.GET;

3609: ELSE
3610: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_TPDATES_DELIVERY');
3611: FND_MESSAGE.SET_TOKEN('EARLIEST', FND_DATE.DATE_TO_CANONICAL(early_date));
3612: FND_MESSAGE.SET_TOKEN('LATEST', FND_DATE.DATE_TO_CANONICAL(latest_date));
3613: l_exception_message := FND_MESSAGE.GET;
3614: END IF;
3615:
3616: IF p_entity = 'DLVY' THEN
3617:

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

3742: IF l_debug_on THEN
3743: WSH_DEBUG_SV.log(l_module_name,'Log exception l_location_id',l_location_id);
3744: END IF;
3745: IF l_location_id IS NOT NULL THEN
3746: FND_MESSAGE.SET_NAME('WSH','WSH_SHIPSET_IGNORE_FOR_PLANG');
3747: FND_MESSAGE.SET_TOKEN('ENTITY',l_delivery_detail_id);
3748: l_exception_message := FND_MESSAGE.GET;
3749: WSH_XC_UTIL.log_exception(
3750: p_api_version => l_api_version,

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

3743: WSH_DEBUG_SV.log(l_module_name,'Log exception l_location_id',l_location_id);
3744: END IF;
3745: IF l_location_id IS NOT NULL THEN
3746: FND_MESSAGE.SET_NAME('WSH','WSH_SHIPSET_IGNORE_FOR_PLANG');
3747: FND_MESSAGE.SET_TOKEN('ENTITY',l_delivery_detail_id);
3748: l_exception_message := FND_MESSAGE.GET;
3749: WSH_XC_UTIL.log_exception(
3750: p_api_version => l_api_version,
3751: p_init_msg_list => FND_API.G_FALSE,

Line 3748: l_exception_message := FND_MESSAGE.GET;

3744: END IF;
3745: IF l_location_id IS NOT NULL THEN
3746: FND_MESSAGE.SET_NAME('WSH','WSH_SHIPSET_IGNORE_FOR_PLANG');
3747: FND_MESSAGE.SET_TOKEN('ENTITY',l_delivery_detail_id);
3748: l_exception_message := FND_MESSAGE.GET;
3749: WSH_XC_UTIL.log_exception(
3750: p_api_version => l_api_version,
3751: p_init_msg_list => FND_API.G_FALSE,
3752: p_commit => FND_API.G_FALSE,

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

3776: IF l_debug_on THEN
3777: WSH_DEBUG_SV.log(l_module_name,'Log waring l_delivery_detail_id',l_delivery_detail_id);
3778: END IF;
3779: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3780: FND_MESSAGE.SET_NAME('WSH','WSH_SHIPSET_IGNORE_FOR_PLANG');
3781: FND_MESSAGE.SET_TOKEN('ENTITY',l_delivery_detail_id);
3782: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
3783: END IF;
3784: END IF;

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

3777: WSH_DEBUG_SV.log(l_module_name,'Log waring l_delivery_detail_id',l_delivery_detail_id);
3778: END IF;
3779: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3780: FND_MESSAGE.SET_NAME('WSH','WSH_SHIPSET_IGNORE_FOR_PLANG');
3781: FND_MESSAGE.SET_TOKEN('ENTITY',l_delivery_detail_id);
3782: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
3783: END IF;
3784: END IF;
3785: CLOSE c_check_ignore_for_planning;