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.AHL_OSP_ACCOMP_PVT dependencies on FND_MSG_PUB

Line 115: FND_MSG_PUB.add;

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:
119: IF (l_log_statement >= l_log_current_level) THEN

Line 129: FND_MSG_PUB.add;

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
133:

Line 493: FND_MSG_PUB.Initialize;

489: END IF;
490:
491: -- Initialize message list if p_init_msg_list is set to TRUE
492: IF FND_API.To_Boolean(p_init_msg_list) THEN
493: FND_MSG_PUB.Initialize;
494: END IF;
495:
496: -- Initialize API return status to success
497: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 509: FND_MSG_PUB.ADD;

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

Line 519: FND_MSG_PUB.ADD;

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:
523: -- Validate that the part has been received against the OSP Line

Line 530: FND_MSG_PUB.ADD;

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:
534: -- Populate a table of Numbers with the single Accomplishment Id (will have only one record)

Line 540: FND_MSG_PUB.ADD;

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:
544: -- Validate that the OSP Order Line Id is valid

Line 551: FND_MSG_PUB.ADD;

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

Line 563: FND_MSG_PUB.ADD;

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:
567: -- Populate a table of Numbers with the Id of the Open Accomplishments assigned to this OSP Line

Line 576: FND_MSG_PUB.ADD;

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)
580:

Line 681: FND_MSG_PUB.Count_And_Get

677: COMMIT WORK;
678: END IF;
679:
680: -- Standard call to get message count and if count is 1, get message info
681: FND_MSG_PUB.Count_And_Get
682: ( p_count => x_msg_count,
683: p_data => x_msg_data,
684: p_encoded => fnd_api.g_false
685: );

Line 695: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

691: EXCEPTION
692: WHEN FND_API.G_EXC_ERROR THEN
693: Rollback to accomplish_osp_mrs_pvt;
694: x_return_status := FND_API.G_RET_STS_ERROR;
695: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
696: p_data => x_msg_data,
697: p_encoded => fnd_api.g_false);
698: IF (FND_LOG.LEVEL_EXCEPTION >= l_log_current_level) THEN
699: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, L_FULL_NAME, 'Execution Exception: ' || x_msg_data);

Line 705: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

701:
702: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
703: Rollback to accomplish_osp_mrs_pvt;
704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
705: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
706: p_data => x_msg_data,
707: p_encoded => fnd_api.g_false);
708:
709: IF (FND_LOG.LEVEL_UNEXPECTED >= l_log_current_level) THEN

Line 716: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

712:
713: WHEN OTHERS THEN
714: Rollback to accomplish_osp_mrs_pvt;
715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
716: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
717: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
718: p_procedure_name => l_api_name,
719: p_error_text => SUBSTR(SQLERRM,1,500));
720: END IF;

Line 717: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

713: WHEN OTHERS THEN
714: Rollback to accomplish_osp_mrs_pvt;
715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
716: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
717: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
718: p_procedure_name => l_api_name,
719: p_error_text => SUBSTR(SQLERRM,1,500));
720: END IF;
721: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 721: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

717: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
718: p_procedure_name => l_api_name,
719: p_error_text => SUBSTR(SQLERRM,1,500));
720: END IF;
721: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
722: p_data => x_msg_data,
723: p_encoded => fnd_api.g_false);
724:
725: IF (FND_LOG.LEVEL_UNEXPECTED >= l_log_current_level) THEN