DBA Data[Home] [Help]

APPS.OKC_DELIVERABLE_PROCESS_PVT dependencies on FND_NEW_MESSAGES

Line 7284: l_err_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

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';

Line 7285: l_sugg_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

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';

Line 7287: l_IntContactMissing_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_MISSING_INT_CONTACT';

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';

Line 7288: l_IntContactInvalid_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_INT_CONTACT';

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';

Line 7289: l_IntContactInvalid_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_INT_CONTACT_S';

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';

Line 7291: l_ContactMissing_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_REQUIRED_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';

Line 7292: l_InvalidRequestor_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_REQUESTER';

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:

Line 7293: l_InvalidRequestor_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_REQUESTER_S';

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

Line 7294: l_InvalidEscAssgn_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_ESCA_ASSIGNEE';

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:

Line 7295: l_InvalidEscAssgn_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_ESCA_S';

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;

Line 7464: l_err_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

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

Line 7465: l_sugg_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

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');

Line 7630: l_ExtContact_err_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_EXT_CONTACT';

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';

Line 7631: l_ExtContact_sugg_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_DEL_INVALID_EXT_CONTACT_S';

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';

Line 7637: l_err_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

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:

Line 7638: l_sugg_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

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;

Line 8637: l_error_msg_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_CHECK_EXT_PARTY_EXISTS';

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:

Line 8638: l_suggestion_msg_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'OKC_CHECK_EXT_PARTY_EXISTS_S';

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;

Line 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;

Line 8643: l_suggestion_msg_text FND_NEW_MESSAGES.MESSAGE_TEXT%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: