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.WF_EVENT_SYNCHRONIZE_PKG dependencies on WF_CORE

Line 7: -- g_begin_clob varchar2(100) := ''||wf_core.newline;

3: ------------------------------------------------------------------------------
4: /*
5: ** PRIVATE global variable
6: */
7: -- g_begin_clob varchar2(100) := ''||wf_core.newline;
8: g_begin_clob varchar2(100) := '';
9: g_end_clob varchar2(100) := '';
10: g_begin_string varchar2(100) := '';
11: g_end_string varchar2(100) := '';

Line 47: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'SYNCHRONIZE', p_event.event_name,

43: return (l_result);
44:
45: exception
46: when others then
47: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'SYNCHRONIZE', p_event.event_name,
48: p_event.event_key,
49: 'ERROR'); raise;
50: return('ERROR');
51: end;

Line 75: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'SYNCHRONIZEUPLOAD', p_event.event_name,

71: return (l_result);
72:
73: exception
74: when others then
75: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'SYNCHRONIZEUPLOAD', p_event.event_name,
76: p_event.event_key,
77: 'ERROR'); raise;
78: return('ERROR');
79: end;

Line 179: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'CREATESYNCCLOB', g_objecttype,

175: --return (syncclob);
176:
177: exception
178: when others then
179: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'CREATESYNCCLOB', g_objecttype,
180: p_ObjectKey ,null);
181: raise;
182: end;
183: ------------------------------------------------------------------------------

Line 239: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'CREATEFILE', p_Directory||

235: wf_event_synchronize_pkg.CreateClobFile(p_Directory, p_Filename, l_clob);
236:
237: exception
238: when others then
239: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'CREATEFILE', p_Directory||
240: '*'||p_Filename,p_ObjectType||'*'||p_ObjectKey ,null);
241: raise;
242: end;
243: ------------------------------------------------------------------------------

Line 352: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'CREATECLOBFILE', p_Directory||

348: utl_file.fclose(l_filehandle);
349:
350: exception
351: when others then
352: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'CREATECLOBFILE', p_Directory||
353: '*'||p_Filename,null);
354: raise;
355: end;
356: ------------------------------------------------------------------------------

Line 420: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,

416: wf_event_synchronize_pkg.uploadsyncclob( l_clob);
417:
418: exception
419: when utl_file.invalid_path then
420: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,
421: p_Filename,null);
422: wf_core.raise('WFE_INVALID_PATH');
423: when utl_file.invalid_mode then
424: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,

Line 422: wf_core.raise('WFE_INVALID_PATH');

418: exception
419: when utl_file.invalid_path then
420: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,
421: p_Filename,null);
422: wf_core.raise('WFE_INVALID_PATH');
423: when utl_file.invalid_mode then
424: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,
425: p_Filename,null);
426: wf_core.raise('WFE_INVALID_MODE');

Line 424: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,

420: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,
421: p_Filename,null);
422: wf_core.raise('WFE_INVALID_PATH');
423: when utl_file.invalid_mode then
424: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,
425: p_Filename,null);
426: wf_core.raise('WFE_INVALID_MODE');
427: when utl_file.invalid_operation then
428: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,

Line 426: wf_core.raise('WFE_INVALID_MODE');

422: wf_core.raise('WFE_INVALID_PATH');
423: when utl_file.invalid_mode then
424: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,
425: p_Filename,null);
426: wf_core.raise('WFE_INVALID_MODE');
427: when utl_file.invalid_operation then
428: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,
429: p_Filename,null);
430: wf_core.raise('WFE_INVALID_OPERATION');

Line 428: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,

424: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,
425: p_Filename,null);
426: wf_core.raise('WFE_INVALID_MODE');
427: when utl_file.invalid_operation then
428: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,
429: p_Filename,null);
430: wf_core.raise('WFE_INVALID_OPERATION');
431: when utl_file.read_error then
432: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,

Line 430: wf_core.raise('WFE_INVALID_OPERATION');

426: wf_core.raise('WFE_INVALID_MODE');
427: when utl_file.invalid_operation then
428: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,
429: p_Filename,null);
430: wf_core.raise('WFE_INVALID_OPERATION');
431: when utl_file.read_error then
432: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,
433: p_Filename,null);
434: wf_core.raise('WFE_READ_ERROR');

Line 432: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,

428: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,
429: p_Filename,null);
430: wf_core.raise('WFE_INVALID_OPERATION');
431: when utl_file.read_error then
432: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,
433: p_Filename,null);
434: wf_core.raise('WFE_READ_ERROR');
435: when utl_file.internal_error then
436: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,

Line 434: wf_core.raise('WFE_READ_ERROR');

430: wf_core.raise('WFE_INVALID_OPERATION');
431: when utl_file.read_error then
432: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,
433: p_Filename,null);
434: wf_core.raise('WFE_READ_ERROR');
435: when utl_file.internal_error then
436: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,
437: p_Filename,null);
438: wf_core.raise('WFE_INTERNAL_ERROR');

Line 436: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,

432: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,
433: p_Filename,null);
434: wf_core.raise('WFE_READ_ERROR');
435: when utl_file.internal_error then
436: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,
437: p_Filename,null);
438: wf_core.raise('WFE_INTERNAL_ERROR');
439: when utl_file.invalid_filehandle then
440: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,

Line 438: wf_core.raise('WFE_INTERNAL_ERROR');

434: wf_core.raise('WFE_READ_ERROR');
435: when utl_file.internal_error then
436: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,
437: p_Filename,null);
438: wf_core.raise('WFE_INTERNAL_ERROR');
439: when utl_file.invalid_filehandle then
440: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,
441: p_Filename,null);
442: wf_core.raise('WFE_INVALID_FILEHANDLE');

Line 440: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,

436: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,
437: p_Filename,null);
438: wf_core.raise('WFE_INTERNAL_ERROR');
439: when utl_file.invalid_filehandle then
440: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,
441: p_Filename,null);
442: wf_core.raise('WFE_INVALID_FILEHANDLE');
443: when others then
444: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,

Line 442: wf_core.raise('WFE_INVALID_FILEHANDLE');

438: wf_core.raise('WFE_INTERNAL_ERROR');
439: when utl_file.invalid_filehandle then
440: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,
441: p_Filename,null);
442: wf_core.raise('WFE_INVALID_FILEHANDLE');
443: when others then
444: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,
445: p_Filename,null);
446: raise;

Line 444: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,

440: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,
441: p_Filename,null);
442: wf_core.raise('WFE_INVALID_FILEHANDLE');
443: when others then
444: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,
445: p_Filename,null);
446: raise;
447: end;
448: ------------------------------------------------------------------------------

Line 529: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADSYNCCLOB', l_counter,

525: END LOOP;
526:
527: exception
528: when others then
529: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADSYNCCLOB', l_counter,
530: substr(l_messagedata,1,100)
531: ,null);
532: raise;
533: end;

Line 573: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'GetSystems', p_key,null,

569: return (returnclob);
570:
571: exception
572: when others then
573: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'GetSystems', p_key,null,
574: 'ERROR'); raise;
575: end;
576: ------------------------------------------------------------------------------
577: /*

Line 608: l_guid := hextoraw(wf_core.translate('WF_SYSTEM_GUID'));

604: -- upper(g_ObjectType) = 'EVENT' OR
605: -- upper(g_ObjectType) = 'SUBSCRIPTIONS' OR
606: -- upper(g_ObjectType) = 'GROUPS' OR
607: upper(g_ObjectType) = 'EVENTS') THEN
608: l_guid := hextoraw(wf_core.translate('WF_SYSTEM_GUID'));
609: ELSE
610: l_guid := hextoraw(null);
611: END IF;
612:

Line 664: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'GetAgents', p_key,null,

660:
661:
662: exception
663: when others then
664: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'GetAgents', p_key,null,
665: 'ERROR'); raise;
666: end;
667: ------------------------------------------------------------------------------
668: /*

Line 717: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'GetAgentGroups', p_key,null,

713: return (returnclob);
714:
715: exception
716: when others then
717: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'GetAgentGroups', p_key,null,
718: 'ERROR'); raise;
719: end;
720:
721: ------------------------------------------------------------------------------

Line 782: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'GetEvents', p_key,null,

778: return (returnclob);
779:
780: exception
781: when others then
782: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'GetEvents', p_key,null,
783: 'ERROR'); raise;
784: end;
785: ------------------------------------------------------------------------------
786: /*

Line 851: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'GetEventGroups', p_key,null,

847: return (returnclob);
848:
849: exception
850: when others then
851: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'GetEventGroups', p_key,null,
852: 'ERROR'); raise;
853: end;
854: ------------------------------------------------------------------------------
855: /*

Line 914: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'GetGroups', p_key,null,

910: return (returnclob);
911:
912: exception
913: when others then
914: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'GetGroups', p_key,null,
915: 'ERROR'); raise;
916: end;
917: ------------------------------------------------------------------------------
918: function GETEVENTGROUPBYGROUP (

Line 959: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'GetEventGroupByGroup', p_key,null,

955: return (returnclob);
956:
957: exception
958: when others then
959: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'GetEventGroupByGroup', p_key,null,
960: 'ERROR'); raise;
961: end;
962:
963: ------------------------------------------------------------------------------

Line 1005: l_guid := hextoraw(wf_core.translate('WF_SYSTEM_GUID'));

1001: -- upper(g_ObjectType) = 'EVENT' OR
1002: -- upper(g_ObjectType) = 'SUBSCRIPTIONS' OR
1003: -- upper(g_ObjectType) = 'GROUPS' OR
1004: upper(g_ObjectType) = 'EVENTS') THEN
1005: l_guid := hextoraw(wf_core.translate('WF_SYSTEM_GUID'));
1006: ELSE
1007: l_guid := hextoraw(null);
1008: END IF;
1009:

Line 1133: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'GetSubscriptions', p_key,null,

1129: return (returnclob);
1130:
1131: exception
1132: when others then
1133: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'GetSubscriptions', p_key,null,
1134: 'ERROR'); raise;
1135: end;
1136: ------------------------------------------------------------------------------
1137: /*

Line 1168: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'GetObjectType',

1164: return (l_return);
1165:
1166: exception
1167: when others then
1168: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'GetObjectType',
1169: substr(p_messagedata,1,100),null,
1170: 'ERROR'); raise;
1171: end;
1172: ------------------------------------------------------------------------------

Line 1202: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UploadObject',

1198: END IF;
1199:
1200: /*exception
1201: when others then
1202: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UploadObject',
1203: substr(p_messagedata,1,100),
1204: p_objecttype,
1205: 'ERROR'); raise;*/
1206: end;

Line 1232: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UpdateGUID');

1228: end if;
1229: end if;
1230: exception
1231: when others then
1232: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UpdateGUID');
1233: raise;
1234: end;
1235: ------------------------------------------------------------------------------
1236: /*

Line 1276: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'ReplaceContent');

1272: end if;
1273: return (retStr);
1274: exception
1275: when others then
1276: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'ReplaceContent');
1277: raise;
1278: end;
1279: ------------------------------------------------------------------------------
1280: /*

Line 1312: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'SetGUID');

1308: end if;
1309: return (retStr);
1310: exception
1311: when others then
1312: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'SetGUID');
1313: raise;
1314: end;
1315: ------------------------------------------------------------------------------
1316: /*

Line 1333: l_sys_guid := hextoraw(wf_core.translate('WF_SYSTEM_GUID'));

1329:
1330: begin
1331: if dataStr is not null then
1332: -- beg_pos := instr(dataStr, g_guid);
1333: l_sys_guid := hextoraw(wf_core.translate('WF_SYSTEM_GUID'));
1334: retStr := replace(dataStr,g_sys_guid,''||l_sys_guid||'');
1335: else
1336: retStr := dataStr;
1337: end if;

Line 1341: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'SetSYSTEMGUID');

1337: end if;
1338: return (retStr);
1339: exception
1340: when others then
1341: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'SetSYSTEMGUID');
1342: raise;
1343: end;
1344: ------------------------------------------------------------------------------
1345: /*

Line 1372: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'GetSID');

1368: return upper(substr(l_sid,1,30));
1369:
1370: exception
1371: when others then
1372: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'GetSID');
1373: raise;
1374: end;
1375: ------------------------------------------------------------------------------
1376: /*

Line 1403: g_qowner := upper(wf_core.translate('WF_SCHEMA'));

1399: from wf_agents
1400: where name = 'WF_IN';
1401: */
1402: if (g_qowner is null) then
1403: g_qowner := upper(wf_core.translate('WF_SCHEMA'));
1404: end if;
1405:
1406: end;
1407:

Line 1411: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'GetQOwner');

1407:
1408: return (g_qowner);
1409: exception
1410: when others then
1411: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'GetQOwner');
1412: raise;
1413: end;
1414: ------------------------------------------------------------------------------
1415: /*

Line 1459: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'SetSID');

1455: return (retStr);
1456:
1457: exception
1458: when others then
1459: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'SetSID');
1460: raise;
1461: end;
1462: ------------------------------------------------------------------------------
1463: /*

Line 1481: and system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID'));

1477:
1478: cursor agent(str varchar2) is
1479: select guid from wf_agents
1480: where name=str
1481: and system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID'));
1482:
1483: begin
1484: if dataStr is not null then
1485: tmpStr := dataStr;

Line 1549: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'SetAgent');

1545: return (retStr);
1546:
1547: exception
1548: when others then
1549: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'SetAgent');
1550: raise;
1551: end;
1552:
1553: ------------------------------------------------------------------------------

Line 1622: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'SetPound');

1618: end if;
1619: return (retStr);
1620: exception
1621: when others then
1622: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'SetPound');
1623: raise;
1624: end;
1625:
1626: ------------------------------------------------------------------------------

Line 1677: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'SetNull');

1673: end if;
1674: return (retStr);
1675: exception
1676: when others then
1677: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'SetNull');
1678: raise;
1679: end;
1680:
1681: ------------------------------------------------------------------------------

Line 1699: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'CREATEEMPTYCLOB');

1695:
1696: dbms_lob.createtemporary(p_outclob, FALSE, DBMS_LOB.CALL);
1697: exception
1698: when others then
1699: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'CREATEEMPTYCLOB');
1700: raise;
1701: end;
1702: ------------------------------------------------------------------------------
1703: /*

Line 1743: wf_core.token('GUID', l_agtguid);

1739: from wf_agents
1740: where guid = l_agtguid;
1741: exception
1742: when others then
1743: wf_core.token('GUID', l_agtguid);
1744: wf_core.raise('WFE_AGENT_NOTRESOLVE');
1745: end;
1746:
1747: l_replaceTarget := '#'||l_replaceTarget;

Line 1744: wf_core.raise('WFE_AGENT_NOTRESOLVE');

1740: where guid = l_agtguid;
1741: exception
1742: when others then
1743: wf_core.token('GUID', l_agtguid);
1744: wf_core.raise('WFE_AGENT_NOTRESOLVE');
1745: end;
1746:
1747: l_replaceTarget := '#'||l_replaceTarget;
1748:

Line 1760: wf_core.context('Wf_Event_Synchronize_Pkg', 'GetAgent');

1756: end if;
1757: return (retStr);
1758: exception
1759: when others then
1760: wf_core.context('Wf_Event_Synchronize_Pkg', 'GetAgent');
1761: raise;
1762: end;
1763: --------------------------------------------------------------------------------------------
1764: /*

Line 1820: wf_core.token('AGENT',l_agtname);

1816: end if;
1817: return (retStr);
1818: exception
1819: when no_data_found then
1820: wf_core.token('AGENT',l_agtname);
1821: wf_core.raise('WFE_SEEDAGT_NOTFOUND');
1822: when others then
1823: raise;
1824: end;

Line 1821: wf_core.raise('WFE_SEEDAGT_NOTFOUND');

1817: return (retStr);
1818: exception
1819: when no_data_found then
1820: wf_core.token('AGENT',l_agtname);
1821: wf_core.raise('WFE_SEEDAGT_NOTFOUND');
1822: when others then
1823: raise;
1824: end;
1825: --------------------------------------------------------------------------------------------

Line 1843: if (wf_core.error_name is not null) then

1839: p_error_code := null;
1840: p_error_msg := null;
1841: exception
1842: when others then
1843: if (wf_core.error_name is not null) then
1844: p_error_code := wf_core.error_name;
1845: p_error_msg := wf_core.error_message;
1846: else
1847: raise;

Line 1844: p_error_code := wf_core.error_name;

1840: p_error_msg := null;
1841: exception
1842: when others then
1843: if (wf_core.error_name is not null) then
1844: p_error_code := wf_core.error_name;
1845: p_error_msg := wf_core.error_message;
1846: else
1847: raise;
1848: end if;

Line 1845: p_error_msg := wf_core.error_message;

1841: exception
1842: when others then
1843: if (wf_core.error_name is not null) then
1844: p_error_code := wf_core.error_name;
1845: p_error_msg := wf_core.error_message;
1846: else
1847: raise;
1848: end if;
1849: end CREATESYNCCLOB2;