DBA Data[Home] [Help]

APPS.CSP_REQUIREMENT_HEADERS_CUHK dependencies on FND_MSG_PUB

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

20:
21: x_return_status := fnd_api.g_ret_sts_success;
22: NULL;
23: -- Standard call to get message count and if count is 1, get message info
24: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
25: p_data => x_msg_data );
26:
27: EXCEPTION
28: WHEN FND_API.G_EXC_ERROR THEN

Line 31: FND_MSG_PUB.Count_And_Get

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

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

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

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

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

Line 40: FND_MSG_PUB.Count_And_Get

36: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
37: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
38: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
39: END IF;
40: FND_MSG_PUB.Count_And_Get
41: ( p_count => x_msg_count,
42: p_data => x_msg_data
43: );
44:

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 csp_requirement_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 csp_requirement_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 csp_requirement_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 csp_requirement_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 100: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

96:
97: x_return_status := fnd_api.g_ret_sts_success;
98: NULL;
99: -- Standard call to get message count and if count is 1, get message info
100: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
101: p_data => x_msg_data );
102:
103: EXCEPTION
104: WHEN FND_API.G_EXC_ERROR THEN

Line 107: FND_MSG_PUB.Count_And_Get

103: EXCEPTION
104: WHEN FND_API.G_EXC_ERROR THEN
105: ROLLBACK TO csp_requirement_headers_cuhk;
106: x_return_status := FND_API.G_RET_STS_ERROR;
107: FND_MSG_PUB.Count_And_Get
108: ( p_count => x_msg_count,
109: p_data => x_msg_data );
110: WHEN OTHERS THEN
111: ROLLBACK TO csp_requirement_headers_cuhk;

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

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

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

110: WHEN OTHERS THEN
111: ROLLBACK TO csp_requirement_headers_cuhk;
112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
113: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
114: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
115: END IF;
116: FND_MSG_PUB.Count_And_Get
117: ( p_count => x_msg_count,
118: p_data => x_msg_data

Line 116: FND_MSG_PUB.Count_And_Get

112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
113: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
114: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
115: END IF;
116: FND_MSG_PUB.Count_And_Get
117: ( p_count => x_msg_count,
118: p_data => x_msg_data
119: );
120:

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

133:
134: x_return_status := fnd_api.g_ret_sts_success;
135: NULL;
136: -- Standard call to get message count and if count is 1, get message info
137: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
138: p_data => x_msg_data );
139:
140: EXCEPTION
141: WHEN FND_API.G_EXC_ERROR THEN

Line 144: FND_MSG_PUB.Count_And_Get

140: EXCEPTION
141: WHEN FND_API.G_EXC_ERROR THEN
142: ROLLBACK TO csp_requirement_headers_cuhk;
143: x_return_status := FND_API.G_RET_STS_ERROR;
144: FND_MSG_PUB.Count_And_Get
145: ( p_count => x_msg_count,
146: p_data => x_msg_data );
147: WHEN OTHERS THEN
148: ROLLBACK TO csp_requirement_headers_cuhk;

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

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

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

147: WHEN OTHERS THEN
148: ROLLBACK TO csp_requirement_headers_cuhk;
149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
150: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
151: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
152: END IF;
153: FND_MSG_PUB.Count_And_Get
154: ( p_count => x_msg_count,
155: p_data => x_msg_data

Line 153: FND_MSG_PUB.Count_And_Get

149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
150: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
151: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
152: END IF;
153: FND_MSG_PUB.Count_And_Get
154: ( p_count => x_msg_count,
155: p_data => x_msg_data
156: );
157:

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

169:
170: x_return_status := fnd_api.g_ret_sts_success;
171: NULL;
172: -- Standard call to get message count and if count is 1, get message info
173: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
174: p_data => x_msg_data );
175:
176: EXCEPTION
177: WHEN FND_API.G_EXC_ERROR THEN

Line 180: FND_MSG_PUB.Count_And_Get

176: EXCEPTION
177: WHEN FND_API.G_EXC_ERROR THEN
178: ROLLBACK TO csp_requirement_headers_cuhk;
179: x_return_status := FND_API.G_RET_STS_ERROR;
180: FND_MSG_PUB.Count_And_Get
181: ( p_count => x_msg_count,
182: p_data => x_msg_data );
183: WHEN OTHERS THEN
184: ROLLBACK TO csp_requirement_headers_cuhk;

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

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

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

183: WHEN OTHERS THEN
184: ROLLBACK TO csp_requirement_headers_cuhk;
185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
186: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
187: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
188: END IF;
189: FND_MSG_PUB.Count_And_Get
190: ( p_count => x_msg_count,
191: p_data => x_msg_data

Line 189: FND_MSG_PUB.Count_And_Get

185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
186: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
187: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
188: END IF;
189: FND_MSG_PUB.Count_And_Get
190: ( p_count => x_msg_count,
191: p_data => x_msg_data
192: );
193:

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

205:
206: x_return_status := fnd_api.g_ret_sts_success;
207: NULL;
208: -- Standard call to get message count and if count is 1, get message info
209: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
210: p_data => x_msg_data );
211:
212: EXCEPTION
213: WHEN FND_API.G_EXC_ERROR THEN

Line 216: FND_MSG_PUB.Count_And_Get

212: EXCEPTION
213: WHEN FND_API.G_EXC_ERROR THEN
214: ROLLBACK TO csp_requirement_headers_cuhk;
215: x_return_status := FND_API.G_RET_STS_ERROR;
216: FND_MSG_PUB.Count_And_Get
217: ( p_count => x_msg_count,
218: p_data => x_msg_data );
219: WHEN OTHERS THEN
220: ROLLBACK TO csp_requirement_headers_cuhk;

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

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

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

219: WHEN OTHERS THEN
220: ROLLBACK TO csp_requirement_headers_cuhk;
221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
222: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
223: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
224: END IF;
225: FND_MSG_PUB.Count_And_Get
226: ( p_count => x_msg_count,
227: p_data => x_msg_data

Line 225: FND_MSG_PUB.Count_And_Get

221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
222: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
223: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
224: END IF;
225: FND_MSG_PUB.Count_And_Get
226: ( p_count => x_msg_count,
227: p_data => x_msg_data
228: );
229: