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.INV_VALIDATE_TROLIN dependencies on INV_VALIDATE_TROHDR

Line 32: p_org IN inv_validate_trohdr.ORG ) RETURN NUMBER

28:
29: -- ---------------------------------------------------------------------
30: FUNCTION Line_Number ( p_line_number IN NUMBER,
31: p_header_id IN NUMBER,
32: p_org IN inv_validate_trohdr.ORG ) RETURN NUMBER
33: IS
34: l_dummy VARCHAR2(10);
35: l_return_value BOOLEAN;
36: l_request_number VARCHAR2(30);

Line 576: IF p_trolin_rec.organization_id <> INV_Validate_Trohdr.g_org.organization_id

572:
573: --inv_debug.message('ssia', 'TRO: validating attributes');
574: -- Validate trolin attributes
575:
576: IF p_trolin_rec.organization_id <> INV_Validate_Trohdr.g_org.organization_id
577: THEN
578: x_return_status := FND_API.G_RET_STS_ERROR;
579: return;
580: END IF;

Line 598: inv_validate_trohdr.g_org.organization_id := p_trolin_rec.organization_id;

594: p_old_trolin_rec.inventory_item_id IS NULL )
595: THEN
596:
597: g_item.inventory_item_id := p_trolin_rec.inventory_item_id;
598: inv_validate_trohdr.g_org.organization_id := p_trolin_rec.organization_id;
599:
600: IF INV_Validate.Inventory_Item(g_item,inv_validate_trohdr.g_org) =
601: INV_Validate.F
602: THEN

Line 600: IF INV_Validate.Inventory_Item(g_item,inv_validate_trohdr.g_org) =

596:
597: g_item.inventory_item_id := p_trolin_rec.inventory_item_id;
598: inv_validate_trohdr.g_org.organization_id := p_trolin_rec.organization_id;
599:
600: IF INV_Validate.Inventory_Item(g_item,inv_validate_trohdr.g_org) =
601: INV_Validate.F
602: THEN
603: x_return_status := FND_API.G_RET_STS_ERROR;
604: return;

Line 655: IF INV_Validate_Trohdr.Date_Required(p_trolin_rec.date_required) =

651: ( p_trolin_rec.date_required <>
652: p_old_trolin_rec.date_required OR
653: p_old_trolin_rec.date_required IS NULL )
654: THEN
655: IF INV_Validate_Trohdr.Date_Required(p_trolin_rec.date_required) =
656: INV_Validate.F
657: THEN
658: x_return_status := FND_API.G_RET_STS_ERROR;
659: return;

Line 678: inv_validate_trohdr.g_org,

674: ELSE
675: l_acct_txn := 1;
676: END IF;
677: IF INV_Validate.From_Subinventory(g_from_sub,
678: inv_validate_trohdr.g_org,
679: g_item,l_acct_txn ) = INV_Validate.F
680: THEN
681: --inv_Debug.message('ssia', 'error from inv_validate.from_subinventory');
682: x_return_status := FND_API.G_RET_STS_ERROR;

Line 772: ,inv_validate_trohdr.g_org

768: END IF;
769: IF (l_pjm = 2) THEN
770: IF INV_Validate.From_Locator(
771: g_from_locator
772: ,inv_validate_trohdr.g_org
773: ,g_item
774: ,g_from_sub
775: ,NULL
776: ,NULL

Line 784: inv_validate_trohdr.g_org,

780: return;
781: END IF;
782: ELSE
783: IF INV_Validate.From_Locator(g_from_locator,
784: inv_validate_trohdr.g_org,
785: g_item, g_from_sub,
786: p_trolin_rec.project_id,
787: p_trolin_rec.task_id,
788: inv_validate_trolin.g_transaction_l.transaction_action_id) =

Line 805: IF INV_Validate_Trohdr.Header(p_trolin_rec.header_id) =

801: ( p_trolin_rec.header_id <>
802: p_old_trolin_rec.header_id OR
803: p_old_trolin_rec.header_id IS NULL )
804: THEN
805: IF INV_Validate_Trohdr.Header(p_trolin_rec.header_id) =
806: INV_Validate.F THEN
807: x_return_status := FND_API.G_RET_STS_ERROR;
808: return;
809: END IF;

Line 882: inv_validate_trohdr.g_org) = F

878: p_old_trolin_rec.line_number OR
879: p_old_trolin_rec.line_number IS NULL )
880: THEN
881: IF Line_Number(p_trolin_rec.line_number,p_trolin_rec.header_id,
882: inv_validate_trohdr.g_org) = F
883: THEN
884: x_return_status := FND_API.G_RET_STS_ERROR;
885: RETURN;
886: END IF;

Line 1087: IF INV_Validate_Trohdr.Request(p_trolin_rec.request_id) =

1083: ( p_trolin_rec.request_id <>
1084: p_old_trolin_rec.request_id OR
1085: p_old_trolin_rec.request_id IS NULL )
1086: THEN
1087: IF INV_Validate_Trohdr.Request(p_trolin_rec.request_id) =
1088: inv_validate.F THEN
1089: x_return_status := FND_API.G_RET_STS_ERROR;
1090: return;
1091: END IF;

Line 1101: inv_validate_trohdr.g_org,

1097: p_old_trolin_rec.revision OR
1098: p_old_trolin_rec.revision IS NULL )
1099: THEN
1100: IF INV_Validate.Revision(p_trolin_rec.revision,
1101: inv_validate_trohdr.g_org,
1102: g_item) = inv_validate.F THEN
1103: x_return_status := FND_API.G_RET_STS_ERROR;
1104: return;
1105: END IF;

Line 1131: IF INV_Validate.Lot_Number(g_lot, inv_validate_trohdr.g_org, g_item) = inv_validate.F THEN

1127:
1128: IF l_mov_order_type=INV_GLOBALS.g_move_order_put_away
1129: THEN
1130:
1131: IF INV_Validate.Lot_Number(g_lot, inv_validate_trohdr.g_org, g_item) = inv_validate.F THEN
1132: x_return_status := FND_API.G_RET_STS_ERROR;
1133: return;
1134: END IF;
1135:

Line 1138: IF INV_Validate.Lot_Number(g_lot, inv_validate_trohdr.g_org, g_item,

1134: END IF;
1135:
1136: ELSE
1137:
1138: IF INV_Validate.Lot_Number(g_lot, inv_validate_trohdr.g_org, g_item,
1139: g_from_sub, g_from_locator,
1140: p_trolin_rec.revision) = inv_validate.F THEN
1141: x_return_status := FND_API.G_RET_STS_ERROR;
1142: return;

Line 1149: IF INV_Validate.Lot_Number(g_lot, inv_validate_trohdr.g_org, g_item,

1145: END IF;
1146:
1147:
1148: /*
1149: IF INV_Validate.Lot_Number(g_lot, inv_validate_trohdr.g_org, g_item,
1150: g_from_sub, g_from_locator,
1151: p_trolin_rec.revision) = inv_validate.F THEN
1152: x_return_status := FND_API.G_RET_STS_ERROR;
1153: return;

Line 1166: inv_validate_trohdr.g_org,

1162: p_old_trolin_rec.serial_number_start IS NULL )
1163: THEN
1164: g_serial.serial_number := p_trolin_rec.serial_number_start;
1165: IF INV_Validate.Serial_Number_Start(g_serial,
1166: inv_validate_trohdr.g_org,
1167: g_item, g_from_sub, g_lot,
1168: g_from_locator,
1169: p_trolin_rec.revision) =
1170: inv_validate.F THEN

Line 1184: inv_validate_trohdr.g_org,

1180: p_old_trolin_rec.serial_number_end IS NULL )
1181: THEN
1182: g_serial.serial_number := p_trolin_rec.serial_number_end;
1183: IF INV_Validate.Serial_Number_End(g_serial,
1184: inv_validate_trohdr.g_org,
1185: g_item, g_from_sub, g_lot,
1186: g_from_locator,
1187: p_trolin_rec.revision) =
1188: inv_validate.F THEN

Line 1201: IF INV_Validate_Trohdr.Status_Date(p_trolin_rec.status_date) =

1197: ( p_trolin_rec.status_date <>
1198: p_old_trolin_rec.status_date OR
1199: p_old_trolin_rec.status_date IS NULL )
1200: THEN
1201: IF INV_Validate_Trohdr.Status_Date(p_trolin_rec.status_date) =
1202: inv_validate.F THEN
1203: x_return_status := FND_API.G_RET_STS_ERROR;
1204: return;
1205: END IF;

Line 1218: WHERE ORG.ORGANIZATION_ID = inv_validate_trohdr.g_org.organization_id;

1214:
1215: SELECT ORG.CHART_OF_ACCOUNTS_ID
1216: INTO l_chart_of_accounts_id
1217: FROM ORG_ORGANIZATION_DEFINITIONS ORG
1218: WHERE ORG.ORGANIZATION_ID = inv_validate_trohdr.g_org.organization_id;
1219:
1220: l_keystat_val := FND_FLEX_KEYVAL.Validate_Segs(
1221: OPERATION => 'CREATE_COMBINATION',
1222: APPL_SHORT_NAME => 'SQLGL',

Line 1258: IF INV_Validate.To_Subinventory(g_to_sub, inv_validate_trohdr.g_org,

1254: p_old_trolin_rec.to_subinventory_code IS NULL )
1255: THEN
1256: --inv_debug.message('ssia', 'check to_subinventory_code');
1257: g_to_sub.secondary_inventory_name := p_trolin_rec.to_subinventory_code;
1258: IF INV_Validate.To_Subinventory(g_to_sub, inv_validate_trohdr.g_org,
1259: g_item, g_from_sub, 0) =
1260: inv_validate.F THEN
1261: --inv_debug.message('ssia', 'error to_subinventory_code');
1262: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1316: inv_validate_trohdr.g_org.stock_locator_control_code,

1312: INV_Globals.Locator_control(
1313: l_return_status,
1314: l_msg_count,
1315: l_msg_data,
1316: inv_validate_trohdr.g_org.stock_locator_control_code,
1317: nvl(g_to_sub.locator_type,1),
1318: g_item.location_control_code,
1319: g_item.restrict_locators_code,
1320: inv_validate_trohdr.g_org.negative_inv_receipt_code,

Line 1320: inv_validate_trohdr.g_org.negative_inv_receipt_code,

1316: inv_validate_trohdr.g_org.stock_locator_control_code,
1317: nvl(g_to_sub.locator_type,1),
1318: g_item.location_control_code,
1319: g_item.restrict_locators_code,
1320: inv_validate_trohdr.g_org.negative_inv_receipt_code,
1321: inv_validate_trolin.g_transaction_l.transaction_action_id);
1322: if (NVL(v_locator_control,1) = 3) then
1323: l_keystat_val := FND_FLEX_KEYVAL.Validate_Segs(
1324: OPERATION => 'CREATE_COMB_NO_AT',

Line 1330: DATA_SET => inv_validate_trohdr.g_org.organization_id);

1326: KEY_FLEX_CODE => 'MTLL',
1327: STRUCTURE_NUMBER => 101,
1328: CONCAT_SEGMENTS => p_trolin_val_rec.to_locator,
1329: VALUES_OR_IDS => 'V',
1330: DATA_SET => inv_validate_trohdr.g_org.organization_id);
1331:
1332: if l_keystat_val then
1333: l_combination_id := FND_FLEX_KEYVAL.combination_id;
1334: BEGIN

Line 1339: AND ORGANIZATION_ID = inv_validate_trohdr.g_org.organization_id

1335: SELECT 'EXISTS'
1336: INTO l_temp
1337: FROM MTL_ITEM_LOCATIONS
1338: WHERE INVENTORY_LOCATION_ID = l_combination_id
1339: AND ORGANIZATION_ID = inv_validate_trohdr.g_org.organization_id
1340: AND SUBINVENTORY_CODE = g_to_sub.secondary_inventory_name;
1341:
1342: EXCEPTION
1343: WHEN NO_DATA_FOUND THEN

Line 1347: AND ORGANIZATION_ID = inv_validate_trohdr.g_org.organization_id

1343: WHEN NO_DATA_FOUND THEN
1344: UPDATE mtl_item_locations
1345: SET SUBINVENTORY_CODE = g_to_sub.secondary_inventory_name
1346: WHERE INVENTORY_LOCATION_ID = l_combination_id
1347: AND ORGANIZATION_ID = inv_validate_trohdr.g_org.organization_id
1348: AND SUBINVENTORY_CODE = NULL;
1349:
1350: if SQL%NOTFOUND then
1351: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1358: AND ORGANIZATION_ID =inv_validate_trohdr.g_org.organization_id;

1354: SELECT PROJECT_ID,TASK_ID
1355: INTO l_project_id, l_task_id
1356: FROM MTL_ITEM_LOCATIONS
1357: WHERE INVENTORY_LOCATION_ID = l_combination_id
1358: AND ORGANIZATION_ID =inv_validate_trohdr.g_org.organization_id;
1359:
1360: if NOT INV_ProjectLocator_PUB.Check_Project_References(
1361: inv_validate_trohdr.g_org.organization_id,
1362: p_trolin_rec.to_locator_id,

Line 1361: inv_validate_trohdr.g_org.organization_id,

1357: WHERE INVENTORY_LOCATION_ID = l_combination_id
1358: AND ORGANIZATION_ID =inv_validate_trohdr.g_org.organization_id;
1359:
1360: if NOT INV_ProjectLocator_PUB.Check_Project_References(
1361: inv_validate_trohdr.g_org.organization_id,
1362: p_trolin_rec.to_locator_id,
1363: 'ANY',
1364: 'N',
1365: l_project_id,

Line 1407: inv_validate_trohdr.g_org, g_item,

1403: IF l_project_id_mil is NOT NULL THEN
1404:
1405:
1406: IF INV_Validate.To_Locator(g_to_locator,
1407: inv_validate_trohdr.g_org, g_item,
1408: g_to_sub, p_trolin_rec.project_id,
1409: p_trolin_rec.task_id,
1410: inv_validate_trolin.g_transaction_l.transaction_action_id) = inv_validate.F THEN
1411: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1418: inv_validate_trohdr.g_org, g_item,

1414:
1415: ELSE
1416:
1417: IF INV_Validate.To_Locator(g_to_locator,
1418: inv_validate_trohdr.g_org, g_item,
1419: g_to_sub, null, null,
1420: inv_validate_trolin.g_transaction_l.transaction_action_id) = inv_validate.F THEN
1421: x_return_status := FND_API.G_RET_STS_ERROR;
1422: return;

Line 1461: inv_validate_trohdr.g_org, g_item) = inv_validate.F THEN

1457: p_old_trolin_rec.uom_code OR
1458: p_old_trolin_rec.uom_code IS NULL )
1459: THEN
1460: IF INV_Validate.Uom(p_trolin_rec.uom_code,
1461: inv_validate_trohdr.g_org, g_item) = inv_validate.F THEN
1462: x_return_status := FND_API.G_RET_STS_ERROR;
1463: END IF;
1464: END IF;
1465: