DBA Data[Home] [Help]

APPS.OE_DEMAND_STREAM_PROCESSOR dependencies on OE_DEMAND_STREAM_PROCESSOR

Line 1: PACKAGE BODY OE_DEMAND_STREAM_PROCESSOR AS

1: PACKAGE BODY OE_DEMAND_STREAM_PROCESSOR AS
2: /* $Header: OEXDSPXB.pls 115.0 99/07/16 08:12:20 porting ship $ */
3:
4: --
5: -- NAME: Order_Info.

Line 476: -- Raises an exception OE_DEMAND_STREAM_PROCESSOR.Original_Sys_Ref_Exists

472: -- If no original_system_reference is passed, the system generates an
473: -- automatic original_system_reference by concatening Order Number, Order
474: -- Type.
475: --
476: -- Raises an exception OE_DEMAND_STREAM_PROCESSOR.Original_Sys_Ref_Exists
477: -- if the eventual combination of original_system_source_code and
478: -- original_system_reference already exist in the database.
479: -- The calling program must handle this exception.
480: --

Line 589: RAISE OE_DEMAND_STREAM_PROCESSOR.Original_Sys_Ref_Exists;

585: WHERE original_system_reference = l_original_system_reference
586: AND original_system_source_code = l_original_system_source_code);
587:
588: IF SQL%NOTFOUND THEN
589: RAISE OE_DEMAND_STREAM_PROCESSOR.Original_Sys_Ref_Exists;
590: END IF;
591:
592: x_result := 'Y';
593: x_sqlcode := 0;

Line 599: WHEN OE_DEMAND_STREAM_PROCESSOR.Original_Sys_Ref_Exists THEN

595: RETURN l_original_system_reference;
596:
597: EXCEPTION
598:
599: WHEN OE_DEMAND_STREAM_PROCESSOR.Original_Sys_Ref_Exists THEN
600:
601: x_sqlcode := SQLCODE;
602: x_result := 'N';
603:

Line 606: RAISE OE_DEMAND_STREAM_PROCESSOR.Original_Sys_Ref_Exists;

602: x_result := 'N';
603:
604: ROLLBACK TO SAVEPOINT set_original_system_reference;
605:
606: RAISE OE_DEMAND_STREAM_PROCESSOR.Original_Sys_Ref_Exists;
607:
608: WHEN OTHERS THEN
609:
610: x_sqlcode := SQLCODE;

Line 672: END OE_DEMAND_STREAM_PROCESSOR;

668:
669: end line_scheduling_exists;
670:
671:
672: END OE_DEMAND_STREAM_PROCESSOR;