DBA Data[Home] [Help]

APPS.CSD_LOGISTICS_PUB dependencies on FND_API

Line 42: p_commit IN VARCHAR2 := fnd_api.g_false,

38: * @rep:displayname Create Logistics Line
39: */
40: PROCEDURE Create_Logistics_Line(
41: p_api_version IN NUMBER,
42: p_commit IN VARCHAR2 := fnd_api.g_false,
43: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
44: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
45: x_return_status OUT NOCOPY VARCHAR2,
46: x_msg_count OUT NOCOPY NUMBER,

Line 43: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

39: */
40: PROCEDURE Create_Logistics_Line(
41: p_api_version IN NUMBER,
42: p_commit IN VARCHAR2 := fnd_api.g_false,
43: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
44: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
45: x_return_status OUT NOCOPY VARCHAR2,
46: x_msg_count OUT NOCOPY NUMBER,
47: x_msg_data OUT NOCOPY VARCHAR2,

Line 44: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

40: PROCEDURE Create_Logistics_Line(
41: p_api_version IN NUMBER,
42: p_commit IN VARCHAR2 := fnd_api.g_false,
43: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
44: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
45: x_return_status OUT NOCOPY VARCHAR2,
46: x_msg_count OUT NOCOPY NUMBER,
47: x_msg_data OUT NOCOPY VARCHAR2,
48: p_product_txn_rec IN OUT NOCOPY csd_process_pvt.product_txn_rec,

Line 69: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

65: p_product_txn_rec => p_product_txn_rec,
66: p_add_to_order_flag => p_add_to_order_flag
67: );
68:
69: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
70: RAISE FND_API.G_EXC_ERROR;
71: END IF;
72:
73: End Create_Logistics_Line;

Line 70: RAISE FND_API.G_EXC_ERROR;

66: p_add_to_order_flag => p_add_to_order_flag
67: );
68:
69: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
70: RAISE FND_API.G_EXC_ERROR;
71: END IF;
72:
73: End Create_Logistics_Line;
74:

Line 91: p_commit IN VARCHAR2 := fnd_api.g_false,

87: * @rep:displayname Create Default Logitics Lines.
88: */
89: PROCEDURE Create_Default_Logistics
90: ( p_api_version IN NUMBER,
91: p_commit IN VARCHAR2 := fnd_api.g_false,
92: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
93: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
94: p_repair_line_id IN NUMBER,
95: x_return_status OUT NOCOPY VARCHAR2,

Line 92: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

88: */
89: PROCEDURE Create_Default_Logistics
90: ( p_api_version IN NUMBER,
91: p_commit IN VARCHAR2 := fnd_api.g_false,
92: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
93: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
94: p_repair_line_id IN NUMBER,
95: x_return_status OUT NOCOPY VARCHAR2,
96: x_msg_count OUT NOCOPY NUMBER,

Line 93: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

89: PROCEDURE Create_Default_Logistics
90: ( p_api_version IN NUMBER,
91: p_commit IN VARCHAR2 := fnd_api.g_false,
92: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
93: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
94: p_repair_line_id IN NUMBER,
95: x_return_status OUT NOCOPY VARCHAR2,
96: x_msg_count OUT NOCOPY NUMBER,
97: x_msg_data OUT NOCOPY VARCHAR2

Line 117: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

113: x_msg_count => x_msg_count,
114: x_msg_data => x_msg_data
115: );
116:
117: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
118: RAISE FND_API.G_EXC_ERROR;
119: END IF;
120:
121: End Create_Default_Logistics;

Line 118: RAISE FND_API.G_EXC_ERROR;

114: x_msg_data => x_msg_data
115: );
116:
117: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
118: RAISE FND_API.G_EXC_ERROR;
119: END IF;
120:
121: End Create_Default_Logistics;
122:

Line 158: IF NOT FND_API.Compatible_API_Call(l_api_version_number,

154: --
155: -- Standard Start of API savepoint
156: SAVEPOINT UPDATE_LOGISTICS_LINE_PUB;
157: -- Standard call to check for call compatibility.
158: IF NOT FND_API.Compatible_API_Call(l_api_version_number,
159: p_api_version,
160: l_api_name,
161: G_PKG_NAME)
162: THEN

Line 163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

159: p_api_version,
160: l_api_name,
161: G_PKG_NAME)
162: THEN
163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
164: END IF;
165: -- Initialize message list if p_init_msg_list is set to TRUE.
166: IF FND_API.to_Boolean(p_init_msg_list)
167: THEN

Line 166: IF FND_API.to_Boolean(p_init_msg_list)

162: THEN
163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
164: END IF;
165: -- Initialize message list if p_init_msg_list is set to TRUE.
166: IF FND_API.to_Boolean(p_init_msg_list)
167: THEN
168: FND_MSG_PUB.initialize;
169: END IF;
170: -- Initialize API return status to success

Line 171: x_return_status := FND_API.G_RET_STS_SUCCESS;

167: THEN
168: FND_MSG_PUB.initialize;
169: END IF;
170: -- Initialize API return status to success
171: x_return_status := FND_API.G_RET_STS_SUCCESS;
172: --
173: -- API body
174: --
175: CSD_LOGISTICS_PVT.Update_Logistics_Line(P_Api_Version => p_api_version,

Line 178: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

174: --
175: CSD_LOGISTICS_PVT.Update_Logistics_Line(P_Api_Version => p_api_version,
176: P_Commit => p_commit,
177: P_Init_Msg_List => p_init_msg_list,
178: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
179: X_Return_Status => x_return_status,
180: X_Msg_Count => x_msg_count,
181: X_Msg_Data => x_msg_data,
182: P_UPD_PRODTXN_REC => p_Upd_ProdTxn_Rec,

Line 188: IF not (x_return_status = FND_API.G_RET_STS_SUCCESS)

184: X_ORDER_HEADER_ID => x_order_header_id,
185: X_ORDER_LINE_ID => x_order_line_id);
186: --
187: -- Check return status from the above procedure call
188: IF not (x_return_status = FND_API.G_RET_STS_SUCCESS)
189: then
190: ROLLBACK TO UPDATE_LOGISTICS_LINE_PUB;
191: return;
192: END IF;

Line 197: IF FND_API.to_Boolean(p_commit)

193: --
194: -- End of API body.
195: --
196: -- Standard check for p_commit
197: IF FND_API.to_Boolean(p_commit)
198: THEN
199: COMMIT WORK;
200: END IF;
201: -- Standard call to get message count and if count is 1, get message info.

Line 206: WHEN Fnd_Api.G_EXC_ERROR THEN

202: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
203: p_data => x_msg_data);
204: --
205: EXCEPTION
206: WHEN Fnd_Api.G_EXC_ERROR THEN
207: x_return_status := Fnd_Api.G_RET_STS_ERROR;
208: ROLLBACK TO UPDATE_LOGISTICS_LINE_PUB;
209: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
210: p_data => x_msg_data);

Line 207: x_return_status := Fnd_Api.G_RET_STS_ERROR;

203: p_data => x_msg_data);
204: --
205: EXCEPTION
206: WHEN Fnd_Api.G_EXC_ERROR THEN
207: x_return_status := Fnd_Api.G_RET_STS_ERROR;
208: ROLLBACK TO UPDATE_LOGISTICS_LINE_PUB;
209: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
210: p_data => x_msg_data);
211: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)

Line 218: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

214: 'csd.plsql.csd_logistics_pub.update_logistics_pub',
215: 'EXC_ERROR[' || x_msg_data || ']');
216: END IF;
217:
218: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
219: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
220: ROLLBACK TO UPDATE_LOGISTICS_LINE_PUB;
221: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
222: p_data => x_msg_data);

Line 219: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

215: 'EXC_ERROR[' || x_msg_data || ']');
216: END IF;
217:
218: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
219: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
220: ROLLBACK TO UPDATE_LOGISTICS_LINE_PUB;
221: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
222: p_data => x_msg_data);
223: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)

Line 230: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

226: 'csd.plsql.csd_logistics_pub.update_logistics_pub',
227: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');
228: END IF;
229: WHEN OTHERS THEN
230: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
231: Rollback TO UPDATE_LOGISTICS_LINE_PUB;
232: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
233: THEN
234: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);