APPS.CSP_PL_SHIP_UTIL dependencies on FND_MESSAGE

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

206:
207: IF p_validation_level = FND_API.G_VALID_LEVEL_FULL THEN
208: -- validate p_organization_id
209: IF p_organization_id IS NULL THEN
210: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
211: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);
212: FND_MSG_PUB.ADD;
213: RAISE EXCP_USER_DEFINED;
214: ELSE

Line 211: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);

207: IF p_validation_level = FND_API.G_VALID_LEVEL_FULL THEN
208: -- validate p_organization_id
209: IF p_organization_id IS NULL THEN
210: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
211: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);
212: FND_MSG_PUB.ADD;
213: RAISE EXCP_USER_DEFINED;
214: ELSE
215: IF p_validation_level = fnd_api.g_valid_level_full THEN

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

218: from mtl_parameters
219: where organization_id = p_organization_id;
220: EXCEPTION
221: WHEN NO_DATA_FOUND THEN
222: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');
223: FND_MSG_PUB.ADD;
224: RAISE EXCP_USER_DEFINED;
225: WHEN OTHERS THEN
226: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

222: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');
223: FND_MSG_PUB.ADD;
224: RAISE EXCP_USER_DEFINED;
225: WHEN OTHERS THEN
226: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
227: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);
228: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
229: fnd_message.set_token('TABLE', 'mtl_parameters', TRUE);
230: FND_MSG_PUB.ADD;

Line 227: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);

223: FND_MSG_PUB.ADD;
224: RAISE EXCP_USER_DEFINED;
225: WHEN OTHERS THEN
226: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
227: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);
228: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
229: fnd_message.set_token('TABLE', 'mtl_parameters', TRUE);
230: FND_MSG_PUB.ADD;
231: RAISE EXCP_USER_DEFINED;

Line 228: fnd_message.set_token('ROUTINE', l_api_name, TRUE);

224: RAISE EXCP_USER_DEFINED;
225: WHEN OTHERS THEN
226: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
227: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);
228: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
229: fnd_message.set_token('TABLE', 'mtl_parameters', TRUE);
230: FND_MSG_PUB.ADD;
231: RAISE EXCP_USER_DEFINED;
232: END;

Line 229: fnd_message.set_token('TABLE', 'mtl_parameters', TRUE);

225: WHEN OTHERS THEN
226: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
227: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);
228: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
229: fnd_message.set_token('TABLE', 'mtl_parameters', TRUE);
230: FND_MSG_PUB.ADD;
231: RAISE EXCP_USER_DEFINED;
232: END;
233: END IF;

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

235: END IF;
236:
237: -- validate packlist_header_id
238: IF p_packlist_header_id IS NULL THEN
239: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
240: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_packlist_header_id', TRUE);
241: FND_MSG_PUB.ADD;
242: RAISE EXCP_USER_DEFINED;
243: ELSE

Line 240: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_packlist_header_id', TRUE);

236:
237: -- validate packlist_header_id
238: IF p_packlist_header_id IS NULL THEN
239: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
240: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_packlist_header_id', TRUE);
241: FND_MSG_PUB.ADD;
242: RAISE EXCP_USER_DEFINED;
243: ELSE
244: IF p_validation_level = fnd_api.g_valid_level_full THEN

Line 252: FND_MESSAGE.SET_NAME ('CSP', 'CSP_INVALID_PACKLIST_HEADER');

248: where organization_id = p_organization_id
249: and packlist_header_id = p_packlist_header_id;
250: EXCEPTION
251: WHEN NO_DATA_FOUND THEN
252: FND_MESSAGE.SET_NAME ('CSP', 'CSP_INVALID_PACKLIST_HEADER');
253: FND_MESSAGE.SET_TOKEN('HEADER_ID', to_char(p_packlist_header_id), TRUE);
254: FND_MSG_PUB.ADD;
255: RAISE EXCP_USER_DEFINED;
256: WHEN OTHERS THEN

Line 253: FND_MESSAGE.SET_TOKEN('HEADER_ID', to_char(p_packlist_header_id), TRUE);

249: and packlist_header_id = p_packlist_header_id;
250: EXCEPTION
251: WHEN NO_DATA_FOUND THEN
252: FND_MESSAGE.SET_NAME ('CSP', 'CSP_INVALID_PACKLIST_HEADER');
253: FND_MESSAGE.SET_TOKEN('HEADER_ID', to_char(p_packlist_header_id), TRUE);
254: FND_MSG_PUB.ADD;
255: RAISE EXCP_USER_DEFINED;
256: WHEN OTHERS THEN
257: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

253: FND_MESSAGE.SET_TOKEN('HEADER_ID', to_char(p_packlist_header_id), TRUE);
254: FND_MSG_PUB.ADD;
255: RAISE EXCP_USER_DEFINED;
256: WHEN OTHERS THEN
257: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
258: fnd_message.set_token('ERR_FIELD', 'p_packlist_header_id', TRUE);
259: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
260: fnd_message.set_token('TABLE', 'csp_packlist_headers', TRUE);
261: FND_MSG_PUB.ADD;

Line 258: fnd_message.set_token('ERR_FIELD', 'p_packlist_header_id', TRUE);

254: FND_MSG_PUB.ADD;
255: RAISE EXCP_USER_DEFINED;
256: WHEN OTHERS THEN
257: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
258: fnd_message.set_token('ERR_FIELD', 'p_packlist_header_id', TRUE);
259: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
260: fnd_message.set_token('TABLE', 'csp_packlist_headers', TRUE);
261: FND_MSG_PUB.ADD;
262: RAISE EXCP_USER_DEFINED;

Line 259: fnd_message.set_token('ROUTINE', l_api_name, TRUE);

255: RAISE EXCP_USER_DEFINED;
256: WHEN OTHERS THEN
257: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
258: fnd_message.set_token('ERR_FIELD', 'p_packlist_header_id', TRUE);
259: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
260: fnd_message.set_token('TABLE', 'csp_packlist_headers', TRUE);
261: FND_MSG_PUB.ADD;
262: RAISE EXCP_USER_DEFINED;
263: END;

Line 260: fnd_message.set_token('TABLE', 'csp_packlist_headers', TRUE);

256: WHEN OTHERS THEN
257: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
258: fnd_message.set_token('ERR_FIELD', 'p_packlist_header_id', TRUE);
259: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
260: fnd_message.set_token('TABLE', 'csp_packlist_headers', TRUE);
261: FND_MSG_PUB.ADD;
262: RAISE EXCP_USER_DEFINED;
263: END;
264: END IF;

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

271: Fetch C_Get_Packlist_Headers Into l_packlist_headers_rec;
272:
273: IF C_Get_Packlist_Headers%NOTFOUND THEN
274: CLOSE C_Get_Packlist_Headers;
275: fnd_message.set_name ('CSP', 'CSP_INVALID_PACKLIST_HEADER');
276: fnd_message.set_token ('HEADER_ID', to_char(p_packlist_header_id), TRUE);
277: fnd_msg_pub.add;
278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: END IF;

Line 276: fnd_message.set_token ('HEADER_ID', to_char(p_packlist_header_id), TRUE);

272:
273: IF C_Get_Packlist_Headers%NOTFOUND THEN
274: CLOSE C_Get_Packlist_Headers;
275: fnd_message.set_name ('CSP', 'CSP_INVALID_PACKLIST_HEADER');
276: fnd_message.set_token ('HEADER_ID', to_char(p_packlist_header_id), TRUE);
277: fnd_msg_pub.add;
278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: END IF;
280: CLOSE C_Get_Packlist_Headers;

Line 357: fnd_message.set_name ('CSP', 'CSP_NO_TXN_RECORD');

353: OPEN C_Get_Temp_ID;
354: FETCH C_Get_Temp_ID INTO l_temp_id;
355: IF C_Get_Temp_ID%NOTFOUND THEN
356: CLOSE C_Get_Temp_ID;
357: fnd_message.set_name ('CSP', 'CSP_NO_TXN_RECORD');
358: fnd_message.set_token ('PICKLIST_ID', to_char(l_packlist_line_rec.picklist_line_id), TRUE);
359: fnd_msg_pub.add;
360: RAISE EXCP_USER_DEFINED;
361: END IF;

Line 358: fnd_message.set_token ('PICKLIST_ID', to_char(l_packlist_line_rec.picklist_line_id), TRUE);

354: FETCH C_Get_Temp_ID INTO l_temp_id;
355: IF C_Get_Temp_ID%NOTFOUND THEN
356: CLOSE C_Get_Temp_ID;
357: fnd_message.set_name ('CSP', 'CSP_NO_TXN_RECORD');
358: fnd_message.set_token ('PICKLIST_ID', to_char(l_packlist_line_rec.picklist_line_id), TRUE);
359: fnd_msg_pub.add;
360: RAISE EXCP_USER_DEFINED;
361: END IF;
362:

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

366: OPEN C_Get_Move_Order_Line_ID(l_temp_id);
367: FETCH C_Get_Move_Order_Line_ID INTO l_move_order_line_id;
368: IF C_Get_Move_Order_Line_ID%NOTFOUND THEN
369: CLOSE C_Get_Move_Order_Line_ID;
370: fnd_message.set_name ('CSP', 'CSP_PACKLIST_MOVEORDER_ERRORS');
371: fnd_message.set_token ('HEADER_ID', to_char(p_packlist_header_id), TRUE);
372: fnd_msg_pub.add;
373: RAISE EXCP_USER_DEFINED;
374: END IF;

Line 371: fnd_message.set_token ('HEADER_ID', to_char(p_packlist_header_id), TRUE);

367: FETCH C_Get_Move_Order_Line_ID INTO l_move_order_line_id;
368: IF C_Get_Move_Order_Line_ID%NOTFOUND THEN
369: CLOSE C_Get_Move_Order_Line_ID;
370: fnd_message.set_name ('CSP', 'CSP_PACKLIST_MOVEORDER_ERRORS');
371: fnd_message.set_token ('HEADER_ID', to_char(p_packlist_header_id), TRUE);
372: fnd_msg_pub.add;
373: RAISE EXCP_USER_DEFINED;
374: END IF;
375:

Line 442: fnd_message.set_name ('CSP', 'CSP_INVALID_MO_RECEIPT_TYPE');

438: Rollback to Confirm_Ship_PUB;
439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
440: END IF;
441: ELSE
442: fnd_message.set_name ('CSP', 'CSP_INVALID_MO_RECEIPT_TYPE');
443: fnd_message.set_token ('HEADER_ID', to_char(l_header_id), TRUE);
444: fnd_msg_pub.add;
445: IF C_Get_packlist_lines%ISOPEN THEN
446: CLOSE C_Get_packlist_lines;

Line 443: fnd_message.set_token ('HEADER_ID', to_char(l_header_id), TRUE);

439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
440: END IF;
441: ELSE
442: fnd_message.set_name ('CSP', 'CSP_INVALID_MO_RECEIPT_TYPE');
443: fnd_message.set_token ('HEADER_ID', to_char(l_header_id), TRUE);
444: fnd_msg_pub.add;
445: IF C_Get_packlist_lines%ISOPEN THEN
446: CLOSE C_Get_packlist_lines;
447: END IF;

Line 456: fnd_message.set_name ('CSP', 'CSP_INVALID_MOVEORDER');

452: EXCEPTION
453: WHEN EXCP_NOSAVEPOINT THEN
454: RAISE EXCP_NOSAVEPOINT;
455: WHEN NO_DATA_FOUND THEN
456: fnd_message.set_name ('CSP', 'CSP_INVALID_MOVEORDER');
457: fnd_message.set_token ('HEADER_ID', to_char(l_header_id), TRUE);
458: fnd_msg_pub.add;
459: RAISE EXCP_USER_DEFINED;
460: WHEN EXCP_USER_DEFINED THEN

Line 457: fnd_message.set_token ('HEADER_ID', to_char(l_header_id), TRUE);

453: WHEN EXCP_NOSAVEPOINT THEN
454: RAISE EXCP_NOSAVEPOINT;
455: WHEN NO_DATA_FOUND THEN
456: fnd_message.set_name ('CSP', 'CSP_INVALID_MOVEORDER');
457: fnd_message.set_token ('HEADER_ID', to_char(l_header_id), TRUE);
458: fnd_msg_pub.add;
459: RAISE EXCP_USER_DEFINED;
460: WHEN EXCP_USER_DEFINED THEN
461: RAISE EXCP_USER_DEFINED;

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

459: RAISE EXCP_USER_DEFINED;
460: WHEN EXCP_USER_DEFINED THEN
461: RAISE EXCP_USER_DEFINED;
462: WHEN OTHERS THEN
463: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
464: fnd_message.set_token('SQLEERM', sqlerrm, TRUE);
465: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
466: fnd_msg_pub.add;
467: RAISE EXCP_USER_DEFINED;

Line 464: fnd_message.set_token('SQLEERM', sqlerrm, TRUE);

460: WHEN EXCP_USER_DEFINED THEN
461: RAISE EXCP_USER_DEFINED;
462: WHEN OTHERS THEN
463: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
464: fnd_message.set_token('SQLEERM', sqlerrm, TRUE);
465: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
466: fnd_msg_pub.add;
467: RAISE EXCP_USER_DEFINED;
468:

Line 465: fnd_message.set_token('ROUTINE', l_api_name, TRUE);

461: RAISE EXCP_USER_DEFINED;
462: WHEN OTHERS THEN
463: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
464: fnd_message.set_token('SQLEERM', sqlerrm, TRUE);
465: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
466: fnd_msg_pub.add;
467: RAISE EXCP_USER_DEFINED;
468:
469: END;

Line 476: FND_MESSAGE.SET_NAME ('CSP', 'CSP_INVALID_PACKLIST_HEADER');

472:
473: END LOOP;
474: IF C_Get_packlist_lines%rowcount = 0 THEN
475: CLOSE C_Get_packlist_lines;
476: FND_MESSAGE.SET_NAME ('CSP', 'CSP_INVALID_PACKLIST_HEADER');
477: FND_MESSAGE.SET_TOKEN('HEADER_ID', to_char(p_packlist_header_id), TRUE);
478: FND_MSG_PUB.ADD;
479: RAISE EXCP_USER_DEFINED;
480: END IF;

Line 477: FND_MESSAGE.SET_TOKEN('HEADER_ID', to_char(p_packlist_header_id), TRUE);

473: END LOOP;
474: IF C_Get_packlist_lines%rowcount = 0 THEN
475: CLOSE C_Get_packlist_lines;
476: FND_MESSAGE.SET_NAME ('CSP', 'CSP_INVALID_PACKLIST_HEADER');
477: FND_MESSAGE.SET_TOKEN('HEADER_ID', to_char(p_packlist_header_id), TRUE);
478: FND_MSG_PUB.ADD;
479: RAISE EXCP_USER_DEFINED;
480: END IF;
481:

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

534: ,X_MSG_DATA => X_MSG_DATA
535: ,X_RETURN_STATUS => X_RETURN_STATUS);
536: WHEN OTHERS THEN
537: Rollback to Confirm_Ship_PUB;
538: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
539: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
540: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
541: fnd_msg_pub.add;
542: fnd_msg_pub.count_and_get

Line 539: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);

535: ,X_RETURN_STATUS => X_RETURN_STATUS);
536: WHEN OTHERS THEN
537: Rollback to Confirm_Ship_PUB;
538: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
539: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
540: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
541: fnd_msg_pub.add;
542: fnd_msg_pub.count_and_get
543: ( p_count => x_msg_count

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

536: WHEN OTHERS THEN
537: Rollback to Confirm_Ship_PUB;
538: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
539: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
540: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
541: fnd_msg_pub.add;
542: fnd_msg_pub.count_and_get
543: ( p_count => x_msg_count
544: , p_data => x_msg_data);

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

629: END IF;
630:
631: -- validate p_organization_id
632: IF p_organization_id IS NULL THEN
633: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
634: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);
635: FND_MSG_PUB.ADD;
636: RAISE EXCP_USER_DEFINED;
637: ELSE

Line 634: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);

630:
631: -- validate p_organization_id
632: IF p_organization_id IS NULL THEN
633: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
634: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);
635: FND_MSG_PUB.ADD;
636: RAISE EXCP_USER_DEFINED;
637: ELSE
638: IF p_validation_level = fnd_api.g_valid_level_full THEN

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

641: from mtl_parameters
642: where organization_id = p_organization_id;
643: EXCEPTION
644: WHEN NO_DATA_FOUND THEN
645: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');
646: FND_MSG_PUB.ADD;
647: RAISE EXCP_USER_DEFINED;
648: WHEN OTHERS THEN
649: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

645: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');
646: FND_MSG_PUB.ADD;
647: RAISE EXCP_USER_DEFINED;
648: WHEN OTHERS THEN
649: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
650: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);
651: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
652: fnd_message.set_token('TABLE', 'mtl_parameters', TRUE);
653: FND_MSG_PUB.ADD;

Line 650: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);

646: FND_MSG_PUB.ADD;
647: RAISE EXCP_USER_DEFINED;
648: WHEN OTHERS THEN
649: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
650: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);
651: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
652: fnd_message.set_token('TABLE', 'mtl_parameters', TRUE);
653: FND_MSG_PUB.ADD;
654: RAISE EXCP_USER_DEFINED;

Line 651: fnd_message.set_token('ROUTINE', l_api_name, TRUE);

647: RAISE EXCP_USER_DEFINED;
648: WHEN OTHERS THEN
649: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
650: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);
651: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
652: fnd_message.set_token('TABLE', 'mtl_parameters', TRUE);
653: FND_MSG_PUB.ADD;
654: RAISE EXCP_USER_DEFINED;
655: END;

Line 652: fnd_message.set_token('TABLE', 'mtl_parameters', TRUE);

648: WHEN OTHERS THEN
649: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
650: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);
651: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
652: fnd_message.set_token('TABLE', 'mtl_parameters', TRUE);
653: FND_MSG_PUB.ADD;
654: RAISE EXCP_USER_DEFINED;
655: END;
656: END IF;

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

658: END IF;
659:
660: -- validate the p_packlist_line_id
661: IF p_packlist_line_id IS NULL THEN
662: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
663: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_packlist_line_id', TRUE);
664: FND_MSG_PUB.ADD;
665: RAISE EXCP_USER_DEFINED;
666: ELSE

Line 663: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_packlist_line_id', TRUE);

659:
660: -- validate the p_packlist_line_id
661: IF p_packlist_line_id IS NULL THEN
662: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
663: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_packlist_line_id', TRUE);
664: FND_MSG_PUB.ADD;
665: RAISE EXCP_USER_DEFINED;
666: ELSE
667: IF p_validation_level = fnd_api.g_valid_level_full THEN

Line 675: FND_MESSAGE.SET_NAME ('CSP', 'CSP_INVALID_PACKLIST_LINE');

671: where organization_id = p_organization_id
672: and packlist_line_id = p_packlist_line_id;
673: EXCEPTION
674: WHEN NO_DATA_FOUND THEN
675: FND_MESSAGE.SET_NAME ('CSP', 'CSP_INVALID_PACKLIST_LINE');
676: FND_MSG_PUB.ADD;
677: RAISE EXCP_USER_DEFINED;
678: WHEN OTHERS THEN
679: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

675: FND_MESSAGE.SET_NAME ('CSP', 'CSP_INVALID_PACKLIST_LINE');
676: FND_MSG_PUB.ADD;
677: RAISE EXCP_USER_DEFINED;
678: WHEN OTHERS THEN
679: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
680: fnd_message.set_token('ERR_FIELD', 'p_packlist_line_id', TRUE);
681: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
682: fnd_message.set_token('TABLE', 'csp_packlist_lines', TRUE);
683: fnd_msg_pub.add;

Line 680: fnd_message.set_token('ERR_FIELD', 'p_packlist_line_id', TRUE);

676: FND_MSG_PUB.ADD;
677: RAISE EXCP_USER_DEFINED;
678: WHEN OTHERS THEN
679: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
680: fnd_message.set_token('ERR_FIELD', 'p_packlist_line_id', TRUE);
681: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
682: fnd_message.set_token('TABLE', 'csp_packlist_lines', TRUE);
683: fnd_msg_pub.add;
684: RAISE EXCP_USER_DEFINED;

Line 681: fnd_message.set_token('ROUTINE', l_api_name, TRUE);

677: RAISE EXCP_USER_DEFINED;
678: WHEN OTHERS THEN
679: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
680: fnd_message.set_token('ERR_FIELD', 'p_packlist_line_id', TRUE);
681: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
682: fnd_message.set_token('TABLE', 'csp_packlist_lines', TRUE);
683: fnd_msg_pub.add;
684: RAISE EXCP_USER_DEFINED;
685:

Line 682: fnd_message.set_token('TABLE', 'csp_packlist_lines', TRUE);

678: WHEN OTHERS THEN
679: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
680: fnd_message.set_token('ERR_FIELD', 'p_packlist_line_id', TRUE);
681: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
682: fnd_message.set_token('TABLE', 'csp_packlist_lines', TRUE);
683: fnd_msg_pub.add;
684: RAISE EXCP_USER_DEFINED;
685:
686: END;

Line 697: FND_MESSAGE.SET_NAME ('CSP', 'CSP_INVALID_PACKLIST_LINE');

693: OPEN C_Get_packlist_lines;
694: FETCH C_Get_packlist_lines INTO l_packlist_line_rec;
695: IF C_Get_packlist_lines%NOTFOUND THEN
696: CLOSE C_Get_packlist_lines;
697: FND_MESSAGE.SET_NAME ('CSP', 'CSP_INVALID_PACKLIST_LINE');
698: FND_MSG_PUB.ADD;
699: RAISE EXCP_USER_DEFINED;
700: ELSE
701:

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

756: ,X_MSG_DATA => X_MSG_DATA
757: ,X_RETURN_STATUS => X_RETURN_STATUS);
758: WHEN OTHERS THEN
759: Rollback to Update_Packlist_Sts_Qty_PUB;
760: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
761: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
762: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
763: fnd_msg_pub.add;
764: fnd_msg_pub.count_and_get

Line 761: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);

757: ,X_RETURN_STATUS => X_RETURN_STATUS);
758: WHEN OTHERS THEN
759: Rollback to Update_Packlist_Sts_Qty_PUB;
760: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
761: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
762: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
763: fnd_msg_pub.add;
764: fnd_msg_pub.count_and_get
765: ( p_count => x_msg_count

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

758: WHEN OTHERS THEN
759: Rollback to Update_Packlist_Sts_Qty_PUB;
760: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
761: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
762: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
763: fnd_msg_pub.add;
764: fnd_msg_pub.count_and_get
765: ( p_count => x_msg_count
766: , p_data => x_msg_data);

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

928:
929: IF p_validation_level = fnd_api.g_valid_level_full THEN
930: -- validate the p_organization_id
931: IF p_organization_id IS NULL THEN
932: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
933: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);
934: FND_MSG_PUB.ADD;
935: RAISE EXCP_USER_DEFINED;
936: ELSE

Line 933: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);

929: IF p_validation_level = fnd_api.g_valid_level_full THEN
930: -- validate the p_organization_id
931: IF p_organization_id IS NULL THEN
932: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
933: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);
934: FND_MSG_PUB.ADD;
935: RAISE EXCP_USER_DEFINED;
936: ELSE
937: IF p_validation_level = fnd_api.g_valid_level_full THEN

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

940: from mtl_parameters
941: where organization_id = p_organization_id;
942: EXCEPTION
943: WHEN NO_DATA_FOUND THEN
944: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');
945: FND_MSG_PUB.ADD;
946: RAISE EXCP_USER_DEFINED;
947: WHEN OTHERS THEN
948: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

944: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');
945: FND_MSG_PUB.ADD;
946: RAISE EXCP_USER_DEFINED;
947: WHEN OTHERS THEN
948: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
949: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);
950: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
951: fnd_message.set_token('TABLE', 'mtl_parameters', TRUE);
952: FND_MSG_PUB.ADD;

Line 949: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);

945: FND_MSG_PUB.ADD;
946: RAISE EXCP_USER_DEFINED;
947: WHEN OTHERS THEN
948: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
949: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);
950: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
951: fnd_message.set_token('TABLE', 'mtl_parameters', TRUE);
952: FND_MSG_PUB.ADD;
953: RAISE EXCP_USER_DEFINED;

Line 950: fnd_message.set_token('ROUTINE', l_api_name, TRUE);

946: RAISE EXCP_USER_DEFINED;
947: WHEN OTHERS THEN
948: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
949: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);
950: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
951: fnd_message.set_token('TABLE', 'mtl_parameters', TRUE);
952: FND_MSG_PUB.ADD;
953: RAISE EXCP_USER_DEFINED;
954: END;

Line 951: fnd_message.set_token('TABLE', 'mtl_parameters', TRUE);

947: WHEN OTHERS THEN
948: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
949: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);
950: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
951: fnd_message.set_token('TABLE', 'mtl_parameters', TRUE);
952: FND_MSG_PUB.ADD;
953: RAISE EXCP_USER_DEFINED;
954: END;
955: END IF;

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

956: NULL;
957: END IF;
958:
959: IF p_packlist_header_id IS NULL THEN
960: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
961: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_packlist_header_id', TRUE);
962: FND_MSG_PUB.ADD;
963: RAISE EXCP_USER_DEFINED;
964: ELSE

Line 961: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_packlist_header_id', TRUE);

957: END IF;
958:
959: IF p_packlist_header_id IS NULL THEN
960: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
961: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_packlist_header_id', TRUE);
962: FND_MSG_PUB.ADD;
963: RAISE EXCP_USER_DEFINED;
964: ELSE
965: -- IF p_validation_level = fnd_api.g_valid_level_full THEN

Line 973: fnd_message.set_name ('CSP', 'CSP_INVALID_PACKLIST_HEADER');

969: where organization_id = p_organization_id
970: and packlist_header_id = p_packlist_header_id;
971: EXCEPTION
972: WHEN NO_DATA_FOUND THEN
973: fnd_message.set_name ('CSP', 'CSP_INVALID_PACKLIST_HEADER');
974: fnd_message.set_token ('HEADER_ID', to_char(p_packlist_header_id), TRUE);
975: fnd_msg_pub.add;
976: RAISE EXCP_USER_DEFINED;
977: WHEN OTHERS THEN

Line 974: fnd_message.set_token ('HEADER_ID', to_char(p_packlist_header_id), TRUE);

970: and packlist_header_id = p_packlist_header_id;
971: EXCEPTION
972: WHEN NO_DATA_FOUND THEN
973: fnd_message.set_name ('CSP', 'CSP_INVALID_PACKLIST_HEADER');
974: fnd_message.set_token ('HEADER_ID', to_char(p_packlist_header_id), TRUE);
975: fnd_msg_pub.add;
976: RAISE EXCP_USER_DEFINED;
977: WHEN OTHERS THEN
978: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

974: fnd_message.set_token ('HEADER_ID', to_char(p_packlist_header_id), TRUE);
975: fnd_msg_pub.add;
976: RAISE EXCP_USER_DEFINED;
977: WHEN OTHERS THEN
978: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
979: fnd_message.set_token('ERR_FIELD', 'p_packlist_header_id', TRUE);
980: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
981: fnd_message.set_token('TABLE', 'csp_packlist_headers', TRUE);
982: FND_MSG_PUB.ADD;

Line 979: fnd_message.set_token('ERR_FIELD', 'p_packlist_header_id', TRUE);

975: fnd_msg_pub.add;
976: RAISE EXCP_USER_DEFINED;
977: WHEN OTHERS THEN
978: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
979: fnd_message.set_token('ERR_FIELD', 'p_packlist_header_id', TRUE);
980: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
981: fnd_message.set_token('TABLE', 'csp_packlist_headers', TRUE);
982: FND_MSG_PUB.ADD;
983: RAISE EXCP_USER_DEFINED;

Line 980: fnd_message.set_token('ROUTINE', l_api_name, TRUE);

976: RAISE EXCP_USER_DEFINED;
977: WHEN OTHERS THEN
978: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
979: fnd_message.set_token('ERR_FIELD', 'p_packlist_header_id', TRUE);
980: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
981: fnd_message.set_token('TABLE', 'csp_packlist_headers', TRUE);
982: FND_MSG_PUB.ADD;
983: RAISE EXCP_USER_DEFINED;
984: END;

Line 981: fnd_message.set_token('TABLE', 'csp_packlist_headers', TRUE);

977: WHEN OTHERS THEN
978: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
979: fnd_message.set_token('ERR_FIELD', 'p_packlist_header_id', TRUE);
980: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
981: fnd_message.set_token('TABLE', 'csp_packlist_headers', TRUE);
982: FND_MSG_PUB.ADD;
983: RAISE EXCP_USER_DEFINED;
984: END;
985: --END IF;

Line 994: fnd_message.set_name ('CSP', 'CSP_INVALID_PACKLIST_HEADER');

990: FETCH C_Get_Packlist_Headers INTO l_packlist_headers_rec;
991:
992: IF C_Get_Packlist_Headers%NOTFOUND THEN
993: CLOSE C_Get_Packlist_Headers;
994: fnd_message.set_name ('CSP', 'CSP_INVALID_PACKLIST_HEADER');
995: fnd_message.set_token ('HEADER_ID', to_char(p_packlist_header_id), TRUE);
996: fnd_msg_pub.add;
997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
998: END IF;

Line 995: fnd_message.set_token ('HEADER_ID', to_char(p_packlist_header_id), TRUE);

991:
992: IF C_Get_Packlist_Headers%NOTFOUND THEN
993: CLOSE C_Get_Packlist_Headers;
994: fnd_message.set_name ('CSP', 'CSP_INVALID_PACKLIST_HEADER');
995: fnd_message.set_token ('HEADER_ID', to_char(p_packlist_header_id), TRUE);
996: fnd_msg_pub.add;
997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
998: END IF;
999: CLOSE C_Get_Packlist_Headers;

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

1061: ,X_RETURN_STATUS => X_RETURN_STATUS);
1062:
1063: WHEN OTHERS THEN
1064: Rollback to Update_Packlist_Sts_Qty_PUB;
1065: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1066: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
1067: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
1068: fnd_msg_pub.add;
1069: fnd_msg_pub.count_and_get

Line 1066: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);

1062:
1063: WHEN OTHERS THEN
1064: Rollback to Update_Packlist_Sts_Qty_PUB;
1065: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1066: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
1067: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
1068: fnd_msg_pub.add;
1069: fnd_msg_pub.count_and_get
1070: ( p_count => x_msg_count

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

1063: WHEN OTHERS THEN
1064: Rollback to Update_Packlist_Sts_Qty_PUB;
1065: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1066: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
1067: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
1068: fnd_msg_pub.add;
1069: fnd_msg_pub.count_and_get
1070: ( p_count => x_msg_count
1071: , p_data => x_msg_data);