DBA Data[Home] [Help]

APPS.CZ_PB_MGR dependencies on JDR_DOCBUILDER

Line 3275: RETURN jdr_docbuilder.ELEMENT

3271: END get_oa_uis;
3272:
3273: -------------------
3274: FUNCTION createelement(p_namespace IN OUT NOCOPY VARCHAR2, p_tagname IN VARCHAR2)
3275: RETURN jdr_docbuilder.ELEMENT
3276: IS
3277: l_child_element jdr_docbuilder.ELEMENT;
3278: BEGIN
3279: IF (p_namespace IS NULL)

Line 3277: l_child_element jdr_docbuilder.ELEMENT;

3273: -------------------
3274: FUNCTION createelement(p_namespace IN OUT NOCOPY VARCHAR2, p_tagname IN VARCHAR2)
3275: RETURN jdr_docbuilder.ELEMENT
3276: IS
3277: l_child_element jdr_docbuilder.ELEMENT;
3278: BEGIN
3279: IF (p_namespace IS NULL)
3280: THEN
3281: p_namespace := 'jrad:';

Line 3284: l_child_element := jdr_docbuilder.createelement(p_namespace, p_tagname);

3280: THEN
3281: p_namespace := 'jrad:';
3282: END IF;
3283:
3284: l_child_element := jdr_docbuilder.createelement(p_namespace, p_tagname);
3285: RETURN l_child_element;
3286: EXCEPTION
3287: WHEN OTHERS
3288: THEN

Line 3411: p_jrad_parent_element IN jdr_docbuilder.ELEMENT

3407: END;
3408:
3409: -----------------------------------------------------
3410: PROCEDURE exploretree(
3411: p_jrad_parent_element IN jdr_docbuilder.ELEMENT
3412: ,p_dom_parent_element IN xmldom.domnode
3413: ,p_grouping_tag IN VARCHAR2
3414: ,p_link_name IN VARCHAR2
3415: )

Line 3432: l_parent_element jdr_docbuilder.ELEMENT;

3428: attrval VARCHAR2(4000);
3429: l_groupingns VARCHAR2(255);
3430: l_groupingtagname VARCHAR2(255);
3431: l_grouping_tag VARCHAR2(255);
3432: l_parent_element jdr_docbuilder.ELEMENT;
3433: l_child_element jdr_docbuilder.ELEMENT;
3434: l_ampers VARCHAR2(1) := fnd_global.local_chr(38);
3435: l_parent_tag_name VARCHAR2(255);
3436: BEGIN

Line 3433: l_child_element jdr_docbuilder.ELEMENT;

3429: l_groupingns VARCHAR2(255);
3430: l_groupingtagname VARCHAR2(255);
3431: l_grouping_tag VARCHAR2(255);
3432: l_parent_element jdr_docbuilder.ELEMENT;
3433: l_child_element jdr_docbuilder.ELEMENT;
3434: l_ampers VARCHAR2(1) := fnd_global.local_chr(38);
3435: l_parent_tag_name VARCHAR2(255);
3436: BEGIN
3437: l_child_nodes := xmldom.getchildnodes(p_dom_parent_element);

Line 3481: jdr_docbuilder.setattribute(l_child_element, attrname, attrval);

3477: attrval := REPLACE(attrval, '>', l_ampers || 'gt;');
3478: attrval := REPLACE(attrval, '<', l_ampers || 'lt;');
3479: attrval := REPLACE(attrval, '"', l_ampers || 'quot;');
3480: attrval := REPLACE(attrval, '''', l_ampers || 'apos;');
3481: jdr_docbuilder.setattribute(l_child_element, attrname, attrval);
3482: END LOOP;
3483: END IF;
3484:
3485: l_groupingns := SUBSTR(p_grouping_tag, 1, INSTR(p_grouping_tag, ':'));

Line 3493: jdr_docbuilder.addchild(p_jrad_parent_element, l_groupingns, l_groupingtagname, l_child_element);

3489: THEN
3490: l_groupingns := 'jrad:';
3491: END IF;
3492:
3493: jdr_docbuilder.addchild(p_jrad_parent_element, l_groupingns, l_groupingtagname, l_child_element);
3494: exploretree(l_child_element, l_child_node, l_grouping_tag, p_link_name);
3495: ELSE
3496: l_namespace := SUBSTR(xmldom.getnodename(l_child_node), 1, INSTR(xmldom.getnodename(l_child_node), ':'));
3497: l_tagname := SUBSTR(xmldom.getnodename(l_child_node), INSTR(xmldom.getnodename(l_child_node), ':') + 1);

Line 3512: jdr_docbuilder.setattribute(l_child_element, attrname, attrval);

3508: attrval := REPLACE(attrval, '>', l_ampers || 'gt;');
3509: attrval := REPLACE(attrval, '<', l_ampers || 'lt;');
3510: attrval := REPLACE(attrval, '"', l_ampers || 'quot;');
3511: attrval := REPLACE(attrval, '''', l_ampers || 'apos;');
3512: jdr_docbuilder.setattribute(l_child_element, attrname, attrval);
3513: END LOOP;
3514: END IF;
3515:
3516: IF (l_grouping_tag IS NULL)

Line 3518: jdr_docbuilder.addchild(p_jrad_parent_element, l_child_element);

3514: END IF;
3515:
3516: IF (l_grouping_tag IS NULL)
3517: THEN
3518: jdr_docbuilder.addchild(p_jrad_parent_element, l_child_element);
3519: exploretree(l_child_element, l_child_node, l_grouping_tag, p_link_name);
3520: ELSE
3521: exploretree(p_jrad_parent_element, l_child_node, l_grouping_tag, p_link_name);
3522: END IF;

Line 3614: jdr_docbuilder.REFRESH;

3610: pbdebug := 22021;
3611: x_return_status := FND_API.G_RET_STS_SUCCESS;
3612: x_msg_count := 0;
3613: x_msg_data := '';
3614: jdr_docbuilder.REFRESH;
3615:
3616: IF (p_document_name IS NULL) THEN
3617: RAISE document_is_null;
3618: END IF;

Line 3661: jdr_docbuilder.REFRESH;

3657: END LOOP;
3658: END IF;
3659:
3660: COMMIT;
3661: jdr_docbuilder.REFRESH;
3662: EXCEPTION
3663: WHEN document_is_null THEN
3664: x_return_status := FND_API.G_RET_STS_ERROR;
3665: x_msg_count := 1;

Line 3726: jdr_docbuilder.REFRESH;

3722: pbdebug := 22022;
3723: x_return_status := FND_API.G_RET_STS_SUCCESS;
3724: x_msg_count := 0;
3725: x_msg_data := '';
3726: jdr_docbuilder.REFRESH;
3727:
3728: IF (p_document_name IS NULL) THEN
3729: RAISE document_is_null;
3730: END IF;

Line 3845: jdr_docbuilder.REFRESH;

3841: END LOOP;
3842: END IF;
3843:
3844: COMMIT;
3845: jdr_docbuilder.REFRESH;
3846: EXCEPTION
3847: WHEN document_is_null THEN
3848: x_return_status := FND_API.G_RET_STS_ERROR;
3849: x_msg_count := 1;

Line 3903: l_doc jdr_docbuilder.document;

3899: attrval VARCHAR2(255);
3900: newattrname VARCHAR2(255);
3901: name_space VARCHAR2(255);
3902: tag_name VARCHAR2(255);
3903: l_doc jdr_docbuilder.document;
3904: top_element jdr_docbuilder.ELEMENT;
3905: g_document jdr_docbuilder.document;
3906: l_new_document jdr_docbuilder.document;
3907: jrad_save_status PLS_INTEGER;

Line 3904: top_element jdr_docbuilder.ELEMENT;

3900: newattrname VARCHAR2(255);
3901: name_space VARCHAR2(255);
3902: tag_name VARCHAR2(255);
3903: l_doc jdr_docbuilder.document;
3904: top_element jdr_docbuilder.ELEMENT;
3905: g_document jdr_docbuilder.document;
3906: l_new_document jdr_docbuilder.document;
3907: jrad_save_status PLS_INTEGER;
3908: document_is_null EXCEPTION;

Line 3905: g_document jdr_docbuilder.document;

3901: name_space VARCHAR2(255);
3902: tag_name VARCHAR2(255);
3903: l_doc jdr_docbuilder.document;
3904: top_element jdr_docbuilder.ELEMENT;
3905: g_document jdr_docbuilder.document;
3906: l_new_document jdr_docbuilder.document;
3907: jrad_save_status PLS_INTEGER;
3908: document_is_null EXCEPTION;
3909: l_msg VARCHAR2(2000);

Line 3906: l_new_document jdr_docbuilder.document;

3902: tag_name VARCHAR2(255);
3903: l_doc jdr_docbuilder.document;
3904: top_element jdr_docbuilder.ELEMENT;
3905: g_document jdr_docbuilder.document;
3906: l_new_document jdr_docbuilder.document;
3907: jrad_save_status PLS_INTEGER;
3908: document_is_null EXCEPTION;
3909: l_msg VARCHAR2(2000);
3910:

Line 3920: jdr_docbuilder.REFRESH;

3916:
3917: OPEN jrad_docs_cur;
3918:
3919: LOOP
3920: jdr_docbuilder.REFRESH;
3921:
3922: FETCH jrad_docs_cur
3923: INTO l_jrad_doc;
3924:

Line 3962: l_doc := jdr_docbuilder.createdocument(l_jrad_doc);

3958: xmlparser.parseclob(p, l_lob);
3959: doc := xmlparser.getdocument(p);
3960: SYS.DBMS_LOB.CLOSE(l_lob);
3961: SYS.DBMS_LOB.freetemporary(l_lob);
3962: l_doc := jdr_docbuilder.createdocument(l_jrad_doc);
3963: top_node := xmldom.makenode(xmldom.getdocumentelement(doc));
3964:
3965: IF (g_toplevel_attr_tbl.COUNT > 0)
3966: THEN

Line 3993: jdr_docbuilder.setattribute(top_element, attrname, attrval);

3989: LOOP
3990: n := xmldom.item(nnm, i);
3991: attrname := xmldom.getnodename(n);
3992: attrval := xmldom.getnodevalue(n);
3993: jdr_docbuilder.setattribute(top_element, attrname, attrval);
3994: END LOOP;
3995: END IF;
3996:
3997: jdr_docbuilder.settoplevelelement(l_doc, top_element);

Line 3997: jdr_docbuilder.settoplevelelement(l_doc, top_element);

3993: jdr_docbuilder.setattribute(top_element, attrname, attrval);
3994: END LOOP;
3995: END IF;
3996:
3997: jdr_docbuilder.settoplevelelement(l_doc, top_element);
3998:
3999: BEGIN
4000: exploretree(top_element, top_node, '', ' ');
4001: EXCEPTION

Line 4010: jrad_save_status := jdr_docbuilder.SAVE;

4006: THEN
4007: RAISE_APPLICATION_ERROR(-20001, 'EXPLORETREE_ERROR') ;
4008: END;
4009:
4010: jrad_save_status := jdr_docbuilder.SAVE;
4011: xmlparser.freeparser(p);
4012: xmldom.freeDocument(doc);
4013: COMMIT;
4014: jdr_docbuilder.REFRESH;

Line 4014: jdr_docbuilder.REFRESH;

4010: jrad_save_status := jdr_docbuilder.SAVE;
4011: xmlparser.freeparser(p);
4012: xmldom.freeDocument(doc);
4013: COMMIT;
4014: jdr_docbuilder.REFRESH;
4015: END LOOP;
4016:
4017: CLOSE jrad_docs_cur;
4018:

Line 4024: jdr_docbuilder.REFRESH;

4020: EXCEPTION
4021: WHEN OTHERS
4022: THEN
4023: ROLLBACK;
4024: jdr_docbuilder.REFRESH;
4025: IF l_jrad_doc is not null THEN
4026: l_msg := l_jrad_doc || '-' || SQLERRM;
4027: ELSE
4028: l_msg := SQLERRM;

Line 4271: l_doc jdr_docbuilder.document;

4267: attrval VARCHAR2(255);
4268: newattrname VARCHAR2(255);
4269: name_space VARCHAR2(255);
4270: tag_name VARCHAR2(255);
4271: l_doc jdr_docbuilder.document;
4272: top_element jdr_docbuilder.ELEMENT;
4273: g_document jdr_docbuilder.document;
4274: l_new_document jdr_docbuilder.document;
4275: jrad_save_status PLS_INTEGER;

Line 4272: top_element jdr_docbuilder.ELEMENT;

4268: newattrname VARCHAR2(255);
4269: name_space VARCHAR2(255);
4270: tag_name VARCHAR2(255);
4271: l_doc jdr_docbuilder.document;
4272: top_element jdr_docbuilder.ELEMENT;
4273: g_document jdr_docbuilder.document;
4274: l_new_document jdr_docbuilder.document;
4275: jrad_save_status PLS_INTEGER;
4276: document_is_null EXCEPTION;

Line 4273: g_document jdr_docbuilder.document;

4269: name_space VARCHAR2(255);
4270: tag_name VARCHAR2(255);
4271: l_doc jdr_docbuilder.document;
4272: top_element jdr_docbuilder.ELEMENT;
4273: g_document jdr_docbuilder.document;
4274: l_new_document jdr_docbuilder.document;
4275: jrad_save_status PLS_INTEGER;
4276: document_is_null EXCEPTION;
4277:

Line 4274: l_new_document jdr_docbuilder.document;

4270: tag_name VARCHAR2(255);
4271: l_doc jdr_docbuilder.document;
4272: top_element jdr_docbuilder.ELEMENT;
4273: g_document jdr_docbuilder.document;
4274: l_new_document jdr_docbuilder.document;
4275: jrad_save_status PLS_INTEGER;
4276: document_is_null EXCEPTION;
4277:
4278: TYPE char_tbl_type IS TABLE OF VARCHAR2(255);

Line 4284: jdr_docbuilder.REFRESH;

4280: g_toplevel_attr_tbl char_tbl_type := char_tbl_type('version', 'xml:lang', 'xmlns:oa', 'xmlns:ui', 'xmlns:jrad', 'xmlns:user', 'xmlns');
4281: l_exportfinished BOOLEAN;
4282: BEGIN
4283: pbdebug := 22027;
4284: jdr_docbuilder.REFRESH;
4285:
4286: IF (p_old_document_name IS NULL)
4287: THEN
4288: RAISE document_is_null;

Line 4337: l_doc := jdr_docbuilder.createdocument(p_new_document_name);

4333: xmlparser.parseclob(p, l_lob);
4334: doc := xmlparser.getdocument(p);
4335: SYS.DBMS_LOB.CLOSE(l_lob);
4336: SYS.DBMS_LOB.freetemporary(l_lob);
4337: l_doc := jdr_docbuilder.createdocument(p_new_document_name);
4338: top_node := xmldom.makenode(xmldom.getdocumentelement(doc));
4339:
4340: IF (g_toplevel_attr_tbl.COUNT > 0)
4341: THEN

Line 4368: jdr_docbuilder.setattribute(top_element, attrname, attrval);

4364: LOOP
4365: n := xmldom.item(nnm, i);
4366: attrname := xmldom.getnodename(n);
4367: attrval := xmldom.getnodevalue(n);
4368: jdr_docbuilder.setattribute(top_element, attrname, attrval);
4369: END LOOP;
4370: END IF;
4371:
4372: jdr_docbuilder.settoplevelelement(l_doc, top_element);

Line 4372: jdr_docbuilder.settoplevelelement(l_doc, top_element);

4368: jdr_docbuilder.setattribute(top_element, attrname, attrval);
4369: END LOOP;
4370: END IF;
4371:
4372: jdr_docbuilder.settoplevelelement(l_doc, top_element);
4373:
4374: BEGIN
4375: exploretree(top_element, top_node, '', ' ');
4376: EXCEPTION

Line 4385: jrad_save_status := jdr_docbuilder.SAVE;

4381: THEN
4382: RAISE_APPLICATION_ERROR(-20001, 'EXPLORETREE_ERROR') ;
4383: END;
4384:
4385: jrad_save_status := jdr_docbuilder.SAVE;
4386: xmlparser.freeparser(p);
4387: COMMIT;
4388: cz_pb_mgr.g_jrad_trans_list := jdr_utils.translationlist();
4389: cz_pb_mgr.g_jrad_trans_list := jdr_utils.gettranslations(p_old_document_name);

Line 4396: jdr_docbuilder.REFRESH;

4392: THEN
4393: jdr_utils.savetranslations(p_new_document_name, cz_pb_mgr.g_jrad_trans_list);
4394: END IF;
4395:
4396: jdr_docbuilder.REFRESH;
4397: COMMIT;
4398: EXCEPTION
4399: WHEN document_is_null
4400: THEN

Line 4404: EXECUTE IMMEDIATE 'BEGIN jdr_docbuilder.refresh; END;';

4400: THEN
4401: NULL;
4402: WHEN OTHERS
4403: THEN
4404: EXECUTE IMMEDIATE 'BEGIN jdr_docbuilder.refresh; END;';
4405:
4406: RAISE;
4407: END insert_into_repository;
4408:

Line 4426: jdr_docbuilder.REFRESH;

4422: pbdebug := 22028;
4423:
4424: IF (cz_pb_mgr.v_server_id <> 0)
4425: THEN
4426: jdr_docbuilder.REFRESH;
4427:
4428: IF (p_old_document_name IS NULL)
4429: THEN
4430: RAISE document_is_null;

Line 4474: EXECUTE IMMEDIATE 'BEGIN jdr_docbuilder.refresh; END;';

4470:
4471: RAISE;
4472: WHEN OTHERS
4473: THEN
4474: EXECUTE IMMEDIATE 'BEGIN jdr_docbuilder.refresh; END;';
4475:
4476: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_JRAD_DOC_ERR', 'JRADDOC', p_old_document_name, 'SQLERRM', SQLERRM);
4477: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.INSERTINTOJRADREPOS', SQLCODE);
4478: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;