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_ML_REPLACE_PVT dependencies on FND_API

Line 49: l_init_msg_list VARCHAR2 (1) := fnd_api.g_true;

45: l_msg_data VARCHAR2 (200);
46: l_msg_index NUMBER (3);
47: l_sql_error VARCHAR2 (2000);
48: l_api_version NUMBER (3) := 1.0;
49: l_init_msg_list VARCHAR2 (1) := fnd_api.g_true;
50: l_commit VARCHAR2 (1) := fnd_api.g_false;
51: e_error EXCEPTION;
52: x_party_header_tbl csi_datastructures_pub.party_header_tbl;
53: x_party_cache_tbl csi_datastructures_pub.party_header_tbl;

Line 50: l_commit VARCHAR2 (1) := fnd_api.g_false;

46: l_msg_index NUMBER (3);
47: l_sql_error VARCHAR2 (2000);
48: l_api_version NUMBER (3) := 1.0;
49: l_init_msg_list VARCHAR2 (1) := fnd_api.g_true;
50: l_commit VARCHAR2 (1) := fnd_api.g_false;
51: e_error EXCEPTION;
52: x_party_header_tbl csi_datastructures_pub.party_header_tbl;
53: x_party_cache_tbl csi_datastructures_pub.party_header_tbl;
54: x_party_account_header_tbl csi_datastructures_pub.party_account_header_tbl;

Line 68: l_miss_char CONSTANT VARCHAR2 (1) := fnd_api.g_miss_char;

64: l_ieav_index PLS_INTEGER;
65: inst_index PLS_INTEGER;
66: i PLS_INTEGER;
67: b_end_dated BOOLEAN := TRUE;
68: l_miss_char CONSTANT VARCHAR2 (1) := fnd_api.g_miss_char;
69: l_miss_num CONSTANT NUMBER := fnd_api.g_miss_num;
70: l_miss_date CONSTANT DATE := fnd_api.g_miss_date;
71: r_instance_id NUMBER;
72: FUNCTION get_parent_tbl_index (

Line 69: l_miss_num CONSTANT NUMBER := fnd_api.g_miss_num;

65: inst_index PLS_INTEGER;
66: i PLS_INTEGER;
67: b_end_dated BOOLEAN := TRUE;
68: l_miss_char CONSTANT VARCHAR2 (1) := fnd_api.g_miss_char;
69: l_miss_num CONSTANT NUMBER := fnd_api.g_miss_num;
70: l_miss_date CONSTANT DATE := fnd_api.g_miss_date;
71: r_instance_id NUMBER;
72: FUNCTION get_parent_tbl_index (
73: p_instance_party_id IN NUMBER,

Line 70: l_miss_date CONSTANT DATE := fnd_api.g_miss_date;

66: i PLS_INTEGER;
67: b_end_dated BOOLEAN := TRUE;
68: l_miss_char CONSTANT VARCHAR2 (1) := fnd_api.g_miss_char;
69: l_miss_num CONSTANT NUMBER := fnd_api.g_miss_num;
70: l_miss_date CONSTANT DATE := fnd_api.g_miss_date;
71: r_instance_id NUMBER;
72: FUNCTION get_parent_tbl_index (
73: p_instance_party_id IN NUMBER,
74: p_relationship_type_code IN VARCHAR2

Line 78: l_miss_char CONSTANT VARCHAR2 (1) := fnd_api.g_miss_char;

74: p_relationship_type_code IN VARCHAR2
75: )
76: RETURN PLS_INTEGER
77: IS
78: l_miss_char CONSTANT VARCHAR2 (1) := fnd_api.g_miss_char;
79: l_miss_num CONSTANT NUMBER := fnd_api.g_miss_num;
80: l_index PLS_INTEGER;
81: BEGIN
82: l_index := NULL;

Line 79: l_miss_num CONSTANT NUMBER := fnd_api.g_miss_num;

75: )
76: RETURN PLS_INTEGER
77: IS
78: l_miss_char CONSTANT VARCHAR2 (1) := fnd_api.g_miss_char;
79: l_miss_num CONSTANT NUMBER := fnd_api.g_miss_num;
80: l_index PLS_INTEGER;
81: BEGIN
82: l_index := NULL;
83: IF x_party_tbl.COUNT >= 1

Line 157: p_validation_level=> fnd_api.g_valid_level_full,

153: csi_item_instance_pub.get_item_instance_details (
154: p_api_version=> l_api_version,
155: p_commit=> l_commit,
156: p_init_msg_list=> l_init_msg_list,
157: p_validation_level=> fnd_api.g_valid_level_full,
158: p_instance_rec=> l_instance_header_rec,
159: p_get_parties=> fnd_api.g_true,
160: p_party_header_tbl=> x_party_header_tbl,
161: p_get_accounts=> fnd_api.g_true,

Line 159: p_get_parties=> fnd_api.g_true,

155: p_commit=> l_commit,
156: p_init_msg_list=> l_init_msg_list,
157: p_validation_level=> fnd_api.g_valid_level_full,
158: p_instance_rec=> l_instance_header_rec,
159: p_get_parties=> fnd_api.g_true,
160: p_party_header_tbl=> x_party_header_tbl,
161: p_get_accounts=> fnd_api.g_true,
162: p_account_header_tbl=> x_party_account_header_tbl,
163: p_get_org_assignments=> fnd_api.g_true,

Line 161: p_get_accounts=> fnd_api.g_true,

157: p_validation_level=> fnd_api.g_valid_level_full,
158: p_instance_rec=> l_instance_header_rec,
159: p_get_parties=> fnd_api.g_true,
160: p_party_header_tbl=> x_party_header_tbl,
161: p_get_accounts=> fnd_api.g_true,
162: p_account_header_tbl=> x_party_account_header_tbl,
163: p_get_org_assignments=> fnd_api.g_true,
164: p_org_header_tbl=> x_org_units_header_tbl,
165: p_get_pricing_attribs=> fnd_api.g_true,

Line 163: p_get_org_assignments=> fnd_api.g_true,

159: p_get_parties=> fnd_api.g_true,
160: p_party_header_tbl=> x_party_header_tbl,
161: p_get_accounts=> fnd_api.g_true,
162: p_account_header_tbl=> x_party_account_header_tbl,
163: p_get_org_assignments=> fnd_api.g_true,
164: p_org_header_tbl=> x_org_units_header_tbl,
165: p_get_pricing_attribs=> fnd_api.g_true,
166: p_pricing_attrib_tbl=> x_pricing_attribs_tbl,
167: p_get_ext_attribs=> fnd_api.g_true,

Line 165: p_get_pricing_attribs=> fnd_api.g_true,

161: p_get_accounts=> fnd_api.g_true,
162: p_account_header_tbl=> x_party_account_header_tbl,
163: p_get_org_assignments=> fnd_api.g_true,
164: p_org_header_tbl=> x_org_units_header_tbl,
165: p_get_pricing_attribs=> fnd_api.g_true,
166: p_pricing_attrib_tbl=> x_pricing_attribs_tbl,
167: p_get_ext_attribs=> fnd_api.g_true,
168: p_ext_attrib_tbl=> x_ext_attrib_value_tbl,
169: p_ext_attrib_def_tbl=> x_extend_attrib_tbl,

Line 167: p_get_ext_attribs=> fnd_api.g_true,

163: p_get_org_assignments=> fnd_api.g_true,
164: p_org_header_tbl=> x_org_units_header_tbl,
165: p_get_pricing_attribs=> fnd_api.g_true,
166: p_pricing_attrib_tbl=> x_pricing_attribs_tbl,
167: p_get_ext_attribs=> fnd_api.g_true,
168: p_ext_attrib_tbl=> x_ext_attrib_value_tbl,
169: p_ext_attrib_def_tbl=> x_extend_attrib_tbl,
170: p_get_asset_assignments=> fnd_api.g_false,
171: p_asset_header_tbl=> x_instance_asset_header_tbl,

Line 170: p_get_asset_assignments=> fnd_api.g_false,

166: p_pricing_attrib_tbl=> x_pricing_attribs_tbl,
167: p_get_ext_attribs=> fnd_api.g_true,
168: p_ext_attrib_tbl=> x_ext_attrib_value_tbl,
169: p_ext_attrib_def_tbl=> x_extend_attrib_tbl,
170: p_get_asset_assignments=> fnd_api.g_false,
171: p_asset_header_tbl=> x_instance_asset_header_tbl,
172: p_resolve_id_columns=> fnd_api.g_false,
173: p_time_stamp=> NULL,
174: x_return_status=> x_return_status,

Line 172: p_resolve_id_columns=> fnd_api.g_false,

168: p_ext_attrib_tbl=> x_ext_attrib_value_tbl,
169: p_ext_attrib_def_tbl=> x_extend_attrib_tbl,
170: p_get_asset_assignments=> fnd_api.g_false,
171: p_asset_header_tbl=> x_instance_asset_header_tbl,
172: p_resolve_id_columns=> fnd_api.g_false,
173: p_time_stamp=> NULL,
174: x_return_status=> x_return_status,
175: x_msg_count=> l_msg_count,
176: x_msg_data=> l_msg_data

Line 181: IF x_return_status <> fnd_api.g_ret_sts_success

177: );
178:
179:
180: --dbms_output.put_line('after get item instance details status : '||x_return_status);
181: IF x_return_status <> fnd_api.g_ret_sts_success
182: THEN
183: l_msg_index := 1;
184: x_error_message := l_msg_data;
185:

Line 191: fnd_api.g_false

187: LOOP
188: x_error_message := x_error_message
189: || fnd_msg_pub.get (
190: l_msg_index,
191: fnd_api.g_false
192: );
193: l_msg_index := l_msg_index
194: + 1;
195: l_msg_count := l_msg_count

Line 5643: x_return_status := fnd_api.g_ret_sts_error;

5639: THEN
5640: ROLLBACK TO instance_entity;
5641: --dbms_output.put_line('in e_Error:'||substr(l_msg_data,1,200));
5642: x_error_message := fnd_message.get;
5643: x_return_status := fnd_api.g_ret_sts_error;
5644: WHEN OTHERS
5645: THEN
5646: l_sql_error := SQLERRM;
5647: fnd_message.set_name ('CSI', 'CSI_ML_UNEXP_SQL_ERROR');

Line 5651: x_return_status := fnd_api.g_ret_sts_unexp_error;

5647: fnd_message.set_name ('CSI', 'CSI_ML_UNEXP_SQL_ERROR');
5648: fnd_message.set_token ('API_NAME', l_api_name);
5649: fnd_message.set_token ('SQL_ERROR', SQLERRM);
5650: x_error_message := fnd_message.get;
5651: x_return_status := fnd_api.g_ret_sts_unexp_error;
5652: END;
5653: END LOOP; --csi_intf_repl_cur
5654:
5655: END process_replace;