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_API

Line 246: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

242: )
243: IS
244: l_Token_Tbl Error_Handler.Token_Tbl_Type;
245: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
246: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
247:
248: l_ri_exists NUMBER := 0;
249: CURSOR GetRevisedItems IS
250: SELECT 'x'

Line 277: l_return_status := FND_API.G_RET_STS_ERROR;

273: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
274: , p_Token_Tbl => l_Token_Tbl
275: );
276: END IF;
277: l_return_status := FND_API.G_RET_STS_ERROR;
278: END IF;
279:
280: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
281: x_return_status := l_return_status;

Line 437: RETURN FND_API.G_MISS_NUM;

433: WHEN NO_DATA_FOUND THEN
434: RETURN NULL;
435:
436: WHEN OTHERS THEN
437: RETURN FND_API.G_MISS_NUM;
438:
439: END Get_Change_Id;
440:
441:

Line 471: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

467: IS
468: l_err_text VARCHAR2(2000) := NULL;
469: l_Token_Tbl Error_Handler.Token_Tbl_Type;
470: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
471: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
472: l_dummy VARCHAR2(10) := NULL;
473: l_process_name VARCHAR2(30) := NULL;
474: l_rev_items_scheduled BOOLEAN := FALSE;
475: l_change_order_type_same NUMBER := 0;

Line 584: l_return_status := FND_API.G_RET_STS_ERROR;

580: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
581: , p_Token_Tbl => l_Token_Tbl
582: );
583: END IF;
584: l_return_status := FND_API.G_RET_STS_ERROR;
585: END IF;
586:
587: --Bug 2921474
588: IF p_ECO_rec.Transaction_Type = ENG_Globals.G_OPR_DELETE AND

Line 600: l_return_status := FND_API.G_RET_STS_ERROR;

596: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
597: , p_Token_Tbl => l_Token_Tbl
598: );
599: END IF;
600: l_return_status := FND_API.G_RET_STS_ERROR;
601: END IF;
602:
603:
604: IF p_ECO_rec.Transaction_Type = ENG_Globals.G_OPR_DELETE AND

Line 616: l_return_status := FND_API.G_RET_STS_ERROR;

612: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
613: , p_Token_Tbl => l_Token_Tbl
614: );
615: END IF;
616: l_return_status := FND_API.G_RET_STS_ERROR;
617: END IF;
618:
619:
620: --End of Bug 2921474

Line 640: l_return_status := FND_API.G_RET_STS_ERROR;

636: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
637: , p_Token_Tbl => l_Token_Tbl
638: );
639: END IF;
640: l_return_status := FND_API.G_RET_STS_ERROR;
641: END IF;
642:
643:
644: -- Added by MK on 09/01/2000

Line 668: l_return_status := FND_API.G_RET_STS_ERROR;

664: , p_Token_Tbl => l_Token_Tbl
665: );
666: END IF;
667: ---Bug 2921534
668: l_return_status := FND_API.G_RET_STS_ERROR;
669: END IF ;
670:
671:
672: END IF;

Line 697: l_return_status := FND_API.G_RET_STS_ERROR;

693: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
694: , p_Token_Tbl => l_Token_Tbl
695: );
696: END IF;
697: l_return_status := FND_API.G_RET_STS_ERROR;
698: END IF;
699: */
700: -- ERES end
701:

Line 722: l_return_status := FND_API.G_RET_STS_ERROR;

718: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
719: , p_Token_Tbl => l_Token_Tbl
720: );
721: END IF;
722: l_return_status := FND_API.G_RET_STS_ERROR;
723: END IF;
724: END IF;
725: -- Are there any revised items that are scheduled ?
726:

Line 748: l_return_status := FND_API.G_RET_STS_ERROR;

744: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
745: , p_Token_Tbl => l_Token_Tbl
746: );
747: END IF;
748: l_return_status := FND_API.G_RET_STS_ERROR;
749: END IF;
750:
751: --117
752: -- Approval list exists

Line 773: l_return_status := FND_API.G_RET_STS_ERROR;

769: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
770: , p_Token_Tbl => l_Token_Tbl
771: );
772: END IF;
773: l_return_status := FND_API.G_RET_STS_ERROR;
774: END IF;
775:
776: -- Approval list must not be changed if Approval Requested
777:

Line 791: l_return_status := FND_API.G_RET_STS_ERROR;

787: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
788: , p_Token_Tbl => l_Token_Tbl
789: );
790: END IF;
791: l_return_status := FND_API.G_RET_STS_ERROR;
792: END IF;
793:
794: -- Status Type must not be changed if Approval Requested
795: -- FROM ENGFMECO.pld (Procedure Initialize_Row)

Line 810: l_return_status := FND_API.G_RET_STS_ERROR;

806: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
807: , p_Token_Tbl => l_Token_Tbl
808: );
809: END IF;
810: l_return_status := FND_API.G_RET_STS_ERROR;
811: END IF;
812:
813:
814:

Line 844: l_return_status := FND_API.G_RET_STS_ERROR;

840: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
841: , p_Token_Tbl => l_Token_Tbl
842: );
843: END IF;
844: l_return_status := FND_API.G_RET_STS_ERROR;
845: END IF;
846:
847: -- Cannot update status to 'Scheduled'
848:

Line 861: l_return_status := FND_API.G_RET_STS_ERROR;

857: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
858: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
859: );
860: END IF;
861: l_return_status := FND_API.G_RET_STS_ERROR;
862: END IF;
863:
864: -- Cannot update priority if the ECO or any of its revised items have been scheduled
865:

Line 886: l_return_status := FND_API.G_RET_STS_ERROR;

882: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
883: , p_Token_Tbl => l_Token_Tbl
884: );
885: END IF;
886: l_return_status := FND_API.G_RET_STS_ERROR;
887: END IF;
888:
889: END IF;
890:

Line 905: l_return_status := FND_API.G_RET_STS_ERROR;

901: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
902: , p_Token_Tbl => l_Token_Tbl
903: );
904: END IF;
905: l_return_status := FND_API.G_RET_STS_ERROR;
906: END IF;
907:
908: IF p_ECO_rec.Transaction_Type = ENG_Globals.G_OPR_UPDATE
909: AND

Line 934: l_return_status := FND_API.G_RET_STS_ERROR;

930: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
931: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
932: , p_Token_Tbl => l_Token_Tbl);
933: END IF;
934: l_return_status := FND_API.G_RET_STS_ERROR;
935: ELSIF l_change_order_type_same = -1
936: THEN
937: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
938: END IF;

Line 937: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

933: END IF;
934: l_return_status := FND_API.G_RET_STS_ERROR;
935: ELSIF l_change_order_type_same = -1
936: THEN
937: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
938: END IF;
939:
940:
941: END IF;

Line 951: NVL(p_ECO_rec.organization_hierarchy, FND_API.G_MISS_CHAR) <>

947: */
948: IF p_ECO_rec.Transaction_Type = ENG_Globals.G_OPR_UPDATE
949: -- AND p_ECO_rec.approval_status_type = 5
950: AND ( --NVL(p_ECO_rec.hierarchy_flag, 2) <> NVL(p_old_ECO_rec.hierarchy_flag,2) OR
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)

Line 952: NVL(p_old_ECO_rec.organization_hierarchy, FND_API.G_MISS_CHAR)

948: IF p_ECO_rec.Transaction_Type = ENG_Globals.G_OPR_UPDATE
949: -- AND p_ECO_rec.approval_status_type = 5
950: AND ( --NVL(p_ECO_rec.hierarchy_flag, 2) <> NVL(p_old_ECO_rec.hierarchy_flag,2) OR
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

Line 965: l_return_status := FND_API.G_RET_STS_ERROR;

961: , p_Token_Tbl => l_Token_Tbl
962: );
963: END IF;
964:
965: l_return_status := FND_API.G_RET_STS_ERROR;
966:
967: END IF ;
968:
969: IF p_ECO_rec.organization_hierarchy IS NOT NULL

Line 972: AND NVL(p_ECO_rec.organization_hierarchy, FND_API.G_MISS_CHAR) <>

968:
969: IF p_ECO_rec.organization_hierarchy IS NOT NULL
970: AND ( p_ECO_rec.Transaction_Type = ENG_Globals.G_OPR_CREATE
971: OR (p_ECO_rec.Transaction_Type = ENG_Globals.G_OPR_UPDATE
972: AND NVL(p_ECO_rec.organization_hierarchy, FND_API.G_MISS_CHAR) <>
973: NVL(p_old_ECO_rec.organization_hierarchy, FND_API.G_MISS_CHAR)
974: )
975: )
976: AND NOT Val_Org_Hierarchy( p_org_hierarchy => p_ECO_rec.organization_hierarchy

Line 973: NVL(p_old_ECO_rec.organization_hierarchy, FND_API.G_MISS_CHAR)

969: IF p_ECO_rec.organization_hierarchy IS NOT NULL
970: AND ( p_ECO_rec.Transaction_Type = ENG_Globals.G_OPR_CREATE
971: OR (p_ECO_rec.Transaction_Type = ENG_Globals.G_OPR_UPDATE
972: AND NVL(p_ECO_rec.organization_hierarchy, FND_API.G_MISS_CHAR) <>
973: NVL(p_old_ECO_rec.organization_hierarchy, FND_API.G_MISS_CHAR)
974: )
975: )
976: AND NOT Val_Org_Hierarchy( p_org_hierarchy => p_ECO_rec.organization_hierarchy
977: , p_org_id => p_Unexp_ECO_rec.organization_id )

Line 990: l_return_status := FND_API.G_RET_STS_ERROR;

986: , p_Token_Tbl => l_Token_Tbl
987: );
988: END IF;
989:
990: l_return_status := FND_API.G_RET_STS_ERROR;
991:
992: END IF ;
993:
994: -- Eng Change New Validations for Change Mgmt Type and Assignee

Line 998: AND NVL(p_Unexp_ECO_rec.Change_Mgmt_Type_Code, FND_API.G_MISS_CHAR) <>

994: -- Eng Change New Validations for Change Mgmt Type and Assignee
995:
996: -- Change Mgmt Type can not be changed thr BO
997: IF (p_ECO_rec.Transaction_Type = ENG_Globals.G_OPR_UPDATE
998: AND NVL(p_Unexp_ECO_rec.Change_Mgmt_Type_Code, FND_API.G_MISS_CHAR) <>
999: NVL(p_old_Unexp_ECO_rec.Change_Mgmt_Type_Code, FND_API.G_MISS_CHAR)
1000: )
1001: THEN
1002:

Line 999: NVL(p_old_Unexp_ECO_rec.Change_Mgmt_Type_Code, FND_API.G_MISS_CHAR)

995:
996: -- Change Mgmt Type can not be changed thr BO
997: IF (p_ECO_rec.Transaction_Type = ENG_Globals.G_OPR_UPDATE
998: AND NVL(p_Unexp_ECO_rec.Change_Mgmt_Type_Code, FND_API.G_MISS_CHAR) <>
999: NVL(p_old_Unexp_ECO_rec.Change_Mgmt_Type_Code, FND_API.G_MISS_CHAR)
1000: )
1001: THEN
1002:
1003: IF Bom_Globals.Get_Debug = 'Y' THEN

Line 1019: l_return_status := FND_API.G_RET_STS_ERROR;

1015: , p_Token_Tbl => l_Token_Tbl
1016: );
1017: END IF;
1018:
1019: l_return_status := FND_API.G_RET_STS_ERROR;
1020:
1021: END IF ;
1022:
1023: /* commented as assignee_role_id ,requestor_role_id don't exist in ENG_CHANGE_ORDER_TYPES table

Line 1036: l_return_status := FND_API.G_RET_STS_ERROR;

1032: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1033: , p_Token_Tbl => l_Token_Tbl
1034: );
1035:
1036: l_return_status := FND_API.G_RET_STS_ERROR;
1037: END IF;
1038:
1039:
1040: SELECT requestor_role_id, assignee_role_id

Line 1071: IF l_return_status = FND_API.G_TRUE

1067: ,x_errorcode => l_errorcode
1068: ,x_grant_guid => l_grant_guid
1069: );
1070:
1071: IF l_return_status = FND_API.G_TRUE
1072: OR l_return_status = FND_API.G_FALSE
1073: THEN
1074: l_return_status := FND_API.G_RET_STS_SUCCESS;
1075: ELSE

Line 1072: OR l_return_status = FND_API.G_FALSE

1068: ,x_grant_guid => l_grant_guid
1069: );
1070:
1071: IF l_return_status = FND_API.G_TRUE
1072: OR l_return_status = FND_API.G_FALSE
1073: THEN
1074: l_return_status := FND_API.G_RET_STS_SUCCESS;
1075: ELSE
1076: Error_Handler.Add_Error_Token

Line 1074: l_return_status := FND_API.G_RET_STS_SUCCESS;

1070:
1071: IF l_return_status = FND_API.G_TRUE
1072: OR l_return_status = FND_API.G_FALSE
1073: THEN
1074: l_return_status := FND_API.G_RET_STS_SUCCESS;
1075: ELSE
1076: Error_Handler.Add_Error_Token
1077: ( p_Message_Name => 'ENG_CHANGE_REQUESTOR_GRANT'
1078: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 1111: IF l_return_status = FND_API.G_TRUE

1107: ,x_errorcode => l_errorcode
1108: ,x_grant_guid => l_grant_guid
1109: );
1110:
1111: IF l_return_status = FND_API.G_TRUE
1112: OR l_return_status = FND_API.G_FALSE
1113: THEN
1114: l_return_status := FND_API.G_RET_STS_SUCCESS;
1115: ELSE

Line 1112: OR l_return_status = FND_API.G_FALSE

1108: ,x_grant_guid => l_grant_guid
1109: );
1110:
1111: IF l_return_status = FND_API.G_TRUE
1112: OR l_return_status = FND_API.G_FALSE
1113: THEN
1114: l_return_status := FND_API.G_RET_STS_SUCCESS;
1115: ELSE
1116: Error_Handler.Add_Error_Token

Line 1114: l_return_status := FND_API.G_RET_STS_SUCCESS;

1110:
1111: IF l_return_status = FND_API.G_TRUE
1112: OR l_return_status = FND_API.G_FALSE
1113: THEN
1114: l_return_status := FND_API.G_RET_STS_SUCCESS;
1115: ELSE
1116: Error_Handler.Add_Error_Token
1117: ( p_Message_Name => 'ENG_CHANGE_ASSIGNEE_GRANT'
1118: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 1135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1131: EXCEPTION
1132:
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);

Line 1237: x_return_status := FND_API.G_RET_STS_SUCCESS;

1233:
1234: l_token_tbl(1).token_name := 'ECO_NAME';
1235: l_token_tbl(1).token_value := p_ECO_rec.ECO_Name;
1236:
1237: x_return_status := FND_API.G_RET_STS_SUCCESS;
1238:
1239: -- Validate ECO attributes
1240:
1241: IF p_Unexp_ECO_rec.Approval_Status_Type = FND_API.G_MISS_NUM

Line 1241: IF p_Unexp_ECO_rec.Approval_Status_Type = FND_API.G_MISS_NUM

1237: x_return_status := FND_API.G_RET_STS_SUCCESS;
1238:
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

Line 1252: x_return_status := FND_API.G_RET_STS_ERROR;

1248: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1249: , p_Token_Tbl => l_Token_Tbl
1250: );
1251: END IF;
1252: x_return_status := FND_API.G_RET_STS_ERROR;
1253: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1254: END IF;
1255:
1256: IF p_Unexp_ECO_rec.approval_status_type IS NOT NULL AND

Line 1270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1266: p_Unexp_ECO_rec.approval_status_type = 6
1267: THEN
1268: IF l_err_text = ''
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

Line 1284: x_return_status := FND_API.G_RET_STS_ERROR;

1280: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1281: , p_Token_Tbl => l_Token_Tbl
1282: );
1283: END IF;
1284: x_return_status := FND_API.G_RET_STS_ERROR;
1285: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1286: END IF;
1287: END IF;
1288:

Line 1303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1299: )
1300: THEN
1301: IF l_err_text = ''
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

Line 1317: x_return_status := FND_API.G_RET_STS_ERROR;

1313: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1314: , p_Token_Tbl => l_Token_Tbl
1315: );
1316: END IF;
1317: x_return_status := FND_API.G_RET_STS_ERROR;
1318: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1319: END IF;
1320: END IF;
1321:

Line 1322: IF p_Unexp_ECO_Rec.Status_Type = FND_API.G_MISS_NUM

1318: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1319: END IF;
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

Line 1333: x_return_status := FND_API.G_RET_STS_ERROR;

1329: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1330: , p_Token_Tbl => l_Token_Tbl
1331: );
1332: END IF;
1333: x_return_status := FND_API.G_RET_STS_ERROR;
1334: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1335: END IF;
1336:
1337: IF p_Unexp_ECO_rec.status_type IS NOT NULL AND

Line 1350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1346: )
1347: THEN
1348: IF l_err_text = ''
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

Line 1364: x_return_status := FND_API.G_RET_STS_ERROR;

1360: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1361: , p_Token_Tbl => l_Token_Tbl
1362: );
1363: END IF;
1364: x_return_status := FND_API.G_RET_STS_ERROR;
1365: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1366: END IF;
1367:
1368: -- Cannot create ECOs that are not OPEN through open interface

Line 1397: x_return_status := FND_API.G_RET_STS_ERROR;

1393: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1394: , p_Token_Tbl => l_Token_Tbl
1395: );
1396: END IF;
1397: x_return_status := FND_API.G_RET_STS_ERROR;
1398: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1399: END IF;
1400:
1401: --Bug 2908248

Line 1421: x_return_status := FND_API.G_RET_STS_ERROR;

1417: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1418: , p_Token_Tbl => l_Token_Tbl
1419: );
1420: END IF;
1421: x_return_status := FND_API.G_RET_STS_ERROR;
1422: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1423: END IF;
1424:
1425: --Bug 2908248

Line 1564: x_return_status := FND_API.G_RET_STS_ERROR;

1560: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1561: , p_Token_Tbl => l_Token_Tbl
1562: );
1563: END IF;
1564: x_return_status := FND_API.G_RET_STS_ERROR;
1565: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1566: end if;
1567:
1568: END IF; --p_Unexp_ECO_rec.status_type = 11

Line 1584: x_return_status := FND_API.G_RET_STS_ERROR;

1580: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1581: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1582: );
1583: END IF;
1584: x_return_status := FND_API.G_RET_STS_ERROR;
1585: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1586: END IF;
1587:
1588: END IF;

Line 1604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1600: )
1601: THEN
1602: IF l_err_text = ''
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

Line 1618: x_return_status := FND_API.G_RET_STS_ERROR;

1614: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1615: , p_Token_Tbl => l_Token_Tbl
1616: );
1617: END IF;
1618: x_return_status := FND_API.G_RET_STS_ERROR;
1619: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1620: END IF;
1621:
1622: IF NVL(l_disable_date, SYSDATE + 1) <= SYSDATE

Line 1635: x_return_status := FND_API.G_RET_STS_ERROR;

1631: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1632: , p_Token_Tbl => l_Token_Tbl
1633: );
1634: END IF;
1635: x_return_status := FND_API.G_RET_STS_ERROR;
1636: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1637: END IF;
1638: IF p_ECO_rec.plm_or_erp_change ='PLM' then
1639:

Line 1659: x_return_status := FND_API.G_RET_STS_ERROR;

1655: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1656: , p_Token_Tbl => l_Token_Tbl
1657: );
1658: END IF;
1659: x_return_status := FND_API.G_RET_STS_ERROR;
1660: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1661:
1662: end if;
1663: END IF;

Line 1683: x_return_status := FND_API.G_RET_STS_ERROR;

1679: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1680: , p_Token_Tbl => l_Token_Tbl
1681: );
1682: END IF;
1683: x_return_status := FND_API.G_RET_STS_ERROR;
1684: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1685: */
1686: END IF;
1687:

Line 1702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1698: )
1699: THEN
1700: IF l_err_text = ''
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

Line 1716: x_return_status := FND_API.G_RET_STS_ERROR;

1712: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1713: , p_Token_Tbl => l_Token_Tbl
1714: );
1715: END IF;
1716: x_return_status := FND_API.G_RET_STS_ERROR;
1717: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1718: END IF;
1719: IF NVL(l_disable_date, SYSDATE + 1) <= SYSDATE
1720: THEN

Line 1732: x_return_status := FND_API.G_RET_STS_ERROR;

1728: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1729: , p_Token_Tbl => l_Token_Tbl
1730: );
1731: END IF;
1732: x_return_status := FND_API.G_RET_STS_ERROR;
1733: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1734: END IF;
1735: --11.5.10
1736: IF p_ECO_rec.plm_or_erp_change ='PLM' then

Line 1758: x_return_status := FND_API.G_RET_STS_ERROR;

1754: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1755: , p_Token_Tbl => l_Token_Tbl
1756: );
1757: END IF;
1758: x_return_status := FND_API.G_RET_STS_ERROR;
1759: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1760:
1761: end if;
1762: --11.5.10

Line 1778: -- when hierarchy_flag = FND_API.G_MISS_NUM

1774: /* User may not set null in Update,
1775: -- because hierarchy_flag does not exist interface table,
1776: -- Hence following logic is commented out.
1777: -- Set 2:No to hierarchy_flag in Entity Defaulting
1778: -- when hierarchy_flag = FND_API.G_MISS_NUM
1779: --
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

Line 1782: IF p_ECO_rec.hierarchy_flag = FND_API.G_MISS_NUM

1778: -- when hierarchy_flag = FND_API.G_MISS_NUM
1779: --
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

Line 1793: x_return_status := FND_API.G_RET_STS_ERROR;

1789: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1790: , p_Token_Tbl => l_Token_Tbl
1791: );
1792: END IF;
1793: x_return_status := FND_API.G_RET_STS_ERROR;
1794: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1795:
1796: END IF ;
1797: END IF ;

Line 1800: AND p_ECO_rec.hierarchy_flag <> FND_API.G_MISS_NUM

1796: END IF ;
1797: END IF ;
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

Line 1811: x_return_status := FND_API.G_RET_STS_ERROR;

1807: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1808: , p_Token_Tbl => l_Token_Tbl
1809: );
1810: END IF;
1811: x_return_status := FND_API.G_RET_STS_ERROR;
1812: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1813: END IF;
1814: */
1815:

Line 1820: AND p_ECO_rec.internal_use_only <> FND_API.G_MISS_NUM

1816:
1817:
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

Line 1831: x_return_status := FND_API.G_RET_STS_ERROR;

1827: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1828: , p_Token_Tbl => l_Token_Tbl
1829: );
1830: END IF;
1831: x_return_status := FND_API.G_RET_STS_ERROR;
1832: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1833: END IF;
1834:
1835: IF p_ECO_rec.need_by_date < SYSDATE

Line 1836: AND p_ECO_rec.need_by_date <> FND_API.G_MISS_DATE

1832: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1833: END IF;
1834:
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

Line 1848: x_return_status := FND_API.G_RET_STS_ERROR;

1844: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1845: , p_Token_Tbl => l_Token_Tbl
1846: );
1847: END IF;
1848: x_return_status := FND_API.G_RET_STS_ERROR;
1849: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1850: END IF;
1851:
1852: IF p_ECO_rec.effort < 0

Line 1853: AND p_ECO_rec.effort <> FND_API.G_MISS_NUM

1849: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1850: END IF;
1851:
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

Line 1865: x_return_status := FND_API.G_RET_STS_ERROR;

1861: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1862: , p_Token_Tbl => l_Token_Tbl
1863: );
1864: END IF;
1865: x_return_status := FND_API.G_RET_STS_ERROR;
1866: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1867: END IF;
1868:
1869:

Line 2007: x_return_status := FND_API.G_RET_STS_ERROR;

2003:
2004: -- Validate descriptive flexfield.
2005:
2006: IF NOT ENG_Validate.Desc_Flex( 'ECO' ) THEN
2007: x_return_status := FND_API.G_RET_STS_ERROR;
2008: END IF;
2009:
2010: END IF;
2011: */

Line 2017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2013: -- Done validating attributes
2014:
2015: EXCEPTION
2016:
2017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2018:
2019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2020: x_err_text := l_err_text;
2021:

Line 2019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2015: EXCEPTION
2016:
2017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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

Line 2043: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

2039: , p_old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
2040: , p_old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
2041: )
2042: IS
2043: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2044: l_err_text VARCHAR2(2000) := NULL;
2045: l_Token_Tbl Error_Handler.Token_Tbl_Type;
2046: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2047: BEGIN

Line 2049: x_return_status := FND_API.G_RET_STS_SUCCESS;

2045: l_Token_Tbl Error_Handler.Token_Tbl_Type;
2046: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2047: BEGIN
2048:
2049: x_return_status := FND_API.G_RET_STS_SUCCESS;
2050:
2051: l_token_tbl(1).token_name := 'ECO_NAME';
2052: l_token_tbl(1).token_value := p_ECO_Rec.ECO_Name;
2053:

Line 2078: x_return_status := FND_API.G_RET_STS_ERROR;

2074: , x_Mesg_Token_Tbl => x_Mesg_Token_Tbl
2075: , p_Token_Tbl => l_Token_Tbl
2076: );
2077: END IF;
2078: x_return_status := FND_API.G_RET_STS_ERROR;
2079: END IF;
2080:
2081: END IF ;
2082:

Line 2087: NVL(p_ECO_rec.organization_hierarchy, FND_API.G_MISS_CHAR)

2083: /* Added by MK on 11/29/00 Bug #1508078
2084: -- Conditionally required validation for hierarchy_flag and organization_hierarchy
2085: --
2086: IF p_ECO_rec.hierarchy_flag = 1 AND
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)

Line 2088: = FND_API.G_MISS_CHAR

2084: -- Conditionally required validation for hierarchy_flag and organization_hierarchy
2085: --
2086: IF p_ECO_rec.hierarchy_flag = 1 AND
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

Line 2100: x_return_status := FND_API.G_RET_STS_ERROR;

2096: , x_Mesg_Token_Tbl => x_Mesg_Token_Tbl
2097: , p_Token_Tbl => l_Token_Tbl
2098: );
2099: END IF;
2100: x_return_status := FND_API.G_RET_STS_ERROR;
2101: END IF;
2102: */
2103:
2104:

Line 2109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2105: EXCEPTION
2106:
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);

Line 2152: l_return_status := FND_API.G_RET_STS_SUCCESS;

2148: l_return_status VARCHAR2(1);
2149: l_err_text VARCHAR2(2000);
2150: l_Token_Tbl Error_Handler.Token_Tbl_Type;
2151: BEGIN
2152: l_return_status := FND_API.G_RET_STS_SUCCESS;
2153:
2154: l_token_tbl(1).token_name := 'ECO_NAME';
2155: l_token_tbl(1).token_value := p_change_notice;
2156: l_token_tbl(2).token_name := 'ORGANIZATION_CODE';

Line 2172: l_return_status := FND_API.G_RET_STS_ERROR;

2168: IF l_return_status = Eng_Globals.G_RECORD_FOUND AND
2169: p_calling_entity = 'ECO' AND
2170: p_transaction_type = Eng_Globals.G_OPR_CREATE
2171: THEN
2172: l_return_status := FND_API.G_RET_STS_ERROR;
2173: Error_Handler.Add_Error_Token
2174: ( p_Message_Name => 'ENG_ECO_ALREADY_EXISTS'
2175: , p_Mesg_Token_Tbl => l_mesg_token_tbl
2176: , x_Mesg_Token_Tbl => l_mesg_token_tbl

Line 2184: l_return_status := FND_API.G_RET_STS_ERROR;

2180: ELSIF l_return_status = Eng_Globals.G_RECORD_FOUND AND
2181: p_transaction_type = Eng_Globals.G_OPR_UPDATE AND
2182: x_eco_unexp_rec.approval_status_type in (3, 5) -- approved or approval requested
2183: THEN
2184: l_return_status := FND_API.G_RET_STS_ERROR;
2185: Error_Handler.Add_Error_Token
2186: ( p_Message_Name => 'ENG_ECO_CANNOT_UPDATE'
2187: , p_Mesg_Token_Tbl => l_mesg_token_tbl
2188: , x_Mesg_Token_Tbl => l_mesg_token_tbl

Line 2197: l_return_status := FND_API.G_RET_STS_ERROR;

2193: p_calling_entity = 'ECO' AND
2194: p_transaction_type IN
2195: ( Eng_Globals.G_OPR_UPDATE, Eng_Globals.G_OPR_DELETE)
2196: THEN
2197: l_return_status := FND_API.G_RET_STS_ERROR;
2198: Error_Handler.Add_Error_Token
2199: ( p_Message_Name => 'ENG_ECO_DOES_NOT_EXIST'
2200: , p_Mesg_Token_Tbl => l_mesg_token_tbl
2201: , x_Mesg_Token_Tbl => l_mesg_token_tbl

Line 2208: l_return_status := FND_API.G_RET_STS_ERROR;

2204:
2205: ELSIF l_return_status = Eng_Globals.G_RECORD_NOT_FOUND AND
2206: p_calling_entity = 'CHILD'
2207: THEN
2208: l_return_status := FND_API.G_RET_STS_ERROR;
2209:
2210: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2211: THEN
2212: Error_Handler.Add_Error_Token

Line 2210: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

2206: p_calling_entity = 'CHILD'
2207: THEN
2208: l_return_status := FND_API.G_RET_STS_ERROR;
2209:
2210: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2211: THEN
2212: Error_Handler.Add_Error_Token
2213: ( p_Message_Name => NULL
2214: , p_Message_Text => l_err_text

Line 2220: l_return_status := FND_API.G_RET_STS_SUCCESS;

2216: , x_Mesg_Token_Tbl => l_mesg_token_tbl
2217: , p_Token_Tbl => l_token_tbl
2218: );
2219: ELSE
2220: l_return_status := FND_API.G_RET_STS_SUCCESS;
2221: END IF;
2222:
2223: x_return_status := l_return_status;
2224: x_mesg_token_tbl := l_mesg_token_tbl;

Line 2355: l_return_status := FND_API.G_RET_STS_SUCCESS;

2351: l_update_allowed BOOLEAN;
2352: l_status_name eng_change_statuses_tl.status_name%TYPE;
2353: BEGIN
2354:
2355: l_return_status := FND_API.G_RET_STS_SUCCESS;
2356: l_change_order_type_id := NULL;
2357:
2358: l_Token_Tbl(1).token_name := 'ECO_NAME';
2359: l_Token_Tbl(1).token_value := p_change_notice;

Line 2507: l_return_status := FND_API.G_RET_STS_ERROR;

2503: END IF;
2504:
2505: IF NVL(Eng_Globals.Is_Eco_Impl, FALSE) = TRUE
2506: THEN
2507: l_return_status := FND_API.G_RET_STS_ERROR;
2508: Error_Handler.Add_Error_Token
2509: ( p_Message_Name => 'ENG_ECO_IMPLEMENTED'
2510: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2511: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2516: l_return_status := FND_API.G_RET_STS_ERROR;

2512: , p_Token_Tbl => l_Token_Tbl
2513: );
2514: ELSIF NVL(Eng_Globals.Is_Eco_Cancl, FALSE) = TRUE
2515: THEN
2516: l_return_status := FND_API.G_RET_STS_ERROR;
2517: Error_Handler.Add_Error_Token
2518: ( p_Message_Name => 'ENG_ECO_CANCELLED'
2519: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2520: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2525: l_return_status := FND_API.G_RET_STS_ERROR;

2521: , p_Token_Tbl => l_Token_Tbl
2522: );
2523: ELSIF NVL(Eng_Globals.Is_WKFL_Process, FALSE) = TRUE
2524: THEN
2525: l_return_status := FND_API.G_RET_STS_ERROR;
2526: Error_Handler.Add_Error_Token
2527: ( p_Message_Name => 'ENG_ECO_WKFL_EXISTS'
2528: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2529: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2534: l_return_status := FND_API.G_RET_STS_ERROR;

2530: , p_Token_Tbl => l_Token_Tbl
2531: );
2532: ELSIF NVL(Eng_Globals.Is_Eco_Access, TRUE) = FALSE
2533: THEN
2534: l_return_status := FND_API.G_RET_STS_ERROR;
2535: l_token_tbl(2).token_name := 'CHANGE_TYPE_CODE';
2536: l_token_tbl(2).token_value := p_change_type_code;
2537: Error_Handler.Add_Error_Token
2538: ( p_Message_Name => 'ENG_ECO_ACCESS_DENIED'

Line 2547: l_return_status := FND_API.G_RET_STS_ERROR;

2543: END IF;
2544: --Check if Workflow is in progress
2545: IF l_WorkflowInprogressExists = TRUE
2546: THEN
2547: l_return_status := FND_API.G_RET_STS_ERROR;
2548: Error_Handler.Add_Error_Token
2549: ( p_Message_Name => 'ENG_ECO_WKFL_INPROGRESS'
2550: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2551: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2559: l_return_status := FND_API.G_RET_STS_ERROR;

2555: ELSIF nvl(l_update_allowed, TRUE) = FALSE
2556: THEN
2557: l_Token_Tbl(2).token_name := 'STATUS_NAME';
2558: l_Token_Tbl(2).token_value := l_status_name;
2559: l_return_status := FND_API.G_RET_STS_ERROR;
2560: Error_Handler.Add_Error_Token
2561: ( p_Message_Name => 'ENG_CHGUPD_NOTALLOWED'
2562: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2563: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl