DBA Data[Home] [Help]

APPS.BOMPEXPL dependencies on BOMPEXPL

Line 1: package body bompexpl as

1: package body bompexpl as
2: /* $Header: BOMEXPLB.pls 120.16.12020000.4 2013/01/21 12:59:49 rambkond ship $ */
3:
4: /*==========================================================================+
5: | Copyright (c) 1993 Oracle Corporation Belmont, California, USA |

Line 9: | File Name : BOMPEXPL.sql |

5: | Copyright (c) 1993 Oracle Corporation Belmont, California, USA |
6: | All rights reserved. |
7: +===========================================================================+
8: | |
9: | File Name : BOMPEXPL.sql |
10: | DESCRIPTION : This file is a packaged procedure for the exploders.
11: | This package contains 3 different exploders for the
12: | modules it can be called from. The procedure exploders
13: | calls the correct exploder based on the module option.

Line 1183: p_pkg_name => 'BOMPEXPL',

1179:
1180: EXCEPTION WHEN OTHERS THEN
1181: error_code := SQLCODE;
1182: Fnd_Msg_Pub.Build_Exc_Msg(
1183: p_pkg_name => 'BOMPEXPL',
1184: p_procedure_name => 'BOM_EXPLODER',
1185: p_error_text => SQLERRM);
1186: err_msg := Fnd_Message.Get_Encoded;
1187: ROLLBACK;

Line 1596: err_msg := 'BOMPEXPL[exploders] '||sqlerrm;

1592: error_code := l_error_code;
1593: err_msg := l_err_msg;
1594: WHEN OTHERS THEN
1595: error_code := sqlcode;
1596: err_msg := 'BOMPEXPL[exploders] '||sqlerrm;
1597: END exploders;
1598:
1599: procedure exploder_userexit (
1600: verify_flag IN NUMBER DEFAULT 0,

Line 1729: err_msg := 'BOMPEXPL: verify parameters';

1725: error_code := out_code;
1726: err_msg := out_message;
1727: WHEN parameter_error THEN
1728: error_code := 9997;
1729: err_msg := 'BOMPEXPL: verify parameters';
1730: WHEN no_data_found THEN
1731: error_code := SQLCODE;
1732: err_msg := 'BOMPEXPL: ' || substrb(SQLERRM,1,60);
1733: WHEN OTHERS THEN

Line 1732: err_msg := 'BOMPEXPL: ' || substrb(SQLERRM,1,60);

1728: error_code := 9997;
1729: err_msg := 'BOMPEXPL: verify parameters';
1730: WHEN no_data_found THEN
1731: error_code := SQLCODE;
1732: err_msg := 'BOMPEXPL: ' || substrb(SQLERRM,1,60);
1733: WHEN OTHERS THEN
1734: error_code := SQLCODE;
1735: err_msg := 'BOMPEXPL (' || stmt_num ||'): ' ||substrb(SQLERRM,1,60);
1736:

Line 1735: err_msg := 'BOMPEXPL (' || stmt_num ||'): ' ||substrb(SQLERRM,1,60);

1731: error_code := SQLCODE;
1732: err_msg := 'BOMPEXPL: ' || substrb(SQLERRM,1,60);
1733: WHEN OTHERS THEN
1734: error_code := SQLCODE;
1735: err_msg := 'BOMPEXPL (' || stmt_num ||'): ' ||substrb(SQLERRM,1,60);
1736:
1737: END exploder_userexit;
1738:
1739: PROCEDURE explosion_report(

Line 2098: err_msg := 'BOMPEXPL(' || stmt_num || '): ' ||

2094:
2095: EXCEPTION
2096: WHEN NO_DATA_FOUND THEN
2097: error_code := SQLCODE;
2098: err_msg := 'BOMPEXPL(' || stmt_num || '): ' ||
2099: substrb(SQLERRM, 1, 60);
2100: /* WHEN rollup_error THEN
2101: error_code := rollup_status;
2102: err_msg := out_message;*/

Line 2112: err_msg := 'BOMPEXPL: verify parameters';

2108: */
2109: err_msg := substrb(out_message, 1, 75);
2110: WHEN parameter_error THEN
2111: error_code := 9997;
2112: err_msg := 'BOMPEXPL: verify parameters';
2113: WHEN OTHERS THEN
2114: error_code := SQLCODE;
2115: err_msg := 'BOMPEXPL(' || stmt_num || '): ' ||
2116: substrb(SQLERRM, 1, 60);

Line 2115: err_msg := 'BOMPEXPL(' || stmt_num || '): ' ||

2111: error_code := 9997;
2112: err_msg := 'BOMPEXPL: verify parameters';
2113: WHEN OTHERS THEN
2114: error_code := SQLCODE;
2115: err_msg := 'BOMPEXPL(' || stmt_num || '): ' ||
2116: substrb(SQLERRM, 1, 60);
2117: END explosion_report;
2118:
2119: /* new procedure for PDI usage.

Line 2174: END bompexpl;

2170: err_msg ,
2171: error_code ) ;
2172: end;
2173:
2174: END bompexpl;