APPS.CSP_PC_FORM_MTLTXNS dependencies on MTL_ITEM_SUB_INVENTORIES

Line 1076: from mtl_item_sub_inventories

1072: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
1073: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
1074: BEGIN
1075: select secondary_inventory into l_restricted_sub
1076: from mtl_item_sub_inventories
1077: where organization_id = p_organization_id
1078: and inventory_item_id = l_inventory_item_id
1079: and secondary_inventory = l_csp_intransit_subinventory;
1080:

Line 1084: -- the mtl_item_sub_inventories table by calling the

1080:
1081: EXCEPTION
1082: WHEN NO_DATA_FOUND THEN
1083: -- Assign the item to the l_csp_intransit_subinventory in
1084: -- the mtl_item_sub_inventories table by calling the
1085: -- mtl_item_sub_inventories_pkg.insert_row.
1086: CSP_ITEM_SUB_INVENTORIES_PKG.Insert_Row(
1087: px_INVENTORY_ITEM_ID => l_inventory_item_id,
1088: p_ORGANIZATION_ID => p_organization_id,

Line 1085: -- mtl_item_sub_inventories_pkg.insert_row.

1081: EXCEPTION
1082: WHEN NO_DATA_FOUND THEN
1083: -- Assign the item to the l_csp_intransit_subinventory in
1084: -- the mtl_item_sub_inventories table by calling the
1085: -- mtl_item_sub_inventories_pkg.insert_row.
1086: CSP_ITEM_SUB_INVENTORIES_PKG.Insert_Row(
1087: px_INVENTORY_ITEM_ID => l_inventory_item_id,
1088: p_ORGANIZATION_ID => p_organization_id,
1089: p_SECONDARY_INVENTORY => l_csp_intransit_subinventory,

Line 1131: fnd_message.set_token('TABLE', 'mtl_item_sub_inventories', TRUE);

1127: WHEN OTHERS THEN
1128: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1129: fnd_message.set_token('ERR_FIELD', 'secondary_inventory', TRUE);
1130: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
1131: fnd_message.set_token('TABLE', 'mtl_item_sub_inventories', TRUE);
1132: FND_MSG_PUB.ADD;
1133:
1134: IF c_ml_records%ISOPEN THEN
1135: close c_ml_records;