APPS.OE_SO_LIN_VALIDATE dependencies on OE_SO_LIN_VALIDATE

Line 1: PACKAGE BODY OE_SO_LIN_VALIDATE AS

1: PACKAGE BODY OE_SO_LIN_VALIDATE AS
2: /* $Header: oesolinb.pls 115.3 99/07/16 08:28:20 porting ship $ */
3:
4: FUNCTION DB_Reserved_Quantity (X_Line_Id IN NUMBER) return NUMBER is
5: DB_Res_Qty NUMBER := NULL;

Line 36: if (P_Lines_Reserved_Qty = OE_SO_LIN_VALIDATE.DB_Reserved_Quantity(P_Line_Id)) then

32: begin
33:
34: P_Result := 'Y';
35:
36: if (P_Lines_Reserved_Qty = OE_SO_LIN_VALIDATE.DB_Reserved_Quantity(P_Line_Id)) then
37: Return;
38: end if;
39:
40: if (P_Lines_Reserved_Qty > (NVL(P_Lines_Ordered_Qty, 0)

Line 50: if (OE_SO_LIN_VALIDATE.Complex_Details(P_Line_Id)) then

46: OE_MSG.Set_Buffer_Message('OE_SCH_RES_LESS_REL_QTY','RELEASED_QUANTITY',to_char(P_Lines_Released_Qty));
47: P_Result := 'N';
48: Return;
49: else
50: if (OE_SO_LIN_VALIDATE.Complex_Details(P_Line_Id)) then
51: OE_MSG.Set_Buffer_Message('OE_SCH_COMPLEX_DETAILS');
52: P_Result := 'N';
53: Return;
54: end if;

Line 192: OE_SO_LIN_VALIDATE.DB_Reserved_Quantity(X_Line_Id);

188: FROM SO_LINES
189: WHERE rowid = X_Row_Id;
190:
191: P_Db_Reserved_Quantity :=
192: OE_SO_LIN_VALIDATE.DB_Reserved_Quantity(X_Line_Id);
193:
194: exception
195: when OTHERS then
196: OE_MSG.Internal_Exception('OE_SO_LIN_VALIDATE.Get_Schedule_DB_Values',

Line 196: OE_MSG.Internal_Exception('OE_SO_LIN_VALIDATE.Get_Schedule_DB_Values',

192: OE_SO_LIN_VALIDATE.DB_Reserved_Quantity(X_Line_Id);
193:
194: exception
195: when OTHERS then
196: OE_MSG.Internal_Exception('OE_SO_LIN_VALIDATE.Get_Schedule_DB_Values',
197: 'Get_DB_Values', 'LINE');
198: Result := 'N';
199: end Get_Schedule_DB_Values;
200:

Line 251: OE_MSG.Internal_Exception('OE_SO_LIN_VALIDATE.Query_Time_Stamps',

247:
248: exception
249:
250: when OTHERS then
251: OE_MSG.Internal_Exception('OE_SO_LIN_VALIDATE.Query_Time_Stamps',
252: 'Query Time Stamps' , 'LINE');
253: Result := 'N';
254: end Query_Time_Stamps;
255:

Line 298: OE_MSG.Internal_Exception('OE_SO_LIN_VALIDATE.Load_ATO_Model',

294: when NO_DATA_FOUND then
295: NULL;
296:
297: when OTHERS then
298: OE_MSG.Internal_Exception('OE_SO_LIN_VALIDATE.Load_ATO_Model',
299: 'Load_ATO_Model' , 'LINE');
300: Result := 'N';
301: end Load_ATO_Model;
302:

Line 331: OE_MSG.Internal_Exception('OE_SO_LIN_VALIDATE.Load_Supply_Reserved',

327: when NO_DATA_FOUND then
328: NULL;
329:
330: when OTHERS then
331: OE_MSG.Internal_Exception('OE_SO_LIN_VALIDATE.Load_Supply_Reserved',
332: 'Load Supply Reserved' , 'LINE');
333: Result := 'N';
334: end Load_Supply_Reserved;
335:

Line 583: OE_MSG.Internal_Exception('OE_SO_LIN_VALIDATE.Validate_Scheduling_Attributes',

579:
580: EXCEPTION
581:
582: when OTHERS then
583: OE_MSG.Internal_Exception('OE_SO_LIN_VALIDATE.Validate_Scheduling_Attributes',
584: 'Validating Scheduling Attributes' , 'LINE');
585:
586: end Validate_Scheduling_Attributes;
587:

Line 588: END OE_SO_LIN_VALIDATE;

584: 'Validating Scheduling Attributes' , 'LINE');
585:
586: end Validate_Scheduling_Attributes;
587:
588: END OE_SO_LIN_VALIDATE;