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 name: interface_nl_to_pa */

Line 498: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

494: x_return_status OUT NOCOPY VARCHAR2,
495: x_error_message OUT NOCOPY VARCHAR2)
496: IS
497: l_api_name CONSTANT VARCHAR2(30) := 'cse_deployment_grp';
498: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
499: l_error_message VARCHAR2(2000);
500: l_msg_count NUMBER;
501: l_msg_data VARCHAR2(2000);
502: l_api_version NUMBER DEFAULT 1.0;

Line 503: l_commit VARCHAR2(1) DEFAULT FND_API.G_FALSE;

499: l_error_message VARCHAR2(2000);
500: l_msg_count NUMBER;
501: l_msg_data VARCHAR2(2000);
502: l_api_version NUMBER DEFAULT 1.0;
503: l_commit VARCHAR2(1) DEFAULT FND_API.G_FALSE;
504: l_init_msg_list VARCHAR2(1) DEFAULT FND_API.G_TRUE;
505: l_validation_level NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL;
506: l_active_instance_only VARCHAR2(1) DEFAULT FND_API.G_TRUE;
507: l_txn_rec csi_datastructures_pub.transaction_rec;

Line 504: l_init_msg_list VARCHAR2(1) DEFAULT FND_API.G_TRUE;

500: l_msg_count NUMBER;
501: l_msg_data VARCHAR2(2000);
502: l_api_version NUMBER DEFAULT 1.0;
503: l_commit VARCHAR2(1) DEFAULT FND_API.G_FALSE;
504: l_init_msg_list VARCHAR2(1) DEFAULT FND_API.G_TRUE;
505: l_validation_level NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL;
506: l_active_instance_only VARCHAR2(1) DEFAULT FND_API.G_TRUE;
507: l_txn_rec csi_datastructures_pub.transaction_rec;
508: l_asset_location_rec csi_datastructures_pub.instance_asset_location_rec;

Line 505: l_validation_level NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL;

501: l_msg_data VARCHAR2(2000);
502: l_api_version NUMBER DEFAULT 1.0;
503: l_commit VARCHAR2(1) DEFAULT FND_API.G_FALSE;
504: l_init_msg_list VARCHAR2(1) DEFAULT FND_API.G_TRUE;
505: l_validation_level NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL;
506: l_active_instance_only VARCHAR2(1) DEFAULT FND_API.G_TRUE;
507: l_txn_rec csi_datastructures_pub.transaction_rec;
508: l_asset_location_rec csi_datastructures_pub.instance_asset_location_rec;
509: l_asset_location_tbl csi_datastructures_pub.instance_asset_location_tbl;

Line 506: l_active_instance_only VARCHAR2(1) DEFAULT FND_API.G_TRUE;

502: l_api_version NUMBER DEFAULT 1.0;
503: l_commit VARCHAR2(1) DEFAULT FND_API.G_FALSE;
504: l_init_msg_list VARCHAR2(1) DEFAULT FND_API.G_TRUE;
505: l_validation_level NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL;
506: l_active_instance_only VARCHAR2(1) DEFAULT FND_API.G_TRUE;
507: l_txn_rec csi_datastructures_pub.transaction_rec;
508: l_asset_location_rec csi_datastructures_pub.instance_asset_location_rec;
509: l_asset_location_tbl csi_datastructures_pub.instance_asset_location_tbl;
510: l_nl_pa_interface_tbl CSE_IPA_TRANS_PKG.nl_pa_interface_tbl_type;

Line 698: x_return_status := FND_API.G_RET_STS_SUCCESS;

694:
695: l_Business_Group_rec c_Business_Group_cur%ROWTYPE;
696:
697: BEGIN
698: x_return_status := FND_API.G_RET_STS_SUCCESS;
699: x_error_message := NULL;
700: cse_util_pkg.set_debug;
701:
702: debug('Inside API cse_deployment_grp.interface_nl_to_pa');

Line 773: RAISE fnd_api.g_exc_error;

769: x_status => l_paapi_status);
770:
771: IF l_paapi_status <> 0 THEN
772: l_error_message := sqlerrm;
773: RAISE fnd_api.g_exc_error;
774: END IF;
775:
776: SELECT name
777: INTO l_organization_name

Line 798: IF( p_trf_pa_attr_rec.transaction_id = FND_API.G_MISS_NUM)

794: CLOSE c_Business_Group_cur;
795:
796: l_nl_pa_interface_tbl(i).transaction_source := ei_rec.transaction_source;
797:
798: IF( p_trf_pa_attr_rec.transaction_id = FND_API.G_MISS_NUM)
799: THEN
800: l_nl_pa_interface_tbl(i).batch_name := FND_API.G_MISS_CHAR;
801: ELSE
802: l_nl_pa_interface_tbl(i).batch_name := p_trf_pa_attr_rec.transaction_id;

Line 800: l_nl_pa_interface_tbl(i).batch_name := FND_API.G_MISS_CHAR;

796: l_nl_pa_interface_tbl(i).transaction_source := ei_rec.transaction_source;
797:
798: IF( p_trf_pa_attr_rec.transaction_id = FND_API.G_MISS_NUM)
799: THEN
800: l_nl_pa_interface_tbl(i).batch_name := FND_API.G_MISS_CHAR;
801: ELSE
802: l_nl_pa_interface_tbl(i).batch_name := p_trf_pa_attr_rec.transaction_id;
803: END IF;
804:

Line 1069: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN

1065: cse_ipa_trans_pkg.populate_pa_interface(
1066: p_nl_pa_interface_tbl => l_nl_pa_interface_tbl,
1067: x_return_status => l_return_status,
1068: x_error_message => l_error_message);
1069: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
1070: debug('error_ message : '||l_error_message);
1071: RAISE fnd_api.g_exc_error;
1072: END IF;
1073:

Line 1071: RAISE fnd_api.g_exc_error;

1067: x_return_status => l_return_status,
1068: x_error_message => l_error_message);
1069: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
1070: debug('error_ message : '||l_error_message);
1071: RAISE fnd_api.g_exc_error;
1072: END IF;
1073:
1074: --update transaction record with new txn_status_code = 'INTERFACE_TO_PA'
1075: /* --commented for bug 8670632 --

Line 1101: IF NOT (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1097: x_return_status => l_return_status,
1098: x_msg_count => l_msg_count,
1099: x_msg_data => l_msg_data);
1100:
1101: IF NOT (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1102: RAISE fnd_api.g_exc_error;
1103: END IF;
1104: --commented for bug 8670632 --
1105: */

Line 1102: RAISE fnd_api.g_exc_error;

1098: x_msg_count => l_msg_count,
1099: x_msg_data => l_msg_data);
1100:
1101: IF NOT (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1102: RAISE fnd_api.g_exc_error;
1103: END IF;
1104: --commented for bug 8670632 --
1105: */
1106: END IF;

Line 1109: WHEN fnd_api.g_exc_error THEN

1105: */
1106: END IF;
1107:
1108: EXCEPTION
1109: WHEN fnd_api.g_exc_error THEN
1110: x_return_status := l_return_status;
1111: x_error_message := l_error_message;
1112: debug('Error in cse_deployment_grp.interface_nl_to_pa : '||x_error_message);
1113: WHEN OTHERS THEN

Line 1117: x_return_status := fnd_api.g_ret_sts_unexp_error;

1113: WHEN OTHERS THEN
1114: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
1115: fnd_message.set_token('ERR_MSG',l_api_name||'='|| SQLERRM);
1116: x_error_message := fnd_message.get;
1117: x_return_status := fnd_api.g_ret_sts_unexp_error;
1118: debug('Inside others exception in cse_deployment_grp.interface_nl_to_pa : ' ||x_error_message);
1119: END interface_nl_to_pa;
1120: -- Added for 8670632--
1121:

Line 1168: x_return_status := fnd_api.g_ret_sts_success ;

1164: l_operational_status_code varchar2(80);
1165: l_t_eav_tbl_empty csi_process_txn_grp.txn_ext_attrib_values_tbl ;--Added for 9262531
1166: BEGIN
1167:
1168: x_return_status := fnd_api.g_ret_sts_success ;
1169:
1170: savepoint process_transaction;
1171:
1172: cse_util_pkg.set_debug;

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

1253: l_txn_rec.source_header_ref_id := nvl(l_project_id, l_last_project_id);
1254: l_txn_rec.source_line_ref_id := nvl(l_task_id, l_last_task_id);
1255: ELSE
1256: l_txn_rec.source_header_ref_id := p_txn_tbl(si_ind).source_header_ref_id;
1257: l_txn_rec.source_line_ref_id := fnd_api.g_miss_num;
1258: END IF;
1259:
1260: l_txn_rec.source_header_ref := p_txn_tbl(si_ind).source_header_ref;
1261: l_txn_rec.source_line_ref := fnd_api.g_miss_char;

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

1257: l_txn_rec.source_line_ref_id := fnd_api.g_miss_num;
1258: END IF;
1259:
1260: l_txn_rec.source_header_ref := p_txn_tbl(si_ind).source_header_ref;
1261: l_txn_rec.source_line_ref := fnd_api.g_miss_char;
1262: l_txn_rec.txn_sub_type_id := p_txn_tbl(si_ind).txn_sub_type_id ;
1263: l_txn_rec.source_transaction_date := p_txn_tbl(si_ind).source_transaction_date ;
1264: l_txn_rec.transaction_quantity := p_txn_tbl(si_ind).transaction_quantity ;
1265:

Line 1343: RAISE fnd_api.g_exc_error ;

1339:
1340: ELSE
1341: fnd_message.set_name('CSI','CSI_DPL_INVALID_LOCATION');
1342: fnd_msg_pub.add;
1343: RAISE fnd_api.g_exc_error ;
1344: END IF ; --p_dest_location_tbl.COUNT
1345:
1346:
1347: -- override destination location attribs based on transaction type

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

1376: l_dest_location_rec.operational_status_code := 'OUT_OF_SERVICE' ;
1377: l_dest_location_rec.instance_usage_code := 'OUT_OF_SERVICE';
1378: ELSIF l_txn_rec.transaction_type_id = 111 THEN -- item move
1379: --fix for the bug 4620445
1380: IF nvl(l_dest_location_rec.location_type_code, fnd_api.g_miss_char) = fnd_api.g_miss_char
1381: OR
1382: nvl(l_dest_location_rec.location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
1383: THEN
1384: fnd_message.set_name('CSI','CSI_DPL_INVALID_LOCATION');

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

1378: ELSIF l_txn_rec.transaction_type_id = 111 THEN -- item move
1379: --fix for the bug 4620445
1380: IF nvl(l_dest_location_rec.location_type_code, fnd_api.g_miss_char) = fnd_api.g_miss_char
1381: OR
1382: nvl(l_dest_location_rec.location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
1383: THEN
1384: fnd_message.set_name('CSI','CSI_DPL_INVALID_LOCATION');
1385: fnd_msg_pub.add;
1386: RAISE fnd_api.g_exc_error;

Line 1386: RAISE fnd_api.g_exc_error;

1382: nvl(l_dest_location_rec.location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
1383: THEN
1384: fnd_message.set_name('CSI','CSI_DPL_INVALID_LOCATION');
1385: fnd_msg_pub.add;
1386: RAISE fnd_api.g_exc_error;
1387: END IF;
1388: l_dest_location_rec.operational_status_code := l_operational_status_code;
1389: l_dest_location_rec.instance_usage_code := l_instance_usage_code;
1390: ELSIF l_txn_rec.transaction_type_id in (107, 155) THEN -- uninstall

Line 1418: RAISE fnd_api.g_exc_error;

1414: l_dest_location_rec.operational_status_code := 'OUT_OF_SERVICE';
1415: ELSE
1416: fnd_message.set_name('CSI','CSI_INVALID_TXN_TYPE_ID');
1417: fnd_msg_pub.add;
1418: RAISE fnd_api.g_exc_error;
1419: END IF; ---Txn Type
1420:
1421: -- Bug 9262531
1422: ind := 0;

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

1455: p_financial_flag => p_txn_tbl(si_ind).financial_flag,
1456: px_txn_rec => l_txn_rec,
1457: x_return_status => l_return_status);
1458:
1459: IF l_return_status not in (fnd_api.g_ret_sts_success, 'W') THEN
1460: RAISE fnd_api.g_exc_error;
1461: END IF;
1462: ELSE
1463:

Line 1460: RAISE fnd_api.g_exc_error;

1456: px_txn_rec => l_txn_rec,
1457: x_return_status => l_return_status);
1458:
1459: IF l_return_status not in (fnd_api.g_ret_sts_success, 'W') THEN
1460: RAISE fnd_api.g_exc_error;
1461: END IF;
1462: ELSE
1463:
1464: IF l_owner_party_account_id is not null AND l_t_inst_tbl(1).serial_number is null THEN

Line 1478: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1474: x_t_ou_tbl => l_t_ou_tbl,
1475: x_t_price_tbl => l_t_price_tbl,
1476: x_return_status => l_return_status);
1477:
1478: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1479: RAISE fnd_api.g_exc_error;
1480: END IF;
1481:
1482: END IF;

Line 1479: RAISE fnd_api.g_exc_error;

1475: x_t_price_tbl => l_t_price_tbl,
1476: x_return_status => l_return_status);
1477:
1478: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1479: RAISE fnd_api.g_exc_error;
1480: END IF;
1481:
1482: END IF;
1483:

Line 1486: p_commit => fnd_api.g_false,

1482: END IF;
1483:
1484: csi_process_txn_grp.process_transaction(
1485: p_api_version => 1.0,
1486: p_commit => fnd_api.g_false,
1487: p_init_msg_list => fnd_api.g_false,
1488: p_validation_level => fnd_api.g_valid_level_full,
1489: p_validate_only_flag => fnd_api.g_false,
1490: p_in_out_flag => 'INT',

Line 1487: p_init_msg_list => fnd_api.g_false,

1483:
1484: csi_process_txn_grp.process_transaction(
1485: p_api_version => 1.0,
1486: p_commit => fnd_api.g_false,
1487: p_init_msg_list => fnd_api.g_false,
1488: p_validation_level => fnd_api.g_valid_level_full,
1489: p_validate_only_flag => fnd_api.g_false,
1490: p_in_out_flag => 'INT',
1491: p_dest_location_rec => l_dest_location_rec ,

Line 1488: p_validation_level => fnd_api.g_valid_level_full,

1484: csi_process_txn_grp.process_transaction(
1485: p_api_version => 1.0,
1486: p_commit => fnd_api.g_false,
1487: p_init_msg_list => fnd_api.g_false,
1488: p_validation_level => fnd_api.g_valid_level_full,
1489: p_validate_only_flag => fnd_api.g_false,
1490: p_in_out_flag => 'INT',
1491: p_dest_location_rec => l_dest_location_rec ,
1492: p_txn_rec => l_txn_rec ,

Line 1489: p_validate_only_flag => fnd_api.g_false,

1485: p_api_version => 1.0,
1486: p_commit => fnd_api.g_false,
1487: p_init_msg_list => fnd_api.g_false,
1488: p_validation_level => fnd_api.g_valid_level_full,
1489: p_validate_only_flag => fnd_api.g_false,
1490: p_in_out_flag => 'INT',
1491: p_dest_location_rec => l_dest_location_rec ,
1492: p_txn_rec => l_txn_rec ,
1493: p_instances_tbl => l_t_inst_tbl,

Line 1506: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1502: x_return_status => l_return_status,
1503: x_msg_count => l_msg_count,
1504: x_msg_data => l_msg_data);
1505:
1506: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1507: RAISE fnd_api.g_exc_error;
1508: END IF;
1509: END IF; -- retirement/non retirement transactions
1510:

Line 1507: RAISE fnd_api.g_exc_error;

1503: x_msg_count => l_msg_count,
1504: x_msg_data => l_msg_data);
1505:
1506: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1507: RAISE fnd_api.g_exc_error;
1508: END IF;
1509: END IF; -- retirement/non retirement transactions
1510:
1511: --Added for Bug 8670632

Line 1542: WHEN fnd_api.g_exc_error THEN

1538: END LOOP ;
1539: END IF ; --p_instance_tbl.COUNT > 0
1540:
1541: EXCEPTION
1542: WHEN fnd_api.g_exc_error THEN
1543: x_return_status := fnd_api.g_ret_sts_error;
1544: x_error_msg := nvl(l_error_msg, cse_util_pkg.dump_error_stack);
1545: debug('Error : '||x_error_msg);
1546: rollback to process_transaction;

Line 1543: x_return_status := fnd_api.g_ret_sts_error;

1539: END IF ; --p_instance_tbl.COUNT > 0
1540:
1541: EXCEPTION
1542: WHEN fnd_api.g_exc_error THEN
1543: x_return_status := fnd_api.g_ret_sts_error;
1544: x_error_msg := nvl(l_error_msg, cse_util_pkg.dump_error_stack);
1545: debug('Error : '||x_error_msg);
1546: rollback to process_transaction;
1547: END process_transaction;