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_RETRO_STATUS_INTERNAL dependencies on FND_MESSAGE

Line 305: fnd_message.set_name('PAY','PAY_34300_RTS_ASG_NOT_EXISTS');

301: close csr_asg;
302: --
303: -- A valid assignment does not exist on the reprocess date.
304: --
305: fnd_message.set_name('PAY','PAY_34300_RTS_ASG_NOT_EXISTS');
306: fnd_message.set_token('EFFECTIVE_DATE', to_char(p_reprocess_date));
307: fnd_message.raise_error;
308: --
309: end if;

Line 306: fnd_message.set_token('EFFECTIVE_DATE', to_char(p_reprocess_date));

302: --
303: -- A valid assignment does not exist on the reprocess date.
304: --
305: fnd_message.set_name('PAY','PAY_34300_RTS_ASG_NOT_EXISTS');
306: fnd_message.set_token('EFFECTIVE_DATE', to_char(p_reprocess_date));
307: fnd_message.raise_error;
308: --
309: end if;
310: close csr_asg;

Line 307: fnd_message.raise_error;

303: -- A valid assignment does not exist on the reprocess date.
304: --
305: fnd_message.set_name('PAY','PAY_34300_RTS_ASG_NOT_EXISTS');
306: fnd_message.set_token('EFFECTIVE_DATE', to_char(p_reprocess_date));
307: fnd_message.raise_error;
308: --
309: end if;
310: close csr_asg;
311: --

Line 379: fnd_message.set_name('PAY','PAY_34301_RTS_INV_APPRVL_STA');

375: end if;
376: end if;
377: end if;
378: if l_inv_app_status then
379: fnd_message.set_name('PAY','PAY_34301_RTS_INV_APPRVL_STA');
380: fnd_message.raise_error;
381: end if;
382: hr_utility.set_location(' Leaving:'||l_proc, 100);
383:

Line 380: fnd_message.raise_error;

376: end if;
377: end if;
378: if l_inv_app_status then
379: fnd_message.set_name('PAY','PAY_34301_RTS_INV_APPRVL_STA');
380: fnd_message.raise_error;
381: end if;
382: hr_utility.set_location(' Leaving:'||l_proc, 100);
383:
384: end chk_approval_status;

Line 434: fnd_message.set_name('PAY','PAY_34302_RTS_INV_REP_DATE');

430: --
431: -- You cannot update the reprocess date of the retro assignment
432: -- that was created by the system.
433: --
434: fnd_message.set_name('PAY','PAY_34302_RTS_INV_REP_DATE');
435: fnd_message.raise_error;
436: --
437: end if;
438: end if;

Line 435: fnd_message.raise_error;

431: -- You cannot update the reprocess date of the retro assignment
432: -- that was created by the system.
433: --
434: fnd_message.set_name('PAY','PAY_34302_RTS_INV_REP_DATE');
435: fnd_message.raise_error;
436: --
437: end if;
438: end if;
439:

Line 491: fnd_message.set_name('PAY','PAY_34288_RET_ASG_DAT_ERR');

487: fetch csr_chk_rep_date into l_dummy;
488: if csr_chk_rep_date%found then
489: close csr_chk_rep_date;
490: --
491: fnd_message.set_name('PAY','PAY_34288_RET_ASG_DAT_ERR');
492: fnd_message.raise_error;
493: --
494: end if;
495: close csr_chk_rep_date;

Line 492: fnd_message.raise_error;

488: if csr_chk_rep_date%found then
489: close csr_chk_rep_date;
490: --
491: fnd_message.set_name('PAY','PAY_34288_RET_ASG_DAT_ERR');
492: fnd_message.raise_error;
493: --
494: end if;
495: close csr_chk_rep_date;
496:

Line 575: fnd_message.set_name('PAY','PAY_34303_RTS_RT_ASG_UNAVAIL');

571: --It will be removed in the future.
572: --
573: -- The retro assignment has been processed or is superseded.
574: --
575: fnd_message.set_name('PAY','PAY_34303_RTS_RT_ASG_UNAVAIL');
576: fnd_message.raise_error;
577: --
578: elsif p_old_approval_status = 'A' and
579: p_new_approval_status is null then

Line 576: fnd_message.raise_error;

572: --
573: -- The retro assignment has been processed or is superseded.
574: --
575: fnd_message.set_name('PAY','PAY_34303_RTS_RT_ASG_UNAVAIL');
576: fnd_message.raise_error;
577: --
578: elsif p_old_approval_status = 'A' and
579: p_new_approval_status is null then
580: --

Line 585: fnd_message.set_name('PAY','PAY_34313_RTS_ASG_CONFIRMED');

581: -- The retro assignment has been confirmed. The retro assignment
582: -- and retro entries cannot be changed unless the status is changed
583: -- or reconfirmed.
584: --
585: fnd_message.set_name('PAY','PAY_34313_RTS_ASG_CONFIRMED');
586: fnd_message.raise_error;
587: --
588: elsif p_dml_mode = g_delete then
589: --

Line 586: fnd_message.raise_error;

582: -- and retro entries cannot be changed unless the status is changed
583: -- or reconfirmed.
584: --
585: fnd_message.set_name('PAY','PAY_34313_RTS_ASG_CONFIRMED');
586: fnd_message.raise_error;
587: --
588: elsif p_dml_mode = g_delete then
589: --
590: -- Check to see if any system generated retro entry exists.

Line 601: fnd_message.set_name('PAY','PAY_34289_RET_ASG_DEL_ERR');

597: close csr_sys_ent_exists;
598: --
599: -- system generated entry found.
600: --
601: fnd_message.set_name('PAY','PAY_34289_RET_ASG_DEL_ERR');
602: fnd_message.raise_error;
603: --
604: end if;
605: close csr_sys_ent_exists;

Line 602: fnd_message.raise_error;

598: --
599: -- system generated entry found.
600: --
601: fnd_message.set_name('PAY','PAY_34289_RET_ASG_DEL_ERR');
602: fnd_message.raise_error;
603: --
604: end if;
605: close csr_sys_ent_exists;
606: end if;

Line 682: fnd_message.set_name('PAY','PAY_34304_RTS_RT_ENT_UNAVAIL');

678: -- If the system has initially generated the retro assignment
679: -- and this entry, the reprocess date cannot be updated.
680: --
681: l_element_name := get_element_name(p_element_entry_id);
682: fnd_message.set_name('PAY','PAY_34304_RTS_RT_ENT_UNAVAIL');
683: fnd_message.set_token('ELEMENT_NAME', l_element_name);
684: fnd_message.raise_error;
685: --
686: elsif nvl(p_system_reprocess_date, p_reprocess_date) < p_reprocess_date then

Line 683: fnd_message.set_token('ELEMENT_NAME', l_element_name);

679: -- and this entry, the reprocess date cannot be updated.
680: --
681: l_element_name := get_element_name(p_element_entry_id);
682: fnd_message.set_name('PAY','PAY_34304_RTS_RT_ENT_UNAVAIL');
683: fnd_message.set_token('ELEMENT_NAME', l_element_name);
684: fnd_message.raise_error;
685: --
686: elsif nvl(p_system_reprocess_date, p_reprocess_date) < p_reprocess_date then
687: --

Line 684: fnd_message.raise_error;

680: --
681: l_element_name := get_element_name(p_element_entry_id);
682: fnd_message.set_name('PAY','PAY_34304_RTS_RT_ENT_UNAVAIL');
683: fnd_message.set_token('ELEMENT_NAME', l_element_name);
684: fnd_message.raise_error;
685: --
686: elsif nvl(p_system_reprocess_date, p_reprocess_date) < p_reprocess_date then
687: --
688: -- The reprocess date cannot be later than the system reprocess date.

Line 691: fnd_message.set_name('PAY','PAY_34285_RET_REC_DATE_ETRY');

687: --
688: -- The reprocess date cannot be later than the system reprocess date.
689: --
690: l_element_name := get_element_name(p_element_entry_id);
691: fnd_message.set_name('PAY','PAY_34285_RET_REC_DATE_ETRY');
692: fnd_message.set_token('ELEMENT_NAME', l_element_name);
693: fnd_message.raise_error;
694: --
695: end if;

Line 692: fnd_message.set_token('ELEMENT_NAME', l_element_name);

688: -- The reprocess date cannot be later than the system reprocess date.
689: --
690: l_element_name := get_element_name(p_element_entry_id);
691: fnd_message.set_name('PAY','PAY_34285_RET_REC_DATE_ETRY');
692: fnd_message.set_token('ELEMENT_NAME', l_element_name);
693: fnd_message.raise_error;
694: --
695: end if;
696: end if;

Line 693: fnd_message.raise_error;

689: --
690: l_element_name := get_element_name(p_element_entry_id);
691: fnd_message.set_name('PAY','PAY_34285_RET_REC_DATE_ETRY');
692: fnd_message.set_token('ELEMENT_NAME', l_element_name);
693: fnd_message.raise_error;
694: --
695: end if;
696: end if;
697: hr_utility.set_location(l_proc, 30);

Line 708: fnd_message.set_name('PAY','PAY_33182_RET_RECALC_DATE_ERR');

704: --
705: -- The reprocess date cannot be earlier than the asg reprocess date.
706: --
707: l_element_name := get_element_name(p_element_entry_id);
708: fnd_message.set_name('PAY','PAY_33182_RET_RECALC_DATE_ERR');
709: fnd_message.set_token('ELEMENT_NAME', l_element_name);
710: fnd_message.raise_error;
711: --
712: end if;

Line 709: fnd_message.set_token('ELEMENT_NAME', l_element_name);

705: -- The reprocess date cannot be earlier than the asg reprocess date.
706: --
707: l_element_name := get_element_name(p_element_entry_id);
708: fnd_message.set_name('PAY','PAY_33182_RET_RECALC_DATE_ERR');
709: fnd_message.set_token('ELEMENT_NAME', l_element_name);
710: fnd_message.raise_error;
711: --
712: end if;
713: end if;

Line 710: fnd_message.raise_error;

706: --
707: l_element_name := get_element_name(p_element_entry_id);
708: fnd_message.set_name('PAY','PAY_33182_RET_RECALC_DATE_ERR');
709: fnd_message.set_token('ELEMENT_NAME', l_element_name);
710: fnd_message.raise_error;
711: --
712: end if;
713: end if;
714: end if;

Line 762: fnd_message.set_name('PAY','PAY_34314_RTS_ENT_NO_DEL');

758: -- User cannot delete system generated retro entry.
759: --
760: l_element_name := get_element_name(p_element_entry_id);
761:
762: fnd_message.set_name('PAY','PAY_34314_RTS_ENT_NO_DEL');
763: fnd_message.set_token('ELEMENT_NAME', l_element_name);
764: fnd_message.raise_error;
765: end if;
766: end if;

Line 763: fnd_message.set_token('ELEMENT_NAME', l_element_name);

759: --
760: l_element_name := get_element_name(p_element_entry_id);
761:
762: fnd_message.set_name('PAY','PAY_34314_RTS_ENT_NO_DEL');
763: fnd_message.set_token('ELEMENT_NAME', l_element_name);
764: fnd_message.raise_error;
765: end if;
766: end if;
767:

Line 764: fnd_message.raise_error;

760: l_element_name := get_element_name(p_element_entry_id);
761:
762: fnd_message.set_name('PAY','PAY_34314_RTS_ENT_NO_DEL');
763: fnd_message.set_token('ELEMENT_NAME', l_element_name);
764: fnd_message.raise_error;
765: end if;
766: end if;
767:
768: hr_utility.set_location(' Leaving:'||l_proc, 40);

Line 832: fnd_message.set_name('PAY','PAY_34305_RTS_INV_ENT_ID');

828: fetch csr_entry into l_rec;
829: if csr_entry%notfound then
830: close csr_entry;
831: --
832: fnd_message.set_name('PAY','PAY_34305_RTS_INV_ENT_ID');
833: fnd_message.set_token('ELEMENT_ENTRY_ID', to_char(p_element_entry_id));
834: fnd_message.raise_error;
835: --
836: end if;

Line 833: fnd_message.set_token('ELEMENT_ENTRY_ID', to_char(p_element_entry_id));

829: if csr_entry%notfound then
830: close csr_entry;
831: --
832: fnd_message.set_name('PAY','PAY_34305_RTS_INV_ENT_ID');
833: fnd_message.set_token('ELEMENT_ENTRY_ID', to_char(p_element_entry_id));
834: fnd_message.raise_error;
835: --
836: end if;
837: close csr_entry;

Line 834: fnd_message.raise_error;

830: close csr_entry;
831: --
832: fnd_message.set_name('PAY','PAY_34305_RTS_INV_ENT_ID');
833: fnd_message.set_token('ELEMENT_ENTRY_ID', to_char(p_element_entry_id));
834: fnd_message.raise_error;
835: --
836: end if;
837: close csr_entry;
838:

Line 918: fnd_message.set_name('PAY','PAY_34306_RTS_NO_DEF_CMP_AVL');

914: -- No default component is defined for this element type.
915: --
916: l_element_name := get_element_name(p_element_entry_id);
917:
918: fnd_message.set_name('PAY','PAY_34306_RTS_NO_DEF_CMP_AVL');
919: fnd_message.set_token('ELEMENT_NAME', l_element_name);
920: fnd_message.raise_error;
921: end if;
922:

Line 919: fnd_message.set_token('ELEMENT_NAME', l_element_name);

915: --
916: l_element_name := get_element_name(p_element_entry_id);
917:
918: fnd_message.set_name('PAY','PAY_34306_RTS_NO_DEF_CMP_AVL');
919: fnd_message.set_token('ELEMENT_NAME', l_element_name);
920: fnd_message.raise_error;
921: end if;
922:
923: --

Line 920: fnd_message.raise_error;

916: l_element_name := get_element_name(p_element_entry_id);
917:
918: fnd_message.set_name('PAY','PAY_34306_RTS_NO_DEF_CMP_AVL');
919: fnd_message.set_token('ELEMENT_NAME', l_element_name);
920: fnd_message.raise_error;
921: end if;
922:
923: --
924: -- Set out variable.

Line 1002: fnd_message.set_name('PAY','PAY_33167_RCU_INV_RETRO_COMP');

998: fetch csr_retro_component into l_exists;
999: if csr_retro_component%notfound then
1000: close csr_retro_component;
1001:
1002: fnd_message.set_name('PAY','PAY_33167_RCU_INV_RETRO_COMP');
1003: fnd_message.raise_error;
1004:
1005: end if;
1006: close csr_retro_component;

Line 1003: fnd_message.raise_error;

999: if csr_retro_component%notfound then
1000: close csr_retro_component;
1001:
1002: fnd_message.set_name('PAY','PAY_33167_RCU_INV_RETRO_COMP');
1003: fnd_message.raise_error;
1004:
1005: end if;
1006: close csr_retro_component;
1007:

Line 1080: fnd_message.set_name('PAY','PAY_34307_RTS_INV_RTR_CMP_USG');

1076: fetch csr_ele into l_element_name;
1077: close csr_ele;
1078: l_component_name := get_component_name(p_retro_component_id);
1079:
1080: fnd_message.set_name('PAY','PAY_34307_RTS_INV_RTR_CMP_USG');
1081: fnd_message.set_token('ELEMENT_NAME', l_element_name);
1082: fnd_message.set_token('COMPONENT_NAME', l_component_name);
1083: fnd_message.raise_error;
1084: --

Line 1081: fnd_message.set_token('ELEMENT_NAME', l_element_name);

1077: close csr_ele;
1078: l_component_name := get_component_name(p_retro_component_id);
1079:
1080: fnd_message.set_name('PAY','PAY_34307_RTS_INV_RTR_CMP_USG');
1081: fnd_message.set_token('ELEMENT_NAME', l_element_name);
1082: fnd_message.set_token('COMPONENT_NAME', l_component_name);
1083: fnd_message.raise_error;
1084: --
1085: end if;

Line 1082: fnd_message.set_token('COMPONENT_NAME', l_component_name);

1078: l_component_name := get_component_name(p_retro_component_id);
1079:
1080: fnd_message.set_name('PAY','PAY_34307_RTS_INV_RTR_CMP_USG');
1081: fnd_message.set_token('ELEMENT_NAME', l_element_name);
1082: fnd_message.set_token('COMPONENT_NAME', l_component_name);
1083: fnd_message.raise_error;
1084: --
1085: end if;
1086: hr_utility.set_location(' Leaving:'||l_proc, 40);

Line 1083: fnd_message.raise_error;

1079:
1080: fnd_message.set_name('PAY','PAY_34307_RTS_INV_RTR_CMP_USG');
1081: fnd_message.set_token('ELEMENT_NAME', l_element_name);
1082: fnd_message.set_token('COMPONENT_NAME', l_component_name);
1083: fnd_message.raise_error;
1084: --
1085: end if;
1086: hr_utility.set_location(' Leaving:'||l_proc, 40);
1087:

Line 1114: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');

1110: open csr_lock_retro_asg;
1111: fetch csr_lock_retro_asg into l_old_rec;
1112: if csr_lock_retro_asg%notfound then
1113: close csr_lock_retro_asg;
1114: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
1115: fnd_message.raise_error;
1116: end if;
1117: close csr_lock_retro_asg;
1118: --

Line 1115: fnd_message.raise_error;

1111: fetch csr_lock_retro_asg into l_old_rec;
1112: if csr_lock_retro_asg%notfound then
1113: close csr_lock_retro_asg;
1114: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
1115: fnd_message.raise_error;
1116: end if;
1117: close csr_lock_retro_asg;
1118: --
1119: hr_utility.set_location(l_proc, 20);

Line 1127: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');

1123: hr_utility.set_location(' Leaving:'||l_proc, 40);
1124: Exception
1125: When HR_Api.Object_Locked then
1126: --
1127: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
1128: fnd_message.set_token('TABLE_NAME', 'pay_retro_assignments');
1129: fnd_message.raise_error;
1130: end lock_retro_asg;
1131: --

Line 1128: fnd_message.set_token('TABLE_NAME', 'pay_retro_assignments');

1124: Exception
1125: When HR_Api.Object_Locked then
1126: --
1127: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
1128: fnd_message.set_token('TABLE_NAME', 'pay_retro_assignments');
1129: fnd_message.raise_error;
1130: end lock_retro_asg;
1131: --
1132: -- ----------------------------------------------------------------------------

Line 1129: fnd_message.raise_error;

1125: When HR_Api.Object_Locked then
1126: --
1127: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
1128: fnd_message.set_token('TABLE_NAME', 'pay_retro_assignments');
1129: fnd_message.raise_error;
1130: end lock_retro_asg;
1131: --
1132: -- ----------------------------------------------------------------------------
1133: -- |----------------------------< decode_default >----------------------------|

Line 1595: fnd_message.set_name('PER', 'PAY_500024_SYS_ENTRY_NO_EXIST');

1591: else
1592: -- Trying to update status to Deferred Forever/ Complete
1593: -- for user generated retro entry
1594: hr_utility.set_location (l_proc, 87);
1595: fnd_message.set_name('PER', 'PAY_500024_SYS_ENTRY_NO_EXIST');
1596: fnd_message.set_token('TABLE_NAME','pay_retro_assignments');
1597: fnd_message.raise_error;
1598: end if;
1599: close csr_sys_ent_exists;

Line 1596: fnd_message.set_token('TABLE_NAME','pay_retro_assignments');

1592: -- Trying to update status to Deferred Forever/ Complete
1593: -- for user generated retro entry
1594: hr_utility.set_location (l_proc, 87);
1595: fnd_message.set_name('PER', 'PAY_500024_SYS_ENTRY_NO_EXIST');
1596: fnd_message.set_token('TABLE_NAME','pay_retro_assignments');
1597: fnd_message.raise_error;
1598: end if;
1599: close csr_sys_ent_exists;
1600: End if;

Line 1597: fnd_message.raise_error;

1593: -- for user generated retro entry
1594: hr_utility.set_location (l_proc, 87);
1595: fnd_message.set_name('PER', 'PAY_500024_SYS_ENTRY_NO_EXIST');
1596: fnd_message.set_token('TABLE_NAME','pay_retro_assignments');
1597: fnd_message.raise_error;
1598: end if;
1599: close csr_sys_ent_exists;
1600: End if;
1601: /* Bug 13696751, changes end */

Line 1926: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');

1922: hr_utility.set_location(' Leaving:'||l_proc, 40);
1923: Exception
1924: When HR_Api.Object_Locked then
1925: --
1926: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
1927: fnd_message.set_token('TABLE_NAME', 'pay_retro_entries');
1928: fnd_message.raise_error;
1929: end lock_retro_entry;
1930: --

Line 1927: fnd_message.set_token('TABLE_NAME', 'pay_retro_entries');

1923: Exception
1924: When HR_Api.Object_Locked then
1925: --
1926: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
1927: fnd_message.set_token('TABLE_NAME', 'pay_retro_entries');
1928: fnd_message.raise_error;
1929: end lock_retro_entry;
1930: --
1931: -- ----------------------------------------------------------------------------

Line 1928: fnd_message.raise_error;

1924: When HR_Api.Object_Locked then
1925: --
1926: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
1927: fnd_message.set_token('TABLE_NAME', 'pay_retro_entries');
1928: fnd_message.raise_error;
1929: end lock_retro_entry;
1930: --
1931: -- ----------------------------------------------------------------------------
1932: -- |-------------------------< maintain_retro_entry >-------------------------|

Line 2216: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');

2212:
2213: if l_old_rec.retro_assignment_id is null then
2214: hr_utility.set_location(l_proc, 30);
2215: --
2216: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
2217: fnd_message.raise_error;
2218: end if;
2219:
2220: hr_utility.set_location(l_proc, 50);

Line 2217: fnd_message.raise_error;

2213: if l_old_rec.retro_assignment_id is null then
2214: hr_utility.set_location(l_proc, 30);
2215: --
2216: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
2217: fnd_message.raise_error;
2218: end if;
2219:
2220: hr_utility.set_location(l_proc, 50);
2221: --

Line 2301: fnd_message.set_name('PAY','PAY_34312_RTS_NO_RTA_FOUND');

2297: --
2298: -- No unprocessed retro assignment is found.
2299: --
2300: hr_utility.set_location('No retro assignment found for this assignment : '||l_proc, 15);
2301: fnd_message.set_name('PAY','PAY_34312_RTS_NO_RTA_FOUND');
2302: fnd_message.raise_error;
2303: --
2304: else
2305: --

Line 2302: fnd_message.raise_error;

2298: -- No unprocessed retro assignment is found.
2299: --
2300: hr_utility.set_location('No retro assignment found for this assignment : '||l_proc, 15);
2301: fnd_message.set_name('PAY','PAY_34312_RTS_NO_RTA_FOUND');
2302: fnd_message.raise_error;
2303: --
2304: else
2305: --
2306: hr_utility.set_location('Got retro assignment id and now locking : '||l_proc, 15);