DBA Data[Home] [Help]

APPS.OE_LIN_SCH dependencies on OE_MSG

Line 36: OE_MSG.Internal_Exception(Routine=>

32: P_Reserved_Quantity := 0;
33:
34: when others then
35: P_Return_Status:=OE_FAILURE;
36: OE_MSG.Internal_Exception(Routine=>
37: 'OE_LIN_SCH.Get_Reserved_Quantity',
38: Operation=>'Scheduling',
39: Object=>'LINE',
40: Message=>' When Others');

Line 77: OE_MSG.Internal_Exception(Routine=>

73: P_Line_released_Quantity:=0;
74:
75: when others then
76: P_Return_Status:=OE_FAILURE;
77: OE_MSG.Internal_Exception(Routine=>
78: 'OE_LIN_SCH.Get_Released_Quantity',
79: Operation=>'Scheduling',
80: Object=>'LINE',
81: Message=>' When Others');

Line 132: OE_MSG.Internal_Exception(Routine=>

128: Details_Complexity_Count:=0;
129:
130: when others then
131: P_Return_Status:=OE_FAILURE;
132: OE_MSG.Internal_Exception(Routine=>
133: 'OE_LIN_SCH.Check_Details_Complexity',
134: Operation=>'Scheduling',
135: Object=>'LINE',
136: Message=>' When Others');

Line 224: OE_MSG.Set_Buffer_Message('OE_SCH_RES_MORE_ORD_QTY','','');

220: end if;
221:
222: if (nvl(P_Reserved_Quantity,0) > (nvl(P_Ordered_Quantity,0) -
223: nvl(P_Cancelled_Quantity,0) )) then
224: OE_MSG.Set_Buffer_Message('OE_SCH_RES_MORE_ORD_QTY','','');
225: Return_Status:=OE_FAILURE;
226: Return;
227: elsif (nvl(P_Reserved_Quantity,0) < nvl(L_Released_Quantity,0)) then
228: OE_MSG.Set_Buffer_Message('OE_SCH_RES_LESS_REL_QTY','RELEASED_QUANTITY',to_char(L_Released_Quantity));

Line 228: OE_MSG.Set_Buffer_Message('OE_SCH_RES_LESS_REL_QTY','RELEASED_QUANTITY',to_char(L_Released_Quantity));

224: OE_MSG.Set_Buffer_Message('OE_SCH_RES_MORE_ORD_QTY','','');
225: Return_Status:=OE_FAILURE;
226: Return;
227: elsif (nvl(P_Reserved_Quantity,0) < nvl(L_Released_Quantity,0)) then
228: OE_MSG.Set_Buffer_Message('OE_SCH_RES_LESS_REL_QTY','RELEASED_QUANTITY',to_char(L_Released_Quantity));
229: Return_Status:=OE_FAILURE;
230: Return;
231: else
232: if L_Details_Complexity_Count > 0 then

Line 233: OE_MSG.Set_Buffer_Message('OE_SCH_COMPLEX_DETAILS','','');

229: Return_Status:=OE_FAILURE;
230: Return;
231: else
232: if L_Details_Complexity_Count > 0 then
233: OE_MSG.Set_Buffer_Message('OE_SCH_COMPLEX_DETAILS','','');
234: Return_Status:=OE_FAILURE;
235: Return;
236: end if;
237: end if;

Line 291: OE_MSG.Internal_Exception(Routine=>

287: null;
288:
289: when others then
290: P_Return_Status:=OE_FAILURE;
291: OE_MSG.Internal_Exception(Routine=>
292: 'OE_LIN_SCH.Get_Schedule_Status',
293: Operation=>'Scheduling',
294: Object=>'LINE',
295: Message=>' When Others');

Line 375: OE_MSG.Internal_Exception(Routine=>

371: P_Return_Status:=OE_SUCCESS;
372:
373: when others then
374: P_Return_Status:=OE_FAILURE;
375: OE_MSG.Internal_Exception(Routine=>
376: 'OE_LIN_SCH.Get_Schedule_DB_Values',
377: Operation=>'Scheduling',
378: Object=>'LINE',
379: Message=>' When Others');

Line 429: OE_MSG.Set_Buffer_Message('OE_SCH_NO_RES_QTY_REQUIRED','','');

425: if ( P_Lin_Obj_Reserved_Quantity is null
426: or P_Lin_Obj_Reserved_Quantity = 0 ) then
427: return;
428: else
429: OE_MSG.Set_Buffer_Message('OE_SCH_NO_RES_QTY_REQUIRED','','');
430: P_Return_Status:=OE_FAILURE;
431: return;
432: end if;
433: end if;

Line 462: OE_MSG.Set_Buffer_Message('OE_SCH_RES_QTY_CHG_NOT_ALLOWED','','');

458:
459: if ( P_Lin_Obj_Schedule_Action_Code is null ) then
460: if ( P_Lin_Obj_Reserved_quantity <> P_World_DB_Reserved_Quantity ) then
461: if ( P_Lin_Obj_Ordered_Quantity <> P_world_DB_Ordered_Quantity ) then
462: OE_MSG.Set_Buffer_Message('OE_SCH_RES_QTY_CHG_NOT_ALLOWED','','');
463: P_Return_Status:=OE_FAILURE;
464: return;
465: end if;
466: end if;

Line 469: OE_MSG.Set_Buffer_Message('OE_SCH_RES_QTY_CHG_NOT_ALLOWED','','');

465: end if;
466: end if;
467: else
468: if ( P_Lin_Obj_Ordered_Quantity <> P_world_DB_Ordered_Quantity ) then
469: OE_MSG.Set_Buffer_Message('OE_SCH_RES_QTY_CHG_NOT_ALLOWED','','');
470: P_Return_Status:=OE_FAILURE;
471: return;
472: end if;
473: end if;

Line 481: OE_MSG.Set_Buffer_Message('OE_SCH_RES_QTY_CHG_NOT_ALLOWED','','');

477: elsif ( P_Lin_Obj_Schedule_Action_Code in ( 'UNRESERVE', 'UNDEMAND',
478: 'UNSCHEDULE') ) then
479: if ( P_Lin_Obj_Reserved_quantity <> P_World_DB_Reserved_Quantity )
480: then
481: OE_MSG.Set_Buffer_Message('OE_SCH_RES_QTY_CHG_NOT_ALLOWED','','');
482: P_Return_Status:=OE_FAILURE;
483: return;
484: elsif ( P_Lin_Obj_Warehouse_Id <> P_world_DB_Warehouse_Id )
485: then

Line 486: OE_MSG.Set_Buffer_Message('OE_SCH_WH_CHG_NOT_ALLOWED','','');

482: P_Return_Status:=OE_FAILURE;
483: return;
484: elsif ( P_Lin_Obj_Warehouse_Id <> P_world_DB_Warehouse_Id )
485: then
486: OE_MSG.Set_Buffer_Message('OE_SCH_WH_CHG_NOT_ALLOWED','','');
487: P_Return_Status:=-1;
488: return;
489: elsif ( P_Lin_Obj_Schedule_Date <> P_World_DB_Schedule_Date )
490: then

Line 491: OE_MSG.Set_Buffer_Message('OE_SCH_DATE_CHG_NOT_ALLOWED','','');

487: P_Return_Status:=-1;
488: return;
489: elsif ( P_Lin_Obj_Schedule_Date <> P_World_DB_Schedule_Date )
490: then
491: OE_MSG.Set_Buffer_Message('OE_SCH_DATE_CHG_NOT_ALLOWED','','');
492: P_Return_Status:=OE_FAILURE;
493: return;
494: elsif ( P_Lin_Obj_Demand_Class_Code <> P_World_DB_Demand_Class_Code) then
495: OE_MSG.Set_Buffer_Message('OE_SCH_DEM_CL_CHG_NOT_ALLOWED','','');

Line 495: OE_MSG.Set_Buffer_Message('OE_SCH_DEM_CL_CHG_NOT_ALLOWED','','');

491: OE_MSG.Set_Buffer_Message('OE_SCH_DATE_CHG_NOT_ALLOWED','','');
492: P_Return_Status:=OE_FAILURE;
493: return;
494: elsif ( P_Lin_Obj_Demand_Class_Code <> P_World_DB_Demand_Class_Code) then
495: OE_MSG.Set_Buffer_Message('OE_SCH_DEM_CL_CHG_NOT_ALLOWED','','');
496: P_Return_Status:=OE_FAILURE;
497: return;
498: end if;
499: elsif ( P_Lin_Obj_Schedule_Action_Code in ( 'ATP CHECK', 'DEMAND')) then

Line 502: OE_MSG.Set_Buffer_Message('OE_SCH_SHIP_TO_CHG_NOT_ALLOWED','','');

498: end if;
499: elsif ( P_Lin_Obj_Schedule_Action_Code in ( 'ATP CHECK', 'DEMAND')) then
500: if ( P_Lin_Obj_Schedule_Action_Code = 'ATP CHECK' ) then
501: if ( P_Lin_Obj_Ship_To_Site_Use_Id <> P_World_DB_Ship_To_Site_Use_Id ) then
502: OE_MSG.Set_Buffer_Message('OE_SCH_SHIP_TO_CHG_NOT_ALLOWED','','');
503: P_Return_Status:=OE_FAILURE;
504: return;
505: end if;
506: end if;

Line 509: OE_MSG.Set_Buffer_Message('OE_SCH_RES_QTY_CHG_NOT_ALLOWED','','');

505: end if;
506: end if;
507: if ( P_Lin_Obj_Reserved_quantity <> P_World_DB_Reserved_Quantity )
508: then
509: OE_MSG.Set_Buffer_Message('OE_SCH_RES_QTY_CHG_NOT_ALLOWED','','');
510: P_Return_Status:=OE_FAILURE;
511: return;
512: end if;
513: elsif ( P_Lin_Obj_Schedule_Action_Code in ( 'RESERVE') ) then

Line 516: OE_MSG.Set_Buffer_Message('OE_SCH_RES_QTY_CHG_NOT_ALLOWED','','');

512: end if;
513: elsif ( P_Lin_Obj_Schedule_Action_Code in ( 'RESERVE') ) then
514: if ( P_Lin_Obj_Reserved_quantity <> P_World_DB_Reserved_Quantity )
515: then
516: OE_MSG.Set_Buffer_Message('OE_SCH_RES_QTY_CHG_NOT_ALLOWED','','');
517: P_Return_Status:=OE_FAILURE;
518: return;
519: end if;
520: end if;

Line 526: OE_MSG.Internal_Exception(Routine=>

522: exception
523:
524: when others then
525: P_Return_Status:=OE_FAILURE;
526: OE_MSG.Internal_Exception(Routine=>
527: 'OE_LIN_SCH.Validate_Scheduling_Attributes',
528: Operation=>'',
529: Object=>'LINE',
530: Message=>' When Others');

Line 578: OE_MSG.Internal_Exception(Routine=>

574: exception
575:
576: when others then
577: Return_Status:=OE_FAILURE;
578: OE_MSG.Internal_Exception(Routine=>
579: 'OE_LIN_SCH.Scheduling_Security',
580: Operation=>'',
581: Object=>'LINE',
582: Message=>' When Others');

Line 623: OE_MSG.Internal_Exception(Routine=>

619: null;
620:
621: when others then
622: P_Return_Status:=OE_FAILURE;
623: OE_MSG.Internal_Exception(Routine=>
624: 'OE_LIN.Query_Reserved_Quantity',
625: Operation=>'Scheduling',
626: Object=>'LINE',
627: Message=>' When Others');