DBA Data[Home] [Help]

APPS.AHL_OSP_ACCOMP_PVT dependencies on FND_MESSAGE

Line 113: FND_MESSAGE.set_name('AHL','AHL_OSP_ACC_INV_DATE');

109: IF (p_accomplishment_date < l_mr_dtls.effective_from OR p_accomplishment_date > nvl(l_mr_dtls.effective_to,SYSDATE)) THEN
110: IF (l_log_statement >= l_log_current_level) THEN
111: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'Invalid accomplishment date.');
112: END IF;
113: FND_MESSAGE.set_name('AHL','AHL_OSP_ACC_INV_DATE');
114: FND_MESSAGE.set_token('TITLE',l_mr_dtls.title);
115: FND_MSG_PUB.add;
116: RAISE FND_API.G_EXC_ERROR;
117: END IF;

Line 114: FND_MESSAGE.set_token('TITLE',l_mr_dtls.title);

110: IF (l_log_statement >= l_log_current_level) THEN
111: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'Invalid accomplishment date.');
112: END IF;
113: FND_MESSAGE.set_name('AHL','AHL_OSP_ACC_INV_DATE');
114: FND_MESSAGE.set_token('TITLE',l_mr_dtls.title);
115: FND_MSG_PUB.add;
116: RAISE FND_API.G_EXC_ERROR;
117: END IF;
118:

Line 127: FND_MESSAGE.set_name('AHL','AHL_OSP_ACC_INV_STATUS');

123: IF (l_mr_dtls.mr_status_code <> 'COMPLETE' ) THEN
124: IF (l_log_statement >= l_log_current_level) THEN
125: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'Invalid MR Status.');
126: END IF;
127: FND_MESSAGE.set_name('AHL','AHL_OSP_ACC_INV_STATUS');
128: FND_MESSAGE.set_token('TITLE',l_mr_dtls.title);
129: FND_MSG_PUB.add;
130: RAISE FND_API.G_EXC_ERROR;
131: END IF;

Line 128: FND_MESSAGE.set_token('TITLE',l_mr_dtls.title);

124: IF (l_log_statement >= l_log_current_level) THEN
125: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'Invalid MR Status.');
126: END IF;
127: FND_MESSAGE.set_name('AHL','AHL_OSP_ACC_INV_STATUS');
128: FND_MESSAGE.set_token('TITLE',l_mr_dtls.title);
129: FND_MSG_PUB.add;
130: RAISE FND_API.G_EXC_ERROR;
131: END IF;
132: --Modification by JROTICH for bug#13798727 END

Line 507: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_OSP_INV_ACCOM_ID');

503: OPEN chk_accomplishment_csr(c_accomplishment_id => p_accomplishment_id);
504: FETCH chk_accomplishment_csr INTO l_osp_order_line_id;
505: IF (chk_accomplishment_csr%NOTFOUND) THEN
506: CLOSE chk_accomplishment_csr;
507: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_OSP_INV_ACCOM_ID');
508: FND_MESSAGE.set_token('ACCOM_ID', p_accomplishment_id);
509: FND_MSG_PUB.ADD;
510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
511: END IF;

Line 508: FND_MESSAGE.set_token('ACCOM_ID', p_accomplishment_id);

504: FETCH chk_accomplishment_csr INTO l_osp_order_line_id;
505: IF (chk_accomplishment_csr%NOTFOUND) THEN
506: CLOSE chk_accomplishment_csr;
507: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_OSP_INV_ACCOM_ID');
508: FND_MESSAGE.set_token('ACCOM_ID', p_accomplishment_id);
509: FND_MSG_PUB.ADD;
510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
511: END IF;
512: CLOSE chk_accomplishment_csr;

Line 516: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_OSP_ACCOM_ID_MISMATCH');

512: CLOSE chk_accomplishment_csr;
513:
514: -- If OSP Order Line Id is also passed, validate it to ensure that it matches the Accomplishment Id
515: IF ((p_osp_order_line_id IS NOT NULL) AND (l_osp_order_line_id <> p_osp_order_line_id)) THEN
516: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_OSP_ACCOM_ID_MISMATCH');
517: FND_MESSAGE.set_token('ACCOM_ID', p_accomplishment_id);
518: FND_MESSAGE.set_token('OSP_LINE_ID', p_osp_order_line_id);
519: FND_MSG_PUB.ADD;
520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 517: FND_MESSAGE.set_token('ACCOM_ID', p_accomplishment_id);

513:
514: -- If OSP Order Line Id is also passed, validate it to ensure that it matches the Accomplishment Id
515: IF ((p_osp_order_line_id IS NOT NULL) AND (l_osp_order_line_id <> p_osp_order_line_id)) THEN
516: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_OSP_ACCOM_ID_MISMATCH');
517: FND_MESSAGE.set_token('ACCOM_ID', p_accomplishment_id);
518: FND_MESSAGE.set_token('OSP_LINE_ID', p_osp_order_line_id);
519: FND_MSG_PUB.ADD;
520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
521: END IF;

Line 518: FND_MESSAGE.set_token('OSP_LINE_ID', p_osp_order_line_id);

514: -- If OSP Order Line Id is also passed, validate it to ensure that it matches the Accomplishment Id
515: IF ((p_osp_order_line_id IS NOT NULL) AND (l_osp_order_line_id <> p_osp_order_line_id)) THEN
516: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_OSP_ACCOM_ID_MISMATCH');
517: FND_MESSAGE.set_token('ACCOM_ID', p_accomplishment_id);
518: FND_MESSAGE.set_token('OSP_LINE_ID', p_osp_order_line_id);
519: FND_MSG_PUB.ADD;
520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
521: END IF;
522:

Line 529: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_OSP_NOT_RECEIVED');

525: FETCH get_received_quantity_csr INTO l_received_quantity;
526: CLOSE get_received_quantity_csr;
527:
528: IF (l_received_quantity IS NULL OR l_received_quantity < 1) THEN
529: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_OSP_NOT_RECEIVED');
530: FND_MSG_PUB.ADD;
531: RAISE FND_API.G_EXC_ERROR;
532: END IF;
533:

Line 539: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_OSP_MISSING_PARAMS');

535: l_accomplishment_ids_tbl(1) := p_accomplishment_id;
536: ELSE
537: -- Ensure that p_osp_order_line_id is not null.
538: IF (p_osp_order_line_id IS NULL) THEN
539: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_OSP_MISSING_PARAMS');
540: FND_MSG_PUB.ADD;
541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
542: END IF;
543:

Line 549: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_OSP_INV_OSP_LINE_ID');

545: OPEN chk_osp_line_csr(c_osp_order_line_id => p_osp_order_line_id);
546: FETCH chk_osp_line_csr INTO l_dummy;
547: IF (chk_osp_line_csr%NOTFOUND) THEN
548: CLOSE chk_osp_line_csr;
549: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_OSP_INV_OSP_LINE_ID');
550: FND_MESSAGE.set_token('OSP_LINE_ID', p_osp_order_line_id);
551: FND_MSG_PUB.ADD;
552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
553: END IF;

Line 550: FND_MESSAGE.set_token('OSP_LINE_ID', p_osp_order_line_id);

546: FETCH chk_osp_line_csr INTO l_dummy;
547: IF (chk_osp_line_csr%NOTFOUND) THEN
548: CLOSE chk_osp_line_csr;
549: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_OSP_INV_OSP_LINE_ID');
550: FND_MESSAGE.set_token('OSP_LINE_ID', p_osp_order_line_id);
551: FND_MSG_PUB.ADD;
552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
553: END IF;
554: CLOSE chk_osp_line_csr;

Line 562: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_OSP_NOT_RECIEVED');

558: FETCH get_received_quantity_csr INTO l_received_quantity;
559: CLOSE get_received_quantity_csr;
560:
561: IF (l_received_quantity IS NULL OR l_received_quantity < 1) THEN
562: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_OSP_NOT_RECIEVED');
563: FND_MSG_PUB.ADD;
564: RAISE FND_API.G_EXC_ERROR;
565: END IF;
566:

Line 574: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_OSP_NO_ACCOMS');

570: CLOSE get_accomplishments_csr;
571:
572: -- Ensure that there is at least one accomplishment to signoff
573: IF (l_accomplishment_ids_tbl.COUNT = 0) THEN
574: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_OSP_NO_ACCOMS');
575: FND_MESSAGE.set_token('OSP_LINE_ID', p_osp_order_line_id);
576: FND_MSG_PUB.ADD;
577: RAISE FND_API.G_EXC_ERROR;
578: END IF;

Line 575: FND_MESSAGE.set_token('OSP_LINE_ID', p_osp_order_line_id);

571:
572: -- Ensure that there is at least one accomplishment to signoff
573: IF (l_accomplishment_ids_tbl.COUNT = 0) THEN
574: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_OSP_NO_ACCOMS');
575: FND_MESSAGE.set_token('OSP_LINE_ID', p_osp_order_line_id);
576: FND_MSG_PUB.ADD;
577: RAISE FND_API.G_EXC_ERROR;
578: END IF;
579: END IF; -- Else (p_accomplishment_id is null)