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 105: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

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

Line 109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 128: IF FND_API.to_boolean(p_init_msg_list)

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

Line 135: x_return_status:=FND_API.G_RET_STS_SUCCESS ;

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

Line 147: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 156: RAISE FND_API.G_EXC_ERROR;

152: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
153: 'Error -- Invalid lookup specified'
154: );
155: END IF;
156: RAISE FND_API.G_EXC_ERROR;
157: END IF;
158:
159: -- If Id is null derive object id from object Number and revision
160: -- 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 181: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 190: RAISE FND_API.G_EXC_ERROR;

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

Line 211: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 212: RAISE FND_API.G_EXC_ERROR;

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

Line 213: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 231: p_commit => FND_API.G_FALSE ,

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

Line 245: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

241: l_msg_count := FND_MSG_PUB.count_msg;
242:
243: IF l_msg_count > 0 THEN
244: X_msg_count := l_msg_count;
245: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
246: RAISE FND_API.G_EXC_ERROR;
247: END IF;
248:
249: -- 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 246: RAISE FND_API.G_EXC_ERROR;

242:
243: IF l_msg_count > 0 THEN
244: X_msg_count := l_msg_count;
245: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
246: RAISE FND_API.G_EXC_ERROR;
247: END IF;
248:
249: -- 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.
250: FOR i IN l_x_doc_assos_tbl.FIRST..l_x_doc_assos_tbl.LAST

Line 275: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

271: l_msg_data,
272: l_return_status
273: );
274:
275: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
276: FND_MESSAGE.SET_NAME('AHL',l_msg_data);
277: FND_MSG_PUB.ADD;
278: x_return_status := l_return_status;
279: RETURN;

Line 308: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

304: l_msg_data,
305: l_return_status
306: );
307:
308: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
309: FND_MESSAGE.SET_NAME('AHL',l_msg_data);
310: FND_MSG_PUB.ADD;
311: x_return_status := l_return_status;
312: RETURN;

Line 332: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

328: l_msg_count := FND_MSG_PUB.count_msg;
329:
330: IF l_msg_count > 0 THEN
331: X_msg_count := l_msg_count;
332: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
333: RAISE FND_API.G_EXC_ERROR;
334: END IF;
335:
336: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 333: RAISE FND_API.G_EXC_ERROR;

329:
330: IF l_msg_count > 0 THEN
331: X_msg_count := l_msg_count;
332: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
333: RAISE FND_API.G_EXC_ERROR;
334: END IF;
335:
336: IF FND_API.TO_BOOLEAN(p_commit) THEN
337: COMMIT;

Line 336: IF FND_API.TO_BOOLEAN(p_commit) THEN

332: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
333: RAISE FND_API.G_EXC_ERROR;
334: END IF;
335:
336: IF FND_API.TO_BOOLEAN(p_commit) THEN
337: COMMIT;
338: END IF;
339:
340: -- Check if API is called in debug mode. If yes, disable debug.

Line 347: WHEN FND_API.G_EXC_ERROR THEN

343: AHL_DEBUG_PUB.disable_debug;
344: END IF;
345:
346: EXCEPTION
347: WHEN FND_API.G_EXC_ERROR THEN
348: ROLLBACK TO process_association;
349: x_return_status := FND_API.G_RET_STS_ERROR;
350: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
351: p_count => x_msg_count,

Line 349: x_return_status := FND_API.G_RET_STS_ERROR;

345:
346: EXCEPTION
347: WHEN FND_API.G_EXC_ERROR THEN
348: ROLLBACK TO process_association;
349: x_return_status := FND_API.G_RET_STS_ERROR;
350: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
351: p_count => x_msg_count,
352: p_data => X_msg_data);
353: -- Debug info.

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

346: EXCEPTION
347: WHEN FND_API.G_EXC_ERROR THEN
348: ROLLBACK TO process_association;
349: x_return_status := FND_API.G_RET_STS_ERROR;
350: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
351: p_count => x_msg_count,
352: p_data => X_msg_data);
353: -- Debug info.
354: IF G_DEBUG='Y' THEN

Line 362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

358: END IF;
359:
360: WHEN OTHERS THEN
361: ROLLBACK TO process_association;
362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
363: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
364: THEN
365: fnd_msg_pub.add_exc_msg(p_pkg_name =>G_PKG_NAME ,
366: p_procedure_name => 'PROCESS_ASSOCIATION',

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

365: fnd_msg_pub.add_exc_msg(p_pkg_name =>G_PKG_NAME ,
366: p_procedure_name => 'PROCESS_ASSOCIATION',
367: p_error_text => SUBSTR(SQLERRM,1,240));
368: END IF;
369: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
370: p_count => x_msg_count,
371: p_data => X_msg_data);
372:
373: