APPS.IEX_ATA_PUB dependencies on IEX_UTILITIES

Line 81: l_req_id_lst IEX_UTILITIES.t_numbers;

77: l_debug NUMBER(15);
78: l_AssignLevel VARCHAR2(20); -- Added by gnramasa on 29/08/2006 for bug # 5487449
79: l_date_str VARCHAR2(255);
80: --Begin Bug 7697167 27-Jan-2009 barathsr
81: l_req_id_lst IEX_UTILITIES.t_numbers;
82: cnt number:=0;--23/01
83: uphase VARCHAR2(255);
84: dphase VARCHAR2(255);
85: ustatus VARCHAR2(255);

Line 119: /* If iex_utilities.validate_running_level(l_Assignlevel) <> 'Y' then

115: l_Assignlevel:= NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
116: FND_FILE.PUT_LINE(FND_FILE.LOG,'Territory Assignment Level, Profile IEX: Territory Access Level(IEX_ACCESS_LEVEL) := ' ||l_Assignlevel);
117:
118: -- Start for bug 8708291 pnaveenk
119: /* If iex_utilities.validate_running_level(l_Assignlevel) <> 'Y' then
120: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Territory Assignment Level at Profile IEX: Territory Level not exists in the Strategy Level set up');
121: End if; */
122:
123: Begin

Line 128: AND iex_utilities.validate_running_level(LOOKUP_CODE)='Y';

124:
125: SELECT count(*) into l_str_level_count
126: FROM IEX_LOOKUPS_V
127: WHERE LOOKUP_TYPE='IEX_RUNNING_LEVEL'
128: AND iex_utilities.validate_running_level(LOOKUP_CODE)='Y';
129:
130: select iex_utilities.validate_running_level(decode(P_STR_LEVEL,'PARTY','CUSTOMER','ACCOUNT','ACCOUNT','BILLTOSITE','BILL_TO','BILL_TO'))
131: into l_str_status
132: from dual;

Line 130: select iex_utilities.validate_running_level(decode(P_STR_LEVEL,'PARTY','CUSTOMER','ACCOUNT','ACCOUNT','BILLTOSITE','BILL_TO','BILL_TO'))

126: FROM IEX_LOOKUPS_V
127: WHERE LOOKUP_TYPE='IEX_RUNNING_LEVEL'
128: AND iex_utilities.validate_running_level(LOOKUP_CODE)='Y';
129:
130: select iex_utilities.validate_running_level(decode(P_STR_LEVEL,'PARTY','CUSTOMER','ACCOUNT','ACCOUNT','BILLTOSITE','BILL_TO','BILL_TO'))
131: into l_str_status
132: from dual;
133:
134: If l_str_level_count > 1 then