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_MESSAGE

Line 168: fnd_message.set_name('PN','PN_INVALID_EFFECTIVE_DATES');

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

Line 177: fnd_message.set_name('PN','PN_INVALID_EFFECTIVE_DATES');

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:
181: -- Validate for end date

Line 186: fnd_message.set_name('PN','PN_INVALID_EFFECTIVE_DATES');

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

Line 199: fnd_message.set_name('PN','PN_INVALID_EFFECTIVE_DATES');

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

Line 211: fnd_message.set_name('PN','PN_INVALID_EFFECTIVE_DATES');

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

Line 222: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

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');
223: fnd_message.set_token('ERR_MSG',sqlerrm);
224:
225: END check_location_overlap;
226:

Line 223: fnd_message.set_token('ERR_MSG',sqlerrm);

219: EXCEPTION
220:
221: WHEN OTHERS THEN
222: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
223: fnd_message.set_token('ERR_MSG',sqlerrm);
224:
225: END check_location_overlap;
226:
227: ------------------------------------------------------

Line 280: fnd_message.set_name('PN','PN_LOC_GAPS_MSG');

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

Line 281: fnd_message.set_token('GAP_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;
284: END IF;
285: ELSIF p_active_end_date IS NOT NULL THEN

Line 282: fnd_message.set_token('GAP_END_DATE',p_active_start_date - 1);

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;
284: END IF;
285: ELSIF p_active_end_date IS NOT NULL THEN
286: IF p_active_end_date < l_min_start_date THEN

Line 289: fnd_message.set_name('PN','PN_LOC_GAPS_MSG');

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

Line 290: fnd_message.set_token('GAP_START_DATE',p_active_end_date + 1);

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

Line 291: fnd_message.set_token('GAP_END_DATE',l_min_start_date);

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;
293: END IF;
294: END IF;
295:

Line 307: fnd_message.set_name('PN','PN_LOC_GAPS_MSG');

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

Line 308: fnd_message.set_token('GAP_START_DATE',p_active_start_date_old);

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;
311: END IF;
312: END LOOP;

Line 309: fnd_message.set_token('GAP_END_DATE',p_active_start_date - 1);

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;
311: END IF;
312: END LOOP;
313: END IF;

Line 322: fnd_message.set_name('PN','PN_LOC_GAPS_MSG');

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

Line 323: fnd_message.set_token('GAP_START_DATE',p_active_end_date + 1);

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;
326: END IF;
327: END LOOP;

Line 324: fnd_message.set_token('GAP_END_DATE',p_active_end_date_old);

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;
326: END IF;
327: END LOOP;
328: END IF;

Line 335: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

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');
336: fnd_message.set_token('ERR_MSG',sqlerrm);
337:
338: END check_location_gaps;
339:

Line 336: fnd_message.set_token('ERR_MSG',sqlerrm);

332: EXCEPTION
333:
334: WHEN OTHERS THEN
335: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
336: fnd_message.set_token('ERR_MSG',sqlerrm);
337:
338: END check_location_gaps;
339:
340: ----------------------------------------------------------------------

Line 1347: fnd_message.set_name('PN', 'PN_GROSS_RENTABLE');

1343: x_location_type_lookup_code,
1344: x_active_start_date,
1345: x_active_end_date) THEN
1346:
1347: fnd_message.set_name('PN', 'PN_GROSS_RENTABLE');
1348: app_exception.raise_Exception;
1349: END IF;
1350: END IF;
1351:

Line 1627: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

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);
1631: END;

Line 1628: fnd_message.set_token('ERR_MSG',sqlerrm);

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);
1631: END;
1632:

Line 1769: fnd_message.set_name('PN', 'PN_GROSS_RENTABLE');

1765: x_active_start_date,
1766: x_active_end_date,
1767: 'UPDATE') THEN
1768:
1769: fnd_message.set_name('PN', 'PN_GROSS_RENTABLE');
1770: app_exception.raise_Exception;
1771: END IF;
1772: END IF;
1773:

Line 1912: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

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

Line 1913: fnd_message.set_token('ERR_MSG',sqlerrm);

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

Line 2040: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

2036: OPEN C;
2037: FETCH C INTO G_LOC_RECINFO;
2038: IF (C%NOTFOUND) THEN
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,

Line 2483: fnd_message.set_name ('PN','PN_LOCTN_TENANCY_CHK_MSG');

2479: FETCH check_tenancy into l_exists;
2480: CLOSE check_tenancy;
2481:
2482: IF l_exists = 'Y' THEN
2483: fnd_message.set_name ('PN','PN_LOCTN_TENANCY_CHK_MSG');
2484: x_return_status := 'E';
2485: RETURN;
2486: END IF;
2487:

Line 2528: fnd_message.set_name ('PN','PN_LOCTN_TENANCY_CHK_MSG');

2524: FETCH check_start_tenancy into l_exists;
2525: CLOSE check_start_tenancy;
2526:
2527: IF l_exists = 'Y' THEN
2528: fnd_message.set_name ('PN','PN_LOCTN_TENANCY_CHK_MSG');
2529: x_return_status := 'E';
2530: RETURN;
2531: END IF;
2532:

Line 2568: fnd_message.set_name ('PN','PN_OTHERS_EXCEPTION');

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

Line 2569: fnd_message.set_token('ERR_MSG',sqlerrm);

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

Line 3055: fnd_message.set_name ('PN','PN_OTHERS_EXCEPTION');

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:
3059: END update_assignments;

Line 3056: fnd_message.set_token('ERR_MSG',sqlerrm);

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:
3059: END update_assignments;
3060:

Line 3734: fnd_message.set_name ('PN','PN_DUP_LOCATION_CODE');

3730: FETCH loc_code_cur INTO l_dummy;
3731: CLOSE loc_code_cur;
3732:
3733: IF l_dummy = 1 THEN
3734: fnd_message.set_name ('PN','PN_DUP_LOCATION_CODE');
3735: fnd_message.set_token('LOCATION_CODE', x_location_code);
3736: x_return_status := 'E';
3737: END IF;
3738:

Line 3735: fnd_message.set_token('LOCATION_CODE', x_location_code);

3731: CLOSE loc_code_cur;
3732:
3733: IF l_dummy = 1 THEN
3734: fnd_message.set_name ('PN','PN_DUP_LOCATION_CODE');
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);

Line 3785: fnd_message.set_name ('PN','PN_DUP_BUILDING');

3781: FETCH building_cur INTO l_dummy;
3782: CLOSE building_cur;
3783:
3784: IF l_dummy = 1 THEN
3785: fnd_message.set_name ('PN','PN_DUP_BUILDING');
3786: fnd_message.set_token('BUILDING', x_building);
3787: x_return_status := 'E';
3788: END IF;
3789:

Line 3786: fnd_message.set_token('BUILDING', x_building);

3782: CLOSE building_cur;
3783:
3784: IF l_dummy = 1 THEN
3785: fnd_message.set_name ('PN','PN_DUP_BUILDING');
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);

Line 3834: fnd_message.set_name('PN', l_msg_name);

3830:
3831: IF l_dup_alias IS NOT NULL THEN
3832: l_msg_name := 'PN_DUP_'||p_location_type_lookup_code||'_ALIAS';
3833: l_token := p_location_type_lookup_code||'_ALIAS';
3834: fnd_message.set_name('PN', l_msg_name);
3835: fnd_message.set_token(l_token, p_location_alias);
3836: RETURN FALSE;
3837: ELSE
3838: RETURN TRUE;

Line 3835: fnd_message.set_token(l_token, p_location_alias);

3831: IF l_dup_alias IS NOT NULL THEN
3832: l_msg_name := 'PN_DUP_'||p_location_type_lookup_code||'_ALIAS';
3833: l_token := p_location_type_lookup_code||'_ALIAS';
3834: fnd_message.set_name('PN', l_msg_name);
3835: fnd_message.set_token(l_token, p_location_alias);
3836: RETURN FALSE;
3837: ELSE
3838: RETURN TRUE;
3839: END IF;

Line 3909: fnd_message.set_name ('PN',l_set_name);

3905: FETCH loc_alias_cur INTO l_dummy;
3906: CLOSE loc_alias_cur;
3907:
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;

Line 3910: fnd_message.set_token(l_set_token, x_location_alias);

3906: CLOSE loc_alias_cur;
3907:
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: