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.

[Home] [Help]

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 573: csi_t_gen_utility_pvt.build_file_name (

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

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

1377: EXCEPTION
1378: WHEN fnd_api.g_exc_error THEN
1379: rollback to order_shipment;
1380: x_return_status := fnd_api.g_ret_sts_error;
1381: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
1382: px_trx_error_rec := l_error_rec;
1383: debug('Error(E) :'||l_error_rec.error_text);
1384: WHEN fnd_api.g_exc_unexpected_error THEN
1385: rollback to order_shipment;

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

1383: debug('Error(E) :'||l_error_rec.error_text);
1384: WHEN fnd_api.g_exc_unexpected_error THEN
1385: rollback to order_shipment;
1386: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1387: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
1388: px_trx_error_rec := l_error_rec;
1389: debug('Error(U) :'||l_error_rec.error_text);
1390: WHEN others THEN
1391: rollback to order_shipment;

Line 1573: csi_t_gen_utility_pvt.dump_api_info(

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

Line 1577: csi_t_gen_utility_pvt.dump_csi_instance_rec(

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);
1579:
1580: /* non source status update call. */
1581: csi_item_instance_pub.update_item_instance(

Line 1622: csi_t_gen_utility_pvt.dump_api_info(

1618: --code modification end for 3681856--
1619:
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(

Line 2093: csi_t_gen_utility_pvt.dump_api_info(

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

Line 2180: csi_t_gen_utility_pvt.dump_api_info(

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

Line 2224: csi_t_gen_utility_pvt.dump_api_info(

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

Line 3843: csi_t_gen_utility_pvt.dump_api_info(

3839: l_instance_rec.quantity
3840: FROM csi_item_instances
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(

Line 3847: csi_t_gen_utility_pvt.dump_csi_instance_rec(

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

Line 4363: csi_t_gen_utility_pvt.dump_api_info(

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

Line 4746: csi_t_gen_utility_pvt.dump_api_info(

4742: csi_utl_pkg.get_system_tbl(
4743: p_txn_systems_rec => px_txn_systems_tbl(ind),
4744: x_cre_systems_rec => l_system_rec );
4745:
4746: csi_t_gen_utility_pvt.dump_api_info(
4747: p_pkg_name => 'csi_systems_pub',
4748: p_api_name => 'create_system');
4749:
4750: csi_systems_pub.create_system(

Line 4910: csi_t_gen_utility_pvt.dump_api_info(

4906: l_src_instance_rec.pa_project_task_id := null;
4907: l_src_instance_rec.wip_job_id := null;
4908: l_src_instance_rec.po_order_line_id := null;
4909:
4910: csi_t_gen_utility_pvt.dump_api_info(
4911: p_pkg_name => 'csi_item_instance_pvt',
4912: p_api_name => 'split_item_instance_lines');
4913:
4914: csi_item_instance_pvt.split_item_instance_lines(

Line 5373: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;

5369: /* assign the trx_rec that will be used for all trx's in IB*/
5370: l_trx_rec := p_trx_rec;
5371:
5372: /* get the debug level from the profile */
5373: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
5374:
5375: l_order_line_rec := p_order_line_rec;
5376:
5377: /* validate the txn table and its child tables */

Line 5448: csi_t_gen_utility_pvt.dump_line_detail_rec(l_tld_rec);

5444: l_cps_tbl.delete;
5445:
5446: /* Process only txn details that have the source_trx_flag = 'Y' */
5447: IF l_debug_level > 1 THEN
5448: csi_t_gen_utility_pvt.dump_line_detail_rec(l_tld_rec);
5449: END IF;
5450:
5451: get_tld_set(
5452: px_tld_rec => l_tld_rec,

Line 5842: csi_t_gen_utility_pvt.dump_api_info(

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

Line 5910: csi_t_gen_utility_pvt.dump_api_info(

5906: l_split_src_inst_rec.po_order_line_id := null;
5907: l_split_src_inst_rec.version_label := nvl(l_tld_rec.version_label,fnd_api.g_miss_char);--bug 5112946
5908: l_split_src_trx_rec := p_trx_rec;
5909:
5910: csi_t_gen_utility_pvt.dump_api_info(
5911: p_pkg_name => 'csi_item_instance_pvt',
5912: p_api_name => 'split_item_instance');
5913:
5914: /* split the inventory staging instance when the instance qty > ship qty */

Line 6191: csi_t_gen_utility_pvt.dump_api_info(

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

Line 6320: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_upd_instance_rec);

6316: debug(' upd_ext_attrib_val_tbl.count :'||l_upd_ext_attrib_val_tbl.count);
6317: debug(' upd_pricing_attribs_tbl.count :'||l_upd_pricing_attribs_tbl.count);
6318:
6319: IF l_debug_level > 1 THEN
6320: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_upd_instance_rec);
6321: END IF;
6322:
6323: csi_t_gen_utility_pvt.dump_api_info(
6324: p_api_name => 'update_item_instance',

Line 6323: csi_t_gen_utility_pvt.dump_api_info(

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

Line 6362: csi_t_gen_utility_pvt.dump_api_info(

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

Line 6455: csi_t_gen_utility_pvt.dump_api_info(

6451:
6452: IF l_old_pricing_attribs_tbl.count > 0 THEN
6453: debug('Update Pricing_Attributes Count '||l_old_pricing_attribs_tbl.count);
6454:
6455: csi_t_gen_utility_pvt.dump_api_info(
6456: p_api_name => 'update_pricing_attribs',
6457: p_pkg_name => 'csi_pricing_attribs_pub');
6458:
6459: csi_pricing_attribs_pub.update_pricing_attribs(

Line 6483: csi_t_gen_utility_pvt.dump_api_info(

6479:
6480: IF l_new_pricing_attribs_tbl.count > 0 THEN
6481: debug('Creating Pricing_Attributes Count '||l_new_pricing_attribs_tbl.count);
6482:
6483: csi_t_gen_utility_pvt.dump_api_info(
6484: p_api_name => 'create_pricing_attribs',
6485: p_pkg_name => 'csi_pricing_attribs_pub');
6486:
6487: csi_pricing_attribs_pub.create_pricing_attribs(

Line 6526: csi_t_gen_utility_pvt.dump_api_info(

6522: debug('Party and Account created successfully.');
6523:
6524: IF l_cre_org_units_tbl.count > 0 THEN
6525:
6526: csi_t_gen_utility_pvt.dump_api_info(
6527: p_api_name => 'create_organization_unit',
6528: p_pkg_name => 'csi_organization_unit_pub');
6529:
6530: csi_organization_unit_pub.create_organization_unit(

Line 6591: csi_t_gen_utility_pvt.dump_api_info(

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

Line 6620: csi_t_gen_utility_pvt.dump_api_info(

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

Line 6669: csi_t_gen_utility_pvt.dump_api_info(

6665:
6666: l_exp_ii_relationship_rec.relationship_id := l_relationship_id;
6667: l_exp_ii_relationship_rec.object_version_number := l_ii_rel_obj_ver_num;
6668:
6669: csi_t_gen_utility_pvt.dump_api_info(
6670: p_api_name => 'expire_relationship',
6671: p_pkg_name => 'csi_ii_relationships_pub');
6672:
6673: csi_ii_relationships_pub.expire_relationship(

Line 6988: csi_t_gen_utility_pvt.dump_api_info(

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

Line 6993: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_cre_instance_rec);

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

Line 7184: csi_t_gen_utility_pvt.dump_api_info(

7180:
7181: IF l_bom_std_item_tbl.COUNT > 0 THEN
7182: debug('explode bom start time :'||to_char(sysdate, 'hh24:mi:ss'));
7183:
7184: csi_t_gen_utility_pvt.dump_api_info(
7185: p_pkg_name => 'csi_item_instance_grp',
7186: p_api_name => 'explode_bom');
7187:
7188: csi_item_instance_grp.explode_bom( -- changes done to call the Group API for performance issues, bug3722382

Line 7258: csi_t_gen_utility_pvt.dump_api_info(

7254: END IF;
7255:
7256: END LOOP;
7257:
7258: csi_t_gen_utility_pvt.dump_api_info(
7259: p_api_name => 'create_relationship',
7260: p_pkg_name => 'csi_ii_relationships_pub');
7261:
7262: csi_ii_relationships_pub.create_relationship(

Line 7336: csi_t_gen_utility_pvt.dump_api_info(

7332:
7333: /* update instance relationship in IB */
7334: IF l_upd_ii_rltns_tbl.count > 0 THEN
7335:
7336: csi_t_gen_utility_pvt.dump_api_info(
7337: p_api_name => 'update_relationship',
7338: p_pkg_name => 'csi_ii_relationships_pub');
7339:
7340: csi_ii_relationships_pub.update_relationship(

Line 7378: csi_t_gen_utility_pvt.dump_api_info(

7374: END LOOP;
7375: -- End fix for FP of bug 5655955 (Bug 13503707)
7376:
7377:
7378: csi_t_gen_utility_pvt.dump_api_info(
7379: p_api_name => 'create_relationship',
7380: p_pkg_name => 'csi_ii_relationships_pub');
7381:
7382: csi_ii_relationships_pub.create_relationship(

Line 8773: csi_t_gen_utility_pvt.build_file_name (

8769: x_return_status := fnd_api.g_ret_sts_success;
8770: l_error_rec := px_trx_error_rec;
8771:
8772: /* builds the debug file name */
8773: csi_t_gen_utility_pvt.build_file_name (
8774: p_file_segment1 => 'csiokshp',
8775: p_file_segment2 => p_mtl_txn_id);
8776:
8777: api_log('oke_shipment');

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

8983: EXCEPTION
8984: WHEN fnd_api.g_exc_error THEN
8985: rollback to oke_shipment;
8986: x_return_status := fnd_api.g_ret_sts_error;
8987: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
8988: px_trx_error_rec := l_error_rec;
8989: debug('Error(E) :'||l_error_rec.error_text);
8990: WHEN others THEN
8991: rollback to oke_shipment;

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

8992: fnd_message.set_name ('FND', 'FND_GENERIC_MESSAGE');
8993: fnd_message.set_token('MESSAGE', 'OTHERS Error :'||substr(sqlerrm, 1, 540));
8994: fnd_msg_pub.add;
8995: x_return_status := fnd_api.g_ret_sts_error;
8996: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
8997: px_trx_error_rec := l_error_rec;
8998: debug('Error(O) :'||l_error_rec.error_text);
8999: END oke_shipment;
9000: