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

Line 166: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

162:
163:
164:
165: BEGIN
166: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
167:
168: debug('set_fa_sync_flag');
169:
170: OPEN inst_sync_over_cur;

Line 261: x_return_status := fnd_api.G_RET_STS_ERROR ;

257: END IF ; --px_instance_asset_rec.fa_location_id <> l_mapped_fa_location_id ;
258: END IF;
259: EXCEPTION
260: WHEN OTHERS THEN
261: x_return_status := fnd_api.G_RET_STS_ERROR ;
262: END set_fa_sync_flag;
263:
264: /*----------------------------------------------------------*/
265: /* Procedure name: Construct_asset_from_hist */

Line 636: AND (p_inst_asset_query_rec.instance_asset_id <> FND_API.G_MISS_NUM)) THEN

632: )IS
633:
634: BEGIN
635: IF( (p_inst_asset_query_rec.instance_asset_id IS NOT NULL)
636: AND (p_inst_asset_query_rec.instance_asset_id <> FND_API.G_MISS_NUM)) THEN
637: DBMS_SQL.BIND_VARIABLE(p_get_asset_cursor_id, ':instance_asset_id', p_inst_asset_query_rec.instance_asset_id);
638: END IF;
639:
640: IF( (p_inst_asset_query_rec.instance_id IS NOT NULL)

Line 641: AND (p_inst_asset_query_rec.instance_id <> FND_API.G_MISS_NUM)) THEN

637: DBMS_SQL.BIND_VARIABLE(p_get_asset_cursor_id, ':instance_asset_id', p_inst_asset_query_rec.instance_asset_id);
638: END IF;
639:
640: IF( (p_inst_asset_query_rec.instance_id IS NOT NULL)
641: AND (p_inst_asset_query_rec.instance_id <> FND_API.G_MISS_NUM)) THEN
642: DBMS_SQL.BIND_VARIABLE(p_get_asset_cursor_id, ':instance_id', p_inst_asset_query_rec.instance_id);
643: END IF;
644:
645: IF( (p_inst_asset_query_rec.fa_asset_id IS NOT NULL)

Line 646: AND (p_inst_asset_query_rec.fa_asset_id <> FND_API.G_MISS_NUM)) THEN

642: DBMS_SQL.BIND_VARIABLE(p_get_asset_cursor_id, ':instance_id', p_inst_asset_query_rec.instance_id);
643: END IF;
644:
645: IF( (p_inst_asset_query_rec.fa_asset_id IS NOT NULL)
646: AND (p_inst_asset_query_rec.fa_asset_id <> FND_API.G_MISS_NUM)) THEN
647: DBMS_SQL.BIND_VARIABLE(p_get_asset_cursor_id, ':fa_asset_id', p_inst_asset_query_rec.fa_asset_id);
648: END IF;
649:
650: IF( (p_inst_asset_query_rec.fa_book_type_code IS NOT NULL)

Line 651: AND (p_inst_asset_query_rec.fa_book_type_code <> FND_API.G_MISS_CHAR)) THEN

647: DBMS_SQL.BIND_VARIABLE(p_get_asset_cursor_id, ':fa_asset_id', p_inst_asset_query_rec.fa_asset_id);
648: END IF;
649:
650: IF( (p_inst_asset_query_rec.fa_book_type_code IS NOT NULL)
651: AND (p_inst_asset_query_rec.fa_book_type_code <> FND_API.G_MISS_CHAR)) THEN
652: DBMS_SQL.BIND_VARIABLE(p_get_asset_cursor_id, ':fa_book_type_code', p_inst_asset_query_rec.fa_book_type_code);
653: END IF;
654:
655: IF( (p_inst_asset_query_rec.fa_location_id IS NOT NULL)

Line 656: AND (p_inst_asset_query_rec.fa_location_id <> FND_API.G_MISS_NUM)) THEN

652: DBMS_SQL.BIND_VARIABLE(p_get_asset_cursor_id, ':fa_book_type_code', p_inst_asset_query_rec.fa_book_type_code);
653: END IF;
654:
655: IF( (p_inst_asset_query_rec.fa_location_id IS NOT NULL)
656: AND (p_inst_asset_query_rec.fa_location_id <> FND_API.G_MISS_NUM)) THEN
657: DBMS_SQL.BIND_VARIABLE(p_get_asset_cursor_id, ':fa_location_id', p_inst_asset_query_rec.fa_location_id);
658: END IF;
659: IF( (p_inst_asset_query_rec.update_status IS NOT NULL)
660: AND (p_inst_asset_query_rec.update_status <> FND_API.G_MISS_CHAR)) THEN

Line 660: AND (p_inst_asset_query_rec.update_status <> FND_API.G_MISS_CHAR)) THEN

656: AND (p_inst_asset_query_rec.fa_location_id <> FND_API.G_MISS_NUM)) THEN
657: DBMS_SQL.BIND_VARIABLE(p_get_asset_cursor_id, ':fa_location_id', p_inst_asset_query_rec.fa_location_id);
658: END IF;
659: IF( (p_inst_asset_query_rec.update_status IS NOT NULL)
660: AND (p_inst_asset_query_rec.update_status <> FND_API.G_MISS_CHAR)) THEN
661: DBMS_SQL.BIND_VARIABLE(p_get_asset_cursor_id, ':update_status', p_inst_asset_query_rec.update_status);
662: END IF;
663:
664: END Bind_asset_variable;

Line 683: ( p_inst_asset_query_rec.instance_asset_id <> FND_API.G_MISS_NUM)) THEN

679: -- Assign null at the start
680: x_where_clause := '';
681:
682: IF (( p_inst_asset_query_rec.instance_asset_id IS NOT NULL) AND
683: ( p_inst_asset_query_rec.instance_asset_id <> FND_API.G_MISS_NUM)) THEN
684: x_where_clause := ' instance_asset_id = :instance_asset_id ';
685: ELSIF ( p_inst_asset_query_rec.instance_asset_id IS NULL) THEN
686: x_where_clause := ' instance_asset_id IS NULL ';
687: END IF;

Line 690: (p_inst_asset_query_rec.instance_id <> FND_API.G_MISS_NUM)) THEN

686: x_where_clause := ' instance_asset_id IS NULL ';
687: END IF;
688:
689: IF ((p_inst_asset_query_rec.instance_id IS NOT NULL) AND
690: (p_inst_asset_query_rec.instance_id <> FND_API.G_MISS_NUM)) THEN
691: IF x_where_clause IS NULL THEN
692: x_where_clause := ' instance_id = :instance_id ';
693: ELSE
694: x_where_clause := x_where_clause||' AND '||' instance_id = :instance_id ';

Line 705: (p_inst_asset_query_rec.fa_asset_id <> FND_API.G_MISS_NUM)) THEN

701: END IF;
702: END IF;
703:
704: IF ((p_inst_asset_query_rec.fa_asset_id IS NOT NULL) AND
705: (p_inst_asset_query_rec.fa_asset_id <> FND_API.G_MISS_NUM)) THEN
706: IF x_where_clause IS NULL THEN
707: x_where_clause := ' fa_asset_id = :fa_asset_id ';
708: ELSE
709: x_where_clause := x_where_clause||' AND '||' fa_asset_id = :fa_asset_id ';

Line 719: (p_inst_asset_query_rec.fa_book_type_code <> FND_API.G_MISS_CHAR)) THEN

715: x_where_clause := x_where_clause||' AND '||' fa_asset_id IS NULL ';
716: END IF;
717: END IF ;
718: IF ((p_inst_asset_query_rec.fa_book_type_code IS NOT NULL) AND
719: (p_inst_asset_query_rec.fa_book_type_code <> FND_API.G_MISS_CHAR)) THEN
720: IF x_where_clause IS NULL THEN
721: x_where_clause := ' fa_book_type_code = :fa_book_type_code ';
722: ELSE
723: x_where_clause := x_where_clause||' AND '||

Line 736: (p_inst_asset_query_rec.fa_location_id <> FND_API.G_MISS_NUM)) THEN

732: END IF;
733: END IF;
734:
735: IF ((p_inst_asset_query_rec.fa_location_id IS NOT NULL) AND
736: (p_inst_asset_query_rec.fa_location_id <> FND_API.G_MISS_NUM)) THEN
737: IF x_where_clause IS NULL THEN
738: x_where_clause := ' fa_location_id = :fa_location_id ';
739: ELSE
740: x_where_clause := x_where_clause||' AND '||

Line 753: (p_inst_asset_query_rec.update_status <> FND_API.G_MISS_CHAR)) THEN

749: END IF;
750: END IF;
751:
752: IF ((p_inst_asset_query_rec.update_status IS NOT NULL) AND
753: (p_inst_asset_query_rec.update_status <> FND_API.G_MISS_CHAR)) THEN
754: IF x_where_clause IS NULL THEN
755: x_where_clause := ' update_status = :update_status ';
756: ELSE
757: x_where_clause := x_where_clause||' AND '||

Line 812: IF fnd_api.to_boolean(p_commit)

808:
809: BEGIN
810: -- Standard Start of API savepoint
811: /*
812: IF fnd_api.to_boolean(p_commit)
813: THEN
814: SAVEPOINT get_instance_asset_pvt;
815: END IF;
816: */

Line 818: IF NOT FND_API.Compatible_API_Call (l_api_version ,

814: SAVEPOINT get_instance_asset_pvt;
815: END IF;
816: */
817: -- Standard call to check for call compatibility.
818: IF NOT FND_API.Compatible_API_Call (l_api_version ,
819: p_api_version ,
820: l_api_name ,
821: G_PKG_NAME )
822: THEN

Line 823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

819: p_api_version ,
820: l_api_name ,
821: G_PKG_NAME )
822: THEN
823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
824: END IF;
825:
826: -- Initialize message list if p_init_msg_list is set to TRUE.
827: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 827: IF FND_API.to_Boolean( p_init_msg_list ) THEN

823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
824: END IF;
825:
826: -- Initialize message list if p_init_msg_list is set to TRUE.
827: IF FND_API.to_Boolean( p_init_msg_list ) THEN
828: FND_MSG_PUB.initialize;
829: END IF;
830:
831: -- Initialize API return status to success

Line 832: x_return_status := FND_API.G_RET_STS_SUCCESS;

828: FND_MSG_PUB.initialize;
829: END IF;
830:
831: -- Initialize API return status to success
832: x_return_status := FND_API.G_RET_STS_SUCCESS;
833:
834:
835: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
836: l_CSI_DEBUG_LEVEL:=fnd_profile.value('CSI_DEBUG_LEVEL');

Line 849: IF (p_instance_asset_query_rec.instance_asset_id = FND_API.G_MISS_NUM)

845: csi_gen_utility_pvt.dump_asset_query_rec(p_instance_asset_query_rec);
846: END IF;
847:
848: -- check if atleast one query parameters are passed
849: IF (p_instance_asset_query_rec.instance_asset_id = FND_API.G_MISS_NUM)
850: AND (p_instance_asset_query_rec.instance_id = FND_API.G_MISS_NUM)
851: AND (p_instance_asset_query_rec.fa_asset_id = FND_API.G_MISS_NUM)
852: AND (p_instance_asset_query_rec.fa_book_type_code = FND_API.G_MISS_CHAR)
853: AND (p_instance_asset_query_rec.fa_location_id = FND_API.G_MISS_NUM)

Line 850: AND (p_instance_asset_query_rec.instance_id = FND_API.G_MISS_NUM)

846: END IF;
847:
848: -- check if atleast one query parameters are passed
849: IF (p_instance_asset_query_rec.instance_asset_id = FND_API.G_MISS_NUM)
850: AND (p_instance_asset_query_rec.instance_id = FND_API.G_MISS_NUM)
851: AND (p_instance_asset_query_rec.fa_asset_id = FND_API.G_MISS_NUM)
852: AND (p_instance_asset_query_rec.fa_book_type_code = FND_API.G_MISS_CHAR)
853: AND (p_instance_asset_query_rec.fa_location_id = FND_API.G_MISS_NUM)
854: AND (p_instance_asset_query_rec.update_status = FND_API.G_MISS_CHAR) THEN

Line 851: AND (p_instance_asset_query_rec.fa_asset_id = FND_API.G_MISS_NUM)

847:
848: -- check if atleast one query parameters are passed
849: IF (p_instance_asset_query_rec.instance_asset_id = FND_API.G_MISS_NUM)
850: AND (p_instance_asset_query_rec.instance_id = FND_API.G_MISS_NUM)
851: AND (p_instance_asset_query_rec.fa_asset_id = FND_API.G_MISS_NUM)
852: AND (p_instance_asset_query_rec.fa_book_type_code = FND_API.G_MISS_CHAR)
853: AND (p_instance_asset_query_rec.fa_location_id = FND_API.G_MISS_NUM)
854: AND (p_instance_asset_query_rec.update_status = FND_API.G_MISS_CHAR) THEN
855:

Line 852: AND (p_instance_asset_query_rec.fa_book_type_code = FND_API.G_MISS_CHAR)

848: -- check if atleast one query parameters are passed
849: IF (p_instance_asset_query_rec.instance_asset_id = FND_API.G_MISS_NUM)
850: AND (p_instance_asset_query_rec.instance_id = FND_API.G_MISS_NUM)
851: AND (p_instance_asset_query_rec.fa_asset_id = FND_API.G_MISS_NUM)
852: AND (p_instance_asset_query_rec.fa_book_type_code = FND_API.G_MISS_CHAR)
853: AND (p_instance_asset_query_rec.fa_location_id = FND_API.G_MISS_NUM)
854: AND (p_instance_asset_query_rec.update_status = FND_API.G_MISS_CHAR) THEN
855:
856: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');

Line 853: AND (p_instance_asset_query_rec.fa_location_id = FND_API.G_MISS_NUM)

849: IF (p_instance_asset_query_rec.instance_asset_id = FND_API.G_MISS_NUM)
850: AND (p_instance_asset_query_rec.instance_id = FND_API.G_MISS_NUM)
851: AND (p_instance_asset_query_rec.fa_asset_id = FND_API.G_MISS_NUM)
852: AND (p_instance_asset_query_rec.fa_book_type_code = FND_API.G_MISS_CHAR)
853: AND (p_instance_asset_query_rec.fa_location_id = FND_API.G_MISS_NUM)
854: AND (p_instance_asset_query_rec.update_status = FND_API.G_MISS_CHAR) THEN
855:
856: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');
857: FND_MSG_PUB.ADD;

Line 854: AND (p_instance_asset_query_rec.update_status = FND_API.G_MISS_CHAR) THEN

850: AND (p_instance_asset_query_rec.instance_id = FND_API.G_MISS_NUM)
851: AND (p_instance_asset_query_rec.fa_asset_id = FND_API.G_MISS_NUM)
852: AND (p_instance_asset_query_rec.fa_book_type_code = FND_API.G_MISS_CHAR)
853: AND (p_instance_asset_query_rec.fa_location_id = FND_API.G_MISS_NUM)
854: AND (p_instance_asset_query_rec.update_status = FND_API.G_MISS_CHAR) THEN
855:
856: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');
857: FND_MSG_PUB.ADD;
858: RAISE FND_API.G_EXC_ERROR;

Line 858: RAISE FND_API.G_EXC_ERROR;

854: AND (p_instance_asset_query_rec.update_status = FND_API.G_MISS_CHAR) THEN
855:
856: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');
857: FND_MSG_PUB.ADD;
858: RAISE FND_API.G_EXC_ERROR;
859: END IF;
860:
861: -- Generate the where clause
862: Gen_Asset_Where_Clause

Line 894: IF (p_time_stamp IS NOT NULL) AND (p_time_stamp <> FND_API.G_MISS_DATE) THEN

890:
891: -- Close the cursor
892: DBMS_SQL.CLOSE_CURSOR(l_get_inst_asset_cursor_id);
893:
894: IF (p_time_stamp IS NOT NULL) AND (p_time_stamp <> FND_API.G_MISS_DATE) THEN
895: IF p_time_stamp <= sysdate THEN
896: Construct_asset_from_hist(x_instance_asset_tbl, p_time_stamp);
897: ELSE
898: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_HIST_PARAMS');

Line 900: RAISE FND_API.G_EXC_ERROR;

896: Construct_asset_from_hist(x_instance_asset_tbl, p_time_stamp);
897: ELSE
898: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_HIST_PARAMS');
899: FND_MSG_PUB.ADD;
900: RAISE FND_API.G_EXC_ERROR;
901: END IF;
902: END IF;
903:
904: -- Resolve the foreign key columns if p_resolve_id_columns is true

Line 905: IF p_resolve_id_columns = fnd_api.g_true THEN

901: END IF;
902: END IF;
903:
904: -- Resolve the foreign key columns if p_resolve_id_columns is true
905: IF p_resolve_id_columns = fnd_api.g_true THEN
906: IF x_instance_asset_tbl.count > 0 THEN
907: l_instance_asset_tbl := x_instance_asset_tbl;
908: Resolve_id_columns(l_instance_asset_tbl);
909:

Line 918: IF FND_API.To_Boolean( p_commit ) THEN

914: -- End of API body
915:
916: -- Standard check of p_commit.
917: /*
918: IF FND_API.To_Boolean( p_commit ) THEN
919: COMMIT WORK;
920: END IF;
921: */
922:

Line 937: WHEN FND_API.G_EXC_ERROR THEN

933: (p_count => x_msg_count ,
934: p_data => x_msg_data );
935:
936: EXCEPTION
937: WHEN FND_API.G_EXC_ERROR THEN
938: /*
939: IF fnd_api.to_boolean(p_commit)
940: THEN
941: ROLLBACK TO get_instance_asset_pvt;

Line 939: IF fnd_api.to_boolean(p_commit)

935:
936: EXCEPTION
937: WHEN FND_API.G_EXC_ERROR THEN
938: /*
939: IF fnd_api.to_boolean(p_commit)
940: THEN
941: ROLLBACK TO get_instance_asset_pvt;
942: END IF;
943: */

Line 944: x_return_status := FND_API.G_RET_STS_ERROR ;

940: THEN
941: ROLLBACK TO get_instance_asset_pvt;
942: END IF;
943: */
944: x_return_status := FND_API.G_RET_STS_ERROR ;
945: FND_MSG_PUB.Count_And_Get
946: ( p_count => x_msg_count,
947: p_data => x_msg_data);
948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

944: x_return_status := FND_API.G_RET_STS_ERROR ;
945: FND_MSG_PUB.Count_And_Get
946: ( p_count => x_msg_count,
947: p_data => x_msg_data);
948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
949: /*
950: IF fnd_api.to_boolean(p_commit)
951: THEN
952: ROLLBACK TO get_instance_asset_pvt;

Line 950: IF fnd_api.to_boolean(p_commit)

946: ( p_count => x_msg_count,
947: p_data => x_msg_data);
948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
949: /*
950: IF fnd_api.to_boolean(p_commit)
951: THEN
952: ROLLBACK TO get_instance_asset_pvt;
953: END IF;
954: */

Line 955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

951: THEN
952: ROLLBACK TO get_instance_asset_pvt;
953: END IF;
954: */
955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
956: FND_MSG_PUB.Count_And_Get
957: ( p_count => x_msg_count,
958: p_data => x_msg_data);
959: WHEN OTHERS THEN

Line 961: IF fnd_api.to_boolean(p_commit)

957: ( p_count => x_msg_count,
958: p_data => x_msg_data);
959: WHEN OTHERS THEN
960: /*
961: IF fnd_api.to_boolean(p_commit)
962: THEN
963: ROLLBACK TO get_instance_asset_pvt;
964: END IF;
965: */

Line 969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

965: */
966: IF DBMS_SQL.IS_OPEN(l_get_inst_asset_cursor_id) THEN
967: DBMS_SQL.CLOSE_CURSOR(l_get_inst_asset_cursor_id);
968: END IF;
969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
970: IF FND_MSG_PUB.Check_Msg_Level
971: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
972: THEN
973: FND_MSG_PUB.Add_Exc_Msg

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

1017: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1018: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1019: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1020:
1021: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1022: l_error_message varchar2(2000);
1023:
1024: BEGIN
1025: -- Standard Start of API savepoint

Line 1026: IF fnd_api.to_boolean(p_commit) THEN

1022: l_error_message varchar2(2000);
1023:
1024: BEGIN
1025: -- Standard Start of API savepoint
1026: IF fnd_api.to_boolean(p_commit) THEN
1027: SAVEPOINT create_instance_asset_pvt;
1028: END IF;
1029:
1030: -- Standard call to check for call compatibility.

Line 1031: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

1027: SAVEPOINT create_instance_asset_pvt;
1028: END IF;
1029:
1030: -- Standard call to check for call compatibility.
1031: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1032: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1033: END IF;
1034:
1035: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1032: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1028: END IF;
1029:
1030: -- Standard call to check for call compatibility.
1031: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1032: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1033: END IF;
1034:
1035: -- Initialize message list if p_init_msg_list is set to TRUE.
1036: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1036: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1032: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1033: END IF;
1034:
1035: -- Initialize message list if p_init_msg_list is set to TRUE.
1036: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1037: FND_MSG_PUB.initialize;
1038: END IF;
1039:
1040: -- Initialize API return status to success

Line 1041: x_return_status := FND_API.G_RET_STS_SUCCESS;

1037: FND_MSG_PUB.initialize;
1038: END IF;
1039:
1040: -- Initialize API return status to success
1041: x_return_status := FND_API.G_RET_STS_SUCCESS;
1042:
1043: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
1044: l_CSI_DEBUG_LEVEL:=fnd_profile.value('CSI_DEBUG_LEVEL');
1045:

Line 1057: IF p_asset_count_rec.asset_count IS NULL OR p_asset_count_rec.asset_count = FND_API.G_MISS_NUM

1053: -- Start API body
1054: --
1055: -- Initialize the Asset count
1056: --
1057: IF p_asset_count_rec.asset_count IS NULL OR p_asset_count_rec.asset_count = FND_API.G_MISS_NUM
1058: THEN
1059: p_asset_count_rec.asset_count := 0;
1060: END IF;
1061: --

Line 1062: IF p_asset_count_rec.lookup_count IS NULL OR p_asset_count_rec.lookup_count = FND_API.G_MISS_NUM

1058: THEN
1059: p_asset_count_rec.asset_count := 0;
1060: END IF;
1061: --
1062: IF p_asset_count_rec.lookup_count IS NULL OR p_asset_count_rec.lookup_count = FND_API.G_MISS_NUM
1063: THEN
1064: p_asset_count_rec.lookup_count := 0;
1065: END IF;
1066: --

Line 1067: IF p_asset_count_rec.loc_count IS NULL OR p_asset_count_rec.loc_count = FND_API.G_MISS_NUM THEN

1063: THEN
1064: p_asset_count_rec.lookup_count := 0;
1065: END IF;
1066: --
1067: IF p_asset_count_rec.loc_count IS NULL OR p_asset_count_rec.loc_count = FND_API.G_MISS_NUM THEN
1068: p_asset_count_rec.loc_count := 0;
1069: END IF;
1070: --
1071: -- Check if all the required parameters are passed

Line 1077: IF nvl(p_instance_asset_rec.fa_mass_addition_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

1073: ( p_instance_asset_rec.INSTANCE_ID ,
1074: ' p_instance_asset_rec.INSTANCE_ID ',
1075: l_api_name );
1076:
1077: IF nvl(p_instance_asset_rec.fa_mass_addition_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
1078: CSI_Asset_vld_pvt.Check_Reqd_Param(
1079: p_instance_asset_rec.FA_ASSET_ID,
1080: 'p_instance_asset_rec.FA_ASSET_ID ',
1081: l_api_name);

Line 1095: IF ( (p_called_from_grp <> FND_API.G_TRUE) AND

1091: ' p_instance_asset_rec.FA_LOCATION_ID',
1092: l_api_name );
1093: -- Added by sk for bug 2232880.
1094: l_record_found := FALSE;
1095: IF ( (p_called_from_grp <> FND_API.G_TRUE) AND
1096: (p_instance_asset_rec.instance_asset_id IS NULL OR
1097: p_instance_asset_rec.instance_asset_id = fnd_api.g_miss_num) )
1098: THEN
1099: BEGIN

Line 1097: p_instance_asset_rec.instance_asset_id = fnd_api.g_miss_num) )

1093: -- Added by sk for bug 2232880.
1094: l_record_found := FALSE;
1095: IF ( (p_called_from_grp <> FND_API.G_TRUE) AND
1096: (p_instance_asset_rec.instance_asset_id IS NULL OR
1097: p_instance_asset_rec.instance_asset_id = fnd_api.g_miss_num) )
1098: THEN
1099: BEGIN
1100: SELECT instance_asset_id,
1101: object_version_number

Line 1119: IF p_instance_asset_rec.active_end_date = fnd_api.g_miss_date THEN

1115: END;
1116: END IF;
1117:
1118: IF l_record_found THEN
1119: IF p_instance_asset_rec.active_end_date = fnd_api.g_miss_date THEN
1120: p_instance_asset_rec.active_end_date := NULL;
1121: END IF;
1122:
1123: update_instance_asset(

Line 1125: ,p_commit => fnd_api.g_false

1121: END IF;
1122:
1123: update_instance_asset(
1124: p_api_version => p_api_version
1125: ,p_commit => fnd_api.g_false
1126: ,p_init_msg_list => p_init_msg_list
1127: ,p_validation_level => p_validation_level
1128: ,p_instance_asset_rec => p_instance_asset_rec
1129: ,p_txn_rec => p_txn_rec

Line 1139: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1135: ,p_asset_id_tbl => l_asset_id_tbl
1136: ,p_asset_loc_tbl => l_asset_loc_tbl);
1137:
1138:
1139: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1140: l_msg_index := 1;
1141: l_msg_count := x_msg_count;
1142: WHILE l_msg_count > 0 LOOP
1143: x_msg_data := FND_MSG_PUB.GET ( l_msg_index, FND_API.G_FALSE );

Line 1143: x_msg_data := FND_MSG_PUB.GET ( l_msg_index, FND_API.G_FALSE );

1139: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1140: l_msg_index := 1;
1141: l_msg_count := x_msg_count;
1142: WHILE l_msg_count > 0 LOOP
1143: x_msg_data := FND_MSG_PUB.GET ( l_msg_index, FND_API.G_FALSE );
1144: debug( ' Failed Pvt:update_instance_asset..');
1145: debug('message data = '||x_msg_data);
1146: l_msg_index := l_msg_index + 1;
1147: l_msg_count := l_msg_count - 1;

Line 1149: RAISE FND_API.G_EXC_ERROR;

1145: debug('message data = '||x_msg_data);
1146: l_msg_index := l_msg_index + 1;
1147: l_msg_count := l_msg_count - 1;
1148: END LOOP;
1149: RAISE FND_API.G_EXC_ERROR;
1150: END IF;
1151:
1152: ELSE
1153: -- End addition by sk for bug 2232880.

Line 1166: IF p_called_from_grp <> FND_API.G_TRUE THEN

1162: ' p_instance_asset_rec.UPDATE_STATUS',
1163: l_api_name );
1164:
1165: -- Validate the Instance id exists in csi_item_instances
1166: IF p_called_from_grp <> FND_API.G_TRUE THEN
1167: IF NOT( CSI_Asset_vld_pvt.Is_InstanceID_Valid
1168: (p_instance_asset_rec.INSTANCE_ID
1169: ,p_instance_asset_rec.check_for_instance_expiry
1170: )) THEN

Line 1171: RAISE FND_API.G_EXC_ERROR;

1167: IF NOT( CSI_Asset_vld_pvt.Is_InstanceID_Valid
1168: (p_instance_asset_rec.INSTANCE_ID
1169: ,p_instance_asset_rec.check_for_instance_expiry
1170: )) THEN
1171: RAISE FND_API.G_EXC_ERROR;
1172: END IF;
1173: END IF;
1174:
1175: IF p_instance_asset_rec.INSTANCE_ASSET_ID is NULL OR

Line 1176: p_instance_asset_rec.INSTANCE_ASSET_ID = FND_API.G_MISS_NUM THEN

1172: END IF;
1173: END IF;
1174:
1175: IF p_instance_asset_rec.INSTANCE_ASSET_ID is NULL OR
1176: p_instance_asset_rec.INSTANCE_ASSET_ID = FND_API.G_MISS_NUM THEN
1177:
1178: -- If the instance_asset id passed is null then generate from sequence
1179: -- and check if the value exists . If exists then generate
1180: -- again from the sequence till we get a value that does not exist

Line 1195: RAISE FND_API.G_EXC_ERROR;

1191: -- Validate the instance asset id if exist then raise CSI_API_INVALID_PRIMARY_KEY error
1192: IF CSI_Asset_vld_pvt.Is_Inst_assetID_exists
1193: (p_instance_asset_rec.INSTANCE_ASSET_ID,
1194: TRUE ) THEN
1195: RAISE FND_API.G_EXC_ERROR;
1196: END IF;
1197: END IF;
1198:
1199: --validation for the asset update status

Line 1203: (p_instance_asset_rec.update_status <> FND_API.G_MISS_CHAR)) THEN

1199: --validation for the asset update status
1200: l_valid_flag := 'Y';
1201: l_exists_flag := 'N';
1202: IF ((p_instance_asset_rec.update_status IS NOT NULL) AND
1203: (p_instance_asset_rec.update_status <> FND_API.G_MISS_CHAR)) THEN
1204: IF p_lookup_tbl.count > 0 THEN
1205: For lookup_count in p_lookup_tbl.FIRST .. p_lookup_tbl.LAST
1206: LOOP
1207: IF p_lookup_tbl(lookup_count).lookup_code = p_instance_asset_rec.update_status THEN

Line 1218: RAISE fnd_api.g_exc_error;

1214: IF l_valid_flag <> 'Y' then
1215: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_UPDATE_STATUS');
1216: FND_MESSAGE.SET_TOKEN('UPDATE_STATUS',p_instance_asset_rec.update_status);
1217: FND_MSG_PUB.Add;
1218: RAISE fnd_api.g_exc_error;
1219: END IF;
1220: END IF;
1221: --
1222: IF l_exists_flag <> 'Y' THEN

Line 1229: RAISE FND_API.G_EXC_ERROR;

1225: p_instance_asset_rec.update_status;
1226: IF NOT( CSI_Asset_vld_pvt.Is_Update_Status_Exists
1227: (p_instance_asset_rec.UPDATE_STATUS)) THEN
1228: p_lookup_tbl(p_asset_count_rec.lookup_count).valid_flag := 'N';
1229: RAISE FND_API.G_EXC_ERROR;
1230: ELSE
1231: p_lookup_tbl(p_asset_count_rec.lookup_count).valid_flag := 'Y';
1232: END IF;
1233: END IF;

Line 1240: RAISE FND_API.G_EXC_ERROR;

1236:
1237: -- Validate the quantity > 0
1238: IF NOT( CSI_Asset_vld_pvt.Is_Quantity_Valid
1239: (p_instance_asset_rec.ASSET_QUANTITY)) THEN
1240: RAISE FND_API.G_EXC_ERROR;
1241: END IF;
1242:
1243: --check for the exists of asset_id and asset book_type_code combination in the fa_books table
1244: l_valid_flag := 'Y';

Line 1247: p_instance_asset_rec.fa_asset_id <> FND_API.G_MISS_NUM) AND

1243: --check for the exists of asset_id and asset book_type_code combination in the fa_books table
1244: l_valid_flag := 'Y';
1245: l_exists_flag := 'N';
1246: IF ((p_instance_asset_rec.fa_asset_id is not null AND
1247: p_instance_asset_rec.fa_asset_id <> FND_API.G_MISS_NUM) AND
1248: (p_instance_asset_rec.fa_book_type_code is not null AND
1249: p_instance_asset_rec.fa_book_type_code <> FND_API.G_MISS_CHAR)) THEN
1250: IF p_asset_id_tbl.count > 0 then
1251: For asset_count in p_asset_id_tbl.FIRST .. p_asset_id_tbl.LAST

Line 1249: p_instance_asset_rec.fa_book_type_code <> FND_API.G_MISS_CHAR)) THEN

1245: l_exists_flag := 'N';
1246: IF ((p_instance_asset_rec.fa_asset_id is not null AND
1247: p_instance_asset_rec.fa_asset_id <> FND_API.G_MISS_NUM) AND
1248: (p_instance_asset_rec.fa_book_type_code is not null AND
1249: p_instance_asset_rec.fa_book_type_code <> FND_API.G_MISS_CHAR)) THEN
1250: IF p_asset_id_tbl.count > 0 then
1251: For asset_count in p_asset_id_tbl.FIRST .. p_asset_id_tbl.LAST
1252: LOOP
1253: IF p_asset_id_tbl(asset_count).asset_id = p_instance_asset_rec.fa_asset_id AND

Line 1267: RAISE fnd_api.g_exc_error;

1263: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ASSET_COMB');
1264: FND_MESSAGE.SET_TOKEN('ASSET_COMBINATION',
1265: p_instance_asset_rec.fa_asset_id||'-'||p_instance_asset_rec.fa_book_type_code);
1266: FND_MSG_PUB.Add;
1267: RAISE fnd_api.g_exc_error;
1268: END IF;
1269: END IF;
1270: --
1271: IF l_exists_flag <> 'Y' THEN

Line 1280: RAISE fnd_api.g_exc_error;

1276: IF NOT( CSI_Asset_vld_pvt.Is_Asset_Comb_Valid
1277: (p_instance_asset_rec.FA_ASSET_ID ,
1278: p_instance_asset_rec.FA_BOOK_TYPE_CODE )) THEN
1279: p_asset_id_tbl(p_asset_count_rec.asset_count).valid_flag := 'N';
1280: RAISE fnd_api.g_exc_error;
1281: ELSE
1282: p_asset_id_tbl(p_asset_count_rec.asset_count).valid_flag := 'Y';
1283: END IF;
1284: END IF;

Line 1287: IF ((p_instance_asset_rec.active_start_date = FND_API.G_MISS_DATE) OR

1283: END IF;
1284: END IF;
1285: END IF;
1286: --
1287: IF ((p_instance_asset_rec.active_start_date = FND_API.G_MISS_DATE) OR
1288: (p_instance_asset_rec.active_start_date IS NULL))
1289: THEN
1290: p_instance_asset_rec.active_start_date := SYSDATE;
1291: END IF;

Line 1293: IF (p_instance_asset_rec.active_end_date = FND_API.G_MISS_DATE) THEN

1289: THEN
1290: p_instance_asset_rec.active_start_date := SYSDATE;
1291: END IF;
1292:
1293: IF (p_instance_asset_rec.active_end_date = FND_API.G_MISS_DATE) THEN
1294: p_instance_asset_rec.active_end_date := NULL;
1295: END IF;
1296: --
1297: IF p_called_from_grp <> FND_API.G_TRUE THEN

Line 1297: IF p_called_from_grp <> FND_API.G_TRUE THEN

1293: IF (p_instance_asset_rec.active_end_date = FND_API.G_MISS_DATE) THEN
1294: p_instance_asset_rec.active_end_date := NULL;
1295: END IF;
1296: --
1297: IF p_called_from_grp <> FND_API.G_TRUE THEN
1298: -- Validation for the active start date passed
1299: IF NOT(CSI_Asset_vld_pvt.Is_StartDate_Valid(
1300: p_instance_asset_rec.ACTIVE_START_DATE,
1301: p_instance_asset_rec.ACTIVE_END_DATE ,

Line 1305: RAISE FND_API.G_EXC_ERROR;

1301: p_instance_asset_rec.ACTIVE_END_DATE ,
1302: p_instance_asset_rec.INSTANCE_ID,
1303: p_instance_asset_rec.check_for_instance_expiry ))
1304: THEN
1305: RAISE FND_API.G_EXC_ERROR;
1306: END IF;
1307: END IF;
1308: --
1309: IF p_called_from_grp <> FND_API.G_TRUE THEN

Line 1309: IF p_called_from_grp <> FND_API.G_TRUE THEN

1305: RAISE FND_API.G_EXC_ERROR;
1306: END IF;
1307: END IF;
1308: --
1309: IF p_called_from_grp <> FND_API.G_TRUE THEN
1310: -- Verify if the active_end_date is valid
1311: IF ((p_instance_asset_rec.ACTIVE_END_DATE is NOT NULL) AND
1312: ( p_instance_asset_rec.ACTIVE_END_DATE <> FND_API.G_MISS_DATE)) THEN
1313: IF NOT(CSI_Asset_vld_pvt.Is_EndDate_Valid(

Line 1312: ( p_instance_asset_rec.ACTIVE_END_DATE <> FND_API.G_MISS_DATE)) THEN

1308: --
1309: IF p_called_from_grp <> FND_API.G_TRUE THEN
1310: -- Verify if the active_end_date is valid
1311: IF ((p_instance_asset_rec.ACTIVE_END_DATE is NOT NULL) AND
1312: ( p_instance_asset_rec.ACTIVE_END_DATE <> FND_API.G_MISS_DATE)) THEN
1313: IF NOT(CSI_Asset_vld_pvt.Is_EndDate_Valid(
1314: p_instance_asset_rec.ACTIVE_START_DATE,
1315: p_instance_asset_rec.ACTIVE_END_DATE ,
1316: p_instance_asset_rec.INSTANCE_ID,

Line 1321: RAISE FND_API.G_EXC_ERROR;

1317: p_instance_asset_rec.INSTANCE_ASSET_ID,
1318: p_txn_rec.TRANSACTION_ID,
1319: p_instance_asset_rec.check_for_instance_expiry))
1320: THEN
1321: RAISE FND_API.G_EXC_ERROR;
1322: END IF;
1323: END IF;
1324: END IF;
1325:

Line 1326: IF nvl(p_instance_asset_rec.fa_asset_id, fnd_api.g_miss_num) = fnd_api.g_miss_num

1322: END IF;
1323: END IF;
1324: END IF;
1325:
1326: IF nvl(p_instance_asset_rec.fa_asset_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
1327: OR
1328: nvl(p_instance_asset_rec.fa_book_type_code, fnd_api.g_miss_char) = fnd_api.g_miss_char
1329: OR
1330: nvl(p_instance_asset_rec.fa_location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num

Line 1328: nvl(p_instance_asset_rec.fa_book_type_code, fnd_api.g_miss_char) = fnd_api.g_miss_char

1324: END IF;
1325:
1326: IF nvl(p_instance_asset_rec.fa_asset_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
1327: OR
1328: nvl(p_instance_asset_rec.fa_book_type_code, fnd_api.g_miss_char) = fnd_api.g_miss_char
1329: OR
1330: nvl(p_instance_asset_rec.fa_location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
1331: OR
1332: nvl(p_instance_asset_rec.asset_quantity, fnd_api.g_miss_num) = fnd_api.g_miss_num

Line 1330: nvl(p_instance_asset_rec.fa_location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num

1326: IF nvl(p_instance_asset_rec.fa_asset_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
1327: OR
1328: nvl(p_instance_asset_rec.fa_book_type_code, fnd_api.g_miss_char) = fnd_api.g_miss_char
1329: OR
1330: nvl(p_instance_asset_rec.fa_location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
1331: OR
1332: nvl(p_instance_asset_rec.asset_quantity, fnd_api.g_miss_num) = fnd_api.g_miss_num
1333: THEN
1334: p_instance_asset_rec.creation_complete_flag := 'N';

Line 1332: nvl(p_instance_asset_rec.asset_quantity, fnd_api.g_miss_num) = fnd_api.g_miss_num

1328: nvl(p_instance_asset_rec.fa_book_type_code, fnd_api.g_miss_char) = fnd_api.g_miss_char
1329: OR
1330: nvl(p_instance_asset_rec.fa_location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
1331: OR
1332: nvl(p_instance_asset_rec.asset_quantity, fnd_api.g_miss_num) = fnd_api.g_miss_num
1333: THEN
1334: p_instance_asset_rec.creation_complete_flag := 'N';
1335: ELSE
1336: p_instance_asset_rec.creation_complete_flag := 'Y';

Line 1340: IF p_called_from_grp <> FND_API.G_TRUE THEN

1336: p_instance_asset_rec.creation_complete_flag := 'Y';
1337: END IF;
1338: --
1339: -- Since Group API already makes a call to this routine, by-passing it.
1340: IF p_called_from_grp <> FND_API.G_TRUE THEN
1341: IF p_instance_asset_rec.fa_sync_validation_reqd = fnd_api.g_true THEN
1342: set_fa_sync_flag (
1343: px_instance_asset_rec => p_instance_asset_rec,
1344: x_return_status => l_return_status,

Line 1341: IF p_instance_asset_rec.fa_sync_validation_reqd = fnd_api.g_true THEN

1337: END IF;
1338: --
1339: -- Since Group API already makes a call to this routine, by-passing it.
1340: IF p_called_from_grp <> FND_API.G_TRUE THEN
1341: IF p_instance_asset_rec.fa_sync_validation_reqd = fnd_api.g_true THEN
1342: set_fa_sync_flag (
1343: px_instance_asset_rec => p_instance_asset_rec,
1344: x_return_status => l_return_status,
1345: x_error_msg => l_error_message);

Line 1346: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1342: set_fa_sync_flag (
1343: px_instance_asset_rec => p_instance_asset_rec,
1344: x_return_status => l_return_status,
1345: x_error_msg => l_error_message);
1346: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1347: RAISE fnd_api.g_exc_error;
1348: END IF;
1349: END IF;
1350: END IF; -- Called from grp check as GRP API already does the validation

Line 1347: RAISE fnd_api.g_exc_error;

1343: px_instance_asset_rec => p_instance_asset_rec,
1344: x_return_status => l_return_status,
1345: x_error_msg => l_error_message);
1346: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1347: RAISE fnd_api.g_exc_error;
1348: END IF;
1349: END IF;
1350: END IF; -- Called from grp check as GRP API already does the validation
1351: --

Line 1352: IF p_instance_asset_rec.fa_sync_validation_reqd = fnd_api.g_false AND

1348: END IF;
1349: END IF;
1350: END IF; -- Called from grp check as GRP API already does the validation
1351: --
1352: IF p_instance_asset_rec.fa_sync_validation_reqd = fnd_api.g_false AND
1353: nvl(p_instance_asset_rec.fa_sync_flag,'N') = 'Y' THEN
1354: --check for the existance of location_id in fa_locations table
1355: l_valid_flag := 'Y';
1356: l_exists_flag := 'N';

Line 1358: p_instance_asset_rec.fa_location_id <> FND_API.G_MISS_NUM THEN

1354: --check for the existance of location_id in fa_locations table
1355: l_valid_flag := 'Y';
1356: l_exists_flag := 'N';
1357: IF p_instance_asset_rec.fa_location_id is not null AND
1358: p_instance_asset_rec.fa_location_id <> FND_API.G_MISS_NUM THEN
1359: IF p_asset_loc_tbl.count > 0 then
1360: For loc_count in p_asset_loc_tbl.FIRST .. p_asset_loc_tbl.LAST
1361: LOOP
1362: IF p_asset_loc_tbl(loc_count).asset_loc_id = p_instance_asset_rec.fa_location_id THEN

Line 1373: RAISE fnd_api.g_exc_error;

1369: IF l_valid_flag <> 'Y' THEN
1370: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ASSET_LOCATION');
1371: FND_MESSAGE.SET_TOKEN('ASSET_LOCATION_ID',p_instance_asset_rec.fa_location_id);
1372: FND_MSG_PUB.Add;
1373: RAISE fnd_api.g_exc_error;
1374: END IF;
1375: END IF;
1376: --
1377: IF l_exists_flag <> 'Y' THEN

Line 1384: RAISE fnd_api.g_exc_error;

1380: p_instance_asset_rec.fa_location_id;
1381: IF NOT( CSI_Asset_vld_pvt.Is_Asset_Location_Valid (p_instance_asset_rec.FA_LOCATION_ID ))
1382: THEN
1383: p_asset_loc_tbl(p_asset_count_rec.loc_count).valid_flag := 'N';
1384: RAISE fnd_api.g_exc_error;
1385: ELSE
1386: p_asset_loc_tbl(p_asset_count_rec.loc_count).valid_flag := 'Y';
1387: END IF;
1388: END IF;

Line 1393: IF p_called_from_grp <> FND_API.G_TRUE THEN

1389: END IF;
1390: END IF;
1391:
1392: -- Call table handler to insert into csi_i_assets table
1393: IF p_called_from_grp <> FND_API.G_TRUE THEN
1394: CSI_I_ASSETS_PKG.Insert_Row (
1395: px_INSTANCE_ASSET_ID => p_instance_asset_rec.INSTANCE_ASSET_ID,
1396: p_INSTANCE_ID => p_instance_asset_rec.INSTANCE_ID,
1397: p_FA_ASSET_ID => p_instance_asset_rec.FA_ASSET_ID,

Line 1414: IF nvl(p_txn_rec.transaction_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

1410: p_OBJECT_VERSION_NUMBER => 1,
1411: p_ACTIVE_START_DATE => p_instance_asset_rec.ACTIVE_START_DATE,
1412: p_ACTIVE_END_DATE => p_instance_asset_rec.ACTIVE_END_DATE);
1413:
1414: IF nvl(p_txn_rec.transaction_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
1415: -- Call create_transaction to create txn log
1416: CSI_TRANSACTIONS_PVT.Create_transaction (
1417: p_api_version => p_api_version,
1418: p_commit => p_commit,

Line 1427: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1423: x_return_status => x_return_status,
1424: x_msg_count => x_msg_count,
1425: x_msg_data => x_msg_data);
1426:
1427: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1428: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_VALIDATE_TXN');
1429: FND_MESSAGE.SET_TOKEN('API_NAME',l_api_name);
1430: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',p_txn_rec.transaction_id );
1431: FND_MSG_PUB.Add;

Line 1432: RAISE fnd_api.g_exc_error;

1428: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_VALIDATE_TXN');
1429: FND_MESSAGE.SET_TOKEN('API_NAME',l_api_name);
1430: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',p_txn_rec.transaction_id );
1431: FND_MSG_PUB.Add;
1432: RAISE fnd_api.g_exc_error;
1433: END IF;
1434: END IF;
1435:
1436: -- Generate the instance asset history id from the sequence

Line 1486: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1482: x_return_status => x_return_status,
1483: x_msg_count => x_msg_count,
1484: x_msg_data => x_msg_data);
1485:
1486: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1487: RAISE fnd_api.g_exc_error;
1488: END IF;
1489:
1490: END IF; -- called from grp check

Line 1487: RAISE fnd_api.g_exc_error;

1483: x_msg_count => x_msg_count,
1484: x_msg_data => x_msg_data);
1485:
1486: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1487: RAISE fnd_api.g_exc_error;
1488: END IF;
1489:
1490: END IF; -- called from grp check
1491: END IF; -- Added by sk for bug 2232880

Line 1496: IF FND_API.To_Boolean( p_commit ) THEN

1492: --
1493: -- End of API body
1494:
1495: -- Standard check of p_commit.
1496: IF FND_API.To_Boolean( p_commit ) THEN
1497: COMMIT WORK;
1498: END IF;
1499:
1500: -- Standard call to get message count and if count is get message info.

Line 1506: WHEN fnd_api.g_exc_error THEN

1502:
1503: debug(' end of create_instance_asset.'||x_return_status);
1504:
1505: EXCEPTION
1506: WHEN fnd_api.g_exc_error THEN
1507: IF fnd_api.to_boolean(p_commit) THEN
1508: ROLLBACK TO create_instance_asset_pvt;
1509: END IF;
1510: x_return_status := fnd_api.g_ret_sts_error;

Line 1507: IF fnd_api.to_boolean(p_commit) THEN

1503: debug(' end of create_instance_asset.'||x_return_status);
1504:
1505: EXCEPTION
1506: WHEN fnd_api.g_exc_error THEN
1507: IF fnd_api.to_boolean(p_commit) THEN
1508: ROLLBACK TO create_instance_asset_pvt;
1509: END IF;
1510: x_return_status := fnd_api.g_ret_sts_error;
1511: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

Line 1510: x_return_status := fnd_api.g_ret_sts_error;

1506: WHEN fnd_api.g_exc_error THEN
1507: IF fnd_api.to_boolean(p_commit) THEN
1508: ROLLBACK TO create_instance_asset_pvt;
1509: END IF;
1510: x_return_status := fnd_api.g_ret_sts_error;
1511: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1512: l_error_message := csi_gen_utility_pvt.dump_error_stack;
1513: debug('error(E): '||l_error_message);
1514: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1514: WHEN fnd_api.g_exc_unexpected_error THEN

1510: x_return_status := fnd_api.g_ret_sts_error;
1511: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1512: l_error_message := csi_gen_utility_pvt.dump_error_stack;
1513: debug('error(E): '||l_error_message);
1514: WHEN fnd_api.g_exc_unexpected_error THEN
1515: IF fnd_api.to_boolean(p_commit) THEN
1516: ROLLBACK TO create_instance_asset_pvt;
1517: END IF;
1518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1515: IF fnd_api.to_boolean(p_commit) THEN

1511: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1512: l_error_message := csi_gen_utility_pvt.dump_error_stack;
1513: debug('error(E): '||l_error_message);
1514: WHEN fnd_api.g_exc_unexpected_error THEN
1515: IF fnd_api.to_boolean(p_commit) THEN
1516: ROLLBACK TO create_instance_asset_pvt;
1517: END IF;
1518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1519: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

Line 1518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1514: WHEN fnd_api.g_exc_unexpected_error THEN
1515: IF fnd_api.to_boolean(p_commit) THEN
1516: ROLLBACK TO create_instance_asset_pvt;
1517: END IF;
1518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1519: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1520: l_error_message := csi_gen_utility_pvt.dump_error_stack;
1521: debug('error(U): '||l_error_message);
1522: WHEN OTHERS THEN

Line 1523: IF fnd_api.to_boolean(p_commit) THEN

1519: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1520: l_error_message := csi_gen_utility_pvt.dump_error_stack;
1521: debug('error(U): '||l_error_message);
1522: WHEN OTHERS THEN
1523: IF fnd_api.to_boolean(p_commit) THEN
1524: ROLLBACK TO create_instance_asset_pvt;
1525: END IF;
1526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1527: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

Line 1526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1522: WHEN OTHERS THEN
1523: IF fnd_api.to_boolean(p_commit) THEN
1524: ROLLBACK TO create_instance_asset_pvt;
1525: END IF;
1526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1527: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1528: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1529: l_error_message := csi_gen_utility_pvt.dump_error_stack;
1530: debug('error(0): '||l_error_message);

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

1559: l_exists_flag VARCHAR2(1);
1560: l_valid_flag VARCHAR2(1);
1561: l_ins_asset_hist_rec csi_datastructures_pub.ins_asset_history_rec;
1562: l_creation_complete_flag varchar2(1);
1563: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1564: l_error_message varchar2(2000);
1565:
1566: CURSOR get_curr_asset_rec (p_inst_asset_id IN NUMBER) IS
1567: SELECT instance_asset_id,

Line 1599: IF fnd_api.to_boolean(p_commit) THEN

1595:
1596: BEGIN
1597:
1598: -- Standard Start of API savepoint
1599: IF fnd_api.to_boolean(p_commit) THEN
1600: SAVEPOINT update_instance_asset_pvt;
1601: END IF;
1602:
1603: -- Standard call to check for call compatibility.

Line 1604: IF NOT FND_API.Compatible_API_Call (l_api_version , p_api_version , l_api_name , G_PKG_NAME) THEN

1600: SAVEPOINT update_instance_asset_pvt;
1601: END IF;
1602:
1603: -- Standard call to check for call compatibility.
1604: IF NOT FND_API.Compatible_API_Call (l_api_version , p_api_version , l_api_name , G_PKG_NAME) THEN
1605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1606: END IF;
1607:
1608: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1601: END IF;
1602:
1603: -- Standard call to check for call compatibility.
1604: IF NOT FND_API.Compatible_API_Call (l_api_version , p_api_version , l_api_name , G_PKG_NAME) THEN
1605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1606: END IF;
1607:
1608: -- Initialize message list if p_init_msg_list is set to TRUE.
1609: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1609: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1606: END IF;
1607:
1608: -- Initialize message list if p_init_msg_list is set to TRUE.
1609: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1610: FND_MSG_PUB.initialize;
1611: END IF;
1612:
1613: -- Initialize API return status to success

Line 1614: x_return_status := FND_API.G_RET_STS_SUCCESS;

1610: FND_MSG_PUB.initialize;
1611: END IF;
1612:
1613: -- Initialize API return status to success
1614: x_return_status := FND_API.G_RET_STS_SUCCESS;
1615:
1616: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
1617: l_CSI_DEBUG_LEVEL:=fnd_profile.value('CSI_DEBUG_LEVEL');
1618:

Line 1630: IF nvl(p_txn_rec.transaction_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

1626: IF (l_CSI_DEBUG_LEVEL > 1) THEN
1627: debug( 'update_instance_asset:'||p_api_version||'-'||p_commit||'-'||p_init_msg_list||'-'||p_validation_level);
1628: -- Dump the records in the log file
1629: csi_gen_utility_pvt.dump_instance_asset_rec(p_instance_asset_rec);
1630: IF nvl(p_txn_rec.transaction_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
1631: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
1632: END IF;
1633: END IF;
1634:

Line 1637: p_asset_count_rec.asset_count = FND_API.G_MISS_NUM THEN

1633: END IF;
1634:
1635: -- Initialize the Asset count
1636: IF p_asset_count_rec.asset_count IS NULL OR
1637: p_asset_count_rec.asset_count = FND_API.G_MISS_NUM THEN
1638: p_asset_count_rec.asset_count := 0;
1639: END IF;
1640: --
1641: IF p_asset_count_rec.lookup_count IS NULL OR

Line 1642: p_asset_count_rec.lookup_count = FND_API.G_MISS_NUM THEN

1638: p_asset_count_rec.asset_count := 0;
1639: END IF;
1640: --
1641: IF p_asset_count_rec.lookup_count IS NULL OR
1642: p_asset_count_rec.lookup_count = FND_API.G_MISS_NUM THEN
1643: p_asset_count_rec.lookup_count := 0;
1644: END IF;
1645: --
1646: IF p_asset_count_rec.loc_count IS NULL OR

Line 1647: p_asset_count_rec.loc_count = FND_API.G_MISS_NUM THEN

1643: p_asset_count_rec.lookup_count := 0;
1644: END IF;
1645: --
1646: IF p_asset_count_rec.loc_count IS NULL OR
1647: p_asset_count_rec.loc_count = FND_API.G_MISS_NUM THEN
1648: p_asset_count_rec.loc_count := 0;
1649: END IF;
1650:
1651: -- Check if all the required parameters are passed

Line 1663: RAISE FND_API.G_EXC_ERROR;

1659: FETCH get_curr_asset_rec INTO l_curr_asset_rec;
1660: IF (l_curr_asset_rec.object_version_number <> p_instance_asset_rec.OBJECT_VERSION_NUMBER) THEN
1661: FND_MESSAGE.Set_Name('CSI', 'CSI_API_OBJ_VER_MISMATCH');
1662: FND_MSG_PUB.ADD;
1663: RAISE FND_API.G_EXC_ERROR;
1664: END IF;
1665:
1666: IF get_curr_asset_rec%NOTFOUND THEN
1667: FND_MESSAGE.Set_Name('CSI', 'CSI_API_RECORD_LOCKED');

Line 1669: RAISE FND_API.G_EXC_ERROR;

1665:
1666: IF get_curr_asset_rec%NOTFOUND THEN
1667: FND_MESSAGE.Set_Name('CSI', 'CSI_API_RECORD_LOCKED');
1668: FND_MSG_PUB.ADD;
1669: RAISE FND_API.G_EXC_ERROR;
1670: END IF;
1671: CLOSE get_curr_asset_rec;
1672: --
1673: p_instance_asset_rec.instance_id := l_curr_asset_rec.instance_id;

Line 1677: RAISE FND_API.G_EXC_ERROR;

1673: p_instance_asset_rec.instance_id := l_curr_asset_rec.instance_id;
1674: --
1675: -- Validate the Instance asset id exists in csi_i_assets
1676: IF NOT( CSI_Asset_vld_pvt.Is_Inst_asset_id_valid (p_instance_asset_rec.INSTANCE_ASSET_ID)) THEN
1677: RAISE FND_API.G_EXC_ERROR;
1678: END IF;
1679:
1680: -- Validate the Instance id exists in csi_item_instances
1681: IF ((p_instance_asset_rec.INSTANCE_ID IS NOT NULL)

Line 1682: AND (p_instance_asset_rec.INSTANCE_ID <> FND_API.G_MISS_NUM)) THEN

1678: END IF;
1679:
1680: -- Validate the Instance id exists in csi_item_instances
1681: IF ((p_instance_asset_rec.INSTANCE_ID IS NOT NULL)
1682: AND (p_instance_asset_rec.INSTANCE_ID <> FND_API.G_MISS_NUM)) THEN
1683: IF NOT( CSI_Asset_vld_pvt.Is_InstanceID_Valid
1684: (p_instance_asset_rec.INSTANCE_ID
1685: ,p_instance_asset_rec.check_for_instance_expiry
1686: )) THEN

Line 1687: RAISE FND_API.G_EXC_ERROR;

1683: IF NOT( CSI_Asset_vld_pvt.Is_InstanceID_Valid
1684: (p_instance_asset_rec.INSTANCE_ID
1685: ,p_instance_asset_rec.check_for_instance_expiry
1686: )) THEN
1687: RAISE FND_API.G_EXC_ERROR;
1688: END IF;
1689: END IF;
1690:
1691: --validation for the asset update status

Line 1695: (p_instance_asset_rec.update_status <> FND_API.G_MISS_CHAR)) THEN

1691: --validation for the asset update status
1692: l_valid_flag := 'Y';
1693: l_exists_flag := 'N';
1694: IF ((p_instance_asset_rec.update_status IS NOT NULL) AND
1695: (p_instance_asset_rec.update_status <> FND_API.G_MISS_CHAR)) THEN
1696: IF p_lookup_tbl.count > 0 THEN
1697: For lookup_count in p_lookup_tbl.FIRST .. p_lookup_tbl.LAST
1698: LOOP
1699: IF p_lookup_tbl(lookup_count).lookup_code = p_instance_asset_rec.update_status THEN

Line 1710: RAISE fnd_api.g_exc_error;

1706: if l_valid_flag <> 'Y' then
1707: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_UPDATE_STATUS');
1708: FND_MESSAGE.SET_TOKEN('UPDATE_STATUS',p_instance_asset_rec.update_status);
1709: FND_MSG_PUB.Add;
1710: RAISE fnd_api.g_exc_error;
1711: end if;
1712: End if;
1713: --
1714: IF l_exists_flag <> 'Y' THEN

Line 1720: RAISE FND_API.G_EXC_ERROR;

1716: p_lookup_tbl(p_asset_count_rec.lookup_count).lookup_code := p_instance_asset_rec.update_status;
1717: IF NOT( CSI_Asset_vld_pvt.Is_Update_Status_Exists
1718: (p_instance_asset_rec.UPDATE_STATUS)) THEN
1719: p_lookup_tbl(p_asset_count_rec.lookup_count).valid_flag := 'N';
1720: RAISE FND_API.G_EXC_ERROR;
1721: ELSE
1722: p_lookup_tbl(p_asset_count_rec.lookup_count).valid_flag := 'Y';
1723: END IF;
1724: END IF;

Line 1732: p_instance_asset_rec.fa_asset_id <> FND_API.G_MISS_NUM) AND

1728: --check for the exists of asset_id and asset book_type_code combination in the fa_books table
1729: l_valid_flag := 'Y';
1730: l_exists_flag := 'N';
1731: IF ((p_instance_asset_rec.fa_asset_id is not null AND
1732: p_instance_asset_rec.fa_asset_id <> FND_API.G_MISS_NUM) AND
1733: (p_instance_asset_rec.fa_book_type_code is not null AND
1734: p_instance_asset_rec.fa_book_type_code <> FND_API.G_MISS_CHAR))
1735: THEN
1736: IF p_asset_id_tbl.count > 0 then

Line 1734: p_instance_asset_rec.fa_book_type_code <> FND_API.G_MISS_CHAR))

1730: l_exists_flag := 'N';
1731: IF ((p_instance_asset_rec.fa_asset_id is not null AND
1732: p_instance_asset_rec.fa_asset_id <> FND_API.G_MISS_NUM) AND
1733: (p_instance_asset_rec.fa_book_type_code is not null AND
1734: p_instance_asset_rec.fa_book_type_code <> FND_API.G_MISS_CHAR))
1735: THEN
1736: IF p_asset_id_tbl.count > 0 then
1737: For asset_count in p_asset_id_tbl.FIRST .. p_asset_id_tbl.LAST
1738: LOOP

Line 1752: RAISE fnd_api.g_exc_error;

1748: IF l_valid_flag <> 'Y' THEN
1749: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ASSET_COMB');
1750: FND_MESSAGE.SET_TOKEN('ASSET_COMBINATION',p_instance_asset_rec.fa_asset_id||'-'||p_instance_asset_rec.fa_book_type_code);
1751: FND_MSG_PUB.Add;
1752: RAISE fnd_api.g_exc_error;
1753: END IF;
1754: END IF;
1755: --
1756: IF l_exists_flag <> 'Y' THEN

Line 1764: RAISE fnd_api.g_exc_error;

1760: IF NOT( CSI_Asset_vld_pvt.Is_Asset_Comb_Valid
1761: (p_instance_asset_rec.FA_ASSET_ID ,
1762: p_instance_asset_rec.FA_BOOK_TYPE_CODE )) THEN
1763: p_asset_id_tbl(p_asset_count_rec.asset_count).valid_flag := 'N';
1764: RAISE fnd_api.g_exc_error;
1765: ELSE
1766: p_asset_id_tbl(p_asset_count_rec.asset_count).valid_flag := 'Y';
1767: END IF;
1768: END IF;

Line 1772: IF p_instance_asset_rec.fa_sync_validation_reqd = fnd_api.g_false AND

1768: END IF;
1769: END IF;
1770: --
1771:
1772: IF p_instance_asset_rec.fa_sync_validation_reqd = fnd_api.g_false AND
1773: nvl(p_instance_asset_rec.fa_sync_flag,'N') = 'Y'
1774: THEN
1775: l_valid_flag := 'Y';
1776: l_exists_flag := 'N';

Line 1778: p_instance_asset_rec.fa_location_id <> FND_API.G_MISS_NUM THEN

1774: THEN
1775: l_valid_flag := 'Y';
1776: l_exists_flag := 'N';
1777: IF p_instance_asset_rec.fa_location_id is not null AND
1778: p_instance_asset_rec.fa_location_id <> FND_API.G_MISS_NUM THEN
1779: IF p_asset_loc_tbl.count > 0 then
1780: For loc_count in p_asset_loc_tbl.FIRST .. p_asset_loc_tbl.LAST
1781: LOOP
1782: IF p_asset_loc_tbl(loc_count).asset_loc_id = p_instance_asset_rec.fa_location_id THEN

Line 1793: RAISE fnd_api.g_exc_error;

1789: IF l_valid_flag <> 'Y' THEN
1790: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ASSET_LOCATION');
1791: FND_MESSAGE.SET_TOKEN('ASSET_LOCATION_ID',p_instance_asset_rec.fa_location_id);
1792: FND_MSG_PUB.Add;
1793: RAISE fnd_api.g_exc_error;
1794: END IF;
1795: END IF;
1796: --
1797: IF l_exists_flag <> 'Y' THEN

Line 1802: RAISE fnd_api.g_exc_error;

1798: p_asset_count_rec.loc_count := p_asset_count_rec.loc_count + 1;
1799: p_asset_loc_tbl(p_asset_count_rec.loc_count).asset_loc_id := p_instance_asset_rec.fa_location_id;
1800: IF NOT( CSI_Asset_vld_pvt.Is_Asset_Location_Valid (p_instance_asset_rec.FA_LOCATION_ID )) THEN
1801: p_asset_loc_tbl(p_asset_count_rec.loc_count).valid_flag := 'N';
1802: RAISE fnd_api.g_exc_error;
1803: ELSE
1804: p_asset_loc_tbl(p_asset_count_rec.loc_count).valid_flag := 'Y';
1805: END IF;
1806: END IF;

Line 1812: IF p_instance_asset_rec.active_start_date <> FND_API.G_MISS_DATE THEN

1808: END IF;
1809: --
1810:
1811: -- Validation for the Active start date
1812: IF p_instance_asset_rec.active_start_date <> FND_API.G_MISS_DATE THEN
1813: IF p_instance_asset_rec.active_start_date <> l_curr_asset_rec.active_start_date THEN
1814: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
1815: FND_MESSAGE.Set_Token('COLUMN', 'ACTIVE_START_DATE');
1816: FND_MSG_PUB.ADD;

Line 1817: RAISE FND_API.G_EXC_ERROR;

1813: IF p_instance_asset_rec.active_start_date <> l_curr_asset_rec.active_start_date THEN
1814: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
1815: FND_MESSAGE.Set_Token('COLUMN', 'ACTIVE_START_DATE');
1816: FND_MSG_PUB.ADD;
1817: RAISE FND_API.G_EXC_ERROR;
1818: END IF;
1819: END IF;
1820:
1821: -- Verify end effective end date

Line 1822: IF ( p_instance_asset_rec.active_end_date <> FND_API.G_MISS_DATE) THEN

1818: END IF;
1819: END IF;
1820:
1821: -- Verify end effective end date
1822: IF ( p_instance_asset_rec.active_end_date <> FND_API.G_MISS_DATE) THEN
1823: IF p_instance_asset_rec.active_end_date IS NOT NULL THEN
1824: IF NOT(CSI_Asset_vld_pvt.Is_EndDate_Valid
1825: (p_instance_asset_rec.ACTIVE_START_DATE,
1826: p_instance_asset_rec.ACTIVE_END_DATE,

Line 1831: RAISE FND_API.G_EXC_ERROR;

1827: p_instance_asset_rec.INSTANCE_ID ,
1828: p_instance_asset_rec.INSTANCE_ASSET_ID,
1829: p_txn_rec.TRANSACTION_ID,
1830: p_instance_asset_rec.check_for_instance_expiry)) THEN
1831: RAISE FND_API.G_EXC_ERROR;
1832: END IF;
1833: END IF;
1834: END IF;
1835:

Line 1836: IF ((p_instance_asset_rec.fa_asset_id is not null AND p_instance_asset_rec.fa_asset_id <> fnd_api.g_miss_num)

1832: END IF;
1833: END IF;
1834: END IF;
1835:
1836: IF ((p_instance_asset_rec.fa_asset_id is not null AND p_instance_asset_rec.fa_asset_id <> fnd_api.g_miss_num)
1837: OR
1838: (l_curr_asset_rec.fa_asset_id is not null AND p_instance_asset_rec.fa_asset_id = fnd_api.g_miss_num))
1839: AND
1840: ((p_instance_asset_rec.fa_book_type_code is not null AND

Line 1838: (l_curr_asset_rec.fa_asset_id is not null AND p_instance_asset_rec.fa_asset_id = fnd_api.g_miss_num))

1834: END IF;
1835:
1836: IF ((p_instance_asset_rec.fa_asset_id is not null AND p_instance_asset_rec.fa_asset_id <> fnd_api.g_miss_num)
1837: OR
1838: (l_curr_asset_rec.fa_asset_id is not null AND p_instance_asset_rec.fa_asset_id = fnd_api.g_miss_num))
1839: AND
1840: ((p_instance_asset_rec.fa_book_type_code is not null AND
1841: p_instance_asset_rec.fa_book_type_code <> fnd_api.g_miss_char)
1842: OR

Line 1841: p_instance_asset_rec.fa_book_type_code <> fnd_api.g_miss_char)

1837: OR
1838: (l_curr_asset_rec.fa_asset_id is not null AND p_instance_asset_rec.fa_asset_id = fnd_api.g_miss_num))
1839: AND
1840: ((p_instance_asset_rec.fa_book_type_code is not null AND
1841: p_instance_asset_rec.fa_book_type_code <> fnd_api.g_miss_char)
1842: OR
1843: (l_curr_asset_rec.fa_book_type_code is not null AND
1844: p_instance_asset_rec.fa_book_type_code = fnd_api.g_miss_char))
1845: AND

Line 1844: p_instance_asset_rec.fa_book_type_code = fnd_api.g_miss_char))

1840: ((p_instance_asset_rec.fa_book_type_code is not null AND
1841: p_instance_asset_rec.fa_book_type_code <> fnd_api.g_miss_char)
1842: OR
1843: (l_curr_asset_rec.fa_book_type_code is not null AND
1844: p_instance_asset_rec.fa_book_type_code = fnd_api.g_miss_char))
1845: AND
1846: ((p_instance_asset_rec.fa_location_id is not null AND
1847: p_instance_asset_rec.fa_location_id <> fnd_api.g_miss_num)
1848: OR

Line 1847: p_instance_asset_rec.fa_location_id <> fnd_api.g_miss_num)

1843: (l_curr_asset_rec.fa_book_type_code is not null AND
1844: p_instance_asset_rec.fa_book_type_code = fnd_api.g_miss_char))
1845: AND
1846: ((p_instance_asset_rec.fa_location_id is not null AND
1847: p_instance_asset_rec.fa_location_id <> fnd_api.g_miss_num)
1848: OR
1849: (l_curr_asset_rec.fa_location_id is not null AND
1850: p_instance_asset_rec.fa_location_id = fnd_api.g_miss_num))
1851: AND

Line 1850: p_instance_asset_rec.fa_location_id = fnd_api.g_miss_num))

1846: ((p_instance_asset_rec.fa_location_id is not null AND
1847: p_instance_asset_rec.fa_location_id <> fnd_api.g_miss_num)
1848: OR
1849: (l_curr_asset_rec.fa_location_id is not null AND
1850: p_instance_asset_rec.fa_location_id = fnd_api.g_miss_num))
1851: AND
1852: ((p_instance_asset_rec.asset_quantity is not null AND
1853: p_instance_asset_rec.asset_quantity <> fnd_api.g_miss_num)
1854: OR

Line 1853: p_instance_asset_rec.asset_quantity <> fnd_api.g_miss_num)

1849: (l_curr_asset_rec.fa_location_id is not null AND
1850: p_instance_asset_rec.fa_location_id = fnd_api.g_miss_num))
1851: AND
1852: ((p_instance_asset_rec.asset_quantity is not null AND
1853: p_instance_asset_rec.asset_quantity <> fnd_api.g_miss_num)
1854: OR
1855: (l_curr_asset_rec.asset_quantity is not null AND
1856: p_instance_asset_rec.asset_quantity = fnd_api.g_miss_num))
1857: THEN

Line 1856: p_instance_asset_rec.asset_quantity = fnd_api.g_miss_num))

1852: ((p_instance_asset_rec.asset_quantity is not null AND
1853: p_instance_asset_rec.asset_quantity <> fnd_api.g_miss_num)
1854: OR
1855: (l_curr_asset_rec.asset_quantity is not null AND
1856: p_instance_asset_rec.asset_quantity = fnd_api.g_miss_num))
1857: THEN
1858: l_creation_complete_flag := 'Y';
1859: ELSE
1860: l_creation_complete_flag := 'N';

Line 1863: IF p_instance_asset_rec.fa_sync_validation_reqd = fnd_api.g_true THEN

1859: ELSE
1860: l_creation_complete_flag := 'N';
1861: END IF;
1862:
1863: IF p_instance_asset_rec.fa_sync_validation_reqd = fnd_api.g_true THEN
1864:
1865: IF nvl(p_instance_asset_rec.fa_book_type_code, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
1866: p_instance_asset_rec.fa_book_type_code := l_curr_asset_rec.fa_book_type_code;
1867: END IF;

Line 1865: IF nvl(p_instance_asset_rec.fa_book_type_code, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN

1861: END IF;
1862:
1863: IF p_instance_asset_rec.fa_sync_validation_reqd = fnd_api.g_true THEN
1864:
1865: IF nvl(p_instance_asset_rec.fa_book_type_code, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
1866: p_instance_asset_rec.fa_book_type_code := l_curr_asset_rec.fa_book_type_code;
1867: END IF;
1868:
1869: IF nvl(p_instance_asset_rec.instance_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

Line 1869: IF nvl(p_instance_asset_rec.instance_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

1865: IF nvl(p_instance_asset_rec.fa_book_type_code, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
1866: p_instance_asset_rec.fa_book_type_code := l_curr_asset_rec.fa_book_type_code;
1867: END IF;
1868:
1869: IF nvl(p_instance_asset_rec.instance_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
1870: p_instance_asset_rec.instance_id := l_curr_asset_rec.instance_id;
1871: END IF;
1872:
1873: IF nvl(p_instance_asset_rec.fa_location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

Line 1873: IF nvl(p_instance_asset_rec.fa_location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

1869: IF nvl(p_instance_asset_rec.instance_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
1870: p_instance_asset_rec.instance_id := l_curr_asset_rec.instance_id;
1871: END IF;
1872:
1873: IF nvl(p_instance_asset_rec.fa_location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
1874: p_instance_asset_rec.fa_location_id := l_curr_asset_rec.fa_location_id;
1875: END IF;
1876:
1877: IF nvl(p_instance_asset_rec.fa_ASSET_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

Line 1877: IF nvl(p_instance_asset_rec.fa_ASSET_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

1873: IF nvl(p_instance_asset_rec.fa_location_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
1874: p_instance_asset_rec.fa_location_id := l_curr_asset_rec.fa_location_id;
1875: END IF;
1876:
1877: IF nvl(p_instance_asset_rec.fa_ASSET_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
1878: p_instance_asset_rec.fa_ASSET_id := l_curr_asset_rec.fa_ASSET_id;
1879: END IF;
1880:
1881: IF nvl(p_instance_asset_rec.asset_quantity, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

Line 1881: IF nvl(p_instance_asset_rec.asset_quantity, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

1877: IF nvl(p_instance_asset_rec.fa_ASSET_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
1878: p_instance_asset_rec.fa_ASSET_id := l_curr_asset_rec.fa_ASSET_id;
1879: END IF;
1880:
1881: IF nvl(p_instance_asset_rec.asset_quantity, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
1882: p_instance_asset_rec.asset_quantity := l_curr_asset_rec.asset_quantity;
1883: END IF;
1884:
1885: set_fa_sync_flag (

Line 1889: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1885: set_fa_sync_flag (
1886: px_instance_asset_rec => p_instance_asset_rec,
1887: x_return_status => l_return_status,
1888: x_error_msg => l_error_message);
1889: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1890: RAISE fnd_api.g_exc_error;
1891: END IF;
1892: END IF;
1893:

Line 1890: RAISE fnd_api.g_exc_error;

1886: px_instance_asset_rec => p_instance_asset_rec,
1887: x_return_status => l_return_status,
1888: x_error_msg => l_error_message);
1889: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1890: RAISE fnd_api.g_exc_error;
1891: END IF;
1892: END IF;
1893:
1894: -- Increment the object_version_number before updating

Line 1908: p_CREATED_BY => FND_API.G_MISS_NUM,

1904: p_UPDATE_STATUS => p_instance_asset_rec.UPDATE_STATUS,
1905: p_FA_SYNC_FLAG => p_instance_asset_rec.FA_SYNC_FLAG,
1906: p_FA_MASS_ADDITION_ID => p_instance_asset_rec.FA_MASS_ADDITION_ID,
1907: p_CREATION_COMPLETE_FLAG=> l_creation_complete_flag,
1908: p_CREATED_BY => FND_API.G_MISS_NUM,
1909: p_CREATION_DATE => fnd_api.g_miss_date,
1910: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1911: p_LAST_UPDATE_DATE => SYSDATE,
1912: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,

Line 1909: p_CREATION_DATE => fnd_api.g_miss_date,

1905: p_FA_SYNC_FLAG => p_instance_asset_rec.FA_SYNC_FLAG,
1906: p_FA_MASS_ADDITION_ID => p_instance_asset_rec.FA_MASS_ADDITION_ID,
1907: p_CREATION_COMPLETE_FLAG=> l_creation_complete_flag,
1908: p_CREATED_BY => FND_API.G_MISS_NUM,
1909: p_CREATION_DATE => fnd_api.g_miss_date,
1910: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1911: p_LAST_UPDATE_DATE => SYSDATE,
1912: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
1913: p_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER,

Line 1917: IF nvl(p_txn_rec.transaction_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN -- changed <> to = bug 5207557

1913: p_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER,
1914: p_ACTIVE_START_DATE => p_instance_asset_rec.ACTIVE_START_DATE,
1915: p_ACTIVE_END_DATE => p_instance_asset_rec.ACTIVE_END_DATE);
1916:
1917: IF nvl(p_txn_rec.transaction_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN -- changed <> to = bug 5207557
1918: -- Call create_transaction to create txn log
1919: CSI_TRANSACTIONS_PVT.Create_transaction (
1920: p_api_version => p_api_version,
1921: p_commit => p_commit,

Line 1930: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1926: x_return_status => x_return_status,
1927: x_msg_count => x_msg_count,
1928: x_msg_data => x_msg_data);
1929:
1930: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1931: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_VALIDATE_TXN');
1932: FND_MESSAGE.SET_TOKEN('API_NAME',l_api_name);
1933: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',p_txn_rec.transaction_id );
1934: FND_MSG_PUB.Add;

Line 1942: IF fnd_api.to_boolean(p_commit) THEN

1938: p_data => x_msg_data,
1939: p_msg_index_out => x_msg_index_out );
1940: debug( 'message data = '||x_msg_data);
1941: End LOOP;
1942: IF fnd_api.to_boolean(p_commit) THEN
1943: ROLLBACK TO update_instance_asset_pvt;
1944: END IF;
1945: RETURN;
1946: END IF;

Line 1962: RAISE FND_API.G_EXC_ERROR;

1958: --
1959: IF l_full_dump_frequency IS NULL THEN
1960: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
1961: FND_MSG_PUB.ADD;
1962: RAISE FND_API.G_EXC_ERROR;
1963: END IF;
1964: --
1965: SELECT mod(l_object_version_number,l_full_dump_frequency)
1966: INTO l_mod_value

Line 1995: p_INSTANCE_ASSET_ID => fnd_api.g_miss_num,

1991:
1992: IF l_asset_hist_csr.full_dump_flag = 'Y' THEN
1993: CSI_I_ASSETS_H_PKG.Update_Row (
1994: p_INSTANCE_ASSET_HISTORY_ID => l_asset_hist_id,
1995: p_INSTANCE_ASSET_ID => fnd_api.g_miss_num,
1996: p_TRANSACTION_ID => fnd_api.g_miss_num,
1997: p_OLD_INSTANCE_ID => fnd_api.g_miss_num,
1998: p_NEW_INSTANCE_ID => l_temp_inst_asset_rec.INSTANCE_ID,
1999: p_OLD_FA_ASSET_ID => fnd_api.g_miss_num,

Line 1996: p_TRANSACTION_ID => fnd_api.g_miss_num,

1992: IF l_asset_hist_csr.full_dump_flag = 'Y' THEN
1993: CSI_I_ASSETS_H_PKG.Update_Row (
1994: p_INSTANCE_ASSET_HISTORY_ID => l_asset_hist_id,
1995: p_INSTANCE_ASSET_ID => fnd_api.g_miss_num,
1996: p_TRANSACTION_ID => fnd_api.g_miss_num,
1997: p_OLD_INSTANCE_ID => fnd_api.g_miss_num,
1998: p_NEW_INSTANCE_ID => l_temp_inst_asset_rec.INSTANCE_ID,
1999: p_OLD_FA_ASSET_ID => fnd_api.g_miss_num,
2000: p_NEW_FA_ASSET_ID => l_temp_inst_asset_rec.FA_ASSET_ID,

Line 1997: p_OLD_INSTANCE_ID => fnd_api.g_miss_num,

1993: CSI_I_ASSETS_H_PKG.Update_Row (
1994: p_INSTANCE_ASSET_HISTORY_ID => l_asset_hist_id,
1995: p_INSTANCE_ASSET_ID => fnd_api.g_miss_num,
1996: p_TRANSACTION_ID => fnd_api.g_miss_num,
1997: p_OLD_INSTANCE_ID => fnd_api.g_miss_num,
1998: p_NEW_INSTANCE_ID => l_temp_inst_asset_rec.INSTANCE_ID,
1999: p_OLD_FA_ASSET_ID => fnd_api.g_miss_num,
2000: p_NEW_FA_ASSET_ID => l_temp_inst_asset_rec.FA_ASSET_ID,
2001: p_OLD_ASSET_QUANTITY => fnd_api.g_miss_num,

Line 1999: p_OLD_FA_ASSET_ID => fnd_api.g_miss_num,

1995: p_INSTANCE_ASSET_ID => fnd_api.g_miss_num,
1996: p_TRANSACTION_ID => fnd_api.g_miss_num,
1997: p_OLD_INSTANCE_ID => fnd_api.g_miss_num,
1998: p_NEW_INSTANCE_ID => l_temp_inst_asset_rec.INSTANCE_ID,
1999: p_OLD_FA_ASSET_ID => fnd_api.g_miss_num,
2000: p_NEW_FA_ASSET_ID => l_temp_inst_asset_rec.FA_ASSET_ID,
2001: p_OLD_ASSET_QUANTITY => fnd_api.g_miss_num,
2002: p_NEW_ASSET_QUANTITY => l_temp_inst_asset_rec.ASSET_QUANTITY,
2003: p_OLD_FA_BOOK_TYPE_CODE => fnd_api.g_miss_char,

Line 2001: p_OLD_ASSET_QUANTITY => fnd_api.g_miss_num,

1997: p_OLD_INSTANCE_ID => fnd_api.g_miss_num,
1998: p_NEW_INSTANCE_ID => l_temp_inst_asset_rec.INSTANCE_ID,
1999: p_OLD_FA_ASSET_ID => fnd_api.g_miss_num,
2000: p_NEW_FA_ASSET_ID => l_temp_inst_asset_rec.FA_ASSET_ID,
2001: p_OLD_ASSET_QUANTITY => fnd_api.g_miss_num,
2002: p_NEW_ASSET_QUANTITY => l_temp_inst_asset_rec.ASSET_QUANTITY,
2003: p_OLD_FA_BOOK_TYPE_CODE => fnd_api.g_miss_char,
2004: p_NEW_FA_BOOK_TYPE_CODE => l_temp_inst_asset_rec.FA_BOOK_TYPE_CODE,
2005: p_OLD_FA_LOCATION_ID => fnd_api.g_miss_num,

Line 2003: p_OLD_FA_BOOK_TYPE_CODE => fnd_api.g_miss_char,

1999: p_OLD_FA_ASSET_ID => fnd_api.g_miss_num,
2000: p_NEW_FA_ASSET_ID => l_temp_inst_asset_rec.FA_ASSET_ID,
2001: p_OLD_ASSET_QUANTITY => fnd_api.g_miss_num,
2002: p_NEW_ASSET_QUANTITY => l_temp_inst_asset_rec.ASSET_QUANTITY,
2003: p_OLD_FA_BOOK_TYPE_CODE => fnd_api.g_miss_char,
2004: p_NEW_FA_BOOK_TYPE_CODE => l_temp_inst_asset_rec.FA_BOOK_TYPE_CODE,
2005: p_OLD_FA_LOCATION_ID => fnd_api.g_miss_num,
2006: p_NEW_FA_LOCATION_ID => l_temp_inst_asset_rec.FA_LOCATION_ID,
2007: p_OLD_UPDATE_STATUS => fnd_api.g_miss_char,

Line 2005: p_OLD_FA_LOCATION_ID => fnd_api.g_miss_num,

2001: p_OLD_ASSET_QUANTITY => fnd_api.g_miss_num,
2002: p_NEW_ASSET_QUANTITY => l_temp_inst_asset_rec.ASSET_QUANTITY,
2003: p_OLD_FA_BOOK_TYPE_CODE => fnd_api.g_miss_char,
2004: p_NEW_FA_BOOK_TYPE_CODE => l_temp_inst_asset_rec.FA_BOOK_TYPE_CODE,
2005: p_OLD_FA_LOCATION_ID => fnd_api.g_miss_num,
2006: p_NEW_FA_LOCATION_ID => l_temp_inst_asset_rec.FA_LOCATION_ID,
2007: p_OLD_UPDATE_STATUS => fnd_api.g_miss_char,
2008: p_NEW_UPDATE_STATUS => l_temp_inst_asset_rec.UPDATE_STATUS,
2009: p_OLD_FA_SYNC_FLAG => fnd_api.g_miss_char,

Line 2007: p_OLD_UPDATE_STATUS => fnd_api.g_miss_char,

2003: p_OLD_FA_BOOK_TYPE_CODE => fnd_api.g_miss_char,
2004: p_NEW_FA_BOOK_TYPE_CODE => l_temp_inst_asset_rec.FA_BOOK_TYPE_CODE,
2005: p_OLD_FA_LOCATION_ID => fnd_api.g_miss_num,
2006: p_NEW_FA_LOCATION_ID => l_temp_inst_asset_rec.FA_LOCATION_ID,
2007: p_OLD_UPDATE_STATUS => fnd_api.g_miss_char,
2008: p_NEW_UPDATE_STATUS => l_temp_inst_asset_rec.UPDATE_STATUS,
2009: p_OLD_FA_SYNC_FLAG => fnd_api.g_miss_char,
2010: p_NEW_FA_SYNC_FLAG => l_temp_inst_asset_rec.FA_SYNC_FLAG,
2011: p_OLD_FA_MASS_ADDITION_ID => fnd_api.g_miss_num,

Line 2009: p_OLD_FA_SYNC_FLAG => fnd_api.g_miss_char,

2005: p_OLD_FA_LOCATION_ID => fnd_api.g_miss_num,
2006: p_NEW_FA_LOCATION_ID => l_temp_inst_asset_rec.FA_LOCATION_ID,
2007: p_OLD_UPDATE_STATUS => fnd_api.g_miss_char,
2008: p_NEW_UPDATE_STATUS => l_temp_inst_asset_rec.UPDATE_STATUS,
2009: p_OLD_FA_SYNC_FLAG => fnd_api.g_miss_char,
2010: p_NEW_FA_SYNC_FLAG => l_temp_inst_asset_rec.FA_SYNC_FLAG,
2011: p_OLD_FA_MASS_ADDITION_ID => fnd_api.g_miss_num,
2012: p_NEW_FA_MASS_ADDITION_ID => l_temp_inst_asset_rec.FA_MASS_ADDITION_ID,
2013: p_OLD_CREATION_COMPLETE_FLAG => fnd_api.g_miss_char,

Line 2011: p_OLD_FA_MASS_ADDITION_ID => fnd_api.g_miss_num,

2007: p_OLD_UPDATE_STATUS => fnd_api.g_miss_char,
2008: p_NEW_UPDATE_STATUS => l_temp_inst_asset_rec.UPDATE_STATUS,
2009: p_OLD_FA_SYNC_FLAG => fnd_api.g_miss_char,
2010: p_NEW_FA_SYNC_FLAG => l_temp_inst_asset_rec.FA_SYNC_FLAG,
2011: p_OLD_FA_MASS_ADDITION_ID => fnd_api.g_miss_num,
2012: p_NEW_FA_MASS_ADDITION_ID => l_temp_inst_asset_rec.FA_MASS_ADDITION_ID,
2013: p_OLD_CREATION_COMPLETE_FLAG => fnd_api.g_miss_char,
2014: p_NEW_CREATION_COMPLETE_FLAG => l_temp_inst_asset_rec.CREATION_COMPLETE_FLAG,
2015: p_FULL_DUMP_FLAG => fnd_api.g_miss_char,

Line 2013: p_OLD_CREATION_COMPLETE_FLAG => fnd_api.g_miss_char,

2009: p_OLD_FA_SYNC_FLAG => fnd_api.g_miss_char,
2010: p_NEW_FA_SYNC_FLAG => l_temp_inst_asset_rec.FA_SYNC_FLAG,
2011: p_OLD_FA_MASS_ADDITION_ID => fnd_api.g_miss_num,
2012: p_NEW_FA_MASS_ADDITION_ID => l_temp_inst_asset_rec.FA_MASS_ADDITION_ID,
2013: p_OLD_CREATION_COMPLETE_FLAG => fnd_api.g_miss_char,
2014: p_NEW_CREATION_COMPLETE_FLAG => l_temp_inst_asset_rec.CREATION_COMPLETE_FLAG,
2015: p_FULL_DUMP_FLAG => fnd_api.g_miss_char,
2016: p_CREATED_BY => fnd_api.g_miss_num,
2017: p_CREATION_DATE => fnd_api.g_miss_date,

Line 2015: p_FULL_DUMP_FLAG => fnd_api.g_miss_char,

2011: p_OLD_FA_MASS_ADDITION_ID => fnd_api.g_miss_num,
2012: p_NEW_FA_MASS_ADDITION_ID => l_temp_inst_asset_rec.FA_MASS_ADDITION_ID,
2013: p_OLD_CREATION_COMPLETE_FLAG => fnd_api.g_miss_char,
2014: p_NEW_CREATION_COMPLETE_FLAG => l_temp_inst_asset_rec.CREATION_COMPLETE_FLAG,
2015: p_FULL_DUMP_FLAG => fnd_api.g_miss_char,
2016: p_CREATED_BY => fnd_api.g_miss_num,
2017: p_CREATION_DATE => fnd_api.g_miss_date,
2018: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
2019: p_LAST_UPDATE_DATE => SYSDATE,

Line 2016: p_CREATED_BY => fnd_api.g_miss_num,

2012: p_NEW_FA_MASS_ADDITION_ID => l_temp_inst_asset_rec.FA_MASS_ADDITION_ID,
2013: p_OLD_CREATION_COMPLETE_FLAG => fnd_api.g_miss_char,
2014: p_NEW_CREATION_COMPLETE_FLAG => l_temp_inst_asset_rec.CREATION_COMPLETE_FLAG,
2015: p_FULL_DUMP_FLAG => fnd_api.g_miss_char,
2016: p_CREATED_BY => fnd_api.g_miss_num,
2017: p_CREATION_DATE => fnd_api.g_miss_date,
2018: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
2019: p_LAST_UPDATE_DATE => SYSDATE,
2020: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,

Line 2017: p_CREATION_DATE => fnd_api.g_miss_date,

2013: p_OLD_CREATION_COMPLETE_FLAG => fnd_api.g_miss_char,
2014: p_NEW_CREATION_COMPLETE_FLAG => l_temp_inst_asset_rec.CREATION_COMPLETE_FLAG,
2015: p_FULL_DUMP_FLAG => fnd_api.g_miss_char,
2016: p_CREATED_BY => fnd_api.g_miss_num,
2017: p_CREATION_DATE => fnd_api.g_miss_date,
2018: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
2019: p_LAST_UPDATE_DATE => SYSDATE,
2020: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
2021: p_OBJECT_VERSION_NUMBER => fnd_api.g_miss_num,

Line 2021: p_OBJECT_VERSION_NUMBER => fnd_api.g_miss_num,

2017: p_CREATION_DATE => fnd_api.g_miss_date,
2018: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
2019: p_LAST_UPDATE_DATE => SYSDATE,
2020: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
2021: p_OBJECT_VERSION_NUMBER => fnd_api.g_miss_num,
2022: p_OLD_ACTIVE_START_DATE => fnd_api.g_miss_date,
2023: p_NEW_ACTIVE_START_DATE => l_temp_inst_asset_rec.ACTIVE_START_DATE,
2024: p_OLD_ACTIVE_END_DATE => fnd_api.g_miss_date,
2025: p_NEW_ACTIVE_END_DATE => l_temp_inst_asset_rec.ACTIVE_END_DATE);

Line 2022: p_OLD_ACTIVE_START_DATE => fnd_api.g_miss_date,

2018: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
2019: p_LAST_UPDATE_DATE => SYSDATE,
2020: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
2021: p_OBJECT_VERSION_NUMBER => fnd_api.g_miss_num,
2022: p_OLD_ACTIVE_START_DATE => fnd_api.g_miss_date,
2023: p_NEW_ACTIVE_START_DATE => l_temp_inst_asset_rec.ACTIVE_START_DATE,
2024: p_OLD_ACTIVE_END_DATE => fnd_api.g_miss_date,
2025: p_NEW_ACTIVE_END_DATE => l_temp_inst_asset_rec.ACTIVE_END_DATE);
2026:

Line 2024: p_OLD_ACTIVE_END_DATE => fnd_api.g_miss_date,

2020: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
2021: p_OBJECT_VERSION_NUMBER => fnd_api.g_miss_num,
2022: p_OLD_ACTIVE_START_DATE => fnd_api.g_miss_date,
2023: p_NEW_ACTIVE_START_DATE => l_temp_inst_asset_rec.ACTIVE_START_DATE,
2024: p_OLD_ACTIVE_END_DATE => fnd_api.g_miss_date,
2025: p_NEW_ACTIVE_END_DATE => l_temp_inst_asset_rec.ACTIVE_END_DATE);
2026:
2027: ELSE
2028:

Line 2031: OR ( l_temp_inst_asset_rec.instance_id = fnd_api.g_miss_num )

2027: ELSE
2028:
2029: IF ( l_asset_hist_csr.old_instance_id IS NULL AND l_asset_hist_csr.new_instance_id IS NULL ) THEN
2030: IF ( l_temp_inst_asset_rec.instance_id = l_curr_asset_rec.instance_id )
2031: OR ( l_temp_inst_asset_rec.instance_id = fnd_api.g_miss_num )
2032: THEN
2033: l_asset_hist_csr.old_instance_id := NULL;
2034: l_asset_hist_csr.new_instance_id := NULL;
2035: ELSE

Line 2036: l_asset_hist_csr.old_instance_id := fnd_api.g_miss_num;

2032: THEN
2033: l_asset_hist_csr.old_instance_id := NULL;
2034: l_asset_hist_csr.new_instance_id := NULL;
2035: ELSE
2036: l_asset_hist_csr.old_instance_id := fnd_api.g_miss_num;
2037: l_asset_hist_csr.new_instance_id := l_temp_inst_asset_rec.instance_id;
2038: END IF;
2039: ELSE
2040: l_asset_hist_csr.old_instance_id := fnd_api.g_miss_num;

Line 2040: l_asset_hist_csr.old_instance_id := fnd_api.g_miss_num;

2036: l_asset_hist_csr.old_instance_id := fnd_api.g_miss_num;
2037: l_asset_hist_csr.new_instance_id := l_temp_inst_asset_rec.instance_id;
2038: END IF;
2039: ELSE
2040: l_asset_hist_csr.old_instance_id := fnd_api.g_miss_num;
2041: l_asset_hist_csr.new_instance_id := l_temp_inst_asset_rec.instance_id;
2042: END IF;
2043: --
2044: IF ( l_asset_hist_csr.old_fa_asset_id IS NULL AND l_asset_hist_csr.new_fa_asset_id IS NULL ) THEN

Line 2047: ( l_temp_inst_asset_rec.fa_asset_id = fnd_api.g_miss_num )

2043: --
2044: IF ( l_asset_hist_csr.old_fa_asset_id IS NULL AND l_asset_hist_csr.new_fa_asset_id IS NULL ) THEN
2045: IF ( l_temp_inst_asset_rec.fa_asset_id = l_curr_asset_rec.fa_asset_id )
2046: OR
2047: ( l_temp_inst_asset_rec.fa_asset_id = fnd_api.g_miss_num )
2048: THEN
2049: l_asset_hist_csr.old_fa_asset_id := NULL;
2050: l_asset_hist_csr.new_fa_asset_id := NULL;
2051: ELSE

Line 2052: l_asset_hist_csr.old_fa_asset_id := fnd_api.g_miss_num;

2048: THEN
2049: l_asset_hist_csr.old_fa_asset_id := NULL;
2050: l_asset_hist_csr.new_fa_asset_id := NULL;
2051: ELSE
2052: l_asset_hist_csr.old_fa_asset_id := fnd_api.g_miss_num;
2053: l_asset_hist_csr.new_fa_asset_id := l_temp_inst_asset_rec.fa_asset_id;
2054: END IF;
2055: ELSE
2056: l_asset_hist_csr.old_fa_asset_id := fnd_api.g_miss_num;

Line 2056: l_asset_hist_csr.old_fa_asset_id := fnd_api.g_miss_num;

2052: l_asset_hist_csr.old_fa_asset_id := fnd_api.g_miss_num;
2053: l_asset_hist_csr.new_fa_asset_id := l_temp_inst_asset_rec.fa_asset_id;
2054: END IF;
2055: ELSE
2056: l_asset_hist_csr.old_fa_asset_id := fnd_api.g_miss_num;
2057: l_asset_hist_csr.new_fa_asset_id := l_temp_inst_asset_rec.fa_asset_id;
2058: END IF;
2059: --
2060: IF ( l_asset_hist_csr.old_fa_book_type_code IS NULL AND l_asset_hist_csr.new_fa_book_type_code IS NULL) THEN

Line 2062: OR ( l_temp_inst_asset_rec.fa_book_type_code = fnd_api.g_miss_char ) THEN

2058: END IF;
2059: --
2060: IF ( l_asset_hist_csr.old_fa_book_type_code IS NULL AND l_asset_hist_csr.new_fa_book_type_code IS NULL) THEN
2061: IF ( l_temp_inst_asset_rec.fa_book_type_code = l_curr_asset_rec.fa_book_type_code )
2062: OR ( l_temp_inst_asset_rec.fa_book_type_code = fnd_api.g_miss_char ) THEN
2063: l_asset_hist_csr.old_fa_book_type_code := NULL;
2064: l_asset_hist_csr.new_fa_book_type_code := NULL;
2065: ELSE
2066: l_asset_hist_csr.old_fa_book_type_code := fnd_api.g_miss_char;

Line 2066: l_asset_hist_csr.old_fa_book_type_code := fnd_api.g_miss_char;

2062: OR ( l_temp_inst_asset_rec.fa_book_type_code = fnd_api.g_miss_char ) THEN
2063: l_asset_hist_csr.old_fa_book_type_code := NULL;
2064: l_asset_hist_csr.new_fa_book_type_code := NULL;
2065: ELSE
2066: l_asset_hist_csr.old_fa_book_type_code := fnd_api.g_miss_char;
2067: l_asset_hist_csr.new_fa_book_type_code := l_temp_inst_asset_rec.fa_book_type_code;
2068: END IF;
2069: ELSE
2070: l_asset_hist_csr.old_fa_book_type_code := fnd_api.g_miss_char;

Line 2070: l_asset_hist_csr.old_fa_book_type_code := fnd_api.g_miss_char;

2066: l_asset_hist_csr.old_fa_book_type_code := fnd_api.g_miss_char;
2067: l_asset_hist_csr.new_fa_book_type_code := l_temp_inst_asset_rec.fa_book_type_code;
2068: END IF;
2069: ELSE
2070: l_asset_hist_csr.old_fa_book_type_code := fnd_api.g_miss_char;
2071: l_asset_hist_csr.new_fa_book_type_code := l_temp_inst_asset_rec.fa_book_type_code;
2072: END IF;
2073: --
2074: IF ( l_asset_hist_csr.old_fa_location_id IS NULL

Line 2077: OR ( l_temp_inst_asset_rec.fa_location_id = fnd_api.g_miss_num ) THEN

2073: --
2074: IF ( l_asset_hist_csr.old_fa_location_id IS NULL
2075: AND l_asset_hist_csr.new_fa_location_id IS NULL ) THEN
2076: IF ( l_temp_inst_asset_rec.fa_location_id = l_curr_asset_rec.fa_location_id )
2077: OR ( l_temp_inst_asset_rec.fa_location_id = fnd_api.g_miss_num ) THEN
2078: l_asset_hist_csr.old_fa_location_id := NULL;
2079: l_asset_hist_csr.new_fa_location_id := NULL;
2080: ELSE
2081: l_asset_hist_csr.old_fa_location_id := fnd_api.g_miss_num;

Line 2081: l_asset_hist_csr.old_fa_location_id := fnd_api.g_miss_num;

2077: OR ( l_temp_inst_asset_rec.fa_location_id = fnd_api.g_miss_num ) THEN
2078: l_asset_hist_csr.old_fa_location_id := NULL;
2079: l_asset_hist_csr.new_fa_location_id := NULL;
2080: ELSE
2081: l_asset_hist_csr.old_fa_location_id := fnd_api.g_miss_num;
2082: l_asset_hist_csr.new_fa_location_id := l_temp_inst_asset_rec.fa_location_id;
2083: END IF;
2084: ELSE
2085: l_asset_hist_csr.old_fa_location_id := fnd_api.g_miss_num;

Line 2085: l_asset_hist_csr.old_fa_location_id := fnd_api.g_miss_num;

2081: l_asset_hist_csr.old_fa_location_id := fnd_api.g_miss_num;
2082: l_asset_hist_csr.new_fa_location_id := l_temp_inst_asset_rec.fa_location_id;
2083: END IF;
2084: ELSE
2085: l_asset_hist_csr.old_fa_location_id := fnd_api.g_miss_num;
2086: l_asset_hist_csr.new_fa_location_id := l_temp_inst_asset_rec.fa_location_id;
2087: END IF;
2088: --
2089: IF ( l_asset_hist_csr.old_asset_quantity IS NULL

Line 2092: OR ( l_temp_inst_asset_rec.asset_quantity = fnd_api.g_miss_num ) THEN

2088: --
2089: IF ( l_asset_hist_csr.old_asset_quantity IS NULL
2090: AND l_asset_hist_csr.new_asset_quantity IS NULL ) THEN
2091: IF ( l_temp_inst_asset_rec.asset_quantity = l_curr_asset_rec.asset_quantity )
2092: OR ( l_temp_inst_asset_rec.asset_quantity = fnd_api.g_miss_num ) THEN
2093: l_asset_hist_csr.old_asset_quantity := NULL;
2094: l_asset_hist_csr.new_asset_quantity := NULL;
2095: ELSE
2096: l_asset_hist_csr.old_asset_quantity := fnd_api.g_miss_num;

Line 2096: l_asset_hist_csr.old_asset_quantity := fnd_api.g_miss_num;

2092: OR ( l_temp_inst_asset_rec.asset_quantity = fnd_api.g_miss_num ) THEN
2093: l_asset_hist_csr.old_asset_quantity := NULL;
2094: l_asset_hist_csr.new_asset_quantity := NULL;
2095: ELSE
2096: l_asset_hist_csr.old_asset_quantity := fnd_api.g_miss_num;
2097: l_asset_hist_csr.new_asset_quantity := l_temp_inst_asset_rec.asset_quantity;
2098: END IF;
2099: ELSE
2100: l_asset_hist_csr.old_asset_quantity := fnd_api.g_miss_num;

Line 2100: l_asset_hist_csr.old_asset_quantity := fnd_api.g_miss_num;

2096: l_asset_hist_csr.old_asset_quantity := fnd_api.g_miss_num;
2097: l_asset_hist_csr.new_asset_quantity := l_temp_inst_asset_rec.asset_quantity;
2098: END IF;
2099: ELSE
2100: l_asset_hist_csr.old_asset_quantity := fnd_api.g_miss_num;
2101: l_asset_hist_csr.new_asset_quantity := l_temp_inst_asset_rec.asset_quantity;
2102: END IF;
2103: --
2104: IF ( l_asset_hist_csr.old_update_status IS NULL

Line 2107: OR ( l_temp_inst_asset_rec.update_status = fnd_api.g_miss_char ) THEN

2103: --
2104: IF ( l_asset_hist_csr.old_update_status IS NULL
2105: AND l_asset_hist_csr.new_update_status IS NULL ) THEN
2106: IF ( l_temp_inst_asset_rec.update_status = l_curr_asset_rec.update_status )
2107: OR ( l_temp_inst_asset_rec.update_status = fnd_api.g_miss_char ) THEN
2108: l_asset_hist_csr.old_update_status := NULL;
2109: l_asset_hist_csr.new_update_status := NULL;
2110: ELSE
2111: l_asset_hist_csr.old_update_status := fnd_api.g_miss_char;

Line 2111: l_asset_hist_csr.old_update_status := fnd_api.g_miss_char;

2107: OR ( l_temp_inst_asset_rec.update_status = fnd_api.g_miss_char ) THEN
2108: l_asset_hist_csr.old_update_status := NULL;
2109: l_asset_hist_csr.new_update_status := NULL;
2110: ELSE
2111: l_asset_hist_csr.old_update_status := fnd_api.g_miss_char;
2112: l_asset_hist_csr.new_update_status := l_temp_inst_asset_rec.update_status;
2113: END IF;
2114: ELSE
2115: l_asset_hist_csr.old_update_status := fnd_api.g_miss_char;

Line 2115: l_asset_hist_csr.old_update_status := fnd_api.g_miss_char;

2111: l_asset_hist_csr.old_update_status := fnd_api.g_miss_char;
2112: l_asset_hist_csr.new_update_status := l_temp_inst_asset_rec.update_status;
2113: END IF;
2114: ELSE
2115: l_asset_hist_csr.old_update_status := fnd_api.g_miss_char;
2116: l_asset_hist_csr.new_update_status := l_temp_inst_asset_rec.update_status;
2117: END IF;
2118: --
2119: IF ( l_asset_hist_csr.old_active_start_date IS NULL

Line 2122: OR ( l_temp_inst_asset_rec.active_start_date = fnd_api.g_miss_date ) THEN

2118: --
2119: IF ( l_asset_hist_csr.old_active_start_date IS NULL
2120: AND l_asset_hist_csr.new_active_start_date IS NULL ) THEN
2121: IF ( l_temp_inst_asset_rec.active_start_date = l_curr_asset_rec.active_start_date )
2122: OR ( l_temp_inst_asset_rec.active_start_date = fnd_api.g_miss_date ) THEN
2123: l_asset_hist_csr.old_active_start_date := NULL;
2124: l_asset_hist_csr.new_active_start_date := NULL;
2125: ELSE
2126: l_asset_hist_csr.old_active_start_date := fnd_api.g_miss_date;

Line 2126: l_asset_hist_csr.old_active_start_date := fnd_api.g_miss_date;

2122: OR ( l_temp_inst_asset_rec.active_start_date = fnd_api.g_miss_date ) THEN
2123: l_asset_hist_csr.old_active_start_date := NULL;
2124: l_asset_hist_csr.new_active_start_date := NULL;
2125: ELSE
2126: l_asset_hist_csr.old_active_start_date := fnd_api.g_miss_date;
2127: l_asset_hist_csr.new_active_start_date := l_temp_inst_asset_rec.active_start_date;
2128: END IF;
2129: ELSE
2130: l_asset_hist_csr.old_active_start_date := fnd_api.g_miss_date;

Line 2130: l_asset_hist_csr.old_active_start_date := fnd_api.g_miss_date;

2126: l_asset_hist_csr.old_active_start_date := fnd_api.g_miss_date;
2127: l_asset_hist_csr.new_active_start_date := l_temp_inst_asset_rec.active_start_date;
2128: END IF;
2129: ELSE
2130: l_asset_hist_csr.old_active_start_date := fnd_api.g_miss_date;
2131: l_asset_hist_csr.new_active_start_date := l_temp_inst_asset_rec.active_start_date;
2132: END IF;
2133: --
2134: IF ( l_asset_hist_csr.old_active_end_date IS NULL

Line 2137: OR ( l_temp_inst_asset_rec.active_end_date = fnd_api.g_miss_date ) THEN

2133: --
2134: IF ( l_asset_hist_csr.old_active_end_date IS NULL
2135: AND l_asset_hist_csr.new_active_end_date IS NULL ) THEN
2136: IF ( l_temp_inst_asset_rec.active_end_date = l_curr_asset_rec.active_end_date )
2137: OR ( l_temp_inst_asset_rec.active_end_date = fnd_api.g_miss_date ) THEN
2138: l_asset_hist_csr.old_active_end_date := NULL;
2139: l_asset_hist_csr.new_active_end_date := NULL;
2140: ELSE
2141: l_asset_hist_csr.old_active_end_date := fnd_api.g_miss_date;

Line 2141: l_asset_hist_csr.old_active_end_date := fnd_api.g_miss_date;

2137: OR ( l_temp_inst_asset_rec.active_end_date = fnd_api.g_miss_date ) THEN
2138: l_asset_hist_csr.old_active_end_date := NULL;
2139: l_asset_hist_csr.new_active_end_date := NULL;
2140: ELSE
2141: l_asset_hist_csr.old_active_end_date := fnd_api.g_miss_date;
2142: l_asset_hist_csr.new_active_end_date := l_temp_inst_asset_rec.active_end_date;
2143: END IF;
2144: ELSE
2145: l_asset_hist_csr.old_active_end_date := fnd_api.g_miss_date;

Line 2145: l_asset_hist_csr.old_active_end_date := fnd_api.g_miss_date;

2141: l_asset_hist_csr.old_active_end_date := fnd_api.g_miss_date;
2142: l_asset_hist_csr.new_active_end_date := l_temp_inst_asset_rec.active_end_date;
2143: END IF;
2144: ELSE
2145: l_asset_hist_csr.old_active_end_date := fnd_api.g_miss_date;
2146: l_asset_hist_csr.new_active_end_date := l_temp_inst_asset_rec.active_end_date;
2147: END IF;
2148:
2149:

Line 2152: p_instance_asset_id => fnd_api.g_miss_num ,

2148:
2149:
2150: csi_i_assets_h_pkg.update_row (
2151: p_instance_asset_history_id => l_asset_hist_id ,
2152: p_instance_asset_id => fnd_api.g_miss_num ,
2153: p_transaction_id => fnd_api.g_miss_num ,
2154: p_old_instance_id => l_asset_hist_csr.old_instance_id ,
2155: p_new_instance_id => l_asset_hist_csr.new_instance_id ,
2156: p_old_fa_asset_id => l_asset_hist_csr.old_fa_asset_id ,

Line 2153: p_transaction_id => fnd_api.g_miss_num ,

2149:
2150: csi_i_assets_h_pkg.update_row (
2151: p_instance_asset_history_id => l_asset_hist_id ,
2152: p_instance_asset_id => fnd_api.g_miss_num ,
2153: p_transaction_id => fnd_api.g_miss_num ,
2154: p_old_instance_id => l_asset_hist_csr.old_instance_id ,
2155: p_new_instance_id => l_asset_hist_csr.new_instance_id ,
2156: p_old_fa_asset_id => l_asset_hist_csr.old_fa_asset_id ,
2157: p_new_fa_asset_id => l_asset_hist_csr.new_fa_asset_id ,

Line 2172: p_full_dump_flag => fnd_api.g_miss_char ,

2168: p_OLD_FA_MASS_ADDITION_ID => l_asset_hist_csr.old_fa_mass_addition_id,
2169: p_NEW_FA_MASS_ADDITION_ID => l_asset_hist_csr.new_fa_mass_addition_id,
2170: p_OLD_CREATION_COMPLETE_FLAG => l_asset_hist_csr.old_creation_complete_flag,
2171: p_NEW_CREATION_COMPLETE_FLAG => l_asset_hist_csr.new_creation_complete_flag,
2172: p_full_dump_flag => fnd_api.g_miss_char ,
2173: p_created_by => fnd_api.g_miss_num ,
2174: p_creation_date => fnd_api.g_miss_date ,
2175: p_last_updated_by => fnd_global.user_id ,
2176: p_last_update_date => SYSDATE ,

Line 2173: p_created_by => fnd_api.g_miss_num ,

2169: p_NEW_FA_MASS_ADDITION_ID => l_asset_hist_csr.new_fa_mass_addition_id,
2170: p_OLD_CREATION_COMPLETE_FLAG => l_asset_hist_csr.old_creation_complete_flag,
2171: p_NEW_CREATION_COMPLETE_FLAG => l_asset_hist_csr.new_creation_complete_flag,
2172: p_full_dump_flag => fnd_api.g_miss_char ,
2173: p_created_by => fnd_api.g_miss_num ,
2174: p_creation_date => fnd_api.g_miss_date ,
2175: p_last_updated_by => fnd_global.user_id ,
2176: p_last_update_date => SYSDATE ,
2177: p_last_update_login => fnd_global.login_id ,

Line 2174: p_creation_date => fnd_api.g_miss_date ,

2170: p_OLD_CREATION_COMPLETE_FLAG => l_asset_hist_csr.old_creation_complete_flag,
2171: p_NEW_CREATION_COMPLETE_FLAG => l_asset_hist_csr.new_creation_complete_flag,
2172: p_full_dump_flag => fnd_api.g_miss_char ,
2173: p_created_by => fnd_api.g_miss_num ,
2174: p_creation_date => fnd_api.g_miss_date ,
2175: p_last_updated_by => fnd_global.user_id ,
2176: p_last_update_date => SYSDATE ,
2177: p_last_update_login => fnd_global.login_id ,
2178: p_object_version_number => fnd_api.g_miss_num ,

Line 2178: p_object_version_number => fnd_api.g_miss_num ,

2174: p_creation_date => fnd_api.g_miss_date ,
2175: p_last_updated_by => fnd_global.user_id ,
2176: p_last_update_date => SYSDATE ,
2177: p_last_update_login => fnd_global.login_id ,
2178: p_object_version_number => fnd_api.g_miss_num ,
2179: p_old_active_start_date => l_asset_hist_csr.old_active_start_date ,
2180: p_new_active_start_date => l_asset_hist_csr.new_active_start_date ,
2181: p_old_active_end_date => l_asset_hist_csr.old_active_end_date ,
2182: p_new_active_end_date => l_asset_hist_csr.new_active_end_date );

Line 2204: IF (p_instance_asset_rec.FA_ASSET_ID = FND_API.G_MISS_NUM) THEN

2200: l_temp_inst_asset_rec.active_start_date := p_instance_asset_rec.active_start_date ;
2201: l_temp_inst_asset_rec.active_end_date := p_instance_asset_rec.active_end_date ;
2202: l_temp_inst_asset_rec.object_version_number := p_instance_asset_rec.object_version_number ;
2203:
2204: IF (p_instance_asset_rec.FA_ASSET_ID = FND_API.G_MISS_NUM) THEN
2205: l_temp_inst_asset_rec.FA_ASSET_ID := l_curr_asset_rec.FA_ASSET_ID ;
2206: END IF;
2207: IF (p_instance_asset_rec.ASSET_QUANTITY = FND_API.G_MISS_NUM) THEN
2208: l_temp_inst_asset_rec.ASSET_QUANTITY := l_curr_asset_rec.ASSET_QUANTITY ;

Line 2207: IF (p_instance_asset_rec.ASSET_QUANTITY = FND_API.G_MISS_NUM) THEN

2203:
2204: IF (p_instance_asset_rec.FA_ASSET_ID = FND_API.G_MISS_NUM) THEN
2205: l_temp_inst_asset_rec.FA_ASSET_ID := l_curr_asset_rec.FA_ASSET_ID ;
2206: END IF;
2207: IF (p_instance_asset_rec.ASSET_QUANTITY = FND_API.G_MISS_NUM) THEN
2208: l_temp_inst_asset_rec.ASSET_QUANTITY := l_curr_asset_rec.ASSET_QUANTITY ;
2209: END IF;
2210: IF (p_instance_asset_rec.FA_BOOK_TYPE_CODE = FND_API.G_MISS_CHAR) THEN
2211: l_temp_inst_asset_rec.FA_BOOK_TYPE_CODE := l_curr_asset_rec.FA_BOOK_TYPE_CODE ;

Line 2210: IF (p_instance_asset_rec.FA_BOOK_TYPE_CODE = FND_API.G_MISS_CHAR) THEN

2206: END IF;
2207: IF (p_instance_asset_rec.ASSET_QUANTITY = FND_API.G_MISS_NUM) THEN
2208: l_temp_inst_asset_rec.ASSET_QUANTITY := l_curr_asset_rec.ASSET_QUANTITY ;
2209: END IF;
2210: IF (p_instance_asset_rec.FA_BOOK_TYPE_CODE = FND_API.G_MISS_CHAR) THEN
2211: l_temp_inst_asset_rec.FA_BOOK_TYPE_CODE := l_curr_asset_rec.FA_BOOK_TYPE_CODE ;
2212: END IF;
2213: IF (p_instance_asset_rec.FA_LOCATION_ID = FND_API.G_MISS_NUM) THEN
2214: l_temp_inst_asset_rec.FA_LOCATION_ID := l_curr_asset_rec.FA_LOCATION_ID ;

Line 2213: IF (p_instance_asset_rec.FA_LOCATION_ID = FND_API.G_MISS_NUM) THEN

2209: END IF;
2210: IF (p_instance_asset_rec.FA_BOOK_TYPE_CODE = FND_API.G_MISS_CHAR) THEN
2211: l_temp_inst_asset_rec.FA_BOOK_TYPE_CODE := l_curr_asset_rec.FA_BOOK_TYPE_CODE ;
2212: END IF;
2213: IF (p_instance_asset_rec.FA_LOCATION_ID = FND_API.G_MISS_NUM) THEN
2214: l_temp_inst_asset_rec.FA_LOCATION_ID := l_curr_asset_rec.FA_LOCATION_ID ;
2215: END IF;
2216: IF (p_instance_asset_rec.UPDATE_STATUS = FND_API.G_MISS_CHAR) THEN
2217: l_temp_inst_asset_rec.UPDATE_STATUS := l_curr_asset_rec.UPDATE_STATUS ;

Line 2216: IF (p_instance_asset_rec.UPDATE_STATUS = FND_API.G_MISS_CHAR) THEN

2212: END IF;
2213: IF (p_instance_asset_rec.FA_LOCATION_ID = FND_API.G_MISS_NUM) THEN
2214: l_temp_inst_asset_rec.FA_LOCATION_ID := l_curr_asset_rec.FA_LOCATION_ID ;
2215: END IF;
2216: IF (p_instance_asset_rec.UPDATE_STATUS = FND_API.G_MISS_CHAR) THEN
2217: l_temp_inst_asset_rec.UPDATE_STATUS := l_curr_asset_rec.UPDATE_STATUS ;
2218: END IF;
2219:
2220: -- Call table handlers to insert into history table

Line 2263: IF (p_instance_asset_rec.fa_asset_id = fnd_api.g_miss_num) OR

2259: l_temp_inst_asset_rec := l_curr_asset_rec;
2260:
2261: -- If the mod value is not equal to zero then dump only the changed columns
2262: -- while the unchanged values have old and new values as null
2263: IF (p_instance_asset_rec.fa_asset_id = fnd_api.g_miss_num) OR
2264: NVL(p_instance_asset_rec.fa_asset_id, fnd_api.g_miss_num) = NVL(l_temp_inst_asset_rec.fa_asset_id, fnd_api.g_miss_num) THEN
2265: l_ins_asset_hist_rec.old_fa_asset_id := NULL;
2266: l_ins_asset_hist_rec.new_fa_asset_id := NULL;
2267: ELSIF

Line 2264: NVL(p_instance_asset_rec.fa_asset_id, fnd_api.g_miss_num) = NVL(l_temp_inst_asset_rec.fa_asset_id, fnd_api.g_miss_num) THEN

2260:
2261: -- If the mod value is not equal to zero then dump only the changed columns
2262: -- while the unchanged values have old and new values as null
2263: IF (p_instance_asset_rec.fa_asset_id = fnd_api.g_miss_num) OR
2264: NVL(p_instance_asset_rec.fa_asset_id, fnd_api.g_miss_num) = NVL(l_temp_inst_asset_rec.fa_asset_id, fnd_api.g_miss_num) THEN
2265: l_ins_asset_hist_rec.old_fa_asset_id := NULL;
2266: l_ins_asset_hist_rec.new_fa_asset_id := NULL;
2267: ELSIF
2268: NVL(l_temp_inst_asset_rec.fa_asset_id,fnd_api.g_miss_num) <> NVL(p_instance_asset_rec.fa_asset_id,fnd_api.g_miss_num) THEN

Line 2268: NVL(l_temp_inst_asset_rec.fa_asset_id,fnd_api.g_miss_num) <> NVL(p_instance_asset_rec.fa_asset_id,fnd_api.g_miss_num) THEN

2264: NVL(p_instance_asset_rec.fa_asset_id, fnd_api.g_miss_num) = NVL(l_temp_inst_asset_rec.fa_asset_id, fnd_api.g_miss_num) THEN
2265: l_ins_asset_hist_rec.old_fa_asset_id := NULL;
2266: l_ins_asset_hist_rec.new_fa_asset_id := NULL;
2267: ELSIF
2268: NVL(l_temp_inst_asset_rec.fa_asset_id,fnd_api.g_miss_num) <> NVL(p_instance_asset_rec.fa_asset_id,fnd_api.g_miss_num) THEN
2269: l_ins_asset_hist_rec.old_fa_asset_id := l_temp_inst_asset_rec.fa_asset_id ;
2270: l_ins_asset_hist_rec.new_fa_asset_id := p_instance_asset_rec.fa_asset_id ;
2271: END IF;
2272: --

Line 2273: IF (p_instance_asset_rec.asset_quantity = fnd_api.g_miss_num) OR

2269: l_ins_asset_hist_rec.old_fa_asset_id := l_temp_inst_asset_rec.fa_asset_id ;
2270: l_ins_asset_hist_rec.new_fa_asset_id := p_instance_asset_rec.fa_asset_id ;
2271: END IF;
2272: --
2273: IF (p_instance_asset_rec.asset_quantity = fnd_api.g_miss_num) OR
2274: NVL(p_instance_asset_rec.asset_quantity, fnd_api.g_miss_num) = NVL(l_temp_inst_asset_rec.asset_quantity, fnd_api.g_miss_num) THEN
2275: l_ins_asset_hist_rec.old_asset_quantity := NULL;
2276: l_ins_asset_hist_rec.new_asset_quantity := NULL;
2277: ELSIF

Line 2274: NVL(p_instance_asset_rec.asset_quantity, fnd_api.g_miss_num) = NVL(l_temp_inst_asset_rec.asset_quantity, fnd_api.g_miss_num) THEN

2270: l_ins_asset_hist_rec.new_fa_asset_id := p_instance_asset_rec.fa_asset_id ;
2271: END IF;
2272: --
2273: IF (p_instance_asset_rec.asset_quantity = fnd_api.g_miss_num) OR
2274: NVL(p_instance_asset_rec.asset_quantity, fnd_api.g_miss_num) = NVL(l_temp_inst_asset_rec.asset_quantity, fnd_api.g_miss_num) THEN
2275: l_ins_asset_hist_rec.old_asset_quantity := NULL;
2276: l_ins_asset_hist_rec.new_asset_quantity := NULL;
2277: ELSIF
2278: NVL(l_temp_inst_asset_rec.asset_quantity,fnd_api.g_miss_num) <> NVL(p_instance_asset_rec.asset_quantity,fnd_api.g_miss_num) THEN

Line 2278: NVL(l_temp_inst_asset_rec.asset_quantity,fnd_api.g_miss_num) <> NVL(p_instance_asset_rec.asset_quantity,fnd_api.g_miss_num) THEN

2274: NVL(p_instance_asset_rec.asset_quantity, fnd_api.g_miss_num) = NVL(l_temp_inst_asset_rec.asset_quantity, fnd_api.g_miss_num) THEN
2275: l_ins_asset_hist_rec.old_asset_quantity := NULL;
2276: l_ins_asset_hist_rec.new_asset_quantity := NULL;
2277: ELSIF
2278: NVL(l_temp_inst_asset_rec.asset_quantity,fnd_api.g_miss_num) <> NVL(p_instance_asset_rec.asset_quantity,fnd_api.g_miss_num) THEN
2279: l_ins_asset_hist_rec.old_asset_quantity := l_temp_inst_asset_rec.asset_quantity ;
2280: l_ins_asset_hist_rec.new_asset_quantity := p_instance_asset_rec.asset_quantity ;
2281: END IF;
2282: --

Line 2283: IF (p_instance_asset_rec.fa_book_type_code = fnd_api.g_miss_char) OR

2279: l_ins_asset_hist_rec.old_asset_quantity := l_temp_inst_asset_rec.asset_quantity ;
2280: l_ins_asset_hist_rec.new_asset_quantity := p_instance_asset_rec.asset_quantity ;
2281: END IF;
2282: --
2283: IF (p_instance_asset_rec.fa_book_type_code = fnd_api.g_miss_char) OR
2284: NVL(p_instance_asset_rec.fa_book_type_code, fnd_api.g_miss_char) = NVL(l_temp_inst_asset_rec.fa_book_type_code, fnd_api.g_miss_char) THEN
2285: l_ins_asset_hist_rec.old_fa_book_type_code := NULL;
2286: l_ins_asset_hist_rec.new_fa_book_type_code := NULL;
2287: ELSIF

Line 2284: NVL(p_instance_asset_rec.fa_book_type_code, fnd_api.g_miss_char) = NVL(l_temp_inst_asset_rec.fa_book_type_code, fnd_api.g_miss_char) THEN

2280: l_ins_asset_hist_rec.new_asset_quantity := p_instance_asset_rec.asset_quantity ;
2281: END IF;
2282: --
2283: IF (p_instance_asset_rec.fa_book_type_code = fnd_api.g_miss_char) OR
2284: NVL(p_instance_asset_rec.fa_book_type_code, fnd_api.g_miss_char) = NVL(l_temp_inst_asset_rec.fa_book_type_code, fnd_api.g_miss_char) THEN
2285: l_ins_asset_hist_rec.old_fa_book_type_code := NULL;
2286: l_ins_asset_hist_rec.new_fa_book_type_code := NULL;
2287: ELSIF
2288: NVL(l_temp_inst_asset_rec.fa_book_type_code,fnd_api.g_miss_char) <> NVL(p_instance_asset_rec.fa_book_type_code,fnd_api.g_miss_char) THEN

Line 2288: NVL(l_temp_inst_asset_rec.fa_book_type_code,fnd_api.g_miss_char) <> NVL(p_instance_asset_rec.fa_book_type_code,fnd_api.g_miss_char) THEN

2284: NVL(p_instance_asset_rec.fa_book_type_code, fnd_api.g_miss_char) = NVL(l_temp_inst_asset_rec.fa_book_type_code, fnd_api.g_miss_char) THEN
2285: l_ins_asset_hist_rec.old_fa_book_type_code := NULL;
2286: l_ins_asset_hist_rec.new_fa_book_type_code := NULL;
2287: ELSIF
2288: NVL(l_temp_inst_asset_rec.fa_book_type_code,fnd_api.g_miss_char) <> NVL(p_instance_asset_rec.fa_book_type_code,fnd_api.g_miss_char) THEN
2289: l_ins_asset_hist_rec.old_fa_book_type_code := l_temp_inst_asset_rec.fa_book_type_code ;
2290: l_ins_asset_hist_rec.new_fa_book_type_code := p_instance_asset_rec.fa_book_type_code ;
2291: END IF;
2292: --

Line 2293: IF (p_instance_asset_rec.fa_location_id = fnd_api.g_miss_num) OR

2289: l_ins_asset_hist_rec.old_fa_book_type_code := l_temp_inst_asset_rec.fa_book_type_code ;
2290: l_ins_asset_hist_rec.new_fa_book_type_code := p_instance_asset_rec.fa_book_type_code ;
2291: END IF;
2292: --
2293: IF (p_instance_asset_rec.fa_location_id = fnd_api.g_miss_num) OR
2294: NVL(p_instance_asset_rec.fa_location_id, fnd_api.g_miss_num) = NVL(l_temp_inst_asset_rec.fa_location_id, fnd_api.g_miss_num) THEN
2295: l_ins_asset_hist_rec.old_fa_location_id := NULL;
2296: l_ins_asset_hist_rec.new_fa_location_id := NULL;
2297: ELSIF

Line 2294: NVL(p_instance_asset_rec.fa_location_id, fnd_api.g_miss_num) = NVL(l_temp_inst_asset_rec.fa_location_id, fnd_api.g_miss_num) THEN

2290: l_ins_asset_hist_rec.new_fa_book_type_code := p_instance_asset_rec.fa_book_type_code ;
2291: END IF;
2292: --
2293: IF (p_instance_asset_rec.fa_location_id = fnd_api.g_miss_num) OR
2294: NVL(p_instance_asset_rec.fa_location_id, fnd_api.g_miss_num) = NVL(l_temp_inst_asset_rec.fa_location_id, fnd_api.g_miss_num) THEN
2295: l_ins_asset_hist_rec.old_fa_location_id := NULL;
2296: l_ins_asset_hist_rec.new_fa_location_id := NULL;
2297: ELSIF
2298: NVL(l_temp_inst_asset_rec.fa_location_id,fnd_api.g_miss_num) <> NVL(p_instance_asset_rec.fa_location_id,fnd_api.g_miss_num) THEN

Line 2298: NVL(l_temp_inst_asset_rec.fa_location_id,fnd_api.g_miss_num) <> NVL(p_instance_asset_rec.fa_location_id,fnd_api.g_miss_num) THEN

2294: NVL(p_instance_asset_rec.fa_location_id, fnd_api.g_miss_num) = NVL(l_temp_inst_asset_rec.fa_location_id, fnd_api.g_miss_num) THEN
2295: l_ins_asset_hist_rec.old_fa_location_id := NULL;
2296: l_ins_asset_hist_rec.new_fa_location_id := NULL;
2297: ELSIF
2298: NVL(l_temp_inst_asset_rec.fa_location_id,fnd_api.g_miss_num) <> NVL(p_instance_asset_rec.fa_location_id,fnd_api.g_miss_num) THEN
2299: l_ins_asset_hist_rec.old_fa_location_id := l_temp_inst_asset_rec.fa_location_id ;
2300: l_ins_asset_hist_rec.new_fa_location_id := p_instance_asset_rec.fa_location_id ;
2301: END IF;
2302: --

Line 2303: IF (p_instance_asset_rec.update_status = fnd_api.g_miss_char) OR

2299: l_ins_asset_hist_rec.old_fa_location_id := l_temp_inst_asset_rec.fa_location_id ;
2300: l_ins_asset_hist_rec.new_fa_location_id := p_instance_asset_rec.fa_location_id ;
2301: END IF;
2302: --
2303: IF (p_instance_asset_rec.update_status = fnd_api.g_miss_char) OR
2304: NVL(p_instance_asset_rec.update_status, fnd_api.g_miss_char) = NVL(l_temp_inst_asset_rec.update_status, fnd_api.g_miss_char) THEN
2305: l_ins_asset_hist_rec.old_fa_book_type_code := NULL;
2306: l_ins_asset_hist_rec.new_fa_book_type_code := NULL;
2307: ELSIF

Line 2304: NVL(p_instance_asset_rec.update_status, fnd_api.g_miss_char) = NVL(l_temp_inst_asset_rec.update_status, fnd_api.g_miss_char) THEN

2300: l_ins_asset_hist_rec.new_fa_location_id := p_instance_asset_rec.fa_location_id ;
2301: END IF;
2302: --
2303: IF (p_instance_asset_rec.update_status = fnd_api.g_miss_char) OR
2304: NVL(p_instance_asset_rec.update_status, fnd_api.g_miss_char) = NVL(l_temp_inst_asset_rec.update_status, fnd_api.g_miss_char) THEN
2305: l_ins_asset_hist_rec.old_fa_book_type_code := NULL;
2306: l_ins_asset_hist_rec.new_fa_book_type_code := NULL;
2307: ELSIF
2308: NVL(l_temp_inst_asset_rec.update_status,fnd_api.g_miss_char) <> NVL(p_instance_asset_rec.update_status,fnd_api.g_miss_char) THEN

Line 2308: NVL(l_temp_inst_asset_rec.update_status,fnd_api.g_miss_char) <> NVL(p_instance_asset_rec.update_status,fnd_api.g_miss_char) THEN

2304: NVL(p_instance_asset_rec.update_status, fnd_api.g_miss_char) = NVL(l_temp_inst_asset_rec.update_status, fnd_api.g_miss_char) THEN
2305: l_ins_asset_hist_rec.old_fa_book_type_code := NULL;
2306: l_ins_asset_hist_rec.new_fa_book_type_code := NULL;
2307: ELSIF
2308: NVL(l_temp_inst_asset_rec.update_status,fnd_api.g_miss_char) <> NVL(p_instance_asset_rec.update_status,fnd_api.g_miss_char) THEN
2309: l_ins_asset_hist_rec.old_fa_book_type_code := l_temp_inst_asset_rec.update_status ;
2310: l_ins_asset_hist_rec.new_fa_book_type_code := p_instance_asset_rec.update_status ;
2311: END IF;
2312: --

Line 2313: IF (p_instance_asset_rec.active_start_date = fnd_api.g_miss_date) OR

2309: l_ins_asset_hist_rec.old_fa_book_type_code := l_temp_inst_asset_rec.update_status ;
2310: l_ins_asset_hist_rec.new_fa_book_type_code := p_instance_asset_rec.update_status ;
2311: END IF;
2312: --
2313: IF (p_instance_asset_rec.active_start_date = fnd_api.g_miss_date) OR
2314: NVL(p_instance_asset_rec.active_start_date, fnd_api.g_miss_date) = NVL(l_temp_inst_asset_rec.active_start_date, fnd_api.g_miss_date) THEN
2315: l_ins_asset_hist_rec.old_active_start_date := NULL;
2316: l_ins_asset_hist_rec.new_active_start_date := NULL;
2317: ELSIF

Line 2314: NVL(p_instance_asset_rec.active_start_date, fnd_api.g_miss_date) = NVL(l_temp_inst_asset_rec.active_start_date, fnd_api.g_miss_date) THEN

2310: l_ins_asset_hist_rec.new_fa_book_type_code := p_instance_asset_rec.update_status ;
2311: END IF;
2312: --
2313: IF (p_instance_asset_rec.active_start_date = fnd_api.g_miss_date) OR
2314: NVL(p_instance_asset_rec.active_start_date, fnd_api.g_miss_date) = NVL(l_temp_inst_asset_rec.active_start_date, fnd_api.g_miss_date) THEN
2315: l_ins_asset_hist_rec.old_active_start_date := NULL;
2316: l_ins_asset_hist_rec.new_active_start_date := NULL;
2317: ELSIF
2318: NVL(l_temp_inst_asset_rec.active_start_date,fnd_api.g_miss_date) <> NVL(p_instance_asset_rec.active_start_date,fnd_api.g_miss_date) THEN

Line 2318: NVL(l_temp_inst_asset_rec.active_start_date,fnd_api.g_miss_date) <> NVL(p_instance_asset_rec.active_start_date,fnd_api.g_miss_date) THEN

2314: NVL(p_instance_asset_rec.active_start_date, fnd_api.g_miss_date) = NVL(l_temp_inst_asset_rec.active_start_date, fnd_api.g_miss_date) THEN
2315: l_ins_asset_hist_rec.old_active_start_date := NULL;
2316: l_ins_asset_hist_rec.new_active_start_date := NULL;
2317: ELSIF
2318: NVL(l_temp_inst_asset_rec.active_start_date,fnd_api.g_miss_date) <> NVL(p_instance_asset_rec.active_start_date,fnd_api.g_miss_date) THEN
2319: l_ins_asset_hist_rec.old_active_start_date := l_temp_inst_asset_rec.active_start_date ;
2320: l_ins_asset_hist_rec.new_active_start_date := p_instance_asset_rec.active_start_date ;
2321: END IF;
2322: --

Line 2323: IF (p_instance_asset_rec.active_end_date = fnd_api.g_miss_date) OR

2319: l_ins_asset_hist_rec.old_active_start_date := l_temp_inst_asset_rec.active_start_date ;
2320: l_ins_asset_hist_rec.new_active_start_date := p_instance_asset_rec.active_start_date ;
2321: END IF;
2322: --
2323: IF (p_instance_asset_rec.active_end_date = fnd_api.g_miss_date) OR
2324: NVL(p_instance_asset_rec.active_end_date, fnd_api.g_miss_date) = NVL(l_temp_inst_asset_rec.active_end_date, fnd_api.g_miss_date) THEN
2325: l_ins_asset_hist_rec.old_active_end_date := NULL;
2326: l_ins_asset_hist_rec.new_active_end_date := NULL;
2327: ELSIF

Line 2324: NVL(p_instance_asset_rec.active_end_date, fnd_api.g_miss_date) = NVL(l_temp_inst_asset_rec.active_end_date, fnd_api.g_miss_date) THEN

2320: l_ins_asset_hist_rec.new_active_start_date := p_instance_asset_rec.active_start_date ;
2321: END IF;
2322: --
2323: IF (p_instance_asset_rec.active_end_date = fnd_api.g_miss_date) OR
2324: NVL(p_instance_asset_rec.active_end_date, fnd_api.g_miss_date) = NVL(l_temp_inst_asset_rec.active_end_date, fnd_api.g_miss_date) THEN
2325: l_ins_asset_hist_rec.old_active_end_date := NULL;
2326: l_ins_asset_hist_rec.new_active_end_date := NULL;
2327: ELSIF
2328: NVL(l_temp_inst_asset_rec.active_end_date,fnd_api.g_miss_date) <> NVL(p_instance_asset_rec.active_end_date,fnd_api.g_miss_date) THEN

Line 2328: NVL(l_temp_inst_asset_rec.active_end_date,fnd_api.g_miss_date) <> NVL(p_instance_asset_rec.active_end_date,fnd_api.g_miss_date) THEN

2324: NVL(p_instance_asset_rec.active_end_date, fnd_api.g_miss_date) = NVL(l_temp_inst_asset_rec.active_end_date, fnd_api.g_miss_date) THEN
2325: l_ins_asset_hist_rec.old_active_end_date := NULL;
2326: l_ins_asset_hist_rec.new_active_end_date := NULL;
2327: ELSIF
2328: NVL(l_temp_inst_asset_rec.active_end_date,fnd_api.g_miss_date) <> NVL(p_instance_asset_rec.active_end_date,fnd_api.g_miss_date) THEN
2329: l_ins_asset_hist_rec.old_active_end_date := l_temp_inst_asset_rec.active_end_date ;
2330: l_ins_asset_hist_rec.new_active_end_date := p_instance_asset_rec.active_end_date ;
2331: END IF;
2332: --

Line 2389: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2385: ,x_msg_count => x_msg_count
2386: ,x_msg_data => x_msg_data
2387: );
2388:
2389: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2390: FOR i in 1..x_msg_Count LOOP
2391: FND_MSG_PUB.Get(p_msg_index => i,
2392: p_encoded => 'F',
2393: p_data => x_msg_data,

Line 2396: RAISE fnd_api.g_exc_error;

2392: p_encoded => 'F',
2393: p_data => x_msg_data,
2394: p_msg_index_out => x_msg_index_out );
2395: End LOOP;
2396: RAISE fnd_api.g_exc_error;
2397: END IF;
2398:
2399: --
2400: -- End of API body

Line 2403: IF FND_API.To_Boolean( p_commit ) THEN

2399: --
2400: -- End of API body
2401:
2402: -- Standard check of p_commit.
2403: IF FND_API.To_Boolean( p_commit ) THEN
2404: COMMIT WORK;
2405: END IF;
2406:
2407: -- Standard call to get message count and if count is get message info.

Line 2412: WHEN FND_API.G_EXC_ERROR THEN

2408: FND_MSG_PUB.Count_And_Get(
2409: p_count => x_msg_count ,
2410: p_data => x_msg_data);
2411: EXCEPTION
2412: WHEN FND_API.G_EXC_ERROR THEN
2413: X_return_status := FND_API.G_RET_STS_ERROR ;
2414: IF fnd_api.to_boolean(p_commit) THEN
2415: ROLLBACK TO update_instance_asset_pvt;
2416: END IF;

Line 2413: X_return_status := FND_API.G_RET_STS_ERROR ;

2409: p_count => x_msg_count ,
2410: p_data => x_msg_data);
2411: EXCEPTION
2412: WHEN FND_API.G_EXC_ERROR THEN
2413: X_return_status := FND_API.G_RET_STS_ERROR ;
2414: IF fnd_api.to_boolean(p_commit) THEN
2415: ROLLBACK TO update_instance_asset_pvt;
2416: END IF;
2417: FND_MSG_PUB.Count_And_Get (

Line 2414: IF fnd_api.to_boolean(p_commit) THEN

2410: p_data => x_msg_data);
2411: EXCEPTION
2412: WHEN FND_API.G_EXC_ERROR THEN
2413: X_return_status := FND_API.G_RET_STS_ERROR ;
2414: IF fnd_api.to_boolean(p_commit) THEN
2415: ROLLBACK TO update_instance_asset_pvt;
2416: END IF;
2417: FND_MSG_PUB.Count_And_Get (
2418: p_count => x_msg_count,

Line 2420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2416: END IF;
2417: FND_MSG_PUB.Count_And_Get (
2418: p_count => x_msg_count,
2419: p_data => x_msg_data);
2420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2421: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2422: IF fnd_api.to_boolean(p_commit) THEN
2423: ROLLBACK TO update_instance_asset_pvt;
2424: END IF;

Line 2421: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2417: FND_MSG_PUB.Count_And_Get (
2418: p_count => x_msg_count,
2419: p_data => x_msg_data);
2420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2421: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2422: IF fnd_api.to_boolean(p_commit) THEN
2423: ROLLBACK TO update_instance_asset_pvt;
2424: END IF;
2425: FND_MSG_PUB.Count_And_Get(

Line 2422: IF fnd_api.to_boolean(p_commit) THEN

2418: p_count => x_msg_count,
2419: p_data => x_msg_data);
2420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2421: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2422: IF fnd_api.to_boolean(p_commit) THEN
2423: ROLLBACK TO update_instance_asset_pvt;
2424: END IF;
2425: FND_MSG_PUB.Count_And_Get(
2426: p_count => x_msg_count,

Line 2429: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2425: FND_MSG_PUB.Count_And_Get(
2426: p_count => x_msg_count,
2427: p_data => x_msg_data);
2428: WHEN OTHERS THEN
2429: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2430: IF fnd_api.to_boolean(p_commit) THEN
2431: ROLLBACK TO update_instance_asset_pvt;
2432: END IF;
2433: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 2430: IF fnd_api.to_boolean(p_commit) THEN

2426: p_count => x_msg_count,
2427: p_data => x_msg_data);
2428: WHEN OTHERS THEN
2429: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2430: IF fnd_api.to_boolean(p_commit) THEN
2431: ROLLBACK TO update_instance_asset_pvt;
2432: END IF;
2433: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2434: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );

Line 2500: IF fnd_api.to_boolean(p_commit)

2496: l_temp_asset_rec csi_datastructures_pub.ins_asset_history_rec;
2497: i NUMBER :=0 ;
2498: BEGIN
2499: /*
2500: IF fnd_api.to_boolean(p_commit)
2501: THEN
2502: SAVEPOINT get_instance_asset_hist;
2503: END IF;
2504: */

Line 2507: IF NOT FND_API.Compatible_API_Call (l_api_version ,

2503: END IF;
2504: */
2505:
2506: -- Standard call to check for call compatibility.
2507: IF NOT FND_API.Compatible_API_Call (l_api_version ,
2508: p_api_version ,
2509: l_api_name ,
2510: G_PKG_NAME )
2511: THEN

Line 2512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2508: p_api_version ,
2509: l_api_name ,
2510: G_PKG_NAME )
2511: THEN
2512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2513: END IF;
2514:
2515: -- Initialize message list if p_init_msg_list is set to TRUE.
2516: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2516: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2513: END IF;
2514:
2515: -- Initialize message list if p_init_msg_list is set to TRUE.
2516: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2517: FND_MSG_PUB.initialize;
2518: END IF;
2519:
2520: -- Initialize API return status to success

Line 2521: x_return_status := FND_API.G_RET_STS_SUCCESS;

2517: FND_MSG_PUB.initialize;
2518: END IF;
2519:
2520: -- Initialize API return status to success
2521: x_return_status := FND_API.G_RET_STS_SUCCESS;
2522:
2523: /***** srramakr commented for bug # 3304439
2524: -- Check for the profile option and enable trace
2525: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN

Line 2541: IF NVL(l_asset_hist_csr.old_instance_id,fnd_api.g_miss_num) = NVL(l_asset_hist_csr.new_instance_id,fnd_api.g_miss_num)

2537: l_ins_asset_rec:=l_temp_asset_rec;
2538:
2539:
2540: --
2541: IF NVL(l_asset_hist_csr.old_instance_id,fnd_api.g_miss_num) = NVL(l_asset_hist_csr.new_instance_id,fnd_api.g_miss_num)
2542: THEN
2543: l_old_ins_asset_rec.instance_id := NULL;
2544: l_new_ins_asset_rec.instance_id := NULL;
2545: ELSE

Line 2550: IF NVL(l_asset_hist_csr.old_fa_asset_id,fnd_api.g_miss_num) = NVL(l_asset_hist_csr.new_fa_asset_id,fnd_api.g_miss_num)

2546: l_old_ins_asset_rec.instance_id := l_asset_hist_csr.old_instance_id;
2547: l_new_ins_asset_rec.instance_id := l_asset_hist_csr.new_instance_id;
2548: END IF;
2549: --
2550: IF NVL(l_asset_hist_csr.old_fa_asset_id,fnd_api.g_miss_num) = NVL(l_asset_hist_csr.new_fa_asset_id,fnd_api.g_miss_num)
2551: THEN
2552: l_old_ins_asset_rec.fa_asset_id := NULL;
2553: l_new_ins_asset_rec.fa_asset_id := NULL;
2554: ELSE

Line 2559: IF NVL(l_asset_hist_csr.old_fa_book_type_code,fnd_api.g_miss_char) = NVL(l_asset_hist_csr.new_fa_book_type_code,fnd_api.g_miss_char)

2555: l_old_ins_asset_rec.fa_asset_id := l_asset_hist_csr.old_fa_asset_id;
2556: l_new_ins_asset_rec.fa_asset_id := l_asset_hist_csr.new_fa_asset_id;
2557: END IF;
2558: --
2559: IF NVL(l_asset_hist_csr.old_fa_book_type_code,fnd_api.g_miss_char) = NVL(l_asset_hist_csr.new_fa_book_type_code,fnd_api.g_miss_char)
2560: THEN
2561: l_old_ins_asset_rec.fa_book_type_code := NULL;
2562: l_new_ins_asset_rec.fa_book_type_code := NULL;
2563: ELSE

Line 2568: IF NVL(l_asset_hist_csr.old_fa_location_id,fnd_api.g_miss_num) = NVL(l_asset_hist_csr.new_fa_location_id,fnd_api.g_miss_num)

2564: l_old_ins_asset_rec.fa_book_type_code := l_asset_hist_csr.old_fa_book_type_code;
2565: l_new_ins_asset_rec.fa_book_type_code := l_asset_hist_csr.new_fa_book_type_code;
2566: END IF;
2567: --
2568: IF NVL(l_asset_hist_csr.old_fa_location_id,fnd_api.g_miss_num) = NVL(l_asset_hist_csr.new_fa_location_id,fnd_api.g_miss_num)
2569: THEN
2570: l_old_ins_asset_rec.fa_location_id := NULL;
2571: l_new_ins_asset_rec.fa_location_id := NULL;
2572: ELSE

Line 2577: IF NVL(l_asset_hist_csr.old_asset_quantity,fnd_api.g_miss_num) = NVL(l_asset_hist_csr.new_asset_quantity,fnd_api.g_miss_num)

2573: l_old_ins_asset_rec.fa_location_id := l_asset_hist_csr.old_fa_location_id;
2574: l_new_ins_asset_rec.fa_location_id := l_asset_hist_csr.new_fa_location_id;
2575: END IF;
2576: --
2577: IF NVL(l_asset_hist_csr.old_asset_quantity,fnd_api.g_miss_num) = NVL(l_asset_hist_csr.new_asset_quantity,fnd_api.g_miss_num)
2578: THEN
2579: l_old_ins_asset_rec.asset_quantity := NULL;
2580: l_new_ins_asset_rec.asset_quantity := NULL;
2581: ELSE

Line 2586: IF NVL(l_asset_hist_csr.old_update_status,fnd_api.g_miss_char) = NVL(l_asset_hist_csr.new_update_status,fnd_api.g_miss_char)

2582: l_old_ins_asset_rec.asset_quantity := l_asset_hist_csr.old_asset_quantity;
2583: l_new_ins_asset_rec.asset_quantity := l_asset_hist_csr.new_asset_quantity;
2584: END IF;
2585: --
2586: IF NVL(l_asset_hist_csr.old_update_status,fnd_api.g_miss_char) = NVL(l_asset_hist_csr.new_update_status,fnd_api.g_miss_char)
2587: THEN
2588: l_old_ins_asset_rec.update_status := NULL;
2589: l_new_ins_asset_rec.update_status := NULL;
2590: ELSE

Line 2595: IF NVL(l_asset_hist_csr.old_active_start_date,fnd_api.g_miss_date) = NVL(l_asset_hist_csr.new_active_start_date,fnd_api.g_miss_date)

2591: l_old_ins_asset_rec.update_status := l_asset_hist_csr.old_update_status;
2592: l_new_ins_asset_rec.update_status := l_asset_hist_csr.new_update_status;
2593: END IF;
2594: --
2595: IF NVL(l_asset_hist_csr.old_active_start_date,fnd_api.g_miss_date) = NVL(l_asset_hist_csr.new_active_start_date,fnd_api.g_miss_date)
2596: THEN
2597: l_old_ins_asset_rec.active_start_date := NULL;
2598: l_new_ins_asset_rec.active_start_date := NULL;
2599: ELSE

Line 2604: IF NVL(l_asset_hist_csr.old_active_end_date,fnd_api.g_miss_date) = NVL(l_asset_hist_csr.new_active_end_date,fnd_api.g_miss_date)

2600: l_old_ins_asset_rec.active_start_date := l_asset_hist_csr.old_active_start_date;
2601: l_new_ins_asset_rec.active_start_date := l_asset_hist_csr.new_active_start_date;
2602: END IF;
2603: --
2604: IF NVL(l_asset_hist_csr.old_active_end_date,fnd_api.g_miss_date) = NVL(l_asset_hist_csr.new_active_end_date,fnd_api.g_miss_date)
2605: THEN
2606: l_old_ins_asset_rec.active_end_date := NULL;
2607: l_new_ins_asset_rec.active_end_date := NULL;
2608: ELSE

Line 2626: IF NVL(l_old_ins_asset_rec.asset_number,fnd_api.g_miss_char) = NVL(l_new_ins_asset_rec.asset_number,fnd_api.g_miss_char)

2622: (p_asset_header_tbl => l_new_ins_asset_tbl);
2623: l_new_ins_asset_rec:=l_new_ins_asset_tbl(1);
2624:
2625: --
2626: IF NVL(l_old_ins_asset_rec.asset_number,fnd_api.g_miss_char) = NVL(l_new_ins_asset_rec.asset_number,fnd_api.g_miss_char)
2627: THEN
2628: l_old_ins_asset_rec.asset_number := NULL;
2629: l_new_ins_asset_rec.asset_number := NULL;
2630: END IF;

Line 2632: IF NVL(l_old_ins_asset_rec.serial_number,fnd_api.g_miss_char) = NVL(l_new_ins_asset_rec.serial_number,fnd_api.g_miss_char)

2628: l_old_ins_asset_rec.asset_number := NULL;
2629: l_new_ins_asset_rec.asset_number := NULL;
2630: END IF;
2631: --
2632: IF NVL(l_old_ins_asset_rec.serial_number,fnd_api.g_miss_char) = NVL(l_new_ins_asset_rec.serial_number,fnd_api.g_miss_char)
2633: THEN
2634: l_old_ins_asset_rec.serial_number := NULL;
2635: l_new_ins_asset_rec.serial_number := NULL;
2636: END IF;

Line 2638: IF NVL(l_old_ins_asset_rec.tag_number,fnd_api.g_miss_char) = NVL(l_new_ins_asset_rec.tag_number,fnd_api.g_miss_char)

2634: l_old_ins_asset_rec.serial_number := NULL;
2635: l_new_ins_asset_rec.serial_number := NULL;
2636: END IF;
2637: --
2638: IF NVL(l_old_ins_asset_rec.tag_number,fnd_api.g_miss_char) = NVL(l_new_ins_asset_rec.tag_number,fnd_api.g_miss_char)
2639: THEN
2640: l_old_ins_asset_rec.tag_number := NULL;
2641: l_new_ins_asset_rec.tag_number := NULL;
2642: END IF;

Line 2644: IF NVL(l_old_ins_asset_rec.category,fnd_api.g_miss_char) = NVL(l_new_ins_asset_rec.category,fnd_api.g_miss_char)

2640: l_old_ins_asset_rec.tag_number := NULL;
2641: l_new_ins_asset_rec.tag_number := NULL;
2642: END IF;
2643: --
2644: IF NVL(l_old_ins_asset_rec.category,fnd_api.g_miss_char) = NVL(l_new_ins_asset_rec.category,fnd_api.g_miss_char)
2645: THEN
2646: l_old_ins_asset_rec.category := NULL;
2647: l_new_ins_asset_rec.category := NULL;
2648: END IF;

Line 2650: IF NVL(l_old_ins_asset_rec.fa_location_segment1,fnd_api.g_miss_char) = NVL(l_new_ins_asset_rec.fa_location_segment1,fnd_api.g_miss_char)

2646: l_old_ins_asset_rec.category := NULL;
2647: l_new_ins_asset_rec.category := NULL;
2648: END IF;
2649: --
2650: IF NVL(l_old_ins_asset_rec.fa_location_segment1,fnd_api.g_miss_char) = NVL(l_new_ins_asset_rec.fa_location_segment1,fnd_api.g_miss_char)
2651: THEN
2652: l_old_ins_asset_rec.fa_location_segment1 := NULL;
2653: l_new_ins_asset_rec.fa_location_segment1 := NULL;
2654: END IF;

Line 2656: IF NVL(l_old_ins_asset_rec.fa_location_segment2,fnd_api.g_miss_char) = NVL(l_new_ins_asset_rec.fa_location_segment2,fnd_api.g_miss_char)

2652: l_old_ins_asset_rec.fa_location_segment1 := NULL;
2653: l_new_ins_asset_rec.fa_location_segment1 := NULL;
2654: END IF;
2655: --
2656: IF NVL(l_old_ins_asset_rec.fa_location_segment2,fnd_api.g_miss_char) = NVL(l_new_ins_asset_rec.fa_location_segment2,fnd_api.g_miss_char)
2657: THEN
2658: l_old_ins_asset_rec.fa_location_segment2 := NULL;
2659: l_new_ins_asset_rec.fa_location_segment2 := NULL;
2660: END IF;

Line 2662: IF NVL(l_old_ins_asset_rec.fa_location_segment3,fnd_api.g_miss_char) = NVL(l_new_ins_asset_rec.fa_location_segment3,fnd_api.g_miss_char)

2658: l_old_ins_asset_rec.fa_location_segment2 := NULL;
2659: l_new_ins_asset_rec.fa_location_segment2 := NULL;
2660: END IF;
2661: --
2662: IF NVL(l_old_ins_asset_rec.fa_location_segment3,fnd_api.g_miss_char) = NVL(l_new_ins_asset_rec.fa_location_segment3,fnd_api.g_miss_char)
2663: THEN
2664: l_old_ins_asset_rec.fa_location_segment3 := NULL;
2665: l_new_ins_asset_rec.fa_location_segment3 := NULL;
2666: END IF;

Line 2668: IF NVL(l_old_ins_asset_rec.fa_location_segment4,fnd_api.g_miss_char) = NVL(l_new_ins_asset_rec.fa_location_segment4,fnd_api.g_miss_char)

2664: l_old_ins_asset_rec.fa_location_segment3 := NULL;
2665: l_new_ins_asset_rec.fa_location_segment3 := NULL;
2666: END IF;
2667: --
2668: IF NVL(l_old_ins_asset_rec.fa_location_segment4,fnd_api.g_miss_char) = NVL(l_new_ins_asset_rec.fa_location_segment4,fnd_api.g_miss_char)
2669: THEN
2670: l_old_ins_asset_rec.fa_location_segment4 := NULL;
2671: l_new_ins_asset_rec.fa_location_segment4 := NULL;
2672: END IF;

Line 2674: IF NVL(l_old_ins_asset_rec.fa_location_segment5,fnd_api.g_miss_char) = NVL(l_new_ins_asset_rec.fa_location_segment5,fnd_api.g_miss_char)

2670: l_old_ins_asset_rec.fa_location_segment4 := NULL;
2671: l_new_ins_asset_rec.fa_location_segment4 := NULL;
2672: END IF;
2673: --
2674: IF NVL(l_old_ins_asset_rec.fa_location_segment5,fnd_api.g_miss_char) = NVL(l_new_ins_asset_rec.fa_location_segment5,fnd_api.g_miss_char)
2675: THEN
2676: l_old_ins_asset_rec.fa_location_segment5 := NULL;
2677: l_new_ins_asset_rec.fa_location_segment5 := NULL;
2678: END IF;

Line 2680: IF NVL(l_old_ins_asset_rec.fa_location_segment6,fnd_api.g_miss_char) = NVL(l_new_ins_asset_rec.fa_location_segment6,fnd_api.g_miss_char)

2676: l_old_ins_asset_rec.fa_location_segment5 := NULL;
2677: l_new_ins_asset_rec.fa_location_segment5 := NULL;
2678: END IF;
2679: --
2680: IF NVL(l_old_ins_asset_rec.fa_location_segment6,fnd_api.g_miss_char) = NVL(l_new_ins_asset_rec.fa_location_segment6,fnd_api.g_miss_char)
2681: THEN
2682: l_old_ins_asset_rec.fa_location_segment6 := NULL;
2683: l_new_ins_asset_rec.fa_location_segment6 := NULL;
2684: END IF;

Line 2686: IF NVL(l_old_ins_asset_rec.fa_location_segment7,fnd_api.g_miss_char) = NVL(l_new_ins_asset_rec.fa_location_segment7,fnd_api.g_miss_char)

2682: l_old_ins_asset_rec.fa_location_segment6 := NULL;
2683: l_new_ins_asset_rec.fa_location_segment6 := NULL;
2684: END IF;
2685: --
2686: IF NVL(l_old_ins_asset_rec.fa_location_segment7,fnd_api.g_miss_char) = NVL(l_new_ins_asset_rec.fa_location_segment7,fnd_api.g_miss_char)
2687: THEN
2688: l_old_ins_asset_rec.fa_location_segment7 := NULL;
2689: l_new_ins_asset_rec.fa_location_segment7 := NULL;
2690: END IF;

Line 2692: IF NVL(l_old_ins_asset_rec.date_placed_in_service,fnd_api.g_miss_date) = NVL(l_new_ins_asset_rec.date_placed_in_service,fnd_api.g_miss_date)

2688: l_old_ins_asset_rec.fa_location_segment7 := NULL;
2689: l_new_ins_asset_rec.fa_location_segment7 := NULL;
2690: END IF;
2691: --
2692: IF NVL(l_old_ins_asset_rec.date_placed_in_service,fnd_api.g_miss_date) = NVL(l_new_ins_asset_rec.date_placed_in_service,fnd_api.g_miss_date)
2693: THEN
2694: l_old_ins_asset_rec.date_placed_in_service := NULL;
2695: l_new_ins_asset_rec.date_placed_in_service := NULL;
2696: END IF;

Line 2698: IF NVL(l_old_ins_asset_rec.description,fnd_api.g_miss_char) = NVL(l_new_ins_asset_rec.description,fnd_api.g_miss_char)

2694: l_old_ins_asset_rec.date_placed_in_service := NULL;
2695: l_new_ins_asset_rec.date_placed_in_service := NULL;
2696: END IF;
2697: --
2698: IF NVL(l_old_ins_asset_rec.description,fnd_api.g_miss_char) = NVL(l_new_ins_asset_rec.description,fnd_api.g_miss_char)
2699: THEN
2700: l_old_ins_asset_rec.description := NULL;
2701: l_new_ins_asset_rec.description := NULL;
2702: END IF;

Line 2704: IF NVL(l_old_ins_asset_rec.employee_name,fnd_api.g_miss_char) = NVL(l_new_ins_asset_rec.employee_name,fnd_api.g_miss_char)

2700: l_old_ins_asset_rec.description := NULL;
2701: l_new_ins_asset_rec.description := NULL;
2702: END IF;
2703: --
2704: IF NVL(l_old_ins_asset_rec.employee_name,fnd_api.g_miss_char) = NVL(l_new_ins_asset_rec.employee_name,fnd_api.g_miss_char)
2705: THEN
2706: l_old_ins_asset_rec.employee_name := NULL;
2707: l_new_ins_asset_rec.employee_name := NULL;
2708: END IF;

Line 2710: IF NVL(l_old_ins_asset_rec.expense_account_number,fnd_api.g_miss_char) = NVL(l_new_ins_asset_rec.expense_account_number,fnd_api.g_miss_char)

2706: l_old_ins_asset_rec.employee_name := NULL;
2707: l_new_ins_asset_rec.employee_name := NULL;
2708: END IF;
2709: --
2710: IF NVL(l_old_ins_asset_rec.expense_account_number,fnd_api.g_miss_char) = NVL(l_new_ins_asset_rec.expense_account_number,fnd_api.g_miss_char)
2711: THEN
2712: l_old_ins_asset_rec.expense_account_number := NULL;
2713: l_new_ins_asset_rec.expense_account_number := NULL;
2714: END IF;

Line 2777: IF FND_API.To_Boolean( p_commit ) THEN

2773: -- End of API body
2774:
2775: -- Standard check of p_commit.
2776: /*
2777: IF FND_API.To_Boolean( p_commit ) THEN
2778: COMMIT WORK;
2779: END IF;
2780: */
2781:

Line 2796: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2792: (p_count => x_msg_count ,
2793: p_data => x_msg_data );
2794: EXCEPTION
2795: WHEN OTHERS THEN
2796: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2797: /*
2798: IF fnd_api.to_boolean(p_commit)
2799: THEN
2800: ROLLBACK TO get_instance_asset_hist;

Line 2798: IF fnd_api.to_boolean(p_commit)

2794: EXCEPTION
2795: WHEN OTHERS THEN
2796: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2797: /*
2798: IF fnd_api.to_boolean(p_commit)
2799: THEN
2800: ROLLBACK TO get_instance_asset_hist;
2801: END IF;
2802: */

Line 2823: l_Sync_Flag VARCHAR2(1) := FND_API.G_TRUE;

2819: x_error_msg OUT NOCOPY VARCHAR2,
2820: x_return_status OUT NOCOPY VARCHAR2
2821: ) IS
2822: l_fa_asset_sync_tbl csi_asset_pvt.fa_asset_sync_tbl;
2823: l_Sync_Flag VARCHAR2(1) := FND_API.G_TRUE;
2824: l_location_id NUMBER := 0;
2825: l_fa_location_id NUMBER := 0;
2826: l_CSI_DEBUG_LEVEL NUMBER;
2827:

Line 2834: x_return_status := FND_API.G_RET_STS_SUCCESS ;

2830: FROM csi_a_locations
2831: WHERE location_id = l_inst_location_id;
2832:
2833: BEGIN
2834: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2835: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
2836: l_CSI_DEBUG_LEVEL:=fnd_profile.value('CSI_DEBUG_LEVEL');
2837: IF px_instance_sync_tbl.count = 0 OR px_instance_asset_sync_tbl.count = 0 OR
2838: px_fa_asset_sync_tbl.count = 0 THEN

Line 2840: RAISE fnd_api.g_exc_error;

2836: l_CSI_DEBUG_LEVEL:=fnd_profile.value('CSI_DEBUG_LEVEL');
2837: IF px_instance_sync_tbl.count = 0 OR px_instance_asset_sync_tbl.count = 0 OR
2838: px_fa_asset_sync_tbl.count = 0 THEN
2839: x_error_msg := 'Invalid Parameters';
2840: RAISE fnd_api.g_exc_error;
2841: END IF;
2842: /*-- Cursor on instance-asset pl/sql table --*/
2843:
2844: IF px_instance_asset_sync_tbl.count > 0 THEN

Line 2858: IF px_fa_asset_sync_tbl(c_fa_asset_rec).sync_up_quantity = FND_API.G_MISS_NUM THEN

2854: px_instance_asset_sync_tbl(c_inst_asset_rec).fa_asset_id AND
2855: px_fa_asset_sync_tbl(c_fa_asset_rec).fa_location_id =
2856: px_instance_asset_sync_tbl(c_inst_asset_rec).fa_location_id THEN
2857: /*-- Accumulating matching asset quantity in sync up qty --*/
2858: IF px_fa_asset_sync_tbl(c_fa_asset_rec).sync_up_quantity = FND_API.G_MISS_NUM THEN
2859: px_fa_asset_sync_tbl(c_fa_asset_rec).sync_up_quantity :=
2860: nvl(px_instance_asset_sync_tbl(c_inst_asset_rec).inst_asset_quantity,0);
2861: ELSE
2862: px_fa_asset_sync_tbl(c_fa_asset_rec).sync_up_quantity :=

Line 2869: l_Sync_Flag := FND_API.G_FALSE;

2865: END IF;
2866: /*-- Validating Accumulated sync qty should not be more than Fa asset qty --*/
2867: IF px_fa_asset_sync_tbl(c_fa_asset_rec).sync_up_quantity >
2868: px_fa_asset_sync_tbl(c_fa_asset_rec).fa_asset_quantity THEN
2869: l_Sync_Flag := FND_API.G_FALSE;
2870: END IF;
2871: END IF;
2872: END LOOP;
2873: END IF;

Line 2884: IF px_instance_sync_tbl(c_inst_rec).sync_up_quantity = FND_API.G_MISS_NUM THEN

2880: px_instance_asset_sync_tbl(c_inst_asset_rec).instance_id ) OR
2881: (px_instance_sync_tbl(c_inst_rec).inst_interface_id =
2882: px_instance_asset_sync_tbl(c_inst_asset_rec).inst_interface_id ) THEN
2883: /*-- Accumulating matching instance quantity in sync up qty --*/
2884: IF px_instance_sync_tbl(c_inst_rec).sync_up_quantity = FND_API.G_MISS_NUM THEN
2885: px_instance_sync_tbl(c_inst_rec).sync_up_quantity :=
2886: px_instance_asset_sync_tbl(c_inst_asset_rec).inst_asset_quantity;
2887: ELSE
2888: px_instance_sync_tbl(c_inst_rec).sync_up_quantity :=

Line 2930: l_Sync_Flag := FND_API.G_FALSE;

2926: IF (px_instance_sync_tbl(c_inst_rec).sync_up_quantity >
2927: px_instance_sync_tbl(c_inst_rec).instance_quantity ) OR
2928: (px_instance_asset_sync_tbl(c_inst_asset_rec).fa_location_id
2929: <> NVL(l_fa_location_id,0) ) THEN
2930: l_Sync_Flag := FND_API.G_FALSE;
2931: END IF;
2932: END IF;
2933: END LOOP;
2934: END IF;

Line 2944: l_Sync_Flag := FND_API.G_FALSE;

2940: LOOP
2941: */ /*-- Validating all Fa asset qty is matched/sync --*/
2942: /* IF px_fa_asset_sync_tbl(c_fa_asset_rec).sync_up_quantity <>
2943: px_fa_asset_sync_tbl(c_fa_asset_rec).fa_asset_quantity THEN
2944: l_Sync_Flag := FND_API.G_FALSE;
2945: END IF;
2946: END LOOP;
2947: */
2948: /*-- Cursor on Item Instance pl/sql table --*/

Line 2954: l_Sync_Flag := FND_API.G_FALSE;

2950: LOOP
2951: /*-- Validating All Instance qty is matched/sync --*/
2952: IF px_instance_sync_tbl(c_inst_rec).sync_up_quantity <>
2953: px_instance_sync_tbl(c_inst_rec).instance_quantity THEN
2954: l_Sync_Flag := FND_API.G_FALSE;
2955: END IF;
2956: END LOOP;
2957: /*-- Cursor on Item Instance pl/sql table --*/
2958: FOR c_inst_rec IN px_instance_sync_tbl.FIRST .. px_instance_sync_tbl.LAST

Line 2961: IF l_Sync_Flag = FND_API.G_FALSE THEN

2957: /*-- Cursor on Item Instance pl/sql table --*/
2958: FOR c_inst_rec IN px_instance_sync_tbl.FIRST .. px_instance_sync_tbl.LAST
2959: LOOP
2960: /*-- If All Assets/Item Instances are in sync then set vld flag as S else E --*/
2961: IF l_Sync_Flag = FND_API.G_FALSE THEN
2962: px_instance_sync_tbl(c_inst_rec).vld_status := 'E';
2963: ELSE
2964: px_instance_sync_tbl(c_inst_rec).vld_status := 'S';
2965: END IF;

Line 2968: WHEN fnd_api.g_exc_error THEN

2964: px_instance_sync_tbl(c_inst_rec).vld_status := 'S';
2965: END IF;
2966: END LOOP;
2967: EXCEPTION
2968: WHEN fnd_api.g_exc_error THEN
2969: x_return_status := FND_API.G_RET_STS_ERROR ;
2970: END asset_syncup_validation;
2971:
2972: PROCEDURE get_attached_item_instances

Line 2969: x_return_status := FND_API.G_RET_STS_ERROR ;

2965: END IF;
2966: END LOOP;
2967: EXCEPTION
2968: WHEN fnd_api.g_exc_error THEN
2969: x_return_status := FND_API.G_RET_STS_ERROR ;
2970: END asset_syncup_validation;
2971:
2972: PROCEDURE get_attached_item_instances
2973: ( p_api_version IN NUMBER,

Line 2981: p_called_from_grp IN VARCHAR2 DEFAULT fnd_api.g_false

2977: x_return_status OUT NOCOPY VARCHAR2,
2978: x_msg_count OUT NOCOPY NUMBER,
2979: x_msg_data OUT NOCOPY VARCHAR2,
2980: p_source_system_name IN VARCHAR2 DEFAULT NULL,
2981: p_called_from_grp IN VARCHAR2 DEFAULT fnd_api.g_false
2982: ) IS
2983: TYPE num_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
2984: TYPE char_tbl IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
2985: l_instance_tbl num_tbl;

Line 3030: IF NOT FND_API.Compatible_API_Call (l_api_version ,

3026: AND c.source_system_name = nvl(p_source_system_name ,c.source_system_name)) ;
3027:
3028: BEGIN
3029: -- Standard call to check for call compatibility.
3030: IF NOT FND_API.Compatible_API_Call (l_api_version ,
3031: p_api_version ,
3032: l_api_name ,
3033: G_PKG_NAME )
3034: THEN

Line 3035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3031: p_api_version ,
3032: l_api_name ,
3033: G_PKG_NAME )
3034: THEN
3035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3036: END IF;
3037: -- Initialize message list if p_init_msg_list is set to TRUE.
3038: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3039: FND_MSG_PUB.initialize;

Line 3038: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3034: THEN
3035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3036: END IF;
3037: -- Initialize message list if p_init_msg_list is set to TRUE.
3038: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3039: FND_MSG_PUB.initialize;
3040: END IF;
3041: -- Initialize API return status to success
3042: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3042: x_return_status := FND_API.G_RET_STS_SUCCESS;

3038: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3039: FND_MSG_PUB.initialize;
3040: END IF;
3041: -- Initialize API return status to success
3042: x_return_status := FND_API.G_RET_STS_SUCCESS;
3043: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
3044: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
3045: -- If csi_debug_level = 1 then dump the procedure name
3046: IF (l_csi_debug_level > 0) THEN

Line 3059: RAISE FND_API.G_EXC_ERROR;

3055: -- Validate asset pl/sql table of records is not null
3056: IF p_instance_asset_sync_tbl.count = 0 THEN
3057: IF (l_csi_debug_level > 0) THEN
3058: debug( 'Asset table of records not provided as input parameter');
3059: RAISE FND_API.G_EXC_ERROR;
3060: END IF;
3061: END IF;
3062:
3063: FOR inst_asst_rec IN p_instance_asset_sync_tbl.FIRST..p_instance_asset_sync_tbl.LAST

Line 3067: IF p_called_from_grp = fnd_api.g_true THEN

3063: FOR inst_asst_rec IN p_instance_asset_sync_tbl.FIRST..p_instance_asset_sync_tbl.LAST
3064: LOOP
3065: IF p_instance_asset_sync_tbl.exists( inst_asst_rec ) THEN
3066:
3067: IF p_called_from_grp = fnd_api.g_true THEN
3068:
3069: OPEN c_interf_instance(
3070: p_instance_asset_sync_tbl(inst_asst_rec).fa_asset_id , -- :1
3071: p_instance_asset_sync_tbl(inst_asst_rec).fa_location_id,-- :2

Line 3123: WHEN FND_API.G_EXC_ERROR THEN

3119: END IF;
3120: END LOOP;
3121:
3122: EXCEPTION
3123: WHEN FND_API.G_EXC_ERROR THEN
3124: x_return_status := FND_API.G_RET_STS_ERROR ;
3125: FND_MSG_PUB.Count_And_Get
3126: ( p_count => x_msg_count,
3127: p_data => x_msg_data );

Line 3124: x_return_status := FND_API.G_RET_STS_ERROR ;

3120: END LOOP;
3121:
3122: EXCEPTION
3123: WHEN FND_API.G_EXC_ERROR THEN
3124: x_return_status := FND_API.G_RET_STS_ERROR ;
3125: FND_MSG_PUB.Count_And_Get
3126: ( p_count => x_msg_count,
3127: p_data => x_msg_data );
3128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3124: x_return_status := FND_API.G_RET_STS_ERROR ;
3125: FND_MSG_PUB.Count_And_Get
3126: ( p_count => x_msg_count,
3127: p_data => x_msg_data );
3128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3130: FND_MSG_PUB.Count_And_Get
3131: ( p_count => x_msg_count,
3132: p_data => x_msg_data );

Line 3129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3125: FND_MSG_PUB.Count_And_Get
3126: ( p_count => x_msg_count,
3127: p_data => x_msg_data );
3128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3130: FND_MSG_PUB.Count_And_Get
3131: ( p_count => x_msg_count,
3132: p_data => x_msg_data );
3133: WHEN OTHERS THEN

Line 3134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3130: FND_MSG_PUB.Count_And_Get
3131: ( p_count => x_msg_count,
3132: p_data => x_msg_data );
3133: WHEN OTHERS THEN
3134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3135: IF FND_MSG_PUB.Check_Msg_Level
3136: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3137: THEN
3138: FND_MSG_PUB.Add_Exc_Msg

Line 3157: p_called_from_grp IN VARCHAR2 DEFAULT fnd_api.g_false

3153: x_return_status OUT NOCOPY VARCHAR2,
3154: x_msg_count OUT NOCOPY NUMBER,
3155: x_msg_data OUT NOCOPY VARCHAR2,
3156: p_source_system_name IN VARCHAR2 DEFAULT NULL,
3157: p_called_from_grp IN VARCHAR2 DEFAULT fnd_api.g_false
3158: ) IS
3159: TYPE num_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
3160: l_fa_asset_id_tbl num_tbl;
3161: l_fa_asset_loc_id_tbl num_tbl;

Line 3204: IF NOT FND_API.Compatible_API_Call (l_api_version ,

3200: AND c.fa_location_id = b.fa_location_id );
3201:
3202: BEGIN
3203: -- Standard call to check for call compatibility.
3204: IF NOT FND_API.Compatible_API_Call (l_api_version ,
3205: p_api_version ,
3206: l_api_name ,
3207: G_PKG_NAME )
3208: THEN

Line 3209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3205: p_api_version ,
3206: l_api_name ,
3207: G_PKG_NAME )
3208: THEN
3209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3210: END IF;
3211: -- Initialize message list if p_init_msg_list is set to TRUE.
3212: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3213: FND_MSG_PUB.initialize;

Line 3212: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3208: THEN
3209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3210: END IF;
3211: -- Initialize message list if p_init_msg_list is set to TRUE.
3212: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3213: FND_MSG_PUB.initialize;
3214: END IF;
3215: -- Initialize API return status to success
3216: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3216: x_return_status := FND_API.G_RET_STS_SUCCESS;

3212: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3213: FND_MSG_PUB.initialize;
3214: END IF;
3215: -- Initialize API return status to success
3216: x_return_status := FND_API.G_RET_STS_SUCCESS;
3217: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
3218: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
3219: -- If csi_debug_level = 1 then dump the procedure name
3220: IF (l_csi_debug_level > 0) THEN

Line 3233: RAISE FND_API.G_EXC_ERROR;

3229: -- Validate asset pl/sql table of records is not null
3230: IF p_instance_sync_tbl.count = 0 THEN
3231: IF (l_csi_debug_level > 0) THEN
3232: debug( 'Item instance not provided as input parameter');
3233: RAISE FND_API.G_EXC_ERROR;
3234: END IF;
3235: END IF;
3236: FOR inst_rec IN p_instance_sync_tbl.FIRST..p_instance_sync_tbl.LAST
3237: LOOP

Line 3243: IF p_called_from_grp = fnd_api.g_true THEN

3239: l_fa_asset_id_tbl.delete;
3240: l_fa_asset_loc_id_tbl.delete;
3241: l_asset_qty_tbl.delete;
3242:
3243: IF p_called_from_grp = fnd_api.g_true THEN
3244: OPEN c_interface_assets( p_instance_sync_tbl(inst_rec).instance_id ,
3245: p_instance_sync_tbl(inst_rec).inst_interface_id,
3246: p_source_system_name);
3247: FETCH c_interface_assets BULK COLLECT INTO

Line 3274: WHEN FND_API.G_EXC_ERROR THEN

3270: END IF;
3271: END LOOP;
3272: debug(' After get_attached_asset_links');
3273: EXCEPTION
3274: WHEN FND_API.G_EXC_ERROR THEN
3275: x_return_status := FND_API.G_RET_STS_ERROR ;
3276: FND_MSG_PUB.Count_And_Get
3277: ( p_count => x_msg_count,
3278: p_data => x_msg_data );

Line 3275: x_return_status := FND_API.G_RET_STS_ERROR ;

3271: END LOOP;
3272: debug(' After get_attached_asset_links');
3273: EXCEPTION
3274: WHEN FND_API.G_EXC_ERROR THEN
3275: x_return_status := FND_API.G_RET_STS_ERROR ;
3276: FND_MSG_PUB.Count_And_Get
3277: ( p_count => x_msg_count,
3278: p_data => x_msg_data );
3279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3275: x_return_status := FND_API.G_RET_STS_ERROR ;
3276: FND_MSG_PUB.Count_And_Get
3277: ( p_count => x_msg_count,
3278: p_data => x_msg_data );
3279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3281: FND_MSG_PUB.Count_And_Get
3282: ( p_count => x_msg_count,
3283: p_data => x_msg_data );

Line 3280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3276: FND_MSG_PUB.Count_And_Get
3277: ( p_count => x_msg_count,
3278: p_data => x_msg_data );
3279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3281: FND_MSG_PUB.Count_And_Get
3282: ( p_count => x_msg_count,
3283: p_data => x_msg_data );
3284: WHEN OTHERS THEN

Line 3285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3281: FND_MSG_PUB.Count_And_Get
3282: ( p_count => x_msg_count,
3283: p_data => x_msg_data );
3284: WHEN OTHERS THEN
3285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3286: IF FND_MSG_PUB.Check_Msg_Level
3287: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3288: THEN
3289: FND_MSG_PUB.Add_Exc_Msg

Line 3307: p_called_from_grp IN VARCHAR2 DEFAULT fnd_api.g_false

3303: x_return_status OUT NOCOPY VARCHAR2,
3304: x_msg_count OUT NOCOPY NUMBER,
3305: x_msg_data OUT NOCOPY VARCHAR2,
3306: p_source_system_name IN VARCHAR2 DEFAULT NULL,
3307: p_called_from_grp IN VARCHAR2 DEFAULT fnd_api.g_false
3308: ) IS
3309: TYPE num_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
3310: l_fa_asset_id_tbl num_tbl;
3311: l_fa_asset_loc_id_tbl num_tbl;

Line 3331: IF NOT FND_API.Compatible_API_Call (l_api_version ,

3327: AND units_assigned > 0
3328: AND fadh.date_ineffective IS NULL;
3329: BEGIN
3330: -- Standard call to check for call compatibility.
3331: IF NOT FND_API.Compatible_API_Call (l_api_version ,
3332: p_api_version ,
3333: l_api_name ,
3334: G_PKG_NAME )
3335: THEN

Line 3336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3332: p_api_version ,
3333: l_api_name ,
3334: G_PKG_NAME )
3335: THEN
3336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3337: END IF;
3338: -- Initialize message list if p_init_msg_list is set to TRUE.
3339: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3340: FND_MSG_PUB.initialize;

Line 3339: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3335: THEN
3336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3337: END IF;
3338: -- Initialize message list if p_init_msg_list is set to TRUE.
3339: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3340: FND_MSG_PUB.initialize;
3341: END IF;
3342: -- Initialize API return status to success
3343: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3343: x_return_status := FND_API.G_RET_STS_SUCCESS;

3339: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3340: FND_MSG_PUB.initialize;
3341: END IF;
3342: -- Initialize API return status to success
3343: x_return_status := FND_API.G_RET_STS_SUCCESS;
3344: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
3345: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
3346: -- If csi_debug_level = 1 then dump the procedure name
3347: IF (l_csi_debug_level > 0) THEN

Line 3360: RAISE FND_API.G_EXC_ERROR;

3356: -- Validate asset pl/sql table of records is not null
3357: IF p_instance_asset_sync_tbl.count = 0 THEN
3358: IF (l_csi_debug_level > 0) THEN
3359: debug( 'Fixed Asset details not provided as input parameter');
3360: RAISE FND_API.G_EXC_ERROR;
3361: END IF;
3362: END IF;
3363:
3364: FOR c_fa_asset IN p_instance_asset_sync_tbl.FIRST..p_instance_asset_sync_tbl.LAST

Line 3389: WHEN FND_API.G_EXC_ERROR THEN

3385: CLOSE c_fa_assets;
3386: END IF;
3387: END LOOP;
3388: EXCEPTION
3389: WHEN FND_API.G_EXC_ERROR THEN
3390: x_return_status := FND_API.G_RET_STS_ERROR ;
3391: FND_MSG_PUB.Count_And_Get
3392: ( p_count => x_msg_count,
3393: p_data => x_msg_data );

Line 3390: x_return_status := FND_API.G_RET_STS_ERROR ;

3386: END IF;
3387: END LOOP;
3388: EXCEPTION
3389: WHEN FND_API.G_EXC_ERROR THEN
3390: x_return_status := FND_API.G_RET_STS_ERROR ;
3391: FND_MSG_PUB.Count_And_Get
3392: ( p_count => x_msg_count,
3393: p_data => x_msg_data );
3394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3390: x_return_status := FND_API.G_RET_STS_ERROR ;
3391: FND_MSG_PUB.Count_And_Get
3392: ( p_count => x_msg_count,
3393: p_data => x_msg_data );
3394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3396: FND_MSG_PUB.Count_And_Get
3397: ( p_count => x_msg_count,
3398: p_data => x_msg_data );

Line 3395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3391: FND_MSG_PUB.Count_And_Get
3392: ( p_count => x_msg_count,
3393: p_data => x_msg_data );
3394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3396: FND_MSG_PUB.Count_And_Get
3397: ( p_count => x_msg_count,
3398: p_data => x_msg_data );
3399: WHEN OTHERS THEN

Line 3400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3396: FND_MSG_PUB.Count_And_Get
3397: ( p_count => x_msg_count,
3398: p_data => x_msg_data );
3399: WHEN OTHERS THEN
3400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3401: IF FND_MSG_PUB.Check_Msg_Level
3402: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3403: THEN
3404: FND_MSG_PUB.Add_Exc_Msg

Line 3420: p_called_from_grp IN VARCHAR2 DEFAULT fnd_api.g_false

3416: x_fa_asset_sync_tbl IN OUT NOCOPY CSI_ASSET_PVT.fa_asset_sync_tbl,
3417: x_return_status OUT NOCOPY VARCHAR2,
3418: x_error_msg OUT NOCOPY VARCHAR2,
3419: p_source_system_name IN VARCHAR2 DEFAULT NULL,
3420: p_called_from_grp IN VARCHAR2 DEFAULT fnd_api.g_false
3421: ) IS
3422: l_csi_debug_level NUMBER := 0;
3423: l_instance_sync_tbl CSI_ASSET_PVT.instance_sync_tbl;
3424: l_tmp_instance_sync_tbl CSI_ASSET_PVT.instance_sync_tbl;

Line 3458: RAISE FND_API.G_EXC_ERROR;

3454: debug( 'Get_syncup_tree');
3455: END IF;
3456: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');
3457: FND_MSG_PUB.ADD;
3458: RAISE FND_API.G_EXC_ERROR;
3459: END IF;
3460: /*-- Loop untill all item instances or assets are explored --*/
3461: WHILE l_process_loop
3462: LOOP

Line 3478: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3474: p_called_from_grp => p_called_from_grp
3475: );
3476: l_instance_sync_tbl.delete;
3477:
3478: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3479: debug( 'Get_attached_asset_links returned with error');
3480: RAISE FND_API.G_EXC_ERROR;
3481: END IF;
3482:

Line 3480: RAISE FND_API.G_EXC_ERROR;

3476: l_instance_sync_tbl.delete;
3477:
3478: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3479: debug( 'Get_attached_asset_links returned with error');
3480: RAISE FND_API.G_EXC_ERROR;
3481: END IF;
3482:
3483: IF nvl(l_instance_asset_sync_tbl.count,0) > 0 THEN
3484: /*-- Verify revisited Nodes --*/

Line 3570: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3566: p_source_system_name => p_source_system_name,
3567: p_called_from_grp => p_called_from_grp
3568: );
3569: l_instance_asset_sync_tbl.delete;
3570: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3571: debug( 'Get_attached_item_instances returned with error');
3572: RAISE FND_API.G_EXC_ERROR;
3573: END IF;
3574: IF nvl(l_instance_sync_tbl.count,0) > 0 THEN

Line 3572: RAISE FND_API.G_EXC_ERROR;

3568: );
3569: l_instance_asset_sync_tbl.delete;
3570: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3571: debug( 'Get_attached_item_instances returned with error');
3572: RAISE FND_API.G_EXC_ERROR;
3573: END IF;
3574: IF nvl(l_instance_sync_tbl.count,0) > 0 THEN
3575: /*-- Verify revisited Nodes --*/
3576: l_tmp_instance_sync_tbl := l_instance_sync_tbl;

Line 3654: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3650: x_msg_data => l_msg_data,
3651: p_source_system_name => p_source_system_name,
3652: p_called_from_grp => p_called_from_grp);
3653:
3654: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3655: debug( 'Get_fa_asset_details returned with error');
3656: RAISE FND_API.G_EXC_ERROR;
3657: END IF;
3658:

Line 3656: RAISE FND_API.G_EXC_ERROR;

3652: p_called_from_grp => p_called_from_grp);
3653:
3654: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3655: debug( 'Get_fa_asset_details returned with error');
3656: RAISE FND_API.G_EXC_ERROR;
3657: END IF;
3658:
3659: EXCEPTION
3660: WHEN FND_API.G_EXC_ERROR THEN

Line 3660: WHEN FND_API.G_EXC_ERROR THEN

3656: RAISE FND_API.G_EXC_ERROR;
3657: END IF;
3658:
3659: EXCEPTION
3660: WHEN FND_API.G_EXC_ERROR THEN
3661: x_return_status := FND_API.G_RET_STS_ERROR ;
3662: END Get_syncup_tree ;
3663:
3664: PROCEDURE create_instance_assets (

Line 3661: x_return_status := FND_API.G_RET_STS_ERROR ;

3657: END IF;
3658:
3659: EXCEPTION
3660: WHEN FND_API.G_EXC_ERROR THEN
3661: x_return_status := FND_API.G_RET_STS_ERROR ;
3662: END Get_syncup_tree ;
3663:
3664: PROCEDURE create_instance_assets (
3665: p_api_version IN number,

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

3676: x_msg_count OUT nocopy number,
3677: x_msg_data OUT nocopy varchar2)
3678: IS
3679: l_api_name varchar2(30) := 'create_instance_assets';
3680: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3681: l_msg_count number;
3682: l_msg_data varchar2(2000);
3683: BEGIN
3684: x_return_status := fnd_api.g_ret_sts_success;

Line 3684: x_return_status := fnd_api.g_ret_sts_success;

3680: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3681: l_msg_count number;
3682: l_msg_data varchar2(2000);
3683: BEGIN
3684: x_return_status := fnd_api.g_ret_sts_success;
3685:
3686: SAVEPOINT create_instance_assets;
3687:
3688: IF p_instance_asset_tbl.COUNT > 0 THEN

Line 3695: p_commit => fnd_api.g_false,

3691: LOOP
3692:
3693: create_instance_asset(
3694: p_api_version => 1.0,
3695: p_commit => fnd_api.g_false,
3696: p_init_msg_list => fnd_api.g_true,
3697: p_validation_level => fnd_api.g_valid_level_full,
3698: p_instance_asset_rec => p_instance_asset_tbl(ia_ind),
3699: p_txn_rec => p_txn_rec,

Line 3696: p_init_msg_list => fnd_api.g_true,

3692:
3693: create_instance_asset(
3694: p_api_version => 1.0,
3695: p_commit => fnd_api.g_false,
3696: p_init_msg_list => fnd_api.g_true,
3697: p_validation_level => fnd_api.g_valid_level_full,
3698: p_instance_asset_rec => p_instance_asset_tbl(ia_ind),
3699: p_txn_rec => p_txn_rec,
3700: p_lookup_tbl => p_lookup_tbl,

Line 3697: p_validation_level => fnd_api.g_valid_level_full,

3693: create_instance_asset(
3694: p_api_version => 1.0,
3695: p_commit => fnd_api.g_false,
3696: p_init_msg_list => fnd_api.g_true,
3697: p_validation_level => fnd_api.g_valid_level_full,
3698: p_instance_asset_rec => p_instance_asset_tbl(ia_ind),
3699: p_txn_rec => p_txn_rec,
3700: p_lookup_tbl => p_lookup_tbl,
3701: p_asset_count_rec => p_asset_count_rec,

Line 3708: IF l_return_status <> fnd_api.g_ret_sts_success THEN

3704: x_return_status => l_return_status,
3705: x_msg_count => l_msg_count,
3706: x_msg_data => l_msg_data);
3707:
3708: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3709: RAISE fnd_api.g_exc_error;
3710: END IF;
3711:
3712: END LOOP;

Line 3709: RAISE fnd_api.g_exc_error;

3705: x_msg_count => l_msg_count,
3706: x_msg_data => l_msg_data);
3707:
3708: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3709: RAISE fnd_api.g_exc_error;
3710: END IF;
3711:
3712: END LOOP;
3713:

Line 3717: WHEN fnd_api.g_exc_error THEN

3713:
3714: END IF;
3715:
3716: EXCEPTION
3717: WHEN fnd_api.g_exc_error THEN
3718: ROLLBACK TO create_instance_assets;
3719: x_return_status := fnd_api.g_ret_sts_error;
3720: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data );
3721: WHEN others THEN

Line 3719: x_return_status := fnd_api.g_ret_sts_error;

3715:
3716: EXCEPTION
3717: WHEN fnd_api.g_exc_error THEN
3718: ROLLBACK TO create_instance_assets;
3719: x_return_status := fnd_api.g_ret_sts_error;
3720: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data );
3721: WHEN others THEN
3722: ROLLBACK TO create_instance_assets;
3723: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 3723: x_return_status := fnd_api.g_ret_sts_unexp_error ;

3719: x_return_status := fnd_api.g_ret_sts_error;
3720: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data );
3721: WHEN others THEN
3722: ROLLBACK TO create_instance_assets;
3723: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3724: fnd_msg_pub.add_exc_msg(g_pkg_name , l_api_name);
3725: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
3726: END create_instance_assets;
3727: