DBA Data[Home] [Help]

APPS.PAY_OPM_SHD dependencies on FND_MESSAGE

Line 34: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');

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

Line 35: fnd_message.set_token('COLUMN_NAME', 'BUSINESS_GROUP_ID');

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');

Line 36: fnd_message.raise_error;

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');

Line 39: 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');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PAY_ORG_PAYMENT_METHODS_F_FK3') Then
43: -- RAISE ERROR MESSAGE

Line 40: fnd_message.set_token('COLUMN_NAME', 'EXTERNAL_ACCOUNT_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
44: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');

Line 41: 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');
45: fnd_message.set_token('COLUMN_NAME', 'PAYMENT_TYPE_ID');

Line 44: 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');
46: fnd_message.raise_error;
47: ElsIf (p_constraint_name = 'PAY_ORG_PAYMENT_METHODS_F_FK4') Then
48: -- RAISE ERROR MESSAGE

Line 45: fnd_message.set_token('COLUMN_NAME', 'PAYMENT_TYPE_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
49: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');

Line 46: 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');
50: fnd_message.set_token('COLUMN_NAME', 'DEFINED_BALANCE_ID');

Line 49: 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');
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');

Line 50: fnd_message.set_token('COLUMN_NAME', 'DEFINED_BALANCE_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');
54: fnd_message.set_token('PROCEDURE', l_proc);

Line 51: 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);
55: fnd_message.set_token('STEP','25');

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

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

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

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');

Line 55: fnd_message.set_token('STEP','25');

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);

Line 56: 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);
60: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);

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

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;

Line 59: 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;
63: --

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

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;

Line 61: 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;
65: --

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

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

Line 177: fnd_message.raise_error;

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

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

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;

Line 183: fnd_message.raise_error;

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;

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

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

Line 444: fnd_message.raise_error;

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

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

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

Line 450: fnd_message.raise_error;

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.

Line 469: fnd_message.set_name('PAY', 'HR_7202_COMMENT_TEXT_NOT_EXIST');

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;

Line 470: fnd_message.raise_error;

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: --

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

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;

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

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: --

Line 504: fnd_message.set_token('STEP','20');

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

Line 505: fnd_message.raise_error;

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: --

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

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: --

Line 524: fnd_message.set_token('TABLE_NAME', 'pay_org_payment_methods_f');

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: -- ----------------------------------------------------------------------------

Line 525: fnd_message.raise_error;

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 >-----------------------------|