233: ------------------------------------------------------------------
234: -- Record this function call in the error
235: -- system in case of an exception
236: ------------------------------------------------------------------
237: fnd_message.set_name('XNP','STD_ERROR');
238: fnd_message.set_token(
239: 'ERROR_LOCN','XNP_WF_STANDARD.SET_SDP_CONTEXT');
240: fnd_message.set_token('ERROR_TEXT',
241: ':'||to_char(SQLCODE)||':'||SQLERRM);
234: -- Record this function call in the error
235: -- system in case of an exception
236: ------------------------------------------------------------------
237: fnd_message.set_name('XNP','STD_ERROR');
238: fnd_message.set_token(
239: 'ERROR_LOCN','XNP_WF_STANDARD.SET_SDP_CONTEXT');
240: fnd_message.set_token('ERROR_TEXT',
241: ':'||to_char(SQLCODE)||':'||SQLERRM);
242: x_progress := fnd_message.get;
236: ------------------------------------------------------------------
237: fnd_message.set_name('XNP','STD_ERROR');
238: fnd_message.set_token(
239: 'ERROR_LOCN','XNP_WF_STANDARD.SET_SDP_CONTEXT');
240: fnd_message.set_token('ERROR_TEXT',
241: ':'||to_char(SQLCODE)||':'||SQLERRM);
242: x_progress := fnd_message.get;
243: wf_core.context(
244: 'XNP_WF_STANDARD'
238: fnd_message.set_token(
239: 'ERROR_LOCN','XNP_WF_STANDARD.SET_SDP_CONTEXT');
240: fnd_message.set_token('ERROR_TEXT',
241: ':'||to_char(SQLCODE)||':'||SQLERRM);
242: x_progress := fnd_message.get;
243: wf_core.context(
244: 'XNP_WF_STANDARD'
245: , 'SET_SDP_CONTEXT'
246: , itemtype
3759: -- Record this function call in the error
3760: -- system in case of an exception
3761: ------------------------------------------------------------------
3762:
3763: fnd_message.set_name('XNP','STD_ERROR');
3764: fnd_message.set_token(
3765: 'ERROR_LOCN','XNP_WF_STANDARD.REJECT_MESSAGE');
3766: fnd_message.set_token('ERROR_TEXT',
3767: ':'||to_char(SQLCODE)||':'||SQLERRM);
3760: -- system in case of an exception
3761: ------------------------------------------------------------------
3762:
3763: fnd_message.set_name('XNP','STD_ERROR');
3764: fnd_message.set_token(
3765: 'ERROR_LOCN','XNP_WF_STANDARD.REJECT_MESSAGE');
3766: fnd_message.set_token('ERROR_TEXT',
3767: ':'||to_char(SQLCODE)||':'||SQLERRM);
3768: x_progress := fnd_message.get;
3762:
3763: fnd_message.set_name('XNP','STD_ERROR');
3764: fnd_message.set_token(
3765: 'ERROR_LOCN','XNP_WF_STANDARD.REJECT_MESSAGE');
3766: fnd_message.set_token('ERROR_TEXT',
3767: ':'||to_char(SQLCODE)||':'||SQLERRM);
3768: x_progress := fnd_message.get;
3769: wf_core.context(
3770: 'XNP_WF_STANDARD'
3764: fnd_message.set_token(
3765: 'ERROR_LOCN','XNP_WF_STANDARD.REJECT_MESSAGE');
3766: fnd_message.set_token('ERROR_TEXT',
3767: ':'||to_char(SQLCODE)||':'||SQLERRM);
3768: x_progress := fnd_message.get;
3769: wf_core.context(
3770: 'XNP_WF_STANDARD'
3771: , 'REJECT_MESSAGE'
3772: ,itemtype
3840: -- Record this function call in the error
3841: -- system in case of an exception
3842: ------------------------------------------------------------------
3843:
3844: fnd_message.set_name('XNP','STD_ERROR');
3845: fnd_message.set_token(
3846: 'ERROR_LOCN','XNP_WF_STANDARD.RETRY_MESSAGE');
3847: fnd_message.set_token('ERROR_TEXT',
3848: ':'||to_char(SQLCODE)||':'||SQLERRM);
3841: -- system in case of an exception
3842: ------------------------------------------------------------------
3843:
3844: fnd_message.set_name('XNP','STD_ERROR');
3845: fnd_message.set_token(
3846: 'ERROR_LOCN','XNP_WF_STANDARD.RETRY_MESSAGE');
3847: fnd_message.set_token('ERROR_TEXT',
3848: ':'||to_char(SQLCODE)||':'||SQLERRM);
3849: x_progress := fnd_message.get;
3843:
3844: fnd_message.set_name('XNP','STD_ERROR');
3845: fnd_message.set_token(
3846: 'ERROR_LOCN','XNP_WF_STANDARD.RETRY_MESSAGE');
3847: fnd_message.set_token('ERROR_TEXT',
3848: ':'||to_char(SQLCODE)||':'||SQLERRM);
3849: x_progress := fnd_message.get;
3850: wf_core.context(
3851: 'XNP_WF_STANDARD'
3845: fnd_message.set_token(
3846: 'ERROR_LOCN','XNP_WF_STANDARD.RETRY_MESSAGE');
3847: fnd_message.set_token('ERROR_TEXT',
3848: ':'||to_char(SQLCODE)||':'||SQLERRM);
3849: x_progress := fnd_message.get;
3850: wf_core.context(
3851: 'XNP_WF_STANDARD'
3852: , 'RETRY_MESSAGE'
3853: ,itemtype
6658: l_ORDER_ID := g_ORDER_ID;
6659:
6660: ------------------------------------------------------------------
6661: -- Get the activity attribute NOTIFN_MSG_NAME
6662: -- Get the string corresponding to this FND message
6663: -- parse to see the tokens in it. Substitute the tokens
6664: -- with the value
6665: ------------------------------------------------------------------
6666: l_notfn_msg_name :=
7575: WHEN OTHERS THEN
7576: /* Record this function call in the error
7577: * system in case of an exception
7578: */
7579: fnd_message.set_name('XNP','STD_ERROR');
7580: fnd_message.set_token(
7581: 'ERROR_LOCN','XNP_WF_TIMERS.DEREGISTER');
7582: if(l_error_code <> 0) then
7583: fnd_message.set_token('ERROR_TEXT',
7576: /* Record this function call in the error
7577: * system in case of an exception
7578: */
7579: fnd_message.set_name('XNP','STD_ERROR');
7580: fnd_message.set_token(
7581: 'ERROR_LOCN','XNP_WF_TIMERS.DEREGISTER');
7582: if(l_error_code <> 0) then
7583: fnd_message.set_token('ERROR_TEXT',
7584: ':'||to_char(l_error_code)||':'||l_error_message);
7579: fnd_message.set_name('XNP','STD_ERROR');
7580: fnd_message.set_token(
7581: 'ERROR_LOCN','XNP_WF_TIMERS.DEREGISTER');
7582: if(l_error_code <> 0) then
7583: fnd_message.set_token('ERROR_TEXT',
7584: ':'||to_char(l_error_code)||':'||l_error_message);
7585: else
7586: fnd_message.set_token('ERROR_TEXT',
7587: ':'||to_char(SQLCODE)||':'||SQLERRM);
7582: if(l_error_code <> 0) then
7583: fnd_message.set_token('ERROR_TEXT',
7584: ':'||to_char(l_error_code)||':'||l_error_message);
7585: else
7586: fnd_message.set_token('ERROR_TEXT',
7587: ':'||to_char(SQLCODE)||':'||SQLERRM);
7588: end if;
7589: x_progress := fnd_message.get;
7590: wf_core.context(
7585: else
7586: fnd_message.set_token('ERROR_TEXT',
7587: ':'||to_char(SQLCODE)||':'||SQLERRM);
7588: end if;
7589: x_progress := fnd_message.get;
7590: wf_core.context(
7591: 'XNP_WF_STANDARD'
7592: , 'DEREGISTERALL'
7593: , itemtype