APPS.ZPB_EXCP_PVT dependencies on STANDARD

Line 53: -- Standard call to check for call compatibility.

49: where (query_path = l_query);
50:
51: BEGIN
52:
53: -- Standard call to check for call compatibility.
54: IF NOT FND_API.Compatible_API_Call( l_api_version,
55: p_api_version,
56: l_api_name,
57: G_PKG_NAME)

Line 98: -- Standard Start of API savepoint

94: where task_id = p_task_id;
95:
96: zpb_aw.execute('call SC.EXCEPCPRMOD(''' || to_char(l_instance_id) || ''')');
97:
98: -- Standard Start of API savepoint
99: SAVEPOINT zpb_excp_pvt_run_exception;
100:
101: --populate zpb_status_sql_members table
102: --ZPB_AW_STATUS.RUN_OLAPI_QUERIES( l_query );

Line 161: -- Standard check of p_commit.

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.
162: IF FND_API.To_Boolean( p_commit ) THEN
163: COMMIT WORK;
164: END IF;
165: -- Standard call to get message count and if count is 1, get message info.

Line 165: -- Standard call to get message count and if count is 1, get message info.

161: -- Standard check of p_commit.
162: IF FND_API.To_Boolean( p_commit ) THEN
163: COMMIT WORK;
164: END IF;
165: -- Standard call to get message count and if count is 1, get message info.
166: FND_MSG_PUB.Count_And_Get(
167: p_count => x_msg_count,
168: p_data => x_msg_data
169: );

Line 246: -- Standard Start of API savepoint

242: l_api_version CONSTANT NUMBER := 1.0;
243:
244: BEGIN
245:
246: -- Standard Start of API savepoint
247: SAVEPOINT zpb_excp_request_child_nodes;
248: -- Standard call to check for call compatibility.
249: IF NOT FND_API.Compatible_API_Call( l_api_version,
250: p_api_version,

Line 248: -- Standard call to check for call compatibility.

244: BEGIN
245:
246: -- Standard Start of API savepoint
247: SAVEPOINT zpb_excp_request_child_nodes;
248: -- Standard call to check for call compatibility.
249: IF NOT FND_API.Compatible_API_Call( l_api_version,
250: p_api_version,
251: l_api_name,
252: G_PKG_NAME)

Line 293: -- Standard check of p_commit.

289: and e.owner_id = nvl(sys_context('ZPB_CONTEXT', 'shadow_id'), fnd_global.user_id));
290:
291: -- End of API body.
292:
293: -- Standard check of p_commit.
294: IF FND_API.To_Boolean( p_commit ) THEN
295: COMMIT WORK;
296: END IF;
297: -- Standard call to get message count and if count is 1, get message info.

Line 297: -- Standard call to get message count and if count is 1, get message info.

293: -- Standard check of p_commit.
294: IF FND_API.To_Boolean( p_commit ) THEN
295: COMMIT WORK;
296: END IF;
297: -- Standard call to get message count and if count is 1, get message info.
298: FND_MSG_PUB.Count_And_Get(
299: p_count => x_msg_count,
300: p_data => x_msg_data
301: );

Line 378: -- Standard Start of API savepoint

374: where (query_path = l_query);
375:
376: BEGIN
377:
378: -- Standard Start of API savepoint
379: SAVEPOINT zpb_excp_pvt_run_exception;
380: -- Standard call to check for call compatibility.
381: IF NOT FND_API.Compatible_API_Call( l_api_version,
382: p_api_version,

Line 380: -- Standard call to check for call compatibility.

376: BEGIN
377:
378: -- Standard Start of API savepoint
379: SAVEPOINT zpb_excp_pvt_run_exception;
380: -- Standard call to check for call compatibility.
381: IF NOT FND_API.Compatible_API_Call( l_api_version,
382: p_api_version,
383: l_api_name,
384: G_PKG_NAME)

Line 474: -- Standard check of p_commit.

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.
475: IF FND_API.To_Boolean( p_commit ) THEN
476: COMMIT WORK;
477: END IF;
478: -- Standard call to get message count and if count is 1, get message info.

Line 478: -- Standard call to get message count and if count is 1, get message info.

474: -- Standard check of p_commit.
475: IF FND_API.To_Boolean( p_commit ) THEN
476: COMMIT WORK;
477: END IF;
478: -- Standard call to get message count and if count is 1, get message info.
479: FND_MSG_PUB.Count_And_Get(
480: p_count => x_msg_count,
481: p_data => x_msg_data
482: );