DBA Data[Home] [Help]

APPS.WSH_REPORT_QUANTITIES dependencies on FND_MESSAGE

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

475: IF dbms_sql.is_open(l_cursor) THEN
476: dbms_sql.close_cursor(l_cursor);
477: END IF;
478:
479: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
480: FND_MESSAGE.Set_Token('PACKAGE','WSH_REPORT_QUANTITIES.populate_temp_table');
481: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
482: APP_EXCEPTION.Raise_Exception;
483:

Line 480: FND_MESSAGE.Set_Token('PACKAGE','WSH_REPORT_QUANTITIES.populate_temp_table');

476: dbms_sql.close_cursor(l_cursor);
477: END IF;
478:
479: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
480: FND_MESSAGE.Set_Token('PACKAGE','WSH_REPORT_QUANTITIES.populate_temp_table');
481: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
482: APP_EXCEPTION.Raise_Exception;
483:
484: END;

Line 481: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));

477: END IF;
478:
479: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
480: FND_MESSAGE.Set_Token('PACKAGE','WSH_REPORT_QUANTITIES.populate_temp_table');
481: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
482: APP_EXCEPTION.Raise_Exception;
483:
484: END;
485:

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

591:
592: END LOOP;
593:
594: EXCEPTION WHEN OTHERS THEN
595: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
596: FND_MESSAGE.Set_Token('PACKAGE','WSH_REPORT_QUANTITIES.add_non_ship_lines');
597: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
598: APP_EXCEPTION.Raise_Exception;
599:

Line 596: FND_MESSAGE.Set_Token('PACKAGE','WSH_REPORT_QUANTITIES.add_non_ship_lines');

592: END LOOP;
593:
594: EXCEPTION WHEN OTHERS THEN
595: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
596: FND_MESSAGE.Set_Token('PACKAGE','WSH_REPORT_QUANTITIES.add_non_ship_lines');
597: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
598: APP_EXCEPTION.Raise_Exception;
599:
600: END;

Line 597: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));

593:
594: EXCEPTION WHEN OTHERS THEN
595: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
596: FND_MESSAGE.Set_Token('PACKAGE','WSH_REPORT_QUANTITIES.add_non_ship_lines');
597: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
598: APP_EXCEPTION.Raise_Exception;
599:
600: END;
601:

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

684:
685: END IF;
686:
687: EXCEPTION WHEN OTHERS THEN
688: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
689: FND_MESSAGE.Set_Token('PACKAGE','WSH_REPORT_QUANTITIES.set_shipped_quantity');
690: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
691: APP_EXCEPTION.Raise_Exception;
692: END;

Line 689: FND_MESSAGE.Set_Token('PACKAGE','WSH_REPORT_QUANTITIES.set_shipped_quantity');

685: END IF;
686:
687: EXCEPTION WHEN OTHERS THEN
688: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
689: FND_MESSAGE.Set_Token('PACKAGE','WSH_REPORT_QUANTITIES.set_shipped_quantity');
690: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
691: APP_EXCEPTION.Raise_Exception;
692: END;
693:

Line 690: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));

686:
687: EXCEPTION WHEN OTHERS THEN
688: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
689: FND_MESSAGE.Set_Token('PACKAGE','WSH_REPORT_QUANTITIES.set_shipped_quantity');
690: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
691: APP_EXCEPTION.Raise_Exception;
692: END;
693:
694: END SET_SHIPPED_QUANTITY;

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

764: END LOOP;
765: END IF;
766:
767: EXCEPTION WHEN OTHERS THEN
768: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
769: FND_MESSAGE.Set_Token('PACKAGE','WSH_REPORT_QUANTITIES.set_invoice_quantity');
770: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
771: APP_EXCEPTION.Raise_Exception;
772: END;

Line 769: FND_MESSAGE.Set_Token('PACKAGE','WSH_REPORT_QUANTITIES.set_invoice_quantity');

765: END IF;
766:
767: EXCEPTION WHEN OTHERS THEN
768: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
769: FND_MESSAGE.Set_Token('PACKAGE','WSH_REPORT_QUANTITIES.set_invoice_quantity');
770: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
771: APP_EXCEPTION.Raise_Exception;
772: END;
773: END SET_INVOICE_QUANTITY;

Line 770: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));

766:
767: EXCEPTION WHEN OTHERS THEN
768: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
769: FND_MESSAGE.Set_Token('PACKAGE','WSH_REPORT_QUANTITIES.set_invoice_quantity');
770: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
771: APP_EXCEPTION.Raise_Exception;
772: END;
773: END SET_INVOICE_QUANTITY;
774:

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

915: CLOSE ORDER_LINES;
916: END IF;
917:
918: EXCEPTION WHEN OTHERS THEN
919: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
920: FND_MESSAGE.Set_Token('PACKAGE','WSH_REPORT_QUANTITIES.insert_order_line');
921: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
922: APP_EXCEPTION.Raise_Exception;
923: END;

Line 920: FND_MESSAGE.Set_Token('PACKAGE','WSH_REPORT_QUANTITIES.insert_order_line');

916: END IF;
917:
918: EXCEPTION WHEN OTHERS THEN
919: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
920: FND_MESSAGE.Set_Token('PACKAGE','WSH_REPORT_QUANTITIES.insert_order_line');
921: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
922: APP_EXCEPTION.Raise_Exception;
923: END;
924: END INSERT_ORDER_LINE;

Line 921: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));

917:
918: EXCEPTION WHEN OTHERS THEN
919: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
920: FND_MESSAGE.Set_Token('PACKAGE','WSH_REPORT_QUANTITIES.insert_order_line');
921: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
922: APP_EXCEPTION.Raise_Exception;
923: END;
924: END INSERT_ORDER_LINE;
925:

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

1053:
1054: CLOSE ORDER_LINES;
1055:
1056: EXCEPTION WHEN OTHERS THEN
1057: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
1058: FND_MESSAGE.Set_Token('PACKAGE','WSH_REPORT_QUANTITIES.insert_ato_components');
1059: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
1060: APP_EXCEPTION.Raise_Exception;
1061: END;

Line 1058: FND_MESSAGE.Set_Token('PACKAGE','WSH_REPORT_QUANTITIES.insert_ato_components');

1054: CLOSE ORDER_LINES;
1055:
1056: EXCEPTION WHEN OTHERS THEN
1057: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
1058: FND_MESSAGE.Set_Token('PACKAGE','WSH_REPORT_QUANTITIES.insert_ato_components');
1059: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
1060: APP_EXCEPTION.Raise_Exception;
1061: END;
1062: END INSERT_ATO_COMPONENTS;

Line 1059: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));

1055:
1056: EXCEPTION WHEN OTHERS THEN
1057: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
1058: FND_MESSAGE.Set_Token('PACKAGE','WSH_REPORT_QUANTITIES.insert_ato_components');
1059: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
1060: APP_EXCEPTION.Raise_Exception;
1061: END;
1062: END INSERT_ATO_COMPONENTS;
1063:

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

1126:
1127: RETURN(l_sq);
1128:
1129: EXCEPTION WHEN OTHERS THEN
1130: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
1131: FND_MESSAGE.Set_Token('PACKAGE','WSH_REPORT_QUANTITIES.line_shipped_quantity');
1132: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
1133: APP_EXCEPTION.Raise_Exception;
1134: END;

Line 1131: FND_MESSAGE.Set_Token('PACKAGE','WSH_REPORT_QUANTITIES.line_shipped_quantity');

1127: RETURN(l_sq);
1128:
1129: EXCEPTION WHEN OTHERS THEN
1130: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
1131: FND_MESSAGE.Set_Token('PACKAGE','WSH_REPORT_QUANTITIES.line_shipped_quantity');
1132: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
1133: APP_EXCEPTION.Raise_Exception;
1134: END;
1135:

Line 1132: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));

1128:
1129: EXCEPTION WHEN OTHERS THEN
1130: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
1131: FND_MESSAGE.Set_Token('PACKAGE','WSH_REPORT_QUANTITIES.line_shipped_quantity');
1132: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
1133: APP_EXCEPTION.Raise_Exception;
1134: END;
1135:
1136: END LINE_SHIPPED_QUANTITY;