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 1388: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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