DBA Data[Home] [Help]

APPS.OE_SO_PLN_SERVER dependencies on OE_MSG

Line 51: OE_MSG.Set_Buffer_Message('OE_SCH_RES_QTY_CHG_NOT_ALLOWED');

47: Return;
48: end if;
49: if P_Schedule_Action_Code in ('RESERVE') then
50: if P_Reserved_Quantity <> P_Db_Reserved_Quantity then
51: OE_MSG.Set_Buffer_Message('OE_SCH_RES_QTY_CHG_NOT_ALLOWED');
52: end if;
53: elsif P_Schedule_Action_Code in ('UNRESERVE','UNDEMAND','UNSCHEDULE') then
54: if P_Warehouse_Id <> P_Db_Warehouse_Id then
55: OE_MSG.Set_Buffer_Message('OE_SCH_WH_CHG_NOT_ALLOWED');

Line 55: OE_MSG.Set_Buffer_Message('OE_SCH_WH_CHG_NOT_ALLOWED');

51: OE_MSG.Set_Buffer_Message('OE_SCH_RES_QTY_CHG_NOT_ALLOWED');
52: end if;
53: elsif P_Schedule_Action_Code in ('UNRESERVE','UNDEMAND','UNSCHEDULE') then
54: if P_Warehouse_Id <> P_Db_Warehouse_Id then
55: OE_MSG.Set_Buffer_Message('OE_SCH_WH_CHG_NOT_ALLOWED');
56: else
57: if P_Schedule_Date <> P_Db_Schedule_Date then
58: OE_MSG.Set_Buffer_Message('OE_SCH_DATE_CHG_NOT_ALLOWED');
59: else

Line 58: OE_MSG.Set_Buffer_Message('OE_SCH_DATE_CHG_NOT_ALLOWED');

54: if P_Warehouse_Id <> P_Db_Warehouse_Id then
55: OE_MSG.Set_Buffer_Message('OE_SCH_WH_CHG_NOT_ALLOWED');
56: else
57: if P_Schedule_Date <> P_Db_Schedule_Date then
58: OE_MSG.Set_Buffer_Message('OE_SCH_DATE_CHG_NOT_ALLOWED');
59: else
60: if P_Demand_Class_Code <> P_Db_Demand_Class_Code then
61: OE_MSG.Set_Buffer_Message('OE_SCH_DEM_CL_CHG_NOT_ALLOWED');
62: end if;

Line 61: OE_MSG.Set_Buffer_Message('OE_SCH_DEM_CL_CHG_NOT_ALLOWED');

57: if P_Schedule_Date <> P_Db_Schedule_Date then
58: OE_MSG.Set_Buffer_Message('OE_SCH_DATE_CHG_NOT_ALLOWED');
59: else
60: if P_Demand_Class_Code <> P_Db_Demand_Class_Code then
61: OE_MSG.Set_Buffer_Message('OE_SCH_DEM_CL_CHG_NOT_ALLOWED');
62: end if;
63: end if;
64: end if;
65: elsif P_Schedule_Action_Code = 'DEMAND' then

Line 67: OE_MSG.Set_Buffer_Message('OE_SCH_RES_QTY_CHG_NOT_ALLOWED');

63: end if;
64: end if;
65: elsif P_Schedule_Action_Code = 'DEMAND' then
66: if P_Reserved_Quantity <> P_Db_Reserved_Quantity then
67: OE_MSG.Set_Buffer_Message('OE_SCH_RES_QTY_CHG_NOT_ALLOWED');
68: else
69: if P_Warehouse_Id <> P_Db_Warehouse_Id then
70: OE_MSG.Set_Buffer_Message('OE_SCH_WH_CHG_NOT_ALLOWED');
71: else

Line 70: OE_MSG.Set_Buffer_Message('OE_SCH_WH_CHG_NOT_ALLOWED');

66: if P_Reserved_Quantity <> P_Db_Reserved_Quantity then
67: OE_MSG.Set_Buffer_Message('OE_SCH_RES_QTY_CHG_NOT_ALLOWED');
68: else
69: if P_Warehouse_Id <> P_Db_Warehouse_Id then
70: OE_MSG.Set_Buffer_Message('OE_SCH_WH_CHG_NOT_ALLOWED');
71: else
72: if P_Schedule_Date <> P_Db_Schedule_Date then
73: OE_MSG.Set_Buffer_Message('OE_SCH_DATE_CHG_NOT_ALLOWED');
74: else

Line 73: OE_MSG.Set_Buffer_Message('OE_SCH_DATE_CHG_NOT_ALLOWED');

69: if P_Warehouse_Id <> P_Db_Warehouse_Id then
70: OE_MSG.Set_Buffer_Message('OE_SCH_WH_CHG_NOT_ALLOWED');
71: else
72: if P_Schedule_Date <> P_Db_Schedule_Date then
73: OE_MSG.Set_Buffer_Message('OE_SCH_DATE_CHG_NOT_ALLOWED');
74: else
75: if P_Demand_Class_Code <> P_Db_Demand_Class_Code then
76: OE_MSG.Set_Buffer_Message('OE_SCH_DEM_CL_CHG_NOT_ALLOWED');
77: end if;

Line 76: OE_MSG.Set_Buffer_Message('OE_SCH_DEM_CL_CHG_NOT_ALLOWED');

72: if P_Schedule_Date <> P_Db_Schedule_Date then
73: OE_MSG.Set_Buffer_Message('OE_SCH_DATE_CHG_NOT_ALLOWED');
74: else
75: if P_Demand_Class_Code <> P_Db_Demand_Class_Code then
76: OE_MSG.Set_Buffer_Message('OE_SCH_DEM_CL_CHG_NOT_ALLOWED');
77: end if;
78: end if;
79: end if;
80: end if;

Line 83: OE_MSG.Set_Buffer_Message('OE_SCH_SHIP_TO_CHG_NOT_ALLOWED');

79: end if;
80: end if;
81: elsif P_Schedule_Action_Code = 'ATP CHECK' then
82: if P_Ship_To_Site_Use_Id <> P_Db_Ship_To_Site_Use_Id then
83: OE_MSG.Set_Buffer_Message('OE_SCH_SHIP_TO_CHG_NOT_ALLOWED');
84: else
85: if P_Reserved_Quantity <> P_Db_Reserved_Quantity then
86: OE_MSG.Set_Buffer_Message('OE_SCH_RES_QTY_CHG_NOT_ALLOWED');
87: else

Line 86: OE_MSG.Set_Buffer_Message('OE_SCH_RES_QTY_CHG_NOT_ALLOWED');

82: if P_Ship_To_Site_Use_Id <> P_Db_Ship_To_Site_Use_Id then
83: OE_MSG.Set_Buffer_Message('OE_SCH_SHIP_TO_CHG_NOT_ALLOWED');
84: else
85: if P_Reserved_Quantity <> P_Db_Reserved_Quantity then
86: OE_MSG.Set_Buffer_Message('OE_SCH_RES_QTY_CHG_NOT_ALLOWED');
87: else
88: if P_Warehouse_Id <> P_Db_Warehouse_Id then
89: OE_MSG.Set_Buffer_Message('OE_SCH_WH_CHG_NOT_ALLOWED');
90: else

Line 89: OE_MSG.Set_Buffer_Message('OE_SCH_WH_CHG_NOT_ALLOWED');

85: if P_Reserved_Quantity <> P_Db_Reserved_Quantity then
86: OE_MSG.Set_Buffer_Message('OE_SCH_RES_QTY_CHG_NOT_ALLOWED');
87: else
88: if P_Warehouse_Id <> P_Db_Warehouse_Id then
89: OE_MSG.Set_Buffer_Message('OE_SCH_WH_CHG_NOT_ALLOWED');
90: else
91: if P_Schedule_Date <> P_Db_Schedule_Date then
92: OE_MSG.Set_Buffer_Message('OE_SCH_DATE_CHG_NOT_ALLOWED');
93: else

Line 92: OE_MSG.Set_Buffer_Message('OE_SCH_DATE_CHG_NOT_ALLOWED');

88: if P_Warehouse_Id <> P_Db_Warehouse_Id then
89: OE_MSG.Set_Buffer_Message('OE_SCH_WH_CHG_NOT_ALLOWED');
90: else
91: if P_Schedule_Date <> P_Db_Schedule_Date then
92: OE_MSG.Set_Buffer_Message('OE_SCH_DATE_CHG_NOT_ALLOWED');
93: else
94: if P_Demand_Class_Code <> P_Db_Demand_Class_Code then
95: OE_MSG.Set_Buffer_Message('OE_SCH_DEM_CL_CHG_NOT_ALLOWED');
96: end if;

Line 95: OE_MSG.Set_Buffer_Message('OE_SCH_DEM_CL_CHG_NOT_ALLOWED');

91: if P_Schedule_Date <> P_Db_Schedule_Date then
92: OE_MSG.Set_Buffer_Message('OE_SCH_DATE_CHG_NOT_ALLOWED');
93: else
94: if P_Demand_Class_Code <> P_Db_Demand_Class_Code then
95: OE_MSG.Set_Buffer_Message('OE_SCH_DEM_CL_CHG_NOT_ALLOWED');
96: end if;
97: end if;
98: end if;
99: end if;

Line 108: OE_MSG.Internal_Exception

104: Return;
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;

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 588: OE_MSG.Set_Buffer_Message('OE_SCH_RES_MORE_ORD_QTY');

584: end if;
585:
586: if (P_Reserved_Qty > (NVL(P_Original_Requested_Qty, 0)
587: - NVL(P_Cancelled_Qty, 0) )) then
588: OE_MSG.Set_Buffer_Message('OE_SCH_RES_MORE_ORD_QTY');
589: P_Result := 'N';
590: Return;
591: elsif (P_Reserved_Qty < NVL(P_Released_Qty, 0) ) then
592: OE_MSG.Set_Buffer_Message('OE_SCH_RES_LESS_REL_QTY','RELEASED_QUANTITY',to_char(P_Released_Qty));

Line 592: OE_MSG.Set_Buffer_Message('OE_SCH_RES_LESS_REL_QTY','RELEASED_QUANTITY',to_char(P_Released_Qty));

588: OE_MSG.Set_Buffer_Message('OE_SCH_RES_MORE_ORD_QTY');
589: P_Result := 'N';
590: Return;
591: elsif (P_Reserved_Qty < NVL(P_Released_Qty, 0) ) 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

Line 597: OE_MSG.Set_Buffer_Message('OE_SCH_COMPLEX_DETAILS');

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;
601: end if;