1094: ---Create the Audit_Procedure_Association
1095: ---
1096: IF ((NOT v_error_found) AND (rc_rec.ap_name IS NOT NULL)) THEN
1097: if(rc_rec.design_effectiveness = 'N' and rc_rec.op_effectiveness = 'N') then
1098: ---fnd_message.set_name('AMW','AMW_ASSOC_AP_EFF_WEBADI_MSG');
1099: v_err_msg := fnd_message.GET_STRING('AMW','AMW_ASSOC_AP_EFF_WEBADI_MSG');
1100: ---v_err_msg := fnd_message.get;
1101: update_interface_with_error (v_err_msg
1102: ,v_table_name
1095: ---
1096: IF ((NOT v_error_found) AND (rc_rec.ap_name IS NOT NULL)) THEN
1097: if(rc_rec.design_effectiveness = 'N' and rc_rec.op_effectiveness = 'N') then
1098: ---fnd_message.set_name('AMW','AMW_ASSOC_AP_EFF_WEBADI_MSG');
1099: v_err_msg := fnd_message.GET_STRING('AMW','AMW_ASSOC_AP_EFF_WEBADI_MSG');
1100: ---v_err_msg := fnd_message.get;
1101: update_interface_with_error (v_err_msg
1102: ,v_table_name
1103: ,v_interface_id);
1096: IF ((NOT v_error_found) AND (rc_rec.ap_name IS NOT NULL)) THEN
1097: if(rc_rec.design_effectiveness = 'N' and rc_rec.op_effectiveness = 'N') then
1098: ---fnd_message.set_name('AMW','AMW_ASSOC_AP_EFF_WEBADI_MSG');
1099: v_err_msg := fnd_message.GET_STRING('AMW','AMW_ASSOC_AP_EFF_WEBADI_MSG');
1100: ---v_err_msg := fnd_message.get;
1101: update_interface_with_error (v_err_msg
1102: ,v_table_name
1103: ,v_interface_id);
1104: else
1734: , 'Invalid Risk Type.');
1735:
1736: BEGIN
1737: IF v_invalid_risk_type is null THEN
1738: v_invalid_risk_type := FND_MESSAGE.GET_STRING('AMW', 'AMW_INVALID_RISK_TYPE');
1739: END IF;
1740: UPDATE amw_risk_ctrl_interface
1741: SET error_flag = 'Y'
1742: ,interface_status = v_invalid_risk_type
1753: , 'Invalid requestor id.');
1754:
1755: BEGIN
1756: IF v_invalid_requestor_msg is null THEN
1757: v_invalid_requestor_msg := FND_MESSAGE.GET_STRING('AMW', 'AMW_UNKNOWN_EMPLOYEE');
1758: END IF;
1759: UPDATE amw_risk_ctrl_interface
1760: SET error_flag = 'Y'
1761: ,interface_status = v_invalid_requestor_msg
1770: , 'no import privilege');
1771:
1772: BEGIN
1773: IF v_no_import_privilege_msg is null THEN
1774: v_no_import_privilege_msg := FND_MESSAGE.GET_STRING('AMW', 'AMW_NO_IMPORT_ACCESS');
1775: END IF;
1776: UPDATE amw_risk_ctrl_interface
1777: SET error_flag = 'Y'
1778: ,interface_status = v_no_import_privilege_msg