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.AHL_PC_ASSOCIATION_PVT dependencies on FND_API

Line 21: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

17: -- ATTACH_UNIT --
18: -----------------
19: PROCEDURE ATTACH_UNIT (
20: p_api_version IN NUMBER,
21: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
22: p_commit IN VARCHAR2 := FND_API.G_FALSE,
23: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
24: p_x_assos_rec IN OUT NOCOPY AHL_PC_ASSOCIATION_PUB.PC_ASSOS_REC,
25: x_return_status OUT NOCOPY VARCHAR2,

Line 22: p_commit IN VARCHAR2 := FND_API.G_FALSE,

18: -----------------
19: PROCEDURE ATTACH_UNIT (
20: p_api_version IN NUMBER,
21: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
22: p_commit IN VARCHAR2 := FND_API.G_FALSE,
23: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
24: p_x_assos_rec IN OUT NOCOPY AHL_PC_ASSOCIATION_PUB.PC_ASSOS_REC,
25: x_return_status OUT NOCOPY VARCHAR2,
26: x_msg_count OUT NOCOPY NUMBER,

Line 23: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

19: PROCEDURE ATTACH_UNIT (
20: p_api_version IN NUMBER,
21: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
22: p_commit IN VARCHAR2 := FND_API.G_FALSE,
23: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
24: p_x_assos_rec IN OUT NOCOPY AHL_PC_ASSOCIATION_PUB.PC_ASSOS_REC,
25: x_return_status OUT NOCOPY VARCHAR2,
26: x_msg_count OUT NOCOPY NUMBER,
27: x_msg_data OUT NOCOPY VARCHAR2

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

39: -- Standard start of API savepoint
40: SAVEPOINT ATTACH_UNIT_PVT;
41:
42: -- Standard call to check for call compatibility
43: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
44: THEN
45: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
46: END IF;
47:

Line 45: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

41:
42: -- Standard call to check for call compatibility
43: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
44: THEN
45: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
46: END IF;
47:
48: -- Initialize message list if p_init_msg_list is set to TRUE
49: IF FND_API.To_Boolean(p_init_msg_list)

Line 49: IF FND_API.To_Boolean(p_init_msg_list)

45: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
46: END IF;
47:
48: -- Initialize message list if p_init_msg_list is set to TRUE
49: IF FND_API.To_Boolean(p_init_msg_list)
50: THEN
51: FND_MSG_PUB.Initialize;
52: END IF;
53:

Line 55: x_return_status := FND_API.G_RET_STS_SUCCESS;

51: FND_MSG_PUB.Initialize;
52: END IF;
53:
54: -- Initialize API return status to success
55: x_return_status := FND_API.G_RET_STS_SUCCESS;
56:
57: IF G_DEBUG='Y' THEN
58: AHL_DEBUG_PUB.ENABLE_DEBUG;
59: END IF;

Line 69: RAISE FND_API.G_EXC_ERROR;

65:
66: -- Check Error Message stack.
67: x_msg_count := FND_MSG_PUB.count_msg;
68: IF x_msg_count > 0 THEN
69: RAISE FND_API.G_EXC_ERROR;
70: END IF;
71:
72: IF p_x_assos_rec.OPERATION_FLAG = G_DML_LINK
73: THEN

Line 160: RAISE FND_API.G_EXC_ERROR;

156:
157: -- Check Error Message stack.
158: x_msg_count := FND_MSG_PUB.count_msg;
159: IF x_msg_count > 0 THEN
160: RAISE FND_API.G_EXC_ERROR;
161: END IF;
162:
163: -- Standard check for p_commit
164: IF FND_API.To_Boolean (p_commit)

Line 164: IF FND_API.To_Boolean (p_commit)

160: RAISE FND_API.G_EXC_ERROR;
161: END IF;
162:
163: -- Standard check for p_commit
164: IF FND_API.To_Boolean (p_commit)
165: THEN
166: COMMIT WORK;
167: END IF;
168:

Line 172: p_encoded => fnd_api.g_false );

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

Line 175: WHEN FND_API.G_EXC_ERROR THEN

171: p_data => x_msg_data,
172: p_encoded => fnd_api.g_false );
173:
174: EXCEPTION
175: WHEN FND_API.G_EXC_ERROR THEN
176: x_return_status := FND_API.G_RET_STS_ERROR;
177: Rollback to ATTACH_UNIT_PVT;
178: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
179: p_data => x_msg_data,

Line 176: x_return_status := FND_API.G_RET_STS_ERROR;

172: p_encoded => fnd_api.g_false );
173:
174: EXCEPTION
175: WHEN FND_API.G_EXC_ERROR THEN
176: x_return_status := FND_API.G_RET_STS_ERROR;
177: Rollback to ATTACH_UNIT_PVT;
178: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
179: p_data => x_msg_data,
180: p_encoded => fnd_api.g_false );

Line 180: p_encoded => fnd_api.g_false );

176: x_return_status := FND_API.G_RET_STS_ERROR;
177: Rollback to ATTACH_UNIT_PVT;
178: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
179: p_data => x_msg_data,
180: p_encoded => fnd_api.g_false );
181:
182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
184: Rollback to ATTACH_UNIT_PVT;

Line 182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

178: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
179: p_data => x_msg_data,
180: p_encoded => fnd_api.g_false );
181:
182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
184: Rollback to ATTACH_UNIT_PVT;
185: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
186: p_data => x_msg_data,

Line 183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

179: p_data => x_msg_data,
180: p_encoded => fnd_api.g_false );
181:
182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
184: Rollback to ATTACH_UNIT_PVT;
185: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
186: p_data => x_msg_data,
187: p_encoded => fnd_api.g_false );

Line 187: p_encoded => fnd_api.g_false );

183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
184: Rollback to ATTACH_UNIT_PVT;
185: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
186: p_data => x_msg_data,
187: p_encoded => fnd_api.g_false );
188:
189: WHEN OTHERS THEN
190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
191: Rollback to ATTACH_UNIT_PVT;

Line 190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

186: p_data => x_msg_data,
187: p_encoded => fnd_api.g_false );
188:
189: WHEN OTHERS THEN
190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
191: Rollback to ATTACH_UNIT_PVT;
192: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
193: THEN
194: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

Line 200: p_encoded => fnd_api.g_false );

196: p_error_text => SUBSTR(SQLERRM,1,240) );
197: END IF;
198: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
199: p_data => x_msg_data,
200: p_encoded => fnd_api.g_false );
201:
202: END ATTACH_UNIT;
203:
204: -----------------

Line 209: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

205: -- DETACH_UNIT --
206: -----------------
207: PROCEDURE DETACH_UNIT (
208: p_api_version IN NUMBER,
209: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
210: p_commit IN VARCHAR2 := FND_API.G_FALSE,
211: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
212: p_x_assos_rec IN OUT NOCOPY AHL_PC_ASSOCIATION_PUB.PC_ASSOS_REC,
213: x_return_status OUT NOCOPY VARCHAR2,

Line 210: p_commit IN VARCHAR2 := FND_API.G_FALSE,

206: -----------------
207: PROCEDURE DETACH_UNIT (
208: p_api_version IN NUMBER,
209: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
210: p_commit IN VARCHAR2 := FND_API.G_FALSE,
211: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
212: p_x_assos_rec IN OUT NOCOPY AHL_PC_ASSOCIATION_PUB.PC_ASSOS_REC,
213: x_return_status OUT NOCOPY VARCHAR2,
214: x_msg_count OUT NOCOPY NUMBER,

Line 211: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

207: PROCEDURE DETACH_UNIT (
208: p_api_version IN NUMBER,
209: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
210: p_commit IN VARCHAR2 := FND_API.G_FALSE,
211: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
212: p_x_assos_rec IN OUT NOCOPY AHL_PC_ASSOCIATION_PUB.PC_ASSOS_REC,
213: x_return_status OUT NOCOPY VARCHAR2,
214: x_msg_count OUT NOCOPY NUMBER,
215: x_msg_data OUT NOCOPY VARCHAR2

Line 222: l_ump_attached VARCHAR2(1) := FND_API.G_FALSE;

218: l_api_name CONSTANT VARCHAR2(30) := 'ATTACH_UNIT';
219: l_api_version CONSTANT NUMBER := 1.0;
220: l_return_status VARCHAR2(1);
221:
222: l_ump_attached VARCHAR2(1) := FND_API.G_FALSE;
223: l_exist VARCHAR2(1);
224: l_is_pc_primary VARCHAR2(1) := 'N';
225:
226: CURSOR is_pc_primary (p_pc_node_id IN NUMBER)

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

234: -- Standard start of API savepoint
235: SAVEPOINT DETACH_UNIT_PVT;
236:
237: -- Standard call to check for call compatibility
238: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
239: THEN
240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
241: END IF;
242:

Line 240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

236:
237: -- Standard call to check for call compatibility
238: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
239: THEN
240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
241: END IF;
242:
243: -- Initialize message list if p_init_msg_list is set to TRUE
244: IF FND_API.To_Boolean(p_init_msg_list)

Line 244: IF FND_API.To_Boolean(p_init_msg_list)

240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
241: END IF;
242:
243: -- Initialize message list if p_init_msg_list is set to TRUE
244: IF FND_API.To_Boolean(p_init_msg_list)
245: THEN
246: FND_MSG_PUB.Initialize;
247: END IF;
248:

Line 250: x_return_status := FND_API.G_RET_STS_SUCCESS;

246: FND_MSG_PUB.Initialize;
247: END IF;
248:
249: -- Initialize API return status to success
250: x_return_status := FND_API.G_RET_STS_SUCCESS;
251:
252: IF G_DEBUG='Y' THEN
253: AHL_DEBUG_PUB.ENABLE_DEBUG;
254: END IF;

Line 261: RAISE FND_API.G_EXC_ERROR;

257:
258: -- Check Error Message stack.
259: x_msg_count := FND_MSG_PUB.count_msg;
260: IF x_msg_count > 0 THEN
261: RAISE FND_API.G_EXC_ERROR;
262: END IF;
263:
264: -- API BODY here...
265: -- Commenting for ER - Bug 278630

Line 278: -- l_ump_attached := FND_API.G_TRUE;

274: -- INTO l_exist
275: -- FROM ahl_utilization_forecast_v
276: -- WHERE unit_config_header_id = nvl(p_x_assos_rec.UNIT_ITEM_ID,FND_PROFILE.VALUE('ORG_ID'));
277:
278: -- l_ump_attached := FND_API.G_TRUE;
279:
280: -- EXCEPTION
281: -- WHEN NO_DATA_FOUND THEN
282: -- l_ump_attached := FND_API.G_FALSE;

Line 282: -- l_ump_attached := FND_API.G_FALSE;

278: -- l_ump_attached := FND_API.G_TRUE;
279:
280: -- EXCEPTION
281: -- WHEN NO_DATA_FOUND THEN
282: -- l_ump_attached := FND_API.G_FALSE;
283: -- WHEN OTHERS THEN
284: -- l_ump_attached := FND_API.G_FALSE;
285:
286: -- END;

Line 284: -- l_ump_attached := FND_API.G_FALSE;

280: -- EXCEPTION
281: -- WHEN NO_DATA_FOUND THEN
282: -- l_ump_attached := FND_API.G_FALSE;
283: -- WHEN OTHERS THEN
284: -- l_ump_attached := FND_API.G_FALSE;
285:
286: -- END;
287: --END IF;
288:

Line 289: IF (l_ump_attached = FND_API.G_FALSE)

285:
286: -- END;
287: --END IF;
288:
289: IF (l_ump_attached = FND_API.G_FALSE)
290: THEN
291: -- Knocking off units...
292: DELETE FROM AHL_PC_ASSOCIATIONS
293: WHERE PC_ASSOCIATION_ID = p_x_assos_rec.PC_ASSOCIATION_ID;

Line 312: RAISE FND_API.G_EXC_ERROR;

308:
309: -- Check Error Message stack.
310: x_msg_count := FND_MSG_PUB.count_msg;
311: IF x_msg_count > 0 THEN
312: RAISE FND_API.G_EXC_ERROR;
313: END IF;
314:
315: -- Standard check for p_commit
316: IF FND_API.To_Boolean (p_commit)

Line 316: IF FND_API.To_Boolean (p_commit)

312: RAISE FND_API.G_EXC_ERROR;
313: END IF;
314:
315: -- Standard check for p_commit
316: IF FND_API.To_Boolean (p_commit)
317: THEN
318: COMMIT WORK;
319: END IF;
320:

Line 324: p_encoded => fnd_api.g_false );

320:
321: -- Standard call to get message count and if count is 1, get message info
322: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
323: p_data => x_msg_data,
324: p_encoded => fnd_api.g_false );
325:
326: EXCEPTION
327: WHEN FND_API.G_EXC_ERROR THEN
328: x_return_status := FND_API.G_RET_STS_ERROR;

Line 327: WHEN FND_API.G_EXC_ERROR THEN

323: p_data => x_msg_data,
324: p_encoded => fnd_api.g_false );
325:
326: EXCEPTION
327: WHEN FND_API.G_EXC_ERROR THEN
328: x_return_status := FND_API.G_RET_STS_ERROR;
329: Rollback to DETACH_UNIT_PVT;
330: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
331: p_data => x_msg_data,

Line 328: x_return_status := FND_API.G_RET_STS_ERROR;

324: p_encoded => fnd_api.g_false );
325:
326: EXCEPTION
327: WHEN FND_API.G_EXC_ERROR THEN
328: x_return_status := FND_API.G_RET_STS_ERROR;
329: Rollback to DETACH_UNIT_PVT;
330: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
331: p_data => x_msg_data,
332: p_encoded => fnd_api.g_false );

Line 332: p_encoded => fnd_api.g_false );

328: x_return_status := FND_API.G_RET_STS_ERROR;
329: Rollback to DETACH_UNIT_PVT;
330: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
331: p_data => x_msg_data,
332: p_encoded => fnd_api.g_false );
333:
334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
336: Rollback to DETACH_UNIT_PVT;

Line 334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

330: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
331: p_data => x_msg_data,
332: p_encoded => fnd_api.g_false );
333:
334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
336: Rollback to DETACH_UNIT_PVT;
337: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
338: p_data => x_msg_data,

Line 335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

331: p_data => x_msg_data,
332: p_encoded => fnd_api.g_false );
333:
334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
336: Rollback to DETACH_UNIT_PVT;
337: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
338: p_data => x_msg_data,
339: p_encoded => fnd_api.g_false );

Line 339: p_encoded => fnd_api.g_false );

335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
336: Rollback to DETACH_UNIT_PVT;
337: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
338: p_data => x_msg_data,
339: p_encoded => fnd_api.g_false );
340:
341: WHEN OTHERS THEN
342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
343: Rollback to DETACH_UNIT_PVT;

Line 342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

338: p_data => x_msg_data,
339: p_encoded => fnd_api.g_false );
340:
341: WHEN OTHERS THEN
342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
343: Rollback to DETACH_UNIT_PVT;
344: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
345: THEN
346: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

Line 352: p_encoded => fnd_api.g_false );

348: p_error_text => SUBSTR(SQLERRM,1,240) );
349: END IF;
350: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
351: p_data => x_msg_data,
352: p_encoded => fnd_api.g_false );
353:
354: END DETACH_UNIT;
355:
356: -----------------

Line 361: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

357: -- ATTACH_ITEM --
358: -----------------
359: PROCEDURE ATTACH_ITEM (
360: p_api_version IN NUMBER,
361: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
362: p_commit IN VARCHAR2 := FND_API.G_FALSE,
363: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
364: p_x_assos_rec IN OUT NOCOPY AHL_PC_ASSOCIATION_PUB.PC_ASSOS_REC,
365: x_return_status OUT NOCOPY VARCHAR2,

Line 362: p_commit IN VARCHAR2 := FND_API.G_FALSE,

358: -----------------
359: PROCEDURE ATTACH_ITEM (
360: p_api_version IN NUMBER,
361: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
362: p_commit IN VARCHAR2 := FND_API.G_FALSE,
363: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
364: p_x_assos_rec IN OUT NOCOPY AHL_PC_ASSOCIATION_PUB.PC_ASSOS_REC,
365: x_return_status OUT NOCOPY VARCHAR2,
366: x_msg_count OUT NOCOPY NUMBER,

Line 363: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

359: PROCEDURE ATTACH_ITEM (
360: p_api_version IN NUMBER,
361: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
362: p_commit IN VARCHAR2 := FND_API.G_FALSE,
363: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
364: p_x_assos_rec IN OUT NOCOPY AHL_PC_ASSOCIATION_PUB.PC_ASSOS_REC,
365: x_return_status OUT NOCOPY VARCHAR2,
366: x_msg_count OUT NOCOPY NUMBER,
367: x_msg_data OUT NOCOPY VARCHAR2

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

379: -- Standard start of API savepoint
380: SAVEPOINT ATTACH_ITEM_PVT;
381:
382: -- Standard call to check for call compatibility
383: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
384: THEN
385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
386: END IF;
387:

Line 385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

381:
382: -- Standard call to check for call compatibility
383: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
384: THEN
385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
386: END IF;
387:
388: -- Initialize message list if p_init_msg_list is set to TRUE
389: IF FND_API.To_Boolean(p_init_msg_list)

Line 389: IF FND_API.To_Boolean(p_init_msg_list)

385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
386: END IF;
387:
388: -- Initialize message list if p_init_msg_list is set to TRUE
389: IF FND_API.To_Boolean(p_init_msg_list)
390: THEN
391: FND_MSG_PUB.Initialize;
392: END IF;
393:

Line 395: x_return_status := FND_API.G_RET_STS_SUCCESS;

391: FND_MSG_PUB.Initialize;
392: END IF;
393:
394: -- Initialize API return status to success
395: x_return_status := FND_API.G_RET_STS_SUCCESS;
396:
397: IF G_DEBUG='Y' THEN
398: AHL_DEBUG_PUB.ENABLE_DEBUG;
399: END IF;

Line 409: RAISE FND_API.G_EXC_ERROR;

405:
406: -- Check Error Message stack.
407: x_msg_count := FND_MSG_PUB.count_msg;
408: IF x_msg_count > 0 THEN
409: RAISE FND_API.G_EXC_ERROR;
410: END IF;
411:
412: IF p_x_assos_rec.OPERATION_FLAG = G_DML_LINK
413: THEN

Line 501: RAISE FND_API.G_EXC_ERROR;

497:
498: -- Check Error Message stack.
499: x_msg_count := FND_MSG_PUB.count_msg;
500: IF x_msg_count > 0 THEN
501: RAISE FND_API.G_EXC_ERROR;
502: END IF;
503:
504: -- Standard check for p_commit
505: IF FND_API.To_Boolean (p_commit)

Line 505: IF FND_API.To_Boolean (p_commit)

501: RAISE FND_API.G_EXC_ERROR;
502: END IF;
503:
504: -- Standard check for p_commit
505: IF FND_API.To_Boolean (p_commit)
506: THEN
507: COMMIT WORK;
508: END IF;
509:

Line 513: p_encoded => fnd_api.g_false );

509:
510: -- Standard call to get message count and if count is 1, get message info
511: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
512: p_data => x_msg_data,
513: p_encoded => fnd_api.g_false );
514:
515: EXCEPTION
516: WHEN FND_API.G_EXC_ERROR THEN
517: x_return_status := FND_API.G_RET_STS_ERROR;

Line 516: WHEN FND_API.G_EXC_ERROR THEN

512: p_data => x_msg_data,
513: p_encoded => fnd_api.g_false );
514:
515: EXCEPTION
516: WHEN FND_API.G_EXC_ERROR THEN
517: x_return_status := FND_API.G_RET_STS_ERROR;
518: Rollback to ATTACH_ITEM_PVT;
519: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
520: p_data => x_msg_data,

Line 517: x_return_status := FND_API.G_RET_STS_ERROR;

513: p_encoded => fnd_api.g_false );
514:
515: EXCEPTION
516: WHEN FND_API.G_EXC_ERROR THEN
517: x_return_status := FND_API.G_RET_STS_ERROR;
518: Rollback to ATTACH_ITEM_PVT;
519: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
520: p_data => x_msg_data,
521: p_encoded => fnd_api.g_false );

Line 521: p_encoded => fnd_api.g_false );

517: x_return_status := FND_API.G_RET_STS_ERROR;
518: Rollback to ATTACH_ITEM_PVT;
519: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
520: p_data => x_msg_data,
521: p_encoded => fnd_api.g_false );
522:
523: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
525: Rollback to ATTACH_ITEM_PVT;

Line 523: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

519: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
520: p_data => x_msg_data,
521: p_encoded => fnd_api.g_false );
522:
523: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
525: Rollback to ATTACH_ITEM_PVT;
526: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
527: p_data => x_msg_data,

Line 524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

520: p_data => x_msg_data,
521: p_encoded => fnd_api.g_false );
522:
523: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
525: Rollback to ATTACH_ITEM_PVT;
526: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
527: p_data => x_msg_data,
528: p_encoded => fnd_api.g_false );

Line 528: p_encoded => fnd_api.g_false );

524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
525: Rollback to ATTACH_ITEM_PVT;
526: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
527: p_data => x_msg_data,
528: p_encoded => fnd_api.g_false );
529:
530: WHEN OTHERS THEN
531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
532: Rollback to ATTACH_ITEM_PVT;

Line 531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

527: p_data => x_msg_data,
528: p_encoded => fnd_api.g_false );
529:
530: WHEN OTHERS THEN
531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
532: Rollback to ATTACH_ITEM_PVT;
533: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
534: THEN
535: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

Line 541: p_encoded => fnd_api.g_false );

537: p_error_text => SUBSTR(SQLERRM,1,240) );
538: END IF;
539: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
540: p_data => x_msg_data,
541: p_encoded => fnd_api.g_false );
542:
543: END ATTACH_ITEM;
544:
545: -----------------

Line 550: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

546: -- DETACH_ITEM --
547: -----------------
548: PROCEDURE DETACH_ITEM (
549: p_api_version IN NUMBER,
550: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
551: p_commit IN VARCHAR2 := FND_API.G_FALSE,
552: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
553: p_x_assos_rec IN OUT NOCOPY AHL_PC_ASSOCIATION_PUB.PC_ASSOS_REC,
554: x_return_status OUT NOCOPY VARCHAR2,

Line 551: p_commit IN VARCHAR2 := FND_API.G_FALSE,

547: -----------------
548: PROCEDURE DETACH_ITEM (
549: p_api_version IN NUMBER,
550: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
551: p_commit IN VARCHAR2 := FND_API.G_FALSE,
552: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
553: p_x_assos_rec IN OUT NOCOPY AHL_PC_ASSOCIATION_PUB.PC_ASSOS_REC,
554: x_return_status OUT NOCOPY VARCHAR2,
555: x_msg_count OUT NOCOPY NUMBER,

Line 552: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

548: PROCEDURE DETACH_ITEM (
549: p_api_version IN NUMBER,
550: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
551: p_commit IN VARCHAR2 := FND_API.G_FALSE,
552: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
553: p_x_assos_rec IN OUT NOCOPY AHL_PC_ASSOCIATION_PUB.PC_ASSOS_REC,
554: x_return_status OUT NOCOPY VARCHAR2,
555: x_msg_count OUT NOCOPY NUMBER,
556: x_msg_data OUT NOCOPY VARCHAR2

Line 563: l_ump_attached VARCHAR2(1) := FND_API.G_FALSE;

559: l_api_name CONSTANT VARCHAR2(30) := 'ATTACH_ITEM';
560: l_api_version CONSTANT NUMBER := 1.0;
561: l_return_status VARCHAR2(1);
562:
563: l_ump_attached VARCHAR2(1) := FND_API.G_FALSE;
564: l_exist VARCHAR2(1);
565: l_is_pc_primary VARCHAR2(1) := 'N';
566:
567: CURSOR is_pc_primary (p_pc_node_id IN NUMBER)

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

575: -- Standard start of API savepoint
576: SAVEPOINT DETACH_ITEM_PVT;
577:
578: -- Standard call to check for call compatibility
579: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
580: THEN
581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
582: END IF;
583:

Line 581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

577:
578: -- Standard call to check for call compatibility
579: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
580: THEN
581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
582: END IF;
583:
584: -- Initialize message list if p_init_msg_list is set to TRUE
585: IF FND_API.To_Boolean(p_init_msg_list)

Line 585: IF FND_API.To_Boolean(p_init_msg_list)

581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
582: END IF;
583:
584: -- Initialize message list if p_init_msg_list is set to TRUE
585: IF FND_API.To_Boolean(p_init_msg_list)
586: THEN
587: FND_MSG_PUB.Initialize;
588: END IF;
589:

Line 591: x_return_status := FND_API.G_RET_STS_SUCCESS;

587: FND_MSG_PUB.Initialize;
588: END IF;
589:
590: -- Initialize API return status to success
591: x_return_status := FND_API.G_RET_STS_SUCCESS;
592:
593: IF G_DEBUG='Y' THEN
594: AHL_DEBUG_PUB.ENABLE_DEBUG;
595: END IF;

Line 602: RAISE FND_API.G_EXC_ERROR;

598:
599: -- Check Error Message stack.
600: x_msg_count := FND_MSG_PUB.count_msg;
601: IF x_msg_count > 0 THEN
602: RAISE FND_API.G_EXC_ERROR;
603: END IF;
604:
605: -- API BODY here...
606: -- Commented for ER - Bug 27786360

Line 623: -- l_ump_attached := FND_API.G_TRUE;

619: -- nvl(inventory_org_id,FND_PROFILE.VALUE('ORG_ID')) = nvl(p_x_assos_rec.INVENTORY_ORG_ID,FND_PROFILE.VALUE('ORG_ID'));
620: --
621: --
622:
623: -- l_ump_attached := FND_API.G_TRUE;
624:
625: -- EXCEPTION
626: -- WHEN NO_DATA_FOUND THEN
627: -- l_ump_attached := FND_API.G_FALSE;

Line 627: -- l_ump_attached := FND_API.G_FALSE;

623: -- l_ump_attached := FND_API.G_TRUE;
624:
625: -- EXCEPTION
626: -- WHEN NO_DATA_FOUND THEN
627: -- l_ump_attached := FND_API.G_FALSE;
628: -- WHEN OTHERS THEN
629: -- l_ump_attached := FND_API.G_FALSE;
630:
631: -- END;

Line 629: -- l_ump_attached := FND_API.G_FALSE;

625: -- EXCEPTION
626: -- WHEN NO_DATA_FOUND THEN
627: -- l_ump_attached := FND_API.G_FALSE;
628: -- WHEN OTHERS THEN
629: -- l_ump_attached := FND_API.G_FALSE;
630:
631: -- END;
632: --END IF;
633:

Line 634: IF (l_ump_attached = FND_API.G_FALSE)

630:
631: -- END;
632: --END IF;
633:
634: IF (l_ump_attached = FND_API.G_FALSE)
635: THEN
636: -- Knocking off items...
637:
638: DELETE FROM AHL_PC_ASSOCIATIONS

Line 658: RAISE FND_API.G_EXC_ERROR;

654:
655: -- Check Error Message stack.
656: x_msg_count := FND_MSG_PUB.count_msg;
657: IF x_msg_count > 0 THEN
658: RAISE FND_API.G_EXC_ERROR;
659: END IF;
660:
661: -- Standard check for p_commit
662: IF FND_API.To_Boolean (p_commit)

Line 662: IF FND_API.To_Boolean (p_commit)

658: RAISE FND_API.G_EXC_ERROR;
659: END IF;
660:
661: -- Standard check for p_commit
662: IF FND_API.To_Boolean (p_commit)
663: THEN
664: COMMIT WORK;
665: END IF;
666:

Line 670: p_encoded => fnd_api.g_false );

666:
667: -- Standard call to get message count and if count is 1, get message info
668: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
669: p_data => x_msg_data,
670: p_encoded => fnd_api.g_false );
671:
672: EXCEPTION
673: WHEN FND_API.G_EXC_ERROR THEN
674: x_return_status := FND_API.G_RET_STS_ERROR;

Line 673: WHEN FND_API.G_EXC_ERROR THEN

669: p_data => x_msg_data,
670: p_encoded => fnd_api.g_false );
671:
672: EXCEPTION
673: WHEN FND_API.G_EXC_ERROR THEN
674: x_return_status := FND_API.G_RET_STS_ERROR;
675: Rollback to DETACH_ITEM_PVT;
676: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
677: p_data => x_msg_data,

Line 674: x_return_status := FND_API.G_RET_STS_ERROR;

670: p_encoded => fnd_api.g_false );
671:
672: EXCEPTION
673: WHEN FND_API.G_EXC_ERROR THEN
674: x_return_status := FND_API.G_RET_STS_ERROR;
675: Rollback to DETACH_ITEM_PVT;
676: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
677: p_data => x_msg_data,
678: p_encoded => fnd_api.g_false );

Line 678: p_encoded => fnd_api.g_false );

674: x_return_status := FND_API.G_RET_STS_ERROR;
675: Rollback to DETACH_ITEM_PVT;
676: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
677: p_data => x_msg_data,
678: p_encoded => fnd_api.g_false );
679:
680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
682: Rollback to DETACH_ITEM_PVT;

Line 680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

676: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
677: p_data => x_msg_data,
678: p_encoded => fnd_api.g_false );
679:
680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
682: Rollback to DETACH_ITEM_PVT;
683: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
684: p_data => x_msg_data,

Line 681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

677: p_data => x_msg_data,
678: p_encoded => fnd_api.g_false );
679:
680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
682: Rollback to DETACH_ITEM_PVT;
683: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
684: p_data => x_msg_data,
685: p_encoded => fnd_api.g_false );

Line 685: p_encoded => fnd_api.g_false );

681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
682: Rollback to DETACH_ITEM_PVT;
683: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
684: p_data => x_msg_data,
685: p_encoded => fnd_api.g_false );
686:
687: WHEN OTHERS THEN
688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
689: Rollback to DETACH_ITEM_PVT;

Line 688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

684: p_data => x_msg_data,
685: p_encoded => fnd_api.g_false );
686:
687: WHEN OTHERS THEN
688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
689: Rollback to DETACH_ITEM_PVT;
690: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
691: THEN
692: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

Line 698: p_encoded => fnd_api.g_false );

694: p_error_text => SUBSTR(SQLERRM,1,240) );
695: END IF;
696: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
697: p_data => x_msg_data,
698: p_encoded => fnd_api.g_false );
699:
700: END DETACH_ITEM;
701:
702: ----------------------

Line 707: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

703: -- PROCESS_DOCUMENT --
704: ----------------------
705: PROCEDURE PROCESS_DOCUMENT (
706: p_api_version IN NUMBER,
707: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
708: p_commit IN VARCHAR2 := FND_API.G_FALSE,
709: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
710: p_module_type IN VARCHAR2 := NULL,
711: p_x_assos_tbl IN OUT NOCOPY AHL_DI_ASSO_DOC_GEN_PUB.association_tbl,

Line 708: p_commit IN VARCHAR2 := FND_API.G_FALSE,

704: ----------------------
705: PROCEDURE PROCESS_DOCUMENT (
706: p_api_version IN NUMBER,
707: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
708: p_commit IN VARCHAR2 := FND_API.G_FALSE,
709: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
710: p_module_type IN VARCHAR2 := NULL,
711: p_x_assos_tbl IN OUT NOCOPY AHL_DI_ASSO_DOC_GEN_PUB.association_tbl,
712: x_return_status OUT NOCOPY VARCHAR2,

Line 709: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

705: PROCEDURE PROCESS_DOCUMENT (
706: p_api_version IN NUMBER,
707: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
708: p_commit IN VARCHAR2 := FND_API.G_FALSE,
709: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
710: p_module_type IN VARCHAR2 := NULL,
711: p_x_assos_tbl IN OUT NOCOPY AHL_DI_ASSO_DOC_GEN_PUB.association_tbl,
712: x_return_status OUT NOCOPY VARCHAR2,
713: x_msg_count OUT NOCOPY NUMBER,

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

747: -- Standard start of API savepoint
748: SAVEPOINT PROCESS_DOCUMENT_PVT;
749:
750: -- Standard call to check for call compatibility
751: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
752: THEN
753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
754: END IF;
755:

Line 753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

749:
750: -- Standard call to check for call compatibility
751: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
752: THEN
753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
754: END IF;
755:
756: -- Initialize message list if p_init_msg_list is set to TRUE
757: IF FND_API.To_Boolean(p_init_msg_list)

Line 757: IF FND_API.To_Boolean(p_init_msg_list)

753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
754: END IF;
755:
756: -- Initialize message list if p_init_msg_list is set to TRUE
757: IF FND_API.To_Boolean(p_init_msg_list)
758: THEN
759: FND_MSG_PUB.Initialize;
760: END IF;
761:

Line 763: x_return_status := FND_API.G_RET_STS_SUCCESS;

759: FND_MSG_PUB.Initialize;
760: END IF;
761:
762: -- Initialize API return status to success
763: x_return_status := FND_API.G_RET_STS_SUCCESS;
764:
765: IF G_DEBUG='Y' THEN
766: AHL_DEBUG_PUB.ENABLE_DEBUG;
767: END IF;

Line 792: RAISE FND_API.G_EXC_ERROR;

788: THEN
789: FND_MESSAGE.Set_Name('AHL','AHL_PC_DOC_NO_REV');
790: FND_MESSAGE.Set_Token('DOC',p_x_assos_tbl(i).DOCUMENT_NO);
791: FND_MSG_PUB.ADD;
792: RAISE FND_API.G_EXC_ERROR;
793: END IF;
794:
795: -- Check PC status for document association
796: OPEN get_pc_header_status (p_x_assos_tbl(i).ASO_OBJECT_ID);

Line 808: RAISE FND_API.G_EXC_ERROR;

804: IF (l_status = 'APPROVAL_PENDING')
805: THEN
806: FND_MESSAGE.Set_Name('AHL','AHL_PC_STATUS_COMPLETE');
807: FND_MSG_PUB.ADD;
808: RAISE FND_API.G_EXC_ERROR;
809: -- If PC is in complete status, there are 2 cases...
810: -- 1. If it has a DRAFT version, allow document association
811: -- 2. If it has no DRAFT version, throw error
812: ELSIF (l_status = 'COMPLETE')

Line 824: RAISE FND_API.G_EXC_ERROR;

820:
821: CLOSE check_draft_version_exists;
822: FND_MESSAGE.Set_Name('AHL','AHL_PC_STATUS_COMPLETE');
823: FND_MSG_PUB.ADD;
824: RAISE FND_API.G_EXC_ERROR;
825: ELSE
826:
827: CLOSE check_draft_version_exists;
828: END IF;

Line 842: RAISE FND_API.G_EXC_ERROR;

838: ELSE
839: CLOSE check_node_exists;
840: FND_MESSAGE.Set_Name('AHL','AHL_PC_NODE_NOT_FOUND');
841: FND_MSG_PUB.ADD;
842: RAISE FND_API.G_EXC_ERROR;
843: END IF;
844: END LOOP;
845: END IF;
846:

Line 854: p_init_msg_list => FND_API.G_FALSE,

850:
851: AHL_DI_ASSO_DOC_GEN_PUB.PROCESS_ASSOCIATION
852: (
853: p_api_version => l_api_version,
854: p_init_msg_list => FND_API.G_FALSE,
855: p_commit => FND_API.G_FALSE,
856: p_validate_only => FND_API.G_TRUE,
857: p_validation_level => p_validation_level,
858: p_x_association_tbl => p_x_assos_tbl,

Line 855: p_commit => FND_API.G_FALSE,

851: AHL_DI_ASSO_DOC_GEN_PUB.PROCESS_ASSOCIATION
852: (
853: p_api_version => l_api_version,
854: p_init_msg_list => FND_API.G_FALSE,
855: p_commit => FND_API.G_FALSE,
856: p_validate_only => FND_API.G_TRUE,
857: p_validation_level => p_validation_level,
858: p_x_association_tbl => p_x_assos_tbl,
859: p_module_type => p_module_type,

Line 856: p_validate_only => FND_API.G_TRUE,

852: (
853: p_api_version => l_api_version,
854: p_init_msg_list => FND_API.G_FALSE,
855: p_commit => FND_API.G_FALSE,
856: p_validate_only => FND_API.G_TRUE,
857: p_validation_level => p_validation_level,
858: p_x_association_tbl => p_x_assos_tbl,
859: p_module_type => p_module_type,
860: x_return_status => x_return_status,

Line 868: RAISE FND_API.G_EXC_ERROR;

864:
865: -- Check Error Message stack.
866: x_msg_count := FND_MSG_PUB.count_msg;
867: IF x_msg_count > 0 THEN
868: RAISE FND_API.G_EXC_ERROR;
869: END IF;
870:
871: -- Standard check for p_commit
872: IF FND_API.To_Boolean (p_commit)

Line 872: IF FND_API.To_Boolean (p_commit)

868: RAISE FND_API.G_EXC_ERROR;
869: END IF;
870:
871: -- Standard check for p_commit
872: IF FND_API.To_Boolean (p_commit)
873: THEN
874: COMMIT WORK;
875: END IF;
876:

Line 880: p_encoded => fnd_api.g_false );

876:
877: -- Standard call to get message count and if count is 1, get message info
878: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
879: p_data => x_msg_data,
880: p_encoded => fnd_api.g_false );
881:
882: EXCEPTION
883: WHEN FND_API.G_EXC_ERROR THEN
884: x_return_status := FND_API.G_RET_STS_ERROR;

Line 883: WHEN FND_API.G_EXC_ERROR THEN

879: p_data => x_msg_data,
880: p_encoded => fnd_api.g_false );
881:
882: EXCEPTION
883: WHEN FND_API.G_EXC_ERROR THEN
884: x_return_status := FND_API.G_RET_STS_ERROR;
885: Rollback to PROCESS_DOCUMENT_PVT;
886: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
887: p_data => x_msg_data,

Line 884: x_return_status := FND_API.G_RET_STS_ERROR;

880: p_encoded => fnd_api.g_false );
881:
882: EXCEPTION
883: WHEN FND_API.G_EXC_ERROR THEN
884: x_return_status := FND_API.G_RET_STS_ERROR;
885: Rollback to PROCESS_DOCUMENT_PVT;
886: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
887: p_data => x_msg_data,
888: p_encoded => fnd_api.g_false );

Line 888: p_encoded => fnd_api.g_false );

884: x_return_status := FND_API.G_RET_STS_ERROR;
885: Rollback to PROCESS_DOCUMENT_PVT;
886: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
887: p_data => x_msg_data,
888: p_encoded => fnd_api.g_false );
889:
890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
892: Rollback to PROCESS_DOCUMENT_PVT;

Line 890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

886: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
887: p_data => x_msg_data,
888: p_encoded => fnd_api.g_false );
889:
890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
892: Rollback to PROCESS_DOCUMENT_PVT;
893: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
894: p_data => x_msg_data,

Line 891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

887: p_data => x_msg_data,
888: p_encoded => fnd_api.g_false );
889:
890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
892: Rollback to PROCESS_DOCUMENT_PVT;
893: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
894: p_data => x_msg_data,
895: p_encoded => fnd_api.g_false );

Line 895: p_encoded => fnd_api.g_false );

891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
892: Rollback to PROCESS_DOCUMENT_PVT;
893: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
894: p_data => x_msg_data,
895: p_encoded => fnd_api.g_false );
896:
897: WHEN OTHERS THEN
898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
899: Rollback to PROCESS_DOCUMENT_PVT;

Line 898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

894: p_data => x_msg_data,
895: p_encoded => fnd_api.g_false );
896:
897: WHEN OTHERS THEN
898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
899: Rollback to PROCESS_DOCUMENT_PVT;
900: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
901: THEN
902: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

Line 908: p_encoded => fnd_api.g_false );

904: p_error_text => SUBSTR(SQLERRM,1,240) );
905: END IF;
906: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
907: p_data => x_msg_data,
908: p_encoded => fnd_api.g_false );
909:
910: END PROCESS_DOCUMENT;
911:
912: --------------------------

Line 1069: RAISE FND_API.G_EXC_ERROR;

1065: IF (l_object_version_number <> p_x_assos_rec.object_version_number)
1066: THEN
1067: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
1068: FND_MSG_PUB.ADD;
1069: RAISE FND_API.G_EXC_ERROR;
1070: END IF;
1071: END IF;
1072:
1073: -- ACL :: R12 Changes

Line 1084: RAISE FND_API.G_EXC_ERROR;

1080: THEN
1081: FND_MESSAGE.set_name( 'AHL','AHL_UC_INVALID_Q_ACTION' );
1082: FND_MSG_PUB.add;
1083: CLOSE check_unit_quarantine;
1084: RAISE FND_API.G_EXC_ERROR;
1085: END IF;
1086: CLOSE check_unit_quarantine;
1087: END If;
1088:

Line 1098: RAISE FND_API.G_EXC_ERROR;

1094: IF (l_status <> 'DRAFT' and l_status <> 'APPROVAL_REJECTED')
1095: THEN
1096: FND_MESSAGE.Set_Name('AHL','AHL_PC_STATUS_COMPLETE');
1097: FND_MSG_PUB.ADD;
1098: RAISE FND_API.G_EXC_ERROR;
1099: END IF;
1100: END IF;
1101:
1102: -- Check if attached unit/item exists in the PC tree for detach operations

Line 1113: RAISE FND_API.G_EXC_ERROR;

1109: THEN
1110: FND_MESSAGE.Set_Name('AHL','AHL_PC_ASSOS_NOT_FOUND');
1111: FND_MSG_PUB.ADD;
1112: CLOSE check_id_exists_in_PC;
1113: RAISE FND_API.G_EXC_ERROR;
1114: END IF;
1115: CLOSE check_id_exists_in_PC;
1116: ELSE
1117: OPEN is_pc_primary(p_x_assos_rec.pc_node_id);

Line 1130: RAISE FND_API.G_EXC_ERROR;

1126: FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_ITEM_EXISTS');
1127: FND_MESSAGE.Set_Token('UNIT_NAME',p_x_assos_rec.unit_item_name);
1128: FND_MSG_PUB.ADD;
1129: CLOSE check_unit_item_exists;
1130: RAISE FND_API.G_EXC_ERROR;
1131: END IF;
1132: CLOSE check_unit_item_exists;
1133: ELSE
1134: OPEN check_unit_item_at_same_level (p_x_assos_rec.unit_item_id, p_x_assos_rec.pc_node_id);

Line 1142: RAISE FND_API.G_EXC_ERROR;

1138: FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_PART_EXISTS_AT_LVL'); -- SATHAPLI BUG:5576835:Changed to correct message code
1139: FND_MESSAGE.Set_Token('UNIT_NAME',p_x_assos_rec.unit_item_name);
1140: FND_MSG_PUB.ADD;
1141: CLOSE check_unit_item_at_same_level;
1142: RAISE FND_API.G_EXC_ERROR;
1143: END IF;
1144: CLOSE check_unit_item_at_same_level;
1145: END IF;
1146:

Line 1156: RAISE FND_API.G_EXC_ERROR;

1152: THEN
1153: FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_NOT_FOUND');
1154: FND_MSG_PUB.ADD;
1155: CLOSE check_unit_exists;
1156: RAISE FND_API.G_EXC_ERROR;
1157: END IF;
1158: CLOSE check_unit_exists;
1159:
1160: OPEN check_unit_valid (p_x_assos_rec.unit_item_id);

Line 1168: RAISE FND_API.G_EXC_ERROR;

1164: FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_NOT_VALID');
1165: FND_MESSAGE.Set_Token('UNIT_NAME',p_x_assos_rec.unit_item_name);
1166: FND_MSG_PUB.ADD;
1167: CLOSE check_unit_valid;
1168: RAISE FND_API.G_EXC_ERROR;
1169: END IF;
1170: CLOSE check_unit_valid;
1171: ELSIF (p_x_assos_rec.association_type_flag = G_PART)
1172: THEN

Line 1180: RAISE FND_API.G_EXC_ERROR;

1176: THEN
1177: FND_MESSAGE.Set_Name('AHL','AHL_PC_ITEM_NOT_FOUND');
1178: FND_MSG_PUB.ADD;
1179: CLOSE check_item_exists;
1180: RAISE FND_API.G_EXC_ERROR;
1181: END IF;
1182: CLOSE check_item_exists;
1183:
1184: OPEN check_item_valid (p_x_assos_rec.unit_item_id);

Line 1192: RAISE FND_API.G_EXC_ERROR;

1188: FND_MESSAGE.Set_Name('AHL','AHL_PC_ITEM_NOT_VALID');
1189: FND_MESSAGE.Set_Token('ITEM_NAME',p_x_assos_rec.unit_item_name);
1190: FND_MSG_PUB.ADD;
1191: CLOSE check_item_valid;
1192: RAISE FND_API.G_EXC_ERROR;
1193: END IF;
1194: CLOSE check_item_valid;
1195: END IF;
1196: END IF;

Line 1208: RAISE FND_API.G_EXC_ERROR;

1204: THEN
1205: FND_MESSAGE.Set_Name('AHL','AHL_PC_ATTACH_LEAF_ONLY');
1206: FND_MSG_PUB.ADD;
1207: CLOSE check_child_node_exists;
1208: RAISE FND_API.G_EXC_ERROR;
1209: END IF;
1210: CLOSE check_child_node_exists;
1211: END IF;
1212: