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

Line 130: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Entering:' || l_proc);

126: language_code = p_language_code;
127:
128:
129: begin
130: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Entering:' || l_proc);
131:
132:
133: if p_update is null then -- if not only update
134:

Line 147: FND_FILE.PUT_LINE(FND_FILE.LOG,'No Activity_Id found corresponding to - ' ||

143: open cur_get_activity_id;
144: fetch cur_get_activity_id into l_activity_id;
145: if cur_get_activity_id%NOTFOUND then --if activity_id
146: close cur_get_activity_id;
147: FND_FILE.PUT_LINE(FND_FILE.LOG,'No Activity_Id found corresponding to - ' ||
148: p_activity_definition_name);
149: p_message := 'No Activity_Id found corresponding to ';
150: -- dbms_output.put_line(p_message);
151: p_activity_version_id := NULL;

Line 162: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application did not create an Activity version for the RCO ' ||

158: open cur_get_language_id;
159: fetch cur_get_language_id into p_language_id;
160: if cur_get_language_id%NOTFOUND then --if language_id
161: close cur_get_language_id;
162: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application did not create an Activity version for the RCO ' ||
163: p_activity_version_name || ' because the Language code '|| p_language_code || ' does not exist. Please return to OiL and correct the Language Name in the RCO.');
164: p_message := 'No language found corresponding to ';
165: -- dbms_output.put_line(p_message);
166: p_activity_version_id := NULL;

Line 179: FND_FILE.PUT_LINE(FND_FILE.LOG,'The Activity Version Name ' || p_activity_version_name|| ' already exists. You must rename all but one RCO of that name.');

175: fetch cur_get_activity_version_name into l_activity_version_name;
176:
177: if cur_get_activity_version_name%FOUND then --if activity_version_id
178: close cur_get_activity_version_name;
179: FND_FILE.PUT_LINE(FND_FILE.LOG,'The Activity Version Name ' || p_activity_version_name|| ' already exists. You must rename all but one RCO of that name.');
180: p_message := 'Activity_version_name already exist ';
181: -- dbms_output.put_line(p_message);
182: p_activity_version_id := NULL;
183: -- p_status := 'F';

Line 193: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Insert Activity with rco_id - '|| p_rco_id);

189:
190: /* for Bug 2201416 Added Trunc when selecting sysdate */
191: select trunc(sysdate) into l_sysdate from dual;
192:
193: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Insert Activity with rco_id - '|| p_rco_id);
194: -- Create activity_version
195:
196: BEGIN
197: -- clear message before calling API

Line 227: FND_FILE.PUT_LINE(FND_FILE.LOG,'The RCO ' || p_activity_version_name||' cannot be transferred into iLearning 11i. You must launch iLearning 11i and create the new course there. ');

223: ,P_intended_audience => p_audience
224: ,P_objectives => p_objectives
225: );
226: */
227: FND_FILE.PUT_LINE(FND_FILE.LOG,'The RCO ' || p_activity_version_name||' cannot be transferred into iLearning 11i. You must launch iLearning 11i and create the new course there. ');
228: -- dbms_output.put_line(p_message);
229: -- p_activity_version_id := l_activity_version_id;
230: p_status := 'S';
231: return;

Line 235: fND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not create an Activity Version for RCO '||

231: return;
232: /* change for eBS
233: EXCEPTION
234: when others then
235: fND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not create an Activity Version for RCO '||
236: p_activity_version_name || '. Reason:' || hr_utility.get_message);
237: p_message := 'Error in creating Activity_version found corresponding to ';
238: -- dbms_output.put_line(p_message);
239: p_activity_version_id := NULL;

Line 255: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application did not create Activity version for RCO ' ||

251: open cur_get_language_id;
252: fetch cur_get_language_id into l2_language_id;
253: if cur_get_language_id%NOTFOUND then --if language_id
254: close cur_get_language_id;
255: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application did not create Activity version for RCO ' ||
256: p_activity_version_name || ' because the Language code '|| p_language_code || ' does not exist. Please return to OiL and correct the Language Name in the RCO.');
257: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'No language_id found corresponding to - ' ||
258: -- p_language_code);
259: p_message := 'No language found corresponding to ';

Line 257: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'No language_id found corresponding to - ' ||

253: if cur_get_language_id%NOTFOUND then --if language_id
254: close cur_get_language_id;
255: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application did not create Activity version for RCO ' ||
256: p_activity_version_name || ' because the Language code '|| p_language_code || ' does not exist. Please return to OiL and correct the Language Name in the RCO.');
257: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'No language_id found corresponding to - ' ||
258: -- p_language_code);
259: p_message := 'No language found corresponding to ';
260: -- dbms_output.put_line(p_message);
261: p_activity_version_id := NULL;

Line 297: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successfully updated the Activity Version for RCO ' ||

293: ,P_description => p_description
294: ,P_intended_audience => p_audience
295: ,P_objectives => p_objectives
296: );
297: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successfully updated the Activity Version for RCO ' ||
298: p_activity_version_name||'.');
299: p_message := 'updated successfully ';
300: -- dbms_output.put_line(p_message);
301: p_activity_version_id := l_activity_version_id;

Line 305: fND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not update the Activity Version for RCO '||

301: p_activity_version_id := l_activity_version_id;
302:
303: EXCEPTION
304: when others then
305: fND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not update the Activity Version for RCO '||
306: p_activity_version_name || '. Reason:' || hr_utility.get_message);
307: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:In updating Activity version for rco_id - ' ||
308: -- p_rco_id || '. REASON:' || hr_utility.get_message);
309: p_message := 'updated successfully ';

Line 307: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:In updating Activity version for rco_id - ' ||

303: EXCEPTION
304: when others then
305: fND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not update the Activity Version for RCO '||
306: p_activity_version_name || '. Reason:' || hr_utility.get_message);
307: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:In updating Activity version for rco_id - ' ||
308: -- p_rco_id || '. REASON:' || hr_utility.get_message);
309: p_message := 'updated successfully ';
310: -- dbms_output.put_line(p_message);
311: -- p_status := 'F';

Line 337: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successfully updated the Language ID for Event ID '|| cur_evt.event_id ||

333: ,P_VALIDATE => false -- (Input)
334: );
335:
336:
337: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successfully updated the Language ID for Event ID '|| cur_evt.event_id ||
338: '.');
339: p_message := 'Event updated successfully.Event id is -'||cur_evt.event_id||
340: ' for Language id - '||l2_language_id;
341: -- dbms_output.put_line(p_message);

Line 344: fND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not update the language ID for Event ID '||

340: ' for Language id - '||l2_language_id;
341: -- dbms_output.put_line(p_message);
342: EXCEPTION
343: when others then
344: fND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not update the language ID for Event ID '||
345: cur_evt.event_id || '. Reason:' || hr_utility.get_message);
346: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:In updating Event.Event id is - '|| cur_evt.event_id ||
347: -- ' for Language id - ' || l2_language_id || '. REASON:' || hr_utility.get_message);
348: p_message := 'ERROR:In updating Event.Event id is -'||cur_evt.event_id||

Line 346: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:In updating Event.Event id is - '|| cur_evt.event_id ||

342: EXCEPTION
343: when others then
344: fND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not update the language ID for Event ID '||
345: cur_evt.event_id || '. Reason:' || hr_utility.get_message);
346: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:In updating Event.Event id is - '|| cur_evt.event_id ||
347: -- ' for Language id - ' || l2_language_id || '. REASON:' || hr_utility.get_message);
348: p_message := 'ERROR:In updating Event.Event id is -'||cur_evt.event_id||
349: ' for Language id - '||l2_language_id;
350: -- dbms_output.put_line(p_message);

Line 375: FND_FILE.PUT_LINE(FND_FILE.LOG,'The RCO ' || p_activity_version_name || ' update failed because no activity version exists. Please return to OiL and update any Offering of this RCO.');

371: fetch cur_get_activity_version_id into l_activity_version_id,p_language_id,l_object_version_number;
372:
373: if cur_get_activity_version_id%NOTFOUND then --if activity_version_id
374: close cur_get_activity_version_id;
375: FND_FILE.PUT_LINE(FND_FILE.LOG,'The RCO ' || p_activity_version_name || ' update failed because no activity version exists. Please return to OiL and update any Offering of this RCO.');
376: p_message := 'ERROR:no activity_version_id found for update corresponding to Rco_Id - '|| p_rco_id;
377: -- dbms_output.put_line(p_message);
378: p_activity_version_id := NULL;
379: -- p_status := 'F';

Line 389: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application did not update the Activity version for the RCO '||

385: open cur_get_language_id;
386: fetch cur_get_language_id into l2_language_id;
387: if cur_get_language_id%NOTFOUND then --if language_id
388: close cur_get_language_id;
389: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application did not update the Activity version for the RCO '||
390: p_activity_version_name || ' because the Language code '|| p_language_code || ' does not exist. Please return to OiL and correct the Language Name in the RCO.');
391: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:No language_id found corresponding to - ' ||
392: -- p_language_code);
393: p_message := 'ERROR:No language found corresponding to - '|| p_language_code;

Line 391: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:No language_id found corresponding to - ' ||

387: if cur_get_language_id%NOTFOUND then --if language_id
388: close cur_get_language_id;
389: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application did not update the Activity version for the RCO '||
390: p_activity_version_name || ' because the Language code '|| p_language_code || ' does not exist. Please return to OiL and correct the Language Name in the RCO.');
391: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:No language_id found corresponding to - ' ||
392: -- p_language_code);
393: p_message := 'ERROR:No language found corresponding to - '|| p_language_code;
394: -- dbms_output.put_line(p_message);
395: p_activity_version_id := NULL;

Line 432: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successfully updated the Activity Version for RCO ' ||

428: ,P_intended_audience => p_audience
429: ,P_objectives => p_objectives
430: );
431:
432: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successfully updated the Activity Version for RCO ' ||
433: p_activity_version_name || '.');
434: p_message := 'updated successfully ';
435: -- dbms_output.put_line(p_message);
436: p_activity_version_id := l_activity_version_id;

Line 440: fND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not update the Activity Version for RCO '||

436: p_activity_version_id := l_activity_version_id;
437:
438: EXCEPTION
439: when others then
440: fND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not update the Activity Version for RCO '||
441: p_activity_version_name || '. Reason:' || hr_utility.get_message);
442: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:In updating Activity version for rco_id - ' ||
443: -- p_rco_id || '.REASON:' || hr_utility.get_message);
444: p_message := 'ERROR:In updating Activity version for rco_id - ' || p_rco_id;

Line 442: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:In updating Activity version for rco_id - ' ||

438: EXCEPTION
439: when others then
440: fND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not update the Activity Version for RCO '||
441: p_activity_version_name || '. Reason:' || hr_utility.get_message);
442: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:In updating Activity version for rco_id - ' ||
443: -- p_rco_id || '.REASON:' || hr_utility.get_message);
444: p_message := 'ERROR:In updating Activity version for rco_id - ' || p_rco_id;
445: -- dbms_output.put_line(p_message);
446: -- p_status := 'F';

Line 470: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successfully updated the Language ID for Event ID '|| cur_evt.event_id || '.');

466: ,P_OBJECT_VERSION_NUMBER => cur_evt.object_version_number -- (Output)
467: ,P_VALIDATE => false -- (Input)
468: );
469:
470: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successfully updated the Language ID for Event ID '|| cur_evt.event_id || '.');
471: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Successfully updated .Event id is - '|| cur_evt.event_id ||
472: -- ' for Language id - ' || l2_language_id);
473: p_message := 'Event updated successfully.Event id is -'||cur_evt.event_id||
474: ' for Language id - '||l2_language_id;

Line 471: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Successfully updated .Event id is - '|| cur_evt.event_id ||

467: ,P_VALIDATE => false -- (Input)
468: );
469:
470: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successfully updated the Language ID for Event ID '|| cur_evt.event_id || '.');
471: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Successfully updated .Event id is - '|| cur_evt.event_id ||
472: -- ' for Language id - ' || l2_language_id);
473: p_message := 'Event updated successfully.Event id is -'||cur_evt.event_id||
474: ' for Language id - '||l2_language_id;
475: -- dbms_output.put_line(p_message);

Line 478: fND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not update the language ID for Event ID '||

474: ' for Language id - '||l2_language_id;
475: -- dbms_output.put_line(p_message);
476: EXCEPTION
477: when others then
478: fND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not update the language ID for Event ID '||
479: cur_evt.event_id || '. Reason:' || hr_utility.get_message);
480: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:In updating Event.Event id is - '|| cur_evt.event_id ||
481: -- ' for Language id - ' || l2_language_id || '. REASON:' || hr_utility.get_message);
482: p_message := 'ERROR:In updating Event.Event id is -'||cur_evt.event_id||

Line 480: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:In updating Event.Event id is - '|| cur_evt.event_id ||

476: EXCEPTION
477: when others then
478: fND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not update the language ID for Event ID '||
479: cur_evt.event_id || '. Reason:' || hr_utility.get_message);
480: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:In updating Event.Event id is - '|| cur_evt.event_id ||
481: -- ' for Language id - ' || l2_language_id || '. REASON:' || hr_utility.get_message);
482: p_message := 'ERROR:In updating Event.Event id is -'||cur_evt.event_id||
483: ' for Language id - '||l2_language_id;
484: -- dbms_output.put_line(p_message);

Line 506: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR: No Language Id Found ');

502:
503: exception
504: when no_language_id_found then
505: null;
506: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR: No Language Id Found ');
507:
508: when others then
509:
510: FND_FILE.PUT_LINE(FND_FILE.LOG,'An error occurred while processing RCO '||

Line 510: FND_FILE.PUT_LINE(FND_FILE.LOG,'An error occurred while processing RCO '||

506: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR: No Language Id Found ');
507:
508: when others then
509:
510: FND_FILE.PUT_LINE(FND_FILE.LOG,'An error occurred while processing RCO '||
511: p_activity_version_name ||'. SQLERRM:'|| SQLERRM);
512: p_message := 'ERROR:In when others exception for Rco_Id - ' || p_rco_id;
513: -- dbms_output.put_line(p_message);
514: p_activity_version_id := NULL;

Line 701: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Entering:' || l_proc);

697: where title = p_offering_title and
698: business_group_id = p_business_group_id;
699:
700: begin
701: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Entering:' || l_proc);
702:
703:
704: IF p_offering_type <> 'C' then --if not INCLASS EVENT
705:

Line 723: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application did not create or update the Event for the Offering '||

719: close cur_get_date_time;
720: end if; --if offering end date is null
721:
722: if p_offering_start_date is NULL then --if offering start date is null
723: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application did not create or update the Event for the Offering '||
724: p_offering_title || '. You must return to OiL and enter a Start Date for the Offering.');
725: p_message := 'ERROR:Offering start date is null for offering id - '|| p_offering_id;
726: -- dbms_output.put_line(p_message);
727: -- p_status := 'F';

Line 752: FND_FILE.PUT_LINE(FND_FILE.LOG,'The Enrollment Start Date must be earlier than the Offering Start Date. Please return to OiL and correct the Enrollment Start Date for the Offering '||

748: end if; --if enrollment start date is null
749:
750:
751: if trunc(l_enrollment_start_date) > trunc(l_course_start_date) then
752: FND_FILE.PUT_LINE(FND_FILE.LOG,'The Enrollment Start Date must be earlier than the Offering Start Date. Please return to OiL and correct the Enrollment Start Date for the Offering '||
753: p_offering_title ||'.');
754: p_status := 'W';
755: return;
756: end if;

Line 773: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not create an Event for Offering '|| p_offering_title ||

769: if cur_get_event_id%NOTFOUND then -- if event does not exist
770: close cur_get_event_id;
771:
772: if p_offering_ispublished = 'N' then --if offering is unpublished and event does not exist
773: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not create an Event for Offering '|| p_offering_title ||
774: ', because the Offering is Unpublished.');
775: p_message := 'Concurrent program will not process offering id - ' || p_offering_id ||
776: ', Because Event id does not exist and Offering is Unpublished.';
777: -- dbms_output.put_line(p_message);

Line 788: FND_FILE.PUT_LINE(FND_FILE.LOG,'The Event Title ' || p_offering_title

784: fetch cur_get_event_title into l_event_title;
785:
786: if cur_get_event_title%FOUND then
787: close cur_get_event_title;
788: FND_FILE.PUT_LINE(FND_FILE.LOG,'The Event Title ' || p_offering_title
789: || ' already exists. You must rename all but one Offering of that name.');
790: p_message := 'Event Title already exist ';
791: -- dbms_output.put_line(p_message);
792: -- p_status := 'F';

Line 856: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successfully created the Delivery Method for Category ' || l_category||'.');

852: ,p_language_code =>USERENV('LANG')
853: ,p_category_usage_id =>l_category_usage_id
854: ,p_category => l_category);
855:
856: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successfully created the Delivery Method for Category ' || l_category||'.');
857: p_message := 'Category usage id - ' || l_category_usage_id || ' created successfully.';
858: -- dbms_output.put_line(p_message);
859:
860: EXCEPTION

Line 863: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not create the Delivery Method for Category ' || l_category

859:
860: EXCEPTION
861: when others then
862:
863: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not create the Delivery Method for Category ' || l_category
864: || '. Reason:' || hr_utility.get_message);
865:
866: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:Unable to create category usage for category - '||
867: -- l_category || '. REASON:' || hr_utility.get_message);

Line 866: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:Unable to create category usage for category - '||

862:
863: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not create the Delivery Method for Category ' || l_category
864: || '. Reason:' || hr_utility.get_message);
865:
866: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:Unable to create category usage for category - '||
867: -- l_category || '. REASON:' || hr_utility.get_message);
868: p_message := 'ERROR:Unable to create category usage for category - '|| l_category;
869: -- dbms_output.put_line(p_message);
870: -- p_status := 'F';

Line 920: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successfully included Delivery Method in Activity Version ID '||

916: ,p_category_usage_id => l_category_usage_id -- (Input)
917: ,p_effective_date => trunc(sysdate) -- (Input)
918: );
919:
920: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successfully included Delivery Method in Activity Version ID '||
921: p_activity_version_id ||'.');
922: p_message := 'Successfully created category inclusion for category usage id - '|| l_category_usage_id;
923: -- dbms_output.put_line(p_message);
924:

Line 927: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not include Delivery Method in Activity Version ID '||

923: -- dbms_output.put_line(p_message);
924:
925: EXCEPTION
926: when others then
927: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not include Delivery Method in Activity Version ID '||
928: p_activity_version_id || '. Reason:' || hr_utility.get_message);
929: p_message := 'ERROR:Unable to create category inclusion for category usage id - '|| l_category_usage_id;
930: -- dbms_output.put_line(p_message);
931: -- dbms_output.put_line('p_activity_version_id - ' || p_activity_version_id);

Line 964: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not update Activity Start Date for Activity Version ID '||

960: );
961:
962: EXCEPTION
963: when others then
964: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not update Activity Start Date for Activity Version ID '||
965: p_activity_version_id || '. REASON:' || hr_utility.get_message);
966: p_message := 'ERROR:Unable to update Activity start date for activity_version_id - '||
967: p_activity_version_id || ' And offering Id - ' ||p_offering_id;
968: -- dbms_output.put_line(p_message);

Line 1024: FND_FILE.PUT_LINE(FND_FILE.LOG,'The offering '|| p_offering_title || ' cannot be transferred into iLearning 11i. You must launch iLearning 11i and create the new class there. ');

1020: ,p_title => p_offering_title
1021: );
1022:
1023: */
1024: FND_FILE.PUT_LINE(FND_FILE.LOG,'The offering '|| p_offering_title || ' cannot be transferred into iLearning 11i. You must launch iLearning 11i and create the new class there. ');
1025: -- p_message := 'Event created successfully.Event id is -'||l_event_id||' for Offering id - '||p_offering_id;
1026: -- dbms_output.put_line(p_message);
1027: p_status := 'S';
1028: return;

Line 1032: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not create an Event for the Offering '|| p_offering_title

1028: return;
1029: /*
1030: EXCEPTION
1031: when others then
1032: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not create an Event for the Offering '|| p_offering_title
1033: || '. Reason:' || hr_utility.get_message);
1034: p_message := 'ERROR:Unable to create Event for Offering id - '||p_offering_id;
1035:
1036: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_event_id -' || l_event_id);

Line 1036: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_event_id -' || l_event_id);

1032: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not create an Event for the Offering '|| p_offering_title
1033: || '. Reason:' || hr_utility.get_message);
1034: p_message := 'ERROR:Unable to create Event for Offering id - '||p_offering_id;
1035:
1036: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_event_id -' || l_event_id);
1037: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_business_group_id - ' || p_business_group_id);
1038: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_event_type - ' || l_event_type);
1039: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_event_ovn - ' || l_event_ovn);
1040: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_offering_title - ' || p_offering_title);

Line 1037: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_business_group_id - ' || p_business_group_id);

1033: || '. Reason:' || hr_utility.get_message);
1034: p_message := 'ERROR:Unable to create Event for Offering id - '||p_offering_id;
1035:
1036: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_event_id -' || l_event_id);
1037: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_business_group_id - ' || p_business_group_id);
1038: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_event_type - ' || l_event_type);
1039: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_event_ovn - ' || l_event_ovn);
1040: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_offering_title - ' || p_offering_title);
1041: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_language_id - ' || p_language_id);

Line 1038: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_event_type - ' || l_event_type);

1034: p_message := 'ERROR:Unable to create Event for Offering id - '||p_offering_id;
1035:
1036: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_event_id -' || l_event_id);
1037: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_business_group_id - ' || p_business_group_id);
1038: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_event_type - ' || l_event_type);
1039: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_event_ovn - ' || l_event_ovn);
1040: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_offering_title - ' || p_offering_title);
1041: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_language_id - ' || p_language_id);
1042: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_activity_version_id - ' || p_activity_version_id);

Line 1039: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_event_ovn - ' || l_event_ovn);

1035:
1036: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_event_id -' || l_event_id);
1037: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_business_group_id - ' || p_business_group_id);
1038: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_event_type - ' || l_event_type);
1039: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_event_ovn - ' || l_event_ovn);
1040: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_offering_title - ' || p_offering_title);
1041: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_language_id - ' || p_language_id);
1042: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_activity_version_id - ' || p_activity_version_id);
1043: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_course_start_date - ' || l_course_start_date);

Line 1040: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_offering_title - ' || p_offering_title);

1036: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_event_id -' || l_event_id);
1037: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_business_group_id - ' || p_business_group_id);
1038: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_event_type - ' || l_event_type);
1039: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_event_ovn - ' || l_event_ovn);
1040: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_offering_title - ' || p_offering_title);
1041: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_language_id - ' || p_language_id);
1042: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_activity_version_id - ' || p_activity_version_id);
1043: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_course_start_date - ' || l_course_start_date);
1044: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_course_end_date - ' || l_course_end_date);

Line 1041: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_language_id - ' || p_language_id);

1037: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_business_group_id - ' || p_business_group_id);
1038: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_event_type - ' || l_event_type);
1039: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_event_ovn - ' || l_event_ovn);
1040: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_offering_title - ' || p_offering_title);
1041: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_language_id - ' || p_language_id);
1042: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_activity_version_id - ' || p_activity_version_id);
1043: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_course_start_date - ' || l_course_start_date);
1044: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_course_end_date - ' || l_course_end_date);
1045: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_course_start_time - ' || l_course_start_time);

Line 1042: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_activity_version_id - ' || p_activity_version_id);

1038: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_event_type - ' || l_event_type);
1039: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_event_ovn - ' || l_event_ovn);
1040: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_offering_title - ' || p_offering_title);
1041: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_language_id - ' || p_language_id);
1042: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_activity_version_id - ' || p_activity_version_id);
1043: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_course_start_date - ' || l_course_start_date);
1044: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_course_end_date - ' || l_course_end_date);
1045: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_course_start_time - ' || l_course_start_time);
1046: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_course_end_time - ' || l_course_end_time);

Line 1043: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_course_start_date - ' || l_course_start_date);

1039: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_event_ovn - ' || l_event_ovn);
1040: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_offering_title - ' || p_offering_title);
1041: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_language_id - ' || p_language_id);
1042: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_activity_version_id - ' || p_activity_version_id);
1043: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_course_start_date - ' || l_course_start_date);
1044: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_course_end_date - ' || l_course_end_date);
1045: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_course_start_time - ' || l_course_start_time);
1046: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_course_end_time - ' || l_course_end_time);
1047: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_enrollment_start_date - ' || l_enrollment_start_date);

Line 1044: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_course_end_date - ' || l_course_end_date);

1040: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_offering_title - ' || p_offering_title);
1041: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_language_id - ' || p_language_id);
1042: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_activity_version_id - ' || p_activity_version_id);
1043: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_course_start_date - ' || l_course_start_date);
1044: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_course_end_date - ' || l_course_end_date);
1045: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_course_start_time - ' || l_course_start_time);
1046: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_course_end_time - ' || l_course_end_time);
1047: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_enrollment_start_date - ' || l_enrollment_start_date);
1048: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_enrollment_end_date - ' || l_enrollment_end_date);

Line 1045: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_course_start_time - ' || l_course_start_time);

1041: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_language_id - ' || p_language_id);
1042: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_activity_version_id - ' || p_activity_version_id);
1043: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_course_start_date - ' || l_course_start_date);
1044: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_course_end_date - ' || l_course_end_date);
1045: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_course_start_time - ' || l_course_start_time);
1046: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_course_end_time - ' || l_course_end_time);
1047: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_enrollment_start_date - ' || l_enrollment_start_date);
1048: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_enrollment_end_date - ' || l_enrollment_end_date);
1049: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_offering_max_attendees - ' || p_offering_max_attendees);

Line 1046: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_course_end_time - ' || l_course_end_time);

1042: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_activity_version_id - ' || p_activity_version_id);
1043: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_course_start_date - ' || l_course_start_date);
1044: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_course_end_date - ' || l_course_end_date);
1045: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_course_start_time - ' || l_course_start_time);
1046: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_course_end_time - ' || l_course_end_time);
1047: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_enrollment_start_date - ' || l_enrollment_start_date);
1048: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_enrollment_end_date - ' || l_enrollment_end_date);
1049: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_offering_max_attendees - ' || p_offering_max_attendees);
1050: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_default_event_owner_id - ' || l_default_event_owner_id);

Line 1047: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_enrollment_start_date - ' || l_enrollment_start_date);

1043: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_course_start_date - ' || l_course_start_date);
1044: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_course_end_date - ' || l_course_end_date);
1045: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_course_start_time - ' || l_course_start_time);
1046: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_course_end_time - ' || l_course_end_time);
1047: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_enrollment_start_date - ' || l_enrollment_start_date);
1048: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_enrollment_end_date - ' || l_enrollment_end_date);
1049: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_offering_max_attendees - ' || p_offering_max_attendees);
1050: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_default_event_owner_id - ' || l_default_event_owner_id);
1051: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_offering_id - ' || p_offering_id);

Line 1048: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_enrollment_end_date - ' || l_enrollment_end_date);

1044: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_course_end_date - ' || l_course_end_date);
1045: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_course_start_time - ' || l_course_start_time);
1046: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_course_end_time - ' || l_course_end_time);
1047: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_enrollment_start_date - ' || l_enrollment_start_date);
1048: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_enrollment_end_date - ' || l_enrollment_end_date);
1049: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_offering_max_attendees - ' || p_offering_max_attendees);
1050: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_default_event_owner_id - ' || l_default_event_owner_id);
1051: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_offering_id - ' || p_offering_id);
1052:

Line 1049: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_offering_max_attendees - ' || p_offering_max_attendees);

1045: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_course_start_time - ' || l_course_start_time);
1046: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_course_end_time - ' || l_course_end_time);
1047: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_enrollment_start_date - ' || l_enrollment_start_date);
1048: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_enrollment_end_date - ' || l_enrollment_end_date);
1049: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_offering_max_attendees - ' || p_offering_max_attendees);
1050: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_default_event_owner_id - ' || l_default_event_owner_id);
1051: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_offering_id - ' || p_offering_id);
1052:
1053: -- dbms_output.put_line(p_message);

Line 1050: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_default_event_owner_id - ' || l_default_event_owner_id);

1046: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_course_end_time - ' || l_course_end_time);
1047: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_enrollment_start_date - ' || l_enrollment_start_date);
1048: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_enrollment_end_date - ' || l_enrollment_end_date);
1049: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_offering_max_attendees - ' || p_offering_max_attendees);
1050: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_default_event_owner_id - ' || l_default_event_owner_id);
1051: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_offering_id - ' || p_offering_id);
1052:
1053: -- dbms_output.put_line(p_message);
1054: -- p_status := 'F';

Line 1051: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_offering_id - ' || p_offering_id);

1047: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_enrollment_start_date - ' || l_enrollment_start_date);
1048: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_enrollment_end_date - ' || l_enrollment_end_date);
1049: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_offering_max_attendees - ' || p_offering_max_attendees);
1050: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_default_event_owner_id - ' || l_default_event_owner_id);
1051: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_offering_id - ' || p_offering_id);
1052:
1053: -- dbms_output.put_line(p_message);
1054: -- p_status := 'F';
1055: p_status := 'W';

Line 1066: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not update Offering '|| p_offering_title ||

1062: close cur_get_event_id;
1063:
1064: -- if event type changed from self-paced to schedule or schedule to self-paced
1065: if l_event_type <> l2_event_type then --if event type changed
1066: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not update Offering '|| p_offering_title ||
1067: ', because you cannot change Offerings from Self-Paced to Scheduled or Scheduled to Self-Paced ');
1068: p_message := 'ERROR:Event type changed from Self-Paced to Schedule or Schedule to Self-Paced ' ||
1069: 'for offering Id - ' || p_offering_id;
1070: -- dbms_output.put_line(p_message);

Line 1148: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successfully created the Delivery Method for Category ' || l_category||'.');

1144: ,p_category_usage_id =>l_category_usage_id
1145: ,p_category => l_category);
1146:
1147:
1148: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successfully created the Delivery Method for Category ' || l_category||'.');
1149: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Category usage id - ' || l_category_usage_id ||
1150: -- ' created successfully ');
1151: p_message := 'Category usage id - ' || l_category_usage_id || ' created successfully.';
1152: -- dbms_output.put_line(p_message);

Line 1149: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Category usage id - ' || l_category_usage_id ||

1145: ,p_category => l_category);
1146:
1147:
1148: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successfully created the Delivery Method for Category ' || l_category||'.');
1149: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Category usage id - ' || l_category_usage_id ||
1150: -- ' created successfully ');
1151: p_message := 'Category usage id - ' || l_category_usage_id || ' created successfully.';
1152: -- dbms_output.put_line(p_message);
1153:

Line 1156: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not create the Delivery Method for Category ' || l_category

1152: -- dbms_output.put_line(p_message);
1153:
1154: EXCEPTION
1155: when others then
1156: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not create the Delivery Method for Category ' || l_category
1157: || '. Reason:' || hr_utility.get_message);
1158: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:Unable to create category usage for category - '||
1159: -- l_category || '. REASON:' || hr_utility.get_message);
1160: p_message := 'ERROR:Unable to create category usage for category - '|| l_category;

Line 1158: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:Unable to create category usage for category - '||

1154: EXCEPTION
1155: when others then
1156: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not create the Delivery Method for Category ' || l_category
1157: || '. Reason:' || hr_utility.get_message);
1158: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:Unable to create category usage for category - '||
1159: -- l_category || '. REASON:' || hr_utility.get_message);
1160: p_message := 'ERROR:Unable to create category usage for category - '|| l_category;
1161: -- dbms_output.put_line(p_message);
1162: -- p_status := 'F';

Line 1212: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successfully included Delivery Method in Activity Version ID '||

1208: ,p_category_usage_id => l_category_usage_id -- (Input)
1209: ,p_effective_date => trunc(sysdate) -- (Input)
1210: );
1211:
1212: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successfully included Delivery Method in Activity Version ID '||
1213: p_activity_version_id ||'.');
1214: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Successfully created category inclusion for category usage id- '||
1215: -- l_category_usage_id);
1216: p_message := 'Successfully created category inclusion for category usage id - '|| l_category_usage_id;

Line 1214: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Successfully created category inclusion for category usage id- '||

1210: );
1211:
1212: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successfully included Delivery Method in Activity Version ID '||
1213: p_activity_version_id ||'.');
1214: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Successfully created category inclusion for category usage id- '||
1215: -- l_category_usage_id);
1216: p_message := 'Successfully created category inclusion for category usage id - '|| l_category_usage_id;
1217: -- dbms_output.put_line(p_message);
1218:

Line 1221: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not include Delivery Method in Activity Version ID '||

1217: -- dbms_output.put_line(p_message);
1218:
1219: EXCEPTION
1220: when others then
1221: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not include Delivery Method in Activity Version ID '||
1222: p_activity_version_id || '. Reason:' || hr_utility.get_message);
1223: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:Unable to create category inclusion for category usage id- '||
1224: -- l_category_usage_id || '. REASON:' || hr_utility.get_message);
1225: p_message := 'ERROR:Unable to create category inclusion for category usage id - '|| l_category_usage_id;

Line 1223: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:Unable to create category inclusion for category usage id- '||

1219: EXCEPTION
1220: when others then
1221: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not include Delivery Method in Activity Version ID '||
1222: p_activity_version_id || '. Reason:' || hr_utility.get_message);
1223: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:Unable to create category inclusion for category usage id- '||
1224: -- l_category_usage_id || '. REASON:' || hr_utility.get_message);
1225: p_message := 'ERROR:Unable to create category inclusion for category usage id - '|| l_category_usage_id;
1226: -- dbms_output.put_line(p_message);
1227: -- dbms_output.put_line('p_activity_version_id - ' || p_activity_version_id);

Line 1260: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not update Activity Start Date for Activity Version ID '||

1256: ,p_validate => false -- (Input)
1257: );
1258: EXCEPTION
1259: when others then
1260: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not update Activity Start Date for Activity Version ID '||
1261: p_activity_version_id || '. REASON:' || hr_utility.get_message);
1262: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:Unable to update Activity start date for activity_version_id - '||
1263: -- p_activity_version_id || ' And offering Id - ' ||p_offering_id
1264: -- || '. REASON:' || hr_utility.get_message);

Line 1262: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:Unable to update Activity start date for activity_version_id - '||

1258: EXCEPTION
1259: when others then
1260: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not update Activity Start Date for Activity Version ID '||
1261: p_activity_version_id || '. REASON:' || hr_utility.get_message);
1262: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:Unable to update Activity start date for activity_version_id - '||
1263: -- p_activity_version_id || ' And offering Id - ' ||p_offering_id
1264: -- || '. REASON:' || hr_utility.get_message);
1265: p_message := 'ERROR:Unable to update Activity start date for activity_version_id - '||
1266: p_activity_version_id || ' And offering Id - ' ||p_offering_id;

Line 1412: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not update Maximum attendees to '||

1408:
1409: l_maximum_attendees := p_offering_max_attendees;
1410:
1411: else
1412: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not update Maximum attendees to '||
1413: p_offering_max_attendees || 'for the Event ' ||
1414: p_offering_title || ' , because '|| l_total_placed ||
1415: ' students have already enrolled in the event.');
1416: p_message := 'ERROR:Maximum attendees for event id - ' ||

Line 1473: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successfully updated the Event '|| p_offering_title || '.');

1469: ,p_title => p_offering_title
1470: );
1471:
1472:
1473: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successfully updated the Event '|| p_offering_title || '.');
1474: p_message := 'Event updated successfully.Event id is -'||l_event_id||' for Offering id - '||p_offering_id;
1475: -- dbms_output.put_line(p_message);
1476: -- p_status := 'S';
1477: -- return;

Line 1481: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not update the Event '|| p_offering_title ||

1477: -- return;
1478:
1479: EXCEPTION
1480: when others then
1481: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not update the Event '|| p_offering_title ||
1482: '. Reason:' || hr_utility.get_message);
1483: p_message := 'ERROR:Unable to update Event.Event id is -'||l_event_id||' for Offering id - '||p_offering_id;
1484: -- dbms_output.put_line(p_message);
1485: -- dbms_output.put_line(l_event_id);

Line 1517: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not automatically enroll students from the waitlists in the Event ' || p_offering_title || '.');

1513: );
1514:
1515: if l_auto_enroll_status = 'F' then
1516:
1517: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not automatically enroll students from the waitlists in the Event ' || p_offering_title || '.');
1518: p_message := 'ERROR:Error in Auto_Enroll_From_Waitlist procedure for event id - ' ||
1519: l_event_id || '.';
1520:
1521: -- dbms_output.put_line(p_message);

Line 1540: FND_FILE.PUT_LINE(FND_FILE.LOG,'The Offering ' || p_offering_title ||

1536: end if; -- if event does not exist
1537:
1538: ELSE
1539:
1540: FND_FILE.PUT_LINE(FND_FILE.LOG,'The Offering ' || p_offering_title ||
1541: ' is an inClass Offering. The application does not import inClass Offerings.');
1542: p_message := 'Concurrent program will not process Offering id - ' || p_offering_id ||
1543: ' due to offering type - ' || p_offering_type;
1544: -- dbms_output.put_line(p_message);

Line 1554: FND_FILE.PUT_LINE(FND_FILE.LOG,'An error occurred while processing the Offering ' || p_offering_title ||'. SQLERRM:'

1550:
1551: exception
1552: when others then
1553:
1554: FND_FILE.PUT_LINE(FND_FILE.LOG,'An error occurred while processing the Offering ' || p_offering_title ||'. SQLERRM:'
1555: || SQLERRM);
1556: p_message := 'ERROR:In when others exception for Offering Id - '|| p_offering_id;
1557: -- dbms_output.put_line(p_message);
1558: -- p_status := 'F';

Line 1592: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Entering:' || l_proc);

1588: l_event_fail number(10) := 0;
1589: l_event_warning number(10) := 0;
1590:
1591: begin
1592: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Entering:' || l_proc);
1593:
1594:
1595: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of p_array.LAST is:' || p_array.LAST);
1596:

Line 1595: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of p_array.LAST is:' || p_array.LAST);

1591: begin
1592: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Entering:' || l_proc);
1593:
1594:
1595: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of p_array.LAST is:' || p_array.LAST);
1596:
1597:
1598:
1599: FOR p_array_idx IN p_array.FIRST..p_array.LAST LOOP

Line 1604: FND_FILE.PUT_LINE(FND_FILE.LOG,'The RCO ID is missing for the Offering ' || p_array(p_array_idx).offering_title ||

1600:
1601:
1602: IF p_array(p_array_idx).rco_id is null then
1603:
1604: FND_FILE.PUT_LINE(FND_FILE.LOG,'The RCO ID is missing for the Offering ' || p_array(p_array_idx).offering_title ||
1605: '.');
1606:
1607: ELSE
1608:

Line 1614: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'creating/updating activity' || 'RCO-ID:' || to_number(p_array(p_array_idx).rco_id) );

1610: l_update := 'true';
1611: else
1612: l_update := NULL;
1613: end if;
1614: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'creating/updating activity' || 'RCO-ID:' || to_number(p_array(p_array_idx).rco_id) );
1615:
1616:
1617: -- Issue SavePoint
1618: SAVEPOINT save_activity;

Line 1620: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');

1616:
1617: -- Issue SavePoint
1618: SAVEPOINT save_activity;
1619:
1620: FND_FILE.PUT_LINE(FND_FILE.LOG,'**-----------------------------------------------------------**');
1621:
1622: crt_or_upd_activity
1623: (
1624: p_update => l_update -- (Input)

Line 1644: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Activity Insert/Update commited.');

1640: if l_rco_status = 'S' then
1641: l_activity_success := l_activity_success +1;
1642: -- do commit
1643: commit;
1644: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Activity Insert/Update commited.');
1645:
1646: elsif l_rco_status = 'W' then
1647: l_activity_warning := l_activity_warning +1;
1648: ROLLBACK TO save_activity;

Line 1649: FND_FILE.PUT_LINE(FND_FILE.LOG,'The import could not create an activity for the RCO:' || p_array(p_array_idx).rco_title);

1645:
1646: elsif l_rco_status = 'W' then
1647: l_activity_warning := l_activity_warning +1;
1648: ROLLBACK TO save_activity;
1649: FND_FILE.PUT_LINE(FND_FILE.LOG,'The import could not create an activity for the RCO:' || p_array(p_array_idx).rco_title);
1650: else
1651: l_activity_fail := l_activity_fail +1;
1652: -- rollback to save_activity
1653: ROLLBACK TO save_activity;

Line 1654: FND_FILE.PUT_LINE(FND_FILE.LOG,'The import could not create an activity for the RCO:' || p_array(p_array_idx).rco_title);

1650: else
1651: l_activity_fail := l_activity_fail +1;
1652: -- rollback to save_activity
1653: ROLLBACK TO save_activity;
1654: FND_FILE.PUT_LINE(FND_FILE.LOG,'The import could not create an activity for the RCO:' || p_array(p_array_idx).rco_title);
1655: end if;
1656:
1657:
1658: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'creating/updating Event');

Line 1658: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'creating/updating Event');

1654: FND_FILE.PUT_LINE(FND_FILE.LOG,'The import could not create an activity for the RCO:' || p_array(p_array_idx).rco_title);
1655: end if;
1656:
1657:
1658: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'creating/updating Event');
1659:
1660: if (to_number(p_array(p_array_idx).offering_id) <> -1 and l_activity_version_id is not null) then
1661:
1662: -- Issue Savepoint

Line 1690: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Event Insert/Update commited.');

1686: if l_offering_status = 'S' then
1687: l_event_success := l_event_success + 1;
1688: -- do commit;
1689: commit;
1690: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Event Insert/Update commited.');
1691: elsif l_offering_status = 'W' then
1692: l_event_warning := l_event_warning + 1;
1693: -- rollback to save_event
1694: ROLLBACK TO save_event;

Line 1695: FND_FILE.PUT_LINE(FND_FILE.LOG,'The import could not create an event for the Offering:' || to_number(p_array(p_array_idx).offering_id) );

1691: elsif l_offering_status = 'W' then
1692: l_event_warning := l_event_warning + 1;
1693: -- rollback to save_event
1694: ROLLBACK TO save_event;
1695: FND_FILE.PUT_LINE(FND_FILE.LOG,'The import could not create an event for the Offering:' || to_number(p_array(p_array_idx).offering_id) );
1696: else
1697: l_event_fail := l_event_fail + 1;
1698: -- rollback to save_event
1699: ROLLBACK TO save_event;

Line 1700: FND_FILE.PUT_LINE(FND_FILE.LOG,'The import could not create an event for the Offering:' || to_number(p_array(p_array_idx).offering_id) );

1696: else
1697: l_event_fail := l_event_fail + 1;
1698: -- rollback to save_event
1699: ROLLBACK TO save_event;
1700: FND_FILE.PUT_LINE(FND_FILE.LOG,'The import could not create an event for the Offering:' || to_number(p_array(p_array_idx).offering_id) );
1701: end if;
1702:
1703: elsif (to_number(p_array(p_array_idx).offering_id) <> -1 and l_activity_version_id is null) then
1704:

Line 1706: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application did not create an event for the offering '||

1702:
1703: elsif (to_number(p_array(p_array_idx).offering_id) <> -1 and l_activity_version_id is null) then
1704:
1705: l_event_warning := l_event_warning + 1;
1706: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application did not create an event for the offering '||
1707: p_array(p_array_idx).offering_title ||
1708: ', because it could not create an activity version from its associated RCO, '||
1709: p_array(p_array_idx).rco_title||'.');
1710:

Line 1730: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');

1726:
1727: l_event_fail := l_event_fail + l_event_warning;
1728: l_activity_fail := l_activity_fail + l_activity_warning;
1729:
1730: FND_FILE.PUT_LINE(FND_FILE.LOG,'**-----------------------------------------------------------**');
1731: FND_FILE.PUT_LINE(FND_FILE.LOG,' IMPORT RESULTS FOR OFFERINGS');
1732: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------------------------');
1733: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of Activities Processed Successfully:' || l_activity_success);
1734: FND_FILE.PUT_LINE(FND_FILE.LOG,' Number of Activities Not Processed:' || l_activity_fail);

Line 1731: FND_FILE.PUT_LINE(FND_FILE.LOG,' IMPORT RESULTS FOR OFFERINGS');

1727: l_event_fail := l_event_fail + l_event_warning;
1728: l_activity_fail := l_activity_fail + l_activity_warning;
1729:
1730: FND_FILE.PUT_LINE(FND_FILE.LOG,'**-----------------------------------------------------------**');
1731: FND_FILE.PUT_LINE(FND_FILE.LOG,' IMPORT RESULTS FOR OFFERINGS');
1732: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------------------------');
1733: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of Activities Processed Successfully:' || l_activity_success);
1734: FND_FILE.PUT_LINE(FND_FILE.LOG,' Number of Activities Not Processed:' || l_activity_fail);
1735: -- FND_FILE.PUT_LINE(FND_FILE.LOG,' Number of Events Processed Successfully:' || l_event_success);

Line 1732: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------------------------');

1728: l_activity_fail := l_activity_fail + l_activity_warning;
1729:
1730: FND_FILE.PUT_LINE(FND_FILE.LOG,'**-----------------------------------------------------------**');
1731: FND_FILE.PUT_LINE(FND_FILE.LOG,' IMPORT RESULTS FOR OFFERINGS');
1732: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------------------------');
1733: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of Activities Processed Successfully:' || l_activity_success);
1734: FND_FILE.PUT_LINE(FND_FILE.LOG,' Number of Activities Not Processed:' || l_activity_fail);
1735: -- FND_FILE.PUT_LINE(FND_FILE.LOG,' Number of Events Processed Successfully:' || l_event_success);
1736: FND_FILE.PUT_LINE(FND_FILE.LOG,' Number of Events Not Processed:' || l_event_fail );

Line 1733: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of Activities Processed Successfully:' || l_activity_success);

1729:
1730: FND_FILE.PUT_LINE(FND_FILE.LOG,'**-----------------------------------------------------------**');
1731: FND_FILE.PUT_LINE(FND_FILE.LOG,' IMPORT RESULTS FOR OFFERINGS');
1732: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------------------------');
1733: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of Activities Processed Successfully:' || l_activity_success);
1734: FND_FILE.PUT_LINE(FND_FILE.LOG,' Number of Activities Not Processed:' || l_activity_fail);
1735: -- FND_FILE.PUT_LINE(FND_FILE.LOG,' Number of Events Processed Successfully:' || l_event_success);
1736: FND_FILE.PUT_LINE(FND_FILE.LOG,' Number of Events Not Processed:' || l_event_fail );
1737: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------------');

Line 1734: FND_FILE.PUT_LINE(FND_FILE.LOG,' Number of Activities Not Processed:' || l_activity_fail);

1730: FND_FILE.PUT_LINE(FND_FILE.LOG,'**-----------------------------------------------------------**');
1731: FND_FILE.PUT_LINE(FND_FILE.LOG,' IMPORT RESULTS FOR OFFERINGS');
1732: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------------------------');
1733: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of Activities Processed Successfully:' || l_activity_success);
1734: FND_FILE.PUT_LINE(FND_FILE.LOG,' Number of Activities Not Processed:' || l_activity_fail);
1735: -- FND_FILE.PUT_LINE(FND_FILE.LOG,' Number of Events Processed Successfully:' || l_event_success);
1736: FND_FILE.PUT_LINE(FND_FILE.LOG,' Number of Events Not Processed:' || l_event_fail );
1737: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------------');
1738: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Exiting:' || l_proc);

Line 1735: -- FND_FILE.PUT_LINE(FND_FILE.LOG,' Number of Events Processed Successfully:' || l_event_success);

1731: FND_FILE.PUT_LINE(FND_FILE.LOG,' IMPORT RESULTS FOR OFFERINGS');
1732: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------------------------');
1733: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of Activities Processed Successfully:' || l_activity_success);
1734: FND_FILE.PUT_LINE(FND_FILE.LOG,' Number of Activities Not Processed:' || l_activity_fail);
1735: -- FND_FILE.PUT_LINE(FND_FILE.LOG,' Number of Events Processed Successfully:' || l_event_success);
1736: FND_FILE.PUT_LINE(FND_FILE.LOG,' Number of Events Not Processed:' || l_event_fail );
1737: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------------');
1738: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Exiting:' || l_proc);
1739:

Line 1736: FND_FILE.PUT_LINE(FND_FILE.LOG,' Number of Events Not Processed:' || l_event_fail );

1732: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------------------------');
1733: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of Activities Processed Successfully:' || l_activity_success);
1734: FND_FILE.PUT_LINE(FND_FILE.LOG,' Number of Activities Not Processed:' || l_activity_fail);
1735: -- FND_FILE.PUT_LINE(FND_FILE.LOG,' Number of Events Processed Successfully:' || l_event_success);
1736: FND_FILE.PUT_LINE(FND_FILE.LOG,' Number of Events Not Processed:' || l_event_fail );
1737: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------------');
1738: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Exiting:' || l_proc);
1739:
1740:

Line 1737: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------------');

1733: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of Activities Processed Successfully:' || l_activity_success);
1734: FND_FILE.PUT_LINE(FND_FILE.LOG,' Number of Activities Not Processed:' || l_activity_fail);
1735: -- FND_FILE.PUT_LINE(FND_FILE.LOG,' Number of Events Processed Successfully:' || l_event_success);
1736: FND_FILE.PUT_LINE(FND_FILE.LOG,' Number of Events Not Processed:' || l_event_fail );
1737: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------------');
1738: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Exiting:' || l_proc);
1739:
1740:
1741: end offering_rco_import;

Line 1738: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Exiting:' || l_proc);

1734: FND_FILE.PUT_LINE(FND_FILE.LOG,' Number of Activities Not Processed:' || l_activity_fail);
1735: -- FND_FILE.PUT_LINE(FND_FILE.LOG,' Number of Events Processed Successfully:' || l_event_success);
1736: FND_FILE.PUT_LINE(FND_FILE.LOG,' Number of Events Not Processed:' || l_event_fail );
1737: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------------');
1738: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Exiting:' || l_proc);
1739:
1740:
1741: end offering_rco_import;
1742:

Line 1763: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Entering:' || l_proc || 'p_array_LAST-' ||p_array.LAST);

1759: l_activity_success number(10) := 0;
1760: l_activity_fail number(10) := 0;
1761:
1762: begin
1763: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Entering:' || l_proc || 'p_array_LAST-' ||p_array.LAST);
1764:
1765:
1766: FOR p_array_idx IN p_array.FIRST..p_array.LAST LOOP
1767:

Line 1768: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Entering:' || l_proc);

1764:
1765:
1766: FOR p_array_idx IN p_array.FIRST..p_array.LAST LOOP
1767:
1768: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Entering:' || l_proc);
1769:
1770: -- Issue Savepoint
1771: SAVEPOINT save_activity;
1772:

Line 1795: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Activity Update commited.');

1791: if l_rco_status = 'S' then
1792: l_activity_success := l_activity_success +1;
1793: -- do commit;
1794: commit;
1795: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Activity Update commited.');
1796: else
1797: l_activity_fail := l_activity_fail +1;
1798: -- rollback to save_activity
1799: ROLLBACK TO save_activity;

Line 1800: FND_FILE.PUT_LINE(FND_FILE.LOG,'The import could not create an activity for the RCO:' || to_number(p_array(p_array_idx).rco_id) );

1796: else
1797: l_activity_fail := l_activity_fail +1;
1798: -- rollback to save_activity
1799: ROLLBACK TO save_activity;
1800: FND_FILE.PUT_LINE(FND_FILE.LOG,'The import could not create an activity for the RCO:' || to_number(p_array(p_array_idx).rco_id) );
1801: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Activity Update rolled back.');
1802: end if;
1803:
1804: END LOOP;

Line 1801: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Activity Update rolled back.');

1797: l_activity_fail := l_activity_fail +1;
1798: -- rollback to save_activity
1799: ROLLBACK TO save_activity;
1800: FND_FILE.PUT_LINE(FND_FILE.LOG,'The import could not create an activity for the RCO:' || to_number(p_array(p_array_idx).rco_id) );
1801: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Activity Update rolled back.');
1802: end if;
1803:
1804: END LOOP;
1805:

Line 1806: FND_FILE.PUT_LINE(FND_FILE.LOG,' IMPORT RESULTS FOR RCOS');

1802: end if;
1803:
1804: END LOOP;
1805:
1806: FND_FILE.PUT_LINE(FND_FILE.LOG,' IMPORT RESULTS FOR RCOS');
1807: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------------------------');
1808: FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of Activities Processed Successfully:' || l_activity_success);
1809: FND_FILE.PUT_LINE(FND_FILE.LOG,' Number of Activities Not Processed:' || l_activity_fail);
1810: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------------------------');

Line 1807: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------------------------');

1803:
1804: END LOOP;
1805:
1806: FND_FILE.PUT_LINE(FND_FILE.LOG,' IMPORT RESULTS FOR RCOS');
1807: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------------------------');
1808: FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of Activities Processed Successfully:' || l_activity_success);
1809: FND_FILE.PUT_LINE(FND_FILE.LOG,' Number of Activities Not Processed:' || l_activity_fail);
1810: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------------------------');
1811: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Exiting:' || l_proc);

Line 1808: FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of Activities Processed Successfully:' || l_activity_success);

1804: END LOOP;
1805:
1806: FND_FILE.PUT_LINE(FND_FILE.LOG,' IMPORT RESULTS FOR RCOS');
1807: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------------------------');
1808: FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of Activities Processed Successfully:' || l_activity_success);
1809: FND_FILE.PUT_LINE(FND_FILE.LOG,' Number of Activities Not Processed:' || l_activity_fail);
1810: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------------------------');
1811: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Exiting:' || l_proc);
1812:

Line 1809: FND_FILE.PUT_LINE(FND_FILE.LOG,' Number of Activities Not Processed:' || l_activity_fail);

1805:
1806: FND_FILE.PUT_LINE(FND_FILE.LOG,' IMPORT RESULTS FOR RCOS');
1807: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------------------------');
1808: FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of Activities Processed Successfully:' || l_activity_success);
1809: FND_FILE.PUT_LINE(FND_FILE.LOG,' Number of Activities Not Processed:' || l_activity_fail);
1810: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------------------------');
1811: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Exiting:' || l_proc);
1812:
1813: end rco_import;

Line 1810: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------------------------');

1806: FND_FILE.PUT_LINE(FND_FILE.LOG,' IMPORT RESULTS FOR RCOS');
1807: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------------------------');
1808: FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of Activities Processed Successfully:' || l_activity_success);
1809: FND_FILE.PUT_LINE(FND_FILE.LOG,' Number of Activities Not Processed:' || l_activity_fail);
1810: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------------------------');
1811: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Exiting:' || l_proc);
1812:
1813: end rco_import;
1814:

Line 1811: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Exiting:' || l_proc);

1807: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------------------------');
1808: FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of Activities Processed Successfully:' || l_activity_success);
1809: FND_FILE.PUT_LINE(FND_FILE.LOG,' Number of Activities Not Processed:' || l_activity_fail);
1810: FND_FILE.PUT_LINE(FND_FILE.LOG,'---------------------------------------------------------------');
1811: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Exiting:' || l_proc);
1812:
1813: end rco_import;
1814:
1815:

Line 1874: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Entering:' || l_proc);

1870: executable_name = p_process_name and
1871: site_id = l_site_id;
1872:
1873: begin
1874: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Entering:' || l_proc);
1875:
1876: select sysdate into l_sysdate from dual;
1877:
1878: -- if (p_start_date is null) or (p_end_date is null) or (p_start_date > p_end_date) or (p_end_date > l_sysdate) then

Line 1881: FND_FILE.PUT_LINE(FND_FILE.LOG,'The Start Date must be earlier than the End Date and the End Date cannot be later than the Current date and time.');

1877:
1878: -- if (p_start_date is null) or (p_end_date is null) or (p_start_date > p_end_date) or (p_end_date > l_sysdate) then
1879: if (pl_start_date is null) or (pl_end_date is null) or (pl_start_date > pl_end_date) or (pl_end_date > l_sysdate) then
1880: l_status := 'F';
1881: FND_FILE.PUT_LINE(FND_FILE.LOG,'The Start Date must be earlier than the End Date and the End Date cannot be later than the Current date and time.');
1882:
1883: else
1884:
1885:

Line 1914: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Record created in ota_iln_xml_processes table for ' ||

1910: pl_end_date);
1911:
1912: l_status := 'S';
1913:
1914: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Record created in ota_iln_xml_processes table for ' ||
1915: -- ' process '|| p_process_name ||
1916: -- ' business group id ' || l_business_group_id ||
1917: -- ' and site id ' || l_site_id || '.');
1918: else

Line 1920: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Process '|| p_process_name || ' for site id ' ||

1916: -- ' business group id ' || l_business_group_id ||
1917: -- ' and site id ' || l_site_id || '.');
1918: else
1919: close cur_get_record3;
1920: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Process '|| p_process_name || ' for site id ' ||
1921: -- l_site_id || ' is attached to business group id ' || l_business_group_id ||
1922: -- ' in ota_iln_xml_processes table. Where as concurrent program is using ' ||
1923: -- ' business group id ' || l_2_business_group_id || '. Please Correct.');
1924:

Line 1925: FND_FILE.PUT_LINE(FND_FILE.LOG,'The Site ID '|| l_site_id || ' is already mapped to the Business Group ID '||

1921: -- l_site_id || ' is attached to business group id ' || l_business_group_id ||
1922: -- ' in ota_iln_xml_processes table. Where as concurrent program is using ' ||
1923: -- ' business group id ' || l_2_business_group_id || '. Please Correct.');
1924:
1925: FND_FILE.PUT_LINE(FND_FILE.LOG,'The Site ID '|| l_site_id || ' is already mapped to the Business Group ID '||
1926: l_2_business_group_id || '.');
1927:
1928: end if;
1929:

Line 1932: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Process '|| p_process_name || ' for business group id ' ||

1928: end if;
1929:
1930: else
1931: close cur_get_record2;
1932: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Process '|| p_process_name || ' for business group id ' ||
1933: -- l_business_group_id || ' is attached to site id ' || l_site_id ||
1934: -- ' in ota_iln_xml_processes table. Where as concurrent program is using site id ' ||
1935: -- l_2_site_id || '. Please Correct.');
1936:

Line 1937: FND_FILE.PUT_LINE(FND_FILE.LOG,'The Business Group ID '|| l_business_group_id || ' is already mapped to the Site ID '||

1933: -- l_business_group_id || ' is attached to site id ' || l_site_id ||
1934: -- ' in ota_iln_xml_processes table. Where as concurrent program is using site id ' ||
1935: -- l_2_site_id || '. Please Correct.');
1936:
1937: FND_FILE.PUT_LINE(FND_FILE.LOG,'The Business Group ID '|| l_business_group_id || ' is already mapped to the Site ID '||
1938: l_2_site_id || '.');
1939: end if;
1940:
1941: else

Line 1964: FND_FILE.PUT_LINE(FND_FILE.LOG,'');

1960:
1961: */
1962:
1963:
1964: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
1965: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent program will update ota_iln_xml_processes table' ||
1966: -- ' with start and end date. ');
1967: else
1968: l_process_type := 'M';

Line 1965: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent program will update ota_iln_xml_processes table' ||

1961: */
1962:
1963:
1964: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
1965: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent program will update ota_iln_xml_processes table' ||
1966: -- ' with start and end date. ');
1967: else
1968: l_process_type := 'M';
1969: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent program will not update ota_iln_xml_processes' ||

Line 1969: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent program will not update ota_iln_xml_processes' ||

1965: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent program will update ota_iln_xml_processes table' ||
1966: -- ' with start and end date. ');
1967: else
1968: l_process_type := 'M';
1969: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent program will not update ota_iln_xml_processes' ||
1970: -- ' with start and end date. ');
1971: end if;
1972:
1973: end if;

Line 1980: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_status:' || p_status);

1976:
1977: p_status := l_status;
1978: p_process_type := l_process_type;
1979:
1980: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_status:' || p_status);
1981: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Exiting:' || l_proc);
1982:
1983:
1984: EXCEPTION

Line 1981: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Exiting:' || l_proc);

1977: p_status := l_status;
1978: p_process_type := l_process_type;
1979:
1980: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_status:' || p_status);
1981: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Exiting:' || l_proc);
1982:
1983:
1984: EXCEPTION
1985: when others then

Line 1986: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:When others exception in procedure crt_or_chk_xml_prcs_tbl.');

1982:
1983:
1984: EXCEPTION
1985: when others then
1986: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:When others exception in procedure crt_or_chk_xml_prcs_tbl.');
1987: p_status := 'F';
1988:
1989: end crt_or_chk_xml_prcs_tbl;
1990:

Line 2010: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Entering:' || l_proc);

2006: l_start_date date := to_date(p_start_date,'YYYY/MM/DD HH24:MI:SS');
2007: l_end_date date := to_date(p_end_date,'YYYY/MM/DD HH24:MI:SS');
2008:
2009: begin
2010: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Entering:' || l_proc);
2011:
2012:
2013: update
2014: ota_iln_xml_processes

Line 2024: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ota_iln_xml_processes table updated successfully' ||

2020: business_group_id = l_business_group_id and
2021: site_id = l_site_id;
2022:
2023:
2024: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ota_iln_xml_processes table updated successfully' ||
2025: -- ' with start and end date. ');
2026: p_status := 'S';
2027:
2028: EXCEPTION

Line 2030: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:When others exception in procedure upd_xml_prcs_tbl.');

2026: p_status := 'S';
2027:
2028: EXCEPTION
2029: when others then
2030: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:When others exception in procedure upd_xml_prcs_tbl.');
2031: p_status := 'F';
2032:
2033: end upd_xml_prcs_tbl;
2034: