DBA Data[Home] [Help]

APPS.WSH_CONTAINER_UTILITIES dependencies on FND_MESSAGE

Line 434: FND_MESSAGE.SET_NAME('WSH','WSH_DET_INVALID_DETAIL');

430:
431: IF (Get_Delivery_Details%NOTFOUND) THEN
432: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
433: -- dbms_output.put_line('no delivery details');
434: FND_MESSAGE.SET_NAME('WSH','WSH_DET_INVALID_DETAIL');
435: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_in_record.delivery_detail_id);
436: CLOSE Get_Delivery_Details;
437: WSH_UTIL_CORE.Add_Message(x_return_status);
438: --

Line 435: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_in_record.delivery_detail_id);

431: IF (Get_Delivery_Details%NOTFOUND) THEN
432: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
433: -- dbms_output.put_line('no delivery details');
434: FND_MESSAGE.SET_NAME('WSH','WSH_DET_INVALID_DETAIL');
435: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_in_record.delivery_detail_id);
436: CLOSE Get_Delivery_Details;
437: WSH_UTIL_CORE.Add_Message(x_return_status);
438: --
439: -- Debug Statements

Line 477: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONT_LOAD');

473: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
474: END IF;
475: --
476: l_org_name := WSH_UTIL_CORE.Get_Org_Name(p_in_record.organization_id);
477: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONT_LOAD');
478: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
479: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
480: -- dbms_output.put_line('error in get cont load');
481: CLOSE Get_Cont_Load;

Line 478: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);

474: END IF;
475: --
476: l_org_name := WSH_UTIL_CORE.Get_Org_Name(p_in_record.organization_id);
477: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONT_LOAD');
478: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
479: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
480: -- dbms_output.put_line('error in get cont load');
481: CLOSE Get_Cont_Load;
482: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 479: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);

475: --
476: l_org_name := WSH_UTIL_CORE.Get_Org_Name(p_in_record.organization_id);
477: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONT_LOAD');
478: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
479: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
480: -- dbms_output.put_line('error in get cont load');
481: CLOSE Get_Cont_Load;
482: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
483: WSH_UTIL_CORE.Add_Message(x_return_status);

Line 529: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');

525: -- raise container_item_error;
526: CLOSE Get_Container_Info;
527: -- dbms_output.put_line('container not found');
528: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
529: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
530: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_lpn);
531: WSH_UTIL_CORE.Add_Message(x_return_status);
532: --
533: -- Debug Statements

Line 530: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_lpn);

526: CLOSE Get_Container_Info;
527: -- dbms_output.put_line('container not found');
528: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
529: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
530: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_lpn);
531: WSH_UTIL_CORE.Add_Message(x_return_status);
532: --
533: -- Debug Statements
534: --

Line 554: -- FND_MESSAGE.SET_NAME('WSH','WSH_CONT_EST_ERROR');

550:
551: IF (x_inout_record.container_item_id IS NULL) THEN
552: -- it means that no container defined for this item type
553: -- raise container_item_error;
554: -- FND_MESSAGE.SET_NAME('WSH','WSH_CONT_EST_ERROR');
555: -- dbms_output.put_line('no container item');
556: -- WSH_UTIL_CORE.Add_Message(x_return_status);
557: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
558: --

Line 586: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_INV_ITEM');

582: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ITEM_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
583: END IF;
584: --
585: l_item_name := WSH_UTIL_CORE.Get_Item_Name(x_inout_record.container_item_id,nvl(p_in_record.organization_id,l_dd_org_id));
586: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_INV_ITEM');
587: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
588: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
589: CLOSE Get_Cont_Msi;
590: WSH_UTIL_CORE.Add_Message(x_return_status);

Line 587: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);

583: END IF;
584: --
585: l_item_name := WSH_UTIL_CORE.Get_Item_Name(x_inout_record.container_item_id,nvl(p_in_record.organization_id,l_dd_org_id));
586: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_INV_ITEM');
587: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
588: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
589: CLOSE Get_Cont_Msi;
590: WSH_UTIL_CORE.Add_Message(x_return_status);
591: --

Line 647: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_ERROR');

643: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
644: END IF;
645: --
646: l_org_name := WSH_UTIL_CORE.Get_Org_Name(p_in_record.organization_id);
647: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_ERROR');
648: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
649: -- dbms_output.put_line('fill percent not defined');
650: CLOSE Get_Fill_Basis;
651: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 648: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);

644: END IF;
645: --
646: l_org_name := WSH_UTIL_CORE.Get_Org_Name(p_in_record.organization_id);
647: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_ERROR');
648: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
649: -- dbms_output.put_line('fill percent not defined');
650: CLOSE Get_Fill_Basis;
651: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
652: WSH_UTIL_CORE.Add_Message(x_return_status);

Line 691: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_LOAD_QTY_ERROR');

687:
688: ELSE
689:
690: x_out_record.num_cont := 0;
691: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_LOAD_QTY_ERROR');
692: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
693: WSH_UTIL_CORE.Add_Message(x_return_status);
694: --
695: -- Debug Statements

Line 751: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_LOAD_ERROR');

747: IF l_max_load_wt > 0 THEN
748: l_num_cont := (l_dd_net_wt/l_max_load_wt);
749: l_fill_pc_flag := 'W';
750: ELSE
751: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_LOAD_ERROR');
752: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
753: WSH_UTIL_CORE.Add_Message(x_return_status);
754: x_out_record.num_cont := 0;
755: --

Line 772: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_VOL_ERROR');

768: IF l_max_volume > 0 THEN
769: l_num_cont := (l_dd_volume/l_max_volume);
770: l_fill_pc_flag := 'V';
771: ELSE
772: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_VOL_ERROR');
773: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
774: WSH_UTIL_CORE.Add_Message(x_return_status);
775: x_out_record.num_cont := 0;
776: --

Line 799: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_WT_ERROR');

795: l_fill_pc_flag := 'V';
796: END IF;
797: --dbms_output.put_line('using qty with NO CONTAINER LOAD' || l_num_cont);
798: ELSE
799: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_WT_ERROR');
800: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
801: WSH_UTIL_CORE.Add_Message(x_return_status);
802: x_out_record.num_cont := 0;
803: --

Line 821: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_ERROR');

817: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
818: END IF;
819: --
820: l_org_name := WSH_UTIL_CORE.Get_Org_Name(nvl(p_in_record.organization_id,l_dd_org_id));
821: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_ERROR');
822: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
823: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
824: WSH_UTIL_CORE.Add_Message(x_return_status);
825: --

Line 822: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);

818: END IF;
819: --
820: l_org_name := WSH_UTIL_CORE.Get_Org_Name(nvl(p_in_record.organization_id,l_dd_org_id));
821: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_ERROR');
822: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
823: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
824: WSH_UTIL_CORE.Add_Message(x_return_status);
825: --
826: -- Debug Statements

Line 844: FND_MESSAGE.SET_NAME('WSH', 'WSH_NULL_WEIGHT_VOLUME');

840: -- weight or volume value or max load quantity is zero.
841: -- We also should catch the case when value is NULL.
842: -- (This is the overloaded procedure with records as parameters.)
843: IF NVL(l_num_cont, 0) = 0 THEN
844: FND_MESSAGE.SET_NAME('WSH', 'WSH_NULL_WEIGHT_VOLUME');
845: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL',p_in_record.delivery_detail_id);
846: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
847: WSH_UTIL_CORE.Add_Message(x_return_status);
848: x_out_record.num_cont := 0;

Line 845: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL',p_in_record.delivery_detail_id);

841: -- We also should catch the case when value is NULL.
842: -- (This is the overloaded procedure with records as parameters.)
843: IF NVL(l_num_cont, 0) = 0 THEN
844: FND_MESSAGE.SET_NAME('WSH', 'WSH_NULL_WEIGHT_VOLUME');
845: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL',p_in_record.delivery_detail_id);
846: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
847: WSH_UTIL_CORE.Add_Message(x_return_status);
848: x_out_record.num_cont := 0;
849: --

Line 896: l_discard_message := FND_MESSAGE.GET;

892: -- or if item indivisible flag is set to Y
893: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS OR
894: l_item_indivisible = 'Y'
895: )THEN
896: l_discard_message := FND_MESSAGE.GET;
897:
898: l_tmp_num_cont := FLOOR(l_dd_packed_qty/l_num_cont);
899:
900: IF (l_tmp_num_cont = 0) THEN

Line 902: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_WT_VOL_ERROR');

898: l_tmp_num_cont := FLOOR(l_dd_packed_qty/l_num_cont);
899:
900: IF (l_tmp_num_cont = 0) THEN
901: -- Bug#: 2503937 - New Error Message
902: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_WT_VOL_ERROR');
903: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
904: WSH_UTIL_CORE.Add_Message(x_return_status);
905: x_out_record.num_cont := 0;
906: --

Line 1194: FND_MESSAGE.SET_NAME('WSH','WSH_DET_INVALID_DETAIL');

1190:
1191: IF (Get_Delivery_Details%NOTFOUND) THEN
1192: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1193: --dbms_output.put_line('no delivery details');
1194: FND_MESSAGE.SET_NAME('WSH','WSH_DET_INVALID_DETAIL');
1195: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_delivery_detail_id);
1196: CLOSE Get_Delivery_Details;
1197: WSH_UTIL_CORE.Add_Message(x_return_status);
1198: --

Line 1195: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_delivery_detail_id);

1191: IF (Get_Delivery_Details%NOTFOUND) THEN
1192: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1193: --dbms_output.put_line('no delivery details');
1194: FND_MESSAGE.SET_NAME('WSH','WSH_DET_INVALID_DETAIL');
1195: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_delivery_detail_id);
1196: CLOSE Get_Delivery_Details;
1197: WSH_UTIL_CORE.Add_Message(x_return_status);
1198: --
1199: -- Debug Statements

Line 1237: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONT_LOAD');

1233: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1234: END IF;
1235: --
1236: l_org_name := WSH_UTIL_CORE.Get_Org_Name(p_organization_id);
1237: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONT_LOAD');
1238: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1239: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
1240: CLOSE Get_Cont_Load;
1241: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1238: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);

1234: END IF;
1235: --
1236: l_org_name := WSH_UTIL_CORE.Get_Org_Name(p_organization_id);
1237: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONT_LOAD');
1238: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1239: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
1240: CLOSE Get_Cont_Load;
1241: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1242: WSH_UTIL_CORE.Add_Message(x_return_status);

Line 1239: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);

1235: --
1236: l_org_name := WSH_UTIL_CORE.Get_Org_Name(p_organization_id);
1237: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONT_LOAD');
1238: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1239: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
1240: CLOSE Get_Cont_Load;
1241: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1242: WSH_UTIL_CORE.Add_Message(x_return_status);
1243: --

Line 1287: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');

1283: -- raise container_item_error;
1284: CLOSE Get_Container_Info;
1285: -- dbms_output.put_line('container not found');
1286: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1287: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
1288: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_lpn);
1289: WSH_UTIL_CORE.Add_Message(x_return_status);
1290: --
1291: -- Debug Statements

Line 1288: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_lpn);

1284: CLOSE Get_Container_Info;
1285: -- dbms_output.put_line('container not found');
1286: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1287: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
1288: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_lpn);
1289: WSH_UTIL_CORE.Add_Message(x_return_status);
1290: --
1291: -- Debug Statements
1292: --

Line 1311: -- FND_MESSAGE.SET_NAME('WSH','WSH_CONT_EST_ERROR');

1307:
1308: IF (x_container_item_id IS NULL) THEN
1309: -- it means that no container defined for this item type
1310: -- raise container_item_error;
1311: -- FND_MESSAGE.SET_NAME('WSH','WSH_CONT_EST_ERROR');
1312: -- dbms_output.put_line('no container item');
1313: -- WSH_UTIL_CORE.Add_Message(x_return_status);
1314: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1315: --

Line 1342: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_INV_ITEM');

1338: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ITEM_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1339: END IF;
1340: --
1341: l_item_name := WSH_UTIL_CORE.Get_Item_Name(x_container_item_id,nvl(p_organization_id,l_dd_org_id));
1342: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_INV_ITEM');
1343: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1344: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1345: CLOSE Get_Cont_Msi;
1346: WSH_UTIL_CORE.Add_Message(x_return_status);

Line 1343: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);

1339: END IF;
1340: --
1341: l_item_name := WSH_UTIL_CORE.Get_Item_Name(x_container_item_id,nvl(p_organization_id,l_dd_org_id));
1342: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_INV_ITEM');
1343: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1344: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1345: CLOSE Get_Cont_Msi;
1346: WSH_UTIL_CORE.Add_Message(x_return_status);
1347: --

Line 1403: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_ERROR');

1399: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1400: END IF;
1401: --
1402: l_org_name := WSH_UTIL_CORE.Get_Org_Name(p_organization_id);
1403: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_ERROR');
1404: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
1405: -- dbms_output.put_line('fill percent not defined');
1406: CLOSE Get_Fill_Basis;
1407: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1404: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);

1400: END IF;
1401: --
1402: l_org_name := WSH_UTIL_CORE.Get_Org_Name(p_organization_id);
1403: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_ERROR');
1404: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
1405: -- dbms_output.put_line('fill percent not defined');
1406: CLOSE Get_Fill_Basis;
1407: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1408: WSH_UTIL_CORE.Add_Message(x_return_status);

Line 1442: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_LOAD_QTY_ERROR');

1438:
1439: CLOSE Get_Cont_Load;
1440:
1441: x_num_cont := 0;
1442: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_LOAD_QTY_ERROR');
1443: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1444: WSH_UTIL_CORE.Add_Message(x_return_status);
1445: --
1446: -- Debug Statements

Line 1503: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_LOAD_ERROR');

1499: IF l_max_load_wt > 0 THEN
1500:
1501: l_num_cont := (l_dd_net_wt/l_max_load_wt);
1502: ELSE
1503: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_LOAD_ERROR');
1504: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1505: WSH_UTIL_CORE.Add_Message(x_return_status);
1506: x_num_cont := 0;
1507: --

Line 1524: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_VOL_ERROR');

1520:
1521: l_num_cont := (l_dd_volume/l_max_volume);
1522:
1523: ELSE
1524: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_VOL_ERROR');
1525: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1526: WSH_UTIL_CORE.Add_Message(x_return_status);
1527: x_num_cont := 0;
1528: --

Line 1548: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_WT_ERROR');

1544: ELSE
1545: l_num_cont := (l_dd_volume/l_max_volume);
1546: END IF;
1547: ELSE
1548: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_WT_ERROR');
1549: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1550: WSH_UTIL_CORE.Add_Message(x_return_status);
1551: x_num_cont := 0;
1552: --

Line 1570: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_ERROR');

1566: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1567: END IF;
1568: --
1569: l_org_name := WSH_UTIL_CORE.Get_Org_Name(nvl(p_organization_id,l_dd_org_id));
1570: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_ERROR');
1571: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
1572: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1573: WSH_UTIL_CORE.Add_Message(x_return_status);
1574: --

Line 1571: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);

1567: END IF;
1568: --
1569: l_org_name := WSH_UTIL_CORE.Get_Org_Name(nvl(p_organization_id,l_dd_org_id));
1570: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_ERROR');
1571: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
1572: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1573: WSH_UTIL_CORE.Add_Message(x_return_status);
1574: --
1575: -- Debug Statements

Line 1590: FND_MESSAGE.SET_NAME('WSH', 'WSH_NULL_WEIGHT_VOLUME');

1586: -- weight or volume value or max load quantity is zero.
1587: -- We also should catch the case when value is NULL.
1588: -- (This is the original API with multiple IN parameters)
1589: IF NVL(l_num_cont, 0) = 0 THEN
1590: FND_MESSAGE.SET_NAME('WSH', 'WSH_NULL_WEIGHT_VOLUME');
1591: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL', p_delivery_detail_id);
1592: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1593: WSH_UTIL_CORE.Add_Message(x_return_status);
1594: x_num_cont := 0;

Line 1591: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL', p_delivery_detail_id);

1587: -- We also should catch the case when value is NULL.
1588: -- (This is the original API with multiple IN parameters)
1589: IF NVL(l_num_cont, 0) = 0 THEN
1590: FND_MESSAGE.SET_NAME('WSH', 'WSH_NULL_WEIGHT_VOLUME');
1591: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL', p_delivery_detail_id);
1592: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1593: WSH_UTIL_CORE.Add_Message(x_return_status);
1594: x_num_cont := 0;
1595: --

Line 1628: l_discard_message := FND_MESSAGE.GET;

1624:
1625:
1626: -- errors likely mean integers are safe values.
1627: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1628: l_discard_message := FND_MESSAGE.GET;
1629:
1630: l_tmp_num_cont := FLOOR(l_dd_packed_qty/l_num_cont);
1631:
1632: IF (l_tmp_num_cont = 0) THEN

Line 1634: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_WT_VOL_ERROR');

1630: l_tmp_num_cont := FLOOR(l_dd_packed_qty/l_num_cont);
1631:
1632: IF (l_tmp_num_cont = 0) THEN
1633: -- Bug#: 2503937 - New Error Message
1634: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_WT_VOL_ERROR');
1635: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1636: WSH_UTIL_CORE.Add_Message(x_return_status);
1637: x_num_cont := 0;
1638: --

Line 1848: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');

1844:
1845: IF Get_Container_Info%NOTFOUND THEN
1846: CLOSE Get_Container_Info;
1847: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1848: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
1849: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_lpn);
1850: WSH_UTIL_CORE.Add_Message(x_return_status);
1851: --
1852: -- Debug Statements

Line 1849: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_lpn);

1845: IF Get_Container_Info%NOTFOUND THEN
1846: CLOSE Get_Container_Info;
1847: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1848: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
1849: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_lpn);
1850: WSH_UTIL_CORE.Add_Message(x_return_status);
1851: --
1852: -- Debug Statements
1853: --

Line 1868: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');

1864: l_cont_item_id := NVL(p_det_cont_item_id,l_cont_item_id);
1865:
1866: ELSE
1867:
1868: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
1869: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1870: WSH_UTIL_CORE.Add_Message(x_return_status);
1871: --
1872: -- Debug Statements

Line 1905: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONT_LOAD');

1901: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1902: END IF;
1903: --
1904: l_org_name := WSH_UTIL_CORE.Get_Org_Name(p_organization_id);
1905: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONT_LOAD');
1906: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1907: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
1908: -- dbms_output.put_line('error in get cont load');
1909: CLOSE Get_Cont_Load;

Line 1906: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);

1902: END IF;
1903: --
1904: l_org_name := WSH_UTIL_CORE.Get_Org_Name(p_organization_id);
1905: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONT_LOAD');
1906: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1907: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
1908: -- dbms_output.put_line('error in get cont load');
1909: CLOSE Get_Cont_Load;
1910: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1907: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);

1903: --
1904: l_org_name := WSH_UTIL_CORE.Get_Org_Name(p_organization_id);
1905: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONT_LOAD');
1906: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1907: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
1908: -- dbms_output.put_line('error in get cont load');
1909: CLOSE Get_Cont_Load;
1910: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1911: WSH_UTIL_CORE.Add_Message(x_return_status);

Line 1931: -- FND_MESSAGE.SET_NAME('WSH','WSH_CONT_EST_ERROR');

1927:
1928: IF (x_mast_cont_item_id IS NULL) THEN
1929: -- it means that no container defined for this item type
1930: -- raise container_item_error;
1931: -- FND_MESSAGE.SET_NAME('WSH','WSH_CONT_EST_ERROR');
1932: -- dbms_output.put_line('no container item');
1933: -- WSH_UTIL_CORE.Add_Message(x_return_status);
1934: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1935: --

Line 1962: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_INV_ITEM');

1958: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ITEM_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1959: END IF;
1960: --
1961: l_item_name := WSH_UTIL_CORE.Get_Item_Name(x_mast_cont_item_id,p_organization_id);
1962: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_INV_ITEM');
1963: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1964: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1965: CLOSE Get_Cont_Msi;
1966: WSH_UTIL_CORE.Add_Message(x_return_status);

Line 1963: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);

1959: END IF;
1960: --
1961: l_item_name := WSH_UTIL_CORE.Get_Item_Name(x_mast_cont_item_id,p_organization_id);
1962: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_INV_ITEM');
1963: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1964: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1965: CLOSE Get_Cont_Msi;
1966: WSH_UTIL_CORE.Add_Message(x_return_status);
1967: --

Line 2022: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_ERROR');

2018: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2019: END IF;
2020: --
2021: l_org_name := WSH_UTIL_CORE.Get_Org_Name(nvl(p_organization_id,l_cont_org_id));
2022: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_ERROR');
2023: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
2024: -- dbms_output.put_line('fill percent not defined');
2025: CLOSE Get_Fill_Basis;
2026: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 2023: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);

2019: END IF;
2020: --
2021: l_org_name := WSH_UTIL_CORE.Get_Org_Name(nvl(p_organization_id,l_cont_org_id));
2022: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_ERROR');
2023: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
2024: -- dbms_output.put_line('fill percent not defined');
2025: CLOSE Get_Fill_Basis;
2026: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2027: WSH_UTIL_CORE.Add_Message(x_return_status);

Line 2062: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_LOAD_QTY_ERROR');

2058:
2059: CLOSE Get_Cont_Load;
2060:
2061: x_num_cont := 0;
2062: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_LOAD_QTY_ERROR');
2063: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2064: WSH_UTIL_CORE.Add_Message(x_return_status);
2065: --
2066: -- Debug Statements

Line 2088: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_LOAD_ERROR');

2084:
2085: IF l_max_load_wt > 0 THEN
2086: l_num_cont := (l_cont_gross/l_max_load_wt);
2087: ELSE
2088: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_LOAD_ERROR');
2089: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2090: WSH_UTIL_CORE.Add_Message(x_return_status);
2091: x_num_cont := 0;
2092: --

Line 2107: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_VOL_ERROR');

2103:
2104: IF l_max_volume > 0 THEN
2105: l_num_cont := (l_cont_volume/l_max_volume);
2106: ELSE
2107: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_VOL_ERROR');
2108: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2109: WSH_UTIL_CORE.Add_Message(x_return_status);
2110: x_num_cont := 0;
2111: --

Line 2132: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_WT_VOL_ERROR');

2128: l_num_cont := (l_cont_volume/l_max_volume);
2129: END IF;
2130: ELSE
2131: -- Bug#: 2503937 - New Error Message
2132: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_WT_VOL_ERROR');
2133: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2134: WSH_UTIL_CORE.Add_Message(x_return_status);
2135: x_num_cont := 0;
2136: --

Line 2155: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_ERROR');

2151: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2152: END IF;
2153: --
2154: l_org_name := WSH_UTIL_CORE.Get_Org_Name(nvl(p_organization_id, l_cont_org_id));
2155: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_ERROR');
2156: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
2157: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2158: WSH_UTIL_CORE.Add_Message(x_return_status);
2159: --

Line 2156: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);

2152: END IF;
2153: --
2154: l_org_name := WSH_UTIL_CORE.Get_Org_Name(nvl(p_organization_id, l_cont_org_id));
2155: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_ERROR');
2156: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
2157: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2158: WSH_UTIL_CORE.Add_Message(x_return_status);
2159: --
2160: -- Debug Statements

Line 2289: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');

2285: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2286: END IF;
2287: --
2288: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
2289: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
2290: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
2291: WSH_UTIL_CORE.Add_Message(x_return_status);
2292: --
2293: -- Debug Statements

Line 2290: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);

2286: END IF;
2287: --
2288: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
2289: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
2290: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
2291: WSH_UTIL_CORE.Add_Message(x_return_status);
2292: --
2293: -- Debug Statements
2294: --

Line 2329: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');

2325: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2326: END IF;
2327: --
2328: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
2329: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
2330: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
2331: WSH_UTIL_CORE.Add_Message(x_return_status);
2332: --
2333: -- Debug Statements

Line 2330: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);

2326: END IF;
2327: --
2328: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
2329: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
2330: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
2331: WSH_UTIL_CORE.Add_Message(x_return_status);
2332: --
2333: -- Debug Statements
2334: --

Line 2523: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_NO_CHILD');

2519: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2520: END IF;
2521: --
2522: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
2523: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_NO_CHILD');
2524: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
2525: WSH_UTIL_CORE.Add_Message(x_return_status);
2526: --
2527: -- Debug Statements

Line 2524: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);

2520: END IF;
2521: --
2522: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
2523: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_NO_CHILD');
2524: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
2525: WSH_UTIL_CORE.Add_Message(x_return_status);
2526: --
2527: -- Debug Statements
2528: --

Line 2604: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');

2600: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2601: END IF;
2602: --
2603: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(det.delivery_detail_id);
2604: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
2605: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
2606: WSH_UTIL_CORE.Add_Message(x_return_status);
2607: END IF;
2608: END LOOP;

Line 2605: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);

2601: END IF;
2602: --
2603: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(det.delivery_detail_id);
2604: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
2605: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
2606: WSH_UTIL_CORE.Add_Message(x_return_status);
2607: END IF;
2608: END LOOP;
2609:

Line 2775: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');

2771: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2772: END IF;
2773: --
2774: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
2775: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
2776: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
2777: WSH_UTIL_CORE.Add_Message(x_return_status);
2778: --
2779: -- Debug Statements

Line 2776: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);

2772: END IF;
2773: --
2774: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
2775: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
2776: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
2777: WSH_UTIL_CORE.Add_Message(x_return_status);
2778: --
2779: -- Debug Statements
2780: --

Line 3091: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');

3087: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3088: END IF;
3089: --
3090: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
3091: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
3092: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
3093: WSH_UTIL_CORE.Add_Message(x_return_status);
3094: --
3095: -- Debug Statements

Line 3092: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);

3088: END IF;
3089: --
3090: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
3091: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
3092: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
3093: WSH_UTIL_CORE.Add_Message(x_return_status);
3094: --
3095: -- Debug Statements
3096: --

Line 3311: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_INVALID_NAME');

3307: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_INSTANCE_ID',P_CONTAINER_INSTANCE_ID);
3308: END IF;
3309: --
3310: IF p_container_name IS NULL THEN
3311: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_INVALID_NAME');
3312: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3313: WSH_UTIL_CORE.Add_Message(x_return_status);
3314: --
3315: -- Debug Statements

Line 3325: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');

3321: return;
3322: END IF;
3323:
3324: IF p_container_instance_id IS NULL THEN
3325: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
3326: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3327: WSH_UTIL_CORE.Add_Message(x_return_status);
3328: --
3329: -- Debug Statements

Line 3345: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_NAME_DUPLICATE');

3341: l_cont_instance_id;
3342:
3343: IF (Check_Dup_Cont%FOUND AND l_cont_instance_id <> p_container_instance_id) THEN
3344: CLOSE Check_Dup_Cont;
3345: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_NAME_DUPLICATE');
3346: FND_MESSAGE.SET_TOKEN('CONT_NAME',p_container_name);
3347: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3348: WSH_UTIL_CORE.Add_Message(x_return_status);
3349: --

Line 3346: FND_MESSAGE.SET_TOKEN('CONT_NAME',p_container_name);

3342:
3343: IF (Check_Dup_Cont%FOUND AND l_cont_instance_id <> p_container_instance_id) THEN
3344: CLOSE Check_Dup_Cont;
3345: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_NAME_DUPLICATE');
3346: FND_MESSAGE.SET_TOKEN('CONT_NAME',p_container_name);
3347: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3348: WSH_UTIL_CORE.Add_Message(x_return_status);
3349: --
3350: -- Debug Statements

Line 3390: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DEL_STS_INVALID');

3386:
3387: IF (nvl(l_del_id,-99) <> -99) THEN
3388:
3389: IF (nvl(l_del_sts,'N/A') <> 'OP') THEN
3390: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DEL_STS_INVALID');
3391: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3392: WSH_UTIL_CORE.Add_Message(x_return_status);
3393: --
3394: -- Debug Statements