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 1953: FND_FILE.PUT_LINE(FND_FILE.LOG, l_log_message);

1949: else
1950: l_log_message := l_log_message || ' for contact id ' || exp_sts_upd.contact_id;
1951: end if;
1952:
1953: FND_FILE.PUT_LINE(FND_FILE.LOG, l_log_message);
1954:
1955: --Update Cert CRE status to Expired
1956: for exp_records in get_data_for_expired_records(exp_sts_upd.cert_prd_enrollment_id)
1957: Loop

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

1976: l_log_message := l_log_message || ' for person id ' || exp_records.person_id;
1977: else
1978: l_log_message := l_log_message || ' for contact id ' || exp_records.contact_id;
1979: end if;
1980: FND_FILE.PUT_LINE(FND_FILE.LOG, l_log_message);
1981: end if;
1982: End Loop;
1983: EXCEPTION
1984: WHEN OTHERS then

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

1981: end if;
1982: End Loop;
1983: EXCEPTION
1984: WHEN OTHERS then
1985: FND_FILE.PUT_LINE(FND_FILE.LOG, 'When Others Error occured in, '
1986: || 'Update to cpe cre calls ,' || 'Cert_Prd_Enrollment_Id=' || to_char(exp_sts_upd.cert_prd_enrollment_id)
1987: ||',' || 'Cert_Enrollment_Id=' || to_char(exp_sts_upd.cert_enrollment_id)
1988: || ',' || SUBSTR(SQLERRM, 1, 500));
1989:

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

1992: end if;
1993: End Loop;
1994:
1995: commit;
1996: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Data committed to database');
1997: hr_utility.set_location('Leaving:'||l_proc, 5);
1998: EXCEPTION
1999: when others then
2000: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc

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

1996: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Data committed to database');
1997: hr_utility.set_location('Leaving:'||l_proc, 5);
1998: EXCEPTION
1999: when others then
2000: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc
2001: ||','||SUBSTR(SQLERRM, 1, 500));
2002: end update_cert_status_to_expired;
2003: --
2004: Procedure sync_cert_status_to_class_enrl(

Line 2072: 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);

2068: do_update := true;
2069: end if;
2070: if do_update then
2071: ota_cme_util.update_cme_status(rec_acty_info.cert_mbr_enrollment_id);
2072: 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);
2073: ota_cme_util.update_cpe_status(rec_acty_info.cert_mbr_enrollment_id, l_cert_prd_enrollment_id, trunc(l_date_status_changed));
2074: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Updated the Certification period status for the cert_prd_enrollment_id = ' || l_cert_prd_enrollment_id);
2075: end if;
2076: do_update := false;

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

2070: if do_update then
2071: ota_cme_util.update_cme_status(rec_acty_info.cert_mbr_enrollment_id);
2072: 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);
2073: ota_cme_util.update_cpe_status(rec_acty_info.cert_mbr_enrollment_id, l_cert_prd_enrollment_id, trunc(l_date_status_changed));
2074: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Updated the Certification period status for the cert_prd_enrollment_id = ' || l_cert_prd_enrollment_id);
2075: end if;
2076: do_update := false;
2077: end loop;
2078: end loop;

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

2080: hr_utility.set_location('Entering:'||l_proc, 20);
2081:
2082: commit;
2083:
2084: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Data committed to database');
2085:
2086: hr_utility.set_location('Leaving:'||l_proc, 30);
2087:
2088: EXCEPTION

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

2086: hr_utility.set_location('Leaving:'||l_proc, 30);
2087:
2088: EXCEPTION
2089: when others then
2090: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc
2091: ||','||SUBSTR(SQLERRM, 1, 500));
2092: end sync_cert_status_to_class_enrl;
2093: --
2094: FUNCTION get_latest_cpe_col(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%TYPE,

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

2421: l_expiration_date ota_cert_prd_enrollments.expiration_date%type;
2422:
2423: begin
2424:
2425: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sync Late Subscription to certification with classes');
2426:
2427: FOR rec_cert_details in csr_cert_details loop
2428: FOR rec_course_info in csr_course_info(rec_cert_details.cert_prd_enrollment_id) loop
2429: FOR rec_enr IN get_enrl_status(rec_course_info.object_id,

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

2456: OPEN csr_cert_enrl(rec_cert_details.cert_enrollment_id);
2457: FETCH csr_cert_enrl INTO l_cert_enrl_rec;
2458: CLOSE csr_cert_enrl;
2459:
2460: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Certification: ' || rec_cert_details.name);
2461: FND_FILE.PUT_LINE(FND_FILE.LOG, '--------------');
2462:
2463: FND_FILE.PUT_LINE(FND_FILE.LOG, 'cert_prd_enrollment_id = ' || rec_cert_details.cert_prd_enrollment_id);
2464: FND_FILE.PUT_LINE(FND_FILE.LOG, 'person_id = ' || rec_cert_details.person_id);

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

2457: FETCH csr_cert_enrl INTO l_cert_enrl_rec;
2458: CLOSE csr_cert_enrl;
2459:
2460: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Certification: ' || rec_cert_details.name);
2461: FND_FILE.PUT_LINE(FND_FILE.LOG, '--------------');
2462:
2463: FND_FILE.PUT_LINE(FND_FILE.LOG, 'cert_prd_enrollment_id = ' || rec_cert_details.cert_prd_enrollment_id);
2464: FND_FILE.PUT_LINE(FND_FILE.LOG, 'person_id = ' || rec_cert_details.person_id);
2465:

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

2459:
2460: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Certification: ' || rec_cert_details.name);
2461: FND_FILE.PUT_LINE(FND_FILE.LOG, '--------------');
2462:
2463: FND_FILE.PUT_LINE(FND_FILE.LOG, 'cert_prd_enrollment_id = ' || rec_cert_details.cert_prd_enrollment_id);
2464: FND_FILE.PUT_LINE(FND_FILE.LOG, 'person_id = ' || rec_cert_details.person_id);
2465:
2466: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Period Start Date = ' || rec_cert_details.cert_period_start_date);
2467: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Period End Date = ' || rec_cert_details.cert_period_end_date);

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

2460: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Certification: ' || rec_cert_details.name);
2461: FND_FILE.PUT_LINE(FND_FILE.LOG, '--------------');
2462:
2463: FND_FILE.PUT_LINE(FND_FILE.LOG, 'cert_prd_enrollment_id = ' || rec_cert_details.cert_prd_enrollment_id);
2464: FND_FILE.PUT_LINE(FND_FILE.LOG, 'person_id = ' || rec_cert_details.person_id);
2465:
2466: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Period Start Date = ' || rec_cert_details.cert_period_start_date);
2467: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Period End Date = ' || rec_cert_details.cert_period_end_date);
2468: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Compeletion Date = ' || l_cert_enrl_rec.completion_date);

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

2462:
2463: FND_FILE.PUT_LINE(FND_FILE.LOG, 'cert_prd_enrollment_id = ' || rec_cert_details.cert_prd_enrollment_id);
2464: FND_FILE.PUT_LINE(FND_FILE.LOG, 'person_id = ' || rec_cert_details.person_id);
2465:
2466: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Period Start Date = ' || rec_cert_details.cert_period_start_date);
2467: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Period End Date = ' || rec_cert_details.cert_period_end_date);
2468: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Compeletion Date = ' || l_cert_enrl_rec.completion_date);
2469: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Earliest Enroll Date = ' || l_cert_enrl_rec.earliest_enroll_date);
2470: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Expiration Date = ' || rec_cert_details.expiration_date);

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

2463: FND_FILE.PUT_LINE(FND_FILE.LOG, 'cert_prd_enrollment_id = ' || rec_cert_details.cert_prd_enrollment_id);
2464: FND_FILE.PUT_LINE(FND_FILE.LOG, 'person_id = ' || rec_cert_details.person_id);
2465:
2466: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Period Start Date = ' || rec_cert_details.cert_period_start_date);
2467: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Period End Date = ' || rec_cert_details.cert_period_end_date);
2468: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Compeletion Date = ' || l_cert_enrl_rec.completion_date);
2469: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Earliest Enroll Date = ' || l_cert_enrl_rec.earliest_enroll_date);
2470: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Expiration Date = ' || rec_cert_details.expiration_date);
2471:

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

2464: FND_FILE.PUT_LINE(FND_FILE.LOG, 'person_id = ' || rec_cert_details.person_id);
2465:
2466: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Period Start Date = ' || rec_cert_details.cert_period_start_date);
2467: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Period End Date = ' || rec_cert_details.cert_period_end_date);
2468: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Compeletion Date = ' || l_cert_enrl_rec.completion_date);
2469: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Earliest Enroll Date = ' || l_cert_enrl_rec.earliest_enroll_date);
2470: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Expiration Date = ' || rec_cert_details.expiration_date);
2471:
2472: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Period Start Date = ' || l_cert_period_start_date);

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

2465:
2466: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Period Start Date = ' || rec_cert_details.cert_period_start_date);
2467: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Period End Date = ' || rec_cert_details.cert_period_end_date);
2468: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Compeletion Date = ' || l_cert_enrl_rec.completion_date);
2469: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Earliest Enroll Date = ' || l_cert_enrl_rec.earliest_enroll_date);
2470: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Expiration Date = ' || rec_cert_details.expiration_date);
2471:
2472: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Period Start Date = ' || l_cert_period_start_date);
2473: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Period End Date = ' || l_cert_period_end_date);

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

2466: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Period Start Date = ' || rec_cert_details.cert_period_start_date);
2467: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Period End Date = ' || rec_cert_details.cert_period_end_date);
2468: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Compeletion Date = ' || l_cert_enrl_rec.completion_date);
2469: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Earliest Enroll Date = ' || l_cert_enrl_rec.earliest_enroll_date);
2470: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Expiration Date = ' || rec_cert_details.expiration_date);
2471:
2472: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Period Start Date = ' || l_cert_period_start_date);
2473: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Period End Date = ' || l_cert_period_end_date);
2474: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Compeletion Date = ' || l_cert_completion_date);

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

2468: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Compeletion Date = ' || l_cert_enrl_rec.completion_date);
2469: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Earliest Enroll Date = ' || l_cert_enrl_rec.earliest_enroll_date);
2470: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Expiration Date = ' || rec_cert_details.expiration_date);
2471:
2472: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Period Start Date = ' || l_cert_period_start_date);
2473: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Period End Date = ' || l_cert_period_end_date);
2474: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Compeletion Date = ' || l_cert_completion_date);
2475: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Earliest Enroll Date = ' || l_earliest_enroll_date);
2476: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Expiration Date = ' || l_expiration_date);

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

2469: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Earliest Enroll Date = ' || l_cert_enrl_rec.earliest_enroll_date);
2470: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Expiration Date = ' || rec_cert_details.expiration_date);
2471:
2472: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Period Start Date = ' || l_cert_period_start_date);
2473: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Period End Date = ' || l_cert_period_end_date);
2474: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Compeletion Date = ' || l_cert_completion_date);
2475: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Earliest Enroll Date = ' || l_earliest_enroll_date);
2476: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Expiration Date = ' || l_expiration_date);
2477: FND_FILE.PUT_LINE(FND_FILE.LOG, '--------------------------------------------------------');

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

2470: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Old Expiration Date = ' || rec_cert_details.expiration_date);
2471:
2472: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Period Start Date = ' || l_cert_period_start_date);
2473: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Period End Date = ' || l_cert_period_end_date);
2474: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Compeletion Date = ' || l_cert_completion_date);
2475: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Earliest Enroll Date = ' || l_earliest_enroll_date);
2476: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Expiration Date = ' || l_expiration_date);
2477: FND_FILE.PUT_LINE(FND_FILE.LOG, '--------------------------------------------------------');
2478:

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

2471:
2472: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Period Start Date = ' || l_cert_period_start_date);
2473: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Period End Date = ' || l_cert_period_end_date);
2474: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Compeletion Date = ' || l_cert_completion_date);
2475: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Earliest Enroll Date = ' || l_earliest_enroll_date);
2476: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Expiration Date = ' || l_expiration_date);
2477: FND_FILE.PUT_LINE(FND_FILE.LOG, '--------------------------------------------------------');
2478:
2479: ota_cert_enrollment_api.update_cert_enrollment

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

2472: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Period Start Date = ' || l_cert_period_start_date);
2473: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Period End Date = ' || l_cert_period_end_date);
2474: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Compeletion Date = ' || l_cert_completion_date);
2475: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Earliest Enroll Date = ' || l_earliest_enroll_date);
2476: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Expiration Date = ' || l_expiration_date);
2477: FND_FILE.PUT_LINE(FND_FILE.LOG, '--------------------------------------------------------');
2478:
2479: ota_cert_enrollment_api.update_cert_enrollment
2480: (p_effective_date => sysdate

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

2473: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Period End Date = ' || l_cert_period_end_date);
2474: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Compeletion Date = ' || l_cert_completion_date);
2475: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Earliest Enroll Date = ' || l_earliest_enroll_date);
2476: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Expiration Date = ' || l_expiration_date);
2477: FND_FILE.PUT_LINE(FND_FILE.LOG, '--------------------------------------------------------');
2478:
2479: ota_cert_enrollment_api.update_cert_enrollment
2480: (p_effective_date => sysdate
2481: ,p_cert_enrollment_id => l_cert_enrl_rec.cert_enrollment_id

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

2510: END LOOP;
2511: END LOOP;
2512: END LOOP;
2513:
2514: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sync Late Subscription to certification with classes is completed.');
2515:
2516: EXCEPTION when others then
2517: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc ||','||SUBSTR(SQLERRM, 1, 500));
2518: end sync_late_subsc_to_class;

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

2513:
2514: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sync Late Subscription to certification with classes is completed.');
2515:
2516: EXCEPTION when others then
2517: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc ||','||SUBSTR(SQLERRM, 1, 500));
2518: end sync_late_subsc_to_class;
2519: --
2520:
2521: END OTA_CPE_UTIL;