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

Line 65: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

61:
62: PROCEDURE PROCESS_ASSOCIATION
63: (
64: p_api_version IN NUMBER := 1.0,
65: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
66: p_commit IN VARCHAR2 := FND_API.G_FALSE,
67: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
68: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
69: p_default IN VARCHAR2 := FND_API.G_FALSE,

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

62: PROCEDURE PROCESS_ASSOCIATION
63: (
64: p_api_version IN NUMBER := 1.0,
65: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
66: p_commit IN VARCHAR2 := FND_API.G_FALSE,
67: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
68: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
69: p_default IN VARCHAR2 := FND_API.G_FALSE,
70: p_module_type IN VARCHAR2,

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

63: (
64: p_api_version IN NUMBER := 1.0,
65: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
66: p_commit IN VARCHAR2 := FND_API.G_FALSE,
67: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
68: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
69: p_default IN VARCHAR2 := FND_API.G_FALSE,
70: p_module_type IN VARCHAR2,
71: x_return_status OUT NOCOPY VARCHAR2,

Line 68: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,

64: p_api_version IN NUMBER := 1.0,
65: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
66: p_commit IN VARCHAR2 := FND_API.G_FALSE,
67: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
68: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
69: p_default IN VARCHAR2 := FND_API.G_FALSE,
70: p_module_type IN VARCHAR2,
71: x_return_status OUT NOCOPY VARCHAR2,
72: x_msg_count OUT NOCOPY NUMBER,

Line 69: p_default IN VARCHAR2 := FND_API.G_FALSE,

65: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
66: p_commit IN VARCHAR2 := FND_API.G_FALSE,
67: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
68: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
69: p_default IN VARCHAR2 := FND_API.G_FALSE,
70: p_module_type IN VARCHAR2,
71: x_return_status OUT NOCOPY VARCHAR2,
72: x_msg_count OUT NOCOPY NUMBER,
73: x_msg_data OUT NOCOPY VARCHAR2,

Line 106: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

102: BEGIN
103:
104:
105: -- Standard call to check for call compatibility.
106: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
107: p_api_version,
108: l_api_name,G_PKG_NAME)
109: THEN
110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

106: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
107: p_api_version,
108: l_api_name,G_PKG_NAME)
109: THEN
110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
111: END IF;
112:
113: -- Standard Start of API savepoint
114: SAVEPOINT process_association;

Line 129: IF FND_API.to_boolean(p_init_msg_list)

125: AHL_DEBUG_PUB.debug( 'enter ahl_rm_asso_doc_aso_pub.Process Association');
126: END IF;
127:
128: -- Initialize message list if p_init_msg_list is set to TRUE.
129: IF FND_API.to_boolean(p_init_msg_list)
130: THEN
131: FND_MSG_PUB.initialize;
132: END IF;
133:

Line 136: x_return_status:=FND_API.G_RET_STS_SUCCESS ;

132: END IF;
133:
134: -- Initialize API return status to success
135:
136: x_return_status:=FND_API.G_RET_STS_SUCCESS ;
137:
138: IF p_x_association_tbl.count >0 THEN
139: FOR i in p_x_association_tbl.FIRST .. p_x_association_tbl.LAST
140: LOOP

Line 148: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

144: p_lookup_type => 'AHL_OBJECT_TYPE',
145: p_lookup_meaning => p_x_association_tbl(i).object_type_desc,
146: p_x_lookup_code => p_x_association_tbl(i).object_type_code
147: );
148: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
149: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
150: fnd_log.string
151: (
152: fnd_log.level_statement,

Line 157: RAISE FND_API.G_EXC_ERROR;

153: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
154: 'Error -- Invalid lookup specified'
155: );
156: END IF;
157: RAISE FND_API.G_EXC_ERROR;
158: END IF;
159:
160: -- If Id is null derive object id from object Number and revision
161: -- This will fail if no record are passed to this API or if records with different association types are passed. This needs to be fixed sooner or later. - Balaji

Line 182: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

178: x_operation_id => p_x_association_tbl(i).object_id,
179: x_return_status => x_return_status
180: );
181: END IF;
182: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
183: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
184: fnd_log.string
185: (
186: fnd_log.level_statement,

Line 191: RAISE FND_API.G_EXC_ERROR;

187: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
188: 'Error in converting Object Number, Object Revision to ID'
189: );
190: END IF;
191: RAISE FND_API.G_EXC_ERROR;
192: END IF;
193: END IF;
194: END LOOP;
195: END IF;

Line 212: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

208: x_msg_data => x_msg_data
209: );
210:
211: -- If any severe error occurs, then, abort API.
212: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
213: RAISE FND_API.G_EXC_ERROR;
214: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
216: END IF;

Line 213: RAISE FND_API.G_EXC_ERROR;

209: );
210:
211: -- If any severe error occurs, then, abort API.
212: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
213: RAISE FND_API.G_EXC_ERROR;
214: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
216: END IF;
217: END IF;

Line 214: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

210:
211: -- If any severe error occurs, then, abort API.
212: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
213: RAISE FND_API.G_EXC_ERROR;
214: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
216: END IF;
217: END IF;
218:

Line 215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

211: -- If any severe error occurs, then, abort API.
212: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
213: RAISE FND_API.G_EXC_ERROR;
214: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
216: END IF;
217: END IF;
218:
219: -- Populate doc table from RM table info. procedure added in 11.5.10

Line 232: p_commit => FND_API.G_FALSE ,

228: AHL_DI_ASSO_DOC_GEN_PUB.PROCESS_ASSOCIATION
229: (
230: p_api_version => p_api_version ,
231: p_init_msg_list => p_init_msg_list ,
232: p_commit => FND_API.G_FALSE ,
233: p_validation_level => p_validation_level ,
234: p_validate_only => p_validate_only ,
235: p_module_type => p_module_type ,
236: x_return_status => x_return_status ,

Line 246: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

242: l_msg_count := FND_MSG_PUB.count_msg;
243:
244: IF l_msg_count > 0 THEN
245: X_msg_count := l_msg_count;
246: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
247: RAISE FND_API.G_EXC_ERROR;
248: END IF;
249:
250: -- call is success so copy the DOC_TITLE_ASSO_ID and Object_version_number back into RM record structure. Balaji added in 11510+ as a part of code cleanup.

Line 247: RAISE FND_API.G_EXC_ERROR;

243:
244: IF l_msg_count > 0 THEN
245: X_msg_count := l_msg_count;
246: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
247: RAISE FND_API.G_EXC_ERROR;
248: END IF;
249:
250: -- call is success so copy the DOC_TITLE_ASSO_ID and Object_version_number back into RM record structure. Balaji added in 11510+ as a part of code cleanup.
251: FOR i IN l_x_doc_assos_tbl.FIRST..l_x_doc_assos_tbl.LAST

Line 280: l_return_status := FND_API.G_RET_STS_ERROR;

276:
277: OPEN get_oper_status( p_x_association_tbl(1).OBJECT_ID);
278: FETCH get_oper_status INTO l_object_status;
279: IF get_oper_status%NOTFOUND THEN
280: l_return_status := FND_API.G_RET_STS_ERROR;
281: l_msg_data := 'AHL_RM_INVALID_OPERATION';
282: END IF;
283: IF ( l_object_status <> 'DRAFT' AND
284: l_object_status <> 'APPROVAL_REJECTED' AND

Line 286: l_return_status := FND_API.G_RET_STS_ERROR;

282: END IF;
283: IF ( l_object_status <> 'DRAFT' AND
284: l_object_status <> 'APPROVAL_REJECTED' AND
285: l_object_status <> 'COMPLETE') THEN
286: l_return_status := FND_API.G_RET_STS_ERROR;
287: l_msg_data := 'AHL_RM_INVALID_OPER_STATUS';
288: END IF;
289: CLOSE get_oper_status;
290: -- End of FP #8410484

Line 291: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

287: l_msg_data := 'AHL_RM_INVALID_OPER_STATUS';
288: END IF;
289: CLOSE get_oper_status;
290: -- End of FP #8410484
291: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
292: FND_MESSAGE.SET_NAME('AHL',l_msg_data);
293: FND_MSG_PUB.ADD;
294: x_return_status := l_return_status;
295: RETURN;

Line 327: l_return_status := FND_API.G_RET_STS_ERROR;

323: --);
324: OPEN get_route_status( p_x_association_tbl(1).OBJECT_ID);
325: FETCH get_route_status INTO l_object_status;
326: IF get_route_status%NOTFOUND THEN
327: l_return_status := FND_API.G_RET_STS_ERROR;
328: l_msg_data := 'AHL_RM_INVALID_ROUTE';
329: END IF;
330: IF ( l_object_status <> 'DRAFT' AND
331: l_object_status <> 'APPROVAL_REJECTED' AND

Line 333: l_return_status := FND_API.G_RET_STS_ERROR;

329: END IF;
330: IF ( l_object_status <> 'DRAFT' AND
331: l_object_status <> 'APPROVAL_REJECTED' AND
332: l_object_status <> 'COMPLETE') THEN
333: l_return_status := FND_API.G_RET_STS_ERROR;
334: l_msg_data := 'AHL_RM_INVALID_ROUTE_STATUS';
335: END IF;
336: CLOSE get_route_status;
337: --End of FP #8410484

Line 338: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

334: l_msg_data := 'AHL_RM_INVALID_ROUTE_STATUS';
335: END IF;
336: CLOSE get_route_status;
337: --End of FP #8410484
338: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
339: FND_MESSAGE.SET_NAME('AHL',l_msg_data);
340: FND_MSG_PUB.ADD;
341: x_return_status := l_return_status;
342: RETURN;

Line 361: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

357: l_msg_count := FND_MSG_PUB.count_msg;
358:
359: IF l_msg_count > 0 THEN
360: X_msg_count := l_msg_count;
361: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
362: RAISE FND_API.G_EXC_ERROR;
363: END IF;
364:
365: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 362: RAISE FND_API.G_EXC_ERROR;

358:
359: IF l_msg_count > 0 THEN
360: X_msg_count := l_msg_count;
361: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
362: RAISE FND_API.G_EXC_ERROR;
363: END IF;
364:
365: IF FND_API.TO_BOOLEAN(p_commit) THEN
366: COMMIT;

Line 365: IF FND_API.TO_BOOLEAN(p_commit) THEN

361: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
362: RAISE FND_API.G_EXC_ERROR;
363: END IF;
364:
365: IF FND_API.TO_BOOLEAN(p_commit) THEN
366: COMMIT;
367: END IF;
368:
369: -- Check if API is called in debug mode. If yes, disable debug.

Line 376: WHEN FND_API.G_EXC_ERROR THEN

372: AHL_DEBUG_PUB.disable_debug;
373: END IF;
374:
375: EXCEPTION
376: WHEN FND_API.G_EXC_ERROR THEN
377: ROLLBACK TO process_association;
378: x_return_status := FND_API.G_RET_STS_ERROR;
379: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
380: p_count => x_msg_count,

Line 378: x_return_status := FND_API.G_RET_STS_ERROR;

374:
375: EXCEPTION
376: WHEN FND_API.G_EXC_ERROR THEN
377: ROLLBACK TO process_association;
378: x_return_status := FND_API.G_RET_STS_ERROR;
379: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
380: p_count => x_msg_count,
381: p_data => X_msg_data);
382: -- Debug info.

Line 379: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

375: EXCEPTION
376: WHEN FND_API.G_EXC_ERROR THEN
377: ROLLBACK TO process_association;
378: x_return_status := FND_API.G_RET_STS_ERROR;
379: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
380: p_count => x_msg_count,
381: p_data => X_msg_data);
382: -- Debug info.
383: IF G_DEBUG='Y' THEN

Line 391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

387: END IF;
388:
389: WHEN OTHERS THEN
390: ROLLBACK TO process_association;
391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
392: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
393: THEN
394: fnd_msg_pub.add_exc_msg(p_pkg_name =>G_PKG_NAME ,
395: p_procedure_name => 'PROCESS_ASSOCIATION',

Line 398: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

394: fnd_msg_pub.add_exc_msg(p_pkg_name =>G_PKG_NAME ,
395: p_procedure_name => 'PROCESS_ASSOCIATION',
396: p_error_text => SUBSTR(SQLERRM,1,240));
397: END IF;
398: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
399: p_count => x_msg_count,
400: p_data => X_msg_data);
401:
402: