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.PNT_LOCATIONS_PKG dependencies on PNT_LOCATIONS_PKG

Line 1: PACKAGE BODY PNT_LOCATIONS_PKG AS

1: PACKAGE BODY PNT_LOCATIONS_PKG AS
2: -- $Header: PNTLOCNB.pls 120.8.12010000.3 2008/11/27 04:42:30 rthumma ship $
3:
4: TYPE loc_info_rec IS
5: RECORD (active_start_date pn_locations.active_start_date%TYPE,

Line 145: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.check_location_overlap(+)');

141: l_max_end_date DATE;
142:
143: BEGIN
144:
145: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.check_location_overlap(+)');
146: pnp_debug_pkg.debug(' ChkLocOlap=> In Parameters :: p_location_id: '||p_location_id||', LocCd: '||p_location_code
147: ||', Type: '||p_location_type_lookup_code||' OrgId: '||p_org_id);
148: pnp_debug_pkg.debug(' ChkLocOlap=> p_active_start_date : '||TO_CHAR(p_active_start_date, 'MM/DD/YYYY')
149: ||', p_active_end_date : '||TO_CHAR(p_active_end_date, 'MM/DD/YYYY'));

Line 218: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.check_location_overlap(-) ReturnStatus: '||x_return_status);

214: END LOOP;
215: END IF;
216: END IF;
217:
218: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.check_location_overlap(-) ReturnStatus: '||x_return_status);
219: EXCEPTION
220:
221: WHEN OTHERS THEN
222: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

Line 251: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.check_location_gaps(+)');

247: l_max_end_date DATE;
248:
249: BEGIN
250:
251: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.check_location_gaps(+)');
252: pnp_debug_pkg.debug(' ChkLocGap=> In Parameters :: p_location_id: '||p_location_id
253: ||', LocCd: '||p_location_code||', OrgId: '||p_org_id);
254: pnp_debug_pkg.debug(' ChkLocGap=> p_active_start_date : '||TO_CHAR(p_active_start_date, 'MM/DD/YYYY')
255: ||', p_active_end_date : '||TO_CHAR(p_active_end_date, 'MM/DD/YYYY'));

Line 331: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.check_location_gaps(-) ReturnStatus: '||x_return_status);

327: END LOOP;
328: END IF;
329: END IF;
330:
331: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.check_location_gaps(-) ReturnStatus: '||x_return_status);
332: EXCEPTION
333:
334: WHEN OTHERS THEN
335: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

Line 552: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.Correct_Update_Row (+) Mode: '||p_change_mode||', Cascade: '||p_cascade

548:
549: BEGIN
550:
551:
552: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.Correct_Update_Row (+) Mode: '||p_change_mode||', Cascade: '||p_cascade
553: ||', AsofDt: '||p_as_of_date);
554: pnp_debug_pkg.debug(' CorUpdRow=> LocId: '||p_pn_locations_rec.location_id||', LocCd: '||p_pn_locations_rec.location_code
555: ||', Type: '||p_pn_locations_rec.location_type_lookup_code
556: ||', StrDt: '||TO_CHAR(p_pn_locations_rec.active_start_date, 'MM/DD/YYYY')

Line 561: PNT_LOCATIONS_PKG.SET_ROWID(

557: ||', EndDt: '||TO_CHAR(p_pn_locations_rec.active_end_date, 'MM/DD/YYYY'));
558:
559: x_return_status := FND_API.G_RET_STS_SUCCESS;
560:
561: PNT_LOCATIONS_PKG.SET_ROWID(
562: p_location_id => p_pn_locations_rec.location_id,
563: p_active_start_date => p_active_start_date_old,
564: p_active_end_date => p_active_end_date_old,
565: x_return_status => x_return_status,

Line 599: PNT_LOCATIONS_PKG.update_assignments (

595: END IF;
596:
597: -- Added redwin Fix for Bug 2722698
598:
599: PNT_LOCATIONS_PKG.update_assignments (
600: p_location_id => p_pn_locations_rec.location_id,
601: p_active_start_date => p_pn_locations_Rec.active_start_date,
602: p_active_end_date => p_pn_locations_rec.active_end_date,
603: p_active_start_date_old => p_active_start_date_old,

Line 639: PNT_LOCATIONS_PKG.Update_child_for_dates (

635: nvl(p_pn_locations_rec.active_end_date,G_END_OF_TIME) OR
636: G_LOC_RECINFO.active_start_date
637: < nvl(p_pn_locations_rec.active_start_date,G_START_OF_TIME) THEN
638:
639: PNT_LOCATIONS_PKG.Update_child_for_dates (
640: p_location_id => p_pn_locations_rec.location_id,
641: p_active_start_date => p_pn_locations_Rec.active_start_date,
642: p_active_end_date => p_pn_locations_rec.active_end_date,
643: p_active_start_date_old => p_active_start_date_old,

Line 667: PNT_LOCATIONS_PKG.check_location_overlap (

663: -- This procedure checks that there is no overlap
664: -- of dates for the same location
665: ------------------------------------------------
666: pnp_debug_pkg.put_log_msg('Calling check_location_overlap');
667: PNT_LOCATIONS_PKG.check_location_overlap (
668: p_org_id => p_pn_locations_rec.org_id,
669: p_location_id => p_pn_locations_rec.location_id,
670: p_location_code => p_pn_locations_rec.location_code,
671: p_location_type_lookup_code => p_pn_locations_rec.location_type_lookup_code,

Line 688: PNT_LOCATIONS_PKG.check_location_gaps (

684: END IF;
685:
686: IF p_pn_locations_rec.location_type_lookup_code NOT IN ('OFFICE', 'SECTION') THEN
687: pnp_debug_pkg.put_log_msg('Calling check_location_gaps');
688: PNT_LOCATIONS_PKG.check_location_gaps (
689: p_org_id => p_pn_locations_rec.org_id,
690: p_location_id => p_pn_locations_rec.location_id,
691: p_location_code => p_pn_locations_rec.location_code,
692: p_location_type_lookup_code => p_pn_locations_rec.location_type_lookup_code,

Line 714: pnt_locations_pkg.Set_Cascade(p_cascade);

710: PNP_DEBUG_PKG.put_log_msg('call update row ');
711:
712: g_loc_recinfo_tmp := p_pn_locations_rec;
713: g_loc_adrinfo_tmp := p_pn_addresses_rec;
714: pnt_locations_pkg.Set_Cascade(p_cascade);
715: pnt_locations_pkg.Update_Locn_Row(
716: p_loc_recinfo => g_loc_recinfo_tmp
717: ,p_adr_recinfo => g_loc_adrinfo_tmp
718: ,p_assgn_area_chgd_flag => p_change_mode

Line 715: pnt_locations_pkg.Update_Locn_Row(

711:
712: g_loc_recinfo_tmp := p_pn_locations_rec;
713: g_loc_adrinfo_tmp := p_pn_addresses_rec;
714: pnt_locations_pkg.Set_Cascade(p_cascade);
715: pnt_locations_pkg.Update_Locn_Row(
716: p_loc_recinfo => g_loc_recinfo_tmp
717: ,p_adr_recinfo => g_loc_adrinfo_tmp
718: ,p_assgn_area_chgd_flag => p_change_mode
719: ,x_return_status => x_return_status

Line 730: pnt_locations_pkg.cascade_child_locn(

726: END IF;
727:
728: IF p_pn_locations_rec.location_type_lookup_code NOT IN ('OFFICE', 'SECTION') AND
729: LTRIM(RTRIM(p_cascade)) IS NOT NULL THEN
730: pnt_locations_pkg.cascade_child_locn(
731: p_location_id => p_pn_locations_rec.location_id
732: ,p_start_date => p_pn_locations_rec.active_start_date
733: ,p_end_date => p_pn_locations_rec.active_end_date
734: ,p_cascade => p_cascade

Line 762: pnt_locations_pkg.Set_Cascade(p_cascade);

758: g_loc_recinfo_tmp := p_pn_locations_rec;
759: g_loc_adrinfo_tmp := p_pn_addresses_rec;
760: g_loc_recinfo_tmp.active_start_date := p_as_of_date;
761: g_loc_recinfo_tmp.active_end_date := l_active_end_date_new;
762: pnt_locations_pkg.Set_Cascade(p_cascade);
763: pnt_locations_pkg.Update_Locn_Row(
764: p_loc_recinfo => g_loc_recinfo_tmp
765: ,p_adr_recinfo => g_loc_adrinfo_tmp
766: ,p_assgn_area_chgd_flag => p_change_mode

Line 763: pnt_locations_pkg.Update_Locn_Row(

759: g_loc_adrinfo_tmp := p_pn_addresses_rec;
760: g_loc_recinfo_tmp.active_start_date := p_as_of_date;
761: g_loc_recinfo_tmp.active_end_date := l_active_end_date_new;
762: pnt_locations_pkg.Set_Cascade(p_cascade);
763: pnt_locations_pkg.Update_Locn_Row(
764: p_loc_recinfo => g_loc_recinfo_tmp
765: ,p_adr_recinfo => g_loc_adrinfo_tmp
766: ,p_assgn_area_chgd_flag => p_change_mode
767: ,x_return_status => x_return_status

Line 785: pnt_locations_pkg.Set_Null_Request_Program_Id;

781: g_loc_adrinfo_tmp := p_pn_addresses_rec;
782: --Bug#6755579 g_loc_recinfo_tmp.common_area_flag := NULL;
783: g_loc_recinfo_tmp.active_start_date := l_active_start_date_new;
784: g_loc_recinfo_tmp.active_end_date := p_as_of_date - 1;
785: pnt_locations_pkg.Set_Null_Request_Program_Id;
786: pnt_locations_pkg.Insert_Locn_Row(
787: p_loc_recinfo => g_loc_recinfo_tmp
788: ,p_adr_recinfo => g_loc_adrinfo_tmp
789: ,p_change_mode => p_change_mode

Line 786: pnt_locations_pkg.Insert_Locn_Row(

782: --Bug#6755579 g_loc_recinfo_tmp.common_area_flag := NULL;
783: g_loc_recinfo_tmp.active_start_date := l_active_start_date_new;
784: g_loc_recinfo_tmp.active_end_date := p_as_of_date - 1;
785: pnt_locations_pkg.Set_Null_Request_Program_Id;
786: pnt_locations_pkg.Insert_Locn_Row(
787: p_loc_recinfo => g_loc_recinfo_tmp
788: ,p_adr_recinfo => g_loc_adrinfo_tmp
789: ,p_change_mode => p_change_mode
790: ,x_return_status => x_return_status

Line 801: pnt_locations_pkg.cascade_child_locn(

797: END IF;
798:
799: IF p_pn_locations_rec.location_type_lookup_code NOT IN ('OFFICE', 'SECTION') AND
800: LTRIM(RTRIM(p_cascade)) IS NOT NULL THEN
801: pnt_locations_pkg.cascade_child_locn(
802: p_location_id => p_pn_locations_rec.location_id
803: ,p_start_date => p_as_of_date
804: ,p_end_date => l_active_end_date_new
805: ,p_cascade => p_cascade

Line 815: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.Correct_Update_Row (-) ReturnStatus: '||x_return_status);

811:
812: END IF;
813: -- End if of correct or update
814:
815: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.Correct_Update_Row (-) ReturnStatus: '||x_return_status);
816:
817: EXCEPTION
818: WHEN OTHERS THEN
819: x_return_status := FND_API.G_RET_STS_ERROR;

Line 870: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.Cascade_Child_Locn (+)');

866: ORDER BY location_type_lookup_code, active_start_date;
867:
868: BEGIN
869:
870: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.Cascade_Child_Locn (+)');
871: pnp_debug_pkg.debug(' CacCldLoc=> In Parameters :: p_location_id: '||p_location_id||', Cascade: '||p_cascade
872: ||', Mode: '||p_change_mode);
873: pnp_debug_pkg.debug(' CacCldLoc=> StrDt: '||TO_CHAR(p_start_date, 'MM/DD/YYYY')
874: ||', EndDt: '||TO_CHAR(p_end_date, 'MM/DD/YYYY'));

Line 917: pnt_locations_pkg.Set_RowId(locn_rec.location_id, locn_rec.active_start_date, locn_rec.active_end_date,

913: pnp_debug_pkg.debug(' CacCldLoc> ActStrDate : '||TO_CHAR(locn_rec.active_start_date, 'MM/DD/YYYY')
914: ||', ActEndDate : '||TO_CHAR(locn_rec.active_end_date, 'MM/DD/YYYY'));
915:
916: IF l_split = 'Y' THEN
917: pnt_locations_pkg.Set_RowId(locn_rec.location_id, locn_rec.active_start_date, locn_rec.active_end_date,
918: x_return_status, x_return_message);
919:
920: IF locn_rec.active_start_date < p_start_date AND
921: locn_rec.active_end_date > p_end_date THEN

Line 927: pnt_locations_pkg.Update_Locn_Row(g_loc_recinfo_tmp, NULL, p_change_mode, x_return_status, x_return_message);

923: pnp_debug_pkg.debug(' CacCldLoc> ... Case# 1: ActStrDt < pStrDt AND ActEndDt > pEndDt');
924: IF x_return_status = 'S' THEN
925: g_loc_recinfo_tmp := locn_rec;
926: g_loc_recinfo_tmp.active_end_date := p_start_date-1;
927: pnt_locations_pkg.Update_Locn_Row(g_loc_recinfo_tmp, NULL, p_change_mode, x_return_status, x_return_message);
928: END IF;
929:
930: IF x_return_status = 'S' THEN
931: g_loc_recinfo_tmp := locn_rec;

Line 934: pnt_locations_pkg.Set_Null_Request_Program_Id;

930: IF x_return_status = 'S' THEN
931: g_loc_recinfo_tmp := locn_rec;
932: g_loc_recinfo_tmp.active_start_date := p_start_date;
933: g_loc_recinfo_tmp.active_end_date := p_end_date;
934: pnt_locations_pkg.Set_Null_Request_Program_Id;
935: pnt_locations_pkg.Set_Cascade(p_cascade);
936: pnt_locations_pkg.Insert_Locn_Row(g_loc_recinfo_tmp, NULL, p_change_mode, x_return_status, x_return_message);
937: END IF;
938:

Line 935: pnt_locations_pkg.Set_Cascade(p_cascade);

931: g_loc_recinfo_tmp := locn_rec;
932: g_loc_recinfo_tmp.active_start_date := p_start_date;
933: g_loc_recinfo_tmp.active_end_date := p_end_date;
934: pnt_locations_pkg.Set_Null_Request_Program_Id;
935: pnt_locations_pkg.Set_Cascade(p_cascade);
936: pnt_locations_pkg.Insert_Locn_Row(g_loc_recinfo_tmp, NULL, p_change_mode, x_return_status, x_return_message);
937: END IF;
938:
939: IF x_return_status = 'S' THEN

Line 936: pnt_locations_pkg.Insert_Locn_Row(g_loc_recinfo_tmp, NULL, p_change_mode, x_return_status, x_return_message);

932: g_loc_recinfo_tmp.active_start_date := p_start_date;
933: g_loc_recinfo_tmp.active_end_date := p_end_date;
934: pnt_locations_pkg.Set_Null_Request_Program_Id;
935: pnt_locations_pkg.Set_Cascade(p_cascade);
936: pnt_locations_pkg.Insert_Locn_Row(g_loc_recinfo_tmp, NULL, p_change_mode, x_return_status, x_return_message);
937: END IF;
938:
939: IF x_return_status = 'S' THEN
940: g_loc_recinfo_tmp := locn_rec;

Line 942: pnt_locations_pkg.Set_Null_Request_Program_Id;

938:
939: IF x_return_status = 'S' THEN
940: g_loc_recinfo_tmp := locn_rec;
941: g_loc_recinfo_tmp.active_start_date := p_end_date+1;
942: pnt_locations_pkg.Set_Null_Request_Program_Id;
943: pnt_locations_pkg.Insert_Locn_Row(g_loc_recinfo_tmp, NULL, p_change_mode, x_return_status, x_return_message);
944: END IF;
945:
946: ELSIF locn_rec.active_start_date < p_start_date THEN

Line 943: pnt_locations_pkg.Insert_Locn_Row(g_loc_recinfo_tmp, NULL, p_change_mode, x_return_status, x_return_message);

939: IF x_return_status = 'S' THEN
940: g_loc_recinfo_tmp := locn_rec;
941: g_loc_recinfo_tmp.active_start_date := p_end_date+1;
942: pnt_locations_pkg.Set_Null_Request_Program_Id;
943: pnt_locations_pkg.Insert_Locn_Row(g_loc_recinfo_tmp, NULL, p_change_mode, x_return_status, x_return_message);
944: END IF;
945:
946: ELSIF locn_rec.active_start_date < p_start_date THEN
947:

Line 952: pnt_locations_pkg.Update_Locn_Row(g_loc_recinfo_tmp, NULL, p_change_mode, x_return_status, x_return_message);

948: pnp_debug_pkg.debug(' CacCldLoc> ... Case# 2: ActStrDt < pStrDt');
949: IF x_return_status = 'S' THEN
950: g_loc_recinfo_tmp := locn_rec;
951: g_loc_recinfo_tmp.active_end_date := p_start_date-1;
952: pnt_locations_pkg.Update_Locn_Row(g_loc_recinfo_tmp, NULL, p_change_mode, x_return_status, x_return_message);
953: END IF;
954:
955: IF x_return_status = 'S' THEN
956: g_loc_recinfo_tmp := locn_rec;

Line 958: pnt_locations_pkg.Set_Null_Request_Program_Id;

954:
955: IF x_return_status = 'S' THEN
956: g_loc_recinfo_tmp := locn_rec;
957: g_loc_recinfo_tmp.active_start_date := p_start_date;
958: pnt_locations_pkg.Set_Null_Request_Program_Id;
959: pnt_locations_pkg.Set_Cascade(p_cascade);
960: pnt_locations_pkg.Insert_Locn_Row(g_loc_recinfo_tmp, NULL, p_change_mode, x_return_status, x_return_message);
961: END IF;
962:

Line 959: pnt_locations_pkg.Set_Cascade(p_cascade);

955: IF x_return_status = 'S' THEN
956: g_loc_recinfo_tmp := locn_rec;
957: g_loc_recinfo_tmp.active_start_date := p_start_date;
958: pnt_locations_pkg.Set_Null_Request_Program_Id;
959: pnt_locations_pkg.Set_Cascade(p_cascade);
960: pnt_locations_pkg.Insert_Locn_Row(g_loc_recinfo_tmp, NULL, p_change_mode, x_return_status, x_return_message);
961: END IF;
962:
963: ELSIF locn_rec.active_end_date > p_end_date THEN

Line 960: pnt_locations_pkg.Insert_Locn_Row(g_loc_recinfo_tmp, NULL, p_change_mode, x_return_status, x_return_message);

956: g_loc_recinfo_tmp := locn_rec;
957: g_loc_recinfo_tmp.active_start_date := p_start_date;
958: pnt_locations_pkg.Set_Null_Request_Program_Id;
959: pnt_locations_pkg.Set_Cascade(p_cascade);
960: pnt_locations_pkg.Insert_Locn_Row(g_loc_recinfo_tmp, NULL, p_change_mode, x_return_status, x_return_message);
961: END IF;
962:
963: ELSIF locn_rec.active_end_date > p_end_date THEN
964:

Line 969: pnt_locations_pkg.Set_Cascade(p_cascade);

965: pnp_debug_pkg.debug(' CacCldLoc> ... Case# 3: ActEndDt > pEndDt');
966: IF x_return_status = 'S' THEN
967: g_loc_recinfo_tmp := locn_rec;
968: g_loc_recinfo_tmp.active_end_date := p_end_date;
969: pnt_locations_pkg.Set_Cascade(p_cascade);
970: pnt_locations_pkg.Update_Locn_Row(g_loc_recinfo_tmp, NULL, p_change_mode, x_return_status, x_return_message);
971: END IF;
972:
973: IF x_return_status = 'S' THEN

Line 970: pnt_locations_pkg.Update_Locn_Row(g_loc_recinfo_tmp, NULL, p_change_mode, x_return_status, x_return_message);

966: IF x_return_status = 'S' THEN
967: g_loc_recinfo_tmp := locn_rec;
968: g_loc_recinfo_tmp.active_end_date := p_end_date;
969: pnt_locations_pkg.Set_Cascade(p_cascade);
970: pnt_locations_pkg.Update_Locn_Row(g_loc_recinfo_tmp, NULL, p_change_mode, x_return_status, x_return_message);
971: END IF;
972:
973: IF x_return_status = 'S' THEN
974: g_loc_recinfo_tmp := locn_rec;

Line 976: pnt_locations_pkg.Set_Null_Request_Program_Id;

972:
973: IF x_return_status = 'S' THEN
974: g_loc_recinfo_tmp := locn_rec;
975: g_loc_recinfo_tmp.active_start_date := p_end_date+1;
976: pnt_locations_pkg.Set_Null_Request_Program_Id;
977: pnt_locations_pkg.Insert_Locn_Row(g_loc_recinfo_tmp, NULL, p_change_mode, x_return_status, x_return_message);
978: END IF;
979:
980: ELSE

Line 977: pnt_locations_pkg.Insert_Locn_Row(g_loc_recinfo_tmp, NULL, p_change_mode, x_return_status, x_return_message);

973: IF x_return_status = 'S' THEN
974: g_loc_recinfo_tmp := locn_rec;
975: g_loc_recinfo_tmp.active_start_date := p_end_date+1;
976: pnt_locations_pkg.Set_Null_Request_Program_Id;
977: pnt_locations_pkg.Insert_Locn_Row(g_loc_recinfo_tmp, NULL, p_change_mode, x_return_status, x_return_message);
978: END IF;
979:
980: ELSE
981:

Line 985: pnt_locations_pkg.Set_Cascade(p_cascade);

981:
982: pnp_debug_pkg.debug(' CacCldLoc> ... Case# 4: ActStrDt >= pStrDt AND ActEndDt <= pEndDt');
983: IF x_return_status = 'S' THEN
984: g_loc_recinfo_tmp := locn_rec;
985: pnt_locations_pkg.Set_Cascade(p_cascade);
986: pnt_locations_pkg.Update_Locn_Row(g_loc_recinfo_tmp, NULL, p_change_mode, x_return_status, x_return_message);
987: END IF;
988:
989: END IF;

Line 986: pnt_locations_pkg.Update_Locn_Row(g_loc_recinfo_tmp, NULL, p_change_mode, x_return_status, x_return_message);

982: pnp_debug_pkg.debug(' CacCldLoc> ... Case# 4: ActStrDt >= pStrDt AND ActEndDt <= pEndDt');
983: IF x_return_status = 'S' THEN
984: g_loc_recinfo_tmp := locn_rec;
985: pnt_locations_pkg.Set_Cascade(p_cascade);
986: pnt_locations_pkg.Update_Locn_Row(g_loc_recinfo_tmp, NULL, p_change_mode, x_return_status, x_return_message);
987: END IF;
988:
989: END IF;
990: END IF;

Line 998: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.Cascade_Child_Locn (-) ReturnStatus: '||x_return_status);

994: IF x_return_status IS NULL THEN
995: x_return_status := fnd_api.g_ret_sts_success;
996: END IF;
997:
998: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.Cascade_Child_Locn (-) ReturnStatus: '||x_return_status);
999:
1000: END Cascade_Child_Locn;
1001:
1002:

Line 1072: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.Check_Locn_Assgn (+)');

1068: AND NVL(emp_assign_end_date, TO_DATE('12/31/4712','MM/DD/YYYY')) >= l_str_date);
1069:
1070: BEGIN
1071:
1072: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.Check_Locn_Assgn (+)');
1073: l_str_date := p_str_date;
1074: l_end_date := NVL(p_end_date, TO_DATE('12/31/4712','MM/DD/YYYY'));
1075:
1076: OPEN check_assign_csr;

Line 1086: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.Check_Locn_Assgn (-) l_exists: '||l_asgn_exists);

1082: ELSE
1083: l_exists := FALSE;
1084: END IF;
1085:
1086: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.Check_Locn_Assgn (-) l_exists: '||l_asgn_exists);
1087:
1088: RETURN l_exists;
1089:
1090: END Check_Locn_Assgn;

Line 1129: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.Parent_Not_Occpble_Asgnble (+) LocId:'||p_parent_location_id

1125: OR (p_status_mode IN ('CUST') AND NVL(assignable_cust, 'Y') = 'N')));
1126:
1127: BEGIN
1128:
1129: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.Parent_Not_Occpble_Asgnble (+) LocId:'||p_parent_location_id
1130: ||', Mode: '||p_status_mode
1131: ||', StrDt: '||TO_CHAR(p_str_date, 'MM/DD/YYYY')
1132: ||', EndDt: '||TO_CHAR(p_end_date, 'MM/DD/YYYY'));
1133: l_str_date := p_str_date;

Line 1148: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.Parent_Not_Occpble_Asgnble (-) l_exists: '||l_loc_status);

1144: l_exists := FALSE;
1145: END IF;
1146: END IF;
1147:
1148: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.Parent_Not_Occpble_Asgnble (-) l_exists: '||l_loc_status);
1149:
1150: RETURN l_exists;
1151:
1152: END Parent_Not_Occpble_Asgnble;

Line 1297: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.insert_row (+) LocId: '||x_location_id||', LocCd: '||x_location_code

1293: l_return_message VARCHAR2(32767) := NULL;
1294: l_sqlerrm VARCHAR2(2000);
1295:
1296: BEGIN
1297: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.insert_row (+) LocId: '||x_location_id||', LocCd: '||x_location_code
1298: ||', Type: '||x_location_type_lookup_code
1299: ||', ActStrDt: '||TO_CHAR(x_active_start_date, 'MM/DD/YYYY')
1300: ||', ActEndDt: '||TO_CHAR(x_active_end_date, 'MM/DD/YYYY'));
1301: x_return_status := fnd_api.g_ret_sts_success;

Line 1308: PNT_LOCATIONS_PKG.check_unique_location_alias ( l_return_status,

1304: -- Call CHECK_UNIQUE_LOCATION_ALIAS to check if the location alias
1305: -- is unique.
1306: -----------------------------------------------------------------
1307: l_return_status := NULL;
1308: PNT_LOCATIONS_PKG.check_unique_location_alias ( l_return_status,
1309: x_location_id,
1310: x_parent_location_id,
1311: x_location_type_lookup_code,
1312: x_location_alias,

Line 1341: IF NOT pnt_locations_pkg.validate_gross_area(x_parent_location_id,

1337:
1338: IF x_location_type_lookup_code IN ('OFFICE', 'SECTION') AND
1339: x_rentable_area IS NOT NULL THEN
1340:
1341: IF NOT pnt_locations_pkg.validate_gross_area(x_parent_location_id,
1342: x_rentable_area,
1343: x_location_type_lookup_code,
1344: x_active_start_date,
1345: x_active_end_date) THEN

Line 1357: PNT_LOCATIONS_PKG.check_location_overlap (

1353:
1354: l_return_status := NULL;
1355:
1356: IF NVL(x_change_mode,'X') not in ('UPDATE') THEN
1357: PNT_LOCATIONS_PKG.check_location_overlap (
1358: p_org_id => x_org_id,
1359: p_location_id => NULL,
1360: p_location_code => x_location_code,
1361: p_location_type_lookup_code => x_location_type_lookup_code,

Line 1381: PNT_LOCATIONS_PKG.check_location_gaps (

1377:
1378: IF NOT (NVL(x_LOCATION_TYPE_LOOKUP_CODE, ' ') IN ('OFFICE', 'SECTION'))
1379: and NVL(x_change_mode,'X') not in ('UPDATE') THEN
1380:
1381: PNT_LOCATIONS_PKG.check_location_gaps (
1382: p_org_id => x_org_id,
1383: p_location_id => null,
1384: p_location_code => x_location_code,
1385: p_location_type_lookup_code => x_location_type_lookup_code,

Line 1633: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.insert_row (-) ReturnStatus: '||x_return_status);

1629: pnp_debug_pkg.debug(' InsRow> Other errors');
1630: pnp_debug_pkg.debug(sqlerrm);
1631: END;
1632:
1633: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.insert_row (-) ReturnStatus: '||x_return_status);
1634:
1635: END insert_row;
1636:
1637: -------------------------------------------------------------------------------

Line 1755: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.update_row (+) LocId: '||x_location_id||', Type: '||x_location_type_lookup_code

1751: l_return_status VARCHAR2(2000) := NULL;
1752:
1753: BEGIN
1754:
1755: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.update_row (+) LocId: '||x_location_id||', Type: '||x_location_type_lookup_code
1756: ||', ActStrDt: '||TO_CHAR(x_active_start_date, 'MM/DD/YYYY')
1757: ||', ActEndDt: '||TO_CHAR(x_active_end_date, 'MM/DD/YYYY'));
1758: x_return_status := FND_API.G_RET_STS_SUCCESS;
1759:

Line 1762: IF NOT pnt_locations_pkg.validate_gross_area(x_location_id,

1758: x_return_status := FND_API.G_RET_STS_SUCCESS;
1759:
1760: IF x_location_type_lookup_code IN ('OFFICE', 'SECTION') AND
1761: x_rentable_area IS NOT NULL THEN
1762: IF NOT pnt_locations_pkg.validate_gross_area(x_location_id,
1763: x_rentable_area,
1764: x_location_type_lookup_code,
1765: x_active_start_date,
1766: x_active_end_date,

Line 1907: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.update_row (-) ReturnStatus: '||x_return_status);

1903: x_addr_attribute15
1904: );
1905: END IF;
1906:
1907: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.update_row (-) ReturnStatus: '||x_return_status);
1908:
1909: EXCEPTION
1910: WHEN OTHERS THEN
1911: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2027: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.lock_row (+)');

2023: AND active_end_date = NVL(x_active_end_date_old, g_end_of_time)
2024: FOR UPDATE OF location_id NOWAIT;
2025:
2026: BEGIN
2027: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.lock_row (+)');
2028:
2029: pnp_debug_pkg.debug(' LockRow=> In Parameters :: LocId: '||x_location_id
2030: ||', Type: '||x_location_type_lookup_code);
2031: pnp_debug_pkg.debug(' LockRow=> ActStrDate : '||TO_CHAR(x_active_start_date, 'MM/DD/YYYY')

Line 2043: PNT_LOCATIONS_PKG.SET_ROWID(

2039: CLOSE C;
2040: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
2041: APP_EXCEPTION.Raise_Exception;
2042: ELSE
2043: PNT_LOCATIONS_PKG.SET_ROWID(
2044: p_location_id => x_location_id,
2045: p_active_start_date => x_active_start_date_old,
2046: p_active_end_date => x_active_end_date_old,
2047: x_return_status => l_return_status,

Line 2402: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.lock_row (-)');

2398: );
2399:
2400: END IF;
2401:
2402: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.lock_row (-)');
2403:
2404: END lock_row;
2405:
2406: -------------------------------------------------------------------------------

Line 2466: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.update_child_for_dates (+)');

2462: l_exists VARCHAR2(1) := 'N';
2463:
2464: BEGIN
2465:
2466: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.update_child_for_dates (+)');
2467: pnp_debug_pkg.debug(' UpdChiDt=> In Parameters :: p_location_id: '||p_location_id);
2468: pnp_debug_pkg.debug(' UpdChiDt=> p_active_start_date : '||TO_CHAR(p_active_start_date, 'MM/DD/YYYY')
2469: ||', p_active_end_date : '||TO_CHAR(p_active_end_date, 'MM/DD/YYYY'));
2470: pnp_debug_pkg.debug(' UpdChiDt=> p_active_start_date_old: '||TO_CHAR(p_active_start_date_old, 'MM/DD/YYYY')

Line 2563: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.update_child_for_dates (-) ReturnStatus: '||x_return_status);

2559:
2560: END IF;
2561:
2562: x_return_status := FND_API.G_RET_STS_SUCCESS;
2563: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.update_child_for_dates (-) ReturnStatus: '||x_return_status);
2564:
2565: EXCEPTION
2566: WHEN OTHERS THEN
2567: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2591: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.check_for_popup (+) LocId: '||p_pn_locations_rec.location_id

2587: x_return_message OUT NOCOPY VARCHAR2) IS
2588:
2589: BEGIN
2590:
2591: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.check_for_popup (+) LocId: '||p_pn_locations_rec.location_id
2592: ||', LocCd: '||p_pn_locations_rec.location_code
2593: ||', Type: '||p_pn_locations_rec.location_type_lookup_code);
2594: x_flag := 'N';
2595:

Line 2935: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.check_for_popup (-) Flag: '||x_flag||', ReturnStatus: '||x_return_status);

2931: END IF;
2932:
2933: END IF;
2934:
2935: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.check_for_popup (-) Flag: '||x_flag||', ReturnStatus: '||x_return_status);
2936:
2937: END check_for_popup;
2938:
2939: -------------------------------------------------------------------------------

Line 2982: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.update_assignments (+)');

2978: CONNECT BY PRIOR location_id = parent_location_id;
2979:
2980: BEGIN
2981:
2982: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.update_assignments (+)');
2983: pnp_debug_pkg.debug(' UpdAsgn=> In Parameters :: p_location_id: '||p_location_id);
2984: pnp_debug_pkg.debug(' UpdAsgn=> p_active_start_date : '||TO_CHAR(p_active_start_date, 'MM/DD/YYYY')
2985: ||', p_active_end_date : '||TO_CHAR(p_active_end_date, 'MM/DD/YYYY'));
2986: pnp_debug_pkg.debug(' UpdAsgn=> p_active_start_date_old: '||TO_CHAR(p_active_start_date_old, 'MM/DD/YYYY')

Line 3050: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.update_assignments (-) ReturnStatus: '||x_return_status);

3046:
3047: END LOOP;
3048:
3049: x_return_status := FND_API.G_RET_STS_SUCCESS;
3050: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.update_assignments (-) ReturnStatus: '||x_return_status);
3051:
3052: EXCEPTION
3053: WHEN OTHERS THEN
3054: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3093: l_act_end_dt DATE := NVL(p_act_end_dt, pnt_locations_pkg.g_end_of_time);

3089: l_min_gross_area NUMBER;
3090: l_loc_id NUMBER;
3091: l_sum_rent_area NUMBER;
3092: l_old_rent_area NUMBER;
3093: l_act_end_dt DATE := NVL(p_act_end_dt, pnt_locations_pkg.g_end_of_time);
3094: l_off_lkp_code VARCHAR2(30);
3095: l_return VARCHAR2(30);
3096:
3097: CURSOR get_min_gross_area IS

Line 3253: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.Check_Location_Gaps(+) LocId: '||p_loc_id||', Mode: '||p_asgn_mode

3249: ));
3250:
3251: BEGIN
3252:
3253: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.Check_Location_Gaps(+) LocId: '||p_loc_id||', Mode: '||p_asgn_mode
3254: ||', StrDt: '||TO_CHAR(p_str_dt, 'MM/DD/YYYY')||', EndDt: '||TO_CHAR(p_end_dt, 'MM/DD/YYYY'));
3255:
3256: loctn_tab.delete;
3257: l_rec_num := 0;

Line 3312: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.Check_Location_Gaps(-) ErrMsg: '||p_err_msg);

3308: END IF;
3309:
3310: p_err_msg := l_err_msg;
3311:
3312: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.Check_Location_Gaps(-) ErrMsg: '||p_err_msg);
3313:
3314: END Check_Location_Gaps;
3315:
3316:

Line 3346: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.Get_Location_Span(+) LocId: '||p_loc_id||', Mode: '||p_asgn_mode);

3342: (p_asgn_mode = 'CUST' AND NVL(assignable_cust, 'Y') = 'Y'));
3343:
3344: BEGIN
3345:
3346: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.Get_Location_Span(+) LocId: '||p_loc_id||', Mode: '||p_asgn_mode);
3347:
3348: OPEN get_loctn_span;
3349: FETCH get_loctn_span INTO p_min_str_dt, p_max_end_dt;
3350: CLOSE get_loctn_span;

Line 3352: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.Get_Location_Span(-) MinStrDt: '

3348: OPEN get_loctn_span;
3349: FETCH get_loctn_span INTO p_min_str_dt, p_max_end_dt;
3350: CLOSE get_loctn_span;
3351:
3352: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.Get_Location_Span(-) MinStrDt: '
3353: ||TO_CHAR(p_min_str_dt, 'MM/DD/YYYY')||', MaxEndDt: '||TO_CHAR(p_max_end_dt, 'MM/DD/YYYY'));
3354:
3355: END Get_Location_Span;
3356:

Line 3360: -- PURPOSE : This procedure calls pnt_locations_pkg.Update_Row for the

3356:
3357:
3358: -----------------------------------------------------------------------
3359: -- PROCEDURE : Update_Locn_Row
3360: -- PURPOSE : This procedure calls pnt_locations_pkg.Update_Row for the
3361: -- pn_locations_all%ROWTYPE passed to it. Called from
3362: -- Correct_Update_Row and Cascade_Child_Locn
3363: -- IN PARAM :
3364: -- History :

Line 3367: -- pnt_locations_pkg.Update_Row

3363: -- IN PARAM :
3364: -- History :
3365: -- 01-DEC-2004 Satish Tripathi o Created for Portfolio Status Enh BUG# 4030816.
3366: -- 02-AUG-2005 Satya Deep o Added X_SOURCE in the call to
3367: -- pnt_locations_pkg.Update_Row
3368: -----------------------------------------------------------------------
3369: PROCEDURE Update_Locn_Row (
3370: p_loc_recinfo IN pn_locations_all%ROWTYPE
3371: ,p_adr_recinfo IN pn_addresses_all%ROWTYPE

Line 3382: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.Update_Locn_Row (+) LocId: '||p_loc_recinfo.location_id

3378: l_location_id pn_locations_all.location_id%TYPE;
3379: l_address_id pn_locations_all.address_id%TYPE;
3380: BEGIN
3381:
3382: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.Update_Locn_Row (+) LocId: '||p_loc_recinfo.location_id
3383: ||', LocCd: '||p_loc_recinfo.location_code
3384: ||', Type: '||p_loc_recinfo.location_type_lookup_code);
3385: l_location_id := p_loc_recinfo.location_id;
3386: l_address_id := p_loc_recinfo.address_id;

Line 3389: pnt_locations_pkg.Set_ROWID(

3385: l_location_id := p_loc_recinfo.location_id;
3386: l_address_id := p_loc_recinfo.address_id;
3387:
3388: IF g_pn_locations_rowid IS NULL THEN
3389: pnt_locations_pkg.Set_ROWID(
3390: p_location_id => p_loc_recinfo.location_id
3391: ,p_active_start_date => p_loc_recinfo.active_start_date
3392: ,p_active_end_date => p_loc_recinfo.active_end_date
3393: ,x_return_status => x_return_status

Line 3400: pnt_locations_pkg.Update_Row

3396: END IF;
3397:
3398: IF NVL(x_return_status, 'S') = 'S' THEN
3399:
3400: pnt_locations_pkg.Update_Row
3401: (
3402: x_location_id => l_location_id
3403: ,x_last_update_date => SYSDATE
3404: ,x_last_updated_by => fnd_global.user_id

Line 3497: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.Update_Locn_Row (-) ReturnStatus: '||x_return_status);

3493: );
3494:
3495: END IF;
3496:
3497: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.Update_Locn_Row (-) ReturnStatus: '||x_return_status);
3498: END Update_Locn_Row;
3499:
3500:
3501: -----------------------------------------------------------------------

Line 3503: -- PURPOSE : This procedure calls pnt_locations_pkg.Insert_Row for the

3499:
3500:
3501: -----------------------------------------------------------------------
3502: -- PROCEDURE : Insert_Locn_Row
3503: -- PURPOSE : This procedure calls pnt_locations_pkg.Insert_Row for the
3504: -- pn_locations_all%ROWTYPE passed to it. Called from
3505: -- Correct_Update_Row and Cascade_Child_Locn
3506: -- IN PARAM :
3507: -- History :

Line 3510: -- pnt_locations_pkg.Insert_Row

3506: -- IN PARAM :
3507: -- History :
3508: -- 01-DEC-2004 Satish Tripathi o Created for Portfolio Status Enh BUG# 4030816.
3509: -- 02-AUG-2005 Satya Deep o Added X_SOURCE in the call to
3510: -- pnt_locations_pkg.Insert_Row
3511: -----------------------------------------------------------------------
3512: PROCEDURE Insert_Locn_Row (
3513: p_loc_recinfo IN pn_locations_all%ROWTYPE
3514: ,p_adr_recinfo IN pn_addresses_all%ROWTYPE

Line 3524: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.Insert_Locn_Row (+) LocId: '||p_loc_recinfo.location_id

3520: l_rowid ROWID;
3521: l_location_id pn_locations_all.location_id%TYPE;
3522: l_address_id pn_locations_all.address_id%TYPE;
3523: BEGIN
3524: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.Insert_Locn_Row (+) LocId: '||p_loc_recinfo.location_id
3525: ||', LocCd: '||p_loc_recinfo.location_code
3526: ||', Type: '||p_loc_recinfo.location_type_lookup_code);
3527:
3528: l_location_id := p_loc_recinfo.location_id;

Line 3531: pnt_locations_pkg.Insert_Row

3527:
3528: l_location_id := p_loc_recinfo.location_id;
3529: l_address_id := p_loc_recinfo.address_id;
3530:
3531: pnt_locations_pkg.Insert_Row
3532: (
3533: x_rowid => l_rowid
3534: ,x_last_update_date => SYSDATE
3535: ,x_last_updated_by => fnd_global.user_id

Line 3643: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.Insert_Locn_Row (-) ReturnStatus: '||x_return_status);

3639: x_return_status := FND_API.G_RET_STS_ERROR;
3640: APP_EXCEPTION.Raise_Exception;
3641: END IF;
3642:
3643: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.Insert_Locn_Row (-) ReturnStatus: '||x_return_status);
3644: END Insert_Locn_Row;
3645:
3646: /* --- CHANGED functions and procedures for MOAC START --- */
3647: /*============================================================================+

Line 3727: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.check_unique_location_code (+)');

3723: );
3724:
3725: BEGIN
3726:
3727: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.check_unique_location_code (+)');
3728:
3729: OPEN loc_code_cur;
3730: FETCH loc_code_cur INTO l_dummy;
3731: CLOSE loc_code_cur;

Line 3739: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.check_unique_location_code (-) ReturnStatus: '||x_return_status);

3735: fnd_message.set_token('LOCATION_CODE', x_location_code);
3736: x_return_status := 'E';
3737: END IF;
3738:
3739: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.check_unique_location_code (-) ReturnStatus: '||x_return_status);
3740: END check_unique_location_code;
3741:
3742:
3743: /*============================================================================+

Line 3778: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.check_unique_building (+)');

3774: );
3775:
3776: BEGIN
3777:
3778: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.check_unique_building (+)');
3779:
3780: OPEN building_cur;
3781: FETCH building_cur INTO l_dummy;
3782: CLOSE building_cur;

Line 3790: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.check_unique_building (-) ReturnStatus: '||x_return_status);

3786: fnd_message.set_token('BUILDING', x_building);
3787: x_return_status := 'E';
3788: END IF;
3789:
3790: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.check_unique_building (-) ReturnStatus: '||x_return_status);
3791: END check_unique_building;
3792:
3793:
3794: -------------------------------------------------------------------------------

Line 3882: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.check_unique_location_alias (+)');

3878: );
3879:
3880: BEGIN
3881:
3882: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.check_unique_location_alias (+)');
3883: pnp_debug_pkg.debug(' ChkUniAlis=> In Parameters :: LocAlias: '||x_location_alias||', LocId: '||x_location_id
3884: ||', Type: '||x_location_type_lookup_code);
3885: pnp_debug_pkg.debug(' ChkUniAlis=> ActStrDate : '||TO_CHAR(x_active_start_date, 'MM/DD/YYYY')
3886: ||', ActEndDate : '||TO_CHAR(x_active_end_date, 'MM/DD/YYYY'));

Line 3915: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.check_unique_location_alias (-) ReturnStatus: '||x_return_status);

3911: x_return_status := 'E';
3912: pnp_debug_pkg.debug(' ChkUniAlis> Error');
3913: END IF;
3914:
3915: pnp_debug_pkg.debug('PNT_LOCATIONS_PKG.check_unique_location_alias (-) ReturnStatus: '||x_return_status);
3916:
3917: END check_unique_location_alias;
3918:
3919: /* --- CHANGED functions and procedures for MOAC END --- */

Line 3924: END PNT_LOCATIONS_PKG ;

3920:
3921: ---------------------------------------------------------------------------------------
3922: -- End of Pkg
3923: ---------------------------------------------------------------------------------------
3924: END PNT_LOCATIONS_PKG ;