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 295: hr_utility.set_location(' Entering:' || l_proc,10);

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

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

409: --
410: -- Reset IN OUT and set OUT parameters
411: --
412: p_certification_status_code := null;
413: hr_utility.set_location(' Leaving:' || l_proc,50);
414: raise;
415: end update_cpe_status;
416:
417:

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

455: l_return_val varchar2(1) := 'N';
456: l_max_expiration_date date;
457:
458: Begin
459: hr_utility.set_location('Entering :'||l_proc,5);
460:
461: --return N for non renewal certs
462: OPEN csr_crt;
463: FETCH csr_crt INTO rec_crt;

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

510: end if;
511: end if;
512: end if;
513:
514: hr_utility.set_location('Leaving :'||l_proc,10);
515:
516: return l_return_val;
517:
518: EXCEPTION

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

516: return l_return_val;
517:
518: EXCEPTION
519: WHEN others THEN
520: hr_utility.set_location('Leaving :'||l_proc,15);
521:
522: RETURN null;
523:
524: End is_period_renewable;

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

556:
557:
558: BEGIN
559:
560: hr_utility.set_location('Entering :'||l_proc,5);
561:
562: OPEN csr_crt;
563: FETCH csr_crt INTO rec_crt;
564: CLOSE csr_crt;

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

592: end if;
593: */
594: end if;
595:
596: hr_utility.set_location('Leaving :'||l_proc,10);
597:
598: return l_next_earliest_enroll_date;
599:
600: EXCEPTION

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

598: return l_next_earliest_enroll_date;
599:
600: EXCEPTION
601: WHEN others THEN
602: hr_utility.set_location('Leaving :'||l_proc,15);
603: RETURN NULL;
604:
605: end get_earl_enrl_dt;
606:

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

663: l_next_earliest_enroll_date ota_cert_enrollments.earliest_enroll_date%type;
664: l_next_expiration_date ota_cert_enrollments.expiration_date%type;
665:
666: BEGIN
667: hr_utility.set_location('Entering :'||l_proc,5);
668:
669: l_curr_dt := trunc(nvl(p_cert_period_start_date, sysdate));
670:
671: OPEN csr_crt;

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

810: p_earliest_enroll_date := l_next_earliest_enroll_date;
811: p_expiration_date := l_next_expiration_date;
812: end if; --pmode check
813:
814: hr_utility.set_location('Leaving :'||l_proc,10);
815:
816: EXCEPTION
817: WHEN others THEN
818: hr_utility.set_location('LEAVING:'|| l_proc, 30);

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

814: hr_utility.set_location('Leaving :'||l_proc,10);
815:
816: EXCEPTION
817: WHEN others THEN
818: hr_utility.set_location('LEAVING:'|| l_proc, 30);
819: p_earliest_enroll_date := null;
820: p_expiration_date := null;
821: RAISE;
822: END calc_cre_dates;

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

862: l_elapsed_due_date date;
863:
864: BEGIN
865:
866: hr_utility.set_location('Entering :'||l_proc,5);
867:
868: OPEN csr_crt;
869: FETCH csr_crt INTO rec_crt;
870: CLOSE csr_crt;

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

918: end if;
919:
920: l_prd_durn := '' || l_prd_durn;
921:
922: hr_utility.set_location('Leaving :'||l_proc,10);
923:
924: return l_prd_durn;
925:
926: EXCEPTION

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

924: return l_prd_durn;
925:
926: EXCEPTION
927: WHEN others THEN
928: hr_utility.set_location('Leaving :'||l_proc,15);
929: RETURN null;
930:
931: end get_next_prd_dur_days;
932: --

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

1060: end if;
1061:
1062: EXCEPTION
1063: WHEN others THEN
1064: hr_utility.set_location('Leaving :'||l_proc,15);
1065: RETURN null;
1066:
1067: End get_cre_status;
1068:

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

1095:
1096:
1097: EXCEPTION
1098: WHEN others THEN
1099: hr_utility.set_location('Leaving :'||l_proc,15);
1100: RETURN null;
1101:
1102: End get_cpe_edit_enabled;
1103:

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

1130: l_return_status varchar2(1):= 'S';
1131: l_bypass_flag varchar2(1) := 'N';
1132:
1133: BEGIN
1134: hr_utility.set_location(' Leaving:'||l_proc, 10);
1135:
1136: if p_mass_update_flag = 'N' then
1137: hr_multi_message.enable_message_list;
1138: end if;

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

1166: end if;
1167: end if;
1168: end if;
1169:
1170: hr_utility.set_location(' Leaving:'||l_proc, 20);
1171:
1172: if p_mass_update_flag = 'N' then
1173: l_return_status := hr_multi_message.get_return_status_disable;
1174: end if;

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

1177:
1178: EXCEPTION
1179:
1180: WHEN app_exception.application_exception THEN
1181: hr_utility.set_location(' Leaving:'||l_proc, 25);
1182:
1183: if p_mass_update_flag = 'N' then
1184: if hr_multi_message.exception_add(p_associated_column1 => 'OTA_CERT_PRD_ENROLLMENTS.CERT_PERIOD_END_DATE') then
1185: return hr_multi_message.get_return_status_disable;

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

1191:
1192: return l_return_status;
1193:
1194: WHEN others THEN
1195: hr_utility.set_location('Leaving :'||l_proc,30);
1196: if p_mass_update_flag = 'N' then
1197: l_return_status := hr_multi_message.get_return_status_disable;
1198: else
1199: l_return_status := 'E';

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

1575: -- Reset IN OUT and set OUT parameters
1576: --
1577: p_cert_prd_enrollment_id := null;
1578: p_certification_status_code := null;
1579: hr_utility.set_location(' Leaving:' || l_proc,50);
1580: raise;
1581: end create_cpe_rec;
1582:
1583: PROCEDURE delete_prd_cascade(p_cert_prd_enrollment_id IN ota_cert_prd_enrollments.cert_prd_enrollment_id%type,

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

1689: l_is_period_update boolean := false;
1690: l_cert_period_completion_date ota_cert_prd_enrollments.completion_date%type;
1691: Begin
1692:
1693: hr_utility.set_location(' Entering:' || l_proc,10);
1694:
1695: OPEN csr_prd_enrl;
1696: FETCH csr_prd_enrl INTO l_prd_enrl_rec;
1697: CLOSE csr_prd_enrl;

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

1812: l_return_status := 'S';
1813:
1814: p_return_status := l_return_status;
1815:
1816: hr_utility.set_location('Leaving :'||l_proc,20);
1817:
1818: EXCEPTION
1819: WHEN others THEN
1820: hr_utility.set_location('Leaving :'||l_proc,30);

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

1816: hr_utility.set_location('Leaving :'||l_proc,20);
1817:
1818: EXCEPTION
1819: WHEN others THEN
1820: hr_utility.set_location('Leaving :'||l_proc,30);
1821: p_return_status := null;
1822: End update_admin_changes;
1823: --
1824: --

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

1882:
1883: l_log_message varchar2(500);
1884:
1885: begin
1886: hr_utility.set_location('Entering:'||l_proc, 5);
1887:
1888: for exp_sts_upd in get_data_for_expiry_status_upd
1889: Loop
1890: if ( trunc(exp_sts_upd.cert_period_end_date) < trunc(sysdate) ) then

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

1888: for exp_sts_upd in get_data_for_expiry_status_upd
1889: Loop
1890: if ( trunc(exp_sts_upd.cert_period_end_date) < trunc(sysdate) ) then
1891: begin
1892: hr_utility.set_location('Entering:'||l_proc, 10);
1893: savepoint update_status_to_expired;
1894:
1895: --Update Period CPE status to Expired
1896: ota_cert_prd_enrollment_api.update_cert_prd_enrollment(

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

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

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

1995: l_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE;
1996:
1997: begin
1998:
1999: hr_utility.set_location('Entering:'||l_proc, 5);
2000:
2001: sync_late_subsc_to_class;
2002:
2003: for rec_cpe_status in csr_cpe_status

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

2001: sync_late_subsc_to_class;
2002:
2003: for rec_cpe_status in csr_cpe_status
2004: loop
2005: hr_utility.set_location('Step:'||l_proc, 10);
2006: for rec_acty_info in csr_acty_info(rec_cpe_status.cert_prd_enrollment_id)
2007: loop
2008: hr_utility.set_location('Step:'||l_proc, 10.1);
2009: -- get latest class enrollment status

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

2004: loop
2005: hr_utility.set_location('Step:'||l_proc, 10);
2006: for rec_acty_info in csr_acty_info(rec_cpe_status.cert_prd_enrollment_id)
2007: loop
2008: hr_utility.set_location('Step:'||l_proc, 10.1);
2009: -- get latest class enrollment status
2010: ota_cme_util.get_enrl_status_on_update(rec_acty_info.object_id,
2011: rec_cpe_status.cert_prd_enrollment_id,
2012: l_booking_status_type,

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

2017: if rec_cpe_status.period_status_code <> 'EXPIRED' then
2018: if trunc(l_date_status_changed) = trunc(rec_cpe_status.cert_period_start_date) then
2019: --scenarios 1 and 2
2020: -- for 'Attended' class enroll status perform status rollup for CURRENT CPE
2021: hr_utility.set_location('Step:'||l_proc, 10.2);
2022: do_update := true;
2023: end if;
2024: end if;
2025: else

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

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

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

2037: do_update := false;
2038: end loop;
2039: end loop;
2040:
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');

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

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

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

2068: l_proc VARCHAR2(72) := g_package||' get_latest_cpe_col';
2069: rec_latest_cpe csr_latest_cpe%rowtype;
2070:
2071: Begin
2072: hr_utility.set_location('Entering:'||l_proc, 5);
2073:
2074: open csr_latest_cpe;
2075: fetch csr_latest_cpe into rec_latest_cpe;
2076: close csr_latest_cpe;

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

2074: open csr_latest_cpe;
2075: fetch csr_latest_cpe into rec_latest_cpe;
2076: close csr_latest_cpe;
2077:
2078: hr_utility.set_location('Leaving:'||l_proc, 10);
2079:
2080: if upper(p_col_name) = upper('Cert_Prd_Enrollment_Id') then
2081: return rec_latest_cpe.Cert_Prd_Enrollment_id;
2082: elsif upper(p_col_name) = upper('Period_Status_Code') then

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

2086: end if;
2087:
2088: EXCEPTION
2089: WHEN others THEN
2090: hr_utility.set_location('Leaving :'||l_proc,15);
2091: RETURN null;
2092:
2093: End get_latest_cpe_col;
2094:

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

2111: l_curr_dt date;
2112:
2113: BEGIN
2114:
2115: hr_utility.set_location('Entering :'||l_proc,5);
2116:
2117: l_curr_dt := trunc(sysdate);
2118:
2119: OPEN csr_crt;

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

2132: EXIT WHEN l_curr_dt < l_elapsed_due_date;
2133: end loop;
2134: end if;
2135:
2136: hr_utility.set_location('Leaving :'||l_proc,10);
2137:
2138: return l_elapsed_due_date;
2139:
2140: EXCEPTION

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

2138: return l_elapsed_due_date;
2139:
2140: EXCEPTION
2141: WHEN others THEN
2142: hr_utility.set_location('Leaving :'||l_proc,15);
2143: RETURN NULL;
2144: end get_elapsed_due_date;
2145:
2146: function check_active_periods(p_event_id ota_events.event_id%type) return varchar2

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

2192: l_dummy varchar2(10);
2193:
2194: Begin
2195:
2196: hr_utility.set_location('Entering:'||l_proc, 10);
2197:
2198: open csr_onl_sync_flag;
2199: fetch csr_onl_sync_flag into rec_onl_sync_flag;
2200: close csr_onl_sync_flag;

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

2219: close csr_chk_prds;
2220:
2221: end if;
2222:
2223: hr_utility.set_location('Leaving :'||l_proc, 30);
2224:
2225: return l_return_value;
2226:
2227: EXCEPTION

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

2225: return l_return_value;
2226:
2227: EXCEPTION
2228: WHEN others THEN
2229: hr_utility.set_location('Leaving :'||l_proc,40);
2230: return l_return_value;
2231: END check_active_periods;
2232:
2233: /* Late Subscription or late renewal to certifications