DBA Data[Home] [Help]

APPS.CSD_FLWSTS_TRAN_RESPS_PVT dependencies on STANDARD

Line 47: -- Standard Start of API savepoint

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,

Line 50: -- Standard call to check for call compatibility.

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 )

Line 122: -- Standard check of p_commit.

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:

Line 127: -- Standard call to get message count and IF count is get message info.

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:

Line 266: -- Standard Start of API savepoint

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,

Line 269: -- Standard call to check for call compatibility.

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 )

Line 345: -- Standard check of p_commit.

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:

Line 350: -- Standard call to get message count and IF count is get message info.

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:

Line 477: -- Standard Start of API savepoint

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,

Line 480: -- Standard call to check for call compatibility.

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 )

Line 537: -- Standard check of p_commit.

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:

Line 542: -- Standard call to get message count and IF count is get message info.

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:

Line 657: -- Standard Start of API savepoint

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,

Line 660: -- Standard call to check for call compatibility.

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 )

Line 725: -- Standard check of p_commit.

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:

Line 730: -- Standard call to get message count and IF count is get message info.

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: