DBA Data[Home] [Help]

APPS.MSC_ATP_PEG dependencies on FND_MSG_PUB

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

5227: 'error in insert row: sqlcode = '|| to_char(my_sqlcode));
5228: msc_sch_wb.atp_debug('Add_Offset_Demands: ERROR- ' || sqlerrm );
5229: END IF;
5230:
5231: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5232: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME , 'Add_Offset_Demands');
5233: END IF;
5234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5235: -- Bug 3319810 Enable exception generation.

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

5228: msc_sch_wb.atp_debug('Add_Offset_Demands: ERROR- ' || sqlerrm );
5229: END IF;
5230:
5231: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5232: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME , 'Add_Offset_Demands');
5233: END IF;
5234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5235: -- Bug 3319810 Enable exception generation.
5236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5680: 'error in insert row: sqlcode = '|| to_char(my_sqlcode));
5681: msc_sch_wb.atp_debug('Add_Offset_Supplies: ERROR- ' || sqlerrm );
5682: END IF;
5683:
5684: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5685: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME , 'Add_Offset_Supplies');
5686: END IF;
5687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5688: -- Bug 3319810 Enable exception generation.

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

5681: msc_sch_wb.atp_debug('Add_Offset_Supplies: ERROR- ' || sqlerrm );
5682: END IF;
5683:
5684: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5685: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME , 'Add_Offset_Supplies');
5686: END IF;
5687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5688: -- Bug 3319810 Enable exception generation.
5689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5951: msc_sch_wb.atp_debug('Add_Offset_Resource_Reqs: ' ||
5952: 'error in processing: errmsg = '|| sqlerrm );
5953: END IF;
5954:
5955: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5956: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME , 'Add_Offset_Resource_Reqs');
5957: END IF;
5958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5959: -- Bug 3319810 Enable exception generation.

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

5952: 'error in processing: errmsg = '|| sqlerrm );
5953: END IF;
5954:
5955: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5956: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME , 'Add_Offset_Resource_Reqs');
5957: END IF;
5958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5959: -- Bug 3319810 Enable exception generation.
5960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6058: END IF;
6059:
6060: EXCEPTION
6061: WHEN OTHERS THEN
6062: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6063: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Add_Offset_Data');
6064: END IF;
6065:
6066: IF PG_DEBUG in ('Y', 'C') THEN

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

6059:
6060: EXCEPTION
6061: WHEN OTHERS THEN
6062: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6063: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Add_Offset_Data');
6064: END IF;
6065:
6066: IF PG_DEBUG in ('Y', 'C') THEN
6067: msc_sch_wb.atp_debug('Add_Offset_Data: ERROR' || sqlerrm );

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

6201: END IF;
6202:
6203: EXCEPTION
6204: WHEN OTHERS THEN
6205: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6206: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Remove_Offset_Demands');
6207: END IF;
6208:
6209: IF PG_DEBUG in ('Y', 'C') THEN

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

6202:
6203: EXCEPTION
6204: WHEN OTHERS THEN
6205: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6206: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Remove_Offset_Demands');
6207: END IF;
6208:
6209: IF PG_DEBUG in ('Y', 'C') THEN
6210: msc_sch_wb.atp_debug('Remove_Offset_Demands: ERROR' || sqlerrm );

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

6383: END IF;
6384:
6385: EXCEPTION
6386: WHEN OTHERS THEN
6387: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6388: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Remove_Offset_Supplies');
6389: END IF;
6390:
6391: IF PG_DEBUG in ('Y', 'C') THEN

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

6384:
6385: EXCEPTION
6386: WHEN OTHERS THEN
6387: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6388: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Remove_Offset_Supplies');
6389: END IF;
6390:
6391: IF PG_DEBUG in ('Y', 'C') THEN
6392: msc_sch_wb.atp_debug('Remove_Offset_Supplies: ERROR' || sqlerrm );

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

6465: END IF;
6466:
6467: EXCEPTION
6468: WHEN OTHERS THEN
6469: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6470: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Remove_Offset_Resource_Reqs');
6471: END IF;
6472:
6473: IF PG_DEBUG in ('Y', 'C') THEN

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

6466:
6467: EXCEPTION
6468: WHEN OTHERS THEN
6469: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6470: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Remove_Offset_Resource_Reqs');
6471: END IF;
6472:
6473: IF PG_DEBUG in ('Y', 'C') THEN
6474: msc_sch_wb.atp_debug('Remove_Offset_Supplies: ERROR' || sqlerrm );

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

6529: END IF;
6530:
6531: EXCEPTION
6532: WHEN OTHERS THEN
6533: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6534: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Remove_Offset_Data');
6535: END IF;
6536:
6537: IF PG_DEBUG in ('Y', 'C') THEN

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

6530:
6531: EXCEPTION
6532: WHEN OTHERS THEN
6533: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6534: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Remove_Offset_Data');
6535: END IF;
6536:
6537: IF PG_DEBUG in ('Y', 'C') THEN
6538: msc_sch_wb.atp_debug('Remove_Offset_Data: ERROR' || sqlerrm );

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

6748: msc_sch_wb.atp_debug('Create_PF_Atp_Pegging: ' || my_sqlcode ||
6749: ' error encountered while creating ATP Pegging : ERROR = '|| sqlerrm);
6750: END IF;
6751:
6752: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6753: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME , 'Create_PF_Atp_Pegging');
6754: END IF;
6755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6749: ' error encountered while creating ATP Pegging : ERROR = '|| sqlerrm);
6750: END IF;
6751:
6752: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6753: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME , 'Create_PF_Atp_Pegging');
6754: END IF;
6755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6757:

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

7492: msc_sch_wb.atp_debug('Create_Atp_Pegging: ' || my_sqlcode ||
7493: ' error encountered while creating ATP Pegging : ERROR = '|| sqlerrm);
7494: END IF;
7495:
7496: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7497: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME , 'Create_Atp_Pegging');
7498: END IF;
7499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7493: ' error encountered while creating ATP Pegging : ERROR = '|| sqlerrm);
7494: END IF;
7495:
7496: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7497: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME , 'Create_Atp_Pegging');
7498: END IF;
7499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7501: