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.OKC_DELIVERABLE_WF_PVT dependencies on FND_MESSAGE

Line 53: fnd_message.clear;

49: l_msg_code := substr(document_id,1,l_divider_index-1);
50: l_del_id := substr(document_id,l_divider_index+1,length(document_id));
51:
52: --set message code
53: fnd_message.clear;
54: fnd_message.set_name(APPLICATION=>'OKC',NAME=>l_msg_code);
55:
56: --set tokens
57: OPEN deliverable_tokens_cursor;

Line 54: fnd_message.set_name(APPLICATION=>'OKC',NAME=>l_msg_code);

50: l_del_id := substr(document_id,l_divider_index+1,length(document_id));
51:
52: --set message code
53: fnd_message.clear;
54: fnd_message.set_name(APPLICATION=>'OKC',NAME=>l_msg_code);
55:
56: --set tokens
57: OPEN deliverable_tokens_cursor;
58: FETCH deliverable_tokens_cursor INTO del_tokens_rec;

Line 60: fnd_message.set_token(TOKEN => 'DELIVERABLENAME',VALUE => del_tokens_rec.deliverable_name);

56: --set tokens
57: OPEN deliverable_tokens_cursor;
58: FETCH deliverable_tokens_cursor INTO del_tokens_rec;
59: IF deliverable_tokens_cursor%FOUND THEN
60: fnd_message.set_token(TOKEN => 'DELIVERABLENAME',VALUE => del_tokens_rec.deliverable_name);
61: fnd_message.set_token(TOKEN => 'BUSDOCTYPE',VALUE => del_tokens_rec.name);
62: fnd_message.set_token(TOKEN => 'BUSDOCNUM',VALUE => del_tokens_rec.business_document_number);
63:
64: --Before due may have extra tokens

Line 61: fnd_message.set_token(TOKEN => 'BUSDOCTYPE',VALUE => del_tokens_rec.name);

57: OPEN deliverable_tokens_cursor;
58: FETCH deliverable_tokens_cursor INTO del_tokens_rec;
59: IF deliverable_tokens_cursor%FOUND THEN
60: fnd_message.set_token(TOKEN => 'DELIVERABLENAME',VALUE => del_tokens_rec.deliverable_name);
61: fnd_message.set_token(TOKEN => 'BUSDOCTYPE',VALUE => del_tokens_rec.name);
62: fnd_message.set_token(TOKEN => 'BUSDOCNUM',VALUE => del_tokens_rec.business_document_number);
63:
64: --Before due may have extra tokens
65: if l_msg_code = 'OKC_DEL_BEFOREDUE_NTF_SUBJECT' then

Line 62: fnd_message.set_token(TOKEN => 'BUSDOCNUM',VALUE => del_tokens_rec.business_document_number);

58: FETCH deliverable_tokens_cursor INTO del_tokens_rec;
59: IF deliverable_tokens_cursor%FOUND THEN
60: fnd_message.set_token(TOKEN => 'DELIVERABLENAME',VALUE => del_tokens_rec.deliverable_name);
61: fnd_message.set_token(TOKEN => 'BUSDOCTYPE',VALUE => del_tokens_rec.name);
62: fnd_message.set_token(TOKEN => 'BUSDOCNUM',VALUE => del_tokens_rec.business_document_number);
63:
64: --Before due may have extra tokens
65: if l_msg_code = 'OKC_DEL_BEFOREDUE_NTF_SUBJECT' then
66: fnd_message.set_token(TOKEN => 'AMOUNT',VALUE => del_tokens_rec.notify_prior_due_date_value);

Line 66: fnd_message.set_token(TOKEN => 'AMOUNT',VALUE => del_tokens_rec.notify_prior_due_date_value);

62: fnd_message.set_token(TOKEN => 'BUSDOCNUM',VALUE => del_tokens_rec.business_document_number);
63:
64: --Before due may have extra tokens
65: if l_msg_code = 'OKC_DEL_BEFOREDUE_NTF_SUBJECT' then
66: fnd_message.set_token(TOKEN => 'AMOUNT',VALUE => del_tokens_rec.notify_prior_due_date_value);
67:
68: select meaning into l_uom_text from fnd_lookups
69: where lookup_type = 'OKC_DELIVERABLE_TIME_UNITS'
70: and lookup_code = del_tokens_rec.notify_prior_due_date_uom;

Line 71: fnd_message.set_token(TOKEN => 'UNITS' ,VALUE => l_uom_text);

67:
68: select meaning into l_uom_text from fnd_lookups
69: where lookup_type = 'OKC_DELIVERABLE_TIME_UNITS'
70: and lookup_code = del_tokens_rec.notify_prior_due_date_uom;
71: fnd_message.set_token(TOKEN => 'UNITS' ,VALUE => l_uom_text);
72: end if; --end setting extra tokens
73: END IF;
74: CLOSE deliverable_tokens_cursor;
75:

Line 77: document:=fnd_message.get;

73: END IF;
74: CLOSE deliverable_tokens_cursor;
75:
76:
77: document:=fnd_message.get;
78:
79:
80: end get_subject_text;
81:

Line 646: FND_MESSAGE.SET_NAME('OKC', 'OKC_CREATE_ADHOC_USER_FAILED');

642: -- build concatinated list of user name for adhoc role
643: l_user_list := l_user_list||','||l_external_role_name;
644: EXCEPTION
645: WHEN OTHERS THEN
646: FND_MESSAGE.SET_NAME('OKC', 'OKC_CREATE_ADHOC_USER_FAILED');
647: FND_MESSAGE.set_token('USER_NAME',l_user_tbl(k));
648: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);
649: FND_MSG_PUB.add;
650: RAISE FND_API.G_EXC_ERROR;

Line 647: FND_MESSAGE.set_token('USER_NAME',l_user_tbl(k));

643: l_user_list := l_user_list||','||l_external_role_name;
644: EXCEPTION
645: WHEN OTHERS THEN
646: FND_MESSAGE.SET_NAME('OKC', 'OKC_CREATE_ADHOC_USER_FAILED');
647: FND_MESSAGE.set_token('USER_NAME',l_user_tbl(k));
648: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);
649: FND_MSG_PUB.add;
650: RAISE FND_API.G_EXC_ERROR;
651: END;

Line 648: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);

644: EXCEPTION
645: WHEN OTHERS THEN
646: FND_MESSAGE.SET_NAME('OKC', 'OKC_CREATE_ADHOC_USER_FAILED');
647: FND_MESSAGE.set_token('USER_NAME',l_user_tbl(k));
648: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);
649: FND_MSG_PUB.add;
650: RAISE FND_API.G_EXC_ERROR;
651: END;
652: END LOOP;

Line 679: FND_MESSAGE.SET_NAME('OKC','OKC_CREATE_ADHOC_ROLE_FAILED');

675: owner_tag => null
676: );
677: EXCEPTION
678: WHEN OTHERS THEN
679: FND_MESSAGE.SET_NAME('OKC','OKC_CREATE_ADHOC_ROLE_FAILED');
680: FND_MESSAGE.set_token('ROLE_NAME',l_external_role_name);
681: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);
682: FND_MSG_PUB.add;
683: RAISE FND_API.G_EXC_ERROR;

Line 680: FND_MESSAGE.set_token('ROLE_NAME',l_external_role_name);

676: );
677: EXCEPTION
678: WHEN OTHERS THEN
679: FND_MESSAGE.SET_NAME('OKC','OKC_CREATE_ADHOC_ROLE_FAILED');
680: FND_MESSAGE.set_token('ROLE_NAME',l_external_role_name);
681: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);
682: FND_MSG_PUB.add;
683: RAISE FND_API.G_EXC_ERROR;
684: END;

Line 681: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);

677: EXCEPTION
678: WHEN OTHERS THEN
679: FND_MESSAGE.SET_NAME('OKC','OKC_CREATE_ADHOC_ROLE_FAILED');
680: FND_MESSAGE.set_token('ROLE_NAME',l_external_role_name);
681: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);
682: FND_MSG_PUB.add;
683: RAISE FND_API.G_EXC_ERROR;
684: END;
685:

Line 723: FND_MESSAGE.SET_NAME('OKC','OKC_CREATE_ADHOC_ROLE_FAILED');

719: owner_tag => null);
720:
721: EXCEPTION
722: WHEN OTHERS THEN
723: FND_MESSAGE.SET_NAME('OKC','OKC_CREATE_ADHOC_ROLE_FAILED');
724: FND_MESSAGE.set_token('ROLE_NAME',l_external_role_name);
725: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);
726: FND_MSG_PUB.add;
727: RAISE FND_API.G_EXC_ERROR;

Line 724: FND_MESSAGE.set_token('ROLE_NAME',l_external_role_name);

720:
721: EXCEPTION
722: WHEN OTHERS THEN
723: FND_MESSAGE.SET_NAME('OKC','OKC_CREATE_ADHOC_ROLE_FAILED');
724: FND_MESSAGE.set_token('ROLE_NAME',l_external_role_name);
725: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);
726: FND_MSG_PUB.add;
727: RAISE FND_API.G_EXC_ERROR;
728: END;

Line 725: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);

721: EXCEPTION
722: WHEN OTHERS THEN
723: FND_MESSAGE.SET_NAME('OKC','OKC_CREATE_ADHOC_ROLE_FAILED');
724: FND_MESSAGE.set_token('ROLE_NAME',l_external_role_name);
725: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);
726: FND_MSG_PUB.add;
727: RAISE FND_API.G_EXC_ERROR;
728: END;
729:

Line 882: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'142: Subject of notification:'||fnd_message.get);

878: RAISE OKC_API.G_EXCEPTION_ERROR;
879: END IF;
880:
881: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
882: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'142: Subject of notification:'||fnd_message.get);
883: END IF;
884:
885: --logic to get the notification id for the OUT parameter
886: IF l_internal_only = 'Y' THEN