24:
25:
26: PROCEDURE Create_Parameter_set
27: ( p_api_version IN NUMBER
28: , p_commit IN VARCHAR2 := FND_API.G_FALSE
29: , p_Param_Set_Rec IN OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
30: , x_return_status OUT NOCOPY VARCHAR2
31: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
32: )
43: );
44:
45:
46: EXCEPTION
47: when FND_API.G_EXC_ERROR then
48: x_return_status := FND_API.G_RET_STS_ERROR ;
49: when FND_API.G_EXC_UNEXPECTED_ERROR then
50: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
51: when others then
44:
45:
46: EXCEPTION
47: when FND_API.G_EXC_ERROR then
48: x_return_status := FND_API.G_RET_STS_ERROR ;
49: when FND_API.G_EXC_UNEXPECTED_ERROR then
50: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
51: when others then
52: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
45:
46: EXCEPTION
47: when FND_API.G_EXC_ERROR then
48: x_return_status := FND_API.G_RET_STS_ERROR ;
49: when FND_API.G_EXC_UNEXPECTED_ERROR then
50: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
51: when others then
52: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
53: BIS_UTILITIES_PVT.Add_Error_Message
46: EXCEPTION
47: when FND_API.G_EXC_ERROR then
48: x_return_status := FND_API.G_RET_STS_ERROR ;
49: when FND_API.G_EXC_UNEXPECTED_ERROR then
50: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
51: when others then
52: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
53: BIS_UTILITIES_PVT.Add_Error_Message
54: ( p_error_msg_id => SQLCODE
48: x_return_status := FND_API.G_RET_STS_ERROR ;
49: when FND_API.G_EXC_UNEXPECTED_ERROR then
50: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
51: when others then
52: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
53: BIS_UTILITIES_PVT.Add_Error_Message
54: ( p_error_msg_id => SQLCODE
55: , p_error_description => SQLERRM
56: , p_error_proc_name => G_PKG_NAME||'.Create_Parameter_set'
65: --
66:
67: PROCEDURE Delete_Parameter_set
68: ( p_api_version IN NUMBER
69: , p_commit IN VARCHAR2 := FND_API.G_FALSE
70: , p_Param_Set_Rec IN BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
71: , x_return_status OUT NOCOPY VARCHAR2
72: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
73: )
84: );
85:
86:
87: EXCEPTION
88: when FND_API.G_EXC_ERROR then
89: x_return_status := FND_API.G_RET_STS_ERROR ;
90: when FND_API.G_EXC_UNEXPECTED_ERROR then
91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
92: when others then
85:
86:
87: EXCEPTION
88: when FND_API.G_EXC_ERROR then
89: x_return_status := FND_API.G_RET_STS_ERROR ;
90: when FND_API.G_EXC_UNEXPECTED_ERROR then
91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
92: when others then
93: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
86:
87: EXCEPTION
88: when FND_API.G_EXC_ERROR then
89: x_return_status := FND_API.G_RET_STS_ERROR ;
90: when FND_API.G_EXC_UNEXPECTED_ERROR then
91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
92: when others then
93: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
94: BIS_UTILITIES_PVT.Add_Error_Message
87: EXCEPTION
88: when FND_API.G_EXC_ERROR then
89: x_return_status := FND_API.G_RET_STS_ERROR ;
90: when FND_API.G_EXC_UNEXPECTED_ERROR then
91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
92: when others then
93: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
94: BIS_UTILITIES_PVT.Add_Error_Message
95: ( p_error_msg_id => SQLCODE
89: x_return_status := FND_API.G_RET_STS_ERROR ;
90: when FND_API.G_EXC_UNEXPECTED_ERROR then
91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
92: when others then
93: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
94: BIS_UTILITIES_PVT.Add_Error_Message
95: ( p_error_msg_id => SQLCODE
96: , p_error_description => SQLERRM
97: , p_error_proc_name => G_PKG_NAME||'.Delete_Parameter_set'
125: , x_error_Tbl => x_error_Tbl
126: );
127:
128: EXCEPTION
129: when FND_API.G_EXC_ERROR then
130: x_return_status := FND_API.G_RET_STS_ERROR ;
131: when FND_API.G_EXC_UNEXPECTED_ERROR then
132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
133: when others then
126: );
127:
128: EXCEPTION
129: when FND_API.G_EXC_ERROR then
130: x_return_status := FND_API.G_RET_STS_ERROR ;
131: when FND_API.G_EXC_UNEXPECTED_ERROR then
132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
133: when others then
134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
127:
128: EXCEPTION
129: when FND_API.G_EXC_ERROR then
130: x_return_status := FND_API.G_RET_STS_ERROR ;
131: when FND_API.G_EXC_UNEXPECTED_ERROR then
132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
133: when others then
134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
135: BIS_UTILITIES_PVT.Add_Error_Message
128: EXCEPTION
129: when FND_API.G_EXC_ERROR then
130: x_return_status := FND_API.G_RET_STS_ERROR ;
131: when FND_API.G_EXC_UNEXPECTED_ERROR then
132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
133: when others then
134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
135: BIS_UTILITIES_PVT.Add_Error_Message
136: ( p_error_msg_id => SQLCODE
130: x_return_status := FND_API.G_RET_STS_ERROR ;
131: when FND_API.G_EXC_UNEXPECTED_ERROR then
132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
133: when others then
134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
135: BIS_UTILITIES_PVT.Add_Error_Message
136: ( p_error_msg_id => SQLCODE
137: , p_error_description => SQLERRM
138: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Parameter_set'
164: , x_error_Tbl => x_error_Tbl
165: );
166:
167: EXCEPTION
168: when FND_API.G_EXC_ERROR then
169: x_return_status := FND_API.G_RET_STS_ERROR ;
170: when FND_API.G_EXC_UNEXPECTED_ERROR then
171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
172: when others then
165: );
166:
167: EXCEPTION
168: when FND_API.G_EXC_ERROR then
169: x_return_status := FND_API.G_RET_STS_ERROR ;
170: when FND_API.G_EXC_UNEXPECTED_ERROR then
171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
172: when others then
173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
166:
167: EXCEPTION
168: when FND_API.G_EXC_ERROR then
169: x_return_status := FND_API.G_RET_STS_ERROR ;
170: when FND_API.G_EXC_UNEXPECTED_ERROR then
171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
172: when others then
173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
174: BIS_UTILITIES_PVT.Add_Error_Message
167: EXCEPTION
168: when FND_API.G_EXC_ERROR then
169: x_return_status := FND_API.G_RET_STS_ERROR ;
170: when FND_API.G_EXC_UNEXPECTED_ERROR then
171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
172: when others then
173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
174: BIS_UTILITIES_PVT.Add_Error_Message
175: ( p_error_msg_id => SQLCODE
169: x_return_status := FND_API.G_RET_STS_ERROR ;
170: when FND_API.G_EXC_UNEXPECTED_ERROR then
171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
172: when others then
173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
174: BIS_UTILITIES_PVT.Add_Error_Message
175: ( p_error_msg_id => SQLCODE
176: , p_error_description => SQLERRM
177: , p_error_proc_name => G_PKG_NAME||'.Manage_Alert_Registrations'
196: , x_error_Tbl => x_error_Tbl
197: );
198:
199: EXCEPTION
200: when FND_API.G_EXC_ERROR then
201: x_return_status := FND_API.G_RET_STS_ERROR ;
202: when FND_API.G_EXC_UNEXPECTED_ERROR then
203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
204: when others then
197: );
198:
199: EXCEPTION
200: when FND_API.G_EXC_ERROR then
201: x_return_status := FND_API.G_RET_STS_ERROR ;
202: when FND_API.G_EXC_UNEXPECTED_ERROR then
203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
204: when others then
205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
198:
199: EXCEPTION
200: when FND_API.G_EXC_ERROR then
201: x_return_status := FND_API.G_RET_STS_ERROR ;
202: when FND_API.G_EXC_UNEXPECTED_ERROR then
203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
204: when others then
205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
206: BIS_UTILITIES_PVT.Add_Error_Message
199: EXCEPTION
200: when FND_API.G_EXC_ERROR then
201: x_return_status := FND_API.G_RET_STS_ERROR ;
202: when FND_API.G_EXC_UNEXPECTED_ERROR then
203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
204: when others then
205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
206: BIS_UTILITIES_PVT.Add_Error_Message
207: ( p_error_msg_id => SQLCODE
201: x_return_status := FND_API.G_RET_STS_ERROR ;
202: when FND_API.G_EXC_UNEXPECTED_ERROR then
203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
204: when others then
205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
206: BIS_UTILITIES_PVT.Add_Error_Message
207: ( p_error_msg_id => SQLCODE
208: , p_error_description => SQLERRM
209: , p_error_proc_name => G_PKG_NAME||'.Manage_Alert_Registrations'
239:
240: return l_p_exist;
241:
242: EXCEPTION
243: when FND_API.G_EXC_ERROR then
244: x_return_status := FND_API.G_RET_STS_ERROR ;
245: when FND_API.G_EXC_UNEXPECTED_ERROR then
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
247: when others then
240: return l_p_exist;
241:
242: EXCEPTION
243: when FND_API.G_EXC_ERROR then
244: x_return_status := FND_API.G_RET_STS_ERROR ;
245: when FND_API.G_EXC_UNEXPECTED_ERROR then
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
247: when others then
248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
241:
242: EXCEPTION
243: when FND_API.G_EXC_ERROR then
244: x_return_status := FND_API.G_RET_STS_ERROR ;
245: when FND_API.G_EXC_UNEXPECTED_ERROR then
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
247: when others then
248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
249: BIS_UTILITIES_PVT.Add_Error_Message
242: EXCEPTION
243: when FND_API.G_EXC_ERROR then
244: x_return_status := FND_API.G_RET_STS_ERROR ;
245: when FND_API.G_EXC_UNEXPECTED_ERROR then
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
247: when others then
248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
249: BIS_UTILITIES_PVT.Add_Error_Message
250: ( p_error_msg_id => SQLCODE
244: x_return_status := FND_API.G_RET_STS_ERROR ;
245: when FND_API.G_EXC_UNEXPECTED_ERROR then
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
247: when others then
248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
249: BIS_UTILITIES_PVT.Add_Error_Message
250: ( p_error_msg_id => SQLCODE
251: , p_error_description => SQLERRM
252: , p_error_proc_name => G_PKG_NAME||'.Parameter_set_exist'