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 2260: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

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

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

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

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

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

Line 2286: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

Line 2290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2294: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 2299: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 2314: WHEN FND_API.G_EXC_ERROR THEN

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

Line 2316: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 2320: p_encoded => FND_API.G_FALSE);

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

Line 2321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 2327: p_encoded => FND_API.G_FALSE);

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

Line 2330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 2338: p_encoded => FND_API.G_FALSE);

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

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

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

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

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

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

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

Line 2541: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

Line 2545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2549: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 2554: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 2570: RAISE FND_API.G_EXC_ERROR ;

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

Line 2584: WHEN FND_API.G_EXC_ERROR THEN

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

Line 2588: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 2592: p_encoded => FND_API.G_FALSE);

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

Line 2593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 2599: p_encoded => FND_API.G_FALSE);

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

Line 2602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 2610: p_encoded => FND_API.G_FALSE);

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

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

3981: dbms_sql.bind_variable(c,'sca_proc_batch_id', p_physical_batch_id, 30);
3982: dbms_sql.bind_variable(c,'start_date', p_start_date);
3983: dbms_sql.bind_variable(c,'end_date', p_end_date);
3984: dbms_sql.bind_variable(c,'api_version', 1.0);
3985: dbms_sql.bind_variable(c,'init_msg_list', FND_API.G_FALSE);
3986: dbms_sql.bind_variable(c,'commit', FND_API.G_FALSE);
3987: dbms_sql.bind_variable(c,'validation_level', FND_API.G_VALID_LEVEL_FULL);
3988: dbms_sql.bind_variable(c,'org_id', p_org_id);
3989: dbms_sql.bind_variable(c,'return_status', l_return_status, 50);

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

3982: dbms_sql.bind_variable(c,'start_date', p_start_date);
3983: dbms_sql.bind_variable(c,'end_date', p_end_date);
3984: dbms_sql.bind_variable(c,'api_version', 1.0);
3985: dbms_sql.bind_variable(c,'init_msg_list', FND_API.G_FALSE);
3986: dbms_sql.bind_variable(c,'commit', FND_API.G_FALSE);
3987: dbms_sql.bind_variable(c,'validation_level', FND_API.G_VALID_LEVEL_FULL);
3988: dbms_sql.bind_variable(c,'org_id', p_org_id);
3989: dbms_sql.bind_variable(c,'return_status', l_return_status, 50);
3990: dbms_sql.bind_variable(c,'msg_count', l_msg_count);

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

3983: dbms_sql.bind_variable(c,'end_date', p_end_date);
3984: dbms_sql.bind_variable(c,'api_version', 1.0);
3985: dbms_sql.bind_variable(c,'init_msg_list', FND_API.G_FALSE);
3986: dbms_sql.bind_variable(c,'commit', FND_API.G_FALSE);
3987: dbms_sql.bind_variable(c,'validation_level', FND_API.G_VALID_LEVEL_FULL);
3988: dbms_sql.bind_variable(c,'org_id', p_org_id);
3989: dbms_sql.bind_variable(c,'return_status', l_return_status, 50);
3990: dbms_sql.bind_variable(c,'msg_count', l_msg_count);
3991: dbms_sql.bind_variable(c,'msg_data', l_msg_data, 200);

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

3996: dbms_sql.variable_value(c,'msg_count', l_msg_count);
3997: dbms_sql.variable_value(c,'msg_data', l_msg_data);
3998: dbms_sql.close_cursor(c);
3999:
4000: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
4001:
4002: RAISE fail_populate;
4003:
4004: end if;