[Home] [Help]
48: l_msg_count NUMBER;
49: l_msg_data VARCHAR2(32767);
50:
51: BEGIN
52: -- Standard Start of API savepoint
53: SAVEPOINT CREATE_SCORECARD_PUB;
54:
55: -- Standard call to check for call compatibility.
56: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
51: BEGIN
52: -- Standard Start of API savepoint
53: SAVEPOINT CREATE_SCORECARD_PUB;
54:
55: -- Standard call to check for call compatibility.
56: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
57: p_api_version,
58: l_api_name,
59: G_PKG_NAME)
109: --
110: -- End of API body
111: --
112:
113: -- Standard check for p_commit
114: IF FND_API.to_Boolean( p_commit )
115: THEN
116: COMMIT WORK;
117: END IF;
121: 'PUB: ' || l_api_name || ' end');
122: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
123: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
124:
125: -- Standard call to get message count and if count is 1, get message info.
126: FND_MSG_PUB.Count_And_Get
127: ( p_count => x_msg_count,
128: p_data => x_msg_data
129: );
182: l_msg_data VARCHAR2(32767);
183:
184: BEGIN
185:
186: -- Standard Start of API savepoint
187: SAVEPOINT UPDATE_SCORECARD_PUB;
188:
189: -- Standard call to check for call compatibility.
190: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
185:
186: -- Standard Start of API savepoint
187: SAVEPOINT UPDATE_SCORECARD_PUB;
188:
189: -- Standard call to check for call compatibility.
190: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
191: p_api_version,
192: l_api_name,
193: G_PKG_NAME)
239: --
240: -- End of API body.
241: --
242:
243: -- Standard check for p_commit
244: IF FND_API.to_Boolean( p_commit )
245: THEN
246: COMMIT WORK;
247: END IF;
251: 'PUB: ' || l_api_name || ' end');
252: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
253: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
254:
255: -- Standard call to get message count and if count is 1, get message info.
256: FND_MSG_PUB.Count_And_Get
257: ( p_count => x_msg_count,
258: p_data => x_msg_data );
259:
310: l_msg_data VARCHAR2(32767);
311: l_scorecard_id NUMBER := P_scorecard_id;
312:
313: BEGIN
314: -- Standard Start of API savepoint
315: SAVEPOINT DELETE_SCORECARD_PUB;
316:
317: -- Standard call to check for call compatibility.
318: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
313: BEGIN
314: -- Standard Start of API savepoint
315: SAVEPOINT DELETE_SCORECARD_PUB;
316:
317: -- Standard call to check for call compatibility.
318: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
319: p_api_version,
320: l_api_name,
321: G_PKG_NAME)
368: --
369: -- End of API body
370: --
371:
372: -- Standard check for p_commit
373: IF FND_API.to_Boolean( p_commit )
374: THEN
375: COMMIT WORK;
376: END IF;
436: l_msg_count NUMBER;
437: l_msg_data VARCHAR2(32767);
438:
439: BEGIN
440: -- Standard Start of API savepoint
441: SAVEPOINT CREATE_CARD_RULE_PUB;
442:
443: -- Standard call to check for call compatibility.
444: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
439: BEGIN
440: -- Standard Start of API savepoint
441: SAVEPOINT CREATE_CARD_RULE_PUB;
442:
443: -- Standard call to check for call compatibility.
444: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
445: p_api_version,
446: l_api_name,
447: G_PKG_NAME)
495: --
496: -- End of API body
497: --
498:
499: -- Standard check for p_commit
500: IF FND_API.to_Boolean( p_commit )
501: THEN
502: COMMIT WORK;
503: END IF;
507: 'PUB: ' || l_api_name || ' end');
508: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
509: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
510:
511: -- Standard call to get message count and if count is 1, get message info.
512: FND_MSG_PUB.Count_And_Get
513: ( p_count => x_msg_count,
514: p_data => x_msg_data
515: );
566: l_msg_data VARCHAR2(32767);
567:
568: BEGIN
569:
570: -- Standard Start of API savepoint
571: SAVEPOINT UPDATE_CARDRULE_QUAL_PUB;
572:
573: -- Standard call to check for call compatibility.
574: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
569:
570: -- Standard Start of API savepoint
571: SAVEPOINT UPDATE_CARDRULE_QUAL_PUB;
572:
573: -- Standard call to check for call compatibility.
574: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
575: p_api_version,
576: l_api_name,
577: G_PKG_NAME)
624: --
625: -- End of API body.
626: --
627:
628: -- Standard check for p_commit
629: IF FND_API.to_Boolean( p_commit )
630: THEN
631: COMMIT WORK;
632: END IF;
636: 'PUB: ' || l_api_name || ' end');
637: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
638: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
639:
640: -- Standard call to get message count and if count is 1, get message info.
641: FND_MSG_PUB.Count_And_Get
642: ( p_count => x_msg_count,
643: p_data => x_msg_data );
644:
693: l_msg_count NUMBER;
694: l_msg_data VARCHAR2(32767);
695:
696: BEGIN
697: -- Standard Start of API savepoint
698: SAVEPOINT DELETE_CARD_RULE_PUB;
699:
700: -- Standard call to check for call compatibility.
701: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
696: BEGIN
697: -- Standard Start of API savepoint
698: SAVEPOINT DELETE_CARD_RULE_PUB;
699:
700: -- Standard call to check for call compatibility.
701: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
702: p_api_version,
703: l_api_name,
704: G_PKG_NAME)
749: --
750: -- End of API body
751: --
752:
753: -- Standard check for p_commit
754: IF FND_API.to_Boolean( p_commit )
755: THEN
756: COMMIT WORK;
757: END IF;