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.CUG_SR_ATTRIBUTE_INTF dependencies on FND_FILE

Line 125: fnd_file.put_line(fnd_file.log,'Start of SR Attribute Interface logic');

121: BEGIN
122:
123: /* Opening the main cursor to fetch new/update sr attribute records to be processed */
124:
125: fnd_file.put_line(fnd_file.log,'Start of SR Attribute Interface logic');
126: fnd_file.put_line(fnd_file.log,'Parameter Start Date :' || p_date);
127:
128: select to_date(p_date, 'YYYY/MM/DD HH24:MI:SS') INTO l_date from dual;
129:

Line 126: fnd_file.put_line(fnd_file.log,'Parameter Start Date :' || p_date);

122:
123: /* Opening the main cursor to fetch new/update sr attribute records to be processed */
124:
125: fnd_file.put_line(fnd_file.log,'Start of SR Attribute Interface logic');
126: fnd_file.put_line(fnd_file.log,'Parameter Start Date :' || p_date);
127:
128: select to_date(p_date, 'YYYY/MM/DD HH24:MI:SS') INTO l_date from dual;
129:
130: fnd_file.put_line(fnd_file.log,'Parameter Start Date :' || to_char(l_date,'DD-MON-YYYY'));

Line 130: fnd_file.put_line(fnd_file.log,'Parameter Start Date :' || to_char(l_date,'DD-MON-YYYY'));

126: fnd_file.put_line(fnd_file.log,'Parameter Start Date :' || p_date);
127:
128: select to_date(p_date, 'YYYY/MM/DD HH24:MI:SS') INTO l_date from dual;
129:
130: fnd_file.put_line(fnd_file.log,'Parameter Start Date :' || to_char(l_date,'DD-MON-YYYY'));
131:
132: --FOR l_sr_attr in c_sr_attr LOOP
133: OPEN c_sr_attr (l_date);
134: FETCH c_sr_attr INTO l_sr_attr;

Line 138: fnd_file.put_line(fnd_file.log, '----------------------- Start of New Record processing ---------------------');

134: FETCH c_sr_attr INTO l_sr_attr;
135:
136: WHILE (c_sr_attr%FOUND) loop
137:
138: fnd_file.put_line(fnd_file.log, '***----------------------- Start of New Record processing ---------------------***');
139: fnd_file.put_line(fnd_file.log,'l_sr_attr loop, SR Type :' || l_sr_attr.sr_type);
140:
141: l_update_flag := false;
142: l_attr_update_flag := false;

Line 139: fnd_file.put_line(fnd_file.log,'l_sr_attr loop, SR Type :' || l_sr_attr.sr_type);

135:
136: WHILE (c_sr_attr%FOUND) loop
137:
138: fnd_file.put_line(fnd_file.log, '***----------------------- Start of New Record processing ---------------------***');
139: fnd_file.put_line(fnd_file.log,'l_sr_attr loop, SR Type :' || l_sr_attr.sr_type);
140:
141: l_update_flag := false;
142: l_attr_update_flag := false;
143:

Line 167: fnd_file.put_line(fnd_file.log,'Template does not exists for SR Type : ' || l_sr_attr.sr_type);

163:
164: /* Check if the cursor fetched any records */
165: if c_template_exists%NOTFOUND then
166: -- Calling the create template API to create new template record
167: fnd_file.put_line(fnd_file.log,'Template does not exists for SR Type : ' || l_sr_attr.sr_type);
168: fnd_file.put_line(fnd_file.log,'Calling Create Template API, SR Type : ' || l_sr_attr.sr_type);
169: CS_TP_TEMPLATES_PVT.Add_Template
170: (
171: p_api_version_number => l_api_version,

Line 168: fnd_file.put_line(fnd_file.log,'Calling Create Template API, SR Type : ' || l_sr_attr.sr_type);

164: /* Check if the cursor fetched any records */
165: if c_template_exists%NOTFOUND then
166: -- Calling the create template API to create new template record
167: fnd_file.put_line(fnd_file.log,'Template does not exists for SR Type : ' || l_sr_attr.sr_type);
168: fnd_file.put_line(fnd_file.log,'Calling Create Template API, SR Type : ' || l_sr_attr.sr_type);
169: CS_TP_TEMPLATES_PVT.Add_Template
170: (
171: p_api_version_number => l_api_version,
172: p_init_msg_list => l_init_msg_list_true,

Line 182: fnd_file.put_line(fnd_file.log,'Template does not exists for SR Type : ' || l_sr_attr.sr_type);

178: x_template_id => l_tmpl_id
179: );
180:
181: -- Calling the create template link API to create new template link record
182: fnd_file.put_line(fnd_file.log,'Template does not exists for SR Type : ' || l_sr_attr.sr_type);
183: fnd_file.put_line(fnd_file.log,'Calling Create Template Link API, SR Type : ' || l_sr_attr.sr_type);
184: CS_TP_TEMPLATES_PVT.update_template_links
185: (
186: p_api_version_number => l_api_version,

Line 183: fnd_file.put_line(fnd_file.log,'Calling Create Template Link API, SR Type : ' || l_sr_attr.sr_type);

179: );
180:
181: -- Calling the create template link API to create new template link record
182: fnd_file.put_line(fnd_file.log,'Template does not exists for SR Type : ' || l_sr_attr.sr_type);
183: fnd_file.put_line(fnd_file.log,'Calling Create Template Link API, SR Type : ' || l_sr_attr.sr_type);
184: CS_TP_TEMPLATES_PVT.update_template_links
185: (
186: p_api_version_number => l_api_version,
187: p_init_msg_list => l_init_msg_list_true,

Line 197: fnd_file.put_line(fnd_file.log,'Template already defined for SR Type : '|| l_sr_attr.sr_type);

193: x_msg_data => x_msg_data,
194: x_return_status => x_return_status
195: );
196: else
197: fnd_file.put_line(fnd_file.log,'Template already defined for SR Type : '|| l_sr_attr.sr_type);
198: l_tmpl_id := l_tmpl_exists.template_id;
199: end if;
200: close c_template_exists;
201:

Line 202: fnd_file.put_line(fnd_file.log,'Attribute Code: ' || l_sr_attr.sr_name);

198: l_tmpl_id := l_tmpl_exists.template_id;
199: end if;
200: close c_template_exists;
201:
202: fnd_file.put_line(fnd_file.log,'Attribute Code: ' || l_sr_attr.sr_name);
203:
204: -- Check for if attribute StartDateActive and EndDateActive has value
205: -- Added the trunc for bug fix 2435523
206:

Line 222: fnd_file.put_line(fnd_file.log,'Attribute is valid for start and end date, SR Type: '

218: and l_sr_attr.displayed_flag = 'Y') then
219:
220: -- End of changes for bug fix 3547950, by aneemuch 02-Apr-2004
221:
222: fnd_file.put_line(fnd_file.log,'Attribute is valid for start and end date, SR Type: '
223: || l_sr_attr.sr_type || ' Attribute : '|| l_sr_attr.sr_name
224: || ' And Display_Flag is set to YES ');
225:
226: l_template_question_list.mquestionname := l_sr_attr.sr_name;

Line 248: fnd_file.put_line(fnd_file.log,'Check if attribute already defined in CS table, SR Type: '

244: open c_template_attr_exists (l_tmpl_id, l_sr_attr.sr_name);
245: fetch c_template_attr_exists into l_tmpl_attr_exists;
246:
247: /* Check if the cursor fetched any records */
248: fnd_file.put_line(fnd_file.log,'Check if attribute already defined in CS table, SR Type: '
249: || l_sr_attr.sr_type || ' Attribute : '|| l_sr_attr.sr_name);
250:
251: if c_template_attr_exists%NOTFOUND then
252: fnd_file.put_line(fnd_file.log,'attribute not defined in CS table, SR Type: '

Line 252: fnd_file.put_line(fnd_file.log,'attribute not defined in CS table, SR Type: '

248: fnd_file.put_line(fnd_file.log,'Check if attribute already defined in CS table, SR Type: '
249: || l_sr_attr.sr_type || ' Attribute : '|| l_sr_attr.sr_name);
250:
251: if c_template_attr_exists%NOTFOUND then
252: fnd_file.put_line(fnd_file.log,'attribute not defined in CS table, SR Type: '
253: || l_sr_attr.sr_type || ' Attribute : '|| l_sr_attr.sr_name);
254:
255: -- Calling the create template question API to create new template question record
256: l_attr_update_flag := false;

Line 260: fnd_file.put_line(fnd_file.log,'Calling the Add_question API,SR Type: '

256: l_attr_update_flag := false;
257: l_template_question_list.mquestionid := NULL;
258: l_template_question_list.mlookupid := NULL;
259:
260: fnd_file.put_line(fnd_file.log,'Calling the Add_question API,SR Type: '
261: || l_sr_attr.sr_type || ' Attribute : '|| l_sr_attr.sr_name);
262: CS_TP_QUESTIONS_PVT.Add_Question
263: (
264: p_api_version_number => l_api_version,

Line 276: fnd_file.put_line(fnd_file.log,'Attribute defined in CS table, SR Type: '

272: x_question_id => l_tmpl_quest_id
273: );
274: else
275: -- Calling the update template question API to update template question record
276: fnd_file.put_line(fnd_file.log,'Attribute defined in CS table, SR Type: '
277: || l_sr_attr.sr_type || ' Attribute : '|| l_sr_attr.sr_name);
278: l_attr_update_flag := true;
279: l_tmpl_quest_id := l_tmpl_attr_exists.question_id;
280: l_template_question_list.mquestionid := l_tmpl_attr_exists.question_id;

Line 284: fnd_file.put_line(fnd_file.log,'Calling the Update_question API, SR Type: '

280: l_template_question_list.mquestionid := l_tmpl_attr_exists.question_id;
281: l_template_question_list.mlookupid := l_tmpl_attr_exists.lookup_id;
282: l_template_question_list.mlast_updated_date := to_char(l_sr_attr.last_update_date, 'MM/DD/YYYY/SSSSS');
283:
284: fnd_file.put_line(fnd_file.log,'Calling the Update_question API, SR Type: '
285: || l_sr_attr.sr_type || ' Attribute : '|| l_sr_attr.sr_name);
286:
287: CS_TP_QUESTIONS_PVT.Update_Question
288: (

Line 298: fnd_file.put_line(fnd_file.log,'Calling CS_TP_LOOKUPS_PKG.UPDATE_ROW API, SR Type: '

294: x_msg_data => x_msg_data,
295: x_return_status => x_return_status
296: );
297:
298: fnd_file.put_line(fnd_file.log,'Calling CS_TP_LOOKUPS_PKG.UPDATE_ROW API, SR Type: '
299: || l_sr_attr.sr_type || ' Attribute : '|| l_sr_attr.sr_name);
300:
301: CS_TP_LOOKUPS_PKG.UPDATE_ROW
302: (

Line 349: fnd_file.put_line(fnd_file.log,'Check if attribute is freetext or LOV, SR Type: '

345: and tq.question_id = q.question_id
346: and tq.template_id = l_tmpl_id
347: and q.question_id = l_tmpl_quest_id;
348:
349: fnd_file.put_line(fnd_file.log,'Check if attribute is freetext or LOV, SR Type: '
350: || l_sr_attr.sr_type || ' Attribute : '|| l_sr_attr.sr_name ||l_sr_attr.sr_attr_list_name);
351:
352: /* Check for if the Attribute has LOV for answer */
353: if l_sr_attr.sr_attr_list_name is NULL then

Line 354: fnd_file.put_line(fnd_file.log, 'attribute is a FREETEXT');

350: || l_sr_attr.sr_type || ' Attribute : '|| l_sr_attr.sr_name ||l_sr_attr.sr_attr_list_name);
351:
352: /* Check for if the Attribute has LOV for answer */
353: if l_sr_attr.sr_attr_list_name is NULL then
354: fnd_file.put_line(fnd_file.log, 'attribute is a FREETEXT');
355: -- Means, attribute is a freetext attribute
356:
357: /* Check if the attribute was previously defined as LOV */
358: if l_attr_update_flag = TRUE then

Line 362: fnd_file.put_line(fnd_file.log,'Calling the delete Choice API, attribute is freetext and attribute is in updatemode, SR Type: '

358: if l_attr_update_flag = TRUE then
359: -- only to do this if the attribute is in update mode
360: -- Call the delete program to delete all the records from the cs_tp_choices_tl
361:
362: fnd_file.put_line(fnd_file.log,'Calling the delete Choice API, attribute is freetext and attribute is in updatemode, SR Type: '
363: || l_sr_attr.sr_type || ' Attribute : '|| l_sr_attr.sr_name);
364: open c_tp_choice (l_tmpl_quest_lookup_id);
365: fetch c_tp_choice into l_tp_choice;
366: while (c_tp_choice%FOUND) loop

Line 388: fnd_file.put_line(fnd_file.log,'Calling the Add_Freetext API, SR Type: '

384: l_template_question_freetext.mfreetextdefaulttext := NULL;
385: l_template_question_freetext.mlookupid :=l_tmpl_quest_lookup_id;
386: l_template_question_freetext.mlast_updated_date:= l_sr_attr.last_update_date;
387:
388: fnd_file.put_line(fnd_file.log,'Calling the Add_Freetext API, SR Type: '
389: || l_sr_attr.sr_type || ' Attribute : '|| l_sr_attr.sr_name);
390: CS_TP_CHOICES_PVT.ADD_FREETEXT
391: (
392: p_api_version_number => l_api_version,

Line 403: fnd_file.put_line(fnd_file.log, 'attribute is a LOV');

399: x_freetext_id => l_tmpl_quest_freetext_id
400: );
401: else
402: -- Means, attribute is defined as a LOV column
403: fnd_file.put_line(fnd_file.log, 'attribute is a LOV');
404: if l_attr_update_flag = TRUE then
405: -- only to do this if the attribute is in update mode
406: -- Call the delete program to delete all the records from the cs_tp_choices_tl
407: fnd_file.put_line(fnd_file.log,'Calling the delete Choice API, attribute is in update mode, SR Type: '

Line 407: fnd_file.put_line(fnd_file.log,'Calling the delete Choice API, attribute is in update mode, SR Type: '

403: fnd_file.put_line(fnd_file.log, 'attribute is a LOV');
404: if l_attr_update_flag = TRUE then
405: -- only to do this if the attribute is in update mode
406: -- Call the delete program to delete all the records from the cs_tp_choices_tl
407: fnd_file.put_line(fnd_file.log,'Calling the delete Choice API, attribute is in update mode, SR Type: '
408: || l_sr_attr.sr_type || ' Attribute : '|| l_sr_attr.sr_name);
409:
410: open c_tp_choice (l_tmpl_quest_lookup_id);
411: fetch c_tp_choice into l_tp_choice;

Line 428: fnd_file.put_line(fnd_file.log,'Calling the delete Free_Text API incase attribute was defined as freetext before, attribute is in update mode, SR Type: '

424: end loop;
425: close c_tp_choice;
426:
427: -- Also, call delete FreeText API to delete record from freetext table if previously defined as freetext
428: fnd_file.put_line(fnd_file.log,'Calling the delete Free_Text API incase attribute was defined as freetext before, attribute is in update mode, SR Type: '
429: || l_sr_attr.sr_type || ' Attribute : '|| l_sr_attr.sr_name);
430: open c_tp_freetext (l_tmpl_quest_lookup_id);
431: fetch c_tp_freetext into l_tp_freetext;
432: while (c_tp_freetext%FOUND) loop

Line 451: fnd_file.put_line(fnd_file.log,'Calling the Add_Choice API, SR Type: ' || l_sr_attr.sr_type ||

447: l_template_question_choice.mlookupid := l_tmpl_quest_lookup_id;
448: l_template_question_choice.mscore := 0;
449: l_template_question_choice.mlast_updated_date := l_tmpl_choice_lookup.last_update_date;
450:
451: fnd_file.put_line(fnd_file.log,'Calling the Add_Choice API, SR Type: ' || l_sr_attr.sr_type ||
452: ' Attribute : '|| l_sr_attr.sr_name || ' Choice : ' ||l_tmpl_choice_lookup.meaning ||'- DESC:'||l_tmpl_choice_lookup.description);
453: CS_TP_CHOICES_PVT.ADD_CHOICE
454: (
455: p_api_version_number => l_api_version,

Line 479: /* fnd_file.put_line(fnd_file.log,'SR Type: ' || l_sr_attr.sr_type ||

475: -- Current API's of iSupport does not support end_date update
476:
477: -- Start of changed for bug fix 3547950, by aneemuch
478:
479: /* fnd_file.put_line(fnd_file.log,'SR Type: ' || l_sr_attr.sr_type ||
480: ' StartDate : ' || l_sr_attr.start_date_active ||
481: ' EndDateActive : ' || l_sr_attr.end_date_active ||
482: ' DisplayedFlag : ' || l_sr_attr.displayed_flag);
483: */

Line 485: fnd_file.put_line(fnd_file.log,'SR Type: ' || l_sr_attr.sr_type ||

481: ' EndDateActive : ' || l_sr_attr.end_date_active ||
482: ' DisplayedFlag : ' || l_sr_attr.displayed_flag);
483: */
484:
485: fnd_file.put_line(fnd_file.log,'SR Type: ' || l_sr_attr.sr_type ||
486: ' StartDate : ' || l_sr_attr.start_date_active ||
487: ' EndDateActive : ' || l_sr_attr.end_date_active ||
488: ' DisplayedFlag : ' || l_sr_attr.displayed_flag ||
489: ' LkupStartDate: '|| l_sr_attr.lkup_start_Date||

Line 499: fnd_file.put_line(fnd_file.log,'Calling Delete Question API for attribute is enddated, SR Type: ' || l_sr_attr.sr_type);

495: fetch c_template_attr_exists into l_tmpl_attr_exists;
496:
497: /* Check if the cursor fetched any records */
498: if c_template_attr_exists%FOUND then
499: fnd_file.put_line(fnd_file.log,'Calling Delete Question API for attribute is enddated, SR Type: ' || l_sr_attr.sr_type);
500: cs_tp_questions_pvt.Delete_Question
501: (
502: p_api_version_number => l_api_version,
503: p_init_msg_list => l_init_msg_list_true,

Line 516: fnd_file.put_line(fnd_file.log, '-------------------- End of Current Record processing ---------------------');

512: close c_template_attr_exists;
513: END IF;
514: COMMIT WORK;
515:
516: fnd_file.put_line(fnd_file.log, '***-------------------- End of Current Record processing ---------------------***');
517: FETCH c_sr_attr INTO l_sr_attr;
518:
519: end loop; --for;
520: retcode := 0;

Line 531: fnd_file.put_line(fnd_file.log,'others '||sqlerrm||to_char(sqlcode));

527:
528: WHEN OTHERS THEN
529: Errbuf := fnd_message.get||' '||SQLERRM;
530: Retcode := 2;
531: fnd_file.put_line(fnd_file.log,'others '||sqlerrm||to_char(sqlcode));
532:
533: END CREATE_ATTR_TEMPLATE;
534:
535:

Line 616: fnd_file.put_line(fnd_file.log,'Start of program');

612: l_templ_question_list cs_tp_choices_pvt.choice;
613:
614: BEGIN
615:
616: fnd_file.put_line(fnd_file.log,'Start of program');
617: OPEN c_cug_sr_attr_ListName (P_lookup_type);
618: fetch c_cug_sr_attr_ListName into l_cug_sr_attr_ListName;
619: WHILE (c_cug_sr_attr_ListName%FOUND) LOOP
620:

Line 621: fnd_file.put_line(fnd_file.log,'Attribute Name : ' || l_cug_sr_attr_ListName.sr_name ||

617: OPEN c_cug_sr_attr_ListName (P_lookup_type);
618: fetch c_cug_sr_attr_ListName into l_cug_sr_attr_ListName;
619: WHILE (c_cug_sr_attr_ListName%FOUND) LOOP
620:
621: fnd_file.put_line(fnd_file.log,'Attribute Name : ' || l_cug_sr_attr_ListName.sr_name ||
622: ' LOV Name : ' || l_cug_sr_attr_ListName.list_name);
623:
624: /* open cursor for choices table and call delete api to delete existing record */
625: OPEN c_tp_question (l_cug_sr_attr_ListName.sr_name, l_cug_sr_attr_ListName.tmpl_name);

Line 634: fnd_file.put_line(fnd_file.log,'Delete Choice before re-creating, '

630: -- call delete choice api to delete records first
631: OPEN c_tp_choice (l_lookup_id);
632: Fetch c_tp_choice into l_tp_choice;
633:
634: fnd_file.put_line(fnd_file.log,'Delete Choice before re-creating, '
635: || 'SR Type : ' || l_cug_sr_attr_ListName.tmpl_name
636: || 'Attribute Name : '
637: || l_cug_sr_attr_ListName.sr_name || ' LOV Name : '
638: || l_cug_sr_attr_ListName.list_name);

Line 641: -- fnd_file.put_line(fnd_file.log,'Delete Choice before re-creating, '

637: || l_cug_sr_attr_ListName.sr_name || ' LOV Name : '
638: || l_cug_sr_attr_ListName.list_name);
639:
640: while (c_tp_choice%FOUND) loop
641: -- fnd_file.put_line(fnd_file.log,'Delete Choice before re-creating, '
642: -- ||'SR Type : ' || l_cug_sr_attr_ListName.tmpl_name
643: -- ||' Attribute Name : ' || l_cug_sr_attr_ListName.sr_name || ' LOV Name : '
644: -- || l_cug_sr_attr_ListName.list_name
645: -- || ' ChoiceID : ' || l_tp_choice.value);

Line 666: fnd_file.put_line(fnd_file.log,'Re-creating choices, SR Type : ' ||

662: /* open the fnd_lookup cursor to re-create choices */
663: OPEN c_fnd_lookup (p_lookup_type);
664: FETCH c_fnd_lookup into l_fnd_lookup;
665:
666: fnd_file.put_line(fnd_file.log,'Re-creating choices, SR Type : ' ||
667: l_cug_sr_attr_ListName.tmpl_name || ' Attribute Name : ' ||
668: l_cug_sr_attr_ListName.sr_name || ' LOV Name : ' || l_cug_sr_attr_ListName.list_name);
669:
670: while (c_fnd_lookup%FOUND) loop

Line 678: -- fnd_file.put_line(fnd_file.log,'Re-creating choices, Attribute Name : ' ||

674: l_templ_question_list.mscore := 0;
675: l_templ_question_list.mlast_updated_date := l_fnd_lookup.last_update_date;
676: l_templ_question_list.mdefaultchoiceflag := FND_API.G_FALSE;
677:
678: -- fnd_file.put_line(fnd_file.log,'Re-creating choices, Attribute Name : ' ||
679: -- l_cug_sr_attr_ListName.sr_name || ' LOV Name : ' || l_cug_sr_attr_ListName.list_name
680: -- || ' ChoiceName : ' || l_fnd_lookup.description);
681:
682: CS_TP_CHOICES_PVT.ADD_CHOICE

Line 712: fnd_file.put_line(fnd_file.log,'others '||sqlerrm||to_char(sqlcode));

708: EXCEPTION
709: WHEN OTHERS THEN
710: Errbuf := fnd_message.get||' '||SQLERRM;
711: Retcode := 2;
712: fnd_file.put_line(fnd_file.log,'others '||sqlerrm||to_char(sqlcode));
713:
714: END Update_Attr_ListName;
715:
716: END CUG_SR_ATTRIBUTE_INTF;