DBA Data[Home] [Help]

APPS.PAY_ETP_SHD_ND 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 264: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');

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

Line 265: fnd_message.raise_error;

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

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

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

Line 271: fnd_message.raise_error;

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

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

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

Line 564: fnd_message.raise_error;

560: --
561: -- The primary key is invalid therefore we must error
562: --
563: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
564: fnd_message.raise_error;
565: End If;
566: Close C_Sel1;
567: If (p_object_version_number
568: <> pay_etp_shd_nd.g_old_rec.object_version_number) Then

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

565: End If;
566: Close C_Sel1;
567: If (p_object_version_number
568: <> pay_etp_shd_nd.g_old_rec.object_version_number) Then
569: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
570: fnd_message.raise_error;
571: End If;
572: --
573: -- Providing we are doing an update and a comment_id exists then

Line 570: fnd_message.raise_error;

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

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

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

Line 590: fnd_message.raise_error;

586: -- We must error due to data integrity problems.
587: --
588: Close C_Sel3;
589: fnd_message.set_name('PAY', 'HR_7202_COMMENT_TEXT_NOT_EXIST');
590: fnd_message.raise_error;
591: End If;
592: Close C_Sel3;
593: End If;
594: --

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

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

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

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

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

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

Line 629: fnd_message.raise_error;

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

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

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

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

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

Line 649: fnd_message.raise_error;

645: -- error message.
646: --
647: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
648: fnd_message.set_token('TABLE_NAME', 'pay_element_types_f');
649: fnd_message.raise_error;
650: End lck;
651: --
652: -- ----------------------------------------------------------------------------
653: -- |-----------------------------< convert_args >-----------------------------|