APPS.WSH_WVX_PVT dependencies on WSH_WVX_PVT

Line 1: PACKAGE BODY WSH_WVX_PVT as

1: PACKAGE BODY WSH_WVX_PVT as
2: /* $Header: WSHUTWXB.pls 115.12 99/08/11 19:23:07 porting ship $ */
3:
4: -- Name x_order_net_wt_in_delivery
5: -- Purpose Calculates the net weight of order's items in a delivery.

Line 123: WSH_WVX_PVT.ato_weight_volume('SC',

119: end loop;
120: end if;
121:
122: FOR a in ato(delivery_id, order_number, order_type_id) LOOP
123: WSH_WVX_PVT.ato_weight_volume('SC',
124: a.ato_line_id,
125: a.qty,
126: weight_uom,
127: ato_weight,

Line 140: FND_MESSAGE.Set_Token('PACKAGE','wsh_wvx_pvt(14)');

136:
137: EXCEPTION
138: WHEN OTHERS THEN
139: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
140: FND_MESSAGE.Set_Token('PACKAGE','wsh_wvx_pvt(14)');
141: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
142: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
143: return 0;
144: END x_order_net_wt_in_delivery;

Line 276: FND_MESSAGE.Set_Token('PACKAGE','wsh_wvx_pvt(15)');

272:
273: EXCEPTION
274: WHEN OTHERS THEN
275: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
276: FND_MESSAGE.Set_Token('PACKAGE','wsh_wvx_pvt(15)');
277: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
278: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
279: status := -1;
280: END ato_weight_volume;

Line 478: WSH_WVX_PVT.container_net_volume(delivery_id,

474: --- Check the container's load volume volume
475: ---
476: ---
477:
478: WSH_WVX_PVT.container_net_volume(delivery_id,
479: organization_id,
480: container.container_id,
481: container.sequence_number,
482: container.volume_uom,

Line 525: WSH_WVX_PVT.container_fill_percent(delivery_id,

521: --- Check the container's load fill percentage doesn't exceed 100%.
522: ---
523: ---
524:
525: WSH_WVX_PVT.container_fill_percent(delivery_id,
526: organization_id,
527: container.container_id,
528: container.inventory_item_id,
529: container.sequence_number,

Line 612: WSH_WVX_PVT.set_messages(message_string,

608: FND_MESSAGE.Set_Token('WEIGHT_UOM', w_uom);
609: FND_MESSAGE.Set_Token('W_SEQ_NUMBER', to_char(w_sequence));
610:
611: message_string := FND_MESSAGE.Get;
612: WSH_WVX_PVT.set_messages(message_string,
613: message_count,
614: message_text1, message_text2, message_text3, message_text4);
615: END IF;
616:

Line 626: WSH_WVX_PVT.set_messages(message_string,

622: FND_MESSAGE.Set_Token('VOLUME_UOM', v_uom);
623: FND_MESSAGE.Set_Token('V_SEQ_NUMBER', to_char(v_sequence));
624:
625: message_string := FND_MESSAGE.Get;
626: WSH_WVX_PVT.set_messages(message_string,
627: message_count,
628: message_text1, message_text2, message_text3, message_text4);
629: END IF;
630:

Line 640: WSH_WVX_PVT.set_messages(message_string,

636: FND_MESSAGE.Set_Token('LOAD_PERCENT', to_char(l_avg_excess));
637: FND_MESSAGE.Set_Token('L_SEQ_NUMBER', to_char(l_sequence));
638:
639: message_string := FND_MESSAGE.Get;
640: WSH_WVX_PVT.set_messages(message_string,
641: message_count,
642: message_text1, message_text2, message_text3, message_text4);
643: END IF;
644:

Line 651: WSH_WVX_PVT.set_messages(message_string,

647: FND_MESSAGE.Set_Token('U_COUNT', to_char(u_count));
648: FND_MESSAGE.Set_Token('U_SEQ_NUMBER', to_char(u_sequence));
649:
650: message_string := FND_MESSAGE.Get;
651: WSH_WVX_PVT.set_messages(message_string,
652: message_count,
653: message_text1, message_text2, message_text3, message_text4);
654: END IF;
655:

Line 673: FND_MESSAGE.Set_Token('PACKAGE','wsh_wvx_pvt(1)');

669:
670: EXCEPTION
671: WHEN OTHERS THEN
672: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
673: FND_MESSAGE.Set_Token('PACKAGE','wsh_wvx_pvt(1)');
674: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
675: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
676: IF delivery_uoms%ISOPEN THEN
677: CLOSE delivery_uoms;

Line 805: WSH_WVX_PVT.ato_weight_volume('SC',

801: END LOOP;
802:
803:
804: FOR a IN packed_ato(delivery_id, container_id, ship_factor) LOOP
805: WSH_WVX_PVT.ato_weight_volume('SC',
806: a.ato_line_id,
807: a.qty,
808: NULL,
809: ato_weight,

Line 822: FND_MESSAGE.Set_Token('PACKAGE','wsh_wvx_pvt(2)');

818:
819: EXCEPTION
820: WHEN OTHERS THEN
821: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
822: FND_MESSAGE.Set_Token('PACKAGE','wsh_wvx_pvt(2)');
823: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
824: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
825: IF container_volume%ISOPEN THEN
826: CLOSE container_volume;

Line 947: FND_MESSAGE.Set_Token('PACKAGE','wsh_wvx_pvt(3)');

943:
944: EXCEPTION
945: WHEN OTHERS THEN
946: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
947: FND_MESSAGE.Set_Token('PACKAGE','wsh_wvx_pvt(3)');
948: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
949: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
950: IF cont_fill%ISOPEN THEN
951: CLOSE cont_fill;

Line 1334: END WSH_WVX_PVT;

1330: END LOOP;
1331: END auto_calc_cont;
1332:
1333:
1334: END WSH_WVX_PVT;