DBA Data[Home] [Help]

APPS.PAY_ETP_SHD dependencies on FND_MESSAGE

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

29: --
30: Begin
31: --
32: If (p_constraint_name = 'PAY_ELEMENT_ADDITIONAL_ENT_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_ELEMENT_ADJUSTMENT_ONL_CHK') Then

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

30: Begin
31: --
32: If (p_constraint_name = 'PAY_ELEMENT_ADDITIONAL_ENT_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_ELEMENT_ADJUSTMENT_ONL_CHK') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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

31: --
32: If (p_constraint_name = 'PAY_ELEMENT_ADDITIONAL_ENT_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_ELEMENT_ADJUSTMENT_ONL_CHK') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
39: fnd_message.set_token('PROCEDURE', l_proc);

Line 36: fnd_message.raise_error;

32: If (p_constraint_name = 'PAY_ELEMENT_ADDITIONAL_ENT_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_ELEMENT_ADJUSTMENT_ONL_CHK') 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');

Line 38: 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_ELEMENT_ADJUSTMENT_ONL_CHK') 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_ELEMENT_CLOSED_FOR_ENT_CHK') Then

Line 39: 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_ELEMENT_ADJUSTMENT_ONL_CHK') 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_ELEMENT_CLOSED_FOR_ENT_CHK') Then
43: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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

36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_ELEMENT_ADJUSTMENT_ONL_CHK') 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_ELEMENT_CLOSED_FOR_ENT_CHK') Then
43: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
44: fnd_message.set_token('PROCEDURE', l_proc);

Line 41: fnd_message.raise_error;

37: ElsIf (p_constraint_name = 'PAY_ELEMENT_ADJUSTMENT_ONL_CHK') 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_ELEMENT_CLOSED_FOR_ENT_CHK') Then
43: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('STEP','15');

Line 43: 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_ELEMENT_CLOSED_FOR_ENT_CHK') Then
43: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('STEP','15');
46: fnd_message.raise_error;
47: ElsIf (p_constraint_name = 'PAY_ELEMENT_INDIRECT_ONLY_CHK') Then

Line 44: 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_ELEMENT_CLOSED_FOR_ENT_CHK') Then
43: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('STEP','15');
46: fnd_message.raise_error;
47: ElsIf (p_constraint_name = 'PAY_ELEMENT_INDIRECT_ONLY_CHK') Then
48: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 45: fnd_message.set_token('STEP','15');

41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PAY_ELEMENT_CLOSED_FOR_ENT_CHK') Then
43: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('STEP','15');
46: fnd_message.raise_error;
47: ElsIf (p_constraint_name = 'PAY_ELEMENT_INDIRECT_ONLY_CHK') Then
48: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
49: fnd_message.set_token('PROCEDURE', l_proc);

Line 46: fnd_message.raise_error;

42: ElsIf (p_constraint_name = 'PAY_ELEMENT_CLOSED_FOR_ENT_CHK') Then
43: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('STEP','15');
46: fnd_message.raise_error;
47: ElsIf (p_constraint_name = 'PAY_ELEMENT_INDIRECT_ONLY_CHK') Then
48: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
49: fnd_message.set_token('PROCEDURE', l_proc);
50: fnd_message.set_token('STEP','20');

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

44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('STEP','15');
46: fnd_message.raise_error;
47: ElsIf (p_constraint_name = 'PAY_ELEMENT_INDIRECT_ONLY_CHK') Then
48: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
49: fnd_message.set_token('PROCEDURE', l_proc);
50: fnd_message.set_token('STEP','20');
51: fnd_message.raise_error;
52: ElsIf (p_constraint_name = 'PAY_ELEMENT_MULTIPLE_ENTRI_CHK') Then

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

45: fnd_message.set_token('STEP','15');
46: fnd_message.raise_error;
47: ElsIf (p_constraint_name = 'PAY_ELEMENT_INDIRECT_ONLY_CHK') Then
48: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
49: fnd_message.set_token('PROCEDURE', l_proc);
50: fnd_message.set_token('STEP','20');
51: fnd_message.raise_error;
52: ElsIf (p_constraint_name = 'PAY_ELEMENT_MULTIPLE_ENTRI_CHK') Then
53: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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

46: fnd_message.raise_error;
47: ElsIf (p_constraint_name = 'PAY_ELEMENT_INDIRECT_ONLY_CHK') Then
48: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
49: fnd_message.set_token('PROCEDURE', l_proc);
50: fnd_message.set_token('STEP','20');
51: fnd_message.raise_error;
52: ElsIf (p_constraint_name = 'PAY_ELEMENT_MULTIPLE_ENTRI_CHK') 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_ELEMENT_INDIRECT_ONLY_CHK') Then
48: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
49: fnd_message.set_token('PROCEDURE', l_proc);
50: fnd_message.set_token('STEP','20');
51: fnd_message.raise_error;
52: ElsIf (p_constraint_name = 'PAY_ELEMENT_MULTIPLE_ENTRI_CHK') 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_token('PROCEDURE', l_proc);
50: fnd_message.set_token('STEP','20');
51: fnd_message.raise_error;
52: ElsIf (p_constraint_name = 'PAY_ELEMENT_MULTIPLE_ENTRI_CHK') 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: ElsIf (p_constraint_name = 'PAY_ELEMENT_MULTIPLY_VALUE_CHK') Then

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

50: fnd_message.set_token('STEP','20');
51: fnd_message.raise_error;
52: ElsIf (p_constraint_name = 'PAY_ELEMENT_MULTIPLE_ENTRI_CHK') 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: ElsIf (p_constraint_name = 'PAY_ELEMENT_MULTIPLY_VALUE_CHK') Then
58: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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

51: fnd_message.raise_error;
52: ElsIf (p_constraint_name = 'PAY_ELEMENT_MULTIPLE_ENTRI_CHK') 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: ElsIf (p_constraint_name = 'PAY_ELEMENT_MULTIPLY_VALUE_CHK') Then
58: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
59: fnd_message.set_token('PROCEDURE', l_proc);

Line 56: fnd_message.raise_error;

52: ElsIf (p_constraint_name = 'PAY_ELEMENT_MULTIPLE_ENTRI_CHK') 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: ElsIf (p_constraint_name = 'PAY_ELEMENT_MULTIPLY_VALUE_CHK') Then
58: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
59: fnd_message.set_token('PROCEDURE', l_proc);
60: fnd_message.set_token('STEP','30');

Line 58: 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: ElsIf (p_constraint_name = 'PAY_ELEMENT_MULTIPLY_VALUE_CHK') Then
58: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
59: fnd_message.set_token('PROCEDURE', l_proc);
60: fnd_message.set_token('STEP','30');
61: fnd_message.raise_error;
62: ElsIf (p_constraint_name = 'PAY_ELEMENT_POST_TERMINATI_CHK') Then

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

55: fnd_message.set_token('STEP','25');
56: fnd_message.raise_error;
57: ElsIf (p_constraint_name = 'PAY_ELEMENT_MULTIPLY_VALUE_CHK') Then
58: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
59: fnd_message.set_token('PROCEDURE', l_proc);
60: fnd_message.set_token('STEP','30');
61: fnd_message.raise_error;
62: ElsIf (p_constraint_name = 'PAY_ELEMENT_POST_TERMINATI_CHK') Then
63: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 60: fnd_message.set_token('STEP','30');

56: fnd_message.raise_error;
57: ElsIf (p_constraint_name = 'PAY_ELEMENT_MULTIPLY_VALUE_CHK') Then
58: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
59: fnd_message.set_token('PROCEDURE', l_proc);
60: fnd_message.set_token('STEP','30');
61: fnd_message.raise_error;
62: ElsIf (p_constraint_name = 'PAY_ELEMENT_POST_TERMINATI_CHK') Then
63: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
64: fnd_message.set_token('PROCEDURE', l_proc);

Line 61: fnd_message.raise_error;

57: ElsIf (p_constraint_name = 'PAY_ELEMENT_MULTIPLY_VALUE_CHK') Then
58: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
59: fnd_message.set_token('PROCEDURE', l_proc);
60: fnd_message.set_token('STEP','30');
61: fnd_message.raise_error;
62: ElsIf (p_constraint_name = 'PAY_ELEMENT_POST_TERMINATI_CHK') Then
63: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
64: fnd_message.set_token('PROCEDURE', l_proc);
65: fnd_message.set_token('STEP','35');

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

59: fnd_message.set_token('PROCEDURE', l_proc);
60: fnd_message.set_token('STEP','30');
61: fnd_message.raise_error;
62: ElsIf (p_constraint_name = 'PAY_ELEMENT_POST_TERMINATI_CHK') Then
63: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
64: fnd_message.set_token('PROCEDURE', l_proc);
65: fnd_message.set_token('STEP','35');
66: fnd_message.raise_error;
67: ElsIf (p_constraint_name = 'PAY_ELEMENT_PROCESSING_TYP_CHK') Then

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

60: fnd_message.set_token('STEP','30');
61: fnd_message.raise_error;
62: ElsIf (p_constraint_name = 'PAY_ELEMENT_POST_TERMINATI_CHK') Then
63: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
64: fnd_message.set_token('PROCEDURE', l_proc);
65: fnd_message.set_token('STEP','35');
66: fnd_message.raise_error;
67: ElsIf (p_constraint_name = 'PAY_ELEMENT_PROCESSING_TYP_CHK') Then
68: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 65: fnd_message.set_token('STEP','35');

61: fnd_message.raise_error;
62: ElsIf (p_constraint_name = 'PAY_ELEMENT_POST_TERMINATI_CHK') Then
63: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
64: fnd_message.set_token('PROCEDURE', l_proc);
65: fnd_message.set_token('STEP','35');
66: fnd_message.raise_error;
67: ElsIf (p_constraint_name = 'PAY_ELEMENT_PROCESSING_TYP_CHK') Then
68: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
69: fnd_message.set_token('PROCEDURE', l_proc);

Line 66: fnd_message.raise_error;

62: ElsIf (p_constraint_name = 'PAY_ELEMENT_POST_TERMINATI_CHK') Then
63: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
64: fnd_message.set_token('PROCEDURE', l_proc);
65: fnd_message.set_token('STEP','35');
66: fnd_message.raise_error;
67: ElsIf (p_constraint_name = 'PAY_ELEMENT_PROCESSING_TYP_CHK') Then
68: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
69: fnd_message.set_token('PROCEDURE', l_proc);
70: fnd_message.set_token('STEP','40');

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

64: fnd_message.set_token('PROCEDURE', l_proc);
65: fnd_message.set_token('STEP','35');
66: fnd_message.raise_error;
67: ElsIf (p_constraint_name = 'PAY_ELEMENT_PROCESSING_TYP_CHK') Then
68: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
69: fnd_message.set_token('PROCEDURE', l_proc);
70: fnd_message.set_token('STEP','40');
71: fnd_message.raise_error;
72: ElsIf (p_constraint_name = 'PAY_ELEMENT_PROCESS_IN_RUN_CHK') Then

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

65: fnd_message.set_token('STEP','35');
66: fnd_message.raise_error;
67: ElsIf (p_constraint_name = 'PAY_ELEMENT_PROCESSING_TYP_CHK') Then
68: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
69: fnd_message.set_token('PROCEDURE', l_proc);
70: fnd_message.set_token('STEP','40');
71: fnd_message.raise_error;
72: ElsIf (p_constraint_name = 'PAY_ELEMENT_PROCESS_IN_RUN_CHK') Then
73: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 70: fnd_message.set_token('STEP','40');

66: fnd_message.raise_error;
67: ElsIf (p_constraint_name = 'PAY_ELEMENT_PROCESSING_TYP_CHK') Then
68: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
69: fnd_message.set_token('PROCEDURE', l_proc);
70: fnd_message.set_token('STEP','40');
71: fnd_message.raise_error;
72: ElsIf (p_constraint_name = 'PAY_ELEMENT_PROCESS_IN_RUN_CHK') Then
73: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
74: fnd_message.set_token('PROCEDURE', l_proc);

Line 71: fnd_message.raise_error;

67: ElsIf (p_constraint_name = 'PAY_ELEMENT_PROCESSING_TYP_CHK') Then
68: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
69: fnd_message.set_token('PROCEDURE', l_proc);
70: fnd_message.set_token('STEP','40');
71: fnd_message.raise_error;
72: ElsIf (p_constraint_name = 'PAY_ELEMENT_PROCESS_IN_RUN_CHK') Then
73: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
74: fnd_message.set_token('PROCEDURE', l_proc);
75: fnd_message.set_token('STEP','45');

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

69: fnd_message.set_token('PROCEDURE', l_proc);
70: fnd_message.set_token('STEP','40');
71: fnd_message.raise_error;
72: ElsIf (p_constraint_name = 'PAY_ELEMENT_PROCESS_IN_RUN_CHK') Then
73: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
74: fnd_message.set_token('PROCEDURE', l_proc);
75: fnd_message.set_token('STEP','45');
76: fnd_message.raise_error;
77: ElsIf (p_constraint_name = 'PAY_ELEMENT_STANDARD_LINK_CHK') Then

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

70: fnd_message.set_token('STEP','40');
71: fnd_message.raise_error;
72: ElsIf (p_constraint_name = 'PAY_ELEMENT_PROCESS_IN_RUN_CHK') Then
73: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
74: fnd_message.set_token('PROCEDURE', l_proc);
75: fnd_message.set_token('STEP','45');
76: fnd_message.raise_error;
77: ElsIf (p_constraint_name = 'PAY_ELEMENT_STANDARD_LINK_CHK') Then
78: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 75: fnd_message.set_token('STEP','45');

71: fnd_message.raise_error;
72: ElsIf (p_constraint_name = 'PAY_ELEMENT_PROCESS_IN_RUN_CHK') Then
73: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
74: fnd_message.set_token('PROCEDURE', l_proc);
75: fnd_message.set_token('STEP','45');
76: fnd_message.raise_error;
77: ElsIf (p_constraint_name = 'PAY_ELEMENT_STANDARD_LINK_CHK') Then
78: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
79: fnd_message.set_token('PROCEDURE', l_proc);

Line 76: fnd_message.raise_error;

72: ElsIf (p_constraint_name = 'PAY_ELEMENT_PROCESS_IN_RUN_CHK') Then
73: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
74: fnd_message.set_token('PROCEDURE', l_proc);
75: fnd_message.set_token('STEP','45');
76: fnd_message.raise_error;
77: ElsIf (p_constraint_name = 'PAY_ELEMENT_STANDARD_LINK_CHK') Then
78: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
79: fnd_message.set_token('PROCEDURE', l_proc);
80: fnd_message.set_token('STEP','50');

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

74: fnd_message.set_token('PROCEDURE', l_proc);
75: fnd_message.set_token('STEP','45');
76: fnd_message.raise_error;
77: ElsIf (p_constraint_name = 'PAY_ELEMENT_STANDARD_LINK_CHK') Then
78: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
79: fnd_message.set_token('PROCEDURE', l_proc);
80: fnd_message.set_token('STEP','50');
81: fnd_message.raise_error;
82: ElsIf (p_constraint_name = 'PAY_ELEMENT_THIRD_PARTY_PA_CHK') Then

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

75: fnd_message.set_token('STEP','45');
76: fnd_message.raise_error;
77: ElsIf (p_constraint_name = 'PAY_ELEMENT_STANDARD_LINK_CHK') Then
78: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
79: fnd_message.set_token('PROCEDURE', l_proc);
80: fnd_message.set_token('STEP','50');
81: fnd_message.raise_error;
82: ElsIf (p_constraint_name = 'PAY_ELEMENT_THIRD_PARTY_PA_CHK') Then
83: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 80: fnd_message.set_token('STEP','50');

76: fnd_message.raise_error;
77: ElsIf (p_constraint_name = 'PAY_ELEMENT_STANDARD_LINK_CHK') Then
78: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
79: fnd_message.set_token('PROCEDURE', l_proc);
80: fnd_message.set_token('STEP','50');
81: fnd_message.raise_error;
82: ElsIf (p_constraint_name = 'PAY_ELEMENT_THIRD_PARTY_PA_CHK') Then
83: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
84: fnd_message.set_token('PROCEDURE', l_proc);

Line 81: fnd_message.raise_error;

77: ElsIf (p_constraint_name = 'PAY_ELEMENT_STANDARD_LINK_CHK') Then
78: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
79: fnd_message.set_token('PROCEDURE', l_proc);
80: fnd_message.set_token('STEP','50');
81: fnd_message.raise_error;
82: ElsIf (p_constraint_name = 'PAY_ELEMENT_THIRD_PARTY_PA_CHK') Then
83: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
84: fnd_message.set_token('PROCEDURE', l_proc);
85: fnd_message.set_token('STEP','55');

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

79: fnd_message.set_token('PROCEDURE', l_proc);
80: fnd_message.set_token('STEP','50');
81: fnd_message.raise_error;
82: ElsIf (p_constraint_name = 'PAY_ELEMENT_THIRD_PARTY_PA_CHK') Then
83: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
84: fnd_message.set_token('PROCEDURE', l_proc);
85: fnd_message.set_token('STEP','55');
86: fnd_message.raise_error;
87: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK1') Then

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

80: fnd_message.set_token('STEP','50');
81: fnd_message.raise_error;
82: ElsIf (p_constraint_name = 'PAY_ELEMENT_THIRD_PARTY_PA_CHK') Then
83: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
84: fnd_message.set_token('PROCEDURE', l_proc);
85: fnd_message.set_token('STEP','55');
86: fnd_message.raise_error;
87: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK1') Then
88: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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

81: fnd_message.raise_error;
82: ElsIf (p_constraint_name = 'PAY_ELEMENT_THIRD_PARTY_PA_CHK') Then
83: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
84: fnd_message.set_token('PROCEDURE', l_proc);
85: fnd_message.set_token('STEP','55');
86: fnd_message.raise_error;
87: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK1') Then
88: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
89: fnd_message.set_token('PROCEDURE', l_proc);

Line 86: fnd_message.raise_error;

82: ElsIf (p_constraint_name = 'PAY_ELEMENT_THIRD_PARTY_PA_CHK') Then
83: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
84: fnd_message.set_token('PROCEDURE', l_proc);
85: fnd_message.set_token('STEP','55');
86: fnd_message.raise_error;
87: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK1') Then
88: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
89: fnd_message.set_token('PROCEDURE', l_proc);
90: fnd_message.set_token('STEP','60');

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

84: fnd_message.set_token('PROCEDURE', l_proc);
85: fnd_message.set_token('STEP','55');
86: fnd_message.raise_error;
87: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK1') Then
88: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
89: fnd_message.set_token('PROCEDURE', l_proc);
90: fnd_message.set_token('STEP','60');
91: fnd_message.raise_error;
92: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK2') Then

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

85: fnd_message.set_token('STEP','55');
86: fnd_message.raise_error;
87: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK1') Then
88: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
89: fnd_message.set_token('PROCEDURE', l_proc);
90: fnd_message.set_token('STEP','60');
91: fnd_message.raise_error;
92: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK2') Then
93: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 90: fnd_message.set_token('STEP','60');

86: fnd_message.raise_error;
87: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK1') Then
88: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
89: fnd_message.set_token('PROCEDURE', l_proc);
90: fnd_message.set_token('STEP','60');
91: fnd_message.raise_error;
92: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK2') Then
93: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
94: fnd_message.set_token('PROCEDURE', l_proc);

Line 91: fnd_message.raise_error;

87: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK1') Then
88: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
89: fnd_message.set_token('PROCEDURE', l_proc);
90: fnd_message.set_token('STEP','60');
91: fnd_message.raise_error;
92: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK2') Then
93: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
94: fnd_message.set_token('PROCEDURE', l_proc);
95: fnd_message.set_token('STEP','65');

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

89: fnd_message.set_token('PROCEDURE', l_proc);
90: fnd_message.set_token('STEP','60');
91: fnd_message.raise_error;
92: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK2') Then
93: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
94: fnd_message.set_token('PROCEDURE', l_proc);
95: fnd_message.set_token('STEP','65');
96: fnd_message.raise_error;
97: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK3') Then

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

90: fnd_message.set_token('STEP','60');
91: fnd_message.raise_error;
92: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK2') Then
93: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
94: fnd_message.set_token('PROCEDURE', l_proc);
95: fnd_message.set_token('STEP','65');
96: fnd_message.raise_error;
97: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK3') Then
98: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 95: fnd_message.set_token('STEP','65');

91: fnd_message.raise_error;
92: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK2') Then
93: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
94: fnd_message.set_token('PROCEDURE', l_proc);
95: fnd_message.set_token('STEP','65');
96: fnd_message.raise_error;
97: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK3') Then
98: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
99: fnd_message.set_token('PROCEDURE', l_proc);

Line 96: fnd_message.raise_error;

92: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK2') Then
93: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
94: fnd_message.set_token('PROCEDURE', l_proc);
95: fnd_message.set_token('STEP','65');
96: fnd_message.raise_error;
97: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK3') Then
98: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
99: fnd_message.set_token('PROCEDURE', l_proc);
100: fnd_message.set_token('STEP','70');

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

94: fnd_message.set_token('PROCEDURE', l_proc);
95: fnd_message.set_token('STEP','65');
96: fnd_message.raise_error;
97: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK3') Then
98: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
99: fnd_message.set_token('PROCEDURE', l_proc);
100: fnd_message.set_token('STEP','70');
101: fnd_message.raise_error;
102: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_PK') Then

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

95: fnd_message.set_token('STEP','65');
96: fnd_message.raise_error;
97: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK3') Then
98: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
99: fnd_message.set_token('PROCEDURE', l_proc);
100: fnd_message.set_token('STEP','70');
101: fnd_message.raise_error;
102: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_PK') Then
103: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 100: fnd_message.set_token('STEP','70');

96: fnd_message.raise_error;
97: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK3') Then
98: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
99: fnd_message.set_token('PROCEDURE', l_proc);
100: fnd_message.set_token('STEP','70');
101: fnd_message.raise_error;
102: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_PK') Then
103: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
104: fnd_message.set_token('PROCEDURE', l_proc);

Line 101: fnd_message.raise_error;

97: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK3') Then
98: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
99: fnd_message.set_token('PROCEDURE', l_proc);
100: fnd_message.set_token('STEP','70');
101: fnd_message.raise_error;
102: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_PK') Then
103: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
104: fnd_message.set_token('PROCEDURE', l_proc);
105: fnd_message.set_token('STEP','75');

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

99: fnd_message.set_token('PROCEDURE', l_proc);
100: fnd_message.set_token('STEP','70');
101: fnd_message.raise_error;
102: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_PK') Then
103: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
104: fnd_message.set_token('PROCEDURE', l_proc);
105: fnd_message.set_token('STEP','75');
106: fnd_message.raise_error;
107: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_UK2') Then

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

100: fnd_message.set_token('STEP','70');
101: fnd_message.raise_error;
102: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_PK') Then
103: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
104: fnd_message.set_token('PROCEDURE', l_proc);
105: fnd_message.set_token('STEP','75');
106: fnd_message.raise_error;
107: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_UK2') Then
108: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 105: fnd_message.set_token('STEP','75');

101: fnd_message.raise_error;
102: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_PK') Then
103: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
104: fnd_message.set_token('PROCEDURE', l_proc);
105: fnd_message.set_token('STEP','75');
106: fnd_message.raise_error;
107: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_UK2') Then
108: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
109: fnd_message.set_token('PROCEDURE', l_proc);

Line 106: fnd_message.raise_error;

102: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_PK') Then
103: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
104: fnd_message.set_token('PROCEDURE', l_proc);
105: fnd_message.set_token('STEP','75');
106: fnd_message.raise_error;
107: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_UK2') Then
108: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
109: fnd_message.set_token('PROCEDURE', l_proc);
110: fnd_message.set_token('STEP','80');

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

104: fnd_message.set_token('PROCEDURE', l_proc);
105: fnd_message.set_token('STEP','75');
106: fnd_message.raise_error;
107: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_UK2') Then
108: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
109: fnd_message.set_token('PROCEDURE', l_proc);
110: fnd_message.set_token('STEP','80');
111: fnd_message.raise_error;
112: Else

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

105: fnd_message.set_token('STEP','75');
106: fnd_message.raise_error;
107: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_UK2') Then
108: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
109: fnd_message.set_token('PROCEDURE', l_proc);
110: fnd_message.set_token('STEP','80');
111: fnd_message.raise_error;
112: Else
113: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');

Line 110: fnd_message.set_token('STEP','80');

106: fnd_message.raise_error;
107: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_UK2') Then
108: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
109: fnd_message.set_token('PROCEDURE', l_proc);
110: fnd_message.set_token('STEP','80');
111: fnd_message.raise_error;
112: Else
113: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
114: fnd_message.set_token('PROCEDURE', l_proc);

Line 111: fnd_message.raise_error;

107: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_UK2') Then
108: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
109: fnd_message.set_token('PROCEDURE', l_proc);
110: fnd_message.set_token('STEP','80');
111: fnd_message.raise_error;
112: Else
113: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
114: fnd_message.set_token('PROCEDURE', l_proc);
115: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);

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

109: fnd_message.set_token('PROCEDURE', l_proc);
110: fnd_message.set_token('STEP','80');
111: fnd_message.raise_error;
112: Else
113: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
114: fnd_message.set_token('PROCEDURE', l_proc);
115: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
116: fnd_message.raise_error;
117: End If;

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

110: fnd_message.set_token('STEP','80');
111: fnd_message.raise_error;
112: Else
113: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
114: fnd_message.set_token('PROCEDURE', l_proc);
115: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
116: fnd_message.raise_error;
117: End If;
118: --

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

111: fnd_message.raise_error;
112: Else
113: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
114: fnd_message.set_token('PROCEDURE', l_proc);
115: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
116: fnd_message.raise_error;
117: End If;
118: --
119: End constraint_error;

Line 116: fnd_message.raise_error;

112: Else
113: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
114: fnd_message.set_token('PROCEDURE', l_proc);
115: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
116: fnd_message.raise_error;
117: End If;
118: --
119: End constraint_error;
120: --

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

262: Close C_Sel1;
263: --
264: -- The primary key is invalid therefore we must error
265: --
266: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
267: fnd_message.raise_error;
268: End If;
269: Close C_Sel1;
270: If (p_object_version_number

Line 267: fnd_message.raise_error;

263: --
264: -- The primary key is invalid therefore we must error
265: --
266: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
267: fnd_message.raise_error;
268: End If;
269: Close C_Sel1;
270: If (p_object_version_number
271: <> pay_etp_shd.g_old_rec.object_version_number) Then

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

268: End If;
269: Close C_Sel1;
270: If (p_object_version_number
271: <> pay_etp_shd.g_old_rec.object_version_number) Then
272: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
273: fnd_message.raise_error;
274: End If;
275: l_fct_ret := true;
276: End If;

Line 273: fnd_message.raise_error;

269: Close C_Sel1;
270: If (p_object_version_number
271: <> pay_etp_shd.g_old_rec.object_version_number) Then
272: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
273: fnd_message.raise_error;
274: End If;
275: l_fct_ret := true;
276: End If;
277: End If;

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

563: Close C_Sel1;
564: --
565: -- The primary key is invalid therefore we must error
566: --
567: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
568: fnd_message.raise_error;
569: End If;
570: Close C_Sel1;
571: If (p_object_version_number

Line 568: fnd_message.raise_error;

564: --
565: -- The primary key is invalid therefore we must error
566: --
567: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
568: fnd_message.raise_error;
569: End If;
570: Close C_Sel1;
571: If (p_object_version_number
572: <> pay_etp_shd.g_old_rec.object_version_number) Then

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

569: End If;
570: Close C_Sel1;
571: If (p_object_version_number
572: <> pay_etp_shd.g_old_rec.object_version_number) Then
573: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
574: fnd_message.raise_error;
575: End If;
576: --
577: -- Providing we are doing an update and a comment_id exists then

Line 574: fnd_message.raise_error;

570: Close C_Sel1;
571: If (p_object_version_number
572: <> pay_etp_shd.g_old_rec.object_version_number) Then
573: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
574: fnd_message.raise_error;
575: End If;
576: --
577: -- Providing we are doing an update and a comment_id exists then
578: -- we select the comment text.

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

589: -- The comments for the specified comment_id does not exist.
590: -- We must error due to data integrity problems.
591: --
592: Close C_Sel3;
593: fnd_message.set_name('PAY', 'HR_7202_COMMENT_TEXT_NOT_EXIST');
594: fnd_message.raise_error;
595: End If;
596: Close C_Sel3;
597: End If;

Line 594: fnd_message.raise_error;

590: -- We must error due to data integrity problems.
591: --
592: Close C_Sel3;
593: fnd_message.set_name('PAY', 'HR_7202_COMMENT_TEXT_NOT_EXIST');
594: fnd_message.raise_error;
595: End If;
596: Close C_Sel3;
597: End If;
598: --

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

626: -- We are doing a datetrack 'INSERT' which is illegal within this
627: -- procedure therefore we must error (note: to lck on insert the
628: -- private procedure ins_lck should be called).
629: --
630: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
631: fnd_message.set_token('PROCEDURE', l_proc);
632: fnd_message.set_token('STEP','20');
633: fnd_message.raise_error;
634: End If;

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

627: -- procedure therefore we must error (note: to lck on insert the
628: -- private procedure ins_lck should be called).
629: --
630: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
631: fnd_message.set_token('PROCEDURE', l_proc);
632: fnd_message.set_token('STEP','20');
633: fnd_message.raise_error;
634: End If;
635: --

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

628: -- private procedure ins_lck should be called).
629: --
630: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
631: fnd_message.set_token('PROCEDURE', l_proc);
632: fnd_message.set_token('STEP','20');
633: fnd_message.raise_error;
634: End If;
635: --
636: -- Set the validation start and end date OUT arguments

Line 633: fnd_message.raise_error;

629: --
630: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
631: fnd_message.set_token('PROCEDURE', l_proc);
632: fnd_message.set_token('STEP','20');
633: fnd_message.raise_error;
634: End If;
635: --
636: -- Set the validation start and end date OUT arguments
637: --

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

647: --
648: -- The object is locked therefore we need to supply a meaningful
649: -- error message.
650: --
651: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
652: fnd_message.set_token('TABLE_NAME', 'pay_element_types_f');
653: fnd_message.raise_error;
654: End lck;
655: --

Line 652: fnd_message.set_token('TABLE_NAME', 'pay_element_types_f');

648: -- The object is locked therefore we need to supply a meaningful
649: -- error message.
650: --
651: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
652: fnd_message.set_token('TABLE_NAME', 'pay_element_types_f');
653: fnd_message.raise_error;
654: End lck;
655: --
656: -- ----------------------------------------------------------------------------

Line 653: fnd_message.raise_error;

649: -- error message.
650: --
651: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
652: fnd_message.set_token('TABLE_NAME', 'pay_element_types_f');
653: fnd_message.raise_error;
654: End lck;
655: --
656: -- ----------------------------------------------------------------------------
657: -- |-----------------------------< convert_args >-----------------------------|