DBA Data[Home] [Help]

APPS.CSP_PARTS_REQUIREMENT dependencies on FND_MESSAGE

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

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

Line 282: l_order_msg := FND_MESSAGE.GET;

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

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

343: FETCH rs_loc_cur into l_header_Rec.ship_to_location_id, l_timezone_id;
344: CLOSE rs_loc_cur;
345: ELSE
346: -- raise error, either ship to location or resource must be specified
347: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
348: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'resource or task assignment or ship to location', FALSE);
349: FND_MSG_PUB.ADD;
350: RAISE EXCP_USER_DEFINED;
351: END If;

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

344: CLOSE rs_loc_cur;
345: ELSE
346: -- raise error, either ship to location or resource must be specified
347: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
348: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'resource or task assignment or ship to location', FALSE);
349: FND_MSG_PUB.ADD;
350: RAISE EXCP_USER_DEFINED;
351: END If;
352: ELSE

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

410: l_rqmt_header_Rec.created_by := nvl(l_user_id, -1);
411: l_rqmt_header_Rec.creation_date := l_today;
412: ELSIF (l_header_rec.operation IN (G_OPR_UPDATE, G_OPR_DELETE)) THEN
413: IF nvl(l_header_rec.requirement_header_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
414: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
415: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_header_rec.requirement_header_id', FALSE);
416: FND_MSG_PUB.ADD;
417: RAISE EXCP_USER_DEFINED;
418: ELSE

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

411: l_rqmt_header_Rec.creation_date := l_today;
412: ELSIF (l_header_rec.operation IN (G_OPR_UPDATE, G_OPR_DELETE)) THEN
413: IF nvl(l_header_rec.requirement_header_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
414: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
415: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_header_rec.requirement_header_id', FALSE);
416: FND_MSG_PUB.ADD;
417: RAISE EXCP_USER_DEFINED;
418: ELSE
419: BEGIN

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

422: from csp_requirement_headers
423: where requirement_header_id = l_header_rec.requirement_header_id;
424: EXCEPTION
425: WHEN NO_DATA_FOUND THEN
426: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_HEADER');
427: fnd_message.set_token('HEADER_ID', to_char(l_header_rec.requirement_header_id), FALSE);
428:
429: FND_MSG_PUB.ADD;
430: RAISE EXCP_USER_DEFINED;

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

423: where requirement_header_id = l_header_rec.requirement_header_id;
424: EXCEPTION
425: WHEN NO_DATA_FOUND THEN
426: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_HEADER');
427: fnd_message.set_token('HEADER_ID', to_char(l_header_rec.requirement_header_id), FALSE);
428:
429: FND_MSG_PUB.ADD;
430: RAISE EXCP_USER_DEFINED;
431: WHEN OTHERS THEN

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

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

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

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

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

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

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

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

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

475:
476: if (l_header_Rec.task_assignment_id IS NULL)
477: and (l_header_Rec.resource_id is null
478: or l_header_rec.resource_type is null) then
479: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
480: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_header_Rec.resource_id', FALSE);
481: FND_MSG_PUB.ADD;
482: RAISE EXCP_USER_DEFINED;
483: end if;

Line 480: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_header_Rec.resource_id', FALSE);

476: if (l_header_Rec.task_assignment_id IS NULL)
477: and (l_header_Rec.resource_id is null
478: or l_header_rec.resource_type is null) then
479: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
480: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_header_Rec.resource_id', FALSE);
481: FND_MSG_PUB.ADD;
482: RAISE EXCP_USER_DEFINED;
483: end if;
484:

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

496: l_rqmt_line_Rec.creation_date := l_today;
497: ELSIF (l_header_rec.operation IN (G_OPR_UPDATE, G_OPR_DELETE)) THEN
498: IF nvl(l_line_rec.requirement_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
499:
500: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
501: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_line_rec.requirement_line_id', FALSE);
502: FND_MSG_PUB.ADD;
503: RAISE EXCP_USER_DEFINED;
504: ELSE

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

497: ELSIF (l_header_rec.operation IN (G_OPR_UPDATE, G_OPR_DELETE)) THEN
498: IF nvl(l_line_rec.requirement_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
499:
500: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
501: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_line_rec.requirement_line_id', FALSE);
502: FND_MSG_PUB.ADD;
503: RAISE EXCP_USER_DEFINED;
504: ELSE
505: BEGIN

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

508: from csp_requirement_lines
509: where requirement_line_id = l_line_rec.requirement_line_id;
510: EXCEPTION
511: WHEN NO_DATA_FOUND THEN
512: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_LINE');
513: fnd_message.set_token ('LINE_ID', to_char(l_line_rec.requirement_line_id), FALSE);
514:
515: FND_MSG_PUB.ADD;
516: RAISE EXCP_USER_DEFINED;

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

509: where requirement_line_id = l_line_rec.requirement_line_id;
510: EXCEPTION
511: WHEN NO_DATA_FOUND THEN
512: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_LINE');
513: fnd_message.set_token ('LINE_ID', to_char(l_line_rec.requirement_line_id), FALSE);
514:
515: FND_MSG_PUB.ADD;
516: RAISE EXCP_USER_DEFINED;
517: WHEN OTHERS THEN

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

514:
515: FND_MSG_PUB.ADD;
516: RAISE EXCP_USER_DEFINED;
517: WHEN OTHERS THEN
518: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
519: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);
520: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
521: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);
522: FND_MSG_PUB.ADD;

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

515: FND_MSG_PUB.ADD;
516: RAISE EXCP_USER_DEFINED;
517: WHEN OTHERS THEN
518: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
519: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);
520: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
521: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);
522: FND_MSG_PUB.ADD;
523: RAISE EXCP_USER_DEFINED;

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

516: RAISE EXCP_USER_DEFINED;
517: WHEN OTHERS THEN
518: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
519: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);
520: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
521: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);
522: FND_MSG_PUB.ADD;
523: RAISE EXCP_USER_DEFINED;
524: END;

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

517: WHEN OTHERS THEN
518: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
519: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);
520: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
521: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);
522: FND_MSG_PUB.ADD;
523: RAISE EXCP_USER_DEFINED;
524: END;
525: END IF;

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

595: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
596: RAISE FND_API.G_EXC_ERROR;
597: ELSE
598: IF l_order_msg IS NOT null THEN
599: FND_MESSAGE.Set_Name('CSP', 'CSP_REQ_CREATED');
600: FND_MESSAGE.Set_Token('REQ_NUMBER',to_char(l_requirement_header_id));
601: x_msg_data := FND_MESSAGE.GET;
602: END IF;
603: END IF;

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

596: RAISE FND_API.G_EXC_ERROR;
597: ELSE
598: IF l_order_msg IS NOT null THEN
599: FND_MESSAGE.Set_Name('CSP', 'CSP_REQ_CREATED');
600: FND_MESSAGE.Set_Token('REQ_NUMBER',to_char(l_requirement_header_id));
601: x_msg_data := FND_MESSAGE.GET;
602: END IF;
603: END IF;
604: WHEN OTHERS THEN

Line 601: x_msg_data := FND_MESSAGE.GET;

597: ELSE
598: IF l_order_msg IS NOT null THEN
599: FND_MESSAGE.Set_Name('CSP', 'CSP_REQ_CREATED');
600: FND_MESSAGE.Set_Token('REQ_NUMBER',to_char(l_requirement_header_id));
601: x_msg_data := FND_MESSAGE.GET;
602: END IF;
603: END IF;
604: WHEN OTHERS THEN
605: NULL;

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

627: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
628: RAISE FND_API.G_EXC_ERROR;
629: ELSE
630: IF l_order_msg IS NOT null THEN
631: FND_MESSAGE.Set_Name('CSP', 'CSP_REQ_CREATED');
632: FND_MESSAGE.Set_Token('REQ_NUMBER',to_char(l_requirement_header_id));
633: x_msg_data := FND_MESSAGE.GET;
634: END IF;
635: END IF;

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

628: RAISE FND_API.G_EXC_ERROR;
629: ELSE
630: IF l_order_msg IS NOT null THEN
631: FND_MESSAGE.Set_Name('CSP', 'CSP_REQ_CREATED');
632: FND_MESSAGE.Set_Token('REQ_NUMBER',to_char(l_requirement_header_id));
633: x_msg_data := FND_MESSAGE.GET;
634: END IF;
635: END IF;
636: END;

Line 633: x_msg_data := FND_MESSAGE.GET;

629: ELSE
630: IF l_order_msg IS NOT null THEN
631: FND_MESSAGE.Set_Name('CSP', 'CSP_REQ_CREATED');
632: FND_MESSAGE.Set_Token('REQ_NUMBER',to_char(l_requirement_header_id));
633: x_msg_data := FND_MESSAGE.GET;
634: END IF;
635: END IF;
636: END;
637: ELSE

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

650: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
651: RAISE FND_API.G_EXC_ERROR;
652: ELSE
653: IF l_order_msg IS NOT null THEN
654: FND_MESSAGE.Set_Name('CSP', 'CSP_REQ_CREATED');
655: FND_MESSAGE.Set_Token('REQ_NUMBER',to_char(l_requirement_header_id));
656: x_msg_data := FND_MESSAGE.GET;
657: END IF;
658: END IF;

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

651: RAISE FND_API.G_EXC_ERROR;
652: ELSE
653: IF l_order_msg IS NOT null THEN
654: FND_MESSAGE.Set_Name('CSP', 'CSP_REQ_CREATED');
655: FND_MESSAGE.Set_Token('REQ_NUMBER',to_char(l_requirement_header_id));
656: x_msg_data := FND_MESSAGE.GET;
657: END IF;
658: END IF;
659: END IF;

Line 656: x_msg_data := FND_MESSAGE.GET;

652: ELSE
653: IF l_order_msg IS NOT null THEN
654: FND_MESSAGE.Set_Name('CSP', 'CSP_REQ_CREATED');
655: FND_MESSAGE.Set_Token('REQ_NUMBER',to_char(l_requirement_header_id));
656: x_msg_data := FND_MESSAGE.GET;
657: END IF;
658: END IF;
659: END IF;
660:

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

682: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
683: RAISE FND_API.G_EXC_ERROR;
684: ELSE
685: IF x_msg_data IS null and l_order_msg is not null THEN
686: FND_MESSAGE.Set_Name('CSP', 'CSP_REQ_UPDATED');
687: FND_MESSAGE.Set_Token('REQ_NUMBER',to_char(l_requirement_header_id));
688: x_msg_data := FND_MESSAGE.GET;
689: END IF;
690: END IF;

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

683: RAISE FND_API.G_EXC_ERROR;
684: ELSE
685: IF x_msg_data IS null and l_order_msg is not null THEN
686: FND_MESSAGE.Set_Name('CSP', 'CSP_REQ_UPDATED');
687: FND_MESSAGE.Set_Token('REQ_NUMBER',to_char(l_requirement_header_id));
688: x_msg_data := FND_MESSAGE.GET;
689: END IF;
690: END IF;
691: FOR I IN 1..x_rqmt_line_tbl.count LOOP

Line 688: x_msg_data := FND_MESSAGE.GET;

684: ELSE
685: IF x_msg_data IS null and l_order_msg is not null THEN
686: FND_MESSAGE.Set_Name('CSP', 'CSP_REQ_UPDATED');
687: FND_MESSAGE.Set_Token('REQ_NUMBER',to_char(l_requirement_header_id));
688: x_msg_data := FND_MESSAGE.GET;
689: END IF;
690: END IF;
691: FOR I IN 1..x_rqmt_line_tbl.count LOOP
692: IF x_rqmt_line_tbl(I).order_line_id IS NOT NULL THEN

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

769: ,X_MSG_DATA => X_MSG_DATA
770: ,X_RETURN_STATUS => X_RETURN_STATUS);
771: WHEN OTHERS THEN
772: Rollback to process_requirement_pub;
773: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
774: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
775: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
776: FND_MSG_PUB.ADD;
777: fnd_msg_pub.count_and_get

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

770: ,X_RETURN_STATUS => X_RETURN_STATUS);
771: WHEN OTHERS THEN
772: Rollback to process_requirement_pub;
773: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
774: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
775: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
776: FND_MSG_PUB.ADD;
777: fnd_msg_pub.count_and_get
778: ( p_count => x_msg_count

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

771: WHEN OTHERS THEN
772: Rollback to process_requirement_pub;
773: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
774: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
775: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
776: FND_MSG_PUB.ADD;
777: fnd_msg_pub.count_and_get
778: ( p_count => x_msg_count
779: , p_data => x_msg_data);

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

957: l_line_rec := l_line_tbl(I);
958:
959: IF nvl(l_line_rec.requirement_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
960:
961: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
962: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_line_rec.requirement_line_id', FALSE);
963:
964: FND_MSG_PUB.ADD;
965: RAISE EXCP_USER_DEFINED;

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

958:
959: IF nvl(l_line_rec.requirement_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
960:
961: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
962: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_line_rec.requirement_line_id', FALSE);
963:
964: FND_MSG_PUB.ADD;
965: RAISE EXCP_USER_DEFINED;
966: ELSE

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

970: from csp_requirement_lines
971: where requirement_line_id = l_line_rec.requirement_line_id;
972: EXCEPTION
973: WHEN NO_DATA_FOUND THEN
974: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_LINE');
975: fnd_message.set_token ('LINE_ID', to_char(l_line_rec.requirement_line_id), FALSE);
976: FND_MSG_PUB.ADD;
977: RAISE EXCP_USER_DEFINED;
978: WHEN OTHERS THEN

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

971: where requirement_line_id = l_line_rec.requirement_line_id;
972: EXCEPTION
973: WHEN NO_DATA_FOUND THEN
974: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_LINE');
975: fnd_message.set_token ('LINE_ID', to_char(l_line_rec.requirement_line_id), FALSE);
976: FND_MSG_PUB.ADD;
977: RAISE EXCP_USER_DEFINED;
978: WHEN OTHERS THEN
979: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

975: fnd_message.set_token ('LINE_ID', to_char(l_line_rec.requirement_line_id), FALSE);
976: FND_MSG_PUB.ADD;
977: RAISE EXCP_USER_DEFINED;
978: WHEN OTHERS THEN
979: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
980: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);
981: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
982: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);
983: FND_MSG_PUB.ADD;

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

976: FND_MSG_PUB.ADD;
977: RAISE EXCP_USER_DEFINED;
978: WHEN OTHERS THEN
979: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
980: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);
981: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
982: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);
983: FND_MSG_PUB.ADD;
984: RAISE EXCP_USER_DEFINED;

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

977: RAISE EXCP_USER_DEFINED;
978: WHEN OTHERS THEN
979: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
980: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);
981: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
982: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);
983: FND_MSG_PUB.ADD;
984: RAISE EXCP_USER_DEFINED;
985: END;

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

978: WHEN OTHERS THEN
979: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
980: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);
981: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
982: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);
983: FND_MSG_PUB.ADD;
984: RAISE EXCP_USER_DEFINED;
985: END;
986: END IF;

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

1023: l_line_rec := l_po_line_tbl(I);
1024:
1025: IF nvl(l_line_rec.requirement_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
1026:
1027: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
1028: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_line_rec.requirement_line_id', FALSE);
1029:
1030: FND_MSG_PUB.ADD;
1031: RAISE EXCP_USER_DEFINED;

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

1024:
1025: IF nvl(l_line_rec.requirement_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
1026:
1027: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
1028: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_line_rec.requirement_line_id', FALSE);
1029:
1030: FND_MSG_PUB.ADD;
1031: RAISE EXCP_USER_DEFINED;
1032: ELSE

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

1036: from csp_requirement_lines
1037: where requirement_line_id = l_line_rec.requirement_line_id;
1038: EXCEPTION
1039: WHEN NO_DATA_FOUND THEN
1040: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_LINE');
1041: fnd_message.set_token ('LINE_ID', to_char(l_line_rec.requirement_line_id), FALSE);
1042: FND_MSG_PUB.ADD;
1043: RAISE EXCP_USER_DEFINED;
1044: WHEN OTHERS THEN

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

1037: where requirement_line_id = l_line_rec.requirement_line_id;
1038: EXCEPTION
1039: WHEN NO_DATA_FOUND THEN
1040: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_LINE');
1041: fnd_message.set_token ('LINE_ID', to_char(l_line_rec.requirement_line_id), FALSE);
1042: FND_MSG_PUB.ADD;
1043: RAISE EXCP_USER_DEFINED;
1044: WHEN OTHERS THEN
1045: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

1041: fnd_message.set_token ('LINE_ID', to_char(l_line_rec.requirement_line_id), FALSE);
1042: FND_MSG_PUB.ADD;
1043: RAISE EXCP_USER_DEFINED;
1044: WHEN OTHERS THEN
1045: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1046: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);
1047: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
1048: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);
1049: FND_MSG_PUB.ADD;

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

1042: FND_MSG_PUB.ADD;
1043: RAISE EXCP_USER_DEFINED;
1044: WHEN OTHERS THEN
1045: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1046: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);
1047: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
1048: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);
1049: FND_MSG_PUB.ADD;
1050: RAISE EXCP_USER_DEFINED;

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

1043: RAISE EXCP_USER_DEFINED;
1044: WHEN OTHERS THEN
1045: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1046: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);
1047: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
1048: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);
1049: FND_MSG_PUB.ADD;
1050: RAISE EXCP_USER_DEFINED;
1051: END;

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

1044: WHEN OTHERS THEN
1045: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1046: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);
1047: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
1048: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);
1049: FND_MSG_PUB.ADD;
1050: RAISE EXCP_USER_DEFINED;
1051: END;
1052: END IF;

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

1110: ,X_MSG_DATA => X_MSG_DATA
1111: ,X_RETURN_STATUS => X_RETURN_STATUS);
1112: WHEN OTHERS THEN
1113: Rollback to csptrreq_fm_order_PUB;
1114: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1115: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
1116: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
1117: FND_MSG_PUB.ADD;
1118: fnd_msg_pub.count_and_get

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

1111: ,X_RETURN_STATUS => X_RETURN_STATUS);
1112: WHEN OTHERS THEN
1113: Rollback to csptrreq_fm_order_PUB;
1114: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1115: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
1116: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
1117: FND_MSG_PUB.ADD;
1118: fnd_msg_pub.count_and_get
1119: ( p_count => x_msg_count

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

1112: WHEN OTHERS THEN
1113: Rollback to csptrreq_fm_order_PUB;
1114: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1115: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
1116: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
1117: FND_MSG_PUB.ADD;
1118: fnd_msg_pub.count_and_get
1119: ( p_count => x_msg_count
1120: , p_data => x_msg_data);

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

1432: ,X_MSG_DATA => X_MSG_DATA
1433: ,X_RETURN_STATUS => X_RETURN_STATUS);
1434: WHEN OTHERS THEN
1435: Rollback to csptrreq_fm_order_PUB;
1436: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1437: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
1438: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
1439: FND_MSG_PUB.ADD;
1440: fnd_msg_pub.count_and_get

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

1433: ,X_RETURN_STATUS => X_RETURN_STATUS);
1434: WHEN OTHERS THEN
1435: Rollback to csptrreq_fm_order_PUB;
1436: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1437: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
1438: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
1439: FND_MSG_PUB.ADD;
1440: fnd_msg_pub.count_and_get
1441: ( p_count => x_msg_count

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

1434: WHEN OTHERS THEN
1435: Rollback to csptrreq_fm_order_PUB;
1436: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1437: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
1438: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
1439: FND_MSG_PUB.ADD;
1440: fnd_msg_pub.count_and_get
1441: ( p_count => x_msg_count
1442: , p_data => x_msg_data);

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

1483: WHERE crl.requirement_header_id = p_header_id
1484: AND crl.requirement_line_id = crld.requirement_line_id;
1485:
1486: IF l_count > 0 THEN
1487: FND_MESSAGE.SET_NAME ('CSP', 'CSP_RQMT_LINE_DELETE_ERROR');
1488: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_header_id', FALSE);
1489: FND_MSG_PUB.ADD;
1490: RAISE EXCP_USER_DEFINED;
1491: ELSE

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

1484: AND crl.requirement_line_id = crld.requirement_line_id;
1485:
1486: IF l_count > 0 THEN
1487: FND_MESSAGE.SET_NAME ('CSP', 'CSP_RQMT_LINE_DELETE_ERROR');
1488: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_header_id', FALSE);
1489: FND_MSG_PUB.ADD;
1490: RAISE EXCP_USER_DEFINED;
1491: ELSE
1492: DELETE FROM csp_requirement_lines

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

1528: ,X_MSG_DATA => X_MSG_DATA
1529: ,X_RETURN_STATUS => X_RETURN_STATUS);
1530: WHEN OTHERS THEN
1531: Rollback to delete_rqmt_header_PUB;
1532: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1533: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
1534: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
1535: FND_MSG_PUB.ADD;
1536: fnd_msg_pub.count_and_get

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

1529: ,X_RETURN_STATUS => X_RETURN_STATUS);
1530: WHEN OTHERS THEN
1531: Rollback to delete_rqmt_header_PUB;
1532: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1533: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
1534: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
1535: FND_MSG_PUB.ADD;
1536: fnd_msg_pub.count_and_get
1537: ( p_count => x_msg_count

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

1530: WHEN OTHERS THEN
1531: Rollback to delete_rqmt_header_PUB;
1532: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1533: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
1534: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
1535: FND_MSG_PUB.ADD;
1536: fnd_msg_pub.count_and_get
1537: ( p_count => x_msg_count
1538: , p_data => x_msg_data);

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

1642: FROM jtf_rs_resource_extns
1643: WHERE user_id = l_user_id;
1644: EXCEPTION
1645: WHEN no_Data_found THEN
1646: FND_MESSAGE.SET_NAME ('CSP', 'CSP_RS_USER_NOT_DEFINED');
1647: FND_MSG_PUB.ADD;
1648: RAISE EXCP_USER_DEFINED;
1649: END;
1650:

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

1654: FROM jtf_rs_all_resources_vl
1655: WHERE resource_id = l_header_rec.resource_id;
1656: EXCEPTION
1657: WHEN no_Data_found THEN
1658: FND_MESSAGE.SET_NAME ('CSP', 'CSP_INVALID_RES_ID_TYPE');
1659: FND_MSG_PUB.ADD;
1660: RAISE EXCP_USER_DEFINED;
1661: END;
1662: */

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

1672: AND default_code = 'IN';
1673: EXCEPTION
1674: WHEN no_Data_found THEN
1675:
1676: FND_MESSAGE.SET_NAME ('CSP', 'CSP_SCH_DEFAULT_SUBINV');
1677: FND_MESSAGE.SET_TOKEN('RESOURCE_TYPE', l_header_rec.resource_type);
1678: FND_MESSAGE.SET_TOKEN('RESOURCE_NAME', l_resource_name);
1679: FND_MSG_PUB.ADD;
1680: RAISE EXCP_USER_DEFINED;

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

1673: EXCEPTION
1674: WHEN no_Data_found THEN
1675:
1676: FND_MESSAGE.SET_NAME ('CSP', 'CSP_SCH_DEFAULT_SUBINV');
1677: FND_MESSAGE.SET_TOKEN('RESOURCE_TYPE', l_header_rec.resource_type);
1678: FND_MESSAGE.SET_TOKEN('RESOURCE_NAME', l_resource_name);
1679: FND_MSG_PUB.ADD;
1680: RAISE EXCP_USER_DEFINED;
1681: WHEN TOO_MANY_ROWS THEN

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

1674: WHEN no_Data_found THEN
1675:
1676: FND_MESSAGE.SET_NAME ('CSP', 'CSP_SCH_DEFAULT_SUBINV');
1677: FND_MESSAGE.SET_TOKEN('RESOURCE_TYPE', l_header_rec.resource_type);
1678: FND_MESSAGE.SET_TOKEN('RESOURCE_NAME', l_resource_name);
1679: FND_MSG_PUB.ADD;
1680: RAISE EXCP_USER_DEFINED;
1681: WHEN TOO_MANY_ROWS THEN
1682:

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

1679: FND_MSG_PUB.ADD;
1680: RAISE EXCP_USER_DEFINED;
1681: WHEN TOO_MANY_ROWS THEN
1682:
1683: FND_MESSAGE.SET_NAME ('CSP', 'CSP_ONE_DEFAULT_IN_ALLOWED');
1684: FND_MSG_PUB.ADD;
1685: RAISE EXCP_USER_DEFINED;
1686: END;
1687:

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

1693: WHERE task_id = l_header_rec.task_id;
1694: EXCEPTION
1695: WHEN NO_DATA_FOUND THEN
1696:
1697: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETER');
1698: FND_MESSAGE.SET_TOKEN('PARAMETER', 'Service Request');
1699: FND_MSG_PUB.ADD;
1700: RAISE EXCP_USER_DEFINED;
1701: END;

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

1694: EXCEPTION
1695: WHEN NO_DATA_FOUND THEN
1696:
1697: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETER');
1698: FND_MESSAGE.SET_TOKEN('PARAMETER', 'Service Request');
1699: FND_MSG_PUB.ADD;
1700: RAISE EXCP_USER_DEFINED;
1701: END;
1702: END IF;

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

1793: WHERE task_id = l_header_rec.task_id;
1794:
1795: IF (l_requirement_header_id IS NOT NULL) THEN
1796: Rollback to save_rqmt_line_PUB;
1797: --FND_MESSAGE.SET_NAME('CSP', 'CSP_TASK_RQMT_EXISTS');
1798: --FND_MSG_PUB.ADD;
1799: --fnd_msg_pub.count_and_get
1800: -- ( p_count => x_msg_count
1801: -- , p_data => x_msg_data);

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

1798: --FND_MSG_PUB.ADD;
1799: --fnd_msg_pub.count_and_get
1800: -- ( p_count => x_msg_count
1801: -- , p_data => x_msg_data);
1802: x_msg_data := fnd_message.get_string('CSP', 'CSP_TASK_RQMT_EXISTS');
1803: x_return_status := 'E';
1804: return;
1805: END IF;
1806: EXCEPTION

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

1859: from csp_requirement_headers
1860: where requirement_header_id = l_header_rec.requirement_header_id;
1861: EXCEPTION
1862: WHEN NO_DATA_FOUND THEN
1863: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_HEADER');
1864: fnd_message.set_token('HEADER_ID', to_char(l_header_rec.requirement_header_id), FALSE);
1865: FND_MSG_PUB.ADD;
1866: RAISE EXCP_USER_DEFINED;
1867: WHEN OTHERS THEN

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

1860: where requirement_header_id = l_header_rec.requirement_header_id;
1861: EXCEPTION
1862: WHEN NO_DATA_FOUND THEN
1863: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_HEADER');
1864: fnd_message.set_token('HEADER_ID', to_char(l_header_rec.requirement_header_id), FALSE);
1865: FND_MSG_PUB.ADD;
1866: RAISE EXCP_USER_DEFINED;
1867: WHEN OTHERS THEN
1868: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

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

1864: fnd_message.set_token('HEADER_ID', to_char(l_header_rec.requirement_header_id), FALSE);
1865: FND_MSG_PUB.ADD;
1866: RAISE EXCP_USER_DEFINED;
1867: WHEN OTHERS THEN
1868: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1869: fnd_message.set_token('ERR_FIELD', 'l_header_rec.requirement_header_id', FALSE);
1870: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
1871: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_HEADERS', FALSE);
1872: FND_MSG_PUB.ADD;

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

1865: FND_MSG_PUB.ADD;
1866: RAISE EXCP_USER_DEFINED;
1867: WHEN OTHERS THEN
1868: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1869: fnd_message.set_token('ERR_FIELD', 'l_header_rec.requirement_header_id', FALSE);
1870: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
1871: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_HEADERS', FALSE);
1872: FND_MSG_PUB.ADD;
1873: RAISE EXCP_USER_DEFINED;

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

1866: RAISE EXCP_USER_DEFINED;
1867: WHEN OTHERS THEN
1868: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1869: fnd_message.set_token('ERR_FIELD', 'l_header_rec.requirement_header_id', FALSE);
1870: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
1871: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_HEADERS', FALSE);
1872: FND_MSG_PUB.ADD;
1873: RAISE EXCP_USER_DEFINED;
1874: END;

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

1867: WHEN OTHERS THEN
1868: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1869: fnd_message.set_token('ERR_FIELD', 'l_header_rec.requirement_header_id', FALSE);
1870: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
1871: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_HEADERS', FALSE);
1872: FND_MSG_PUB.ADD;
1873: RAISE EXCP_USER_DEFINED;
1874: END;
1875:

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

1914: into l_count
1915: from csp_requirement_lines
1916: where requirement_line_id = l_rqmt_line_rec.requirement_line_id;
1917: IF l_count > 0 THEN
1918: fnd_message.set_name('CSP', 'CSP_DUPLICATE_RQMT_LINE');
1919: FND_MSG_PUB.ADD;
1920: RAISE EXCP_USER_DEFINED;
1921: END IF;
1922: EXCEPTION

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

2020: ,X_MSG_DATA => X_MSG_DATA
2021: ,X_RETURN_STATUS => X_RETURN_STATUS);
2022: WHEN OTHERS THEN
2023: Rollback to save_rqmt_line_PUB;
2024: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2025: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
2026: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
2027: FND_MSG_PUB.ADD;
2028: fnd_msg_pub.count_and_get

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

2021: ,X_RETURN_STATUS => X_RETURN_STATUS);
2022: WHEN OTHERS THEN
2023: Rollback to save_rqmt_line_PUB;
2024: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2025: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
2026: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
2027: FND_MSG_PUB.ADD;
2028: fnd_msg_pub.count_and_get
2029: ( p_count => x_msg_count

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

2022: WHEN OTHERS THEN
2023: Rollback to save_rqmt_line_PUB;
2024: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2025: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
2026: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
2027: FND_MSG_PUB.ADD;
2028: fnd_msg_pub.count_and_get
2029: ( p_count => x_msg_count
2030: , p_data => x_msg_data);

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

2096: ,X_MSG_DATA => X_MSG_DATA
2097: ,X_RETURN_STATUS => X_RETURN_STATUS);
2098: WHEN OTHERS THEN
2099: Rollback to delete_rqmt_line_PUB;
2100: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2101: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
2102: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
2103: FND_MSG_PUB.ADD;
2104: fnd_msg_pub.count_and_get

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

2097: ,X_RETURN_STATUS => X_RETURN_STATUS);
2098: WHEN OTHERS THEN
2099: Rollback to delete_rqmt_line_PUB;
2100: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2101: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
2102: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
2103: FND_MSG_PUB.ADD;
2104: fnd_msg_pub.count_and_get
2105: ( p_count => x_msg_count

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

2098: WHEN OTHERS THEN
2099: Rollback to delete_rqmt_line_PUB;
2100: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2101: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
2102: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
2103: FND_MSG_PUB.ADD;
2104: fnd_msg_pub.count_and_get
2105: ( p_count => x_msg_count
2106: , p_data => x_msg_data);

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

2191: WHERE requirement_header_id = p_header_id;
2192:
2193: EXCEPTION
2194: WHEN no_data_found THEN
2195: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_HEADER');
2196: fnd_message.set_token('HEADER_ID', to_char(p_header_id), FALSE);
2197: FND_MSG_PUB.ADD;
2198: RAISE EXCP_USER_DEFINED;
2199: END;

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

2192:
2193: EXCEPTION
2194: WHEN no_data_found THEN
2195: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_HEADER');
2196: fnd_message.set_token('HEADER_ID', to_char(p_header_id), FALSE);
2197: FND_MSG_PUB.ADD;
2198: RAISE EXCP_USER_DEFINED;
2199: END;
2200:

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

2352: ,X_MSG_DATA => X_MSG_DATA
2353: ,X_RETURN_STATUS => X_RETURN_STATUS);
2354: WHEN OTHERS THEN
2355: Rollback to check_Availability_pub;
2356: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2357: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
2358: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
2359: FND_MSG_PUB.ADD;
2360: fnd_msg_pub.count_and_get

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

2353: ,X_RETURN_STATUS => X_RETURN_STATUS);
2354: WHEN OTHERS THEN
2355: Rollback to check_Availability_pub;
2356: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2357: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
2358: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
2359: FND_MSG_PUB.ADD;
2360: fnd_msg_pub.count_and_get
2361: ( p_count => x_msg_count

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

2354: WHEN OTHERS THEN
2355: Rollback to check_Availability_pub;
2356: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2357: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
2358: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
2359: FND_MSG_PUB.ADD;
2360: fnd_msg_pub.count_and_get
2361: ( p_count => x_msg_count
2362: , p_data => x_msg_data);

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

2500: end if;
2501:
2502: EXCEPTION
2503: WHEN no_data_found THEN
2504: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_HEADER');
2505: fnd_message.set_token('HEADER_ID', to_char(p_header_id), FALSE);
2506: FND_MSG_PUB.ADD;
2507: RAISE EXCP_USER_DEFINED;
2508: END;

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

2501:
2502: EXCEPTION
2503: WHEN no_data_found THEN
2504: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_HEADER');
2505: fnd_message.set_token('HEADER_ID', to_char(p_header_id), FALSE);
2506: FND_MSG_PUB.ADD;
2507: RAISE EXCP_USER_DEFINED;
2508: END;
2509:

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

2540: end if;
2541:
2542: EXIT WHEN rqmt_line_cur%NOTFOUND;
2543: IF (l_line_rec.sourced_From = 'IO' and l_line_rec.source_organization_id IS NULL) THEN
2544: fnd_message.set_name('CSP', 'CSP_NULL_SRC_ORGN');
2545: fnd_msg_pub.add;
2546: RAISE EXCP_USER_DEFINED;
2547: END If;
2548: l_line_rec.ordered_quantity := l_line_Rec.quantity;

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

2733: ,X_MSG_DATA => X_MSG_DATA
2734: ,X_RETURN_STATUS => X_RETURN_STATUS);
2735: WHEN OTHERS THEN
2736: Rollback to create_order_PUB;
2737: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2738: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
2739: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
2740: FND_MSG_PUB.ADD;
2741: fnd_msg_pub.count_and_get

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

2734: ,X_RETURN_STATUS => X_RETURN_STATUS);
2735: WHEN OTHERS THEN
2736: Rollback to create_order_PUB;
2737: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2738: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
2739: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
2740: FND_MSG_PUB.ADD;
2741: fnd_msg_pub.count_and_get
2742: ( p_count => x_msg_count

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

2735: WHEN OTHERS THEN
2736: Rollback to create_order_PUB;
2737: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2738: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
2739: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
2740: FND_MSG_PUB.ADD;
2741: fnd_msg_pub.count_and_get
2742: ( p_count => x_msg_count
2743: , p_data => x_msg_data);

Line 2980: FND_MESSAGE.SET_NAME('CSP', 'CSP_TSK_ASGN_ORDER_MSG');

2976: fetch check_IO_booked into l_rqmt_header_id, l_dummy;
2977: exit when check_IO_booked%NOTFOUND;
2978:
2979: if l_dummy > 0 then
2980: FND_MESSAGE.SET_NAME('CSP', 'CSP_TSK_ASGN_ORDER_MSG');
2981: FND_MESSAGE.SET_TOKEN('REQ_NUM', l_rqmt_header_id, TRUE);
2982: FND_MSG_PUB.ADD;
2983: raise EXCP_USER_DEFINED;
2984: end if;

Line 2981: FND_MESSAGE.SET_TOKEN('REQ_NUM', l_rqmt_header_id, TRUE);

2977: exit when check_IO_booked%NOTFOUND;
2978:
2979: if l_dummy > 0 then
2980: FND_MESSAGE.SET_NAME('CSP', 'CSP_TSK_ASGN_ORDER_MSG');
2981: FND_MESSAGE.SET_TOKEN('REQ_NUM', l_rqmt_header_id, TRUE);
2982: FND_MSG_PUB.ADD;
2983: raise EXCP_USER_DEFINED;
2984: end if;
2985: end loop;

Line 3014: FND_MESSAGE.SET_NAME('CSP', 'CSP_TSK_ASGN_SHIP_MSG');

3010: if l_is_cancelled = 'N' then -- entered status
3011: -- check ship to type
3012: if l_ship_to_type = 'R' or l_ship_to_type = 'S' then
3013: -- raise an error message
3014: FND_MESSAGE.SET_NAME('CSP', 'CSP_TSK_ASGN_SHIP_MSG');
3015: FND_MESSAGE.SET_TOKEN('REQ_NUM', l_rqmt_header_id, TRUE);
3016: FND_MSG_PUB.ADD;
3017: raise EXCP_USER_DEFINED;
3018: end if;

Line 3015: FND_MESSAGE.SET_TOKEN('REQ_NUM', l_rqmt_header_id, TRUE);

3011: -- check ship to type
3012: if l_ship_to_type = 'R' or l_ship_to_type = 'S' then
3013: -- raise an error message
3014: FND_MESSAGE.SET_NAME('CSP', 'CSP_TSK_ASGN_SHIP_MSG');
3015: FND_MESSAGE.SET_TOKEN('REQ_NUM', l_rqmt_header_id, TRUE);
3016: FND_MSG_PUB.ADD;
3017: raise EXCP_USER_DEFINED;
3018: end if;
3019:

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

3030: WHERE OBJECT_CODE = l_resource_type_code;
3031:
3032: l_resource_name := csp_pick_utils.get_object_name(l_resource_type_code, l_resource_id);
3033:
3034: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_DEFAULT_SUBINV');
3035: FND_MESSAGE.SET_TOKEN('RESOURCE_TYPE', l_resource_type_name, TRUE);
3036: FND_MESSAGE.SET_TOKEN('RESOURCE_NAME', l_resource_name, TRUE);
3037: FND_MSG_PUB.ADD;
3038: raise EXCP_USER_DEFINED;

Line 3035: FND_MESSAGE.SET_TOKEN('RESOURCE_TYPE', l_resource_type_name, TRUE);

3031:
3032: l_resource_name := csp_pick_utils.get_object_name(l_resource_type_code, l_resource_id);
3033:
3034: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_DEFAULT_SUBINV');
3035: FND_MESSAGE.SET_TOKEN('RESOURCE_TYPE', l_resource_type_name, TRUE);
3036: FND_MESSAGE.SET_TOKEN('RESOURCE_NAME', l_resource_name, TRUE);
3037: FND_MSG_PUB.ADD;
3038: raise EXCP_USER_DEFINED;
3039: end if;

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

3032: l_resource_name := csp_pick_utils.get_object_name(l_resource_type_code, l_resource_id);
3033:
3034: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_DEFAULT_SUBINV');
3035: FND_MESSAGE.SET_TOKEN('RESOURCE_TYPE', l_resource_type_name, TRUE);
3036: FND_MESSAGE.SET_TOKEN('RESOURCE_NAME', l_resource_name, TRUE);
3037: FND_MSG_PUB.ADD;
3038: raise EXCP_USER_DEFINED;
3039: end if;
3040:

Line 3048: FND_MESSAGE.SET_NAME('CSP', 'CSP_TSK_ASGN_OU_MSG');

3044: WHERE organization_id = l_organization_id;
3045:
3046: if l_old_dest_OU <> l_new_dest_OU then
3047: -- raise an error message
3048: FND_MESSAGE.SET_NAME('CSP', 'CSP_TSK_ASGN_OU_MSG');
3049: FND_MESSAGE.SET_TOKEN('REQ_NUM', l_rqmt_header_id, TRUE);
3050: FND_MSG_PUB.ADD;
3051: raise EXCP_USER_DEFINED;
3052: end if;

Line 3049: FND_MESSAGE.SET_TOKEN('REQ_NUM', l_rqmt_header_id, TRUE);

3045:
3046: if l_old_dest_OU <> l_new_dest_OU then
3047: -- raise an error message
3048: FND_MESSAGE.SET_NAME('CSP', 'CSP_TSK_ASGN_OU_MSG');
3049: FND_MESSAGE.SET_TOKEN('REQ_NUM', l_rqmt_header_id, TRUE);
3050: FND_MSG_PUB.ADD;
3051: raise EXCP_USER_DEFINED;
3052: end if;
3053:

Line 3083: FND_MESSAGE.SET_NAME('CSP', 'CSP_MAN_NOT_CANCEL_RESERV');

3079: if l_res_same_org > 0 then
3080: CSP_SCH_INT_PVT.CANCEL_RESERVATION(l_source_id, x_return_status, x_msg_data, x_msg_count);
3081: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3082: rollback to csp_correct_req_record;
3083: FND_MESSAGE.SET_NAME('CSP', 'CSP_MAN_NOT_CANCEL_RESERV');
3084: FND_MESSAGE.SET_TOKEN('REQ_NUM', l_rqmt_header_id, TRUE);
3085: FND_MSG_PUB.ADD;
3086: raise EXCP_USER_DEFINED;
3087: else

Line 3084: FND_MESSAGE.SET_TOKEN('REQ_NUM', l_rqmt_header_id, TRUE);

3080: CSP_SCH_INT_PVT.CANCEL_RESERVATION(l_source_id, x_return_status, x_msg_data, x_msg_count);
3081: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3082: rollback to csp_correct_req_record;
3083: FND_MESSAGE.SET_NAME('CSP', 'CSP_MAN_NOT_CANCEL_RESERV');
3084: FND_MESSAGE.SET_TOKEN('REQ_NUM', l_rqmt_header_id, TRUE);
3085: FND_MSG_PUB.ADD;
3086: raise EXCP_USER_DEFINED;
3087: else
3088: CSP_REQ_LINE_DETAILS_PKG.Delete_Row(l_req_line_dtl_id);

Line 3200: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_DATE_PST_ASSGN');

3196: -- check if we need to source the item and schedule dates are already in past
3197: -- then stop reassignment
3198: if l_booking_start_date is null or l_booking_start_date <= sysdate then
3199: x_return_status := FND_API.G_RET_STS_ERROR;
3200: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_DATE_PST_ASSGN');
3201: FND_MSG_PUB.ADD;
3202: fnd_msg_pub.count_and_get
3203: ( p_count => x_msg_count
3204: , p_data => x_msg_data);

Line 3232: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');

3228: end if;
3229:
3230: if l_partial_line > 0 then
3231: x_return_status := FND_API.G_RET_STS_ERROR;
3232: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
3233: FND_MSG_PUB.ADD;
3234: fnd_msg_pub.count_and_get
3235: ( p_count => x_msg_count
3236: , p_data => x_msg_data);

Line 3290: FND_MESSAGE.SET_NAME('CSP', 'CSP_TSK_ASSGN_NO_IO_CAN');

3286: and oola.header_id = ooha.header_id
3287: AND rownum = 1;
3288:
3289: x_return_status := FND_API.G_RET_STS_ERROR;
3290: FND_MESSAGE.SET_NAME('CSP', 'CSP_TSK_ASSGN_NO_IO_CAN');
3291: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',l_order_number, FALSE);
3292: FND_MSG_PUB.ADD;
3293: fnd_msg_pub.count_and_get
3294: ( p_count => x_msg_count

Line 3291: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',l_order_number, FALSE);

3287: AND rownum = 1;
3288:
3289: x_return_status := FND_API.G_RET_STS_ERROR;
3290: FND_MESSAGE.SET_NAME('CSP', 'CSP_TSK_ASSGN_NO_IO_CAN');
3291: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',l_order_number, FALSE);
3292: FND_MSG_PUB.ADD;
3293: fnd_msg_pub.count_and_get
3294: ( p_count => x_msg_count
3295: , p_data => x_msg_data);

Line 3365: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');

3361: end if;
3362:
3363: if l_fl_rcvd_multi_source > 0 then
3364: x_return_status := FND_API.G_RET_STS_ERROR;
3365: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
3366: FND_MSG_PUB.ADD;
3367: fnd_msg_pub.count_and_get
3368: ( p_count => x_msg_count
3369: , p_data => x_msg_data);

Line 3417: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');

3413: end if;
3414:
3415: if l_oth_req_line > 0 then
3416: x_return_status := FND_API.G_RET_STS_ERROR;
3417: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
3418: FND_MSG_PUB.ADD;
3419: fnd_msg_pub.count_and_get
3420: ( p_count => x_msg_count
3421: , p_data => x_msg_data);

Line 3492: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');

3488: 'after calling move_parts_on_reassign...x_return_status=' || x_return_status);
3489: end if;
3490: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3491: x_return_status := FND_API.G_RET_STS_ERROR;
3492: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
3493: FND_MSG_PUB.ADD;
3494: fnd_msg_pub.count_and_get
3495: ( p_count => x_msg_count
3496: , p_data => x_msg_data);

Line 3556: FND_MESSAGE.SET_NAME('CSP', 'CSP_TSK_ASSGN_NO_IO_CAN');

3552: AND oola.header_id = ooha.header_id
3553: AND rownum = 1;
3554:
3555: x_return_status := FND_API.G_RET_STS_ERROR;
3556: FND_MESSAGE.SET_NAME('CSP', 'CSP_TSK_ASSGN_NO_IO_CAN');
3557: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',l_order_number, FALSE);
3558: FND_MSG_PUB.ADD;
3559: fnd_msg_pub.count_and_get
3560: ( p_count => x_msg_count

Line 3557: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',l_order_number, FALSE);

3553: AND rownum = 1;
3554:
3555: x_return_status := FND_API.G_RET_STS_ERROR;
3556: FND_MESSAGE.SET_NAME('CSP', 'CSP_TSK_ASSGN_NO_IO_CAN');
3557: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',l_order_number, FALSE);
3558: FND_MSG_PUB.ADD;
3559: fnd_msg_pub.count_and_get
3560: ( p_count => x_msg_count
3561: , p_data => x_msg_data);

Line 3591: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');

3587: end if;
3588:
3589: if l_ship_multi_src > 0 then
3590: x_return_status := FND_API.G_RET_STS_ERROR;
3591: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
3592: FND_MSG_PUB.ADD;
3593: fnd_msg_pub.count_and_get
3594: ( p_count => x_msg_count
3595: , p_data => x_msg_data);

Line 3634: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');

3630: end if;
3631:
3632: if l_oth_req_line > 0 then
3633: x_return_status := FND_API.G_RET_STS_ERROR;
3634: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
3635: FND_MSG_PUB.ADD;
3636: fnd_msg_pub.count_and_get
3637: ( p_count => x_msg_count
3638: , p_data => x_msg_data);

Line 3722: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');

3718: end if;
3719:
3720: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3721: x_return_status := FND_API.G_RET_STS_ERROR;
3722: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
3723: FND_MSG_PUB.ADD;
3724: fnd_msg_pub.count_and_get
3725: ( p_count => x_msg_count
3726: , p_data => x_msg_data);

Line 3732: FND_MESSAGE.SET_NAME('CSP', 'CSP_RASG_IO_UPD_OU_ERR');

3728: end if;
3729: end loop;
3730: else
3731: x_return_status := FND_API.G_RET_STS_ERROR;
3732: FND_MESSAGE.SET_NAME('CSP', 'CSP_RASG_IO_UPD_OU_ERR');
3733: FND_MESSAGE.SET_TOKEN('ORG_NAME', l_dest_org_name, TRUE);
3734: FND_MSG_PUB.ADD;
3735: fnd_msg_pub.count_and_get
3736: ( p_count => x_msg_count

Line 3733: FND_MESSAGE.SET_TOKEN('ORG_NAME', l_dest_org_name, TRUE);

3729: end loop;
3730: else
3731: x_return_status := FND_API.G_RET_STS_ERROR;
3732: FND_MESSAGE.SET_NAME('CSP', 'CSP_RASG_IO_UPD_OU_ERR');
3733: FND_MESSAGE.SET_TOKEN('ORG_NAME', l_dest_org_name, TRUE);
3734: FND_MSG_PUB.ADD;
3735: fnd_msg_pub.count_and_get
3736: ( p_count => x_msg_count
3737: , p_data => x_msg_data);

Line 3818: FND_MESSAGE.SET_NAME('CSP', 'CSP_TSK_ASSGN_NO_SRC');

3814: end if;
3815: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3816: FND_MSG_PUB.initialize;
3817: l_resource_name := csp_pick_utils.get_object_name(l_resource_type_code, l_resource_id);
3818: FND_MESSAGE.SET_NAME('CSP', 'CSP_TSK_ASSGN_NO_SRC');
3819: FND_MESSAGE.SET_TOKEN('RESOURCE_NAME',l_resource_name, FALSE);
3820: FND_MSG_PUB.ADD;
3821: fnd_msg_pub.count_and_get
3822: ( p_count => x_msg_count

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

3815: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3816: FND_MSG_PUB.initialize;
3817: l_resource_name := csp_pick_utils.get_object_name(l_resource_type_code, l_resource_id);
3818: FND_MESSAGE.SET_NAME('CSP', 'CSP_TSK_ASSGN_NO_SRC');
3819: FND_MESSAGE.SET_TOKEN('RESOURCE_NAME',l_resource_name, FALSE);
3820: FND_MSG_PUB.ADD;
3821: fnd_msg_pub.count_and_get
3822: ( p_count => x_msg_count
3823: , p_data => x_msg_data);

Line 3872: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');

3868: end if;
3869:
3870: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3871: x_return_status := FND_API.G_RET_STS_ERROR;
3872: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
3873: FND_MSG_PUB.ADD;
3874: fnd_msg_pub.count_and_get
3875: ( p_count => x_msg_count
3876: , p_data => x_msg_data);

Line 3882: FND_MESSAGE.SET_NAME('CSP', 'CSP_RASG_IO_UPD_OU_ERR');

3878: end if;
3879: end loop;
3880: else
3881: x_return_status := FND_API.G_RET_STS_ERROR;
3882: FND_MESSAGE.SET_NAME('CSP', 'CSP_RASG_IO_UPD_OU_ERR');
3883: FND_MESSAGE.SET_TOKEN('ORG_NAME', l_dest_org_name, TRUE);
3884: FND_MSG_PUB.ADD;
3885: fnd_msg_pub.count_and_get
3886: ( p_count => x_msg_count

Line 3883: FND_MESSAGE.SET_TOKEN('ORG_NAME', l_dest_org_name, TRUE);

3879: end loop;
3880: else
3881: x_return_status := FND_API.G_RET_STS_ERROR;
3882: FND_MESSAGE.SET_NAME('CSP', 'CSP_RASG_IO_UPD_OU_ERR');
3883: FND_MESSAGE.SET_TOKEN('ORG_NAME', l_dest_org_name, TRUE);
3884: FND_MSG_PUB.ADD;
3885: fnd_msg_pub.count_and_get
3886: ( p_count => x_msg_count
3887: , p_data => x_msg_data);

Line 3893: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');

3889: end if;
3890: return;
3891: else
3892: x_return_status := FND_API.G_RET_STS_ERROR;
3893: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
3894: FND_MSG_PUB.ADD;
3895: fnd_msg_pub.count_and_get
3896: ( p_count => x_msg_count
3897: , p_data => x_msg_data);

Line 4032: FND_MESSAGE.SET_NAME('CSP', 'CSP_IO_BOOK_ERROR');

4028:
4029: select order_number into l_oe_order_num
4030: from oe_order_headers_all where header_id = l_oe_header_id;
4031:
4032: FND_MESSAGE.SET_NAME('CSP', 'CSP_IO_BOOK_ERROR');
4033: FND_MESSAGE.SET_TOKEN('ORDER_NUM', l_oe_order_num, TRUE);
4034: FND_MSG_PUB.ADD;
4035: raise EXCP_USER_DEFINED;
4036: end if;

Line 4033: FND_MESSAGE.SET_TOKEN('ORDER_NUM', l_oe_order_num, TRUE);

4029: select order_number into l_oe_order_num
4030: from oe_order_headers_all where header_id = l_oe_header_id;
4031:
4032: FND_MESSAGE.SET_NAME('CSP', 'CSP_IO_BOOK_ERROR');
4033: FND_MESSAGE.SET_TOKEN('ORDER_NUM', l_oe_order_num, TRUE);
4034: FND_MSG_PUB.ADD;
4035: raise EXCP_USER_DEFINED;
4036: end if;
4037:

Line 4566: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');

4562: end if;
4563:
4564: if l_dtl_count > 0 then
4565: x_return_status := FND_API.G_RET_STS_ERROR;
4566: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
4567: FND_MSG_PUB.ADD;
4568: fnd_msg_pub.count_and_get
4569: ( p_count => x_msg_count
4570: , p_data => x_msg_data);