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_MSG_PUB

Line 108: FND_MSG_PUB.initialize;

104: BEGIN
105: SAVEPOINT Validate_And_Write_PUB;
106: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
107: -- initialize message list
108: FND_MSG_PUB.initialize;
109: END IF;
110:
111: -- Standard call to check for call compatibility.
112: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 124: fnd_msg_pub.add;

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:
128: IF p_action_code = 0 THEN

Line 138: fnd_msg_pub.add;

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
142: NULL;

Line 149: fnd_msg_pub.add;

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:
153: -- Validate the move order line id

Line 157: FND_MSG_PUB.ADD;

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
161: select line_id into l_check_existence

Line 168: fnd_msg_pub.add;

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.
172: NULL;

Line 178: FND_MSG_PUB.ADD;

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;
182:

Line 187: FND_MSG_PUB.ADD;

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
191: -- organization id will be used to validate the item id

Line 199: fnd_msg_pub.add;

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');
203: fnd_message.set_token('ERR_FIELD', 'p_picklist_header_id', FALSE);

Line 206: FND_MSG_PUB.ADD;

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;
210:

Line 215: FND_MSG_PUB.ADD;

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
219: -- validate whether the inventory_item_is exists in the given oranization_id

Line 227: fnd_msg_pub.add;

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');
231: fnd_message.set_token('ERR_FIELD', 'p_inventory_item_id', FALSE);

Line 234: FND_MSG_PUB.ADD;

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;
238:

Line 243: FND_MSG_PUB.ADD;

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:
247: IF nvl(p_transaction_temp_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

Line 250: FND_MSG_PUB.ADD;

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
254: -- validate whether the transaction temp id is valid

Line 264: fnd_msg_pub.add;

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');
268: fnd_message.set_token('ERR_FIELD', 'p_transaction_temp_id', FALSE);

Line 271: FND_MSG_PUB.ADD;

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;
275:

Line 279: FND_MSG_PUB.ADD;

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
283: BEGIN

Line 291: fnd_msg_pub.add;

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');
295: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);

Line 298: FND_MSG_PUB.ADD;

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;
302:

Line 328: FND_MSG_PUB.ADD;

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
332: select picklist_line_id into l_check_existence

Line 339: fnd_msg_pub.add;

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');
343: fnd_message.set_token('ERR_FIELD', 'px_picklist_line_id', FALSE);

Line 346: FND_MSG_PUB.ADD;

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;
350:

Line 379: FND_MSG_PUB.ADD;

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:
383: ELSE -- if the header_id is null

Line 403: fnd_msg_pub.add;

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');
407: fnd_message.set_token('ERR_FIELD', 'p_inventory_item_id', FALSE);

Line 410: FND_MSG_PUB.ADD;

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;
414:

Line 425: fnd_msg_pub.add;

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.
429: NULL;

Line 435: FND_MSG_PUB.ADD;

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;
439:

Line 450: fnd_msg_pub.add;

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');
454: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);

Line 457: FND_MSG_PUB.ADD;

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;
461:

Line 472: fnd_msg_pub.add;

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');
476: fnd_message.set_token('ERR_FIELD', 'p_transaction_temp_id', FALSE);

Line 479: FND_MSG_PUB.ADD;

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;
483:

Line 494: FND_MSG_PUB.ADD;

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;
498: End if;

Line 508: FND_MSG_PUB.ADD;

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
512: select picklist_line_id into l_check_existence

Line 519: fnd_msg_pub.add;

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');
523: fnd_message.set_token('ERR_FIELD', 'px_picklist_line_id', FALSE);

Line 526: FND_MSG_PUB.ADD;

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;
530: END IF;

Line 622: fnd_msg_pub.count_and_get

618: EXCEPTION
619: WHEN EXCP_USER_DEFINED THEN
620: Rollback to Validate_And_Write_PUB;
621: x_return_status := FND_API.G_RET_STS_ERROR;
622: fnd_msg_pub.count_and_get
623: ( p_count => x_msg_count
624: , p_data => x_msg_data);
625: WHEN FND_API.G_EXC_ERROR THEN
626: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

Line 629: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

625: WHEN FND_API.G_EXC_ERROR THEN
626: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
627: P_API_NAME => L_API_NAME
628: ,P_PKG_NAME => G_PKG_NAME
629: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
630: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
631: ,X_MSG_COUNT => X_MSG_COUNT
632: ,X_MSG_DATA => X_MSG_DATA
633: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 638: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
635: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
636: P_API_NAME => L_API_NAME
637: ,P_PKG_NAME => G_PKG_NAME
638: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
639: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
640: ,X_MSG_COUNT => X_MSG_COUNT
641: ,X_MSG_DATA => X_MSG_DATA
642: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 648: fnd_msg_pub.add;

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);
652: x_return_status := fnd_api.g_ret_sts_error;

Line 649: fnd_msg_pub.count_and_get

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);
652: x_return_status := fnd_api.g_ret_sts_error;
653: