37: RETURN l_date;
38: EXCEPTION
39: WHEN OTHERS
40: THEN
41: bis_collection_utilities.put_line (SQLERRM || '' || SQLCODE);
42: fnd_message.set_name (application => 'FND'
43: , NAME => 'CRM-DEBUG ERROR');
44: fnd_message.set_token (token => 'ROUTINE'
45: , VALUE => 'OKI_DBI_UTIL_PVT.current_period_start_date ');
42: fnd_message.set_name (application => 'FND'
43: , NAME => 'CRM-DEBUG ERROR');
44: fnd_message.set_token (token => 'ROUTINE'
45: , VALUE => 'OKI_DBI_UTIL_PVT.current_period_start_date ');
46: bis_collection_utilities.put_line (fnd_message.get);
47: raise_application_error (-20000
48: , 'Stack Dump Follows =>'
49: , TRUE);
50: END current_period_start_date;
76: RETURN l_date;
77: EXCEPTION
78: WHEN OTHERS
79: THEN
80: bis_collection_utilities.put_line (SQLERRM || '' || SQLCODE);
81: fnd_message.set_name (application => 'FND'
82: , NAME => 'CRM-DEBUG ERROR');
83: fnd_message.set_token (token => 'ROUTINE'
84: , VALUE => 'OKI_DBI_UTIL_PVT.current_period_end_date ');
81: fnd_message.set_name (application => 'FND'
82: , NAME => 'CRM-DEBUG ERROR');
83: fnd_message.set_token (token => 'ROUTINE'
84: , VALUE => 'OKI_DBI_UTIL_PVT.current_period_end_date ');
85: bis_collection_utilities.put_line (fnd_message.get);
86: raise_application_error (-20000
87: , 'Stack Dump Follows =>'
88: , TRUE);
89: END current_period_end_date;
255: RETURN l_date;
256: EXCEPTION
257: WHEN OTHERS
258: THEN
259: bis_collection_utilities.put_line ('Error in function previous_report_start_date : ' || SQLERRM || '' || SQLCODE);
260: raise_application_error (-20000
261: , 'Stack Dump Follows =>'
262: , TRUE);
263: END previous_report_start_date;
320: RETURN l_sec_profile;
321: EXCEPTION
322: WHEN OTHERS
323: THEN
324: bis_collection_utilities.put_line (SQLERRM || '' || SQLCODE);
325: fnd_message.set_name (application => 'FND'
326: , NAME => 'CRM-DEBUG ERROR');
327: fnd_message.set_token (token => 'ROUTINE'
328: , VALUE => 'OKI_DBI_UTIL_PVT.get_sec_profile ');
325: fnd_message.set_name (application => 'FND'
326: , NAME => 'CRM-DEBUG ERROR');
327: fnd_message.set_token (token => 'ROUTINE'
328: , VALUE => 'OKI_DBI_UTIL_PVT.get_sec_profile ');
329: bis_collection_utilities.put_line (fnd_message.get);
330: raise_application_error (-20000
331: , 'Stack Dump Follows =>'
332: , TRUE);
333: END get_sec_profile;
365: RETURN l_org_where;
366: EXCEPTION
367: WHEN OTHERS
368: THEN
369: bis_collection_utilities.put_line (SQLERRM || '' || SQLCODE);
370: fnd_message.set_name (application => 'FND'
371: , NAME => 'CRM-DEBUG ERROR');
372: fnd_message.set_token (token => 'ROUTINE'
373: , VALUE => 'OKI_DBI_UTIL_PVT.get_org_where ');
370: fnd_message.set_name (application => 'FND'
371: , NAME => 'CRM-DEBUG ERROR');
372: fnd_message.set_token (token => 'ROUTINE'
373: , VALUE => 'OKI_DBI_UTIL_PVT.get_org_where ');
374: bis_collection_utilities.put_line (fnd_message.get);
375: raise_application_error (-20000
376: , 'Stack Dump Follows =>'
377: , TRUE);
378: END get_org_where;
581: END IF;
582: EXCEPTION
583: WHEN OTHERS
584: THEN
585: bis_collection_utilities.put_line (SQLERRM || '' || SQLCODE);
586: fnd_message.set_name (application => 'FND'
587: , NAME => 'CRM-DEBUG ERROR');
588: fnd_message.set_token (token => 'ROUTINE'
589: , VALUE => 'OKI_DBI_UTIL_PVT.get_dbi_params ');
586: fnd_message.set_name (application => 'FND'
587: , NAME => 'CRM-DEBUG ERROR');
588: fnd_message.set_token (token => 'ROUTINE'
589: , VALUE => 'OKI_DBI_UTIL_PVT.get_dbi_params ');
590: bis_collection_utilities.put_line (fnd_message.get);
591: raise_application_error (-20000
592: , 'Stack Dump Follows =>'
593: , TRUE);
594: END get_dbi_params;
603: RETURN bis_common_parameters.get_currency_code;
604: EXCEPTION
605: WHEN OTHERS
606: THEN
607: bis_collection_utilities.put_line (SQLERRM || '' || SQLCODE);
608: fnd_message.set_name (application => 'FND'
609: , NAME => 'CRM-DEBUG ERROR');
610: fnd_message.set_token (token => 'ROUTINE'
611: , VALUE => 'OKI_DBI_UTIL_PVT.get_global_currency ');
608: fnd_message.set_name (application => 'FND'
609: , NAME => 'CRM-DEBUG ERROR');
610: fnd_message.set_token (token => 'ROUTINE'
611: , VALUE => 'OKI_DBI_UTIL_PVT.get_global_currency ');
612: bis_collection_utilities.put_line (fnd_message.get);
613: raise_application_error (-20000
614: , 'Stack Dump Follows =>'
615: , TRUE);
616: END get_global_currency;
814: END IF;
815: EXCEPTION
816: WHEN OTHERS
817: THEN
818: bis_collection_utilities.put_line (SQLERRM || '' || SQLCODE);
819: fnd_message.set_name (application => 'FND'
820: , NAME => 'CRM-DEBUG ERROR');
821: fnd_message.set_token (token => 'ROUTINE'
822: , VALUE => 'OKI_DBI_UTIL_PVT.get_parameter_values ');
819: fnd_message.set_name (application => 'FND'
820: , NAME => 'CRM-DEBUG ERROR');
821: fnd_message.set_token (token => 'ROUTINE'
822: , VALUE => 'OKI_DBI_UTIL_PVT.get_parameter_values ');
823: bis_collection_utilities.put_line (fnd_message.get);
824: raise_application_error (-20000
825: , 'Stack Dump Follows =>'
826: , TRUE);
827: END get_parameter_values;
893: END LOOP;
894: EXCEPTION
895: WHEN OTHERS
896: THEN
897: bis_collection_utilities.put_line (SQLERRM || '' || SQLCODE);
898: fnd_message.set_name (application => 'FND'
899: , NAME => 'CRM-DEBUG ERROR');
900: fnd_message.set_token (token => 'ROUTINE'
901: , VALUE => 'OKI_DBI_UTIL_PVT.get_drill_across_param_val ');
898: fnd_message.set_name (application => 'FND'
899: , NAME => 'CRM-DEBUG ERROR');
900: fnd_message.set_token (token => 'ROUTINE'
901: , VALUE => 'OKI_DBI_UTIL_PVT.get_drill_across_param_val ');
902: bis_collection_utilities.put_line (fnd_message.get);
903: raise_application_error (-20000
904: , 'Stack Dump Follows =>'
905: , TRUE);
906: END get_drill_across_param_val;