29: --
30: Begin
31: --
32: If (p_constraint_name = 'PAY_SPR_PROCESSING_RULE_CHK') Then
33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_FK2') Then
30: Begin
31: --
32: If (p_constraint_name = 'PAY_SPR_PROCESSING_RULE_CHK') Then
33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_FK2') Then
38: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
31: --
32: If (p_constraint_name = 'PAY_SPR_PROCESSING_RULE_CHK') Then
33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_FK2') Then
38: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
39: fnd_message.set_token('COLUMN_NAME', 'ASSIGNMENT_STATUS_TYPE_ID');
32: If (p_constraint_name = 'PAY_SPR_PROCESSING_RULE_CHK') Then
33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_FK2') Then
38: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
39: fnd_message.set_token('COLUMN_NAME', 'ASSIGNMENT_STATUS_TYPE_ID');
40: fnd_message.raise_error;
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_FK2') Then
38: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
39: fnd_message.set_token('COLUMN_NAME', 'ASSIGNMENT_STATUS_TYPE_ID');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_PK') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_FK2') Then
38: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
39: fnd_message.set_token('COLUMN_NAME', 'ASSIGNMENT_STATUS_TYPE_ID');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_PK') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_FK2') Then
38: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
39: fnd_message.set_token('COLUMN_NAME', 'ASSIGNMENT_STATUS_TYPE_ID');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_PK') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','15');
38: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
39: fnd_message.set_token('COLUMN_NAME', 'ASSIGNMENT_STATUS_TYPE_ID');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_PK') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','15');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_UK2') Then
39: fnd_message.set_token('COLUMN_NAME', 'ASSIGNMENT_STATUS_TYPE_ID');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_PK') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','15');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_UK2') Then
47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_PK') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','15');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_UK2') Then
47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
48: fnd_message.set_token('PROCEDURE', l_proc);
41: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_PK') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','15');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_UK2') Then
47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('STEP','20');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','15');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_UK2') Then
47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('STEP','20');
50: fnd_message.raise_error;
51: Else
44: fnd_message.set_token('STEP','15');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_UK2') Then
47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('STEP','20');
50: fnd_message.raise_error;
51: Else
52: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_UK2') Then
47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('STEP','20');
50: fnd_message.raise_error;
51: Else
52: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
53: fnd_message.set_token('PROCEDURE', l_proc);
46: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_UK2') Then
47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('STEP','20');
50: fnd_message.raise_error;
51: Else
52: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
53: fnd_message.set_token('PROCEDURE', l_proc);
54: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('STEP','20');
50: fnd_message.raise_error;
51: Else
52: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
53: fnd_message.set_token('PROCEDURE', l_proc);
54: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
55: fnd_message.raise_error;
56: End If;
49: fnd_message.set_token('STEP','20');
50: fnd_message.raise_error;
51: Else
52: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
53: fnd_message.set_token('PROCEDURE', l_proc);
54: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
55: fnd_message.raise_error;
56: End If;
57: --
50: fnd_message.raise_error;
51: Else
52: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
53: fnd_message.set_token('PROCEDURE', l_proc);
54: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
55: fnd_message.raise_error;
56: End If;
57: --
58: End constraint_error;
51: Else
52: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
53: fnd_message.set_token('PROCEDURE', l_proc);
54: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
55: fnd_message.raise_error;
56: End If;
57: --
58: End constraint_error;
59: --
121: Close C_Sel1;
122: --
123: -- The primary key is invalid therefore we must error
124: --
125: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
126: fnd_message.raise_error;
127: End If;
128: Close C_Sel1;
129: If (p_object_version_number
122: --
123: -- The primary key is invalid therefore we must error
124: --
125: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
126: fnd_message.raise_error;
127: End If;
128: Close C_Sel1;
129: If (p_object_version_number
130: <> pay_ppr_shd.g_old_rec.object_version_number) Then
127: End If;
128: Close C_Sel1;
129: If (p_object_version_number
130: <> pay_ppr_shd.g_old_rec.object_version_number) Then
131: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
132: fnd_message.raise_error;
133: End If;
134: l_fct_ret := true;
135: End If;
128: Close C_Sel1;
129: If (p_object_version_number
130: <> pay_ppr_shd.g_old_rec.object_version_number) Then
131: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
132: fnd_message.raise_error;
133: End If;
134: l_fct_ret := true;
135: End If;
136: End If;
342: Close C_Sel1;
343: --
344: -- The primary key is invalid therefore we must error
345: --
346: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
347: fnd_message.raise_error;
348: End If;
349: Close C_Sel1;
350: If (p_object_version_number
343: --
344: -- The primary key is invalid therefore we must error
345: --
346: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
347: fnd_message.raise_error;
348: End If;
349: Close C_Sel1;
350: If (p_object_version_number
351: <> pay_ppr_shd.g_old_rec.object_version_number) Then
348: End If;
349: Close C_Sel1;
350: If (p_object_version_number
351: <> pay_ppr_shd.g_old_rec.object_version_number) Then
352: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
353: fnd_message.raise_error;
354: End If;
355: --
356: -- Providing we are doing an update and a comment_id exists then
349: Close C_Sel1;
350: If (p_object_version_number
351: <> pay_ppr_shd.g_old_rec.object_version_number) Then
352: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
353: fnd_message.raise_error;
354: End If;
355: --
356: -- Providing we are doing an update and a comment_id exists then
357: -- we select the comment text.
368: -- The comments for the specified comment_id does not exist.
369: -- We must error due to data integrity problems.
370: --
371: Close C_Sel3;
372: fnd_message.set_name('PAY', 'HR_7202_COMMENT_TEXT_NOT_EXIST');
373: fnd_message.raise_error;
374: End If;
375: Close C_Sel3;
376: End If;
369: -- We must error due to data integrity problems.
370: --
371: Close C_Sel3;
372: fnd_message.set_name('PAY', 'HR_7202_COMMENT_TEXT_NOT_EXIST');
373: fnd_message.raise_error;
374: End If;
375: Close C_Sel3;
376: End If;
377: --
394: -- We are doing a datetrack 'INSERT' which is illegal within this
395: -- procedure therefore we must error (note: to lck on insert the
396: -- private procedure ins_lck should be called).
397: --
398: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
399: fnd_message.set_token('PROCEDURE', l_proc);
400: fnd_message.set_token('STEP','20');
401: fnd_message.raise_error;
402: End If;
395: -- procedure therefore we must error (note: to lck on insert the
396: -- private procedure ins_lck should be called).
397: --
398: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
399: fnd_message.set_token('PROCEDURE', l_proc);
400: fnd_message.set_token('STEP','20');
401: fnd_message.raise_error;
402: End If;
403: --
396: -- private procedure ins_lck should be called).
397: --
398: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
399: fnd_message.set_token('PROCEDURE', l_proc);
400: fnd_message.set_token('STEP','20');
401: fnd_message.raise_error;
402: End If;
403: --
404: -- Set the validation start and end date OUT arguments
397: --
398: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
399: fnd_message.set_token('PROCEDURE', l_proc);
400: fnd_message.set_token('STEP','20');
401: fnd_message.raise_error;
402: End If;
403: --
404: -- Set the validation start and end date OUT arguments
405: --
415: --
416: -- The object is locked therefore we need to supply a meaningful
417: -- error message.
418: --
419: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
420: fnd_message.set_token('TABLE_NAME', 'pay_status_processing_rules_f');
421: fnd_message.raise_error;
422: End lck;
423: --
416: -- The object is locked therefore we need to supply a meaningful
417: -- error message.
418: --
419: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
420: fnd_message.set_token('TABLE_NAME', 'pay_status_processing_rules_f');
421: fnd_message.raise_error;
422: End lck;
423: --
424: -- ----------------------------------------------------------------------------
417: -- error message.
418: --
419: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
420: fnd_message.set_token('TABLE_NAME', 'pay_status_processing_rules_f');
421: fnd_message.raise_error;
422: End lck;
423: --
424: -- ----------------------------------------------------------------------------
425: -- |-----------------------------< convert_args >-----------------------------|