DBA Data[Home] [Help]

APPS.HZ_ADDRESS_USAGES_PUB dependencies on STANDARD

Line 31: -- Standard start of API savepoint

27:
28: x_return_status := FND_API.G_RET_STS_SUCCESS;
29: l_error_code := NULL;
30:
31: -- Standard start of API savepoint
32: SAVEPOINT do_create_address_usages;
33:
34: -- Map Id is mandatory
35:

Line 232: -- Standard start of API savepoint

228: l_status VARCHAR2(30);
229:
230: BEGIN
231:
232: -- Standard start of API savepoint
233: SAVEPOINT create_address_usages;
234:
235: -- Initialize message list if p_init_msg_list is set to TRUE.
236: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

270: END;
271: --dbms_output.put_line('After Gen pkg Create usage : map id :'|| p_address_usages_rec.map_id);
272: END IF;
273:
274: -- Standard call to get message count and if count is 1, get message info.
275: FND_MSG_PUB.Count_And_Get(
276: p_encoded => FND_API.G_FALSE,
277: p_count => x_msg_count,
278: p_data => x_msg_data);

Line 344: -- Standard start of API savepoint

340: db_application_id hz_address_usages.application_id%TYPE;
341:
342: BEGIN
343:
344: -- Standard start of API savepoint
345: SAVEPOINT update_address_usages;
346:
347: -- Initialize message list if p_init_msg_list is set to TRUE.
348: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

485: NULL;
486: END;
487: END IF;
488:
489: -- Standard call to get message count and if count is 1, get message info.
490: FND_MSG_PUB.Count_And_Get(
491: p_encoded => FND_API.G_FALSE,
492: p_count => x_msg_count,
493: p_data => x_msg_data);

Line 552: -- Standard start of API savepoint

548: l_status VARCHAR2(30);
549:
550: BEGIN
551:
552: -- Standard start of API savepoint
553: SAVEPOINT create_address_usage_dtls;
554:
555: -- Initialize message list if p_init_msg_list is set to TRUE.
556: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

657: END;
658: --dbms_output.put_line('After Gen pkg Create usage dtls : map id :'|| l_map_id);
659: END IF;
660:
661: -- Standard call to get message count and if count is 1, get message info.
662: FND_MSG_PUB.Count_And_Get(
663: p_encoded => FND_API.G_FALSE,
664: p_count => x_msg_count,
665: p_data => x_msg_data);

Line 745: -- Standard start of API savepoint

741: WHERE usage_id = p_usage_id;
742:
743: BEGIN
744:
745: -- Standard start of API savepoint
746: SAVEPOINT delete_address_usages;
747:
748: -- Initialize message list if p_init_msg_list is set to TRUE.
749: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

894: END IF;
895: END IF;
896: END IF;
897:
898: -- Standard call to get message count and if count is 1, get message info.
899: FND_MSG_PUB.Count_And_Get(
900: p_encoded => FND_API.G_FALSE,
901: p_count => x_msg_count,
902: p_data => x_msg_data);