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 192: IEX_DEBUG_PUB.LogMessage('Create_strategy_work_items: ' || 'No Data Found');

188:
189: --dbms_output.put_line('ERRRRRRRROS is '||l_msg_data) ;
190: if ( l_return_status = 'E') then
191: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
192: IEX_DEBUG_PUB.LogMessage('Create_strategy_work_items: ' || 'No Data Found');
193: END IF;
194: RAISE FND_API.G_EXC_ERROR;
195: elsif ( l_return_status ='U') then
196: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

193: END IF;
194: RAISE FND_API.G_EXC_ERROR;
195: elsif ( l_return_status ='U') then
196: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
197: IEX_DEBUG_PUB.LogMessage('Create_strategy_work_items: ' || 'Create UwqmProcedure failed');
198: END IF;
199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
200: end if ;
201: END;

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

199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
200: end if ;
201: END;
202: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
203: IEX_DEBUG_PUB.LogMessage('Create_strategy_work_items: ' || 'In if metaphor');
204: END IF;
205: end if ;
206: --end of profile enabled checking
207: end if ;

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

222: );
223:
224: -- IF PG_DEBUG < 10 THEN
225: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
226: IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_strategy_work_items_PVT.Create_strategy_work_items ******** ');
227: END IF;
228: EXCEPTION
229: WHEN FND_API.G_EXC_ERROR THEN
230: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

327: BEGIN
328:
329: -- IF PG_DEBUG < 10 THEN
330: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
331: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_strategy_work_items_PVT.update_strategy_work_items ******** ');
332: END IF;
333: -- Standard Start of API savepoint
334: SAVEPOINT UPDATE_strategy_work_items_PVT;
335:

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

404: l_work_item_temp_id := p_strategy_work_item_rec.WORK_ITEM_TEMPLATE_ID ;
405: l_work_item_id := p_strategy_work_item_rec.WORK_ITEM_ID ;
406: l_strategy_id := p_strategy_work_item_rec.STRATEGY_ID ;
407: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
408: IEX_DEBUG_PUB.LogMessage('Update_strategy_work_items: ' || 'In VIMPIIIIIIII '||l_work_item_id);
409: END IF;
410: IEX_STRY_UWQ_PVT.Update_uwq_item(
411: p_api_version => 1.0,
412: p_init_msg_list => FND_API.G_TRUE,

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

417: x_msg_count => l_msg_count,
418: x_msg_data => l_msg_data) ;
419: if ( l_return_status = 'E') then
420: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
421: IEX_DEBUG_PUB.LogMessage('Update_strategy_work_items: ' || 'No Data Found');
422: END IF;
423: RAISE FND_API.G_EXC_ERROR;
424: elsif ( l_return_status ='U') then
425: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

422: END IF;
423: RAISE FND_API.G_EXC_ERROR;
424: elsif ( l_return_status ='U') then
425: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
426: IEX_DEBUG_PUB.LogMessage('Update_strategy_work_items: ' || 'Create UwqmProcedure failed');
427: END IF;
428: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
429: end if ;
430: END;

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

428: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
429: end if ;
430: END;
431: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
432: IEX_DEBUG_PUB.LogMessage('Update_strategy_work_items: ' || 'In if metaphor');
433: END IF;
434: end if ;
435: --end of profile enabled checking
436: end if ;

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

462:
463: EXCEPTION
464: WHEN OTHERS THEN
465: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
466: IEX_DEBUG_PUB.LogMessage( debug_msg => 'IEU_UWQM_ITEMS' || to_char(p_strategy_work_item_rec.work_item_id), print_date => 'Y');
467: END IF;
468: AS_UTILITY_PVT.Set_Message(
469: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
470: p_msg_name => 'IEX_METAPHOR_CREATION_FAILED',

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

474:
475: END;
476: -- IF PG_DEBUG < 10 THEN
477: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
478: IEX_DEBUG_PUB.LogMessage('Update_strategy_work_items: ' || 'In if metaphor');
479: END IF;
480: end if ;
481: --end of profile enabled checking
482: end if ;

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

492: p_data => x_msg_data
493: );
494: -- IF PG_DEBUG < 10 THEN
495: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
496: IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_strategy_work_items_PVT.update_strategy_work_items ******** ');
497: END IF;
498: EXCEPTION
499: WHEN FND_API.G_EXC_ERROR THEN
500: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(