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

Line 43: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

39: ( p_api_version IN NUMBER
40: , p_commit IN VARCHAR2 := FND_API.G_FALSE
41: , p_Param_Set_Rec IN OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
42: , x_return_status OUT NOCOPY VARCHAR2
43: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
44: )
45: IS
46: l_user_id number;
47: l_login_id number;

Line 52: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

48: l_registration_id number;
49: l_role_name varchar2(30);
50: l_null_role_name varchar2(30) := NULL;
51: l_role_display_name varchar2(32000);
52: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
53: l_role_name_p VARCHAR2(30);
54: l_null_role_name_p VARCHAR2(30) := NULL;
55:
56: BEGIN

Line 81: --BIS_UTILITIES_PUB.put_line(p_text =>'creating paramter set. notifier code: '

77: -- Selecting the Next Registion Id from Sequence Generator
78: --
79: select bis_alert_registration_s.NextVal into l_registration_id from dual;
80: --
81: --BIS_UTILITIES_PUB.put_line(p_text =>'creating paramter set. notifier code: '
82: --||p_Param_Set_Rec.NOTIFIERS_CODE);
83:
84: IF p_Param_Set_Rec.NOTIFIERS_CODE IS NULL THEN
85: l_role_name := G_BIS_ALERT_ROLE || to_char(l_registration_id);

Line 90: --BIS_UTILITIES_PUB.put_line(p_text =>'role name, display name: '||l_role_name

86: l_role_display_name := BIS_UTILITIES_PVT.getPrompt
87: ( G_PERFORMANCE_ALERT_PROMPTS
88: , G_AD_HOC_ROLE_DISPLAY_NAME
89: );
90: --BIS_UTILITIES_PUB.put_line(p_text =>'role name, display name: '||l_role_name
91: --||', '||l_role_display_name);
92:
93: BEGIN
94: l_role_name_p := l_role_name;

Line 102: BIS_UTILITIES_PUB.put_line(p_text =>'1st error while creating role: '||l_role_name

98: , role_display_name => l_role_name
99: , expiration_date => NULL);
100: EXCEPTION
101: WHEN OTHERS THEN
102: BIS_UTILITIES_PUB.put_line(p_text =>'1st error while creating role: '||l_role_name
103: ||'. error: '||sqlerrm);
104:
105: BEGIN
106: null;

Line 119: BIS_UTILITIES_PUB.put_line(p_text =>'2st error while creating role: '||l_null_role_name

115: , expiration_date => NULL);
116:
117: EXCEPTION
118: WHEN OTHERS THEN
119: BIS_UTILITIES_PUB.put_line(p_text =>'2st error while creating role: '||l_null_role_name
120: ||'. error: '||sqlerrm);
121: END;
122:
123: END;

Line 128: BIS_UTILITIES_PUB.put_line(p_text =>'ART: role: '|| p_Param_Set_Rec.NOTIFIERS_CODE);

124:
125: p_Param_Set_Rec.NOTIFIERS_CODE := l_role_name;
126: end if;
127: /*
128: BIS_UTILITIES_PUB.put_line(p_text =>'ART: role: '|| p_Param_Set_Rec.NOTIFIERS_CODE);
129: BIS_UTILITIES_PUB.put_line(p_text =>'target level: '||p_Param_Set_Rec.TARGET_LEVEL_ID);
130: BIS_UTILITIES_PUB.put_line(p_text =>'time dim level: '
131: ||p_Param_Set_Rec.TIME_DIMENSION_LEVEL_ID);
132: BIS_UTILITIES_PUB.put_line(p_text =>'time dim value: '||p_Param_Set_Rec.PARAMETER2_VALUE);

Line 129: BIS_UTILITIES_PUB.put_line(p_text =>'target level: '||p_Param_Set_Rec.TARGET_LEVEL_ID);

125: p_Param_Set_Rec.NOTIFIERS_CODE := l_role_name;
126: end if;
127: /*
128: BIS_UTILITIES_PUB.put_line(p_text =>'ART: role: '|| p_Param_Set_Rec.NOTIFIERS_CODE);
129: BIS_UTILITIES_PUB.put_line(p_text =>'target level: '||p_Param_Set_Rec.TARGET_LEVEL_ID);
130: BIS_UTILITIES_PUB.put_line(p_text =>'time dim level: '
131: ||p_Param_Set_Rec.TIME_DIMENSION_LEVEL_ID);
132: BIS_UTILITIES_PUB.put_line(p_text =>'time dim value: '||p_Param_Set_Rec.PARAMETER2_VALUE);
133: */

Line 130: BIS_UTILITIES_PUB.put_line(p_text =>'time dim level: '

126: end if;
127: /*
128: BIS_UTILITIES_PUB.put_line(p_text =>'ART: role: '|| p_Param_Set_Rec.NOTIFIERS_CODE);
129: BIS_UTILITIES_PUB.put_line(p_text =>'target level: '||p_Param_Set_Rec.TARGET_LEVEL_ID);
130: BIS_UTILITIES_PUB.put_line(p_text =>'time dim level: '
131: ||p_Param_Set_Rec.TIME_DIMENSION_LEVEL_ID);
132: BIS_UTILITIES_PUB.put_line(p_text =>'time dim value: '||p_Param_Set_Rec.PARAMETER2_VALUE);
133: */
134: --

Line 132: BIS_UTILITIES_PUB.put_line(p_text =>'time dim value: '||p_Param_Set_Rec.PARAMETER2_VALUE);

128: BIS_UTILITIES_PUB.put_line(p_text =>'ART: role: '|| p_Param_Set_Rec.NOTIFIERS_CODE);
129: BIS_UTILITIES_PUB.put_line(p_text =>'target level: '||p_Param_Set_Rec.TARGET_LEVEL_ID);
130: BIS_UTILITIES_PUB.put_line(p_text =>'time dim level: '
131: ||p_Param_Set_Rec.TIME_DIMENSION_LEVEL_ID);
132: BIS_UTILITIES_PUB.put_line(p_text =>'time dim value: '||p_Param_Set_Rec.PARAMETER2_VALUE);
133: */
134: --
135: insert into bis_pmf_alert_parameters(
136: REGISTRATION_ID

Line 179: --BIS_UTILITIES_PUB.put_line(p_text =>'committed insert. status: '||x_return_status);

175: , l_login_id
176: );
177:
178: if (p_commit = FND_API.G_TRUE) then
179: --BIS_UTILITIES_PUB.put_line(p_text =>'committed insert. status: '||x_return_status);
180: COMMIT;
181: end if;
182:
183: EXCEPTION

Line 186: BIS_UTILITIES_PUB.put_line(p_text =>'exception 1 in Create_Parameter_set'||sqlerrm);

182:
183: EXCEPTION
184: when FND_API.G_EXC_ERROR then
185: x_return_status := FND_API.G_RET_STS_ERROR ;
186: BIS_UTILITIES_PUB.put_line(p_text =>'exception 1 in Create_Parameter_set'||sqlerrm);
187: when FND_API.G_EXC_UNEXPECTED_ERROR then
188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
189: BIS_UTILITIES_PUB.put_line(p_text =>'exception 2 in Create_Parameter_set'||sqlerrm);
190: when others then

Line 189: BIS_UTILITIES_PUB.put_line(p_text =>'exception 2 in Create_Parameter_set'||sqlerrm);

185: x_return_status := FND_API.G_RET_STS_ERROR ;
186: BIS_UTILITIES_PUB.put_line(p_text =>'exception 1 in Create_Parameter_set'||sqlerrm);
187: when FND_API.G_EXC_UNEXPECTED_ERROR then
188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
189: BIS_UTILITIES_PUB.put_line(p_text =>'exception 2 in Create_Parameter_set'||sqlerrm);
190: when others then
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
192: BIS_UTILITIES_PUB.put_line(p_text =>'exception 3 in Create_Parameter_set'||sqlerrm);
193: l_error_tbl := x_error_Tbl;

Line 192: BIS_UTILITIES_PUB.put_line(p_text =>'exception 3 in Create_Parameter_set'||sqlerrm);

188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
189: BIS_UTILITIES_PUB.put_line(p_text =>'exception 2 in Create_Parameter_set'||sqlerrm);
190: when others then
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
192: BIS_UTILITIES_PUB.put_line(p_text =>'exception 3 in Create_Parameter_set'||sqlerrm);
193: l_error_tbl := x_error_Tbl;
194: BIS_UTILITIES_PVT.Add_Error_Message
195: ( p_error_msg_id => SQLCODE
196: , p_error_description => SQLERRM

Line 213: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

209: ( p_api_version IN NUMBER
210: , p_commit IN VARCHAR2 := FND_API.G_FALSE
211: , p_Param_Set_Rec IN BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
212: , x_return_status OUT NOCOPY VARCHAR2
213: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
214: )
215: IS
216: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
217: BEGIN

Line 216: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

212: , x_return_status OUT NOCOPY VARCHAR2
213: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
214: )
215: IS
216: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
217: BEGIN
218:
219: x_return_status := FND_API.G_RET_STS_SUCCESS;
220:

Line 224: BIS_UTILITIES_PUB.put_line(p_text =>'Cannot delete parameter set without Registeration ID.');

220:
221: IF p_Param_Set_Rec.registration_id IS NOT NULL THEN
222: Delete_Parameter_Set(p_Param_Set_Rec.registration_id,x_return_status);
223: ELSE
224: BIS_UTILITIES_PUB.put_line(p_text =>'Cannot delete parameter set without Registeration ID.');
225: END IF;
226: IF p_commit = FND_API.G_TRUE THEN
227: commit;
228: END IF;

Line 233: BIS_UTILITIES_PUB.put_line(p_text =>'exception 1 in delete parameter set: '||sqlerrm);

229:
230: EXCEPTION
231: when FND_API.G_EXC_ERROR then
232: x_return_status := FND_API.G_RET_STS_ERROR ;
233: BIS_UTILITIES_PUB.put_line(p_text =>'exception 1 in delete parameter set: '||sqlerrm);
234: when FND_API.G_EXC_UNEXPECTED_ERROR then
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
236: BIS_UTILITIES_PUB.put_line(p_text =>'exception 2 in delete parameter set: '||sqlerrm);
237: when others then

Line 236: BIS_UTILITIES_PUB.put_line(p_text =>'exception 2 in delete parameter set: '||sqlerrm);

232: x_return_status := FND_API.G_RET_STS_ERROR ;
233: BIS_UTILITIES_PUB.put_line(p_text =>'exception 1 in delete parameter set: '||sqlerrm);
234: when FND_API.G_EXC_UNEXPECTED_ERROR then
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
236: BIS_UTILITIES_PUB.put_line(p_text =>'exception 2 in delete parameter set: '||sqlerrm);
237: when others then
238: BIS_UTILITIES_PUB.put_line(p_text =>'exception 3 in delete parameter set: '||sqlerrm);
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
240: l_error_tbl := x_error_Tbl;

Line 238: BIS_UTILITIES_PUB.put_line(p_text =>'exception 3 in delete parameter set: '||sqlerrm);

234: when FND_API.G_EXC_UNEXPECTED_ERROR then
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
236: BIS_UTILITIES_PUB.put_line(p_text =>'exception 2 in delete parameter set: '||sqlerrm);
237: when others then
238: BIS_UTILITIES_PUB.put_line(p_text =>'exception 3 in delete parameter set: '||sqlerrm);
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
240: l_error_tbl := x_error_Tbl;
241: BIS_UTILITIES_PVT.Add_Error_Message
242: ( p_error_msg_id => SQLCODE

Line 265: -- BIS_UTILITIES_PUB.put_line(p_text =>'Deleting parameter set: '||p_registration_ID);

261: BEGIN
262:
263: x_return_status := FND_API.G_RET_STS_SUCCESS;
264:
265: -- BIS_UTILITIES_PUB.put_line(p_text =>'Deleting parameter set: '||p_registration_ID);
266:
267: -- select count(1) into l_count_1 from bis_pmf_alert_parameters;
268: -- where registration_id = p_registration_id;
269:

Line 277: BIS_UTILITIES_PUB.put_line(p_text =>'before delete: '||l_count_1||', after delete: '||l_count_2);

273:
274: --select count(1) into l_count_2 from bis_pmf_alert_parameters;
275: -- where registration_id = p_registration_id;
276:
277: BIS_UTILITIES_PUB.put_line(p_text =>'before delete: '||l_count_1||', after delete: '||l_count_2);
278: l_debug := 'before delete: '||l_count_1||', after delete: '||l_count_2;
279:
280: x_return_status := x_return_status ||'--delete debug--'||l_debug;
281:

Line 285: BIS_UTILITIES_PUB.put_line(p_text =>'exception in delete parameter set: '||sqlerrm);

281:
282: EXCEPTION
283: when others then
284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
285: BIS_UTILITIES_PUB.put_line(p_text =>'exception in delete parameter set: '||sqlerrm);
286: END Delete_Parameter_Set;
287:
288: --
289: -- Retrieve a Table of parmeter set for the given PM and time

Line 299: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

295: , p_time_dimension_level_id IN NUMBER
296: , p_current_row IN VARCHAR2 := NULL
297: , x_Param_Set_Tbl OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
298: , x_return_status OUT NOCOPY VARCHAR2
299: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
300: )
301: IS
302:
303: l_Param_Set_rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;

Line 305: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

301: IS
302:
303: l_Param_Set_rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;
304: l_Dim_Level_Value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
305: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
306:
307: Cursor parameter_set_list is select
308: REGISTRATION_ID
309: , PERFORMANCE_MEASURE_ID

Line 331: BIS_UTILITIES_PUB.put_line(p_text =>'Retrieving parameter set by Measure');

327: i number := 0;
328:
329: BEGIN
330:
331: BIS_UTILITIES_PUB.put_line(p_text =>'Retrieving parameter set by Measure');
332: for p_set in parameter_set_list
333: loop
334:
335: l_Param_Set_rec.REGISTRATION_ID := p_set.REGISTRATION_ID;

Line 351: BIS_UTILITIES_PUB.put_line(p_text =>'Registeration id: '||l_Param_Set_rec.REGISTRATION_ID

347: l_Param_Set_rec.PARAMETER6_VALUE := p_set.PARAMETER6_VALUE;
348: l_Param_Set_rec.PARAMETER7_VALUE := p_set.PARAMETER7_VALUE;
349: l_Param_Set_rec.NOTIFY_OWNER_FLAG := p_set.NOTIFY_OWNER_FLAG;
350: /*
351: BIS_UTILITIES_PUB.put_line(p_text =>'Registeration id: '||l_Param_Set_rec.REGISTRATION_ID
352: ||', Measure id: '||l_Param_Set_rec.PERFORMANCE_MEASURE_ID
353: ||', Target Level id: '||l_Param_Set_rec.target_LEVEL_ID
354: ||', Time level id: '||l_Param_Set_rec.TIME_DIMENSION_LEVEL_ID
355: ||', Notifier: '||l_Param_Set_rec.NOTIFIERS_CODE

Line 362: BIS_UTILITIES_PUB.put_line(p_text =>'Number of Parameter_sets retrieved: '||x_Param_Set_Tbl.COUNT);

358: x_Param_Set_Tbl(x_Param_Set_Tbl.COUNT+1) := l_Param_Set_rec;
359: end loop;
360:
361: IF parameter_set_list%ISOPEN THEN close parameter_set_list; END IF;
362: BIS_UTILITIES_PUB.put_line(p_text =>'Number of Parameter_sets retrieved: '||x_Param_Set_Tbl.COUNT);
363:
364: EXCEPTION
365: when FND_API.G_EXC_ERROR then
366: IF parameter_set_list%ISOPEN THEN close parameter_set_list; END IF;

Line 395: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

391: , p_Param_Set_Rec IN BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
392: , p_current_row IN VARCHAR2 := NULL
393: , x_Param_Set_Tbl OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
394: , x_return_status OUT NOCOPY VARCHAR2
395: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
396: )
397: IS
398:
399: l_Param_Set_rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;

Line 402: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

398:
399: l_Param_Set_rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;
400: l_Param_Set_tbl BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
401: l_Dim_Level_Value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
402: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
403:
404: Cursor parameter_set_reg is
405: select
406: REGISTRATION_ID

Line 471: BIS_UTILITIES_PUB.put_line(p_text =>'Retrieving parameter set by parameter set record');

467: or (PARAMETER7_VALUE = P_Param_Set_Rec.PARAMETER7_VALUE));
468:
469: BEGIN
470:
471: BIS_UTILITIES_PUB.put_line(p_text =>'Retrieving parameter set by parameter set record');
472: IF p_Param_Set_Rec.REGISTRATION_ID IS NOT NULL THEN
473: BIS_UTILITIES_PUB.put_line(p_text =>'Retrieving alert parameter set based on registration id');
474: FOR p_set IN parameter_set_reg
475: LOOP

Line 473: BIS_UTILITIES_PUB.put_line(p_text =>'Retrieving alert parameter set based on registration id');

469: BEGIN
470:
471: BIS_UTILITIES_PUB.put_line(p_text =>'Retrieving parameter set by parameter set record');
472: IF p_Param_Set_Rec.REGISTRATION_ID IS NOT NULL THEN
473: BIS_UTILITIES_PUB.put_line(p_text =>'Retrieving alert parameter set based on registration id');
474: FOR p_set IN parameter_set_reg
475: LOOP
476: l_Param_Set_rec.REGISTRATION_ID := p_set.REGISTRATION_ID;
477: l_Param_Set_rec.PERFORMANCE_MEASURE_ID := p_set.PERFORMANCE_MEASURE_ID;

Line 493: BIS_UTILITIES_PUB.put_line(p_text =>'Retrieved '||l_Param_Set_Tbl.COUNT||' parameter sets');

489: l_Param_Set_rec.PARAMETER7_VALUE := p_set.PARAMETER7_VALUE;
490: l_Param_Set_rec.NOTIFY_OWNER_FLAG := p_set.NOTIFY_OWNER_FLAG;
491: l_Param_Set_Tbl(l_Param_Set_Tbl.COUNT+1) := l_Param_Set_rec;
492: END LOOP;
493: BIS_UTILITIES_PUB.put_line(p_text =>'Retrieved '||l_Param_Set_Tbl.COUNT||' parameter sets');
494:
495: ELSIF p_Param_Set_Rec.TARGET_LEVEL_ID IS NOT NULL THEN
496: BIS_UTILITIES_PUB.put_line(p_text =>'Retrieving alert parameter set based on target level');
497: FOR P_set IN parameter_set_tl

Line 496: BIS_UTILITIES_PUB.put_line(p_text =>'Retrieving alert parameter set based on target level');

492: END LOOP;
493: BIS_UTILITIES_PUB.put_line(p_text =>'Retrieved '||l_Param_Set_Tbl.COUNT||' parameter sets');
494:
495: ELSIF p_Param_Set_Rec.TARGET_LEVEL_ID IS NOT NULL THEN
496: BIS_UTILITIES_PUB.put_line(p_text =>'Retrieving alert parameter set based on target level');
497: FOR P_set IN parameter_set_tl
498: LOOP
499: l_Param_Set_rec.REGISTRATION_ID := p_set.REGISTRATION_ID;
500: l_Param_Set_rec.PERFORMANCE_MEASURE_ID := p_set.PERFORMANCE_MEASURE_ID;

Line 516: BIS_UTILITIES_PUB.put_line(p_text =>'Retrieved '||l_Param_Set_Tbl.COUNT||' parameter sets');

512: l_Param_Set_rec.PARAMETER7_VALUE := p_set.PARAMETER7_VALUE;
513: l_Param_Set_rec.NOTIFY_OWNER_FLAG := p_set.NOTIFY_OWNER_FLAG;
514: l_Param_Set_Tbl(l_Param_Set_Tbl.COUNT+1) := l_Param_Set_rec;
515: END LOOP;
516: BIS_UTILITIES_PUB.put_line(p_text =>'Retrieved '||l_Param_Set_Tbl.COUNT||' parameter sets');
517:
518: ELSIF p_Param_Set_rec.PERFORMANCE_MEASURE_ID IS NOT NULL
519: AND p_Param_Set_rec.TIME_DIMENSION_LEVEL_ID IS NOT NULL
520: THEN

Line 521: BIS_UTILITIES_PUB.put_line(p_text =>'Retrieving alert parameter set based on performance measure');

517:
518: ELSIF p_Param_Set_rec.PERFORMANCE_MEASURE_ID IS NOT NULL
519: AND p_Param_Set_rec.TIME_DIMENSION_LEVEL_ID IS NOT NULL
520: THEN
521: BIS_UTILITIES_PUB.put_line(p_text =>'Retrieving alert parameter set based on performance measure');
522: Retrieve_Parameter_set
523: ( p_api_version => 1.0
524: , p_measure_id => p_Param_Set_rec.PERFORMANCE_MEASURE_ID
525: , p_time_dimension_level_id => p_Param_Set_rec.TIME_DIMENSION_LEVEL_ID

Line 531: BIS_UTILITIES_PUB.put_line(p_text =>'Retrieved '||l_Param_Set_Tbl.COUNT||' parameter sets');

527: , x_Param_Set_tbl => l_param_set_tbl
528: , x_return_status => x_return_status
529: , x_error_Tbl => x_error_Tbl
530: );
531: BIS_UTILITIES_PUB.put_line(p_text =>'Retrieved '||l_Param_Set_Tbl.COUNT||' parameter sets');
532: --x_param_set_tbl := l_param_set_tbl;
533: --RETURN;
534: END IF;
535:

Line 577: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

573: IS
574:
575: l_Param_Set_rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;
576: l_Param_Set_tbl BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
577: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
578: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
579:
580: BEGIN
581:

Line 578: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;

574:
575: l_Param_Set_rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;
576: l_Param_Set_tbl BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
577: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
578: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
579:
580: BEGIN
581:
582: l_Param_Set_rec.performance_measure_id := p_performance_measure_id;

Line 632: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

628: IS
629:
630: l_Param_Set_rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;
631: l_Param_Set_tbl BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
632: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
633: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
634:
635: BEGIN
636:

Line 633: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;

629:
630: l_Param_Set_rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;
631: l_Param_Set_tbl BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
632: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
633: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
634:
635: BEGIN
636:
637: Retrieve_Parameter_set

Line 647: BIS_UTILITIES_PUB.put_line(p_text =>'Notifier code retrieved: '||x_notifiers_code);

643: );
644:
645: IF l_Param_Set_tbl.COUNT >= 1 THEN
646: x_notifiers_code := l_Param_Set_tbl(1).notifiers_code;
647: BIS_UTILITIES_PUB.put_line(p_text =>'Notifier code retrieved: '||x_notifiers_code);
648: ELSE
649: BIS_UTILITIES_PUB.put_line(p_text =>'Notifier code not retrieved.');
650: x_notifiers_code := null;
651: END IF;

Line 649: BIS_UTILITIES_PUB.put_line(p_text =>'Notifier code not retrieved.');

645: IF l_Param_Set_tbl.COUNT >= 1 THEN
646: x_notifiers_code := l_Param_Set_tbl(1).notifiers_code;
647: BIS_UTILITIES_PUB.put_line(p_text =>'Notifier code retrieved: '||x_notifiers_code);
648: ELSE
649: BIS_UTILITIES_PUB.put_line(p_text =>'Notifier code not retrieved.');
650: x_notifiers_code := null;
651: END IF;
652:
653: EXCEPTION

Line 657: BIS_UTILITIES_PUB.put_line(p_text =>x_return_status);

653: EXCEPTION
654: when others then
655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
656: x_return_status := 'exception 1 at Retrieve_Notifiers_Code: '||sqlerrm;
657: BIS_UTILITIES_PUB.put_line(p_text =>x_return_status);
658: l_error_tbl_p := l_error_tbl;
659: BIS_UTILITIES_PVT.Add_Error_Message
660: ( p_error_msg_id => SQLCODE
661: , p_error_description => SQLERRM

Line 678: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

674: PROCEDURE Manage_Alert_Registrations
675: ( p_Param_Set_Tbl IN BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
676: , x_request_scheduled OUT NOCOPY VARCHAR2
677: , x_return_status OUT NOCOPY VARCHAR2
678: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
679: )
680: IS
681:
682: l_return_status VARCHAR2(32000);

Line 683: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

679: )
680: IS
681:
682: l_return_status VARCHAR2(32000);
683: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
684:
685: BEGIN
686:
687: FOR i IN 1..p_Param_Set_Tbl.COUNT LOOP

Line 723: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

719: PROCEDURE Manage_Alert_Registrations
720: ( p_Param_Set_rec IN BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
721: , x_request_scheduled OUT NOCOPY VARCHAR2
722: , x_return_status OUT NOCOPY VARCHAR2
723: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
724: )
725: IS
726: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
727: BEGIN

Line 726: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

722: , x_return_status OUT NOCOPY VARCHAR2
723: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
724: )
725: IS
726: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
727: BEGIN
728:
729: BIS_CONCURRENT_MANAGER_PVT.Manage_Alert_Registrations
730: ( p_Param_Set_rec => p_Param_Set_rec

Line 739: BIS_UTILITIES_PUB.put_line(p_text =>'exception 1 in Manage_Alert_Registrations: '||sqlerrm);

735:
736: EXCEPTION
737: when FND_API.G_EXC_ERROR then
738: x_return_status := FND_API.G_RET_STS_ERROR ;
739: BIS_UTILITIES_PUB.put_line(p_text =>'exception 1 in Manage_Alert_Registrations: '||sqlerrm);
740: when FND_API.G_EXC_UNEXPECTED_ERROR then
741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
742: BIS_UTILITIES_PUB.put_line(p_text =>'exception 2 in Manage_Alert_Registrations: '||sqlerrm);
743: when others then

Line 742: BIS_UTILITIES_PUB.put_line(p_text =>'exception 2 in Manage_Alert_Registrations: '||sqlerrm);

738: x_return_status := FND_API.G_RET_STS_ERROR ;
739: BIS_UTILITIES_PUB.put_line(p_text =>'exception 1 in Manage_Alert_Registrations: '||sqlerrm);
740: when FND_API.G_EXC_UNEXPECTED_ERROR then
741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
742: BIS_UTILITIES_PUB.put_line(p_text =>'exception 2 in Manage_Alert_Registrations: '||sqlerrm);
743: when others then
744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
745: BIS_UTILITIES_PUB.put_line(p_text =>'exception 3 in Manage_Alert_Registrations: '||sqlerrm);
746: l_error_tbl := x_error_Tbl;

Line 745: BIS_UTILITIES_PUB.put_line(p_text =>'exception 3 in Manage_Alert_Registrations: '||sqlerrm);

741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
742: BIS_UTILITIES_PUB.put_line(p_text =>'exception 2 in Manage_Alert_Registrations: '||sqlerrm);
743: when others then
744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
745: BIS_UTILITIES_PUB.put_line(p_text =>'exception 3 in Manage_Alert_Registrations: '||sqlerrm);
746: l_error_tbl := x_error_Tbl;
747: BIS_UTILITIES_PVT.Add_Error_Message
748: ( p_error_msg_id => SQLCODE
749: , p_error_description => SQLERRM

Line 762: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

758: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
759: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
760: , x_request_scheduled OUT NOCOPY VARCHAR2
761: , x_return_status OUT NOCOPY VARCHAR2
762: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
763: )
764: IS
765:
766: l_Param_Set_Rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;

Line 772: BIS_UTILITIES_PUB.put_line(p_text =>'Managing alert registrations. ');

768: l_request_scheduled VARCHAR2(1000);
769:
770: BEGIN
771:
772: BIS_UTILITIES_PUB.put_line(p_text =>'Managing alert registrations. ');
773: BIS_UTILITIES_PUB.put_line(p_text =>'Measure: '||p_measure_instance.measure_id
774: ||', target level: '||p_measure_instance.Target_Level_ID);
775:
776: Form_Param_Set_Rec

Line 773: BIS_UTILITIES_PUB.put_line(p_text =>'Measure: '||p_measure_instance.measure_id

769:
770: BEGIN
771:
772: BIS_UTILITIES_PUB.put_line(p_text =>'Managing alert registrations. ');
773: BIS_UTILITIES_PUB.put_line(p_text =>'Measure: '||p_measure_instance.measure_id
774: ||', target level: '||p_measure_instance.Target_Level_ID);
775:
776: Form_Param_Set_Rec
777: ( p_measure_instance => p_measure_instance

Line 804: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

800: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
801: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
802: l_dimension_level_number NUMBER;
803: l_return_status VARCHAR2(32000);
804: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
805:
806: BEGIN
807:
808: l_Target_Level_Rec.target_level_id := p_measure_instance.target_level_id;

Line 840: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

836: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
837: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
838: l_dimension_level_number NUMBER;
839: l_return_status VARCHAR2(32000);
840: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
841:
842: BEGIN
843:
844: l_Target_Level_Rec.target_level_id := p_measure_instance.target_level_id;

Line 888: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

884: ( p_api_version IN NUMBER
885: , p_Param_Set_Rec IN BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
886: , x_notifiers_code OUT NOCOPY VARCHAR2
887: , x_return_status OUT NOCOPY VARCHAR2
888: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
889: ) return boolean
890: IS
891:
892: l_Param_Set_tbl BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;

Line 894: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

890: IS
891:
892: l_Param_Set_tbl BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
893: l_p_exist boolean;
894: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
895:
896: BEGIN
897:
898: Retrieve_Parameter_set

Line 945: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

941: ( p_api_version IN NUMBER
942: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
943: , p_Param_Set_Rec IN BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
944: , x_return_status OUT NOCOPY VARCHAR2
945: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
946: )
947: IS
948: --
949: l_return_status VARCHAR2(10);

Line 950: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

946: )
947: IS
948: --
949: l_return_status VARCHAR2(10);
950: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
951: l_target_rec BIS_TARGET_PUB.Target_Rec_Type;
952: l_target_level_rec BIS_TARGET_LEVEL_PUB.Target_level_Rec_Type;
953: l_measure_rec BIS_MEASURE_PUB.measure_rec_type;
954: --

Line 959: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;

955: l_bisbv_target_levels BIS_TARGET_LEVEL_PUB.Target_level_Rec_Type;
956: l_Dim_Level_Value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
957: l_measure_rec_p BIS_MEASURE_PUB.measure_rec_type;
958: l_Dim_Level_Value_Rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
959: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
960: --
961: BEGIN
962: --
963: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1325: || BIS_UTILITIES_PUB.encode(p_measure_id);

1321: IF (p_measure_id IS NOT NULL) THEN
1322: l_alert_url := l_alert_url || G_AMPERSAND || 'perfMeasureId='
1323: -- 2280993 starts
1324: -- || wfa_html.conv_special_url_chars(p_measure_id);
1325: || BIS_UTILITIES_PUB.encode(p_measure_id);
1326: -- 2280993 ends
1327: END IF;
1328: IF (p_plan_id IS NOT NULL) THEN
1329: l_alert_url := l_alert_url || G_AMPERSAND || 'planId='

Line 1332: || BIS_UTILITIES_PUB.encode(p_plan_id);

1328: IF (p_plan_id IS NOT NULL) THEN
1329: l_alert_url := l_alert_url || G_AMPERSAND || 'planId='
1330: -- 2280993 starts
1331: -- || wfa_html.conv_special_url_chars(p_plan_id);
1332: || BIS_UTILITIES_PUB.encode(p_plan_id);
1333: -- 2280993 ends
1334: END IF;
1335: IF (p_target_level_id IS NOT NULL) THEN
1336: l_Alert_url := l_alert_url || G_AMPERSAND || 'targetLevelId='

Line 1339: ||BIS_UTILITIES_PUB.encode(p_target_level_id);

1335: IF (p_target_level_id IS NOT NULL) THEN
1336: l_Alert_url := l_alert_url || G_AMPERSAND || 'targetLevelId='
1337: -- 2280993 starts
1338: -- ||wfa_html.conv_special_url_chars(p_target_level_id);
1339: ||BIS_UTILITIES_PUB.encode(p_target_level_id);
1340: -- 2280993 ends
1341: END IF;
1342: IF (p_parameter1levelId IS NOT NULL) THEN
1343: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter1LevelId='

Line 1346: ||BIS_UTILITIES_PUB.encode(p_parameter1levelId);

1342: IF (p_parameter1levelId IS NOT NULL) THEN
1343: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter1LevelId='
1344: -- 2280993 starts
1345: -- ||wfa_html.conv_special_url_chars(p_parameter1levelId);
1346: ||BIS_UTILITIES_PUB.encode(p_parameter1levelId);
1347: -- 2280993 ends
1348: END IF;
1349: IF (p_parameter1ValueId IS NOT NULL) THEN
1350: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter1ValueId='

Line 1353: ||BIS_UTILITIES_PUB.encode(p_parameter1ValueId);

1349: IF (p_parameter1ValueId IS NOT NULL) THEN
1350: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter1ValueId='
1351: -- 2280993 starts
1352: -- ||wfa_html.conv_special_url_chars(p_parameter1ValueId);
1353: ||BIS_UTILITIES_PUB.encode(p_parameter1ValueId);
1354: -- 2280993 ends
1355: END IF;
1356: IF (p_parameter2levelId IS NOT NULL) THEN
1357: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter2LevelId='

Line 1360: ||BIS_UTILITIES_PUB.encode(p_parameter2levelId);

1356: IF (p_parameter2levelId IS NOT NULL) THEN
1357: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter2LevelId='
1358: -- 2280993 starts
1359: -- ||wfa_html.conv_special_url_chars(p_parameter2levelId);
1360: ||BIS_UTILITIES_PUB.encode(p_parameter2levelId);
1361: -- 2280993 ends
1362: END IF;
1363: IF (p_parameter2ValueId IS NOT NULL) THEN
1364: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter2ValueId='

Line 1367: ||BIS_UTILITIES_PUB.encode(p_parameter2ValueId);

1363: IF (p_parameter2ValueId IS NOT NULL) THEN
1364: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter2ValueId='
1365: -- 2280993 starts
1366: -- ||wfa_html.conv_special_url_chars(p_parameter2ValueId);
1367: ||BIS_UTILITIES_PUB.encode(p_parameter2ValueId);
1368: -- 2280993 ends
1369: END IF;
1370: IF (p_parameter3levelId IS NOT NULL) THEN
1371: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter3LevelId='

Line 1374: ||BIS_UTILITIES_PUB.encode(p_parameter3levelId);

1370: IF (p_parameter3levelId IS NOT NULL) THEN
1371: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter3LevelId='
1372: -- 2280993 starts
1373: -- ||wfa_html.conv_special_url_chars(p_parameter3levelId);
1374: ||BIS_UTILITIES_PUB.encode(p_parameter3levelId);
1375: -- 2280993 ends
1376: END IF;
1377: IF (p_parameter3ValueId IS NOT NULL) THEN
1378: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter3ValueId='

Line 1381: ||BIS_UTILITIES_PUB.encode(p_parameter3ValueId);

1377: IF (p_parameter3ValueId IS NOT NULL) THEN
1378: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter3ValueId='
1379: -- 2280993 starts
1380: -- ||wfa_html.conv_special_url_chars(p_parameter3ValueId);
1381: ||BIS_UTILITIES_PUB.encode(p_parameter3ValueId);
1382: -- 2280993 ends
1383: END IF;
1384: IF (p_parameter4levelId IS NOT NULL) THEN
1385: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter4LevelId='

Line 1388: ||BIS_UTILITIES_PUB.encode(p_parameter4levelId);

1384: IF (p_parameter4levelId IS NOT NULL) THEN
1385: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter4LevelId='
1386: -- 2280993 starts
1387: -- ||wfa_html.conv_special_url_chars(p_parameter4levelId);
1388: ||BIS_UTILITIES_PUB.encode(p_parameter4levelId);
1389: -- 2280993 ends
1390: END IF;
1391: IF (p_parameter4ValueId IS NOT NULL) THEN
1392: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter4ValueId='

Line 1395: ||BIS_UTILITIES_PUB.encode(p_parameter4ValueId);

1391: IF (p_parameter4ValueId IS NOT NULL) THEN
1392: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter4ValueId='
1393: -- 2280993 starts
1394: -- ||wfa_html.conv_special_url_chars(p_parameter4ValueId);
1395: ||BIS_UTILITIES_PUB.encode(p_parameter4ValueId);
1396: -- 2280993 ends
1397: END IF;
1398: IF (p_parameter5levelId IS NOT NULL) THEN
1399: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter5LevelId='

Line 1402: ||BIS_UTILITIES_PUB.encode(p_parameter5levelId);

1398: IF (p_parameter5levelId IS NOT NULL) THEN
1399: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter5LevelId='
1400: -- 2280993 starts
1401: -- ||wfa_html.conv_special_url_chars(p_parameter5levelId);
1402: ||BIS_UTILITIES_PUB.encode(p_parameter5levelId);
1403: -- 2280993 ends
1404: END IF;
1405: IF (p_parameter5ValueId IS NOT NULL) THEN
1406: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter5ValueId='

Line 1409: ||BIS_UTILITIES_PUB.encode(p_parameter5ValueId);

1405: IF (p_parameter5ValueId IS NOT NULL) THEN
1406: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter5ValueId='
1407: -- 2280993 starts
1408: -- ||wfa_html.conv_special_url_chars(p_parameter5ValueId);
1409: ||BIS_UTILITIES_PUB.encode(p_parameter5ValueId);
1410: -- 2280993 ends
1411: END IF;
1412: IF (p_parameter6levelId IS NOT NULL) THEN
1413: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter6LevelId='

Line 1416: ||BIS_UTILITIES_PUB.encode(p_parameter6levelId);

1412: IF (p_parameter6levelId IS NOT NULL) THEN
1413: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter6LevelId='
1414: -- 2280993 starts
1415: -- ||wfa_html.conv_special_url_chars(p_parameter6levelId);
1416: ||BIS_UTILITIES_PUB.encode(p_parameter6levelId);
1417: -- 2280993 ends
1418: END IF;
1419: IF (p_parameter6ValueId IS NOT NULL) THEN
1420: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter6ValueId='

Line 1423: ||BIS_UTILITIES_PUB.encode(p_parameter6ValueId);

1419: IF (p_parameter6ValueId IS NOT NULL) THEN
1420: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter6ValueId='
1421: -- 2280993 starts
1422: -- ||wfa_html.conv_special_url_chars(p_parameter6ValueId);
1423: ||BIS_UTILITIES_PUB.encode(p_parameter6ValueId);
1424: -- 2280993 ends
1425: END IF;
1426: IF (p_parameter7levelId IS NOT NULL) THEN
1427: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter7LevelId='

Line 1430: ||BIS_UTILITIES_PUB.encode(p_parameter7levelId);

1426: IF (p_parameter7levelId IS NOT NULL) THEN
1427: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter7LevelId='
1428: -- 2280993 starts
1429: -- ||wfa_html.conv_special_url_chars(p_parameter7levelId);
1430: ||BIS_UTILITIES_PUB.encode(p_parameter7levelId);
1431: -- 2280993 ends
1432: END IF;
1433: IF (p_parameter7ValueId IS NOT NULL) THEN
1434: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter7ValueId='

Line 1437: ||BIS_UTILITIES_PUB.encode(p_parameter7ValueId);

1433: IF (p_parameter7ValueId IS NOT NULL) THEN
1434: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter7ValueId='
1435: -- 2280993 starts
1436: -- ||wfa_html.conv_special_url_chars(p_parameter7ValueId);
1437: ||BIS_UTILITIES_PUB.encode(p_parameter7ValueId);
1438: -- 2280993 ends
1439: END IF;
1440: IF (p_viewByLevelId IS NOT NULL) THEN
1441: l_alert_url := l_alert_url || G_AMPERSAND || 'viewByLevelId='

Line 1444: ||BIS_UTILITIES_PUB.encode(p_viewByLevelId);

1440: IF (p_viewByLevelId IS NOT NULL) THEN
1441: l_alert_url := l_alert_url || G_AMPERSAND || 'viewByLevelId='
1442: -- 2280993 starts
1443: -- ||wfa_html.conv_special_url_chars(p_viewByLevelId);
1444: ||BIS_UTILITIES_PUB.encode(p_viewByLevelId);
1445: -- 2280993 ends
1446: END IF;
1447:
1448: BIS_UTILITIES_PUB.put_line(p_text =>'alert url built');

Line 1448: BIS_UTILITIES_PUB.put_line(p_text =>'alert url built');

1444: ||BIS_UTILITIES_PUB.encode(p_viewByLevelId);
1445: -- 2280993 ends
1446: END IF;
1447:
1448: BIS_UTILITIES_PUB.put_line(p_text =>'alert url built');
1449: x_alert_url := l_alert_url;
1450:
1451: EXCEPTION
1452: WHEN OTHERS THEN

Line 1453: BIS_UTILITIES_PUB.put_line(p_text =>'Error in BuildAlertRegistrationURL: '||SQLERRM);

1449: x_alert_url := l_alert_url;
1450:
1451: EXCEPTION
1452: WHEN OTHERS THEN
1453: BIS_UTILITIES_PUB.put_line(p_text =>'Error in BuildAlertRegistrationURL: '||SQLERRM);
1454:
1455: END BuildAlertRegistrationURL;
1456:
1457: PROCEDURE BuildAlertRegistrationURL

Line 1487: ||BIS_UTILITIES_PUB.encode(p_measure_id);

1483: IF (p_measure_id IS NOT NULL) THEN
1484: l_alert_url := l_alert_url || G_AMPERSAND ||'perfMeasureId='
1485: -- 2280993 starts
1486: -- ||wfa_html.conv_special_url_chars(p_measure_id);
1487: ||BIS_UTILITIES_PUB.encode(p_measure_id);
1488: -- 2280993 ends
1489: END IF;
1490: IF (p_timelevel_id IS NOT NULL) THEN
1491: l_alert_url := l_alert_url || G_AMPERSAND||'timeDimLevelId='

Line 1494: || BIS_UTILITIES_PUB.encode(p_timelevel_id);

1490: IF (p_timelevel_id IS NOT NULL) THEN
1491: l_alert_url := l_alert_url || G_AMPERSAND||'timeDimLevelId='
1492: -- 2280993 starts
1493: -- || wfa_html.conv_special_url_chars(p_timelevel_id);
1494: || BIS_UTILITIES_PUB.encode(p_timelevel_id);
1495: -- 2280993 ends
1496: END IF;
1497: IF (p_viewByLevelId IS NOT NULL) THEN
1498: l_alert_url := l_alert_url || G_AMPERSAND || 'viewByLevelId='

Line 1501: ||BIS_UTILITIES_PUB.encode(p_viewByLevelId);

1497: IF (p_viewByLevelId IS NOT NULL) THEN
1498: l_alert_url := l_alert_url || G_AMPERSAND || 'viewByLevelId='
1499: -- 2280993 starts
1500: -- ||wfa_html.conv_special_url_chars(p_viewByLevelId);
1501: ||BIS_UTILITIES_PUB.encode(p_viewByLevelId);
1502: -- 2280993 ends
1503: END IF;
1504:
1505: x_alert_url := l_alert_url;

Line 1509: BIS_UTILITIES_PUB.put_line(p_text =>'Error in BuildAlertRegistrationURL: '||SQLERRM);

1505: x_alert_url := l_alert_url;
1506:
1507: EXCEPTION
1508: WHEN OTHERS THEN
1509: BIS_UTILITIES_PUB.put_line(p_text =>'Error in BuildAlertRegistrationURL: '||SQLERRM);
1510:
1511: END BuildAlertRegistrationURL;
1512:
1513: PROCEDURE BuildScheduleReportURL

Line 1545: BIS_UTILITIES_PUB.put_line(p_text =>'Error in BuildScheduleReportURL: '||SQLERRM);

1541: Null;
1542:
1543: EXCEPTION
1544: WHEN OTHERS THEN
1545: BIS_UTILITIES_PUB.put_line(p_text =>'Error in BuildScheduleReportURL: '||SQLERRM);
1546:
1547: END BuildScheduleReportURL;
1548:
1549: PROCEDURE Add_Users_To_Role

Line 1575: BIS_UTILITIES_PUB.put_line(p_text =>'Error in Add_Users_To_Role: '||SQLERRM);

1571: END IF;
1572: l_user_names := ltrim(substr(l_user_names, c1+1));
1573: EXCEPTION
1574: WHEN OTHERS THEN
1575: BIS_UTILITIES_PUB.put_line(p_text =>'Error in Add_Users_To_Role: '||SQLERRM);
1576: IF (c1 = 0) THEN
1577: EXIT;
1578: ELSE
1579: l_user_names := ltrim(substr(l_user_names, c1+1));