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 AHL_RA_NR_PROFILE_PVT

Line 130: nrp_mat_tbl AHL_RA_NR_PROFILE_PVT.nrp_mat_req_tbl_type;

126: l_debug_module VARCHAR2(1000) := 'ahl.plsql.AHL_UMP_BOM_PVT.Process_Mr_Nr_Profile';
127: l_item_present_flag VARCHAR2(1);
128:
129: -- Variables for calling NR profile API.
130: nrp_mat_tbl AHL_RA_NR_PROFILE_PVT.nrp_mat_req_tbl_type;
131: nrp_res_tbl AHL_RA_NR_PROFILE_PVT.nrp_res_req_tbl_type;
132:
133:
134: -- Variables for calling NR profile API

Line 131: nrp_res_tbl AHL_RA_NR_PROFILE_PVT.nrp_res_req_tbl_type;

127: l_item_present_flag VARCHAR2(1);
128:
129: -- Variables for calling NR profile API.
130: nrp_mat_tbl AHL_RA_NR_PROFILE_PVT.nrp_mat_req_tbl_type;
131: nrp_res_tbl AHL_RA_NR_PROFILE_PVT.nrp_res_req_tbl_type;
132:
133:
134: -- Variables for calling NR profile API
135: l_return_status VARCHAR2(1);

Line 171: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' Calling API AHL_RA_NR_PROFILE_PVT.populate_prof_mat_req');

167: G_DEBUG_LINE_NUM := l_debug_module||': '||3010;
168:
169: -- Call NR profile material API
170: BEGIN
171: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' Calling API AHL_RA_NR_PROFILE_PVT.populate_prof_mat_req');
172: AHL_RA_NR_PROFILE_PVT.populate_prof_mat_req(
173: p_mr_header_id => p_mr_header_id,
174: p_instance_id => p_item_instance_id,
175: p_ue_id => p_unit_effectivity_id,

Line 172: AHL_RA_NR_PROFILE_PVT.populate_prof_mat_req(

168:
169: -- Call NR profile material API
170: BEGIN
171: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' Calling API AHL_RA_NR_PROFILE_PVT.populate_prof_mat_req');
172: AHL_RA_NR_PROFILE_PVT.populate_prof_mat_req(
173: p_mr_header_id => p_mr_header_id,
174: p_instance_id => p_item_instance_id,
175: p_ue_id => p_unit_effectivity_id,
176: p_plan_id => p_plan_id,

Line 186: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' Exception in AHL_RA_NR_PROFILE_PVT.populate_prof_mat_req -'||SQLERRM);

182: EXCEPTION
183: WHEN OTHERS
184: THEN
185: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' ****************************** Exception ******************************');
186: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' Exception in AHL_RA_NR_PROFILE_PVT.populate_prof_mat_req -'||SQLERRM);
187: g_ret_status := 2;
188: RAISE;
189: END;
190: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' Returned from call to AHL_NR_PROFILE_PVT.populate_prof_mat_req:' ||

Line 326: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' Calling API AHL_RA_NR_PROFILE_PVT.populate_prof_res_req');

322: l_msg_data:= NULL;
323: G_DEBUG_LINE_NUM := l_debug_module||': '||3170;
324:
325: -- Call NR profile resource API
326: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' Calling API AHL_RA_NR_PROFILE_PVT.populate_prof_res_req');
327: BEGIN
328: AHL_RA_NR_PROFILE_PVT.populate_prof_res_req(
329: p_mr_header_id => p_mr_header_id,
330: p_instance_id => p_item_instance_id,

Line 328: AHL_RA_NR_PROFILE_PVT.populate_prof_res_req(

324:
325: -- Call NR profile resource API
326: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' Calling API AHL_RA_NR_PROFILE_PVT.populate_prof_res_req');
327: BEGIN
328: AHL_RA_NR_PROFILE_PVT.populate_prof_res_req(
329: p_mr_header_id => p_mr_header_id,
330: p_instance_id => p_item_instance_id,
331: p_ue_id => p_unit_effectivity_id,
332: p_plan_id => p_plan_id,

Line 342: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' Exception in AHL_RA_NR_PROFILE_PVT.populate_prof_res_req -'||SQLERRM);

338: EXCEPTION
339: WHEN OTHERS
340: THEN
341: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' ****************************** Exception ******************************');
342: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' Exception in AHL_RA_NR_PROFILE_PVT.populate_prof_res_req -'||SQLERRM);
343: RAISE;
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);