DBA Data[Home] [Help]

APPS.PAY_PUT_SHD dependencies on FND_MESSAGE

Line 101: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

97: --
98: Begin
99: --
100: If (p_constraint_name = 'PAY_USER_TABLES_PK') Then
101: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
102: fnd_message.set_token('PROCEDURE', l_proc);
103: fnd_message.set_token('STEP','5');
104: fnd_message.raise_error;
105: ElsIf (p_constraint_name = 'PAY_USER_TABLES_UK2') Then

Line 102: fnd_message.set_token('PROCEDURE', l_proc);

98: Begin
99: --
100: If (p_constraint_name = 'PAY_USER_TABLES_PK') Then
101: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
102: fnd_message.set_token('PROCEDURE', l_proc);
103: fnd_message.set_token('STEP','5');
104: fnd_message.raise_error;
105: ElsIf (p_constraint_name = 'PAY_USER_TABLES_UK2') Then
106: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 103: fnd_message.set_token('STEP','5');

99: --
100: If (p_constraint_name = 'PAY_USER_TABLES_PK') Then
101: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
102: fnd_message.set_token('PROCEDURE', l_proc);
103: fnd_message.set_token('STEP','5');
104: fnd_message.raise_error;
105: ElsIf (p_constraint_name = 'PAY_USER_TABLES_UK2') Then
106: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
107: fnd_message.set_token('PROCEDURE', l_proc);

Line 104: fnd_message.raise_error;

100: If (p_constraint_name = 'PAY_USER_TABLES_PK') Then
101: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
102: fnd_message.set_token('PROCEDURE', l_proc);
103: fnd_message.set_token('STEP','5');
104: fnd_message.raise_error;
105: ElsIf (p_constraint_name = 'PAY_USER_TABLES_UK2') Then
106: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
107: fnd_message.set_token('PROCEDURE', l_proc);
108: fnd_message.set_token('STEP','10');

Line 106: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

102: fnd_message.set_token('PROCEDURE', l_proc);
103: fnd_message.set_token('STEP','5');
104: fnd_message.raise_error;
105: ElsIf (p_constraint_name = 'PAY_USER_TABLES_UK2') Then
106: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
107: fnd_message.set_token('PROCEDURE', l_proc);
108: fnd_message.set_token('STEP','10');
109: fnd_message.raise_error;
110: ElsIf (p_constraint_name = 'PAY_UTAB_RANGE_OR_MATCH_CHK') Then

Line 107: fnd_message.set_token('PROCEDURE', l_proc);

103: fnd_message.set_token('STEP','5');
104: fnd_message.raise_error;
105: ElsIf (p_constraint_name = 'PAY_USER_TABLES_UK2') Then
106: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
107: fnd_message.set_token('PROCEDURE', l_proc);
108: fnd_message.set_token('STEP','10');
109: fnd_message.raise_error;
110: ElsIf (p_constraint_name = 'PAY_UTAB_RANGE_OR_MATCH_CHK') Then
111: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');

Line 108: fnd_message.set_token('STEP','10');

104: fnd_message.raise_error;
105: ElsIf (p_constraint_name = 'PAY_USER_TABLES_UK2') Then
106: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
107: fnd_message.set_token('PROCEDURE', l_proc);
108: fnd_message.set_token('STEP','10');
109: fnd_message.raise_error;
110: ElsIf (p_constraint_name = 'PAY_UTAB_RANGE_OR_MATCH_CHK') Then
111: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
112: fnd_message.set_token('COLUMN', 'RANGE_OR_MATCH');

Line 109: fnd_message.raise_error;

105: ElsIf (p_constraint_name = 'PAY_USER_TABLES_UK2') Then
106: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
107: fnd_message.set_token('PROCEDURE', l_proc);
108: fnd_message.set_token('STEP','10');
109: fnd_message.raise_error;
110: ElsIf (p_constraint_name = 'PAY_UTAB_RANGE_OR_MATCH_CHK') Then
111: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
112: fnd_message.set_token('COLUMN', 'RANGE_OR_MATCH');
113: fnd_message.set_token('LOOKUP_TYPE','RANGE_MATCH');

Line 111: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');

107: fnd_message.set_token('PROCEDURE', l_proc);
108: fnd_message.set_token('STEP','10');
109: fnd_message.raise_error;
110: ElsIf (p_constraint_name = 'PAY_UTAB_RANGE_OR_MATCH_CHK') Then
111: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
112: fnd_message.set_token('COLUMN', 'RANGE_OR_MATCH');
113: fnd_message.set_token('LOOKUP_TYPE','RANGE_MATCH');
114: fnd_message.raise_error;
115: ElsIf (p_constraint_name = 'PAY_UTAB_USER_KEY_UNITS_CHK') Then

Line 112: fnd_message.set_token('COLUMN', 'RANGE_OR_MATCH');

108: fnd_message.set_token('STEP','10');
109: fnd_message.raise_error;
110: ElsIf (p_constraint_name = 'PAY_UTAB_RANGE_OR_MATCH_CHK') Then
111: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
112: fnd_message.set_token('COLUMN', 'RANGE_OR_MATCH');
113: fnd_message.set_token('LOOKUP_TYPE','RANGE_MATCH');
114: fnd_message.raise_error;
115: ElsIf (p_constraint_name = 'PAY_UTAB_USER_KEY_UNITS_CHK') Then
116: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');

Line 113: fnd_message.set_token('LOOKUP_TYPE','RANGE_MATCH');

109: fnd_message.raise_error;
110: ElsIf (p_constraint_name = 'PAY_UTAB_RANGE_OR_MATCH_CHK') Then
111: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
112: fnd_message.set_token('COLUMN', 'RANGE_OR_MATCH');
113: fnd_message.set_token('LOOKUP_TYPE','RANGE_MATCH');
114: fnd_message.raise_error;
115: ElsIf (p_constraint_name = 'PAY_UTAB_USER_KEY_UNITS_CHK') Then
116: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
117: fnd_message.set_token('COLUMN', 'USER_KEY_UNITS');

Line 114: fnd_message.raise_error;

110: ElsIf (p_constraint_name = 'PAY_UTAB_RANGE_OR_MATCH_CHK') Then
111: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
112: fnd_message.set_token('COLUMN', 'RANGE_OR_MATCH');
113: fnd_message.set_token('LOOKUP_TYPE','RANGE_MATCH');
114: fnd_message.raise_error;
115: ElsIf (p_constraint_name = 'PAY_UTAB_USER_KEY_UNITS_CHK') Then
116: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
117: fnd_message.set_token('COLUMN', 'USER_KEY_UNITS');
118: fnd_message.set_token('LOOKUP_TYPE','DATA_TYPE');

Line 116: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');

112: fnd_message.set_token('COLUMN', 'RANGE_OR_MATCH');
113: fnd_message.set_token('LOOKUP_TYPE','RANGE_MATCH');
114: fnd_message.raise_error;
115: ElsIf (p_constraint_name = 'PAY_UTAB_USER_KEY_UNITS_CHK') Then
116: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
117: fnd_message.set_token('COLUMN', 'USER_KEY_UNITS');
118: fnd_message.set_token('LOOKUP_TYPE','DATA_TYPE');
119: fnd_message.raise_error;
120: Else

Line 117: fnd_message.set_token('COLUMN', 'USER_KEY_UNITS');

113: fnd_message.set_token('LOOKUP_TYPE','RANGE_MATCH');
114: fnd_message.raise_error;
115: ElsIf (p_constraint_name = 'PAY_UTAB_USER_KEY_UNITS_CHK') Then
116: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
117: fnd_message.set_token('COLUMN', 'USER_KEY_UNITS');
118: fnd_message.set_token('LOOKUP_TYPE','DATA_TYPE');
119: fnd_message.raise_error;
120: Else
121: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');

Line 118: fnd_message.set_token('LOOKUP_TYPE','DATA_TYPE');

114: fnd_message.raise_error;
115: ElsIf (p_constraint_name = 'PAY_UTAB_USER_KEY_UNITS_CHK') Then
116: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
117: fnd_message.set_token('COLUMN', 'USER_KEY_UNITS');
118: fnd_message.set_token('LOOKUP_TYPE','DATA_TYPE');
119: fnd_message.raise_error;
120: Else
121: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
122: fnd_message.set_token('PROCEDURE', l_proc);

Line 119: fnd_message.raise_error;

115: ElsIf (p_constraint_name = 'PAY_UTAB_USER_KEY_UNITS_CHK') Then
116: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
117: fnd_message.set_token('COLUMN', 'USER_KEY_UNITS');
118: fnd_message.set_token('LOOKUP_TYPE','DATA_TYPE');
119: fnd_message.raise_error;
120: Else
121: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
122: fnd_message.set_token('PROCEDURE', l_proc);
123: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);

Line 121: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');

117: fnd_message.set_token('COLUMN', 'USER_KEY_UNITS');
118: fnd_message.set_token('LOOKUP_TYPE','DATA_TYPE');
119: fnd_message.raise_error;
120: Else
121: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
122: fnd_message.set_token('PROCEDURE', l_proc);
123: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
124: fnd_message.raise_error;
125: End If;

Line 122: fnd_message.set_token('PROCEDURE', l_proc);

118: fnd_message.set_token('LOOKUP_TYPE','DATA_TYPE');
119: fnd_message.raise_error;
120: Else
121: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
122: fnd_message.set_token('PROCEDURE', l_proc);
123: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
124: fnd_message.raise_error;
125: End If;
126: --

Line 123: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);

119: fnd_message.raise_error;
120: Else
121: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
122: fnd_message.set_token('PROCEDURE', l_proc);
123: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
124: fnd_message.raise_error;
125: End If;
126: --
127: End constraint_error;

Line 124: fnd_message.raise_error;

120: Else
121: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
122: fnd_message.set_token('PROCEDURE', l_proc);
123: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
124: fnd_message.raise_error;
125: End If;
126: --
127: End constraint_error;
128: --

Line 188: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');

184: Close C_Sel1;
185: --
186: -- The primary key is invalid therefore we must error
187: --
188: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
189: fnd_message.raise_error;
190: End If;
191: Close C_Sel1;
192: If (p_object_version_number

Line 189: fnd_message.raise_error;

185: --
186: -- The primary key is invalid therefore we must error
187: --
188: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
189: fnd_message.raise_error;
190: End If;
191: Close C_Sel1;
192: If (p_object_version_number
193: <> pay_put_shd.g_old_rec.object_version_number) Then

Line 194: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');

190: End If;
191: Close C_Sel1;
192: If (p_object_version_number
193: <> pay_put_shd.g_old_rec.object_version_number) Then
194: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
195: fnd_message.raise_error;
196: End If;
197: l_fct_ret := true;
198: End If;

Line 195: fnd_message.raise_error;

191: Close C_Sel1;
192: If (p_object_version_number
193: <> pay_put_shd.g_old_rec.object_version_number) Then
194: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
195: fnd_message.raise_error;
196: End If;
197: l_fct_ret := true;
198: End If;
199: End If;

Line 252: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');

248: Close C_Sel1;
249: --
250: -- The primary key is invalid therefore we must error
251: --
252: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
253: fnd_message.raise_error;
254: End If;
255: Close C_Sel1;
256: If (p_object_version_number

Line 253: fnd_message.raise_error;

249: --
250: -- The primary key is invalid therefore we must error
251: --
252: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
253: fnd_message.raise_error;
254: End If;
255: Close C_Sel1;
256: If (p_object_version_number
257: <> pay_put_shd.g_old_rec.object_version_number) Then

Line 258: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');

254: End If;
255: Close C_Sel1;
256: If (p_object_version_number
257: <> pay_put_shd.g_old_rec.object_version_number) Then
258: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
259: fnd_message.raise_error;
260: End If;
261: --
262: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 259: fnd_message.raise_error;

255: Close C_Sel1;
256: If (p_object_version_number
257: <> pay_put_shd.g_old_rec.object_version_number) Then
258: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
259: fnd_message.raise_error;
260: End If;
261: --
262: hr_utility.set_location(' Leaving:'||l_proc, 10);
263: --

Line 272: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');

268: --
269: -- The object is locked therefore we need to supply a meaningful
270: -- error message.
271: --
272: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
273: fnd_message.set_token('TABLE_NAME', 'pay_user_tables');
274: fnd_message.raise_error;
275: End lck;
276: --

Line 273: fnd_message.set_token('TABLE_NAME', 'pay_user_tables');

269: -- The object is locked therefore we need to supply a meaningful
270: -- error message.
271: --
272: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
273: fnd_message.set_token('TABLE_NAME', 'pay_user_tables');
274: fnd_message.raise_error;
275: End lck;
276: --
277: -- ----------------------------------------------------------------------------

Line 274: fnd_message.raise_error;

270: -- error message.
271: --
272: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
273: fnd_message.set_token('TABLE_NAME', 'pay_user_tables');
274: fnd_message.raise_error;
275: End lck;
276: --
277: -- ----------------------------------------------------------------------------
278: -- |-----------------------------< convert_args >-----------------------------|