DBA Data[Home] [Help]

APPS.BIS_PMF_ALERT_REG_PUB dependencies on FND_API

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

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

Line 47: when FND_API.G_EXC_ERROR then

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

Line 48: x_return_status := FND_API.G_RET_STS_ERROR ;

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 ;

Line 49: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

Line 50: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 52: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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'

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

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

Line 88: when FND_API.G_EXC_ERROR then

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

Line 89: x_return_status := FND_API.G_RET_STS_ERROR ;

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 ;

Line 90: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

Line 91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 93: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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'

Line 129: when FND_API.G_EXC_ERROR then

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

Line 130: x_return_status := FND_API.G_RET_STS_ERROR ;

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 ;

Line 131: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

Line 132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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'

Line 168: when FND_API.G_EXC_ERROR then

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

Line 169: x_return_status := FND_API.G_RET_STS_ERROR ;

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 ;

Line 170: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

Line 171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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'

Line 200: when FND_API.G_EXC_ERROR then

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

Line 201: x_return_status := FND_API.G_RET_STS_ERROR ;

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 ;

Line 202: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

Line 203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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'

Line 243: when FND_API.G_EXC_ERROR then

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

Line 244: x_return_status := FND_API.G_RET_STS_ERROR ;

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 ;

Line 245: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

Line 246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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'