4983: ELSE
4984: l_msg_code := l_message_code_about_to_expire;
4985: END IF;
4986:
4987: fnd_message.clear;
4988: --set message name
4989: fnd_message.set_name(
4990: application =>l_app_name,
4991: name =>l_msg_code);
4985: END IF;
4986:
4987: fnd_message.clear;
4988: --set message name
4989: fnd_message.set_name(
4990: application =>l_app_name,
4991: name =>l_msg_code);
4992: --set message tokens
4993: fnd_message.set_token(
4989: fnd_message.set_name(
4990: application =>l_app_name,
4991: name =>l_msg_code);
4992: --set message tokens
4993: fnd_message.set_token(
4994: token => l_message_token_con_number,
4995: value => p_contract_number);
4996: fnd_message.set_token(
4997: token => l_message_token_con_version,
4992: --set message tokens
4993: fnd_message.set_token(
4994: token => l_message_token_con_number,
4995: value => p_contract_number);
4996: fnd_message.set_token(
4997: token => l_message_token_con_version,
4998: value => p_contract_version);
4999:
5000: --get fnd message
4996: fnd_message.set_token(
4997: token => l_message_token_con_version,
4998: value => p_contract_version);
4999:
5000: --get fnd message
5001: l_subject_text := fnd_message.get;
5002:
5003: --set message subject
5004: wf_engine.SetItemAttrText (
4997: token => l_message_token_con_version,
4998: value => p_contract_version);
4999:
5000: --get fnd message
5001: l_subject_text := fnd_message.get;
5002:
5003: --set message subject
5004: wf_engine.SetItemAttrText (
5005: itemtype => l_item_type,