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.

[Home] [Help]

APPS.CSP_PC_FORM_PICKHEADERS dependencies on FND_MESSAGE

Line 102: fnd_message.set_name ('INV', 'INV-INVALID ACTION');

98: END IF;
99:
100:
101: IF nvl(p_action_code, fnd_api.g_miss_num) NOT IN (0, 1, 2) THEN
102: fnd_message.set_name ('INV', 'INV-INVALID ACTION');
103: fnd_message.set_token ('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
104: fnd_msg_pub.add;
105: RAISE EXCP_USER_DEFINED;
106: END IF;

Line 103: fnd_message.set_token ('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);

99:
100:
101: IF nvl(p_action_code, fnd_api.g_miss_num) NOT IN (0, 1, 2) THEN
102: fnd_message.set_name ('INV', 'INV-INVALID ACTION');
103: fnd_message.set_token ('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
104: fnd_msg_pub.add;
105: RAISE EXCP_USER_DEFINED;
106: END IF;
107:

Line 117: fnd_message.set_name ('CSP', 'CSP_DUPLICATE_RECORD');

113: FROM CSP_PICKLIST_HEADERS
114: WHERE picklist_header_id = px_picklist_header_id
115: AND organization_id = p_organization_id;
116:
117: fnd_message.set_name ('CSP', 'CSP_DUPLICATE_RECORD');
118: fnd_msg_pub.add;
119: -- l_msg_data := 'Header ID '||px_picklist_header_id||' already exists. It is not allowed to create a new record again with this ID.';
120: RAISE EXCP_USER_DEFINED;
121: EXCEPTION

Line 125: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

121: EXCEPTION
122: WHEN NO_DATA_FOUND THEN -- This is what we want!
123: NULL;
124: WHEN OTHERS THEN
125: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
126: fnd_message.set_token('ERR_FIELD', 'px_picklist_header_id', FALSE);
127: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
128: fnd_message.set_token('TABLE', 'CSP_PICKLIST_HEADERS', FALSE);
129: FND_MSG_PUB.ADD;

Line 126: fnd_message.set_token('ERR_FIELD', 'px_picklist_header_id', FALSE);

122: WHEN NO_DATA_FOUND THEN -- This is what we want!
123: NULL;
124: WHEN OTHERS THEN
125: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
126: fnd_message.set_token('ERR_FIELD', 'px_picklist_header_id', FALSE);
127: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
128: fnd_message.set_token('TABLE', 'CSP_PICKLIST_HEADERS', FALSE);
129: FND_MSG_PUB.ADD;
130: RAISE EXCP_USER_DEFINED;

Line 127: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);

123: NULL;
124: WHEN OTHERS THEN
125: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
126: fnd_message.set_token('ERR_FIELD', 'px_picklist_header_id', FALSE);
127: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
128: fnd_message.set_token('TABLE', 'CSP_PICKLIST_HEADERS', FALSE);
129: FND_MSG_PUB.ADD;
130: RAISE EXCP_USER_DEFINED;
131: END;

Line 128: fnd_message.set_token('TABLE', 'CSP_PICKLIST_HEADERS', FALSE);

124: WHEN OTHERS THEN
125: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
126: fnd_message.set_token('ERR_FIELD', 'px_picklist_header_id', FALSE);
127: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
128: fnd_message.set_token('TABLE', 'CSP_PICKLIST_HEADERS', FALSE);
129: FND_MSG_PUB.ADD;
130: RAISE EXCP_USER_DEFINED;
131: END;
132: END IF;

Line 136: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');

132: END IF;
133:
134: -- Validate the status against the lookup codes.
135: IF nvl(p_PICKLIST_STATUS, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
136: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
137: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_picklist_status', FALSE);
138: FND_MSG_PUB.ADD;
139: RAISE EXCP_USER_DEFINED;
140: ELSE

Line 137: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_picklist_status', FALSE);

133:
134: -- Validate the status against the lookup codes.
135: IF nvl(p_PICKLIST_STATUS, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
136: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
137: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_picklist_status', FALSE);
138: FND_MSG_PUB.ADD;
139: RAISE EXCP_USER_DEFINED;
140: ELSE
141: BEGIN

Line 148: fnd_message.set_name('CSP', 'CSP_INVALID_PICK_STATUS');

144: where lookup_type = 'CSP_PICKLIST_STATUS'
145: and lookup_code = p_PICKLIST_STATUS;
146: EXCEPTION
147: WHEN NO_DATA_FOUND THEN
148: fnd_message.set_name('CSP', 'CSP_INVALID_PICK_STATUS');
149: fnd_message.set_token('PICKLIST_STATUS', p_PICKLIST_STATUS, FALSE);
150: fnd_msg_pub.add;
151: RAISE EXCP_USER_DEFINED;
152: WHEN OTHERS THEN

Line 149: fnd_message.set_token('PICKLIST_STATUS', p_PICKLIST_STATUS, FALSE);

145: and lookup_code = p_PICKLIST_STATUS;
146: EXCEPTION
147: WHEN NO_DATA_FOUND THEN
148: fnd_message.set_name('CSP', 'CSP_INVALID_PICK_STATUS');
149: fnd_message.set_token('PICKLIST_STATUS', p_PICKLIST_STATUS, FALSE);
150: fnd_msg_pub.add;
151: RAISE EXCP_USER_DEFINED;
152: WHEN OTHERS THEN
153: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

Line 153: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

149: fnd_message.set_token('PICKLIST_STATUS', p_PICKLIST_STATUS, FALSE);
150: fnd_msg_pub.add;
151: RAISE EXCP_USER_DEFINED;
152: WHEN OTHERS THEN
153: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
154: fnd_message.set_token('ERR_FIELD', 'px_picklist_status', FALSE);
155: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
156: fnd_message.set_token('TABLE', 'FND_LOOKUPS', FALSE);
157: FND_MSG_PUB.ADD;

Line 154: fnd_message.set_token('ERR_FIELD', 'px_picklist_status', FALSE);

150: fnd_msg_pub.add;
151: RAISE EXCP_USER_DEFINED;
152: WHEN OTHERS THEN
153: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
154: fnd_message.set_token('ERR_FIELD', 'px_picklist_status', FALSE);
155: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
156: fnd_message.set_token('TABLE', 'FND_LOOKUPS', FALSE);
157: FND_MSG_PUB.ADD;
158: RAISE EXCP_USER_DEFINED;

Line 155: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);

151: RAISE EXCP_USER_DEFINED;
152: WHEN OTHERS THEN
153: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
154: fnd_message.set_token('ERR_FIELD', 'px_picklist_status', FALSE);
155: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
156: fnd_message.set_token('TABLE', 'FND_LOOKUPS', FALSE);
157: FND_MSG_PUB.ADD;
158: RAISE EXCP_USER_DEFINED;
159: END;

Line 156: fnd_message.set_token('TABLE', 'FND_LOOKUPS', FALSE);

152: WHEN OTHERS THEN
153: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
154: fnd_message.set_token('ERR_FIELD', 'px_picklist_status', FALSE);
155: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
156: fnd_message.set_token('TABLE', 'FND_LOOKUPS', FALSE);
157: FND_MSG_PUB.ADD;
158: RAISE EXCP_USER_DEFINED;
159: END;
160: END IF;

Line 164: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');

160: END IF;
161:
162: --validation of organization_id
163: IF nvl(p_organization_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
164: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
165: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', FALSE);
166: FND_MSG_PUB.ADD;
167: RAISE EXCP_USER_DEFINED;
168: ELSE

Line 165: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', FALSE);

161:
162: --validation of organization_id
163: IF nvl(p_organization_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
164: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
165: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', FALSE);
166: FND_MSG_PUB.ADD;
167: RAISE EXCP_USER_DEFINED;
168: ELSE
169: BEGIN

Line 175: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');

171: from mtl_parameters
172: where organization_id = p_organization_id;
173: EXCEPTION
174: WHEN NO_DATA_FOUND THEN
175: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');
176: FND_MSG_PUB.ADD;
177: RAISE EXCP_USER_DEFINED;
178: WHEN OTHERS THEN
179: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

Line 179: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

175: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');
176: FND_MSG_PUB.ADD;
177: RAISE EXCP_USER_DEFINED;
178: WHEN OTHERS THEN
179: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
180: fnd_message.set_token('ERR_FIELD', 'p_organization_id', FALSE);
181: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
182: fnd_message.set_token('TABLE', 'ORG_ORGANIZATION_DEFINITIONS', FALSE);
183: FND_MSG_PUB.ADD;

Line 180: fnd_message.set_token('ERR_FIELD', 'p_organization_id', FALSE);

176: FND_MSG_PUB.ADD;
177: RAISE EXCP_USER_DEFINED;
178: WHEN OTHERS THEN
179: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
180: fnd_message.set_token('ERR_FIELD', 'p_organization_id', FALSE);
181: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
182: fnd_message.set_token('TABLE', 'ORG_ORGANIZATION_DEFINITIONS', FALSE);
183: FND_MSG_PUB.ADD;
184: RAISE EXCP_USER_DEFINED;

Line 181: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);

177: RAISE EXCP_USER_DEFINED;
178: WHEN OTHERS THEN
179: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
180: fnd_message.set_token('ERR_FIELD', 'p_organization_id', FALSE);
181: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
182: fnd_message.set_token('TABLE', 'ORG_ORGANIZATION_DEFINITIONS', FALSE);
183: FND_MSG_PUB.ADD;
184: RAISE EXCP_USER_DEFINED;
185: END;

Line 182: fnd_message.set_token('TABLE', 'ORG_ORGANIZATION_DEFINITIONS', FALSE);

178: WHEN OTHERS THEN
179: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
180: fnd_message.set_token('ERR_FIELD', 'p_organization_id', FALSE);
181: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
182: fnd_message.set_token('TABLE', 'ORG_ORGANIZATION_DEFINITIONS', FALSE);
183: FND_MSG_PUB.ADD;
184: RAISE EXCP_USER_DEFINED;
185: END;
186: END IF;

Line 215: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');

211: -- Picklist header id is required for update.
212: -- We do need to take care the case which the user updates the picklist_header_id to a record
213: -- which already exists because the picklist_header_id is a primary key.
214: IF nvl(px_picklist_header_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
215: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
216: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'px_picklist_header_id', FALSE);
217: FND_MSG_PUB.ADD;
218: RAISE EXCP_USER_DEFINED;
219: ELSE

Line 216: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'px_picklist_header_id', FALSE);

212: -- We do need to take care the case which the user updates the picklist_header_id to a record
213: -- which already exists because the picklist_header_id is a primary key.
214: IF nvl(px_picklist_header_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
215: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
216: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'px_picklist_header_id', FALSE);
217: FND_MSG_PUB.ADD;
218: RAISE EXCP_USER_DEFINED;
219: ELSE
220: BEGIN

Line 226: fnd_message.set_name('CSP', 'CSP_INVALID_PICKLIST_HEADER');

222: from csp_picklist_headers
223: where picklist_header_id = px_picklist_header_id;
224: EXCEPTION
225: WHEN NO_DATA_FOUND THEN
226: fnd_message.set_name('CSP', 'CSP_INVALID_PICKLIST_HEADER');
227: fnd_message.set_token ('HEADER_ID', to_char(px_picklist_header_id), FALSE);
228: FND_MSG_PUB.ADD;
229: RAISE EXCP_USER_DEFINED;
230: WHEN OTHERS THEN

Line 227: fnd_message.set_token ('HEADER_ID', to_char(px_picklist_header_id), FALSE);

223: where picklist_header_id = px_picklist_header_id;
224: EXCEPTION
225: WHEN NO_DATA_FOUND THEN
226: fnd_message.set_name('CSP', 'CSP_INVALID_PICKLIST_HEADER');
227: fnd_message.set_token ('HEADER_ID', to_char(px_picklist_header_id), FALSE);
228: FND_MSG_PUB.ADD;
229: RAISE EXCP_USER_DEFINED;
230: WHEN OTHERS THEN
231: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

Line 231: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

227: fnd_message.set_token ('HEADER_ID', to_char(px_picklist_header_id), FALSE);
228: FND_MSG_PUB.ADD;
229: RAISE EXCP_USER_DEFINED;
230: WHEN OTHERS THEN
231: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
232: fnd_message.set_token('ERR_FIELD', 'px_picklist_header_id', FALSE);
233: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
234: fnd_message.set_token('TABLE', 'CSP_PICKLIST_HEADERS', FALSE);
235: FND_MSG_PUB.ADD;

Line 232: fnd_message.set_token('ERR_FIELD', 'px_picklist_header_id', FALSE);

228: FND_MSG_PUB.ADD;
229: RAISE EXCP_USER_DEFINED;
230: WHEN OTHERS THEN
231: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
232: fnd_message.set_token('ERR_FIELD', 'px_picklist_header_id', FALSE);
233: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
234: fnd_message.set_token('TABLE', 'CSP_PICKLIST_HEADERS', FALSE);
235: FND_MSG_PUB.ADD;
236: RAISE EXCP_USER_DEFINED;

Line 233: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);

229: RAISE EXCP_USER_DEFINED;
230: WHEN OTHERS THEN
231: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
232: fnd_message.set_token('ERR_FIELD', 'px_picklist_header_id', FALSE);
233: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
234: fnd_message.set_token('TABLE', 'CSP_PICKLIST_HEADERS', FALSE);
235: FND_MSG_PUB.ADD;
236: RAISE EXCP_USER_DEFINED;
237: END;

Line 234: fnd_message.set_token('TABLE', 'CSP_PICKLIST_HEADERS', FALSE);

230: WHEN OTHERS THEN
231: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
232: fnd_message.set_token('ERR_FIELD', 'px_picklist_header_id', FALSE);
233: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
234: fnd_message.set_token('TABLE', 'CSP_PICKLIST_HEADERS', FALSE);
235: FND_MSG_PUB.ADD;
236: RAISE EXCP_USER_DEFINED;
237: END;
238: END IF;

Line 249: fnd_message.set_name('CSP', 'CSP_INVALID_PICK_STATUS');

245: where lookup_type = 'CSP_PICKLIST_STATUS'
246: and lookup_code = p_PICKLIST_STATUS;
247: EXCEPTION
248: WHEN NO_DATA_FOUND THEN
249: fnd_message.set_name('CSP', 'CSP_INVALID_PICK_STATUS');
250: fnd_message.set_token('PICKLIST_STATUS', p_PICKLIST_STATUS, FALSE);
251: fnd_msg_pub.add;
252: RAISE EXCP_USER_DEFINED;
253: WHEN OTHERS THEN

Line 250: fnd_message.set_token('PICKLIST_STATUS', p_PICKLIST_STATUS, FALSE);

246: and lookup_code = p_PICKLIST_STATUS;
247: EXCEPTION
248: WHEN NO_DATA_FOUND THEN
249: fnd_message.set_name('CSP', 'CSP_INVALID_PICK_STATUS');
250: fnd_message.set_token('PICKLIST_STATUS', p_PICKLIST_STATUS, FALSE);
251: fnd_msg_pub.add;
252: RAISE EXCP_USER_DEFINED;
253: WHEN OTHERS THEN
254: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

Line 254: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

250: fnd_message.set_token('PICKLIST_STATUS', p_PICKLIST_STATUS, FALSE);
251: fnd_msg_pub.add;
252: RAISE EXCP_USER_DEFINED;
253: WHEN OTHERS THEN
254: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
255: fnd_message.set_token('ERR_FIELD', 'px_picklist_status', FALSE);
256: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
257: fnd_message.set_token('TABLE', 'FND_LOOKUPS', FALSE);
258: FND_MSG_PUB.ADD;

Line 255: fnd_message.set_token('ERR_FIELD', 'px_picklist_status', FALSE);

251: fnd_msg_pub.add;
252: RAISE EXCP_USER_DEFINED;
253: WHEN OTHERS THEN
254: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
255: fnd_message.set_token('ERR_FIELD', 'px_picklist_status', FALSE);
256: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
257: fnd_message.set_token('TABLE', 'FND_LOOKUPS', FALSE);
258: FND_MSG_PUB.ADD;
259: RAISE EXCP_USER_DEFINED;

Line 256: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);

252: RAISE EXCP_USER_DEFINED;
253: WHEN OTHERS THEN
254: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
255: fnd_message.set_token('ERR_FIELD', 'px_picklist_status', FALSE);
256: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
257: fnd_message.set_token('TABLE', 'FND_LOOKUPS', FALSE);
258: FND_MSG_PUB.ADD;
259: RAISE EXCP_USER_DEFINED;
260: END;

Line 257: fnd_message.set_token('TABLE', 'FND_LOOKUPS', FALSE);

253: WHEN OTHERS THEN
254: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
255: fnd_message.set_token('ERR_FIELD', 'px_picklist_status', FALSE);
256: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
257: fnd_message.set_token('TABLE', 'FND_LOOKUPS', FALSE);
258: FND_MSG_PUB.ADD;
259: RAISE EXCP_USER_DEFINED;
260: END;
261: END IF;

Line 271: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');

267: from mtl_parameters
268: where organization_id = p_organization_id;
269: EXCEPTION
270: WHEN NO_DATA_FOUND THEN
271: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');
272: FND_MSG_PUB.ADD;
273: RAISE EXCP_USER_DEFINED;
274: WHEN OTHERS THEN
275: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

Line 275: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

271: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');
272: FND_MSG_PUB.ADD;
273: RAISE EXCP_USER_DEFINED;
274: WHEN OTHERS THEN
275: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
276: fnd_message.set_token('ERR_FIELD', 'p_organization_id', FALSE);
277: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
278: fnd_message.set_token('TABLE', 'MTL_PARAMETERS', FALSE);
279: FND_MSG_PUB.ADD;

Line 276: fnd_message.set_token('ERR_FIELD', 'p_organization_id', FALSE);

272: FND_MSG_PUB.ADD;
273: RAISE EXCP_USER_DEFINED;
274: WHEN OTHERS THEN
275: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
276: fnd_message.set_token('ERR_FIELD', 'p_organization_id', FALSE);
277: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
278: fnd_message.set_token('TABLE', 'MTL_PARAMETERS', FALSE);
279: FND_MSG_PUB.ADD;
280: RAISE EXCP_USER_DEFINED;

Line 277: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);

273: RAISE EXCP_USER_DEFINED;
274: WHEN OTHERS THEN
275: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
276: fnd_message.set_token('ERR_FIELD', 'p_organization_id', FALSE);
277: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
278: fnd_message.set_token('TABLE', 'MTL_PARAMETERS', FALSE);
279: FND_MSG_PUB.ADD;
280: RAISE EXCP_USER_DEFINED;
281: END;

Line 278: fnd_message.set_token('TABLE', 'MTL_PARAMETERS', FALSE);

274: WHEN OTHERS THEN
275: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
276: fnd_message.set_token('ERR_FIELD', 'p_organization_id', FALSE);
277: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
278: fnd_message.set_token('TABLE', 'MTL_PARAMETERS', FALSE);
279: FND_MSG_PUB.ADD;
280: RAISE EXCP_USER_DEFINED;
281: END;
282: END IF;

Line 290: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

286: Open l_Get_Creation_Date_Csr;
287: Fetch l_Get_Creation_Date_Csr into l_creation_date;
288: If l_Get_Creation_Date_Csr%NOTFOUND Then
289: Close l_Get_Creation_Date_Csr;
290: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
291: fnd_message.set_token('ERR_FIELD', 'p_cretaion_date', FALSE);
292: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
293: fnd_message.set_token('TABLE', 'CSP_PICKLIST_HEADERS', FALSE);
294: FND_MSG_PUB.ADD;

Line 291: fnd_message.set_token('ERR_FIELD', 'p_cretaion_date', FALSE);

287: Fetch l_Get_Creation_Date_Csr into l_creation_date;
288: If l_Get_Creation_Date_Csr%NOTFOUND Then
289: Close l_Get_Creation_Date_Csr;
290: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
291: fnd_message.set_token('ERR_FIELD', 'p_cretaion_date', FALSE);
292: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
293: fnd_message.set_token('TABLE', 'CSP_PICKLIST_HEADERS', FALSE);
294: FND_MSG_PUB.ADD;
295: RAISE EXCP_USER_DEFINED;

Line 292: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);

288: If l_Get_Creation_Date_Csr%NOTFOUND Then
289: Close l_Get_Creation_Date_Csr;
290: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
291: fnd_message.set_token('ERR_FIELD', 'p_cretaion_date', FALSE);
292: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
293: fnd_message.set_token('TABLE', 'CSP_PICKLIST_HEADERS', FALSE);
294: FND_MSG_PUB.ADD;
295: RAISE EXCP_USER_DEFINED;
296: End if;

Line 293: fnd_message.set_token('TABLE', 'CSP_PICKLIST_HEADERS', FALSE);

289: Close l_Get_Creation_Date_Csr;
290: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
291: fnd_message.set_token('ERR_FIELD', 'p_cretaion_date', FALSE);
292: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
293: fnd_message.set_token('TABLE', 'CSP_PICKLIST_HEADERS', FALSE);
294: FND_MSG_PUB.ADD;
295: RAISE EXCP_USER_DEFINED;
296: End if;
297: Close l_Get_Creation_Date_Csr;

Line 306: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');

302: END IF;
303:
304: ELSE -- p_action_code = 2
305: IF nvl(px_picklist_header_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
306: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
307: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'px_picklist_header_id', FALSE);
308: FND_MSG_PUB.ADD;
309: RAISE EXCP_USER_DEFINED;
310: ELSE

Line 307: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'px_picklist_header_id', FALSE);

303:
304: ELSE -- p_action_code = 2
305: IF nvl(px_picklist_header_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
306: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
307: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'px_picklist_header_id', FALSE);
308: FND_MSG_PUB.ADD;
309: RAISE EXCP_USER_DEFINED;
310: ELSE
311: BEGIN

Line 317: fnd_message.set_name('CSP', 'CSP_INVALID_PICKLIST_HEADER');

313: from csp_picklist_headers
314: where picklist_header_id = px_picklist_header_id;
315: EXCEPTION
316: WHEN NO_DATA_FOUND THEN
317: fnd_message.set_name('CSP', 'CSP_INVALID_PICKLIST_HEADER');
318: fnd_message.set_token ('HEADER_ID', to_char(px_picklist_header_id), FALSE);
319: fnd_msg_pub.add;
320: RAISE EXCP_USER_DEFINED;
321: WHEN OTHERS THEN

Line 318: fnd_message.set_token ('HEADER_ID', to_char(px_picklist_header_id), FALSE);

314: where picklist_header_id = px_picklist_header_id;
315: EXCEPTION
316: WHEN NO_DATA_FOUND THEN
317: fnd_message.set_name('CSP', 'CSP_INVALID_PICKLIST_HEADER');
318: fnd_message.set_token ('HEADER_ID', to_char(px_picklist_header_id), FALSE);
319: fnd_msg_pub.add;
320: RAISE EXCP_USER_DEFINED;
321: WHEN OTHERS THEN
322: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

Line 322: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

318: fnd_message.set_token ('HEADER_ID', to_char(px_picklist_header_id), FALSE);
319: fnd_msg_pub.add;
320: RAISE EXCP_USER_DEFINED;
321: WHEN OTHERS THEN
322: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
323: fnd_message.set_token('ERR_FIELD', 'px_picklist_header_id', FALSE);
324: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
325: fnd_message.set_token('TABLE', 'CSP_PICKLIST_HEADERS', FALSE);
326: FND_MSG_PUB.ADD;

Line 323: fnd_message.set_token('ERR_FIELD', 'px_picklist_header_id', FALSE);

319: fnd_msg_pub.add;
320: RAISE EXCP_USER_DEFINED;
321: WHEN OTHERS THEN
322: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
323: fnd_message.set_token('ERR_FIELD', 'px_picklist_header_id', FALSE);
324: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
325: fnd_message.set_token('TABLE', 'CSP_PICKLIST_HEADERS', FALSE);
326: FND_MSG_PUB.ADD;
327: RAISE EXCP_USER_DEFINED;

Line 324: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);

320: RAISE EXCP_USER_DEFINED;
321: WHEN OTHERS THEN
322: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
323: fnd_message.set_token('ERR_FIELD', 'px_picklist_header_id', FALSE);
324: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
325: fnd_message.set_token('TABLE', 'CSP_PICKLIST_HEADERS', FALSE);
326: FND_MSG_PUB.ADD;
327: RAISE EXCP_USER_DEFINED;
328: END;

Line 325: fnd_message.set_token('TABLE', 'CSP_PICKLIST_HEADERS', FALSE);

321: WHEN OTHERS THEN
322: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
323: fnd_message.set_token('ERR_FIELD', 'px_picklist_header_id', FALSE);
324: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
325: fnd_message.set_token('TABLE', 'CSP_PICKLIST_HEADERS', FALSE);
326: FND_MSG_PUB.ADD;
327: RAISE EXCP_USER_DEFINED;
328: END;
329: END IF;

Line 446: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

442: ,X_MSG_DATA => X_MSG_DATA
443: ,X_RETURN_STATUS => X_RETURN_STATUS);
444: WHEN OTHERS THEN
445: Rollback to Validate_And_Write_PUB;
446: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
447: fnd_message.set_token ('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
448: fnd_message.set_token ('SQLERRM', sqlerrm, FALSE);
449: fnd_msg_pub.add;
450: fnd_msg_pub.count_and_get

Line 447: fnd_message.set_token ('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);

443: ,X_RETURN_STATUS => X_RETURN_STATUS);
444: WHEN OTHERS THEN
445: Rollback to Validate_And_Write_PUB;
446: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
447: fnd_message.set_token ('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
448: fnd_message.set_token ('SQLERRM', sqlerrm, FALSE);
449: fnd_msg_pub.add;
450: fnd_msg_pub.count_and_get
451: ( p_count => x_msg_count

Line 448: fnd_message.set_token ('SQLERRM', sqlerrm, FALSE);

444: WHEN OTHERS THEN
445: Rollback to Validate_And_Write_PUB;
446: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
447: fnd_message.set_token ('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
448: fnd_message.set_token ('SQLERRM', sqlerrm, FALSE);
449: fnd_msg_pub.add;
450: fnd_msg_pub.count_and_get
451: ( p_count => x_msg_count
452: , p_data => x_msg_data);