DBA Data[Home] [Help]

APPS.IEX_STRY_UTL_PUB dependencies on IEX_STRATEGY_WORK_ITEMS_PVT

Line 262: l_strategy_work_item_rec IEX_strategy_work_items_PVT.strategy_work_item_Rec_Type;

258: l_return_status VARCHAR2(1);
259: l_msg_count NUMBER;
260: l_msg_data VARCHAR2(32767);
261: l_api_version_number CONSTANT NUMBER := 2.0;
262: l_strategy_work_item_rec IEX_strategy_work_items_PVT.strategy_work_item_Rec_Type;
263: l_strategy_rec IEX_strategy_PVT.strategy_Rec_Type;
264: l_object_version_number NUMBER;
265:
266: Cursor c_get_work_items (p_strategy_id NUMBER) is

Line 338: iex_debug_pub.logMessage('CLOSE_STRY_AND_WITEMS: ' || 'Before Calling IEX_STRATEGY_WORK_ITEMS_PVT.Update_strategy_work_items');

334: :=c_get_work_items_rec.object_version_number;
335: l_strategy_work_item_Rec.execute_end := sysdate;
336: -- IF PG_DEBUG < 10 THEN
337: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
338: iex_debug_pub.logMessage('CLOSE_STRY_AND_WITEMS: ' || 'Before Calling IEX_STRATEGY_WORK_ITEMS_PVT.Update_strategy_work_items');
339: END IF;
340: -- IF PG_DEBUG < 10 THEN
341: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
342: iex_debug_pub.logMessage('CLOSE_STRY_AND_WITEMS: ' || '---------------------------------');

Line 345: IEX_STRATEGY_WORK_ITEMS_PVT.Update_strategy_work_items(

341: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
342: iex_debug_pub.logMessage('CLOSE_STRY_AND_WITEMS: ' || '---------------------------------');
343: END IF;
344:
345: IEX_STRATEGY_WORK_ITEMS_PVT.Update_strategy_work_items(
346: P_Api_Version_Number =>l_api_version_number,
347: P_strategy_work_item_Rec =>l_strategy_work_item_Rec,
348: P_Init_Msg_List =>FND_API.G_TRUE,
349: p_commit =>FND_API.G_TRUE,

Line 357: iex_debug_pub.logMessage('CLOSE_STRY_AND_WITEMS: ' || 'After Calling IEX_STRATEGY_WORK_ITEMS_PVT.Update_strategy_work_items '||

353: x_return_status => l_return_status,
354: XO_OBJECT_VERSION_NUMBER =>l_object_version_number );
355: -- IF PG_DEBUG < 10 THEN
356: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
357: iex_debug_pub.logMessage('CLOSE_STRY_AND_WITEMS: ' || 'After Calling IEX_STRATEGY_WORK_ITEMS_PVT.Update_strategy_work_items '||
358: 'and Status =>'||l_return_status);
359: END IF;
360: IF l_return_status = FND_API.G_RET_STS_ERROR then
361: AddFailMsg( p_object => 'STRATEGY_WORK_ITEMS',

Line 665: l_strategy_work_item_rec IEX_strategy_work_items_PVT.strategy_work_item_Rec_Type;

661: l_return_status VARCHAR2(1);
662: l_msg_count NUMBER;
663: l_msg_data VARCHAR2(32767);
664: l_api_version_number CONSTANT NUMBER := 2.0;
665: l_strategy_work_item_rec IEX_strategy_work_items_PVT.strategy_work_item_Rec_Type;
666: l_object_version_number NUMBER;
667:
668: Cursor c_get_work_items (p_work_item_id NUMBER) is
669: SELECT object_version_number

Line 739: iex_debug_pub.logMessage('UPDATE_WORK_ITEM: ' || 'Before Calling IEX_STRATEGY_WORK_ITEMS_PVT.Update_strategy_work_items');

735: :=c_get_work_items_rec.object_version_number;
736: l_strategy_work_item_Rec.execute_end := sysdate;
737: -- IF PG_DEBUG < 10 THEN
738: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
739: iex_debug_pub.logMessage('UPDATE_WORK_ITEM: ' || 'Before Calling IEX_STRATEGY_WORK_ITEMS_PVT.Update_strategy_work_items');
740: END IF;
741: -- IF PG_DEBUG < 10 THEN
742: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
743: iex_debug_pub.logMessage('UPDATE_WORK_ITEM: ' || '---------------------------------');

Line 746: IEX_STRATEGY_WORK_ITEMS_PVT.Update_strategy_work_items(

742: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
743: iex_debug_pub.logMessage('UPDATE_WORK_ITEM: ' || '---------------------------------');
744: END IF;
745:
746: IEX_STRATEGY_WORK_ITEMS_PVT.Update_strategy_work_items(
747: P_Api_Version_Number =>l_api_version_number,
748: P_strategy_work_item_Rec =>l_strategy_work_item_Rec,
749: P_Init_Msg_List =>FND_API.G_TRUE,
750: p_commit =>FND_API.G_TRUE,

Line 758: iex_debug_pub.logMessage('UPDATE_WORK_ITEM: ' || 'After Calling IEX_STRATEGY_WORK_ITEMS_PVT.Update_strategy_work_items '||

754: x_return_status => l_return_status,
755: XO_OBJECT_VERSION_NUMBER =>l_object_version_number );
756: -- IF PG_DEBUG < 10 THEN
757: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
758: iex_debug_pub.logMessage('UPDATE_WORK_ITEM: ' || 'After Calling IEX_STRATEGY_WORK_ITEMS_PVT.Update_strategy_work_items '||
759: 'and Status =>'||l_return_status);
760: END IF;
761: IF l_return_status = FND_API.G_RET_STS_ERROR then
762: AddFailMsg( p_object => 'STRATEGY_WORK_ITEMS',

Line 1539: iex_strategy_work_items_pvt.strategy_work_item_Rec_Type,

1535: **/
1536:
1537: /*
1538: PROCEDURE UPDATE_AND_SENDSIGNAL( P_strategy_work_item_Rec IN
1539: iex_strategy_work_items_pvt.strategy_work_item_Rec_Type,
1540: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1541: x_return_status OUT NOCOPY VARCHAR2,
1542: x_msg_count OUT NOCOPY NUMBER,
1543: x_msg_data OUT NOCOPY VARCHAR2)IS

Line 1557: iex_strategy_work_items_pvt.update_strategy_work_items(

1553: SAVEPOINT UPDATE_AND_SENDSIGNAL;
1554:
1555: x_return_status := FND_API.G_RET_STS_SUCCESS;
1556:
1557: iex_strategy_work_items_pvt.update_strategy_work_items(
1558: p_api_version_number => 2.0,
1559: p_init_msg_list => FND_API.G_TRUE,
1560: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1561: p_commit => p_commit,