DBA Data[Home] [Help]

APPS.PAY_US_ARCHIVE dependencies on PAY_CORE_UTILS

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

1439: close c_get_asg_id;
1440: /* Added to show message in PAY_MESSAGE_LINES */
1441: l_mesg := 'Primary Assignment Not Found for Person '|| to_char(l_person_id);
1442: l_record_name := 'Person '|| to_char(l_person_id);
1443: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','A');
1444: pay_core_utils.push_token('record_name',l_record_name);
1445: pay_core_utils.push_token('description',l_mesg);
1446: raise_application_error(-20001,'Primary Assignment Not Found ' ||
1447: 'for person ' || to_char(l_person_id));

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

1440: /* Added to show message in PAY_MESSAGE_LINES */
1441: l_mesg := 'Primary Assignment Not Found for Person '|| to_char(l_person_id);
1442: l_record_name := 'Person '|| to_char(l_person_id);
1443: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','A');
1444: pay_core_utils.push_token('record_name',l_record_name);
1445: pay_core_utils.push_token('description',l_mesg);
1446: raise_application_error(-20001,'Primary Assignment Not Found ' ||
1447: 'for person ' || to_char(l_person_id));
1448: end if;

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

1441: l_mesg := 'Primary Assignment Not Found for Person '|| to_char(l_person_id);
1442: l_record_name := 'Person '|| to_char(l_person_id);
1443: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','A');
1444: pay_core_utils.push_token('record_name',l_record_name);
1445: pay_core_utils.push_token('description',l_mesg);
1446: raise_application_error(-20001,'Primary Assignment Not Found ' ||
1447: 'for person ' || to_char(l_person_id));
1448: end if;
1449: if c_get_asg_id%ISOPEN then

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

4143: if c_get_1099_distribution_info%NOTFOUND then
4144: l_distribution_code := '7' ;
4145: elsif c_get_1099_distribution_info%ROWCOUNT > 1 then
4146: l_mesg :='Person id '||to_char(l_person_id)||' has multiple distribution code for one GRE';
4147: pay_core_utils.push_message(801,'PAY_EXCEPTION','A');
4148: pay_core_utils.push_token('description',substr(l_mesg,1,50));
4149: hr_utility.raise_error;
4150: end if;
4151:

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

4144: l_distribution_code := '7' ;
4145: elsif c_get_1099_distribution_info%ROWCOUNT > 1 then
4146: l_mesg :='Person id '||to_char(l_person_id)||' has multiple distribution code for one GRE';
4147: pay_core_utils.push_message(801,'PAY_EXCEPTION','A');
4148: pay_core_utils.push_token('description',substr(l_mesg,1,50));
4149: hr_utility.raise_error;
4150: end if;
4151:
4152: close c_get_1099_distribution_info;

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

4537:
4538: if l_processed = 'X' then
4539: hr_utility.trace('Value of l_processed is : ' || l_processed);
4540: l_mesg :='Error : GRE '||''''|| l_gre_name|| ''''||' has already been archived';
4541: pay_core_utils.push_message(801,'PAY_EXCEPTION_ERROR','P');
4542: pay_core_utils.push_token('description',l_mesg);
4543: hr_utility.raise_error;
4544: end if;
4545:

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

4538: if l_processed = 'X' then
4539: hr_utility.trace('Value of l_processed is : ' || l_processed);
4540: l_mesg :='Error : GRE '||''''|| l_gre_name|| ''''||' has already been archived';
4541: pay_core_utils.push_message(801,'PAY_EXCEPTION_ERROR','P');
4542: pay_core_utils.push_token('description',l_mesg);
4543: hr_utility.raise_error;
4544: end if;
4545:
4546: exception

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

4548: null; /* meaning this is the only run */
4549:
4550: when too_many_rows then
4551: l_mesg :='Error : GRE '||''''|| l_gre_name|| ''''||' has already been archived';
4552: pay_core_utils.push_message(801,'PAY_EXCEPTION_ERROR','P');
4553: pay_core_utils.push_token('description',l_mesg);
4554: hr_utility.raise_error;
4555:
4556: end;

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

4549:
4550: when too_many_rows then
4551: l_mesg :='Error : GRE '||''''|| l_gre_name|| ''''||' has already been archived';
4552: pay_core_utils.push_message(801,'PAY_EXCEPTION_ERROR','P');
4553: pay_core_utils.push_token('description',l_mesg);
4554: hr_utility.raise_error;
4555:
4556: end;
4557: