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 422: x_return_status := fnd_api.g_ret_sts_success;

418: g_ia_ind binary_integer := 0;
419:
420: BEGIN
421:
422: x_return_status := fnd_api.g_ret_sts_success;
423:
424: savepoint fa_grp_create_instance;
425:
426: -- validate mandatory fields

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

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

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

463:
464: -- derive eam_item_type
465: IF nvl(p_instance_rec.inventory_item_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
466: AND
467: nvl(p_instance_rec.vld_organization_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
468: THEN
469:
470: SELECT eam_item_type,
471: serial_number_control_code

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

480: END IF;
481:
482: END IF;
483:
484: IF nvl(p_fixed_asset_rec.asset_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
485:
486: IF nvl(p_fixed_asset_rec.asset_location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
487: OR
488: nvl(p_fixed_asset_rec.asset_quantity, fnd_api.g_miss_num) = fnd_api.g_miss_num

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

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

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

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

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

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

Line 501: IF l_return_status <> fnd_api.g_ret_sts_success THEN

497: x_fa_quantity => l_fa_quantity,
498: x_fa_book_type_code => l_fa_book_type_code,
499: x_return_status => l_return_status);
500:
501: IF l_return_status <> fnd_api.g_ret_sts_success THEN
502: RAISE fnd_api.g_exc_error;
503: END IF;
504: END IF;
505: END IF;

Line 502: RAISE fnd_api.g_exc_error;

498: x_fa_book_type_code => l_fa_book_type_code,
499: x_return_status => l_return_status);
500:
501: IF l_return_status <> fnd_api.g_ret_sts_success THEN
502: RAISE fnd_api.g_exc_error;
503: END IF;
504: END IF;
505: END IF;
506:

Line 509: p_commit => fnd_api.g_false,

505: END IF;
506:
507: csi_transactions_pvt.create_transaction(
508: p_api_version => 1.0,
509: p_commit => fnd_api.g_false,
510: p_init_msg_list => fnd_api.g_true,
511: p_validation_level => fnd_api.g_valid_level_full,
512: p_success_if_exists_flag => 'Y',
513: p_transaction_rec => px_csi_txn_rec,

Line 510: p_init_msg_list => fnd_api.g_true,

506:
507: csi_transactions_pvt.create_transaction(
508: p_api_version => 1.0,
509: p_commit => fnd_api.g_false,
510: p_init_msg_list => fnd_api.g_true,
511: p_validation_level => fnd_api.g_valid_level_full,
512: p_success_if_exists_flag => 'Y',
513: p_transaction_rec => px_csi_txn_rec,
514: x_return_status => l_return_status,

Line 511: p_validation_level => fnd_api.g_valid_level_full,

507: csi_transactions_pvt.create_transaction(
508: p_api_version => 1.0,
509: p_commit => fnd_api.g_false,
510: p_init_msg_list => fnd_api.g_true,
511: p_validation_level => fnd_api.g_valid_level_full,
512: p_success_if_exists_flag => 'Y',
513: p_transaction_rec => px_csi_txn_rec,
514: x_return_status => l_return_status,
515: x_msg_count => l_msg_count,

Line 518: IF l_return_status <> fnd_api.g_ret_sts_success THEN

514: x_return_status => l_return_status,
515: x_msg_count => l_msg_count,
516: x_msg_data => l_msg_data);
517:
518: IF l_return_status <> fnd_api.g_ret_sts_success THEN
519: RAISE fnd_api.g_exc_error;
520: END IF;
521:
522: IF p_instance_serial_tbl.COUNT > 0 THEN

Line 519: RAISE fnd_api.g_exc_error;

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

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

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

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

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

Line 597: IF l_return_status <> fnd_api.g_ret_sts_success THEN

593: validate_inst_asset(
594: px_inst_asset_rec => l_instance_asset_tbl(g_ia_ind),
595: x_return_status => l_return_status);
596:
597: IF l_return_status <> fnd_api.g_ret_sts_success THEN
598: RAISE fnd_api.g_exc_error;
599: END IF;
600:
601: END IF;

Line 598: RAISE fnd_api.g_exc_error;

594: px_inst_asset_rec => l_instance_asset_tbl(g_ia_ind),
595: x_return_status => l_return_status);
596:
597: IF l_return_status <> fnd_api.g_ret_sts_success THEN
598: RAISE fnd_api.g_exc_error;
599: END IF;
600:
601: END IF;
602:

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

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

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

644: l_instance_asset_tbl(g_ia_ind).asset_quantity := p_instance_rec.quantity;
645: l_instance_asset_tbl(g_ia_ind).update_status := 'IN_SERVICE';
646: l_instance_asset_tbl(g_ia_ind).fa_sync_flag := p_fixed_asset_rec.fa_sync_flag;
647: l_instance_asset_tbl(g_ia_ind).fa_sync_validation_reqd :=
648: nvl(p_fixed_asset_rec.fa_sync_validation_reqd, fnd_api.g_false);
649:
650: validate_inst_asset(
651: px_inst_asset_rec => l_instance_asset_tbl(g_ia_ind),
652: x_return_status => l_return_status);

Line 654: IF l_return_status <> fnd_api.g_ret_sts_success THEN

650: validate_inst_asset(
651: px_inst_asset_rec => l_instance_asset_tbl(g_ia_ind),
652: x_return_status => l_return_status);
653:
654: IF l_return_status <> fnd_api.g_ret_sts_success THEN
655: RAISE fnd_api.g_exc_error;
656: END IF;
657:
658: END IF;

Line 655: RAISE fnd_api.g_exc_error;

651: px_inst_asset_rec => l_instance_asset_tbl(g_ia_ind),
652: x_return_status => l_return_status);
653:
654: IF l_return_status <> fnd_api.g_ret_sts_success THEN
655: RAISE fnd_api.g_exc_error;
656: END IF;
657:
658: END IF;
659:

Line 667: p_commit => fnd_api.g_false,

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

Line 668: p_init_msg_list => fnd_api.g_true,

664:
665: csi_item_instance_grp.create_item_instance (
666: p_api_version => 1.0,
667: p_commit => fnd_api.g_false,
668: p_init_msg_list => fnd_api.g_true,
669: p_validation_level => fnd_api.g_valid_level_full,
670: p_instance_tbl => l_instance_tbl,
671: p_ext_attrib_values_tbl => l_ext_attrib_values_tbl,
672: p_party_tbl => l_party_tbl,

Line 669: p_validation_level => fnd_api.g_valid_level_full,

665: csi_item_instance_grp.create_item_instance (
666: p_api_version => 1.0,
667: p_commit => fnd_api.g_false,
668: p_init_msg_list => fnd_api.g_true,
669: p_validation_level => fnd_api.g_valid_level_full,
670: p_instance_tbl => l_instance_tbl,
671: p_ext_attrib_values_tbl => l_ext_attrib_values_tbl,
672: p_party_tbl => l_party_tbl,
673: p_account_tbl => l_account_tbl,

Line 684: IF l_return_status <> fnd_api.g_ret_sts_success THEN

680: x_return_status => l_return_status,
681: x_msg_count => l_msg_count,
682: x_msg_data => l_msg_data);
683:
684: IF l_return_status <> fnd_api.g_ret_sts_success THEN
685: RAISE fnd_api.g_exc_error;
686: END IF;
687:
688: IF l_grp_error_tbl.COUNT > 0 THEN

Line 685: RAISE fnd_api.g_exc_error;

681: x_msg_count => l_msg_count,
682: x_msg_data => l_msg_data);
683:
684: IF l_return_status <> fnd_api.g_ret_sts_success THEN
685: RAISE fnd_api.g_exc_error;
686: END IF;
687:
688: IF l_grp_error_tbl.COUNT > 0 THEN
689: -- errors should be passes out as error.

Line 694: RAISE fnd_api.g_exc_error;

690: FOR err_ind IN l_grp_error_tbl.FIRST ..l_grp_error_tbl.LAST
691: LOOP
692: IF l_grp_error_tbl(err_ind).process_status = 'E' THEN
693: l_error_message := l_grp_error_tbl(err_ind).error_message;
694: RAISE fnd_api.g_exc_error;
695: END IF;
696: END LOOP;
697:
698: END IF;

Line 708: p_init_msg_list => fnd_api.g_true,

704: IF l_eam_item THEN
705: -- to be uncommented later
706: eam_maint_attributes_pub.create_maint_attributes(
707: p_api_version => 1.0,
708: p_init_msg_list => fnd_api.g_true,
709: p_commit => fnd_api.g_false,
710: p_validation_level => fnd_api.g_valid_level_full,
711: p_instance_id => l_instance_tbl(inst_ind).instance_id,
712: p_owning_department_id => p_eam_rec.owning_department_id,

Line 709: p_commit => fnd_api.g_false,

705: -- to be uncommented later
706: eam_maint_attributes_pub.create_maint_attributes(
707: p_api_version => 1.0,
708: p_init_msg_list => fnd_api.g_true,
709: p_commit => fnd_api.g_false,
710: p_validation_level => fnd_api.g_valid_level_full,
711: p_instance_id => l_instance_tbl(inst_ind).instance_id,
712: p_owning_department_id => p_eam_rec.owning_department_id,
713: p_accounting_class_code => p_eam_rec.wip_accounting_class_code,

Line 710: p_validation_level => fnd_api.g_valid_level_full,

706: eam_maint_attributes_pub.create_maint_attributes(
707: p_api_version => 1.0,
708: p_init_msg_list => fnd_api.g_true,
709: p_commit => fnd_api.g_false,
710: p_validation_level => fnd_api.g_valid_level_full,
711: p_instance_id => l_instance_tbl(inst_ind).instance_id,
712: p_owning_department_id => p_eam_rec.owning_department_id,
713: p_accounting_class_code => p_eam_rec.wip_accounting_class_code,
714: p_area_id => p_eam_rec.area_id,

Line 720: IF l_return_status <> fnd_api.g_ret_sts_success THEN

716: x_return_status => l_return_status,
717: x_msg_count => l_msg_count,
718: x_msg_data => l_msg_data);
719:
720: IF l_return_status <> fnd_api.g_ret_sts_success THEN
721: RAISE fnd_api.g_exc_error;
722: END IF;
723: END IF;
724:

Line 721: RAISE fnd_api.g_exc_error;

717: x_msg_count => l_msg_count,
718: x_msg_data => l_msg_data);
719:
720: IF l_return_status <> fnd_api.g_ret_sts_success THEN
721: RAISE fnd_api.g_exc_error;
722: END IF;
723: END IF;
724:
725: END LOOP;

Line 749: WHEN fnd_api.g_exc_error THEN

745: x_error_message := dump_error_stack;
746: END IF;
747:
748: EXCEPTION
749: WHEN fnd_api.g_exc_error THEN
750: rollback to fa_grp_create_instance;
751: x_return_status := fnd_api.g_ret_sts_error;
752: x_error_message := dump_error_stack;
753: WHEN others THEN

Line 751: x_return_status := fnd_api.g_ret_sts_error;

747:
748: EXCEPTION
749: WHEN fnd_api.g_exc_error THEN
750: rollback to fa_grp_create_instance;
751: x_return_status := fnd_api.g_ret_sts_error;
752: x_error_message := dump_error_stack;
753: WHEN others THEN
754: rollback to fa_grp_create_instance;
755: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 755: x_return_status := fnd_api.g_ret_sts_unexp_error;

751: x_return_status := fnd_api.g_ret_sts_error;
752: x_error_message := dump_error_stack;
753: WHEN others THEN
754: rollback to fa_grp_create_instance;
755: x_return_status := fnd_api.g_ret_sts_unexp_error;
756: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
757: fnd_message.set_token('API_NAME','csi_fa_instance_grp.create_item_instance');
758: fnd_message.set_token('SQL_ERROR',SQLERRM);
759: fnd_msg_pub.add;

Line 797: l_miss_num number := fnd_api.g_miss_num;

793: l_fa_flow varchar2(1);
794: l_copy_flags_rec copy_flags_rec;
795: l_instance_rec csi_datastructures_pub.instance_rec;
796:
797: l_miss_num number := fnd_api.g_miss_num;
798: l_miss_char varchar2(200) := fnd_api.g_miss_char;
799:
800: l_instance_tbl csi_datastructures_pub.instance_tbl;
801:

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

794: l_copy_flags_rec copy_flags_rec;
795: l_instance_rec csi_datastructures_pub.instance_rec;
796:
797: l_miss_num number := fnd_api.g_miss_num;
798: l_miss_char varchar2(200) := fnd_api.g_miss_char;
799:
800: l_instance_tbl csi_datastructures_pub.instance_tbl;
801:
802: o_ind binary_integer := 0;

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

804:
805: ia_ind binary_integer := 0;
806: l_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
807:
808: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
809: l_msg_count number;
810: l_msg_data varchar2(4000);
811: l_error_message varchar2(2000);
812:

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

837: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
838: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
839: l_inst_id_lst csi_datastructures_pub.id_tbl;
840:
841: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
842: l_msg_count number;
843: l_msg_data varchar2(4000);
844: BEGIN
845:

Line 846: x_return_status := fnd_api.g_ret_sts_success;

842: l_msg_count number;
843: l_msg_data varchar2(4000);
844: BEGIN
845:
846: x_return_status := fnd_api.g_ret_sts_success;
847:
848: csi_item_instance_pvt.copy_item_instance(
849: p_api_version => 1.0,
850: p_commit => fnd_api.g_false,

Line 850: p_commit => fnd_api.g_false,

846: x_return_status := fnd_api.g_ret_sts_success;
847:
848: csi_item_instance_pvt.copy_item_instance(
849: p_api_version => 1.0,
850: p_commit => fnd_api.g_false,
851: p_init_msg_list => fnd_api.g_true,
852: p_validation_level => fnd_api.g_valid_level_full,
853: p_source_instance_rec => p_instance_rec,
854: p_copy_ext_attribs => p_copy_flags_rec.copy_ext_attribs,

Line 851: p_init_msg_list => fnd_api.g_true,

847:
848: csi_item_instance_pvt.copy_item_instance(
849: p_api_version => 1.0,
850: p_commit => fnd_api.g_false,
851: p_init_msg_list => fnd_api.g_true,
852: p_validation_level => fnd_api.g_valid_level_full,
853: p_source_instance_rec => p_instance_rec,
854: p_copy_ext_attribs => p_copy_flags_rec.copy_ext_attribs,
855: p_copy_org_assignments => p_copy_flags_rec.copy_org_assignments,

Line 852: p_validation_level => fnd_api.g_valid_level_full,

848: csi_item_instance_pvt.copy_item_instance(
849: p_api_version => 1.0,
850: p_commit => fnd_api.g_false,
851: p_init_msg_list => fnd_api.g_true,
852: p_validation_level => fnd_api.g_valid_level_full,
853: p_source_instance_rec => p_instance_rec,
854: p_copy_ext_attribs => p_copy_flags_rec.copy_ext_attribs,
855: p_copy_org_assignments => p_copy_flags_rec.copy_org_assignments,
856: p_copy_parties => p_copy_flags_rec.copy_parties,

Line 862: p_call_from_split => fnd_api.g_false,

858: p_copy_accounts => p_copy_flags_rec.copy_accounts,
859: p_copy_asset_assignments => p_copy_flags_rec.copy_asset_assignments,
860: p_copy_pricing_attribs => p_copy_flags_rec.copy_pricing_attribs,
861: p_copy_inst_children => p_copy_flags_rec.copy_inst_children,
862: p_call_from_split => fnd_api.g_false,
863: p_txn_rec => px_csi_txn_rec,
864: x_new_instance_tbl => l_instance_tbl,
865: x_return_status => l_return_status,
866: x_msg_count => l_msg_count,

Line 869: IF l_return_status <> fnd_api.g_ret_sts_success THEN

865: x_return_status => l_return_status,
866: x_msg_count => l_msg_count,
867: x_msg_data => l_msg_data);
868:
869: IF l_return_status <> fnd_api.g_ret_sts_success THEN
870: RAISE fnd_api.g_exc_error;
871: END IF;
872:
873: IF nvl(p_fa_flow, 'N') = 'Y' THEN

Line 870: RAISE fnd_api.g_exc_error;

866: x_msg_count => l_msg_count,
867: x_msg_data => l_msg_data);
868:
869: IF l_return_status <> fnd_api.g_ret_sts_success THEN
870: RAISE fnd_api.g_exc_error;
871: END IF;
872:
873: IF nvl(p_fa_flow, 'N') = 'Y' THEN
874:

Line 904: p_commit => fnd_api.g_false,

900:
901: -- change the owner to internal
902: csi_item_instance_pub.update_item_instance(
903: p_api_version => 1.0,
904: p_commit => fnd_api.g_false,
905: p_init_msg_list => fnd_api.g_true,
906: p_validation_level => fnd_api.g_valid_level_full,
907: p_instance_rec => l_instance_rec,
908: p_ext_attrib_values_tbl => l_eav_tbl,

Line 905: p_init_msg_list => fnd_api.g_true,

901: -- change the owner to internal
902: csi_item_instance_pub.update_item_instance(
903: p_api_version => 1.0,
904: p_commit => fnd_api.g_false,
905: p_init_msg_list => fnd_api.g_true,
906: p_validation_level => fnd_api.g_valid_level_full,
907: p_instance_rec => l_instance_rec,
908: p_ext_attrib_values_tbl => l_eav_tbl,
909: p_party_tbl => l_party_tbl,

Line 906: p_validation_level => fnd_api.g_valid_level_full,

902: csi_item_instance_pub.update_item_instance(
903: p_api_version => 1.0,
904: p_commit => fnd_api.g_false,
905: p_init_msg_list => fnd_api.g_true,
906: p_validation_level => fnd_api.g_valid_level_full,
907: p_instance_rec => l_instance_rec,
908: p_ext_attrib_values_tbl => l_eav_tbl,
909: p_party_tbl => l_party_tbl,
910: p_account_tbl => l_party_acct_tbl,

Line 920: IF l_return_status <> fnd_api.g_ret_sts_success THEN

916: x_return_status => l_return_status,
917: x_msg_count => l_msg_count,
918: x_msg_data => l_msg_data);
919:
920: IF l_return_status <> fnd_api.g_ret_sts_success THEN
921: RAISE fnd_api.g_exc_error;
922: END IF;
923:
924: END IF;

Line 921: RAISE fnd_api.g_exc_error;

917: x_msg_count => l_msg_count,
918: x_msg_data => l_msg_data);
919:
920: IF l_return_status <> fnd_api.g_ret_sts_success THEN
921: RAISE fnd_api.g_exc_error;
922: END IF;
923:
924: END IF;
925:

Line 931: WHEN fnd_api.g_exc_error THEN

927:
928: x_instance_tbl := l_instance_tbl;
929:
930: EXCEPTION
931: WHEN fnd_api.g_exc_error THEN
932: x_return_status := fnd_api.g_ret_sts_error;
933: END do_copy;
934:
935: BEGIN

Line 932: x_return_status := fnd_api.g_ret_sts_error;

928: x_instance_tbl := l_instance_tbl;
929:
930: EXCEPTION
931: WHEN fnd_api.g_exc_error THEN
932: x_return_status := fnd_api.g_ret_sts_error;
933: END do_copy;
934:
935: BEGIN
936:

Line 937: x_return_status := fnd_api.g_ret_sts_success;

933: END do_copy;
934:
935: BEGIN
936:
937: x_return_status := fnd_api.g_ret_sts_success;
938:
939: savepoint fa_grp_copy_instance;
940:
941: csi_item_instance_vld_pvt.check_reqd_param_num (

Line 948: p_commit => fnd_api.g_false,

944: p_api_name => 'csi_fa_instance_rec.copy_item_instance');
945:
946: csi_transactions_pvt.create_transaction(
947: p_api_version => 1.0,
948: p_commit => fnd_api.g_false,
949: p_init_msg_list => fnd_api.g_true,
950: p_validation_level => fnd_api.g_valid_level_full,
951: p_success_if_exists_flag => 'Y',
952: p_transaction_rec => px_csi_txn_rec,

Line 949: p_init_msg_list => fnd_api.g_true,

945:
946: csi_transactions_pvt.create_transaction(
947: p_api_version => 1.0,
948: p_commit => fnd_api.g_false,
949: p_init_msg_list => fnd_api.g_true,
950: p_validation_level => fnd_api.g_valid_level_full,
951: p_success_if_exists_flag => 'Y',
952: p_transaction_rec => px_csi_txn_rec,
953: x_return_status => l_return_status,

Line 950: p_validation_level => fnd_api.g_valid_level_full,

946: csi_transactions_pvt.create_transaction(
947: p_api_version => 1.0,
948: p_commit => fnd_api.g_false,
949: p_init_msg_list => fnd_api.g_true,
950: p_validation_level => fnd_api.g_valid_level_full,
951: p_success_if_exists_flag => 'Y',
952: p_transaction_rec => px_csi_txn_rec,
953: x_return_status => l_return_status,
954: x_msg_count => l_msg_count,

Line 957: IF l_return_status <> fnd_api.g_ret_sts_success THEN

953: x_return_status => l_return_status,
954: x_msg_count => l_msg_count,
955: x_msg_data => l_msg_data);
956:
957: IF l_return_status <> fnd_api.g_ret_sts_success THEN
958: RAISE fnd_api.g_exc_error;
959: END IF;
960:
961: IF nvl(p_fixed_asset_rec.asset_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

Line 958: RAISE fnd_api.g_exc_error;

954: x_msg_count => l_msg_count,
955: x_msg_data => l_msg_data);
956:
957: IF l_return_status <> fnd_api.g_ret_sts_success THEN
958: RAISE fnd_api.g_exc_error;
959: END IF;
960:
961: IF nvl(p_fixed_asset_rec.asset_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
962: l_fa_flow := 'Y';

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

957: IF l_return_status <> fnd_api.g_ret_sts_success THEN
958: RAISE fnd_api.g_exc_error;
959: END IF;
960:
961: IF nvl(p_fixed_asset_rec.asset_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
962: l_fa_flow := 'Y';
963: l_copy_flags_rec.copy_parties := fnd_api.g_false;
964: l_copy_flags_rec.copy_accounts := fnd_api.g_false;
965: l_copy_flags_rec.copy_contacts := fnd_api.g_false;

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

959: END IF;
960:
961: IF nvl(p_fixed_asset_rec.asset_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
962: l_fa_flow := 'Y';
963: l_copy_flags_rec.copy_parties := fnd_api.g_false;
964: l_copy_flags_rec.copy_accounts := fnd_api.g_false;
965: l_copy_flags_rec.copy_contacts := fnd_api.g_false;
966: ELSE
967: l_fa_flow := 'N';

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

960:
961: IF nvl(p_fixed_asset_rec.asset_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
962: l_fa_flow := 'Y';
963: l_copy_flags_rec.copy_parties := fnd_api.g_false;
964: l_copy_flags_rec.copy_accounts := fnd_api.g_false;
965: l_copy_flags_rec.copy_contacts := fnd_api.g_false;
966: ELSE
967: l_fa_flow := 'N';
968: l_copy_flags_rec.copy_parties := p_copy_parties;

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

961: IF nvl(p_fixed_asset_rec.asset_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
962: l_fa_flow := 'Y';
963: l_copy_flags_rec.copy_parties := fnd_api.g_false;
964: l_copy_flags_rec.copy_accounts := fnd_api.g_false;
965: l_copy_flags_rec.copy_contacts := fnd_api.g_false;
966: ELSE
967: l_fa_flow := 'N';
968: l_copy_flags_rec.copy_parties := p_copy_parties;
969: l_copy_flags_rec.copy_accounts := p_copy_accounts;

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

976: l_copy_flags_rec.copy_asset_assignments := p_copy_asset_assignments;
977: l_copy_flags_rec.copy_inst_children := p_copy_inst_children;
978:
979: -- derive eam_item_type
980: IF nvl(p_instance_rec.inventory_item_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
981: AND
982: nvl(p_instance_rec.vld_organization_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
983: THEN
984:

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

978:
979: -- derive eam_item_type
980: IF nvl(p_instance_rec.inventory_item_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
981: AND
982: nvl(p_instance_rec.vld_organization_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
983: THEN
984:
985: SELECT eam_item_type,
986: serial_number_control_code

Line 1038: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1034: px_csi_txn_rec => px_csi_txn_rec,
1035: x_instance_tbl => l_instance_tbl,
1036: x_return_status => l_return_status);
1037:
1038: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1039: l_error_message := dump_error_stack;
1040: RAISE fnd_api.g_exc_error;
1041: END IF;
1042:

Line 1040: RAISE fnd_api.g_exc_error;

1036: x_return_status => l_return_status);
1037:
1038: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1039: l_error_message := dump_error_stack;
1040: RAISE fnd_api.g_exc_error;
1041: END IF;
1042:
1043: IF l_instance_tbl.COUNT > 0 THEN
1044: FOR inst_ind IN l_instance_tbl.FIRST .. l_instance_tbl.LAST

Line 1069: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1065: px_csi_txn_rec => px_csi_txn_rec,
1066: x_instance_tbl => l_instance_tbl,
1067: x_return_status => l_return_status);
1068:
1069: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1070: l_error_message := dump_error_stack;
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:
1069: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1070: l_error_message := dump_error_stack;
1071: RAISE fnd_api.g_exc_error;
1072: END IF;
1073:
1074: IF l_instance_tbl.COUNT > 0 THEN
1075: FOR inst_ind IN l_instance_tbl.FIRST .. l_instance_tbl.LAST

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

1084: IF o_instance_tbl.COUNT > 0 THEN
1085: FOR inst_ind IN o_instance_tbl.FIRST .. o_instance_tbl.LAST
1086: LOOP
1087:
1088: IF nvl(p_fixed_asset_rec.asset_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
1089: ia_ind := ia_ind + 1;
1090: l_instance_asset_tbl(ia_ind).instance_id := o_instance_tbl(inst_ind).instance_id;
1091: l_instance_asset_tbl(ia_ind).fa_asset_id := p_fixed_asset_rec.asset_id;
1092: l_instance_asset_tbl(ia_ind).fa_book_type_code := p_fixed_asset_rec.book_type_code;

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

1100:
1101: IF l_eam_item THEN
1102:
1103: /*Need to flip the EAM attributes.*/
1104: IF p_eam_rec.owning_department_id = FND_API.G_MISS_NUM THEN
1105: l_owning_department_id := NULL;
1106: ELSIF p_eam_rec.owning_department_id IS NULL THEN
1107: l_owning_department_id := FND_API.G_MISS_NUM;
1108: END IF;

Line 1107: l_owning_department_id := FND_API.G_MISS_NUM;

1103: /*Need to flip the EAM attributes.*/
1104: IF p_eam_rec.owning_department_id = FND_API.G_MISS_NUM THEN
1105: l_owning_department_id := NULL;
1106: ELSIF p_eam_rec.owning_department_id IS NULL THEN
1107: l_owning_department_id := FND_API.G_MISS_NUM;
1108: END IF;
1109:
1110: IF p_eam_rec.wip_accounting_class_code = FND_API.G_MISS_CHAR THEN
1111: l_wip_accounting_class_code := NULL;

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

1106: ELSIF p_eam_rec.owning_department_id IS NULL THEN
1107: l_owning_department_id := FND_API.G_MISS_NUM;
1108: END IF;
1109:
1110: IF p_eam_rec.wip_accounting_class_code = FND_API.G_MISS_CHAR THEN
1111: l_wip_accounting_class_code := NULL;
1112: ELSIF p_eam_rec.owning_department_id IS NULL THEN
1113: l_wip_accounting_class_code := FND_API.G_MISS_CHAR;
1114: END IF;

Line 1113: l_wip_accounting_class_code := FND_API.G_MISS_CHAR;

1109:
1110: IF p_eam_rec.wip_accounting_class_code = FND_API.G_MISS_CHAR THEN
1111: l_wip_accounting_class_code := NULL;
1112: ELSIF p_eam_rec.owning_department_id IS NULL THEN
1113: l_wip_accounting_class_code := FND_API.G_MISS_CHAR;
1114: END IF;
1115:
1116: IF p_eam_rec.area_id = FND_API.G_MISS_NUM THEN
1117: l_area_id := NULL;

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

1112: ELSIF p_eam_rec.owning_department_id IS NULL THEN
1113: l_wip_accounting_class_code := FND_API.G_MISS_CHAR;
1114: END IF;
1115:
1116: IF p_eam_rec.area_id = FND_API.G_MISS_NUM THEN
1117: l_area_id := NULL;
1118: ELSIF p_eam_rec.owning_department_id IS NULL THEN
1119: l_area_id := FND_API.G_MISS_NUM;
1120: END IF;

Line 1119: l_area_id := FND_API.G_MISS_NUM;

1115:
1116: IF p_eam_rec.area_id = FND_API.G_MISS_NUM THEN
1117: l_area_id := NULL;
1118: ELSIF p_eam_rec.owning_department_id IS NULL THEN
1119: l_area_id := FND_API.G_MISS_NUM;
1120: END IF;
1121:
1122: IF p_eam_rec.parent_instance_id = FND_API.G_MISS_NUM THEN
1123: l_parent_instance_id := NULL;

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

1118: ELSIF p_eam_rec.owning_department_id IS NULL THEN
1119: l_area_id := FND_API.G_MISS_NUM;
1120: END IF;
1121:
1122: IF p_eam_rec.parent_instance_id = FND_API.G_MISS_NUM THEN
1123: l_parent_instance_id := NULL;
1124: ELSIF p_eam_rec.owning_department_id IS NULL THEN
1125: l_parent_instance_id := FND_API.G_MISS_NUM;
1126: END IF;

Line 1125: l_parent_instance_id := FND_API.G_MISS_NUM;

1121:
1122: IF p_eam_rec.parent_instance_id = FND_API.G_MISS_NUM THEN
1123: l_parent_instance_id := NULL;
1124: ELSIF p_eam_rec.owning_department_id IS NULL THEN
1125: l_parent_instance_id := FND_API.G_MISS_NUM;
1126: END IF;
1127:
1128: eam_maint_attributes_pub.create_maint_attributes(
1129: p_api_version => 1.0,

Line 1130: p_init_msg_list => fnd_api.g_true,

1126: END IF;
1127:
1128: eam_maint_attributes_pub.create_maint_attributes(
1129: p_api_version => 1.0,
1130: p_init_msg_list => fnd_api.g_true,
1131: p_commit => fnd_api.g_false,
1132: p_validation_level => fnd_api.g_valid_level_full,
1133: p_instance_id => l_instance_tbl(inst_ind).instance_id,
1134: p_owning_department_id => l_owning_department_id,

Line 1131: p_commit => fnd_api.g_false,

1127:
1128: eam_maint_attributes_pub.create_maint_attributes(
1129: p_api_version => 1.0,
1130: p_init_msg_list => fnd_api.g_true,
1131: p_commit => fnd_api.g_false,
1132: p_validation_level => fnd_api.g_valid_level_full,
1133: p_instance_id => l_instance_tbl(inst_ind).instance_id,
1134: p_owning_department_id => l_owning_department_id,
1135: p_accounting_class_code => l_wip_accounting_class_code,

Line 1132: p_validation_level => fnd_api.g_valid_level_full,

1128: eam_maint_attributes_pub.create_maint_attributes(
1129: p_api_version => 1.0,
1130: p_init_msg_list => fnd_api.g_true,
1131: p_commit => fnd_api.g_false,
1132: p_validation_level => fnd_api.g_valid_level_full,
1133: p_instance_id => l_instance_tbl(inst_ind).instance_id,
1134: p_owning_department_id => l_owning_department_id,
1135: p_accounting_class_code => l_wip_accounting_class_code,
1136: p_area_id => l_area_id,

Line 1142: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1138: x_return_status => l_return_status,
1139: x_msg_count => l_msg_count,
1140: x_msg_data => l_msg_data);
1141:
1142: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1143: RAISE fnd_api.g_exc_error;
1144: END IF;
1145: END IF;
1146:

Line 1143: RAISE fnd_api.g_exc_error;

1139: x_msg_count => l_msg_count,
1140: x_msg_data => l_msg_data);
1141:
1142: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1143: RAISE fnd_api.g_exc_error;
1144: END IF;
1145: END IF;
1146:
1147: END LOOP;

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

1154: px_csi_txn_rec => px_csi_txn_rec,
1155: x_return_status => l_return_status,
1156: x_error_message => l_error_message);
1157:
1158: IF l_return_status IN (fnd_api.g_ret_sts_success, 'W') THEN
1159: x_return_status := l_return_status;
1160: x_error_message := l_error_message;
1161: ELSE
1162: RAISE fnd_api.g_exc_error;

Line 1162: RAISE fnd_api.g_exc_error;

1158: IF l_return_status IN (fnd_api.g_ret_sts_success, 'W') THEN
1159: x_return_status := l_return_status;
1160: x_error_message := l_error_message;
1161: ELSE
1162: RAISE fnd_api.g_exc_error;
1163: END IF;
1164:
1165: END IF;
1166:

Line 1171: WHEN fnd_api.g_exc_error THEN

1167: x_instance_tbl := o_instance_tbl;
1168: x_instance_asset_tbl := l_instance_asset_tbl;
1169:
1170: EXCEPTION
1171: WHEN fnd_api.g_exc_error THEN
1172: rollback to fa_grp_copy_instance;
1173: x_return_status := fnd_api.g_ret_sts_error;
1174: x_error_message := dump_error_stack;
1175: WHEN others THEN

Line 1173: x_return_status := fnd_api.g_ret_sts_error;

1169:
1170: EXCEPTION
1171: WHEN fnd_api.g_exc_error THEN
1172: rollback to fa_grp_copy_instance;
1173: x_return_status := fnd_api.g_ret_sts_error;
1174: x_error_message := dump_error_stack;
1175: WHEN others THEN
1176: rollback to fa_grp_copy_instance;
1177: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1177: x_return_status := fnd_api.g_ret_sts_unexp_error;

1173: x_return_status := fnd_api.g_ret_sts_error;
1174: x_error_message := dump_error_stack;
1175: WHEN others THEN
1176: rollback to fa_grp_copy_instance;
1177: x_return_status := fnd_api.g_ret_sts_unexp_error;
1178: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
1179: fnd_message.set_token('API_NAME','csi_fa_instance_grp.copy_item_instance');
1180: fnd_message.set_token('SQL_ERROR',SQLERRM);
1181: fnd_msg_pub.add;

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

1203: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1204:
1205: g_ia_ind binary_integer := 0;
1206:
1207: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1208: l_msg_count number;
1209: l_msg_data varchar2(2000);
1210:
1211: l_error_message varchar2(2000);

Line 1214: x_return_status := fnd_api.g_ret_sts_success;

1210:
1211: l_error_message varchar2(2000);
1212:
1213: BEGIN
1214: x_return_status := fnd_api.g_ret_sts_success;
1215:
1216: debug('associate_item_isntance');
1217:
1218: IF p_instance_tbl.COUNT > 0 THEN

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

1227: l_instance_asset_tbl(g_ia_ind).fa_location_id := p_fixed_asset_rec.asset_location_id;
1228: l_instance_asset_tbl(g_ia_ind).asset_quantity := p_instance_tbl(inst_ind).quantity;
1229: l_instance_asset_tbl(g_ia_ind).update_status := 'IN_SERVICE';
1230:
1231: IF nvl(p_fixed_asset_rec.asset_location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
1232: OR
1233: nvl(p_fixed_asset_rec.asset_quantity, fnd_api.g_miss_num) = fnd_api.g_miss_num
1234: OR
1235: nvl(p_fixed_asset_rec.book_type_code, fnd_api.g_miss_char) = fnd_api.g_miss_char

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

1229: l_instance_asset_tbl(g_ia_ind).update_status := 'IN_SERVICE';
1230:
1231: IF nvl(p_fixed_asset_rec.asset_location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
1232: OR
1233: nvl(p_fixed_asset_rec.asset_quantity, fnd_api.g_miss_num) = fnd_api.g_miss_num
1234: OR
1235: nvl(p_fixed_asset_rec.book_type_code, fnd_api.g_miss_char) = fnd_api.g_miss_char
1236: THEN
1237:

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

1231: IF nvl(p_fixed_asset_rec.asset_location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
1232: OR
1233: nvl(p_fixed_asset_rec.asset_quantity, fnd_api.g_miss_num) = fnd_api.g_miss_num
1234: OR
1235: nvl(p_fixed_asset_rec.book_type_code, fnd_api.g_miss_char) = fnd_api.g_miss_char
1236: THEN
1237:
1238: derive_fa_missing_values(
1239: p_instance_rec => p_instance_tbl(inst_ind),

Line 1246: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1242: x_fa_quantity => l_fa_quantity,
1243: x_fa_book_type_code => l_fa_book_type_code,
1244: x_return_status => l_return_status);
1245:
1246: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1247: RAISE fnd_api.g_exc_error;
1248: END IF;
1249:
1250: debug('location_id :'||l_fa_location_id);

Line 1247: RAISE fnd_api.g_exc_error;

1243: x_fa_book_type_code => l_fa_book_type_code,
1244: x_return_status => l_return_status);
1245:
1246: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1247: RAISE fnd_api.g_exc_error;
1248: END IF;
1249:
1250: debug('location_id :'||l_fa_location_id);
1251:

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

1248: END IF;
1249:
1250: debug('location_id :'||l_fa_location_id);
1251:
1252: IF nvl(p_fixed_asset_rec.asset_location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
1253: l_instance_asset_tbl(g_ia_ind).fa_location_id := l_fa_location_id;
1254: END IF;
1255:
1256: IF nvl(p_fixed_asset_rec.asset_quantity, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

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

1252: IF nvl(p_fixed_asset_rec.asset_location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
1253: l_instance_asset_tbl(g_ia_ind).fa_location_id := l_fa_location_id;
1254: END IF;
1255:
1256: IF nvl(p_fixed_asset_rec.asset_quantity, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
1257: l_instance_asset_tbl(g_ia_ind).asset_quantity := l_fa_quantity;
1258: END IF;
1259:
1260: l_instance_asset_tbl(g_ia_ind).fa_book_type_code := l_fa_book_type_code;

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

1259:
1260: l_instance_asset_tbl(g_ia_ind).fa_book_type_code := l_fa_book_type_code;
1261: l_instance_asset_tbl(g_ia_ind).fa_sync_flag := p_fixed_asset_rec.fa_sync_flag;
1262: l_instance_asset_tbl(g_ia_ind).fa_sync_validation_reqd :=
1263: nvl(p_fixed_asset_rec.fa_sync_validation_reqd, fnd_api.g_false);
1264:
1265: END IF;
1266:
1267: END LOOP;

Line 1274: p_commit => fnd_api.g_false,

1270: IF l_instance_asset_tbl.COUNT > 0 THEN
1271:
1272: csi_transactions_pvt.create_transaction(
1273: p_api_version => 1.0,
1274: p_commit => fnd_api.g_false,
1275: p_init_msg_list => fnd_api.g_true,
1276: p_validation_level => fnd_api.g_valid_level_full,
1277: p_success_if_exists_flag => 'Y',
1278: p_transaction_rec => px_csi_txn_rec,

Line 1275: p_init_msg_list => fnd_api.g_true,

1271:
1272: csi_transactions_pvt.create_transaction(
1273: p_api_version => 1.0,
1274: p_commit => fnd_api.g_false,
1275: p_init_msg_list => fnd_api.g_true,
1276: p_validation_level => fnd_api.g_valid_level_full,
1277: p_success_if_exists_flag => 'Y',
1278: p_transaction_rec => px_csi_txn_rec,
1279: x_return_status => l_return_status,

Line 1276: p_validation_level => fnd_api.g_valid_level_full,

1272: csi_transactions_pvt.create_transaction(
1273: p_api_version => 1.0,
1274: p_commit => fnd_api.g_false,
1275: p_init_msg_list => fnd_api.g_true,
1276: p_validation_level => fnd_api.g_valid_level_full,
1277: p_success_if_exists_flag => 'Y',
1278: p_transaction_rec => px_csi_txn_rec,
1279: x_return_status => l_return_status,
1280: x_msg_count => l_msg_count,

Line 1283: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1279: x_return_status => l_return_status,
1280: x_msg_count => l_msg_count,
1281: x_msg_data => l_msg_data);
1282:
1283: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1284: RAISE fnd_api.g_exc_error;
1285: END IF;
1286:
1287: create_instance_assets(

Line 1284: RAISE fnd_api.g_exc_error;

1280: x_msg_count => l_msg_count,
1281: x_msg_data => l_msg_data);
1282:
1283: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1284: RAISE fnd_api.g_exc_error;
1285: END IF;
1286:
1287: create_instance_assets(
1288: px_instance_asset_tbl => l_instance_asset_tbl,

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

1289: px_csi_txn_rec => px_csi_txn_rec,
1290: x_return_status => l_return_status,
1291: x_error_message => l_error_message);
1292:
1293: IF l_return_status IN (fnd_api.g_ret_sts_success, 'W') THEN
1294: x_return_status := l_return_status;
1295: x_error_message := l_error_message;
1296: ELSE
1297: RAISE fnd_api.g_exc_error;

Line 1297: RAISE fnd_api.g_exc_error;

1293: IF l_return_status IN (fnd_api.g_ret_sts_success, 'W') THEN
1294: x_return_status := l_return_status;
1295: x_error_message := l_error_message;
1296: ELSE
1297: RAISE fnd_api.g_exc_error;
1298: END IF;
1299:
1300: END IF;
1301:

Line 1303: WHEN fnd_api.g_exc_error THEN

1299:
1300: END IF;
1301:
1302: EXCEPTION
1303: WHEN fnd_api.g_exc_error THEN
1304: x_return_status := fnd_api.g_ret_sts_error;
1305: x_error_message := dump_error_stack;
1306: WHEN others THEN
1307: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1304: x_return_status := fnd_api.g_ret_sts_error;

1300: END IF;
1301:
1302: EXCEPTION
1303: WHEN fnd_api.g_exc_error THEN
1304: x_return_status := fnd_api.g_ret_sts_error;
1305: x_error_message := dump_error_stack;
1306: WHEN others THEN
1307: x_return_status := fnd_api.g_ret_sts_unexp_error;
1308: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');

Line 1307: x_return_status := fnd_api.g_ret_sts_unexp_error;

1303: WHEN fnd_api.g_exc_error THEN
1304: x_return_status := fnd_api.g_ret_sts_error;
1305: x_error_message := dump_error_stack;
1306: WHEN others THEN
1307: x_return_status := fnd_api.g_ret_sts_unexp_error;
1308: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
1309: fnd_message.set_token('API_NAME','csi_fa_instance_grp.associate_item_instance');
1310: fnd_message.set_token('SQL_ERROR',SQLERRM);
1311: fnd_msg_pub.add;

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

1325: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1326: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1327: l_warning_flag varchar2(1) := 'N';
1328:
1329: l_return_status varchar2(2000) := fnd_api.g_ret_sts_success;
1330: l_msg_count number;
1331: l_msg_data varchar2(2000);
1332:
1333: BEGIN

Line 1335: x_return_status := fnd_api.g_ret_sts_success;

1331: l_msg_data varchar2(2000);
1332:
1333: BEGIN
1334:
1335: x_return_status := fnd_api.g_ret_sts_success;
1336: IF p_instance_asset_tbl.count > 0 THEN
1337:
1338: csi_transactions_pvt.create_transaction(
1339: p_api_version => 1.0,

Line 1340: p_commit => fnd_api.g_false,

1336: IF p_instance_asset_tbl.count > 0 THEN
1337:
1338: csi_transactions_pvt.create_transaction(
1339: p_api_version => 1.0,
1340: p_commit => fnd_api.g_false,
1341: p_init_msg_list => fnd_api.g_true,
1342: p_validation_level => fnd_api.g_valid_level_full,
1343: p_success_if_exists_flag => 'Y',
1344: p_transaction_rec => px_csi_txn_rec,

Line 1341: p_init_msg_list => fnd_api.g_true,

1337:
1338: csi_transactions_pvt.create_transaction(
1339: p_api_version => 1.0,
1340: p_commit => fnd_api.g_false,
1341: p_init_msg_list => fnd_api.g_true,
1342: p_validation_level => fnd_api.g_valid_level_full,
1343: p_success_if_exists_flag => 'Y',
1344: p_transaction_rec => px_csi_txn_rec,
1345: x_return_status => l_return_status,

Line 1342: p_validation_level => fnd_api.g_valid_level_full,

1338: csi_transactions_pvt.create_transaction(
1339: p_api_version => 1.0,
1340: p_commit => fnd_api.g_false,
1341: p_init_msg_list => fnd_api.g_true,
1342: p_validation_level => fnd_api.g_valid_level_full,
1343: p_success_if_exists_flag => 'Y',
1344: p_transaction_rec => px_csi_txn_rec,
1345: x_return_status => l_return_status,
1346: x_msg_count => l_msg_count,

Line 1349: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1345: x_return_status => l_return_status,
1346: x_msg_count => l_msg_count,
1347: x_msg_data => l_msg_data);
1348:
1349: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1350: RAISE fnd_api.g_exc_error;
1351: END IF;
1352:
1353: FOR l_ind IN p_instance_asset_tbl.FIRST .. p_instance_asset_tbl.LAST

Line 1350: RAISE fnd_api.g_exc_error;

1346: x_msg_count => l_msg_count,
1347: x_msg_data => l_msg_data);
1348:
1349: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1350: RAISE fnd_api.g_exc_error;
1351: END IF;
1352:
1353: FOR l_ind IN p_instance_asset_tbl.FIRST .. p_instance_asset_tbl.LAST
1354: LOOP

Line 1360: p_commit => fnd_api.g_false,

1356: l_instance_asset_rec := p_instance_asset_tbl(l_ind);
1357:
1358: csi_asset_pvt.update_instance_asset (
1359: p_api_version => 1.0,
1360: p_commit => fnd_api.g_false,
1361: p_init_msg_list => fnd_api.g_true,
1362: p_validation_level => fnd_api.g_valid_level_full,
1363: p_instance_asset_rec => l_instance_asset_rec,
1364: p_txn_rec => px_csi_txn_rec,

Line 1361: p_init_msg_list => fnd_api.g_true,

1357:
1358: csi_asset_pvt.update_instance_asset (
1359: p_api_version => 1.0,
1360: p_commit => fnd_api.g_false,
1361: p_init_msg_list => fnd_api.g_true,
1362: p_validation_level => fnd_api.g_valid_level_full,
1363: p_instance_asset_rec => l_instance_asset_rec,
1364: p_txn_rec => px_csi_txn_rec,
1365: x_return_status => l_return_status,

Line 1362: p_validation_level => fnd_api.g_valid_level_full,

1358: csi_asset_pvt.update_instance_asset (
1359: p_api_version => 1.0,
1360: p_commit => fnd_api.g_false,
1361: p_init_msg_list => fnd_api.g_true,
1362: p_validation_level => fnd_api.g_valid_level_full,
1363: p_instance_asset_rec => l_instance_asset_rec,
1364: p_txn_rec => px_csi_txn_rec,
1365: x_return_status => l_return_status,
1366: x_msg_count => l_msg_count,

Line 1373: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1369: p_asset_count_rec => l_asset_count_rec,
1370: p_asset_id_tbl => l_asset_id_tbl,
1371: p_asset_loc_tbl => l_asset_loc_tbl);
1372:
1373: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1374: RAISE fnd_api.g_exc_error;
1375: END IF;
1376:
1377: IF l_instance_asset_rec.fa_sync_flag = 'N' THEN

Line 1374: RAISE fnd_api.g_exc_error;

1370: p_asset_id_tbl => l_asset_id_tbl,
1371: p_asset_loc_tbl => l_asset_loc_tbl);
1372:
1373: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1374: RAISE fnd_api.g_exc_error;
1375: END IF;
1376:
1377: IF l_instance_asset_rec.fa_sync_flag = 'N' THEN
1378: l_warning_flag := 'Y';

Line 1393: WHEN fnd_api.g_exc_error THEN

1389: x_error_message := dump_error_stack;
1390: END IF;
1391:
1392: EXCEPTION
1393: WHEN fnd_api.g_exc_error THEN
1394: x_return_status := fnd_api.g_ret_sts_error;
1395: x_error_message := dump_error_stack;
1396: WHEN others THEN
1397: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1394: x_return_status := fnd_api.g_ret_sts_error;

1390: END IF;
1391:
1392: EXCEPTION
1393: WHEN fnd_api.g_exc_error THEN
1394: x_return_status := fnd_api.g_ret_sts_error;
1395: x_error_message := dump_error_stack;
1396: WHEN others THEN
1397: x_return_status := fnd_api.g_ret_sts_unexp_error;
1398: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');

Line 1397: x_return_status := fnd_api.g_ret_sts_unexp_error;

1393: WHEN fnd_api.g_exc_error THEN
1394: x_return_status := fnd_api.g_ret_sts_error;
1395: x_error_message := dump_error_stack;
1396: WHEN others THEN
1397: x_return_status := fnd_api.g_ret_sts_unexp_error;
1398: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
1399: fnd_message.set_token('API_NAME','csi_fa_instance_grp.update_asset_association');
1400: fnd_message.set_token('SQL_ERROR',SQLERRM);
1401: fnd_msg_pub.add;

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

1418:
1419: l_asset_quantity number;
1420: l_asset_location_id number;
1421:
1422: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1423: l_msg_count number;
1424: l_msg_data varchar2(2000);
1425:
1426: l_warning_flag varchar2(1) := 'N';

Line 1431: x_return_status := fnd_api.g_ret_sts_success;

1427:
1428:
1429: BEGIN
1430:
1431: x_return_status := fnd_api.g_ret_sts_success;
1432:
1433: debug('create_instance_assets');
1434:
1435: savepoint create_instance_assets;

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

1438:
1439: FOR ia_ind IN px_instance_asset_tbl.FIRST .. px_instance_asset_tbl.LAST
1440: LOOP
1441:
1442: IF nvl(px_instance_asset_tbl(ia_ind).fa_location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
1443: OR
1444: nvl(px_instance_asset_tbl(ia_ind).asset_quantity, fnd_api.g_miss_num) = fnd_api.g_miss_num
1445: THEN
1446:

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

1440: LOOP
1441:
1442: IF nvl(px_instance_asset_tbl(ia_ind).fa_location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
1443: OR
1444: nvl(px_instance_asset_tbl(ia_ind).asset_quantity, fnd_api.g_miss_num) = fnd_api.g_miss_num
1445: THEN
1446:
1447: l_instance_rec.instance_id := px_instance_asset_tbl(ia_ind).instance_id;
1448: l_fixed_asset_rec.asset_id := px_instance_asset_tbl(ia_ind).fa_asset_id;

Line 1460: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1456: x_fa_quantity => l_asset_quantity,
1457: x_fa_book_type_code => px_instance_asset_tbl(ia_ind).fa_book_type_code,
1458: x_return_status => l_return_status);
1459:
1460: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1461: RAISE fnd_api.g_exc_error;
1462: END IF;
1463:
1464: IF nvl(px_instance_asset_tbl(ia_ind).fa_location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num

Line 1461: RAISE fnd_api.g_exc_error;

1457: x_fa_book_type_code => px_instance_asset_tbl(ia_ind).fa_book_type_code,
1458: x_return_status => l_return_status);
1459:
1460: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1461: RAISE fnd_api.g_exc_error;
1462: END IF;
1463:
1464: IF nvl(px_instance_asset_tbl(ia_ind).fa_location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
1465: THEN

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

1460: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1461: RAISE fnd_api.g_exc_error;
1462: END IF;
1463:
1464: IF nvl(px_instance_asset_tbl(ia_ind).fa_location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
1465: THEN
1466: px_instance_asset_tbl(ia_ind).fa_location_id := l_asset_location_id;
1467: END IF;
1468:

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

1465: THEN
1466: px_instance_asset_tbl(ia_ind).fa_location_id := l_asset_location_id;
1467: END IF;
1468:
1469: IF nvl(px_instance_asset_tbl(ia_ind).asset_quantity, fnd_api.g_miss_num) = fnd_api.g_miss_num
1470: THEN
1471: px_instance_asset_tbl(ia_ind).asset_quantity := l_asset_quantity;
1472: END IF;
1473:

Line 1480: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1476: validate_inst_asset(
1477: px_inst_asset_rec => px_instance_asset_tbl(ia_ind),
1478: x_return_status => l_return_status);
1479:
1480: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1481: RAISE fnd_api.g_exc_error;
1482: END IF;
1483:
1484: IF nvl(px_instance_asset_tbl(ia_ind).instance_asset_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

Line 1481: RAISE fnd_api.g_exc_error;

1477: px_inst_asset_rec => px_instance_asset_tbl(ia_ind),
1478: x_return_status => l_return_status);
1479:
1480: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1481: RAISE fnd_api.g_exc_error;
1482: END IF;
1483:
1484: IF nvl(px_instance_asset_tbl(ia_ind).instance_asset_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
1485:

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

1480: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1481: RAISE fnd_api.g_exc_error;
1482: END IF;
1483:
1484: IF nvl(px_instance_asset_tbl(ia_ind).instance_asset_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
1485:
1486: csi_asset_pvt.create_instance_asset(
1487: p_api_version => 1.0,
1488: p_commit => fnd_api.g_false,

Line 1488: p_commit => fnd_api.g_false,

1484: IF nvl(px_instance_asset_tbl(ia_ind).instance_asset_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
1485:
1486: csi_asset_pvt.create_instance_asset(
1487: p_api_version => 1.0,
1488: p_commit => fnd_api.g_false,
1489: p_init_msg_list => fnd_api.g_true,
1490: p_validation_level => fnd_api.g_valid_level_full,
1491: p_instance_asset_rec => px_instance_asset_tbl(ia_ind),
1492: p_txn_rec => px_csi_txn_rec,

Line 1489: p_init_msg_list => fnd_api.g_true,

1485:
1486: csi_asset_pvt.create_instance_asset(
1487: p_api_version => 1.0,
1488: p_commit => fnd_api.g_false,
1489: p_init_msg_list => fnd_api.g_true,
1490: p_validation_level => fnd_api.g_valid_level_full,
1491: p_instance_asset_rec => px_instance_asset_tbl(ia_ind),
1492: p_txn_rec => px_csi_txn_rec,
1493: p_lookup_tbl => l_lookup_tbl,

Line 1490: p_validation_level => fnd_api.g_valid_level_full,

1486: csi_asset_pvt.create_instance_asset(
1487: p_api_version => 1.0,
1488: p_commit => fnd_api.g_false,
1489: p_init_msg_list => fnd_api.g_true,
1490: p_validation_level => fnd_api.g_valid_level_full,
1491: p_instance_asset_rec => px_instance_asset_tbl(ia_ind),
1492: p_txn_rec => px_csi_txn_rec,
1493: p_lookup_tbl => l_lookup_tbl,
1494: p_asset_count_rec => l_asset_count_rec,

Line 1501: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1497: x_return_status => l_return_status,
1498: x_msg_count => l_msg_count,
1499: x_msg_data => l_msg_data);
1500:
1501: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1502: RAISE fnd_api.g_exc_error;
1503: END IF;
1504:
1505: ELSE

Line 1502: RAISE fnd_api.g_exc_error;

1498: x_msg_count => l_msg_count,
1499: x_msg_data => l_msg_data);
1500:
1501: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1502: RAISE fnd_api.g_exc_error;
1503: END IF;
1504:
1505: ELSE
1506: null;

Line 1523: x_return_status := fnd_api.g_ret_sts_success;

1519: fnd_msg_pub.add;
1520: x_return_status := 'W';
1521: x_error_message := dump_error_stack;
1522: ELSE
1523: x_return_status := fnd_api.g_ret_sts_success;
1524: END IF;
1525:
1526: EXCEPTION
1527: WHEN fnd_api.g_exc_error THEN

Line 1527: WHEN fnd_api.g_exc_error THEN

1523: x_return_status := fnd_api.g_ret_sts_success;
1524: END IF;
1525:
1526: EXCEPTION
1527: WHEN fnd_api.g_exc_error THEN
1528: rollback to create_instance_assets;
1529: x_return_status := fnd_api.g_ret_sts_error;
1530: x_error_message := dump_error_stack;
1531: WHEN others THEN

Line 1529: x_return_status := fnd_api.g_ret_sts_error;

1525:
1526: EXCEPTION
1527: WHEN fnd_api.g_exc_error THEN
1528: rollback to create_instance_assets;
1529: x_return_status := fnd_api.g_ret_sts_error;
1530: x_error_message := dump_error_stack;
1531: WHEN others THEN
1532: rollback to create_instance_assets;
1533: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 1533: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1529: x_return_status := fnd_api.g_ret_sts_error;
1530: x_error_message := dump_error_stack;
1531: WHEN others THEN
1532: rollback to create_instance_assets;
1533: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1534: x_error_message := substr(sqlerrm, 1, 2000);
1535: END create_instance_assets;
1536:
1537: END csi_fa_instance_grp;