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.IGS_CA_COMPUTE_DA_VAL_PKG dependencies on FND_LOG

Line 170: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

166: l_prg_type := p_prog_type;
167: l_prd_cd := p_prog_ver;
168: l_app_type := p_app_type;
169:
170: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
171: l_debug_str := 'Starting values : Sys Date Type ='||p_sys_date_type||'Cal Type =' || p_cal_type || 'Seq Num ='||p_seq_number ||
172: 'Org Unit ='|| l_org_unit||'Prog Type ='||l_prg_type || 'Prog Ver ='||l_prd_cd || 'App_Type = '|| l_app_type;
173: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
174: END IF;

Line 173: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

169:
170: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
171: l_debug_str := 'Starting values : Sys Date Type ='||p_sys_date_type||'Cal Type =' || p_cal_type || 'Seq Num ='||p_seq_number ||
172: 'Org Unit ='|| l_org_unit||'Prog Type ='||l_prg_type || 'Prog Ver ='||l_prd_cd || 'App_Type = '|| l_app_type;
173: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
174: END IF;
175:
176:
177: IF ((l_app_type IS NOT NULL) AND (NOT l_found))

Line 188: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

184: l_dt_val := NULL;
185:
186: IF get_da_inst(l_dt_alias,p_cal_type,p_seq_number,l_dt_val)
187: THEN
188: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
189: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_val.DAI_found_for_overd_DA_at_app_type_lvl';
190: l_debug_str := 'Computed DAI for values : Date Alias ='||l_dt_alias||' Cal Type ='||p_cal_type||' Seq Num ='||p_seq_number;
191: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
192: END IF;

Line 191: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

187: THEN
188: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
189: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_val.DAI_found_for_overd_DA_at_app_type_lvl';
190: l_debug_str := 'Computed DAI for values : Date Alias ='||l_dt_alias||' Cal Type ='||p_cal_type||' Seq Num ='||p_seq_number;
191: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
192: END IF;
193: RETURN l_dt_val;
194: ELSE
195: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 195: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

191: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
192: END IF;
193: RETURN l_dt_val;
194: ELSE
195: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
196: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_val.DAI_not_found_for_overd_DA_at_prog_type_lvl';
197: l_debug_str := 'Tried computing DAI for values : Date Alias ='||l_dt_alias||' Cal Type ='||p_cal_type||' Seq Num ='||p_seq_number;
198: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
199: END IF;

Line 198: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

194: ELSE
195: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
196: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_val.DAI_not_found_for_overd_DA_at_prog_type_lvl';
197: l_debug_str := 'Tried computing DAI for values : Date Alias ='||l_dt_alias||' Cal Type ='||p_cal_type||' Seq Num ='||p_seq_number;
198: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
199: END IF;
200: l_found := FALSE; -- Go up the heirarchy and try to find the next available DA value.
201: END IF;
202: END IF;

Line 217: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

213: l_dt_val := NULL;
214:
215: IF get_da_inst(l_dt_alias,p_cal_type,p_seq_number,l_dt_val)
216: THEN
217: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
218: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_val.DAI_found_for_overd_DA_at_prog_ver_lvl';
219: l_debug_str := 'Computed DAI for values : Date Alias ='||l_dt_alias||' Cal Type ='||p_cal_type||' Seq Num ='||p_seq_number;
220: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
221: END IF;

Line 220: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

216: THEN
217: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
218: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_val.DAI_found_for_overd_DA_at_prog_ver_lvl';
219: l_debug_str := 'Computed DAI for values : Date Alias ='||l_dt_alias||' Cal Type ='||p_cal_type||' Seq Num ='||p_seq_number;
220: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
221: END IF;
222: RETURN l_dt_val;
223: ELSE
224: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 224: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

220: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
221: END IF;
222: RETURN l_dt_val;
223: ELSE
224: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
225: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_val.DAI_not_found_for_overd_DA_at_prog_ver_lvl';
226: l_debug_str := 'Tried computing DAI for values : Date Alias ='||l_dt_alias||' Cal Type ='||p_cal_type||' Seq Num ='||p_seq_number;
227: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
228: END IF;

Line 227: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

223: ELSE
224: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
225: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_val.DAI_not_found_for_overd_DA_at_prog_ver_lvl';
226: l_debug_str := 'Tried computing DAI for values : Date Alias ='||l_dt_alias||' Cal Type ='||p_cal_type||' Seq Num ='||p_seq_number;
227: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
228: END IF;
229: l_found := FALSE; -- Go up the heirarchy and try to find the next available DA value.
230: END IF;
231: END IF;

Line 245: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

241: l_dt_val := NULL;
242:
243: IF get_da_inst(l_dt_alias,p_cal_type,p_seq_number,l_dt_val)
244: THEN
245: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
246: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_val.DAI_found_for_overd_DA_at_prog_type_lvl';
247: l_debug_str := 'Computed DAI for values : Date Alias ='||l_dt_alias||' Cal Type ='||p_cal_type||' Seq Num ='||p_seq_number;
248: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
249: END IF;

Line 248: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

244: THEN
245: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
246: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_val.DAI_found_for_overd_DA_at_prog_type_lvl';
247: l_debug_str := 'Computed DAI for values : Date Alias ='||l_dt_alias||' Cal Type ='||p_cal_type||' Seq Num ='||p_seq_number;
248: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
249: END IF;
250: RETURN l_dt_val;
251: ELSE
252: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 252: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

248: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
249: END IF;
250: RETURN l_dt_val;
251: ELSE
252: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
253: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_val.DAI_not_found_for_overd_DA_at_prog_type_lvl';
254: l_debug_str := 'Tried computing DAI for values : Date Alias ='||l_dt_alias||' Cal Type ='||p_cal_type||' Seq Num ='||p_seq_number;
255: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
256: END IF;

Line 255: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

251: ELSE
252: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
253: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_val.DAI_not_found_for_overd_DA_at_prog_type_lvl';
254: l_debug_str := 'Tried computing DAI for values : Date Alias ='||l_dt_alias||' Cal Type ='||p_cal_type||' Seq Num ='||p_seq_number;
255: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
256: END IF;
257: l_found := FALSE; -- Go up the heirarchy and try to find the next available DA value.
258: END IF;
259: END IF;

Line 273: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

269: l_dt_val := NULL;
270:
271: IF get_da_inst(l_dt_alias,p_cal_type,p_seq_number,l_dt_val)
272: THEN
273: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
274: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_val.DAI_found_for_overd_DA_at_org_unit_lvl';
275: l_debug_str := 'Computed DAI for values : Date Alias ='||l_dt_alias||' Cal Type ='||p_cal_type||' Seq Num ='||p_seq_number;
276: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
277: END IF;

Line 276: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

272: THEN
273: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
274: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_val.DAI_found_for_overd_DA_at_org_unit_lvl';
275: l_debug_str := 'Computed DAI for values : Date Alias ='||l_dt_alias||' Cal Type ='||p_cal_type||' Seq Num ='||p_seq_number;
276: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
277: END IF;
278: RETURN l_dt_val;
279: ELSE
280: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 280: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

276: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
277: END IF;
278: RETURN l_dt_val;
279: ELSE
280: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
281: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_val.DAI_not_found_for_overd_DA_at_org_unit_lvl';
282: l_debug_str := 'Tried computing DAI for values : Date Alias ='||l_dt_alias||' Cal Type ='||p_cal_type||' Seq Num ='||p_seq_number;
283: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
284: END IF;

Line 283: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

279: ELSE
280: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
281: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_val.DAI_not_found_for_overd_DA_at_org_unit_lvl';
282: l_debug_str := 'Tried computing DAI for values : Date Alias ='||l_dt_alias||' Cal Type ='||p_cal_type||' Seq Num ='||p_seq_number;
283: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
284: END IF;
285: l_found := FALSE; -- Go up the heirarchy and try to find the next available DA value.
286: END IF;
287: END IF;

Line 304: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

300: l_dt_val := NULL;
301:
302: IF get_da_inst(l_dt_alias,p_cal_type,p_seq_number,l_dt_val)
303: THEN
304: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
305: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_val.DAI_found_for_default_DA_at_site_lvl';
306: l_debug_str := 'Computed DAI for values : Date Alias ='||l_dt_alias||' Cal Type ='||p_cal_type||' Seq Num ='||p_seq_number;
307: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
308: END IF;

Line 307: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

303: THEN
304: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
305: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_val.DAI_found_for_default_DA_at_site_lvl';
306: l_debug_str := 'Computed DAI for values : Date Alias ='||l_dt_alias||' Cal Type ='||p_cal_type||' Seq Num ='||p_seq_number;
307: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
308: END IF;
309: RETURN l_dt_val;
310: ELSE
311: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 311: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

307: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
308: END IF;
309: RETURN l_dt_val;
310: ELSE
311: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
312: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_val.DAI_not_found_for_default_DA_at_site_lvl';
313: l_debug_str := 'Tried computing DAI for values : Date Alias ='||l_dt_alias||' Cal Type ='||p_cal_type||' Seq Num ='||p_seq_number;
314: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
315: END IF;

Line 314: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

310: ELSE
311: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
312: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_val.DAI_not_found_for_default_DA_at_site_lvl';
313: l_debug_str := 'Tried computing DAI for values : Date Alias ='||l_dt_alias||' Cal Type ='||p_cal_type||' Seq Num ='||p_seq_number;
314: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
315: END IF;
316: RETURN NULL; -- NO DAI could be found out. Return NULL;
317: END IF;
318: ELSE

Line 319: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

315: END IF;
316: RETURN NULL; -- NO DAI could be found out. Return NULL;
317: END IF;
318: ELSE
319: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
320: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_val.No_default_DA_found_at_site_lvl';
321: l_debug_str := null;
322: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
323: END IF;

Line 322: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

318: ELSE
319: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
320: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_val.No_default_DA_found_at_site_lvl';
321: l_debug_str := null;
322: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
323: END IF;
324: RETURN NULL;
325: END IF;
326: END IF;

Line 329: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

325: END IF;
326: END IF;
327: EXCEPTION
328: WHEN OTHERS THEN
329: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
330: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_val.exception_occured';
331: l_debug_str := sqlerrm;
332: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
333: END IF;

Line 332: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

328: WHEN OTHERS THEN
329: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
330: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_val.exception_occured';
331: l_debug_str := sqlerrm;
332: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
333: END IF;
334: END cal_da_elt_val;
335:
336: FUNCTION cal_da_elt_ofst_val(p_dt_alias IN VARCHAR2,

Line 586: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

582: l_prog_ver := p_prog_ver;
583: l_app_type := p_app_type;
584: l_dai_val := NULL; -- To be returned by the function call.
585:
586: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
587: l_debug_str := 'Starting values : Date Alias ='||l_dt_alias||' DAI seq num ='||l_da_seq_num||' Cal Type ='||l_cal_type||' Seq Num ='||l_seq_num||
588: ' Org Unit ='||l_org_unit||' Prog Type ='||l_prog_type||' Prog Ver ='||l_prog_ver || ' App_Type = '|| l_app_type;
589: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
590: END IF;

Line 589: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

585:
586: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
587: l_debug_str := 'Starting values : Date Alias ='||l_dt_alias||' DAI seq num ='||l_da_seq_num||' Cal Type ='||l_cal_type||' Seq Num ='||l_seq_num||
588: ' Org Unit ='||l_org_unit||' Prog Type ='||l_prog_type||' Prog Ver ='||l_prog_ver || ' App_Type = '|| l_app_type;
589: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
590: END IF;
591:
592: l_da_ofst_level_rec := chk_da_ofst_lvl(l_dt_alias,l_da_seq_num,l_cal_type,l_seq_num);
593:

Line 594: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

590: END IF;
591:
592: l_da_ofst_level_rec := chk_da_ofst_lvl(l_dt_alias,l_da_seq_num,l_cal_type,l_seq_num);
593:
594: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
595: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.offset_level_info';
596: l_debug_str := 'Offset Level ='||l_da_ofst_level_rec.ofst_lvl ||
597: 'Offset DA = '||l_da_ofst_level_rec.dt_alias||
598: 'Offset DAI Seq num ='||l_da_ofst_level_rec.da_seq_num ||

Line 606: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

602: 'Week Offset ='||l_da_ofst_level_rec.week_offset||
603: 'Month Offset ='||l_da_ofst_level_rec.month_offset||
604: 'Year Offset ='||l_da_ofst_level_rec.year_offset ||
605: 'Offset override flag ='||l_da_ofst_level_rec.ofst_override;
606: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
607: END IF;
608:
609: IF (l_da_ofst_level_rec.ofst_lvl IS NULL)
610: THEN

Line 618: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

614: IF (l_da_used = 'NOT_USED_AT_ALL')
615: THEN
616: -- Call old API directly and return the value of the DAI.
617: l_dai_val := IGS_CA_GEN_001.calp_get_alias_val(l_dt_alias,l_da_seq_num,l_cal_type,l_seq_num);
618: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
619: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.DA_not_used_in_SDA';
620: l_debug_str := 'Computing DAI using values : Date Alias ='||l_dt_alias||' DAI Seq num ='||l_da_seq_num||' Cal Type ='||l_cal_type||' Seq num ='||l_seq_num;
621: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
622: END IF;

Line 621: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

617: l_dai_val := IGS_CA_GEN_001.calp_get_alias_val(l_dt_alias,l_da_seq_num,l_cal_type,l_seq_num);
618: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
619: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.DA_not_used_in_SDA';
620: l_debug_str := 'Computing DAI using values : Date Alias ='||l_dt_alias||' DAI Seq num ='||l_da_seq_num||' Cal Type ='||l_cal_type||' Seq num ='||l_seq_num;
621: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
622: END IF;
623: RETURN l_dai_val;
624: ELSIF (l_da_used = 'USED_MORE_THAN_ONE')
625: THEN

Line 629: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

625: THEN
626: -- Call old API directly and return the value of the DAI.
627: l_dai_val := IGS_CA_GEN_001.calp_get_alias_val(l_dt_alias,l_da_seq_num,l_cal_type,l_seq_num);
628:
629: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
630: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.DA_used_in_more_than_one_SDA';
631: l_debug_str := 'Computing DAI for original DAI : Date Alias ='||l_dt_alias||' DAI Seq num ='||l_da_seq_num||' Cal Type ='||l_cal_type||' Seq num ='||l_seq_num;
632: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
633: END IF;

Line 632: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

628:
629: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
630: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.DA_used_in_more_than_one_SDA';
631: l_debug_str := 'Computing DAI for original DAI : Date Alias ='||l_dt_alias||' DAI Seq num ='||l_da_seq_num||' Cal Type ='||l_cal_type||' Seq num ='||l_seq_num;
632: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
633: END IF;
634:
635: RETURN l_dai_val;
636: ELSE

Line 637: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

633: END IF;
634:
635: RETURN l_dai_val;
636: ELSE
637: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
638: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.DA_used_in_single_SDA';
639: l_debug_str := 'Calling generic function with values : Sys Date Type ='||l_da_used||
640: 'Cal Type ='||l_cal_type||' Seq Num ='||l_seq_num||' Org Unit ='||l_org_unit||' Prog Type ='||l_prog_type||' Prog Ver ='||l_prog_ver || ' App_Type = '|| l_app_type;
641: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

Line 641: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

637: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
638: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.DA_used_in_single_SDA';
639: l_debug_str := 'Calling generic function with values : Sys Date Type ='||l_da_used||
640: 'Cal Type ='||l_cal_type||' Seq Num ='||l_seq_num||' Org Unit ='||l_org_unit||' Prog Type ='||l_prog_type||' Prog Ver ='||l_prog_ver || ' App_Type = '|| l_app_type;
641: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
642: END IF;
643: l_dai_val := cal_da_elt_val(l_da_used,l_cal_type,l_seq_num,l_org_unit,l_prog_type,l_prog_ver, l_app_type);
644: IF (l_dai_val IS NOT NULL)
645: THEN

Line 648: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

644: IF (l_dai_val IS NOT NULL)
645: THEN
646: RETURN l_dai_val;
647: ELSE
648: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
649: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.No_value_returned_by_generic_function ';
650: fnd_log.string_with_context( fnd_log.level_statement,l_label,null, NULL,NULL,NULL,NULL,NULL,null);
651: END IF;
652: RETURN null;

Line 650: fnd_log.string_with_context( fnd_log.level_statement,l_label,null, NULL,NULL,NULL,NULL,NULL,null);

646: RETURN l_dai_val;
647: ELSE
648: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
649: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.No_value_returned_by_generic_function ';
650: fnd_log.string_with_context( fnd_log.level_statement,l_label,null, NULL,NULL,NULL,NULL,NULL,null);
651: END IF;
652: RETURN null;
653: END IF;
654: END IF;

Line 660: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

656: THEN
657: IF ((l_da_ofst_level_rec.ofst_lvl = 'DATE_ALIAS_INST') AND (l_da_ofst_level_rec.ofst_override = 'N' ))
658: THEN
659: -- Override flag set to 'N', compute the DAI for the offset DA and add the offset and return the value.
660: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
661: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.ofst_ovrd_uncheck_computing_DAI_value_for_passed_DA';
662: l_debug_str := 'Using : Ofst DA ='||l_da_ofst_level_rec.dt_alias||' Ofst DA seq num ='||l_da_ofst_level_rec.da_seq_num||
663: 'Ofst Cal Type ='||l_da_ofst_level_rec.offset_cal_type||' Ofst CI seq num ='||l_da_ofst_level_rec.offset_ci_sequence_number;
664: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

Line 664: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

660: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
661: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.ofst_ovrd_uncheck_computing_DAI_value_for_passed_DA';
662: l_debug_str := 'Using : Ofst DA ='||l_da_ofst_level_rec.dt_alias||' Ofst DA seq num ='||l_da_ofst_level_rec.da_seq_num||
663: 'Ofst Cal Type ='||l_da_ofst_level_rec.offset_cal_type||' Ofst CI seq num ='||l_da_ofst_level_rec.offset_ci_sequence_number;
664: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
665: END IF;
666: l_dai_val := IGS_CA_GEN_001.calp_get_alias_val(l_da_ofst_level_rec.dt_alias,l_da_ofst_level_rec.da_seq_num,l_da_ofst_level_rec.offset_cal_type,l_da_ofst_level_rec.offset_ci_sequence_number);
667: l_dai_val := add_offset(l_dai_val,l_da_ofst_level_rec);
668:

Line 673: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

669: -- Last step : resolve constraints if any, using IGS_CA_GEN_002.calp_clc_daio_cnstrt.
670:
671: l_msg := NULL;
672:
673: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
674: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.resolving_constraints';
675: l_debug_str := 'Resolving cnstrt on : Date Alias ='||l_dt_alias||'Date Alias seq num ='||l_da_seq_num||'Cal type ='||l_cal_type||'Seq num ='||l_seq_num||'DAI value ='||l_dai_val;
676: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
677: END IF;

Line 676: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

672:
673: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
674: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.resolving_constraints';
675: l_debug_str := 'Resolving cnstrt on : Date Alias ='||l_dt_alias||'Date Alias seq num ='||l_da_seq_num||'Cal type ='||l_cal_type||'Seq num ='||l_seq_num||'DAI value ='||l_dai_val;
676: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
677: END IF;
678:
679: l_final_val := IGS_CA_GEN_002.calp_clc_daio_cnstrt(l_dt_alias,
680: l_da_seq_num,

Line 688: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

684: l_msg);
685: IF (l_msg IS NOT NULL)
686: THEN
687: -- Could not resolve constrints, return the computed date value with the constraints unresolved.
688: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
689: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.constraints_not_resolved_returning_unresolved';
690: l_debug_str := l_msg;
691: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
692: END IF;

Line 691: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

687: -- Could not resolve constrints, return the computed date value with the constraints unresolved.
688: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
689: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.constraints_not_resolved_returning_unresolved';
690: l_debug_str := l_msg;
691: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
692: END IF;
693: RETURN l_dai_val;
694: ELSE
695: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 695: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

691: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
692: END IF;
693: RETURN l_dai_val;
694: ELSE
695: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
696: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.constraints_resolved_returning_value';
697: fnd_log.string_with_context( fnd_log.level_statement,l_label,null, NULL,NULL,NULL,NULL,NULL,null);
698: END IF;
699: RETURN l_final_val;

Line 697: fnd_log.string_with_context( fnd_log.level_statement,l_label,null, NULL,NULL,NULL,NULL,NULL,null);

693: RETURN l_dai_val;
694: ELSE
695: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
696: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.constraints_resolved_returning_value';
697: fnd_log.string_with_context( fnd_log.level_statement,l_label,null, NULL,NULL,NULL,NULL,NULL,null);
698: END IF;
699: RETURN l_final_val;
700: END IF;
701: END IF;

Line 710: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

706:
707: IF (l_da_used = 'NOT_USED_AT_ALL')
708: THEN
709: -- DA not used in any SDA, return the value for the initial DAI passsed.
710: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
711: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.ovrd_DA_not_used_in_sda';
712: l_debug_str := 'Computing DAI for initial values : Date Alias ='||l_dt_alias||'Seq num ='|| l_da_seq_num || ' Cal Type ='||l_cal_type || ' Seq num ='||l_seq_num;
713: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
714: END IF;

Line 713: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

709: -- DA not used in any SDA, return the value for the initial DAI passsed.
710: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
711: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.ovrd_DA_not_used_in_sda';
712: l_debug_str := 'Computing DAI for initial values : Date Alias ='||l_dt_alias||'Seq num ='|| l_da_seq_num || ' Cal Type ='||l_cal_type || ' Seq num ='||l_seq_num;
713: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
714: END IF;
715:
716: l_dai_val := IGS_CA_GEN_001.calp_get_alias_val(l_dt_alias,l_da_seq_num,l_cal_type,l_seq_num);
717: RETURN l_dai_val;

Line 721: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

717: RETURN l_dai_val;
718: ELSIF (l_da_used = 'USED_MORE_THAN_ONE')
719: THEN
720: -- DA not used in any SDA, return the value for the initial DAI passsed.
721: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
722: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.ovrd_DA_used_in_more_than_one_SDA';
723: l_debug_str := 'Returning DAI for original values : Date Alias ='||l_dt_alias||'Seq num ='|| l_da_seq_num || ' Cal Type ='||l_cal_type || ' Seq num ='||l_seq_num;
724: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
725: END IF;

Line 724: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

720: -- DA not used in any SDA, return the value for the initial DAI passsed.
721: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
722: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.ovrd_DA_used_in_more_than_one_SDA';
723: l_debug_str := 'Returning DAI for original values : Date Alias ='||l_dt_alias||'Seq num ='|| l_da_seq_num || ' Cal Type ='||l_cal_type || ' Seq num ='||l_seq_num;
724: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
725: END IF;
726: l_dai_val := IGS_CA_GEN_001.calp_get_alias_val(l_dt_alias,l_da_seq_num,l_cal_type,l_seq_num);
727: RETURN l_dai_val;
728: ELSE

Line 730: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

726: l_dai_val := IGS_CA_GEN_001.calp_get_alias_val(l_dt_alias,l_da_seq_num,l_cal_type,l_seq_num);
727: RETURN l_dai_val;
728: ELSE
729: -- Call generic to return the date value. If it returns add the offset and return.
730: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
731: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.ovrd_DA_used_in_single_SDA';
732: l_debug_str := 'Calling generic function with values : Date Alias ='||l_da_used|| ' Cal Type ='||l_cal_type||' Seq num ='||l_seq_num|| ' Org Unit ='||l_org_unit||
733: 'Prog Type ='||l_prog_type||' Prog Ver ='||l_prog_ver||' App Type ='||l_app_type;
734: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

Line 734: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

730: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
731: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.ovrd_DA_used_in_single_SDA';
732: l_debug_str := 'Calling generic function with values : Date Alias ='||l_da_used|| ' Cal Type ='||l_cal_type||' Seq num ='||l_seq_num|| ' Org Unit ='||l_org_unit||
733: 'Prog Type ='||l_prog_type||' Prog Ver ='||l_prog_ver||' App Type ='||l_app_type;
734: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
735: END IF;
736:
737: l_dai_val := cal_da_elt_val(l_da_used,l_cal_type,l_seq_num,l_org_unit,l_prog_type,l_prog_ver, l_app_type);
738:

Line 741: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

737: l_dai_val := cal_da_elt_val(l_da_used,l_cal_type,l_seq_num,l_org_unit,l_prog_type,l_prog_ver, l_app_type);
738:
739: IF (l_dai_val IS NULL)
740: THEN
741: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
742: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.generic_function_returned_null';
743: l_debug_str := null;
744: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
745: END IF;

Line 744: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

740: THEN
741: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
742: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.generic_function_returned_null';
743: l_debug_str := null;
744: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
745: END IF;
746: RETURN null;
747: ELSE
748: l_dai_val := add_offset(l_dai_val,l_da_ofst_level_rec);

Line 751: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

747: ELSE
748: l_dai_val := add_offset(l_dai_val,l_da_ofst_level_rec);
749: l_msg := NULL;
750:
751: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
752: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.got_DAI_resolving_constraints';
753: l_debug_str := 'Resolving cnstrt on : Date Alias ='||l_dt_alias||'Date Alias seq num ='||l_da_seq_num||'Cal type ='||l_cal_type||'Seq num ='||l_seq_num||'DAI value ='||l_dai_val;
754: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
755: END IF;

Line 754: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

750:
751: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
752: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.got_DAI_resolving_constraints';
753: l_debug_str := 'Resolving cnstrt on : Date Alias ='||l_dt_alias||'Date Alias seq num ='||l_da_seq_num||'Cal type ='||l_cal_type||'Seq num ='||l_seq_num||'DAI value ='||l_dai_val;
754: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
755: END IF;
756: l_final_val := IGS_CA_GEN_002.calp_clc_daio_cnstrt(l_dt_alias,
757: l_da_seq_num,
758: l_cal_type,

Line 765: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

761: l_msg);
762: IF (l_msg IS NOT NULL)
763: THEN
764: -- Could not resolve constrints, return the computed date value with the constraints unresolved.
765: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
766: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.constraints_not_resolved_returning_unresolved';
767: l_debug_str := l_msg;
768: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
769: END IF;

Line 768: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

764: -- Could not resolve constrints, return the computed date value with the constraints unresolved.
765: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
766: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.constraints_not_resolved_returning_unresolved';
767: l_debug_str := l_msg;
768: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
769: END IF;
770: RETURN l_dai_val;
771: ELSE
772: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 772: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

768: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
769: END IF;
770: RETURN l_dai_val;
771: ELSE
772: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
773: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.constraints_resolved';
774: l_debug_str := null;
775: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
776: END IF;

Line 775: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

771: ELSE
772: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
773: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.constraints_resolved';
774: l_debug_str := null;
775: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
776: END IF;
777: RETURN l_final_val;
778: END IF;
779: END IF;