87: if c_get_def_bal_id%notfound then
88: open c_get_balance_name;
89: fetch c_get_balance_name into l_bal_name;
90: close c_get_balance_name;
91: hr_utility.set_message(801,'HR_AU_BAL_DIM_NOT_DEFINED');
92: hr_utility.set_message_token('DIMENSION',l_run_dim_name); --2610141
93: hr_utility.set_message_token('BALANCE_NAME',l_bal_name);
94: return(-1);
95: end if;
88: open c_get_balance_name;
89: fetch c_get_balance_name into l_bal_name;
90: close c_get_balance_name;
91: hr_utility.set_message(801,'HR_AU_BAL_DIM_NOT_DEFINED');
92: hr_utility.set_message_token('DIMENSION',l_run_dim_name); --2610141
93: hr_utility.set_message_token('BALANCE_NAME',l_bal_name);
94: return(-1);
95: end if;
96: close c_get_def_bal_id;
89: fetch c_get_balance_name into l_bal_name;
90: close c_get_balance_name;
91: hr_utility.set_message(801,'HR_AU_BAL_DIM_NOT_DEFINED');
92: hr_utility.set_message_token('DIMENSION',l_run_dim_name); --2610141
93: hr_utility.set_message_token('BALANCE_NAME',l_bal_name);
94: return(-1);
95: end if;
96: close c_get_def_bal_id;
97:
139: if c_get_def_bal_id%notfound then
140: open c_get_balance_name;
141: fetch c_get_balance_name into l_bal_name;
142: close c_get_balance_name;
143: hr_utility.set_message(801,'HR_AU_BAL_DIM_NOT_DEFINED');
144: hr_utility.set_message_token('DIMENSION',l_mtd_dim_name); --2610141
145: hr_utility.set_message_token('BALANCE_NAME',l_bal_name);
146: return(-2);
147: end if;
140: open c_get_balance_name;
141: fetch c_get_balance_name into l_bal_name;
142: close c_get_balance_name;
143: hr_utility.set_message(801,'HR_AU_BAL_DIM_NOT_DEFINED');
144: hr_utility.set_message_token('DIMENSION',l_mtd_dim_name); --2610141
145: hr_utility.set_message_token('BALANCE_NAME',l_bal_name);
146: return(-2);
147: end if;
148: close c_get_def_bal_id;
141: fetch c_get_balance_name into l_bal_name;
142: close c_get_balance_name;
143: hr_utility.set_message(801,'HR_AU_BAL_DIM_NOT_DEFINED');
144: hr_utility.set_message_token('DIMENSION',l_mtd_dim_name); --2610141
145: hr_utility.set_message_token('BALANCE_NAME',l_bal_name);
146: return(-2);
147: end if;
148: close c_get_def_bal_id;
149:
184: if c_get_def_bal_id%notfound then
185: open c_get_balance_name;
186: fetch c_get_balance_name into l_bal_name;
187: close c_get_balance_name;
188: hr_utility.set_message(801,'HR_AU_BAL_DIM_NOT_DEFINED');
189: hr_utility.set_message_token('DIMENSION',l_qtd_dim_name); --2610141
190: hr_utility.set_message_token('BALANCE_NAME',l_bal_name);
191: return(-3);
192: end if;
185: open c_get_balance_name;
186: fetch c_get_balance_name into l_bal_name;
187: close c_get_balance_name;
188: hr_utility.set_message(801,'HR_AU_BAL_DIM_NOT_DEFINED');
189: hr_utility.set_message_token('DIMENSION',l_qtd_dim_name); --2610141
190: hr_utility.set_message_token('BALANCE_NAME',l_bal_name);
191: return(-3);
192: end if;
193: close c_get_def_bal_id;
186: fetch c_get_balance_name into l_bal_name;
187: close c_get_balance_name;
188: hr_utility.set_message(801,'HR_AU_BAL_DIM_NOT_DEFINED');
189: hr_utility.set_message_token('DIMENSION',l_qtd_dim_name); --2610141
190: hr_utility.set_message_token('BALANCE_NAME',l_bal_name);
191: return(-3);
192: end if;
193: close c_get_def_bal_id;
194:
223: );
224:
225: END IF ;
226:
227: hr_utility.trace('p_bal_run '||p_bal_run);
228: hr_utility.trace('p_bal_mtd '||p_bal_mtd);
229: hr_utility.trace('p_bal_qtd '||p_bal_qtd);
230:
231: return(0);
224:
225: END IF ;
226:
227: hr_utility.trace('p_bal_run '||p_bal_run);
228: hr_utility.trace('p_bal_mtd '||p_bal_mtd);
229: hr_utility.trace('p_bal_qtd '||p_bal_qtd);
230:
231: return(0);
232:
225: END IF ;
226:
227: hr_utility.trace('p_bal_run '||p_bal_run);
228: hr_utility.trace('p_bal_mtd '||p_bal_mtd);
229: hr_utility.trace('p_bal_qtd '||p_bal_qtd);
230:
231: return(0);
232:
233: exception