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.

APPS.CSP_PC_FORM_PICKLINES dependencies on FND_MESSAGE

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

118: END IF;
119:
120: --validating p_action_code
121: IF p_action_code NOT IN (0, 1, 2) OR p_action_code IS NULL THEN
122: fnd_message.set_name ('INV', 'INV-INVALID ACTION');
123: fnd_message.set_token ('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
124: fnd_msg_pub.add;
125: RAISE EXCP_USER_DEFINED;
126: END IF;

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

119:
120: --validating p_action_code
121: IF p_action_code NOT IN (0, 1, 2) OR p_action_code IS NULL THEN
122: fnd_message.set_name ('INV', 'INV-INVALID ACTION');
123: fnd_message.set_token ('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
124: fnd_msg_pub.add;
125: RAISE EXCP_USER_DEFINED;
126: END IF;
127:

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

133: SELECt picklist_line_id into l_check_existence
134: FROM CSP_PICKLIST_LINES
135: WHERE picklist_line_id = px_picklist_line_id;
136:
137: fnd_message.set_name ('CSP', 'CSP_DUPLICATE_RECORD');
138: fnd_msg_pub.add;
139: RAISE EXCP_USER_DEFINED;
140: EXCEPTION
141: WHEN NO_DATA_FOUND THEN

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

144: End IF;
145:
146: --validating quantity_picked
147: IF nvl(p_quantity_picked, fnd_api.g_miss_num) = fnd_api.g_miss_num OR p_quantity_picked < 0 THEN
148: fnd_message.set_name ('CSP', 'CSP_INVALID_QTY_PICKED');
149: fnd_msg_pub.add;
150: RAISE EXCP_USER_DEFINED;
151: END IF;
152:

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

151: END IF;
152:
153: -- Validate the move order line id
154: IF nvl(p_line_id,fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
155: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
156: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_line_id', FALSE);
157: FND_MSG_PUB.ADD;
158: RAISE EXCP_USER_DEFINED;
159: ELSE

Line 156: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_line_id', FALSE);

152:
153: -- Validate the move order line id
154: IF nvl(p_line_id,fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
155: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
156: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_line_id', FALSE);
157: FND_MSG_PUB.ADD;
158: RAISE EXCP_USER_DEFINED;
159: ELSE
160: BEGIN

Line 166: fnd_message.set_name ('CSP', 'CSP_INVALID_MOVEORDER_LINE');

162: from csp_moveorder_lines
163: where line_id = p_line_id;
164: Exception
165: WHEN NO_DATA_FOUND THEN
166: fnd_message.set_name ('CSP', 'CSP_INVALID_MOVEORDER_LINE');
167: fnd_message.set_token ('LINE_ID', to_char(p_line_id), FALSE);
168: fnd_msg_pub.add;
169: RAISE EXCP_USER_DEFINED;
170: WHEN TOO_MANY_ROWS THEN

Line 167: fnd_message.set_token ('LINE_ID', to_char(p_line_id), FALSE);

163: where line_id = p_line_id;
164: Exception
165: WHEN NO_DATA_FOUND THEN
166: fnd_message.set_name ('CSP', 'CSP_INVALID_MOVEORDER_LINE');
167: fnd_message.set_token ('LINE_ID', to_char(p_line_id), FALSE);
168: fnd_msg_pub.add;
169: RAISE EXCP_USER_DEFINED;
170: WHEN TOO_MANY_ROWS THEN
171: -- This is normal. One move order line id can map to many transaction_temp_id's.

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

170: WHEN TOO_MANY_ROWS THEN
171: -- This is normal. One move order line id can map to many transaction_temp_id's.
172: NULL;
173: WHEN OTHERS THEN
174: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
175: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);
176: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
177: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_LINES', FALSE);
178: FND_MSG_PUB.ADD;

Line 175: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);

171: -- This is normal. One move order line id can map to many transaction_temp_id's.
172: NULL;
173: WHEN OTHERS THEN
174: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
175: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);
176: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
177: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_LINES', FALSE);
178: FND_MSG_PUB.ADD;
179: RAISE EXCP_USER_DEFINED;

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

172: NULL;
173: WHEN OTHERS THEN
174: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
175: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);
176: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
177: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_LINES', FALSE);
178: FND_MSG_PUB.ADD;
179: RAISE EXCP_USER_DEFINED;
180: END;

Line 177: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_LINES', FALSE);

173: WHEN OTHERS THEN
174: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
175: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);
176: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
177: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_LINES', FALSE);
178: FND_MSG_PUB.ADD;
179: RAISE EXCP_USER_DEFINED;
180: END;
181: END IF;

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

181: END IF;
182:
183: --validate p_picklist_header_id
184: IF nvl(p_picklist_header_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
185: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
186: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_picklist_header_id', FALSE);
187: FND_MSG_PUB.ADD;
188: RAISE EXCP_USER_DEFINED;
189: ELSE

Line 186: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_picklist_header_id', FALSE);

182:
183: --validate p_picklist_header_id
184: IF nvl(p_picklist_header_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
185: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
186: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_picklist_header_id', FALSE);
187: FND_MSG_PUB.ADD;
188: RAISE EXCP_USER_DEFINED;
189: ELSE
190: BEGIN

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

193: from csp_picklist_headers
194: where picklist_header_id = p_picklist_header_id;
195: EXCEPTION
196: WHEN NO_DATA_FOUND THEN
197: fnd_message.set_name ('CSP', 'CSP_INVALID_PICKLIST_HEADER');
198: fnd_message.set_token ('HEADER_ID', to_char(p_picklist_header_id), FALSE);
199: fnd_msg_pub.add;
200: RAISE EXCP_USER_DEFINED;
201: WHEN OTHERS THEN

Line 198: fnd_message.set_token ('HEADER_ID', to_char(p_picklist_header_id), FALSE);

194: where picklist_header_id = p_picklist_header_id;
195: EXCEPTION
196: WHEN NO_DATA_FOUND THEN
197: fnd_message.set_name ('CSP', 'CSP_INVALID_PICKLIST_HEADER');
198: fnd_message.set_token ('HEADER_ID', to_char(p_picklist_header_id), FALSE);
199: fnd_msg_pub.add;
200: RAISE EXCP_USER_DEFINED;
201: WHEN OTHERS THEN
202: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

198: fnd_message.set_token ('HEADER_ID', to_char(p_picklist_header_id), FALSE);
199: fnd_msg_pub.add;
200: RAISE EXCP_USER_DEFINED;
201: WHEN OTHERS THEN
202: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
203: fnd_message.set_token('ERR_FIELD', 'p_picklist_header_id', FALSE);
204: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
205: fnd_message.set_token('TABLE', 'CSP_PICKLIST_HEADERS', FALSE);
206: FND_MSG_PUB.ADD;

Line 203: fnd_message.set_token('ERR_FIELD', 'p_picklist_header_id', FALSE);

199: fnd_msg_pub.add;
200: RAISE EXCP_USER_DEFINED;
201: WHEN OTHERS THEN
202: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
203: fnd_message.set_token('ERR_FIELD', 'p_picklist_header_id', FALSE);
204: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
205: fnd_message.set_token('TABLE', 'CSP_PICKLIST_HEADERS', FALSE);
206: FND_MSG_PUB.ADD;
207: RAISE EXCP_USER_DEFINED;

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

200: RAISE EXCP_USER_DEFINED;
201: WHEN OTHERS THEN
202: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
203: fnd_message.set_token('ERR_FIELD', 'p_picklist_header_id', FALSE);
204: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
205: fnd_message.set_token('TABLE', 'CSP_PICKLIST_HEADERS', FALSE);
206: FND_MSG_PUB.ADD;
207: RAISE EXCP_USER_DEFINED;
208: END;

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

201: WHEN OTHERS THEN
202: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
203: fnd_message.set_token('ERR_FIELD', 'p_picklist_header_id', FALSE);
204: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
205: fnd_message.set_token('TABLE', 'CSP_PICKLIST_HEADERS', FALSE);
206: FND_MSG_PUB.ADD;
207: RAISE EXCP_USER_DEFINED;
208: END;
209: END IF;

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

209: END IF;
210:
211: --validating inventory_item_id
212: IF nvl(p_inventory_item_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
213: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
214: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_inventory_item_id ', FALSE);
215: FND_MSG_PUB.ADD;
216: RAISE EXCP_USER_DEFINED;
217: ELSE

Line 214: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_inventory_item_id ', FALSE);

210:
211: --validating inventory_item_id
212: IF nvl(p_inventory_item_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
213: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
214: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_inventory_item_id ', FALSE);
215: FND_MSG_PUB.ADD;
216: RAISE EXCP_USER_DEFINED;
217: ELSE
218: BEGIN

Line 226: fnd_message.set_name('INV', 'INV-NO ITEM RECROD');

222: where inventory_item_id = p_inventory_item_id
223: and organization_id = l_organization_id;
224: EXCEPTION
225: WHEN NO_DATA_FOUND THEN
226: fnd_message.set_name('INV', 'INV-NO ITEM RECROD');
227: fnd_msg_pub.add;
228: RAISE EXCP_USER_DEFINED;
229: WHEN OTHERS THEN
230: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

226: fnd_message.set_name('INV', 'INV-NO ITEM RECROD');
227: fnd_msg_pub.add;
228: RAISE EXCP_USER_DEFINED;
229: WHEN OTHERS THEN
230: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
231: fnd_message.set_token('ERR_FIELD', 'p_inventory_item_id', FALSE);
232: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
233: fnd_message.set_token('TABLE', 'MTL_SYSTEM_ITEMS', FALSE);
234: FND_MSG_PUB.ADD;

Line 231: fnd_message.set_token('ERR_FIELD', 'p_inventory_item_id', FALSE);

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

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

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

Line 233: fnd_message.set_token('TABLE', 'MTL_SYSTEM_ITEMS', FALSE);

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

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

237: END IF;
238:
239: -- Validate the Picklist_Line_Number
240: IF nvl(p_picklist_line_number, 0) < 1 OR p_picklist_line_number = fnd_api.g_miss_num THEN
241: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
242: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_picklist_line_number', FALSE);
243: FND_MSG_PUB.ADD;
244: RAISE EXCP_USER_DEFINED;
245: END IF;

Line 242: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_picklist_line_number', FALSE);

238:
239: -- Validate the Picklist_Line_Number
240: IF nvl(p_picklist_line_number, 0) < 1 OR p_picklist_line_number = fnd_api.g_miss_num THEN
241: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
242: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_picklist_line_number', FALSE);
243: FND_MSG_PUB.ADD;
244: RAISE EXCP_USER_DEFINED;
245: END IF;
246:

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

244: RAISE EXCP_USER_DEFINED;
245: END IF;
246:
247: IF nvl(p_transaction_temp_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
248: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
249: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_transaction_temp_id', FALSE);
250: FND_MSG_PUB.ADD;
251: RAISE EXCP_USER_DEFINED;
252: ELSE

Line 249: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_transaction_temp_id', FALSE);

245: END IF;
246:
247: IF nvl(p_transaction_temp_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
248: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
249: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_transaction_temp_id', FALSE);
250: FND_MSG_PUB.ADD;
251: RAISE EXCP_USER_DEFINED;
252: ELSE
253: BEGIN

Line 262: fnd_message.set_name ('CSP', 'CSP_INVALID_TXN_TEMP_ID');

258: and inventory_item_id = p_inventory_item_id
259: and move_order_line_id = p_line_id;
260: EXCEPTION
261: WHEN NO_DATA_FOUND THEN
262: fnd_message.set_name ('CSP', 'CSP_INVALID_TXN_TEMP_ID');
263: fnd_message.set_token ('ID', to_char(px_picklist_line_id), FALSE);
264: fnd_msg_pub.add;
265: RAISE EXCP_USER_DEFINED;
266: WHEN OTHERS THEN

Line 263: fnd_message.set_token ('ID', to_char(px_picklist_line_id), FALSE);

259: and move_order_line_id = p_line_id;
260: EXCEPTION
261: WHEN NO_DATA_FOUND THEN
262: fnd_message.set_name ('CSP', 'CSP_INVALID_TXN_TEMP_ID');
263: fnd_message.set_token ('ID', to_char(px_picklist_line_id), FALSE);
264: fnd_msg_pub.add;
265: RAISE EXCP_USER_DEFINED;
266: WHEN OTHERS THEN
267: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

263: fnd_message.set_token ('ID', to_char(px_picklist_line_id), FALSE);
264: fnd_msg_pub.add;
265: RAISE EXCP_USER_DEFINED;
266: WHEN OTHERS THEN
267: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
268: fnd_message.set_token('ERR_FIELD', 'p_transaction_temp_id', FALSE);
269: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
270: fnd_message.set_token('TABLE', 'MTL_MATERIAL_TRANSACTIONS_TEMP', FALSE);
271: FND_MSG_PUB.ADD;

Line 268: fnd_message.set_token('ERR_FIELD', 'p_transaction_temp_id', FALSE);

264: fnd_msg_pub.add;
265: RAISE EXCP_USER_DEFINED;
266: WHEN OTHERS THEN
267: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
268: fnd_message.set_token('ERR_FIELD', 'p_transaction_temp_id', FALSE);
269: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
270: fnd_message.set_token('TABLE', 'MTL_MATERIAL_TRANSACTIONS_TEMP', FALSE);
271: FND_MSG_PUB.ADD;
272: RAISE EXCP_USER_DEFINED;

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

265: RAISE EXCP_USER_DEFINED;
266: WHEN OTHERS THEN
267: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
268: fnd_message.set_token('ERR_FIELD', 'p_transaction_temp_id', FALSE);
269: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
270: fnd_message.set_token('TABLE', 'MTL_MATERIAL_TRANSACTIONS_TEMP', FALSE);
271: FND_MSG_PUB.ADD;
272: RAISE EXCP_USER_DEFINED;
273: END;

Line 270: fnd_message.set_token('TABLE', 'MTL_MATERIAL_TRANSACTIONS_TEMP', FALSE);

266: WHEN OTHERS THEN
267: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
268: fnd_message.set_token('ERR_FIELD', 'p_transaction_temp_id', FALSE);
269: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
270: fnd_message.set_token('TABLE', 'MTL_MATERIAL_TRANSACTIONS_TEMP', FALSE);
271: FND_MSG_PUB.ADD;
272: RAISE EXCP_USER_DEFINED;
273: END;
274: END IF;

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

273: END;
274: END IF;
275:
276: IF nvl(p_uom_code, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
277: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
278: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_uom_code', FALSE);
279: FND_MSG_PUB.ADD;
280: RAISE EXCP_USER_DEFINED;
281: ELSE

Line 278: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_uom_code', FALSE);

274: END IF;
275:
276: IF nvl(p_uom_code, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
277: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
278: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_uom_code', FALSE);
279: FND_MSG_PUB.ADD;
280: RAISE EXCP_USER_DEFINED;
281: ELSE
282: -- validate the UOM code

Line 289: fnd_message.set_name('INV', 'INV_UOM_NOTFOUND');

285: from mtl_units_of_measure
286: where UOM_CODE = p_uom_code;
287: EXCEPTION
288: WHEN NO_DATA_FOUND THEN
289: fnd_message.set_name('INV', 'INV_UOM_NOTFOUND');
290: fnd_message.set_token('UOM', p_uom_code, FALSE);
291: fnd_msg_pub.add;
292: RAISE EXCP_USER_DEFINED;
293: WHEN OTHERS THEN

Line 290: fnd_message.set_token('UOM', p_uom_code, FALSE);

286: where UOM_CODE = p_uom_code;
287: EXCEPTION
288: WHEN NO_DATA_FOUND THEN
289: fnd_message.set_name('INV', 'INV_UOM_NOTFOUND');
290: fnd_message.set_token('UOM', p_uom_code, FALSE);
291: fnd_msg_pub.add;
292: RAISE EXCP_USER_DEFINED;
293: WHEN OTHERS THEN
294: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

290: fnd_message.set_token('UOM', p_uom_code, FALSE);
291: fnd_msg_pub.add;
292: RAISE EXCP_USER_DEFINED;
293: WHEN OTHERS THEN
294: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
295: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);
296: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
297: fnd_message.set_token('TABLE', 'MTL_UNITS_OF_MEASURE', FALSE);
298: FND_MSG_PUB.ADD;

Line 295: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);

291: fnd_msg_pub.add;
292: RAISE EXCP_USER_DEFINED;
293: WHEN OTHERS THEN
294: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
295: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);
296: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
297: fnd_message.set_token('TABLE', 'MTL_UNITS_OF_MEASURE', FALSE);
298: FND_MSG_PUB.ADD;
299: RAISE EXCP_USER_DEFINED;

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

292: RAISE EXCP_USER_DEFINED;
293: WHEN OTHERS THEN
294: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
295: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);
296: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
297: fnd_message.set_token('TABLE', 'MTL_UNITS_OF_MEASURE', FALSE);
298: FND_MSG_PUB.ADD;
299: RAISE EXCP_USER_DEFINED;
300: END;

Line 297: fnd_message.set_token('TABLE', 'MTL_UNITS_OF_MEASURE', FALSE);

293: WHEN OTHERS THEN
294: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
295: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);
296: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
297: fnd_message.set_token('TABLE', 'MTL_UNITS_OF_MEASURE', FALSE);
298: FND_MSG_PUB.ADD;
299: RAISE EXCP_USER_DEFINED;
300: END;
301: END IF;

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

322: END IF;
323:
324: ELSIF p_action_code = 1 THEN
325: IF px_picklist_line_id IS NULL THEN
326: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
327: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'px_picklist_line_id', FALSE);
328: FND_MSG_PUB.ADD;
329: RAISE EXCP_USER_DEFINED;
330: ELSE

Line 327: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'px_picklist_line_id', FALSE);

323:
324: ELSIF p_action_code = 1 THEN
325: IF px_picklist_line_id IS NULL THEN
326: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
327: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'px_picklist_line_id', FALSE);
328: FND_MSG_PUB.ADD;
329: RAISE EXCP_USER_DEFINED;
330: ELSE
331: BEGIN

Line 337: fnd_message.set_name ('CSP', 'CSP_INVALID_PICKLIST');

333: from csp_picklist_lines
334: where picklist_line_id = px_picklist_line_id;
335: EXCEPTION
336: WHEN NO_DATA_FOUND THEN
337: fnd_message.set_name ('CSP', 'CSP_INVALID_PICKLIST');
338: fnd_message.set_token ('LINE_ID', to_char(px_picklist_line_id), FALSE);
339: fnd_msg_pub.add;
340: RAISE EXCP_USER_DEFINED;
341: WHEN OTHERS THEN

Line 338: fnd_message.set_token ('LINE_ID', to_char(px_picklist_line_id), FALSE);

334: where picklist_line_id = px_picklist_line_id;
335: EXCEPTION
336: WHEN NO_DATA_FOUND THEN
337: fnd_message.set_name ('CSP', 'CSP_INVALID_PICKLIST');
338: fnd_message.set_token ('LINE_ID', to_char(px_picklist_line_id), FALSE);
339: fnd_msg_pub.add;
340: RAISE EXCP_USER_DEFINED;
341: WHEN OTHERS THEN
342: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

338: fnd_message.set_token ('LINE_ID', to_char(px_picklist_line_id), FALSE);
339: fnd_msg_pub.add;
340: RAISE EXCP_USER_DEFINED;
341: WHEN OTHERS THEN
342: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
343: fnd_message.set_token('ERR_FIELD', 'px_picklist_line_id', FALSE);
344: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
345: fnd_message.set_token('TABLE', 'CSP_PICKLIST_LINES', FALSE);
346: FND_MSG_PUB.ADD;

Line 343: fnd_message.set_token('ERR_FIELD', 'px_picklist_line_id', FALSE);

339: fnd_msg_pub.add;
340: RAISE EXCP_USER_DEFINED;
341: WHEN OTHERS THEN
342: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
343: fnd_message.set_token('ERR_FIELD', 'px_picklist_line_id', FALSE);
344: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
345: fnd_message.set_token('TABLE', 'CSP_PICKLIST_LINES', FALSE);
346: FND_MSG_PUB.ADD;
347: RAISE EXCP_USER_DEFINED;

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

340: RAISE EXCP_USER_DEFINED;
341: WHEN OTHERS THEN
342: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
343: fnd_message.set_token('ERR_FIELD', 'px_picklist_line_id', FALSE);
344: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
345: fnd_message.set_token('TABLE', 'CSP_PICKLIST_LINES', FALSE);
346: FND_MSG_PUB.ADD;
347: RAISE EXCP_USER_DEFINED;
348: END;

Line 345: fnd_message.set_token('TABLE', 'CSP_PICKLIST_LINES', FALSE);

341: WHEN OTHERS THEN
342: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
343: fnd_message.set_token('ERR_FIELD', 'px_picklist_line_id', FALSE);
344: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
345: fnd_message.set_token('TABLE', 'CSP_PICKLIST_LINES', FALSE);
346: FND_MSG_PUB.ADD;
347: RAISE EXCP_USER_DEFINED;
348: END;
349: END IF;

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

366: where picklist_header_id = p_picklist_header_id;
367:
368: EXCEPTION
369: WHEN NO_DATA_FOUND THEN
370: fnd_message.set_name('CSP', 'CSP_INVALID_PICKLIST_HEADER');
371: fnd_message.set_token ('HEADER_ID', to_char(p_picklist_header_id), FALSE);
372: -- l_msg_data := 'Pick List Header ID does not exist in the organization.';
373: RAISE EXCP_USER_DEFINED;
374: WHEN OTHERS THEN

Line 371: fnd_message.set_token ('HEADER_ID', to_char(p_picklist_header_id), FALSE);

367:
368: EXCEPTION
369: WHEN NO_DATA_FOUND THEN
370: fnd_message.set_name('CSP', 'CSP_INVALID_PICKLIST_HEADER');
371: fnd_message.set_token ('HEADER_ID', to_char(p_picklist_header_id), FALSE);
372: -- l_msg_data := 'Pick List Header ID does not exist in the organization.';
373: RAISE EXCP_USER_DEFINED;
374: WHEN OTHERS THEN
375: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

371: fnd_message.set_token ('HEADER_ID', to_char(p_picklist_header_id), FALSE);
372: -- l_msg_data := 'Pick List Header ID does not exist in the organization.';
373: RAISE EXCP_USER_DEFINED;
374: WHEN OTHERS THEN
375: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
376: fnd_message.set_token('ERR_FIELD', 'px_picklist_line_id', FALSE);
377: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
378: fnd_message.set_token('TABLE', 'CSP_PICKLIST_LINES', FALSE);
379: FND_MSG_PUB.ADD;

Line 376: fnd_message.set_token('ERR_FIELD', 'px_picklist_line_id', FALSE);

372: -- l_msg_data := 'Pick List Header ID does not exist in the organization.';
373: RAISE EXCP_USER_DEFINED;
374: WHEN OTHERS THEN
375: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
376: fnd_message.set_token('ERR_FIELD', 'px_picklist_line_id', FALSE);
377: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
378: fnd_message.set_token('TABLE', 'CSP_PICKLIST_LINES', FALSE);
379: FND_MSG_PUB.ADD;
380: RAISE EXCP_USER_DEFINED;

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

373: RAISE EXCP_USER_DEFINED;
374: WHEN OTHERS THEN
375: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
376: fnd_message.set_token('ERR_FIELD', 'px_picklist_line_id', FALSE);
377: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
378: fnd_message.set_token('TABLE', 'CSP_PICKLIST_LINES', FALSE);
379: FND_MSG_PUB.ADD;
380: RAISE EXCP_USER_DEFINED;
381: END;

Line 378: fnd_message.set_token('TABLE', 'CSP_PICKLIST_LINES', FALSE);

374: WHEN OTHERS THEN
375: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
376: fnd_message.set_token('ERR_FIELD', 'px_picklist_line_id', FALSE);
377: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
378: fnd_message.set_token('TABLE', 'CSP_PICKLIST_LINES', FALSE);
379: FND_MSG_PUB.ADD;
380: RAISE EXCP_USER_DEFINED;
381: END;
382:

Line 402: fnd_message.set_name('INV', 'INV-NO ITEM RECROD');

398: where inventory_item_id = p_inventory_item_id
399: and organization_id = l_organization_id;
400: EXCEPTION
401: WHEN NO_DATA_FOUND THEN
402: fnd_message.set_name('INV', 'INV-NO ITEM RECROD');
403: fnd_msg_pub.add;
404: RAISE EXCP_USER_DEFINED;
405: WHEN OTHERS THEN
406: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

402: fnd_message.set_name('INV', 'INV-NO ITEM RECROD');
403: fnd_msg_pub.add;
404: RAISE EXCP_USER_DEFINED;
405: WHEN OTHERS THEN
406: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
407: fnd_message.set_token('ERR_FIELD', 'p_inventory_item_id', FALSE);
408: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
409: fnd_message.set_token('TABLE', 'MTL_SYSTEM_ITEMS', FALSE);
410: FND_MSG_PUB.ADD;

Line 407: fnd_message.set_token('ERR_FIELD', 'p_inventory_item_id', FALSE);

403: fnd_msg_pub.add;
404: RAISE EXCP_USER_DEFINED;
405: WHEN OTHERS THEN
406: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
407: fnd_message.set_token('ERR_FIELD', 'p_inventory_item_id', FALSE);
408: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
409: fnd_message.set_token('TABLE', 'MTL_SYSTEM_ITEMS', FALSE);
410: FND_MSG_PUB.ADD;
411: RAISE EXCP_USER_DEFINED;

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

404: RAISE EXCP_USER_DEFINED;
405: WHEN OTHERS THEN
406: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
407: fnd_message.set_token('ERR_FIELD', 'p_inventory_item_id', FALSE);
408: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
409: fnd_message.set_token('TABLE', 'MTL_SYSTEM_ITEMS', FALSE);
410: FND_MSG_PUB.ADD;
411: RAISE EXCP_USER_DEFINED;
412: END;

Line 409: fnd_message.set_token('TABLE', 'MTL_SYSTEM_ITEMS', FALSE);

405: WHEN OTHERS THEN
406: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
407: fnd_message.set_token('ERR_FIELD', 'p_inventory_item_id', FALSE);
408: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
409: fnd_message.set_token('TABLE', 'MTL_SYSTEM_ITEMS', FALSE);
410: FND_MSG_PUB.ADD;
411: RAISE EXCP_USER_DEFINED;
412: END;
413: END IF;

Line 423: fnd_message.set_name ('CSP', 'CSP_INVALID_MOVEORDER_LINE');

419: from csp_moveorder_lines
420: where line_id = p_line_id;
421: EXCEPTION
422: WHEN NO_DATA_FOUND THEN
423: fnd_message.set_name ('CSP', 'CSP_INVALID_MOVEORDER_LINE');
424: fnd_message.set_token ('LINE_ID', to_char(p_line_id), FALSE);
425: fnd_msg_pub.add;
426: RAISE EXCP_USER_DEFINED;
427: WHEN TOO_MANY_ROWS THEN

Line 424: fnd_message.set_token ('LINE_ID', to_char(p_line_id), FALSE);

420: where line_id = p_line_id;
421: EXCEPTION
422: WHEN NO_DATA_FOUND THEN
423: fnd_message.set_name ('CSP', 'CSP_INVALID_MOVEORDER_LINE');
424: fnd_message.set_token ('LINE_ID', to_char(p_line_id), FALSE);
425: fnd_msg_pub.add;
426: RAISE EXCP_USER_DEFINED;
427: WHEN TOO_MANY_ROWS THEN
428: -- This is normal. One move order line id can map to many transaction_temp_id's.

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

427: WHEN TOO_MANY_ROWS THEN
428: -- This is normal. One move order line id can map to many transaction_temp_id's.
429: NULL;
430: WHEN OTHERS THEN
431: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
432: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);
433: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
434: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_LINES', FALSE);
435: FND_MSG_PUB.ADD;

Line 432: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);

428: -- This is normal. One move order line id can map to many transaction_temp_id's.
429: NULL;
430: WHEN OTHERS THEN
431: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
432: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);
433: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
434: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_LINES', FALSE);
435: FND_MSG_PUB.ADD;
436: RAISE EXCP_USER_DEFINED;

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

429: NULL;
430: WHEN OTHERS THEN
431: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
432: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);
433: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
434: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_LINES', FALSE);
435: FND_MSG_PUB.ADD;
436: RAISE EXCP_USER_DEFINED;
437: END;

Line 434: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_LINES', FALSE);

430: WHEN OTHERS THEN
431: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
432: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);
433: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
434: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_LINES', FALSE);
435: FND_MSG_PUB.ADD;
436: RAISE EXCP_USER_DEFINED;
437: END;
438: END IF;

Line 448: fnd_message.set_name('INV', 'INV_UOM_NOTFOUND');

444: from mtl_units_of_measure
445: where UOM_CODE = p_uom_code;
446: EXCEPTION
447: WHEN NO_DATA_FOUND THEN
448: fnd_message.set_name('INV', 'INV_UOM_NOTFOUND');
449: fnd_message.set_token('UOM', p_uom_code, FALSE);
450: fnd_msg_pub.add;
451: RAISE EXCP_USER_DEFINED;
452: WHEN OTHERS THEN

Line 449: fnd_message.set_token('UOM', p_uom_code, FALSE);

445: where UOM_CODE = p_uom_code;
446: EXCEPTION
447: WHEN NO_DATA_FOUND THEN
448: fnd_message.set_name('INV', 'INV_UOM_NOTFOUND');
449: fnd_message.set_token('UOM', p_uom_code, FALSE);
450: fnd_msg_pub.add;
451: RAISE EXCP_USER_DEFINED;
452: WHEN OTHERS THEN
453: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

449: fnd_message.set_token('UOM', p_uom_code, FALSE);
450: fnd_msg_pub.add;
451: RAISE EXCP_USER_DEFINED;
452: WHEN OTHERS THEN
453: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
454: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);
455: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
456: fnd_message.set_token('TABLE', 'MTL_UNITS_OF_MEASURE', FALSE);
457: FND_MSG_PUB.ADD;

Line 454: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);

450: fnd_msg_pub.add;
451: RAISE EXCP_USER_DEFINED;
452: WHEN OTHERS THEN
453: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
454: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);
455: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
456: fnd_message.set_token('TABLE', 'MTL_UNITS_OF_MEASURE', FALSE);
457: FND_MSG_PUB.ADD;
458: RAISE EXCP_USER_DEFINED;

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

451: RAISE EXCP_USER_DEFINED;
452: WHEN OTHERS THEN
453: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
454: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);
455: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
456: fnd_message.set_token('TABLE', 'MTL_UNITS_OF_MEASURE', FALSE);
457: FND_MSG_PUB.ADD;
458: RAISE EXCP_USER_DEFINED;
459: END;

Line 456: fnd_message.set_token('TABLE', 'MTL_UNITS_OF_MEASURE', FALSE);

452: WHEN OTHERS THEN
453: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
454: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);
455: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
456: fnd_message.set_token('TABLE', 'MTL_UNITS_OF_MEASURE', FALSE);
457: FND_MSG_PUB.ADD;
458: RAISE EXCP_USER_DEFINED;
459: END;
460: END IF;

Line 470: fnd_message.set_name ('CSP', 'CSP_INVALID_TXN_TEMP_ID');

466: from mtl_material_transactions_temp
467: where transaction_temp_id = p_transaction_temp_id;
468: EXCEPTION
469: WHEN NO_DATA_FOUND THEN
470: fnd_message.set_name ('CSP', 'CSP_INVALID_TXN_TEMP_ID');
471: fnd_message.set_token ('ID', to_char(px_picklist_line_id), FALSE);
472: fnd_msg_pub.add;
473: RAISE EXCP_USER_DEFINED;
474: WHEN OTHERS THEN

Line 471: fnd_message.set_token ('ID', to_char(px_picklist_line_id), FALSE);

467: where transaction_temp_id = p_transaction_temp_id;
468: EXCEPTION
469: WHEN NO_DATA_FOUND THEN
470: fnd_message.set_name ('CSP', 'CSP_INVALID_TXN_TEMP_ID');
471: fnd_message.set_token ('ID', to_char(px_picklist_line_id), FALSE);
472: fnd_msg_pub.add;
473: RAISE EXCP_USER_DEFINED;
474: WHEN OTHERS THEN
475: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

471: fnd_message.set_token ('ID', to_char(px_picklist_line_id), FALSE);
472: fnd_msg_pub.add;
473: RAISE EXCP_USER_DEFINED;
474: WHEN OTHERS THEN
475: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
476: fnd_message.set_token('ERR_FIELD', 'p_transaction_temp_id', FALSE);
477: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
478: fnd_message.set_token('TABLE', 'MTL_MATERIAL_TRANSACTIONS_TEMP', FALSE);
479: FND_MSG_PUB.ADD;

Line 476: fnd_message.set_token('ERR_FIELD', 'p_transaction_temp_id', FALSE);

472: fnd_msg_pub.add;
473: RAISE EXCP_USER_DEFINED;
474: WHEN OTHERS THEN
475: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
476: fnd_message.set_token('ERR_FIELD', 'p_transaction_temp_id', FALSE);
477: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
478: fnd_message.set_token('TABLE', 'MTL_MATERIAL_TRANSACTIONS_TEMP', FALSE);
479: FND_MSG_PUB.ADD;
480: RAISE EXCP_USER_DEFINED;

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

473: RAISE EXCP_USER_DEFINED;
474: WHEN OTHERS THEN
475: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
476: fnd_message.set_token('ERR_FIELD', 'p_transaction_temp_id', FALSE);
477: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
478: fnd_message.set_token('TABLE', 'MTL_MATERIAL_TRANSACTIONS_TEMP', FALSE);
479: FND_MSG_PUB.ADD;
480: RAISE EXCP_USER_DEFINED;
481: END;

Line 478: fnd_message.set_token('TABLE', 'MTL_MATERIAL_TRANSACTIONS_TEMP', FALSE);

474: WHEN OTHERS THEN
475: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
476: fnd_message.set_token('ERR_FIELD', 'p_transaction_temp_id', FALSE);
477: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
478: fnd_message.set_token('TABLE', 'MTL_MATERIAL_TRANSACTIONS_TEMP', FALSE);
479: FND_MSG_PUB.ADD;
480: RAISE EXCP_USER_DEFINED;
481: END;
482: END IF;

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

486: Open l_Get_Creation_Date_Csr;
487: Fetch l_Get_Creation_Date_Csr into l_creation_date;
488: If l_Get_Creation_Date_Csr%NOTFOUND Then
489: Close l_Get_Creation_Date_Csr;
490: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
491: fnd_message.set_token('ERR_FIELD', 'p_cretaion_date', FALSE);
492: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
493: fnd_message.set_token('TABLE', 'CSP_PICKLIST_LINES', FALSE);
494: FND_MSG_PUB.ADD;

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

487: Fetch l_Get_Creation_Date_Csr into l_creation_date;
488: If l_Get_Creation_Date_Csr%NOTFOUND Then
489: Close l_Get_Creation_Date_Csr;
490: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
491: fnd_message.set_token('ERR_FIELD', 'p_cretaion_date', FALSE);
492: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
493: fnd_message.set_token('TABLE', 'CSP_PICKLIST_LINES', FALSE);
494: FND_MSG_PUB.ADD;
495: RAISE EXCP_USER_DEFINED;

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

488: If l_Get_Creation_Date_Csr%NOTFOUND Then
489: Close l_Get_Creation_Date_Csr;
490: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
491: fnd_message.set_token('ERR_FIELD', 'p_cretaion_date', FALSE);
492: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
493: fnd_message.set_token('TABLE', 'CSP_PICKLIST_LINES', FALSE);
494: FND_MSG_PUB.ADD;
495: RAISE EXCP_USER_DEFINED;
496: End if;

Line 493: fnd_message.set_token('TABLE', 'CSP_PICKLIST_LINES', FALSE);

489: Close l_Get_Creation_Date_Csr;
490: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
491: fnd_message.set_token('ERR_FIELD', 'p_cretaion_date', FALSE);
492: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
493: fnd_message.set_token('TABLE', 'CSP_PICKLIST_LINES', FALSE);
494: FND_MSG_PUB.ADD;
495: RAISE EXCP_USER_DEFINED;
496: End if;
497: Close l_Get_Creation_Date_Csr;

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

502: END IF;
503:
504: ELSE -- p_action_code = 2
505: IF px_picklist_line_id IS NULL THEN
506: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
507: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'px_picklist_line_id', FALSE);
508: FND_MSG_PUB.ADD;
509: RAISE EXCP_USER_DEFINED;
510: ELSE

Line 507: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'px_picklist_line_id', FALSE);

503:
504: ELSE -- p_action_code = 2
505: IF px_picklist_line_id IS NULL THEN
506: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
507: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'px_picklist_line_id', FALSE);
508: FND_MSG_PUB.ADD;
509: RAISE EXCP_USER_DEFINED;
510: ELSE
511: BEGIN

Line 517: fnd_message.set_name ('CSP', 'CSP_INVALID_PICKLIST');

513: from csp_picklist_lines
514: where picklist_line_id = px_picklist_line_id;
515: EXCEPTION
516: WHEN NO_DATA_FOUND THEN
517: fnd_message.set_name ('CSP', 'CSP_INVALID_PICKLIST');
518: fnd_message.set_token ('LINE_ID', to_char(px_picklist_line_id), FALSE);
519: fnd_msg_pub.add;
520: RAISE EXCP_USER_DEFINED;
521: WHEN OTHERS THEN

Line 518: fnd_message.set_token ('LINE_ID', to_char(px_picklist_line_id), FALSE);

514: where picklist_line_id = px_picklist_line_id;
515: EXCEPTION
516: WHEN NO_DATA_FOUND THEN
517: fnd_message.set_name ('CSP', 'CSP_INVALID_PICKLIST');
518: fnd_message.set_token ('LINE_ID', to_char(px_picklist_line_id), FALSE);
519: fnd_msg_pub.add;
520: RAISE EXCP_USER_DEFINED;
521: WHEN OTHERS THEN
522: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

518: fnd_message.set_token ('LINE_ID', to_char(px_picklist_line_id), FALSE);
519: fnd_msg_pub.add;
520: RAISE EXCP_USER_DEFINED;
521: WHEN OTHERS THEN
522: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
523: fnd_message.set_token('ERR_FIELD', 'px_picklist_line_id', FALSE);
524: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
525: fnd_message.set_token('TABLE', 'CSP_PICKLIST_LINES', FALSE);
526: FND_MSG_PUB.ADD;

Line 523: fnd_message.set_token('ERR_FIELD', 'px_picklist_line_id', FALSE);

519: fnd_msg_pub.add;
520: RAISE EXCP_USER_DEFINED;
521: WHEN OTHERS THEN
522: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
523: fnd_message.set_token('ERR_FIELD', 'px_picklist_line_id', FALSE);
524: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
525: fnd_message.set_token('TABLE', 'CSP_PICKLIST_LINES', FALSE);
526: FND_MSG_PUB.ADD;
527: RAISE EXCP_USER_DEFINED;

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

520: RAISE EXCP_USER_DEFINED;
521: WHEN OTHERS THEN
522: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
523: fnd_message.set_token('ERR_FIELD', 'px_picklist_line_id', FALSE);
524: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
525: fnd_message.set_token('TABLE', 'CSP_PICKLIST_LINES', FALSE);
526: FND_MSG_PUB.ADD;
527: RAISE EXCP_USER_DEFINED;
528: END;

Line 525: fnd_message.set_token('TABLE', 'CSP_PICKLIST_LINES', FALSE);

521: WHEN OTHERS THEN
522: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
523: fnd_message.set_token('ERR_FIELD', 'px_picklist_line_id', FALSE);
524: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
525: fnd_message.set_token('TABLE', 'CSP_PICKLIST_LINES', FALSE);
526: FND_MSG_PUB.ADD;
527: RAISE EXCP_USER_DEFINED;
528: END;
529: END IF;

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

641: ,X_MSG_DATA => X_MSG_DATA
642: ,X_RETURN_STATUS => X_RETURN_STATUS);
643: WHEN OTHERS THEN
644: Rollback to Validate_And_Write_PUB;
645: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
646: fnd_message.set_token ('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
647: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
648: fnd_msg_pub.add;
649: fnd_msg_pub.count_and_get

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

642: ,X_RETURN_STATUS => X_RETURN_STATUS);
643: WHEN OTHERS THEN
644: Rollback to Validate_And_Write_PUB;
645: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
646: fnd_message.set_token ('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
647: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
648: fnd_msg_pub.add;
649: fnd_msg_pub.count_and_get
650: ( p_count => x_msg_count

Line 647: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);

643: WHEN OTHERS THEN
644: Rollback to Validate_And_Write_PUB;
645: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
646: fnd_message.set_token ('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
647: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
648: fnd_msg_pub.add;
649: fnd_msg_pub.count_and_get
650: ( p_count => x_msg_count
651: , p_data => x_msg_data);