eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_DELAYED_REQUESTS_PVT dependencies on OE_MSG_PUB

Line 134: OE_MSG_PUB.ADD;

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

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

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

Line 142: OE_MSG_PUB.Add_Exc_Msg

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

Line 1780: OE_MSG_PUB.Add;

1776: -- End of requests logged by blankets business object APIs.
1777: ELSE
1778: FND_MESSAGE.SET_NAME('ONT','ONT_INVALID_REQUEST');
1779: FND_MESSAGE.SET_TOKEN('ACTION',l_request_type);
1780: OE_MSG_PUB.Add;
1781: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1782:
1783: END IF;
1784:

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

1855: G_Delayed_Requests(p_request_ind).processed := 'N';
1856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1857:
1858:
1859: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1860: THEN
1861: OE_MSG_PUB.Add_Exc_Msg
1862: ( G_PKG_NAME
1863: , 'Process_Request_Pvt'

Line 1861: OE_MSG_PUB.Add_Exc_Msg

1857:
1858:
1859: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1860: THEN
1861: OE_MSG_PUB.Add_Exc_Msg
1862: ( G_PKG_NAME
1863: , 'Process_Request_Pvt'
1864: );
1865: END IF;

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

1868: G_Delayed_Requests(p_request_ind).processed := 'N';
1869: oe_debug_pub.add('SQL ERROR MESSAGE FOR WHEN OTHRES:'||SQLERRM);
1870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1871:
1872: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1873: THEN
1874: OE_MSG_PUB.Add_Exc_Msg
1875: ( G_PKG_NAME
1876: , 'Process_Request_Pvt'

Line 1874: OE_MSG_PUB.Add_Exc_Msg

1870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1871:
1872: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1873: THEN
1874: OE_MSG_PUB.Add_Exc_Msg
1875: ( G_PKG_NAME
1876: , 'Process_Request_Pvt'
1877: );
1878: END IF;

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

2354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2356:
2357: WHEN OTHERS THEN
2358: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2359: THEN
2360: OE_MSG_PUB.Add_Exc_Msg
2361: (G_PKG_NAME
2362: ,'LOGREQUEST');

Line 2360: OE_MSG_PUB.Add_Exc_Msg

2356:
2357: WHEN OTHERS THEN
2358: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2359: THEN
2360: OE_MSG_PUB.Add_Exc_Msg
2361: (G_PKG_NAME
2362: ,'LOGREQUEST');
2363: END IF;
2364:

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

2477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2478:
2479: when others THEN
2480:
2481: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2482: OE_MSG_PUB.Add_Exc_Msg
2483: (G_PKG_NAME
2484: ,'DeleteRequest');
2485: END IF;

Line 2482: OE_MSG_PUB.Add_Exc_Msg

2478:
2479: when others THEN
2480:
2481: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2482: OE_MSG_PUB.Add_Exc_Msg
2483: (G_PKG_NAME
2484: ,'DeleteRequest');
2485: END IF;
2486:

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

2521: EXCEPTION
2522:
2523: WHEN OTHERS THEN
2524:
2525: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2526: OE_MSG_PUB.Add_Exc_Msg
2527: (G_PKG_NAME
2528: ,'Clear_Request');
2529: END IF;

Line 2526: OE_MSG_PUB.Add_Exc_Msg

2522:
2523: WHEN OTHERS THEN
2524:
2525: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2526: OE_MSG_PUB.Add_Exc_Msg
2527: (G_PKG_NAME
2528: ,'Clear_Request');
2529: END IF;
2530:

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

2601: WHEN OTHERS THEN
2602:
2603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2604:
2605: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2606: THEN
2607: OE_MSG_PUB.Add_Exc_Msg
2608: ( G_PKG_NAME
2609: , 'Process_Request'

Line 2607: OE_MSG_PUB.Add_Exc_Msg

2603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2604:
2605: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2606: THEN
2607: OE_MSG_PUB.Add_Exc_Msg
2608: ( G_PKG_NAME
2609: , 'Process_Request'
2610: );
2611: END IF;

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

2681: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
2682: p_In_out => 0);
2683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2684:
2685: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2686: THEN
2687: OE_MSG_PUB.Add_Exc_Msg
2688: ( G_PKG_NAME
2689: , 'Process_Request_for_Entity'

Line 2687: OE_MSG_PUB.Add_Exc_Msg

2683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2684:
2685: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2686: THEN
2687: OE_MSG_PUB.Add_Exc_Msg
2688: ( G_PKG_NAME
2689: , 'Process_Request_for_Entity'
2690: );
2691: END IF;

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

2802: p_In_out => 0);
2803: oe_debug_pub.add('others error', 1);
2804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2805:
2806: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2807: THEN
2808: OE_MSG_PUB.Add_Exc_Msg
2809: ( G_PKG_NAME
2810: , 'Process_Request_for_ReqType'

Line 2808: OE_MSG_PUB.Add_Exc_Msg

2804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2805:
2806: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2807: THEN
2808: OE_MSG_PUB.Add_Exc_Msg
2809: ( G_PKG_NAME
2810: , 'Process_Request_for_ReqType'
2811: );
2812: END IF;

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

3571: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
3572: p_In_out => 0);
3573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3574:
3575: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3576: THEN
3577: OE_MSG_PUB.Add_Exc_Msg
3578: ( G_PKG_NAME
3579: , 'Process_Delayed_Requests'

Line 3577: OE_MSG_PUB.Add_Exc_Msg

3573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3574:
3575: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3576: THEN
3577: OE_MSG_PUB.Add_Exc_Msg
3578: ( G_PKG_NAME
3579: , 'Process_Delayed_Requests'
3580: );
3581: END IF;

Line 3914: OE_MSG_PUB.set_msg_context(

3910: END;
3911: END IF;
3912: END IF;
3913:
3914: OE_MSG_PUB.set_msg_context(
3915: p_entity_code => l_request_rec.entity_code
3916: ,p_entity_id => l_request_rec.entity_id
3917: ,p_header_id => l_header_id
3918: ,p_line_id => l_line_id

Line 3998: OE_MSG_PUB.Add;

3994: END IF;
3995:
3996: FND_MESSAGE.SET_NAME('ONT','ONT_INVALID_REQUEST');
3997: FND_MESSAGE.SET_TOKEN('ACTION',l_request_rec.request_type);
3998: OE_MSG_PUB.Add;
3999: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4000:
4001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4002: END IF;

Line 4218: OE_MSG_PUB.update_msg_context(

4214: /** processed in the second call **/
4215: ELSIF p_process_WF_requests THEN
4216:
4217: IF l_request_rec.entity_code = OE_Globals.G_ENTITY_HEADER THEN
4218: OE_MSG_PUB.update_msg_context(
4219: p_header_id => l_request_rec.entity_id);
4220:
4221: ELSIF l_request_rec.entity_code = OE_Globals.G_ENTITY_LINE THEN
4222: OE_MSG_PUB.update_msg_context(

Line 4222: OE_MSG_PUB.update_msg_context(

4218: OE_MSG_PUB.update_msg_context(
4219: p_header_id => l_request_rec.entity_id);
4220:
4221: ELSIF l_request_rec.entity_code = OE_Globals.G_ENTITY_LINE THEN
4222: OE_MSG_PUB.update_msg_context(
4223: p_line_id => l_request_rec.entity_id);
4224: END IF;
4225: FND_MESSAGE.SET_NAME('ONT','ONT_INVALID_REQUEST');
4226: FND_MESSAGE.SET_TOKEN('ACTION',l_request_rec.request_type);

Line 4227: OE_MSG_PUB.Add;

4223: p_line_id => l_request_rec.entity_id);
4224: END IF;
4225: FND_MESSAGE.SET_NAME('ONT','ONT_INVALID_REQUEST');
4226: FND_MESSAGE.SET_TOKEN('ACTION',l_request_rec.request_type);
4227: OE_MSG_PUB.Add;
4228: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4229: END IF;
4230:
4231: IF l_request_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR

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

4244: else
4245: p_x_request_tbl(i) := l_request_rec;
4246: end if;
4247:
4248: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4249:
4250: EXCEPTION
4251:
4252: WHEN FND_API.G_EXC_ERROR THEN

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

4252: WHEN FND_API.G_EXC_ERROR THEN
4253: l_request_rec.return_status := FND_API.G_RET_STS_ERROR;
4254: l_request_rec.processed := 'Y';
4255: p_x_request_tbl(i):= l_request_rec;
4256: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4257:
4258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4259: l_request_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4260: l_request_rec.processed := 'Y';

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

4258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4259: l_request_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4260: l_request_rec.processed := 'Y';
4261: p_x_request_tbl(i):= l_request_rec;
4262: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4264:
4265:
4266: WHEN OTHERS THEN

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

4267: l_request_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4268: l_request_rec.processed := 'Y';
4269: p_x_request_tbl(i) := l_request_rec;
4270:
4271: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4272: THEN
4273: OE_MSG_PUB.Add_Exc_Msg
4274: ( G_PKG_NAME
4275: , 'Process_Order_Actions'

Line 4273: OE_MSG_PUB.Add_Exc_Msg

4269: p_x_request_tbl(i) := l_request_rec;
4270:
4271: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4272: THEN
4273: OE_MSG_PUB.Add_Exc_Msg
4274: ( G_PKG_NAME
4275: , 'Process_Order_Actions'
4276: );
4277: END IF;

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

4275: , 'Process_Order_Actions'
4276: );
4277: END IF;
4278:
4279: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4281:
4282: END;
4283: <> -- Label for requests that do not need to be processed

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

4291: END IF;
4292: IF l_debug_level > 0 THEN
4293: oe_debug_pub.ADD('Exiting OE_ORDER_PUB.PROCESS_ORDER_ACTIONS', 1);
4294: END IF;
4295: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4296:
4297: EXCEPTION
4298:
4299: WHEN FND_API.G_EXC_ERROR THEN

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

4296:
4297: EXCEPTION
4298:
4299: WHEN FND_API.G_EXC_ERROR THEN
4300: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4301: RAISE;
4302:
4303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4304: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);

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

4300: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4301: RAISE;
4302:
4303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4304: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4305: RAISE;
4306:
4307: WHEN OTHERS THEN
4308:

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

4305: RAISE;
4306:
4307: WHEN OTHERS THEN
4308:
4309: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4310: THEN
4311: OE_MSG_PUB.Add_Exc_Msg
4312: ( G_PKG_NAME
4313: , 'Process_Order_Actions'

Line 4311: OE_MSG_PUB.Add_Exc_Msg

4307: WHEN OTHERS THEN
4308:
4309: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4310: THEN
4311: OE_MSG_PUB.Add_Exc_Msg
4312: ( G_PKG_NAME
4313: , 'Process_Order_Actions'
4314: );
4315: END IF;

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

4313: , 'Process_Order_Actions'
4314: );
4315: END IF;
4316:
4317: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4319:
4320: END Process_Order_Actions;
4321:

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

4486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4487:
4488: when others THEN
4489:
4490: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4491: OE_MSG_PUB.Add_Exc_Msg
4492: (G_PKG_NAME
4493: ,'Delete_Reqs_for_Deleted_Entity');
4494: END IF;

Line 4491: OE_MSG_PUB.Add_Exc_Msg

4487:
4488: when others THEN
4489:
4490: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4491: OE_MSG_PUB.Add_Exc_Msg
4492: (G_PKG_NAME
4493: ,'Delete_Reqs_for_Deleted_Entity');
4494: END IF;
4495: