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.EAM_PM_LAST_SERVICE_PUB dependencies on FND_API

Line 11: -- Default = FND_API.G_FALSE

7: -- Pre-reqs : None.
8: -- Parameters :
9: -- IN : p_api_version IN NUMBER Required
10: -- p_init_msg_list IN VARCHAR2 Optional
11: -- Default = FND_API.G_FALSE
12: -- p_commit IN VARCHAR2 Optional
13: -- Default = FND_API.G_FALSE
14: -- p_validation_level IN NUMBER Optional
15: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 13: -- Default = FND_API.G_FALSE

9: -- IN : p_api_version IN NUMBER Required
10: -- p_init_msg_list IN VARCHAR2 Optional
11: -- Default = FND_API.G_FALSE
12: -- p_commit IN VARCHAR2 Optional
13: -- Default = FND_API.G_FALSE
14: -- p_validation_level IN NUMBER Optional
15: -- Default = FND_API.G_VALID_LEVEL_FULL
16: -- parameter1
17: -- parameter2

Line 15: -- Default = FND_API.G_VALID_LEVEL_FULL

11: -- Default = FND_API.G_FALSE
12: -- p_commit IN VARCHAR2 Optional
13: -- Default = FND_API.G_FALSE
14: -- p_validation_level IN NUMBER Optional
15: -- Default = FND_API.G_VALID_LEVEL_FULL
16: -- parameter1
17: -- parameter2
18: -- .
19: -- .

Line 90: RAISE fnd_api.g_exc_error;

86: if P_meter_id is null or p_actv_assoc_id is null
87: then
88: FND_MESSAGE.SET_NAME('EAM','EAM_IAA_ID_MISSING');
89: fnd_msg_pub.add;
90: RAISE fnd_api.g_exc_error;
91: end if;
92:
93: open c_val_meter_id(p_meter_id);
94: fetch c_val_meter_id into l_dummy;

Line 99: RAISE fnd_api.g_exc_error;

95: IF c_val_meter_id%NOTFOUND
96: THEN
97: FND_MESSAGE.SET_NAME('EAM','EAM_IAA_INV_METER_ID');
98: fnd_msg_pub.add;
99: RAISE fnd_api.g_exc_error;
100: END IF;
101: CLOSE c_val_meter_id;
102:
103: open c_val_act_assoc_id(p_actv_assoc_id);

Line 109: RAISE fnd_api.g_exc_error;

105: IF c_val_act_assoc_id%NOTFOUND
106: THEN
107: FND_MESSAGE.SET_NAME('EAM','EAM_IAA_INV_ACTIVITY_ASSOC_ID');
108: fnd_msg_pub.add;
109: RAISE fnd_api.g_exc_error;
110: END IF;
111: CLOSE c_val_act_assoc_id;
112:
113: open c_meter_act_assoc(p_actv_assoc_id, p_meter_id);

Line 119: RAISE fnd_api.g_exc_error;

115: IF c_meter_act_assoc %NOTFOUND
116: THEN
117: FND_MESSAGE.SET_NAME('EAM','EAM_IAA_INV_METER_ID');
118: fnd_msg_pub.add;
119: RAISE fnd_api.g_exc_error;
120: END IF;
121: CLOSE c_meter_act_assoc;
122:
123:

Line 130: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE ,

126:
127: PROCEDURE process_pm_last_service
128: (
129: p_api_version IN NUMBER ,
130: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE ,
131: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
132: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
133: x_return_status OUT NOCOPY VARCHAR2 ,
134: x_msg_count OUT NOCOPY NUMBER ,

Line 131: p_commit IN VARCHAR2:= FND_API.G_FALSE ,

127: PROCEDURE process_pm_last_service
128: (
129: p_api_version IN NUMBER ,
130: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE ,
131: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
132: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
133: x_return_status OUT NOCOPY VARCHAR2 ,
134: x_msg_count OUT NOCOPY NUMBER ,
135: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 132: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

128: (
129: p_api_version IN NUMBER ,
130: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE ,
131: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
132: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
133: x_return_status OUT NOCOPY VARCHAR2 ,
134: x_msg_count OUT NOCOPY NUMBER ,
135: x_msg_data OUT NOCOPY VARCHAR2 ,
136:

Line 160: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

156: BEGIN
157: -- Standard Start of API savepoint
158: SAVEPOINT process_pm_last_service;
159: -- Standard call to check for call compatibility.
160: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
161: p_api_version ,
162: l_api_name ,
163: G_PKG_NAME )
164: THEN

Line 165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

161: p_api_version ,
162: l_api_name ,
163: G_PKG_NAME )
164: THEN
165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
166: END IF;
167: -- Initialize message list if p_init_msg_list is set to TRUE.
168: IF FND_API.to_Boolean( p_init_msg_list ) THEN
169: FND_MSG_PUB.initialize;

Line 168: IF FND_API.to_Boolean( p_init_msg_list ) THEN

164: THEN
165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
166: END IF;
167: -- Initialize message list if p_init_msg_list is set to TRUE.
168: IF FND_API.to_Boolean( p_init_msg_list ) THEN
169: FND_MSG_PUB.initialize;
170: END IF;
171: -- Initialize API return status to success
172: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 172: x_return_status := FND_API.G_RET_STS_SUCCESS;

168: IF FND_API.to_Boolean( p_init_msg_list ) THEN
169: FND_MSG_PUB.initialize;
170: END IF;
171: -- Initialize API return status to success
172: x_return_status := FND_API.G_RET_STS_SUCCESS;
173:
174: -- API body
175: IF p_pm_last_service_tbl.count >0
176: THEN

Line 187: RAISE fnd_api.g_exc_error;

183: p_pm_last_service_tbl(i).prev_service_reading is null*/ ) THEN
184:
185: FND_MESSAGE.SET_NAME('EAM','EAM_NULL_METER_READING');
186: fnd_msg_pub.add;
187: RAISE fnd_api.g_exc_error;
188:
189: END IF;
190:
191: open c_check_update(p_pm_last_service_tbl(i).meter_id,p_actv_assoc_id);

Line 248: IF FND_API.To_Boolean( p_commit ) THEN

244:
245:
246: -- End of API body.
247: -- Standard check of p_commit.
248: IF FND_API.To_Boolean( p_commit ) THEN
249: COMMIT WORK;
250: END IF;
251: -- Standard call to get message count and if count is 1, get message info.
252: FND_MSG_PUB.Count_And_Get

Line 257: WHEN FND_API.G_EXC_ERROR THEN

253: ( p_count => x_msg_count ,
254: p_data => x_msg_data
255: );
256: EXCEPTION
257: WHEN FND_API.G_EXC_ERROR THEN
258: ROLLBACK TO process_pm_last_service;
259: x_return_status := FND_API.G_RET_STS_ERROR ;
260: FND_MSG_PUB.Count_And_Get
261: ( p_count => x_msg_count ,

Line 259: x_return_status := FND_API.G_RET_STS_ERROR ;

255: );
256: EXCEPTION
257: WHEN FND_API.G_EXC_ERROR THEN
258: ROLLBACK TO process_pm_last_service;
259: x_return_status := FND_API.G_RET_STS_ERROR ;
260: FND_MSG_PUB.Count_And_Get
261: ( p_count => x_msg_count ,
262: p_data => x_msg_data ,
263: P_ENCODED => FND_API.G_FALSE

Line 263: P_ENCODED => FND_API.G_FALSE

259: x_return_status := FND_API.G_RET_STS_ERROR ;
260: FND_MSG_PUB.Count_And_Get
261: ( p_count => x_msg_count ,
262: p_data => x_msg_data ,
263: P_ENCODED => FND_API.G_FALSE
264: );
265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
266: ROLLBACK TO process_pm_last_service;
267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

261: ( p_count => x_msg_count ,
262: p_data => x_msg_data ,
263: P_ENCODED => FND_API.G_FALSE
264: );
265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
266: ROLLBACK TO process_pm_last_service;
267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
268:
269: FND_MSG_PUB.Count_And_Get

Line 267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

263: P_ENCODED => FND_API.G_FALSE
264: );
265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
266: ROLLBACK TO process_pm_last_service;
267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
268:
269: FND_MSG_PUB.Count_And_Get
270: ( p_count => x_msg_count ,
271: p_data => x_msg_data ,

Line 272: P_ENCODED => FND_API.G_FALSE

268:
269: FND_MSG_PUB.Count_And_Get
270: ( p_count => x_msg_count ,
271: p_data => x_msg_data ,
272: P_ENCODED => FND_API.G_FALSE
273: );
274: WHEN OTHERS THEN
275: ROLLBACK TO process_pm_last_service;
276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

272: P_ENCODED => FND_API.G_FALSE
273: );
274: WHEN OTHERS THEN
275: ROLLBACK TO process_pm_last_service;
276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
277: IF FND_MSG_PUB.Check_Msg_Level
278: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
279: THEN
280: FND_MSG_PUB.Add_Exc_Msg

Line 288: P_ENCODED => FND_API.G_FALSE

284: END IF;
285: FND_MSG_PUB.Count_And_Get
286: ( p_count => x_msg_count ,
287: p_data => x_msg_data ,
288: P_ENCODED => FND_API.G_FALSE
289: );
290: END process_pm_last_service;
291:
292: