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_FORECAST_REQ_PVT dependencies on AHL_UMP_FORECAST_REQ_PVT

Line 1: PACKAGE BODY AHL_UMP_FORECAST_REQ_PVT AS

1: PACKAGE BODY AHL_UMP_FORECAST_REQ_PVT AS
2: /* $Header: AHLVURQB.pls 120.1.12010000.2 2008/12/27 00:46:26 sracha ship $ */
3:
4: -----------------------
5: -- Declare Constants --

Line 7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_UMP_FORECAST_REQ_PVT';

3:
4: -----------------------
5: -- Declare Constants --
6: -----------------------
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_UMP_FORECAST_REQ_PVT';
8: --G_APP_MODULE CONSTANT VARCHAR2(30) := 'AHL';
9: G_APP_MODULE CONSTANT VARCHAR2(30) := RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE')));
10:
11: -- UMP Statuses

Line 174: l_debug_module varchar2(400) := 'AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast';

170: l_requirement_date DATE;
171: l_previous_route_id NUMBER;
172: l_previous_req_date DATE;
173:
174: l_debug_module varchar2(400) := 'AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast';
175:
176: BEGIN
177: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
178: fnd_log.string

Line 181: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast.begin',

177: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
178: fnd_log.string
179: (
180: G_DEBUG_PROC,
181: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast.begin',
182: 'At the start of PLSQL procedure'
183: );
184: END IF;
185:

Line 207: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

203: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
204: fnd_log.string
205: (
206: G_DEBUG_STMT,
207: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
208: 'Have succesfully deleted the orphan forecasts'
209: );
210: END IF;
211:

Line 219: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

215: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
216: fnd_log.string
217: (
218: G_DEBUG_STMT,
219: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
220: 'Processing unit effectivities for csi_item_instance_id : ' || P_applicable_instances_tbl(i).csi_item_instance_id
221: );
222: END IF;
223: FOR ue_mr_routes_rec IN ue_mr_routes_csr (P_applicable_instances_tbl(i).csi_item_instance_id) LOOP

Line 228: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

224: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
225: fnd_log.string
226: (
227: G_DEBUG_STMT ,
228: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
229: 'AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req API :p_route_id :p_mr_route_id : p_item_instance_id : p_requirement_date'
230: || ue_mr_routes_rec.route_id || ':' || ue_mr_routes_rec.mr_route_id || ':' ||P_applicable_instances_tbl(i).csi_item_instance_id
231: || ':' ||ue_mr_routes_rec.due_date
232: );

Line 245: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

241: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
242: fnd_log.string
243: (
244: G_DEBUG_STMT ,
245: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
246: 'AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req API :p_route_id :p_mr_route_id : '
247: || ue_mr_routes_rec.route_id || ':' || ue_mr_routes_rec.mr_route_id
248: );
249: END IF;

Line 287: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

283: IF(fnd_log.level_error >= G_DEBUG_LEVEL)THEN
284: fnd_log.string
285: (
286: fnd_log.level_error,
287: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
288: 'AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req Threw error'
289: );
290: END IF;
291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 300: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

296: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
297: fnd_log.string
298: (
299: G_DEBUG_STMT,
300: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
301: 'After call AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req API : l_Route_Mtl_Req_Tbl.COUNT : ' || l_Route_Mtl_Req_Tbl.COUNT
302: );
303: END IF;
304: FOR j IN l_Route_Mtl_Req_Tbl.FIRST..l_Route_Mtl_Req_Tbl.LAST LOOP

Line 313: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

309: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
310: fnd_log.string
311: (
312: G_DEBUG_STMT,
313: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
314: 'Inserting record in AHL_SCHEDULE_MATERIALS '
315: );
316: fnd_log.string
317: (

Line 319: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

315: );
316: fnd_log.string
317: (
318: G_DEBUG_STMT,
319: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
320: 'unit_effectivity_id : ' || ue_mr_routes_rec.unit_effectivity_id
321: );
322: fnd_log.string
323: (

Line 325: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

321: );
322: fnd_log.string
323: (
324: G_DEBUG_STMT,
325: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
326: 'requested_date : ' || ue_mr_routes_rec.due_date
327: );
328: fnd_log.string
329: (

Line 331: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

327: );
328: fnd_log.string
329: (
330: G_DEBUG_STMT,
331: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
332: 'mr_route_id : '|| ue_mr_routes_rec.mr_route_id
333: );
334: fnd_log.string
335: (

Line 337: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

333: );
334: fnd_log.string
335: (
336: G_DEBUG_STMT,
337: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
338: 'inventory_item_id : ' || l_Route_Mtl_Req_Tbl(j).inventory_item_id
339: );
340: fnd_log.string
341: (

Line 343: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

339: );
340: fnd_log.string
341: (
342: G_DEBUG_STMT,
343: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
344: 'quantity : ' || l_Route_Mtl_Req_Tbl(j).quantity
345: );
346: fnd_log.string
347: (

Line 349: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

345: );
346: fnd_log.string
347: (
348: G_DEBUG_STMT,
349: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
350: 'uom : ' || l_Route_Mtl_Req_Tbl(j).uom_code
351: );
352: END IF;
353: AHL_SCHEDULE_MATERIALS_PKG.INSERT_ROW

Line 413: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

409: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
410: fnd_log.string
411: (
412: G_DEBUG_STMT,
413: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
414: 'Updating record in AHL_SCHEDULE_MATERIALS '
415: );
416: fnd_log.string
417: (

Line 419: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

415: );
416: fnd_log.string
417: (
418: G_DEBUG_STMT,
419: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
420: 'unit_effectivity_id : ' || ue_mr_routes_rec.unit_effectivity_id
421: );
422: fnd_log.string
423: (

Line 425: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

421: );
422: fnd_log.string
423: (
424: G_DEBUG_STMT,
425: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
426: 'requested_date : ' || ue_mr_routes_rec.due_date
427: );
428: fnd_log.string
429: (

Line 431: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

427: );
428: fnd_log.string
429: (
430: G_DEBUG_STMT,
431: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
432: 'mr_route_id : '|| ue_mr_routes_rec.mr_route_id
433: );
434: fnd_log.string
435: (

Line 437: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

433: );
434: fnd_log.string
435: (
436: G_DEBUG_STMT,
437: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
438: 'inventory_item_id : ' || l_Route_Mtl_Req_Tbl(j).inventory_item_id
439: );
440: fnd_log.string
441: (

Line 443: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

439: );
440: fnd_log.string
441: (
442: G_DEBUG_STMT,
443: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
444: 'quantity : ' || l_Route_Mtl_Req_Tbl(j).quantity
445: );
446: fnd_log.string
447: (

Line 449: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

445: );
446: fnd_log.string
447: (
448: G_DEBUG_STMT,
449: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
450: 'uom : ' || l_Route_Mtl_Req_Tbl(j).uom_code
451: );
452: END IF;
453: AHL_SCHEDULE_MATERIALS_PKG.UPDATE_ROW

Line 519: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

515: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
516: fnd_log.string
517: (
518: G_DEBUG_STMT,
519: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
520: 'Have succesfully finished forecasting'
521: );
522: END IF;
523: -- Check Error Message stack.

Line 538: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast.end',

534: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)THEN
535: fnd_log.string
536: (
537: G_DEBUG_PROC,
538: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast.end',
539: 'At the end of PLSQL procedure'
540: );
541: END IF;
542:

Line 631: l_debug_module VARCHAR2(400) := 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Build_Mat_Forecast_Stream';

627: AND due_date IS NOT NULL
628: AND (status_code IS NULL OR status_code = 'INIT-DUE');
629: --ORDER BY csi_item_instance_id, due_date;
630:
631: l_debug_module VARCHAR2(400) := 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Build_Mat_Forecast_Stream';
632:
633: l_csi_item_instance_id NUMBER;
634: l_name ahl_unit_config_headers.name%TYPE;
635: l_instance_number csi_item_instances.instance_number%TYPE;

Line 764: AHL_UMP_FORECAST_REQ_PVT.process_mrl_req_forecast

760:
761: SAVEPOINT Build_Mrl_Forecast_Stream_s;
762:
763: --call for material requirement forecast
764: AHL_UMP_FORECAST_REQ_PVT.process_mrl_req_forecast
765: (
766: p_api_version => 1.0,
767: p_init_msg_list => FND_API.G_TRUE,
768: p_commit => FND_API.G_FALSE,

Line 823: AHL_UMP_FORECAST_REQ_PVT.Process_Material_Req

819: IF (l_mr_route_id_tbl.COUNT > 0) THEN
820: FOR k IN l_mr_route_id_tbl.FIRST..l_mr_route_id_tbl.LAST LOOP
821: -- validate and update/insert into schedule materials for
822: -- every combination of UE and mr_route_id.
823: AHL_UMP_FORECAST_REQ_PVT.Process_Material_Req
824: (p_unit_effectivity_id => l_ue_id_tbl(i),
825: p_csi_item_instance_id => l_ue_ii_id_tbl(i),
826: p_due_date => l_ue_due_date_tbl(i),
827: p_mr_route_id => l_mr_route_id_tbl(k),

Line 954: fnd_log.string ( G_DEBUG_PROC, 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Build_Config_Tree',

950:
951: BEGIN
952:
953: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)THEN
954: fnd_log.string ( G_DEBUG_PROC, 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Build_Config_Tree',
955: 'Start Build_Config_Tree');
956: END IF;
957:
958: -- For top node.

Line 999: fnd_log.string (G_DEBUG_PROC, 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Build_Config_Tree',

995:
996: X_CONFIG_NODE_TBL := l_config_node_tbl;
997:
998: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)THEN
999: fnd_log.string (G_DEBUG_PROC, 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Build_Config_Tree',
1000: 'Count on config' || x_config_node_tbl.COUNT);
1001:
1002: fnd_log.string (G_DEBUG_PROC, 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Build_Config_Tree',
1003: 'End Build_Config_Tree');

Line 1002: fnd_log.string (G_DEBUG_PROC, 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Build_Config_Tree',

998: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)THEN
999: fnd_log.string (G_DEBUG_PROC, 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Build_Config_Tree',
1000: 'Count on config' || x_config_node_tbl.COUNT);
1001:
1002: fnd_log.string (G_DEBUG_PROC, 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Build_Config_Tree',
1003: 'End Build_Config_Tree');
1004: END IF;
1005:
1006: END Build_Config_Tree;

Line 1040: l_debug_module VARCHAR2(1000) := 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Material_Req';

1036: AND SM.mr_route_id = p_mr_route_id
1037: AND SM.unit_effectivity_id = p_unit_effectivity_id
1038: FOR UPDATE OF REQUESTED_DATE NOWAIT;
1039:
1040: l_debug_module VARCHAR2(1000) := 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Material_Req';
1041: l_Schedule_Mtl_Req_rec AHL_SCHEDULE_MATERIALS%ROWTYPE;
1042: l_requirement_date DATE;
1043: l_Route_Mtl_Req_Tbl AHL_LTP_MTL_REQ_PVT.Route_Mtl_Req_Tbl_Type;
1044:

Line 1290: fnd_log.string (G_DEBUG_PROC, 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.log_error_messages',

1286:
1287: BEGIN
1288:
1289: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)THEN
1290: fnd_log.string (G_DEBUG_PROC, 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.log_error_messages',
1291: 'Start log error messages');
1292: END IF;
1293:
1294: -- Standard call to get message count.

Line 1306: fnd_log.string (G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.log_error_messages',

1302: p_msg_index_out => l_msg_index_out );
1303:
1304: fnd_file.put_line(FND_FILE.LOG, 'Err message-'||l_msg_index_out||':' || l_msg_data);
1305: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
1306: fnd_log.string (G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.log_error_messages',
1307: 'Err message-'||l_msg_index_out||':' || substr(l_msg_data,1,240));
1308: END IF;
1309:
1310: END LOOP;

Line 1313: fnd_log.string (G_DEBUG_PROC, 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.log_error_messages',

1309:
1310: END LOOP;
1311:
1312: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)THEN
1313: fnd_log.string (G_DEBUG_PROC, 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.log_error_messages',
1314: 'End log error messages');
1315: END IF;
1316:
1317: END log_error_messages;

Line 1319: END AHL_UMP_FORECAST_REQ_PVT;

1315: END IF;
1316:
1317: END log_error_messages;
1318:
1319: END AHL_UMP_FORECAST_REQ_PVT;