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_CORRECTIVE_ACTION_PVT dependencies on BIS_UTILITIES_PVT

Line 702: l_is_rolling_period := bis_utilities_pvt.Is_Rolling_Period_Level

698:
699:
700: if l_time_level_short_name is not NULL then
701:
702: l_is_rolling_period := bis_utilities_pvt.Is_Rolling_Period_Level
703: ( p_level_short_name => l_time_level_short_name );
704:
705: IF ( l_is_rolling_period = 1 ) THEN
706:

Line 715: l_rolling_period_start_date := bis_utilities_pvt.get_Roll_Period_Start_Date

711: , avalue => l_measure_rec.Measure_Name||' '||v_dim_value_level(l_sequence_no)
712: );
713:
714: l_rolling_period_end_date := sysdate;
715: l_rolling_period_start_date := bis_utilities_pvt.get_Roll_Period_Start_Date
716: ( p_level_short_name => l_time_level_short_name
717: , p_end_date => l_rolling_period_end_date
718: );
719:

Line 720: l_start_label := BIS_UTILITIES_PVT.Get_FND_Message('BIS_ROLLING_START');

716: ( p_level_short_name => l_time_level_short_name
717: , p_end_date => l_rolling_period_end_date
718: );
719:
720: l_start_label := BIS_UTILITIES_PVT.Get_FND_Message('BIS_ROLLING_START');
721: l_end_label := BIS_UTILITIES_PVT.Get_FND_Message('BIS_ROLLING_END');
722:
723: ELSE
724:

Line 721: l_end_label := BIS_UTILITIES_PVT.Get_FND_Message('BIS_ROLLING_END');

717: , p_end_date => l_rolling_period_end_date
718: );
719:
720: l_start_label := BIS_UTILITIES_PVT.Get_FND_Message('BIS_ROLLING_START');
721: l_end_label := BIS_UTILITIES_PVT.Get_FND_Message('BIS_ROLLING_END');
722:
723: ELSE
724:
725: WF_ENGINE.SetItemAttrText

Line 747: l_label := BIS_UTILITIES_PVT.getPrompt

743:
744:
745:
746:
747: l_label := BIS_UTILITIES_PVT.getPrompt
748: (p_attribute_code => fnd_message.get_string('BIS', 'BIS_ALERT_SUBJECT')
749: ); -- BIS_UTILITIES_PUB.put_line(p_text =>'Subject'||l_label);
750:
751: WF_ENGINE.SetItemAttrText

Line 761: l_label := BIS_UTILITIES_PVT.getPrompt

757:
758:
759: -- set the workflow attributes
760: --
761: l_label := BIS_UTILITIES_PVT.getPrompt
762: (p_attribute_code => fnd_message.get_string('BIS', 'BIS_ALERT_DETAILS')
763: ); -- BIS_UTILITIES_PUB.put_line(p_text =>'Details'||l_label);
764:
765: WF_ENGINE.SetItemAttrText

Line 772: l_label := BIS_UTILITIES_PVT.getPrompt

768: , aname => 'L_ALERT_DETAILS_LABEL'
769: , avalue => l_label
770: );
771:
772: l_label := BIS_UTILITIES_PVT.getPrompt
773: (p_attribute_code => fnd_message.get_string('BIS', 'BIS_ALERT_MSG')
774: );
775: -- BIS_UTILITIES_PUB.put_line(p_text =>'Alert Msg'||l_label);
776: WF_ENGINE.SetItemAttrText

Line 783: l_label := BIS_UTILITIES_PVT.getPrompt

779: , aname => 'L_ALERT_MSG'
780: , avalue => l_label
781: );
782:
783: l_label := BIS_UTILITIES_PVT.getPrompt
784: (p_attribute_code => fnd_message.get_string('BIS', 'BIS_ALERT_RUN_DATE')
785: );
786: -- BIS_UTILITIES_PUB.put_line(p_text =>'Run Date'||l_label);
787: WF_ENGINE.SetItemAttrText

Line 859: l_label := BIS_UTILITIES_PVT.getPrompt

855: l_alert_details1 := null;
856:
857: BIS_UTILITIES_PUB.put_line(p_text =>'Dimension: '||l_alert_details);
858:
859: l_label := BIS_UTILITIES_PVT.getPrompt
860: (p_attribute_code => fnd_message.get_string('BIS', 'BIS_ALERT_PERF_MEASURE')
861: );
862: BIS_UTILITIES_PUB.put_line(p_text =>'Perf Measure'||l_label);
863: wf_engine.SetItemAttrText

Line 876: l_label := BIS_UTILITIES_PVT.getPrompt

872: , aname => 'L_PERFORMANCE_MEASURE'
873: , avalue => l_measure_rec.Measure_Name
874: );
875:
876: l_label := BIS_UTILITIES_PVT.getPrompt
877: (p_attribute_code => fnd_message.get_string('BIS', 'BIS_ALERT_UNIT_MEASURE')
878: );
879: BIS_UTILITIES_PUB.put_line(p_text =>'Unit Of Measure'||l_label);
880: wf_engine.SetItemAttrText

Line 895: l_label := BIS_UTILITIES_PVT.getPrompt

891: );
892:
893: --BIS_UTILITIES_PUB.put_line(p_text =>l_label||': '||p_measure_instance.Measure_Name);
894:
895: l_label := BIS_UTILITIES_PVT.getPrompt
896: (p_attribute_code => fnd_message.get_string('BIS', 'BIS_ALERT_TARGET')
897: );
898: BIS_UTILITIES_PUB.put_line(p_text =>'Target'||l_label);
899: wf_engine.SetItemAttrText

Line 916: l_label := BIS_UTILITIES_PVT.getPrompt

912: --BIS_UTILITIES_PUB.put_line(p_text =>l_label||': ' ||l_target_rec.Target);
913:
914: if (l_number_out_of_range >= 100) then
915:
916: l_label := BIS_UTILITIES_PVT.getPrompt
917: (p_attribute_code => fnd_message.get_string('BIS', 'BIS_ALERT_TOLERANCE_RANGE1')
918: );
919: BIS_UTILITIES_PUB.put_line(p_text =>'Tolerance Range 1'||l_label);
920:

Line 940: l_label := BIS_UTILITIES_PVT.getPrompt

936: end if;
937:
938: if ( mod(l_number_out_of_range, 100) >= 10 ) then
939:
940: l_label := BIS_UTILITIES_PVT.getPrompt
941: (p_attribute_code => fnd_message.get_string('BIS', 'BIS_ALERT_TOLERANCE_RANGE2')
942: );
943: BIS_UTILITIES_PUB.put_line(p_text =>'Tolerance Range 2'||l_label);
944:

Line 964: l_label := BIS_UTILITIES_PVT.getPrompt

960: end if;
961:
962: if ( mod(l_number_out_of_range, 100) = 1 ) or ( mod(l_number_out_of_range, 10) = 1 ) then
963:
964: l_label := BIS_UTILITIES_PVT.getPrompt
965: (p_attribute_code => fnd_message.get_string('BIS', 'BIS_ALERT_TOLERANCE_RANGE3')
966: );
967:
968: BIS_UTILITIES_PUB.put_line(p_text =>'Tolerance Range 3'||l_label);

Line 988: l_label := BIS_UTILITIES_PVT.getPrompt

984:
985: end if;
986:
987:
988: l_label := BIS_UTILITIES_PVT.getPrompt
989: (p_attribute_code => fnd_message.get_string('BIS', 'BIS_ALERT_ACTUAL')
990: );
991: BIS_UTILITIES_PUB.put_line(p_text =>'Actual'||l_label);
992: wf_engine.SetItemAttrText

Line 1007: l_label := BIS_UTILITIES_PVT.getPrompt

1003: );
1004:
1005: --BIS_UTILITIES_PUB.put_line(p_text =>l_label||': '||l_actual_rec.Actual);
1006:
1007: l_label := BIS_UTILITIES_PVT.getPrompt
1008: (p_attribute_code => fnd_message.get_string('BIS', 'BIS_ALERT_INFO')
1009: );
1010: BIS_UTILITIES_PUB.put_line(p_text =>'info'||l_label);
1011: wf_engine.SetItemAttrText

Line 1019: l_label := BIS_UTILITIES_PVT.getPrompt

1015: , avalue => l_label
1016: );
1017:
1018: If ( l_link is null ) THEN -- UPPER(l_link) = G_RPT_ERROR then
1019: l_label := BIS_UTILITIES_PVT.getPrompt
1020: (p_attribute_code => fnd_message.get_string('BIS', 'BIS_ALERT_NORPT1')
1021: );
1022:
1023: wf_engine.SetItemAttrText

Line 1029: l_label := BIS_UTILITIES_PVT.getPrompt

1025: , itemkey => l_wf_item_key
1026: , aname => 'L_RELATE_INFO_LABEL'
1027: , avalue => l_label
1028: );
1029: l_label := BIS_UTILITIES_PVT.getPrompt
1030: (p_attribute_code => fnd_message.get_string('BIS', 'BIS_ALERT_NORPT2')
1031: );
1032:
1033: wf_engine.SetItemAttrText

Line 1050: l_label := BIS_UTILITIES_PVT.getPrompt

1046:
1047: Else
1048:
1049:
1050: l_label := BIS_UTILITIES_PVT.getPrompt
1051: (p_attribute_code => fnd_message.get_string('BIS', 'BIS_ALERT_INFO_MSG')
1052: );
1053:
1054: wf_engine.SetItemAttrText

Line 1077: l_label := BIS_UTILITIES_PVT.getPrompt

1073: );
1074:
1075: End If;
1076:
1077: l_label := BIS_UTILITIES_PVT.getPrompt
1078: (p_attribute_code => fnd_message.get_string('BIS', 'BIS_ALERT_RECIPIENTS')
1079: );
1080: BIS_UTILITIES_PUB.put_line(p_text =>'Recipients'||l_label);
1081: wf_engine.SetItemAttrText

Line 1089: l_label := BIS_UTILITIES_PVT.getPrompt

1085: , avalue => l_label
1086: );
1087:
1088: --BIS_UTILITIES_PUB.put_line(p_text =>l_label);
1089: l_label := BIS_UTILITIES_PVT.getPrompt
1090: (p_attribute_code => fnd_message.get_string('BIS', 'BIS_ALERT_REC_MSG')
1091: );
1092: BIS_UTILITIES_PUB.put_line(p_text =>'Rec Msg'||l_label);
1093: wf_engine.SetItemAttrText

Line 1145: l_label := BIS_UTILITIES_PVT.getPrompt

1141: , itemkey => l_wf_item_key
1142: , aname => 'L_RECEPIENT_TXT'
1143: , avalue => l_msg1
1144: );
1145: l_label := BIS_UTILITIES_PVT.getPrompt
1146: (p_attribute_code => fnd_message.get_string('BIS', 'BIS_ALERT_SCHEDULE')
1147: );
1148:
1149: wf_engine.SetItemAttrText

Line 1169: l_label := BIS_UTILITIES_PVT.getPrompt

1165: , itemkey => l_wf_item_key
1166: , aname => 'NEXT_RUN_DATE'
1167: , avalue => l_next_run_date
1168: );
1169: l_label := BIS_UTILITIES_PVT.getPrompt
1170: (p_attribute_code => BIS_UTILITIES_PVT.Get_FND_Message(
1171: p_message_name => 'BIS_ALERT_SCHEDULE_MSG1'
1172: , p_msg_param1 => 'NEXT_RUN_DATE'
1173: , p_msg_param1_val => l_next_run_date

Line 1170: (p_attribute_code => BIS_UTILITIES_PVT.Get_FND_Message(

1166: , aname => 'NEXT_RUN_DATE'
1167: , avalue => l_next_run_date
1168: );
1169: l_label := BIS_UTILITIES_PVT.getPrompt
1170: (p_attribute_code => BIS_UTILITIES_PVT.Get_FND_Message(
1171: p_message_name => 'BIS_ALERT_SCHEDULE_MSG1'
1172: , p_msg_param1 => 'NEXT_RUN_DATE'
1173: , p_msg_param1_val => l_next_run_date
1174: )

Line 1187: l_label := l_label || ' ' || BIS_UTILITIES_PVT.getPrompt

1183: -- 1880142, avalue => l_schedule_freq ||' '||l_schedule_freq_unit
1184: , avalue => l_schedule_unit -- 1880142
1185: );
1186:
1187: l_label := l_label || ' ' || BIS_UTILITIES_PVT.getPrompt
1188: (p_attribute_code => BIS_UTILITIES_PVT.Get_FND_Message(
1189: p_message_name => 'BIS_ALERT_SCHEDULE_MSG2'
1190: , p_msg_param1 => 'SCHEDULE_INFO'
1191: , p_msg_param1_val => l_schedule_unit

Line 1188: (p_attribute_code => BIS_UTILITIES_PVT.Get_FND_Message(

1184: , avalue => l_schedule_unit -- 1880142
1185: );
1186:
1187: l_label := l_label || ' ' || BIS_UTILITIES_PVT.getPrompt
1188: (p_attribute_code => BIS_UTILITIES_PVT.Get_FND_Message(
1189: p_message_name => 'BIS_ALERT_SCHEDULE_MSG2'
1190: , p_msg_param1 => 'SCHEDULE_INFO'
1191: , p_msg_param1_val => l_schedule_unit
1192: )

Line 1199: l_label := BIS_UTILITIES_PVT.getPrompt(p_attribute_code=> fnd_message.get_string('BIS', 'BIS_ALERT_NOT_REPEAT'));

1195: end if;
1196:
1197: else
1198:
1199: l_label := BIS_UTILITIES_PVT.getPrompt(p_attribute_code=> fnd_message.get_string('BIS', 'BIS_ALERT_NOT_REPEAT'));
1200:
1201: end if;
1202:
1203: --l_msg := l_msg||'You will only receive an alert if the actual performane measure is outside of the tolerance range.';

Line 1204: l_label := l_label || ' ' || BIS_UTILITIES_PVT.getPrompt

1200:
1201: end if;
1202:
1203: --l_msg := l_msg||'You will only receive an alert if the actual performane measure is outside of the tolerance range.';
1204: l_label := l_label || ' ' || BIS_UTILITIES_PVT.getPrompt
1205: (p_attribute_code => fnd_message.get_string('BIS', 'BIS_ALERT_SCHEDULE_MSG3')
1206: );
1207:
1208:

Line 1754: BIS_UTILITIES_PVT.Add_Error_Message

1750: RETURN;
1751: when FND_API.G_EXC_UNEXPECTED_ERROR then
1752: RETURN;
1753: when others then
1754: BIS_UTILITIES_PVT.Add_Error_Message
1755: ( p_error_msg_id => SQLCODE
1756: , p_error_description => SQLERRM
1757: , p_error_proc_name => G_PKG_NAME||'.Get_Report_Attachement'
1758: );

Line 1802: BIS_UTILITIES_PVT.Get_FND_Message

1798: l_document varchar2(32000);
1799: l_amp varchar2(10) := '&';
1800: l_target_id varchar2(32000);
1801: l_wait_msg varchar2(32000) :=
1802: BIS_UTILITIES_PVT.Get_FND_Message
1803: ( p_message_name => 'BIS_ALERT_RETRIEVING_MSG' );
1804:
1805: BEGIN
1806:

Line 2125: l_bis_url := bis_utilities_pvt.get_bis_jsp_path;

2121: IF icx_sec.validateSession THEN
2122:
2123: l_jsp_name := 'bisunsub.jsp';
2124:
2125: l_bis_url := bis_utilities_pvt.get_bis_jsp_path;
2126:
2127: l_parameter := 'measureId='||pMeasureId -- 487
2128: || '&' || 'targetLevelId=' || pTargetLevelId -- 1964
2129: || '&' || 'targetId=' || pTargetId -- 602

Line 2252: BIS_UTILITIES_PVT.Add_Error_Message

2248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2249: x_msg_count := 1;
2250: x_msg_data := 'Error in BISVCACB.pls in unSubscribeFromAlerts' || sqlerrm;
2251: l_error_tbl_p := l_error_tbl;
2252: BIS_UTILITIES_PVT.Add_Error_Message
2253: ( p_error_msg_id => SQLCODE
2254: , p_error_description => SQLERRM
2255: , p_error_proc_name => G_PKG_NAME||'.unSubscribeFromAlerts'
2256: , p_error_table => l_error_tbl_p

Line 2376: l_alert_message := l_alert_message || BIS_UTILITIES_PVT.Get_FND_Message(

2372: ) ;
2373:
2374: l_next_run_date := to_char(l_client_date, l_date_format);
2375:
2376: l_alert_message := l_alert_message || BIS_UTILITIES_PVT.Get_FND_Message(
2377: p_message_name => 'BIS_ALERT_SCHEDULE_MSG1'
2378: ,p_msg_param1 => 'NEXT_RUN_DATE'
2379: ,p_msg_param1_val => l_next_run_date
2380: );

Line 2384: l_alert_message := l_alert_message || BIS_UTILITIES_PVT.Get_FND_Message(

2380: );
2381: END IF;
2382:
2383: IF (l_freq IS NOT NULL) THEN
2384: l_alert_message := l_alert_message || BIS_UTILITIES_PVT.Get_FND_Message(
2385: p_message_name => 'BIS_ALERT_SCHEDULE_MSG2'
2386: ,p_msg_param1 => 'SCHEDULE_INFO'
2387: ,p_msg_param1_val => l_freq
2388: );

Line 2391: l_alert_message := l_alert_message || BIS_UTILITIES_PVT.Get_FND_Message(

2387: ,p_msg_param1_val => l_freq
2388: );
2389: END IF;
2390: ELSE
2391: l_alert_message := l_alert_message || BIS_UTILITIES_PVT.Get_FND_Message(
2392: p_message_name => 'BIS_ALERT_NOT_REPEAT'
2393: );
2394: END IF;
2395:

Line 2396: l_alert_message := l_alert_message || BIS_UTILITIES_PVT.Get_FND_Message(

2392: p_message_name => 'BIS_ALERT_NOT_REPEAT'
2393: );
2394: END IF;
2395:
2396: l_alert_message := l_alert_message || BIS_UTILITIES_PVT.Get_FND_Message(
2397: p_message_name => 'BIS_ALERT_SCHEDULE_MSG3'
2398: );
2399:
2400: l_hdr_support := wf_core.translate('WF_HEADER_ATTR');