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.CSD_REPAIRS_PVT dependencies on CSD_REPAIRS_PVT

Line 1: Package BODY Csd_Repairs_Pvt AS

1: Package BODY Csd_Repairs_Pvt AS
2: /* $Header: csdvdrab.pls 120.25.12010000.5 2008/12/19 02:01:43 swai ship $ */
3: --
4: -- Package name : CSD_REPAIRS_PVT
5: -- Purpose : This package contains the private APIs for creating,

Line 4: -- Package name : CSD_REPAIRS_PVT

1: Package BODY Csd_Repairs_Pvt AS
2: /* $Header: csdvdrab.pls 120.25.12010000.5 2008/12/19 02:01:43 swai ship $ */
3: --
4: -- Package name : CSD_REPAIRS_PVT
5: -- Purpose : This package contains the private APIs for creating,
6: -- updating, deleting repair orders. Access is
7: -- restricted to Oracle Depot Rapair Internal Development.
8: -- History :

Line 43: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_REPAIRS_PVT';

39: -- validate ib_ref_number when repair type is refurbished.
40: -- 115.45 05/19/05 vparvath Adding update_ro_Status API for R12 development.
41: -- 08/15/06 rfieldma Adding new error messages for update repair type and update repair status.
42: -- procedures update_repair_type, update_flow_status
43: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_REPAIRS_PVT';
44: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdvdrab.pls';
45: g_debug NUMBER := Csd_Gen_Utility_Pvt.g_debug_level;
46: --
47:

Line 3084: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',

3080: SAVEPOINT copy_Attachments;
3081:
3082: IF(Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level) THEN
3083: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3084: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3085: 'Entered Copy_Attachments API');
3086: END IF;
3087:
3088: -- Standard call to check for call compatibility.

Line 3107: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',

3103: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3104:
3105: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3106: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3107: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3108: 'Validate Original Repair line id = '||p_original_ro_id);
3109: END IF;
3110:
3111: IF NOT (Csd_Process_Util.Validate_rep_line_id

Line 3118: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',

3114: END IF;
3115:
3116: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3117: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3118: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3119: 'Validation of Original Repair line id completed successfully');
3120: END IF;
3121:
3122: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN

Line 3124: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',

3120: END IF;
3121:
3122: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3123: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3124: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3125: 'Validate New Repair line id = '||p_new_ro_id);
3126: END IF;
3127:
3128: IF NOT (Csd_Process_Util.Validate_rep_line_id

Line 3135: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',

3131: END IF;
3132:
3133: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3134: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3135: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3136: 'Validation of New Repair line id completed successfully');
3137: END IF;
3138:
3139: -- Begin API Body

Line 3145: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',

3141: -- the from_entity (Original Repair Order)
3142:
3143: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3144: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3145: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3146: 'Open main cursor');
3147: END IF;
3148:
3149: IF(Fnd_Log.Level_Event >= Fnd_Log.G_Current_Runtime_Level) THEN

Line 3151: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',

3147: END IF;
3148:
3149: IF(Fnd_Log.Level_Event >= Fnd_Log.G_Current_Runtime_Level) THEN
3150: Fnd_Log.STRING(Fnd_Log.Level_Event,
3151: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3152: 'Started Copying of Attachments ');
3153: END IF;
3154:
3155:

Line 3160: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',

3156: FOR docrec IN doclist LOOP
3157:
3158: IF ( Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3159: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3160: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3161: 'Main cursor - Datatype id = '||docrec.datatype_id);
3162:
3163: END IF;
3164:

Line 3176: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',

3172: -- Create Documents records
3173:
3174: IF ( Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level ) THEN
3175: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3176: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3177: 'Calling the FND_DOCUMENTS_PKG.Insert_Row');
3178: END IF;
3179:
3180: Fnd_Documents_Pkg.Insert_Row(l_row_id_tmp,

Line 3236: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',

3232: CLOSE shorttext;
3233:
3234: IF ( Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3235: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3236: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3237: 'Inserting into fnd_documents_short_text for
3238: document id = '||docrec.document_id);
3239: END IF;
3240:

Line 3259: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',

3255: CLOSE longtext;
3256:
3257: IF ( Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3258: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3259: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3260: 'Inserting into fnd_documents_long_text for
3261: document id = '||docrec.document_id);
3262: END IF;
3263:

Line 3292: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',

3288: CLOSE fnd_lobs_cur;
3289:
3290: IF ( Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3291: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3292: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3293: 'Inserting into fnd_lobs for
3294: document id = '||docrec.document_id);
3295: END IF;
3296:

Line 3331: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',

3327:
3328:
3329: IF ( Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3330: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3331: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3332: 'Inserting into fnd_attached_documents for
3333: document id = '||docrec.document_id);
3334: END IF;
3335:

Line 3428: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',

3424: p_data => x_msg_data);
3425:
3426: IF ( Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3427: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3428: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3429: 'Copy Attachments completed successfully ');
3430: END IF;
3431:
3432: EXCEPTION

Line 3442: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',

3438: p_data => x_msg_data
3439: );
3440: IF ( Fnd_Log.LEVEL_ERROR >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
3441: Fnd_Log.STRING(Fnd_Log.LEVEL_ERROR,
3442: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3443: 'EXC_ERROR ['||x_msg_data||']');
3444: END IF;
3445:
3446: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 3454: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',

3450: p_data => x_msg_data );
3451:
3452: IF ( Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
3453: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,
3454: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3455: 'EXC_UNEXPECTED_ERROR ['||x_msg_data||']');
3456: END IF;
3457:
3458: WHEN OTHERS THEN

Line 3471: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',

3467: p_data => x_msg_data );
3468:
3469: IF ( Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
3470: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,
3471: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3472: 'SQL Message ['||SQLERRM||']');
3473: END IF;
3474:
3475: END Copy_Attachments;

Line 3518: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',

3514: SAVEPOINT Delete_Attachments;
3515:
3516: IF(Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level) THEN
3517: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3518: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3519: 'Entered Delete_Attachments API');
3520: END IF;
3521:
3522: -- Standard call to check for call compatibility.

Line 3541: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',

3537: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3538:
3539: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3540: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3541: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3542: 'Validate Repair line id = '||p_repair_line_id);
3543: END IF;
3544:
3545: IF NOT (Csd_Process_Util.Validate_rep_line_id

Line 3552: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',

3548: END IF;
3549:
3550: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3551: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3552: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3553: 'Validation of Repair line id completed successfully');
3554: END IF;
3555:
3556: --

Line 3563: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',

3559:
3560: -- Delete from FND_DOCUMENTS_SHORT_TEXT table
3561: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3562: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3563: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3564: 'Deleting from fnd_documents_short_text');
3565: END IF;
3566:
3567: IF(Fnd_Log.Level_Event >= Fnd_Log.G_Current_Runtime_Level) THEN

Line 3569: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',

3565: END IF;
3566:
3567: IF(Fnd_Log.Level_Event >= Fnd_Log.G_Current_Runtime_Level) THEN
3568: Fnd_Log.STRING(Fnd_Log.Level_Event,
3569: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3570: 'Started Deleting of Attachments');
3571: END IF;
3572:
3573:

Line 3589: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',

3585:
3586: -- Delete from FND_DOCUMENTS_LONG_TEXT table
3587: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3588: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3589: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3590: 'Deleting from fnd_documents_long_text');
3591: END IF;
3592:
3593: DELETE FROM fnd_documents_long_text

Line 3608: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',

3604:
3605: -- Delete from FND_DOCUMENTS_LONG_RAW table
3606: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3607: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3608: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3609: 'Deleting from fnd_documents_long_raw');
3610: END IF;
3611:
3612: DELETE FROM fnd_documents_long_raw

Line 3628: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',

3624:
3625: -- Delete from FND_LOBS table
3626: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3627: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3628: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3629: 'Deleting from fnd_lobs');
3630: END IF;
3631:
3632: DELETE FROM fnd_lobs

Line 3647: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',

3643:
3644: -- Delete from FND_DOCUMENTS_TL table
3645: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3646: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3647: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3648: 'Deleting from fnd_documents_tl');
3649: END IF;
3650:
3651: DELETE FROM fnd_documents_tl

Line 3662: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',

3658:
3659: -- Delete from FND_DOCUMENTS table
3660: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3661: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3662: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3663: 'Deleting from fnd_documents');
3664: END IF;
3665:
3666: DELETE FROM fnd_documents

Line 3676: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',

3672:
3673: -- delete from FND_ATTACHED_DOCUMENTS table
3674: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3675: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3676: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3677: 'Deleting from fnd_attached_documents');
3678: END IF;
3679:
3680: DELETE FROM fnd_attached_documents fad

Line 3697: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',

3693: p_data => x_msg_data);
3694:
3695: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3696: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3697: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3698: 'Delete_Attachments completed successfully');
3699: END IF;
3700:
3701: EXCEPTION

Line 3711: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',

3707: p_data => x_msg_data
3708: );
3709: IF ( Fnd_Log.LEVEL_ERROR >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
3710: Fnd_Log.STRING(Fnd_Log.LEVEL_ERROR,
3711: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3712: 'EXC_ERROR ['||x_msg_data||']');
3713: END IF;
3714:
3715: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 3723: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',

3719: p_data => x_msg_data );
3720:
3721: IF ( Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
3722: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,
3723: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3724: 'EXC_UNEXPECTED_ERROR ['||x_msg_data||']');
3725: END IF;
3726:
3727: WHEN OTHERS THEN

Line 3740: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',

3736: p_data => x_msg_data );
3737:
3738: IF ( Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
3739: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,
3740: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3741: 'SQL Message ['||SQLERRM||']');
3742: END IF;
3743:
3744:

Line 3819: 'csd.plsql.csd_repairs_pvt.update_ro_status.begin',

3815: BEGIN
3816: --------------------Standard stuff -------------------------
3817: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level) THEN
3818: Fnd_Log.STRING (Fnd_Log.level_procedure,
3819: 'csd.plsql.csd_repairs_pvt.update_ro_status.begin',
3820: 'Entering update_ro_status private api');
3821: END IF;
3822: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
3823: Fnd_Msg_Pub.initialize;

Line 3837: 'csd.plsql.csd_repairs_pvt.update_ro_status',

3833:
3834: ------------Convert Values to Id----------------------------------------------
3835: IF (Fnd_Log.level_event >= Fnd_Log.g_current_runtime_level) THEN
3836: Fnd_Log.STRING (Fnd_Log.level_event,
3837: 'csd.plsql.csd_repairs_pvt.update_ro_status',
3838: '-----step 1: Value to Id conversion');
3839: END IF;
3840: Csd_Repairs_Util.Convert_Status_Val_To_Id(p_repair_status_rec,
3841: l_repair_status_rec,

Line 3847: 'csd.plsql.csd_repairs_pvt.update_ro_status',

3843:
3844: ------------Default/Validate Input parameters----------------------------------------------
3845: IF (Fnd_Log.level_event >= Fnd_Log.g_current_runtime_level) THEN
3846: Fnd_Log.STRING (Fnd_Log.level_event,
3847: 'csd.plsql.csd_repairs_pvt.update_ro_status',
3848: '-----step 2: Validate input ');
3849: END IF;
3850:
3851: IF (Fnd_Log.level_event >= Fnd_Log.g_current_runtime_level) THEN

Line 3853: 'csd.plsql.csd_repairs_pvt.update_ro_status',

3849: END IF;
3850:
3851: IF (Fnd_Log.level_event >= Fnd_Log.g_current_runtime_level) THEN
3852: Fnd_Log.STRING (Fnd_Log.level_event,
3853: 'csd.plsql.csd_repairs_pvt.update_ro_status',
3854: '-----step 3: get required repair order values for update private api,ro['
3855: ||l_repair_status_rec.repair_line_id||'],status['
3856: ||l_repair_status_rec.repair_status||']');
3857:

Line 3882: 'csd.plsql.csd_repairs_pvt.update_ro_status',

3878: CLOSE flow_stat_cur;
3879:
3880: IF (Fnd_Log.level_event >= Fnd_Log.g_current_runtime_level) THEN
3881: Fnd_Log.STRING (Fnd_Log.level_event,
3882: 'csd.plsql.csd_repairs_pvt.update_ro_status',
3883: '-----step 4: Checking for open jobs/tasks,ro['
3884: ||l_repair_status_rec.repair_line_id||'],state['
3885: ||l_repair_status_rec.repair_state||']');
3886: END IF;

Line 3911: 'csd.plsql.csd_repairs_pvt.update_ro_status',

3907: ------------Call other private api to perform the status update------------------------------
3908: /*----------------------Vinay says the api update_flow_Status has logic to close ro status.*/
3909: IF (Fnd_Log.level_event >= Fnd_Log.g_current_runtime_level) THEN
3910: Fnd_Log.STRING (Fnd_Log.level_event,
3911: 'csd.plsql.csd_repairs_pvt.update_ro_status',
3912: '-----step 5a: Calling another private api to validate and update status');
3913: END IF;
3914: Csd_Repairs_Pvt.UPDATE_FLOW_STATUS (
3915: p_api_version => 1.0,

Line 3914: Csd_Repairs_Pvt.UPDATE_FLOW_STATUS (

3910: Fnd_Log.STRING (Fnd_Log.level_event,
3911: 'csd.plsql.csd_repairs_pvt.update_ro_status',
3912: '-----step 5a: Calling another private api to validate and update status');
3913: END IF;
3914: Csd_Repairs_Pvt.UPDATE_FLOW_STATUS (
3915: p_api_version => 1.0,
3916: p_commit => Fnd_api.g_false,
3917: p_init_msg_list => Fnd_Api.g_false,
3918: p_validation_level => Fnd_Api.g_valid_level_full,

Line 3951: 'csd.plsql.csd_repairs_pvt.update_ro_status',

3947: Fnd_Msg_Pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3948:
3949: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level) THEN
3950: Fnd_Log.STRING (Fnd_Log.level_procedure,
3951: 'csd.plsql.csd_repairs_pvt.update_ro_status',
3952: 'Leaving update_ro_Status private api');
3953: END IF;
3954:
3955: EXCEPTION

Line 3963: 'csd.plsql.csd_repairs_pvt.update_ro_status',

3959: ROLLBACK TO update_ro_status_pvt;
3960: Fnd_Msg_Pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3961: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level) THEN
3962: Fnd_Log.STRING (Fnd_Log.level_error,
3963: 'csd.plsql.csd_repairs_pvt.update_ro_status',
3964: 'EXC_ERROR[' || x_msg_data || ']');
3965: END IF;
3966: WHEN Fnd_Api.g_exc_unexpected_error
3967: THEN

Line 3974: 'csd.plsql.csd_repairs_pvt.update_ro_status',

3970: Fnd_Msg_Pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3971:
3972: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level) THEN
3973: Fnd_Log.STRING (Fnd_Log.level_exception,
3974: 'csd.plsql.csd_repairs_pvt.update_ro_status',
3975: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');
3976: END IF;
3977: WHEN OTHERS
3978: THEN

Line 3990: 'csd.plsql.csd_repairs_pvt.update_ro_status',

3986: Fnd_Msg_Pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3987:
3988: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level) THEN
3989: Fnd_Log.STRING (Fnd_Log.level_exception,
3990: 'csd.plsql.csd_repairs_pvt.update_ro_status',
3991: 'SQL MEssage[' || SQLERRM || ']');
3992: END IF;
3993: END UPDATE_RO_STATUS;
3994:

Line 4015: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.CSD_REPAIRS_PVT.update_flow_status';

4011: x_object_version_number OUT NOCOPY NUMBER
4012: ) IS
4013:
4014: -- CONSTANTS --
4015: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.CSD_REPAIRS_PVT.update_flow_status';
4016: lc_api_name CONSTANT VARCHAR2(30) := 'Update_Flow_Status';
4017: lc_api_version CONSTANT NUMBER := 1.0;
4018: lc_update_fs_event_code CONSTANT VARCHAR2(5) := 'SC';
4019: lc_status_code_closed CONSTANT VARCHAR2(1) := 'C';

Line 4602: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.CSD_REPAIRS_PVT.Is_Rt_Update_Allowed';

4598: p_responsibility_id IN NUMBER
4599: ) RETURN BOOLEAN IS
4600:
4601: -- CONSTANTS --
4602: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.CSD_REPAIRS_PVT.Is_Rt_Update_Allowed';
4603: lc_api_name CONSTANT VARCHAR2(30) := 'Is_Rt_Update_Allowed';
4604:
4605: -- VARIABLES --
4606: l_dummy VARCHAR2(1) := NULL;

Line 4689: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.CSD_REPAIRS_PVT.update_repair_type';

4685: x_object_version_number OUT NOCOPY NUMBER
4686: ) IS
4687:
4688: -- CONSTANTS --
4689: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.CSD_REPAIRS_PVT.update_repair_type';
4690: lc_api_name CONSTANT VARCHAR2(30) := 'Update_Repair_Type';
4691: lc_api_version CONSTANT NUMBER := 1.0;
4692: lc_update_rt_event_code CONSTANT VARCHAR2(5) := 'RTU';
4693:

Line 5125: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.CSD_REPAIRS_PVT.Is_Flwsts_Update_Allowed';

5121: p_responsibility_id IN NUMBER
5122: ) RETURN BOOLEAN IS
5123:
5124: -- CONSTANTS --
5125: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.CSD_REPAIRS_PVT.Is_Flwsts_Update_Allowed';
5126: lc_api_name CONSTANT VARCHAR2(30) := 'Is_Flwsts_Update_Allowed';
5127:
5128: -- VARIABLES --
5129: l_dummy VARCHAR2(1) := NULL;

Line 5207: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.CSD_REPAIRS_PVT.launch_flwsts_wf';

5203: p_flwsts_wf_rec IN Flwsts_Wf_Rec_Type
5204: ) IS
5205:
5206: -- CONSTANTS --
5207: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.CSD_REPAIRS_PVT.launch_flwsts_wf';
5208: lc_api_name CONSTANT VARCHAR2(30) := 'Launch_Flwsts_Wf';
5209: lc_api_version CONSTANT NUMBER := 1.0;
5210:
5211: -- For setting WF engine threshold

Line 5532: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repairs_pvt.update_ro_status_websrvc';

5528: l_status_upd_control_rec Csd_Repairs_Pub.STATUS_UPD_CONTROL_REC_TYPE;
5529: l_object_Version_number NUMBER;
5530: l_return_status VARCHAR2(1);
5531:
5532: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repairs_pvt.update_ro_status_websrvc';
5533: lc_api_name CONSTANT VARCHAR2(30) := 'update_ro_status_websrvc';
5534: lc_api_version CONSTANT NUMBER := 1.0;
5535:
5536: BEGIN

Line 5585: Csd_Repairs_Pvt.UPDATE_RO_STATUS(P_Api_Version => p_api_version,

5581:
5582: l_status_upd_control_rec.check_task_wip := p_check_task_wip;
5583:
5584: --debug('calling update_ro_status private api');
5585: Csd_Repairs_Pvt.UPDATE_RO_STATUS(P_Api_Version => p_api_version,
5586: P_Commit => p_commit,
5587: P_Init_Msg_List => p_init_msg_list,
5588: P_Validation_Level => Fnd_Api.G_VALID_LEVEL_FULL,
5589: X_Return_Status => x_return_status,

Line 5843: CSD_REPAIRS_PVT.LAUNCH_WFEXCEPTION_BEVENT(

5839: resultout := 'COMPLETE:ERROR';
5840:
5841: l_module_name := 'UPDATE_RO_STATUS';
5842:
5843: CSD_REPAIRS_PVT.LAUNCH_WFEXCEPTION_BEVENT(
5844: p_return_status => l_return_status,
5845: p_msg_count => l_msg_count,
5846: p_msg_data => l_msg_data,
5847: p_repair_line_id => l_repair_line_id,

Line 5860: WF_CORE.CONTEXT('CSD_REPAIRS_PVT','UPDATE_RO_STATUS_WF',itemtype,

5856: END IF;
5857:
5858: EXCEPTION
5859: WHEN OTHERS THEN
5860: WF_CORE.CONTEXT('CSD_REPAIRS_PVT','UPDATE_RO_STATUS_WF',itemtype,
5861: itemkey,to_char(actid),funcmode);
5862: raise;
5863: END;
5864:

Line 5969: END Csd_Repairs_Pvt;

5965: commit;
5966:
5967: END;
5968:
5969: END Csd_Repairs_Pvt;