DBA Data[Home] [Help]

APPS.MSC_ATP_PEG dependencies on FND_MSG_PUB

Line 5217: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

5213: 'error in insert row: sqlcode = '|| to_char(my_sqlcode));
5214: msc_sch_wb.atp_debug('Add_Offset_Demands: ERROR- ' || sqlerrm );
5215: END IF;
5216:
5217: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5218: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME , 'Add_Offset_Demands');
5219: END IF;
5220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5221: -- Bug 3319810 Enable exception generation.

Line 5218: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME , 'Add_Offset_Demands');

5214: msc_sch_wb.atp_debug('Add_Offset_Demands: ERROR- ' || sqlerrm );
5215: END IF;
5216:
5217: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5218: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME , 'Add_Offset_Demands');
5219: END IF;
5220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5221: -- Bug 3319810 Enable exception generation.
5222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5670: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

5666: 'error in insert row: sqlcode = '|| to_char(my_sqlcode));
5667: msc_sch_wb.atp_debug('Add_Offset_Supplies: ERROR- ' || sqlerrm );
5668: END IF;
5669:
5670: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5671: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME , 'Add_Offset_Supplies');
5672: END IF;
5673: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5674: -- Bug 3319810 Enable exception generation.

Line 5671: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME , 'Add_Offset_Supplies');

5667: msc_sch_wb.atp_debug('Add_Offset_Supplies: ERROR- ' || sqlerrm );
5668: END IF;
5669:
5670: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5671: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME , 'Add_Offset_Supplies');
5672: END IF;
5673: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5674: -- Bug 3319810 Enable exception generation.
5675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5941: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

5937: msc_sch_wb.atp_debug('Add_Offset_Resource_Reqs: ' ||
5938: 'error in processing: errmsg = '|| sqlerrm );
5939: END IF;
5940:
5941: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5942: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME , 'Add_Offset_Resource_Reqs');
5943: END IF;
5944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5945: -- Bug 3319810 Enable exception generation.

Line 5942: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME , 'Add_Offset_Resource_Reqs');

5938: 'error in processing: errmsg = '|| sqlerrm );
5939: END IF;
5940:
5941: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5942: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME , 'Add_Offset_Resource_Reqs');
5943: END IF;
5944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5945: -- Bug 3319810 Enable exception generation.
5946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6048: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

6044: END IF;
6045:
6046: EXCEPTION
6047: WHEN OTHERS THEN
6048: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6049: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Add_Offset_Data');
6050: END IF;
6051:
6052: IF PG_DEBUG in ('Y', 'C') THEN

Line 6049: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Add_Offset_Data');

6045:
6046: EXCEPTION
6047: WHEN OTHERS THEN
6048: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6049: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Add_Offset_Data');
6050: END IF;
6051:
6052: IF PG_DEBUG in ('Y', 'C') THEN
6053: msc_sch_wb.atp_debug('Add_Offset_Data: ERROR' || sqlerrm );

Line 6191: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

6187: END IF;
6188:
6189: EXCEPTION
6190: WHEN OTHERS THEN
6191: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6192: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Remove_Offset_Demands');
6193: END IF;
6194:
6195: IF PG_DEBUG in ('Y', 'C') THEN

Line 6192: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Remove_Offset_Demands');

6188:
6189: EXCEPTION
6190: WHEN OTHERS THEN
6191: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6192: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Remove_Offset_Demands');
6193: END IF;
6194:
6195: IF PG_DEBUG in ('Y', 'C') THEN
6196: msc_sch_wb.atp_debug('Remove_Offset_Demands: ERROR' || sqlerrm );

Line 6373: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

6369: END IF;
6370:
6371: EXCEPTION
6372: WHEN OTHERS THEN
6373: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6374: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Remove_Offset_Supplies');
6375: END IF;
6376:
6377: IF PG_DEBUG in ('Y', 'C') THEN

Line 6374: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Remove_Offset_Supplies');

6370:
6371: EXCEPTION
6372: WHEN OTHERS THEN
6373: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6374: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Remove_Offset_Supplies');
6375: END IF;
6376:
6377: IF PG_DEBUG in ('Y', 'C') THEN
6378: msc_sch_wb.atp_debug('Remove_Offset_Supplies: ERROR' || sqlerrm );

Line 6455: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

6451: END IF;
6452:
6453: EXCEPTION
6454: WHEN OTHERS THEN
6455: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6456: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Remove_Offset_Resource_Reqs');
6457: END IF;
6458:
6459: IF PG_DEBUG in ('Y', 'C') THEN

Line 6456: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Remove_Offset_Resource_Reqs');

6452:
6453: EXCEPTION
6454: WHEN OTHERS THEN
6455: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6456: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Remove_Offset_Resource_Reqs');
6457: END IF;
6458:
6459: IF PG_DEBUG in ('Y', 'C') THEN
6460: msc_sch_wb.atp_debug('Remove_Offset_Supplies: ERROR' || sqlerrm );

Line 6519: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

6515: END IF;
6516:
6517: EXCEPTION
6518: WHEN OTHERS THEN
6519: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6520: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Remove_Offset_Data');
6521: END IF;
6522:
6523: IF PG_DEBUG in ('Y', 'C') THEN

Line 6520: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Remove_Offset_Data');

6516:
6517: EXCEPTION
6518: WHEN OTHERS THEN
6519: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6520: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Remove_Offset_Data');
6521: END IF;
6522:
6523: IF PG_DEBUG in ('Y', 'C') THEN
6524: msc_sch_wb.atp_debug('Remove_Offset_Data: ERROR' || sqlerrm );

Line 6677: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

6673: msc_sch_wb.atp_debug('Create_PF_Atp_Pegging: ' || my_sqlcode ||
6674: ' error encountered while creating ATP Pegging : ERROR = '|| sqlerrm);
6675: END IF;
6676:
6677: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6678: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME , 'Create_PF_Atp_Pegging');
6679: END IF;
6680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6678: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME , 'Create_PF_Atp_Pegging');

6674: ' error encountered while creating ATP Pegging : ERROR = '|| sqlerrm);
6675: END IF;
6676:
6677: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6678: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME , 'Create_PF_Atp_Pegging');
6679: END IF;
6680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6682:

Line 7090: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

7086: msc_sch_wb.atp_debug('Create_Atp_Pegging: ' || my_sqlcode ||
7087: ' error encountered while creating ATP Pegging : ERROR = '|| sqlerrm);
7088: END IF;
7089:
7090: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7091: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME , 'Create_Atp_Pegging');
7092: END IF;
7093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7091: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME , 'Create_Atp_Pegging');

7087: ' error encountered while creating ATP Pegging : ERROR = '|| sqlerrm);
7088: END IF;
7089:
7090: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7091: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME , 'Create_Atp_Pegging');
7092: END IF;
7093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7095: