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.BIS_PMF_REG_SERVICE_PVT dependencies on BIS_UTILITIES_PVT

Line 447: bis_utilities_pvt.set_debug_log_flag ( -- 2715218

443: l_alert_based_on := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET;
444: END IF;
445:
446: -- Debug messages should not be printed (irrespective of debug profile option).
447: bis_utilities_pvt.set_debug_log_flag ( -- 2715218
448: p_is_true => FALSE
449: , x_return_status => l_return_status
450: , x_return_msg => l_return_msg
451: ) ;

Line 507: := BIS_UTILITIES_PVT.Get_FND_Message

503:
504: IF l_object_tbl.COUNT < 1 THEN
505: --p_request_id := '-1';
506: p_request_id
507: := BIS_UTILITIES_PVT.Get_FND_Message
508: ( p_message_name => 'BIS_AK_NOT_SET_UP_MSG'
509: , p_msg_param1 => 'MEASURE_NAME'
510: , p_msg_param1_val => bis_utilities_pvt.escape_html(l_measure_name)
511: );

Line 510: , p_msg_param1_val => bis_utilities_pvt.escape_html(l_measure_name)

506: p_request_id
507: := BIS_UTILITIES_PVT.Get_FND_Message
508: ( p_message_name => 'BIS_AK_NOT_SET_UP_MSG'
509: , p_msg_param1 => 'MEASURE_NAME'
510: , p_msg_param1_val => bis_utilities_pvt.escape_html(l_measure_name)
511: );
512:
513: -- dbms_output.put_line('bisvarsb. process_parameter full set 0005 ');
514:

Line 686: BIS_UTILITIES_PVT.Add_Error_Message

682: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
683: l_debug :=l_debug||' exception 3 at process_parameter_full_set. '||sqlerrm;
684: p_request_id := l_request_id ||l_debug;
685: l_error_tbl_p := l_error_tbl;
686: BIS_UTILITIES_PVT.Add_Error_Message
687: ( p_error_msg_id => SQLCODE
688: , p_error_description => SQLERRM
689: , p_error_proc_name => 'Process_Parameter_set'
690: , p_error_table => l_error_tbl_p

Line 929: BIS_UTILITIES_PVT.Add_Error_Message

925: p_request_id := l_request_id||', debug: '||l_debug_text
926: ||' exception 3 in submit_parameter_set_request '||sqlerrm;
927: BIS_UTILITIES_PUB.put_line(p_text =>'debug: '||l_debug_text);
928: l_error_Tbl_p := l_error_Tbl;
929: BIS_UTILITIES_PVT.Add_Error_Message
930: ( p_error_msg_id => SQLCODE
931: , p_error_description => SQLERRM
932: , p_error_proc_name => 'submit_parameter_set_request'
933: , p_error_table => l_error_tbl_p

Line 1164: BIS_UTILITIES_PVT.Add_Error_Message

1160: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1161: l_debug :=l_debug||' exception 3 at add_parameter_set. '||sqlerrm;
1162: x_request_id := x_request_id ||l_debug;
1163: l_error_tbl_p := l_error_tbl;
1164: BIS_UTILITIES_PVT.Add_Error_Message
1165: ( p_error_msg_id => SQLCODE
1166: , p_error_description => SQLERRM
1167: , p_error_proc_name => 'Add_Parameter_set'
1168: , p_error_table => l_error_tbl_p

Line 1321: BIS_UTILITIES_PVT.Add_Error_Message

1317: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1318: l_debug :=l_debug||' exception 3 at process_report_set_request. '||sqlerrm;
1319: x_request_id := x_request_id ||l_debug;
1320: l_error_tbl_p := l_error_Tbl;
1321: BIS_UTILITIES_PVT.Add_Error_Message
1322: ( p_error_msg_id => SQLCODE
1323: , p_error_description => SQLERRM
1324: , p_error_proc_name => 'process_report_set_request'
1325: , p_error_table => l_error_tbl_p

Line 1394: BIS_UTILITIES_PVT.Add_Error_Message

1390: l_debug :=l_debug
1391: ||' exception 3 at process_batch_report_request. '||sqlerrm;
1392: x_request_id := x_request_id ||l_debug;
1393: l_error_tbl_p := l_error_tbl;
1394: BIS_UTILITIES_PVT.Add_Error_Message
1395: ( p_error_msg_id => SQLCODE
1396: , p_error_description => SQLERRM
1397: , p_error_proc_name => 'process_batch_report_request'
1398: , p_error_table => l_error_tbl_p

Line 1483: BIS_UTILITIES_PVT.Add_Error_Message

1479: p_request_id := l_request_id
1480: ||' exception 3 in process_parameter_set ';
1481: BIS_UTILITIES_PUB.put_line(p_text =>'process_parameter_set exception3: '||sqlerrm);
1482: l_error_tbl_p := l_error_tbl;
1483: BIS_UTILITIES_PVT.Add_Error_Message
1484: ( p_error_msg_id => SQLCODE
1485: , p_error_description => SQLERRM
1486: , p_error_proc_name => 'Process_Parameter_set'
1487: , p_error_table => l_error_tbl_p

Line 1599: BIS_UTILITIES_PVT.Add_Error_Message

1595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1596: x_return_status := ' exception 3 in Register_Parameter_Set '||sqlerrm;
1597: BIS_UTILITIES_PUB.put_line(p_text =>'register_parameter_set exception3: '||sqlerrm);
1598: l_error_tbl := x_error_Tbl;
1599: BIS_UTILITIES_PVT.Add_Error_Message
1600: ( p_error_msg_id => SQLCODE
1601: , p_error_description => SQLERRM
1602: , p_error_proc_name => 'Register_Parameter_Set'
1603: , p_error_table => l_error_tbl

Line 1655: := BIS_UTILITIES_PVT.Get_FND_Message

1651: ELSE
1652: -- wf_directory.AddUsersToAdHocRole(l_notifiers_code,l_user);
1653: wf_local_synch.propagateUserRole(p_role_name => l_notifiers_code, p_user_name => l_user);
1654: l_request_id
1655: := BIS_UTILITIES_PVT.Get_FND_Message
1656: ( p_message_name => 'BIS_NOTIFIER_ADDED'
1657: , p_msg_param1 => 'USER_NAME'
1658: , p_msg_param1_val => l_user
1659: );

Line 1728: l_time_level_short_name := BIS_UTILITIES_PVT.GET_TIME_SHORT_NAME(p_time_dimension_level_id);

1724: l_is_total_time := IS_TOTAL_DIM_LEVEL(p_time_dimension_level_id);
1725:
1726: --added to allow RSG call to let thr' for all time levels
1727: IF (p_time_dimension_level_id IS NOT NULL) THEN
1728: l_time_level_short_name := BIS_UTILITIES_PVT.GET_TIME_SHORT_NAME(p_time_dimension_level_id);
1729: END IF;
1730:
1731: l_Is_Rolling_Period_Level := BIS_UTILITIES_PVT.Is_Rolling_Period_Level( -- bug 2408906
1732: p_level_short_name => l_time_level_short_name ); -- BIS_UTILITIES_PUB.put_line(p_text =>'Time Level short Name ' || l_time_level_short_name);

Line 1731: l_Is_Rolling_Period_Level := BIS_UTILITIES_PVT.Is_Rolling_Period_Level( -- bug 2408906

1727: IF (p_time_dimension_level_id IS NOT NULL) THEN
1728: l_time_level_short_name := BIS_UTILITIES_PVT.GET_TIME_SHORT_NAME(p_time_dimension_level_id);
1729: END IF;
1730:
1731: l_Is_Rolling_Period_Level := BIS_UTILITIES_PVT.Is_Rolling_Period_Level( -- bug 2408906
1732: p_level_short_name => l_time_level_short_name ); -- BIS_UTILITIES_PUB.put_line(p_text =>'Time Level short Name ' || l_time_level_short_name);
1733: IF (p_time_dimension_level_id IS NOT NULL) THEN --added to allow RSG call to let thr' for all time levels
1734: l_time_short_name := BIS_UTILITIES_PVT.Get_Time_Dimension_Name (p_DimLevelId => p_time_dimension_level_id); -- BIS_UTILITIES_PUB.put_line(p_text =>'Time short Name ' || l_time_short_name);
1735: l_total_time_level_short := BIS_UTILITIES_PVT.Get_Total_Dimlevel_Name (l_time_short_name , NULL, l_time_level_short_name); -- BIS_UTILITIES_PUB.put_line(p_text =>'Total Time Level short Name ' || l_total_time_level_short);

Line 1734: l_time_short_name := BIS_UTILITIES_PVT.Get_Time_Dimension_Name (p_DimLevelId => p_time_dimension_level_id); -- BIS_UTILITIES_PUB.put_line(p_text =>'Time short Name ' || l_time_short_name);

1730:
1731: l_Is_Rolling_Period_Level := BIS_UTILITIES_PVT.Is_Rolling_Period_Level( -- bug 2408906
1732: p_level_short_name => l_time_level_short_name ); -- BIS_UTILITIES_PUB.put_line(p_text =>'Time Level short Name ' || l_time_level_short_name);
1733: IF (p_time_dimension_level_id IS NOT NULL) THEN --added to allow RSG call to let thr' for all time levels
1734: l_time_short_name := BIS_UTILITIES_PVT.Get_Time_Dimension_Name (p_DimLevelId => p_time_dimension_level_id); -- BIS_UTILITIES_PUB.put_line(p_text =>'Time short Name ' || l_time_short_name);
1735: l_total_time_level_short := BIS_UTILITIES_PVT.Get_Total_Dimlevel_Name (l_time_short_name , NULL, l_time_level_short_name); -- BIS_UTILITIES_PUB.put_line(p_text =>'Total Time Level short Name ' || l_total_time_level_short);
1736: END IF;
1737:
1738: BIS_UTILITIES_PUB.put_line(p_text => ' --------------------------------------------- ' );

Line 1735: l_total_time_level_short := BIS_UTILITIES_PVT.Get_Total_Dimlevel_Name (l_time_short_name , NULL, l_time_level_short_name); -- BIS_UTILITIES_PUB.put_line(p_text =>'Total Time Level short Name ' || l_total_time_level_short);

1731: l_Is_Rolling_Period_Level := BIS_UTILITIES_PVT.Is_Rolling_Period_Level( -- bug 2408906
1732: p_level_short_name => l_time_level_short_name ); -- BIS_UTILITIES_PUB.put_line(p_text =>'Time Level short Name ' || l_time_level_short_name);
1733: IF (p_time_dimension_level_id IS NOT NULL) THEN --added to allow RSG call to let thr' for all time levels
1734: l_time_short_name := BIS_UTILITIES_PVT.Get_Time_Dimension_Name (p_DimLevelId => p_time_dimension_level_id); -- BIS_UTILITIES_PUB.put_line(p_text =>'Time short Name ' || l_time_short_name);
1735: l_total_time_level_short := BIS_UTILITIES_PVT.Get_Total_Dimlevel_Name (l_time_short_name , NULL, l_time_level_short_name); -- BIS_UTILITIES_PUB.put_line(p_text =>'Total Time Level short Name ' || l_total_time_level_short);
1736: END IF;
1737:
1738: BIS_UTILITIES_PUB.put_line(p_text => ' --------------------------------------------- ' );
1739:

Line 1965: BIS_UTILITIES_PVT.Add_Error_Message

1961: when others then
1962: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1963: BIS_UTILITIES_PUB.put_line(p_text =>'exception 3 at Retrieve_target_info: '||sqlerrm);
1964: l_error_tbl := x_error_tbl;
1965: BIS_UTILITIES_PVT.Add_Error_Message
1966: ( p_error_msg_id => SQLCODE
1967: , p_error_description => SQLERRM
1968: , p_error_proc_name => G_PKG_NAME||'.Retrieve_target_info'
1969: , p_error_table => l_error_tbl

Line 2182: BIS_UTILITIES_PVT.Add_Error_Message

2178: when others then
2179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2180: BIS_UTILITIES_PUB.put_line(p_text =>'exception 3 at Retrieve_target_info: '||sqlerrm);
2181: l_error_tbl := x_error_Tbl;
2182: BIS_UTILITIES_PVT.Add_Error_Message
2183: ( p_error_msg_id => SQLCODE
2184: , p_error_description => SQLERRM
2185: , p_error_proc_name => G_PKG_NAME||'.Retrieve_target_info'
2186: , p_error_table => l_error_tbl

Line 2732: := BIS_UTILITIES_PVT.Get_FND_Message

2728: BIS_UTILITIES_PUB.put_line(p_text =>'Setting repeat result: '||l_repeat_result);
2729: l_debug_text:= l_debug_text||' Setting repeat result: '||l_repeat_result;
2730:
2731: l_request_desc
2732: := BIS_UTILITIES_PVT.Get_FND_Message
2733: ( p_message_name => G_ALERT_CONC_REQ_NAME
2734: , p_msg_param1 => 'MEASURE_NAME'
2735: , p_msg_param1_val => l_measure_rec.MEASURE_NAME
2736: , p_msg_param2 => 'TIME_LEVEL'

Line 2764: l_submit_result := BIS_UTILITIES_PVT.Get_FND_Message

2760: l_debug_text:= l_debug_text||' Submit concurrent requests result: '
2761: ||ERRBUF||', code: '||RETCODE;
2762:
2763: IF ((l_request_id = 0) OR (l_request_id IS NULL)) THEN -- 2568688
2764: l_submit_result := BIS_UTILITIES_PVT.Get_FND_Message
2765: ( p_message_name => G_FAILED_MSG)
2766: || ' ' || ERRBUF ;
2767: ELSE
2768: l_submit_result := BIS_UTILITIES_PVT.Get_FND_Message

Line 2768: l_submit_result := BIS_UTILITIES_PVT.Get_FND_Message

2764: l_submit_result := BIS_UTILITIES_PVT.Get_FND_Message
2765: ( p_message_name => G_FAILED_MSG)
2766: || ' ' || ERRBUF ;
2767: ELSE
2768: l_submit_result := BIS_UTILITIES_PVT.Get_FND_Message
2769: ( p_message_name => G_SUCCESS_MSG
2770: , p_msg_param1 => G_REQUEST_ID_TOK
2771: , p_msg_param1_val => l_request_id
2772: );

Line 2795: BIS_UTILITIES_PVT.Add_Error_Message

2791: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2792: p_request_id := l_request_id
2793: ||' exception 3 in submit_conc_request '||sqlerrm;
2794: l_error_tbl_p := l_error_tbl;
2795: BIS_UTILITIES_PVT.Add_Error_Message
2796: ( p_error_msg_id => SQLCODE
2797: , p_error_description => SQLERRM
2798: , p_error_proc_name => 'submit_conc_request'
2799: , p_error_table => l_error_tbl_p

Line 3040: := BIS_UTILITIES_PVT.G_BIS_APPLICATION_SHORT_NAME;

3036: l_Concurrent_Request_rec := x_Concurrent_Request_rec;
3037: BIS_UTILITIES_PUB.put_line(p_text =>'Forming concurrent request');
3038:
3039: l_Concurrent_Request_rec.application_short_name
3040: := BIS_UTILITIES_PVT.G_BIS_APPLICATION_SHORT_NAME;
3041: l_Concurrent_Request_rec.program
3042: := BIS_CONCURRENT_MANAGER_PVT.G_ALERT_PROGRAM;
3043: l_Concurrent_Request_rec.start_time := p_start_time;
3044: l_Concurrent_Request_rec.description := p_request_desc;

Line 3102: BIS_UTILITIES_PVT.Add_Error_Message

3098: when FND_API.G_EXC_UNEXPECTED_ERROR then
3099: BIS_UTILITIES_PUB.put_line(p_text =>'form conc req 2');
3100: when others then
3101: BIS_UTILITIES_PUB.put_line(p_text =>'form conc req 3: '||SQLERRM);
3102: BIS_UTILITIES_PVT.Add_Error_Message
3103: ( p_error_msg_id => SQLCODE
3104: , p_error_description => SQLERRM
3105: , p_error_proc_name => G_PKG_NAME||'.Form_Concurrent_Request'
3106: );

Line 3295: BIS_UTILITIES_PVT.Add_Error_Message

3291: BIS_UTILITIES_PUB.put_line(p_text =>'form_parameter_set exception2: '||sqlerrm);
3292: when others then
3293: BIS_UTILITIES_PUB.put_line(p_text =>'form_parameter_set exception3: '||sqlerrm);
3294: l_error_tbl_p := l_error_tbl;
3295: BIS_UTILITIES_PVT.Add_Error_Message
3296: ( p_error_msg_id => SQLCODE
3297: , p_error_description => SQLERRM
3298: , p_error_proc_name => 'form_parameter_set'
3299: , p_error_table => l_error_tbl_p

Line 3523: BIS_UTILITIES_PVT.Add_Error_Message

3519: BIS_UTILITIES_PUB.put_line(p_text =>'Verify_Target_Level exception2: '||sqlerrm);
3520: when others then
3521: BIS_UTILITIES_PUB.put_line(p_text =>'Verify_Target_Level exception3: '||sqlerrm);
3522: l_error_Tbl_p := l_error_Tbl;
3523: BIS_UTILITIES_PVT.Add_Error_Message
3524: ( p_error_msg_id => SQLCODE
3525: , p_error_description => SQLERRM
3526: , p_error_proc_name => 'Verify_Target_Level'
3527: , p_error_table => l_error_tbl_p

Line 3766: IF l_dimension_Level_Rec.dimension_short_name = BIS_UTILITIES_PVT.Get_Total_Dimlevel_Name

3762: , x_return_status => l_return_status
3763: , x_error_Tbl => l_error_Tbl
3764: );
3765:
3766: IF l_dimension_Level_Rec.dimension_short_name = BIS_UTILITIES_PVT.Get_Total_Dimlevel_Name
3767: (p_dim_short_name => BIS_UTILITIES_PVT.Get_Time_Dimension_Name
3768: (p_DimLevelId => l_dimension_level_rec.Dimension_Level_Id)) THEN
3769: RETURN TRUE;
3770: ELSE

Line 3767: (p_dim_short_name => BIS_UTILITIES_PVT.Get_Time_Dimension_Name

3763: , x_error_Tbl => l_error_Tbl
3764: );
3765:
3766: IF l_dimension_Level_Rec.dimension_short_name = BIS_UTILITIES_PVT.Get_Total_Dimlevel_Name
3767: (p_dim_short_name => BIS_UTILITIES_PVT.Get_Time_Dimension_Name
3768: (p_DimLevelId => l_dimension_level_rec.Dimension_Level_Id)) THEN
3769: RETURN TRUE;
3770: ELSE
3771: RETURN FALSE;