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 1399: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1424: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1567: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1587: x_return_status := FND_API.G_RET_STS_ERROR;

1583: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1584: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1585: );
1586: END IF;
1587: x_return_status := FND_API.G_RET_STS_ERROR;
1588: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1589: END IF;
1590:
1591: END IF;

Line 1607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1603: )
1604: THEN
1605: IF l_err_text = ''
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

Line 1621: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1638: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1662: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1686: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1705: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1701: )
1702: THEN
1703: IF l_err_text = ''
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

Line 1719: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1735: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1761: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1781: -- when hierarchy_flag = FND_API.G_MISS_NUM

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

Line 1785: IF p_ECO_rec.hierarchy_flag = FND_API.G_MISS_NUM

1781: -- when hierarchy_flag = FND_API.G_MISS_NUM
1782: --
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

Line 1796: x_return_status := FND_API.G_RET_STS_ERROR;

1792: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1793: , p_Token_Tbl => l_Token_Tbl
1794: );
1795: END IF;
1796: x_return_status := FND_API.G_RET_STS_ERROR;
1797: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1798:
1799: END IF ;
1800: END IF ;

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

1799: END IF ;
1800: END IF ;
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

Line 1814: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

1819:
1820:
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

Line 1834: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

1835: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1836: END IF;
1837:
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

Line 1851: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

1852: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1853: END IF;
1854:
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

Line 1868: x_return_status := FND_API.G_RET_STS_ERROR;

1864: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1865: , p_Token_Tbl => l_Token_Tbl
1866: );
1867: END IF;
1868: x_return_status := FND_API.G_RET_STS_ERROR;
1869: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1870: END IF;
1871:
1872:

Line 2010: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2020: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2016: -- Done validating attributes
2017:
2018: EXCEPTION
2019:
2020: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2021:
2022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2023: x_err_text := l_err_text;
2024:

Line 2022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2018: EXCEPTION
2019:
2020: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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

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

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

Line 2052: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 2081: x_return_status := FND_API.G_RET_STS_ERROR;

2077: , x_Mesg_Token_Tbl => x_Mesg_Token_Tbl
2078: , p_Token_Tbl => l_Token_Tbl
2079: );
2080: END IF;
2081: x_return_status := FND_API.G_RET_STS_ERROR;
2082: END IF;
2083:
2084: END IF ;
2085:

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

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

Line 2091: = FND_API.G_MISS_CHAR

2087: -- Conditionally required validation for hierarchy_flag and organization_hierarchy
2088: --
2089: IF p_ECO_rec.hierarchy_flag = 1 AND
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

Line 2103: x_return_status := FND_API.G_RET_STS_ERROR;

2099: , x_Mesg_Token_Tbl => x_Mesg_Token_Tbl
2100: , p_Token_Tbl => l_Token_Tbl
2101: );
2102: END IF;
2103: x_return_status := FND_API.G_RET_STS_ERROR;
2104: END IF;
2105: */
2106:
2107:

Line 2112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2108: EXCEPTION
2109:
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);

Line 2155: l_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 2175: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2187: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2200: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2211: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2213: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

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

Line 2223: l_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 2358: l_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 2510: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2519: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2528: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2537: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2550: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2562: l_return_status := FND_API.G_RET_STS_ERROR;

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