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_API

Line 7: G_USE_ACTUALS CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) :='AHL_UA_FLIGHT_SCHEDULES_PUB';
5:
6: -- Flag for determining wether to use Actual dates or Estimated dates.
7: G_USE_ACTUALS CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
8:
9: PROCEDURE Get_Flight_Schedule_Details
10: (
11: -- standard IN params

Line 13: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,

9: PROCEDURE Get_Flight_Schedule_Details
10: (
11: -- standard IN params
12: p_api_version IN NUMBER,
13: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
14: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
15: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
16: p_default IN VARCHAR2 :=FND_API.G_FALSE,
17: p_module_type IN VARCHAR2 :=NULL,

Line 14: p_commit IN VARCHAR2 :=FND_API.G_FALSE,

10: (
11: -- standard IN params
12: p_api_version IN NUMBER,
13: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
14: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
15: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
16: p_default IN VARCHAR2 :=FND_API.G_FALSE,
17: p_module_type IN VARCHAR2 :=NULL,
18: -- standard OUT params

Line 15: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

11: -- standard IN params
12: p_api_version IN NUMBER,
13: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
14: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
15: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
16: p_default IN VARCHAR2 :=FND_API.G_FALSE,
17: p_module_type IN VARCHAR2 :=NULL,
18: -- standard OUT params
19: x_return_status OUT NOCOPY VARCHAR2,

Line 16: p_default IN VARCHAR2 :=FND_API.G_FALSE,

12: p_api_version IN NUMBER,
13: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
14: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
15: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
16: p_default IN VARCHAR2 :=FND_API.G_FALSE,
17: p_module_type IN VARCHAR2 :=NULL,
18: -- standard OUT params
19: x_return_status OUT NOCOPY VARCHAR2,
20: x_msg_count OUT NOCOPY NUMBER,

Line 54: x_return_status:=FND_API.G_RET_STS_SUCCESS;

50: --savepoint is not required for procedures which does only query
51: --SAVEPOINT search_flight_schedules_pub;
52:
53: -- Initialize return status to success initially
54: x_return_status:=FND_API.G_RET_STS_SUCCESS;
55:
56: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
57: p_api_version,
58: l_api_name,G_PKG_NAME)

Line 56: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

52:
53: -- Initialize return status to success initially
54: x_return_status:=FND_API.G_RET_STS_SUCCESS;
55:
56: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
57: p_api_version,
58: l_api_name,G_PKG_NAME)
59: THEN
60: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 60: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

56: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
57: p_api_version,
58: l_api_name,G_PKG_NAME)
59: THEN
60: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 64: IF FND_API.to_boolean(p_init_msg_list) THEN

60: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 74: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
77: -- Search query...
78: l_search_Query := 'SELECT

Line 182: IF g_use_actuals = FND_API.G_TRUE

178: IF p_flight_search_rec.START_DATE IS NOT NULL AND p_flight_search_rec.END_DATE IS NOT NULL
179: THEN
180: IF p_flight_search_rec.DATE_APPLY_TO_FLAG IS NULL
181: THEN
182: IF g_use_actuals = FND_API.G_TRUE
183: THEN
184: l_search_Query := l_search_Query ||' AND ( ';
185: l_search_Query := l_search_Query ||' ( ';
186: l_search_Query := l_search_Query ||' to_date(:start_time, ''DD-MON-RRRR HH24:MI:SS'') <= nvl(actual_departure_time, est_departure_time) and ';

Line 247: IF g_use_actuals = FND_API.G_TRUE

243: END IF;
244:
245: ELSIF p_flight_search_rec.DATE_APPLY_TO_FLAG = G_APPLY_TO_ARRIVAL
246: THEN
247: IF g_use_actuals = FND_API.G_TRUE
248: THEN
249: l_search_Query := l_search_Query ||' AND ';
250: l_search_Query := l_search_Query ||' ( ';
251: l_search_Query := l_search_Query ||' to_date(:start_time, ''DD-MON-RRRR HH24:MI:SS'') < nvl(actual_arrival_time, est_arrival_time) and ';

Line 272: IF g_use_actuals = FND_API.G_TRUE

268: END IF;
269:
270: ELSIF p_flight_search_rec.DATE_APPLY_TO_FLAG = G_APPLY_TO_DEPARTURE
271: THEN
272: IF g_use_actuals = FND_API.G_TRUE
273: THEN
274: l_search_Query := l_search_Query ||' AND ';
275: l_search_Query := l_search_Query ||' ( ';
276: l_search_Query := l_search_Query ||' to_date(:start_time, ''DD-MON-RRRR HH24:MI:SS'') <= nvl(actual_departure_time, est_departure_time) and ';

Line 298: IF g_use_actuals = FND_API.G_TRUE

294: END IF;
295:
296: ELSIF p_flight_search_rec.START_DATE IS NOT NULL
297: THEN
298: IF g_use_actuals = FND_API.G_TRUE
299: THEN
300: l_search_Query := l_search_Query || ' AND NVL(ACTUAL_ARRIVAL_TIME,EST_ARRIVAL_TIME) >= to_date(:'||l_bind_index||', ''DD-MON-RRRR HH24:MI:SS'')';
301: ELSE
302: l_search_Query := l_search_Query || ' AND EST_ARRIVAL_TIME >= to_date(:'||l_bind_index||', ''DD-MON-RRRR HH24:MI:SS'')';

Line 309: IF g_use_actuals = FND_API.G_TRUE

305: l_bind_index := l_bind_index + 1;
306:
307: ELSIF p_flight_search_rec.END_DATE IS NOT NULL
308: THEN
309: IF g_use_actuals = FND_API.G_TRUE
310: THEN
311: l_search_Query := l_search_Query || ' AND NVL(ACTUAL_DEPARTURE_TIME,EST_DEPARTURE_TIME) <= to_date(:'||l_bind_index||', ''DD-MON-RRRR HH24:MI:SS'')';
312: ELSE
313: l_search_Query := l_search_Query || ' AND EST_DEPARTURE_TIME <= to_date(:'||l_bind_index||', ''DD-MON-RRRR HH24:MI:SS'')';

Line 438: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

434: );
435: END IF;
436:
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,

Line 440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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 447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

443: p_data => x_msg_data);
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,

Line 467: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,

463: PROCEDURE Process_Flight_Schedules
464: (
465: -- standard IN params
466: p_api_version IN NUMBER,
467: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
468: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
469: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
470: p_default IN VARCHAR2 :=FND_API.G_FALSE,
471: p_module_type IN VARCHAR2 :=NULL,

Line 468: p_commit IN VARCHAR2 :=FND_API.G_FALSE,

464: (
465: -- standard IN params
466: p_api_version IN NUMBER,
467: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
468: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
469: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
470: p_default IN VARCHAR2 :=FND_API.G_FALSE,
471: p_module_type IN VARCHAR2 :=NULL,
472: -- standard OUT params

Line 469: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

465: -- standard IN params
466: p_api_version IN NUMBER,
467: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
468: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
469: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
470: p_default IN VARCHAR2 :=FND_API.G_FALSE,
471: p_module_type IN VARCHAR2 :=NULL,
472: -- standard OUT params
473: x_return_status OUT NOCOPY VARCHAR2,

Line 470: p_default IN VARCHAR2 :=FND_API.G_FALSE,

466: p_api_version IN NUMBER,
467: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
468: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
469: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
470: p_default IN VARCHAR2 :=FND_API.G_FALSE,
471: p_module_type IN VARCHAR2 :=NULL,
472: -- standard OUT params
473: x_return_status OUT NOCOPY VARCHAR2,
474: x_msg_count OUT NOCOPY NUMBER,

Line 497: x_return_status:=FND_API.G_RET_STS_SUCCESS;

493: --define a savepoint for the procedure
494: SAVEPOINT Process_Flight_Schedules_pub;
495:
496: -- Initialize return status to success initially
497: x_return_status:=FND_API.G_RET_STS_SUCCESS;
498:
499: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
500: p_api_version,
501: l_api_name,G_PKG_NAME)

Line 499: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

495:
496: -- Initialize return status to success initially
497: x_return_status:=FND_API.G_RET_STS_SUCCESS;
498:
499: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
500: p_api_version,
501: l_api_name,G_PKG_NAME)
502: THEN
503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

499: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
500: p_api_version,
501: l_api_name,G_PKG_NAME)
502: THEN
503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 507: IF FND_API.to_boolean(p_init_msg_list) THEN

503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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:

Line 532: p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID = FND_API.G_MISS_NUM)

528: p_x_flight_schedules_tbl(i).DML_OPERATION = 'U' OR p_x_flight_schedules_tbl(i).DML_OPERATION = 'u' )
529: THEN
530: --Unit Schedule id cannot be null
531: IF (p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID IS NULL OR
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;

Line 541: p_x_flight_schedules_tbl(i).OBJECT_VERSION_NUMBER = FND_API.G_MISS_NUM)

537: END IF;
538:
539: -- Check for Object Version number.
540: IF (p_x_flight_schedules_tbl(i).OBJECT_VERSION_NUMBER IS NULL OR
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;

Line 556: p_x_flight_schedules_tbl(i).UNIT_CONFIG_HEADER_ID = FND_API.G_MISS_NUM )AND

552: p_x_flight_schedules_tbl(i).DML_OPERATION = 'u'
553: THEN
554: -- Unit Config Header id is a mandatory input field and cannot be null.
555: IF (p_x_flight_schedules_tbl(i).UNIT_CONFIG_HEADER_ID IS NULL OR
556: p_x_flight_schedules_tbl(i).UNIT_CONFIG_HEADER_ID = FND_API.G_MISS_NUM )AND
557: (p_x_flight_schedules_tbl(i).UNIT_CONFIG_NAME IS NULL OR
558: p_x_flight_schedules_tbl(i).UNIT_CONFIG_NAME = FND_API.G_MISS_CHAR)
559:
560: THEN

Line 558: p_x_flight_schedules_tbl(i).UNIT_CONFIG_NAME = FND_API.G_MISS_CHAR)

554: -- Unit Config Header id is a mandatory input field and cannot be null.
555: IF (p_x_flight_schedules_tbl(i).UNIT_CONFIG_HEADER_ID IS NULL OR
556: p_x_flight_schedules_tbl(i).UNIT_CONFIG_HEADER_ID = FND_API.G_MISS_NUM )AND
557: (p_x_flight_schedules_tbl(i).UNIT_CONFIG_NAME IS NULL OR
558: p_x_flight_schedules_tbl(i).UNIT_CONFIG_NAME = FND_API.G_MISS_CHAR)
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);

Line 568: p_x_flight_schedules_tbl(i).FLIGHT_NUMBER = FND_API.G_MISS_CHAR

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

Line 577: p_x_flight_schedules_tbl(i).SEGMENT = FND_API.G_MISS_CHAR

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

Line 586: p_x_flight_schedules_tbl(i).DEPARTURE_DEPT_ID = FND_API.G_MISS_NUM ) AND

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
586: p_x_flight_schedules_tbl(i).DEPARTURE_DEPT_ID = FND_API.G_MISS_NUM ) AND
587: ( p_x_flight_schedules_tbl(i).DEPARTURE_DEPT_CODE IS NULL OR
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' );

Line 588: p_x_flight_schedules_tbl(i).DEPARTURE_DEPT_CODE = FND_API.G_MISS_CHAR )

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
586: p_x_flight_schedules_tbl(i).DEPARTURE_DEPT_ID = FND_API.G_MISS_NUM ) AND
587: ( p_x_flight_schedules_tbl(i).DEPARTURE_DEPT_CODE IS NULL OR
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;

Line 597: p_x_flight_schedules_tbl(i).DEPARTURE_ORG_ID = FND_API.G_MISS_NUM ) AND

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
597: p_x_flight_schedules_tbl(i).DEPARTURE_ORG_ID = FND_API.G_MISS_NUM ) AND
598: ( p_x_flight_schedules_tbl(i).DEPARTURE_ORG_CODE IS NULL OR
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' );

Line 599: p_x_flight_schedules_tbl(i).DEPARTURE_ORG_CODE = FND_API.G_MISS_CHAR )

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
597: p_x_flight_schedules_tbl(i).DEPARTURE_ORG_ID = FND_API.G_MISS_NUM ) AND
598: ( p_x_flight_schedules_tbl(i).DEPARTURE_ORG_CODE IS NULL OR
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;

Line 608: p_x_flight_schedules_tbl(i).ARRIVAL_DEPT_ID = FND_API.G_MISS_NUM ) AND

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
608: p_x_flight_schedules_tbl(i).ARRIVAL_DEPT_ID = FND_API.G_MISS_NUM ) AND
609: ( p_x_flight_schedules_tbl(i).ARRIVAL_DEPT_CODE IS NULL OR
610: p_x_flight_schedules_tbl(i).ARRIVAL_DEPT_CODE = FND_API.G_MISS_CHAR )
611:
612: THEN

Line 610: p_x_flight_schedules_tbl(i).ARRIVAL_DEPT_CODE = FND_API.G_MISS_CHAR )

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
608: p_x_flight_schedules_tbl(i).ARRIVAL_DEPT_ID = FND_API.G_MISS_NUM ) AND
609: ( p_x_flight_schedules_tbl(i).ARRIVAL_DEPT_CODE IS NULL OR
610: p_x_flight_schedules_tbl(i).ARRIVAL_DEPT_CODE = FND_API.G_MISS_CHAR )
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);

Line 620: p_x_flight_schedules_tbl(i).ARRIVAL_ORG_ID = FND_API.G_MISS_NUM ) AND

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
620: p_x_flight_schedules_tbl(i).ARRIVAL_ORG_ID = FND_API.G_MISS_NUM ) AND
621: ( p_x_flight_schedules_tbl(i).ARRIVAL_ORG_CODE IS NULL OR
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' );

Line 622: p_x_flight_schedules_tbl(i).ARRIVAL_ORG_CODE = FND_API.G_MISS_CHAR )

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
620: p_x_flight_schedules_tbl(i).ARRIVAL_ORG_ID = FND_API.G_MISS_NUM ) AND
621: ( p_x_flight_schedules_tbl(i).ARRIVAL_ORG_CODE IS NULL OR
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;

Line 631: p_x_flight_schedules_tbl(i).EST_DEPARTURE_TIME = FND_API.G_MISS_DATE

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

Line 640: p_x_flight_schedules_tbl(i).EST_ARRIVAL_TIME = FND_API.G_MISS_DATE

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

Line 649: p_x_flight_schedules_tbl(i).VISIT_RESCHEDULE_MODE = FND_API.G_MISS_CHAR ) AND

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
649: p_x_flight_schedules_tbl(i).VISIT_RESCHEDULE_MODE = FND_API.G_MISS_CHAR ) AND
650: ( p_x_flight_schedules_tbl(i).VISIT_RESCHEDULE_MEANING IS NULL OR
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' );

Line 651: p_x_flight_schedules_tbl(i).VISIT_RESCHEDULE_MEANING = FND_API.G_MISS_CHAR )

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
649: p_x_flight_schedules_tbl(i).VISIT_RESCHEDULE_MODE = FND_API.G_MISS_CHAR ) AND
650: ( p_x_flight_schedules_tbl(i).VISIT_RESCHEDULE_MEANING IS NULL OR
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;

Line 665: RAISE FND_API.G_EXC_ERROR;

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;
667:
668:
669: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 692: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

688: p_x_flight_schedules_tbl => p_x_flight_schedules_tbl
689: );
690:
691: -- Check Error Message stack.
692: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
693: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
694: fnd_log.string
695: (
696: fnd_log.level_error,

Line 701: RAISE FND_API.G_EXC_ERROR;

697: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
698: 'Private API raised expected error....'
699: );
700: END IF;
701: RAISE FND_API.G_EXC_ERROR;
702: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
703: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
704: fnd_log.string
705: (

Line 702: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

698: 'Private API raised expected error....'
699: );
700: END IF;
701: RAISE FND_API.G_EXC_ERROR;
702: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
703: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
704: fnd_log.string
705: (
706: fnd_log.level_error,

Line 711: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

707: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
708: 'Private API raised unexpected error....'
709: );
710: END IF;
711: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
712: END IF;
713:
714: -- Standard check for p_commit
715: IF FND_API.To_Boolean (p_commit)

Line 715: IF FND_API.To_Boolean (p_commit)

711: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
712: END IF;
713:
714: -- Standard check for p_commit
715: IF FND_API.To_Boolean (p_commit)
716: THEN
717: COMMIT;
718: END IF;
719:

Line 730: WHEN FND_API.G_EXC_ERROR THEN

726: );
727: END IF;
728:
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,

Line 731: x_return_status := FND_API.G_RET_STS_ERROR;

727: END IF;
728:
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 );

Line 735: p_encoded => fnd_api.g_false );

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
738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
739: Rollback to Process_Flight_Schedules_pub;

Line 737: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
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,

Line 738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

734: p_data => x_msg_data,
735: p_encoded => fnd_api.g_false );
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 );

Line 742: p_encoded => fnd_api.g_false );

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
745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
746: Rollback to Process_Flight_Schedules_pub;

Line 745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

741: p_data => x_msg_data,
742: p_encoded => fnd_api.g_false );
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,

Line 755: p_encoded => fnd_api.g_false );

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;
758:
759: -----------------------------------------------------------------------------------------------------

Line 877: p_init_msg_list => FND_API.G_FALSE,

873: END IF;
874:
875: AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules(
876: p_api_version => 1.0,
877: p_init_msg_list => FND_API.G_FALSE,
878: p_commit => FND_API.G_FALSE,
879: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
880: p_default => FND_API.G_FALSE,
881: p_module_type => null,

Line 878: p_commit => FND_API.G_FALSE,

874:
875: AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules(
876: p_api_version => 1.0,
877: p_init_msg_list => FND_API.G_FALSE,
878: p_commit => FND_API.G_FALSE,
879: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
880: p_default => FND_API.G_FALSE,
881: p_module_type => null,
882: x_return_status => x_return_status,

Line 879: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

875: AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules(
876: p_api_version => 1.0,
877: p_init_msg_list => FND_API.G_FALSE,
878: p_commit => FND_API.G_FALSE,
879: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
880: p_default => FND_API.G_FALSE,
881: p_module_type => null,
882: x_return_status => x_return_status,
883: x_msg_count => x_msg_count,

Line 880: p_default => FND_API.G_FALSE,

876: p_api_version => 1.0,
877: p_init_msg_list => FND_API.G_FALSE,
878: p_commit => FND_API.G_FALSE,
879: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
880: p_default => FND_API.G_FALSE,
881: p_module_type => null,
882: x_return_status => x_return_status,
883: x_msg_count => x_msg_count,
884: x_msg_data => x_msg_data,

Line 898: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

894: );
895: END IF;
896:
897: -- Check Error Message stack.
898: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
899: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
900: fnd_log.string
901: (
902: fnd_log.level_error,

Line 907: RAISE FND_API.G_EXC_ERROR;

903: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
904: 'AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules API raised expected error....'
905: );
906: END IF;
907: RAISE FND_API.G_EXC_ERROR;
908: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
909: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
910: fnd_log.string
911: (

Line 908: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

904: 'AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules API raised expected error....'
905: );
906: END IF;
907: RAISE FND_API.G_EXC_ERROR;
908: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
909: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
910: fnd_log.string
911: (
912: fnd_log.level_error,

Line 917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

913: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
914: 'AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules API raised unexpected error....'
915: );
916: END IF;
917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
918: END IF;
919:
920:
921: --Populate the ids back to flight_visit_rec

Line 1058: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

1054: x_is_conflict => l_is_conflict
1055: );
1056:
1057: -- Check Error Message stack.
1058: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1059: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1060: fnd_log.string
1061: (
1062: fnd_log.level_error,

Line 1067: RAISE FND_API.G_EXC_ERROR;

1063: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1064: 'AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules API raised expected error....'
1065: );
1066: END IF;
1067: RAISE FND_API.G_EXC_ERROR;
1068: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1069: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1070: fnd_log.string
1071: (

Line 1068: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1064: 'AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules API raised expected error....'
1065: );
1066: END IF;
1067: RAISE FND_API.G_EXC_ERROR;
1068: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1069: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1070: fnd_log.string
1071: (
1072: fnd_log.level_error,

Line 1077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1073: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1074: 'AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules API raised unexpected error....'
1075: );
1076: END IF;
1077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1078: END IF;
1079:
1080: -- Determine if the succeding event is Flight and its details.
1081: AHL_UA_COMMON_PVT.Get_Succ_Flight_Info

Line 1089: p_use_actuals => FND_API.G_FALSE,

1085: x_msg_count => x_msg_count,
1086: x_msg_data => x_msg_data,
1087: p_unit_config_id => p_x_flight_visit_schedules_tbl(i).UNIT_CONFIG_HEADER_ID,
1088: p_end_date_time => p_x_flight_visit_schedules_tbl(i).EST_ARRIVAL_TIME,
1089: p_use_actuals => FND_API.G_FALSE,
1090: x_succ_flight_schedule => l_x_succ_flight_schedule,
1091: x_is_conflict => l_is_conflict
1092: );
1093:

Line 1095: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

1091: x_is_conflict => l_is_conflict
1092: );
1093:
1094: -- Check Error Message stack.
1095: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1096: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1097: fnd_log.string
1098: (
1099: fnd_log.level_error,

Line 1104: RAISE FND_API.G_EXC_ERROR;

1100: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1101: 'AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules API raised expected error....'
1102: );
1103: END IF;
1104: RAISE FND_API.G_EXC_ERROR;
1105: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1106: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1107: fnd_log.string
1108: (

Line 1105: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1101: 'AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules API raised expected error....'
1102: );
1103: END IF;
1104: RAISE FND_API.G_EXC_ERROR;
1105: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1106: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1107: fnd_log.string
1108: (
1109: fnd_log.level_error,

Line 1114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1110: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1111: 'AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules API raised unexpected error....'
1112: );
1113: END IF;
1114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1115: END IF;
1116:
1117: IF l_x_visit_rec.visit_id IS NOT NULL THEN
1118: l_x_visit_tbl(j).PLAN_END_DATE := l_x_visit_rec.START_DATE;

Line 1226: p_init_msg_list => FND_API.G_FALSE,

1222: END IF;
1223:
1224: AHL_VWP_VISITS_PVT.Process_Visit (
1225: p_api_version => 1.0,
1226: p_init_msg_list => FND_API.G_FALSE,
1227: p_commit => FND_API.G_FALSE,
1228: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1229: p_module_type => NULL,
1230: p_x_Visit_tbl => l_x_visit_tbl,

Line 1227: p_commit => FND_API.G_FALSE,

1223:
1224: AHL_VWP_VISITS_PVT.Process_Visit (
1225: p_api_version => 1.0,
1226: p_init_msg_list => FND_API.G_FALSE,
1227: p_commit => FND_API.G_FALSE,
1228: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1229: p_module_type => NULL,
1230: p_x_Visit_tbl => l_x_visit_tbl,
1231: x_return_status => x_return_status,

Line 1228: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1224: AHL_VWP_VISITS_PVT.Process_Visit (
1225: p_api_version => 1.0,
1226: p_init_msg_list => FND_API.G_FALSE,
1227: p_commit => FND_API.G_FALSE,
1228: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1229: p_module_type => NULL,
1230: p_x_Visit_tbl => l_x_visit_tbl,
1231: x_return_status => x_return_status,
1232: x_msg_count => x_msg_count,

Line 1246: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

1242: );
1243: END IF;
1244:
1245: -- Check Error Message stack.
1246: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1247: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1248: fnd_log.string
1249: (
1250: fnd_log.level_error,

Line 1255: RAISE FND_API.G_EXC_ERROR;

1251: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1252: 'AHL_VWP_VISITS_PVT.Process_Visit API raised expected error....'
1253: );
1254: END IF;
1255: RAISE FND_API.G_EXC_ERROR;
1256: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1257: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1258: fnd_log.string
1259: (

Line 1256: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1252: 'AHL_VWP_VISITS_PVT.Process_Visit API raised expected error....'
1253: );
1254: END IF;
1255: RAISE FND_API.G_EXC_ERROR;
1256: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1257: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1258: fnd_log.string
1259: (
1260: fnd_log.level_error,

Line 1265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1261: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1262: 'AHL_VWP_VISITS_PVT.Process_Visit API raised unexpected error....'
1263: );
1264: END IF;
1265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1266: END IF;
1267:
1268: -- Re-assign visit id.
1269: j := l_x_visit_tbl.FIRST;

Line 1306: x_return_status:= FND_API.G_RET_STS_SUCCESS;

1302: l_api_name CONSTANT VARCHAR2(30) := 'validate_api_inputs';
1303:
1304: BEGIN
1305: -- Initialize return status to success initially
1306: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1307:
1308: FOR i IN p_flight_visit_sch_tbl.FIRST..p_flight_visit_sch_tbl.LAST
1309: LOOP
1310:

Line 1335: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1339: --Obj version number and Unit Schedule id check in case of update or delete.

Line 1345: p_flight_visit_sch_tbl(i).UNIT_SCHEDULE_ID = FND_API.G_MISS_NUM)

1341: p_flight_visit_sch_tbl(i).DML_OPERATION = 'U' OR p_flight_visit_sch_tbl(i).DML_OPERATION = 'u' )
1342: THEN
1343: --Unit Schedule id cannot be null
1344: IF (p_flight_visit_sch_tbl(i).UNIT_SCHEDULE_ID IS NULL OR
1345: p_flight_visit_sch_tbl(i).UNIT_SCHEDULE_ID = FND_API.G_MISS_NUM)
1346: THEN
1347: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1348: fnd_log.string
1349: (

Line 1358: x_return_status := FND_API.G_RET_STS_ERROR;

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.
1362: IF (p_flight_visit_sch_tbl(i).OBJECT_VERSION_NUMBER IS NULL OR

Line 1363: p_flight_visit_sch_tbl(i).OBJECT_VERSION_NUMBER = FND_API.G_MISS_NUM)

1359: END IF;
1360:
1361: -- Check for Object Version number.
1362: IF (p_flight_visit_sch_tbl(i).OBJECT_VERSION_NUMBER IS NULL OR
1363: p_flight_visit_sch_tbl(i).OBJECT_VERSION_NUMBER = FND_API.G_MISS_NUM)
1364: THEN
1365: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1366: fnd_log.string
1367: (

Line 1377: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1381: IF p_flight_visit_sch_tbl(i).DML_OPERATION = 'C' OR

Line 1388: p_flight_visit_sch_tbl(i).UNIT_CONFIG_HEADER_ID = FND_API.G_MISS_NUM )AND

1384: p_flight_visit_sch_tbl(i).DML_OPERATION = 'u'
1385: THEN
1386: -- Unit Config Header id is a mandatory input field and cannot be null.
1387: IF (p_flight_visit_sch_tbl(i).UNIT_CONFIG_HEADER_ID IS NULL OR
1388: p_flight_visit_sch_tbl(i).UNIT_CONFIG_HEADER_ID = FND_API.G_MISS_NUM )AND
1389: (p_flight_visit_sch_tbl(i).UNIT_CONFIG_NAME IS NULL OR
1390: p_flight_visit_sch_tbl(i).UNIT_CONFIG_NAME = FND_API.G_MISS_CHAR)
1391:
1392: THEN

Line 1390: p_flight_visit_sch_tbl(i).UNIT_CONFIG_NAME = FND_API.G_MISS_CHAR)

1386: -- Unit Config Header id is a mandatory input field and cannot be null.
1387: IF (p_flight_visit_sch_tbl(i).UNIT_CONFIG_HEADER_ID IS NULL OR
1388: p_flight_visit_sch_tbl(i).UNIT_CONFIG_HEADER_ID = FND_API.G_MISS_NUM )AND
1389: (p_flight_visit_sch_tbl(i).UNIT_CONFIG_NAME IS NULL OR
1390: p_flight_visit_sch_tbl(i).UNIT_CONFIG_NAME = FND_API.G_MISS_CHAR)
1391:
1392: THEN
1393: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1394: fnd_log.string

Line 1405: x_return_status := FND_API.G_RET_STS_ERROR;

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.
1409: IF p_flight_visit_sch_tbl(i).FLIGHT_NUMBER IS NULL OR

Line 1410: p_flight_visit_sch_tbl(i).FLIGHT_NUMBER = FND_API.G_MISS_CHAR

1406: END IF;
1407:
1408: --Flight Number is a mandatory input field and cannot be null.
1409: IF p_flight_visit_sch_tbl(i).FLIGHT_NUMBER IS NULL OR
1410: p_flight_visit_sch_tbl(i).FLIGHT_NUMBER = FND_API.G_MISS_CHAR
1411: THEN
1412: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1413: fnd_log.string
1414: (

Line 1424: x_return_status := FND_API.G_RET_STS_ERROR;

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
1428: IF p_flight_visit_sch_tbl(i).SEGMENT IS NULL OR

Line 1429: p_flight_visit_sch_tbl(i).SEGMENT = FND_API.G_MISS_CHAR

1425: END IF;
1426:
1427: --Segment is a mandatory input field and cannot be null
1428: IF p_flight_visit_sch_tbl(i).SEGMENT IS NULL OR
1429: p_flight_visit_sch_tbl(i).SEGMENT = FND_API.G_MISS_CHAR
1430: THEN
1431: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1432: fnd_log.string
1433: (

Line 1443: x_return_status := FND_API.G_RET_STS_ERROR;

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
1447: IF ( p_flight_visit_sch_tbl(i).DEPARTURE_DEPT_ID IS NULL OR

Line 1448: p_flight_visit_sch_tbl(i).DEPARTURE_DEPT_ID = FND_API.G_MISS_NUM ) AND

1444: END IF;
1445:
1446: --Departure_Dept_Id is a mandatory input field and cannot be null
1447: IF ( p_flight_visit_sch_tbl(i).DEPARTURE_DEPT_ID IS NULL OR
1448: p_flight_visit_sch_tbl(i).DEPARTURE_DEPT_ID = FND_API.G_MISS_NUM ) AND
1449: ( p_flight_visit_sch_tbl(i).DEPARTURE_DEPT_CODE IS NULL OR
1450: p_flight_visit_sch_tbl(i).DEPARTURE_DEPT_CODE = FND_API.G_MISS_CHAR )
1451: THEN
1452: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

Line 1450: p_flight_visit_sch_tbl(i).DEPARTURE_DEPT_CODE = FND_API.G_MISS_CHAR )

1446: --Departure_Dept_Id is a mandatory input field and cannot be null
1447: IF ( p_flight_visit_sch_tbl(i).DEPARTURE_DEPT_ID IS NULL OR
1448: p_flight_visit_sch_tbl(i).DEPARTURE_DEPT_ID = FND_API.G_MISS_NUM ) AND
1449: ( p_flight_visit_sch_tbl(i).DEPARTURE_DEPT_CODE IS NULL OR
1450: p_flight_visit_sch_tbl(i).DEPARTURE_DEPT_CODE = FND_API.G_MISS_CHAR )
1451: THEN
1452: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1453: fnd_log.string
1454: (

Line 1464: x_return_status := FND_API.G_RET_STS_ERROR;

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
1468: IF ( p_flight_visit_sch_tbl(i).DEPARTURE_ORG_ID IS NULL OR

Line 1469: p_flight_visit_sch_tbl(i).DEPARTURE_ORG_ID = FND_API.G_MISS_NUM ) AND

1465: END IF;
1466:
1467: --Departure_Org_Id is a mandatory input field and cannot be null
1468: IF ( p_flight_visit_sch_tbl(i).DEPARTURE_ORG_ID IS NULL OR
1469: p_flight_visit_sch_tbl(i).DEPARTURE_ORG_ID = FND_API.G_MISS_NUM ) AND
1470: ( p_flight_visit_sch_tbl(i).DEPARTURE_ORG_CODE IS NULL OR
1471: p_flight_visit_sch_tbl(i).DEPARTURE_ORG_CODE = FND_API.G_MISS_CHAR )
1472: THEN
1473: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

Line 1471: p_flight_visit_sch_tbl(i).DEPARTURE_ORG_CODE = FND_API.G_MISS_CHAR )

1467: --Departure_Org_Id is a mandatory input field and cannot be null
1468: IF ( p_flight_visit_sch_tbl(i).DEPARTURE_ORG_ID IS NULL OR
1469: p_flight_visit_sch_tbl(i).DEPARTURE_ORG_ID = FND_API.G_MISS_NUM ) AND
1470: ( p_flight_visit_sch_tbl(i).DEPARTURE_ORG_CODE IS NULL OR
1471: p_flight_visit_sch_tbl(i).DEPARTURE_ORG_CODE = FND_API.G_MISS_CHAR )
1472: THEN
1473: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1474: fnd_log.string
1475: (

Line 1485: x_return_status := FND_API.G_RET_STS_ERROR;

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
1489: IF ( p_flight_visit_sch_tbl(i).ARRIVAL_DEPT_ID IS NULL OR

Line 1490: p_flight_visit_sch_tbl(i).ARRIVAL_DEPT_ID = FND_API.G_MISS_NUM ) AND

1486: END IF;
1487:
1488: --Arrival_Dept_Id is a mandatory input field and cannot be null
1489: IF ( p_flight_visit_sch_tbl(i).ARRIVAL_DEPT_ID IS NULL OR
1490: p_flight_visit_sch_tbl(i).ARRIVAL_DEPT_ID = FND_API.G_MISS_NUM ) AND
1491: ( p_flight_visit_sch_tbl(i).ARRIVAL_DEPT_CODE IS NULL OR
1492: p_flight_visit_sch_tbl(i).ARRIVAL_DEPT_CODE = FND_API.G_MISS_CHAR )
1493:
1494: THEN

Line 1492: p_flight_visit_sch_tbl(i).ARRIVAL_DEPT_CODE = FND_API.G_MISS_CHAR )

1488: --Arrival_Dept_Id is a mandatory input field and cannot be null
1489: IF ( p_flight_visit_sch_tbl(i).ARRIVAL_DEPT_ID IS NULL OR
1490: p_flight_visit_sch_tbl(i).ARRIVAL_DEPT_ID = FND_API.G_MISS_NUM ) AND
1491: ( p_flight_visit_sch_tbl(i).ARRIVAL_DEPT_CODE IS NULL OR
1492: p_flight_visit_sch_tbl(i).ARRIVAL_DEPT_CODE = FND_API.G_MISS_CHAR )
1493:
1494: THEN
1495: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1496: fnd_log.string

Line 1507: x_return_status := FND_API.G_RET_STS_ERROR;

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
1511: IF ( p_flight_visit_sch_tbl(i).ARRIVAL_ORG_ID IS NULL OR

Line 1512: p_flight_visit_sch_tbl(i).ARRIVAL_ORG_ID = FND_API.G_MISS_NUM ) AND

1508: END IF;
1509:
1510: --Arrival_Org_Id is a mandatory input field and cannot be null
1511: IF ( p_flight_visit_sch_tbl(i).ARRIVAL_ORG_ID IS NULL OR
1512: p_flight_visit_sch_tbl(i).ARRIVAL_ORG_ID = FND_API.G_MISS_NUM ) AND
1513: ( p_flight_visit_sch_tbl(i).ARRIVAL_ORG_CODE IS NULL OR
1514: p_flight_visit_sch_tbl(i).ARRIVAL_ORG_CODE = FND_API.G_MISS_CHAR )
1515: THEN
1516: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

Line 1514: p_flight_visit_sch_tbl(i).ARRIVAL_ORG_CODE = FND_API.G_MISS_CHAR )

1510: --Arrival_Org_Id is a mandatory input field and cannot be null
1511: IF ( p_flight_visit_sch_tbl(i).ARRIVAL_ORG_ID IS NULL OR
1512: p_flight_visit_sch_tbl(i).ARRIVAL_ORG_ID = FND_API.G_MISS_NUM ) AND
1513: ( p_flight_visit_sch_tbl(i).ARRIVAL_ORG_CODE IS NULL OR
1514: p_flight_visit_sch_tbl(i).ARRIVAL_ORG_CODE = FND_API.G_MISS_CHAR )
1515: THEN
1516: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1517: fnd_log.string
1518: (

Line 1528: x_return_status := FND_API.G_RET_STS_ERROR;

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
1532: IF p_flight_visit_sch_tbl(i).EST_DEPARTURE_TIME IS NULL OR

Line 1533: p_flight_visit_sch_tbl(i).EST_DEPARTURE_TIME = FND_API.G_MISS_DATE

1529: END IF;
1530:
1531: --Est_Departure_Time is a mandatory input field and cannot be null
1532: IF p_flight_visit_sch_tbl(i).EST_DEPARTURE_TIME IS NULL OR
1533: p_flight_visit_sch_tbl(i).EST_DEPARTURE_TIME = FND_API.G_MISS_DATE
1534: THEN
1535: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1536: fnd_log.string
1537: (

Line 1547: x_return_status := FND_API.G_RET_STS_ERROR;

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
1551: IF p_flight_visit_sch_tbl(i).EST_ARRIVAL_TIME IS NULL OR

Line 1552: p_flight_visit_sch_tbl(i).EST_ARRIVAL_TIME = FND_API.G_MISS_DATE

1548: END IF;
1549:
1550: --Est_Arrival_Time is a mandatory input field and cannot be null
1551: IF p_flight_visit_sch_tbl(i).EST_ARRIVAL_TIME IS NULL OR
1552: p_flight_visit_sch_tbl(i).EST_ARRIVAL_TIME = FND_API.G_MISS_DATE
1553: THEN
1554: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1555: fnd_log.string
1556: (

Line 1566: x_return_status := FND_API.G_RET_STS_ERROR;

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
1570: IF ( p_flight_visit_sch_tbl(i).VISIT_RESCHEDULE_MODE IS NULL OR

Line 1571: p_flight_visit_sch_tbl(i).VISIT_RESCHEDULE_MODE = FND_API.G_MISS_CHAR ) AND

1567: END IF;
1568:
1569: --Visit_Reschedule_Mode is a mandatory input field and cannot be null
1570: IF ( p_flight_visit_sch_tbl(i).VISIT_RESCHEDULE_MODE IS NULL OR
1571: p_flight_visit_sch_tbl(i).VISIT_RESCHEDULE_MODE = FND_API.G_MISS_CHAR ) AND
1572: ( p_flight_visit_sch_tbl(i).VISIT_RESCHEDULE_MEANING IS NULL OR
1573: p_flight_visit_sch_tbl(i).VISIT_RESCHEDULE_MEANING = FND_API.G_MISS_CHAR )
1574: THEN
1575: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

Line 1573: p_flight_visit_sch_tbl(i).VISIT_RESCHEDULE_MEANING = FND_API.G_MISS_CHAR )

1569: --Visit_Reschedule_Mode is a mandatory input field and cannot be null
1570: IF ( p_flight_visit_sch_tbl(i).VISIT_RESCHEDULE_MODE IS NULL OR
1571: p_flight_visit_sch_tbl(i).VISIT_RESCHEDULE_MODE = FND_API.G_MISS_CHAR ) AND
1572: ( p_flight_visit_sch_tbl(i).VISIT_RESCHEDULE_MEANING IS NULL OR
1573: p_flight_visit_sch_tbl(i).VISIT_RESCHEDULE_MEANING = FND_API.G_MISS_CHAR )
1574: THEN
1575: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1576: fnd_log.string
1577: (

Line 1587: x_return_status := FND_API.G_RET_STS_ERROR;

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 -------------------
1591: IF p_flight_visit_sch_tbl(i).DML_OPERATION = 'C' OR

Line 1596: p_flight_visit_sch_tbl(i).VISIT_TYPE_CODE = FND_API.G_MISS_CHAR ) AND

1592: p_flight_visit_sch_tbl(i).DML_OPERATION = 'c'
1593: THEN
1594: -- Check for visit type.
1595: IF ( p_flight_visit_sch_tbl(i).VISIT_TYPE_CODE IS NULL OR
1596: p_flight_visit_sch_tbl(i).VISIT_TYPE_CODE = FND_API.G_MISS_CHAR ) AND
1597: ( p_flight_visit_sch_tbl(i).VISIT_TYPE_MEANING IS NULL OR
1598: p_flight_visit_sch_tbl(i).VISIT_TYPE_MEANING = FND_API.G_MISS_CHAR )
1599: THEN
1600: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

Line 1598: p_flight_visit_sch_tbl(i).VISIT_TYPE_MEANING = FND_API.G_MISS_CHAR )

1594: -- Check for visit type.
1595: IF ( p_flight_visit_sch_tbl(i).VISIT_TYPE_CODE IS NULL OR
1596: p_flight_visit_sch_tbl(i).VISIT_TYPE_CODE = FND_API.G_MISS_CHAR ) AND
1597: ( p_flight_visit_sch_tbl(i).VISIT_TYPE_MEANING IS NULL OR
1598: p_flight_visit_sch_tbl(i).VISIT_TYPE_MEANING = FND_API.G_MISS_CHAR )
1599: THEN
1600: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1601: fnd_log.string
1602: (

Line 1612: x_return_status := FND_API.G_RET_STS_ERROR;

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.
1616: IF ( p_flight_visit_sch_tbl(i).VISIT_CREATE_TYPE IS NULL OR

Line 1617: p_flight_visit_sch_tbl(i).VISIT_CREATE_TYPE = FND_API.G_MISS_CHAR ) AND

1613: END IF;
1614:
1615: -- Check for visit create type.
1616: IF ( p_flight_visit_sch_tbl(i).VISIT_CREATE_TYPE IS NULL OR
1617: p_flight_visit_sch_tbl(i).VISIT_CREATE_TYPE = FND_API.G_MISS_CHAR ) AND
1618: ( p_flight_visit_sch_tbl(i).VISIT_CREATE_MEANING IS NULL OR
1619: p_flight_visit_sch_tbl(i).VISIT_CREATE_MEANING = FND_API.G_MISS_CHAR )
1620: THEN
1621: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

Line 1619: p_flight_visit_sch_tbl(i).VISIT_CREATE_MEANING = FND_API.G_MISS_CHAR )

1615: -- Check for visit create type.
1616: IF ( p_flight_visit_sch_tbl(i).VISIT_CREATE_TYPE IS NULL OR
1617: p_flight_visit_sch_tbl(i).VISIT_CREATE_TYPE = FND_API.G_MISS_CHAR ) AND
1618: ( p_flight_visit_sch_tbl(i).VISIT_CREATE_MEANING IS NULL OR
1619: p_flight_visit_sch_tbl(i).VISIT_CREATE_MEANING = FND_API.G_MISS_CHAR )
1620: THEN
1621: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1622: fnd_log.string
1623: (

Line 1633: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1651: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,

1647: PROCEDURE Process_FlightVisit_Sch
1648: (
1649: -- standard IN params
1650: p_api_version IN NUMBER,
1651: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
1652: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
1653: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
1654: p_default IN VARCHAR2 :=FND_API.G_FALSE,
1655: p_module_type IN VARCHAR2 :=NULL,

Line 1652: p_commit IN VARCHAR2 :=FND_API.G_FALSE,

1648: (
1649: -- standard IN params
1650: p_api_version IN NUMBER,
1651: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
1652: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
1653: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
1654: p_default IN VARCHAR2 :=FND_API.G_FALSE,
1655: p_module_type IN VARCHAR2 :=NULL,
1656: -- standard OUT params

Line 1653: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

1649: -- standard IN params
1650: p_api_version IN NUMBER,
1651: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
1652: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
1653: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
1654: p_default IN VARCHAR2 :=FND_API.G_FALSE,
1655: p_module_type IN VARCHAR2 :=NULL,
1656: -- standard OUT params
1657: x_return_status OUT NOCOPY VARCHAR2,

Line 1654: p_default IN VARCHAR2 :=FND_API.G_FALSE,

1650: p_api_version IN NUMBER,
1651: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
1652: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
1653: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
1654: p_default IN VARCHAR2 :=FND_API.G_FALSE,
1655: p_module_type IN VARCHAR2 :=NULL,
1656: -- standard OUT params
1657: x_return_status OUT NOCOPY VARCHAR2,
1658: x_msg_count OUT NOCOPY NUMBER,

Line 1680: x_return_status:=FND_API.G_RET_STS_SUCCESS;

1676: --define a savepoint for the procedure
1677: SAVEPOINT p_x_flght_visit_schedules_pub;
1678:
1679: -- Initialize return status to success initially
1680: x_return_status:=FND_API.G_RET_STS_SUCCESS;
1681:
1682: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1683: p_api_version,
1684: l_api_name,G_PKG_NAME)

Line 1682: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

1678:
1679: -- Initialize return status to success initially
1680: x_return_status:=FND_API.G_RET_STS_SUCCESS;
1681:
1682: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1683: p_api_version,
1684: l_api_name,G_PKG_NAME)
1685: THEN
1686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1682: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1683: p_api_version,
1684: l_api_name,G_PKG_NAME)
1685: THEN
1686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 1690: IF FND_API.to_boolean(p_init_msg_list) THEN

1686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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:

Line 1711: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

1707: x_return_status => x_return_status
1708: );
1709:
1710: -- If any severe error occurs, then, abort API.
1711: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1712: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1713: fnd_log.string
1714: (
1715: fnd_log.level_error,

Line 1720: RAISE FND_API.G_EXC_ERROR;

1716: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1717: 'validate_api_inputs API raised expected error....'
1718: );
1719: END IF;
1720: RAISE FND_API.G_EXC_ERROR;
1721: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1722: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1723: fnd_log.string
1724: (

Line 1721: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1717: 'validate_api_inputs API raised expected error....'
1718: );
1719: END IF;
1720: RAISE FND_API.G_EXC_ERROR;
1721: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1722: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1723: fnd_log.string
1724: (
1725: fnd_log.level_error,

Line 1730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1726: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1727: 'validate_api_inputs API raised unexpected error....'
1728: );
1729: END IF;
1730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1731: END IF;
1732:
1733: --Procedure to populate Flight Schedule rec from flight_visit_rec
1734:

Line 1753: IF FND_API.To_Boolean (p_commit)

1749: x_msg_data => x_msg_data
1750: );
1751:
1752: -- Standard check for p_commit
1753: IF FND_API.To_Boolean (p_commit)
1754: THEN
1755: COMMIT;
1756: END IF;
1757:

Line 1768: WHEN FND_API.G_EXC_ERROR THEN

1764: );
1765: END IF;
1766:
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,

Line 1769: x_return_status := FND_API.G_RET_STS_ERROR;

1765: END IF;
1766:
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 );

Line 1773: p_encoded => fnd_api.g_false );

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
1776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1777: Rollback to p_x_flght_visit_schedules_pub;

Line 1775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
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,

Line 1776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1772: p_data => x_msg_data,
1773: p_encoded => fnd_api.g_false );
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 );

Line 1780: p_encoded => fnd_api.g_false );

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
1783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1784: Rollback to p_x_flght_visit_schedules_pub;

Line 1783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1779: p_data => x_msg_data,
1780: p_encoded => fnd_api.g_false );
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,

Line 1793: p_encoded => fnd_api.g_false );

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;
1796:
1797: END AHL_UA_FLIGHT_SCHEDULES_PUB;