[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
3300: p_eco_for_production => l_eco_for_production
3301: )
3302: LOOP
3303: -- operation is invalid
3304: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3305: THEN
3306: Error_Handler.Add_Error_Token
3307: ( p_message_name => 'BOM_OP_OLD_OPSEQ_INVALID'
3308: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3336: -- If the primary routing does not exist then the acd type
3337: -- of the operation must not be Add.
3338: --
3339:
3340: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3341: THEN
3342: l_token_tbl(1).token_name := 'REVISED_ITEM_NAME';
3343: l_token_tbl(1).token_value := l_com_operation_rec.revised_item_name;
3344:
3399: -- is Disabled on the ECO
3400: --
3401: IF p_old_com_operation_rec.acd_type = l_ACD_DISABLE
3402: THEN
3403: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3404: THEN
3405: Error_Handler.Add_Error_Token
3406: ( p_message_name => 'BOM_OP_DISABLED'
3407: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3416: -- For UPDATE, ACD Type not updateable
3417: --
3418: IF l_com_operation_rec.acd_type <> p_old_com_operation_rec.acd_type
3419: THEN
3420: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3421: THEN
3422: Error_Handler.Add_Error_Token
3423: ( p_message_name => 'BOM_OP_ACD_TYPE_NOT_UPDATEABLE'
3424: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3434: --
3435: IF l_com_operation_rec.old_operation_sequence_number <>
3436: p_old_com_operation_rec.old_operation_sequence_number
3437: THEN
3438: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3439: THEN
3440: Error_Handler.Add_Error_Token
3441: ( p_message_name => 'BOM_OP_OLDOPSQNM_NT_UPDATEABLE'
3442: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3452: --
3453: IF l_com_operation_rec.old_start_effective_date <>
3454: p_old_com_operation_rec.old_start_effective_date
3455: THEN
3456: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3457: THEN
3458: Error_Handler.Add_Error_Token
3459: ( p_message_name => 'BOM_OP_OLDEFFDT_NOT_UPDATEABLE'
3460: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3483: , p_rev_item_seq_id => l_com_op_unexp_rec.revised_item_sequence_id
3484: )
3485: THEN
3486:
3487: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3488: THEN
3489: Error_Handler.Add_Error_Token
3490: ( p_message_name => 'BOM_OP_CANNOT_CANCL_FOR_REVCMP'
3491: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3531: OR trunc(l_com_operation_rec.new_start_effective_date) < trunc(sysdate)
3532: **/ )
3533: THEN
3534:
3535: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3536: THEN
3537: Error_Handler.Add_Error_Token
3538: ( p_message_name => 'BOM_OP_EFFDATE_NOT_UPDATABLE'
3539: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3563: )
3564: AND BOM_Rtg_Globals.Get_Eam_Item_Type <> BOM_Rtg_Globals.G_ASSET_ACTIVITY
3565: THEN
3566:
3567: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3568: THEN
3569: Error_Handler.Add_Error_Token
3570: ( p_message_name => 'BOM_OP_DEPT_NOT_UPDATABLE'
3571: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3583: , p_dept_id => l_com_op_unexp_rec.department_id
3584: )
3585: THEN
3586:
3587: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3588: THEN
3589: Error_Handler.Add_Error_Token
3590: ( p_message_name => 'BOM_EAM_OP_DEPT_NOT_UPDATABLE'
3591: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3607: AND p_old_com_operation_rec.reference_flag = 2 -- 2:No
3608: AND l_com_operation_rec.reference_flag = 1 -- 1:Yes
3609: THEN
3610:
3611: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3612: THEN
3613: Error_Handler.Add_Error_Token
3614: ( p_message_name => 'BOM_OP_REF_NOT_ALLOWED'
3615: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3652: AND l_com_op_unexp_rec.standard_operation_id IS NULL
3653: AND l_com_operation_rec.reference_flag <> 2 -- 2:No
3654: THEN
3655:
3656: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3657: THEN
3658: Error_Handler.Add_Error_Token
3659: ( p_message_name => 'BOM_OP_REFFLAG_MUST_BE_NO'
3660: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3734: NVL( l_com_operation_rec.new_start_effective_date
3735: , l_com_operation_rec.start_effective_date)
3736: THEN
3737:
3738: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3739: THEN
3740: Error_Handler.Add_Error_Token
3741: ( p_message_name => 'BOM_OP_DISABLE_DATE_INVALID'
3742: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3762: AND l_com_operation_rec.count_point_type = 3 -- 3:Non-Direct
3763: AND l_com_operation_rec.backflush_flag <> 1 -- 1:Yes
3764: THEN
3765:
3766: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3767: THEN
3768: Error_Handler.Add_Error_Token
3769: ( p_message_name => 'BOM_OP_BKFFLAG_CPNTYPE_INVALID'
3770: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3796: AND l_bom_item_type = l_STANDARD -- 4:Standard
3797: AND l_com_operation_rec.option_dependent_flag <> 2 -- 2:No
3798: THEN
3799:
3800: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3801: THEN
3802: Error_Handler.Add_Error_Token
3803: ( p_message_name => 'BOM_OP_DPTFLAG_MUST_BE_NO'
3804: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3834: )
3835:
3836: LOOP
3837:
3838: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3839: THEN
3840: Error_Handler.Add_Error_Token
3841: ( p_message_name => 'BOM_OP_DEPT_ID_INVALID'
3842: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3866: FOR l_parenets_rec IN l_parents_csr(p_parent_seq_id
3867: => l_com_op_unexp_rec.process_op_seq_id )
3868: LOOP
3869:
3870: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3871: THEN
3872: Error_Handler.Add_Error_Token
3873: ( p_message_name => 'BOM_FLM_OP_PRT_PCSOP_INVALID'
3874: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3896: FOR l_parenets_rec IN l_parents_csr(p_parent_seq_id
3897: => l_com_op_unexp_rec.line_op_seq_id)
3898: LOOP
3899:
3900: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3901: THEN
3902: Error_Handler.Add_Error_Token
3903: ( p_message_name => 'BOM_FLM_OP_PRT_LINEOP_INVALID'
3904: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl