DBA Data[Home] [Help]

APPS.QP_FORMULA_UTIL dependencies on OE_MSG_PUB

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

731: EXCEPTION
732:
733: WHEN OTHERS THEN
734:
735: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
736: THEN
737: OE_MSG_PUB.Add_Exc_Msg
738: ( G_PKG_NAME
739: , 'Update_Row'

Line 737: OE_MSG_PUB.Add_Exc_Msg

733: WHEN OTHERS THEN
734:
735: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
736: THEN
737: OE_MSG_PUB.Add_Exc_Msg
738: ( G_PKG_NAME
739: , 'Update_Row'
740: );
741: END IF;

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

841: EXCEPTION
842:
843: WHEN OTHERS THEN
844:
845: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
846: THEN
847: OE_MSG_PUB.Add_Exc_Msg
848: ( G_PKG_NAME
849: , 'Insert_Row'

Line 847: OE_MSG_PUB.Add_Exc_Msg

843: WHEN OTHERS THEN
844:
845: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
846: THEN
847: OE_MSG_PUB.Add_Exc_Msg
848: ( G_PKG_NAME
849: , 'Insert_Row'
850: );
851: END IF;

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

873: EXCEPTION
874:
875: WHEN OTHERS THEN
876:
877: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
878: THEN
879: OE_MSG_PUB.Add_Exc_Msg
880: ( G_PKG_NAME
881: , 'Delete_Row'

Line 879: OE_MSG_PUB.Add_Exc_Msg

875: WHEN OTHERS THEN
876:
877: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
878: THEN
879: OE_MSG_PUB.Add_Exc_Msg
880: ( G_PKG_NAME
881: , 'Delete_Row'
882: );
883: END IF;

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

964: EXCEPTION
965:
966: WHEN OTHERS THEN
967:
968: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
969: THEN
970: OE_MSG_PUB.Add_Exc_Msg
971: ( G_PKG_NAME
972: , 'Query_Row'

Line 970: OE_MSG_PUB.Add_Exc_Msg

966: WHEN OTHERS THEN
967:
968: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
969: THEN
970: OE_MSG_PUB.Add_Exc_Msg
971: ( G_PKG_NAME
972: , 'Query_Row'
973: );
974: END IF;

Line 1117: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

1113:
1114: x_return_status := FND_API.G_RET_STS_ERROR;
1115: x_FORMULA_rec.return_status := FND_API.G_RET_STS_ERROR;
1116:
1117: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1118: THEN
1119:
1120: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
1121: OE_MSG_PUB.Add;

Line 1121: OE_MSG_PUB.Add;

1117: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1118: THEN
1119:
1120: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
1121: OE_MSG_PUB.Add;
1122:
1123: END IF;
1124:
1125: END IF;

Line 1135: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

1131:
1132: x_return_status := FND_API.G_RET_STS_ERROR;
1133: x_FORMULA_rec.return_status := FND_API.G_RET_STS_ERROR;
1134:
1135: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1136: THEN
1137:
1138: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
1139: OE_MSG_PUB.Add;

Line 1139: OE_MSG_PUB.Add;

1135: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1136: THEN
1137:
1138: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
1139: OE_MSG_PUB.Add;
1140:
1141: END IF;
1142: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1143:

Line 1147: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

1143:
1144: x_return_status := FND_API.G_RET_STS_ERROR;
1145: x_FORMULA_rec.return_status := FND_API.G_RET_STS_ERROR;
1146:
1147: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1148: THEN
1149:
1150: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
1151: OE_MSG_PUB.Add;

Line 1151: OE_MSG_PUB.Add;

1147: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1148: THEN
1149:
1150: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
1151: OE_MSG_PUB.Add;
1152:
1153: END IF;
1154: WHEN OTHERS THEN
1155:

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

1155:
1156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1157: x_FORMULA_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1158:
1159: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1160: THEN
1161: OE_MSG_PUB.Add_Exc_Msg
1162: ( G_PKG_NAME
1163: , 'Lock_Row'

Line 1161: OE_MSG_PUB.Add_Exc_Msg

1157: x_FORMULA_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1158:
1159: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1160: THEN
1161: OE_MSG_PUB.Add_Exc_Msg
1162: ( G_PKG_NAME
1163: , 'Lock_Row'
1164: );
1165: END IF;

Line 1222: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

1218: IF p_FORMULA_rec.price_formula_id <> FND_API.G_MISS_NUM THEN
1219:
1220: l_FORMULA_rec.price_formula_id := p_FORMULA_rec.price_formula_id;
1221:
1222: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1223: THEN
1224:
1225: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1226: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_formula');

Line 1227: OE_MSG_PUB.Add;

1223: THEN
1224:
1225: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1226: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_formula');
1227: OE_MSG_PUB.Add;
1228:
1229: END IF;
1230:
1231: ELSE