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 3072: l_debug_level NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;

3068: l_long_text_tmp LONG;
3069: l_fnd_lobs_rec fnd_lobs_cur%ROWTYPE;
3070: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Attachments';
3071: l_api_version CONSTANT NUMBER := 1.0;
3072: l_debug_level NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
3073: l_procedure_level NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3074: l_statement_level NUMBER := Fnd_Log.LEVEL_STATEMENT;
3075: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;
3076:

Line 3073: l_procedure_level NUMBER := Fnd_Log.LEVEL_PROCEDURE;

3069: l_fnd_lobs_rec fnd_lobs_cur%ROWTYPE;
3070: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Attachments';
3071: l_api_version CONSTANT NUMBER := 1.0;
3072: l_debug_level NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
3073: l_procedure_level NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3074: l_statement_level NUMBER := Fnd_Log.LEVEL_STATEMENT;
3075: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;
3076:
3077: BEGIN

Line 3074: l_statement_level NUMBER := Fnd_Log.LEVEL_STATEMENT;

3070: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Attachments';
3071: l_api_version CONSTANT NUMBER := 1.0;
3072: l_debug_level NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
3073: l_procedure_level NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3074: l_statement_level NUMBER := Fnd_Log.LEVEL_STATEMENT;
3075: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;
3076:
3077: BEGIN
3078:

Line 3075: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;

3071: l_api_version CONSTANT NUMBER := 1.0;
3072: l_debug_level NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
3073: l_procedure_level NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3074: l_statement_level NUMBER := Fnd_Log.LEVEL_STATEMENT;
3075: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;
3076:
3077: BEGIN
3078:
3079: -- Standard Start of API savepoint

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

3078:
3079: -- Standard Start of API savepoint
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;

Line 3083: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3079: -- Standard Start of API savepoint
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:

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

3101:
3102: -- Initialize API return status to success
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;

Line 3106: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3102: -- Initialize API return status to success
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:

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

3112: ( p_repair_line_id => p_original_ro_id)) THEN
3113: RAISE Fnd_Api.G_EXC_ERROR;
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;

Line 3117: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3113: RAISE Fnd_Api.G_EXC_ERROR;
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:

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

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
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;

Line 3123: Fnd_Log.STRING(Fnd_Log.Level_Statement,

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
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:

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

3129: ( p_repair_line_id => p_new_ro_id)) THEN
3130: RAISE Fnd_Api.G_EXC_ERROR;
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;

Line 3134: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3130: RAISE Fnd_Api.G_EXC_ERROR;
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:

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

3139: -- Begin API Body
3140: -- Use cursor loop to get all attachments associated with
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;

Line 3144: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3140: -- Use cursor loop to get all attachments associated with
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:

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

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
3150: Fnd_Log.STRING(Fnd_Log.Level_Event,
3151: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3152: 'Started Copying of Attachments ');
3153: END IF;

Line 3150: Fnd_Log.STRING(Fnd_Log.Level_Event,

3146: 'Open main cursor');
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:

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

3154:
3155:
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:

Line 3159: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3155:
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;

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

3170: IF (docrec.usage_type = 'O'
3171: AND docrec.datatype_id IN (1,2,6,5) ) THEN
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;

Line 3175: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3171: AND docrec.datatype_id IN (1,2,6,5) ) THEN
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:

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

3230: OPEN shorttext(docrec.media_id);
3231: FETCH shorttext INTO l_short_text_tmp;
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);

Line 3235: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3231: FETCH shorttext INTO l_short_text_tmp;
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;

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

3253: OPEN longtext(docrec.media_id);
3254: FETCH longtext INTO l_long_text_tmp;
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);

Line 3258: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3254: FETCH longtext INTO l_long_text_tmp;
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;

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

3286: l_fnd_lobs_rec.oracle_charset,
3287: l_fnd_lobs_rec.file_format;
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);

Line 3291: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3287: l_fnd_lobs_rec.file_format;
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;

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

3325:
3326: END IF; -- end if usage_type = 'O' and datatype in (1,2,6,5)
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);

Line 3330: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3326: END IF; -- end if usage_type = 'O' and datatype in (1,2,6,5)
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;

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

3422: Fnd_Msg_Pub.Count_And_Get
3423: (p_count => x_msg_count,
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;

Line 3427: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3423: (p_count => x_msg_count,
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:

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

3436: Fnd_Msg_Pub.Count_And_Get
3437: (p_count => x_msg_count,
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;

Line 3441: Fnd_Log.STRING(Fnd_Log.LEVEL_ERROR,

3437: (p_count => x_msg_count,
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:

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

3448: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
3449: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count,
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;

Line 3453: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,

3449: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count,
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:

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

3465: END IF;
3466: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count,
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;

Line 3470: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,

3466: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count,
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:

Line 3506: l_debug_level NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;

3502: IS
3503:
3504: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Attachments';
3505: l_api_version CONSTANT NUMBER := 1.0;
3506: l_debug_level NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
3507: l_procedure_level NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3508: l_statement_level NUMBER := Fnd_Log.LEVEL_STATEMENT;
3509: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;
3510:

Line 3507: l_procedure_level NUMBER := Fnd_Log.LEVEL_PROCEDURE;

3503:
3504: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Attachments';
3505: l_api_version CONSTANT NUMBER := 1.0;
3506: l_debug_level NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
3507: l_procedure_level NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3508: l_statement_level NUMBER := Fnd_Log.LEVEL_STATEMENT;
3509: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;
3510:
3511: BEGIN

Line 3508: l_statement_level NUMBER := Fnd_Log.LEVEL_STATEMENT;

3504: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Attachments';
3505: l_api_version CONSTANT NUMBER := 1.0;
3506: l_debug_level NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
3507: l_procedure_level NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3508: l_statement_level NUMBER := Fnd_Log.LEVEL_STATEMENT;
3509: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;
3510:
3511: BEGIN
3512:

Line 3509: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;

3505: l_api_version CONSTANT NUMBER := 1.0;
3506: l_debug_level NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
3507: l_procedure_level NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3508: l_statement_level NUMBER := Fnd_Log.LEVEL_STATEMENT;
3509: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;
3510:
3511: BEGIN
3512:
3513: -- Standard Start of API savepoint

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

3512:
3513: -- Standard Start of API savepoint
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;

Line 3517: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3513: -- Standard Start of API savepoint
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:

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

3535:
3536: -- Initialize API return status to success
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;

Line 3540: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3536: -- Initialize API return status to success
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:

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

3546: ( p_repair_line_id => p_repair_line_id)) THEN
3547: RAISE Fnd_Api.G_EXC_ERROR;
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;

Line 3551: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3547: RAISE Fnd_Api.G_EXC_ERROR;
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:

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

3557: -- Begin API Body
3558: --
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;

Line 3562: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3558: --
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:

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

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
3568: Fnd_Log.STRING(Fnd_Log.Level_Event,
3569: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3570: 'Started Deleting of Attachments');
3571: END IF;

Line 3568: Fnd_Log.STRING(Fnd_Log.Level_Event,

3564: 'Deleting from fnd_documents_short_text');
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:

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

3583: AND fd.datatype_id = 1
3584: AND fad.pk1_value = TO_CHAR(p_repair_line_id));
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;

Line 3588: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3584: AND fad.pk1_value = TO_CHAR(p_repair_line_id));
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:

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

3602: AND fd.datatype_id = 2
3603: AND fad.pk1_value = TO_CHAR(p_repair_line_id));
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;

Line 3607: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3603: AND fad.pk1_value = TO_CHAR(p_repair_line_id));
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:

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

3622: AND fad.pk1_value = TO_CHAR(p_repair_line_id));
3623:
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;

Line 3627: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3623:
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:

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

3641: AND fd.datatype_id = 6
3642: AND fad.pk1_value = TO_CHAR(p_repair_line_id));
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;

Line 3646: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3642: AND fad.pk1_value = TO_CHAR(p_repair_line_id));
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:

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

3656: AND fd.usage_type = 'O'
3657: AND fad.pk1_value = TO_CHAR(p_repair_line_id));
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;

Line 3661: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3657: AND fad.pk1_value = TO_CHAR(p_repair_line_id));
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:

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

3670: FROM fnd_attached_documents fad
3671: WHERE fad.pk1_value = TO_CHAR(p_repair_line_id));
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;

Line 3675: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3671: WHERE fad.pk1_value = TO_CHAR(p_repair_line_id));
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:

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

3691: Fnd_Msg_Pub.Count_And_Get
3692: (p_count => x_msg_count,
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;

Line 3696: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3692: (p_count => x_msg_count,
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:

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

3705: Fnd_Msg_Pub.Count_And_Get
3706: (p_count => x_msg_count,
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;

Line 3710: Fnd_Log.STRING(Fnd_Log.LEVEL_ERROR,

3706: (p_count => x_msg_count,
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:

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

3717: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
3718: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count,
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;

Line 3722: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,

3718: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count,
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:

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

3734: END IF;
3735: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count,
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;

Line 3739: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,

3735: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count,
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:

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

3813:
3814:
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;

Line 3818: Fnd_Log.STRING (Fnd_Log.level_procedure,

3814:
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

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

3831:
3832: l_repair_status_Rec := p_repair_status_rec;
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;

Line 3836: Fnd_Log.STRING (Fnd_Log.level_event,

3832: l_repair_status_Rec := p_repair_status_rec;
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,

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

3841: l_repair_status_rec,
3842: l_return_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;

Line 3846: Fnd_Log.STRING (Fnd_Log.level_event,

3842: l_return_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:

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

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
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['

Line 3852: Fnd_Log.STRING (Fnd_Log.level_event,

3848: '-----step 2: Validate input ');
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||']');

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

3876: RAISE Fnd_Api.G_EXC_ERROR;
3877: END IF;
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['

Line 3881: Fnd_Log.STRING (Fnd_Log.level_event,

3877: END IF;
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||']');

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

3905:
3906:
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;

Line 3910: Fnd_Log.STRING (Fnd_Log.level_event,

3906:
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 (

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

3945:
3946: -- Standard call to get message count and IF count is get message info.
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;

Line 3950: Fnd_Log.STRING (Fnd_Log.level_procedure,

3946: -- Standard call to get message count and IF count is get message info.
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:

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

3957: THEN
3958: x_return_status := Fnd_Api.G_RET_STS_ERROR;
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;

Line 3962: Fnd_Log.STRING (Fnd_Log.level_error,

3958: x_return_status := Fnd_Api.G_RET_STS_ERROR;
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

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

3968: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3969: ROLLBACK TO update_ro_status_pvt;
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;

Line 3973: Fnd_Log.STRING (Fnd_Log.level_exception,

3969: ROLLBACK TO update_ro_status_pvt;
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

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

3984: END IF;
3985:
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;

Line 3989: Fnd_Log.STRING (Fnd_Log.level_exception,

3985:
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;

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

4102: IF Fnd_Api.to_Boolean( p_init_msg_list ) THEN
4103: Fnd_Msg_Pub.initialize;
4104: END IF;
4105:
4106: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4107: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',
4108: 'Entered Update_Flow_Status');
4109: END IF;
4110:

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

4103: Fnd_Msg_Pub.initialize;
4104: END IF;
4105:
4106: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4107: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',
4108: 'Entered Update_Flow_Status');
4109: END IF;
4110:
4111: -- Initialize API return status to success

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

4115:
4116: -- STEP 1: Validate Mandatory Parameters.
4117:
4118: -- Check the required parameters
4119: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4120: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4121: 'Checking required parameters');
4122: END IF;
4123:

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

4116: -- STEP 1: Validate Mandatory Parameters.
4117:
4118: -- Check the required parameters
4119: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4120: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4121: 'Checking required parameters');
4122: END IF;
4123:
4124: -- Check the required parameters

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

4159: RAISE Fnd_Api.G_EXC_ERROR;
4160: END IF;
4161:
4162:
4163: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4164: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4165: 'Calling Cursor c_get_trans_flags');
4166: END IF;
4167:

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

4160: END IF;
4161:
4162:
4163: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4164: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4165: 'Calling Cursor c_get_trans_flags');
4166: END IF;
4167:
4168: OPEN c_get_trans_details;

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

4176: l_to_flow_status_code,
4177: l_from_flow_status_code;
4178: CLOSE c_get_trans_details;
4179:
4180: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4181: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4182: 'After calling Cursor c_get_trans_details');
4183: END IF;
4184:

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

4177: l_from_flow_status_code;
4178: CLOSE c_get_trans_details;
4179:
4180: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4181: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4182: 'After calling Cursor c_get_trans_details');
4183: END IF;
4184:
4185: -- Validate whether the set up exists for transition of

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

4205: -- We do not need to call the 'update allowed' function if the
4206: -- 'all resp' have access or we are requested to skip the check.
4207: IF (l_allow_all_resp_flag <> 'Y' AND p_check_access_flag = 'Y') THEN
4208:
4209: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4210: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4211: 'Calling Is_Flwsts_Update_Allowed');
4212: END IF;
4213:

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

4206: -- 'all resp' have access or we are requested to skip the check.
4207: IF (l_allow_all_resp_flag <> 'Y' AND p_check_access_flag = 'Y') THEN
4208:
4209: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4210: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4211: 'Calling Is_Flwsts_Update_Allowed');
4212: END IF;
4213:
4214: IF NOT Is_Flwsts_Update_Allowed(p_repair_type_id => p_repair_type_id,

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

4226: -- won't show.
4227: RAISE Fnd_Api.G_EXC_ERROR;
4228: END IF;
4229:
4230: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4231: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4232: 'After calling Is_Flwsts_Update_Allowed');
4233: END IF;
4234: END IF;

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

4227: RAISE Fnd_Api.G_EXC_ERROR;
4228: END IF;
4229:
4230: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4231: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4232: 'After calling Is_Flwsts_Update_Allowed');
4233: END IF;
4234: END IF;
4235:

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

4237:
4238: -- Validate reason code if passed
4239: IF p_reason_code IS NOT NULL THEN
4240:
4241: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4242: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4243: 'Calling Cursor c_check_status_reason');
4244: END IF;
4245:

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

4238: -- Validate reason code if passed
4239: IF p_reason_code IS NOT NULL THEN
4240:
4241: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4242: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4243: 'Calling Cursor c_check_status_reason');
4244: END IF;
4245:
4246: OPEN c_check_status_reason;

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

4272: l_flwsts_wf_rec.wf_item_type := l_wf_item_type;
4273: l_flwsts_wf_rec.wf_item_key := l_wf_item_key;
4274: l_flwsts_wf_rec.wf_process_name := l_wf_process_name;
4275:
4276: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4277: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4278: 'Calling Launch_Flwsts_Wf');
4279: END IF;
4280:

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

4273: l_flwsts_wf_rec.wf_item_key := l_wf_item_key;
4274: l_flwsts_wf_rec.wf_process_name := l_wf_process_name;
4275:
4276: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4277: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4278: 'Calling Launch_Flwsts_Wf');
4279: END IF;
4280:
4281: Launch_Flwsts_Wf (

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

4300: END IF;
4301:
4302: -- STEP 6: Update CSD_REPAIRS with status details.
4303:
4304: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4305: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4306: 'Calling update Repairs');
4307: END IF;
4308:

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

4301:
4302: -- STEP 6: Update CSD_REPAIRS with status details.
4303:
4304: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4305: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4306: 'Calling update Repairs');
4307: END IF;
4308:
4309: --BEGIN

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

4349: Fnd_Msg_Pub.ADD;
4350: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4351: end if;
4352:
4353: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4354: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4355: 'After calling update Repairs');
4356: END IF;
4357:

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

4350: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4351: end if;
4352:
4353: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4354: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4355: 'After calling update Repairs');
4356: END IF;
4357:
4358: -- STEP 7: Log 'Status Change' activity.

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

4359:
4360: -- Log an activity if setup to do so.
4361: IF l_capture_activity_flag = 'Y' THEN
4362:
4363: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4364: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4365: 'Calling Repair History to log activity');
4366: END IF;
4367:

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

4360: -- Log an activity if setup to do so.
4361: IF l_capture_activity_flag = 'Y' THEN
4362:
4363: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4364: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4365: 'Calling Repair History to log activity');
4366: END IF;
4367:
4368:

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

4512: Fnd_Msg_Pub.Count_And_Get
4513: (p_count => x_msg_count,
4514: p_data => x_msg_data );
4515:
4516: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4517: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.END',
4518: 'Leaving Update_Flow_Status');
4519: END IF;
4520:

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

4513: (p_count => x_msg_count,
4514: p_data => x_msg_data );
4515:
4516: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4517: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.END',
4518: 'Leaving Update_Flow_Status');
4519: END IF;
4520:
4521: EXCEPTION

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

4527: (p_count => x_msg_count,
4528: p_data => x_msg_data );
4529:
4530: -- save message in debug log
4531: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4532: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
4533: 'EXC_ERROR['||x_msg_data||']');
4534: END IF;
4535:

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

4528: p_data => x_msg_data );
4529:
4530: -- save message in debug log
4531: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4532: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
4533: 'EXC_ERROR['||x_msg_data||']');
4534: END IF;
4535:
4536: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

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

4540: -- save message in fnd stack
4541: IF Fnd_Msg_Pub.Check_Msg_Level
4542: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
4543: THEN
4544: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4545: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
4546: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
4547: END IF;
4548: Fnd_Msg_Pub.Add_Exc_Msg

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

4541: IF Fnd_Msg_Pub.Check_Msg_Level
4542: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
4543: THEN
4544: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4545: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
4546: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
4547: END IF;
4548: Fnd_Msg_Pub.Add_Exc_Msg
4549: (G_PKG_NAME ,

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

4554: ( p_count => x_msg_count,
4555: p_data => x_msg_data );
4556:
4557: -- save message in debug log
4558: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4559: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
4560: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
4561: END IF;
4562:

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

4555: p_data => x_msg_data );
4556:
4557: -- save message in debug log
4558: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4559: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
4560: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
4561: END IF;
4562:
4563: WHEN OTHERS THEN

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

4567: -- save message in fnd stack
4568: IF Fnd_Msg_Pub.Check_Msg_Level
4569: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
4570: THEN
4571: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4572: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
4573: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
4574: END IF;
4575: Fnd_Msg_Pub.Add_Exc_Msg

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

4568: IF Fnd_Msg_Pub.Check_Msg_Level
4569: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
4570: THEN
4571: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4572: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
4573: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
4574: END IF;
4575: Fnd_Msg_Pub.Add_Exc_Msg
4576: (G_PKG_NAME ,

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

4581: (p_count => x_msg_count,
4582: p_data => x_msg_data );
4583:
4584: -- save message in debug log
4585: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4586: -- create a seeded message
4587: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
4588: 'SQL Message['||SQLERRM||']' );
4589: END IF;

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

4583:
4584: -- save message in debug log
4585: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4586: -- create a seeded message
4587: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
4588: 'SQL Message['||SQLERRM||']' );
4589: END IF;
4590:
4591: END Update_Flow_Status;

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

4621: );
4622:
4623: BEGIN
4624:
4625: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4626: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',
4627: 'Entered Is_Rt_Update_Allowed');
4628: END IF;
4629:

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

4622:
4623: BEGIN
4624:
4625: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4626: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',
4627: 'Entered Is_Rt_Update_Allowed');
4628: END IF;
4629:
4630: -- Check the required parameters

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

4627: 'Entered Is_Rt_Update_Allowed');
4628: END IF;
4629:
4630: -- Check the required parameters
4631: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4632: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4633: 'Checking required parameters');
4634: END IF;
4635:

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

4628: END IF;
4629:
4630: -- Check the required parameters
4631: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4632: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4633: 'Checking required parameters');
4634: END IF;
4635:
4636: -- Check the required parameters

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

4660: ELSE
4661: RETURN TRUE;
4662: END IF;
4663:
4664: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4665: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.END',
4666: 'Leaving Is_Rt_Update_Allowed');
4667: END IF;
4668:

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

4661: RETURN TRUE;
4662: END IF;
4663:
4664: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4665: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.END',
4666: 'Leaving Is_Rt_Update_Allowed');
4667: END IF;
4668:
4669: END Is_Rt_Update_Allowed;

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

4746: IF Fnd_Api.to_Boolean( p_init_msg_list ) THEN
4747: Fnd_Msg_Pub.initialize;
4748: END IF;
4749:
4750: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4751: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',
4752: 'Entered Update_Repair_Type');
4753: END IF;
4754:

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

4747: Fnd_Msg_Pub.initialize;
4748: END IF;
4749:
4750: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4751: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',
4752: 'Entered Update_Repair_Type');
4753: END IF;
4754:
4755: -- Initialize API return status to success

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

4757:
4758: -- Api body starts
4759:
4760: -- Check the required parameters
4761: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4762: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4763: 'Checking required parameters');
4764: END IF;
4765:

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

4758: -- Api body starts
4759:
4760: -- Check the required parameters
4761: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4762: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4763: 'Checking required parameters');
4764: END IF;
4765:
4766: -- Check the required parameters

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

4791: p_param_name => 'P_OBJECT_VERSION_NUMBER',
4792: p_api_name => lc_api_name);
4793:
4794:
4795: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4796: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4797: 'Calling Cursor c_get_trans_flags');
4798: END IF;
4799:

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

4792: p_api_name => lc_api_name);
4793:
4794:
4795: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4796: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4797: 'Calling Cursor c_get_trans_flags');
4798: END IF;
4799:
4800: OPEN c_get_trans_flags;

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

4800: OPEN c_get_trans_flags;
4801: FETCH c_get_trans_flags INTO l_reason_required_flag, l_capture_activity_flag;
4802: CLOSE c_get_trans_flags;
4803:
4804: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4805: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4806: 'After calling Cursor c_get_trans_flags');
4807: END IF;
4808:

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

4801: FETCH c_get_trans_flags INTO l_reason_required_flag, l_capture_activity_flag;
4802: CLOSE c_get_trans_flags;
4803:
4804: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4805: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4806: 'After calling Cursor c_get_trans_flags');
4807: END IF;
4808:
4809: -- 5362259, validate p_to_repair_type_id and show error msg

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

4832: --5362259, changing exeception from G_EXC_UPEXPECTED_ERROR to G_EXC_ERROR
4833: RAISE Fnd_Api.G_EXC_ERROR;
4834: END IF;
4835:
4836: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4837: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4838: 'Calling Is_Rt_Update_Allowed');
4839: END IF;
4840:

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

4833: RAISE Fnd_Api.G_EXC_ERROR;
4834: END IF;
4835:
4836: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4837: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4838: 'Calling Is_Rt_Update_Allowed');
4839: END IF;
4840:
4841: IF NOT Is_Rt_Update_Allowed(p_from_repair_type_id => p_from_repair_type_id,

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

4849: Fnd_Msg_Pub.ADD;
4850: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4851: END IF;
4852:
4853: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4854: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4855: 'After calling Is_Rt_Update_Allowed');
4856: END IF;
4857:

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

4850: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4851: END IF;
4852:
4853: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4854: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4855: 'After calling Is_Rt_Update_Allowed');
4856: END IF;
4857:
4858:

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

4855: 'After calling Is_Rt_Update_Allowed');
4856: END IF;
4857:
4858:
4859: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4860: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4861: 'Calling Cursor c_check_rt_reason');
4862: END IF;
4863:

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

4856: END IF;
4857:
4858:
4859: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4860: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4861: 'Calling Cursor c_check_rt_reason');
4862: END IF;
4863:
4864: -- Validate reason code if passed

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

4875: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4876: END IF;
4877: END IF;
4878:
4879: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4880: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4881: 'calling update for Repair Type');
4882: END IF;
4883:

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

4876: END IF;
4877: END IF;
4878:
4879: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4880: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4881: 'calling update for Repair Type');
4882: END IF;
4883:
4884: BEGIN

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

4905: Fnd_Msg_Pub.ADD;
4906: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4907: END;
4908:
4909: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4910: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4911: 'After calling update for Repair Type');
4912: END IF;
4913:

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

4906: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4907: END;
4908:
4909: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4910: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4911: 'After calling update for Repair Type');
4912: END IF;
4913:
4914: -- Log an activity if setup to do so.

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

4913:
4914: -- Log an activity if setup to do so.
4915: IF l_capture_activity_flag = 'Y' THEN
4916:
4917: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4918: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4919: 'Calling Repair History to log activity');
4920: END IF;
4921:

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

4914: -- Log an activity if setup to do so.
4915: IF l_capture_activity_flag = 'Y' THEN
4916:
4917: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4918: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
4919: 'Calling Repair History to log activity');
4920: END IF;
4921:
4922: OPEN c_get_repair_types;

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

5036: Fnd_Msg_Pub.Count_And_Get
5037: (p_count => x_msg_count,
5038: p_data => x_msg_data );
5039:
5040: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5041: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.END',
5042: 'Leaving Update_Repair_Type');
5043: END IF;
5044:

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

5037: (p_count => x_msg_count,
5038: p_data => x_msg_data );
5039:
5040: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5041: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.END',
5042: 'Leaving Update_Repair_Type');
5043: END IF;
5044:
5045: EXCEPTION

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

5051: (p_count => x_msg_count,
5052: p_data => x_msg_data );
5053:
5054: -- save message in debug log
5055: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5056: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
5057: 'EXC_ERROR['||x_msg_data||']');
5058: END IF;
5059:

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

5052: p_data => x_msg_data );
5053:
5054: -- save message in debug log
5055: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5056: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
5057: 'EXC_ERROR['||x_msg_data||']');
5058: END IF;
5059:
5060: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

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

5064: -- save message in fnd stack
5065: IF Fnd_Msg_Pub.Check_Msg_Level
5066: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5067: THEN
5068: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5069: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5070: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5071: END IF;
5072: Fnd_Msg_Pub.Add_Exc_Msg

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

5065: IF Fnd_Msg_Pub.Check_Msg_Level
5066: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5067: THEN
5068: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5069: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5070: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5071: END IF;
5072: Fnd_Msg_Pub.Add_Exc_Msg
5073: (G_PKG_NAME ,

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

5078: ( p_count => x_msg_count,
5079: p_data => x_msg_data );
5080:
5081: -- save message in debug log
5082: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5083: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
5084: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
5085: END IF;
5086:

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

5079: p_data => x_msg_data );
5080:
5081: -- save message in debug log
5082: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5083: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
5084: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
5085: END IF;
5086:
5087: WHEN OTHERS THEN

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

5091: -- save message in fnd stack
5092: IF Fnd_Msg_Pub.Check_Msg_Level
5093: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5094: THEN
5095: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5096: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5097: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5098: END IF;
5099: Fnd_Msg_Pub.Add_Exc_Msg

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

5092: IF Fnd_Msg_Pub.Check_Msg_Level
5093: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5094: THEN
5095: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5096: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5097: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5098: END IF;
5099: Fnd_Msg_Pub.Add_Exc_Msg
5100: (G_PKG_NAME ,

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

5105: (p_count => x_msg_count,
5106: p_data => x_msg_data );
5107:
5108: -- save message in debug log
5109: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5110: -- create a seeded message
5111: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
5112: 'SQL Message['||SQLERRM||']' );
5113: END IF;

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

5107:
5108: -- save message in debug log
5109: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5110: -- create a seeded message
5111: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
5112: 'SQL Message['||SQLERRM||']' );
5113: END IF;
5114:
5115: END Update_Repair_Type;

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

5145: );
5146:
5147: BEGIN
5148:
5149: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5150: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',
5151: 'Entered Is_Flwsts_Update_Allowed');
5152: END IF;
5153:

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

5146:
5147: BEGIN
5148:
5149: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5150: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',
5151: 'Entered Is_Flwsts_Update_Allowed');
5152: END IF;
5153:
5154: -- Check the required parameters

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

5151: 'Entered Is_Flwsts_Update_Allowed');
5152: END IF;
5153:
5154: -- Check the required parameters
5155: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5156: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5157: 'Checking required parameters');
5158: END IF;
5159:

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

5152: END IF;
5153:
5154: -- Check the required parameters
5155: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5156: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5157: 'Checking required parameters');
5158: END IF;
5159:
5160: -- Check the required parameters

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

5184: ELSE
5185: RETURN TRUE;
5186: END IF;
5187:
5188: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5189: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.END',
5190: 'Leaving Is_Flwsts_Update_Allowed');
5191: END IF;
5192:

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

5185: RETURN TRUE;
5186: END IF;
5187:
5188: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5189: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.END',
5190: 'Leaving Is_Flwsts_Update_Allowed');
5191: END IF;
5192:
5193: END Is_Flwsts_Update_Allowed;

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

5242: IF Fnd_Api.to_Boolean( p_init_msg_list ) THEN
5243: Fnd_Msg_Pub.initialize;
5244: END IF;
5245:
5246: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5247: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',
5248: 'Entered Launch_Flwsts_Wf');
5249: END IF;
5250:

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

5243: Fnd_Msg_Pub.initialize;
5244: END IF;
5245:
5246: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5247: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',
5248: 'Entered Launch_Flwsts_Wf');
5249: END IF;
5250:
5251: -- Initialize API return status to success

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

5253:
5254: -- Api body starts
5255:
5256: -- Check the required parameters
5257: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5258: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5259: 'Checking required parameters');
5260: END IF;
5261:

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

5254: -- Api body starts
5255:
5256: -- Check the required parameters
5257: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5258: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5259: 'Checking required parameters');
5260: END IF;
5261:
5262: -- Check the required parameters

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

5305:
5306: -- Defer the wf process
5307: Wf_Engine.threshold := lc_wf_negative_threshold;
5308:
5309: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5310: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5311: 'Calling WF_ENGINE.CreateProcess');
5312: END IF;
5313:

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

5306: -- Defer the wf process
5307: Wf_Engine.threshold := lc_wf_negative_threshold;
5308:
5309: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5310: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5311: 'Calling WF_ENGINE.CreateProcess');
5312: END IF;
5313:
5314: Wf_Engine.CreateProcess(itemtype => p_flwsts_wf_rec.wf_item_type,

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

5332:
5333: l_wf_aname_TabType(5) := lc_object_version_number;
5334: l_wf_avalue_TabType(5) := p_flwsts_wf_rec.object_version_number;
5335:
5336: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5337: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5338: 'Calling WF_ENGINE.AddItemAttrNumberArray to add attributes');
5339: END IF;
5340:

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

5333: l_wf_aname_TabType(5) := lc_object_version_number;
5334: l_wf_avalue_TabType(5) := p_flwsts_wf_rec.object_version_number;
5335:
5336: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5337: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5338: 'Calling WF_ENGINE.AddItemAttrNumberArray to add attributes');
5339: END IF;
5340:
5341: Wf_Engine.AddItemAttrNumberArray(itemtype => p_flwsts_wf_rec.wf_item_type,

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

5376: number_value => p_flwsts_wf_rec.object_version_number
5377: );
5378: */
5379:
5380: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5381: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5382: 'Calling WF_ENGINE.StartProcess');
5383: END IF;
5384:

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

5377: );
5378: */
5379:
5380: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5381: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
5382: 'Calling WF_ENGINE.StartProcess');
5383: END IF;
5384:
5385: -- The WF process is kicked off now in deferred mode

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

5403: Fnd_Msg_Pub.Count_And_Get
5404: (p_count => x_msg_count,
5405: p_data => x_msg_data );
5406:
5407: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5408: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.END',
5409: 'Leaving Launch_Flwsts_Wf');
5410: END IF;
5411:

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

5404: (p_count => x_msg_count,
5405: p_data => x_msg_data );
5406:
5407: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5408: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.END',
5409: 'Leaving Launch_Flwsts_Wf');
5410: END IF;
5411:
5412: EXCEPTION

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

5418: (p_count => x_msg_count,
5419: p_data => x_msg_data );
5420:
5421: -- save message in debug log
5422: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5423: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
5424: 'EXC_ERROR['||x_msg_data||']');
5425: END IF;
5426:

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

5419: p_data => x_msg_data );
5420:
5421: -- save message in debug log
5422: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5423: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
5424: 'EXC_ERROR['||x_msg_data||']');
5425: END IF;
5426:
5427: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

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

5431: -- save message in fnd stack
5432: IF Fnd_Msg_Pub.Check_Msg_Level
5433: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5434: THEN
5435: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5436: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5437: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5438: END IF;
5439: Fnd_Msg_Pub.Add_Exc_Msg

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

5432: IF Fnd_Msg_Pub.Check_Msg_Level
5433: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5434: THEN
5435: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5436: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5437: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5438: END IF;
5439: Fnd_Msg_Pub.Add_Exc_Msg
5440: (G_PKG_NAME ,

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

5445: ( p_count => x_msg_count,
5446: p_data => x_msg_data );
5447:
5448: -- save message in debug log
5449: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5450: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
5451: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
5452: END IF;
5453:

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

5446: p_data => x_msg_data );
5447:
5448: -- save message in debug log
5449: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5450: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
5451: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
5452: END IF;
5453:
5454: WHEN OTHERS THEN

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

5458: -- save message in fnd stack
5459: IF Fnd_Msg_Pub.Check_Msg_Level
5460: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5461: THEN
5462: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5463: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5464: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5465: END IF;
5466: Fnd_Msg_Pub.Add_Exc_Msg

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

5459: IF Fnd_Msg_Pub.Check_Msg_Level
5460: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5461: THEN
5462: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5463: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5464: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5465: END IF;
5466: Fnd_Msg_Pub.Add_Exc_Msg
5467: (G_PKG_NAME ,

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

5472: (p_count => x_msg_count,
5473: p_data => x_msg_data );
5474:
5475: -- save message in debug log
5476: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5477: -- create a seeded message
5478: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
5479: 'SQL Message['||SQLERRM||']' );
5480: END IF;

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

5474:
5475: -- save message in debug log
5476: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5477: -- create a seeded message
5478: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
5479: 'SQL Message['||SQLERRM||']' );
5480: END IF;
5481:
5482: END Launch_Flwsts_Wf;

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

5554: IF Fnd_Api.to_Boolean( p_init_msg_list ) THEN
5555: Fnd_Msg_Pub.initialize;
5556: END IF;
5557:
5558: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5559: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',
5560: 'Entered UPDATE_RO_STATUS_WEBSRVC');
5561: END IF;
5562:

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

5555: Fnd_Msg_Pub.initialize;
5556: END IF;
5557:
5558: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5559: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',
5560: 'Entered UPDATE_RO_STATUS_WEBSRVC');
5561: END IF;
5562:
5563: l_return_Status := Fnd_Api.G_RET_STS_SUCCESS;

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

5603: Fnd_Msg_Pub.Count_And_Get
5604: (p_count => x_msg_count,
5605: p_data => x_msg_data );
5606:
5607: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5608: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.END',
5609: 'Leaving UPDATE_RO_STATUS_WEBSRVC');
5610: END IF;
5611:

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

5604: (p_count => x_msg_count,
5605: p_data => x_msg_data );
5606:
5607: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5608: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.END',
5609: 'Leaving UPDATE_RO_STATUS_WEBSRVC');
5610: END IF;
5611:
5612: EXCEPTION

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

5618: (p_count => x_msg_count,
5619: p_data => x_msg_data );
5620:
5621: -- save message in debug log
5622: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5623: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
5624: 'EXC_ERROR['||x_msg_data||']');
5625: END IF;
5626:

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

5619: p_data => x_msg_data );
5620:
5621: -- save message in debug log
5622: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5623: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
5624: 'EXC_ERROR['||x_msg_data||']');
5625: END IF;
5626:
5627: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

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

5631: -- save message in fnd stack
5632: IF Fnd_Msg_Pub.Check_Msg_Level
5633: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5634: THEN
5635: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5636: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5637: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5638: END IF;
5639: Fnd_Msg_Pub.Add_Exc_Msg

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

5632: IF Fnd_Msg_Pub.Check_Msg_Level
5633: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5634: THEN
5635: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5636: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5637: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5638: END IF;
5639: Fnd_Msg_Pub.Add_Exc_Msg
5640: (G_PKG_NAME ,

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

5645: ( p_count => x_msg_count,
5646: p_data => x_msg_data );
5647:
5648: -- save message in debug log
5649: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5650: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
5651: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
5652: END IF;
5653:

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

5646: p_data => x_msg_data );
5647:
5648: -- save message in debug log
5649: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5650: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
5651: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
5652: END IF;
5653:
5654: WHEN OTHERS THEN

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

5658: -- save message in fnd stack
5659: IF Fnd_Msg_Pub.Check_Msg_Level
5660: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5661: THEN
5662: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5663: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5664: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5665: END IF;
5666: Fnd_Msg_Pub.Add_Exc_Msg

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

5659: IF Fnd_Msg_Pub.Check_Msg_Level
5660: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5661: THEN
5662: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5663: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5664: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5665: END IF;
5666: Fnd_Msg_Pub.Add_Exc_Msg
5667: (G_PKG_NAME ,

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

5672: (p_count => x_msg_count,
5673: p_data => x_msg_data );
5674:
5675: -- save message in debug log
5676: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5677: -- create a seeded message
5678: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
5679: 'SQL Message['||SQLERRM||']' );
5680: END IF;

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

5674:
5675: -- save message in debug log
5676: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5677: -- create a seeded message
5678: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION, lc_mod_name,
5679: 'SQL Message['||SQLERRM||']' );
5680: END IF;
5681:
5682: END UPDATE_RO_STATUS_WebSrvc;