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_US_ARCHIVE dependencies on PAY_CORE_UTILS

Line 1747: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','A');

1743: close c_get_asg_id;
1744: /* Added to show message in PAY_MESSAGE_LINES */
1745: l_mesg := 'Primary Assignment Not Found for Person '|| to_char(l_person_id);
1746: l_record_name := 'Person '|| to_char(l_person_id);
1747: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','A');
1748: pay_core_utils.push_token('record_name',l_record_name);
1749: pay_core_utils.push_token('description',l_mesg);
1750: raise_application_error(-20001,'Primary Assignment Not Found ' ||
1751: 'for person ' || to_char(l_person_id));

Line 1748: pay_core_utils.push_token('record_name',l_record_name);

1744: /* Added to show message in PAY_MESSAGE_LINES */
1745: l_mesg := 'Primary Assignment Not Found for Person '|| to_char(l_person_id);
1746: l_record_name := 'Person '|| to_char(l_person_id);
1747: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','A');
1748: pay_core_utils.push_token('record_name',l_record_name);
1749: pay_core_utils.push_token('description',l_mesg);
1750: raise_application_error(-20001,'Primary Assignment Not Found ' ||
1751: 'for person ' || to_char(l_person_id));
1752: end if;

Line 1749: pay_core_utils.push_token('description',l_mesg);

1745: l_mesg := 'Primary Assignment Not Found for Person '|| to_char(l_person_id);
1746: l_record_name := 'Person '|| to_char(l_person_id);
1747: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','A');
1748: pay_core_utils.push_token('record_name',l_record_name);
1749: pay_core_utils.push_token('description',l_mesg);
1750: raise_application_error(-20001,'Primary Assignment Not Found ' ||
1751: 'for person ' || to_char(l_person_id));
1752: end if;
1753: if c_get_asg_id%ISOPEN then

Line 4815: pay_core_utils.push_message(801,'PAY_EXCEPTION','A');

4811: if c_get_1099_distribution_info%NOTFOUND then
4812: l_distribution_code := '7' ;
4813: elsif c_get_1099_distribution_info%ROWCOUNT > 1 then
4814: l_mesg :='Person id '||to_char(l_person_id)||' has multiple distribution code for one GRE';
4815: pay_core_utils.push_message(801,'PAY_EXCEPTION','A');
4816: pay_core_utils.push_token('description',substr(l_mesg,1,50));
4817: hr_utility.raise_error;
4818: end if;
4819:

Line 4816: pay_core_utils.push_token('description',substr(l_mesg,1,50));

4812: l_distribution_code := '7' ;
4813: elsif c_get_1099_distribution_info%ROWCOUNT > 1 then
4814: l_mesg :='Person id '||to_char(l_person_id)||' has multiple distribution code for one GRE';
4815: pay_core_utils.push_message(801,'PAY_EXCEPTION','A');
4816: pay_core_utils.push_token('description',substr(l_mesg,1,50));
4817: hr_utility.raise_error;
4818: end if;
4819:
4820: close c_get_1099_distribution_info;

Line 5373: pay_core_utils.push_message(801,'PAY_EXCEPTION_ERROR','P');

5369:
5370: if l_processed = 'X' then
5371: hr_utility.trace('Value of l_processed is : ' || l_processed);
5372: l_mesg :='Error : GRE '||''''|| l_gre_name|| ''''||' has already been archived';
5373: pay_core_utils.push_message(801,'PAY_EXCEPTION_ERROR','P');
5374: pay_core_utils.push_token('description',l_mesg);
5375: hr_utility.raise_error;
5376: end if;
5377:

Line 5374: pay_core_utils.push_token('description',l_mesg);

5370: if l_processed = 'X' then
5371: hr_utility.trace('Value of l_processed is : ' || l_processed);
5372: l_mesg :='Error : GRE '||''''|| l_gre_name|| ''''||' has already been archived';
5373: pay_core_utils.push_message(801,'PAY_EXCEPTION_ERROR','P');
5374: pay_core_utils.push_token('description',l_mesg);
5375: hr_utility.raise_error;
5376: end if;
5377:
5378: exception

Line 5384: pay_core_utils.push_message(801,'PAY_EXCEPTION_ERROR','P');

5380: null; /* meaning this is the only run */
5381:
5382: when too_many_rows then
5383: l_mesg :='Error : GRE '||''''|| l_gre_name|| ''''||' has already been archived';
5384: pay_core_utils.push_message(801,'PAY_EXCEPTION_ERROR','P');
5385: pay_core_utils.push_token('description',l_mesg);
5386: hr_utility.raise_error;
5387:
5388: end;

Line 5385: pay_core_utils.push_token('description',l_mesg);

5381:
5382: when too_many_rows then
5383: l_mesg :='Error : GRE '||''''|| l_gre_name|| ''''||' has already been archived';
5384: pay_core_utils.push_message(801,'PAY_EXCEPTION_ERROR','P');
5385: pay_core_utils.push_token('description',l_mesg);
5386: hr_utility.raise_error;
5387:
5388: end;
5389: