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_MC_PATH_POSITION_PVT dependencies on FND_API

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

24: -- End of Comments.
25:
26: PROCEDURE Create_Position_ID (
27: p_api_version IN NUMBER,
28: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
29: p_commit IN VARCHAR2 := FND_API.G_FALSE,
30: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
31: x_return_status OUT NOCOPY VARCHAR2,
32: x_msg_count OUT NOCOPY NUMBER,

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

25:
26: PROCEDURE Create_Position_ID (
27: p_api_version IN NUMBER,
28: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
29: p_commit IN VARCHAR2 := FND_API.G_FALSE,
30: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
31: x_return_status OUT NOCOPY VARCHAR2,
32: x_msg_count OUT NOCOPY NUMBER,
33: x_msg_data OUT NOCOPY VARCHAR2,

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

26: PROCEDURE Create_Position_ID (
27: p_api_version IN NUMBER,
28: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
29: p_commit IN VARCHAR2 := FND_API.G_FALSE,
30: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
31: x_return_status OUT NOCOPY VARCHAR2,
32: x_msg_count OUT NOCOPY NUMBER,
33: x_msg_data OUT NOCOPY VARCHAR2,
34: p_path_position_tbl IN AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type,

Line 119: x_return_status := FND_API.G_RET_STS_SUCCESS;

115: -- Standard start of API savepoint
116: SAVEPOINT Create_Position_ID_pvt;
117:
118: -- Initialize Procedure return status to success
119: x_return_status := FND_API.G_RET_STS_SUCCESS;
120: -- Standard call to check for call compatibility
121: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
122: G_PKG_NAME) THEN
123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 121: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

117:
118: -- Initialize Procedure return status to success
119: x_return_status := FND_API.G_RET_STS_SUCCESS;
120: -- Standard call to check for call compatibility
121: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
122: G_PKG_NAME) THEN
123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
124: END IF;
125:

Line 123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

119: x_return_status := FND_API.G_RET_STS_SUCCESS;
120: -- Standard call to check for call compatibility
121: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
122: G_PKG_NAME) THEN
123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
124: END IF;
125:
126: -- Initialize message list if p_init_msg_list is set to TRUE
127: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 127: IF FND_API.To_Boolean(p_init_msg_list) THEN

123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
124: END IF;
125:
126: -- Initialize message list if p_init_msg_list is set to TRUE
127: IF FND_API.To_Boolean(p_init_msg_list) THEN
128: FND_MSG_PUB.Initialize;
129: END IF;
130:
131: --initialize ver spec score;

Line 180: IF (p_position_ref_code = FND_API.G_MISS_CHAR) THEN

176:
177: END LOOP;
178:
179: --Convert the position ref meaning only if position ref code is undefined.
180: IF (p_position_ref_code = FND_API.G_MISS_CHAR) THEN
181: IF (p_position_ref_meaning = FND_API.G_MISS_CHAR) THEN
182: l_position_ref_code := NULL;
183: ELSIF (p_position_ref_meaning IS NULL) THEN
184: l_position_ref_code := NULL;

Line 181: IF (p_position_ref_meaning = FND_API.G_MISS_CHAR) THEN

177: END LOOP;
178:
179: --Convert the position ref meaning only if position ref code is undefined.
180: IF (p_position_ref_code = FND_API.G_MISS_CHAR) THEN
181: IF (p_position_ref_meaning = FND_API.G_MISS_CHAR) THEN
182: l_position_ref_code := NULL;
183: ELSIF (p_position_ref_meaning IS NULL) THEN
184: l_position_ref_code := NULL;
185: ELSIF (p_position_ref_meaning <> FND_API.G_MISS_CHAR) THEN

Line 185: ELSIF (p_position_ref_meaning <> FND_API.G_MISS_CHAR) THEN

181: IF (p_position_ref_meaning = FND_API.G_MISS_CHAR) THEN
182: l_position_ref_code := NULL;
183: ELSIF (p_position_ref_meaning IS NULL) THEN
184: l_position_ref_code := NULL;
185: ELSIF (p_position_ref_meaning <> FND_API.G_MISS_CHAR) THEN
186: AHL_UTIL_MC_PKG.Convert_To_LookupCode('AHL_POSITION_REFERENCE',
187: p_position_ref_meaning,
188: l_position_ref_code,
189: l_return_val);

Line 203: RAISE FND_API.G_EXC_ERROR;

199:
200: -- Check Error Message stack.
201: l_msg_count := FND_MSG_PUB.count_msg;
202: IF l_msg_count > 0 THEN
203: RAISE FND_API.G_EXC_ERROR;
204: END IF;
205:
206: --Convert to find all same level paths
207: IF (l_position_ref_code <> FND_API.G_MISS_CHAR AND

Line 207: IF (l_position_ref_code <> FND_API.G_MISS_CHAR AND

203: RAISE FND_API.G_EXC_ERROR;
204: END IF;
205:
206: --Convert to find all same level paths
207: IF (l_position_ref_code <> FND_API.G_MISS_CHAR AND
208: l_position_ref_code IS NOT NULL) THEN
209: l_poskey := l_path_tbl(l_path_tbl.LAST).position_key;
210: OPEN get_sibling_poskey_csr(l_path_tbl(l_path_tbl.LAST).mc_id,
211: l_poskey);

Line 215: l_sib_pos_ref_code := get_posref_by_path(l_path_tbl, FND_API.G_TRUE);

211: l_poskey);
212: LOOP
213: FETCH get_sibling_poskey_csr INTO l_path_tbl(l_path_tbl.LAST).position_key;
214: EXIT WHEN get_sibling_poskey_csr%NOTFOUND;
215: l_sib_pos_ref_code := get_posref_by_path(l_path_tbl, FND_API.G_TRUE);
216: IF (l_sib_pos_ref_code = l_position_ref_code) THEN
217: FND_MESSAGE.Set_Name('AHL','AHL_MC_POSREF_DUPLICATE');
218: FND_MESSAGE.Set_Token('POSREF',l_position_ref_code);
219: FND_MSG_PUB.ADD;

Line 228: RAISE FND_API.G_EXC_ERROR;

224:
225: -- Check Error Message stack.
226: l_msg_count := FND_MSG_PUB.count_msg;
227: IF l_msg_count > 0 THEN
228: RAISE FND_API.G_EXC_ERROR;
229: END IF;
230:
231: --Encode the path_position_tbl
232: l_encoded_path := Encode(p_path_position_tbl);

Line 240: IF (l_position_ref_code <> FND_API.G_MISS_CHAR OR

236: --Compare and find matching path_position
237: OPEN get_position_id_csr(l_encoded_path);
238: FETCH get_position_id_csr INTO x_position_id;
239: IF (get_position_id_csr%FOUND) THEN
240: IF (l_position_ref_code <> FND_API.G_MISS_CHAR OR
241: l_position_ref_code IS NULL) THEN
242: UPDATE ahl_mc_path_positions SET
243: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
244: LAST_UPDATE_DATE = sysdate,

Line 379: IF FND_API.TO_BOOLEAN(p_commit) THEN

375: END IF;
376: CLOSE get_position_id_csr;
377:
378: -- Standard check of p_commit
379: IF FND_API.TO_BOOLEAN(p_commit) THEN
380: COMMIT WORK;
381: END IF;
382: -- Standard call to get message count and if count is 1, get message info
383: FND_MSG_PUB.Count_And_Get

Line 386: p_encoded => fnd_api.g_false

382: -- Standard call to get message count and if count is 1, get message info
383: FND_MSG_PUB.Count_And_Get
384: ( p_count => x_msg_count,
385: p_data => x_msg_data,
386: p_encoded => fnd_api.g_false
387: );
388: EXCEPTION
389: WHEN FND_API.G_EXC_ERROR THEN
390: Rollback to Create_Position_ID_pvt;

Line 389: WHEN FND_API.G_EXC_ERROR THEN

385: p_data => x_msg_data,
386: p_encoded => fnd_api.g_false
387: );
388: EXCEPTION
389: WHEN FND_API.G_EXC_ERROR THEN
390: Rollback to Create_Position_ID_pvt;
391: x_return_status := FND_API.G_RET_STS_ERROR;
392: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
393: p_data => x_msg_data,

Line 391: x_return_status := FND_API.G_RET_STS_ERROR;

387: );
388: EXCEPTION
389: WHEN FND_API.G_EXC_ERROR THEN
390: Rollback to Create_Position_ID_pvt;
391: x_return_status := FND_API.G_RET_STS_ERROR;
392: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
393: p_data => x_msg_data,
394: p_encoded => fnd_api.g_false);
395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 394: p_encoded => fnd_api.g_false);

390: Rollback to Create_Position_ID_pvt;
391: x_return_status := FND_API.G_RET_STS_ERROR;
392: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
393: p_data => x_msg_data,
394: p_encoded => fnd_api.g_false);
395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
396: Rollback to Create_Position_ID_pvt;
397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
398: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

391: x_return_status := FND_API.G_RET_STS_ERROR;
392: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
393: p_data => x_msg_data,
394: p_encoded => fnd_api.g_false);
395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
396: Rollback to Create_Position_ID_pvt;
397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
398: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
399: p_data => x_msg_data,

Line 397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

393: p_data => x_msg_data,
394: p_encoded => fnd_api.g_false);
395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
396: Rollback to Create_Position_ID_pvt;
397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
398: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
399: p_data => x_msg_data,
400: p_encoded => fnd_api.g_false);
401: WHEN OTHERS THEN

Line 400: p_encoded => fnd_api.g_false);

396: Rollback to Create_Position_ID_pvt;
397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
398: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
399: p_data => x_msg_data,
400: p_encoded => fnd_api.g_false);
401: WHEN OTHERS THEN
402: Rollback to Create_Position_ID_pvt;
403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
404: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

Line 403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

399: p_data => x_msg_data,
400: p_encoded => fnd_api.g_false);
401: WHEN OTHERS THEN
402: Rollback to Create_Position_ID_pvt;
403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
404: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
405: p_procedure_name => l_api_name,
406: p_error_text => SQLERRM);
407: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 409: p_encoded => fnd_api.g_false);

405: p_procedure_name => l_api_name,
406: p_error_text => SQLERRM);
407: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
408: p_data => x_msg_data,
409: p_encoded => fnd_api.g_false);
410:
411: END Create_Position_ID;
412:
413: -----------------------------

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

425: -- End of Comments.
426:
427: PROCEDURE Map_Instance_To_Positions (
428: p_api_version IN NUMBER,
429: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
430: p_commit IN VARCHAR2 := FND_API.G_FALSE,
431: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
432: x_return_status OUT NOCOPY VARCHAR2,
433: x_msg_count OUT NOCOPY NUMBER,

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

426:
427: PROCEDURE Map_Instance_To_Positions (
428: p_api_version IN NUMBER,
429: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
430: p_commit IN VARCHAR2 := FND_API.G_FALSE,
431: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
432: x_return_status OUT NOCOPY VARCHAR2,
433: x_msg_count OUT NOCOPY NUMBER,
434: x_msg_data OUT NOCOPY VARCHAR2,

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

427: PROCEDURE Map_Instance_To_Positions (
428: p_api_version IN NUMBER,
429: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
430: p_commit IN VARCHAR2 := FND_API.G_FALSE,
431: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
432: x_return_status OUT NOCOPY VARCHAR2,
433: x_msg_count OUT NOCOPY NUMBER,
434: x_msg_data OUT NOCOPY VARCHAR2,
435: p_csi_item_instance_id IN NUMBER)

Line 509: x_return_status := FND_API.G_RET_STS_SUCCESS;

505: -- Standard start of API savepoint
506: SAVEPOINT Map_Instance_To_Positions_pvt;
507:
508: -- Initialize Procedure return status to success
509: x_return_status := FND_API.G_RET_STS_SUCCESS;
510: -- Standard call to check for call compatibility
511: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
512: G_PKG_NAME) THEN
513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 511: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

507:
508: -- Initialize Procedure return status to success
509: x_return_status := FND_API.G_RET_STS_SUCCESS;
510: -- Standard call to check for call compatibility
511: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
512: G_PKG_NAME) THEN
513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
514: END IF;
515:

Line 513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

509: x_return_status := FND_API.G_RET_STS_SUCCESS;
510: -- Standard call to check for call compatibility
511: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
512: G_PKG_NAME) THEN
513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
514: END IF;
515:
516: -- Initialize message list if p_init_msg_list is set to TRUE
517: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 517: IF FND_API.To_Boolean(p_init_msg_list) THEN

513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
514: END IF;
515:
516: -- Initialize message list if p_init_msg_list is set to TRUE
517: IF FND_API.To_Boolean(p_init_msg_list) THEN
518: FND_MSG_PUB.Initialize;
519: END IF;
520:
521: --Fetch the position informations for the instance

Line 614: p_encoded => fnd_api.g_false

610: -- Standard call to get message count and if count is 1, get message info
611: FND_MSG_PUB.Count_And_Get
612: ( p_count => x_msg_count,
613: p_data => x_msg_data,
614: p_encoded => fnd_api.g_false
615: );
616: EXCEPTION
617: WHEN FND_API.G_EXC_ERROR THEN
618: Rollback to Map_Instance_To_Positions_pvt;

Line 617: WHEN FND_API.G_EXC_ERROR THEN

613: p_data => x_msg_data,
614: p_encoded => fnd_api.g_false
615: );
616: EXCEPTION
617: WHEN FND_API.G_EXC_ERROR THEN
618: Rollback to Map_Instance_To_Positions_pvt;
619: x_return_status := FND_API.G_RET_STS_ERROR;
620: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
621: p_data => x_msg_data,

Line 619: x_return_status := FND_API.G_RET_STS_ERROR;

615: );
616: EXCEPTION
617: WHEN FND_API.G_EXC_ERROR THEN
618: Rollback to Map_Instance_To_Positions_pvt;
619: x_return_status := FND_API.G_RET_STS_ERROR;
620: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
621: p_data => x_msg_data,
622: p_encoded => fnd_api.g_false);
623: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 622: p_encoded => fnd_api.g_false);

618: Rollback to Map_Instance_To_Positions_pvt;
619: x_return_status := FND_API.G_RET_STS_ERROR;
620: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
621: p_data => x_msg_data,
622: p_encoded => fnd_api.g_false);
623: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
624: Rollback to Map_Instance_To_Positions_pvt;
625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
626: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 623: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

619: x_return_status := FND_API.G_RET_STS_ERROR;
620: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
621: p_data => x_msg_data,
622: p_encoded => fnd_api.g_false);
623: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
624: Rollback to Map_Instance_To_Positions_pvt;
625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
626: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
627: p_data => x_msg_data,

Line 625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

621: p_data => x_msg_data,
622: p_encoded => fnd_api.g_false);
623: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
624: Rollback to Map_Instance_To_Positions_pvt;
625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
626: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
627: p_data => x_msg_data,
628: p_encoded => fnd_api.g_false);
629: WHEN OTHERS THEN

Line 628: p_encoded => fnd_api.g_false);

624: Rollback to Map_Instance_To_Positions_pvt;
625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
626: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
627: p_data => x_msg_data,
628: p_encoded => fnd_api.g_false);
629: WHEN OTHERS THEN
630: Rollback to Map_Instance_To_Positions_pvt;
631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
632: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

Line 631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

627: p_data => x_msg_data,
628: p_encoded => fnd_api.g_false);
629: WHEN OTHERS THEN
630: Rollback to Map_Instance_To_Positions_pvt;
631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
632: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
633: p_procedure_name => l_api_name,
634: p_error_text => SQLERRM);
635: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 637: p_encoded => fnd_api.g_false);

633: p_procedure_name => l_api_name,
634: p_error_text => SQLERRM);
635: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
636: p_data => x_msg_data,
637: p_encoded => fnd_api.g_false);
638: END Map_Instance_To_Positions;
639:
640:
641: -----------------------------

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

653: -- End of Comments.
654:
655: PROCEDURE Map_Position_To_Instances (
656: p_api_version IN NUMBER,
657: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
658: p_commit IN VARCHAR2 := FND_API.G_FALSE,
659: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
660: x_return_status OUT NOCOPY VARCHAR2,
661: x_msg_count OUT NOCOPY NUMBER,

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

654:
655: PROCEDURE Map_Position_To_Instances (
656: p_api_version IN NUMBER,
657: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
658: p_commit IN VARCHAR2 := FND_API.G_FALSE,
659: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
660: x_return_status OUT NOCOPY VARCHAR2,
661: x_msg_count OUT NOCOPY NUMBER,
662: x_msg_data OUT NOCOPY VARCHAR2,

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

655: PROCEDURE Map_Position_To_Instances (
656: p_api_version IN NUMBER,
657: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
658: p_commit IN VARCHAR2 := FND_API.G_FALSE,
659: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
660: x_return_status OUT NOCOPY VARCHAR2,
661: x_msg_count OUT NOCOPY NUMBER,
662: x_msg_data OUT NOCOPY VARCHAR2,
663: p_position_id IN NUMBER)

Line 713: x_return_status := FND_API.G_RET_STS_SUCCESS;

709: -- Standard start of API savepoint
710: SAVEPOINT map_position_to_instances_pvt;
711:
712: -- Initialize Procedure return status to success
713: x_return_status := FND_API.G_RET_STS_SUCCESS;
714: -- Standard call to check for call compatibility
715: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
716: G_PKG_NAME) THEN
717: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 715: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

711:
712: -- Initialize Procedure return status to success
713: x_return_status := FND_API.G_RET_STS_SUCCESS;
714: -- Standard call to check for call compatibility
715: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
716: G_PKG_NAME) THEN
717: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
718: END IF;
719:

Line 717: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

713: x_return_status := FND_API.G_RET_STS_SUCCESS;
714: -- Standard call to check for call compatibility
715: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
716: G_PKG_NAME) THEN
717: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
718: END IF;
719:
720: -- Initialize message list if p_init_msg_list is set to TRUE
721: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 721: IF FND_API.To_Boolean(p_init_msg_list) THEN

717: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
718: END IF;
719:
720: -- Initialize message list if p_init_msg_list is set to TRUE
721: IF FND_API.To_Boolean(p_init_msg_list) THEN
722: FND_MSG_PUB.Initialize;
723: END IF;
724:
725: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 868: IF FND_API.TO_BOOLEAN(p_commit) THEN

864:
865: DBMS_SQL.CLOSE_CURSOR(v_CursorID);
866:
867: -- Standard check of p_commit
868: IF FND_API.TO_BOOLEAN(p_commit) THEN
869: COMMIT WORK;
870: END IF;
871:
872: -- Standard call to get message count and if count is 1, get message info

Line 876: p_encoded => fnd_api.g_false

872: -- Standard call to get message count and if count is 1, get message info
873: FND_MSG_PUB.Count_And_Get
874: ( p_count => x_msg_count,
875: p_data => x_msg_data,
876: p_encoded => fnd_api.g_false
877: );
878:
879: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
880: fnd_log.string(fnd_log.level_procedure,L_FULL_NAME||'.end','At the end of PLSQL procedure');

Line 884: WHEN FND_API.G_EXC_ERROR THEN

880: fnd_log.string(fnd_log.level_procedure,L_FULL_NAME||'.end','At the end of PLSQL procedure');
881: END IF;
882:
883: EXCEPTION
884: WHEN FND_API.G_EXC_ERROR THEN
885: Rollback to map_position_to_instances_pvt;
886: x_return_status := FND_API.G_RET_STS_ERROR;
887: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
888: p_data => x_msg_data,

Line 886: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 889: p_encoded => fnd_api.g_false);

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

Line 890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

888: p_data => x_msg_data,
889: p_encoded => fnd_api.g_false);
890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
891: Rollback to map_position_to_instances_pvt;
892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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: WHEN OTHERS THEN

Line 895: p_encoded => fnd_api.g_false);

891: Rollback to map_position_to_instances_pvt;
892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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: WHEN OTHERS THEN
897: Rollback to map_position_to_instances_pvt;
898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
899: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

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: WHEN OTHERS THEN
897: Rollback to map_position_to_instances_pvt;
898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
899: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
900: p_procedure_name => l_api_name,
901: p_error_text => SQLERRM);
902: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 904: p_encoded => fnd_api.g_false);

900: p_procedure_name => l_api_name,
901: p_error_text => SQLERRM);
902: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
903: p_data => x_msg_data,
904: p_encoded => fnd_api.g_false);
905: END Map_Position_To_Instances;
906:
907: -----------------------------
908: -- Start of Comments --

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

925: -- End of Comments.
926:
927: PROCEDURE Get_Pos_Instance (
928: p_api_version IN NUMBER,
929: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
930: p_commit IN VARCHAR2 := FND_API.G_FALSE,
931: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
932: x_return_status OUT NOCOPY VARCHAR2,
933: x_msg_count OUT NOCOPY NUMBER,

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

926:
927: PROCEDURE Get_Pos_Instance (
928: p_api_version IN NUMBER,
929: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
930: p_commit IN VARCHAR2 := FND_API.G_FALSE,
931: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
932: x_return_status OUT NOCOPY VARCHAR2,
933: x_msg_count OUT NOCOPY NUMBER,
934: x_msg_data OUT NOCOPY VARCHAR2,

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

927: PROCEDURE Get_Pos_Instance (
928: p_api_version IN NUMBER,
929: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
930: p_commit IN VARCHAR2 := FND_API.G_FALSE,
931: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
932: x_return_status OUT NOCOPY VARCHAR2,
933: x_msg_count OUT NOCOPY NUMBER,
934: x_msg_data OUT NOCOPY VARCHAR2,
935: p_position_id IN NUMBER,

Line 1080: x_return_status := FND_API.G_RET_STS_SUCCESS;

1076: fnd_log.string(fnd_log.level_procedure, l_full_name||'.begin', 'At the start of PLSQL procedure. p_csi_item_instance_id = ' || p_csi_item_instance_id ||
1077: ', p_position_id = ' || p_position_id);
1078: END IF;
1079: -- Initialize Procedure return status to success
1080: x_return_status := FND_API.G_RET_STS_SUCCESS;
1081: x_mapping_status := 'NULL';
1082:
1083: -- Standard call to check for call compatibility
1084: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

Line 1084: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

1080: x_return_status := FND_API.G_RET_STS_SUCCESS;
1081: x_mapping_status := 'NULL';
1082:
1083: -- Standard call to check for call compatibility
1084: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1085: G_PKG_NAME) THEN
1086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1087: END IF;
1088:

Line 1086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1082:
1083: -- Standard call to check for call compatibility
1084: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1085: G_PKG_NAME) THEN
1086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1087: END IF;
1088:
1089: -- Initialize message list if p_init_msg_list is set to TRUE
1090: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 1090: IF FND_API.To_Boolean(p_init_msg_list) THEN

1086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1087: END IF;
1088:
1089: -- Initialize message list if p_init_msg_list is set to TRUE
1090: IF FND_API.To_Boolean(p_init_msg_list) THEN
1091: FND_MSG_PUB.Initialize;
1092: END IF;
1093:
1094: --Step 0) Validate that p_csi_item_instance is not null and valid

Line 1098: RAISE FND_API.G_EXC_ERROR;

1094: --Step 0) Validate that p_csi_item_instance is not null and valid
1095: IF (p_csi_item_instance_id IS NULL) THEN
1096: FND_MESSAGE.Set_Name('AHL','AHL_MC_POS_INSTANCE_ID_NULL');
1097: FND_MSG_PUB.ADD;
1098: RAISE FND_API.G_EXC_ERROR;
1099: END IF;
1100: --Validate that the input instance is a unit
1101: OPEN check_instance_top_csr (p_csi_item_instance_id);
1102: FETCH check_instance_top_csr INTO l_dummy;

Line 1106: RAISE FND_API.G_EXC_ERROR;

1102: FETCH check_instance_top_csr INTO l_dummy;
1103: IF (check_instance_top_csr%NOTFOUND) THEN
1104: FND_MESSAGE.Set_Name('AHL','AHL_MC_POS_INSTANCE_ID_INV');
1105: FND_MSG_PUB.ADD;
1106: RAISE FND_API.G_EXC_ERROR;
1107: END IF;
1108: CLOSE check_instance_top_csr;
1109:
1110: --Step 1) Build the path position table object based on path position id

Line 1130: RAISE FND_API.G_EXC_ERROR;

1126: --If table is less than 1 in size, this is invalid path
1127: IF (l_path_tbl.COUNT<1) THEN
1128: FND_MESSAGE.Set_Name('AHL','AHL_MC_POS_PATH_ID_INV');
1129: FND_MSG_PUB.ADD;
1130: RAISE FND_API.G_EXC_ERROR;
1131:
1132: --If there is only 1 row, then lowest level UC = p_csi_instance_id
1133: ELSIF (l_path_tbl.COUNT =1) THEN
1134: OPEN check_top_mc_csr ( p_csi_item_instance_id,

Line 1255: p_encoded => fnd_api.g_false

1251: -- Standard call to get message count and if count is 1, get message info
1252: FND_MSG_PUB.Count_And_Get
1253: ( p_count => x_msg_count,
1254: p_data => x_msg_data,
1255: p_encoded => fnd_api.g_false
1256: );
1257: EXCEPTION
1258: WHEN FND_API.G_EXC_ERROR THEN
1259: Rollback to Get_Pos_Empty_Instance_pvt;

Line 1258: WHEN FND_API.G_EXC_ERROR THEN

1254: p_data => x_msg_data,
1255: p_encoded => fnd_api.g_false
1256: );
1257: EXCEPTION
1258: WHEN FND_API.G_EXC_ERROR THEN
1259: Rollback to Get_Pos_Empty_Instance_pvt;
1260: x_return_status := FND_API.G_RET_STS_ERROR;
1261: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1262: p_data => x_msg_data,

Line 1260: x_return_status := FND_API.G_RET_STS_ERROR;

1256: );
1257: EXCEPTION
1258: WHEN FND_API.G_EXC_ERROR THEN
1259: Rollback to Get_Pos_Empty_Instance_pvt;
1260: x_return_status := FND_API.G_RET_STS_ERROR;
1261: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1262: p_data => x_msg_data,
1263: p_encoded => fnd_api.g_false);
1264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1263: p_encoded => fnd_api.g_false);

1259: Rollback to Get_Pos_Empty_Instance_pvt;
1260: x_return_status := FND_API.G_RET_STS_ERROR;
1261: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1262: p_data => x_msg_data,
1263: p_encoded => fnd_api.g_false);
1264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1265: Rollback to Get_Pos_Empty_Instance_pvt;
1266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1267: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 1264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1260: x_return_status := FND_API.G_RET_STS_ERROR;
1261: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1262: p_data => x_msg_data,
1263: p_encoded => fnd_api.g_false);
1264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1265: Rollback to Get_Pos_Empty_Instance_pvt;
1266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1267: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1268: p_data => x_msg_data,

Line 1266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1262: p_data => x_msg_data,
1263: p_encoded => fnd_api.g_false);
1264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1265: Rollback to Get_Pos_Empty_Instance_pvt;
1266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1267: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1268: p_data => x_msg_data,
1269: p_encoded => fnd_api.g_false);
1270: WHEN OTHERS THEN

Line 1269: p_encoded => fnd_api.g_false);

1265: Rollback to Get_Pos_Empty_Instance_pvt;
1266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1267: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1268: p_data => x_msg_data,
1269: p_encoded => fnd_api.g_false);
1270: WHEN OTHERS THEN
1271: Rollback to Get_Pos_Empty_Instance_pvt;
1272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1273: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

Line 1272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1268: p_data => x_msg_data,
1269: p_encoded => fnd_api.g_false);
1270: WHEN OTHERS THEN
1271: Rollback to Get_Pos_Empty_Instance_pvt;
1272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1273: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
1274: p_procedure_name => l_api_name,
1275: p_error_text => SQLERRM);
1276: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 1278: p_encoded => fnd_api.g_false);

1274: p_procedure_name => l_api_name,
1275: p_error_text => SQLERRM);
1276: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1277: p_data => x_msg_data,
1278: p_encoded => fnd_api.g_false);
1279: END Get_Pos_Instance;
1280:
1281: ----------------------------
1282: -- Start of Comments --

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

1297: -- End of Comments.
1298:
1299: PROCEDURE Get_Pos_Instance (
1300: p_api_version IN NUMBER,
1301: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1302: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1303: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1304: x_return_status OUT NOCOPY VARCHAR2,
1305: x_msg_count OUT NOCOPY NUMBER,

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

1298:
1299: PROCEDURE Get_Pos_Instance (
1300: p_api_version IN NUMBER,
1301: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1302: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1303: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1304: x_return_status OUT NOCOPY VARCHAR2,
1305: x_msg_count OUT NOCOPY NUMBER,
1306: x_msg_data OUT NOCOPY VARCHAR2,

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

1299: PROCEDURE Get_Pos_Instance (
1300: p_api_version IN NUMBER,
1301: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1302: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1303: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1304: x_return_status OUT NOCOPY VARCHAR2,
1305: x_msg_count OUT NOCOPY NUMBER,
1306: x_msg_data OUT NOCOPY VARCHAR2,
1307: p_position_id IN NUMBER,

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

1362: -- End of Comments.
1363:
1364: PROCEDURE Copy_Positions_For_MC (
1365: p_api_version IN NUMBER,
1366: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1367: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1368: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1369: x_return_status OUT NOCOPY VARCHAR2,
1370: x_msg_count OUT NOCOPY NUMBER,

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

1363:
1364: PROCEDURE Copy_Positions_For_MC (
1365: p_api_version IN NUMBER,
1366: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1367: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1368: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1369: x_return_status OUT NOCOPY VARCHAR2,
1370: x_msg_count OUT NOCOPY NUMBER,
1371: x_msg_data OUT NOCOPY VARCHAR2,

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

1364: PROCEDURE Copy_Positions_For_MC (
1365: p_api_version IN NUMBER,
1366: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1367: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1368: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1369: x_return_status OUT NOCOPY VARCHAR2,
1370: x_msg_count OUT NOCOPY NUMBER,
1371: x_msg_data OUT NOCOPY VARCHAR2,
1372: p_from_mc_header_id IN NUMBER,

Line 1417: x_return_status := FND_API.G_RET_STS_SUCCESS;

1413: -- Standard start of API savepoint
1414: SAVEPOINT Copy_Positions_For_Mc_pvt;
1415:
1416: -- Initialize Procedure return status to success
1417: x_return_status := FND_API.G_RET_STS_SUCCESS;
1418: -- Standard call to check for call compatibility
1419: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1420: G_PKG_NAME) THEN
1421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1419: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

1415:
1416: -- Initialize Procedure return status to success
1417: x_return_status := FND_API.G_RET_STS_SUCCESS;
1418: -- Standard call to check for call compatibility
1419: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1420: G_PKG_NAME) THEN
1421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1422: END IF;
1423:

Line 1421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1417: x_return_status := FND_API.G_RET_STS_SUCCESS;
1418: -- Standard call to check for call compatibility
1419: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1420: G_PKG_NAME) THEN
1421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1422: END IF;
1423:
1424: -- Initialize message list if p_init_msg_list is set to TRUE
1425: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 1425: IF FND_API.To_Boolean(p_init_msg_list) THEN

1421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1422: END IF;
1423:
1424: -- Initialize message list if p_init_msg_list is set to TRUE
1425: IF FND_API.To_Boolean(p_init_msg_list) THEN
1426: FND_MSG_PUB.Initialize;
1427: END IF;
1428:
1429: --Check Status of MC allows for editing

Line 1437: RAISE FND_API.G_EXC_ERROR;

1433: FND_MESSAGE.Set_Name('AHL','AHL_UC_MC_HEADER_ID_INVALID');
1434: FND_MESSAGE.Set_Token('MC_HEADER_ID',p_to_mc_header_id);
1435: FND_MSG_PUB.ADD;
1436: CLOSE check_mc_status_csr;
1437: RAISE FND_API.G_EXC_ERROR;
1438: ELSIF ( l_status_code <> 'DRAFT' AND
1439: l_status_code <> 'APPROVAL_REJECTED') THEN
1440: FND_MESSAGE.Set_Name('AHL','AHL_MC_EDIT_INV_MC');
1441: FND_MESSAGE.Set_Token('STATUS', l_status);

Line 1444: RAISE FND_API.G_EXC_ERROR;

1440: FND_MESSAGE.Set_Name('AHL','AHL_MC_EDIT_INV_MC');
1441: FND_MESSAGE.Set_Token('STATUS', l_status);
1442: FND_MSG_PUB.ADD;
1443: CLOSE check_mc_status_csr;
1444: RAISE FND_API.G_EXC_ERROR;
1445: END IF;
1446: CLOSE check_mc_status_csr;
1447:
1448: --Copy all version specific paths

Line 1456: p_commit => FND_API.G_FALSE,

1452: EXIT WHEN get_ver_position_ids_csr%NOTFOUND;
1453:
1454: Copy_Position (
1455: p_api_version => 1.0,
1456: p_commit => FND_API.G_FALSE,
1457: p_position_id => l_position_id,
1458: p_to_mc_header_id => p_to_mc_header_id,
1459: x_position_id => l_new_position_id,
1460: x_return_status => x_return_status,

Line 1464: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1460: x_return_status => x_return_status,
1461: x_msg_count => x_msg_count,
1462: x_msg_data => x_msg_data);
1463: -- Check return status.
1464: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1465: RAISE FND_API.G_EXC_ERROR;
1466: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1468: END IF;

Line 1465: RAISE FND_API.G_EXC_ERROR;

1461: x_msg_count => x_msg_count,
1462: x_msg_data => x_msg_data);
1463: -- Check return status.
1464: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1465: RAISE FND_API.G_EXC_ERROR;
1466: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1468: END IF;
1469: END LOOP;

Line 1466: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1462: x_msg_data => x_msg_data);
1463: -- Check return status.
1464: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1465: RAISE FND_API.G_EXC_ERROR;
1466: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1468: END IF;
1469: END LOOP;
1470: CLOSE get_ver_position_ids_csr;

Line 1467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1463: -- Check return status.
1464: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1465: RAISE FND_API.G_EXC_ERROR;
1466: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1468: END IF;
1469: END LOOP;
1470: CLOSE get_ver_position_ids_csr;
1471:

Line 1489: p_commit => FND_API.G_FALSE,

1485: EXIT WHEN get_nover_position_ids_csr%NOTFOUND;
1486:
1487: Copy_Position (
1488: p_api_version => 1.0,
1489: p_commit => FND_API.G_FALSE,
1490: p_position_id => l_position_id,
1491: p_to_mc_header_id => p_to_mc_header_id,
1492: x_position_id => l_new_position_id,
1493: x_return_status => x_return_status,

Line 1497: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1493: x_return_status => x_return_status,
1494: x_msg_count => x_msg_count,
1495: x_msg_data => x_msg_data);
1496: -- Check return status.
1497: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1498: RAISE FND_API.G_EXC_ERROR;
1499: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1501: END IF;

Line 1498: RAISE FND_API.G_EXC_ERROR;

1494: x_msg_count => x_msg_count,
1495: x_msg_data => x_msg_data);
1496: -- Check return status.
1497: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1498: RAISE FND_API.G_EXC_ERROR;
1499: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1501: END IF;
1502: END LOOP;

Line 1499: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1495: x_msg_data => x_msg_data);
1496: -- Check return status.
1497: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1498: RAISE FND_API.G_EXC_ERROR;
1499: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1501: END IF;
1502: END LOOP;
1503: CLOSE get_nover_position_ids_csr;

Line 1500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1496: -- Check return status.
1497: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1498: RAISE FND_API.G_EXC_ERROR;
1499: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1501: END IF;
1502: END LOOP;
1503: CLOSE get_nover_position_ids_csr;
1504: END IF;

Line 1507: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1503: CLOSE get_nover_position_ids_csr;
1504: END IF;
1505:
1506: -- Check return status.
1507: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1508: RAISE FND_API.G_EXC_ERROR;
1509: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1511: END IF;

Line 1508: RAISE FND_API.G_EXC_ERROR;

1504: END IF;
1505:
1506: -- Check return status.
1507: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1508: RAISE FND_API.G_EXC_ERROR;
1509: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1511: END IF;
1512:

Line 1509: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1505:
1506: -- Check return status.
1507: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1508: RAISE FND_API.G_EXC_ERROR;
1509: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1511: END IF;
1512:
1513:

Line 1510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1506: -- Check return status.
1507: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1508: RAISE FND_API.G_EXC_ERROR;
1509: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1511: END IF;
1512:
1513:
1514: -- Standard check of p_commit

Line 1515: IF FND_API.TO_BOOLEAN(p_commit) THEN

1511: END IF;
1512:
1513:
1514: -- Standard check of p_commit
1515: IF FND_API.TO_BOOLEAN(p_commit) THEN
1516: COMMIT WORK;
1517: END IF;
1518: -- Standard call to get message count and if count is 1, get message info
1519: FND_MSG_PUB.Count_And_Get

Line 1522: p_encoded => fnd_api.g_false

1518: -- Standard call to get message count and if count is 1, get message info
1519: FND_MSG_PUB.Count_And_Get
1520: ( p_count => x_msg_count,
1521: p_data => x_msg_data,
1522: p_encoded => fnd_api.g_false
1523: );
1524: EXCEPTION
1525: WHEN FND_API.G_EXC_ERROR THEN
1526: Rollback to Copy_Positions_For_Mc_pvt;

Line 1525: WHEN FND_API.G_EXC_ERROR THEN

1521: p_data => x_msg_data,
1522: p_encoded => fnd_api.g_false
1523: );
1524: EXCEPTION
1525: WHEN FND_API.G_EXC_ERROR THEN
1526: Rollback to Copy_Positions_For_Mc_pvt;
1527: x_return_status := FND_API.G_RET_STS_ERROR;
1528: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1529: p_data => x_msg_data,

Line 1527: x_return_status := FND_API.G_RET_STS_ERROR;

1523: );
1524: EXCEPTION
1525: WHEN FND_API.G_EXC_ERROR THEN
1526: Rollback to Copy_Positions_For_Mc_pvt;
1527: x_return_status := FND_API.G_RET_STS_ERROR;
1528: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1529: p_data => x_msg_data,
1530: p_encoded => fnd_api.g_false);
1531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1530: p_encoded => fnd_api.g_false);

1526: Rollback to Copy_Positions_For_Mc_pvt;
1527: x_return_status := FND_API.G_RET_STS_ERROR;
1528: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1529: p_data => x_msg_data,
1530: p_encoded => fnd_api.g_false);
1531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1532: Rollback to Copy_Positions_For_Mc_pvt;
1533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1534: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 1531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1527: x_return_status := FND_API.G_RET_STS_ERROR;
1528: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1529: p_data => x_msg_data,
1530: p_encoded => fnd_api.g_false);
1531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1532: Rollback to Copy_Positions_For_Mc_pvt;
1533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1534: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1535: p_data => x_msg_data,

Line 1533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1529: p_data => x_msg_data,
1530: p_encoded => fnd_api.g_false);
1531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1532: Rollback to Copy_Positions_For_Mc_pvt;
1533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1534: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1535: p_data => x_msg_data,
1536: p_encoded => fnd_api.g_false);
1537: WHEN OTHERS THEN

Line 1536: p_encoded => fnd_api.g_false);

1532: Rollback to Copy_Positions_For_Mc_pvt;
1533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1534: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1535: p_data => x_msg_data,
1536: p_encoded => fnd_api.g_false);
1537: WHEN OTHERS THEN
1538: Rollback to Copy_Positions_For_Mc_pvt;
1539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1540: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

Line 1539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1535: p_data => x_msg_data,
1536: p_encoded => fnd_api.g_false);
1537: WHEN OTHERS THEN
1538: Rollback to Copy_Positions_For_Mc_pvt;
1539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1540: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
1541: p_procedure_name => l_api_name,
1542: p_error_text => SQLERRM);
1543: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 1545: p_encoded => fnd_api.g_false);

1541: p_procedure_name => l_api_name,
1542: p_error_text => SQLERRM);
1543: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1544: p_data => x_msg_data,
1545: p_encoded => fnd_api.g_false);
1546: END Copy_Positions_For_MC;
1547:
1548: -----------------------------
1549: -- Start of Comments --

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

1561: -- End of Comments.
1562:
1563: PROCEDURE Copy_Position (
1564: p_api_version IN NUMBER,
1565: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1566: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1567: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1568: x_return_status OUT NOCOPY VARCHAR2,
1569: x_msg_count OUT NOCOPY NUMBER,

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

1562:
1563: PROCEDURE Copy_Position (
1564: p_api_version IN NUMBER,
1565: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1566: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1567: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1568: x_return_status OUT NOCOPY VARCHAR2,
1569: x_msg_count OUT NOCOPY NUMBER,
1570: x_msg_data OUT NOCOPY VARCHAR2,

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

1563: PROCEDURE Copy_Position (
1564: p_api_version IN NUMBER,
1565: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1566: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1567: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1568: x_return_status OUT NOCOPY VARCHAR2,
1569: x_msg_count OUT NOCOPY NUMBER,
1570: x_msg_data OUT NOCOPY VARCHAR2,
1571: p_position_id IN NUMBER,

Line 1610: x_return_status := FND_API.G_RET_STS_SUCCESS;

1606: -- Standard start of API savepoint
1607: SAVEPOINT Copy_Position_pvt;
1608:
1609: -- Initialize Procedure return status to success
1610: x_return_status := FND_API.G_RET_STS_SUCCESS;
1611: -- Standard call to check for call compatibility
1612: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1613: G_PKG_NAME) THEN
1614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1612: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

1608:
1609: -- Initialize Procedure return status to success
1610: x_return_status := FND_API.G_RET_STS_SUCCESS;
1611: -- Standard call to check for call compatibility
1612: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1613: G_PKG_NAME) THEN
1614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1615: END IF;
1616:

Line 1614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1610: x_return_status := FND_API.G_RET_STS_SUCCESS;
1611: -- Standard call to check for call compatibility
1612: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1613: G_PKG_NAME) THEN
1614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1615: END IF;
1616:
1617: -- Initialize message list if p_init_msg_list is set to TRUE
1618: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 1618: IF FND_API.To_Boolean(p_init_msg_list) THEN

1614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1615: END IF;
1616:
1617: -- Initialize message list if p_init_msg_list is set to TRUE
1618: IF FND_API.To_Boolean(p_init_msg_list) THEN
1619: FND_MSG_PUB.Initialize;
1620: END IF;
1621:
1622: --Fetch the to mc_header_id information

Line 1631: RAISE FND_API.G_EXC_ERROR;

1627: FND_MESSAGE.Set_Token('NAME','');
1628: FND_MESSAGE.Set_Token('MC_HEADER_ID',p_to_mc_header_id);
1629: FND_MSG_PUB.ADD;
1630: CLOSE get_mc_id_ver_csr;
1631: RAISE FND_API.G_EXC_ERROR;
1632: END IF;
1633: CLOSE get_mc_id_ver_csr;
1634:
1635: --Fetch the position path information

Line 1685: RAISE FND_API.G_EXC_ERROR;

1681:
1682: -- Check Error Message stack.
1683: x_msg_count := FND_MSG_PUB.count_msg;
1684: IF x_msg_count > 0 THEN
1685: RAISE FND_API.G_EXC_ERROR;
1686: END IF;
1687:
1688: --Create position with new error message stack.
1689: --This stack will not be useful

Line 1692: p_init_msg_list => FND_API.G_TRUE,

1688: --Create position with new error message stack.
1689: --This stack will not be useful
1690: Create_Position_ID (
1691: p_api_version => 1.0,
1692: p_init_msg_list => FND_API.G_TRUE,
1693: p_commit => FND_API.G_FALSE,
1694: p_path_position_tbl => l_pos_tbl,
1695: p_position_ref_meaning => FND_API.G_MISS_CHAR,
1696: p_position_ref_code => l_pos_ref_code,

Line 1693: p_commit => FND_API.G_FALSE,

1689: --This stack will not be useful
1690: Create_Position_ID (
1691: p_api_version => 1.0,
1692: p_init_msg_list => FND_API.G_TRUE,
1693: p_commit => FND_API.G_FALSE,
1694: p_path_position_tbl => l_pos_tbl,
1695: p_position_ref_meaning => FND_API.G_MISS_CHAR,
1696: p_position_ref_code => l_pos_ref_code,
1697: x_position_id => x_position_id,

Line 1695: p_position_ref_meaning => FND_API.G_MISS_CHAR,

1691: p_api_version => 1.0,
1692: p_init_msg_list => FND_API.G_TRUE,
1693: p_commit => FND_API.G_FALSE,
1694: p_path_position_tbl => l_pos_tbl,
1695: p_position_ref_meaning => FND_API.G_MISS_CHAR,
1696: p_position_ref_code => l_pos_ref_code,
1697: x_position_id => x_position_id,
1698: x_return_status => l_return_status,
1699: x_msg_count => l_msg_count,

Line 1703: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1699: x_msg_count => l_msg_count,
1700: x_msg_data => l_msg_data);
1701:
1702: -- Suppress the validation errors from Create API.
1703: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1704: --Suppress the expected errors
1705: --Clean out the messages
1706: FND_MSG_PUB.Initialize;
1707: x_position_id := null;

Line 1708: x_return_status := FND_API.G_RET_STS_SUCCESS;

1704: --Suppress the expected errors
1705: --Clean out the messages
1706: FND_MSG_PUB.Initialize;
1707: x_position_id := null;
1708: x_return_status := FND_API.G_RET_STS_SUCCESS;
1709: x_msg_count := 0;
1710: x_msg_data := null;
1711: ELSE
1712: --Use normal error handling

Line 1719: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1715: x_msg_data := l_msg_data;
1716: END IF;
1717:
1718: -- Check return status.
1719: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1720: RAISE FND_API.G_EXC_ERROR;
1721: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1723: END IF;

Line 1720: RAISE FND_API.G_EXC_ERROR;

1716: END IF;
1717:
1718: -- Check return status.
1719: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1720: RAISE FND_API.G_EXC_ERROR;
1721: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1723: END IF;
1724:

Line 1721: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1717:
1718: -- Check return status.
1719: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1720: RAISE FND_API.G_EXC_ERROR;
1721: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1723: END IF;
1724:
1725: -- Standard check of p_commit

Line 1722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1718: -- Check return status.
1719: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1720: RAISE FND_API.G_EXC_ERROR;
1721: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1723: END IF;
1724:
1725: -- Standard check of p_commit
1726: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 1726: IF FND_API.TO_BOOLEAN(p_commit) THEN

1722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1723: END IF;
1724:
1725: -- Standard check of p_commit
1726: IF FND_API.TO_BOOLEAN(p_commit) THEN
1727: COMMIT WORK;
1728: END IF;
1729:
1730: -- Standard call to get message count and if count is 1, get message info

Line 1734: p_encoded => fnd_api.g_false

1730: -- Standard call to get message count and if count is 1, get message info
1731: FND_MSG_PUB.Count_And_Get
1732: ( p_count => x_msg_count,
1733: p_data => x_msg_data,
1734: p_encoded => fnd_api.g_false
1735: );
1736: EXCEPTION
1737: WHEN FND_API.G_EXC_ERROR THEN
1738: Rollback to Copy_Position_pvt;

Line 1737: WHEN FND_API.G_EXC_ERROR THEN

1733: p_data => x_msg_data,
1734: p_encoded => fnd_api.g_false
1735: );
1736: EXCEPTION
1737: WHEN FND_API.G_EXC_ERROR THEN
1738: Rollback to Copy_Position_pvt;
1739: x_return_status := FND_API.G_RET_STS_ERROR;
1740: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1741: p_data => x_msg_data,

Line 1739: x_return_status := FND_API.G_RET_STS_ERROR;

1735: );
1736: EXCEPTION
1737: WHEN FND_API.G_EXC_ERROR THEN
1738: Rollback to Copy_Position_pvt;
1739: x_return_status := FND_API.G_RET_STS_ERROR;
1740: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1741: p_data => x_msg_data,
1742: p_encoded => fnd_api.g_false);
1743: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1742: p_encoded => fnd_api.g_false);

1738: Rollback to Copy_Position_pvt;
1739: x_return_status := FND_API.G_RET_STS_ERROR;
1740: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1741: p_data => x_msg_data,
1742: p_encoded => fnd_api.g_false);
1743: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1744: Rollback to Copy_Position_pvt;
1745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1746: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 1743: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1739: x_return_status := FND_API.G_RET_STS_ERROR;
1740: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1741: p_data => x_msg_data,
1742: p_encoded => fnd_api.g_false);
1743: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1744: Rollback to Copy_Position_pvt;
1745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1746: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1747: p_data => x_msg_data,

Line 1745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1741: p_data => x_msg_data,
1742: p_encoded => fnd_api.g_false);
1743: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1744: Rollback to Copy_Position_pvt;
1745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1746: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1747: p_data => x_msg_data,
1748: p_encoded => fnd_api.g_false);
1749: WHEN OTHERS THEN

Line 1748: p_encoded => fnd_api.g_false);

1744: Rollback to Copy_Position_pvt;
1745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1746: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1747: p_data => x_msg_data,
1748: p_encoded => fnd_api.g_false);
1749: WHEN OTHERS THEN
1750: Rollback to Copy_Position_pvt;
1751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1752: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

Line 1751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1747: p_data => x_msg_data,
1748: p_encoded => fnd_api.g_false);
1749: WHEN OTHERS THEN
1750: Rollback to Copy_Position_pvt;
1751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1752: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
1753: p_procedure_name => l_api_name,
1754: p_error_text => SQLERRM);
1755: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 1757: p_encoded => fnd_api.g_false);

1753: p_procedure_name => l_api_name,
1754: p_error_text => SQLERRM);
1755: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1756: p_data => x_msg_data,
1757: p_encoded => fnd_api.g_false);
1758: END Copy_Position;
1759:
1760: -----------------------------
1761: -- Start of Comments --

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

1771: -- End of Comments.
1772:
1773: PROCEDURE Delete_Positions_For_MC (
1774: p_api_version IN NUMBER,
1775: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1776: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1777: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1778: x_return_status OUT NOCOPY VARCHAR2,
1779: x_msg_count OUT NOCOPY NUMBER,

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

1772:
1773: PROCEDURE Delete_Positions_For_MC (
1774: p_api_version IN NUMBER,
1775: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1776: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1777: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1778: x_return_status OUT NOCOPY VARCHAR2,
1779: x_msg_count OUT NOCOPY NUMBER,
1780: x_msg_data OUT NOCOPY VARCHAR2,

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

1773: PROCEDURE Delete_Positions_For_MC (
1774: p_api_version IN NUMBER,
1775: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1776: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1777: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1778: x_return_status OUT NOCOPY VARCHAR2,
1779: x_msg_count OUT NOCOPY NUMBER,
1780: x_msg_data OUT NOCOPY VARCHAR2,
1781: p_mc_header_id IN NUMBER)

Line 1837: x_return_status := FND_API.G_RET_STS_SUCCESS;

1833: -- Standard start of API savepoint
1834: SAVEPOINT Delete_Positions_For_Mc_pvt;
1835:
1836: -- Initialize Procedure return status to success
1837: x_return_status := FND_API.G_RET_STS_SUCCESS;
1838: -- Standard call to check for call compatibility
1839: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1840: G_PKG_NAME) THEN
1841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1839: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

1835:
1836: -- Initialize Procedure return status to success
1837: x_return_status := FND_API.G_RET_STS_SUCCESS;
1838: -- Standard call to check for call compatibility
1839: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1840: G_PKG_NAME) THEN
1841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1842: END IF;
1843:

Line 1841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1837: x_return_status := FND_API.G_RET_STS_SUCCESS;
1838: -- Standard call to check for call compatibility
1839: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1840: G_PKG_NAME) THEN
1841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1842: END IF;
1843:
1844: -- Initialize message list if p_init_msg_list is set to TRUE
1845: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 1845: IF FND_API.To_Boolean(p_init_msg_list) THEN

1841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1842: END IF;
1843:
1844: -- Initialize message list if p_init_msg_list is set to TRUE
1845: IF FND_API.To_Boolean(p_init_msg_list) THEN
1846: FND_MSG_PUB.Initialize;
1847: END IF;
1848:
1849: --Check Status of MC allows for editing

Line 1858: RAISE FND_API.G_EXC_ERROR;

1854: FND_MESSAGE.Set_Token('NAME','');
1855: FND_MESSAGE.Set_Token('MC_HEADER_ID',p_mc_header_id);
1856: FND_MSG_PUB.ADD;
1857: CLOSE check_mc_status_csr;
1858: RAISE FND_API.G_EXC_ERROR;
1859: ELSIF ( l_status_code <> 'DRAFT' AND
1860: l_status_code <> 'APPROVAL_REJECTED') THEN
1861: FND_MESSAGE.Set_Name('AHL','AHL_MC_EDIT_INV_MC');
1862: FND_MESSAGE.Set_Token('STATUS', l_status);

Line 1865: RAISE FND_API.G_EXC_ERROR;

1861: FND_MESSAGE.Set_Name('AHL','AHL_MC_EDIT_INV_MC');
1862: FND_MESSAGE.Set_Token('STATUS', l_status);
1863: FND_MSG_PUB.ADD;
1864: CLOSE check_mc_status_csr;
1865: RAISE FND_API.G_EXC_ERROR;
1866: END IF;
1867: CLOSE check_mc_status_csr;
1868:
1869: --Delete version specific positions

Line 1927: IF FND_API.TO_BOOLEAN(p_commit) THEN

1923: CLOSE get_nover_position_ids_csr;
1924: END IF;
1925:
1926: -- Standard check of p_commit
1927: IF FND_API.TO_BOOLEAN(p_commit) THEN
1928: COMMIT WORK;
1929: END IF;
1930: -- Standard call to get message count and if count is 1, get message info
1931: FND_MSG_PUB.Count_And_Get

Line 1934: p_encoded => fnd_api.g_false

1930: -- Standard call to get message count and if count is 1, get message info
1931: FND_MSG_PUB.Count_And_Get
1932: ( p_count => x_msg_count,
1933: p_data => x_msg_data,
1934: p_encoded => fnd_api.g_false
1935: );
1936: EXCEPTION
1937: WHEN FND_API.G_EXC_ERROR THEN
1938: Rollback to Delete_Positions_For_Mc_pvt;

Line 1937: WHEN FND_API.G_EXC_ERROR THEN

1933: p_data => x_msg_data,
1934: p_encoded => fnd_api.g_false
1935: );
1936: EXCEPTION
1937: WHEN FND_API.G_EXC_ERROR THEN
1938: Rollback to Delete_Positions_For_Mc_pvt;
1939: x_return_status := FND_API.G_RET_STS_ERROR;
1940: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1941: p_data => x_msg_data,

Line 1939: x_return_status := FND_API.G_RET_STS_ERROR;

1935: );
1936: EXCEPTION
1937: WHEN FND_API.G_EXC_ERROR THEN
1938: Rollback to Delete_Positions_For_Mc_pvt;
1939: x_return_status := FND_API.G_RET_STS_ERROR;
1940: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1941: p_data => x_msg_data,
1942: p_encoded => fnd_api.g_false);
1943: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1942: p_encoded => fnd_api.g_false);

1938: Rollback to Delete_Positions_For_Mc_pvt;
1939: x_return_status := FND_API.G_RET_STS_ERROR;
1940: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1941: p_data => x_msg_data,
1942: p_encoded => fnd_api.g_false);
1943: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1944: Rollback to Delete_Positions_For_Mc_pvt;
1945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1946: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 1943: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1939: x_return_status := FND_API.G_RET_STS_ERROR;
1940: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1941: p_data => x_msg_data,
1942: p_encoded => fnd_api.g_false);
1943: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1944: Rollback to Delete_Positions_For_Mc_pvt;
1945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1946: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1947: p_data => x_msg_data,

Line 1945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1941: p_data => x_msg_data,
1942: p_encoded => fnd_api.g_false);
1943: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1944: Rollback to Delete_Positions_For_Mc_pvt;
1945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1946: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1947: p_data => x_msg_data,
1948: p_encoded => fnd_api.g_false);
1949: WHEN OTHERS THEN

Line 1948: p_encoded => fnd_api.g_false);

1944: Rollback to Delete_Positions_For_Mc_pvt;
1945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1946: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1947: p_data => x_msg_data,
1948: p_encoded => fnd_api.g_false);
1949: WHEN OTHERS THEN
1950: Rollback to Delete_Positions_For_Mc_pvt;
1951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1952: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

Line 1951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1947: p_data => x_msg_data,
1948: p_encoded => fnd_api.g_false);
1949: WHEN OTHERS THEN
1950: Rollback to Delete_Positions_For_Mc_pvt;
1951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1952: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
1953: p_procedure_name => l_api_name,
1954: p_error_text => SQLERRM);
1955: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 1957: p_encoded => fnd_api.g_false);

1953: p_procedure_name => l_api_name,
1954: p_error_text => SQLERRM);
1955: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1956: p_data => x_msg_data,
1957: p_encoded => fnd_api.g_false);
1958: END Delete_Positions_For_MC;
1959:
1960:
1961: ---------------------------------------------------------------------

Line 1971: -- p_code_flag IN VARHCAR2 If Equal to FND_API.G_TRUE, then return

1967: -- Parameters :
1968: --
1969: -- get_position_ref_code Parameters:
1970: -- p_position_id IN NUMBER the path position id
1971: -- p_code_flag IN VARHCAR2 If Equal to FND_API.G_TRUE, then return
1972: -- pos ref code, else return pos ref meaning. Default to False.
1973: --
1974: FUNCTION get_posref_by_id(
1975: p_path_position_ID IN NUMBER,

Line 1976: p_code_flag IN VARCHAR2 := FND_API.G_FALSE)

1972: -- pos ref code, else return pos ref meaning. Default to False.
1973: --
1974: FUNCTION get_posref_by_id(
1975: p_path_position_ID IN NUMBER,
1976: p_code_flag IN VARCHAR2 := FND_API.G_FALSE)
1977: RETURN VARCHAR2 -- Position Ref Code or Meaning
1978: IS
1979: --
1980: CURSOR get_pos_ref_csr (p_position_id IN NUMBER) IS

Line 2009: (l_pos_ref_code = FND_API.G_MISS_CHAR) THEN

2005: FETCH get_pos_ref_csr INTO l_pos_ref_code;
2006:
2007: --If there are no pos ref defined for path
2008: IF (l_pos_ref_code IS NULL) OR
2009: (l_pos_ref_code = FND_API.G_MISS_CHAR) THEN
2010: OPEN get_def_pos_ref_csr(p_path_position_ID);
2011: FETCH get_def_pos_ref_csr INTO l_pos_ref_code;
2012: CLOSE get_def_pos_ref_csr;
2013: END IF;

Line 2016: IF (p_code_flag = FND_API.G_TRUE) THEN

2012: CLOSE get_def_pos_ref_csr;
2013: END IF;
2014: CLOSE get_pos_ref_csr;
2015:
2016: IF (p_code_flag = FND_API.G_TRUE) THEN
2017: RETURN l_pos_ref_code;
2018: ELSE
2019: --Convert to meaning.
2020: AHL_UTIL_MC_PKG.Convert_To_LookupMeaning('AHL_POSITION_REFERENCE',

Line 2039: -- p_code_flag IN VARHCAR2 If Equal to FND_API.G_TRUE, then return

2035: -- Parameters :
2036: --
2037: -- get_position_ref_code Parameters:
2038: -- p_position_path_tbl IN AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type Required
2039: -- p_code_flag IN VARHCAR2 If Equal to FND_API.G_TRUE, then return
2040: -- pos ref code, else return pos ref meaning. Default to False.
2041: --
2042: FUNCTION get_posref_by_path(
2043: p_path_position_tbl IN AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type,

Line 2044: p_code_flag IN VARCHAR2 := FND_API.G_FALSE

2040: -- pos ref code, else return pos ref meaning. Default to False.
2041: --
2042: FUNCTION get_posref_by_path(
2043: p_path_position_tbl IN AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type,
2044: p_code_flag IN VARCHAR2 := FND_API.G_FALSE
2045: )
2046: RETURN VARCHAR2 -- Position Ref Meaning/Code
2047: IS
2048: --

Line 2096: IF (p_code_flag = FND_API.G_TRUE) THEN

2092: CLOSE get_def_path_pos_ref_csr;
2093: END IF;
2094: CLOSE get_path_pos_ref_csr;
2095:
2096: IF (p_code_flag = FND_API.G_TRUE) THEN
2097: RETURN l_pos_ref_code;
2098: ELSE
2099: --Convert to meaning.
2100: AHL_UTIL_MC_PKG.Convert_To_LookupMeaning('AHL_POSITION_REFERENCE',

Line 2358: -- value as FND_API.G_TRUE for Boolean TRUE and

2354: -- Start of Comments --
2355: -- Function name: check_pos_ref_path_char
2356: -- Type : Private
2357: -- Function : Calls private function Check_pos_ref_path and returns
2358: -- value as FND_API.G_TRUE for Boolean TRUE and
2359: -- FND_API.G_FALSE for Boolean False.
2360: -- Pre-reqs :
2361: -- Parameters : p_from_csi_id NUMBER the from instance id
2362: -- p_to_csi_id NUMBER the instance id that it reaches

Line 2359: -- FND_API.G_FALSE for Boolean False.

2355: -- Function name: check_pos_ref_path_char
2356: -- Type : Private
2357: -- Function : Calls private function Check_pos_ref_path and returns
2358: -- value as FND_API.G_TRUE for Boolean TRUE and
2359: -- FND_API.G_FALSE for Boolean False.
2360: -- Pre-reqs :
2361: -- Parameters : p_from_csi_id NUMBER the from instance id
2362: -- p_to_csi_id NUMBER the instance id that it reaches
2363: --

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

2390: -- End of Comments.
2391:
2392: PROCEDURE Map_Instance_To_Pos_ID (
2393: p_api_version IN NUMBER,
2394: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2395: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2396: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2397: x_return_status OUT NOCOPY VARCHAR2,
2398: x_msg_count OUT NOCOPY NUMBER,

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

2391:
2392: PROCEDURE Map_Instance_To_Pos_ID (
2393: p_api_version IN NUMBER,
2394: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2395: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2396: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2397: x_return_status OUT NOCOPY VARCHAR2,
2398: x_msg_count OUT NOCOPY NUMBER,
2399: x_msg_data OUT NOCOPY VARCHAR2,

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

2392: PROCEDURE Map_Instance_To_Pos_ID (
2393: p_api_version IN NUMBER,
2394: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2395: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2396: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2397: x_return_status OUT NOCOPY VARCHAR2,
2398: x_msg_count OUT NOCOPY NUMBER,
2399: x_msg_data OUT NOCOPY VARCHAR2,
2400: p_csi_item_instance_id IN NUMBER,

Line 2401: p_relationship_id IN NUMBER := FND_API.G_MISS_NUM,

2397: x_return_status OUT NOCOPY VARCHAR2,
2398: x_msg_count OUT NOCOPY NUMBER,
2399: x_msg_data OUT NOCOPY VARCHAR2,
2400: p_csi_item_instance_id IN NUMBER,
2401: p_relationship_id IN NUMBER := FND_API.G_MISS_NUM,
2402: x_path_position_id OUT NOCOPY NUMBER)
2403: IS
2404: --
2405: --Fetch the unit and unit header info for each instance

Line 2548: x_return_status := FND_API.G_RET_STS_SUCCESS;

2544: fnd_log.string(fnd_log.level_procedure, l_full_name||'.begin', 'At the start of PLSQL procedure. p_csi_item_instance_id = ' || p_csi_item_instance_id ||
2545: ', p_relationship_id = ' || p_relationship_id);
2546: END IF;
2547: -- Initialize Procedure return status to success
2548: x_return_status := FND_API.G_RET_STS_SUCCESS;
2549: x_path_position_id := null;
2550:
2551: -- Standard call to check for call compatibility
2552: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

Line 2552: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

2548: x_return_status := FND_API.G_RET_STS_SUCCESS;
2549: x_path_position_id := null;
2550:
2551: -- Standard call to check for call compatibility
2552: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
2553: G_PKG_NAME) THEN
2554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2555: END IF;
2556:

Line 2554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2550:
2551: -- Standard call to check for call compatibility
2552: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
2553: G_PKG_NAME) THEN
2554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2555: END IF;
2556:
2557: -- Initialize message list if p_init_msg_list is set to TRUE
2558: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 2558: IF FND_API.To_Boolean(p_init_msg_list) THEN

2554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2555: END IF;
2556:
2557: -- Initialize message list if p_init_msg_list is set to TRUE
2558: IF FND_API.To_Boolean(p_init_msg_list) THEN
2559: FND_MSG_PUB.Initialize;
2560: END IF;
2561:
2562: --Fetch the position informations for the instance

Line 2609: IF (p_relationship_id <> FND_API.G_MISS_NUM AND

2605: CLOSE get_last_uc_rec_csr;
2606:
2607:
2608: --For the empty position, build path information for last node of path.
2609: IF (p_relationship_id <> FND_API.G_MISS_NUM AND
2610: p_relationship_id IS NOT NULL) THEN
2611: OPEN get_mc_relationship_csr (p_relationship_id, p_csi_item_instance_id);
2612: FETCH get_mc_relationship_csr INTO l_path_rec.mc_id,
2613: l_path_rec.version_number,

Line 2640: RAISE FND_API.G_EXC_ERROR;

2636: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 21-Dec-2007
2637: -- There is no need to call the API Create_Position_ID, if there are pending validation errors.
2638: x_msg_count := FND_MSG_PUB.count_msg;
2639: IF x_msg_count > 0 THEN
2640: RAISE FND_API.G_EXC_ERROR;
2641: END IF;
2642:
2643: Create_Position_ID (
2644: p_api_version => 1.0,

Line 2645: p_init_msg_list => FND_API.G_TRUE,

2641: END IF;
2642:
2643: Create_Position_ID (
2644: p_api_version => 1.0,
2645: p_init_msg_list => FND_API.G_TRUE,
2646: p_commit => FND_API.G_FALSE,
2647: p_path_position_tbl => l_path_tbl,
2648: p_position_ref_meaning => FND_API.G_MISS_CHAR,
2649: p_position_ref_code => FND_API.G_MISS_CHAR,

Line 2646: p_commit => FND_API.G_FALSE,

2642:
2643: Create_Position_ID (
2644: p_api_version => 1.0,
2645: p_init_msg_list => FND_API.G_TRUE,
2646: p_commit => FND_API.G_FALSE,
2647: p_path_position_tbl => l_path_tbl,
2648: p_position_ref_meaning => FND_API.G_MISS_CHAR,
2649: p_position_ref_code => FND_API.G_MISS_CHAR,
2650: x_position_id => x_path_position_id,

Line 2648: p_position_ref_meaning => FND_API.G_MISS_CHAR,

2644: p_api_version => 1.0,
2645: p_init_msg_list => FND_API.G_TRUE,
2646: p_commit => FND_API.G_FALSE,
2647: p_path_position_tbl => l_path_tbl,
2648: p_position_ref_meaning => FND_API.G_MISS_CHAR,
2649: p_position_ref_code => FND_API.G_MISS_CHAR,
2650: x_position_id => x_path_position_id,
2651: x_return_status => x_return_status,
2652: x_msg_count => x_msg_count,

Line 2649: p_position_ref_code => FND_API.G_MISS_CHAR,

2645: p_init_msg_list => FND_API.G_TRUE,
2646: p_commit => FND_API.G_FALSE,
2647: p_path_position_tbl => l_path_tbl,
2648: p_position_ref_meaning => FND_API.G_MISS_CHAR,
2649: p_position_ref_code => FND_API.G_MISS_CHAR,
2650: x_position_id => x_path_position_id,
2651: x_return_status => x_return_status,
2652: x_msg_count => x_msg_count,
2653: x_msg_data => x_msg_data);

Line 2664: IF FND_API.TO_BOOLEAN(p_commit) THEN

2660: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2661: fnd_log.string(fnd_log.level_procedure, l_full_name||'.end', 'At the end of PLSQL procedure. About to commit work.');
2662: END IF;
2663: -- Standard check of p_commit
2664: IF FND_API.TO_BOOLEAN(p_commit) THEN
2665: COMMIT WORK;
2666: END IF;
2667:
2668: -- Standard call to get message count and if count is 1, get message info

Line 2672: p_encoded => fnd_api.g_false

2668: -- Standard call to get message count and if count is 1, get message info
2669: FND_MSG_PUB.Count_And_Get
2670: ( p_count => x_msg_count,
2671: p_data => x_msg_data,
2672: p_encoded => fnd_api.g_false
2673: );
2674: EXCEPTION
2675: WHEN FND_API.G_EXC_ERROR THEN
2676: Rollback to Map_Instance_To_Pos_ID_pvt;

Line 2675: WHEN FND_API.G_EXC_ERROR THEN

2671: p_data => x_msg_data,
2672: p_encoded => fnd_api.g_false
2673: );
2674: EXCEPTION
2675: WHEN FND_API.G_EXC_ERROR THEN
2676: Rollback to Map_Instance_To_Pos_ID_pvt;
2677: x_return_status := FND_API.G_RET_STS_ERROR;
2678: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2679: p_data => x_msg_data,

Line 2677: x_return_status := FND_API.G_RET_STS_ERROR;

2673: );
2674: EXCEPTION
2675: WHEN FND_API.G_EXC_ERROR THEN
2676: Rollback to Map_Instance_To_Pos_ID_pvt;
2677: x_return_status := FND_API.G_RET_STS_ERROR;
2678: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2679: p_data => x_msg_data,
2680: p_encoded => fnd_api.g_false);
2681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2680: p_encoded => fnd_api.g_false);

2676: Rollback to Map_Instance_To_Pos_ID_pvt;
2677: x_return_status := FND_API.G_RET_STS_ERROR;
2678: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2679: p_data => x_msg_data,
2680: p_encoded => fnd_api.g_false);
2681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2682: Rollback to Map_Instance_To_Pos_ID_pvt;
2683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2684: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 2681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2677: x_return_status := FND_API.G_RET_STS_ERROR;
2678: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2679: p_data => x_msg_data,
2680: p_encoded => fnd_api.g_false);
2681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2682: Rollback to Map_Instance_To_Pos_ID_pvt;
2683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2684: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2685: p_data => x_msg_data,

Line 2683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2679: p_data => x_msg_data,
2680: p_encoded => fnd_api.g_false);
2681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2682: Rollback to Map_Instance_To_Pos_ID_pvt;
2683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2684: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2685: p_data => x_msg_data,
2686: p_encoded => fnd_api.g_false);
2687: WHEN OTHERS THEN

Line 2686: p_encoded => fnd_api.g_false);

2682: Rollback to Map_Instance_To_Pos_ID_pvt;
2683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2684: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2685: p_data => x_msg_data,
2686: p_encoded => fnd_api.g_false);
2687: WHEN OTHERS THEN
2688: Rollback to Map_Instance_To_Pos_ID_pvt;
2689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2690: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

Line 2689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2685: p_data => x_msg_data,
2686: p_encoded => fnd_api.g_false);
2687: WHEN OTHERS THEN
2688: Rollback to Map_Instance_To_Pos_ID_pvt;
2689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2690: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
2691: p_procedure_name => l_api_name,
2692: p_error_text => SQLERRM);
2693: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 2695: p_encoded => fnd_api.g_false);

2691: p_procedure_name => l_api_name,
2692: p_error_text => SQLERRM);
2693: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2694: p_data => x_msg_data,
2695: p_encoded => fnd_api.g_false);
2696:
2697: END Map_Instance_To_Pos_Id;
2698:
2699: ---------------------------------------------------------------------