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_MSG_PUB

Line 135: FND_MSG_PUB.add;

131: OPEN Instance_Id_Cur;
132: FETCH Instance_Id_Cur INTO l_instance_id;
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;

Line 243: l_msg_count := FND_MSG_PUB.count_msg;

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;
247: END IF;

Line 365: l_msg_count := FND_MSG_PUB.count_msg;

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;
369: END IF;

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 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 395: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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',
399: p_error_text => SUBSTR(SQLERRM,1,240));

Line 397: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',

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',
399: p_error_text => SUBSTR(SQLERRM,1,240));
400: END IF;
401: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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 491: FND_MSG_PUB.initialize;

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
494: x_return_status := FND_API.G_RET_STS_SUCCESS;
495: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 515: Fnd_Msg_Pub.ADD;

511: OPEN Check_Sch_Visit_cur(p_x_material_avl_tbl(1).visit_id);
512: FETCH Check_Sch_Visit_cur INTO l_dummy;
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;

Line 544: Fnd_Msg_Pub.ADD;

540: OPEN Schedule_Matrl_cur(p_x_material_avl_tbl(i).schedule_material_id);
541: FETCH Schedule_Matrl_cur INTO l_Schedule_Matrl_Rec;
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;

Line 553: Fnd_Msg_Pub.ADD;

549:
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:

Line 593: l_msg_count := FND_MSG_PUB.count_msg;

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;
597: END IF;

Line 643: l_msg_count := FND_MSG_PUB.count_msg;

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;
647: END IF;

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 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 673: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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',
677: p_error_text => SUBSTR(SQLERRM,1,240));

Line 675: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',

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',
677: p_error_text => SUBSTR(SQLERRM,1,240));
678: END IF;
679: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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 768: FND_MSG_PUB.initialize;

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;
772: -- Standard call to check for call compatibility.

Line 810: l_msg_count := FND_MSG_PUB.count_msg;

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;
814: END IF;

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 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 838: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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',
842: p_error_text => SUBSTR(SQLERRM,1,240));

Line 840: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',

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',
842: p_error_text => SUBSTR(SQLERRM,1,240));
843: END IF;
844: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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 1039: FND_MSG_PUB.initialize;

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;
1043: -- Standard call to check for call compatibility.

Line 1067: FND_MSG_PUB.add;

1063: OPEN Instance_Id_Cur;
1064: FETCH Instance_Id_Cur INTO l_instance_id;
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: --

Line 1119: Fnd_Msg_Pub.ADD;

1115:
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:

Line 1205: l_msg_count := FND_MSG_PUB.count_msg;

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;
1209: END IF;

Line 1315: l_msg_count := FND_MSG_PUB.count_msg;

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;
1319: END IF;

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 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 1345: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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',
1349: p_error_text => SUBSTR(SQLERRM,1,240));

Line 1347: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',

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',
1349: p_error_text => SUBSTR(SQLERRM,1,240));
1350: END IF;
1351: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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 1493: FND_MSG_PUB.initialize;

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;
1497: -- Standard call to check for call compatibility.

Line 1524: Fnd_Msg_Pub.ADD;

1520:
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;

Line 1576: l_msg_count := FND_MSG_PUB.count_msg;

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;
1580: END IF;

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 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 1660: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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',
1664: p_error_text => SUBSTR(SQLERRM,1,240));

Line 1662: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',

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',
1664: p_error_text => SUBSTR(SQLERRM,1,240));
1665: END IF;
1666: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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 1756: FND_MSG_PUB.initialize;

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;
1760: -- Standard call to check for call compatibility.

Line 1815: l_msg_count := FND_MSG_PUB.count_msg;

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;
1819: END IF;

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 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 1885: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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',
1889: p_error_text => SUBSTR(SQLERRM,1,240));

Line 1887: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',

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',
1889: p_error_text => SUBSTR(SQLERRM,1,240));
1890: END IF;
1891: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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 1983: FND_MSG_PUB.initialize;

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
1987: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2009: -- FND_MSG_PUB.add;

2005: FETCH Instance_Id_Cur INTO l_instance_id;
2006: IF Instance_Id_Cur%NOTFOUND THEN
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;

Line 2031: FND_MSG_PUB.add;

2027: FETCH Get_Item_ATP_Flag INTO l_ATP_flag;
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

Line 2084: l_msg_count := FND_MSG_PUB.count_msg;

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;
2088: END IF;

Line 2118: l_msg_count := FND_MSG_PUB.count_msg;

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;
2122: END IF;

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 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 2147: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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',
2151: p_error_text => SUBSTR(SQLERRM,1,240));

Line 2149: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',

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',
2151: p_error_text => SUBSTR(SQLERRM,1,240));
2152: END IF;
2153: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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;