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 230: l_msg_count := FND_MSG_PUB.count_msg;

226: END IF;
227:
228: -- Check Error Message stack.
229: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
230: l_msg_count := FND_MSG_PUB.count_msg;
231: IF l_msg_count > 0 THEN
232: RAISE FND_API.G_EXC_ERROR;
233: END IF;
234: END IF;

Line 348: l_msg_count := FND_MSG_PUB.count_msg;

344: END IF;
345:
346: -- Check Error Message stack.
347: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
348: l_msg_count := FND_MSG_PUB.count_msg;
349: IF l_msg_count > 0 THEN
350: RAISE FND_API.G_EXC_ERROR;
351: END IF;
352: END IF;

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

360: EXCEPTION
361: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
362: ROLLBACK TO check_availability;
363: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
364: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
365: p_count => l_msg_count,
366: p_data => l_msg_data);
367:
368: WHEN FND_API.G_EXC_ERROR THEN

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

367:
368: WHEN FND_API.G_EXC_ERROR THEN
369: ROLLBACK TO check_availability;
370: X_return_status := FND_API.G_RET_STS_ERROR;
371: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
372: p_count => l_msg_count,
373: p_data => l_msg_data);
374:
375: WHEN OTHERS THEN

Line 378: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

374:
375: WHEN OTHERS THEN
376: ROLLBACK TO check_availability;
377: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
378: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
379: THEN
380: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',
381: p_procedure_name => 'CHECK_AVAILABILITY',
382: p_error_text => SUBSTR(SQLERRM,1,240));

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

376: ROLLBACK TO check_availability;
377: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
378: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
379: THEN
380: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',
381: p_procedure_name => 'CHECK_AVAILABILITY',
382: p_error_text => SUBSTR(SQLERRM,1,240));
383: END IF;
384: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

380: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',
381: p_procedure_name => 'CHECK_AVAILABILITY',
382: p_error_text => SUBSTR(SQLERRM,1,240));
383: END IF;
384: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
385: p_count => l_msg_count,
386: p_data => l_msg_data);
387:
388: END Check_Availability;

Line 474: FND_MSG_PUB.initialize;

470: SAVEPOINT check_material_aval;
471: -- Standard call to check for call compatibility.
472: IF FND_API.to_boolean(p_init_msg_list)
473: THEN
474: FND_MSG_PUB.initialize;
475: END IF;
476: -- Initialize API return status to success
477: x_return_status := FND_API.G_RET_STS_SUCCESS;
478: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 498: Fnd_Msg_Pub.ADD;

494: OPEN Check_Sch_Visit_cur(p_x_material_avl_tbl(1).visit_id);
495: FETCH Check_Sch_Visit_cur INTO l_dummy;
496: IF Check_Sch_Visit_cur%FOUND THEN
497: Fnd_Message.SET_NAME('AHL','AHL_VISIT_UNSCHEDULED');
498: Fnd_Msg_Pub.ADD;
499: CLOSE Check_Sch_Visit_cur;
500: RAISE Fnd_Api.G_EXC_ERROR;
501: END IF;
502: CLOSE Check_Sch_Visit_cur;

Line 527: Fnd_Msg_Pub.ADD;

523: OPEN Schedule_Matrl_cur(p_x_material_avl_tbl(i).schedule_material_id);
524: FETCH Schedule_Matrl_cur INTO l_Schedule_Matrl_Rec;
525: IF Schedule_Matrl_cur%NOTFOUND THEN
526: Fnd_Message.SET_NAME('AHL','AHL_LTP_ORG_ID_NOT_EXISTS');
527: Fnd_Msg_Pub.ADD;
528: CLOSE Schedule_Matrl_cur;
529: RAISE Fnd_Api.G_EXC_ERROR;
530: END IF;
531: CLOSE Schedule_Matrl_cur;

Line 536: Fnd_Msg_Pub.ADD;

532:
533: --Added by sowsubra - starts
534: IF l_Schedule_Matrl_Rec.status = 'IN-SERVICE' THEN
535: Fnd_Message.SET_NAME('AHL','AHL_MAT_STS_INSERVICE');
536: Fnd_Msg_Pub.ADD;
537: RAISE Fnd_Api.G_EXC_ERROR;
538: END IF;
539: --Added by sowsubra - ends
540:

Line 576: l_msg_count := FND_MSG_PUB.count_msg;

572: END IF;
573:
574: -- Check Error Message stack.
575: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
576: l_msg_count := FND_MSG_PUB.count_msg;
577: IF l_msg_count > 0 THEN
578: RAISE FND_API.G_EXC_ERROR;
579: END IF;
580: END IF;

Line 619: l_msg_count := FND_MSG_PUB.count_msg;

615: END IF;
616:
617: -- Check Error Message stack.
618: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
619: l_msg_count := FND_MSG_PUB.count_msg;
620: IF l_msg_count > 0 THEN
621: RAISE FND_API.G_EXC_ERROR;
622: END IF;
623: END IF;

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

631: EXCEPTION
632: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
633: ROLLBACK TO check_material_aval;
634: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
635: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
636: p_count => l_msg_count,
637: p_data => l_msg_data);
638:
639: WHEN FND_API.G_EXC_ERROR THEN

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

638:
639: WHEN FND_API.G_EXC_ERROR THEN
640: ROLLBACK TO check_material_aval;
641: X_return_status := FND_API.G_RET_STS_ERROR;
642: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
643: p_count => l_msg_count,
644: p_data => l_msg_data);
645:
646: WHEN OTHERS THEN

Line 649: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

645:
646: WHEN OTHERS THEN
647: ROLLBACK TO check_material_aval;
648: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
649: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
650: THEN
651: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',
652: p_procedure_name => 'CHECK_MATERIAL_AVAL',
653: p_error_text => SUBSTR(SQLERRM,1,240));

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

647: ROLLBACK TO check_material_aval;
648: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
649: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
650: THEN
651: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',
652: p_procedure_name => 'CHECK_MATERIAL_AVAL',
653: p_error_text => SUBSTR(SQLERRM,1,240));
654: END IF;
655: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

651: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',
652: p_procedure_name => 'CHECK_MATERIAL_AVAL',
653: p_error_text => SUBSTR(SQLERRM,1,240));
654: END IF;
655: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
656: p_count => l_msg_count,
657: p_data => l_msg_data);
658:
659: END Check_Material_Aval;

Line 742: FND_MSG_PUB.initialize;

738: -- Standard Start of API savepoint
739: SAVEPOINT Get_Visit_Task_Materials;
740: -- Initialize message list if p_init_msg_list is set to TRUE.
741: IF FND_API.to_boolean(p_init_msg_list) THEN
742: FND_MSG_PUB.initialize;
743: END IF;
744: -- Initialize API return status to success
745: x_return_status := FND_API.G_RET_STS_SUCCESS;
746: -- Standard call to check for call compatibility.

Line 784: l_msg_count := FND_MSG_PUB.count_msg;

780: END IF;
781:
782: -- Check Error Message stack.
783: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
784: l_msg_count := FND_MSG_PUB.count_msg;
785: IF l_msg_count > 0 THEN
786: RAISE FND_API.G_EXC_ERROR;
787: END IF;
788: END IF;

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

796: EXCEPTION
797: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
798: ROLLBACK TO Get_Visit_Task_Materials;
799: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
800: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
801: p_count => l_msg_count,
802: p_data => l_msg_data);
803: WHEN FND_API.G_EXC_ERROR THEN
804: ROLLBACK TO Get_Visit_Task_Materials;

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

802: p_data => l_msg_data);
803: WHEN FND_API.G_EXC_ERROR THEN
804: ROLLBACK TO Get_Visit_Task_Materials;
805: X_return_status := FND_API.G_RET_STS_ERROR;
806: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
807: p_count => l_msg_count,
808: p_data => l_msg_data);
809: WHEN OTHERS THEN
810: ROLLBACK TO Get_Visit_Task_Materials;

Line 812: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

808: p_data => l_msg_data);
809: WHEN OTHERS THEN
810: ROLLBACK TO Get_Visit_Task_Materials;
811: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
812: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
813: THEN
814: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',
815: p_procedure_name => 'GET_VISIT_TASK_MATERIALS',
816: p_error_text => SUBSTR(SQLERRM,1,240));

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

810: ROLLBACK TO Get_Visit_Task_Materials;
811: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
812: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
813: THEN
814: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',
815: p_procedure_name => 'GET_VISIT_TASK_MATERIALS',
816: p_error_text => SUBSTR(SQLERRM,1,240));
817: END IF;
818: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

814: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',
815: p_procedure_name => 'GET_VISIT_TASK_MATERIALS',
816: p_error_text => SUBSTR(SQLERRM,1,240));
817: END IF;
818: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
819: p_count => l_msg_count,
820: p_data => l_msg_data);
821: END Get_Visit_Task_Materials;
822: --

Line 1011: FND_MSG_PUB.initialize;

1007: -- Standard Start of API savepoint
1008: SAVEPOINT Call_ATP;
1009: -- Initialize message list if p_init_msg_list is set to TRUE.
1010: IF FND_API.to_boolean(p_init_msg_list) THEN
1011: FND_MSG_PUB.initialize;
1012: END IF;
1013: -- Initialize API return status to success
1014: x_return_status := FND_API.G_RET_STS_SUCCESS;
1015: -- Standard call to check for call compatibility.

Line 1039: FND_MSG_PUB.add;

1035: OPEN Instance_Id_Cur;
1036: FETCH Instance_Id_Cur INTO l_instance_id;
1037: IF Instance_Id_Cur%NOTFOUND THEN
1038: FND_MESSAGE.Set_Name( 'AHL','AHL_LTP_ATP_INS_ENABLE' );
1039: FND_MSG_PUB.add;
1040: CLOSE Instance_Id_Cur;
1041: RAISE FND_API.G_EXC_ERROR;
1042: END IF;
1043: --

Line 1083: Fnd_Msg_Pub.ADD;

1079:
1080: --Added by sowsubra - start
1081: IF l_Planned_Order_Rec.status = 'IN-SERVICE' THEN
1082: Fnd_Message.SET_NAME('AHL','AHL_MAT_STS_INSERVICE');
1083: Fnd_Msg_Pub.ADD;
1084: RAISE Fnd_Api.G_EXC_ERROR;
1085: END IF;
1086: --Added by sowsubra - end
1087:

Line 1166: l_msg_count := FND_MSG_PUB.count_msg;

1162: END IF;
1163:
1164: -- Check Error Message stack.
1165: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1166: l_msg_count := FND_MSG_PUB.count_msg;
1167: IF l_msg_count > 0 THEN
1168: RAISE FND_API.G_EXC_ERROR;
1169: END IF;
1170: END IF;

Line 1261: l_msg_count := FND_MSG_PUB.count_msg;

1257: END IF;
1258:
1259: -- Check Error Message stack.
1260: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
1261: l_msg_count := FND_MSG_PUB.count_msg;
1262: IF l_msg_count > 0 THEN
1263: RAISE FND_API.G_EXC_ERROR;
1264: END IF;
1265: END IF;

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

1273: EXCEPTION
1274: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1275: ROLLBACK TO Call_ATP;
1276: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1277: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1278: p_count => l_msg_count,
1279: p_data => l_msg_data);
1280:
1281: WHEN FND_API.G_EXC_ERROR THEN

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

1280:
1281: WHEN FND_API.G_EXC_ERROR THEN
1282: ROLLBACK TO Call_ATP;
1283: X_return_status := FND_API.G_RET_STS_ERROR;
1284: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1285: p_count => l_msg_count,
1286: p_data => l_msg_data);
1287:
1288: WHEN OTHERS THEN

Line 1291: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1287:
1288: WHEN OTHERS THEN
1289: ROLLBACK TO Call_ATP;
1290: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1291: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1292: THEN
1293: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',
1294: p_procedure_name => 'CALL_ATP',
1295: p_error_text => SUBSTR(SQLERRM,1,240));

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

1289: ROLLBACK TO Call_ATP;
1290: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1291: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1292: THEN
1293: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',
1294: p_procedure_name => 'CALL_ATP',
1295: p_error_text => SUBSTR(SQLERRM,1,240));
1296: END IF;
1297: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

1293: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',
1294: p_procedure_name => 'CALL_ATP',
1295: p_error_text => SUBSTR(SQLERRM,1,240));
1296: END IF;
1297: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1298: p_count => l_msg_count,
1299: p_data => l_msg_data);
1300:
1301: END Call_ATP;

Line 1394: FND_MSG_PUB.initialize;

1390: -- Standard Start of API savepoint
1391: SAVEPOINT schedule_planned_matrls;
1392: -- Initialize message list if p_init_msg_list is set to TRUE.
1393: IF FND_API.to_boolean(p_init_msg_list) THEN
1394: FND_MSG_PUB.initialize;
1395: END IF;
1396: -- Initialize API return status to success
1397: x_return_status := FND_API.G_RET_STS_SUCCESS;
1398: -- Standard call to check for call compatibility.

Line 1425: Fnd_Msg_Pub.ADD;

1421:
1422: --Added by sowsubra - starts
1423: IF l_planned_matrl_tbl(i).mat_status = 'IN-SERVICE' THEN
1424: Fnd_Message.SET_NAME('AHL','AHL_MAT_STS_INSERVICE');
1425: Fnd_Msg_Pub.ADD;
1426: RAISE Fnd_Api.G_EXC_ERROR;
1427: END IF;
1428: --Added by sowsubra - ends
1429: END LOOP;

Line 1477: l_msg_count := FND_MSG_PUB.count_msg;

1473: END IF;
1474:
1475: -- Check Error Message stack.
1476: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
1477: l_msg_count := FND_MSG_PUB.count_msg;
1478: IF l_msg_count > 0 THEN
1479: RAISE FND_API.G_EXC_ERROR;
1480: END IF;
1481: END IF;

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

1541: EXCEPTION
1542: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1543: ROLLBACK TO Schedule_Planned_Matrls;
1544: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1545: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1546: p_count => l_msg_count,
1547: p_data => l_msg_data);
1548:
1549: WHEN FND_API.G_EXC_ERROR THEN

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

1548:
1549: WHEN FND_API.G_EXC_ERROR THEN
1550: ROLLBACK TO Schedule_Planned_Matrls;
1551: X_return_status := FND_API.G_RET_STS_ERROR;
1552: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1553: p_count => l_msg_count,
1554: p_data => l_msg_data);
1555:
1556: WHEN OTHERS THEN

Line 1559: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1555:
1556: WHEN OTHERS THEN
1557: ROLLBACK TO Schedule_Planned_Matrls;
1558: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1559: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1560: THEN
1561: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',
1562: p_procedure_name => 'SCHEDULE_PLANNED_MATRLS',
1563: p_error_text => SUBSTR(SQLERRM,1,240));

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

1557: ROLLBACK TO Schedule_Planned_Matrls;
1558: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1559: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1560: THEN
1561: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',
1562: p_procedure_name => 'SCHEDULE_PLANNED_MATRLS',
1563: p_error_text => SUBSTR(SQLERRM,1,240));
1564: END IF;
1565: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

1561: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',
1562: p_procedure_name => 'SCHEDULE_PLANNED_MATRLS',
1563: p_error_text => SUBSTR(SQLERRM,1,240));
1564: END IF;
1565: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1566: p_count => l_msg_count,
1567: p_data => l_msg_data);
1568:
1569: END Schedule_Planned_Matrls;

Line 1653: FND_MSG_PUB.initialize;

1649: -- Standard Start of API savepoint
1650: SAVEPOINT Schedule_All_Materials;
1651: -- Initialize message list if p_init_msg_list is set to TRUE.
1652: IF FND_API.to_boolean(p_init_msg_list) THEN
1653: FND_MSG_PUB.initialize;
1654: END IF;
1655: -- Initialize API return status to success
1656: x_return_status := FND_API.G_RET_STS_SUCCESS;
1657: -- Standard call to check for call compatibility.

Line 1712: l_msg_count := FND_MSG_PUB.count_msg;

1708: END IF;
1709:
1710: -- Check Error Message stack.
1711: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
1712: l_msg_count := FND_MSG_PUB.count_msg;
1713: IF l_msg_count > 0 THEN
1714: RAISE FND_API.G_EXC_ERROR;
1715: END IF;
1716: END IF;

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

1762: EXCEPTION
1763: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1764: ROLLBACK TO Schedule_All_Materials;
1765: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1766: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1767: p_count => l_msg_count,
1768: p_data => l_msg_data);
1769:
1770: WHEN FND_API.G_EXC_ERROR THEN

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

1769:
1770: WHEN FND_API.G_EXC_ERROR THEN
1771: ROLLBACK TO Schedule_All_Materials;
1772: X_return_status := FND_API.G_RET_STS_ERROR;
1773: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1774: p_count => l_msg_count,
1775: p_data => l_msg_data);
1776:
1777: WHEN OTHERS THEN

Line 1780: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1776:
1777: WHEN OTHERS THEN
1778: ROLLBACK TO Schedule_All_Materials;
1779: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1780: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1781: THEN
1782: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',
1783: p_procedure_name => 'SCHEDULE_ALL_MATERIALS',
1784: p_error_text => SUBSTR(SQLERRM,1,240));

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

1778: ROLLBACK TO Schedule_All_Materials;
1779: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1780: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1781: THEN
1782: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',
1783: p_procedure_name => 'SCHEDULE_ALL_MATERIALS',
1784: p_error_text => SUBSTR(SQLERRM,1,240));
1785: END IF;
1786: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

1782: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PVT',
1783: p_procedure_name => 'SCHEDULE_ALL_MATERIALS',
1784: p_error_text => SUBSTR(SQLERRM,1,240));
1785: END IF;
1786: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1787: p_count => l_msg_count,
1788: p_data => l_msg_data);
1789:
1790: END Schedule_All_Materials;