eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSP_AUTOPOP dependencies on HR_UTILITY

Line 756: -- hr_utility.trace_on(null,'autodebug'); Commented by tbalacha

752:
753: BEGIN
754: /* Instead of profile , the segment number is now picked from the table */
755: --For Bug Fix : 1760311 : Introducing Conditional Checking for NA while selecting segment Number
756: -- hr_utility.trace_on(null,'autodebug'); Commented by tbalacha
757: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: Inside main Param values
758: p_acct_type = ' || p_acct_type ||' p_person_id = ' || p_person_id ||' p_assignment_id = '
759: || p_assignment_id ||' p_element_type_id = ' || p_element_type_id ||' p_project_id = ' || p_project_id );
760: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: Inside main Param values Contd:

Line 757: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: Inside main Param values

753: BEGIN
754: /* Instead of profile , the segment number is now picked from the table */
755: --For Bug Fix : 1760311 : Introducing Conditional Checking for NA while selecting segment Number
756: -- hr_utility.trace_on(null,'autodebug'); Commented by tbalacha
757: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: Inside main Param values
758: p_acct_type = ' || p_acct_type ||' p_person_id = ' || p_person_id ||' p_assignment_id = '
759: || p_assignment_id ||' p_element_type_id = ' || p_element_type_id ||' p_project_id = ' || p_project_id );
760: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: Inside main Param values Contd:
761: p_expenditure_organization_id = ' || p_expenditure_organization_id

Line 760: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: Inside main Param values Contd:

756: -- hr_utility.trace_on(null,'autodebug'); Commented by tbalacha
757: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: Inside main Param values
758: p_acct_type = ' || p_acct_type ||' p_person_id = ' || p_person_id ||' p_assignment_id = '
759: || p_assignment_id ||' p_element_type_id = ' || p_element_type_id ||' p_project_id = ' || p_project_id );
760: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: Inside main Param values Contd:
761: p_expenditure_organization_id = ' || p_expenditure_organization_id
762: ||' p_task_id = ' || p_task_id ||' p_award_id = ' || p_award_id ||' p_expenditure_type = ' || p_expenditure_type );
763: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: Inside main Param values Contd:
764: p_gl_code_combination_id = ' || p_gl_code_combination_id ||' p_payroll_date = ' || p_payroll_date );

Line 763: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: Inside main Param values Contd:

759: || p_assignment_id ||' p_element_type_id = ' || p_element_type_id ||' p_project_id = ' || p_project_id );
760: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: Inside main Param values Contd:
761: p_expenditure_organization_id = ' || p_expenditure_organization_id
762: ||' p_task_id = ' || p_task_id ||' p_award_id = ' || p_award_id ||' p_expenditure_type = ' || p_expenditure_type );
763: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: Inside main Param values Contd:
764: p_gl_code_combination_id = ' || p_gl_code_combination_id ||' p_payroll_date = ' || p_payroll_date );
765: IF p_acct_type = 'N' THEN
766: SELECT segment_number
767: INTO l_segment_num

Line 772: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: Getting the value of l_segment_num'|| l_segment_num);

768: FROM psp_auto_segments
769: WHERE business_group_id = p_business_group_id
770: AND set_of_books_id = p_set_of_books_id;
771:
772: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: Getting the value of l_segment_num'|| l_segment_num);
773: -- END IF; should be moved down otherwise will result in unexpected error
774: -- when processing exp --type for correction of bug fix 1907209
775:
776: g_error_api_path := '';

Line 782: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: before FND_FLEX_EXT.get_segments');

778: For Bug 1907209 : Natural Bypass Account Enhancement : Added following code for Skipping the
779: Autopop for Natural Account-lveerubh
780: ****/
781: -- get the original segments
782: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: before FND_FLEX_EXT.get_segments');
783:
784: ccid_exists := FND_FLEX_EXT.get_segments( application_short_name => short_name,
785: key_flex_code => flex_code,
786: structure_number => struct_num,

Line 791: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: after FND_FLEX_EXT.get_segments l_segment_num='||l_segment_num|| 'nsegs='||nsegs);

787: combination_id => p_gl_code_combination_id,
788: n_segments => nsegs,
789: segments => segs);
790:
791: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: after FND_FLEX_EXT.get_segments l_segment_num='||l_segment_num|| 'nsegs='||nsegs);
792:
793: /* Bug Fix 5439154: Support for non Consecutive GL Segments*/
794: OPEN segment_number_csr;
795: l_segment_index :=1 ;

Line 810: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: PSP_AUTOP_SEG_NUM');

806:
807: -- l_seg_no := l_segment_num;
808: IF (l_seg_no >nsegs) OR (l_seg_no IS NULL) THEN
809: --dbms_output.put_line('to test failure on exp type');
810: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: PSP_AUTOP_SEG_NUM');
811: FND_MESSAGE.SET_NAME('PSP','PSP_AUTOP_SEG_NUM');
812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
813: END IF;
814: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: before IF ccid_exists = TRUE l_segment_num ='|| l_segment_num || 'segs(l_seg_no)='|| segs(l_seg_no)||'p_set_of_books_id='|| p_set_of_books_id ||'p_business_group_id='|| p_business_group_id);

Line 814: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: before IF ccid_exists = TRUE l_segment_num ='|| l_segment_num || 'segs(l_seg_no)='|| segs(l_seg_no)||'p_set_of_books_id='|| p_set_of_books_id ||'p_business_group_id='|| p_business_group_id);

810: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: PSP_AUTOP_SEG_NUM');
811: FND_MESSAGE.SET_NAME('PSP','PSP_AUTOP_SEG_NUM');
812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
813: END IF;
814: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: before IF ccid_exists = TRUE l_segment_num ='|| l_segment_num || 'segs(l_seg_no)='|| segs(l_seg_no)||'p_set_of_books_id='|| p_set_of_books_id ||'p_business_group_id='|| p_business_group_id);
815:
816: IF ccid_exists = TRUE THEN
817: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: inside IF ccid_exists = TRUE THEN');
818: OPEN by_pass_na_cur;

Line 817: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: inside IF ccid_exists = TRUE THEN');

813: END IF;
814: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: before IF ccid_exists = TRUE l_segment_num ='|| l_segment_num || 'segs(l_seg_no)='|| segs(l_seg_no)||'p_set_of_books_id='|| p_set_of_books_id ||'p_business_group_id='|| p_business_group_id);
815:
816: IF ccid_exists = TRUE THEN
817: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: inside IF ccid_exists = TRUE THEN');
818: OPEN by_pass_na_cur;
819: FETCH by_pass_na_cur INTO l_by_pass_na;
820: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: inside l_by_pass_na='|| l_by_pass_na);
821:

Line 820: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: inside l_by_pass_na='|| l_by_pass_na);

816: IF ccid_exists = TRUE THEN
817: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: inside IF ccid_exists = TRUE THEN');
818: OPEN by_pass_na_cur;
819: FETCH by_pass_na_cur INTO l_by_pass_na;
820: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: inside l_by_pass_na='|| l_by_pass_na);
821:
822: IF by_pass_na_cur%FOUND THEN
823: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: inside by_pass_na_cur%FOUND THEN');
824:

Line 823: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: inside by_pass_na_cur%FOUND THEN');

819: FETCH by_pass_na_cur INTO l_by_pass_na;
820: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: inside l_by_pass_na='|| l_by_pass_na);
821:
822: IF by_pass_na_cur%FOUND THEN
823: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: inside by_pass_na_cur%FOUND THEN');
824:
825: -- By-Pass Natural Account Segment passed
826: -- Skip auto-population.
827: CLOSE by_pass_na_cur;

Line 832: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: FND_FLEX_EXT.get_segments:CCID'||p_gl_code_combination_id||' passed in does not exist'||':'||g_error_api_path);

828: RAISE BY_PASS_NA_FOUND;
829: END IF;
830: CLOSE by_pass_na_cur;
831: ELSE
832: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: FND_FLEX_EXT.get_segments:CCID'||p_gl_code_combination_id||' passed in does not exist'||':'||g_error_api_path);
833: g_error_api_path := 'FND_FLEX_EXT.get_segments:CCID'||p_gl_code_combination_id||' passed in does not exist'||':'||g_error_api_path;
834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
835: END IF; -- end of if_ccid_exists
836: --End of Fix for Bug :1907209 : Natural By Pass Account -lveerubh

Line 839: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: before IF p_expenditure_type is NOT NULL THEN ');

835: END IF; -- end of if_ccid_exists
836: --End of Fix for Bug :1907209 : Natural By Pass Account -lveerubh
837: END IF; -- end of p_acct_type='N' -- subha for correction of bug fix 1907209
838:
839: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: before IF p_expenditure_type is NOT NULL THEN ');
840:
841: -- Check By-Pass Table to skip following
842: -- code if passed expenditure type is in
843: -- user defined By-Pass Table.

Line 864: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: before OPEN period_type_c ');

860: END IF;
861:
862: -- Determine Period Type of assignment's payroll.
863: --dbms_output.put_line('before period type cursor ');
864: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: before OPEN period_type_c ');
865:
866: OPEN period_type_c;
867: FETCH period_type_c INTO
868: l_period_type;

Line 887: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: Before Calling Dynamic Queny');

883: -- Cycle through either expenditure type
884: -- or Natural Account rules, depending
885: -- on the value of p_acct_type.
886: --dbms_output.put_line('before calling dynmaic query ');
887: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: Before Calling Dynamic Queny');
888: DynamicQuery(
889: p_person_id => p_person_id,
890: p_assignment_id => p_assignment_id,
891: p_element_type_id => p_element_type_id,

Line 903: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: after Calling Dynamic Queny l_return_status= '|| l_return_status);

899: p_business_group_id => p_business_group_id,
900: p_gl_code_combination_id => p_gl_code_combination_id,
901: p_return_status => l_return_status
902: );
903: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: after Calling Dynamic Queny l_return_status= '|| l_return_status);
904:
905:
906: IF l_return_status <> fnd_api.g_ret_sts_success THEN
907: g_error_api_path := 'DYNAMIC QUERY='||to_char(l_lookup_id)||':'||g_error_api_path;

Line 930: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: EXPENDITURE TYPE - RULE NO ='||l_acct_seq_num||' ');

926: IF exp_accts_c%NOTFOUND THEN
927: CLOSE exp_accts_c;
928: EXIT;
929: END IF;
930: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: ***************EXPENDITURE TYPE - RULE NO ='||l_acct_seq_num||' ***************');
931: ELSIF p_acct_type = 'N' THEN
932: --dbms_output.put_line('p_acct_type'||p_acct_type);
933: --dbms_output.put_line('p_payroll_date'||to_char(p_payroll_date));
934: FETCH na_accts_c into

Line 937: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: inside the loop fetched values:l_period_type=' || l_period_type|| 'l_acct_id='|| l_acct_id||'l_segment_num='||l_segment_num ||'l_natural_account='||l_natural_account );

933: --dbms_output.put_line('p_payroll_date'||to_char(p_payroll_date));
934: FETCH na_accts_c into
935: l_acct_id,l_segment_num,
936: l_natural_account, l_acct_seq_num;
937: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: inside the loop fetched values:l_period_type=' || l_period_type|| 'l_acct_id='|| l_acct_id||'l_segment_num='||l_segment_num ||'l_natural_account='||l_natural_account );
938: IF l_acct_id is NULL THEN
939: --dbms_output.put_line('acct_id'||','||to_char(l_acct_id)||','||l_natural_account);
940: null;
941:

Line 945: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: exiting from outer loop' );

941:
942: END IF;
943: IF na_accts_c%NOTFOUND THEN
944: CLOSE na_accts_c;
945: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: exiting from outer loop' );
946: EXIT;
947: END IF;
948: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: ****************NATURAL ACCOUNT - RULE NO ='||l_acct_seq_num||' ***************');
949: END IF;

Line 948: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: **NATURAL ACCOUNT - RULE NO ='||l_acct_seq_num||' *');

944: CLOSE na_accts_c;
945: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: exiting from outer loop' );
946: EXIT;
947: END IF;
948: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: ****************NATURAL ACCOUNT - RULE NO ='||l_acct_seq_num||' ***************');
949: END IF;
950:
951: -- Delete all records from PL/SQL table that will
952: -- hold the resolved values of the parameter expressions

Line 959: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: before OPEN params_c(l_acct_id) ACCT_ID ='||l_acct_id);

955: v_resolved.DELETE;
956:
957: -- Cycle through all parameter expressions for the
958: -- current rule and exit when no parameter exrpressions found.
959: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: before OPEN params_c(l_acct_id) ACCT_ID ='||l_acct_id);
960:
961: OPEN params_c(l_acct_id); LOOP
962: FETCH params_c into
963: l_param_line_num,

Line 1035: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: before if lookup_array.EXISTS');

1031: -- values for each of the parameter expressions
1032: -- cycled through in the current loop.
1033: */
1034: --dbms_output.put_line('before accessing the array');
1035: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: before if lookup_array.EXISTS');
1036: if lookup_array.EXISTS(l_lookup_id)THEN
1037: l_datatype:=lookup_array(l_lookup_id).data_type;
1038: l_varchar_results:=lookup_array(l_lookup_id).charres;
1039: l_number_results:=lookup_array(l_lookup_id).numres;

Line 1046: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: before seraching for datatype l_param_line_num ='||l_param_line_num);

1042:
1043:
1044: --dbms_output.put_line('after fetch from temp');
1045: --dbms_output.put_line('data type '||l_datatype);
1046: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: before seraching for datatype l_param_line_num ='||l_param_line_num);
1047: IF l_datatype = 'VARCHAR2' THEN
1048: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: in VArchar2');
1049: hr_utility.trace('Autodebug Message:PSP_AUTOPOP:variable ='||l_varchar_results||' user_value='||l_user_value);
1050: IF l_operand = '=' THEN

Line 1048: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: in VArchar2');

1044: --dbms_output.put_line('after fetch from temp');
1045: --dbms_output.put_line('data type '||l_datatype);
1046: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: before seraching for datatype l_param_line_num ='||l_param_line_num);
1047: IF l_datatype = 'VARCHAR2' THEN
1048: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: in VArchar2');
1049: hr_utility.trace('Autodebug Message:PSP_AUTOPOP:variable ='||l_varchar_results||' user_value='||l_user_value);
1050: IF l_operand = '=' THEN
1051: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: in = block');
1052: IF l_varchar_results IS NULL AND l_user_value IS NULL THEN

Line 1049: hr_utility.trace('Autodebug Message:PSP_AUTOPOP:variable ='||l_varchar_results||' user_value='||l_user_value);

1045: --dbms_output.put_line('data type '||l_datatype);
1046: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: before seraching for datatype l_param_line_num ='||l_param_line_num);
1047: IF l_datatype = 'VARCHAR2' THEN
1048: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: in VArchar2');
1049: hr_utility.trace('Autodebug Message:PSP_AUTOPOP:variable ='||l_varchar_results||' user_value='||l_user_value);
1050: IF l_operand = '=' THEN
1051: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: in = block');
1052: IF l_varchar_results IS NULL AND l_user_value IS NULL THEN
1053: v_resolved(l_param_line_num) := v_true;

Line 1051: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: in = block');

1047: IF l_datatype = 'VARCHAR2' THEN
1048: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: in VArchar2');
1049: hr_utility.trace('Autodebug Message:PSP_AUTOPOP:variable ='||l_varchar_results||' user_value='||l_user_value);
1050: IF l_operand = '=' THEN
1051: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: in = block');
1052: IF l_varchar_results IS NULL AND l_user_value IS NULL THEN
1053: v_resolved(l_param_line_num) := v_true;
1054: ELSIF l_varchar_results = l_user_value THEN
1055: v_resolved(l_param_line_num) := v_true;

Line 1100: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: in Number l_param_line_num ='||l_param_line_num);

1096: END IF;
1097: END IF;
1098:
1099: ELSIF l_datatype = 'NUMBER' THEN
1100: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: in Number l_param_line_num ='||l_param_line_num);
1101: hr_utility.trace('Autodebug Message:PSP_AUTOPOP:variable ='||l_number_results||' user_value='||l_user_value);
1102:
1103: IF l_operand = '=' THEN
1104: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: in = block');

Line 1101: hr_utility.trace('Autodebug Message:PSP_AUTOPOP:variable ='||l_number_results||' user_value='||l_user_value);

1097: END IF;
1098:
1099: ELSIF l_datatype = 'NUMBER' THEN
1100: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: in Number l_param_line_num ='||l_param_line_num);
1101: hr_utility.trace('Autodebug Message:PSP_AUTOPOP:variable ='||l_number_results||' user_value='||l_user_value);
1102:
1103: IF l_operand = '=' THEN
1104: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: in = block');
1105: IF l_number_results IS NULL AND l_user_value IS NULL THEN

Line 1104: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: in = block');

1100: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: in Number l_param_line_num ='||l_param_line_num);
1101: hr_utility.trace('Autodebug Message:PSP_AUTOPOP:variable ='||l_number_results||' user_value='||l_user_value);
1102:
1103: IF l_operand = '=' THEN
1104: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: in = block');
1105: IF l_number_results IS NULL AND l_user_value IS NULL THEN
1106: v_resolved(l_param_line_num) := v_true;
1107: ELSIF l_number_results = to_number(l_user_value) THEN
1108: v_resolved(l_param_line_num) := v_true;

Line 1167: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: in Date l_param_line_num ='||l_param_line_num);

1163: END IF;
1164: END IF;
1165:
1166: ELSIF l_datatype = 'DATE' THEN
1167: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: in Date l_param_line_num ='||l_param_line_num);
1168: hr_utility.trace('Autodebug Message:PSP_AUTOPOP:variable ='||l_date_results||' user_value='||l_user_value);
1169:
1170: IF l_operand = '=' THEN
1171: IF l_date_results IS NULL AND l_user_value IS NULL THEN

Line 1168: hr_utility.trace('Autodebug Message:PSP_AUTOPOP:variable ='||l_date_results||' user_value='||l_user_value);

1164: END IF;
1165:
1166: ELSIF l_datatype = 'DATE' THEN
1167: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: in Date l_param_line_num ='||l_param_line_num);
1168: hr_utility.trace('Autodebug Message:PSP_AUTOPOP:variable ='||l_date_results||' user_value='||l_user_value);
1169:
1170: IF l_operand = '=' THEN
1171: IF l_date_results IS NULL AND l_user_value IS NULL THEN
1172: v_resolved(l_param_line_num) := v_true;

Line 1240: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: after Loop');

1236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1237: END IF;
1238:
1239: END LOOP;
1240: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: after Loop');
1241:
1242:
1243: -- Determine how many parameter expressions were looped
1244: -- through. If zero, then raise unexpected error. There

Line 1249: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: last_line_num = '||last_line_num );

1245: -- should never be a rule with a rule definition but
1246: -- no parameter expressions.
1247:
1248: last_line_num := v_resolved.last;
1249: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: last_line_num = '||last_line_num );
1250:
1251: IF last_line_num IS NULL THEN
1252: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: NO PARAMETERS:ACCT_ID='||to_char(l_acct_id)||':'||g_error_api_path);
1253: g_error_api_path := 'NO PARAMETERS:ACCT_ID='||to_char(l_acct_id)||':'||g_error_api_path;

Line 1252: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: NO PARAMETERS:ACCT_ID='||to_char(l_acct_id)||':'||g_error_api_path);

1248: last_line_num := v_resolved.last;
1249: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: last_line_num = '||last_line_num );
1250:
1251: IF last_line_num IS NULL THEN
1252: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: NO PARAMETERS:ACCT_ID='||to_char(l_acct_id)||':'||g_error_api_path);
1253: g_error_api_path := 'NO PARAMETERS:ACCT_ID='||to_char(l_acct_id)||':'||g_error_api_path;
1254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1255: END IF;
1256:

Line 1266: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: before opening the cursor rules_c l_acct_id='|| l_acct_id);

1262: -- being processed. There should always be a calculator
1263: -- rule (i.e., 1 AND 2 OR 3 ) for a rule which has a
1264: -- rule definition which is criteria of the cursor.
1265:
1266: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: before opening the cursor rules_c l_acct_id='|| l_acct_id);
1267: open rules_c(l_acct_id);
1268: fetch rules_c into l_calculator_rule;
1269: --dbms_output.put_line('l_calculator_rule '||','||l_calculator_rule);
1270: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: inside the cursor rules_c l_calculator_rule' || l_calculator_rule);

Line 1270: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: inside the cursor rules_c l_calculator_rule' || l_calculator_rule);

1266: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: before opening the cursor rules_c l_acct_id='|| l_acct_id);
1267: open rules_c(l_acct_id);
1268: fetch rules_c into l_calculator_rule;
1269: --dbms_output.put_line('l_calculator_rule '||','||l_calculator_rule);
1270: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: inside the cursor rules_c l_calculator_rule' || l_calculator_rule);
1271:
1272: IF rules_c%NOTFOUND THEN
1273: --dbms_output.put_line('no rule found');
1274: close rules_c;

Line 1276: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: cursor rules_c not found l_calculator_rule' || l_calculator_rule);

1272: IF rules_c%NOTFOUND THEN
1273: --dbms_output.put_line('no rule found');
1274: close rules_c;
1275: g_error_api_path := 'NO RULE:ACCT_ID='||to_char(l_acct_id)||':'||g_error_api_path;
1276: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: cursor rules_c not found l_calculator_rule' || l_calculator_rule);
1277:
1278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1279: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: after l_cal_rule Raised FND_API.G_EXC_UNEXPECTED_ERROR');
1280: END IF;

Line 1279: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: after l_cal_rule Raised FND_API.G_EXC_UNEXPECTED_ERROR');

1275: g_error_api_path := 'NO RULE:ACCT_ID='||to_char(l_acct_id)||':'||g_error_api_path;
1276: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: cursor rules_c not found l_calculator_rule' || l_calculator_rule);
1277:
1278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1279: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: after l_cal_rule Raised FND_API.G_EXC_UNEXPECTED_ERROR');
1280: END IF;
1281: close rules_c;
1282:
1283: -- Use the values of the resolved parameter

Line 1289: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: resolved_rule '||l_calculator_rule);

1285: -- to replace the parameter line numbers in the
1286: -- rule string.
1287:
1288: resolved_rule := ltrim(l_calculator_rule);
1289: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: resolved_rule '||l_calculator_rule);
1290:
1291: --dbms_output.put_line('after rule assignment '||resolved_rule);
1292:
1293: /* replaced 1 by first_line_num :- Subha July 19, 2000 */

Line 1309: hr_utility.trace('Autodebug Message:PSP_AUTOPOP '||resolved_rule);

1305: resolved_rule:=REPLACE(resolved_rule,v_true,'1=1');
1306: resolved_rule:=REPLACE(resolved_rule,v_false,'1=0');
1307:
1308: -- dbms_output.put_line('Before call to resolve_rule with text string:'||resolved_rule);
1309: hr_utility.trace('Autodebug Message:PSP_AUTOPOP '||resolved_rule);
1310: -- IF resolve_rules(resolved_rule) THEN bug fix 2023955
1311: IF resolve_rules_new(resolved_rule) THEN
1312: hr_utility.trace('Autodebug Message:PSP_AUTOPOP rule is true ');
1313: -- dbms_output.put_line('RULE IS TRUE!!!');

Line 1312: hr_utility.trace('Autodebug Message:PSP_AUTOPOP rule is true ');

1308: -- dbms_output.put_line('Before call to resolve_rule with text string:'||resolved_rule);
1309: hr_utility.trace('Autodebug Message:PSP_AUTOPOP '||resolved_rule);
1310: -- IF resolve_rules(resolved_rule) THEN bug fix 2023955
1311: IF resolve_rules_new(resolved_rule) THEN
1312: hr_utility.trace('Autodebug Message:PSP_AUTOPOP rule is true ');
1313: -- dbms_output.put_line('RULE IS TRUE!!!');
1314: l_rule_match := TRUE;
1315: EXIT;
1316: ELSE

Line 1317: hr_utility.trace('Autodebug Message:PSP_AUTOPOP rule is false');

1313: -- dbms_output.put_line('RULE IS TRUE!!!');
1314: l_rule_match := TRUE;
1315: EXIT;
1316: ELSE
1317: hr_utility.trace('Autodebug Message:PSP_AUTOPOP rule is false');
1318: -- dbms_output.put_line('RULE IS FALSE!!!');
1319: --null;
1320: END IF;
1321:

Line 1323: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: outside of outer loop');

1319: --null;
1320: END IF;
1321:
1322: END LOOP;
1323: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: outside of outer loop');
1324:
1325: lookup_array.delete;
1326: IF l_rule_match THEN
1327: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: in side IF l_rule_match ' );

Line 1327: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: in side IF l_rule_match ' );

1323: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: outside of outer loop');
1324:
1325: lookup_array.delete;
1326: IF l_rule_match THEN
1327: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: in side IF l_rule_match ' );
1328: IF p_acct_type = 'E' THEN
1329: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: inside IF p_acct_type = E');
1330: ret_expenditure_type := l_expenditure_type;
1331: ELSIF p_acct_type = 'N' THEN

Line 1329: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: inside IF p_acct_type = E');

1325: lookup_array.delete;
1326: IF l_rule_match THEN
1327: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: in side IF l_rule_match ' );
1328: IF p_acct_type = 'E' THEN
1329: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: inside IF p_acct_type = E');
1330: ret_expenditure_type := l_expenditure_type;
1331: ELSIF p_acct_type = 'N' THEN
1332: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: inside IF p_acct_type = N');
1333: -- *************************************************************

Line 1332: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: inside IF p_acct_type = N');

1328: IF p_acct_type = 'E' THEN
1329: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: inside IF p_acct_type = E');
1330: ret_expenditure_type := l_expenditure_type;
1331: ELSIF p_acct_type = 'N' THEN
1332: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: inside IF p_acct_type = N');
1333: -- *************************************************************
1334: -- Make calls to FND_FLEX_EXT
1335: -- *************************************************************
1336: /* For Bug 1907209 : Natural Bypass Account : Call to get the original segments has been moved to the top

Line 1383: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: before calling FND_FLEX_EXT.get_combination_id') ;

1379: END IF;
1380: */
1381: --segs(nsegs ) := l_natural_account;
1382: segs(l_seg_no) := l_natural_account;
1383: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: before calling FND_FLEX_EXT.get_combination_id') ;
1384: combo_valid := FND_FLEX_EXT.get_combination_id(application_short_name => short_name,
1385: key_flex_code => flex_code,
1386: structure_number => struct_num,
1387: validation_date => SYSDATE,

Line 1391: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: after calling FND_FLEX_EXT get_combination_id combo_valid = ');

1387: validation_date => SYSDATE,
1388: n_segments => nsegs,
1389: segments => segs,
1390: combination_id => new_gl_ccid);
1391: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: after calling FND_FLEX_EXT get_combination_id combo_valid = ');
1392:
1393: IF (combo_valid = TRUE) THEN
1394: ret_gl_code_combination_id := new_gl_ccid;
1395: ELSE

Line 1398: hr_utility.trace('Autodebug Message:PSP_AUTOPOP:'|| g_error_api_path);

1394: ret_gl_code_combination_id := new_gl_ccid;
1395: ELSE
1396: g_error_api_path := 'FND_FLEX_EXT.get_combination_id:Error creating new ccid with old CCID = '
1397: ||p_gl_code_combination_id||': Object_code = '||l_natural_account||':'||g_error_api_path;
1398: hr_utility.trace('Autodebug Message:PSP_AUTOPOP:'|| g_error_api_path);
1399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1400: END IF;
1401: /* For Bug 1907209 : Natural Bypass Account : Call to get the original segments has been moved to the top
1402: becase of the enhancement -lveerubh

Line 1414: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: SUCCESS RULE FOUND');

1410: END IF;
1411:
1412: retcode := FND_API.G_RET_STS_SUCCESS;
1413: -- --dbms_output.put_line('Rule was found!!!');
1414: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: SUCCESS RULE FOUND');
1415: ELSE
1416: retcode := FND_API.G_RET_STS_ERROR;
1417: -- --dbms_output.put_line('No rule found that matched.');
1418: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: NO RULE FOUND');

Line 1418: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: NO RULE FOUND');

1414: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: SUCCESS RULE FOUND');
1415: ELSE
1416: retcode := FND_API.G_RET_STS_ERROR;
1417: -- --dbms_output.put_line('No rule found that matched.');
1418: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: NO RULE FOUND');
1419: END IF;
1420: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: END MAIN with out Exception'||retcode);
1421: -- hr_utility.trace_off ; Commented by tbalacha
1422:

Line 1420: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: END MAIN with out Exception'||retcode);

1416: retcode := FND_API.G_RET_STS_ERROR;
1417: -- --dbms_output.put_line('No rule found that matched.');
1418: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: NO RULE FOUND');
1419: END IF;
1420: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: END MAIN with out Exception'||retcode);
1421: -- hr_utility.trace_off ; Commented by tbalacha
1422:
1423: EXCEPTION
1424: WHEN BY_PASS_FOUND THEN

Line 1421: -- hr_utility.trace_off ; Commented by tbalacha

1417: -- --dbms_output.put_line('No rule found that matched.');
1418: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: NO RULE FOUND');
1419: END IF;
1420: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: END MAIN with out Exception'||retcode);
1421: -- hr_utility.trace_off ; Commented by tbalacha
1422:
1423: EXCEPTION
1424: WHEN BY_PASS_FOUND THEN
1425: ret_expenditure_type := p_expenditure_type;

Line 1427: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: EXCEPTIOn BY_PASS_FOUND');

1423: EXCEPTION
1424: WHEN BY_PASS_FOUND THEN
1425: ret_expenditure_type := p_expenditure_type;
1426: retcode := FND_API.G_RET_STS_SUCCESS;
1427: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: EXCEPTIOn BY_PASS_FOUND');
1428:
1429: WHEN NO_PERIOD_TYPE THEN
1430: retcode := FND_API.G_RET_STS_UNEXP_ERROR;
1431: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: EXCEPTIOn NO_PERIOD_TYPE');

Line 1431: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: EXCEPTIOn NO_PERIOD_TYPE');

1427: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: EXCEPTIOn BY_PASS_FOUND');
1428:
1429: WHEN NO_PERIOD_TYPE THEN
1430: retcode := FND_API.G_RET_STS_UNEXP_ERROR;
1431: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: EXCEPTIOn NO_PERIOD_TYPE');
1432:
1433: -- For Bug 1907209 : Natrual Bypass Account Enhancement - Added the following Exception -lveerubh
1434: WHEN BY_PASS_NA_FOUND THEN
1435: ret_gl_code_combination_id := p_gl_code_combination_id;

Line 1437: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: EXCEPTIOn BY_PASS_NA_FOUND');

1433: -- For Bug 1907209 : Natrual Bypass Account Enhancement - Added the following Exception -lveerubh
1434: WHEN BY_PASS_NA_FOUND THEN
1435: ret_gl_code_combination_id := p_gl_code_combination_id;
1436: retcode := FND_API.G_RET_STS_SUCCESS;
1437: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: EXCEPTIOn BY_PASS_NA_FOUND');
1438: WHEN OTHERS THEN
1439: --dbms_output.put_line('Exception in Auto-Population:PSP_AUTOPOP:'||g_error_api_path);
1440: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: EXCEPTIOn OTHERS');
1441:

Line 1440: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: EXCEPTIOn OTHERS');

1436: retcode := FND_API.G_RET_STS_SUCCESS;
1437: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: EXCEPTIOn BY_PASS_NA_FOUND');
1438: WHEN OTHERS THEN
1439: --dbms_output.put_line('Exception in Auto-Population:PSP_AUTOPOP:'||g_error_api_path);
1440: hr_utility.trace('Autodebug Message:PSP_AUTOPOP: EXCEPTIOn OTHERS');
1441:
1442: retcode := FND_API.G_RET_STS_UNEXP_ERROR;
1443: END main;
1444: