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

Line 194: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)

190: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' Returned from call to AHL_NR_PROFILE_PVT.populate_prof_mat_req:' ||
191: ' x_return_status = ' || l_return_status || ' nrp_mat_tbl.COUNT = '||nrp_mat_tbl.COUNT);
192:
193:
194: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
195: THEN
196: G_DEBUG_LINE_NUM := l_debug_module||': '||3020;
197: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' ****************************** Unexpected Error ******************************');
198: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' AHL_NR_PROFILE_PVT.populate_prof_mat_req Threw Unexpected Error');

Line 204: p_encoded => FND_API.G_FALSE,

200: IF (l_msg_count > 0) THEN
201: FOR i IN 1..l_msg_count
202: LOOP
203: fnd_msg_pub.get( p_msg_index => i,
204: p_encoded => FND_API.G_FALSE,
205: p_data => l_err_msg,
206: p_msg_index_out => l_msg_index_out);
207:
208: fnd_file.put_line(FND_FILE.LOG, 'Error message-'||l_msg_index_out||':' || l_err_msg);

Line 212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

208: fnd_file.put_line(FND_FILE.LOG, 'Error message-'||l_msg_index_out||':' || l_err_msg);
209: END LOOP;
210: END IF;
211: g_ret_status := 1;
212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
213: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
214: THEN
215: G_DEBUG_LINE_NUM := l_debug_module||': '||3030;
216: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' ******************************* Error ******************************');

Line 213: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)

209: END LOOP;
210: END IF;
211: g_ret_status := 1;
212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
213: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
214: THEN
215: G_DEBUG_LINE_NUM := l_debug_module||': '||3030;
216: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' ******************************* Error ******************************');
217: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' AHL_NR_PROFILE_PVT.populate_prof_mat_req Threw Error');

Line 223: p_encoded => FND_API.G_FALSE,

219: IF (l_msg_count > 0) THEN
220: FOR i IN 1..l_msg_count
221: LOOP
222: fnd_msg_pub.get( p_msg_index => i,
223: p_encoded => FND_API.G_FALSE,
224: p_data => l_err_msg,
225: p_msg_index_out => l_msg_index_out);
226:
227: fnd_file.put_line(FND_FILE.LOG, 'Error message-'||l_msg_index_out||':' || l_err_msg);

Line 231: RAISE FND_API.G_EXC_ERROR;

227: fnd_file.put_line(FND_FILE.LOG, 'Error message-'||l_msg_index_out||':' || l_err_msg);
228: END LOOP;
229: END IF;
230: g_ret_status := 1;
231: RAISE FND_API.G_EXC_ERROR;
232: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS)
233: THEN
234: -- Populate p_x_consolidated_mat_tbl variable to be returned
235: G_DEBUG_LINE_NUM := l_debug_module||': '||3040;

Line 232: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS)

228: END LOOP;
229: END IF;
230: g_ret_status := 1;
231: RAISE FND_API.G_EXC_ERROR;
232: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS)
233: THEN
234: -- Populate p_x_consolidated_mat_tbl variable to be returned
235: G_DEBUG_LINE_NUM := l_debug_module||': '||3040;
236:

Line 348: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)

344: END;
345: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' Returned from call to AHL_NR_PROFILE_PVT.populate_prof_res_req:' ||
346: ' x_return_status = ' || l_return_status || ' nrp_res_tbl.COUNT = '||nrp_res_tbl.COUNT);
347: G_DEBUG_LINE_NUM := l_debug_module||': '||3180;
348: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
349: THEN
350: G_DEBUG_LINE_NUM := l_debug_module||': '||3185;
351: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' ******************************* Unexpected Error ******************************');
352: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||'AHL_NR_PROFILE_PVT.populate_prof_res_req Threw Unexpected Error');

Line 359: p_encoded => FND_API.G_FALSE,

355: IF (l_msg_count > 0) THEN
356: FOR i IN 1..l_msg_count
357: LOOP
358: fnd_msg_pub.get( p_msg_index => i,
359: p_encoded => FND_API.G_FALSE,
360: p_data => l_err_msg,
361: p_msg_index_out => l_msg_index_out);
362:
363: fnd_file.put_line(FND_FILE.LOG, 'Error message-'||l_msg_index_out||':' || l_err_msg);

Line 367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

363: fnd_file.put_line(FND_FILE.LOG, 'Error message-'||l_msg_index_out||':' || l_err_msg);
364: END LOOP;
365: END IF;
366: g_ret_status := 1;
367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
368: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
369: THEN
370: G_DEBUG_LINE_NUM := l_debug_module||': '||3187;
371: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' ******************************* Error ******************************');

Line 368: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)

364: END LOOP;
365: END IF;
366: g_ret_status := 1;
367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
368: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR)
369: THEN
370: G_DEBUG_LINE_NUM := l_debug_module||': '||3187;
371: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' ******************************* Error ******************************');
372: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||'AHL_NR_PROFILE_PVT.populate_prof_res_req Threw Error');

Line 379: p_encoded => FND_API.G_FALSE,

375: IF (l_msg_count > 0) THEN
376: FOR i IN 1..l_msg_count
377: LOOP
378: fnd_msg_pub.get( p_msg_index => i,
379: p_encoded => FND_API.G_FALSE,
380: p_data => l_err_msg,
381: p_msg_index_out => l_msg_index_out);
382:
383: fnd_file.put_line(FND_FILE.LOG, 'Error message-'||l_msg_index_out||':' || l_err_msg);

Line 387: RAISE FND_API.G_EXC_ERROR;

383: fnd_file.put_line(FND_FILE.LOG, 'Error message-'||l_msg_index_out||':' || l_err_msg);
384: END LOOP;
385: END IF;
386: g_ret_status := 1;
387: RAISE FND_API.G_EXC_ERROR;
388: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS)
389: THEN
390: G_DEBUG_LINE_NUM := l_debug_module||': '||3190;
391:

Line 388: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS)

384: END LOOP;
385: END IF;
386: g_ret_status := 1;
387: RAISE FND_API.G_EXC_ERROR;
388: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS)
389: THEN
390: G_DEBUG_LINE_NUM := l_debug_module||': '||3190;
391:
392: -- Populate p_x_consolidated_res_tbl variable to be returned

Line 567: p_init_msg_list => FND_API.G_FALSE,

563: ' p_requirement_date:'||l_requirement_date);
564: G_DEBUG_LINE_NUM := l_debug_module||': '||4050;
565: BEGIN
566: AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req (p_api_version => 1.0,
567: p_init_msg_list => FND_API.G_FALSE,
568: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
569: x_return_status => l_return_status,
570: x_msg_count => l_msg_count,
571: x_msg_data => l_msg_data,

Line 568: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

564: G_DEBUG_LINE_NUM := l_debug_module||': '||4050;
565: BEGIN
566: AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req (p_api_version => 1.0,
567: p_init_msg_list => FND_API.G_FALSE,
568: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
569: x_return_status => l_return_status,
570: x_msg_count => l_msg_count,
571: x_msg_data => l_msg_data,
572: p_route_id => p_route_id_tbl(k),

Line 587: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

583: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' Exception in AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req -'||SQLERRM);
584: g_ret_status := 2;
585: RAISE;
586: END;
587: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
588: THEN
589:
590: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' ****************************** AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req Threw error ****************************** ');
591: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' message data = '||l_msg_data);

Line 598: p_encoded => FND_API.G_FALSE,

594:
595: FOR i IN 1..l_msg_count
596: LOOP
597: fnd_msg_pub.get( p_msg_index => i,
598: p_encoded => FND_API.G_FALSE,
599: p_data => l_err_msg,
600: p_msg_index_out => l_msg_index_out);
601:
602: fnd_file.put_line(FND_FILE.LOG, 'Error message-'||l_msg_index_out||':' || l_err_msg);

Line 606: RAISE FND_API.G_EXC_ERROR;-- Raise Error

602: fnd_file.put_line(FND_FILE.LOG, 'Error message-'||l_msg_index_out||':' || l_err_msg);
603: END LOOP;
604: END IF;
605: g_ret_status := 1;
606: RAISE FND_API.G_EXC_ERROR;-- Raise Error
607: END IF;
608:
609: --Log
610: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' After AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req, l_Route_Mtl_Req_Tbl.COUNT = '||l_Route_Mtl_Req_Tbl.COUNT);

Line 2311: WHEN FND_API.G_EXC_ERROR THEN

2307: END IF;
2308:
2309: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' End of procedure Process_Ue');
2310: EXCEPTION
2311: WHEN FND_API.G_EXC_ERROR THEN
2312: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM|| ' Caught FND_API.G_EXC_ERROR');
2313: g_ret_status := 1;
2314: l_msg_count := Fnd_Msg_Pub.count_msg;
2315: IF (l_msg_count > 0) THEN

Line 2312: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM|| ' Caught FND_API.G_EXC_ERROR');

2308:
2309: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' End of procedure Process_Ue');
2310: EXCEPTION
2311: WHEN FND_API.G_EXC_ERROR THEN
2312: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM|| ' Caught FND_API.G_EXC_ERROR');
2313: g_ret_status := 1;
2314: l_msg_count := Fnd_Msg_Pub.count_msg;
2315: IF (l_msg_count > 0) THEN
2316: FOR i IN 1..l_msg_count

Line 2319: p_encoded => FND_API.G_FALSE,

2315: IF (l_msg_count > 0) THEN
2316: FOR i IN 1..l_msg_count
2317: LOOP
2318: fnd_msg_pub.get( p_msg_index => i,
2319: p_encoded => FND_API.G_FALSE,
2320: p_data => l_err_msg,
2321: p_msg_index_out => l_msg_index_out);
2322:
2323: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM|| 'Error message-'||l_msg_index_out||':' || l_err_msg);

Line 2327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2323: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM|| 'Error message-'||l_msg_index_out||':' || l_err_msg);
2324: END LOOP;
2325: END IF;
2326:
2327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2328: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM|| ' Caught G_EXC_UNEXPECTED_ERROR');
2329: g_ret_status := 1;
2330: l_msg_count := Fnd_Msg_Pub.count_msg;
2331: IF (l_msg_count > 0) THEN

Line 2335: p_encoded => FND_API.G_FALSE,

2331: IF (l_msg_count > 0) THEN
2332: FOR i IN 1..l_msg_count
2333: LOOP
2334: fnd_msg_pub.get( p_msg_index => i,
2335: p_encoded => FND_API.G_FALSE,
2336: p_data => l_err_msg,
2337: p_msg_index_out => l_msg_index_out);
2338:
2339: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM|| 'Error message-'||l_msg_index_out||':' || l_err_msg);

Line 2351: p_encoded => FND_API.G_FALSE,

2347: IF (l_msg_count > 0) THEN
2348: FOR i IN 1..l_msg_count
2349: LOOP
2350: fnd_msg_pub.get( p_msg_index => i,
2351: p_encoded => FND_API.G_FALSE,
2352: p_data => l_err_msg,
2353: p_msg_index_out => l_msg_index_out);
2354:
2355: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM|| 'Error message-'||l_msg_index_out||':' || l_err_msg);