eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMO_VBATCH_GRP dependencies on FND_API

Line 8: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMO_VBATCH_GRP';
5:
6: --This procdeure would instantiate the process instructions for the batch.
7: procedure INSTANTIATE_ADVANCED_PI (P_API_VERSION IN NUMBER,
8: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
9: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
10: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
11: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
12: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 9: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

5:
6: --This procdeure would instantiate the process instructions for the batch.
7: procedure INSTANTIATE_ADVANCED_PI (P_API_VERSION IN NUMBER,
8: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
9: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
10: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
11: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
12: X_MSG_COUNT OUT NOCOPY NUMBER,
13: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 10: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

6: --This procdeure would instantiate the process instructions for the batch.
7: procedure INSTANTIATE_ADVANCED_PI (P_API_VERSION IN NUMBER,
8: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
9: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
10: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
11: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
12: X_MSG_COUNT OUT NOCOPY NUMBER,
13: X_MSG_DATA OUT NOCOPY VARCHAR2,
14: P_ENTITY_NAME IN VARCHAR2,

Line 27: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN

23: -- Standard Start of API savepoint
24: SAVEPOINT INSTANTIATE_ADVANCED_PI_GRP;
25:
26: -- Standard call to check for call compatibility.
27: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN
28: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
29: END IF;
30:
31: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 28: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

24: SAVEPOINT INSTANTIATE_ADVANCED_PI_GRP;
25:
26: -- Standard call to check for call compatibility.
27: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN
28: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
29: END IF;
30:
31: -- Initialize message list if p_init_msg_list is set to TRUE.
32: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 32: IF FND_API.to_Boolean( p_init_msg_list ) THEN

28: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
29: END IF;
30:
31: -- Initialize message list if p_init_msg_list is set to TRUE.
32: IF FND_API.to_Boolean( p_init_msg_list ) THEN
33: FND_MSG_PUB.initialize;
34: END IF;
35: -- Initialize API return status to success
36: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 36: x_return_status := FND_API.G_RET_STS_SUCCESS;

32: IF FND_API.to_Boolean( p_init_msg_list ) THEN
33: FND_MSG_PUB.initialize;
34: END IF;
35: -- Initialize API return status to success
36: x_return_status := FND_API.G_RET_STS_SUCCESS;
37:
38:
39: GMO_VBATCH_PVT.INSTANTIATE_ADVANCED_PI
40: (

Line 48: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

44: X_MSG_COUNT => X_MSG_COUNT,
45: X_MSG_DATA => X_MSG_DATA
46: );
47:
48: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
49: IF FND_API.To_Boolean( p_commit ) THEN
50: COMMIT ;
51: END IF;
52: ELSE

Line 49: IF FND_API.To_Boolean( p_commit ) THEN

45: X_MSG_DATA => X_MSG_DATA
46: );
47:
48: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
49: IF FND_API.To_Boolean( p_commit ) THEN
50: COMMIT ;
51: END IF;
52: ELSE
53: RAISE FND_API.G_EXC_ERROR;

Line 53: RAISE FND_API.G_EXC_ERROR;

49: IF FND_API.To_Boolean( p_commit ) THEN
50: COMMIT ;
51: END IF;
52: ELSE
53: RAISE FND_API.G_EXC_ERROR;
54: END IF;
55:
56: -- Standard call to get message count and if count is 1, get message info.
57: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

Line 60: WHEN FND_API.G_EXC_ERROR THEN

56: -- Standard call to get message count and if count is 1, get message info.
57: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
58:
59: EXCEPTION
60: WHEN FND_API.G_EXC_ERROR THEN
61: ROLLBACK TO INSTANTIATE_ADVANCED_PI_GRP;
62: x_return_status := FND_API.G_RET_STS_ERROR;
63: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
64: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 62: x_return_status := FND_API.G_RET_STS_ERROR;

58:
59: EXCEPTION
60: WHEN FND_API.G_EXC_ERROR THEN
61: ROLLBACK TO INSTANTIATE_ADVANCED_PI_GRP;
62: x_return_status := FND_API.G_RET_STS_ERROR;
63: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
64: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
65: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_grp.instantiate_advanced_pi', FALSE);
66: end if;

Line 67: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

63: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
64: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
65: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_grp.instantiate_advanced_pi', FALSE);
66: end if;
67: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
68: ROLLBACK TO INSTANTIATE_ADVANCED_PI_GRP;
69: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
70: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
71: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 69: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

65: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_grp.instantiate_advanced_pi', FALSE);
66: end if;
67: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
68: ROLLBACK TO INSTANTIATE_ADVANCED_PI_GRP;
69: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
70: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
71: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
72: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_grp.instantiate_advanced_pi', FALSE);
73: end if;

Line 76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

72: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_grp.instantiate_advanced_pi', FALSE);
73: end if;
74: WHEN OTHERS THEN
75: ROLLBACK TO INSTANTIATE_ADVANCED_PI_GRP;
76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
77: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
78: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
79: END IF;
80: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

Line 90: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

86:
87: --This procdeure would get the context information for the task.
88:
89: procedure ON_TASK_LOAD (P_API_VERSION IN NUMBER,
90: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
91: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
92: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
93: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
94: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 91: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

87: --This procdeure would get the context information for the task.
88:
89: procedure ON_TASK_LOAD (P_API_VERSION IN NUMBER,
90: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
91: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
92: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
93: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
94: X_MSG_COUNT OUT NOCOPY NUMBER,
95: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 92: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

88:
89: procedure ON_TASK_LOAD (P_API_VERSION IN NUMBER,
90: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
91: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
92: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
93: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
94: X_MSG_COUNT OUT NOCOPY NUMBER,
95: X_MSG_DATA OUT NOCOPY VARCHAR2,
96: P_FROM_MODULE IN VARCHAR2,

Line 119: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN

115:
116:
117: BEGIN
118: -- Standard call to check for call compatibility.
119: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN
120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
121: END IF;
122:
123: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

116:
117: BEGIN
118: -- Standard call to check for call compatibility.
119: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN
120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
121: END IF;
122:
123: -- Initialize message list if p_init_msg_list is set to TRUE.
124: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 124: IF FND_API.to_Boolean( p_init_msg_list ) THEN

120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
121: END IF;
122:
123: -- Initialize message list if p_init_msg_list is set to TRUE.
124: IF FND_API.to_Boolean( p_init_msg_list ) THEN
125: FND_MSG_PUB.initialize;
126: END IF;
127: -- Initialize API return status to success
128: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 128: x_return_status := FND_API.G_RET_STS_SUCCESS;

124: IF FND_API.to_Boolean( p_init_msg_list ) THEN
125: FND_MSG_PUB.initialize;
126: END IF;
127: -- Initialize API return status to success
128: x_return_status := FND_API.G_RET_STS_SUCCESS;
129:
130: GMO_VBATCH_PVT.ON_TASK_LOAD
131: (
132: P_FROM_MODULE => P_FROM_MODULE,

Line 152: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

148: X_MSG_COUNT => X_MSG_COUNT,
149: X_MSG_DATA => X_MSG_DATA
150: );
151:
152: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
153: IF FND_API.To_Boolean( p_commit ) THEN
154: COMMIT ;
155: END IF;
156: ELSE

Line 153: IF FND_API.To_Boolean( p_commit ) THEN

149: X_MSG_DATA => X_MSG_DATA
150: );
151:
152: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
153: IF FND_API.To_Boolean( p_commit ) THEN
154: COMMIT ;
155: END IF;
156: ELSE
157: RAISE FND_API.G_EXC_ERROR;

Line 157: RAISE FND_API.G_EXC_ERROR;

153: IF FND_API.To_Boolean( p_commit ) THEN
154: COMMIT ;
155: END IF;
156: ELSE
157: RAISE FND_API.G_EXC_ERROR;
158: END IF;
159:
160: -- Standard call to get message count and if count is 1, get message info.
161: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

Line 164: WHEN FND_API.G_EXC_ERROR THEN

160: -- Standard call to get message count and if count is 1, get message info.
161: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
162:
163: EXCEPTION
164: WHEN FND_API.G_EXC_ERROR THEN
165: x_return_status := FND_API.G_RET_STS_ERROR;
166: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
167: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
168: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_grp.on_task_load', FALSE);

Line 165: x_return_status := FND_API.G_RET_STS_ERROR;

161: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
162:
163: EXCEPTION
164: WHEN FND_API.G_EXC_ERROR THEN
165: x_return_status := FND_API.G_RET_STS_ERROR;
166: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
167: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
168: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_grp.on_task_load', FALSE);
169: end if;

Line 170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

166: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
167: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
168: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_grp.on_task_load', FALSE);
169: end if;
170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
172: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
173: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
174: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_grp.on_task_load', FALSE);

Line 171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

167: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
168: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_grp.on_task_load', FALSE);
169: end if;
170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
172: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
173: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
174: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_grp.on_task_load', FALSE);
175: end if;

Line 177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

173: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
174: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_grp.on_task_load', FALSE);
175: end if;
176: WHEN OTHERS THEN
177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
178: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
179: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
180: END IF;
181: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

Line 194: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

190:
191: --This procdeure would process the action performed by the task.
192:
193: procedure ON_TASK_ACTION (P_API_VERSION IN NUMBER,
194: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
195: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
196: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
197: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
198: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 195: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

191: --This procdeure would process the action performed by the task.
192:
193: procedure ON_TASK_ACTION (P_API_VERSION IN NUMBER,
194: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
195: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
196: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
197: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
198: X_MSG_COUNT OUT NOCOPY NUMBER,
199: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 196: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

192:
193: procedure ON_TASK_ACTION (P_API_VERSION IN NUMBER,
194: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
195: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
196: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
197: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
198: X_MSG_COUNT OUT NOCOPY NUMBER,
199: X_MSG_DATA OUT NOCOPY VARCHAR2,
200: P_ENTITY_NAME IN VARCHAR2,

Line 212: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN

208: l_api_version CONSTANT NUMBER := 1.0;
209:
210: BEGIN
211: -- Standard call to check for call compatibility.
212: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN
213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
214: END IF;
215:
216: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

209:
210: BEGIN
211: -- Standard call to check for call compatibility.
212: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN
213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
214: END IF;
215:
216: -- Initialize message list if p_init_msg_list is set to TRUE.
217: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 217: IF FND_API.to_Boolean( p_init_msg_list ) THEN

213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
214: END IF;
215:
216: -- Initialize message list if p_init_msg_list is set to TRUE.
217: IF FND_API.to_Boolean( p_init_msg_list ) THEN
218: FND_MSG_PUB.initialize;
219: END IF;
220: -- Initialize API return status to success
221: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 221: x_return_status := FND_API.G_RET_STS_SUCCESS;

217: IF FND_API.to_Boolean( p_init_msg_list ) THEN
218: FND_MSG_PUB.initialize;
219: END IF;
220: -- Initialize API return status to success
221: x_return_status := FND_API.G_RET_STS_SUCCESS;
222:
223: GMO_VBATCH_PVT.ON_TASK_ACTION
224: (
225: P_ENTITY_NAME => P_ENTITY_NAME,

Line 236: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

232: X_MSG_DATA => X_MSG_DATA
233:
234: );
235:
236: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
237: IF FND_API.To_Boolean( p_commit ) THEN
238: COMMIT ;
239: END IF;
240: ELSE

Line 237: IF FND_API.To_Boolean( p_commit ) THEN

233:
234: );
235:
236: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
237: IF FND_API.To_Boolean( p_commit ) THEN
238: COMMIT ;
239: END IF;
240: ELSE
241: RAISE FND_API.G_EXC_ERROR;

Line 241: RAISE FND_API.G_EXC_ERROR;

237: IF FND_API.To_Boolean( p_commit ) THEN
238: COMMIT ;
239: END IF;
240: ELSE
241: RAISE FND_API.G_EXC_ERROR;
242: END IF;
243:
244: -- Standard call to get message count and if count is 1, get message info.
245: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

Line 248: WHEN FND_API.G_EXC_ERROR THEN

244: -- Standard call to get message count and if count is 1, get message info.
245: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
246:
247: EXCEPTION
248: WHEN FND_API.G_EXC_ERROR THEN
249: x_return_status := FND_API.G_RET_STS_ERROR;
250: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
251: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
252: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_grp.on_task_action', FALSE);

Line 249: x_return_status := FND_API.G_RET_STS_ERROR;

245: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
246:
247: EXCEPTION
248: WHEN FND_API.G_EXC_ERROR THEN
249: x_return_status := FND_API.G_RET_STS_ERROR;
250: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
251: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
252: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_grp.on_task_action', FALSE);
253: end if;

Line 254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

250: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
251: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
252: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_grp.on_task_action', FALSE);
253: end if;
254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
256: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
257: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
258: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_grp.on_task_action', FALSE);

Line 255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

251: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
252: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_grp.on_task_action', FALSE);
253: end if;
254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
256: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
257: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
258: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_grp.on_task_action', FALSE);
259: end if;

Line 261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

257: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
258: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_grp.on_task_action', FALSE);
259: end if;
260: WHEN OTHERS THEN
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
262: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
263: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
264: END IF;
265: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

Line 276: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

272:
273: --This procdeure would process the save event of the task.
274:
275: procedure ON_TASK_SAVE (P_API_VERSION IN NUMBER,
276: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
277: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
278: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
279: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
280: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 277: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

273: --This procdeure would process the save event of the task.
274:
275: procedure ON_TASK_SAVE (P_API_VERSION IN NUMBER,
276: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
277: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
278: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
279: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
280: X_MSG_COUNT OUT NOCOPY NUMBER,
281: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 278: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

274:
275: procedure ON_TASK_SAVE (P_API_VERSION IN NUMBER,
276: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
277: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
278: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
279: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
280: X_MSG_COUNT OUT NOCOPY NUMBER,
281: X_MSG_DATA OUT NOCOPY VARCHAR2,
282: P_FROM_MODULE IN VARCHAR2,

Line 303: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN

299: l_task_erecord fnd_table_of_varchar2_255;
300:
301: BEGIN
302: -- Standard call to check for call compatibility.
303: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN
304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
305: END IF;
306:
307: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

300:
301: BEGIN
302: -- Standard call to check for call compatibility.
303: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN
304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
305: END IF;
306:
307: -- Initialize message list if p_init_msg_list is set to TRUE.
308: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 308: IF FND_API.to_Boolean( p_init_msg_list ) THEN

304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
305: END IF;
306:
307: -- Initialize message list if p_init_msg_list is set to TRUE.
308: IF FND_API.to_Boolean( p_init_msg_list ) THEN
309: FND_MSG_PUB.initialize;
310: END IF;
311: -- Initialize API return status to success
312: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 312: x_return_status := FND_API.G_RET_STS_SUCCESS;

308: IF FND_API.to_Boolean( p_init_msg_list ) THEN
309: FND_MSG_PUB.initialize;
310: END IF;
311: -- Initialize API return status to success
312: x_return_status := FND_API.G_RET_STS_SUCCESS;
313:
314: l_task_identifier := FND_TABLE_OF_VARCHAR2_255();
315: l_task_value := FND_TABLE_OF_VARCHAR2_255();
316: l_task_erecord := FND_TABLE_OF_VARCHAR2_255();

Line 351: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

347: X_MSG_COUNT => X_MSG_COUNT,
348: X_MSG_DATA => X_MSG_DATA
349: );
350:
351: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
352: IF FND_API.To_Boolean( p_commit ) THEN
353: COMMIT ;
354: END IF;
355: ELSE

Line 352: IF FND_API.To_Boolean( p_commit ) THEN

348: X_MSG_DATA => X_MSG_DATA
349: );
350:
351: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
352: IF FND_API.To_Boolean( p_commit ) THEN
353: COMMIT ;
354: END IF;
355: ELSE
356: RAISE FND_API.G_EXC_ERROR;

Line 356: RAISE FND_API.G_EXC_ERROR;

352: IF FND_API.To_Boolean( p_commit ) THEN
353: COMMIT ;
354: END IF;
355: ELSE
356: RAISE FND_API.G_EXC_ERROR;
357: END IF;
358:
359:
360: -- Standard call to get message count and if count is 1, get message info.

Line 364: WHEN FND_API.G_EXC_ERROR THEN

360: -- Standard call to get message count and if count is 1, get message info.
361: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
362:
363: EXCEPTION
364: WHEN FND_API.G_EXC_ERROR THEN
365: x_return_status := FND_API.G_RET_STS_ERROR;
366: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
367: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
368: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_grp.on_task_save', FALSE);

Line 365: x_return_status := FND_API.G_RET_STS_ERROR;

361: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
362:
363: EXCEPTION
364: WHEN FND_API.G_EXC_ERROR THEN
365: x_return_status := FND_API.G_RET_STS_ERROR;
366: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
367: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
368: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_grp.on_task_save', FALSE);
369: end if;

Line 370: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

366: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
367: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
368: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_grp.on_task_save', FALSE);
369: end if;
370: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
372: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
373: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
374: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_grp.on_task_save', FALSE);

Line 371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

367: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
368: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_grp.on_task_save', FALSE);
369: end if;
370: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
372: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
373: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
374: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_grp.on_task_save', FALSE);
375: end if;

Line 377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

373: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
374: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_grp.on_task_save', FALSE);
375: end if;
376: WHEN OTHERS THEN
377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
378: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
379: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
380: END IF;
381: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

Line 392: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

388:
389: --This procdeure would check if the step is locked or not
390:
391: procedure GET_ENTITY_LOCK_STATUS (P_API_VERSION IN NUMBER,
392: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
393: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
394: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
395: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
396: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 393: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

389: --This procdeure would check if the step is locked or not
390:
391: procedure GET_ENTITY_LOCK_STATUS (P_API_VERSION IN NUMBER,
392: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
393: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
394: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
395: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
396: X_MSG_COUNT OUT NOCOPY NUMBER,
397: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 394: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

390:
391: procedure GET_ENTITY_LOCK_STATUS (P_API_VERSION IN NUMBER,
392: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
393: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
394: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
395: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
396: X_MSG_COUNT OUT NOCOPY NUMBER,
397: X_MSG_DATA OUT NOCOPY VARCHAR2,
398: P_ENTITY_NAME IN VARCHAR2,

Line 412: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN

408: l_api_version CONSTANT NUMBER := 1.0;
409:
410: BEGIN
411: -- Standard call to check for call compatibility.
412: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN
413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
414: END IF;
415:
416: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

409:
410: BEGIN
411: -- Standard call to check for call compatibility.
412: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN
413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
414: END IF;
415:
416: -- Initialize message list if p_init_msg_list is set to TRUE.
417: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 417: IF FND_API.to_Boolean( p_init_msg_list ) THEN

413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
414: END IF;
415:
416: -- Initialize message list if p_init_msg_list is set to TRUE.
417: IF FND_API.to_Boolean( p_init_msg_list ) THEN
418: FND_MSG_PUB.initialize;
419: END IF;
420: -- Initialize API return status to success
421: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 421: x_return_status := FND_API.G_RET_STS_SUCCESS;

417: IF FND_API.to_Boolean( p_init_msg_list ) THEN
418: FND_MSG_PUB.initialize;
419: END IF;
420: -- Initialize API return status to success
421: x_return_status := FND_API.G_RET_STS_SUCCESS;
422:
423: GMO_VBATCH_PVT.GET_ENTITY_LOCK_STATUS
424: (
425: P_ENTITY_NAME => P_ENTITY_NAME,

Line 436: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

432: X_MSG_COUNT => X_MSG_COUNT,
433: X_MSG_DATA => X_MSG_DATA
434: );
435:
436: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
437: IF FND_API.To_Boolean( p_commit ) THEN
438: COMMIT ;
439: END IF;
440: ELSE

Line 437: IF FND_API.To_Boolean( p_commit ) THEN

433: X_MSG_DATA => X_MSG_DATA
434: );
435:
436: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
437: IF FND_API.To_Boolean( p_commit ) THEN
438: COMMIT ;
439: END IF;
440: ELSE
441: RAISE FND_API.G_EXC_ERROR;

Line 441: RAISE FND_API.G_EXC_ERROR;

437: IF FND_API.To_Boolean( p_commit ) THEN
438: COMMIT ;
439: END IF;
440: ELSE
441: RAISE FND_API.G_EXC_ERROR;
442: END IF;
443:
444: -- Standard call to get message count and if count is 1, get message info.
445: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

Line 448: WHEN FND_API.G_EXC_ERROR THEN

444: -- Standard call to get message count and if count is 1, get message info.
445: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
446:
447: EXCEPTION
448: WHEN FND_API.G_EXC_ERROR THEN
449: x_return_status := FND_API.G_RET_STS_ERROR;
450: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
451: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
452: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_grp.get_entity_lock_status', FALSE);

Line 449: x_return_status := FND_API.G_RET_STS_ERROR;

445: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
446:
447: EXCEPTION
448: WHEN FND_API.G_EXC_ERROR THEN
449: x_return_status := FND_API.G_RET_STS_ERROR;
450: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
451: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
452: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_grp.get_entity_lock_status', FALSE);
453: end if;

Line 454: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

450: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
451: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
452: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_grp.get_entity_lock_status', FALSE);
453: end if;
454: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
456: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
457: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
458: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_grp.get_entity_lock_status', FALSE);

Line 455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

451: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
452: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_grp.get_entity_lock_status', FALSE);
453: end if;
454: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
456: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
457: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
458: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_grp.get_entity_lock_status', FALSE);
459: end if;

Line 461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

457: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
458: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_grp.get_entity_lock_status', FALSE);
459: end if;
460: WHEN OTHERS THEN
461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
462: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
463: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
464: END IF;
465: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);