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 167: csi_t_gen_utility_pvt.dump_api_info(

163: l_reference_found boolean;
164: l_reference_code varchar2(30);
165: BEGIN
166:
167: csi_t_gen_utility_pvt.dump_api_info(
168: p_pkg_name => g_pkg_name,
169: p_api_name => 'validate_reference');
170:
171: l_reference_found := FALSE;

Line 226: csi_t_gen_utility_pvt.dump_api_info(

222: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
223:
224: BEGIN
225:
226: csi_t_gen_utility_pvt.dump_api_info(
227: p_pkg_name => g_pkg_name,
228: p_api_name => 'validate_owner_reference');
229:
230: x_return_status := fnd_api.g_ret_sts_success;

Line 309: csi_t_gen_utility_pvt.dump_api_info(

305: BEGIN
306:
307: x_return_status := fnd_api.g_ret_sts_success;
308:
309: csi_t_gen_utility_pvt.dump_api_info(
310: p_pkg_name => g_pkg_name,
311: p_api_name => 'sub_type_validations');
312:
313: debug('Transaction type ID: '||p_sub_type_rec.transaction_type_id);

Line 418: csi_t_gen_utility_pvt.dump_api_info(

414: l_bom_item_type mtl_system_items.bom_item_type%TYPE;
415:
416: BEGIN
417:
418: csi_t_gen_utility_pvt.dump_api_info(
419: p_pkg_name => g_pkg_name,
420: p_api_name => 'get_item_attributes');
421:
422: x_return_status := fnd_api.g_ret_sts_success;

Line 533: csi_t_gen_utility_pvt.dump_api_info(

529: x_return_status OUT NOCOPY varchar2)
530: IS
531: BEGIN
532:
533: csi_t_gen_utility_pvt.dump_api_info(
534: p_pkg_name => g_pkg_name,
535: p_api_name => 'validate_instance_rec');
536:
537: x_return_status := fnd_api.g_ret_sts_success;

Line 622: csi_t_gen_utility_pvt.dump_api_info(

618: BEGIN
619:
620: x_return_status := fnd_api.g_ret_sts_success;
621:
622: csi_t_gen_utility_pvt.dump_api_info(
623: p_pkg_name => g_pkg_name,
624: p_api_name => 'build_instance_query_rec');
625:
626: l_inst_query_rec.inventory_item_id := p_instance_rec.inventory_item_id;

Line 696: csi_t_gen_utility_pvt.dump_instance_query_rec(

692: x_instance_query_rec := l_inst_query_rec;
693:
694: debug('Instance query criteria for '||p_query_criteria);
695:
696: csi_t_gen_utility_pvt.dump_instance_query_rec(
697: p_instance_query_rec => x_instance_query_rec);
698:
699: EXCEPTION
700: WHEN fnd_api.g_exc_error THEN

Line 791: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);

787: l_parties_tbl(1).party_id := l_internal_party_id;
788: l_parties_tbl(1).relationship_type_code:= 'OWNER';
789: l_parties_tbl(1).contact_flag := 'N';
790:
791: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);
792:
793: csi_t_gen_utility_pvt.dump_api_info(
794: p_pkg_name => 'csi_item_instance_pub',
795: p_api_name => 'create_item_instance');

Line 793: csi_t_gen_utility_pvt.dump_api_info(

789: l_parties_tbl(1).contact_flag := 'N';
790:
791: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);
792:
793: csi_t_gen_utility_pvt.dump_api_info(
794: p_pkg_name => 'csi_item_instance_pub',
795: p_api_name => 'create_item_instance');
796:
797: -- creation of zero quantity instance

Line 829: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_u_instance_rec);

825: l_u_instance_rec.instance_id := l_instance_rec.instance_id;
826: l_u_instance_rec.quantity := 0;
827: l_u_instance_rec.object_version_number := l_instance_rec.object_version_number;
828:
829: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_u_instance_rec);
830:
831: csi_t_gen_utility_pvt.dump_api_info(
832: p_pkg_name => 'csi_item_instance_pub',
833: p_api_name => 'update_item_instance');

Line 831: csi_t_gen_utility_pvt.dump_api_info(

827: l_u_instance_rec.object_version_number := l_instance_rec.object_version_number;
828:
829: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_u_instance_rec);
830:
831: csi_t_gen_utility_pvt.dump_api_info(
832: p_pkg_name => 'csi_item_instance_pub',
833: p_api_name => 'update_item_instance');
834:
835: -- update to make a zero quantity instance

Line 901: csi_t_gen_utility_pvt.dump_api_info(

897: l_msg_data varchar2(2000);
898:
899: BEGIN
900:
901: csi_t_gen_utility_pvt.dump_api_info(
902: p_pkg_name => g_pkg_name,
903: p_api_name => 'get_src_instance_id');
904:
905: x_return_status := fnd_api.g_ret_sts_success;

Line 1164: csi_t_gen_utility_pvt.dump_api_info(

1160: l_msg_data varchar2(2000);
1161:
1162: BEGIN
1163:
1164: csi_t_gen_utility_pvt.dump_api_info(
1165: p_pkg_name => g_pkg_name,
1166: p_api_name => 'get_dest_instance_id');
1167:
1168: x_return_status := fnd_api.g_ret_sts_success;

Line 1184: csi_t_gen_utility_pvt.dump_api_info(

1180: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1181: RAISE fnd_api.g_exc_error;
1182: END IF;
1183:
1184: csi_t_gen_utility_pvt.dump_api_info(
1185: p_pkg_name => 'csi_item_instance_pub',
1186: p_api_name => 'get_item_instances');
1187:
1188: csi_item_instance_pub.get_item_instances(

Line 1408: csi_t_gen_utility_pvt.dump_txn_i_party_rec(

1404:
1405: IF p_i_parties_tbl(l_ind).parent_tbl_index = p_instance_index THEN
1406:
1407: /* debug messages */
1408: csi_t_gen_utility_pvt.dump_txn_i_party_rec(
1409: p_txn_i_party_rec => p_i_parties_tbl(l_ind));
1410:
1411: c_ind := c_ind + 1;
1412:

Line 1448: csi_t_gen_utility_pvt.dump_txn_ip_account_rec(

1444:
1445: IF p_ip_accounts_tbl(l_a_ind).parent_tbl_index = l_ind THEN
1446:
1447: /* debug messages */
1448: csi_t_gen_utility_pvt.dump_txn_ip_account_rec(
1449: p_txn_ip_account_rec => p_ip_accounts_tbl(l_a_ind));
1450:
1451: c_a_ind := c_a_ind + 1;
1452:

Line 1520: csi_t_gen_utility_pvt.dump_txn_eav_rec(

1516: LOOP
1517: IF p_ext_attrib_vals_tbl(l_ind).parent_tbl_index = p_instance_index THEN
1518:
1519: /* debug messages */
1520: csi_t_gen_utility_pvt.dump_txn_eav_rec(
1521: p_txn_eav_rec => p_ext_attrib_vals_tbl(l_ind));
1522:
1523: c_ind := c_ind + 1;
1524:

Line 1580: csi_t_gen_utility_pvt.dump_txn_price_rec(

1576: LOOP
1577: IF p_pricing_attribs_tbl(l_ind).parent_tbl_index = p_instance_index THEN
1578:
1579: /* debug messages */
1580: csi_t_gen_utility_pvt.dump_txn_price_rec(
1581: p_txn_price_rec => p_pricing_attribs_tbl(l_ind));
1582:
1583: c_ind := c_ind + 1;
1584:

Line 1740: csi_t_gen_utility_pvt.dump_txn_org_unit_rec(

1736: LOOP
1737: IF p_org_units_tbl(l_ind).parent_tbl_index = p_instance_index THEN
1738:
1739: /* debug messages */
1740: csi_t_gen_utility_pvt.dump_txn_org_unit_rec(
1741: p_txn_org_unit_rec => p_org_units_tbl(l_ind));
1742:
1743: c_ind := c_ind + 1;
1744:

Line 1800: csi_t_gen_utility_pvt.dump_txn_asset_rec(

1796: LOOP
1797: IF p_instance_asset_tbl(l_ind).parent_tbl_index = p_instance_index THEN
1798:
1799: /* debug messages */
1800: csi_t_gen_utility_pvt.dump_txn_asset_rec(
1801: p_txn_asset_rec => p_instance_asset_tbl(l_ind));
1802:
1803: c_ind := c_ind + 1;
1804:

Line 2144: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_u_instance_rec);

2140: INTO l_u_instance_rec.object_version_number
2141: FROM csi_item_instances
2142: WHERE instance_id = l_u_instance_rec.instance_id;
2143:
2144: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_u_instance_rec);
2145:
2146: csi_t_gen_utility_pvt.dump_api_info(
2147: p_pkg_name => 'csi_item_instance_pub',
2148: p_api_name => 'update_item_instance');

Line 2146: csi_t_gen_utility_pvt.dump_api_info(

2142: WHERE instance_id = l_u_instance_rec.instance_id;
2143:
2144: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_u_instance_rec);
2145:
2146: csi_t_gen_utility_pvt.dump_api_info(
2147: p_pkg_name => 'csi_item_instance_pub',
2148: p_api_name => 'update_item_instance');
2149:
2150: -- unexpire instance call.

Line 2358: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;

2354:
2355: BEGIN
2356:
2357: x_return_status := fnd_api.g_ret_sts_success;
2358: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
2359:
2360: /* debug messages */
2361:
2362: csi_t_gen_utility_pvt.dump_api_info(

Line 2362: csi_t_gen_utility_pvt.dump_api_info(

2358: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
2359:
2360: /* debug messages */
2361:
2362: csi_t_gen_utility_pvt.dump_api_info(
2363: p_pkg_name => g_pkg_name,
2364: p_api_name => 'process_ib');
2365:
2366: debug('Processing record no. '||p_instance_index||' from the instances tbl.');

Line 2370: csi_t_gen_utility_pvt.dump_txn_instance_rec(

2366: debug('Processing record no. '||p_instance_index||' from the instances tbl.');
2367:
2368: IF l_debug_level > 1 THEN
2369:
2370: csi_t_gen_utility_pvt.dump_txn_instance_rec(
2371: p_txn_instance_rec => p_instance_rec);
2372:
2373: csi_t_gen_utility_pvt.dump_dest_location_rec(
2374: p_dest_location_rec => p_dest_location_rec);

Line 2373: csi_t_gen_utility_pvt.dump_dest_location_rec(

2369:
2370: csi_t_gen_utility_pvt.dump_txn_instance_rec(
2371: p_txn_instance_rec => p_instance_rec);
2372:
2373: csi_t_gen_utility_pvt.dump_dest_location_rec(
2374: p_dest_location_rec => p_dest_location_rec);
2375:
2376: END IF;
2377:

Line 2491: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);

2487: l_instance_rec.operational_status_code := p_dest_location_rec.operational_status_code;
2488:
2489: l_current_procedure := 'create_item_instance';
2490:
2491: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);
2492:
2493: csi_t_gen_utility_pvt.dump_api_info(
2494: p_pkg_name => 'csi_item_instance_pub',
2495: p_api_name => 'create_item_instance');

Line 2493: csi_t_gen_utility_pvt.dump_api_info(

2489: l_current_procedure := 'create_item_instance';
2490:
2491: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);
2492:
2493: csi_t_gen_utility_pvt.dump_api_info(
2494: p_pkg_name => 'csi_item_instance_pub',
2495: p_api_name => 'create_item_instance');
2496:
2497: -- create destination instance (when there is only creation of destination)

Line 2584: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);

2580: END IF;
2581:
2582: l_current_procedure := 'create_item_instance';
2583:
2584: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);
2585:
2586: csi_t_gen_utility_pvt.dump_api_info(
2587: p_pkg_name => 'csi_item_instance_pub',
2588: p_api_name => 'create_item_instance');

Line 2586: csi_t_gen_utility_pvt.dump_api_info(

2582: l_current_procedure := 'create_item_instance';
2583:
2584: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);
2585:
2586: csi_t_gen_utility_pvt.dump_api_info(
2587: p_pkg_name => 'csi_item_instance_pub',
2588: p_api_name => 'create_item_instance');
2589:
2590: csi_item_instance_pub.create_item_instance(

Line 2703: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);

2699: END IF;
2700:
2701: l_current_procedure := 'update_item_instance';
2702:
2703: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);
2704:
2705: csi_t_gen_utility_pvt.dump_api_info(
2706: p_pkg_name => 'csi_item_instance_pub',
2707: p_api_name => 'update_item_instance');

Line 2705: csi_t_gen_utility_pvt.dump_api_info(

2701: l_current_procedure := 'update_item_instance';
2702:
2703: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);
2704:
2705: csi_t_gen_utility_pvt.dump_api_info(
2706: p_pkg_name => 'csi_item_instance_pub',
2707: p_api_name => 'update_item_instance');
2708:
2709: -- destination update for IN and INT

Line 2921: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);

2917: WHERE instance_id = l_instance_rec.instance_id;
2918:
2919: l_current_procedure := 'update_item_instance';
2920:
2921: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);
2922:
2923: csi_t_gen_utility_pvt.dump_api_info(
2924: p_pkg_name => 'csi_item_instance_pub',
2925: p_api_name => 'update_item_instance');

Line 2923: csi_t_gen_utility_pvt.dump_api_info(

2919: l_current_procedure := 'update_item_instance';
2920:
2921: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);
2922:
2923: csi_t_gen_utility_pvt.dump_api_info(
2924: p_pkg_name => 'csi_item_instance_pub',
2925: p_api_name => 'update_item_instance');
2926:
2927: -- serialized update at dest

Line 3259: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_u_instance_rec);

3255: debug(' src_inst_ovn : '||l_object_version_number);
3256: debug(' src_inst_qty : '||l_src_instance_qty);
3257: debug(' txn_qty : '||p_instance_rec.quantity);
3258:
3259: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_u_instance_rec);
3260:
3261: l_current_procedure := 'update_item_instance';
3262:
3263: csi_t_gen_utility_pvt.dump_api_info(

Line 3263: csi_t_gen_utility_pvt.dump_api_info(

3259: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_u_instance_rec);
3260:
3261: l_current_procedure := 'update_item_instance';
3262:
3263: csi_t_gen_utility_pvt.dump_api_info(
3264: p_pkg_name => 'csi_item_instance_pub',
3265: p_api_name => 'update_item_instance');
3266:
3267: /* source instance update for srl at so issue and non serial */

Line 3398: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);

3394: END IF;
3395:
3396: l_current_procedure := 'create_item_instance';
3397:
3398: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);
3399:
3400: csi_t_gen_utility_pvt.dump_api_info(
3401: p_pkg_name => 'csi_item_instance_pub',
3402: p_api_name => 'create_item_instance');

Line 3400: csi_t_gen_utility_pvt.dump_api_info(

3396: l_current_procedure := 'create_item_instance';
3397:
3398: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);
3399:
3400: csi_t_gen_utility_pvt.dump_api_info(
3401: p_pkg_name => 'csi_item_instance_pub',
3402: p_api_name => 'create_item_instance');
3403:
3404: /* non serial destination instance create */

Line 3490: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_u_instance_rec);

3486:
3487: -- update item instance
3488: l_current_procedure := 'update_item_instance';
3489:
3490: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_u_instance_rec);
3491:
3492: csi_t_gen_utility_pvt.dump_api_info(
3493: p_pkg_name => 'csi_item_instance_pub',
3494: p_api_name => 'update_item_instance');

Line 3492: csi_t_gen_utility_pvt.dump_api_info(

3488: l_current_procedure := 'update_item_instance';
3489:
3490: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_u_instance_rec);
3491:
3492: csi_t_gen_utility_pvt.dump_api_info(
3493: p_pkg_name => 'csi_item_instance_pub',
3494: p_api_name => 'update_item_instance');
3495:
3496: /* non serial destination instance update */

Line 3589: csi_t_gen_utility_pvt.dump_api_info(

3585: l_u_ea_values_tbl.DELETE;
3586: l_u_pricing_tbl.DELETE;
3587: l_u_assets_tbl.DELETE;
3588:
3589: csi_t_gen_utility_pvt.dump_api_info(
3590: p_pkg_name => 'csi_item_instance_pub',
3591: p_api_name => 'update_item_instance');
3592:
3593: -- decrement inv instance for OUT transactions

Line 3697: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);

3693: END IF;
3694:
3695: l_current_procedure := 'create_item_instance';
3696:
3697: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);
3698:
3699: csi_t_gen_utility_pvt.dump_api_info(
3700: p_pkg_name => 'csi_item_instance_pub',
3701: p_api_name => 'create_item_instance');

Line 3699: csi_t_gen_utility_pvt.dump_api_info(

3695: l_current_procedure := 'create_item_instance';
3696:
3697: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_instance_rec);
3698:
3699: csi_t_gen_utility_pvt.dump_api_info(
3700: p_pkg_name => 'csi_item_instance_pub',
3701: p_api_name => 'create_item_instance');
3702:
3703: csi_item_instance_pub.create_item_instance(

Line 3779: csi_t_gen_utility_pvt.dump_api_info(

3775: x_return_status => l_return_status);
3776:
3777: END IF;
3778:
3779: csi_t_gen_utility_pvt.dump_api_info(
3780: p_pkg_name => 'csi_item_instance_pub',
3781: p_api_name => 'update_item_instance');
3782:
3783: csi_item_instance_pub.update_item_instance(

Line 3904: csi_t_gen_utility_pvt.dump_txn_ii_rltns_rec(

3900: l_ii_rltns_rec.object_version_number := p_txn_ii_rltns_rec.object_version_number;
3901:
3902: x_ii_rltns_rec := l_ii_rltns_rec;
3903:
3904: csi_t_gen_utility_pvt.dump_txn_ii_rltns_rec(
3905: p_txn_ii_rltns_rec => p_txn_ii_rltns_rec);
3906:
3907: EXCEPTION
3908: WHEN fnd_api.g_exc_error THEN

Line 3940: csi_t_gen_utility_pvt.dump_api_info(

3936:
3937:
3938: BEGIN
3939:
3940: csi_t_gen_utility_pvt.dump_api_info(
3941: p_pkg_name => g_pkg_name,
3942: p_api_name => 'process_relation');
3943:
3944: x_return_status := fnd_api.g_ret_sts_success;

Line 4209: csi_t_gen_utility_pvt.dump_api_info(

4205:
4206: l_relationship_query_rec.subject_id := p_instance_id;
4207: l_relationship_query_rec.relationship_type_code := 'COMPONENT-OF';
4208:
4209: csi_t_gen_utility_pvt.dump_api_info(
4210: p_pkg_name => 'csi_ii_relationships_pub',
4211: p_api_name => 'get_relationships');
4212:
4213: csi_ii_relationships_pub.get_relationships(

Line 4242: csi_t_gen_utility_pvt.dump_api_info(

4238: l_relationship_tbl(l_ind).relationship_id;
4239: l_exp_relationship_rec.object_version_number :=
4240: l_relationship_tbl(l_ind).object_version_number;
4241:
4242: csi_t_gen_utility_pvt.dump_api_info(
4243: p_pkg_name => 'csi_ii_relationships_pub',
4244: p_api_name => 'expire_relationship');
4245:
4246: debug(' relationship id :'||l_exp_relationship_rec.relationship_id);