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_SCENARIOS_PVT dependencies on FND_API

Line 8: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

4: G_PKG_NAME CONSTANT VARCHAR2(30) :='CN_SCENARIOS_PVT';
5:
6: PROCEDURE delete_scenario_plans
7: (p_api_version IN NUMBER ,
8: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
9: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
10: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
11: p_role_plan_id IN CN_SCENARIO_PLANS_ALL.ROLE_PLAN_ID%TYPE := NULL,
12: p_comp_plan_id IN CN_SCENARIO_PLANS_ALL.COMP_PLAN_ID%TYPE := NULL,

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

5:
6: PROCEDURE delete_scenario_plans
7: (p_api_version IN NUMBER ,
8: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
9: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
10: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
11: p_role_plan_id IN CN_SCENARIO_PLANS_ALL.ROLE_PLAN_ID%TYPE := NULL,
12: p_comp_plan_id IN CN_SCENARIO_PLANS_ALL.COMP_PLAN_ID%TYPE := NULL,
13: p_role_id IN CN_SCENARIO_PLANS_ALL.ROLE_ID%TYPE := NULL,

Line 10: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

6: PROCEDURE delete_scenario_plans
7: (p_api_version IN NUMBER ,
8: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
9: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
10: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
11: p_role_plan_id IN CN_SCENARIO_PLANS_ALL.ROLE_PLAN_ID%TYPE := NULL,
12: p_comp_plan_id IN CN_SCENARIO_PLANS_ALL.COMP_PLAN_ID%TYPE := NULL,
13: p_role_id IN CN_SCENARIO_PLANS_ALL.ROLE_ID%TYPE := NULL,
14: x_return_status OUT NOCOPY VARCHAR2 ,

Line 25: IF NOT FND_API.Compatible_API_Call

21:
22: -- Standard Start of API savepoint
23: SAVEPOINT delete_scenario_plans;
24: -- Standard call to check for call compatibility.
25: IF NOT FND_API.Compatible_API_Call
26: (l_api_version ,
27: p_api_version ,
28: l_api_name ,
29: G_PKG_NAME )

Line 31: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

27: p_api_version ,
28: l_api_name ,
29: G_PKG_NAME )
30: THEN
31: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
32: END IF;
33: -- Initialize message list if p_init_msg_list is set to TRUE.
34: IF FND_API.to_Boolean( p_init_msg_list ) THEN
35: FND_MSG_PUB.initialize;

Line 34: IF FND_API.to_Boolean( p_init_msg_list ) THEN

30: THEN
31: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
32: END IF;
33: -- Initialize message list if p_init_msg_list is set to TRUE.
34: IF FND_API.to_Boolean( p_init_msg_list ) THEN
35: FND_MSG_PUB.initialize;
36: END IF;
37: -- Initialize API return status to success
38: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 38: x_return_status := FND_API.G_RET_STS_SUCCESS;

34: IF FND_API.to_Boolean( p_init_msg_list ) THEN
35: FND_MSG_PUB.initialize;
36: END IF;
37: -- Initialize API return status to success
38: x_return_status := FND_API.G_RET_STS_SUCCESS;
39:
40: IF p_role_plan_id is not null then
41: delete from cn_scenario_plans_all where role_plan_id = p_role_plan_id;
42: end if;

Line 57: IF FND_API.To_Boolean( p_commit ) THEN

53:
54: -- End of API body.
55:
56: -- Standard check of p_commit.
57: IF FND_API.To_Boolean( p_commit ) THEN
58: COMMIT WORK;
59: END IF;
60: -- Standard call to get message count and if count is 1, get message info.
61: FND_MSG_PUB.Count_And_Get

Line 64: p_encoded => FND_API.G_FALSE );

60: -- Standard call to get message count and if count is 1, get message info.
61: FND_MSG_PUB.Count_And_Get
62: (p_count => x_msg_count ,
63: p_data => x_msg_data ,
64: p_encoded => FND_API.G_FALSE );
65: EXCEPTION
66: WHEN FND_API.G_EXC_ERROR THEN
67: ROLLBACK TO delete_scenario_plans;
68: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 66: WHEN FND_API.G_EXC_ERROR THEN

62: (p_count => x_msg_count ,
63: p_data => x_msg_data ,
64: p_encoded => FND_API.G_FALSE );
65: EXCEPTION
66: WHEN FND_API.G_EXC_ERROR THEN
67: ROLLBACK TO delete_scenario_plans;
68: x_return_status := FND_API.G_RET_STS_ERROR ;
69: FND_MSG_PUB.count_and_get
70: (p_count => x_msg_count ,

Line 68: x_return_status := FND_API.G_RET_STS_ERROR ;

64: p_encoded => FND_API.G_FALSE );
65: EXCEPTION
66: WHEN FND_API.G_EXC_ERROR THEN
67: ROLLBACK TO delete_scenario_plans;
68: x_return_status := FND_API.G_RET_STS_ERROR ;
69: FND_MSG_PUB.count_and_get
70: (p_count => x_msg_count ,
71: p_data => x_msg_data ,
72: p_encoded => FND_API.G_FALSE );

Line 72: p_encoded => FND_API.G_FALSE );

68: x_return_status := FND_API.G_RET_STS_ERROR ;
69: FND_MSG_PUB.count_and_get
70: (p_count => x_msg_count ,
71: p_data => x_msg_data ,
72: p_encoded => FND_API.G_FALSE );
73: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
74: ROLLBACK TO delete_scenario_plans;
75: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
76: FND_MSG_PUB.count_and_get

Line 73: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

69: FND_MSG_PUB.count_and_get
70: (p_count => x_msg_count ,
71: p_data => x_msg_data ,
72: p_encoded => FND_API.G_FALSE );
73: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
74: ROLLBACK TO delete_scenario_plans;
75: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
76: FND_MSG_PUB.count_and_get
77: (p_count => x_msg_count ,

Line 75: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

71: p_data => x_msg_data ,
72: p_encoded => FND_API.G_FALSE );
73: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
74: ROLLBACK TO delete_scenario_plans;
75: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
76: FND_MSG_PUB.count_and_get
77: (p_count => x_msg_count ,
78: p_data => x_msg_data ,
79: p_encoded => FND_API.G_FALSE );

Line 79: p_encoded => FND_API.G_FALSE );

75: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
76: FND_MSG_PUB.count_and_get
77: (p_count => x_msg_count ,
78: p_data => x_msg_data ,
79: p_encoded => FND_API.G_FALSE );
80: WHEN OTHERS THEN
81: ROLLBACK TO delete_scenario_plans;
82: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
83: IF FND_MSG_PUB.check_msg_level

Line 82: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

78: p_data => x_msg_data ,
79: p_encoded => FND_API.G_FALSE );
80: WHEN OTHERS THEN
81: ROLLBACK TO delete_scenario_plans;
82: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
83: IF FND_MSG_PUB.check_msg_level
84: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
85: THEN
86: FND_MSG_PUB.add_exc_msg

Line 93: p_encoded => FND_API.G_FALSE );

89: END IF;
90: FND_MSG_PUB.count_and_get
91: (p_count => x_msg_count ,
92: p_data => x_msg_data ,
93: p_encoded => FND_API.G_FALSE );
94: END;
95:
96: END CN_SCENARIOS_PVT;