DBA Data[Home] [Help]

APPS.CZ_IMP_SINGLE dependencies on CZ_REFS

Line 1604: --Here to call cz_refs api

1600: UPDATE CZ_PS_NODES SET
1601: DELETED_FLAG='1'
1602: WHERE CURRENT OF c_onl_ps_node;
1603:
1604: --Here to call cz_refs api
1605: IF(v_PsNodeType IN (bomModel, cnReference))THEN
1606: cz_refs.delete_Node(v_PsNodeId, v_PsNodeType, p_out_err, '1');
1607: IF (p_out_err > 0) THEN
1608: BEGIN

Line 1606: cz_refs.delete_Node(v_PsNodeId, v_PsNodeType, p_out_err, '1');

1602: WHERE CURRENT OF c_onl_ps_node;
1603:
1604: --Here to call cz_refs api
1605: IF(v_PsNodeType IN (bomModel, cnReference))THEN
1606: cz_refs.delete_Node(v_PsNodeId, v_PsNodeType, p_out_err, '1');
1607: IF (p_out_err > 0) THEN
1608: BEGIN
1609: SELECT message INTO d_str FROM cz_db_logs WHERE run_id = p_out_err;
1610: EXCEPTION

Line 1614: RAISE CZ_REFS_DELNODE_EXCP;

1610: EXCEPTION
1611: WHEN NO_DATA_FOUND THEN
1612: d_str := NULL;
1613: END;
1614: RAISE CZ_REFS_DELNODE_EXCP;
1615: END IF;
1616: END IF;
1617:
1618: END IF;

Line 1632: WHEN CZ_REFS_DELNODE_EXCP THEN

1628: CLOSE c_onl_ps_node;
1629: COMMIT;
1630:
1631: EXCEPTION
1632: WHEN CZ_REFS_DELNODE_EXCP THEN
1633: IF d_str IS NULL THEN d_str := 'NO MESSAGE FOUND'; END IF;
1634: d_str := CZ_UTILS.GET_TEXT('CZ_IMP_CZREFS_DELNODE', 'MSG', d_str);
1635: x_error :=cz_utils.log_report(d_str,1,'CZ_IMP_SINGLE.EXTR_PS_NODE: delete obsolete nodes',11276,inRun_Id);
1636: ROLLBACK;

Line 4249: cz_refs.set_Trackable_Children_Flag(nModelId);

4245: xERROR:=cz_utils.log_report(nTop_ID||':'||SQLERRM,1,'CZ_IMP_SINGLE.IMPORTSINGLEBILL.XFRPROJECTS',11276,genRun_ID);
4246: END;
4247:
4248: BEGIN
4249: cz_refs.set_Trackable_Children_Flag(nModelId);
4250: EXCEPTION
4251: WHEN OTHERS THEN
4252: xERROR:=cz_utils.log_report(nModelId||':'||SQLERRM,1,'CZ_IMP_SINGLE.IMPORTSINGLEBILL.TRACKABLE',11276,genRun_ID);
4253: END;