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;
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;
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 )
128: end if;
129:
130: -- Api body ends here
131:
132: -- Standard check of p_commit.
133: IF FND_API.To_Boolean( p_commit ) THEN
134: COMMIT WORK;
135: END IF;
136:
133: IF FND_API.To_Boolean( p_commit ) THEN
134: COMMIT WORK;
135: END IF;
136:
137: -- Standard call to get message count and IF count is get message info.
138: FND_MSG_PUB.Count_And_Get
139: (p_count => x_msg_count,
140: p_data => x_msg_data );
141:
272: -- SQLCODE = -00001 and name it as 'UNIQUE_CONSTRAINT_VIOLATED'.
273: PRAGMA EXCEPTION_INIT( UNIQUE_CONSTRAINT_VIOLATED, -00001 );
274:
275: BEGIN
276: -- Standard Start of API savepoint
277: SAVEPOINT Update_Rt_Tran;
278:
279: -- Standard call to check for call compatibility.
280: IF NOT FND_API.Compatible_API_Call (lc_api_version,
275: BEGIN
276: -- Standard Start of API savepoint
277: SAVEPOINT Update_Rt_Tran;
278:
279: -- Standard call to check for call compatibility.
280: IF NOT FND_API.Compatible_API_Call (lc_api_version,
281: p_api_version,
282: lc_api_name ,
283: G_PKG_NAME )
361: end if;
362:
363: -- Api body ends here
364:
365: -- Standard check of p_commit.
366: IF FND_API.To_Boolean( p_commit ) THEN
367: COMMIT WORK;
368: END IF;
369:
366: IF FND_API.To_Boolean( p_commit ) THEN
367: COMMIT WORK;
368: END IF;
369:
370: -- Standard call to get message count and IF count is get message info.
371: FND_MSG_PUB.Count_And_Get
372: (p_count => x_msg_count,
373: p_data => x_msg_data );
374:
493: l_msg_data VARCHAR2(100);
494: l_msg_index NUMBER;
495:
496: BEGIN
497: -- Standard Start of API savepoint
498: SAVEPOINT Delete_Rt_Tran;
499:
500: -- Standard call to check for call compatibility.
501: IF NOT FND_API.Compatible_API_Call (lc_api_version,
496: BEGIN
497: -- Standard Start of API savepoint
498: SAVEPOINT Delete_Rt_Tran;
499:
500: -- Standard call to check for call compatibility.
501: IF NOT FND_API.Compatible_API_Call (lc_api_version,
502: p_api_version,
503: lc_api_name ,
504: G_PKG_NAME )
553: end if;
554:
555: -- Api body ends here
556:
557: -- Standard check of p_commit.
558: IF FND_API.To_Boolean( p_commit ) THEN
559: COMMIT WORK;
560: END IF;
561:
558: IF FND_API.To_Boolean( p_commit ) THEN
559: COMMIT WORK;
560: END IF;
561:
562: -- Standard call to get message count and IF count is get message info.
563: FND_MSG_PUB.Count_And_Get
564: (p_count => x_msg_count,
565: p_data => x_msg_data );
566:
673: l_msg_index NUMBER;
674: l_rowid ROWID;
675:
676: BEGIN
677: -- Standard Start of API savepoint
678: SAVEPOINT Lock_Rt_Tran;
679:
680: -- Standard call to check for call compatibility.
681: IF NOT FND_API.Compatible_API_Call (lc_api_version,
676: BEGIN
677: -- Standard Start of API savepoint
678: SAVEPOINT Lock_Rt_Tran;
679:
680: -- Standard call to check for call compatibility.
681: IF NOT FND_API.Compatible_API_Call (lc_api_version,
682: p_api_version,
683: lc_api_name ,
684: G_PKG_NAME )
741: end if;
742:
743: -- Api body ends here
744:
745: -- Standard check of p_commit.
746: IF FND_API.To_Boolean( p_commit ) THEN
747: COMMIT WORK;
748: END IF;
749:
746: IF FND_API.To_Boolean( p_commit ) THEN
747: COMMIT WORK;
748: END IF;
749:
750: -- Standard call to get message count and IF count is get message info.
751: FND_MSG_PUB.Count_And_Get
752: (p_count => x_msg_count,
753: p_data => x_msg_data );
754: