DBA Data[Home] [Help]

APPS.PON_FORMS_JRAD_PVT dependencies on PON_FORMS_UTIL_PVT

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

732: v_vset_element_created VARCHAR2(1);
733:
734: BEGIN
735:
736: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'BEGIN -' || section_id);
737:
738: v_curr_formfieldvaluesvo_name := g_values_viewName || p_vocount;
739:
740: --

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

827: forms.form_id = forms_tl.form_id AND
828: forms.form_id = v_form_fields_row.section_id AND
829: forms_tl.LANGUAGE = g_base_language;
830:
831: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'Creat image for inner repeating section '
832: || v_form_fields_row.section_id || ' ' || v_section_title);
833:
834: v_section_field_element := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.OA_NS, 'image');
835: JDR_DOCBUILDER.setAttribute (v_section_field_element, 'id', v_jrad_element_id || 'IMG' || g_total_image_count);

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

1099: END IF;
1100:
1101: END LOOP;
1102:
1103: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'END');
1104:
1105: return v_section_layout_element;
1106:
1107: END CREATE_TABLE;

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

1149:
1150: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_REPEATING_SECTION';
1151:
1152: BEGIN
1153: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'BEGIN-');
1154:
1155: -- initialize to error
1156: x_result := fnd_api.g_ret_sts_error;
1157:

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

1157:
1158: -- always use VO1 for independent repeating section
1159: v_view_name := g_values_viewName || '1';
1160:
1161: v_section_entry_path := PON_FORMS_UTIL_PVT.getDataEntryRegionName(p_section_id);
1162: v_section_read_path := PON_FORMS_UTIL_PVT.getReadOnlyRegionName(p_section_id);
1163:
1164:
1165: IF (JDR_DOCBUILDER.DOCUMENTEXISTS(v_section_entry_path)=TRUE) THEN

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

1158: -- always use VO1 for independent repeating section
1159: v_view_name := g_values_viewName || '1';
1160:
1161: v_section_entry_path := PON_FORMS_UTIL_PVT.getDataEntryRegionName(p_section_id);
1162: v_section_read_path := PON_FORMS_UTIL_PVT.getReadOnlyRegionName(p_section_id);
1163:
1164:
1165: IF (JDR_DOCBUILDER.DOCUMENTEXISTS(v_section_entry_path)=TRUE) THEN
1166: JDR_DOCBUILDER.DELETEDOCUMENT (v_section_entry_path);

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

1296: rval := JDR_DOCBUILDER.save;
1297:
1298: x_result := fnd_api.g_ret_sts_success;
1299:
1300: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'END');
1301:
1302: EXCEPTION
1303: WHEN OTHERS THEN
1304: x_result := fnd_api.g_ret_sts_error;

Line 1307: 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);

1303: WHEN OTHERS THEN
1304: x_result := fnd_api.g_ret_sts_error;
1305: x_error_code := SQLCODE;
1306: x_error_message := SUBSTR(SQLERRM, 1, 100);
1307: 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);
1308:
1309: end CREATE_REPEATING_SECTION;
1310:
1311:

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

1380: rval INTEGER;
1381:
1382: BEGIN
1383:
1384: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'BEGIN-');
1385:
1386: IF (JDR_DOCBUILDER.DOCUMENTEXISTS(g_jrad_ext_page_path)=TRUE) THEN
1387: JDR_DOCBUILDER.DELETEDOCUMENT (g_jrad_ext_page_path);
1388: END IF;

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

1508: rval := JDR_DOCBUILDER.save;
1509:
1510: x_result := fnd_api.g_ret_sts_success;
1511:
1512: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'END');
1513:
1514: EXCEPTION
1515: WHEN OTHERS THEN
1516: x_result := fnd_api.g_ret_sts_error;

Line 1519: 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);

1515: WHEN OTHERS THEN
1516: x_result := fnd_api.g_ret_sts_error;
1517: x_error_code := SQLCODE;
1518: x_error_message := SUBSTR(SQLERRM, 1, 100);
1519: 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);
1520:
1521: END CREATE_ABSTRACT_TABLE;
1522:
1523: /*======================================================================

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

1636: v_read_only_rgn_name VARCHAR2(250);
1637: v_vset_element_created VARCHAR2(1);
1638:
1639: BEGIN
1640: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'BEGIN-');
1641:
1642: -- we dont need to pass the fullPathName to this procedure
1643: -- we can generate the region name here
1644:

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

1641:
1642: -- we dont need to pass the fullPathName to this procedure
1643: -- we can generate the region name here
1644:
1645: v_data_entry_rgn_name := PON_FORMS_UTIL_PVT.getDataEntryRegionName(p_form_id);
1646: v_read_only_rgn_name := PON_FORMS_UTIL_PVT.getReadOnlyRegionName(p_form_id);
1647:
1648: IF (JDR_DOCBUILDER.DOCUMENTEXISTS(v_data_entry_rgn_name)=TRUE) THEN --{
1649: JDR_DOCBUILDER.DELETEDOCUMENT(v_data_entry_rgn_name);

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

1642: -- we dont need to pass the fullPathName to this procedure
1643: -- we can generate the region name here
1644:
1645: v_data_entry_rgn_name := PON_FORMS_UTIL_PVT.getDataEntryRegionName(p_form_id);
1646: v_read_only_rgn_name := PON_FORMS_UTIL_PVT.getReadOnlyRegionName(p_form_id);
1647:
1648: IF (JDR_DOCBUILDER.DOCUMENTEXISTS(v_data_entry_rgn_name)=TRUE) THEN --{
1649: JDR_DOCBUILDER.DELETEDOCUMENT(v_data_entry_rgn_name);
1650: END IF; --}

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

1654: END IF; --}
1655:
1656: -- initialize the dataEntryRegion
1657: dataEntryRegion := JDR_DOCBUILDER.createDocument(v_data_entry_rgn_name,'en-US');
1658: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'Step 1 - create data-entry region' || v_data_entry_rgn_name);
1659:
1660: readOnlyRegion := JDR_DOCBUILDER.createDocument(v_read_only_rgn_name,'en-US');
1661:
1662: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'Step 2 - create read-entry region' || v_read_only_rgn_name);

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

1658: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'Step 1 - create data-entry region' || v_data_entry_rgn_name);
1659:
1660: readOnlyRegion := JDR_DOCBUILDER.createDocument(v_read_only_rgn_name,'en-US');
1661:
1662: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'Step 2 - create read-entry region' || v_read_only_rgn_name);
1663:
1664: v_current_layout_element_index := 0;
1665: v_parent_section_code := NULL;
1666: v_section_code := NULL;

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

1714: forms.form_id = forms_tl.form_id AND
1715: forms.form_id = v_current_section_id AND
1716: forms_tl.LANGUAGE = g_base_language;
1717:
1718: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 1+ : create header region for section ' || v_section_code);
1719:
1720: JDR_DOCBUILDER.setAttribute (v_section_element, 'id', v_jrad_element_id);
1721:
1722: JDR_DOCBUILDER.setAttribute (v_section_element, 'text', escapespecialchar(v_section_title));

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

1724: JDR_DOCBUILDER.setAttribute (v_section_element_rd, 'id', v_jrad_element_id);
1725:
1726: JDR_DOCBUILDER.setAttribute (v_section_element_rd, 'text', escapespecialchar(v_section_title));
1727:
1728: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 1+ - top level element is ' || v_current_section_id);
1729:
1730: JDR_DOCBUILDER.setTopLevelElement(dataEntryRegion, v_section_element);
1731:
1732: JDR_DOCBUILDER.setTopLevelElement(readOnlyRegion, v_section_element_rd);

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

1814: v_LEVEL1_SECTION_ID := v_current_section_id;
1815:
1816: -- add the mcl as a child of the header region
1817:
1818: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 2+ : v_parent_section_id = '
1819: || v_parent_section_id || ' v_current_section_id = '
1820: || v_current_section_id || ' v_LEVEL1_SECTION_ID = ' || v_LEVEL1_SECTION_ID);
1821:
1822: --Create a new header section

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

1837: forms.form_id = forms_tl.form_id AND
1838: forms.form_id = v_current_section_id AND
1839: forms_tl.LANGUAGE = g_base_language;
1840:
1841: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 2+ - create header region for section ' || v_section_code);
1842:
1843: JDR_DOCBUILDER.setAttribute (v_section_element, 'id', v_jrad_element_id);
1844: JDR_DOCBUILDER.setAttribute (v_section_element, 'text', escapespecialchar(v_section_title));
1845: g_total_element_count := g_total_element_count + 1;

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

1905: -- normal adding of fields to an MCL for a section will be handled below,
1906: -- here, we will determine whether or not this field appears in a section
1907: -- apart from the remaining group of fields in the section
1908:
1909: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case ' || v_form_fields_row.type || ' :-: ' || v_prev_record_type);
1910:
1911: IF(v_prev_record_type <> 'SECTION_FIELD') THEN
1912: --{
1913: v_parent_section_id := v_form_fields_row.form_id;

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

1913: v_parent_section_id := v_form_fields_row.form_id;
1914: v_current_section_id := v_form_fields_row.section_id;
1915: v_LEVEL1_SECTION_ID := v_current_section_id;
1916:
1917: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case '|| v_form_fields_row.type ||':+:'
1918: || v_current_section_id);
1919:
1920: -- we have already created a oa:header region for this section
1921: -- but just that this field has been added to this section out-of-order

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

1988: v_parent_section_id := v_form_fields_row.section_id;
1989: v_current_section_id := v_form_fields_row.LEVEL2_SECTION_ID;
1990: v_LEVEL1_SECTION_ID := v_parent_section_id;
1991:
1992: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 3+ : v_parent_section_id = '
1993: || v_parent_section_id || ' v_current_section_id = '
1994: || v_current_section_id || ' v_LEVEL1_SECTION_ID = ' || v_LEVEL1_SECTION_ID);
1995:
1996: --Create a new header section

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

2013: forms.form_id = forms_tl.form_id AND
2014: forms.form_id = v_current_section_id AND
2015: forms_tl.LANGUAGE = g_base_language;
2016:
2017: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 3+ : create header region for section ' || v_section_code);
2018:
2019: JDR_DOCBUILDER.setAttribute (v_section_element, 'id', v_jrad_element_id);
2020: JDR_DOCBUILDER.setAttribute (v_section_element, 'text', escapespecialchar(v_section_title));
2021:

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

2071: --}
2072:
2073: ELSIF (v_form_fields_row.type='INNER_SECTION_FIELD') THEN
2074: --{
2075: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case ' || v_form_fields_row.type || ' :-: ' || v_prev_record_type);
2076:
2077: IF(v_prev_record_type <> 'INNER_SECTION_FIELD') THEN
2078: --{
2079:

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

2084: -- we have encountered a field inside a inner section, which was
2085: -- added out-of-order from the original set of fields directly
2086: -- inside the
2087:
2088: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case'||v_form_fields_row.type||':+:'||v_current_section_id);
2089:
2090: --create a section layout(MCL) and add it to the new section
2091: v_section_layout_element := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.OA_NS,
2092: 'messageComponentLayout');

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

2162: v_section_element := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.OA_NS, 'header');
2163:
2164: v_section_element_rd := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.OA_NS, 'header');
2165:
2166: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 4+ : v_parent_section_id = '
2167: || v_parent_section_id || ' v_current_section_id = '
2168: || v_current_section_id || ' v_LEVEL1_SECTION_ID = '
2169: || v_LEVEL1_SECTION_ID);
2170:

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

2180: forms.form_id = forms_tl.form_id AND
2181: forms.form_id = v_current_section_id AND
2182: forms_tl.LANGUAGE = g_base_language;
2183:
2184: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 4+ : create header region for section - '
2185: || v_section_code );
2186:
2187: JDR_DOCBUILDER.setAttribute (v_section_element, 'id', v_jrad_element_id);
2188: JDR_DOCBUILDER.setAttribute (v_section_element, 'text', escapespecialchar(v_section_title));

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

2204: JDR_DOCBUILDER.setAttribute (v_section_layout_element_rd, 'id', v_jrad_element_id ||'_table');
2205: JDR_DOCBUILDER.setAttribute (v_section_layout_element_rd, 'viewName',
2206: v_curr_formfieldvaluesvo_name);
2207:
2208: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'Setting viewName for ' || v_section_code
2209: ||'_table' || ' ' || v_curr_formfieldvaluesvo_name);
2210:
2211: JDR_DOCBUILDER.setAttribute (v_section_layout_element_rd, 'width', '100%');
2212:

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

2224:
2225: -- add all the rows in the table
2226: -- create a repeating section directly inside a form
2227:
2228: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'Invoke CREATE_TABLE with '
2229: || v_current_section_id || ' ' || p_form_id || ' '
2230: || v_formfieldvaluesvo_list_count);
2231:
2232: v_section_layout_element := CREATE_TABLE(v_current_section_id, v_section_layout_element,

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

2328: ELSIF (v_form_fields_row.type='INNER_REPEAT_SECTION') THEN
2329: --{
2330:
2331:
2332: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 5- : v_parent_section_id = '
2333: || v_parent_section_id || ' v_current_section_id = '
2334: || v_current_section_id || ' v_LEVEL1_SECTION_ID = '
2335: || v_LEVEL1_SECTION_ID);
2336:

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

2340: v_current_section_id := v_form_fields_row.repeating_section_id;
2341: v_LEVEL1_SECTION_ID := v_parent_section_id;
2342:
2343: -- create a header region
2344: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 5+ : v_parent_section_id = '
2345: || v_parent_section_id || ' v_current_section_id = '
2346: || v_current_section_id || ' v_LEVEL1_SECTION_ID = '
2347: || v_LEVEL1_SECTION_ID);
2348:

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

2367: forms.form_id = forms_tl.form_id AND
2368: forms.form_id = v_current_section_id AND
2369: forms_tl.LANGUAGE = g_base_language;
2370:
2371: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 5+ : create header region for section - '
2372: || v_section_code );
2373:
2374: JDR_DOCBUILDER.setAttribute (v_section_element, 'id', v_jrad_element_id);
2375: JDR_DOCBUILDER.setAttribute (v_section_element, 'text', escapespecialchar(v_section_title));

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

2394: JDR_DOCBUILDER.setAttribute (v_section_layout_element_rd, 'id', v_jrad_element_id ||'_table');
2395: JDR_DOCBUILDER.setAttribute (v_section_layout_element_rd, 'viewName',
2396: v_curr_formfieldvaluesvo_name);
2397:
2398: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'Setting viewName for ' || v_section_code
2399: ||'_table' || ' as ' || v_curr_formfieldvaluesvo_name);
2400:
2401:
2402: JDR_DOCBUILDER.setAttribute (v_section_layout_element_rd, 'width', '100%');

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

2521: --}
2522: ELSIF (v_form_fields_row.type='INNER_SECTION_REPEAT_SECTION') THEN
2523: --{
2524:
2525: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 6- : v_parent_section_id = '
2526: || v_parent_section_id || ' v_current_section_id = '
2527: || v_current_section_id || ' v_LEVEL1_SECTION_ID = '
2528: || v_LEVEL1_SECTION_ID);
2529:

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

2534: v_current_section_id := v_form_fields_row.repeating_section_id;
2535: v_LEVEL1_SECTION_ID := v_form_fields_row.section_id;
2536: -- create a header region
2537:
2538: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 6+ : v_parent_section_id = '
2539: || v_parent_section_id || ' v_current_section_id = '
2540: || v_current_section_id || ' v_LEVEL1_SECTION_ID = '
2541: || v_LEVEL1_SECTION_ID);
2542:

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

2557: forms.form_id = forms_tl.form_id AND
2558: forms.form_id = v_current_section_id AND
2559: forms_tl.LANGUAGE = g_base_language;
2560:
2561: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'case 4+ : create header region for section - ' || v_section_code );
2562:
2563: JDR_DOCBUILDER.setAttribute (v_section_element, 'id', v_jrad_element_id);
2564: JDR_DOCBUILDER.setAttribute (v_section_element, 'text', escapespecialchar(v_section_title));
2565:

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

2584:
2585: JDR_DOCBUILDER.setAttribute (v_section_layout_element_rd, 'id', v_jrad_element_id ||'_table');
2586: JDR_DOCBUILDER.setAttribute (v_section_layout_element_rd, 'viewName', v_curr_formfieldvaluesvo_name);
2587:
2588: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'Setting viewName for ' || v_section_code||'_table' || ' as ' || v_curr_formfieldvaluesvo_name);
2589: JDR_DOCBUILDER.setAttribute (v_section_layout_element_rd, 'width', '100%');
2590:
2591: -- create a table footer, and this footer as a child of the table region
2592: v_table_footer_element := JDR_DOCBUILDER.createElement (JDR_DOCBUILDER.OA_NS, 'tableFooter');

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

2722:
2723: -- v_field_jrad_id := v_section_code || '_' || v_form_fields_row.field_code;
2724: v_field_jrad_id := v_jrad_element_id;
2725:
2726: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'Creating field ' || v_field_jrad_id);
2727:
2728: IF(NVL( v_form_fields_row.SYSTEM_FLAG, 'N') = 'Y' ) THEN
2729: --{
2730: /* Bug 6050403: For the TWO_PART_FLAG system field there is need to

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

2913: JDR_DOCBUILDER.setAttribute (v_section_field_element_rd, 'viewName', v_curr_formfieldvaluesvo_name);
2914: END IF;
2915: JDR_DOCBUILDER.addChild (v_section_layout_element_rd,jdr_docbuilder.UI_NS,'contents',v_section_field_element_rd);
2916:
2917: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'Setting viewname for ' || v_form_fields_row.field_code || ' as ' || v_curr_formfieldvaluesvo_name);
2918:
2919: END IF; --}
2920:
2921: v_prev_record_type := v_form_fields_row.type;

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

2921: v_prev_record_type := v_form_fields_row.type;
2922:
2923: END LOOP; --}
2924:
2925: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'JRAD created, now saving to JDR repository');
2926:
2927: rval := JDR_DOCBUILDER.save;
2928:
2929: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'Finished saving to JDR repository');

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

2925: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'JRAD created, now saving to JDR repository');
2926:
2927: rval := JDR_DOCBUILDER.save;
2928:
2929: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'Finished saving to JDR repository');
2930:
2931: x_result :=fnd_api.g_ret_sts_success;
2932:
2933: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'END');

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

2929: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'Finished saving to JDR repository');
2930:
2931: x_result :=fnd_api.g_ret_sts_success;
2932:
2933: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'END');
2934:
2935: EXCEPTION
2936: WHEN OTHERS THEN
2937: x_result := fnd_api.g_ret_sts_error;

Line 2940: 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);

2936: WHEN OTHERS THEN
2937: x_result := fnd_api.g_ret_sts_error;
2938: x_error_code := SQLCODE;
2939: x_error_message := SUBSTR(SQLERRM, 1, 100);
2940: 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);
2941:
2942: END CREATE_FORM;
2943:
2944: /*======================================================================

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

2959:
2960: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_ABSTRACT';
2961:
2962: BEGIN
2963: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'BEGIN-');
2964:
2965: create_form(p_form_id, x_result, x_error_code, x_error_message);
2966:
2967: create_abstract_table(p_form_id, x_result, x_error_code, x_error_message);

Line 2976: 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);

2972: WHEN OTHERS THEN
2973: x_result := fnd_api.g_ret_sts_error;
2974: x_error_code := SQLCODE;
2975: x_error_message := SUBSTR(SQLERRM, 1, 100);
2976: 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);
2977:
2978: END;
2979:
2980: /*======================================================================

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

2997: BEGIN
2998: -- initialize to error
2999: x_result := fnd_api.g_ret_sts_error;
3000:
3001: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'BEGIN-');
3002:
3003: -- the overall logic to generate jrad is as follows -
3004: -- determine whether the type is 'SECTION' or 'ABSTRACT' or 'FORM'
3005:

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

3036: end if;
3037:
3038: x_result := fnd_api.g_ret_sts_success;
3039:
3040: PON_FORMS_UTIL_PVT.print_debug_log(l_api_name, 'END');
3041:
3042: EXCEPTION
3043: WHEN OTHERS THEN
3044: x_result := fnd_api.g_ret_sts_error;

Line 3047: 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);

3043: WHEN OTHERS THEN
3044: x_result := fnd_api.g_ret_sts_error;
3045: x_error_code := SQLCODE;
3046: x_error_message := SUBSTR(SQLERRM, 1, 100);
3047: 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);
3048:
3049: END CREATE_JRAD;
3050:
3051: