DBA Data[Home] [Help]

APPS.GHR_MSL_PKG dependencies on GHR_MTO_INT

Line 1148: ghr_mto_int.log_message(

1144: END;
1145:
1146: pr('No error in create sf52 ');
1147:
1148: ghr_mto_int.log_message(
1149: p_procedure => 'Successful Completion',
1150: p_message => 'Name: '||p_full_name ||
1151: ' SSN: '|| p_national_identifier||
1152: ' Mass Salary : '||

Line 1238: ghr_mto_int.log_message(

1234: l_mslerrbuf;
1235: hr_utility.set_location('before creating entry in log file',10);
1236: l_recs_failed := l_recs_failed + 1;
1237: begin
1238: ghr_mto_int.log_message(
1239: p_procedure => g_proc,
1240: p_message => l_log_text);
1241: exception
1242: when others then

Line 1260: ghr_mto_int.log_message(

1256: ' Sql Err is '||sqlerrm(sqlcode);
1257: hr_utility.set_location('before creating entry in log file',20);
1258: l_recs_failed := l_recs_failed + 1;
1259: begin
1260: ghr_mto_int.log_message(
1261: p_procedure => g_proc,
1262: p_message => l_log_text);
1263: exception
1264: when others then

Line 1369: ghr_mto_int.set_log_program_name('GHR_MSL_PKG');

1365: l_index := l_index +1;
1366: END LOOP;
1367:
1368: IF upper(p_action) = 'CREATE' then
1369: ghr_mto_int.set_log_program_name('GHR_MSL_PKG');
1370: ELSE
1371: ghr_mto_int.set_log_program_name('MSL_'||p_mass_salary);
1372: END IF;
1373:

Line 1371: ghr_mto_int.set_log_program_name('MSL_'||p_mass_salary);

1367:
1368: IF upper(p_action) = 'CREATE' then
1369: ghr_mto_int.set_log_program_name('GHR_MSL_PKG');
1370: ELSE
1371: ghr_mto_int.set_log_program_name('MSL_'||p_mass_salary);
1372: END IF;
1373:
1374: get_lac_dtls(l_pa_request_id, l_lac_sf52_rec);
1375:

Line 1675: ghr_mto_int.log_message(

1671: COMMIT;
1672: END IF;
1673:
1674: BEGIN
1675: ghr_mto_int.log_message(
1676: p_procedure => g_proc,
1677: p_message => l_log_text);
1678: EXCEPTION
1679: WHEN others THEN

Line 3019: ghr_mto_int.log_message(

3015: p_mass_salary_name||'; Employee Name: '|| p_full_name ||
3016: '; SSN: ' || p_national_identifier || '; '||
3017: hr_utility.get_message;
3018: BEGIN
3019: ghr_mto_int.log_message(
3020: p_procedure => 'check_grade_retention',
3021: p_message => l_log_text);
3022: g_rg_recs_failed := g_rg_recs_failed + 1;
3023: EXCEPTION

Line 3370: ghr_mto_int.log_message(

3366: p_mass_salary_name||'; Employee Name: '|| p_full_name ||
3367: '; SSN: ' || p_national_identifier || '; '||
3368: hr_utility.get_message;
3369: BEGIN
3370: ghr_mto_int.log_message(
3371: p_procedure => 'check_grade_retention',
3372: p_message => l_log_text);
3373: g_rg_recs_failed := g_rg_recs_failed + 1;
3374: EXCEPTION

Line 3754: ghr_mto_int.log_message(

3750: exit;
3751: end loop;
3752: if l_action_taken <> 'CANCELED' then
3753: -- Bug#3718167 Added SSN in the following message
3754: ghr_mto_int.log_message(
3755: p_procedure => 'RPA Exists Already',
3756: p_message => 'Name: '|| l_name || '; SSN: '||l_ssn||
3757: ' - Salary Change ' ||
3758: ' RPA Exists for the given FWS pay_lan and effective date' );

Line 3780: ghr_mto_int.log_message(

3776: exit;
3777: end loop;
3778: if l_action_taken <> 'CANCELED' then
3779: -- Bug#3718167 Added SSN in the following message
3780: ghr_mto_int.log_message(
3781: p_procedure => 'RPA Exists Already',
3782: p_message => 'Name: '|| l_name || '; SSN: '||l_ssn||
3783: ' - Salary Change ' ||
3784: ' RPA Exists for the given effective date ' );

Line 4896: ghr_mto_int.put_line(msg||'-'||par1||' -'||par2||'-');

4892: -- g_no := g_no +1;
4893: -- insert into l_tmp values (g_no,substr(msg||'-'||par1||' -'||par2||'-',1,199));
4894: -- DBMS_OUTPUT.PUT_LINE(msg||'-'||par1||' -'||par2||'-');
4895:
4896: ghr_mto_int.put_line(msg||'-'||par1||' -'||par2||'-');
4897: exception
4898: when others then
4899: hr_utility.set_location('Error in pr '||' Err is '||sqlerrm(sqlcode),20);
4900: l_mslerrbuf := 'Error in pr Sql Err is '|| sqlerrm(sqlcode);

Line 6046: ghr_mto_int.log_message(

6042: );
6043: END;
6044:
6045: pr('No error in create sf52 ');
6046: ghr_mto_int.log_message(
6047: p_procedure => 'Successful Completion',
6048: p_message => 'Name: '||p_full_name ||
6049: ' SSN: '|| p_national_identifier||
6050: ' Mass Salary : '||

Line 6132: ghr_mto_int.log_message(

6128: l_mslerrbuf;
6129: hr_utility.set_location('before creating entry in log file',10);
6130: l_recs_failed := l_recs_failed + 1;
6131: begin
6132: ghr_mto_int.log_message(
6133: p_procedure => g_proc,
6134: p_message => l_log_text);
6135:
6136: exception

Line 6155: ghr_mto_int.log_message(

6151: ' Sql Err is '||sqlerrm(sqlcode);
6152: hr_utility.set_location('before creating entry in log file',20);
6153: l_recs_failed := l_recs_failed + 1;
6154: begin
6155: ghr_mto_int.log_message(
6156: p_procedure => g_proc,
6157: p_message => l_log_text);
6158:
6159: exception

Line 6232: ghr_mto_int.set_log_program_name('GHR_MSL_PKG');

6228:
6229: END LOOP;
6230:
6231: IF upper(p_action) = 'CREATE' then
6232: ghr_mto_int.set_log_program_name('GHR_MSL_PKG');
6233: ELSE
6234: ghr_mto_int.set_log_program_name('MSL_'||p_mass_salary);
6235: END IF;
6236:

Line 6234: ghr_mto_int.set_log_program_name('MSL_'||p_mass_salary);

6230:
6231: IF upper(p_action) = 'CREATE' then
6232: ghr_mto_int.set_log_program_name('GHR_MSL_PKG');
6233: ELSE
6234: ghr_mto_int.set_log_program_name('MSL_'||p_mass_salary);
6235: END IF;
6236:
6237: -- Commented out by Edward Nunez. It's not needed anymore with 894 rules
6238: -- IF upper(p_action) = 'CREATE' then

Line 6545: ghr_mto_int.log_message(

6541: commit;
6542: END IF;
6543:
6544: begin
6545: ghr_mto_int.log_message(
6546: p_procedure => g_proc,
6547: p_message => l_log_text);
6548:
6549: exception

Line 6813: ghr_mto_int.log_message(

6809: p_mass_salary_name||'; Employee Name: '|| p_full_name ||
6810: '; SSN: ' || p_national_identifier || '; '||
6811: hr_utility.get_message;
6812: BEGIN
6813: ghr_mto_int.log_message(
6814: p_procedure => 'check_grade_retention',
6815: p_message => l_log_text);
6816: g_rg_recs_failed := g_rg_recs_failed + 1;
6817: EXCEPTION

Line 8034: ghr_mto_int.log_message(

8030: END;
8031:
8032: pr('No error in create sf52 ');
8033:
8034: ghr_mto_int.log_message(
8035: p_procedure => 'Successful Completion',
8036: p_message => 'Name: '||p_full_name ||
8037: ' SSN: '|| p_national_identifier||
8038: ' Mass Salary : '||

Line 8125: ghr_mto_int.log_message(

8121: l_mslerrbuf;
8122: hr_utility.set_location('before creating entry in log file',10);
8123: l_recs_failed := l_recs_failed + 1;
8124: begin
8125: ghr_mto_int.log_message(
8126: p_procedure => g_proc,
8127: p_message => l_log_text);
8128: exception
8129: when others then

Line 8147: ghr_mto_int.log_message(

8143: ' Sql Err is '||sqlerrm(sqlcode);
8144: hr_utility.set_location('before creating entry in log file',20);
8145: l_recs_failed := l_recs_failed + 1;
8146: begin
8147: ghr_mto_int.log_message(
8148: p_procedure => g_proc,
8149: p_message => l_log_text);
8150: exception
8151: when others then

Line 8233: ghr_mto_int.set_log_program_name('GHR_MSL_PKG');

8229:
8230: END LOOP;*/
8231:
8232: IF upper(p_action) = 'CREATE' then
8233: ghr_mto_int.set_log_program_name('GHR_MSL_PKG');
8234: ELSE
8235: ghr_mto_int.set_log_program_name('MSL_'||p_mass_salary);
8236: END IF;
8237:

Line 8235: ghr_mto_int.set_log_program_name('MSL_'||p_mass_salary);

8231:
8232: IF upper(p_action) = 'CREATE' then
8233: ghr_mto_int.set_log_program_name('GHR_MSL_PKG');
8234: ELSE
8235: ghr_mto_int.set_log_program_name('MSL_'||p_mass_salary);
8236: END IF;
8237:
8238: -- Commented out by Edward Nunez. It's not needed anymore with 894 rules
8239: -- IF upper(p_action) = 'CREATE' then

Line 8556: ghr_mto_int.log_message(

8552: commit;
8553: END IF;
8554:
8555: begin
8556: ghr_mto_int.log_message(
8557: p_procedure => g_proc,
8558: p_message => l_log_text);
8559:
8560: exception