DBA Data[Home] [Help]

APPS.PJI_FM_PLAN_MAINT dependencies on FND_API

Line 1302: x_return_status := FND_API.G_RET_STS_SUCCESS;

1298: excp_plan_already_summarized EXCEPTION;
1299: PRAGMA EXCEPTION_INIT(excp_plan_already_summarized, -1422);
1300: BEGIN
1301:
1302: x_return_status := FND_API.G_RET_STS_SUCCESS;
1303:
1304: FOR i IN p_fp_version_ids.FIRST..p_fp_version_ids.LAST LOOP
1305:
1306: print_time('plan version id.. ' || p_fp_version_ids(i) );

Line 1329: x_return_status := FND_API.G_RET_STS_ERROR;

1325: END LOOP;
1326:
1327: EXCEPTION
1328: WHEN excp_plan_already_summarized THEN
1329: x_return_status := FND_API.G_RET_STS_ERROR;
1330: print_time(' CHECK_PRIMARY_ALREADY_EXISTS exception ' || SQLERRM );
1331: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
1332: p_procedure_name => 'CHECK_PRIMARY_ALREADY_EXISTS');
1333: RAISE;

Line 1336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1332: p_procedure_name => 'CHECK_PRIMARY_ALREADY_EXISTS');
1333: RAISE;
1334:
1335: WHEN OTHERS THEN
1336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1337: print_time(' SEC_SLICE_CREATE_T exception ' || SQLERRM );
1338: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
1339: p_procedure_name => 'CHECK_PRIMARY_ALREADY_EXISTS');
1340: RAISE;

Line 1594: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1590: , x_num_rows => l_num_rows
1591: , x_return_status => x_return_status
1592: , x_msg_code => x_msg_code) ;
1593:
1594: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1595: print_time(' PULL_PLANS_FOR_PR input parameters did not validate. Exitting.');
1596: RETURN;
1597: ELSIF (l_num_rows = 0) THEN
1598: print_time ( 'GET_ACTUALS_SUMM : no rows in ver3 to process, RETURNING.' );

Line 1697: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1693: , x_return_status => x_return_status
1694: , x_msg_code => x_msg_code) ;
1695:
1696:
1697: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1698: print_time(' PULL_PLANS_FOR_PR input parameters did not validate. Exitting.');
1699: RETURN;
1700: ELSIF (l_num_rows = 0) THEN
1701: print_time ( 'GET_ACTUALS_SUMM : no rows in ver3 to process, RETURNING.' );