31: --
32: Begin
33: --
34: If (p_constraint_name = 'PAY_BATCH_LINES_FK3') Then
35: fnd_message.set_name('PAY', 'PAY_52680_BHT_INVALID_HEADER');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_BATCH_LINES_PK') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
39: fnd_message.set_token('PROCEDURE', l_proc);
32: Begin
33: --
34: If (p_constraint_name = 'PAY_BATCH_LINES_FK3') Then
35: fnd_message.set_name('PAY', 'PAY_52680_BHT_INVALID_HEADER');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_BATCH_LINES_PK') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','10');
34: If (p_constraint_name = 'PAY_BATCH_LINES_FK3') Then
35: fnd_message.set_name('PAY', 'PAY_52680_BHT_INVALID_HEADER');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_BATCH_LINES_PK') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','10');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PAY_BCHL_BATCH_LINE_STATUS_CHK') Then
35: fnd_message.set_name('PAY', 'PAY_52680_BHT_INVALID_HEADER');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_BATCH_LINES_PK') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','10');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PAY_BCHL_BATCH_LINE_STATUS_CHK') Then
43: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_BATCH_LINES_PK') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','10');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PAY_BCHL_BATCH_LINE_STATUS_CHK') Then
43: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
44: fnd_message.set_token('COLUMN_NAME','BATCH_LINE_STATUS');
37: ElsIf (p_constraint_name = 'PAY_BATCH_LINES_PK') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','10');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PAY_BCHL_BATCH_LINE_STATUS_CHK') Then
43: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
44: fnd_message.set_token('COLUMN_NAME','BATCH_LINE_STATUS');
45: fnd_message.raise_error;
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','10');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PAY_BCHL_BATCH_LINE_STATUS_CHK') Then
43: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
44: fnd_message.set_token('COLUMN_NAME','BATCH_LINE_STATUS');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'PAY_BCHL_ENTRY_TYPE_CHK') Then
47: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
40: fnd_message.set_token('STEP','10');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PAY_BCHL_BATCH_LINE_STATUS_CHK') Then
43: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
44: fnd_message.set_token('COLUMN_NAME','BATCH_LINE_STATUS');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'PAY_BCHL_ENTRY_TYPE_CHK') Then
47: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
48: fnd_message.set_token('COLUMN_NAME','ENTRY_TYPE');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PAY_BCHL_BATCH_LINE_STATUS_CHK') Then
43: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
44: fnd_message.set_token('COLUMN_NAME','BATCH_LINE_STATUS');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'PAY_BCHL_ENTRY_TYPE_CHK') Then
47: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
48: fnd_message.set_token('COLUMN_NAME','ENTRY_TYPE');
49: fnd_message.raise_error;
43: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
44: fnd_message.set_token('COLUMN_NAME','BATCH_LINE_STATUS');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'PAY_BCHL_ENTRY_TYPE_CHK') Then
47: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
48: fnd_message.set_token('COLUMN_NAME','ENTRY_TYPE');
49: fnd_message.raise_error;
50: Else
51: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
44: fnd_message.set_token('COLUMN_NAME','BATCH_LINE_STATUS');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'PAY_BCHL_ENTRY_TYPE_CHK') Then
47: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
48: fnd_message.set_token('COLUMN_NAME','ENTRY_TYPE');
49: fnd_message.raise_error;
50: Else
51: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
52: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'PAY_BCHL_ENTRY_TYPE_CHK') Then
47: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
48: fnd_message.set_token('COLUMN_NAME','ENTRY_TYPE');
49: fnd_message.raise_error;
50: Else
51: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
52: fnd_message.set_token('PROCEDURE', l_proc);
53: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
47: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
48: fnd_message.set_token('COLUMN_NAME','ENTRY_TYPE');
49: fnd_message.raise_error;
50: Else
51: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
52: fnd_message.set_token('PROCEDURE', l_proc);
53: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
54: fnd_message.raise_error;
55: End If;
48: fnd_message.set_token('COLUMN_NAME','ENTRY_TYPE');
49: fnd_message.raise_error;
50: Else
51: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
52: fnd_message.set_token('PROCEDURE', l_proc);
53: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
54: fnd_message.raise_error;
55: End If;
56: --
49: fnd_message.raise_error;
50: Else
51: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
52: fnd_message.set_token('PROCEDURE', l_proc);
53: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
54: fnd_message.raise_error;
55: End If;
56: --
57: End constraint_error;
50: Else
51: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
52: fnd_message.set_token('PROCEDURE', l_proc);
53: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
54: fnd_message.raise_error;
55: End If;
56: --
57: End constraint_error;
58: --
222: Close C_Sel1;
223: --
224: -- The primary key is invalid therefore we must error
225: --
226: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
227: fnd_message.raise_error;
228: End If;
229: Close C_Sel1;
230: If (p_object_version_number
223: --
224: -- The primary key is invalid therefore we must error
225: --
226: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
227: fnd_message.raise_error;
228: End If;
229: Close C_Sel1;
230: If (p_object_version_number
231: <> pay_btl_shd.g_old_rec.object_version_number) Then
228: End If;
229: Close C_Sel1;
230: If (p_object_version_number
231: <> pay_btl_shd.g_old_rec.object_version_number) Then
232: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
233: fnd_message.raise_error;
234: End If;
235: l_fct_ret := true;
236: End If;
229: Close C_Sel1;
230: If (p_object_version_number
231: <> pay_btl_shd.g_old_rec.object_version_number) Then
232: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
233: fnd_message.raise_error;
234: End If;
235: l_fct_ret := true;
236: End If;
237: End If;
388: Close C_Sel1;
389: --
390: -- The primary key is invalid therefore we must error
391: --
392: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
393: fnd_message.raise_error;
394: End If;
395: Close C_Sel1;
396: If (p_object_version_number
389: --
390: -- The primary key is invalid therefore we must error
391: --
392: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
393: fnd_message.raise_error;
394: End If;
395: Close C_Sel1;
396: If (p_object_version_number
397: <> pay_btl_shd.g_old_rec.object_version_number) Then
394: End If;
395: Close C_Sel1;
396: If (p_object_version_number
397: <> pay_btl_shd.g_old_rec.object_version_number) Then
398: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
399: fnd_message.raise_error;
400: End If;
401: --
402: hr_utility.set_location(' Leaving:'||l_proc, 10);
395: Close C_Sel1;
396: If (p_object_version_number
397: <> pay_btl_shd.g_old_rec.object_version_number) Then
398: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
399: fnd_message.raise_error;
400: End If;
401: --
402: hr_utility.set_location(' Leaving:'||l_proc, 10);
403: --
408: --
409: -- The object is locked therefore we need to supply a meaningful
410: -- error message.
411: --
412: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
413: fnd_message.set_token('TABLE_NAME', 'pay_batch_lines');
414: fnd_message.raise_error;
415: End lck;
416: --
409: -- The object is locked therefore we need to supply a meaningful
410: -- error message.
411: --
412: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
413: fnd_message.set_token('TABLE_NAME', 'pay_batch_lines');
414: fnd_message.raise_error;
415: End lck;
416: --
417: -- ----------------------------------------------------------------------------
410: -- error message.
411: --
412: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
413: fnd_message.set_token('TABLE_NAME', 'pay_batch_lines');
414: fnd_message.raise_error;
415: End lck;
416: --
417: -- ----------------------------------------------------------------------------
418: -- |-----------------------------< convert_args >-----------------------------|