DBA Data[Home] [Help]

APPS.CSF_DEBRIEF_HEADERS_CUHK dependencies on FND_MSG_PUB

Line 23: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

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 );
25:
26: EXCEPTION
27: WHEN FND_API.G_EXC_ERROR THEN

Line 30: FND_MSG_PUB.Count_And_Get

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
34: ROLLBACK TO csf_debrief_headers_cuhk;

Line 36: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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
40: ( p_count => x_msg_count,

Line 37: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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
40: ( p_count => x_msg_count,
41: p_data => x_msg_data

Line 39: FND_MSG_PUB.Count_And_Get

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
40: ( p_count => x_msg_count,
41: p_data => x_msg_data
42: );
43:

Line 62: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

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 );
64:
65: EXCEPTION
66: WHEN FND_API.G_EXC_ERROR THEN

Line 69: FND_MSG_PUB.Count_And_Get

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
73: ROLLBACK TO csf_debrief_headers_cuhk;

Line 75: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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
79: ( p_count => x_msg_count,

Line 76: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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
79: ( p_count => x_msg_count,
80: p_data => x_msg_data

Line 78: FND_MSG_PUB.Count_And_Get

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
79: ( p_count => x_msg_count,
80: p_data => x_msg_data
81: );
82:

Line 98: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

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 );
100:
101: EXCEPTION
102: WHEN FND_API.G_EXC_ERROR THEN

Line 105: FND_MSG_PUB.Count_And_Get

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
109: ROLLBACK TO csf_debrief_headers_cuhk;

Line 111: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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
115: ( p_count => x_msg_count,

Line 112: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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
115: ( p_count => x_msg_count,
116: p_data => x_msg_data

Line 114: FND_MSG_PUB.Count_And_Get

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
115: ( p_count => x_msg_count,
116: p_data => x_msg_data
117: );
118:

Line 135: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

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 );
137:
138: EXCEPTION
139: WHEN FND_API.G_EXC_ERROR THEN

Line 142: FND_MSG_PUB.Count_And_Get

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
146: ROLLBACK TO csf_debrief_headers_cuhk;

Line 148: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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
152: ( p_count => x_msg_count,

Line 149: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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
152: ( p_count => x_msg_count,
153: p_data => x_msg_data

Line 151: FND_MSG_PUB.Count_And_Get

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
152: ( p_count => x_msg_count,
153: p_data => x_msg_data
154: );
155:

Line 171: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

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 );
173:
174: EXCEPTION
175: WHEN FND_API.G_EXC_ERROR THEN

Line 178: FND_MSG_PUB.Count_And_Get

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
182: ROLLBACK TO csf_debrief_headers_cuhk;

Line 184: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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
188: ( p_count => x_msg_count,

Line 185: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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
188: ( p_count => x_msg_count,
189: p_data => x_msg_data

Line 187: FND_MSG_PUB.Count_And_Get

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
188: ( p_count => x_msg_count,
189: p_data => x_msg_data
190: );
191:

Line 207: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

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 );
209:
210: EXCEPTION
211: WHEN FND_API.G_EXC_ERROR THEN

Line 214: FND_MSG_PUB.Count_And_Get

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
218: ROLLBACK TO csf_debrief_headers_cuhk;

Line 220: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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
224: ( p_count => x_msg_count,

Line 221: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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
224: ( p_count => x_msg_count,
225: p_data => x_msg_data

Line 223: FND_MSG_PUB.Count_And_Get

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
224: ( p_count => x_msg_count,
225: p_data => x_msg_data
226: );
227: