DBA Data[Home] [Help]

APPS.GHR_MASS_SEL_NOA dependencies on GHR_MTO_INT

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

34: (msg IN varchar2
35: , par1 IN varchar2 DEFAULT NULL
36: , par2 IN varchar2 DEFAULT NULL) IS
37: BEGIN
38: ghr_mto_int.put_line (msg|| '-'|| par1|| ' -'|| par2|| '-');
39: EXCEPTION
40: WHEN others THEN
41: hr_utility.set_location ('Error in pr '|| ' Err is '|| sqlerrm (sqlcode), 20);
42: l_noaerrbuf := 'Error in pr Sql Err is '|| sqlerrm (sqlcode);

Line 107: ghr_mto_int.log_message

103: END IF;
104:
105: IF l_action_taken <> 'CANCELED' THEN
106: hr_utility.set_location ('in Canceled action '|| l_proc, 6);
107: ghr_mto_int.log_message
108: (p_procedure => 'RPA Exists Already'
109: , p_message => 'Name: '
110: || l_name
111: || ' Emp No: '

Line 2336: ghr_mto_int.log_message( p_procedure => 'Successful Completion',

2332: update_position_info (l_position_data_rec);
2333: ghr_validate_perwsdpo.update_posn_status(l_position_id,l_effective_date);
2334: ghr_mlc_pkg.upd_ext_info_to_null(l_position_id,l_effective_date);
2335: --Bug# 14475560
2336: ghr_mto_int.log_message( p_procedure => 'Successful Completion',
2337: p_message => 'Vacant Position : '||l_position_title ||'.'|| l_position_number
2338: ||'.'||l_position_seq_no||'.'||l_sub_element_code||
2339: ' Mass NOA Selectable : '||
2340: p_mass_salary ||' Vacant pos Successfully completed');

Line 2395: ghr_mto_int.log_message

2391:
2392: l_recs_failed := l_recs_failed + 1;
2393:
2394: BEGIN
2395: ghr_mto_int.log_message
2396: (p_procedure => g_proc
2397: , p_message => l_log_text);
2398: EXCEPTION
2399: WHEN others THEN

Line 2443: ghr_mto_int.log_message

2439: COMMIT;
2440: END IF;
2441:
2442: BEGIN
2443: ghr_mto_int.log_message
2444: (p_procedure => g_proc
2445: , p_message => l_log_text);
2446: EXCEPTION
2447: WHEN others THEN

Line 3040: ghr_mto_int.log_message

3036: IF l_errbuf IS NULL THEN
3037: pr ('No error in create sf52 ');
3038: hr_utility.set_location ('Before commiting', 2);
3039:
3040: ghr_mto_int.log_message
3041: (p_procedure => 'Successful Completion'
3042: , p_message => 'Name: '
3043: || p_full_name
3044: || ' Emp No: '

Line 3105: ghr_mto_int.log_message

3101:
3102: hr_utility.set_location ('before creating entry in log file', 10);
3103: l_recs_failed := l_recs_failed + 1;
3104: BEGIN
3105: ghr_mto_int.log_message
3106: (p_procedure => g_proc
3107: , p_message => l_log_text);
3108: EXCEPTION
3109: WHEN others THEN

Line 3144: ghr_mto_int.log_message

3140: COMMIT;
3141: END IF;
3142:
3143: BEGIN
3144: ghr_mto_int.log_message
3145: (p_procedure => g_proc
3146: , p_message => l_log_text);
3147: EXCEPTION
3148: WHEN others THEN

Line 3212: ghr_mto_int.set_log_program_name ('GHR_MNOA_PKG');

3208: RAISE mnoa_error;
3209: END;
3210: g_effective_date := l_effective_date;
3211: IF upper (p_action) = 'CREATE' THEN
3212: ghr_mto_int.set_log_program_name ('GHR_MNOA_PKG');
3213: ELSE
3214: ghr_mto_int.set_log_program_name ('MSNOA_'|| p_mass_salary);
3215: END IF;
3216: get_lac_dtls (l_pa_request_id, l_lac_sf52_rec);

Line 3214: ghr_mto_int.set_log_program_name ('MSNOA_'|| p_mass_salary);

3210: g_effective_date := l_effective_date;
3211: IF upper (p_action) = 'CREATE' THEN
3212: ghr_mto_int.set_log_program_name ('GHR_MNOA_PKG');
3213: ELSE
3214: ghr_mto_int.set_log_program_name ('MSNOA_'|| p_mass_salary);
3215: END IF;
3216: get_lac_dtls (l_pa_request_id, l_lac_sf52_rec);
3217: ghr_msl_pkg.g_first_noa_code := l_noa_code;
3218: hr_utility.set_location ('Mass Action name '|| p_action, 52);

Line 4341: ghr_mto_int.log_message

4337: COMMIT;
4338: END IF;
4339:
4340: BEGIN
4341: ghr_mto_int.log_message
4342: (p_procedure => g_proc
4343: , p_message => l_log_text);
4344: EXCEPTION
4345: WHEN others THEN

Line 4743: ghr_mto_int.log_message

4739: IF l_errbuf IS NULL THEN
4740: pr ('No error in create sf52 ');
4741: hr_utility.set_location ('Before commiting', 2);
4742:
4743: ghr_mto_int.log_message
4744: (p_procedure => 'Successful Completion'
4745: , p_message => 'Name: '
4746: || p_full_name
4747: || ' Emp No: '

Line 4818: ghr_mto_int.log_message

4814: hr_utility.set_location ('before creating entry in log file', 10);
4815: l_recs_failed := l_recs_failed + 1;
4816:
4817: BEGIN
4818: ghr_mto_int.log_message
4819: (p_procedure => g_proc
4820: , p_message => l_log_text);
4821: EXCEPTION
4822: WHEN others THEN

Line 4863: ghr_mto_int.log_message

4859: COMMIT;
4860: END IF;
4861:
4862: BEGIN
4863: ghr_mto_int.log_message
4864: (p_procedure => g_proc
4865: , p_message => l_log_text);
4866: EXCEPTION
4867: WHEN others THEN

Line 4932: ghr_mto_int.log_message

4928: COMMIT;
4929: END IF;
4930:
4931: BEGIN
4932: ghr_mto_int.log_message
4933: (p_procedure => g_proc
4934: , p_message => l_log_text);
4935: EXCEPTION
4936: WHEN others THEN

Line 4996: ghr_mto_int.set_log_program_name ('GHR_MCANCEL_PKG');

4992:
4993: g_effective_date := l_effective_date;
4994:
4995: IF upper (p_action) = 'CREATE' THEN
4996: ghr_mto_int.set_log_program_name ('GHR_MCANCEL_PKG');
4997: ELSE
4998: ghr_mto_int.set_log_program_name ('MCANCEL_'
4999: || p_mass_salary);
5000: END IF;

Line 4998: ghr_mto_int.set_log_program_name ('MCANCEL_'

4994:
4995: IF upper (p_action) = 'CREATE' THEN
4996: ghr_mto_int.set_log_program_name ('GHR_MCANCEL_PKG');
4997: ELSE
4998: ghr_mto_int.set_log_program_name ('MCANCEL_'
4999: || p_mass_salary);
5000: END IF;
5001:
5002: get_lac_dtls (l_pa_request_id, l_lac_sf52_rec);

Line 5088: ghr_mto_int.log_message

5084: COMMIT;
5085: END IF;
5086:
5087: BEGIN
5088: ghr_mto_int.log_message
5089: (p_procedure => g_proc
5090: , p_message => l_log_text);
5091: EXCEPTION
5092: WHEN others THEN