DBA Data[Home] [Help]

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

417: end if;
418: end if;
419:
420: if l_inv_app_status then
421: fnd_message.set_name('PAY','PAY_34301_RTS_INV_APPRVL_STA');
422: fnd_message.raise_error;
423: end if;
424: hr_utility.set_location(' Leaving:'||l_proc, 40);
425:

Line 422: fnd_message.raise_error;

418: end if;
419:
420: if l_inv_app_status then
421: fnd_message.set_name('PAY','PAY_34301_RTS_INV_APPRVL_STA');
422: fnd_message.raise_error;
423: end if;
424: hr_utility.set_location(' Leaving:'||l_proc, 40);
425:
426: end chk_approval_status;

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

472: --
473: -- You cannot update the reprocess date of the retro assignment
474: -- that was created by the system.
475: --
476: fnd_message.set_name('PAY','PAY_34302_RTS_INV_REP_DATE');
477: fnd_message.raise_error;
478: --
479: end if;
480: end if;

Line 477: fnd_message.raise_error;

473: -- You cannot update the reprocess date of the retro assignment
474: -- that was created by the system.
475: --
476: fnd_message.set_name('PAY','PAY_34302_RTS_INV_REP_DATE');
477: fnd_message.raise_error;
478: --
479: end if;
480: end if;
481:

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

529: fetch csr_chk_rep_date into l_dummy;
530: if csr_chk_rep_date%found then
531: close csr_chk_rep_date;
532: --
533: fnd_message.set_name('PAY','PAY_34288_RET_ASG_DAT_ERR');
534: fnd_message.raise_error;
535: --
536: end if;
537: close csr_chk_rep_date;

Line 534: fnd_message.raise_error;

530: if csr_chk_rep_date%found then
531: close csr_chk_rep_date;
532: --
533: fnd_message.set_name('PAY','PAY_34288_RET_ASG_DAT_ERR');
534: fnd_message.raise_error;
535: --
536: end if;
537: close csr_chk_rep_date;
538:

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

606: (p_old_approval_status not in ('A','D','P')) then
607: --
608: -- The retro assignment has been processed or is superseded.
609: --
610: fnd_message.set_name('PAY','PAY_34303_RTS_RT_ASG_UNAVAIL');
611: fnd_message.raise_error;
612: --
613: elsif p_old_approval_status = 'A' and
614: p_new_approval_status is null then

Line 611: fnd_message.raise_error;

607: --
608: -- The retro assignment has been processed or is superseded.
609: --
610: fnd_message.set_name('PAY','PAY_34303_RTS_RT_ASG_UNAVAIL');
611: fnd_message.raise_error;
612: --
613: elsif p_old_approval_status = 'A' and
614: p_new_approval_status is null then
615: --

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

616: -- The retro assignment has been confirmed. The retro assignment
617: -- and retro entries cannot be changed unless the status is changed
618: -- or reconfirmed.
619: --
620: fnd_message.set_name('PAY','PAY_34313_RTS_ASG_CONFIRMED');
621: fnd_message.raise_error;
622: --
623: elsif p_dml_mode = g_delete then
624: --

Line 621: fnd_message.raise_error;

617: -- and retro entries cannot be changed unless the status is changed
618: -- or reconfirmed.
619: --
620: fnd_message.set_name('PAY','PAY_34313_RTS_ASG_CONFIRMED');
621: fnd_message.raise_error;
622: --
623: elsif p_dml_mode = g_delete then
624: --
625: -- Check to see if any system generated retro entry exists.

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

630: close csr_sys_ent_exists;
631: --
632: -- system generated entry found.
633: --
634: fnd_message.set_name('PAY','PAY_34289_RET_ASG_DEL_ERR');
635: fnd_message.raise_error;
636: --
637: end if;
638: close csr_sys_ent_exists;

Line 635: fnd_message.raise_error;

631: --
632: -- system generated entry found.
633: --
634: fnd_message.set_name('PAY','PAY_34289_RET_ASG_DEL_ERR');
635: fnd_message.raise_error;
636: --
637: end if;
638: close csr_sys_ent_exists;
639: end if;

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

710: -- If the system has initially generated the retro assignment
711: -- and this entry, the reprocess date cannot be updated.
712: --
713: l_element_name := get_element_name(p_element_entry_id);
714: fnd_message.set_name('PAY','PAY_34304_RTS_RT_ENT_UNAVAIL');
715: fnd_message.set_token('ELEMENT_NAME', l_element_name);
716: fnd_message.raise_error;
717: --
718: elsif nvl(p_system_reprocess_date, p_reprocess_date) < p_reprocess_date then

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

711: -- and this entry, the reprocess date cannot be updated.
712: --
713: l_element_name := get_element_name(p_element_entry_id);
714: fnd_message.set_name('PAY','PAY_34304_RTS_RT_ENT_UNAVAIL');
715: fnd_message.set_token('ELEMENT_NAME', l_element_name);
716: fnd_message.raise_error;
717: --
718: elsif nvl(p_system_reprocess_date, p_reprocess_date) < p_reprocess_date then
719: --

Line 716: fnd_message.raise_error;

712: --
713: l_element_name := get_element_name(p_element_entry_id);
714: fnd_message.set_name('PAY','PAY_34304_RTS_RT_ENT_UNAVAIL');
715: fnd_message.set_token('ELEMENT_NAME', l_element_name);
716: fnd_message.raise_error;
717: --
718: elsif nvl(p_system_reprocess_date, p_reprocess_date) < p_reprocess_date then
719: --
720: -- The reprocess date cannot be later than the system reprocess date.

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

719: --
720: -- The reprocess date cannot be later than the system reprocess date.
721: --
722: l_element_name := get_element_name(p_element_entry_id);
723: fnd_message.set_name('PAY','PAY_34285_RET_REC_DATE_ETRY');
724: fnd_message.set_token('ELEMENT_NAME', l_element_name);
725: fnd_message.raise_error;
726: --
727: end if;

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

720: -- The reprocess date cannot be later than the system reprocess date.
721: --
722: l_element_name := get_element_name(p_element_entry_id);
723: fnd_message.set_name('PAY','PAY_34285_RET_REC_DATE_ETRY');
724: fnd_message.set_token('ELEMENT_NAME', l_element_name);
725: fnd_message.raise_error;
726: --
727: end if;
728: end if;

Line 725: fnd_message.raise_error;

721: --
722: l_element_name := get_element_name(p_element_entry_id);
723: fnd_message.set_name('PAY','PAY_34285_RET_REC_DATE_ETRY');
724: fnd_message.set_token('ELEMENT_NAME', l_element_name);
725: fnd_message.raise_error;
726: --
727: end if;
728: end if;
729: hr_utility.set_location(l_proc, 30);

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

736: --
737: -- The reprocess date cannot be earlier than the asg reprocess date.
738: --
739: l_element_name := get_element_name(p_element_entry_id);
740: fnd_message.set_name('PAY','PAY_33182_RET_RECALC_DATE_ERR');
741: fnd_message.set_token('ELEMENT_NAME', l_element_name);
742: fnd_message.raise_error;
743: --
744: end if;

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

737: -- The reprocess date cannot be earlier than the asg reprocess date.
738: --
739: l_element_name := get_element_name(p_element_entry_id);
740: fnd_message.set_name('PAY','PAY_33182_RET_RECALC_DATE_ERR');
741: fnd_message.set_token('ELEMENT_NAME', l_element_name);
742: fnd_message.raise_error;
743: --
744: end if;
745: end if;

Line 742: fnd_message.raise_error;

738: --
739: l_element_name := get_element_name(p_element_entry_id);
740: fnd_message.set_name('PAY','PAY_33182_RET_RECALC_DATE_ERR');
741: fnd_message.set_token('ELEMENT_NAME', l_element_name);
742: fnd_message.raise_error;
743: --
744: end if;
745: end if;
746: end if;

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

790: -- User cannot delete system generated retro entry.
791: --
792: l_element_name := get_element_name(p_element_entry_id);
793:
794: fnd_message.set_name('PAY','PAY_34314_RTS_ENT_NO_DEL');
795: fnd_message.set_token('ELEMENT_NAME', l_element_name);
796: fnd_message.raise_error;
797: end if;
798: end if;

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

791: --
792: l_element_name := get_element_name(p_element_entry_id);
793:
794: fnd_message.set_name('PAY','PAY_34314_RTS_ENT_NO_DEL');
795: fnd_message.set_token('ELEMENT_NAME', l_element_name);
796: fnd_message.raise_error;
797: end if;
798: end if;
799:

Line 796: fnd_message.raise_error;

792: l_element_name := get_element_name(p_element_entry_id);
793:
794: fnd_message.set_name('PAY','PAY_34314_RTS_ENT_NO_DEL');
795: fnd_message.set_token('ELEMENT_NAME', l_element_name);
796: fnd_message.raise_error;
797: end if;
798: end if;
799:
800: hr_utility.set_location(' Leaving:'||l_proc, 40);

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

860: fetch csr_entry into l_rec;
861: if csr_entry%notfound then
862: close csr_entry;
863: --
864: fnd_message.set_name('PAY','PAY_34305_RTS_INV_ENT_ID');
865: fnd_message.set_token('ELEMENT_ENTRY_ID', to_char(p_element_entry_id));
866: fnd_message.raise_error;
867: --
868: end if;

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

861: if csr_entry%notfound then
862: close csr_entry;
863: --
864: fnd_message.set_name('PAY','PAY_34305_RTS_INV_ENT_ID');
865: fnd_message.set_token('ELEMENT_ENTRY_ID', to_char(p_element_entry_id));
866: fnd_message.raise_error;
867: --
868: end if;
869: close csr_entry;

Line 866: fnd_message.raise_error;

862: close csr_entry;
863: --
864: fnd_message.set_name('PAY','PAY_34305_RTS_INV_ENT_ID');
865: fnd_message.set_token('ELEMENT_ENTRY_ID', to_char(p_element_entry_id));
866: fnd_message.raise_error;
867: --
868: end if;
869: close csr_entry;
870:

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

946: -- No default component is defined for this element type.
947: --
948: l_element_name := get_element_name(p_element_entry_id);
949:
950: fnd_message.set_name('PAY','PAY_34306_RTS_NO_DEF_CMP_AVL');
951: fnd_message.set_token('ELEMENT_NAME', l_element_name);
952: fnd_message.raise_error;
953: end if;
954:

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

947: --
948: l_element_name := get_element_name(p_element_entry_id);
949:
950: fnd_message.set_name('PAY','PAY_34306_RTS_NO_DEF_CMP_AVL');
951: fnd_message.set_token('ELEMENT_NAME', l_element_name);
952: fnd_message.raise_error;
953: end if;
954:
955: --

Line 952: fnd_message.raise_error;

948: l_element_name := get_element_name(p_element_entry_id);
949:
950: fnd_message.set_name('PAY','PAY_34306_RTS_NO_DEF_CMP_AVL');
951: fnd_message.set_token('ELEMENT_NAME', l_element_name);
952: fnd_message.raise_error;
953: end if;
954:
955: --
956: -- Set out variable.

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

1030: fetch csr_retro_component into l_exists;
1031: if csr_retro_component%notfound then
1032: close csr_retro_component;
1033:
1034: fnd_message.set_name('PAY','PAY_33167_RCU_INV_RETRO_COMP');
1035: fnd_message.raise_error;
1036:
1037: end if;
1038: close csr_retro_component;

Line 1035: fnd_message.raise_error;

1031: if csr_retro_component%notfound then
1032: close csr_retro_component;
1033:
1034: fnd_message.set_name('PAY','PAY_33167_RCU_INV_RETRO_COMP');
1035: fnd_message.raise_error;
1036:
1037: end if;
1038: close csr_retro_component;
1039:

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

1108: fetch csr_ele into l_element_name;
1109: close csr_ele;
1110: l_component_name := get_component_name(p_retro_component_id);
1111:
1112: fnd_message.set_name('PAY','PAY_34307_RTS_INV_RTR_CMP_USG');
1113: fnd_message.set_token('ELEMENT_NAME', l_element_name);
1114: fnd_message.set_token('COMPONENT_NAME', l_component_name);
1115: fnd_message.raise_error;
1116: --

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

1109: close csr_ele;
1110: l_component_name := get_component_name(p_retro_component_id);
1111:
1112: fnd_message.set_name('PAY','PAY_34307_RTS_INV_RTR_CMP_USG');
1113: fnd_message.set_token('ELEMENT_NAME', l_element_name);
1114: fnd_message.set_token('COMPONENT_NAME', l_component_name);
1115: fnd_message.raise_error;
1116: --
1117: end if;

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

1110: l_component_name := get_component_name(p_retro_component_id);
1111:
1112: fnd_message.set_name('PAY','PAY_34307_RTS_INV_RTR_CMP_USG');
1113: fnd_message.set_token('ELEMENT_NAME', l_element_name);
1114: fnd_message.set_token('COMPONENT_NAME', l_component_name);
1115: fnd_message.raise_error;
1116: --
1117: end if;
1118: hr_utility.set_location(' Leaving:'||l_proc, 40);

Line 1115: fnd_message.raise_error;

1111:
1112: fnd_message.set_name('PAY','PAY_34307_RTS_INV_RTR_CMP_USG');
1113: fnd_message.set_token('ELEMENT_NAME', l_element_name);
1114: fnd_message.set_token('COMPONENT_NAME', l_component_name);
1115: fnd_message.raise_error;
1116: --
1117: end if;
1118: hr_utility.set_location(' Leaving:'||l_proc, 40);
1119:

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

1142: open csr_lock_retro_asg;
1143: fetch csr_lock_retro_asg into l_old_rec;
1144: if csr_lock_retro_asg%notfound then
1145: close csr_lock_retro_asg;
1146: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
1147: fnd_message.raise_error;
1148: end if;
1149: close csr_lock_retro_asg;
1150: --

Line 1147: fnd_message.raise_error;

1143: fetch csr_lock_retro_asg into l_old_rec;
1144: if csr_lock_retro_asg%notfound then
1145: close csr_lock_retro_asg;
1146: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
1147: fnd_message.raise_error;
1148: end if;
1149: close csr_lock_retro_asg;
1150: --
1151: hr_utility.set_location(l_proc, 20);

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

1155: hr_utility.set_location(' Leaving:'||l_proc, 40);
1156: Exception
1157: When HR_Api.Object_Locked then
1158: --
1159: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
1160: fnd_message.set_token('TABLE_NAME', 'pay_retro_assignments');
1161: fnd_message.raise_error;
1162: end lock_retro_asg;
1163: --

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

1156: Exception
1157: When HR_Api.Object_Locked then
1158: --
1159: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
1160: fnd_message.set_token('TABLE_NAME', 'pay_retro_assignments');
1161: fnd_message.raise_error;
1162: end lock_retro_asg;
1163: --
1164: -- ----------------------------------------------------------------------------

Line 1161: fnd_message.raise_error;

1157: When HR_Api.Object_Locked then
1158: --
1159: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
1160: fnd_message.set_token('TABLE_NAME', 'pay_retro_assignments');
1161: fnd_message.raise_error;
1162: end lock_retro_asg;
1163: --
1164: -- ----------------------------------------------------------------------------
1165: -- |----------------------------< decode_default >----------------------------|

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

1877: hr_utility.set_location(' Leaving:'||l_proc, 40);
1878: Exception
1879: When HR_Api.Object_Locked then
1880: --
1881: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
1882: fnd_message.set_token('TABLE_NAME', 'pay_retro_entries');
1883: fnd_message.raise_error;
1884: end lock_retro_entry;
1885: --

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

1878: Exception
1879: When HR_Api.Object_Locked then
1880: --
1881: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
1882: fnd_message.set_token('TABLE_NAME', 'pay_retro_entries');
1883: fnd_message.raise_error;
1884: end lock_retro_entry;
1885: --
1886: -- ----------------------------------------------------------------------------

Line 1883: fnd_message.raise_error;

1879: When HR_Api.Object_Locked then
1880: --
1881: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
1882: fnd_message.set_token('TABLE_NAME', 'pay_retro_entries');
1883: fnd_message.raise_error;
1884: end lock_retro_entry;
1885: --
1886: -- ----------------------------------------------------------------------------
1887: -- |-------------------------< maintain_retro_entry >-------------------------|

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

2167:
2168: if l_old_rec.retro_assignment_id is null then
2169: hr_utility.set_location(l_proc, 30);
2170: --
2171: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
2172: fnd_message.raise_error;
2173: end if;
2174:
2175: hr_utility.set_location(l_proc, 50);

Line 2172: fnd_message.raise_error;

2168: if l_old_rec.retro_assignment_id is null then
2169: hr_utility.set_location(l_proc, 30);
2170: --
2171: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
2172: fnd_message.raise_error;
2173: end if;
2174:
2175: hr_utility.set_location(l_proc, 50);
2176: --

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

2252: --
2253: -- No unprocessed retro assignment is found.
2254: --
2255: hr_utility.set_location('No retro assignment found for this assignment : '||l_proc, 15);
2256: fnd_message.set_name('PAY','PAY_34312_RTS_NO_RTA_FOUND');
2257: fnd_message.raise_error;
2258: --
2259: else
2260: --

Line 2257: fnd_message.raise_error;

2253: -- No unprocessed retro assignment is found.
2254: --
2255: hr_utility.set_location('No retro assignment found for this assignment : '||l_proc, 15);
2256: fnd_message.set_name('PAY','PAY_34312_RTS_NO_RTA_FOUND');
2257: fnd_message.raise_error;
2258: --
2259: else
2260: --
2261: hr_utility.set_location('Got retro assignment id and now locking : '||l_proc, 15);