DBA Data[Home] [Help]

APPS.OE_BULK_ORDER_PVT dependencies on OE_BULK_MSG_PUB

Line 118: OE_BULK_MSG_PUB.Add_Exc_Msg

114: EXCEPTION
115: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
117: WHEN OTHERS THEN
118: OE_BULK_MSG_PUB.Add_Exc_Msg
119: ( G_PKG_NAME
120: , 'Delete_Error_Records'
121: );
122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 176: OE_BULK_MSG_PUB.Add_Exc_Msg

172: EXCEPTION
173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
175: WHEN OTHERS THEN
176: OE_BULK_MSG_PUB.Add_Exc_Msg
177: ( G_PKG_NAME
178: , 'Process_Invalid_Records'
179: );
180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 246: OE_BULK_MSG_PUB.Add_Exc_Msg

242: EXCEPTION
243: WHEN OTHERS THEN
244: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
245: THEN
246: OE_BULK_MSG_PUB.Add_Exc_Msg
247: (G_PKG_NAME
248: ,'Update_DBI_log');
249: END IF;
250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

337: -- Insert Messages into DB from above processing call
338: -------------------------------------------------------------------
339:
340: IF l_debug_level > 0 THEN
341: oe_debug_pub.add( 'SAVING MESSAGES '||OE_BULK_MSG_PUB.G_MSG_TBL.MESSAGE.COUNT ) ;
342: END IF;
343:
344: -- Bug 5640601 =>
345: -- Selecting hsecs from v$times is changed to execute only when debug

Line 351: OE_Bulk_Msg_PUB.Save_Messages(G_REQUEST_ID);

347: IF l_debug_level > 0 Then
348: SELECT hsecs INTO l_start_time from v$timer;
349: end if;
350:
351: OE_Bulk_Msg_PUB.Save_Messages(G_REQUEST_ID);
352:
353: -- Bug 5640601 =>
354: -- Selecting hsecs from v$times is changed to execute only when debug
355: -- is enabled, as hsec is used for logging only when debug is enabled.

Line 414: OE_BULK_MSG_PUB.Add_Exc_Msg

410: EXCEPTION
411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
413: WHEN OTHERS THEN
414: OE_BULK_MSG_PUB.Add_Exc_Msg
415: ( G_PKG_NAME
416: , 'Process_Headers'
417: );
418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

503:
504:
505: -- Insert Messages
506: IF l_debug_level > 0 THEN
507: oe_debug_pub.add( 'SAVING MESSAGES '||OE_BULK_MSG_PUB.G_MSG_TBL.MESSAGE.COUNT ) ;
508: END IF;
509: OE_Bulk_Msg_PUB.Save_Messages(G_REQUEST_ID);
510:
511: -- Update Headers Interface for Invalid Lines

Line 509: OE_Bulk_Msg_PUB.Save_Messages(G_REQUEST_ID);

505: -- Insert Messages
506: IF l_debug_level > 0 THEN
507: oe_debug_pub.add( 'SAVING MESSAGES '||OE_BULK_MSG_PUB.G_MSG_TBL.MESSAGE.COUNT ) ;
508: END IF;
509: OE_Bulk_Msg_PUB.Save_Messages(G_REQUEST_ID);
510:
511: -- Update Headers Interface for Invalid Lines
512: -- Bug 5640601 =>
513: -- Selecting hsecs from v$times is changed to execute only when debug

Line 557: OE_BULK_MSG_PUB.Add_Exc_Msg

553: EXCEPTION
554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
556: WHEN OTHERS THEN
557: OE_BULK_MSG_PUB.Add_Exc_Msg
558: ( G_PKG_NAME
559: , 'Process_Lines'
560: );
561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1060: OE_BULK_MSG_PUB.Add_Exc_Msg

1056: EXCEPTION
1057: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1058: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1059: WHEN OTHERS THEN
1060: OE_BULK_MSG_PUB.Add_Exc_Msg
1061: ( G_PKG_NAME
1062: , 'Post_Process'
1063: );
1064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1106: OE_BULK_MSG_PUB.initialize;

1102:
1103: -- Initialize message list
1104:
1105: IF FND_API.to_Boolean(p_init_msg_list) THEN
1106: OE_BULK_MSG_PUB.initialize;
1107: END IF;
1108:
1109: -- Establish SAVEPOINT
1110:

Line 1339: OE_BULK_MSG_PUB.Count_And_Get

1335:
1336:
1337: -- Get message count and data
1338:
1339: OE_BULK_MSG_PUB.Count_And_Get
1340: ( p_count => x_msg_count
1341: , p_data => x_msg_data
1342: );
1343:

Line 1353: OE_BULK_MSG_PUB.Count_And_Get

1349: END IF;
1350: ROLLBACK TO SAVEPOINT Process_Batch;
1351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1352: -- Get message count and data
1353: OE_BULK_MSG_PUB.Count_And_Get
1354: ( p_count => x_msg_count
1355: , p_data => x_msg_data
1356: );
1357: WHEN OTHERS THEN

Line 1366: OE_BULK_MSG_PUB.Add_Exc_Msg

1362: oe_debug_pub.add( 'SQL ERROR :'||SQLERRM ) ;
1363: END IF;
1364: ROLLBACK TO SAVEPOINT Process_Batch;
1365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1366: OE_BULK_MSG_PUB.Add_Exc_Msg
1367: ( G_PKG_NAME
1368: , 'Process_Batch'
1369: );
1370: -- Get message count and data

Line 1371: OE_BULK_MSG_PUB.Count_And_Get

1367: ( G_PKG_NAME
1368: , 'Process_Batch'
1369: );
1370: -- Get message count and data
1371: OE_BULK_MSG_PUB.Count_And_Get
1372: ( p_count => x_msg_count
1373: , p_data => x_msg_data
1374: );
1375: END Process_Batch;

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

1437: WHEN OTHERS THEN
1438: IF l_debug_level > 0 THEN
1439: oe_debug_pub.add( 'in others exception ' || SQLERRM ) ;
1440: END IF;
1441: IF OE_BULK_MSG_PUB.check_msg_level(OE_BULK_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1442: THEN
1443: OE_BULK_MSG_PUB.add_exc_msg
1444: (G_PKG_NAME
1445: ,'Mark_Header_Error'

Line 1443: OE_BULK_MSG_PUB.add_exc_msg

1439: oe_debug_pub.add( 'in others exception ' || SQLERRM ) ;
1440: END IF;
1441: IF OE_BULK_MSG_PUB.check_msg_level(OE_BULK_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1442: THEN
1443: OE_BULK_MSG_PUB.add_exc_msg
1444: (G_PKG_NAME
1445: ,'Mark_Header_Error'
1446: );
1447: END IF;