eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.PO_MESSAGE_S

Source


1 PACKAGE PO_MESSAGE_S AS
2 -- $Header: PO_MESSAGE_S.pls 120.14 2006/09/11 12:26:22 scolvenk noship $
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_PDOI_INV_CLOSE_TOLERANCE CONSTANT VARCHAR2(30) := 'PO_PDOI_INV_CLOSE_TOLERANCE';
39 PO_PDOI_INVALID_SHIP_TO_LOC_ID CONSTANT VARCHAR2(30) := 'PO_PDOI_INVALID_SHIP_TO_LOC_ID';
40 PO_PDOI_INVALID_SHIP_TO_ORG_ID CONSTANT VARCHAR2(30) := 'PO_PDOI_INVALID_SHIP_TO_ORG_ID';
41 PO_PDOI_ITEM_NOT_NULL CONSTANT VARCHAR2(30) := 'PO_PDOI_ITEM_NOT_NULL';
42 PO_PO_AMT_LIMIT_CK_FAILED CONSTANT VARCHAR2(30) := 'PO_PO_AMT_LIMIT_CK_FAILED';
43 PO_PO_AMT_ORD_LT_AMT_BILLED_NA CONSTANT VARCHAR2(30) := 'PO_PO_AMT_ORD_LT_AMT_BILLED_NA';
44 PO_PO_AMT_ORD_LT_AMT_RCVD_NA CONSTANT VARCHAR2(30) := 'PO_PO_AMT_ORD_LT_AMT_RCVD_NA';
45 PO_PO_ENTER_UNIQUE_DIST_NUM CONSTANT VARCHAR2(30) := 'PO_PO_ENTER_UNIQUE_DIST_NUM';
46 PO_PO_ENTER_UNIQUE_LINE_NUM CONSTANT VARCHAR2(30) := 'PO_PO_ENTER_UNIQUE_LINE_NUM';
47 PO_PO_ENTER_UNIQUE_SHIP_NUM CONSTANT VARCHAR2(30) := 'PO_PO_ENTER_UNIQUE_SHIP_NUM';
48 PO_PO_ENTER_UNIQUE_PRC_BRK_NUM CONSTANT VARCHAR2(30) := 'PO_PO_ENTER_UNIQUE_PRC_BRK_NUM'; --<BUG#4586236>
49 PO_PO_NFC_PRICE_CHANGE CONSTANT VARCHAR2(30) := 'PO_PO_NFC_PRICE_CHANGE';
50 PO_PO_NFC_QTY_CHANGE CONSTANT VARCHAR2(30) := 'PO_PO_NFC_QTY_CHANGE';
51 PO_PO_PLANNED_ITEM_DATE_REQ CONSTANT VARCHAR2(30) := 'PO_PO_PLANNED_ITEM_DATE_REQ';
52 PO_PO_QTY_ORD_LT_QTY_BILL_NA CONSTANT VARCHAR2(30) := 'PO_PO_QTY_ORD_LT_QTY_BILL_NA';
53 PO_PO_QTY_ORD_LT_QTY_BILLED_NA CONSTANT VARCHAR2(30) := 'PO_PO_QTY_ORD_LT_QTY_BILLED_NA';
54 PO_PO_QTY_ORD_LT_QTY_ENC_NA CONSTANT VARCHAR2(30) := 'PO_PO_QTY_ORD_LT_QTY_ENC_NA';
55 PO_PO_QTY_ORD_LT_QTY_RCVD_NA CONSTANT VARCHAR2(30) := 'PO_PO_QTY_ORD_LT_QTY_RCVD_NA';
56 PO_PO_QTY_ORD_LT_QTY_RCVD_NA2 CONSTANT VARCHAR2(30) := 'PO_PO_QTY_ORD_LT_QTY_RCVD_NA2';
57 PO_PO_VENDOR_ON_HOLD CONSTANT VARCHAR2(30) := 'PO_PO_VENDOR_ON_HOLD';
58 PO_RCV_TRANSACTION_PENDING CONSTANT VARCHAR2(30) := 'PO_RCV_TRANSACTION_PENDING';
59 PO_RETRO_PRICING_NOT_ALLOWED CONSTANT VARCHAR2(30) := 'PO_RETRO_PRICING_NOT_ALLOWED';
60 --PBWC Message Change Impact: Removing the next 2 messages.
61 --PO_SHIP_AMT_ORD_LT_AMT_BILL_NA CONSTANT VARCHAR2(30) := 'PO_SHIP_AMT_ORD_LT_AMT_BILL_NA';
62 --PO_SHIP_AMT_ORD_LT_AMT_RCVD_NA CONSTANT VARCHAR2(30) := 'PO_SHIP_AMT_ORD_LT_AMT_RCVD_NA';
63 PO_SVC_ASSIGNMENT_DATES CONSTANT VARCHAR2(30) := 'PO_SVC_ASSIGNMENT_DATES';
64 PO_SVC_MAX_LT_MIN_MULTIPLIER CONSTANT VARCHAR2(30) := 'PO_SVC_MAX_LT_MIN_MULTIPLIER';
65 PO_SVC_MULTIPLIER_BTWN_MIN_MAX CONSTANT VARCHAR2(30) := 'PO_SVC_MULTIPLIER_BTWN_MIN_MAX';
66 PO_SVC_MULTIPLIER_GT_MIN CONSTANT VARCHAR2(30) := 'PO_SVC_MULTIPLIER_GT_MIN';
67 PO_SVC_NON_UNIQUE_PRC_DIFF_NUM CONSTANT VARCHAR2(30) := 'PO_SVC_NON_UNIQUE_PRC_DIFF_NUM';
68 PO_SVC_NON_UNIQUE_PRICE_TYPE CONSTANT VARCHAR2(30) := 'PO_SVC_NON_UNIQUE_PRICE_TYPE';
69 PO_SVC_PRC_TYPE_NOT_ON_SRC_DOC CONSTANT VARCHAR2(30) := 'PO_SVC_PRC_TYPE_NOT_ON_SRC_DOC';
70 PO_VMI_ASL_EXIST CONSTANT VARCHAR2(30) := 'PO_VMI_ASL_EXIST';
71 POX_EFFECTIVE_DATES CONSTANT VARCHAR2(30) := 'POX_EFFECTIVE_DATES';
72 POX_EFFECTIVE_DATES1 CONSTANT VARCHAR2(30) := 'POX_EFFECTIVE_DATES1';
73 POX_EFFECTIVE_DATES2 CONSTANT VARCHAR2(30) := 'POX_EFFECTIVE_DATES2';
74 POX_EFFECTIVE_DATES3 CONSTANT VARCHAR2(30) := 'POX_EFFECTIVE_DATES3';
75 POX_EFFECTIVE_DATES4 CONSTANT VARCHAR2(30) := 'POX_EFFECTIVE_DATES4';
76 POX_EFFECTIVE_DATES5 CONSTANT VARCHAR2(30) := 'POX_EFFECTIVE_DATES5';
77 POX_EFFECTIVE_DATES6 CONSTANT VARCHAR2(30) := 'POX_EFFECTIVE_DATES6';
78 POX_EXPIRATION_DATES CONSTANT VARCHAR2(30) := 'POX_EXPIRATION_DATES';
79 POX_PRICEBREAK_ITEM_FAILED CONSTANT VARCHAR2(30) := 'POX_PRICEBREAK_ITEM_FAILED';
80 RCV_ALL_OPEN_PO_PERIOD CONSTANT VARCHAR2(30) := 'RCV_ALL_OPEN_PO_PERIOD';
81 PO_OOP_ENTER_ALL_FIELDS CONSTANT VARCHAR2(30) := 'PO_OOP_ENTER_ALL_FIELDS';
82 PO_PO_ENTER_OPEN_GL_DATE CONSTANT VARCHAR2(30) := 'PO_PO_ENTER_OPEN_GL_DATE';
83 --PBWC Message Change Impact: Adding the following messages.
84 PO_PO_QTY_ORD_LT_QTY_DEL_NA CONSTANT VARCHAR2(30) := 'PO_PO_QTY_ORD_LT_QTY_DEL_NA';
85 PO_PO_AMT_ORD_LT_AMT_DEL_NA CONSTANT VARCHAR2(30) := 'PO_PO_AMT_ORD_LT_AMT_DEL_NA';
86 RCV_ALL_OPEN_PO_PERIOD_HTML CONSTANT VARCHAR2(30) := 'RCV_ALL_OPEN_PO_PERIOD_HTML';
87 PO_WRAPPER_MESSAGE CONSTANT VARCHAR2(30) := 'PO_WRAPPER_MESSAGE';
88 PO_MAX_RET_AMT_GE_RETAINED  CONSTANT VARCHAR2(30) := 'PO_MAX_RET_AMT_GE_RETAINED';  --Bug 5453079
89 
90 ------------------------------------------------------------------
91 ------------------------------------------------------------------
92 -- Token Names used in the messages.
93 ------------------------------------------------------------------
94 ------------------------------------------------------------------
95 c_ERR_NUMBER_token CONSTANT VARCHAR2(30) := 'ERR_NUMBER'; -- PO_ALL_SQL_ERROR
96 c_LSQL_ERR_token CONSTANT VARCHAR2(30) := 'LSQL_ERR'; -- PO_ALL_SQL_ERROR
97 c_QTY_BILLED_token CONSTANT VARCHAR2(30) := 'QTY_BILLED'; -- PO_PO_QTY_ORD_LT_QTY_BILLED_NA
98 c_QTY_ENC_token CONSTANT VARCHAR2(30) := 'QTY_ENC'; -- PO_PO_QTY_ORD_LT_QTY_ENC_NA
99 c_QTY_ORD_token CONSTANT VARCHAR2(30) := 'QTY_ORD'; -- PO_PO_QTY_ORD_LT_QTY_ENC_NA
100 c_QTY_RCVD_token CONSTANT VARCHAR2(30) := 'QTY_RCVD'; -- PO_PO_QTY_ORD_LT_QTY_RCVD_NA
101 c_ROUTINE_token CONSTANT VARCHAR2(30) := 'ROUTINE'; -- PO_ALL_SQL_ERROR
102 c_SQL_ERR_token CONSTANT VARCHAR2(30) := 'SQL_ERR'; -- PO_ALL_SQL_ERROR
103 --PBWC Message Change Impact: Removing and Adding the following tokens.
104 --c_VALUE_token CONSTANT VARCHAR2(30) := 'VALUE'; -- PO_PDOI_INV_CLOSE_TOLERANCE
105 c_QTY_DEL_token CONSTANT VARCHAR2(30) := 'QTY_DEL'; -- PO_PO_QTY_ORD_LT_QTY_DEL_NA
106 c_AMT_BILLED_token CONSTANT VARCHAR2(30) := 'AMT_BILLED'; -- PO_PO_AMT_ORD_LT_AMT_BILLED_NA
107 c_AMT_RCVD_token CONSTANT VARCHAR2(30) := 'AMT_RCVD'; -- PO_PO_AMT_ORD_LT_AMT_RCVD_NA
108 c_AMT_DEL_token CONSTANT VARCHAR2(30) := 'AMT_DEL'; -- PO_PO_AMT_ORD_LT_AMT_DEL_NA
109 c_TOTAL_AMT_token CONSTANT VARCHAR2(30) := 'TOTAL_AMT'; -- PO_CHNG_OTL_INVALID_AMOUNT
110 c_LINE_NUM_token CONSTANT VARCHAR2(30) := 'LINE_NUM';
111 c_SCHED_NUM_token CONSTANT VARCHAR2(30) := 'SCHED_NUM';
112 c_MAX_RET_AMT_token CONSTANT VARCHAR2(30) := 'MAX_RET_AMT';    --PO_MAX_RET_AMT_GE_RETAINED
113 c_AMT_RETAINED_token CONSTANT VARCHAR2(30) := 'AMT_RETAINED';  --PO_MAX_RET_AMT_GE_RETAINED
114 
115 
116 c_MESSAGE_token CONSTANT VARCHAR2(30) := 'MESSAGE';
117 ------------------------------------------------------------------
118 ------------------------------------------------------------------
119 -- Public variables
120 ------------------------------------------------------------------
121 ------------------------------------------------------------------
122 
123 g_routine varchar2(240) := NULL;
124 g_location varchar2(240) := NULL;
125 
126 ------------------------------------------------------------------
127 ------------------------------------------------------------------
128 -- Public subprograms
129 ------------------------------------------------------------------
130 ------------------------------------------------------------------
131 
132 PROCEDURE SQL_ERROR(routine IN varchar2 ,
133                     location IN varchar2,
134                     error_code IN number);
135 
136 PROCEDURE SQL_ERROR(
137   p_package  IN varchar2
138 , p_routine  IN varchar2
139 , p_location IN varchar2
140 , p_sqlcode  IN number
141 , p_sqlerrm  IN varchar
142 );
143 
144 PROCEDURE APP_ERROR(error_name IN varchar2);
145 
146 PROCEDURE APP_ERROR(error_name IN varchar2,
147                     token1 IN varchar2,
148                     value1 IN varchar2);
149 
150 PROCEDURE APP_ERROR(error_name IN varchar2,
151                     token1 IN varchar2,
152                     value1 IN varchar2,
153                     token2 IN varchar2,
154                     value2 IN varchar2);
155 
156 PROCEDURE APP_ERROR(error_name IN varchar2,
157                     token1 IN varchar2,
158                     value1 IN varchar2,
159                     token2 IN varchar2,
160                     value2 IN varchar2,
161                     token3 IN varchar2,
162                     value3 IN varchar2);
163 
164 PROCEDURE APP_ERROR(error_name IN varchar2,
165                     token1 IN varchar2,
166                     value1 IN varchar2,
167                     token2 IN varchar2,
168                     value2 IN varchar2,
169                     token3 IN varchar2,
170                     value3 IN varchar2,
171                     token4 IN varchar2,
172                     value4 IN varchar2);
173 
174 PROCEDURE SQL_SHOW_ERROR;
175 
176 PROCEDURE APP_SET_NAME(error_name IN varchar2);
177 
178 PROCEDURE CLEAR;
179 
180 -- Bug 3516763
181 FUNCTION GET_FND_MSG_PUB_LAST RETURN varchar2;
182 
183 PROCEDURE add_exc_msg
184 (   p_pkg_name		IN VARCHAR2,
185     p_procedure_name	IN VARCHAR2,
186     p_error_text	IN VARCHAR2 := NULL
187 );
188 
189 -- <PDOI Rewrite R12 START>
190 PROCEDURE concat_fnd_messages_in_stack
191 ( p_max_size IN NUMBER,
192   x_message_text OUT NOCOPY VARCHAR2
193 );
194 -- <PDOI Rewrite R12 END>
195 
196 END PO_MESSAGE_S;