eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_INDUSTRY_ACTIVATOR dependencies on FND_FILE

Line 28: FND_FILE.NEW_LINE(FND_FILE.LOG);

24: language_code = p_language_code and
25: last_updated_by IN ('0','1','2');
26:
27: BEGIN
28: FND_FILE.NEW_LINE(FND_FILE.LOG);
29: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Updating industry translated message text.');
30: -- get the list of messages for the current industry from fnd_new_messages_il
31: for v1 in industry_message_list(v_industry_id) loop
32: -- populate the orig_message_text column

Line 29: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Updating industry translated message text.');

25: last_updated_by IN ('0','1','2');
26:
27: BEGIN
28: FND_FILE.NEW_LINE(FND_FILE.LOG);
29: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Updating industry translated message text.');
30: -- get the list of messages for the current industry from fnd_new_messages_il
31: for v1 in industry_message_list(v_industry_id) loop
32: -- populate the orig_message_text column
33: for v2 in get_original_text(v1.application_id,

Line 53: FND_FILE.NEW_LINE(FND_FILE.LOG);

49: message_name = v1.message_name and
50: language_code = v1.language_code;
51: end loop;
52: commit;
53: FND_FILE.NEW_LINE(FND_FILE.LOG);
54: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Update of industry translated message text completed.');
55: END activate_messages;
56:
57: procedure activate_lookups is

Line 54: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Update of industry translated message text completed.');

50: language_code = v1.language_code;
51: end loop;
52: commit;
53: FND_FILE.NEW_LINE(FND_FILE.LOG);
54: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Update of industry translated message text completed.');
55: END activate_messages;
56:
57: procedure activate_lookups is
58:

Line 84: FND_FILE.NEW_LINE(FND_FILE.LOG);

80: language = p_language_code and
81: last_updated_by IN ('0','1','2');
82:
83: BEGIN
84: FND_FILE.NEW_LINE(FND_FILE.LOG);
85: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Updating industry translated lookups.');
86: -- get the list of lookups for the current industry from fnd_lookup_values_il
87: for v1 in industry_lookup_list(v_industry_id) loop
88: -- populate the orig_message_text column

Line 85: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Updating industry translated lookups.');

81: last_updated_by IN ('0','1','2');
82:
83: BEGIN
84: FND_FILE.NEW_LINE(FND_FILE.LOG);
85: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Updating industry translated lookups.');
86: -- get the list of lookups for the current industry from fnd_lookup_values_il
87: for v1 in industry_lookup_list(v_industry_id) loop
88: -- populate the orig_message_text column
89: for v2 in get_original_lookups(v1.application_id,

Line 133: FND_FILE.NEW_LINE(FND_FILE.LOG);

129: language = v1.language_code;
130: end if;
131: end loop;
132: commit;
133: FND_FILE.NEW_LINE(FND_FILE.LOG);
134: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Completed updating industry translated lookups.');
135: END activate_lookups;
136:
137: procedure section_title (which IN number,

Line 134: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Completed updating industry translated lookups.');

130: end if;
131: end loop;
132: commit;
133: FND_FILE.NEW_LINE(FND_FILE.LOG);
134: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Completed updating industry translated lookups.');
135: END activate_lookups;
136:
137: procedure section_title (which IN number,
138: title IN varchar2) is

Line 141: FND_FILE.NEW_LINE(which);

137: procedure section_title (which IN number,
138: title IN varchar2) is
139:
140: begin
141: FND_FILE.NEW_LINE(which);
142: FND_FILE.PUT_LINE(which, '----------------------------------------------------------------');
143: FND_FILE.PUT_LINE(which, title);
144: FND_FILE.PUT_LINE(which, '----------------------------------------------------------------');
145: end section_title;

Line 142: FND_FILE.PUT_LINE(which, '----------------------------------------------------------------');

138: title IN varchar2) is
139:
140: begin
141: FND_FILE.NEW_LINE(which);
142: FND_FILE.PUT_LINE(which, '----------------------------------------------------------------');
143: FND_FILE.PUT_LINE(which, title);
144: FND_FILE.PUT_LINE(which, '----------------------------------------------------------------');
145: end section_title;
146:

Line 143: FND_FILE.PUT_LINE(which, title);

139:
140: begin
141: FND_FILE.NEW_LINE(which);
142: FND_FILE.PUT_LINE(which, '----------------------------------------------------------------');
143: FND_FILE.PUT_LINE(which, title);
144: FND_FILE.PUT_LINE(which, '----------------------------------------------------------------');
145: end section_title;
146:
147:

Line 144: FND_FILE.PUT_LINE(which, '----------------------------------------------------------------');

140: begin
141: FND_FILE.NEW_LINE(which);
142: FND_FILE.PUT_LINE(which, '----------------------------------------------------------------');
143: FND_FILE.PUT_LINE(which, title);
144: FND_FILE.PUT_LINE(which, '----------------------------------------------------------------');
145: end section_title;
146:
147:
148: ----PUBLIC ROUTINES

Line 159: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start of FND_INDUSTRY_ACTIVATION');

155: v_errbuf VARCHAR2(2000);
156: v_retcode VARCHAR2(3);
157: v_activate_date DATE;
158: BEGIN
159: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start of FND_INDUSTRY_ACTIVATION');
160: v_activate_date := SYSDATE;
161: deactivate_industries(v_errbuf,
162: v_retcode);
163: if retcode = 2 then

Line 169: section_title(FND_FILE.LOG, 'Activating industry '||v_industry_id);

165: end if;
166: v_industry_id := to_number(p_industry_id);
167: --Now set the profile to the new value for the desired industry
168: if fnd_profile.save('FND_INDUSTRY_ID', v_industry_id,'SITE') then
169: section_title(FND_FILE.LOG, 'Activating industry '||v_industry_id);
170: commit;
171: else
172: raise e_bad_profile;
173: end if;

Line 225: FND_FILE.NEW_LINE(FND_FILE.LOG);

221: if v_industry_id is NULL then
222:
223: return;
224: end if;
225: FND_FILE.NEW_LINE(FND_FILE.LOG);
226: section_title(FND_FILE.LOG, 'Deactivating INDUSTRY_ID '||v_industry_id);
227: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Restoring original message text.');
228:
229:

Line 226: section_title(FND_FILE.LOG, 'Deactivating INDUSTRY_ID '||v_industry_id);

222:
223: return;
224: end if;
225: FND_FILE.NEW_LINE(FND_FILE.LOG);
226: section_title(FND_FILE.LOG, 'Deactivating INDUSTRY_ID '||v_industry_id);
227: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Restoring original message text.');
228:
229:
230: for v1 in restore_message_text loop

Line 227: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Restoring original message text.');

223: return;
224: end if;
225: FND_FILE.NEW_LINE(FND_FILE.LOG);
226: section_title(FND_FILE.LOG, 'Deactivating INDUSTRY_ID '||v_industry_id);
227: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Restoring original message text.');
228:
229:
230: for v1 in restore_message_text loop
231:

Line 242: FND_FILE.PUT_LINE(FND_FILE.LOG,'Original message text restored.');

238: language_code = v1.language_code;
239: end if;
240: end loop;
241: commit;
242: FND_FILE.PUT_LINE(FND_FILE.LOG,'Original message text restored.');
243: -- clean up the orig_message_text column in the FND_NEW_MESSAGES_IL table
244: update fnd_new_messages_il
245: set orig_message_text = null;
246: commit;

Line 247: FND_FILE.NEW_LINE(FND_FILE.LOG);

243: -- clean up the orig_message_text column in the FND_NEW_MESSAGES_IL table
244: update fnd_new_messages_il
245: set orig_message_text = null;
246: commit;
247: FND_FILE.NEW_LINE(FND_FILE.LOG);
248: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Restoring original lookup values meaning and description.');
249: for v2 in restore_lookups loop
250: if v2.orig_meaning is not null then
251: update fnd_lookup_values

Line 248: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Restoring original lookup values meaning and description.');

244: update fnd_new_messages_il
245: set orig_message_text = null;
246: commit;
247: FND_FILE.NEW_LINE(FND_FILE.LOG);
248: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Restoring original lookup values meaning and description.');
249: for v2 in restore_lookups loop
250: if v2.orig_meaning is not null then
251: update fnd_lookup_values
252: set meaning = v2.orig_meaning,

Line 262: FND_FILE.PUT_LINE(FND_FILE.LOG,'Original lookup value meanings and descriptions restored.');

258: and language = v2.language_code;
259: end if;
260: end loop;
261: commit;
262: FND_FILE.PUT_LINE(FND_FILE.LOG,'Original lookup value meanings and descriptions restored.');
263: -- clean up the orig_meaning and orig_description columns in the FND_LOOKUP_VALUES_IL table
264: update fnd_lookup_values_il
265: set orig_meaning = null,
266: orig_description = null;