DBA Data[Home] [Help]

APPS.PA_PROJECT_CONTACTS_PKG dependencies on APP_EXCEPTION

Line 86: APP_EXCEPTION.Raise_Exception;

82: FETCH C INTO Recinfo;
83: if (C%NOTFOUND) then
84: CLOSE C;
85: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
86: APP_EXCEPTION.Raise_Exception;
87: end if;
88: CLOSE C;
89: if recinfo.record_version_number <> x_record_version_number
90: then

Line 92: APP_EXCEPTION.Raise_Exception;

88: CLOSE C;
89: if recinfo.record_version_number <> x_record_version_number
90: then
91: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
92: APP_EXCEPTION.Raise_Exception;
93: end if;
94: if (
95:
96: (Recinfo.project_id = X_Project_Id)

Line 105: APP_EXCEPTION.Raise_Exception;

101: ) then
102: return;
103: else
104: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
105: APP_EXCEPTION.Raise_Exception;
106: end if;
107: END Lock_Row;
108:
109:

Line 135: APP_EXCEPTION.Raise_Exception;

131: FETCH C INTO Recinfo;
132: if (C%NOTFOUND) then
133: CLOSE C;
134: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
135: APP_EXCEPTION.Raise_Exception;
136: end if;
137: CLOSE C;
138: if recinfo.record_version_number <> x_record_version_number
139: then

Line 141: APP_EXCEPTION.Raise_Exception;

137: CLOSE C;
138: if recinfo.record_version_number <> x_record_version_number
139: then
140: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
141: APP_EXCEPTION.Raise_Exception;
142: end if;
143: UPDATE pa_project_contacts
144: SET
145: project_id = X_Project_Id,

Line 174: APP_EXCEPTION.Raise_Exception;

170: FETCH C INTO Recinfo;
171: if (C%NOTFOUND) then
172: CLOSE C;
173: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
174: APP_EXCEPTION.Raise_Exception;
175: end if;
176: CLOSE C;
177: if recinfo.record_version_number <> x_record_version_number
178: then

Line 180: APP_EXCEPTION.Raise_Exception;

176: CLOSE C;
177: if recinfo.record_version_number <> x_record_version_number
178: then
179: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
180: APP_EXCEPTION.Raise_Exception;
181: end if;
182: DELETE FROM pa_project_contacts
183: WHERE rowid = X_Rowid;
184: