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 1453: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

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

Line 1589: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

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

Line 1761: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

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

Line 2162: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

2158:
2159: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2160: l_datatype_id NUMBER;
2161: l_msg_count NUMBER;
2162: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
2163: l_api_version NUMBER := 1;
2164: l_business_document_type OKC_CONTRACT_DOCS.BUSINESS_DOCUMENT_TYPE%TYPE;
2165: l_business_document_id OKC_CONTRACT_DOCS.BUSINESS_DOCUMENT_ID%TYPE;
2166: l_business_document_version OKC_CONTRACT_DOCS.BUSINESS_DOCUMENT_VERSION%TYPE;

Line 2387: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

2383: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Attachments';
2384: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2385: l_datatype_id FND_DOCUMENTS.DATATYPE_ID%TYPE;
2386: l_msg_count NUMBER;
2387: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
2388: l_api_version NUMBER:= 1;
2389:
2390:
2391: BEGIN

Line 2533: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

2529:
2530: l_api_name CONSTANT VARCHAR2(30) := 'qa_doc';
2531: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2532: l_msg_count NUMBER;
2533: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
2534: l_api_version NUMBER:= 1;
2535: l_qa_name FND_LOOKUPS.MEANING%TYPE;
2536: l_severity_flag VARCHAR2(1) := 'W';
2537: l_perform_qa VARCHAR2(1) := 'N';