DBA Data[Home] [Help]

APPS.IEX_UWQ_SEL_PKG dependencies on IEX_UWQ_SEL_PKG

Line 1: PACKAGE BODY IEX_UWQ_SEL_PKG AS

1: PACKAGE BODY IEX_UWQ_SEL_PKG AS
2: /* $Header: iextmslb.pls 120.1.12010000.2 2009/01/05 13:20:41 pnaveenk noship $ */
3:
4:
5: PROCEDURE LogMessage(l_Message varchar2) IS

Line 663: iex_debug_pub.LogMessage('IEX_UWQ_SEL_PKG.handleFooTask :Begin ++');

659: p_action_name OUT NOCOPY varchar2,
660: p_action_param OUT NOCOPY varchar2)
661: is
662: BEGIN
663: iex_debug_pub.LogMessage('IEX_UWQ_SEL_PKG.handleFooTask :Begin ++');
664: l_task_id := '';
665: l_source_code := '';
666: l_source_code_id := '';
667: l_source_campaign_id := 0;

Line 673: iex_debug_pub.LogMessage('IEX_UWQ_SEL_PKG.handleFooTask :l_nm_PARTY_ID' || l_nm_PARTY_ID);

669:
670: iex_debug_pub.LogMessage('Calling getFooData ++');
671: getFooData(p_mediaTable);
672: iex_debug_pub.LogMessage('Returned from getFooData --');
673: iex_debug_pub.LogMessage('IEX_UWQ_SEL_PKG.handleFooTask :l_nm_PARTY_ID' || l_nm_PARTY_ID);
674: iex_debug_pub.LogMessage('IEX_UWQ_SEL_PKG.handleFooTask :l_Task_ID' || l_Task_ID);
675: /*
676: If l_nm_party_id <> 0 then
677: p_action_name := 'IEXRCALL';

Line 674: iex_debug_pub.LogMessage('IEX_UWQ_SEL_PKG.handleFooTask :l_Task_ID' || l_Task_ID);

670: iex_debug_pub.LogMessage('Calling getFooData ++');
671: getFooData(p_mediaTable);
672: iex_debug_pub.LogMessage('Returned from getFooData --');
673: iex_debug_pub.LogMessage('IEX_UWQ_SEL_PKG.handleFooTask :l_nm_PARTY_ID' || l_nm_PARTY_ID);
674: iex_debug_pub.LogMessage('IEX_UWQ_SEL_PKG.handleFooTask :l_Task_ID' || l_Task_ID);
675: /*
676: If l_nm_party_id <> 0 then
677: p_action_name := 'IEXRCALL';
678:

Line 716: iex_debug_pub.LogMessage('IEX_UWQ_SEL_PKG.handleFooTask :final l_nm_PARTY_ID' || l_nm_PARTY_ID);

712: INTO l_nm_PARTY_ID
713: from jtf_tasks_b
714: WHERE task_id=l_Task_ID;
715: END if;
716: iex_debug_pub.LogMessage('IEX_UWQ_SEL_PKG.handleFooTask :final l_nm_PARTY_ID' || l_nm_PARTY_ID);
717: If l_nm_PARTY_ID IS NULL OR l_nm_PARTY_ID=0 then
718: iex_debug_pub.LogMessage('IEX_UWQ_SEL_PKG.handleFooTask :Party_id is NULL, So opening the Task manager screen instead of IEXRCALL');
719: p_action_name := 'JTFTKMAN' ;
720: p_action_param := 'TASK_ID=' || l_Task_ID;

Line 718: iex_debug_pub.LogMessage('IEX_UWQ_SEL_PKG.handleFooTask :Party_id is NULL, So opening the Task manager screen instead of IEXRCALL');

714: WHERE task_id=l_Task_ID;
715: END if;
716: iex_debug_pub.LogMessage('IEX_UWQ_SEL_PKG.handleFooTask :final l_nm_PARTY_ID' || l_nm_PARTY_ID);
717: If l_nm_PARTY_ID IS NULL OR l_nm_PARTY_ID=0 then
718: iex_debug_pub.LogMessage('IEX_UWQ_SEL_PKG.handleFooTask :Party_id is NULL, So opening the Task manager screen instead of IEXRCALL');
719: p_action_name := 'JTFTKMAN' ;
720: p_action_param := 'TASK_ID=' || l_Task_ID;
721: p_action_type := 2;
722: ELSE

Line 744: END IEX_UWQ_SEL_PKG;

740: l_AreaCodeLength := NVL(FND_PROFILE.VALUE('AST_AREA_CODE_LENGTH'), 3);
741: l_PhoneNumberLength := NVL(FND_PROFILE.VALUE('AST_PHONE_NUMBER_LENGTH'), 7);
742: l_DumpData := NVL(FND_PROFILE.VALUE('AST_DUMP_PARAMS'), 'N');
743:
744: END IEX_UWQ_SEL_PKG;