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_ORDER_FULFILL_PUB 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_api_name => p_api_name,
17: p_pkg_name => 'csi_order_fulfill_pub');
18: END api_log;
19:

Line 55: csi_t_gen_utility_pvt.dump_api_info(

51: BEGIN
52:
53: x_return_status := fnd_api.g_ret_sts_success;
54:
55: csi_t_gen_utility_pvt.dump_api_info(
56: p_api_name => 'create_transaction',
57: p_pkg_name => 'csi_transactions_pvt');
58:
59: csi_transactions_pvt.create_transaction(

Line 172: csi_t_gen_utility_pvt.dump_api_info(

168: l_src_instance_rec.pa_project_task_id := null;
169: l_src_instance_rec.wip_job_id := null;
170: l_src_instance_rec.po_order_line_id := null;
171:
172: csi_t_gen_utility_pvt.dump_api_info(
173: p_pkg_name => 'csi_item_instance_pvt',
174: p_api_name => 'split_item_instance_lines');
175:
176: csi_item_instance_pvt.split_item_instance_lines(

Line 391: csi_t_gen_utility_pvt.dump_api_info(

387:
388: IF l_bom_std_item_tbl.COUNT > 0 THEN
389: debug('explode bom start time :'||to_char(sysdate, 'hh24:mi:ss'));
390:
391: csi_t_gen_utility_pvt.dump_api_info(
392: p_pkg_name => 'csi_item_instance_grp',
393: p_api_name => 'explode_bom');
394:
395: csi_item_instance_grp.explode_bom( -- changes done to call the Group API for performance issues, bug3722382

Line 931: csi_t_gen_utility_pvt.dump_api_info(

927:
928: l_quantity1 := l_instance_quantity - p_quantity;
929: l_quantity2 := p_quantity;
930:
931: csi_t_gen_utility_pvt.dump_api_info(
932: p_pkg_name => 'csi_item_instance_pvt',
933: p_api_name => 'split_item_instance');
934:
935: csi_item_instance_pvt.split_item_instance (

Line 2076: csi_t_gen_utility_pvt.dump_api_info(

2072: debug(' instance_id : '||p_instance_id);
2073:
2074: IF nvl(p_instance_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
2075:
2076: csi_t_gen_utility_pvt.dump_api_info(
2077: p_pkg_name => 'csi_item_instance_pub',
2078: p_api_name => 'get_item_instance_details');
2079:
2080: -- get the instance party and party account info

Line 2848: csi_t_gen_utility_pvt.dump_csi_instance_rec(

2844: l_u_party_acct_tbl(1).object_version_number := l_acct_object_ver_num;
2845:
2846: END IF;
2847:
2848: csi_t_gen_utility_pvt.dump_csi_instance_rec(
2849: p_csi_instance_rec => l_u_instance_rec);
2850:
2851: csi_t_gen_utility_pvt.dump_api_info(
2852: p_api_name => 'update_item_instance',

Line 2851: csi_t_gen_utility_pvt.dump_api_info(

2847:
2848: csi_t_gen_utility_pvt.dump_csi_instance_rec(
2849: p_csi_instance_rec => l_u_instance_rec);
2850:
2851: csi_t_gen_utility_pvt.dump_api_info(
2852: p_api_name => 'update_item_instance',
2853: p_pkg_name => 'csi_item_instance_pub');
2854:
2855: csi_item_instance_pub.update_item_instance(

Line 4489: csi_t_gen_utility_pvt.dump_api_info(

4485: l_u_instance_rec.instance_id := p_instance_id ;
4486: l_u_instance_rec.last_oe_order_line_id := p_order_line_id;
4487: l_u_instance_rec.object_version_number := l_inst_object_ver_num;
4488:
4489: csi_t_gen_utility_pvt.dump_api_info(
4490: p_api_name => 'update_item_instance',
4491: p_pkg_name => 'csi_item_instance_pub');
4492:
4493: debug(' instance_id : '||l_u_instance_rec.instance_id);

Line 4638: csi_t_gen_utility_pvt.dump_api_info(

4634: FROM csi_ii_relationships
4635: WHERE relationship_id = l_exp_rltns_rec.relationship_id;
4636:
4637: debug(' relationship_ovn :'||l_exp_rltns_rec.object_version_number);
4638: csi_t_gen_utility_pvt.dump_api_info(
4639: p_pkg_name => 'csi_ii_relationships_pub',
4640: p_api_name => 'expire_relationship');
4641:
4642: csi_ii_relationships_pub.expire_relationship(

Line 4691: csi_t_gen_utility_pvt.dump_api_info(

4687:
4688: l_relationship_query_rec.subject_id := p_instance_id;
4689: l_relationship_query_rec.relationship_type_code := 'COMPONENT-OF';
4690:
4691: csi_t_gen_utility_pvt.dump_api_info(
4692: p_pkg_name => 'csi_ii_relationships_pub',
4693: p_api_name => 'get_relationships');
4694:
4695: csi_ii_relationships_pub.get_relationships(

Line 5929: csi_t_gen_utility_pvt.dump_api_info(

5925:
5926: l_ii_rltns_qry_rec.object_id := l_config_instances(ci_ind).instance_id;
5927: l_ii_rltns_qry_rec.relationship_type_code := 'COMPONENT-OF';
5928:
5929: csi_t_gen_utility_pvt.dump_api_info(
5930: p_pkg_name => 'csi_ii_relationships_pub',
5931: p_api_name => 'get_relationships');
5932:
5933: csi_ii_relationships_pub.get_relationships(

Line 6378: csi_t_gen_utility_pvt.dump_api_info(

6374: debug('query criteria for get_item_instances:');
6375: debug(' inventory_item_id : '||l_inst_query_rec.inventory_item_id);
6376: debug(' last_oe_order_line_id : '||l_inst_query_rec.last_oe_order_line_id);
6377:
6378: csi_t_gen_utility_pvt.dump_api_info(
6379: p_api_name => 'get_item_instances',
6380: p_pkg_name => 'csi_item_instance_pub');
6381:
6382: csi_item_instance_pub.get_item_instances(

Line 6714: csi_t_gen_utility_pvt.dump_api_info(

6710: debug('Query criteria for get_item_instances:');
6711: debug(' item id : '||l_inst_query_rec.inventory_item_id);
6712: debug(' line id : '||l_inst_query_rec.last_oe_order_line_id);
6713:
6714: csi_t_gen_utility_pvt.dump_api_info(
6715: p_api_name => 'get_item_instances',
6716: p_pkg_name => 'csi_item_instance_pub');
6717:
6718: csi_item_instance_pub.get_item_instances(

Line 7008: csi_t_gen_utility_pvt.dump_api_info(

7004: debug('query criteria for get_item_instances:');
7005: debug(' item id : '||l_inst_query_rec.inventory_item_id);
7006: debug(' line id : '||l_inst_query_rec.last_oe_order_line_id);
7007:
7008: csi_t_gen_utility_pvt.dump_api_info(
7009: p_api_name => 'get_item_instances',
7010: p_pkg_name => 'csi_item_instance_pub');
7011:
7012: csi_item_instance_pub.get_item_instances(

Line 7323: csi_t_gen_utility_pvt.dump_csi_ii_rltns_tbl(l_ii_rltns_tbl);

7319: END IF;
7320:
7321: IF l_ii_rltns_tbl.count > 0 THEN
7322:
7323: csi_t_gen_utility_pvt.dump_csi_ii_rltns_tbl(l_ii_rltns_tbl);
7324:
7325: csi_t_gen_utility_pvt.dump_api_info(
7326: p_pkg_name => 'csi_ii_relationships_pub',
7327: p_api_name => 'create_relationship');

Line 7325: csi_t_gen_utility_pvt.dump_api_info(

7321: IF l_ii_rltns_tbl.count > 0 THEN
7322:
7323: csi_t_gen_utility_pvt.dump_csi_ii_rltns_tbl(l_ii_rltns_tbl);
7324:
7325: csi_t_gen_utility_pvt.dump_api_info(
7326: p_pkg_name => 'csi_ii_relationships_pub',
7327: p_api_name => 'create_relationship');
7328:
7329: csi_ii_relationships_pub.create_relationship(

Line 7473: csi_t_gen_utility_pvt.dump_api_info(

7469:
7470: debug(' subject_id : '||l_ii_rltns_qry_rec.subject_id);
7471: debug(' relationship_type : '||l_ii_rltns_qry_rec.relationship_type_code);
7472:
7473: csi_t_gen_utility_pvt.dump_api_info(
7474: p_pkg_name => 'csi_ii_relationships_pub',
7475: p_api_name => 'get_relationships');
7476:
7477: csi_ii_relationships_pub.get_relationships(

Line 7837: csi_t_gen_utility_pvt.dump_csi_ii_rltns_tbl(l_ii_rltns_tbl);

7833: END IF;
7834:
7835: IF l_ii_rltns_tbl.count > 0 THEN
7836:
7837: csi_t_gen_utility_pvt.dump_csi_ii_rltns_tbl(l_ii_rltns_tbl);
7838:
7839: csi_t_gen_utility_pvt.dump_api_info(
7840: p_pkg_name => 'csi_ii_relationships_pub',
7841: p_api_name => 'create_relationship');

Line 7839: csi_t_gen_utility_pvt.dump_api_info(

7835: IF l_ii_rltns_tbl.count > 0 THEN
7836:
7837: csi_t_gen_utility_pvt.dump_csi_ii_rltns_tbl(l_ii_rltns_tbl);
7838:
7839: csi_t_gen_utility_pvt.dump_api_info(
7840: p_pkg_name => 'csi_ii_relationships_pub',
7841: p_api_name => 'create_relationship');
7842:
7843: csi_ii_relationships_pub.create_relationship(

Line 8119: csi_t_gen_utility_pvt.dump_api_info(

8115: l_vld_orgn_id number;
8116:
8117: BEGIN
8118:
8119: csi_t_gen_utility_pvt.dump_api_info(
8120: p_api_name => 'demo_fulfillment',
8121: p_pkg_name => 'csi_order_fulfill_pub');
8122:
8123: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;

Line 8363: csi_t_gen_utility_pvt.dump_api_info(

8359: l_quantity1 := l_instance_rec.quantity - l_line_dtl_tbl(1).quantity ;
8360: l_split_src_inst_rec.instance_id := l_instance_rec.instance_id;
8361: -- l_csi_trxn_rec.split_reason_code := 'PARTIAL_RETURN';
8362:
8363: csi_t_gen_utility_pvt.dump_api_info(
8364: p_pkg_name => 'csi_item_instance_pvt',
8365: p_api_name => 'split_item_instance');
8366:
8367: csi_item_instance_pvt.split_item_instance (

Line 8678: x_return_message := csi_t_gen_utility_pvt.dump_error_stack;

8674:
8675: EXCEPTION
8676: WHEN fnd_api.g_exc_error THEN
8677: x_return_status := fnd_api.g_ret_sts_error;
8678: x_return_message := csi_t_gen_utility_pvt.dump_error_stack;
8679: rollback to cz_fulfillment;
8680: debug(x_return_message);
8681: WHEN others THEN
8682: fnd_message.set_name ('FND', 'FND_GENERIC_MESSAGE');

Line 8686: x_return_message := csi_t_gen_utility_pvt.dump_error_stack;

8682: fnd_message.set_name ('FND', 'FND_GENERIC_MESSAGE');
8683: fnd_message.set_token('MESSAGE', 'OTHERS Error :'||substr(sqlerrm, 1, 300));
8684: fnd_msg_pub.add;
8685: x_return_status := fnd_api.g_ret_sts_error;
8686: x_return_message := csi_t_gen_utility_pvt.dump_error_stack;
8687: rollback to cz_fulfillment;
8688: debug(x_return_message);
8689: END cz_fulfillment;
8690:

Line 8888: IF csi_t_gen_utility_pvt.g_debug_level >= 25 THEN

8884: IF l_return_status <> fnd_api.g_ret_sts_success THEN
8885: RAISE fnd_api.g_exc_error;
8886: END IF;
8887:
8888: IF csi_t_gen_utility_pvt.g_debug_level >= 25 THEN
8889: csi_t_gen_utility_pvt.dump_txn_tables(
8890: p_ids_or_index_based => 'I',
8891: p_line_detail_tbl => l_p_tld_tbl,
8892: p_party_detail_tbl => l_p_tpd_tbl,

Line 8889: csi_t_gen_utility_pvt.dump_txn_tables(

8885: RAISE fnd_api.g_exc_error;
8886: END IF;
8887:
8888: IF csi_t_gen_utility_pvt.g_debug_level >= 25 THEN
8889: csi_t_gen_utility_pvt.dump_txn_tables(
8890: p_ids_or_index_based => 'I',
8891: p_line_detail_tbl => l_p_tld_tbl,
8892: p_party_detail_tbl => l_p_tpd_tbl,
8893: p_pty_acct_tbl => l_p_tpa_tbl,

Line 9185: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;

9181:
9182: x_return_status := fnd_api.g_ret_sts_success;
9183: l_error_rec := px_trx_error_rec;
9184:
9185: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
9186:
9187: csi_t_gen_utility_pvt.build_file_name(
9188: p_file_segment1 => 'csisoful',
9189: p_file_segment2 => p_order_line_id);

Line 9187: csi_t_gen_utility_pvt.build_file_name(

9183: l_error_rec := px_trx_error_rec;
9184:
9185: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
9186:
9187: csi_t_gen_utility_pvt.build_file_name(
9188: p_file_segment1 => 'csisoful',
9189: p_file_segment2 => p_order_line_id);
9190:
9191: api_log(l_api_name);

Line 10414: l_error_message := csi_t_gen_utility_pvt.dump_error_stack;

10410: x_return_status := fnd_api.g_ret_sts_success;
10411: WHEN fnd_api.g_exc_error THEN
10412: rollback to order_fulfillment;
10413: x_return_status := fnd_api.g_ret_sts_error;
10414: l_error_message := csi_t_gen_utility_pvt.dump_error_stack;
10415: l_error_rec.error_text := l_error_message;
10416: debug('Error(E) :'||l_error_message);
10417: px_trx_error_rec := l_error_rec;
10418:

Line 10437: l_error_message := csi_t_gen_utility_pvt.dump_error_stack;

10433: fnd_message.set_token('MESSAGE',substr(sqlerrm,1,540));
10434: fnd_msg_pub.add;
10435:
10436: x_return_status := fnd_api.g_ret_sts_error;
10437: l_error_message := csi_t_gen_utility_pvt.dump_error_stack;
10438: l_error_rec.error_text := l_error_message;
10439: debug('Error(O) :'||l_error_message);
10440: px_trx_error_rec := l_error_rec;
10441:

Line 11019: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;

11015:
11016: x_return_status := fnd_api.g_ret_sts_success;
11017: l_error_rec := px_trx_error_rec;
11018:
11019: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
11020:
11021: SELECT trx_source_line_id
11022: INTO p_order_line_id
11023: FROM mtl_material_transactions

Line 11026: csi_t_gen_utility_pvt.build_file_name(

11022: INTO p_order_line_id
11023: FROM mtl_material_transactions
11024: WHERE transaction_id = p_mtl_txn_id;
11025:
11026: csi_t_gen_utility_pvt.build_file_name(
11027: p_file_segment1 => 'csisoful',
11028: p_file_segment2 => p_order_line_id);
11029:
11030: api_log(l_api_name);

Line 11395: csi_t_gen_utility_pvt.dump_api_info(

11391: p_txn_rec.transaction_type_id := l_txn_type_id;
11392:
11393: l_trx_rec.transaction_id := fnd_api.g_miss_num;
11394:
11395: csi_t_gen_utility_pvt.dump_api_info(
11396: p_api_name => 'update_item_instance',
11397: p_pkg_name => 'csi_item_instance_pub');
11398:
11399: csi_item_instance_pub.update_item_instance(

Line 11477: l_error_message := csi_t_gen_utility_pvt.dump_error_stack;

11473: EXCEPTION
11474: WHEN fnd_api.g_exc_error THEN
11475: x_return_status := fnd_api.g_ret_sts_error;
11476: l_error_rec.source_id := p_mtl_txn_id; -- For Bug 4168922
11477: l_error_message := csi_t_gen_utility_pvt.dump_error_stack;
11478: l_error_rec.error_text := l_error_message;
11479: debug('Error(E) :'||l_error_message);
11480: px_trx_error_rec := l_error_rec;
11481:

Line 11489: l_error_message := csi_t_gen_utility_pvt.dump_error_stack;

11485: fnd_msg_pub.add;
11486:
11487: x_return_status := fnd_api.g_ret_sts_error;
11488: l_error_rec.source_id := p_mtl_txn_id; -- For 4168922
11489: l_error_message := csi_t_gen_utility_pvt.dump_error_stack;
11490: l_error_rec.error_text := l_error_message;
11491: debug('Error(O) :'||l_error_message);
11492: px_trx_error_rec := l_error_rec;
11493:

Line 11613: csi_t_gen_utility_pvt.build_file_name(

11609: BEGIN
11610:
11611: x_return_status := FND_API.G_RET_STS_SUCCESS;
11612:
11613: csi_t_gen_utility_pvt.build_file_name(
11614: p_file_segment1 => 'csi',
11615: p_file_segment2 => to_char(sysdate, 'DDMMYY'),
11616: p_file_segment3 => 'invoke');
11617:

Line 11626: csi_t_gen_utility_pvt.add('Bypassing the SDP queue for the order line id: '||p_order_line_id);

11622: l_bypass := csi_datastructures_pub.g_install_param_rec.sfm_queue_bypass_flag;
11623:
11624: IF l_bypass = 'Y' THEN
11625:
11626: csi_t_gen_utility_pvt.add('Bypassing the SDP queue for the order line id: '||p_order_line_id);
11627:
11628: csi_inv_txnstub_pkg.execute_trx_dpl(
11629: p_transaction_type => 'CSISOFUL',
11630: p_transaction_id => p_order_line_id,

Line 11640: csi_t_gen_utility_pvt.add('Publishing the order line id '||p_order_line_id||' for fulfillment.');

11636: END IF;
11637:
11638: ELSE
11639:
11640: csi_t_gen_utility_pvt.add('Publishing the order line id '||p_order_line_id||' for fulfillment.');
11641:
11642: csi_t_gen_utility_pvt.add('Transaction Type :CSISOFUL');
11643: csi_t_gen_utility_pvt.add('Transaction ID :'||p_order_line_id);
11644:

Line 11642: csi_t_gen_utility_pvt.add('Transaction Type :CSISOFUL');

11638: ELSE
11639:
11640: csi_t_gen_utility_pvt.add('Publishing the order line id '||p_order_line_id||' for fulfillment.');
11641:
11642: csi_t_gen_utility_pvt.add('Transaction Type :CSISOFUL');
11643: csi_t_gen_utility_pvt.add('Transaction ID :'||p_order_line_id);
11644:
11645: XNP_CSISOFUL_U.publish(
11646: xnp$order_line_id => p_order_line_id,

Line 11643: csi_t_gen_utility_pvt.add('Transaction ID :'||p_order_line_id);

11639:
11640: csi_t_gen_utility_pvt.add('Publishing the order line id '||p_order_line_id||' for fulfillment.');
11641:
11642: csi_t_gen_utility_pvt.add('Transaction Type :CSISOFUL');
11643: csi_t_gen_utility_pvt.add('Transaction ID :'||p_order_line_id);
11644:
11645: XNP_CSISOFUL_U.publish(
11646: xnp$order_line_id => p_order_line_id,
11647: x_message_id => l_message_id,