DBA Data[Home] [Help]

APPS.OKC_DELIVERABLE_PROCESS_PVT dependencies on OKC_TERMS_UTIL_PVT

Line 6328: 1. This API is invoked by OKC_TERMS_UTIL_PVT.merge_template_working_copy

6324:
6325: END purge_doc_deliverables;
6326:
6327: /***
6328: 1. This API is invoked by OKC_TERMS_UTIL_PVT.merge_template_working_copy
6329: 2. This API will select all deliverables for a given
6330: business document type and version
6331: 3. Delete all deliverables along with the attachments and status history
6332: ***/

Line 6460: 1. This API is invoked by OKC_TERMS_UTIL_PVT.merge_template_working_copy

6456:
6457: END delete_deliverables;
6458:
6459: /***
6460: 1. This API is invoked by OKC_TERMS_UTIL_PVT.merge_template_working_copy
6461: 2. This API will select all deliverables for a given source template id
6462: 3. Update all deliverables on the target template Id
6463: set the business_document_id = source template id
6464: ***/

Line 7176: l_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,

7172: IF(del_rec.notify_prior_due_date_value is null OR del_rec.notify_prior_due_date_uom is null) THEN
7173: l_index := l_index+1;
7174: l_qa_result_tbl(l_index).error_severity := G_QA_STS_ERROR;
7175: l_qa_result_tbl(l_index).message_name := 'OKC_DEL_NTF_DETAILS_REQUIRED';
7176: l_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7177: p_msg_name => 'OKC_DEL_NTF_DETAILS_REQUIRED',
7178: p_token1 => 'NOTIFICATION_TYPE',
7179: p_token1_value => 'prior due',
7180: p_token2 => 'DELIVERABLE_NAME',

Line 7183: l_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,

7179: p_token1_value => 'prior due',
7180: p_token2 => 'DELIVERABLE_NAME',
7181: p_token2_value => del_rec.deliverable_name);
7182: l_qa_result_tbl(l_index).problem_details := l_message_txt;
7183: l_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7184: p_msg_name => 'OKC_DEL_NTF_DETAILS_REQUIRED_S');
7185: l_qa_result_tbl(l_index).suggestion := l_message_txt;
7186:
7187: END IF;

Line 7196: l_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,

7192: IF(del_rec.notify_escalation_value is null OR del_rec.notify_escalation_uom is null OR del_rec.escalation_assignee is null) THEN
7193: l_index := l_index+1;
7194: l_qa_result_tbl(l_index).error_severity := p_severity;
7195: l_qa_result_tbl(l_index).message_name := 'OKC_DEL_ESCALATE_REQUIRED';
7196: l_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7197: p_msg_name => 'OKC_DEL_ESCALATE_REQUIRED',
7198: p_token1 => 'DELIVERABLE_NAME',
7199: p_token1_value => del_rec.deliverable_name);
7200: l_qa_result_tbl(l_index).problem_details := l_message_txt;

Line 7201: l_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,

7197: p_msg_name => 'OKC_DEL_ESCALATE_REQUIRED',
7198: p_token1 => 'DELIVERABLE_NAME',
7199: p_token1_value => del_rec.deliverable_name);
7200: l_qa_result_tbl(l_index).problem_details := l_message_txt;
7201: l_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7202: p_msg_name => 'OKC_DEL_REQUIRED_S');
7203: l_qa_result_tbl(l_index).suggestion := l_message_txt;
7204:
7205: END IF;

Line 7313: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,

7309: l_index := l_index+1;
7310:
7311: --l_qa_result_tbl(l_index).error_severity := G_QA_STS_ERROR;
7312: l_qa_result_tbl(l_index).message_name := l_IntContactMissing_err_msg;
7313: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7314: p_msg_name => l_IntContactMissing_err_msg,
7315: p_token1 => 'DELIVERABLE_NAME',
7316: p_token1_value => del_rec.deliverable_name);
7317:

Line 7318: l_sugg_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,

7314: p_msg_name => l_IntContactMissing_err_msg,
7315: p_token1 => 'DELIVERABLE_NAME',
7316: p_token1_value => del_rec.deliverable_name);
7317:
7318: l_sugg_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7319: p_msg_name => l_ContactMissing_sugg_msg);
7320:
7321: l_qa_result_tbl(l_index).problem_details := l_err_message_txt;
7322: l_qa_result_tbl(l_index).suggestion := l_sugg_message_txt;

Line 7334: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,

7330: IF l_contact_exists = 'N' THEN
7331: l_index := l_index+1;
7332: --l_qa_result_tbl(l_index).error_severity := G_QA_STS_ERROR;
7333: l_qa_result_tbl(l_index).message_name := l_IntContactInvalid_err_msg;
7334: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7335: p_msg_name => l_IntContactInvalid_err_msg);
7336: l_sugg_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7337: p_msg_name => l_IntContactInvalid_sugg_msg);
7338:

Line 7336: l_sugg_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,

7332: --l_qa_result_tbl(l_index).error_severity := G_QA_STS_ERROR;
7333: l_qa_result_tbl(l_index).message_name := l_IntContactInvalid_err_msg;
7334: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7335: p_msg_name => l_IntContactInvalid_err_msg);
7336: l_sugg_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7337: p_msg_name => l_IntContactInvalid_sugg_msg);
7338:
7339: l_qa_result_tbl(l_index).problem_details := l_err_message_txt;
7340: l_qa_result_tbl(l_index).suggestion := l_sugg_message_txt;

Line 7356: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,

7352:
7353: l_index := l_index+1;
7354: --l_qa_result_tbl(l_index).error_severity := G_QA_STS_WARNING;
7355: l_qa_result_tbl(l_index).message_name := l_InvalidRequestor_err_msg;
7356: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7357: p_msg_name => l_InvalidRequestor_err_msg);
7358: l_qa_result_tbl(l_index).problem_details := l_err_message_txt;
7359: l_sugg_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7360: p_msg_name => l_InvalidRequestor_sugg_msg);

Line 7359: l_sugg_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,

7355: l_qa_result_tbl(l_index).message_name := l_InvalidRequestor_err_msg;
7356: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7357: p_msg_name => l_InvalidRequestor_err_msg);
7358: l_qa_result_tbl(l_index).problem_details := l_err_message_txt;
7359: l_sugg_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7360: p_msg_name => l_InvalidRequestor_sugg_msg);
7361: l_qa_result_tbl(l_index).suggestion := l_sugg_message_txt;
7362:
7363: END IF;

Line 7374: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,

7370:
7371: l_index := l_index+1;
7372: --l_qa_result_tbl(l_index).error_severity := G_QA_STS_ERROR;
7373: l_qa_result_tbl(l_index).message_name := l_InvalidEscAssgn_err_msg;
7374: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7375: p_msg_name => l_InvalidEscAssgn_err_msg);
7376: l_qa_result_tbl(l_index).problem_details := l_err_message_txt;
7377: l_sugg_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7378: p_msg_name => l_InvalidEscAssgn_sugg_msg);

Line 7377: l_sugg_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,

7373: l_qa_result_tbl(l_index).message_name := l_InvalidEscAssgn_err_msg;
7374: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7375: p_msg_name => l_InvalidEscAssgn_err_msg);
7376: l_qa_result_tbl(l_index).problem_details := l_err_message_txt;
7377: l_sugg_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7378: p_msg_name => l_InvalidEscAssgn_sugg_msg);
7379: l_qa_result_tbl(l_index).suggestion := l_sugg_message_txt;
7380:
7381: END IF;

Line 7489: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,

7485: IF l_contact_valid = 'N' THEN
7486: l_index := l_index+1;
7487:
7488: l_qa_result_tbl(l_index).message_name := 'OKC_DEL_INV_INT_CONT_EMAIL';
7489: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7490: p_msg_name => 'OKC_DEL_INV_INT_CONT_EMAIL');
7491: l_sugg_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7492: p_msg_name => 'OKC_DEL_INV_INT_CONT_EMAIL_S');
7493:

Line 7491: l_sugg_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,

7487:
7488: l_qa_result_tbl(l_index).message_name := 'OKC_DEL_INV_INT_CONT_EMAIL';
7489: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7490: p_msg_name => 'OKC_DEL_INV_INT_CONT_EMAIL');
7491: l_sugg_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7492: p_msg_name => 'OKC_DEL_INV_INT_CONT_EMAIL_S');
7493:
7494: l_qa_result_tbl(l_index).problem_details := l_err_message_txt;
7495: l_qa_result_tbl(l_index).suggestion := l_sugg_message_txt;

Line 7511: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,

7507: IF l_contact_valid = 'N' THEN
7508:
7509: l_index := l_index+1;
7510: l_qa_result_tbl(l_index).message_name := 'OKC_DEL_INV_REQ_CONT_EMAIL';
7511: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7512: p_msg_name => 'OKC_DEL_INV_REQ_CONT_EMAIL');
7513: l_qa_result_tbl(l_index).problem_details := l_err_message_txt;
7514: l_sugg_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7515: p_msg_name => 'OKC_DEL_INV_INT_CONT_EMAIL_S');

Line 7514: l_sugg_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,

7510: l_qa_result_tbl(l_index).message_name := 'OKC_DEL_INV_REQ_CONT_EMAIL';
7511: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7512: p_msg_name => 'OKC_DEL_INV_REQ_CONT_EMAIL');
7513: l_qa_result_tbl(l_index).problem_details := l_err_message_txt;
7514: l_sugg_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7515: p_msg_name => 'OKC_DEL_INV_INT_CONT_EMAIL_S');
7516: l_qa_result_tbl(l_index).suggestion := l_sugg_message_txt;
7517:
7518: END IF;

Line 7531: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,

7527: IF l_contact_valid = 'N' THEN
7528:
7529: l_index := l_index+1;
7530: l_qa_result_tbl(l_index).message_name := 'OKC_DEL_INV_ESC_CONT_EMAIL';
7531: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7532: p_msg_name => 'OKC_DEL_INV_ESC_CONT_EMAIL');
7533: l_qa_result_tbl(l_index).problem_details := l_err_message_txt;
7534: l_sugg_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7535: p_msg_name => 'OKC_DEL_INV_INT_CONT_EMAIL_S');

Line 7534: l_sugg_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,

7530: l_qa_result_tbl(l_index).message_name := 'OKC_DEL_INV_ESC_CONT_EMAIL';
7531: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7532: p_msg_name => 'OKC_DEL_INV_ESC_CONT_EMAIL');
7533: l_qa_result_tbl(l_index).problem_details := l_err_message_txt;
7534: l_sugg_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7535: p_msg_name => 'OKC_DEL_INV_INT_CONT_EMAIL_S');
7536: l_qa_result_tbl(l_index).suggestion := l_sugg_message_txt;
7537:
7538: END IF;

Line 7665: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,

7661: --l_qa_result_tbl(l_index).error_severity := G_QA_STS_ERROR;
7662:
7663: If (l_doc_type_class = 'REPOSITORY') then
7664: l_qa_result_tbl(l_index).message_name := l_ExtContact_err_msg;
7665: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7666: p_msg_name => l_ExtContact_err_msg,
7667: p_token1 => 'DELIVERABLE_NAME',
7668: p_token1_value => del_rec.deliverable_name);
7669: l_sugg_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,

Line 7669: l_sugg_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,

7665: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7666: p_msg_name => l_ExtContact_err_msg,
7667: p_token1 => 'DELIVERABLE_NAME',
7668: p_token1_value => del_rec.deliverable_name);
7669: l_sugg_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7670: p_msg_name => l_ExtContact_sugg_msg);
7671: Else
7672: l_qa_result_tbl(l_index).message_name := l_SupplierContact_err_msg;
7673: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,

Line 7673: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,

7669: l_sugg_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7670: p_msg_name => l_ExtContact_sugg_msg);
7671: Else
7672: l_qa_result_tbl(l_index).message_name := l_SupplierContact_err_msg;
7673: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7674: p_msg_name => l_SupplierContact_err_msg,
7675: p_token1 => 'DELIVERABLE_NAME',
7676: p_token1_value => del_rec.deliverable_name);
7677: l_sugg_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,

Line 7677: l_sugg_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,

7673: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7674: p_msg_name => l_SupplierContact_err_msg,
7675: p_token1 => 'DELIVERABLE_NAME',
7676: p_token1_value => del_rec.deliverable_name);
7677: l_sugg_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7678: p_msg_name => l_SupplierContact_sugg_msg);
7679: End If;
7680:
7681: l_qa_result_tbl(l_index).problem_details := l_err_message_txt;

Line 7818: OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,

7814: l_qa_result_tbl(l_index).message_name := 'OKC_DEL_MISSING_FIXED_ST_DATE';
7815:
7816: --- set problem long description
7817: l_qa_result_tbl(l_index).problem_details :=
7818: OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7819: p_msg_name => 'OKC_DEL_MISSING_FIXED_ST_DATE',
7820: p_token1 => 'DELIVERABLE_NAME',
7821: p_token1_value => del_rec.deliverable_name);
7822:

Line 7825: OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,

7821: p_token1_value => del_rec.deliverable_name);
7822:
7823: -- set suggestion for given qa message
7824: l_qa_result_tbl(l_index).suggestion :=
7825: OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7826: p_msg_name => 'OKC_DEL_REQUIRED_S');
7827:
7828: -- set return status for calling API to know, that there's a QA message
7829: --l_qa_status := OKC_API.G_RET_STS_ERROR;

Line 7844: OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,

7840: l_qa_result_tbl(l_index).message_name := 'OKC_DEL_DUE_DATE_ST_INCOMPLETE';
7841:
7842: --- set problem long description
7843: l_qa_result_tbl(l_index).problem_details :=
7844: OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7845: p_msg_name => 'OKC_DEL_DUE_DATE_ST_INCOMPLETE',
7846: p_token1 => 'DELIVERABLE_NAME',
7847: p_token1_value => del_rec.deliverable_name);
7848:

Line 7851: OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,

7847: p_token1_value => del_rec.deliverable_name);
7848:
7849: -- set suggestion for given qa message
7850: l_qa_result_tbl(l_index).suggestion :=
7851: OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7852: p_msg_name => 'OKC_DEL_REQUIRED_S');
7853:
7854: END IF; -- relative_st_event_id is null
7855: END IF; -- del_rec.fixed_start_date is null THEN

Line 7868: OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,

7864: l_qa_result_tbl(l_index).message_name := 'OKC_DEL_DUE_DATE_EN_INCOMPLETE';
7865:
7866: --- set problem long description
7867: l_qa_result_tbl(l_index).problem_details :=
7868: OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7869: p_msg_name => 'OKC_DEL_DUE_DATE_EN_INCOMPLETE',
7870: p_token1 => 'DELIVERABLE_NAME',
7871: p_token1_value => del_rec.deliverable_name);
7872:

Line 7875: OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,

7871: p_token1_value => del_rec.deliverable_name);
7872:
7873: -- set suggestion for given qa message
7874: l_qa_result_tbl(l_index).suggestion :=
7875: OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7876: p_msg_name => 'OKC_DEL_REQUIRED_S');
7877:
7878:
7879: END IF;

Line 8008: l_qa_result_tbl(l_index).problem_details := OKC_TERMS_UTIL_PVT.get_message(

8004: -- set qa message name
8005: l_qa_result_tbl(l_index).message_name := 'OKC_DEL_MISSING_RLTV_DATE';
8006:
8007: --- set problem long description
8008: l_qa_result_tbl(l_index).problem_details := OKC_TERMS_UTIL_PVT.get_message(
8009: p_app_name => G_OKC,
8010: p_msg_name => 'OKC_DEL_MISSING_RLTV_DATE',
8011: p_token1 => 'EVT_DATE_NAME',
8012: p_token1_value => qaMessages(1),

Line 8017: l_qa_result_tbl(l_index).suggestion := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,

8013: p_token2 => 'DELIVERABLE_NAME',
8014: p_token2_value => del_rec.deliverable_name);
8015:
8016: -- set suggestion for given qa message
8017: l_qa_result_tbl(l_index).suggestion := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
8018: p_msg_name => 'OKC_DEL_MISSING_RLTV_DATE_S',
8019: p_token1 => 'EVT_DATE_NAME',
8020: p_token1_value => qaMessages(1) );
8021:

Line 8036: l_qa_result_tbl(l_index).problem_details := OKC_TERMS_UTIL_PVT.get_message(

8032: -- set qa message name
8033: l_qa_result_tbl(l_index).message_name := 'OKC_DEL_MISSING_RLTV_DATES';
8034:
8035: --- set problem long description
8036: l_qa_result_tbl(l_index).problem_details := OKC_TERMS_UTIL_PVT.get_message(
8037: p_app_name => G_OKC,
8038: p_msg_name => 'OKC_DEL_MISSING_RLTV_DATES',
8039: p_token1 => 'EVT_DATE_NAME1',
8040: p_token1_value => qaMessages(1),

Line 8047: l_qa_result_tbl(l_index).suggestion := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,

8043: p_token3 => 'DELIVERABLE_NAME',
8044: p_token3_value => del_rec.deliverable_name);
8045:
8046: -- set suggestion for given qa message
8047: l_qa_result_tbl(l_index).suggestion := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
8048: p_msg_name => 'OKC_DEL_MISSING_RLTV_DATES_S',
8049: p_token1 => 'EVT_DATE_NAME1',
8050: p_token1_value => qaMessages(1),
8051: p_token2 => 'EVT_DATE_NAME2',

Line 8151: l_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,

8147:
8148: IF(del_rec.amendment_operation is not null and del_rec.amendment_notes is null) THEN
8149: l_index := l_index+1;
8150: l_qa_result_tbl(l_index).message_name := 'OKC_DEL_MISSING_AMEND_DESC';
8151: l_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
8152: p_msg_name => 'OKC_DEL_MISSING_AMEND_DESC',
8153: p_token1 => 'DELIVERABLE_NAME',
8154: p_token1_value => del_rec.deliverable_name);
8155: l_qa_result_tbl(l_index).problem_details := l_message_txt;

Line 8156: l_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,

8152: p_msg_name => 'OKC_DEL_MISSING_AMEND_DESC',
8153: p_token1 => 'DELIVERABLE_NAME',
8154: p_token1_value => del_rec.deliverable_name);
8155: l_qa_result_tbl(l_index).problem_details := l_message_txt;
8156: l_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
8157: p_msg_name => 'OKC_DEL_REQUIRED_S');
8158: l_qa_result_tbl(l_index).suggestion := l_message_txt;
8159:
8160: END IF;

Line 8233: l_msg_txt := OKC_TERMS_UTIL_PVT.get_message

8229: l_api_name CONSTANT VARCHAR2(30) := 'update_error_table';
8230: Begin
8231: l_return_status := G_RET_STS_SUCCESS;
8232: l_short_desc := get_lookup_meaning('OKC_TERM_QA_LIST',p_qa_code);
8233: l_msg_txt := OKC_TERMS_UTIL_PVT.get_message
8234: (p_app_name => G_OKC,
8235: p_msg_name => p_error_msg_name,
8236: p_token1 => 'DELIVERABLE_VARIABLE',
8237: p_token1_value => p_del_variable_name,

Line 8241: l_suggestion_txt := OKC_TERMS_UTIL_PVT.get_message

8237: p_token1_value => p_del_variable_name,
8238: p_token2 => 'ARTICLE_NAME',
8239: p_token2_value => p_article_name);
8240:
8241: l_suggestion_txt := OKC_TERMS_UTIL_PVT.get_message
8242: (p_app_name => G_OKC,
8243: p_msg_name => p_suggestion_msg_name);
8244: l_index := px_qa_result_tbl.count + 1;
8245: px_qa_result_tbl(l_index).error_severity := p_qa_severity;

Line 8547: p_article_name => okc_terms_util_pvt.get_Article_Name( get_variables_REC.article_id ,get_variables_REC.version_id), -- get_variables_REC.article_name,

8543: p_qa_code => l_qa_code,
8544: p_error_msg_name => 'OKC_DEL_VAR_NOT_RESOLVED',
8545: p_del_variable_name => get_variables_REC.variable_name, -- get_variables_REC.del_variable_name,
8546: p_article_id => get_variables_REC.article_id,
8547: p_article_name => okc_terms_util_pvt.get_Article_Name( get_variables_REC.article_id ,get_variables_REC.version_id), -- get_variables_REC.article_name,
8548: p_section_name => get_variables_REC.section_name,
8549: p_suggestion_msg_name => 'OKC_DEL_VAR_NOT_RESOLVED_S',
8550: x_return_status => l_return_status );
8551:

Line 8672: l_error_msg_text := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,

8668: AND del_rec.external_party_id is NULL) then
8669:
8670: l_index := l_index+1;
8671: l_qa_result_tbl(l_index).error_severity := G_QA_STS_ERROR;
8672: l_error_msg_text := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
8673: p_msg_name => l_error_msg_name,
8674: p_token1 => l_deliverable_name_token,
8675: p_token1_value => del_rec.deliverable_name);
8676: l_qa_result_tbl(l_index).problem_details := l_error_msg_text;

Line 8678: l_suggestion_msg_text := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,

8674: p_token1 => l_deliverable_name_token,
8675: p_token1_value => del_rec.deliverable_name);
8676: l_qa_result_tbl(l_index).problem_details := l_error_msg_text;
8677:
8678: l_suggestion_msg_text := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
8679: p_msg_name => l_suggestion_msg_name);
8680:
8681: l_qa_result_tbl(l_index).suggestion := l_suggestion_msg_text;
8682: l_qa_result_tbl(l_index).title := del_rec.deliverable_name;

Line 10215: l_msg := OKC_TERMS_UTIL_PVT.Get_Message(

10211: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'FIXED_END_DATE is : '|| p_fixed_end_date);
10212: END IF;
10213: -- bug#3465662 call this API if print due date msg name is not null
10214: IF p_print_due_date_msg_name IS NOT NULL THEN
10215: l_msg := OKC_TERMS_UTIL_PVT.Get_Message(
10216: p_app_name => 'OKC'
10217: ,p_msg_name => p_print_due_date_msg_name
10218: ,p_token1 => 'DAY_OF_WEEK'
10219: ,p_token1_value => l_day_of_week

Line 11022: OKC_TERMS_UTIL_PVT.deliverable_amendment_exists()

11018: /**
11019: 3635916 MODIFYING DELIVERABLE DOES NOT REMOVE RELATED CLAUSE
11020: FROM AMENDMENT SUMMARY
11021: This API will be invoked by
11022: OKC_TERMS_UTIL_PVT.deliverable_amendment_exists()
11023: Parameter Details:
11024: p_bus_doc_id : document Id
11025: p_bus_doc_type : document type
11026: p_variable_code: deliverable variable code