DBA Data[Home] [Help]

APPS.PAY_TXR_INS dependencies on HR_UTILITY

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

30: --
31: l_proc varchar2(72) := g_package||'set_base_key_value';
32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 10);
35: --
36: pay_txr_ins.g_jurisdiction_code_i := p_jurisdiction_code;
37: pay_txr_ins.g_tax_type_i := p_tax_type;
38: pay_txr_ins.g_tax_category_i := p_tax_category;

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

39: pay_txr_ins.g_classification_id_i := p_classification_id;
40: pay_txr_ins.g_taxability_rules_date_id_i := p_taxability_rules_date_id;
41: pay_txr_ins.g_secondary_class_id_i := p_secondary_classification_id;
42: --
43: hr_utility.set_location(' Leaving:'||l_proc, 20);
44: End set_base_key_value;
45: --
46: --
47: -- ----------------------------------------------------------------------------

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

94: l_proc varchar2(72) := g_package||'insert_dml';
95: num number;
96: --
97: Begin
98: hr_utility.set_location('Entering:'||l_proc, 5);
99: --
100: --
101: --
102: --

Line 105: hr_utility.trace('p_rec.jurisdiction_code '||p_rec.jurisdiction_code);

101: --
102: --
103: -- Insert the row into: pay_taxability_rules
104: --
105: hr_utility.trace('p_rec.jurisdiction_code '||p_rec.jurisdiction_code);
106: hr_utility.trace('p_rec.tax_type '||p_rec.tax_type);
107: hr_utility.trace('p_rec.tax_category '||p_rec.tax_category);
108: hr_utility.trace('p_rec.classification_id '||to_char(p_rec.classification_id));
109: hr_utility.trace('p_rec.legislation_code '||p_rec.legislation_code);

Line 106: hr_utility.trace('p_rec.tax_type '||p_rec.tax_type);

102: --
103: -- Insert the row into: pay_taxability_rules
104: --
105: hr_utility.trace('p_rec.jurisdiction_code '||p_rec.jurisdiction_code);
106: hr_utility.trace('p_rec.tax_type '||p_rec.tax_type);
107: hr_utility.trace('p_rec.tax_category '||p_rec.tax_category);
108: hr_utility.trace('p_rec.classification_id '||to_char(p_rec.classification_id));
109: hr_utility.trace('p_rec.legislation_code '||p_rec.legislation_code);
110: hr_utility.trace('p_rec.status '||p_rec.status);

Line 107: hr_utility.trace('p_rec.tax_category '||p_rec.tax_category);

103: -- Insert the row into: pay_taxability_rules
104: --
105: hr_utility.trace('p_rec.jurisdiction_code '||p_rec.jurisdiction_code);
106: hr_utility.trace('p_rec.tax_type '||p_rec.tax_type);
107: hr_utility.trace('p_rec.tax_category '||p_rec.tax_category);
108: hr_utility.trace('p_rec.classification_id '||to_char(p_rec.classification_id));
109: hr_utility.trace('p_rec.legislation_code '||p_rec.legislation_code);
110: hr_utility.trace('p_rec.status '||p_rec.status);
111: hr_utility.trace('p_rec.secondary_classification_id '||

Line 108: hr_utility.trace('p_rec.classification_id '||to_char(p_rec.classification_id));

104: --
105: hr_utility.trace('p_rec.jurisdiction_code '||p_rec.jurisdiction_code);
106: hr_utility.trace('p_rec.tax_type '||p_rec.tax_type);
107: hr_utility.trace('p_rec.tax_category '||p_rec.tax_category);
108: hr_utility.trace('p_rec.classification_id '||to_char(p_rec.classification_id));
109: hr_utility.trace('p_rec.legislation_code '||p_rec.legislation_code);
110: hr_utility.trace('p_rec.status '||p_rec.status);
111: hr_utility.trace('p_rec.secondary_classification_id '||
112: to_char(p_rec.secondary_classification_id));

Line 109: hr_utility.trace('p_rec.legislation_code '||p_rec.legislation_code);

105: hr_utility.trace('p_rec.jurisdiction_code '||p_rec.jurisdiction_code);
106: hr_utility.trace('p_rec.tax_type '||p_rec.tax_type);
107: hr_utility.trace('p_rec.tax_category '||p_rec.tax_category);
108: hr_utility.trace('p_rec.classification_id '||to_char(p_rec.classification_id));
109: hr_utility.trace('p_rec.legislation_code '||p_rec.legislation_code);
110: hr_utility.trace('p_rec.status '||p_rec.status);
111: hr_utility.trace('p_rec.secondary_classification_id '||
112: to_char(p_rec.secondary_classification_id));
113: insert into pay_taxability_rules

Line 110: hr_utility.trace('p_rec.status '||p_rec.status);

106: hr_utility.trace('p_rec.tax_type '||p_rec.tax_type);
107: hr_utility.trace('p_rec.tax_category '||p_rec.tax_category);
108: hr_utility.trace('p_rec.classification_id '||to_char(p_rec.classification_id));
109: hr_utility.trace('p_rec.legislation_code '||p_rec.legislation_code);
110: hr_utility.trace('p_rec.status '||p_rec.status);
111: hr_utility.trace('p_rec.secondary_classification_id '||
112: to_char(p_rec.secondary_classification_id));
113: insert into pay_taxability_rules
114: (jurisdiction_code

Line 111: hr_utility.trace('p_rec.secondary_classification_id '||

107: hr_utility.trace('p_rec.tax_category '||p_rec.tax_category);
108: hr_utility.trace('p_rec.classification_id '||to_char(p_rec.classification_id));
109: hr_utility.trace('p_rec.legislation_code '||p_rec.legislation_code);
110: hr_utility.trace('p_rec.status '||p_rec.status);
111: hr_utility.trace('p_rec.secondary_classification_id '||
112: to_char(p_rec.secondary_classification_id));
113: insert into pay_taxability_rules
114: (jurisdiction_code
115: ,tax_type

Line 140: hr_utility.set_location(' Leaving:'||l_proc, 10);

136: from pay_taxability_rules
137: where jurisdiction_code = p_rec.jurisdiction_code;
138: --
139: --
140: hr_utility.set_location(' Leaving:'||l_proc, 10);
141: hr_utility.set_location(' Num:'|| to_char(num), 20);
142: Exception
143: When hr_api.check_integrity_violated Then
144: -- A check constraint has been violated

Line 141: hr_utility.set_location(' Num:'|| to_char(num), 20);

137: where jurisdiction_code = p_rec.jurisdiction_code;
138: --
139: --
140: hr_utility.set_location(' Leaving:'||l_proc, 10);
141: hr_utility.set_location(' Num:'|| to_char(num), 20);
142: Exception
143: When hr_api.check_integrity_violated Then
144: -- A check constraint has been violated
145: --

Line 160: hr_utility.trace('Exception in '||SQLERRM);

156: pay_txr_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When Others Then
159: --
160: hr_utility.trace('Exception in '||SQLERRM);
161: Raise;
162: End insert_dml;
163: --
164: -- ----------------------------------------------------------------------------

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

230: l_exists varchar2(1);
231: ln_rules_nextval pay_taxability_rules_dates.taxability_rules_date_id%TYPE;
232: --
233: Begin
234: hr_utility.set_location('Entering:'||l_proc, 5);
235: --
236: If (pay_txr_ins.g_jurisdiction_code_i is not null or
237: pay_txr_ins.g_tax_type_i is not null or
238: pay_txr_ins.g_tax_category_i is not null or

Line 323: hr_utility.set_location(' Leaving:'||l_proc, 10);

319:
320: Close C_Sel1;
321: End If;
322: --
323: hr_utility.set_location(' Leaving:'||l_proc, 10);
324: End pre_insert;
325: --
326: -- ----------------------------------------------------------------------------
327: -- |-----------------------------< post_insert >------------------------------|

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

362: --
363: l_proc varchar2(72) := g_package||'post_insert';
364: --
365: Begin
366: hr_utility.set_location('Entering:'||l_proc, 5);
367: begin
368: --
369: pay_txr_rki.after_insert
370: (p_effective_date => p_effective_date

Line 399: hr_utility.set_location(' Leaving:'||l_proc, 10);

395: ,p_hook_type => 'AI');
396: --
397: end;
398: --
399: hr_utility.set_location(' Leaving:'||l_proc, 10);
400: End post_insert;
401: --
402: -- ----------------------------------------------------------------------------
403: -- |---------------------------------< ins >----------------------------------|

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

409: --
410: l_proc varchar2(72) := g_package||'ins';
411: --
412: Begin
413: hr_utility.set_location('Entering:'||l_proc, 5);
414: --
415: -- Call the supporting insert validate operations
416: --
417: pay_txr_bus.insert_validate

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

439: --
440: -- Call to raise any errors on multi-message list
441: hr_multi_message.end_validation_set;
442: --
443: hr_utility.set_location('Leaving:'||l_proc, 20);
444: end ins;
445: --
446: -- ----------------------------------------------------------------------------
447: -- |---------------------------------< ins >----------------------------------|

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

461: l_rec pay_txr_shd.g_rec_type;
462: l_proc varchar2(72) := g_package||'ins';
463: --
464: Begin
465: hr_utility.set_location('Entering:'||l_proc, 5);
466: hr_utility.trace('In Procedure ins');
467: --
468: -- Call conversion function to turn arguments into the
469: -- p_rec structure.

Line 466: hr_utility.trace('In Procedure ins');

462: l_proc varchar2(72) := g_package||'ins';
463: --
464: Begin
465: hr_utility.set_location('Entering:'||l_proc, 5);
466: hr_utility.trace('In Procedure ins');
467: --
468: -- Call conversion function to turn arguments into the
469: -- p_rec structure.
470: --

Line 471: hr_utility.trace('Before calling pay_txr_shd.convert_args ');

467: --
468: -- Call conversion function to turn arguments into the
469: -- p_rec structure.
470: --
471: hr_utility.trace('Before calling pay_txr_shd.convert_args ');
472: l_rec :=
473: pay_txr_shd.convert_args
474: (p_jurisdiction_code
475: ,p_tax_type

Line 484: hr_utility.trace('After calling pay_txr_shd.convert_args ');

480: ,p_status
481: ,p_secondary_classification_id
482: );
483: --
484: hr_utility.trace('After calling pay_txr_shd.convert_args ');
485: -- Having converted the arguments into the pay_txr_rec
486: -- plsql record structure we call the corresponding record business process.
487: --
488: hr_utility.trace('Before calling pay_txr_ins.ins ');

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

484: hr_utility.trace('After calling pay_txr_shd.convert_args ');
485: -- Having converted the arguments into the pay_txr_rec
486: -- plsql record structure we call the corresponding record business process.
487: --
488: hr_utility.trace('Before calling pay_txr_ins.ins ');
489: pay_txr_ins.ins
490: (p_effective_date
491: ,l_rec
492: );

Line 495: hr_utility.set_location(' Leaving:'||l_proc, 10);

491: ,l_rec
492: );
493: --
494: --
495: hr_utility.set_location(' Leaving:'||l_proc, 10);
496: End ins;
497: --
498: end pay_txr_ins;