APPS.OPI_DBI_REP_UOM_STD_CONV_PKG dependencies on STANDARD

Line 32: -- Use inventory item Id of 0 for standard rates in the staging table.

28:
29: -- Measure lookup type for FND_LOOKUPS
30: C_MEASURE_LOOKUP_TYPE CONSTANT VARCHAR2(40) := 'OPI_DBI_UOM_MEASURE_TYPE';
31:
32: -- Use inventory item Id of 0 for standard rates in the staging table.
33: C_STD_RATE_ITEM_ID CONSTANT NUMBER := 0;
34:
35: -- Conversion rate types. 1 for Intra-class, 2 for Inter-class. Currently
36: -- only using intra-class.

Line 54: 'The Reporting UOMs standard conversion rate fact table update program''s initial load has terminated with errors. Please refer to the concurrent log file and/or concurrent request output file for details.';

50: /****************************************
51: * Error Messages
52: ****************************************/
53: C_INIT_LOAD_ERROR_MESG CONSTANT VARCHAR2 (300) :=
54: 'The Reporting UOMs standard conversion rate fact table update program''s initial load has terminated with errors. Please refer to the concurrent log file and/or concurrent request output file for details.';
55:
56: C_INCR_LOAD_ERROR_MESG CONSTANT VARCHAR2 (300) :=
57: 'The Reporting UOMs standard conversion rate fact table update program''s incremental load has terminated with errors. Please refer to the concurrent log file and/or concurrent request output file for details.';
58:

Line 57: 'The Reporting UOMs standard conversion rate fact table update program''s incremental load has terminated with errors. Please refer to the concurrent log file and/or concurrent request output file for details.';

53: C_INIT_LOAD_ERROR_MESG CONSTANT VARCHAR2 (300) :=
54: 'The Reporting UOMs standard conversion rate fact table update program''s initial load has terminated with errors. Please refer to the concurrent log file and/or concurrent request output file for details.';
55:
56: C_INCR_LOAD_ERROR_MESG CONSTANT VARCHAR2 (300) :=
57: 'The Reporting UOMs standard conversion rate fact table update program''s incremental load has terminated with errors. Please refer to the concurrent log file and/or concurrent request output file for details.';
58:
59: /**************************************************
60: * Package Level User Defined Exceptions for functions
61: **************************************************/

Line 100: INTRA_STD_CONV_FAILED_MESG CONSTANT VARCHAR2(200) := 'Unable to compute all intra-class standard conversion rates to the reporting units of measure.';

96: -- Exception to raise if computing all intra class conversion rates
97: -- fails.
98: INTRA_STD_CONV_FAILED EXCEPTION;
99: PRAGMA EXCEPTION_INIT (INTRA_STD_CONV_FAILED, -20007);
100: INTRA_STD_CONV_FAILED_MESG CONSTANT VARCHAR2(200) := 'Unable to compute all intra-class standard conversion rates to the reporting units of measure.';
101:
102: -- Exception to raise if computing all inter class conversion rates
103: -- fails.
104: INTER_STD_CONV_FAILED EXCEPTION;

Line 106: INTER_STD_CONV_FAILED_MESG CONSTANT VARCHAR2(200) := 'Unable to compute all inter-class standard conversion rates to the reporting units of measure.';

102: -- Exception to raise if computing all inter class conversion rates
103: -- fails.
104: INTER_STD_CONV_FAILED EXCEPTION;
105: PRAGMA EXCEPTION_INIT (INTER_STD_CONV_FAILED, -20008);
106: INTER_STD_CONV_FAILED_MESG CONSTANT VARCHAR2(200) := 'Unable to compute all inter-class standard conversion rates to the reporting units of measure.';
107:
108: -- Exception to raise if unable to insert conversion rates into the
109: -- fact table during the initial load.
110: INSERT_NEW_RATES_FAILED EXCEPTION;

Line 133: Wrapper routine for the initial load of the standard conversion

129:
130:
131: /* populate_rep_uom_std_conv_init
132:
133: Wrapper routine for the initial load of the standard conversion
134: rates program.
135:
136: Parameters:
137: errbuf - error message on unsuccessful termination

Line 149: Wrapper routine for the incremental load of the standard conversion

145: retcode OUT NOCOPY NUMBER);
146:
147: /* populate_rep_uom_std_conv_incr
148:
149: Wrapper routine for the incremental load of the standard conversion
150: rates program.
151:
152: Parameters:
153: errbuf - error message on unsuccessful termination