117: l_org_id NUMBER;
118: l_status VARCHAR2(1);
119:
120: BEGIN
121: -- Standard Start of API savepoint
122: SAVEPOINT Create_Quota_Assign_Pub;
123: -- Standard call to check for call compatibility.
124: IF NOT FND_API.Compatible_API_Call
125: (l_api_version ,
119:
120: BEGIN
121: -- Standard Start of API savepoint
122: SAVEPOINT Create_Quota_Assign_Pub;
123: -- Standard call to check for call compatibility.
124: IF NOT FND_API.Compatible_API_Call
125: (l_api_version ,
126: p_api_version ,
127: l_api_name ,
185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
186: end if;
187:
188: -- End of API body.
189: -- Standard check of p_commit.
190: IF FND_API.To_Boolean( p_commit ) THEN
191: COMMIT WORK;
192: END IF;
193: -- Standard call to get message count and if count is 1, get message info.
189: -- Standard check of p_commit.
190: IF FND_API.To_Boolean( p_commit ) THEN
191: COMMIT WORK;
192: END IF;
193: -- Standard call to get message count and if count is 1, get message info.
194: FND_MSG_PUB.Count_And_Get
195: (p_count => x_msg_count ,
196: p_data => x_msg_data ,
197: p_encoded => FND_API.G_FALSE );
283: old_org_id NUMBER;
284: old_quota_id NUMBER;
285:
286: BEGIN
287: -- Standard Start of API savepoint
288: SAVEPOINT Update_Quota_Assign_Pub;
289: -- Standard call to check for call compatibility.
290: IF NOT FND_API.Compatible_API_Call
291: (l_api_version ,
285:
286: BEGIN
287: -- Standard Start of API savepoint
288: SAVEPOINT Update_Quota_Assign_Pub;
289: -- Standard call to check for call compatibility.
290: IF NOT FND_API.Compatible_API_Call
291: (l_api_version ,
292: p_api_version ,
293: l_api_name ,
406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
407: end if;
408:
409: -- End of API body.
410: -- Standard check of p_commit.
411: IF FND_API.To_Boolean( p_commit ) THEN
412: COMMIT WORK;
413: END IF;
414: -- Standard call to get message count and if count is 1, get message info.
410: -- Standard check of p_commit.
411: IF FND_API.To_Boolean( p_commit ) THEN
412: COMMIT WORK;
413: END IF;
414: -- Standard call to get message count and if count is 1, get message info.
415: FND_MSG_PUB.Count_And_Get
416: (p_count => x_msg_count ,
417: p_data => x_msg_data ,
418: p_encoded => FND_API.G_FALSE );
502: l_status VARCHAR2(1);
503: old_org_id NUMBER;
504:
505: BEGIN
506: -- Standard Start of API savepoint
507: SAVEPOINT Delete_Quota_Assign_Pub;
508: -- Standard call to check for call compatibility.
509: IF NOT FND_API.Compatible_API_Call
510: (l_api_version ,
504:
505: BEGIN
506: -- Standard Start of API savepoint
507: SAVEPOINT Delete_Quota_Assign_Pub;
508: -- Standard call to check for call compatibility.
509: IF NOT FND_API.Compatible_API_Call
510: (l_api_version ,
511: p_api_version ,
512: l_api_name ,
601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
602: end if;
603:
604: -- End of API body.
605: -- Standard check of p_commit.
606: IF FND_API.To_Boolean( p_commit ) THEN
607: COMMIT WORK;
608: END IF;
609: -- Standard call to get message count and if count is 1, get message info.
605: -- Standard check of p_commit.
606: IF FND_API.To_Boolean( p_commit ) THEN
607: COMMIT WORK;
608: END IF;
609: -- Standard call to get message count and if count is 1, get message info.
610: FND_MSG_PUB.Count_And_Get
611: (p_count => x_msg_count ,
612: p_data => x_msg_data ,
613: p_encoded => FND_API.G_FALSE );