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 605: inv_validate_trohdr.g_org.organization_id := p_trolin_rec.organization_id;

601: p_old_trolin_rec.inventory_item_id OR
602: p_old_trolin_rec.inventory_item_id IS NULL )
603: THEN
604: g_item.inventory_item_id := p_trolin_rec.inventory_item_id;
605: inv_validate_trohdr.g_org.organization_id := p_trolin_rec.organization_id;
606: /* bug9267446 */
607: IF g_transaction_l.transaction_type_id IS NOT NULL THEN
608: IF INV_Validate.Inventory_Item(g_item,inv_validate_trohdr.g_org,g_transaction_l.transaction_type_id) =
609: INV_Validate.F

Line 608: IF INV_Validate.Inventory_Item(g_item,inv_validate_trohdr.g_org,g_transaction_l.transaction_type_id) =

604: g_item.inventory_item_id := p_trolin_rec.inventory_item_id;
605: inv_validate_trohdr.g_org.organization_id := p_trolin_rec.organization_id;
606: /* bug9267446 */
607: IF g_transaction_l.transaction_type_id IS NOT NULL THEN
608: IF INV_Validate.Inventory_Item(g_item,inv_validate_trohdr.g_org,g_transaction_l.transaction_type_id) =
609: INV_Validate.F
610: THEN
611: x_return_status := FND_API.G_RET_STS_ERROR;
612: return;

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

612: return;
613: END IF;
614: ELSE
615: /* bug9267446 */
616: IF INV_Validate.Inventory_Item(g_item,inv_validate_trohdr.g_org) =
617: --IF INV_Validate.Inventory_Item(g_item,inv_validate_trohdr.g_org) =
618: INV_Validate.F
619: THEN
620: x_return_status := FND_API.G_RET_STS_ERROR;

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

613: END IF;
614: ELSE
615: /* bug9267446 */
616: IF INV_Validate.Inventory_Item(g_item,inv_validate_trohdr.g_org) =
617: --IF INV_Validate.Inventory_Item(g_item,inv_validate_trohdr.g_org) =
618: INV_Validate.F
619: THEN
620: x_return_status := FND_API.G_RET_STS_ERROR;
621: return;

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

623: END IF;
624: END IF;
625: --inv_debug.message('ssia', 'TRO: item: ' || x_return_status);
626: -- Bug 15841667 Org validation added after item validation
627: IF p_trolin_rec.organization_id <> INV_Validate_Trohdr.g_org.organization_id
628: THEN
629: x_return_status := FND_API.G_RET_STS_ERROR;
630: return;
631: END IF;

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

665: ( p_trolin_rec.date_required <>
666: p_old_trolin_rec.date_required OR
667: p_old_trolin_rec.date_required IS NULL )
668: THEN
669: IF INV_Validate_Trohdr.Date_Required(p_trolin_rec.date_required) =
670: INV_Validate.F
671: THEN
672: x_return_status := FND_API.G_RET_STS_ERROR;
673: return;

Line 692: inv_validate_trohdr.g_org,

688: ELSE
689: l_acct_txn := 1;
690: END IF;
691: IF INV_Validate.From_Subinventory(g_from_sub,
692: inv_validate_trohdr.g_org,
693: g_item,l_acct_txn ) = INV_Validate.F
694: THEN
695: --inv_Debug.message('ssia', 'error from inv_validate.from_subinventory');
696: x_return_status := FND_API.G_RET_STS_ERROR;

Line 786: ,inv_validate_trohdr.g_org

782: END IF;
783: IF (l_pjm = 2) THEN
784: IF INV_Validate.From_Locator(
785: g_from_locator
786: ,inv_validate_trohdr.g_org
787: ,g_item
788: ,g_from_sub
789: ,NULL
790: ,NULL

Line 798: inv_validate_trohdr.g_org,

794: return;
795: END IF;
796: ELSE
797: IF INV_Validate.From_Locator(g_from_locator,
798: inv_validate_trohdr.g_org,
799: g_item, g_from_sub,
800: p_trolin_rec.project_id,
801: p_trolin_rec.task_id,
802: inv_validate_trolin.g_transaction_l.transaction_action_id) =

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

815: ( p_trolin_rec.header_id <>
816: p_old_trolin_rec.header_id OR
817: p_old_trolin_rec.header_id IS NULL )
818: THEN
819: IF INV_Validate_Trohdr.Header(p_trolin_rec.header_id) =
820: INV_Validate.F THEN
821: x_return_status := FND_API.G_RET_STS_ERROR;
822: return;
823: END IF;

Line 896: inv_validate_trohdr.g_org) = F

892: p_old_trolin_rec.line_number OR
893: p_old_trolin_rec.line_number IS NULL )
894: THEN
895: IF Line_Number(p_trolin_rec.line_number,p_trolin_rec.header_id,
896: inv_validate_trohdr.g_org) = F
897: THEN
898: x_return_status := FND_API.G_RET_STS_ERROR;
899: RETURN;
900: END IF;

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

1097: ( p_trolin_rec.request_id <>
1098: p_old_trolin_rec.request_id OR
1099: p_old_trolin_rec.request_id IS NULL )
1100: THEN
1101: IF INV_Validate_Trohdr.Request(p_trolin_rec.request_id) =
1102: inv_validate.F THEN
1103: x_return_status := FND_API.G_RET_STS_ERROR;
1104: return;
1105: END IF;

Line 1115: inv_validate_trohdr.g_org,

1111: p_old_trolin_rec.revision OR
1112: p_old_trolin_rec.revision IS NULL )
1113: THEN
1114: IF INV_Validate.Revision(p_trolin_rec.revision,
1115: inv_validate_trohdr.g_org,
1116: g_item) = inv_validate.F THEN
1117: x_return_status := FND_API.G_RET_STS_ERROR;
1118: return;
1119: END IF;

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

1141:
1142: IF l_mov_order_type=INV_GLOBALS.g_move_order_put_away
1143: THEN
1144:
1145: IF INV_Validate.Lot_Number(g_lot, inv_validate_trohdr.g_org, g_item) = inv_validate.F THEN
1146: x_return_status := FND_API.G_RET_STS_ERROR;
1147: return;
1148: END IF;
1149:

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

1148: END IF;
1149:
1150: ELSE
1151:
1152: IF INV_Validate.Lot_Number(g_lot, inv_validate_trohdr.g_org, g_item,
1153: g_from_sub, g_from_locator,
1154: p_trolin_rec.revision) = inv_validate.F THEN
1155: x_return_status := FND_API.G_RET_STS_ERROR;
1156: return;

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

1159: END IF;
1160:
1161:
1162: /*
1163: IF INV_Validate.Lot_Number(g_lot, inv_validate_trohdr.g_org, g_item,
1164: g_from_sub, g_from_locator,
1165: p_trolin_rec.revision) = inv_validate.F THEN
1166: x_return_status := FND_API.G_RET_STS_ERROR;
1167: return;

Line 1180: inv_validate_trohdr.g_org,

1176: p_old_trolin_rec.serial_number_start IS NULL )
1177: THEN
1178: g_serial.serial_number := p_trolin_rec.serial_number_start;
1179: IF INV_Validate.Serial_Number_Start(g_serial,
1180: inv_validate_trohdr.g_org,
1181: g_item, g_from_sub, g_lot,
1182: g_from_locator,
1183: p_trolin_rec.revision) =
1184: inv_validate.F THEN

Line 1198: inv_validate_trohdr.g_org,

1194: p_old_trolin_rec.serial_number_end IS NULL )
1195: THEN
1196: g_serial.serial_number := p_trolin_rec.serial_number_end;
1197: IF INV_Validate.Serial_Number_End(g_serial,
1198: inv_validate_trohdr.g_org,
1199: g_item, g_from_sub, g_lot,
1200: g_from_locator,
1201: p_trolin_rec.revision) =
1202: inv_validate.F THEN

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

1211: ( p_trolin_rec.status_date <>
1212: p_old_trolin_rec.status_date OR
1213: p_old_trolin_rec.status_date IS NULL )
1214: THEN
1215: IF INV_Validate_Trohdr.Status_Date(p_trolin_rec.status_date) =
1216: inv_validate.F THEN
1217: x_return_status := FND_API.G_RET_STS_ERROR;
1218: return;
1219: END IF;

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

1228:
1229: SELECT ORG.CHART_OF_ACCOUNTS_ID
1230: INTO l_chart_of_accounts_id
1231: FROM ORG_ORGANIZATION_DEFINITIONS ORG
1232: WHERE ORG.ORGANIZATION_ID = inv_validate_trohdr.g_org.organization_id;
1233:
1234: l_keystat_val := FND_FLEX_KEYVAL.Validate_Segs(
1235: OPERATION => 'CREATE_COMBINATION',
1236: APPL_SHORT_NAME => 'SQLGL',

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

1268: p_old_trolin_rec.to_subinventory_code IS NULL )
1269: THEN
1270: --inv_debug.message('ssia', 'check to_subinventory_code');
1271: g_to_sub.secondary_inventory_name := p_trolin_rec.to_subinventory_code;
1272: IF INV_Validate.To_Subinventory(g_to_sub, inv_validate_trohdr.g_org,
1273: g_item, g_from_sub, 0) =
1274: inv_validate.F THEN
1275: --inv_debug.message('ssia', 'error to_subinventory_code');
1276: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1330: inv_validate_trohdr.g_org.stock_locator_control_code,

1326: INV_Globals.Locator_control(
1327: l_return_status,
1328: l_msg_count,
1329: l_msg_data,
1330: inv_validate_trohdr.g_org.stock_locator_control_code,
1331: nvl(g_to_sub.locator_type,1),
1332: g_item.location_control_code,
1333: g_item.restrict_locators_code,
1334: inv_validate_trohdr.g_org.negative_inv_receipt_code,

Line 1334: inv_validate_trohdr.g_org.negative_inv_receipt_code,

1330: inv_validate_trohdr.g_org.stock_locator_control_code,
1331: nvl(g_to_sub.locator_type,1),
1332: g_item.location_control_code,
1333: g_item.restrict_locators_code,
1334: inv_validate_trohdr.g_org.negative_inv_receipt_code,
1335: inv_validate_trolin.g_transaction_l.transaction_action_id);
1336: if (NVL(v_locator_control,1) = 3) then
1337: l_keystat_val := FND_FLEX_KEYVAL.Validate_Segs(
1338: OPERATION => 'CREATE_COMB_NO_AT',

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

1340: KEY_FLEX_CODE => 'MTLL',
1341: STRUCTURE_NUMBER => 101,
1342: CONCAT_SEGMENTS => p_trolin_val_rec.to_locator,
1343: VALUES_OR_IDS => 'V',
1344: DATA_SET => inv_validate_trohdr.g_org.organization_id);
1345:
1346: if l_keystat_val then
1347: l_combination_id := FND_FLEX_KEYVAL.combination_id;
1348: BEGIN

Line 1353: AND ORGANIZATION_ID = inv_validate_trohdr.g_org.organization_id

1349: SELECT 'EXISTS'
1350: INTO l_temp
1351: FROM MTL_ITEM_LOCATIONS
1352: WHERE INVENTORY_LOCATION_ID = l_combination_id
1353: AND ORGANIZATION_ID = inv_validate_trohdr.g_org.organization_id
1354: AND SUBINVENTORY_CODE = g_to_sub.secondary_inventory_name;
1355:
1356: EXCEPTION
1357: WHEN NO_DATA_FOUND THEN

Line 1361: AND ORGANIZATION_ID = inv_validate_trohdr.g_org.organization_id

1357: WHEN NO_DATA_FOUND THEN
1358: UPDATE mtl_item_locations
1359: SET SUBINVENTORY_CODE = g_to_sub.secondary_inventory_name
1360: WHERE INVENTORY_LOCATION_ID = l_combination_id
1361: AND ORGANIZATION_ID = inv_validate_trohdr.g_org.organization_id
1362: AND SUBINVENTORY_CODE = NULL;
1363:
1364: if SQL%NOTFOUND then
1365: x_return_status := FND_API.G_RET_STS_ERROR;

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

1368: SELECT PROJECT_ID,TASK_ID
1369: INTO l_project_id, l_task_id
1370: FROM MTL_ITEM_LOCATIONS
1371: WHERE INVENTORY_LOCATION_ID = l_combination_id
1372: AND ORGANIZATION_ID =inv_validate_trohdr.g_org.organization_id;
1373:
1374: if NOT INV_ProjectLocator_PUB.Check_Project_References(
1375: inv_validate_trohdr.g_org.organization_id,
1376: p_trolin_rec.to_locator_id,

Line 1375: inv_validate_trohdr.g_org.organization_id,

1371: WHERE INVENTORY_LOCATION_ID = l_combination_id
1372: AND ORGANIZATION_ID =inv_validate_trohdr.g_org.organization_id;
1373:
1374: if NOT INV_ProjectLocator_PUB.Check_Project_References(
1375: inv_validate_trohdr.g_org.organization_id,
1376: p_trolin_rec.to_locator_id,
1377: 'ANY',
1378: 'N',
1379: l_project_id,

Line 1421: inv_validate_trohdr.g_org, g_item,

1417: IF l_project_id_mil is NOT NULL THEN
1418:
1419:
1420: IF INV_Validate.To_Locator(g_to_locator,
1421: inv_validate_trohdr.g_org, g_item,
1422: g_to_sub, p_trolin_rec.project_id,
1423: p_trolin_rec.task_id,
1424: inv_validate_trolin.g_transaction_l.transaction_action_id) = inv_validate.F THEN
1425: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1432: inv_validate_trohdr.g_org, g_item,

1428:
1429: ELSE
1430:
1431: IF INV_Validate.To_Locator(g_to_locator,
1432: inv_validate_trohdr.g_org, g_item,
1433: g_to_sub, null, null,
1434: inv_validate_trolin.g_transaction_l.transaction_action_id) = inv_validate.F THEN
1435: x_return_status := FND_API.G_RET_STS_ERROR;
1436: return;

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

1471: p_old_trolin_rec.uom_code OR
1472: p_old_trolin_rec.uom_code IS NULL )
1473: THEN
1474: IF INV_Validate.Uom(p_trolin_rec.uom_code,
1475: inv_validate_trohdr.g_org, g_item) = inv_validate.F THEN
1476: x_return_status := FND_API.G_RET_STS_ERROR;
1477: END IF;
1478: END IF;
1479: