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 FND_API

Line 167: x_return_status := FND_API.G_RET_STS_ERROR;

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
167: x_return_status := FND_API.G_RET_STS_ERROR;
168: fnd_message.set_name('PN','PN_INVALID_EFFECTIVE_DATES');
169: return;
170: END IF;
171: END IF;

Line 176: x_return_status := FND_API.G_RET_STS_ERROR;

172:
173: -- Validate for start date
174: IF p_active_end_date IS NULL THEN
175: IF p_active_start_date BETWEEN l_min_start_date AND l_max_end_date THEN
176: x_return_status := FND_API.G_RET_STS_ERROR;
177: fnd_message.set_name('PN','PN_INVALID_EFFECTIVE_DATES');
178: return;
179: END IF;
180:

Line 185: x_return_status := FND_API.G_RET_STS_ERROR;

181: -- Validate for end date
182: ELSE
183: IF (p_active_end_date BETWEEN l_min_start_date AND l_max_end_date)
184: OR (p_active_end_date = g_end_of_time and p_active_start_date < l_min_start_date) THEN
185: x_return_status := FND_API.G_RET_STS_ERROR;
186: fnd_message.set_name('PN','PN_INVALID_EFFECTIVE_DATES');
187: return;
188: END IF;
189: END IF;

Line 198: x_return_status := FND_API.G_RET_STS_ERROR;

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;
201: END IF;
202: END LOOP;

Line 210: x_return_status := FND_API.G_RET_STS_ERROR;

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;
213: END IF;
214: END LOOP;

Line 279: x_return_status := FND_API.G_RET_STS_ERROR;

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);
283: RETURN;

Line 288: x_return_status := FND_API.G_RET_STS_ERROR;

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);
292: RETURN;

Line 306: x_return_status := FND_API.G_RET_STS_ERROR;

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);
310: RETURN;

Line 321: x_return_status := FND_API.G_RET_STS_ERROR;

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);
325: RETURN;

Line 371: x_return_status := FND_API.G_RET_STS_SUCCESS;

367: AND active_end_date = NVL(p_active_end_date,g_end_of_time);
368:
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

Line 377: x_return_status := FND_API.G_RET_STS_ERROR;

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;
378:
379: WHEN TOO_MANY_ROWS THEN
380: x_return_status := FND_API.G_RET_STS_ERROR;
381:

Line 380: x_return_status := FND_API.G_RET_STS_ERROR;

376: WHEN NO_DATA_FOUND THEN
377: x_return_status := FND_API.G_RET_STS_ERROR;
378:
379: WHEN TOO_MANY_ROWS THEN
380: x_return_status := FND_API.G_RET_STS_ERROR;
381:
382: WHEN OTHERS THEN
383: x_return_status := FND_API.G_RET_STS_ERROR;
384:

Line 383: x_return_status := FND_API.G_RET_STS_ERROR;

379: WHEN TOO_MANY_ROWS THEN
380: x_return_status := FND_API.G_RET_STS_ERROR;
381:
382: WHEN OTHERS THEN
383: x_return_status := FND_API.G_RET_STS_ERROR;
384:
385: END SET_ROWID;
386:
387: -------------------------------------------------------------------------------

Line 559: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 592: IF not(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

588: x_return_status => x_return_status,
589: x_return_message => x_return_message
590: );
591:
592: IF not(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
593: x_return_status := FND_API.G_RET_STS_ERROR;
594: APP_EXCEPTION.Raise_Exception;
595: END IF;
596:

Line 593: x_return_status := FND_API.G_RET_STS_ERROR;

589: x_return_message => x_return_message
590: );
591:
592: IF not(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
593: x_return_status := FND_API.G_RET_STS_ERROR;
594: APP_EXCEPTION.Raise_Exception;
595: END IF;
596:
597: -- Added redwin Fix for Bug 2722698

Line 608: IF NOT ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

604: p_active_end_date_old => p_active_end_date_old,
605: x_return_status => x_return_status,
606: x_return_message => x_return_message);
607:
608: IF NOT ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
609: x_return_status := FND_API.G_RET_STS_ERROR;
610: APP_EXCEPTION.Raise_Exception;
611: END IF;
612:

Line 609: x_return_status := FND_API.G_RET_STS_ERROR;

605: x_return_status => x_return_status,
606: x_return_message => x_return_message);
607:
608: IF NOT ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
609: x_return_status := FND_API.G_RET_STS_ERROR;
610: APP_EXCEPTION.Raise_Exception;
611: END IF;
612:
613: END IF; -- if p_validate

Line 649: IF NOT ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

645: p_location_type_lookup_code => p_pn_locations_rec.location_type_lookup_code,
646: x_return_status => x_return_status,
647: x_return_message => x_return_message);
648:
649: IF NOT ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
650: x_return_status := FND_API.G_RET_STS_ERROR;
651: APP_EXCEPTION.Raise_Exception;
652: END IF;
653:

Line 650: x_return_status := FND_API.G_RET_STS_ERROR;

646: x_return_status => x_return_status,
647: x_return_message => x_return_message);
648:
649: IF NOT ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
650: x_return_status := FND_API.G_RET_STS_ERROR;
651: APP_EXCEPTION.Raise_Exception;
652: END IF;
653:
654: END IF;

Line 679: IF NOT ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

675: p_active_end_date_old => p_active_end_date_old,
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;

Line 682: x_return_status := FND_API.G_RET_STS_ERROR;

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:
686: IF p_pn_locations_rec.location_type_lookup_code NOT IN ('OFFICE', 'SECTION') THEN

Line 700: IF NOT ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

696: p_active_end_date_old => p_active_end_date_old,
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;

Line 702: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 723: IF NOT ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

719: ,x_return_status => x_return_status
720: ,x_return_message => x_return_message
721: );
722:
723: IF NOT ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
724: x_return_status := FND_API.G_RET_STS_ERROR;
725: APP_EXCEPTION.Raise_Exception;
726: END IF;
727:

Line 724: x_return_status := FND_API.G_RET_STS_ERROR;

720: ,x_return_message => x_return_message
721: );
722:
723: IF NOT ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
724: x_return_status := FND_API.G_RET_STS_ERROR;
725: APP_EXCEPTION.Raise_Exception;
726: END IF;
727:
728: IF p_pn_locations_rec.location_type_lookup_code NOT IN ('OFFICE', 'SECTION') AND

Line 771: IF NOT ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

767: ,x_return_status => x_return_status
768: ,x_return_message => x_return_message
769: );
770:
771: IF NOT ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
772: x_return_status := FND_API.G_RET_STS_ERROR;
773: APP_EXCEPTION.Raise_Exception;
774: END IF;
775:

Line 772: x_return_status := FND_API.G_RET_STS_ERROR;

768: ,x_return_message => x_return_message
769: );
770:
771: IF NOT ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
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.');

Line 794: IF NOT ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

790: ,x_return_status => x_return_status
791: ,x_return_message => x_return_message
792: );
793:
794: IF NOT ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
795: x_return_status := FND_API.G_RET_STS_ERROR;
796: APP_EXCEPTION.Raise_Exception;
797: END IF;
798:

Line 795: x_return_status := FND_API.G_RET_STS_ERROR;

791: ,x_return_message => x_return_message
792: );
793:
794: IF NOT ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
795: x_return_status := FND_API.G_RET_STS_ERROR;
796: APP_EXCEPTION.Raise_Exception;
797: END IF;
798:
799: IF p_pn_locations_rec.location_type_lookup_code NOT IN ('OFFICE', 'SECTION') AND

Line 819: x_return_status := FND_API.G_RET_STS_ERROR;

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;
820:
821: END Correct_Update_Row;
822:
823:

Line 995: x_return_status := fnd_api.g_ret_sts_success;

991:
992: END LOOP;
993:
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:

Line 1301: x_return_status := fnd_api.g_ret_sts_success;

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;
1302:
1303: -----------------------------------------------------------------
1304: -- Call CHECK_UNIQUE_LOCATION_ALIAS to check if the location alias
1305: -- is unique.

Line 1369: IF NOT ( l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1365: p_active_end_date_old => null,
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:

Line 1393: IF NOT ( l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1389: p_active_end_date_old => null,
1390: x_return_status => l_return_status,
1391: x_return_message => l_return_message);
1392:
1393: IF NOT ( l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1394: APP_EXCEPTION.Raise_Exception;
1395: END IF;
1396:
1397: END IF; -- x_LOCATION_TYPE_LOOKUP_CODE

Line 1626: x_return_status := FND_API.G_RET_STS_ERROR;

1622: CLOSE C;
1623:
1624: EXCEPTION
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);

Line 1758: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1911: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2562: x_return_status := FND_API.G_RET_STS_SUCCESS;

2558: CONNECT BY PRIOR location_id = parent_location_id);
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

Line 2567: x_return_status := FND_API.G_RET_STS_ERROR;

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;
2568: fnd_message.set_name ('PN','PN_OTHERS_EXCEPTION');
2569: fnd_message.set_token('ERR_MSG',sqlerrm);
2570:
2571: END update_child_for_dates;

Line 3049: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 3054: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 3638: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

3634: ,x_return_message => x_return_message
3635: ,x_source => p_loc_recinfo.source
3636: );
3637:
3638: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3639: x_return_status := FND_API.G_RET_STS_ERROR;
3640: APP_EXCEPTION.Raise_Exception;
3641: END IF;
3642:

Line 3639: x_return_status := FND_API.G_RET_STS_ERROR;

3635: ,x_source => p_loc_recinfo.source
3636: );
3637:
3638: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
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);