DBA Data[Home] [Help]

APPS.PAY_ASSIGNMENT_ACTIONS_BRU dependencies on HR_UTILITY

Line 40: hr_utility.set_location('pay_assignment_actions_bru',10);

36: ON "APPS"."PAY_ASSIGNMENT_ACTIONS" for each row
37: WHEN (OLD.action_status <> NEW.action_status) begin
38: --
39: if hr_general.g_data_migrator_mode <> 'Y' then
40: hr_utility.set_location('pay_assignment_actions_bru',10);
41: if (:NEW.action_status <> :OLD.action_status) then
42: --
43: if (:OLD.action_status in ('C', 'S') and :NEW.action_status = 'M') then
44: -- doing a Retry operation

Line 45: hr_utility.set_location('pay_assignment_actions_bru',20);

41: if (:NEW.action_status <> :OLD.action_status) then
42: --
43: if (:OLD.action_status in ('C', 'S') and :NEW.action_status = 'M') then
44: -- doing a Retry operation
45: hr_utility.set_location('pay_assignment_actions_bru',20);
46: hrassact.ensure_assact_rolled_back
47: (:OLD.assignment_action_id, 'RETRY');
48: --
49: elsif (:OLD.action_status in ('C', 'S') and :NEW.action_status = 'B') then

Line 51: hr_utility.set_location('pay_assignment_actions_bru',30);

47: (:OLD.assignment_action_id, 'RETRY');
48: --
49: elsif (:OLD.action_status in ('C', 'S') and :NEW.action_status = 'B') then
50: -- doing a Mark for Backpay operation
51: hr_utility.set_location('pay_assignment_actions_bru',30);
52: hrassact.ensure_assact_rolled_back
53: (:OLD.assignment_action_id, 'BACKPAY');
54: --
55: elsif (:NEW.action_status = 'C'

Line 72: hr_utility.set_message(801, 'HR_6218_ACTION_BAD_UPDATE');

68: from pay_payroll_actions pac
69: where pac.payroll_action_id = :NEW.payroll_action_id;
70: --
71: if (actype <> 'M') then
72: hr_utility.set_message(801, 'HR_6218_ACTION_BAD_UPDATE');
73: hr_utility.raise_error;
74: end if;
75: end;
76: elsif (:OLD.action_status = 'U' and :NEW.action_status = 'B') then

Line 73: hr_utility.raise_error;

69: where pac.payroll_action_id = :NEW.payroll_action_id;
70: --
71: if (actype <> 'M') then
72: hr_utility.set_message(801, 'HR_6218_ACTION_BAD_UPDATE');
73: hr_utility.raise_error;
74: end if;
75: end;
76: elsif (:OLD.action_status = 'U' and :NEW.action_status = 'B') then
77: -- We can only perform an update from unprocessed to backpaying

Line 88: hr_utility.set_message(801, 'HR_6218_ACTION_BAD_UPDATE');

84: from pay_payroll_actions pac
85: where pac.payroll_action_id = :NEW.payroll_action_id;
86: --
87: if (actype not in ('F', 'W')) then
88: hr_utility.set_message(801, 'HR_6218_ACTION_BAD_UPDATE');
89: hr_utility.raise_error;
90: end if;
91: end;
92: elsif ((:NEW.action_status = 'S') OR (:OLD.action_status = 'S')) then

Line 89: hr_utility.raise_error;

85: where pac.payroll_action_id = :NEW.payroll_action_id;
86: --
87: if (actype not in ('F', 'W')) then
88: hr_utility.set_message(801, 'HR_6218_ACTION_BAD_UPDATE');
89: hr_utility.raise_error;
90: end if;
91: end;
92: elsif ((:NEW.action_status = 'S') OR (:OLD.action_status = 'S')) then
93: null;

Line 95: hr_utility.set_message(801, 'HR_6218_ACTION_BAD_UPDATE');

91: end;
92: elsif ((:NEW.action_status = 'S') OR (:OLD.action_status = 'S')) then
93: null;
94: else
95: hr_utility.set_message(801, 'HR_6218_ACTION_BAD_UPDATE');
96: hr_utility.raise_error;
97: end if;
98: end if;
99: hr_utility.set_location('pay_assignment_actions_bru',40);

Line 96: hr_utility.raise_error;

92: elsif ((:NEW.action_status = 'S') OR (:OLD.action_status = 'S')) then
93: null;
94: else
95: hr_utility.set_message(801, 'HR_6218_ACTION_BAD_UPDATE');
96: hr_utility.raise_error;
97: end if;
98: end if;
99: hr_utility.set_location('pay_assignment_actions_bru',40);
100: end if;

Line 99: hr_utility.set_location('pay_assignment_actions_bru',40);

95: hr_utility.set_message(801, 'HR_6218_ACTION_BAD_UPDATE');
96: hr_utility.raise_error;
97: end if;
98: end if;
99: hr_utility.set_location('pay_assignment_actions_bru',40);
100: end if;
101: end pay_assignment_actions_bru;