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

Line 139: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');

135:
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;

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 141: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));

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;
145:

Line 142: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);

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;
145:
146:

Line 275: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');

271: END IF;
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;

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 277: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));

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;
281:

Line 278: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);

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;
281:
282:

Line 605: FND_MESSAGE.Set_Name('OE', 'WSH_WV_CONT_OVERLOAD_W');

601:
602:
603: IF w_count > 0 THEN
604: w_net_excess := ceil(w_net_excess * 1000) / 1000;
605: FND_MESSAGE.Set_Name('OE', 'WSH_WV_CONT_OVERLOAD_W');
606: FND_MESSAGE.Set_Token('W_COUNT', to_char(w_count));
607: FND_MESSAGE.Set_Token('WEIGHT_AMOUNT', to_char(w_net_excess));
608: FND_MESSAGE.Set_Token('WEIGHT_UOM', w_uom);
609: FND_MESSAGE.Set_Token('W_SEQ_NUMBER', to_char(w_sequence));

Line 606: FND_MESSAGE.Set_Token('W_COUNT', to_char(w_count));

602:
603: IF w_count > 0 THEN
604: w_net_excess := ceil(w_net_excess * 1000) / 1000;
605: FND_MESSAGE.Set_Name('OE', 'WSH_WV_CONT_OVERLOAD_W');
606: FND_MESSAGE.Set_Token('W_COUNT', to_char(w_count));
607: FND_MESSAGE.Set_Token('WEIGHT_AMOUNT', to_char(w_net_excess));
608: FND_MESSAGE.Set_Token('WEIGHT_UOM', w_uom);
609: FND_MESSAGE.Set_Token('W_SEQ_NUMBER', to_char(w_sequence));
610:

Line 607: FND_MESSAGE.Set_Token('WEIGHT_AMOUNT', to_char(w_net_excess));

603: IF w_count > 0 THEN
604: w_net_excess := ceil(w_net_excess * 1000) / 1000;
605: FND_MESSAGE.Set_Name('OE', 'WSH_WV_CONT_OVERLOAD_W');
606: FND_MESSAGE.Set_Token('W_COUNT', to_char(w_count));
607: FND_MESSAGE.Set_Token('WEIGHT_AMOUNT', to_char(w_net_excess));
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;

Line 608: FND_MESSAGE.Set_Token('WEIGHT_UOM', w_uom);

604: w_net_excess := ceil(w_net_excess * 1000) / 1000;
605: FND_MESSAGE.Set_Name('OE', 'WSH_WV_CONT_OVERLOAD_W');
606: FND_MESSAGE.Set_Token('W_COUNT', to_char(w_count));
607: FND_MESSAGE.Set_Token('WEIGHT_AMOUNT', to_char(w_net_excess));
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,

Line 609: FND_MESSAGE.Set_Token('W_SEQ_NUMBER', to_char(w_sequence));

605: FND_MESSAGE.Set_Name('OE', 'WSH_WV_CONT_OVERLOAD_W');
606: FND_MESSAGE.Set_Token('W_COUNT', to_char(w_count));
607: FND_MESSAGE.Set_Token('WEIGHT_AMOUNT', to_char(w_net_excess));
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,

Line 611: message_string := FND_MESSAGE.Get;

607: FND_MESSAGE.Set_Token('WEIGHT_AMOUNT', to_char(w_net_excess));
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;

Line 619: FND_MESSAGE.Set_Name('OE', 'WSH_WV_CONT_OVERLOAD_V');

615: END IF;
616:
617: IF v_count > 0 THEN
618: v_net_excess := ceil(v_net_excess * 1000) / 1000;
619: FND_MESSAGE.Set_Name('OE', 'WSH_WV_CONT_OVERLOAD_V');
620: FND_MESSAGE.Set_Token('V_COUNT', to_char(v_count));
621: FND_MESSAGE.Set_Token('VOLUME_AMOUNT', to_char(v_net_excess));
622: FND_MESSAGE.Set_Token('VOLUME_UOM', v_uom);
623: FND_MESSAGE.Set_Token('V_SEQ_NUMBER', to_char(v_sequence));

Line 620: FND_MESSAGE.Set_Token('V_COUNT', to_char(v_count));

616:
617: IF v_count > 0 THEN
618: v_net_excess := ceil(v_net_excess * 1000) / 1000;
619: FND_MESSAGE.Set_Name('OE', 'WSH_WV_CONT_OVERLOAD_V');
620: FND_MESSAGE.Set_Token('V_COUNT', to_char(v_count));
621: FND_MESSAGE.Set_Token('VOLUME_AMOUNT', to_char(v_net_excess));
622: FND_MESSAGE.Set_Token('VOLUME_UOM', v_uom);
623: FND_MESSAGE.Set_Token('V_SEQ_NUMBER', to_char(v_sequence));
624:

Line 621: FND_MESSAGE.Set_Token('VOLUME_AMOUNT', to_char(v_net_excess));

617: IF v_count > 0 THEN
618: v_net_excess := ceil(v_net_excess * 1000) / 1000;
619: FND_MESSAGE.Set_Name('OE', 'WSH_WV_CONT_OVERLOAD_V');
620: FND_MESSAGE.Set_Token('V_COUNT', to_char(v_count));
621: FND_MESSAGE.Set_Token('VOLUME_AMOUNT', to_char(v_net_excess));
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;

Line 622: FND_MESSAGE.Set_Token('VOLUME_UOM', v_uom);

618: v_net_excess := ceil(v_net_excess * 1000) / 1000;
619: FND_MESSAGE.Set_Name('OE', 'WSH_WV_CONT_OVERLOAD_V');
620: FND_MESSAGE.Set_Token('V_COUNT', to_char(v_count));
621: FND_MESSAGE.Set_Token('VOLUME_AMOUNT', to_char(v_net_excess));
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,

Line 623: FND_MESSAGE.Set_Token('V_SEQ_NUMBER', to_char(v_sequence));

619: FND_MESSAGE.Set_Name('OE', 'WSH_WV_CONT_OVERLOAD_V');
620: FND_MESSAGE.Set_Token('V_COUNT', to_char(v_count));
621: FND_MESSAGE.Set_Token('VOLUME_AMOUNT', to_char(v_net_excess));
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,

Line 625: message_string := FND_MESSAGE.Get;

621: FND_MESSAGE.Set_Token('VOLUME_AMOUNT', to_char(v_net_excess));
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;

Line 634: FND_MESSAGE.Set_Name('OE', 'WSH_WV_CONT_OVERLOAD_L');

630:
631: IF l_count > 0 THEN
632: -- overload percentage is average of the containers' overload percentage
633: l_avg_excess := ceil(l_sum_excess / l_count);
634: FND_MESSAGE.Set_Name('OE', 'WSH_WV_CONT_OVERLOAD_L');
635: FND_MESSAGE.Set_Token('L_COUNT', to_char(l_count));
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:

Line 635: FND_MESSAGE.Set_Token('L_COUNT', to_char(l_count));

631: IF l_count > 0 THEN
632: -- overload percentage is average of the containers' overload percentage
633: l_avg_excess := ceil(l_sum_excess / l_count);
634: FND_MESSAGE.Set_Name('OE', 'WSH_WV_CONT_OVERLOAD_L');
635: FND_MESSAGE.Set_Token('L_COUNT', to_char(l_count));
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;

Line 636: FND_MESSAGE.Set_Token('LOAD_PERCENT', to_char(l_avg_excess));

632: -- overload percentage is average of the containers' overload percentage
633: l_avg_excess := ceil(l_sum_excess / l_count);
634: FND_MESSAGE.Set_Name('OE', 'WSH_WV_CONT_OVERLOAD_L');
635: FND_MESSAGE.Set_Token('L_COUNT', to_char(l_count));
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,

Line 637: FND_MESSAGE.Set_Token('L_SEQ_NUMBER', to_char(l_sequence));

633: l_avg_excess := ceil(l_sum_excess / l_count);
634: FND_MESSAGE.Set_Name('OE', 'WSH_WV_CONT_OVERLOAD_L');
635: FND_MESSAGE.Set_Token('L_COUNT', to_char(l_count));
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,

Line 639: message_string := FND_MESSAGE.Get;

635: FND_MESSAGE.Set_Token('L_COUNT', to_char(l_count));
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;

Line 646: FND_MESSAGE.Set_Name('OE', 'WSH_WV_CONT_UNDERLOAD');

642: message_text1, message_text2, message_text3, message_text4);
643: END IF;
644:
645: IF u_count > 0 THEN
646: FND_MESSAGE.Set_Name('OE', 'WSH_WV_CONT_UNDERLOAD');
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;

Line 647: FND_MESSAGE.Set_Token('U_COUNT', to_char(u_count));

643: END IF;
644:
645: IF u_count > 0 THEN
646: FND_MESSAGE.Set_Name('OE', 'WSH_WV_CONT_UNDERLOAD');
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,

Line 648: FND_MESSAGE.Set_Token('U_SEQ_NUMBER', to_char(u_sequence));

644:
645: IF u_count > 0 THEN
646: FND_MESSAGE.Set_Name('OE', 'WSH_WV_CONT_UNDERLOAD');
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,

Line 650: message_string := FND_MESSAGE.Get;

646: FND_MESSAGE.Set_Name('OE', 'WSH_WV_CONT_UNDERLOAD');
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;

Line 661: FND_MESSAGE.Set_Name('OE', 'WSH_WV_COMBO');

657:
658: IF message_count > 0 THEN
659: status := 1;
660:
661: FND_MESSAGE.Set_Name('OE', 'WSH_WV_COMBO');
662: FND_MESSAGE.Set_Token('MESSAGE_1', message_text1);
663: FND_MESSAGE.Set_Token('MESSAGE_2', message_text2);
664: FND_MESSAGE.Set_Token('MESSAGE_3', message_text3);
665: FND_MESSAGE.Set_Token('MESSAGE_4', message_text4);

Line 662: FND_MESSAGE.Set_Token('MESSAGE_1', message_text1);

658: IF message_count > 0 THEN
659: status := 1;
660:
661: FND_MESSAGE.Set_Name('OE', 'WSH_WV_COMBO');
662: FND_MESSAGE.Set_Token('MESSAGE_1', message_text1);
663: FND_MESSAGE.Set_Token('MESSAGE_2', message_text2);
664: FND_MESSAGE.Set_Token('MESSAGE_3', message_text3);
665: FND_MESSAGE.Set_Token('MESSAGE_4', message_text4);
666: END IF;

Line 663: FND_MESSAGE.Set_Token('MESSAGE_2', message_text2);

659: status := 1;
660:
661: FND_MESSAGE.Set_Name('OE', 'WSH_WV_COMBO');
662: FND_MESSAGE.Set_Token('MESSAGE_1', message_text1);
663: FND_MESSAGE.Set_Token('MESSAGE_2', message_text2);
664: FND_MESSAGE.Set_Token('MESSAGE_3', message_text3);
665: FND_MESSAGE.Set_Token('MESSAGE_4', message_text4);
666: END IF;
667:

Line 664: FND_MESSAGE.Set_Token('MESSAGE_3', message_text3);

660:
661: FND_MESSAGE.Set_Name('OE', 'WSH_WV_COMBO');
662: FND_MESSAGE.Set_Token('MESSAGE_1', message_text1);
663: FND_MESSAGE.Set_Token('MESSAGE_2', message_text2);
664: FND_MESSAGE.Set_Token('MESSAGE_3', message_text3);
665: FND_MESSAGE.Set_Token('MESSAGE_4', message_text4);
666: END IF;
667:
668: RETURN NOT overloaded;

Line 665: FND_MESSAGE.Set_Token('MESSAGE_4', message_text4);

661: FND_MESSAGE.Set_Name('OE', 'WSH_WV_COMBO');
662: FND_MESSAGE.Set_Token('MESSAGE_1', message_text1);
663: FND_MESSAGE.Set_Token('MESSAGE_2', message_text2);
664: FND_MESSAGE.Set_Token('MESSAGE_3', message_text3);
665: FND_MESSAGE.Set_Token('MESSAGE_4', message_text4);
666: END IF;
667:
668: RETURN NOT overloaded;
669:

Line 672: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');

668: RETURN NOT overloaded;
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

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 674: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));

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;
678: END IF;

Line 675: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);

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;
678: END IF;
679: IF cont_info%ISOPEN THEN

Line 821: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');

817: volume := net_volume;
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

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 823: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));

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;
827: END IF;

Line 824: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);

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;
827: END IF;
828: IF contents_volume%ISOPEN THEN

Line 946: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');

942: fill_percent := TRUNC(100 * fill / container_qty);
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

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 948: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));

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;
952: END IF;

Line 949: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);

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;
952: END IF;
953: IF contents_fill%ISOPEN THEN