DBA Data[Home] [Help]

PACKAGE: APPS.PO_MESSAGE_S

Source


1 PACKAGE PO_MESSAGE_S AUTHID CURRENT_USER AS
2 -- $Header: PO_MESSAGE_S.pls 120.25.12020000.3 2013/04/18 13:47:20 swvyamas ship $
3 
4 ------------------------------------------------------------------
5 ------------------------------------------------------------------
6 -- Seeded PO Message Name constants, in alphabetical order.
7 ------------------------------------------------------------------
8 ------------------------------------------------------------------
9 PJM_UEFF_UNIT_NUMBER_REQUIRED CONSTANT VARCHAR2(30) := 'UEFF-UNIT NUMBER REQUIRED';
10 PO_ADVANCE_GT_LINE_AMOUNT CONSTANT VARCHAR2(30) := 'PO_ADVANCE_GT_LINE_AMOUNT'; -- Bug 5070210
11 PO_ALL_CNL_PARAM_NULL CONSTANT VARCHAR2(30) := 'PO_ALL_CNL_PARAM_NULL';
12 PO_ALL_DATE_BETWEEN_START_END CONSTANT VARCHAR2(30) := 'PO_ALL_DATE_BETWEEN_START_END';
13 PO_ALL_ENTER_NUMERIC CONSTANT VARCHAR2(30) := 'PO_ALL_ENTER_NUMERIC';
14 PO_ALL_ENTER_PERCENT CONSTANT VARCHAR2(30) := 'PO_ALL_ENTER_PERCENT';
15 PO_ALL_ENTER_UNIQUE_VAL CONSTANT VARCHAR2(30) := 'PO_ALL_ENTER_UNIQUE_VAL';
16 PO_ALL_ENTER_VALUE_GE_ZERO CONSTANT VARCHAR2(30) := 'PO_ALL_ENTER_VALUE_GE_ZERO';
17 PO_ALL_ENTER_VALUE_GT_ZERO CONSTANT VARCHAR2(30) := 'PO_ALL_ENTER_VALUE_GT_ZERO';
18 PO_ALL_NOT_NULL CONSTANT VARCHAR2(30) := 'PO_ALL_NOT_NULL';
19 PO_ALL_SQL_ERROR CONSTANT VARCHAR2(30) := 'PO_ALL_SQL_ERROR';
20 PO_AMT_GRT_AGD_AMT CONSTANT VARCHAR2(30) := 'PO_AMT_GRT_AGD_AMT';
21 PO_AMT_LMT_NOT_NULL CONSTANT VARCHAR2(30) := 'PO_AMT_LMT_NOT_NULL';
22 PO_AMT_TO_ENCUM_LT_UNENCUM CONSTANT VARCHAR2(30) := 'PO_AMT_TO_ENCUM_LT_UNENCUM';
23 PO_CHNG_OTL_INVALID_AMOUNT CONSTANT VARCHAR2(30) := 'PO_CHNG_OTL_INVALID_AMOUNT';
24 PO_CHNG_OTL_INVALID_END_DATE CONSTANT VARCHAR2(30) := 'PO_CHNG_OTL_INVALID_END_DATE';
25 PO_CHNG_OTL_INVALID_START_DATE CONSTANT VARCHAR2(30) := 'PO_CHNG_OTL_INVALID_START_DATE';
26 PO_CHNG_OTL_NO_PRICE_CHANGE CONSTANT VARCHAR2(30) := 'PO_CHNG_OTL_NO_PRICE_CHANGE';
27 PO_CONS_SHIP_TO_ORG_DIFF_SOB CONSTANT VARCHAR2(30) := 'PO_CONS_SHIP_TO_ORG_DIFF_SOB';
28 PO_CONTRACT_ST_GT_REF_CR CONSTANT VARCHAR2(30) := 'PO_CONTRACT_ST_GT_REF_CR';
29 PO_CONTRACT_ST_LT_REF_CR CONSTANT VARCHAR2(30) := 'PO_CONTRACT_ST_LT_REF_CR';
30 PO_CPO_NO_RATE_FOR_DATE CONSTANT VARCHAR2(30) := 'PO_CPO_NO_RATE_FOR_DATE';
31 --PBWC Message Change Impact: Removing the next 4 messages.
32 --PO_DIS_AMT_NL_BIL CONSTANT VARCHAR2(30) := 'PO_DIS_AMT_NL_BIL';
33 --PO_DIS_AMT_NL_DEL CONSTANT VARCHAR2(30) := 'PO_DIS_AMT_NL_DEL';
34 --PO_DIS_QUA_NL_BIL CONSTANT VARCHAR2(30) := 'PO_DIS_QUA_NL_BIL';
35 --PO_DIS_QUA_NL_DEL CONSTANT VARCHAR2(30) := 'PO_DIS_QUA_NL_DEL';
36 PO_HTML_NO_RATE_DEFINED CONSTANT VARCHAR2(30) := 'PO_HTML_NO_RATE_DEFINED';
37 PO_INVALID_INVOICE_MATCH_FPS CONSTANT VARCHAR2(30) := 'PO_INVALID_INVOICE_MATCH_FPS';
38 PO_PAR_COMMENTS_NOT_NULL  CONSTANT VARCHAR2(30) := 'PO_PAR_COMMENTS_NOT_NULL';    --Bug 16505653
39 PO_PDOI_INV_CLOSE_TOLERANCE CONSTANT VARCHAR2(30) := 'PO_PDOI_INV_CLOSE_TOLERANCE';
40 PO_PDOI_INVALID_SHIP_TO_LOC_ID CONSTANT VARCHAR2(30) := 'PO_PDOI_INVALID_SHIP_TO_LOC_ID';
41 PO_PDOI_INVALID_SHIP_TO_ORG_ID CONSTANT VARCHAR2(30) := 'PO_PDOI_INVALID_SHIP_TO_ORG_ID';
42 PO_PDOI_ITEM_NOT_NULL CONSTANT VARCHAR2(30) := 'PO_PDOI_ITEM_NOT_NULL';
43 PO_PO_AMT_LIMIT_CK_FAILED CONSTANT VARCHAR2(30) := 'PO_PO_AMT_LIMIT_CK_FAILED';
44 PO_PO_AMT_ORD_LT_AMT_BILLED_NA CONSTANT VARCHAR2(30) := 'PO_PO_AMT_ORD_LT_AMT_BILLED_NA';
45 PO_PO_AMT_ORD_LT_AMT_RCVD_NA CONSTANT VARCHAR2(30) := 'PO_PO_AMT_ORD_LT_AMT_RCVD_NA';
46 PO_PO_ENTER_UNIQUE_DIST_NUM CONSTANT VARCHAR2(30) := 'PO_PO_ENTER_UNIQUE_DIST_NUM';
47 PO_PO_ENTER_UNIQUE_LINE_NUM CONSTANT VARCHAR2(30) := 'PO_PO_ENTER_UNIQUE_LINE_NUM';
48 PO_PO_ENTER_UNIQUE_SHIP_NUM CONSTANT VARCHAR2(30) := 'PO_PO_ENTER_UNIQUE_SHIP_NUM';
49 PO_PO_ENTER_UNIQUE_PRC_BRK_NUM CONSTANT VARCHAR2(30) := 'PO_PO_ENTER_UNIQUE_PRC_BRK_NUM'; --<BUG#4586236>
50 PO_PO_NFC_PRICE_CHANGE CONSTANT VARCHAR2(30) := 'PO_PO_NFC_PRICE_CHANGE';
51 PO_PO_NFC_QTY_CHANGE CONSTANT VARCHAR2(30) := 'PO_PO_NFC_QTY_CHANGE';
52 PO_PO_PLANNED_ITEM_DATE_REQ CONSTANT VARCHAR2(30) := 'PO_PO_PLANNED_ITEM_DATE_REQ';
53 PO_PO_QTY_ORD_LT_QTY_BILL_NA CONSTANT VARCHAR2(30) := 'PO_PO_QTY_ORD_LT_QTY_BILL_NA';
54 PO_PO_QTY_ORD_LT_QTY_BILLED_NA CONSTANT VARCHAR2(30) := 'PO_PO_QTY_ORD_LT_QTY_BILLED_NA';
55 PO_PO_QTY_ORD_LT_QTY_ENC_NA CONSTANT VARCHAR2(30) := 'PO_PO_QTY_ORD_LT_QTY_ENC_NA';
56 PO_PO_QTY_ORD_LT_QTY_RCVD_NA CONSTANT VARCHAR2(30) := 'PO_PO_QTY_ORD_LT_QTY_RCVD_NA';
57 PO_PO_QTY_ORD_LT_QTY_RCVD_NA2 CONSTANT VARCHAR2(30) := 'PO_PO_QTY_ORD_LT_QTY_RCVD_NA2';
58 PO_PO_VENDOR_ON_HOLD CONSTANT VARCHAR2(30) := 'PO_PO_VENDOR_ON_HOLD';
59 PO_RCV_TRANSACTION_PENDING CONSTANT VARCHAR2(30) := 'PO_RCV_TRANSACTION_PENDING';
60 PO_RETRO_PRICING_NOT_ALLOWED CONSTANT VARCHAR2(30) := 'PO_RETRO_PRICING_NOT_ALLOWED';
61 --PBWC Message Change Impact: Removing the next 2 messages.
62 --PO_SHIP_AMT_ORD_LT_AMT_BILL_NA CONSTANT VARCHAR2(30) := 'PO_SHIP_AMT_ORD_LT_AMT_BILL_NA';
63 --PO_SHIP_AMT_ORD_LT_AMT_RCVD_NA CONSTANT VARCHAR2(30) := 'PO_SHIP_AMT_ORD_LT_AMT_RCVD_NA';
64 PO_SVC_ASSIGNMENT_DATES CONSTANT VARCHAR2(30) := 'PO_SVC_ASSIGNMENT_DATES';
65 PO_SVC_MAX_LT_MIN_MULTIPLIER CONSTANT VARCHAR2(30) := 'PO_SVC_MAX_LT_MIN_MULTIPLIER';
66 PO_SVC_MULTIPLIER_BTWN_MIN_MAX CONSTANT VARCHAR2(30) := 'PO_SVC_MULTIPLIER_BTWN_MIN_MAX';
67 PO_SVC_MULTIPLIER_GT_MIN CONSTANT VARCHAR2(30) := 'PO_SVC_MULTIPLIER_GT_MIN';
68 PO_SVC_NON_UNIQUE_PRC_DIFF_NUM CONSTANT VARCHAR2(30) := 'PO_SVC_NON_UNIQUE_PRC_DIFF_NUM';
69 PO_SVC_NON_UNIQUE_PRICE_TYPE CONSTANT VARCHAR2(30) := 'PO_SVC_NON_UNIQUE_PRICE_TYPE';
70 PO_SVC_PRC_TYPE_NOT_ON_SRC_DOC CONSTANT VARCHAR2(30) := 'PO_SVC_PRC_TYPE_NOT_ON_SRC_DOC';
71 PO_VMI_ASL_EXIST CONSTANT VARCHAR2(30) := 'PO_VMI_ASL_EXIST';
72 POX_EFFECTIVE_DATES CONSTANT VARCHAR2(30) := 'POX_EFFECTIVE_DATES';
73 POX_EFFECTIVE_DATES1 CONSTANT VARCHAR2(30) := 'POX_EFFECTIVE_DATES1';
74 POX_EFFECTIVE_DATES2 CONSTANT VARCHAR2(30) := 'POX_EFFECTIVE_DATES2';
75 POX_EFFECTIVE_DATES3 CONSTANT VARCHAR2(30) := 'POX_EFFECTIVE_DATES3';
76 POX_EFFECTIVE_DATES4 CONSTANT VARCHAR2(30) := 'POX_EFFECTIVE_DATES4';
77 POX_EFFECTIVE_DATES5 CONSTANT VARCHAR2(30) := 'POX_EFFECTIVE_DATES5';
78 POX_EFFECTIVE_DATES6 CONSTANT VARCHAR2(30) := 'POX_EFFECTIVE_DATES6';
79 POX_EXPIRATION_DATES CONSTANT VARCHAR2(30) := 'POX_EXPIRATION_DATES';
80 POX_PRICEBREAK_ITEM_FAILED CONSTANT VARCHAR2(30) := 'POX_PRICEBREAK_ITEM_FAILED';
81 RCV_ALL_OPEN_PO_PERIOD CONSTANT VARCHAR2(30) := 'RCV_ALL_OPEN_PO_PERIOD';
82 PO_OOP_ENTER_ALL_FIELDS CONSTANT VARCHAR2(30) := 'PO_OOP_ENTER_ALL_FIELDS';
83 PO_PO_ENTER_OPEN_GL_DATE CONSTANT VARCHAR2(30) := 'PO_PO_ENTER_OPEN_GL_DATE';
84 --PBWC Message Change Impact: Adding the following messages.
85 PO_PO_QTY_ORD_LT_QTY_DEL_NA CONSTANT VARCHAR2(30) := 'PO_PO_QTY_ORD_LT_QTY_DEL_NA';
86 PO_PO_AMT_ORD_LT_AMT_DEL_NA CONSTANT VARCHAR2(30) := 'PO_PO_AMT_ORD_LT_AMT_DEL_NA';
87 RCV_ALL_OPEN_PO_PERIOD_HTML CONSTANT VARCHAR2(30) := 'RCV_ALL_OPEN_PO_PERIOD_HTML';
88 PO_WRAPPER_MESSAGE CONSTANT VARCHAR2(30) := 'PO_WRAPPER_MESSAGE';
89 PO_MAX_RET_AMT_GE_RETAINED  CONSTANT VARCHAR2(30) := 'PO_MAX_RET_AMT_GE_RETAINED';  --Bug 5453079
90 
91 --Mod Project
92 PO_MOD_EFFECT_DT_INVALID CONSTANT VARCHAR2(30) := 'PO_MOD_EFFECT_DT_INVALID';
93 PO_MOD_EFFECT_DT_NOTNULL CONSTANT VARCHAR2(30) := 'PO_MOD_EFFECT_DT_NOTNULL';
94 PO_MOD_CANCEL_INVALID CONSTANT VARCHAR2(30) := 'PO_MOD_CANCEL_INVALID';
95 
96 -- CLM Partial Funding Changes
97 PO_PDOI_INVALID_FUND_VAL CONSTANT VARCHAR2(30) := 'PO_PDOI_INVALID_FUND_VAL';
98 PO_PDOI_INVALID_FUND_VAL_ENC CONSTANT VARCHAR2(30) := 'PO_PDOI_INVALID_FUND_VAL_ENC';
99 PO_PF_QTY_FUND_LT_QTY_DEL_NA CONSTANT VARCHAR2(30) := 'PO_PF_QTY_FUND_LT_QTY_DEL_NA';
100 PO_PF_QTY_FUND_LT_QTY_BIL_NA CONSTANT VARCHAR2(30) := 'PO_PF_QTY_FUND_LT_QTY_BIL_NA';
101 PO_PF_AMT_FUND_LT_AMT_DEL_NA CONSTANT VARCHAR2(30) := 'PO_PF_AMT_FUND_LT_AMT_DEL_NA';
102 PO_PF_AMT_FUND_LT_AMT_BIL_NA CONSTANT VARCHAR2(30) := 'PO_PF_AMT_FUND_LT_AMT_BIL_NA';
103 PO_PF_FUND_VAL_GT_BACK_REQ CONSTANT VARCHAR2(30) := 'PO_PF_FUND_VAL_GT_BACK_REQ';
104 
105 PO_FUNDED_VAL_GT_REQ_FUNDS_RMN CONSTANT VARCHAR2(30) := 'PO_FUNDED_VAL_GT_REQ_FUNDS_RMN'; -- CLM-LnSc
106 
107 -- For CLM Fed Fields
108 PO_IDV_EFF_DT_LT_ORD_ST_DT_CLM CONSTANT VARCHAR2(30) := 'PO_IDV_EFF_DT_LT_ORD_ST_DT_CLM';
109 PO_IDV_ORD_ST_DT_LT_END_DT_CLM CONSTANT VARCHAR2(30) := 'PO_IDV_ORD_ST_DT_LT_END_DT_CLM';
110 PO_IDV_MX_OD_AMT_GT_MN_OD_CLM CONSTANT VARCHAR2(30) := 'PO_IDV_MX_OD_AMT_GT_MN_OD_CLM';
111 PO_IDV_MX_CL_AMT_GT_RLSD_CLM CONSTANT VARCHAR2(30) := 'PO_IDV_MX_CL_AMT_GT_RLSD_CLM';
112 PO_IDV_OD_TL_AMT_GT_MN_OD_CLM CONSTANT VARCHAR2(30) := 'PO_IDV_OD_TL_AMT_GT_MN_OD_CLM';
113 PO_IDV_MX_OD_AMT_LT_SM_IDV_CLM CONSTANT VARCHAR2(30) := 'PO_IDV_MX_OD_AMT_LT_SM_IDV_CLM';
114 PO_IDV_OD_TL_AMT_LT_MX_OD_CLM CONSTANT VARCHAR2(30) := 'PO_IDV_OD_TL_AMT_LT_MX_OD_CLM';
115 PO_IDV_MX_CL_AMT_GT_MXPM_CLM CONSTANT VARCHAR2(30) := 'PO_IDV_MX_CL_AMT_GT_MXPM_CLM';
116 PO_IDV_MX_CL_AMT_GT_MNPM_CLM CONSTANT VARCHAR2(30) := 'PO_IDV_MX_CL_AMT_GT_MNPM_CLM';
117 
118 PO_IDV_LINE_ORDER_DATES CONSTANT VARCHAR2(30) := 'PO_IDV_LINE_ORDER_DATES';
119 PO_IDV_ORD_ST_DT_GT_SYS CONSTANT VARCHAR2(30) := 'PO_IDV_ORD_ST_DT_GT_SYS';
120 PO_IDV_AMT_LIMIT_CK_FAILED CONSTANT VARCHAR2(30) :=  'PO_IDV_AMT_LIMIT_CK_FAILED'; --Bug 12660599
121 PO_IDV_MAX_TOT_AMT_LE_LIN_TAMT CONSTANT VARCHAR2(30) := 'PO_IDV_MAX_TOT_AMT_LE_LIN_TAMT';
122 PO_IDV_MAX_TOT_AMT_GE_MIN_TAMT CONSTANT VARCHAR2(30) := 'PO_IDV_MAX_TOT_AMT_GE_MIN_TAMT';
123 PO_IDV_MAX_ORD_AMT_LE_MAX_TAMT CONSTANT VARCHAR2(30) := 'PO_IDV_MAX_ORD_AMT_LE_MAX_TAMT';
124 PO_IDV_MAX_ORD_AMT_GE_MIN_OAMT CONSTANT VARCHAR2(30) := 'PO_IDV_MAX_ORD_AMT_GE_MIN_OAMT';
125 PO_IDV_MAX_TOT_QTY_LE_LIN_TQTY CONSTANT VARCHAR2(30) := 'PO_IDV_MAX_TOT_QTY_LE_LIN_TQTY';
126 PO_IDV_MAX_TOT_QTY_GE_MIN_TQTY CONSTANT VARCHAR2(30) := 'PO_IDV_MAX_TOT_QTY_GE_MIN_TQTY';
127 PO_IDV_MAX_ORD_QTY_LE_MAX_TQTY CONSTANT VARCHAR2(30) := 'PO_IDV_MAX_ORD_QTY_LE_MAX_TQTY';
128 PO_IDV_MAX_ORD_QTY_GE_MIN_OQTY CONSTANT VARCHAR2(30) := 'PO_IDV_MAX_ORD_QTY_GE_MIN_OQTY';
129 PO_IDV_ORD_END_DT_NULL CONSTANT VARCHAR2(30) := 'PO_IDV_ORD_END_DT_NULL';
130 
131 PO_IDV_POP_END_DT_NULL CONSTANT VARCHAR2(30) := 'PO_IDV_POP_END_DT_NULL';
132 PO_IDV_LINE_POP_DATES CONSTANT VARCHAR2(30) := 'PO_IDV_LINE_POP_DATES';
133 PO_IDV_POP_DT_NEED_BY_NULL CONSTANT VARCHAR2(30) := 'PO_IDV_POP_DT_NEED_BY_NULL';
134 
135 PO_PRINT_FORM_FORMAT_INVALID CONSTANT VARCHAR2(30) := 'PO_PRINT_FORM_FORMAT_INVALID';
136 
137 -- For CLM multi mod validations
138 PO_MULTIMOD_NO_DOC_SELECTED CONSTANT VARCHAR2(30) := 'PO_MULTIMOD_NO_DOC_SELECTED';
139 PO_MULTIMOD_NO_EXEMPT_REASON CONSTANT VARCHAR2(30) := 'PO_MULTIMOD_NO_EXEMPT_REASON';
140 PO_MULTIMOD_NO_VENDOR_CONTACT CONSTANT VARCHAR2(30) := 'PO_MULTIMOD_NO_VENDOR_CONTACT';
141 PO_SUB_ENTER_VENDOR_CONTACT CONSTANT VARCHAR2(30) := 'PO_SUB_ENTER_VENDOR_CONTACT';
142 PO_MULTIMOD_NO_CHANGE_DONE CONSTANT VARCHAR2(30) := 'PO_MULTIMOD_NO_CHANGE_DONE';
143 PO_MULTIMOD_NO_VENDOR_SITE CONSTANT VARCHAR2(30) := 'PO_MULTIMOD_NO_VENDOR_SITE';
144 PO_MULTIMOD_NO_VENDOR_CCR CONSTANT VARCHAR2(50) := 'PO_MULTIMOD_VNDR_SITE_CCR_INV';
145 PO_MULTIMOD_CLAUSE_INVALID CONSTANT VARCHAR2(50) := 'PO_MULTIMOD_CLAUSE_CHG_INV';
146 PO_MULTIMOD_INVALID_ACK_BY CONSTANT VARCHAR2(50) := 'PO_MULTIMOD_INVALID_ACK_BY';
147 PO_MULTIMOD_NOOFCOPIES_GE_ZERO CONSTANT VARCHAR2(50) := 'PO_MULTIMOD_NOOFCOPIES_GE_ZERO';
148 PO_MULTIMOD_INV_VNDRNAME_CHG CONSTANT VARCHAR2(50) := 'PO_MULTIMOD_INV_VNDRNAME_CHG';
149 PO_MULTIMOD_INV_VNDR_CHG CONSTANT VARCHAR2(50) := 'PO_MULTIMOD_INV_VNDR_CHG';
150 PO_SUB_VENDOR_ON_HOLD CONSTANT VARCHAR2(50) := 'PO_SUB_VENDOR_ON_HOLD';
151 PO_MULTIMOD_AWARD_NOT_INC CONSTANT VARCHAR2(50) := 'PO_MULTIMOD_AWARD_NOT_INC';
152 PO_MULTIMOD_AWARD_NOT_INC_SUM CONSTANT VARCHAR2(50) := 'PO_MULTIMOD_AWARD_NOT_INC_SUM';
153 PO_MULTIMOD_IDV_NOT_INC CONSTANT VARCHAR2(50) := 'PO_MULTIMOD_IDV_NOT_INC';
154 PO_MULTIMOD_IDV_NOT_INC_SUM CONSTANT VARCHAR2(50) := 'PO_MULTIMOD_IDV_NOT_INC_SUM';
155 PO_SUPCHG_UNPD_RCV CONSTANT VARCHAR2(50) := 'PO_SUPCHG_UNPD_RCV';
156 PO_SUPCHG_UNPD_RCV_SUM CONSTANT VARCHAR2(50) := 'PO_SUPCHG_UNPD_RCV_SUM';
157 PO_SUPCHG_UNVAL_RCV CONSTANT VARCHAR2(50) := 'PO_SUPCHG_UNVAL_RCV';
158 PO_SUPCHG_UNPD_INV CONSTANT VARCHAR2(50) := 'PO_SUPCHG_UNPD_INV';
159 PO_SUPCHG_UNPD_INV_SUM CONSTANT VARCHAR2(50) := 'PO_SUPCHG_UNPD_INV_SUM';
160 PO_SUPCHG_UNVAL_INV CONSTANT VARCHAR2(50) := 'PO_SUPCHG_UNVAL_INV';
161 PO_SUPCHG_UNINV_4WAY  CONSTANT VARCHAR2(50) := 'PO_SUPCHG_UNINV_4WAY';
162 PO_SUPCHG_UNINV_3WAY  CONSTANT VARCHAR2(50) := 'PO_SUPCHG_UNINV_3WAY';
163 PO_SUPCHG_UNINV_2WAY  CONSTANT VARCHAR2(50) := 'PO_SUPCHG_UNINV_2WAY';
164 PO_SUPCHG_UNINV_RCV CONSTANT VARCHAR2(50) := 'PO_SUPCHG_UNINV_RCV';
165 PO_SUPCHG_RCPT_DOCS_NOTINC CONSTANT VARCHAR2(50) := 'PO_SUPCHG_RCPT_DOCS_NOTINC';
166 PO_SUPCHG_SHRD_RCPT CONSTANT VARCHAR2(50) := 'PO_SUPCHG_SHRD_RCPT';
167 PO_SUPCHG_RDAT_GE_NOVDAT CONSTANT VARCHAR2(50) := 'PO_SUPCHG_RDAT_GE_NOVDAT';
168 PO_SUPCHG_RDAT_GE_NOVDAT_SUM CONSTANT VARCHAR2(50) := 'PO_SUPCHG_RDAT_GE_NOVDAT_SUM';
169 PO_SUPCHG_WITH_RCV_TRX CONSTANT VARCHAR2(50) := 'PO_SUPCHG_WITH_RCV_TRX';
170 PO_SUPCHG_WITH_RCV_TRX_SUM CONSTANT VARCHAR2(50) := 'PO_SUPCHG_WITH_RCV_TRX_SUM';
171 PO_SUPCHG_INDAT_GE_NOVDAT CONSTANT VARCHAR2(50) := 'PO_SUPCHG_INDAT_GE_NOVDAT';
172 PO_SUPCHG_INDAT_GE_NOVDAT_SUM CONSTANT VARCHAR2(50) := 'PO_SUPCHG_INDAT_GE_NOVDAT_SUM';
173 PO_SUPCHG_UNMTCH_INV_VNDR CONSTANT VARCHAR2(50) := 'PO_SUPCHG_UNMTCH_INV_VNDR';
174 PO_SUPCHG_UNMTCH_INV_VNDR_SUM CONSTANT VARCHAR2(50) := 'PO_SUPCHG_UNMTCH_INV_VNDR_SUM';
175 PO_SUPCHG_PARTPD_INV_VNDR CONSTANT VARCHAR2(50) := 'PO_SUPCHG_PARTPD_INV_VNDR';
176 PO_SUPCHG_PARTPD_INV_VNDR_SUM CONSTANT VARCHAR2(50) := 'PO_SUPCHG_PARTPD_INV_VNDR_SUM';
177 PO_SUPCHG_PREPD_INV_VNDR CONSTANT VARCHAR2(50) := 'PO_SUPCHG_PREPD_INV_VNDR';
178 PO_SUPCHG_PREPD_INV_VNDR_SUM CONSTANT VARCHAR2(50) := 'PO_SUPCHG_PREPD_INV_VNDR_SUM';
179 
180 ------------------------------------------------------------------
181 ------------------------------------------------------------------
182 -- Token Names used in the messages.
183 ------------------------------------------------------------------
184 ------------------------------------------------------------------
185 c_ERR_NUMBER_token CONSTANT VARCHAR2(30) := 'ERR_NUMBER'; -- PO_ALL_SQL_ERROR
186 c_LSQL_ERR_token CONSTANT VARCHAR2(30) := 'LSQL_ERR'; -- PO_ALL_SQL_ERROR
187 c_QTY_BILLED_token CONSTANT VARCHAR2(30) := 'QTY_BILLED'; -- PO_PO_QTY_ORD_LT_QTY_BILLED_NA
188 c_QTY_ENC_token CONSTANT VARCHAR2(30) := 'QTY_ENC'; -- PO_PO_QTY_ORD_LT_QTY_ENC_NA
189 c_QTY_ORD_token CONSTANT VARCHAR2(30) := 'QTY_ORD'; -- PO_PO_QTY_ORD_LT_QTY_ENC_NA
190 c_QTY_RCVD_token CONSTANT VARCHAR2(30) := 'QTY_RCVD'; -- PO_PO_QTY_ORD_LT_QTY_RCVD_NA
191 c_ROUTINE_token CONSTANT VARCHAR2(30) := 'ROUTINE'; -- PO_ALL_SQL_ERROR
192 c_SQL_ERR_token CONSTANT VARCHAR2(30) := 'SQL_ERR'; -- PO_ALL_SQL_ERROR
193 --PBWC Message Change Impact: Removing and Adding the following tokens.
194 --c_VALUE_token CONSTANT VARCHAR2(30) := 'VALUE'; -- PO_PDOI_INV_CLOSE_TOLERANCE
195 c_QTY_DEL_token CONSTANT VARCHAR2(30) := 'QTY_DEL'; -- PO_PO_QTY_ORD_LT_QTY_DEL_NA
196 c_AMT_BILLED_token CONSTANT VARCHAR2(30) := 'AMT_BILLED'; -- PO_PO_AMT_ORD_LT_AMT_BILLED_NA
197 c_AMT_RCVD_token CONSTANT VARCHAR2(30) := 'AMT_RCVD'; -- PO_PO_AMT_ORD_LT_AMT_RCVD_NA
198 c_AMT_DEL_token CONSTANT VARCHAR2(30) := 'AMT_DEL'; -- PO_PO_AMT_ORD_LT_AMT_DEL_NA
199 c_TOTAL_AMT_token CONSTANT VARCHAR2(30) := 'TOTAL_AMT'; -- PO_CHNG_OTL_INVALID_AMOUNT
200 c_LINE_NUM_token CONSTANT VARCHAR2(30) := 'LINE_NUM';
201 c_SCHED_NUM_token CONSTANT VARCHAR2(30) := 'SCHED_NUM';
202 c_MAX_RET_AMT_token CONSTANT VARCHAR2(30) := 'MAX_RET_AMT';    --PO_MAX_RET_AMT_GE_RETAINED
203 c_AMT_RETAINED_token CONSTANT VARCHAR2(30) := 'AMT_RETAINED';  --PO_MAX_RET_AMT_GE_RETAINED
204 
205 ------------------------------------------------------------------
206 ------------------------------------------------------------------
207 -- Link Requisition Distributions validation messages.
208 ------------------------------------------------------------------
209 ------------------------------------------------------------------
210 
211 PO_LINKREQ_UNIQUE_DIST_NUM CONSTANT VARCHAR2(30) := 'PO_LINKREQ_UNIQUE_DIST_NUM';
215 PO_LINKREQ_TOTAL_AMT_MISMATCH CONSTANT VARCHAR2(30) := 'PO_LINKREQ_TOTAL_AMT_MISMATCH';
212 PO_LINKREQ_FUNDED_VAL_MISMATCH CONSTANT VARCHAR2(30) := 'PO_LINKREQ_FUNDED_VAL_MISMATCH';
213 PO_LINKREQ_DIST_AMT_MISMATCH CONSTANT VARCHAR2(30) := 'PO_LINKREQ_DIST_AMT_MISMATCH';
214 PO_LINKREQ_ENTER_VALUE_GT_ZERO CONSTANT VARCHAR2(30) := 'PO_LINKREQ_ENTER_VALUE_GT_ZERO';
216 PO_LINKREQ_TOTAL_QT_MISMATCH CONSTANT VARCHAR2(30) := 'PO_LINKREQ_TOTAL_QT_MISMATCH';
217 PO_LINKREQ_FUNDS_CONSUMED CONSTANT VARCHAR2(30) := 'PO_LINKREQ_FUNDS_CONSUMED';
218 PO_LINKREQ_REQ_AT_SOURCING CONSTANT VARCHAR2(30) := 'PO_LINKREQ_REQ_AT_SOURCING';
219 
220 --UCA Project - CLM R4 Changes Begin.
221 PO_UCA_UNDEF_LE_NTE CONSTANT VARCHAR2(30) := 'PO_UCA_UNDEF_LE_NTE';
222 PO_UCA_LGL_LE_NTE CONSTANT VARCHAR2(30) := 'PO_UCA_LGL_LE_NTE';
223 PO_UCA_PDD_GE_SYSDATE CONSTANT VARCHAR2(30) := 'PO_UCA_PDD_GE_SYSDATE';
224 PO_UCA_UNDEF_LE_LINE_AMT CONSTANT VARCHAR2(30) := 'PO_UCA_UNDEF_LE_LINE_AMT';
225 
226 --UCA Project - CLM R4 Changes End
227 PO_INVALID_EXHIBIT_NAME CONSTANT VARCHAR2(30) := 'PO_INVALID_EXHIBIT_NAME_MSG';
228 
229 c_MESSAGE_token CONSTANT VARCHAR2(30) := 'MESSAGE';
230 ------------------------------------------------------------------
231 ------------------------------------------------------------------
232 -- Public variables
233 ------------------------------------------------------------------
234 ------------------------------------------------------------------
235 
236 g_routine varchar2(240) := NULL;
237 g_location varchar2(240) := NULL;
238 
239 ------------------------------------------------------------------
240 ------------------------------------------------------------------
241 -- Public subprograms
242 ------------------------------------------------------------------
243 ------------------------------------------------------------------
244 
245 PROCEDURE SQL_ERROR(routine IN varchar2 ,
246                     location IN varchar2,
247                     error_code IN number);
248 
249 PROCEDURE SQL_ERROR(
250   p_package  IN varchar2
251 , p_routine  IN varchar2
252 , p_location IN varchar2
253 , p_sqlcode  IN number
254 , p_sqlerrm  IN varchar
255 );
256 
257 PROCEDURE APP_ERROR(error_name IN varchar2);
258 
259 PROCEDURE APP_ERROR(error_name IN varchar2,
260                     token1 IN varchar2,
261                     value1 IN varchar2);
262 
263 PROCEDURE APP_ERROR(error_name IN varchar2,
264                     token1 IN varchar2,
265                     value1 IN varchar2,
266                     token2 IN varchar2,
267                     value2 IN varchar2);
268 
269 PROCEDURE APP_ERROR(error_name IN varchar2,
270                     token1 IN varchar2,
271                     value1 IN varchar2,
272                     token2 IN varchar2,
273                     value2 IN varchar2,
274                     token3 IN varchar2,
275                     value3 IN varchar2);
276 
277 PROCEDURE APP_ERROR(error_name IN varchar2,
278                     token1 IN varchar2,
279                     value1 IN varchar2,
280                     token2 IN varchar2,
281                     value2 IN varchar2,
282                     token3 IN varchar2,
283                     value3 IN varchar2,
284                     token4 IN varchar2,
285                     value4 IN varchar2);
286 
287 PROCEDURE SQL_SHOW_ERROR;
288 
289 PROCEDURE APP_SET_NAME(error_name IN varchar2);
290 
291 PROCEDURE CLEAR;
292 
293 -- Bug 3516763
294 FUNCTION GET_FND_MSG_PUB_LAST RETURN varchar2;
295 
296 PROCEDURE add_exc_msg
297 (   p_pkg_name		IN VARCHAR2,
298     p_procedure_name	IN VARCHAR2,
299     p_error_text	IN VARCHAR2 := NULL
300 );
301 
302 -- <PDOI Rewrite R12 START>
303 PROCEDURE concat_fnd_messages_in_stack
304 ( p_max_size IN NUMBER,
305   x_message_text OUT NOCOPY VARCHAR2
306 );
307 -- <PDOI Rewrite R12 END>
308 
309 END PO_MESSAGE_S;