eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_SCA_TRX_PROC_PVT dependencies on FND_API

Line 2262: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

2258:
2259:
2260: PROCEDURE call_populate_results (
2261: p_api_version IN NUMBER,
2262: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2263: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2264: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
2265: p_start_date IN DATE,
2266: p_end_date IN DATE,

Line 2263: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2259:
2260: PROCEDURE call_populate_results (
2261: p_api_version IN NUMBER,
2262: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2263: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2264: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
2265: p_start_date IN DATE,
2266: p_end_date IN DATE,
2267: p_org_id IN NUMBER,

Line 2264: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

2260: PROCEDURE call_populate_results (
2261: p_api_version IN NUMBER,
2262: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2263: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2264: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
2265: p_start_date IN DATE,
2266: p_end_date IN DATE,
2267: p_org_id IN NUMBER,
2268: x_return_status OUT NOCOPY VARCHAR2,

Line 2288: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

2284: -- Standard Start of API savepoint
2285: SAVEPOINT call_populate_results;
2286:
2287: -- Standard call to check for call compatibility.
2288: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2289: p_api_version ,
2290: l_api_name,
2291: G_PKG_NAME ) THEN
2292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2288: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2289: p_api_version ,
2290: l_api_name,
2291: G_PKG_NAME ) THEN
2292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2293: END IF;
2294:
2295: -- Initialize message list if p_init_msg_list is set to TRUE.
2296: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2296: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2293: END IF;
2294:
2295: -- Initialize message list if p_init_msg_list is set to TRUE.
2296: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2297: FND_MSG_PUB.initialize;
2298: END IF;
2299:
2300: -- Initialize API return status to success

Line 2301: x_return_status := FND_API.G_RET_STS_SUCCESS;

2297: FND_MSG_PUB.initialize;
2298: END IF;
2299:
2300: -- Initialize API return status to success
2301: x_return_status := FND_API.G_RET_STS_SUCCESS;
2302:
2303: fnd_request.set_org_id( p_org_id ); -- vensrini
2304:
2305: x_process_audit_id :=

Line 2316: WHEN FND_API.G_EXC_ERROR THEN

2312: argument3 => p_org_id);
2313: commit;
2314:
2315: EXCEPTION
2316: WHEN FND_API.G_EXC_ERROR THEN
2317: ROLLBACK TO call_populate_results;
2318: x_return_status := FND_API.G_RET_STS_ERROR ;
2319: FND_MSG_PUB.Count_And_Get(
2320: p_count => x_msg_count ,

Line 2318: x_return_status := FND_API.G_RET_STS_ERROR ;

2314:
2315: EXCEPTION
2316: WHEN FND_API.G_EXC_ERROR THEN
2317: ROLLBACK TO call_populate_results;
2318: x_return_status := FND_API.G_RET_STS_ERROR ;
2319: FND_MSG_PUB.Count_And_Get(
2320: p_count => x_msg_count ,
2321: p_data => x_msg_data ,
2322: p_encoded => FND_API.G_FALSE);

Line 2322: p_encoded => FND_API.G_FALSE);

2318: x_return_status := FND_API.G_RET_STS_ERROR ;
2319: FND_MSG_PUB.Count_And_Get(
2320: p_count => x_msg_count ,
2321: p_data => x_msg_data ,
2322: p_encoded => FND_API.G_FALSE);
2323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2324: ROLLBACK TO call_populate_results;
2325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2326: FND_MSG_PUB.Count_And_Get(

Line 2323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2319: FND_MSG_PUB.Count_And_Get(
2320: p_count => x_msg_count ,
2321: p_data => x_msg_data ,
2322: p_encoded => FND_API.G_FALSE);
2323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2324: ROLLBACK TO call_populate_results;
2325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2326: FND_MSG_PUB.Count_And_Get(
2327: p_count => x_msg_count ,

Line 2325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2321: p_data => x_msg_data ,
2322: p_encoded => FND_API.G_FALSE);
2323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2324: ROLLBACK TO call_populate_results;
2325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2326: FND_MSG_PUB.Count_And_Get(
2327: p_count => x_msg_count ,
2328: p_data => x_msg_data ,
2329: p_encoded => FND_API.G_FALSE);

Line 2329: p_encoded => FND_API.G_FALSE);

2325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2326: FND_MSG_PUB.Count_And_Get(
2327: p_count => x_msg_count ,
2328: p_data => x_msg_data ,
2329: p_encoded => FND_API.G_FALSE);
2330: WHEN OTHERS THEN
2331: ROLLBACK TO call_populate_results;
2332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2333: IF FND_MSG_PUB.Check_Msg_Level(

Line 2332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2328: p_data => x_msg_data ,
2329: p_encoded => FND_API.G_FALSE);
2330: WHEN OTHERS THEN
2331: ROLLBACK TO call_populate_results;
2332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2333: IF FND_MSG_PUB.Check_Msg_Level(
2334: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2335: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
2336: END IF;

Line 2340: p_encoded => FND_API.G_FALSE);

2336: END IF;
2337: FND_MSG_PUB.Count_And_Get(
2338: p_count => x_msg_count ,
2339: p_data => x_msg_data ,
2340: p_encoded => FND_API.G_FALSE);
2341:
2342: END call_populate_results;
2343:
2344:

Line 2521: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

2517:
2518:
2519: PROCEDURE call_populate_data (
2520: p_api_version IN NUMBER,
2521: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2522: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2523: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
2524: p_start_date IN DATE,
2525: p_end_date IN DATE,

Line 2522: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2518:
2519: PROCEDURE call_populate_data (
2520: p_api_version IN NUMBER,
2521: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2522: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2523: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
2524: p_start_date IN DATE,
2525: p_end_date IN DATE,
2526: p_checkbox_value IN VARCHAR2,

Line 2523: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

2519: PROCEDURE call_populate_data (
2520: p_api_version IN NUMBER,
2521: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2522: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2523: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
2524: p_start_date IN DATE,
2525: p_end_date IN DATE,
2526: p_checkbox_value IN VARCHAR2,
2527: x_return_status OUT NOCOPY VARCHAR2,

Line 2543: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

2539: -- Standard Start of API savepoint
2540: SAVEPOINT call_populate_data;
2541:
2542: -- Standard call to check for call compatibility.
2543: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2544: p_api_version ,
2545: l_api_name,
2546: G_PKG_NAME ) THEN
2547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2543: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2544: p_api_version ,
2545: l_api_name,
2546: G_PKG_NAME ) THEN
2547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2548: END IF;
2549:
2550: -- Initialize message list if p_init_msg_list is set to TRUE.
2551: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2551: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2548: END IF;
2549:
2550: -- Initialize message list if p_init_msg_list is set to TRUE.
2551: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2552: FND_MSG_PUB.initialize;
2553: END IF;
2554:
2555: -- Initialize API return status to success

Line 2556: x_return_status := FND_API.G_RET_STS_SUCCESS;

2552: FND_MSG_PUB.initialize;
2553: END IF;
2554:
2555: -- Initialize API return status to success
2556: x_return_status := FND_API.G_RET_STS_SUCCESS;
2557:
2558: IF (p_checkbox_value <> 'Y') THEN
2559: l_checkbox_value := 'N';
2560: END IF;

Line 2572: RAISE FND_API.G_EXC_ERROR ;

2568: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2569: FND_MESSAGE.SET_NAME ('CN' , 'CN_DYNAMIC_PKG_NOT_GEN');
2570: FND_MSG_PUB.Add;
2571: END IF;
2572: RAISE FND_API.G_EXC_ERROR ;
2573:
2574: END IF;
2575:
2576: x_process_audit_id :=

Line 2586: WHEN FND_API.G_EXC_ERROR THEN

2582: argument3 => l_checkbox_value);
2583: commit;
2584:
2585: EXCEPTION
2586: WHEN FND_API.G_EXC_ERROR THEN
2587:
2588: ROLLBACK TO call_populate_data;
2589:
2590: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 2590: x_return_status := FND_API.G_RET_STS_ERROR ;

2586: WHEN FND_API.G_EXC_ERROR THEN
2587:
2588: ROLLBACK TO call_populate_data;
2589:
2590: x_return_status := FND_API.G_RET_STS_ERROR ;
2591: FND_MSG_PUB.Count_And_Get(
2592: p_count => x_msg_count ,
2593: p_data => x_msg_data ,
2594: p_encoded => FND_API.G_FALSE);

Line 2594: p_encoded => FND_API.G_FALSE);

2590: x_return_status := FND_API.G_RET_STS_ERROR ;
2591: FND_MSG_PUB.Count_And_Get(
2592: p_count => x_msg_count ,
2593: p_data => x_msg_data ,
2594: p_encoded => FND_API.G_FALSE);
2595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2596: ROLLBACK TO call_populate_data;
2597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2598: FND_MSG_PUB.Count_And_Get(

Line 2595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2591: FND_MSG_PUB.Count_And_Get(
2592: p_count => x_msg_count ,
2593: p_data => x_msg_data ,
2594: p_encoded => FND_API.G_FALSE);
2595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2596: ROLLBACK TO call_populate_data;
2597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2598: FND_MSG_PUB.Count_And_Get(
2599: p_count => x_msg_count ,

Line 2597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2593: p_data => x_msg_data ,
2594: p_encoded => FND_API.G_FALSE);
2595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2596: ROLLBACK TO call_populate_data;
2597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2598: FND_MSG_PUB.Count_And_Get(
2599: p_count => x_msg_count ,
2600: p_data => x_msg_data ,
2601: p_encoded => FND_API.G_FALSE);

Line 2601: p_encoded => FND_API.G_FALSE);

2597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2598: FND_MSG_PUB.Count_And_Get(
2599: p_count => x_msg_count ,
2600: p_data => x_msg_data ,
2601: p_encoded => FND_API.G_FALSE);
2602: WHEN OTHERS THEN
2603: ROLLBACK TO call_populate_data;
2604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2605: IF FND_MSG_PUB.Check_Msg_Level(

Line 2604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2600: p_data => x_msg_data ,
2601: p_encoded => FND_API.G_FALSE);
2602: WHEN OTHERS THEN
2603: ROLLBACK TO call_populate_data;
2604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2605: IF FND_MSG_PUB.Check_Msg_Level(
2606: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2607: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
2608: END IF;

Line 2612: p_encoded => FND_API.G_FALSE);

2608: END IF;
2609: FND_MSG_PUB.Count_And_Get(
2610: p_count => x_msg_count ,
2611: p_data => x_msg_data ,
2612: p_encoded => FND_API.G_FALSE);
2613:
2614: END call_populate_data;
2615:
2616: Procedure check_api_adjusted (

Line 3991: dbms_sql.bind_variable(c,'init_msg_list', FND_API.G_FALSE);

3987: dbms_sql.bind_variable(c,'sca_proc_batch_id', p_physical_batch_id, 30);
3988: dbms_sql.bind_variable(c,'start_date', p_start_date);
3989: dbms_sql.bind_variable(c,'end_date', p_end_date);
3990: dbms_sql.bind_variable(c,'api_version', 1.0);
3991: dbms_sql.bind_variable(c,'init_msg_list', FND_API.G_FALSE);
3992: dbms_sql.bind_variable(c,'commit', FND_API.G_FALSE);
3993: dbms_sql.bind_variable(c,'validation_level', FND_API.G_VALID_LEVEL_FULL);
3994: dbms_sql.bind_variable(c,'org_id', p_org_id);
3995: dbms_sql.bind_variable(c,'return_status', l_return_status, 50);

Line 3992: dbms_sql.bind_variable(c,'commit', FND_API.G_FALSE);

3988: dbms_sql.bind_variable(c,'start_date', p_start_date);
3989: dbms_sql.bind_variable(c,'end_date', p_end_date);
3990: dbms_sql.bind_variable(c,'api_version', 1.0);
3991: dbms_sql.bind_variable(c,'init_msg_list', FND_API.G_FALSE);
3992: dbms_sql.bind_variable(c,'commit', FND_API.G_FALSE);
3993: dbms_sql.bind_variable(c,'validation_level', FND_API.G_VALID_LEVEL_FULL);
3994: dbms_sql.bind_variable(c,'org_id', p_org_id);
3995: dbms_sql.bind_variable(c,'return_status', l_return_status, 50);
3996: dbms_sql.bind_variable(c,'msg_count', l_msg_count);

Line 3993: dbms_sql.bind_variable(c,'validation_level', FND_API.G_VALID_LEVEL_FULL);

3989: dbms_sql.bind_variable(c,'end_date', p_end_date);
3990: dbms_sql.bind_variable(c,'api_version', 1.0);
3991: dbms_sql.bind_variable(c,'init_msg_list', FND_API.G_FALSE);
3992: dbms_sql.bind_variable(c,'commit', FND_API.G_FALSE);
3993: dbms_sql.bind_variable(c,'validation_level', FND_API.G_VALID_LEVEL_FULL);
3994: dbms_sql.bind_variable(c,'org_id', p_org_id);
3995: dbms_sql.bind_variable(c,'return_status', l_return_status, 50);
3996: dbms_sql.bind_variable(c,'msg_count', l_msg_count);
3997: dbms_sql.bind_variable(c,'msg_data', l_msg_data, 200);

Line 4006: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

4002: dbms_sql.variable_value(c,'msg_count', l_msg_count);
4003: dbms_sql.variable_value(c,'msg_data', l_msg_data);
4004: dbms_sql.close_cursor(c);
4005:
4006: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
4007:
4008: RAISE fail_populate;
4009:
4010: end if;