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

Line 8: csi_t_gen_utility_pvt.add(p_message);

4: PROCEDURE debug(
5: p_message IN varchar2)
6: IS
7: BEGIN
8: csi_t_gen_utility_pvt.add(p_message);
9: END debug;
10:
11: PROCEDURE api_log(
12: p_api_name IN varchar2)

Line 15: csi_t_gen_utility_pvt.dump_api_info(

11: PROCEDURE api_log(
12: p_api_name IN varchar2)
13: IS
14: BEGIN
15: csi_t_gen_utility_pvt.dump_api_info(
16: p_pkg_name => 'csi_interface_pkg',
17: p_api_name => p_api_name);
18: END api_log;
19:

Line 2230: csi_t_gen_utility_pvt.dump_line_detail_rec(l_src_tld_rec);

2226: l_src_tld_rec := l_txn_line_dtl_tbl(l_ind);
2227: l_src_tld_index := l_ind;
2228: l_source_identified := TRUE;
2229: debug('dumping l_src_tld_rec..');
2230: csi_t_gen_utility_pvt.dump_line_detail_rec(l_src_tld_rec);
2231: ELSE
2232: l_n_td_ind := l_tld_tbl.COUNT + 1;
2233: l_tld_tbl(l_n_td_ind) := l_txn_line_dtl_tbl(l_ind);
2234:

Line 2381: csi_t_gen_utility_pvt.add(' NON SOURCE LINE ');

2377: END LOOP;
2378: END IF;
2379: /* Begin fix for Bug 3502896 */
2380: ELSE
2381: csi_t_gen_utility_pvt.add(' NON SOURCE LINE ');
2382: BEGIN
2383: SELECT instance_id
2384: INTO l_tld_tbl(l_ind).instance_id
2385: FROM csi_item_instances

Line 2440: csi_t_gen_utility_pvt.dump_instance_query_rec(

2436:
2437: l_inst_query_rec.inventory_item_id := p_source_line_rec.inventory_item_id;
2438: l_inst_query_rec.last_oe_order_line_id := p_source_line_rec.source_line_id;
2439:
2440: csi_t_gen_utility_pvt.dump_instance_query_rec(
2441: p_instance_query_rec => l_inst_query_rec);
2442:
2443: csi_t_gen_utility_pvt.dump_api_info(
2444: p_api_name => 'get_item_instances',

Line 2443: csi_t_gen_utility_pvt.dump_api_info(

2439:
2440: csi_t_gen_utility_pvt.dump_instance_query_rec(
2441: p_instance_query_rec => l_inst_query_rec);
2442:
2443: csi_t_gen_utility_pvt.dump_api_info(
2444: p_api_name => 'get_item_instances',
2445: p_pkg_name => 'csi_item_instance_pub');
2446:
2447: csi_item_instance_pub.get_item_instances(

Line 3614: -- csi_t_gen_utility_Pvt.dump_txn_eav_rec(p_txn_eav_tbl(l_eav_ind));

3610: FOR l_eav_ind IN p_txn_eav_tbl.FIRST .. p_txn_eav_tbl.LAST
3611: LOOP
3612: IF p_txn_eav_tbl(l_eav_ind).txn_line_details_index = p_index THEN
3613:
3614: -- csi_t_gen_utility_Pvt.dump_txn_eav_rec(p_txn_eav_tbl(l_eav_ind));
3615:
3616: eav_ind := eav_ind + 1;
3617:
3618: l_eav_tbl(eav_ind).instance_id := l_i_rec.instance_id;

Line 4468: csi_t_gen_utility_pvt.dump_api_info(

4464: END LOOP;
4465:
4466: record_time('Start');
4467:
4468: csi_t_gen_utility_pvt.dump_api_info(
4469: p_pkg_name => 'csi_ii_relationships_pub',
4470: p_api_name => 'update_relationship');
4471:
4472: csi_ii_relationships_pub.update_relationship(

Line 4564: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_c_instance_rec);

4560: l_c_org_units_tbl := l_org_units_tbl;
4561: l_c_eav_tbl := l_eav_tbl;
4562: l_c_pricing_tbl := l_pricing_tbl;
4563:
4564: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_c_instance_rec);
4565:
4566: IF csi_t_gen_utility_pvt.g_debug_level >= 15 THEN
4567: csi_t_gen_utility_pvt.dump_csi_party_tbl(l_c_party_tbl);
4568: csi_t_gen_utility_pvt.dump_csi_account_tbl(l_c_party_acct_tbl);

Line 4566: IF csi_t_gen_utility_pvt.g_debug_level >= 15 THEN

4562: l_c_pricing_tbl := l_pricing_tbl;
4563:
4564: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_c_instance_rec);
4565:
4566: IF csi_t_gen_utility_pvt.g_debug_level >= 15 THEN
4567: csi_t_gen_utility_pvt.dump_csi_party_tbl(l_c_party_tbl);
4568: csi_t_gen_utility_pvt.dump_csi_account_tbl(l_c_party_acct_tbl);
4569: csi_t_gen_utility_pvt.dump_eav_tbl(l_c_eav_tbl);
4570: END IF;

Line 4567: csi_t_gen_utility_pvt.dump_csi_party_tbl(l_c_party_tbl);

4563:
4564: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_c_instance_rec);
4565:
4566: IF csi_t_gen_utility_pvt.g_debug_level >= 15 THEN
4567: csi_t_gen_utility_pvt.dump_csi_party_tbl(l_c_party_tbl);
4568: csi_t_gen_utility_pvt.dump_csi_account_tbl(l_c_party_acct_tbl);
4569: csi_t_gen_utility_pvt.dump_eav_tbl(l_c_eav_tbl);
4570: END IF;
4571:

Line 4568: csi_t_gen_utility_pvt.dump_csi_account_tbl(l_c_party_acct_tbl);

4564: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_c_instance_rec);
4565:
4566: IF csi_t_gen_utility_pvt.g_debug_level >= 15 THEN
4567: csi_t_gen_utility_pvt.dump_csi_party_tbl(l_c_party_tbl);
4568: csi_t_gen_utility_pvt.dump_csi_account_tbl(l_c_party_acct_tbl);
4569: csi_t_gen_utility_pvt.dump_eav_tbl(l_c_eav_tbl);
4570: END IF;
4571:
4572: record_time('Start');

Line 4569: csi_t_gen_utility_pvt.dump_eav_tbl(l_c_eav_tbl);

4565:
4566: IF csi_t_gen_utility_pvt.g_debug_level >= 15 THEN
4567: csi_t_gen_utility_pvt.dump_csi_party_tbl(l_c_party_tbl);
4568: csi_t_gen_utility_pvt.dump_csi_account_tbl(l_c_party_acct_tbl);
4569: csi_t_gen_utility_pvt.dump_eav_tbl(l_c_eav_tbl);
4570: END IF;
4571:
4572: record_time('Start');
4573:

Line 4574: csi_t_gen_utility_pvt.dump_api_info(

4570: END IF;
4571:
4572: record_time('Start');
4573:
4574: csi_t_gen_utility_pvt.dump_api_info(
4575: p_pkg_name => 'csi_item_instance_pub',
4576: p_api_name => 'create_item_instance');
4577:
4578: csi_item_instance_pub.create_item_instance(

Line 4653: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_u_instance_rec);

4649: l_u_org_units_tbl := l_org_units_tbl;
4650: l_u_eav_tbl := l_eav_tbl;
4651: l_u_pricing_tbl := l_pricing_tbl;
4652:
4653: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_u_instance_rec);
4654: csi_t_gen_utility_pvt.dump_csi_party_tbl(l_u_party_tbl);
4655: csi_t_gen_utility_pvt.dump_csi_account_tbl(l_u_party_acct_tbl);
4656: csi_t_gen_utility_pvt.dump_eav_tbl(l_u_eav_tbl);
4657:

Line 4654: csi_t_gen_utility_pvt.dump_csi_party_tbl(l_u_party_tbl);

4650: l_u_eav_tbl := l_eav_tbl;
4651: l_u_pricing_tbl := l_pricing_tbl;
4652:
4653: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_u_instance_rec);
4654: csi_t_gen_utility_pvt.dump_csi_party_tbl(l_u_party_tbl);
4655: csi_t_gen_utility_pvt.dump_csi_account_tbl(l_u_party_acct_tbl);
4656: csi_t_gen_utility_pvt.dump_eav_tbl(l_u_eav_tbl);
4657:
4658:

Line 4655: csi_t_gen_utility_pvt.dump_csi_account_tbl(l_u_party_acct_tbl);

4651: l_u_pricing_tbl := l_pricing_tbl;
4652:
4653: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_u_instance_rec);
4654: csi_t_gen_utility_pvt.dump_csi_party_tbl(l_u_party_tbl);
4655: csi_t_gen_utility_pvt.dump_csi_account_tbl(l_u_party_acct_tbl);
4656: csi_t_gen_utility_pvt.dump_eav_tbl(l_u_eav_tbl);
4657:
4658:
4659: IF nvl(l_u_instance_rec.active_end_date, fnd_api.g_miss_date) <> fnd_api.g_miss_date

Line 4656: csi_t_gen_utility_pvt.dump_eav_tbl(l_u_eav_tbl);

4652:
4653: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_u_instance_rec);
4654: csi_t_gen_utility_pvt.dump_csi_party_tbl(l_u_party_tbl);
4655: csi_t_gen_utility_pvt.dump_csi_account_tbl(l_u_party_acct_tbl);
4656: csi_t_gen_utility_pvt.dump_eav_tbl(l_u_eav_tbl);
4657:
4658:
4659: IF nvl(l_u_instance_rec.active_end_date, fnd_api.g_miss_date) <> fnd_api.g_miss_date
4660: THEN

Line 4683: csi_t_gen_utility_pvt.dump_api_info(

4679: ELSE
4680: -- End adding code for FP of bug 6755897 - Reconcilation changes
4681: record_time('Start');
4682:
4683: csi_t_gen_utility_pvt.dump_api_info(
4684: p_pkg_name => 'csi_item_instance_pub',
4685: p_api_name => 'update_item_instance');
4686:
4687: csi_item_instance_pub.update_item_instance(

Line 4772: csi_t_gen_utility_pvt.dump_api_info(

4768:
4769: record_time('Start');
4770:
4771: -- call the API for BOM Explosion
4772: csi_t_gen_utility_pvt.dump_api_info(
4773: p_pkg_name => 'csi_item_instance_pvt',
4774: p_api_name => 'explode_bom');
4775:
4776: csi_item_instance_pvt.explode_bom(

Line 4852: csi_t_gen_utility_pvt.dump_api_info(

4848: debug('query criteria for get_item_instances:');
4849: debug(' item id : '||l_inst_query_rec.inventory_item_id);
4850: debug(' line id : '||l_inst_query_rec.last_oe_order_line_id);
4851:
4852: csi_t_gen_utility_pvt.dump_api_info(
4853: p_api_name => 'get_item_instances',
4854: p_pkg_name => 'csi_item_instance_pub');
4855:
4856: csi_item_instance_pub.get_item_instances(

Line 4893: csi_t_gen_utility_pvt.dump_api_info(

4889: --
4890: IF l_c_ii_rltns_tbl.COUNT > 0 THEN
4891:
4892: record_time('Start');
4893: csi_t_gen_utility_pvt.dump_api_info(
4894: p_pkg_name => 'csi_ii_relationships_pub',
4895: p_api_name => 'create_relationship');
4896:
4897: -- create relationship

Line 4947: x_return_message := csi_t_gen_utility_pvt.dump_error_stack;

4943: EXCEPTION
4944:
4945: WHEN fnd_api.g_exc_error THEN
4946: x_return_status := fnd_api.g_ret_sts_error ;
4947: x_return_message := csi_t_gen_utility_pvt.dump_error_stack;
4948: debug('Error in Interface_IB: '||x_return_message);
4949: WHEN others THEN
4950:
4951: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

Line 4956: x_return_message := csi_t_gen_utility_pvt.dump_error_stack;

4952: fnd_message.set_token('MESSAGE', substr(sqlerrm, 1, 240));
4953: fnd_msg_pub.add;
4954:
4955: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4956: x_return_message := csi_t_gen_utility_pvt.dump_error_stack;
4957: debug('Error in Interface_IB: '||x_return_message);
4958:
4959: END interface_ib;
4960:

Line 5278: csi_t_gen_utility_pvt.dump_instance_query_rec(

5274: END IF;
5275:
5276: END IF;
5277:
5278: csi_t_gen_utility_pvt.dump_instance_query_rec(
5279: p_instance_query_rec => l_inst_query_rec);
5280:
5281: csi_t_gen_utility_pvt.dump_api_info(
5282: p_pkg_name => 'csi_item_instance_pub',

Line 5281: csi_t_gen_utility_pvt.dump_api_info(

5277:
5278: csi_t_gen_utility_pvt.dump_instance_query_rec(
5279: p_instance_query_rec => l_inst_query_rec);
5280:
5281: csi_t_gen_utility_pvt.dump_api_info(
5282: p_pkg_name => 'csi_item_instance_pub',
5283: p_api_name => 'get_item_instances');
5284:
5285: csi_item_instance_pub.get_item_instances(

Line 5503: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);

5499: l_parties_tbl(1).party_id := l_internal_party_id;
5500: l_parties_tbl(1).relationship_type_code:= 'OWNER';
5501: l_parties_tbl(1).contact_flag := 'N';
5502:
5503: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);
5504:
5505: csi_t_gen_utility_pvt.dump_api_info(
5506: p_pkg_name => 'csi_item_instance_pub',
5507: p_api_name => 'create_item_instance');

Line 5505: csi_t_gen_utility_pvt.dump_api_info(

5501: l_parties_tbl(1).contact_flag := 'N';
5502:
5503: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);
5504:
5505: csi_t_gen_utility_pvt.dump_api_info(
5506: p_pkg_name => 'csi_item_instance_pub',
5507: p_api_name => 'create_item_instance');
5508:
5509: -- creation of negative quantity inventory instance

Line 5593: csi_t_gen_utility_pvt.dump_csi_instance_rec(

5589: END;
5590: END IF;
5591: /*Code modified/added END for bug 4865052*/
5592:
5593: csi_t_gen_utility_pvt.dump_csi_instance_rec(
5594: p_csi_instance_rec => l_instance_rec);
5595:
5596: record_time('Start');
5597:

Line 5598: csi_t_gen_utility_pvt.dump_api_info(

5594: p_csi_instance_rec => l_instance_rec);
5595:
5596: record_time('Start');
5597:
5598: csi_t_gen_utility_pvt.dump_api_info(
5599: p_api_name => 'update_item_instance',
5600: p_pkg_name => 'csi_item_instance_pub');
5601:
5602: /* decrement the inventory source instance */