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

Line 27: p_encoded => fnd_api.g_false,

23: FOR l_ind IN 1..l_msg_count
24: LOOP
25: fnd_msg_pub.get(
26: p_msg_index => l_ind,
27: p_encoded => fnd_api.g_false,
28: p_data => l_msg_data,
29: p_msg_index_out => l_msg_index_out);
30:
31: x_msg_data := ltrim(x_msg_data||' '||l_msg_data);

Line 113: x_return_status := fnd_api.g_ret_sts_success;

109: BEGIN
110:
111: debug('validate_inst_asset');
112:
113: x_return_status := fnd_api.g_ret_sts_success;
114:
115: IF nvl(px_inst_asset_rec.instance_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
116: SELECT accounting_class_code,
117: location_type_code,

Line 115: IF nvl(px_inst_asset_rec.instance_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

111: debug('validate_inst_asset');
112:
113: x_return_status := fnd_api.g_ret_sts_success;
114:
115: IF nvl(px_inst_asset_rec.instance_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
116: SELECT accounting_class_code,
117: location_type_code,
118: inventory_item_id,
119: last_vld_organization_id,

Line 136: RAISE fnd_api.g_exc_error;

132: fnd_message.set_name('CSI', 'CSI_INST_ASSET_AC_INVALID');
133: fnd_message.set_token('INST_NUM', l_inst_num);
134: fnd_message.set_token('AC_CODE', l_acct_class_code);
135: fnd_msg_pub.add;
136: RAISE fnd_api.g_exc_error;
137: END IF;
138:
139: IF l_location_type_code in ('WIP', 'PROJECT', 'IN_TRANSIT') THEN
140: fnd_message.set_name('CSI', 'CSI_INST_ASSET_LOC_INVALID');

Line 144: RAISE fnd_api.g_exc_error;

140: fnd_message.set_name('CSI', 'CSI_INST_ASSET_LOC_INVALID');
141: fnd_message.set_token('INST_NUM', l_inst_num);
142: fnd_message.set_token('LOC_CODE', l_location_type_code);
143: fnd_msg_pub.add;
144: RAISE fnd_api.g_exc_error;
145: END IF;
146:
147: SELECT asset_creation_code,
148: segment1,

Line 171: RAISE fnd_api.g_exc_error;

167: IF l_pending_txn THEN
168: fnd_message.set_name('CSI', 'CSI_DEPR_ADD_PENDING_TXN');
169: fnd_message.set_token('TXN_ID', l_pending_txn_id);
170: fnd_msg_pub.add;
171: RAISE fnd_api.g_exc_error;
172: END IF;
173:
174: l_pending_mass_add := FALSE;
175: FOR pending_mass_add_rec IN pending_mass_add_cur(px_inst_asset_rec.instance_id)

Line 186: RAISE fnd_api.g_exc_error;

182: IF l_pending_mass_add THEN
183: fnd_message.set_name('CSI', 'CSI_DEPR_ADD_PENDING_MASSADD');
184: fnd_message.set_token('MASS_ADD_ID', l_fa_mass_add_id);
185: fnd_msg_pub.add;
186: RAISE fnd_api.g_exc_error;
187: END IF;
188:
189: END IF;
190:

Line 198: IF nvl(px_inst_asset_rec.instance_asset_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

194: debug('fa_asset_id : '||px_inst_asset_rec.fa_asset_id);
195:
196: IF l_serial_code in (2, 5) or l_serial_number is not null THEN
197:
198: IF nvl(px_inst_asset_rec.instance_asset_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
199: -- create case
200: FOR uniq_fa_rec IN uniq_fa_cur(px_inst_asset_rec.instance_id)
201: LOOP
202: fnd_message.set_name('CSI', 'CSI_SRL_DUP_FA_ERROR');

Line 206: raise fnd_api.g_exc_error;

202: fnd_message.set_name('CSI', 'CSI_SRL_DUP_FA_ERROR');
203: fnd_message.set_token('INST_ID', px_inst_asset_rec.instance_id);
204: fnd_message.set_token('ASSET_ID', uniq_fa_rec.fa_asset_id);
205: fnd_msg_pub.add;
206: raise fnd_api.g_exc_error;
207: END LOOP;
208:
209: ELSE
210: null;

Line 225: WHEN fnd_api.g_exc_error THEN

221:
222: END IF;
223:
224: EXCEPTION
225: WHEN fnd_api.g_exc_error THEN
226: x_return_status := fnd_api.g_ret_sts_error;
227: END validate_inst_asset;
228:
229: PROCEDURE derive_fa_missing_values(

Line 226: x_return_status := fnd_api.g_ret_sts_error;

222: END IF;
223:
224: EXCEPTION
225: WHEN fnd_api.g_exc_error THEN
226: x_return_status := fnd_api.g_ret_sts_error;
227: END validate_inst_asset;
228:
229: PROCEDURE derive_fa_missing_values(
230: p_instance_rec IN csi_datastructures_pub.instance_rec,

Line 278: x_return_status := fnd_api.g_ret_sts_success;

274: ORDER BY date_effective desc; -- latest one first
275:
276: BEGIN
277:
278: x_return_status := fnd_api.g_ret_sts_success;
279:
280: debug('derive fa loc');
281:
282: IF nvl(p_fixed_asset_rec.book_type_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char THEN

Line 282: IF nvl(p_fixed_asset_rec.book_type_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char THEN

278: x_return_status := fnd_api.g_ret_sts_success;
279:
280: debug('derive fa loc');
281:
282: IF nvl(p_fixed_asset_rec.book_type_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char THEN
283: l_fa_book_type_code := p_fixed_asset_rec.book_type_code;
284: ELSE
285: FOR btc_rec IN btc_cur(p_fixed_asset_rec.asset_id)
286: LOOP

Line 294: IF nvl(p_instance_rec.instance_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

290: END IF;
291:
292: l_location_table := null;
293:
294: IF nvl(p_instance_rec.instance_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
295: SELECT location_type_code,
296: location_id,
297: quantity
298: INTO l_location_type_code,

Line 308: IF nvl(p_fixed_asset_rec.asset_location_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

304: l_location_type_code := p_instance_rec.location_type_code;
305: l_location_id := p_instance_rec.location_id;
306: END IF;
307:
308: IF nvl(p_fixed_asset_rec.asset_location_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
309: l_fa_location_id := p_fixed_asset_rec.asset_location_id;
310: ELSE
311:
312: l_location_table := null;

Line 389: l_miss_num number := fnd_api.g_miss_num;

385: l_fa_location_id number;
386: l_fa_quantity number;
387: l_fa_book_type_code varchar2(30);
388:
389: l_miss_num number := fnd_api.g_miss_num;
390: l_miss_char varchar2(200) := fnd_api.g_miss_char;
391:
392: l_serial_control_code number;
393: l_eam_item_type number;

Line 390: l_miss_char varchar2(200) := fnd_api.g_miss_char;

386: l_fa_quantity number;
387: l_fa_book_type_code varchar2(30);
388:
389: l_miss_num number := fnd_api.g_miss_num;
390: l_miss_char varchar2(200) := fnd_api.g_miss_char;
391:
392: l_serial_control_code number;
393: l_eam_item_type number;
394: l_eam_item boolean := FALSE;

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

404: l_csi_txn_tbl csi_datastructures_pub.transaction_tbl;
405: l_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
406:
407:
408: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
409: l_msg_count number;
410: l_msg_data varchar2(2000);
411: l_error_message varchar2(2000);
412: l_warning_flag varchar2(1) := 'N';

Line 426: x_return_status := fnd_api.g_ret_sts_success;

422: l_error_msg VARCHAR2(5000) := '';
423:
424: BEGIN
425:
426: x_return_status := fnd_api.g_ret_sts_success;
427:
428: savepoint fa_grp_create_instance;
429:
430: -- validate mandatory fields

Line 469: IF nvl(p_instance_rec.inventory_item_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num

465: p_param_name => 'px_csi_txn_rec.transaction_type_id',
466: p_api_name => 'csi_fa_instance_grp.create_item_instance');
467:
468: -- derive eam_item_type
469: IF nvl(p_instance_rec.inventory_item_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
470: AND
471: nvl(p_instance_rec.vld_organization_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
472: THEN
473:

Line 471: nvl(p_instance_rec.vld_organization_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num

467:
468: -- derive eam_item_type
469: IF nvl(p_instance_rec.inventory_item_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
470: AND
471: nvl(p_instance_rec.vld_organization_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
472: THEN
473:
474: SELECT eam_item_type,
475: serial_number_control_code

Line 488: IF nvl(p_fixed_asset_rec.asset_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

484: END IF;
485:
486: END IF;
487:
488: IF nvl(p_fixed_asset_rec.asset_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
489:
490: IF nvl(p_fixed_asset_rec.asset_location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
491: OR
492: nvl(p_fixed_asset_rec.asset_quantity, fnd_api.g_miss_num) = fnd_api.g_miss_num

Line 490: IF nvl(p_fixed_asset_rec.asset_location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num

486: END IF;
487:
488: IF nvl(p_fixed_asset_rec.asset_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
489:
490: IF nvl(p_fixed_asset_rec.asset_location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
491: OR
492: nvl(p_fixed_asset_rec.asset_quantity, fnd_api.g_miss_num) = fnd_api.g_miss_num
493: OR
494: nvl(p_fixed_asset_rec.book_type_code, fnd_api.g_miss_char) = fnd_api.g_miss_char

Line 492: nvl(p_fixed_asset_rec.asset_quantity, fnd_api.g_miss_num) = fnd_api.g_miss_num

488: IF nvl(p_fixed_asset_rec.asset_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
489:
490: IF nvl(p_fixed_asset_rec.asset_location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
491: OR
492: nvl(p_fixed_asset_rec.asset_quantity, fnd_api.g_miss_num) = fnd_api.g_miss_num
493: OR
494: nvl(p_fixed_asset_rec.book_type_code, fnd_api.g_miss_char) = fnd_api.g_miss_char
495: THEN
496:

Line 494: nvl(p_fixed_asset_rec.book_type_code, fnd_api.g_miss_char) = fnd_api.g_miss_char

490: IF nvl(p_fixed_asset_rec.asset_location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
491: OR
492: nvl(p_fixed_asset_rec.asset_quantity, fnd_api.g_miss_num) = fnd_api.g_miss_num
493: OR
494: nvl(p_fixed_asset_rec.book_type_code, fnd_api.g_miss_char) = fnd_api.g_miss_char
495: THEN
496:
497: derive_fa_missing_values(
498: p_instance_rec => p_instance_rec,

Line 505: IF l_return_status <> fnd_api.g_ret_sts_success THEN

501: x_fa_quantity => l_fa_quantity,
502: x_fa_book_type_code => l_fa_book_type_code,
503: x_return_status => l_return_status);
504:
505: IF l_return_status <> fnd_api.g_ret_sts_success THEN
506: RAISE fnd_api.g_exc_error;
507: END IF;
508: END IF;
509: END IF;

Line 506: RAISE fnd_api.g_exc_error;

502: x_fa_book_type_code => l_fa_book_type_code,
503: x_return_status => l_return_status);
504:
505: IF l_return_status <> fnd_api.g_ret_sts_success THEN
506: RAISE fnd_api.g_exc_error;
507: END IF;
508: END IF;
509: END IF;
510:

Line 513: p_commit => fnd_api.g_false,

509: END IF;
510:
511: csi_transactions_pvt.create_transaction(
512: p_api_version => 1.0,
513: p_commit => fnd_api.g_false,
514: p_init_msg_list => fnd_api.g_true,
515: p_validation_level => fnd_api.g_valid_level_full,
516: p_success_if_exists_flag => 'Y',
517: p_transaction_rec => px_csi_txn_rec,

Line 514: p_init_msg_list => fnd_api.g_true,

510:
511: csi_transactions_pvt.create_transaction(
512: p_api_version => 1.0,
513: p_commit => fnd_api.g_false,
514: p_init_msg_list => fnd_api.g_true,
515: p_validation_level => fnd_api.g_valid_level_full,
516: p_success_if_exists_flag => 'Y',
517: p_transaction_rec => px_csi_txn_rec,
518: x_return_status => l_return_status,

Line 515: p_validation_level => fnd_api.g_valid_level_full,

511: csi_transactions_pvt.create_transaction(
512: p_api_version => 1.0,
513: p_commit => fnd_api.g_false,
514: p_init_msg_list => fnd_api.g_true,
515: p_validation_level => fnd_api.g_valid_level_full,
516: p_success_if_exists_flag => 'Y',
517: p_transaction_rec => px_csi_txn_rec,
518: x_return_status => l_return_status,
519: x_msg_count => l_msg_count,

Line 522: IF l_return_status <> fnd_api.g_ret_sts_success THEN

518: x_return_status => l_return_status,
519: x_msg_count => l_msg_count,
520: x_msg_data => l_msg_data);
521:
522: IF l_return_status <> fnd_api.g_ret_sts_success THEN
523: RAISE fnd_api.g_exc_error;
524: END IF;
525:
526: IF p_instance_serial_tbl.COUNT > 0 THEN

Line 523: RAISE fnd_api.g_exc_error;

519: x_msg_count => l_msg_count,
520: x_msg_data => l_msg_data);
521:
522: IF l_return_status <> fnd_api.g_ret_sts_success THEN
523: RAISE fnd_api.g_exc_error;
524: END IF;
525:
526: IF p_instance_serial_tbl.COUNT > 0 THEN
527: FOR srl_ind IN p_instance_serial_tbl.FIRST .. p_instance_serial_tbl.LAST

Line 585: IF nvl(p_fixed_asset_rec.asset_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

581:
582: END LOOP;
583: END IF;
584:
585: IF nvl(p_fixed_asset_rec.asset_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
586: g_ia_ind := g_ia_ind + 1;
587: l_instance_asset_tbl(g_ia_ind).parent_tbl_index := g_inst_ind;
588: l_instance_asset_tbl(g_ia_ind).fa_asset_id := p_fixed_asset_rec.asset_id;
589: l_instance_asset_tbl(g_ia_ind).fa_book_type_code := l_fa_book_type_code;

Line 595: nvl(p_fixed_asset_rec.fa_sync_validation_reqd, fnd_api.g_false);

591: l_instance_asset_tbl(g_ia_ind).asset_quantity := 1; -- for serialized
592: l_instance_asset_tbl(g_ia_ind).update_status := 'IN_SERVICE';
593: l_instance_asset_tbl(g_ia_ind).fa_sync_flag := p_fixed_asset_rec.fa_sync_flag;
594: l_instance_asset_tbl(g_ia_ind).fa_sync_validation_reqd :=
595: nvl(p_fixed_asset_rec.fa_sync_validation_reqd, fnd_api.g_false);
596:
597: validate_inst_asset(
598: px_inst_asset_rec => l_instance_asset_tbl(g_ia_ind),
599: x_return_status => l_return_status);

Line 601: IF l_return_status <> fnd_api.g_ret_sts_success THEN

597: validate_inst_asset(
598: px_inst_asset_rec => l_instance_asset_tbl(g_ia_ind),
599: x_return_status => l_return_status);
600:
601: IF l_return_status <> fnd_api.g_ret_sts_success THEN
602: RAISE fnd_api.g_exc_error;
603: END IF;
604:
605: END IF;

Line 602: RAISE fnd_api.g_exc_error;

598: px_inst_asset_rec => l_instance_asset_tbl(g_ia_ind),
599: x_return_status => l_return_status);
600:
601: IF l_return_status <> fnd_api.g_ret_sts_success THEN
602: RAISE fnd_api.g_exc_error;
603: END IF;
604:
605: END IF;
606:

Line 642: IF nvl(p_fixed_asset_rec.asset_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

638:
639: END LOOP;
640: END IF;
641:
642: IF nvl(p_fixed_asset_rec.asset_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
643: g_ia_ind := g_ia_ind + 1;
644: l_instance_asset_tbl(g_ia_ind).parent_tbl_index := g_inst_ind;
645: l_instance_asset_tbl(g_ia_ind).fa_asset_id := p_fixed_asset_rec.asset_id;
646: l_instance_asset_tbl(g_ia_ind).fa_book_type_code := l_fa_book_type_code;

Line 652: nvl(p_fixed_asset_rec.fa_sync_validation_reqd, fnd_api.g_false);

648: l_instance_asset_tbl(g_ia_ind).asset_quantity := p_instance_rec.quantity;
649: l_instance_asset_tbl(g_ia_ind).update_status := 'IN_SERVICE';
650: l_instance_asset_tbl(g_ia_ind).fa_sync_flag := p_fixed_asset_rec.fa_sync_flag;
651: l_instance_asset_tbl(g_ia_ind).fa_sync_validation_reqd :=
652: nvl(p_fixed_asset_rec.fa_sync_validation_reqd, fnd_api.g_false);
653:
654: validate_inst_asset(
655: px_inst_asset_rec => l_instance_asset_tbl(g_ia_ind),
656: x_return_status => l_return_status);

Line 658: IF l_return_status <> fnd_api.g_ret_sts_success THEN

654: validate_inst_asset(
655: px_inst_asset_rec => l_instance_asset_tbl(g_ia_ind),
656: x_return_status => l_return_status);
657:
658: IF l_return_status <> fnd_api.g_ret_sts_success THEN
659: RAISE fnd_api.g_exc_error;
660: END IF;
661:
662: END IF;

Line 659: RAISE fnd_api.g_exc_error;

655: px_inst_asset_rec => l_instance_asset_tbl(g_ia_ind),
656: x_return_status => l_return_status);
657:
658: IF l_return_status <> fnd_api.g_ret_sts_success THEN
659: RAISE fnd_api.g_exc_error;
660: END IF;
661:
662: END IF;
663:

Line 671: p_commit => fnd_api.g_false,

667: debug('instance_asset_tbl.count : '||l_instance_asset_tbl.count);
668:
669: csi_item_instance_grp.create_item_instance (
670: p_api_version => 1.0,
671: p_commit => fnd_api.g_false,
672: p_init_msg_list => fnd_api.g_true,
673: p_validation_level => fnd_api.g_valid_level_full,
674: p_instance_tbl => l_instance_tbl,
675: p_ext_attrib_values_tbl => l_ext_attrib_values_tbl,

Line 672: p_init_msg_list => fnd_api.g_true,

668:
669: csi_item_instance_grp.create_item_instance (
670: p_api_version => 1.0,
671: p_commit => fnd_api.g_false,
672: p_init_msg_list => fnd_api.g_true,
673: p_validation_level => fnd_api.g_valid_level_full,
674: p_instance_tbl => l_instance_tbl,
675: p_ext_attrib_values_tbl => l_ext_attrib_values_tbl,
676: p_party_tbl => l_party_tbl,

Line 673: p_validation_level => fnd_api.g_valid_level_full,

669: csi_item_instance_grp.create_item_instance (
670: p_api_version => 1.0,
671: p_commit => fnd_api.g_false,
672: p_init_msg_list => fnd_api.g_true,
673: p_validation_level => fnd_api.g_valid_level_full,
674: p_instance_tbl => l_instance_tbl,
675: p_ext_attrib_values_tbl => l_ext_attrib_values_tbl,
676: p_party_tbl => l_party_tbl,
677: p_account_tbl => l_account_tbl,

Line 688: IF l_return_status <> fnd_api.g_ret_sts_success THEN

684: x_return_status => l_return_status,
685: x_msg_count => l_msg_count,
686: x_msg_data => l_msg_data);
687:
688: IF l_return_status <> fnd_api.g_ret_sts_success THEN
689: --bug 9227016
690: RAISE l_item_inst_grp_excep;
691: --RAISE fnd_api.g_exc_error;
692: END IF;

Line 691: --RAISE fnd_api.g_exc_error;

687:
688: IF l_return_status <> fnd_api.g_ret_sts_success THEN
689: --bug 9227016
690: RAISE l_item_inst_grp_excep;
691: --RAISE fnd_api.g_exc_error;
692: END IF;
693:
694: IF l_grp_error_tbl.COUNT > 0 THEN
695: -- errors should be passes out as error.

Line 701: --RAISE fnd_api.g_exc_error;

697: LOOP
698: IF l_grp_error_tbl(err_ind).process_status = 'E' THEN
699: --bug 9227016
700: --l_error_message := l_grp_error_tbl(err_ind).error_message;
701: --RAISE fnd_api.g_exc_error;
702: RAISE l_item_inst_grp_excep;
703: END IF;
704: END LOOP;
705:

Line 716: p_init_msg_list => fnd_api.g_true,

712: IF l_eam_item THEN
713: -- to be uncommented later
714: eam_maint_attributes_pub.create_maint_attributes(
715: p_api_version => 1.0,
716: p_init_msg_list => fnd_api.g_true,
717: p_commit => fnd_api.g_false,
718: p_validation_level => fnd_api.g_valid_level_full,
719: p_instance_id => l_instance_tbl(inst_ind).instance_id,
720: p_owning_department_id => p_eam_rec.owning_department_id,

Line 717: p_commit => fnd_api.g_false,

713: -- to be uncommented later
714: eam_maint_attributes_pub.create_maint_attributes(
715: p_api_version => 1.0,
716: p_init_msg_list => fnd_api.g_true,
717: p_commit => fnd_api.g_false,
718: p_validation_level => fnd_api.g_valid_level_full,
719: p_instance_id => l_instance_tbl(inst_ind).instance_id,
720: p_owning_department_id => p_eam_rec.owning_department_id,
721: p_accounting_class_code => p_eam_rec.wip_accounting_class_code,

Line 718: p_validation_level => fnd_api.g_valid_level_full,

714: eam_maint_attributes_pub.create_maint_attributes(
715: p_api_version => 1.0,
716: p_init_msg_list => fnd_api.g_true,
717: p_commit => fnd_api.g_false,
718: p_validation_level => fnd_api.g_valid_level_full,
719: p_instance_id => l_instance_tbl(inst_ind).instance_id,
720: p_owning_department_id => p_eam_rec.owning_department_id,
721: p_accounting_class_code => p_eam_rec.wip_accounting_class_code,
722: p_area_id => p_eam_rec.area_id,

Line 728: IF l_return_status <> fnd_api.g_ret_sts_success THEN

724: x_return_status => l_return_status,
725: x_msg_count => l_msg_count,
726: x_msg_data => l_msg_data);
727:
728: IF l_return_status <> fnd_api.g_ret_sts_success THEN
729: RAISE fnd_api.g_exc_error;
730: END IF;
731: END IF;
732:

Line 729: RAISE fnd_api.g_exc_error;

725: x_msg_count => l_msg_count,
726: x_msg_data => l_msg_data);
727:
728: IF l_return_status <> fnd_api.g_ret_sts_success THEN
729: RAISE fnd_api.g_exc_error;
730: END IF;
731: END IF;
732:
733: END LOOP;

Line 769: x_return_status := fnd_api.g_ret_sts_error;

765: l_error_message := l_error_message || l_grp_error_tbl(err_ind).error_message || ' ';
766: END IF;
767: END LOOP;
768: END IF;
769: x_return_status := fnd_api.g_ret_sts_error;
770: x_error_message := l_error_message;
771: --bug 9227016 end
772: WHEN fnd_api.g_exc_error THEN
773: rollback to fa_grp_create_instance;

Line 772: WHEN fnd_api.g_exc_error THEN

768: END IF;
769: x_return_status := fnd_api.g_ret_sts_error;
770: x_error_message := l_error_message;
771: --bug 9227016 end
772: WHEN fnd_api.g_exc_error THEN
773: rollback to fa_grp_create_instance;
774: x_return_status := fnd_api.g_ret_sts_error;
775: x_error_message := dump_error_stack;
776: WHEN others THEN

Line 774: x_return_status := fnd_api.g_ret_sts_error;

770: x_error_message := l_error_message;
771: --bug 9227016 end
772: WHEN fnd_api.g_exc_error THEN
773: rollback to fa_grp_create_instance;
774: x_return_status := fnd_api.g_ret_sts_error;
775: x_error_message := dump_error_stack;
776: WHEN others THEN
777: rollback to fa_grp_create_instance;
778: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 778: x_return_status := fnd_api.g_ret_sts_unexp_error;

774: x_return_status := fnd_api.g_ret_sts_error;
775: x_error_message := dump_error_stack;
776: WHEN others THEN
777: rollback to fa_grp_create_instance;
778: x_return_status := fnd_api.g_ret_sts_unexp_error;
779: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
780: fnd_message.set_token('API_NAME','csi_fa_instance_grp.create_item_instance');
781: fnd_message.set_token('SQL_ERROR',SQLERRM);
782: fnd_msg_pub.add;

Line 820: l_miss_num number := fnd_api.g_miss_num;

816: l_fa_flow varchar2(1);
817: l_copy_flags_rec copy_flags_rec;
818: l_instance_rec csi_datastructures_pub.instance_rec;
819:
820: l_miss_num number := fnd_api.g_miss_num;
821: l_miss_char varchar2(200) := fnd_api.g_miss_char;
822:
823: l_instance_tbl csi_datastructures_pub.instance_tbl;
824:

Line 821: l_miss_char varchar2(200) := fnd_api.g_miss_char;

817: l_copy_flags_rec copy_flags_rec;
818: l_instance_rec csi_datastructures_pub.instance_rec;
819:
820: l_miss_num number := fnd_api.g_miss_num;
821: l_miss_char varchar2(200) := fnd_api.g_miss_char;
822:
823: l_instance_tbl csi_datastructures_pub.instance_tbl;
824:
825: o_ind binary_integer := 0;

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

827:
828: ia_ind binary_integer := 0;
829: l_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
830:
831: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
832: l_msg_count number;
833: l_msg_data varchar2(4000);
834: l_error_message varchar2(2000);
835:

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

861: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
862: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
863: l_inst_id_lst csi_datastructures_pub.id_tbl;
864:
865: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
866: l_msg_count number;
867: l_msg_data varchar2(4000);
868: BEGIN
869:

Line 870: x_return_status := fnd_api.g_ret_sts_success;

866: l_msg_count number;
867: l_msg_data varchar2(4000);
868: BEGIN
869:
870: x_return_status := fnd_api.g_ret_sts_success;
871:
872: csi_item_instance_pvt.copy_item_instance(
873: p_api_version => 1.0,
874: p_commit => fnd_api.g_false,

Line 874: p_commit => fnd_api.g_false,

870: x_return_status := fnd_api.g_ret_sts_success;
871:
872: csi_item_instance_pvt.copy_item_instance(
873: p_api_version => 1.0,
874: p_commit => fnd_api.g_false,
875: p_init_msg_list => fnd_api.g_true,
876: p_validation_level => fnd_api.g_valid_level_full,
877: p_source_instance_rec => p_instance_rec,
878: p_copy_ext_attribs => p_copy_flags_rec.copy_ext_attribs,

Line 875: p_init_msg_list => fnd_api.g_true,

871:
872: csi_item_instance_pvt.copy_item_instance(
873: p_api_version => 1.0,
874: p_commit => fnd_api.g_false,
875: p_init_msg_list => fnd_api.g_true,
876: p_validation_level => fnd_api.g_valid_level_full,
877: p_source_instance_rec => p_instance_rec,
878: p_copy_ext_attribs => p_copy_flags_rec.copy_ext_attribs,
879: p_copy_org_assignments => p_copy_flags_rec.copy_org_assignments,

Line 876: p_validation_level => fnd_api.g_valid_level_full,

872: csi_item_instance_pvt.copy_item_instance(
873: p_api_version => 1.0,
874: p_commit => fnd_api.g_false,
875: p_init_msg_list => fnd_api.g_true,
876: p_validation_level => fnd_api.g_valid_level_full,
877: p_source_instance_rec => p_instance_rec,
878: p_copy_ext_attribs => p_copy_flags_rec.copy_ext_attribs,
879: p_copy_org_assignments => p_copy_flags_rec.copy_org_assignments,
880: p_copy_parties => p_copy_flags_rec.copy_parties,

Line 886: p_call_from_split => fnd_api.g_false,

882: p_copy_accounts => p_copy_flags_rec.copy_accounts,
883: p_copy_asset_assignments => p_copy_flags_rec.copy_asset_assignments,
884: p_copy_pricing_attribs => p_copy_flags_rec.copy_pricing_attribs,
885: p_copy_inst_children => p_copy_flags_rec.copy_inst_children,
886: p_call_from_split => fnd_api.g_false,
887: p_txn_rec => px_csi_txn_rec,
888: x_new_instance_tbl => l_instance_tbl,
889: x_return_status => l_return_status,
890: x_msg_count => l_msg_count,

Line 893: IF l_return_status <> fnd_api.g_ret_sts_success THEN

889: x_return_status => l_return_status,
890: x_msg_count => l_msg_count,
891: x_msg_data => l_msg_data);
892:
893: IF l_return_status <> fnd_api.g_ret_sts_success THEN
894: RAISE fnd_api.g_exc_error;
895: END IF;
896:
897: IF nvl(p_fa_flow, 'N') = 'Y' THEN

Line 894: RAISE fnd_api.g_exc_error;

890: x_msg_count => l_msg_count,
891: x_msg_data => l_msg_data);
892:
893: IF l_return_status <> fnd_api.g_ret_sts_success THEN
894: RAISE fnd_api.g_exc_error;
895: END IF;
896:
897: IF nvl(p_fa_flow, 'N') = 'Y' THEN
898:

Line 928: p_commit => fnd_api.g_false,

924:
925: -- change the owner to internal
926: csi_item_instance_pub.update_item_instance(
927: p_api_version => 1.0,
928: p_commit => fnd_api.g_false,
929: p_init_msg_list => fnd_api.g_true,
930: p_validation_level => fnd_api.g_valid_level_full,
931: p_instance_rec => l_instance_rec,
932: p_ext_attrib_values_tbl => l_eav_tbl,

Line 929: p_init_msg_list => fnd_api.g_true,

925: -- change the owner to internal
926: csi_item_instance_pub.update_item_instance(
927: p_api_version => 1.0,
928: p_commit => fnd_api.g_false,
929: p_init_msg_list => fnd_api.g_true,
930: p_validation_level => fnd_api.g_valid_level_full,
931: p_instance_rec => l_instance_rec,
932: p_ext_attrib_values_tbl => l_eav_tbl,
933: p_party_tbl => l_party_tbl,

Line 930: p_validation_level => fnd_api.g_valid_level_full,

926: csi_item_instance_pub.update_item_instance(
927: p_api_version => 1.0,
928: p_commit => fnd_api.g_false,
929: p_init_msg_list => fnd_api.g_true,
930: p_validation_level => fnd_api.g_valid_level_full,
931: p_instance_rec => l_instance_rec,
932: p_ext_attrib_values_tbl => l_eav_tbl,
933: p_party_tbl => l_party_tbl,
934: p_account_tbl => l_party_acct_tbl,

Line 944: IF l_return_status <> fnd_api.g_ret_sts_success THEN

940: x_return_status => l_return_status,
941: x_msg_count => l_msg_count,
942: x_msg_data => l_msg_data);
943:
944: IF l_return_status <> fnd_api.g_ret_sts_success THEN
945: RAISE fnd_api.g_exc_error;
946: END IF;
947:
948: END IF;

Line 945: RAISE fnd_api.g_exc_error;

941: x_msg_count => l_msg_count,
942: x_msg_data => l_msg_data);
943:
944: IF l_return_status <> fnd_api.g_ret_sts_success THEN
945: RAISE fnd_api.g_exc_error;
946: END IF;
947:
948: END IF;
949:

Line 955: WHEN fnd_api.g_exc_error THEN

951:
952: x_instance_tbl := l_instance_tbl;
953:
954: EXCEPTION
955: WHEN fnd_api.g_exc_error THEN
956: x_return_status := fnd_api.g_ret_sts_error;
957: END do_copy;
958:
959: BEGIN

Line 956: x_return_status := fnd_api.g_ret_sts_error;

952: x_instance_tbl := l_instance_tbl;
953:
954: EXCEPTION
955: WHEN fnd_api.g_exc_error THEN
956: x_return_status := fnd_api.g_ret_sts_error;
957: END do_copy;
958:
959: BEGIN
960:

Line 961: x_return_status := fnd_api.g_ret_sts_success;

957: END do_copy;
958:
959: BEGIN
960:
961: x_return_status := fnd_api.g_ret_sts_success;
962:
963: savepoint fa_grp_copy_instance;
964:
965: csi_item_instance_vld_pvt.check_reqd_param_num (

Line 972: p_commit => fnd_api.g_false,

968: p_api_name => 'csi_fa_instance_rec.copy_item_instance');
969:
970: csi_transactions_pvt.create_transaction(
971: p_api_version => 1.0,
972: p_commit => fnd_api.g_false,
973: p_init_msg_list => fnd_api.g_true,
974: p_validation_level => fnd_api.g_valid_level_full,
975: p_success_if_exists_flag => 'Y',
976: p_transaction_rec => px_csi_txn_rec,

Line 973: p_init_msg_list => fnd_api.g_true,

969:
970: csi_transactions_pvt.create_transaction(
971: p_api_version => 1.0,
972: p_commit => fnd_api.g_false,
973: p_init_msg_list => fnd_api.g_true,
974: p_validation_level => fnd_api.g_valid_level_full,
975: p_success_if_exists_flag => 'Y',
976: p_transaction_rec => px_csi_txn_rec,
977: x_return_status => l_return_status,

Line 974: p_validation_level => fnd_api.g_valid_level_full,

970: csi_transactions_pvt.create_transaction(
971: p_api_version => 1.0,
972: p_commit => fnd_api.g_false,
973: p_init_msg_list => fnd_api.g_true,
974: p_validation_level => fnd_api.g_valid_level_full,
975: p_success_if_exists_flag => 'Y',
976: p_transaction_rec => px_csi_txn_rec,
977: x_return_status => l_return_status,
978: x_msg_count => l_msg_count,

Line 981: IF l_return_status <> fnd_api.g_ret_sts_success THEN

977: x_return_status => l_return_status,
978: x_msg_count => l_msg_count,
979: x_msg_data => l_msg_data);
980:
981: IF l_return_status <> fnd_api.g_ret_sts_success THEN
982: RAISE fnd_api.g_exc_error;
983: END IF;
984:
985: IF nvl(p_fixed_asset_rec.asset_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

Line 982: RAISE fnd_api.g_exc_error;

978: x_msg_count => l_msg_count,
979: x_msg_data => l_msg_data);
980:
981: IF l_return_status <> fnd_api.g_ret_sts_success THEN
982: RAISE fnd_api.g_exc_error;
983: END IF;
984:
985: IF nvl(p_fixed_asset_rec.asset_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
986: l_fa_flow := 'Y';

Line 985: IF nvl(p_fixed_asset_rec.asset_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

981: IF l_return_status <> fnd_api.g_ret_sts_success THEN
982: RAISE fnd_api.g_exc_error;
983: END IF;
984:
985: IF nvl(p_fixed_asset_rec.asset_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
986: l_fa_flow := 'Y';
987: l_copy_flags_rec.copy_parties := fnd_api.g_false;
988: l_copy_flags_rec.copy_accounts := fnd_api.g_false;
989: l_copy_flags_rec.copy_contacts := fnd_api.g_false;

Line 987: l_copy_flags_rec.copy_parties := fnd_api.g_false;

983: END IF;
984:
985: IF nvl(p_fixed_asset_rec.asset_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
986: l_fa_flow := 'Y';
987: l_copy_flags_rec.copy_parties := fnd_api.g_false;
988: l_copy_flags_rec.copy_accounts := fnd_api.g_false;
989: l_copy_flags_rec.copy_contacts := fnd_api.g_false;
990: ELSE
991: l_fa_flow := 'N';

Line 988: l_copy_flags_rec.copy_accounts := fnd_api.g_false;

984:
985: IF nvl(p_fixed_asset_rec.asset_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
986: l_fa_flow := 'Y';
987: l_copy_flags_rec.copy_parties := fnd_api.g_false;
988: l_copy_flags_rec.copy_accounts := fnd_api.g_false;
989: l_copy_flags_rec.copy_contacts := fnd_api.g_false;
990: ELSE
991: l_fa_flow := 'N';
992: l_copy_flags_rec.copy_parties := p_copy_parties;

Line 989: l_copy_flags_rec.copy_contacts := fnd_api.g_false;

985: IF nvl(p_fixed_asset_rec.asset_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
986: l_fa_flow := 'Y';
987: l_copy_flags_rec.copy_parties := fnd_api.g_false;
988: l_copy_flags_rec.copy_accounts := fnd_api.g_false;
989: l_copy_flags_rec.copy_contacts := fnd_api.g_false;
990: ELSE
991: l_fa_flow := 'N';
992: l_copy_flags_rec.copy_parties := p_copy_parties;
993: l_copy_flags_rec.copy_accounts := p_copy_accounts;

Line 1004: IF nvl(p_instance_rec.inventory_item_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num

1000: l_copy_flags_rec.copy_asset_assignments := p_copy_asset_assignments;
1001: l_copy_flags_rec.copy_inst_children := p_copy_inst_children;
1002:
1003: -- derive eam_item_type
1004: IF nvl(p_instance_rec.inventory_item_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
1005: AND
1006: nvl(p_instance_rec.vld_organization_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
1007: THEN
1008:

Line 1006: nvl(p_instance_rec.vld_organization_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num

1002:
1003: -- derive eam_item_type
1004: IF nvl(p_instance_rec.inventory_item_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
1005: AND
1006: nvl(p_instance_rec.vld_organization_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
1007: THEN
1008:
1009: SELECT eam_item_type,
1010: serial_number_control_code

Line 1062: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1058: px_csi_txn_rec => px_csi_txn_rec,
1059: x_instance_tbl => l_instance_tbl,
1060: x_return_status => l_return_status);
1061:
1062: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1063: l_error_message := dump_error_stack;
1064: RAISE fnd_api.g_exc_error;
1065: END IF;
1066:

Line 1064: RAISE fnd_api.g_exc_error;

1060: x_return_status => l_return_status);
1061:
1062: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1063: l_error_message := dump_error_stack;
1064: RAISE fnd_api.g_exc_error;
1065: END IF;
1066:
1067: IF l_instance_tbl.COUNT > 0 THEN
1068: FOR inst_ind IN l_instance_tbl.FIRST .. l_instance_tbl.LAST

Line 1093: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1089: px_csi_txn_rec => px_csi_txn_rec,
1090: x_instance_tbl => l_instance_tbl,
1091: x_return_status => l_return_status);
1092:
1093: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1094: l_error_message := dump_error_stack;
1095: RAISE fnd_api.g_exc_error;
1096: END IF;
1097:

Line 1095: RAISE fnd_api.g_exc_error;

1091: x_return_status => l_return_status);
1092:
1093: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1094: l_error_message := dump_error_stack;
1095: RAISE fnd_api.g_exc_error;
1096: END IF;
1097:
1098: IF l_instance_tbl.COUNT > 0 THEN
1099: FOR inst_ind IN l_instance_tbl.FIRST .. l_instance_tbl.LAST

Line 1112: IF nvl(p_fixed_asset_rec.asset_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

1108: IF o_instance_tbl.COUNT > 0 THEN
1109: FOR inst_ind IN o_instance_tbl.FIRST .. o_instance_tbl.LAST
1110: LOOP
1111:
1112: IF nvl(p_fixed_asset_rec.asset_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
1113: ia_ind := ia_ind + 1;
1114: l_instance_asset_tbl(ia_ind).instance_id := o_instance_tbl(inst_ind).instance_id;
1115: l_instance_asset_tbl(ia_ind).fa_asset_id := p_fixed_asset_rec.asset_id;
1116: l_instance_asset_tbl(ia_ind).fa_book_type_code := p_fixed_asset_rec.book_type_code;

Line 1128: IF p_eam_rec.owning_department_id = FND_API.G_MISS_NUM THEN

1124:
1125: IF l_eam_item THEN
1126: /* Commented the code for Bug 12658776
1127: --Need to flip the EAM attributes.
1128: IF p_eam_rec.owning_department_id = FND_API.G_MISS_NUM THEN
1129: l_owning_department_id := NULL;
1130: ELSIF p_eam_rec.owning_department_id IS NULL THEN
1131: l_owning_department_id := FND_API.G_MISS_NUM;
1132: END IF;

Line 1131: l_owning_department_id := FND_API.G_MISS_NUM;

1127: --Need to flip the EAM attributes.
1128: IF p_eam_rec.owning_department_id = FND_API.G_MISS_NUM THEN
1129: l_owning_department_id := NULL;
1130: ELSIF p_eam_rec.owning_department_id IS NULL THEN
1131: l_owning_department_id := FND_API.G_MISS_NUM;
1132: END IF;
1133:
1134: IF p_eam_rec.wip_accounting_class_code = FND_API.G_MISS_CHAR THEN
1135: l_wip_accounting_class_code := NULL;

Line 1134: IF p_eam_rec.wip_accounting_class_code = FND_API.G_MISS_CHAR THEN

1130: ELSIF p_eam_rec.owning_department_id IS NULL THEN
1131: l_owning_department_id := FND_API.G_MISS_NUM;
1132: END IF;
1133:
1134: IF p_eam_rec.wip_accounting_class_code = FND_API.G_MISS_CHAR THEN
1135: l_wip_accounting_class_code := NULL;
1136: ELSIF p_eam_rec.owning_department_id IS NULL THEN
1137: l_wip_accounting_class_code := FND_API.G_MISS_CHAR;
1138: END IF;

Line 1137: l_wip_accounting_class_code := FND_API.G_MISS_CHAR;

1133:
1134: IF p_eam_rec.wip_accounting_class_code = FND_API.G_MISS_CHAR THEN
1135: l_wip_accounting_class_code := NULL;
1136: ELSIF p_eam_rec.owning_department_id IS NULL THEN
1137: l_wip_accounting_class_code := FND_API.G_MISS_CHAR;
1138: END IF;
1139:
1140: IF p_eam_rec.area_id = FND_API.G_MISS_NUM THEN
1141: l_area_id := NULL;

Line 1140: IF p_eam_rec.area_id = FND_API.G_MISS_NUM THEN

1136: ELSIF p_eam_rec.owning_department_id IS NULL THEN
1137: l_wip_accounting_class_code := FND_API.G_MISS_CHAR;
1138: END IF;
1139:
1140: IF p_eam_rec.area_id = FND_API.G_MISS_NUM THEN
1141: l_area_id := NULL;
1142: ELSIF p_eam_rec.owning_department_id IS NULL THEN
1143: l_area_id := FND_API.G_MISS_NUM;
1144: END IF;

Line 1143: l_area_id := FND_API.G_MISS_NUM;

1139:
1140: IF p_eam_rec.area_id = FND_API.G_MISS_NUM THEN
1141: l_area_id := NULL;
1142: ELSIF p_eam_rec.owning_department_id IS NULL THEN
1143: l_area_id := FND_API.G_MISS_NUM;
1144: END IF;
1145:
1146: IF p_eam_rec.parent_instance_id = FND_API.G_MISS_NUM THEN
1147: l_parent_instance_id := NULL;

Line 1146: IF p_eam_rec.parent_instance_id = FND_API.G_MISS_NUM THEN

1142: ELSIF p_eam_rec.owning_department_id IS NULL THEN
1143: l_area_id := FND_API.G_MISS_NUM;
1144: END IF;
1145:
1146: IF p_eam_rec.parent_instance_id = FND_API.G_MISS_NUM THEN
1147: l_parent_instance_id := NULL;
1148: ELSIF p_eam_rec.owning_department_id IS NULL THEN
1149: l_parent_instance_id := FND_API.G_MISS_NUM;
1150: END IF;

Line 1149: l_parent_instance_id := FND_API.G_MISS_NUM;

1145:
1146: IF p_eam_rec.parent_instance_id = FND_API.G_MISS_NUM THEN
1147: l_parent_instance_id := NULL;
1148: ELSIF p_eam_rec.owning_department_id IS NULL THEN
1149: l_parent_instance_id := FND_API.G_MISS_NUM;
1150: END IF;
1151: */
1152:
1153: eam_maint_attributes_pub.create_maint_attributes(

Line 1155: p_init_msg_list => fnd_api.g_true,

1151: */
1152:
1153: eam_maint_attributes_pub.create_maint_attributes(
1154: p_api_version => 1.0,
1155: p_init_msg_list => fnd_api.g_true,
1156: p_commit => fnd_api.g_false,
1157: p_validation_level => fnd_api.g_valid_level_full,
1158: p_instance_id => l_instance_tbl(inst_ind).instance_id,
1159: p_owning_department_id => p_eam_rec.owning_department_id, --Changed for bug 12658776

Line 1156: p_commit => fnd_api.g_false,

1152:
1153: eam_maint_attributes_pub.create_maint_attributes(
1154: p_api_version => 1.0,
1155: p_init_msg_list => fnd_api.g_true,
1156: p_commit => fnd_api.g_false,
1157: p_validation_level => fnd_api.g_valid_level_full,
1158: p_instance_id => l_instance_tbl(inst_ind).instance_id,
1159: p_owning_department_id => p_eam_rec.owning_department_id, --Changed for bug 12658776
1160: p_accounting_class_code => p_eam_rec.wip_accounting_class_code, --Changed for bug 12658776

Line 1157: p_validation_level => fnd_api.g_valid_level_full,

1153: eam_maint_attributes_pub.create_maint_attributes(
1154: p_api_version => 1.0,
1155: p_init_msg_list => fnd_api.g_true,
1156: p_commit => fnd_api.g_false,
1157: p_validation_level => fnd_api.g_valid_level_full,
1158: p_instance_id => l_instance_tbl(inst_ind).instance_id,
1159: p_owning_department_id => p_eam_rec.owning_department_id, --Changed for bug 12658776
1160: p_accounting_class_code => p_eam_rec.wip_accounting_class_code, --Changed for bug 12658776
1161: p_area_id => p_eam_rec.area_id, --Changed for bug 12658776

Line 1167: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1163: x_return_status => l_return_status,
1164: x_msg_count => l_msg_count,
1165: x_msg_data => l_msg_data);
1166:
1167: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1168: RAISE fnd_api.g_exc_error;
1169: END IF;
1170: END IF;
1171:

Line 1168: RAISE fnd_api.g_exc_error;

1164: x_msg_count => l_msg_count,
1165: x_msg_data => l_msg_data);
1166:
1167: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1168: RAISE fnd_api.g_exc_error;
1169: END IF;
1170: END IF;
1171:
1172: END LOOP;

Line 1183: IF l_return_status IN (fnd_api.g_ret_sts_success, 'W') THEN

1179: px_csi_txn_rec => px_csi_txn_rec,
1180: x_return_status => l_return_status,
1181: x_error_message => l_error_message);
1182:
1183: IF l_return_status IN (fnd_api.g_ret_sts_success, 'W') THEN
1184: x_return_status := l_return_status;
1185: x_error_message := l_error_message;
1186: ELSE
1187: RAISE fnd_api.g_exc_error;

Line 1187: RAISE fnd_api.g_exc_error;

1183: IF l_return_status IN (fnd_api.g_ret_sts_success, 'W') THEN
1184: x_return_status := l_return_status;
1185: x_error_message := l_error_message;
1186: ELSE
1187: RAISE fnd_api.g_exc_error;
1188: END IF;
1189:
1190: END IF;
1191:

Line 1196: WHEN fnd_api.g_exc_error THEN

1192: x_instance_tbl := o_instance_tbl;
1193: x_instance_asset_tbl := l_instance_asset_tbl;
1194:
1195: EXCEPTION
1196: WHEN fnd_api.g_exc_error THEN
1197: rollback to fa_grp_copy_instance;
1198: x_return_status := fnd_api.g_ret_sts_error;
1199: x_error_message := dump_error_stack;
1200: WHEN others THEN

Line 1198: x_return_status := fnd_api.g_ret_sts_error;

1194:
1195: EXCEPTION
1196: WHEN fnd_api.g_exc_error THEN
1197: rollback to fa_grp_copy_instance;
1198: x_return_status := fnd_api.g_ret_sts_error;
1199: x_error_message := dump_error_stack;
1200: WHEN others THEN
1201: rollback to fa_grp_copy_instance;
1202: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1202: x_return_status := fnd_api.g_ret_sts_unexp_error;

1198: x_return_status := fnd_api.g_ret_sts_error;
1199: x_error_message := dump_error_stack;
1200: WHEN others THEN
1201: rollback to fa_grp_copy_instance;
1202: x_return_status := fnd_api.g_ret_sts_unexp_error;
1203: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
1204: fnd_message.set_token('API_NAME','csi_fa_instance_grp.copy_item_instance');
1205: fnd_message.set_token('SQL_ERROR',SQLERRM);
1206: fnd_msg_pub.add;

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

1228: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1229:
1230: g_ia_ind binary_integer := 0;
1231:
1232: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1233: l_msg_count number;
1234: l_msg_data varchar2(2000);
1235:
1236: l_error_message varchar2(2000);

Line 1239: x_return_status := fnd_api.g_ret_sts_success;

1235:
1236: l_error_message varchar2(2000);
1237:
1238: BEGIN
1239: x_return_status := fnd_api.g_ret_sts_success;
1240:
1241: debug('associate_item_isntance');
1242:
1243: IF p_instance_tbl.COUNT > 0 THEN

Line 1256: IF nvl(p_fixed_asset_rec.asset_location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num

1252: l_instance_asset_tbl(g_ia_ind).fa_location_id := p_fixed_asset_rec.asset_location_id;
1253: l_instance_asset_tbl(g_ia_ind).asset_quantity := p_instance_tbl(inst_ind).quantity;
1254: l_instance_asset_tbl(g_ia_ind).update_status := 'IN_SERVICE';
1255:
1256: IF nvl(p_fixed_asset_rec.asset_location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
1257: OR
1258: nvl(p_fixed_asset_rec.asset_quantity, fnd_api.g_miss_num) = fnd_api.g_miss_num
1259: OR
1260: nvl(p_fixed_asset_rec.book_type_code, fnd_api.g_miss_char) = fnd_api.g_miss_char

Line 1258: nvl(p_fixed_asset_rec.asset_quantity, fnd_api.g_miss_num) = fnd_api.g_miss_num

1254: l_instance_asset_tbl(g_ia_ind).update_status := 'IN_SERVICE';
1255:
1256: IF nvl(p_fixed_asset_rec.asset_location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
1257: OR
1258: nvl(p_fixed_asset_rec.asset_quantity, fnd_api.g_miss_num) = fnd_api.g_miss_num
1259: OR
1260: nvl(p_fixed_asset_rec.book_type_code, fnd_api.g_miss_char) = fnd_api.g_miss_char
1261: THEN
1262:

Line 1260: nvl(p_fixed_asset_rec.book_type_code, fnd_api.g_miss_char) = fnd_api.g_miss_char

1256: IF nvl(p_fixed_asset_rec.asset_location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
1257: OR
1258: nvl(p_fixed_asset_rec.asset_quantity, fnd_api.g_miss_num) = fnd_api.g_miss_num
1259: OR
1260: nvl(p_fixed_asset_rec.book_type_code, fnd_api.g_miss_char) = fnd_api.g_miss_char
1261: THEN
1262:
1263: derive_fa_missing_values(
1264: p_instance_rec => p_instance_tbl(inst_ind),

Line 1271: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1267: x_fa_quantity => l_fa_quantity,
1268: x_fa_book_type_code => l_fa_book_type_code,
1269: x_return_status => l_return_status);
1270:
1271: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1272: RAISE fnd_api.g_exc_error;
1273: END IF;
1274:
1275: debug('location_id :'||l_fa_location_id);

Line 1272: RAISE fnd_api.g_exc_error;

1268: x_fa_book_type_code => l_fa_book_type_code,
1269: x_return_status => l_return_status);
1270:
1271: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1272: RAISE fnd_api.g_exc_error;
1273: END IF;
1274:
1275: debug('location_id :'||l_fa_location_id);
1276:

Line 1277: IF nvl(p_fixed_asset_rec.asset_location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

1273: END IF;
1274:
1275: debug('location_id :'||l_fa_location_id);
1276:
1277: IF nvl(p_fixed_asset_rec.asset_location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
1278: l_instance_asset_tbl(g_ia_ind).fa_location_id := l_fa_location_id;
1279: END IF;
1280:
1281: IF nvl(p_fixed_asset_rec.asset_quantity, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

Line 1281: IF nvl(p_fixed_asset_rec.asset_quantity, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

1277: IF nvl(p_fixed_asset_rec.asset_location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
1278: l_instance_asset_tbl(g_ia_ind).fa_location_id := l_fa_location_id;
1279: END IF;
1280:
1281: IF nvl(p_fixed_asset_rec.asset_quantity, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
1282: l_instance_asset_tbl(g_ia_ind).asset_quantity := l_fa_quantity;
1283: END IF;
1284:
1285: l_instance_asset_tbl(g_ia_ind).fa_book_type_code := l_fa_book_type_code;

Line 1288: nvl(p_fixed_asset_rec.fa_sync_validation_reqd, fnd_api.g_false);

1284:
1285: l_instance_asset_tbl(g_ia_ind).fa_book_type_code := l_fa_book_type_code;
1286: l_instance_asset_tbl(g_ia_ind).fa_sync_flag := p_fixed_asset_rec.fa_sync_flag;
1287: l_instance_asset_tbl(g_ia_ind).fa_sync_validation_reqd :=
1288: nvl(p_fixed_asset_rec.fa_sync_validation_reqd, fnd_api.g_false);
1289:
1290: END IF;
1291:
1292: END LOOP;

Line 1299: p_commit => fnd_api.g_false,

1295: IF l_instance_asset_tbl.COUNT > 0 THEN
1296:
1297: csi_transactions_pvt.create_transaction(
1298: p_api_version => 1.0,
1299: p_commit => fnd_api.g_false,
1300: p_init_msg_list => fnd_api.g_true,
1301: p_validation_level => fnd_api.g_valid_level_full,
1302: p_success_if_exists_flag => 'Y',
1303: p_transaction_rec => px_csi_txn_rec,

Line 1300: p_init_msg_list => fnd_api.g_true,

1296:
1297: csi_transactions_pvt.create_transaction(
1298: p_api_version => 1.0,
1299: p_commit => fnd_api.g_false,
1300: p_init_msg_list => fnd_api.g_true,
1301: p_validation_level => fnd_api.g_valid_level_full,
1302: p_success_if_exists_flag => 'Y',
1303: p_transaction_rec => px_csi_txn_rec,
1304: x_return_status => l_return_status,

Line 1301: p_validation_level => fnd_api.g_valid_level_full,

1297: csi_transactions_pvt.create_transaction(
1298: p_api_version => 1.0,
1299: p_commit => fnd_api.g_false,
1300: p_init_msg_list => fnd_api.g_true,
1301: p_validation_level => fnd_api.g_valid_level_full,
1302: p_success_if_exists_flag => 'Y',
1303: p_transaction_rec => px_csi_txn_rec,
1304: x_return_status => l_return_status,
1305: x_msg_count => l_msg_count,

Line 1308: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1304: x_return_status => l_return_status,
1305: x_msg_count => l_msg_count,
1306: x_msg_data => l_msg_data);
1307:
1308: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1309: RAISE fnd_api.g_exc_error;
1310: END IF;
1311:
1312: create_instance_assets(

Line 1309: RAISE fnd_api.g_exc_error;

1305: x_msg_count => l_msg_count,
1306: x_msg_data => l_msg_data);
1307:
1308: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1309: RAISE fnd_api.g_exc_error;
1310: END IF;
1311:
1312: create_instance_assets(
1313: px_instance_asset_tbl => l_instance_asset_tbl,

Line 1318: IF l_return_status IN (fnd_api.g_ret_sts_success, 'W') THEN

1314: px_csi_txn_rec => px_csi_txn_rec,
1315: x_return_status => l_return_status,
1316: x_error_message => l_error_message);
1317:
1318: IF l_return_status IN (fnd_api.g_ret_sts_success, 'W') THEN
1319: x_return_status := l_return_status;
1320: x_error_message := l_error_message;
1321: ELSE
1322: RAISE fnd_api.g_exc_error;

Line 1322: RAISE fnd_api.g_exc_error;

1318: IF l_return_status IN (fnd_api.g_ret_sts_success, 'W') THEN
1319: x_return_status := l_return_status;
1320: x_error_message := l_error_message;
1321: ELSE
1322: RAISE fnd_api.g_exc_error;
1323: END IF;
1324:
1325: END IF;
1326:

Line 1328: WHEN fnd_api.g_exc_error THEN

1324:
1325: END IF;
1326:
1327: EXCEPTION
1328: WHEN fnd_api.g_exc_error THEN
1329: x_return_status := fnd_api.g_ret_sts_error;
1330: x_error_message := dump_error_stack;
1331: WHEN others THEN
1332: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1329: x_return_status := fnd_api.g_ret_sts_error;

1325: END IF;
1326:
1327: EXCEPTION
1328: WHEN fnd_api.g_exc_error THEN
1329: x_return_status := fnd_api.g_ret_sts_error;
1330: x_error_message := dump_error_stack;
1331: WHEN others THEN
1332: x_return_status := fnd_api.g_ret_sts_unexp_error;
1333: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');

Line 1332: x_return_status := fnd_api.g_ret_sts_unexp_error;

1328: WHEN fnd_api.g_exc_error THEN
1329: x_return_status := fnd_api.g_ret_sts_error;
1330: x_error_message := dump_error_stack;
1331: WHEN others THEN
1332: x_return_status := fnd_api.g_ret_sts_unexp_error;
1333: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
1334: fnd_message.set_token('API_NAME','csi_fa_instance_grp.associate_item_instance');
1335: fnd_message.set_token('SQL_ERROR',SQLERRM);
1336: fnd_msg_pub.add;

Line 1354: l_return_status varchar2(2000) := fnd_api.g_ret_sts_success;

1350: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1351: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1352: l_warning_flag varchar2(1) := 'N';
1353:
1354: l_return_status varchar2(2000) := fnd_api.g_ret_sts_success;
1355: l_msg_count number;
1356: l_msg_data varchar2(2000);
1357:
1358: BEGIN

Line 1360: x_return_status := fnd_api.g_ret_sts_success;

1356: l_msg_data varchar2(2000);
1357:
1358: BEGIN
1359:
1360: x_return_status := fnd_api.g_ret_sts_success;
1361: IF p_instance_asset_tbl.count > 0 THEN
1362:
1363: csi_transactions_pvt.create_transaction(
1364: p_api_version => 1.0,

Line 1365: p_commit => fnd_api.g_false,

1361: IF p_instance_asset_tbl.count > 0 THEN
1362:
1363: csi_transactions_pvt.create_transaction(
1364: p_api_version => 1.0,
1365: p_commit => fnd_api.g_false,
1366: p_init_msg_list => fnd_api.g_true,
1367: p_validation_level => fnd_api.g_valid_level_full,
1368: p_success_if_exists_flag => 'Y',
1369: p_transaction_rec => px_csi_txn_rec,

Line 1366: p_init_msg_list => fnd_api.g_true,

1362:
1363: csi_transactions_pvt.create_transaction(
1364: p_api_version => 1.0,
1365: p_commit => fnd_api.g_false,
1366: p_init_msg_list => fnd_api.g_true,
1367: p_validation_level => fnd_api.g_valid_level_full,
1368: p_success_if_exists_flag => 'Y',
1369: p_transaction_rec => px_csi_txn_rec,
1370: x_return_status => l_return_status,

Line 1367: p_validation_level => fnd_api.g_valid_level_full,

1363: csi_transactions_pvt.create_transaction(
1364: p_api_version => 1.0,
1365: p_commit => fnd_api.g_false,
1366: p_init_msg_list => fnd_api.g_true,
1367: p_validation_level => fnd_api.g_valid_level_full,
1368: p_success_if_exists_flag => 'Y',
1369: p_transaction_rec => px_csi_txn_rec,
1370: x_return_status => l_return_status,
1371: x_msg_count => l_msg_count,

Line 1374: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1370: x_return_status => l_return_status,
1371: x_msg_count => l_msg_count,
1372: x_msg_data => l_msg_data);
1373:
1374: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1375: RAISE fnd_api.g_exc_error;
1376: END IF;
1377:
1378: FOR l_ind IN p_instance_asset_tbl.FIRST .. p_instance_asset_tbl.LAST

Line 1375: RAISE fnd_api.g_exc_error;

1371: x_msg_count => l_msg_count,
1372: x_msg_data => l_msg_data);
1373:
1374: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1375: RAISE fnd_api.g_exc_error;
1376: END IF;
1377:
1378: FOR l_ind IN p_instance_asset_tbl.FIRST .. p_instance_asset_tbl.LAST
1379: LOOP

Line 1385: p_commit => fnd_api.g_false,

1381: l_instance_asset_rec := p_instance_asset_tbl(l_ind);
1382:
1383: csi_asset_pvt.update_instance_asset (
1384: p_api_version => 1.0,
1385: p_commit => fnd_api.g_false,
1386: p_init_msg_list => fnd_api.g_true,
1387: p_validation_level => fnd_api.g_valid_level_full,
1388: p_instance_asset_rec => l_instance_asset_rec,
1389: p_txn_rec => px_csi_txn_rec,

Line 1386: p_init_msg_list => fnd_api.g_true,

1382:
1383: csi_asset_pvt.update_instance_asset (
1384: p_api_version => 1.0,
1385: p_commit => fnd_api.g_false,
1386: p_init_msg_list => fnd_api.g_true,
1387: p_validation_level => fnd_api.g_valid_level_full,
1388: p_instance_asset_rec => l_instance_asset_rec,
1389: p_txn_rec => px_csi_txn_rec,
1390: x_return_status => l_return_status,

Line 1387: p_validation_level => fnd_api.g_valid_level_full,

1383: csi_asset_pvt.update_instance_asset (
1384: p_api_version => 1.0,
1385: p_commit => fnd_api.g_false,
1386: p_init_msg_list => fnd_api.g_true,
1387: p_validation_level => fnd_api.g_valid_level_full,
1388: p_instance_asset_rec => l_instance_asset_rec,
1389: p_txn_rec => px_csi_txn_rec,
1390: x_return_status => l_return_status,
1391: x_msg_count => l_msg_count,

Line 1398: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1394: p_asset_count_rec => l_asset_count_rec,
1395: p_asset_id_tbl => l_asset_id_tbl,
1396: p_asset_loc_tbl => l_asset_loc_tbl);
1397:
1398: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1399: RAISE fnd_api.g_exc_error;
1400: END IF;
1401:
1402: IF l_instance_asset_rec.fa_sync_flag = 'N' THEN

Line 1399: RAISE fnd_api.g_exc_error;

1395: p_asset_id_tbl => l_asset_id_tbl,
1396: p_asset_loc_tbl => l_asset_loc_tbl);
1397:
1398: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1399: RAISE fnd_api.g_exc_error;
1400: END IF;
1401:
1402: IF l_instance_asset_rec.fa_sync_flag = 'N' THEN
1403: l_warning_flag := 'Y';

Line 1418: WHEN fnd_api.g_exc_error THEN

1414: x_error_message := dump_error_stack;
1415: END IF;
1416:
1417: EXCEPTION
1418: WHEN fnd_api.g_exc_error THEN
1419: x_return_status := fnd_api.g_ret_sts_error;
1420: x_error_message := dump_error_stack;
1421: WHEN others THEN
1422: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1419: x_return_status := fnd_api.g_ret_sts_error;

1415: END IF;
1416:
1417: EXCEPTION
1418: WHEN fnd_api.g_exc_error THEN
1419: x_return_status := fnd_api.g_ret_sts_error;
1420: x_error_message := dump_error_stack;
1421: WHEN others THEN
1422: x_return_status := fnd_api.g_ret_sts_unexp_error;
1423: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');

Line 1422: x_return_status := fnd_api.g_ret_sts_unexp_error;

1418: WHEN fnd_api.g_exc_error THEN
1419: x_return_status := fnd_api.g_ret_sts_error;
1420: x_error_message := dump_error_stack;
1421: WHEN others THEN
1422: x_return_status := fnd_api.g_ret_sts_unexp_error;
1423: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
1424: fnd_message.set_token('API_NAME','csi_fa_instance_grp.update_asset_association');
1425: fnd_message.set_token('SQL_ERROR',SQLERRM);
1426: fnd_msg_pub.add;

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

1443:
1444: l_asset_quantity number;
1445: l_asset_location_id number;
1446:
1447: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1448: l_msg_count number;
1449: l_msg_data varchar2(2000);
1450:
1451: l_warning_flag varchar2(1) := 'N';

Line 1456: x_return_status := fnd_api.g_ret_sts_success;

1452:
1453:
1454: BEGIN
1455:
1456: x_return_status := fnd_api.g_ret_sts_success;
1457:
1458: debug('create_instance_assets');
1459:
1460: savepoint create_instance_assets;

Line 1467: IF nvl(px_instance_asset_tbl(ia_ind).fa_location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num

1463:
1464: FOR ia_ind IN px_instance_asset_tbl.FIRST .. px_instance_asset_tbl.LAST
1465: LOOP
1466:
1467: IF nvl(px_instance_asset_tbl(ia_ind).fa_location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
1468: OR
1469: nvl(px_instance_asset_tbl(ia_ind).asset_quantity, fnd_api.g_miss_num) = fnd_api.g_miss_num
1470: THEN
1471:

Line 1469: nvl(px_instance_asset_tbl(ia_ind).asset_quantity, fnd_api.g_miss_num) = fnd_api.g_miss_num

1465: LOOP
1466:
1467: IF nvl(px_instance_asset_tbl(ia_ind).fa_location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
1468: OR
1469: nvl(px_instance_asset_tbl(ia_ind).asset_quantity, fnd_api.g_miss_num) = fnd_api.g_miss_num
1470: THEN
1471:
1472: l_instance_rec.instance_id := px_instance_asset_tbl(ia_ind).instance_id;
1473: l_fixed_asset_rec.asset_id := px_instance_asset_tbl(ia_ind).fa_asset_id;

Line 1485: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1481: x_fa_quantity => l_asset_quantity,
1482: x_fa_book_type_code => px_instance_asset_tbl(ia_ind).fa_book_type_code,
1483: x_return_status => l_return_status);
1484:
1485: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1486: RAISE fnd_api.g_exc_error;
1487: END IF;
1488:
1489: IF nvl(px_instance_asset_tbl(ia_ind).fa_location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num

Line 1486: RAISE fnd_api.g_exc_error;

1482: x_fa_book_type_code => px_instance_asset_tbl(ia_ind).fa_book_type_code,
1483: x_return_status => l_return_status);
1484:
1485: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1486: RAISE fnd_api.g_exc_error;
1487: END IF;
1488:
1489: IF nvl(px_instance_asset_tbl(ia_ind).fa_location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
1490: THEN

Line 1489: IF nvl(px_instance_asset_tbl(ia_ind).fa_location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num

1485: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1486: RAISE fnd_api.g_exc_error;
1487: END IF;
1488:
1489: IF nvl(px_instance_asset_tbl(ia_ind).fa_location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
1490: THEN
1491: px_instance_asset_tbl(ia_ind).fa_location_id := l_asset_location_id;
1492: END IF;
1493:

Line 1494: IF nvl(px_instance_asset_tbl(ia_ind).asset_quantity, fnd_api.g_miss_num) = fnd_api.g_miss_num

1490: THEN
1491: px_instance_asset_tbl(ia_ind).fa_location_id := l_asset_location_id;
1492: END IF;
1493:
1494: IF nvl(px_instance_asset_tbl(ia_ind).asset_quantity, fnd_api.g_miss_num) = fnd_api.g_miss_num
1495: THEN
1496: px_instance_asset_tbl(ia_ind).asset_quantity := l_asset_quantity;
1497: END IF;
1498:

Line 1505: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1501: validate_inst_asset(
1502: px_inst_asset_rec => px_instance_asset_tbl(ia_ind),
1503: x_return_status => l_return_status);
1504:
1505: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1506: RAISE fnd_api.g_exc_error;
1507: END IF;
1508:
1509: IF nvl(px_instance_asset_tbl(ia_ind).instance_asset_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

Line 1506: RAISE fnd_api.g_exc_error;

1502: px_inst_asset_rec => px_instance_asset_tbl(ia_ind),
1503: x_return_status => l_return_status);
1504:
1505: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1506: RAISE fnd_api.g_exc_error;
1507: END IF;
1508:
1509: IF nvl(px_instance_asset_tbl(ia_ind).instance_asset_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
1510:

Line 1509: IF nvl(px_instance_asset_tbl(ia_ind).instance_asset_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

1505: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1506: RAISE fnd_api.g_exc_error;
1507: END IF;
1508:
1509: IF nvl(px_instance_asset_tbl(ia_ind).instance_asset_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
1510:
1511: csi_asset_pvt.create_instance_asset(
1512: p_api_version => 1.0,
1513: p_commit => fnd_api.g_false,

Line 1513: p_commit => fnd_api.g_false,

1509: IF nvl(px_instance_asset_tbl(ia_ind).instance_asset_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
1510:
1511: csi_asset_pvt.create_instance_asset(
1512: p_api_version => 1.0,
1513: p_commit => fnd_api.g_false,
1514: p_init_msg_list => fnd_api.g_true,
1515: p_validation_level => fnd_api.g_valid_level_full,
1516: p_instance_asset_rec => px_instance_asset_tbl(ia_ind),
1517: p_txn_rec => px_csi_txn_rec,

Line 1514: p_init_msg_list => fnd_api.g_true,

1510:
1511: csi_asset_pvt.create_instance_asset(
1512: p_api_version => 1.0,
1513: p_commit => fnd_api.g_false,
1514: p_init_msg_list => fnd_api.g_true,
1515: p_validation_level => fnd_api.g_valid_level_full,
1516: p_instance_asset_rec => px_instance_asset_tbl(ia_ind),
1517: p_txn_rec => px_csi_txn_rec,
1518: p_lookup_tbl => l_lookup_tbl,

Line 1515: p_validation_level => fnd_api.g_valid_level_full,

1511: csi_asset_pvt.create_instance_asset(
1512: p_api_version => 1.0,
1513: p_commit => fnd_api.g_false,
1514: p_init_msg_list => fnd_api.g_true,
1515: p_validation_level => fnd_api.g_valid_level_full,
1516: p_instance_asset_rec => px_instance_asset_tbl(ia_ind),
1517: p_txn_rec => px_csi_txn_rec,
1518: p_lookup_tbl => l_lookup_tbl,
1519: p_asset_count_rec => l_asset_count_rec,

Line 1526: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1522: x_return_status => l_return_status,
1523: x_msg_count => l_msg_count,
1524: x_msg_data => l_msg_data);
1525:
1526: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1527: RAISE fnd_api.g_exc_error;
1528: END IF;
1529:
1530: ELSE

Line 1527: RAISE fnd_api.g_exc_error;

1523: x_msg_count => l_msg_count,
1524: x_msg_data => l_msg_data);
1525:
1526: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1527: RAISE fnd_api.g_exc_error;
1528: END IF;
1529:
1530: ELSE
1531: null;

Line 1548: x_return_status := fnd_api.g_ret_sts_success;

1544: fnd_msg_pub.add;
1545: x_return_status := 'W';
1546: x_error_message := dump_error_stack;
1547: ELSE
1548: x_return_status := fnd_api.g_ret_sts_success;
1549: END IF;
1550:
1551: EXCEPTION
1552: WHEN fnd_api.g_exc_error THEN

Line 1552: WHEN fnd_api.g_exc_error THEN

1548: x_return_status := fnd_api.g_ret_sts_success;
1549: END IF;
1550:
1551: EXCEPTION
1552: WHEN fnd_api.g_exc_error THEN
1553: rollback to create_instance_assets;
1554: x_return_status := fnd_api.g_ret_sts_error;
1555: x_error_message := dump_error_stack;
1556: WHEN others THEN

Line 1554: x_return_status := fnd_api.g_ret_sts_error;

1550:
1551: EXCEPTION
1552: WHEN fnd_api.g_exc_error THEN
1553: rollback to create_instance_assets;
1554: x_return_status := fnd_api.g_ret_sts_error;
1555: x_error_message := dump_error_stack;
1556: WHEN others THEN
1557: rollback to create_instance_assets;
1558: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 1558: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1554: x_return_status := fnd_api.g_ret_sts_error;
1555: x_error_message := dump_error_stack;
1556: WHEN others THEN
1557: rollback to create_instance_assets;
1558: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1559: x_error_message := substr(sqlerrm, 1, 2000);
1560: END create_instance_assets;
1561:
1562: END csi_fa_instance_grp;