[Home] [Help]
26: l_msg_count NUMBER;
27: l_msg_data VARCHAR2(32767);
28:
29: BEGIN
30: -- Standard Start of API savepoint
31: SAVEPOINT Create_Status_Rule_PUB;
32:
33: -- Standard call to check for call compatibility.
34: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
29: BEGIN
30: -- Standard Start of API savepoint
31: SAVEPOINT Create_Status_Rule_PUB;
32:
33: -- Standard call to check for call compatibility.
34: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
35: p_api_version,
36: l_api_name,
37: G_PKG_NAME)
81: --
82: -- End of API body
83: --
84:
85: -- Standard check for p_commit
86: IF FND_API.to_Boolean( p_commit )
87: THEN
88: COMMIT WORK;
89: END IF;
92: IEX_DEBUG_PUB.LogMessage('PUB: ' || l_api_name || ' end');
93: IEX_DEBUG_PUB.LogMessage('End time:'
94: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
95:
96: -- Standard call to get message count and if count is 1, get message info.
97: FND_MSG_PUB.Count_And_Get
98: ( p_count => x_msg_count,
99: p_data => x_msg_data
100: );
177: l_status_rule_rec iex_status_rule_pub.status_rule_rec_type;
178:
179: BEGIN
180:
181: -- Standard Start of API savepoint
182: SAVEPOINT Update_Status_Rule_PUB;
183:
184: -- Standard call to check for call compatibility.
185: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
180:
181: -- Standard Start of API savepoint
182: SAVEPOINT Update_Status_Rule_PUB;
183:
184: -- Standard call to check for call compatibility.
185: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
186: p_api_version,
187: l_api_name,
188: G_PKG_NAME)
236: --
237: -- End of API body.
238: --
239:
240: -- Standard check for p_commit
241: IF FND_API.to_Boolean( p_commit )
242: THEN
243: COMMIT WORK;
244: END IF;
247: IEX_DEBUG_PUB.LogMessage('PUB: ' || l_api_name || ' end');
248: IEX_DEBUG_PUB.LogMessage('End time:'
249: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
250:
251: -- Standard call to get message count and if count is 1, get message info.
252: FND_MSG_PUB.Count_And_Get
253: ( p_count => x_msg_count,
254: p_data => x_msg_data );
255:
330: l_msg_count NUMBER;
331: l_msg_data VARCHAR2(32767);
332:
333: BEGIN
334: -- Standard Start of API savepoint
335: SAVEPOINT Delete_Status_Rule_PUB;
336:
337: -- Standard call to check for call compatibility.
338: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
333: BEGIN
334: -- Standard Start of API savepoint
335: SAVEPOINT Delete_Status_Rule_PUB;
336:
337: -- Standard call to check for call compatibility.
338: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
339: p_api_version,
340: l_api_name,
341: G_PKG_NAME)
388: --
389: -- End of API body
390: --
391:
392: -- Standard check for p_commit
393: IF FND_API.to_Boolean( p_commit )
394: THEN
395: COMMIT WORK;
396: END IF;
479: x_status_rule_line_id NUMBER;
480:
481:
482: BEGIN
483: -- Standard Start of API savepoint
484: SAVEPOINT Create_Status_Rule_Line_PUB;
485:
486: -- Standard call to check for call compatibility.
487: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
482: BEGIN
483: -- Standard Start of API savepoint
484: SAVEPOINT Create_Status_Rule_Line_PUB;
485:
486: -- Standard call to check for call compatibility.
487: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
488: p_api_version,
489: l_api_name,
490: G_PKG_NAME)
534: --
535: -- End of API body
536: --
537:
538: -- Standard check for p_commit
539: IF FND_API.to_Boolean( p_commit )
540: THEN
541: COMMIT WORK;
542: END IF;
545: IEX_DEBUG_PUB.LogMessage('PUB: ' || l_api_name || ' end');
546: IEX_DEBUG_PUB.LogMessage('End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
547:
548:
549: -- Standard call to get message count and if count is 1, get message info.
550: FND_MSG_PUB.Count_And_Get
551: ( p_count => x_msg_count,
552: p_data => x_msg_data
553: );
600: l_status_rule_line_REC iex_status_rule_pub.status_rule_line_rec_type;
601:
602: BEGIN
603:
604: -- Standard Start of API savepoint
605: SAVEPOINT Update_Status_Rule_Line_PUB;
606:
607: -- Standard call to check for call compatibility.
608: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
603:
604: -- Standard Start of API savepoint
605: SAVEPOINT Update_Status_Rule_Line_PUB;
606:
607: -- Standard call to check for call compatibility.
608: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
609: p_api_version,
610: l_api_name,
611: G_PKG_NAME)
656: --
657: -- End of API body.
658: --
659:
660: -- Standard check for p_commit
661: IF FND_API.to_Boolean( p_commit )
662: THEN
663: COMMIT WORK;
664: END IF;
667: IEX_DEBUG_PUB.LogMessage('PUB: ' || l_api_name || ' end');
668: IEX_DEBUG_PUB.LogMessage('End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
669:
670:
671: -- Standard call to get message count and if count is 1, get message info.
672: FND_MSG_PUB.Count_And_Get
673: ( p_count => x_msg_count,
674: p_data => x_msg_data );
675:
720: l_msg_data VARCHAR2(32767);
721: l_status_rule_line_id NUMBER;
722:
723: BEGIN
724: -- Standard Start of API savepoint
725: SAVEPOINT Delete_Status_Rule_Line_PUB;
726:
727: -- Standard call to check for call compatibility.
728: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
723: BEGIN
724: -- Standard Start of API savepoint
725: SAVEPOINT Delete_Status_Rule_Line_PUB;
726:
727: -- Standard call to check for call compatibility.
728: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
729: p_api_version,
730: l_api_name,
731: G_PKG_NAME)
777: --
778: -- End of API body
779: --
780:
781: -- Standard check for p_commit
782: IF FND_API.to_Boolean( p_commit )
783: THEN
784: COMMIT WORK;
785: END IF;