DBA Data[Home] [Help]

APPS.CSI_ORDER_SHIP_PUB dependencies on CSI_ITEM_INSTANCE_PUB

Line 1517: p_pkg_name => 'csi_item_instance_pub',

1513: END IF;
1514: --code modification end for 3681856--
1515:
1516: csi_t_gen_utility_pvt.dump_api_info(
1517: p_pkg_name => 'csi_item_instance_pub',
1518: p_api_name => 'update_item_instance');
1519:
1520: csi_t_gen_utility_pvt.dump_csi_instance_rec(
1521: p_csi_instance_rec => l_ns_instance_rec);

Line 1524: csi_item_instance_pub.update_item_instance(

1520: csi_t_gen_utility_pvt.dump_csi_instance_rec(
1521: p_csi_instance_rec => l_ns_instance_rec);
1522:
1523: /* non source status update call. */
1524: csi_item_instance_pub.update_item_instance(
1525: p_api_version => 1.0,
1526: p_commit => fnd_api.g_false,
1527: p_init_msg_list => fnd_api.g_true,
1528: p_validation_level => fnd_api.g_valid_level_full,

Line 1567: p_pkg_name => 'csi_item_instance_pub');

1563: l_trx_rec.transaction_id := fnd_api.g_miss_num;
1564:
1565: csi_t_gen_utility_pvt.dump_api_info(
1566: p_api_name => 'expire_item_instance',
1567: p_pkg_name => 'csi_item_instance_pub');
1568:
1569: csi_item_instance_pub.expire_item_instance(
1570: p_api_version => 1.0,
1571: p_commit => fnd_api.g_false,

Line 1569: csi_item_instance_pub.expire_item_instance(

1565: csi_t_gen_utility_pvt.dump_api_info(
1566: p_api_name => 'expire_item_instance',
1567: p_pkg_name => 'csi_item_instance_pub');
1568:
1569: csi_item_instance_pub.expire_item_instance(
1570: p_api_version => 1.0,
1571: p_commit => fnd_api.g_false,
1572: p_init_msg_list => fnd_api.g_true,
1573: p_validation_level => fnd_api.g_valid_level_full,

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

1579: x_msg_count => l_msg_count,
1580: x_msg_data => l_msg_data);
1581:
1582: IF NOT(l_return_status = fnd_api.g_ret_sts_success) THEN
1583: g_api_name := 'csi_item_instance_pub.expire_item_instance';
1584: raise fnd_api.g_exc_error;
1585: END IF;
1586: END IF;
1587:

Line 2035: p_pkg_name => 'csi_item_instance_pub',

2031: debug('serial_number :'||l_inst_query_rec.serial_number);
2032: debug('----------------------------------------------------' );
2033:
2034: csi_t_gen_utility_pvt.dump_api_info(
2035: p_pkg_name => 'csi_item_instance_pub',
2036: p_api_name => 'get_item_instances');
2037:
2038: -- As part of fix for Bug 2985193 this call even brings the expired Inv. Instances.
2039: -- To achieve this p_active_instances_only should have a value of false.

Line 2048: csi_item_instance_pub.get_item_instances(

2044: ELSE
2045: l_active_instances_only := fnd_api.g_true;
2046: END IF;
2047:
2048: csi_item_instance_pub.get_item_instances(
2049: p_api_version => 1.0,
2050: p_commit => fnd_api.g_false,
2051: p_init_msg_list => fnd_api.g_true,
2052: p_validation_level => fnd_api.g_valid_level_full,

Line 2123: p_pkg_name => 'csi_item_instance_pub');

2119:
2120: debug('Creating an inventory instance in the staging area for non reservable item.');
2121: csi_t_gen_utility_pvt.dump_api_info(
2122: p_api_name => 'create_item_instance',
2123: p_pkg_name => 'csi_item_instance_pub');
2124:
2125: /* Creation of instance with the Shippable Quantity for Negative Quantities */
2126:
2127: debug('Creating an instance with quantity 1 for Non-Reservable Item');

Line 2128: csi_item_instance_pub.create_item_instance(

2124:
2125: /* Creation of instance with the Shippable Quantity for Negative Quantities */
2126:
2127: debug('Creating an instance with quantity 1 for Non-Reservable Item');
2128: csi_item_instance_pub.create_item_instance(
2129: p_api_version => 1.0,
2130: p_commit => fnd_api.g_false,
2131: p_init_msg_list => fnd_api.g_true,
2132: p_validation_level => fnd_api.g_valid_level_full,

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

2144:
2145: -- For Bug 4057183
2146: -- IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
2147: IF NOT(x_return_status in (fnd_api.g_ret_sts_success,'W')) THEN
2148: g_api_name := 'csi_item_instance_pub.create_item_instance';
2149: raise fnd_api.g_exc_error;
2150: END IF;
2151:
2152: l_zero_instance_rec.instance_id := l_cre_instance_rec.instance_id;

Line 2166: p_pkg_name => 'csi_item_instance_pub',

2162:
2163: debug('Updating Created Instance to zero Quantity');
2164:
2165: csi_t_gen_utility_pvt.dump_api_info(
2166: p_pkg_name => 'csi_item_instance_pub',
2167: p_api_name => 'update_item_instance');
2168:
2169: csi_item_instance_pub.update_item_instance(
2170: p_api_version => 1.0,

Line 2169: csi_item_instance_pub.update_item_instance(

2165: csi_t_gen_utility_pvt.dump_api_info(
2166: p_pkg_name => 'csi_item_instance_pub',
2167: p_api_name => 'update_item_instance');
2168:
2169: csi_item_instance_pub.update_item_instance(
2170: p_api_version => 1.0,
2171: p_commit => fnd_api.g_false,
2172: p_init_msg_list => fnd_api.g_true,
2173: p_validation_level => fnd_api.g_valid_level_full,

Line 3766: p_pkg_name => 'csi_item_instance_pub');

3762: WHERE instance_id = l_instance_rec.instance_id;
3763:
3764: csi_t_gen_utility_pvt.dump_api_info(
3765: p_api_name => 'update_item_instance',
3766: p_pkg_name => 'csi_item_instance_pub');
3767:
3768: csi_t_gen_utility_pvt.dump_csi_instance_rec(
3769: p_csi_instance_rec => l_instance_rec);
3770:

Line 3773: csi_item_instance_pub.update_item_instance(

3769: p_csi_instance_rec => l_instance_rec);
3770:
3771: /* decrement the inventory source instance */
3772:
3773: csi_item_instance_pub.update_item_instance(
3774: p_api_version => 1.0,
3775: p_commit => fnd_api.g_false,
3776: p_init_msg_list => fnd_api.g_true,
3777: p_validation_level => fnd_api.g_valid_level_full,

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

3790:
3791: -- For Bug 4057183
3792: -- IF l_return_status <> fnd_api.g_ret_sts_success THEN
3793: IF l_return_status not in (fnd_api.g_ret_sts_success,'W') THEN
3794: g_api_name := 'csi_item_instance_pub.update_item_instance';
3795: raise fnd_api.g_exc_error;
3796: END IF;
3797:
3798: EXCEPTION

Line 3938: csi_item_instance_pub.get_item_instance_details(

3934:
3935: l_g_instance_rec.instance_id := p_instance_id;
3936:
3937: -- get the instance party and party account info
3938: csi_item_instance_pub.get_item_instance_details(
3939: p_api_version => 1.0,
3940: p_commit => fnd_api.g_false,
3941: p_init_msg_list => fnd_api.g_true,
3942: p_validation_level => fnd_api.g_valid_level_full,

Line 4044: csi_item_instance_pub.create_item_instance(

4040: END IF;
4041:
4042: -- create a new instance for the decremented qty
4043:
4044: csi_item_instance_pub.create_item_instance(
4045: p_api_version => 1.0,
4046: p_commit => fnd_api.g_false,
4047: p_init_msg_list => fnd_api.g_true,
4048: p_validation_level => fnd_api.g_valid_level_full,

Line 4082: csi_item_instance_pub.update_item_instance(

4078: INTO l_u_instance_rec.object_version_number
4079: FROM csi_item_instances
4080: WHERE instance_id = l_u_instance_rec.instance_id;
4081:
4082: csi_item_instance_pub.update_item_instance(
4083: p_api_version => 1.0,
4084: p_commit => fnd_api.g_false,
4085: p_init_msg_list => fnd_api.g_true,
4086: p_validation_level => fnd_api.g_valid_level_full,

Line 4286: p_pkg_name => 'csi_item_instance_pub');

4282: l_u_party_acct_tbl(1).parent_tbl_index := 1;
4283:
4284: csi_t_gen_utility_pvt.dump_api_info(
4285: p_api_name => 'update_item_instance',
4286: p_pkg_name => 'csi_item_instance_pub');
4287:
4288: csi_item_instance_pub.update_item_instance(
4289: p_api_version => 1.0,
4290: p_commit => fnd_api.g_false,

Line 4288: csi_item_instance_pub.update_item_instance(

4284: csi_t_gen_utility_pvt.dump_api_info(
4285: p_api_name => 'update_item_instance',
4286: p_pkg_name => 'csi_item_instance_pub');
4287:
4288: csi_item_instance_pub.update_item_instance(
4289: p_api_version => 1.0,
4290: p_commit => fnd_api.g_false,
4291: p_init_msg_list => fnd_api.g_true,
4292: p_validation_level => fnd_api.g_valid_level_full,

Line 5586: p_pkg_name => 'csi_item_instance_pub',

5582: l_un_exp_instance_rec.active_end_date := null;
5583: l_un_exp_instance_rec.object_version_number := l_inst_obj_ver_num;
5584:
5585: csi_t_gen_utility_pvt.dump_api_info(
5586: p_pkg_name => 'csi_item_instance_pub',
5587: p_api_name => 'update_item_instance');
5588:
5589: csi_item_instance_pub.update_item_instance(
5590: p_api_version => 1.0,

Line 5589: csi_item_instance_pub.update_item_instance(

5585: csi_t_gen_utility_pvt.dump_api_info(
5586: p_pkg_name => 'csi_item_instance_pub',
5587: p_api_name => 'update_item_instance');
5588:
5589: csi_item_instance_pub.update_item_instance(
5590: p_api_version => 1.0,
5591: p_commit => fnd_api.g_false,
5592: p_init_msg_list => fnd_api.g_true,
5593: p_validation_level => fnd_api.g_valid_level_full,

Line 5932: p_pkg_name => 'csi_item_instance_pub',

5928:
5929: debug('change owner to internal to terminate contracts.');
5930:
5931: csi_t_gen_utility_pvt.dump_api_info(
5932: p_pkg_name => 'csi_item_instance_pub',
5933: p_api_name => 'update_item_instance');
5934:
5935: -- owner change to internal
5936: csi_item_instance_pub.update_item_instance(

Line 5936: csi_item_instance_pub.update_item_instance(

5932: p_pkg_name => 'csi_item_instance_pub',
5933: p_api_name => 'update_item_instance');
5934:
5935: -- owner change to internal
5936: csi_item_instance_pub.update_item_instance(
5937: p_api_version => 1.0,
5938: p_commit => fnd_api.g_false,
5939: p_init_msg_list => fnd_api.g_true,
5940: p_validation_level => fnd_api.g_valid_level_full,

Line 6065: p_pkg_name => 'csi_item_instance_pub');

6061: END IF;
6062:
6063: csi_t_gen_utility_pvt.dump_api_info(
6064: p_api_name => 'update_item_instance',
6065: p_pkg_name => 'csi_item_instance_pub');
6066:
6067: debug('Converting the instance into a customer product....!');
6068:
6069: /* this is the call that makes the instance as customer product */

Line 6070: csi_item_instance_pub.update_item_instance(

6066:
6067: debug('Converting the instance into a customer product....!');
6068:
6069: /* this is the call that makes the instance as customer product */
6070: csi_item_instance_pub.update_item_instance(
6071: p_api_version => 1.0,
6072: p_commit => fnd_api.g_false,
6073: p_init_msg_list => fnd_api.g_true,
6074: p_validation_level => fnd_api.g_valid_level_full,

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

6087:
6088: -- For Bug 4057183
6089: -- IF l_return_status <> fnd_api.g_ret_sts_success THEN
6090: IF l_return_status not in (fnd_api.g_ret_sts_success,'W') THEN
6091: g_api_name := 'csi_item_instance_pub.update_item_instance';
6092: raise fnd_api.g_exc_error;
6093: END IF;
6094:
6095: IF l_expire_flag THEN

Line 6104: p_pkg_name => 'csi_item_instance_pub');

6100: l_trx_rec.transaction_id := fnd_api.g_miss_num;
6101:
6102: csi_t_gen_utility_pvt.dump_api_info(
6103: p_api_name => 'expire_item_instance',
6104: p_pkg_name => 'csi_item_instance_pub');
6105:
6106: csi_item_instance_pub.expire_item_instance(
6107: p_api_version => 1.0,
6108: p_commit => fnd_api.g_false,

Line 6106: csi_item_instance_pub.expire_item_instance(

6102: csi_t_gen_utility_pvt.dump_api_info(
6103: p_api_name => 'expire_item_instance',
6104: p_pkg_name => 'csi_item_instance_pub');
6105:
6106: csi_item_instance_pub.expire_item_instance(
6107: p_api_version => 1.0,
6108: p_commit => fnd_api.g_false,
6109: p_init_msg_list => fnd_api.g_true,
6110: p_validation_level => fnd_api.g_valid_level_full,

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

6116: x_msg_count => x_msg_count,
6117: x_msg_data => x_msg_data);
6118:
6119: IF NOT(l_return_status = fnd_api.g_ret_sts_success) THEN
6120: g_api_name := 'csi_item_instance_pub.expire_item_instance';
6121: raise fnd_api.g_exc_error;
6122: END IF;
6123:
6124: END IF;

Line 6331: p_pkg_name => 'csi_item_instance_pub');

6327: debug('Update Extended_Attributes Count '||l_old_extended_attribs_tbl.count);
6328:
6329: csi_t_gen_utility_pvt.dump_api_info(
6330: p_api_name => 'update_extended_attrib_values',
6331: p_pkg_name => 'csi_item_instance_pub');
6332:
6333: csi_item_instance_pub.update_extended_attrib_values(
6334: p_api_version => 1.0,
6335: p_commit => fnd_api.g_false,

Line 6333: csi_item_instance_pub.update_extended_attrib_values(

6329: csi_t_gen_utility_pvt.dump_api_info(
6330: p_api_name => 'update_extended_attrib_values',
6331: p_pkg_name => 'csi_item_instance_pub');
6332:
6333: csi_item_instance_pub.update_extended_attrib_values(
6334: p_api_version => 1.0,
6335: p_commit => fnd_api.g_false,
6336: p_init_msg_list => fnd_api.g_true,
6337: p_validation_level => fnd_api.g_valid_level_full,

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

6341: x_msg_count => x_msg_count,
6342: x_msg_data => x_msg_data);
6343:
6344: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
6345: g_api_name := 'csi_item_instance_pub.update_extended_attrib_values';
6346: raise fnd_api.g_exc_error;
6347: END IF;
6348:
6349: debug('Extended Attributed updated successfully.');

Line 6360: p_pkg_name => 'csi_item_instance_pub');

6356: -- END MRK CODE FOR UPDATE EXTENDED ATTRIBUTE
6357:
6358: csi_t_gen_utility_pvt.dump_api_info(
6359: p_api_name => 'create_extended_attrib_values',
6360: p_pkg_name => 'csi_item_instance_pub');
6361:
6362: csi_item_instance_pub.create_extended_attrib_values(
6363: p_api_version => 1.0,
6364: p_commit => fnd_api.g_false,

Line 6362: csi_item_instance_pub.create_extended_attrib_values(

6358: csi_t_gen_utility_pvt.dump_api_info(
6359: p_api_name => 'create_extended_attrib_values',
6360: p_pkg_name => 'csi_item_instance_pub');
6361:
6362: csi_item_instance_pub.create_extended_attrib_values(
6363: p_api_version => 1.0,
6364: p_commit => fnd_api.g_false,
6365: p_init_msg_list => fnd_api.g_true,
6366: p_validation_level => fnd_api.g_valid_level_full,

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

6370: x_msg_count => x_msg_count,
6371: x_msg_data => x_msg_data);
6372:
6373: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
6374: g_api_name := 'csi_item_instance_pub.create_extended_attrib_values';
6375: raise fnd_api.g_exc_error;
6376: END IF;
6377:
6378: debug('Extended Attributed created successfully.');

Line 6704: p_pkg_name => 'csi_item_instance_pub');

6700: debug(' ext_attrib_val_tbl.count :'||l_cre_ext_attrib_val_tbl.count);
6701:
6702: csi_t_gen_utility_pvt.dump_api_info(
6703: p_api_name => 'create_item_instance',
6704: p_pkg_name => 'csi_item_instance_pub');
6705:
6706: IF l_debug_level > 1 THEN
6707: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_cre_instance_rec);
6708: END IF;

Line 6711: csi_item_instance_pub.create_item_instance(

6707: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_cre_instance_rec);
6708: END IF;
6709:
6710: /* for order fulfillment instance ref is not there so create an instance */
6711: csi_item_instance_pub.create_item_instance(
6712: p_api_version => 1.0,
6713: p_commit => fnd_api.g_false,
6714: p_init_msg_list => fnd_api.g_true,
6715: p_validation_level => fnd_api.g_valid_level_full,

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

6727:
6728: -- For Bug 4057183
6729: -- IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
6730: IF NOT(x_return_status in(fnd_api.g_ret_sts_success,'W')) THEN
6731: g_api_name := 'csi_item_instance_pub.create_item_instance';
6732: raise fnd_api.g_exc_error;
6733: END IF;
6734:
6735: l_cp_ind := l_cp_ind + 1;