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.ZPB_PERSONAL_AW dependencies on ZPB_PERSONAL_AW

Line 1: package body ZPB_PERSONAL_AW as

1: package body ZPB_PERSONAL_AW as
2: /* $Header: zpbpersonalaw.plb 120.29 2007/12/04 15:40:39 mbhat ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ZPB_PERSONAL_AW';
5: G_LOCK_OUT CONSTANT Number := 2;

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ZPB_PERSONAL_AW';

1: package body ZPB_PERSONAL_AW as
2: /* $Header: zpbpersonalaw.plb 120.29 2007/12/04 15:40:39 mbhat ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ZPB_PERSONAL_AW';
5: G_LOCK_OUT CONSTANT Number := 2;
6: g_olapSchema varchar2(3) := zpb_aw.get_schema;
7:
8: g_annotAW varchar2(30);

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 369: fnd_message.set_name('ZPB','ZPB_PERSONAL_AW_SESSION_MSG');

365:
366: EXCEPTION
367: WHEN aw_attached_rw_exception THEN
368:
369: fnd_message.set_name('ZPB','ZPB_PERSONAL_AW_SESSION_MSG');
370:
371: fnd_message.set_token('SESSION_USER', l_sess_user);
372: fnd_message.set_token('OS_USER', l_os_user);
373: fnd_message.set_token('STATUS', l_status);

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 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 1510: end ZPB_PERSONAL_AW;

1506: where USER_ID = FND_GLOBAL.USER_ID
1507: and BUSINESS_AREA_ID = p_business_area_id;
1508: end UPDATE_SHADOW;
1509:
1510: end ZPB_PERSONAL_AW;