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_PARTS_REQUIREMENT dependencies on FND_MESSAGE

Line 278: FND_MESSAGE.Set_Name('CSP', 'CSP_NEED_PASSED');

274: x_msg_count => l_msg_count,
275: p_called_from => 'MOBILE'
276: );
277: ELSE
278: FND_MESSAGE.Set_Name('CSP', 'CSP_NEED_PASSED');
279: l_order_msg := FND_MESSAGE.GET;
280: END IF;
281: END IF;
282: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 279: l_order_msg := FND_MESSAGE.GET;

275: p_called_from => 'MOBILE'
276: );
277: ELSE
278: FND_MESSAGE.Set_Name('CSP', 'CSP_NEED_PASSED');
279: l_order_msg := FND_MESSAGE.GET;
280: END IF;
281: END IF;
282: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
283: null; --RAISE FND_API.G_EXC_ERROR;

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

337: FETCH rs_loc_cur into l_header_Rec.ship_to_location_id, l_timezone_id;
338: CLOSE rs_loc_cur;
339: ELSE
340: -- raise error, either ship to location or resource must be specified
341: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
342: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'resource or task assignment or ship to location', FALSE);
343: FND_MSG_PUB.ADD;
344: RAISE EXCP_USER_DEFINED;
345: END If;

Line 342: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'resource or task assignment or ship to location', FALSE);

338: CLOSE rs_loc_cur;
339: ELSE
340: -- raise error, either ship to location or resource must be specified
341: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
342: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'resource or task assignment or ship to location', FALSE);
343: FND_MSG_PUB.ADD;
344: RAISE EXCP_USER_DEFINED;
345: END If;
346: ELSE

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

404: l_rqmt_header_Rec.created_by := nvl(l_user_id, -1);
405: l_rqmt_header_Rec.creation_date := l_today;
406: ELSIF (l_header_rec.operation IN (G_OPR_UPDATE, G_OPR_DELETE)) THEN
407: IF nvl(l_header_rec.requirement_header_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
408: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
409: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_header_rec.requirement_header_id', FALSE);
410: FND_MSG_PUB.ADD;
411: RAISE EXCP_USER_DEFINED;
412: ELSE

Line 409: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_header_rec.requirement_header_id', FALSE);

405: l_rqmt_header_Rec.creation_date := l_today;
406: ELSIF (l_header_rec.operation IN (G_OPR_UPDATE, G_OPR_DELETE)) THEN
407: IF nvl(l_header_rec.requirement_header_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
408: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
409: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_header_rec.requirement_header_id', FALSE);
410: FND_MSG_PUB.ADD;
411: RAISE EXCP_USER_DEFINED;
412: ELSE
413: BEGIN

Line 420: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_HEADER');

416: from csp_requirement_headers
417: where requirement_header_id = l_header_rec.requirement_header_id;
418: EXCEPTION
419: WHEN NO_DATA_FOUND THEN
420: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_HEADER');
421: fnd_message.set_token('HEADER_ID', to_char(l_header_rec.requirement_header_id), FALSE);
422:
423: FND_MSG_PUB.ADD;
424: RAISE EXCP_USER_DEFINED;

Line 421: fnd_message.set_token('HEADER_ID', to_char(l_header_rec.requirement_header_id), FALSE);

417: where requirement_header_id = l_header_rec.requirement_header_id;
418: EXCEPTION
419: WHEN NO_DATA_FOUND THEN
420: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_HEADER');
421: fnd_message.set_token('HEADER_ID', to_char(l_header_rec.requirement_header_id), FALSE);
422:
423: FND_MSG_PUB.ADD;
424: RAISE EXCP_USER_DEFINED;
425: WHEN OTHERS THEN

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

422:
423: FND_MSG_PUB.ADD;
424: RAISE EXCP_USER_DEFINED;
425: WHEN OTHERS THEN
426: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
427: fnd_message.set_token('ERR_FIELD', 'l_header_rec.requirement_header_id', FALSE);
428: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
429: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_HEADERS', FALSE);
430: FND_MSG_PUB.ADD;

Line 427: fnd_message.set_token('ERR_FIELD', 'l_header_rec.requirement_header_id', FALSE);

423: FND_MSG_PUB.ADD;
424: RAISE EXCP_USER_DEFINED;
425: WHEN OTHERS THEN
426: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
427: fnd_message.set_token('ERR_FIELD', 'l_header_rec.requirement_header_id', FALSE);
428: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
429: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_HEADERS', FALSE);
430: FND_MSG_PUB.ADD;
431: RAISE EXCP_USER_DEFINED;

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

424: RAISE EXCP_USER_DEFINED;
425: WHEN OTHERS THEN
426: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
427: fnd_message.set_token('ERR_FIELD', 'l_header_rec.requirement_header_id', FALSE);
428: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
429: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_HEADERS', FALSE);
430: FND_MSG_PUB.ADD;
431: RAISE EXCP_USER_DEFINED;
432: END;

Line 429: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_HEADERS', FALSE);

425: WHEN OTHERS THEN
426: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
427: fnd_message.set_token('ERR_FIELD', 'l_header_rec.requirement_header_id', FALSE);
428: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
429: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_HEADERS', FALSE);
430: FND_MSG_PUB.ADD;
431: RAISE EXCP_USER_DEFINED;
432: END;
433: END IF;

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

481: l_rqmt_line_Rec.creation_date := l_today;
482: ELSIF (l_header_rec.operation IN (G_OPR_UPDATE, G_OPR_DELETE)) THEN
483: IF nvl(l_line_rec.requirement_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
484:
485: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
486: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_line_rec.requirement_line_id', FALSE);
487: FND_MSG_PUB.ADD;
488: RAISE EXCP_USER_DEFINED;
489: ELSE

Line 486: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_line_rec.requirement_line_id', FALSE);

482: ELSIF (l_header_rec.operation IN (G_OPR_UPDATE, G_OPR_DELETE)) THEN
483: IF nvl(l_line_rec.requirement_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
484:
485: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
486: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_line_rec.requirement_line_id', FALSE);
487: FND_MSG_PUB.ADD;
488: RAISE EXCP_USER_DEFINED;
489: ELSE
490: BEGIN

Line 497: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_LINE');

493: from csp_requirement_lines
494: where requirement_line_id = l_line_rec.requirement_line_id;
495: EXCEPTION
496: WHEN NO_DATA_FOUND THEN
497: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_LINE');
498: fnd_message.set_token ('LINE_ID', to_char(l_line_rec.requirement_line_id), FALSE);
499:
500: FND_MSG_PUB.ADD;
501: RAISE EXCP_USER_DEFINED;

Line 498: fnd_message.set_token ('LINE_ID', to_char(l_line_rec.requirement_line_id), FALSE);

494: where requirement_line_id = l_line_rec.requirement_line_id;
495: EXCEPTION
496: WHEN NO_DATA_FOUND THEN
497: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_LINE');
498: fnd_message.set_token ('LINE_ID', to_char(l_line_rec.requirement_line_id), FALSE);
499:
500: FND_MSG_PUB.ADD;
501: RAISE EXCP_USER_DEFINED;
502: WHEN OTHERS THEN

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

499:
500: FND_MSG_PUB.ADD;
501: RAISE EXCP_USER_DEFINED;
502: WHEN OTHERS THEN
503: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
504: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);
505: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
506: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);
507: FND_MSG_PUB.ADD;

Line 504: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);

500: FND_MSG_PUB.ADD;
501: RAISE EXCP_USER_DEFINED;
502: WHEN OTHERS THEN
503: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
504: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);
505: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
506: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);
507: FND_MSG_PUB.ADD;
508: RAISE EXCP_USER_DEFINED;

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

501: RAISE EXCP_USER_DEFINED;
502: WHEN OTHERS THEN
503: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
504: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);
505: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
506: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);
507: FND_MSG_PUB.ADD;
508: RAISE EXCP_USER_DEFINED;
509: END;

Line 506: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);

502: WHEN OTHERS THEN
503: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
504: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);
505: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
506: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);
507: FND_MSG_PUB.ADD;
508: RAISE EXCP_USER_DEFINED;
509: END;
510: END IF;

Line 584: FND_MESSAGE.Set_Name('CSP', 'CSP_REQ_CREATED');

580: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
581: RAISE FND_API.G_EXC_ERROR;
582: ELSE
583: IF l_order_msg IS NOT null THEN
584: FND_MESSAGE.Set_Name('CSP', 'CSP_REQ_CREATED');
585: FND_MESSAGE.Set_Token('REQ_NUMBER',to_char(l_requirement_header_id));
586: x_msg_data := FND_MESSAGE.GET;
587: END IF;
588: END IF;

Line 585: FND_MESSAGE.Set_Token('REQ_NUMBER',to_char(l_requirement_header_id));

581: RAISE FND_API.G_EXC_ERROR;
582: ELSE
583: IF l_order_msg IS NOT null THEN
584: FND_MESSAGE.Set_Name('CSP', 'CSP_REQ_CREATED');
585: FND_MESSAGE.Set_Token('REQ_NUMBER',to_char(l_requirement_header_id));
586: x_msg_data := FND_MESSAGE.GET;
587: END IF;
588: END IF;
589: WHEN OTHERS THEN

Line 586: x_msg_data := FND_MESSAGE.GET;

582: ELSE
583: IF l_order_msg IS NOT null THEN
584: FND_MESSAGE.Set_Name('CSP', 'CSP_REQ_CREATED');
585: FND_MESSAGE.Set_Token('REQ_NUMBER',to_char(l_requirement_header_id));
586: x_msg_data := FND_MESSAGE.GET;
587: END IF;
588: END IF;
589: WHEN OTHERS THEN
590: NULL;

Line 616: FND_MESSAGE.Set_Name('CSP', 'CSP_REQ_CREATED');

612: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
613: RAISE FND_API.G_EXC_ERROR;
614: ELSE
615: IF l_order_msg IS NOT null THEN
616: FND_MESSAGE.Set_Name('CSP', 'CSP_REQ_CREATED');
617: FND_MESSAGE.Set_Token('REQ_NUMBER',to_char(l_requirement_header_id));
618: x_msg_data := FND_MESSAGE.GET;
619: END IF;
620: END IF;

Line 617: FND_MESSAGE.Set_Token('REQ_NUMBER',to_char(l_requirement_header_id));

613: RAISE FND_API.G_EXC_ERROR;
614: ELSE
615: IF l_order_msg IS NOT null THEN
616: FND_MESSAGE.Set_Name('CSP', 'CSP_REQ_CREATED');
617: FND_MESSAGE.Set_Token('REQ_NUMBER',to_char(l_requirement_header_id));
618: x_msg_data := FND_MESSAGE.GET;
619: END IF;
620: END IF;
621: END;

Line 618: x_msg_data := FND_MESSAGE.GET;

614: ELSE
615: IF l_order_msg IS NOT null THEN
616: FND_MESSAGE.Set_Name('CSP', 'CSP_REQ_CREATED');
617: FND_MESSAGE.Set_Token('REQ_NUMBER',to_char(l_requirement_header_id));
618: x_msg_data := FND_MESSAGE.GET;
619: END IF;
620: END IF;
621: END;
622: ELSE

Line 639: FND_MESSAGE.Set_Name('CSP', 'CSP_REQ_CREATED');

635: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
636: RAISE FND_API.G_EXC_ERROR;
637: ELSE
638: IF l_order_msg IS NOT null THEN
639: FND_MESSAGE.Set_Name('CSP', 'CSP_REQ_CREATED');
640: FND_MESSAGE.Set_Token('REQ_NUMBER',to_char(l_requirement_header_id));
641: x_msg_data := FND_MESSAGE.GET;
642: END IF;
643: END IF;

Line 640: FND_MESSAGE.Set_Token('REQ_NUMBER',to_char(l_requirement_header_id));

636: RAISE FND_API.G_EXC_ERROR;
637: ELSE
638: IF l_order_msg IS NOT null THEN
639: FND_MESSAGE.Set_Name('CSP', 'CSP_REQ_CREATED');
640: FND_MESSAGE.Set_Token('REQ_NUMBER',to_char(l_requirement_header_id));
641: x_msg_data := FND_MESSAGE.GET;
642: END IF;
643: END IF;
644: END IF;

Line 641: x_msg_data := FND_MESSAGE.GET;

637: ELSE
638: IF l_order_msg IS NOT null THEN
639: FND_MESSAGE.Set_Name('CSP', 'CSP_REQ_CREATED');
640: FND_MESSAGE.Set_Token('REQ_NUMBER',to_char(l_requirement_header_id));
641: x_msg_data := FND_MESSAGE.GET;
642: END IF;
643: END IF;
644: END IF;
645:

Line 671: FND_MESSAGE.Set_Name('CSP', 'CSP_REQ_UPDATED');

667: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
668: RAISE FND_API.G_EXC_ERROR;
669: ELSE
670: IF x_msg_data IS null and l_order_msg is not null THEN
671: FND_MESSAGE.Set_Name('CSP', 'CSP_REQ_UPDATED');
672: FND_MESSAGE.Set_Token('REQ_NUMBER',to_char(l_requirement_header_id));
673: x_msg_data := FND_MESSAGE.GET;
674: END IF;
675: END IF;

Line 672: FND_MESSAGE.Set_Token('REQ_NUMBER',to_char(l_requirement_header_id));

668: RAISE FND_API.G_EXC_ERROR;
669: ELSE
670: IF x_msg_data IS null and l_order_msg is not null THEN
671: FND_MESSAGE.Set_Name('CSP', 'CSP_REQ_UPDATED');
672: FND_MESSAGE.Set_Token('REQ_NUMBER',to_char(l_requirement_header_id));
673: x_msg_data := FND_MESSAGE.GET;
674: END IF;
675: END IF;
676: FOR I IN 1..x_rqmt_line_tbl.count LOOP

Line 673: x_msg_data := FND_MESSAGE.GET;

669: ELSE
670: IF x_msg_data IS null and l_order_msg is not null THEN
671: FND_MESSAGE.Set_Name('CSP', 'CSP_REQ_UPDATED');
672: FND_MESSAGE.Set_Token('REQ_NUMBER',to_char(l_requirement_header_id));
673: x_msg_data := FND_MESSAGE.GET;
674: END IF;
675: END IF;
676: FOR I IN 1..x_rqmt_line_tbl.count LOOP
677: IF x_rqmt_line_tbl(I).order_line_id IS NOT NULL THEN

Line 758: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

754: ,X_MSG_DATA => X_MSG_DATA
755: ,X_RETURN_STATUS => X_RETURN_STATUS);
756: WHEN OTHERS THEN
757: Rollback to process_requirement_pub;
758: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
759: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
760: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
761: FND_MSG_PUB.ADD;
762: fnd_msg_pub.count_and_get

Line 759: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);

755: ,X_RETURN_STATUS => X_RETURN_STATUS);
756: WHEN OTHERS THEN
757: Rollback to process_requirement_pub;
758: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
759: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
760: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
761: FND_MSG_PUB.ADD;
762: fnd_msg_pub.count_and_get
763: ( p_count => x_msg_count

Line 760: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);

756: WHEN OTHERS THEN
757: Rollback to process_requirement_pub;
758: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
759: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
760: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
761: FND_MSG_PUB.ADD;
762: fnd_msg_pub.count_and_get
763: ( p_count => x_msg_count
764: , p_data => x_msg_data);

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

942: l_line_rec := l_line_tbl(I);
943:
944: IF nvl(l_line_rec.requirement_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
945:
946: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
947: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_line_rec.requirement_line_id', FALSE);
948:
949: FND_MSG_PUB.ADD;
950: RAISE EXCP_USER_DEFINED;

Line 947: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_line_rec.requirement_line_id', FALSE);

943:
944: IF nvl(l_line_rec.requirement_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
945:
946: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
947: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_line_rec.requirement_line_id', FALSE);
948:
949: FND_MSG_PUB.ADD;
950: RAISE EXCP_USER_DEFINED;
951: ELSE

Line 959: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_LINE');

955: from csp_requirement_lines
956: where requirement_line_id = l_line_rec.requirement_line_id;
957: EXCEPTION
958: WHEN NO_DATA_FOUND THEN
959: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_LINE');
960: fnd_message.set_token ('LINE_ID', to_char(l_line_rec.requirement_line_id), FALSE);
961: FND_MSG_PUB.ADD;
962: RAISE EXCP_USER_DEFINED;
963: WHEN OTHERS THEN

Line 960: fnd_message.set_token ('LINE_ID', to_char(l_line_rec.requirement_line_id), FALSE);

956: where requirement_line_id = l_line_rec.requirement_line_id;
957: EXCEPTION
958: WHEN NO_DATA_FOUND THEN
959: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_LINE');
960: fnd_message.set_token ('LINE_ID', to_char(l_line_rec.requirement_line_id), FALSE);
961: FND_MSG_PUB.ADD;
962: RAISE EXCP_USER_DEFINED;
963: WHEN OTHERS THEN
964: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

960: fnd_message.set_token ('LINE_ID', to_char(l_line_rec.requirement_line_id), FALSE);
961: FND_MSG_PUB.ADD;
962: RAISE EXCP_USER_DEFINED;
963: WHEN OTHERS THEN
964: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
965: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);
966: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
967: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);
968: FND_MSG_PUB.ADD;

Line 965: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);

961: FND_MSG_PUB.ADD;
962: RAISE EXCP_USER_DEFINED;
963: WHEN OTHERS THEN
964: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
965: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);
966: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
967: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);
968: FND_MSG_PUB.ADD;
969: RAISE EXCP_USER_DEFINED;

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

962: RAISE EXCP_USER_DEFINED;
963: WHEN OTHERS THEN
964: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
965: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);
966: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
967: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);
968: FND_MSG_PUB.ADD;
969: RAISE EXCP_USER_DEFINED;
970: END;

Line 967: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);

963: WHEN OTHERS THEN
964: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
965: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);
966: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
967: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);
968: FND_MSG_PUB.ADD;
969: RAISE EXCP_USER_DEFINED;
970: END;
971: END IF;

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

1008: l_line_rec := l_po_line_tbl(I);
1009:
1010: IF nvl(l_line_rec.requirement_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
1011:
1012: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
1013: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_line_rec.requirement_line_id', FALSE);
1014:
1015: FND_MSG_PUB.ADD;
1016: RAISE EXCP_USER_DEFINED;

Line 1013: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_line_rec.requirement_line_id', FALSE);

1009:
1010: IF nvl(l_line_rec.requirement_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
1011:
1012: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
1013: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_line_rec.requirement_line_id', FALSE);
1014:
1015: FND_MSG_PUB.ADD;
1016: RAISE EXCP_USER_DEFINED;
1017: ELSE

Line 1025: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_LINE');

1021: from csp_requirement_lines
1022: where requirement_line_id = l_line_rec.requirement_line_id;
1023: EXCEPTION
1024: WHEN NO_DATA_FOUND THEN
1025: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_LINE');
1026: fnd_message.set_token ('LINE_ID', to_char(l_line_rec.requirement_line_id), FALSE);
1027: FND_MSG_PUB.ADD;
1028: RAISE EXCP_USER_DEFINED;
1029: WHEN OTHERS THEN

Line 1026: fnd_message.set_token ('LINE_ID', to_char(l_line_rec.requirement_line_id), FALSE);

1022: where requirement_line_id = l_line_rec.requirement_line_id;
1023: EXCEPTION
1024: WHEN NO_DATA_FOUND THEN
1025: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_LINE');
1026: fnd_message.set_token ('LINE_ID', to_char(l_line_rec.requirement_line_id), FALSE);
1027: FND_MSG_PUB.ADD;
1028: RAISE EXCP_USER_DEFINED;
1029: WHEN OTHERS THEN
1030: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

1026: fnd_message.set_token ('LINE_ID', to_char(l_line_rec.requirement_line_id), FALSE);
1027: FND_MSG_PUB.ADD;
1028: RAISE EXCP_USER_DEFINED;
1029: WHEN OTHERS THEN
1030: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1031: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);
1032: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
1033: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);
1034: FND_MSG_PUB.ADD;

Line 1031: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);

1027: FND_MSG_PUB.ADD;
1028: RAISE EXCP_USER_DEFINED;
1029: WHEN OTHERS THEN
1030: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1031: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);
1032: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
1033: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);
1034: FND_MSG_PUB.ADD;
1035: RAISE EXCP_USER_DEFINED;

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

1028: RAISE EXCP_USER_DEFINED;
1029: WHEN OTHERS THEN
1030: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1031: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);
1032: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
1033: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);
1034: FND_MSG_PUB.ADD;
1035: RAISE EXCP_USER_DEFINED;
1036: END;

Line 1033: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);

1029: WHEN OTHERS THEN
1030: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1031: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);
1032: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
1033: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);
1034: FND_MSG_PUB.ADD;
1035: RAISE EXCP_USER_DEFINED;
1036: END;
1037: END IF;

Line 1099: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

1095: ,X_MSG_DATA => X_MSG_DATA
1096: ,X_RETURN_STATUS => X_RETURN_STATUS);
1097: WHEN OTHERS THEN
1098: Rollback to csptrreq_fm_order_PUB;
1099: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1100: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
1101: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
1102: FND_MSG_PUB.ADD;
1103: fnd_msg_pub.count_and_get

Line 1100: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);

1096: ,X_RETURN_STATUS => X_RETURN_STATUS);
1097: WHEN OTHERS THEN
1098: Rollback to csptrreq_fm_order_PUB;
1099: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1100: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
1101: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
1102: FND_MSG_PUB.ADD;
1103: fnd_msg_pub.count_and_get
1104: ( p_count => x_msg_count

Line 1101: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);

1097: WHEN OTHERS THEN
1098: Rollback to csptrreq_fm_order_PUB;
1099: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1100: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
1101: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
1102: FND_MSG_PUB.ADD;
1103: fnd_msg_pub.count_and_get
1104: ( p_count => x_msg_count
1105: , p_data => x_msg_data);

Line 1323: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

1319: ,X_MSG_DATA => X_MSG_DATA
1320: ,X_RETURN_STATUS => X_RETURN_STATUS);
1321: WHEN OTHERS THEN
1322: Rollback to csptrreq_fm_order_PUB;
1323: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1324: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
1325: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
1326: FND_MSG_PUB.ADD;
1327: fnd_msg_pub.count_and_get

Line 1324: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);

1320: ,X_RETURN_STATUS => X_RETURN_STATUS);
1321: WHEN OTHERS THEN
1322: Rollback to csptrreq_fm_order_PUB;
1323: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1324: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
1325: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
1326: FND_MSG_PUB.ADD;
1327: fnd_msg_pub.count_and_get
1328: ( p_count => x_msg_count

Line 1325: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);

1321: WHEN OTHERS THEN
1322: Rollback to csptrreq_fm_order_PUB;
1323: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1324: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
1325: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
1326: FND_MSG_PUB.ADD;
1327: fnd_msg_pub.count_and_get
1328: ( p_count => x_msg_count
1329: , p_data => x_msg_data);

Line 1374: FND_MESSAGE.SET_NAME ('CSP', 'CSP_RQMT_LINE_DELETE_ERROR');

1370: WHERE crl.requirement_header_id = p_header_id
1371: AND crl.requirement_line_id = crld.requirement_line_id;
1372:
1373: IF l_count > 0 THEN
1374: FND_MESSAGE.SET_NAME ('CSP', 'CSP_RQMT_LINE_DELETE_ERROR');
1375: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_header_id', FALSE);
1376: FND_MSG_PUB.ADD;
1377: RAISE EXCP_USER_DEFINED;
1378: ELSE

Line 1375: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_header_id', FALSE);

1371: AND crl.requirement_line_id = crld.requirement_line_id;
1372:
1373: IF l_count > 0 THEN
1374: FND_MESSAGE.SET_NAME ('CSP', 'CSP_RQMT_LINE_DELETE_ERROR');
1375: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_header_id', FALSE);
1376: FND_MSG_PUB.ADD;
1377: RAISE EXCP_USER_DEFINED;
1378: ELSE
1379: DELETE FROM csp_requirement_lines

Line 1419: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

1415: ,X_MSG_DATA => X_MSG_DATA
1416: ,X_RETURN_STATUS => X_RETURN_STATUS);
1417: WHEN OTHERS THEN
1418: Rollback to delete_rqmt_header_PUB;
1419: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1420: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
1421: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
1422: FND_MSG_PUB.ADD;
1423: fnd_msg_pub.count_and_get

Line 1420: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);

1416: ,X_RETURN_STATUS => X_RETURN_STATUS);
1417: WHEN OTHERS THEN
1418: Rollback to delete_rqmt_header_PUB;
1419: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1420: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
1421: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
1422: FND_MSG_PUB.ADD;
1423: fnd_msg_pub.count_and_get
1424: ( p_count => x_msg_count

Line 1421: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);

1417: WHEN OTHERS THEN
1418: Rollback to delete_rqmt_header_PUB;
1419: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1420: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
1421: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
1422: FND_MSG_PUB.ADD;
1423: fnd_msg_pub.count_and_get
1424: ( p_count => x_msg_count
1425: , p_data => x_msg_data);

Line 1532: FND_MESSAGE.SET_NAME ('CSP', 'CSP_RS_USER_NOT_DEFINED');

1528: FROM jtf_rs_resource_extns
1529: WHERE user_id = l_user_id;
1530: EXCEPTION
1531: WHEN no_Data_found THEN
1532: FND_MESSAGE.SET_NAME ('CSP', 'CSP_RS_USER_NOT_DEFINED');
1533: FND_MSG_PUB.ADD;
1534: RAISE EXCP_USER_DEFINED;
1535: END;
1536:

Line 1544: FND_MESSAGE.SET_NAME ('CSP', 'CSP_INVALID_RES_ID_TYPE');

1540: FROM jtf_rs_all_resources_vl
1541: WHERE resource_id = l_header_rec.resource_id;
1542: EXCEPTION
1543: WHEN no_Data_found THEN
1544: FND_MESSAGE.SET_NAME ('CSP', 'CSP_INVALID_RES_ID_TYPE');
1545: FND_MSG_PUB.ADD;
1546: RAISE EXCP_USER_DEFINED;
1547: END;
1548: */

Line 1562: FND_MESSAGE.SET_NAME ('CSP', 'CSP_SCH_DEFAULT_SUBINV');

1558: AND default_code = 'IN';
1559: EXCEPTION
1560: WHEN no_Data_found THEN
1561:
1562: FND_MESSAGE.SET_NAME ('CSP', 'CSP_SCH_DEFAULT_SUBINV');
1563: FND_MESSAGE.SET_TOKEN('RESOURCE_TYPE', l_header_rec.resource_type);
1564: FND_MESSAGE.SET_TOKEN('RESOURCE_NAME', l_resource_name);
1565: FND_MSG_PUB.ADD;
1566: RAISE EXCP_USER_DEFINED;

Line 1563: FND_MESSAGE.SET_TOKEN('RESOURCE_TYPE', l_header_rec.resource_type);

1559: EXCEPTION
1560: WHEN no_Data_found THEN
1561:
1562: FND_MESSAGE.SET_NAME ('CSP', 'CSP_SCH_DEFAULT_SUBINV');
1563: FND_MESSAGE.SET_TOKEN('RESOURCE_TYPE', l_header_rec.resource_type);
1564: FND_MESSAGE.SET_TOKEN('RESOURCE_NAME', l_resource_name);
1565: FND_MSG_PUB.ADD;
1566: RAISE EXCP_USER_DEFINED;
1567: WHEN TOO_MANY_ROWS THEN

Line 1564: FND_MESSAGE.SET_TOKEN('RESOURCE_NAME', l_resource_name);

1560: WHEN no_Data_found THEN
1561:
1562: FND_MESSAGE.SET_NAME ('CSP', 'CSP_SCH_DEFAULT_SUBINV');
1563: FND_MESSAGE.SET_TOKEN('RESOURCE_TYPE', l_header_rec.resource_type);
1564: FND_MESSAGE.SET_TOKEN('RESOURCE_NAME', l_resource_name);
1565: FND_MSG_PUB.ADD;
1566: RAISE EXCP_USER_DEFINED;
1567: WHEN TOO_MANY_ROWS THEN
1568:

Line 1569: FND_MESSAGE.SET_NAME ('CSP', 'CSP_ONE_DEFAULT_IN_ALLOWED');

1565: FND_MSG_PUB.ADD;
1566: RAISE EXCP_USER_DEFINED;
1567: WHEN TOO_MANY_ROWS THEN
1568:
1569: FND_MESSAGE.SET_NAME ('CSP', 'CSP_ONE_DEFAULT_IN_ALLOWED');
1570: FND_MSG_PUB.ADD;
1571: RAISE EXCP_USER_DEFINED;
1572: END;
1573:

Line 1583: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETER');

1579: WHERE task_id = l_header_rec.task_id;
1580: EXCEPTION
1581: WHEN NO_DATA_FOUND THEN
1582:
1583: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETER');
1584: FND_MESSAGE.SET_TOKEN('PARAMETER', 'Service Request');
1585: FND_MSG_PUB.ADD;
1586: RAISE EXCP_USER_DEFINED;
1587: END;

Line 1584: FND_MESSAGE.SET_TOKEN('PARAMETER', 'Service Request');

1580: EXCEPTION
1581: WHEN NO_DATA_FOUND THEN
1582:
1583: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETER');
1584: FND_MESSAGE.SET_TOKEN('PARAMETER', 'Service Request');
1585: FND_MSG_PUB.ADD;
1586: RAISE EXCP_USER_DEFINED;
1587: END;
1588: END IF;

Line 1681: --FND_MESSAGE.SET_NAME('CSP', 'CSP_TASK_RQMT_EXISTS');

1677: WHERE task_id = l_header_rec.task_id;
1678:
1679: IF (l_requirement_header_id IS NOT NULL) THEN
1680: Rollback to save_rqmt_line_PUB;
1681: --FND_MESSAGE.SET_NAME('CSP', 'CSP_TASK_RQMT_EXISTS');
1682: --FND_MSG_PUB.ADD;
1683: --fnd_msg_pub.count_and_get
1684: -- ( p_count => x_msg_count
1685: -- , p_data => x_msg_data);

Line 1686: x_msg_data := fnd_message.get_string('CSP', 'CSP_TASK_RQMT_EXISTS');

1682: --FND_MSG_PUB.ADD;
1683: --fnd_msg_pub.count_and_get
1684: -- ( p_count => x_msg_count
1685: -- , p_data => x_msg_data);
1686: x_msg_data := fnd_message.get_string('CSP', 'CSP_TASK_RQMT_EXISTS');
1687: x_return_status := 'E';
1688: return;
1689: END IF;
1690: EXCEPTION

Line 1747: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_HEADER');

1743: from csp_requirement_headers
1744: where requirement_header_id = l_header_rec.requirement_header_id;
1745: EXCEPTION
1746: WHEN NO_DATA_FOUND THEN
1747: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_HEADER');
1748: fnd_message.set_token('HEADER_ID', to_char(l_header_rec.requirement_header_id), FALSE);
1749: FND_MSG_PUB.ADD;
1750: RAISE EXCP_USER_DEFINED;
1751: WHEN OTHERS THEN

Line 1748: fnd_message.set_token('HEADER_ID', to_char(l_header_rec.requirement_header_id), FALSE);

1744: where requirement_header_id = l_header_rec.requirement_header_id;
1745: EXCEPTION
1746: WHEN NO_DATA_FOUND THEN
1747: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_HEADER');
1748: fnd_message.set_token('HEADER_ID', to_char(l_header_rec.requirement_header_id), FALSE);
1749: FND_MSG_PUB.ADD;
1750: RAISE EXCP_USER_DEFINED;
1751: WHEN OTHERS THEN
1752: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

1748: fnd_message.set_token('HEADER_ID', to_char(l_header_rec.requirement_header_id), FALSE);
1749: FND_MSG_PUB.ADD;
1750: RAISE EXCP_USER_DEFINED;
1751: WHEN OTHERS THEN
1752: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1753: fnd_message.set_token('ERR_FIELD', 'l_header_rec.requirement_header_id', FALSE);
1754: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
1755: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_HEADERS', FALSE);
1756: FND_MSG_PUB.ADD;

Line 1753: fnd_message.set_token('ERR_FIELD', 'l_header_rec.requirement_header_id', FALSE);

1749: FND_MSG_PUB.ADD;
1750: RAISE EXCP_USER_DEFINED;
1751: WHEN OTHERS THEN
1752: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1753: fnd_message.set_token('ERR_FIELD', 'l_header_rec.requirement_header_id', FALSE);
1754: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
1755: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_HEADERS', FALSE);
1756: FND_MSG_PUB.ADD;
1757: RAISE EXCP_USER_DEFINED;

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

1750: RAISE EXCP_USER_DEFINED;
1751: WHEN OTHERS THEN
1752: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1753: fnd_message.set_token('ERR_FIELD', 'l_header_rec.requirement_header_id', FALSE);
1754: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
1755: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_HEADERS', FALSE);
1756: FND_MSG_PUB.ADD;
1757: RAISE EXCP_USER_DEFINED;
1758: END;

Line 1755: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_HEADERS', FALSE);

1751: WHEN OTHERS THEN
1752: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1753: fnd_message.set_token('ERR_FIELD', 'l_header_rec.requirement_header_id', FALSE);
1754: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
1755: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_HEADERS', FALSE);
1756: FND_MSG_PUB.ADD;
1757: RAISE EXCP_USER_DEFINED;
1758: END;
1759:

Line 1802: fnd_message.set_name('CSP', 'CSP_DUPLICATE_RQMT_LINE');

1798: into l_count
1799: from csp_requirement_lines
1800: where requirement_line_id = l_rqmt_line_rec.requirement_line_id;
1801: IF l_count > 0 THEN
1802: fnd_message.set_name('CSP', 'CSP_DUPLICATE_RQMT_LINE');
1803: FND_MSG_PUB.ADD;
1804: RAISE EXCP_USER_DEFINED;
1805: END IF;
1806: EXCEPTION

Line 1908: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

1904: ,X_MSG_DATA => X_MSG_DATA
1905: ,X_RETURN_STATUS => X_RETURN_STATUS);
1906: WHEN OTHERS THEN
1907: Rollback to save_rqmt_line_PUB;
1908: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1909: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
1910: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
1911: FND_MSG_PUB.ADD;
1912: fnd_msg_pub.count_and_get

Line 1909: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);

1905: ,X_RETURN_STATUS => X_RETURN_STATUS);
1906: WHEN OTHERS THEN
1907: Rollback to save_rqmt_line_PUB;
1908: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1909: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
1910: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
1911: FND_MSG_PUB.ADD;
1912: fnd_msg_pub.count_and_get
1913: ( p_count => x_msg_count

Line 1910: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);

1906: WHEN OTHERS THEN
1907: Rollback to save_rqmt_line_PUB;
1908: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1909: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
1910: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
1911: FND_MSG_PUB.ADD;
1912: fnd_msg_pub.count_and_get
1913: ( p_count => x_msg_count
1914: , p_data => x_msg_data);

Line 1984: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

1980: ,X_MSG_DATA => X_MSG_DATA
1981: ,X_RETURN_STATUS => X_RETURN_STATUS);
1982: WHEN OTHERS THEN
1983: Rollback to delete_rqmt_line_PUB;
1984: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1985: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
1986: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
1987: FND_MSG_PUB.ADD;
1988: fnd_msg_pub.count_and_get

Line 1985: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);

1981: ,X_RETURN_STATUS => X_RETURN_STATUS);
1982: WHEN OTHERS THEN
1983: Rollback to delete_rqmt_line_PUB;
1984: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1985: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
1986: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
1987: FND_MSG_PUB.ADD;
1988: fnd_msg_pub.count_and_get
1989: ( p_count => x_msg_count

Line 1986: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);

1982: WHEN OTHERS THEN
1983: Rollback to delete_rqmt_line_PUB;
1984: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1985: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
1986: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
1987: FND_MSG_PUB.ADD;
1988: fnd_msg_pub.count_and_get
1989: ( p_count => x_msg_count
1990: , p_data => x_msg_data);

Line 2079: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_HEADER');

2075: WHERE requirement_header_id = p_header_id;
2076:
2077: EXCEPTION
2078: WHEN no_data_found THEN
2079: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_HEADER');
2080: fnd_message.set_token('HEADER_ID', to_char(p_header_id), FALSE);
2081: FND_MSG_PUB.ADD;
2082: RAISE EXCP_USER_DEFINED;
2083: END;

Line 2080: fnd_message.set_token('HEADER_ID', to_char(p_header_id), FALSE);

2076:
2077: EXCEPTION
2078: WHEN no_data_found THEN
2079: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_HEADER');
2080: fnd_message.set_token('HEADER_ID', to_char(p_header_id), FALSE);
2081: FND_MSG_PUB.ADD;
2082: RAISE EXCP_USER_DEFINED;
2083: END;
2084:

Line 2236: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

2232: ,X_MSG_DATA => X_MSG_DATA
2233: ,X_RETURN_STATUS => X_RETURN_STATUS);
2234: WHEN OTHERS THEN
2235: Rollback to check_Availability_pub;
2236: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2237: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
2238: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
2239: FND_MSG_PUB.ADD;
2240: fnd_msg_pub.count_and_get

Line 2237: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);

2233: ,X_RETURN_STATUS => X_RETURN_STATUS);
2234: WHEN OTHERS THEN
2235: Rollback to check_Availability_pub;
2236: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2237: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
2238: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
2239: FND_MSG_PUB.ADD;
2240: fnd_msg_pub.count_and_get
2241: ( p_count => x_msg_count

Line 2238: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);

2234: WHEN OTHERS THEN
2235: Rollback to check_Availability_pub;
2236: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2237: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
2238: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
2239: FND_MSG_PUB.ADD;
2240: fnd_msg_pub.count_and_get
2241: ( p_count => x_msg_count
2242: , p_data => x_msg_data);

Line 2384: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_HEADER');

2380: end if;
2381:
2382: EXCEPTION
2383: WHEN no_data_found THEN
2384: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_HEADER');
2385: fnd_message.set_token('HEADER_ID', to_char(p_header_id), FALSE);
2386: FND_MSG_PUB.ADD;
2387: RAISE EXCP_USER_DEFINED;
2388: END;

Line 2385: fnd_message.set_token('HEADER_ID', to_char(p_header_id), FALSE);

2381:
2382: EXCEPTION
2383: WHEN no_data_found THEN
2384: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_HEADER');
2385: fnd_message.set_token('HEADER_ID', to_char(p_header_id), FALSE);
2386: FND_MSG_PUB.ADD;
2387: RAISE EXCP_USER_DEFINED;
2388: END;
2389:

Line 2424: fnd_message.set_name('CSP', 'CSP_NULL_SRC_ORGN');

2420: end if;
2421:
2422: EXIT WHEN rqmt_line_cur%NOTFOUND;
2423: IF (l_line_rec.sourced_From = 'IO' and l_line_rec.source_organization_id IS NULL) THEN
2424: fnd_message.set_name('CSP', 'CSP_NULL_SRC_ORGN');
2425: fnd_msg_pub.add;
2426: RAISE EXCP_USER_DEFINED;
2427: END If;
2428: l_line_rec.ordered_quantity := l_line_Rec.quantity;

Line 2617: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

2613: ,X_MSG_DATA => X_MSG_DATA
2614: ,X_RETURN_STATUS => X_RETURN_STATUS);
2615: WHEN OTHERS THEN
2616: Rollback to create_order_PUB;
2617: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2618: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
2619: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
2620: FND_MSG_PUB.ADD;
2621: fnd_msg_pub.count_and_get

Line 2618: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);

2614: ,X_RETURN_STATUS => X_RETURN_STATUS);
2615: WHEN OTHERS THEN
2616: Rollback to create_order_PUB;
2617: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2618: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
2619: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
2620: FND_MSG_PUB.ADD;
2621: fnd_msg_pub.count_and_get
2622: ( p_count => x_msg_count

Line 2619: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);

2615: WHEN OTHERS THEN
2616: Rollback to create_order_PUB;
2617: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2618: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
2619: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
2620: FND_MSG_PUB.ADD;
2621: fnd_msg_pub.count_and_get
2622: ( p_count => x_msg_count
2623: , p_data => x_msg_data);