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 PNP_DEBUG_PKG

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 146: pnp_debug_pkg.debug(' ChkLocOlap=> In Parameters :: p_location_id: '||p_location_id||', LocCd: '||p_location_code

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'));
150: pnp_debug_pkg.debug(' ChkLocOlap=> p_active_start_date_old: '||TO_CHAR(p_active_start_date_old, 'MM/DD/YYYY')

Line 148: pnp_debug_pkg.debug(' ChkLocOlap=> p_active_start_date : '||TO_CHAR(p_active_start_date, 'MM/DD/YYYY')

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'));
150: pnp_debug_pkg.debug(' ChkLocOlap=> p_active_start_date_old: '||TO_CHAR(p_active_start_date_old, 'MM/DD/YYYY')
151: ||', p_active_end_date_old: '||TO_CHAR(p_active_end_date_old, 'MM/DD/YYYY'));
152:

Line 150: pnp_debug_pkg.debug(' ChkLocOlap=> p_active_start_date_old: '||TO_CHAR(p_active_start_date_old, 'MM/DD/YYYY')

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'));
150: pnp_debug_pkg.debug(' ChkLocOlap=> p_active_start_date_old: '||TO_CHAR(p_active_start_date_old, 'MM/DD/YYYY')
151: ||', p_active_end_date_old: '||TO_CHAR(p_active_end_date_old, 'MM/DD/YYYY'));
152:
153: IF p_location_id IS NULL THEN
154:

Line 162: pnp_debug_pkg.debug(' ChkLocOlap> MinStrDt: '||TO_CHAR(l_min_start_date, 'MM/DD/YYYY')

158: INTO l_min_start_date,
159: l_max_end_date;
160: CLOSE for_insert_cur;
161:
162: pnp_debug_pkg.debug(' ChkLocOlap> MinStrDt: '||TO_CHAR(l_min_start_date, 'MM/DD/YYYY')
163: ||', MaxEndDt: '||TO_CHAR(l_max_end_date, 'MM/DD/YYYY'));
164: -- Validate for start date
165: IF p_active_start_date IS NOT NULL THEN
166: IF p_active_start_date BETWEEN l_min_start_date AND l_max_end_date THEN

Line 196: pnp_debug_pkg.debug(' ChkLocOlap> Start date diff = '|| update_rec.start_date_diff);

192:
193: IF p_active_start_date IS NOT NULL THEN
194: FOR update_rec in for_update_st_cur(p_loc_id => p_location_id, p_str_dt => p_active_start_date, p_str_dt_old => p_active_start_date_old)
195: LOOP
196: pnp_debug_pkg.debug(' ChkLocOlap> Start date diff = '|| update_rec.start_date_diff);
197: IF update_rec.start_date_diff < 1 then
198: x_return_status := FND_API.G_RET_STS_ERROR;
199: fnd_message.set_name('PN','PN_INVALID_EFFECTIVE_DATES');
200: return;

Line 208: pnp_debug_pkg.debug(' ChkLocOlap> End date diff = '|| update_rec.end_date_diff);

204:
205: IF p_active_end_date IS NOT NULL THEN
206: FOR update_rec in for_update_end_cur(p_loc_id => p_location_id, p_end_dt => p_active_end_date, p_end_dt_old => p_active_end_date_old)
207: LOOP
208: pnp_debug_pkg.debug(' ChkLocOlap> End date diff = '|| update_rec.end_date_diff);
209: IF update_rec.end_date_diff > -1 then
210: x_return_status := FND_API.G_RET_STS_ERROR;
211: fnd_message.set_name('PN','PN_INVALID_EFFECTIVE_DATES');
212: return;

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 252: pnp_debug_pkg.debug(' ChkLocGap=> In Parameters :: p_location_id: '||p_location_id

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'));
256: pnp_debug_pkg.debug(' ChkLocGap=> p_active_start_date_old: '||TO_CHAR(p_active_start_date_old, 'MM/DD/YYYY')

Line 254: pnp_debug_pkg.debug(' ChkLocGap=> p_active_start_date : '||TO_CHAR(p_active_start_date, 'MM/DD/YYYY')

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'));
256: pnp_debug_pkg.debug(' ChkLocGap=> p_active_start_date_old: '||TO_CHAR(p_active_start_date_old, 'MM/DD/YYYY')
257: ||', p_active_end_date_old: '||TO_CHAR(p_active_end_date_old, 'MM/DD/YYYY'));
258:

Line 256: pnp_debug_pkg.debug(' ChkLocGap=> p_active_start_date_old: '||TO_CHAR(p_active_start_date_old, 'MM/DD/YYYY')

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'));
256: pnp_debug_pkg.debug(' ChkLocGap=> p_active_start_date_old: '||TO_CHAR(p_active_start_date_old, 'MM/DD/YYYY')
257: ||', p_active_end_date_old: '||TO_CHAR(p_active_end_date_old, 'MM/DD/YYYY'));
258:
259: IF p_location_id IS NULL THEN
260: -- Check for gaps during create record

Line 271: pnp_debug_pkg.debug(' ChkLocGap> MinStrDt: '||TO_CHAR(l_min_start_date, 'MM/DD/YYYY')

267:
268: l_min_start_date := l_min_start_date - 1;
269: l_max_end_date := l_max_end_date + 1;
270:
271: pnp_debug_pkg.debug(' ChkLocGap> MinStrDt: '||TO_CHAR(l_min_start_date, 'MM/DD/YYYY')
272: ||', MaxEndDt: '||TO_CHAR(l_max_end_date, 'MM/DD/YYYY'));
273: IF p_active_start_date IS NOT NULL THEN
274: IF NOT ((p_active_start_date <= l_min_start_date AND
275: NVL(p_active_end_date, TO_DATE('12/31/4712','MM/DD/YYYY')) = l_min_start_date) OR

Line 278: pnp_debug_pkg.debug(' ChkLocGap> StrDtMaxEndDt');

274: IF NOT ((p_active_start_date <= l_min_start_date AND
275: NVL(p_active_end_date, TO_DATE('12/31/4712','MM/DD/YYYY')) = l_min_start_date) OR
276: (p_active_start_date >= l_max_end_date and p_active_start_date = l_max_end_date))
277: THEN
278: pnp_debug_pkg.debug(' ChkLocGap> StrDtMaxEndDt');
279: x_return_status := FND_API.G_RET_STS_ERROR;
280: fnd_message.set_name('PN','PN_LOC_GAPS_MSG');
281: fnd_message.set_token('GAP_START_DATE',l_max_end_date);
282: fnd_message.set_token('GAP_END_DATE',p_active_start_date - 1);

Line 287: pnp_debug_pkg.debug(' ChkLocGap> EndDt

283: RETURN;
284: END IF;
285: ELSIF p_active_end_date IS NOT NULL THEN
286: IF p_active_end_date < l_min_start_date THEN
287: pnp_debug_pkg.debug(' ChkLocGap> EndDt 288: x_return_status := FND_API.G_RET_STS_ERROR;
289: fnd_message.set_name('PN','PN_LOC_GAPS_MSG');
290: fnd_message.set_token('GAP_START_DATE',p_active_end_date + 1);
291: fnd_message.set_token('GAP_END_DATE',l_min_start_date);

Line 303: pnp_debug_pkg.debug(' ChkLocGap> Start date diff = '|| update_rec.start_date_diff);

299:
300: IF p_active_start_date IS NOT NULL THEN
301: FOR update_rec in for_update_st_cur(p_loc_id => p_location_id, p_str_dt => p_active_start_date, p_str_dt_old => p_active_start_date_old)
302: LOOP
303: pnp_debug_pkg.debug(' ChkLocGap> Start date diff = '|| update_rec.start_date_diff);
304: IF update_rec.start_date_diff <> 1 THEN
305: pnp_debug_pkg.debug(' ChkLocGap> StrDt not Null, Diff <> 1');
306: x_return_status := FND_API.G_RET_STS_ERROR;
307: fnd_message.set_name('PN','PN_LOC_GAPS_MSG');

Line 305: pnp_debug_pkg.debug(' ChkLocGap> StrDt not Null, Diff <> 1');

301: FOR update_rec in for_update_st_cur(p_loc_id => p_location_id, p_str_dt => p_active_start_date, p_str_dt_old => p_active_start_date_old)
302: LOOP
303: pnp_debug_pkg.debug(' ChkLocGap> Start date diff = '|| update_rec.start_date_diff);
304: IF update_rec.start_date_diff <> 1 THEN
305: pnp_debug_pkg.debug(' ChkLocGap> StrDt not Null, Diff <> 1');
306: x_return_status := FND_API.G_RET_STS_ERROR;
307: fnd_message.set_name('PN','PN_LOC_GAPS_MSG');
308: fnd_message.set_token('GAP_START_DATE',p_active_start_date_old);
309: fnd_message.set_token('GAP_END_DATE',p_active_start_date - 1);

Line 318: pnp_debug_pkg.debug(' ChkLocGap> End date diff = '|| update_rec.end_date_diff);

314:
315: IF p_active_end_date IS NOT NULL THEN
316: FOR update_rec in for_update_end_cur(p_loc_id => p_location_id, p_end_dt => p_active_end_date, p_end_dt_old => p_active_end_date_old)
317: LOOP
318: pnp_debug_pkg.debug(' ChkLocGap> End date diff = '|| update_rec.end_date_diff);
319: IF update_rec.end_date_diff <> -1 then
320: pnp_debug_pkg.debug(' ChkLocGap> EndDt not Null, Diff <> 1');
321: x_return_status := FND_API.G_RET_STS_ERROR;
322: fnd_message.set_name('PN','PN_LOC_GAPS_MSG');

Line 320: pnp_debug_pkg.debug(' ChkLocGap> EndDt not Null, Diff <> 1');

316: FOR update_rec in for_update_end_cur(p_loc_id => p_location_id, p_end_dt => p_active_end_date, p_end_dt_old => p_active_end_date_old)
317: LOOP
318: pnp_debug_pkg.debug(' ChkLocGap> End date diff = '|| update_rec.end_date_diff);
319: IF update_rec.end_date_diff <> -1 then
320: pnp_debug_pkg.debug(' ChkLocGap> EndDt not Null, Diff <> 1');
321: x_return_status := FND_API.G_RET_STS_ERROR;
322: fnd_message.set_name('PN','PN_LOC_GAPS_MSG');
323: fnd_message.set_token('GAP_START_DATE',p_active_end_date + 1);
324: fnd_message.set_token('GAP_END_DATE',p_active_end_date_old);

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 356: pnp_debug_pkg.debug(' PntLocnPkg.SetRowid (+) LocId: '||p_location_id

352: l_rowid ROWID;
353:
354: BEGIN
355:
356: pnp_debug_pkg.debug(' PntLocnPkg.SetRowid (+) LocId: '||p_location_id
357: ||', ActStrDt: '||TO_CHAR(p_active_start_date, 'MM/DD/YYYY')
358: ||', ActEndDt: '||TO_CHAR(p_active_end_date, 'MM/DD/YYYY'));
359:
360: -- Location ID, Active Start Date, Active End Date are the old values retrived by the query

Line 373: pnp_debug_pkg.debug(' PntLocnPkg.SetRowid (-) ReturnStatus: '||x_return_status);

369: g_pn_locations_rowid := l_rowid;
370:
371: x_return_status := FND_API.G_RET_STS_SUCCESS;
372:
373: pnp_debug_pkg.debug(' PntLocnPkg.SetRowid (-) ReturnStatus: '||x_return_status);
374:
375: EXCEPTION
376: WHEN NO_DATA_FOUND THEN
377: x_return_status := FND_API.G_RET_STS_ERROR;

Line 421: pnp_debug_pkg.debug(' Set_Cascade (+) '||p_cascade

417: AND active_end_date >= g_loc_recinfo_tmp.active_start_date;
418:
419: BEGIN
420:
421: pnp_debug_pkg.debug(' Set_Cascade (+) '||p_cascade
422: ||', Occ/Asgn:|'||g_loc_recinfo_tmp.Occupancy_status_code
423: ||'|'||g_loc_recinfo_tmp.Assignable_emp
424: ||'|'||g_loc_recinfo_tmp.Assignable_cc
425: ||'|'||g_loc_recinfo_tmp.Assignable_cust

Line 470: pnp_debug_pkg.debug(' Set_Cascade (-) '||p_cascade

466: g_loc_recinfo_tmp.assignable_cust := l_cascade_cust;
467: END IF;
468: END IF;
469:
470: pnp_debug_pkg.debug(' Set_Cascade (-) '||p_cascade
471: ||', Occ/Asgn:|'||g_loc_recinfo_tmp.Occupancy_status_code
472: ||'|'||g_loc_recinfo_tmp.Assignable_emp
473: ||'|'||g_loc_recinfo_tmp.Assignable_cc
474: ||'|'||g_loc_recinfo_tmp.Assignable_cust

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 554: pnp_debug_pkg.debug(' CorUpdRow=> LocId: '||p_pn_locations_rec.location_id||', LocCd: '||p_pn_locations_rec.location_code

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')
557: ||', EndDt: '||TO_CHAR(p_pn_locations_rec.active_end_date, 'MM/DD/YYYY'));
558:

Line 569: pnp_debug_pkg.put_log_msg('Calling validate_assignable_area');

565: x_return_status => x_return_status,
566: x_return_message => x_return_message);
567:
568: IF ( p_validate) THEN
569: pnp_debug_pkg.put_log_msg('Calling validate_assignable_area');
570:
571: IF p_change_mode = 'CORRECT' THEN
572: l_str_dt := p_pn_locations_rec.active_start_date;
573: l_end_dt := p_pn_locations_rec.active_end_date;

Line 666: pnp_debug_pkg.put_log_msg('Calling check_location_overlap');

662: -- Call 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,

Line 680: pnp_debug_pkg.debug(' CorUpdRow> Error in check_location_overlap');

676: x_return_status => x_return_status,
677: x_return_message => x_return_message);
678:
679: IF NOT ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
680: pnp_debug_pkg.debug(' CorUpdRow> Error in check_location_overlap');
681: pnp_debug_pkg.put_log_msg(' CorUpdRow> Error :Calling check_location_overlap');
682: x_return_status := FND_API.G_RET_STS_ERROR;
683: APP_EXCEPTION.Raise_Exception;
684: END IF;

Line 681: pnp_debug_pkg.put_log_msg(' CorUpdRow> Error :Calling check_location_overlap');

677: x_return_message => x_return_message);
678:
679: IF NOT ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
680: pnp_debug_pkg.debug(' CorUpdRow> Error in check_location_overlap');
681: pnp_debug_pkg.put_log_msg(' CorUpdRow> Error :Calling check_location_overlap');
682: x_return_status := FND_API.G_RET_STS_ERROR;
683: APP_EXCEPTION.Raise_Exception;
684: END IF;
685:

Line 687: pnp_debug_pkg.put_log_msg('Calling check_location_gaps');

683: APP_EXCEPTION.Raise_Exception;
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,

Line 701: pnp_debug_pkg.put_log_msg('Error Calling check_location_gaps');

697: x_return_status => x_return_status,
698: x_return_message => x_return_message);
699:
700: IF NOT ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
701: pnp_debug_pkg.put_log_msg('Error Calling check_location_gaps');
702: x_return_status := FND_API.G_RET_STS_ERROR;
703: APP_EXCEPTION.Raise_Exception;
704: END IF;
705:

Line 710: PNP_DEBUG_PKG.put_log_msg('call update row ');

706: END IF;
707:
708: END IF; -- endif for p_validate
709:
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);

Line 776: pnp_debug_pkg.put_log_msg('Calling UPDATE ROW.');

772: x_return_status := FND_API.G_RET_STS_ERROR;
773: APP_EXCEPTION.Raise_Exception;
774: END IF;
775:
776: pnp_debug_pkg.put_log_msg('Calling UPDATE ROW.');
777:
778: pnp_debug_pkg.put_log_msg('Calling INSERT ROW address = ' || G_LOC_RECINFO.ADDRESS_ID);
779:
780: g_loc_recinfo_tmp := g_loc_recinfo;

Line 778: pnp_debug_pkg.put_log_msg('Calling INSERT ROW address = ' || G_LOC_RECINFO.ADDRESS_ID);

774: END IF;
775:
776: pnp_debug_pkg.put_log_msg('Calling UPDATE ROW.');
777:
778: pnp_debug_pkg.put_log_msg('Calling INSERT ROW address = ' || G_LOC_RECINFO.ADDRESS_ID);
779:
780: g_loc_recinfo_tmp := g_loc_recinfo;
781: g_loc_adrinfo_tmp := p_pn_addresses_rec;
782: --Bug#6755579 g_loc_recinfo_tmp.common_area_flag := NULL;

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 871: pnp_debug_pkg.debug(' CacCldLoc=> In Parameters :: p_location_id: '||p_location_id||', Cascade: '||p_cascade

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'));
875:

Line 873: pnp_debug_pkg.debug(' CacCldLoc=> StrDt: '||TO_CHAR(p_start_date, 'MM/DD/YYYY')

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'));
875:
876: FOR locn_rec IN location_cursor
877: LOOP

Line 909: pnp_debug_pkg.debug(' CacCldLoc> Row#: '||location_cursor%ROWCOUNT||', LocId: '||locn_rec.location_id

905: l_split := 'Y';
906: END IF;
907: END IF;
908:
909: pnp_debug_pkg.debug(' CacCldLoc> Row#: '||location_cursor%ROWCOUNT||', LocId: '||locn_rec.location_id
910: ||', LocCd: '||locn_rec.location_code
911: ||', Type: '||locn_rec.location_type_lookup_code
912: ||', Split: '||l_split);
913: pnp_debug_pkg.debug(' CacCldLoc> ActStrDate : '||TO_CHAR(locn_rec.active_start_date, 'MM/DD/YYYY')

Line 913: pnp_debug_pkg.debug(' CacCldLoc> ActStrDate : '||TO_CHAR(locn_rec.active_start_date, 'MM/DD/YYYY')

909: pnp_debug_pkg.debug(' CacCldLoc> Row#: '||location_cursor%ROWCOUNT||', LocId: '||locn_rec.location_id
910: ||', LocCd: '||locn_rec.location_code
911: ||', Type: '||locn_rec.location_type_lookup_code
912: ||', Split: '||l_split);
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,

Line 923: pnp_debug_pkg.debug(' CacCldLoc> ... Case# 1: ActStrDt < pStrDt AND ActEndDt > pEndDt');

919:
920: IF locn_rec.active_start_date < p_start_date AND
921: locn_rec.active_end_date > p_end_date THEN
922:
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);

Line 948: pnp_debug_pkg.debug(' CacCldLoc> ... Case# 2: ActStrDt < pStrDt');

944: END IF;
945:
946: ELSIF locn_rec.active_start_date < p_start_date THEN
947:
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);

Line 965: pnp_debug_pkg.debug(' CacCldLoc> ... Case# 3: ActEndDt > pEndDt');

961: END IF;
962:
963: ELSIF locn_rec.active_end_date > p_end_date THEN
964:
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);

Line 982: pnp_debug_pkg.debug(' CacCldLoc> ... Case# 4: ActStrDt >= pStrDt AND ActEndDt <= pEndDt');

978: END IF;
979:
980: ELSE
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);

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 1317: pnp_debug_pkg.put_log_msg('Error in unique_location_alias');

1313: x_active_start_date,
1314: x_active_end_date,
1315: x_org_id);
1316: IF (l_return_status IS NOT NULL) THEN
1317: pnp_debug_pkg.put_log_msg('Error in unique_location_alias');
1318: APP_EXCEPTION.Raise_Exception;
1319: END IF;
1320:
1321: -----------------------------------------------------------------

Line 1334: pnp_debug_pkg.put_log_msg('Error in unique_location_code');

1330: ,x_active_start_date
1331: ,x_active_end_date
1332: ,x_org_id);
1333: IF (l_return_status IS NOT NULL) THEN
1334: pnp_debug_pkg.put_log_msg('Error in unique_location_code');
1335: APP_EXCEPTION.Raise_Exception;
1336: END IF;
1337:
1338: IF x_location_type_lookup_code IN ('OFFICE', 'SECTION') AND

Line 1370: pnp_debug_pkg.debug(' InsRow> Error in check_location_overlap ');

1366: x_return_status => l_return_status,
1367: x_return_message => l_return_message);
1368:
1369: IF NOT ( l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1370: pnp_debug_pkg.debug(' InsRow> Error in check_location_overlap ');
1371: APP_EXCEPTION.Raise_Exception;
1372: END IF;
1373:
1374: END IF; -- x_change_mode

Line 1406: pnp_debug_pkg.put_log_msg('Calling address insert address =' || x_address_id);

1402: -- PN_LOCATIONS table. This will only be called when we insert the
1403: -- building record.
1404: -----------------------------------------------------------------
1405:
1406: pnp_debug_pkg.put_log_msg('Calling address insert address =' || x_address_id);
1407: IF (NVL(x_LOCATION_TYPE_LOOKUP_CODE, ' ') IN ('BUILDING','LAND'))
1408: AND x_address_id is null THEN
1409: PNT_ADDR_PKG.insert_row (
1410: x_address_id,

Line 1473: pnp_debug_pkg.debug(' InsRow> before insert' || x_change_mode);

1469: INTO x_location_id
1470: FROM DUAL;
1471: END IF;
1472:
1473: pnp_debug_pkg.debug(' InsRow> before insert' || x_change_mode);
1474: BEGIN
1475: INSERT INTO pn_locations_all (
1476: LOCATION_ID
1477: ,LAST_UPDATE_DATE

Line 1619: pnp_debug_pkg.debug(' InsRow> Error in insert');

1615: OPEN C;
1616: FETCH C INTO x_rowid;
1617: IF (C%NOTFOUND) THEN
1618: CLOSE C;
1619: pnp_debug_pkg.debug(' InsRow> Error in insert');
1620: RAISE NO_DATA_FOUND;
1621: END IF;
1622: CLOSE C;
1623:

Line 1629: pnp_debug_pkg.debug(' InsRow> Other errors');

1625: WHEN OTHERS THEN
1626: x_return_status := FND_API.G_RET_STS_ERROR;
1627: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
1628: fnd_message.set_token('ERR_MSG',sqlerrm);
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);

Line 1630: pnp_debug_pkg.debug(sqlerrm);

1626: x_return_status := FND_API.G_RET_STS_ERROR;
1627: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
1628: fnd_message.set_token('ERR_MSG',sqlerrm);
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:

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 1783: pnp_debug_pkg.put_log_msg('update locations');

1779: ,p_end_dt => x_active_end_date
1780: );
1781: END IF;
1782:
1783: pnp_debug_pkg.put_log_msg('update locations');
1784:
1785: UPDATE PN_LOCATIONS_ALL
1786: SET
1787: LAST_UPDATE_DATE = x_LAST_UPDATE_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 1914: pnp_debug_pkg.put_log_msg('OTHER ERRORS'|| sqlerrm);

1910: WHEN OTHERS THEN
1911: x_return_status := FND_API.G_RET_STS_ERROR;
1912: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
1913: fnd_message.set_token('ERR_MSG',sqlerrm);
1914: pnp_debug_pkg.put_log_msg('OTHER ERRORS'|| sqlerrm);
1915: END UPDATE_ROW;
1916:
1917: ------------------------------------------------------------------------
1918: -- PROCEDURE : lock_row

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 2029: pnp_debug_pkg.debug(' LockRow=> In Parameters :: LocId: '||x_location_id

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')
2032: ||', ActEndDate : '||TO_CHAR(x_active_end_date, 'MM/DD/YYYY'));
2033: pnp_debug_pkg.debug(' LockRow=> ActStrDateOld: '||TO_CHAR(x_active_start_date_old, 'MM/DD/YYYY')

Line 2031: pnp_debug_pkg.debug(' LockRow=> ActStrDate : '||TO_CHAR(x_active_start_date, 'MM/DD/YYYY')

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')
2032: ||', ActEndDate : '||TO_CHAR(x_active_end_date, 'MM/DD/YYYY'));
2033: pnp_debug_pkg.debug(' LockRow=> ActStrDateOld: '||TO_CHAR(x_active_start_date_old, 'MM/DD/YYYY')
2034: ||', ActEndDateOld: '||TO_CHAR(x_active_end_date_old, 'MM/DD/YYYY'));
2035:

Line 2033: pnp_debug_pkg.debug(' LockRow=> ActStrDateOld: '||TO_CHAR(x_active_start_date_old, 'MM/DD/YYYY')

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')
2032: ||', ActEndDate : '||TO_CHAR(x_active_end_date, 'MM/DD/YYYY'));
2033: pnp_debug_pkg.debug(' LockRow=> ActStrDateOld: '||TO_CHAR(x_active_start_date_old, 'MM/DD/YYYY')
2034: ||', ActEndDateOld: '||TO_CHAR(x_active_end_date_old, 'MM/DD/YYYY'));
2035:
2036: OPEN C;
2037: FETCH C INTO G_LOC_RECINFO;

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 2467: pnp_debug_pkg.debug(' UpdChiDt=> In Parameters :: p_location_id: '||p_location_id);

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')
2471: ||', p_active_end_date_old: '||TO_CHAR(p_active_end_date_old, 'MM/DD/YYYY'));

Line 2468: pnp_debug_pkg.debug(' UpdChiDt=> p_active_start_date : '||TO_CHAR(p_active_start_date, 'MM/DD/YYYY')

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')
2471: ||', p_active_end_date_old: '||TO_CHAR(p_active_end_date_old, 'MM/DD/YYYY'));
2472:

Line 2470: pnp_debug_pkg.debug(' UpdChiDt=> p_active_start_date_old: '||TO_CHAR(p_active_start_date_old, 'MM/DD/YYYY')

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')
2471: ||', p_active_end_date_old: '||TO_CHAR(p_active_end_date_old, 'MM/DD/YYYY'));
2472:
2473: IF p_active_end_date < p_active_end_date_old AND
2474: p_location_type_lookup_code NOT IN ('OFFICE','SECTION')THEN

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 2983: pnp_debug_pkg.debug(' UpdAsgn=> In Parameters :: p_location_id: '||p_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')
2987: ||', p_active_end_date_old: '||TO_CHAR(p_active_end_date_old, 'MM/DD/YYYY'));

Line 2984: pnp_debug_pkg.debug(' UpdAsgn=> p_active_start_date : '||TO_CHAR(p_active_start_date, 'MM/DD/YYYY')

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')
2987: ||', p_active_end_date_old: '||TO_CHAR(p_active_end_date_old, 'MM/DD/YYYY'));
2988:

Line 2986: pnp_debug_pkg.debug(' UpdAsgn=> p_active_start_date_old: '||TO_CHAR(p_active_start_date_old, 'MM/DD/YYYY')

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')
2987: ||', p_active_end_date_old: '||TO_CHAR(p_active_end_date_old, 'MM/DD/YYYY'));
2988:
2989: FOR l_location_rec in location_cursor LOOP
2990:

Line 2991: pnp_debug_pkg.debug(' UpdAsgn> Row#: '||location_cursor%ROWCOUNT||', Inside FOR loop LocId: '||l_location_rec.location_id||', LocCd: '||l_location_rec.location_code);

2987: ||', p_active_end_date_old: '||TO_CHAR(p_active_end_date_old, 'MM/DD/YYYY'));
2988:
2989: FOR l_location_rec in location_cursor LOOP
2990:
2991: pnp_debug_pkg.debug(' UpdAsgn> Row#: '||location_cursor%ROWCOUNT||', Inside FOR loop LocId: '||l_location_rec.location_id||', LocCd: '||l_location_rec.location_code);
2992:
2993: IF l_location_rec.active_end_date > p_active_end_date
2994: and p_active_end_date <> p_active_end_date_old THEN
2995:

Line 2996: pnp_debug_pkg.debug(' UpdAsgn> Inside end date updation');

2992:
2993: IF l_location_rec.active_end_date > p_active_end_date
2994: and p_active_end_date <> p_active_end_date_old THEN
2995:
2996: pnp_debug_pkg.debug(' UpdAsgn> Inside end date updation');
2997:
2998: DELETE FROM pn_space_assign_emp_all
2999: WHERE location_id = l_location_rec.location_id
3000: AND emp_assign_start_date > p_active_end_date

Line 3023: pnp_debug_pkg.debug(' UpdAsgn> Inside start date updation');

3019:
3020: IF l_location_rec.active_start_date < p_active_start_date
3021: and p_active_start_date <> p_active_start_date_old THEN
3022:
3023: pnp_debug_pkg.debug(' UpdAsgn> Inside start date updation');
3024:
3025: DELETE FROM pn_space_assign_emp_all
3026: WHERE location_id = l_location_rec.location_id
3027: AND emp_assign_end_date < p_active_start_date

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 3057: pnp_debug_pkg.log('Other error update_assignments' || sqlerrm);

3053: WHEN OTHERS THEN
3054: x_return_status := FND_API.G_RET_STS_ERROR;
3055: fnd_message.set_name ('PN','PN_OTHERS_EXCEPTION');
3056: fnd_message.set_token('ERR_MSG',sqlerrm);
3057: pnp_debug_pkg.log('Other error update_assignments' || sqlerrm);
3058:
3059: END update_assignments;
3060:
3061: -----------------------------------------------------------------------

Line 3117: pnp_debug_pkg.debug(' PntLocnPkg.Validate_Gross_Area (+) LocId: '||p_loc_id||', Area: '||p_area

3113: AND active_start_date <= NVL(p_act_end_dt, TO_DATE('12/31/4712','MM/DD/YYYY'))
3114: AND active_end_date >= p_act_str_dt;
3115: BEGIN
3116:
3117: pnp_debug_pkg.debug(' PntLocnPkg.Validate_Gross_Area (+) LocId: '||p_loc_id||', Area: '||p_area
3118: ||', ActStrDt: '||TO_CHAR(p_act_str_dt, 'MM/DD/YYYY')
3119: ||', ActEndDt: '||TO_CHAR(p_act_end_dt, 'MM/DD/YYYY'));
3120: IF p_lkp_code in ('OFFICE', 'SECTION') THEN
3121:

Line 3169: pnp_debug_pkg.debug(' PntLocnPkg.Validate_Gross_Area (+) LocId: '||p_loc_id||', Return: '||l_return);

3165: END IF;
3166:
3167: END IF;
3168:
3169: pnp_debug_pkg.debug(' PntLocnPkg.Validate_Gross_Area (+) LocId: '||p_loc_id||', Return: '||l_return);
3170:
3171: IF l_return = 'Y' THEN
3172: RETURN TRUE;
3173: ELSE

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 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 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 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 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 3883: pnp_debug_pkg.debug(' ChkUniAlis=> In Parameters :: LocAlias: '||x_location_alias||', LocId: '||x_location_id

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'));
3887:

Line 3885: pnp_debug_pkg.debug(' ChkUniAlis=> ActStrDate : '||TO_CHAR(x_active_start_date, 'MM/DD/YYYY')

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'));
3887:
3888: -- If the location alias is null then we don't need to check
3889: -- This will happen only for data created by the external system.

Line 3898: pnp_debug_pkg.debug(' ChkUniAlis> Duplicate');

3894:
3895: IF x_location_type_lookup_code IN ('BUILDING', 'LAND', 'FLOOR', 'PARCEL', 'OFFICE', 'SECTION') THEN
3896: l_set_name := 'PN_DUP_'||x_location_type_lookup_code||'_ALIAS';
3897: l_set_token := x_location_type_lookup_code||'_ALIAS';
3898: pnp_debug_pkg.debug(' ChkUniAlis> Duplicate');
3899: ELSE
3900: -- we should never reach this place
3901: x_return_status := 'E';
3902: END IF;

Line 3912: pnp_debug_pkg.debug(' ChkUniAlis> Error');

3908: IF l_dummy = 1 THEN
3909: fnd_message.set_name ('PN',l_set_name);
3910: fnd_message.set_token(l_set_token, x_location_alias);
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:

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 --- */