DBA Data[Home] [Help]

APPS.PSP_AUTOPOP dependencies on FND_FLEX_EXT

Line 597: segs FND_FLEX_EXT.SegmentArray;

593: l_seg_no NUMBER(2);
594: -- For Bug 1907209 : Moved the variables up : Natural Bypass Account Enhancement -lveerubh
595: nsegs NUMBER;
596: cat_segs VARCHAR2(2000);
597: segs FND_FLEX_EXT.SegmentArray;
598: ccid_exists BOOLEAN;
599: combo_valid BOOLEAN;
600: new_gl_ccid NUMBER;
601:

Line 741: segs FND_FLEX_EXT.SegmentArray;

737: /* For Bug 1907209 : Natural Bypass Acount - Moved the declaration of variables up as they are referenced by the
738: Cursor by_na_pass_cur -lveerubh
739: nsegs NUMBER;
740: cat_segs VARCHAR2(2000);
741: segs FND_FLEX_EXT.SegmentArray;
742: ccid_exists BOOLEAN;
743: combo_valid BOOLEAN;
744: new_gl_ccid NUMBER;
745: */

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 784: ccid_exists := FND_FLEX_EXT.get_segments( application_short_name => short_name,

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,
787: combination_id => p_gl_code_combination_id,
788: n_segments => nsegs,

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 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 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;

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
837: END IF; -- end of p_acct_type='N' -- subha for correction of bug fix 1907209

Line 1334: -- Make calls to FND_FLEX_EXT

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
1337: becase of the enhancement -lveerubh
1338: ccid_exists := FND_FLEX_EXT.get_segments(application_short_name => short_name,

Line 1338: ccid_exists := FND_FLEX_EXT.get_segments(application_short_name => short_name,

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
1337: becase of the enhancement -lveerubh
1338: ccid_exists := FND_FLEX_EXT.get_segments(application_short_name => short_name,
1339: key_flex_code => flex_code,
1340: structure_number => struct_num,
1341: combination_id => p_gl_code_combination_id,
1342: n_segments => nsegs,

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 1384: combo_valid := FND_FLEX_EXT.get_combination_id(application_short_name => short_name,

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,
1388: n_segments => nsegs,

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 1396: g_error_api_path := 'FND_FLEX_EXT.get_combination_id:Error creating new ccid with old CCID = '

1392:
1393: IF (combo_valid = TRUE) THEN
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;

Line 1405: g_error_api_path := 'FND_FLEX_EXT.get_segments:CCID'||p_gl_code_combination_id||' passed in does not exist'

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
1403:
1404: ELSE
1405: g_error_api_path := 'FND_FLEX_EXT.get_segments:CCID'||p_gl_code_combination_id||' passed in does not exist'
1406: ||':'||g_error_api_path;
1407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1408: END IF;
1409: */