DBA Data[Home] [Help]

APPS.OE_ORDER_CLOSE_UTIL dependencies on OE_MSG_PUB

Line 156: OE_MSG_PUB.set_msg_context(

152: SAVEPOINT CLOSE_ORDER;
153:
154: x_return_status := FND_API.G_RET_STS_SUCCESS;
155:
156: OE_MSG_PUB.set_msg_context(
157: p_entity_code => 'HEADER'
158: ,p_entity_id => p_header_id
159: ,p_header_id => p_header_id);
160:

Line 174: OE_MSG_PUB.update_msg_context(

170: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
172: END IF;
173:
174: OE_MSG_PUB.update_msg_context(
175: p_entity_code => 'HEADER'
176: ,p_entity_id => l_old_header_rec.header_id
177: ,p_header_id => l_old_header_rec.header_id
178: ,p_line_id => null

Line 209: OE_MSG_PUB.ADD;

205: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS AND
206: l_check_hold_result = FND_API.G_TRUE )
207: THEN
208: FND_MESSAGE.SET_NAME('ONT','OE_CLOSE_ORDER_HOLD_EXISTS');
209: OE_MSG_PUB.ADD;
210: RAISE ON_HOLD_ERROR;
211: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
212: RAISE FND_API.G_EXC_ERROR;
213: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 380: OE_MSG_PUB.reset_msg_context('HEADER');

376: -- when order header is updated.
377: OE_PC_Constraints_Admin_Pvt.Clear_Cached_Results
378: (p_validation_entity_id => OE_PC_GLOBALS.G_ENTITY_HEADER);
379:
380: OE_MSG_PUB.reset_msg_context('HEADER');
381:
382: EXCEPTION
383: WHEN ON_HOLD_ERROR THEN
384: x_return_status := 'H';

Line 385: OE_MSG_PUB.reset_msg_context('HEADER');

381:
382: EXCEPTION
383: WHEN ON_HOLD_ERROR THEN
384: x_return_status := 'H';
385: OE_MSG_PUB.reset_msg_context('HEADER');
386: ROLLBACK TO CLOSE_ORDER;
387: WHEN FND_API.G_EXC_ERROR THEN
388: x_return_status := FND_API.G_RET_STS_ERROR;
389: OE_MSG_PUB.reset_msg_context('HEADER');

Line 389: OE_MSG_PUB.reset_msg_context('HEADER');

385: OE_MSG_PUB.reset_msg_context('HEADER');
386: ROLLBACK TO CLOSE_ORDER;
387: WHEN FND_API.G_EXC_ERROR THEN
388: x_return_status := FND_API.G_RET_STS_ERROR;
389: OE_MSG_PUB.reset_msg_context('HEADER');
390: ROLLBACK TO CLOSE_ORDER;
391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
393: OE_MSG_PUB.reset_msg_context('HEADER');

Line 393: OE_MSG_PUB.reset_msg_context('HEADER');

389: OE_MSG_PUB.reset_msg_context('HEADER');
390: ROLLBACK TO CLOSE_ORDER;
391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
393: OE_MSG_PUB.reset_msg_context('HEADER');
394: ROLLBACK TO CLOSE_ORDER;
395: WHEN OTHERS THEN
396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
397: IF FND_MSG_PUB.Check_Msg_Level

Line 400: OE_MSG_PUB.Add_Exc_Msg

396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
397: IF FND_MSG_PUB.Check_Msg_Level
398: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
399: THEN
400: OE_MSG_PUB.Add_Exc_Msg
401: ( G_PKG_NAME
402: , 'Close_Order'
403: );
404: END IF;

Line 405: OE_MSG_PUB.reset_msg_context('HEADER');

401: ( G_PKG_NAME
402: , 'Close_Order'
403: );
404: END IF;
405: OE_MSG_PUB.reset_msg_context('HEADER');
406: ROLLBACK TO CLOSE_ORDER;
407: END CLOSE_ORDER;
408:
409: PROCEDURE CLOSE_LINE

Line 448: OE_MSG_PUB.set_msg_context(

444: SAVEPOINT CLOSE_LINE;
445:
446: x_return_status := FND_API.G_RET_STS_SUCCESS;
447:
448: OE_MSG_PUB.set_msg_context(
449: p_entity_code => 'LINE'
450: ,p_entity_id => p_line_id
451: ,p_line_id => p_line_id);
452:

Line 499: OE_MSG_PUB.update_msg_context

495: FROM oe_order_lines_all
496: WHERE line_id = p_line_id
497: FOR UPDATE NOWAIT;
498:
499: OE_MSG_PUB.update_msg_context
500: ( p_entity_code => 'LINE'
501: ,p_entity_id => l_old_line_tbl(1).line_id
502: ,p_header_id => l_old_line_tbl(1).header_id
503: ,p_line_id => l_old_line_tbl(1).line_id

Line 527: OE_MSG_PUB.update_msg_context

523: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
525: END IF;
526:
527: OE_MSG_PUB.update_msg_context
528: ( p_entity_code => 'LINE'
529: ,p_entity_id => l_old_line_tbl(1).line_id
530: ,p_header_id => l_old_line_tbl(1).header_id
531: ,p_line_id => l_old_line_tbl(1).line_id

Line 565: OE_MSG_PUB.ADD;

561: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS AND
562: l_check_hold_result = FND_API.G_TRUE )
563: THEN
564: FND_MESSAGE.SET_NAME('ONT','OE_CLOSE_LINE_HOLD_EXISTS');
565: OE_MSG_PUB.ADD;
566: RAISE ON_HOLD_ERROR;
567: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
568: RAISE FND_API.G_EXC_ERROR;
569: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 856: OE_MSG_PUB.Reset_Msg_Context('LINE');

852:
853: --Customer Acceptance
854: IF l_pending_acceptance = 'N' THEN
855: DELETE_ADJUSTMENTS(p_line_id => p_line_id);
856: OE_MSG_PUB.Reset_Msg_Context('LINE');
857: END IF;
858:
859: --- Adding the following code to raise OIP status change event during order line closure
860: -- change done for bug 13930149

Line 922: OE_MSG_PUB.Reset_Msg_Context('LINE');

918:
919: EXCEPTION
920: WHEN ON_HOLD_ERROR THEN
921: x_return_status := 'H';
922: OE_MSG_PUB.Reset_Msg_Context('LINE');
923: ROLLBACK TO CLOSE_LINE;
924: WHEN FND_API.G_EXC_ERROR THEN
925: x_return_status := FND_API.G_RET_STS_ERROR;
926: OE_MSG_PUB.Reset_Msg_Context('LINE');

Line 926: OE_MSG_PUB.Reset_Msg_Context('LINE');

922: OE_MSG_PUB.Reset_Msg_Context('LINE');
923: ROLLBACK TO CLOSE_LINE;
924: WHEN FND_API.G_EXC_ERROR THEN
925: x_return_status := FND_API.G_RET_STS_ERROR;
926: OE_MSG_PUB.Reset_Msg_Context('LINE');
927: ROLLBACK TO CLOSE_LINE;
928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
930: OE_MSG_PUB.Reset_Msg_Context('LINE');

Line 930: OE_MSG_PUB.Reset_Msg_Context('LINE');

926: OE_MSG_PUB.Reset_Msg_Context('LINE');
927: ROLLBACK TO CLOSE_LINE;
928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
930: OE_MSG_PUB.Reset_Msg_Context('LINE');
931: ROLLBACK TO CLOSE_LINE;
932: WHEN OTHERS THEN
933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
934: IF FND_MSG_PUB.Check_Msg_Level

Line 937: OE_MSG_PUB.Add_Exc_Msg

933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
934: IF FND_MSG_PUB.Check_Msg_Level
935: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
936: THEN
937: OE_MSG_PUB.Add_Exc_Msg
938: ( G_PKG_NAME
939: , 'Close_Line'
940: );
941: END IF;

Line 942: OE_MSG_PUB.Reset_Msg_Context('LINE');

938: ( G_PKG_NAME
939: , 'Close_Line'
940: );
941: END IF;
942: OE_MSG_PUB.Reset_Msg_Context('LINE');
943: ROLLBACK TO CLOSE_LINE;
944: END CLOSE_LINE;
945:
946: END OE_ORDER_CLOSE_UTIL;