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_UTL_PKG dependencies on CSI_UTL_PKG

Line 1: PACKAGE BODY csi_utl_pkg as

1: PACKAGE BODY csi_utl_pkg as
2: /* $Header: csiutlb.pls 120.21 2007/10/20 01:20:15 fli ship $ */
3:
4: /*----------------------------------------------------------*/
5: /* Package Name : csi_utl_pkg */

Line 5: /* Package Name : csi_utl_pkg */

1: PACKAGE BODY csi_utl_pkg as
2: /* $Header: csiutlb.pls 120.21 2007/10/20 01:20:15 fli ship $ */
3:
4: /*----------------------------------------------------------*/
5: /* Package Name : csi_utl_pkg */
6: /* Description : used by the order shipment interface */
7: /* to do the validations */
8: /*----------------------------------------------------------*/
9:

Line 10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'csi_utl_pkg';

6: /* Description : used by the order shipment interface */
7: /* to do the validations */
8: /*----------------------------------------------------------*/
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'csi_utl_pkg';
11: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csiutlb.pls';
12:
13: PROCEDURE debug(
14: p_message IN VARCHAR2)

Line 25: csi_order_ship_pub.g_api_name := 'csi_utl_pkg.'||p_api_name;

21: p_api_name IN VARCHAR2)
22: IS
23: BEGIN
24:
25: csi_order_ship_pub.g_api_name := 'csi_utl_pkg.'||p_api_name;
26:
27: csi_t_gen_utility_pvt.dump_api_info(
28: p_pkg_name => 'csi_utl_pkg',
29: p_api_name => p_api_name);

Line 28: p_pkg_name => 'csi_utl_pkg',

24:
25: csi_order_ship_pub.g_api_name := 'csi_utl_pkg.'||p_api_name;
26:
27: csi_t_gen_utility_pvt.dump_api_info(
28: p_pkg_name => 'csi_utl_pkg',
29: p_api_name => p_api_name);
30:
31: END api_log;
32:

Line 929: l_inst_party_id := csi_utl_pkg.get_instance_party_id(l_instance_id);

925: x_txn_line_dtl_rec.active_start_date := sysdate;
926: x_txn_line_dtl_rec.object_version_number := 1 ;
927: x_txn_line_dtl_rec.preserve_detail_flag := 'Y';
928:
929: l_inst_party_id := csi_utl_pkg.get_instance_party_id(l_instance_id);
930: IF l_inst_party_id = -1 THEN
931: debug('get_instance_party_id failed');
932: RAISE fnd_api.g_exc_error;
933: END IF;

Line 949: l_ip_account_id := csi_utl_pkg.get_ip_account_id(l_inst_party_id);

945:
946: /* get ip_account_id only if inst_party_id does not exist */
947:
948: IF l_inst_party_id is not null THEN
949: l_ip_account_id := csi_utl_pkg.get_ip_account_id(l_inst_party_id);
950: IF l_ip_account_id = -1 THEN
951: l_ip_account_id := NULL;
952: debug('Party account not found for instance ');
953: END IF;

Line 1095: l_inst_party_id := csi_utl_pkg.get_instance_party_id(l_instance_id);

1091: x_txn_line_dtl_rec.active_start_date := sysdate;
1092: x_txn_line_dtl_rec.object_version_number := 1 ;
1093: x_txn_line_dtl_rec.preserve_detail_flag := 'Y';
1094:
1095: l_inst_party_id := csi_utl_pkg.get_instance_party_id(l_instance_id);
1096:
1097: IF l_inst_party_id = -1 THEN
1098: debug('get_instance_party_id failed');
1099: RAISE fnd_api.g_exc_error;

Line 1116: l_ip_account_id := csi_utl_pkg.get_ip_account_id(l_inst_party_id);

1112:
1113: /* get ip_account_id only if inst_party_id does not exist */
1114:
1115: IF l_inst_party_id is not null THEN
1116: l_ip_account_id := csi_utl_pkg.get_ip_account_id(l_inst_party_id);
1117:
1118: /* If ip_account_id is -1 then account does not exist in IB */
1119:
1120: IF l_ip_account_id = -1 THEN

Line 2710: csi_utl_pkg.derive_party_id(

2706: AND
2707: nvl(p_order_line_rec.ship_to_contact_id, fnd_api.g_miss_num ) <> fnd_api.g_miss_num
2708: THEN
2709:
2710: csi_utl_pkg.derive_party_id(
2711: p_cust_acct_role_id => p_order_line_rec.ship_to_contact_id,
2712: x_party_id => l_contact_party_id,
2713: x_return_status => x_return_status );
2714:

Line 2760: csi_utl_pkg.derive_party_id(

2756: AND
2757: nvl(p_order_line_rec.invoice_to_contact_id, fnd_api.g_miss_num ) <> fnd_api.g_miss_num
2758: THEN
2759:
2760: csi_utl_pkg.derive_party_id(
2761: p_cust_acct_role_id => p_order_line_rec.invoice_to_contact_id,
2762: x_party_id => l_contact_party_id,
2763: x_return_status => x_return_status );
2764:

Line 3002: l_primary_uom := csi_utl_pkg.get_primay_uom(

2998:
2999: /* Initialize API return status to success */
3000: x_return_status := fnd_api.g_ret_sts_success;
3001:
3002: l_primary_uom := csi_utl_pkg.get_primay_uom(
3003: p_inv_item_id => p_inventory_item_id,
3004: p_inv_org_id => p_inv_organization_id);
3005:
3006: debug('Primary UOM :'||l_primary_uom);

Line 3899: l_obj_ver_num := csi_utl_pkg.get_org_obj_ver_num(

3895:
3896: IF NVL(l_instance_ou_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM then
3897:
3898: /* if the instance_ou_id does not exist then update for org_units */
3899: l_obj_ver_num := csi_utl_pkg.get_org_obj_ver_num(
3900: l_instance_ou_id);
3901:
3902: IF l_obj_ver_num = -1 THEN
3903: debug('csi_utl_pkg.get_org_obj_ver_num failed ');

Line 3903: debug('csi_utl_pkg.get_org_obj_ver_num failed ');

3899: l_obj_ver_num := csi_utl_pkg.get_org_obj_ver_num(
3900: l_instance_ou_id);
3901:
3902: IF l_obj_ver_num = -1 THEN
3903: debug('csi_utl_pkg.get_org_obj_ver_num failed ');
3904: RAISE fnd_api.g_exc_error;
3905: END IF;
3906:
3907: x_upd_org_units_tbl(l_upd_org).instance_ou_id := l_instance_ou_id;

Line 4032: l_obj_ver_num := csi_utl_pkg.get_ext_obj_ver_num(

4028:
4029: l_cre_ext := l_cre_ext + 1;
4030: ELSIF (p_txn_ext_attrib_vals_tbl(j).attrib_source_table = 'CSI_IEA_VALUES') THEN
4031:
4032: l_obj_ver_num := csi_utl_pkg.get_ext_obj_ver_num(
4033: p_txn_ext_attrib_vals_tbl(j).attribute_source_id);
4034:
4035: IF l_obj_ver_num = -1 THEN
4036: debug('csi_utl_pkg.get_ext_obj_ver_num failed ');

Line 4036: debug('csi_utl_pkg.get_ext_obj_ver_num failed ');

4032: l_obj_ver_num := csi_utl_pkg.get_ext_obj_ver_num(
4033: p_txn_ext_attrib_vals_tbl(j).attribute_source_id);
4034:
4035: IF l_obj_ver_num = -1 THEN
4036: debug('csi_utl_pkg.get_ext_obj_ver_num failed ');
4037: RAISE fnd_api.g_exc_error;
4038: END IF;
4039:
4040: x_upd_ext_attrib_val_tbl(l_upd_ext).attribute_value_id := p_txn_ext_attrib_vals_tbl(j).attribute_source_id;

Line 4677: l_obj_ver_num := csi_utl_pkg.get_ii_obj_ver_num(

4673: THEN
4674:
4675: /* Build the table for updating the instance relationship */
4676:
4677: l_obj_ver_num := csi_utl_pkg.get_ii_obj_ver_num(
4678: x_txn_ii_rltns_tbl(j).csi_inst_relationship_id);
4679:
4680: IF l_obj_ver_num = -1 THEN
4681: RAISE fnd_api.g_exc_error;

Line 5206: csi_utl_pkg.get_org_assign(

5202: LOOP
5203:
5204: l_upd_ou_tbl(l_upd_org) := x_upd_org_units_tbl(l_upd_org);
5205:
5206: csi_utl_pkg.get_org_assign(
5207: p_instance_id => l_instance_id ,
5208: p_operating_unit_id => x_upd_org_units_tbl(l_upd_org).operating_unit_id,
5209: p_rel_type_code => x_upd_org_units_tbl(l_upd_org).relationship_type_code,
5210: x_instance_ou_id => l_instance_ou_id,

Line 5230: csi_utl_pkg.get_ext_attribs(

5226: IF x_upd_ext_attrib_val_tbl.count > 0 THEN
5227: FOR l_upd_ext in x_upd_ext_attrib_val_tbl.first..x_upd_ext_attrib_val_tbl.last
5228: LOOP
5229:
5230: csi_utl_pkg.get_ext_attribs(
5231: p_instance_id => l_instance_id ,
5232: p_attribute_id => x_upd_ext_attrib_val_tbl(l_upd_ext).attribute_id,
5233: x_attribute_value_id => l_attrib_value_id,
5234: x_obj_version_number => l_av_obj_ver_num,

Line 5624: l_obj_ver_num := csi_utl_pkg.get_pty_obj_ver_num(

5620: l_cre_pty := l_cre_pty + 1;
5621:
5622: ELSE
5623:
5624: l_obj_ver_num := csi_utl_pkg.get_pty_obj_ver_num(
5625: p_txn_party_detail_tbl(j).instance_party_id);
5626:
5627: IF l_obj_ver_num = -1 THEN
5628: RAISE fnd_api.g_exc_error;

Line 6523: px_txn_ps_tbl IN OUT NOCOPY csi_utl_pkg.txn_ps_tbl,

6519: PROCEDURE distribute_instances(
6520: p_quantity_ratio IN number,
6521: p_model_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
6522: px_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl,
6523: px_txn_ps_tbl IN OUT NOCOPY csi_utl_pkg.txn_ps_tbl,
6524: x_return_status OUT NOCOPY varchar2)
6525: IS
6526:
6527: l_txn_type_id number := csi_order_ship_pub.g_txn_type_id;

Line 6981: l_txn_ps_tbl csi_utl_pkg.txn_ps_tbl;

6977: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
6978: l_msg_data varchar2(512);
6979: l_msg_count number;
6980:
6981: l_txn_ps_tbl csi_utl_pkg.txn_ps_tbl;
6982:
6983: --fix for bug5096435
6984: l_order_line_qty number;
6985: l_temp_line_rec oe_order_pub.Line_Rec_Type;

Line 7277: px_item_control_rec.primary_uom_code := csi_utl_pkg.get_primay_uom(

7273: x_return_status := fnd_api.g_ret_sts_success;
7274:
7275: IF nvl(px_item_control_rec.primary_uom_code, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
7276:
7277: px_item_control_rec.primary_uom_code := csi_utl_pkg.get_primay_uom(
7278: p_inv_item_id => px_item_control_rec.inventory_item_id,
7279: p_inv_org_id => px_item_control_rec.organization_id);
7280:
7281: END IF;

Line 7305: END csi_utl_pkg ;

7301: WHEN fnd_api.g_exc_error THEN
7302: x_return_status := fnd_api.g_ret_sts_error;
7303: END get_unit_price_in_primary_uom;
7304:
7305: END csi_utl_pkg ;