DBA Data[Home] [Help]

APPS.ZPB_EXCP_PVT dependencies on ZPB_LOG

Line 73: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'Running Exceptions for user ' || l_user_id || '.');

69:
70: l_user_id := to_char(p_user_id);
71: l_task_id := to_char(p_task_id);
72:
73: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'Running Exceptions for user ' || l_user_id || '.');
74:
75: for each in task_dfn loop
76: if (each.name = EXCEPTION_LIMIT) then
77: l_exception_limit := each.value;

Line 109: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'The specified query shows inconsistent results.');

105: l_count := 1;
106: for each in statSqlMbrs loop
107: if (l_count > 1) then
108: if (l_dim <> each.dim or l_hier <> each.hier) then
109: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'The specified query shows inconsistent results.');
110: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
111: --RAISE_APPLICATION_ERROR(-20000, 'The specified query shows inconsistent results.', TRUE);
112: end if;
113: else

Line 157: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'Exceptions check completed for user ' || l_user_id || '.');

153: where task_id = l_task_id;
154: end if;
155: end if;
156:
157: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'Exceptions check completed for user ' || l_user_id || '.');
158:
159: -- End of API body.
160:
161: -- Standard check of p_commit.

Line 411: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'Finding children for task_id ' || p_task_id || ' and notification_id ' || p_notification_id || '.');

407:
408: l_task_id := to_char(p_task_id);
409: --dbms_output.put_line(l_task_id);
410:
411: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'Finding children for task_id ' || p_task_id || ' and notification_id ' || p_notification_id || '.');
412:
413: for each in task_dfn loop
414: if (each.name = QUERY_OBJECT_PATH) then
415: l_query_path := each.value;

Line 438: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'The specified query shows inconsistent results.');

434: l_count := 1;
435: for each in statSqlMbrs loop
436: if (l_count > 1) then
437: if (l_dim <> each.dim or l_hier <> each.hier) then
438: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'The specified query shows inconsistent results.');
439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
440: --RAISE_APPLICATION_ERROR(-20000, 'The specified query shows inconsistent results.', TRUE);
441: end if;
442: else

Line 470: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, l_child_ct || ' children found for task_id ' || p_task_id || ' and notification_id ' || p_notification_id || '.');

466: where task_id = p_task_id
467: and notification_id = p_notification_id;
468: end if;
469:
470: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, l_child_ct || ' children found for task_id ' || p_task_id || ' and notification_id ' || p_notification_id || '.');
471:
472: -- End of API body.
473:
474: -- Standard check of p_commit.