DBA Data[Home] [Help]

APPS.AST_WEBASSIST_PVT dependencies on STANDARD

Line 54: -- Standard begin of API savepoint

50: l_web_assist_rec web_assist_rec_type;
51: l_web_search_rec web_search_rec_type;
52: l_query_string_rec query_string_rec_type;
53: BEGIN
54: -- Standard begin of API savepoint
55: SAVEPOINT Create_WebAssist_PVT;
56:
57: -- Standard call to check FOR call compatibility.
58: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 57: -- Standard call to check FOR call compatibility.

53: BEGIN
54: -- Standard begin of API savepoint
55: SAVEPOINT Create_WebAssist_PVT;
56:
57: -- Standard call to check FOR call compatibility.
58: IF NOT FND_API.Compatible_API_Call (l_api_version,
59: p_api_version,
60: l_api_name,
61: G_PKG_NAME)

Line 424: -- Standard check of p_commit.

420: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
422: END IF;
423: END IF;
424: -- Standard check of p_commit.
425: IF FND_API.To_Boolean ( p_commit ) THEN
426: COMMIT WORK;
427: END IF;
428:

Line 436: -- Standard call to get message count AND IF count is 1, get message info.

432: FND_MESSAGE.Set_Name('ast', 'Pvt WebAssist API: End');
433: FND_MSG_PUB.Add;
434: END IF;
435:
436: -- Standard call to get message count AND IF count is 1, get message info.
437: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
438: p_data => x_msg_data );
439:
440:

Line 495: -- Standard begin of API savepoint

491: l_query_string_rec query_string_rec_type;
492:
493: BEGIN
494:
495: -- Standard begin of API savepoint
496: SAVEPOINT Lock_WebAssist_PVT;
497:
498: -- Standard call to check FOR call compatibility.
499: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 498: -- Standard call to check FOR call compatibility.

494:
495: -- Standard begin of API savepoint
496: SAVEPOINT Lock_WebAssist_PVT;
497:
498: -- Standard call to check FOR call compatibility.
499: IF NOT FND_API.Compatible_API_Call (l_api_version,
500: p_api_version,
501: l_api_name,
502: G_PKG_NAME)

Line 653: -- Standard check of p_commit.

649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
650: END IF;
651: END IF;
652:
653: -- Standard check of p_commit.
654: IF FND_API.To_Boolean ( p_commit ) THEN
655: COMMIT WORK;
656: END IF;
657:

Line 658: -- Standard call to get message count AND IF count is 1, get message info.

654: IF FND_API.To_Boolean ( p_commit ) THEN
655: COMMIT WORK;
656: END IF;
657:
658: -- Standard call to get message count AND IF count is 1, get message info.
659:
660: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
661: p_data => x_msg_data );
662:

Line 718: -- Standard begin of API savepoint

714: l_web_search_rec web_search_rec_type;
715: l_query_string_rec query_string_rec_type;
716:
717: BEGIN
718: -- Standard begin of API savepoint
719: SAVEPOINT Update_WebAssist_PVT;
720: -- Standard call to check FOR call compatibility.
721: IF NOT FND_API.Compatible_API_Call (l_api_version,
722: p_api_version,

Line 720: -- Standard call to check FOR call compatibility.

716:
717: BEGIN
718: -- Standard begin of API savepoint
719: SAVEPOINT Update_WebAssist_PVT;
720: -- Standard call to check FOR call compatibility.
721: IF NOT FND_API.Compatible_API_Call (l_api_version,
722: p_api_version,
723: l_api_name,
724: G_PKG_NAME)

Line 906: -- Standard check of p_commit.

902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
903: END IF;
904: END IF;
905:
906: -- Standard check of p_commit.
907: IF FND_API.To_Boolean ( p_commit ) THEN
908: COMMIT WORK;
909: END IF;
910:

Line 911: -- Standard call to get message count AND IF count is 1, get message info.

907: IF FND_API.To_Boolean ( p_commit ) THEN
908: COMMIT WORK;
909: END IF;
910:
911: -- Standard call to get message count AND IF count is 1, get message info.
912: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
913: p_data => x_msg_data );
914:
915:

Line 979: -- Standard begin of API savepoint

975: l_web_search_rec web_search_rec_type;
976: l_query_string_rec query_string_rec_type;
977:
978: BEGIN
979: -- Standard begin of API savepoint
980: SAVEPOINT Delete_WebAssist_PVT;
981:
982: -- Standard call to check FOR call compatibility.
983: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 982: -- Standard call to check FOR call compatibility.

978: BEGIN
979: -- Standard begin of API savepoint
980: SAVEPOINT Delete_WebAssist_PVT;
981:
982: -- Standard call to check FOR call compatibility.
983: IF NOT FND_API.Compatible_API_Call (l_api_version,
984: p_api_version,
985: l_api_name,
986: G_PKG_NAME)

Line 1064: -- Standard check of p_commit.

1060: WHERE web_assist_id = p_web_assist_rec.web_assist_id;
1061: END IF;
1062:
1063:
1064: -- Standard check of p_commit.
1065: IF FND_API.To_Boolean ( p_commit ) THEN
1066: commit work;
1067: END IF;
1068: -- ENDof API body

Line 1105: -- Standard call to get message count AND IF count is 1, get message info.

1101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1102: END IF;
1103: END IF;
1104:
1105: -- Standard call to get message count AND IF count is 1, get message info.
1106: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1107: p_data => x_msg_data );
1108:
1109: