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_METADATA_PKG dependencies on ZPB_LOG

Line 1136: -- zpb_log.write_error('zpb_metadata_pkg.deleteCubeRecord',

1132: procedure deleteCubeRecord(p_cube_id in number) is
1133:
1134: begin
1135:
1136: -- zpb_log.write_error('zpb_metadata_pkg.deleteCubeRecord',
1137: -- 'Deleteing Cube '||p_cube_id);
1138:
1139: -- delete cube measures and measure scoping entries
1140:

Line 3247: zpb_log.write('zpb_metadata_pkg.build_cube.begin',

3243: bus_area_id_num number;
3244:
3245: begin
3246:
3247: zpb_log.write('zpb_metadata_pkg.build_cube.begin',
3248: 'Creating metadata in ' || p_aw ||
3249: ' for cube ' || p_cubeView ||
3250: ' of type '|| p_cube_type);
3251: l_gid := false;

Line 3315: zpb_log.write_event('zpb_metadata.build_cube.error',

3311: where epb_id = l_dim and bus_area_id = bus_area_id_num;
3312:
3313: exception
3314: when no_data_found then
3315: zpb_log.write_event('zpb_metadata.build_cube.error',
3316: 'No metadata for dimension ' || l_dim ||
3317: ' of cube ' || p_cubeView);
3318: end;
3319:

Line 3358: zpb_log.write_event('zpb_metadata.build_cube.error',

3354:
3355: exception
3356: when no_data_found then
3357:
3358: zpb_log.write_event('zpb_metadata.build_cube.error',
3359: 'No metadata for hierarchy ' || l_hier ||
3360: ' of dimension ' || m_cube_dims_en.dimensionId);
3361: end;
3362:

Line 3394: zpb_log.write_event('zpb_metadata.build_cube.error',

3390:
3391: exception
3392: when no_data_found then
3393:
3394: zpb_log.write_event('zpb_metadata.build_cube.error',
3395: 'No metadata for null hierarchy ' ||
3396: ' of dimension ' || m_cube_dims_en.dimensionId);
3397: end;
3398:

Line 3408: zpb_log.write('zpb_metadata_pkg.build_instance.end',

3404: end if;
3405: exit when j=0;
3406: end loop;
3407:
3408: zpb_log.write('zpb_metadata_pkg.build_instance.end',
3409: 'succesfull completion');
3410:
3411: EXCEPTION
3412: WHEN OTHERS THEN

Line 3413: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));

3409: 'succesfull completion');
3410:
3411: EXCEPTION
3412: WHEN OTHERS THEN
3413: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
3414: return;
3415:
3416:
3417: end BUILD_CUBE;

Line 3466: zpb_log.write('zpb_metadata_pkg.build_instance.begin',

3462: begin
3463:
3464:
3465:
3466: zpb_log.write('zpb_metadata_pkg.build_instance.begin',
3467: 'Creating metadata in ' || p_aw ||
3468: ' of type ' || p_type ||
3469: ' for instance '|| p_instance ||
3470: ' and template ' || p_template ||

Line 3859: zpb_log.write('zpb_metadata_pkg.build_instance.end',

3855:
3856: end if; -- shared or shared view for currency building
3857: zpb_aw.execute ('pop '||l_measAw||'MEASURE');
3858:
3859: zpb_log.write('zpb_metadata_pkg.build_instance.end',
3860: 'succesfull completion');
3861:
3862: EXCEPTION
3863: WHEN OTHERS THEN

Line 3865: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));

3861:
3862: EXCEPTION
3863: WHEN OTHERS THEN
3864: -- dbms_output.put_line('OTHERS : ' || substr(sqlerrm,1,90));
3865: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
3866: return;
3867:
3868: end BUILD_INSTANCE;
3869:

Line 3926: zpb_log.write('zpb_metadata_pkg.build_measure.begin',

3922: bus_area_id_num number;
3923:
3924: begin
3925:
3926: zpb_log.write('zpb_metadata_pkg.build_measure.begin',
3927: 'Creating metadata in ' || p_aw ||
3928: ' in cube ' || p_cube ||
3929: ' for measure ' || p_meas ||
3930: ' for instance '|| p_instance ||

Line 4149: zpb_log.write_event('zpb_metadata_pkg.build_measure.error',

4145:
4146: m_meas_id := InsertMeasureRecord(m_meas_en);
4147:
4148: else
4149: zpb_log.write_event('zpb_metadata_pkg.build_measure.error',
4150: 'No metadata created because no metadata for' ||
4151: 'cube ' || p_cube);
4152:
4153: end if;

Line 4158: zpb_log.write('zpb_metadata.build_measure.end',

4154:
4155:
4156: zpb_aw.execute ('pop '||l_awQual||'MEASURE');
4157:
4158: zpb_log.write('zpb_metadata.build_measure.end',
4159: 'succesfull completion');
4160:
4161: EXCEPTION
4162: WHEN OTHERS THEN

Line 4163: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));

4159: 'succesfull completion');
4160:
4161: EXCEPTION
4162: WHEN OTHERS THEN
4163: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
4164: return;
4165:
4166: end BUILD_MEASURE;
4167:

Line 4231: zpb_log.write('zpb_metadata_pkg.build.begin',

4227: m_column_id_num number;
4228:
4229: begin
4230:
4231: zpb_log.write('zpb_metadata_pkg.build.begin',
4232: 'Creating metadata map for '||p_aw);
4233: -- dbms_output.put_line('Creating metadata map for '||p_aw);
4234:
4235: bus_area_id_num := sys_context('ZPB_CONTEXT', 'business_area_id');

Line 4662: zpb_log.write('zpb_metadata_pkg.build.end',

4658: end if;
4659:
4660: zpb_aw.execute('pop oknullstatus '||l_global_ecm.AttrDim);
4661:
4662: zpb_log.write('zpb_metadata_pkg.build.end',
4663: 'Created metadata map for '||p_aw);
4664:
4665: EXCEPTION
4666: WHEN OTHERS THEN

Line 4667: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));

4663: 'Created metadata map for '||p_aw);
4664:
4665: EXCEPTION
4666: WHEN OTHERS THEN
4667: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
4668: return;
4669:
4670: end BUILD;
4671:

Line 5276: -- zpb_log.write_error('zpb_metadata_pkg.delete_user',

5272: name like p_sharaw || '%';
5273:
5274: begin
5275:
5276: -- zpb_log.write_error('zpb_metadata_pkg.delete_user',
5277: -- 'Deleteing User '||p_user);
5278:
5279: bus_area_id_num := sys_context('ZPB_CONTEXT', 'business_area_id');
5280:

Line 5303: -- zpb_log.write_error('zpb_metadata_pkg.delete_user',

5299: name like p_user || '/_%' escape '/';
5300:
5301: begin
5302:
5303: -- zpb_log.write_error('zpb_metadata_pkg.delete_user',
5304: -- 'Deleteing User '||p_user);
5305:
5306: bus_area_id_num := sys_context('ZPB_CONTEXT', 'business_area_id');
5307:

Line 5342: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));

5338: end if;
5339:
5340: EXCEPTION
5341: WHEN OTHERS THEN
5342: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
5343: return;
5344:
5345: end delete_user;
5346:

Line 5726: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name, 'ZPB_STARTUP_NOHIER_WARN : ' || l_dim_data.Sdsc);

5722: (G_PKG_NAME,
5723: l_api_name,
5724: 'ZPB_STARTUP_NOHIER_WARN', 'DIM', l_dim_data.Sdsc );
5725: -- dbms_output.put_line('ZPB_STARTUP_NOHIER_WARN : ' || l_dim_data.Sdsc);
5726: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name, 'ZPB_STARTUP_NOHIER_WARN : ' || l_dim_data.Sdsc);
5727: end if;
5728:
5729:
5730: -- give scope to user to the null hierarchies of all attribute range dimensions

Line 5842: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));

5838: zpb_aw.execute('pop oknullstatus');
5839:
5840: EXCEPTION
5841: WHEN OTHERS THEN
5842: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
5843: return;
5844:
5845: end BUILD_PERSONAL_DIMS;
5846: