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_CPE_UTIL dependencies on FND_FILE

Line 1914: FND_FILE.PUT_LINE(FND_FILE.LOG, l_log_message);

1910: else
1911: l_log_message := l_log_message || ' for contact id ' || exp_sts_upd.contact_id;
1912: end if;
1913:
1914: FND_FILE.PUT_LINE(FND_FILE.LOG, l_log_message);
1915:
1916: --Update Cert CRE status to Expired
1917: for exp_records in get_data_for_expired_records(exp_sts_upd.cert_prd_enrollment_id)
1918: Loop

Line 1941: FND_FILE.PUT_LINE(FND_FILE.LOG, l_log_message);

1937: l_log_message := l_log_message || ' for person id ' || exp_records.person_id;
1938: else
1939: l_log_message := l_log_message || ' for contact id ' || exp_records.contact_id;
1940: end if;
1941: FND_FILE.PUT_LINE(FND_FILE.LOG, l_log_message);
1942: end if;
1943: End Loop;
1944: EXCEPTION
1945: WHEN OTHERS then

Line 1946: FND_FILE.PUT_LINE(FND_FILE.LOG, 'When Others Error occured in, '

1942: end if;
1943: End Loop;
1944: EXCEPTION
1945: WHEN OTHERS then
1946: FND_FILE.PUT_LINE(FND_FILE.LOG, 'When Others Error occured in, '
1947: || 'Update to cpe cre calls ,' || 'Cert_Prd_Enrollment_Id=' || to_char(exp_sts_upd.cert_prd_enrollment_id)
1948: ||',' || 'Cert_Enrollment_Id=' || to_char(exp_sts_upd.cert_enrollment_id)
1949: || ',' || SUBSTR(SQLERRM, 1, 500));
1950:

Line 1957: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Data committed to database');

1953: end if;
1954: End Loop;
1955:
1956: commit;
1957: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Data committed to database');
1958: hr_utility.set_location('Leaving:'||l_proc, 5);
1959: EXCEPTION
1960: when others then
1961: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc

Line 1961: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc

1957: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Data committed to database');
1958: hr_utility.set_location('Leaving:'||l_proc, 5);
1959: EXCEPTION
1960: when others then
1961: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc
1962: ||','||SUBSTR(SQLERRM, 1, 500));
1963: end update_cert_status_to_expired;
1964: --
1965: Procedure sync_cert_status_to_class_enrl(

Line 2033: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Updated the Certification member status for the cert_mbr_enrollment_id = ' || rec_acty_info.cert_mbr_enrollment_id);

2029: do_update := true;
2030: end if;
2031: if do_update then
2032: ota_cme_util.update_cme_status(rec_acty_info.cert_mbr_enrollment_id);
2033: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Updated the Certification member status for the cert_mbr_enrollment_id = ' || rec_acty_info.cert_mbr_enrollment_id);
2034: ota_cme_util.update_cpe_status(rec_acty_info.cert_mbr_enrollment_id, l_cert_prd_enrollment_id, trunc(l_date_status_changed));
2035: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Updated the Certification period status for the cert_prd_enrollment_id = ' || l_cert_prd_enrollment_id);
2036: end if;
2037: do_update := false;

Line 2035: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Updated the Certification period status for the cert_prd_enrollment_id = ' || l_cert_prd_enrollment_id);

2031: if do_update then
2032: ota_cme_util.update_cme_status(rec_acty_info.cert_mbr_enrollment_id);
2033: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Updated the Certification member status for the cert_mbr_enrollment_id = ' || rec_acty_info.cert_mbr_enrollment_id);
2034: ota_cme_util.update_cpe_status(rec_acty_info.cert_mbr_enrollment_id, l_cert_prd_enrollment_id, trunc(l_date_status_changed));
2035: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Updated the Certification period status for the cert_prd_enrollment_id = ' || l_cert_prd_enrollment_id);
2036: end if;
2037: do_update := false;
2038: end loop;
2039: end loop;

Line 2045: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Data committed to database');

2041: hr_utility.set_location('Entering:'||l_proc, 20);
2042:
2043: commit;
2044:
2045: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Data committed to database');
2046:
2047: hr_utility.set_location('Leaving:'||l_proc, 30);
2048:
2049: EXCEPTION

Line 2051: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc

2047: hr_utility.set_location('Leaving:'||l_proc, 30);
2048:
2049: EXCEPTION
2050: when others then
2051: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc
2052: ||','||SUBSTR(SQLERRM, 1, 500));
2053: end sync_cert_status_to_class_enrl;
2054: --
2055: FUNCTION get_latest_cpe_col(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%TYPE,

Line 2386: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sync Late Subscription to certification with classes');

2382: l_expiration_date ota_cert_prd_enrollments.expiration_date%type;
2383:
2384: begin
2385:
2386: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sync Late Subscription to certification with classes');
2387:
2388: FOR rec_cert_details in csr_cert_details loop
2389: FOR rec_course_info in csr_course_info(rec_cert_details.cert_prd_enrollment_id) loop
2390: FOR rec_enr IN get_enrl_status(rec_course_info.object_id,

Line 2421: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Certification: ' || rec_cert_details.name);

2417: OPEN csr_cert_enrl(rec_cert_details.cert_enrollment_id);
2418: FETCH csr_cert_enrl INTO l_cert_enrl_rec;
2419: CLOSE csr_cert_enrl;
2420:
2421: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Certification: ' || rec_cert_details.name);
2422: FND_FILE.PUT_LINE(FND_FILE.LOG, '--------------');
2423:
2424: FND_FILE.PUT_LINE(FND_FILE.LOG, 'cert_prd_enrollment_id = ' || rec_cert_details.cert_prd_enrollment_id);
2425: FND_FILE.PUT_LINE(FND_FILE.LOG, 'person_id = ' || rec_cert_details.person_id);

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

2418: FETCH csr_cert_enrl INTO l_cert_enrl_rec;
2419: CLOSE csr_cert_enrl;
2420:
2421: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Certification: ' || rec_cert_details.name);
2422: FND_FILE.PUT_LINE(FND_FILE.LOG, '--------------');
2423:
2424: FND_FILE.PUT_LINE(FND_FILE.LOG, 'cert_prd_enrollment_id = ' || rec_cert_details.cert_prd_enrollment_id);
2425: FND_FILE.PUT_LINE(FND_FILE.LOG, 'person_id = ' || rec_cert_details.person_id);
2426:

Line 2424: FND_FILE.PUT_LINE(FND_FILE.LOG, 'cert_prd_enrollment_id = ' || rec_cert_details.cert_prd_enrollment_id);

2420:
2421: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Certification: ' || rec_cert_details.name);
2422: FND_FILE.PUT_LINE(FND_FILE.LOG, '--------------');
2423:
2424: FND_FILE.PUT_LINE(FND_FILE.LOG, 'cert_prd_enrollment_id = ' || rec_cert_details.cert_prd_enrollment_id);
2425: FND_FILE.PUT_LINE(FND_FILE.LOG, 'person_id = ' || rec_cert_details.person_id);
2426:
2427: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Period Start Date = ' || rec_cert_details.cert_period_start_date);
2428: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Period End Date = ' || rec_cert_details.cert_period_end_date);

Line 2425: FND_FILE.PUT_LINE(FND_FILE.LOG, 'person_id = ' || rec_cert_details.person_id);

2421: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Certification: ' || rec_cert_details.name);
2422: FND_FILE.PUT_LINE(FND_FILE.LOG, '--------------');
2423:
2424: FND_FILE.PUT_LINE(FND_FILE.LOG, 'cert_prd_enrollment_id = ' || rec_cert_details.cert_prd_enrollment_id);
2425: FND_FILE.PUT_LINE(FND_FILE.LOG, 'person_id = ' || rec_cert_details.person_id);
2426:
2427: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Period Start Date = ' || rec_cert_details.cert_period_start_date);
2428: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Period End Date = ' || rec_cert_details.cert_period_end_date);
2429: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Compeletion Date = ' || l_cert_enrl_rec.completion_date);

Line 2427: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Period Start Date = ' || rec_cert_details.cert_period_start_date);

2423:
2424: FND_FILE.PUT_LINE(FND_FILE.LOG, 'cert_prd_enrollment_id = ' || rec_cert_details.cert_prd_enrollment_id);
2425: FND_FILE.PUT_LINE(FND_FILE.LOG, 'person_id = ' || rec_cert_details.person_id);
2426:
2427: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Period Start Date = ' || rec_cert_details.cert_period_start_date);
2428: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Period End Date = ' || rec_cert_details.cert_period_end_date);
2429: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Compeletion Date = ' || l_cert_enrl_rec.completion_date);
2430: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Earliest Enroll Date = ' || l_cert_enrl_rec.earliest_enroll_date);
2431: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Expiration Date = ' || rec_cert_details.expiration_date);

Line 2428: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Period End Date = ' || rec_cert_details.cert_period_end_date);

2424: FND_FILE.PUT_LINE(FND_FILE.LOG, 'cert_prd_enrollment_id = ' || rec_cert_details.cert_prd_enrollment_id);
2425: FND_FILE.PUT_LINE(FND_FILE.LOG, 'person_id = ' || rec_cert_details.person_id);
2426:
2427: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Period Start Date = ' || rec_cert_details.cert_period_start_date);
2428: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Period End Date = ' || rec_cert_details.cert_period_end_date);
2429: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Compeletion Date = ' || l_cert_enrl_rec.completion_date);
2430: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Earliest Enroll Date = ' || l_cert_enrl_rec.earliest_enroll_date);
2431: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Expiration Date = ' || rec_cert_details.expiration_date);
2432:

Line 2429: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Compeletion Date = ' || l_cert_enrl_rec.completion_date);

2425: FND_FILE.PUT_LINE(FND_FILE.LOG, 'person_id = ' || rec_cert_details.person_id);
2426:
2427: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Period Start Date = ' || rec_cert_details.cert_period_start_date);
2428: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Period End Date = ' || rec_cert_details.cert_period_end_date);
2429: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Compeletion Date = ' || l_cert_enrl_rec.completion_date);
2430: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Earliest Enroll Date = ' || l_cert_enrl_rec.earliest_enroll_date);
2431: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Expiration Date = ' || rec_cert_details.expiration_date);
2432:
2433: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Period Start Date = ' || l_cert_period_start_date);

Line 2430: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Earliest Enroll Date = ' || l_cert_enrl_rec.earliest_enroll_date);

2426:
2427: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Period Start Date = ' || rec_cert_details.cert_period_start_date);
2428: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Period End Date = ' || rec_cert_details.cert_period_end_date);
2429: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Compeletion Date = ' || l_cert_enrl_rec.completion_date);
2430: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Earliest Enroll Date = ' || l_cert_enrl_rec.earliest_enroll_date);
2431: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Expiration Date = ' || rec_cert_details.expiration_date);
2432:
2433: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Period Start Date = ' || l_cert_period_start_date);
2434: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Period End Date = ' || l_cert_period_end_date);

Line 2431: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Expiration Date = ' || rec_cert_details.expiration_date);

2427: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Period Start Date = ' || rec_cert_details.cert_period_start_date);
2428: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Period End Date = ' || rec_cert_details.cert_period_end_date);
2429: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Compeletion Date = ' || l_cert_enrl_rec.completion_date);
2430: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Earliest Enroll Date = ' || l_cert_enrl_rec.earliest_enroll_date);
2431: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Expiration Date = ' || rec_cert_details.expiration_date);
2432:
2433: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Period Start Date = ' || l_cert_period_start_date);
2434: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Period End Date = ' || l_cert_period_end_date);
2435: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Compeletion Date = ' || l_cert_completion_date);

Line 2433: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Period Start Date = ' || l_cert_period_start_date);

2429: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Compeletion Date = ' || l_cert_enrl_rec.completion_date);
2430: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Earliest Enroll Date = ' || l_cert_enrl_rec.earliest_enroll_date);
2431: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Expiration Date = ' || rec_cert_details.expiration_date);
2432:
2433: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Period Start Date = ' || l_cert_period_start_date);
2434: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Period End Date = ' || l_cert_period_end_date);
2435: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Compeletion Date = ' || l_cert_completion_date);
2436: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Earliest Enroll Date = ' || l_earliest_enroll_date);
2437: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Expiration Date = ' || l_expiration_date);

Line 2434: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Period End Date = ' || l_cert_period_end_date);

2430: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Earliest Enroll Date = ' || l_cert_enrl_rec.earliest_enroll_date);
2431: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Expiration Date = ' || rec_cert_details.expiration_date);
2432:
2433: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Period Start Date = ' || l_cert_period_start_date);
2434: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Period End Date = ' || l_cert_period_end_date);
2435: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Compeletion Date = ' || l_cert_completion_date);
2436: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Earliest Enroll Date = ' || l_earliest_enroll_date);
2437: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Expiration Date = ' || l_expiration_date);
2438: FND_FILE.PUT_LINE(FND_FILE.LOG, '--------------------------------------------------------');

Line 2435: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Compeletion Date = ' || l_cert_completion_date);

2431: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Expiration Date = ' || rec_cert_details.expiration_date);
2432:
2433: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Period Start Date = ' || l_cert_period_start_date);
2434: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Period End Date = ' || l_cert_period_end_date);
2435: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Compeletion Date = ' || l_cert_completion_date);
2436: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Earliest Enroll Date = ' || l_earliest_enroll_date);
2437: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Expiration Date = ' || l_expiration_date);
2438: FND_FILE.PUT_LINE(FND_FILE.LOG, '--------------------------------------------------------');
2439:

Line 2436: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Earliest Enroll Date = ' || l_earliest_enroll_date);

2432:
2433: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Period Start Date = ' || l_cert_period_start_date);
2434: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Period End Date = ' || l_cert_period_end_date);
2435: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Compeletion Date = ' || l_cert_completion_date);
2436: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Earliest Enroll Date = ' || l_earliest_enroll_date);
2437: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Expiration Date = ' || l_expiration_date);
2438: FND_FILE.PUT_LINE(FND_FILE.LOG, '--------------------------------------------------------');
2439:
2440: ota_cert_enrollment_api.update_cert_enrollment

Line 2437: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Expiration Date = ' || l_expiration_date);

2433: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Period Start Date = ' || l_cert_period_start_date);
2434: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Period End Date = ' || l_cert_period_end_date);
2435: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Compeletion Date = ' || l_cert_completion_date);
2436: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Earliest Enroll Date = ' || l_earliest_enroll_date);
2437: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Expiration Date = ' || l_expiration_date);
2438: FND_FILE.PUT_LINE(FND_FILE.LOG, '--------------------------------------------------------');
2439:
2440: ota_cert_enrollment_api.update_cert_enrollment
2441: (p_effective_date => sysdate

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

2434: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Period End Date = ' || l_cert_period_end_date);
2435: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Compeletion Date = ' || l_cert_completion_date);
2436: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Earliest Enroll Date = ' || l_earliest_enroll_date);
2437: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Expiration Date = ' || l_expiration_date);
2438: FND_FILE.PUT_LINE(FND_FILE.LOG, '--------------------------------------------------------');
2439:
2440: ota_cert_enrollment_api.update_cert_enrollment
2441: (p_effective_date => sysdate
2442: ,p_cert_enrollment_id => l_cert_enrl_rec.cert_enrollment_id

Line 2475: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sync Late Subscription to certification with classes is completed.');

2471: END LOOP;
2472: END LOOP;
2473: END LOOP;
2474:
2475: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sync Late Subscription to certification with classes is completed.');
2476:
2477: EXCEPTION when others then
2478: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc ||','||SUBSTR(SQLERRM, 1, 500));
2479: end sync_late_subsc_to_class;

Line 2478: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc ||','||SUBSTR(SQLERRM, 1, 500));

2474:
2475: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sync Late Subscription to certification with classes is completed.');
2476:
2477: EXCEPTION when others then
2478: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc ||','||SUBSTR(SQLERRM, 1, 500));
2479: end sync_late_subsc_to_class;
2480: --
2481:
2482: END OTA_CPE_UTIL;