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

Line 109: x_return_status := FND_API.G_RET_STS_SUCCESS;

105: --------------------Initialize ----------------------------------
106: -- Standard Start of API savepoint
107: SAVEPOINT check_availability;
108: -- Initialize API return status to success
109: x_return_status := FND_API.G_RET_STS_SUCCESS;
110: -- Initialize message list if p_init_msg_list is set to TRUE.
111: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
112: l_api_version,
113: l_api_name,G_PKG_NAME)

Line 111: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

107: SAVEPOINT check_availability;
108: -- Initialize API return status to success
109: x_return_status := FND_API.G_RET_STS_SUCCESS;
110: -- Initialize message list if p_init_msg_list is set to TRUE.
111: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
112: l_api_version,
113: l_api_name,G_PKG_NAME)
114: THEN
115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

111: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
112: l_api_version,
113: l_api_name,G_PKG_NAME)
114: THEN
115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
116: END IF;
117: --
118:
119: -- Get Session ID

Line 137: RAISE FND_API.G_EXC_ERROR;

133: IF Instance_Id_Cur%NOTFOUND THEN
134: FND_MESSAGE.Set_Name( 'AHL','AHL_LTP_ATP_INS_ENABLE' );
135: FND_MSG_PUB.add;
136: CLOSE Instance_Id_Cur;
137: RAISE FND_API.G_EXC_ERROR;
138: END IF;
139: CLOSE Instance_Id_Cur;
140: --
141: IF (l_log_statement >= l_log_current_level) THEN

Line 242: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN

238: 'After calling Mrp Atp Pub.Call_ATP. Return Status : '|| l_return_status);
239: END IF;
240:
241: -- Check Error Message stack.
242: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
243: l_msg_count := FND_MSG_PUB.count_msg;
244: IF l_msg_count > 0 THEN
245: RAISE FND_API.G_EXC_ERROR;
246: END IF;

Line 245: RAISE FND_API.G_EXC_ERROR;

241: -- Check Error Message stack.
242: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
243: l_msg_count := FND_MSG_PUB.count_msg;
244: IF l_msg_count > 0 THEN
245: RAISE FND_API.G_EXC_ERROR;
246: END IF;
247: END IF;
248:
249: -- SKPATHAK :: Bug 12833742 :: 11-AUG-2011 :: Commented the below

Line 291: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

287: L_DEBUG_KEY,
288: 'Pub Message : '||x_atp_table.Message(1));
289: END IF;
290:
291: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
292:
293: MSC_ATP_GLOBAL.Extend_ATP(x_atp_table, l_return_status);
294:
295: x_available_date := to_char(x_atp_table.Ship_Date(1));

Line 364: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN

360: 'Derived from Mrp Atp Pub Available Quantity : '||x_available_qty);
361: END IF;
362:
363: -- Check Error Message stack.
364: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
365: l_msg_count := FND_MSG_PUB.count_msg;
366: IF l_msg_count > 0 THEN
367: RAISE FND_API.G_EXC_ERROR;
368: END IF;

Line 367: RAISE FND_API.G_EXC_ERROR;

363: -- Check Error Message stack.
364: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
365: l_msg_count := FND_MSG_PUB.count_msg;
366: IF l_msg_count > 0 THEN
367: RAISE FND_API.G_EXC_ERROR;
368: END IF;
369: END IF;
370:
371: IF (l_log_procedure >= l_log_current_level) THEN

Line 378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

374: 'At the end of PL SQL procedure. Return Status = ' || x_return_status);
375: END IF;
376:
377: EXCEPTION
378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
379: ROLLBACK TO check_availability;
380: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
381: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
382: p_count => l_msg_count,

Line 380: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

376:
377: EXCEPTION
378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
379: ROLLBACK TO check_availability;
380: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
381: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
382: p_count => l_msg_count,
383: p_data => l_msg_data);
384:

Line 381: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

377: EXCEPTION
378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
379: ROLLBACK TO check_availability;
380: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
381: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
382: p_count => l_msg_count,
383: p_data => l_msg_data);
384:
385: WHEN FND_API.G_EXC_ERROR THEN

Line 385: WHEN FND_API.G_EXC_ERROR THEN

381: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
382: p_count => l_msg_count,
383: p_data => l_msg_data);
384:
385: WHEN FND_API.G_EXC_ERROR THEN
386: ROLLBACK TO check_availability;
387: X_return_status := FND_API.G_RET_STS_ERROR;
388: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
389: p_count => l_msg_count,

Line 387: X_return_status := FND_API.G_RET_STS_ERROR;

383: p_data => l_msg_data);
384:
385: WHEN FND_API.G_EXC_ERROR THEN
386: ROLLBACK TO check_availability;
387: X_return_status := FND_API.G_RET_STS_ERROR;
388: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
389: p_count => l_msg_count,
390: p_data => l_msg_data);
391:

Line 388: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

384:
385: WHEN FND_API.G_EXC_ERROR THEN
386: ROLLBACK TO check_availability;
387: X_return_status := FND_API.G_RET_STS_ERROR;
388: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
389: p_count => l_msg_count,
390: p_data => l_msg_data);
391:
392: WHEN OTHERS THEN

Line 394: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

390: p_data => l_msg_data);
391:
392: WHEN OTHERS THEN
393: ROLLBACK TO check_availability;
394: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
395: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
396: THEN
397: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',
398: p_procedure_name => 'CHECK_AVAILABILITY',

Line 401: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

397: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',
398: p_procedure_name => 'CHECK_AVAILABILITY',
399: p_error_text => SUBSTR(SQLERRM,1,240));
400: END IF;
401: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
402: p_count => l_msg_count,
403: p_data => l_msg_data);
404:
405: END Check_Availability;

Line 416: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

412: -- Parameters :
413: --
414: -- Standard IN Parameters :
415: -- p_api_version IN NUMBER Required
416: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
417: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
418: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
419: -- Based on this flag, the API will set the default attributes.
420: -- p_module_type In VARCHAR2 Default NULL

Line 417: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

413: --
414: -- Standard IN Parameters :
415: -- p_api_version IN NUMBER Required
416: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
417: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
418: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
419: -- Based on this flag, the API will set the default attributes.
420: -- p_module_type In VARCHAR2 Default NULL
421: -- This will be null.

Line 418: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

414: -- Standard IN Parameters :
415: -- p_api_version IN NUMBER Required
416: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
417: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
418: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
419: -- Based on this flag, the API will set the default attributes.
420: -- p_module_type In VARCHAR2 Default NULL
421: -- This will be null.
422: -- Standard OUT Parameters :

Line 433: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

429: -- List of item attributes associated to visit task
430: --
431: PROCEDURE Check_Material_Aval (
432: p_api_version IN NUMBER,
433: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
434: p_commit IN VARCHAR2 := FND_API.g_false,
435: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
436: p_module_type IN VARCHAR2 := 'JSP',
437: p_x_material_avl_tbl IN OUT NOCOPY ahl_ltp_matrl_aval_pub.Material_Availability_Tbl,

Line 434: p_commit IN VARCHAR2 := FND_API.g_false,

430: --
431: PROCEDURE Check_Material_Aval (
432: p_api_version IN NUMBER,
433: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
434: p_commit IN VARCHAR2 := FND_API.g_false,
435: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
436: p_module_type IN VARCHAR2 := 'JSP',
437: p_x_material_avl_tbl IN OUT NOCOPY ahl_ltp_matrl_aval_pub.Material_Availability_Tbl,
438: x_return_status OUT NOCOPY VARCHAR2,

Line 435: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

431: PROCEDURE Check_Material_Aval (
432: p_api_version IN NUMBER,
433: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
434: p_commit IN VARCHAR2 := FND_API.g_false,
435: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
436: p_module_type IN VARCHAR2 := 'JSP',
437: p_x_material_avl_tbl IN OUT NOCOPY ahl_ltp_matrl_aval_pub.Material_Availability_Tbl,
438: x_return_status OUT NOCOPY VARCHAR2,
439: x_msg_count OUT NOCOPY NUMBER,

Line 489: IF FND_API.to_boolean(p_init_msg_list)

485: --------------------Initialize ----------------------------------
486: -- Standard Start of API savepoint
487: SAVEPOINT check_material_aval;
488: -- Standard call to check for call compatibility.
489: IF FND_API.to_boolean(p_init_msg_list)
490: THEN
491: FND_MSG_PUB.initialize;
492: END IF;
493: -- Initialize API return status to success

Line 494: x_return_status := FND_API.G_RET_STS_SUCCESS;

490: THEN
491: FND_MSG_PUB.initialize;
492: END IF;
493: -- Initialize API return status to success
494: x_return_status := FND_API.G_RET_STS_SUCCESS;
495: -- Initialize message list if p_init_msg_list is set to TRUE.
496: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
497: p_api_version,
498: l_api_name,G_PKG_NAME)

Line 496: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

492: END IF;
493: -- Initialize API return status to success
494: x_return_status := FND_API.G_RET_STS_SUCCESS;
495: -- Initialize message list if p_init_msg_list is set to TRUE.
496: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
497: p_api_version,
498: l_api_name,G_PKG_NAME)
499: THEN
500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

496: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
497: p_api_version,
498: l_api_name,G_PKG_NAME)
499: THEN
500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
501: END IF;
502:
503: IF (l_log_statement >= l_log_current_level)THEN
504: fnd_log.string(l_log_statement,

Line 517: RAISE Fnd_Api.G_EXC_ERROR;

513: IF Check_Sch_Visit_cur%FOUND THEN
514: Fnd_Message.SET_NAME('AHL','AHL_VISIT_UNSCHEDULED');
515: Fnd_Msg_Pub.ADD;
516: CLOSE Check_Sch_Visit_cur;
517: RAISE Fnd_Api.G_EXC_ERROR;
518: END IF;
519: CLOSE Check_Sch_Visit_cur;
520: --
521: IF (l_log_statement >= l_log_current_level)THEN

Line 546: RAISE Fnd_Api.G_EXC_ERROR;

542: IF Schedule_Matrl_cur%NOTFOUND THEN
543: Fnd_Message.SET_NAME('AHL','AHL_LTP_ORG_ID_NOT_EXISTS');
544: Fnd_Msg_Pub.ADD;
545: CLOSE Schedule_Matrl_cur;
546: RAISE Fnd_Api.G_EXC_ERROR;
547: END IF;
548: CLOSE Schedule_Matrl_cur;
549:
550: --Added by sowsubra - starts

Line 554: RAISE Fnd_Api.G_EXC_ERROR;

550: --Added by sowsubra - starts
551: IF l_Schedule_Matrl_Rec.status = 'IN-SERVICE' THEN
552: Fnd_Message.SET_NAME('AHL','AHL_MAT_STS_INSERVICE');
553: Fnd_Msg_Pub.ADD;
554: RAISE Fnd_Api.G_EXC_ERROR;
555: END IF;
556: --Added by sowsubra - ends
557:
558: --Get Item description

Line 592: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN

588: 'After calling Check Availability, Return Status : '|| l_return_status);
589: END IF;
590:
591: -- Check Error Message stack.
592: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
593: l_msg_count := FND_MSG_PUB.count_msg;
594: IF l_msg_count > 0 THEN
595: RAISE FND_API.G_EXC_ERROR;
596: END IF;

Line 595: RAISE FND_API.G_EXC_ERROR;

591: -- Check Error Message stack.
592: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
593: l_msg_count := FND_MSG_PUB.count_msg;
594: IF l_msg_count > 0 THEN
595: RAISE FND_API.G_EXC_ERROR;
596: END IF;
597: END IF;
598: --Assign derived values
599: p_x_material_avl_tbl(i).quantity_available:= l_available_quantity;

Line 642: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN

638: END LOOP;
639: END IF;
640:
641: -- Check Error Message stack.
642: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
643: l_msg_count := FND_MSG_PUB.count_msg;
644: IF l_msg_count > 0 THEN
645: RAISE FND_API.G_EXC_ERROR;
646: END IF;

Line 645: RAISE FND_API.G_EXC_ERROR;

641: -- Check Error Message stack.
642: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
643: l_msg_count := FND_MSG_PUB.count_msg;
644: IF l_msg_count > 0 THEN
645: RAISE FND_API.G_EXC_ERROR;
646: END IF;
647: END IF;
648:
649: IF (l_log_procedure >= l_log_current_level) THEN

Line 656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

652: 'At the end of PL SQL procedure. Return Status = ' || x_return_status);
653: END IF;
654:
655: EXCEPTION
656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
657: ROLLBACK TO check_material_aval;
658: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
659: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
660: p_count => l_msg_count,

Line 658: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

654:
655: EXCEPTION
656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
657: ROLLBACK TO check_material_aval;
658: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
659: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
660: p_count => l_msg_count,
661: p_data => l_msg_data);
662:

Line 659: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

655: EXCEPTION
656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
657: ROLLBACK TO check_material_aval;
658: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
659: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
660: p_count => l_msg_count,
661: p_data => l_msg_data);
662:
663: WHEN FND_API.G_EXC_ERROR THEN

Line 663: WHEN FND_API.G_EXC_ERROR THEN

659: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
660: p_count => l_msg_count,
661: p_data => l_msg_data);
662:
663: WHEN FND_API.G_EXC_ERROR THEN
664: ROLLBACK TO check_material_aval;
665: X_return_status := FND_API.G_RET_STS_ERROR;
666: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
667: p_count => l_msg_count,

Line 665: X_return_status := FND_API.G_RET_STS_ERROR;

661: p_data => l_msg_data);
662:
663: WHEN FND_API.G_EXC_ERROR THEN
664: ROLLBACK TO check_material_aval;
665: X_return_status := FND_API.G_RET_STS_ERROR;
666: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
667: p_count => l_msg_count,
668: p_data => l_msg_data);
669:

Line 666: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

662:
663: WHEN FND_API.G_EXC_ERROR THEN
664: ROLLBACK TO check_material_aval;
665: X_return_status := FND_API.G_RET_STS_ERROR;
666: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
667: p_count => l_msg_count,
668: p_data => l_msg_data);
669:
670: WHEN OTHERS THEN

Line 672: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

668: p_data => l_msg_data);
669:
670: WHEN OTHERS THEN
671: ROLLBACK TO check_material_aval;
672: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
673: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
674: THEN
675: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',
676: p_procedure_name => 'CHECK_MATERIAL_AVAL',

Line 679: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

675: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',
676: p_procedure_name => 'CHECK_MATERIAL_AVAL',
677: p_error_text => SUBSTR(SQLERRM,1,240));
678: END IF;
679: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
680: p_count => l_msg_count,
681: p_data => l_msg_data);
682:
683: END Check_Material_Aval;

Line 695: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

691: -- Parameters :
692: --
693: -- Standard IN Parameters :
694: -- p_api_version IN NUMBER Required
695: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
696: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
697: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
698: -- Based on this flag, the API will set the default attributes.
699: -- p_module_type In VARCHAR2 Default NULL

Line 696: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

692: --
693: -- Standard IN Parameters :
694: -- p_api_version IN NUMBER Required
695: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
696: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
697: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
698: -- Based on this flag, the API will set the default attributes.
699: -- p_module_type In VARCHAR2 Default NULL
700: -- This will be null.

Line 697: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

693: -- Standard IN Parameters :
694: -- p_api_version IN NUMBER Required
695: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
696: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
697: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
698: -- Based on this flag, the API will set the default attributes.
699: -- p_module_type In VARCHAR2 Default NULL
700: -- This will be null.
701: -- Standard OUT Parameters :

Line 712: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

708: -- x_task_req_matrl_tbl OUT NOCOPY Task_Req_Matrl_Tbl,
709: --
710: PROCEDURE Get_Visit_Task_Materials (
711: p_api_version IN NUMBER,
712: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
713: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
714: p_visit_id IN NUMBER,
715: x_task_req_matrl_tbl OUT NOCOPY ahl_ltp_matrl_aval_pub.task_req_matrl_tbl,
716: x_return_status OUT NOCOPY VARCHAR2,

Line 713: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

709: --
710: PROCEDURE Get_Visit_Task_Materials (
711: p_api_version IN NUMBER,
712: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
713: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
714: p_visit_id IN NUMBER,
715: x_task_req_matrl_tbl OUT NOCOPY ahl_ltp_matrl_aval_pub.task_req_matrl_tbl,
716: x_return_status OUT NOCOPY VARCHAR2,
717: x_msg_count OUT NOCOPY NUMBER,

Line 767: IF FND_API.to_boolean(p_init_msg_list) THEN

763: END IF;
764: -- Standard Start of API savepoint
765: SAVEPOINT Get_Visit_Task_Materials;
766: -- Initialize message list if p_init_msg_list is set to TRUE.
767: IF FND_API.to_boolean(p_init_msg_list) THEN
768: FND_MSG_PUB.initialize;
769: END IF;
770: -- Initialize API return status to success
771: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 771: x_return_status := FND_API.G_RET_STS_SUCCESS;

767: IF FND_API.to_boolean(p_init_msg_list) THEN
768: FND_MSG_PUB.initialize;
769: END IF;
770: -- Initialize API return status to success
771: x_return_status := FND_API.G_RET_STS_SUCCESS;
772: -- Standard call to check for call compatibility.
773: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
774: l_api_version,
775: l_api_name,G_PKG_NAME)

Line 773: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

769: END IF;
770: -- Initialize API return status to success
771: x_return_status := FND_API.G_RET_STS_SUCCESS;
772: -- Standard call to check for call compatibility.
773: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
774: l_api_version,
775: l_api_name,G_PKG_NAME)
776: THEN
777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

773: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
774: l_api_version,
775: l_api_name,G_PKG_NAME)
776: THEN
777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
778: END IF;
779:
780: --
781: IF p_visit_id IS NOT NULL THEN

Line 809: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN

805: CLOSE Visit_Task_Matrl_Cur;
806: END IF;
807:
808: -- Check Error Message stack.
809: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
810: l_msg_count := FND_MSG_PUB.count_msg;
811: IF l_msg_count > 0 THEN
812: RAISE FND_API.G_EXC_ERROR;
813: END IF;

Line 812: RAISE FND_API.G_EXC_ERROR;

808: -- Check Error Message stack.
809: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
810: l_msg_count := FND_MSG_PUB.count_msg;
811: IF l_msg_count > 0 THEN
812: RAISE FND_API.G_EXC_ERROR;
813: END IF;
814: END IF;
815:
816: IF (l_log_procedure >= l_log_current_level) THEN

Line 823: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

819: 'At the end of PL SQL procedure. Return Status = ' || x_return_status);
820: END IF;
821:
822: EXCEPTION
823: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
824: ROLLBACK TO Get_Visit_Task_Materials;
825: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
826: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
827: p_count => l_msg_count,

Line 825: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

821:
822: EXCEPTION
823: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
824: ROLLBACK TO Get_Visit_Task_Materials;
825: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
826: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
827: p_count => l_msg_count,
828: p_data => l_msg_data);
829: WHEN FND_API.G_EXC_ERROR THEN

Line 826: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

822: EXCEPTION
823: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
824: ROLLBACK TO Get_Visit_Task_Materials;
825: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
826: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
827: p_count => l_msg_count,
828: p_data => l_msg_data);
829: WHEN FND_API.G_EXC_ERROR THEN
830: ROLLBACK TO Get_Visit_Task_Materials;

Line 829: WHEN FND_API.G_EXC_ERROR THEN

825: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
826: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
827: p_count => l_msg_count,
828: p_data => l_msg_data);
829: WHEN FND_API.G_EXC_ERROR THEN
830: ROLLBACK TO Get_Visit_Task_Materials;
831: X_return_status := FND_API.G_RET_STS_ERROR;
832: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
833: p_count => l_msg_count,

Line 831: X_return_status := FND_API.G_RET_STS_ERROR;

827: p_count => l_msg_count,
828: p_data => l_msg_data);
829: WHEN FND_API.G_EXC_ERROR THEN
830: ROLLBACK TO Get_Visit_Task_Materials;
831: X_return_status := FND_API.G_RET_STS_ERROR;
832: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
833: p_count => l_msg_count,
834: p_data => l_msg_data);
835: WHEN OTHERS THEN

Line 832: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

828: p_data => l_msg_data);
829: WHEN FND_API.G_EXC_ERROR THEN
830: ROLLBACK TO Get_Visit_Task_Materials;
831: X_return_status := FND_API.G_RET_STS_ERROR;
832: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
833: p_count => l_msg_count,
834: p_data => l_msg_data);
835: WHEN OTHERS THEN
836: ROLLBACK TO Get_Visit_Task_Materials;

Line 837: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

833: p_count => l_msg_count,
834: p_data => l_msg_data);
835: WHEN OTHERS THEN
836: ROLLBACK TO Get_Visit_Task_Materials;
837: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
838: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
839: THEN
840: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',
841: p_procedure_name => 'GET_VISIT_TASK_MATERIALS',

Line 844: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

840: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',
841: p_procedure_name => 'GET_VISIT_TASK_MATERIALS',
842: p_error_text => SUBSTR(SQLERRM,1,240));
843: END IF;
844: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
845: p_count => l_msg_count,
846: p_data => l_msg_data);
847: END Get_Visit_Task_Materials;
848: --

Line 864: x_return_status := FND_API.G_RET_STS_SUCCESS;

860: L_DEBUG_KEY ||'.begin',
861: 'At the start of PL SQL procedure.');
862: END IF;
863:
864: x_return_status := FND_API.G_RET_STS_SUCCESS;
865: --
866: p_atp_table.Row_Id.Extend;
867: P_ATP_TABLE.INSTANCE_ID.EXTEND;
868: P_ATP_TABLE.INVENTORY_ITEM_ID.EXTEND;

Line 930: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

926: -- Parameters :
927: --
928: -- Standard IN Parameters :
929: -- p_api_version IN NUMBER Required
930: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
931: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
932: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
933: -- Based on this flag, the API will set the default attributes.
934: -- p_module_type In VARCHAR2 Default NULL

Line 931: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

927: --
928: -- Standard IN Parameters :
929: -- p_api_version IN NUMBER Required
930: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
931: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
932: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
933: -- Based on this flag, the API will set the default attributes.
934: -- p_module_type In VARCHAR2 Default NULL
935: -- This will be null.

Line 932: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

928: -- Standard IN Parameters :
929: -- p_api_version IN NUMBER Required
930: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
931: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
932: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
933: -- Based on this flag, the API will set the default attributes.
934: -- p_module_type In VARCHAR2 Default NULL
935: -- This will be null.
936: -- Standard OUT Parameters :

Line 947: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

943: -- List of item attributes associated to visit task
944: --
945: PROCEDURE Call_ATP (
946: p_api_version IN NUMBER,
947: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
948: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
949: p_x_planned_matrl_tbl IN OUT NOCOPY AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl,
950: x_return_status OUT NOCOPY VARCHAR2,
951: x_msg_count OUT NOCOPY NUMBER,

Line 948: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

944: --
945: PROCEDURE Call_ATP (
946: p_api_version IN NUMBER,
947: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
948: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
949: p_x_planned_matrl_tbl IN OUT NOCOPY AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl,
950: x_return_status OUT NOCOPY VARCHAR2,
951: x_msg_count OUT NOCOPY NUMBER,
952: x_msg_data OUT NOCOPY VARCHAR2)

Line 1038: IF FND_API.to_boolean(p_init_msg_list) THEN

1034: END IF;
1035: -- Standard Start of API savepoint
1036: SAVEPOINT Call_ATP;
1037: -- Initialize message list if p_init_msg_list is set to TRUE.
1038: IF FND_API.to_boolean(p_init_msg_list) THEN
1039: FND_MSG_PUB.initialize;
1040: END IF;
1041: -- Initialize API return status to success
1042: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1042: x_return_status := FND_API.G_RET_STS_SUCCESS;

1038: IF FND_API.to_boolean(p_init_msg_list) THEN
1039: FND_MSG_PUB.initialize;
1040: END IF;
1041: -- Initialize API return status to success
1042: x_return_status := FND_API.G_RET_STS_SUCCESS;
1043: -- Standard call to check for call compatibility.
1044: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1045: l_api_version,
1046: l_api_name,G_PKG_NAME)

Line 1044: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

1040: END IF;
1041: -- Initialize API return status to success
1042: x_return_status := FND_API.G_RET_STS_SUCCESS;
1043: -- Standard call to check for call compatibility.
1044: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1045: l_api_version,
1046: l_api_name,G_PKG_NAME)
1047: THEN
1048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1044: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1045: l_api_version,
1046: l_api_name,G_PKG_NAME)
1047: THEN
1048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1049: END IF;
1050:
1051: --Get session id
1052: SELECT MRP_ATP_SCHEDULE_TEMP_S.NEXTVAL

Line 1069: RAISE FND_API.G_EXC_ERROR;

1065: IF Instance_Id_Cur%NOTFOUND THEN
1066: FND_MESSAGE.Set_Name( 'AHL','AHL_LTP_ATP_INS_ENABLE' );
1067: FND_MSG_PUB.add;
1068: CLOSE Instance_Id_Cur;
1069: RAISE FND_API.G_EXC_ERROR;
1070: END IF;
1071: --
1072: CLOSE Instance_Id_Cur;
1073:

Line 1120: RAISE Fnd_Api.G_EXC_ERROR;

1116: --Added by sowsubra - start
1117: IF l_Planned_Order_Rec.status = 'IN-SERVICE' THEN
1118: Fnd_Message.SET_NAME('AHL','AHL_MAT_STS_INSERVICE');
1119: Fnd_Msg_Pub.ADD;
1120: RAISE Fnd_Api.G_EXC_ERROR;
1121: END IF;
1122: --Added by sowsubra - end
1123:
1124: --Get Concatenated visit number, task number

Line 1204: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1200: 'After calling Mrp Atp Pub.Call_ATP. Return Status : '|| x_return_status);
1201: END IF;
1202:
1203: -- Check Error Message stack.
1204: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1205: l_msg_count := FND_MSG_PUB.count_msg;
1206: IF l_msg_count > 0 THEN
1207: RAISE FND_API.G_EXC_ERROR;
1208: END IF;

Line 1207: RAISE FND_API.G_EXC_ERROR;

1203: -- Check Error Message stack.
1204: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1205: l_msg_count := FND_MSG_PUB.count_msg;
1206: IF l_msg_count > 0 THEN
1207: RAISE FND_API.G_EXC_ERROR;
1208: END IF;
1209: END IF;
1210:
1211: --Check for error code

Line 1314: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN

1310: END LOOP;
1311: END IF;
1312:
1313: -- Check Error Message stack.
1314: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
1315: l_msg_count := FND_MSG_PUB.count_msg;
1316: IF l_msg_count > 0 THEN
1317: RAISE FND_API.G_EXC_ERROR;
1318: END IF;

Line 1317: RAISE FND_API.G_EXC_ERROR;

1313: -- Check Error Message stack.
1314: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
1315: l_msg_count := FND_MSG_PUB.count_msg;
1316: IF l_msg_count > 0 THEN
1317: RAISE FND_API.G_EXC_ERROR;
1318: END IF;
1319: END IF;
1320: --Need to fix error messages
1321:

Line 1328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1324: L_DEBUG_KEY ||'.end',
1325: 'At the end of PL SQL procedure. Return Status = ' || x_return_status);
1326: END IF;
1327: EXCEPTION
1328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1329: ROLLBACK TO Call_ATP;
1330: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1331: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1332: p_count => l_msg_count,

Line 1330: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1326: END IF;
1327: EXCEPTION
1328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1329: ROLLBACK TO Call_ATP;
1330: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1331: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1332: p_count => l_msg_count,
1333: p_data => l_msg_data);
1334:

Line 1331: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1327: EXCEPTION
1328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1329: ROLLBACK TO Call_ATP;
1330: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1331: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1332: p_count => l_msg_count,
1333: p_data => l_msg_data);
1334:
1335: WHEN FND_API.G_EXC_ERROR THEN

Line 1335: WHEN FND_API.G_EXC_ERROR THEN

1331: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1332: p_count => l_msg_count,
1333: p_data => l_msg_data);
1334:
1335: WHEN FND_API.G_EXC_ERROR THEN
1336: ROLLBACK TO Call_ATP;
1337: X_return_status := FND_API.G_RET_STS_ERROR;
1338: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1339: p_count => l_msg_count,

Line 1337: X_return_status := FND_API.G_RET_STS_ERROR;

1333: p_data => l_msg_data);
1334:
1335: WHEN FND_API.G_EXC_ERROR THEN
1336: ROLLBACK TO Call_ATP;
1337: X_return_status := FND_API.G_RET_STS_ERROR;
1338: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1339: p_count => l_msg_count,
1340: p_data => l_msg_data);
1341:

Line 1338: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1334:
1335: WHEN FND_API.G_EXC_ERROR THEN
1336: ROLLBACK TO Call_ATP;
1337: X_return_status := FND_API.G_RET_STS_ERROR;
1338: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1339: p_count => l_msg_count,
1340: p_data => l_msg_data);
1341:
1342: WHEN OTHERS THEN

Line 1344: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1340: p_data => l_msg_data);
1341:
1342: WHEN OTHERS THEN
1343: ROLLBACK TO Call_ATP;
1344: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1345: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1346: THEN
1347: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',
1348: p_procedure_name => 'CALL_ATP',

Line 1351: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1347: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',
1348: p_procedure_name => 'CALL_ATP',
1349: p_error_text => SUBSTR(SQLERRM,1,240));
1350: END IF;
1351: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1352: p_count => l_msg_count,
1353: p_data => l_msg_data);
1354:
1355: END Call_ATP;

Line 1367: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

1363: -- Parameters :
1364: --
1365: -- Standard IN Parameters :
1366: -- p_api_version IN NUMBER Required
1367: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1368: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1369: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1370: -- Based on this flag, the API will set the default attributes.
1371: -- p_module_type In VARCHAR2 Default NULL

Line 1368: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

1364: --
1365: -- Standard IN Parameters :
1366: -- p_api_version IN NUMBER Required
1367: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1368: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1369: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1370: -- Based on this flag, the API will set the default attributes.
1371: -- p_module_type In VARCHAR2 Default NULL
1372: -- This will be null.

Line 1369: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

1365: -- Standard IN Parameters :
1366: -- p_api_version IN NUMBER Required
1367: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1368: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1369: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1370: -- Based on this flag, the API will set the default attributes.
1371: -- p_module_type In VARCHAR2 Default NULL
1372: -- This will be null.
1373: -- Standard OUT Parameters :

Line 1384: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

1380: -- List of item attributes associated to visit task
1381: --
1382: PROCEDURE Schedule_Planned_Matrls (
1383: p_api_version IN NUMBER,
1384: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1385: p_commit IN VARCHAR2 := FND_API.g_false,
1386: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1387: p_x_planned_matrl_tbl IN OUT NOCOPY AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl,
1388: x_return_status OUT NOCOPY VARCHAR2,

Line 1385: p_commit IN VARCHAR2 := FND_API.g_false,

1381: --
1382: PROCEDURE Schedule_Planned_Matrls (
1383: p_api_version IN NUMBER,
1384: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1385: p_commit IN VARCHAR2 := FND_API.g_false,
1386: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1387: p_x_planned_matrl_tbl IN OUT NOCOPY AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl,
1388: x_return_status OUT NOCOPY VARCHAR2,
1389: x_msg_count OUT NOCOPY NUMBER,

Line 1386: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

1382: PROCEDURE Schedule_Planned_Matrls (
1383: p_api_version IN NUMBER,
1384: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1385: p_commit IN VARCHAR2 := FND_API.g_false,
1386: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1387: p_x_planned_matrl_tbl IN OUT NOCOPY AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl,
1388: x_return_status OUT NOCOPY VARCHAR2,
1389: x_msg_count OUT NOCOPY NUMBER,
1390: x_msg_data OUT NOCOPY VARCHAR2)

Line 1492: IF FND_API.to_boolean(p_init_msg_list) THEN

1488: END IF;
1489: -- Standard Start of API savepoint
1490: SAVEPOINT schedule_planned_matrls;
1491: -- Initialize message list if p_init_msg_list is set to TRUE.
1492: IF FND_API.to_boolean(p_init_msg_list) THEN
1493: FND_MSG_PUB.initialize;
1494: END IF;
1495: -- Initialize API return status to success
1496: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1496: x_return_status := FND_API.G_RET_STS_SUCCESS;

1492: IF FND_API.to_boolean(p_init_msg_list) THEN
1493: FND_MSG_PUB.initialize;
1494: END IF;
1495: -- Initialize API return status to success
1496: x_return_status := FND_API.G_RET_STS_SUCCESS;
1497: -- Standard call to check for call compatibility.
1498: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1499: l_api_version,
1500: l_api_name,G_PKG_NAME)

Line 1498: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

1494: END IF;
1495: -- Initialize API return status to success
1496: x_return_status := FND_API.G_RET_STS_SUCCESS;
1497: -- Standard call to check for call compatibility.
1498: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1499: l_api_version,
1500: l_api_name,G_PKG_NAME)
1501: THEN
1502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1498: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1499: l_api_version,
1500: l_api_name,G_PKG_NAME)
1501: THEN
1502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1503: END IF;
1504:
1505: --
1506: IF l_planned_matrl_tbl.COUNT > 0 THEN

Line 1525: RAISE Fnd_Api.G_EXC_ERROR;

1521: --Added by sowsubra - starts
1522: IF l_planned_matrl_tbl(i).mat_status = 'IN-SERVICE' THEN
1523: Fnd_Message.SET_NAME('AHL','AHL_MAT_STS_INSERVICE');
1524: Fnd_Msg_Pub.ADD;
1525: RAISE Fnd_Api.G_EXC_ERROR;
1526: END IF;
1527: --Added by sowsubra - ends
1528: END LOOP;
1529: END IF;

Line 1575: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN

1571: ', Returned Final Records : '||l_temp_planned_matrl_tbl.COUNT);
1572: END IF;
1573:
1574: -- Check Error Message stack.
1575: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
1576: l_msg_count := FND_MSG_PUB.count_msg;
1577: IF l_msg_count > 0 THEN
1578: RAISE FND_API.G_EXC_ERROR;
1579: END IF;

Line 1578: RAISE FND_API.G_EXC_ERROR;

1574: -- Check Error Message stack.
1575: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
1576: l_msg_count := FND_MSG_PUB.count_msg;
1577: IF l_msg_count > 0 THEN
1578: RAISE FND_API.G_EXC_ERROR;
1579: END IF;
1580: END IF;
1581:
1582: --Assign out parameter

Line 1632: IF FND_API.TO_BOOLEAN(p_commit) THEN

1628: END LOOP;
1629: END IF;
1630:
1631: -- Standard check of p_commit
1632: IF FND_API.TO_BOOLEAN(p_commit) THEN
1633: COMMIT WORK;
1634: END IF;
1635:
1636: IF (l_log_procedure >= l_log_current_level) THEN

Line 1643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1639: 'At the end of PL SQL procedure. Return Status = ' || x_return_status);
1640: END IF;
1641:
1642: EXCEPTION
1643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1644: ROLLBACK TO Schedule_Planned_Matrls;
1645: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1646: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1647: p_count => l_msg_count,

Line 1645: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1641:
1642: EXCEPTION
1643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1644: ROLLBACK TO Schedule_Planned_Matrls;
1645: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1646: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1647: p_count => l_msg_count,
1648: p_data => l_msg_data);
1649:

Line 1646: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1642: EXCEPTION
1643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1644: ROLLBACK TO Schedule_Planned_Matrls;
1645: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1646: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1647: p_count => l_msg_count,
1648: p_data => l_msg_data);
1649:
1650: WHEN FND_API.G_EXC_ERROR THEN

Line 1650: WHEN FND_API.G_EXC_ERROR THEN

1646: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1647: p_count => l_msg_count,
1648: p_data => l_msg_data);
1649:
1650: WHEN FND_API.G_EXC_ERROR THEN
1651: ROLLBACK TO Schedule_Planned_Matrls;
1652: X_return_status := FND_API.G_RET_STS_ERROR;
1653: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1654: p_count => l_msg_count,

Line 1652: X_return_status := FND_API.G_RET_STS_ERROR;

1648: p_data => l_msg_data);
1649:
1650: WHEN FND_API.G_EXC_ERROR THEN
1651: ROLLBACK TO Schedule_Planned_Matrls;
1652: X_return_status := FND_API.G_RET_STS_ERROR;
1653: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1654: p_count => l_msg_count,
1655: p_data => l_msg_data);
1656:

Line 1653: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1649:
1650: WHEN FND_API.G_EXC_ERROR THEN
1651: ROLLBACK TO Schedule_Planned_Matrls;
1652: X_return_status := FND_API.G_RET_STS_ERROR;
1653: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1654: p_count => l_msg_count,
1655: p_data => l_msg_data);
1656:
1657: WHEN OTHERS THEN

Line 1659: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1655: p_data => l_msg_data);
1656:
1657: WHEN OTHERS THEN
1658: ROLLBACK TO Schedule_Planned_Matrls;
1659: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1660: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1661: THEN
1662: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',
1663: p_procedure_name => 'SCHEDULE_PLANNED_MATRLS',

Line 1666: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1662: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',
1663: p_procedure_name => 'SCHEDULE_PLANNED_MATRLS',
1664: p_error_text => SUBSTR(SQLERRM,1,240));
1665: END IF;
1666: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1667: p_count => l_msg_count,
1668: p_data => l_msg_data);
1669:
1670: END Schedule_Planned_Matrls;

Line 1682: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

1678: -- Parameters :
1679: --
1680: -- Standard IN Parameters :
1681: -- p_api_version IN NUMBER Required
1682: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1683: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1684: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1685: -- Based on this flag, the API will set the default attributes.
1686: -- p_module_type In VARCHAR2 Default NULL

Line 1683: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

1679: --
1680: -- Standard IN Parameters :
1681: -- p_api_version IN NUMBER Required
1682: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1683: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1684: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1685: -- Based on this flag, the API will set the default attributes.
1686: -- p_module_type In VARCHAR2 Default NULL
1687: -- This will be null.

Line 1684: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

1680: -- Standard IN Parameters :
1681: -- p_api_version IN NUMBER Required
1682: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1683: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1684: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1685: -- Based on this flag, the API will set the default attributes.
1686: -- p_module_type In VARCHAR2 Default NULL
1687: -- This will be null.
1688: -- Standard OUT Parameters :

Line 1699: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

1695: -- List of item attributes associated to visit task
1696: --
1697: PROCEDURE Schedule_All_Materials (
1698: p_api_version IN NUMBER,
1699: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1700: p_commit IN VARCHAR2 := FND_API.g_false,
1701: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1702: p_visit_id IN NUMBER,
1703: x_planned_matrl_tbl OUT NOCOPY AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl,

Line 1700: p_commit IN VARCHAR2 := FND_API.g_false,

1696: --
1697: PROCEDURE Schedule_All_Materials (
1698: p_api_version IN NUMBER,
1699: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1700: p_commit IN VARCHAR2 := FND_API.g_false,
1701: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1702: p_visit_id IN NUMBER,
1703: x_planned_matrl_tbl OUT NOCOPY AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl,
1704: x_return_status OUT NOCOPY VARCHAR2,

Line 1701: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

1697: PROCEDURE Schedule_All_Materials (
1698: p_api_version IN NUMBER,
1699: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1700: p_commit IN VARCHAR2 := FND_API.g_false,
1701: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1702: p_visit_id IN NUMBER,
1703: x_planned_matrl_tbl OUT NOCOPY AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl,
1704: x_return_status OUT NOCOPY VARCHAR2,
1705: x_msg_count OUT NOCOPY NUMBER,

Line 1755: IF FND_API.to_boolean(p_init_msg_list) THEN

1751: END IF;
1752: -- Standard Start of API savepoint
1753: SAVEPOINT Schedule_All_Materials;
1754: -- Initialize message list if p_init_msg_list is set to TRUE.
1755: IF FND_API.to_boolean(p_init_msg_list) THEN
1756: FND_MSG_PUB.initialize;
1757: END IF;
1758: -- Initialize API return status to success
1759: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1759: x_return_status := FND_API.G_RET_STS_SUCCESS;

1755: IF FND_API.to_boolean(p_init_msg_list) THEN
1756: FND_MSG_PUB.initialize;
1757: END IF;
1758: -- Initialize API return status to success
1759: x_return_status := FND_API.G_RET_STS_SUCCESS;
1760: -- Standard call to check for call compatibility.
1761: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1762: l_api_version,
1763: l_api_name,G_PKG_NAME)

Line 1761: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

1757: END IF;
1758: -- Initialize API return status to success
1759: x_return_status := FND_API.G_RET_STS_SUCCESS;
1760: -- Standard call to check for call compatibility.
1761: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1762: l_api_version,
1763: l_api_name,G_PKG_NAME)
1764: THEN
1765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1761: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1762: l_api_version,
1763: l_api_name,G_PKG_NAME)
1764: THEN
1765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1766: END IF;
1767:
1768: IF p_visit_id IS NOT NULL THEN
1769: OPEN Get_Visit_Task_Matrl_Cur(p_visit_id);

Line 1814: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN

1810: 'After calling Call ATP, Return Status : '|| l_return_status);
1811: END IF;
1812:
1813: -- Check Error Message stack.
1814: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
1815: l_msg_count := FND_MSG_PUB.count_msg;
1816: IF l_msg_count > 0 THEN
1817: RAISE FND_API.G_EXC_ERROR;
1818: END IF;

Line 1817: RAISE FND_API.G_EXC_ERROR;

1813: -- Check Error Message stack.
1814: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
1815: l_msg_count := FND_MSG_PUB.count_msg;
1816: IF l_msg_count > 0 THEN
1817: RAISE FND_API.G_EXC_ERROR;
1818: END IF;
1819: END IF;
1820: --Assign to out variable
1821: IF l_Planned_Matrl_Tbl.COUNT > 0 THEN

Line 1857: IF FND_API.TO_BOOLEAN(p_commit) THEN

1853: END IF;
1854: END LOOP;
1855: END IF;
1856: -- Standard check of p_commit
1857: IF FND_API.TO_BOOLEAN(p_commit) THEN
1858: COMMIT WORK;
1859: END IF;
1860:
1861: IF (l_log_procedure >= l_log_current_level) THEN

Line 1868: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1864: 'At the end of PL SQL procedure. Return Status = ' || x_return_status);
1865: END IF;
1866:
1867: EXCEPTION
1868: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1869: ROLLBACK TO Schedule_All_Materials;
1870: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1871: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1872: p_count => l_msg_count,

Line 1870: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1866:
1867: EXCEPTION
1868: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1869: ROLLBACK TO Schedule_All_Materials;
1870: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1871: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1872: p_count => l_msg_count,
1873: p_data => l_msg_data);
1874:

Line 1871: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1867: EXCEPTION
1868: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1869: ROLLBACK TO Schedule_All_Materials;
1870: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1871: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1872: p_count => l_msg_count,
1873: p_data => l_msg_data);
1874:
1875: WHEN FND_API.G_EXC_ERROR THEN

Line 1875: WHEN FND_API.G_EXC_ERROR THEN

1871: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1872: p_count => l_msg_count,
1873: p_data => l_msg_data);
1874:
1875: WHEN FND_API.G_EXC_ERROR THEN
1876: ROLLBACK TO Schedule_All_Materials;
1877: X_return_status := FND_API.G_RET_STS_ERROR;
1878: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1879: p_count => l_msg_count,

Line 1877: X_return_status := FND_API.G_RET_STS_ERROR;

1873: p_data => l_msg_data);
1874:
1875: WHEN FND_API.G_EXC_ERROR THEN
1876: ROLLBACK TO Schedule_All_Materials;
1877: X_return_status := FND_API.G_RET_STS_ERROR;
1878: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1879: p_count => l_msg_count,
1880: p_data => l_msg_data);
1881:

Line 1878: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1874:
1875: WHEN FND_API.G_EXC_ERROR THEN
1876: ROLLBACK TO Schedule_All_Materials;
1877: X_return_status := FND_API.G_RET_STS_ERROR;
1878: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1879: p_count => l_msg_count,
1880: p_data => l_msg_data);
1881:
1882: WHEN OTHERS THEN

Line 1884: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1880: p_data => l_msg_data);
1881:
1882: WHEN OTHERS THEN
1883: ROLLBACK TO Schedule_All_Materials;
1884: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1885: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1886: THEN
1887: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',
1888: p_procedure_name => 'SCHEDULE_ALL_MATERIALS',

Line 1891: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1887: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',
1888: p_procedure_name => 'SCHEDULE_ALL_MATERIALS',
1889: p_error_text => SUBSTR(SQLERRM,1,240));
1890: END IF;
1891: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1892: p_count => l_msg_count,
1893: p_data => l_msg_data);
1894:
1895: END Schedule_All_Materials;

Line 1909: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

1905: -- Parameters :
1906: --
1907: -- Standard IN Parameters :
1908: -- p_api_version IN NUMBER Required
1909: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1910: -- Standard OUT Parameters :
1911: -- x_return_status OUT VARCHAR2 Required
1912: -- x_msg_count OUT NUMBER Required
1913: -- x_msg_data OUT VARCHAR2 Required

Line 1920: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

1916: -- p_deleted_matrl_tbl IN Planned_Matrls_Tbl Required
1917: --
1918: PROCEDURE Unschedule_deleted_materials (
1919: p_api_version IN NUMBER,
1920: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1921: p_deleted_matrl_tbl IN AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl,
1922: x_return_status OUT NOCOPY VARCHAR2,
1923: x_msg_count OUT NOCOPY NUMBER,
1924: x_msg_data OUT NOCOPY VARCHAR2)

Line 1982: IF FND_API.to_boolean(p_init_msg_list) THEN

1978: -- Standard Start of API savepoint
1979: SAVEPOINT Unschedule_deleted_materials;
1980:
1981: -- Initialize message list if p_init_msg_list is set to TRUE.
1982: IF FND_API.to_boolean(p_init_msg_list) THEN
1983: FND_MSG_PUB.initialize;
1984: END IF;
1985:
1986: -- Initialize API return status to success

Line 1987: x_return_status := FND_API.G_RET_STS_SUCCESS;

1983: FND_MSG_PUB.initialize;
1984: END IF;
1985:
1986: -- Initialize API return status to success
1987: x_return_status := FND_API.G_RET_STS_SUCCESS;
1988:
1989: -- Standard call to check for call compatibility.
1990: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, l_api_version, l_api_name, G_PKG_NAME) THEN
1991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1990: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, l_api_version, l_api_name, G_PKG_NAME) THEN

1986: -- Initialize API return status to success
1987: x_return_status := FND_API.G_RET_STS_SUCCESS;
1988:
1989: -- Standard call to check for call compatibility.
1990: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, l_api_version, l_api_name, G_PKG_NAME) THEN
1991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1992: END IF;
1993:
1994: --Get session id

Line 1991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1987: x_return_status := FND_API.G_RET_STS_SUCCESS;
1988:
1989: -- Standard call to check for call compatibility.
1990: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, l_api_version, l_api_name, G_PKG_NAME) THEN
1991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1992: END IF;
1993:
1994: --Get session id
1995: SELECT MRP_ATP_SCHEDULE_TEMP_S.NEXTVAL

Line 2011: -- RAISE FND_API.G_EXC_ERROR;

2007: l_atp_instance_flag := FALSE;
2008: -- FND_MESSAGE.Set_Name( 'AHL','AHL_LTP_ATP_INS_ENABLE' );
2009: -- FND_MSG_PUB.add;
2010: -- CLOSE Instance_Id_Cur;
2011: -- RAISE FND_API.G_EXC_ERROR;
2012: END IF;
2013: CLOSE Instance_Id_Cur;
2014: IF (l_log_statement >= l_log_current_level) THEN
2015: fnd_log.string(l_log_statement, L_DEBUG_KEY, 'Instance Id: ' || l_instance_id);

Line 2032: RAISE FND_API.G_EXC_ERROR;

2028: CLOSE Get_Item_ATP_Flag;
2029: IF (l_ATP_flag <> 'N') THEN
2030: FND_MESSAGE.Set_Name('AHL','AHL_LTP_ATP_INS_ENABLE');
2031: FND_MSG_PUB.add;
2032: RAISE FND_API.G_EXC_ERROR;
2033: END IF;
2034: END IF;
2035: -- End changes by surrkuma on 11-JUN-2009 for the bug 9901811
2036:

Line 2083: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2079: 'After calling MRP_ATP_PUB.CALL_ATP. Return Status : ' || x_return_status);
2080: END IF;
2081:
2082: -- Check Error Message stack.
2083: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2084: l_msg_count := FND_MSG_PUB.count_msg;
2085: IF l_msg_count > 0 THEN
2086: RAISE FND_API.G_EXC_ERROR;
2087: END IF;

Line 2086: RAISE FND_API.G_EXC_ERROR;

2082: -- Check Error Message stack.
2083: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2084: l_msg_count := FND_MSG_PUB.count_msg;
2085: IF l_msg_count > 0 THEN
2086: RAISE FND_API.G_EXC_ERROR;
2087: END IF;
2088: END IF;
2089:
2090: --Check for error code

Line 2117: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN

2113: END LOOP;
2114: END IF;
2115:
2116: -- Check Error Message stack.
2117: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
2118: l_msg_count := FND_MSG_PUB.count_msg;
2119: IF l_msg_count > 0 THEN
2120: RAISE FND_API.G_EXC_ERROR;
2121: END IF;

Line 2120: RAISE FND_API.G_EXC_ERROR;

2116: -- Check Error Message stack.
2117: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
2118: l_msg_count := FND_MSG_PUB.count_msg;
2119: IF l_msg_count > 0 THEN
2120: RAISE FND_API.G_EXC_ERROR;
2121: END IF;
2122: END IF;
2123:
2124: IF (l_log_procedure >= l_log_current_level) THEN

Line 2130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2126: L_DEBUG_KEY ||'.end',
2127: 'At the end of PL SQL procedure. Return Status = ' || x_return_status);
2128: END IF;
2129: EXCEPTION
2130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2131: ROLLBACK TO Unschedule_deleted_materials;
2132: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2133: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2134: p_count => l_msg_count,

Line 2132: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2128: END IF;
2129: EXCEPTION
2130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2131: ROLLBACK TO Unschedule_deleted_materials;
2132: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2133: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2134: p_count => l_msg_count,
2135: p_data => l_msg_data);
2136:

Line 2133: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

2129: EXCEPTION
2130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2131: ROLLBACK TO Unschedule_deleted_materials;
2132: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2133: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2134: p_count => l_msg_count,
2135: p_data => l_msg_data);
2136:
2137: WHEN FND_API.G_EXC_ERROR THEN

Line 2137: WHEN FND_API.G_EXC_ERROR THEN

2133: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2134: p_count => l_msg_count,
2135: p_data => l_msg_data);
2136:
2137: WHEN FND_API.G_EXC_ERROR THEN
2138: ROLLBACK TO Unschedule_deleted_materials;
2139: X_return_status := FND_API.G_RET_STS_ERROR;
2140: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2141: p_count => l_msg_count,

Line 2139: X_return_status := FND_API.G_RET_STS_ERROR;

2135: p_data => l_msg_data);
2136:
2137: WHEN FND_API.G_EXC_ERROR THEN
2138: ROLLBACK TO Unschedule_deleted_materials;
2139: X_return_status := FND_API.G_RET_STS_ERROR;
2140: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2141: p_count => l_msg_count,
2142: p_data => l_msg_data);
2143:

Line 2140: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

2136:
2137: WHEN FND_API.G_EXC_ERROR THEN
2138: ROLLBACK TO Unschedule_deleted_materials;
2139: X_return_status := FND_API.G_RET_STS_ERROR;
2140: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2141: p_count => l_msg_count,
2142: p_data => l_msg_data);
2143:
2144: WHEN OTHERS THEN

Line 2146: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2142: p_data => l_msg_data);
2143:
2144: WHEN OTHERS THEN
2145: ROLLBACK TO Unschedule_deleted_materials;
2146: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2147: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2148: THEN
2149: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',
2150: p_procedure_name => 'Unschedule_deleted_materials',

Line 2153: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

2149: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',
2150: p_procedure_name => 'Unschedule_deleted_materials',
2151: p_error_text => SUBSTR(SQLERRM,1,240));
2152: END IF;
2153: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2154: p_count => l_msg_count,
2155: p_data => l_msg_data);
2156:
2157: END Unschedule_deleted_materials;