[Home] [Help]
115: AND l_person_effective_date between EMP.effective_start_date
116: and NVL (EMP.effective_end_date, sysdate);
117:
118: /* Bug 6053374: Added the Exception block. Exception would be thrown only for a
119: Standard Invoice, as the case would be taken care in PAXTTXCB itself, for an Expense Report.
120: And for Standard Invoices, System should not throw an error even if the EI date does not fall
121: between effective_start_date and effective_end_date of the employee */
122: EXCEPTION
123: WHEN NO_DATA_FOUND THEN
116: and NVL (EMP.effective_end_date, sysdate);
117:
118: /* Bug 6053374: Added the Exception block. Exception would be thrown only for a
119: Standard Invoice, as the case would be taken care in PAXTTXCB itself, for an Expense Report.
120: And for Standard Invoices, System should not throw an error even if the EI date does not fall
121: between effective_start_date and effective_end_date of the employee */
122: EXCEPTION
123: WHEN NO_DATA_FOUND THEN
124: null;
2666:
2667: WHEN no_lookup_type
2668: THEN
2669: reset_error_stack; /* Bug 5233487 */
2670: -- Record standard workflow debugging message
2671: wf_core.context( pkg_name => 'PA_ACC_GEN_WF_PKG ',
2672: proc_name => 'PA_SEG_LOOKUP_SET_VALUE',
2673: arg1 => 'Lookup Set:' || l_seg_value_lookup_set_name,
2674: arg2 => 'Intermediate Value: ' || l_intermediate_value,
2700:
2701: WHEN no_lookup_code
2702: THEN
2703: reset_error_stack; /* Bug 5233487 */
2704: -- Record standard workflow debugging message
2705: wf_core.context( pkg_name => 'PA_ACC_GEN_WF_PKG ',
2706: proc_name => 'PA_SEG_LOOKUP_SET_VALUE',
2707: arg1 => 'Lookup Set:' || l_seg_value_lookup_set_name,
2708: arg2 => 'Intermediate Value: ' || l_intermediate_value,
2741:
2742: WHEN no_data_found
2743: THEN
2744: reset_error_stack; /* Bug 5233487 */
2745: -- Record standard workflow debugging message
2746: wf_core.context( pkg_name => 'PA_ACC_GEN_WF_PKG ',
2747: proc_name => 'PA_SEG_LOOKUP_SET_VALUE',
2748: arg1 => 'Lookup Set:' || l_seg_value_lookup_set_name,
2749: arg2 => 'Intermediate Value: ' || l_intermediate_value,
2807: -- Return a failure so that the abort generation End function is called
2808:
2809: x_result := 'COMPLETE:FAILURE';
2810:
2811: -- Record standard workflow debugging message
2812: wf_core.context( pkg_name => 'PA_ACC_GEN_WF_PKG ',
2813: proc_name => 'PA_SEG_LOOKUP_SET_VALUE',
2814: arg1 => 'Lookup Set:' || l_seg_value_lookup_set_name,
2815: arg2 => 'Intermediate Value: ' || l_intermediate_value,
3061: -- Return a failure so that the abort generation End function is called
3062:
3063: x_result := 'COMPLETE:FAILURE';
3064:
3065: -- Record standard workflow debugging message
3066: wf_core.context( pkg_name => 'PA_ACC_GEN_WF_PKG ',
3067: proc_name => 'PA_AA_FUNCTION_TRANSACTION',
3068: arg1 => 'Function Transaction Code' || l_ft_code,
3069: arg2 => 'Project Type Class Code: ' || l_ptype_class_code,