[Home] [Help]
414: csi_t_gen_utility_pvt.dump_instance_query_rec(p_instance_query_rec => l_instance_query_rec);
415:
416: debug('Before Get Item Instance');
417:
418: csi_item_instance_pub.get_item_instances(l_api_version,
419: l_commit,
420: l_init_msg_list,
421: l_validation_level,
422: l_instance_query_rec,
439:
440: -- Check for any errors and add them to the message stack to pass out to be put into the
441: -- error log table.
442: IF NOT l_return_status = l_fnd_success then
443: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
444: l_msg_index := 1;
445: WHILE l_msg_count > 0 loop
446: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
447: l_msg_index := l_msg_index + 1;
488: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
489:
490: debug('Before Create of source Instance');
491:
492: csi_item_instance_pub.create_item_instance(l_api_version,
493: l_commit,
494: l_init_msg_list,
495: l_validation_level,
496: l_new_src_instance_rec,
510:
511: -- Check for any errors and add them to the message stack to pass out to be put into the
512: -- error log table.
513: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
514: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
515: l_msg_index := 1;
516: WHILE l_msg_count > 0 loop
517: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
518: l_msg_index := l_msg_index + 1;
554: l_update_src_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
555:
556: debug('Instance Status Id: '||l_update_src_instance_rec.instance_status_id);
557:
558: csi_item_instance_pub.update_item_instance(l_api_version,
559: l_commit,
560: l_init_msg_list,
561: l_validation_level,
562: l_update_src_instance_rec,
580:
581: -- Check for any errors and add them to the message stack to pass out to be put into the
582: -- error log table.
583: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
584: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
585: l_msg_index := 1;
586: WHILE l_msg_count > 0 loop
587: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
588: l_msg_index := l_msg_index + 1;
658: csi_t_gen_utility_pvt.dump_instance_query_rec(p_instance_query_rec => l_dest_instance_query_rec);
659:
660: debug('Before Dest Get Item Instance - 31');
661:
662: csi_item_instance_pub.get_item_instances(l_api_version,
663: l_commit,
664: l_init_msg_list,
665: l_validation_level,
666: l_dest_instance_query_rec,
683:
684: -- Check for any errors and add them to the message stack to pass out to be put into the
685: -- error log table.
686: IF NOT l_return_status = l_fnd_success then
687: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
688: l_msg_index := 1;
689: WHILE l_msg_count > 0 loop
690: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
691: l_msg_index := l_msg_index + 1;
735: debug('HR Location: '||l_mtl_item_tbl(j).hr_location_id);
736: debug('Serial Number: '||l_mtl_item_tbl(j).serial_number);
737: debug('Mfg Flag: '||l_mfg_serial_number_flag);
738:
739: csi_item_instance_pub.create_item_instance(l_api_version,
740: l_commit,
741: l_init_msg_list,
742: l_validation_level,
743: l_new_dest_instance_rec,
756:
757: -- Check for any errors and add them to the message stack to pass out to be put into the
758: -- error log table.
759: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
760: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
761: l_msg_index := 1;
762: WHILE l_msg_count > 0 loop
763: l_error_message := fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
764: l_msg_index := l_msg_index + 1;
820:
821: debug('Before Update Item Instance - 34');
822: debug('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
823:
824: csi_item_instance_pub.update_item_instance(l_api_version,
825: l_commit,
826: l_init_msg_list,
827: l_validation_level,
828: l_update_dest_instance_rec,
845: debug('l_upd_error_instance_id is: '||l_upd_error_instance_id);
846:
847: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
848: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
849: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
850: l_msg_index := 1;
851: WHILE l_msg_count > 0 loop
852: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
853: l_msg_index := l_msg_index + 1;
895: l_asset_assignment_tbl.delete;
896:
897: debug('Before Update of Serialized Item Instance');
898:
899: csi_item_instance_pub.update_item_instance(l_api_version,
900: l_commit,
901: l_init_msg_list,
902: l_validation_level,
903: l_update_src_instance_rec,
922:
923: -- Check for any errors and add them to the message stack to pass out to be put into the
924: -- error log table.
925: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
926: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
927: l_msg_index := 1;
928: WHILE l_msg_count > 0 loop
929: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
930: l_msg_index := l_msg_index + 1;