DBA Data[Home] [Help]

APPS.PAY_MONETARY_UNITS_PKG dependencies on HR_UTILITY

Line 20: hr_utility.set_location('pay_monetary_units_pkg.pop_flds',1);

16: where territory_code = p_terr_code;
17: --
18: begin
19: --
20: hr_utility.set_location('pay_monetary_units_pkg.pop_flds',1);
21: --
22: open c2;
23: --
24: fetch c2 into p_country;

Line 63: hr_utility.set_location('pay_monetary_units_pkg.chk_unq_row',1);

59: or (p_rowid is not null and chartorowid(p_rowid) <> pmu.rowid));
60: --
61: begin
62: --
63: hr_utility.set_location('pay_monetary_units_pkg.chk_unq_row',1);
64: --
65: if p_unit_name is not null then
66: open c3('MONETARY_UNIT_NAME');
67: --

Line 70: hr_utility.set_message(801, 'PAY_6777_DEF_CURR_UNIT_EXISTS');

66: open c3('MONETARY_UNIT_NAME');
67: --
68: fetch c3 into l_exists;
69: IF c3%found THEN
70: hr_utility.set_message(801, 'PAY_6777_DEF_CURR_UNIT_EXISTS');
71: hr_utility.set_message_token('1','name');
72: close c3;
73: hr_utility.raise_error;
74: END IF;

Line 71: hr_utility.set_message_token('1','name');

67: --
68: fetch c3 into l_exists;
69: IF c3%found THEN
70: hr_utility.set_message(801, 'PAY_6777_DEF_CURR_UNIT_EXISTS');
71: hr_utility.set_message_token('1','name');
72: close c3;
73: hr_utility.raise_error;
74: END IF;
75: --

Line 73: hr_utility.raise_error;

69: IF c3%found THEN
70: hr_utility.set_message(801, 'PAY_6777_DEF_CURR_UNIT_EXISTS');
71: hr_utility.set_message_token('1','name');
72: close c3;
73: hr_utility.raise_error;
74: END IF;
75: --
76: close c3;
77: end if;

Line 84: hr_utility.set_message(801, 'PAY_6777_DEF_CURR_UNIT_EXISTS');

80: open c3('RELATIVE_VALUE');
81: --
82: fetch c3 into l_exists;
83: IF c3%found THEN
84: hr_utility.set_message(801, 'PAY_6777_DEF_CURR_UNIT_EXISTS');
85: hr_utility.set_message_token('1','value');
86: close c3;
87: hr_utility.raise_error;
88: END IF;

Line 85: hr_utility.set_message_token('1','value');

81: --
82: fetch c3 into l_exists;
83: IF c3%found THEN
84: hr_utility.set_message(801, 'PAY_6777_DEF_CURR_UNIT_EXISTS');
85: hr_utility.set_message_token('1','value');
86: close c3;
87: hr_utility.raise_error;
88: END IF;
89: --

Line 87: hr_utility.raise_error;

83: IF c3%found THEN
84: hr_utility.set_message(801, 'PAY_6777_DEF_CURR_UNIT_EXISTS');
85: hr_utility.set_message_token('1','value');
86: close c3;
87: hr_utility.raise_error;
88: END IF;
89: --
90: close c3;
91: end if;

Line 104: hr_utility.set_location('pay_monetary_units_pkg.get_id',1);

100: from sys.dual;
101: --
102: begin
103: --
104: hr_utility.set_location('pay_monetary_units_pkg.get_id',1);
105: --
106: open c4;
107: --
108: fetch c4 into p_munit_id;

Line 125: hr_utility.set_location('pay_monetary_units_pkg.stb_del_valid',1);

121: where monetary_unit_id = p_munit_id;
122: --
123: begin
124: --
125: hr_utility.set_location('pay_monetary_units_pkg.stb_del_valid',1);
126: --
127: open c5;
128: --
129: fetch c5 into l_exists;

Line 131: hr_utility.set_message(801, 'PAY_6780_DEF_CURR_UNIT_RULES');

127: open c5;
128: --
129: fetch c5 into l_exists;
130: IF c5%found THEN
131: hr_utility.set_message(801, 'PAY_6780_DEF_CURR_UNIT_RULES');
132: close c5;
133: hr_utility.raise_error;
134: END IF;
135: --

Line 133: hr_utility.raise_error;

129: fetch c5 into l_exists;
130: IF c5%found THEN
131: hr_utility.set_message(801, 'PAY_6780_DEF_CURR_UNIT_RULES');
132: close c5;
133: hr_utility.raise_error;
134: END IF;
135: --
136: close c5;
137: --

Line 317: hr_utility.set_location('Entering Update_row',30);

313: X_LAST_UPDATED_BY in NUMBER,
314: X_LAST_UPDATE_LOGIN in NUMBER
315: ) is
316: begin
317: hr_utility.set_location('Entering Update_row',30);
318: --
319: chk_unq_row(p_cur_code => X_CURRENCY_CODE
320: ,p_unit_name => X_MONETARY_UNIT_NAME
321: ,p_rel_value => X_RELATIVE_VALUE

Line 657: hr_utility.set_location(l_proc_name, 5);

653: l_leg_code VARCHAR2(150) := nvl(p_legislation_code, g_legislation_code);
654: l_exists number(1);
655: --
656: begin
657: hr_utility.set_location(l_proc_name, 5);
658: --
659: open c_translation(p_language
660: ,p_monetary_unit_name
661: ,p_monetary_unit_id

Line 674: hr_utility.set_location(l_proc_name, 10);

670: else
671: close c_translation;
672: end if;
673: --
674: hr_utility.set_location(l_proc_name, 10);
675: end VALIDATE_TRANSLATION;
676: --
677: end PAY_MONETARY_UNITS_PKG;