DBA Data[Home] [Help]

APPS.ITA_SETUP_GROUPS_PKG dependencies on FND_FILE

Line 194: fnd_file.put_line(fnd_file.log,'SG_PKG.UR: ' || X_AUDIT_END_DATE);

190: X_LAST_UPDATE_LOGIN in NUMBER
191: ) is
192: begin
193:
194: fnd_file.put_line(fnd_file.log,'SG_PKG.UR: ' || X_AUDIT_END_DATE);
195: update ITA_SETUP_GROUPS_B set
196: TABLE_ID = X_TABLE_ID,
197: TABLE_APP_ID = X_TABLE_APP_ID,
198: CONTEXT_PARAMETER_CODE = X_CONTEXT_PARAMETER_CODE,

Line 334: fnd_file.put_line(fnd_file.log,'Setup Group: ' || X_SETUP_GROUP_CODE);

330: db_luby number; -- entity owner in db
331: db_ludate date; -- entity update date in db
332: begin
333:
334: fnd_file.put_line(fnd_file.log,'Setup Group: ' || X_SETUP_GROUP_CODE);
335: fnd_file.put_line(fnd_file.log,'Custom mode: ' || X_CUSTOM_MODE);
336:
337: -- translate values to IDs
338: select APPLICATION_ID

Line 335: fnd_file.put_line(fnd_file.log,'Custom mode: ' || X_CUSTOM_MODE);

331: db_ludate date; -- entity update date in db
332: begin
333:
334: fnd_file.put_line(fnd_file.log,'Setup Group: ' || X_SETUP_GROUP_CODE);
335: fnd_file.put_line(fnd_file.log,'Custom mode: ' || X_CUSTOM_MODE);
336:
337: -- translate values to IDs
338: select APPLICATION_ID
339: into view_appid

Line 376: fnd_file.put_line(fnd_file.log,'Update Row: ' || l_audit_end_date || ': ' || X_AUDIT_END_DATE);

372: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
373: db_ludate, x_CUSTOM_MODE)) then
374: -- Update existing row
375: -- Changes made for R12, to set audit end date for obsolete tables
376: fnd_file.put_line(fnd_file.log,'Update Row: ' || l_audit_end_date || ': ' || X_AUDIT_END_DATE);
377: ITA_SETUP_GROUPS_PKG.UPDATE_ROW(
378: X_SETUP_GROUP_CODE => X_SETUP_GROUP_CODE,
379: X_TABLE_ID => view_table_id,
380: X_TABLE_APP_ID => view_appid,

Line 396: fnd_file.put_line(fnd_file.log,'Insert');

392:
393: exception
394: when no_data_found then
395: -- Record doesn't exist - insert in all cases
396: fnd_file.put_line(fnd_file.log,'Insert');
397: ITA_SETUP_GROUPS_PKG.INSERT_ROW(
398: x_rowid => row_id,
399: X_SETUP_GROUP_CODE => X_SETUP_GROUP_CODE,
400: X_TABLE_ID => view_table_id,