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_GENERIC_PLANNER_PVT dependencies on BIS_UTILITIES_PUB

Line 57: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

53:
54: l_return_status VARCHAR2(32000);
55: l_msg_count NUMBER;
56: l_msg_data VARCHAR2(32000);
57: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
58: l_measure_instance_p BIS_MEASURE_PUB.Measure_Instance_type;
59:
60: BEGIN
61:

Line 65: BIS_UTILITIES_PUB.put_line(p_text =>'Servicing planner request.');

61:
62: l_measure_instance := p_measure_instance;
63: l_dim_level_value_tbl := p_dim_level_value_tbl;
64:
65: BIS_UTILITIES_PUB.put_line(p_text =>'Servicing planner request.');
66: BIS_UTILITIES_PUB.put_line(p_text =>'Target level id: '||l_measure_instance.Target_level_id);
67:
68: /*
69: BIS_UTILITIES_PUB.put_line(p_text =>'VGPLB: org, id: '

Line 66: BIS_UTILITIES_PUB.put_line(p_text =>'Target level id: '||l_measure_instance.Target_level_id);

62: l_measure_instance := p_measure_instance;
63: l_dim_level_value_tbl := p_dim_level_value_tbl;
64:
65: BIS_UTILITIES_PUB.put_line(p_text =>'Servicing planner request.');
66: BIS_UTILITIES_PUB.put_line(p_text =>'Target level id: '||l_measure_instance.Target_level_id);
67:
68: /*
69: BIS_UTILITIES_PUB.put_line(p_text =>'VGPLB: org, id: '
70: ||l_dim_level_value_tbl(1).dimension_level_short_name||' - '

Line 69: BIS_UTILITIES_PUB.put_line(p_text =>'VGPLB: org, id: '

65: BIS_UTILITIES_PUB.put_line(p_text =>'Servicing planner request.');
66: BIS_UTILITIES_PUB.put_line(p_text =>'Target level id: '||l_measure_instance.Target_level_id);
67:
68: /*
69: BIS_UTILITIES_PUB.put_line(p_text =>'VGPLB: org, id: '
70: ||l_dim_level_value_tbl(1).dimension_level_short_name||' - '
71: ||l_dim_level_value_tbl(1).dimension_level_value_id);
72:
73: BIS_UTILITIES_PUB.put_line(p_text =>'VGPLB: time, id: '

Line 73: BIS_UTILITIES_PUB.put_line(p_text =>'VGPLB: time, id: '

69: BIS_UTILITIES_PUB.put_line(p_text =>'VGPLB: org, id: '
70: ||l_dim_level_value_tbl(1).dimension_level_short_name||' - '
71: ||l_dim_level_value_tbl(1).dimension_level_value_id);
72:
73: BIS_UTILITIES_PUB.put_line(p_text =>'VGPLB: time, id: '
74: ||l_dim_level_value_tbl(2).dimension_level_short_name||' - '
75: ||l_dim_level_value_tbl(2).dimension_level_value_id);
76:
77: BIS_UTILITIES_PUB.put_line(p_text =>'VGPLB: dim1 id: '

Line 77: BIS_UTILITIES_PUB.put_line(p_text =>'VGPLB: dim1 id: '

73: BIS_UTILITIES_PUB.put_line(p_text =>'VGPLB: time, id: '
74: ||l_dim_level_value_tbl(2).dimension_level_short_name||' - '
75: ||l_dim_level_value_tbl(2).dimension_level_value_id);
76:
77: BIS_UTILITIES_PUB.put_line(p_text =>'VGPLB: dim1 id: '
78: ||l_dim_level_value_tbl(3).dimension_level_short_name||' - '
79: ||l_dim_level_value_tbl(3).dimension_level_value_id);
80:
81: BIS_UTILITIES_PUB.put_line(p_text =>'VGPLB: dim2 id: '

Line 81: BIS_UTILITIES_PUB.put_line(p_text =>'VGPLB: dim2 id: '

77: BIS_UTILITIES_PUB.put_line(p_text =>'VGPLB: dim1 id: '
78: ||l_dim_level_value_tbl(3).dimension_level_short_name||' - '
79: ||l_dim_level_value_tbl(3).dimension_level_value_id);
80:
81: BIS_UTILITIES_PUB.put_line(p_text =>'VGPLB: dim2 id: '
82: ||l_dim_level_value_tbl(4).dimension_level_short_name||' - '
83: ||l_dim_level_value_tbl(4).dimension_level_value_id);
84: */
85:

Line 88: IF ((BIS_UTILITIES_PUB.Value_Missing(l_measure_instance.Target_level_id)

84: */
85:
86: -- Retrieve Performance Target information
87: --
88: IF ((BIS_UTILITIES_PUB.Value_Missing(l_measure_instance.Target_level_id)
89: = FND_API.G_TRUE)
90: OR (BIS_UTILITIES_PUB.Value_Null(l_measure_instance.Target_level_id)
91: = FND_API.G_TRUE))
92: THEN

Line 90: OR (BIS_UTILITIES_PUB.Value_Null(l_measure_instance.Target_level_id)

86: -- Retrieve Performance Target information
87: --
88: IF ((BIS_UTILITIES_PUB.Value_Missing(l_measure_instance.Target_level_id)
89: = FND_API.G_TRUE)
90: OR (BIS_UTILITIES_PUB.Value_Null(l_measure_instance.Target_level_id)
91: = FND_API.G_TRUE))
92: THEN
93: BIS_PMF_DATA_SOURCE_PUB.Retrieve_Target_Level
94: ( p_measure_instance => l_measure_instance

Line 108: BIS_UTILITIES_PUB.put_line(p_text =>'Target level short name: '

104: , p_target_owners_rec => l_Target_Owners_Rec
105: , p_actual_rec => l_Actual_Rec
106: , x_measure_instance => l_measure_instance
107: );
108: BIS_UTILITIES_PUB.put_line(p_text =>'Target level short name: '
109: ||l_measure_instance.Target_Level_Short_Name);
110: ELSE
111: BIS_PMF_DATA_SOURCE_PVT.Form_Target_Level_rec
112: ( p_measure_instance => l_measure_instance

Line 126: BIS_UTILITIES_PUB.put_line(p_text =>'Planner retrieved target: '||l_target_rec.target);

122: , p_dim_level_value_tbl => l_dim_level_value_tbl
123: , p_all_info => FND_API.G_FALSE
124: , x_target_rec => l_target_rec
125: );
126: BIS_UTILITIES_PUB.put_line(p_text =>'Planner retrieved target: '||l_target_rec.target);
127:
128: -- Retrieve Performance Actual information
129: --
130: BIS_PMF_DATA_SOURCE_PUB.Retrieve_Actual

Line 136: BIS_UTILITIES_PUB.put_line(p_text =>'Planner retrieved actual: '||l_actual_rec.actual);

132: , p_dim_level_value_tbl => l_dim_level_value_tbl
133: , p_all_info => FND_API.G_FALSE
134: , x_actual_rec => l_actual_rec
135: );
136: BIS_UTILITIES_PUB.put_line(p_text =>'Planner retrieved actual: '||l_actual_rec.actual);
137:
138: -- post actual
139: --
140: IF (BIS_UTILITIES_PUB.Value_Not_Missing(l_actual_rec.Actual) = FND_API.G_TRUE)

Line 140: IF (BIS_UTILITIES_PUB.Value_Not_Missing(l_actual_rec.Actual) = FND_API.G_TRUE)

136: BIS_UTILITIES_PUB.put_line(p_text =>'Planner retrieved actual: '||l_actual_rec.actual);
137:
138: -- post actual
139: --
140: IF (BIS_UTILITIES_PUB.Value_Not_Missing(l_actual_rec.Actual) = FND_API.G_TRUE)
141: -- OR (BIS_UTILITIES_PUB.Value_Not_Null(l_actual_rec.Actual) = FND_API.G_TRUE))
142: THEN
143: BIS_ACTUAL_PUB.Post_Actual
144: ( p_api_version => 1.0

Line 141: -- OR (BIS_UTILITIES_PUB.Value_Not_Null(l_actual_rec.Actual) = FND_API.G_TRUE))

137:
138: -- post actual
139: --
140: IF (BIS_UTILITIES_PUB.Value_Not_Missing(l_actual_rec.Actual) = FND_API.G_TRUE)
141: -- OR (BIS_UTILITIES_PUB.Value_Not_Null(l_actual_rec.Actual) = FND_API.G_TRUE))
142: THEN
143: BIS_ACTUAL_PUB.Post_Actual
144: ( p_api_version => 1.0
145: , p_commit => FND_API.G_TRUE

Line 152: BIS_UTILITIES_PUB.put_line(p_text =>'Actual posted: '||l_return_status);

148: , x_msg_count => l_msg_count
149: , x_msg_data => l_msg_data
150: , x_error_Tbl => l_error_Tbl
151: );
152: BIS_UTILITIES_PUB.put_line(p_text =>'Actual posted: '||l_return_status);
153: END IF;
154:
155: -- Comparison and notification
156: --

Line 162: BIS_UTILITIES_PUB.put_line(p_text =>'Target to actual comparison: out of range '||l_comparison_result);

158: ( p_target_rec => l_Target_Rec
159: , p_actual_rec => l_Actual_Rec
160: , x_comparison_result => l_comparison_result
161: );
162: BIS_UTILITIES_PUB.put_line(p_text =>'Target to actual comparison: out of range '||l_comparison_result);
163:
164: -- Assume Exception mode alert compare and notify Target owner
165: -- when exceptions occur. No notification if result is normal.
166: -- Start corrective action only if exception occured

Line 187: BIS_UTILITIES_PUB.put_line(p_text =>'Range 1 Owner: '||l_Target_Owners_Rec.Range1_Owner_Short_Name);

183: , p_target_owners_rec => l_Target_Owners_Rec
184: , p_actual_rec => l_Actual_Rec
185: , x_measure_instance => l_measure_instance
186: );
187: BIS_UTILITIES_PUB.put_line(p_text =>'Range 1 Owner: '||l_Target_Owners_Rec.Range1_Owner_Short_Name);
188: BIS_UTILITIES_PUB.put_line(p_text =>'Range 2 Owner: '||l_Target_Owners_Rec.Range2_Owner_Short_Name);
189: BIS_UTILITIES_PUB.put_line(p_text =>'Range 3 Owner: '||l_Target_Owners_Rec.Range3_Owner_Short_Name);
190:
191: BIS_CORRECTIVE_ACTION_PUB.Send_Alert

Line 188: BIS_UTILITIES_PUB.put_line(p_text =>'Range 2 Owner: '||l_Target_Owners_Rec.Range2_Owner_Short_Name);

184: , p_actual_rec => l_Actual_Rec
185: , x_measure_instance => l_measure_instance
186: );
187: BIS_UTILITIES_PUB.put_line(p_text =>'Range 1 Owner: '||l_Target_Owners_Rec.Range1_Owner_Short_Name);
188: BIS_UTILITIES_PUB.put_line(p_text =>'Range 2 Owner: '||l_Target_Owners_Rec.Range2_Owner_Short_Name);
189: BIS_UTILITIES_PUB.put_line(p_text =>'Range 3 Owner: '||l_Target_Owners_Rec.Range3_Owner_Short_Name);
190:
191: BIS_CORRECTIVE_ACTION_PUB.Send_Alert
192: ( p_measure_instance => l_measure_instance

Line 189: BIS_UTILITIES_PUB.put_line(p_text =>'Range 3 Owner: '||l_Target_Owners_Rec.Range3_Owner_Short_Name);

185: , x_measure_instance => l_measure_instance
186: );
187: BIS_UTILITIES_PUB.put_line(p_text =>'Range 1 Owner: '||l_Target_Owners_Rec.Range1_Owner_Short_Name);
188: BIS_UTILITIES_PUB.put_line(p_text =>'Range 2 Owner: '||l_Target_Owners_Rec.Range2_Owner_Short_Name);
189: BIS_UTILITIES_PUB.put_line(p_text =>'Range 3 Owner: '||l_Target_Owners_Rec.Range3_Owner_Short_Name);
190:
191: BIS_CORRECTIVE_ACTION_PUB.Send_Alert
192: ( p_measure_instance => l_measure_instance
193: , p_dim_level_value_tbl => l_dim_level_value_tbl

Line 198: -- BIS_UTILITIES_PUB.put_line(p_text =>'Send alert notification started');

194: , p_comparison_result => l_comparison_result
195: );
196: -- Following is an Incorrect Log. Please don't uncomment the following line
197:
198: -- BIS_UTILITIES_PUB.put_line(p_text =>'Send alert notification started');
199:
200:
201: IF p_alert_type = BIS_PMF_REG_SERVICE_PVT.G_TARGET_LEVEL THEN
202: BIS_CORRECTIVE_ACTION_PUB.Start_Corrective_Action

Line 207: BIS_UTILITIES_PUB.put_line(p_text =>'Corrective action started');

203: ( p_measure_instance => l_measure_instance
204: , p_dim_level_value_tbl => l_dim_level_value_tbl
205: , p_comparison_result => l_comparison_result
206: );
207: BIS_UTILITIES_PUB.put_line(p_text =>'Corrective action started');
208: END IF;
209:
210: END IF;
211:

Line 295: BIS_UTILITIES_PUB.put_line(p_text =>'Comparing values.');

291: l_range2_high := l_target+((l_range2_high/100)*l_target);
292: l_range3_low := l_target-((l_range3_low/100)*l_target);
293: l_range3_high := l_target+((l_range3_high/100)*l_target);
294:
295: BIS_UTILITIES_PUB.put_line(p_text =>'Comparing values.');
296: BIS_UTILITIES_PUB.put_line(p_text =>'Actual: '||l_actual||', Target: '||l_target);
297: BIS_UTILITIES_PUB.put_line(p_text =>'Range 1 low: '||l_range1_low||', high: '||l_range1_high);
298: BIS_UTILITIES_PUB.put_line(p_text =>'Range 2 low: '||l_range2_low||', high: '||l_range2_high);
299: BIS_UTILITIES_PUB.put_line(p_text =>'Range 3 low: '||l_range3_low||', high: '||l_range3_high);

Line 296: BIS_UTILITIES_PUB.put_line(p_text =>'Actual: '||l_actual||', Target: '||l_target);

292: l_range3_low := l_target-((l_range3_low/100)*l_target);
293: l_range3_high := l_target+((l_range3_high/100)*l_target);
294:
295: BIS_UTILITIES_PUB.put_line(p_text =>'Comparing values.');
296: BIS_UTILITIES_PUB.put_line(p_text =>'Actual: '||l_actual||', Target: '||l_target);
297: BIS_UTILITIES_PUB.put_line(p_text =>'Range 1 low: '||l_range1_low||', high: '||l_range1_high);
298: BIS_UTILITIES_PUB.put_line(p_text =>'Range 2 low: '||l_range2_low||', high: '||l_range2_high);
299: BIS_UTILITIES_PUB.put_line(p_text =>'Range 3 low: '||l_range3_low||', high: '||l_range3_high);
300:

Line 297: BIS_UTILITIES_PUB.put_line(p_text =>'Range 1 low: '||l_range1_low||', high: '||l_range1_high);

293: l_range3_high := l_target+((l_range3_high/100)*l_target);
294:
295: BIS_UTILITIES_PUB.put_line(p_text =>'Comparing values.');
296: BIS_UTILITIES_PUB.put_line(p_text =>'Actual: '||l_actual||', Target: '||l_target);
297: BIS_UTILITIES_PUB.put_line(p_text =>'Range 1 low: '||l_range1_low||', high: '||l_range1_high);
298: BIS_UTILITIES_PUB.put_line(p_text =>'Range 2 low: '||l_range2_low||', high: '||l_range2_high);
299: BIS_UTILITIES_PUB.put_line(p_text =>'Range 3 low: '||l_range3_low||', high: '||l_range3_high);
300:
301: -- Check if actual not equal to target

Line 298: BIS_UTILITIES_PUB.put_line(p_text =>'Range 2 low: '||l_range2_low||', high: '||l_range2_high);

294:
295: BIS_UTILITIES_PUB.put_line(p_text =>'Comparing values.');
296: BIS_UTILITIES_PUB.put_line(p_text =>'Actual: '||l_actual||', Target: '||l_target);
297: BIS_UTILITIES_PUB.put_line(p_text =>'Range 1 low: '||l_range1_low||', high: '||l_range1_high);
298: BIS_UTILITIES_PUB.put_line(p_text =>'Range 2 low: '||l_range2_low||', high: '||l_range2_high);
299: BIS_UTILITIES_PUB.put_line(p_text =>'Range 3 low: '||l_range3_low||', high: '||l_range3_high);
300:
301: -- Check if actual not equal to target
302: --

Line 299: BIS_UTILITIES_PUB.put_line(p_text =>'Range 3 low: '||l_range3_low||', high: '||l_range3_high);

295: BIS_UTILITIES_PUB.put_line(p_text =>'Comparing values.');
296: BIS_UTILITIES_PUB.put_line(p_text =>'Actual: '||l_actual||', Target: '||l_target);
297: BIS_UTILITIES_PUB.put_line(p_text =>'Range 1 low: '||l_range1_low||', high: '||l_range1_high);
298: BIS_UTILITIES_PUB.put_line(p_text =>'Range 2 low: '||l_range2_low||', high: '||l_range2_high);
299: BIS_UTILITIES_PUB.put_line(p_text =>'Range 3 low: '||l_range3_low||', high: '||l_range3_high);
300:
301: -- Check if actual not equal to target
302: --
303: IF (l_actual <> l_target)