DBA Data[Home] [Help]

APPS.PON_CONSOLE_PVT dependencies on FND_API

Line 780: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS

776:
777: --- dbms_output.put_line('After timezone api call');
778: --- dbms_output.put_line('Tick client date ' || i || ' : ' || to_char(l_tick_client_date,'dd-mon-yyyy hh24:mi:ss'));
779:
780: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS
781: THEN
782: -- Temporary code...have better handling later on
783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
784: END IF;

Line 783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

779:
780: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS
781: THEN
782: -- Temporary code...have better handling later on
783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
784: END IF;
785:
786: x_tick_date_values(i) := l_tick_client_date;
787:

Line 814: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

810: WHEN excp_invalid_timezone
811: THEN
812: -- set appropriate out parameters; temporary code below
813: raise;
814: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
815: THEN
816: RAISE;
817: END get_tick_values;
818:

Line 1209: x_record_status := FND_API.G_TRUE;

1205:
1206: BEGIN
1207:
1208: -- initialize the out parameter
1209: x_record_status := FND_API.G_TRUE;
1210:
1211: -- Initialize other variables
1212: l_sysdate := SYSDATE;
1213: l_user_id := fnd_global.user_id;

Line 1299: x_record_status := FND_API.G_FALSE;

1295: COMMIT;
1296:
1297: EXCEPTION
1298: WHEN OTHERS THEN
1299: x_record_status := FND_API.G_FALSE;
1300: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1301: FND_LOG.string(log_level => FND_LOG.level_unexpected
1302: ,module => g_pkg_name||'.'||l_api_name
1303: ,message => 'unexpected error '||l_progress

Line 1336: x_record_status := FND_API.G_TRUE;

1332:
1333: BEGIN
1334:
1335: -- initialize the out parameter
1336: x_record_status := FND_API.G_TRUE;
1337:
1338: -- Initialize other variables
1339: l_sysdate := SYSDATE;
1340: l_user_id := fnd_global.user_id;

Line 1400: x_record_status := FND_API.G_FALSE;

1396:
1397: EXCEPTION
1398: WHEN OTHERS THEN
1399: --DBMS_OUTPUT.PUT_LINE('error' ||SQLERRM ||' '||SQLCODE);
1400: x_record_status := FND_API.G_FALSE;
1401: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1402: FND_LOG.string(log_level => FND_LOG.level_unexpected
1403: ,module => g_pkg_name||'.'||l_api_name
1404: ,message => 'unexpected error '||l_progress