DBA Data[Home] [Help]

APPS.OE_DELAYED_REQUESTS_PVT dependencies on OE_MSG_PUB

Line 135: OE_MSG_PUB.ADD;

131: END LOOP;
132:
133: IF x_request_ind > l_max_ind THEN
134: FND_MESSAGE.SET_NAME('ONT','OE_MAX_REQUESTS_EXCEEDED');
135: OE_MSG_PUB.ADD;
136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
137: END IF;
138:
139: EXCEPTION

Line 141: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

137: END IF;
138:
139: EXCEPTION
140: WHEN OTHERS THEN
141: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
142: THEN
143: OE_MSG_PUB.Add_Exc_Msg
144: (G_PKG_NAME
145: ,'CheckForRequest');

Line 143: OE_MSG_PUB.Add_Exc_Msg

139: EXCEPTION
140: WHEN OTHERS THEN
141: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
142: THEN
143: OE_MSG_PUB.Add_Exc_Msg
144: (G_PKG_NAME
145: ,'CheckForRequest');
146: END IF;
147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2058: OE_MSG_PUB.Add;

2054:
2055: ELSE
2056: FND_MESSAGE.SET_NAME('ONT','ONT_INVALID_REQUEST');
2057: FND_MESSAGE.SET_TOKEN('ACTION',l_request_type);
2058: OE_MSG_PUB.Add;
2059: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2060:
2061: END IF;
2062:

Line 2172: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2168: G_Delayed_Requests(p_request_ind).processed := 'N';
2169: END IF ; -- 9714072
2170: END IF;
2171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2172: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2173: THEN
2174: OE_MSG_PUB.Add_Exc_Msg
2175: ( G_PKG_NAME
2176: , 'Process_Request_Pvt'

Line 2174: OE_MSG_PUB.Add_Exc_Msg

2170: END IF;
2171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2172: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2173: THEN
2174: OE_MSG_PUB.Add_Exc_Msg
2175: ( G_PKG_NAME
2176: , 'Process_Request_Pvt'
2177: );
2178: END IF;

Line 2196: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2192: END IF ; -- 9714072
2193: END IF;
2194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2195:
2196: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2197: THEN
2198: OE_MSG_PUB.Add_Exc_Msg
2199: ( G_PKG_NAME
2200: , 'Process_Request_Pvt'

Line 2198: OE_MSG_PUB.Add_Exc_Msg

2194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2195:
2196: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2197: THEN
2198: OE_MSG_PUB.Add_Exc_Msg
2199: ( G_PKG_NAME
2200: , 'Process_Request_Pvt'
2201: );
2202: END IF;

Line 2713: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2711:
2712: WHEN OTHERS THEN
2713: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2714: THEN
2715: OE_MSG_PUB.Add_Exc_Msg
2716: (G_PKG_NAME
2717: ,'LOGREQUEST');

Line 2715: OE_MSG_PUB.Add_Exc_Msg

2711:
2712: WHEN OTHERS THEN
2713: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2714: THEN
2715: OE_MSG_PUB.Add_Exc_Msg
2716: (G_PKG_NAME
2717: ,'LOGREQUEST');
2718: END IF;
2719:

Line 2836: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2833:
2834: when others THEN
2835:
2836: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2837: OE_MSG_PUB.Add_Exc_Msg
2838: (G_PKG_NAME
2839: ,'DeleteRequest');
2840: END IF;

Line 2837: OE_MSG_PUB.Add_Exc_Msg

2833:
2834: when others THEN
2835:
2836: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2837: OE_MSG_PUB.Add_Exc_Msg
2838: (G_PKG_NAME
2839: ,'DeleteRequest');
2840: END IF;
2841:

Line 2880: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2876: EXCEPTION
2877:
2878: WHEN OTHERS THEN
2879:
2880: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2881: OE_MSG_PUB.Add_Exc_Msg
2882: (G_PKG_NAME
2883: ,'Clear_Request');
2884: END IF;

Line 2881: OE_MSG_PUB.Add_Exc_Msg

2877:
2878: WHEN OTHERS THEN
2879:
2880: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2881: OE_MSG_PUB.Add_Exc_Msg
2882: (G_PKG_NAME
2883: ,'Clear_Request');
2884: END IF;
2885:

Line 2960: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2956: WHEN OTHERS THEN
2957:
2958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2959:
2960: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2961: THEN
2962: OE_MSG_PUB.Add_Exc_Msg
2963: ( G_PKG_NAME
2964: , 'Process_Request'

Line 2962: OE_MSG_PUB.Add_Exc_Msg

2958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2959:
2960: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2961: THEN
2962: OE_MSG_PUB.Add_Exc_Msg
2963: ( G_PKG_NAME
2964: , 'Process_Request'
2965: );
2966: END IF;

Line 3052: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3048: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
3049: p_In_out => 0);
3050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3051:
3052: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3053: THEN
3054: OE_MSG_PUB.Add_Exc_Msg
3055: ( G_PKG_NAME
3056: , 'Process_Request_for_Entity'

Line 3054: OE_MSG_PUB.Add_Exc_Msg

3050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3051:
3052: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3053: THEN
3054: OE_MSG_PUB.Add_Exc_Msg
3055: ( G_PKG_NAME
3056: , 'Process_Request_for_Entity'
3057: );
3058: END IF;

Line 3190: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3186: p_In_out => 0);
3187: oe_debug_pub.add('others error', 1);
3188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3189:
3190: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3191: THEN
3192: OE_MSG_PUB.Add_Exc_Msg
3193: ( G_PKG_NAME
3194: , 'Process_Request_for_ReqType'

Line 3192: OE_MSG_PUB.Add_Exc_Msg

3188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3189:
3190: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3191: THEN
3192: OE_MSG_PUB.Add_Exc_Msg
3193: ( G_PKG_NAME
3194: , 'Process_Request_for_ReqType'
3195: );
3196: END IF;

Line 4006: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4002: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
4003: p_In_out => 0);
4004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4005:
4006: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4007: THEN
4008: OE_MSG_PUB.Add_Exc_Msg
4009: ( G_PKG_NAME
4010: , 'Process_Delayed_Requests'

Line 4008: OE_MSG_PUB.Add_Exc_Msg

4004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4005:
4006: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4007: THEN
4008: OE_MSG_PUB.Add_Exc_Msg
4009: ( G_PKG_NAME
4010: , 'Process_Delayed_Requests'
4011: );
4012: END IF;

Line 4352: OE_MSG_PUB.set_msg_context(

4348: END;
4349: END IF;
4350: END IF;
4351:
4352: OE_MSG_PUB.set_msg_context(
4353: p_entity_code => l_request_rec.entity_code
4354: ,p_entity_id => l_request_rec.entity_id
4355: ,p_header_id => l_header_id
4356: ,p_line_id => l_line_id

Line 4436: OE_MSG_PUB.Add;

4432: END IF;
4433:
4434: FND_MESSAGE.SET_NAME('ONT','ONT_INVALID_REQUEST');
4435: FND_MESSAGE.SET_TOKEN('ACTION',l_request_rec.request_type);
4436: OE_MSG_PUB.Add;
4437: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4438:
4439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4440: END IF;

Line 4656: OE_MSG_PUB.update_msg_context(

4652: /** processed in the second call **/
4653: ELSIF p_process_WF_requests THEN
4654:
4655: IF l_request_rec.entity_code = OE_Globals.G_ENTITY_HEADER THEN
4656: OE_MSG_PUB.update_msg_context(
4657: p_header_id => l_request_rec.entity_id);
4658:
4659: ELSIF l_request_rec.entity_code = OE_Globals.G_ENTITY_LINE THEN
4660: OE_MSG_PUB.update_msg_context(

Line 4660: OE_MSG_PUB.update_msg_context(

4656: OE_MSG_PUB.update_msg_context(
4657: p_header_id => l_request_rec.entity_id);
4658:
4659: ELSIF l_request_rec.entity_code = OE_Globals.G_ENTITY_LINE THEN
4660: OE_MSG_PUB.update_msg_context(
4661: p_line_id => l_request_rec.entity_id);
4662: END IF;
4663: FND_MESSAGE.SET_NAME('ONT','ONT_INVALID_REQUEST');
4664: FND_MESSAGE.SET_TOKEN('ACTION',l_request_rec.request_type);

Line 4665: OE_MSG_PUB.Add;

4661: p_line_id => l_request_rec.entity_id);
4662: END IF;
4663: FND_MESSAGE.SET_NAME('ONT','ONT_INVALID_REQUEST');
4664: FND_MESSAGE.SET_TOKEN('ACTION',l_request_rec.request_type);
4665: OE_MSG_PUB.Add;
4666: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4667: END IF;
4668:
4669: IF l_request_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR

Line 4686: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);

4682: else
4683: p_x_request_tbl(i) := l_request_rec;
4684: end if;
4685:
4686: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4687:
4688: EXCEPTION
4689:
4690: WHEN FND_API.G_EXC_ERROR THEN

Line 4694: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);

4690: WHEN FND_API.G_EXC_ERROR THEN
4691: l_request_rec.return_status := FND_API.G_RET_STS_ERROR;
4692: l_request_rec.processed := 'Y';
4693: p_x_request_tbl(i):= l_request_rec;
4694: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4695:
4696: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4697: l_request_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4698: l_request_rec.processed := 'Y';

Line 4700: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);

4696: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4697: l_request_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4698: l_request_rec.processed := 'Y';
4699: p_x_request_tbl(i):= l_request_rec;
4700: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4702:
4703:
4704: WHEN OTHERS THEN

Line 4709: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4705: l_request_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4706: l_request_rec.processed := 'Y';
4707: p_x_request_tbl(i) := l_request_rec;
4708:
4709: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4710: THEN
4711: OE_MSG_PUB.Add_Exc_Msg
4712: ( G_PKG_NAME
4713: , 'Process_Order_Actions'

Line 4711: OE_MSG_PUB.Add_Exc_Msg

4707: p_x_request_tbl(i) := l_request_rec;
4708:
4709: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4710: THEN
4711: OE_MSG_PUB.Add_Exc_Msg
4712: ( G_PKG_NAME
4713: , 'Process_Order_Actions'
4714: );
4715: END IF;

Line 4717: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);

4713: , 'Process_Order_Actions'
4714: );
4715: END IF;
4716:
4717: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4719:
4720: END;
4721: <> -- Label for requests that do not need to be processed

Line 4733: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);

4729: END IF;
4730: IF l_debug_level > 0 THEN
4731: oe_debug_pub.ADD('Exiting OE_ORDER_PUB.PROCESS_ORDER_ACTIONS', 1);
4732: END IF;
4733: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4734:
4735: EXCEPTION
4736:
4737: WHEN FND_API.G_EXC_ERROR THEN

Line 4738: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);

4734:
4735: EXCEPTION
4736:
4737: WHEN FND_API.G_EXC_ERROR THEN
4738: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4739: RAISE;
4740:
4741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4742: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);

Line 4742: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);

4738: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4739: RAISE;
4740:
4741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4742: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4743: RAISE;
4744:
4745: WHEN OTHERS THEN
4746:

Line 4747: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4743: RAISE;
4744:
4745: WHEN OTHERS THEN
4746:
4747: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4748: THEN
4749: OE_MSG_PUB.Add_Exc_Msg
4750: ( G_PKG_NAME
4751: , 'Process_Order_Actions'

Line 4749: OE_MSG_PUB.Add_Exc_Msg

4745: WHEN OTHERS THEN
4746:
4747: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4748: THEN
4749: OE_MSG_PUB.Add_Exc_Msg
4750: ( G_PKG_NAME
4751: , 'Process_Order_Actions'
4752: );
4753: END IF;

Line 4755: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);

4751: , 'Process_Order_Actions'
4752: );
4753: END IF;
4754:
4755: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4757:
4758: END Process_Order_Actions;
4759:

Line 4942: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4939:
4940: when others THEN
4941:
4942: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4943: OE_MSG_PUB.Add_Exc_Msg
4944: (G_PKG_NAME
4945: ,'Delete_Reqs_for_Deleted_Entity');
4946: END IF;

Line 4943: OE_MSG_PUB.Add_Exc_Msg

4939:
4940: when others THEN
4941:
4942: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4943: OE_MSG_PUB.Add_Exc_Msg
4944: (G_PKG_NAME
4945: ,'Delete_Reqs_for_Deleted_Entity');
4946: END IF;
4947: