DBA Data[Home] [Help]

APPS.CSP_REQUIREMENT_LINES_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_lines_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_lines_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_lines_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_lines_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 63: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

59:
60: x_return_status := fnd_api.g_ret_sts_success;
61: NULL;
62: -- Standard call to get message count and if count is 1, get message info
63: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
64: p_data => x_msg_data );
65:
66: EXCEPTION
67: WHEN FND_API.G_EXC_ERROR THEN

Line 70: FND_MSG_PUB.Count_And_Get

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

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

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

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

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

Line 79: FND_MSG_PUB.Count_And_Get

75: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
76: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
77: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
78: END IF;
79: FND_MSG_PUB.Count_And_Get
80: ( p_count => x_msg_count,
81: p_data => x_msg_data
82: );
83:

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

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

Line 110: FND_MSG_PUB.Count_And_Get

106: EXCEPTION
107: WHEN FND_API.G_EXC_ERROR THEN
108: ROLLBACK TO csp_requirement_lines_cuhk;
109: x_return_status := FND_API.G_RET_STS_ERROR;
110: FND_MSG_PUB.Count_And_Get
111: ( p_count => x_msg_count,
112: p_data => x_msg_data );
113: WHEN OTHERS THEN
114: ROLLBACK TO csp_requirement_lines_cuhk;

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

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

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

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

Line 119: FND_MSG_PUB.Count_And_Get

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

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

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

Line 147: FND_MSG_PUB.Count_And_Get

143: EXCEPTION
144: WHEN FND_API.G_EXC_ERROR THEN
145: ROLLBACK TO csp_requirement_lines_cuhk;
146: x_return_status := FND_API.G_RET_STS_ERROR;
147: FND_MSG_PUB.Count_And_Get
148: ( p_count => x_msg_count,
149: p_data => x_msg_data );
150: WHEN OTHERS THEN
151: ROLLBACK TO csp_requirement_lines_cuhk;

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

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

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

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

Line 156: FND_MSG_PUB.Count_And_Get

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

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

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

Line 183: FND_MSG_PUB.Count_And_Get

179: EXCEPTION
180: WHEN FND_API.G_EXC_ERROR THEN
181: ROLLBACK TO csp_requirement_lines_cuhk;
182: x_return_status := FND_API.G_RET_STS_ERROR;
183: FND_MSG_PUB.Count_And_Get
184: ( p_count => x_msg_count,
185: p_data => x_msg_data );
186: WHEN OTHERS THEN
187: ROLLBACK TO csp_requirement_lines_cuhk;

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

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

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

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

Line 192: FND_MSG_PUB.Count_And_Get

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

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

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

Line 219: FND_MSG_PUB.Count_And_Get

215: EXCEPTION
216: WHEN FND_API.G_EXC_ERROR THEN
217: ROLLBACK TO csp_requirement_lines_cuhk;
218: x_return_status := FND_API.G_RET_STS_ERROR;
219: FND_MSG_PUB.Count_And_Get
220: ( p_count => x_msg_count,
221: p_data => x_msg_data );
222: WHEN OTHERS THEN
223: ROLLBACK TO csp_requirement_lines_cuhk;

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

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

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

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

Line 228: FND_MSG_PUB.Count_And_Get

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