APPS.WSH_SC_TRX_INTERFACE dependencies on APP_EXCEPTION

Line 336: APP_EXCEPTION.Raise_Exception;

332: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
333: FND_MESSAGE.Set_Token('PACKAGE','SHP_SC_SERIAL_VALIDATION_PKG.Check_Serial_Numbers');
334: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
335: FND_MESSAGE.Set_Token('ORA_TEXT',X_Stmt_Num ||':'|| X_Stmt);
336: APP_EXCEPTION.Raise_Exception;
337: END Check_serial_number;
338:
339:
340:

Line 457: APP_EXCEPTION.Raise_Exception;

453: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
454: FND_MESSAGE.Set_Token('PACKAGE','WSH_SC_TRX_INTERFACE.update_sopld');
455: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
456: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
457: APP_EXCEPTION.Raise_Exception;
458: END;
459:
460: if sql%notfound then
461: wsh_del_oi_core.println('BUT could not update so_picking_line_details.');

Line 642: APP_EXCEPTION.Raise_Exception;

638: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
639: FND_MESSAGE.Set_Token('PACKAGE','WSH_SC_TRX_INTERFACE.Insert_sopld');
640: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
641: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
642: APP_EXCEPTION.Raise_Exception;
643:
644: END Insert_Sopld_Row;
645:
646:

Line 697: APP_EXCEPTION.Raise_Exception;

693: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
694: FND_MESSAGE.Set_Token('PACKAGE','WSH_SC_TRX_INTERFACE.update_requested_quantity');
695: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
696: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
697: APP_EXCEPTION.Raise_Exception;
698: END;
699: if sql%notfound then
700: wsh_del_oi_core.println('Unexpected error on picking detail '||to_char(x_picking_line_detail_id));
701: error_code := '1';

Line 789: APP_EXCEPTION.Raise_Exception;

785: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
786: FND_MESSAGE.Set_Token('PACKAGE','WSH_SC_TRX_INTERFACE.split_sopld_row');
787: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
788: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
789: APP_EXCEPTION.Raise_Exception;
790:
791: END split_SOPLD_row;
792:
793:

Line 1582: APP_EXCEPTION.Raise_Exception;

1578: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
1579: FND_MESSAGE.Set_Token('PACKAGE','WSH_SC_TRX_INTERFACE.update_sopld1');
1580: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
1581: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
1582: APP_EXCEPTION.Raise_Exception;
1583: END;
1584:
1585: -- oirec.picking_line_detail_id := new_pld_id;
1586: -- oirec.shipped_quantity := pl_shp_qty;

Line 1739: --APP_EXCEPTION.Raise_Exception;

1735: --FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
1736: --FND_MESSAGE.Set_Token('PACKAGE','WSH_SC_TRX_INTERFACE.process_sopld_interface');
1737: --FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
1738: --FND_MESSAGE.Set_Token('ORA_TEXT','Insert statement');
1739: --APP_EXCEPTION.Raise_Exception;
1740: END;
1741:
1742: END PROCESS_PICKING_DETAILS_INTER;
1743:

Line 2093: APP_EXCEPTION.Raise_Exception;

2089: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
2090: FND_MESSAGE.Set_Token('PACKAGE','WSH_SC_TRX_INTERFACE.insert_freight_charges statement');
2091: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
2092: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
2093: APP_EXCEPTION.Raise_Exception;
2094: EXIT;
2095:
2096: if ( sql%found ) then
2097: wsh_del_oi_core.println(' ');

Line 2130: APP_EXCEPTION.Raise_Exception;

2126: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
2127: FND_MESSAGE.Set_Token('PACKAGE','WSH_SC_TRX_INTERFACE.insert_freight_charges');
2128: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
2129: FND_MESSAGE.Set_Token('ORA_TEXT','Insert statement');
2130: APP_EXCEPTION.Raise_Exception;
2131:
2132: end;
2133:
2134: --x_error_code := error_code;