29: X_LAST_UPDATE_LOGIN := -1;
30: end if;
31: else
32: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
33: app_exception.raise_exception;
34: end if;
35: insert into IGW_EXPENDITURE_TYPES (
36: EXPENDITURE_CATEGORY,
37: EXPENDITURE_TYPE,
84: open c1;
85: fetch c1 into tlinfo;
86: if (c1%notfound) then
87: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
88: app_exception.raise_exception;
89: close c1;
90: return;
91: end if;
92: close c1;
101: ) then
102: null;
103: else
104: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
105: app_exception.raise_exception;
106: end if;
107: return;
108: end LOCK_ROW;
109:
134: X_LAST_UPDATE_LOGIN := -1;
135: end if;
136: else
137: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
138: app_exception.raise_exception;
139: end if;
140: update IGW_EXPENDITURE_TYPES set
141: EXPENDITURE_CATEGORY = X_EXPENDITURE_CATEGORY,
142: EXPENDITURE_TYPE = X_EXPENDITURE_TYPE,