DBA Data[Home] [Help]

APPS.HR_NZ_PERSONAL_PAY_METHOD_API dependencies on HR_UTILITY

Line 33: hr_utility.set_location('Entering:'|| l_proc, 5);

29: AND asg.assignment_id = p_assignment_id
30: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;
31:
32: BEGIN
33: hr_utility.set_location('Entering:'|| l_proc, 5);
34: --
35: -- Check that p_assignment_id and p_effective_date are not null as they
36: -- are used by the cursor to validate the business group.
37: --

Line 48: hr_utility.set_location(l_proc, 6);

44: (p_api_name => l_proc
45: ,p_argument => 'effective_date'
46: ,p_argument_value => p_effective_date);
47: --
48: hr_utility.set_location(l_proc, 6);
49: --
50: -- Ensure that the legislation rule for the employee assignment
51: -- business group is that of p_leg_code.
52: --

Line 59: hr_utility.set_message(801, 'HR_7348_ASSIGNMENT_INVALID');

55: --
56: IF (csr_legcode%NOTFOUND)
57: THEN
58: CLOSE csr_legcode;
59: hr_utility.set_message(801, 'HR_7348_ASSIGNMENT_INVALID');
60: hr_utility.raise_error;
61: END IF;
62: IF (csr_legcode%FOUND AND l_valid <> p_leg_code)
63: THEN

Line 60: hr_utility.raise_error;

56: IF (csr_legcode%NOTFOUND)
57: THEN
58: CLOSE csr_legcode;
59: hr_utility.set_message(801, 'HR_7348_ASSIGNMENT_INVALID');
60: hr_utility.raise_error;
61: END IF;
62: IF (csr_legcode%FOUND AND l_valid <> p_leg_code)
63: THEN
64: CLOSE csr_legcode;

Line 65: hr_utility.set_message(801, 'HR_7898_PPM_BUS_GRP_INVALID');

61: END IF;
62: IF (csr_legcode%FOUND AND l_valid <> p_leg_code)
63: THEN
64: CLOSE csr_legcode;
65: hr_utility.set_message(801, 'HR_7898_PPM_BUS_GRP_INVALID');
66: hr_utility.raise_error;
67: END IF;
68: --
69: CLOSE csr_legcode;

Line 66: hr_utility.raise_error;

62: IF (csr_legcode%FOUND AND l_valid <> p_leg_code)
63: THEN
64: CLOSE csr_legcode;
65: hr_utility.set_message(801, 'HR_7898_PPM_BUS_GRP_INVALID');
66: hr_utility.raise_error;
67: END IF;
68: --
69: CLOSE csr_legcode;
70: hr_utility.set_location(l_proc, 7);

Line 70: hr_utility.set_location(l_proc, 7);

66: hr_utility.raise_error;
67: END IF;
68: --
69: CLOSE csr_legcode;
70: hr_utility.set_location(l_proc, 7);
71: --
72: -- Assign out parameter after truncating the date by using a local
73: -- variable.
74: --

Line 78: hr_utility.set_location('Leaving:'|| l_proc, 8);

74: --
75: l_effective_date := TRUNC(p_effective_date);
76: p_effective_date := l_effective_date;
77: --
78: hr_utility.set_location('Leaving:'|| l_proc, 8);
79: --
80: END check_insert_legislation;
81:
82:

Line 107: hr_utility.set_location('Entering:'|| l_proc, 10);

103: --
104: -- Ensure that the legislation rule for the employee assignment business
105: -- group is that of p_leg_code.
106: --
107: hr_utility.set_location('Entering:'|| l_proc, 10);
108: OPEN csr_legcode;
109: FETCH csr_legcode INTO l_valid;
110: --
111: IF (csr_legcode%NOTFOUND)

Line 114: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

110: --
111: IF (csr_legcode%NOTFOUND)
112: THEN
113: CLOSE csr_legcode;
114: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
115: hr_utility.raise_error;
116: END IF;
117: IF (csr_legcode%FOUND AND l_valid <> p_leg_code)
118: THEN

Line 115: hr_utility.raise_error;

111: IF (csr_legcode%NOTFOUND)
112: THEN
113: CLOSE csr_legcode;
114: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
115: hr_utility.raise_error;
116: END IF;
117: IF (csr_legcode%FOUND AND l_valid <> p_leg_code)
118: THEN
119: hr_utility.set_message(801, 'HR_7898_PPM_BUS_GRP_INVALID');

Line 119: hr_utility.set_message(801, 'HR_7898_PPM_BUS_GRP_INVALID');

115: hr_utility.raise_error;
116: END IF;
117: IF (csr_legcode%FOUND AND l_valid <> p_leg_code)
118: THEN
119: hr_utility.set_message(801, 'HR_7898_PPM_BUS_GRP_INVALID');
120: hr_utility.raise_error;
121: END IF;
122: CLOSE csr_legcode;
123: hr_utility.set_location('Leaving:'|| l_proc, 20);

Line 120: hr_utility.raise_error;

116: END IF;
117: IF (csr_legcode%FOUND AND l_valid <> p_leg_code)
118: THEN
119: hr_utility.set_message(801, 'HR_7898_PPM_BUS_GRP_INVALID');
120: hr_utility.raise_error;
121: END IF;
122: CLOSE csr_legcode;
123: hr_utility.set_location('Leaving:'|| l_proc, 20);
124:

Line 123: hr_utility.set_location('Leaving:'|| l_proc, 20);

119: hr_utility.set_message(801, 'HR_7898_PPM_BUS_GRP_INVALID');
120: hr_utility.raise_error;
121: END IF;
122: CLOSE csr_legcode;
123: hr_utility.set_location('Leaving:'|| l_proc, 20);
124:
125: END check_update_legislation;
126:
127: ------------------------------------------------------------

Line 227: hr_utility.set_location('Entering:'|| l_proc, 5);

223: l_check_bank_acct VARCHAR2(5);
224: --
225: BEGIN
226: --
227: hr_utility.set_location('Entering:'|| l_proc, 5);
228: --
229: l_effective_date := TRUNC(p_effective_date);
230: --
231: hr_nz_personal_pay_method_api.check_insert_legislation

Line 236: hr_utility.set_location(l_proc, 7);

232: (p_assignment_id => p_assignment_id
233: ,p_effective_date => l_effective_date
234: ,p_leg_code => 'NZ');
235: --
236: hr_utility.set_location(l_proc, 7);
237:
238: --
239: -- Call the business process to create the personal payment method
240: --

Line 326: hr_utility.set_location(' Leaving:'||l_proc, 9);

322: ,p_effective_end_date => p_effective_end_date
323: ,p_comment_id => p_comment_id
324: );
325: --
326: hr_utility.set_location(' Leaving:'||l_proc, 9);
327: END create_nz_personal_pay_method;
328:
329:
330: ------------------------------------------------------------------------------

Line 417: hr_utility.set_location('Entering:'|| l_proc, 5);

413: l_check_bank_acct VARCHAR2(5);
414: l_effective_date DATE;
415: --
416: BEGIN
417: hr_utility.set_location('Entering:'|| l_proc, 5);
418: --
419: l_effective_date := TRUNC(p_effective_date);
420: --
421: -- Ensure that the legislation rule for the employee assignment business

Line 430: hr_utility.set_location(l_proc, 6);

426: (p_personal_payment_method_id => p_personal_payment_method_id
427: ,p_effective_date => l_effective_date
428: ,p_leg_code => 'NZ');
429: --
430: hr_utility.set_location(l_proc, 6);
431:
432: --
433: -- Call the business process to update the personal payment method
434: --

Line 518: hr_utility.set_location(' Leaving:'||l_proc, 7);

514: ,p_effective_start_date => p_effective_start_date
515: ,p_effective_end_date => p_effective_end_date
516: );
517: --
518: hr_utility.set_location(' Leaving:'||l_proc, 7);
519: END update_nz_personal_pay_method;
520:
521: END hr_nz_personal_pay_method_api;