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.OKL_TMG_PVT dependencies on FND_NEW_MESSAGES

Line 519: CURSOR fnd_new_messages_pk_csr (p_application_id IN NUMBER,

515: FROM Okl_Billing_Charges_V
516: WHERE okl_billing_charges_v.id = p_id;
517: l_okl_tmgv_bchv_fk okl_tmgv_bchv_fk_csr%ROWTYPE;
518:
519: CURSOR fnd_new_messages_pk_csr (p_application_id IN NUMBER,
520: p_message_name IN VARCHAR2,
521: p_language_code IN VARCHAR2) IS
522: SELECT 'x'
523: FROM Fnd_New_Messages

Line 523: FROM Fnd_New_Messages

519: CURSOR fnd_new_messages_pk_csr (p_application_id IN NUMBER,
520: p_message_name IN VARCHAR2,
521: p_language_code IN VARCHAR2) IS
522: SELECT 'x'
523: FROM Fnd_New_Messages
524: WHERE fnd_new_messages.application_id = p_application_id
525: AND fnd_new_messages.message_name = p_message_name
526: AND fnd_new_messages.language_code = p_language_code;
527: l_fnd_new_messages_pk fnd_new_messages_pk_csr%ROWTYPE;

Line 524: WHERE fnd_new_messages.application_id = p_application_id

520: p_message_name IN VARCHAR2,
521: p_language_code IN VARCHAR2) IS
522: SELECT 'x'
523: FROM Fnd_New_Messages
524: WHERE fnd_new_messages.application_id = p_application_id
525: AND fnd_new_messages.message_name = p_message_name
526: AND fnd_new_messages.language_code = p_language_code;
527: l_fnd_new_messages_pk fnd_new_messages_pk_csr%ROWTYPE;
528:

Line 525: AND fnd_new_messages.message_name = p_message_name

521: p_language_code IN VARCHAR2) IS
522: SELECT 'x'
523: FROM Fnd_New_Messages
524: WHERE fnd_new_messages.application_id = p_application_id
525: AND fnd_new_messages.message_name = p_message_name
526: AND fnd_new_messages.language_code = p_language_code;
527: l_fnd_new_messages_pk fnd_new_messages_pk_csr%ROWTYPE;
528:
529: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 526: AND fnd_new_messages.language_code = p_language_code;

522: SELECT 'x'
523: FROM Fnd_New_Messages
524: WHERE fnd_new_messages.application_id = p_application_id
525: AND fnd_new_messages.message_name = p_message_name
526: AND fnd_new_messages.language_code = p_language_code;
527: l_fnd_new_messages_pk fnd_new_messages_pk_csr%ROWTYPE;
528:
529: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
530: l_row_notfound BOOLEAN := TRUE;

Line 527: l_fnd_new_messages_pk fnd_new_messages_pk_csr%ROWTYPE;

523: FROM Fnd_New_Messages
524: WHERE fnd_new_messages.application_id = p_application_id
525: AND fnd_new_messages.message_name = p_message_name
526: AND fnd_new_messages.language_code = p_language_code;
527: l_fnd_new_messages_pk fnd_new_messages_pk_csr%ROWTYPE;
528:
529: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
530: l_row_notfound BOOLEAN := TRUE;
531: BEGIN

Line 540: OPEN fnd_new_messages_pk_csr (p_tmgv_rec.TMG_APPLICATION_ID,

536: ((p_tmgv_rec.TMG_APPLICATION_ID <> p_db_tmgv_rec.TMG_APPLICATION_ID) OR
537: (p_tmgv_rec.TMG_LANGUAGE_CODE <> p_db_tmgv_rec.TMG_LANGUAGE_CODE) OR
538: (p_tmgv_rec.TMG_MESSAGE_NAME <> p_db_tmgv_rec.TMG_MESSAGE_NAME)))
539: THEN
540: OPEN fnd_new_messages_pk_csr (p_tmgv_rec.TMG_APPLICATION_ID,
541: p_tmgv_rec.TMG_MESSAGE_NAME,
542: p_tmgv_rec.TMG_LANGUAGE_CODE);
543: FETCH fnd_new_messages_pk_csr INTO l_fnd_new_messages_pk;
544: l_row_notfound := fnd_new_messages_pk_csr%NOTFOUND;

Line 543: FETCH fnd_new_messages_pk_csr INTO l_fnd_new_messages_pk;

539: THEN
540: OPEN fnd_new_messages_pk_csr (p_tmgv_rec.TMG_APPLICATION_ID,
541: p_tmgv_rec.TMG_MESSAGE_NAME,
542: p_tmgv_rec.TMG_LANGUAGE_CODE);
543: FETCH fnd_new_messages_pk_csr INTO l_fnd_new_messages_pk;
544: l_row_notfound := fnd_new_messages_pk_csr%NOTFOUND;
545: CLOSE fnd_new_messages_pk_csr;
546: IF (l_row_notfound) THEN
547: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TMG_APPLICATION_ID');

Line 544: l_row_notfound := fnd_new_messages_pk_csr%NOTFOUND;

540: OPEN fnd_new_messages_pk_csr (p_tmgv_rec.TMG_APPLICATION_ID,
541: p_tmgv_rec.TMG_MESSAGE_NAME,
542: p_tmgv_rec.TMG_LANGUAGE_CODE);
543: FETCH fnd_new_messages_pk_csr INTO l_fnd_new_messages_pk;
544: l_row_notfound := fnd_new_messages_pk_csr%NOTFOUND;
545: CLOSE fnd_new_messages_pk_csr;
546: IF (l_row_notfound) THEN
547: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TMG_APPLICATION_ID');
548: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TMG_MESSAGE_NAME');

Line 545: CLOSE fnd_new_messages_pk_csr;

541: p_tmgv_rec.TMG_MESSAGE_NAME,
542: p_tmgv_rec.TMG_LANGUAGE_CODE);
543: FETCH fnd_new_messages_pk_csr INTO l_fnd_new_messages_pk;
544: l_row_notfound := fnd_new_messages_pk_csr%NOTFOUND;
545: CLOSE fnd_new_messages_pk_csr;
546: IF (l_row_notfound) THEN
547: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TMG_APPLICATION_ID');
548: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TMG_MESSAGE_NAME');
549: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TMG_LANGUAGE_CODE');