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',
1237: key_flex_code => 'GL#',
1238: STRUCTURE_NUMBER => l_chart_of_accounts_id,
1239: CONCAT_SEGMENTS => p_trolin_val_rec.to_account,
1240: VALUES_OR_IDS => 'V');
1241: -- DATA_SET => INV_Validate.g_TRO_VAttributes.organization_id);
1242: if l_keystat_val then
1243: l_combination_id := FND_FLEX_KEYVAL.combination_id;
1244: p_trolin_rec.to_account_id := l_combination_id;
1245: else
1246: x_return_status := FND_API.G_RET_STS_ERROR;
1247: end if;
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',
1339: APPL_SHORT_NAME => 'INV',
1340: KEY_FLEX_CODE => 'MTLL',
1341: STRUCTURE_NUMBER => 101,
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
1349: SELECT 'EXISTS'
1350: INTO l_temp
1351: FROM MTL_ITEM_LOCATIONS