DBA Data[Home] [Help]

APPS.PAY_PEL_SHD dependencies on FND_MESSAGE

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

30: --
31: Begin
32: --
33: If (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK10') Then
34: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
35: fnd_message.set_token('PROCEDURE', l_proc);
36: fnd_message.set_token('STEP','5');
37: fnd_message.raise_error;
38: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK11') Then

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

31: Begin
32: --
33: If (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK10') Then
34: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
35: fnd_message.set_token('PROCEDURE', l_proc);
36: fnd_message.set_token('STEP','5');
37: fnd_message.raise_error;
38: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK11') Then
39: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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

32: --
33: If (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK10') Then
34: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
35: fnd_message.set_token('PROCEDURE', l_proc);
36: fnd_message.set_token('STEP','5');
37: fnd_message.raise_error;
38: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK11') Then
39: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
40: fnd_message.set_token('PROCEDURE', l_proc);

Line 37: fnd_message.raise_error;

33: If (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK10') Then
34: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
35: fnd_message.set_token('PROCEDURE', l_proc);
36: fnd_message.set_token('STEP','5');
37: fnd_message.raise_error;
38: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK11') Then
39: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
40: fnd_message.set_token('PROCEDURE', l_proc);
41: fnd_message.set_token('STEP','10');

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

35: fnd_message.set_token('PROCEDURE', l_proc);
36: fnd_message.set_token('STEP','5');
37: fnd_message.raise_error;
38: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK11') Then
39: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
40: fnd_message.set_token('PROCEDURE', l_proc);
41: fnd_message.set_token('STEP','10');
42: fnd_message.raise_error;
43: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK12') Then

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

36: fnd_message.set_token('STEP','5');
37: fnd_message.raise_error;
38: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK11') Then
39: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
40: fnd_message.set_token('PROCEDURE', l_proc);
41: fnd_message.set_token('STEP','10');
42: fnd_message.raise_error;
43: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK12') Then
44: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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

37: fnd_message.raise_error;
38: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK11') Then
39: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
40: fnd_message.set_token('PROCEDURE', l_proc);
41: fnd_message.set_token('STEP','10');
42: fnd_message.raise_error;
43: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK12') Then
44: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
45: fnd_message.set_token('PROCEDURE', l_proc);

Line 42: fnd_message.raise_error;

38: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK11') Then
39: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
40: fnd_message.set_token('PROCEDURE', l_proc);
41: fnd_message.set_token('STEP','10');
42: fnd_message.raise_error;
43: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK12') Then
44: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
45: fnd_message.set_token('PROCEDURE', l_proc);
46: fnd_message.set_token('STEP','15');

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

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

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

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

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

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

Line 47: fnd_message.raise_error;

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

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

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

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

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

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

47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK13') Then
49: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
50: fnd_message.set_token('PROCEDURE', l_proc);
51: fnd_message.set_token('STEP','20');
52: fnd_message.raise_error;
53: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK2') Then
54: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
55: fnd_message.set_token('PROCEDURE', l_proc);

Line 52: fnd_message.raise_error;

48: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK13') Then
49: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
50: fnd_message.set_token('PROCEDURE', l_proc);
51: fnd_message.set_token('STEP','20');
52: fnd_message.raise_error;
53: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK2') Then
54: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
55: fnd_message.set_token('PROCEDURE', l_proc);
56: fnd_message.set_token('STEP','25');

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

50: fnd_message.set_token('PROCEDURE', l_proc);
51: fnd_message.set_token('STEP','20');
52: fnd_message.raise_error;
53: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK2') Then
54: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
55: fnd_message.set_token('PROCEDURE', l_proc);
56: fnd_message.set_token('STEP','25');
57: fnd_message.raise_error;
58: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK4') Then

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

51: fnd_message.set_token('STEP','20');
52: fnd_message.raise_error;
53: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK2') Then
54: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
55: fnd_message.set_token('PROCEDURE', l_proc);
56: fnd_message.set_token('STEP','25');
57: fnd_message.raise_error;
58: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK4') Then
59: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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

52: fnd_message.raise_error;
53: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK2') Then
54: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
55: fnd_message.set_token('PROCEDURE', l_proc);
56: fnd_message.set_token('STEP','25');
57: fnd_message.raise_error;
58: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK4') Then
59: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
60: fnd_message.set_token('PROCEDURE', l_proc);

Line 57: fnd_message.raise_error;

53: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK2') Then
54: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
55: fnd_message.set_token('PROCEDURE', l_proc);
56: fnd_message.set_token('STEP','25');
57: fnd_message.raise_error;
58: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK4') Then
59: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
60: fnd_message.set_token('PROCEDURE', l_proc);
61: fnd_message.set_token('STEP','30');

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

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

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

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

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

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

Line 62: fnd_message.raise_error;

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

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

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

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

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

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

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

Line 67: fnd_message.raise_error;

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

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

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

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

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

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

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

Line 72: fnd_message.raise_error;

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

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

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

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

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

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

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

Line 77: fnd_message.raise_error;

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

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

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

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

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

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

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

Line 82: fnd_message.raise_error;

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

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

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

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

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

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

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

Line 87: fnd_message.raise_error;

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

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

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

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

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

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

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

Line 92: fnd_message.raise_error;

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

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

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

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

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

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

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

Line 97: fnd_message.raise_error;

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

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

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

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

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

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

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

Line 102: fnd_message.raise_error;

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

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

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

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

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

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

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

Line 107: fnd_message.raise_error;

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

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

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

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

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

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

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

Line 112: fnd_message.raise_error;

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

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

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

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

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

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

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

Line 117: fnd_message.raise_error;

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

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

219: Close C_Sel1;
220: --
221: -- The primary key is invalid therefore we must error
222: --
223: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
224: fnd_message.raise_error;
225: End If;
226: Close C_Sel1;
227: If (p_object_version_number

Line 224: fnd_message.raise_error;

220: --
221: -- The primary key is invalid therefore we must error
222: --
223: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
224: fnd_message.raise_error;
225: End If;
226: Close C_Sel1;
227: If (p_object_version_number
228: <> pay_pel_shd.g_old_rec.object_version_number) Then

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

225: End If;
226: Close C_Sel1;
227: If (p_object_version_number
228: <> pay_pel_shd.g_old_rec.object_version_number) Then
229: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
230: fnd_message.raise_error;
231: End If;
232: l_fct_ret := true;
233: End If;

Line 230: fnd_message.raise_error;

226: Close C_Sel1;
227: If (p_object_version_number
228: <> pay_pel_shd.g_old_rec.object_version_number) Then
229: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
230: fnd_message.raise_error;
231: End If;
232: l_fct_ret := true;
233: End If;
234: End If;

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

302: l_parent_key_value1
303: ,l_parent_key_value2;
304: If C_Sel1%NOTFOUND then
305: Close C_Sel1;
306: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
307: fnd_message.set_token('PROCEDURE',l_proc);
308: fnd_message.set_token('STEP','10');
309: fnd_message.raise_error;
310: End If;

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

303: ,l_parent_key_value2;
304: If C_Sel1%NOTFOUND then
305: Close C_Sel1;
306: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
307: fnd_message.set_token('PROCEDURE',l_proc);
308: fnd_message.set_token('STEP','10');
309: fnd_message.raise_error;
310: End If;
311: Close C_Sel1;

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

304: If C_Sel1%NOTFOUND then
305: Close C_Sel1;
306: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
307: fnd_message.set_token('PROCEDURE',l_proc);
308: fnd_message.set_token('STEP','10');
309: fnd_message.raise_error;
310: End If;
311: Close C_Sel1;
312: --

Line 309: fnd_message.raise_error;

305: Close C_Sel1;
306: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
307: fnd_message.set_token('PROCEDURE',l_proc);
308: fnd_message.set_token('STEP','10');
309: fnd_message.raise_error;
310: End If;
311: Close C_Sel1;
312: --
313: -- Call the corresponding datetrack api

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

506: Close C_Sel1;
507: --
508: -- The primary key is invalid therefore we must error
509: --
510: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
511: fnd_message.raise_error;
512: End If;
513: Close C_Sel1;
514: If (p_object_version_number

Line 511: fnd_message.raise_error;

507: --
508: -- The primary key is invalid therefore we must error
509: --
510: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
511: fnd_message.raise_error;
512: End If;
513: Close C_Sel1;
514: If (p_object_version_number
515: <> pay_pel_shd.g_old_rec.object_version_number) Then

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

512: End If;
513: Close C_Sel1;
514: If (p_object_version_number
515: <> pay_pel_shd.g_old_rec.object_version_number) Then
516: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
517: fnd_message.raise_error;
518: End If;
519: --
520: -- Providing we are doing an update and a comment_id exists then

Line 517: fnd_message.raise_error;

513: Close C_Sel1;
514: If (p_object_version_number
515: <> pay_pel_shd.g_old_rec.object_version_number) Then
516: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
517: fnd_message.raise_error;
518: End If;
519: --
520: -- Providing we are doing an update and a comment_id exists then
521: -- we select the comment text.

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

532: -- The comments for the specified comment_id does not exist.
533: -- We must error due to data integrity problems.
534: --
535: Close C_Sel3;
536: fnd_message.set_name('PAY', 'HR_7202_COMMENT_TEXT_NOT_EXIST');
537: fnd_message.raise_error;
538: End If;
539: Close C_Sel3;
540: End If;

Line 537: fnd_message.raise_error;

533: -- We must error due to data integrity problems.
534: --
535: Close C_Sel3;
536: fnd_message.set_name('PAY', 'HR_7202_COMMENT_TEXT_NOT_EXIST');
537: fnd_message.raise_error;
538: End If;
539: Close C_Sel3;
540: End If;
541: --

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

569: -- We are doing a datetrack 'INSERT' which is illegal within this
570: -- procedure therefore we must error (note: to lck on insert the
571: -- private procedure ins_lck should be called).
572: --
573: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
574: fnd_message.set_token('PROCEDURE', l_proc);
575: fnd_message.set_token('STEP','20');
576: fnd_message.raise_error;
577: End If;

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

570: -- procedure therefore we must error (note: to lck on insert the
571: -- private procedure ins_lck should be called).
572: --
573: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
574: fnd_message.set_token('PROCEDURE', l_proc);
575: fnd_message.set_token('STEP','20');
576: fnd_message.raise_error;
577: End If;
578: --

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

571: -- private procedure ins_lck should be called).
572: --
573: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
574: fnd_message.set_token('PROCEDURE', l_proc);
575: fnd_message.set_token('STEP','20');
576: fnd_message.raise_error;
577: End If;
578: --
579: -- Set the validation start and end date OUT arguments

Line 576: fnd_message.raise_error;

572: --
573: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
574: fnd_message.set_token('PROCEDURE', l_proc);
575: fnd_message.set_token('STEP','20');
576: fnd_message.raise_error;
577: End If;
578: --
579: -- Set the validation start and end date OUT arguments
580: --

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

590: --
591: -- The object is locked therefore we need to supply a meaningful
592: -- error message.
593: --
594: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
595: fnd_message.set_token('TABLE_NAME', 'pay_element_links_f');
596: fnd_message.raise_error;
597: End lck;
598: --

Line 595: fnd_message.set_token('TABLE_NAME', 'pay_element_links_f');

591: -- The object is locked therefore we need to supply a meaningful
592: -- error message.
593: --
594: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
595: fnd_message.set_token('TABLE_NAME', 'pay_element_links_f');
596: fnd_message.raise_error;
597: End lck;
598: --
599: -- ----------------------------------------------------------------------------

Line 596: fnd_message.raise_error;

592: -- error message.
593: --
594: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
595: fnd_message.set_token('TABLE_NAME', 'pay_element_links_f');
596: fnd_message.raise_error;
597: End lck;
598: --
599: -- ----------------------------------------------------------------------------
600: -- |-----------------------------< convert_args >-----------------------------|