eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_DELIVERABLE_PROCESS_PVT dependencies on OKC_TERMS_UTIL_PVT

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

6651:
6652: END purge_doc_deliverables;
6653:
6654: /***
6655: 1. This API is invoked by OKC_TERMS_UTIL_PVT.merge_template_working_copy
6656: 2. This API will select all deliverables for a given
6657: business document type and version
6658: 3. Delete all deliverables along with the attachments and status history
6659: ***/

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

6831:
6832: END delete_deliverables;
6833:
6834: /***
6835: 1. This API is invoked by OKC_TERMS_UTIL_PVT.merge_template_working_copy
6836: 2. This API will select all deliverables for a given source template id
6837: 3. Update all deliverables on the target template Id
6838: set the business_document_id = source template id
6839: ***/

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

7577: IF(del_rec.notify_prior_due_date_value is null OR del_rec.notify_prior_due_date_uom is null) THEN
7578: l_index := l_index+1;
7579: l_qa_result_tbl(l_index).error_severity := G_QA_STS_ERROR;
7580: l_qa_result_tbl(l_index).message_name := 'OKC_DEL_NTF_DETAILS_REQUIRED';
7581: l_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7582: p_msg_name => 'OKC_DEL_NTF_DETAILS_REQUIRED',
7583: p_token1 => 'NOTIFICATION_TYPE',
7584: p_token1_value => 'prior due',
7585: p_token2 => 'DELIVERABLE_NAME',

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

7584: p_token1_value => 'prior due',
7585: p_token2 => 'DELIVERABLE_NAME',
7586: p_token2_value => del_rec.deliverable_name);
7587: l_qa_result_tbl(l_index).problem_details := l_message_txt;
7588: l_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7589: p_msg_name => 'OKC_DEL_NTF_DETAILS_REQUIRED_S');
7590: l_qa_result_tbl(l_index).suggestion := l_message_txt;
7591:
7592: END IF;

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

7601: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_ESCALATE_REQUIRED',del_rec.business_document_type);
7602: l_resolved_token := OKC_API.resolve_del_token(del_rec.business_document_type);
7603:
7604: /*l_qa_result_tbl(l_index).message_name := 'OKC_DEL_ESCALATE_REQUIRED';
7605: l_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7606: p_msg_name => 'OKC_DEL_ESCALATE_REQUIRED',
7607: p_token1 => 'DELIVERABLE_NAME',
7608: p_token1_value => del_rec.deliverable_name);*/
7609:

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

7607: p_token1 => 'DELIVERABLE_NAME',
7608: p_token1_value => del_rec.deliverable_name);*/
7609:
7610: l_qa_result_tbl(l_index).message_name := l_resolved_msg_name;
7611: l_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7612: p_msg_name => l_resolved_msg_name,
7613: p_token1 => 'DEL_TOKEN',
7614: p_token1_value => l_resolved_token,
7615: p_token2 => 'DELIVERABLE_NAME',

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

7618: l_qa_result_tbl(l_index).reference_column1 := 'DEL_TOKEN~' || l_resolved_token;
7619: l_qa_result_tbl(l_index).reference_column2 := 'DELIVERABLE_NAME~'||del_rec.deliverable_name;
7620:
7621: l_qa_result_tbl(l_index).problem_details := l_message_txt;
7622: l_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7623: p_msg_name => 'OKC_DEL_REQUIRED_S');
7624: l_qa_result_tbl(l_index).suggestion := l_message_txt;
7625:
7626: END IF;

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

7743: l_resolved_msg_name := OKC_API.resolve_message(l_IntContactMissing_err_msg,del_rec.business_document_type);
7744: l_resolved_token := OKC_API.resolve_del_token(del_rec.business_document_type);
7745:
7746: /* l_qa_result_tbl(l_index).message_name := l_IntContactMissing_err_msg;
7747: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7748: p_msg_name => l_IntContactMissing_err_msg,
7749: p_token1 => 'DELIVERABLE_NAME',
7750: p_token1_value => del_rec.deliverable_name); */
7751:

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

7749: p_token1 => 'DELIVERABLE_NAME',
7750: p_token1_value => del_rec.deliverable_name); */
7751:
7752: l_qa_result_tbl(l_index).message_name := l_resolved_msg_name;
7753: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7754: p_msg_name => l_resolved_msg_name,
7755: p_token1 => 'DEL_TOKEN',
7756: p_token1_value => l_resolved_token,
7757: p_token2 => 'DELIVERABLE_NAME',

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

7759:
7760: l_qa_result_tbl(l_index).reference_column1 := 'DEL_TOKEN~' || l_resolved_token;
7761: l_qa_result_tbl(l_index).reference_column2 := 'DELIVERABLE_NAME~'||del_rec.deliverable_name;
7762:
7763: l_sugg_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7764: p_msg_name => l_ContactMissing_sugg_msg);
7765:
7766: l_qa_result_tbl(l_index).problem_details := l_err_message_txt;
7767: l_qa_result_tbl(l_index).suggestion := l_sugg_message_txt;

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

7780: l_resolved_msg_name := OKC_API.resolve_message(l_IntContactInvalid_err_msg,del_rec.business_document_type);
7781: l_resolved_token := OKC_API.resolve_del_token(del_rec.business_document_type);
7782:
7783: /* l_qa_result_tbl(l_index).message_name := l_IntContactInvalid_err_msg;
7784: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7785: p_msg_name => l_IntContactInvalid_err_msg);*/
7786:
7787: l_qa_result_tbl(l_index).message_name := l_resolved_msg_name;
7788: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,

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

7784: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7785: p_msg_name => l_IntContactInvalid_err_msg);*/
7786:
7787: l_qa_result_tbl(l_index).message_name := l_resolved_msg_name;
7788: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7789: p_msg_name => l_resolved_msg_name,
7790: p_token1 => 'DEL_TOKEN',
7791: p_token1_value => l_resolved_token
7792: );

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

7792: );
7793:
7794: l_qa_result_tbl(l_index).reference_column1 := 'DEL_TOKEN~' || l_resolved_token;
7795:
7796: l_sugg_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7797: p_msg_name => l_IntContactInvalid_sugg_msg);
7798:
7799: l_qa_result_tbl(l_index).problem_details := l_err_message_txt;
7800: l_qa_result_tbl(l_index).suggestion := l_sugg_message_txt;

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

7817: l_resolved_msg_name := OKC_API.resolve_message(l_InvalidRequestor_err_msg,del_rec.business_document_type);
7818: l_resolved_token := OKC_API.resolve_del_token(del_rec.business_document_type);
7819:
7820: l_qa_result_tbl(l_index).message_name := l_resolved_msg_name;
7821: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7822: p_msg_name => l_resolved_msg_name,
7823: p_token1 => 'DEL_TOKEN',
7824: p_token1_value => l_resolved_token);
7825:

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

7825:
7826: l_qa_result_tbl(l_index).reference_column1 := 'DEL_TOKEN~' || l_resolved_token;
7827:
7828: /*l_qa_result_tbl(l_index).message_name := l_InvalidRequestor_err_msg;
7829: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7830: p_msg_name => l_InvalidRequestor_err_msg);*/
7831: l_qa_result_tbl(l_index).problem_details := l_err_message_txt;
7832: l_sugg_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7833: p_msg_name => l_InvalidRequestor_sugg_msg);

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

7828: /*l_qa_result_tbl(l_index).message_name := l_InvalidRequestor_err_msg;
7829: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7830: p_msg_name => l_InvalidRequestor_err_msg);*/
7831: l_qa_result_tbl(l_index).problem_details := l_err_message_txt;
7832: l_sugg_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7833: p_msg_name => l_InvalidRequestor_sugg_msg);
7834: l_qa_result_tbl(l_index).suggestion := l_sugg_message_txt;
7835:
7836: END IF;

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

7844: l_index := l_index+1;
7845: --l_qa_result_tbl(l_index).error_severity := G_QA_STS_ERROR;
7846: --Acq Plan Message Cleanup
7847: /*l_qa_result_tbl(l_index).message_name := l_InvalidEscAssgn_err_msg;
7848: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7849: p_msg_name => l_InvalidEscAssgn_err_msg);*/
7850:
7851: l_resolved_msg_name := OKC_API.resolve_message(l_InvalidEscAssgn_err_msg,del_rec.business_document_type);
7852: l_resolved_token := OKC_API.resolve_del_token(del_rec.business_document_type);

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

7852: l_resolved_token := OKC_API.resolve_del_token(del_rec.business_document_type);
7853:
7854:
7855: l_qa_result_tbl(l_index).message_name := l_InvalidEscAssgn_err_msg;
7856: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7857: p_msg_name => l_resolved_msg_name,
7858: p_token1 => 'DEL_TOKEN',
7859: p_token1_value => l_resolved_token);
7860: l_qa_result_tbl(l_index).problem_details := l_err_message_txt;

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

7860: l_qa_result_tbl(l_index).problem_details := l_err_message_txt;
7861:
7862: l_qa_result_tbl(l_index).reference_column1 := 'DEL_TOKEN~' || l_resolved_token;
7863:
7864: l_sugg_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7865: p_msg_name => l_InvalidEscAssgn_sugg_msg);
7866: l_qa_result_tbl(l_index).suggestion := l_sugg_message_txt;
7867:
7868: END IF;

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

7996: l_resolved_msg_name := OKC_API.resolve_message(l_exhibitMissing_err_msg,del_rec.business_document_type);
7997: l_resolved_token := OKC_API.resolve_del_token(del_rec.business_document_type);
7998:
7999: l_qa_result_tbl(l_index).message_name := l_resolved_msg_name;
8000: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
8001: p_msg_name => l_resolved_msg_name,
8002: p_token1 => 'DEL_TOKEN',
8003: p_token1_value => l_resolved_token,
8004: p_token2 => 'DELIVERABLE_NAME',

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

8009: l_qa_result_tbl(l_index).reference_column2 := 'DELIVERABLE_NAME~'||del_rec.deliverable_name;
8010:
8011:
8012:
8013: l_sugg_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
8014: p_msg_name => l_exhibitMissing_sugg_msg);
8015:
8016: l_qa_result_tbl(l_index).problem_details := l_err_message_txt;
8017: l_qa_result_tbl(l_index).suggestion := l_sugg_message_txt;

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

8129: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_INV_INT_CONT_EMAIL',del_rec.business_document_type);
8130: l_resolved_token := OKC_API.resolve_del_token(del_rec.business_document_type);
8131:
8132: /* l_qa_result_tbl(l_index).message_name := 'OKC_DEL_INV_INT_CONT_EMAIL';
8133: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
8134: p_msg_name => 'OKC_DEL_INV_INT_CONT_EMAIL');*/
8135:
8136: l_qa_result_tbl(l_index).message_name := l_resolved_msg_name;
8137: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,

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

8133: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
8134: p_msg_name => 'OKC_DEL_INV_INT_CONT_EMAIL');*/
8135:
8136: l_qa_result_tbl(l_index).message_name := l_resolved_msg_name;
8137: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
8138: p_msg_name => l_resolved_msg_name,
8139: p_token1 => 'DEL_TOKEN',
8140: p_token1_value => l_resolved_token
8141: );

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

8139: p_token1 => 'DEL_TOKEN',
8140: p_token1_value => l_resolved_token
8141: );
8142: l_qa_result_tbl(l_index).reference_column1 := 'DEL_TOKEN~' || l_resolved_token;
8143: l_sugg_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
8144: p_msg_name => 'OKC_DEL_INV_INT_CONT_EMAIL_S');
8145:
8146: l_qa_result_tbl(l_index).problem_details := l_err_message_txt;
8147: l_qa_result_tbl(l_index).suggestion := l_sugg_message_txt;

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

8164: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_INV_REQ_CONT_EMAIL',del_rec.business_document_type);
8165: l_resolved_token := OKC_API.resolve_del_token(del_rec.business_document_type);
8166:
8167: /* l_qa_result_tbl(l_index).message_name := 'OKC_DEL_INV_REQ_CONT_EMAIL';
8168: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
8169: p_msg_name => 'OKC_DEL_INV_REQ_CONT_EMAIL');*/
8170:
8171: l_qa_result_tbl(l_index).message_name := l_resolved_msg_name;
8172: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,

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

8168: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
8169: p_msg_name => 'OKC_DEL_INV_REQ_CONT_EMAIL');*/
8170:
8171: l_qa_result_tbl(l_index).message_name := l_resolved_msg_name;
8172: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
8173: p_msg_name => l_resolved_msg_name,
8174: p_token1 => 'DEL_TOKEN',
8175: p_token1_value => l_resolved_token
8176: );

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

8175: p_token1_value => l_resolved_token
8176: );
8177: l_qa_result_tbl(l_index).reference_column1 := 'DEL_TOKEN~' || l_resolved_token;
8178: l_qa_result_tbl(l_index).problem_details := l_err_message_txt;
8179: l_sugg_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
8180: p_msg_name => 'OKC_DEL_INV_INT_CONT_EMAIL_S');
8181: l_qa_result_tbl(l_index).suggestion := l_sugg_message_txt;
8182:
8183: END IF;

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

8192: IF l_contact_valid = 'N' THEN
8193:
8194: l_index := l_index+1;
8195: l_qa_result_tbl(l_index).message_name := 'OKC_DEL_INV_ESC_CONT_EMAIL';
8196: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
8197: p_msg_name => 'OKC_DEL_INV_ESC_CONT_EMAIL');
8198: l_qa_result_tbl(l_index).problem_details := l_err_message_txt;
8199: l_sugg_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
8200: p_msg_name => 'OKC_DEL_INV_INT_CONT_EMAIL_S');

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

8195: l_qa_result_tbl(l_index).message_name := 'OKC_DEL_INV_ESC_CONT_EMAIL';
8196: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
8197: p_msg_name => 'OKC_DEL_INV_ESC_CONT_EMAIL');
8198: l_qa_result_tbl(l_index).problem_details := l_err_message_txt;
8199: l_sugg_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
8200: p_msg_name => 'OKC_DEL_INV_INT_CONT_EMAIL_S');
8201: l_qa_result_tbl(l_index).suggestion := l_sugg_message_txt;
8202:
8203: END IF;

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

8335:
8336: If (l_doc_type_class = 'REPOSITORY') THEN
8337: --Acq Plan Messages Cleanup
8338: /*l_qa_result_tbl(l_index).message_name := l_ExtContact_err_msg;
8339: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
8340: p_msg_name => l_ExtContact_err_msg,
8341: p_token1 => 'DELIVERABLE_NAME',
8342: p_token1_value => del_rec.deliverable_name);*/
8343:

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

8344: l_resolved_msg_name := OKC_API.resolve_message(l_ExtContact_err_msg,del_rec.business_document_type);
8345: l_resolved_token := OKC_API.resolve_del_token(del_rec.business_document_type);
8346:
8347: l_qa_result_tbl(l_index).message_name := l_resolved_msg_name;
8348: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
8349: p_msg_name => l_resolved_msg_name,
8350: p_token1 => 'DEL_TOKEN',
8351: p_token1_value => l_resolved_token,
8352: p_token2 => 'DELIVERABLE_NAME',

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

8351: p_token1_value => l_resolved_token,
8352: p_token2 => 'DELIVERABLE_NAME',
8353: p_token2_value => del_rec.deliverable_name);
8354:
8355: l_sugg_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
8356: p_msg_name => l_ExtContact_sugg_msg);
8357: ELSE
8358: --Acq Plan Messages Cleanup
8359:

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

8357: ELSE
8358: --Acq Plan Messages Cleanup
8359:
8360: /* l_qa_result_tbl(l_index).message_name := l_SupplierContact_err_msg;
8361: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
8362: p_msg_name => l_SupplierContact_err_msg,
8363: p_token1 => 'DELIVERABLE_NAME',
8364: p_token1_value => del_rec.deliverable_name);*/
8365: l_resolved_msg_name := OKC_API.resolve_message(l_SupplierContact_err_msg,del_rec.business_document_type);

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

8365: l_resolved_msg_name := OKC_API.resolve_message(l_SupplierContact_err_msg,del_rec.business_document_type);
8366: l_resolved_token := OKC_API.resolve_del_token(del_rec.business_document_type);
8367:
8368: l_qa_result_tbl(l_index).message_name := l_resolved_msg_name;
8369: l_err_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
8370: p_msg_name => l_resolved_msg_name,
8371: p_token1 => 'DEL_TOKEN',
8372: p_token1_value => l_resolved_token,
8373: p_token2 => 'DELIVERABLE_NAME',

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

8372: p_token1_value => l_resolved_token,
8373: p_token2 => 'DELIVERABLE_NAME',
8374: p_token2_value => del_rec.deliverable_name);
8375:
8376: l_sugg_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
8377: p_msg_name => l_SupplierContact_sugg_msg);
8378: End If;
8379:
8380: l_qa_result_tbl(l_index).problem_details := l_err_message_txt;

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

8527: l_qa_result_tbl(l_index).message_name := l_resolved_msg_name;
8528:
8529: --- set problem long description
8530: l_qa_result_tbl(l_index).problem_details :=
8531: OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
8532: --p_msg_name => 'OKC_DEL_MISSING_FIXED_ST_DATE',
8533: p_msg_name => l_resolved_msg_name,
8534: p_token1 => 'DEL_TOKEN',
8535: -- p_token1_value => del_rec.deliverable_name,

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

8540: l_qa_result_tbl(l_index).reference_column1 := 'DEL_TOKEN~' || l_resolved_token;
8541: l_qa_result_tbl(l_index).reference_column2 := 'DELIVERABLE_NAME~'||del_rec.deliverable_name;
8542: -- set suggestion for given qa message
8543: l_qa_result_tbl(l_index).suggestion :=
8544: OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
8545: p_msg_name => 'OKC_DEL_REQUIRED_S');
8546:
8547: -- set return status for calling API to know, that there's a QA message
8548: --l_qa_status := OKC_API.G_RET_STS_ERROR;

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

8563: /* l_qa_result_tbl(l_index).message_name := 'OKC_DEL_DUE_DATE_ST_INCOMPLETE';
8564:
8565: --- set problem long description
8566: l_qa_result_tbl(l_index).problem_details :=
8567: OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
8568: p_msg_name => 'OKC_DEL_DUE_DATE_ST_INCOMPLETE',
8569: p_token1 => 'DELIVERABLE_NAME',
8570: p_token1_value => del_rec.deliverable_name);*/
8571:

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

8572: l_qa_result_tbl(l_index).message_name := l_resolved_msg_name;
8573:
8574: --- set problem long description
8575: l_qa_result_tbl(l_index).problem_details :=
8576: OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
8577: p_msg_name => l_resolved_msg_name,
8578: p_token1 => 'DEL_TOKEN',
8579: p_token1_value => l_resolved_token,
8580: p_token2 => 'DELIVERABLE_NAME',

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

8581: p_token2_value => del_rec.deliverable_name);
8582:
8583: -- set suggestion for given qa message
8584: l_qa_result_tbl(l_index).suggestion :=
8585: OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
8586: p_msg_name => 'OKC_DEL_REQUIRED_S');
8587:
8588: END IF; -- relative_st_event_id is null
8589: END IF; -- del_rec.fixed_start_date is null THEN

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

8602: /* l_qa_result_tbl(l_index).message_name := 'OKC_DEL_DUE_DATE_EN_INCOMPLETE';
8603:
8604: --- set problem long description
8605: l_qa_result_tbl(l_index).problem_details :=
8606: OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
8607: p_msg_name => 'OKC_DEL_DUE_DATE_EN_INCOMPLETE',
8608: p_token1 => 'DELIVERABLE_NAME',
8609: p_token1_value => del_rec.deliverable_name);*/
8610:

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

8611: l_qa_result_tbl(l_index).message_name := l_resolved_msg_name;
8612:
8613: --- set problem long description
8614: l_qa_result_tbl(l_index).problem_details :=
8615: OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
8616: p_msg_name => l_resolved_msg_name,
8617: p_token1 => 'DEL_TOKEN',
8618: p_token1_value => l_resolved_token,
8619: p_token2 => 'DELIVERABLE_NAME',

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

8619: p_token2 => 'DELIVERABLE_NAME',
8620: p_token2_value => del_rec.deliverable_name);
8621: -- set suggestion for given qa message
8622: l_qa_result_tbl(l_index).suggestion :=
8623: OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
8624: p_msg_name => 'OKC_DEL_REQUIRED_S');
8625:
8626:
8627: END IF;

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

8757: -- set qa message name
8758: l_qa_result_tbl(l_index).message_name := l_resolved_msg_name;
8759:
8760: --- set problem long description
8761: l_qa_result_tbl(l_index).problem_details := OKC_TERMS_UTIL_PVT.get_message(
8762: p_app_name => G_OKC,
8763: p_msg_name => l_resolved_msg_name,
8764: p_token1 => 'EVT_DATE_NAME',
8765: p_token1_value => qaMessages(1),

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

8772: l_qa_result_tbl(l_index).reference_column2 := 'DEL_TOKEN~' || l_resolved_token;
8773: l_qa_result_tbl(l_index).reference_column2 := 'DELIVERABLE_NAME~'||del_rec.deliverable_name;
8774:
8775: -- set suggestion for given qa message
8776: l_qa_result_tbl(l_index).suggestion := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
8777: p_msg_name => 'OKC_DEL_MISSING_RLTV_DATE_S',
8778: p_token1 => 'EVT_DATE_NAME',
8779: p_token1_value => qaMessages(1) );
8780:

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

8794: -- set qa message name
8795: l_qa_result_tbl(l_index).message_name := l_resolved_msg_name;
8796:
8797: --- set problem long description
8798: l_qa_result_tbl(l_index).problem_details := OKC_TERMS_UTIL_PVT.get_message(
8799: p_app_name => G_OKC,
8800: p_msg_name => l_resolved_msg_name,
8801: p_token1 => 'EVT_DATE_NAME1',
8802: p_token1_value => qaMessages(1),

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

8814:
8815:
8816:
8817: -- set suggestion for given qa message
8818: l_qa_result_tbl(l_index).suggestion := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
8819: p_msg_name => 'OKC_DEL_MISSING_RLTV_DATES_S',
8820: p_token1 => 'EVT_DATE_NAME1',
8821: p_token1_value => qaMessages(1),
8822: p_token2 => 'EVT_DATE_NAME2',

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

8926:
8927: --Acq Plan Message Cleanup
8928:
8929: /* l_qa_result_tbl(l_index).message_name := 'OKC_DEL_MISSING_AMEND_DESC';
8930: l_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
8931: p_msg_name => 'OKC_DEL_MISSING_AMEND_DESC',
8932: p_token1 => 'DELIVERABLE_NAME',
8933: p_token1_value => del_rec.deliverable_name);*/
8934:

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

8936: l_resolved_token := OKC_API.resolve_del_token(del_rec.business_document_type);
8937:
8938:
8939: l_qa_result_tbl(l_index).message_name := l_resolved_msg_name;
8940: l_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
8941: p_msg_name => l_resolved_msg_name,
8942: p_token1 => 'DEL_TOKEN',
8943: p_token1_value => l_resolved_token,
8944: p_token2 => 'DELIVERABLE_NAME',

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

8947: l_qa_result_tbl(l_index).reference_column1 := 'DEL_TOKEN~' || l_resolved_token;
8948: l_qa_result_tbl(l_index).reference_column2 := 'DELIVERABLE_NAME~'||del_rec.deliverable_name;
8949:
8950: l_qa_result_tbl(l_index).problem_details := l_message_txt;
8951: l_message_txt := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
8952: p_msg_name => 'OKC_DEL_REQUIRED_S');
8953: l_qa_result_tbl(l_index).suggestion := l_message_txt;
8954:
8955: END IF;

Line 9028: l_msg_txt := OKC_TERMS_UTIL_PVT.get_message

9024: l_api_name CONSTANT VARCHAR2(30) := 'update_error_table';
9025: Begin
9026: l_return_status := G_RET_STS_SUCCESS;
9027: l_short_desc := get_lookup_meaning('OKC_TERM_QA_LIST',p_qa_code);
9028: l_msg_txt := OKC_TERMS_UTIL_PVT.get_message
9029: (p_app_name => G_OKC,
9030: p_msg_name => p_error_msg_name,
9031: p_token1 => 'DELIVERABLE_VARIABLE',
9032: p_token1_value => p_del_variable_name,

Line 9036: l_suggestion_txt := OKC_TERMS_UTIL_PVT.get_message

9032: p_token1_value => p_del_variable_name,
9033: p_token2 => 'ARTICLE_NAME',
9034: p_token2_value => p_article_name);
9035:
9036: l_suggestion_txt := OKC_TERMS_UTIL_PVT.get_message
9037: (p_app_name => G_OKC,
9038: p_msg_name => p_suggestion_msg_name);
9039: l_index := px_qa_result_tbl.count + 1;
9040: px_qa_result_tbl(l_index).error_severity := p_qa_severity;

Line 9348: 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,

9344: p_qa_code => l_qa_code,
9345: p_error_msg_name => l_resolved_msg_name,
9346: p_del_variable_name => get_variables_REC.variable_name, -- get_variables_REC.del_variable_name,
9347: p_article_id => get_variables_REC.article_id,
9348: 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,
9349: p_section_name => get_variables_REC.section_name,
9350: p_suggestion_msg_name => l_resolved_msg_name2,
9351: x_return_status => l_return_status );
9352:

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

9481: --Acq Plan Message Cleanup
9482: l_resolved_msg_name := OKC_API.resolve_message(l_error_msg_name,del_rec.business_document_type);
9483: l_resolved_token := OKC_API.resolve_del_token(del_rec.business_document_type);
9484:
9485: l_error_msg_text := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
9486: p_msg_name => l_resolved_msg_name,
9487: p_token1 => 'DEL_TOKEN',
9488: p_token1_value => l_resolved_token,
9489: p_token2 => l_deliverable_name_token,

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

9497: --Acq Plan Message Cleanup
9498: l_resolved_msg_name := OKC_API.resolve_message(l_suggestion_msg_name,del_rec.business_document_type);
9499: l_resolved_token := OKC_API.resolve_del_token(del_rec.business_document_type);
9500:
9501: l_suggestion_msg_text := OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
9502: p_msg_name => l_resolved_msg_name,
9503: p_token1 => 'DEL_TOKEN',
9504: p_token1_value => l_resolved_token
9505: );

Line 11174: l_msg := OKC_TERMS_UTIL_PVT.Get_Message(

11170: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'FIXED_END_DATE is : '|| p_fixed_end_date);
11171: END IF;
11172: -- bug#3465662 call this API if print due date msg name is not null
11173: IF p_print_due_date_msg_name IS NOT NULL THEN
11174: l_msg := OKC_TERMS_UTIL_PVT.Get_Message(
11175: p_app_name => 'OKC'
11176: ,p_msg_name => p_print_due_date_msg_name
11177: ,p_token1 => 'DAY_OF_WEEK'
11178: ,p_token1_value => l_day_of_week

Line 12041: OKC_TERMS_UTIL_PVT.deliverable_amendment_exists()

12037: /**
12038: 3635916 MODIFYING DELIVERABLE DOES NOT REMOVE RELATED CLAUSE
12039: FROM AMENDMENT SUMMARY
12040: This API will be invoked by
12041: OKC_TERMS_UTIL_PVT.deliverable_amendment_exists()
12042: Parameter Details:
12043: p_bus_doc_id : document Id
12044: p_bus_doc_type : document type
12045: p_variable_code: deliverable variable code

Line 13579: l_st_ba := OKC_TERMS_UTIL_PVT.Get_Message(

13575:
13576: l_st_event := l_st_event_rec.event_name;
13577:
13578: IF (l_st_event_rec.before_after='B') THEN
13579: l_st_ba := OKC_TERMS_UTIL_PVT.Get_Message(
13580: p_app_name => 'OKC'
13581: ,p_msg_name => 'OKC_DEL_BEFORE_TOKEN'
13582: );
13583:

Line 13585: l_st_ba := OKC_TERMS_UTIL_PVT.Get_Message(

13581: ,p_msg_name => 'OKC_DEL_BEFORE_TOKEN'
13582: );
13583:
13584: ELSIF (l_st_event_rec.before_after='A') THEN
13585: l_st_ba := OKC_TERMS_UTIL_PVT.Get_Message(
13586: p_app_name => 'OKC'
13587: ,p_msg_name => 'OKC_DEL_AFTER_TOKEN'
13588: );
13589: END IF;

Line 13601: l_end_ba := OKC_TERMS_UTIL_PVT.Get_Message(

13597: l_end_event := l_end_event_rec.event_name;
13598:
13599:
13600: IF (l_end_event_rec.before_after='B') THEN
13601: l_end_ba := OKC_TERMS_UTIL_PVT.Get_Message(
13602: p_app_name => 'OKC'
13603: ,p_msg_name => 'OKC_DEL_BEFORE_TOKEN'
13604: );
13605: ELSIF (l_end_event_rec.before_after='A') THEN

Line 13606: l_end_ba := OKC_TERMS_UTIL_PVT.Get_Message(

13602: p_app_name => 'OKC'
13603: ,p_msg_name => 'OKC_DEL_BEFORE_TOKEN'
13604: );
13605: ELSIF (l_end_event_rec.before_after='A') THEN
13606: l_end_ba := OKC_TERMS_UTIL_PVT.Get_Message(
13607: p_app_name => 'OKC'
13608: ,p_msg_name => 'OKC_DEL_AFTER_TOKEN'
13609: );
13610: END IF;

Line 13616: l_st_date_uom := OKC_TERMS_UTIL_PVT.Get_Message(

13612:
13613: IF p_relative_st_date_uom IS NOT NULL THEN
13614:
13615: IF (p_relative_st_date_uom like 'MTH%') THEN
13616: l_st_date_uom := OKC_TERMS_UTIL_PVT.Get_Message(
13617: p_app_name => 'OKC'
13618: ,p_msg_name => 'OKC_DEL_MONTHS_TOKEN'
13619: );
13620: ELSIF (p_relative_st_date_uom like 'WK%') THEN

Line 13621: l_st_date_uom := OKC_TERMS_UTIL_PVT.Get_Message(

13617: p_app_name => 'OKC'
13618: ,p_msg_name => 'OKC_DEL_MONTHS_TOKEN'
13619: );
13620: ELSIF (p_relative_st_date_uom like 'WK%') THEN
13621: l_st_date_uom := OKC_TERMS_UTIL_PVT.Get_Message(
13622: p_app_name => 'OKC'
13623: ,p_msg_name => 'OKC_DEL_WEEKS_TOKEN'
13624: );
13625: ELSIF (p_relative_st_date_uom like 'DAY%') THEN

Line 13626: l_st_date_uom := OKC_TERMS_UTIL_PVT.Get_Message(

13622: p_app_name => 'OKC'
13623: ,p_msg_name => 'OKC_DEL_WEEKS_TOKEN'
13624: );
13625: ELSIF (p_relative_st_date_uom like 'DAY%') THEN
13626: l_st_date_uom := OKC_TERMS_UTIL_PVT.Get_Message(
13627: p_app_name => 'OKC'
13628: ,p_msg_name => 'OKC_DEL_DAYS_TOKEN'
13629: );
13630: END IF;

Line 13636: l_end_date_uom := OKC_TERMS_UTIL_PVT.Get_Message(

13632:
13633: IF p_relative_end_date_uom IS NOT NULL THEN
13634:
13635: IF (p_relative_end_date_uom like 'MTH%') THEN
13636: l_end_date_uom := OKC_TERMS_UTIL_PVT.Get_Message(
13637: p_app_name => 'OKC'
13638: ,p_msg_name => 'OKC_DEL_MONTH_TOKEN'
13639: );
13640: ELSIF (p_relative_end_date_uom like 'WK%') THEN

Line 13641: l_end_date_uom := OKC_TERMS_UTIL_PVT.Get_Message(

13637: p_app_name => 'OKC'
13638: ,p_msg_name => 'OKC_DEL_MONTH_TOKEN'
13639: );
13640: ELSIF (p_relative_end_date_uom like 'WK%') THEN
13641: l_end_date_uom := OKC_TERMS_UTIL_PVT.Get_Message(
13642: p_app_name => 'OKC'
13643: ,p_msg_name => 'OKC_DEL_WEEK_TOKEN'
13644: );
13645: ELSIF (p_relative_end_date_uom like 'DAY%') THEN

Line 13646: l_end_date_uom := OKC_TERMS_UTIL_PVT.Get_Message(

13642: p_app_name => 'OKC'
13643: ,p_msg_name => 'OKC_DEL_WEEK_TOKEN'
13644: );
13645: ELSIF (p_relative_end_date_uom like 'DAY%') THEN
13646: l_end_date_uom := OKC_TERMS_UTIL_PVT.Get_Message(
13647: p_app_name => 'OKC'
13648: ,p_msg_name => 'OKC_DEL_DAY_TOKEN'
13649: );
13650: END IF;

Line 13664: l_msg := OKC_TERMS_UTIL_PVT.Get_Message(

13660: end if;
13661:
13662: -- Case 1, both start and end dates are fixed
13663: IF p_relative_st_date_event_id IS NULL AND p_relative_end_date_event_id IS NULL THEN
13664: l_msg := OKC_TERMS_UTIL_PVT.Get_Message(
13665: p_app_name => 'OKC'
13666: ,p_msg_name => 'OKC_DEL_RD_FS_FE'
13667: ,p_token1 => 'FREQ_NUM'
13668: ,p_token1_value => l_repeating_duration

Line 13676: l_msg := OKC_TERMS_UTIL_PVT.Get_Message(

13672: ,p_token3_value => p_fixed_end_date
13673: );
13674: ELSIF p_relative_st_date_event_id IS NULL AND p_relative_end_date_event_id IS NOT NULL
13675: THEN
13676: l_msg := OKC_TERMS_UTIL_PVT.Get_Message(
13677: p_app_name => 'OKC'
13678: ,p_msg_name => 'OKC_DEL_RD_FS_RE'
13679: ,p_token1 => 'FREQ_NUM'
13680: ,p_token1_value => l_repeating_duration

Line 13695: l_msg := OKC_TERMS_UTIL_PVT.Get_Message(

13691: );
13692: ELSIF p_relative_st_date_event_id IS NOT NULL AND p_relative_end_date_event_id IS NULL
13693: THEN
13694:
13695: l_msg := OKC_TERMS_UTIL_PVT.Get_Message(
13696: p_app_name => 'OKC'
13697: ,p_msg_name => 'OKC_DEL_RD_FS_RE'
13698: ,p_token1 => 'FREQ_NUM'
13699: ,p_token1_value => l_repeating_duration

Line 13715: l_msg := OKC_TERMS_UTIL_PVT.Get_Message(

13711:
13712:
13713: ELSIF p_relative_st_date_event_id IS NOT NULL AND p_relative_end_date_event_id IS NOT NULL THEN
13714:
13715: l_msg := OKC_TERMS_UTIL_PVT.Get_Message(
13716: p_app_name => 'OKC'
13717: ,p_msg_name => 'OKC_DEL_RD_RS_RE'
13718: ,p_token1 => 'FREQ_NUM'
13719: ,p_token1_value => l_repeating_duration