30: Begin
31: --
32: If (p_constraint_name = 'PAY_ORG_PAYMENT_METHODS_F_FK1') Then
33: -- RAISE ERROR MESSAGE
34: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
35: fnd_message.set_token('COLUMN_NAME', 'BUSINESS_GROUP_ID');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_ORG_PAYMENT_METHODS_F_FK2') Then
38: -- RAISE ERROR MESSAGE
31: --
32: If (p_constraint_name = 'PAY_ORG_PAYMENT_METHODS_F_FK1') Then
33: -- RAISE ERROR MESSAGE
34: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
35: fnd_message.set_token('COLUMN_NAME', 'BUSINESS_GROUP_ID');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_ORG_PAYMENT_METHODS_F_FK2') Then
38: -- RAISE ERROR MESSAGE
39: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
32: If (p_constraint_name = 'PAY_ORG_PAYMENT_METHODS_F_FK1') Then
33: -- RAISE ERROR MESSAGE
34: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
35: fnd_message.set_token('COLUMN_NAME', 'BUSINESS_GROUP_ID');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_ORG_PAYMENT_METHODS_F_FK2') Then
38: -- RAISE ERROR MESSAGE
39: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
40: fnd_message.set_token('COLUMN_NAME', 'EXTERNAL_ACCOUNT_ID');
35: fnd_message.set_token('COLUMN_NAME', 'BUSINESS_GROUP_ID');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_ORG_PAYMENT_METHODS_F_FK2') Then
38: -- RAISE ERROR MESSAGE
39: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
40: fnd_message.set_token('COLUMN_NAME', 'EXTERNAL_ACCOUNT_ID');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PAY_ORG_PAYMENT_METHODS_F_FK3') Then
43: -- RAISE ERROR MESSAGE
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_ORG_PAYMENT_METHODS_F_FK2') Then
38: -- RAISE ERROR MESSAGE
39: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
40: fnd_message.set_token('COLUMN_NAME', 'EXTERNAL_ACCOUNT_ID');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PAY_ORG_PAYMENT_METHODS_F_FK3') Then
43: -- RAISE ERROR MESSAGE
44: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
37: ElsIf (p_constraint_name = 'PAY_ORG_PAYMENT_METHODS_F_FK2') Then
38: -- RAISE ERROR MESSAGE
39: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
40: fnd_message.set_token('COLUMN_NAME', 'EXTERNAL_ACCOUNT_ID');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PAY_ORG_PAYMENT_METHODS_F_FK3') Then
43: -- RAISE ERROR MESSAGE
44: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
45: fnd_message.set_token('COLUMN_NAME', 'PAYMENT_TYPE_ID');
40: fnd_message.set_token('COLUMN_NAME', 'EXTERNAL_ACCOUNT_ID');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PAY_ORG_PAYMENT_METHODS_F_FK3') Then
43: -- RAISE ERROR MESSAGE
44: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
45: fnd_message.set_token('COLUMN_NAME', 'PAYMENT_TYPE_ID');
46: fnd_message.raise_error;
47: ElsIf (p_constraint_name = 'PAY_ORG_PAYMENT_METHODS_F_FK4') Then
48: -- RAISE ERROR MESSAGE
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PAY_ORG_PAYMENT_METHODS_F_FK3') Then
43: -- RAISE ERROR MESSAGE
44: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
45: fnd_message.set_token('COLUMN_NAME', 'PAYMENT_TYPE_ID');
46: fnd_message.raise_error;
47: ElsIf (p_constraint_name = 'PAY_ORG_PAYMENT_METHODS_F_FK4') Then
48: -- RAISE ERROR MESSAGE
49: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
42: ElsIf (p_constraint_name = 'PAY_ORG_PAYMENT_METHODS_F_FK3') Then
43: -- RAISE ERROR MESSAGE
44: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
45: fnd_message.set_token('COLUMN_NAME', 'PAYMENT_TYPE_ID');
46: fnd_message.raise_error;
47: ElsIf (p_constraint_name = 'PAY_ORG_PAYMENT_METHODS_F_FK4') Then
48: -- RAISE ERROR MESSAGE
49: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
50: fnd_message.set_token('COLUMN_NAME', 'DEFINED_BALANCE_ID');
45: fnd_message.set_token('COLUMN_NAME', 'PAYMENT_TYPE_ID');
46: fnd_message.raise_error;
47: ElsIf (p_constraint_name = 'PAY_ORG_PAYMENT_METHODS_F_FK4') Then
48: -- RAISE ERROR MESSAGE
49: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
50: fnd_message.set_token('COLUMN_NAME', 'DEFINED_BALANCE_ID');
51: fnd_message.raise_error;
52: ElsIf (p_constraint_name = 'PAY_ORG_PAYMENT_METHODS_F_PK') Then
53: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
46: fnd_message.raise_error;
47: ElsIf (p_constraint_name = 'PAY_ORG_PAYMENT_METHODS_F_FK4') Then
48: -- RAISE ERROR MESSAGE
49: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
50: fnd_message.set_token('COLUMN_NAME', 'DEFINED_BALANCE_ID');
51: fnd_message.raise_error;
52: ElsIf (p_constraint_name = 'PAY_ORG_PAYMENT_METHODS_F_PK') Then
53: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
54: fnd_message.set_token('PROCEDURE', l_proc);
47: ElsIf (p_constraint_name = 'PAY_ORG_PAYMENT_METHODS_F_FK4') Then
48: -- RAISE ERROR MESSAGE
49: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
50: fnd_message.set_token('COLUMN_NAME', 'DEFINED_BALANCE_ID');
51: fnd_message.raise_error;
52: ElsIf (p_constraint_name = 'PAY_ORG_PAYMENT_METHODS_F_PK') Then
53: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
54: fnd_message.set_token('PROCEDURE', l_proc);
55: fnd_message.set_token('STEP','25');
49: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
50: fnd_message.set_token('COLUMN_NAME', 'DEFINED_BALANCE_ID');
51: fnd_message.raise_error;
52: ElsIf (p_constraint_name = 'PAY_ORG_PAYMENT_METHODS_F_PK') Then
53: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
54: fnd_message.set_token('PROCEDURE', l_proc);
55: fnd_message.set_token('STEP','25');
56: fnd_message.raise_error;
57: Else
50: fnd_message.set_token('COLUMN_NAME', 'DEFINED_BALANCE_ID');
51: fnd_message.raise_error;
52: ElsIf (p_constraint_name = 'PAY_ORG_PAYMENT_METHODS_F_PK') Then
53: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
54: fnd_message.set_token('PROCEDURE', l_proc);
55: fnd_message.set_token('STEP','25');
56: fnd_message.raise_error;
57: Else
58: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
51: fnd_message.raise_error;
52: ElsIf (p_constraint_name = 'PAY_ORG_PAYMENT_METHODS_F_PK') Then
53: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
54: fnd_message.set_token('PROCEDURE', l_proc);
55: fnd_message.set_token('STEP','25');
56: fnd_message.raise_error;
57: Else
58: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
59: fnd_message.set_token('PROCEDURE', l_proc);
52: ElsIf (p_constraint_name = 'PAY_ORG_PAYMENT_METHODS_F_PK') Then
53: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
54: fnd_message.set_token('PROCEDURE', l_proc);
55: fnd_message.set_token('STEP','25');
56: fnd_message.raise_error;
57: Else
58: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
59: fnd_message.set_token('PROCEDURE', l_proc);
60: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
54: fnd_message.set_token('PROCEDURE', l_proc);
55: fnd_message.set_token('STEP','25');
56: fnd_message.raise_error;
57: Else
58: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
59: fnd_message.set_token('PROCEDURE', l_proc);
60: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
61: fnd_message.raise_error;
62: End If;
55: fnd_message.set_token('STEP','25');
56: fnd_message.raise_error;
57: Else
58: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
59: fnd_message.set_token('PROCEDURE', l_proc);
60: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
61: fnd_message.raise_error;
62: End If;
63: --
56: fnd_message.raise_error;
57: Else
58: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
59: fnd_message.set_token('PROCEDURE', l_proc);
60: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
61: fnd_message.raise_error;
62: End If;
63: --
64: End constraint_error;
57: Else
58: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
59: fnd_message.set_token('PROCEDURE', l_proc);
60: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
61: fnd_message.raise_error;
62: End If;
63: --
64: End constraint_error;
65: --
172: Close C_Sel1;
173: --
174: -- The primary key is invalid therefore we must error
175: --
176: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
177: fnd_message.raise_error;
178: End If;
179: Close C_Sel1;
180: If (p_object_version_number
173: --
174: -- The primary key is invalid therefore we must error
175: --
176: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
177: fnd_message.raise_error;
178: End If;
179: Close C_Sel1;
180: If (p_object_version_number
181: <> pay_opm_shd.g_old_rec.object_version_number) Then
178: End If;
179: Close C_Sel1;
180: If (p_object_version_number
181: <> pay_opm_shd.g_old_rec.object_version_number) Then
182: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
183: fnd_message.raise_error;
184: End If;
185: l_fct_ret := true;
186: End If;
179: Close C_Sel1;
180: If (p_object_version_number
181: <> pay_opm_shd.g_old_rec.object_version_number) Then
182: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
183: fnd_message.raise_error;
184: End If;
185: l_fct_ret := true;
186: End If;
187: End If;
439: Close C_Sel1;
440: --
441: -- The primary key is invalid therefore we must error
442: --
443: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
444: fnd_message.raise_error;
445: End If;
446: Close C_Sel1;
447: If (p_object_version_number
440: --
441: -- The primary key is invalid therefore we must error
442: --
443: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
444: fnd_message.raise_error;
445: End If;
446: Close C_Sel1;
447: If (p_object_version_number
448: <> pay_opm_shd.g_old_rec.object_version_number) Then
445: End If;
446: Close C_Sel1;
447: If (p_object_version_number
448: <> pay_opm_shd.g_old_rec.object_version_number) Then
449: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
450: fnd_message.raise_error;
451: End If;
452: --
453: -- Providing we are doing an update and a comment_id exists then
446: Close C_Sel1;
447: If (p_object_version_number
448: <> pay_opm_shd.g_old_rec.object_version_number) Then
449: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
450: fnd_message.raise_error;
451: End If;
452: --
453: -- Providing we are doing an update and a comment_id exists then
454: -- we select the comment text.
465: -- The comments for the specified comment_id does not exist.
466: -- We must error due to data integrity problems.
467: --
468: Close C_Sel3;
469: fnd_message.set_name('PAY', 'HR_7202_COMMENT_TEXT_NOT_EXIST');
470: fnd_message.raise_error;
471: End If;
472: Close C_Sel3;
473: End If;
466: -- We must error due to data integrity problems.
467: --
468: Close C_Sel3;
469: fnd_message.set_name('PAY', 'HR_7202_COMMENT_TEXT_NOT_EXIST');
470: fnd_message.raise_error;
471: End If;
472: Close C_Sel3;
473: End If;
474: --
498: -- We are doing a datetrack 'INSERT' which is illegal within this
499: -- procedure therefore we must error (note: to lck on insert the
500: -- private procedure ins_lck should be called).
501: --
502: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
503: fnd_message.set_token('PROCEDURE', l_proc);
504: fnd_message.set_token('STEP','20');
505: fnd_message.raise_error;
506: End If;
499: -- procedure therefore we must error (note: to lck on insert the
500: -- private procedure ins_lck should be called).
501: --
502: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
503: fnd_message.set_token('PROCEDURE', l_proc);
504: fnd_message.set_token('STEP','20');
505: fnd_message.raise_error;
506: End If;
507: --
500: -- private procedure ins_lck should be called).
501: --
502: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
503: fnd_message.set_token('PROCEDURE', l_proc);
504: fnd_message.set_token('STEP','20');
505: fnd_message.raise_error;
506: End If;
507: --
508: -- Set the validation start and end date OUT arguments
501: --
502: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
503: fnd_message.set_token('PROCEDURE', l_proc);
504: fnd_message.set_token('STEP','20');
505: fnd_message.raise_error;
506: End If;
507: --
508: -- Set the validation start and end date OUT arguments
509: --
519: --
520: -- The object is locked therefore we need to supply a meaningful
521: -- error message.
522: --
523: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
524: fnd_message.set_token('TABLE_NAME', 'pay_org_payment_methods_f');
525: fnd_message.raise_error;
526: End lck;
527: --
520: -- The object is locked therefore we need to supply a meaningful
521: -- error message.
522: --
523: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
524: fnd_message.set_token('TABLE_NAME', 'pay_org_payment_methods_f');
525: fnd_message.raise_error;
526: End lck;
527: --
528: -- ----------------------------------------------------------------------------
521: -- error message.
522: --
523: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
524: fnd_message.set_token('TABLE_NAME', 'pay_org_payment_methods_f');
525: fnd_message.raise_error;
526: End lck;
527: --
528: -- ----------------------------------------------------------------------------
529: -- |-----------------------------< convert_args >-----------------------------|