eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEX_STRATEGY_WORK_ITEMS_PVT dependencies on FND_LOG

Line 10: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

6:
7:
8: -- Hint: Primary key needs to be returned.
9: --PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
10: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
11:
12: PROCEDURE Create_strategy_work_items(
13: P_Api_Version_Number IN NUMBER,
14: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

Line 41: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

37: Cursor c2 is SELECT iex_strategy_work_items_S.nextval from dual;
38:
39: BEGIN
40: -- IF PG_DEBUG < 10 THEN
41: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
42: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_strategy_work_items_PVT.Create_strategy_work_items ******** ');
43: END IF;
44: -- Standard Start of API savepoint
45: SAVEPOINT CREATE_strategy_work_items_PVT;

Line 56: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

52: THEN
53: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
54: END IF;
55: -- IF PG_DEBUG < 10 THEN
56: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
57: IEX_DEBUG_PUB.LogMessage('Create_strategy_work_items: ' || 'After Compatibility Check');
58: END IF;
59:
60: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 86: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

82: END IF;
83: RAISE FND_API.G_EXC_ERROR;
84: END IF;
85: -- IF PG_DEBUG < 10 THEN
86: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
87: IEX_DEBUG_PUB.LogMessage('Create_strategy_work_items: ' || 'After Global user Check');
88: END IF;
89:
90: --object version Number

Line 97: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

93: OPEN C2;
94: FETCH C2 INTO v_work_item_id;
95: CLOSE C2;
96: -- IF PG_DEBUG < 10 THEN
97: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
98: IEX_DEBUG_PUB.LogMessage('Create_strategy_work_items: ' || 'After work_item_id Check and work_item_id is => '||v_work_item_id);
99: END IF;
100:
101: --strategy Id check

Line 111: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

107: fnd_msg_pub.add;
108: RAISE FND_API.G_EXC_ERROR;
109: END IF;
110: -- IF PG_DEBUG < 10 THEN
111: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
112: IEX_DEBUG_PUB.LogMessage ('Create_strategy_work_items: ' || 'After strategy id check');
113: END IF;
114:
115: --resource Id check

Line 125: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

121: fnd_msg_pub.add;
122: RAISE FND_API.G_EXC_ERROR;
123: END IF;
124: -- IF PG_DEBUG < 10 THEN
125: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
126: IEX_DEBUG_PUB.LogMessage ('Create_strategy_work_items: ' || 'After resource id check');
127: END IF;
128:
129:

Line 131: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

127: END IF;
128:
129:
130: -- IF PG_DEBUG < 10 THEN
131: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
132: IEX_DEBUG_PUB.LogMessage('Create_strategy_work_items: ' || 'Before Calling iex_strategies_pkg.insert_row');
133: END IF;
134:
135: -- Invoke table handler(IEX_STRATEGY_WORK_ITEMS_PKG.Insert_Row)

Line 204: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

200: x_msg_data => l_msg_data) ;
201:
202: --dbms_output.put_line('ERRRRRRRROS is '||l_msg_data) ;
203: if ( l_return_status = 'E') then
204: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
205: IEX_DEBUG_PUB.LogMessage('Create_strategy_work_items: ' || 'No Data Found');
206: END IF;
207: RAISE FND_API.G_EXC_ERROR;
208: elsif ( l_return_status ='U') then

Line 209: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

205: IEX_DEBUG_PUB.LogMessage('Create_strategy_work_items: ' || 'No Data Found');
206: END IF;
207: RAISE FND_API.G_EXC_ERROR;
208: elsif ( l_return_status ='U') then
209: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
210: IEX_DEBUG_PUB.LogMessage('Create_strategy_work_items: ' || 'Create UwqmProcedure failed');
211: END IF;
212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
213: end if ;

Line 215: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

211: END IF;
212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
213: end if ;
214: END;
215: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
216: IEX_DEBUG_PUB.LogMessage('Create_strategy_work_items: ' || 'In if metaphor');
217: END IF;
218: end if ;
219: --end of profile enabled checking

Line 238: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

234: p_data => x_msg_data
235: );
236:
237: -- IF PG_DEBUG < 10 THEN
238: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
239: IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_strategy_work_items_PVT.Create_strategy_work_items ******** ');
240: END IF;
241: EXCEPTION
242: WHEN FND_API.G_EXC_ERROR THEN

Line 343: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

339:
340: BEGIN
341:
342: -- IF PG_DEBUG < 10 THEN
343: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
344: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_strategy_work_items_PVT.update_strategy_work_items ******** ');
345: END IF;
346: -- Standard Start of API savepoint
347: SAVEPOINT UPDATE_strategy_work_items_PVT;

Line 420: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

416: BEGIN
417: l_work_item_temp_id := p_strategy_work_item_rec.WORK_ITEM_TEMPLATE_ID ;
418: l_work_item_id := p_strategy_work_item_rec.WORK_ITEM_ID ;
419: l_strategy_id := p_strategy_work_item_rec.STRATEGY_ID ;
420: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
421: IEX_DEBUG_PUB.LogMessage('Update_strategy_work_items: ' || 'In VIMPIIIIIIII '||l_work_item_id);
422: END IF;
423: IEX_STRY_UWQ_PVT.Update_uwq_item(
424: p_api_version => 1.0,

Line 433: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

429: x_return_status => l_return_status,
430: x_msg_count => l_msg_count,
431: x_msg_data => l_msg_data) ;
432: if ( l_return_status = 'E') then
433: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
434: IEX_DEBUG_PUB.LogMessage('Update_strategy_work_items: ' || 'No Data Found');
435: END IF;
436: RAISE FND_API.G_EXC_ERROR;
437: elsif ( l_return_status ='U') then

Line 438: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

434: IEX_DEBUG_PUB.LogMessage('Update_strategy_work_items: ' || 'No Data Found');
435: END IF;
436: RAISE FND_API.G_EXC_ERROR;
437: elsif ( l_return_status ='U') then
438: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
439: IEX_DEBUG_PUB.LogMessage('Update_strategy_work_items: ' || 'Create UwqmProcedure failed');
440: END IF;
441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
442: end if ;

Line 444: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

440: END IF;
441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
442: end if ;
443: END;
444: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
445: IEX_DEBUG_PUB.LogMessage('Update_strategy_work_items: ' || 'In if metaphor');
446: END IF;
447: end if ;
448: --end of profile enabled checking

Line 478: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

474: x_msg_data => l_msg_data) ;
475:
476: EXCEPTION
477: WHEN OTHERS THEN
478: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
479: IEX_DEBUG_PUB.LogMessage( debug_msg => 'IEU_UWQM_ITEMS' || to_char(p_strategy_work_item_rec.work_item_id), print_date => 'Y');
480: END IF;
481: AS_UTILITY_PVT.Set_Message(
482: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 490: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
487:
488: END;
489: -- IF PG_DEBUG < 10 THEN
490: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
491: IEX_DEBUG_PUB.LogMessage('Update_strategy_work_items: ' || 'In if metaphor');
492: END IF;
493: end if ;
494: --end of profile enabled checking

Line 508: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

504: ( p_count => x_msg_count,
505: p_data => x_msg_data
506: );
507: -- IF PG_DEBUG < 10 THEN
508: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
509: IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_strategy_work_items_PVT.update_strategy_work_items ******** ');
510: END IF;
511: EXCEPTION
512: WHEN FND_API.G_EXC_ERROR THEN