43: -- SQLCODE = -00001 and name it as 'UNIQUE_CONSTRAINT_VIOLATED'.
44: PRAGMA EXCEPTION_INIT( UNIQUE_CONSTRAINT_VIOLATED, -00001 );
45:
46: BEGIN
47: -- Standard Start of API savepoint
48: SAVEPOINT Create_Rt_Tran_Resp;
49:
50: -- Standard call to check for call compatibility.
51: IF NOT FND_API.Compatible_API_Call (lc_api_version,
46: BEGIN
47: -- Standard Start of API savepoint
48: SAVEPOINT Create_Rt_Tran_Resp;
49:
50: -- Standard call to check for call compatibility.
51: IF NOT FND_API.Compatible_API_Call (lc_api_version,
52: p_api_version,
53: lc_api_name ,
54: G_PKG_NAME )
119: end if;
120:
121: -- Api body ends here
122:
123: -- Standard check of p_commit.
124: IF FND_API.To_Boolean( p_commit ) THEN
125: COMMIT WORK;
126: END IF;
127:
124: IF FND_API.To_Boolean( p_commit ) THEN
125: COMMIT WORK;
126: END IF;
127:
128: -- Standard call to get message count and IF count is get message info.
129: FND_MSG_PUB.Count_And_Get
130: (p_count => x_msg_count,
131: p_data => x_msg_data );
132:
263: -- SQLCODE = -00001 and name it as 'UNIQUE_CONSTRAINT_VIOLATED'.
264: PRAGMA EXCEPTION_INIT( UNIQUE_CONSTRAINT_VIOLATED, -00001 );
265:
266: BEGIN
267: -- Standard Start of API savepoint
268: SAVEPOINT Update_Rt_Tran_Resp;
269:
270: -- Standard call to check for call compatibility.
271: IF NOT FND_API.Compatible_API_Call (lc_api_version,
266: BEGIN
267: -- Standard Start of API savepoint
268: SAVEPOINT Update_Rt_Tran_Resp;
269:
270: -- Standard call to check for call compatibility.
271: IF NOT FND_API.Compatible_API_Call (lc_api_version,
272: p_api_version,
273: lc_api_name ,
274: G_PKG_NAME )
342: end if;
343:
344: -- Api body ends here
345:
346: -- Standard check of p_commit.
347: IF FND_API.To_Boolean( p_commit ) THEN
348: COMMIT WORK;
349: END IF;
350:
347: IF FND_API.To_Boolean( p_commit ) THEN
348: COMMIT WORK;
349: END IF;
350:
351: -- Standard call to get message count and IF count is get message info.
352: FND_MSG_PUB.Count_And_Get
353: (p_count => x_msg_count,
354: p_data => x_msg_data );
355:
474: l_msg_data VARCHAR2(100);
475: l_msg_index NUMBER;
476:
477: BEGIN
478: -- Standard Start of API savepoint
479: SAVEPOINT Delete_Rt_Tran_Resp;
480:
481: -- Standard call to check for call compatibility.
482: IF NOT FND_API.Compatible_API_Call (lc_api_version,
477: BEGIN
478: -- Standard Start of API savepoint
479: SAVEPOINT Delete_Rt_Tran_Resp;
480:
481: -- Standard call to check for call compatibility.
482: IF NOT FND_API.Compatible_API_Call (lc_api_version,
483: p_api_version,
484: lc_api_name ,
485: G_PKG_NAME )
534: end if;
535:
536: -- Api body ends here
537:
538: -- Standard check of p_commit.
539: IF FND_API.To_Boolean( p_commit ) THEN
540: COMMIT WORK;
541: END IF;
542:
539: IF FND_API.To_Boolean( p_commit ) THEN
540: COMMIT WORK;
541: END IF;
542:
543: -- Standard call to get message count and IF count is get message info.
544: FND_MSG_PUB.Count_And_Get
545: (p_count => x_msg_count,
546: p_data => x_msg_data );
547:
654: l_msg_index NUMBER;
655: l_rowid ROWID;
656:
657: BEGIN
658: -- Standard Start of API savepoint
659: SAVEPOINT Lock_Rt_Tran_Resp;
660:
661: -- Standard call to check for call compatibility.
662: IF NOT FND_API.Compatible_API_Call (lc_api_version,
657: BEGIN
658: -- Standard Start of API savepoint
659: SAVEPOINT Lock_Rt_Tran_Resp;
660:
661: -- Standard call to check for call compatibility.
662: IF NOT FND_API.Compatible_API_Call (lc_api_version,
663: p_api_version,
664: lc_api_name ,
665: G_PKG_NAME )
722: end if;
723:
724: -- Api body ends here
725:
726: -- Standard check of p_commit.
727: IF FND_API.To_Boolean( p_commit ) THEN
728: COMMIT WORK;
729: END IF;
730:
727: IF FND_API.To_Boolean( p_commit ) THEN
728: COMMIT WORK;
729: END IF;
730:
731: -- Standard call to get message count and IF count is get message info.
732: FND_MSG_PUB.Count_And_Get
733: (p_count => x_msg_count,
734: p_data => x_msg_data );
735: