222: ROLLBACK TO REASSIGN_STRATEGY_PUB;
223: RETURN;
224: END if; --l_status =cancelled
225:
226: -- Standard check of p_commit
227: IF FND_API.To_Boolean(p_commit) THEN
228: COMMIT WORK;
229: END IF;
230:
373: iex_debug_pub.logmessage('SQLCODE: '|| SQLCODE);
374: iex_debug_pub.logmessage('SQLERRM: '|| SQLERRM);
375: END;
376:
377: -- Standard check of p_commit
378: IF FND_API.To_Boolean(p_commit) THEN
379: COMMIT WORK;
380: END IF;
381:
491: end if;
492: */
493: END IF; --if status is successful
494:
495: -- Standard check of p_commit
496: IF FND_API.To_Boolean(p_commit) THEN
497: COMMIT WORK;
498: END IF;
499:
628: */
629: END IF ; -- p_status in 'closed' or cancelled'
630: END IF; --if status is successful
631:
632: -- Standard check of p_commit
633: IF FND_API.To_Boolean(p_commit) THEN
634: COMMIT WORK;
635: END IF;
636:
855: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
856: IEX_DEBUG_PUB.logmessage('UPDATE_WORKITEM: ' || 'Status of work item update ' ||l_return_status);
857: END IF;
858:
859: -- Standard check of p_commit
860: IF FND_API.To_Boolean(p_commit) THEN
861: COMMIT WORK;
862: END IF;
863:
911: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
912: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': start');
913: END IF;
914:
915: -- Standard start of API savepoint
916: SAVEPOINT SHOW_IN_UWQ_PVT;
917:
918: -- Standard call to check for call compatibility
919: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
914:
915: -- Standard start of API savepoint
916: SAVEPOINT SHOW_IN_UWQ_PVT;
917:
918: -- Standard call to check for call compatibility
919: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
921: END IF;
922:
1030: end if;
1031:
1032: -- END OF BODY OF API
1033:
1034: -- Standard check of p_commit.
1035: IF FND_API.To_Boolean( p_commit ) THEN
1036: COMMIT WORK;
1037: END IF;
1038:
1036: COMMIT WORK;
1037: END IF;
1038:
1039: x_return_status := l_return_status;
1040: -- Standard call to get message count and if count is 1, get message info
1041: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1042: p_count => x_msg_count,
1043: p_data => x_msg_data);
1044: