DBA Data[Home] [Help]

APPS.PAY_TAXABILITY_RULES_API dependencies on HR_UTILITY

Line 41: hr_utility.trace('In check_taxability_rule_exists');

37: lv_seed_last_updated_by NUMBER(15);
38:
39: BEGIN
40:
41: hr_utility.trace('In check_taxability_rule_exists');
42: open c_check_taxability_rule
43: (p_jurisdiction
44: ,p_legislation_code
45: ,p_tax_type

Line 56: hr_utility.trace('lv_seed_last_updated_by = '||to_char(lv_seed_last_updated_by));

52: end if;
53: close c_check_taxability_rule;
54:
55: lv_seed_last_updated_by:= fnd_load_util.owner_id('ORACLE');
56: hr_utility.trace('lv_seed_last_updated_by = '||to_char(lv_seed_last_updated_by));
57: hr_utility.trace('lv_last_updated_by = '||to_char(lv_last_updated_by));
58:
59: /* Check if its a seeded row. If so, set the return status to 'S' seed. */
60:

Line 57: hr_utility.trace('lv_last_updated_by = '||to_char(lv_last_updated_by));

53: close c_check_taxability_rule;
54:
55: lv_seed_last_updated_by:= fnd_load_util.owner_id('ORACLE');
56: hr_utility.trace('lv_seed_last_updated_by = '||to_char(lv_seed_last_updated_by));
57: hr_utility.trace('lv_last_updated_by = '||to_char(lv_last_updated_by));
58:
59: /* Check if its a seeded row. If so, set the return status to 'S' seed. */
60:
61: if lv_last_updated_by = lv_seed_last_updated_by Then

Line 67: hr_utility.trace('lv_status = '||lv_status);

63: lv_status := 'S';
64:
65: end if;
66:
67: hr_utility.trace('lv_status = '||lv_status);
68:
69: return (lv_status);
70:
71: END check_taxability_rule_exists;

Line 91: hr_utility.trace('In paytxabltyrulapi package');

87:
88: l_proc VARCHAR2(72) := g_package||'create_taxability_rules';
89: BEGIN
90:
91: hr_utility.trace('In paytxabltyrulapi package');
92:
93: hr_utility.set_location('Entering:'|| l_proc, 10);
94: --
95: -- Issue a savepoint

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

89: BEGIN
90:
91: hr_utility.trace('In paytxabltyrulapi package');
92:
93: hr_utility.set_location('Entering:'|| l_proc, 10);
94: --
95: -- Issue a savepoint
96: --
97: savepoint create_taxability_rules;

Line 99: hr_utility.trace('Before calling pay_txr_ins.ins');

95: -- Issue a savepoint
96: --
97: savepoint create_taxability_rules;
98:
99: hr_utility.trace('Before calling pay_txr_ins.ins');
100:
101: pay_txr_ins.ins(p_effective_date => sysdate
102: ,p_legislation_code => p_legislation_code
103: ,p_jurisdiction_code => p_jurisdiction

Line 112: hr_utility.trace('After calling pay_txr_ins.ins');

108: ,p_status => p_status
109: ,p_secondary_classification_id => p_secondary_classification_id
110: );
111:
112: hr_utility.trace('After calling pay_txr_ins.ins');
113:
114: IF p_validate THEN
115: hr_utility.set_location('Entering:'|| l_proc, 30);
116: RAISE hr_api.validate_enabled;

Line 115: hr_utility.set_location('Entering:'|| l_proc, 30);

111:
112: hr_utility.trace('After calling pay_txr_ins.ins');
113:
114: IF p_validate THEN
115: hr_utility.set_location('Entering:'|| l_proc, 30);
116: RAISE hr_api.validate_enabled;
117: END IF;
118:
119: EXCEPTION

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

119: EXCEPTION
120:
121: WHEN hr_api.validate_enabled THEN
122: ROLLBACK TO create_taxability_rules;
123: hr_utility.set_location(' Leaving:'||l_proc, 80);
124:
125: WHEN OTHERS THEN
126: ROLLBACK TO create_taxability_rules;
127: hr_utility.set_location(' Leaving:'||l_proc, 80);

Line 127: hr_utility.set_location(' Leaving:'||l_proc, 80);

123: hr_utility.set_location(' Leaving:'||l_proc, 80);
124:
125: WHEN OTHERS THEN
126: ROLLBACK TO create_taxability_rules;
127: hr_utility.set_location(' Leaving:'||l_proc, 80);
128: RAISE;
129:
130: hr_utility.trace('End create_taxability_rules');
131:

Line 130: hr_utility.trace('End create_taxability_rules');

126: ROLLBACK TO create_taxability_rules;
127: hr_utility.set_location(' Leaving:'||l_proc, 80);
128: RAISE;
129:
130: hr_utility.trace('End create_taxability_rules');
131:
132: END create_taxability_rules;
133:
134:

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

147: l_proc VARCHAR2(72) := g_package||'update_taxability_rules';
148:
149: BEGIN
150:
151: hr_utility.set_location('Entering:'|| l_proc, 10);
152: --
153: -- Issue a savepoint.
154: --
155: savepoint update_taxability_rules;

Line 169: hr_utility.set_location('Entering:'|| l_proc, 20);

165: ,p_status => p_status
166: ,p_secondary_classification_id => p_secondary_classification_id);
167:
168:
169: hr_utility.set_location('Entering:'|| l_proc, 20);
170:
171: IF p_validate THEN
172: hr_utility.set_location('Entering:'|| l_proc, 30);
173: RAISE hr_api.validate_enabled;

Line 172: hr_utility.set_location('Entering:'|| l_proc, 30);

168:
169: hr_utility.set_location('Entering:'|| l_proc, 20);
170:
171: IF p_validate THEN
172: hr_utility.set_location('Entering:'|| l_proc, 30);
173: RAISE hr_api.validate_enabled;
174: END IF;
175:
176: EXCEPTION

Line 180: hr_utility.set_location(' Leaving:'||l_proc, 80);

176: EXCEPTION
177:
178: WHEN hr_api.validate_enabled THEN
179: ROLLBACK TO update_taxability_rules;
180: hr_utility.set_location(' Leaving:'||l_proc, 80);
181:
182: WHEN OTHERS THEN
183: ROLLBACK TO update_taxability_rules;
184: hr_utility.set_location(' Leaving:'||l_proc, 80);

Line 184: hr_utility.set_location(' Leaving:'||l_proc, 80);

180: hr_utility.set_location(' Leaving:'||l_proc, 80);
181:
182: WHEN OTHERS THEN
183: ROLLBACK TO update_taxability_rules;
184: hr_utility.set_location(' Leaving:'||l_proc, 80);
185: RAISE;
186:
187: end update_taxability_rules;
188: