DBA Data[Home] [Help]

APPS.AS_SALES_LEAD_RANKS_PVT dependencies on STANDARD

Line 111: -- Standard call to get message count and IF count is 1, get message info.

107: END IF;
108: CLOSE C_Get_Ranks;
109: END IF;
110:
111: -- Standard call to get message count and IF count is 1, get message info.
112: FND_MSG_PUB.Count_And_Get
113: ( p_count => x_msg_count,
114: p_data => x_msg_data );
115:

Line 174: -- Standard call to get message count and IF count is 1, get message info.

170: END IF;
171: END IF;
172: CLOSE C_Get_Meaning;
173: END IF;
174: -- Standard call to get message count and IF count is 1, get message info.
175: FND_MSG_PUB.Count_And_Get
176: ( p_count => x_msg_count,
177: p_data => x_msg_data );
178:

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

266: CLOSE C_Get_Rating;
267:
268: END IF;
269:
270: -- Standard call to get message count and if count is 1, get message info.
271: FND_MSG_PUB.Count_And_Get
272: ( p_count => x_msg_count,
273: p_data => x_msg_data
274: );

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

363:
364: END IF;
365:
366:
367: -- Standard call to get message count and if count is 1, get message info.
368: FND_MSG_PUB.Count_And_Get
369: ( p_count => x_msg_count,
370: p_data => x_msg_data
371: );

Line 411: -- Standard start of API savepoint

407: SELECT MAX(MIN_SCORE) FROM AS_SALES_LEAD_RANKS_B;
408:
409:
410: BEGIN
411: -- Standard start of API savepoint
412: SAVEPOINT Create_Rank_PVT;
413:
414: -- Standard call to check for call compatibility
415: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

Line 414: -- Standard call to check for call compatibility

410: BEGIN
411: -- Standard start of API savepoint
412: SAVEPOINT Create_Rank_PVT;
413:
414: -- Standard call to check for call compatibility
415: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
416: l_api_name, G_PKG_NAME)
417: THEN
418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 551: -- Standard check of p_commit

547: --dbms_output.put_line('private API returns ' || x_return_status);
548:
549: -- End of API body
550:
551: -- Standard check of p_commit
552: IF FND_API.To_Boolean(p_commit) THEN
553: COMMIT WORK;
554: END IF;
555:

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

552: IF FND_API.To_Boolean(p_commit) THEN
553: COMMIT WORK;
554: END IF;
555:
556: -- Standard call to get message count and if count is 1, get message info
557: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
558:
559: EXCEPTION
560:

Line 621: -- Standard start of API savepoint

617: WHERE rank_id = p_sales_lead_rank_rec.RANK_ID;
618: l_last_update_date DATE;
619:
620: BEGIN
621: -- Standard start of API savepoint
622: SAVEPOINT Update_Rank_PVT;
623:
624: -- Standard call to check for call compatibility
625: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

Line 624: -- Standard call to check for call compatibility

620: BEGIN
621: -- Standard start of API savepoint
622: SAVEPOINT Update_Rank_PVT;
623:
624: -- Standard call to check for call compatibility
625: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
626: l_api_name, G_PKG_NAME)
627: THEN
628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 806: -- Standard check of p_commit

802:
803: END IF;
804: -- End of API body
805:
806: -- Standard check of p_commit
807: IF FND_API.To_Boolean(p_commit) THEN
808: COMMIT WORK;
809: END IF;
810:

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

807: IF FND_API.To_Boolean(p_commit) THEN
808: COMMIT WORK;
809: END IF;
810:
811: -- Standard call to get message count and if count is 1, get message info
812: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
813:
814: EXCEPTION
815: WHEN FND_API.G_EXC_ERROR THEN

Line 877: -- Standard start of API savepoint

873: SELECT 'X' FROM AS_SALES_LEAD_RANKS_B
874: WHERE rank_id = p_sales_lead_rank_id;
875:
876: BEGIN
877: -- Standard start of API savepoint
878: SAVEPOINT Delete_Rank_PVT;
879:
880: -- Standard call to check for call compatibility
881: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

Line 880: -- Standard call to check for call compatibility

876: BEGIN
877: -- Standard start of API savepoint
878: SAVEPOINT Delete_Rank_PVT;
879:
880: -- Standard call to check for call compatibility
881: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
882: l_api_name, G_PKG_NAME)
883: THEN
884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 984: -- Standard check of p_commit

980:
981:
982:
983:
984: -- Standard check of p_commit
985: IF FND_API.To_Boolean(p_commit) THEN
986: COMMIT WORK;
987: END IF;
988:

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

985: IF FND_API.To_Boolean(p_commit) THEN
986: COMMIT WORK;
987: END IF;
988:
989: -- Standard call to get message count and if count is 1, get message info
990: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
991:
992: EXCEPTION
993: WHEN FND_API.G_EXC_ERROR THEN