DBA Data[Home] [Help]

APPS.OE_BULK_ORDER_PVT dependencies on OE_BULK_MSG_PUB

Line 134: OE_BULK_MSG_PUB.Add_Exc_Msg

130: EXCEPTION
131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
133: WHEN OTHERS THEN
134: OE_BULK_MSG_PUB.Add_Exc_Msg
135: ( G_PKG_NAME
136: , 'Delete_Error_Records'
137: );
138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 216: OE_BULK_MSG_PUB.Add_Exc_Msg

212: EXCEPTION
213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
215: WHEN OTHERS THEN
216: OE_BULK_MSG_PUB.Add_Exc_Msg
217: ( G_PKG_NAME
218: , 'Process_Invalid_Records'
219: );
220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 286: OE_BULK_MSG_PUB.Add_Exc_Msg

282: EXCEPTION
283: WHEN OTHERS THEN
284: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
285: THEN
286: OE_BULK_MSG_PUB.Add_Exc_Msg
287: (G_PKG_NAME
288: ,'Update_DBI_log');
289: END IF;
290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 381: oe_debug_pub.add( 'SAVING MESSAGES '||OE_BULK_MSG_PUB.G_MSG_TBL.MESSAGE.COUNT ) ;

377: -- Insert Messages into DB from above processing call
378: -------------------------------------------------------------------
379:
380: IF l_debug_level > 0 THEN
381: oe_debug_pub.add( 'SAVING MESSAGES '||OE_BULK_MSG_PUB.G_MSG_TBL.MESSAGE.COUNT ) ;
382: END IF;
383:
384: -- Bug 5640601 =>
385: -- Selecting hsecs from v$times is changed to execute only when debug

Line 391: OE_Bulk_Msg_PUB.Save_Messages(G_REQUEST_ID);

387: IF l_debug_level > 0 Then
388: SELECT hsecs INTO l_start_time from v$timer;
389: end if;
390:
391: OE_Bulk_Msg_PUB.Save_Messages(G_REQUEST_ID);
392:
393: -- Bug 5640601 =>
394: -- Selecting hsecs from v$times is changed to execute only when debug
395: -- is enabled, as hsec is used for logging only when debug is enabled.

Line 454: OE_BULK_MSG_PUB.Add_Exc_Msg

450: EXCEPTION
451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
453: WHEN OTHERS THEN
454: OE_BULK_MSG_PUB.Add_Exc_Msg
455: ( G_PKG_NAME
456: , 'Process_Headers'
457: );
458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 547: oe_debug_pub.add( 'SAVING MESSAGES '||OE_BULK_MSG_PUB.G_MSG_TBL.MESSAGE.COUNT ) ;

543:
544:
545: -- Insert Messages
546: IF l_debug_level > 0 THEN
547: oe_debug_pub.add( 'SAVING MESSAGES '||OE_BULK_MSG_PUB.G_MSG_TBL.MESSAGE.COUNT ) ;
548: END IF;
549: OE_Bulk_Msg_PUB.Save_Messages(G_REQUEST_ID);
550:
551: -- Update Headers Interface for Invalid Lines

Line 549: OE_Bulk_Msg_PUB.Save_Messages(G_REQUEST_ID);

545: -- Insert Messages
546: IF l_debug_level > 0 THEN
547: oe_debug_pub.add( 'SAVING MESSAGES '||OE_BULK_MSG_PUB.G_MSG_TBL.MESSAGE.COUNT ) ;
548: END IF;
549: OE_Bulk_Msg_PUB.Save_Messages(G_REQUEST_ID);
550:
551: -- Update Headers Interface for Invalid Lines
552: -- Bug 5640601 =>
553: -- Selecting hsecs from v$times is changed to execute only when debug

Line 597: OE_BULK_MSG_PUB.Add_Exc_Msg

593: EXCEPTION
594: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
596: WHEN OTHERS THEN
597: OE_BULK_MSG_PUB.Add_Exc_Msg
598: ( G_PKG_NAME
599: , 'Process_Lines'
600: );
601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1101: OE_BULK_MSG_PUB.Add_Exc_Msg

1097: EXCEPTION
1098: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1100: WHEN OTHERS THEN
1101: OE_BULK_MSG_PUB.Add_Exc_Msg
1102: ( G_PKG_NAME
1103: , 'Post_Process'
1104: );
1105: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1147: OE_BULK_MSG_PUB.initialize;

1143:
1144: -- Initialize message list
1145:
1146: IF FND_API.to_Boolean(p_init_msg_list) THEN
1147: OE_BULK_MSG_PUB.initialize;
1148: END IF;
1149:
1150: -- Establish SAVEPOINT
1151:

Line 1380: OE_BULK_MSG_PUB.Count_And_Get

1376:
1377:
1378: -- Get message count and data
1379:
1380: OE_BULK_MSG_PUB.Count_And_Get
1381: ( p_count => x_msg_count
1382: , p_data => x_msg_data
1383: );
1384:

Line 1394: OE_BULK_MSG_PUB.Count_And_Get

1390: END IF;
1391: ROLLBACK TO SAVEPOINT Process_Batch;
1392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1393: -- Get message count and data
1394: OE_BULK_MSG_PUB.Count_And_Get
1395: ( p_count => x_msg_count
1396: , p_data => x_msg_data
1397: );
1398: WHEN OTHERS THEN

Line 1407: OE_BULK_MSG_PUB.Add_Exc_Msg

1403: oe_debug_pub.add( 'SQL ERROR :'||SQLERRM ) ;
1404: END IF;
1405: ROLLBACK TO SAVEPOINT Process_Batch;
1406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1407: OE_BULK_MSG_PUB.Add_Exc_Msg
1408: ( G_PKG_NAME
1409: , 'Process_Batch'
1410: );
1411: -- Get message count and data

Line 1412: OE_BULK_MSG_PUB.Count_And_Get

1408: ( G_PKG_NAME
1409: , 'Process_Batch'
1410: );
1411: -- Get message count and data
1412: OE_BULK_MSG_PUB.Count_And_Get
1413: ( p_count => x_msg_count
1414: , p_data => x_msg_data
1415: );
1416: END Process_Batch;

Line 1482: IF OE_BULK_MSG_PUB.check_msg_level(OE_BULK_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1478: WHEN OTHERS THEN
1479: IF l_debug_level > 0 THEN
1480: oe_debug_pub.add( 'in others exception ' || SQLERRM ) ;
1481: END IF;
1482: IF OE_BULK_MSG_PUB.check_msg_level(OE_BULK_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1483: THEN
1484: OE_BULK_MSG_PUB.add_exc_msg
1485: (G_PKG_NAME
1486: ,'Mark_Header_Error'

Line 1484: OE_BULK_MSG_PUB.add_exc_msg

1480: oe_debug_pub.add( 'in others exception ' || SQLERRM ) ;
1481: END IF;
1482: IF OE_BULK_MSG_PUB.check_msg_level(OE_BULK_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1483: THEN
1484: OE_BULK_MSG_PUB.add_exc_msg
1485: (G_PKG_NAME
1486: ,'Mark_Header_Error'
1487: );
1488: END IF;