DBA Data[Home] [Help]

APPS.PER_POSITION_STRUCTURES_PKG dependencies on FND_MESSAGE

Line 58: -- fnd_message.set_name('PER', 'HR_289296_SEC_PROF_SETUP_ERR');

54:
55: --
56: exception
57: when NO_DATA_FOUND then
58: -- fnd_message.set_name('PER', 'HR_289296_SEC_PROF_SETUP_ERR');
59: fnd_message.set_name('PER', 'HR_289521_GLOBAL_SEC_PROFILE');
60: fnd_message.raise_error;
61: end;
62: else

Line 59: fnd_message.set_name('PER', 'HR_289521_GLOBAL_SEC_PROFILE');

55: --
56: exception
57: when NO_DATA_FOUND then
58: -- fnd_message.set_name('PER', 'HR_289296_SEC_PROF_SETUP_ERR');
59: fnd_message.set_name('PER', 'HR_289521_GLOBAL_SEC_PROFILE');
60: fnd_message.raise_error;
61: end;
62: else
63: p_view_all_poss := 'Y';

Line 60: fnd_message.raise_error;

56: exception
57: when NO_DATA_FOUND then
58: -- fnd_message.set_name('PER', 'HR_289296_SEC_PROF_SETUP_ERR');
59: fnd_message.set_name('PER', 'HR_289521_GLOBAL_SEC_PROFILE');
60: fnd_message.raise_error;
61: end;
62: else
63: p_view_all_poss := 'Y';
64: p_security_profile_id := 0;

Line 85: fnd_message.set_name('PAY', 'PER_7901_SYS_DUPLICATE_RECORDS');

81: where (psp.rowid <> X_Rowid
82: or X_Rowid is null)
83: and upper(psp.name) = upper(X_Name)
84: and psp.business_group_id + 0 = X_Business_group_id);
85: fnd_message.set_name('PAY', 'PER_7901_SYS_DUPLICATE_RECORDS');
86: fnd_message.raise_error;
87: exception
88: when no_data_found then
89: null;

Line 86: fnd_message.raise_error;

82: or X_Rowid is null)
83: and upper(psp.name) = upper(X_Name)
84: and psp.business_group_id + 0 = X_Business_group_id);
85: fnd_message.set_name('PAY', 'PER_7901_SYS_DUPLICATE_RECORDS');
86: fnd_message.raise_error;
87: exception
88: when no_data_found then
89: null;
90: when others then

Line 150: fnd_message.set_name('PAY','HR_6084_PO_POS_HAS_HIER_VER');

146: select 1
147: from per_pos_structure_versions psv
148: where psv.position_structure_id = X_Position_Structure_Id);
149: --
150: fnd_message.set_name('PAY','HR_6084_PO_POS_HAS_HIER_VER');
151: fnd_message.raise_error;
152: --
153: exception
154: when no_data_found then

Line 151: fnd_message.raise_error;

147: from per_pos_structure_versions psv
148: where psv.position_structure_id = X_Position_Structure_Id);
149: --
150: fnd_message.set_name('PAY','HR_6084_PO_POS_HAS_HIER_VER');
151: fnd_message.raise_error;
152: --
153: exception
154: when no_data_found then
155: null;

Line 170: fnd_message.set_name('PAY','PAY_7694_PER_NO_DEL_STRUCTURE');

166: from per_security_profiles sec
167: where sec.business_group_id + 0 = X_Business_Group_Id
168: and sec.position_structure_id = X_Position_Structure_Id);
169: --
170: fnd_message.set_name('PAY','PAY_7694_PER_NO_DEL_STRUCTURE');
171: fnd_message.raise_error;
172: --
173: exception
174: when no_data_found then

Line 171: fnd_message.raise_error;

167: where sec.business_group_id + 0 = X_Business_Group_Id
168: and sec.position_structure_id = X_Position_Structure_Id);
169: --
170: fnd_message.set_name('PAY','PAY_7694_PER_NO_DEL_STRUCTURE');
171: fnd_message.raise_error;
172: --
173: exception
174: when no_data_found then
175: null;

Line 227: fnd_message.set_name('PER','HR_6048_PO_POS_DEL_POS_CONT');

223: l_rows_fetched := dbms_sql.execute(l_sql_cursor);
224: --
225: if (dbms_sql.fetch_rows(l_sql_cursor) > 0)
226: then
227: fnd_message.set_name('PER','HR_6048_PO_POS_DEL_POS_CONT');
228: fnd_message.raise_error;
229: end if;
230: --
231: -- Close cursor used for processing SQL statement.

Line 228: fnd_message.raise_error;

224: --
225: if (dbms_sql.fetch_rows(l_sql_cursor) > 0)
226: then
227: fnd_message.set_name('PER','HR_6048_PO_POS_DEL_POS_CONT');
228: fnd_message.raise_error;
229: end if;
230: --
231: -- Close cursor used for processing SQL statement.
232: --

Line 472: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');

468: AND (X_Attribute20 IS NULL)))
469: ) then
470: return;
471: else
472: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
473: APP_EXCEPTION.RAISE_EXCEPTION;
474: end if;
475: END Lock_Row;
476: