DBA Data[Home] [Help]

APPS.OKI_DBI_UTIL_PVT dependencies on FND_MESSAGE

Line 42: fnd_message.set_name (application => 'FND'

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 ');
46: bis_collection_utilities.put_line (fnd_message.get);

Line 44: fnd_message.set_token (token => 'ROUTINE'

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 ');
46: bis_collection_utilities.put_line (fnd_message.get);
47: raise_application_error (-20000
48: , 'Stack Dump Follows =>'

Line 46: bis_collection_utilities.put_line (fnd_message.get);

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;

Line 81: fnd_message.set_name (application => 'FND'

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 ');
85: bis_collection_utilities.put_line (fnd_message.get);

Line 83: fnd_message.set_token (token => 'ROUTINE'

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 ');
85: bis_collection_utilities.put_line (fnd_message.get);
86: raise_application_error (-20000
87: , 'Stack Dump Follows =>'

Line 85: bis_collection_utilities.put_line (fnd_message.get);

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;

Line 325: fnd_message.set_name (application => 'FND'

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 ');
329: bis_collection_utilities.put_line (fnd_message.get);

Line 327: fnd_message.set_token (token => 'ROUTINE'

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 ');
329: bis_collection_utilities.put_line (fnd_message.get);
330: raise_application_error (-20000
331: , 'Stack Dump Follows =>'

Line 329: bis_collection_utilities.put_line (fnd_message.get);

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;

Line 370: fnd_message.set_name (application => 'FND'

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 ');
374: bis_collection_utilities.put_line (fnd_message.get);

Line 372: fnd_message.set_token (token => 'ROUTINE'

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 ');
374: bis_collection_utilities.put_line (fnd_message.get);
375: raise_application_error (-20000
376: , 'Stack Dump Follows =>'

Line 374: bis_collection_utilities.put_line (fnd_message.get);

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;

Line 586: fnd_message.set_name (application => 'FND'

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 ');
590: bis_collection_utilities.put_line (fnd_message.get);

Line 588: fnd_message.set_token (token => 'ROUTINE'

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 ');
590: bis_collection_utilities.put_line (fnd_message.get);
591: raise_application_error (-20000
592: , 'Stack Dump Follows =>'

Line 590: bis_collection_utilities.put_line (fnd_message.get);

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;

Line 608: fnd_message.set_name (application => 'FND'

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 ');
612: bis_collection_utilities.put_line (fnd_message.get);

Line 610: fnd_message.set_token (token => 'ROUTINE'

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 ');
612: bis_collection_utilities.put_line (fnd_message.get);
613: raise_application_error (-20000
614: , 'Stack Dump Follows =>'

Line 612: bis_collection_utilities.put_line (fnd_message.get);

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;

Line 819: fnd_message.set_name (application => 'FND'

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 ');
823: bis_collection_utilities.put_line (fnd_message.get);

Line 821: fnd_message.set_token (token => 'ROUTINE'

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 ');
823: bis_collection_utilities.put_line (fnd_message.get);
824: raise_application_error (-20000
825: , 'Stack Dump Follows =>'

Line 823: bis_collection_utilities.put_line (fnd_message.get);

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;

Line 898: fnd_message.set_name (application => 'FND'

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 ');
902: bis_collection_utilities.put_line (fnd_message.get);

Line 900: fnd_message.set_token (token => 'ROUTINE'

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 ');
902: bis_collection_utilities.put_line (fnd_message.get);
903: raise_application_error (-20000
904: , 'Stack Dump Follows =>'

Line 902: bis_collection_utilities.put_line (fnd_message.get);

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;

Line 2139: fnd_message.set_name (application => 'BIS'

2135: l_custom_rec bis_query_attributes;
2136: BEGIN
2137: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
2138: -- Unassigned bind variable
2139: fnd_message.set_name (application => 'BIS'
2140: , NAME => 'EDW_UNASSIGNED');
2141: l_custom_rec.attribute_name := '&UNASSIGNED';
2142: l_custom_rec.attribute_value := fnd_message.get;
2143: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

Line 2142: l_custom_rec.attribute_value := fnd_message.get;

2138: -- Unassigned bind variable
2139: fnd_message.set_name (application => 'BIS'
2140: , NAME => 'EDW_UNASSIGNED');
2141: l_custom_rec.attribute_name := '&UNASSIGNED';
2142: l_custom_rec.attribute_value := fnd_message.get;
2143: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2144: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
2145: x_custom_output.EXTEND;
2146: x_custom_output (x_custom_output.COUNT) := l_custom_rec;

Line 2148: fnd_message.set_name (application => 'BIS'

2144: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
2145: x_custom_output.EXTEND;
2146: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
2147: -- Direct Report bind variable
2148: fnd_message.set_name (application => 'BIS'
2149: , NAME => 'BIS_PMF_DIRECT_REP');
2150: l_custom_rec.attribute_name := '&DIRECT_REPORT';
2151: l_custom_rec.attribute_value := fnd_message.get;
2152: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

Line 2151: l_custom_rec.attribute_value := fnd_message.get;

2147: -- Direct Report bind variable
2148: fnd_message.set_name (application => 'BIS'
2149: , NAME => 'BIS_PMF_DIRECT_REP');
2150: l_custom_rec.attribute_name := '&DIRECT_REPORT';
2151: l_custom_rec.attribute_value := fnd_message.get;
2152: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
2153: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
2154: x_custom_output.EXTEND;
2155: x_custom_output (x_custom_output.COUNT) := l_custom_rec;