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