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 FND_API

Line 40: , p_commit IN VARCHAR2 := FND_API.G_FALSE

36:
37:
38: PROCEDURE Create_Parameter_set
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: )

Line 58: x_return_status := FND_API.G_RET_STS_SUCCESS;

54: l_null_role_name_p VARCHAR2(30) := NULL;
55:
56: BEGIN
57:
58: x_return_status := FND_API.G_RET_STS_SUCCESS;
59:
60: /* Commented out NOCOPY for performance reasons.
61:
62: BIS_PMF_ALERT_REG_PVT.Validate_Parameter_set

Line 68: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

64: , p_Param_Set_Rec => p_Param_Set_rec
65: , x_return_status => x_Return_status
66: , x_error_Tbl => x_error_tbl
67: );
68: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
69: RAISE FND_API.G_EXC_ERROR;
70: END IF;
71: */
72:

Line 69: RAISE FND_API.G_EXC_ERROR;

65: , x_return_status => x_Return_status
66: , x_error_Tbl => x_error_tbl
67: );
68: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
69: RAISE FND_API.G_EXC_ERROR;
70: END IF;
71: */
72:
73: l_user_id := fnd_global.USER_ID;

Line 178: if (p_commit = FND_API.G_TRUE) then

174: , l_user_id
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:

Line 184: when FND_API.G_EXC_ERROR then

180: COMMIT;
181: end if;
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 ;

Line 185: x_return_status := FND_API.G_RET_STS_ERROR ;

181: end if;
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);

Line 187: when FND_API.G_EXC_UNEXPECTED_ERROR then

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
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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
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);

Line 191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
194: BIS_UTILITIES_PVT.Add_Error_Message
195: ( p_error_msg_id => SQLCODE

Line 210: , p_commit IN VARCHAR2 := FND_API.G_FALSE

206: --
207:
208: PROCEDURE Delete_Parameter_set
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: )

Line 219: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
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

Line 226: IF p_commit = FND_API.G_TRUE 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;
229:
230: EXCEPTION

Line 231: when FND_API.G_EXC_ERROR then

227: commit;
228: END IF;
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 ;

Line 232: x_return_status := FND_API.G_RET_STS_ERROR ;

228: END IF;
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);

Line 234: when FND_API.G_EXC_UNEXPECTED_ERROR then

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
238: BIS_UTILITIES_PUB.put_line(p_text =>'exception 3 in delete parameter set: '||sqlerrm);

Line 235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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
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 ;

Line 239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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
243: , p_error_description => SQLERRM

Line 263: x_return_status := FND_API.G_RET_STS_SUCCESS;

259: l_debug VARCHAR2(32000);
260:
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;

Line 284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

280: x_return_status := x_return_status ||'--delete debug--'||l_debug;
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: --

Line 365: when FND_API.G_EXC_ERROR then

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;
367: x_return_status := FND_API.G_RET_STS_ERROR ;
368: when FND_API.G_EXC_UNEXPECTED_ERROR then
369: IF parameter_set_list%ISOPEN THEN close parameter_set_list; END IF;

Line 367: x_return_status := FND_API.G_RET_STS_ERROR ;

363:
364: EXCEPTION
365: when FND_API.G_EXC_ERROR then
366: IF parameter_set_list%ISOPEN THEN close parameter_set_list; END IF;
367: x_return_status := FND_API.G_RET_STS_ERROR ;
368: when FND_API.G_EXC_UNEXPECTED_ERROR then
369: IF parameter_set_list%ISOPEN THEN close parameter_set_list; END IF;
370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
371: when others then

Line 368: when FND_API.G_EXC_UNEXPECTED_ERROR then

364: EXCEPTION
365: when FND_API.G_EXC_ERROR then
366: IF parameter_set_list%ISOPEN THEN close parameter_set_list; END IF;
367: x_return_status := FND_API.G_RET_STS_ERROR ;
368: when FND_API.G_EXC_UNEXPECTED_ERROR then
369: IF parameter_set_list%ISOPEN THEN close parameter_set_list; END IF;
370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
371: when others then
372: IF parameter_set_list%ISOPEN THEN close parameter_set_list; END IF;

Line 370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

366: IF parameter_set_list%ISOPEN THEN close parameter_set_list; END IF;
367: x_return_status := FND_API.G_RET_STS_ERROR ;
368: when FND_API.G_EXC_UNEXPECTED_ERROR then
369: IF parameter_set_list%ISOPEN THEN close parameter_set_list; END IF;
370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
371: when others then
372: IF parameter_set_list%ISOPEN THEN close parameter_set_list; END IF;
373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
374: l_error_tbl := x_error_Tbl;

Line 373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

369: IF parameter_set_list%ISOPEN THEN close parameter_set_list; END IF;
370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
371: when others then
372: IF parameter_set_list%ISOPEN THEN close parameter_set_list; END IF;
373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
374: l_error_tbl := x_error_Tbl;
375: BIS_UTILITIES_PVT.Add_Error_Message
376: ( p_error_msg_id => SQLCODE
377: , p_error_description => SQLERRM

Line 539: when FND_API.G_EXC_ERROR then

535:
536: x_Param_Set_Tbl := l_Param_Set_tbl;
537:
538: EXCEPTION
539: when FND_API.G_EXC_ERROR then
540: x_return_status := FND_API.G_RET_STS_ERROR ;
541: when FND_API.G_EXC_UNEXPECTED_ERROR then
542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
543: when others then

Line 540: x_return_status := FND_API.G_RET_STS_ERROR ;

536: x_Param_Set_Tbl := l_Param_Set_tbl;
537:
538: EXCEPTION
539: when FND_API.G_EXC_ERROR then
540: x_return_status := FND_API.G_RET_STS_ERROR ;
541: when FND_API.G_EXC_UNEXPECTED_ERROR then
542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
543: when others then
544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 541: when FND_API.G_EXC_UNEXPECTED_ERROR then

537:
538: EXCEPTION
539: when FND_API.G_EXC_ERROR then
540: x_return_status := FND_API.G_RET_STS_ERROR ;
541: when FND_API.G_EXC_UNEXPECTED_ERROR then
542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
543: when others then
544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
545: l_error_tbl := x_error_Tbl;

Line 542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

538: EXCEPTION
539: when FND_API.G_EXC_ERROR then
540: x_return_status := FND_API.G_RET_STS_ERROR ;
541: when FND_API.G_EXC_UNEXPECTED_ERROR then
542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
543: when others then
544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
545: l_error_tbl := x_error_Tbl;
546: BIS_UTILITIES_PVT.Add_Error_Message

Line 544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

540: x_return_status := FND_API.G_RET_STS_ERROR ;
541: when FND_API.G_EXC_UNEXPECTED_ERROR then
542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
543: when others then
544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
545: l_error_tbl := x_error_Tbl;
546: BIS_UTILITIES_PVT.Add_Error_Message
547: ( p_error_msg_id => SQLCODE
548: , p_error_description => SQLERRM

Line 602: when FND_API.G_EXC_ERROR then

598: , x_return_status => x_return_status
599: );
600:
601: EXCEPTION
602: when FND_API.G_EXC_ERROR then
603: x_return_status := FND_API.G_RET_STS_ERROR ;
604: x_return_status := 'exception 1 at Retrieve_Notifiers_Code: '||sqlerrm;
605: when FND_API.G_EXC_UNEXPECTED_ERROR then
606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 603: x_return_status := FND_API.G_RET_STS_ERROR ;

599: );
600:
601: EXCEPTION
602: when FND_API.G_EXC_ERROR then
603: x_return_status := FND_API.G_RET_STS_ERROR ;
604: x_return_status := 'exception 1 at Retrieve_Notifiers_Code: '||sqlerrm;
605: when FND_API.G_EXC_UNEXPECTED_ERROR then
606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
607: x_return_status := 'exception 2 at Retrieve_Notifiers_Code: '||sqlerrm;

Line 605: when FND_API.G_EXC_UNEXPECTED_ERROR then

601: EXCEPTION
602: when FND_API.G_EXC_ERROR then
603: x_return_status := FND_API.G_RET_STS_ERROR ;
604: x_return_status := 'exception 1 at Retrieve_Notifiers_Code: '||sqlerrm;
605: when FND_API.G_EXC_UNEXPECTED_ERROR then
606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
607: x_return_status := 'exception 2 at Retrieve_Notifiers_Code: '||sqlerrm;
608: when others then
609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

602: when FND_API.G_EXC_ERROR then
603: x_return_status := FND_API.G_RET_STS_ERROR ;
604: x_return_status := 'exception 1 at Retrieve_Notifiers_Code: '||sqlerrm;
605: when FND_API.G_EXC_UNEXPECTED_ERROR then
606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
607: x_return_status := 'exception 2 at Retrieve_Notifiers_Code: '||sqlerrm;
608: when others then
609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
610: x_return_status := 'exception 3 at Retrieve_Notifiers_Code: '||sqlerrm;

Line 609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

605: when FND_API.G_EXC_UNEXPECTED_ERROR then
606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
607: x_return_status := 'exception 2 at Retrieve_Notifiers_Code: '||sqlerrm;
608: when others then
609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
610: x_return_status := 'exception 3 at Retrieve_Notifiers_Code: '||sqlerrm;
611: l_error_tbl_p := l_error_tbl;
612: BIS_UTILITIES_PVT.Add_Error_Message
613: ( p_error_msg_id => SQLCODE

Line 655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

651: END IF;
652:
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

Line 697: when FND_API.G_EXC_ERROR then

693: );
694: END LOOP;
695:
696: EXCEPTION
697: when FND_API.G_EXC_ERROR then
698: x_return_status := FND_API.G_RET_STS_ERROR ;
699: when FND_API.G_EXC_UNEXPECTED_ERROR then
700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
701: when others then

Line 698: x_return_status := FND_API.G_RET_STS_ERROR ;

694: END LOOP;
695:
696: EXCEPTION
697: when FND_API.G_EXC_ERROR then
698: x_return_status := FND_API.G_RET_STS_ERROR ;
699: when FND_API.G_EXC_UNEXPECTED_ERROR then
700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
701: when others then
702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 699: when FND_API.G_EXC_UNEXPECTED_ERROR then

695:
696: EXCEPTION
697: when FND_API.G_EXC_ERROR then
698: x_return_status := FND_API.G_RET_STS_ERROR ;
699: when FND_API.G_EXC_UNEXPECTED_ERROR then
700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
701: when others then
702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
703: l_error_tbl := x_error_tbl;

Line 700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

696: EXCEPTION
697: when FND_API.G_EXC_ERROR then
698: x_return_status := FND_API.G_RET_STS_ERROR ;
699: when FND_API.G_EXC_UNEXPECTED_ERROR then
700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
701: when others then
702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
703: l_error_tbl := x_error_tbl;
704: BIS_UTILITIES_PVT.Add_Error_Message

Line 702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

698: x_return_status := FND_API.G_RET_STS_ERROR ;
699: when FND_API.G_EXC_UNEXPECTED_ERROR then
700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
701: when others then
702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
703: l_error_tbl := x_error_tbl;
704: BIS_UTILITIES_PVT.Add_Error_Message
705: ( p_error_msg_id => SQLCODE
706: , p_error_description => SQLERRM

Line 737: when FND_API.G_EXC_ERROR then

733: , x_error_Tbl => x_error_Tbl
734: );
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 ;

Line 738: x_return_status := FND_API.G_RET_STS_ERROR ;

734: );
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);

Line 740: when FND_API.G_EXC_UNEXPECTED_ERROR then

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
744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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
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);

Line 744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
747: BIS_UTILITIES_PVT.Add_Error_Message
748: ( p_error_msg_id => SQLCODE

Line 914: when FND_API.G_EXC_ERROR then

910:
911: return l_p_exist;
912:
913: EXCEPTION
914: when FND_API.G_EXC_ERROR then
915: x_return_status := FND_API.G_RET_STS_ERROR ;
916: x_return_status := ' exception 1 at Parameter_set_exist '||sqlerrm;
917: return FALSE;
918: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 915: x_return_status := FND_API.G_RET_STS_ERROR ;

911: return l_p_exist;
912:
913: EXCEPTION
914: when FND_API.G_EXC_ERROR then
915: x_return_status := FND_API.G_RET_STS_ERROR ;
916: x_return_status := ' exception 1 at Parameter_set_exist '||sqlerrm;
917: return FALSE;
918: when FND_API.G_EXC_UNEXPECTED_ERROR then
919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 918: when FND_API.G_EXC_UNEXPECTED_ERROR then

914: when FND_API.G_EXC_ERROR then
915: x_return_status := FND_API.G_RET_STS_ERROR ;
916: x_return_status := ' exception 1 at Parameter_set_exist '||sqlerrm;
917: return FALSE;
918: when FND_API.G_EXC_UNEXPECTED_ERROR then
919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
920: x_return_status := ' exception 2 at Parameter_set_exist '||sqlerrm;
921: return FALSE;
922: when others then

Line 919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

915: x_return_status := FND_API.G_RET_STS_ERROR ;
916: x_return_status := ' exception 1 at Parameter_set_exist '||sqlerrm;
917: return FALSE;
918: when FND_API.G_EXC_UNEXPECTED_ERROR then
919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
920: x_return_status := ' exception 2 at Parameter_set_exist '||sqlerrm;
921: return FALSE;
922: when others then
923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
920: x_return_status := ' exception 2 at Parameter_set_exist '||sqlerrm;
921: return FALSE;
922: when others then
923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
924: x_return_status := ' exception 3 at Parameter_set_exist '||sqlerrm;
925: return FALSE;
926: l_error_tbl := x_error_Tbl;
927: BIS_UTILITIES_PVT.Add_Error_Message

Line 942: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

938: -- Validates target record
939: --
940: PROCEDURE Validate_Parameter_set
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: )

Line 963: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
964:
965: l_measure_rec.measure_id := p_param_Set_Rec.performance_measure_id;
966:
967: -- Calling the retrieve_measure to validate the measure_id

Line 974: , p_all_info => FND_API.G_FALSE

970: l_measure_rec_p := l_measure_rec;
971: BIS_MEASURE_PUB.Retrieve_Measure
972: ( p_api_version => p_api_version
973: , p_measure_rec => l_measure_rec_p
974: , p_all_info => FND_API.G_FALSE
975: , x_Measure_rec => l_measure_rec
976: , x_return_status => l_return_status
977: , x_error_Tbl => x_error_tbl
978: );

Line 981: WHEN FND_API.G_EXC_ERROR THEN

977: , x_error_Tbl => x_error_tbl
978: );
979:
980: EXCEPTION
981: WHEN FND_API.G_EXC_ERROR THEN
982: x_return_status:= FND_API.G_RET_STS_ERROR;
983: RAISE;
984: END;
985:

Line 982: x_return_status:= FND_API.G_RET_STS_ERROR;

978: );
979:
980: EXCEPTION
981: WHEN FND_API.G_EXC_ERROR THEN
982: x_return_status:= FND_API.G_RET_STS_ERROR;
983: RAISE;
984: END;
985:
986: --

Line 1004: WHEN FND_API.G_EXC_ERROR THEN

1000: , x_error_Tbl => l_error_Tbl
1001: );
1002: --
1003: EXCEPTION
1004: WHEN FND_API.G_EXC_ERROR THEN
1005: x_return_status:= FND_API.G_RET_STS_ERROR;
1006: l_error_tbl_p := x_error_Tbl;
1007: BIS_UTILITIES_PVT.concatenateErrorTables
1008: ( p_error_Tbl1 => l_error_Tbl_p

Line 1005: x_return_status:= FND_API.G_RET_STS_ERROR;

1001: );
1002: --
1003: EXCEPTION
1004: WHEN FND_API.G_EXC_ERROR THEN
1005: x_return_status:= FND_API.G_RET_STS_ERROR;
1006: l_error_tbl_p := x_error_Tbl;
1007: BIS_UTILITIES_PVT.concatenateErrorTables
1008: ( p_error_Tbl1 => l_error_Tbl_p
1009: , p_error_Tbl2 => l_error_Tbl

Line 1021: , p_all_info => FND_API.G_FALSE

1017: BEGIN
1018: BIS_Target_Level_PUB.Retrieve_Target_Level
1019: ( p_api_version => p_api_version
1020: , p_Target_Level_Rec => l_target_level_rec
1021: , p_all_info => FND_API.G_FALSE
1022: , x_Target_Level_Rec => l_bisbv_target_levels
1023: , x_return_status => l_return_status
1024: , x_error_Tbl => x_error_Tbl
1025: );

Line 1028: WHEN FND_API.G_EXC_ERROR THEN

1024: , x_error_Tbl => x_error_Tbl
1025: );
1026: --
1027: EXCEPTION
1028: WHEN FND_API.G_EXC_ERROR THEN
1029: x_return_status:= FND_API.G_RET_STS_ERROR;
1030: RAISE;
1031: END;
1032: --

Line 1029: x_return_status:= FND_API.G_RET_STS_ERROR;

1025: );
1026: --
1027: EXCEPTION
1028: WHEN FND_API.G_EXC_ERROR THEN
1029: x_return_status:= FND_API.G_RET_STS_ERROR;
1030: RAISE;
1031: END;
1032: --
1033:

Line 1054: WHEN FND_API.G_EXC_ERROR THEN

1050: );
1051: END IF;
1052: --
1053: EXCEPTION
1054: WHEN FND_API.G_EXC_ERROR THEN
1055: x_return_status:= FND_API.G_RET_STS_ERROR;
1056: l_error_tbl_p := x_error_Tbl;
1057: BIS_UTILITIES_PVT.concatenateErrorTables
1058: ( p_error_Tbl1 => l_error_Tbl_p

Line 1055: x_return_status:= FND_API.G_RET_STS_ERROR;

1051: END IF;
1052: --
1053: EXCEPTION
1054: WHEN FND_API.G_EXC_ERROR THEN
1055: x_return_status:= FND_API.G_RET_STS_ERROR;
1056: l_error_tbl_p := x_error_Tbl;
1057: BIS_UTILITIES_PVT.concatenateErrorTables
1058: ( p_error_Tbl1 => l_error_Tbl_p
1059: , p_error_Tbl2 => l_error_Tbl

Line 1084: WHEN FND_API.G_EXC_ERROR THEN

1080: );
1081: END IF;
1082: --
1083: EXCEPTION
1084: WHEN FND_API.G_EXC_ERROR THEN
1085: x_return_status:= FND_API.G_RET_STS_ERROR;
1086: l_error_tbl_p := x_error_Tbl;
1087: BIS_UTILITIES_PVT.concatenateErrorTables
1088: ( p_error_Tbl1 => l_error_Tbl_p

Line 1085: x_return_status:= FND_API.G_RET_STS_ERROR;

1081: END IF;
1082: --
1083: EXCEPTION
1084: WHEN FND_API.G_EXC_ERROR THEN
1085: x_return_status:= FND_API.G_RET_STS_ERROR;
1086: l_error_tbl_p := x_error_Tbl;
1087: BIS_UTILITIES_PVT.concatenateErrorTables
1088: ( p_error_Tbl1 => l_error_Tbl_p
1089: , p_error_Tbl2 => l_error_Tbl

Line 1115: WHEN FND_API.G_EXC_ERROR THEN

1111: );
1112: END IF;
1113: --
1114: EXCEPTION
1115: WHEN FND_API.G_EXC_ERROR THEN
1116: x_return_status:= FND_API.G_RET_STS_ERROR;
1117: l_error_tbl_p := x_error_Tbl;
1118: BIS_UTILITIES_PVT.concatenateErrorTables
1119: ( p_error_Tbl1 => l_error_Tbl_p

Line 1116: x_return_status:= FND_API.G_RET_STS_ERROR;

1112: END IF;
1113: --
1114: EXCEPTION
1115: WHEN FND_API.G_EXC_ERROR THEN
1116: x_return_status:= FND_API.G_RET_STS_ERROR;
1117: l_error_tbl_p := x_error_Tbl;
1118: BIS_UTILITIES_PVT.concatenateErrorTables
1119: ( p_error_Tbl1 => l_error_Tbl_p
1120: , p_error_Tbl2 => l_error_Tbl

Line 1147: WHEN FND_API.G_EXC_ERROR THEN

1143: );
1144: END IF;
1145: --
1146: EXCEPTION
1147: WHEN FND_API.G_EXC_ERROR THEN
1148: x_return_status:= FND_API.G_RET_STS_ERROR;
1149: l_error_tbl_p := x_error_Tbl;
1150: BIS_UTILITIES_PVT.concatenateErrorTables
1151: ( p_error_Tbl1 => l_error_Tbl_p

Line 1148: x_return_status:= FND_API.G_RET_STS_ERROR;

1144: END IF;
1145: --
1146: EXCEPTION
1147: WHEN FND_API.G_EXC_ERROR THEN
1148: x_return_status:= FND_API.G_RET_STS_ERROR;
1149: l_error_tbl_p := x_error_Tbl;
1150: BIS_UTILITIES_PVT.concatenateErrorTables
1151: ( p_error_Tbl1 => l_error_Tbl_p
1152: , p_error_Tbl2 => l_error_Tbl

Line 1179: WHEN FND_API.G_EXC_ERROR THEN

1175:
1176: END IF;
1177: --
1178: EXCEPTION
1179: WHEN FND_API.G_EXC_ERROR THEN
1180: x_return_status:= FND_API.G_RET_STS_ERROR;
1181: l_error_tbl_p := x_error_Tbl;
1182: BIS_UTILITIES_PVT.concatenateErrorTables
1183: ( p_error_Tbl1 => l_error_Tbl_p

Line 1180: x_return_status:= FND_API.G_RET_STS_ERROR;

1176: END IF;
1177: --
1178: EXCEPTION
1179: WHEN FND_API.G_EXC_ERROR THEN
1180: x_return_status:= FND_API.G_RET_STS_ERROR;
1181: l_error_tbl_p := x_error_Tbl;
1182: BIS_UTILITIES_PVT.concatenateErrorTables
1183: ( p_error_Tbl1 => l_error_Tbl_p
1184: , p_error_Tbl2 => l_error_Tbl

Line 1212: WHEN FND_API.G_EXC_ERROR THEN

1208:
1209: END IF;
1210: --
1211: EXCEPTION
1212: WHEN FND_API.G_EXC_ERROR THEN
1213: x_return_status:= FND_API.G_RET_STS_ERROR;
1214: l_error_tbl_p := x_error_Tbl;
1215: BIS_UTILITIES_PVT.concatenateErrorTables
1216: ( p_error_Tbl1 => l_error_Tbl_p

Line 1213: x_return_status:= FND_API.G_RET_STS_ERROR;

1209: END IF;
1210: --
1211: EXCEPTION
1212: WHEN FND_API.G_EXC_ERROR THEN
1213: x_return_status:= FND_API.G_RET_STS_ERROR;
1214: l_error_tbl_p := x_error_Tbl;
1215: BIS_UTILITIES_PVT.concatenateErrorTables
1216: ( p_error_Tbl1 => l_error_Tbl_p
1217: , p_error_Tbl2 => l_error_Tbl

Line 1244: WHEN FND_API.G_EXC_ERROR THEN

1240: );
1241: END IF;
1242: --
1243: EXCEPTION
1244: WHEN FND_API.G_EXC_ERROR THEN
1245: x_return_status:= FND_API.G_RET_STS_ERROR;
1246: l_error_tbl_p := x_error_Tbl;
1247: BIS_UTILITIES_PVT.concatenateErrorTables
1248: ( p_error_Tbl1 => l_error_Tbl_p

Line 1245: x_return_status:= FND_API.G_RET_STS_ERROR;

1241: END IF;
1242: --
1243: EXCEPTION
1244: WHEN FND_API.G_EXC_ERROR THEN
1245: x_return_status:= FND_API.G_RET_STS_ERROR;
1246: l_error_tbl_p := x_error_Tbl;
1247: BIS_UTILITIES_PVT.concatenateErrorTables
1248: ( p_error_Tbl1 => l_error_Tbl_p
1249: , p_error_Tbl2 => l_error_Tbl

Line 1261: WHEN FND_API.G_EXC_ERROR THEN

1257: x_return_status := l_return_status;
1258:
1259: --
1260: EXCEPTION
1261: WHEN FND_API.G_EXC_ERROR THEN
1262: x_return_status:= FND_API.G_RET_STS_ERROR;
1263: RAISE;
1264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1262: x_return_status:= FND_API.G_RET_STS_ERROR;

1258:
1259: --
1260: EXCEPTION
1261: WHEN FND_API.G_EXC_ERROR THEN
1262: x_return_status:= FND_API.G_RET_STS_ERROR;
1263: RAISE;
1264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1266: RAISE;

Line 1264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1260: EXCEPTION
1261: WHEN FND_API.G_EXC_ERROR THEN
1262: x_return_status:= FND_API.G_RET_STS_ERROR;
1263: RAISE;
1264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1266: RAISE;
1267: WHEN OTHERS THEN
1268: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 1265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1261: WHEN FND_API.G_EXC_ERROR THEN
1262: x_return_status:= FND_API.G_RET_STS_ERROR;
1263: RAISE;
1264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1266: RAISE;
1267: WHEN OTHERS THEN
1268: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1269: l_error_tbl_p := x_error_Tbl;

Line 1268: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

1264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1266: RAISE;
1267: WHEN OTHERS THEN
1268: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1269: l_error_tbl_p := x_error_Tbl;
1270: BIS_UTILITIES_PVT.Add_Error_Message
1271: ( p_error_table => l_error_Tbl_p
1272: , p_error_msg_id => SQLCODE

Line 1276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1272: , p_error_msg_id => SQLCODE
1273: , p_error_description => SQLERRM
1274: , x_error_table => x_error_Tbl
1275: );
1276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1277: END Validate_Parameter_Set;
1278: --
1279:
1280: PROCEDURE BuildAlertRegistrationURL