DBA Data[Home] [Help]

APPS.WIP_REBUILD dependencies on FND_API

Line 101: x_retVal := fnd_api.G_RET_STS_SUCCESS; --assume success

97:
98: l_msgCount NUMBER;
99: BEGIN
100:
101: x_retVal := fnd_api.G_RET_STS_SUCCESS; --assume success
102:
103: select mmtt.rebuild_serial_number,
104: mmtt.rebuild_item_id,
105: mmtt.organization_id,

Line 157: x_retVal := fnd_api.G_RET_STS_ERROR;

153: x_msg_data => x_errMsg);
154: end if;
155:
156: EXCEPTION when others then
157: x_retVal := fnd_api.G_RET_STS_ERROR;
158: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
159: fnd_message.set_token('ERROR_TEXT', 'wip_rebuild.update_genealogy');
160: x_errMsg := fnd_message.get;
161: end update_genealogy;

Line 362: x_retVal := FND_API.G_RET_STS_ERROR;

358: END IF;
359: CLOSE workorder;
360:
361: IF(l_return_status<>'S') THEN
362: x_retVal := FND_API.G_RET_STS_ERROR;
363:
364: --get the messages from the wo api
365:
366: mesg := '';

Line 386: if(x_retVal <> FND_API.G_RET_STS_SUCCESS) then

382:
383: update_genealogy(p_tempId => p_tempId,
384: x_retVal => x_retVal,
385: x_errMsg => x_errMsg);
386: if(x_retVal <> FND_API.G_RET_STS_SUCCESS) then
387: ROLLBACK TO REBUILD; --gen update failure
388: end if;
389: end if;
390: