DBA Data[Home] [Help]

APPS.GHR_MSL_PKG dependencies on GHR_MTO_INT

Line 1162: ghr_mto_int.log_message(

1158: END;
1159:
1160: pr('No error in create sf52 ');
1161: --Bug # 9329643 Modified SSN to Emp No
1162: ghr_mto_int.log_message(
1163: p_procedure => 'Successful Completion',
1164: p_message => 'Name: '||p_full_name ||
1165: ' Emp No: ' || p_employee_number||
1166: ' Mass Salary : '||

Line 1253: ghr_mto_int.log_message(

1249: l_mslerrbuf;
1250: hr_utility.set_location('before creating entry in log file',10);
1251: l_recs_failed := l_recs_failed + 1;
1252: begin
1253: ghr_mto_int.log_message(
1254: p_procedure => g_proc,
1255: p_message => l_log_text);
1256: exception
1257: when others then

Line 1276: ghr_mto_int.log_message(

1272: ' Sql Err is '||sqlerrm(sqlcode);
1273: hr_utility.set_location('before creating entry in log file',20);
1274: l_recs_failed := l_recs_failed + 1;
1275: begin
1276: ghr_mto_int.log_message(
1277: p_procedure => g_proc,
1278: p_message => l_log_text);
1279: exception
1280: when others then

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

1381: l_index := l_index +1;
1382: END LOOP;
1383:
1384: IF upper(p_action) = 'CREATE' then
1385: ghr_mto_int.set_log_program_name('GHR_MSL_PKG');
1386: ELSE
1387: ghr_mto_int.set_log_program_name('MSL_'||p_mass_salary);
1388: END IF;
1389:

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

1383:
1384: IF upper(p_action) = 'CREATE' then
1385: ghr_mto_int.set_log_program_name('GHR_MSL_PKG');
1386: ELSE
1387: ghr_mto_int.set_log_program_name('MSL_'||p_mass_salary);
1388: END IF;
1389:
1390: get_lac_dtls(l_pa_request_id, l_lac_sf52_rec);
1391:

Line 1699: ghr_mto_int.log_message(

1695: COMMIT;
1696: END IF;
1697:
1698: BEGIN
1699: ghr_mto_int.log_message(
1700: p_procedure => g_proc,
1701: p_message => l_log_text);
1702: EXCEPTION
1703: WHEN others THEN

Line 3050: ghr_mto_int.log_message(

3046: p_mass_salary_name||'; Employee Name: '|| p_full_name ||
3047: '; Emp No: ' || p_employee_number || '; '||
3048: hr_utility.get_message;
3049: BEGIN
3050: ghr_mto_int.log_message(
3051: p_procedure => 'check_grade_retention',
3052: p_message => l_log_text);
3053: g_rg_recs_failed := g_rg_recs_failed + 1;
3054: EXCEPTION

Line 3404: ghr_mto_int.log_message(

3400: p_mass_salary_name||'; Employee Name: '|| p_full_name ||
3401: '; Emp No: ' || p_employee_number || '; '||
3402: hr_utility.get_message;
3403: BEGIN
3404: ghr_mto_int.log_message(
3405: p_procedure => 'check_grade_retention',
3406: p_message => l_log_text);
3407: g_rg_recs_failed := g_rg_recs_failed + 1;
3408: EXCEPTION

Line 3798: ghr_mto_int.log_message(

3794: End if;
3795: if l_action_taken <> 'CANCELED' then
3796: -- Bug#3718167 Added SSN in the following message
3797: --Bug # 9329643 Modified SSN to Emp No
3798: ghr_mto_int.log_message(
3799: p_procedure => 'RPA Exists Already',
3800: p_message => 'Name: '|| l_name || '; Emp No: '||l_employee_number||
3801: ' - Salary Change ' ||
3802: ' RPA Exists for the given FWS pay_lan and effective date' );

Line 3832: ghr_mto_int.log_message(

3828: End if;
3829: if l_action_taken <> 'CANCELED' then
3830: -- Bug#3718167 Added SSN in the following message
3831: --Bug # 9329643 Modified SSN to Emp No
3832: ghr_mto_int.log_message(
3833: p_procedure => 'RPA Exists Already',
3834: p_message => 'Name: '|| l_name || '; Emp No: '||l_employee_number||
3835: ' - Salary Change ' ||
3836: ' RPA Exists for the given effective date ' );

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

4950: -- g_no := g_no +1;
4951: -- insert into l_tmp values (g_no,substr(msg||'-'||par1||' -'||par2||'-',1,199));
4952: -- DBMS_OUTPUT.PUT_LINE(msg||'-'||par1||' -'||par2||'-');
4953:
4954: ghr_mto_int.put_line(msg||'-'||par1||' -'||par2||'-');
4955: exception
4956: when others then
4957: hr_utility.set_location('Error in pr '||' Err is '||sqlerrm(sqlcode),20);
4958: l_mslerrbuf := 'Error in pr Sql Err is '|| sqlerrm(sqlcode);

Line 6176: ghr_mto_int.log_message(

6172: END;
6173:
6174: pr('No error in create sf52 ');
6175: --Bug # 9329643 Modified SSN to Emp No
6176: ghr_mto_int.log_message(
6177: p_procedure => 'Successful Completion',
6178: p_message => 'Name: '||p_full_name ||
6179: ' Emp No: ' || p_employee_number||
6180: ' Mass Salary : '||

Line 6263: ghr_mto_int.log_message(

6259: l_mslerrbuf;
6260: hr_utility.set_location('before creating entry in log file',10);
6261: l_recs_failed := l_recs_failed + 1;
6262: begin
6263: ghr_mto_int.log_message(
6264: p_procedure => g_proc,
6265: p_message => l_log_text);
6266:
6267: exception

Line 6287: ghr_mto_int.log_message(

6283: ' Sql Err is '||sqlerrm(sqlcode);
6284: hr_utility.set_location('before creating entry in log file',20);
6285: l_recs_failed := l_recs_failed + 1;
6286: begin
6287: ghr_mto_int.log_message(
6288: p_procedure => g_proc,
6289: p_message => l_log_text);
6290:
6291: exception

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

6360:
6361: END LOOP;
6362:
6363: IF upper(p_action) = 'CREATE' then
6364: ghr_mto_int.set_log_program_name('GHR_MSL_PKG');
6365: ELSE
6366: ghr_mto_int.set_log_program_name('MSL_'||p_mass_salary);
6367: END IF;
6368:

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

6362:
6363: IF upper(p_action) = 'CREATE' then
6364: ghr_mto_int.set_log_program_name('GHR_MSL_PKG');
6365: ELSE
6366: ghr_mto_int.set_log_program_name('MSL_'||p_mass_salary);
6367: END IF;
6368:
6369: -- Commented out by Edward Nunez. It's not needed anymore with 894 rules
6370: -- IF upper(p_action) = 'CREATE' then

Line 6685: ghr_mto_int.log_message(

6681: commit;
6682: END IF;
6683:
6684: begin
6685: ghr_mto_int.log_message(
6686: p_procedure => g_proc,
6687: p_message => l_log_text);
6688:
6689: exception

Line 6955: ghr_mto_int.log_message(

6951: p_mass_salary_name||'; Employee Name: '|| p_full_name ||
6952: '; Emp No: ' || p_employee_number || '; '||
6953: hr_utility.get_message;
6954: BEGIN
6955: ghr_mto_int.log_message(
6956: p_procedure => 'check_grade_retention',
6957: p_message => l_log_text);
6958: g_rg_recs_failed := g_rg_recs_failed + 1;
6959: EXCEPTION

Line 8188: ghr_mto_int.log_message(

8184:
8185: pr('No error in create sf52 ');
8186:
8187: --Bug # 9329643 Modified SSN to Emp No
8188: ghr_mto_int.log_message(
8189: p_procedure => 'Successful Completion',
8190: p_message => 'Name: '||p_full_name ||
8191: ' Emp No: ' || p_employee_number||
8192: ' Mass Salary : '||

Line 8280: ghr_mto_int.log_message(

8276: l_mslerrbuf;
8277: hr_utility.set_location('before creating entry in log file',10);
8278: l_recs_failed := l_recs_failed + 1;
8279: begin
8280: ghr_mto_int.log_message(
8281: p_procedure => g_proc,
8282: p_message => l_log_text);
8283: exception
8284: when others then

Line 8303: ghr_mto_int.log_message(

8299: ' Sql Err is '||sqlerrm(sqlcode);
8300: hr_utility.set_location('before creating entry in log file',20);
8301: l_recs_failed := l_recs_failed + 1;
8302: begin
8303: ghr_mto_int.log_message(
8304: p_procedure => g_proc,
8305: p_message => l_log_text);
8306: exception
8307: when others then

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

8385:
8386: END LOOP;*/
8387:
8388: IF upper(p_action) = 'CREATE' then
8389: ghr_mto_int.set_log_program_name('GHR_MSL_PKG');
8390: ELSE
8391: ghr_mto_int.set_log_program_name('MSL_'||p_mass_salary);
8392: END IF;
8393:

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

8387:
8388: IF upper(p_action) = 'CREATE' then
8389: ghr_mto_int.set_log_program_name('GHR_MSL_PKG');
8390: ELSE
8391: ghr_mto_int.set_log_program_name('MSL_'||p_mass_salary);
8392: END IF;
8393:
8394: -- Commented out by Edward Nunez. It's not needed anymore with 894 rules
8395: -- IF upper(p_action) = 'CREATE' then

Line 8720: ghr_mto_int.log_message(

8716: commit;
8717: END IF;
8718:
8719: begin
8720: ghr_mto_int.log_message(
8721: p_procedure => g_proc,
8722: p_message => l_log_text);
8723:
8724: exception