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.12.12010000.3 2009/01/12 12:26:06 rrajkule 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 1595: err_msg := 'BOMPEXPL[exploders] '||sqlerrm;

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

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

1721: error_code := out_code;
1722: err_msg := out_message;
1723: WHEN parameter_error THEN
1724: error_code := 9997;
1725: err_msg := 'BOMPEXPL: verify parameters';
1726: WHEN no_data_found THEN
1727: error_code := SQLCODE;
1728: err_msg := 'BOMPEXPL: ' || substrb(SQLERRM,1,60);
1729: WHEN OTHERS THEN

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

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

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

1727: error_code := SQLCODE;
1728: err_msg := 'BOMPEXPL: ' || substrb(SQLERRM,1,60);
1729: WHEN OTHERS THEN
1730: error_code := SQLCODE;
1731: err_msg := 'BOMPEXPL (' || stmt_num ||'): ' ||substrb(SQLERRM,1,60);
1732:
1733: END exploder_userexit;
1734:
1735: PROCEDURE explosion_report(

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

2069:
2070: EXCEPTION
2071: WHEN NO_DATA_FOUND THEN
2072: error_code := SQLCODE;
2073: err_msg := 'BOMPEXPL(' || stmt_num || '): ' ||
2074: substrb(SQLERRM, 1, 60);
2075: /* WHEN rollup_error THEN
2076: error_code := rollup_status;
2077: err_msg := out_message;*/

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

2079: error_code := out_code;
2080: err_msg := out_message;
2081: WHEN parameter_error THEN
2082: error_code := 9997;
2083: err_msg := 'BOMPEXPL: verify parameters';
2084: WHEN OTHERS THEN
2085: error_code := SQLCODE;
2086: err_msg := 'BOMPEXPL(' || stmt_num || '): ' ||
2087: substrb(SQLERRM, 1, 60);

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

2082: error_code := 9997;
2083: err_msg := 'BOMPEXPL: verify parameters';
2084: WHEN OTHERS THEN
2085: error_code := SQLCODE;
2086: err_msg := 'BOMPEXPL(' || stmt_num || '): ' ||
2087: substrb(SQLERRM, 1, 60);
2088: END explosion_report;
2089:
2090: /* new procedure for PDI usage.

Line 2145: END bompexpl;

2141: err_msg ,
2142: error_code ) ;
2143: end;
2144:
2145: END bompexpl;