eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 246: hr_utility.set_location('Entering:'||l_proc, 5);

242: l_sec_ele_class_exists varchar2(1);
243: ln_rules_nextval pay_taxability_rules_dates.taxability_rules_date_id%TYPE;
244: --
245: Begin
246: hr_utility.set_location('Entering:'||l_proc, 5);
247: --
248: -- Bug 11894789
249: --
250: IF substr(fnd_release.release_name,1,2) = '12' and substr(fnd_release.release_name,4,1) >= '2' THEN

Line 252: hr_utility.trace('Before Ele Class Validation ');

248: -- Bug 11894789
249: --
250: IF substr(fnd_release.release_name,1,2) = '12' and substr(fnd_release.release_name,4,1) >= '2' THEN
251:
252: hr_utility.trace('Before Ele Class Validation ');
253:
254: Open c_ele_class_validation;
255: Fetch c_ele_class_validation into l_ele_class_exists;
256: If c_ele_class_validation%notfound Then

Line 273: hr_utility.trace('Before Sec Ele Class Validation ');

269: Close c_ele_class_validation;
270:
271: IF p_rec.secondary_classification_id IS NOT NULL THEN
272:
273: hr_utility.trace('Before Sec Ele Class Validation ');
274:
275: Open c_sec_ele_class_validation;
276: Fetch c_sec_ele_class_validation into l_sec_ele_class_exists;
277: If c_sec_ele_class_validation%notfound Then

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

376:
377: Close C_Sel1;
378: End If;
379: --
380: hr_utility.set_location(' Leaving:'||l_proc, 10);
381: End pre_insert;
382: --
383: -- ----------------------------------------------------------------------------
384: -- |-----------------------------< post_insert >------------------------------|

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

419: --
420: l_proc varchar2(72) := g_package||'post_insert';
421: --
422: Begin
423: hr_utility.set_location('Entering:'||l_proc, 5);
424: begin
425: --
426: pay_txr_rki.after_insert
427: (p_effective_date => p_effective_date

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

452: ,p_hook_type => 'AI');
453: --
454: end;
455: --
456: hr_utility.set_location(' Leaving:'||l_proc, 10);
457: End post_insert;
458: --
459: -- ----------------------------------------------------------------------------
460: -- |---------------------------------< ins >----------------------------------|

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

466: --
467: l_proc varchar2(72) := g_package||'ins';
468: --
469: Begin
470: hr_utility.set_location('Entering:'||l_proc, 5);
471: --
472: -- Call the supporting insert validate operations
473: --
474: pay_txr_bus.insert_validate

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

496: --
497: -- Call to raise any errors on multi-message list
498: hr_multi_message.end_validation_set;
499: --
500: hr_utility.set_location('Leaving:'||l_proc, 20);
501: end ins;
502: --
503: -- ----------------------------------------------------------------------------
504: -- |---------------------------------< ins >----------------------------------|

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

518: l_rec pay_txr_shd.g_rec_type;
519: l_proc varchar2(72) := g_package||'ins';
520: --
521: Begin
522: hr_utility.set_location('Entering:'||l_proc, 5);
523: hr_utility.trace('In Procedure ins');
524: --
525: -- Call conversion function to turn arguments into the
526: -- p_rec structure.

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

519: l_proc varchar2(72) := g_package||'ins';
520: --
521: Begin
522: hr_utility.set_location('Entering:'||l_proc, 5);
523: hr_utility.trace('In Procedure ins');
524: --
525: -- Call conversion function to turn arguments into the
526: -- p_rec structure.
527: --

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

524: --
525: -- Call conversion function to turn arguments into the
526: -- p_rec structure.
527: --
528: hr_utility.trace('Before calling pay_txr_shd.convert_args ');
529: l_rec :=
530: pay_txr_shd.convert_args
531: (p_jurisdiction_code
532: ,p_tax_type

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

537: ,p_status
538: ,p_secondary_classification_id
539: );
540: --
541: hr_utility.trace('After calling pay_txr_shd.convert_args ');
542: -- Having converted the arguments into the pay_txr_rec
543: -- plsql record structure we call the corresponding record business process.
544: --
545: hr_utility.trace('Before calling pay_txr_ins.ins ');

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

541: hr_utility.trace('After calling pay_txr_shd.convert_args ');
542: -- Having converted the arguments into the pay_txr_rec
543: -- plsql record structure we call the corresponding record business process.
544: --
545: hr_utility.trace('Before calling pay_txr_ins.ins ');
546: pay_txr_ins.ins
547: (p_effective_date
548: ,l_rec
549: );

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

548: ,l_rec
549: );
550: --
551: --
552: hr_utility.set_location(' Leaving:'||l_proc, 10);
553: End ins;
554: --
555: end pay_txr_ins;