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.CSE_DEPLOYMENT_GRP dependencies on FND_API

Line 73: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

69: l_instance_ids_list csi_datastructures_pub.id_tbl;
70:
71: l_msg_data varchar2(2000);
72: l_msg_count number;
73: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
74: l_error_message varchar2(2000);
75:
76: BEGIN
77:

Line 78: x_return_status := fnd_api.g_ret_sts_success;

74: l_error_message varchar2(2000);
75:
76: BEGIN
77:
78: x_return_status := fnd_api.g_ret_sts_success;
79:
80: debug('inside api process_retirements');
81: debug(' p_instance_id : '||p_instance_id);
82: debug(' p_asset_id : '||p_asset_id);

Line 103: IF l_return_status <> fnd_api.g_ret_sts_success THEN

99: px_txn_rec => px_txn_rec,
100: x_return_status => l_return_status,
101: x_error_message => l_error_message);
102:
103: IF l_return_status <> fnd_api.g_ret_sts_success THEN
104: RAISE fnd_api.g_exc_error;
105: END IF;
106:
107: cse_fa_txn_pkg.populate_retirement_interface(

Line 104: RAISE fnd_api.g_exc_error;

100: x_return_status => l_return_status,
101: x_error_message => l_error_message);
102:
103: IF l_return_status <> fnd_api.g_ret_sts_success THEN
104: RAISE fnd_api.g_exc_error;
105: END IF;
106:
107: cse_fa_txn_pkg.populate_retirement_interface(
108: p_csi_txn_id => px_txn_rec.transaction_id,

Line 118: IF l_return_status <> fnd_api.g_ret_sts_success THEN

114: p_retirement_units => px_txn_rec.transaction_quantity,
115: p_retirement_date => px_txn_rec.source_transaction_date,
116: x_return_status => l_return_status);
117:
118: IF l_return_status <> fnd_api.g_ret_sts_success THEN
119: RAISE fnd_api.g_exc_error;
120: END IF;
121:
122: END LOOP;

Line 119: RAISE fnd_api.g_exc_error;

115: p_retirement_date => px_txn_rec.source_transaction_date,
116: x_return_status => l_return_status);
117:
118: IF l_return_status <> fnd_api.g_ret_sts_success THEN
119: RAISE fnd_api.g_exc_error;
120: END IF;
121:
122: END LOOP;
123: END IF;

Line 165: RAISE fnd_api.g_exc_error;

161: IF l_inst_asset_found THEN
162: fnd_message.set_name('CSE', 'CSE_WFM_RETIRE_FLAG_ERROR');
163: fnd_message.set_token('ASSET_ID',l_asset_id);
164: fnd_msg_pub.add;
165: RAISE fnd_api.g_exc_error;
166: END IF;
167:
168: END IF;
169: END IF; -- in_service or acct_class_code = 'ASSET'

Line 175: RAISE fnd_api.g_exc_error;

171: IF l_location_type_code = 'PROJECT' THEN
172: IF NOT(l_inst_asset_found) THEN
173: fnd_message.set_name('CSE', 'CSE_WFM_RETIRE_CIP_ERROR');
174: fnd_msg_pub.add;
175: RAISE fnd_api.g_exc_error;
176: END IF;
177: ELSIF l_location_type_code IN ('INVENTORY', 'WIP') THEN
178: fnd_message.set_name('CSE', 'CSE_WFM_RETIRE_INT_ERROR');
179: fnd_message.set_token('INST_ID', p_instance_id);

Line 181: RAISE fnd_api.g_exc_error;

177: ELSIF l_location_type_code IN ('INVENTORY', 'WIP') THEN
178: fnd_message.set_name('CSE', 'CSE_WFM_RETIRE_INT_ERROR');
179: fnd_message.set_token('INST_ID', p_instance_id);
180: fnd_msg_pub.add;
181: RAISE fnd_api.g_exc_error;
182: END IF;
183:
184: IF l_quantity > px_txn_rec.transaction_quantity THEN
185: -- partial retirement

Line 198: p_commit => fnd_api.g_false,

194: debug('Calling API csi_item_instance_pvt.split_item_instance');
195:
196: csi_item_instance_pvt.split_item_instance (
197: p_api_version => 1.0,
198: p_commit => fnd_api.g_false,
199: p_init_msg_list => fnd_api.g_true,
200: p_validation_level => fnd_api.g_valid_level_full,
201: p_source_instance_rec => l_source_instance_rec,
202: p_quantity1 => l_source_instance_qty,

Line 199: p_init_msg_list => fnd_api.g_true,

195:
196: csi_item_instance_pvt.split_item_instance (
197: p_api_version => 1.0,
198: p_commit => fnd_api.g_false,
199: p_init_msg_list => fnd_api.g_true,
200: p_validation_level => fnd_api.g_valid_level_full,
201: p_source_instance_rec => l_source_instance_rec,
202: p_quantity1 => l_source_instance_qty,
203: p_quantity2 => l_new_instance_qty,

Line 200: p_validation_level => fnd_api.g_valid_level_full,

196: csi_item_instance_pvt.split_item_instance (
197: p_api_version => 1.0,
198: p_commit => fnd_api.g_false,
199: p_init_msg_list => fnd_api.g_true,
200: p_validation_level => fnd_api.g_valid_level_full,
201: p_source_instance_rec => l_source_instance_rec,
202: p_quantity1 => l_source_instance_qty,
203: p_quantity2 => l_new_instance_qty,
204: p_copy_ext_attribs => fnd_api.g_true,

Line 204: p_copy_ext_attribs => fnd_api.g_true,

200: p_validation_level => fnd_api.g_valid_level_full,
201: p_source_instance_rec => l_source_instance_rec,
202: p_quantity1 => l_source_instance_qty,
203: p_quantity2 => l_new_instance_qty,
204: p_copy_ext_attribs => fnd_api.g_true,
205: p_copy_org_assignments => fnd_api.g_true,
206: p_copy_parties => fnd_api.g_true,
207: p_copy_accounts => fnd_api.g_true,
208: p_copy_asset_assignments => fnd_api.g_false,

Line 205: p_copy_org_assignments => fnd_api.g_true,

201: p_source_instance_rec => l_source_instance_rec,
202: p_quantity1 => l_source_instance_qty,
203: p_quantity2 => l_new_instance_qty,
204: p_copy_ext_attribs => fnd_api.g_true,
205: p_copy_org_assignments => fnd_api.g_true,
206: p_copy_parties => fnd_api.g_true,
207: p_copy_accounts => fnd_api.g_true,
208: p_copy_asset_assignments => fnd_api.g_false,
209: p_copy_pricing_attribs => fnd_api.g_true,

Line 206: p_copy_parties => fnd_api.g_true,

202: p_quantity1 => l_source_instance_qty,
203: p_quantity2 => l_new_instance_qty,
204: p_copy_ext_attribs => fnd_api.g_true,
205: p_copy_org_assignments => fnd_api.g_true,
206: p_copy_parties => fnd_api.g_true,
207: p_copy_accounts => fnd_api.g_true,
208: p_copy_asset_assignments => fnd_api.g_false,
209: p_copy_pricing_attribs => fnd_api.g_true,
210: p_txn_rec => px_txn_rec,

Line 207: p_copy_accounts => fnd_api.g_true,

203: p_quantity2 => l_new_instance_qty,
204: p_copy_ext_attribs => fnd_api.g_true,
205: p_copy_org_assignments => fnd_api.g_true,
206: p_copy_parties => fnd_api.g_true,
207: p_copy_accounts => fnd_api.g_true,
208: p_copy_asset_assignments => fnd_api.g_false,
209: p_copy_pricing_attribs => fnd_api.g_true,
210: p_txn_rec => px_txn_rec,
211: x_new_instance_rec => l_new_instance_rec,

Line 208: p_copy_asset_assignments => fnd_api.g_false,

204: p_copy_ext_attribs => fnd_api.g_true,
205: p_copy_org_assignments => fnd_api.g_true,
206: p_copy_parties => fnd_api.g_true,
207: p_copy_accounts => fnd_api.g_true,
208: p_copy_asset_assignments => fnd_api.g_false,
209: p_copy_pricing_attribs => fnd_api.g_true,
210: p_txn_rec => px_txn_rec,
211: x_new_instance_rec => l_new_instance_rec,
212: x_return_status => l_return_status,

Line 209: p_copy_pricing_attribs => fnd_api.g_true,

205: p_copy_org_assignments => fnd_api.g_true,
206: p_copy_parties => fnd_api.g_true,
207: p_copy_accounts => fnd_api.g_true,
208: p_copy_asset_assignments => fnd_api.g_false,
209: p_copy_pricing_attribs => fnd_api.g_true,
210: p_txn_rec => px_txn_rec,
211: x_new_instance_rec => l_new_instance_rec,
212: x_return_status => l_return_status,
213: x_msg_count => l_msg_count,

Line 216: IF l_return_status <> fnd_api.g_ret_sts_success THEN

212: x_return_status => l_return_status,
213: x_msg_count => l_msg_count,
214: x_msg_data => l_msg_data);
215:
216: IF l_return_status <> fnd_api.g_ret_sts_success THEN
217: RAISE fnd_api.g_exc_error;
218: END IF;
219:
220: debug(' new_instance_id : '||l_new_instance_rec.instance_id);

Line 217: RAISE fnd_api.g_exc_error;

213: x_msg_count => l_msg_count,
214: x_msg_data => l_msg_data);
215:
216: IF l_return_status <> fnd_api.g_ret_sts_success THEN
217: RAISE fnd_api.g_exc_error;
218: END IF;
219:
220: debug(' new_instance_id : '||l_new_instance_rec.instance_id);
221: debug(' new_instance_quantity: '||l_new_instance_rec.quantity);

Line 248: p_commit => fnd_api.g_false,

244: debug(' operation_status_code : '||l_u_instance_rec.operational_status_code);
245:
246: csi_item_instance_pub.update_item_instance(
247: p_api_version => 1.0,
248: p_commit => fnd_api.g_false,
249: p_init_msg_list => fnd_api.g_true,
250: p_validation_level => fnd_api.g_valid_level_full,
251: p_instance_rec => l_u_instance_rec,
252: p_party_tbl => l_u_parties_tbl,

Line 249: p_init_msg_list => fnd_api.g_true,

245:
246: csi_item_instance_pub.update_item_instance(
247: p_api_version => 1.0,
248: p_commit => fnd_api.g_false,
249: p_init_msg_list => fnd_api.g_true,
250: p_validation_level => fnd_api.g_valid_level_full,
251: p_instance_rec => l_u_instance_rec,
252: p_party_tbl => l_u_parties_tbl,
253: p_account_tbl => l_u_pty_accts_tbl,

Line 250: p_validation_level => fnd_api.g_valid_level_full,

246: csi_item_instance_pub.update_item_instance(
247: p_api_version => 1.0,
248: p_commit => fnd_api.g_false,
249: p_init_msg_list => fnd_api.g_true,
250: p_validation_level => fnd_api.g_valid_level_full,
251: p_instance_rec => l_u_instance_rec,
252: p_party_tbl => l_u_parties_tbl,
253: p_account_tbl => l_u_pty_accts_tbl,
254: p_org_assignments_tbl => l_u_org_units_tbl,

Line 264: IF l_return_status <> fnd_api.g_ret_sts_success THEN

260: x_return_status => l_return_status,
261: x_msg_count => l_msg_count,
262: x_msg_data => l_msg_data);
263:
264: IF l_return_status <> fnd_api.g_ret_sts_success THEN
265: RAISE fnd_api.g_exc_error;
266: END IF;
267:
268: END IF; -- operational_flag = 'Y'

Line 265: RAISE fnd_api.g_exc_error;

261: x_msg_count => l_msg_count,
262: x_msg_data => l_msg_data);
263:
264: IF l_return_status <> fnd_api.g_ret_sts_success THEN
265: RAISE fnd_api.g_exc_error;
266: END IF;
267:
268: END IF; -- operational_flag = 'Y'
269:

Line 271: WHEN fnd_api.g_exc_error THEN

267:
268: END IF; -- operational_flag = 'Y'
269:
270: EXCEPTION
271: WHEN fnd_api.g_exc_error THEN
272: rollback to process_retirements;
273: x_return_status := fnd_api.g_ret_sts_error;
274: END process_retirements;
275:

Line 273: x_return_status := fnd_api.g_ret_sts_error;

269:
270: EXCEPTION
271: WHEN fnd_api.g_exc_error THEN
272: rollback to process_retirements;
273: x_return_status := fnd_api.g_ret_sts_error;
274: END process_retirements;
275:
276: PROCEDURE rebuild_child_entities(
277: p_instance_id IN number,

Line 310: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

306: xr_ind binary_integer := 0;
307:
308: l_msg_data varchar2(2000);
309: l_msg_count number;
310: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
311:
312: BEGIN
313:
314: x_return_status := fnd_api.g_ret_sts_success;

Line 314: x_return_status := fnd_api.g_ret_sts_success;

310: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
311:
312: BEGIN
313:
314: x_return_status := fnd_api.g_ret_sts_success;
315:
316: IF nvl(p_instance_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
317:
318: l_inst_rec.instance_id := p_instance_id;

Line 316: IF nvl(p_instance_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

312: BEGIN
313:
314: x_return_status := fnd_api.g_ret_sts_success;
315:
316: IF nvl(p_instance_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
317:
318: l_inst_rec.instance_id := p_instance_id;
319:
320: csi_item_instance_pub.get_item_instance_details(

Line 322: p_commit => fnd_api.g_false,

318: l_inst_rec.instance_id := p_instance_id;
319:
320: csi_item_instance_pub.get_item_instance_details(
321: p_api_version => 1.0,
322: p_commit => fnd_api.g_false,
323: p_init_msg_list => fnd_api.g_true,
324: p_validation_level => fnd_api.g_valid_level_full,
325: p_instance_rec => l_inst_rec,
326: p_get_parties => fnd_api.g_true,

Line 323: p_init_msg_list => fnd_api.g_true,

319:
320: csi_item_instance_pub.get_item_instance_details(
321: p_api_version => 1.0,
322: p_commit => fnd_api.g_false,
323: p_init_msg_list => fnd_api.g_true,
324: p_validation_level => fnd_api.g_valid_level_full,
325: p_instance_rec => l_inst_rec,
326: p_get_parties => fnd_api.g_true,
327: p_party_header_tbl => l_pty_tbl,

Line 324: p_validation_level => fnd_api.g_valid_level_full,

320: csi_item_instance_pub.get_item_instance_details(
321: p_api_version => 1.0,
322: p_commit => fnd_api.g_false,
323: p_init_msg_list => fnd_api.g_true,
324: p_validation_level => fnd_api.g_valid_level_full,
325: p_instance_rec => l_inst_rec,
326: p_get_parties => fnd_api.g_true,
327: p_party_header_tbl => l_pty_tbl,
328: p_get_accounts => fnd_api.g_true,

Line 326: p_get_parties => fnd_api.g_true,

322: p_commit => fnd_api.g_false,
323: p_init_msg_list => fnd_api.g_true,
324: p_validation_level => fnd_api.g_valid_level_full,
325: p_instance_rec => l_inst_rec,
326: p_get_parties => fnd_api.g_true,
327: p_party_header_tbl => l_pty_tbl,
328: p_get_accounts => fnd_api.g_true,
329: p_account_header_tbl => l_pty_acct_tbl,
330: p_get_org_assignments => fnd_api.g_true,

Line 328: p_get_accounts => fnd_api.g_true,

324: p_validation_level => fnd_api.g_valid_level_full,
325: p_instance_rec => l_inst_rec,
326: p_get_parties => fnd_api.g_true,
327: p_party_header_tbl => l_pty_tbl,
328: p_get_accounts => fnd_api.g_true,
329: p_account_header_tbl => l_pty_acct_tbl,
330: p_get_org_assignments => fnd_api.g_true,
331: p_org_header_tbl => l_org_tbl,
332: p_get_pricing_attribs => fnd_api.g_true,

Line 330: p_get_org_assignments => fnd_api.g_true,

326: p_get_parties => fnd_api.g_true,
327: p_party_header_tbl => l_pty_tbl,
328: p_get_accounts => fnd_api.g_true,
329: p_account_header_tbl => l_pty_acct_tbl,
330: p_get_org_assignments => fnd_api.g_true,
331: p_org_header_tbl => l_org_tbl,
332: p_get_pricing_attribs => fnd_api.g_true,
333: p_pricing_attrib_tbl => l_price_tbl,
334: p_get_ext_attribs => fnd_api.g_false,

Line 332: p_get_pricing_attribs => fnd_api.g_true,

328: p_get_accounts => fnd_api.g_true,
329: p_account_header_tbl => l_pty_acct_tbl,
330: p_get_org_assignments => fnd_api.g_true,
331: p_org_header_tbl => l_org_tbl,
332: p_get_pricing_attribs => fnd_api.g_true,
333: p_pricing_attrib_tbl => l_price_tbl,
334: p_get_ext_attribs => fnd_api.g_false,
335: p_ext_attrib_tbl => l_eav_tbl,
336: p_ext_attrib_def_tbl => l_ea_tbl,

Line 334: p_get_ext_attribs => fnd_api.g_false,

330: p_get_org_assignments => fnd_api.g_true,
331: p_org_header_tbl => l_org_tbl,
332: p_get_pricing_attribs => fnd_api.g_true,
333: p_pricing_attrib_tbl => l_price_tbl,
334: p_get_ext_attribs => fnd_api.g_false,
335: p_ext_attrib_tbl => l_eav_tbl,
336: p_ext_attrib_def_tbl => l_ea_tbl,
337: p_get_asset_assignments => fnd_api.g_false,
338: p_asset_header_tbl => l_ia_tbl,

Line 337: p_get_asset_assignments => fnd_api.g_false,

333: p_pricing_attrib_tbl => l_price_tbl,
334: p_get_ext_attribs => fnd_api.g_false,
335: p_ext_attrib_tbl => l_eav_tbl,
336: p_ext_attrib_def_tbl => l_ea_tbl,
337: p_get_asset_assignments => fnd_api.g_false,
338: p_asset_header_tbl => l_ia_tbl,
339: p_resolve_id_columns => fnd_api.g_false,
340: p_time_stamp => l_time_stamp,
341: x_return_status => l_return_status,

Line 339: p_resolve_id_columns => fnd_api.g_false,

335: p_ext_attrib_tbl => l_eav_tbl,
336: p_ext_attrib_def_tbl => l_ea_tbl,
337: p_get_asset_assignments => fnd_api.g_false,
338: p_asset_header_tbl => l_ia_tbl,
339: p_resolve_id_columns => fnd_api.g_false,
340: p_time_stamp => l_time_stamp,
341: x_return_status => l_return_status,
342: x_msg_count => l_msg_count,
343: x_msg_data => l_msg_data );

Line 344: IF l_return_status <> fnd_api.g_ret_sts_success THEN

340: p_time_stamp => l_time_stamp,
341: x_return_status => l_return_status,
342: x_msg_count => l_msg_count,
343: x_msg_data => l_msg_data );
344: IF l_return_status <> fnd_api.g_ret_sts_success THEN
345: RAISE fnd_api.g_exc_error;
346: END IF;
347:
348: IF l_pty_tbl.count > 0 THEN

Line 345: RAISE fnd_api.g_exc_error;

341: x_return_status => l_return_status,
342: x_msg_count => l_msg_count,
343: x_msg_data => l_msg_data );
344: IF l_return_status <> fnd_api.g_ret_sts_success THEN
345: RAISE fnd_api.g_exc_error;
346: END IF;
347:
348: IF l_pty_tbl.count > 0 THEN
349:

Line 352: IF nvl(l_pty_tbl(p_ind).active_end_date, fnd_api.g_miss_date) = fnd_api.g_miss_date THEN

348: IF l_pty_tbl.count > 0 THEN
349:
350: FOR p_ind IN l_pty_tbl.FIRST .. l_pty_tbl.LAST
351: LOOP
352: IF nvl(l_pty_tbl(p_ind).active_end_date, fnd_api.g_miss_date) = fnd_api.g_miss_date THEN
353:
354: xp_ind := xp_ind + 1;
355:
356: l_t_pty_tbl(xp_ind).instance_party_id := fnd_api.g_miss_num;

Line 356: l_t_pty_tbl(xp_ind).instance_party_id := fnd_api.g_miss_num;

352: IF nvl(l_pty_tbl(p_ind).active_end_date, fnd_api.g_miss_date) = fnd_api.g_miss_date THEN
353:
354: xp_ind := xp_ind + 1;
355:
356: l_t_pty_tbl(xp_ind).instance_party_id := fnd_api.g_miss_num;
357: l_t_pty_tbl(xp_ind).parent_tbl_index := 1;
358: l_t_pty_tbl(xp_ind).instance_id := p_instance_id;
359: l_t_pty_tbl(xp_ind).party_source_table := l_pty_tbl(p_ind).party_source_table;
360: l_t_pty_tbl(xp_ind).party_id := l_pty_tbl(p_ind).party_id;

Line 364: l_t_pty_tbl(xp_ind).active_start_date := fnd_api.g_miss_date;

360: l_t_pty_tbl(xp_ind).party_id := l_pty_tbl(p_ind).party_id;
361: l_t_pty_tbl(xp_ind).relationship_type_code:= l_pty_tbl(p_ind).relationship_type_code;
362: l_t_pty_tbl(xp_ind).contact_flag := l_pty_tbl(p_ind).contact_flag;
363: l_t_pty_tbl(xp_ind).contact_ip_id := l_pty_tbl(p_ind).contact_ip_id;
364: l_t_pty_tbl(xp_ind).active_start_date := fnd_api.g_miss_date;
365: l_t_pty_tbl(xp_ind).active_end_date := fnd_api.g_miss_date;
366: l_t_pty_tbl(xp_ind).context := l_pty_tbl(p_ind).context;
367: l_t_pty_tbl(xp_ind).attribute1 := l_pty_tbl(p_ind).attribute1;
368: l_t_pty_tbl(xp_ind).attribute2 := l_pty_tbl(p_ind).attribute2;

Line 365: l_t_pty_tbl(xp_ind).active_end_date := fnd_api.g_miss_date;

361: l_t_pty_tbl(xp_ind).relationship_type_code:= l_pty_tbl(p_ind).relationship_type_code;
362: l_t_pty_tbl(xp_ind).contact_flag := l_pty_tbl(p_ind).contact_flag;
363: l_t_pty_tbl(xp_ind).contact_ip_id := l_pty_tbl(p_ind).contact_ip_id;
364: l_t_pty_tbl(xp_ind).active_start_date := fnd_api.g_miss_date;
365: l_t_pty_tbl(xp_ind).active_end_date := fnd_api.g_miss_date;
366: l_t_pty_tbl(xp_ind).context := l_pty_tbl(p_ind).context;
367: l_t_pty_tbl(xp_ind).attribute1 := l_pty_tbl(p_ind).attribute1;
368: l_t_pty_tbl(xp_ind).attribute2 := l_pty_tbl(p_ind).attribute2;
369: l_t_pty_tbl(xp_ind).attribute3 := l_pty_tbl(p_ind).attribute3;

Line 390: nvl(l_pty_acct_tbl(pa_ind).active_end_date, fnd_api.g_miss_date) = fnd_api.g_miss_date

386: LOOP
387:
388: IF l_pty_acct_tbl(pa_ind).instance_party_id = l_pty_tbl(p_ind).instance_party_id
389: AND
390: nvl(l_pty_acct_tbl(pa_ind).active_end_date, fnd_api.g_miss_date) = fnd_api.g_miss_date
391: THEN
392: xpa_ind := xpa_ind + 1;
393: l_t_pty_acct_tbl(xpa_ind).ip_account_id := fnd_api.g_miss_num;
394: l_t_pty_acct_tbl(xpa_ind).parent_tbl_index := xp_ind;

Line 393: l_t_pty_acct_tbl(xpa_ind).ip_account_id := fnd_api.g_miss_num;

389: AND
390: nvl(l_pty_acct_tbl(pa_ind).active_end_date, fnd_api.g_miss_date) = fnd_api.g_miss_date
391: THEN
392: xpa_ind := xpa_ind + 1;
393: l_t_pty_acct_tbl(xpa_ind).ip_account_id := fnd_api.g_miss_num;
394: l_t_pty_acct_tbl(xpa_ind).parent_tbl_index := xp_ind;
395: l_t_pty_acct_tbl(xpa_ind).instance_party_id := fnd_api.g_miss_num;
396: l_t_pty_acct_tbl(xpa_ind).party_account_id := l_pty_acct_tbl(pa_ind).party_account_id;
397: l_t_pty_acct_tbl(xpa_ind).relationship_type_code:= l_pty_acct_tbl(pa_ind).relationship_type_code;

Line 395: l_t_pty_acct_tbl(xpa_ind).instance_party_id := fnd_api.g_miss_num;

391: THEN
392: xpa_ind := xpa_ind + 1;
393: l_t_pty_acct_tbl(xpa_ind).ip_account_id := fnd_api.g_miss_num;
394: l_t_pty_acct_tbl(xpa_ind).parent_tbl_index := xp_ind;
395: l_t_pty_acct_tbl(xpa_ind).instance_party_id := fnd_api.g_miss_num;
396: l_t_pty_acct_tbl(xpa_ind).party_account_id := l_pty_acct_tbl(pa_ind).party_account_id;
397: l_t_pty_acct_tbl(xpa_ind).relationship_type_code:= l_pty_acct_tbl(pa_ind).relationship_type_code;
398: l_t_pty_acct_tbl(xpa_ind).bill_to_address := l_pty_acct_tbl(pa_ind).bill_to_address;
399: l_t_pty_acct_tbl(xpa_ind).ship_to_address := l_pty_acct_tbl(pa_ind).ship_to_address;

Line 400: l_t_pty_acct_tbl(xpa_ind).active_start_date := fnd_api.g_miss_date;

396: l_t_pty_acct_tbl(xpa_ind).party_account_id := l_pty_acct_tbl(pa_ind).party_account_id;
397: l_t_pty_acct_tbl(xpa_ind).relationship_type_code:= l_pty_acct_tbl(pa_ind).relationship_type_code;
398: l_t_pty_acct_tbl(xpa_ind).bill_to_address := l_pty_acct_tbl(pa_ind).bill_to_address;
399: l_t_pty_acct_tbl(xpa_ind).ship_to_address := l_pty_acct_tbl(pa_ind).ship_to_address;
400: l_t_pty_acct_tbl(xpa_ind).active_start_date := fnd_api.g_miss_date;
401: l_t_pty_acct_tbl(xpa_ind).active_end_date := fnd_api.g_miss_date;
402: l_t_pty_acct_tbl(xpa_ind).context := l_pty_acct_tbl(pa_ind).context;
403: l_t_pty_acct_tbl(xpa_ind).attribute1 := l_pty_acct_tbl(pa_ind).attribute1;
404: l_t_pty_acct_tbl(xpa_ind).attribute2 := l_pty_acct_tbl(pa_ind).attribute2;

Line 401: l_t_pty_acct_tbl(xpa_ind).active_end_date := fnd_api.g_miss_date;

397: l_t_pty_acct_tbl(xpa_ind).relationship_type_code:= l_pty_acct_tbl(pa_ind).relationship_type_code;
398: l_t_pty_acct_tbl(xpa_ind).bill_to_address := l_pty_acct_tbl(pa_ind).bill_to_address;
399: l_t_pty_acct_tbl(xpa_ind).ship_to_address := l_pty_acct_tbl(pa_ind).ship_to_address;
400: l_t_pty_acct_tbl(xpa_ind).active_start_date := fnd_api.g_miss_date;
401: l_t_pty_acct_tbl(xpa_ind).active_end_date := fnd_api.g_miss_date;
402: l_t_pty_acct_tbl(xpa_ind).context := l_pty_acct_tbl(pa_ind).context;
403: l_t_pty_acct_tbl(xpa_ind).attribute1 := l_pty_acct_tbl(pa_ind).attribute1;
404: l_t_pty_acct_tbl(xpa_ind).attribute2 := l_pty_acct_tbl(pa_ind).attribute2;
405: l_t_pty_acct_tbl(xpa_ind).attribute3 := l_pty_acct_tbl(pa_ind).attribute3;

Line 432: IF nvl(l_org_tbl(o_ind).active_end_date, fnd_api.g_miss_date) = fnd_api.g_miss_date THEN

428:
429: IF l_org_tbl.count > 0 THEN
430: FOR o_ind IN l_org_tbl.FIRST .. l_org_tbl.LAST
431: LOOP
432: IF nvl(l_org_tbl(o_ind).active_end_date, fnd_api.g_miss_date) = fnd_api.g_miss_date THEN
433: xo_ind := xo_ind + 1;
434: l_t_org_tbl(xo_ind).instance_ou_id := fnd_api.g_miss_num;
435: l_t_org_tbl(xo_ind).parent_tbl_index := 1;
436: l_t_org_tbl(xo_ind).instance_id := p_instance_id;

Line 434: l_t_org_tbl(xo_ind).instance_ou_id := fnd_api.g_miss_num;

430: FOR o_ind IN l_org_tbl.FIRST .. l_org_tbl.LAST
431: LOOP
432: IF nvl(l_org_tbl(o_ind).active_end_date, fnd_api.g_miss_date) = fnd_api.g_miss_date THEN
433: xo_ind := xo_ind + 1;
434: l_t_org_tbl(xo_ind).instance_ou_id := fnd_api.g_miss_num;
435: l_t_org_tbl(xo_ind).parent_tbl_index := 1;
436: l_t_org_tbl(xo_ind).instance_id := p_instance_id;
437: l_t_org_tbl(xo_ind).operating_unit_id := l_org_tbl(o_ind).operating_unit_id;
438: l_t_org_tbl(xo_ind).relationship_type_code:= l_org_tbl(o_ind).relationship_type_code;

Line 439: l_t_org_tbl(xo_ind).active_start_date := fnd_api.g_miss_date;

435: l_t_org_tbl(xo_ind).parent_tbl_index := 1;
436: l_t_org_tbl(xo_ind).instance_id := p_instance_id;
437: l_t_org_tbl(xo_ind).operating_unit_id := l_org_tbl(o_ind).operating_unit_id;
438: l_t_org_tbl(xo_ind).relationship_type_code:= l_org_tbl(o_ind).relationship_type_code;
439: l_t_org_tbl(xo_ind).active_start_date := fnd_api.g_miss_date;
440: l_t_org_tbl(xo_ind).active_end_date := fnd_api.g_miss_date;
441: l_t_org_tbl(xo_ind).context := l_org_tbl(o_ind).context;
442: l_t_org_tbl(xo_ind).attribute1 := l_org_tbl(o_ind).attribute1;
443: l_t_org_tbl(xo_ind).attribute2 := l_org_tbl(o_ind).attribute2;

Line 440: l_t_org_tbl(xo_ind).active_end_date := fnd_api.g_miss_date;

436: l_t_org_tbl(xo_ind).instance_id := p_instance_id;
437: l_t_org_tbl(xo_ind).operating_unit_id := l_org_tbl(o_ind).operating_unit_id;
438: l_t_org_tbl(xo_ind).relationship_type_code:= l_org_tbl(o_ind).relationship_type_code;
439: l_t_org_tbl(xo_ind).active_start_date := fnd_api.g_miss_date;
440: l_t_org_tbl(xo_ind).active_end_date := fnd_api.g_miss_date;
441: l_t_org_tbl(xo_ind).context := l_org_tbl(o_ind).context;
442: l_t_org_tbl(xo_ind).attribute1 := l_org_tbl(o_ind).attribute1;
443: l_t_org_tbl(xo_ind).attribute2 := l_org_tbl(o_ind).attribute2;
444: l_t_org_tbl(xo_ind).attribute3 := l_org_tbl(o_ind).attribute3;

Line 465: IF nvl(l_price_tbl(pr_ind).active_end_date, fnd_api.g_miss_date) = fnd_api.g_miss_date THEN

461:
462: IF l_price_tbl.count > 0 THEN
463: FOR pr_ind IN l_price_tbl.FIRST .. l_price_tbl.LAST
464: LOOP
465: IF nvl(l_price_tbl(pr_ind).active_end_date, fnd_api.g_miss_date) = fnd_api.g_miss_date THEN
466: xpr_ind := xpr_ind + 1;
467: END IF;
468: END LOOP;
469: END IF;

Line 479: WHEN fnd_api.g_exc_error THEN

475: x_t_ou_tbl := l_t_org_tbl;
476: x_t_price_tbl := l_t_price_tbl;
477:
478: EXCEPTION
479: WHEN fnd_api.g_exc_error THEN
480: x_return_status := fnd_api.g_ret_sts_error;
481: END rebuild_child_entities;
482:
483:

Line 480: x_return_status := fnd_api.g_ret_sts_error;

476: x_t_price_tbl := l_t_price_tbl;
477:
478: EXCEPTION
479: WHEN fnd_api.g_exc_error THEN
480: x_return_status := fnd_api.g_ret_sts_error;
481: END rebuild_child_entities;
482:
483:
484: PROCEDURE process_transaction (

Line 529: x_return_status := fnd_api.g_ret_sts_success ;

525: l_operational_status_code varchar2(80);
526:
527: BEGIN
528:
529: x_return_status := fnd_api.g_ret_sts_success ;
530:
531: cse_util_pkg.set_debug;
532:
533: csi_t_gen_utility_pvt.build_file_name(

Line 616: l_txn_rec.source_line_ref_id := fnd_api.g_miss_num;

612: l_txn_rec.source_header_ref_id := nvl(l_project_id, l_last_project_id);
613: l_txn_rec.source_line_ref_id := nvl(l_task_id, l_last_task_id);
614: ELSE
615: l_txn_rec.source_header_ref_id := p_txn_tbl(si_ind).source_header_ref_id;
616: l_txn_rec.source_line_ref_id := fnd_api.g_miss_num;
617: END IF;
618:
619: l_txn_rec.source_header_ref := p_txn_tbl(si_ind).source_header_ref;
620: l_txn_rec.source_line_ref := fnd_api.g_miss_char;

Line 620: l_txn_rec.source_line_ref := fnd_api.g_miss_char;

616: l_txn_rec.source_line_ref_id := fnd_api.g_miss_num;
617: END IF;
618:
619: l_txn_rec.source_header_ref := p_txn_tbl(si_ind).source_header_ref;
620: l_txn_rec.source_line_ref := fnd_api.g_miss_char;
621: l_txn_rec.txn_sub_type_id := p_txn_tbl(si_ind).txn_sub_type_id ;
622: l_txn_rec.source_transaction_date := p_txn_tbl(si_ind).source_transaction_date ;
623: l_txn_rec.transaction_quantity := p_txn_tbl(si_ind).transaction_quantity ;
624:

Line 693: RAISE fnd_api.g_exc_error ;

689:
690: ELSE
691: fnd_message.set_name('CSI','CSI_DPL_INVALID_LOCATION');
692: fnd_msg_pub.add;
693: RAISE fnd_api.g_exc_error ;
694: END IF ; --p_dest_location_tbl.COUNT
695:
696:
697: -- override destination location attribs based on transaction type

Line 721: IF nvl(l_dest_location_rec.location_type_code, fnd_api.g_miss_char) = fnd_api.g_miss_char

717: l_dest_location_rec.operational_status_code := 'OUT_OF_SERVICE' ;
718: l_dest_location_rec.instance_usage_code := 'OUT_OF_SERVICE';
719: ELSIF l_txn_rec.transaction_type_id = 111 THEN -- item move
720: --fix for the bug 4620445
721: IF nvl(l_dest_location_rec.location_type_code, fnd_api.g_miss_char) = fnd_api.g_miss_char
722: OR
723: nvl(l_dest_location_rec.location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
724: THEN
725: fnd_message.set_name('CSI','CSI_DPL_INVALID_LOCATION');

Line 723: nvl(l_dest_location_rec.location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num

719: ELSIF l_txn_rec.transaction_type_id = 111 THEN -- item move
720: --fix for the bug 4620445
721: IF nvl(l_dest_location_rec.location_type_code, fnd_api.g_miss_char) = fnd_api.g_miss_char
722: OR
723: nvl(l_dest_location_rec.location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
724: THEN
725: fnd_message.set_name('CSI','CSI_DPL_INVALID_LOCATION');
726: fnd_msg_pub.add;
727: RAISE fnd_api.g_exc_error;

Line 727: RAISE fnd_api.g_exc_error;

723: nvl(l_dest_location_rec.location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
724: THEN
725: fnd_message.set_name('CSI','CSI_DPL_INVALID_LOCATION');
726: fnd_msg_pub.add;
727: RAISE fnd_api.g_exc_error;
728: END IF;
729: l_dest_location_rec.operational_status_code := l_operational_status_code;
730: l_dest_location_rec.instance_usage_code := l_instance_usage_code;
731: ELSIF l_txn_rec.transaction_type_id in (107, 155) THEN -- uninstall

Line 757: RAISE fnd_api.g_exc_error;

753: l_dest_location_rec.operational_status_code := 'OUT_OF_SERVICE';
754: ELSE
755: fnd_message.set_name('CSI','CSI_INVALID_TXN_TYPE_ID');
756: fnd_msg_pub.add;
757: RAISE fnd_api.g_exc_error;
758: END IF; ---Txn Type
759:
760: IF p_ext_attrib_values_tbl.COUNT > 0 THEN
761: FOR av_ind IN p_ext_attrib_values_tbl.FIRST .. p_ext_attrib_values_tbl.LAST

Line 791: IF l_return_status not in (fnd_api.g_ret_sts_success, 'W') THEN

787: p_financial_flag => p_txn_tbl(si_ind).financial_flag,
788: px_txn_rec => l_txn_rec,
789: x_return_status => l_return_status);
790:
791: IF l_return_status not in (fnd_api.g_ret_sts_success, 'W') THEN
792: RAISE fnd_api.g_exc_error;
793: END IF;
794: ELSE
795:

Line 792: RAISE fnd_api.g_exc_error;

788: px_txn_rec => l_txn_rec,
789: x_return_status => l_return_status);
790:
791: IF l_return_status not in (fnd_api.g_ret_sts_success, 'W') THEN
792: RAISE fnd_api.g_exc_error;
793: END IF;
794: ELSE
795:
796: IF l_owner_party_account_id is not null AND l_t_inst_tbl(1).serial_number is null THEN

Line 810: IF l_return_status <> fnd_api.g_ret_sts_success THEN

806: x_t_ou_tbl => l_t_ou_tbl,
807: x_t_price_tbl => l_t_price_tbl,
808: x_return_status => l_return_status);
809:
810: IF l_return_status <> fnd_api.g_ret_sts_success THEN
811: RAISE fnd_api.g_exc_error;
812: END IF;
813:
814: END IF;

Line 811: RAISE fnd_api.g_exc_error;

807: x_t_price_tbl => l_t_price_tbl,
808: x_return_status => l_return_status);
809:
810: IF l_return_status <> fnd_api.g_ret_sts_success THEN
811: RAISE fnd_api.g_exc_error;
812: END IF;
813:
814: END IF;
815:

Line 818: p_commit => fnd_api.g_false,

814: END IF;
815:
816: csi_process_txn_grp.process_transaction(
817: p_api_version => 1.0,
818: p_commit => fnd_api.g_false,
819: p_init_msg_list => fnd_api.g_false,
820: p_validation_level => fnd_api.g_valid_level_full,
821: p_validate_only_flag => fnd_api.g_false,
822: p_in_out_flag => 'INT',

Line 819: p_init_msg_list => fnd_api.g_false,

815:
816: csi_process_txn_grp.process_transaction(
817: p_api_version => 1.0,
818: p_commit => fnd_api.g_false,
819: p_init_msg_list => fnd_api.g_false,
820: p_validation_level => fnd_api.g_valid_level_full,
821: p_validate_only_flag => fnd_api.g_false,
822: p_in_out_flag => 'INT',
823: p_dest_location_rec => l_dest_location_rec ,

Line 820: p_validation_level => fnd_api.g_valid_level_full,

816: csi_process_txn_grp.process_transaction(
817: p_api_version => 1.0,
818: p_commit => fnd_api.g_false,
819: p_init_msg_list => fnd_api.g_false,
820: p_validation_level => fnd_api.g_valid_level_full,
821: p_validate_only_flag => fnd_api.g_false,
822: p_in_out_flag => 'INT',
823: p_dest_location_rec => l_dest_location_rec ,
824: p_txn_rec => l_txn_rec ,

Line 821: p_validate_only_flag => fnd_api.g_false,

817: p_api_version => 1.0,
818: p_commit => fnd_api.g_false,
819: p_init_msg_list => fnd_api.g_false,
820: p_validation_level => fnd_api.g_valid_level_full,
821: p_validate_only_flag => fnd_api.g_false,
822: p_in_out_flag => 'INT',
823: p_dest_location_rec => l_dest_location_rec ,
824: p_txn_rec => l_txn_rec ,
825: p_instances_tbl => l_t_inst_tbl,

Line 838: IF l_return_status <> fnd_api.g_ret_sts_success THEN

834: x_return_status => l_return_status,
835: x_msg_count => l_msg_count,
836: x_msg_data => l_msg_data);
837:
838: IF l_return_status <> fnd_api.g_ret_sts_success THEN
839: RAISE fnd_api.g_exc_error;
840: END IF;
841: END IF; -- retirement/non retirement transactions
842:

Line 839: RAISE fnd_api.g_exc_error;

835: x_msg_count => l_msg_count,
836: x_msg_data => l_msg_data);
837:
838: IF l_return_status <> fnd_api.g_ret_sts_success THEN
839: RAISE fnd_api.g_exc_error;
840: END IF;
841: END IF; -- retirement/non retirement transactions
842:
843: END LOOP ;

Line 847: WHEN fnd_api.g_exc_error THEN

843: END LOOP ;
844: END IF ; --p_instance_tbl.COUNT > 0
845:
846: EXCEPTION
847: WHEN fnd_api.g_exc_error THEN
848: x_return_status := fnd_api.g_ret_sts_error;
849: x_error_msg := nvl(l_error_msg, cse_util_pkg.dump_error_stack);
850: debug('Error : '||x_error_msg);
851: END process_transaction;

Line 848: x_return_status := fnd_api.g_ret_sts_error;

844: END IF ; --p_instance_tbl.COUNT > 0
845:
846: EXCEPTION
847: WHEN fnd_api.g_exc_error THEN
848: x_return_status := fnd_api.g_ret_sts_error;
849: x_error_msg := nvl(l_error_msg, cse_util_pkg.dump_error_stack);
850: debug('Error : '||x_error_msg);
851: END process_transaction;
852: END cse_deployment_grp;