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_AMP_WORKBENCH_PVT dependencies on FND_API

Line 37: p_not_for_sch IN VARCHAR2 := Fnd_Api.g_false,

33: PROCEDURE GET_GRAPH_REC_FOR_DATE(
34: p_graph_rec_date IN DATE,
35: p_graph_rec_num IN NUMBER,
36: p_visit_count IN NUMBER,
37: p_not_for_sch IN VARCHAR2 := Fnd_Api.g_false,
38: p_filter_criteria IN VARCHAR2 := 'ALL',
39: p_rec_type IN VARCHAR2 := G_SPACE_TYPE,
40: p_sch_visits_tbl IN SCH_VISITS_TBL,
41: p_x_sch_graph_rec IN OUT NOCOPY SCH_GRAPH_RESULTS_REC

Line 246: -- p_init_msg_list VARCHAR2 Default FND_API.G_FALSE

242: -- Parameters :
243: --
244: -- Standard IN Parameters :
245: -- p_api_version NUMBER Required
246: -- p_init_msg_list VARCHAR2 Default FND_API.G_FALSE
247: -- p_commit VARCHAR2 Default FND_API.G_FALSE
248: -- p_validation_level NUMBER Default FND_API.G_VALID_LEVEL_FULL
249: -- p_default VARCHAR2 Default FND_API.G_TRUE
250: -- p_module_type VARCHAR2 Default NULL

Line 247: -- p_commit VARCHAR2 Default FND_API.G_FALSE

243: --
244: -- Standard IN Parameters :
245: -- p_api_version NUMBER Required
246: -- p_init_msg_list VARCHAR2 Default FND_API.G_FALSE
247: -- p_commit VARCHAR2 Default FND_API.G_FALSE
248: -- p_validation_level NUMBER Default FND_API.G_VALID_LEVEL_FULL
249: -- p_default VARCHAR2 Default FND_API.G_TRUE
250: -- p_module_type VARCHAR2 Default NULL
251: --

Line 248: -- p_validation_level NUMBER Default FND_API.G_VALID_LEVEL_FULL

244: -- Standard IN Parameters :
245: -- p_api_version NUMBER Required
246: -- p_init_msg_list VARCHAR2 Default FND_API.G_FALSE
247: -- p_commit VARCHAR2 Default FND_API.G_FALSE
248: -- p_validation_level NUMBER Default FND_API.G_VALID_LEVEL_FULL
249: -- p_default VARCHAR2 Default FND_API.G_TRUE
250: -- p_module_type VARCHAR2 Default NULL
251: --
252: -- Standard OUT Parameters :

Line 249: -- p_default VARCHAR2 Default FND_API.G_TRUE

245: -- p_api_version NUMBER Required
246: -- p_init_msg_list VARCHAR2 Default FND_API.G_FALSE
247: -- p_commit VARCHAR2 Default FND_API.G_FALSE
248: -- p_validation_level NUMBER Default FND_API.G_VALID_LEVEL_FULL
249: -- p_default VARCHAR2 Default FND_API.G_TRUE
250: -- p_module_type VARCHAR2 Default NULL
251: --
252: -- Standard OUT Parameters :
253: -- x_return_status VARCHAR2 Required

Line 270: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

266: -- Sthilak CHANGED THE PROCEDURE LOGIC ER1#3799535
267: -- Sthilak bug #13958744 department_id is added in claculating working days
268: procedure GET_MC_GRAPH_DATA(
269: p_api_version IN NUMBER := 1.0,
270: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
271: p_commit IN VARCHAR2 := FND_API.G_FALSE,
272: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
273: p_default IN VARCHAR2 := FND_API.G_FALSE,
274: p_module_type IN VARCHAR2 := NULL,

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

267: -- Sthilak bug #13958744 department_id is added in claculating working days
268: procedure GET_MC_GRAPH_DATA(
269: p_api_version IN NUMBER := 1.0,
270: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
271: p_commit IN VARCHAR2 := FND_API.G_FALSE,
272: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
273: p_default IN VARCHAR2 := FND_API.G_FALSE,
274: p_module_type IN VARCHAR2 := NULL,
275: x_return_status OUT NOCOPY VARCHAR2,

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

268: procedure GET_MC_GRAPH_DATA(
269: p_api_version IN NUMBER := 1.0,
270: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
271: p_commit IN VARCHAR2 := FND_API.G_FALSE,
272: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
273: p_default IN VARCHAR2 := FND_API.G_FALSE,
274: p_module_type IN VARCHAR2 := NULL,
275: x_return_status OUT NOCOPY VARCHAR2,
276: x_msg_count OUT NOCOPY NUMBER,

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

269: p_api_version IN NUMBER := 1.0,
270: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
271: p_commit IN VARCHAR2 := FND_API.G_FALSE,
272: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
273: p_default IN VARCHAR2 := FND_API.G_FALSE,
274: p_module_type IN VARCHAR2 := NULL,
275: x_return_status OUT NOCOPY VARCHAR2,
276: x_msg_count OUT NOCOPY NUMBER,
277: x_msg_data OUT NOCOPY VARCHAR2,

Line 460: -- p_init_msg_list VARCHAR2 Default FND_API.G_FALSE

456: -- Parameters :
457: --
458: -- Standard IN Parameters :
459: -- p_api_version NUMBER Required
460: -- p_init_msg_list VARCHAR2 Default FND_API.G_FALSE
461: -- p_validation_level NUMBER Default FND_API.G_VALID_LEVEL_FULL
462: --
463: -- Standard OUT Parameters :
464: -- x_return_status VARCHAR2 Required

Line 461: -- p_validation_level NUMBER Default FND_API.G_VALID_LEVEL_FULL

457: --
458: -- Standard IN Parameters :
459: -- p_api_version NUMBER Required
460: -- p_init_msg_list VARCHAR2 Default FND_API.G_FALSE
461: -- p_validation_level NUMBER Default FND_API.G_VALID_LEVEL_FULL
462: --
463: -- Standard OUT Parameters :
464: -- x_return_status VARCHAR2 Required
465: -- x_msg_count NUMBER Required

Line 473: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

469: -- x_sch_graph_results_tbl SCH_GRAPH_RESULTS_TBL
470:
471: PROCEDURE GET_ORG_SCH_GRAPH(
472: p_api_version IN NUMBER := 1.0,
473: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
474: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
475: x_return_status OUT NOCOPY VARCHAR2,
476: x_msg_count OUT NOCOPY NUMBER,
477: x_msg_data OUT NOCOPY VARCHAR2,

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

470:
471: PROCEDURE GET_ORG_SCH_GRAPH(
472: p_api_version IN NUMBER := 1.0,
473: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
474: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
475: x_return_status OUT NOCOPY VARCHAR2,
476: x_msg_count OUT NOCOPY NUMBER,
477: x_msg_data OUT NOCOPY VARCHAR2,
478: p_org_sch_search_rec IN org_sch_search_rec,

Line 563: IF FND_API.to_boolean(p_init_msg_list)

559: ' Filter Criteria = ' || p_org_sch_search_rec.RESULT_FILTER);
560: END IF;
561:
562: -- Standard call to check for call compatibility.
563: IF FND_API.to_boolean(p_init_msg_list)
564: THEN
565: FND_MSG_PUB.initialize;
566: END IF;
567: -- Initialize API return status to success

Line 568: x_return_status := FND_API.G_RET_STS_SUCCESS;

564: THEN
565: FND_MSG_PUB.initialize;
566: END IF;
567: -- Initialize API return status to success
568: x_return_status := FND_API.G_RET_STS_SUCCESS;
569:
570: -- Initialize message list if p_init_msg_list is set to TRUE.
571: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
572: p_api_version,

Line 571: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

567: -- Initialize API return status to success
568: x_return_status := FND_API.G_RET_STS_SUCCESS;
569:
570: -- Initialize message list if p_init_msg_list is set to TRUE.
571: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
572: p_api_version,
573: l_api_name,G_PKG_NAME)
574: THEN
575: Fnd_Msg_Pub.ADD;

Line 576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

572: p_api_version,
573: l_api_name,G_PKG_NAME)
574: THEN
575: Fnd_Msg_Pub.ADD;
576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
577: END IF;
578: --
579:
580: IF(p_org_sch_search_rec.ORG_ID IS NULL) OR

Line 589: RAISE Fnd_Api.G_EXC_ERROR;

585: 'Passed Mandatory fields Org id or Display window is null');
586: END IF;
587: Fnd_Message.set_name(G_APP_NAME, 'AHL_AMP_ORG_MANDATORY');
588: FND_MSG_PUB.ADD;
589: RAISE Fnd_Api.G_EXC_ERROR;
590:
591: ELSIF(p_org_sch_search_rec.START_FROM_DATE IS NULL) AND
592: (p_org_sch_search_rec.START_BEFORE_DATE IS NULL) THEN
593:

Line 596: RAISE Fnd_Api.G_EXC_ERROR;

592: (p_org_sch_search_rec.START_BEFORE_DATE IS NULL) THEN
593:
594: Fnd_Message.set_name(G_APP_NAME, 'AHL_AMP_DATE_MANDATORY');
595: Fnd_Msg_Pub.ADD;
596: RAISE Fnd_Api.G_EXC_ERROR;
597: END IF;
598:
599: IF (p_org_sch_search_rec.RESULT_FILTER IS NOT NULL) THEN
600: l_filter_criteria := p_org_sch_search_rec.RESULT_FILTER;

Line 641: p_init_msg_list => FND_API.G_FALSE,

637: l_org_sch_search_rec.RESULT_FILTER := l_filter_criteria;
638:
639: GET_VISITS_FOR_DATE_ORG(
640: p_api_version => p_api_version,
641: p_init_msg_list => FND_API.G_FALSE,
642: p_validation_level => p_validation_level,
643: x_return_status => l_return_status,
644: x_msg_count => l_msg_count,
645: x_msg_data => l_msg_data,

Line 671: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN

667: END LOOP;
668: CLOSE c_space_dept_for_org;
669:
670: l_msg_count := Fnd_Msg_Pub.count_msg;
671: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN
672: IF (l_log_statement >= l_log_current_level) THEN
673: fnd_log.string(l_log_statement,
674: L_DEBUG_KEY,
675: 'Errors from GET_VISITS_FOR_DATE_ORG. Message count: ' ||

Line 679: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

675: 'Errors from GET_VISITS_FOR_DATE_ORG. Message count: ' ||
676: l_msg_count || ', Message data: ' || l_msg_data);
677: END IF;
678: x_msg_count := l_msg_count;
679: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
680: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
681: END IF;
682:
683: x_return_status := Fnd_Api.g_ret_sts_success;

Line 680: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

676: l_msg_count || ', Message data: ' || l_msg_data);
677: END IF;
678: x_msg_count := l_msg_count;
679: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
680: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
681: END IF;
682:
683: x_return_status := Fnd_Api.g_ret_sts_success;
684: IF (l_log_procedure >= l_log_current_level) THEN

Line 683: x_return_status := Fnd_Api.g_ret_sts_success;

679: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
680: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
681: END IF;
682:
683: x_return_status := Fnd_Api.g_ret_sts_success;
684: IF (l_log_procedure >= l_log_current_level) THEN
685: fnd_log.string(l_log_procedure,
686: L_DEBUG_KEY || '.end',
687: 'Return Status = ' || x_return_status);

Line 691: WHEN Fnd_Api.G_EXC_ERROR THEN

687: 'Return Status = ' || x_return_status);
688: END IF;
689:
690: EXCEPTION
691: WHEN Fnd_Api.G_EXC_ERROR THEN
692: x_return_status := Fnd_Api.G_RET_STS_ERROR;
693: ROLLBACK TO GET_ORG_SCH_GRAPH;
694: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
695: p_data => x_msg_data,

Line 692: x_return_status := Fnd_Api.G_RET_STS_ERROR;

688: END IF;
689:
690: EXCEPTION
691: WHEN Fnd_Api.G_EXC_ERROR THEN
692: x_return_status := Fnd_Api.G_RET_STS_ERROR;
693: ROLLBACK TO GET_ORG_SCH_GRAPH;
694: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
695: p_data => x_msg_data,
696: p_encoded => Fnd_Api.g_false);

Line 696: p_encoded => Fnd_Api.g_false);

692: x_return_status := Fnd_Api.G_RET_STS_ERROR;
693: ROLLBACK TO GET_ORG_SCH_GRAPH;
694: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
695: p_data => x_msg_data,
696: p_encoded => Fnd_Api.g_false);
697: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
698: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
699: ROLLBACK TO GET_ORG_SCH_GRAPH;
700: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,

Line 697: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

693: ROLLBACK TO GET_ORG_SCH_GRAPH;
694: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
695: p_data => x_msg_data,
696: p_encoded => Fnd_Api.g_false);
697: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
698: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
699: ROLLBACK TO GET_ORG_SCH_GRAPH;
700: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
701: p_data => x_msg_data,

Line 698: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

694: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
695: p_data => x_msg_data,
696: p_encoded => Fnd_Api.g_false);
697: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
698: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
699: ROLLBACK TO GET_ORG_SCH_GRAPH;
700: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
701: p_data => x_msg_data,
702: p_encoded => Fnd_Api.g_false);

Line 702: p_encoded => Fnd_Api.g_false);

698: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
699: ROLLBACK TO GET_ORG_SCH_GRAPH;
700: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
701: p_data => x_msg_data,
702: p_encoded => Fnd_Api.g_false);
703: WHEN OTHERS THEN
704: ROLLBACK TO GET_ORG_SCH_GRAPH;
705: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
706: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)

Line 705: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;

701: p_data => x_msg_data,
702: p_encoded => Fnd_Api.g_false);
703: WHEN OTHERS THEN
704: ROLLBACK TO GET_ORG_SCH_GRAPH;
705: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
706: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
707: THEN
708: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
709: END IF;

Line 711: p_encoded => Fnd_Api.g_false,

707: THEN
708: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
709: END IF;
710: Fnd_Msg_Pub.count_and_get (
711: p_encoded => Fnd_Api.g_false,
712: p_count => x_msg_count,
713: p_data => x_msg_data);
714:
715: END GET_ORG_SCH_GRAPH;

Line 723: -- p_init_msg_list VARCHAR2 Default FND_API.G_FALSE

719: -- Parameters :
720: --
721: -- Standard IN Parameters :
722: -- p_api_version NUMBER Required
723: -- p_init_msg_list VARCHAR2 Default FND_API.G_FALSE
724: -- p_validation_level NUMBER Default FND_API.G_VALID_LEVEL_FULL
725: --
726: -- Standard OUT Parameters :
727: -- x_return_status VARCHAR2 Required

Line 724: -- p_validation_level NUMBER Default FND_API.G_VALID_LEVEL_FULL

720: --
721: -- Standard IN Parameters :
722: -- p_api_version NUMBER Required
723: -- p_init_msg_list VARCHAR2 Default FND_API.G_FALSE
724: -- p_validation_level NUMBER Default FND_API.G_VALID_LEVEL_FULL
725: --
726: -- Standard OUT Parameters :
727: -- x_return_status VARCHAR2 Required
728: -- x_msg_count NUMBER Required

Line 737: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

733: -- x_sch_visits_tbl SCH_VISITS_TBL
734:
735: PROCEDURE GET_VISITS_FOR_DATE_ORG(
736: p_api_version IN NUMBER := 1.0,
737: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
738: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
739: x_return_status OUT NOCOPY VARCHAR2,
740: x_msg_count OUT NOCOPY NUMBER,
741: x_msg_data OUT NOCOPY VARCHAR2,

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

734:
735: PROCEDURE GET_VISITS_FOR_DATE_ORG(
736: p_api_version IN NUMBER := 1.0,
737: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
738: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
739: x_return_status OUT NOCOPY VARCHAR2,
740: x_msg_count OUT NOCOPY NUMBER,
741: x_msg_data OUT NOCOPY VARCHAR2,
742: p_org_sch_search_rec IN org_sch_search_rec,

Line 830: IF FND_API.to_boolean(p_init_msg_list)

826: ' Filter Criteria = ' || p_org_sch_search_rec.RESULT_FILTER);
827: END IF;
828:
829: -- Standard call to check for call compatibility.
830: IF FND_API.to_boolean(p_init_msg_list)
831: THEN
832: FND_MSG_PUB.initialize;
833: END IF;
834: -- Initialize API return status to success

Line 835: x_return_status := FND_API.G_RET_STS_SUCCESS;

831: THEN
832: FND_MSG_PUB.initialize;
833: END IF;
834: -- Initialize API return status to success
835: x_return_status := FND_API.G_RET_STS_SUCCESS;
836:
837: -- Initialize message list if p_init_msg_list is set to TRUE.
838: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
839: p_api_version,

Line 838: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

834: -- Initialize API return status to success
835: x_return_status := FND_API.G_RET_STS_SUCCESS;
836:
837: -- Initialize message list if p_init_msg_list is set to TRUE.
838: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
839: p_api_version,
840: l_api_name,G_PKG_NAME)
841: THEN
842: Fnd_Msg_Pub.ADD;

Line 843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

839: p_api_version,
840: l_api_name,G_PKG_NAME)
841: THEN
842: Fnd_Msg_Pub.ADD;
843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
844: END IF;
845: --
846:
847: IF(p_org_sch_search_rec.ORG_ID IS NULL) OR

Line 858: RAISE Fnd_Api.G_EXC_ERROR;

854: 'One of the Passed Mandatory fields is null');
855: END IF;
856: Fnd_Message.set_name(G_APP_NAME, 'AHL_AMP_ORG_MANDATORY');
857: FND_MSG_PUB.ADD;
858: RAISE Fnd_Api.G_EXC_ERROR;
859: END IF;
860:
861: l_loop_window := p_org_sch_search_rec.DISPLAY_WINDOW;
862: l_loop_start_date := p_org_sch_search_rec.START_FROM_DATE;

Line 930: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN

926: x_sch_graph_rec := l_sch_graph_rec;
927:
928:
929: l_msg_count := Fnd_Msg_Pub.count_msg;
930: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN
931: IF (l_log_statement >= l_log_current_level) THEN
932: fnd_log.string(l_log_statement,
933: L_DEBUG_KEY,
934: 'Errors from GET_VISITS_FOR_DATE_ORG. Message count: ' ||

Line 938: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

934: 'Errors from GET_VISITS_FOR_DATE_ORG. Message count: ' ||
935: l_msg_count || ', Message data: ' || l_msg_data);
936: END IF;
937: x_msg_count := l_msg_count;
938: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
939: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
940: END IF;
941:
942: x_return_status := Fnd_Api.g_ret_sts_success;

Line 939: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

935: l_msg_count || ', Message data: ' || l_msg_data);
936: END IF;
937: x_msg_count := l_msg_count;
938: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
939: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
940: END IF;
941:
942: x_return_status := Fnd_Api.g_ret_sts_success;
943: IF (l_log_procedure >= l_log_current_level) THEN

Line 942: x_return_status := Fnd_Api.g_ret_sts_success;

938: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
939: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
940: END IF;
941:
942: x_return_status := Fnd_Api.g_ret_sts_success;
943: IF (l_log_procedure >= l_log_current_level) THEN
944: fnd_log.string(l_log_procedure,
945: L_DEBUG_KEY || '.end',
946: 'Return Status = ' || x_return_status);

Line 950: WHEN Fnd_Api.G_EXC_ERROR THEN

946: 'Return Status = ' || x_return_status);
947: END IF;
948:
949: EXCEPTION
950: WHEN Fnd_Api.G_EXC_ERROR THEN
951: x_return_status := Fnd_Api.G_RET_STS_ERROR;
952: ROLLBACK TO GET_VISITS_FOR_DATE_ORG;
953: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
954: p_data => x_msg_data,

Line 951: x_return_status := Fnd_Api.G_RET_STS_ERROR;

947: END IF;
948:
949: EXCEPTION
950: WHEN Fnd_Api.G_EXC_ERROR THEN
951: x_return_status := Fnd_Api.G_RET_STS_ERROR;
952: ROLLBACK TO GET_VISITS_FOR_DATE_ORG;
953: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
954: p_data => x_msg_data,
955: p_encoded => Fnd_Api.g_false);

Line 955: p_encoded => Fnd_Api.g_false);

951: x_return_status := Fnd_Api.G_RET_STS_ERROR;
952: ROLLBACK TO GET_VISITS_FOR_DATE_ORG;
953: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
954: p_data => x_msg_data,
955: p_encoded => Fnd_Api.g_false);
956: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
957: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
958: ROLLBACK TO GET_VISITS_FOR_DATE_ORG;
959: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,

Line 956: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

952: ROLLBACK TO GET_VISITS_FOR_DATE_ORG;
953: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
954: p_data => x_msg_data,
955: p_encoded => Fnd_Api.g_false);
956: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
957: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
958: ROLLBACK TO GET_VISITS_FOR_DATE_ORG;
959: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
960: p_data => x_msg_data,

Line 957: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

953: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
954: p_data => x_msg_data,
955: p_encoded => Fnd_Api.g_false);
956: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
957: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
958: ROLLBACK TO GET_VISITS_FOR_DATE_ORG;
959: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
960: p_data => x_msg_data,
961: p_encoded => Fnd_Api.g_false);

Line 961: p_encoded => Fnd_Api.g_false);

957: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
958: ROLLBACK TO GET_VISITS_FOR_DATE_ORG;
959: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
960: p_data => x_msg_data,
961: p_encoded => Fnd_Api.g_false);
962: WHEN OTHERS THEN
963: ROLLBACK TO GET_VISITS_FOR_DATE_ORG;
964: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
965: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)

Line 964: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;

960: p_data => x_msg_data,
961: p_encoded => Fnd_Api.g_false);
962: WHEN OTHERS THEN
963: ROLLBACK TO GET_VISITS_FOR_DATE_ORG;
964: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
965: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
966: THEN
967: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
968: END IF;

Line 970: p_encoded => Fnd_Api.g_false,

966: THEN
967: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
968: END IF;
969: Fnd_Msg_Pub.count_and_get (
970: p_encoded => Fnd_Api.g_false,
971: p_count => x_msg_count,
972: p_data => x_msg_data);
973:
974: END GET_VISITS_FOR_DATE_ORG;

Line 982: -- p_init_msg_list VARCHAR2 Default FND_API.G_FALSE

978: -- Parameters :
979: --
980: -- Standard IN Parameters :
981: -- p_api_version NUMBER Required
982: -- p_init_msg_list VARCHAR2 Default FND_API.G_FALSE
983: -- p_validation_level NUMBER Default FND_API.G_VALID_LEVEL_FULL
984: --
985: -- Standard OUT Parameters :
986: -- x_return_status VARCHAR2 Required

Line 983: -- p_validation_level NUMBER Default FND_API.G_VALID_LEVEL_FULL

979: --
980: -- Standard IN Parameters :
981: -- p_api_version NUMBER Required
982: -- p_init_msg_list VARCHAR2 Default FND_API.G_FALSE
983: -- p_validation_level NUMBER Default FND_API.G_VALID_LEVEL_FULL
984: --
985: -- Standard OUT Parameters :
986: -- x_return_status VARCHAR2 Required
987: -- x_msg_count NUMBER Required

Line 995: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

991: -- x_sch_graph_results_tbl SCH_GRAPH_RESULTS_TBL
992:
993: PROCEDURE GET_FLT_SCH_GRAPH(
994: p_api_version IN NUMBER := 1.0,
995: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
996: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
997: x_return_status OUT NOCOPY VARCHAR2,
998: x_msg_count OUT NOCOPY NUMBER,
999: x_msg_data OUT NOCOPY VARCHAR2,

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

992:
993: PROCEDURE GET_FLT_SCH_GRAPH(
994: p_api_version IN NUMBER := 1.0,
995: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
996: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
997: x_return_status OUT NOCOPY VARCHAR2,
998: x_msg_count OUT NOCOPY NUMBER,
999: x_msg_data OUT NOCOPY VARCHAR2,
1000: p_flt_sch_search_rec IN FLEET_SCH_SEARCH_REC,

Line 1075: IF FND_API.to_boolean(p_init_msg_list)

1071: ' Display Window = ' || p_flt_sch_search_rec.DISPLAY_WINDOW);
1072: END IF;
1073:
1074: -- Standard call to check for call compatibility.
1075: IF FND_API.to_boolean(p_init_msg_list)
1076: THEN
1077: FND_MSG_PUB.initialize;
1078: END IF;
1079: -- Initialize API return status to success

Line 1080: x_return_status := FND_API.G_RET_STS_SUCCESS;

1076: THEN
1077: FND_MSG_PUB.initialize;
1078: END IF;
1079: -- Initialize API return status to success
1080: x_return_status := FND_API.G_RET_STS_SUCCESS;
1081:
1082: -- Initialize message list if p_init_msg_list is set to TRUE.
1083: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1084: p_api_version,

Line 1083: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

1079: -- Initialize API return status to success
1080: x_return_status := FND_API.G_RET_STS_SUCCESS;
1081:
1082: -- Initialize message list if p_init_msg_list is set to TRUE.
1083: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1084: p_api_version,
1085: l_api_name,G_PKG_NAME)
1086: THEN
1087: Fnd_Msg_Pub.ADD;

Line 1088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1084: p_api_version,
1085: l_api_name,G_PKG_NAME)
1086: THEN
1087: Fnd_Msg_Pub.ADD;
1088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1089: END IF;
1090: --
1091:
1092: IF(p_flt_sch_search_rec.FLEET_ID IS NULL) OR

Line 1101: RAISE Fnd_Api.G_EXC_ERROR;

1097: 'Passed Mandatory fields Org id or Display window is null');
1098: END IF;
1099: Fnd_Message.set_name(G_APP_NAME, 'AHL_AMP_FLEET_MANDATORY');
1100: FND_MSG_PUB.ADD;
1101: RAISE Fnd_Api.G_EXC_ERROR;
1102:
1103: ELSIF(p_flt_sch_search_rec.START_FROM_DATE IS NULL) AND
1104: (p_flt_sch_search_rec.START_BEFORE_DATE IS NULL) THEN
1105:

Line 1108: RAISE Fnd_Api.G_EXC_ERROR;

1104: (p_flt_sch_search_rec.START_BEFORE_DATE IS NULL) THEN
1105:
1106: Fnd_Message.set_name(G_APP_NAME, 'AHL_AMP_DATE_MANDATORY');
1107: Fnd_Msg_Pub.ADD;
1108: RAISE Fnd_Api.G_EXC_ERROR;
1109: END IF;
1110:
1111: l_loop_window := p_flt_sch_search_rec.DISPLAY_WINDOW;
1112:

Line 1161: p_init_msg_list => FND_API.G_FALSE,

1157: l_flt_sch_search_rec.DISPLAY_WINDOW := l_loop_window;
1158:
1159: GET_VISITS_FOR_DATE_FLT(
1160: p_api_version => p_api_version,
1161: p_init_msg_list => FND_API.G_FALSE,
1162: p_validation_level => p_validation_level,
1163: x_return_status => l_return_status,
1164: x_msg_count => l_msg_count,
1165: x_msg_data => l_msg_data,

Line 1182: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN

1178: END LOOP;
1179: CLOSE c_unit_for_flt;
1180:
1181: l_msg_count := Fnd_Msg_Pub.count_msg;
1182: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN
1183: IF (l_log_statement >= l_log_current_level) THEN
1184: fnd_log.string(l_log_statement,
1185: L_DEBUG_KEY,
1186: 'Errors from GET_VISITS_FOR_DATE_FLT. Message count: ' ||

Line 1190: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1186: 'Errors from GET_VISITS_FOR_DATE_FLT. Message count: ' ||
1187: l_msg_count || ', Message data: ' || l_msg_data);
1188: END IF;
1189: x_msg_count := l_msg_count;
1190: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1191: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1192: END IF;
1193:
1194: x_return_status := Fnd_Api.g_ret_sts_success;

Line 1191: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

1187: l_msg_count || ', Message data: ' || l_msg_data);
1188: END IF;
1189: x_msg_count := l_msg_count;
1190: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1191: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1192: END IF;
1193:
1194: x_return_status := Fnd_Api.g_ret_sts_success;
1195: IF (l_log_procedure >= l_log_current_level) THEN

Line 1194: x_return_status := Fnd_Api.g_ret_sts_success;

1190: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1191: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1192: END IF;
1193:
1194: x_return_status := Fnd_Api.g_ret_sts_success;
1195: IF (l_log_procedure >= l_log_current_level) THEN
1196: fnd_log.string(l_log_procedure,
1197: L_DEBUG_KEY || '.end',
1198: 'Return Status = ' || x_return_status);

Line 1202: WHEN Fnd_Api.G_EXC_ERROR THEN

1198: 'Return Status = ' || x_return_status);
1199: END IF;
1200:
1201: EXCEPTION
1202: WHEN Fnd_Api.G_EXC_ERROR THEN
1203: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1204: ROLLBACK TO GET_FLT_SCH_GRAPH;
1205: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
1206: p_data => x_msg_data,

Line 1203: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1199: END IF;
1200:
1201: EXCEPTION
1202: WHEN Fnd_Api.G_EXC_ERROR THEN
1203: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1204: ROLLBACK TO GET_FLT_SCH_GRAPH;
1205: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
1206: p_data => x_msg_data,
1207: p_encoded => Fnd_Api.g_false);

Line 1207: p_encoded => Fnd_Api.g_false);

1203: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1204: ROLLBACK TO GET_FLT_SCH_GRAPH;
1205: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
1206: p_data => x_msg_data,
1207: p_encoded => Fnd_Api.g_false);
1208: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1209: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1210: ROLLBACK TO GET_FLT_SCH_GRAPH;
1211: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,

Line 1208: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

1204: ROLLBACK TO GET_FLT_SCH_GRAPH;
1205: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
1206: p_data => x_msg_data,
1207: p_encoded => Fnd_Api.g_false);
1208: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1209: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1210: ROLLBACK TO GET_FLT_SCH_GRAPH;
1211: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
1212: p_data => x_msg_data,

Line 1209: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1205: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
1206: p_data => x_msg_data,
1207: p_encoded => Fnd_Api.g_false);
1208: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1209: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1210: ROLLBACK TO GET_FLT_SCH_GRAPH;
1211: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
1212: p_data => x_msg_data,
1213: p_encoded => Fnd_Api.g_false);

Line 1213: p_encoded => Fnd_Api.g_false);

1209: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1210: ROLLBACK TO GET_FLT_SCH_GRAPH;
1211: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
1212: p_data => x_msg_data,
1213: p_encoded => Fnd_Api.g_false);
1214: WHEN OTHERS THEN
1215: ROLLBACK TO GET_FLT_SCH_GRAPH;
1216: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1217: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)

Line 1216: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;

1212: p_data => x_msg_data,
1213: p_encoded => Fnd_Api.g_false);
1214: WHEN OTHERS THEN
1215: ROLLBACK TO GET_FLT_SCH_GRAPH;
1216: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1217: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
1218: THEN
1219: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
1220: END IF;

Line 1222: p_encoded => Fnd_Api.g_false,

1218: THEN
1219: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
1220: END IF;
1221: Fnd_Msg_Pub.count_and_get (
1222: p_encoded => Fnd_Api.g_false,
1223: p_count => x_msg_count,
1224: p_data => x_msg_data);
1225:
1226: END GET_FLT_SCH_GRAPH;

Line 1234: -- p_init_msg_list VARCHAR2 Default FND_API.G_FALSE

1230: -- Parameters :
1231: --
1232: -- Standard IN Parameters :
1233: -- p_api_version NUMBER Required
1234: -- p_init_msg_list VARCHAR2 Default FND_API.G_FALSE
1235: -- p_validation_level NUMBER Default FND_API.G_VALID_LEVEL_FULL
1236: --
1237: -- Standard OUT Parameters :
1238: -- x_return_status VARCHAR2 Required

Line 1235: -- p_validation_level NUMBER Default FND_API.G_VALID_LEVEL_FULL

1231: --
1232: -- Standard IN Parameters :
1233: -- p_api_version NUMBER Required
1234: -- p_init_msg_list VARCHAR2 Default FND_API.G_FALSE
1235: -- p_validation_level NUMBER Default FND_API.G_VALID_LEVEL_FULL
1236: --
1237: -- Standard OUT Parameters :
1238: -- x_return_status VARCHAR2 Required
1239: -- x_msg_count NUMBER Required

Line 1248: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

1244: -- x_sch_visits_tbl SCH_VISITS_TBL
1245:
1246: PROCEDURE GET_VISITS_FOR_DATE_FLT(
1247: p_api_version IN NUMBER := 1.0,
1248: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1249: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1250: x_return_status OUT NOCOPY VARCHAR2,
1251: x_msg_count OUT NOCOPY NUMBER,
1252: x_msg_data OUT NOCOPY VARCHAR2,

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

1245:
1246: PROCEDURE GET_VISITS_FOR_DATE_FLT(
1247: p_api_version IN NUMBER := 1.0,
1248: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1249: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1250: x_return_status OUT NOCOPY VARCHAR2,
1251: x_msg_count OUT NOCOPY NUMBER,
1252: x_msg_data OUT NOCOPY VARCHAR2,
1253: p_flt_sch_search_rec IN FLEET_SCH_SEARCH_REC,

Line 1275: l_not_for_sch VARCHAR2(1) := FND_API.G_FALSE;

1271: l_flt_sch_search_rec fleet_sch_search_rec;
1272: l_sch_graph_rec SCH_GRAPH_RESULTS_REC;
1273: l_sch_visits_tbl sch_visits_tbl;
1274: l_dummy VARCHAR2(1);
1275: l_not_for_sch VARCHAR2(1) := FND_API.G_FALSE;
1276:
1277: -- Cursor
1278: CURSOR c_visit_for_unit_day (c_unit_id IN NUMBER, c_duration IN NUMBER, c_loop_date IN DATE)
1279: IS

Line 1341: IF FND_API.to_boolean(p_init_msg_list)

1337: ' Loop Window = ' || p_flt_sch_search_rec.DISPLAY_WINDOW);
1338: END IF;
1339:
1340: -- Standard call to check for call compatibility.
1341: IF FND_API.to_boolean(p_init_msg_list)
1342: THEN
1343: FND_MSG_PUB.initialize;
1344: END IF;
1345: -- Initialize API return status to success

Line 1346: x_return_status := FND_API.G_RET_STS_SUCCESS;

1342: THEN
1343: FND_MSG_PUB.initialize;
1344: END IF;
1345: -- Initialize API return status to success
1346: x_return_status := FND_API.G_RET_STS_SUCCESS;
1347:
1348: -- Initialize message list if p_init_msg_list is set to TRUE.
1349: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1350: p_api_version,

Line 1349: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

1345: -- Initialize API return status to success
1346: x_return_status := FND_API.G_RET_STS_SUCCESS;
1347:
1348: -- Initialize message list if p_init_msg_list is set to TRUE.
1349: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1350: p_api_version,
1351: l_api_name,G_PKG_NAME)
1352: THEN
1353: Fnd_Msg_Pub.ADD;

Line 1354: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1350: p_api_version,
1351: l_api_name,G_PKG_NAME)
1352: THEN
1353: Fnd_Msg_Pub.ADD;
1354: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1355: END IF;
1356: --
1357:
1358: IF(p_flt_sch_search_rec.UNIT_ID IS NULL) OR

Line 1369: RAISE Fnd_Api.G_EXC_ERROR;

1365: 'One of the Passed Mandatory fields is null');
1366: END IF;
1367: Fnd_Message.set_name(G_APP_NAME, 'AHL_AMP_FLEET_MANDATORY');
1368: FND_MSG_PUB.ADD;
1369: RAISE Fnd_Api.G_EXC_ERROR;
1370: END IF;
1371:
1372: l_loop_window := p_flt_sch_search_rec.DISPLAY_WINDOW;
1373: l_loop_start_date := p_flt_sch_search_rec.START_FROM_DATE;

Line 1400: l_not_for_sch := FND_API.G_TRUE;

1396: ,l_loop_start_date);
1397:
1398: FETCH c_flt_unit_ass_day INTO l_dummy;
1399: IF c_flt_unit_ass_day%NOTFOUND THEN
1400: l_not_for_sch := FND_API.G_TRUE;
1401: ELSE
1402: l_not_for_sch := FND_API.G_FALSE;
1403: END IF;
1404: CLOSE c_flt_unit_ass_day;

Line 1402: l_not_for_sch := FND_API.G_FALSE;

1398: FETCH c_flt_unit_ass_day INTO l_dummy;
1399: IF c_flt_unit_ass_day%NOTFOUND THEN
1400: l_not_for_sch := FND_API.G_TRUE;
1401: ELSE
1402: l_not_for_sch := FND_API.G_FALSE;
1403: END IF;
1404: CLOSE c_flt_unit_ass_day;
1405:
1406: -- call GET_GRAPH_REC_FOR_DATE

Line 1422: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN

1418: x_sch_visits_tbl := l_sch_visits_tbl;
1419: x_sch_graph_rec := l_sch_graph_rec;
1420:
1421: l_msg_count := Fnd_Msg_Pub.count_msg;
1422: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN
1423: IF (l_log_statement >= l_log_current_level) THEN
1424: fnd_log.string(l_log_statement,
1425: L_DEBUG_KEY,
1426: 'Errors from GET_VISITS_FOR_DATE_FLT. Message count: ' ||

Line 1430: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1426: 'Errors from GET_VISITS_FOR_DATE_FLT. Message count: ' ||
1427: l_msg_count || ', Message data: ' || l_msg_data);
1428: END IF;
1429: x_msg_count := l_msg_count;
1430: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1431: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1432: END IF;
1433:
1434: x_return_status := Fnd_Api.g_ret_sts_success;

Line 1431: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

1427: l_msg_count || ', Message data: ' || l_msg_data);
1428: END IF;
1429: x_msg_count := l_msg_count;
1430: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1431: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1432: END IF;
1433:
1434: x_return_status := Fnd_Api.g_ret_sts_success;
1435: IF (l_log_procedure >= l_log_current_level) THEN

Line 1434: x_return_status := Fnd_Api.g_ret_sts_success;

1430: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1431: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1432: END IF;
1433:
1434: x_return_status := Fnd_Api.g_ret_sts_success;
1435: IF (l_log_procedure >= l_log_current_level) THEN
1436: fnd_log.string(l_log_procedure,
1437: L_DEBUG_KEY || '.end',
1438: 'Return Status = ' || x_return_status);

Line 1442: WHEN Fnd_Api.G_EXC_ERROR THEN

1438: 'Return Status = ' || x_return_status);
1439: END IF;
1440:
1441: EXCEPTION
1442: WHEN Fnd_Api.G_EXC_ERROR THEN
1443: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1444: ROLLBACK TO GET_VISITS_FOR_DATE_FLT;
1445: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
1446: p_data => x_msg_data,

Line 1443: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1439: END IF;
1440:
1441: EXCEPTION
1442: WHEN Fnd_Api.G_EXC_ERROR THEN
1443: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1444: ROLLBACK TO GET_VISITS_FOR_DATE_FLT;
1445: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
1446: p_data => x_msg_data,
1447: p_encoded => Fnd_Api.g_false);

Line 1447: p_encoded => Fnd_Api.g_false);

1443: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1444: ROLLBACK TO GET_VISITS_FOR_DATE_FLT;
1445: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
1446: p_data => x_msg_data,
1447: p_encoded => Fnd_Api.g_false);
1448: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1449: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1450: ROLLBACK TO GET_VISITS_FOR_DATE_FLT;
1451: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,

Line 1448: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

1444: ROLLBACK TO GET_VISITS_FOR_DATE_FLT;
1445: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
1446: p_data => x_msg_data,
1447: p_encoded => Fnd_Api.g_false);
1448: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1449: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1450: ROLLBACK TO GET_VISITS_FOR_DATE_FLT;
1451: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
1452: p_data => x_msg_data,

Line 1449: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1445: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
1446: p_data => x_msg_data,
1447: p_encoded => Fnd_Api.g_false);
1448: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1449: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1450: ROLLBACK TO GET_VISITS_FOR_DATE_FLT;
1451: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
1452: p_data => x_msg_data,
1453: p_encoded => Fnd_Api.g_false);

Line 1453: p_encoded => Fnd_Api.g_false);

1449: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1450: ROLLBACK TO GET_VISITS_FOR_DATE_FLT;
1451: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
1452: p_data => x_msg_data,
1453: p_encoded => Fnd_Api.g_false);
1454: WHEN OTHERS THEN
1455: ROLLBACK TO GET_VISITS_FOR_DATE_FLT;
1456: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1457: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)

Line 1456: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;

1452: p_data => x_msg_data,
1453: p_encoded => Fnd_Api.g_false);
1454: WHEN OTHERS THEN
1455: ROLLBACK TO GET_VISITS_FOR_DATE_FLT;
1456: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1457: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
1458: THEN
1459: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
1460: END IF;

Line 1462: p_encoded => Fnd_Api.g_false,

1458: THEN
1459: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
1460: END IF;
1461: Fnd_Msg_Pub.count_and_get (
1462: p_encoded => Fnd_Api.g_false,
1463: p_count => x_msg_count,
1464: p_data => x_msg_data);
1465:
1466: END GET_VISITS_FOR_DATE_FLT;

Line 1485: p_not_for_sch IN VARCHAR2 := Fnd_Api.g_false,

1481: PROCEDURE GET_GRAPH_REC_FOR_DATE(
1482: p_graph_rec_date IN DATE,
1483: p_graph_rec_num IN NUMBER,
1484: p_visit_count IN NUMBER,
1485: p_not_for_sch IN VARCHAR2 := Fnd_Api.g_false,
1486: p_filter_criteria IN VARCHAR2 := 'ALL',
1487: p_rec_type IN VARCHAR2 := G_SPACE_TYPE,
1488: p_sch_visits_tbl IN sch_visits_tbl,
1489: p_x_sch_graph_rec IN OUT NOCOPY SCH_GRAPH_RESULTS_REC

Line 1522: IF(p_not_for_sch = Fnd_Api.g_true) THEN

1518: l_conflict VARCHAR2(30) := l_M_V_conflict||p_graph_rec_num;
1519: l_no_visit VARCHAR2(30) := l_N_no_visit||p_graph_rec_num;
1520:
1521: BEGIN
1522: IF(p_not_for_sch = Fnd_Api.g_true) THEN
1523: l_schedule_type := l_N_not_available||p_graph_rec_num;
1524:
1525: ELSIF(p_visit_count < 1) THEN
1526: l_schedule_type := l_N_no_visit || p_graph_rec_num;

Line 1657: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

1653: p_x_sch_graph_rec.VISIT_DATE_21 := p_graph_rec_date;
1654: p_x_sch_graph_rec.VISIT_ID_21 := l_visit_id;
1655: ELSE
1656: FND_MSG_PUB.ADD;
1657: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1658: END CASE;
1659:
1660: IF(p_filter_criteria IN (l_filter_open, l_filter_conflict)) THEN
1661: IF NOT p_x_sch_graph_rec.FILTER_REC THEN