[Home] [Help]
1: PACKAGE BODY XNP_UTILS AS
2: /* $Header: XNPUTILB.pls 120.1 2005/06/17 03:44:45 appldev $ */
3:
4: g_new_line CONSTANT VARCHAR2(10) := convert(fnd_global.local_chr(10),
5: substr(userenv('LANGUAGE'), instr(userenv('LANGUAGE'),'.') +1),
254: /* BUG 1500177
255: -- get the Adapter name
256: */
257: -- get the fe name
258: XNP_UTILS.GET_FE_NAME_FOR_SP
259: (p_SP_ID=>l_DONOR_SP_ID
260: ,x_FE_NAME=>x_FE_NAME
261: ,x_ERROR_CODE=>x_RETURN_CODE
262: ,x_ERROR_MESSAGE=>x_ERROR_DESCRIPTION
331: /* BUG 1500177
332: -- get the fe name
333: */
334: -- get the fe name
335: XNP_UTILS.GET_FE_NAME_FOR_SP
336: (p_SP_ID=>l_ORIGINAL_DONOR_SP_ID
337: ,x_FE_NAME=>x_FE_NAME
338: ,x_ERROR_CODE=>x_RETURN_CODE
339: ,x_ERROR_MESSAGE=>x_ERROR_DESCRIPTION
405: /* BUG 1500177
406: -- get the fe name
407: */
408: -- get the fe name
409: XNP_UTILS.GET_FE_NAME_FOR_SP
410: (p_SP_ID=>l_NRC_SP_ID
411: ,x_FE_NAME=>x_FE_NAME
412: ,x_ERROR_CODE=>x_RETURN_CODE
413: ,x_ERROR_MESSAGE=>x_ERROR_DESCRIPTION
491: /* BUG 1500177
492: -- get the fe name
493: */
494: -- get the fe name
495: XNP_UTILS.GET_FE_NAME_FOR_SP
496: (p_SP_ID=>l_RECIPIENT_SP_ID
497: ,x_FE_NAME=>x_FE_NAME
498: ,x_ERROR_CODE=>x_RETURN_CODE
499: ,x_ERROR_MESSAGE=>x_ERROR_DESCRIPTION
556: /* BUG 1500177
557: -- get the fe name
558: */
559: -- get the fe name
560: XNP_UTILS.GET_FE_NAME_FOR_SP
561: (p_SP_ID=>l_SENDER_SP_ID
562: ,x_FE_NAME=>x_FE_NAME
563: ,x_ERROR_CODE=>x_RETURN_CODE
564: ,x_ERROR_MESSAGE=>x_ERROR_DESCRIPTION
635: end if;
636:
637: EXCEPTION
638: WHEN OTHERS THEN
639: --wf_core.context( 'XNP_UTILS'
640: -- , 'CANONICAL_TO_DATE'
641: -- , 'String format of given date is invalid hence returning NULL: Allowed format is :'||l_CANONICAL_DT_MASK
642: -- , null
643: -- , null
675: end if;
676:
677: EXCEPTION
678: WHEN OTHERS THEN
679: --wf_core.context( 'XNP_UTILS'
680: -- , 'DATE_TO_CANONICAL'
681: -- , 'Date format of given date is invalid hence returning NULL: Preferred format is :'||l_CANONICAL_DT_MASK
682: -- , null
683: -- , null
1317: END IF;
1318:
1319: CLOSE c_get_process_reference;
1320:
1321: XNP_UTILS.GET_WF_INSTANCE
1322: (P_PROCESS_REFERENCE => l_process_reference
1323: ,X_WF_TYPE => l_wf_type
1324: ,X_WF_KEY => l_wf_key
1325: ,X_WF_ACTIVITY => l_wf_activity
1334: EXCEPTION
1335: WHEN NO_DATA_FOUND THEN
1336: x_error_code := SQLCODE;
1337: fnd_message.set_name('XNP','STD_GET_FAILED');
1338: fnd_message.set_token('FAILED_PROC','XNP_UTILS.GET_WORKITEM_INSTANCE_ID');
1339: fnd_message.set_token('ATTRNAME','PROCESS_REFERENCE');
1340: fnd_message.set_token('KEY','REFERENCE_ID');
1341: fnd_message.set_token('VALUE',p_reference_id);
1342: x_error_message := fnd_message.get||':'||SQLERRM;
1347:
1348: WHEN OTHERS THEN
1349: x_error_code := SQLCODE;
1350: fnd_message.set_name('XNP','STD_ERROR');
1351: fnd_message.set_token('ERROR_LOCN','XNP_UTILS.GET_WORKITEM_INSTANCE_ID');
1352: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1353: x_error_message := fnd_message.get;
1354:
1355: IF c_get_process_reference%ISOPEN THEN
1484: BEGIN
1485:
1486: -- Copy all the workitem parameters one by one
1487: FOR wi_param IN c_wi_params LOOP
1488: XNP_UTILS.COPY_WI_PARAM_VALUE
1489: (p_src_wi_id => p_src_wi_id
1490: ,p_dest_wi_id => p_dest_wi_id
1491: ,p_param_name => wi_param.name
1492: );
1554: ,1
1555: ,instr(substr(l_string,instr(l_string,'&')+1),' ')
1556: );
1557:
1558: l_posn := instr(token, xnp_utils.g_new_line);
1559: if(l_posn > 0) then
1560: token := substr(token,1,l_posn-1);
1561: end if;
1562: l_posn := 0;
1576: END LOOP;
1577:
1578: l_body := fnd_message.get;
1579: x_body := l_body;
1580: x_subject := substr(l_body,1,instr(l_body,xnp_utils.g_new_line));
1581: return;
1582:
1583: END GET_INTERPRETED_NOTIFICATION;
1584:
1748: END IF;
1749:
1750: END CHECK_IF_NUM_RANGE_EXISTS;
1751:
1752: END XNP_UTILS;