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_Flwsts_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_Flwsts_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 )
118: end if;
119:
120: -- Api body ends here
121:
122: -- Standard check of p_commit.
123: IF FND_API.To_Boolean( p_commit ) THEN
124: COMMIT WORK;
125: END IF;
126:
123: IF FND_API.To_Boolean( p_commit ) THEN
124: COMMIT WORK;
125: END IF;
126:
127: -- Standard call to get message count and IF count is get message info.
128: FND_MSG_PUB.Count_And_Get
129: (p_count => x_msg_count,
130: p_data => x_msg_data );
131:
262: -- SQLCODE = -00001 and name it as 'UNIQUE_CONSTRAINT_VIOLATED'.
263: PRAGMA EXCEPTION_INIT( UNIQUE_CONSTRAINT_VIOLATED, -00001 );
264:
265: BEGIN
266: -- Standard Start of API savepoint
267: SAVEPOINT Update_Flwsts_Tran_Resp;
268:
269: -- Standard call to check for call compatibility.
270: IF NOT FND_API.Compatible_API_Call (lc_api_version,
265: BEGIN
266: -- Standard Start of API savepoint
267: SAVEPOINT Update_Flwsts_Tran_Resp;
268:
269: -- Standard call to check for call compatibility.
270: IF NOT FND_API.Compatible_API_Call (lc_api_version,
271: p_api_version,
272: lc_api_name ,
273: G_PKG_NAME )
341: end if;
342:
343: -- Api body ends here
344:
345: -- Standard check of p_commit.
346: IF FND_API.To_Boolean( p_commit ) THEN
347: COMMIT WORK;
348: END IF;
349:
346: IF FND_API.To_Boolean( p_commit ) THEN
347: COMMIT WORK;
348: END IF;
349:
350: -- Standard call to get message count and IF count is get message info.
351: FND_MSG_PUB.Count_And_Get
352: (p_count => x_msg_count,
353: p_data => x_msg_data );
354:
473: l_msg_data VARCHAR2(100);
474: l_msg_index NUMBER;
475:
476: BEGIN
477: -- Standard Start of API savepoint
478: SAVEPOINT Delete_Flwsts_Tran_Resp;
479:
480: -- Standard call to check for call compatibility.
481: IF NOT FND_API.Compatible_API_Call (lc_api_version,
476: BEGIN
477: -- Standard Start of API savepoint
478: SAVEPOINT Delete_Flwsts_Tran_Resp;
479:
480: -- Standard call to check for call compatibility.
481: IF NOT FND_API.Compatible_API_Call (lc_api_version,
482: p_api_version,
483: lc_api_name ,
484: G_PKG_NAME )
533: end if;
534:
535: -- Api body ends here
536:
537: -- Standard check of p_commit.
538: IF FND_API.To_Boolean( p_commit ) THEN
539: COMMIT WORK;
540: END IF;
541:
538: IF FND_API.To_Boolean( p_commit ) THEN
539: COMMIT WORK;
540: END IF;
541:
542: -- Standard call to get message count and IF count is get message info.
543: FND_MSG_PUB.Count_And_Get
544: (p_count => x_msg_count,
545: p_data => x_msg_data );
546:
653: l_msg_index NUMBER;
654: l_rowid ROWID;
655:
656: BEGIN
657: -- Standard Start of API savepoint
658: SAVEPOINT Lock_Flwsts_Tran_Resp;
659:
660: -- Standard call to check for call compatibility.
661: IF NOT FND_API.Compatible_API_Call (lc_api_version,
656: BEGIN
657: -- Standard Start of API savepoint
658: SAVEPOINT Lock_Flwsts_Tran_Resp;
659:
660: -- Standard call to check for call compatibility.
661: IF NOT FND_API.Compatible_API_Call (lc_api_version,
662: p_api_version,
663: lc_api_name ,
664: G_PKG_NAME )
721: end if;
722:
723: -- Api body ends here
724:
725: -- Standard check of p_commit.
726: IF FND_API.To_Boolean( p_commit ) THEN
727: COMMIT WORK;
728: END IF;
729:
726: IF FND_API.To_Boolean( p_commit ) THEN
727: COMMIT WORK;
728: END IF;
729:
730: -- Standard call to get message count and IF count is get message info.
731: FND_MSG_PUB.Count_And_Get
732: (p_count => x_msg_count,
733: p_data => x_msg_data );
734: