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 59: fnd_message.clear;

55: l_msg_code := substr(document_id,1,l_divider_index-1);
56: l_del_id := substr(document_id,l_divider_index+1,length(document_id));
57:
58: --set message code
59: fnd_message.clear;
60: fnd_message.set_name(APPLICATION=>'OKC',NAME=>l_msg_code);
61:
62: --set tokens
63: OPEN deliverable_tokens_cursor;

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

56: l_del_id := substr(document_id,l_divider_index+1,length(document_id));
57:
58: --set message code
59: fnd_message.clear;
60: fnd_message.set_name(APPLICATION=>'OKC',NAME=>l_msg_code);
61:
62: --set tokens
63: OPEN deliverable_tokens_cursor;
64: FETCH deliverable_tokens_cursor INTO del_tokens_rec;

Line 71: fnd_message.set_name(APPLICATION=>'OKC', NAME=>l_resolved_msg_name);

67: --Acq Plan Message Cleanup
68: l_resolved_msg_name := OKC_API.resolve_message(l_msg_code, del_tokens_rec.document_type);
69: l_resolved_token := OKC_API.resolve_del_token(del_tokens_rec.document_type);
70:
71: fnd_message.set_name(APPLICATION=>'OKC', NAME=>l_resolved_msg_name);
72: fnd_message.set_token(TOKEN => 'DEL_TOKEN',VALUE => l_resolved_token);
73: fnd_message.set_token(TOKEN => 'DELIVERABLENAME',VALUE => del_tokens_rec.deliverable_name);
74: fnd_message.set_token(TOKEN => 'BUSDOCTYPE',VALUE => del_tokens_rec.name);
75: fnd_message.set_token(TOKEN => 'BUSDOCNUM',VALUE => del_tokens_rec.business_document_number);

Line 72: fnd_message.set_token(TOKEN => 'DEL_TOKEN',VALUE => l_resolved_token);

68: l_resolved_msg_name := OKC_API.resolve_message(l_msg_code, del_tokens_rec.document_type);
69: l_resolved_token := OKC_API.resolve_del_token(del_tokens_rec.document_type);
70:
71: fnd_message.set_name(APPLICATION=>'OKC', NAME=>l_resolved_msg_name);
72: fnd_message.set_token(TOKEN => 'DEL_TOKEN',VALUE => l_resolved_token);
73: fnd_message.set_token(TOKEN => 'DELIVERABLENAME',VALUE => del_tokens_rec.deliverable_name);
74: fnd_message.set_token(TOKEN => 'BUSDOCTYPE',VALUE => del_tokens_rec.name);
75: fnd_message.set_token(TOKEN => 'BUSDOCNUM',VALUE => del_tokens_rec.business_document_number);
76:

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

69: l_resolved_token := OKC_API.resolve_del_token(del_tokens_rec.document_type);
70:
71: fnd_message.set_name(APPLICATION=>'OKC', NAME=>l_resolved_msg_name);
72: fnd_message.set_token(TOKEN => 'DEL_TOKEN',VALUE => l_resolved_token);
73: fnd_message.set_token(TOKEN => 'DELIVERABLENAME',VALUE => del_tokens_rec.deliverable_name);
74: fnd_message.set_token(TOKEN => 'BUSDOCTYPE',VALUE => del_tokens_rec.name);
75: fnd_message.set_token(TOKEN => 'BUSDOCNUM',VALUE => del_tokens_rec.business_document_number);
76:
77: --Before due may have extra tokens

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

70:
71: fnd_message.set_name(APPLICATION=>'OKC', NAME=>l_resolved_msg_name);
72: fnd_message.set_token(TOKEN => 'DEL_TOKEN',VALUE => l_resolved_token);
73: fnd_message.set_token(TOKEN => 'DELIVERABLENAME',VALUE => del_tokens_rec.deliverable_name);
74: fnd_message.set_token(TOKEN => 'BUSDOCTYPE',VALUE => del_tokens_rec.name);
75: fnd_message.set_token(TOKEN => 'BUSDOCNUM',VALUE => del_tokens_rec.business_document_number);
76:
77: --Before due may have extra tokens
78: --if l_msg_code = 'OKC_DEL_BEFOREDUE_NTF_SUBJECT' THEN

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

71: fnd_message.set_name(APPLICATION=>'OKC', NAME=>l_resolved_msg_name);
72: fnd_message.set_token(TOKEN => 'DEL_TOKEN',VALUE => l_resolved_token);
73: fnd_message.set_token(TOKEN => 'DELIVERABLENAME',VALUE => del_tokens_rec.deliverable_name);
74: fnd_message.set_token(TOKEN => 'BUSDOCTYPE',VALUE => del_tokens_rec.name);
75: fnd_message.set_token(TOKEN => 'BUSDOCNUM',VALUE => del_tokens_rec.business_document_number);
76:
77: --Before due may have extra tokens
78: --if l_msg_code = 'OKC_DEL_BEFOREDUE_NTF_SUBJECT' THEN
79: if l_msg_code = 'OKC_DEL_BEFOREDUE_NTF_SUBJECT' THEN

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

77: --Before due may have extra tokens
78: --if l_msg_code = 'OKC_DEL_BEFOREDUE_NTF_SUBJECT' THEN
79: if l_msg_code = 'OKC_DEL_BEFOREDUE_NTF_SUBJECT' THEN
80:
81: fnd_message.set_token(TOKEN => 'AMOUNT',VALUE => del_tokens_rec.notify_prior_due_date_value);
82:
83: select meaning into l_uom_text from fnd_lookups
84: where lookup_type = 'OKC_DELIVERABLE_TIME_UNITS'
85: and lookup_code = del_tokens_rec.notify_prior_due_date_uom;

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

82:
83: select meaning into l_uom_text from fnd_lookups
84: where lookup_type = 'OKC_DELIVERABLE_TIME_UNITS'
85: and lookup_code = del_tokens_rec.notify_prior_due_date_uom;
86: fnd_message.set_token(TOKEN => 'UNITS' ,VALUE => l_uom_text);
87: end if; --end setting extra tokens for okc_del_beforedue_ntf_subject
88: END IF; --deliverable_tokens_cursor%FOUND
89: CLOSE deliverable_tokens_cursor;
90:

Line 92: document:=fnd_message.get;

88: END IF; --deliverable_tokens_cursor%FOUND
89: CLOSE deliverable_tokens_cursor;
90:
91:
92: document:=fnd_message.get;
93:
94:
95: end get_subject_text;
96:

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

708: -- build concatinated list of user name for adhoc role
709: l_user_list := l_user_list||','||l_external_role_name;
710: EXCEPTION
711: WHEN OTHERS THEN
712: FND_MESSAGE.SET_NAME('OKC', 'OKC_CREATE_ADHOC_USER_FAILED');
713: FND_MESSAGE.set_token('USER_NAME',l_user_tbl(k));
714: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);
715: FND_MSG_PUB.add;
716: RAISE FND_API.G_EXC_ERROR;

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

709: l_user_list := l_user_list||','||l_external_role_name;
710: EXCEPTION
711: WHEN OTHERS THEN
712: FND_MESSAGE.SET_NAME('OKC', 'OKC_CREATE_ADHOC_USER_FAILED');
713: FND_MESSAGE.set_token('USER_NAME',l_user_tbl(k));
714: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);
715: FND_MSG_PUB.add;
716: RAISE FND_API.G_EXC_ERROR;
717: END;

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

710: EXCEPTION
711: WHEN OTHERS THEN
712: FND_MESSAGE.SET_NAME('OKC', 'OKC_CREATE_ADHOC_USER_FAILED');
713: FND_MESSAGE.set_token('USER_NAME',l_user_tbl(k));
714: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);
715: FND_MSG_PUB.add;
716: RAISE FND_API.G_EXC_ERROR;
717: END;
718: END LOOP;

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

741: owner_tag => null
742: );
743: EXCEPTION
744: WHEN OTHERS THEN
745: FND_MESSAGE.SET_NAME('OKC','OKC_CREATE_ADHOC_ROLE_FAILED');
746: FND_MESSAGE.set_token('ROLE_NAME',l_external_role_name);
747: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);
748: FND_MSG_PUB.add;
749: RAISE FND_API.G_EXC_ERROR;

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

742: );
743: EXCEPTION
744: WHEN OTHERS THEN
745: FND_MESSAGE.SET_NAME('OKC','OKC_CREATE_ADHOC_ROLE_FAILED');
746: FND_MESSAGE.set_token('ROLE_NAME',l_external_role_name);
747: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);
748: FND_MSG_PUB.add;
749: RAISE FND_API.G_EXC_ERROR;
750: END;

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

743: EXCEPTION
744: WHEN OTHERS THEN
745: FND_MESSAGE.SET_NAME('OKC','OKC_CREATE_ADHOC_ROLE_FAILED');
746: FND_MESSAGE.set_token('ROLE_NAME',l_external_role_name);
747: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);
748: FND_MSG_PUB.add;
749: RAISE FND_API.G_EXC_ERROR;
750: END;
751:

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

785: owner_tag => null);
786:
787: EXCEPTION
788: WHEN OTHERS THEN
789: FND_MESSAGE.SET_NAME('OKC','OKC_CREATE_ADHOC_ROLE_FAILED');
790: FND_MESSAGE.set_token('ROLE_NAME',l_external_role_name);
791: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);
792: FND_MSG_PUB.add;
793: RAISE FND_API.G_EXC_ERROR;

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

786:
787: EXCEPTION
788: WHEN OTHERS THEN
789: FND_MESSAGE.SET_NAME('OKC','OKC_CREATE_ADHOC_ROLE_FAILED');
790: FND_MESSAGE.set_token('ROLE_NAME',l_external_role_name);
791: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);
792: FND_MSG_PUB.add;
793: RAISE FND_API.G_EXC_ERROR;
794: END;

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

787: EXCEPTION
788: WHEN OTHERS THEN
789: FND_MESSAGE.SET_NAME('OKC','OKC_CREATE_ADHOC_ROLE_FAILED');
790: FND_MESSAGE.set_token('ROLE_NAME',l_external_role_name);
791: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);
792: FND_MSG_PUB.add;
793: RAISE FND_API.G_EXC_ERROR;
794: END;
795:

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

1019: RAISE OKC_API.G_EXCEPTION_ERROR;
1020: END IF;
1021:
1022: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1023: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'142: Subject of notification:'||fnd_message.get);
1024: END IF;
1025:
1026: --logic to get the notification id for the OUT parameter
1027: IF l_internal_only = 'Y' THEN