APPS.OKC_CONTRACT_DOCS_GRP dependencies on FND_NEW_MESSAGES

Line 645: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

641: l_attached_document_id FND_ATTACHED_DOCUMENTS.ATTACHED_DOCUMENT_ID%TYPE := -1;
642: l_object_version_number NUMBER := -1;
643: l_doc_approved_flag VARCHAR2(1);
644: l_msg_count NUMBER;
645: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
646: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
647: l_parent_attached_doc_id OKC_CONTRACT_DOCS.PARENT_ATTACHED_DOC_ID%TYPE;
648: l_pk2_value FND_ATTACHED_DOCUMENTS.pk2_value%TYPE;
649:

Line 1066: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

1062: ) IS l_api_name CONSTANT VARCHAR2(30) := 'Version_Attachments';
1063: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1064:
1065: l_msg_count NUMBER;
1066: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
1067: l_api_version NUMBER := 1;
1068: l_business_document_type OKC_CONTRACT_DOCS.BUSINESS_DOCUMENT_TYPE%TYPE;
1069: l_business_document_id OKC_CONTRACT_DOCS.BUSINESS_DOCUMENT_ID%TYPE;
1070: l_business_document_version OKC_CONTRACT_DOCS.BUSINESS_DOCUMENT_VERSION%TYPE;

Line 1451: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

1447: ) IS
1448: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Ver_Attachments';
1449: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1450: l_msg_count NUMBER;
1451: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
1452: l_api_version NUMBER := 1;
1453:
1454: -- Attachment cursor
1455: CURSOR attach_csr(l_bus_doc_type VARCHAR2, l_bus_doc_id NUMBER, l_bus_doc_version NUMBER) IS

Line 1587: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

1583: ) IS
1584: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Doc_Attachments';
1585: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1586: l_msg_count NUMBER;
1587: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
1588: l_api_version NUMBER := 1;
1589:
1590: -- Attachment cursor
1591: CURSOR attach_csr(l_bus_doc_type VARCHAR2, l_bus_doc_id NUMBER) IS

Line 1759: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

1755: ) IS l_api_name CONSTANT VARCHAR2(30) := 'Copy_Attachment_Docs';
1756: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1757: l_datatype_id NUMBER;
1758: l_msg_count NUMBER;
1759: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
1760: l_api_version NUMBER := 1;
1761: l_business_document_type OKC_CONTRACT_DOCS.BUSINESS_DOCUMENT_TYPE%TYPE;
1762: l_business_document_id OKC_CONTRACT_DOCS.BUSINESS_DOCUMENT_ID%TYPE;
1763: l_business_document_version OKC_CONTRACT_DOCS.BUSINESS_DOCUMENT_VERSION%TYPE;

Line 2151: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

2147:
2148: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2149: l_datatype_id NUMBER;
2150: l_msg_count NUMBER;
2151: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
2152: l_api_version NUMBER := 1;
2153: l_business_document_type OKC_CONTRACT_DOCS.BUSINESS_DOCUMENT_TYPE%TYPE;
2154: l_business_document_id OKC_CONTRACT_DOCS.BUSINESS_DOCUMENT_ID%TYPE;
2155: l_business_document_version OKC_CONTRACT_DOCS.BUSINESS_DOCUMENT_VERSION%TYPE;

Line 2376: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

2372: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Attachments';
2373: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2374: l_datatype_id FND_DOCUMENTS.DATATYPE_ID%TYPE;
2375: l_msg_count NUMBER;
2376: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
2377: l_api_version NUMBER:= 1;
2378:
2379:
2380: BEGIN

Line 2522: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

2518:
2519: l_api_name CONSTANT VARCHAR2(30) := 'qa_doc';
2520: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2521: l_msg_count NUMBER;
2522: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
2523: l_api_version NUMBER:= 1;
2524: l_qa_name FND_LOOKUPS.MEANING%TYPE;
2525: l_severity_flag VARCHAR2(1) := 'W';
2526: l_perform_qa VARCHAR2(1) := 'N';