DBA Data[Home] [Help]

APPS.ZPB_PERSONAL_AW dependencies on ZPB_ERROR_HANDLER

Line 489: ZPB_ERROR_HANDLER.HANDLE_EXCEPTION (G_PKG_NAME,

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: --
493: -- Reattach personal to remove changes to dimensions:

Line 498: ZPB_ERROR_HANDLER.MERGE_STATUS(x_return_status,

494: --
495: zpb_aw.execute('aw detach '||g_olapSchema||'.'||g_personalAW);
496: zpb_aw.execute('call PA.ATTACH.PERSONAL('''||p_user||''' '''||
497: g_attach_mode||''')');
498: ZPB_ERROR_HANDLER.MERGE_STATUS(x_return_status,
499: FND_API.G_RET_STS_UNEXP_ERROR);
500:
501: end;
502: end if;

Line 721: ZPB_ERROR_HANDLER.MERGE_STATUS(x_return_status,

717: l_value := zpb_aw.interp ('call PA.MERGE.INST ('''||p_user||''' '''||
718: FND_GLOBAL.RESP_ID||''' '''||
719: g_personalAW||''' '''||g_sharedAW||''')');
720: if (l_value <> 'S') then
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');

Line 895: ZPB_ERROR_HANDLER.REGISTER_CONFIRMATION

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');
899:

Line 903: ZPB_ERROR_HANDLER.MERGE_STATUS(x_return_status,

899:
900: zpb_aw.execute ('aw detach '||g_olapSchema||'.'||g_personalAW);
901: zpb_aw.execute ('call PA.ATTACH.PERSONAL('''||p_user||''' '''||
902: g_attach_mode||''')');
903: ZPB_ERROR_HANDLER.MERGE_STATUS(x_return_status,
904: FND_API.G_RET_STS_UNEXP_ERROR);
905: return null;
906: end METADATA_UPDATE;
907:

Line 931: ZPB_ERROR_HANDLER.HANDLE_EXCEPTION (G_PKG_NAME,

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,
935: FND_API.G_RET_STS_UNEXP_ERROR);

Line 934: ZPB_ERROR_HANDLER.MERGE_STATUS(x_return_status,

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,
935: FND_API.G_RET_STS_UNEXP_ERROR);
936:
937: end SECURITY_UPDATE;
938:

Line 1446: ZPB_ERROR_HANDLER.HANDLE_EXCEPTION

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',
1450: 'INST',

Line 1452: ZPB_ERROR_HANDLER.MERGE_STATUS(x_return_status,

1448: l_proc,
1449: 'ZPB_STARTUP_MEAS_DLT_ERR_MSG',
1450: 'INST',
1451: del_meas.AC_INSTANCE_ID);
1452: ZPB_ERROR_HANDLER.MERGE_STATUS(x_return_status,
1453: FND_API.G_RET_STS_UNEXP_ERROR);
1454: end;
1455: end loop;
1456:

Line 1469: ZPB_ERROR_HANDLER.HANDLE_EXCEPTION

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',
1473: 'OBJ',

Line 1475: ZPB_ERROR_HANDLER.MERGE_STATUS(x_return_status,

1471: l_proc,
1472: 'ZPB_STARTUP_APP_MEAS_ERR_MSG',
1473: 'OBJ',
1474: personal.OBJECT_USER_ID);
1475: ZPB_ERROR_HANDLER.MERGE_STATUS(x_return_status,
1476: FND_API.G_RET_STS_UNEXP_ERROR);
1477: end;
1478: end loop;
1479: