[Home] [Help]
52: * @rep:lifecycle active
53: * @rep:displayname Create Repair Order
54: */
55: PROCEDURE Create_Repair_Order(P_Api_Version_Number IN NUMBER,
56: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
57: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
58: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59: P_REPAIR_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
60: P_REPLN_Rec IN CSD_REPAIRS_PUB.REPLN_Rec_Type,
53: * @rep:displayname Create Repair Order
54: */
55: PROCEDURE Create_Repair_Order(P_Api_Version_Number IN NUMBER,
56: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
57: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
58: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59: P_REPAIR_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
60: P_REPLN_Rec IN CSD_REPAIRS_PUB.REPLN_Rec_Type,
61: p_create_default_logistics IN VARCHAR2 := 'N',
54: */
55: PROCEDURE Create_Repair_Order(P_Api_Version_Number IN NUMBER,
56: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
57: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
58: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59: P_REPAIR_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
60: P_REPLN_Rec IN CSD_REPAIRS_PUB.REPLN_Rec_Type,
61: p_create_default_logistics IN VARCHAR2 := 'N',
62: X_REPAIR_LINE_ID OUT NOCOPY NUMBER,
55: PROCEDURE Create_Repair_Order(P_Api_Version_Number IN NUMBER,
56: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
57: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
58: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59: P_REPAIR_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
60: P_REPLN_Rec IN CSD_REPAIRS_PUB.REPLN_Rec_Type,
61: p_create_default_logistics IN VARCHAR2 := 'N',
62: X_REPAIR_LINE_ID OUT NOCOPY NUMBER,
63: X_REPAIR_NUMBER OUT NOCOPY VARCHAR2,
78: --
79: -- Standard Start of API savepoint
80: SAVEPOINT CREATE_REPAIR_ORDER_PUB;
81: -- Standard call to check for call compatibility.
82: IF NOT FND_API.Compatible_API_Call(l_api_version_number,
83: p_api_version_number,
84: l_api_name,
85: G_PKG_NAME)
86: THEN
83: p_api_version_number,
84: l_api_name,
85: G_PKG_NAME)
86: THEN
87: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
88: END IF;
89: -- Initialize message list if p_init_msg_list is set to TRUE.
90: IF FND_API.to_Boolean(p_init_msg_list)
91: THEN
86: THEN
87: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
88: END IF;
89: -- Initialize message list if p_init_msg_list is set to TRUE.
90: IF FND_API.to_Boolean(p_init_msg_list)
91: THEN
92: FND_MSG_PUB.initialize;
93: END IF;
94: -- Initialize API return status to success
91: THEN
92: FND_MSG_PUB.initialize;
93: END IF;
94: -- Initialize API return status to success
95: x_return_status := FND_API.G_RET_STS_SUCCESS;
96: --
97: -- API body
98: --
99: CSD_REPAIRS_PVT.Create_Repair_Order(P_Api_Version_Number => 1.0,
108: X_Msg_Count => x_msg_count,
109: X_Msg_Data => x_msg_data);
110: --
111: -- Check return status from the above procedure call
112: IF not (x_return_status = FND_API.G_RET_STS_SUCCESS)
113: then
114: ROLLBACK TO CREATE_REPAIR_ORDER_PUB;
115: return;
116: END IF;
127: x_msg_count => X_Msg_Count,
128: x_msg_data => X_Msg_Data
129: );
130:
131: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
132: RAISE FND_API.G_EXC_ERROR;
133: END IF;
134:
135: END IF;
128: x_msg_data => X_Msg_Data
129: );
130:
131: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
132: RAISE FND_API.G_EXC_ERROR;
133: END IF;
134:
135: END IF;
136:
137: -- swai: 12.1.1 bug 7176940 - check service bulletins after RO creation
138: IF (nvl(fnd_profile.value('CSD_AUTO_CHECK_BULLETINS'),'N') = 'Y') THEN
139: CSD_RO_BULLETINS_PVT.LINK_BULLETINS_TO_RO(
140: p_api_version_number => 1.0,
141: p_init_msg_list => Fnd_Api.G_FALSE,
142: p_commit => Fnd_Api.G_FALSE,
143: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
144: p_repair_line_id => x_repair_line_id,
145: px_ro_sc_ids_tbl => l_ro_sc_ids_tbl,
138: IF (nvl(fnd_profile.value('CSD_AUTO_CHECK_BULLETINS'),'N') = 'Y') THEN
139: CSD_RO_BULLETINS_PVT.LINK_BULLETINS_TO_RO(
140: p_api_version_number => 1.0,
141: p_init_msg_list => Fnd_Api.G_FALSE,
142: p_commit => Fnd_Api.G_FALSE,
143: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
144: p_repair_line_id => x_repair_line_id,
145: px_ro_sc_ids_tbl => l_ro_sc_ids_tbl,
146: x_return_status => l_return_status,
139: CSD_RO_BULLETINS_PVT.LINK_BULLETINS_TO_RO(
140: p_api_version_number => 1.0,
141: p_init_msg_list => Fnd_Api.G_FALSE,
142: p_commit => Fnd_Api.G_FALSE,
143: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
144: p_repair_line_id => x_repair_line_id,
145: px_ro_sc_ids_tbl => l_ro_sc_ids_tbl,
146: x_return_status => l_return_status,
147: x_msg_count => l_msg_count,
153: --
154: -- End of API body.
155: --
156: -- Standard check for p_commit
157: IF FND_API.to_Boolean(p_commit)
158: THEN
159: COMMIT WORK;
160: END IF;
161: -- Standard call to get message count and if count is 1, get message info.
162: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
163: p_data => x_msg_data);
164: --
165: EXCEPTION
166: WHEN FND_API.G_EXC_ERROR THEN
167: JTF_PLSQL_API.HANDLE_EXCEPTIONS(P_API_NAME => L_API_NAME,
168: P_PKG_NAME => G_PKG_NAME,
169: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
170: P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB,
172: X_MSG_DATA => X_MSG_DATA,
173: X_RETURN_STATUS => X_RETURN_STATUS);
174: -- RAISE;
175: --
176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
177: JTF_PLSQL_API.HANDLE_EXCEPTIONS(P_API_NAME => L_API_NAME,
178: P_PKG_NAME => G_PKG_NAME,
179: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
180: P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB,
195: --
196: End Create_Repair_Order;
197:
198: PROCEDURE Update_Repair_Order(P_Api_Version_Number IN NUMBER,
199: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
200: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
201: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
202: p_REPAIR_LINE_ID IN NUMBER,
203: P_REPLN_Rec IN OUT NOCOPY CSD_REPAIRS_PUB.REPLN_Rec_Type,
196: End Create_Repair_Order;
197:
198: PROCEDURE Update_Repair_Order(P_Api_Version_Number IN NUMBER,
199: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
200: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
201: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
202: p_REPAIR_LINE_ID IN NUMBER,
203: P_REPLN_Rec IN OUT NOCOPY CSD_REPAIRS_PUB.REPLN_Rec_Type,
204: X_Return_Status OUT NOCOPY VARCHAR2,
197:
198: PROCEDURE Update_Repair_Order(P_Api_Version_Number IN NUMBER,
199: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
200: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
201: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
202: p_REPAIR_LINE_ID IN NUMBER,
203: P_REPLN_Rec IN OUT NOCOPY CSD_REPAIRS_PUB.REPLN_Rec_Type,
204: X_Return_Status OUT NOCOPY VARCHAR2,
205: X_Msg_Count OUT NOCOPY NUMBER,
212: --
213: -- Standard Start of API savepoint
214: SAVEPOINT UPDATE_REPAIR_ORDER_PUB;
215: -- Standard call to check for call compatibility.
216: IF NOT FND_API.Compatible_API_Call(l_api_version_number,
217: p_api_version_number,
218: l_api_name,
219: G_PKG_NAME)
220: THEN
217: p_api_version_number,
218: l_api_name,
219: G_PKG_NAME)
220: THEN
221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
222: END IF;
223: -- Initialize message list if p_init_msg_list is set to TRUE.
224: IF FND_API.to_Boolean(p_init_msg_list)
225: THEN
220: THEN
221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
222: END IF;
223: -- Initialize message list if p_init_msg_list is set to TRUE.
224: IF FND_API.to_Boolean(p_init_msg_list)
225: THEN
226: FND_MSG_PUB.initialize;
227: END IF;
228: -- Initialize API return status to SUCCESS
225: THEN
226: FND_MSG_PUB.initialize;
227: END IF;
228: -- Initialize API return status to SUCCESS
229: x_return_status := FND_API.G_RET_STS_SUCCESS;
230: --
231: -- API body
232: --
233: CSD_repairs_PVT.Update_Repair_Order(P_Api_Version_Number => 1.0,
240: X_Msg_Count => x_msg_count,
241: X_Msg_Data => x_msg_data);
242: --
243: -- Check return status from the above procedure call
244: IF not (x_return_status = FND_API.G_RET_STS_SUCCESS)
245: then
246: ROLLBACK TO UPDATE_REPAIR_ORDER_PUB;
247: return;
248: END IF;
249: --
250: -- End of API body.
251: --
252: -- Standard check for p_commit
253: IF FND_API.to_Boolean(p_commit)
254: THEN
255: COMMIT WORK;
256: END IF;
257: -- Standard call to get message count and if count is 1, get message info.
258: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
259: p_data => x_msg_data);
260: --
261: EXCEPTION
262: WHEN FND_API.G_EXC_ERROR THEN
263: JTF_PLSQL_API.HANDLE_EXCEPTIONS(P_API_NAME => L_API_NAME,
264: P_PKG_NAME => G_PKG_NAME,
265: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
266: P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB,
268: X_MSG_DATA => X_MSG_DATA,
269: X_RETURN_STATUS => X_RETURN_STATUS);
270: -- RAISE;
271: --
272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
273: JTF_PLSQL_API.HANDLE_EXCEPTIONS(P_API_NAME => L_API_NAME,
274: P_PKG_NAME => G_PKG_NAME,
275: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
276: P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB,
292:
293: -- bug#12884352
294: PROCEDURE Update_Repair_Type (
295: p_api_version IN NUMBER,
296: p_commit IN VARCHAR2 := fnd_api.g_false,
297: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
298: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
299: x_return_status OUT NOCOPY VARCHAR2,
300: x_msg_count OUT NOCOPY NUMBER,
293: -- bug#12884352
294: PROCEDURE Update_Repair_Type (
295: p_api_version IN NUMBER,
296: p_commit IN VARCHAR2 := fnd_api.g_false,
297: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
298: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
299: x_return_status OUT NOCOPY VARCHAR2,
300: x_msg_count OUT NOCOPY NUMBER,
301: x_msg_data OUT NOCOPY VARCHAR2,
294: PROCEDURE Update_Repair_Type (
295: p_api_version IN NUMBER,
296: p_commit IN VARCHAR2 := fnd_api.g_false,
297: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
298: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
299: x_return_status OUT NOCOPY VARCHAR2,
300: x_msg_count OUT NOCOPY NUMBER,
301: x_msg_data OUT NOCOPY VARCHAR2,
302: p_repair_type_rec IN CSD_REPAIRS_PUB.Repair_Type_Rec_Type,
311: --
312: -- Standard Start of API savepoint
313: SAVEPOINT UPDATE_REPAIR_TYPE_PUB;
314: -- Standard call to check for call compatibility.
315: IF NOT FND_API.Compatible_API_Call(l_api_version_number,
316: p_api_version,
317: l_api_name,
318: G_PKG_NAME)
319: THEN
316: p_api_version,
317: l_api_name,
318: G_PKG_NAME)
319: THEN
320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
321: END IF;
322: -- Initialize message list if p_init_msg_list is set to TRUE.
323: IF FND_API.to_Boolean(p_init_msg_list)
324: THEN
319: THEN
320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
321: END IF;
322: -- Initialize message list if p_init_msg_list is set to TRUE.
323: IF FND_API.to_Boolean(p_init_msg_list)
324: THEN
325: FND_MSG_PUB.initialize;
326: END IF;
327: -- Initialize API return status to success
324: THEN
325: FND_MSG_PUB.initialize;
326: END IF;
327: -- Initialize API return status to success
328: x_return_status := FND_API.G_RET_STS_SUCCESS;
329: --
330: -- API body
331: --
332: CSD_REPAIRS_PVT.UPDATE_REPAIR_TYPE(P_Api_Version => p_api_version,
346: );
347:
348: --
349: -- Check return status from the above procedure call
350: IF not (x_return_status = FND_API.G_RET_STS_SUCCESS)
351: then
352: ROLLBACK TO UPDATE_REPAIR_TYPE_PUB;
353: return;
354: END IF;
355: --
356: -- End of API body.
357: --
358: -- Standard check for p_commit
359: IF FND_API.to_Boolean(p_commit)
360: THEN
361: COMMIT WORK;
362: END IF;
363: -- Standard call to get message count and if count is 1, get message info.
364: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
365: p_data => x_msg_data);
366: --
367: EXCEPTION
368: WHEN Fnd_Api.G_EXC_ERROR THEN
369: x_return_status := Fnd_Api.G_RET_STS_ERROR;
370: ROLLBACK TO UPDATE_REPAIR_TYPE_PUB;
371: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
372: p_data => x_msg_data);
365: p_data => x_msg_data);
366: --
367: EXCEPTION
368: WHEN Fnd_Api.G_EXC_ERROR THEN
369: x_return_status := Fnd_Api.G_RET_STS_ERROR;
370: ROLLBACK TO UPDATE_REPAIR_TYPE_PUB;
371: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
372: p_data => x_msg_data);
373: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
376: 'csd.plsql.CSD_REPAIRS_PUB.Update_Repair_Type',
377: 'EXC_ERROR[' || x_msg_data || ']');
378: END IF;
379:
380: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
381: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
382: ROLLBACK TO UPDATE_REPAIR_TYPE_PUB;
383: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
384: p_data => x_msg_data);
377: 'EXC_ERROR[' || x_msg_data || ']');
378: END IF;
379:
380: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
381: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
382: ROLLBACK TO UPDATE_REPAIR_TYPE_PUB;
383: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
384: p_data => x_msg_data);
385: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
388: 'csd.plsql.CSD_REPAIRS_PUB.Update_Repair_Type',
389: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');
390: END IF;
391: WHEN OTHERS THEN
392: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
393: Rollback TO UPDATE_REPAIR_TYPE_PUB;
394: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
395: THEN
396: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
440: --
441: -- Standard Start of API savepoint
442: SAVEPOINT UPDATE_RO_STATUS_PUB;
443: -- Standard call to check for call compatibility.
444: IF NOT FND_API.Compatible_API_Call(l_api_version_number,
445: p_api_version,
446: l_api_name,
447: G_PKG_NAME)
448: THEN
445: p_api_version,
446: l_api_name,
447: G_PKG_NAME)
448: THEN
449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
450: END IF;
451: -- Initialize message list if p_init_msg_list is set to TRUE.
452: IF FND_API.to_Boolean(p_init_msg_list)
453: THEN
448: THEN
449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
450: END IF;
451: -- Initialize message list if p_init_msg_list is set to TRUE.
452: IF FND_API.to_Boolean(p_init_msg_list)
453: THEN
454: FND_MSG_PUB.initialize;
455: END IF;
456: -- Initialize API return status to success
453: THEN
454: FND_MSG_PUB.initialize;
455: END IF;
456: -- Initialize API return status to success
457: x_return_status := FND_API.G_RET_STS_SUCCESS;
458: --
459: -- API body
460: --
461: CSD_REPAIRS_PVT.UPDATE_RO_STATUS(P_Api_Version => p_api_version,
460: --
461: CSD_REPAIRS_PVT.UPDATE_RO_STATUS(P_Api_Version => p_api_version,
462: P_Commit => p_commit,
463: P_Init_Msg_List => p_init_msg_list,
464: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
465: X_Return_Status => x_return_status,
466: X_Msg_Count => x_msg_count,
467: X_Msg_Data => x_msg_data,
468: P_REPAIR_STATUS_REC => p_repair_status_rec,
469: P_STATUS_CONTROL_REC => p_status_upd_control_rec,
470: X_OBJECT_VERSION_NUMBER => x_object_Version_number);
471: --
472: -- Check return status from the above procedure call
473: IF not (x_return_status = FND_API.G_RET_STS_SUCCESS)
474: then
475: ROLLBACK TO UPDATE_RO_STATUS_PUB;
476: return;
477: END IF;
478: --
479: -- End of API body.
480: --
481: -- Standard check for p_commit
482: IF FND_API.to_Boolean(p_commit)
483: THEN
484: COMMIT WORK;
485: END IF;
486: -- Standard call to get message count and if count is 1, get message info.
487: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
488: p_data => x_msg_data);
489: --
490: EXCEPTION
491: WHEN Fnd_Api.G_EXC_ERROR THEN
492: x_return_status := Fnd_Api.G_RET_STS_ERROR;
493: ROLLBACK TO UPDATE_RO_STATUS_PUB;
494: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
495: p_data => x_msg_data);
488: p_data => x_msg_data);
489: --
490: EXCEPTION
491: WHEN Fnd_Api.G_EXC_ERROR THEN
492: x_return_status := Fnd_Api.G_RET_STS_ERROR;
493: ROLLBACK TO UPDATE_RO_STATUS_PUB;
494: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
495: p_data => x_msg_data);
496: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
499: 'csd.plsql.CSD_REPAIRS_PUB.Update_ro_status',
500: 'EXC_ERROR[' || x_msg_data || ']');
501: END IF;
502:
503: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
504: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
505: ROLLBACK TO UPDATE_RO_STATUS_PUB;
506: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
507: p_data => x_msg_data);
500: 'EXC_ERROR[' || x_msg_data || ']');
501: END IF;
502:
503: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
504: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
505: ROLLBACK TO UPDATE_RO_STATUS_PUB;
506: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
507: p_data => x_msg_data);
508: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
511: 'csd.plsql.CSD_REPAIRS_PUB.Update_ro_status',
512: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');
513: END IF;
514: WHEN OTHERS THEN
515: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
516: Rollback TO UPDATE_RO_STATUS_PUB;
517: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
518: THEN
519: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);