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

Line 11: csi_t_gen_utility_pvt.add(p_message);

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

Line 22: csi_t_gen_utility_pvt.add('Inside API : '||p_pkg_name||'.'||p_api_name);

18: IS
19: BEGIN
20: IF l_debug_level > 0 THEN
21: g_api_name := p_pkg_name||'.'||p_api_name;
22: csi_t_gen_utility_pvt.add('Inside API : '||p_pkg_name||'.'||p_api_name);
23: END IF;
24: END api_log;
25:
26: PROCEDURE dump_assy_comp_relation(

Line 1028: csi_t_gen_utility_pvt.dump_instance_query_rec(l_inst_query_rec);

1024: l_inst_query_rec.instance_usage_code := 'IN_INVENTORY';
1025: l_inst_query_rec.inv_organization_id := p_organization_id;
1026: END IF;
1027:
1028: csi_t_gen_utility_pvt.dump_instance_query_rec(l_inst_query_rec);
1029:
1030: api_log(
1031: p_api_name => 'get_item_instances',
1032: p_pkg_name => 'csi_item_instance_pub');

Line 1371: csi_t_gen_utility_pvt.dump_api_info(

1367:
1368: l_inst_query_rec.inventory_item_id := p_inventory_item_id;
1369: l_inst_query_rec.serial_number := p_serial_number;
1370:
1371: csi_t_gen_utility_pvt.dump_api_info(
1372: p_api_name => 'get_item_instances',
1373: p_pkg_name => 'csi_item_instance_pub');
1374:
1375: csi_item_instance_pub.get_item_instances(

Line 4446: csi_t_gen_utility_pvt.build_file_name(

4442:
4443: BEGIN
4444: x_return_status := fnd_api.g_ret_sts_success;
4445:
4446: csi_t_gen_utility_pvt.build_file_name(
4447: p_file_segment1 => 'csiwipci',
4448: p_file_segment2 => p_transaction_id);
4449:
4450: api_log('wip_comp_issue');

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

4499:
4500: EXCEPTION
4501: WHEN fnd_api.g_exc_error THEN
4502: rollback to wip_comp_issue;
4503: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
4504: px_trx_error_rec := l_error_rec;
4505: x_return_status := fnd_api.g_ret_sts_error;
4506: debug('Error(E) :'||l_error_rec.error_text);
4507:

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

4511: fnd_message.set_token('API_NAME',g_api_name);
4512: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 540));
4513: fnd_msg_pub.add;
4514:
4515: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
4516: px_trx_error_rec := l_error_rec;
4517: x_return_status := fnd_api.g_ret_sts_unexp_error;
4518: debug('Error(O) :'||l_error_rec.error_text);
4519: END wip_comp_issue;

Line 4536: csi_t_gen_utility_pvt.build_file_name(

4532:
4533: BEGIN
4534: x_return_status := fnd_api.g_ret_sts_success;
4535:
4536: csi_t_gen_utility_pvt.build_file_name(
4537: p_file_segment1 => 'csiwipar',
4538: p_file_segment2 => p_transaction_id);
4539:
4540: api_log('wip_assy_return');

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

4589:
4590: EXCEPTION
4591: WHEN fnd_api.g_exc_error THEN
4592: rollback to wip_assy_return;
4593: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
4594: px_trx_error_rec := l_error_rec;
4595: x_return_status := fnd_api.g_ret_sts_error;
4596: debug('Error(E) :'||l_error_rec.error_text);
4597:

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

4601: fnd_message.set_token('API_NAME',g_api_name);
4602: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 540));
4603: fnd_msg_pub.add;
4604:
4605: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
4606: px_trx_error_rec := l_error_rec;
4607: x_return_status := fnd_api.g_ret_sts_unexp_error;
4608: debug('Error(O) :'||l_error_rec.error_text);
4609: END wip_assy_return;

Line 4629: csi_t_gen_utility_pvt.build_file_name(

4625:
4626: BEGIN
4627: x_return_status := fnd_api.g_ret_sts_success;
4628:
4629: csi_t_gen_utility_pvt.build_file_name(
4630: p_file_segment1 => 'csiwipbr',
4631: p_file_segment2 => p_transaction_id);
4632:
4633: api_log('wip_byproduct_return');

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

4682:
4683: EXCEPTION
4684: WHEN fnd_api.g_exc_error THEN
4685: rollback to wip_byproduct_return;
4686: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
4687: px_trx_error_rec := l_error_rec;
4688: x_return_status := fnd_api.g_ret_sts_error;
4689: debug('Error(E) :'||l_error_rec.error_text);
4690:

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

4694: fnd_message.set_token('API_NAME',g_api_name);
4695: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 540));
4696: fnd_msg_pub.add;
4697:
4698: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
4699: px_trx_error_rec := l_error_rec;
4700: x_return_status := fnd_api.g_ret_sts_unexp_error;
4701: debug('Error(O) :'||l_error_rec.error_text);
4702: END wip_byproduct_return;

Line 4720: csi_t_gen_utility_pvt.build_file_name(

4716:
4717: BEGIN
4718: x_return_status := fnd_api.g_ret_sts_success;
4719:
4720: csi_t_gen_utility_pvt.build_file_name(
4721: p_file_segment1 => 'csiwipnr',
4722: p_file_segment2 => p_transaction_id);
4723:
4724: api_log('wip_neg_comp_return');

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

4773:
4774: EXCEPTION
4775: WHEN fnd_api.g_exc_error THEN
4776: rollback to wip_neg_comp_return;
4777: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
4778: px_trx_error_rec := l_error_rec;
4779: x_return_status := fnd_api.g_ret_sts_error;
4780: debug('Error(E) :'||l_error_rec.error_text);
4781:

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

4785: fnd_message.set_token('API_NAME',g_api_name);
4786: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 540));
4787: fnd_msg_pub.add;
4788:
4789: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
4790: px_trx_error_rec := l_error_rec;
4791: x_return_status := fnd_api.g_ret_sts_unexp_error;
4792: debug('Error(O) :'||l_error_rec.error_text);
4793: END wip_neg_comp_return;

Line 4882: csi_t_gen_utility_pvt.dump_instance_query_rec(p_instance_query_rec);

4878: l_msg_data varchar2(2000);
4879:
4880: BEGIN
4881:
4882: csi_t_gen_utility_pvt.dump_instance_query_rec(p_instance_query_rec);
4883:
4884: api_log(
4885: p_pkg_name => 'csi_item_instance_pub',
4886: p_api_name => 'get_item_instances');

Line 5616: csi_t_gen_utility_pvt.build_file_name(

5612:
5613: fnd_msg_pub.initialize;
5614:
5615:
5616: csi_t_gen_utility_pvt.build_file_name(
5617: p_file_segment1 => 'csiwipcr',
5618: p_file_segment2 => p_transaction_id);
5619:
5620: api_log('wip_comp_receipt');

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

5724:
5725: EXCEPTION
5726: WHEN fnd_api.g_exc_error THEN
5727: rollback to wip_component_receipt;
5728: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
5729: px_trx_error_rec := l_error_rec;
5730: x_return_status := fnd_api.g_ret_sts_error;
5731:
5732: debug('Error(E) :'||l_error_rec.error_text);

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

5738: fnd_message.set_token('API_NAME',g_api_name);
5739: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 255));
5740: fnd_msg_pub.add;
5741:
5742: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
5743: px_trx_error_rec := l_error_rec;
5744: x_return_status := fnd_api.g_ret_sts_unexp_error;
5745:
5746: debug('Error(O) :'||l_error_rec.error_text);

Line 5962: csi_t_gen_utility_pvt.build_file_name(

5958: x_return_status := fnd_api.g_ret_sts_success;
5959:
5960: fnd_msg_pub.initialize;
5961:
5962: csi_t_gen_utility_pvt.build_file_name(
5963: p_file_segment1 => 'csiwipbc',
5964: p_file_segment2 => p_transaction_id);
5965:
5966: api_log('wip_byproduct_completion');

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

6114:
6115: EXCEPTION
6116: WHEN fnd_api.g_exc_error THEN
6117: rollback to wip_byproduct_completion;
6118: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
6119: px_trx_error_rec := l_error_rec;
6120: x_return_status := fnd_api.g_ret_sts_error;
6121: debug('Error(E) :'||l_error_rec.error_text);
6122:

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

6127: fnd_message.set_token('API_NAME',g_api_name);
6128: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 255));
6129: fnd_msg_pub.add;
6130:
6131: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
6132: px_trx_error_rec := l_error_rec;
6133: x_return_status := fnd_api.g_ret_sts_unexp_error;
6134: debug('Error(E) :'||l_error_rec.error_text);
6135:

Line 6192: csi_t_gen_utility_pvt.build_file_name(

6188: x_return_status := fnd_api.g_ret_sts_success;
6189:
6190: fnd_msg_pub.initialize;
6191:
6192: csi_t_gen_utility_pvt.build_file_name(
6193: p_file_segment1 => 'csiwipac',
6194: p_file_segment2 => p_transaction_id);
6195:
6196: api_log('wip_assy_completion');

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

6344:
6345: EXCEPTION
6346: WHEN fnd_api.g_exc_error THEN
6347: rollback to wip_assy_completion;
6348: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
6349: px_trx_error_rec := l_error_rec;
6350: x_return_status := fnd_api.g_ret_sts_error;
6351: debug('Error(E) :'||l_error_rec.error_text);
6352:

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

6357: fnd_message.set_token('API_NAME',g_api_name);
6358: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 255));
6359: fnd_msg_pub.add;
6360:
6361: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
6362: px_trx_error_rec := l_error_rec;
6363: x_return_status := fnd_api.g_ret_sts_unexp_error;
6364: debug('Error(E) :'||l_error_rec.error_text);
6365:

Line 6549: csi_t_gen_utility_pvt.build_file_name(

6545: l_error_message varchar2(2000);
6546:
6547: BEGIN
6548:
6549: csi_t_gen_utility_pvt.build_file_name(
6550: p_file_segment1 => 'csiwiprel',
6551: p_file_segment2 => p_wip_entity_id);
6552:
6553: api_log('process_manual_rltns');

Line 6692: l_error_message := csi_t_gen_utility_pvt.dump_error_stack;

6688: EXCEPTION
6689: WHEN fnd_api.g_exc_error THEN
6690:
6691: rollback to process_manual_rltns;
6692: l_error_message := csi_t_gen_utility_pvt.dump_error_stack;
6693: debug('Error :'||l_error_message);
6694:
6695: x_error_message := l_error_message;
6696: x_return_status := fnd_api.g_ret_sts_error;

Line 6760: csi_t_gen_utility_pvt.build_file_name(

6756: BEGIN
6757:
6758: x_return_status := fnd_api.g_ret_sts_success;
6759:
6760: csi_t_gen_utility_pvt.build_file_name(
6761: p_file_segment1 => 'csieamwc',
6762: p_file_segment2 => p_wip_entity_id);
6763:
6764: api_log('eam_wip_completion');

Line 6903: csi_t_gen_utility_pvt.build_file_name(

6899: BEGIN
6900:
6901: x_return_status := fnd_api.g_ret_sts_success;
6902:
6903: csi_t_gen_utility_pvt.build_file_name(
6904: p_file_segment1 => 'csieamrr',
6905: p_file_segment2 => p_wip_entity_id);
6906:
6907: api_log('eam_rebuildable_return');