7280: l_contact_exists VARCHAR2(1);
7281: l_qa_code VARCHAR2(80) := 'CHECK_BUYER_CONTACT';
7282: l_short_desc VARCHAR2(80);
7283:
7284: l_err_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
7285: l_sugg_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
7286:
7287: l_IntContactMissing_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_MISSING_INT_CONTACT';
7288: l_IntContactInvalid_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_INT_CONTACT';
7281: l_qa_code VARCHAR2(80) := 'CHECK_BUYER_CONTACT';
7282: l_short_desc VARCHAR2(80);
7283:
7284: l_err_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
7285: l_sugg_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
7286:
7287: l_IntContactMissing_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_MISSING_INT_CONTACT';
7288: l_IntContactInvalid_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_INT_CONTACT';
7289: l_IntContactInvalid_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_INT_CONTACT_S';
7283:
7284: l_err_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
7285: l_sugg_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
7286:
7287: l_IntContactMissing_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_MISSING_INT_CONTACT';
7288: l_IntContactInvalid_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_INT_CONTACT';
7289: l_IntContactInvalid_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_INT_CONTACT_S';
7290:
7291: l_ContactMissing_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_REQUIRED_S';
7284: l_err_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
7285: l_sugg_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
7286:
7287: l_IntContactMissing_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_MISSING_INT_CONTACT';
7288: l_IntContactInvalid_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_INT_CONTACT';
7289: l_IntContactInvalid_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_INT_CONTACT_S';
7290:
7291: l_ContactMissing_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_REQUIRED_S';
7292: l_InvalidRequestor_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_REQUESTER';
7285: l_sugg_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
7286:
7287: l_IntContactMissing_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_MISSING_INT_CONTACT';
7288: l_IntContactInvalid_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_INT_CONTACT';
7289: l_IntContactInvalid_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_INT_CONTACT_S';
7290:
7291: l_ContactMissing_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_REQUIRED_S';
7292: l_InvalidRequestor_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_REQUESTER';
7293: l_InvalidRequestor_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_REQUESTER_S';
7287: l_IntContactMissing_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_MISSING_INT_CONTACT';
7288: l_IntContactInvalid_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_INT_CONTACT';
7289: l_IntContactInvalid_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_INT_CONTACT_S';
7290:
7291: l_ContactMissing_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_REQUIRED_S';
7292: l_InvalidRequestor_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_REQUESTER';
7293: l_InvalidRequestor_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_REQUESTER_S';
7294: l_InvalidEscAssgn_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_ESCA_ASSIGNEE';
7295: l_InvalidEscAssgn_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_ESCA_S';
7288: l_IntContactInvalid_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_INT_CONTACT';
7289: l_IntContactInvalid_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_INT_CONTACT_S';
7290:
7291: l_ContactMissing_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_REQUIRED_S';
7292: l_InvalidRequestor_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_REQUESTER';
7293: l_InvalidRequestor_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_REQUESTER_S';
7294: l_InvalidEscAssgn_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_ESCA_ASSIGNEE';
7295: l_InvalidEscAssgn_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_ESCA_S';
7296:
7289: l_IntContactInvalid_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_INT_CONTACT_S';
7290:
7291: l_ContactMissing_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_REQUIRED_S';
7292: l_InvalidRequestor_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_REQUESTER';
7293: l_InvalidRequestor_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_REQUESTER_S';
7294: l_InvalidEscAssgn_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_ESCA_ASSIGNEE';
7295: l_InvalidEscAssgn_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_ESCA_S';
7296:
7297: BEGIN
7290:
7291: l_ContactMissing_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_REQUIRED_S';
7292: l_InvalidRequestor_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_REQUESTER';
7293: l_InvalidRequestor_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_REQUESTER_S';
7294: l_InvalidEscAssgn_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_ESCA_ASSIGNEE';
7295: l_InvalidEscAssgn_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_ESCA_S';
7296:
7297: BEGIN
7298:
7291: l_ContactMissing_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_REQUIRED_S';
7292: l_InvalidRequestor_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_REQUESTER';
7293: l_InvalidRequestor_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_REQUESTER_S';
7294: l_InvalidEscAssgn_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_ESCA_ASSIGNEE';
7295: l_InvalidEscAssgn_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_ESCA_S';
7296:
7297: BEGIN
7298:
7299: l_qa_result_tbl := px_qa_result_tbl;
7460:
7461: l_qa_code VARCHAR2(80) := 'CHECK_INTERNAL_CONTACT_VALID';
7462: l_short_desc VARCHAR2(80);
7463:
7464: l_err_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
7465: l_sugg_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
7466:
7467: BEGIN
7468: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7461: l_qa_code VARCHAR2(80) := 'CHECK_INTERNAL_CONTACT_VALID';
7462: l_short_desc VARCHAR2(80);
7463:
7464: l_err_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
7465: l_sugg_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
7466:
7467: BEGIN
7468: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7469: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.check_internal_contacts_valid');
7626: l_qa_code VARCHAR2(80) := 'CHECK_SUPPLIER_CONTACT';
7627: l_short_desc VARCHAR2(80);
7628:
7629: --Messages for Repository
7630: l_ExtContact_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_EXT_CONTACT';
7631: l_ExtContact_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_EXT_CONTACT_S';
7632:
7633: --Messages for PO
7634: l_SupplierContact_err_msg VARCHAR2(30) := 'OKC_DEL_INVALID_SUPP_CONTACT';
7627: l_short_desc VARCHAR2(80);
7628:
7629: --Messages for Repository
7630: l_ExtContact_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_EXT_CONTACT';
7631: l_ExtContact_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_EXT_CONTACT_S';
7632:
7633: --Messages for PO
7634: l_SupplierContact_err_msg VARCHAR2(30) := 'OKC_DEL_INVALID_SUPP_CONTACT';
7635: l_SupplierContact_sugg_msg VARCHAR2(30) := 'OKC_DEL_INVALID_SUPP_CONTACT_S';
7633: --Messages for PO
7634: l_SupplierContact_err_msg VARCHAR2(30) := 'OKC_DEL_INVALID_SUPP_CONTACT';
7635: l_SupplierContact_sugg_msg VARCHAR2(30) := 'OKC_DEL_INVALID_SUPP_CONTACT_S';
7636:
7637: l_err_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
7638: l_sugg_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
7639:
7640: BEGIN
7641:
7634: l_SupplierContact_err_msg VARCHAR2(30) := 'OKC_DEL_INVALID_SUPP_CONTACT';
7635: l_SupplierContact_sugg_msg VARCHAR2(30) := 'OKC_DEL_INVALID_SUPP_CONTACT_S';
7636:
7637: l_err_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
7638: l_sugg_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
7639:
7640: BEGIN
7641:
7642: l_qa_result_tbl := px_qa_result_tbl;
8633: l_start PLS_INTEGER := 0;
8634:
8635: l_qa_code VARCHAR2(80) := 'CHECK_EXTERNAL_PARTY_EXISTS';
8636: l_short_desc VARCHAR2(80);
8637: l_error_msg_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_CHECK_EXT_PARTY_EXISTS';
8638: l_suggestion_msg_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_CHECK_EXT_PARTY_EXISTS_S';
8639:
8640: l_deliverable_name_token VARCHAR2(30) := 'DELIVERABLE_NAME';
8641:
8634:
8635: l_qa_code VARCHAR2(80) := 'CHECK_EXTERNAL_PARTY_EXISTS';
8636: l_short_desc VARCHAR2(80);
8637: l_error_msg_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_CHECK_EXT_PARTY_EXISTS';
8638: l_suggestion_msg_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_CHECK_EXT_PARTY_EXISTS_S';
8639:
8640: l_deliverable_name_token VARCHAR2(30) := 'DELIVERABLE_NAME';
8641:
8642: l_error_msg_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
8638: l_suggestion_msg_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_CHECK_EXT_PARTY_EXISTS_S';
8639:
8640: l_deliverable_name_token VARCHAR2(30) := 'DELIVERABLE_NAME';
8641:
8642: l_error_msg_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
8643: l_suggestion_msg_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
8644:
8645: l_doc_type_class OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE_CLASS%TYPE;
8646: l_del_type_int_flag OKC_DELIVERABLE_TYPES_B.INTERNAL_FLAG%TYPE;
8639:
8640: l_deliverable_name_token VARCHAR2(30) := 'DELIVERABLE_NAME';
8641:
8642: l_error_msg_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
8643: l_suggestion_msg_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
8644:
8645: l_doc_type_class OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE_CLASS%TYPE;
8646: l_del_type_int_flag OKC_DELIVERABLE_TYPES_B.INTERNAL_FLAG%TYPE;
8647: