DBA Data[Home] [Help]

APPS.OE_LIN dependencies on OE_MSG

Line 59: OE_MSG.Set_Buffer_Message('OE_MANDIS_DISALLOWED',

55:
56: X_Global_Result:=OE_SUCCESS;
57:
58: if (X_Discounting_Privilage='NONE') then
59: OE_MSG.Set_Buffer_Message('OE_MANDIS_DISALLOWED',
60: 'REASON','OE_MANDIS_NO_PRIVILEGE');
61: X_Global_Result:=OE_FAILURE;
62: X_Reason := 'OE_MANDIS_NO_PRIVILEGE';
63: Return;

Line 91: OE_MSG.Set_Buffer_Message('OE_MANDIS_DISALLOWED',

87: WHERE HEADER_ID = X_HEADER_ID
88: AND LINE_ID = X_LINE_ID
89: AND NVL( AUTOMATIC_FLAG, 'N' ) = 'N'
90: HAVING COUNT(*) > 1;
91: OE_MSG.Set_Buffer_Message('OE_MANDIS_DISALLOWED',
92: 'REASON','OE_MANDIS_TOO_MANY');
93: X_Global_Result:=OE_FAILURE;
94: X_Reason := 'OE_MANDIS_TOO_MANY';
95: Return;

Line 104: OE_MSG.Set_Buffer_Message('OE_MANDIS_DISALLOWED',

100: end;
101: end if;
102: exception
103: when no_data_found then
104: OE_MSG.Set_Buffer_Message('OE_MANDIS_DISALLOWED',
105: 'REASON','OE_MANDIS_PRICES_ENFORCED');
106: X_Global_Result:=OE_FAILURE;
107: X_Reason := 'OE_MANDIS_PRICES_ENFORCED';
108: Return;

Line 113: OE_MSG.Set_Buffer_Message('OE_MANDIS_DISALLOWED',

109: end;
110:
111: exception
112: when no_data_found then
113: OE_MSG.Set_Buffer_Message('OE_MANDIS_DISALLOWED',
114: 'REASON','OE_MANDIS_NO_DISCOUNT');
115: X_Global_Result:=OE_FAILURE;
116: X_Reason := 'OE_MANDIS_NO_DISCOUNT';
117: Return;

Line 122: OE_MSG.Set_Buffer_Message('OE_MANDIS_DISALLOWED',

118: end;
119: /*else no else is required as this condition is tetsted at the time of
120: selling_price validation too
121: 441551
122: OE_MSG.Set_Buffer_Message('OE_MANDIS_DISALLOWED',
123: 'REASON','OE_MANDIS_NO_LIST_PRICE');
124: X_Global_Result:=OE_FAILURE;
125: X_Reason := 'OE_MANDIS_NO_LIST_PRICE';
126: Return;

Line 134: OE_MSG.Internal_Exception(Routine=>

130: exception
131:
132: when others then
133: X_Global_Result:=OE_FAILURE;
134: OE_MSG.Internal_Exception(Routine=>
135: 'OE_LIN.Check_Allow_Manual_Discount',
136: Operation=>'Pricing',
137: Object=>'LINE',
138: Message=>' When Others');

Line 275: OE_MSG.Internal_Exception(Routine=>

271: P_Global_Result:=L_Global_Result;
272:
273: when others then
274: P_Global_Result:=OE_FAILURE;
275: OE_MSG.Internal_Exception(Routine=>
276: 'OE_LIN.Apply_Manual_Discount',
277: Operation=>'Pricing',
278: Object=>'LINE',
279: Message=>' When Others');

Line 319: OE_MSG.Internal_Exception(Routine=>

315: null;
316:
317: when others then
318: P_Return_Status:=OE_FAILURE;
319: OE_MSG.Internal_Exception(Routine=>
320: 'OE_LIN.Get_Line_Object_Adj_Total',
321: Operation=>'Pricing',
322: Object=>'LINE',
323: Message=>' When Others');

Line 341: OE_MSG.Set_Buffer_Message('OE_SCH_ATO_MODEL','','');

337:
338: begin
339:
340: if (ATO_Model_Flag = 'Y') then
341: OE_MSG.Set_Buffer_Message('OE_SCH_ATO_MODEL','','');
342: Return_Status:='N';
343: else
344: Return_Status:='Y';
345: end if;

Line 351: OE_MSG.Internal_Exception(Routine=>

347: exception
348:
349: when others then
350: Return_Status:=OE_FAILURE;
351: OE_MSG.Internal_Exception(Routine=>
352: 'OE_LIN_Validate.ATO_Model',
353: Operation=>'',
354: Object=>'LINE',
355: Message=>' When Others');

Line 370: OE_MSG.Set_Buffer_Message('OE_SCH_LINE_PART_OF_ATO_CONFIG','','');

366:
367: begin
368:
369: if (ATO_Line_Id is not null) then
370: OE_MSG.Set_Buffer_Message('OE_SCH_LINE_PART_OF_ATO_CONFIG','','');
371: Return_Status:='N';
372: else
373: Return_Status:='Y';
374: end if;

Line 380: OE_MSG.Internal_Exception(Routine=>

376: exception
377:
378: when others then
379: Return_Status:=OE_FAILURE;
380: OE_MSG.Internal_Exception(Routine=>
381: 'OE_LIN_Validate.ATO_Configuration',
382: Operation=>'',
383: Object=>'LINE',
384: Message=>' When Others');

Line 399: OE_MSG.Set_Buffer_Message('OE_SCH_LINE_HAS_SUPP_RES','','');

395:
396: begin
397:
398: if (Supply_Reservation_Exists='Y') then
399: OE_MSG.Set_Buffer_Message('OE_SCH_LINE_HAS_SUPP_RES','','');
400: Return_Status:='N';
401: else
402: Return_Status:='Y';
403: end if;

Line 409: OE_MSG.Internal_Exception(Routine=>

405: exception
406:
407: when others then
408: Return_Status:=OE_FAILURE;
409: OE_MSG.Internal_Exception(Routine=>
410: 'OE_LIN.Supply_Reserved',
411: Operation=>'',
412: Object=>'LINE',
413: Message=>' When Others');

Line 430: OE_MSG.Set_Buffer_Message('OE_SCH_LINE_GROUP_MEMBER','','');

426:
427: begin
428:
429: if (DB_Record_Flag='Y' and Source_Object is not null) then
430: OE_MSG.Set_Buffer_Message('OE_SCH_LINE_GROUP_MEMBER','','');
431: Return_Status:='N';
432: else
433: Return_Status:='Y';
434: end if;

Line 439: OE_MSG.Internal_Exception(Routine=>

435: exception
436:
437: when others then
438: Return_Status:=OE_FAILURE;
439: OE_MSG.Internal_Exception(Routine=>
440: 'OE_LIN.Check_Schedule_Group',
441: Operation=>'',
442: Object=>'LINE',
443: Message=>' When Others');

Line 460: OE_MSG.Set_Buffer_Message('OE_SCH_INT_ORDER_UPD','','');

456:
457: begin
458:
459: if (Order_Category='P') then
460: OE_MSG.Set_Buffer_Message('OE_SCH_INT_ORDER_UPD','','');
461: Return_Status:='N';
462: else
463: Return_Status:='Y';
464: end if;

Line 470: OE_MSG.Internal_Exception(Routine=>

466: exception
467:
468: when others then
469: Return_Status:=OE_FAILURE;
470: OE_MSG.Internal_Exception(Routine=>
471: 'OE_LIN.Internal_Order',
472: Operation=>'',
473: Object=>'LINE',
474: Message=>' When Others');

Line 499: OE_MSG.Set_Buffer_Message('OE_SCH_LINE_FULLY_RELEASED','','');

495: WHERE ROWID = Row_Id
496: AND S2 = 4;
497:
498: if L_Count = 1 then
499: OE_MSG.Set_Buffer_Message('OE_SCH_LINE_FULLY_RELEASED','','');
500: Return_Status:='N';
501: else
502: Return_Status:='Y';
503: end if;

Line 509: OE_MSG.Internal_Exception(Routine=>

505: exception
506:
507: when others then
508: Return_Status:=OE_FAILURE;
509: OE_MSG.Internal_Exception(Routine=>
510: 'OE_LIN.Fully_Released',
511: Operation=>'',
512: Object=>'LINE',
513: Message=>' When Others');

Line 539: OE_MSG.Set_Buffer_Message('OE_SCH_LINE_FULLY_CANCELLED','','');

535: WHERE ROWID = Row_Id
536: AND ORDERED_QUANTITY = NVL(CANCELLED_QUANTITY,0);
537:
538: if L_Count = 1 then
539: OE_MSG.Set_Buffer_Message('OE_SCH_LINE_FULLY_CANCELLED','','');
540: Return_Status:='N';
541: else
542: Return_Status:='Y';
543: end if;

Line 549: OE_MSG.Internal_Exception(Routine=>

545: exception
546:
547: when others then
548: Return_Status:=OE_FAILURE;
549: OE_MSG.Internal_Exception(Routine=>
550: 'OE_LIN.Fully_Cancelled',
551: Operation=>'',
552: Object=>'LINE',
553: Message=>' When Others');

Line 584: OE_MSG.Internal_Exception(Routine=>

580: exception
581:
582: when others then
583: P_Return_Status:=OE_FAILURE;
584: OE_MSG.Internal_Exception(Routine=>
585: 'OE_LIN.Calc_Lin_Obj_Open_Quantity',
586: Operation=>'',
587: Object=>'LINE',
588: Message=>' When Others');

Line 662: OE_MSG.Internal_Exception(Routine=>

658: end if;
659:
660: when others then
661: P_Return_Status:=OE_FAILURE;
662: OE_MSG.Internal_Exception(Routine=>
663: 'OE_LIN.Load_ATO_Flag',
664: Operation=>'',
665: Object=>'LINE',
666: Message=>' When Others');

Line 720: OE_MSG.Set_Buffer_Message('OE_LIN_SERVICES_EXISTS','','');

716: fetch service_exists into l_dummy;
717: close service_exists;
718: if l_dummy is not null then
719: P_Return_Status:=OE_FAILURE;
720: OE_MSG.Set_Buffer_Message('OE_LIN_SERVICES_EXISTS','','');
721: return;
722: end if;
723: open installation_exists(p_line_id);
724: fetch installation_exists into l_dummy;

Line 728: OE_MSG.Set_Buffer_Message('OE_LIN_ISD_EXISTS','','');

724: fetch installation_exists into l_dummy;
725: close installation_exists;
726: if l_dummy is not null then
727: P_Return_Status:=OE_FAILURE;
728: OE_MSG.Set_Buffer_Message('OE_LIN_ISD_EXISTS','','');
729: return;
730: end if;
731: end;
732: else -- not a model

Line 749: OE_MSG.Set_Buffer_Message('OE_LIN_SERVICES_EXISTS','','');

745: fetch service_exists into l_dummy;
746: close service_exists;
747: if l_dummy is not null then
748: P_Return_Status:=OE_FAILURE;
749: OE_MSG.Set_Buffer_Message('OE_LIN_SERVICES_EXISTS','','');
750: return;
751: end if;
752: open installation_exists(p_line_id);
753: fetch installation_exists into l_dummy;

Line 757: OE_MSG.Set_Buffer_Message('OE_LIN_ISD_EXISTS','','');

753: fetch installation_exists into l_dummy;
754: close installation_exists;
755: if l_dummy is not null then
756: P_Return_Status:=OE_FAILURE;
757: OE_MSG.Set_Buffer_Message('OE_LIN_ISD_EXISTS','','');
758: return;
759: end if;
760: end;
761: end if; -- item_type = MODEL

Line 775: OE_MSG.Set_Buffer_Message('OE_OE_SCHEDULING_EXISTS','','');

771: AND (LINE_ID = P_Line_Id
772: OR PARENT_LINE_ID = P_Line_Id))
773: AND ROWNUM = 1;
774:
775: OE_MSG.Set_Buffer_Message('OE_OE_SCHEDULING_EXISTS','','');
776:
777: P_Return_Status:=OE_FAILURE;
778:
779: exception

Line 799: OE_MSG.Set_Buffer_Message('OE_OE_LINE_CONFIG_PROCESSED','','');

795: OR OPEN_FLAG IS NULL)
796: AND ROWNUM = 1;
797:
798: P_Return_Status:=OE_FAILURE;
799: OE_MSG.Set_Buffer_Message('OE_OE_LINE_CONFIG_PROCESSED','','');
800: exception
801: when no_data_found then
802: null;
803: end;

Line 809: OE_MSG.Internal_Exception(Routine=>

805:
806:
807: when others then
808: P_Return_Status:=OE_FAILURE;
809: OE_MSG.Internal_Exception(Routine=>
810: 'OE_LIN.Check_Navigate_Shipments',
811: Operation=>'',
812: Object=>'LINE',
813: Message=>' When Others');

Line 848: OE_MSG.Internal_Exception(Routine=>

844: exception
845:
846: when others then
847: P_Return_Status:=OE_FAILURE;
848: OE_MSG.Internal_Exception(Routine=>
849: 'OE_LIN.Update_Shippable_Flag',
850: Operation=>'',
851: Object=>'LINE',
852: Message=>' When Others');