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 2201: csi_t_gen_utility_pvt.dump_line_detail_rec(l_src_tld_rec);

2197: l_src_tld_rec := l_txn_line_dtl_tbl(l_ind);
2198: l_src_tld_index := l_ind;
2199: l_source_identified := TRUE;
2200: debug('dumping l_src_tld_rec..');
2201: csi_t_gen_utility_pvt.dump_line_detail_rec(l_src_tld_rec);
2202: ELSE
2203: l_n_td_ind := l_tld_tbl.COUNT + 1;
2204: l_tld_tbl(l_n_td_ind) := l_txn_line_dtl_tbl(l_ind);
2205:

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

2348: END LOOP;
2349: END IF;
2350: /* Begin fix for Bug 3502896 */
2351: ELSE
2352: csi_t_gen_utility_pvt.add(' NON SOURCE LINE ');
2353: BEGIN
2354: SELECT instance_id
2355: INTO l_tld_tbl(l_ind).instance_id
2356: FROM csi_item_instances

Line 2406: csi_t_gen_utility_pvt.dump_instance_query_rec(

2402:
2403: l_inst_query_rec.inventory_item_id := p_source_line_rec.inventory_item_id;
2404: l_inst_query_rec.last_oe_order_line_id := p_source_line_rec.source_line_id;
2405:
2406: csi_t_gen_utility_pvt.dump_instance_query_rec(
2407: p_instance_query_rec => l_inst_query_rec);
2408:
2409: csi_t_gen_utility_pvt.dump_api_info(
2410: p_api_name => 'get_item_instances',

Line 2409: csi_t_gen_utility_pvt.dump_api_info(

2405:
2406: csi_t_gen_utility_pvt.dump_instance_query_rec(
2407: p_instance_query_rec => l_inst_query_rec);
2408:
2409: csi_t_gen_utility_pvt.dump_api_info(
2410: p_api_name => 'get_item_instances',
2411: p_pkg_name => 'csi_item_instance_pub');
2412:
2413: csi_item_instance_pub.get_item_instances(

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

3517: FOR l_eav_ind IN p_txn_eav_tbl.FIRST .. p_txn_eav_tbl.LAST
3518: LOOP
3519: IF p_txn_eav_tbl(l_eav_ind).txn_line_details_index = p_index THEN
3520:
3521: -- csi_t_gen_utility_Pvt.dump_txn_eav_rec(p_txn_eav_tbl(l_eav_ind));
3522:
3523: eav_ind := eav_ind + 1;
3524:
3525: l_eav_tbl(eav_ind).instance_id := l_i_rec.instance_id;

Line 4362: csi_t_gen_utility_pvt.dump_api_info(

4358: END LOOP;
4359:
4360: record_time('Start');
4361:
4362: csi_t_gen_utility_pvt.dump_api_info(
4363: p_pkg_name => 'csi_ii_relationships_pub',
4364: p_api_name => 'update_relationship');
4365:
4366: csi_ii_relationships_pub.update_relationship(

Line 4457: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_c_instance_rec);

4453: l_c_org_units_tbl := l_org_units_tbl;
4454: l_c_eav_tbl := l_eav_tbl;
4455: l_c_pricing_tbl := l_pricing_tbl;
4456:
4457: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_c_instance_rec);
4458:
4459: IF csi_t_gen_utility_pvt.g_debug_level >= 15 THEN
4460: csi_t_gen_utility_pvt.dump_csi_party_tbl(l_c_party_tbl);
4461: csi_t_gen_utility_pvt.dump_csi_account_tbl(l_c_party_acct_tbl);

Line 4459: IF csi_t_gen_utility_pvt.g_debug_level >= 15 THEN

4455: l_c_pricing_tbl := l_pricing_tbl;
4456:
4457: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_c_instance_rec);
4458:
4459: IF csi_t_gen_utility_pvt.g_debug_level >= 15 THEN
4460: csi_t_gen_utility_pvt.dump_csi_party_tbl(l_c_party_tbl);
4461: csi_t_gen_utility_pvt.dump_csi_account_tbl(l_c_party_acct_tbl);
4462: csi_t_gen_utility_pvt.dump_eav_tbl(l_c_eav_tbl);
4463: END IF;

Line 4460: csi_t_gen_utility_pvt.dump_csi_party_tbl(l_c_party_tbl);

4456:
4457: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_c_instance_rec);
4458:
4459: IF csi_t_gen_utility_pvt.g_debug_level >= 15 THEN
4460: csi_t_gen_utility_pvt.dump_csi_party_tbl(l_c_party_tbl);
4461: csi_t_gen_utility_pvt.dump_csi_account_tbl(l_c_party_acct_tbl);
4462: csi_t_gen_utility_pvt.dump_eav_tbl(l_c_eav_tbl);
4463: END IF;
4464:

Line 4461: csi_t_gen_utility_pvt.dump_csi_account_tbl(l_c_party_acct_tbl);

4457: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_c_instance_rec);
4458:
4459: IF csi_t_gen_utility_pvt.g_debug_level >= 15 THEN
4460: csi_t_gen_utility_pvt.dump_csi_party_tbl(l_c_party_tbl);
4461: csi_t_gen_utility_pvt.dump_csi_account_tbl(l_c_party_acct_tbl);
4462: csi_t_gen_utility_pvt.dump_eav_tbl(l_c_eav_tbl);
4463: END IF;
4464:
4465: record_time('Start');

Line 4462: csi_t_gen_utility_pvt.dump_eav_tbl(l_c_eav_tbl);

4458:
4459: IF csi_t_gen_utility_pvt.g_debug_level >= 15 THEN
4460: csi_t_gen_utility_pvt.dump_csi_party_tbl(l_c_party_tbl);
4461: csi_t_gen_utility_pvt.dump_csi_account_tbl(l_c_party_acct_tbl);
4462: csi_t_gen_utility_pvt.dump_eav_tbl(l_c_eav_tbl);
4463: END IF;
4464:
4465: record_time('Start');
4466:

Line 4467: csi_t_gen_utility_pvt.dump_api_info(

4463: END IF;
4464:
4465: record_time('Start');
4466:
4467: csi_t_gen_utility_pvt.dump_api_info(
4468: p_pkg_name => 'csi_item_instance_pub',
4469: p_api_name => 'create_item_instance');
4470:
4471: csi_item_instance_pub.create_item_instance(

Line 4546: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_u_instance_rec);

4542: l_u_org_units_tbl := l_org_units_tbl;
4543: l_u_eav_tbl := l_eav_tbl;
4544: l_u_pricing_tbl := l_pricing_tbl;
4545:
4546: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_u_instance_rec);
4547: csi_t_gen_utility_pvt.dump_csi_party_tbl(l_u_party_tbl);
4548: csi_t_gen_utility_pvt.dump_csi_account_tbl(l_u_party_acct_tbl);
4549: csi_t_gen_utility_pvt.dump_eav_tbl(l_u_eav_tbl);
4550:

Line 4547: csi_t_gen_utility_pvt.dump_csi_party_tbl(l_u_party_tbl);

4543: l_u_eav_tbl := l_eav_tbl;
4544: l_u_pricing_tbl := l_pricing_tbl;
4545:
4546: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_u_instance_rec);
4547: csi_t_gen_utility_pvt.dump_csi_party_tbl(l_u_party_tbl);
4548: csi_t_gen_utility_pvt.dump_csi_account_tbl(l_u_party_acct_tbl);
4549: csi_t_gen_utility_pvt.dump_eav_tbl(l_u_eav_tbl);
4550:
4551:

Line 4548: csi_t_gen_utility_pvt.dump_csi_account_tbl(l_u_party_acct_tbl);

4544: l_u_pricing_tbl := l_pricing_tbl;
4545:
4546: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_u_instance_rec);
4547: csi_t_gen_utility_pvt.dump_csi_party_tbl(l_u_party_tbl);
4548: csi_t_gen_utility_pvt.dump_csi_account_tbl(l_u_party_acct_tbl);
4549: csi_t_gen_utility_pvt.dump_eav_tbl(l_u_eav_tbl);
4550:
4551:
4552: IF nvl(l_u_instance_rec.active_end_date, fnd_api.g_miss_date) <> fnd_api.g_miss_date

Line 4549: csi_t_gen_utility_pvt.dump_eav_tbl(l_u_eav_tbl);

4545:
4546: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_u_instance_rec);
4547: csi_t_gen_utility_pvt.dump_csi_party_tbl(l_u_party_tbl);
4548: csi_t_gen_utility_pvt.dump_csi_account_tbl(l_u_party_acct_tbl);
4549: csi_t_gen_utility_pvt.dump_eav_tbl(l_u_eav_tbl);
4550:
4551:
4552: IF nvl(l_u_instance_rec.active_end_date, fnd_api.g_miss_date) <> fnd_api.g_miss_date
4553: THEN

Line 4576: csi_t_gen_utility_pvt.dump_api_info(

4572: ELSE
4573: -- End adding code for FP of bug 6755897 - Reconcilation changes
4574: record_time('Start');
4575:
4576: csi_t_gen_utility_pvt.dump_api_info(
4577: p_pkg_name => 'csi_item_instance_pub',
4578: p_api_name => 'update_item_instance');
4579:
4580: csi_item_instance_pub.update_item_instance(

Line 4665: csi_t_gen_utility_pvt.dump_api_info(

4661:
4662: record_time('Start');
4663:
4664: -- call the API for BOM Explosion
4665: csi_t_gen_utility_pvt.dump_api_info(
4666: p_pkg_name => 'csi_item_instance_pvt',
4667: p_api_name => 'explode_bom');
4668:
4669: csi_item_instance_pvt.explode_bom(

Line 4745: csi_t_gen_utility_pvt.dump_api_info(

4741: debug('query criteria for get_item_instances:');
4742: debug(' item id : '||l_inst_query_rec.inventory_item_id);
4743: debug(' line id : '||l_inst_query_rec.last_oe_order_line_id);
4744:
4745: csi_t_gen_utility_pvt.dump_api_info(
4746: p_api_name => 'get_item_instances',
4747: p_pkg_name => 'csi_item_instance_pub');
4748:
4749: csi_item_instance_pub.get_item_instances(

Line 4786: csi_t_gen_utility_pvt.dump_api_info(

4782: --
4783: IF l_c_ii_rltns_tbl.COUNT > 0 THEN
4784:
4785: record_time('Start');
4786: csi_t_gen_utility_pvt.dump_api_info(
4787: p_pkg_name => 'csi_ii_relationships_pub',
4788: p_api_name => 'create_relationship');
4789:
4790: -- create relationship

Line 4840: x_return_message := csi_t_gen_utility_pvt.dump_error_stack;

4836: EXCEPTION
4837:
4838: WHEN fnd_api.g_exc_error THEN
4839: x_return_status := fnd_api.g_ret_sts_error ;
4840: x_return_message := csi_t_gen_utility_pvt.dump_error_stack;
4841: debug('Error in Interface_IB: '||x_return_message);
4842: WHEN others THEN
4843:
4844: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

Line 4849: x_return_message := csi_t_gen_utility_pvt.dump_error_stack;

4845: fnd_message.set_token('MESSAGE', substr(sqlerrm, 1, 240));
4846: fnd_msg_pub.add;
4847:
4848: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4849: x_return_message := csi_t_gen_utility_pvt.dump_error_stack;
4850: debug('Error in Interface_IB: '||x_return_message);
4851:
4852: END interface_ib;
4853:

Line 5171: csi_t_gen_utility_pvt.dump_instance_query_rec(

5167: END IF;
5168:
5169: END IF;
5170:
5171: csi_t_gen_utility_pvt.dump_instance_query_rec(
5172: p_instance_query_rec => l_inst_query_rec);
5173:
5174: csi_t_gen_utility_pvt.dump_api_info(
5175: p_pkg_name => 'csi_item_instance_pub',

Line 5174: csi_t_gen_utility_pvt.dump_api_info(

5170:
5171: csi_t_gen_utility_pvt.dump_instance_query_rec(
5172: p_instance_query_rec => l_inst_query_rec);
5173:
5174: csi_t_gen_utility_pvt.dump_api_info(
5175: p_pkg_name => 'csi_item_instance_pub',
5176: p_api_name => 'get_item_instances');
5177:
5178: csi_item_instance_pub.get_item_instances(

Line 5396: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);

5392: l_parties_tbl(1).party_id := l_internal_party_id;
5393: l_parties_tbl(1).relationship_type_code:= 'OWNER';
5394: l_parties_tbl(1).contact_flag := 'N';
5395:
5396: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);
5397:
5398: csi_t_gen_utility_pvt.dump_api_info(
5399: p_pkg_name => 'csi_item_instance_pub',
5400: p_api_name => 'create_item_instance');

Line 5398: csi_t_gen_utility_pvt.dump_api_info(

5394: l_parties_tbl(1).contact_flag := 'N';
5395:
5396: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);
5397:
5398: csi_t_gen_utility_pvt.dump_api_info(
5399: p_pkg_name => 'csi_item_instance_pub',
5400: p_api_name => 'create_item_instance');
5401:
5402: -- creation of negative quantity inventory instance

Line 5486: csi_t_gen_utility_pvt.dump_csi_instance_rec(

5482: END;
5483: END IF;
5484: /*Code modified/added END for bug 4865052*/
5485:
5486: csi_t_gen_utility_pvt.dump_csi_instance_rec(
5487: p_csi_instance_rec => l_instance_rec);
5488:
5489: record_time('Start');
5490:

Line 5491: csi_t_gen_utility_pvt.dump_api_info(

5487: p_csi_instance_rec => l_instance_rec);
5488:
5489: record_time('Start');
5490:
5491: csi_t_gen_utility_pvt.dump_api_info(
5492: p_api_name => 'update_item_instance',
5493: p_pkg_name => 'csi_item_instance_pub');
5494:
5495: /* decrement the inventory source instance */