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.CSI_INV_DISCREPANCY_PKG dependencies on FND_API

Line 30: x_return_status := fnd_api.g_ret_sts_success;

26: l_oracle_schema varchar2(30);
27: l_return boolean;
28: BEGIN
29:
30: x_return_status := fnd_api.g_ret_sts_success;
31:
32: l_return := fnd_installation.get_app_info(
33: application_short_name => p_product_short_name,
34: status => l_status,

Line 41: RAISE fnd_api.g_exc_error;

37:
38: IF NOT l_return THEN
39: fnd_message.set_name('CSI', 'CSI_FND_INVALID_SCHEMA_ERROR');
40: fnd_msg_pub.add;
41: RAISE fnd_api.g_exc_error;
42: END IF;
43:
44: x_schema_name := l_oracle_schema;
45:

Line 47: WHEN fnd_api.g_exc_error THEN

43:
44: x_schema_name := l_oracle_schema;
45:
46: EXCEPTION
47: WHEN fnd_api.g_exc_error THEN
48: x_return_status := fnd_api.g_ret_sts_error;
49: END get_schema_name;
50: --
51: -- Truncate the discrepancy table before each run

Line 48: x_return_status := fnd_api.g_ret_sts_error;

44: x_schema_name := l_oracle_schema;
45:
46: EXCEPTION
47: WHEN fnd_api.g_exc_error THEN
48: x_return_status := fnd_api.g_ret_sts_error;
49: END get_schema_name;
50: --
51: -- Truncate the discrepancy table before each run
52: --

Line 95: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

91: l_source_type VARCHAR2(30);
92:
93: l_schema_name varchar2(30);
94: l_object_name varchar2(80);
95: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
96:
97: Begin
98:
99: get_schema_name(

Line 104: IF l_return_status <> fnd_api.g_ret_sts_success THEN

100: p_product_short_name => 'CSI',
101: x_schema_name => l_schema_name,
102: x_return_status => l_return_status);
103:
104: IF l_return_status <> fnd_api.g_ret_sts_success THEN
105: RAISE fnd_api.g_exc_error;
106: END IF;
107:
108: l_object_name := l_schema_name||'.csi_xnp_msgs_temp';

Line 105: RAISE fnd_api.g_exc_error;

101: x_schema_name => l_schema_name,
102: x_return_status => l_return_status);
103:
104: IF l_return_status <> fnd_api.g_ret_sts_success THEN
105: RAISE fnd_api.g_exc_error;
106: END IF;
107:
108: l_object_name := l_schema_name||'.csi_xnp_msgs_temp';
109:

Line 524: IF (nvl(p_instance_rec.vld_organization_id, fnd_api.g_miss_num) =

520: l_lot_number
521: FROM csi_item_instances
522: WHERE instance_id = p_instance_rec.instance_id;
523:
524: IF (nvl(p_instance_rec.vld_organization_id, fnd_api.g_miss_num) =
525: nvl(l_vld_organization_id, fnd_api.g_miss_num))
526: AND
527: (nvl(p_instance_rec.inv_organization_id,fnd_api.g_miss_num) =
528: nvl(l_inv_organization_id, fnd_api.g_miss_num))

Line 525: nvl(l_vld_organization_id, fnd_api.g_miss_num))

521: FROM csi_item_instances
522: WHERE instance_id = p_instance_rec.instance_id;
523:
524: IF (nvl(p_instance_rec.vld_organization_id, fnd_api.g_miss_num) =
525: nvl(l_vld_organization_id, fnd_api.g_miss_num))
526: AND
527: (nvl(p_instance_rec.inv_organization_id,fnd_api.g_miss_num) =
528: nvl(l_inv_organization_id, fnd_api.g_miss_num))
529: AND

Line 527: (nvl(p_instance_rec.inv_organization_id,fnd_api.g_miss_num) =

523:
524: IF (nvl(p_instance_rec.vld_organization_id, fnd_api.g_miss_num) =
525: nvl(l_vld_organization_id, fnd_api.g_miss_num))
526: AND
527: (nvl(p_instance_rec.inv_organization_id,fnd_api.g_miss_num) =
528: nvl(l_inv_organization_id, fnd_api.g_miss_num))
529: AND
530: (nvl(p_instance_rec.inv_subinventory_name, fnd_api.g_miss_char) =
531: nvl(l_inv_subinventory_name, fnd_api.g_miss_char))

Line 528: nvl(l_inv_organization_id, fnd_api.g_miss_num))

524: IF (nvl(p_instance_rec.vld_organization_id, fnd_api.g_miss_num) =
525: nvl(l_vld_organization_id, fnd_api.g_miss_num))
526: AND
527: (nvl(p_instance_rec.inv_organization_id,fnd_api.g_miss_num) =
528: nvl(l_inv_organization_id, fnd_api.g_miss_num))
529: AND
530: (nvl(p_instance_rec.inv_subinventory_name, fnd_api.g_miss_char) =
531: nvl(l_inv_subinventory_name, fnd_api.g_miss_char))
532: AND

Line 530: (nvl(p_instance_rec.inv_subinventory_name, fnd_api.g_miss_char) =

526: AND
527: (nvl(p_instance_rec.inv_organization_id,fnd_api.g_miss_num) =
528: nvl(l_inv_organization_id, fnd_api.g_miss_num))
529: AND
530: (nvl(p_instance_rec.inv_subinventory_name, fnd_api.g_miss_char) =
531: nvl(l_inv_subinventory_name, fnd_api.g_miss_char))
532: AND
533: (nvl(p_instance_rec.inventory_revision, fnd_api.g_miss_char) =
534: nvl(l_inventory_revision, fnd_api.g_miss_char))

Line 531: nvl(l_inv_subinventory_name, fnd_api.g_miss_char))

527: (nvl(p_instance_rec.inv_organization_id,fnd_api.g_miss_num) =
528: nvl(l_inv_organization_id, fnd_api.g_miss_num))
529: AND
530: (nvl(p_instance_rec.inv_subinventory_name, fnd_api.g_miss_char) =
531: nvl(l_inv_subinventory_name, fnd_api.g_miss_char))
532: AND
533: (nvl(p_instance_rec.inventory_revision, fnd_api.g_miss_char) =
534: nvl(l_inventory_revision, fnd_api.g_miss_char))
535: AND

Line 533: (nvl(p_instance_rec.inventory_revision, fnd_api.g_miss_char) =

529: AND
530: (nvl(p_instance_rec.inv_subinventory_name, fnd_api.g_miss_char) =
531: nvl(l_inv_subinventory_name, fnd_api.g_miss_char))
532: AND
533: (nvl(p_instance_rec.inventory_revision, fnd_api.g_miss_char) =
534: nvl(l_inventory_revision, fnd_api.g_miss_char))
535: AND
536: (nvl(p_instance_rec.inv_locator_id, fnd_api.g_miss_num) =
537: nvl(l_inv_locator_id, fnd_api.g_miss_num))

Line 534: nvl(l_inventory_revision, fnd_api.g_miss_char))

530: (nvl(p_instance_rec.inv_subinventory_name, fnd_api.g_miss_char) =
531: nvl(l_inv_subinventory_name, fnd_api.g_miss_char))
532: AND
533: (nvl(p_instance_rec.inventory_revision, fnd_api.g_miss_char) =
534: nvl(l_inventory_revision, fnd_api.g_miss_char))
535: AND
536: (nvl(p_instance_rec.inv_locator_id, fnd_api.g_miss_num) =
537: nvl(l_inv_locator_id, fnd_api.g_miss_num))
538: AND

Line 536: (nvl(p_instance_rec.inv_locator_id, fnd_api.g_miss_num) =

532: AND
533: (nvl(p_instance_rec.inventory_revision, fnd_api.g_miss_char) =
534: nvl(l_inventory_revision, fnd_api.g_miss_char))
535: AND
536: (nvl(p_instance_rec.inv_locator_id, fnd_api.g_miss_num) =
537: nvl(l_inv_locator_id, fnd_api.g_miss_num))
538: AND
539: (nvl(p_instance_rec.location_type_code, fnd_api.g_miss_char) =
540: nvl(l_location_type_code, fnd_api.g_miss_char))

Line 537: nvl(l_inv_locator_id, fnd_api.g_miss_num))

533: (nvl(p_instance_rec.inventory_revision, fnd_api.g_miss_char) =
534: nvl(l_inventory_revision, fnd_api.g_miss_char))
535: AND
536: (nvl(p_instance_rec.inv_locator_id, fnd_api.g_miss_num) =
537: nvl(l_inv_locator_id, fnd_api.g_miss_num))
538: AND
539: (nvl(p_instance_rec.location_type_code, fnd_api.g_miss_char) =
540: nvl(l_location_type_code, fnd_api.g_miss_char))
541: AND

Line 539: (nvl(p_instance_rec.location_type_code, fnd_api.g_miss_char) =

535: AND
536: (nvl(p_instance_rec.inv_locator_id, fnd_api.g_miss_num) =
537: nvl(l_inv_locator_id, fnd_api.g_miss_num))
538: AND
539: (nvl(p_instance_rec.location_type_code, fnd_api.g_miss_char) =
540: nvl(l_location_type_code, fnd_api.g_miss_char))
541: AND
542: (nvl(p_instance_rec.instance_usage_code, fnd_api.g_miss_char) =
543: nvl(l_instance_usage_code, fnd_api.g_miss_char))

Line 540: nvl(l_location_type_code, fnd_api.g_miss_char))

536: (nvl(p_instance_rec.inv_locator_id, fnd_api.g_miss_num) =
537: nvl(l_inv_locator_id, fnd_api.g_miss_num))
538: AND
539: (nvl(p_instance_rec.location_type_code, fnd_api.g_miss_char) =
540: nvl(l_location_type_code, fnd_api.g_miss_char))
541: AND
542: (nvl(p_instance_rec.instance_usage_code, fnd_api.g_miss_char) =
543: nvl(l_instance_usage_code, fnd_api.g_miss_char))
544: AND

Line 542: (nvl(p_instance_rec.instance_usage_code, fnd_api.g_miss_char) =

538: AND
539: (nvl(p_instance_rec.location_type_code, fnd_api.g_miss_char) =
540: nvl(l_location_type_code, fnd_api.g_miss_char))
541: AND
542: (nvl(p_instance_rec.instance_usage_code, fnd_api.g_miss_char) =
543: nvl(l_instance_usage_code, fnd_api.g_miss_char))
544: AND
545: (nvl(p_instance_rec.lot_number, fnd_api.g_miss_char) =
546: nvl(l_lot_number, fnd_api.g_miss_char))

Line 543: nvl(l_instance_usage_code, fnd_api.g_miss_char))

539: (nvl(p_instance_rec.location_type_code, fnd_api.g_miss_char) =
540: nvl(l_location_type_code, fnd_api.g_miss_char))
541: AND
542: (nvl(p_instance_rec.instance_usage_code, fnd_api.g_miss_char) =
543: nvl(l_instance_usage_code, fnd_api.g_miss_char))
544: AND
545: (nvl(p_instance_rec.lot_number, fnd_api.g_miss_char) =
546: nvl(l_lot_number, fnd_api.g_miss_char))
547: THEN

Line 545: (nvl(p_instance_rec.lot_number, fnd_api.g_miss_char) =

541: AND
542: (nvl(p_instance_rec.instance_usage_code, fnd_api.g_miss_char) =
543: nvl(l_instance_usage_code, fnd_api.g_miss_char))
544: AND
545: (nvl(p_instance_rec.lot_number, fnd_api.g_miss_char) =
546: nvl(l_lot_number, fnd_api.g_miss_char))
547: THEN
548: l_not_the_same := FALSE;
549:

Line 546: nvl(l_lot_number, fnd_api.g_miss_char))

542: (nvl(p_instance_rec.instance_usage_code, fnd_api.g_miss_char) =
543: nvl(l_instance_usage_code, fnd_api.g_miss_char))
544: AND
545: (nvl(p_instance_rec.lot_number, fnd_api.g_miss_char) =
546: nvl(l_lot_number, fnd_api.g_miss_char))
547: THEN
548: l_not_the_same := FALSE;
549:
550: --debug('IB and INV attributes for ser. item are not same');

Line 711: l_instance_rec.instance_id := fnd_api.g_miss_num;

707: LOOP
708:
709: BEGIN
710:
711: l_instance_rec.instance_id := fnd_api.g_miss_num;
712: l_instance_rec.inventory_item_id := srl_rec.inventory_item_id;
713: l_instance_rec.serial_number := srl_rec.serial_number;
714: l_instance_rec.lot_number := srl_rec.lot_number;
715: l_instance_rec.mfg_serial_number_flag := 'Y';

Line 1297: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

1293: l_request_id NUMBER;
1294:
1295: l_schema_name varchar2(30);
1296: l_object_name varchar2(80);
1297: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1298:
1299: BEGIN
1300: --
1301: -- Empty the discrepancy table before each run

Line 1308: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1304: p_product_short_name => 'CSI',
1305: x_schema_name => l_schema_name,
1306: x_return_status => l_return_status);
1307:
1308: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1309: RAISE fnd_api.g_exc_error;
1310: END IF;
1311:
1312: l_object_name := l_schema_name||'.csi_inv_discrepancy_temp';

Line 1309: RAISE fnd_api.g_exc_error;

1305: x_schema_name => l_schema_name,
1306: x_return_status => l_return_status);
1307:
1308: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1309: RAISE fnd_api.g_exc_error;
1310: END IF;
1311:
1312: l_object_name := l_schema_name||'.csi_inv_discrepancy_temp';
1313: