DBA Data[Home] [Help]

APPS.CSF_DEBRIEF_HEADERS_CUHK dependencies on FND_API

Line 20: x_return_status := fnd_api.g_ret_sts_success;

16: l_api_name varchar2(200) := 'Create_debrief_header_Pre' ;
17: BEGIN
18: Savepoint csf_debrief_headers_cuhk;
19:
20: x_return_status := fnd_api.g_ret_sts_success;
21: NULL;
22: -- Standard call to get message count and if count is 1, get message info
23: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
24: p_data => x_msg_data );

Line 27: WHEN FND_API.G_EXC_ERROR THEN

23: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
24: p_data => x_msg_data );
25:
26: EXCEPTION
27: WHEN FND_API.G_EXC_ERROR THEN
28: ROLLBACK TO csf_debrief_headers_cuhk;
29: x_return_status := FND_API.G_RET_STS_ERROR;
30: FND_MSG_PUB.Count_And_Get
31: ( p_count => x_msg_count,

Line 29: x_return_status := FND_API.G_RET_STS_ERROR;

25:
26: EXCEPTION
27: WHEN FND_API.G_EXC_ERROR THEN
28: ROLLBACK TO csf_debrief_headers_cuhk;
29: x_return_status := FND_API.G_RET_STS_ERROR;
30: FND_MSG_PUB.Count_And_Get
31: ( p_count => x_msg_count,
32: p_data => x_msg_data );
33: WHEN OTHERS THEN

Line 35: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

31: ( p_count => x_msg_count,
32: p_data => x_msg_data );
33: WHEN OTHERS THEN
34: ROLLBACK TO csf_debrief_headers_cuhk;
35: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
36: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
37: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
38: END IF;
39: FND_MSG_PUB.Count_And_Get

Line 59: x_return_status := fnd_api.g_ret_sts_success;

55: l_api_name varchar2(200) := 'Create_debrief_header_Pre' ;
56: BEGIN
57: Savepoint csf_debrief_headers_cuhk;
58:
59: x_return_status := fnd_api.g_ret_sts_success;
60: NULL;
61: -- Standard call to get message count and if count is 1, get message info
62: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
63: p_data => x_msg_data );

Line 66: WHEN FND_API.G_EXC_ERROR THEN

62: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
63: p_data => x_msg_data );
64:
65: EXCEPTION
66: WHEN FND_API.G_EXC_ERROR THEN
67: ROLLBACK TO csf_debrief_headers_cuhk;
68: x_return_status := FND_API.G_RET_STS_ERROR;
69: FND_MSG_PUB.Count_And_Get
70: ( p_count => x_msg_count,

Line 68: x_return_status := FND_API.G_RET_STS_ERROR;

64:
65: EXCEPTION
66: WHEN FND_API.G_EXC_ERROR THEN
67: ROLLBACK TO csf_debrief_headers_cuhk;
68: x_return_status := FND_API.G_RET_STS_ERROR;
69: FND_MSG_PUB.Count_And_Get
70: ( p_count => x_msg_count,
71: p_data => x_msg_data );
72: WHEN OTHERS THEN

Line 74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

70: ( p_count => x_msg_count,
71: p_data => x_msg_data );
72: WHEN OTHERS THEN
73: ROLLBACK TO csf_debrief_headers_cuhk;
74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
75: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
76: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
77: END IF;
78: FND_MSG_PUB.Count_And_Get

Line 95: x_return_status := fnd_api.g_ret_sts_success;

91: l_api_name varchar2(200) := 'Create_debrief_header_Pre' ;
92: BEGIN
93: Savepoint csf_debrief_headers_cuhk;
94:
95: x_return_status := fnd_api.g_ret_sts_success;
96: NULL;
97: -- Standard call to get message count and if count is 1, get message info
98: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
99: p_data => x_msg_data );

Line 102: WHEN FND_API.G_EXC_ERROR THEN

98: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
99: p_data => x_msg_data );
100:
101: EXCEPTION
102: WHEN FND_API.G_EXC_ERROR THEN
103: ROLLBACK TO csf_debrief_headers_cuhk;
104: x_return_status := FND_API.G_RET_STS_ERROR;
105: FND_MSG_PUB.Count_And_Get
106: ( p_count => x_msg_count,

Line 104: x_return_status := FND_API.G_RET_STS_ERROR;

100:
101: EXCEPTION
102: WHEN FND_API.G_EXC_ERROR THEN
103: ROLLBACK TO csf_debrief_headers_cuhk;
104: x_return_status := FND_API.G_RET_STS_ERROR;
105: FND_MSG_PUB.Count_And_Get
106: ( p_count => x_msg_count,
107: p_data => x_msg_data );
108: WHEN OTHERS THEN

Line 110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

106: ( p_count => x_msg_count,
107: p_data => x_msg_data );
108: WHEN OTHERS THEN
109: ROLLBACK TO csf_debrief_headers_cuhk;
110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
111: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
112: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
113: END IF;
114: FND_MSG_PUB.Count_And_Get

Line 132: x_return_status := fnd_api.g_ret_sts_success;

128: l_api_name varchar2(200) := 'Create_debrief_header_Pre' ;
129: BEGIN
130: Savepoint csf_debrief_headers_cuhk;
131:
132: x_return_status := fnd_api.g_ret_sts_success;
133: NULL;
134: -- Standard call to get message count and if count is 1, get message info
135: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
136: p_data => x_msg_data );

Line 139: WHEN FND_API.G_EXC_ERROR THEN

135: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
136: p_data => x_msg_data );
137:
138: EXCEPTION
139: WHEN FND_API.G_EXC_ERROR THEN
140: ROLLBACK TO csf_debrief_headers_cuhk;
141: x_return_status := FND_API.G_RET_STS_ERROR;
142: FND_MSG_PUB.Count_And_Get
143: ( p_count => x_msg_count,

Line 141: x_return_status := FND_API.G_RET_STS_ERROR;

137:
138: EXCEPTION
139: WHEN FND_API.G_EXC_ERROR THEN
140: ROLLBACK TO csf_debrief_headers_cuhk;
141: x_return_status := FND_API.G_RET_STS_ERROR;
142: FND_MSG_PUB.Count_And_Get
143: ( p_count => x_msg_count,
144: p_data => x_msg_data );
145: WHEN OTHERS THEN

Line 147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

143: ( p_count => x_msg_count,
144: p_data => x_msg_data );
145: WHEN OTHERS THEN
146: ROLLBACK TO csf_debrief_headers_cuhk;
147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
148: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
149: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
150: END IF;
151: FND_MSG_PUB.Count_And_Get

Line 168: x_return_status := fnd_api.g_ret_sts_success;

164: l_api_name varchar2(200) := 'Create_debrief_header_Pre' ;
165: BEGIN
166: Savepoint csf_debrief_headers_cuhk;
167:
168: x_return_status := fnd_api.g_ret_sts_success;
169: NULL;
170: -- Standard call to get message count and if count is 1, get message info
171: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
172: p_data => x_msg_data );

Line 175: WHEN FND_API.G_EXC_ERROR THEN

171: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
172: p_data => x_msg_data );
173:
174: EXCEPTION
175: WHEN FND_API.G_EXC_ERROR THEN
176: ROLLBACK TO csf_debrief_headers_cuhk;
177: x_return_status := FND_API.G_RET_STS_ERROR;
178: FND_MSG_PUB.Count_And_Get
179: ( p_count => x_msg_count,

Line 177: x_return_status := FND_API.G_RET_STS_ERROR;

173:
174: EXCEPTION
175: WHEN FND_API.G_EXC_ERROR THEN
176: ROLLBACK TO csf_debrief_headers_cuhk;
177: x_return_status := FND_API.G_RET_STS_ERROR;
178: FND_MSG_PUB.Count_And_Get
179: ( p_count => x_msg_count,
180: p_data => x_msg_data );
181: WHEN OTHERS THEN

Line 183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

179: ( p_count => x_msg_count,
180: p_data => x_msg_data );
181: WHEN OTHERS THEN
182: ROLLBACK TO csf_debrief_headers_cuhk;
183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
184: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
185: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
186: END IF;
187: FND_MSG_PUB.Count_And_Get

Line 204: x_return_status := fnd_api.g_ret_sts_success;

200: l_api_name varchar2(200) := 'Create_debrief_header_Pre' ;
201: BEGIN
202: Savepoint csf_debrief_headers_cuhk;
203:
204: x_return_status := fnd_api.g_ret_sts_success;
205: NULL;
206: -- Standard call to get message count and if count is 1, get message info
207: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
208: p_data => x_msg_data );

Line 211: WHEN FND_API.G_EXC_ERROR THEN

207: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
208: p_data => x_msg_data );
209:
210: EXCEPTION
211: WHEN FND_API.G_EXC_ERROR THEN
212: ROLLBACK TO csf_debrief_headers_cuhk;
213: x_return_status := FND_API.G_RET_STS_ERROR;
214: FND_MSG_PUB.Count_And_Get
215: ( p_count => x_msg_count,

Line 213: x_return_status := FND_API.G_RET_STS_ERROR;

209:
210: EXCEPTION
211: WHEN FND_API.G_EXC_ERROR THEN
212: ROLLBACK TO csf_debrief_headers_cuhk;
213: x_return_status := FND_API.G_RET_STS_ERROR;
214: FND_MSG_PUB.Count_And_Get
215: ( p_count => x_msg_count,
216: p_data => x_msg_data );
217: WHEN OTHERS THEN

Line 219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

215: ( p_count => x_msg_count,
216: p_data => x_msg_data );
217: WHEN OTHERS THEN
218: ROLLBACK TO csf_debrief_headers_cuhk;
219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
220: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
221: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
222: END IF;
223: FND_MSG_PUB.Count_And_Get