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_UA_FLIGHT_SCHEDULES_PUB dependencies on FND_MSG_PUB

Line 65: FND_MSG_PUB.initialize;

61: END IF;
62:
63: -- Initialize message list if p_init_msg_list is set to TRUE.
64: IF FND_API.to_boolean(p_init_msg_list) THEN
65: FND_MSG_PUB.initialize;
66: END IF;
67:
68: -- Validations for dates-based search... If dates criteria applied to arrival / departure, then both start and end need to be passed
69: IF (p_flight_search_rec.DATE_APPLY_TO_FLAG IS NOT NULL AND (p_flight_search_rec.START_DATE IS NULL OR p_flight_search_rec.END_DATE IS NULL))

Line 72: FND_MSG_PUB.add;

68: -- Validations for dates-based search... If dates criteria applied to arrival / departure, then both start and end need to be passed
69: IF (p_flight_search_rec.DATE_APPLY_TO_FLAG IS NOT NULL AND (p_flight_search_rec.START_DATE IS NULL OR p_flight_search_rec.END_DATE IS NULL))
70: THEN
71: FND_MESSAGE.set_name('AHL', 'AHL_UA_SEARCH_DATE_APP_FLAG');
72: FND_MSG_PUB.add;
73:
74: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
75: END IF;
76:

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

452: EXCEPTION
453: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
454: --ROLLBACK TO search_flight_schedules_pub;
455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
456: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
457: p_count => x_msg_count,
458: p_data => x_msg_data);
459:
460: WHEN OTHERS THEN

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

459:
460: WHEN OTHERS THEN
461: --ROLLBACK TO search_flight_schedules_pub;
462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
463: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
464: THEN
465: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
466: p_procedure_name => l_api_name,
467: p_error_text => SUBSTR(SQLERRM,1,240));

Line 465: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

461: --ROLLBACK TO search_flight_schedules_pub;
462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
463: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
464: THEN
465: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
466: p_procedure_name => l_api_name,
467: p_error_text => SUBSTR(SQLERRM,1,240));
468:
469: END IF;

Line 523: FND_MSG_PUB.initialize;

519: END IF;
520:
521: -- Initialize message list if p_init_msg_list is set to TRUE.
522: IF FND_API.to_boolean(p_init_msg_list) THEN
523: FND_MSG_PUB.initialize;
524: END IF;
525:
526:
527: FOR i IN p_x_flight_schedules_tbl.FIRST..p_x_flight_schedules_tbl.LAST

Line 537: FND_MSG_PUB.add;

533: THEN
534: FND_MESSAGE.set_name( 'AHL','AHL_COM_INVALID_DML' );
535: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
536: FND_MESSAGE.set_token( 'FIELD', p_x_flight_schedules_tbl(i).DML_OPERATION);
537: FND_MSG_PUB.add;
538: END IF;
539:
540:
541: --Obj version number and Unit Schedule id check in case of update or delete.

Line 551: FND_MSG_PUB.add;

547: p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID = FND_API.G_MISS_NUM)
548: THEN
549: FND_MESSAGE.set_name( 'AHL','AHL_UA_US_NOT_FOUND' );
550: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
551: FND_MSG_PUB.add;
552: END IF;
553:
554: -- Check for Object Version number.
555: IF (p_x_flight_schedules_tbl(i).OBJECT_VERSION_NUMBER IS NULL OR

Line 560: FND_MSG_PUB.add;

556: p_x_flight_schedules_tbl(i).OBJECT_VERSION_NUMBER = FND_API.G_MISS_NUM)
557: THEN
558: FND_MESSAGE.set_name( 'AHL','AHL_UA_OBJ_VERNO_NULL' );
559: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
560: FND_MSG_PUB.add;
561: END IF;
562: END IF;
563:
564: IF p_x_flight_schedules_tbl(i).DML_OPERATION = 'C' OR

Line 578: FND_MSG_PUB.add;

574:
575: THEN
576: FND_MESSAGE.set_name( 'AHL','AHL_UA_INV_UC_NAME' );
577: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
578: FND_MSG_PUB.add;
579: END IF;
580:
581: --Flight Number is a mandatory input field and cannot be null.
582: IF p_x_flight_schedules_tbl(i).FLIGHT_NUMBER IS NULL OR

Line 587: FND_MSG_PUB.add;

583: p_x_flight_schedules_tbl(i).FLIGHT_NUMBER = FND_API.G_MISS_CHAR
584: THEN
585: FND_MESSAGE.set_name( 'AHL','AHL_UA_FLG_NUMBER_NULL' );
586: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
587: FND_MSG_PUB.add;
588: END IF;
589:
590: --Segment is a mandatory input field and cannot be null
591: IF p_x_flight_schedules_tbl(i).SEGMENT IS NULL OR

Line 596: FND_MSG_PUB.add;

592: p_x_flight_schedules_tbl(i).SEGMENT = FND_API.G_MISS_CHAR
593: THEN
594: FND_MESSAGE.set_name( 'AHL','AHL_UA_SEGMENT_NULL' );
595: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
596: FND_MSG_PUB.add;
597: END IF;
598:
599: --Departure_Dept_Id is a mandatory input field and cannot be null
600: IF ( p_x_flight_schedules_tbl(i).DEPARTURE_DEPT_ID IS NULL OR

Line 607: FND_MSG_PUB.add;

603: p_x_flight_schedules_tbl(i).DEPARTURE_DEPT_CODE = FND_API.G_MISS_CHAR )
604: THEN
605: FND_MESSAGE.set_name( 'AHL','AHL_UA_DEP_DEPT_NULL' );
606: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
607: FND_MSG_PUB.add;
608: END IF;
609:
610: --Departure_Org_Id is a mandatory input field and cannot be null
611: IF ( p_x_flight_schedules_tbl(i).DEPARTURE_ORG_ID IS NULL OR

Line 618: FND_MSG_PUB.add;

614: p_x_flight_schedules_tbl(i).DEPARTURE_ORG_CODE = FND_API.G_MISS_CHAR )
615: THEN
616: FND_MESSAGE.set_name( 'AHL','AHL_UA_DEP_ORG_NULL' );
617: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
618: FND_MSG_PUB.add;
619: END IF;
620:
621: --Arrival_Dept_Id is a mandatory input field and cannot be null
622: IF ( p_x_flight_schedules_tbl(i).ARRIVAL_DEPT_ID IS NULL OR

Line 630: FND_MSG_PUB.add;

626:
627: THEN
628: FND_MESSAGE.set_name( 'AHL','AHL_UA_ARR_DEPT_NULL' );
629: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
630: FND_MSG_PUB.add;
631: END IF;
632:
633: --Arrival_Org_Id is a mandatory input field and cannot be null
634: IF ( p_x_flight_schedules_tbl(i).ARRIVAL_ORG_ID IS NULL OR

Line 641: FND_MSG_PUB.add;

637: p_x_flight_schedules_tbl(i).ARRIVAL_ORG_CODE = FND_API.G_MISS_CHAR )
638: THEN
639: FND_MESSAGE.set_name( 'AHL','AHL_UA_ARR_ORG_NULL' );
640: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
641: FND_MSG_PUB.add;
642: END IF;
643:
644: --Est_Departure_Time is a mandatory input field and cannot be null
645: IF p_x_flight_schedules_tbl(i).EST_DEPARTURE_TIME IS NULL OR

Line 650: FND_MSG_PUB.add;

646: p_x_flight_schedules_tbl(i).EST_DEPARTURE_TIME = FND_API.G_MISS_DATE
647: THEN
648: FND_MESSAGE.set_name( 'AHL','AHL_UA_EST_DEP_TIME_NULL' );
649: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
650: FND_MSG_PUB.add;
651: END IF;
652:
653: --Est_Arrival_Time is a mandatory input field and cannot be null
654: IF p_x_flight_schedules_tbl(i).EST_ARRIVAL_TIME IS NULL OR

Line 659: FND_MSG_PUB.add;

655: p_x_flight_schedules_tbl(i).EST_ARRIVAL_TIME = FND_API.G_MISS_DATE
656: THEN
657: FND_MESSAGE.set_name( 'AHL','AHL_UA_EST_ARR_TIME_NULL' );
658: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
659: FND_MSG_PUB.add;
660: END IF;
661:
662: --Visit_Reschedule_Mode is a mandatory input field and cannot be null
663: IF ( p_x_flight_schedules_tbl(i).VISIT_RESCHEDULE_MODE IS NULL OR

Line 670: FND_MSG_PUB.add;

666: p_x_flight_schedules_tbl(i).VISIT_RESCHEDULE_MEANING = FND_API.G_MISS_CHAR )
667: THEN
668: FND_MESSAGE.set_name( 'AHL','AHL_UA_VST_RES_MODE_NULL' );
669: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
670: FND_MSG_PUB.add;
671: END IF;
672:
673: END IF;
674:

Line 677: l_msg_count := FND_MSG_PUB.COUNT_MSG;

673: END IF;
674:
675: END LOOP;
676:
677: l_msg_count := FND_MSG_PUB.COUNT_MSG;
678: IF (l_msg_count > 0)
679: THEN
680: RAISE FND_API.G_EXC_ERROR;
681: END IF;

Line 748: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

744: EXCEPTION
745: WHEN FND_API.G_EXC_ERROR THEN
746: x_return_status := FND_API.G_RET_STS_ERROR;
747: Rollback to Process_Flight_Schedules_pub;
748: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
749: p_data => x_msg_data,
750: p_encoded => fnd_api.g_false );
751:
752: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 755: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

751:
752: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
754: Rollback to Process_Flight_Schedules_pub;
755: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
756: p_data => x_msg_data,
757: p_encoded => fnd_api.g_false );
758:
759: WHEN OTHERS THEN

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

758:
759: WHEN OTHERS THEN
760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
761: Rollback to Process_Flight_Schedules_pub;
762: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
763: THEN
764: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
765: p_procedure_name => l_api_name,
766: p_error_text => SUBSTR(SQLERRM,1,240) );

Line 764: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
761: Rollback to Process_Flight_Schedules_pub;
762: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
763: THEN
764: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
765: p_procedure_name => l_api_name,
766: p_error_text => SUBSTR(SQLERRM,1,240) );
767: END IF;
768: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 768: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

764: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
765: p_procedure_name => l_api_name,
766: p_error_text => SUBSTR(SQLERRM,1,240) );
767: END IF;
768: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
769: p_data => x_msg_data,
770: p_encoded => fnd_api.g_false );
771:
772: END Process_Flight_Schedules;

Line 1365: FND_MSG_PUB.add;

1361: END IF;
1362: FND_MESSAGE.set_name( 'AHL','AHL_COM_INVALID_DML' );
1363: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1364: FND_MESSAGE.set_token( 'FIELD', p_flight_visit_sch_tbl(i).DML_OPERATION);
1365: FND_MSG_PUB.add;
1366: x_return_status := FND_API.G_RET_STS_ERROR;
1367: END IF;
1368:
1369:

Line 1388: FND_MSG_PUB.add;

1384: );
1385: END IF;
1386: FND_MESSAGE.set_name( 'AHL','AHL_UA_US_NOT_FOUND' );
1387: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1388: FND_MSG_PUB.add;
1389: x_return_status := FND_API.G_RET_STS_ERROR;
1390: END IF;
1391:
1392: -- Check for Object Version number.

Line 1407: FND_MSG_PUB.add;

1403: );
1404: END IF;
1405: FND_MESSAGE.set_name( 'AHL','AHL_UA_OBJ_VERNO_NULL' );
1406: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1407: FND_MSG_PUB.add;
1408: x_return_status := FND_API.G_RET_STS_ERROR;
1409: END IF;
1410: END IF;
1411:

Line 1435: FND_MSG_PUB.add;

1431: );
1432: END IF;
1433: FND_MESSAGE.set_name( 'AHL','AHL_UA_INV_UC_NAME' );
1434: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1435: FND_MSG_PUB.add;
1436: x_return_status := FND_API.G_RET_STS_ERROR;
1437: END IF;
1438:
1439: --Flight Number is a mandatory input field and cannot be null.

Line 1454: FND_MSG_PUB.add;

1450: );
1451: END IF;
1452: FND_MESSAGE.set_name( 'AHL','AHL_UA_FLG_NUMBER_NULL' );
1453: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1454: FND_MSG_PUB.add;
1455: x_return_status := FND_API.G_RET_STS_ERROR;
1456: END IF;
1457:
1458: --Segment is a mandatory input field and cannot be null

Line 1473: FND_MSG_PUB.add;

1469: );
1470: END IF;
1471: FND_MESSAGE.set_name( 'AHL','AHL_UA_SEGMENT_NULL' );
1472: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1473: FND_MSG_PUB.add;
1474: x_return_status := FND_API.G_RET_STS_ERROR;
1475: END IF;
1476:
1477: --Departure_Dept_Id is a mandatory input field and cannot be null

Line 1494: FND_MSG_PUB.add;

1490: );
1491: END IF;
1492: FND_MESSAGE.set_name( 'AHL','AHL_UA_DEP_DEPT_NULL' );
1493: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1494: FND_MSG_PUB.add;
1495: x_return_status := FND_API.G_RET_STS_ERROR;
1496: END IF;
1497:
1498: --Departure_Org_Id is a mandatory input field and cannot be null

Line 1515: FND_MSG_PUB.add;

1511: );
1512: END IF;
1513: FND_MESSAGE.set_name( 'AHL','AHL_UA_DEP_ORG_NULL' );
1514: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1515: FND_MSG_PUB.add;
1516: x_return_status := FND_API.G_RET_STS_ERROR;
1517: END IF;
1518:
1519: --Arrival_Dept_Id is a mandatory input field and cannot be null

Line 1537: FND_MSG_PUB.add;

1533: );
1534: END IF;
1535: FND_MESSAGE.set_name( 'AHL','AHL_UA_ARR_DEPT_NULL' );
1536: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1537: FND_MSG_PUB.add;
1538: x_return_status := FND_API.G_RET_STS_ERROR;
1539: END IF;
1540:
1541: --Arrival_Org_Id is a mandatory input field and cannot be null

Line 1558: FND_MSG_PUB.add;

1554: );
1555: END IF;
1556: FND_MESSAGE.set_name( 'AHL','AHL_UA_ARR_ORG_NULL' );
1557: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1558: FND_MSG_PUB.add;
1559: x_return_status := FND_API.G_RET_STS_ERROR;
1560: END IF;
1561:
1562: --Est_Departure_Time is a mandatory input field and cannot be null

Line 1577: FND_MSG_PUB.add;

1573: );
1574: END IF;
1575: FND_MESSAGE.set_name( 'AHL','AHL_UA_EST_DEP_TIME_NULL' );
1576: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1577: FND_MSG_PUB.add;
1578: x_return_status := FND_API.G_RET_STS_ERROR;
1579: END IF;
1580:
1581: --Est_Arrival_Time is a mandatory input field and cannot be null

Line 1596: FND_MSG_PUB.add;

1592: );
1593: END IF;
1594: FND_MESSAGE.set_name( 'AHL','AHL_UA_EST_ARR_TIME_NULL' );
1595: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1596: FND_MSG_PUB.add;
1597: x_return_status := FND_API.G_RET_STS_ERROR;
1598: END IF;
1599:
1600: --Visit_Reschedule_Mode is a mandatory input field and cannot be null

Line 1617: FND_MSG_PUB.add;

1613: );
1614: END IF;
1615: FND_MESSAGE.set_name( 'AHL','AHL_UA_VST_RES_MODE_NULL' );
1616: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1617: FND_MSG_PUB.add;
1618: x_return_status := FND_API.G_RET_STS_ERROR;
1619: END IF;
1620:
1621: ----------------- Validate visit paramters here, only when DML_OPERATION is C -------------------

Line 1642: FND_MSG_PUB.add;

1638: );
1639: END IF;
1640: FND_MESSAGE.set_name( 'AHL','AHL_UA_VST_TYPE_NULL' );
1641: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1642: FND_MSG_PUB.add;
1643: x_return_status := FND_API.G_RET_STS_ERROR;
1644: END IF;
1645:
1646: -- Check for visit create type.

Line 1663: FND_MSG_PUB.add;

1659: );
1660: END IF;
1661: FND_MESSAGE.set_name( 'AHL','AHL_UA_VST_CRE_TYPE_NULL' );
1662: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1663: FND_MSG_PUB.add;
1664: x_return_status := FND_API.G_RET_STS_ERROR;
1665: END IF;
1666: END IF;
1667:

Line 1722: FND_MSG_PUB.initialize;

1718: END IF;
1719:
1720: -- Initialize message list if p_init_msg_list is set to TRUE.
1721: IF FND_API.to_boolean(p_init_msg_list) THEN
1722: FND_MSG_PUB.initialize;
1723: END IF;
1724:
1725:
1726: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 1802: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1798: EXCEPTION
1799: WHEN FND_API.G_EXC_ERROR THEN
1800: x_return_status := FND_API.G_RET_STS_ERROR;
1801: Rollback to p_x_flght_visit_schedules_pub;
1802: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1803: p_data => x_msg_data,
1804: p_encoded => fnd_api.g_false );
1805:
1806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1809: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1805:
1806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1808: Rollback to p_x_flght_visit_schedules_pub;
1809: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1810: p_data => x_msg_data,
1811: p_encoded => fnd_api.g_false );
1812:
1813: WHEN OTHERS THEN

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

1812:
1813: WHEN OTHERS THEN
1814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1815: Rollback to p_x_flght_visit_schedules_pub;
1816: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1817: THEN
1818: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
1819: p_procedure_name => l_api_name,
1820: p_error_text => SUBSTR(SQLERRM,1,240) );

Line 1818: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

1814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1815: Rollback to p_x_flght_visit_schedules_pub;
1816: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1817: THEN
1818: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
1819: p_procedure_name => l_api_name,
1820: p_error_text => SUBSTR(SQLERRM,1,240) );
1821: END IF;
1822: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 1822: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1818: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
1819: p_procedure_name => l_api_name,
1820: p_error_text => SUBSTR(SQLERRM,1,240) );
1821: END IF;
1822: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1823: p_data => x_msg_data,
1824: p_encoded => fnd_api.g_false );
1825:
1826: END Process_FlightVisit_Sch;