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.PER_ZA_WSP_LOOKUP dependencies on HR_UTILITY

Line 68: hr_utility.set_location('inside validate_lookup_meaning',1);

64: Is
65: l_count number;
66: l_meaning varchar2(100);
67: begin
68: hr_utility.set_location('inside validate_lookup_meaning',1);
69: hr_utility.set_location('P_MEANING ' || P_MEANING,1);
70: select count(*)
71: into l_count
72: from

Line 69: hr_utility.set_location('P_MEANING ' || P_MEANING,1);

65: l_count number;
66: l_meaning varchar2(100);
67: begin
68: hr_utility.set_location('inside validate_lookup_meaning',1);
69: hr_utility.set_location('P_MEANING ' || P_MEANING,1);
70: select count(*)
71: into l_count
72: from
73: fnd_lookup_values

Line 79: hr_utility.set_location('l_count ' || l_count,1);

75: and MEANING = P_MEANING
76: and lookup_code <> p_lookup_code
77: AND security_group_id = fnd_global.lookup_security_group(P_LOOKUP_TYPE,3);
78:
79: hr_utility.set_location('l_count ' || l_count,1);
80: hr_utility.set_location('fnd_global.lookup_security_group(P_LOOKUP_TYPE,3) ' || fnd_global.lookup_security_group(P_LOOKUP_TYPE,3),1);
81:
82: if l_count = 0 then
83: l_MEANING := P_Meaning;

Line 80: hr_utility.set_location('fnd_global.lookup_security_group(P_LOOKUP_TYPE,3) ' || fnd_global.lookup_security_group(P_LOOKUP_TYPE,3),1);

76: and lookup_code <> p_lookup_code
77: AND security_group_id = fnd_global.lookup_security_group(P_LOOKUP_TYPE,3);
78:
79: hr_utility.set_location('l_count ' || l_count,1);
80: hr_utility.set_location('fnd_global.lookup_security_group(P_LOOKUP_TYPE,3) ' || fnd_global.lookup_security_group(P_LOOKUP_TYPE,3),1);
81:
82: if l_count = 0 then
83: l_MEANING := P_Meaning;
84: else

Line 148: hr_utility.set_location('inside LOOKUP_VAL_INSERT_ROW',1);

144: lookup_type = P_LOOKUP_TYPE
145: and lookup_code = P_LOOKUP_CODE
146: AND security_group_id = fnd_global.lookup_security_group(P_LOOKUP_TYPE,3);
147:
148: hr_utility.set_location('inside LOOKUP_VAL_INSERT_ROW',1);
149: hr_utility.set_location('P_LOOKUP_TYPE' || P_LOOKUP_TYPE,1);
150: hr_utility.set_location('P_LOOKUP_CODE' || P_LOOKUP_CODE,1);
151:
152: hr_utility.set_location('P_START_DATE_ACTIVE' || P_START_DATE_ACTIVE,1);

Line 149: hr_utility.set_location('P_LOOKUP_TYPE' || P_LOOKUP_TYPE,1);

145: and lookup_code = P_LOOKUP_CODE
146: AND security_group_id = fnd_global.lookup_security_group(P_LOOKUP_TYPE,3);
147:
148: hr_utility.set_location('inside LOOKUP_VAL_INSERT_ROW',1);
149: hr_utility.set_location('P_LOOKUP_TYPE' || P_LOOKUP_TYPE,1);
150: hr_utility.set_location('P_LOOKUP_CODE' || P_LOOKUP_CODE,1);
151:
152: hr_utility.set_location('P_START_DATE_ACTIVE' || P_START_DATE_ACTIVE,1);
153: hr_utility.set_location('P_END_DATE_ACTIVE' || P_END_DATE_ACTIVE,1);

Line 150: hr_utility.set_location('P_LOOKUP_CODE' || P_LOOKUP_CODE,1);

146: AND security_group_id = fnd_global.lookup_security_group(P_LOOKUP_TYPE,3);
147:
148: hr_utility.set_location('inside LOOKUP_VAL_INSERT_ROW',1);
149: hr_utility.set_location('P_LOOKUP_TYPE' || P_LOOKUP_TYPE,1);
150: hr_utility.set_location('P_LOOKUP_CODE' || P_LOOKUP_CODE,1);
151:
152: hr_utility.set_location('P_START_DATE_ACTIVE' || P_START_DATE_ACTIVE,1);
153: hr_utility.set_location('P_END_DATE_ACTIVE' || P_END_DATE_ACTIVE,1);
154:

Line 152: hr_utility.set_location('P_START_DATE_ACTIVE' || P_START_DATE_ACTIVE,1);

148: hr_utility.set_location('inside LOOKUP_VAL_INSERT_ROW',1);
149: hr_utility.set_location('P_LOOKUP_TYPE' || P_LOOKUP_TYPE,1);
150: hr_utility.set_location('P_LOOKUP_CODE' || P_LOOKUP_CODE,1);
151:
152: hr_utility.set_location('P_START_DATE_ACTIVE' || P_START_DATE_ACTIVE,1);
153: hr_utility.set_location('P_END_DATE_ACTIVE' || P_END_DATE_ACTIVE,1);
154:
155:
156: if l_count = 0 then

Line 153: hr_utility.set_location('P_END_DATE_ACTIVE' || P_END_DATE_ACTIVE,1);

149: hr_utility.set_location('P_LOOKUP_TYPE' || P_LOOKUP_TYPE,1);
150: hr_utility.set_location('P_LOOKUP_CODE' || P_LOOKUP_CODE,1);
151:
152: hr_utility.set_location('P_START_DATE_ACTIVE' || P_START_DATE_ACTIVE,1);
153: hr_utility.set_location('P_END_DATE_ACTIVE' || P_END_DATE_ACTIVE,1);
154:
155:
156: if l_count = 0 then
157:

Line 165: hr_utility.set_location('l_meaning' || l_meaning,1);

161: P_LOOKUP_TYPE => P_LOOKUP_TYPE
162: , P_MEANING => P_MEANING
163: , P_LOOKUP_CODE => P_LOOKUP_CODE
164: );
165: hr_utility.set_location('l_meaning' || l_meaning,1);
166:
167: hr_utility.set_location('calling FND_LOOKUP_VALUES_PKG.INSERT_ROW',1);
168: hr_utility.set_location('fnd_global.lookup_security_group(P_LOOKUP_TYPE,3)'|| fnd_global.lookup_security_group(P_LOOKUP_TYPE,3),1);
169:

Line 167: hr_utility.set_location('calling FND_LOOKUP_VALUES_PKG.INSERT_ROW',1);

163: , P_LOOKUP_CODE => P_LOOKUP_CODE
164: );
165: hr_utility.set_location('l_meaning' || l_meaning,1);
166:
167: hr_utility.set_location('calling FND_LOOKUP_VALUES_PKG.INSERT_ROW',1);
168: hr_utility.set_location('fnd_global.lookup_security_group(P_LOOKUP_TYPE,3)'|| fnd_global.lookup_security_group(P_LOOKUP_TYPE,3),1);
169:
170: /*Changes for Bug 6898734 */
171: len_desc:=length(P_DESCRIPTION);

Line 168: hr_utility.set_location('fnd_global.lookup_security_group(P_LOOKUP_TYPE,3)'|| fnd_global.lookup_security_group(P_LOOKUP_TYPE,3),1);

164: );
165: hr_utility.set_location('l_meaning' || l_meaning,1);
166:
167: hr_utility.set_location('calling FND_LOOKUP_VALUES_PKG.INSERT_ROW',1);
168: hr_utility.set_location('fnd_global.lookup_security_group(P_LOOKUP_TYPE,3)'|| fnd_global.lookup_security_group(P_LOOKUP_TYPE,3),1);
169:
170: /*Changes for Bug 6898734 */
171: len_desc:=length(P_DESCRIPTION);
172: SELECT vsize(P_DESCRIPTION) INTO lenb_desc FROM dual;

Line 174: hr_utility.set_location('len_desription:'|| len_desc,1);

170: /*Changes for Bug 6898734 */
171: len_desc:=length(P_DESCRIPTION);
172: SELECT vsize(P_DESCRIPTION) INTO lenb_desc FROM dual;
173:
174: hr_utility.set_location('len_desription:'|| len_desc,1);
175: hr_utility.set_location('len_bytes_desription:'|| lenb_desc,1);
176:
177: L_DESCRIPTION := P_DESCRIPTION;
178: hr_utility.set_location('Before Loop',1);

Line 175: hr_utility.set_location('len_bytes_desription:'|| lenb_desc,1);

171: len_desc:=length(P_DESCRIPTION);
172: SELECT vsize(P_DESCRIPTION) INTO lenb_desc FROM dual;
173:
174: hr_utility.set_location('len_desription:'|| len_desc,1);
175: hr_utility.set_location('len_bytes_desription:'|| lenb_desc,1);
176:
177: L_DESCRIPTION := P_DESCRIPTION;
178: hr_utility.set_location('Before Loop',1);
179:

Line 178: hr_utility.set_location('Before Loop',1);

174: hr_utility.set_location('len_desription:'|| len_desc,1);
175: hr_utility.set_location('len_bytes_desription:'|| lenb_desc,1);
176:
177: L_DESCRIPTION := P_DESCRIPTION;
178: hr_utility.set_location('Before Loop',1);
179:
180: WHILE lenb_desc > 240
181: loop
182: len_desc:=length(L_DESCRIPTION);

Line 186: hr_utility.set_location('After loop',1);

182: len_desc:=length(L_DESCRIPTION);
183: L_DESCRIPTION:=substr(L_DESCRIPTION,1,len_desc-1);
184: SELECT vsize(L_DESCRIPTION) INTO lenb_desc FROM dual;
185: END loop;
186: hr_utility.set_location('After loop',1);
187:
188: /* End changes for Bug 6898734 */
189:
190: FND_LOOKUP_VALUES_PKG.INSERT_ROW(

Line 998: hr_utility.set_location('inside val_usr_row',1);

994: begin
995: IF P_user_row_id IS NOT NULL then
996: l_from_year := p_from_year - 1;
997: l_year := p_year -1;
998: hr_utility.set_location('inside val_usr_row',1);
999: hr_utility.set_location('P_user_row_id '|| P_user_row_id,1);
1000: l_from_start_date := to_date(to_char(g_plan_year_start_date,'DD-MM-')||l_from_year,'DD-MM-YYYY');
1001: hr_utility.set_location('l_from_start_date '|| l_from_start_date,1);
1002: l_from_end_date := to_date(to_char(g_plan_year_end_date,'DD-MM-')||p_from_year,'DD-MM-YYYY');

Line 999: hr_utility.set_location('P_user_row_id '|| P_user_row_id,1);

995: IF P_user_row_id IS NOT NULL then
996: l_from_year := p_from_year - 1;
997: l_year := p_year -1;
998: hr_utility.set_location('inside val_usr_row',1);
999: hr_utility.set_location('P_user_row_id '|| P_user_row_id,1);
1000: l_from_start_date := to_date(to_char(g_plan_year_start_date,'DD-MM-')||l_from_year,'DD-MM-YYYY');
1001: hr_utility.set_location('l_from_start_date '|| l_from_start_date,1);
1002: l_from_end_date := to_date(to_char(g_plan_year_end_date,'DD-MM-')||p_from_year,'DD-MM-YYYY');
1003: hr_utility.set_location('l_from_end_date '|| l_from_end_date,1);

Line 1001: hr_utility.set_location('l_from_start_date '|| l_from_start_date,1);

997: l_year := p_year -1;
998: hr_utility.set_location('inside val_usr_row',1);
999: hr_utility.set_location('P_user_row_id '|| P_user_row_id,1);
1000: l_from_start_date := to_date(to_char(g_plan_year_start_date,'DD-MM-')||l_from_year,'DD-MM-YYYY');
1001: hr_utility.set_location('l_from_start_date '|| l_from_start_date,1);
1002: l_from_end_date := to_date(to_char(g_plan_year_end_date,'DD-MM-')||p_from_year,'DD-MM-YYYY');
1003: hr_utility.set_location('l_from_end_date '|| l_from_end_date,1);
1004:
1005: l_start_date := to_date(to_char(g_plan_year_start_date,'DD-MM-')||l_year,'DD-MM-YYYY');

Line 1003: hr_utility.set_location('l_from_end_date '|| l_from_end_date,1);

999: hr_utility.set_location('P_user_row_id '|| P_user_row_id,1);
1000: l_from_start_date := to_date(to_char(g_plan_year_start_date,'DD-MM-')||l_from_year,'DD-MM-YYYY');
1001: hr_utility.set_location('l_from_start_date '|| l_from_start_date,1);
1002: l_from_end_date := to_date(to_char(g_plan_year_end_date,'DD-MM-')||p_from_year,'DD-MM-YYYY');
1003: hr_utility.set_location('l_from_end_date '|| l_from_end_date,1);
1004:
1005: l_start_date := to_date(to_char(g_plan_year_start_date,'DD-MM-')||l_year,'DD-MM-YYYY');
1006: hr_utility.set_location('l_start_date '|| l_start_date,1);
1007: l_end_date := to_date(to_char(g_plan_year_end_date,'DD-MM-')||p_year,'DD-MM-YYYY');

Line 1006: hr_utility.set_location('l_start_date '|| l_start_date,1);

1002: l_from_end_date := to_date(to_char(g_plan_year_end_date,'DD-MM-')||p_from_year,'DD-MM-YYYY');
1003: hr_utility.set_location('l_from_end_date '|| l_from_end_date,1);
1004:
1005: l_start_date := to_date(to_char(g_plan_year_start_date,'DD-MM-')||l_year,'DD-MM-YYYY');
1006: hr_utility.set_location('l_start_date '|| l_start_date,1);
1007: l_end_date := to_date(to_char(g_plan_year_end_date,'DD-MM-')||p_year,'DD-MM-YYYY');
1008: hr_utility.set_location('l_end_date '|| l_end_date,1);
1009: if tab_usr_row_ids.exists(P_user_row_id) then
1010: hr_utility.set_location('tab_usr_row_ids.exists(P_user_row_id)',1);

Line 1008: hr_utility.set_location('l_end_date '|| l_end_date,1);

1004:
1005: l_start_date := to_date(to_char(g_plan_year_start_date,'DD-MM-')||l_year,'DD-MM-YYYY');
1006: hr_utility.set_location('l_start_date '|| l_start_date,1);
1007: l_end_date := to_date(to_char(g_plan_year_end_date,'DD-MM-')||p_year,'DD-MM-YYYY');
1008: hr_utility.set_location('l_end_date '|| l_end_date,1);
1009: if tab_usr_row_ids.exists(P_user_row_id) then
1010: hr_utility.set_location('tab_usr_row_ids.exists(P_user_row_id)',1);
1011: else
1012: for rec_usr_row in csr_usr_row

Line 1010: hr_utility.set_location('tab_usr_row_ids.exists(P_user_row_id)',1);

1006: hr_utility.set_location('l_start_date '|| l_start_date,1);
1007: l_end_date := to_date(to_char(g_plan_year_end_date,'DD-MM-')||p_year,'DD-MM-YYYY');
1008: hr_utility.set_location('l_end_date '|| l_end_date,1);
1009: if tab_usr_row_ids.exists(P_user_row_id) then
1010: hr_utility.set_location('tab_usr_row_ids.exists(P_user_row_id)',1);
1011: else
1012: for rec_usr_row in csr_usr_row
1013: ( l_from_start_date
1014: , l_from_end_date

Line 1026: hr_utility.set_location('PER_34003_USER_ROW_OVERLAP ',1);

1022: And usr1.effective_start_date <= l_end_date;
1023: IF l_obj_ver > 0 THEN
1024: --fnd_message.set_name('PER','PER_34003_USER_ROW_OVERLAP');
1025: --fnd_message.error;
1026: hr_utility.set_location('PER_34003_USER_ROW_OVERLAP ',1);
1027: errbuf := substr(fnd_message.get_string('PER','PER_34003_USER_ROW_OVERLAP'),1,255);
1028: retcode := P_user_row_id;
1029: --exit;
1030: else

Line 1033: hr_utility.set_location('Calling pay_user_row_api.create_user_row ',1);

1029: --exit;
1030: else
1031: l_user_row_id := P_user_row_id;
1032: l_obj_ver := 1;
1033: hr_utility.set_location('Calling pay_user_row_api.create_user_row ',1);
1034: pay_user_row_api.create_user_row(
1035: p_validate => FALSE
1036: ,p_effective_date => l_start_date
1037: ,p_user_table_id => rec_usr_row.user_table_id

Line 1056: hr_utility.set_location('Calling pay_user_column_instance_api.create_user_column_instance ',1);

1052: , l_start_date
1053: )
1054: loop
1055: l_user_col_inst_id := rec_usr_val.user_column_instance_id;
1056: hr_utility.set_location('Calling pay_user_column_instance_api.create_user_column_instance ',1);
1057: pay_user_column_instance_api.create_user_column_instance
1058: ( p_validate => FALSE
1059: , p_effective_date => l_start_date
1060: , p_user_row_id => l_user_row_id

Line 1072: hr_utility.set_location('setting in pl/sql table P_user_row_id ' || P_user_row_id,1);

1068: , p_effective_end_date => l_end_date);
1069: end loop;
1070: END IF;
1071: end loop;
1072: hr_utility.set_location('setting in pl/sql table P_user_row_id ' || P_user_row_id,1);
1073: tab_usr_row_ids(P_user_row_id) := P_user_row_id;
1074: end if;
1075: END if;
1076: hr_utility.set_location('Back from val_usr_row ',1);

Line 1076: hr_utility.set_location('Back from val_usr_row ',1);

1072: hr_utility.set_location('setting in pl/sql table P_user_row_id ' || P_user_row_id,1);
1073: tab_usr_row_ids(P_user_row_id) := P_user_row_id;
1074: end if;
1075: END if;
1076: hr_utility.set_location('Back from val_usr_row ',1);
1077:
1078: end val_usr_row;
1079:
1080:

Line 1146: hr_utility.SET_LOCATION('Inside copy_lookup_values',1);

1142:
1143:
1144: begin
1145:
1146: hr_utility.SET_LOCATION('Inside copy_lookup_values',1);
1147: hr_utility.SET_LOCATION('p_year '||p_year,1);
1148: hr_utility.SET_LOCATION('P_from_year ' || P_from_year,1);
1149: hr_utility.SET_LOCATION('p_plan_trng_ind ' || p_plan_trng_ind,1);
1150:

Line 1147: hr_utility.SET_LOCATION('p_year '||p_year,1);

1143:
1144: begin
1145:
1146: hr_utility.SET_LOCATION('Inside copy_lookup_values',1);
1147: hr_utility.SET_LOCATION('p_year '||p_year,1);
1148: hr_utility.SET_LOCATION('P_from_year ' || P_from_year,1);
1149: hr_utility.SET_LOCATION('p_plan_trng_ind ' || p_plan_trng_ind,1);
1150:
1151:

Line 1148: hr_utility.SET_LOCATION('P_from_year ' || P_from_year,1);

1144: begin
1145:
1146: hr_utility.SET_LOCATION('Inside copy_lookup_values',1);
1147: hr_utility.SET_LOCATION('p_year '||p_year,1);
1148: hr_utility.SET_LOCATION('P_from_year ' || P_from_year,1);
1149: hr_utility.SET_LOCATION('p_plan_trng_ind ' || p_plan_trng_ind,1);
1150:
1151:
1152: select count(*) into l_trnd_count

Line 1149: hr_utility.SET_LOCATION('p_plan_trng_ind ' || p_plan_trng_ind,1);

1145:
1146: hr_utility.SET_LOCATION('Inside copy_lookup_values',1);
1147: hr_utility.SET_LOCATION('p_year '||p_year,1);
1148: hr_utility.SET_LOCATION('P_from_year ' || P_from_year,1);
1149: hr_utility.SET_LOCATION('p_plan_trng_ind ' || p_plan_trng_ind,1);
1150:
1151:
1152: select count(*) into l_trnd_count
1153: from fnd_lookup_values

Line 1163: hr_utility.SET_LOCATION('l_trnd_count ' || l_trnd_count,1);

1159: )
1160: AND security_group_id = fnd_global.lookup_security_group(lookup_type,3)
1161: and substr(lookup_code,1,4) = p_year-1;
1162:
1163: hr_utility.SET_LOCATION('l_trnd_count ' || l_trnd_count,1);
1164:
1165: select count(*) into l_plan_count
1166: from fnd_lookup_values
1167: Where lookup_type in

Line 1176: hr_utility.SET_LOCATION('l_plan_count ' || l_plan_count,1);

1172: )
1173: AND security_group_id = fnd_global.lookup_security_group(lookup_type,3)
1174: and substr(lookup_code,1,4) = p_year;
1175:
1176: hr_utility.SET_LOCATION('l_plan_count ' || l_plan_count,1);
1177:
1178: l_count := l_trnd_count + l_plan_count;
1179:
1180: if l_count = 0 then

Line 1184: hr_utility.SET_LOCATION('calling Planned g_p_lpath_lookup_type ' ,1);

1180: if l_count = 0 then
1181: tab_usr_row_ids.delete;
1182: if p_plan_trng_ind = '20' or p_plan_trng_ind = '10' then
1183:
1184: hr_utility.SET_LOCATION('calling Planned g_p_lpath_lookup_type ' ,1);
1185:
1186: for csr_lp_rec in csr_cp_lookup_values
1187: ( g_p_lpath_lookup_type
1188: , p_year

Line 1236: hr_utility.SET_LOCATION('calling planned g_p_cert_lookup_type ' ,1);

1232: , P_END_DATE_ACTIVE => g_plan_year_end_date
1233: );
1234: end loop;
1235:
1236: hr_utility.SET_LOCATION('calling planned g_p_cert_lookup_type ' ,1);
1237: for csr_cert_rec in csr_cp_lookup_values
1238: ( g_p_cert_lookup_type
1239: , p_year
1240: , p_from_year

Line 1287: hr_utility.SET_LOCATION('calling planned g_p_course_lookup_type ' ,1);

1283: , P_END_DATE_ACTIVE => g_plan_year_end_date
1284: );
1285: end loop;
1286:
1287: hr_utility.SET_LOCATION('calling planned g_p_course_lookup_type ' ,1);
1288:
1289: for csr_crs_rec in csr_cp_lookup_values
1290: ( g_p_course_lookup_type
1291: , p_year

Line 1337: hr_utility.SET_LOCATION('After planned g_p_course_lookup_type ' ,1);

1333: , P_START_DATE_ACTIVE => g_plan_year_start_date
1334: , P_END_DATE_ACTIVE => g_plan_year_end_date
1335: );
1336: end loop;
1337: hr_utility.SET_LOCATION('After planned g_p_course_lookup_type ' ,1);
1338: hr_utility.SET_LOCATION('Calling planned create_lookup_values ' ,1);
1339: create_lookup_values
1340: (errbuf => errbuf
1341: , retcode => retcode

Line 1338: hr_utility.SET_LOCATION('Calling planned create_lookup_values ' ,1);

1334: , P_END_DATE_ACTIVE => g_plan_year_end_date
1335: );
1336: end loop;
1337: hr_utility.SET_LOCATION('After planned g_p_course_lookup_type ' ,1);
1338: hr_utility.SET_LOCATION('Calling planned create_lookup_values ' ,1);
1339: create_lookup_values
1340: (errbuf => errbuf
1341: , retcode => retcode
1342: , p_year => p_year

Line 1351: hr_utility.SET_LOCATION('calling Completed g_t_lpath_lookup_type ' ,1);

1347: if p_plan_trng_ind = '30' OR p_plan_trng_ind = '10' then
1348:
1349: tab_usr_row_ids.delete;
1350:
1351: hr_utility.SET_LOCATION('calling Completed g_t_lpath_lookup_type ' ,1);
1352:
1353: for csr_lp_rec in csr_cp_lookup_values
1354: ( g_t_lpath_lookup_type
1355: , p_year - 1

Line 1401: hr_utility.SET_LOCATION('calling trained g_t_course_lookup_type ' ,1);

1397: , P_END_DATE_ACTIVE => g_trnd_year_end_date
1398: );
1399: end loop;
1400:
1401: hr_utility.SET_LOCATION('calling trained g_t_course_lookup_type ' ,1);
1402:
1403: for csr_cert_rec in csr_cp_lookup_values
1404: ( g_t_course_lookup_type
1405: , p_year - 1

Line 1426: hr_utility.SET_LOCATION('calling trained LOOKUP_VAL_INSERT_ROW ' ,1);

1422: val_usr_row(csr_cert_rec.ATTRIBUTE13,p_year-1,p_from_year-1,errbuf,retcode);
1423: val_usr_row(csr_cert_rec.ATTRIBUTE14,p_year-1,p_from_year-1,errbuf,retcode);
1424: val_usr_row(csr_cert_rec.ATTRIBUTE15,p_year-1,p_from_year-1,errbuf,retcode);
1425:
1426: hr_utility.SET_LOCATION('calling trained LOOKUP_VAL_INSERT_ROW ' ,1);
1427:
1428: LOOKUP_VAL_INSERT_ROW
1429: ( P_LOOKUP_TYPE => csr_cert_rec.LOOKUP_TYPE
1430: , P_LOOKUP_CODE => csr_cert_rec.LOOKUP_CODE

Line 1454: hr_utility.SET_LOCATION('calling trained g_t_cert_lookup_type ' ,1);

1450: , P_END_DATE_ACTIVE => g_trnd_year_end_date
1451: );
1452: end loop;
1453:
1454: hr_utility.SET_LOCATION('calling trained g_t_cert_lookup_type ' ,1);
1455:
1456: for csr_crs_rec in csr_cp_lookup_values
1457: ( g_t_cert_lookup_type
1458: , p_year - 1

Line 1505: hr_utility.SET_LOCATION('calling trained g_t_comp_lookup_type ' ,1);

1501: , P_END_DATE_ACTIVE => g_trnd_year_end_date
1502: );
1503: end loop;
1504:
1505: hr_utility.SET_LOCATION('calling trained g_t_comp_lookup_type ' ,1);
1506:
1507: for csr_comp_rec in csr_cp_lookup_values
1508: ( g_t_comp_lookup_type
1509: , p_year - 1

Line 1556: hr_utility.SET_LOCATION('calling trained g_t_qual_lookup_type ' ,1);

1552: , P_END_DATE_ACTIVE => g_trnd_year_end_date
1553: );
1554: end loop;
1555:
1556: hr_utility.SET_LOCATION('calling trained g_t_qual_lookup_type ' ,1);
1557:
1558: for csr_qual_rec in csr_cp_lookup_values
1559: ( g_t_qual_lookup_type
1560: , p_year - 1

Line 1675: hr_utility.set_location ('Inside copy_plan_2_trining ' ,1);

1671: ATTRIBUTE9 ||ATTRIBUTE10||ATTRIBUTE11||ATTRIBUTE12||
1672: ATTRIBUTE13||ATTRIBUTE14||ATTRIBUTE15) is not null;
1673:
1674: begin
1675: hr_utility.set_location ('Inside copy_plan_2_trining ' ,1);
1676: hr_utility.set_location ('p_year ' || p_year,1);
1677: hr_utility.set_location ('P_from_year ' || P_from_year ,1);
1678:
1679:

Line 1676: hr_utility.set_location ('p_year ' || p_year,1);

1672: ATTRIBUTE13||ATTRIBUTE14||ATTRIBUTE15) is not null;
1673:
1674: begin
1675: hr_utility.set_location ('Inside copy_plan_2_trining ' ,1);
1676: hr_utility.set_location ('p_year ' || p_year,1);
1677: hr_utility.set_location ('P_from_year ' || P_from_year ,1);
1678:
1679:
1680: select count(*) into l_count

Line 1677: hr_utility.set_location ('P_from_year ' || P_from_year ,1);

1673:
1674: begin
1675: hr_utility.set_location ('Inside copy_plan_2_trining ' ,1);
1676: hr_utility.set_location ('p_year ' || p_year,1);
1677: hr_utility.set_location ('P_from_year ' || P_from_year ,1);
1678:
1679:
1680: select count(*) into l_count
1681: from fnd_lookup_values

Line 1691: hr_utility.set_location ('l_count ' || l_count ,2);

1687: )
1688: And security_group_id = fnd_global.lookup_security_group(lookup_type,3)
1689: and substr(lookup_code,1,4) = to_char(p_year-1);
1690:
1691: hr_utility.set_location ('l_count ' || l_count ,2);
1692:
1693: if l_count = 0 then
1694: tab_usr_row_ids.delete;
1695: for plan_2_train_rec in csr_cp_plan_2_train

Line 1699: hr_utility.set_location ('Inside g_p_lpath_lookup_type ' ,1);

1695: for plan_2_train_rec in csr_cp_plan_2_train
1696: (g_p_lpath_lookup_type
1697: )
1698: loop
1699: hr_utility.set_location ('Inside g_p_lpath_lookup_type ' ,1);
1700:
1701: val_usr_row(plan_2_train_rec.ATTRIBUTE1,p_year - 1,p_from_year,errbuf,retcode);
1702: val_usr_row(plan_2_train_rec.ATTRIBUTE2,p_year - 1,p_from_year,errbuf,retcode);
1703: val_usr_row(plan_2_train_rec.ATTRIBUTE3,p_year - 1,p_from_year,errbuf,retcode);

Line 1749: hr_utility.set_location ('Inside g_p_course_lookup_type ' ,1);

1745: for plan_2_train_rec in csr_cp_plan_2_train
1746: (g_p_course_lookup_type
1747: )
1748: loop
1749: hr_utility.set_location ('Inside g_p_course_lookup_type ' ,1);
1750: val_usr_row(plan_2_train_rec.ATTRIBUTE1,p_year - 1,p_from_year,errbuf,retcode);
1751: val_usr_row(plan_2_train_rec.ATTRIBUTE2,p_year - 1,p_from_year,errbuf,retcode);
1752: val_usr_row(plan_2_train_rec.ATTRIBUTE3,p_year - 1,p_from_year,errbuf,retcode);
1753: val_usr_row(plan_2_train_rec.ATTRIBUTE4,p_year - 1,p_from_year,errbuf,retcode);

Line 1797: hr_utility.set_location ('Inside g_p_cert_lookup_type ' ,1);

1793: for plan_2_train_rec in csr_cp_plan_2_train
1794: (g_p_cert_lookup_type
1795: )
1796: loop
1797: hr_utility.set_location ('Inside g_p_cert_lookup_type ' ,1);
1798: val_usr_row(plan_2_train_rec.ATTRIBUTE1,p_year - 1,p_from_year,errbuf,retcode);
1799: val_usr_row(plan_2_train_rec.ATTRIBUTE2,p_year - 1,p_from_year,errbuf,retcode);
1800: val_usr_row(plan_2_train_rec.ATTRIBUTE3,p_year - 1,p_from_year,errbuf,retcode);
1801: val_usr_row(plan_2_train_rec.ATTRIBUTE4,p_year - 1,p_from_year,errbuf,retcode);

Line 1931: -- hr_utility.trace_on(null,'ZAWSP');

1927: Is
1928:
1929: begin
1930: retcode := 0;
1931: -- hr_utility.trace_on(null,'ZAWSP');
1932: hr_utility.set_location('In wsp_lookup_values',10);
1933: hr_utility.set_location('p_syncronise :' || p_syncronise,20);
1934: hr_utility.set_location('p_year :' || p_year,20);
1935: hr_utility.set_location('P_mode :' || P_mode,20);

Line 1932: hr_utility.set_location('In wsp_lookup_values',10);

1928:
1929: begin
1930: retcode := 0;
1931: -- hr_utility.trace_on(null,'ZAWSP');
1932: hr_utility.set_location('In wsp_lookup_values',10);
1933: hr_utility.set_location('p_syncronise :' || p_syncronise,20);
1934: hr_utility.set_location('p_year :' || p_year,20);
1935: hr_utility.set_location('P_mode :' || P_mode,20);
1936: hr_utility.set_location('p_from_year :' || p_from_year,20);

Line 1933: hr_utility.set_location('p_syncronise :' || p_syncronise,20);

1929: begin
1930: retcode := 0;
1931: -- hr_utility.trace_on(null,'ZAWSP');
1932: hr_utility.set_location('In wsp_lookup_values',10);
1933: hr_utility.set_location('p_syncronise :' || p_syncronise,20);
1934: hr_utility.set_location('p_year :' || p_year,20);
1935: hr_utility.set_location('P_mode :' || P_mode,20);
1936: hr_utility.set_location('p_from_year :' || p_from_year,20);
1937: hr_utility.set_location('p_plan_trng_ind :' || p_plan_trng_ind,20);

Line 1934: hr_utility.set_location('p_year :' || p_year,20);

1930: retcode := 0;
1931: -- hr_utility.trace_on(null,'ZAWSP');
1932: hr_utility.set_location('In wsp_lookup_values',10);
1933: hr_utility.set_location('p_syncronise :' || p_syncronise,20);
1934: hr_utility.set_location('p_year :' || p_year,20);
1935: hr_utility.set_location('P_mode :' || P_mode,20);
1936: hr_utility.set_location('p_from_year :' || p_from_year,20);
1937: hr_utility.set_location('p_plan_trng_ind :' || p_plan_trng_ind,20);
1938:

Line 1935: hr_utility.set_location('P_mode :' || P_mode,20);

1931: -- hr_utility.trace_on(null,'ZAWSP');
1932: hr_utility.set_location('In wsp_lookup_values',10);
1933: hr_utility.set_location('p_syncronise :' || p_syncronise,20);
1934: hr_utility.set_location('p_year :' || p_year,20);
1935: hr_utility.set_location('P_mode :' || P_mode,20);
1936: hr_utility.set_location('p_from_year :' || p_from_year,20);
1937: hr_utility.set_location('p_plan_trng_ind :' || p_plan_trng_ind,20);
1938:
1939:

Line 1936: hr_utility.set_location('p_from_year :' || p_from_year,20);

1932: hr_utility.set_location('In wsp_lookup_values',10);
1933: hr_utility.set_location('p_syncronise :' || p_syncronise,20);
1934: hr_utility.set_location('p_year :' || p_year,20);
1935: hr_utility.set_location('P_mode :' || P_mode,20);
1936: hr_utility.set_location('p_from_year :' || p_from_year,20);
1937: hr_utility.set_location('p_plan_trng_ind :' || p_plan_trng_ind,20);
1938:
1939:
1940: if p_syncronise = '10' or p_syncronise = '40' then

Line 1937: hr_utility.set_location('p_plan_trng_ind :' || p_plan_trng_ind,20);

1933: hr_utility.set_location('p_syncronise :' || p_syncronise,20);
1934: hr_utility.set_location('p_year :' || p_year,20);
1935: hr_utility.set_location('P_mode :' || P_mode,20);
1936: hr_utility.set_location('p_from_year :' || p_from_year,20);
1937: hr_utility.set_location('p_plan_trng_ind :' || p_plan_trng_ind,20);
1938:
1939:
1940: if p_syncronise = '10' or p_syncronise = '40' then
1941: wsp_populate_udt;

Line 1962: hr_utility.set_location('g_plan_year_start_date :' || g_plan_year_start_date,30);

1958: , g_trnd_year_start_date
1959: , g_trnd_year_end_date
1960: From Dual;
1961:
1962: hr_utility.set_location('g_plan_year_start_date :' || g_plan_year_start_date,30);
1963: hr_utility.set_location('g_plan_year_end_date :' || g_plan_year_end_date,30);
1964: hr_utility.set_location('g_trnd_year_start_date :' || g_trnd_year_start_date,30);
1965: hr_utility.set_location('g_trnd_year_end_date :' || g_trnd_year_end_date,30);
1966:

Line 1963: hr_utility.set_location('g_plan_year_end_date :' || g_plan_year_end_date,30);

1959: , g_trnd_year_end_date
1960: From Dual;
1961:
1962: hr_utility.set_location('g_plan_year_start_date :' || g_plan_year_start_date,30);
1963: hr_utility.set_location('g_plan_year_end_date :' || g_plan_year_end_date,30);
1964: hr_utility.set_location('g_trnd_year_start_date :' || g_trnd_year_start_date,30);
1965: hr_utility.set_location('g_trnd_year_end_date :' || g_trnd_year_end_date,30);
1966:
1967: if P_mode = '10' then -- Create

Line 1964: hr_utility.set_location('g_trnd_year_start_date :' || g_trnd_year_start_date,30);

1960: From Dual;
1961:
1962: hr_utility.set_location('g_plan_year_start_date :' || g_plan_year_start_date,30);
1963: hr_utility.set_location('g_plan_year_end_date :' || g_plan_year_end_date,30);
1964: hr_utility.set_location('g_trnd_year_start_date :' || g_trnd_year_start_date,30);
1965: hr_utility.set_location('g_trnd_year_end_date :' || g_trnd_year_end_date,30);
1966:
1967: if P_mode = '10' then -- Create
1968: /* create the look up values

Line 1965: hr_utility.set_location('g_trnd_year_end_date :' || g_trnd_year_end_date,30);

1961:
1962: hr_utility.set_location('g_plan_year_start_date :' || g_plan_year_start_date,30);
1963: hr_utility.set_location('g_plan_year_end_date :' || g_plan_year_end_date,30);
1964: hr_utility.set_location('g_trnd_year_start_date :' || g_trnd_year_start_date,30);
1965: hr_utility.set_location('g_trnd_year_end_date :' || g_trnd_year_end_date,30);
1966:
1967: if P_mode = '10' then -- Create
1968: /* create the look up values
1969: it will delete existing lookup values for passed year

Line 1971: hr_utility.set_location('Calling create_lookup_values' ,40);

1967: if P_mode = '10' then -- Create
1968: /* create the look up values
1969: it will delete existing lookup values for passed year
1970: and create freash lookup values*/
1971: hr_utility.set_location('Calling create_lookup_values' ,40);
1972: create_lookup_values
1973: (errbuf => errbuf
1974: , retcode => retcode
1975: --, p_business_group_id => p_business_group_id

Line 1981: hr_utility.set_location('Calling refresh_lookup_values' ,50);

1977: , p_plan_trng_ind => p_plan_trng_ind
1978: , p_del_mode => 'Y' -- if values exists delete and re create
1979: );
1980: elsif P_mode = '20' then -- refresh
1981: hr_utility.set_location('Calling refresh_lookup_values' ,50);
1982: /* refresh the lookup values
1983: it will do the following
1984: 1) add the Attribute_category where it is missing
1985: 2) add new rows in lookup values if new Learning Path,

Line 1999: hr_utility.set_location('Calling copy_plan_2_trining' ,50);

1995: elsif P_mode = '30' then -- Copy Plan to TRAINED
1996: /* Create the lookup values for plan as create
1997: and copy previous years plan to current years TRAINED
1998: */
1999: hr_utility.set_location('Calling copy_plan_2_trining' ,50);
2000: copy_plan_2_trining
2001: ( errbuf => errbuf
2002: , retcode => retcode
2003: , p_year => p_year

Line 2012: hr_utility.set_location('Calling copy_lookup_values' ,60);

2008: elsif p_mode = '40' then -- Copy Plan to Plan and TRained to Trained
2009: /* Create the lookup values for plan as create
2010: and copy previous years plan to current years TRAINED
2011: */
2012: hr_utility.set_location('Calling copy_lookup_values' ,60);
2013: copy_lookup_values
2014: (errbuf => errbuf
2015: ,retcode => retcode
2016: ,p_year => p_year

Line 2027: -- hr_utility.trace_off;

2023: retcode := -1;
2024:
2025: end if;
2026: end if; -- End if p_syncronise = '10' or p_syncronise = '30'
2027: -- hr_utility.trace_off;
2028: EXCEPTION
2029: WHEN OTHERS then
2030: errbuf := substr(SQLERRM,1,255);
2031: retcode := sqlcode;