APPS.ZPB_AW dependencies on ZPB_LOG

Line 21: zpb_log.write_statement ('zpb_aw.execute',

17: procedure EXECUTE (p_cmd in varchar2)
18: is
19: begin
20: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
21: zpb_log.write_statement ('zpb_aw.execute',
22: 'Executing AW Statement: '||p_cmd);
23: end if;
24: dbms_aw.execute(p_cmd);
25: end execute;

Line 43: zpb_log.write_statement ('zpb_aw.interp',

39: is
40: l_return varchar2(4000);
41: begin
42: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
43: zpb_log.write_statement ('zpb_aw.interp',
44: 'Interpreting AW Statement: '||p_cmd);
45:
46: l_return := dbms_lob.substr(dbms_aw.interp (p_cmd), 4000);
47:

Line 48: zpb_log.write_statement ('zpb_aw.interp',

44: 'Interpreting AW Statement: '||p_cmd);
45:
46: l_return := dbms_lob.substr(dbms_aw.interp (p_cmd), 4000);
47:
48: zpb_log.write_statement ('zpb_aw.interp',
49: 'AW Statement returned: '||l_return);
50: return l_return;
51: else
52: return dbms_lob.substr(dbms_aw.interp (p_cmd), 4000);

Line 71: zpb_log.write_statement ('zpb_aw.interpbool',

67: return boolean is
68: l_return boolean;
69: begin
70: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
71: zpb_log.write_statement ('zpb_aw.interpbool',
72: 'Interpreting AW Statement: '||p_cmd);
73: end if;
74:
75: if (dbms_aw.eval_number('if nafill('||substr(p_cmd, 5)||

Line 84: zpb_log.write_statement ('zpb_aw.interpbool',

80: end if;
81:
82: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
83: if (l_return) then
84: zpb_log.write_statement ('zpb_aw.interpbool',
85: 'AW Statement returned true');
86: else
87: zpb_log.write_statement ('zpb_aw.interpbool',
88: 'AW Statement returned false');

Line 87: zpb_log.write_statement ('zpb_aw.interpbool',

83: if (l_return) then
84: zpb_log.write_statement ('zpb_aw.interpbool',
85: 'AW Statement returned true');
86: else
87: zpb_log.write_statement ('zpb_aw.interpbool',
88: 'AW Statement returned false');
89: end if;
90: end if;
91: return l_return;

Line 109: zpb_log.write_statement ('zpb_aw.eval_text',

105: return VARCHAR2 is
106: l_return varchar2(4000);
107: begin
108: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
109: zpb_log.write_statement ('zpb_aw.eval_text',
110: 'Interpreting AW Statement: '||p_cmd);
111:
112: l_return := dbms_lob.substr(dbms_aw.eval_text(p_cmd), 4000);
113:

Line 114: zpb_log.write_statement ('zpb_aw.eval_text',

110: 'Interpreting AW Statement: '||p_cmd);
111:
112: l_return := dbms_lob.substr(dbms_aw.eval_text(p_cmd), 4000);
113:
114: zpb_log.write_statement ('zpb_aw.eval_text',
115: 'AW Statement returned: '||l_return);
116: return l_return;
117: else
118: return dbms_lob.substr(dbms_aw.eval_text(p_cmd), 4000);

Line 137: zpb_log.write_statement ('zpb_aw.eval_text',

133: return NUMBER is
134: l_return NUMBER;
135: begin
136: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
137: zpb_log.write_statement ('zpb_aw.eval_text',
138: 'Interpreting AW Statement: '||p_cmd);
139:
140: l_return := dbms_aw.eval_number(p_cmd);
141:

Line 142: zpb_log.write_statement ('zpb_aw.eval_text',

138: 'Interpreting AW Statement: '||p_cmd);
139:
140: l_return := dbms_aw.eval_number(p_cmd);
141:
142: zpb_log.write_statement ('zpb_aw.eval_text',
143: 'AW Statement returned: '||l_return);
144: return l_return;
145: else
146: return dbms_aw.eval_number(p_cmd);

Line 427: ZPB_LOG.WRITE (l_api_name||'.begin',

423:
424: -- Initialize API return status to success
425: x_return_status := FND_API.G_RET_STS_SUCCESS;
426:
427: ZPB_LOG.WRITE (l_api_name||'.begin',
428: 'Initializing Bus Area '||p_business_area_id);
429:
430: if p_detach_all = FND_API.G_TRUE then
431: DETACH_ALL;

Line 579: ZPB_LOG.WRITE (l_api_name||'.begin', 'Initializing User '||p_user);

575:
576: -- Initialize API return status to success
577: x_return_status := FND_API.G_RET_STS_SUCCESS;
578:
579: ZPB_LOG.WRITE (l_api_name||'.begin', 'Initializing User '||p_user);
580:
581: if (p_business_area_id is null) then
582: null;
583: end if;

Line 704: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME||'.'||l_api_name||'.begin',

700: END IF;
701: -- Initialize API return status to success
702: x_return_status := FND_API.G_RET_STS_SUCCESS;
703:
704: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME||'.'||l_api_name||'.begin',
705: 'Begin OLAP workspace cleaning');
706:
707: --
708: -- Detach all AW's that are attached, except for EXPRESS

Line 716: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME||'.'||l_api_name||'.end',

712: ZPB_SECURITY_CONTEXT.INITCONTEXT(null, null, null, null, null);
713:
714: DBMS_AW.SHUTDOWN;
715:
716: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME||'.'||l_api_name||'.end',
717: 'OLAP workspace has been cleaned');
718:
719: -- Standard call to get message count and if count is 1, get message info.
720: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data );