59: l_status varchar2(1);
60: l_var2 number;
61:
62: BEGIN
63: -- Standard Start of API savepoint
64: SAVEPOINT EAM_ASSET_LOG_PVT_SV;
65:
66: -- Standard call to check for call compatibility.
67: IF NOT fnd_api.compatible_api_call(
62: BEGIN
63: -- Standard Start of API savepoint
64: SAVEPOINT EAM_ASSET_LOG_PVT_SV;
65:
66: -- Standard call to check for call compatibility.
67: IF NOT fnd_api.compatible_api_call(
68: l_api_version
69: ,p_api_version
70: ,l_api_name
234:
235: END IF;
236:
237: -- End of API body.
238: -- Standard check of p_commit.
239: IF fnd_api.to_boolean(p_commit) THEN
240: COMMIT WORK;
241: END IF;
242: fnd_msg_pub.count_and_get(
297: l_organization_id number;
298: l_dummy number;
299:
300: BEGIN
301: -- Standard Start of API savepoint
302: SAVEPOINT EAM_ASSET_LOG_PVT_SV;
303:
304: -- Standard call to check for call compatibility.
305: IF NOT fnd_api.compatible_api_call(
300: BEGIN
301: -- Standard Start of API savepoint
302: SAVEPOINT EAM_ASSET_LOG_PVT_SV;
303:
304: -- Standard call to check for call compatibility.
305: IF NOT fnd_api.compatible_api_call(
306: l_api_version
307: ,p_api_version
308: ,l_api_name
561: l_organization_id number;
562: BEGIN
563: retcode:=0;
564:
565: -- Standard Start of API savepoint
566: SAVEPOINT EAM_ASSET_LOG_PVT_SV;
567:
568: begin
569: select nvl(maint_organization_id, p_organization_id) into l_organization_id
674: l_location_type_code varchar2(30);
675:
676: BEGIN
677:
678: /* Standard Start of API savepoint */
679: SAVEPOINT EAM_ASSET_LOG_PVT;
680:
681: /* Standard call to check for call compatibility. */
682: IF NOT FND_API.Compatible_API_Call
677:
678: /* Standard Start of API savepoint */
679: SAVEPOINT EAM_ASSET_LOG_PVT;
680:
681: /* Standard call to check for call compatibility. */
682: IF NOT FND_API.Compatible_API_Call
683: ( l_api_version ,
684: p_api_version ,
685: l_api_name ,
1134: x_msg_data => x_msg_data
1135: );
1136: END IF;
1137:
1138: /* Standard check of p_commit. */
1139:
1140: IF FND_API.TO_BOOLEAN( P_COMMIT ) THEN
1141: COMMIT WORK;
1142: END IF;
1140: IF FND_API.TO_BOOLEAN( P_COMMIT ) THEN
1141: COMMIT WORK;
1142: END IF;
1143:
1144: -- Standard call to get message count and if count is 1, get message info.
1145:
1146: fnd_msg_pub.get
1147: ( p_msg_index_out => x_msg_count ,
1148: p_data => x_msg_data
1223: FROM csi_counter_associations caa, csi_item_instances cii
1224: WHERE caa.counter_id = p_ref_id AND
1225: cii.instance_id = caa.source_object_id;
1226: BEGIN
1227: -- Standard Start of API savepoint
1228: SAVEPOINT EAM_ASSET_LOG_PVT_SV;
1229:
1230: -- Standard call to check for call compatibility.
1231: IF NOT fnd_api.compatible_api_call(
1226: BEGIN
1227: -- Standard Start of API savepoint
1228: SAVEPOINT EAM_ASSET_LOG_PVT_SV;
1229:
1230: -- Standard call to check for call compatibility.
1231: IF NOT fnd_api.compatible_api_call(
1232: l_api_version
1233: ,p_api_version
1234: ,l_api_name
1325: END IF;
1326: END LOOP;
1327:
1328: -- End of API body.
1329: -- Standard check of p_commit.
1330: IF fnd_api.to_boolean(p_commit) THEN
1331: COMMIT WORK;
1332: END IF;
1333: