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.27.12020000.8 2012/11/09 07:20:52 mvaradam 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.27.12020000.8 2012/11/09 07:20:52 mvaradam 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 2750: csi_utl_pkg.derive_party_id(

2746: AND
2747: nvl(p_order_line_rec.ship_to_contact_id, fnd_api.g_miss_num ) <> fnd_api.g_miss_num
2748: THEN
2749:
2750: csi_utl_pkg.derive_party_id(
2751: p_cust_acct_role_id => p_order_line_rec.ship_to_contact_id,
2752: x_party_id => l_contact_party_id,
2753: x_return_status => x_return_status );
2754:

Line 2801: csi_utl_pkg.derive_party_id(

2797: AND
2798: nvl(p_order_line_rec.invoice_to_contact_id, fnd_api.g_miss_num ) <> fnd_api.g_miss_num
2799: THEN
2800:
2801: csi_utl_pkg.derive_party_id(
2802: p_cust_acct_role_id => p_order_line_rec.invoice_to_contact_id,
2803: x_party_id => l_contact_party_id,
2804: x_return_status => x_return_status );
2805:

Line 3044: l_primary_uom := csi_utl_pkg.get_primay_uom(

3040:
3041: /* Initialize API return status to success */
3042: x_return_status := fnd_api.g_ret_sts_success;
3043:
3044: l_primary_uom := csi_utl_pkg.get_primay_uom(
3045: p_inv_item_id => p_inventory_item_id,
3046: p_inv_org_id => p_inv_organization_id);
3047:
3048: debug('Primary UOM :'||l_primary_uom);

Line 3941: l_obj_ver_num := csi_utl_pkg.get_org_obj_ver_num(

3937:
3938: IF NVL(l_instance_ou_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM then
3939:
3940: /* if the instance_ou_id does not exist then update for org_units */
3941: l_obj_ver_num := csi_utl_pkg.get_org_obj_ver_num(
3942: l_instance_ou_id);
3943:
3944: IF l_obj_ver_num = -1 THEN
3945: debug('csi_utl_pkg.get_org_obj_ver_num failed ');

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

3941: l_obj_ver_num := csi_utl_pkg.get_org_obj_ver_num(
3942: l_instance_ou_id);
3943:
3944: IF l_obj_ver_num = -1 THEN
3945: debug('csi_utl_pkg.get_org_obj_ver_num failed ');
3946: RAISE fnd_api.g_exc_error;
3947: END IF;
3948:
3949: x_upd_org_units_tbl(l_upd_org).instance_ou_id := l_instance_ou_id;

Line 4074: l_obj_ver_num := csi_utl_pkg.get_ext_obj_ver_num(

4070:
4071: l_cre_ext := l_cre_ext + 1;
4072: ELSIF (p_txn_ext_attrib_vals_tbl(j).attrib_source_table = 'CSI_IEA_VALUES') THEN
4073:
4074: l_obj_ver_num := csi_utl_pkg.get_ext_obj_ver_num(
4075: p_txn_ext_attrib_vals_tbl(j).attribute_source_id);
4076:
4077: IF l_obj_ver_num = -1 THEN
4078: debug('csi_utl_pkg.get_ext_obj_ver_num failed ');

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

4074: l_obj_ver_num := csi_utl_pkg.get_ext_obj_ver_num(
4075: p_txn_ext_attrib_vals_tbl(j).attribute_source_id);
4076:
4077: IF l_obj_ver_num = -1 THEN
4078: debug('csi_utl_pkg.get_ext_obj_ver_num failed ');
4079: RAISE fnd_api.g_exc_error;
4080: END IF;
4081:
4082: x_upd_ext_attrib_val_tbl(l_upd_ext).attribute_value_id := p_txn_ext_attrib_vals_tbl(j).attribute_source_id;

Line 4719: l_obj_ver_num := csi_utl_pkg.get_ii_obj_ver_num(

4715: THEN
4716:
4717: /* Build the table for updating the instance relationship */
4718:
4719: l_obj_ver_num := csi_utl_pkg.get_ii_obj_ver_num(
4720: x_txn_ii_rltns_tbl(j).csi_inst_relationship_id);
4721:
4722: IF l_obj_ver_num = -1 THEN
4723: RAISE fnd_api.g_exc_error;

Line 5277: csi_utl_pkg.get_org_assign(

5273: -- End of Code Addition for the bug 8309196
5274:
5275: l_upd_ou_tbl(l_uou_ind) := x_upd_org_units_tbl(l_upd_org); -- Modified for the bug 8309196
5276:
5277: csi_utl_pkg.get_org_assign(
5278: p_instance_id => l_instance_id ,
5279: p_operating_unit_id => x_upd_org_units_tbl(l_upd_org).operating_unit_id,
5280: p_rel_type_code => x_upd_org_units_tbl(l_upd_org).relationship_type_code,
5281: x_instance_ou_id => l_instance_ou_id,

Line 5309: csi_utl_pkg.get_ext_attribs(

5305: IF x_upd_ext_attrib_val_tbl.count > 0 THEN
5306: FOR l_upd_ext in x_upd_ext_attrib_val_tbl.first..x_upd_ext_attrib_val_tbl.last
5307: LOOP
5308:
5309: csi_utl_pkg.get_ext_attribs(
5310: p_instance_id => l_instance_id ,
5311: p_attribute_id => x_upd_ext_attrib_val_tbl(l_upd_ext).attribute_id,
5312: x_attribute_value_id => l_attrib_value_id,
5313: x_obj_version_number => l_av_obj_ver_num,

Line 5703: l_obj_ver_num := csi_utl_pkg.get_pty_obj_ver_num(

5699: l_cre_pty := l_cre_pty + 1;
5700:
5701: ELSE
5702:
5703: l_obj_ver_num := csi_utl_pkg.get_pty_obj_ver_num(
5704: p_txn_party_detail_tbl(j).instance_party_id);
5705:
5706: IF l_obj_ver_num = -1 THEN
5707: RAISE fnd_api.g_exc_error;

Line 6603: px_txn_ps_tbl IN OUT NOCOPY csi_utl_pkg.txn_ps_tbl,

6599: p_quantity_ratio IN number,
6600: p_model_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
6601: p_split_flag IN varchar2,--bug 14534435
6602: px_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl,
6603: px_txn_ps_tbl IN OUT NOCOPY csi_utl_pkg.txn_ps_tbl,
6604: x_return_status OUT NOCOPY varchar2)
6605: IS
6606:
6607: l_txn_type_id number := csi_order_ship_pub.g_txn_type_id;

Line 7069: l_txn_ps_tbl csi_utl_pkg.txn_ps_tbl;

7065: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
7066: l_msg_data varchar2(512);
7067: l_msg_count number;
7068:
7069: l_txn_ps_tbl csi_utl_pkg.txn_ps_tbl;
7070:
7071: --fix for bug5096435
7072: l_order_line_qty number;
7073: l_temp_line_rec oe_order_pub.Line_Rec_Type;

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

7363: x_return_status := fnd_api.g_ret_sts_success;
7364:
7365: IF nvl(px_item_control_rec.primary_uom_code, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
7366:
7367: px_item_control_rec.primary_uom_code := csi_utl_pkg.get_primay_uom(
7368: p_inv_item_id => px_item_control_rec.inventory_item_id,
7369: p_inv_org_id => px_item_control_rec.organization_id);
7370:
7371: END IF;

Line 7539: END csi_utl_pkg ;

7535: END get_lot_ctrl_code;
7536: --Added for Bug#14835893
7537:
7538:
7539: END csi_utl_pkg ;