APPS.OKC_TERMS_UTIL_GRP dependencies on FND_NEW_MESSAGES

Line 809: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

805: p_doc_type IN VARCHAR2,
806: p_doc_id IN NUMBER
807: ) RETURN VARCHAR2 IS
808: l_return_status Varchar2(1);
809: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
810: l_msg_count NUMBER;
811: l_return_value Varchar2(30);
812: BEGIN
813: l_return_value:=Is_Article_Exist(P_api_version => 1,

Line 843: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

839: ) RETURN VARCHAR2 IS -- 'T' - updatable, 'F'- nonupdatable, 'E' - doesn't exist
840: l_api_version CONSTANT NUMBER := 1;
841: l_api_name CONSTANT VARCHAR2(30) := 'Is_Document_Updatable';
842: l_return_status Varchar2(1);
843: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
844: l_msg_count NUMBER;
845: l_return_value Varchar2(1) := 'E';
846: l_org_id NUMBER := (-99);
847: l_init_msg_list VARCHAR2(2000);

Line 956: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

952: p_doc_type IN VARCHAR2,
953: p_doc_id IN NUMBER
954: ) RETURN VARCHAR2 IS
955: l_return_status Varchar2(1);
956: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
957: l_msg_count NUMBER;
958: l_return_value Varchar2(30);
959: BEGIN
960:

Line 2380: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

2376: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
2377: l_template_ID OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%TYPE;
2378: l_return_status Varchar2(1);
2379: l_msg_count NUMBER;
2380: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
2381: BEGIN
2382: Get_Terms_Template(p_api_version =>1,
2383: p_init_msg_list => FND_API.G_FALSE,
2384: x_return_status => l_return_status,

Line 2580: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

2576: l_api_name CONSTANT VARCHAR2(30) := 'get_last_signed_revision';
2577: l_doc_class VARCHAR2(30) := '?';
2578: l_signed_version NUMBER;
2579: l_msg_count NUMBER;
2580: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
2581: l_return_status VARCHAR2(1);
2582:
2583: CURSOR doc_cls_lst_crs IS
2584: SELECT document_type_class