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_LOG

Line 3: ---------------------------- FND Logging Constants -----------------------------

1: PACKAGE BODY Ahl_Ump_Bom_Pvt AS
2: /* $Header: AHLVUMBB.pls 120.0.12020000.2 2012/12/07 16:08:12 sareepar noship $*/
3: ---------------------------- FND Logging Constants -----------------------------
4: G_DEBUG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: G_DEBUG_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
6: G_DEBUG_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
7: G_REQ_TYPE_FORECAST CONSTANT VARCHAR2(30) := 'FORECAST';

Line 4: G_DEBUG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1: PACKAGE BODY Ahl_Ump_Bom_Pvt AS
2: /* $Header: AHLVUMBB.pls 120.0.12020000.2 2012/12/07 16:08:12 sareepar noship $*/
3: ---------------------------- FND Logging Constants -----------------------------
4: G_DEBUG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: G_DEBUG_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
6: G_DEBUG_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
7: G_REQ_TYPE_FORECAST CONSTANT VARCHAR2(30) := 'FORECAST';
8:

Line 5: G_DEBUG_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

1: PACKAGE BODY Ahl_Ump_Bom_Pvt AS
2: /* $Header: AHLVUMBB.pls 120.0.12020000.2 2012/12/07 16:08:12 sareepar noship $*/
3: ---------------------------- FND Logging Constants -----------------------------
4: G_DEBUG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: G_DEBUG_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
6: G_DEBUG_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
7: G_REQ_TYPE_FORECAST CONSTANT VARCHAR2(30) := 'FORECAST';
8:
9: ---------------------------- Commit counter variable ---------------------------

Line 6: G_DEBUG_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

2: /* $Header: AHLVUMBB.pls 120.0.12020000.2 2012/12/07 16:08:12 sareepar noship $*/
3: ---------------------------- FND Logging Constants -----------------------------
4: G_DEBUG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: G_DEBUG_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
6: G_DEBUG_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
7: G_REQ_TYPE_FORECAST CONSTANT VARCHAR2(30) := 'FORECAST';
8:
9: ---------------------------- Commit counter variable ---------------------------
10: g_commit_counter NUMBER := 0;

Line 155: FND_LOG.STRING(G_DEBUG_PROC, l_debug_module, G_DEBUG_LINE_NUM||' Input Parameters to Process_Mr_Nr_Profile - ' ||

151:
152: -- Log
153: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)
154: THEN
155: FND_LOG.STRING(G_DEBUG_PROC, l_debug_module, G_DEBUG_LINE_NUM||' Input Parameters to Process_Mr_Nr_Profile - ' ||
156: ' p_mr_header_id = ' || p_mr_header_id ||
157: ' p_item_instance_id = '||p_item_instance_id||
158: ' p_unit_effectivity_id = '||p_unit_effectivity_id||
159: ' p_plan_id = '||p_plan_id);

Line 458: FND_LOG.STRING(G_DEBUG_PROC, l_debug_module, ' Leaving Process_Mr_Nr_Profile');

454: G_DEBUG_LINE_NUM := l_debug_module||': '||3340;
455: -- Log
456: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)
457: THEN
458: FND_LOG.STRING(G_DEBUG_PROC, l_debug_module, ' Leaving Process_Mr_Nr_Profile');
459: END IF;
460: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' Leaving Process_Mr_Nr_Profile');
461:
462: END Process_Mr_Nr_Profile;

Line 516: FND_LOG.STRING(G_DEBUG_PROC, l_debug_module, 'In Process_Material_Req. Parameters passed p_csi_item_instance_id ='||p_csi_item_instance_id||

512: G_DEBUG_LINE_NUM := l_debug_module||': '||4000;
513: -- Log
514: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)
515: THEN
516: FND_LOG.STRING(G_DEBUG_PROC, l_debug_module, 'In Process_Material_Req. Parameters passed p_csi_item_instance_id ='||p_csi_item_instance_id||
517: ' p_due_date ='||p_due_date||
518: ' p_org_id ='||p_org_id||
519: ' p_route_id_tbl.COUNT = '||p_route_id_tbl.COUNT||
520: ' p_mr_route_tbl.COUNT = '||p_mr_route_tbl.COUNT||

Line 701: fnd_log.string (G_DEBUG_PROC, l_debug_module, 'End of procedure Process_Material_Req');

697: ' should be equal to p_route_id_tbl.COUNT = '||p_route_id_tbl.COUNT);
698:
699: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)
700: THEN
701: fnd_log.string (G_DEBUG_PROC, l_debug_module, 'End of procedure Process_Material_Req');
702: END IF;
703: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' End of procedure Process_Material_Req');
704: END Process_Material_Req;
705: -----------------------------------End of Procedure Process_Material_Req-------------------------------------------------

Line 737: fnd_log.string (G_DEBUG_PROC, l_debug_module, G_DEBUG_LINE_NUM||' In procedure Perform_Updates');

733: BEGIN
734: G_DEBUG_LINE_NUM := l_debug_module||': '||7000;
735: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)
736: THEN
737: fnd_log.string (G_DEBUG_PROC, l_debug_module, G_DEBUG_LINE_NUM||' In procedure Perform_Updates');
738: END IF;
739: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' In procedure Perform_Updates');
740:
741: -- Insert/Update/Delete

Line 905: fnd_log.string (G_DEBUG_PROC, l_debug_module, G_DEBUG_LINE_NUM||' End of procedure Perform_Updates');

901:
902: END IF;
903: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)
904: THEN
905: fnd_log.string (G_DEBUG_PROC, l_debug_module, G_DEBUG_LINE_NUM||' End of procedure Perform_Updates');
906: END IF;
907: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' End of procedure Perform_Updates');
908: EXCEPTION
909: WHEN OTHERS

Line 917: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'Error in procedure Perform_Updates');

913: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
914: THEN
915: g_err_msg := substr(SQLERRM, 1, 3900);
916: g_err_code := SQLCODE;
917: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'Error in procedure Perform_Updates');
918: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'error code is '||g_err_code);
919: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'error message is '||g_err_msg);
920: END IF;
921: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' Error in procedure Perform_Updates');

Line 918: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'error code is '||g_err_code);

914: THEN
915: g_err_msg := substr(SQLERRM, 1, 3900);
916: g_err_code := SQLCODE;
917: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'Error in procedure Perform_Updates');
918: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'error code is '||g_err_code);
919: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'error message is '||g_err_msg);
920: END IF;
921: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' Error in procedure Perform_Updates');
922: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' error code is '||g_err_code);

Line 919: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'error message is '||g_err_msg);

915: g_err_msg := substr(SQLERRM, 1, 3900);
916: g_err_code := SQLCODE;
917: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'Error in procedure Perform_Updates');
918: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'error code is '||g_err_code);
919: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'error message is '||g_err_msg);
920: END IF;
921: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' Error in procedure Perform_Updates');
922: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' error code is '||g_err_code);
923: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' error message is '||g_err_msg);

Line 1375: FND_LOG.STRING(G_DEBUG_PROC, l_debug_module, 'In Procedure Process_Ue. Input Paramters - '||

1371: -- Log
1372: G_DEBUG_LINE_NUM := l_debug_module||': '||2000;
1373: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)
1374: THEN
1375: FND_LOG.STRING(G_DEBUG_PROC, l_debug_module, 'In Procedure Process_Ue. Input Paramters - '||
1376: ' p_unit_effectivity_id = '||p_unit_effectivity_id ||
1377: ' p_group_mr_flag = '||p_group_mr_flag ||
1378: ' p_mr_header_id = '||p_mr_header_id ||
1379: ' p_item_instance_id = '||p_item_instance_id ||

Line 2306: fnd_log.string (G_DEBUG_PROC, l_debug_module, G_DEBUG_LINE_NUM||' End of procedure Process_Ue');

2302: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' Back from Perform_Updates');
2303: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' UE processing is complete');
2304: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)
2305: THEN
2306: fnd_log.string (G_DEBUG_PROC, l_debug_module, G_DEBUG_LINE_NUM||' End of procedure Process_Ue');
2307: END IF;
2308:
2309: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' End of procedure Process_Ue');
2310: EXCEPTION

Line 2636: fnd_log.string (G_DEBUG_PROC, l_debug_module, 'Start Create_Update_Ump_Bom');

2632: BEGIN
2633:
2634: G_DEBUG_LINE_NUM := l_debug_module||': '||1;
2635: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
2636: fnd_log.string (G_DEBUG_PROC, l_debug_module, 'Start Create_Update_Ump_Bom');
2637: fnd_log.string (G_DEBUG_PROC, l_debug_module, 'Input Parameter: p_sim_plan_name:' || p_sim_plan_name);
2638: fnd_log.string (G_DEBUG_PROC, l_debug_module, 'Input Parameter: p_all_flag:' || p_all_flag);
2639: END IF;
2640: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' Start Create_Update_Ump_Bom');

Line 2637: fnd_log.string (G_DEBUG_PROC, l_debug_module, 'Input Parameter: p_sim_plan_name:' || p_sim_plan_name);

2633:
2634: G_DEBUG_LINE_NUM := l_debug_module||': '||1;
2635: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
2636: fnd_log.string (G_DEBUG_PROC, l_debug_module, 'Start Create_Update_Ump_Bom');
2637: fnd_log.string (G_DEBUG_PROC, l_debug_module, 'Input Parameter: p_sim_plan_name:' || p_sim_plan_name);
2638: fnd_log.string (G_DEBUG_PROC, l_debug_module, 'Input Parameter: p_all_flag:' || p_all_flag);
2639: END IF;
2640: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' Start Create_Update_Ump_Bom');
2641: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' Input Parameter: p_sim_plan_name:' || p_sim_plan_name);

Line 2638: fnd_log.string (G_DEBUG_PROC, l_debug_module, 'Input Parameter: p_all_flag:' || p_all_flag);

2634: G_DEBUG_LINE_NUM := l_debug_module||': '||1;
2635: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
2636: fnd_log.string (G_DEBUG_PROC, l_debug_module, 'Start Create_Update_Ump_Bom');
2637: fnd_log.string (G_DEBUG_PROC, l_debug_module, 'Input Parameter: p_sim_plan_name:' || p_sim_plan_name);
2638: fnd_log.string (G_DEBUG_PROC, l_debug_module, 'Input Parameter: p_all_flag:' || p_all_flag);
2639: END IF;
2640: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' Start Create_Update_Ump_Bom');
2641: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' Input Parameter: p_sim_plan_name:' || p_sim_plan_name);
2642: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' Input Parameter: p_all_flag:' || p_all_flag);

Line 3938: fnd_log.string (G_DEBUG_STMT, l_debug_module, G_DEBUG_LINE_NUM||' Error in procedure Create_Update_Ump_Bom');

3934: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
3935: THEN
3936: g_err_msg := substr(SQLERRM, 1, 3900);
3937: g_err_code := SQLCODE;
3938: fnd_log.string (G_DEBUG_STMT, l_debug_module, G_DEBUG_LINE_NUM||' Error in procedure Create_Update_Ump_Bom');
3939: fnd_log.string (G_DEBUG_STMT, l_debug_module, G_DEBUG_LINE_NUM||' error code is '||g_err_code);
3940: fnd_log.string (G_DEBUG_STMT, l_debug_module, G_DEBUG_LINE_NUM||' error message is '||g_err_msg);
3941: END IF;
3942: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' Error in procedure Create_Update_Ump_Bom');

Line 3939: fnd_log.string (G_DEBUG_STMT, l_debug_module, G_DEBUG_LINE_NUM||' error code is '||g_err_code);

3935: THEN
3936: g_err_msg := substr(SQLERRM, 1, 3900);
3937: g_err_code := SQLCODE;
3938: fnd_log.string (G_DEBUG_STMT, l_debug_module, G_DEBUG_LINE_NUM||' Error in procedure Create_Update_Ump_Bom');
3939: fnd_log.string (G_DEBUG_STMT, l_debug_module, G_DEBUG_LINE_NUM||' error code is '||g_err_code);
3940: fnd_log.string (G_DEBUG_STMT, l_debug_module, G_DEBUG_LINE_NUM||' error message is '||g_err_msg);
3941: END IF;
3942: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' Error in procedure Create_Update_Ump_Bom');
3943: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' error code is '||g_err_code);

Line 3940: fnd_log.string (G_DEBUG_STMT, l_debug_module, G_DEBUG_LINE_NUM||' error message is '||g_err_msg);

3936: g_err_msg := substr(SQLERRM, 1, 3900);
3937: g_err_code := SQLCODE;
3938: fnd_log.string (G_DEBUG_STMT, l_debug_module, G_DEBUG_LINE_NUM||' Error in procedure Create_Update_Ump_Bom');
3939: fnd_log.string (G_DEBUG_STMT, l_debug_module, G_DEBUG_LINE_NUM||' error code is '||g_err_code);
3940: fnd_log.string (G_DEBUG_STMT, l_debug_module, G_DEBUG_LINE_NUM||' error message is '||g_err_msg);
3941: END IF;
3942: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' Error in procedure Create_Update_Ump_Bom');
3943: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' error code is '||g_err_code);
3944: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' error message is '||g_err_msg);