DBA Data[Home] [Help]

APPS.ZPB_PERSONAL_AW dependencies on ZPB_LOG

Line 44: zpb_log.write('zpb_personal_aw.annotation_create.begin',

40: l_dims varchar2(500);
41: l_persAw varchar2(60);
42: begin
43:
44: zpb_log.write('zpb_personal_aw.annotation_create.begin',
45: 'Creating personal metadata for '||p_user);
46:
47: l_persAw := g_olapSchema||'.'||g_personalAW;
48: zpb_aw.execute ('call pa.attach.shared ('''||p_user||''')');

Line 68: zpb_log.write('zpb_personal_aw.annotation_create.end',

64: zpb_aw.execute ('call an.form.pers.crt('''||l_persAw||''' '''||
65: g_olapSchema||'.'||g_sharedAW||''' '''||
66: g_olapSchema||'.'||g_annotAW||''')');
67:
68: zpb_log.write('zpb_personal_aw.annotation_create.end',
69: 'End annotation creation');
70: end ANNOTATION_CREATE;
71:
72: -------------------------------------------------------------------------------

Line 416: ZPB_LOG.WRITE ('zpb_metadata_map.aw_update.begin', 'Begin Metadata Update');

412: l_upd boolean := false;
413: l_proc varchar2(9) := 'aw_update';
414:
415: begin
416: ZPB_LOG.WRITE ('zpb_metadata_map.aw_update.begin', 'Begin Metadata Update');
417:
418: ZPB_AW.EXECUTE ('PA.VIEW.DELETED = no');
419: --
420: -- For security, check to see if security needs updating:

Line 479: ZPB_LOG.WRITE_EVENT (G_PKG_NAME||'.'||l_proc,

475: end if;
476:
477: if (l_dims is not null) then
478: begin
479: ZPB_LOG.WRITE_EVENT (G_PKG_NAME||'.'||l_proc,
480: 'Updating dimensions: '||l_dims);
481:
482: ZPB_METADATA_PKG.BUILD_PERSONAL_DIMS (g_personalAW, g_sharedAW,
483: 'PERSONAL', l_dims);

Line 488: ZPB_LOG.LOG_PLSQL_EXCEPTION (G_PKG_NAME, l_proc);

484: VIEWS_UPDATE(g_personalAW, p_user, l_dims, 'Y');
485: l_ret := true;
486: exception
487: when others then
488: ZPB_LOG.LOG_PLSQL_EXCEPTION (G_PKG_NAME, l_proc);
489: ZPB_ERROR_HANDLER.HANDLE_EXCEPTION (G_PKG_NAME,
490: l_proc,
491: 'ZPB_STARTUP_DIM_MAP_ERR_MSG');
492: --

Line 524: zpb_log.write('zpb_personal_aw.data_views_create.begin',

520: p_approver in varchar2)
521: is
522: l_aw varchar2(32);
523: begin
524: zpb_log.write('zpb_personal_aw.data_views_create.begin',
525: 'Creating data views for '||p_user||
526: ', instance: '||p_instance);
527:
528: get_aws(p_user);

Line 535: zpb_log.write('zpb_personal_aw.data_views_create.end',

531: ZPB_AW.EXECUTE ('CALL CM.BUILD.INSTVIEW ('''||l_aw||''' '''||
532: p_instance||''' '''||p_type||''' '''||p_template||''' '''||
533: p_approver||''')');
534:
535: zpb_log.write('zpb_personal_aw.data_views_create.end',
536: 'Created data views for '||p_user||
537: ', instance: '||p_instance);
538: end DATA_VIEWS_CREATE;
539:

Line 714: zpb_log.write('zpb_personal_aw.measures_shared_update.begin',

710: return BOOLEAN
711: is
712: l_value varchar2(20);
713: begin
714: zpb_log.write('zpb_personal_aw.measures_shared_update.begin',
715: 'Creating structures for shared measures');
716:
717: l_value := zpb_aw.interp ('call PA.MERGE.INST ('''||p_user||''' '''||
718: FND_GLOBAL.RESP_ID||''' '''||

Line 725: zpb_log.write('zpb_personal_aw.measures_shared_update.end', 'Done');

721: ZPB_ERROR_HANDLER.MERGE_STATUS(x_return_status,
722: FND_API.G_RET_STS_UNEXP_ERROR);
723: end if;
724:
725: zpb_log.write('zpb_personal_aw.measures_shared_update.end', 'Done');
726: return true;
727: end MEASURES_SHARED_UPDATE;
728: -------------------------------------------------------------------------------
729: -- METADATA_CREATE - Copies the metadata objects from shared AW into a

Line 760: zpb_log.write('zpb_personal_aw.metadata_create.begin',

756: l_attr_ecm zpb_ecm.attr_ecm;
757: l_line_type_ecm zpb_ecm.line_type_ecm;
758:
759: begin
760: zpb_log.write('zpb_personal_aw.metadata_create.begin',
761: 'Creating personal metadata for '||p_user);
762:
763: get_aws(p_user);
764: zpb_aw.execute ('call pa.attach.shared ('''||p_user||''')');

Line 857: zpb_log.write('zpb_personal_aw.metadata_create.end',

853: import (p_user, null, 'N');
854:
855: zpb_aw.execute ('call PA.ATTACH.SHARED('''||p_user||''' false)');
856:
857: zpb_log.write('zpb_personal_aw.metadata_create.end',
858: 'Created personal metadata for '||p_user);
859:
860: end METADATA_CREATE;
861:

Line 894: ZPB_LOG.LOG_PLSQL_EXCEPTION (G_PKG_NAME, l_proc);

890: return l_ret;
891:
892: exception
893: when others then
894: ZPB_LOG.LOG_PLSQL_EXCEPTION (G_PKG_NAME, l_proc);
895: ZPB_ERROR_HANDLER.REGISTER_CONFIRMATION
896: (G_PKG_NAME,
897: l_proc,
898: 'ZPB_STARTUP_META_UPD_ERR_MSG');

Line 930: ZPB_LOG.LOG_PLSQL_EXCEPTION (G_PKG_NAME, l_proc);

926: g_olapSchema||'.'||g_sharedAW||''' '''||g_olapSchema||'.'||
927: g_personalAW||''')');
928: exception
929: when others then
930: ZPB_LOG.LOG_PLSQL_EXCEPTION (G_PKG_NAME, l_proc);
931: ZPB_ERROR_HANDLER.HANDLE_EXCEPTION (G_PKG_NAME,
932: l_proc,
933: 'ZPB_STARTUP_SEC_ERR_MSG');
934: ZPB_ERROR_HANDLER.MERGE_STATUS(x_return_status,

Line 1012: zpb_log.write('zpb_personal_aw.startup', 'Begin startup for '||p_user);

1008: FND_MSG_PUB.INITIALIZE;
1009: end if;
1010:
1011: x_return_status := FND_API.G_RET_STS_SUCCESS;
1012: zpb_log.write('zpb_personal_aw.startup', 'Begin startup for '||p_user);
1013:
1014: --dbms_output.put_line ('Start: '||to_char(sysdate, 'HH:MI:SS'));
1015:
1016: select RESPONSIBILITY_ID

Line 1149: zpb_log.write('zpb_personal_aw.startup.end',

1145: FND_MSG_PUB.COUNT_AND_GET
1146: (p_count => x_msg_count,
1147: p_data => x_msg_data);
1148:
1149: zpb_log.write('zpb_personal_aw.startup.end',
1150: 'Completed startup for '||p_user);
1151: /*
1152: exception
1153: when FND_API.G_EXC_ERROR then

Line 1201: zpb_log.write('zpb_personal_aw.views_update.begin',

1197:
1198: l_dim_ecm zpb_ecm.dimension_ecm;
1199: l_dim_data zpb_ecm.dimension_data;
1200: begin
1201: zpb_log.write('zpb_personal_aw.views_update.begin',
1202: 'Updating metadata views for dims: '||p_dims);
1203:
1204: if (p_dims is not null) then
1205: zpb_aw.execute ('call DB.BUILD.LMAP ('''||g_olapSchema||'.'||

Line 1279: zpb_log.write('zpb_personal_aw.views_update.end',

1275: exit when j=0;
1276: end loop;
1277: end if;
1278:
1279: zpb_log.write('zpb_personal_aw.views_update.end',
1280: 'Updated metadata views');
1281: end VIEWS_UPDATE;
1282:
1283: -------------------------------------------------------------------------------

Line 1312: zpb_log.write('zpb_personal_aw.personal_aw_rw_scan.begin',

1308: is
1309: l_val number;
1310: begin
1311:
1312: zpb_log.write('zpb_personal_aw.personal_aw_rw_scan.begin',
1313: 'Scanning for personal AW r/w session for '||p_user);
1314:
1315: --
1316: -- Need to separate these queries. When lumped together, performance is bad

Line 1337: zpb_log.write('zpb_personal_aw.views_update.end',

1333: from v$session
1334: where sid = l_val
1335: and status <> 'KILLED';
1336:
1337: zpb_log.write('zpb_personal_aw.views_update.end',
1338: 'Personal r/w AW sessions scanned for '||p_user);
1339: exception
1340: when no_data_found then
1341: null;

Line 1445: ZPB_LOG.LOG_PLSQL_EXCEPTION (G_PKG_NAME, l_proc);

1441: and TEMPLATE_ID = del_meas.TEMPLATE_ID
1442: and OBJECT_USER_ID = del_meas.OBJECT_USER_ID;
1443: exception
1444: when others then
1445: ZPB_LOG.LOG_PLSQL_EXCEPTION (G_PKG_NAME, l_proc);
1446: ZPB_ERROR_HANDLER.HANDLE_EXCEPTION
1447: (G_PKG_NAME,
1448: l_proc,
1449: 'ZPB_STARTUP_MEAS_DLT_ERR_MSG',

Line 1468: ZPB_LOG.LOG_PLSQL_EXCEPTION (G_PKG_NAME, l_proc);

1464: zpb_aw.execute('CALL PA.ATTACH.APPROVEE('''||zpb_aw.get_schema||'.'||
1465: zpb_aw.get_personal_aw(personal.OBJECT_USER_ID)||''')');
1466: exception
1467: when others then
1468: ZPB_LOG.LOG_PLSQL_EXCEPTION (G_PKG_NAME, l_proc);
1469: ZPB_ERROR_HANDLER.HANDLE_EXCEPTION
1470: (G_PKG_NAME,
1471: l_proc,
1472: 'ZPB_STARTUP_APP_MEAS_ERR_MSG',