eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ENG_VALIDATE_ECO dependencies on FND_MSG_PUB

Line 220: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

216:
217: EXCEPTION
218:
219: WHEN OTHERS THEN
220: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
221: THEN
222: l_err_text := G_PKG_NAME || ' : (Compatible_Change_Order_Type) -
223: Change_Notice ' || substrb(SQLERRM,1,200);
224: Error_Handler.Add_Error_Token

Line 268: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

264:
265: IF p_ECO_rec.Transaction_Type = ENG_Globals.G_OPR_DELETE AND
266: (l_ri_exists = 1 OR p_unexp_eco_rec.approval_status_type in (2,3,5))
267: THEN
268: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
269: THEN
270: Error_Handler.Add_Error_Token
271: ( p_Message_Name => 'ENG_ECO_CANNOT_DELETE'
272: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 575: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

571:
572: IF p_ECO_rec.Transaction_Type = ENG_Globals.G_OPR_DELETE AND
573: l_ri_exists = 1
574: THEN
575: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
576: THEN
577: Error_Handler.Add_Error_Token
578: ( p_Message_Name => 'ENG_ECO_CANNOT_DELETE'
579: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 591: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

587: --Bug 2921474
588: IF p_ECO_rec.Transaction_Type = ENG_Globals.G_OPR_DELETE AND
589: l_cl_exists =1
590: THEN
591: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
592: THEN
593: Error_Handler.Add_Error_Token
594: ( p_Message_Name => 'ENG_ECO_CANNOT_DELETE_CL'
595: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 607: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

603:
604: IF p_ECO_rec.Transaction_Type = ENG_Globals.G_OPR_DELETE AND
605: l_er_exists =1
606: THEN
607: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
608: THEN
609: Error_Handler.Add_Error_Token
610: ( p_Message_Name => 'ENG_ECO_CANNOT_DELETE_ER'
611: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 631: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

627: THEN
628: l_Token_Tbl(2).token_name := 'STATUS_TYPE';
629: l_Token_Tbl(2).token_value := p_Unexp_ECO_rec.status_type;
630:
631: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
632: THEN
633: Error_Handler.Add_Error_Token
634: ( p_Message_Name => 'ENG_ECO_STAT_MUST_NOT_BE_CNCL'
635: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 658: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

654: IF NOT Check_Ref_Rev_Comp_For_ECO( p_eco_name => p_eco_rec.ECO_Name
655: , p_organization_id => p_unexp_ECO_rec.organization_id
656: )
657: THEN
658: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
659: THEN
660: Error_Handler.Add_Error_Token
661: ( p_Message_Name => 'ENG_ECO_CANNOT_CNCL_FOR_REV_OP'
662: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 688: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

684: /*
685: IF p_Unexp_ECO_rec.approval_list_id IS NOT NULL AND
686: l_process_name IS NOT NULL
687: THEN
688: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
689: THEN
690: Error_Handler.Add_Error_Token
691: ( p_Message_Name => 'ENG_APPROV_LIST_PROCESS_EXISTS'
692: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 713: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

709: p_Unexp_ECO_rec.approval_list_id IS NULL AND
710: l_process_name IS NULL AND
711: p_Unexp_ECO_rec.approval_status_type NOT IN (4,5))
712: THEN
713: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
714: THEN
715: Error_Handler.Add_Error_Token
716: ( p_Message_Name => 'ENG_APP_STATUS_REJ_APPROV'
717: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 737: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

733: IF p_Unexp_ECO_rec.approval_status_type <> 5 AND
734: (p_Unexp_ECO_rec.status_type = 4 OR
735: l_ri_sched_exists = 1)
736: THEN
737: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
738: THEN
739: l_token_tbl(1).token_name := 'ECO_NAME';
740: l_token_tbl(1).token_value := p_ECO_rec.eco_name;
741: Error_Handler.Add_Error_Token

Line 762: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

758: -- Approval Requested, Rejected, or Approved
759:
760: IF p_Unexp_ECO_rec.approval_status_type NOT IN (1,2,3,4,5)
761: THEN
762: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
763: THEN
764: l_token_tbl(2).token_name := 'APPROVAL_STATUS_TYPE';
765: l_token_tbl(2).token_value := p_Unexp_ECO_rec.Approval_Status_Type;
766: Error_Handler.Add_Error_Token

Line 782: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

778: IF p_old_Unexp_ECO_rec.approval_status_type = 3 AND
779: (p_ECO_rec.Transaction_Type = ENG_GLOBALS.G_OPR_UPDATE AND
780: NVL(p_Unexp_ECO_rec.approval_list_id, 0) <> NVL(p_old_Unexp_ECO_rec.approval_list_id, 0))
781: THEN
782: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
783: THEN
784: Error_Handler.Add_Error_Token
785: ( p_Message_Name => 'ENG_APP_LIST_MUST_NOT_CHANGE'
786: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 801: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

797: IF p_old_Unexp_ECO_rec.approval_status_type = 3 AND
798: (p_ECO_rec.Transaction_Type = ENG_GLOBALS.G_OPR_UPDATE AND
799: p_Unexp_ECO_rec.status_type <> p_old_Unexp_ECO_rec.status_type)
800: THEN
801: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
802: THEN
803: Error_Handler.Add_Error_Token
804: ( p_Message_Name => 'ENG_STAT_TYPE_MUST_NOT_CHANGE'
805: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 833: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

829: p_Unexp_ECO_rec.approval_status_type <> p_old_Unexp_ECO_rec.approval_status_type))
830: AND
831: p_Unexp_ECO_rec.approval_status_type IN (2,3,4,5,7)
832: THEN
833: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
834: THEN
835: l_token_tbl(2).token_name := 'APPROVAL_STATUS_TYPE';
836: l_token_tbl(2).token_value := p_Unexp_ECO_rec.Approval_Status_Type;
837: Error_Handler.Add_Error_Token

Line 853: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

849: IF p_ECO_rec.Transaction_Type = ENG_Globals.G_OPR_UPDATE AND
850: p_Unexp_ECO_rec.status_type <> p_old_Unexp_ECO_rec.status_type AND
851: p_Unexp_ECO_rec.status_type = 4
852: THEN
853: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
854: THEN
855: Error_Handler.Add_Error_Token
856: ( p_Message_Name => 'ENG_PROC_CANNOT_SCHEDULE'
857: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 871: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

867: NVL(p_ECO_rec.priority_code, 'NONE') <> NVL(p_old_ECO_rec.priority_code, 'NONE') AND
868: (p_old_Unexp_ECO_rec.status_type = 4
869: OR l_ri_sched_exists = 1)
870: THEN
871: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
872: THEN
873: l_token_tbl(1).token_value := 'ECO_NAME';
874: l_token_tbl(1).token_value := p_eco_rec.eco_name;
875: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('eco name: ' || p_eco_rec.eco_name); END IF;

Line 896: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

892:
893: IF p_Unexp_ECO_rec.status_type <> 5 AND
894: p_ECO_rec.cancellation_comments IS NOT NULL
895: THEN
896: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
897: THEN
898: Error_Handler.Add_Error_Token
899: ( p_Message_Name => 'ENG_ECO_CANCL_DETAILS_EXIST'
900: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 926: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

922: -- the assembly type of any existing revised items
923:
924: IF l_change_order_type_same = 0
925: THEN
926: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
927: THEN
928: Error_Handler.Add_Error_Token
929: ( p_Message_Name => 'ENG_ECO_CANCL_DETAILS_EXIST'
930: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 955: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

951: NVL(p_ECO_rec.organization_hierarchy, FND_API.G_MISS_CHAR) <>
952: NVL(p_old_ECO_rec.organization_hierarchy, FND_API.G_MISS_CHAR)
953: )
954: THEN
955: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
956: THEN
957: Error_Handler.Add_Error_Token
958: ( p_Message_Name => 'ENG_HIERARCHY_MUST_NOT_CHANGE'
959: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 980: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

976: AND NOT Val_Org_Hierarchy( p_org_hierarchy => p_ECO_rec.organization_hierarchy
977: , p_org_id => p_Unexp_ECO_rec.organization_id )
978: THEN
979:
980: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
981: THEN
982: Error_Handler.Add_Error_Token
983: ( p_Message_Name => 'ENG_ORG_HIERARCHY_INVALID'
984: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 1009: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1005: Error_Handler.Write_Debug('Old Change Mgmt Type: ' || p_old_Unexp_ECO_rec.Change_Mgmt_Type_Code);
1006: Error_Handler.Write_Debug('New Change Mgmt Type: ' || p_Unexp_ECO_rec.Change_Mgmt_Type_Code);
1007: END IF;
1008:
1009: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1010: THEN
1011: Error_Handler.Add_Error_Token
1012: ( p_Message_Name => 'ENG_CHANGE_MGMT_MUST_NOT_UPD'
1013: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 1137: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1133: WHEN OTHERS THEN
1134:
1135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1136:
1137: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1138: THEN
1139: l_err_text := G_PKG_NAME || ' : (Entity Validation) ' || substrb(SQLERRM,1,200);
1140: Error_Handler.Add_Error_Token
1141: ( p_Message_Text => l_err_text

Line 1243: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1239: -- Validate ECO attributes
1240:
1241: IF p_Unexp_ECO_rec.Approval_Status_Type = FND_API.G_MISS_NUM
1242: THEN
1243: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1244: THEN
1245: Error_Handler.Add_Error_Token
1246: ( p_Message_Name => 'ENG_APPROVAL_STAT_TYPE_NULL'
1247: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 1273: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1269: THEN
1270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1271: END IF;
1272:
1273: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1274: THEN
1275: l_token_tbl(2).token_name := 'APPROVAL_STATUS_TYPE';
1276: l_token_tbl(2).token_value := p_Unexp_ECO_Rec.Approval_Status_Type;
1277: Error_Handler.Add_Error_Token

Line 1306: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1302: THEN
1303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1304: END IF;
1305:
1306: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1307: THEN
1308: l_token_tbl(2).token_name := 'ECO_DEPARTMENT';
1309: l_token_tbl(2).token_value := p_ECO_Rec.ECO_Department_Name;
1310: Error_Handler.Add_Error_Token

Line 1324: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1320: END IF;
1321:
1322: IF p_Unexp_ECO_Rec.Status_Type = FND_API.G_MISS_NUM
1323: THEN
1324: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1325: THEN
1326: Error_Handler.Add_Error_Token
1327: ( p_Message_Name => 'ENG_ECO_STAT_TYPE_MISSING'
1328: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 1353: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1349: THEN
1350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1351: END IF;
1352:
1353: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1354: THEN
1355: l_token_tbl(2).token_name := 'STATUS_TYPE';
1356: l_token_tbl(2).token_value := p_Unexp_ECO_Rec.Status_Type;
1357: Error_Handler.Add_Error_Token

Line 1390: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1386: THEN
1387: l_token_tbl(1).token_name := 'STATUS_TYPE';
1388: l_token_tbl(1).token_value := p_Unexp_ECO_Rec.Status_Type;
1389:
1390: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1391: THEN
1392: Error_Handler.Add_Error_Token
1393: ( p_Message_Name => 'ENG_ECO_CREATE_STAT_INVALID'
1394: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 1415: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1411: THEN
1412: l_token_tbl(1).token_name := 'STATUS_TYPE';
1413: l_token_tbl(1).token_value := p_Unexp_ECO_Rec.Status_Type;
1414:
1415: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1416: THEN
1417: Error_Handler.Add_Error_Token
1418: ( p_Message_Name => 'ENG_ECO_CREATE_STAT_INVALID'
1419: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 1558: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1554: -- check for implemented revised items
1555: if (l_rev_item_cnt > 0 or l_er_cico_count >0)then
1556: l_token_tbl(1).token_name := 'STATUS_NAME';
1557: l_token_tbl(1).token_value := p_Unexp_ECO_Rec.Status_Type;
1558: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1559: THEN
1560: Error_Handler.Add_Error_Token
1561: ( p_Message_Name => 'ENG_ECO_CREATE_STAT_INVALID'
1562: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 1579: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1575: -- Cannot implement ECOs through open interface
1576:
1577: IF p_Unexp_ECO_rec.status_type = 6
1578: THEN
1579: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1580: THEN
1581: Error_Handler.Add_Error_Token
1582: ( p_Message_Name => 'ENG_ECO_STAT_CANNOT_BE_IMPL'
1583: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 1610: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1606: THEN
1607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1608: END IF;
1609:
1610: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1611: THEN
1612: l_token_tbl(2).token_name := 'PRIORITY_CODE';
1613: l_token_tbl(2).token_value := p_ECO_Rec.Priority_Code;
1614: Error_Handler.Add_Error_Token

Line 1627: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1623: END IF;
1624:
1625: IF NVL(l_disable_date, SYSDATE + 1) <= SYSDATE
1626: THEN
1627: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1628: THEN
1629: l_token_tbl(2).token_name := 'PRIORITY_CODE';
1630: l_token_tbl(2).token_value := p_ECO_Rec.Priority_Code;
1631: Error_Handler.Add_Error_Token

Line 1651: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1647: l_valid_priority := 1;
1648: end if;
1649: end loop;
1650: if l_valid_priority = 0 then
1651: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1652: THEN
1653: l_token_tbl(2).token_name := 'PRIORITY_CODE';
1654: l_token_tbl(2).token_value := p_ECO_Rec.Priority_Code;
1655: Error_Handler.Add_Error_Token

Line 1675: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1671: ELSIF (p_ECO_rec.priority_code IS NULL
1672: AND p_ECO_rec.Assignee IS NOT NULL) THEN
1673:
1674:
1675: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1676: THEN
1677: l_token_tbl(2).token_name := 'ECO_NAME';
1678: l_token_tbl(2).token_value := p_ECO_Rec.Eco_Name;
1679: Error_Handler.Add_Error_Token

Line 1708: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1704: THEN
1705: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1706: END IF;
1707:
1708: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1709: THEN
1710: l_token_tbl(2).token_name := 'REASON_CODE';
1711: l_token_tbl(2).token_value := p_ECO_Rec.Reason_Code;
1712: Error_Handler.Add_Error_Token

Line 1724: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1720: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1721: END IF;
1722: IF NVL(l_disable_date, SYSDATE + 1) <= SYSDATE
1723: THEN
1724: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1725: THEN
1726: l_token_tbl(2).token_name := 'REASON_CODE';
1727: l_token_tbl(2).token_value := p_ECO_Rec.Reason_Code;
1728: Error_Handler.Add_Error_Token

Line 1750: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1746: end if;
1747: end loop;
1748: if l_valid_reason = 0 then
1749:
1750: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1751: THEN
1752: l_token_tbl(2).token_name := 'REASON_CODE';
1753: l_token_tbl(2).token_value := p_ECO_Rec.Reason_Code;
1754: Error_Handler.Add_Error_Token

Line 1787: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1783: IF p_ECO_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE
1784: THEN
1785: IF p_ECO_rec.hierarchy_flag = FND_API.G_MISS_NUM
1786: THEN
1787: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1788: THEN
1789: Error_Handler.Add_Error_Token
1790: ( p_Message_Name => 'ENG_HIERARCHY_FLAG_MISSING'
1791: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 1805: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1801:
1802: IF NVL(p_ECO_rec.hierarchy_flag,2 ) NOT IN (1, 2 )
1803: AND p_ECO_rec.hierarchy_flag <> FND_API.G_MISS_NUM
1804: THEN
1805: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1806: THEN
1807: Error_Handler.Add_Error_Token
1808: ( p_Message_Name => 'ENG_HIERARCHY_FLAG_INVALID'
1809: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 1825: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1821: -- Eng Change
1822: IF NVL(p_ECO_rec.internal_use_only,1 ) NOT IN (1, 2 )
1823: AND p_ECO_rec.internal_use_only <> FND_API.G_MISS_NUM
1824: THEN
1825: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1826: THEN
1827: Error_Handler.Add_Error_Token
1828: ( p_Message_Name => 'ENG_INTL_USE_ONLY_FLAG_INVALID'
1829: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 1842: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1838: IF p_ECO_rec.need_by_date < SYSDATE
1839: AND p_ECO_rec.need_by_date <> FND_API.G_MISS_DATE
1840: AND p_ECO_rec.need_by_date IS NOT NULL
1841: THEN
1842: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1843: THEN
1844: Error_Handler.Add_Error_Token
1845: ( p_Message_Name => 'ENG_NEED_BY_DATE_LESS_CURR'
1846: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 1859: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1855: IF p_ECO_rec.effort < 0
1856: AND p_ECO_rec.effort <> FND_API.G_MISS_NUM
1857: AND p_ECO_rec.effort IS NOT NULL
1858: THEN
1859: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1860: THEN
1861: Error_Handler.Add_Error_Token
1862: ( p_Message_Name => 'ENG_EFFORT_LESS_ZERO'
1863: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2025: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2021:
2022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2023: x_err_text := l_err_text;
2024:
2025: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2026: THEN
2027: Error_Handler.Add_Error_Token
2028: ( p_Message_Text => l_err_text
2029: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2072: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2068: IF (FND_PROFILE.DEFINED('ENG:MANDATORY_ECO_DEPT') AND
2069: FND_PROFILE.VALUE('ENG:MANDATORY_ECO_DEPT') = '1')
2070: AND p_Unexp_ECO_rec.responsible_org_id IS NULL
2071: THEN
2072: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2073: THEN
2074: Error_Handler.Add_Error_Token
2075: ( p_Message_Name => 'ENG_RESP_ORG_MISSING'
2076: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2094: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2090: NVL(p_ECO_rec.organization_hierarchy, FND_API.G_MISS_CHAR)
2091: = FND_API.G_MISS_CHAR
2092: THEN
2093:
2094: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2095: THEN
2096: Error_Handler.Add_Error_Token
2097: ( p_Message_Name => 'ENG_ORG_HIERARCHY_MISSING'
2098: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2114: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2110: WHEN OTHERS THEN
2111:
2112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2113:
2114: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2115: THEN
2116: l_err_text := G_PKG_NAME || ' : (Conditionally Required Fields Check) ' || substrb(SQLERRM,1,200);
2117: Error_Handler.Add_Error_Token
2118: ( p_Message_Text => l_err_text