APPS.PSB_DISTRIBUTE_WORKSHEET_PVT dependencies on FND_API

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

24: --
25: PROCEDURE Start_Process
26: (
27: p_api_version IN NUMBER ,
28: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
29: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
30: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
31: p_return_status OUT NOCOPY VARCHAR2 ,
32: p_msg_count OUT NOCOPY NUMBER ,

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

25: PROCEDURE Start_Process
26: (
27: p_api_version IN NUMBER ,
28: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
29: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
30: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
31: p_return_status OUT NOCOPY VARCHAR2 ,
32: p_msg_count OUT NOCOPY NUMBER ,
33: p_msg_data OUT NOCOPY VARCHAR2 ,

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

26: (
27: p_api_version IN NUMBER ,
28: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
29: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
30: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
31: p_return_status OUT NOCOPY VARCHAR2 ,
32: p_msg_count OUT NOCOPY NUMBER ,
33: p_msg_data OUT NOCOPY VARCHAR2 ,
34: --

Line 57: IF NOT FND_API.Compatible_API_Call ( l_api_version,

53: BEGIN
54: --
55: SAVEPOINT Start_Process_Pvt ;
56: --
57: IF NOT FND_API.Compatible_API_Call ( l_api_version,
58: p_api_version,
59: l_api_name,
60: G_PKG_NAME )
61: THEN

Line 62: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

58: p_api_version,
59: l_api_name,
60: G_PKG_NAME )
61: THEN
62: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
63: END IF;
64: --
65:
66: /* Bug 2576222 Start */

Line 70: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

66: /* Bug 2576222 Start */
67: l_user_name := fnd_global.user_name;
68: /* Bug 2576222 End */
69:
70: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
71: FND_MSG_PUB.initialize ;
72: END IF;
73: --
74: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 74: p_return_status := FND_API.G_RET_STS_SUCCESS ;

70: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
71: FND_MSG_PUB.initialize ;
72: END IF;
73: --
74: p_return_status := FND_API.G_RET_STS_SUCCESS ;
75: --
76:
77: WF_Engine.CreateProcess
78: (

Line 145: IF FND_API.To_Boolean ( p_commit ) THEN

141: ItemKey => l_ItemKey
142: );
143:
144: --
145: IF FND_API.To_Boolean ( p_commit ) THEN
146: COMMIT WORK;
147: END IF;
148: --
149: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 154: WHEN FND_API.G_EXC_ERROR THEN

150: p_data => p_msg_data );
151: --
152: EXCEPTION
153: --
154: WHEN FND_API.G_EXC_ERROR THEN
155: --
156: ROLLBACK TO Start_Process_Pvt ;
157: p_return_status := FND_API.G_RET_STS_ERROR;
158: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 157: p_return_status := FND_API.G_RET_STS_ERROR;

153: --
154: WHEN FND_API.G_EXC_ERROR THEN
155: --
156: ROLLBACK TO Start_Process_Pvt ;
157: p_return_status := FND_API.G_RET_STS_ERROR;
158: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
159: p_data => p_msg_data );
160: --
161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

157: p_return_status := FND_API.G_RET_STS_ERROR;
158: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
159: p_data => p_msg_data );
160: --
161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
162: --
163: ROLLBACK TO Start_Process_Pvt ;
164: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
165: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 164: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

160: --
161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
162: --
163: ROLLBACK TO Start_Process_Pvt ;
164: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
165: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
166: p_data => p_msg_data );
167: --
168: WHEN OTHERS THEN

Line 171: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

167: --
168: WHEN OTHERS THEN
169: --
170: ROLLBACK TO Start_Process_Pvt ;
171: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
172: --
173: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
174: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
175: l_api_name);