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.PAY_JP_DEF_SS dependencies on FND_MESSAGE

Line 254: fnd_message.set_name('PAY', 'PAY_JP_DEF_PERIOD_CLOSED');

250: fetch csr_pact into l_pact_rec;
251: close csr_pact;
252: --
253: if l_pact_rec.submission_period_status = 'C' then
254: fnd_message.set_name('PAY', 'PAY_JP_DEF_PERIOD_CLOSED');
255: fnd_message.raise_error;
256: end if;
257: --
258: l_sysdate := sysdate;

Line 255: fnd_message.raise_error;

251: close csr_pact;
252: --
253: if l_pact_rec.submission_period_status = 'C' then
254: fnd_message.set_name('PAY', 'PAY_JP_DEF_PERIOD_CLOSED');
255: fnd_message.raise_error;
256: end if;
257: --
258: l_sysdate := sysdate;
259: --

Line 261: fnd_message.set_name('PAY', 'PAY_JP_DEF_PERIOD_NOT_STARTED');

257: --
258: l_sysdate := sysdate;
259: --
260: if l_sysdate < nvl(l_pact_rec.submission_start_date, l_sysdate) then
261: fnd_message.set_name('PAY', 'PAY_JP_DEF_PERIOD_NOT_STARTED');
262: fnd_message.raise_error;
263: end if;
264: --
265: if l_sysdate > nvl(l_pact_rec.submission_end_date, l_sysdate) then

Line 262: fnd_message.raise_error;

258: l_sysdate := sysdate;
259: --
260: if l_sysdate < nvl(l_pact_rec.submission_start_date, l_sysdate) then
261: fnd_message.set_name('PAY', 'PAY_JP_DEF_PERIOD_NOT_STARTED');
262: fnd_message.raise_error;
263: end if;
264: --
265: if l_sysdate > nvl(l_pact_rec.submission_end_date, l_sysdate) then
266: fnd_message.set_name('PAY', 'PAY_JP_DEF_PERIOD_EXPIRED');

Line 266: fnd_message.set_name('PAY', 'PAY_JP_DEF_PERIOD_EXPIRED');

262: fnd_message.raise_error;
263: end if;
264: --
265: if l_sysdate > nvl(l_pact_rec.submission_end_date, l_sysdate) then
266: fnd_message.set_name('PAY', 'PAY_JP_DEF_PERIOD_EXPIRED');
267: fnd_message.raise_error;
268: end if;
269: --
270: return l_sysdate;

Line 267: fnd_message.raise_error;

263: end if;
264: --
265: if l_sysdate > nvl(l_pact_rec.submission_end_date, l_sysdate) then
266: fnd_message.set_name('PAY', 'PAY_JP_DEF_PERIOD_EXPIRED');
267: fnd_message.raise_error;
268: end if;
269: --
270: return l_sysdate;
271: end check_submission_period;

Line 287: l_sqlerrm varchar2(2000) := fnd_message.get;

283: is
284: begin
285: if sqlcode = -20001 then
286: declare
287: l_sqlerrm varchar2(2000) := fnd_message.get;
288: begin
289: if l_sqlerrm is not null then
290: return l_sqlerrm;
291: else

Line 1239: fnd_message.set_name('FND', 'FND_RECORD_CHANGED_ERROR');

1235: where action_information_id = p_action_information_id
1236: for update nowait;
1237: --
1238: if p_rec.object_version_number <> p_object_version_number then
1239: fnd_message.set_name('FND', 'FND_RECORD_CHANGED_ERROR');
1240: fnd_message.raise_error;
1241: end if;
1242: exception
1243: when hr_api.object_locked then

Line 1240: fnd_message.raise_error;

1236: for update nowait;
1237: --
1238: if p_rec.object_version_number <> p_object_version_number then
1239: fnd_message.set_name('FND', 'FND_RECORD_CHANGED_ERROR');
1240: fnd_message.raise_error;
1241: end if;
1242: exception
1243: when hr_api.object_locked then
1244: fnd_message.set_name('FND', 'FND_LOCK_RECORD_ERROR');

Line 1244: fnd_message.set_name('FND', 'FND_LOCK_RECORD_ERROR');

1240: fnd_message.raise_error;
1241: end if;
1242: exception
1243: when hr_api.object_locked then
1244: fnd_message.set_name('FND', 'FND_LOCK_RECORD_ERROR');
1245: fnd_message.raise_error;
1246: when no_data_found then
1247: fnd_message.set_name('FND', 'FND_RECORD_DELETED_ERROR');
1248: fnd_message.raise_error;

Line 1245: fnd_message.raise_error;

1241: end if;
1242: exception
1243: when hr_api.object_locked then
1244: fnd_message.set_name('FND', 'FND_LOCK_RECORD_ERROR');
1245: fnd_message.raise_error;
1246: when no_data_found then
1247: fnd_message.set_name('FND', 'FND_RECORD_DELETED_ERROR');
1248: fnd_message.raise_error;
1249: end lock_assact;

Line 1247: fnd_message.set_name('FND', 'FND_RECORD_DELETED_ERROR');

1243: when hr_api.object_locked then
1244: fnd_message.set_name('FND', 'FND_LOCK_RECORD_ERROR');
1245: fnd_message.raise_error;
1246: when no_data_found then
1247: fnd_message.set_name('FND', 'FND_RECORD_DELETED_ERROR');
1248: fnd_message.raise_error;
1249: end lock_assact;
1250: -- |---------------------------------------------------------------------------|
1251: -- |--------------------------------< do_init >--------------------------------|

Line 1248: fnd_message.raise_error;

1244: fnd_message.set_name('FND', 'FND_LOCK_RECORD_ERROR');
1245: fnd_message.raise_error;
1246: when no_data_found then
1247: fnd_message.set_name('FND', 'FND_RECORD_DELETED_ERROR');
1248: fnd_message.raise_error;
1249: end lock_assact;
1250: -- |---------------------------------------------------------------------------|
1251: -- |--------------------------------< do_init >--------------------------------|
1252: -- |---------------------------------------------------------------------------|

Line 1512: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');

1508: --
1509: check_submission_period(p_action_information_id);
1510: --
1511: if l_assact_rec.transaction_status not in ('U', 'N') then
1512: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
1513: fnd_message.raise_error;
1514: end if;
1515: --
1516: delete

Line 1513: fnd_message.raise_error;

1509: check_submission_period(p_action_information_id);
1510: --
1511: if l_assact_rec.transaction_status not in ('U', 'N') then
1512: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
1513: fnd_message.raise_error;
1514: end if;
1515: --
1516: delete
1517: from pay_action_information

Line 1862: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');

1858: --
1859: l_submission_date := check_submission_period(p_action_information_id);
1860: --
1861: if l_assact_rec.transaction_status <> 'N' then
1862: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
1863: fnd_message.raise_error;
1864: end if;
1865: --
1866: -- Synchronize JP_DEF_ENTRY

Line 1863: fnd_message.raise_error;

1859: l_submission_date := check_submission_period(p_action_information_id);
1860: --
1861: if l_assact_rec.transaction_status <> 'N' then
1862: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
1863: fnd_message.raise_error;
1864: end if;
1865: --
1866: -- Synchronize JP_DEF_ENTRY
1867: -- Note all child EOs must be validated before calling this procedure

Line 2025: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');

2021: --
2022: check_submission_period(p_action_information_id);
2023: --
2024: if l_assact_rec.transaction_status not in ('F', 'A') then
2025: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
2026: fnd_message.raise_error;
2027: elsif l_assact_rec.transfer_status <> 'U' then
2028: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_TRANSFERRED');
2029: fnd_message.raise_error;

Line 2026: fnd_message.raise_error;

2022: check_submission_period(p_action_information_id);
2023: --
2024: if l_assact_rec.transaction_status not in ('F', 'A') then
2025: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
2026: fnd_message.raise_error;
2027: elsif l_assact_rec.transfer_status <> 'U' then
2028: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_TRANSFERRED');
2029: fnd_message.raise_error;
2030: end if;

Line 2028: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_TRANSFERRED');

2024: if l_assact_rec.transaction_status not in ('F', 'A') then
2025: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
2026: fnd_message.raise_error;
2027: elsif l_assact_rec.transfer_status <> 'U' then
2028: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_TRANSFERRED');
2029: fnd_message.raise_error;
2030: end if;
2031: --
2032: delete

Line 2029: fnd_message.raise_error;

2025: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
2026: fnd_message.raise_error;
2027: elsif l_assact_rec.transfer_status <> 'U' then
2028: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_TRANSFERRED');
2029: fnd_message.raise_error;
2030: end if;
2031: --
2032: delete
2033: from pay_action_information

Line 2104: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');

2100: --
2101: check_submission_period(p_action_information_id);
2102: --
2103: if l_assact_rec.transaction_status not in ('F', 'A') then
2104: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
2105: fnd_message.raise_error;
2106: elsif l_assact_rec.transfer_status <> 'U' then
2107: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_TRANSFERRED');
2108: fnd_message.raise_error;

Line 2105: fnd_message.raise_error;

2101: check_submission_period(p_action_information_id);
2102: --
2103: if l_assact_rec.transaction_status not in ('F', 'A') then
2104: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
2105: fnd_message.raise_error;
2106: elsif l_assact_rec.transfer_status <> 'U' then
2107: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_TRANSFERRED');
2108: fnd_message.raise_error;
2109: end if;

Line 2107: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_TRANSFERRED');

2103: if l_assact_rec.transaction_status not in ('F', 'A') then
2104: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
2105: fnd_message.raise_error;
2106: elsif l_assact_rec.transfer_status <> 'U' then
2107: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_TRANSFERRED');
2108: fnd_message.raise_error;
2109: end if;
2110: --
2111: l_assact_rec.transaction_status := 'N';

Line 2108: fnd_message.raise_error;

2104: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
2105: fnd_message.raise_error;
2106: elsif l_assact_rec.transfer_status <> 'U' then
2107: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_TRANSFERRED');
2108: fnd_message.raise_error;
2109: end if;
2110: --
2111: l_assact_rec.transaction_status := 'N';
2112: l_assact_rec.finalized_date := null;

Line 2174: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');

2170: --
2171: lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
2172: --
2173: if l_assact_rec.transaction_status <> 'F' then
2174: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
2175: fnd_message.raise_error;
2176: end if;
2177: --
2178: l_assact_rec.transaction_status := 'A';

Line 2175: fnd_message.raise_error;

2171: lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
2172: --
2173: if l_assact_rec.transaction_status <> 'F' then
2174: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
2175: fnd_message.raise_error;
2176: end if;
2177: --
2178: l_assact_rec.transaction_status := 'A';
2179: --

Line 2348: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');

2344: --
2345: lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
2346: --
2347: if l_assact_rec.transaction_status <> 'A' then
2348: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
2349: fnd_message.raise_error;
2350: elsif l_assact_rec.transfer_status <> 'U' then
2351: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_TRANSFERRED');
2352: fnd_message.raise_error;

Line 2349: fnd_message.raise_error;

2345: lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
2346: --
2347: if l_assact_rec.transaction_status <> 'A' then
2348: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
2349: fnd_message.raise_error;
2350: elsif l_assact_rec.transfer_status <> 'U' then
2351: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_TRANSFERRED');
2352: fnd_message.raise_error;
2353: end if;

Line 2351: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_TRANSFERRED');

2347: if l_assact_rec.transaction_status <> 'A' then
2348: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
2349: fnd_message.raise_error;
2350: elsif l_assact_rec.transfer_status <> 'U' then
2351: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_TRANSFERRED');
2352: fnd_message.raise_error;
2353: end if;
2354: --
2355: if p_create_session then

Line 2352: fnd_message.raise_error;

2348: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
2349: fnd_message.raise_error;
2350: elsif l_assact_rec.transfer_status <> 'U' then
2351: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_TRANSFERRED');
2352: fnd_message.raise_error;
2353: end if;
2354: --
2355: if p_create_session then
2356: insert_session(l_assact_rec.effective_date);

Line 2618: fnd_message.set_name('PAY', 'PAY_JP_DEF_NOT_TRANSFERRED');

2614: --
2615: lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
2616: --
2617: if l_assact_rec.transfer_status = 'U' then
2618: fnd_message.set_name('PAY', 'PAY_JP_DEF_NOT_TRANSFERRED');
2619: fnd_message.raise_error;
2620: elsif l_assact_rec.transfer_status = 'E' then
2621: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_EXPIRED');
2622: fnd_message.raise_error;

Line 2619: fnd_message.raise_error;

2615: lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
2616: --
2617: if l_assact_rec.transfer_status = 'U' then
2618: fnd_message.set_name('PAY', 'PAY_JP_DEF_NOT_TRANSFERRED');
2619: fnd_message.raise_error;
2620: elsif l_assact_rec.transfer_status = 'E' then
2621: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_EXPIRED');
2622: fnd_message.raise_error;
2623: end if;

Line 2621: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_EXPIRED');

2617: if l_assact_rec.transfer_status = 'U' then
2618: fnd_message.set_name('PAY', 'PAY_JP_DEF_NOT_TRANSFERRED');
2619: fnd_message.raise_error;
2620: elsif l_assact_rec.transfer_status = 'E' then
2621: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_EXPIRED');
2622: fnd_message.raise_error;
2623: end if;
2624: --
2625: if p_create_session then

Line 2622: fnd_message.raise_error;

2618: fnd_message.set_name('PAY', 'PAY_JP_DEF_NOT_TRANSFERRED');
2619: fnd_message.raise_error;
2620: elsif l_assact_rec.transfer_status = 'E' then
2621: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_EXPIRED');
2622: fnd_message.raise_error;
2623: end if;
2624: --
2625: if p_create_session then
2626: insert_session(l_assact_rec.effective_date);

Line 2796: fnd_message.set_name('PAY', 'PAY_JP_DEF_NOT_TRANSFERRED_YET');

2792: --
2793: lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
2794: --
2795: if l_assact_rec.transfer_status = 'U' then
2796: fnd_message.set_name('PAY', 'PAY_JP_DEF_NOT_TRANSFERRED_YET');
2797: fnd_message.raise_error;
2798: elsif l_assact_rec.transfer_status = 'E' then
2799: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_EXPIRED');
2800: fnd_message.raise_error;

Line 2797: fnd_message.raise_error;

2793: lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
2794: --
2795: if l_assact_rec.transfer_status = 'U' then
2796: fnd_message.set_name('PAY', 'PAY_JP_DEF_NOT_TRANSFERRED_YET');
2797: fnd_message.raise_error;
2798: elsif l_assact_rec.transfer_status = 'E' then
2799: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_EXPIRED');
2800: fnd_message.raise_error;
2801: end if;

Line 2799: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_EXPIRED');

2795: if l_assact_rec.transfer_status = 'U' then
2796: fnd_message.set_name('PAY', 'PAY_JP_DEF_NOT_TRANSFERRED_YET');
2797: fnd_message.raise_error;
2798: elsif l_assact_rec.transfer_status = 'E' then
2799: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_EXPIRED');
2800: fnd_message.raise_error;
2801: end if;
2802: --
2803: l_year_end_date := add_months(trunc(l_assact_rec.effective_date, 'YYYY'), 12) - 1;

Line 2800: fnd_message.raise_error;

2796: fnd_message.set_name('PAY', 'PAY_JP_DEF_NOT_TRANSFERRED_YET');
2797: fnd_message.raise_error;
2798: elsif l_assact_rec.transfer_status = 'E' then
2799: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_EXPIRED');
2800: fnd_message.raise_error;
2801: end if;
2802: --
2803: l_year_end_date := add_months(trunc(l_assact_rec.effective_date, 'YYYY'), 12) - 1;
2804: if p_expiry_date < l_assact_rec.effective_date

Line 2806: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_EXPIRY_DATE');

2802: --
2803: l_year_end_date := add_months(trunc(l_assact_rec.effective_date, 'YYYY'), 12) - 1;
2804: if p_expiry_date < l_assact_rec.effective_date
2805: or p_expiry_date > l_year_end_date then
2806: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_EXPIRY_DATE');
2807: fnd_message.set_token('EFFECTIVE_DATE', fnd_date.date_to_chardate(l_assact_rec.effective_date));
2808: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));
2809: fnd_message.raise_error;
2810: end if;

Line 2807: fnd_message.set_token('EFFECTIVE_DATE', fnd_date.date_to_chardate(l_assact_rec.effective_date));

2803: l_year_end_date := add_months(trunc(l_assact_rec.effective_date, 'YYYY'), 12) - 1;
2804: if p_expiry_date < l_assact_rec.effective_date
2805: or p_expiry_date > l_year_end_date then
2806: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_EXPIRY_DATE');
2807: fnd_message.set_token('EFFECTIVE_DATE', fnd_date.date_to_chardate(l_assact_rec.effective_date));
2808: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));
2809: fnd_message.raise_error;
2810: end if;
2811: --

Line 2808: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));

2804: if p_expiry_date < l_assact_rec.effective_date
2805: or p_expiry_date > l_year_end_date then
2806: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_EXPIRY_DATE');
2807: fnd_message.set_token('EFFECTIVE_DATE', fnd_date.date_to_chardate(l_assact_rec.effective_date));
2808: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));
2809: fnd_message.raise_error;
2810: end if;
2811: --
2812: insert_session(p_expiry_date);

Line 2809: fnd_message.raise_error;

2805: or p_expiry_date > l_year_end_date then
2806: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_EXPIRY_DATE');
2807: fnd_message.set_token('EFFECTIVE_DATE', fnd_date.date_to_chardate(l_assact_rec.effective_date));
2808: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));
2809: fnd_message.raise_error;
2810: end if;
2811: --
2812: insert_session(p_expiry_date);
2813: --

Line 3004: fnd_message.set_name('PAY', 'PAY_JP_DEF_NOT_EXPIRED_YET');

3000: --
3001: lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
3002: --
3003: if l_assact_rec.transfer_status <> 'E' then
3004: fnd_message.set_name('PAY', 'PAY_JP_DEF_NOT_EXPIRED_YET');
3005: fnd_message.raise_error;
3006: end if;
3007: --
3008: insert_session(l_assact_rec.expiry_date);

Line 3005: fnd_message.raise_error;

3001: lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
3002: --
3003: if l_assact_rec.transfer_status <> 'E' then
3004: fnd_message.set_name('PAY', 'PAY_JP_DEF_NOT_EXPIRED_YET');
3005: fnd_message.raise_error;
3006: end if;
3007: --
3008: insert_session(l_assact_rec.expiry_date);
3009: --