DBA Data[Home] [Help]

APPS.ZPB_DHMINTERFACE_GRP dependencies on FND_API

Line 183: if not FND_API.Compatible_API_Call (l_api_version,

179: and a.DIMENSION_ID = b.DIMENSION_ID ;
180: begin
181: SAVEPOINT Export_Dimension_Grp;
182:
183: if not FND_API.Compatible_API_Call (l_api_version,
184: p_api_version,
185: l_api_name,
186: G_PKG_NAME)
187: then

Line 188: raise FND_API.G_EXC_UNEXPECTED_ERROR;

184: p_api_version,
185: l_api_name,
186: G_PKG_NAME)
187: then
188: raise FND_API.G_EXC_UNEXPECTED_ERROR;
189: end if;
190:
191: if (FND_API.TO_BOOLEAN (p_init_msg_list)) then
192: FND_MSG_PUB.INITIALIZE;

Line 191: if (FND_API.TO_BOOLEAN (p_init_msg_list)) then

187: then
188: raise FND_API.G_EXC_UNEXPECTED_ERROR;
189: end if;
190:
191: if (FND_API.TO_BOOLEAN (p_init_msg_list)) then
192: FND_MSG_PUB.INITIALIZE;
193: end if;
194:
195: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 195: x_return_status := FND_API.G_RET_STS_SUCCESS;

191: if (FND_API.TO_BOOLEAN (p_init_msg_list)) then
192: FND_MSG_PUB.INITIALIZE;
193: end if;
194:
195: x_return_status := FND_API.G_RET_STS_SUCCESS;
196:
197: l_shdw_id := nvl(sys_context('ZPB_CONTEXT', 'shadow_id'),
198: fnd_global.user_id);
199: l_apps_id := nvl(sys_context('ZPB_CONTEXT', 'user_id'), fnd_global.user_id);

Line 1402: if (FND_API.TO_BOOLEAN (p_commit)) then

1398:
1399: zpb_aw.execute ('pop oknullstatus commas '||l_awQual||l_dim_data.ExpObj||
1400: ' '||l_awQual||l_global_ecm.LangDim);
1401:
1402: if (FND_API.TO_BOOLEAN (p_commit)) then
1403: zpb_aw.execute ('upd');
1404: commit work;
1405: end if;
1406:

Line 1412: when FND_API.G_EXC_ERROR then

1408: (p_count => x_msg_count,
1409: p_data => x_msg_data);
1410: /*
1411: exception
1412: when FND_API.G_EXC_ERROR then
1413: ROLLBACK TO Export_Dimension_Grp;
1414: x_return_status := FND_API.G_RET_STS_ERROR;
1415: FND_MSG_PUB.COUNT_AND_GET
1416: (p_count => x_msg_count,

Line 1414: x_return_status := FND_API.G_RET_STS_ERROR;

1410: /*
1411: exception
1412: when FND_API.G_EXC_ERROR then
1413: ROLLBACK TO Export_Dimension_Grp;
1414: x_return_status := FND_API.G_RET_STS_ERROR;
1415: FND_MSG_PUB.COUNT_AND_GET
1416: (p_count => x_msg_count,
1417: p_data => x_msg_data);
1418:

Line 1419: when FND_API.G_EXC_UNEXPECTED_ERROR then

1415: FND_MSG_PUB.COUNT_AND_GET
1416: (p_count => x_msg_count,
1417: p_data => x_msg_data);
1418:
1419: when FND_API.G_EXC_UNEXPECTED_ERROR then
1420: ROLLBACK TO Export_Dimension_Grp;
1421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1422: FND_MSG_PUB.COUNT_AND_GET
1423: (p_count => x_msg_count,

Line 1421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1417: p_data => x_msg_data);
1418:
1419: when FND_API.G_EXC_UNEXPECTED_ERROR then
1420: ROLLBACK TO Export_Dimension_Grp;
1421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1422: FND_MSG_PUB.COUNT_AND_GET
1423: (p_count => x_msg_count,
1424: p_data => x_msg_data);
1425:

Line 1428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1424: p_data => x_msg_data);
1425:
1426: when OTHERS then
1427: ROLLBACK TO Export_Dimension_Grp;
1428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1429: if (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) then
1430: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1431: end if;
1432: FND_MSG_PUB.COUNT_AND_GET

Line 1560: if not FND_API.Compatible_API_Call (l_api_version,

1556: order by RELATIVE_DIMENSION_GROUP_SEQ;
1557: begin
1558: SAVEPOINT Import_Dimension_Grp;
1559:
1560: if not FND_API.Compatible_API_Call (l_api_version,
1561: p_api_version,
1562: l_api_name,
1563: G_PKG_NAME)
1564: then

Line 1565: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1561: p_api_version,
1562: l_api_name,
1563: G_PKG_NAME)
1564: then
1565: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1566: end if;
1567:
1568: if (FND_API.TO_BOOLEAN (p_init_msg_list)) then
1569: FND_MSG_PUB.INITIALIZE;

Line 1568: if (FND_API.TO_BOOLEAN (p_init_msg_list)) then

1564: then
1565: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1566: end if;
1567:
1568: if (FND_API.TO_BOOLEAN (p_init_msg_list)) then
1569: FND_MSG_PUB.INITIALIZE;
1570: end if;
1571:
1572: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1572: x_return_status := FND_API.G_RET_STS_SUCCESS;

1568: if (FND_API.TO_BOOLEAN (p_init_msg_list)) then
1569: FND_MSG_PUB.INITIALIZE;
1570: end if;
1571:
1572: x_return_status := FND_API.G_RET_STS_SUCCESS;
1573:
1574: l_shdw_id := nvl(sys_context('ZPB_CONTEXT', 'shadow_id'),
1575: fnd_global.user_id);
1576: l_apps_id := nvl(sys_context('ZPB_CONTEXT', 'user_id'), fnd_global.user_id);

Line 2387: if (FND_API.TO_BOOLEAN (p_commit)) then

2383: zpb_aw.execute ('pop oknullstatus '||l_awQual||l_dim_data.ExpObj||' '||
2384: l_awQual||l_global_ecm.LangDim||' '||l_awQual||
2385: l_dim_ecm.LevelDim);
2386:
2387: if (FND_API.TO_BOOLEAN (p_commit)) then
2388: zpb_aw.execute ('upd');
2389: commit work;
2390: end if;
2391:

Line 2397: when FND_API.G_EXC_ERROR then

2393: (p_count => x_msg_count,
2394: p_data => x_msg_data);
2395: /*
2396: exception
2397: when FND_API.G_EXC_ERROR then
2398: ROLLBACK TO Import_Dimension_Grp;
2399: x_return_status := FND_API.G_RET_STS_ERROR;
2400: FND_MSG_PUB.COUNT_AND_GET
2401: (p_count => x_msg_count,

Line 2399: x_return_status := FND_API.G_RET_STS_ERROR;

2395: /*
2396: exception
2397: when FND_API.G_EXC_ERROR then
2398: ROLLBACK TO Import_Dimension_Grp;
2399: x_return_status := FND_API.G_RET_STS_ERROR;
2400: FND_MSG_PUB.COUNT_AND_GET
2401: (p_count => x_msg_count,
2402: p_data => x_msg_data);
2403:

Line 2404: when FND_API.G_EXC_UNEXPECTED_ERROR then

2400: FND_MSG_PUB.COUNT_AND_GET
2401: (p_count => x_msg_count,
2402: p_data => x_msg_data);
2403:
2404: when FND_API.G_EXC_UNEXPECTED_ERROR then
2405: ROLLBACK TO Import_Dimension_Grp;
2406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2407: FND_MSG_PUB.COUNT_AND_GET
2408: (p_count => x_msg_count,

Line 2406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2402: p_data => x_msg_data);
2403:
2404: when FND_API.G_EXC_UNEXPECTED_ERROR then
2405: ROLLBACK TO Import_Dimension_Grp;
2406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2407: FND_MSG_PUB.COUNT_AND_GET
2408: (p_count => x_msg_count,
2409: p_data => x_msg_data);
2410:

Line 2413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2409: p_data => x_msg_data);
2410:
2411: when OTHERS then
2412: ROLLBACK TO Import_Dimension_Grp;
2413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2414:
2415: if (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) then
2416: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2417: end if;