[Home] [Help]
1310: AND p_com_operation_rec.op_lead_time_percent <> FND_API.G_MISS_NUM
1311: AND (p_com_operation_rec.op_lead_time_percent < 0
1312: OR p_com_operation_rec.op_lead_time_percent > 100 )
1313: THEN
1314: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1315: THEN
1316: Error_Handler.Add_Error_Token
1317: ( p_Message_Name => 'BOM_OP_LT_PERCENT_INVALID'
1318: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1328: IF p_com_operation_rec.minimum_transfer_quantity IS NOT NULL
1329: AND p_com_operation_rec.minimum_transfer_quantity < 0
1330: AND p_com_operation_rec.minimum_transfer_quantity <> FND_API.G_MISS_NUM
1331: THEN
1332: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1333: THEN
1334: Error_Handler.Add_Error_Token
1335: ( p_Message_Name => 'BOM_OP_MINI_TRANS_QTY_INVALID'
1336: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1346: IF p_com_operation_rec.count_point_type IS NOT NULL
1347: AND p_com_operation_rec.count_point_type NOT IN (1,2,3)
1348: AND p_com_operation_rec.count_point_type <> FND_API.G_MISS_NUM
1349: THEN
1350: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1351: THEN
1352: Error_Handler.Add_Error_Token
1353: ( p_Message_Name => 'BOM_OP_CNTPOINT_TYPE_INVALID'
1354: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1365: IF p_com_operation_rec.backflush_flag IS NOT NULL
1366: AND p_com_operation_rec.backflush_flag NOT IN (1,2)
1367: AND p_com_operation_rec.backflush_flag <> FND_API.G_MISS_NUM
1368: THEN
1369: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1370: THEN
1371: Error_Handler.Add_Error_Token
1372: ( p_Message_Name => 'BOM_OP_BKFLUSH_FLAG_INVALID'
1373: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1383: IF p_com_operation_rec.option_dependent_flag IS NOT NULL
1384: AND p_com_operation_rec.option_dependent_flag NOT IN (1,2)
1385: AND p_com_operation_rec.option_dependent_flag <> FND_API.G_MISS_NUM
1386: THEN
1387: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1388: THEN
1389: Error_Handler.Add_Error_Token
1390: ( p_Message_Name => 'BOM_OP_DPTFLAG_INVALID'
1391: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1401: IF p_com_operation_rec.reference_flag IS NOT NULL
1402: AND p_com_operation_rec.reference_flag NOT IN (1,2)
1403: AND p_com_operation_rec.reference_flag <> FND_API.G_MISS_NUM
1404: THEN
1405: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1406: THEN
1407: Error_Handler.Add_Error_Token
1408: ( p_Message_Name => 'BOM_OP_REFERENCE_INVALID'
1409: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1419: IF p_com_operation_rec.include_in_rollup IS NOT NULL
1420: AND p_com_operation_rec.include_in_rollup NOT IN (1,2)
1421: AND p_com_operation_rec.include_in_rollup <> FND_API.G_MISS_NUM
1422: THEN
1423: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1424: THEN
1425: Error_Handler.Add_Error_Token
1426: ( p_Message_Name => 'BOM_OP_ICDROLLUP_INVALID'
1427: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1437: IF p_com_operation_rec.op_yield_enabled_flag IS NOT NULL
1438: AND p_com_operation_rec.op_yield_enabled_flag NOT IN (1,2)
1439: AND p_com_operation_rec.op_yield_enabled_flag <> FND_API.G_MISS_NUM
1440: THEN
1441: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1442: THEN
1443: Error_Handler.Add_Error_Token
1444: ( p_Message_Name => 'BOM_OP_YILEDENABLED_INVALID'
1445: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1456: (p_com_operation_rec.yield <= 0
1457: OR p_com_operation_rec.yield > 1 )
1458: AND p_com_operation_rec.yield <> FND_API.G_MISS_NUM
1459: THEN
1460: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1461: THEN
1462: Error_Handler.Add_Error_Token
1463: ( p_Message_Name => 'BOM_OP_YIELD_INVALID'
1464: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1475: (p_com_operation_rec.cumulative_yield < 0
1476: OR p_com_operation_rec.cumulative_yield > 1 )
1477: AND p_com_operation_rec.cumulative_yield <> FND_API.G_MISS_NUM
1478: THEN
1479: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1480: THEN
1481: Error_Handler.Add_Error_Token
1482: ( p_Message_Name => 'BOM_OP_CUM_YIELD_INVALID'
1483: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1494: (p_com_operation_rec.reverse_cum_yield < 0
1495: OR p_com_operation_rec.reverse_cum_yield > 1 )
1496: AND p_com_operation_rec.reverse_cum_yield <> FND_API.G_MISS_NUM
1497: THEN
1498: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1499: THEN
1500: Error_Handler.Add_Error_Token
1501: ( p_Message_Name => 'BOM_OP_REVCUM_YIELD_INVALID'
1502: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1513: (p_com_operation_rec.net_planning_percent < 0
1514: OR p_com_operation_rec.net_planning_percent > 100 )
1515: AND p_com_operation_rec.net_planning_percent <> FND_API.G_MISS_NUM
1516: THEN
1517: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1518: THEN
1519: Error_Handler.Add_Error_Token
1520: ( p_Message_Name => 'BOM_FLM_OP_NETPLNPCT_INVALID'
1521: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1533: AND BOM_Rtg_Globals.Get_Eam_Item_Type = BOM_Rtg_Globals.G_ASSET_ACTIVITY
1534: AND NOT Bom_Rtg_Eam_Util.CheckShutdownType
1535: (p_shutdown_type => p_com_operation_rec.shutdown_type )
1536: THEN
1537: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1538: THEN
1539: Error_Handler.Add_Error_Token
1540: ( p_Message_Name => 'BOM_EAM_SHUTDOWN_TYPE_INVALID'
1541: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1554:
1555: IF BOM_RTG_GLOBALS.Get_Routing_Header_ECN(p_com_op_unexp_rec.Routing_Sequence_Id) IS NOT NULL
1556: AND (p_com_operation_rec.eco_name IS NULL OR p_com_operation_rec.eco_name = FND_API.G_MISS_CHAR)
1557: THEN
1558: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1559: THEN
1560: l_Token_Tbl(1).token_name := 'ALTERNATE';
1561: l_Token_Tbl(1).token_value := nvl(p_com_operation_rec.Alternate_Routing_Code, bom_globals.retrieve_message('BOM', 'BOM_PRIMARY'));
1562: l_Token_Tbl(2).token_name := 'ASSY_ITEM';
2429: AND ( NVL(p_old_com_op_unexp_rec.standard_operation_id, FND_API.G_MISS_NUM ) <>
2430: NVL(l_com_op_unexp_rec.standard_operation_id, FND_API.G_MISS_NUM )
2431: )
2432: THEN
2433: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2434: THEN
2435:
2436: Error_Handler.Add_Error_Token
2437: ( p_message_name => 'BOM_OP_STD_OP_NOTUPDATABLE'
2462: THEN
2463: IF (nvl(p_old_com_operation_rec.Minimum_Transfer_Quantity,-1) <>
2464: nvl(l_com_operation_rec.Minimum_Transfer_Quantity,-1))
2465: THEN
2466: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2467: THEN
2468:
2469: Error_Handler.Add_Error_Token
2470: ( p_message_name => 'BOM_STD_MTQ_NOT_UPDATABLE'
2477: END IF;
2478:
2479: IF (p_old_com_operation_rec.Count_Point_Type <> l_com_operation_rec.Count_Point_Type)
2480: THEN
2481: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2482: THEN
2483:
2484: Error_Handler.Add_Error_Token
2485: ( p_message_name => 'BOM_STD_CPT_NOT_UPDATABLE'
2492: END IF;
2493:
2494: IF (p_old_com_operation_rec.Backflush_Flag <> l_com_operation_rec.Backflush_Flag)
2495: THEN
2496: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2497: THEN
2498:
2499: Error_Handler.Add_Error_Token
2500: ( p_message_name => 'BOM_STD_BFF_NOT_UPDATABLE'
2507: END IF;
2508:
2509: IF (p_old_com_operation_rec.Option_Dependent_Flag <> l_com_operation_rec.Option_Dependent_Flag)
2510: THEN
2511: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2512: THEN
2513:
2514: Error_Handler.Add_Error_Token
2515: ( p_message_name => 'BOM_STD_ODF_NOT_UPDATABLE'
2523:
2524: IF (nvl(p_old_com_operation_rec.Operation_Description,'None') <>
2525: nvl(l_com_operation_rec.Operation_Description,'None'))
2526: THEN
2527: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2528: THEN
2529:
2530: Error_Handler.Add_Error_Token
2531: ( p_message_name => 'BOM_STD_OPD_NOT_UPDATABLE'
2539:
2540: IF (nvl(p_old_com_operation_rec.Long_Description,'NONE') <>
2541: nvl(l_com_operation_rec.Long_Description,'NONE'))
2542: THEN
2543: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2544: THEN
2545:
2546: Error_Handler.Add_Error_Token
2547: ( p_message_name => 'BOM_STD_LD_NOT_UPDATABLE'
2579: l_copy_std_op := TRUE ;
2580: FOR l_exist_res_rec IN l_exist_res_cur
2581: ( p_op_seq_id => l_com_op_unexp_rec.operation_sequence_id )
2582: LOOP
2583: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2584: THEN
2585: Error_Handler.Add_Error_Token
2586: ( p_message_name => 'BOM_OP_CANNOT_COPY_STD_OP'
2587: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2599: THEN
2600: FOR l_exist_res_rec IN l_exist_res_cur
2601: ( p_op_seq_id => l_com_op_unexp_rec.old_operation_sequence_id )
2602: LOOP
2603: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2604: THEN
2605: Error_Handler.Add_Error_Token
2606: ( p_message_name => 'BOM_OP_CANNOT_COPY_STD_OP'
2607: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2634: )
2635: LOOP
2636:
2637: -- invalid standard op code
2638: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2639: THEN
2640: Error_Handler.Add_Error_Token
2641: ( p_message_name => 'BOM_OP_STD_OP_INVALID'
2642: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2657: LOOP
2658: -- The standard operation contains alternate resources
2659: -- We need to warn the user to change the schedule sequence number which will be defaulted to 0
2660: -- We will also unreference this standard operation as the user still has to enter the SSN
2661: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2662: THEN
2663: Error_Handler.Add_Error_Token
2664: ( p_message_name => 'BOM_SSN_ZERO_VALUE'
2665: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3299: p_eco_for_production => l_eco_for_production
3300: )
3301: LOOP
3302: -- operation is invalid
3303: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3304: THEN
3305: Error_Handler.Add_Error_Token
3306: ( p_message_name => 'BOM_OP_OLD_OPSEQ_INVALID'
3307: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3335: -- If the primary routing does not exist then the acd type
3336: -- of the operation must not be Add.
3337: --
3338:
3339: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3340: THEN
3341: l_token_tbl(1).token_name := 'REVISED_ITEM_NAME';
3342: l_token_tbl(1).token_value := l_com_operation_rec.revised_item_name;
3343:
3398: -- is Disabled on the ECO
3399: --
3400: IF p_old_com_operation_rec.acd_type = l_ACD_DISABLE
3401: THEN
3402: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3403: THEN
3404: Error_Handler.Add_Error_Token
3405: ( p_message_name => 'BOM_OP_DISABLED'
3406: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3415: -- For UPDATE, ACD Type not updateable
3416: --
3417: IF l_com_operation_rec.acd_type <> p_old_com_operation_rec.acd_type
3418: THEN
3419: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3420: THEN
3421: Error_Handler.Add_Error_Token
3422: ( p_message_name => 'BOM_OP_ACD_TYPE_NOT_UPDATEABLE'
3423: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3433: --
3434: IF l_com_operation_rec.old_operation_sequence_number <>
3435: p_old_com_operation_rec.old_operation_sequence_number
3436: THEN
3437: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3438: THEN
3439: Error_Handler.Add_Error_Token
3440: ( p_message_name => 'BOM_OP_OLDOPSQNM_NT_UPDATEABLE'
3441: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3451: --
3452: IF l_com_operation_rec.old_start_effective_date <>
3453: p_old_com_operation_rec.old_start_effective_date
3454: THEN
3455: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3456: THEN
3457: Error_Handler.Add_Error_Token
3458: ( p_message_name => 'BOM_OP_OLDEFFDT_NOT_UPDATEABLE'
3459: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3482: , p_rev_item_seq_id => l_com_op_unexp_rec.revised_item_sequence_id
3483: )
3484: THEN
3485:
3486: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3487: THEN
3488: Error_Handler.Add_Error_Token
3489: ( p_message_name => 'BOM_OP_CANNOT_CANCL_FOR_REVCMP'
3490: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3530: OR trunc(l_com_operation_rec.new_start_effective_date) < trunc(sysdate)
3531: **/ )
3532: THEN
3533:
3534: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3535: THEN
3536: Error_Handler.Add_Error_Token
3537: ( p_message_name => 'BOM_OP_EFFDATE_NOT_UPDATABLE'
3538: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3562: )
3563: AND BOM_Rtg_Globals.Get_Eam_Item_Type <> BOM_Rtg_Globals.G_ASSET_ACTIVITY
3564: THEN
3565:
3566: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3567: THEN
3568: Error_Handler.Add_Error_Token
3569: ( p_message_name => 'BOM_OP_DEPT_NOT_UPDATABLE'
3570: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3582: , p_dept_id => l_com_op_unexp_rec.department_id
3583: )
3584: THEN
3585:
3586: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3587: THEN
3588: Error_Handler.Add_Error_Token
3589: ( p_message_name => 'BOM_EAM_OP_DEPT_NOT_UPDATABLE'
3590: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3606: AND p_old_com_operation_rec.reference_flag = 2 -- 2:No
3607: AND l_com_operation_rec.reference_flag = 1 -- 1:Yes
3608: THEN
3609:
3610: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3611: THEN
3612: Error_Handler.Add_Error_Token
3613: ( p_message_name => 'BOM_OP_REF_NOT_ALLOWED'
3614: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3651: AND l_com_op_unexp_rec.standard_operation_id IS NULL
3652: AND l_com_operation_rec.reference_flag <> 2 -- 2:No
3653: THEN
3654:
3655: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3656: THEN
3657: Error_Handler.Add_Error_Token
3658: ( p_message_name => 'BOM_OP_REFFLAG_MUST_BE_NO'
3659: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3733: NVL( l_com_operation_rec.new_start_effective_date
3734: , l_com_operation_rec.start_effective_date)
3735: THEN
3736:
3737: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3738: THEN
3739: Error_Handler.Add_Error_Token
3740: ( p_message_name => 'BOM_OP_DISABLE_DATE_INVALID'
3741: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3761: AND l_com_operation_rec.count_point_type = 3 -- 3:Non-Direct
3762: AND l_com_operation_rec.backflush_flag <> 1 -- 1:Yes
3763: THEN
3764:
3765: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3766: THEN
3767: Error_Handler.Add_Error_Token
3768: ( p_message_name => 'BOM_OP_BKFFLAG_CPNTYPE_INVALID'
3769: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3795: AND l_bom_item_type = l_STANDARD -- 4:Standard
3796: AND l_com_operation_rec.option_dependent_flag <> 2 -- 2:No
3797: THEN
3798:
3799: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3800: THEN
3801: Error_Handler.Add_Error_Token
3802: ( p_message_name => 'BOM_OP_DPTFLAG_MUST_BE_NO'
3803: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3833: )
3834:
3835: LOOP
3836:
3837: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3838: THEN
3839: Error_Handler.Add_Error_Token
3840: ( p_message_name => 'BOM_OP_DEPT_ID_INVALID'
3841: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3865: FOR l_parenets_rec IN l_parents_csr(p_parent_seq_id
3866: => l_com_op_unexp_rec.process_op_seq_id )
3867: LOOP
3868:
3869: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3870: THEN
3871: Error_Handler.Add_Error_Token
3872: ( p_message_name => 'BOM_FLM_OP_PRT_PCSOP_INVALID'
3873: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3895: FOR l_parenets_rec IN l_parents_csr(p_parent_seq_id
3896: => l_com_op_unexp_rec.line_op_seq_id)
3897: LOOP
3898:
3899: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3900: THEN
3901: Error_Handler.Add_Error_Token
3902: ( p_message_name => 'BOM_FLM_OP_PRT_LINEOP_INVALID'
3903: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl