DBA Data[Home] [Help]

APPS.PQP_RATES_HISTORY_CALC dependencies on FND_DATE

Line 627: fnd_message.set_token('EFFECTIVEDATE',fnd_date.date_to_canonical(p_date));

623: -- Added a new message for contract type not found
624: -- BUG 3454641
625: hr_utility.set_message(8303, 'PQP_230113_AAT_MISSING_CONTRCT');
626: -- ver 115.35 : anshghos : setting token value
627: fnd_message.set_token('EFFECTIVEDATE',fnd_date.date_to_canonical(p_date));
628: hr_utility.raise_error;
629: -- RETURN 0;
630: --
631: END IF;

Line 732: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));

728: g_debug := hr_utility.debug_enabled;
729: IF g_debug THEN
730: debug_enter(l_proc_name);
731: debug('p_assignment_id:'||p_assignment_id);
732: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));
733: debug('p_business_group_id:'||p_business_group_id);
734: debug('p_contract_type:'||p_contract_type);
735: debug('p_time_dimension:'||p_time_dimension);
736: END IF;

Line 934: debug('p_date:'||fnd_date.date_to_canonical(p_date));

930: g_debug := hr_utility.debug_enabled;
931: IF g_debug THEN
932: debug_enter(l_proc_name);
933: debug('p_assignment_id:'||p_assignment_id);
934: debug('p_date:'||fnd_date.date_to_canonical(p_date));
935: debug('p_value:'||p_value);
936: debug('p_to_time_dim:'||p_to_time_dim);
937: debug('p_from_time_dim:'||p_from_time_dim);
938: debug('p_fte:'||p_fte);

Line 1018: fnd_message.set_token('EFFECTIVEDATE',fnd_date.date_to_canonical(p_date));

1014: IF l_contract_type IS NULL
1015: THEN
1016: hr_utility.set_message(8303, 'PQP_230113_AAT_MISSING_CONTRCT');
1017: -- ver 115.35 : anshghos : setting token value
1018: fnd_message.set_token('EFFECTIVEDATE',fnd_date.date_to_canonical(p_date));
1019: hr_utility.raise_error;
1020: END IF;
1021:
1022: -- Modified code to improve performance

Line 1436: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));

1432: debug_enter(l_proc_name);
1433: IF g_debug THEN
1434: debug('p_element_type_id:'||p_element_type_id);
1435: debug('p_input_value_name:'||p_input_value_name);
1436: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));
1437: debug('p_lookup_input_values_yn:'||p_lookup_input_values_yn);
1438: END IF;
1439:
1440: OPEN csr_input_value_id

Line 1548: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));

1544: debug('p_business_group_id:'||p_business_group_id);
1545: debug('p_table_name:'||p_table_name);
1546: debug('p_column_name:'||p_column_name);
1547: debug('p_row_value:'||p_row_value);
1548: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));
1549: END IF;
1550:
1551: BEGIN -- wrapping the hruserdt.get_table_value call
1552:

Line 1781: debug('p_date:'||fnd_date.date_to_canonical(p_date)); --IN DATE

1777: g_debug := hr_utility.debug_enabled;
1778: IF g_debug THEN
1779: debug_enter(l_proc_name);
1780: debug('p_assignment_id:'||p_assignment_id); --IN NUMBER
1781: debug('p_date:'||fnd_date.date_to_canonical(p_date)); --IN DATE
1782: debug('p_element_type_id:'||p_element_type_id); --IN NUMBER
1783: debug('p_to_time_dim:'||p_to_time_dim); --IN VARCHAR2
1784: debug('p_fte:'||p_fte); --IN VARCHAR2
1785: debug('p_service_history:'||p_service_history); --IN VARCHAR2

Line 2341: fnd_date.date_to_canonical(p_calculation_date));

2337: IF g_debug THEN
2338: debug_enter(l_proc_name);
2339: debug('p_assignment_id:'||p_assignment_id);
2340: debug('p_calculation_date:'||
2341: fnd_date.date_to_canonical(p_calculation_date));
2342: debug('p_name:'||p_name);
2343: debug('p_rt_element:'||p_rt_element);
2344: debug('p_to_time_dim:'||p_to_time_dim);
2345: debug('p_rate(INOUT):'||p_rate);

Line 2739: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));

2735: g_debug := hr_utility.debug_enabled;
2736: IF g_debug THEN
2737: debug('p_assignment_id:'||p_assignment_id);
2738: debug('p_rate_name:'||p_rate_name);
2739: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));
2740: debug('p_time_dimension:'||
2741: NVL(p_time_dimension,'ISNULL_SAME_AS_FROM'));
2742: debug('p_rate_type_or_element:'||
2743: NVL(p_rate_type_or_element,'ISNULL_WILL_USE_'||c_default_type_of_rate));

Line 2879: fnd_date.date_to_canonical(p_calculation_date));

2875: IF g_debug THEN
2876: debug_enter(l_proc_name);
2877: debug('p_assignment_id:'||p_assignment_id);
2878: debug('p_calculation_date:'||
2879: fnd_date.date_to_canonical(p_calculation_date));
2880: debug('p_name:'||p_name);
2881: debug('p_rt_element:'||p_rt_element);
2882: debug('p_to_time_dim:'||p_to_time_dim);
2883: debug('p_rate(INOUT):'||p_rate);

Line 3261: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));

3257: g_debug := hr_utility.debug_enabled;
3258: IF g_debug THEN
3259: debug('p_assignment_id:'||p_assignment_id);
3260: debug('p_rate_name:'||p_rate_name);
3261: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));
3262: debug('p_time_dimension:'||
3263: NVL(p_time_dimension,'ISNULL_SAME_AS_FROM'));
3264: debug('p_rate_type_or_element:'||
3265: NVL(p_rate_type_or_element,'ISNULL_WILL_USE_'||c_default_type_of_rate));