APPS.OKC_TERMS_UTIL_GRP dependencies on FND_NEW_MESSAGES

Line 718: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

714: p_doc_type IN VARCHAR2,
715: p_doc_id IN NUMBER
716: ) RETURN VARCHAR2 IS
717: l_return_status Varchar2(1);
718: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
719: l_msg_count NUMBER;
720: l_return_value Varchar2(30);
721: BEGIN
722: l_return_value:=Is_Article_Exist(P_api_version => 1,

Line 752: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

748: ) RETURN VARCHAR2 IS -- 'T' - updatable, 'F'- nonupdatable, 'E' - doesn't exist
749: l_api_version CONSTANT NUMBER := 1;
750: l_api_name CONSTANT VARCHAR2(30) := 'Is_Document_Updatable';
751: l_return_status Varchar2(1);
752: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
753: l_msg_count NUMBER;
754: l_return_value Varchar2(1) := 'E';
755: l_org_id NUMBER := (-99);
756: l_init_msg_list VARCHAR2(2000);

Line 852: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

848: p_doc_type IN VARCHAR2,
849: p_doc_id IN NUMBER
850: ) RETURN VARCHAR2 IS
851: l_return_status Varchar2(1);
852: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
853: l_msg_count NUMBER;
854: l_return_value Varchar2(30);
855: BEGIN
856:

Line 2271: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

2267: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
2268: l_template_ID OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%TYPE;
2269: l_return_status Varchar2(1);
2270: l_msg_count NUMBER;
2271: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
2272: BEGIN
2273: Get_Terms_Template(p_api_version =>1,
2274: p_init_msg_list => FND_API.G_FALSE,
2275: x_return_status => l_return_status,

Line 2471: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

2467: l_api_name CONSTANT VARCHAR2(30) := 'get_last_signed_revision';
2468: l_doc_class VARCHAR2(30) := '?';
2469: l_signed_version NUMBER;
2470: l_msg_count NUMBER;
2471: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
2472: l_return_status VARCHAR2(1);
2473:
2474: CURSOR doc_cls_lst_crs IS
2475: SELECT document_type_class