7701: l_contact_exists VARCHAR2(1);
7702: l_qa_code VARCHAR2(80) := 'CHECK_BUYER_CONTACT';
7703: l_short_desc VARCHAR2(80);
7704:
7705: l_err_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
7706: l_sugg_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
7707:
7708: --Acq Plan Message Cleanup
7709: -- l_IntContactMissing_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_MISSING_INT_CONTACT';
7702: l_qa_code VARCHAR2(80) := 'CHECK_BUYER_CONTACT';
7703: l_short_desc VARCHAR2(80);
7704:
7705: l_err_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
7706: l_sugg_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
7707:
7708: --Acq Plan Message Cleanup
7709: -- l_IntContactMissing_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_MISSING_INT_CONTACT';
7710: l_IntContactMissing_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_MISSING_INT_CONTACT';
7705: l_err_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
7706: l_sugg_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
7707:
7708: --Acq Plan Message Cleanup
7709: -- l_IntContactMissing_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_MISSING_INT_CONTACT';
7710: l_IntContactMissing_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_MISSING_INT_CONTACT';
7711: -- l_IntContactInvalid_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_INT_CONTACT';
7712: l_IntContactInvalid_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_INT_CONTACT';
7713: l_IntContactInvalid_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_INT_CONTACT_S';
7706: l_sugg_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
7707:
7708: --Acq Plan Message Cleanup
7709: -- l_IntContactMissing_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_MISSING_INT_CONTACT';
7710: l_IntContactMissing_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_MISSING_INT_CONTACT';
7711: -- l_IntContactInvalid_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_INT_CONTACT';
7712: l_IntContactInvalid_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_INT_CONTACT';
7713: l_IntContactInvalid_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_INT_CONTACT_S';
7714:
7707:
7708: --Acq Plan Message Cleanup
7709: -- l_IntContactMissing_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_MISSING_INT_CONTACT';
7710: l_IntContactMissing_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_MISSING_INT_CONTACT';
7711: -- l_IntContactInvalid_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_INT_CONTACT';
7712: l_IntContactInvalid_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_INT_CONTACT';
7713: l_IntContactInvalid_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_INT_CONTACT_S';
7714:
7715: l_ContactMissing_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_REQUIRED_S';
7708: --Acq Plan Message Cleanup
7709: -- l_IntContactMissing_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_MISSING_INT_CONTACT';
7710: l_IntContactMissing_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_MISSING_INT_CONTACT';
7711: -- l_IntContactInvalid_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_INT_CONTACT';
7712: l_IntContactInvalid_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_INT_CONTACT';
7713: l_IntContactInvalid_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_INT_CONTACT_S';
7714:
7715: l_ContactMissing_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_REQUIRED_S';
7716: l_InvalidRequestor_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_REQUESTER';
7709: -- l_IntContactMissing_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_MISSING_INT_CONTACT';
7710: l_IntContactMissing_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_MISSING_INT_CONTACT';
7711: -- l_IntContactInvalid_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_INT_CONTACT';
7712: l_IntContactInvalid_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_INT_CONTACT';
7713: l_IntContactInvalid_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_INT_CONTACT_S';
7714:
7715: l_ContactMissing_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_REQUIRED_S';
7716: l_InvalidRequestor_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_REQUESTER';
7717: l_InvalidRequestor_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_REQUESTER_S';
7711: -- l_IntContactInvalid_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_INT_CONTACT';
7712: l_IntContactInvalid_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_INT_CONTACT';
7713: l_IntContactInvalid_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_INT_CONTACT_S';
7714:
7715: l_ContactMissing_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_REQUIRED_S';
7716: l_InvalidRequestor_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_REQUESTER';
7717: l_InvalidRequestor_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_REQUESTER_S';
7718: --Acq Plan Message Cleanup
7719: --l_InvalidEscAssgn_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_ESCA_ASSIGNEE';
7712: l_IntContactInvalid_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_INT_CONTACT';
7713: l_IntContactInvalid_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_INT_CONTACT_S';
7714:
7715: l_ContactMissing_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_REQUIRED_S';
7716: l_InvalidRequestor_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_REQUESTER';
7717: l_InvalidRequestor_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_REQUESTER_S';
7718: --Acq Plan Message Cleanup
7719: --l_InvalidEscAssgn_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_ESCA_ASSIGNEE';
7720: l_InvalidEscAssgn_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_ESCA_ASSIGNEE';
7713: l_IntContactInvalid_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_INT_CONTACT_S';
7714:
7715: l_ContactMissing_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_REQUIRED_S';
7716: l_InvalidRequestor_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_REQUESTER';
7717: l_InvalidRequestor_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_REQUESTER_S';
7718: --Acq Plan Message Cleanup
7719: --l_InvalidEscAssgn_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_ESCA_ASSIGNEE';
7720: l_InvalidEscAssgn_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_ESCA_ASSIGNEE';
7721: l_InvalidEscAssgn_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_ESCA_S';
7715: l_ContactMissing_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_REQUIRED_S';
7716: l_InvalidRequestor_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_REQUESTER';
7717: l_InvalidRequestor_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_REQUESTER_S';
7718: --Acq Plan Message Cleanup
7719: --l_InvalidEscAssgn_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_ESCA_ASSIGNEE';
7720: l_InvalidEscAssgn_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_ESCA_ASSIGNEE';
7721: l_InvalidEscAssgn_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_ESCA_S';
7722:
7723: l_resolved_msg_name VARCHAR2(30);
7716: l_InvalidRequestor_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_REQUESTER';
7717: l_InvalidRequestor_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_REQUESTER_S';
7718: --Acq Plan Message Cleanup
7719: --l_InvalidEscAssgn_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_ESCA_ASSIGNEE';
7720: l_InvalidEscAssgn_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_ESCA_ASSIGNEE';
7721: l_InvalidEscAssgn_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_ESCA_S';
7722:
7723: l_resolved_msg_name VARCHAR2(30);
7724: l_resolved_token VARCHAR2(100);
7717: l_InvalidRequestor_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_REQUESTER_S';
7718: --Acq Plan Message Cleanup
7719: --l_InvalidEscAssgn_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_ESCA_ASSIGNEE';
7720: l_InvalidEscAssgn_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_ESCA_ASSIGNEE';
7721: l_InvalidEscAssgn_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_ESCA_S';
7722:
7723: l_resolved_msg_name VARCHAR2(30);
7724: l_resolved_token VARCHAR2(100);
7725:
7956: l_contact_exists VARCHAR2(1);
7957: l_qa_code VARCHAR2(80) := 'CHECK_DELIVERABLE_EXHIBIT';
7958: l_short_desc VARCHAR2(80);
7959:
7960: l_err_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
7961: l_sugg_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
7962:
7963: l_exhibitMissing_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_MISSING_EXHIBIT';
7964: l_exhibitMissing_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_MISSING_EXHIBIT_S';
7957: l_qa_code VARCHAR2(80) := 'CHECK_DELIVERABLE_EXHIBIT';
7958: l_short_desc VARCHAR2(80);
7959:
7960: l_err_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
7961: l_sugg_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
7962:
7963: l_exhibitMissing_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_MISSING_EXHIBIT';
7964: l_exhibitMissing_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_MISSING_EXHIBIT_S';
7965:
7959:
7960: l_err_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
7961: l_sugg_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
7962:
7963: l_exhibitMissing_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_MISSING_EXHIBIT';
7964: l_exhibitMissing_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_MISSING_EXHIBIT_S';
7965:
7966: --Acq Plan Message Cleanup
7967: l_resolved_msg_name VARCHAR2(30);
7960: l_err_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
7961: l_sugg_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
7962:
7963: l_exhibitMissing_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_MISSING_EXHIBIT';
7964: l_exhibitMissing_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_MISSING_EXHIBIT_S';
7965:
7966: --Acq Plan Message Cleanup
7967: l_resolved_msg_name VARCHAR2(30);
7968: l_resolved_token VARCHAR2(100);
8096:
8097: l_qa_code VARCHAR2(80) := 'CHECK_INTERNAL_CONTACT_VALID';
8098: l_short_desc VARCHAR2(80);
8099:
8100: l_err_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
8101: l_sugg_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
8102:
8103: --Acq Plan Message Cleanup
8104: l_resolved_msg_name VARCHAR2(30);
8097: l_qa_code VARCHAR2(80) := 'CHECK_INTERNAL_CONTACT_VALID';
8098: l_short_desc VARCHAR2(80);
8099:
8100: l_err_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
8101: l_sugg_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
8102:
8103: --Acq Plan Message Cleanup
8104: l_resolved_msg_name VARCHAR2(30);
8105: l_resolved_token VARCHAR2(100);
8292: l_short_desc VARCHAR2(80);
8293:
8294: --Messages for Repository
8295: -- Acq Plan Messages Cleanup
8296: --l_ExtContact_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_EXT_CONTACT';
8297: l_ExtContact_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_EXT_CONTACT';
8298: l_ExtContact_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_EXT_CONTACT_S';
8299:
8300: --Messages for PO
8293:
8294: --Messages for Repository
8295: -- Acq Plan Messages Cleanup
8296: --l_ExtContact_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_EXT_CONTACT';
8297: l_ExtContact_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_EXT_CONTACT';
8298: l_ExtContact_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_EXT_CONTACT_S';
8299:
8300: --Messages for PO
8301: --l_SupplierContact_err_msg VARCHAR2(30) := 'OKC_DEL_INVALID_SUPP_CONTACT';
8294: --Messages for Repository
8295: -- Acq Plan Messages Cleanup
8296: --l_ExtContact_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_EXT_CONTACT';
8297: l_ExtContact_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_EXT_CONTACT';
8298: l_ExtContact_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_EXT_CONTACT_S';
8299:
8300: --Messages for PO
8301: --l_SupplierContact_err_msg VARCHAR2(30) := 'OKC_DEL_INVALID_SUPP_CONTACT';
8302: l_SupplierContact_err_msg VARCHAR2(30) := 'OKC_DEL_INVALID_SUPP_CONTACT';
8301: --l_SupplierContact_err_msg VARCHAR2(30) := 'OKC_DEL_INVALID_SUPP_CONTACT';
8302: l_SupplierContact_err_msg VARCHAR2(30) := 'OKC_DEL_INVALID_SUPP_CONTACT';
8303: l_SupplierContact_sugg_msg VARCHAR2(30) := 'OKC_DEL_INVALID_SUPP_CONTACT_S';
8304:
8305: l_err_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
8306: l_sugg_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
8307:
8308: --Acq Plan Message Cleanup
8309: l_resolved_msg_name VARCHAR2(30);
8302: l_SupplierContact_err_msg VARCHAR2(30) := 'OKC_DEL_INVALID_SUPP_CONTACT';
8303: l_SupplierContact_sugg_msg VARCHAR2(30) := 'OKC_DEL_INVALID_SUPP_CONTACT_S';
8304:
8305: l_err_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
8306: l_sugg_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
8307:
8308: --Acq Plan Message Cleanup
8309: l_resolved_msg_name VARCHAR2(30);
8310: l_resolved_token VARCHAR2(100);
9435:
9436: l_qa_code VARCHAR2(80) := 'CHECK_EXTERNAL_PARTY_EXISTS';
9437: l_short_desc VARCHAR2(80);
9438: --Acq Plan Message Cleanup
9439: --l_error_msg_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_CHECK_EXT_PARTY_EXISTS';
9440: l_error_msg_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_CHECK_EXT_PARTY_EXISTS';
9441: --l_suggestion_msg_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_CHECK_EXT_PARTY_EXISTS_S';
9442: l_suggestion_msg_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_CHECK_EXT_PARTY_EXISTS_S';
9443:
9436: l_qa_code VARCHAR2(80) := 'CHECK_EXTERNAL_PARTY_EXISTS';
9437: l_short_desc VARCHAR2(80);
9438: --Acq Plan Message Cleanup
9439: --l_error_msg_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_CHECK_EXT_PARTY_EXISTS';
9440: l_error_msg_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_CHECK_EXT_PARTY_EXISTS';
9441: --l_suggestion_msg_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_CHECK_EXT_PARTY_EXISTS_S';
9442: l_suggestion_msg_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_CHECK_EXT_PARTY_EXISTS_S';
9443:
9444: l_deliverable_name_token VARCHAR2(30) := 'DELIVERABLE_NAME';
9437: l_short_desc VARCHAR2(80);
9438: --Acq Plan Message Cleanup
9439: --l_error_msg_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_CHECK_EXT_PARTY_EXISTS';
9440: l_error_msg_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_CHECK_EXT_PARTY_EXISTS';
9441: --l_suggestion_msg_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_CHECK_EXT_PARTY_EXISTS_S';
9442: l_suggestion_msg_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_CHECK_EXT_PARTY_EXISTS_S';
9443:
9444: l_deliverable_name_token VARCHAR2(30) := 'DELIVERABLE_NAME';
9445:
9438: --Acq Plan Message Cleanup
9439: --l_error_msg_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_CHECK_EXT_PARTY_EXISTS';
9440: l_error_msg_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_CHECK_EXT_PARTY_EXISTS';
9441: --l_suggestion_msg_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_CHECK_EXT_PARTY_EXISTS_S';
9442: l_suggestion_msg_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_CHECK_EXT_PARTY_EXISTS_S';
9443:
9444: l_deliverable_name_token VARCHAR2(30) := 'DELIVERABLE_NAME';
9445:
9446: l_error_msg_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
9442: l_suggestion_msg_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_CHECK_EXT_PARTY_EXISTS_S';
9443:
9444: l_deliverable_name_token VARCHAR2(30) := 'DELIVERABLE_NAME';
9445:
9446: l_error_msg_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
9447: l_suggestion_msg_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
9448:
9449: l_doc_type_class OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE_CLASS%TYPE;
9450: l_del_type_int_flag OKC_DELIVERABLE_TYPES_B.INTERNAL_FLAG%TYPE;
9443:
9444: l_deliverable_name_token VARCHAR2(30) := 'DELIVERABLE_NAME';
9445:
9446: l_error_msg_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
9447: l_suggestion_msg_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
9448:
9449: l_doc_type_class OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE_CLASS%TYPE;
9450: l_del_type_int_flag OKC_DELIVERABLE_TYPES_B.INTERNAL_FLAG%TYPE;
9451: