DBA Data[Home] [Help]

APPS.CSD_REPAIRS_PUB dependencies on CSD_REPAIRS_PUB

Line 1: PACKAGE BODY CSD_REPAIRS_PUB as

1: PACKAGE BODY CSD_REPAIRS_PUB as
2: /* $Header: csdpdrab.pls 120.15 2011/12/02 06:46:56 vicli ship $ */
3: /*#
4: * This is the public interface for the Depot Repair API. It allows
5: * execution of various Depot Repair APIs.

Line 13: -- Package name : CSD_REPAIRS_PUB

9: * @rep:lifecycle active
10: * @rep:category BUSINESS_ENTITY CSD_REPAIR_ORDER
11: */
12: --
13: -- Package name : CSD_REPAIRS_PUB
14: -- Purpose : This package contains the public APIs for creating
15: -- and updating repair orders.
16: -- History :
17: -- Version Date Name Description

Line 33: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_REPAIRS_PUB';

29: -- Update_Repair_Order
30: --
31: -- NOTE :
32: --
33: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_REPAIRS_PUB';
34: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdpdrab.pls';
35: g_debug NUMBER := csd_gen_utility_pvt.g_debug_level;
36: --
37: /*#

Line 60: P_REPLN_Rec IN CSD_REPAIRS_PUB.REPLN_Rec_Type,

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,
64: X_Return_Status OUT NOCOPY VARCHAR2,

Line 203: P_REPLN_Rec IN OUT NOCOPY CSD_REPAIRS_PUB.REPLN_Rec_Type,

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,
206: X_Msg_Data OUT NOCOPY VARCHAR2) IS
207: --

Line 302: p_repair_type_rec IN CSD_REPAIRS_PUB.Repair_Type_Rec_Type,

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,
303: x_object_version_number OUT NOCOPY NUMBER
304: ) IS
305:
306: --

Line 376: 'csd.plsql.CSD_REPAIRS_PUB.Update_Repair_Type',

372: p_data => x_msg_data);
373: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
374: THEN
375: Fnd_Log.STRING(Fnd_Log.level_error,
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

Line 388: 'csd.plsql.CSD_REPAIRS_PUB.Update_Repair_Type',

384: p_data => x_msg_data);
385: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
386: THEN
387: Fnd_Log.STRING(Fnd_Log.level_exception,
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;

Line 403: 'csd.plsql.CSD_REPAIRS_PUB.Update_Repair_Type',

399: p_data => x_msg_data);
400: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
401: THEN
402: Fnd_Log.STRING(Fnd_Log.level_exception,
403: 'csd.plsql.CSD_REPAIRS_PUB.Update_Repair_Type',
404: 'SQL MEssage[' || SQLERRM || ']');
405: END IF;
406:
407: End Update_Repair_Type;

Line 499: 'csd.plsql.CSD_REPAIRS_PUB.Update_ro_status',

495: p_data => x_msg_data);
496: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
497: THEN
498: Fnd_Log.STRING(Fnd_Log.level_error,
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

Line 511: 'csd.plsql.CSD_REPAIRS_PUB.Update_ro_status',

507: p_data => x_msg_data);
508: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
509: THEN
510: Fnd_Log.STRING(Fnd_Log.level_exception,
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;

Line 526: 'csd.plsql.CSD_REPAIRS_PUB.Update_ro_status',

522: p_data => x_msg_data);
523: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
524: THEN
525: Fnd_Log.STRING(Fnd_Log.level_exception,
526: 'csd.plsql.CSD_REPAIRS_PUB.Update_ro_status',
527: 'SQL MEssage[' || SQLERRM || ']');
528: END IF;
529:
530: End Update_ro_status;

Line 532: End CSD_REPAIRS_PUB;

528: END IF;
529:
530: End Update_ro_status;
531: -- R12 Development End
532: End CSD_REPAIRS_PUB;