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_PROCESS_TXN_PVT 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: EXCEPTION
10: WHEN others THEN
11: null;
12: END debug;

Line 18: csi_t_gen_utility_pvt.dump_api_info(

14: PROCEDURE api_log(
15: p_api_name IN varchar2)
16: IS
17: BEGIN
18: csi_t_gen_utility_pvt.dump_api_info(
19: p_pkg_name => 'csi_process_txn_pvt',
20: p_api_name => p_api_name);
21: EXCEPTION
22: WHEN others THEN

Line 226: csi_t_gen_utility_pvt.dump_api_info(

222: l_reference_found boolean;
223: l_reference_code varchar2(30);
224: BEGIN
225:
226: csi_t_gen_utility_pvt.dump_api_info(
227: p_pkg_name => g_pkg_name,
228: p_api_name => 'validate_reference');
229:
230: l_reference_found := FALSE;

Line 285: csi_t_gen_utility_pvt.dump_api_info(

281: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
282:
283: BEGIN
284:
285: csi_t_gen_utility_pvt.dump_api_info(
286: p_pkg_name => g_pkg_name,
287: p_api_name => 'validate_owner_reference');
288:
289: x_return_status := fnd_api.g_ret_sts_success;

Line 368: csi_t_gen_utility_pvt.dump_api_info(

364: BEGIN
365:
366: x_return_status := fnd_api.g_ret_sts_success;
367:
368: csi_t_gen_utility_pvt.dump_api_info(
369: p_pkg_name => g_pkg_name,
370: p_api_name => 'sub_type_validations');
371:
372: debug('Transaction type ID: '||p_sub_type_rec.transaction_type_id);

Line 481: csi_t_gen_utility_pvt.dump_api_info(

477: l_serial_tagged VARCHAR2(1) := 'N';
478:
479: BEGIN
480:
481: csi_t_gen_utility_pvt.dump_api_info(
482: p_pkg_name => g_pkg_name,
483: p_api_name => 'get_item_attributes');
484:
485: x_return_status := fnd_api.g_ret_sts_success;

Line 633: csi_t_gen_utility_pvt.dump_api_info(

629: x_return_status OUT NOCOPY varchar2)
630: IS
631: BEGIN
632:
633: csi_t_gen_utility_pvt.dump_api_info(
634: p_pkg_name => g_pkg_name,
635: p_api_name => 'validate_instance_rec');
636:
637: x_return_status := fnd_api.g_ret_sts_success;

Line 722: csi_t_gen_utility_pvt.dump_api_info(

718: BEGIN
719:
720: x_return_status := fnd_api.g_ret_sts_success;
721:
722: csi_t_gen_utility_pvt.dump_api_info(
723: p_pkg_name => g_pkg_name,
724: p_api_name => 'build_instance_query_rec');
725:
726: l_inst_query_rec.inventory_item_id := p_instance_rec.inventory_item_id;

Line 844: csi_t_gen_utility_pvt.dump_instance_query_rec(

840: x_instance_query_rec := l_inst_query_rec;
841:
842: debug('Instance query criteria for '||p_query_criteria);
843:
844: csi_t_gen_utility_pvt.dump_instance_query_rec(
845: p_instance_query_rec => x_instance_query_rec);
846:
847: EXCEPTION
848: WHEN fnd_api.g_exc_error THEN

Line 939: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);

935: l_parties_tbl(1).party_id := l_internal_party_id;
936: l_parties_tbl(1).relationship_type_code:= 'OWNER';
937: l_parties_tbl(1).contact_flag := 'N';
938:
939: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);
940:
941: csi_t_gen_utility_pvt.dump_api_info(
942: p_pkg_name => 'csi_item_instance_pub',
943: p_api_name => 'create_item_instance');

Line 941: csi_t_gen_utility_pvt.dump_api_info(

937: l_parties_tbl(1).contact_flag := 'N';
938:
939: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);
940:
941: csi_t_gen_utility_pvt.dump_api_info(
942: p_pkg_name => 'csi_item_instance_pub',
943: p_api_name => 'create_item_instance');
944:
945: -- creation of zero quantity instance

Line 977: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_u_instance_rec);

973: l_u_instance_rec.instance_id := l_instance_rec.instance_id;
974: l_u_instance_rec.quantity := 0;
975: l_u_instance_rec.object_version_number := l_instance_rec.object_version_number;
976:
977: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_u_instance_rec);
978:
979: csi_t_gen_utility_pvt.dump_api_info(
980: p_pkg_name => 'csi_item_instance_pub',
981: p_api_name => 'update_item_instance');

Line 979: csi_t_gen_utility_pvt.dump_api_info(

975: l_u_instance_rec.object_version_number := l_instance_rec.object_version_number;
976:
977: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_u_instance_rec);
978:
979: csi_t_gen_utility_pvt.dump_api_info(
980: p_pkg_name => 'csi_item_instance_pub',
981: p_api_name => 'update_item_instance');
982:
983: -- update to make a zero quantity instance

Line 1056: csi_t_gen_utility_pvt.dump_api_info(

1052: -- End adding code for bug 7207346
1053:
1054: BEGIN
1055:
1056: csi_t_gen_utility_pvt.dump_api_info(
1057: p_pkg_name => g_pkg_name,
1058: p_api_name => 'get_src_instance_id');
1059:
1060: x_return_status := fnd_api.g_ret_sts_success;

Line 1382: csi_t_gen_utility_pvt.dump_api_info(

1378: -- End adding code for bug 7207346
1379:
1380: BEGIN
1381:
1382: csi_t_gen_utility_pvt.dump_api_info(
1383: p_pkg_name => g_pkg_name,
1384: p_api_name => 'get_dest_instance_id');
1385:
1386: x_return_status := fnd_api.g_ret_sts_success;

Line 1402: csi_t_gen_utility_pvt.dump_api_info(

1398: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1399: RAISE fnd_api.g_exc_error;
1400: END IF;
1401:
1402: csi_t_gen_utility_pvt.dump_api_info(
1403: p_pkg_name => 'csi_item_instance_pub',
1404: p_api_name => 'get_item_instances');
1405:
1406: csi_item_instance_pub.get_item_instances(

Line 1670: csi_t_gen_utility_pvt.dump_txn_i_party_rec(

1666:
1667: IF p_i_parties_tbl(l_ind).parent_tbl_index = p_instance_index THEN
1668:
1669: /* debug messages */
1670: csi_t_gen_utility_pvt.dump_txn_i_party_rec(
1671: p_txn_i_party_rec => p_i_parties_tbl(l_ind));
1672:
1673: c_ind := c_ind + 1;
1674:

Line 1710: csi_t_gen_utility_pvt.dump_txn_ip_account_rec(

1706:
1707: IF p_ip_accounts_tbl(l_a_ind).parent_tbl_index = l_ind THEN
1708:
1709: /* debug messages */
1710: csi_t_gen_utility_pvt.dump_txn_ip_account_rec(
1711: p_txn_ip_account_rec => p_ip_accounts_tbl(l_a_ind));
1712:
1713: c_a_ind := c_a_ind + 1;
1714:

Line 1782: csi_t_gen_utility_pvt.dump_txn_eav_rec(

1778: LOOP
1779: IF p_ext_attrib_vals_tbl(l_ind).parent_tbl_index = p_instance_index THEN
1780:
1781: /* debug messages */
1782: csi_t_gen_utility_pvt.dump_txn_eav_rec(
1783: p_txn_eav_rec => p_ext_attrib_vals_tbl(l_ind));
1784:
1785: c_ind := c_ind + 1;
1786:

Line 1842: csi_t_gen_utility_pvt.dump_txn_price_rec(

1838: LOOP
1839: IF p_pricing_attribs_tbl(l_ind).parent_tbl_index = p_instance_index THEN
1840:
1841: /* debug messages */
1842: csi_t_gen_utility_pvt.dump_txn_price_rec(
1843: p_txn_price_rec => p_pricing_attribs_tbl(l_ind));
1844:
1845: c_ind := c_ind + 1;
1846:

Line 2002: csi_t_gen_utility_pvt.dump_txn_org_unit_rec(

1998: LOOP
1999: IF p_org_units_tbl(l_ind).parent_tbl_index = p_instance_index THEN
2000:
2001: /* debug messages */
2002: csi_t_gen_utility_pvt.dump_txn_org_unit_rec(
2003: p_txn_org_unit_rec => p_org_units_tbl(l_ind));
2004:
2005: c_ind := c_ind + 1;
2006:

Line 2062: csi_t_gen_utility_pvt.dump_txn_asset_rec(

2058: LOOP
2059: IF p_instance_asset_tbl(l_ind).parent_tbl_index = p_instance_index THEN
2060:
2061: /* debug messages */
2062: csi_t_gen_utility_pvt.dump_txn_asset_rec(
2063: p_txn_asset_rec => p_instance_asset_tbl(l_ind));
2064:
2065: c_ind := c_ind + 1;
2066:

Line 2406: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_u_instance_rec);

2402: INTO l_u_instance_rec.object_version_number
2403: FROM csi_item_instances
2404: WHERE instance_id = l_u_instance_rec.instance_id;
2405:
2406: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_u_instance_rec);
2407:
2408: csi_t_gen_utility_pvt.dump_api_info(
2409: p_pkg_name => 'csi_item_instance_pub',
2410: p_api_name => 'update_item_instance');

Line 2408: csi_t_gen_utility_pvt.dump_api_info(

2404: WHERE instance_id = l_u_instance_rec.instance_id;
2405:
2406: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_u_instance_rec);
2407:
2408: csi_t_gen_utility_pvt.dump_api_info(
2409: p_pkg_name => 'csi_item_instance_pub',
2410: p_api_name => 'update_item_instance');
2411:
2412: -- unexpire instance call.

Line 2620: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;

2616:
2617: BEGIN
2618:
2619: x_return_status := fnd_api.g_ret_sts_success;
2620: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
2621:
2622: /* debug messages */
2623:
2624: csi_t_gen_utility_pvt.dump_api_info(

Line 2624: csi_t_gen_utility_pvt.dump_api_info(

2620: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
2621:
2622: /* debug messages */
2623:
2624: csi_t_gen_utility_pvt.dump_api_info(
2625: p_pkg_name => g_pkg_name,
2626: p_api_name => 'process_ib');
2627:
2628: debug('Processing record no. '||p_instance_index||' from the instances tbl.');

Line 2632: csi_t_gen_utility_pvt.dump_txn_instance_rec(

2628: debug('Processing record no. '||p_instance_index||' from the instances tbl.');
2629:
2630: IF l_debug_level > 1 THEN
2631:
2632: csi_t_gen_utility_pvt.dump_txn_instance_rec(
2633: p_txn_instance_rec => p_instance_rec);
2634:
2635: csi_t_gen_utility_pvt.dump_dest_location_rec(
2636: p_dest_location_rec => p_dest_location_rec);

Line 2635: csi_t_gen_utility_pvt.dump_dest_location_rec(

2631:
2632: csi_t_gen_utility_pvt.dump_txn_instance_rec(
2633: p_txn_instance_rec => p_instance_rec);
2634:
2635: csi_t_gen_utility_pvt.dump_dest_location_rec(
2636: p_dest_location_rec => p_dest_location_rec);
2637:
2638: END IF;
2639:

Line 2753: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);

2749: l_instance_rec.operational_status_code := p_dest_location_rec.operational_status_code;
2750:
2751: l_current_procedure := 'create_item_instance';
2752:
2753: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);
2754:
2755: csi_t_gen_utility_pvt.dump_api_info(
2756: p_pkg_name => 'csi_item_instance_pub',
2757: p_api_name => 'create_item_instance');

Line 2755: csi_t_gen_utility_pvt.dump_api_info(

2751: l_current_procedure := 'create_item_instance';
2752:
2753: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);
2754:
2755: csi_t_gen_utility_pvt.dump_api_info(
2756: p_pkg_name => 'csi_item_instance_pub',
2757: p_api_name => 'create_item_instance');
2758:
2759: -- create destination instance (when there is only creation of destination)

Line 2846: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);

2842: END IF;
2843:
2844: l_current_procedure := 'create_item_instance';
2845:
2846: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);
2847:
2848: csi_t_gen_utility_pvt.dump_api_info(
2849: p_pkg_name => 'csi_item_instance_pub',
2850: p_api_name => 'create_item_instance');

Line 2848: csi_t_gen_utility_pvt.dump_api_info(

2844: l_current_procedure := 'create_item_instance';
2845:
2846: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);
2847:
2848: csi_t_gen_utility_pvt.dump_api_info(
2849: p_pkg_name => 'csi_item_instance_pub',
2850: p_api_name => 'create_item_instance');
2851:
2852: csi_item_instance_pub.create_item_instance(

Line 2965: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);

2961: END IF;
2962:
2963: l_current_procedure := 'update_item_instance';
2964:
2965: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);
2966:
2967: csi_t_gen_utility_pvt.dump_api_info(
2968: p_pkg_name => 'csi_item_instance_pub',
2969: p_api_name => 'update_item_instance');

Line 2967: csi_t_gen_utility_pvt.dump_api_info(

2963: l_current_procedure := 'update_item_instance';
2964:
2965: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);
2966:
2967: csi_t_gen_utility_pvt.dump_api_info(
2968: p_pkg_name => 'csi_item_instance_pub',
2969: p_api_name => 'update_item_instance');
2970:
2971: -- destination update for IN and INT

Line 3191: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);

3187: WHERE instance_id = l_instance_rec.instance_id;
3188:
3189: l_current_procedure := 'update_item_instance';
3190:
3191: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);
3192:
3193: csi_t_gen_utility_pvt.dump_api_info(
3194: p_pkg_name => 'csi_item_instance_pub',
3195: p_api_name => 'update_item_instance');

Line 3193: csi_t_gen_utility_pvt.dump_api_info(

3189: l_current_procedure := 'update_item_instance';
3190:
3191: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);
3192:
3193: csi_t_gen_utility_pvt.dump_api_info(
3194: p_pkg_name => 'csi_item_instance_pub',
3195: p_api_name => 'update_item_instance');
3196:
3197: -- serialized update at dest

Line 3573: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_u_instance_rec);

3569: debug(' src_inst_ovn : '||l_object_version_number);
3570: debug(' src_inst_qty : '||l_src_instance_qty);
3571: debug(' txn_qty : '||p_instance_rec.quantity);
3572:
3573: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_u_instance_rec);
3574:
3575: l_current_procedure := 'update_item_instance';
3576:
3577: csi_t_gen_utility_pvt.dump_api_info(

Line 3577: csi_t_gen_utility_pvt.dump_api_info(

3573: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_u_instance_rec);
3574:
3575: l_current_procedure := 'update_item_instance';
3576:
3577: csi_t_gen_utility_pvt.dump_api_info(
3578: p_pkg_name => 'csi_item_instance_pub',
3579: p_api_name => 'update_item_instance');
3580:
3581: /* source instance update for srl at so issue and non serial */

Line 3739: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);

3735: -- end Bug 9301695
3736:
3737: l_current_procedure := 'create_item_instance';
3738:
3739: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);
3740:
3741: csi_t_gen_utility_pvt.dump_api_info(
3742: p_pkg_name => 'csi_item_instance_pub',
3743: p_api_name => 'create_item_instance');

Line 3741: csi_t_gen_utility_pvt.dump_api_info(

3737: l_current_procedure := 'create_item_instance';
3738:
3739: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);
3740:
3741: csi_t_gen_utility_pvt.dump_api_info(
3742: p_pkg_name => 'csi_item_instance_pub',
3743: p_api_name => 'create_item_instance');
3744:
3745: /* non serial destination instance create */

Line 3854: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_u_instance_rec);

3850:
3851: -- update item instance
3852: l_current_procedure := 'update_item_instance';
3853:
3854: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_u_instance_rec);
3855:
3856: csi_t_gen_utility_pvt.dump_api_info(
3857: p_pkg_name => 'csi_item_instance_pub',
3858: p_api_name => 'update_item_instance');

Line 3856: csi_t_gen_utility_pvt.dump_api_info(

3852: l_current_procedure := 'update_item_instance';
3853:
3854: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_u_instance_rec);
3855:
3856: csi_t_gen_utility_pvt.dump_api_info(
3857: p_pkg_name => 'csi_item_instance_pub',
3858: p_api_name => 'update_item_instance');
3859:
3860: /* non serial destination instance update */

Line 3953: csi_t_gen_utility_pvt.dump_api_info(

3949: l_u_ea_values_tbl.DELETE;
3950: l_u_pricing_tbl.DELETE;
3951: l_u_assets_tbl.DELETE;
3952:
3953: csi_t_gen_utility_pvt.dump_api_info(
3954: p_pkg_name => 'csi_item_instance_pub',
3955: p_api_name => 'update_item_instance');
3956:
3957: -- decrement inv instance for OUT transactions

Line 4061: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);

4057: END IF;
4058:
4059: l_current_procedure := 'create_item_instance';
4060:
4061: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);
4062:
4063: csi_t_gen_utility_pvt.dump_api_info(
4064: p_pkg_name => 'csi_item_instance_pub',
4065: p_api_name => 'create_item_instance');

Line 4063: csi_t_gen_utility_pvt.dump_api_info(

4059: l_current_procedure := 'create_item_instance';
4060:
4061: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);
4062:
4063: csi_t_gen_utility_pvt.dump_api_info(
4064: p_pkg_name => 'csi_item_instance_pub',
4065: p_api_name => 'create_item_instance');
4066:
4067: csi_item_instance_pub.create_item_instance(

Line 4143: csi_t_gen_utility_pvt.dump_api_info(

4139: x_return_status => l_return_status);
4140:
4141: END IF;
4142:
4143: csi_t_gen_utility_pvt.dump_api_info(
4144: p_pkg_name => 'csi_item_instance_pub',
4145: p_api_name => 'update_item_instance');
4146:
4147: csi_item_instance_pub.update_item_instance(

Line 4268: csi_t_gen_utility_pvt.dump_txn_ii_rltns_rec(

4264: l_ii_rltns_rec.object_version_number := p_txn_ii_rltns_rec.object_version_number;
4265:
4266: x_ii_rltns_rec := l_ii_rltns_rec;
4267:
4268: csi_t_gen_utility_pvt.dump_txn_ii_rltns_rec(
4269: p_txn_ii_rltns_rec => p_txn_ii_rltns_rec);
4270:
4271: EXCEPTION
4272: WHEN fnd_api.g_exc_error THEN

Line 4304: csi_t_gen_utility_pvt.dump_api_info(

4300:
4301:
4302: BEGIN
4303:
4304: csi_t_gen_utility_pvt.dump_api_info(
4305: p_pkg_name => g_pkg_name,
4306: p_api_name => 'process_relation');
4307:
4308: x_return_status := fnd_api.g_ret_sts_success;

Line 4573: csi_t_gen_utility_pvt.dump_api_info(

4569:
4570: l_relationship_query_rec.subject_id := p_instance_id;
4571: l_relationship_query_rec.relationship_type_code := 'COMPONENT-OF';
4572:
4573: csi_t_gen_utility_pvt.dump_api_info(
4574: p_pkg_name => 'csi_ii_relationships_pub',
4575: p_api_name => 'get_relationships');
4576:
4577: csi_ii_relationships_pub.get_relationships(

Line 4606: csi_t_gen_utility_pvt.dump_api_info(

4602: l_relationship_tbl(l_ind).relationship_id;
4603: l_exp_relationship_rec.object_version_number :=
4604: l_relationship_tbl(l_ind).object_version_number;
4605:
4606: csi_t_gen_utility_pvt.dump_api_info(
4607: p_pkg_name => 'csi_ii_relationships_pub',
4608: p_api_name => 'expire_relationship');
4609:
4610: debug(' relationship id :'||l_exp_relationship_rec.relationship_id);