DBA Data[Home] [Help]

APPS.CE_BANK_GROUPINGS dependencies on STANDARD

Line 229: cep_standard.enable_debug(p_debug_path, p_debug_file);

225: curr_module := 'CE_BAND_GROUPING';
226:
227: c := '1';
228: if l_debug in ('Y', 'C') then
229: cep_standard.enable_debug(p_debug_path, p_debug_file);
230: cep_standard.debug('>>CE_BANK_GROUPINGS.grouping '||sysdate);
231: cep_standard.debug(' p_bank_entity_type = '|| p_bank_entity_type);
232: cep_standard.debug(' p_display_debug = '|| p_display_debug);
233: cep_standard.debug(' p_debug_path = '|| p_debug_path);

Line 230: cep_standard.debug('>>CE_BANK_GROUPINGS.grouping '||sysdate);

226:
227: c := '1';
228: if l_debug in ('Y', 'C') then
229: cep_standard.enable_debug(p_debug_path, p_debug_file);
230: cep_standard.debug('>>CE_BANK_GROUPINGS.grouping '||sysdate);
231: cep_standard.debug(' p_bank_entity_type = '|| p_bank_entity_type);
232: cep_standard.debug(' p_display_debug = '|| p_display_debug);
233: cep_standard.debug(' p_debug_path = '|| p_debug_path);
234: cep_standard.debug(' p_debug_file = '|| p_debug_file);

Line 231: cep_standard.debug(' p_bank_entity_type = '|| p_bank_entity_type);

227: c := '1';
228: if l_debug in ('Y', 'C') then
229: cep_standard.enable_debug(p_debug_path, p_debug_file);
230: cep_standard.debug('>>CE_BANK_GROUPINGS.grouping '||sysdate);
231: cep_standard.debug(' p_bank_entity_type = '|| p_bank_entity_type);
232: cep_standard.debug(' p_display_debug = '|| p_display_debug);
233: cep_standard.debug(' p_debug_path = '|| p_debug_path);
234: cep_standard.debug(' p_debug_file = '|| p_debug_file);
235: end if;

Line 232: cep_standard.debug(' p_display_debug = '|| p_display_debug);

228: if l_debug in ('Y', 'C') then
229: cep_standard.enable_debug(p_debug_path, p_debug_file);
230: cep_standard.debug('>>CE_BANK_GROUPINGS.grouping '||sysdate);
231: cep_standard.debug(' p_bank_entity_type = '|| p_bank_entity_type);
232: cep_standard.debug(' p_display_debug = '|| p_display_debug);
233: cep_standard.debug(' p_debug_path = '|| p_debug_path);
234: cep_standard.debug(' p_debug_file = '|| p_debug_file);
235: end if;
236:

Line 233: cep_standard.debug(' p_debug_path = '|| p_debug_path);

229: cep_standard.enable_debug(p_debug_path, p_debug_file);
230: cep_standard.debug('>>CE_BANK_GROUPINGS.grouping '||sysdate);
231: cep_standard.debug(' p_bank_entity_type = '|| p_bank_entity_type);
232: cep_standard.debug(' p_display_debug = '|| p_display_debug);
233: cep_standard.debug(' p_debug_path = '|| p_debug_path);
234: cep_standard.debug(' p_debug_file = '|| p_debug_file);
235: end if;
236:
237: --

Line 234: cep_standard.debug(' p_debug_file = '|| p_debug_file);

230: cep_standard.debug('>>CE_BANK_GROUPINGS.grouping '||sysdate);
231: cep_standard.debug(' p_bank_entity_type = '|| p_bank_entity_type);
232: cep_standard.debug(' p_display_debug = '|| p_display_debug);
233: cep_standard.debug(' p_debug_path = '|| p_debug_path);
234: cep_standard.debug(' p_debug_file = '|| p_debug_file);
235: end if;
236:
237: --
238: -- Check if the bank upgrade mode is ready for grouping

Line 477: cep_standard.debug('c_upg_id.count='||to_char(c_upg_id.count));

473: and group_id is null;
474:
475: else
476: if l_debug in ('Y', 'C') then
477: cep_standard.debug('c_upg_id.count='||to_char(c_upg_id.count));
478: end if;
479: exit;
480: end if;
481: tot_count := sql%rowcount;

Line 491: cep_standard.debug('Total bank count='||to_char(tot_count));

487:
488: c := '15';
489: close bank_cur;
490: if l_debug in ('Y', 'C') then
491: cep_standard.debug('Total bank count='||to_char(tot_count));
492: end if;
493:
494: -- Populate secondary attributes to primary records
495: c := '16';

Line 1024: cep_standard.debug('c_upg_id.count='||to_char(c_upg_id.count));

1020: and group_id is null;
1021:
1022: else
1023: if l_debug in ('Y', 'C') then
1024: cep_standard.debug('c_upg_id.count='||to_char(c_upg_id.count));
1025: end if;
1026: exit;
1027: end if;
1028: tot_count := sql%rowcount;

Line 1038: cep_standard.debug('Total branch count='||to_char(tot_count));

1034:
1035: c := '62';
1036: close branch_cur;
1037: if l_debug in ('Y', 'C') then
1038: cep_standard.debug('Total branch count='||to_char(tot_count));
1039: end if;
1040:
1041: -- Populate secondary attributes to primary records
1042: c := '63';

Line 1571: cep_standard.debug('c_upg_id.count='||to_char(c_upg_id.count));

1567: c := '108';
1568:
1569: else
1570: if l_debug in ('Y', 'C') then
1571: cep_standard.debug('c_upg_id.count='||to_char(c_upg_id.count));
1572: end if;
1573: exit;
1574: end if;
1575: tot_count := sql%rowcount;

Line 1585: cep_standard.debug('Total account count='||to_char(tot_count));

1581:
1582: c := '110';
1583: close acct_cur;
1584: if l_debug in ('Y', 'C') then
1585: cep_standard.debug('Total account count='||to_char(tot_count));
1586: end if;
1587:
1588: -- Populate secondary attributes to primary records
1589: c := '111';

Line 1859: cep_standard.debug('c_upg_id.count='||to_char(c_upg_id.count));

1855: and bau2.secondary_acct_use_flag = 'Y');
1856:
1857: else
1858: if l_debug in ('Y', 'C') then
1859: cep_standard.debug('c_upg_id.count='||to_char(c_upg_id.count));
1860: end if;
1861: exit;
1862: end if;
1863: tot_count := sql%rowcount;

Line 1873: cep_standard.debug('Total account count='||to_char(tot_count));

1869:
1870: c := '132';
1871: close ba_use_cur;
1872: if l_debug in ('Y', 'C') then
1873: cep_standard.debug('Total account count='||to_char(tot_count));
1874: end if;
1875:
1876: --
1877: -- Update GROUPED status to ce_bank_upgrade_modes for 'ACCOUNT' level

Line 1897: cep_standard.debug('<

1893: end if;
1894:
1895: c := '134';
1896: if l_debug in ('Y', 'C') then
1897: cep_standard.debug('< 1898: cep_standard.disable_debug(p_display_debug);
1899: end if;
1900:
1901: c := '135';

Line 1898: cep_standard.disable_debug(p_display_debug);

1894:
1895: c := '134';
1896: if l_debug in ('Y', 'C') then
1897: cep_standard.debug('< 1898: cep_standard.disable_debug(p_display_debug);
1899: end if;
1900:
1901: c := '135';
1902:

Line 1906: cep_standard.debug('c='||c||', the '||p_bank_entity_type||

1902:
1903: EXCEPTION
1904: WHEN NO_DATA_FOUND THEN
1905: if (c_grouping_flag = 'N') then
1906: cep_standard.debug('c='||c||', the '||p_bank_entity_type||
1907: ' upgrade mode is not ready for grouping.');
1908: end if;
1909: WHEN OTHERS THEN
1910: rollback;

Line 1911: cep_standard.debug('sqlerrm='||sqlerrm);

1907: ' upgrade mode is not ready for grouping.');
1908: end if;
1909: WHEN OTHERS THEN
1910: rollback;
1911: cep_standard.debug('sqlerrm='||sqlerrm);
1912: cep_standard.debug('EXCEPTION: CE_BANK_GROUPINGS.grouping c=' || c);
1913: RAISE;
1914:
1915: END; /* grouping */

Line 1912: cep_standard.debug('EXCEPTION: CE_BANK_GROUPINGS.grouping c=' || c);

1908: end if;
1909: WHEN OTHERS THEN
1910: rollback;
1911: cep_standard.debug('sqlerrm='||sqlerrm);
1912: cep_standard.debug('EXCEPTION: CE_BANK_GROUPINGS.grouping c=' || c);
1913: RAISE;
1914:
1915: END; /* grouping */
1916: