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 1048: csi_t_gen_utility_pvt.dump_instance_query_rec(l_inst_query_rec);

1044: l_inst_query_rec.instance_usage_code := 'IN_INVENTORY';
1045: l_inst_query_rec.inv_organization_id := p_organization_id;
1046: END IF;
1047:
1048: csi_t_gen_utility_pvt.dump_instance_query_rec(l_inst_query_rec);
1049:
1050: api_log(
1051: p_api_name => 'get_item_instances',
1052: p_pkg_name => 'csi_item_instance_pub');

Line 1391: csi_t_gen_utility_pvt.dump_api_info(

1387:
1388: l_inst_query_rec.inventory_item_id := p_inventory_item_id;
1389: l_inst_query_rec.serial_number := p_serial_number;
1390:
1391: csi_t_gen_utility_pvt.dump_api_info(
1392: p_api_name => 'get_item_instances',
1393: p_pkg_name => 'csi_item_instance_pub');
1394:
1395: csi_item_instance_pub.get_item_instances(

Line 4581: csi_t_gen_utility_pvt.build_file_name(

4577:
4578: BEGIN
4579: x_return_status := fnd_api.g_ret_sts_success;
4580:
4581: csi_t_gen_utility_pvt.build_file_name(
4582: p_file_segment1 => 'csiwipci',
4583: p_file_segment2 => p_transaction_id);
4584:
4585: api_log('wip_comp_issue');

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

4634:
4635: EXCEPTION
4636: WHEN fnd_api.g_exc_error THEN
4637: rollback to wip_comp_issue;
4638: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
4639: px_trx_error_rec := l_error_rec;
4640: x_return_status := fnd_api.g_ret_sts_error;
4641: debug('Error(E) :'||l_error_rec.error_text);
4642:

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

4646: fnd_message.set_token('API_NAME',g_api_name);
4647: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 540));
4648: fnd_msg_pub.add;
4649:
4650: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
4651: px_trx_error_rec := l_error_rec;
4652: x_return_status := fnd_api.g_ret_sts_unexp_error;
4653: debug('Error(O) :'||l_error_rec.error_text);
4654: END wip_comp_issue;

Line 4671: csi_t_gen_utility_pvt.build_file_name(

4667:
4668: BEGIN
4669: x_return_status := fnd_api.g_ret_sts_success;
4670:
4671: csi_t_gen_utility_pvt.build_file_name(
4672: p_file_segment1 => 'csiwipar',
4673: p_file_segment2 => p_transaction_id);
4674:
4675: api_log('wip_assy_return');

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

4724:
4725: EXCEPTION
4726: WHEN fnd_api.g_exc_error THEN
4727: rollback to wip_assy_return;
4728: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
4729: px_trx_error_rec := l_error_rec;
4730: x_return_status := fnd_api.g_ret_sts_error;
4731: debug('Error(E) :'||l_error_rec.error_text);
4732:

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

4736: fnd_message.set_token('API_NAME',g_api_name);
4737: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 540));
4738: fnd_msg_pub.add;
4739:
4740: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
4741: px_trx_error_rec := l_error_rec;
4742: x_return_status := fnd_api.g_ret_sts_unexp_error;
4743: debug('Error(O) :'||l_error_rec.error_text);
4744: END wip_assy_return;

Line 4764: csi_t_gen_utility_pvt.build_file_name(

4760:
4761: BEGIN
4762: x_return_status := fnd_api.g_ret_sts_success;
4763:
4764: csi_t_gen_utility_pvt.build_file_name(
4765: p_file_segment1 => 'csiwipbr',
4766: p_file_segment2 => p_transaction_id);
4767:
4768: api_log('wip_byproduct_return');

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

4817:
4818: EXCEPTION
4819: WHEN fnd_api.g_exc_error THEN
4820: rollback to wip_byproduct_return;
4821: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
4822: px_trx_error_rec := l_error_rec;
4823: x_return_status := fnd_api.g_ret_sts_error;
4824: debug('Error(E) :'||l_error_rec.error_text);
4825:

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

4829: fnd_message.set_token('API_NAME',g_api_name);
4830: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 540));
4831: fnd_msg_pub.add;
4832:
4833: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
4834: px_trx_error_rec := l_error_rec;
4835: x_return_status := fnd_api.g_ret_sts_unexp_error;
4836: debug('Error(O) :'||l_error_rec.error_text);
4837: END wip_byproduct_return;

Line 4855: csi_t_gen_utility_pvt.build_file_name(

4851:
4852: BEGIN
4853: x_return_status := fnd_api.g_ret_sts_success;
4854:
4855: csi_t_gen_utility_pvt.build_file_name(
4856: p_file_segment1 => 'csiwipnr',
4857: p_file_segment2 => p_transaction_id);
4858:
4859: api_log('wip_neg_comp_return');

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

4908:
4909: EXCEPTION
4910: WHEN fnd_api.g_exc_error THEN
4911: rollback to wip_neg_comp_return;
4912: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
4913: px_trx_error_rec := l_error_rec;
4914: x_return_status := fnd_api.g_ret_sts_error;
4915: debug('Error(E) :'||l_error_rec.error_text);
4916:

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

4920: fnd_message.set_token('API_NAME',g_api_name);
4921: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 540));
4922: fnd_msg_pub.add;
4923:
4924: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
4925: px_trx_error_rec := l_error_rec;
4926: x_return_status := fnd_api.g_ret_sts_unexp_error;
4927: debug('Error(O) :'||l_error_rec.error_text);
4928: END wip_neg_comp_return;

Line 5017: csi_t_gen_utility_pvt.dump_instance_query_rec(p_instance_query_rec);

5013: l_msg_data varchar2(2000);
5014:
5015: BEGIN
5016:
5017: csi_t_gen_utility_pvt.dump_instance_query_rec(p_instance_query_rec);
5018:
5019: api_log(
5020: p_pkg_name => 'csi_item_instance_pub',
5021: p_api_name => 'get_item_instances');

Line 5822: csi_t_gen_utility_pvt.build_file_name(

5818:
5819: fnd_msg_pub.initialize;
5820:
5821:
5822: csi_t_gen_utility_pvt.build_file_name(
5823: p_file_segment1 => 'csiwipcr',
5824: p_file_segment2 => p_transaction_id);
5825:
5826: api_log('wip_comp_receipt');

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

5930:
5931: EXCEPTION
5932: WHEN fnd_api.g_exc_error THEN
5933: rollback to wip_component_receipt;
5934: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
5935: px_trx_error_rec := l_error_rec;
5936: x_return_status := fnd_api.g_ret_sts_error;
5937:
5938: debug('Error(E) :'||l_error_rec.error_text);

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

5944: fnd_message.set_token('API_NAME',g_api_name);
5945: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 255));
5946: fnd_msg_pub.add;
5947:
5948: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
5949: px_trx_error_rec := l_error_rec;
5950: x_return_status := fnd_api.g_ret_sts_unexp_error;
5951:
5952: debug('Error(O) :'||l_error_rec.error_text);

Line 6168: csi_t_gen_utility_pvt.build_file_name(

6164: x_return_status := fnd_api.g_ret_sts_success;
6165:
6166: fnd_msg_pub.initialize;
6167:
6168: csi_t_gen_utility_pvt.build_file_name(
6169: p_file_segment1 => 'csiwipbc',
6170: p_file_segment2 => p_transaction_id);
6171:
6172: api_log('wip_byproduct_completion');

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

6320:
6321: EXCEPTION
6322: WHEN fnd_api.g_exc_error THEN
6323: rollback to wip_byproduct_completion;
6324: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
6325: px_trx_error_rec := l_error_rec;
6326: x_return_status := fnd_api.g_ret_sts_error;
6327: debug('Error(E) :'||l_error_rec.error_text);
6328:

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

6333: fnd_message.set_token('API_NAME',g_api_name);
6334: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 255));
6335: fnd_msg_pub.add;
6336:
6337: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
6338: px_trx_error_rec := l_error_rec;
6339: x_return_status := fnd_api.g_ret_sts_unexp_error;
6340: debug('Error(E) :'||l_error_rec.error_text);
6341:

Line 6398: csi_t_gen_utility_pvt.build_file_name(

6394: x_return_status := fnd_api.g_ret_sts_success;
6395:
6396: fnd_msg_pub.initialize;
6397:
6398: csi_t_gen_utility_pvt.build_file_name(
6399: p_file_segment1 => 'csiwipac',
6400: p_file_segment2 => p_transaction_id);
6401:
6402: api_log('wip_assy_completion');

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

6550:
6551: EXCEPTION
6552: WHEN fnd_api.g_exc_error THEN
6553: rollback to wip_assy_completion;
6554: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
6555: px_trx_error_rec := l_error_rec;
6556: x_return_status := fnd_api.g_ret_sts_error;
6557: debug('Error(E) :'||l_error_rec.error_text);
6558:

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

6563: fnd_message.set_token('API_NAME',g_api_name);
6564: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 255));
6565: fnd_msg_pub.add;
6566:
6567: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
6568: px_trx_error_rec := l_error_rec;
6569: x_return_status := fnd_api.g_ret_sts_unexp_error;
6570: debug('Error(E) :'||l_error_rec.error_text);
6571:

Line 6755: csi_t_gen_utility_pvt.build_file_name(

6751: l_error_message varchar2(2000);
6752:
6753: BEGIN
6754:
6755: csi_t_gen_utility_pvt.build_file_name(
6756: p_file_segment1 => 'csiwiprel',
6757: p_file_segment2 => p_wip_entity_id);
6758:
6759: api_log('process_manual_rltns');

Line 6898: l_error_message := csi_t_gen_utility_pvt.dump_error_stack;

6894: EXCEPTION
6895: WHEN fnd_api.g_exc_error THEN
6896:
6897: rollback to process_manual_rltns;
6898: l_error_message := csi_t_gen_utility_pvt.dump_error_stack;
6899: debug('Error :'||l_error_message);
6900:
6901: x_error_message := l_error_message;
6902: x_return_status := fnd_api.g_ret_sts_error;

Line 6966: csi_t_gen_utility_pvt.build_file_name(

6962: BEGIN
6963:
6964: x_return_status := fnd_api.g_ret_sts_success;
6965:
6966: csi_t_gen_utility_pvt.build_file_name(
6967: p_file_segment1 => 'csieamwc',
6968: p_file_segment2 => p_wip_entity_id);
6969:
6970: api_log('eam_wip_completion');

Line 7109: csi_t_gen_utility_pvt.build_file_name(

7105: BEGIN
7106:
7107: x_return_status := fnd_api.g_ret_sts_success;
7108:
7109: csi_t_gen_utility_pvt.build_file_name(
7110: p_file_segment1 => 'csieamrr',
7111: p_file_segment2 => p_wip_entity_id);
7112:
7113: api_log('eam_rebuildable_return');