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

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

10: G_DEBUG_UEXP CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11:
12: PROCEDURE PERFORM_MATERIAL_TXN (
13: p_api_version IN NUMBER,
14: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
15: p_commit IN VARCHAR2 := FND_API.G_FALSE,
16: p_default IN VARCHAR2 := FND_API.G_FALSE,
17: p_x_material_txn_tbl IN OUT NOCOPY AHL_PRD_MATERIAL_TXN_PUB.Ahl_Material_Txn_Tbl_Type,
18: x_return_status OUT NOCOPY VARCHAR2,

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

11:
12: PROCEDURE PERFORM_MATERIAL_TXN (
13: p_api_version IN NUMBER,
14: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
15: p_commit IN VARCHAR2 := FND_API.G_FALSE,
16: p_default IN VARCHAR2 := FND_API.G_FALSE,
17: p_x_material_txn_tbl IN OUT NOCOPY AHL_PRD_MATERIAL_TXN_PUB.Ahl_Material_Txn_Tbl_Type,
18: x_return_status OUT NOCOPY VARCHAR2,
19: x_msg_count OUT NOCOPY NUMBER,

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

12: PROCEDURE PERFORM_MATERIAL_TXN (
13: p_api_version IN NUMBER,
14: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
15: p_commit IN VARCHAR2 := FND_API.G_FALSE,
16: p_default IN VARCHAR2 := FND_API.G_FALSE,
17: p_x_material_txn_tbl IN OUT NOCOPY AHL_PRD_MATERIAL_TXN_PUB.Ahl_Material_Txn_Tbl_Type,
18: x_return_status OUT NOCOPY VARCHAR2,
19: x_msg_count OUT NOCOPY NUMBER,
20: x_msg_data OUT NOCOPY VARCHAR2

Line 44: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name,

40: );
41: END IF;
42:
43: -- Standard call to check for call compatibility
44: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name,
45: G_PKG_NAME ) THEN
46: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
47: END IF;
48:

Line 46: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

42:
43: -- Standard call to check for call compatibility
44: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name,
45: G_PKG_NAME ) THEN
46: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
47: END IF;
48:
49: -- Standard start of API savepoint
50: SAVEPOINT Perform_Material_Txn_pub;

Line 53: IF FND_API.To_Boolean(p_init_msg_list) THEN

49: -- Standard start of API savepoint
50: SAVEPOINT Perform_Material_Txn_pub;
51:
52: -- Initialize message list if p_init_msg_list is set to TRUE
53: IF FND_API.To_Boolean(p_init_msg_list) THEN
54: FND_MSG_PUB.Initialize;
55: END IF;
56:
57: -- Initialize API return status to success

Line 58: x_return_status := FND_API.G_RET_STS_SUCCESS;

54: FND_MSG_PUB.Initialize;
55: END IF;
56:
57: -- Initialize API return status to success
58: x_return_status := FND_API.G_RET_STS_SUCCESS;
59:
60: -- Assign variables to l_x_ahl_mtltxn_rec structure.
61: IF (p_x_material_txn_tbl.COUNT > 0) THEN
62: FOR i IN p_x_material_txn_tbl.FIRST..p_x_material_txn_tbl.LAST LOOP

Line 140: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

136: AHL_PRD_MTLTXN_PVT.PERFORM_MTL_TXN(
137: p_api_version => 1.0,
138: p_init_msg_list => p_init_msg_list,
139: p_commit => p_commit,
140: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
141: p_default => p_default,
142: p_module_type => NULL,
143: p_create_sr => 'Y',
144: p_x_ahl_mtltxn_tbl => l_ahl_mtltxn_tbl,

Line 165: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

161: 'After call to AHL_PRD_MTLTXN_PVT.PERFORM_MTL_TXN failed. Error count:' || x_msg_count
162: );
163: END IF;
164:
165: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
166: RAISE FND_API.G_EXC_ERROR;
167: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
169: END IF;

Line 166: RAISE FND_API.G_EXC_ERROR;

162: );
163: END IF;
164:
165: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
166: RAISE FND_API.G_EXC_ERROR;
167: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
169: END IF;
170:

Line 167: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

163: END IF;
164:
165: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
166: RAISE FND_API.G_EXC_ERROR;
167: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
169: END IF;
170:
171: IF (l_ahl_mtltxn_tbl.COUNT > 0) THEN

Line 168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

164:
165: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
166: RAISE FND_API.G_EXC_ERROR;
167: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
169: END IF;
170:
171: IF (l_ahl_mtltxn_tbl.COUNT > 0) THEN
172: FOR i IN l_ahl_mtltxn_tbl.FIRST..l_ahl_mtltxn_tbl.LAST LOOP

Line 258: p_init_msg_list => FND_API.G_FALSE,

254: -- Call disposition API.
255: IF (l_disp_Mtl_Txn_Tbl.COUNT > 0) THEN
256: AHL_PRD_DISP_MTL_TXN_PVT.Process_Disp_Mtl_Txn (
257: p_api_version => 1.0,
258: p_init_msg_list => FND_API.G_FALSE,
259: p_commit => FND_API.G_FALSE,
260: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
261: x_return_status => x_return_status,
262: x_msg_count => x_msg_count,

Line 259: p_commit => FND_API.G_FALSE,

255: IF (l_disp_Mtl_Txn_Tbl.COUNT > 0) THEN
256: AHL_PRD_DISP_MTL_TXN_PVT.Process_Disp_Mtl_Txn (
257: p_api_version => 1.0,
258: p_init_msg_list => FND_API.G_FALSE,
259: p_commit => FND_API.G_FALSE,
260: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
261: x_return_status => x_return_status,
262: x_msg_count => x_msg_count,
263: x_msg_data => x_msg_data,

Line 260: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

256: AHL_PRD_DISP_MTL_TXN_PVT.Process_Disp_Mtl_Txn (
257: p_api_version => 1.0,
258: p_init_msg_list => FND_API.G_FALSE,
259: p_commit => FND_API.G_FALSE,
260: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
261: x_return_status => x_return_status,
262: x_msg_count => x_msg_count,
263: x_msg_data => x_msg_data,
264: p_module => 'JSP',

Line 283: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

279: 'After call to AHL_PRD_DISP_MTL_TXN_PVT.Process_Disp_Mtl_Txn. Error count:' || x_msg_count
280: );
281: END IF;
282:
283: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
284: RAISE FND_API.G_EXC_ERROR;
285: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
287: END IF;

Line 284: RAISE FND_API.G_EXC_ERROR;

280: );
281: END IF;
282:
283: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
284: RAISE FND_API.G_EXC_ERROR;
285: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
287: END IF;
288:

Line 285: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

281: END IF;
282:
283: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
284: RAISE FND_API.G_EXC_ERROR;
285: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
287: END IF;
288:
289: END IF;

Line 286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

282:
283: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
284: RAISE FND_API.G_EXC_ERROR;
285: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
287: END IF;
288:
289: END IF;
290:

Line 292: IF FND_API.to_boolean(p_commit) THEN

288:
289: END IF;
290:
291: -- Standard check of p_commit
292: IF FND_API.to_boolean(p_commit) THEN
293: COMMIT;
294: END IF;
295:
296: -- Standard call to get message count and if count is 1, get message

Line 300: p_encoded => fnd_api.g_false);

296: -- Standard call to get message count and if count is 1, get message
297: FND_MSG_PUB.Count_And_Get
298: ( p_count => x_msg_count,
299: p_data => x_msg_data,
300: p_encoded => fnd_api.g_false);
301:
302: -- Log API exit point
303: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)
304: THEN

Line 313: WHEN FND_API.G_EXC_ERROR THEN

309: );
310: END IF;
311:
312: EXCEPTION
313: WHEN FND_API.G_EXC_ERROR THEN
314: ROLLBACK TO Perform_Material_Txn_pub;
315: x_return_status := FND_API.G_RET_STS_ERROR;
316: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
317: p_data => x_msg_data,

Line 315: x_return_status := FND_API.G_RET_STS_ERROR;

311:
312: EXCEPTION
313: WHEN FND_API.G_EXC_ERROR THEN
314: ROLLBACK TO Perform_Material_Txn_pub;
315: x_return_status := FND_API.G_RET_STS_ERROR;
316: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
317: p_data => x_msg_data,
318: p_encoded => fnd_api.g_false);
319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 318: p_encoded => fnd_api.g_false);

314: ROLLBACK TO Perform_Material_Txn_pub;
315: x_return_status := FND_API.G_RET_STS_ERROR;
316: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
317: p_data => x_msg_data,
318: p_encoded => fnd_api.g_false);
319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
320: ROLLBACK TO Perform_Material_Txn_pub;
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
322: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

315: x_return_status := FND_API.G_RET_STS_ERROR;
316: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
317: p_data => x_msg_data,
318: p_encoded => fnd_api.g_false);
319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
320: ROLLBACK TO Perform_Material_Txn_pub;
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
322: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
323: p_data => x_msg_data,

Line 321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

317: p_data => x_msg_data,
318: p_encoded => fnd_api.g_false);
319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
320: ROLLBACK TO Perform_Material_Txn_pub;
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
322: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
323: p_data => x_msg_data,
324: p_encoded => fnd_api.g_false);
325: WHEN OTHERS THEN

Line 324: p_encoded => fnd_api.g_false);

320: ROLLBACK TO Perform_Material_Txn_pub;
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
322: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
323: p_data => x_msg_data,
324: p_encoded => fnd_api.g_false);
325: WHEN OTHERS THEN
326: ROLLBACK TO Perform_Material_Txn_pub;
327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
328:

Line 327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

323: p_data => x_msg_data,
324: p_encoded => fnd_api.g_false);
325: WHEN OTHERS THEN
326: ROLLBACK TO Perform_Material_Txn_pub;
327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
328:
329: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
330: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
331: p_procedure_name => l_api_name,

Line 336: p_encoded => fnd_api.g_false);

332: p_error_text => SUBSTR(SQLERRM,1,240));
333: END IF;
334: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
335: p_data => x_msg_data,
336: p_encoded => fnd_api.g_false);
337: END Perform_Material_Txn;
338:
339: END AHL_PRD_MATERIAL_TXN_PUB;