DBA Data[Home] [Help]

APPS.PJI_FM_PLAN_MAINT dependencies on FND_API

Line 1355: x_return_status := FND_API.G_RET_STS_SUCCESS;

1351: excp_plan_already_summarized EXCEPTION;
1352: PRAGMA EXCEPTION_INIT(excp_plan_already_summarized, -1422);
1353: BEGIN
1354:
1355: x_return_status := FND_API.G_RET_STS_SUCCESS;
1356:
1357: FOR i IN p_fp_version_ids.FIRST..p_fp_version_ids.LAST LOOP
1358:
1359: print_time('plan version id.. ' || p_fp_version_ids(i) );

Line 1382: x_return_status := FND_API.G_RET_STS_ERROR;

1378: END LOOP;
1379:
1380: EXCEPTION
1381: WHEN excp_plan_already_summarized THEN
1382: x_return_status := FND_API.G_RET_STS_ERROR;
1383: print_time(' CHECK_PRIMARY_ALREADY_EXISTS exception ' || SQLERRM );
1384: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
1385: p_procedure_name => 'CHECK_PRIMARY_ALREADY_EXISTS');
1386: RAISE;

Line 1389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1385: p_procedure_name => 'CHECK_PRIMARY_ALREADY_EXISTS');
1386: RAISE;
1387:
1388: WHEN OTHERS THEN
1389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1390: print_time(' SEC_SLICE_CREATE_T exception ' || SQLERRM );
1391: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
1392: p_procedure_name => 'CHECK_PRIMARY_ALREADY_EXISTS');
1393: RAISE;

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

1644: , x_num_rows => l_num_rows
1645: , x_return_status => x_return_status
1646: , x_msg_code => x_msg_code) ;
1647:
1648: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1649: print_time(' PULL_PLANS_FOR_PR input parameters did not validate. Exitting.');
1650: RETURN;
1651: ELSIF (l_num_rows = 0) THEN
1652: print_time ( 'GET_ACTUALS_SUMM : no rows in ver3 to process, RETURNING.' );

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

1753: , x_return_status => x_return_status
1754: , x_msg_code => x_msg_code) ;
1755:
1756:
1757: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1758: print_time(' PULL_PLANS_FOR_PR input parameters did not validate. Exitting.');
1759: RETURN;
1760: ELSIF (l_num_rows = 0) THEN
1761: print_time ( 'GET_ACTUALS_SUMM : no rows in ver3 to process, RETURNING.' );