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 261: fnd_message.set_name('PAY', 'PAY_JP_DEF_PERIOD_CLOSED');

257: fetch csr_pact into l_pact_rec;
258: close csr_pact;
259: --
260: if l_pact_rec.submission_period_status = 'C' then
261: fnd_message.set_name('PAY', 'PAY_JP_DEF_PERIOD_CLOSED');
262: fnd_message.raise_error;
263: end if;
264: --
265: l_sysdate := sysdate;

Line 262: fnd_message.raise_error;

258: close csr_pact;
259: --
260: if l_pact_rec.submission_period_status = 'C' then
261: fnd_message.set_name('PAY', 'PAY_JP_DEF_PERIOD_CLOSED');
262: fnd_message.raise_error;
263: end if;
264: --
265: l_sysdate := sysdate;
266: --

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

264: --
265: l_sysdate := sysdate;
266: --
267: if l_sysdate < nvl(l_pact_rec.submission_start_date, l_sysdate) then
268: fnd_message.set_name('PAY', 'PAY_JP_DEF_PERIOD_NOT_STARTED');
269: fnd_message.raise_error;
270: end if;
271: --
272: if l_sysdate > nvl(l_pact_rec.submission_end_date, l_sysdate) then

Line 269: fnd_message.raise_error;

265: l_sysdate := sysdate;
266: --
267: if l_sysdate < nvl(l_pact_rec.submission_start_date, l_sysdate) then
268: fnd_message.set_name('PAY', 'PAY_JP_DEF_PERIOD_NOT_STARTED');
269: fnd_message.raise_error;
270: end if;
271: --
272: if l_sysdate > nvl(l_pact_rec.submission_end_date, l_sysdate) then
273: fnd_message.set_name('PAY', 'PAY_JP_DEF_PERIOD_EXPIRED');

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

269: fnd_message.raise_error;
270: end if;
271: --
272: if l_sysdate > nvl(l_pact_rec.submission_end_date, l_sysdate) then
273: fnd_message.set_name('PAY', 'PAY_JP_DEF_PERIOD_EXPIRED');
274: fnd_message.raise_error;
275: end if;
276: --
277: return l_sysdate;

Line 274: fnd_message.raise_error;

270: end if;
271: --
272: if l_sysdate > nvl(l_pact_rec.submission_end_date, l_sysdate) then
273: fnd_message.set_name('PAY', 'PAY_JP_DEF_PERIOD_EXPIRED');
274: fnd_message.raise_error;
275: end if;
276: --
277: return l_sysdate;
278: end check_submission_period;

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

290: is
291: begin
292: if sqlcode = -20001 then
293: declare
294: l_sqlerrm varchar2(2000) := fnd_message.get;
295: begin
296: if l_sqlerrm is not null then
297: return l_sqlerrm;
298: else

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

1457: where action_information_id = p_action_information_id
1458: for update nowait;
1459: --
1460: if p_rec.object_version_number <> p_object_version_number then
1461: fnd_message.set_name('FND', 'FND_RECORD_CHANGED_ERROR');
1462: fnd_message.raise_error;
1463: end if;
1464: --
1465: -- assumption is that lock_assact work for same business group against multiple assignments

Line 1462: fnd_message.raise_error;

1458: for update nowait;
1459: --
1460: if p_rec.object_version_number <> p_object_version_number then
1461: fnd_message.set_name('FND', 'FND_RECORD_CHANGED_ERROR');
1462: fnd_message.raise_error;
1463: end if;
1464: --
1465: -- assumption is that lock_assact work for same business group against multiple assignments
1466: -- because archive should processed for one session business group

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

1475: end if;
1476: --
1477: exception
1478: when hr_api.object_locked then
1479: fnd_message.set_name('FND', 'FND_LOCK_RECORD_ERROR');
1480: fnd_message.raise_error;
1481: when no_data_found then
1482: fnd_message.set_name('FND', 'FND_RECORD_DELETED_ERROR');
1483: fnd_message.raise_error;

Line 1480: fnd_message.raise_error;

1476: --
1477: exception
1478: when hr_api.object_locked then
1479: fnd_message.set_name('FND', 'FND_LOCK_RECORD_ERROR');
1480: fnd_message.raise_error;
1481: when no_data_found then
1482: fnd_message.set_name('FND', 'FND_RECORD_DELETED_ERROR');
1483: fnd_message.raise_error;
1484: end lock_assact;

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

1478: when hr_api.object_locked then
1479: fnd_message.set_name('FND', 'FND_LOCK_RECORD_ERROR');
1480: fnd_message.raise_error;
1481: when no_data_found then
1482: fnd_message.set_name('FND', 'FND_RECORD_DELETED_ERROR');
1483: fnd_message.raise_error;
1484: end lock_assact;
1485: --
1486: -- -------------------------------------------------------------------------

Line 1483: fnd_message.raise_error;

1479: fnd_message.set_name('FND', 'FND_LOCK_RECORD_ERROR');
1480: fnd_message.raise_error;
1481: when no_data_found then
1482: fnd_message.set_name('FND', 'FND_RECORD_DELETED_ERROR');
1483: fnd_message.raise_error;
1484: end lock_assact;
1485: --
1486: -- -------------------------------------------------------------------------
1487: -- archive_default

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

2303: --
2304: check_submission_period(p_action_information_id);
2305: --
2306: if l_assact_rec.transaction_status not in ('U', 'N') then
2307: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
2308: fnd_message.raise_error;
2309: end if;
2310: --
2311: delete

Line 2308: fnd_message.raise_error;

2304: check_submission_period(p_action_information_id);
2305: --
2306: if l_assact_rec.transaction_status not in ('U', 'N') then
2307: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
2308: fnd_message.raise_error;
2309: end if;
2310: --
2311: delete
2312: from pay_action_information

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

2421: --
2422: l_submission_date := check_submission_period(p_action_information_id);
2423: --
2424: if l_assact_rec.transaction_status <> 'N' then
2425: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
2426: fnd_message.raise_error;
2427: end if;
2428: --
2429: -- Synchronize JP_DEF_ENTRY

Line 2426: fnd_message.raise_error;

2422: l_submission_date := check_submission_period(p_action_information_id);
2423: --
2424: if l_assact_rec.transaction_status <> 'N' then
2425: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
2426: fnd_message.raise_error;
2427: end if;
2428: --
2429: -- Synchronize JP_DEF_ENTRY
2430: -- Note all child EOs must be validated before calling this procedure

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

2639: --
2640: check_submission_period(p_action_information_id);
2641: --
2642: if l_assact_rec.transaction_status not in ('F', 'A') then
2643: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
2644: fnd_message.raise_error;
2645: elsif l_assact_rec.transfer_status <> 'U' then
2646: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_TRANSFERRED');
2647: fnd_message.raise_error;

Line 2644: fnd_message.raise_error;

2640: check_submission_period(p_action_information_id);
2641: --
2642: if l_assact_rec.transaction_status not in ('F', 'A') then
2643: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
2644: fnd_message.raise_error;
2645: elsif l_assact_rec.transfer_status <> 'U' then
2646: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_TRANSFERRED');
2647: fnd_message.raise_error;
2648: end if;

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

2642: if l_assact_rec.transaction_status not in ('F', 'A') then
2643: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
2644: fnd_message.raise_error;
2645: elsif l_assact_rec.transfer_status <> 'U' then
2646: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_TRANSFERRED');
2647: fnd_message.raise_error;
2648: end if;
2649: --
2650: delete

Line 2647: fnd_message.raise_error;

2643: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
2644: fnd_message.raise_error;
2645: elsif l_assact_rec.transfer_status <> 'U' then
2646: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_TRANSFERRED');
2647: fnd_message.raise_error;
2648: end if;
2649: --
2650: delete
2651: from pay_action_information

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

2721: --
2722: check_submission_period(p_action_information_id);
2723: --
2724: if l_assact_rec.transaction_status not in ('F', 'A') then
2725: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
2726: fnd_message.raise_error;
2727: elsif l_assact_rec.transfer_status <> 'U' then
2728: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_TRANSFERRED');
2729: fnd_message.raise_error;

Line 2726: fnd_message.raise_error;

2722: check_submission_period(p_action_information_id);
2723: --
2724: if l_assact_rec.transaction_status not in ('F', 'A') then
2725: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
2726: fnd_message.raise_error;
2727: elsif l_assact_rec.transfer_status <> 'U' then
2728: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_TRANSFERRED');
2729: fnd_message.raise_error;
2730: end if;

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

2724: if l_assact_rec.transaction_status not in ('F', 'A') then
2725: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
2726: fnd_message.raise_error;
2727: elsif l_assact_rec.transfer_status <> 'U' then
2728: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_TRANSFERRED');
2729: fnd_message.raise_error;
2730: end if;
2731: --
2732: l_assact_rec.transaction_status := 'N';

Line 2729: fnd_message.raise_error;

2725: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
2726: fnd_message.raise_error;
2727: elsif l_assact_rec.transfer_status <> 'U' then
2728: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_TRANSFERRED');
2729: fnd_message.raise_error;
2730: end if;
2731: --
2732: l_assact_rec.transaction_status := 'N';
2733: l_assact_rec.finalized_date := null;

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

2794: --
2795: lock_assact(p_action_information_id, p_object_version_number, l_business_group_id, l_assact_rec);
2796: --
2797: if l_assact_rec.transaction_status <> 'F' then
2798: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
2799: fnd_message.raise_error;
2800: end if;
2801: --
2802: l_assact_rec.transaction_status := 'A';

Line 2799: fnd_message.raise_error;

2795: lock_assact(p_action_information_id, p_object_version_number, l_business_group_id, l_assact_rec);
2796: --
2797: if l_assact_rec.transaction_status <> 'F' then
2798: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
2799: fnd_message.raise_error;
2800: end if;
2801: --
2802: l_assact_rec.transaction_status := 'A';
2803: --

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

3010: --
3011: lock_assact(p_action_information_id, p_object_version_number, g_business_group_id, l_assact_rec);
3012: --
3013: if l_assact_rec.transaction_status <> 'A' then
3014: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
3015: fnd_message.raise_error;
3016: elsif l_assact_rec.transfer_status <> 'U' then
3017: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_TRANSFERRED');
3018: fnd_message.raise_error;

Line 3015: fnd_message.raise_error;

3011: lock_assact(p_action_information_id, p_object_version_number, g_business_group_id, l_assact_rec);
3012: --
3013: if l_assact_rec.transaction_status <> 'A' then
3014: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
3015: fnd_message.raise_error;
3016: elsif l_assact_rec.transfer_status <> 'U' then
3017: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_TRANSFERRED');
3018: fnd_message.raise_error;
3019: end if;

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

3013: if l_assact_rec.transaction_status <> 'A' then
3014: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
3015: fnd_message.raise_error;
3016: elsif l_assact_rec.transfer_status <> 'U' then
3017: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_TRANSFERRED');
3018: fnd_message.raise_error;
3019: end if;
3020: --
3021: if p_create_session then

Line 3018: fnd_message.raise_error;

3014: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
3015: fnd_message.raise_error;
3016: elsif l_assact_rec.transfer_status <> 'U' then
3017: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_TRANSFERRED');
3018: fnd_message.raise_error;
3019: end if;
3020: --
3021: if p_create_session then
3022: insert_session(l_assact_rec.effective_date);

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

3366: --
3367: lock_assact(p_action_information_id, p_object_version_number, g_business_group_id, l_assact_rec);
3368: --
3369: if l_assact_rec.transfer_status = 'U' then
3370: fnd_message.set_name('PAY', 'PAY_JP_DEF_NOT_TRANSFERRED');
3371: fnd_message.raise_error;
3372: elsif l_assact_rec.transfer_status = 'E' then
3373: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_EXPIRED');
3374: fnd_message.raise_error;

Line 3371: fnd_message.raise_error;

3367: lock_assact(p_action_information_id, p_object_version_number, g_business_group_id, l_assact_rec);
3368: --
3369: if l_assact_rec.transfer_status = 'U' then
3370: fnd_message.set_name('PAY', 'PAY_JP_DEF_NOT_TRANSFERRED');
3371: fnd_message.raise_error;
3372: elsif l_assact_rec.transfer_status = 'E' then
3373: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_EXPIRED');
3374: fnd_message.raise_error;
3375: end if;

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

3369: if l_assact_rec.transfer_status = 'U' then
3370: fnd_message.set_name('PAY', 'PAY_JP_DEF_NOT_TRANSFERRED');
3371: fnd_message.raise_error;
3372: elsif l_assact_rec.transfer_status = 'E' then
3373: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_EXPIRED');
3374: fnd_message.raise_error;
3375: end if;
3376: --
3377: if p_create_session then

Line 3374: fnd_message.raise_error;

3370: fnd_message.set_name('PAY', 'PAY_JP_DEF_NOT_TRANSFERRED');
3371: fnd_message.raise_error;
3372: elsif l_assact_rec.transfer_status = 'E' then
3373: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_EXPIRED');
3374: fnd_message.raise_error;
3375: end if;
3376: --
3377: if p_create_session then
3378: insert_session(l_assact_rec.effective_date);

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

3609: --
3610: lock_assact(p_action_information_id, p_object_version_number, l_business_group_id, l_assact_rec);
3611: --
3612: if l_assact_rec.transfer_status = 'U' then
3613: fnd_message.set_name('PAY', 'PAY_JP_DEF_NOT_TRANSFERRED_YET');
3614: fnd_message.raise_error;
3615: elsif l_assact_rec.transfer_status = 'E' then
3616: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_EXPIRED');
3617: fnd_message.raise_error;

Line 3614: fnd_message.raise_error;

3610: lock_assact(p_action_information_id, p_object_version_number, l_business_group_id, l_assact_rec);
3611: --
3612: if l_assact_rec.transfer_status = 'U' then
3613: fnd_message.set_name('PAY', 'PAY_JP_DEF_NOT_TRANSFERRED_YET');
3614: fnd_message.raise_error;
3615: elsif l_assact_rec.transfer_status = 'E' then
3616: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_EXPIRED');
3617: fnd_message.raise_error;
3618: end if;

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

3612: if l_assact_rec.transfer_status = 'U' then
3613: fnd_message.set_name('PAY', 'PAY_JP_DEF_NOT_TRANSFERRED_YET');
3614: fnd_message.raise_error;
3615: elsif l_assact_rec.transfer_status = 'E' then
3616: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_EXPIRED');
3617: fnd_message.raise_error;
3618: end if;
3619: --
3620: l_year_end_date := add_months(trunc(l_assact_rec.effective_date, 'YYYY'), 12) - 1;

Line 3617: fnd_message.raise_error;

3613: fnd_message.set_name('PAY', 'PAY_JP_DEF_NOT_TRANSFERRED_YET');
3614: fnd_message.raise_error;
3615: elsif l_assact_rec.transfer_status = 'E' then
3616: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_EXPIRED');
3617: fnd_message.raise_error;
3618: end if;
3619: --
3620: l_year_end_date := add_months(trunc(l_assact_rec.effective_date, 'YYYY'), 12) - 1;
3621: --

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

3620: l_year_end_date := add_months(trunc(l_assact_rec.effective_date, 'YYYY'), 12) - 1;
3621: --
3622: if p_expiry_date < l_assact_rec.effective_date
3623: or p_expiry_date > l_year_end_date then
3624: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_EXPIRY_DATE');
3625: fnd_message.set_token('EFFECTIVE_DATE', fnd_date.date_to_chardate(l_assact_rec.effective_date));
3626: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));
3627: fnd_message.raise_error;
3628: end if;

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

3621: --
3622: if p_expiry_date < l_assact_rec.effective_date
3623: or p_expiry_date > l_year_end_date then
3624: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_EXPIRY_DATE');
3625: fnd_message.set_token('EFFECTIVE_DATE', fnd_date.date_to_chardate(l_assact_rec.effective_date));
3626: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));
3627: fnd_message.raise_error;
3628: end if;
3629: --

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

3622: if p_expiry_date < l_assact_rec.effective_date
3623: or p_expiry_date > l_year_end_date then
3624: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_EXPIRY_DATE');
3625: fnd_message.set_token('EFFECTIVE_DATE', fnd_date.date_to_chardate(l_assact_rec.effective_date));
3626: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));
3627: fnd_message.raise_error;
3628: end if;
3629: --
3630: insert_session(p_expiry_date);

Line 3627: fnd_message.raise_error;

3623: or p_expiry_date > l_year_end_date then
3624: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_EXPIRY_DATE');
3625: fnd_message.set_token('EFFECTIVE_DATE', fnd_date.date_to_chardate(l_assact_rec.effective_date));
3626: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));
3627: fnd_message.raise_error;
3628: end if;
3629: --
3630: insert_session(p_expiry_date);
3631: --

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

3883: --
3884: lock_assact(p_action_information_id, p_object_version_number, l_business_group_id, l_assact_rec);
3885: --
3886: if l_assact_rec.transfer_status <> 'E' then
3887: fnd_message.set_name('PAY', 'PAY_JP_DEF_NOT_EXPIRED_YET');
3888: fnd_message.raise_error;
3889: end if;
3890: --
3891: insert_session(l_assact_rec.expiry_date);

Line 3888: fnd_message.raise_error;

3884: lock_assact(p_action_information_id, p_object_version_number, l_business_group_id, l_assact_rec);
3885: --
3886: if l_assact_rec.transfer_status <> 'E' then
3887: fnd_message.set_name('PAY', 'PAY_JP_DEF_NOT_EXPIRED_YET');
3888: fnd_message.raise_error;
3889: end if;
3890: --
3891: insert_session(l_assact_rec.expiry_date);
3892: --