[Home] [Help]
175: 2) FND_MESSAGE.SET_NAME('PA' ,SQLERRM) is wrong which was returning no_data_found
176: Exception
177: When Others Then
178: FND_MESSAGE.SET_NAME('PA' ,SQLERRM);
179: APP_EXCEPTION.RAISE_EXCEPTION;*/
180: END Insert_Parent_Row;
181:
182: PROCEDURE Update_Parent_Row (X_ROW_ID IN VARCHAR2,
183: X_RESOURCE_LIST_MEMBER_ID NUMBER,
231: FETCH C INTO Recinfo;
232: If (C%NOTFOUND) THEN
233: Close C;
234: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
235: APP_EXCEPTION.RAISE_EXCEPTION;
236: END If;
237: CLOSE C;
238: IF (
239: (X_RESOURCE_LIST_MEMBER_ID = Recinfo.RESOURCE_LIST_MEMBER_ID) And
252: ) Then
253: Return;
254: Else
255: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_CHANGED');
256: APP_EXCEPTION.RAISE_EXCEPTION;
257: END If;
258:
259: End Lock_Parent_Row;
260:
437: 2) FND_MESSAGE.SET_NAME('PA' ,SQLERRM) is wrong which was returning no_data_found
438: Exception
439: When Others Then
440: FND_MESSAGE.SET_NAME('PA' ,SQLERRM);
441: APP_EXCEPTION.RAISE_EXCEPTION;*/
442: END Insert_CHILD_Row;
443:
444: PROCEDURE Update_CHILD_Row (X_ROW_ID IN VARCHAR2,
445: X_RESOURCE_LIST_MEMBER_ID NUMBER,
491: FETCH C INTO Recinfo;
492: If (C%NOTFOUND) THEN
493: Close C;
494: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
495: APP_EXCEPTION.RAISE_EXCEPTION;
496: END If;
497: CLOSE C;
498: IF (
499: (X_RESOURCE_LIST_MEMBER_ID = Recinfo.RESOURCE_LIST_MEMBER_ID) And
511: ) Then
512: Return;
513: Else
514: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_CHANGED');
515: APP_EXCEPTION.RAISE_EXCEPTION;
516: END If;
517:
518: End Lock_CHILD_Row;
519:
589: EXCEPTION
590: When Others Then
591:
592: --FND_MESSAGE.SET_NAME('PA' ,SQLERRM);
593: APP_EXCEPTION.RAISE_EXCEPTION;*/
594:
595: end DELETE_UNCLASSIFIED_CHILD;
596:
597: End PA_Resource_List_Pkg;