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 441: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

437: EXCEPTION
438: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
439: --ROLLBACK TO search_flight_schedules_pub;
440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
441: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
442: p_count => x_msg_count,
443: p_data => x_msg_data);
444:
445: WHEN OTHERS THEN

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

444:
445: WHEN OTHERS THEN
446: --ROLLBACK TO search_flight_schedules_pub;
447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
448: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
449: THEN
450: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
451: p_procedure_name => l_api_name,
452: p_error_text => SUBSTR(SQLERRM,1,240));

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

446: --ROLLBACK TO search_flight_schedules_pub;
447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
448: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
449: THEN
450: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
451: p_procedure_name => l_api_name,
452: p_error_text => SUBSTR(SQLERRM,1,240));
453:
454: END IF;

Line 508: FND_MSG_PUB.initialize;

504: END IF;
505:
506: -- Initialize message list if p_init_msg_list is set to TRUE.
507: IF FND_API.to_boolean(p_init_msg_list) THEN
508: FND_MSG_PUB.initialize;
509: END IF;
510:
511:
512: FOR i IN p_x_flight_schedules_tbl.FIRST..p_x_flight_schedules_tbl.LAST

Line 522: FND_MSG_PUB.add;

518: THEN
519: FND_MESSAGE.set_name( 'AHL','AHL_COM_INVALID_DML' );
520: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
521: FND_MESSAGE.set_token( 'FIELD', p_x_flight_schedules_tbl(i).DML_OPERATION);
522: FND_MSG_PUB.add;
523: END IF;
524:
525:
526: --Obj version number and Unit Schedule id check in case of update or delete.

Line 536: FND_MSG_PUB.add;

532: p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID = FND_API.G_MISS_NUM)
533: THEN
534: FND_MESSAGE.set_name( 'AHL','AHL_UA_US_NOT_FOUND' );
535: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
536: FND_MSG_PUB.add;
537: END IF;
538:
539: -- Check for Object Version number.
540: IF (p_x_flight_schedules_tbl(i).OBJECT_VERSION_NUMBER IS NULL OR

Line 545: FND_MSG_PUB.add;

541: p_x_flight_schedules_tbl(i).OBJECT_VERSION_NUMBER = FND_API.G_MISS_NUM)
542: THEN
543: FND_MESSAGE.set_name( 'AHL','AHL_UA_OBJ_VERNO_NULL' );
544: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
545: FND_MSG_PUB.add;
546: END IF;
547: END IF;
548:
549: IF p_x_flight_schedules_tbl(i).DML_OPERATION = 'C' OR

Line 563: FND_MSG_PUB.add;

559:
560: THEN
561: FND_MESSAGE.set_name( 'AHL','AHL_UA_INV_UC_NAME' );
562: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
563: FND_MSG_PUB.add;
564: END IF;
565:
566: --Flight Number is a mandatory input field and cannot be null.
567: IF p_x_flight_schedules_tbl(i).FLIGHT_NUMBER IS NULL OR

Line 572: FND_MSG_PUB.add;

568: p_x_flight_schedules_tbl(i).FLIGHT_NUMBER = FND_API.G_MISS_CHAR
569: THEN
570: FND_MESSAGE.set_name( 'AHL','AHL_UA_FLG_NUMBER_NULL' );
571: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
572: FND_MSG_PUB.add;
573: END IF;
574:
575: --Segment is a mandatory input field and cannot be null
576: IF p_x_flight_schedules_tbl(i).SEGMENT IS NULL OR

Line 581: FND_MSG_PUB.add;

577: p_x_flight_schedules_tbl(i).SEGMENT = FND_API.G_MISS_CHAR
578: THEN
579: FND_MESSAGE.set_name( 'AHL','AHL_UA_SEGMENT_NULL' );
580: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
581: FND_MSG_PUB.add;
582: END IF;
583:
584: --Departure_Dept_Id is a mandatory input field and cannot be null
585: IF ( p_x_flight_schedules_tbl(i).DEPARTURE_DEPT_ID IS NULL OR

Line 592: FND_MSG_PUB.add;

588: p_x_flight_schedules_tbl(i).DEPARTURE_DEPT_CODE = FND_API.G_MISS_CHAR )
589: THEN
590: FND_MESSAGE.set_name( 'AHL','AHL_UA_DEP_DEPT_NULL' );
591: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
592: FND_MSG_PUB.add;
593: END IF;
594:
595: --Departure_Org_Id is a mandatory input field and cannot be null
596: IF ( p_x_flight_schedules_tbl(i).DEPARTURE_ORG_ID IS NULL OR

Line 603: FND_MSG_PUB.add;

599: p_x_flight_schedules_tbl(i).DEPARTURE_ORG_CODE = FND_API.G_MISS_CHAR )
600: THEN
601: FND_MESSAGE.set_name( 'AHL','AHL_UA_DEP_ORG_NULL' );
602: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
603: FND_MSG_PUB.add;
604: END IF;
605:
606: --Arrival_Dept_Id is a mandatory input field and cannot be null
607: IF ( p_x_flight_schedules_tbl(i).ARRIVAL_DEPT_ID IS NULL OR

Line 615: FND_MSG_PUB.add;

611:
612: THEN
613: FND_MESSAGE.set_name( 'AHL','AHL_UA_ARR_DEPT_NULL' );
614: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
615: FND_MSG_PUB.add;
616: END IF;
617:
618: --Arrival_Org_Id is a mandatory input field and cannot be null
619: IF ( p_x_flight_schedules_tbl(i).ARRIVAL_ORG_ID IS NULL OR

Line 626: FND_MSG_PUB.add;

622: p_x_flight_schedules_tbl(i).ARRIVAL_ORG_CODE = FND_API.G_MISS_CHAR )
623: THEN
624: FND_MESSAGE.set_name( 'AHL','AHL_UA_ARR_ORG_NULL' );
625: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
626: FND_MSG_PUB.add;
627: END IF;
628:
629: --Est_Departure_Time is a mandatory input field and cannot be null
630: IF p_x_flight_schedules_tbl(i).EST_DEPARTURE_TIME IS NULL OR

Line 635: FND_MSG_PUB.add;

631: p_x_flight_schedules_tbl(i).EST_DEPARTURE_TIME = FND_API.G_MISS_DATE
632: THEN
633: FND_MESSAGE.set_name( 'AHL','AHL_UA_EST_DEP_TIME_NULL' );
634: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
635: FND_MSG_PUB.add;
636: END IF;
637:
638: --Est_Arrival_Time is a mandatory input field and cannot be null
639: IF p_x_flight_schedules_tbl(i).EST_ARRIVAL_TIME IS NULL OR

Line 644: FND_MSG_PUB.add;

640: p_x_flight_schedules_tbl(i).EST_ARRIVAL_TIME = FND_API.G_MISS_DATE
641: THEN
642: FND_MESSAGE.set_name( 'AHL','AHL_UA_EST_ARR_TIME_NULL' );
643: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
644: FND_MSG_PUB.add;
645: END IF;
646:
647: --Visit_Reschedule_Mode is a mandatory input field and cannot be null
648: IF ( p_x_flight_schedules_tbl(i).VISIT_RESCHEDULE_MODE IS NULL OR

Line 655: FND_MSG_PUB.add;

651: p_x_flight_schedules_tbl(i).VISIT_RESCHEDULE_MEANING = FND_API.G_MISS_CHAR )
652: THEN
653: FND_MESSAGE.set_name( 'AHL','AHL_UA_VST_RES_MODE_NULL' );
654: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
655: FND_MSG_PUB.add;
656: END IF;
657:
658: END IF;
659:

Line 662: l_msg_count := FND_MSG_PUB.COUNT_MSG;

658: END IF;
659:
660: END LOOP;
661:
662: l_msg_count := FND_MSG_PUB.COUNT_MSG;
663: IF (l_msg_count > 0)
664: THEN
665: RAISE FND_API.G_EXC_ERROR;
666: END IF;

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

729: EXCEPTION
730: WHEN FND_API.G_EXC_ERROR THEN
731: x_return_status := FND_API.G_RET_STS_ERROR;
732: Rollback to Process_Flight_Schedules_pub;
733: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
734: p_data => x_msg_data,
735: p_encoded => fnd_api.g_false );
736:
737: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

736:
737: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
739: Rollback to Process_Flight_Schedules_pub;
740: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
741: p_data => x_msg_data,
742: p_encoded => fnd_api.g_false );
743:
744: WHEN OTHERS THEN

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

743:
744: WHEN OTHERS THEN
745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
746: Rollback to Process_Flight_Schedules_pub;
747: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
748: THEN
749: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
750: p_procedure_name => l_api_name,
751: p_error_text => SUBSTR(SQLERRM,1,240) );

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

745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
746: Rollback to Process_Flight_Schedules_pub;
747: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
748: THEN
749: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
750: p_procedure_name => l_api_name,
751: p_error_text => SUBSTR(SQLERRM,1,240) );
752: END IF;
753: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

749: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
750: p_procedure_name => l_api_name,
751: p_error_text => SUBSTR(SQLERRM,1,240) );
752: END IF;
753: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
754: p_data => x_msg_data,
755: p_encoded => fnd_api.g_false );
756:
757: END Process_Flight_Schedules;

Line 1334: FND_MSG_PUB.add;

1330: END IF;
1331: FND_MESSAGE.set_name( 'AHL','AHL_COM_INVALID_DML' );
1332: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1333: FND_MESSAGE.set_token( 'FIELD', p_flight_visit_sch_tbl(i).DML_OPERATION);
1334: FND_MSG_PUB.add;
1335: x_return_status := FND_API.G_RET_STS_ERROR;
1336: END IF;
1337:
1338:

Line 1357: FND_MSG_PUB.add;

1353: );
1354: END IF;
1355: FND_MESSAGE.set_name( 'AHL','AHL_UA_US_NOT_FOUND' );
1356: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1357: FND_MSG_PUB.add;
1358: x_return_status := FND_API.G_RET_STS_ERROR;
1359: END IF;
1360:
1361: -- Check for Object Version number.

Line 1376: FND_MSG_PUB.add;

1372: );
1373: END IF;
1374: FND_MESSAGE.set_name( 'AHL','AHL_UA_OBJ_VERNO_NULL' );
1375: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1376: FND_MSG_PUB.add;
1377: x_return_status := FND_API.G_RET_STS_ERROR;
1378: END IF;
1379: END IF;
1380:

Line 1404: FND_MSG_PUB.add;

1400: );
1401: END IF;
1402: FND_MESSAGE.set_name( 'AHL','AHL_UA_INV_UC_NAME' );
1403: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1404: FND_MSG_PUB.add;
1405: x_return_status := FND_API.G_RET_STS_ERROR;
1406: END IF;
1407:
1408: --Flight Number is a mandatory input field and cannot be null.

Line 1423: FND_MSG_PUB.add;

1419: );
1420: END IF;
1421: FND_MESSAGE.set_name( 'AHL','AHL_UA_FLG_NUMBER_NULL' );
1422: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1423: FND_MSG_PUB.add;
1424: x_return_status := FND_API.G_RET_STS_ERROR;
1425: END IF;
1426:
1427: --Segment is a mandatory input field and cannot be null

Line 1442: FND_MSG_PUB.add;

1438: );
1439: END IF;
1440: FND_MESSAGE.set_name( 'AHL','AHL_UA_SEGMENT_NULL' );
1441: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1442: FND_MSG_PUB.add;
1443: x_return_status := FND_API.G_RET_STS_ERROR;
1444: END IF;
1445:
1446: --Departure_Dept_Id is a mandatory input field and cannot be null

Line 1463: FND_MSG_PUB.add;

1459: );
1460: END IF;
1461: FND_MESSAGE.set_name( 'AHL','AHL_UA_DEP_DEPT_NULL' );
1462: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1463: FND_MSG_PUB.add;
1464: x_return_status := FND_API.G_RET_STS_ERROR;
1465: END IF;
1466:
1467: --Departure_Org_Id is a mandatory input field and cannot be null

Line 1484: FND_MSG_PUB.add;

1480: );
1481: END IF;
1482: FND_MESSAGE.set_name( 'AHL','AHL_UA_DEP_ORG_NULL' );
1483: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1484: FND_MSG_PUB.add;
1485: x_return_status := FND_API.G_RET_STS_ERROR;
1486: END IF;
1487:
1488: --Arrival_Dept_Id is a mandatory input field and cannot be null

Line 1506: FND_MSG_PUB.add;

1502: );
1503: END IF;
1504: FND_MESSAGE.set_name( 'AHL','AHL_UA_ARR_DEPT_NULL' );
1505: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1506: FND_MSG_PUB.add;
1507: x_return_status := FND_API.G_RET_STS_ERROR;
1508: END IF;
1509:
1510: --Arrival_Org_Id is a mandatory input field and cannot be null

Line 1527: FND_MSG_PUB.add;

1523: );
1524: END IF;
1525: FND_MESSAGE.set_name( 'AHL','AHL_UA_ARR_ORG_NULL' );
1526: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1527: FND_MSG_PUB.add;
1528: x_return_status := FND_API.G_RET_STS_ERROR;
1529: END IF;
1530:
1531: --Est_Departure_Time is a mandatory input field and cannot be null

Line 1546: FND_MSG_PUB.add;

1542: );
1543: END IF;
1544: FND_MESSAGE.set_name( 'AHL','AHL_UA_EST_DEP_TIME_NULL' );
1545: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1546: FND_MSG_PUB.add;
1547: x_return_status := FND_API.G_RET_STS_ERROR;
1548: END IF;
1549:
1550: --Est_Arrival_Time is a mandatory input field and cannot be null

Line 1565: FND_MSG_PUB.add;

1561: );
1562: END IF;
1563: FND_MESSAGE.set_name( 'AHL','AHL_UA_EST_ARR_TIME_NULL' );
1564: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1565: FND_MSG_PUB.add;
1566: x_return_status := FND_API.G_RET_STS_ERROR;
1567: END IF;
1568:
1569: --Visit_Reschedule_Mode is a mandatory input field and cannot be null

Line 1586: FND_MSG_PUB.add;

1582: );
1583: END IF;
1584: FND_MESSAGE.set_name( 'AHL','AHL_UA_VST_RES_MODE_NULL' );
1585: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1586: FND_MSG_PUB.add;
1587: x_return_status := FND_API.G_RET_STS_ERROR;
1588: END IF;
1589:
1590: ----------------- Validate visit paramters here, only when DML_OPERATION is C -------------------

Line 1611: FND_MSG_PUB.add;

1607: );
1608: END IF;
1609: FND_MESSAGE.set_name( 'AHL','AHL_UA_VST_TYPE_NULL' );
1610: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1611: FND_MSG_PUB.add;
1612: x_return_status := FND_API.G_RET_STS_ERROR;
1613: END IF;
1614:
1615: -- Check for visit create type.

Line 1632: FND_MSG_PUB.add;

1628: );
1629: END IF;
1630: FND_MESSAGE.set_name( 'AHL','AHL_UA_VST_CRE_TYPE_NULL' );
1631: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1632: FND_MSG_PUB.add;
1633: x_return_status := FND_API.G_RET_STS_ERROR;
1634: END IF;
1635: END IF;
1636:

Line 1691: FND_MSG_PUB.initialize;

1687: END IF;
1688:
1689: -- Initialize message list if p_init_msg_list is set to TRUE.
1690: IF FND_API.to_boolean(p_init_msg_list) THEN
1691: FND_MSG_PUB.initialize;
1692: END IF;
1693:
1694:
1695: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

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

1767: EXCEPTION
1768: WHEN FND_API.G_EXC_ERROR THEN
1769: x_return_status := FND_API.G_RET_STS_ERROR;
1770: Rollback to p_x_flght_visit_schedules_pub;
1771: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1772: p_data => x_msg_data,
1773: p_encoded => fnd_api.g_false );
1774:
1775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1774:
1775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1777: Rollback to p_x_flght_visit_schedules_pub;
1778: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1779: p_data => x_msg_data,
1780: p_encoded => fnd_api.g_false );
1781:
1782: WHEN OTHERS THEN

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

1781:
1782: WHEN OTHERS THEN
1783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1784: Rollback to p_x_flght_visit_schedules_pub;
1785: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1786: THEN
1787: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
1788: p_procedure_name => l_api_name,
1789: p_error_text => SUBSTR(SQLERRM,1,240) );

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

1783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1784: Rollback to p_x_flght_visit_schedules_pub;
1785: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1786: THEN
1787: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
1788: p_procedure_name => l_api_name,
1789: p_error_text => SUBSTR(SQLERRM,1,240) );
1790: END IF;
1791: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

1787: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
1788: p_procedure_name => l_api_name,
1789: p_error_text => SUBSTR(SQLERRM,1,240) );
1790: END IF;
1791: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1792: p_data => x_msg_data,
1793: p_encoded => fnd_api.g_false );
1794:
1795: END Process_FlightVisit_Sch;