DBA Data[Home] [Help]

APPS.CN_SEASONALITIES_PVT dependencies on STANDARD

Line 57: -- Standard Start of API savepoint

53: l_msg_data VARCHAR2(2000);
54:
55: BEGIN
56: --DBMS_OUTPUT.PUT_LINE('Update in progress');
57: -- Standard Start of API savepoint
58: SAVEPOINT Update_Seasonalities;
59: -- Standard call to check for call compatibility.
60: IF NOT FND_API.compatible_api_call
61: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )

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

55: BEGIN
56: --DBMS_OUTPUT.PUT_LINE('Update in progress');
57: -- Standard Start of API savepoint
58: SAVEPOINT Update_Seasonalities;
59: -- Standard call to check for call compatibility.
60: IF NOT FND_API.compatible_api_call
61: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
62: THEN
63: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 121: -- Standard check of p_commit.

117: -- End of API body.
118: << end_Update_Seasonalities >>
119: NULL;
120:
121: -- Standard check of p_commit.
122: IF FND_API.To_Boolean( p_commit ) THEN
123: COMMIT WORK;
124: END IF;
125: -- Standard call to get message count and if count is 1, get message info.

Line 125: -- Standard call to get message count and if count is 1, get message info.

121: -- Standard check of p_commit.
122: IF FND_API.To_Boolean( p_commit ) THEN
123: COMMIT WORK;
124: END IF;
125: -- Standard call to get message count and if count is 1, get message info.
126: FND_MSG_PUB.Count_And_Get
127: (
128: p_count => x_msg_count ,
129: p_data => x_msg_data ,

Line 231: -- Standard Start of API savepoint

227: SELECT PCT_SEASONALITY FROM CN_SEASONALITIES
228: WHERE seas_schedule_id = p_seas_sch_id;
229: BEGIN
230: --DBMS_OUTPUT.PUT_LINE('Delete in progress');
231: -- Standard Start of API savepoint
232: SAVEPOINT Validate_Seasonalities;
233: -- Standard call to check for call compatibility.
234: IF NOT FND_API.compatible_api_call
235: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )

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

229: BEGIN
230: --DBMS_OUTPUT.PUT_LINE('Delete in progress');
231: -- Standard Start of API savepoint
232: SAVEPOINT Validate_Seasonalities;
233: -- Standard call to check for call compatibility.
234: IF NOT FND_API.compatible_api_call
235: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
236: THEN
237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 285: -- Standard check of p_commit.

281: -- End of API body.
282: << end_Validate_Seasonalities >>
283: NULL;
284:
285: -- Standard check of p_commit.
286: IF FND_API.To_Boolean( p_commit ) THEN
287: COMMIT WORK;
288: END IF;
289: -- Standard call to get message count and if count is 1, get message info.

Line 289: -- Standard call to get message count and if count is 1, get message info.

285: -- Standard check of p_commit.
286: IF FND_API.To_Boolean( p_commit ) THEN
287: COMMIT WORK;
288: END IF;
289: -- Standard call to get message count and if count is 1, get message info.
290: FND_MSG_PUB.Count_And_Get
291: (
292: p_count => x_msg_count ,
293: p_data => x_msg_data ,