117:
118:
119: --
120: --
121: -- Standard check of p_commit.
122:
123: if FND_API.to_Boolean (p_commit) then
124: commit work;
125: end if;
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 1, get message info.
128:
129: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
130: p_data => p_msg_data);
131: --
307: close c;
308: --
309: --p_position_assignment_id := l_pos_assignment_id ;
310: --
311: -- Standard check of p_commit.
312: if FND_API.to_Boolean (p_commit) then
313: commit work;
314: end if;
315: -- Standard call to get message count and if count is 1, get message info.
311: -- Standard check of p_commit.
312: if FND_API.to_Boolean (p_commit) then
313: commit work;
314: end if;
315: -- Standard call to get message count and if count is 1, get message info.
316: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
317: p_data => p_msg_data);
318: --
319: EXCEPTION
565: if (sql%notfound) THEN
566: null;
567: end if;
568:
569: -- Standard check of p_commit.
570: --
571: if FND_API.to_Boolean (p_commit) then
572: commit work;
573: end if;
571: if FND_API.to_Boolean (p_commit) then
572: commit work;
573: end if;
574:
575: -- Standard call to get message count and if count is 1, get message info.
576:
577: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
578: p_data => p_msg_data);
579: --