DBA Data[Home] [Help]

APPS.QP_SSC_UTIL dependencies on OE_MSG_PUB

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

736: EXCEPTION
737:
738: WHEN OTHERS THEN
739:
740: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
741: THEN
742: OE_MSG_PUB.Add_Exc_Msg
743: ( G_PKG_NAME
744: , 'Update_Row'

Line 742: OE_MSG_PUB.Add_Exc_Msg

738: WHEN OTHERS THEN
739:
740: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
741: THEN
742: OE_MSG_PUB.Add_Exc_Msg
743: ( G_PKG_NAME
744: , 'Update_Row'
745: );
746: END IF;

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

821: EXCEPTION
822:
823: WHEN OTHERS THEN
824:
825: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
826: THEN
827: OE_MSG_PUB.Add_Exc_Msg
828: ( G_PKG_NAME
829: , 'Insert_Row'

Line 827: OE_MSG_PUB.Add_Exc_Msg

823: WHEN OTHERS THEN
824:
825: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
826: THEN
827: OE_MSG_PUB.Add_Exc_Msg
828: ( G_PKG_NAME
829: , 'Insert_Row'
830: );
831: END IF;

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

849: EXCEPTION
850:
851: WHEN OTHERS THEN
852:
853: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
854: THEN
855: OE_MSG_PUB.Add_Exc_Msg
856: ( G_PKG_NAME
857: , 'Delete_Row'

Line 855: OE_MSG_PUB.Add_Exc_Msg

851: WHEN OTHERS THEN
852:
853: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
854: THEN
855: OE_MSG_PUB.Add_Exc_Msg
856: ( G_PKG_NAME
857: , 'Delete_Row'
858: );
859: END IF;

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

936: (p_lookup_code IS NOT NULL
937: AND
938: p_lookup_code <> FND_API.G_MISS_CHAR)
939: THEN
940: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
941: THEN
942: OE_MSG_PUB.Add_Exc_Msg
943: ( G_PKG_NAME
944: , 'Query Rows'

Line 942: OE_MSG_PUB.Add_Exc_Msg

938: p_lookup_code <> FND_API.G_MISS_CHAR)
939: THEN
940: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
941: THEN
942: OE_MSG_PUB.Add_Exc_Msg
943: ( G_PKG_NAME
944: , 'Query Rows'
945: , 'Keys are mutually exclusive: pte_source_system_id = '|| p_pte_source_system_id || ', lookup_code = '|| p_lookup_code
946: );

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

1013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1014:
1015: WHEN OTHERS THEN
1016:
1017: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1018: THEN
1019: OE_MSG_PUB.Add_Exc_Msg
1020: ( G_PKG_NAME
1021: , 'Query_Rows'

Line 1019: OE_MSG_PUB.Add_Exc_Msg

1015: WHEN OTHERS THEN
1016:
1017: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1018: THEN
1019: OE_MSG_PUB.Add_Exc_Msg
1020: ( G_PKG_NAME
1021: , 'Query_Rows'
1022: );
1023: END IF;

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

1173:
1174: x_return_status := FND_API.G_RET_STS_ERROR;
1175: x_SSC_rec.return_status := FND_API.G_RET_STS_ERROR;
1176:
1177: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1178: THEN
1179:
1180: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
1181: OE_MSG_PUB.Add;

Line 1181: OE_MSG_PUB.Add;

1177: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1178: THEN
1179:
1180: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
1181: OE_MSG_PUB.Add;
1182:
1183: END IF;
1184:
1185: END IF;

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

1190:
1191: x_return_status := FND_API.G_RET_STS_ERROR;
1192: x_SSC_rec.return_status := FND_API.G_RET_STS_ERROR;
1193:
1194: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1195: THEN
1196:
1197: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
1198: OE_MSG_PUB.Add;

Line 1198: OE_MSG_PUB.Add;

1194: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1195: THEN
1196:
1197: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
1198: OE_MSG_PUB.Add;
1199:
1200: END IF;
1201: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1202:

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

1202:
1203: x_return_status := FND_API.G_RET_STS_ERROR;
1204: x_SSC_rec.return_status := FND_API.G_RET_STS_ERROR;
1205:
1206: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1207: THEN
1208:
1209: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
1210: OE_MSG_PUB.Add;

Line 1210: OE_MSG_PUB.Add;

1206: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1207: THEN
1208:
1209: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
1210: OE_MSG_PUB.Add;
1211:
1212: END IF;
1213: WHEN OTHERS THEN
1214:

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

1214:
1215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1216: x_SSC_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1217:
1218: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1219: THEN
1220: OE_MSG_PUB.Add_Exc_Msg
1221: ( G_PKG_NAME
1222: , 'Lock_Row'

Line 1220: OE_MSG_PUB.Add_Exc_Msg

1216: x_SSC_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1217:
1218: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1219: THEN
1220: OE_MSG_PUB.Add_Exc_Msg
1221: ( G_PKG_NAME
1222: , 'Lock_Row'
1223: );
1224: END IF;

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

1294: IF p_SSC_rec.enabled_flag <> FND_API.G_MISS_CHAR THEN
1295:
1296: l_SSC_rec.enabled_flag := p_SSC_rec.enabled_flag;
1297:
1298: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1299: THEN
1300:
1301: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1302: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','enabled');

Line 1303: OE_MSG_PUB.Add;

1299: THEN
1300:
1301: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1302: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','enabled');
1303: OE_MSG_PUB.Add;
1304:
1305: END IF;
1306:
1307: ELSE

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

1324: IF p_SSC_rec.pte_code <> FND_API.G_MISS_CHAR THEN
1325:
1326: l_SSC_rec.pte_code := p_SSC_rec.pte_code;
1327:
1328: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1329: THEN
1330:
1331: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1332: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pte');

Line 1333: OE_MSG_PUB.Add;

1329: THEN
1330:
1331: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1332: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pte');
1333: OE_MSG_PUB.Add;
1334:
1335: END IF;
1336:
1337: ELSE

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

1354: IF p_SSC_rec.pte_source_system_id <> FND_API.G_MISS_NUM THEN
1355:
1356: l_SSC_rec.pte_source_system_id := p_SSC_rec.pte_source_system_id;
1357:
1358: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1359: THEN
1360:
1361: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1362: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pte_source_system');

Line 1363: OE_MSG_PUB.Add;

1359: THEN
1360:
1361: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1362: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pte_source_system');
1363: OE_MSG_PUB.Add;
1364:
1365: END IF;
1366:
1367: ELSE