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_ORDER_SHIP_PUB dependencies on CSI_T_GEN_UTILITY_PVT

Line 9: IF csi_t_gen_utility_pvt.g_debug_level > 0 THEN

5: PROCEDURE debug(
6: p_message IN varchar2)
7: IS
8: BEGIN
9: IF csi_t_gen_utility_pvt.g_debug_level > 0 THEN
10: csi_t_gen_utility_pvt.add(p_message);
11: END IF;
12: END debug;
13:

Line 10: csi_t_gen_utility_pvt.add(p_message);

6: p_message IN varchar2)
7: IS
8: BEGIN
9: IF csi_t_gen_utility_pvt.g_debug_level > 0 THEN
10: csi_t_gen_utility_pvt.add(p_message);
11: END IF;
12: END debug;
13:
14: PROCEDURE api_log(

Line 21: csi_t_gen_utility_pvt.dump_api_info(

17: BEGIN
18:
19: g_api_name := 'csi_order_ship_pub.'||p_api_name;
20:
21: csi_t_gen_utility_pvt.dump_api_info(
22: p_api_name => p_api_name,
23: p_pkg_name => 'csi_order_ship_pub');
24:
25: END api_log;

Line 96: csi_t_gen_utility_pvt.build_file_name(

92: END IF;
93:
94: END IF;
95:
96: csi_t_gen_utility_pvt.build_file_name(
97: p_file_segment1 => 'csisoshp',
98: p_file_segment2 => p_order_line_rec.inv_mtl_transaction_id);
99:
100: END LOOP;

Line 571: csi_t_gen_utility_pvt.build_file_name (

567: /* Initialize API return status to success */
568: x_return_status := fnd_api.g_ret_sts_success;
569: l_error_rec := px_trx_error_rec;
570:
571: csi_t_gen_utility_pvt.build_file_name (
572: p_file_segment1 => 'csisoshp',
573: p_file_segment2 => p_mtl_transaction_id);
574:
575: api_log('order_shipment');

Line 1324: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;

1320: EXCEPTION
1321: WHEN fnd_api.g_exc_error THEN
1322: rollback to order_shipment;
1323: x_return_status := fnd_api.g_ret_sts_error;
1324: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
1325: px_trx_error_rec := l_error_rec;
1326: debug('Error(E) :'||l_error_rec.error_text);
1327: WHEN fnd_api.g_exc_unexpected_error THEN
1328: rollback to order_shipment;

Line 1330: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;

1326: debug('Error(E) :'||l_error_rec.error_text);
1327: WHEN fnd_api.g_exc_unexpected_error THEN
1328: rollback to order_shipment;
1329: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1330: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
1331: px_trx_error_rec := l_error_rec;
1332: debug('Error(U) :'||l_error_rec.error_text);
1333: WHEN others THEN
1334: rollback to order_shipment;

Line 1516: csi_t_gen_utility_pvt.dump_api_info(

1512: l_ns_instance_rec.call_contracts := fnd_api.g_false;
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(

Line 1520: csi_t_gen_utility_pvt.dump_csi_instance_rec(

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);
1522:
1523: /* non source status update call. */
1524: csi_item_instance_pub.update_item_instance(

Line 1565: csi_t_gen_utility_pvt.dump_api_info(

1561: --code modification end for 3681856--
1562:
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(

Line 2034: csi_t_gen_utility_pvt.dump_api_info(

2030: debug('lot_number :'||l_inst_query_rec.lot_number);
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.

Line 2121: csi_t_gen_utility_pvt.dump_api_info(

2117: l_cre_party_tbl(1).relationship_type_code := 'OWNER';
2118: l_cre_party_tbl(1).contact_flag := 'N';
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 */

Line 2165: csi_t_gen_utility_pvt.dump_api_info(

2161: -- debug('Before calling update OBJECT_VERSION_NUMBER '||l_zero_instance_rec.object_version_number);
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(

Line 3764: csi_t_gen_utility_pvt.dump_api_info(

3760: l_instance_rec.quantity
3761: FROM csi_item_instances
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(

Line 3768: csi_t_gen_utility_pvt.dump_csi_instance_rec(

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:
3771: /* decrement the inventory source instance */
3772:

Line 4284: csi_t_gen_utility_pvt.dump_api_info(

4280: l_u_party_acct_tbl(1).ship_to_address := fnd_api.g_miss_num;
4281: l_u_party_acct_tbl(1).instance_party_id := l_instance_party_id;
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(

Line 4667: csi_t_gen_utility_pvt.dump_api_info(

4663: csi_utl_pkg.get_system_tbl(
4664: p_txn_systems_rec => px_txn_systems_tbl(ind),
4665: x_cre_systems_rec => l_system_rec );
4666:
4667: csi_t_gen_utility_pvt.dump_api_info(
4668: p_pkg_name => 'csi_systems_pub',
4669: p_api_name => 'create_system');
4670:
4671: csi_systems_pub.create_system(

Line 4831: csi_t_gen_utility_pvt.dump_api_info(

4827: l_src_instance_rec.pa_project_task_id := null;
4828: l_src_instance_rec.wip_job_id := null;
4829: l_src_instance_rec.po_order_line_id := null;
4830:
4831: csi_t_gen_utility_pvt.dump_api_info(
4832: p_pkg_name => 'csi_item_instance_pvt',
4833: p_api_name => 'split_item_instance_lines');
4834:
4835: csi_item_instance_pvt.split_item_instance_lines(

Line 5157: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;

5153: /* assign the trx_rec that will be used for all trx's in IB*/
5154: l_trx_rec := p_trx_rec;
5155:
5156: /* get the debug level from the profile */
5157: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
5158:
5159: l_order_line_rec := p_order_line_rec;
5160:
5161: /* validate the txn table and its child tables */

Line 5232: csi_t_gen_utility_pvt.dump_line_detail_rec(l_tld_rec);

5228: l_cps_tbl.delete;
5229:
5230: /* Process only txn details that have the source_trx_flag = 'Y' */
5231: IF l_debug_level > 1 THEN
5232: csi_t_gen_utility_pvt.dump_line_detail_rec(l_tld_rec);
5233: END IF;
5234:
5235: get_tld_set(
5236: px_tld_rec => l_tld_rec,

Line 5585: csi_t_gen_utility_pvt.dump_api_info(

5581: l_un_exp_instance_rec.instance_id := l_tld_rec.instance_id;
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(

Line 5653: csi_t_gen_utility_pvt.dump_api_info(

5649: l_split_src_inst_rec.po_order_line_id := null;
5650: l_split_src_inst_rec.version_label := nvl(l_tld_rec.version_label,fnd_api.g_miss_char);--bug 5112946
5651: l_split_src_trx_rec := p_trx_rec;
5652:
5653: csi_t_gen_utility_pvt.dump_api_info(
5654: p_pkg_name => 'csi_item_instance_pvt',
5655: p_api_name => 'split_item_instance');
5656:
5657: /* split the inventory staging instance when the instance qty > ship qty */

Line 5931: csi_t_gen_utility_pvt.dump_api_info(

5927: l_chg_party_tbl(1).party_id := p_order_line_rec.internal_party_id;
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

Line 6060: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_upd_instance_rec);

6056: debug(' upd_ext_attrib_val_tbl.count :'||l_upd_ext_attrib_val_tbl.count);
6057: debug(' upd_pricing_attribs_tbl.count :'||l_upd_pricing_attribs_tbl.count);
6058:
6059: IF l_debug_level > 1 THEN
6060: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_upd_instance_rec);
6061: END IF;
6062:
6063: csi_t_gen_utility_pvt.dump_api_info(
6064: p_api_name => 'update_item_instance',

Line 6063: csi_t_gen_utility_pvt.dump_api_info(

6059: IF l_debug_level > 1 THEN
6060: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_upd_instance_rec);
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....!');

Line 6102: csi_t_gen_utility_pvt.dump_api_info(

6098: l_exp_instance_rec.object_version_number := l_inst_obj_ver_num + 1;
6099:
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(

Line 6193: csi_t_gen_utility_pvt.dump_api_info(

6189:
6190: IF l_old_pricing_attribs_tbl.count > 0 THEN
6191: debug('Update Pricing_Attributes Count '||l_old_pricing_attribs_tbl.count);
6192:
6193: csi_t_gen_utility_pvt.dump_api_info(
6194: p_api_name => 'update_pricing_attribs',
6195: p_pkg_name => 'csi_pricing_attribs_pub');
6196:
6197: csi_pricing_attribs_pub.update_pricing_attribs(

Line 6221: csi_t_gen_utility_pvt.dump_api_info(

6217:
6218: IF l_new_pricing_attribs_tbl.count > 0 THEN
6219: debug('Creating Pricing_Attributes Count '||l_new_pricing_attribs_tbl.count);
6220:
6221: csi_t_gen_utility_pvt.dump_api_info(
6222: p_api_name => 'create_pricing_attribs',
6223: p_pkg_name => 'csi_pricing_attribs_pub');
6224:
6225: csi_pricing_attribs_pub.create_pricing_attribs(

Line 6264: csi_t_gen_utility_pvt.dump_api_info(

6260: debug('Party and Account created successfully.');
6261:
6262: IF l_cre_org_units_tbl.count > 0 THEN
6263:
6264: csi_t_gen_utility_pvt.dump_api_info(
6265: p_api_name => 'create_organization_unit',
6266: p_pkg_name => 'csi_organization_unit_pub');
6267:
6268: csi_organization_unit_pub.create_organization_unit(

Line 6329: csi_t_gen_utility_pvt.dump_api_info(

6325:
6326: IF l_old_extended_attribs_tbl.count > 0 THEN
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(

Line 6358: csi_t_gen_utility_pvt.dump_api_info(

6354: debug('Create Extended_Attributes Count '||l_new_extended_attribs_tbl.count);
6355:
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(

Line 6407: csi_t_gen_utility_pvt.dump_api_info(

6403:
6404: l_exp_ii_relationship_rec.relationship_id := l_relationship_id;
6405: l_exp_ii_relationship_rec.object_version_number := l_ii_rel_obj_ver_num;
6406:
6407: csi_t_gen_utility_pvt.dump_api_info(
6408: p_api_name => 'expire_relationship',
6409: p_pkg_name => 'csi_ii_relationships_pub');
6410:
6411: csi_ii_relationships_pub.expire_relationship(

Line 6702: csi_t_gen_utility_pvt.dump_api_info(

6698: debug(' inst_asset_tbl.count :'||l_cre_inst_asset_tbl.count);
6699: debug(' pricing_attribs_tbl.count :'||l_cre_pricing_attribs_tbl.count);
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

Line 6707: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_cre_instance_rec);

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;
6709:
6710: /* for order fulfillment instance ref is not there so create an instance */
6711: csi_item_instance_pub.create_item_instance(

Line 6883: csi_t_gen_utility_pvt.dump_api_info(

6879:
6880: IF l_bom_std_item_tbl.COUNT > 0 THEN
6881: debug('explode bom start time :'||to_char(sysdate, 'hh24:mi:ss'));
6882:
6883: csi_t_gen_utility_pvt.dump_api_info(
6884: p_pkg_name => 'csi_item_instance_grp',
6885: p_api_name => 'explode_bom');
6886:
6887: csi_item_instance_grp.explode_bom( -- changes done to call the Group API for performance issues, bug3722382

Line 6957: csi_t_gen_utility_pvt.dump_api_info(

6953: END IF;
6954:
6955: END LOOP;
6956:
6957: csi_t_gen_utility_pvt.dump_api_info(
6958: p_api_name => 'create_relationship',
6959: p_pkg_name => 'csi_ii_relationships_pub');
6960:
6961: csi_ii_relationships_pub.create_relationship(

Line 7035: csi_t_gen_utility_pvt.dump_api_info(

7031:
7032: /* update instance relationship in IB */
7033: IF l_upd_ii_rltns_tbl.count > 0 THEN
7034:
7035: csi_t_gen_utility_pvt.dump_api_info(
7036: p_api_name => 'update_relationship',
7037: p_pkg_name => 'csi_ii_relationships_pub');
7038:
7039: csi_ii_relationships_pub.update_relationship(

Line 7059: csi_t_gen_utility_pvt.dump_api_info(

7055:
7056: /* Create instance relationships in IB */
7057: IF l_cre_ii_rltns_tbl.count > 0 THEN
7058:
7059: csi_t_gen_utility_pvt.dump_api_info(
7060: p_api_name => 'create_relationship',
7061: p_pkg_name => 'csi_ii_relationships_pub');
7062:
7063: csi_ii_relationships_pub.create_relationship(

Line 8454: csi_t_gen_utility_pvt.build_file_name (

8450: x_return_status := fnd_api.g_ret_sts_success;
8451: l_error_rec := px_trx_error_rec;
8452:
8453: /* builds the debug file name */
8454: csi_t_gen_utility_pvt.build_file_name (
8455: p_file_segment1 => 'csiokshp',
8456: p_file_segment2 => p_mtl_txn_id);
8457:
8458: api_log('oke_shipment');

Line 8667: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;

8663: EXCEPTION
8664: WHEN fnd_api.g_exc_error THEN
8665: rollback to oke_shipment;
8666: x_return_status := fnd_api.g_ret_sts_error;
8667: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
8668: px_trx_error_rec := l_error_rec;
8669: debug('Error(E) :'||l_error_rec.error_text);
8670: WHEN others THEN
8671: rollback to oke_shipment;

Line 8676: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;

8672: fnd_message.set_name ('FND', 'FND_GENERIC_MESSAGE');
8673: fnd_message.set_token('MESSAGE', 'OTHERS Error :'||substr(sqlerrm, 1, 540));
8674: fnd_msg_pub.add;
8675: x_return_status := fnd_api.g_ret_sts_error;
8676: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
8677: px_trx_error_rec := l_error_rec;
8678: debug('Error(O) :'||l_error_rec.error_text);
8679: END oke_shipment;
8680: