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 FND_LOG

Line 585: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

581: x_REPAIR_LINE_ID := l_REPAIR_LINE_ID;
582: x_REPAIR_NUMBER := l_REPAIR_NUMBER;
583:
584: -- START bug#13698799 auto create ro, parent ro
585: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
586: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, 'CSD.PLSQL.csd_repairs_pvt.create_repair_order',
587: 'Calling Repair History to log activity');
588: END IF;
589:

Line 586: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, 'CSD.PLSQL.csd_repairs_pvt.create_repair_order',

582: x_REPAIR_NUMBER := l_REPAIR_NUMBER;
583:
584: -- START bug#13698799 auto create ro, parent ro
585: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
586: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, 'CSD.PLSQL.csd_repairs_pvt.create_repair_order',
587: 'Calling Repair History to log activity');
588: END IF;
589:
590: IF l_REPLN_Rec.parent_repair_line_id is not null and l_REPLN_Rec.parent_repair_line_id <> FND_API.G_MISS_NUM THEN

Line 647: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

643: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
644: END IF;
645:
646: IF l_REPLN_Rec.parent_repair_line_id is not NULL and l_REPLN_Rec.parent_repair_line_id <> FND_API.G_MISS_NUM THEN
647: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
648: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, 'CSD.PLSQL.csd_repairs_pvt.create_repair_order',
649: 'Calling Repair History to log activity for parent RO');
650: END IF;
651:

Line 648: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, 'CSD.PLSQL.csd_repairs_pvt.create_repair_order',

644: END IF;
645:
646: IF l_REPLN_Rec.parent_repair_line_id is not NULL and l_REPLN_Rec.parent_repair_line_id <> FND_API.G_MISS_NUM THEN
647: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
648: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, 'CSD.PLSQL.csd_repairs_pvt.create_repair_order',
649: 'Calling Repair History to log activity for parent RO');
650: END IF;
651:
652: -- log an activity on the newly created repair order

Line 3380: l_debug_level NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;

3376: l_long_text_tmp LONG;
3377: l_fnd_lobs_rec fnd_lobs_cur%ROWTYPE;
3378: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Attachments';
3379: l_api_version CONSTANT NUMBER := 1.0;
3380: l_debug_level NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
3381: l_procedure_level NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3382: l_statement_level NUMBER := Fnd_Log.LEVEL_STATEMENT;
3383: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;
3384:

Line 3381: l_procedure_level NUMBER := Fnd_Log.LEVEL_PROCEDURE;

3377: l_fnd_lobs_rec fnd_lobs_cur%ROWTYPE;
3378: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Attachments';
3379: l_api_version CONSTANT NUMBER := 1.0;
3380: l_debug_level NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
3381: l_procedure_level NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3382: l_statement_level NUMBER := Fnd_Log.LEVEL_STATEMENT;
3383: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;
3384:
3385: BEGIN

Line 3382: l_statement_level NUMBER := Fnd_Log.LEVEL_STATEMENT;

3378: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Attachments';
3379: l_api_version CONSTANT NUMBER := 1.0;
3380: l_debug_level NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
3381: l_procedure_level NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3382: l_statement_level NUMBER := Fnd_Log.LEVEL_STATEMENT;
3383: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;
3384:
3385: BEGIN
3386:

Line 3383: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;

3379: l_api_version CONSTANT NUMBER := 1.0;
3380: l_debug_level NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
3381: l_procedure_level NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3382: l_statement_level NUMBER := Fnd_Log.LEVEL_STATEMENT;
3383: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;
3384:
3385: BEGIN
3386:
3387: -- Standard Start of API savepoint

Line 3390: IF(Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level) THEN

3386:
3387: -- Standard Start of API savepoint
3388: SAVEPOINT copy_Attachments;
3389:
3390: IF(Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level) THEN
3391: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3392: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3393: 'Entered Copy_Attachments API');
3394: END IF;

Line 3391: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3387: -- Standard Start of API savepoint
3388: SAVEPOINT copy_Attachments;
3389:
3390: IF(Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level) THEN
3391: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3392: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3393: 'Entered Copy_Attachments API');
3394: END IF;
3395:

Line 3413: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN

3409:
3410: -- Initialize API return status to success
3411: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3412:
3413: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3414: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3415: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3416: 'Validate Original Repair line id = '||p_original_ro_id);
3417: END IF;

Line 3414: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3410: -- Initialize API return status to success
3411: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3412:
3413: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3414: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3415: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3416: 'Validate Original Repair line id = '||p_original_ro_id);
3417: END IF;
3418:

Line 3424: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN

3420: ( p_repair_line_id => p_original_ro_id)) THEN
3421: RAISE Fnd_Api.G_EXC_ERROR;
3422: END IF;
3423:
3424: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3425: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3426: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3427: 'Validation of Original Repair line id completed successfully');
3428: END IF;

Line 3425: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3421: RAISE Fnd_Api.G_EXC_ERROR;
3422: END IF;
3423:
3424: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3425: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3426: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3427: 'Validation of Original Repair line id completed successfully');
3428: END IF;
3429:

Line 3430: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN

3426: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3427: 'Validation of Original Repair line id completed successfully');
3428: END IF;
3429:
3430: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3431: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3432: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3433: 'Validate New Repair line id = '||p_new_ro_id);
3434: END IF;

Line 3431: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3427: 'Validation of Original Repair line id completed successfully');
3428: END IF;
3429:
3430: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3431: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3432: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3433: 'Validate New Repair line id = '||p_new_ro_id);
3434: END IF;
3435:

Line 3441: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN

3437: ( p_repair_line_id => p_new_ro_id)) THEN
3438: RAISE Fnd_Api.G_EXC_ERROR;
3439: END IF;
3440:
3441: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3442: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3443: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3444: 'Validation of New Repair line id completed successfully');
3445: END IF;

Line 3442: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3438: RAISE Fnd_Api.G_EXC_ERROR;
3439: END IF;
3440:
3441: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3442: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3443: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3444: 'Validation of New Repair line id completed successfully');
3445: END IF;
3446:

Line 3451: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN

3447: -- Begin API Body
3448: -- Use cursor loop to get all attachments associated with
3449: -- the from_entity (Original Repair Order)
3450:
3451: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3452: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3453: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3454: 'Open main cursor');
3455: END IF;

Line 3452: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3448: -- Use cursor loop to get all attachments associated with
3449: -- the from_entity (Original Repair Order)
3450:
3451: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3452: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3453: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3454: 'Open main cursor');
3455: END IF;
3456:

Line 3457: IF(Fnd_Log.Level_Event >= Fnd_Log.G_Current_Runtime_Level) THEN

3453: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3454: 'Open main cursor');
3455: END IF;
3456:
3457: IF(Fnd_Log.Level_Event >= Fnd_Log.G_Current_Runtime_Level) THEN
3458: Fnd_Log.STRING(Fnd_Log.Level_Event,
3459: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3460: 'Started Copying of Attachments ');
3461: END IF;

Line 3458: Fnd_Log.STRING(Fnd_Log.Level_Event,

3454: 'Open main cursor');
3455: END IF;
3456:
3457: IF(Fnd_Log.Level_Event >= Fnd_Log.G_Current_Runtime_Level) THEN
3458: Fnd_Log.STRING(Fnd_Log.Level_Event,
3459: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3460: 'Started Copying of Attachments ');
3461: END IF;
3462:

Line 3466: IF ( Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN

3462:
3463:
3464: FOR docrec IN doclist LOOP
3465:
3466: IF ( Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3467: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3468: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3469: 'Main cursor - Datatype id = '||docrec.datatype_id);
3470:

Line 3467: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3463:
3464: FOR docrec IN doclist LOOP
3465:
3466: IF ( Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3467: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3468: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3469: 'Main cursor - Datatype id = '||docrec.datatype_id);
3470:
3471: END IF;

Line 3482: IF ( Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level ) THEN

3478: IF (docrec.usage_type = 'O'
3479: AND docrec.datatype_id IN (1,2,6,5) ) THEN
3480: -- Create Documents records
3481:
3482: IF ( Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level ) THEN
3483: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3484: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3485: 'Calling the FND_DOCUMENTS_PKG.Insert_Row');
3486: END IF;

Line 3483: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3479: AND docrec.datatype_id IN (1,2,6,5) ) THEN
3480: -- Create Documents records
3481:
3482: IF ( Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level ) THEN
3483: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3484: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3485: 'Calling the FND_DOCUMENTS_PKG.Insert_Row');
3486: END IF;
3487:

Line 3542: IF ( Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN

3538: OPEN shorttext(docrec.media_id);
3539: FETCH shorttext INTO l_short_text_tmp;
3540: CLOSE shorttext;
3541:
3542: IF ( Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3543: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3544: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3545: 'Inserting into fnd_documents_short_text for
3546: document id = '||docrec.document_id);

Line 3543: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3539: FETCH shorttext INTO l_short_text_tmp;
3540: CLOSE shorttext;
3541:
3542: IF ( Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3543: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3544: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3545: 'Inserting into fnd_documents_short_text for
3546: document id = '||docrec.document_id);
3547: END IF;

Line 3565: IF ( Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN

3561: OPEN longtext(docrec.media_id);
3562: FETCH longtext INTO l_long_text_tmp;
3563: CLOSE longtext;
3564:
3565: IF ( Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3566: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3567: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3568: 'Inserting into fnd_documents_long_text for
3569: document id = '||docrec.document_id);

Line 3566: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3562: FETCH longtext INTO l_long_text_tmp;
3563: CLOSE longtext;
3564:
3565: IF ( Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3566: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3567: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3568: 'Inserting into fnd_documents_long_text for
3569: document id = '||docrec.document_id);
3570: END IF;

Line 3598: IF ( Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN

3594: l_fnd_lobs_rec.oracle_charset,
3595: l_fnd_lobs_rec.file_format;
3596: CLOSE fnd_lobs_cur;
3597:
3598: IF ( Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3599: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3600: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3601: 'Inserting into fnd_lobs for
3602: document id = '||docrec.document_id);

Line 3599: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3595: l_fnd_lobs_rec.file_format;
3596: CLOSE fnd_lobs_cur;
3597:
3598: IF ( Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3599: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3600: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3601: 'Inserting into fnd_lobs for
3602: document id = '||docrec.document_id);
3603: END IF;

Line 3637: IF ( Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN

3633:
3634: END IF; -- end if usage_type = 'O' and datatype in (1,2,6,5)
3635:
3636:
3637: IF ( Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3638: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3639: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3640: 'Inserting into fnd_attached_documents for
3641: document id = '||docrec.document_id);

Line 3638: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3634: END IF; -- end if usage_type = 'O' and datatype in (1,2,6,5)
3635:
3636:
3637: IF ( Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3638: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3639: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3640: 'Inserting into fnd_attached_documents for
3641: document id = '||docrec.document_id);
3642: END IF;

Line 3734: IF ( Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN

3730: Fnd_Msg_Pub.Count_And_Get
3731: (p_count => x_msg_count,
3732: p_data => x_msg_data);
3733:
3734: IF ( Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3735: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3736: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3737: 'Copy Attachments completed successfully ');
3738: END IF;

Line 3735: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3731: (p_count => x_msg_count,
3732: p_data => x_msg_data);
3733:
3734: IF ( Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3735: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3736: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3737: 'Copy Attachments completed successfully ');
3738: END IF;
3739:

Line 3748: IF ( Fnd_Log.LEVEL_ERROR >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN

3744: Fnd_Msg_Pub.Count_And_Get
3745: (p_count => x_msg_count,
3746: p_data => x_msg_data
3747: );
3748: IF ( Fnd_Log.LEVEL_ERROR >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
3749: Fnd_Log.STRING(Fnd_Log.LEVEL_ERROR,
3750: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3751: 'EXC_ERROR ['||x_msg_data||']');
3752: END IF;

Line 3749: Fnd_Log.STRING(Fnd_Log.LEVEL_ERROR,

3745: (p_count => x_msg_count,
3746: p_data => x_msg_data
3747: );
3748: IF ( Fnd_Log.LEVEL_ERROR >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
3749: Fnd_Log.STRING(Fnd_Log.LEVEL_ERROR,
3750: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3751: 'EXC_ERROR ['||x_msg_data||']');
3752: END IF;
3753:

Line 3760: IF ( Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN

3756: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
3757: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count,
3758: p_data => x_msg_data );
3759:
3760: IF ( Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
3761: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,
3762: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3763: 'EXC_UNEXPECTED_ERROR ['||x_msg_data||']');
3764: END IF;

Line 3761: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,

3757: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count,
3758: p_data => x_msg_data );
3759:
3760: IF ( Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
3761: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,
3762: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3763: 'EXC_UNEXPECTED_ERROR ['||x_msg_data||']');
3764: END IF;
3765:

Line 3777: IF ( Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN

3773: END IF;
3774: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count,
3775: p_data => x_msg_data );
3776:
3777: IF ( Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
3778: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,
3779: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3780: 'SQL Message ['||SQLERRM||']');
3781: END IF;

Line 3778: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,

3774: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count,
3775: p_data => x_msg_data );
3776:
3777: IF ( Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
3778: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,
3779: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3780: 'SQL Message ['||SQLERRM||']');
3781: END IF;
3782:

Line 3814: l_debug_level NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;

3810: IS
3811:
3812: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Attachments';
3813: l_api_version CONSTANT NUMBER := 1.0;
3814: l_debug_level NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
3815: l_procedure_level NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3816: l_statement_level NUMBER := Fnd_Log.LEVEL_STATEMENT;
3817: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;
3818:

Line 3815: l_procedure_level NUMBER := Fnd_Log.LEVEL_PROCEDURE;

3811:
3812: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Attachments';
3813: l_api_version CONSTANT NUMBER := 1.0;
3814: l_debug_level NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
3815: l_procedure_level NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3816: l_statement_level NUMBER := Fnd_Log.LEVEL_STATEMENT;
3817: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;
3818:
3819: BEGIN

Line 3816: l_statement_level NUMBER := Fnd_Log.LEVEL_STATEMENT;

3812: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Attachments';
3813: l_api_version CONSTANT NUMBER := 1.0;
3814: l_debug_level NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
3815: l_procedure_level NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3816: l_statement_level NUMBER := Fnd_Log.LEVEL_STATEMENT;
3817: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;
3818:
3819: BEGIN
3820:

Line 3817: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;

3813: l_api_version CONSTANT NUMBER := 1.0;
3814: l_debug_level NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
3815: l_procedure_level NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3816: l_statement_level NUMBER := Fnd_Log.LEVEL_STATEMENT;
3817: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;
3818:
3819: BEGIN
3820:
3821: -- Standard Start of API savepoint

Line 3824: IF(Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level) THEN

3820:
3821: -- Standard Start of API savepoint
3822: SAVEPOINT Delete_Attachments;
3823:
3824: IF(Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level) THEN
3825: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3826: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3827: 'Entered Delete_Attachments API');
3828: END IF;

Line 3825: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3821: -- Standard Start of API savepoint
3822: SAVEPOINT Delete_Attachments;
3823:
3824: IF(Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level) THEN
3825: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3826: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3827: 'Entered Delete_Attachments API');
3828: END IF;
3829:

Line 3847: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN

3843:
3844: -- Initialize API return status to success
3845: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3846:
3847: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3848: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3849: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3850: 'Validate Repair line id = '||p_repair_line_id);
3851: END IF;

Line 3848: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3844: -- Initialize API return status to success
3845: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3846:
3847: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3848: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3849: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3850: 'Validate Repair line id = '||p_repair_line_id);
3851: END IF;
3852:

Line 3858: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN

3854: ( p_repair_line_id => p_repair_line_id)) THEN
3855: RAISE Fnd_Api.G_EXC_ERROR;
3856: END IF;
3857:
3858: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3859: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3860: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3861: 'Validation of Repair line id completed successfully');
3862: END IF;

Line 3859: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3855: RAISE Fnd_Api.G_EXC_ERROR;
3856: END IF;
3857:
3858: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3859: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3860: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3861: 'Validation of Repair line id completed successfully');
3862: END IF;
3863:

Line 3869: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN

3865: -- Begin API Body
3866: --
3867:
3868: -- Delete from FND_DOCUMENTS_SHORT_TEXT table
3869: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3870: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3871: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3872: 'Deleting from fnd_documents_short_text');
3873: END IF;

Line 3870: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3866: --
3867:
3868: -- Delete from FND_DOCUMENTS_SHORT_TEXT table
3869: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3870: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3871: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3872: 'Deleting from fnd_documents_short_text');
3873: END IF;
3874:

Line 3875: IF(Fnd_Log.Level_Event >= Fnd_Log.G_Current_Runtime_Level) THEN

3871: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3872: 'Deleting from fnd_documents_short_text');
3873: END IF;
3874:
3875: IF(Fnd_Log.Level_Event >= Fnd_Log.G_Current_Runtime_Level) THEN
3876: Fnd_Log.STRING(Fnd_Log.Level_Event,
3877: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3878: 'Started Deleting of Attachments');
3879: END IF;

Line 3876: Fnd_Log.STRING(Fnd_Log.Level_Event,

3872: 'Deleting from fnd_documents_short_text');
3873: END IF;
3874:
3875: IF(Fnd_Log.Level_Event >= Fnd_Log.G_Current_Runtime_Level) THEN
3876: Fnd_Log.STRING(Fnd_Log.Level_Event,
3877: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3878: 'Started Deleting of Attachments');
3879: END IF;
3880:

Line 3895: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN

3891: AND fd.datatype_id = 1
3892: AND fad.pk1_value = TO_CHAR(p_repair_line_id));
3893:
3894: -- Delete from FND_DOCUMENTS_LONG_TEXT table
3895: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3896: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3897: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3898: 'Deleting from fnd_documents_long_text');
3899: END IF;

Line 3896: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3892: AND fad.pk1_value = TO_CHAR(p_repair_line_id));
3893:
3894: -- Delete from FND_DOCUMENTS_LONG_TEXT table
3895: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3896: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3897: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3898: 'Deleting from fnd_documents_long_text');
3899: END IF;
3900:

Line 3914: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN

3910: AND fd.datatype_id = 2
3911: AND fad.pk1_value = TO_CHAR(p_repair_line_id));
3912:
3913: -- Delete from FND_DOCUMENTS_LONG_RAW table
3914: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3915: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3916: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3917: 'Deleting from fnd_documents_long_raw');
3918: END IF;

Line 3915: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3911: AND fad.pk1_value = TO_CHAR(p_repair_line_id));
3912:
3913: -- Delete from FND_DOCUMENTS_LONG_RAW table
3914: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3915: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3916: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3917: 'Deleting from fnd_documents_long_raw');
3918: END IF;
3919:

Line 3934: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN

3930: AND fad.pk1_value = TO_CHAR(p_repair_line_id));
3931:
3932:
3933: -- Delete from FND_LOBS table
3934: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3935: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3936: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3937: 'Deleting from fnd_lobs');
3938: END IF;

Line 3935: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3931:
3932:
3933: -- Delete from FND_LOBS table
3934: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3935: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3936: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3937: 'Deleting from fnd_lobs');
3938: END IF;
3939:

Line 3953: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN

3949: AND fd.datatype_id = 6
3950: AND fad.pk1_value = TO_CHAR(p_repair_line_id));
3951:
3952: -- Delete from FND_DOCUMENTS_TL table
3953: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3954: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3955: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3956: 'Deleting from fnd_documents_tl');
3957: END IF;

Line 3954: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3950: AND fad.pk1_value = TO_CHAR(p_repair_line_id));
3951:
3952: -- Delete from FND_DOCUMENTS_TL table
3953: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3954: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3955: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3956: 'Deleting from fnd_documents_tl');
3957: END IF;
3958:

Line 3968: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN

3964: AND fd.usage_type = 'O'
3965: AND fad.pk1_value = TO_CHAR(p_repair_line_id));
3966:
3967: -- Delete from FND_DOCUMENTS table
3968: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3969: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3970: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3971: 'Deleting from fnd_documents');
3972: END IF;

Line 3969: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3965: AND fad.pk1_value = TO_CHAR(p_repair_line_id));
3966:
3967: -- Delete from FND_DOCUMENTS table
3968: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3969: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3970: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3971: 'Deleting from fnd_documents');
3972: END IF;
3973:

Line 3982: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN

3978: FROM fnd_attached_documents fad
3979: WHERE fad.pk1_value = TO_CHAR(p_repair_line_id));
3980:
3981: -- delete from FND_ATTACHED_DOCUMENTS table
3982: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3983: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3984: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3985: 'Deleting from fnd_attached_documents');
3986: END IF;

Line 3983: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3979: WHERE fad.pk1_value = TO_CHAR(p_repair_line_id));
3980:
3981: -- delete from FND_ATTACHED_DOCUMENTS table
3982: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3983: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3984: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3985: 'Deleting from fnd_attached_documents');
3986: END IF;
3987:

Line 4003: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN

3999: Fnd_Msg_Pub.Count_And_Get
4000: (p_count => x_msg_count,
4001: p_data => x_msg_data);
4002:
4003: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
4004: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4005: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
4006: 'Delete_Attachments completed successfully');
4007: END IF;

Line 4004: Fnd_Log.STRING(Fnd_Log.Level_Statement,

4000: (p_count => x_msg_count,
4001: p_data => x_msg_data);
4002:
4003: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
4004: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4005: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
4006: 'Delete_Attachments completed successfully');
4007: END IF;
4008:

Line 4017: IF ( Fnd_Log.LEVEL_ERROR >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN

4013: Fnd_Msg_Pub.Count_And_Get
4014: (p_count => x_msg_count,
4015: p_data => x_msg_data
4016: );
4017: IF ( Fnd_Log.LEVEL_ERROR >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
4018: Fnd_Log.STRING(Fnd_Log.LEVEL_ERROR,
4019: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
4020: 'EXC_ERROR ['||x_msg_data||']');
4021: END IF;

Line 4018: Fnd_Log.STRING(Fnd_Log.LEVEL_ERROR,

4014: (p_count => x_msg_count,
4015: p_data => x_msg_data
4016: );
4017: IF ( Fnd_Log.LEVEL_ERROR >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
4018: Fnd_Log.STRING(Fnd_Log.LEVEL_ERROR,
4019: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
4020: 'EXC_ERROR ['||x_msg_data||']');
4021: END IF;
4022:

Line 4029: IF ( Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN

4025: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
4026: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count,
4027: p_data => x_msg_data );
4028:
4029: IF ( Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
4030: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,
4031: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
4032: 'EXC_UNEXPECTED_ERROR ['||x_msg_data||']');
4033: END IF;

Line 4030: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,

4026: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count,
4027: p_data => x_msg_data );
4028:
4029: IF ( Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
4030: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,
4031: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
4032: 'EXC_UNEXPECTED_ERROR ['||x_msg_data||']');
4033: END IF;
4034:

Line 4046: IF ( Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN

4042: END IF;
4043: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count,
4044: p_data => x_msg_data );
4045:
4046: IF ( Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
4047: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,
4048: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
4049: 'SQL Message ['||SQLERRM||']');
4050: END IF;

Line 4047: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,

4043: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count,
4044: p_data => x_msg_data );
4045:
4046: IF ( Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
4047: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,
4048: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
4049: 'SQL Message ['||SQLERRM||']');
4050: END IF;
4051:

Line 4125: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level) THEN

4121:
4122:
4123: BEGIN
4124: --------------------Standard stuff -------------------------
4125: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level) THEN
4126: Fnd_Log.STRING (Fnd_Log.level_procedure,
4127: 'csd.plsql.csd_repairs_pvt.update_ro_status.begin',
4128: 'Entering update_ro_status private api');
4129: END IF;

Line 4126: Fnd_Log.STRING (Fnd_Log.level_procedure,

4122:
4123: BEGIN
4124: --------------------Standard stuff -------------------------
4125: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level) THEN
4126: Fnd_Log.STRING (Fnd_Log.level_procedure,
4127: 'csd.plsql.csd_repairs_pvt.update_ro_status.begin',
4128: 'Entering update_ro_status private api');
4129: END IF;
4130: IF Fnd_Api.to_boolean (p_init_msg_list) THEN

Line 4143: IF (Fnd_Log.level_event >= Fnd_Log.g_current_runtime_level) THEN

4139:
4140: l_repair_status_Rec := p_repair_status_rec;
4141:
4142: ------------Convert Values to Id----------------------------------------------
4143: IF (Fnd_Log.level_event >= Fnd_Log.g_current_runtime_level) THEN
4144: Fnd_Log.STRING (Fnd_Log.level_event,
4145: 'csd.plsql.csd_repairs_pvt.update_ro_status',
4146: '-----step 1: Value to Id conversion');
4147: END IF;

Line 4144: Fnd_Log.STRING (Fnd_Log.level_event,

4140: l_repair_status_Rec := p_repair_status_rec;
4141:
4142: ------------Convert Values to Id----------------------------------------------
4143: IF (Fnd_Log.level_event >= Fnd_Log.g_current_runtime_level) THEN
4144: Fnd_Log.STRING (Fnd_Log.level_event,
4145: 'csd.plsql.csd_repairs_pvt.update_ro_status',
4146: '-----step 1: Value to Id conversion');
4147: END IF;
4148: Csd_Repairs_Util.Convert_Status_Val_To_Id(p_repair_status_rec,

Line 4153: IF (Fnd_Log.level_event >= Fnd_Log.g_current_runtime_level) THEN

4149: l_repair_status_rec,
4150: l_return_status);
4151:
4152: ------------Default/Validate Input parameters----------------------------------------------
4153: IF (Fnd_Log.level_event >= Fnd_Log.g_current_runtime_level) THEN
4154: Fnd_Log.STRING (Fnd_Log.level_event,
4155: 'csd.plsql.csd_repairs_pvt.update_ro_status',
4156: '-----step 2: Validate input ');
4157: END IF;

Line 4154: Fnd_Log.STRING (Fnd_Log.level_event,

4150: l_return_status);
4151:
4152: ------------Default/Validate Input parameters----------------------------------------------
4153: IF (Fnd_Log.level_event >= Fnd_Log.g_current_runtime_level) THEN
4154: Fnd_Log.STRING (Fnd_Log.level_event,
4155: 'csd.plsql.csd_repairs_pvt.update_ro_status',
4156: '-----step 2: Validate input ');
4157: END IF;
4158:

Line 4159: IF (Fnd_Log.level_event >= Fnd_Log.g_current_runtime_level) THEN

4155: 'csd.plsql.csd_repairs_pvt.update_ro_status',
4156: '-----step 2: Validate input ');
4157: END IF;
4158:
4159: IF (Fnd_Log.level_event >= Fnd_Log.g_current_runtime_level) THEN
4160: Fnd_Log.STRING (Fnd_Log.level_event,
4161: 'csd.plsql.csd_repairs_pvt.update_ro_status',
4162: '-----step 3: get required repair order values for update private api,ro['
4163: ||l_repair_status_rec.repair_line_id||'],status['

Line 4160: Fnd_Log.STRING (Fnd_Log.level_event,

4156: '-----step 2: Validate input ');
4157: END IF;
4158:
4159: IF (Fnd_Log.level_event >= Fnd_Log.g_current_runtime_level) THEN
4160: Fnd_Log.STRING (Fnd_Log.level_event,
4161: 'csd.plsql.csd_repairs_pvt.update_ro_status',
4162: '-----step 3: get required repair order values for update private api,ro['
4163: ||l_repair_status_rec.repair_line_id||'],status['
4164: ||l_repair_status_rec.repair_status||']');

Line 4188: IF (Fnd_Log.level_event >= Fnd_Log.g_current_runtime_level) THEN

4184: RAISE Fnd_Api.G_EXC_ERROR;
4185: END IF;
4186: CLOSE flow_stat_cur;
4187:
4188: IF (Fnd_Log.level_event >= Fnd_Log.g_current_runtime_level) THEN
4189: Fnd_Log.STRING (Fnd_Log.level_event,
4190: 'csd.plsql.csd_repairs_pvt.update_ro_status',
4191: '-----step 4: Checking for open jobs/tasks,ro['
4192: ||l_repair_status_rec.repair_line_id||'],state['

Line 4189: Fnd_Log.STRING (Fnd_Log.level_event,

4185: END IF;
4186: CLOSE flow_stat_cur;
4187:
4188: IF (Fnd_Log.level_event >= Fnd_Log.g_current_runtime_level) THEN
4189: Fnd_Log.STRING (Fnd_Log.level_event,
4190: 'csd.plsql.csd_repairs_pvt.update_ro_status',
4191: '-----step 4: Checking for open jobs/tasks,ro['
4192: ||l_repair_status_rec.repair_line_id||'],state['
4193: ||l_repair_status_rec.repair_state||']');

Line 4217: IF (Fnd_Log.level_event >= Fnd_Log.g_current_runtime_level) THEN

4213:
4214:
4215: ------------Call other private api to perform the status update------------------------------
4216: /*----------------------Vinay says the api update_flow_Status has logic to close ro status.*/
4217: IF (Fnd_Log.level_event >= Fnd_Log.g_current_runtime_level) THEN
4218: Fnd_Log.STRING (Fnd_Log.level_event,
4219: 'csd.plsql.csd_repairs_pvt.update_ro_status',
4220: '-----step 5a: Calling another private api to validate and update status');
4221: END IF;

Line 4218: Fnd_Log.STRING (Fnd_Log.level_event,

4214:
4215: ------------Call other private api to perform the status update------------------------------
4216: /*----------------------Vinay says the api update_flow_Status has logic to close ro status.*/
4217: IF (Fnd_Log.level_event >= Fnd_Log.g_current_runtime_level) THEN
4218: Fnd_Log.STRING (Fnd_Log.level_event,
4219: 'csd.plsql.csd_repairs_pvt.update_ro_status',
4220: '-----step 5a: Calling another private api to validate and update status');
4221: END IF;
4222: Csd_Repairs_Pvt.UPDATE_FLOW_STATUS (

Line 4257: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level) THEN

4253:
4254: -- Standard call to get message count and IF count is get message info.
4255: Fnd_Msg_Pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
4256:
4257: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level) THEN
4258: Fnd_Log.STRING (Fnd_Log.level_procedure,
4259: 'csd.plsql.csd_repairs_pvt.update_ro_status',
4260: 'Leaving update_ro_Status private api');
4261: END IF;

Line 4258: Fnd_Log.STRING (Fnd_Log.level_procedure,

4254: -- Standard call to get message count and IF count is get message info.
4255: Fnd_Msg_Pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
4256:
4257: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level) THEN
4258: Fnd_Log.STRING (Fnd_Log.level_procedure,
4259: 'csd.plsql.csd_repairs_pvt.update_ro_status',
4260: 'Leaving update_ro_Status private api');
4261: END IF;
4262:

Line 4269: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level) THEN

4265: THEN
4266: x_return_status := Fnd_Api.G_RET_STS_ERROR;
4267: ROLLBACK TO update_ro_status_pvt;
4268: Fnd_Msg_Pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
4269: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level) THEN
4270: Fnd_Log.STRING (Fnd_Log.level_error,
4271: 'csd.plsql.csd_repairs_pvt.update_ro_status',
4272: 'EXC_ERROR[' || x_msg_data || ']');
4273: END IF;

Line 4270: Fnd_Log.STRING (Fnd_Log.level_error,

4266: x_return_status := Fnd_Api.G_RET_STS_ERROR;
4267: ROLLBACK TO update_ro_status_pvt;
4268: Fnd_Msg_Pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
4269: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level) THEN
4270: Fnd_Log.STRING (Fnd_Log.level_error,
4271: 'csd.plsql.csd_repairs_pvt.update_ro_status',
4272: 'EXC_ERROR[' || x_msg_data || ']');
4273: END IF;
4274: WHEN Fnd_Api.g_exc_unexpected_error

Line 4280: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level) THEN

4276: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
4277: ROLLBACK TO update_ro_status_pvt;
4278: Fnd_Msg_Pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
4279:
4280: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level) THEN
4281: Fnd_Log.STRING (Fnd_Log.level_exception,
4282: 'csd.plsql.csd_repairs_pvt.update_ro_status',
4283: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');
4284: END IF;

Line 4281: Fnd_Log.STRING (Fnd_Log.level_exception,

4277: ROLLBACK TO update_ro_status_pvt;
4278: Fnd_Msg_Pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
4279:
4280: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level) THEN
4281: Fnd_Log.STRING (Fnd_Log.level_exception,
4282: 'csd.plsql.csd_repairs_pvt.update_ro_status',
4283: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');
4284: END IF;
4285: WHEN OTHERS

Line 4296: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level) THEN

4292: END IF;
4293:
4294: Fnd_Msg_Pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
4295:
4296: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level) THEN
4297: Fnd_Log.STRING (Fnd_Log.level_exception,
4298: 'csd.plsql.csd_repairs_pvt.update_ro_status',
4299: 'SQL MEssage[' || SQLERRM || ']');
4300: END IF;

Line 4297: Fnd_Log.STRING (Fnd_Log.level_exception,

4293:
4294: Fnd_Msg_Pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
4295:
4296: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level) THEN
4297: Fnd_Log.STRING (Fnd_Log.level_exception,
4298: 'csd.plsql.csd_repairs_pvt.update_ro_status',
4299: 'SQL MEssage[' || SQLERRM || ']');
4300: END IF;
4301: END UPDATE_RO_STATUS;

Line 4414: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

4410: IF Fnd_Api.to_Boolean( p_init_msg_list ) THEN
4411: Fnd_Msg_Pub.initialize;
4412: END IF;
4413:
4414: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4415: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',
4416: 'Entered Update_Flow_Status');
4417: END IF;
4418:

Line 4415: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',

4411: Fnd_Msg_Pub.initialize;
4412: END IF;
4413:
4414: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4415: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',
4416: 'Entered Update_Flow_Status');
4417: END IF;
4418:
4419: -- Initialize API return status to success

Line 4427: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

4423:
4424: -- STEP 1: Validate Mandatory Parameters.
4425:
4426: -- Check the required parameters
4427: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4428: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4429: 'Checking required parameters');
4430: END IF;
4431:

Line 4428: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,

4424: -- STEP 1: Validate Mandatory Parameters.
4425:
4426: -- Check the required parameters
4427: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4428: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4429: 'Checking required parameters');
4430: END IF;
4431:
4432: -- Check the required parameters

Line 4471: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

4467: RAISE Fnd_Api.G_EXC_ERROR;
4468: END IF;
4469:
4470:
4471: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4472: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4473: 'Calling Cursor c_get_trans_flags');
4474: END IF;
4475:

Line 4472: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,

4468: END IF;
4469:
4470:
4471: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4472: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4473: 'Calling Cursor c_get_trans_flags');
4474: END IF;
4475:
4476: OPEN c_get_trans_details;

Line 4488: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

4484: l_to_flow_status_code,
4485: l_from_flow_status_code;
4486: CLOSE c_get_trans_details;
4487:
4488: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4489: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4490: 'After calling Cursor c_get_trans_details');
4491: END IF;
4492:

Line 4489: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,

4485: l_from_flow_status_code;
4486: CLOSE c_get_trans_details;
4487:
4488: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4489: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4490: 'After calling Cursor c_get_trans_details');
4491: END IF;
4492:
4493: -- Validate whether the set up exists for transition of

Line 4517: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

4513: -- We do not need to call the 'update allowed' function if the
4514: -- 'all resp' have access or we are requested to skip the check.
4515: IF (l_allow_all_resp_flag <> 'Y' AND p_check_access_flag = 'Y') THEN
4516:
4517: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4518: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4519: 'Calling Is_Flwsts_Update_Allowed');
4520: END IF;
4521:

Line 4518: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,

4514: -- 'all resp' have access or we are requested to skip the check.
4515: IF (l_allow_all_resp_flag <> 'Y' AND p_check_access_flag = 'Y') THEN
4516:
4517: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4518: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4519: 'Calling Is_Flwsts_Update_Allowed');
4520: END IF;
4521:
4522: IF NOT Is_Flwsts_Update_Allowed(p_repair_type_id => p_repair_type_id,

Line 4538: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

4534: -- won't show.
4535: RAISE Fnd_Api.G_EXC_ERROR;
4536: END IF;
4537:
4538: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4539: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4540: 'After calling Is_Flwsts_Update_Allowed');
4541: END IF;
4542: END IF;

Line 4539: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,

4535: RAISE Fnd_Api.G_EXC_ERROR;
4536: END IF;
4537:
4538: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4539: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4540: 'After calling Is_Flwsts_Update_Allowed');
4541: END IF;
4542: END IF;
4543:

Line 4549: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

4545:
4546: -- Validate reason code if passed
4547: IF p_reason_code IS NOT NULL THEN
4548:
4549: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4550: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4551: 'Calling Cursor c_check_status_reason');
4552: END IF;
4553:

Line 4550: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,

4546: -- Validate reason code if passed
4547: IF p_reason_code IS NOT NULL THEN
4548:
4549: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4550: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4551: 'Calling Cursor c_check_status_reason');
4552: END IF;
4553:
4554: OPEN c_check_status_reason;

Line 4584: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

4580: l_flwsts_wf_rec.wf_item_type := l_wf_item_type;
4581: l_flwsts_wf_rec.wf_item_key := l_wf_item_key;
4582: l_flwsts_wf_rec.wf_process_name := l_wf_process_name;
4583:
4584: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4585: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4586: 'Calling Launch_Flwsts_Wf');
4587: END IF;
4588:

Line 4585: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,

4581: l_flwsts_wf_rec.wf_item_key := l_wf_item_key;
4582: l_flwsts_wf_rec.wf_process_name := l_wf_process_name;
4583:
4584: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4585: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4586: 'Calling Launch_Flwsts_Wf');
4587: END IF;
4588:
4589: Launch_Flwsts_Wf (

Line 4612: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

4608: END IF;
4609:
4610: -- STEP 6: Update CSD_REPAIRS with status details.
4611:
4612: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4613: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4614: 'Calling update Repairs');
4615: END IF;
4616:

Line 4613: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,

4609:
4610: -- STEP 6: Update CSD_REPAIRS with status details.
4611:
4612: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4613: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4614: 'Calling update Repairs');
4615: END IF;
4616:
4617: --BEGIN

Line 4661: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

4657: Fnd_Msg_Pub.ADD;
4658: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4659: end if;
4660:
4661: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4662: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4663: 'After calling update Repairs');
4664: END IF;
4665:

Line 4662: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,

4658: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4659: end if;
4660:
4661: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4662: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4663: 'After calling update Repairs');
4664: END IF;
4665:
4666: -- STEP 7: Log 'Status Change' activity.

Line 4671: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

4667:
4668: -- Log an activity if setup to do so.
4669: IF l_capture_activity_flag = 'Y' THEN
4670:
4671: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4672: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4673: 'Calling Repair History to log activity');
4674: END IF;
4675:

Line 4672: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,

4668: -- Log an activity if setup to do so.
4669: IF l_capture_activity_flag = 'Y' THEN
4670:
4671: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4672: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4673: 'Calling Repair History to log activity');
4674: END IF;
4675:
4676:

Line 4824: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

4820: Fnd_Msg_Pub.Count_And_Get
4821: (p_count => x_msg_count,
4822: p_data => x_msg_data );
4823:
4824: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4825: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.END',
4826: 'Leaving Update_Flow_Status');
4827: END IF;
4828:

Line 4825: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.END',

4821: (p_count => x_msg_count,
4822: p_data => x_msg_data );
4823:
4824: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4825: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.END',
4826: 'Leaving Update_Flow_Status');
4827: END IF;
4828:
4829: EXCEPTION

Line 4839: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

4835: (p_count => x_msg_count,
4836: p_data => x_msg_data );
4837:
4838: -- save message in debug log
4839: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4840: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
4841: 'EXC_ERROR['||x_msg_data||']');
4842: END IF;
4843:

Line 4840: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,

4836: p_data => x_msg_data );
4837:
4838: -- save message in debug log
4839: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4840: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
4841: 'EXC_ERROR['||x_msg_data||']');
4842: END IF;
4843:
4844: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 4852: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

4848: -- save message in fnd stack
4849: IF Fnd_Msg_Pub.Check_Msg_Level
4850: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
4851: THEN
4852: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4853: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
4854: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
4855: END IF;
4856: Fnd_Msg_Pub.Add_Exc_Msg

Line 4853: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,

4849: IF Fnd_Msg_Pub.Check_Msg_Level
4850: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
4851: THEN
4852: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4853: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
4854: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
4855: END IF;
4856: Fnd_Msg_Pub.Add_Exc_Msg
4857: (G_PKG_NAME ,

Line 4866: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

4862: ( p_count => x_msg_count,
4863: p_data => x_msg_data );
4864:
4865: -- save message in debug log
4866: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4867: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
4868: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
4869: END IF;
4870:

Line 4867: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,

4863: p_data => x_msg_data );
4864:
4865: -- save message in debug log
4866: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4867: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
4868: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
4869: END IF;
4870:
4871: WHEN OTHERS THEN

Line 4879: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

4875: -- save message in fnd stack
4876: IF Fnd_Msg_Pub.Check_Msg_Level
4877: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
4878: THEN
4879: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4880: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
4881: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
4882: END IF;
4883: Fnd_Msg_Pub.Add_Exc_Msg

Line 4880: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,

4876: IF Fnd_Msg_Pub.Check_Msg_Level
4877: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
4878: THEN
4879: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4880: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
4881: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
4882: END IF;
4883: Fnd_Msg_Pub.Add_Exc_Msg
4884: (G_PKG_NAME ,

Line 4893: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

4889: (p_count => x_msg_count,
4890: p_data => x_msg_data );
4891:
4892: -- save message in debug log
4893: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4894: -- create a seeded message
4895: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
4896: 'SQL Message['||SQLERRM||']' );
4897: END IF;

Line 4895: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,

4891:
4892: -- save message in debug log
4893: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4894: -- create a seeded message
4895: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
4896: 'SQL Message['||SQLERRM||']' );
4897: END IF;
4898:
4899: END Update_Flow_Status;

Line 4933: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

4929: );
4930:
4931: BEGIN
4932:
4933: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4934: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',
4935: 'Entered Is_Rt_Update_Allowed');
4936: END IF;
4937:

Line 4934: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',

4930:
4931: BEGIN
4932:
4933: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4934: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',
4935: 'Entered Is_Rt_Update_Allowed');
4936: END IF;
4937:
4938: -- Check the required parameters

Line 4939: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

4935: 'Entered Is_Rt_Update_Allowed');
4936: END IF;
4937:
4938: -- Check the required parameters
4939: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4940: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4941: 'Checking required parameters');
4942: END IF;
4943:

Line 4940: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,

4936: END IF;
4937:
4938: -- Check the required parameters
4939: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4940: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4941: 'Checking required parameters');
4942: END IF;
4943:
4944: -- Check the required parameters

Line 4972: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

4968: ELSE
4969: RETURN TRUE;
4970: END IF;
4971:
4972: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4973: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.END',
4974: 'Leaving Is_Rt_Update_Allowed');
4975: END IF;
4976:

Line 4973: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.END',

4969: RETURN TRUE;
4970: END IF;
4971:
4972: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4973: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.END',
4974: 'Leaving Is_Rt_Update_Allowed');
4975: END IF;
4976:
4977: END Is_Rt_Update_Allowed;

Line 5058: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

5054: IF Fnd_Api.to_Boolean( p_init_msg_list ) THEN
5055: Fnd_Msg_Pub.initialize;
5056: END IF;
5057:
5058: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5059: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',
5060: 'Entered Update_Repair_Type');
5061: END IF;
5062:

Line 5059: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',

5055: Fnd_Msg_Pub.initialize;
5056: END IF;
5057:
5058: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5059: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',
5060: 'Entered Update_Repair_Type');
5061: END IF;
5062:
5063: -- Initialize API return status to success

Line 5069: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

5065:
5066: -- Api body starts
5067:
5068: -- Check the required parameters
5069: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5070: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5071: 'Checking required parameters');
5072: END IF;
5073:

Line 5070: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,

5066: -- Api body starts
5067:
5068: -- Check the required parameters
5069: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5070: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5071: 'Checking required parameters');
5072: END IF;
5073:
5074: -- Check the required parameters

Line 5103: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

5099: p_param_name => 'P_OBJECT_VERSION_NUMBER',
5100: p_api_name => lc_api_name);
5101:
5102:
5103: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5104: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5105: 'Calling Cursor c_get_trans_flags');
5106: END IF;
5107:

Line 5104: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,

5100: p_api_name => lc_api_name);
5101:
5102:
5103: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5104: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5105: 'Calling Cursor c_get_trans_flags');
5106: END IF;
5107:
5108: OPEN c_get_trans_flags;

Line 5112: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

5108: OPEN c_get_trans_flags;
5109: FETCH c_get_trans_flags INTO l_reason_required_flag, l_capture_activity_flag;
5110: CLOSE c_get_trans_flags;
5111:
5112: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5113: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5114: 'After calling Cursor c_get_trans_flags');
5115: END IF;
5116:

Line 5113: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,

5109: FETCH c_get_trans_flags INTO l_reason_required_flag, l_capture_activity_flag;
5110: CLOSE c_get_trans_flags;
5111:
5112: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5113: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5114: 'After calling Cursor c_get_trans_flags');
5115: END IF;
5116:
5117: -- 5362259, validate p_to_repair_type_id and show error msg

Line 5144: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

5140: --5362259, changing exeception from G_EXC_UPEXPECTED_ERROR to G_EXC_ERROR
5141: RAISE Fnd_Api.G_EXC_ERROR;
5142: END IF;
5143:
5144: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5145: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5146: 'Calling Is_Rt_Update_Allowed');
5147: END IF;
5148:

Line 5145: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,

5141: RAISE Fnd_Api.G_EXC_ERROR;
5142: END IF;
5143:
5144: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5145: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5146: 'Calling Is_Rt_Update_Allowed');
5147: END IF;
5148:
5149: IF NOT Is_Rt_Update_Allowed(p_from_repair_type_id => p_from_repair_type_id,

Line 5161: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

5157: Fnd_Msg_Pub.ADD;
5158: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
5159: END IF;
5160:
5161: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5162: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5163: 'After calling Is_Rt_Update_Allowed');
5164: END IF;
5165:

Line 5162: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,

5158: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
5159: END IF;
5160:
5161: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5162: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5163: 'After calling Is_Rt_Update_Allowed');
5164: END IF;
5165:
5166:

Line 5167: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

5163: 'After calling Is_Rt_Update_Allowed');
5164: END IF;
5165:
5166:
5167: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5168: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5169: 'Calling Cursor c_check_rt_reason');
5170: END IF;
5171:

Line 5168: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,

5164: END IF;
5165:
5166:
5167: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5168: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5169: 'Calling Cursor c_check_rt_reason');
5170: END IF;
5171:
5172: -- Validate reason code if passed

Line 5187: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

5183: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
5184: END IF;
5185: END IF;
5186:
5187: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5188: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5189: 'calling update for Repair Type');
5190: END IF;
5191:

Line 5188: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,

5184: END IF;
5185: END IF;
5186:
5187: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5188: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5189: 'calling update for Repair Type');
5190: END IF;
5191:
5192: BEGIN

Line 5217: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

5213: Fnd_Msg_Pub.ADD;
5214: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
5215: END;
5216:
5217: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5218: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5219: 'After calling update for Repair Type');
5220: END IF;
5221:

Line 5218: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,

5214: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
5215: END;
5216:
5217: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5218: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5219: 'After calling update for Repair Type');
5220: END IF;
5221:
5222: -- Log an activity if setup to do so.

Line 5225: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

5221:
5222: -- Log an activity if setup to do so.
5223: IF l_capture_activity_flag = 'Y' THEN
5224:
5225: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5226: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5227: 'Calling Repair History to log activity');
5228: END IF;
5229:

Line 5226: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,

5222: -- Log an activity if setup to do so.
5223: IF l_capture_activity_flag = 'Y' THEN
5224:
5225: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5226: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5227: 'Calling Repair History to log activity');
5228: END IF;
5229:
5230: OPEN c_get_repair_types;

Line 5348: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

5344: Fnd_Msg_Pub.Count_And_Get
5345: (p_count => x_msg_count,
5346: p_data => x_msg_data );
5347:
5348: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5349: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.END',
5350: 'Leaving Update_Repair_Type');
5351: END IF;
5352:

Line 5349: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.END',

5345: (p_count => x_msg_count,
5346: p_data => x_msg_data );
5347:
5348: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5349: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.END',
5350: 'Leaving Update_Repair_Type');
5351: END IF;
5352:
5353: EXCEPTION

Line 5363: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

5359: (p_count => x_msg_count,
5360: p_data => x_msg_data );
5361:
5362: -- save message in debug log
5363: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5364: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
5365: 'EXC_ERROR['||x_msg_data||']');
5366: END IF;
5367:

Line 5364: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,

5360: p_data => x_msg_data );
5361:
5362: -- save message in debug log
5363: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5364: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
5365: 'EXC_ERROR['||x_msg_data||']');
5366: END IF;
5367:
5368: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 5376: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

5372: -- save message in fnd stack
5373: IF Fnd_Msg_Pub.Check_Msg_Level
5374: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5375: THEN
5376: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5377: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5378: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5379: END IF;
5380: Fnd_Msg_Pub.Add_Exc_Msg

Line 5377: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,

5373: IF Fnd_Msg_Pub.Check_Msg_Level
5374: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5375: THEN
5376: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5377: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5378: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5379: END IF;
5380: Fnd_Msg_Pub.Add_Exc_Msg
5381: (G_PKG_NAME ,

Line 5390: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

5386: ( p_count => x_msg_count,
5387: p_data => x_msg_data );
5388:
5389: -- save message in debug log
5390: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5391: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
5392: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
5393: END IF;
5394:

Line 5391: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,

5387: p_data => x_msg_data );
5388:
5389: -- save message in debug log
5390: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5391: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
5392: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
5393: END IF;
5394:
5395: WHEN OTHERS THEN

Line 5403: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

5399: -- save message in fnd stack
5400: IF Fnd_Msg_Pub.Check_Msg_Level
5401: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5402: THEN
5403: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5404: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5405: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5406: END IF;
5407: Fnd_Msg_Pub.Add_Exc_Msg

Line 5404: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,

5400: IF Fnd_Msg_Pub.Check_Msg_Level
5401: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5402: THEN
5403: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5404: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5405: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5406: END IF;
5407: Fnd_Msg_Pub.Add_Exc_Msg
5408: (G_PKG_NAME ,

Line 5417: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

5413: (p_count => x_msg_count,
5414: p_data => x_msg_data );
5415:
5416: -- save message in debug log
5417: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5418: -- create a seeded message
5419: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
5420: 'SQL Message['||SQLERRM||']' );
5421: END IF;

Line 5419: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,

5415:
5416: -- save message in debug log
5417: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5418: -- create a seeded message
5419: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
5420: 'SQL Message['||SQLERRM||']' );
5421: END IF;
5422:
5423: END Update_Repair_Type;

Line 5457: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

5453: );
5454:
5455: BEGIN
5456:
5457: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5458: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',
5459: 'Entered Is_Flwsts_Update_Allowed');
5460: END IF;
5461:

Line 5458: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',

5454:
5455: BEGIN
5456:
5457: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5458: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',
5459: 'Entered Is_Flwsts_Update_Allowed');
5460: END IF;
5461:
5462: -- Check the required parameters

Line 5463: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

5459: 'Entered Is_Flwsts_Update_Allowed');
5460: END IF;
5461:
5462: -- Check the required parameters
5463: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5464: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5465: 'Checking required parameters');
5466: END IF;
5467:

Line 5464: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,

5460: END IF;
5461:
5462: -- Check the required parameters
5463: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5464: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5465: 'Checking required parameters');
5466: END IF;
5467:
5468: -- Check the required parameters

Line 5496: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

5492: ELSE
5493: RETURN TRUE;
5494: END IF;
5495:
5496: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5497: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.END',
5498: 'Leaving Is_Flwsts_Update_Allowed');
5499: END IF;
5500:

Line 5497: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.END',

5493: RETURN TRUE;
5494: END IF;
5495:
5496: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5497: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.END',
5498: 'Leaving Is_Flwsts_Update_Allowed');
5499: END IF;
5500:
5501: END Is_Flwsts_Update_Allowed;

Line 5554: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

5550: IF Fnd_Api.to_Boolean( p_init_msg_list ) THEN
5551: Fnd_Msg_Pub.initialize;
5552: END IF;
5553:
5554: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5555: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',
5556: 'Entered Launch_Flwsts_Wf');
5557: END IF;
5558:

Line 5555: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',

5551: Fnd_Msg_Pub.initialize;
5552: END IF;
5553:
5554: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5555: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',
5556: 'Entered Launch_Flwsts_Wf');
5557: END IF;
5558:
5559: -- Initialize API return status to success

Line 5565: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

5561:
5562: -- Api body starts
5563:
5564: -- Check the required parameters
5565: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5566: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5567: 'Checking required parameters');
5568: END IF;
5569:

Line 5566: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,

5562: -- Api body starts
5563:
5564: -- Check the required parameters
5565: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5566: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5567: 'Checking required parameters');
5568: END IF;
5569:
5570: -- Check the required parameters

Line 5619: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

5615: -- Defer the wf process
5616: -- yvchen: Bug 12888789, Don't change the Wf_Engine.threshold, so it will not defer the WF processing
5617: -- Wf_Engine.threshold := lc_wf_negative_threshold;
5618:
5619: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5620: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5621: 'Calling WF_ENGINE.CreateProcess');
5622: END IF;
5623:

Line 5620: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,

5616: -- yvchen: Bug 12888789, Don't change the Wf_Engine.threshold, so it will not defer the WF processing
5617: -- Wf_Engine.threshold := lc_wf_negative_threshold;
5618:
5619: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5620: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5621: 'Calling WF_ENGINE.CreateProcess');
5622: END IF;
5623:
5624: Wf_Engine.CreateProcess(itemtype => p_flwsts_wf_rec.wf_item_type,

Line 5646: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

5642:
5643: l_wf_aname_TabType(5) := lc_object_version_number;
5644: l_wf_avalue_TabType(5) := p_flwsts_wf_rec.object_version_number;
5645:
5646: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5647: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5648: 'Calling WF_ENGINE.AddItemAttrNumberArray to add attributes');
5649: END IF;
5650:

Line 5647: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,

5643: l_wf_aname_TabType(5) := lc_object_version_number;
5644: l_wf_avalue_TabType(5) := p_flwsts_wf_rec.object_version_number;
5645:
5646: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5647: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5648: 'Calling WF_ENGINE.AddItemAttrNumberArray to add attributes');
5649: END IF;
5650:
5651: Wf_Engine.AddItemAttrNumberArray(itemtype => p_flwsts_wf_rec.wf_item_type,

Line 5690: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

5686: number_value => p_flwsts_wf_rec.object_version_number
5687: );
5688: */
5689:
5690: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5691: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5692: 'Calling WF_ENGINE.StartProcess');
5693: END IF;
5694:

Line 5691: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,

5687: );
5688: */
5689:
5690: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5691: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5692: 'Calling WF_ENGINE.StartProcess');
5693: END IF;
5694:
5695: -- The WF process is kicked off now in deferred mode

Line 5718: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

5714: Fnd_Msg_Pub.Count_And_Get
5715: (p_count => x_msg_count,
5716: p_data => x_msg_data );
5717:
5718: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5719: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.END',
5720: 'Leaving Launch_Flwsts_Wf');
5721: END IF;
5722:

Line 5719: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.END',

5715: (p_count => x_msg_count,
5716: p_data => x_msg_data );
5717:
5718: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5719: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.END',
5720: 'Leaving Launch_Flwsts_Wf');
5721: END IF;
5722:
5723: EXCEPTION

Line 5733: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

5729: (p_count => x_msg_count,
5730: p_data => x_msg_data );
5731:
5732: -- save message in debug log
5733: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5734: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
5735: 'EXC_ERROR['||x_msg_data||']');
5736: END IF;
5737:

Line 5734: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,

5730: p_data => x_msg_data );
5731:
5732: -- save message in debug log
5733: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5734: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
5735: 'EXC_ERROR['||x_msg_data||']');
5736: END IF;
5737:
5738: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 5746: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

5742: -- save message in fnd stack
5743: IF Fnd_Msg_Pub.Check_Msg_Level
5744: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5745: THEN
5746: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5747: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5748: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5749: END IF;
5750: Fnd_Msg_Pub.Add_Exc_Msg

Line 5747: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,

5743: IF Fnd_Msg_Pub.Check_Msg_Level
5744: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5745: THEN
5746: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5747: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5748: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5749: END IF;
5750: Fnd_Msg_Pub.Add_Exc_Msg
5751: (G_PKG_NAME ,

Line 5760: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

5756: ( p_count => x_msg_count,
5757: p_data => x_msg_data );
5758:
5759: -- save message in debug log
5760: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5761: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
5762: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
5763: END IF;
5764:

Line 5761: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,

5757: p_data => x_msg_data );
5758:
5759: -- save message in debug log
5760: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5761: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
5762: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
5763: END IF;
5764:
5765: WHEN OTHERS THEN

Line 5773: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

5769: -- save message in fnd stack
5770: IF Fnd_Msg_Pub.Check_Msg_Level
5771: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5772: THEN
5773: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5774: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5775: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5776: END IF;
5777: Fnd_Msg_Pub.Add_Exc_Msg

Line 5774: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,

5770: IF Fnd_Msg_Pub.Check_Msg_Level
5771: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5772: THEN
5773: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5774: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5775: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5776: END IF;
5777: Fnd_Msg_Pub.Add_Exc_Msg
5778: (G_PKG_NAME ,

Line 5787: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

5783: (p_count => x_msg_count,
5784: p_data => x_msg_data );
5785:
5786: -- save message in debug log
5787: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5788: -- create a seeded message
5789: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
5790: 'SQL Message['||SQLERRM||']' );
5791: END IF;

Line 5789: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,

5785:
5786: -- save message in debug log
5787: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5788: -- create a seeded message
5789: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
5790: 'SQL Message['||SQLERRM||']' );
5791: END IF;
5792:
5793: END Launch_Flwsts_Wf;

Line 5869: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

5865: IF Fnd_Api.to_Boolean( p_init_msg_list ) THEN
5866: Fnd_Msg_Pub.initialize;
5867: END IF;
5868:
5869: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5870: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',
5871: 'Entered UPDATE_RO_STATUS_WEBSRVC');
5872: END IF;
5873:

Line 5870: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',

5866: Fnd_Msg_Pub.initialize;
5867: END IF;
5868:
5869: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5870: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',
5871: 'Entered UPDATE_RO_STATUS_WEBSRVC');
5872: END IF;
5873:
5874: l_return_Status := Fnd_Api.G_RET_STS_SUCCESS;

Line 5918: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

5914: Fnd_Msg_Pub.Count_And_Get
5915: (p_count => x_msg_count,
5916: p_data => x_msg_data );
5917:
5918: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5919: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.END',
5920: 'Leaving UPDATE_RO_STATUS_WEBSRVC');
5921: END IF;
5922:

Line 5919: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.END',

5915: (p_count => x_msg_count,
5916: p_data => x_msg_data );
5917:
5918: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5919: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.END',
5920: 'Leaving UPDATE_RO_STATUS_WEBSRVC');
5921: END IF;
5922:
5923: EXCEPTION

Line 5933: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

5929: (p_count => x_msg_count,
5930: p_data => x_msg_data );
5931:
5932: -- save message in debug log
5933: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5934: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
5935: 'EXC_ERROR['||x_msg_data||']');
5936: END IF;
5937:

Line 5934: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,

5930: p_data => x_msg_data );
5931:
5932: -- save message in debug log
5933: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5934: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
5935: 'EXC_ERROR['||x_msg_data||']');
5936: END IF;
5937:
5938: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 5946: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

5942: -- save message in fnd stack
5943: IF Fnd_Msg_Pub.Check_Msg_Level
5944: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5945: THEN
5946: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5947: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5948: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5949: END IF;
5950: Fnd_Msg_Pub.Add_Exc_Msg

Line 5947: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,

5943: IF Fnd_Msg_Pub.Check_Msg_Level
5944: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5945: THEN
5946: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5947: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5948: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5949: END IF;
5950: Fnd_Msg_Pub.Add_Exc_Msg
5951: (G_PKG_NAME ,

Line 5960: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

5956: ( p_count => x_msg_count,
5957: p_data => x_msg_data );
5958:
5959: -- save message in debug log
5960: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5961: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
5962: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
5963: END IF;
5964:

Line 5961: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,

5957: p_data => x_msg_data );
5958:
5959: -- save message in debug log
5960: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5961: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
5962: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
5963: END IF;
5964:
5965: WHEN OTHERS THEN

Line 5973: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

5969: -- save message in fnd stack
5970: IF Fnd_Msg_Pub.Check_Msg_Level
5971: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5972: THEN
5973: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5974: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5975: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5976: END IF;
5977: Fnd_Msg_Pub.Add_Exc_Msg

Line 5974: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,

5970: IF Fnd_Msg_Pub.Check_Msg_Level
5971: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5972: THEN
5973: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5974: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5975: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5976: END IF;
5977: Fnd_Msg_Pub.Add_Exc_Msg
5978: (G_PKG_NAME ,

Line 5987: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

5983: (p_count => x_msg_count,
5984: p_data => x_msg_data );
5985:
5986: -- save message in debug log
5987: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5988: -- create a seeded message
5989: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
5990: 'SQL Message['||SQLERRM||']' );
5991: END IF;

Line 5989: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,

5985:
5986: -- save message in debug log
5987: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5988: -- create a seeded message
5989: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
5990: 'SQL Message['||SQLERRM||']' );
5991: END IF;
5992:
5993: END UPDATE_RO_STATUS_WebSrvc;