333: EXCEPTION
334:
335: WHEN Invalid_Table THEN
336: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
337: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_TABLE');
338: FND_MESSAGE.Set_Token('TABLE', p_table_name);
339: WSH_UTIL_CORE.Add_Message(x_return_status);
340: --
341: -- Debug Statements
334:
335: WHEN Invalid_Table THEN
336: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
337: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_TABLE');
338: FND_MESSAGE.Set_Token('TABLE', p_table_name);
339: WSH_UTIL_CORE.Add_Message(x_return_status);
340: --
341: -- Debug Statements
342: --
587: --
588: EXCEPTION
589: WHEN Invalid_Table THEN
590: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
591: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_TABLE');
592: FND_MESSAGE.Set_Token('TABLE', p_table_name);
593: WSH_UTIL_CORE.Add_Message(x_return_status);
594: --
595: -- Debug Statements
588: EXCEPTION
589: WHEN Invalid_Table THEN
590: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
591: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_TABLE');
592: FND_MESSAGE.Set_Token('TABLE', p_table_name);
593: WSH_UTIL_CORE.Add_Message(x_return_status);
594: --
595: -- Debug Statements
596: --
772: IF c_wnd_attributes%ISOPEN THEN
773: CLOSE c_wnd_attributes;
774: END IF;
775: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
776: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_DELIVERY');
777: FND_MESSAGE.Set_Token('DELIVERY', p_primary_id);
778: WSH_UTIL_CORE.Add_Message(x_return_status);
779: --
780: -- Debug Statements
773: CLOSE c_wnd_attributes;
774: END IF;
775: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
776: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_DELIVERY');
777: FND_MESSAGE.Set_Token('DELIVERY', p_primary_id);
778: WSH_UTIL_CORE.Add_Message(x_return_status);
779: --
780: -- Debug Statements
781: --
789: IF c_wdd_attributes%ISOPEN THEN
790: CLOSE c_wdd_attributes;
791: END IF;
792: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
793: FND_MESSAGE.Set_Name('WSH', 'WSH_DET_INVALID_DETAIL');
794: FND_MESSAGE.Set_Token('DETAIL_ID', p_primary_id);
795: WSH_UTIL_CORE.Add_Message(x_return_status);
796: --
797: -- Debug Statements
790: CLOSE c_wdd_attributes;
791: END IF;
792: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
793: FND_MESSAGE.Set_Name('WSH', 'WSH_DET_INVALID_DETAIL');
794: FND_MESSAGE.Set_Token('DETAIL_ID', p_primary_id);
795: WSH_UTIL_CORE.Add_Message(x_return_status);
796: --
797: -- Debug Statements
798: --
802: END IF;
803: --
804: WHEN Invalid_Table THEN
805: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
806: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_TABLE');
807: FND_MESSAGE.Set_Token('TABLE', p_table_name);
808: WSH_UTIL_CORE.Add_Message(x_return_status);
809: --
810: -- Debug Statements
803: --
804: WHEN Invalid_Table THEN
805: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
806: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_TABLE');
807: FND_MESSAGE.Set_Token('TABLE', p_table_name);
808: WSH_UTIL_CORE.Add_Message(x_return_status);
809: --
810: -- Debug Statements
811: --
951: EXCEPTION
952:
953: WHEN Invalid_Table THEN
954: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
955: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_TABLE');
956: FND_MESSAGE.Set_Token('TABLE', p_table_name);
957: WSH_UTIL_CORE.Add_Message(x_return_status);
958: --
959: -- Debug Statements
952:
953: WHEN Invalid_Table THEN
954: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
955: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_TABLE');
956: FND_MESSAGE.Set_Token('TABLE', p_table_name);
957: WSH_UTIL_CORE.Add_Message(x_return_status);
958: --
959: -- Debug Statements
960: --
1135:
1136: EXCEPTION
1137: WHEN Invalid_Table THEN
1138: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1139: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_TABLE');
1140: FND_MESSAGE.Set_Token('TABLE', p_table_name);
1141: WSH_UTIL_CORE.Add_Message(x_return_status);
1142: --
1143: --
1136: EXCEPTION
1137: WHEN Invalid_Table THEN
1138: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1139: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_TABLE');
1140: FND_MESSAGE.Set_Token('TABLE', p_table_name);
1141: WSH_UTIL_CORE.Add_Message(x_return_status);
1142: --
1143: --
1144: -- Debug Statements
1221: END IF;
1222: --
1223: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1224: IF (p_table_name = 'WSH_NEW_DELIVERIES') THEN
1225: l_token := FND_MESSAGE.Get_String('WSH', 'WSH_DELIVERY_DFF_TITLE');
1226: END IF;
1227:
1228: j := Check_DFF_Req(p_table_name => p_table_name,
1229: x_return_status => x_return_status);
1295: WHEN Required_Attributes_Empty THEN
1296: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1297: -- IF condition Added for Bug 3118519
1298: IF ( UPPER(p_table_name) = 'WSH_NEW_DELIVERIES' ) THEN
1299: FND_MESSAGE.Set_Name('WSH', 'WSH_DFF_ATTRIBUTE_EMPTY');
1300: FND_MESSAGE.Set_Token('DFF_TITLE', l_token);
1301: WSH_UTIL_CORE.Add_Message(x_return_status);
1302: END IF;
1303: --
1296: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1297: -- IF condition Added for Bug 3118519
1298: IF ( UPPER(p_table_name) = 'WSH_NEW_DELIVERIES' ) THEN
1299: FND_MESSAGE.Set_Name('WSH', 'WSH_DFF_ATTRIBUTE_EMPTY');
1300: FND_MESSAGE.Set_Token('DFF_TITLE', l_token);
1301: WSH_UTIL_CORE.Add_Message(x_return_status);
1302: END IF;
1303: --
1304: -- Debug Statements