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.JTF_GRIDDB dependencies on JTF_DEBUG_PUB

Line 2499: l_debug_tbl IN OUT NOCOPY JTF_DEBUG_PUB.debug_tbl_type)

2495: END;
2496:
2497: -----------------------------------------------------------------------
2498: procedure addGridInfo(p_gridIndex IN NUMBER,
2499: l_debug_tbl IN OUT NOCOPY JTF_DEBUG_PUB.debug_tbl_type)
2500: IS
2501: i number;
2502: bind_count number;
2503: l_len_sql number;

Line 2516: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('GRID INDEX',

2512: i := l_debug_tbl.count;
2513: i := i + 1;
2514: l_debug_tbl(i).debug_message := ' ';
2515: i := i + 1;
2516: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('GRID INDEX',
2517: p_gridIndex);
2518: i := i + 1;
2519: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('GRID NAME',
2520: TableDefs(p_gridIndex).gridName);

Line 2519: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('GRID NAME',

2515: i := i + 1;
2516: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('GRID INDEX',
2517: p_gridIndex);
2518: i := i + 1;
2519: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('GRID NAME',
2520: TableDefs(p_gridIndex).gridName);
2521: i := i + 1;
2522: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('TITLE TEXT',
2523: TableDefs(p_gridIndex).title_text);

Line 2522: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('TITLE TEXT',

2518: i := i + 1;
2519: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('GRID NAME',
2520: TableDefs(p_gridIndex).gridName);
2521: i := i + 1;
2522: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('TITLE TEXT',
2523: TableDefs(p_gridIndex).title_text);
2524: i := i + 1;
2525: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('DATASOURCE',
2526: TableDefs(p_gridIndex).grid_datasource_name);

Line 2525: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('DATASOURCE',

2521: i := i + 1;
2522: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('TITLE TEXT',
2523: TableDefs(p_gridIndex).title_text);
2524: i := i + 1;
2525: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('DATASOURCE',
2526: TableDefs(p_gridIndex).grid_datasource_name);
2527: i := i + 1;
2528: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('DB VIEW NAME',
2529: TableDefs(p_gridIndex).db_view_name);

Line 2528: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('DB VIEW NAME',

2524: i := i + 1;
2525: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('DATASOURCE',
2526: TableDefs(p_gridIndex).grid_datasource_name);
2527: i := i + 1;
2528: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('DB VIEW NAME',
2529: TableDefs(p_gridIndex).db_view_name);
2530:
2531: l_len_sql := length(TableDefs(p_gridIndex).SQLStatement);
2532: sql_statement := TableDefs(p_gridIndex).SQLStatement;

Line 2534: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('LAST SQL STATEMENT',substr(sql_statement,len, JTF_DEBUG_PUB.FILE_LINESIZE - JTF_DEBUG_PUB.pad_length));

2530:
2531: l_len_sql := length(TableDefs(p_gridIndex).SQLStatement);
2532: sql_statement := TableDefs(p_gridIndex).SQLStatement;
2533: i := i + 1;
2534: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('LAST SQL STATEMENT',substr(sql_statement,len, JTF_DEBUG_PUB.FILE_LINESIZE - JTF_DEBUG_PUB.pad_length));
2535: len := len + (JTF_DEBUG_PUB.FILE_LINESIZE - JTF_DEBUG_PUB.pad_length);
2536:
2537: while l_len_sql > len loop
2538: i := i + 1;

Line 2535: len := len + (JTF_DEBUG_PUB.FILE_LINESIZE - JTF_DEBUG_PUB.pad_length);

2531: l_len_sql := length(TableDefs(p_gridIndex).SQLStatement);
2532: sql_statement := TableDefs(p_gridIndex).SQLStatement;
2533: i := i + 1;
2534: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('LAST SQL STATEMENT',substr(sql_statement,len, JTF_DEBUG_PUB.FILE_LINESIZE - JTF_DEBUG_PUB.pad_length));
2535: len := len + (JTF_DEBUG_PUB.FILE_LINESIZE - JTF_DEBUG_PUB.pad_length);
2536:
2537: while l_len_sql > len loop
2538: i := i + 1;
2539: l_debug_tbl(i).debug_message := substr(sql_statement,len, JTF_DEBUG_PUB.FILE_LINESIZE);

Line 2539: l_debug_tbl(i).debug_message := substr(sql_statement,len, JTF_DEBUG_PUB.FILE_LINESIZE);

2535: len := len + (JTF_DEBUG_PUB.FILE_LINESIZE - JTF_DEBUG_PUB.pad_length);
2536:
2537: while l_len_sql > len loop
2538: i := i + 1;
2539: l_debug_tbl(i).debug_message := substr(sql_statement,len, JTF_DEBUG_PUB.FILE_LINESIZE);
2540: len := len + JTF_DEBUG_PUB.FILE_LINESIZE;
2541: end loop;
2542:
2543: i := i + 1;

Line 2540: len := len + JTF_DEBUG_PUB.FILE_LINESIZE;

2536:
2537: while l_len_sql > len loop
2538: i := i + 1;
2539: l_debug_tbl(i).debug_message := substr(sql_statement,len, JTF_DEBUG_PUB.FILE_LINESIZE);
2540: len := len + JTF_DEBUG_PUB.FILE_LINESIZE;
2541: end loop;
2542:
2543: i := i + 1;
2544: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber('SQL CURSOR',

Line 2544: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber('SQL CURSOR',

2540: len := len + JTF_DEBUG_PUB.FILE_LINESIZE;
2541: end loop;
2542:
2543: i := i + 1;
2544: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber('SQL CURSOR',
2545: TableDefs(p_gridIndex).SQLCursor);
2546: i := i + 1;
2547: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('REFRESH FLAG',
2548: TableDefs(p_gridIndex).refreshFlag);

Line 2547: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('REFRESH FLAG',

2543: i := i + 1;
2544: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber('SQL CURSOR',
2545: TableDefs(p_gridIndex).SQLCursor);
2546: i := i + 1;
2547: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('REFRESH FLAG',
2548: TableDefs(p_gridIndex).refreshFlag);
2549: -- where clause also greater than the fileline size
2550: len := 1;
2551: whereClause := TableDefs(p_gridIndex).where_clause;

Line 2553: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('CURRENT WHERE CLAUSE', substr(whereClause,len,JTF_DEBUG_PUB.FILE_LINESIZE - JTF_DEBUG_PUB.PAD_LENGTH));

2549: -- where clause also greater than the fileline size
2550: len := 1;
2551: whereClause := TableDefs(p_gridIndex).where_clause;
2552: i := i + 1;
2553: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('CURRENT WHERE CLAUSE', substr(whereClause,len,JTF_DEBUG_PUB.FILE_LINESIZE - JTF_DEBUG_PUB.PAD_LENGTH));
2554: len := len + (JTF_DEBUG_PUB.FILE_LINESIZE - JTF_DEBUG_PUB.pad_length);
2555:
2556: while (length(whereClause) > len) loop
2557: i := i + 1;

Line 2554: len := len + (JTF_DEBUG_PUB.FILE_LINESIZE - JTF_DEBUG_PUB.pad_length);

2550: len := 1;
2551: whereClause := TableDefs(p_gridIndex).where_clause;
2552: i := i + 1;
2553: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('CURRENT WHERE CLAUSE', substr(whereClause,len,JTF_DEBUG_PUB.FILE_LINESIZE - JTF_DEBUG_PUB.PAD_LENGTH));
2554: len := len + (JTF_DEBUG_PUB.FILE_LINESIZE - JTF_DEBUG_PUB.pad_length);
2555:
2556: while (length(whereClause) > len) loop
2557: i := i + 1;
2558: l_debug_tbl(i).debug_message := substr(whereClause,len, JTF_DEBUG_PUB.FILE_LINESIZE);

Line 2558: l_debug_tbl(i).debug_message := substr(whereClause,len, JTF_DEBUG_PUB.FILE_LINESIZE);

2554: len := len + (JTF_DEBUG_PUB.FILE_LINESIZE - JTF_DEBUG_PUB.pad_length);
2555:
2556: while (length(whereClause) > len) loop
2557: i := i + 1;
2558: l_debug_tbl(i).debug_message := substr(whereClause,len, JTF_DEBUG_PUB.FILE_LINESIZE);
2559: len := len + JTF_DEBUG_PUB.FILE_LINESIZE;
2560: end loop;
2561:
2562: i := i + 1;

Line 2559: len := len + JTF_DEBUG_PUB.FILE_LINESIZE;

2555:
2556: while (length(whereClause) > len) loop
2557: i := i + 1;
2558: l_debug_tbl(i).debug_message := substr(whereClause,len, JTF_DEBUG_PUB.FILE_LINESIZE);
2559: len := len + JTF_DEBUG_PUB.FILE_LINESIZE;
2560: end loop;
2561:
2562: i := i + 1;
2563: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('WHERE CLAUSE CHANGED', TableDefs(p_gridIndex).hasWhereClauseChanged);

Line 2563: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('WHERE CLAUSE CHANGED', TableDefs(p_gridIndex).hasWhereClauseChanged);

2559: len := len + JTF_DEBUG_PUB.FILE_LINESIZE;
2560: end loop;
2561:
2562: i := i + 1;
2563: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('WHERE CLAUSE CHANGED', TableDefs(p_gridIndex).hasWhereClauseChanged);
2564: i := i + 1;
2565: bind_count := bindVariablesCount(TableDefs(p_gridIndex).gridName);
2566: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber('BIND VARIABLES COUNT', bind_count);
2567:

Line 2566: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber('BIND VARIABLES COUNT', bind_count);

2562: i := i + 1;
2563: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('WHERE CLAUSE CHANGED', TableDefs(p_gridIndex).hasWhereClauseChanged);
2564: i := i + 1;
2565: bind_count := bindVariablesCount(TableDefs(p_gridIndex).gridName);
2566: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber('BIND VARIABLES COUNT', bind_count);
2567:
2568: if bind_count > 0 then
2569: bind_var := bindVariables.FIRST;
2570: while bind_var is not NULL LOOP

Line 2576: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('BIND NAME'), bindVariables(bind_var).variableName);

2572: = TableDefs(p_gridIndex).gridName then
2573: i := i + 1;
2574: l_debug_tbl(i).debug_message := ' ';
2575: i := i + 1;
2576: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('BIND NAME'), bindVariables(bind_var).variableName);
2577: i := i + 1;
2578: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('BIND TYPE'), bindVariables(bind_var).variableDataType);
2579: i := i + 1;
2580: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('CHAR BIND VALUE'), bindVariables(bind_var).variableCharValue);

Line 2578: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('BIND TYPE'), bindVariables(bind_var).variableDataType);

2574: l_debug_tbl(i).debug_message := ' ';
2575: i := i + 1;
2576: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('BIND NAME'), bindVariables(bind_var).variableName);
2577: i := i + 1;
2578: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('BIND TYPE'), bindVariables(bind_var).variableDataType);
2579: i := i + 1;
2580: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('CHAR BIND VALUE'), bindVariables(bind_var).variableCharValue);
2581: i := i + 1;
2582: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatDate(JTF_DEBUG_PUB.FormatIndent('DATE BIND VALUE'), bindVariables(bind_var).variableDateValue);

Line 2580: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('CHAR BIND VALUE'), bindVariables(bind_var).variableCharValue);

2576: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('BIND NAME'), bindVariables(bind_var).variableName);
2577: i := i + 1;
2578: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('BIND TYPE'), bindVariables(bind_var).variableDataType);
2579: i := i + 1;
2580: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('CHAR BIND VALUE'), bindVariables(bind_var).variableCharValue);
2581: i := i + 1;
2582: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatDate(JTF_DEBUG_PUB.FormatIndent('DATE BIND VALUE'), bindVariables(bind_var).variableDateValue);
2583: i := i + 1;
2584: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber(JTF_DEBUG_PUB.FormatIndent('NUMBER BIND VALUE'), bindVariables(bind_var).variableNumberValue);

Line 2582: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatDate(JTF_DEBUG_PUB.FormatIndent('DATE BIND VALUE'), bindVariables(bind_var).variableDateValue);

2578: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('BIND TYPE'), bindVariables(bind_var).variableDataType);
2579: i := i + 1;
2580: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('CHAR BIND VALUE'), bindVariables(bind_var).variableCharValue);
2581: i := i + 1;
2582: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatDate(JTF_DEBUG_PUB.FormatIndent('DATE BIND VALUE'), bindVariables(bind_var).variableDateValue);
2583: i := i + 1;
2584: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber(JTF_DEBUG_PUB.FormatIndent('NUMBER BIND VALUE'), bindVariables(bind_var).variableNumberValue);
2585:
2586: end if;

Line 2584: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber(JTF_DEBUG_PUB.FormatIndent('NUMBER BIND VALUE'), bindVariables(bind_var).variableNumberValue);

2580: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('CHAR BIND VALUE'), bindVariables(bind_var).variableCharValue);
2581: i := i + 1;
2582: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatDate(JTF_DEBUG_PUB.FormatIndent('DATE BIND VALUE'), bindVariables(bind_var).variableDateValue);
2583: i := i + 1;
2584: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber(JTF_DEBUG_PUB.FormatIndent('NUMBER BIND VALUE'), bindVariables(bind_var).variableNumberValue);
2585:
2586: end if;
2587: bind_var := bindVariables.NEXT(bind_var);
2588: END LOOP;

Line 2593: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('SORT COLUMN1'),

2589: end if;
2590: i := i + 1;
2591: l_debug_tbl(i).debug_message := 'SORT COLUMNS';
2592: i := i + 1;
2593: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('SORT COLUMN1'),
2594: TableDefs(p_gridIndex).grid_sort_col_alias1);
2595: i := i + 1;
2596: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('SORT COLUMN2'),
2597: TableDefs(p_gridIndex).grid_sort_col_alias2);

Line 2596: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('SORT COLUMN2'),

2592: i := i + 1;
2593: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('SORT COLUMN1'),
2594: TableDefs(p_gridIndex).grid_sort_col_alias1);
2595: i := i + 1;
2596: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('SORT COLUMN2'),
2597: TableDefs(p_gridIndex).grid_sort_col_alias2);
2598: i := i + 1;
2599: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('SORT COLUMN3'),
2600: TableDefs(p_gridIndex).grid_sort_col_alias3);

Line 2599: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('SORT COLUMN3'),

2595: i := i + 1;
2596: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('SORT COLUMN2'),
2597: TableDefs(p_gridIndex).grid_sort_col_alias2);
2598: i := i + 1;
2599: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('SORT COLUMN3'),
2600: TableDefs(p_gridIndex).grid_sort_col_alias3);
2601: i := i + 1;
2602: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber('FETCH SIZE',
2603: getFetchSize);

Line 2602: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber('FETCH SIZE',

2598: i := i + 1;
2599: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('SORT COLUMN3'),
2600: TableDefs(p_gridIndex).grid_sort_col_alias3);
2601: i := i + 1;
2602: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber('FETCH SIZE',
2603: getFetchSize);
2604: i := i + 1;
2605: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('MORE ROWS EXIST',
2606: TableDefs(p_gridIndex).moreRowsExists);

Line 2605: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('MORE ROWS EXIST',

2601: i := i + 1;
2602: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber('FETCH SIZE',
2603: getFetchSize);
2604: i := i + 1;
2605: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('MORE ROWS EXIST',
2606: TableDefs(p_gridIndex).moreRowsExists);
2607: i := i + 1;
2608: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber('CURRENT ROW COUNT',
2609: TableDefs(p_gridIndex).rowCount);

Line 2608: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber('CURRENT ROW COUNT',

2604: i := i + 1;
2605: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('MORE ROWS EXIST',
2606: TableDefs(p_gridIndex).moreRowsExists);
2607: i := i + 1;
2608: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber('CURRENT ROW COUNT',
2609: TableDefs(p_gridIndex).rowCount);
2610: i := i + 1;
2611: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber('COLUMN COUNT',
2612: TableDefs(p_gridIndex).colCount);

Line 2611: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber('COLUMN COUNT',

2607: i := i + 1;
2608: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber('CURRENT ROW COUNT',
2609: TableDefs(p_gridIndex).rowCount);
2610: i := i + 1;
2611: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber('COLUMN COUNT',
2612: TableDefs(p_gridIndex).colCount);
2613: i := i + 1;
2614: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber('LINES OF TEXT PER ROW',
2615: TableDefs(p_gridIndex).default_row_height);

Line 2614: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber('LINES OF TEXT PER ROW',

2610: i := i + 1;
2611: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber('COLUMN COUNT',
2612: TableDefs(p_gridIndex).colCount);
2613: i := i + 1;
2614: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber('LINES OF TEXT PER ROW',
2615: TableDefs(p_gridIndex).default_row_height);
2616: i := i + 1;
2617: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber('CUSTOM GRID ID',
2618: TableDefs(p_gridIndex).custom_grid_id);

Line 2617: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber('CUSTOM GRID ID',

2613: i := i + 1;
2614: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber('LINES OF TEXT PER ROW',
2615: TableDefs(p_gridIndex).default_row_height);
2616: i := i + 1;
2617: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber('CUSTOM GRID ID',
2618: TableDefs(p_gridIndex).custom_grid_id);
2619: i := i + 1;
2620: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('CUSTOM GRID NAME',
2621: TableDefs(p_gridIndex).custom_grid_name);

Line 2620: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('CUSTOM GRID NAME',

2616: i := i + 1;
2617: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber('CUSTOM GRID ID',
2618: TableDefs(p_gridIndex).custom_grid_id);
2619: i := i + 1;
2620: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('CUSTOM GRID NAME',
2621: TableDefs(p_gridIndex).custom_grid_name);
2622: i := i + 1;
2623: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber('CUSTOM GRID OWNER',
2624: TableDefs(p_gridIndex).owner);

Line 2623: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber('CUSTOM GRID OWNER',

2619: i := i + 1;
2620: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('CUSTOM GRID NAME',
2621: TableDefs(p_gridIndex).custom_grid_name);
2622: i := i + 1;
2623: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber('CUSTOM GRID OWNER',
2624: TableDefs(p_gridIndex).owner);
2625: i := i + 1;
2626: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('PUBLIC FLAG',
2627: TableDefs(p_gridIndex).public_flag);

Line 2626: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('PUBLIC FLAG',

2622: i := i + 1;
2623: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber('CUSTOM GRID OWNER',
2624: TableDefs(p_gridIndex).owner);
2625: i := i + 1;
2626: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar('PUBLIC FLAG',
2627: TableDefs(p_gridIndex).public_flag);
2628: i := i + 1;
2629: l_debug_tbl(i).debug_message := ' ';
2630: i := i + 1;

Line 2639: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('COLUMN INDEX'), k);

2635: if columndefs(k).gridname = TableDefs(p_gridIndex).gridname then
2636: i := i + 1;
2637: l_debug_tbl(i).debug_message := ' ';
2638: i := i + 1;
2639: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('COLUMN INDEX'), k);
2640: i := i + 1;
2641: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('GRID COL ALIAS'), columndefs(k).grid_col_alias);
2642: i := i + 1;
2643: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('DB COL ALIAS'), columndefs(k).db_col_name);

Line 2641: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('GRID COL ALIAS'), columndefs(k).grid_col_alias);

2637: l_debug_tbl(i).debug_message := ' ';
2638: i := i + 1;
2639: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('COLUMN INDEX'), k);
2640: i := i + 1;
2641: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('GRID COL ALIAS'), columndefs(k).grid_col_alias);
2642: i := i + 1;
2643: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('DB COL ALIAS'), columndefs(k).db_col_name);
2644: i := i + 1;
2645: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('DATA TYPE CODE'), columndefs(k).data_type_code);

Line 2643: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('DB COL ALIAS'), columndefs(k).db_col_name);

2639: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('COLUMN INDEX'), k);
2640: i := i + 1;
2641: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('GRID COL ALIAS'), columndefs(k).grid_col_alias);
2642: i := i + 1;
2643: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('DB COL ALIAS'), columndefs(k).db_col_name);
2644: i := i + 1;
2645: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('DATA TYPE CODE'), columndefs(k).data_type_code);
2646: i := i + 1;
2647: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber(JTF_DEBUG_PUB.FormatIndent('QUERY SEQ'), columndefs(k).query_seq);

Line 2645: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('DATA TYPE CODE'), columndefs(k).data_type_code);

2641: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('GRID COL ALIAS'), columndefs(k).grid_col_alias);
2642: i := i + 1;
2643: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('DB COL ALIAS'), columndefs(k).db_col_name);
2644: i := i + 1;
2645: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('DATA TYPE CODE'), columndefs(k).data_type_code);
2646: i := i + 1;
2647: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber(JTF_DEBUG_PUB.FormatIndent('QUERY SEQ'), columndefs(k).query_seq);
2648: i := i + 1;
2649: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('SORTABLE FLAG'), columndefs(k).sortable_flag);

Line 2647: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber(JTF_DEBUG_PUB.FormatIndent('QUERY SEQ'), columndefs(k).query_seq);

2643: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('DB COL ALIAS'), columndefs(k).db_col_name);
2644: i := i + 1;
2645: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('DATA TYPE CODE'), columndefs(k).data_type_code);
2646: i := i + 1;
2647: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber(JTF_DEBUG_PUB.FormatIndent('QUERY SEQ'), columndefs(k).query_seq);
2648: i := i + 1;
2649: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('SORTABLE FLAG'), columndefs(k).sortable_flag);
2650: i := i + 1;
2651: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('VISIBLE FLAG'), columndefs(k).visible_flag);

Line 2649: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('SORTABLE FLAG'), columndefs(k).sortable_flag);

2645: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('DATA TYPE CODE'), columndefs(k).data_type_code);
2646: i := i + 1;
2647: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber(JTF_DEBUG_PUB.FormatIndent('QUERY SEQ'), columndefs(k).query_seq);
2648: i := i + 1;
2649: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('SORTABLE FLAG'), columndefs(k).sortable_flag);
2650: i := i + 1;
2651: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('VISIBLE FLAG'), columndefs(k).visible_flag);
2652: i := i + 1;
2653: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('FREEZE VISIBLE STATE'), columndefs(k).freeze_visible_flag);

Line 2651: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('VISIBLE FLAG'), columndefs(k).visible_flag);

2647: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber(JTF_DEBUG_PUB.FormatIndent('QUERY SEQ'), columndefs(k).query_seq);
2648: i := i + 1;
2649: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('SORTABLE FLAG'), columndefs(k).sortable_flag);
2650: i := i + 1;
2651: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('VISIBLE FLAG'), columndefs(k).visible_flag);
2652: i := i + 1;
2653: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('FREEZE VISIBLE STATE'), columndefs(k).freeze_visible_flag);
2654: i := i + 1;
2655: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber(JTF_DEBUG_PUB.FormatIndent('DISPLAY INDEX'), columndefs(k).display_index);

Line 2653: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('FREEZE VISIBLE STATE'), columndefs(k).freeze_visible_flag);

2649: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('SORTABLE FLAG'), columndefs(k).sortable_flag);
2650: i := i + 1;
2651: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('VISIBLE FLAG'), columndefs(k).visible_flag);
2652: i := i + 1;
2653: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('FREEZE VISIBLE STATE'), columndefs(k).freeze_visible_flag);
2654: i := i + 1;
2655: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber(JTF_DEBUG_PUB.FormatIndent('DISPLAY INDEX'), columndefs(k).display_index);
2656: i := i + 1;
2657: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('DISPLAY TYPE'), columndefs(k).display_type_code);

Line 2655: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber(JTF_DEBUG_PUB.FormatIndent('DISPLAY INDEX'), columndefs(k).display_index);

2651: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('VISIBLE FLAG'), columndefs(k).visible_flag);
2652: i := i + 1;
2653: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('FREEZE VISIBLE STATE'), columndefs(k).freeze_visible_flag);
2654: i := i + 1;
2655: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber(JTF_DEBUG_PUB.FormatIndent('DISPLAY INDEX'), columndefs(k).display_index);
2656: i := i + 1;
2657: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('DISPLAY TYPE'), columndefs(k).display_type_code);
2658: i := i + 1;
2659: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('DISPLAY FORMAT TYPE'), columndefs(k).display_format_type_code);

Line 2657: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('DISPLAY TYPE'), columndefs(k).display_type_code);

2653: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('FREEZE VISIBLE STATE'), columndefs(k).freeze_visible_flag);
2654: i := i + 1;
2655: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber(JTF_DEBUG_PUB.FormatIndent('DISPLAY INDEX'), columndefs(k).display_index);
2656: i := i + 1;
2657: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('DISPLAY TYPE'), columndefs(k).display_type_code);
2658: i := i + 1;
2659: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('DISPLAY FORMAT TYPE'), columndefs(k).display_format_type_code);
2660: i := i + 1;
2661: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber(JTF_DEBUG_PUB.FormatIndent('DISPLAY WIDTH'), columndefs(k).display_hsize);

Line 2659: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('DISPLAY FORMAT TYPE'), columndefs(k).display_format_type_code);

2655: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber(JTF_DEBUG_PUB.FormatIndent('DISPLAY INDEX'), columndefs(k).display_index);
2656: i := i + 1;
2657: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('DISPLAY TYPE'), columndefs(k).display_type_code);
2658: i := i + 1;
2659: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('DISPLAY FORMAT TYPE'), columndefs(k).display_format_type_code);
2660: i := i + 1;
2661: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber(JTF_DEBUG_PUB.FormatIndent('DISPLAY WIDTH'), columndefs(k).display_hsize);
2662: i := i + 1;
2663: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('HEADER ALIGNMENT '), columndefs(k).header_alignment_code);

Line 2661: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber(JTF_DEBUG_PUB.FormatIndent('DISPLAY WIDTH'), columndefs(k).display_hsize);

2657: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('DISPLAY TYPE'), columndefs(k).display_type_code);
2658: i := i + 1;
2659: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('DISPLAY FORMAT TYPE'), columndefs(k).display_format_type_code);
2660: i := i + 1;
2661: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber(JTF_DEBUG_PUB.FormatIndent('DISPLAY WIDTH'), columndefs(k).display_hsize);
2662: i := i + 1;
2663: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('HEADER ALIGNMENT '), columndefs(k).header_alignment_code);
2664: i := i + 1;
2665: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('CELL ALIGNMENT'), columndefs(k).cell_alignment_code);

Line 2663: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('HEADER ALIGNMENT '), columndefs(k).header_alignment_code);

2659: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('DISPLAY FORMAT TYPE'), columndefs(k).display_format_type_code);
2660: i := i + 1;
2661: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber(JTF_DEBUG_PUB.FormatIndent('DISPLAY WIDTH'), columndefs(k).display_hsize);
2662: i := i + 1;
2663: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('HEADER ALIGNMENT '), columndefs(k).header_alignment_code);
2664: i := i + 1;
2665: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('CELL ALIGNMENT'), columndefs(k).cell_alignment_code);
2666: i := i + 1;
2667: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('DISPLAY FORMAT MASK'), columndefs(k).display_format_mask);

Line 2665: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('CELL ALIGNMENT'), columndefs(k).cell_alignment_code);

2661: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatNumber(JTF_DEBUG_PUB.FormatIndent('DISPLAY WIDTH'), columndefs(k).display_hsize);
2662: i := i + 1;
2663: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('HEADER ALIGNMENT '), columndefs(k).header_alignment_code);
2664: i := i + 1;
2665: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('CELL ALIGNMENT'), columndefs(k).cell_alignment_code);
2666: i := i + 1;
2667: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('DISPLAY FORMAT MASK'), columndefs(k).display_format_mask);
2668: i := i + 1;
2669: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('CHECK BOX CHECKED VALUE'), columndefs(k).checkbox_checked_value);

Line 2667: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('DISPLAY FORMAT MASK'), columndefs(k).display_format_mask);

2663: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('HEADER ALIGNMENT '), columndefs(k).header_alignment_code);
2664: i := i + 1;
2665: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('CELL ALIGNMENT'), columndefs(k).cell_alignment_code);
2666: i := i + 1;
2667: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('DISPLAY FORMAT MASK'), columndefs(k).display_format_mask);
2668: i := i + 1;
2669: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('CHECK BOX CHECKED VALUE'), columndefs(k).checkbox_checked_value);
2670: i := i + 1;
2671: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('CHECK BOX UNCHECKED VALUE'), columndefs(k).checkbox_unchecked_value);

Line 2669: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('CHECK BOX CHECKED VALUE'), columndefs(k).checkbox_checked_value);

2665: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('CELL ALIGNMENT'), columndefs(k).cell_alignment_code);
2666: i := i + 1;
2667: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('DISPLAY FORMAT MASK'), columndefs(k).display_format_mask);
2668: i := i + 1;
2669: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('CHECK BOX CHECKED VALUE'), columndefs(k).checkbox_checked_value);
2670: i := i + 1;
2671: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('CHECK BOX UNCHECKED VALUE'), columndefs(k).checkbox_unchecked_value);
2672: i := i + 1;
2673: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('CHECK BOX OTHER VALUE'), columndefs(k).checkbox_other_values);

Line 2671: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('CHECK BOX UNCHECKED VALUE'), columndefs(k).checkbox_unchecked_value);

2667: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('DISPLAY FORMAT MASK'), columndefs(k).display_format_mask);
2668: i := i + 1;
2669: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('CHECK BOX CHECKED VALUE'), columndefs(k).checkbox_checked_value);
2670: i := i + 1;
2671: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('CHECK BOX UNCHECKED VALUE'), columndefs(k).checkbox_unchecked_value);
2672: i := i + 1;
2673: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('CHECK BOX OTHER VALUE'), columndefs(k).checkbox_other_values);
2674: i := i + 1;
2675: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('DB CURRENCY CODE COL'), columndefs(k).db_currency_code_col);

Line 2673: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('CHECK BOX OTHER VALUE'), columndefs(k).checkbox_other_values);

2669: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('CHECK BOX CHECKED VALUE'), columndefs(k).checkbox_checked_value);
2670: i := i + 1;
2671: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('CHECK BOX UNCHECKED VALUE'), columndefs(k).checkbox_unchecked_value);
2672: i := i + 1;
2673: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('CHECK BOX OTHER VALUE'), columndefs(k).checkbox_other_values);
2674: i := i + 1;
2675: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('DB CURRENCY CODE COL'), columndefs(k).db_currency_code_col);
2676: i := i + 1;
2677: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('DB CURRENCY COL ALIAS'), columndefs(k).db_currency_col_alias);

Line 2675: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('DB CURRENCY CODE COL'), columndefs(k).db_currency_code_col);

2671: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('CHECK BOX UNCHECKED VALUE'), columndefs(k).checkbox_unchecked_value);
2672: i := i + 1;
2673: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('CHECK BOX OTHER VALUE'), columndefs(k).checkbox_other_values);
2674: i := i + 1;
2675: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('DB CURRENCY CODE COL'), columndefs(k).db_currency_code_col);
2676: i := i + 1;
2677: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('DB CURRENCY COL ALIAS'), columndefs(k).db_currency_col_alias);
2678: i := i + 1;
2679: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('LABEL TEXT'), columndefs(k).label_text);

Line 2677: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('DB CURRENCY COL ALIAS'), columndefs(k).db_currency_col_alias);

2673: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('CHECK BOX OTHER VALUE'), columndefs(k).checkbox_other_values);
2674: i := i + 1;
2675: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('DB CURRENCY CODE COL'), columndefs(k).db_currency_code_col);
2676: i := i + 1;
2677: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('DB CURRENCY COL ALIAS'), columndefs(k).db_currency_col_alias);
2678: i := i + 1;
2679: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('LABEL TEXT'), columndefs(k).label_text);
2680:
2681: end if;

Line 2679: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('LABEL TEXT'), columndefs(k).label_text);

2675: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('DB CURRENCY CODE COL'), columndefs(k).db_currency_code_col);
2676: i := i + 1;
2677: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('DB CURRENCY COL ALIAS'), columndefs(k).db_currency_col_alias);
2678: i := i + 1;
2679: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatChar(JTF_DEBUG_PUB.FormatIndent('LABEL TEXT'), columndefs(k).label_text);
2680:
2681: end if;
2682: k := columnDefs.NEXT(k);
2683: end loop;

Line 2689: procedure debug(p_debug_tbl IN JTF_DEBUG_PUB.debug_tbl_type

2685: END addGridInfo;
2686:
2687:
2688: -------------------------------------------------------------------------------
2689: procedure debug(p_debug_tbl IN JTF_DEBUG_PUB.debug_tbl_type
2690: := JTF_DEBUG_PUB.G_MISS_DEBUG_TBL,
2691: p_gridname IN VARCHAR2 := NULL,
2692: x_path OUT NOCOPY varchar2,
2693: x_filename OUT NOCOPY varchar2,

Line 2690: := JTF_DEBUG_PUB.G_MISS_DEBUG_TBL,

2686:
2687:
2688: -------------------------------------------------------------------------------
2689: procedure debug(p_debug_tbl IN JTF_DEBUG_PUB.debug_tbl_type
2690: := JTF_DEBUG_PUB.G_MISS_DEBUG_TBL,
2691: p_gridname IN VARCHAR2 := NULL,
2692: x_path OUT NOCOPY varchar2,
2693: x_filename OUT NOCOPY varchar2,
2694: X_Return_Status OUT NOCOPY VARCHAR2,

Line 2698: l_debug_tbl JTF_DEBUG_PUB.debug_tbl_type;

2694: X_Return_Status OUT NOCOPY VARCHAR2,
2695: X_Msg_Count OUT NOCOPY NUMBER,
2696: X_Msg_Data OUT NOCOPY VARCHAR2) IS
2697:
2698: l_debug_tbl JTF_DEBUG_PUB.debug_tbl_type;
2699: i number := 1;
2700: j binary_integer := 0;
2701: k binary_integer := 1;
2702: all_info binary_integer := 1;

Line 2722: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.getVersion;

2718: l_debug_tbl(i).debug_message := JTF_DBSTRING_UTILS.getVersion;
2719: i := i + 1;
2720: l_debug_tbl(i).debug_message := JTF_DBSTREAM_UTILS.getVersion;
2721: i := i + 1;
2722: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.getVersion;
2723: i := i + 1;
2724: l_debug_tbl(i).debug_message := ' ';
2725: i := i + 1;
2726: l_debug_tbl(i).debug_message := 'GRID NAMES AND DATASOURCES';

Line 2732: := JTF_DEBUG_PUB.FormatChar(TableDefs(k).gridName,

2728: k := TableDefs.FIRST;
2729: WHILE k is not NULL LOOP
2730: i := i + 1;
2731: l_debug_tbl(i).debug_message
2732: := JTF_DEBUG_PUB.FormatChar(TableDefs(k).gridName,
2733: TableDefs(k).grid_datasource_name);
2734: k := TableDefs.NEXT(k);
2735: END LOOP;
2736:

Line 2752: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatSeperator;

2748: if fnd_log.test(FND_LOG.LEVEL_EVENT, 'JTF.GRID.PLSQL.JTFGRDDB.DEBUG.CURRENT.SERVER') then
2749: all_info_IDX := l_debug_tbl.count + 1;
2750: if p_gridName is not NULL then
2751: i := i + 1;
2752: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatSeperator;
2753: i := i + 1;
2754: l_debug_tbl(i).debug_message := 'CURRENT GRID INFORMATION';
2755:
2756: j := findTableDefIndex(p_gridName);

Line 2774: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatSeperator;

2770:
2771: if fnd_log.test(FND_LOG.LEVEL_EVENT, 'JTF.GRID.PLSQL.JTFGRDDB.DEBUG.ALL.SERVER') then
2772: all_info_IDX := l_debug_tbl.count + 1;
2773: /* i := i + 1;
2774: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatSeperator;
2775: i := i + 1;
2776: l_debug_tbl(i).debug_message := 'INFORMATION OF ALL OTHER GRIDS';*/
2777: i := i + 1;
2778: l_debug_tbl(i).debug_message := ' ';

Line 2788: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatSeperator;

2784: END IF;
2785: all_info := TableDefs.NEXT(all_info);
2786: END LOOP;
2787: i := i + 1;
2788: l_debug_tbl(i).debug_message := JTF_DEBUG_PUB.FormatSeperator;
2789:
2790: For IDX in all_info_IDX..l_debug_tbl.count LOOP
2791: l_debug_tbl(IDX).module_name
2792: := 'JTF.GRID.PLSQL.JTFGRDDB.DEBUG.ALL.SERVER';

Line 2807: JTF_DEBUG_PUB.Debug( p_debug_tbl => l_debug_tbl,

2803: all_info_IDX := all_info_IDX + 1;
2804: END LOOP;
2805:
2806: -- the module name was split up to avoid GSCC error
2807: JTF_DEBUG_PUB.Debug( p_debug_tbl => l_debug_tbl,
2808: p_module => 'J'||'TF.GRID%',
2809: x_path => x_path,
2810: x_filename => x_filename,
2811: x_msg_count => x_msg_count,