DBA Data[Home] [Help]

APPS.INV_TRANSFER_ORDER_PVT dependencies on INV_VALIDATE

Line 1015: inv_validate_trohdr.ATTRIBUTES(x_return_status => l_return_status, p_trohdr_rec => l_trohdr_rec, p_trohdr_val_rec => l_trohdr_val_rec, p_old_trohdr_rec => l_old_trohdr_rec);

1011:
1012: IF p_validation_level > fnd_api.g_valid_level_none THEN
1013: -- Bug#2536932: Setting Missing elements of P_TROHDR_VAL_REC to NULL values.
1014: l_trohdr_val_rec := inv_trohdr_util.convert_miss_to_null(p_trohdr_val_rec);
1015: inv_validate_trohdr.ATTRIBUTES(x_return_status => l_return_status, p_trohdr_rec => l_trohdr_rec, p_trohdr_val_rec => l_trohdr_val_rec, p_old_trohdr_rec => l_old_trohdr_rec);
1016:
1017: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1018: RAISE fnd_api.g_exc_unexpected_error;
1019: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

Line 1041: inv_validate_trohdr.entity_delete(x_return_status => l_return_status, p_trohdr_rec => l_trohdr_rec);

1037:
1038: -- Entity level validation.
1039: IF l_control_rec.validate_entity THEN
1040: IF l_trohdr_rec.operation = inv_globals.g_opr_delete THEN
1041: inv_validate_trohdr.entity_delete(x_return_status => l_return_status, p_trohdr_rec => l_trohdr_rec);
1042: ELSE
1043: inv_validate_trohdr.entity(x_return_status => l_return_status, p_trohdr_rec => l_trohdr_rec, p_old_trohdr_rec => l_old_trohdr_rec);
1044: END IF;
1045:

Line 1043: inv_validate_trohdr.entity(x_return_status => l_return_status, p_trohdr_rec => l_trohdr_rec, p_old_trohdr_rec => l_old_trohdr_rec);

1039: IF l_control_rec.validate_entity THEN
1040: IF l_trohdr_rec.operation = inv_globals.g_opr_delete THEN
1041: inv_validate_trohdr.entity_delete(x_return_status => l_return_status, p_trohdr_rec => l_trohdr_rec);
1042: ELSE
1043: inv_validate_trohdr.entity(x_return_status => l_return_status, p_trohdr_rec => l_trohdr_rec, p_old_trohdr_rec => l_old_trohdr_rec);
1044: END IF;
1045:
1046: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1047: RAISE fnd_api.g_exc_unexpected_error;

Line 1163: /* Fix for Bug# 3409435. Calling the INV_Validate_Trolin.init procedure

1159: BEGIN
1160: -- Load local records.
1161: l_trolin_rec := l_trolin_tbl(i);
1162:
1163: /* Fix for Bug# 3409435. Calling the INV_Validate_Trolin.init procedure
1164: to initialize the global variables used in inv_validate_trolin package */
1165: INV_Validate_Trolin.init;
1166:
1167: /* Bug 2504964: Tracking Ship Set : Code Starts */

Line 1164: to initialize the global variables used in inv_validate_trolin package */

1160: -- Load local records.
1161: l_trolin_rec := l_trolin_tbl(i);
1162:
1163: /* Fix for Bug# 3409435. Calling the INV_Validate_Trolin.init procedure
1164: to initialize the global variables used in inv_validate_trolin package */
1165: INV_Validate_Trolin.init;
1166:
1167: /* Bug 2504964: Tracking Ship Set : Code Starts */
1168: IF l_trolin_rec.ship_set_id IS NOT NULL

Line 1165: INV_Validate_Trolin.init;

1161: l_trolin_rec := l_trolin_tbl(i);
1162:
1163: /* Fix for Bug# 3409435. Calling the INV_Validate_Trolin.init procedure
1164: to initialize the global variables used in inv_validate_trolin package */
1165: INV_Validate_Trolin.init;
1166:
1167: /* Bug 2504964: Tracking Ship Set : Code Starts */
1168: IF l_trolin_rec.ship_set_id IS NOT NULL
1169: AND l_trolin_rec.ship_set_id <> NVL(l_current_ship_set_id, -99) THEN

Line 1244: -- inv_default_trolin.ATTRIBUTES and inv_validate_trolin.ATTRIBUTES

1240:
1241: -- bug 4662395 set the profile mfg_organization_id so
1242: -- the call to PJM_PROJECTS_V will return data.
1243: -- The call to PJM_PROJECTS_V is made indirectly through
1244: -- inv_default_trolin.ATTRIBUTES and inv_validate_trolin.ATTRIBUTES
1245: -- both of which can be found in the next few lines of code.
1246:
1247: --Bug #5204255
1248: --We should set the profile value only if it is NULL/G_MISS_NUM

Line 1279: inv_validate_trolin.ATTRIBUTES(x_return_status => l_return_status, p_trolin_rec => l_trolin_rec, p_trolin_val_rec => l_trolin_val_rec, p_old_trolin_rec => l_old_trolin_rec);

1275:
1276: l_trolin_rec := l_tmp_trolin_rec;
1277:
1278: IF p_validation_level > fnd_api.g_valid_level_none THEN
1279: inv_validate_trolin.ATTRIBUTES(x_return_status => l_return_status, p_trolin_rec => l_trolin_rec, p_trolin_val_rec => l_trolin_val_rec, p_old_trolin_rec => l_old_trolin_rec);
1280:
1281: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1282: --debug('error in validate_attributes');
1283: IF (l_debug = 1) THEN

Line 1322: inv_validate_trolin.entity_delete(x_return_status => l_return_status, p_trolin_rec => l_trolin_rec);

1318:
1319: -- Entity level validation.
1320: IF l_control_rec.validate_entity THEN
1321: IF l_trolin_rec.operation = inv_globals.g_opr_delete THEN
1322: inv_validate_trolin.entity_delete(x_return_status => l_return_status, p_trolin_rec => l_trolin_rec);
1323: ELSE
1324: --debug('Trolin Validate Entity');
1325: IF (l_debug = 1) THEN
1326: DEBUG('Trolin Validate Entity', 'Inv_Transfer_Order_PVT.Trolins');

Line 1328: inv_validate_trolin.entity(x_return_status => l_return_status, p_trolin_rec => l_trolin_rec, p_old_trolin_rec => l_old_trolin_rec, p_move_order_type => p_move_order_type);

1324: --debug('Trolin Validate Entity');
1325: IF (l_debug = 1) THEN
1326: DEBUG('Trolin Validate Entity', 'Inv_Transfer_Order_PVT.Trolins');
1327: END IF;
1328: inv_validate_trolin.entity(x_return_status => l_return_status, p_trolin_rec => l_trolin_rec, p_old_trolin_rec => l_old_trolin_rec, p_move_order_type => p_move_order_type);
1329: END IF;
1330:
1331: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1332: l_trolin_rec.return_status := l_return_status;

Line 2038: l_org inv_validate.org;

2034: END get_transfer_order;
2035:
2036: FUNCTION validate_from_subinventory(p_from_subinventory_code IN VARCHAR2, p_organization_id IN NUMBER, p_inventory_item_id IN NUMBER, p_transaction_type_id IN NUMBER, p_restrict_subinventories_code IN NUMBER)
2037: RETURN BOOLEAN IS
2038: l_org inv_validate.org;
2039: l_item inv_validate.item;
2040: l_acct_txn NUMBER;
2041: l_return NUMBER;
2042: l_result BOOLEAN;

Line 2039: l_item inv_validate.item;

2035:
2036: FUNCTION validate_from_subinventory(p_from_subinventory_code IN VARCHAR2, p_organization_id IN NUMBER, p_inventory_item_id IN NUMBER, p_transaction_type_id IN NUMBER, p_restrict_subinventories_code IN NUMBER)
2037: RETURN BOOLEAN IS
2038: l_org inv_validate.org;
2039: l_item inv_validate.item;
2040: l_acct_txn NUMBER;
2041: l_return NUMBER;
2042: l_result BOOLEAN;
2043: l_error_msg VARCHAR2(2000);

Line 2053: IF (inv_validate.transaction_type(p_transaction_type_id, l_txn_action_id, l_txn_source_type_id) = inv_validate.t) THEN

2049: l_item.organization_id := p_organization_id;
2050: l_item.inventory_item_id := p_inventory_item_id;
2051: l_item.restrict_subinventories_code := p_restrict_subinventories_code;
2052:
2053: IF (inv_validate.transaction_type(p_transaction_type_id, l_txn_action_id, l_txn_source_type_id) = inv_validate.t) THEN
2054: IF (l_txn_action_id = 1) THEN
2055: l_acct_txn := 1;
2056: ELSE
2057: l_acct_txn := 0;

Line 2063: l_return := inv_validate.from_subinventory(g_from_sub, l_org, l_item, l_acct_txn);

2059: ELSE
2060: RETURN FALSE;
2061: END IF;
2062:
2063: l_return := inv_validate.from_subinventory(g_from_sub, l_org, l_item, l_acct_txn);
2064:
2065: IF (l_return = inv_validate.f) THEN
2066: l_result := FALSE;
2067: ELSE

Line 2065: IF (l_return = inv_validate.f) THEN

2061: END IF;
2062:
2063: l_return := inv_validate.from_subinventory(g_from_sub, l_org, l_item, l_acct_txn);
2064:
2065: IF (l_return = inv_validate.f) THEN
2066: l_result := FALSE;
2067: ELSE
2068: l_result := TRUE;
2069: END IF;

Line 2084: l_org inv_validate.org;

2080: , p_asset_item IN VARCHAR2
2081: , p_from_sub_asset IN NUMBER
2082: )
2083: RETURN BOOLEAN IS
2084: l_org inv_validate.org;
2085: l_item inv_validate.item;
2086: l_sub inv_validate.sub;
2087: l_acct_txn NUMBER;
2088: l_return NUMBER;

Line 2085: l_item inv_validate.item;

2081: , p_from_sub_asset IN NUMBER
2082: )
2083: RETURN BOOLEAN IS
2084: l_org inv_validate.org;
2085: l_item inv_validate.item;
2086: l_sub inv_validate.sub;
2087: l_acct_txn NUMBER;
2088: l_return NUMBER;
2089: l_result BOOLEAN;

Line 2086: l_sub inv_validate.sub;

2082: )
2083: RETURN BOOLEAN IS
2084: l_org inv_validate.org;
2085: l_item inv_validate.item;
2086: l_sub inv_validate.sub;
2087: l_acct_txn NUMBER;
2088: l_return NUMBER;
2089: l_result BOOLEAN;
2090: BEGIN

Line 2105: l_return := inv_validate.to_subinventory(l_sub, l_org, l_item, g_from_sub, l_acct_txn);

2101: END IF;
2102:
2103: l_item.inventory_asset_flag := p_asset_item;
2104: -- g_from_sub.asset_inventory := p_from_sub_asset;
2105: l_return := inv_validate.to_subinventory(l_sub, l_org, l_item, g_from_sub, l_acct_txn);
2106:
2107: IF (l_return = inv_validate.f) THEN
2108: --l_error_msg := FND_MSG_PUB.GET(p_encoded => FND_API.G_FALSE);
2109: l_result := FALSE;

Line 2107: IF (l_return = inv_validate.f) THEN

2103: l_item.inventory_asset_flag := p_asset_item;
2104: -- g_from_sub.asset_inventory := p_from_sub_asset;
2105: l_return := inv_validate.to_subinventory(l_sub, l_org, l_item, g_from_sub, l_acct_txn);
2106:
2107: IF (l_return = inv_validate.f) THEN
2108: --l_error_msg := FND_MSG_PUB.GET(p_encoded => FND_API.G_FALSE);
2109: l_result := FALSE;
2110: ELSE
2111: l_result := TRUE;