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 HR_UTILITY

Line 56: hr_utility.set_location('Entering:'|| l_proc, 10);

52: l_item_key wf_items.item_key%type;
53:
54: begin
55:
56: hr_utility.set_location('Entering:'|| l_proc, 10);
57:
58: for rec in get_crt_prd_enrollments
59: Loop
60: if ('Y' = ota_cpe_util.is_cert_success_complete(p_cert_prd_enrollment_id => rec.cert_prd_enrollment_id,

Line 75: hr_utility.set_location('Leaving:'|| l_proc, 10);

71:
72: end if;
73:
74: end loop;
75: hr_utility.set_location('Leaving:'|| l_proc, 10);
76: end crt_comp_upd_succ_att;
77:
78: -- ---------------------------------------------------------------------------
79: -- |----------------------< is_cert_success_complete >-----------------------------|

Line 139: hr_utility.trace('Batra act_id' || I.Activity_version_id);

135: l_succ_att_flag varchar2(5);
136: l_cls_enr_exists varchar2(1) := 'N' ;
137: Begin
138: For I in Csr_Cert_mbr Loop
139: hr_utility.trace('Batra act_id' || I.Activity_version_id);
140:
141: for rec in Csr_Crt_mbr_cls_status(I.Activity_version_id)
142: Loop
143: l_cls_enr_exists := 'Y' ;

Line 145: hr_utility.trace('Batra l_succ_att_flag' || l_succ_att_flag);

141: for rec in Csr_Crt_mbr_cls_status(I.Activity_version_id)
142: Loop
143: l_cls_enr_exists := 'Y' ;
144: l_succ_att_flag := rec.successful_attendance_flag;
145: hr_utility.trace('Batra l_succ_att_flag' || l_succ_att_flag);
146: /* If Csr_Crt_mbr_cls_status%Notfound then
147: hr_utility.trace('Batra in crs not found l_succ_att_flag' || I.Activity_version_id);
148: l_mbr_cls_succ_att_flag := 'N' ;
149: exit ;

Line 147: hr_utility.trace('Batra in crs not found l_succ_att_flag' || I.Activity_version_id);

143: l_cls_enr_exists := 'Y' ;
144: l_succ_att_flag := rec.successful_attendance_flag;
145: hr_utility.trace('Batra l_succ_att_flag' || l_succ_att_flag);
146: /* If Csr_Crt_mbr_cls_status%Notfound then
147: hr_utility.trace('Batra in crs not found l_succ_att_flag' || I.Activity_version_id);
148: l_mbr_cls_succ_att_flag := 'N' ;
149: exit ;
150: Else*/
151: If Nvl(l_succ_att_flag,'N') = 'Y' then

Line 152: hr_utility.trace('Batra l_succ_att_flag Y' || I.Activity_version_id);

148: l_mbr_cls_succ_att_flag := 'N' ;
149: exit ;
150: Else*/
151: If Nvl(l_succ_att_flag,'N') = 'Y' then
152: hr_utility.trace('Batra l_succ_att_flag Y' || I.Activity_version_id);
153: l_mbr_cls_succ_att_flag := 'Y' ;
154: exit ;
155: Else
156: hr_utility.trace('Batra in else of l_succ_att_flag' || l_succ_att_flag);

Line 156: hr_utility.trace('Batra in else of l_succ_att_flag' || l_succ_att_flag);

152: hr_utility.trace('Batra l_succ_att_flag Y' || I.Activity_version_id);
153: l_mbr_cls_succ_att_flag := 'Y' ;
154: exit ;
155: Else
156: hr_utility.trace('Batra in else of l_succ_att_flag' || l_succ_att_flag);
157: l_mbr_cls_succ_att_flag := 'N' ;
158: exit ;
159: End If;
160: -- End If ;

Line 171: hr_utility.trace('Batra before return' || l_mbr_cls_succ_att_flag);

167: End if ;
168: --close Csr_Crt_mbr_cls_status;
169:
170: End Loop;
171: hr_utility.trace('Batra before return' || l_mbr_cls_succ_att_flag);
172: return l_mbr_cls_succ_att_flag;
173:
174: end is_cert_success_complete;
175:

Line 205: hr_utility.set_location(' Entering:' || l_proc,10);

201: l_result varchar2(3) :='F';
202:
203: Begin
204:
205: hr_utility.set_location(' Entering:' || l_proc,10);
206:
207: open any_child;
208: fetch any_child into l_exists;
209: if any_child%NOTFOUND then

Line 223: hr_utility.set_location('Leaving :'||l_proc,15);

219: return l_result;
220:
221: EXCEPTION
222: WHEN others THEN
223: hr_utility.set_location('Leaving :'||l_proc,15);
224: RETURN NULL;
225:
226: end chk_cert_prd_compl;
227:

Line 296: hr_utility.set_location(' Entering:' || l_proc,10);

292: l_unenrollment_date DATE;
293:
294: Begin
295:
296: hr_utility.set_location(' Entering:' || l_proc,10);
297:
298: if p_child_update_flag = 'Y' then
299: for rec_mbr_enrl in csr_mbr_enrl
300: loop

Line 421: hr_utility.set_location(' Leaving:' || l_proc,50);

417: --
418: -- Reset IN OUT and set OUT parameters
419: --
420: p_certification_status_code := null;
421: hr_utility.set_location(' Leaving:' || l_proc,50);
422: raise;
423: end update_cpe_status;
424:
425:

Line 467: hr_utility.set_location('Entering :'||l_proc,5);

463: l_return_val varchar2(1) := 'N';
464: l_max_expiration_date date;
465:
466: Begin
467: hr_utility.set_location('Entering :'||l_proc,5);
468:
469: --return N for non renewal certs
470: OPEN csr_crt;
471: FETCH csr_crt INTO rec_crt;

Line 522: hr_utility.set_location('Leaving :'||l_proc,10);

518: end if;
519: end if;
520: end if;
521:
522: hr_utility.set_location('Leaving :'||l_proc,10);
523:
524: return l_return_val;
525:
526: EXCEPTION

Line 528: hr_utility.set_location('Leaving :'||l_proc,15);

524: return l_return_val;
525:
526: EXCEPTION
527: WHEN others THEN
528: hr_utility.set_location('Leaving :'||l_proc,15);
529:
530: RETURN null;
531:
532: End is_period_renewable;

Line 568: hr_utility.set_location('Entering :'||l_proc,5);

564:
565:
566: BEGIN
567:
568: hr_utility.set_location('Entering :'||l_proc,5);
569:
570: OPEN csr_crt;
571: FETCH csr_crt INTO rec_crt;
572: CLOSE csr_crt;

Line 604: hr_utility.set_location('Leaving :'||l_proc,10);

600: end if;
601: */
602: end if;
603:
604: hr_utility.set_location('Leaving :'||l_proc,10);
605:
606: return l_next_earliest_enroll_date;
607:
608: EXCEPTION

Line 610: hr_utility.set_location('Leaving :'||l_proc,15);

606: return l_next_earliest_enroll_date;
607:
608: EXCEPTION
609: WHEN others THEN
610: hr_utility.set_location('Leaving :'||l_proc,15);
611: RETURN NULL;
612:
613: end get_earl_enrl_dt;
614:

Line 675: hr_utility.set_location('Entering :'||l_proc,5);

671: l_next_earliest_enroll_date ota_cert_enrollments.earliest_enroll_date%type;
672: l_next_expiration_date ota_cert_enrollments.expiration_date%type;
673:
674: BEGIN
675: hr_utility.set_location('Entering :'||l_proc,5);
676:
677: l_curr_dt := trunc(nvl(p_cert_period_start_date, sysdate));
678:
679: OPEN csr_crt;

Line 822: hr_utility.set_location('Leaving :'||l_proc,10);

818: p_earliest_enroll_date := l_next_earliest_enroll_date;
819: p_expiration_date := l_next_expiration_date;
820: end if; --pmode check
821:
822: hr_utility.set_location('Leaving :'||l_proc,10);
823:
824: EXCEPTION
825: WHEN others THEN
826: hr_utility.set_location('LEAVING:'|| l_proc, 30);

Line 826: hr_utility.set_location('LEAVING:'|| l_proc, 30);

822: hr_utility.set_location('Leaving :'||l_proc,10);
823:
824: EXCEPTION
825: WHEN others THEN
826: hr_utility.set_location('LEAVING:'|| l_proc, 30);
827: p_earliest_enroll_date := null;
828: p_expiration_date := null;
829: RAISE;
830: END calc_cre_dates;

Line 874: hr_utility.set_location('Entering :'||l_proc,5);

870: l_elapsed_due_date date;
871:
872: BEGIN
873:
874: hr_utility.set_location('Entering :'||l_proc,5);
875:
876: OPEN csr_crt;
877: FETCH csr_crt INTO rec_crt;
878: CLOSE csr_crt;

Line 930: hr_utility.set_location('Leaving :'||l_proc,10);

926: end if;
927:
928: l_prd_durn := '' || l_prd_durn;
929:
930: hr_utility.set_location('Leaving :'||l_proc,10);
931:
932: return l_prd_durn;
933:
934: EXCEPTION

Line 936: hr_utility.set_location('Leaving :'||l_proc,15);

932: return l_prd_durn;
933:
934: EXCEPTION
935: WHEN others THEN
936: hr_utility.set_location('Leaving :'||l_proc,15);
937: RETURN null;
938:
939: end get_next_prd_dur_days;
940: --

Line 1072: hr_utility.set_location('Leaving :'||l_proc,15);

1068: end if;
1069:
1070: EXCEPTION
1071: WHEN others THEN
1072: hr_utility.set_location('Leaving :'||l_proc,15);
1073: RETURN null;
1074:
1075: End get_cre_status;
1076:

Line 1107: hr_utility.set_location('Leaving :'||l_proc,15);

1103:
1104:
1105: EXCEPTION
1106: WHEN others THEN
1107: hr_utility.set_location('Leaving :'||l_proc,15);
1108: RETURN null;
1109:
1110: End get_cpe_edit_enabled;
1111:

Line 1142: hr_utility.set_location(' Leaving:'||l_proc, 10);

1138: l_return_status varchar2(1):= 'S';
1139: l_bypass_flag varchar2(1) := 'N';
1140:
1141: BEGIN
1142: hr_utility.set_location(' Leaving:'||l_proc, 10);
1143:
1144: if p_mass_update_flag = 'N' then
1145: hr_multi_message.enable_message_list;
1146: end if;

Line 1178: hr_utility.set_location(' Leaving:'||l_proc, 20);

1174: end if;
1175: end if;
1176: end if;
1177:
1178: hr_utility.set_location(' Leaving:'||l_proc, 20);
1179:
1180: if p_mass_update_flag = 'N' then
1181: l_return_status := hr_multi_message.get_return_status_disable;
1182: end if;

Line 1189: hr_utility.set_location(' Leaving:'||l_proc, 25);

1185:
1186: EXCEPTION
1187:
1188: WHEN app_exception.application_exception THEN
1189: hr_utility.set_location(' Leaving:'||l_proc, 25);
1190:
1191: if p_mass_update_flag = 'N' then
1192: if hr_multi_message.exception_add(p_associated_column1 => 'OTA_CERT_PRD_ENROLLMENTS.CERT_PERIOD_END_DATE') then
1193: return hr_multi_message.get_return_status_disable;

Line 1203: hr_utility.set_location('Leaving :'||l_proc,30);

1199:
1200: return l_return_status;
1201:
1202: WHEN others THEN
1203: hr_utility.set_location('Leaving :'||l_proc,30);
1204: if p_mass_update_flag = 'N' then
1205: l_return_status := hr_multi_message.get_return_status_disable;
1206: else
1207: l_return_status := 'E';

Line 1593: hr_utility.set_location(' Leaving:' || l_proc,50);

1589: -- Reset IN OUT and set OUT parameters
1590: --
1591: p_cert_prd_enrollment_id := null;
1592: p_certification_status_code := null;
1593: hr_utility.set_location(' Leaving:' || l_proc,50);
1594: raise;
1595: end create_cpe_rec;
1596:
1597: PROCEDURE delete_prd_cascade(p_cert_prd_enrollment_id IN ota_cert_prd_enrollments.cert_prd_enrollment_id%type,

Line 1711: hr_utility.set_location(' Entering:' || l_proc,10);

1707: l_old_status_code ota_cert_enrollments.certification_status_code%type;
1708: l_cert_upd_comp varchar2(1);
1709: Begin
1710:
1711: hr_utility.set_location(' Entering:' || l_proc,10);
1712: hr_utility.set_location(' p_certification_status_code is :' || l_proc || p_certification_status_code,100);
1713:
1714: OPEN csr_prd_enrl;
1715: FETCH csr_prd_enrl INTO l_prd_enrl_rec;

Line 1712: hr_utility.set_location(' p_certification_status_code is :' || l_proc || p_certification_status_code,100);

1708: l_cert_upd_comp varchar2(1);
1709: Begin
1710:
1711: hr_utility.set_location(' Entering:' || l_proc,10);
1712: hr_utility.set_location(' p_certification_status_code is :' || l_proc || p_certification_status_code,100);
1713:
1714: OPEN csr_prd_enrl;
1715: FETCH csr_prd_enrl INTO l_prd_enrl_rec;
1716: CLOSE csr_prd_enrl;

Line 1813: hr_utility.set_location(' l_cert_upd_comp is ' ||l_cert_upd_comp || l_proc,10);

1809: ,p_cert_period_end_date => l_cert_period_end_date
1810: ,p_completion_date => l_cert_period_completion_date);
1811: end if;
1812:
1813: hr_utility.set_location(' l_cert_upd_comp is ' ||l_cert_upd_comp || l_proc,10);
1814:
1815: if p_certification_status_code = 'CERTIFIED' and l_cert_upd_comp = 'Y' then
1816: hr_utility.set_location(' Updating competencies'||l_proc,10);
1817: ota_competence_ss.create_wf_process(p_process =>'OTA_COMPETENCE_UPDATE_JSP_PRC',

Line 1816: hr_utility.set_location(' Updating competencies'||l_proc,10);

1812:
1813: hr_utility.set_location(' l_cert_upd_comp is ' ||l_cert_upd_comp || l_proc,10);
1814:
1815: if p_certification_status_code = 'CERTIFIED' and l_cert_upd_comp = 'Y' then
1816: hr_utility.set_location(' Updating competencies'||l_proc,10);
1817: ota_competence_ss.create_wf_process(p_process =>'OTA_COMPETENCE_UPDATE_JSP_PRC',
1818: p_itemtype =>'HRSSA',
1819: p_person_id => l_cert_enrl_rec.person_id,
1820: p_eventid =>null,

Line 1855: hr_utility.set_location('Leaving :'||l_proc,20);

1851: l_return_status := 'S';
1852:
1853: p_return_status := l_return_status;
1854:
1855: hr_utility.set_location('Leaving :'||l_proc,20);
1856:
1857: EXCEPTION
1858: WHEN others THEN
1859: hr_utility.set_location('Leaving :'||l_proc,30);

Line 1859: hr_utility.set_location('Leaving :'||l_proc,30);

1855: hr_utility.set_location('Leaving :'||l_proc,20);
1856:
1857: EXCEPTION
1858: WHEN others THEN
1859: hr_utility.set_location('Leaving :'||l_proc,30);
1860: p_return_status := null;
1861: End update_admin_changes;
1862: --
1863: --

Line 1925: hr_utility.set_location('Entering:'||l_proc, 5);

1921:
1922: l_log_message varchar2(500);
1923:
1924: begin
1925: hr_utility.set_location('Entering:'||l_proc, 5);
1926:
1927: for exp_sts_upd in get_data_for_expiry_status_upd
1928: Loop
1929: if ( trunc(exp_sts_upd.cert_period_end_date) < trunc(sysdate) ) then

Line 1931: hr_utility.set_location('Entering:'||l_proc, 10);

1927: for exp_sts_upd in get_data_for_expiry_status_upd
1928: Loop
1929: if ( trunc(exp_sts_upd.cert_period_end_date) < trunc(sysdate) ) then
1930: begin
1931: hr_utility.set_location('Entering:'||l_proc, 10);
1932: savepoint update_status_to_expired;
1933:
1934: --Update Period CPE status to Expired
1935: ota_cert_prd_enrollment_api.update_cert_prd_enrollment(

Line 1997: hr_utility.set_location('Leaving:'||l_proc, 5);

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
2001: ||','||SUBSTR(SQLERRM, 1, 500));

Line 2038: hr_utility.set_location('Entering:'||l_proc, 5);

2034: l_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE;
2035:
2036: begin
2037:
2038: hr_utility.set_location('Entering:'||l_proc, 5);
2039:
2040: sync_late_subsc_to_class;
2041:
2042: for rec_cpe_status in csr_cpe_status

Line 2044: hr_utility.set_location('Step:'||l_proc, 10);

2040: sync_late_subsc_to_class;
2041:
2042: for rec_cpe_status in csr_cpe_status
2043: loop
2044: hr_utility.set_location('Step:'||l_proc, 10);
2045: for rec_acty_info in csr_acty_info(rec_cpe_status.cert_prd_enrollment_id)
2046: loop
2047: hr_utility.set_location('Step:'||l_proc, 10.1);
2048: -- get latest class enrollment status

Line 2047: hr_utility.set_location('Step:'||l_proc, 10.1);

2043: loop
2044: hr_utility.set_location('Step:'||l_proc, 10);
2045: for rec_acty_info in csr_acty_info(rec_cpe_status.cert_prd_enrollment_id)
2046: loop
2047: hr_utility.set_location('Step:'||l_proc, 10.1);
2048: -- get latest class enrollment status
2049: ota_cme_util.get_enrl_status_on_update(rec_acty_info.object_id,
2050: rec_cpe_status.cert_prd_enrollment_id,
2051: l_booking_status_type,

Line 2060: hr_utility.set_location('Step:'||l_proc, 10.2);

2056: if rec_cpe_status.period_status_code <> 'EXPIRED' then
2057: if trunc(l_date_status_changed) = trunc(rec_cpe_status.cert_period_start_date) then
2058: --scenarios 1 and 2
2059: -- for 'Attended' class enroll status perform status rollup for CURRENT CPE
2060: hr_utility.set_location('Step:'||l_proc, 10.2);
2061: do_update := true;
2062: end if;
2063: end if;
2064: else

Line 2067: hr_utility.set_location('Step:'||l_proc, 10.3);

2063: end if;
2064: else
2065: --scenarios 3 and 4
2066: -- for any class enroll status changes this would update child of EXPIRED CPE and status rollup for CURRENT CPE
2067: hr_utility.set_location('Step:'||l_proc, 10.3);
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);

Line 2080: hr_utility.set_location('Entering:'||l_proc, 20);

2076: do_update := false;
2077: end loop;
2078: end loop;
2079:
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');

Line 2086: hr_utility.set_location('Leaving:'||l_proc, 30);

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
2089: when others then
2090: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc

Line 2111: hr_utility.set_location('Entering:'||l_proc, 5);

2107: l_proc VARCHAR2(72) := g_package||' get_latest_cpe_col';
2108: rec_latest_cpe csr_latest_cpe%rowtype;
2109:
2110: Begin
2111: hr_utility.set_location('Entering:'||l_proc, 5);
2112:
2113: open csr_latest_cpe;
2114: fetch csr_latest_cpe into rec_latest_cpe;
2115: close csr_latest_cpe;

Line 2117: hr_utility.set_location('Leaving:'||l_proc, 10);

2113: open csr_latest_cpe;
2114: fetch csr_latest_cpe into rec_latest_cpe;
2115: close csr_latest_cpe;
2116:
2117: hr_utility.set_location('Leaving:'||l_proc, 10);
2118:
2119: if upper(p_col_name) = upper('Cert_Prd_Enrollment_Id') then
2120: return rec_latest_cpe.Cert_Prd_Enrollment_id;
2121: elsif upper(p_col_name) = upper('Period_Status_Code') then

Line 2129: hr_utility.set_location('Leaving :'||l_proc,15);

2125: end if;
2126:
2127: EXCEPTION
2128: WHEN others THEN
2129: hr_utility.set_location('Leaving :'||l_proc,15);
2130: RETURN null;
2131:
2132: End get_latest_cpe_col;
2133:

Line 2154: hr_utility.set_location('Entering :'||l_proc,5);

2150: l_curr_dt date;
2151:
2152: BEGIN
2153:
2154: hr_utility.set_location('Entering :'||l_proc,5);
2155:
2156: l_curr_dt := trunc(sysdate);
2157:
2158: OPEN csr_crt;

Line 2175: hr_utility.set_location('Leaving :'||l_proc,10);

2171: EXIT WHEN l_curr_dt < l_elapsed_due_date;
2172: end loop;
2173: end if;
2174:
2175: hr_utility.set_location('Leaving :'||l_proc,10);
2176:
2177: return l_elapsed_due_date;
2178:
2179: EXCEPTION

Line 2181: hr_utility.set_location('Leaving :'||l_proc,15);

2177: return l_elapsed_due_date;
2178:
2179: EXCEPTION
2180: WHEN others THEN
2181: hr_utility.set_location('Leaving :'||l_proc,15);
2182: RETURN NULL;
2183: end get_elapsed_due_date;
2184:
2185: function check_active_periods(p_event_id ota_events.event_id%type) return varchar2

Line 2235: hr_utility.set_location('Entering:'||l_proc, 10);

2231: l_dummy varchar2(10);
2232:
2233: Begin
2234:
2235: hr_utility.set_location('Entering:'||l_proc, 10);
2236:
2237: open csr_onl_sync_flag;
2238: fetch csr_onl_sync_flag into rec_onl_sync_flag;
2239: close csr_onl_sync_flag;

Line 2262: hr_utility.set_location('Leaving :'||l_proc, 30);

2258: close csr_chk_prds;
2259:
2260: end if;
2261:
2262: hr_utility.set_location('Leaving :'||l_proc, 30);
2263:
2264: return l_return_value;
2265:
2266: EXCEPTION

Line 2268: hr_utility.set_location('Leaving :'||l_proc,40);

2264: return l_return_value;
2265:
2266: EXCEPTION
2267: WHEN others THEN
2268: hr_utility.set_location('Leaving :'||l_proc,40);
2269: return l_return_value;
2270: END check_active_periods;
2271:
2272: /* Late Subscription or late renewal to certifications