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.PON_FORMS_JRAD_PVT dependencies on PON_FORMS_UTIL_PVT

Line 64: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'BEGIN');

60: v_ret_value VARCHAR2(1);
61: l_api_name CONSTANT VARCHAR2(30) := 'ISLOVVALUESET';
62:
63: BEGIN
64: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'BEGIN');
65:
66: v_ret_value := 'N';
67:
68: BEGIN

Line 83: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'RETURN VALUE=' || v_ret_value);

79: v_ret_value := 'N';
80: END;
81:
82:
83: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'RETURN VALUE=' || v_ret_value);
84:
85: RETURN v_ret_value;
86:
87: END isLovValueSet;

Line 104: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'BEGIN');

100: v_ret_value VARCHAR2(120);
101: l_api_name CONSTANT VARCHAR2(30) := 'ESCAPESPECIALCHAR';
102:
103: BEGIN
104: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'BEGIN');
105:
106: v_ret_value := replace(p_prompt, '&', '&'||'amp;');
107:
108: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'RETURN VALUE=' || v_ret_value);

Line 108: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'RETURN VALUE=' || v_ret_value);

104: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'BEGIN');
105:
106: v_ret_value := replace(p_prompt, '&', '&'||'amp;');
107:
108: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'RETURN VALUE=' || v_ret_value);
109:
110: RETURN v_ret_value;
111:
112: END escapeSpecialChar;

Line 191: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'RETURN VALUE=' || v_ret_value);

187: || g_spacer || p_incl_sec_id || g_spacer || 0
188: || g_spacer || to_char(null);
189: END IF;
190:
191: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'RETURN VALUE=' || v_ret_value);
192:
193: RETURN v_ret_value;
194:
195: END getparentelementindex;

Line 222: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'RETURN VALUE=' || v_ret_value);

218: v_ret_value := p_type || g_spacer || p_form_id || g_spacer || p_section_id
219: || g_spacer || p_incl_sec_id || g_spacer || p_rept_sec_id
220: || g_spacer || to_char(null);
221:
222: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'RETURN VALUE=' || v_ret_value);
223:
224: RETURN v_ret_value;
225:
226: END getCurrentElementIndex;

Line 273: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'RETURN VALUE=' || v_ret_value);

269: ELSE
270: v_ret_value := 't0';
271: END IF;
272:
273: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'RETURN VALUE=' || v_ret_value);
274:
275: RETURN v_ret_value;
276:
277: END getdisplaytype;

Line 301: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'RETURN VALUE=' || v_ret_value);

297: ELSE
298: v_ret_value := to_char(p_id);
299: END IF;
300:
301: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'RETURN VALUE=' || v_ret_value);
302:
303: RETURN v_ret_value;
304:
305: END getDisplayId;

Line 340: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'RETURN VALUE=' || v_ret_value);

336: || 'RS_' || getDisplayId(p_rept_sec_id)
337: || 'FD_' || p_field_code;
338:
339:
340: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'RETURN VALUE=' || v_ret_value);
341:
342: RETURN v_ret_value;
343:
344: END getJradId;

Line 403: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'END');

399: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',lovMap);
400: g_lov_map_count := g_lov_map_count + 1;
401: */
402:
403: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'END');
404:
405: EXCEPTION
406: WHEN OTHERS THEN
407: PON_FORMS_UTIL_PVT.print_error_log(l_api_name, 'EXCEPTION');

Line 407: PON_FORMS_UTIL_PVT.print_error_log(l_api_name, 'EXCEPTION');

403: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'END');
404:
405: EXCEPTION
406: WHEN OTHERS THEN
407: PON_FORMS_UTIL_PVT.print_error_log(l_api_name, 'EXCEPTION');
408: err_num := SQLCODE;
409: err_msg := SUBSTR(SQLERRM, 1, 100);
410:
411: END CREATE_LOV;

Line 442: PON_FORMS_UTIL_PVT.print_error_log(l_api_name, 'EXCEPTION');

438: RETURN V_BASE_LANGUAGE;
439:
440: EXCEPTION
441: WHEN OTHERS THEN
442: PON_FORMS_UTIL_PVT.print_error_log(l_api_name, 'EXCEPTION');
443: RETURN V_BASE_LANGUAGE;
444:
445: END getBaseLanguage;
446:

Line 467: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'BEGIN '

463: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_ELEMENT';
464:
465: BEGIN
466:
467: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'BEGIN '
468: || p_element_type || ' ' || p_element_id || ' '
469: || p_element_dataType || ' ' || p_element_viewAttr);
470:
471: v_return_jrad_element := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.OA_NS, p_element_type);

Line 493: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'END');

489: JDR_DOCBUILDER.setAttribute (v_return_jrad_element, 'longTipRegion', g_jrad_long_tip_rgn);
490: end if;
491: end if;
492:
493: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'END');
494:
495: return v_return_jrad_element;
496:
497: END CREATE_ELEMENT;

Line 520: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'BEGIN '

516: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_TABLE_ELEMENT';
517:
518: BEGIN
519:
520: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'BEGIN '
521: || p_element_type || ' ' || p_element_id || ' '
522: || p_element_dataType || ' ' || p_element_viewAttr);
523:
524: v_return_jrad_element := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.OA_NS, p_element_type);

Line 532: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'END');

528: JDR_DOCBUILDER.setAttribute (v_return_jrad_element, 'prompt', escapespecialchar(p_element_prompt));
529: JDR_DOCBUILDER.setAttribute (v_return_jrad_element, 'dataType', p_element_dataType);
530: JDR_DOCBUILDER.setAttribute (v_return_jrad_element, 'cellNoWrapFormat', 'true');
531:
532: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'END');
533:
534: return v_return_jrad_element;
535:
536: END CREATE_TABLE_ELEMENT;

Line 564: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'BEGIN -'

560: FND_FLEX_EXCEPTION EXCEPTION;
561:
562: BEGIN
563:
564: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'BEGIN -'
565: || p_field_jrad_id || ' ' || p_field_code || ' '
566: || p_mapping_field || ' ' || p_value_set_name);
567:
568: BEGIN

Line 659: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'END');

655: create_lov(p_field_code, p_value_set_name, p_mapping_field,
656: v_validation_type, p_field_jrad_id, v_return_jrad_element);
657: end if; --}
658:
659: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'END');
660: return v_return_jrad_element;
661:
662: EXCEPTION
663: WHEN FND_FLEX_EXCEPTION THEN

Line 693: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'BEGIN -'

689: FND_FLEX_EXCEPTION EXCEPTION;
690:
691: BEGIN
692:
693: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'BEGIN -'
694: || p_field_jrad_id || ' ' || p_field_code || ' '
695: || p_mapping_field || ' ' || p_value_set_name);
696:
697: BEGIN

Line 788: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'END');

784: create_lov(p_field_code, p_value_set_name, p_mapping_field,
785: v_validation_type, p_field_jrad_id, v_return_jrad_element);
786: end if; --}
787:
788: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'END');
789: return v_return_jrad_element;
790:
791: EXCEPTION
792: WHEN FND_FLEX_EXCEPTION THEN

Line 866: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'BEGIN -' || section_id);

862: v_vset_element_created VARCHAR2(1);
863:
864: BEGIN
865:
866: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'BEGIN -' || section_id);
867:
868: v_curr_formfieldvaluesvo_name := g_values_viewName || p_vocount;
869:
870: --

Line 961: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'Creat image for inner repeating section '

957: forms.form_id = forms_tl.form_id AND
958: forms.form_id = v_form_fields_row.section_id AND
959: forms_tl.LANGUAGE = g_base_language;
960:
961: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'Creat image for inner repeating section '
962: || v_form_fields_row.section_id || ' ' || v_section_title);
963:
964: v_section_field_element := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.OA_NS, 'image');
965: JDR_DOCBUILDER.setAttribute (v_section_field_element, 'id', v_jrad_element_id || 'IMG' || g_total_image_count);

Line 1233: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'END');

1229: END IF;
1230:
1231: END LOOP;
1232:
1233: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'END');
1234:
1235: return v_section_layout_element;
1236:
1237: END CREATE_TABLE;

Line 1283: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'BEGIN-');

1279:
1280: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_REPEATING_SECTION';
1281:
1282: BEGIN
1283: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'BEGIN-');
1284:
1285: -- initialize to error
1286: x_result := fnd_api.g_ret_sts_error;
1287:

Line 1291: v_section_entry_path := PON_FORMS_UTIL_PVT.getDataEntryRegionName(p_section_id);

1287:
1288: -- always use VO1 for independent repeating section
1289: v_view_name := g_values_viewName || '1';
1290:
1291: v_section_entry_path := PON_FORMS_UTIL_PVT.getDataEntryRegionName(p_section_id);
1292: v_section_read_path := PON_FORMS_UTIL_PVT.getReadOnlyRegionName(p_section_id);
1293:
1294:
1295: IF (JDR_DOCBUILDER.DOCUMENTEXISTS(v_section_entry_path)=TRUE) THEN

Line 1292: v_section_read_path := PON_FORMS_UTIL_PVT.getReadOnlyRegionName(p_section_id);

1288: -- always use VO1 for independent repeating section
1289: v_view_name := g_values_viewName || '1';
1290:
1291: v_section_entry_path := PON_FORMS_UTIL_PVT.getDataEntryRegionName(p_section_id);
1292: v_section_read_path := PON_FORMS_UTIL_PVT.getReadOnlyRegionName(p_section_id);
1293:
1294:
1295: IF (JDR_DOCBUILDER.DOCUMENTEXISTS(v_section_entry_path)=TRUE) THEN
1296: JDR_DOCBUILDER.DELETEDOCUMENT (v_section_entry_path);

Line 1430: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'END');

1426: rval := JDR_DOCBUILDER.save;
1427:
1428: x_result := fnd_api.g_ret_sts_success;
1429:
1430: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'END');
1431:
1432: EXCEPTION
1433: WHEN OTHERS THEN
1434: x_result := fnd_api.g_ret_sts_error;

Line 1437: PON_FORMS_UTIL_PVT.print_error_log(l_api_name, 'EXCEPTION - x_result=' || x_result || ' x_error_code=' || x_error_code || ' x_error_message=' || x_error_message || ' SQLERRM=' || SQLERRM);

1433: WHEN OTHERS THEN
1434: x_result := fnd_api.g_ret_sts_error;
1435: x_error_code := SQLCODE;
1436: x_error_message := SUBSTR(SQLERRM, 1, 100);
1437: PON_FORMS_UTIL_PVT.print_error_log(l_api_name, 'EXCEPTION - x_result=' || x_result || ' x_error_code=' || x_error_code || ' x_error_message=' || x_error_message || ' SQLERRM=' || SQLERRM);
1438:
1439: end CREATE_REPEATING_SECTION;
1440:
1441:

Line 1514: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'BEGIN-');

1510: rval INTEGER;
1511:
1512: BEGIN
1513:
1514: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'BEGIN-');
1515:
1516: IF (JDR_DOCBUILDER.DOCUMENTEXISTS(g_jrad_ext_page_path)=TRUE) THEN
1517: JDR_DOCBUILDER.DELETEDOCUMENT (g_jrad_ext_page_path);
1518: END IF;

Line 1642: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'END');

1638: rval := JDR_DOCBUILDER.save;
1639:
1640: x_result := fnd_api.g_ret_sts_success;
1641:
1642: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'END');
1643:
1644: EXCEPTION
1645: WHEN OTHERS THEN
1646: x_result := fnd_api.g_ret_sts_error;

Line 1649: PON_FORMS_UTIL_PVT.print_error_log(l_api_name, 'EXCEPTION - x_result=' || x_result || ' x_error_code=' || x_error_code || ' x_error_message=' || x_error_message || ' SQLERRM=' || SQLERRM);

1645: WHEN OTHERS THEN
1646: x_result := fnd_api.g_ret_sts_error;
1647: x_error_code := SQLCODE;
1648: x_error_message := SUBSTR(SQLERRM, 1, 100);
1649: PON_FORMS_UTIL_PVT.print_error_log(l_api_name, 'EXCEPTION - x_result=' || x_result || ' x_error_code=' || x_error_code || ' x_error_message=' || x_error_message || ' SQLERRM=' || SQLERRM);
1650:
1651: END CREATE_ABSTRACT_TABLE;
1652:
1653: /*======================================================================

Line 1771: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'BEGIN-');

1767: v_read_only_rgn_name VARCHAR2(250);
1768: v_vset_element_created VARCHAR2(1);
1769:
1770: BEGIN
1771: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'BEGIN-');
1772:
1773: -- we dont need to pass the fullPathName to this procedure
1774: -- we can generate the region name here
1775:

Line 1776: v_data_entry_rgn_name := PON_FORMS_UTIL_PVT.getDataEntryRegionName(p_form_id);

1772:
1773: -- we dont need to pass the fullPathName to this procedure
1774: -- we can generate the region name here
1775:
1776: v_data_entry_rgn_name := PON_FORMS_UTIL_PVT.getDataEntryRegionName(p_form_id);
1777: v_read_only_rgn_name := PON_FORMS_UTIL_PVT.getReadOnlyRegionName(p_form_id);
1778:
1779: IF (JDR_DOCBUILDER.DOCUMENTEXISTS(v_data_entry_rgn_name)=TRUE) THEN --{
1780: JDR_DOCBUILDER.DELETEDOCUMENT(v_data_entry_rgn_name);

Line 1777: v_read_only_rgn_name := PON_FORMS_UTIL_PVT.getReadOnlyRegionName(p_form_id);

1773: -- we dont need to pass the fullPathName to this procedure
1774: -- we can generate the region name here
1775:
1776: v_data_entry_rgn_name := PON_FORMS_UTIL_PVT.getDataEntryRegionName(p_form_id);
1777: v_read_only_rgn_name := PON_FORMS_UTIL_PVT.getReadOnlyRegionName(p_form_id);
1778:
1779: IF (JDR_DOCBUILDER.DOCUMENTEXISTS(v_data_entry_rgn_name)=TRUE) THEN --{
1780: JDR_DOCBUILDER.DELETEDOCUMENT(v_data_entry_rgn_name);
1781: END IF; --}

Line 1789: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'Step 1 - create data-entry region' || v_data_entry_rgn_name);

1785: END IF; --}
1786:
1787: -- initialize the dataEntryRegion
1788: dataEntryRegion := JDR_DOCBUILDER.createDocument(v_data_entry_rgn_name,'en-US');
1789: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'Step 1 - create data-entry region' || v_data_entry_rgn_name);
1790:
1791: readOnlyRegion := JDR_DOCBUILDER.createDocument(v_read_only_rgn_name,'en-US');
1792:
1793: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'Step 2 - create read-entry region' || v_read_only_rgn_name);

Line 1793: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'Step 2 - create read-entry region' || v_read_only_rgn_name);

1789: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'Step 1 - create data-entry region' || v_data_entry_rgn_name);
1790:
1791: readOnlyRegion := JDR_DOCBUILDER.createDocument(v_read_only_rgn_name,'en-US');
1792:
1793: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'Step 2 - create read-entry region' || v_read_only_rgn_name);
1794:
1795: v_current_layout_element_index := 0;
1796: v_parent_section_code := NULL;
1797: v_section_code := NULL;

Line 1849: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 1+ : create header region for section ' || v_section_code);

1845: forms.form_id = forms_tl.form_id AND
1846: forms.form_id = v_current_section_id AND
1847: forms_tl.LANGUAGE = g_base_language;
1848:
1849: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 1+ : create header region for section ' || v_section_code);
1850:
1851: JDR_DOCBUILDER.setAttribute (v_section_element, 'id', v_jrad_element_id);
1852:
1853: JDR_DOCBUILDER.setAttribute (v_section_element, 'text', escapespecialchar(v_section_title));

Line 1859: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 1+ - top level element is ' || v_current_section_id);

1855: JDR_DOCBUILDER.setAttribute (v_section_element_rd, 'id', v_jrad_element_id);
1856:
1857: JDR_DOCBUILDER.setAttribute (v_section_element_rd, 'text', escapespecialchar(v_section_title));
1858:
1859: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 1+ - top level element is ' || v_current_section_id);
1860:
1861: JDR_DOCBUILDER.setTopLevelElement(dataEntryRegion, v_section_element);
1862:
1863: JDR_DOCBUILDER.setTopLevelElement(readOnlyRegion, v_section_element_rd);

Line 1949: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 2+ : v_parent_section_id = '

1945: v_LEVEL1_SECTION_ID := v_current_section_id;
1946:
1947: -- add the mcl as a child of the header region
1948:
1949: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 2+ : v_parent_section_id = '
1950: || v_parent_section_id || ' v_current_section_id = '
1951: || v_current_section_id || ' v_LEVEL1_SECTION_ID = ' || v_LEVEL1_SECTION_ID);
1952:
1953: --Create a new header section

Line 1972: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 2+ - create header region for section ' || v_section_code);

1968: forms.form_id = forms_tl.form_id AND
1969: forms.form_id = v_current_section_id AND
1970: forms_tl.LANGUAGE = g_base_language;
1971:
1972: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 2+ - create header region for section ' || v_section_code);
1973:
1974: JDR_DOCBUILDER.setAttribute (v_section_element, 'id', v_jrad_element_id);
1975: JDR_DOCBUILDER.setAttribute (v_section_element, 'text', escapespecialchar(v_section_title));
1976: g_total_element_count := g_total_element_count + 1;

Line 2040: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case ' || v_form_fields_row.type || ' :-: ' || v_prev_record_type);

2036: -- normal adding of fields to an MCL for a section will be handled below,
2037: -- here, we will determine whether or not this field appears in a section
2038: -- apart from the remaining group of fields in the section
2039:
2040: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case ' || v_form_fields_row.type || ' :-: ' || v_prev_record_type);
2041:
2042: IF(v_prev_record_type <> 'SECTION_FIELD') THEN
2043: --{
2044: v_parent_section_id := v_form_fields_row.form_id;

Line 2048: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case '|| v_form_fields_row.type ||':+:'

2044: v_parent_section_id := v_form_fields_row.form_id;
2045: v_current_section_id := v_form_fields_row.section_id;
2046: v_LEVEL1_SECTION_ID := v_current_section_id;
2047:
2048: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case '|| v_form_fields_row.type ||':+:'
2049: || v_current_section_id);
2050:
2051: -- we have already created a oa:header region for this section
2052: -- but just that this field has been added to this section out-of-order

Line 2123: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 3+ : v_parent_section_id = '

2119: v_parent_section_id := v_form_fields_row.section_id;
2120: v_current_section_id := v_form_fields_row.LEVEL2_SECTION_ID;
2121: v_LEVEL1_SECTION_ID := v_parent_section_id;
2122:
2123: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 3+ : v_parent_section_id = '
2124: || v_parent_section_id || ' v_current_section_id = '
2125: || v_current_section_id || ' v_LEVEL1_SECTION_ID = ' || v_LEVEL1_SECTION_ID);
2126:
2127: --Create a new header section

Line 2148: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 3+ : create header region for section ' || v_section_code);

2144: forms.form_id = forms_tl.form_id AND
2145: forms.form_id = v_current_section_id AND
2146: forms_tl.LANGUAGE = g_base_language;
2147:
2148: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 3+ : create header region for section ' || v_section_code);
2149:
2150: JDR_DOCBUILDER.setAttribute (v_section_element, 'id', v_jrad_element_id);
2151: JDR_DOCBUILDER.setAttribute (v_section_element, 'text', escapespecialchar(v_section_title));
2152:

Line 2206: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case ' || v_form_fields_row.type || ' :-: ' || v_prev_record_type);

2202: --}
2203:
2204: ELSIF (v_form_fields_row.type='INNER_SECTION_FIELD') THEN
2205: --{
2206: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case ' || v_form_fields_row.type || ' :-: ' || v_prev_record_type);
2207:
2208: IF(v_prev_record_type <> 'INNER_SECTION_FIELD') THEN
2209: --{
2210:

Line 2219: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case'||v_form_fields_row.type||':+:'||v_current_section_id);

2215: -- we have encountered a field inside a inner section, which was
2216: -- added out-of-order from the original set of fields directly
2217: -- inside the
2218:
2219: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case'||v_form_fields_row.type||':+:'||v_current_section_id);
2220:
2221: --create a section layout(MCL) and add it to the new section
2222: v_section_layout_element := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.OA_NS,
2223: 'messageComponentLayout');

Line 2297: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 4+ : v_parent_section_id = '

2293: v_section_element := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.OA_NS, 'header');
2294:
2295: v_section_element_rd := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.OA_NS, 'header');
2296:
2297: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 4+ : v_parent_section_id = '
2298: || v_parent_section_id || ' v_current_section_id = '
2299: || v_current_section_id || ' v_LEVEL1_SECTION_ID = '
2300: || v_LEVEL1_SECTION_ID);
2301:

Line 2315: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 4+ : create header region for section - '

2311: forms.form_id = forms_tl.form_id AND
2312: forms.form_id = v_current_section_id AND
2313: forms_tl.LANGUAGE = g_base_language;
2314:
2315: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 4+ : create header region for section - '
2316: || v_section_code );
2317:
2318: JDR_DOCBUILDER.setAttribute (v_section_element, 'id', v_jrad_element_id);
2319: JDR_DOCBUILDER.setAttribute (v_section_element, 'text', escapespecialchar(v_section_title));

Line 2339: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'Setting viewName for ' || v_section_code

2335: JDR_DOCBUILDER.setAttribute (v_section_layout_element_rd, 'id', v_jrad_element_id ||'_table');
2336: JDR_DOCBUILDER.setAttribute (v_section_layout_element_rd, 'viewName',
2337: v_curr_formfieldvaluesvo_name);
2338:
2339: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'Setting viewName for ' || v_section_code
2340: ||'_table' || ' ' || v_curr_formfieldvaluesvo_name);
2341:
2342: JDR_DOCBUILDER.setAttribute (v_section_layout_element_rd, 'width', '100%');
2343:

Line 2359: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'Invoke CREATE_TABLE with '

2355:
2356: -- add all the rows in the table
2357: -- create a repeating section directly inside a form
2358:
2359: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'Invoke CREATE_TABLE with '
2360: || v_current_section_id || ' ' || p_form_id || ' '
2361: || v_formfieldvaluesvo_list_count);
2362:
2363: v_section_layout_element := CREATE_TABLE(v_current_section_id, v_section_layout_element,

Line 2463: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 5- : v_parent_section_id = '

2459: ELSIF (v_form_fields_row.type='INNER_REPEAT_SECTION') THEN
2460: --{
2461:
2462:
2463: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 5- : v_parent_section_id = '
2464: || v_parent_section_id || ' v_current_section_id = '
2465: || v_current_section_id || ' v_LEVEL1_SECTION_ID = '
2466: || v_LEVEL1_SECTION_ID);
2467:

Line 2475: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 5+ : v_parent_section_id = '

2471: v_current_section_id := v_form_fields_row.repeating_section_id;
2472: v_LEVEL1_SECTION_ID := v_parent_section_id;
2473:
2474: -- create a header region
2475: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 5+ : v_parent_section_id = '
2476: || v_parent_section_id || ' v_current_section_id = '
2477: || v_current_section_id || ' v_LEVEL1_SECTION_ID = '
2478: || v_LEVEL1_SECTION_ID);
2479:

Line 2502: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 5+ : create header region for section - '

2498: forms.form_id = forms_tl.form_id AND
2499: forms.form_id = v_current_section_id AND
2500: forms_tl.LANGUAGE = g_base_language;
2501:
2502: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 5+ : create header region for section - '
2503: || v_section_code );
2504:
2505: JDR_DOCBUILDER.setAttribute (v_section_element, 'id', v_jrad_element_id);
2506: JDR_DOCBUILDER.setAttribute (v_section_element, 'text', escapespecialchar(v_section_title));

Line 2529: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'Setting viewName for ' || v_section_code

2525: JDR_DOCBUILDER.setAttribute (v_section_layout_element_rd, 'id', v_jrad_element_id ||'_table');
2526: JDR_DOCBUILDER.setAttribute (v_section_layout_element_rd, 'viewName',
2527: v_curr_formfieldvaluesvo_name);
2528:
2529: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'Setting viewName for ' || v_section_code
2530: ||'_table' || ' as ' || v_curr_formfieldvaluesvo_name);
2531:
2532:
2533: JDR_DOCBUILDER.setAttribute (v_section_layout_element_rd, 'width', '100%');

Line 2656: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 6- : v_parent_section_id = '

2652: --}
2653: ELSIF (v_form_fields_row.type='INNER_SECTION_REPEAT_SECTION') THEN
2654: --{
2655:
2656: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 6- : v_parent_section_id = '
2657: || v_parent_section_id || ' v_current_section_id = '
2658: || v_current_section_id || ' v_LEVEL1_SECTION_ID = '
2659: || v_LEVEL1_SECTION_ID);
2660:

Line 2669: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 6+ : v_parent_section_id = '

2665: v_current_section_id := v_form_fields_row.repeating_section_id;
2666: v_LEVEL1_SECTION_ID := v_form_fields_row.section_id;
2667: -- create a header region
2668:
2669: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 6+ : v_parent_section_id = '
2670: || v_parent_section_id || ' v_current_section_id = '
2671: || v_current_section_id || ' v_LEVEL1_SECTION_ID = '
2672: || v_LEVEL1_SECTION_ID);
2673:

Line 2692: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 4+ : create header region for section - ' || v_section_code );

2688: forms.form_id = forms_tl.form_id AND
2689: forms.form_id = v_current_section_id AND
2690: forms_tl.LANGUAGE = g_base_language;
2691:
2692: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 4+ : create header region for section - ' || v_section_code );
2693:
2694: JDR_DOCBUILDER.setAttribute (v_section_element, 'id', v_jrad_element_id);
2695: JDR_DOCBUILDER.setAttribute (v_section_element, 'text', escapespecialchar(v_section_title));
2696:

Line 2719: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'Setting viewName for ' || v_section_code||'_table' || ' as ' || v_curr_formfieldvaluesvo_name);

2715:
2716: JDR_DOCBUILDER.setAttribute (v_section_layout_element_rd, 'id', v_jrad_element_id ||'_table');
2717: JDR_DOCBUILDER.setAttribute (v_section_layout_element_rd, 'viewName', v_curr_formfieldvaluesvo_name);
2718:
2719: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'Setting viewName for ' || v_section_code||'_table' || ' as ' || v_curr_formfieldvaluesvo_name);
2720: JDR_DOCBUILDER.setAttribute (v_section_layout_element_rd, 'width', '100%');
2721:
2722: -- create a table footer, and this footer as a child of the table region
2723: v_table_footer_element := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.OA_NS, 'tableFooter');

Line 2857: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'Creating field ' || v_field_jrad_id);

2853:
2854: -- v_field_jrad_id := v_section_code || '_' || v_form_fields_row.field_code;
2855: v_field_jrad_id := v_jrad_element_id;
2856:
2857: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'Creating field ' || v_field_jrad_id);
2858:
2859: IF(NVL( v_form_fields_row.SYSTEM_FLAG, 'N') = 'Y' ) THEN
2860: --{
2861: /* Bug 6050403: For the TWO_PART_FLAG system field there is need to

Line 3078: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'Setting viewname for ' || v_form_fields_row.field_code || ' as ' || v_curr_formfieldvaluesvo_name);

3074: JDR_DOCBUILDER.setAttribute (v_section_field_element_rd, 'viewName', v_curr_formfieldvaluesvo_name);
3075: END IF;
3076: JDR_DOCBUILDER.addChild (v_section_layout_element_rd,jdr_docbuilder.UI_NS,'contents',v_section_field_element_rd);
3077:
3078: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'Setting viewname for ' || v_form_fields_row.field_code || ' as ' || v_curr_formfieldvaluesvo_name);
3079:
3080: END IF; --}
3081:
3082: v_prev_record_type := v_form_fields_row.type;

Line 3086: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'JRAD created, now saving to JDR repository');

3082: v_prev_record_type := v_form_fields_row.type;
3083:
3084: END LOOP; --}
3085:
3086: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'JRAD created, now saving to JDR repository');
3087:
3088: rval := JDR_DOCBUILDER.save;
3089:
3090: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'Finished saving to JDR repository');

Line 3090: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'Finished saving to JDR repository');

3086: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'JRAD created, now saving to JDR repository');
3087:
3088: rval := JDR_DOCBUILDER.save;
3089:
3090: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'Finished saving to JDR repository');
3091:
3092: x_result :=fnd_api.g_ret_sts_success;
3093:
3094: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'END');

Line 3094: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'END');

3090: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'Finished saving to JDR repository');
3091:
3092: x_result :=fnd_api.g_ret_sts_success;
3093:
3094: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'END');
3095:
3096: EXCEPTION
3097: WHEN OTHERS THEN
3098: x_result := fnd_api.g_ret_sts_error;

Line 3101: PON_FORMS_UTIL_PVT.print_error_log(l_api_name, 'EXCEPTION - x_result=' || x_result || ' x_error_code=' || x_error_code || ' x_error_message=' || x_error_message || ' SQLERRM=' || SQLERRM);

3097: WHEN OTHERS THEN
3098: x_result := fnd_api.g_ret_sts_error;
3099: x_error_code := SQLCODE;
3100: x_error_message := SUBSTR(SQLERRM, 1, 100);
3101: PON_FORMS_UTIL_PVT.print_error_log(l_api_name, 'EXCEPTION - x_result=' || x_result || ' x_error_code=' || x_error_code || ' x_error_message=' || x_error_message || ' SQLERRM=' || SQLERRM);
3102:
3103: END CREATE_FORM;
3104:
3105: /*======================================================================

Line 3124: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'BEGIN-');

3120:
3121: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_ABSTRACT';
3122:
3123: BEGIN
3124: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'BEGIN-');
3125:
3126: create_form(p_form_id, x_result, x_error_code, x_error_message);
3127:
3128: create_abstract_table(p_form_id, x_result, x_error_code, x_error_message);

Line 3137: PON_FORMS_UTIL_PVT.print_error_log(l_api_name, 'EXCEPTION - x_result=' || x_result || ' x_error_code=' || x_error_code || ' x_error_message=' || x_error_message || ' SQLERRM=' || SQLERRM);

3133: WHEN OTHERS THEN
3134: x_result := fnd_api.g_ret_sts_error;
3135: x_error_code := SQLCODE;
3136: x_error_message := SUBSTR(SQLERRM, 1, 100);
3137: PON_FORMS_UTIL_PVT.print_error_log(l_api_name, 'EXCEPTION - x_result=' || x_result || ' x_error_code=' || x_error_code || ' x_error_message=' || x_error_message || ' SQLERRM=' || SQLERRM);
3138:
3139: END;
3140:
3141: /*======================================================================

Line 3162: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'BEGIN-');

3158: BEGIN
3159: -- initialize to error
3160: x_result := fnd_api.g_ret_sts_error;
3161:
3162: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'BEGIN-');
3163:
3164: -- the overall logic to generate jrad is as follows -
3165: -- determine whether the type is 'SECTION' or 'ABSTRACT' or 'FORM'
3166:

Line 3201: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'END');

3197: end if;
3198:
3199: x_result := fnd_api.g_ret_sts_success;
3200:
3201: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'END');
3202:
3203: EXCEPTION
3204: WHEN OTHERS THEN
3205: x_result := fnd_api.g_ret_sts_error;

Line 3208: PON_FORMS_UTIL_PVT.print_error_log(l_api_name, 'EXCEPTION - x_result=' || x_result || ' x_error_code=' || x_error_code || ' x_error_message=' || x_error_message || ' SQLERRM=' || SQLERRM);

3204: WHEN OTHERS THEN
3205: x_result := fnd_api.g_ret_sts_error;
3206: x_error_code := SQLCODE;
3207: x_error_message := SUBSTR(SQLERRM, 1, 100);
3208: PON_FORMS_UTIL_PVT.print_error_log(l_api_name, 'EXCEPTION - x_result=' || x_result || ' x_error_code=' || x_error_code || ' x_error_message=' || x_error_message || ' SQLERRM=' || SQLERRM);
3209:
3210: END CREATE_JRAD;
3211:
3212: