TRIGGER: APPS.PA_MAITN_ORG_UPDATE_AFSTAT

Source

Description

"APPS"."PA_MAITN_ORG_UPDATE_AFSTAT" 
AFTER UPDATE
 ON  "HR"."PER_ORG_STRUCTURE_ELEMENTS#"  

Type

AFTER STATEMENT

Event

UPDATE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

DECLARE
  v_err_code number;
  v_err_stage varchar2(300);
  v_err_stack varchar2(300);
BEGIN
 if hr_general.g_data_migrator_mode <> 'Y' then
  IF (pa_imp.pa_implemented_all) THEN
    IF pa_org_utils.newRows.count > 0 THEN -- added for bug #11815106
    pa_org_utils.maintain_org_hist_update(
				          v_err_code,
				          v_err_stage,
				          v_err_stack);
    if  v_err_code < 0 then
      fnd_message.set_name('PA', 'PA_ALL_ORACLE_ERROR');
      fnd_message.set_token('errno', to_char(v_err_code));
      fnd_message.set_token('stage', v_err_stage);
      app_exception.raise_exception;
    elsif v_err_code > 0 then
      fnd_message.set_name('PA', v_err_stage);
      app_exception.raise_exception;
    end if;
   end if;
  END IF;
 end if;
END;