DBA Data[Home] [Help]

APPS.IEX_STRATEGY_WORK_ITEMS_PVT dependencies on IEX_DEBUG_PUB

Line 42: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_strategy_work_items_PVT.Create_strategy_work_items ******** ');

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;
46:

Line 57: IEX_DEBUG_PUB.LogMessage('Create_strategy_work_items: ' || 'After Compatibility Check');

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.
61: IF FND_API.to_Boolean( p_init_msg_list )

Line 87: IEX_DEBUG_PUB.LogMessage('Create_strategy_work_items: ' || 'After Global user Check');

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
91: v_object_version_number :=1;

Line 98: IEX_DEBUG_PUB.LogMessage('Create_strategy_work_items: ' || 'After work_item_id Check and work_item_id is => '||v_work_item_id);

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
102: IF (P_strategy_work_item_rec.strategy_id IS NULL) OR

Line 112: IEX_DEBUG_PUB.LogMessage ('Create_strategy_work_items: ' || 'After strategy id check');

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
116: IF (P_strategy_work_item_rec.resource_id IS NULL) OR

Line 126: IEX_DEBUG_PUB.LogMessage ('Create_strategy_work_items: ' || 'After resource id check');

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:
130: -- IF PG_DEBUG < 10 THEN

Line 132: IEX_DEBUG_PUB.LogMessage('Create_strategy_work_items: ' || 'Before Calling iex_strategies_pkg.insert_row');

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)
136: IEX_STRATEGY_WORK_ITEMS_PKG.Insert_Row(

Line 205: IEX_DEBUG_PUB.LogMessage('Create_strategy_work_items: ' || 'No Data Found');

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
209: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 210: IEX_DEBUG_PUB.LogMessage('Create_strategy_work_items: ' || 'Create UwqmProcedure failed');

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 ;
214: END;

Line 216: IEX_DEBUG_PUB.LogMessage('Create_strategy_work_items: ' || 'In if metaphor');

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
220: end if ;

Line 239: IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_strategy_work_items_PVT.Create_strategy_work_items ******** ');

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
243: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

Line 344: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_strategy_work_items_PVT.update_strategy_work_items ******** ');

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;
348:

Line 421: IEX_DEBUG_PUB.LogMessage('Update_strategy_work_items: ' || 'In VIMPIIIIIIII '||l_work_item_id);

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,
425: p_init_msg_list => FND_API.G_TRUE,

Line 434: IEX_DEBUG_PUB.LogMessage('Update_strategy_work_items: ' || 'No Data Found');

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
438: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 439: IEX_DEBUG_PUB.LogMessage('Update_strategy_work_items: ' || 'Create UwqmProcedure failed');

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 ;
443: END;

Line 445: IEX_DEBUG_PUB.LogMessage('Update_strategy_work_items: ' || 'In if metaphor');

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
449: end if ;

Line 479: IEX_DEBUG_PUB.LogMessage( debug_msg => 'IEU_UWQM_ITEMS' || to_char(p_strategy_work_item_rec.work_item_id), print_date => 'Y');

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,
483: p_msg_name => 'IEX_METAPHOR_CREATION_FAILED',

Line 491: IEX_DEBUG_PUB.LogMessage('Update_strategy_work_items: ' || 'In if metaphor');

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
495: end if ;

Line 509: IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_strategy_work_items_PVT.update_strategy_work_items ******** ');

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
513: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(