DBA Data[Home] [Help]

APPS.IES_DEPL_SCRIPT_PKG dependencies on FND_MSG_PUB

Line 60: FND_MSG_PUB.initialize;

56: END IF;
57:
58: -- initialize message list if p_init_msg_list is set to TRUE
59: IF FND_API.To_Boolean( p_init_msg_list ) THEN
60: FND_MSG_PUB.initialize;
61: END IF;
62:
63: -- Initialize the API return status to success
64: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 73: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

69: 'WHERE DSCRIPT_ID = :dscriptId' USING p_dscript_id;
70:
71: EXCEPTION
72: WHEN OTHERS THEN
73: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
74: THEN
75: FND_MESSAGE.SET_NAME('IES', 'IES_DSCRIPT_LOCK_ERROR');
76: FND_MSG_PUB.Add;
77: END IF;

Line 76: FND_MSG_PUB.Add;

72: WHEN OTHERS THEN
73: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
74: THEN
75: FND_MESSAGE.SET_NAME('IES', 'IES_DSCRIPT_LOCK_ERROR');
76: FND_MSG_PUB.Add;
77: END IF;
78:
79: RAISE FND_API.G_EXC_ERROR;
80: END;

Line 83: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

79: RAISE FND_API.G_EXC_ERROR;
80: END;
81:
82: -- Signify Success
83: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
84: THEN
85: FND_MESSAGE.SET_NAME('IES', 'IES_DSCRIPT_LOCK_SUCCESS');
86: FND_MSG_PUB.Add;
87: END IF;

Line 86: FND_MSG_PUB.Add;

82: -- Signify Success
83: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
84: THEN
85: FND_MESSAGE.SET_NAME('IES', 'IES_DSCRIPT_LOCK_SUCCESS');
86: FND_MSG_PUB.Add;
87: END IF;
88:
89: -- End of API body
90:

Line 97: FND_MSG_PUB.Count_And_Get

93: COMMIT WORK;
94: END IF;
95:
96: -- Standard call to get message count and if count is 1, get message info
97: FND_MSG_PUB.Count_And_Get
98: ( p_encoded => l_encoded,
99: p_count => x_msg_count,
100: p_data => x_msg_data
101: );

Line 108: FND_MSG_PUB.Count_And_Get

104: WHEN FND_API.G_EXC_ERROR THEN
105: ROLLBACK TO lock_deployed_script_sp;
106: x_return_status := FND_API.G_RET_STS_ERROR;
107:
108: FND_MSG_PUB.Count_And_Get
109: ( p_encoded => l_encoded,
110: p_count => x_msg_count,
111: p_data => x_msg_data
112: );

Line 118: FND_MSG_PUB.Count_And_Get

114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
115: ROLLBACK TO lock_deployed_script_sp;
116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
117:
118: FND_MSG_PUB.Count_And_Get
119: ( p_encoded => l_encoded,
120: p_count => x_msg_count,
121: p_data => x_msg_data
122: );

Line 128: IF FND_MSG_PUB.Check_Msg_Level

124: WHEN OTHERS THEN
125: ROLLBACK TO lock_deployed_script_sp;
126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
127:
128: IF FND_MSG_PUB.Check_Msg_Level
129: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
130: THEN
131: FND_MSG_PUB.Add_Exc_Msg
132: ( p_pkg_name => G_PKG_NAME,

Line 129: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

125: ROLLBACK TO lock_deployed_script_sp;
126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
127:
128: IF FND_MSG_PUB.Check_Msg_Level
129: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
130: THEN
131: FND_MSG_PUB.Add_Exc_Msg
132: ( p_pkg_name => G_PKG_NAME,
133: p_procedure_name => l_api_name,

Line 131: FND_MSG_PUB.Add_Exc_Msg

127:
128: IF FND_MSG_PUB.Check_Msg_Level
129: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
130: THEN
131: FND_MSG_PUB.Add_Exc_Msg
132: ( p_pkg_name => G_PKG_NAME,
133: p_procedure_name => l_api_name,
134: p_error_text => 'G_MSG_LVL_UNEXP_ERROR'
135: );

Line 137: FND_MSG_PUB.Count_And_Get

133: p_procedure_name => l_api_name,
134: p_error_text => 'G_MSG_LVL_UNEXP_ERROR'
135: );
136: END IF;
137: FND_MSG_PUB.Count_And_Get
138: ( p_encoded => l_encoded,
139: p_count => x_msg_count,
140: p_data => x_msg_data
141: );

Line 176: FND_MSG_PUB.initialize;

172: END IF;
173:
174: -- initialize message list if p_init_msg_list is set to TRUE
175: IF FND_API.To_Boolean( p_init_msg_list ) THEN
176: FND_MSG_PUB.initialize;
177: END IF;
178:
179: -- Initialize the API return status to success
180: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 204: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

200: x_msg_data);
201: x_dscript_id := l_dscript_id;
202: END;
203: -- Signify Success
204: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
205: THEN
206: FND_MESSAGE.SET_NAME('IES', 'IES_DSCRIPT_LOCK_SUCCESS');
207: FND_MSG_PUB.Add;
208: END IF;

Line 207: FND_MSG_PUB.Add;

203: -- Signify Success
204: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
205: THEN
206: FND_MESSAGE.SET_NAME('IES', 'IES_DSCRIPT_LOCK_SUCCESS');
207: FND_MSG_PUB.Add;
208: END IF;
209:
210:
211: -- Standard call to get message count and if count is 1, get message info

Line 212: FND_MSG_PUB.Count_And_Get

208: END IF;
209:
210:
211: -- Standard call to get message count and if count is 1, get message info
212: FND_MSG_PUB.Count_And_Get
213: ( p_encoded => l_encoded,
214: p_count => x_msg_count,
215: p_data => x_msg_data
216: );

Line 222: FND_MSG_PUB.Count_And_Get

218: WHEN NO_DATA_FOUND THEN
219: ROLLBACK TO lock_deployed_script_sp;
220: x_return_status := FND_API.G_RET_STS_ERROR;
221:
222: FND_MSG_PUB.Count_And_Get
223: ( p_encoded => l_encoded,
224: p_count => x_msg_count,
225: p_data => x_msg_data
226: );

Line 232: IF FND_MSG_PUB.Check_Msg_Level

228: WHEN OTHERS THEN
229: ROLLBACK TO lock_deployed_script_sp;
230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
231:
232: IF FND_MSG_PUB.Check_Msg_Level
233: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
234: THEN
235: FND_MSG_PUB.Add_Exc_Msg
236: ( p_pkg_name => G_PKG_NAME,

Line 233: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

229: ROLLBACK TO lock_deployed_script_sp;
230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
231:
232: IF FND_MSG_PUB.Check_Msg_Level
233: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
234: THEN
235: FND_MSG_PUB.Add_Exc_Msg
236: ( p_pkg_name => G_PKG_NAME,
237: p_procedure_name => l_api_name,

Line 235: FND_MSG_PUB.Add_Exc_Msg

231:
232: IF FND_MSG_PUB.Check_Msg_Level
233: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
234: THEN
235: FND_MSG_PUB.Add_Exc_Msg
236: ( p_pkg_name => G_PKG_NAME,
237: p_procedure_name => l_api_name,
238: p_error_text => 'G_MSG_LVL_UNEXP_ERROR'
239: );

Line 241: FND_MSG_PUB.Count_And_Get

237: p_procedure_name => l_api_name,
238: p_error_text => 'G_MSG_LVL_UNEXP_ERROR'
239: );
240: END IF;
241: FND_MSG_PUB.Count_And_Get
242: ( p_encoded => l_encoded,
243: p_count => x_msg_count,
244: p_data => x_msg_data
245: );

Line 281: FND_MSG_PUB.initialize;

277: END IF;
278:
279: -- initialize message list if p_init_msg_list is set to TRUE
280: IF FND_API.To_Boolean( p_init_msg_list ) THEN
281: FND_MSG_PUB.initialize;
282: END IF;
283:
284: -- Initialize the API return status to success
285: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 305: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

301: x_msg_data);
302: x_dscript_id := l_dscript_id;
303: END;
304: -- Signify Success
305: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
306: THEN
307: FND_MESSAGE.SET_NAME('IES', 'IES_DSCRIPT_LOCK_SUCCESS');
308: FND_MSG_PUB.Add;
309: END IF;

Line 308: FND_MSG_PUB.Add;

304: -- Signify Success
305: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
306: THEN
307: FND_MESSAGE.SET_NAME('IES', 'IES_DSCRIPT_LOCK_SUCCESS');
308: FND_MSG_PUB.Add;
309: END IF;
310:
311:
312: -- Standard call to get message count and if count is 1, get message info

Line 313: FND_MSG_PUB.Count_And_Get

309: END IF;
310:
311:
312: -- Standard call to get message count and if count is 1, get message info
313: FND_MSG_PUB.Count_And_Get
314: ( p_encoded => l_encoded,
315: p_count => x_msg_count,
316: p_data => x_msg_data
317: );

Line 324: FND_MSG_PUB.Count_And_Get

320: WHEN NO_DATA_FOUND THEN
321: ROLLBACK TO lock_deployed_script_sp;
322: x_return_status := FND_API.G_RET_STS_ERROR;
323:
324: FND_MSG_PUB.Count_And_Get
325: ( p_encoded => l_encoded,
326: p_count => x_msg_count,
327: p_data => x_msg_data
328: );

Line 333: IF FND_MSG_PUB.Check_Msg_Level

329: WHEN OTHERS THEN
330: ROLLBACK TO lock_deployed_script_sp;
331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
332:
333: IF FND_MSG_PUB.Check_Msg_Level
334: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
335: THEN
336: FND_MSG_PUB.Add_Exc_Msg
337: ( p_pkg_name => G_PKG_NAME,

Line 334: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

330: ROLLBACK TO lock_deployed_script_sp;
331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
332:
333: IF FND_MSG_PUB.Check_Msg_Level
334: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
335: THEN
336: FND_MSG_PUB.Add_Exc_Msg
337: ( p_pkg_name => G_PKG_NAME,
338: p_procedure_name => l_api_name,

Line 336: FND_MSG_PUB.Add_Exc_Msg

332:
333: IF FND_MSG_PUB.Check_Msg_Level
334: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
335: THEN
336: FND_MSG_PUB.Add_Exc_Msg
337: ( p_pkg_name => G_PKG_NAME,
338: p_procedure_name => l_api_name,
339: p_error_text => 'G_MSG_LVL_UNEXP_ERROR'
340: );

Line 342: FND_MSG_PUB.Count_And_Get

338: p_procedure_name => l_api_name,
339: p_error_text => 'G_MSG_LVL_UNEXP_ERROR'
340: );
341: END IF;
342: FND_MSG_PUB.Count_And_Get
343: ( p_encoded => l_encoded,
344: p_count => x_msg_count,
345: p_data => x_msg_data
346: );