DBA Data[Home] [Help]

APPS.CSI_ORDER_SHIP_PUB dependencies on CSI_ITEM_INSTANCE_PUB

Line 1574: p_pkg_name => 'csi_item_instance_pub',

1570: END IF;
1571: --code modification end for 3681856--
1572:
1573: csi_t_gen_utility_pvt.dump_api_info(
1574: p_pkg_name => 'csi_item_instance_pub',
1575: p_api_name => 'update_item_instance');
1576:
1577: csi_t_gen_utility_pvt.dump_csi_instance_rec(
1578: p_csi_instance_rec => l_ns_instance_rec);

Line 1581: csi_item_instance_pub.update_item_instance(

1577: csi_t_gen_utility_pvt.dump_csi_instance_rec(
1578: p_csi_instance_rec => l_ns_instance_rec);
1579:
1580: /* non source status update call. */
1581: csi_item_instance_pub.update_item_instance(
1582: p_api_version => 1.0,
1583: p_commit => fnd_api.g_false,
1584: p_init_msg_list => fnd_api.g_true,
1585: p_validation_level => fnd_api.g_valid_level_full,

Line 1624: p_pkg_name => 'csi_item_instance_pub');

1620: l_trx_rec.transaction_id := fnd_api.g_miss_num;
1621:
1622: csi_t_gen_utility_pvt.dump_api_info(
1623: p_api_name => 'expire_item_instance',
1624: p_pkg_name => 'csi_item_instance_pub');
1625:
1626: csi_item_instance_pub.expire_item_instance(
1627: p_api_version => 1.0,
1628: p_commit => fnd_api.g_false,

Line 1626: csi_item_instance_pub.expire_item_instance(

1622: csi_t_gen_utility_pvt.dump_api_info(
1623: p_api_name => 'expire_item_instance',
1624: p_pkg_name => 'csi_item_instance_pub');
1625:
1626: csi_item_instance_pub.expire_item_instance(
1627: p_api_version => 1.0,
1628: p_commit => fnd_api.g_false,
1629: p_init_msg_list => fnd_api.g_true,
1630: p_validation_level => fnd_api.g_valid_level_full,

Line 1640: g_api_name := 'csi_item_instance_pub.expire_item_instance';

1636: x_msg_count => l_msg_count,
1637: x_msg_data => l_msg_data);
1638:
1639: IF NOT(l_return_status = fnd_api.g_ret_sts_success) THEN
1640: g_api_name := 'csi_item_instance_pub.expire_item_instance';
1641: raise fnd_api.g_exc_error;
1642: END IF;
1643: END IF;
1644:

Line 2094: p_pkg_name => 'csi_item_instance_pub',

2090: debug('serial_number :'||l_inst_query_rec.serial_number);
2091: debug('----------------------------------------------------' );
2092:
2093: csi_t_gen_utility_pvt.dump_api_info(
2094: p_pkg_name => 'csi_item_instance_pub',
2095: p_api_name => 'get_item_instances');
2096:
2097: -- As part of fix for Bug 2985193 this call even brings the expired Inv. Instances.
2098: -- To achieve this p_active_instances_only should have a value of false.

Line 2107: csi_item_instance_pub.get_item_instances(

2103: ELSE
2104: l_active_instances_only := fnd_api.g_true;
2105: END IF;
2106:
2107: csi_item_instance_pub.get_item_instances(
2108: p_api_version => 1.0,
2109: p_commit => fnd_api.g_false,
2110: p_init_msg_list => fnd_api.g_true,
2111: p_validation_level => fnd_api.g_valid_level_full,

Line 2182: p_pkg_name => 'csi_item_instance_pub');

2178:
2179: debug('Creating an inventory instance in the staging area for non reservable item.');
2180: csi_t_gen_utility_pvt.dump_api_info(
2181: p_api_name => 'create_item_instance',
2182: p_pkg_name => 'csi_item_instance_pub');
2183:
2184: /* Creation of instance with the Shippable Quantity for Negative Quantities */
2185:
2186: debug('Creating an instance with quantity 1 for Non-Reservable Item');

Line 2187: csi_item_instance_pub.create_item_instance(

2183:
2184: /* Creation of instance with the Shippable Quantity for Negative Quantities */
2185:
2186: debug('Creating an instance with quantity 1 for Non-Reservable Item');
2187: csi_item_instance_pub.create_item_instance(
2188: p_api_version => 1.0,
2189: p_commit => fnd_api.g_false,
2190: p_init_msg_list => fnd_api.g_true,
2191: p_validation_level => fnd_api.g_valid_level_full,

Line 2207: g_api_name := 'csi_item_instance_pub.create_item_instance';

2203:
2204: -- For Bug 4057183
2205: -- IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
2206: IF NOT(x_return_status in (fnd_api.g_ret_sts_success,'W')) THEN
2207: g_api_name := 'csi_item_instance_pub.create_item_instance';
2208: raise fnd_api.g_exc_error;
2209: END IF;
2210:
2211: l_zero_instance_rec.instance_id := l_cre_instance_rec.instance_id;

Line 2225: p_pkg_name => 'csi_item_instance_pub',

2221:
2222: debug('Updating Created Instance to zero Quantity');
2223:
2224: csi_t_gen_utility_pvt.dump_api_info(
2225: p_pkg_name => 'csi_item_instance_pub',
2226: p_api_name => 'update_item_instance');
2227:
2228: csi_item_instance_pub.update_item_instance(
2229: p_api_version => 1.0,

Line 2228: csi_item_instance_pub.update_item_instance(

2224: csi_t_gen_utility_pvt.dump_api_info(
2225: p_pkg_name => 'csi_item_instance_pub',
2226: p_api_name => 'update_item_instance');
2227:
2228: csi_item_instance_pub.update_item_instance(
2229: p_api_version => 1.0,
2230: p_commit => fnd_api.g_false,
2231: p_init_msg_list => fnd_api.g_true,
2232: p_validation_level => fnd_api.g_valid_level_full,

Line 3845: p_pkg_name => 'csi_item_instance_pub');

3841: WHERE instance_id = l_instance_rec.instance_id;
3842:
3843: csi_t_gen_utility_pvt.dump_api_info(
3844: p_api_name => 'update_item_instance',
3845: p_pkg_name => 'csi_item_instance_pub');
3846:
3847: csi_t_gen_utility_pvt.dump_csi_instance_rec(
3848: p_csi_instance_rec => l_instance_rec);
3849:

Line 3852: csi_item_instance_pub.update_item_instance(

3848: p_csi_instance_rec => l_instance_rec);
3849:
3850: /* decrement the inventory source instance */
3851:
3852: csi_item_instance_pub.update_item_instance(
3853: p_api_version => 1.0,
3854: p_commit => fnd_api.g_false,
3855: p_init_msg_list => fnd_api.g_true,
3856: p_validation_level => fnd_api.g_valid_level_full,

Line 3873: g_api_name := 'csi_item_instance_pub.update_item_instance';

3869:
3870: -- For Bug 4057183
3871: -- IF l_return_status <> fnd_api.g_ret_sts_success THEN
3872: IF l_return_status not in (fnd_api.g_ret_sts_success,'W') THEN
3873: g_api_name := 'csi_item_instance_pub.update_item_instance';
3874: raise fnd_api.g_exc_error;
3875: END IF;
3876:
3877: EXCEPTION

Line 4017: csi_item_instance_pub.get_item_instance_details(

4013:
4014: l_g_instance_rec.instance_id := p_instance_id;
4015:
4016: -- get the instance party and party account info
4017: csi_item_instance_pub.get_item_instance_details(
4018: p_api_version => 1.0,
4019: p_commit => fnd_api.g_false,
4020: p_init_msg_list => fnd_api.g_true,
4021: p_validation_level => fnd_api.g_valid_level_full,

Line 4123: csi_item_instance_pub.create_item_instance(

4119: END IF;
4120:
4121: -- create a new instance for the decremented qty
4122:
4123: csi_item_instance_pub.create_item_instance(
4124: p_api_version => 1.0,
4125: p_commit => fnd_api.g_false,
4126: p_init_msg_list => fnd_api.g_true,
4127: p_validation_level => fnd_api.g_valid_level_full,

Line 4161: csi_item_instance_pub.update_item_instance(

4157: INTO l_u_instance_rec.object_version_number
4158: FROM csi_item_instances
4159: WHERE instance_id = l_u_instance_rec.instance_id;
4160:
4161: csi_item_instance_pub.update_item_instance(
4162: p_api_version => 1.0,
4163: p_commit => fnd_api.g_false,
4164: p_init_msg_list => fnd_api.g_true,
4165: p_validation_level => fnd_api.g_valid_level_full,

Line 4365: p_pkg_name => 'csi_item_instance_pub');

4361: l_u_party_acct_tbl(1).parent_tbl_index := 1;
4362:
4363: csi_t_gen_utility_pvt.dump_api_info(
4364: p_api_name => 'update_item_instance',
4365: p_pkg_name => 'csi_item_instance_pub');
4366:
4367: csi_item_instance_pub.update_item_instance(
4368: p_api_version => 1.0,
4369: p_commit => fnd_api.g_false,

Line 4367: csi_item_instance_pub.update_item_instance(

4363: csi_t_gen_utility_pvt.dump_api_info(
4364: p_api_name => 'update_item_instance',
4365: p_pkg_name => 'csi_item_instance_pub');
4366:
4367: csi_item_instance_pub.update_item_instance(
4368: p_api_version => 1.0,
4369: p_commit => fnd_api.g_false,
4370: p_init_msg_list => fnd_api.g_true,
4371: p_validation_level => fnd_api.g_valid_level_full,

Line 5843: p_pkg_name => 'csi_item_instance_pub',

5839: l_un_exp_instance_rec.active_end_date := null;
5840: l_un_exp_instance_rec.object_version_number := l_inst_obj_ver_num;
5841:
5842: csi_t_gen_utility_pvt.dump_api_info(
5843: p_pkg_name => 'csi_item_instance_pub',
5844: p_api_name => 'update_item_instance');
5845:
5846: csi_item_instance_pub.update_item_instance(
5847: p_api_version => 1.0,

Line 5846: csi_item_instance_pub.update_item_instance(

5842: csi_t_gen_utility_pvt.dump_api_info(
5843: p_pkg_name => 'csi_item_instance_pub',
5844: p_api_name => 'update_item_instance');
5845:
5846: csi_item_instance_pub.update_item_instance(
5847: p_api_version => 1.0,
5848: p_commit => fnd_api.g_false,
5849: p_init_msg_list => fnd_api.g_true,
5850: p_validation_level => fnd_api.g_valid_level_full,

Line 6192: p_pkg_name => 'csi_item_instance_pub',

6188:
6189: debug('change owner to internal to terminate contracts.');
6190:
6191: csi_t_gen_utility_pvt.dump_api_info(
6192: p_pkg_name => 'csi_item_instance_pub',
6193: p_api_name => 'update_item_instance');
6194:
6195: -- owner change to internal
6196: csi_item_instance_pub.update_item_instance(

Line 6196: csi_item_instance_pub.update_item_instance(

6192: p_pkg_name => 'csi_item_instance_pub',
6193: p_api_name => 'update_item_instance');
6194:
6195: -- owner change to internal
6196: csi_item_instance_pub.update_item_instance(
6197: p_api_version => 1.0,
6198: p_commit => fnd_api.g_false,
6199: p_init_msg_list => fnd_api.g_true,
6200: p_validation_level => fnd_api.g_valid_level_full,

Line 6325: p_pkg_name => 'csi_item_instance_pub');

6321: END IF;
6322:
6323: csi_t_gen_utility_pvt.dump_api_info(
6324: p_api_name => 'update_item_instance',
6325: p_pkg_name => 'csi_item_instance_pub');
6326:
6327: debug('Converting the instance into a customer product....!');
6328:
6329: /* this is the call that makes the instance as customer product */

Line 6330: csi_item_instance_pub.update_item_instance(

6326:
6327: debug('Converting the instance into a customer product....!');
6328:
6329: /* this is the call that makes the instance as customer product */
6330: csi_item_instance_pub.update_item_instance(
6331: p_api_version => 1.0,
6332: p_commit => fnd_api.g_false,
6333: p_init_msg_list => fnd_api.g_true,
6334: p_validation_level => fnd_api.g_valid_level_full,

Line 6351: g_api_name := 'csi_item_instance_pub.update_item_instance';

6347:
6348: -- For Bug 4057183
6349: -- IF l_return_status <> fnd_api.g_ret_sts_success THEN
6350: IF l_return_status not in (fnd_api.g_ret_sts_success,'W') THEN
6351: g_api_name := 'csi_item_instance_pub.update_item_instance';
6352: raise fnd_api.g_exc_error;
6353: END IF;
6354:
6355: IF l_expire_flag THEN

Line 6364: p_pkg_name => 'csi_item_instance_pub');

6360: l_trx_rec.transaction_id := fnd_api.g_miss_num;
6361:
6362: csi_t_gen_utility_pvt.dump_api_info(
6363: p_api_name => 'expire_item_instance',
6364: p_pkg_name => 'csi_item_instance_pub');
6365:
6366: csi_item_instance_pub.expire_item_instance(
6367: p_api_version => 1.0,
6368: p_commit => fnd_api.g_false,

Line 6366: csi_item_instance_pub.expire_item_instance(

6362: csi_t_gen_utility_pvt.dump_api_info(
6363: p_api_name => 'expire_item_instance',
6364: p_pkg_name => 'csi_item_instance_pub');
6365:
6366: csi_item_instance_pub.expire_item_instance(
6367: p_api_version => 1.0,
6368: p_commit => fnd_api.g_false,
6369: p_init_msg_list => fnd_api.g_true,
6370: p_validation_level => fnd_api.g_valid_level_full,

Line 6380: g_api_name := 'csi_item_instance_pub.expire_item_instance';

6376: x_msg_count => x_msg_count,
6377: x_msg_data => x_msg_data);
6378:
6379: IF NOT(l_return_status = fnd_api.g_ret_sts_success) THEN
6380: g_api_name := 'csi_item_instance_pub.expire_item_instance';
6381: raise fnd_api.g_exc_error;
6382: END IF;
6383:
6384: END IF;

Line 6593: p_pkg_name => 'csi_item_instance_pub');

6589: debug('Update Extended_Attributes Count '||l_old_extended_attribs_tbl.count);
6590:
6591: csi_t_gen_utility_pvt.dump_api_info(
6592: p_api_name => 'update_extended_attrib_values',
6593: p_pkg_name => 'csi_item_instance_pub');
6594:
6595: csi_item_instance_pub.update_extended_attrib_values(
6596: p_api_version => 1.0,
6597: p_commit => fnd_api.g_false,

Line 6595: csi_item_instance_pub.update_extended_attrib_values(

6591: csi_t_gen_utility_pvt.dump_api_info(
6592: p_api_name => 'update_extended_attrib_values',
6593: p_pkg_name => 'csi_item_instance_pub');
6594:
6595: csi_item_instance_pub.update_extended_attrib_values(
6596: p_api_version => 1.0,
6597: p_commit => fnd_api.g_false,
6598: p_init_msg_list => fnd_api.g_true,
6599: p_validation_level => fnd_api.g_valid_level_full,

Line 6607: g_api_name := 'csi_item_instance_pub.update_extended_attrib_values';

6603: x_msg_count => x_msg_count,
6604: x_msg_data => x_msg_data);
6605:
6606: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
6607: g_api_name := 'csi_item_instance_pub.update_extended_attrib_values';
6608: raise fnd_api.g_exc_error;
6609: END IF;
6610:
6611: debug('Extended Attributed updated successfully.');

Line 6622: p_pkg_name => 'csi_item_instance_pub');

6618: -- END MRK CODE FOR UPDATE EXTENDED ATTRIBUTE
6619:
6620: csi_t_gen_utility_pvt.dump_api_info(
6621: p_api_name => 'create_extended_attrib_values',
6622: p_pkg_name => 'csi_item_instance_pub');
6623:
6624: csi_item_instance_pub.create_extended_attrib_values(
6625: p_api_version => 1.0,
6626: p_commit => fnd_api.g_false,

Line 6624: csi_item_instance_pub.create_extended_attrib_values(

6620: csi_t_gen_utility_pvt.dump_api_info(
6621: p_api_name => 'create_extended_attrib_values',
6622: p_pkg_name => 'csi_item_instance_pub');
6623:
6624: csi_item_instance_pub.create_extended_attrib_values(
6625: p_api_version => 1.0,
6626: p_commit => fnd_api.g_false,
6627: p_init_msg_list => fnd_api.g_true,
6628: p_validation_level => fnd_api.g_valid_level_full,

Line 6636: g_api_name := 'csi_item_instance_pub.create_extended_attrib_values';

6632: x_msg_count => x_msg_count,
6633: x_msg_data => x_msg_data);
6634:
6635: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
6636: g_api_name := 'csi_item_instance_pub.create_extended_attrib_values';
6637: raise fnd_api.g_exc_error;
6638: END IF;
6639:
6640: debug('Extended Attributed created successfully.');

Line 6990: p_pkg_name => 'csi_item_instance_pub');

6986: debug(' ext_attrib_val_tbl.count :'||l_cre_ext_attrib_val_tbl.count);
6987:
6988: csi_t_gen_utility_pvt.dump_api_info(
6989: p_api_name => 'create_item_instance',
6990: p_pkg_name => 'csi_item_instance_pub');
6991:
6992: IF l_debug_level > 1 THEN
6993: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_cre_instance_rec);
6994: END IF;

Line 6997: csi_item_instance_pub.create_item_instance(

6993: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_cre_instance_rec);
6994: END IF;
6995:
6996: /* for order fulfillment instance ref is not there so create an instance */
6997: csi_item_instance_pub.create_item_instance(
6998: p_api_version => 1.0,
6999: p_commit => fnd_api.g_false,
7000: p_init_msg_list => fnd_api.g_true,
7001: p_validation_level => fnd_api.g_valid_level_full,

Line 7017: g_api_name := 'csi_item_instance_pub.create_item_instance';

7013:
7014: -- For Bug 4057183
7015: -- IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
7016: IF NOT(x_return_status in(fnd_api.g_ret_sts_success,'W')) THEN
7017: g_api_name := 'csi_item_instance_pub.create_item_instance';
7018: raise fnd_api.g_exc_error;
7019: END IF;
7020:
7021: l_cp_ind := l_cp_ind + 1;