82: if P_LAST_UPDATE_LOGIN is NULL then
83: P_LAST_UPDATE_LOGIN := -1;
84: end if;
85: else
86: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
87: FND_MSG_PUB.Add ;
88: raise FND_API.G_EXC_ERROR;
89: end if;
90: --
239: --
240: FETCH C INTO Recinfo;
241: IF (C%NOTFOUND) then
242: CLOSE C;
243: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
244: FND_MSG_PUB.Add;
245: CLOSE c;
246: RAISE FND_API.G_EXC_ERROR ;
247: END IF;
265: )
266: THEN
267: NULL ;
268: ELSE
269: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED') ;
270: FND_MSG_PUB.Add ;
271: RAISE FND_API.G_EXC_ERROR ;
272: END IF;
273:
389: if P_LAST_UPDATE_LOGIN is NULL then
390: P_LAST_UPDATE_LOGIN := -1;
391: end if;
392: else
393: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
394: FND_MSG_PUB.Add ;
395: raise FND_API.G_EXC_ERROR ;
396: end if;
397: --
625: if P_LAST_UPDATE_LOGIN is NULL then
626: P_LAST_UPDATE_LOGIN := -1;
627: end if;
628: else
629: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
630: FND_MSG_PUB.Add ;
631: raise FND_API.G_EXC_ERROR;
632: end if;
633: --
855: --
856: FETCH C INTO Recinfo;
857: IF (C%NOTFOUND) then
858: CLOSE C;
859: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
860: FND_MSG_PUB.Add;
861: CLOSE c;
862: RAISE FND_API.G_EXC_ERROR ;
863: END IF;
874: )
875: THEN
876: NULL ;
877: ELSE
878: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED') ;
879: FND_MSG_PUB.Add ;
880: RAISE FND_API.G_EXC_ERROR ;
881: END IF;
882:
988: if P_LAST_UPDATE_LOGIN is NULL then
989: P_LAST_UPDATE_LOGIN := -1;
990: end if;
991: else
992: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
993: FND_MSG_PUB.Add ;
994: raise FND_API.G_EXC_ERROR ;
995: end if;
996: --