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 OKC_API

Line 68: l_resolved_msg_name := OKC_API.resolve_message(l_msg_code, del_tokens_rec.document_type);

64: FETCH deliverable_tokens_cursor INTO del_tokens_rec;
65: IF deliverable_tokens_cursor%FOUND THEN
66:
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);

Line 69: l_resolved_token := OKC_API.resolve_del_token(del_tokens_rec.document_type);

65: IF deliverable_tokens_cursor%FOUND THEN
66:
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);

Line 444: OKC_API.init_msg_list(p_init_msg_list=>p_init_msg_list);

440: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'105: BusDocId:'||p_business_document_id);
441: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'106: BusDocType:'||p_business_document_type);
442: END IF;
443:
444: OKC_API.init_msg_list(p_init_msg_list=>p_init_msg_list);
445:
446: --Get item key from sequence
447: select to_char(okc_wf_notify_s1.nextval) into l_item_key from dual;
448:

Line 479: l_resolved_msg_name1 := OKC_API.resolve_message('OKC_DEL_ESCALATE_NTF_SUBJECT',p_business_document_type);

475: IF instr(p_deliverable_type,'INTERNAL')<>0 then
476: l_internal_deliverable_type := 'Y';
477: END IF; --internal deliv type
478: ------------------------------------------------------------------------------------*/
479: l_resolved_msg_name1 := OKC_API.resolve_message('OKC_DEL_ESCALATE_NTF_SUBJECT',p_business_document_type);
480: l_resolved_msg_name2 := OKC_API.resolve_message('OKC_DEL_BEFOREDUE_NTF_SUBJECT',p_business_document_type);
481:
482: IF l_internal_deliverable_type = 'Y' OR
483: --p_msg_code = 'OKC_DEL_ESCALATE_NTF_SUBJECT' OR

Line 480: l_resolved_msg_name2 := OKC_API.resolve_message('OKC_DEL_BEFOREDUE_NTF_SUBJECT',p_business_document_type);

476: l_internal_deliverable_type := 'Y';
477: END IF; --internal deliv type
478: ------------------------------------------------------------------------------------*/
479: l_resolved_msg_name1 := OKC_API.resolve_message('OKC_DEL_ESCALATE_NTF_SUBJECT',p_business_document_type);
480: l_resolved_msg_name2 := OKC_API.resolve_message('OKC_DEL_BEFOREDUE_NTF_SUBJECT',p_business_document_type);
481:
482: IF l_internal_deliverable_type = 'Y' OR
483: --p_msg_code = 'OKC_DEL_ESCALATE_NTF_SUBJECT' OR
484: -- (p_msg_code = 'OKC_DEL_BEFOREDUE_NTF_SUBJECT' and l_resp_party_code = 'INTERNAL_ORG') then

Line 494: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_COMPLETE_NTF_SUBJECT',p_business_document_type);

490: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
491: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'107: Send to internal users only: '||l_internal_only);
492: END IF;
493:
494: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_COMPLETE_NTF_SUBJECT',p_business_document_type);
495: l_resolved_msg_name6 := OKC_API.resolve_message('OKC_DEL_CANCEL_NTF_SUBJECT',p_business_document_type);
496: l_resolved_msg_name7 := OKC_API.resolve_message('OKC_DEL_FAILED_NTF_SUBJECT',p_business_document_type);
497: l_resolved_msg_name8 := OKC_API.resolve_message('OKC_DEL_SUBMIT_NTF_SUBJECT',p_business_document_type);
498:

Line 495: l_resolved_msg_name6 := OKC_API.resolve_message('OKC_DEL_CANCEL_NTF_SUBJECT',p_business_document_type);

491: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'107: Send to internal users only: '||l_internal_only);
492: END IF;
493:
494: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_COMPLETE_NTF_SUBJECT',p_business_document_type);
495: l_resolved_msg_name6 := OKC_API.resolve_message('OKC_DEL_CANCEL_NTF_SUBJECT',p_business_document_type);
496: l_resolved_msg_name7 := OKC_API.resolve_message('OKC_DEL_FAILED_NTF_SUBJECT',p_business_document_type);
497: l_resolved_msg_name8 := OKC_API.resolve_message('OKC_DEL_SUBMIT_NTF_SUBJECT',p_business_document_type);
498:
499: --check if supplier gets FYI (he cant respond)

Line 496: l_resolved_msg_name7 := OKC_API.resolve_message('OKC_DEL_FAILED_NTF_SUBJECT',p_business_document_type);

492: END IF;
493:
494: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_COMPLETE_NTF_SUBJECT',p_business_document_type);
495: l_resolved_msg_name6 := OKC_API.resolve_message('OKC_DEL_CANCEL_NTF_SUBJECT',p_business_document_type);
496: l_resolved_msg_name7 := OKC_API.resolve_message('OKC_DEL_FAILED_NTF_SUBJECT',p_business_document_type);
497: l_resolved_msg_name8 := OKC_API.resolve_message('OKC_DEL_SUBMIT_NTF_SUBJECT',p_business_document_type);
498:
499: --check if supplier gets FYI (he cant respond)
500: IF l_internal_only = 'N' and

Line 497: l_resolved_msg_name8 := OKC_API.resolve_message('OKC_DEL_SUBMIT_NTF_SUBJECT',p_business_document_type);

493:
494: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_COMPLETE_NTF_SUBJECT',p_business_document_type);
495: l_resolved_msg_name6 := OKC_API.resolve_message('OKC_DEL_CANCEL_NTF_SUBJECT',p_business_document_type);
496: l_resolved_msg_name7 := OKC_API.resolve_message('OKC_DEL_FAILED_NTF_SUBJECT',p_business_document_type);
497: l_resolved_msg_name8 := OKC_API.resolve_message('OKC_DEL_SUBMIT_NTF_SUBJECT',p_business_document_type);
498:
499: --check if supplier gets FYI (he cant respond)
500: IF l_internal_only = 'N' and
501: (p_msg_code = 'OKC_DEL_COMPLETE_NTF_SUBJECT' OR

Line 653: Okc_Api.Set_Message(p_app_name=>G_APP_NAME,

649: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'123: ERROR finding External Users List');
650: END IF;
651: l_ext_contact_error :='Y';
652:
653: Okc_Api.Set_Message(p_app_name=>G_APP_NAME,
654: p_msg_name=>'OKC_DEL_NTF_EXT_USER_NOT_FOUND',
655: p_token1 => 'BUSDOCTYPE',
656: p_token1_value => l_busdoctype_meaning,
657: p_token2 => 'BUSDOCNUM',

Line 813: Okc_Api.Set_Message(p_app_name=>G_APP_NAME,

809: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
810: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'134: External Contact and External List Function BOTH are NULL, Error = '||l_ext_contact_error);
811: END IF;
812:
813: Okc_Api.Set_Message(p_app_name=>G_APP_NAME,
814: p_msg_name=>'OKC_DEL_NTF_EXT_USER_NOT_FOUND',
815: p_token1 => 'BUSDOCTYPE',
816: p_token1_value => l_busdoctype_meaning,
817: p_token2 => 'BUSDOCNUM',

Line 833: Okc_Api.Set_Message(G_APP_NAME,'OKC_DEL_NTF_INT_USER_NO_EMAIL');

829: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'136: Internal Contact Role Display Name = '||l_int_role_display_name);
830: END IF;
831:
832: IF l_internal_role_name IS NULL THEN
833: Okc_Api.Set_Message(G_APP_NAME,'OKC_DEL_NTF_INT_USER_NO_EMAIL');
834: x_return_status := G_RET_STS_ERROR;
835: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
836: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'137: Invalid Internal contact Id (no email), raising error');
837: END IF;

Line 839: RAISE OKC_API.G_EXCEPTION_ERROR;

835: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
836: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'137: Invalid Internal contact Id (no email), raising error');
837: END IF;
838:
839: RAISE OKC_API.G_EXCEPTION_ERROR;
840: END IF; --end internal user not found
841:
842: l_requester_role_name := get_internal_user_role(p_requester_id, l_req_role_display_name);
843: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 850: l_resolved_msg_name1 := OKC_API.resolve_message('OKC_DEL_OVERDUE_NTF_SUBJECT',p_business_document_type);

846: END IF;
847:
848:
849: --Acq Plan Message Cleanup
850: l_resolved_msg_name1 := OKC_API.resolve_message('OKC_DEL_OVERDUE_NTF_SUBJECT',p_business_document_type);
851: l_resolved_msg_name2 := OKC_API.resolve_message('OKC_DEL_BEFOREDUE_NTF_SUBJECT',p_business_document_type);
852: l_resolved_msg_name3 := OKC_API.resolve_message('OKC_DEL_ESCALATE_NTF_SUBJECT',p_business_document_type);
853: l_resolved_msg_name4 := OKC_API.resolve_message('OKC_DEL_REOPEN_NTF_SUBJECT',p_business_document_type);
854: l_resolved_msg_name5 := OKC_API.resolve_message('OKC_DEL_REJECT_NTF_SUBJECT',p_business_document_type);

Line 851: l_resolved_msg_name2 := OKC_API.resolve_message('OKC_DEL_BEFOREDUE_NTF_SUBJECT',p_business_document_type);

847:
848:
849: --Acq Plan Message Cleanup
850: l_resolved_msg_name1 := OKC_API.resolve_message('OKC_DEL_OVERDUE_NTF_SUBJECT',p_business_document_type);
851: l_resolved_msg_name2 := OKC_API.resolve_message('OKC_DEL_BEFOREDUE_NTF_SUBJECT',p_business_document_type);
852: l_resolved_msg_name3 := OKC_API.resolve_message('OKC_DEL_ESCALATE_NTF_SUBJECT',p_business_document_type);
853: l_resolved_msg_name4 := OKC_API.resolve_message('OKC_DEL_REOPEN_NTF_SUBJECT',p_business_document_type);
854: l_resolved_msg_name5 := OKC_API.resolve_message('OKC_DEL_REJECT_NTF_SUBJECT',p_business_document_type);
855:

Line 852: l_resolved_msg_name3 := OKC_API.resolve_message('OKC_DEL_ESCALATE_NTF_SUBJECT',p_business_document_type);

848:
849: --Acq Plan Message Cleanup
850: l_resolved_msg_name1 := OKC_API.resolve_message('OKC_DEL_OVERDUE_NTF_SUBJECT',p_business_document_type);
851: l_resolved_msg_name2 := OKC_API.resolve_message('OKC_DEL_BEFOREDUE_NTF_SUBJECT',p_business_document_type);
852: l_resolved_msg_name3 := OKC_API.resolve_message('OKC_DEL_ESCALATE_NTF_SUBJECT',p_business_document_type);
853: l_resolved_msg_name4 := OKC_API.resolve_message('OKC_DEL_REOPEN_NTF_SUBJECT',p_business_document_type);
854: l_resolved_msg_name5 := OKC_API.resolve_message('OKC_DEL_REJECT_NTF_SUBJECT',p_business_document_type);
855:
856: --Logic to determine which workflow process to choose

Line 853: l_resolved_msg_name4 := OKC_API.resolve_message('OKC_DEL_REOPEN_NTF_SUBJECT',p_business_document_type);

849: --Acq Plan Message Cleanup
850: l_resolved_msg_name1 := OKC_API.resolve_message('OKC_DEL_OVERDUE_NTF_SUBJECT',p_business_document_type);
851: l_resolved_msg_name2 := OKC_API.resolve_message('OKC_DEL_BEFOREDUE_NTF_SUBJECT',p_business_document_type);
852: l_resolved_msg_name3 := OKC_API.resolve_message('OKC_DEL_ESCALATE_NTF_SUBJECT',p_business_document_type);
853: l_resolved_msg_name4 := OKC_API.resolve_message('OKC_DEL_REOPEN_NTF_SUBJECT',p_business_document_type);
854: l_resolved_msg_name5 := OKC_API.resolve_message('OKC_DEL_REJECT_NTF_SUBJECT',p_business_document_type);
855:
856: --Logic to determine which workflow process to choose
857: if l_internal_deliverable_type = 'Y' OR l_ext_contact_error = 'Y' OR

Line 854: l_resolved_msg_name5 := OKC_API.resolve_message('OKC_DEL_REJECT_NTF_SUBJECT',p_business_document_type);

850: l_resolved_msg_name1 := OKC_API.resolve_message('OKC_DEL_OVERDUE_NTF_SUBJECT',p_business_document_type);
851: l_resolved_msg_name2 := OKC_API.resolve_message('OKC_DEL_BEFOREDUE_NTF_SUBJECT',p_business_document_type);
852: l_resolved_msg_name3 := OKC_API.resolve_message('OKC_DEL_ESCALATE_NTF_SUBJECT',p_business_document_type);
853: l_resolved_msg_name4 := OKC_API.resolve_message('OKC_DEL_REOPEN_NTF_SUBJECT',p_business_document_type);
854: l_resolved_msg_name5 := OKC_API.resolve_message('OKC_DEL_REJECT_NTF_SUBJECT',p_business_document_type);
855:
856: --Logic to determine which workflow process to choose
857: if l_internal_deliverable_type = 'Y' OR l_ext_contact_error = 'Y' OR
858: -- p_msg_code = 'OKC_DEL_ESCALATE_NTF_SUBJECT' then

Line 1019: RAISE OKC_API.G_EXCEPTION_ERROR;

1015: itemkey => l_item_key);
1016:
1017: --Even though we've sent notifications already, if there was an error with the external contact, we want to send an error notification.
1018: IF l_ext_contact_error = 'Y' THEN
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);

Line 1059: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1055:
1056: FND_FILE.PUT_LINE(FND_FILE.LOG,'Returning notification Id: '||to_char(x_notification_id));
1057: FND_FILE.PUT_LINE(FND_FILE.LOG,'Notifier returning status: '||x_return_status);
1058: ELSE
1059: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1060: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1061: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'145: null notification ID');
1062: END IF;
1063: END IF; --end check notification id

Line 1559: l_resolved_del_token := OKC_API.resolve_del_token(l_bus_doc_type);

1555: l_int_contact_name := substr(document_id, l_fourthcolon + 1, l_fifthcolon - l_fourthcolon - 1);
1556: l_ext_contact_name := substr(document_id, l_fifthcolon + 1, length(document_id) - l_fifthcolon);
1557:
1558: --getting messages to print the prompts of the deliverable details
1559: l_resolved_del_token := OKC_API.resolve_del_token(l_bus_doc_type);
1560:
1561: --Deliverable Name
1562: l_resolved_msg_name := OKC_API.resolve_message('OKC_REP_WF_DEL_NAME', l_bus_doc_type);
1563: l_del_name_msg := OKC_TERMS_UTIL_PVT.Get_Message(p_app_name => 'OKC',

Line 1562: l_resolved_msg_name := OKC_API.resolve_message('OKC_REP_WF_DEL_NAME', l_bus_doc_type);

1558: --getting messages to print the prompts of the deliverable details
1559: l_resolved_del_token := OKC_API.resolve_del_token(l_bus_doc_type);
1560:
1561: --Deliverable Name
1562: l_resolved_msg_name := OKC_API.resolve_message('OKC_REP_WF_DEL_NAME', l_bus_doc_type);
1563: l_del_name_msg := OKC_TERMS_UTIL_PVT.Get_Message(p_app_name => 'OKC',
1564: p_msg_name => l_resolved_msg_name,
1565: p_token1 => 'DEL_TOKEN',
1566: p_token1_value => l_resolved_del_token);

Line 1569: l_resolved_msg_name := OKC_API.resolve_message('OKC_REP_WF_DEL_TYPE', l_bus_doc_type);

1565: p_token1 => 'DEL_TOKEN',
1566: p_token1_value => l_resolved_del_token);
1567:
1568: --Deliverable Type
1569: l_resolved_msg_name := OKC_API.resolve_message('OKC_REP_WF_DEL_TYPE', l_bus_doc_type);
1570: l_del_type_msg := OKC_TERMS_UTIL_PVT.Get_Message(p_app_name => 'OKC',
1571: p_msg_name => l_resolved_msg_name,
1572: p_token1 => 'DEL_TOKEN',
1573: p_token1_value => l_resolved_del_token);

Line 1576: l_resolved_msg_name := OKC_API.resolve_message('OKC_REP_WF_RESP_PARTY', l_bus_doc_type);

1572: p_token1 => 'DEL_TOKEN',
1573: p_token1_value => l_resolved_del_token);
1574:
1575: --Responsible Party
1576: l_resolved_msg_name := OKC_API.resolve_message('OKC_REP_WF_RESP_PARTY', l_bus_doc_type);
1577: l_resp_party_msg := OKC_TERMS_UTIL_PVT.Get_Message(p_app_name => 'OKC',p_msg_name => l_resolved_msg_name);
1578:
1579: --Internal Contact Name
1580: l_resolved_msg_name := OKC_API.resolve_message('OKC_REP_WF_INT_CONTACT', l_bus_doc_type);

Line 1580: l_resolved_msg_name := OKC_API.resolve_message('OKC_REP_WF_INT_CONTACT', l_bus_doc_type);

1576: l_resolved_msg_name := OKC_API.resolve_message('OKC_REP_WF_RESP_PARTY', l_bus_doc_type);
1577: l_resp_party_msg := OKC_TERMS_UTIL_PVT.Get_Message(p_app_name => 'OKC',p_msg_name => l_resolved_msg_name);
1578:
1579: --Internal Contact Name
1580: l_resolved_msg_name := OKC_API.resolve_message('OKC_REP_WF_INT_CONTACT', l_bus_doc_type);
1581: l_int_contact_msg := OKC_TERMS_UTIL_PVT.Get_Message(p_app_name => 'OKC', p_msg_name => l_resolved_msg_name);
1582:
1583: --External Contact Name
1584: l_resolved_msg_name := OKC_API.resolve_message('OKC_REP_WF_EXT_CONTACT', l_bus_doc_type);

Line 1584: l_resolved_msg_name := OKC_API.resolve_message('OKC_REP_WF_EXT_CONTACT', l_bus_doc_type);

1580: l_resolved_msg_name := OKC_API.resolve_message('OKC_REP_WF_INT_CONTACT', l_bus_doc_type);
1581: l_int_contact_msg := OKC_TERMS_UTIL_PVT.Get_Message(p_app_name => 'OKC', p_msg_name => l_resolved_msg_name);
1582:
1583: --External Contact Name
1584: l_resolved_msg_name := OKC_API.resolve_message('OKC_REP_WF_EXT_CONTACT', l_bus_doc_type);
1585: l_ext_contact_msg := OKC_TERMS_UTIL_PVT.Get_Message(p_app_name => 'OKC', p_msg_name => l_resolved_msg_name);
1586:
1587: l_msgbody := '
1588: