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 IGS_CA_COMPUTE_DA_VAL_PKG

Line 1: PACKAGE BODY IGS_CA_COMPUTE_DA_VAL_PKG

1: PACKAGE BODY IGS_CA_COMPUTE_DA_VAL_PKG
2: /* $Header: IGSCA15B.pls 120.1 2005/08/16 22:19:44 appldev noship $ */
3: /*****************************************************
4: || Created By : Navin Sidana
5: || Created On : 10/13/2004

Line 162: l_prog_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_val';

158: END get_da_inst; --
159:
160: BEGIN /* Main Procedure begins here */
161:
162: l_prog_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_val';
163: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_val.start';
164:
165: l_org_unit := p_org_unit;
166: l_prg_type := p_prog_type;

Line 163: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_val.start';

159:
160: BEGIN /* Main Procedure begins here */
161:
162: l_prog_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_val';
163: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_val.start';
164:
165: l_org_unit := p_org_unit;
166: l_prg_type := p_prog_type;
167: l_prd_cd := p_prog_ver;

Line 189: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_val.DAI_found_for_overd_DA_at_app_type_lvl';

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;
193: RETURN l_dt_val;

Line 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';

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;
200: l_found := FALSE; -- Go up the heirarchy and try to find the next available DA value.

Line 218: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_val.DAI_found_for_overd_DA_at_prog_ver_lvl';

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;
222: RETURN l_dt_val;

Line 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';

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;
229: l_found := FALSE; -- Go up the heirarchy and try to find the next available DA value.

Line 246: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_val.DAI_found_for_overd_DA_at_prog_type_lvl';

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;
250: RETURN l_dt_val;

Line 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';

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;
257: l_found := FALSE; -- Go up the heirarchy and try to find the next available DA value.

Line 274: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_val.DAI_found_for_overd_DA_at_org_unit_lvl';

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;
278: RETURN l_dt_val;

Line 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';

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;
285: l_found := FALSE; -- Go up the heirarchy and try to find the next available DA value.

Line 305: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_val.DAI_found_for_default_DA_at_site_lvl';

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;
309: RETURN l_dt_val;

Line 312: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_val.DAI_not_found_for_default_DA_at_site_lvl';

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;
316: RETURN NULL; -- NO DAI could be found out. Return NULL;

Line 320: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_val.No_default_DA_found_at_site_lvl';

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;
324: RETURN NULL;

Line 330: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_val.exception_occured';

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;
334: END cal_da_elt_val;

Line 573: l_prog_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val';

569: END;
570:
571: BEGIN /* Main */
572:
573: l_prog_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val';
574: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.start';
575:
576: l_dt_alias := p_dt_alias;
577: l_da_seq_num := p_da_seq_num;

Line 574: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.start';

570:
571: BEGIN /* Main */
572:
573: l_prog_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val';
574: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.start';
575:
576: l_dt_alias := p_dt_alias;
577: l_da_seq_num := p_da_seq_num;
578: l_cal_type := p_cal_type;

Line 595: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.offset_level_info';

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 ||
599: 'Offset DA Cal Type ='||l_da_ofst_level_rec.offset_cal_type ||

Line 619: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.DA_not_used_in_SDA';

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;
623: RETURN l_dai_val;

Line 630: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.DA_used_in_more_than_one_SDA';

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;
634:

Line 638: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.DA_used_in_single_SDA';

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);
642: END IF;

Line 649: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.No_value_returned_by_generic_function ';

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;
653: END IF;

Line 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';

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);
665: END IF;

Line 674: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.resolving_constraints';

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;
678:

Line 689: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.constraints_not_resolved_returning_unresolved';

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;
693: RETURN l_dai_val;

Line 696: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.constraints_resolved_returning_value';

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;
700: END IF;

Line 711: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.ovrd_DA_not_used_in_sda';

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;
715:

Line 722: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.ovrd_DA_used_in_more_than_one_SDA';

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;
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);

Line 731: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.ovrd_DA_used_in_single_SDA';

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);
735: END IF;

Line 742: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.generic_function_returned_null';

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;
746: RETURN null;

Line 752: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.got_DAI_resolving_constraints';

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;
756: l_final_val := IGS_CA_GEN_002.calp_clc_daio_cnstrt(l_dt_alias,

Line 766: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.constraints_not_resolved_returning_unresolved';

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;
770: RETURN l_dai_val;

Line 773: l_label := 'igs.plsql.igs_ca_compute_da_val_pkg.cal_da_elt_ofst_val.constraints_resolved';

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;
777: RETURN l_final_val;

Line 783: END IGS_CA_COMPUTE_DA_VAL_PKG;

779: END IF;
780: END IF;
781: END IF;
782: END cal_da_elt_ofst_val;
783: END IGS_CA_COMPUTE_DA_VAL_PKG;