APPS.CSI_T_TXN_LINE_DTLS_PVT dependencies on CSI_ITEM_INSTANCE_VLD_PVT

Line 212: csi_item_instance_vld_pvt.is_valid_instance_type(

208:
209: --debug('Validate instance type code.');
210:
211: IF NOT
212: csi_item_instance_vld_pvt.is_valid_instance_type(
213: p_instance_type_code => p_txn_line_dtl_rec.instance_type_code)
214: THEN
215: debug('Validate instance type code failed.');
216: RAISE fnd_api.g_exc_error;

Line 251: csi_item_instance_vld_pvt.is_valid_system_id(

247: THEN
248:
249: --debug('Validate csi system id .');
250: IF NOT
251: csi_item_instance_vld_pvt.is_valid_system_id(
252: p_system_id => p_txn_line_dtl_rec.csi_system_id) THEN
253:
254: debug('Validate csi system id failed.');
255: RAISE fnd_api.g_exc_error;

Line 283: csi_item_instance_vld_pvt.is_trackable(

279: fnd_api.g_miss_num THEN
280:
281: --debug('Validate item id for trackabality .');
282: IF NOT
283: csi_item_instance_vld_pvt.is_trackable(
284: p_inv_item_id => p_txn_line_dtl_rec.inventory_item_id,
285: p_org_id => p_txn_line_dtl_rec.inv_organization_id) THEN
286:
287: debug('Validate item id for trackabality failed.');

Line 302: csi_item_instance_vld_pvt.is_valid_condition(

298: THEN
299:
300: --debug('Validate item condition id .');
301:
302: csi_item_instance_vld_pvt.is_valid_condition(
303: p_instance_condition_id => p_txn_line_dtl_rec.item_condition_id,
304: p_creation_complete_flag => l_creation_flag,
305: l_return_value => l_valid);
306:

Line 321: csi_item_instance_vld_pvt.validate_revision(

317: THEN
318:
319: --debug('Validate item revision .');
320:
321: csi_item_instance_vld_pvt.validate_revision(
322: p_inv_item_id => p_txn_line_dtl_rec.inventory_item_id,
323: p_inv_org_id => p_txn_line_dtl_rec.inv_organization_id,
324: p_revision => p_txn_line_dtl_rec.inventory_revision,
325: p_creation_complete_flag => l_creation_flag,

Line 349: csi_item_instance_vld_pvt.is_valid_uom(

345: END IF;
346:
347: --debug('Validate item uom .');
348: -- validate uom
349: csi_item_instance_vld_pvt.is_valid_uom(
350: p_inv_org_id => p_txn_line_dtl_rec.inv_organization_id,
351: p_inv_item_id => p_txn_line_dtl_rec.inventory_item_id,
352: p_uom_code => l_uom_code,
353: p_quantity => l_quantity,

Line 382: csi_item_instance_vld_pvt.validate_serial_number(

378: RAISE fnd_api.g_exc_error;
379: END IF;
380:
381: /*
382: csi_item_instance_vld_pvt.validate_serial_number(
383: p_inv_org_id => p_txn_line_dtl_rec.inv_organization_id,
384: p_inv_item_id => p_txn_line_dtl_rec.inventory_item_id,
385: p_serial_number => p_txn_line_dtl_rec.serial_number,
386: p_mfg_serial_number_flag => p_txn_line_dtl_rec.mfg_serial_number_flag,

Line 416: csi_item_instance_vld_pvt.validate_lot_number(

412: RAISE fnd_api.g_exc_error;
413: END IF;
414:
415: /*
416: csi_item_instance_vld_pvt.validate_lot_number(
417: p_inv_org_id => p_txn_line_dtl_rec.inv_organization_id,
418: p_inv_item_id => p_txn_line_dtl_rec.inventory_item_id,
419: p_lot_number => p_txn_line_dtl_rec.lot_number,
420: p_mfg_serial_number_flag => p_txn_line_dtl_rec.mfg_serial_number_flag,

Line 436: csi_item_instance_vld_pvt.is_valid_location_source(

432: --debug('Validate location type code .');
433:
434: -- location_type_code
435: IF NOT
436: csi_item_instance_vld_pvt.is_valid_location_source(
437: p_loc_source_table => p_txn_line_dtl_rec.location_type_code)
438: THEN
439: debug('Validate location type code failed.');
440: RAISE fnd_api.g_exc_error;

Line 447: l_valid := csi_item_instance_vld_pvt.is_valid_location_id(

443: IF NVL(p_txn_line_dtl_rec.location_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
444: THEN
445:
446: -- debug('Validate location id .');
447: l_valid := csi_item_instance_vld_pvt.is_valid_location_id(
448: p_location_source_table => p_txn_line_dtl_rec.location_type_code,
449: p_location_id => p_txn_line_dtl_rec.location_id);
450:
451: IF NOT (l_valid) then

Line 595: csi_item_instance_vld_pvt.is_valid_status(

591: IF NVL(p_txn_line_dtl_rec.instance_status_id, fnd_api.g_miss_num) <>
592: fnd_api.g_miss_num
593: THEN
594: --debug('Validate instance status id .');
595: csi_item_instance_vld_pvt.is_valid_status(
596: p_instance_status_id => p_txn_line_dtl_rec.instance_status_id,
597: p_creation_complete_flag => l_creation_flag,
598: l_return_value => l_valid);
599:

Line 1295: l_valid := csi_item_instance_vld_pvt.is_valid_system_id(

1291: AND
1292: l_td_rec.csi_system_id is not null
1293: THEN
1294:
1295: l_valid := csi_item_instance_vld_pvt.is_valid_system_id(
1296: p_system_id => l_td_rec.csi_system_id);
1297:
1298: IF NOT (l_valid) THEN
1299: debug('Validate csi system id failed.');

Line 1334: l_valid := csi_item_instance_vld_pvt.is_trackable(

1330:
1331: -- If the transaction is mass update, IB trackable checking is skipped
1332: -- as per ER 6936037
1333: IF NVL(l_src_transaction_type_id, fnd_api.g_miss_num) <> 3 THEN
1334: l_valid := csi_item_instance_vld_pvt.is_trackable(
1335: p_inv_item_id => l_td_rec.inventory_item_id,
1336: p_org_id => l_td_rec.inv_organization_id);
1337:
1338: IF NOT (l_valid) THEN

Line 1362: csi_item_instance_vld_pvt.is_valid_instance_type(

1358: l_td_rec.instance_type_code is not null
1359: THEN
1360:
1361: l_valid :=
1362: csi_item_instance_vld_pvt.is_valid_instance_type(
1363: p_instance_type_code => l_td_rec.instance_type_code);
1364:
1365: IF NOT (l_valid) THEN
1366: debug('Validate instance type code failed.');

Line 1380: csi_item_instance_vld_pvt.is_valid_condition(

1376: AND
1377: l_td_rec.item_condition_id is not null
1378: THEN
1379:
1380: csi_item_instance_vld_pvt.is_valid_condition(
1381: p_instance_condition_id => l_td_rec.item_condition_id,
1382: p_creation_complete_flag => l_creation_flag,
1383: l_return_value => l_valid);
1384:

Line 1465: csi_item_instance_vld_pvt.validate_serial_number(

1461: END IF;
1462:
1463: /*
1464: --validate serial_number
1465: csi_item_instance_vld_pvt.validate_serial_number(
1466: p_inv_org_id => l_td_rec.inv_organization_id,
1467: p_inv_item_id => l_td_rec.inventory_item_id,
1468: p_serial_number => l_td_rec.serial_number,
1469: p_mfg_serial_number_flag => l_td_rec.mfg_serial_number_flag,

Line 1490: csi_item_instance_vld_pvt.is_valid_location_source(

1486: l_td_rec.location_type_code is not null
1487: THEN
1488:
1489: l_valid :=
1490: csi_item_instance_vld_pvt.is_valid_location_source(
1491: p_loc_source_table => l_td_rec.location_type_code);
1492:
1493: IF NOT (l_valid) THEN
1494: debug('Validate location type code failed.');

Line 1508: l_valid := csi_item_instance_vld_pvt.is_valid_location_id(

1504: AND
1505: l_td_rec.location_id is not null
1506: THEN
1507:
1508: l_valid := csi_item_instance_vld_pvt.is_valid_location_id(
1509: p_location_source_table => l_td_rec.location_type_code,
1510: p_location_id => l_td_rec.location_id);
1511:
1512: IF NOT (l_valid) then

Line 1528: l_valid := csi_item_instance_vld_pvt.is_valid_location_source(

1524: IF l_td_rec.install_location_type_code <> fnd_api.g_miss_char
1525: AND
1526: l_td_rec.install_location_type_code is not null
1527: THEN
1528: l_valid := csi_item_instance_vld_pvt.is_valid_location_source(
1529: p_loc_source_table => l_td_rec.install_location_type_code);
1530:
1531: IF NOT (l_valid) THEN
1532: debug('Validate Install location type code failed.');

Line 1544: l_valid := csi_item_instance_vld_pvt.is_valid_location_id(

1540: IF l_td_rec.install_location_id <> fnd_api.g_miss_num
1541: AND
1542: l_td_rec.install_location_id is not null
1543: THEN
1544: l_valid := csi_item_instance_vld_pvt.is_valid_location_id(
1545: p_location_source_table => l_td_rec.install_location_type_code,
1546: p_location_id => l_td_rec.install_location_id);
1547:
1548: IF NOT (l_valid) then

Line 1579: csi_item_instance_vld_pvt.is_valid_status(

1575: IF NVL(l_td_rec.instance_status_id, fnd_api.g_miss_num) <>
1576: fnd_api.g_miss_num
1577: THEN
1578: --debug('Validate instance status id .');
1579: csi_item_instance_vld_pvt.is_valid_status(
1580: p_instance_status_id => l_td_rec.instance_status_id,
1581: p_creation_complete_flag => l_creation_flag,
1582: l_return_value => l_valid);
1583: