APPS.EGO_ITEM_AML_GRP dependencies on FND_API

Line 131: x_return_status := FND_API.G_RET_STS_ERROR;

127: fnd_message.set_token('PACKAGE', G_PKG_NAME ||'.'|| l_api_name);
128: fnd_message.set_token('VALUE', l_msg_data);
129: x_msg_data := fnd_message.get();
130: x_msg_count := 1;
131: x_return_status := FND_API.G_RET_STS_ERROR;
132: RETURN;
133: END IF;
134:
135: IF (p_pf_to_process IS NULL) THEN

Line 143: x_return_status := FND_API.G_RET_STS_ERROR;

139: fnd_message.set_token('PACKAGE', G_PKG_NAME ||'.'|| l_api_name);
140: fnd_message.set_token('VALUE', l_msg_data);
141: x_msg_data := fnd_message.get();
142: x_msg_count := 1;
143: x_return_status := FND_API.G_RET_STS_ERROR;
144: RETURN;
145: END IF;
146:
147: log_now (p_log_level => G_DEBUG_LEVEL_STATEMENT

Line 163: x_return_status := FND_API.G_RET_STS_SUCCESS;

159: WHEN NO_DATA_FOUND THEN
160: fnd_message.set_name('EGO','EGO_IPI_NO_LINES');
161: x_msg_count := 1;
162: x_msg_data := fnd_message.get();
163: x_return_status := FND_API.G_RET_STS_SUCCESS;
164: RAISE NO_ROWS_IN_INTF_TABLE;
165: END;
166: log_now (p_log_level => G_DEBUG_LEVEL_STATEMENT
167: ,p_module => l_api_name

Line 171: IF FND_API.TO_BOOLEAN(p_commit) THEN

167: ,p_module => l_api_name
168: ,p_message => 'Found Interface Lines to be processed'
169: );
170:
171: IF FND_API.TO_BOOLEAN(p_commit) THEN
172: -- create save point
173: SAVEPOINT POPULATE_INTF_WITH_PRODDATA_SP;
174: END IF;
175:

Line 491: IF FND_API.TO_BOOLEAN(p_commit) THEN

487: ,p_module => l_api_name
488: ,p_message => 'Populate intf table with prod data for UPDATE done'
489: );
490:
491: IF FND_API.TO_BOOLEAN(p_commit) THEN
492: COMMIT WORK;
493: END IF;
494:
495: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 495: x_return_status := FND_API.G_RET_STS_SUCCESS;

491: IF FND_API.TO_BOOLEAN(p_commit) THEN
492: COMMIT WORK;
493: END IF;
494:
495: x_return_status := FND_API.G_RET_STS_SUCCESS;
496: x_msg_count := 0;
497: x_msg_data := NULL;
498: log_now (p_log_level => G_DEBUG_LEVEL_PROCEDURE
499: ,p_module => l_api_name

Line 506: IF FND_API.TO_BOOLEAN(p_commit) THEN

502: EXCEPTION
503: WHEN NO_ROWS_IN_INTF_TABLE THEN
504: NULL;
505: WHEN OTHERS THEN
506: IF FND_API.TO_BOOLEAN(p_commit) THEN
507: ROLLBACK TO POPULATE_INTF_WITH_PRODDATA_SP;
508: END IF;
509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
510: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

Line 509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

505: WHEN OTHERS THEN
506: IF FND_API.TO_BOOLEAN(p_commit) THEN
507: ROLLBACK TO POPULATE_INTF_WITH_PRODDATA_SP;
508: END IF;
509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
510: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
511: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
512: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
513: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);