APPS.OE_SO_PLN_SERVER dependencies on OE_SO_PLN_SERVER

Line 1: PACKAGE BODY OE_SO_PLN_SERVER AS

1: PACKAGE BODY OE_SO_PLN_SERVER AS
2: /* $Header: OESOPLNB.pls 115.2 99/07/16 08:11:06 porting shi $ */
3:
4: PROCEDURE When_Validate_Record
5: (

Line 31: OE_SO_PLN_SERVER.Get_Schedule_DB_Values

27: is
28: Result VARCHAR2(1) := 'Y';
29: begin
30: P_Result := 'Y';
31: OE_SO_PLN_SERVER.Get_Schedule_DB_Values
32: (
33: X_Row_Id,
34: P_Picking_Line_Id,
35: P_Db_Schedule_Date,

Line 109: ('OE_SO_PLN_SERVER.When_Validate_Record',

105:
106: exception
107: when OTHERS then
108: OE_MSG.Internal_Exception
109: ('OE_SO_PLN_SERVER.When_Validate_Record',
110: 'When-Validate-Record', 'PICKING_LINE');
111: Result := 'N';
112: end When_Validate_Record;
113:

Line 169: OE_SO_PLN_SERVER.DB_Reserved_Quantity(X_Picking_Line_Id);

165: FROM SO_PICKING_LINES
166: WHERE rowid = X_Row_Id;
167:
168: P_Db_Reserved_Quantity :=
169: OE_SO_PLN_SERVER.DB_Reserved_Quantity(X_Picking_Line_Id);
170:
171: exception
172: when OTHERS then
173: OE_MSG.Internal_Exception('OE_SO_PLN_SERVER.Get_Schedule_DB_Values',

Line 173: OE_MSG.Internal_Exception('OE_SO_PLN_SERVER.Get_Schedule_DB_Values',

169: OE_SO_PLN_SERVER.DB_Reserved_Quantity(X_Picking_Line_Id);
170:
171: exception
172: when OTHERS then
173: OE_MSG.Internal_Exception('OE_SO_PLN_SERVER.Get_Schedule_DB_Values',
174: 'Get_DB_Values', 'P_LINE');
175: Result := 'N';
176: end Get_Schedule_DB_Values;
177:

Line 524: OE_MSG.Internal_Exception('OE_SO_PLN_SERVER.Update_Row',NULL,NULL);

520: end if;
521:
522: exception
523: when OTHERS then
524: OE_MSG.Internal_Exception('OE_SO_PLN_SERVER.Update_Row',NULL,NULL);
525:
526: END Update_Row;
527:
528: FUNCTION complex_details (x_picking_line_id IN NUMBER) RETURN BOOLEAN IS

Line 582: if (NVL(P_Reserved_Qty, 0) = OE_SO_PLN_SERVER.DB_Reserved_Quantity(P_Picking_Line_Id)) then

578: begin
579:
580: P_Result := 'Y';
581:
582: if (NVL(P_Reserved_Qty, 0) = OE_SO_PLN_SERVER.DB_Reserved_Quantity(P_Picking_Line_Id)) then
583: Return;
584: end if;
585:
586: if (P_Reserved_Qty > (NVL(P_Original_Requested_Qty, 0)

Line 596: if (OE_SO_PLN_SERVER.Complex_Details(P_Picking_Line_Id)) then

592: OE_MSG.Set_Buffer_Message('OE_SCH_RES_LESS_REL_QTY','RELEASED_QUANTITY',to_char(P_Released_Qty));
593: P_Result := 'N';
594: Return;
595: else
596: if (OE_SO_PLN_SERVER.Complex_Details(P_Picking_Line_Id)) then
597: OE_MSG.Set_Buffer_Message('OE_SCH_COMPLEX_DETAILS');
598: P_Result := 'N';
599: Return;
600: end if;

Line 607: END OE_SO_PLN_SERVER;

603: Return;
604:
605: end Validate_Reserved_Qty;
606:
607: END OE_SO_PLN_SERVER;