160: X_ATTRIBUTE14,
161: X_ATTRIBUTE15,
162: X_ATTRIBUTE_CATEGORY,
163: sysdate,
164: FND_GLOBAL.USER_ID,
165: SYSDATE,
166: FND_GLOBAL.USER_ID,
167: NULL
168: );
162: X_ATTRIBUTE_CATEGORY,
163: sysdate,
164: FND_GLOBAL.USER_ID,
165: SYSDATE,
166: FND_GLOBAL.USER_ID,
167: NULL
168: );
169:
170: insert into JTF_CAL_EXCEPTIONS_TL (
182: v_exception_id,
183: X_EXCEPTION_NAME,
184: X_DESCRIPTION,
185: sysdate,
186: FND_GLOBAL.USER_ID,
187: SYSDATE,
188: FND_GLOBAL.USER_ID,
189: NULL,
190: L.LANGUAGE_CODE,
184: X_DESCRIPTION,
185: sysdate,
186: FND_GLOBAL.USER_ID,
187: SYSDATE,
188: FND_GLOBAL.USER_ID,
189: NULL,
190: L.LANGUAGE_CODE,
191: userenv('LANG')
192: from FND_LANGUAGES L
459: ATTRIBUTE14 = X_ATTRIBUTE14,
460: ATTRIBUTE15 = X_ATTRIBUTE15,
461: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
462: LAST_UPDATE_DATE = sysdate,
463: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
464: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
465: where EXCEPTION_ID = X_EXCEPTION_ID;
466:
467: if (sql%notfound) then
460: ATTRIBUTE15 = X_ATTRIBUTE15,
461: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
462: LAST_UPDATE_DATE = sysdate,
463: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
464: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
465: where EXCEPTION_ID = X_EXCEPTION_ID;
466:
467: if (sql%notfound) then
468: raise no_data_found;
472: JTF_CAL_EXCEPTIONS_TL set
473: EXCEPTION_NAME = X_EXCEPTION_NAME,
474: DESCRIPTION = X_DESCRIPTION,
475: LAST_UPDATE_DATE = sysdate,
476: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
477: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
478: SOURCE_LANG = userenv('LANG')
479: where EXCEPTION_ID = X_EXCEPTION_ID
480: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
473: EXCEPTION_NAME = X_EXCEPTION_NAME,
474: DESCRIPTION = X_DESCRIPTION,
475: LAST_UPDATE_DATE = sysdate,
476: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
477: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
478: SOURCE_LANG = userenv('LANG')
479: where EXCEPTION_ID = X_EXCEPTION_ID
480: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
481: