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_REPAIR_ESTIMATE_PVT dependencies on FND_LOG

Line 3092: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;

3088:
3089: PROCEDURE get_total_estimated_charge(p_repair_line_id IN NUMBER,
3090: x_estimated_charge OUT NOCOPY NUMBER,
3091: x_return_status OUT NOCOPY VARCHAR2) IS
3092: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
3093: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
3094: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3095: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
3096: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;

Line 3093: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;

3089: PROCEDURE get_total_estimated_charge(p_repair_line_id IN NUMBER,
3090: x_estimated_charge OUT NOCOPY NUMBER,
3091: x_return_status OUT NOCOPY VARCHAR2) IS
3092: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
3093: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
3094: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3095: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
3096: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
3097: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;

Line 3094: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;

3090: x_estimated_charge OUT NOCOPY NUMBER,
3091: x_return_status OUT NOCOPY VARCHAR2) IS
3092: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
3093: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
3094: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3095: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
3096: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
3097: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
3098: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;

Line 3095: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;

3091: x_return_status OUT NOCOPY VARCHAR2) IS
3092: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
3093: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
3094: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3095: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
3096: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
3097: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
3098: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
3099: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.get_total_estimated_charge';

Line 3096: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;

3092: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
3093: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
3094: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3095: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
3096: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
3097: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
3098: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
3099: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.get_total_estimated_charge';
3100: BEGIN

Line 3097: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;

3093: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
3094: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3095: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
3096: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
3097: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
3098: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
3099: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.get_total_estimated_charge';
3100: BEGIN
3101: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

Line 3098: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;

3094: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3095: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
3096: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
3097: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
3098: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
3099: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.get_total_estimated_charge';
3100: BEGIN
3101: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3102: THEN

Line 3101: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

3097: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
3098: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
3099: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.get_total_estimated_charge';
3100: BEGIN
3101: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3102: THEN
3103: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3104: lc_mod_name || '.BEGIN',
3105: 'Entered get_total_estimated_charge');

Line 3103: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3099: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.get_total_estimated_charge';
3100: BEGIN
3101: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3102: THEN
3103: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3104: lc_mod_name || '.BEGIN',
3105: 'Entered get_total_estimated_charge');
3106: END IF;
3107:

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

3112: FROM csd_repair_estimate_lines_v
3113: WHERE repair_line_id = p_repair_line_id
3114: AND billing_type IN ('M', 'L', 'E');
3115:
3116: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
3117: THEN
3118: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3119: lc_mod_name || 'out_parameter',
3120: 'x_estimated_charge: ' || x_estimated_charge);

Line 3118: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3114: AND billing_type IN ('M', 'L', 'E');
3115:
3116: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
3117: THEN
3118: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3119: lc_mod_name || 'out_parameter',
3120: 'x_estimated_charge: ' || x_estimated_charge);
3121: END IF;
3122: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

Line 3122: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

3118: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3119: lc_mod_name || 'out_parameter',
3120: 'x_estimated_charge: ' || x_estimated_charge);
3121: END IF;
3122: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3123: THEN
3124: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3125: lc_mod_name || '.END',
3126: 'Leaving get_total_estimated_charge');

Line 3124: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3120: 'x_estimated_charge: ' || x_estimated_charge);
3121: END IF;
3122: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3123: THEN
3124: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3125: lc_mod_name || '.END',
3126: 'Leaving get_total_estimated_charge');
3127: END IF;
3128: EXCEPTION

Line 3172: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;

3168: p_inventory_item_id IN NUMBER, -- required
3169: p_organization_id IN NUMBER, -- required
3170: x_warning_flag OUT NOCOPY VARCHAR2) IS
3171: -- CONSTANTS --
3172: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
3173: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
3174: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3175: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
3176: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;

Line 3173: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;

3169: p_organization_id IN NUMBER, -- required
3170: x_warning_flag OUT NOCOPY VARCHAR2) IS
3171: -- CONSTANTS --
3172: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
3173: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
3174: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3175: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
3176: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
3177: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;

Line 3174: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;

3170: x_warning_flag OUT NOCOPY VARCHAR2) IS
3171: -- CONSTANTS --
3172: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
3173: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
3174: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3175: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
3176: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
3177: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
3178: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;

Line 3175: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;

3171: -- CONSTANTS --
3172: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
3173: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
3174: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3175: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
3176: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
3177: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
3178: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
3179: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.autocreate_estimate_lines';

Line 3176: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;

3172: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
3173: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
3174: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3175: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
3176: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
3177: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
3178: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
3179: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.autocreate_estimate_lines';
3180: lc_api_name CONSTANT VARCHAR2(30) := 'Autocreate_Estimate_Lines';

Line 3177: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;

3173: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
3174: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3175: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
3176: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
3177: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
3178: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
3179: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.autocreate_estimate_lines';
3180: lc_api_name CONSTANT VARCHAR2(30) := 'Autocreate_Estimate_Lines';
3181: lc_api_version CONSTANT NUMBER := 1.0;

Line 3178: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;

3174: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3175: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
3176: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
3177: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
3178: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
3179: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.autocreate_estimate_lines';
3180: lc_api_name CONSTANT VARCHAR2(30) := 'Autocreate_Estimate_Lines';
3181: lc_api_version CONSTANT NUMBER := 1.0;
3182:

Line 3229: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

3225: THEN
3226: Fnd_Msg_Pub.initialize;
3227: END IF;
3228:
3229: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3230: THEN
3231: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3232: lc_mod_name || '.BEGIN',
3233: 'Entered Autocreate_Estimate_Lines');

Line 3231: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3227: END IF;
3228:
3229: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3230: THEN
3231: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3232: lc_mod_name || '.BEGIN',
3233: 'Entered Autocreate_Estimate_Lines');
3234: END IF;
3235:

Line 3237: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)

3233: 'Entered Autocreate_Estimate_Lines');
3234: END IF;
3235:
3236: -- log parameters
3237: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
3238: THEN
3239: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3240: lc_mod_name || '.parameter_logging',
3241: 'p_api_version: ' || p_api_version);

Line 3239: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3235:
3236: -- log parameters
3237: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
3238: THEN
3239: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3240: lc_mod_name || '.parameter_logging',
3241: 'p_api_version: ' || p_api_version);
3242: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3243: lc_mod_name || '.parameter_logging',

Line 3242: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3238: THEN
3239: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3240: lc_mod_name || '.parameter_logging',
3241: 'p_api_version: ' || p_api_version);
3242: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3243: lc_mod_name || '.parameter_logging',
3244: 'p_commit: ' || p_commit);
3245: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3246: lc_mod_name || '.parameter_logging',

Line 3245: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3241: 'p_api_version: ' || p_api_version);
3242: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3243: lc_mod_name || '.parameter_logging',
3244: 'p_commit: ' || p_commit);
3245: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3246: lc_mod_name || '.parameter_logging',
3247: 'p_init_msg_list: ' || p_init_msg_list);
3248: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3249: lc_mod_name || '.parameter_logging',

Line 3248: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3244: 'p_commit: ' || p_commit);
3245: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3246: lc_mod_name || '.parameter_logging',
3247: 'p_init_msg_list: ' || p_init_msg_list);
3248: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3249: lc_mod_name || '.parameter_logging',
3250: 'p_validation_level: ' || p_validation_level);
3251: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3252: lc_mod_name || '.parameter_logging',

Line 3251: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3247: 'p_init_msg_list: ' || p_init_msg_list);
3248: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3249: lc_mod_name || '.parameter_logging',
3250: 'p_validation_level: ' || p_validation_level);
3251: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3252: lc_mod_name || '.parameter_logging',
3253: 'p_repair_line_id: ' || p_repair_line_id);
3254: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3255: lc_mod_name || '.parameter_logging',

Line 3254: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3250: 'p_validation_level: ' || p_validation_level);
3251: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3252: lc_mod_name || '.parameter_logging',
3253: 'p_repair_line_id: ' || p_repair_line_id);
3254: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3255: lc_mod_name || '.parameter_logging',
3256: 'p_estimate_id: ' || p_estimate_id);
3257: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3258: lc_mod_name || '.parameter_logging',

Line 3257: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3253: 'p_repair_line_id: ' || p_repair_line_id);
3254: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3255: lc_mod_name || '.parameter_logging',
3256: 'p_estimate_id: ' || p_estimate_id);
3257: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3258: lc_mod_name || '.parameter_logging',
3259: 'p_repair_type_id: ' || p_repair_type_id);
3260: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3261: lc_mod_name || '.parameter_logging',

Line 3260: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3256: 'p_estimate_id: ' || p_estimate_id);
3257: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3258: lc_mod_name || '.parameter_logging',
3259: 'p_repair_type_id: ' || p_repair_type_id);
3260: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3261: lc_mod_name || '.parameter_logging',
3262: 'p_business_process_id: ' ||
3263: p_business_process_id);
3264: Fnd_Log.STRING(Fnd_Log.Level_Statement,

Line 3264: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3260: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3261: lc_mod_name || '.parameter_logging',
3262: 'p_business_process_id: ' ||
3263: p_business_process_id);
3264: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3265: lc_mod_name || '.parameter_logging',
3266: 'p_currency_code: ' || p_currency_code);
3267: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3268: lc_mod_name || '.parameter_logging',

Line 3267: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3263: p_business_process_id);
3264: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3265: lc_mod_name || '.parameter_logging',
3266: 'p_currency_code: ' || p_currency_code);
3267: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3268: lc_mod_name || '.parameter_logging',
3269: 'p_incident_id: ' || p_incident_id);
3270: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3271: lc_mod_name || '.parameter_logging',

Line 3270: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3266: 'p_currency_code: ' || p_currency_code);
3267: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3268: lc_mod_name || '.parameter_logging',
3269: 'p_incident_id: ' || p_incident_id);
3270: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3271: lc_mod_name || '.parameter_logging',
3272: 'p_repair_mode: ' || p_repair_mode);
3273: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3274: lc_mod_name || '.parameter_logging',

Line 3273: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3269: 'p_incident_id: ' || p_incident_id);
3270: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3271: lc_mod_name || '.parameter_logging',
3272: 'p_repair_mode: ' || p_repair_mode);
3273: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3274: lc_mod_name || '.parameter_logging',
3275: 'p_inventory_item_id: ' || p_inventory_item_id);
3276: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3277: lc_mod_name || '.parameter_logging',

Line 3276: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3272: 'p_repair_mode: ' || p_repair_mode);
3273: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3274: lc_mod_name || '.parameter_logging',
3275: 'p_inventory_item_id: ' || p_inventory_item_id);
3276: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3277: lc_mod_name || '.parameter_logging',
3278: 'p_organization_id: ' || p_organization_id);
3279: END IF;
3280:

Line 3292: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

3288: -- initialize the warning flag
3289: x_warning_flag := Fnd_Api.G_FALSE;
3290:
3291: -- Check the required parameters
3292: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3293: THEN
3294: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3295: lc_mod_name,
3296: 'Checking required parameters');

Line 3294: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3290:
3291: -- Check the required parameters
3292: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3293: THEN
3294: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3295: lc_mod_name,
3296: 'Checking required parameters');
3297: END IF;
3298:

Line 3336: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

3332: p_param_name => 'ORGANIZATION_ID',
3333: p_api_name => lc_api_name);
3334:
3335: -- Check number of service codes to get mle lines for
3336: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3337: THEN
3338: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3339: lc_mod_name,
3340: 'Counting the number of service codes to apply');

Line 3338: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3334:
3335: -- Check number of service codes to get mle lines for
3336: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3337: THEN
3338: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3339: lc_mod_name,
3340: 'Counting the number of service codes to apply');
3341: END IF;
3342: BEGIN

Line 3356: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)

3352: WHEN OTHERS THEN
3353: l_num_service_codes := 0;
3354: END;
3355:
3356: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
3357: THEN
3358: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3359: lc_mod_name,
3360: 'l_num_service_codes: ' || l_num_service_codes);

Line 3358: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3354: END;
3355:
3356: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
3357: THEN
3358: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3359: lc_mod_name,
3360: 'l_num_service_codes: ' || l_num_service_codes);
3361: END IF;
3362:

Line 3378: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

3374: END IF;
3375: END IF;
3376:
3377: -- Get default Contract.
3378: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3379: THEN
3380: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3381: lc_mod_name,
3382: 'Calling CSD_CHARGE_LINE_UTIL.Get_DefaultContract');

Line 3380: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3376:
3377: -- Get default Contract.
3378: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3379: THEN
3380: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3381: lc_mod_name,
3382: 'Calling CSD_CHARGE_LINE_UTIL.Get_DefaultContract');
3383: END IF;
3384:

Line 3387: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

3383: END IF;
3384:
3385: l_default_contract_line_id := Csd_Charge_Line_Util.Get_DefaultContract(p_repair_line_id);
3386:
3387: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3388: THEN
3389: -- log results from previous call
3390: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3391: lc_mod_name,

Line 3390: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3386:
3387: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3388: THEN
3389: -- log results from previous call
3390: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3391: lc_mod_name,
3392: 'Returned from CSD_CHARGE_LINE_UTIL.Get_DefaultContract');
3393: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3394: lc_mod_name,

Line 3393: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3389: -- log results from previous call
3390: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3391: lc_mod_name,
3392: 'Returned from CSD_CHARGE_LINE_UTIL.Get_DefaultContract');
3393: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3394: lc_mod_name,
3395: 'l_default_contract_line_id = ' ||
3396: l_default_contract_line_id);
3397: -- log the next call

Line 3398: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3394: lc_mod_name,
3395: 'l_default_contract_line_id = ' ||
3396: l_default_contract_line_id);
3397: -- log the next call
3398: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3399: lc_mod_name,
3400: 'calling CSD_CHARGE_LINE_UTIL.Get_RO_PriceList');
3401: END IF;
3402:

Line 3409: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

3405: THEN
3406: RAISE CSD_EST_DEF_PL;
3407: END IF;
3408:
3409: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3410: THEN
3411: -- log results from previous call
3412: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3413: lc_mod_name,

Line 3412: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3408:
3409: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3410: THEN
3411: -- log results from previous call
3412: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3413: lc_mod_name,
3414: 'Returned from CSD_CHARGE_LINE_UTIL.Get_RO_PriceList');
3415: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3416: lc_mod_name,

Line 3415: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3411: -- log results from previous call
3412: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3413: lc_mod_name,
3414: 'Returned from CSD_CHARGE_LINE_UTIL.Get_RO_PriceList');
3415: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3416: lc_mod_name,
3417: 'l_default_price_list_id = ' ||
3418: l_default_price_list_id);
3419: -- log the next call

Line 3420: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3416: lc_mod_name,
3417: 'l_default_price_list_id = ' ||
3418: l_default_price_list_id);
3419: -- log the next call
3420: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3421: lc_mod_name,
3422: 'Calling CSD_GEN_ERRMSGS_PVT.purge_entity_msgs');
3423: END IF;
3424:

Line 3441: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

3437: p_source_entity_id2 => NULL,
3438: x_return_status => l_return_status,
3439: x_msg_count => l_msg_count,
3440: x_msg_data => l_msg_data);
3441: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3442: THEN
3443: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3444: lc_mod_name,
3445: 'Returned from CSD_GEN_ERRMSGS_PVT.purge_entity_msgs');

Line 3443: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3439: x_msg_count => l_msg_count,
3440: x_msg_data => l_msg_data);
3441: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3442: THEN
3443: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3444: lc_mod_name,
3445: 'Returned from CSD_GEN_ERRMSGS_PVT.purge_entity_msgs');
3446: END IF;
3447: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS)

Line 3455: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

3451:
3452: -- Now, get info for estimate lines into l_est_lines_tbl
3453: IF p_repair_mode = 'TASK'
3454: THEN
3455: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3456: THEN
3457: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3458: lc_mod_name,
3459: 'Calling CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_Task');

Line 3457: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3453: IF p_repair_mode = 'TASK'
3454: THEN
3455: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3456: THEN
3457: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3458: lc_mod_name,
3459: 'Calling CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_Task');
3460: END IF;
3461: Get_Estimates_From_Task(p_api_version => 1.0,

Line 3481: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

3477: p_price_list_id => l_default_price_list_id,
3478: p_contract_line_id => l_default_contract_line_id,
3479: x_est_lines_tbl => l_est_lines_tbl,
3480: x_warning_flag => l_warning_flag);
3481: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3482: THEN
3483: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3484: lc_mod_name,
3485: 'Returned from CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_Task');

Line 3483: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3479: x_est_lines_tbl => l_est_lines_tbl,
3480: x_warning_flag => l_warning_flag);
3481: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3482: THEN
3483: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3484: lc_mod_name,
3485: 'Returned from CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_Task');
3486: END IF;
3487: ELSIF p_repair_mode = 'WIP'

Line 3489: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

3485: 'Returned from CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_Task');
3486: END IF;
3487: ELSIF p_repair_mode = 'WIP'
3488: THEN
3489: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3490: THEN
3491: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3492: lc_mod_name,
3493: 'Calling CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_BOM');

Line 3491: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3487: ELSIF p_repair_mode = 'WIP'
3488: THEN
3489: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3490: THEN
3491: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3492: lc_mod_name,
3493: 'Calling CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_BOM');
3494: END IF;
3495: Get_Estimates_From_BOM(p_api_version => 1.0,

Line 3515: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

3511: p_price_list_id => l_default_price_list_id,
3512: p_contract_line_id => l_default_contract_line_id,
3513: x_est_lines_tbl => l_est_lines_tbl,
3514: x_warning_flag => l_warning_flag);
3515: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3516: THEN
3517: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3518: lc_mod_name,
3519: 'Returned from CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_BOM');

Line 3517: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3513: x_est_lines_tbl => l_est_lines_tbl,
3514: x_warning_flag => l_warning_flag);
3515: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3516: THEN
3517: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3518: lc_mod_name,
3519: 'Returned from CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_BOM');
3520: END IF;
3521: ELSE

Line 3522: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)

3518: lc_mod_name,
3519: 'Returned from CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_BOM');
3520: END IF;
3521: ELSE
3522: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
3523: THEN
3524: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3525: lc_mod_name,
3526: 'Unknown Repair Mode: ' || p_repair_mode);

Line 3524: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3520: END IF;
3521: ELSE
3522: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
3523: THEN
3524: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3525: lc_mod_name,
3526: 'Unknown Repair Mode: ' || p_repair_mode);
3527: END IF;
3528: RAISE CSD_EST_INAPPL_MODE;

Line 3541: IF (Fnd_Log.Level_Procedure >=

3537: -- before attempting to create estimate lines
3538: IF (l_warning_flag = Fnd_Api.G_TRUE)
3539: THEN
3540: x_warning_flag := l_warning_flag;
3541: IF (Fnd_Log.Level_Procedure >=
3542: Fnd_Log.G_Current_Runtime_Level)
3543: THEN
3544: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3545: lc_mod_name,

Line 3542: Fnd_Log.G_Current_Runtime_Level)

3538: IF (l_warning_flag = Fnd_Api.G_TRUE)
3539: THEN
3540: x_warning_flag := l_warning_flag;
3541: IF (Fnd_Log.Level_Procedure >=
3542: Fnd_Log.G_Current_Runtime_Level)
3543: THEN
3544: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3545: lc_mod_name,
3546: 'Calling CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');

Line 3544: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3540: x_warning_flag := l_warning_flag;
3541: IF (Fnd_Log.Level_Procedure >=
3542: Fnd_Log.G_Current_Runtime_Level)
3543: THEN
3544: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3545: lc_mod_name,
3546: 'Calling CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
3547: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3548: lc_mod_name,

Line 3547: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3543: THEN
3544: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3545: lc_mod_name,
3546: 'Calling CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
3547: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3548: lc_mod_name,
3549: 'Number of messages in stack: ' ||
3550: Fnd_Msg_Pub.count_msg);
3551: END IF;

Line 3567: IF (Fnd_Log.Level_Procedure >=

3563: IF NOT (l_return_status = Fnd_Api.G_RET_STS_SUCCESS)
3564: THEN
3565: RAISE Fnd_Api.G_EXC_ERROR;
3566: END IF;
3567: IF (Fnd_Log.Level_Procedure >=
3568: Fnd_Log.G_Current_Runtime_Level)
3569: THEN
3570: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3571: lc_mod_name,

Line 3568: Fnd_Log.G_Current_Runtime_Level)

3564: THEN
3565: RAISE Fnd_Api.G_EXC_ERROR;
3566: END IF;
3567: IF (Fnd_Log.Level_Procedure >=
3568: Fnd_Log.G_Current_Runtime_Level)
3569: THEN
3570: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3571: lc_mod_name,
3572: 'Returned from CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');

Line 3570: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3566: END IF;
3567: IF (Fnd_Log.Level_Procedure >=
3568: Fnd_Log.G_Current_Runtime_Level)
3569: THEN
3570: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3571: lc_mod_name,
3572: 'Returned from CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
3573: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3574: lc_mod_name,

Line 3573: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3569: THEN
3570: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3571: lc_mod_name,
3572: 'Returned from CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
3573: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3574: lc_mod_name,
3575: 'Number of messages in stack: ' ||
3576: Fnd_Msg_Pub.count_msg);
3577: END IF;

Line 3580: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)

3576: Fnd_Msg_Pub.count_msg);
3577: END IF;
3578: END IF;
3579:
3580: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
3581: THEN
3582: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3583: lc_mod_name,
3584: 'Creating repair estimate lines');

Line 3582: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3578: END IF;
3579:
3580: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
3581: THEN
3582: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3583: lc_mod_name,
3584: 'Creating repair estimate lines');
3585: END IF;
3586: FOR i IN 1 .. l_est_lines_tbl.COUNT

Line 3589: IF (Fnd_Log.Level_Statement >=

3585: END IF;
3586: FOR i IN 1 .. l_est_lines_tbl.COUNT
3587: LOOP
3588: BEGIN
3589: IF (Fnd_Log.Level_Statement >=
3590: Fnd_Log.G_Current_Runtime_Level)
3591: THEN
3592: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3593: lc_mod_name,

Line 3590: Fnd_Log.G_Current_Runtime_Level)

3586: FOR i IN 1 .. l_est_lines_tbl.COUNT
3587: LOOP
3588: BEGIN
3589: IF (Fnd_Log.Level_Statement >=
3590: Fnd_Log.G_Current_Runtime_Level)
3591: THEN
3592: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3593: lc_mod_name,
3594: 'Calling create_repair_estimate_lines for line ' || i);

Line 3592: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3588: BEGIN
3589: IF (Fnd_Log.Level_Statement >=
3590: Fnd_Log.G_Current_Runtime_Level)
3591: THEN
3592: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3593: lc_mod_name,
3594: 'Calling create_repair_estimate_lines for line ' || i);
3595: END IF;
3596: create_repair_estimate_lines(p_api_version => 1.0,

Line 3612: IF (Fnd_Log.Level_Statement >=

3608: WHEN OTHERS THEN
3609: l_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3610: END;
3611:
3612: IF (Fnd_Log.Level_Statement >=
3613: Fnd_Log.G_Current_Runtime_Level)
3614: THEN
3615: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3616: lc_mod_name,

Line 3613: Fnd_Log.G_Current_Runtime_Level)

3609: l_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3610: END;
3611:
3612: IF (Fnd_Log.Level_Statement >=
3613: Fnd_Log.G_Current_Runtime_Level)
3614: THEN
3615: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3616: lc_mod_name,
3617: 'x_estimate_line_rec = ' ||

Line 3615: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3611:
3612: IF (Fnd_Log.Level_Statement >=
3613: Fnd_Log.G_Current_Runtime_Level)
3614: THEN
3615: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3616: lc_mod_name,
3617: 'x_estimate_line_rec = ' ||
3618: TO_CHAR(l_est_lines_tbl(i)
3619: .repair_estimate_line_id));

Line 3620: -- FND_LOG.STRING(Fnd_Log.Level_Procedure, lc_mod_name,

3616: lc_mod_name,
3617: 'x_estimate_line_rec = ' ||
3618: TO_CHAR(l_est_lines_tbl(i)
3619: .repair_estimate_line_id));
3620: -- FND_LOG.STRING(Fnd_Log.Level_Procedure, lc_mod_name,
3621: -- 'x_return_status = '||l_return_status);
3622: END IF;
3623:
3624: -- If SC have been applied to create estimate lines successfully,

Line 3636: IF (Fnd_Log.Level_Statement >=

3632: NVL(l_est_lines_tbl(i).RO_SERVICE_CODE_ID, -999)) AND
3633: (l_est_lines_tbl(i).RO_SERVICE_CODE_ID IS NOT NULL)
3634: THEN
3635:
3636: IF (Fnd_Log.Level_Statement >=
3637: Fnd_Log.G_Current_Runtime_Level)
3638: THEN
3639: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3640: lc_mod_name,

Line 3637: Fnd_Log.G_Current_Runtime_Level)

3633: (l_est_lines_tbl(i).RO_SERVICE_CODE_ID IS NOT NULL)
3634: THEN
3635:
3636: IF (Fnd_Log.Level_Statement >=
3637: Fnd_Log.G_Current_Runtime_Level)
3638: THEN
3639: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3640: lc_mod_name,
3641: 'l_prev_ro_sc_id = ' ||

Line 3639: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3635:
3636: IF (Fnd_Log.Level_Statement >=
3637: Fnd_Log.G_Current_Runtime_Level)
3638: THEN
3639: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3640: lc_mod_name,
3641: 'l_prev_ro_sc_id = ' ||
3642: TO_CHAR(l_prev_ro_sc_id));
3643: Fnd_Log.STRING(Fnd_Log.Level_Statement,

Line 3643: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3639: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3640: lc_mod_name,
3641: 'l_prev_ro_sc_id = ' ||
3642: TO_CHAR(l_prev_ro_sc_id));
3643: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3644: lc_mod_name,
3645: 'l_est_lines_tbl(i).RO_SERVICE_CODE_ID = ' ||
3646: TO_CHAR(l_est_lines_tbl(i)
3647: .RO_SERVICE_CODE_ID));

Line 3659: IF (Fnd_Log.Level_Procedure >=

3655: FETCH c_ro_sc_obj_version
3656: INTO l_ro_sc_rec_type.object_version_number;
3657: CLOSE c_ro_sc_obj_version;
3658:
3659: IF (Fnd_Log.Level_Procedure >=
3660: Fnd_Log.G_Current_Runtime_Level)
3661: THEN
3662: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3663: lc_mod_name,

Line 3660: Fnd_Log.G_Current_Runtime_Level)

3656: INTO l_ro_sc_rec_type.object_version_number;
3657: CLOSE c_ro_sc_obj_version;
3658:
3659: IF (Fnd_Log.Level_Procedure >=
3660: Fnd_Log.G_Current_Runtime_Level)
3661: THEN
3662: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3663: lc_mod_name,
3664: 'Calling CSD_RO_SERVICE_CODES_PVT.Update_RO_Service_Code');

Line 3662: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3658:
3659: IF (Fnd_Log.Level_Procedure >=
3660: Fnd_Log.G_Current_Runtime_Level)
3661: THEN
3662: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3663: lc_mod_name,
3664: 'Calling CSD_RO_SERVICE_CODES_PVT.Update_RO_Service_Code');
3665: END IF;
3666: Csd_Ro_Service_Codes_Pvt.Update_RO_Service_Code(p_api_version => 1.0,

Line 3683: IF (Fnd_Log.Level_Statement >=

3679: .RO_SERVICE_CODE_ID;
3680: ELSE
3681: -- not able to update csd_ro_service_codes table to set as applied to est
3682: x_warning_flag := Fnd_Api.G_TRUE;
3683: IF (Fnd_Log.Level_Statement >=
3684: Fnd_Log.G_Current_Runtime_Level)
3685: THEN
3686: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3687: lc_mod_name,

Line 3684: Fnd_Log.G_Current_Runtime_Level)

3680: ELSE
3681: -- not able to update csd_ro_service_codes table to set as applied to est
3682: x_warning_flag := Fnd_Api.G_TRUE;
3683: IF (Fnd_Log.Level_Statement >=
3684: Fnd_Log.G_Current_Runtime_Level)
3685: THEN
3686: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3687: lc_mod_name,
3688: 'Adding message CSD_EST_SC_APPLIED_ERR to FND_MSG stack');

Line 3686: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3682: x_warning_flag := Fnd_Api.G_TRUE;
3683: IF (Fnd_Log.Level_Statement >=
3684: Fnd_Log.G_Current_Runtime_Level)
3685: THEN
3686: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3687: lc_mod_name,
3688: 'Adding message CSD_EST_SC_APPLIED_ERR to FND_MSG stack');
3689: END IF;
3690: Fnd_Message.SET_NAME('CSD',

Line 3693: IF (Fnd_Log.Level_Procedure >=

3689: END IF;
3690: Fnd_Message.SET_NAME('CSD',
3691: 'CSD_EST_SC_APPLIED_ERR');
3692: Fnd_Msg_Pub.ADD;
3693: IF (Fnd_Log.Level_Procedure >=
3694: Fnd_Log.G_Current_Runtime_Level)
3695: THEN
3696: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3697: lc_mod_name,

Line 3694: Fnd_Log.G_Current_Runtime_Level)

3690: Fnd_Message.SET_NAME('CSD',
3691: 'CSD_EST_SC_APPLIED_ERR');
3692: Fnd_Msg_Pub.ADD;
3693: IF (Fnd_Log.Level_Procedure >=
3694: Fnd_Log.G_Current_Runtime_Level)
3695: THEN
3696: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3697: lc_mod_name,
3698: 'Calling CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');

Line 3696: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3692: Fnd_Msg_Pub.ADD;
3693: IF (Fnd_Log.Level_Procedure >=
3694: Fnd_Log.G_Current_Runtime_Level)
3695: THEN
3696: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3697: lc_mod_name,
3698: 'Calling CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
3699: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3700: lc_mod_name,

Line 3699: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3695: THEN
3696: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3697: lc_mod_name,
3698: 'Calling CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
3699: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3700: lc_mod_name,
3701: 'Number of messages in stack: ' ||
3702: Fnd_Msg_Pub.count_msg);
3703: END IF;

Line 3722: IF (Fnd_Log.Level_Procedure >=

3718: (l_return_status = Fnd_Api.G_RET_STS_SUCCESS)
3719: THEN
3720: RAISE Fnd_Api.G_EXC_ERROR;
3721: END IF;
3722: IF (Fnd_Log.Level_Procedure >=
3723: Fnd_Log.G_Current_Runtime_Level)
3724: THEN
3725: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3726: lc_mod_name,

Line 3723: Fnd_Log.G_Current_Runtime_Level)

3719: THEN
3720: RAISE Fnd_Api.G_EXC_ERROR;
3721: END IF;
3722: IF (Fnd_Log.Level_Procedure >=
3723: Fnd_Log.G_Current_Runtime_Level)
3724: THEN
3725: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3726: lc_mod_name,
3727: 'Returned from CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');

Line 3725: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3721: END IF;
3722: IF (Fnd_Log.Level_Procedure >=
3723: Fnd_Log.G_Current_Runtime_Level)
3724: THEN
3725: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3726: lc_mod_name,
3727: 'Returned from CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
3728: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3729: lc_mod_name,

Line 3728: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3724: THEN
3725: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3726: lc_mod_name,
3727: 'Returned from CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
3728: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3729: lc_mod_name,
3730: 'Number of messages in stack: ' ||
3731: Fnd_Msg_Pub.count_msg);
3732: END IF;

Line 3738: IF (Fnd_Log.Level_Procedure >=

3734: END IF;
3735: ELSE
3736: -- not able to create repair estimate line from record in table
3737: -- log a warning and save the error messages.
3738: IF (Fnd_Log.Level_Procedure >=
3739: Fnd_Log.G_Current_Runtime_Level)
3740: THEN
3741: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3742: lc_mod_name,

Line 3739: Fnd_Log.G_Current_Runtime_Level)

3735: ELSE
3736: -- not able to create repair estimate line from record in table
3737: -- log a warning and save the error messages.
3738: IF (Fnd_Log.Level_Procedure >=
3739: Fnd_Log.G_Current_Runtime_Level)
3740: THEN
3741: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3742: lc_mod_name,
3743: 'Unable to create repair estimate line for index ' || i);

Line 3741: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3737: -- log a warning and save the error messages.
3738: IF (Fnd_Log.Level_Procedure >=
3739: Fnd_Log.G_Current_Runtime_Level)
3740: THEN
3741: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3742: lc_mod_name,
3743: 'Unable to create repair estimate line for index ' || i);
3744: END IF;
3745:

Line 3764: IF (Fnd_Log.Level_Statement >=

3760: l_item_name := TO_CHAR(l_est_lines_tbl(i)
3761: .inventory_item_id);
3762: END;
3763:
3764: IF (Fnd_Log.Level_Statement >=
3765: Fnd_Log.G_Current_Runtime_Level)
3766: THEN
3767: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3768: lc_mod_name,

Line 3765: Fnd_Log.G_Current_Runtime_Level)

3761: .inventory_item_id);
3762: END;
3763:
3764: IF (Fnd_Log.Level_Statement >=
3765: Fnd_Log.G_Current_Runtime_Level)
3766: THEN
3767: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3768: lc_mod_name,
3769: 'Adding message CSD_EST_LINE_CREATED_ERR to FND_MSG stack');

Line 3767: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3763:
3764: IF (Fnd_Log.Level_Statement >=
3765: Fnd_Log.G_Current_Runtime_Level)
3766: THEN
3767: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3768: lc_mod_name,
3769: 'Adding message CSD_EST_LINE_CREATED_ERR to FND_MSG stack');
3770: END IF;
3771: Fnd_Message.SET_NAME('CSD', 'CSD_EST_LINE_CREATED_ERR');

Line 3774: IF (Fnd_Log.Level_Procedure >=

3770: END IF;
3771: Fnd_Message.SET_NAME('CSD', 'CSD_EST_LINE_CREATED_ERR');
3772: Fnd_Message.SET_TOKEN('ITEM', l_item_name);
3773: Fnd_Msg_Pub.ADD;
3774: IF (Fnd_Log.Level_Procedure >=
3775: Fnd_Log.G_Current_Runtime_Level)
3776: THEN
3777: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3778: lc_mod_name,

Line 3775: Fnd_Log.G_Current_Runtime_Level)

3771: Fnd_Message.SET_NAME('CSD', 'CSD_EST_LINE_CREATED_ERR');
3772: Fnd_Message.SET_TOKEN('ITEM', l_item_name);
3773: Fnd_Msg_Pub.ADD;
3774: IF (Fnd_Log.Level_Procedure >=
3775: Fnd_Log.G_Current_Runtime_Level)
3776: THEN
3777: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3778: lc_mod_name,
3779: 'Calling CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');

Line 3777: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3773: Fnd_Msg_Pub.ADD;
3774: IF (Fnd_Log.Level_Procedure >=
3775: Fnd_Log.G_Current_Runtime_Level)
3776: THEN
3777: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3778: lc_mod_name,
3779: 'Calling CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
3780: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3781: lc_mod_name,

Line 3780: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3776: THEN
3777: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3778: lc_mod_name,
3779: 'Calling CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
3780: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3781: lc_mod_name,
3782: 'Number of messages in stack: ' ||
3783: Fnd_Msg_Pub.count_msg);
3784: END IF;

Line 3802: IF (Fnd_Log.Level_Procedure >=

3798: IF NOT (l_return_status = Fnd_Api.G_RET_STS_SUCCESS)
3799: THEN
3800: RAISE Fnd_Api.G_EXC_ERROR;
3801: END IF;
3802: IF (Fnd_Log.Level_Procedure >=
3803: Fnd_Log.G_Current_Runtime_Level)
3804: THEN
3805: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3806: lc_mod_name,

Line 3803: Fnd_Log.G_Current_Runtime_Level)

3799: THEN
3800: RAISE Fnd_Api.G_EXC_ERROR;
3801: END IF;
3802: IF (Fnd_Log.Level_Procedure >=
3803: Fnd_Log.G_Current_Runtime_Level)
3804: THEN
3805: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3806: lc_mod_name,
3807: 'Returned from CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');

Line 3805: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3801: END IF;
3802: IF (Fnd_Log.Level_Procedure >=
3803: Fnd_Log.G_Current_Runtime_Level)
3804: THEN
3805: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3806: lc_mod_name,
3807: 'Returned from CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
3808: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3809: lc_mod_name,

Line 3808: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3804: THEN
3805: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3806: lc_mod_name,
3807: 'Returned from CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
3808: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3809: lc_mod_name,
3810: 'Number of messages in stack: ' ||
3811: Fnd_Msg_Pub.count_msg);
3812: END IF;

Line 3831: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)

3827: -- Standard call to get message count and IF count is get message info.
3828: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3829: p_data => x_msg_data);
3830:
3831: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
3832: THEN
3833: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3834: lc_mod_name || '.out_parameter',
3835: 'x_warning_flag: ' || x_warning_flag);

Line 3833: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3829: p_data => x_msg_data);
3830:
3831: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
3832: THEN
3833: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3834: lc_mod_name || '.out_parameter',
3835: 'x_warning_flag: ' || x_warning_flag);
3836: END IF;
3837:

Line 3838: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

3834: lc_mod_name || '.out_parameter',
3835: 'x_warning_flag: ' || x_warning_flag);
3836: END IF;
3837:
3838: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3839: THEN
3840: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3841: lc_mod_name || '.END',
3842: 'Leaving Autocreate_Estimate_Lines');

Line 3840: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3836: END IF;
3837:
3838: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3839: THEN
3840: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3841: lc_mod_name || '.END',
3842: 'Leaving Autocreate_Estimate_Lines');
3843: END IF;
3844:

Line 3853: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)

3849: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3850: x_warning_flag := Fnd_Api.G_FALSE;
3851:
3852: -- save message in fnd stack
3853: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
3854: THEN
3855: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3856: lc_mod_name,
3857: 'Adding message CSD_EST_SC_NO_APPL to FND_MSG stack');

Line 3855: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3851:
3852: -- save message in fnd stack
3853: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
3854: THEN
3855: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3856: lc_mod_name,
3857: 'Adding message CSD_EST_SC_NO_APPL to FND_MSG stack');
3858: END IF;
3859: Fnd_Message.SET_NAME('CSD', 'CSD_EST_SC_NO_APPL');

Line 3865: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)

3861: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3862: p_data => x_msg_data);
3863:
3864: -- save message in debug log
3865: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
3866: THEN
3867: Fnd_Log.STRING(Fnd_Log.Level_Exception,
3868: lc_mod_name,
3869: 'No service codes found to apply');

Line 3867: Fnd_Log.STRING(Fnd_Log.Level_Exception,

3863:
3864: -- save message in debug log
3865: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
3866: THEN
3867: Fnd_Log.STRING(Fnd_Log.Level_Exception,
3868: lc_mod_name,
3869: 'No service codes found to apply');
3870: END IF;
3871: WHEN CSD_EST_DEF_PL THEN

Line 3878: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)

3874: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3875: x_warning_flag := Fnd_Api.G_FALSE;
3876:
3877: -- save message in fnd stack
3878: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
3879: THEN
3880: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3881: lc_mod_name,
3882: 'Adding message CSD_EST_NO_DEF_PL to FND_MSG stack');

Line 3880: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3876:
3877: -- save message in fnd stack
3878: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
3879: THEN
3880: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3881: lc_mod_name,
3882: 'Adding message CSD_EST_NO_DEF_PL to FND_MSG stack');
3883: END IF;
3884: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NO_DEF_PL');

Line 3890: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)

3886: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3887: p_data => x_msg_data);
3888:
3889: -- save message in debug log
3890: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
3891: THEN
3892: Fnd_Log.STRING(Fnd_Log.Level_Exception,
3893: lc_mod_name,
3894: 'Unable to determine default pricelist');

Line 3892: Fnd_Log.STRING(Fnd_Log.Level_Exception,

3888:
3889: -- save message in debug log
3890: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
3891: THEN
3892: Fnd_Log.STRING(Fnd_Log.Level_Exception,
3893: lc_mod_name,
3894: 'Unable to determine default pricelist');
3895: END IF;
3896:

Line 3904: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)

3900: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3901: x_warning_flag := Fnd_Api.G_FALSE;
3902:
3903: -- save message in fnd stack
3904: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
3905: THEN
3906: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3907: lc_mod_name,
3908: 'Adding message CSD_EST_INAPPL_MODE to FND_MSG stack');

Line 3906: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3902:
3903: -- save message in fnd stack
3904: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
3905: THEN
3906: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3907: lc_mod_name,
3908: 'Adding message CSD_EST_INAPPL_MODE to FND_MSG stack');
3909: END IF;
3910: DECLARE

Line 3929: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)

3925: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3926: p_data => x_msg_data);
3927:
3928: -- save message in debug log
3929: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
3930: THEN
3931: Fnd_Log.STRING(Fnd_Log.Level_Exception,
3932: lc_mod_name,
3933: 'Cannot apply service code for repair mode');

Line 3931: Fnd_Log.STRING(Fnd_Log.Level_Exception,

3927:
3928: -- save message in debug log
3929: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
3930: THEN
3931: Fnd_Log.STRING(Fnd_Log.Level_Exception,
3932: lc_mod_name,
3933: 'Cannot apply service code for repair mode');
3934: END IF;
3935: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 3942: if (Fnd_Log.Level_Statement>= Fnd_Log.G_Current_Runtime_Level) then

3938:
3939: /*
3940: -- TO DO: Add seeded err message
3941: -- save message in fnd stack
3942: if (Fnd_Log.Level_Statement>= Fnd_Log.G_Current_Runtime_Level) then
3943: FND_LOG.STRING(Fnd_Log.Level_Statement, lc_mod_name,
3944: 'Adding message err_name to FND_MSG stack');
3945: end if;
3946: FND_MESSAGE.SET_NAME('CSD','err_name');

Line 3943: FND_LOG.STRING(Fnd_Log.Level_Statement, lc_mod_name,

3939: /*
3940: -- TO DO: Add seeded err message
3941: -- save message in fnd stack
3942: if (Fnd_Log.Level_Statement>= Fnd_Log.G_Current_Runtime_Level) then
3943: FND_LOG.STRING(Fnd_Log.Level_Statement, lc_mod_name,
3944: 'Adding message err_name to FND_MSG stack');
3945: end if;
3946: FND_MESSAGE.SET_NAME('CSD','err_name');
3947: FND_MESSAGE.SET_TOKEN('toke_name', 'token_value');

Line 3954: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)

3950: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3951: p_data => x_msg_data);
3952:
3953: -- save message in debug log
3954: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
3955: THEN
3956: Fnd_Log.STRING(Fnd_Log.Level_Exception,
3957: lc_mod_name,
3958: 'EXC_ERROR[' || x_msg_data || ']');

Line 3956: Fnd_Log.STRING(Fnd_Log.Level_Exception,

3952:
3953: -- save message in debug log
3954: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
3955: THEN
3956: Fnd_Log.STRING(Fnd_Log.Level_Exception,
3957: lc_mod_name,
3958: 'EXC_ERROR[' || x_msg_data || ']');
3959: END IF;
3960: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 3967: IF (Fnd_Log.Level_Statement >=

3963:
3964: -- save message in fnd stack
3965: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
3966: THEN
3967: IF (Fnd_Log.Level_Statement >=
3968: Fnd_Log.G_Current_Runtime_Level)
3969: THEN
3970: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3971: lc_mod_name,

Line 3968: Fnd_Log.G_Current_Runtime_Level)

3964: -- save message in fnd stack
3965: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
3966: THEN
3967: IF (Fnd_Log.Level_Statement >=
3968: Fnd_Log.G_Current_Runtime_Level)
3969: THEN
3970: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3971: lc_mod_name,
3972: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 3970: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3966: THEN
3967: IF (Fnd_Log.Level_Statement >=
3968: Fnd_Log.G_Current_Runtime_Level)
3969: THEN
3970: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3971: lc_mod_name,
3972: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
3973: END IF;
3974: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);

Line 3980: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)

3976: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3977: p_data => x_msg_data);
3978:
3979: -- save message in debug log
3980: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
3981: THEN
3982: Fnd_Log.STRING(Fnd_Log.Level_Exception,
3983: lc_mod_name,
3984: 'EXC_UNEXPECTED_ERROR[' || x_msg_data || ']');

Line 3982: Fnd_Log.STRING(Fnd_Log.Level_Exception,

3978:
3979: -- save message in debug log
3980: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
3981: THEN
3982: Fnd_Log.STRING(Fnd_Log.Level_Exception,
3983: lc_mod_name,
3984: 'EXC_UNEXPECTED_ERROR[' || x_msg_data || ']');
3985: END IF;
3986: WHEN OTHERS THEN

Line 3993: IF (Fnd_Log.Level_Statement >=

3989:
3990: -- save message in fnd stack
3991: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
3992: THEN
3993: IF (Fnd_Log.Level_Statement >=
3994: Fnd_Log.G_Current_Runtime_Level)
3995: THEN
3996: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3997: lc_mod_name,

Line 3994: Fnd_Log.G_Current_Runtime_Level)

3990: -- save message in fnd stack
3991: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
3992: THEN
3993: IF (Fnd_Log.Level_Statement >=
3994: Fnd_Log.G_Current_Runtime_Level)
3995: THEN
3996: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3997: lc_mod_name,
3998: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 3996: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3992: THEN
3993: IF (Fnd_Log.Level_Statement >=
3994: Fnd_Log.G_Current_Runtime_Level)
3995: THEN
3996: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3997: lc_mod_name,
3998: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
3999: END IF;
4000: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);

Line 4006: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)

4002: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
4003: p_data => x_msg_data);
4004:
4005: -- save message in debug log
4006: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
4007: THEN
4008: -- create a seeded message
4009: Fnd_Log.STRING(Fnd_Log.Level_Exception,
4010: lc_mod_name,

Line 4009: Fnd_Log.STRING(Fnd_Log.Level_Exception,

4005: -- save message in debug log
4006: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
4007: THEN
4008: -- create a seeded message
4009: Fnd_Log.STRING(Fnd_Log.Level_Exception,
4010: lc_mod_name,
4011: 'SQL Message[' || SQLERRM || ']');
4012: END IF;
4013:

Line 4051: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;

4047: p_contract_line_id IN NUMBER,
4048: x_est_lines_tbl OUT NOCOPY CSD_REPAIR_ESTIMATE_PVT.REPAIR_ESTIMATE_LINE_TBL,
4049: x_warning_flag OUT NOCOPY VARCHAR2) IS
4050: -- CONSTANTS --
4051: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
4052: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
4053: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
4054: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
4055: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;

Line 4052: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;

4048: x_est_lines_tbl OUT NOCOPY CSD_REPAIR_ESTIMATE_PVT.REPAIR_ESTIMATE_LINE_TBL,
4049: x_warning_flag OUT NOCOPY VARCHAR2) IS
4050: -- CONSTANTS --
4051: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
4052: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
4053: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
4054: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
4055: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
4056: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;

Line 4053: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;

4049: x_warning_flag OUT NOCOPY VARCHAR2) IS
4050: -- CONSTANTS --
4051: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
4052: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
4053: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
4054: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
4055: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
4056: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
4057: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;

Line 4054: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;

4050: -- CONSTANTS --
4051: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
4052: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
4053: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
4054: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
4055: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
4056: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
4057: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
4058: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.get_estimates_from_task';

Line 4055: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;

4051: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
4052: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
4053: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
4054: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
4055: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
4056: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
4057: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
4058: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.get_estimates_from_task';
4059: lc_api_name CONSTANT VARCHAR2(30) := 'Get_Estimates_From_Task';

Line 4056: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;

4052: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
4053: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
4054: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
4055: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
4056: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
4057: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
4058: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.get_estimates_from_task';
4059: lc_api_name CONSTANT VARCHAR2(30) := 'Get_Estimates_From_Task';
4060: lc_api_version CONSTANT NUMBER := 1.0;

Line 4057: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;

4053: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
4054: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
4055: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
4056: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
4057: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
4058: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.get_estimates_from_task';
4059: lc_api_name CONSTANT VARCHAR2(30) := 'Get_Estimates_From_Task';
4060: lc_api_version CONSTANT NUMBER := 1.0;
4061:

Line 4638: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

4634:
4635: --
4636: -- Begin API Body
4637: --
4638: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
4639: THEN
4640: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4641: lc_mod_name || '.BEGIN',
4642: 'Entering CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_Task');

Line 4640: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

4636: -- Begin API Body
4637: --
4638: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
4639: THEN
4640: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4641: lc_mod_name || '.BEGIN',
4642: 'Entering CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_Task');
4643: END IF;
4644: -- log parameters

Line 4645: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)

4641: lc_mod_name || '.BEGIN',
4642: 'Entering CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_Task');
4643: END IF;
4644: -- log parameters
4645: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
4646: THEN
4647: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4648: lc_mod_name || '.parameter_logging',
4649: 'p_api_version: ' || p_api_version);

Line 4647: Fnd_Log.STRING(Fnd_Log.Level_Statement,

4643: END IF;
4644: -- log parameters
4645: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
4646: THEN
4647: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4648: lc_mod_name || '.parameter_logging',
4649: 'p_api_version: ' || p_api_version);
4650: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4651: lc_mod_name || '.parameter_logging',

Line 4650: Fnd_Log.STRING(Fnd_Log.Level_Statement,

4646: THEN
4647: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4648: lc_mod_name || '.parameter_logging',
4649: 'p_api_version: ' || p_api_version);
4650: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4651: lc_mod_name || '.parameter_logging',
4652: 'p_commit: ' || p_commit);
4653: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4654: lc_mod_name || '.parameter_logging',

Line 4653: Fnd_Log.STRING(Fnd_Log.Level_Statement,

4649: 'p_api_version: ' || p_api_version);
4650: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4651: lc_mod_name || '.parameter_logging',
4652: 'p_commit: ' || p_commit);
4653: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4654: lc_mod_name || '.parameter_logging',
4655: 'p_init_msg_list: ' || p_init_msg_list);
4656: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4657: lc_mod_name || '.parameter_logging',

Line 4656: Fnd_Log.STRING(Fnd_Log.Level_Statement,

4652: 'p_commit: ' || p_commit);
4653: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4654: lc_mod_name || '.parameter_logging',
4655: 'p_init_msg_list: ' || p_init_msg_list);
4656: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4657: lc_mod_name || '.parameter_logging',
4658: 'p_validation_level: ' || p_validation_level);
4659: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4660: lc_mod_name || '.parameter_logging',

Line 4659: Fnd_Log.STRING(Fnd_Log.Level_Statement,

4655: 'p_init_msg_list: ' || p_init_msg_list);
4656: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4657: lc_mod_name || '.parameter_logging',
4658: 'p_validation_level: ' || p_validation_level);
4659: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4660: lc_mod_name || '.parameter_logging',
4661: 'p_repair_line_id: ' || p_repair_line_id);
4662: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4663: lc_mod_name || '.parameter_logging',

Line 4662: Fnd_Log.STRING(Fnd_Log.Level_Statement,

4658: 'p_validation_level: ' || p_validation_level);
4659: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4660: lc_mod_name || '.parameter_logging',
4661: 'p_repair_line_id: ' || p_repair_line_id);
4662: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4663: lc_mod_name || '.parameter_logging',
4664: 'p_estimate_id: ' || p_estimate_id);
4665: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4666: lc_mod_name || '.parameter_logging',

Line 4665: Fnd_Log.STRING(Fnd_Log.Level_Statement,

4661: 'p_repair_line_id: ' || p_repair_line_id);
4662: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4663: lc_mod_name || '.parameter_logging',
4664: 'p_estimate_id: ' || p_estimate_id);
4665: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4666: lc_mod_name || '.parameter_logging',
4667: 'p_repair_type_id: ' || p_repair_type_id);
4668: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4669: lc_mod_name || '.parameter_logging',

Line 4668: Fnd_Log.STRING(Fnd_Log.Level_Statement,

4664: 'p_estimate_id: ' || p_estimate_id);
4665: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4666: lc_mod_name || '.parameter_logging',
4667: 'p_repair_type_id: ' || p_repair_type_id);
4668: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4669: lc_mod_name || '.parameter_logging',
4670: 'p_business_process_id: ' ||
4671: p_business_process_id);
4672: Fnd_Log.STRING(Fnd_Log.Level_Statement,

Line 4672: Fnd_Log.STRING(Fnd_Log.Level_Statement,

4668: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4669: lc_mod_name || '.parameter_logging',
4670: 'p_business_process_id: ' ||
4671: p_business_process_id);
4672: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4673: lc_mod_name || '.parameter_logging',
4674: 'p_currency_code: ' || p_currency_code);
4675: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4676: lc_mod_name || '.parameter_logging',

Line 4675: Fnd_Log.STRING(Fnd_Log.Level_Statement,

4671: p_business_process_id);
4672: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4673: lc_mod_name || '.parameter_logging',
4674: 'p_currency_code: ' || p_currency_code);
4675: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4676: lc_mod_name || '.parameter_logging',
4677: 'p_incident_id: ' || p_incident_id);
4678: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4679: lc_mod_name || '.parameter_logging',

Line 4678: Fnd_Log.STRING(Fnd_Log.Level_Statement,

4674: 'p_currency_code: ' || p_currency_code);
4675: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4676: lc_mod_name || '.parameter_logging',
4677: 'p_incident_id: ' || p_incident_id);
4678: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4679: lc_mod_name || '.parameter_logging',
4680: 'p_repair_mode: ' || p_repair_mode);
4681: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4682: lc_mod_name || '.parameter_logging',

Line 4681: Fnd_Log.STRING(Fnd_Log.Level_Statement,

4677: 'p_incident_id: ' || p_incident_id);
4678: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4679: lc_mod_name || '.parameter_logging',
4680: 'p_repair_mode: ' || p_repair_mode);
4681: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4682: lc_mod_name || '.parameter_logging',
4683: 'p_inventory_item_id: ' || p_inventory_item_id);
4684: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4685: lc_mod_name || '.parameter_logging',

Line 4684: Fnd_Log.STRING(Fnd_Log.Level_Statement,

4680: 'p_repair_mode: ' || p_repair_mode);
4681: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4682: lc_mod_name || '.parameter_logging',
4683: 'p_inventory_item_id: ' || p_inventory_item_id);
4684: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4685: lc_mod_name || '.parameter_logging',
4686: 'p_organization_id: ' || p_organization_id);
4687: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4688: lc_mod_name || '.parameter_logging',

Line 4687: Fnd_Log.STRING(Fnd_Log.Level_Statement,

4683: 'p_inventory_item_id: ' || p_inventory_item_id);
4684: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4685: lc_mod_name || '.parameter_logging',
4686: 'p_organization_id: ' || p_organization_id);
4687: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4688: lc_mod_name || '.parameter_logging',
4689: 'p_price_list_id: ' || p_price_list_id);
4690: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4691: lc_mod_name || '.parameter_logging',

Line 4690: Fnd_Log.STRING(Fnd_Log.Level_Statement,

4686: 'p_organization_id: ' || p_organization_id);
4687: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4688: lc_mod_name || '.parameter_logging',
4689: 'p_price_list_id: ' || p_price_list_id);
4690: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4691: lc_mod_name || '.parameter_logging',
4692: 'p_contract_line_id: ' || p_contract_line_id);
4693: END IF;
4694:

Line 4706: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)

4702: -- get threshold for tasks - to be used when determining manual vs rollup qty
4703: l_task_threshold := TO_NUMBER(NVL(Fnd_Profile.value('CSP_PROD_TASK_HIST_RULE'),
4704: '0'));
4705:
4706: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
4707: THEN
4708: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4709: lc_mod_name,
4710: 'l_labor_inventory_item_id = ' ||

Line 4708: Fnd_Log.STRING(Fnd_Log.Level_Statement,

4704: '0'));
4705:
4706: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
4707: THEN
4708: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4709: lc_mod_name,
4710: 'l_labor_inventory_item_id = ' ||
4711: l_labor_inventory_item_id);
4712: Fnd_Log.STRING(Fnd_Log.Level_Statement,

Line 4712: Fnd_Log.STRING(Fnd_Log.Level_Statement,

4708: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4709: lc_mod_name,
4710: 'l_labor_inventory_item_id = ' ||
4711: l_labor_inventory_item_id);
4712: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4713: lc_mod_name,
4714: 'l_use_tasks_from_sol = ' ||
4715: l_use_tasks_from_sol);
4716: Fnd_Log.STRING(Fnd_Log.Level_Statement,

Line 4716: Fnd_Log.STRING(Fnd_Log.Level_Statement,

4712: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4713: lc_mod_name,
4714: 'l_use_tasks_from_sol = ' ||
4715: l_use_tasks_from_sol);
4716: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4717: lc_mod_name,
4718: 'l_task_threshold = ' || l_task_threshold);
4719: END IF;
4720:

Line 4727: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

4723: --
4724: DECLARE
4725: l_count NUMBER := 0;
4726: BEGIN
4727: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
4728: THEN
4729: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4730: lc_mod_name,
4731: 'Getting task material lines from service codes');

Line 4729: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

4725: l_count NUMBER := 0;
4726: BEGIN
4727: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
4728: THEN
4729: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4730: lc_mod_name,
4731: 'Getting task material lines from service codes');
4732: END IF;
4733: -- bugfix 3468680, vkjain

Line 4763: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

4759: END IF;
4760: END LOOP;
4761: END;
4762:
4763: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
4764: THEN
4765: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4766: lc_mod_name,
4767: 'material line count = ' ||

Line 4765: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

4761: END;
4762:
4763: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
4764: THEN
4765: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4766: lc_mod_name,
4767: 'material line count = ' ||
4768: l_materials_from_sc_tbl.COUNT);
4769: END IF;

Line 4812: IF (Fnd_Log.Level_Procedure >=

4808: THEN
4809: DECLARE
4810: l_count NUMBER := 0;
4811: BEGIN
4812: IF (Fnd_Log.Level_Procedure >=
4813: Fnd_Log.G_Current_Runtime_Level)
4814: THEN
4815: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4816: lc_mod_name,

Line 4813: Fnd_Log.G_Current_Runtime_Level)

4809: DECLARE
4810: l_count NUMBER := 0;
4811: BEGIN
4812: IF (Fnd_Log.Level_Procedure >=
4813: Fnd_Log.G_Current_Runtime_Level)
4814: THEN
4815: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4816: lc_mod_name,
4817: 'Getting task labor lines from service codes');

Line 4815: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

4811: BEGIN
4812: IF (Fnd_Log.Level_Procedure >=
4813: Fnd_Log.G_Current_Runtime_Level)
4814: THEN
4815: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4816: lc_mod_name,
4817: 'Getting task labor lines from service codes');
4818: END IF;
4819: -- bugfix 3468680, vkjain

Line 4840: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

4836: l_labor_from_sc_tbl(l_count).ro_service_code_id := r1.ro_service_code_id;
4837: END LOOP;
4838: END;
4839:
4840: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
4841: THEN
4842: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4843: lc_mod_name,
4844: 'labor line count = ' ||

Line 4842: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

4838: END;
4839:
4840: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
4841: THEN
4842: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4843: lc_mod_name,
4844: 'labor line count = ' ||
4845: l_labor_from_sc_tbl.COUNT);
4846: END IF;

Line 4897: IF (Fnd_Log.Level_Procedure >=

4893: l_return_status VARCHAR2(1);
4894: l_msg_count NUMBER;
4895: l_msg_data VARCHAR2(2000);
4896: BEGIN
4897: IF (Fnd_Log.Level_Procedure >=
4898: Fnd_Log.G_Current_Runtime_Level)
4899: THEN
4900: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4901: lc_mod_name,

Line 4898: Fnd_Log.G_Current_Runtime_Level)

4894: l_msg_count NUMBER;
4895: l_msg_data VARCHAR2(2000);
4896: BEGIN
4897: IF (Fnd_Log.Level_Procedure >=
4898: Fnd_Log.G_Current_Runtime_Level)
4899: THEN
4900: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4901: lc_mod_name,
4902: 'Getting all solution tasks with no product template');

Line 4900: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

4896: BEGIN
4897: IF (Fnd_Log.Level_Procedure >=
4898: Fnd_Log.G_Current_Runtime_Level)
4899: THEN
4900: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4901: lc_mod_name,
4902: 'Getting all solution tasks with no product template');
4903: END IF;
4904: FOR r1 IN c_sol_tasks_no_prod(p_repair_line_id)

Line 4907: IF (Fnd_Log.Level_Statement >=

4903: END IF;
4904: FOR r1 IN c_sol_tasks_no_prod(p_repair_line_id)
4905: LOOP
4906: x_warning_flag := Fnd_Api.G_TRUE;
4907: IF (Fnd_Log.Level_Statement >=
4908: Fnd_Log.G_Current_Runtime_Level)
4909: THEN
4910: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4911: lc_mod_name,

Line 4908: Fnd_Log.G_Current_Runtime_Level)

4904: FOR r1 IN c_sol_tasks_no_prod(p_repair_line_id)
4905: LOOP
4906: x_warning_flag := Fnd_Api.G_TRUE;
4907: IF (Fnd_Log.Level_Statement >=
4908: Fnd_Log.G_Current_Runtime_Level)
4909: THEN
4910: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4911: lc_mod_name,
4912: 'Adding message CSD_EST_SOL_TASK_NO_PROD to FND_MSG stack');

Line 4910: Fnd_Log.STRING(Fnd_Log.Level_Statement,

4906: x_warning_flag := Fnd_Api.G_TRUE;
4907: IF (Fnd_Log.Level_Statement >=
4908: Fnd_Log.G_Current_Runtime_Level)
4909: THEN
4910: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4911: lc_mod_name,
4912: 'Adding message CSD_EST_SOL_TASK_NO_PROD to FND_MSG stack');
4913: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4914: lc_mod_name,

Line 4913: Fnd_Log.STRING(Fnd_Log.Level_Statement,

4909: THEN
4910: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4911: lc_mod_name,
4912: 'Adding message CSD_EST_SOL_TASK_NO_PROD to FND_MSG stack');
4913: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4914: lc_mod_name,
4915: 'no task template for task group id ' ||
4916: r1.task_group_id);
4917: END IF;

Line 4922: IF (Fnd_Log.Level_Procedure >=

4918: Fnd_Message.SET_NAME('CSD', 'CSD_EST_SOL_TASK_NO_PROD');
4919: Fnd_Message.SET_TOKEN('GROUP_ID', r1.task_group_id);
4920: Fnd_Message.SET_TOKEN('GROUP_NAME', r1.task_group_name);
4921: Fnd_Msg_Pub.ADD;
4922: IF (Fnd_Log.Level_Procedure >=
4923: Fnd_Log.G_Current_Runtime_Level)
4924: THEN
4925: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4926: lc_mod_name,

Line 4923: Fnd_Log.G_Current_Runtime_Level)

4919: Fnd_Message.SET_TOKEN('GROUP_ID', r1.task_group_id);
4920: Fnd_Message.SET_TOKEN('GROUP_NAME', r1.task_group_name);
4921: Fnd_Msg_Pub.ADD;
4922: IF (Fnd_Log.Level_Procedure >=
4923: Fnd_Log.G_Current_Runtime_Level)
4924: THEN
4925: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4926: lc_mod_name,
4927: 'Calling CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');

Line 4925: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

4921: Fnd_Msg_Pub.ADD;
4922: IF (Fnd_Log.Level_Procedure >=
4923: Fnd_Log.G_Current_Runtime_Level)
4924: THEN
4925: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4926: lc_mod_name,
4927: 'Calling CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
4928: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4929: lc_mod_name,

Line 4928: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

4924: THEN
4925: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4926: lc_mod_name,
4927: 'Calling CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
4928: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4929: lc_mod_name,
4930: 'Number of messages in stack: ' ||
4931: Fnd_Msg_Pub.count_msg);
4932: END IF;

Line 4948: IF (Fnd_Log.Level_Procedure >=

4944: IF NOT (l_return_status = Fnd_Api.G_RET_STS_SUCCESS)
4945: THEN
4946: RAISE Fnd_Api.G_EXC_ERROR;
4947: END IF;
4948: IF (Fnd_Log.Level_Procedure >=
4949: Fnd_Log.G_Current_Runtime_Level)
4950: THEN
4951: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4952: lc_mod_name,

Line 4949: Fnd_Log.G_Current_Runtime_Level)

4945: THEN
4946: RAISE Fnd_Api.G_EXC_ERROR;
4947: END IF;
4948: IF (Fnd_Log.Level_Procedure >=
4949: Fnd_Log.G_Current_Runtime_Level)
4950: THEN
4951: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4952: lc_mod_name,
4953: 'Returned from CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');

Line 4951: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

4947: END IF;
4948: IF (Fnd_Log.Level_Procedure >=
4949: Fnd_Log.G_Current_Runtime_Level)
4950: THEN
4951: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4952: lc_mod_name,
4953: 'Returned from CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
4954: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4955: lc_mod_name,

Line 4954: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

4950: THEN
4951: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4952: lc_mod_name,
4953: 'Returned from CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
4954: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4955: lc_mod_name,
4956: 'Number of messages in stack: ' ||
4957: Fnd_Msg_Pub.count_msg);
4958: END IF;

Line 4968: IF (Fnd_Log.Level_Procedure >=

4964: --
4965: DECLARE
4966: l_count NUMBER := 0;
4967: BEGIN
4968: IF (Fnd_Log.Level_Procedure >=
4969: Fnd_Log.G_Current_Runtime_Level)
4970: THEN
4971: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4972: lc_mod_name,

Line 4969: Fnd_Log.G_Current_Runtime_Level)

4965: DECLARE
4966: l_count NUMBER := 0;
4967: BEGIN
4968: IF (Fnd_Log.Level_Procedure >=
4969: Fnd_Log.G_Current_Runtime_Level)
4970: THEN
4971: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4972: lc_mod_name,
4973: 'Getting task material lines from solutions');

Line 4971: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

4967: BEGIN
4968: IF (Fnd_Log.Level_Procedure >=
4969: Fnd_Log.G_Current_Runtime_Level)
4970: THEN
4971: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4972: lc_mod_name,
4973: 'Getting task material lines from solutions');
4974: END IF;
4975: FOR r1 IN c_material_lines_from_sol(p_repair_line_id,

Line 5007: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

5003: END IF;
5004: END LOOP;
5005: END;
5006:
5007: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5008: THEN
5009: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5010: lc_mod_name,
5011: 'material line count = ' ||

Line 5009: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

5005: END;
5006:
5007: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5008: THEN
5009: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5010: lc_mod_name,
5011: 'material line count = ' ||
5012: l_materials_from_sol_tbl.COUNT);
5013: END IF;

Line 5058: IF (Fnd_Log.Level_Procedure >=

5054: THEN
5055: DECLARE
5056: l_count NUMBER := 0;
5057: BEGIN
5058: IF (Fnd_Log.Level_Procedure >=
5059: Fnd_Log.G_Current_Runtime_Level)
5060: THEN
5061: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5062: lc_mod_name,

Line 5059: Fnd_Log.G_Current_Runtime_Level)

5055: DECLARE
5056: l_count NUMBER := 0;
5057: BEGIN
5058: IF (Fnd_Log.Level_Procedure >=
5059: Fnd_Log.G_Current_Runtime_Level)
5060: THEN
5061: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5062: lc_mod_name,
5063: 'Getting task labor lines from solutions');

Line 5061: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

5057: BEGIN
5058: IF (Fnd_Log.Level_Procedure >=
5059: Fnd_Log.G_Current_Runtime_Level)
5060: THEN
5061: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5062: lc_mod_name,
5063: 'Getting task labor lines from solutions');
5064: END IF;
5065: FOR r1 IN c_labor_lines_from_sol(p_repair_line_id,

Line 5087: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

5083: l_labor_from_sol_tbl(l_count).ro_service_code_id := r1.ro_service_code_id;
5084: END LOOP;
5085: END;
5086:
5087: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5088: THEN
5089: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5090: lc_mod_name,
5091: 'labor line count = ' ||

Line 5089: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

5085: END;
5086:
5087: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5088: THEN
5089: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5090: lc_mod_name,
5091: 'labor line count = ' ||
5092: l_labor_from_sol_tbl.COUNT);
5093: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

Line 5093: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

5089: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5090: lc_mod_name,
5091: 'labor line count = ' ||
5092: l_labor_from_sol_tbl.COUNT);
5093: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5094: lc_mod_name,
5095: 'Calling Convert_To_Est_Lines');
5096: END IF;
5097: IF (l_labor_from_sol_tbl.COUNT > 0)

Line 5136: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

5132: -- bugfix 3543135, vkjain.
5133: -- IF (x_est_lines_tbl.count <= 0) THEN
5134: IF (l_No_Eligible_Lines)
5135: THEN
5136: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5137: THEN
5138: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5139: lc_mod_name,
5140: 'no estimate lines available to autogenerate from tasks');

Line 5138: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

5134: IF (l_No_Eligible_Lines)
5135: THEN
5136: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5137: THEN
5138: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5139: lc_mod_name,
5140: 'no estimate lines available to autogenerate from tasks');
5141: END IF;
5142: RAISE CSD_EST_NO_AUTOGEN;

Line 5145: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)

5141: END IF;
5142: RAISE CSD_EST_NO_AUTOGEN;
5143: END IF;
5144:
5145: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
5146: THEN
5147: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5148: lc_mod_name || '.out_parameter',
5149: 'x_warning_flag: ' || x_warning_flag);

Line 5147: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5143: END IF;
5144:
5145: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
5146: THEN
5147: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5148: lc_mod_name || '.out_parameter',
5149: 'x_warning_flag: ' || x_warning_flag);
5150: END IF;
5151: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

Line 5151: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

5147: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5148: lc_mod_name || '.out_parameter',
5149: 'x_warning_flag: ' || x_warning_flag);
5150: END IF;
5151: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5152: THEN
5153: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5154: lc_mod_name || '.END',
5155: 'Leaving CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_Task');

Line 5153: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

5149: 'x_warning_flag: ' || x_warning_flag);
5150: END IF;
5151: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5152: THEN
5153: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5154: lc_mod_name || '.END',
5155: 'Leaving CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_Task');
5156: END IF;
5157: --

Line 5175: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)

5171: WHEN CSD_EST_NO_AUTOGEN THEN
5172: x_warning_flag := Fnd_Api.G_TRUE;
5173:
5174: -- save message in fnd stack
5175: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
5176: THEN
5177: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5178: lc_mod_name,
5179: 'Adding message CSD_EST_NO_AUTOGEN to FND_MSG stack');

Line 5177: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5173:
5174: -- save message in fnd stack
5175: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
5176: THEN
5177: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5178: lc_mod_name,
5179: 'Adding message CSD_EST_NO_AUTOGEN to FND_MSG stack');
5180: END IF;
5181: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NO_AUTOGEN');

Line 5187: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)

5183: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5184: p_data => x_msg_data);
5185:
5186: -- save message in debug log
5187: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5188: THEN
5189: Fnd_Log.STRING(Fnd_Log.Level_Exception,
5190: lc_mod_name,
5191: 'No estimate lines autogenerated');

Line 5189: Fnd_Log.STRING(Fnd_Log.Level_Exception,

5185:
5186: -- save message in debug log
5187: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5188: THEN
5189: Fnd_Log.STRING(Fnd_Log.Level_Exception,
5190: lc_mod_name,
5191: 'No estimate lines autogenerated');
5192: END IF;
5193:

Line 5201: if (Fnd_Log.Level_Statement>= Fnd_Log.G_Current_Runtime_Level) then

5197:
5198: /*
5199: -- TO DO: Add seeded err message
5200: -- save message in fnd stack
5201: if (Fnd_Log.Level_Statement>= Fnd_Log.G_Current_Runtime_Level) then
5202: FND_LOG.STRING(Fnd_Log.Level_Statement, lc_mod_name,
5203: 'Adding message ERR_NAME to FND_MSG stack');
5204: end if;
5205: FND_MESSAGE.SET_NAME('CSD','err_name');

Line 5202: FND_LOG.STRING(Fnd_Log.Level_Statement, lc_mod_name,

5198: /*
5199: -- TO DO: Add seeded err message
5200: -- save message in fnd stack
5201: if (Fnd_Log.Level_Statement>= Fnd_Log.G_Current_Runtime_Level) then
5202: FND_LOG.STRING(Fnd_Log.Level_Statement, lc_mod_name,
5203: 'Adding message ERR_NAME to FND_MSG stack');
5204: end if;
5205: FND_MESSAGE.SET_NAME('CSD','err_name');
5206: FND_MESSAGE.SET_TOKEN('toke_name', 'token_value');

Line 5213: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)

5209: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5210: p_data => x_msg_data);
5211:
5212: -- save message in debug log
5213: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5214: THEN
5215: Fnd_Log.STRING(Fnd_Log.Level_Exception,
5216: lc_mod_name,
5217: 'EXC_ERROR[' || x_msg_data || ']');

Line 5215: Fnd_Log.STRING(Fnd_Log.Level_Exception,

5211:
5212: -- save message in debug log
5213: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5214: THEN
5215: Fnd_Log.STRING(Fnd_Log.Level_Exception,
5216: lc_mod_name,
5217: 'EXC_ERROR[' || x_msg_data || ']');
5218: END IF;
5219:

Line 5227: IF (Fnd_Log.Level_Statement >=

5223:
5224: -- save message in fnd stack
5225: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5226: THEN
5227: IF (Fnd_Log.Level_Statement >=
5228: Fnd_Log.G_Current_Runtime_Level)
5229: THEN
5230: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5231: lc_mod_name,

Line 5228: Fnd_Log.G_Current_Runtime_Level)

5224: -- save message in fnd stack
5225: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5226: THEN
5227: IF (Fnd_Log.Level_Statement >=
5228: Fnd_Log.G_Current_Runtime_Level)
5229: THEN
5230: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5231: lc_mod_name,
5232: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 5230: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5226: THEN
5227: IF (Fnd_Log.Level_Statement >=
5228: Fnd_Log.G_Current_Runtime_Level)
5229: THEN
5230: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5231: lc_mod_name,
5232: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5233: END IF;
5234: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);

Line 5240: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)

5236: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5237: p_data => x_msg_data);
5238:
5239: -- save message in debug log
5240: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5241: THEN
5242: Fnd_Log.STRING(Fnd_Log.Level_Exception,
5243: lc_mod_name,
5244: 'EXC_UNEXPECTED_ERROR[' || x_msg_data || ']');

Line 5242: Fnd_Log.STRING(Fnd_Log.Level_Exception,

5238:
5239: -- save message in debug log
5240: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5241: THEN
5242: Fnd_Log.STRING(Fnd_Log.Level_Exception,
5243: lc_mod_name,
5244: 'EXC_UNEXPECTED_ERROR[' || x_msg_data || ']');
5245: END IF;
5246:

Line 5254: IF (Fnd_Log.Level_Statement >=

5250:
5251: -- save message in fnd stack
5252: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5253: THEN
5254: IF (Fnd_Log.Level_Statement >=
5255: Fnd_Log.G_Current_Runtime_Level)
5256: THEN
5257: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5258: lc_mod_name,

Line 5255: Fnd_Log.G_Current_Runtime_Level)

5251: -- save message in fnd stack
5252: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5253: THEN
5254: IF (Fnd_Log.Level_Statement >=
5255: Fnd_Log.G_Current_Runtime_Level)
5256: THEN
5257: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5258: lc_mod_name,
5259: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 5257: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5253: THEN
5254: IF (Fnd_Log.Level_Statement >=
5255: Fnd_Log.G_Current_Runtime_Level)
5256: THEN
5257: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5258: lc_mod_name,
5259: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5260: END IF;
5261: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);

Line 5267: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)

5263: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5264: p_data => x_msg_data);
5265:
5266: -- save message in debug log
5267: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5268: THEN
5269: -- create a seeded message
5270: Fnd_Log.STRING(Fnd_Log.Level_Exception,
5271: lc_mod_name,

Line 5270: Fnd_Log.STRING(Fnd_Log.Level_Exception,

5266: -- save message in debug log
5267: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5268: THEN
5269: -- create a seeded message
5270: Fnd_Log.STRING(Fnd_Log.Level_Exception,
5271: lc_mod_name,
5272: 'SQL Message[' || SQLERRM || ']');
5273: END IF;
5274: END Get_Estimates_From_Task;

Line 5312: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;

5308: x_est_lines_tbl OUT NOCOPY CSD_REPAIR_ESTIMATE_PVT.REPAIR_ESTIMATE_LINE_TBL,
5309: x_warning_flag OUT NOCOPY VARCHAR2) IS
5310:
5311: -- CONSTANTS --
5312: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
5313: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
5314: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
5315: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
5316: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;

Line 5313: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;

5309: x_warning_flag OUT NOCOPY VARCHAR2) IS
5310:
5311: -- CONSTANTS --
5312: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
5313: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
5314: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
5315: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
5316: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
5317: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;

Line 5314: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;

5310:
5311: -- CONSTANTS --
5312: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
5313: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
5314: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
5315: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
5316: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
5317: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
5318: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;

Line 5315: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;

5311: -- CONSTANTS --
5312: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
5313: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
5314: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
5315: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
5316: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
5317: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
5318: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
5319: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.get_estimates_from_bom';

Line 5316: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;

5312: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
5313: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
5314: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
5315: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
5316: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
5317: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
5318: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
5319: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.get_estimates_from_bom';
5320: lc_api_name CONSTANT VARCHAR2(30) := 'Get_Estimates_From_BOM';

Line 5317: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;

5313: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
5314: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
5315: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
5316: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
5317: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
5318: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
5319: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.get_estimates_from_bom';
5320: lc_api_name CONSTANT VARCHAR2(30) := 'Get_Estimates_From_BOM';
5321: lc_api_version CONSTANT NUMBER := 1.0;

Line 5318: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;

5314: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
5315: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
5316: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
5317: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
5318: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
5319: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.get_estimates_from_bom';
5320: lc_api_name CONSTANT VARCHAR2(30) := 'Get_Estimates_From_BOM';
5321: lc_api_version CONSTANT NUMBER := 1.0;
5322:

Line 5574: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

5570: THEN
5571: Fnd_Msg_Pub.initialize;
5572: END IF;
5573:
5574: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5575: THEN
5576: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5577: lc_mod_name || '.BEGIN',
5578: 'Entering CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_BOM');

Line 5576: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

5572: END IF;
5573:
5574: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5575: THEN
5576: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5577: lc_mod_name || '.BEGIN',
5578: 'Entering CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_BOM');
5579: END IF;
5580: -- log parameters

Line 5581: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)

5577: lc_mod_name || '.BEGIN',
5578: 'Entering CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_BOM');
5579: END IF;
5580: -- log parameters
5581: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
5582: THEN
5583: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5584: lc_mod_name || '.parameter_logging',
5585: 'p_api_version: ' || p_api_version);

Line 5583: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5579: END IF;
5580: -- log parameters
5581: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
5582: THEN
5583: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5584: lc_mod_name || '.parameter_logging',
5585: 'p_api_version: ' || p_api_version);
5586: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5587: lc_mod_name || '.parameter_logging',

Line 5586: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5582: THEN
5583: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5584: lc_mod_name || '.parameter_logging',
5585: 'p_api_version: ' || p_api_version);
5586: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5587: lc_mod_name || '.parameter_logging',
5588: 'p_commit: ' || p_commit);
5589: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5590: lc_mod_name || '.parameter_logging',

Line 5589: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5585: 'p_api_version: ' || p_api_version);
5586: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5587: lc_mod_name || '.parameter_logging',
5588: 'p_commit: ' || p_commit);
5589: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5590: lc_mod_name || '.parameter_logging',
5591: 'p_init_msg_list: ' || p_init_msg_list);
5592: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5593: lc_mod_name || '.parameter_logging',

Line 5592: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5588: 'p_commit: ' || p_commit);
5589: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5590: lc_mod_name || '.parameter_logging',
5591: 'p_init_msg_list: ' || p_init_msg_list);
5592: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5593: lc_mod_name || '.parameter_logging',
5594: 'p_validation_level: ' || p_validation_level);
5595: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5596: lc_mod_name || '.parameter_logging',

Line 5595: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5591: 'p_init_msg_list: ' || p_init_msg_list);
5592: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5593: lc_mod_name || '.parameter_logging',
5594: 'p_validation_level: ' || p_validation_level);
5595: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5596: lc_mod_name || '.parameter_logging',
5597: 'p_repair_line_id: ' || p_repair_line_id);
5598: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5599: lc_mod_name || '.parameter_logging',

Line 5598: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5594: 'p_validation_level: ' || p_validation_level);
5595: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5596: lc_mod_name || '.parameter_logging',
5597: 'p_repair_line_id: ' || p_repair_line_id);
5598: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5599: lc_mod_name || '.parameter_logging',
5600: 'p_estimate_id: ' || p_estimate_id);
5601: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5602: lc_mod_name || '.parameter_logging',

Line 5601: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5597: 'p_repair_line_id: ' || p_repair_line_id);
5598: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5599: lc_mod_name || '.parameter_logging',
5600: 'p_estimate_id: ' || p_estimate_id);
5601: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5602: lc_mod_name || '.parameter_logging',
5603: 'p_repair_type_id: ' || p_repair_type_id);
5604: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5605: lc_mod_name || '.parameter_logging',

Line 5604: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5600: 'p_estimate_id: ' || p_estimate_id);
5601: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5602: lc_mod_name || '.parameter_logging',
5603: 'p_repair_type_id: ' || p_repair_type_id);
5604: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5605: lc_mod_name || '.parameter_logging',
5606: 'p_business_process_id: ' ||
5607: p_business_process_id);
5608: Fnd_Log.STRING(Fnd_Log.Level_Statement,

Line 5608: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5604: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5605: lc_mod_name || '.parameter_logging',
5606: 'p_business_process_id: ' ||
5607: p_business_process_id);
5608: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5609: lc_mod_name || '.parameter_logging',
5610: 'p_currency_code: ' || p_currency_code);
5611: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5612: lc_mod_name || '.parameter_logging',

Line 5611: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5607: p_business_process_id);
5608: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5609: lc_mod_name || '.parameter_logging',
5610: 'p_currency_code: ' || p_currency_code);
5611: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5612: lc_mod_name || '.parameter_logging',
5613: 'p_incident_id: ' || p_incident_id);
5614: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5615: lc_mod_name || '.parameter_logging',

Line 5614: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5610: 'p_currency_code: ' || p_currency_code);
5611: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5612: lc_mod_name || '.parameter_logging',
5613: 'p_incident_id: ' || p_incident_id);
5614: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5615: lc_mod_name || '.parameter_logging',
5616: 'p_repair_mode: ' || p_repair_mode);
5617: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5618: lc_mod_name || '.parameter_logging',

Line 5617: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5613: 'p_incident_id: ' || p_incident_id);
5614: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5615: lc_mod_name || '.parameter_logging',
5616: 'p_repair_mode: ' || p_repair_mode);
5617: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5618: lc_mod_name || '.parameter_logging',
5619: 'p_inventory_item_id: ' || p_inventory_item_id);
5620: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5621: lc_mod_name || '.parameter_logging',

Line 5620: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5616: 'p_repair_mode: ' || p_repair_mode);
5617: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5618: lc_mod_name || '.parameter_logging',
5619: 'p_inventory_item_id: ' || p_inventory_item_id);
5620: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5621: lc_mod_name || '.parameter_logging',
5622: 'p_organization_id: ' || p_organization_id);
5623: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5624: lc_mod_name || '.parameter_logging',

Line 5623: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5619: 'p_inventory_item_id: ' || p_inventory_item_id);
5620: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5621: lc_mod_name || '.parameter_logging',
5622: 'p_organization_id: ' || p_organization_id);
5623: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5624: lc_mod_name || '.parameter_logging',
5625: 'p_price_list_id: ' || p_price_list_id);
5626: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5627: lc_mod_name || '.parameter_logging',

Line 5626: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5622: 'p_organization_id: ' || p_organization_id);
5623: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5624: lc_mod_name || '.parameter_logging',
5625: 'p_price_list_id: ' || p_price_list_id);
5626: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5627: lc_mod_name || '.parameter_logging',
5628: 'p_contract_line_id: ' || p_contract_line_id);
5629: END IF;
5630:

Line 5647: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

5643: --
5644: DECLARE
5645: l_count NUMBER := 0;
5646: BEGIN
5647: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5648: THEN
5649: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5650: lc_mod_name,
5651: 'Getting BOM material lines from service codes');

Line 5649: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

5645: l_count NUMBER := 0;
5646: BEGIN
5647: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5648: THEN
5649: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5650: lc_mod_name,
5651: 'Getting BOM material lines from service codes');
5652: END IF;
5653: -- Bugfix 3468680, vkjain

Line 5685: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

5681: -- THEN
5682: -- Csd_Gen_Utility_Pvt.dump_mle_lines_tbl_type(l_material_lines_tbl);
5683: -- END IF;
5684:
5685: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5686: THEN
5687: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5688: lc_mod_name,
5689: 'material line count = ' ||

Line 5687: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

5683: -- END IF;
5684:
5685: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5686: THEN
5687: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5688: lc_mod_name,
5689: 'material line count = ' ||
5690: l_material_lines_tbl.COUNT);
5691: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

Line 5691: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

5687: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5688: lc_mod_name,
5689: 'material line count = ' ||
5690: l_material_lines_tbl.COUNT);
5691: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5692: lc_mod_name,
5693: 'Calling Convert_To_Est_Lines');
5694: END IF;
5695:

Line 5736: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

5732: --
5733: DECLARE
5734: l_count NUMBER := 0;
5735: BEGIN
5736: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5737: THEN
5738: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5739: lc_mod_name,
5740: 'Getting BOM labor lines from service codes');

Line 5738: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

5734: l_count NUMBER := 0;
5735: BEGIN
5736: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5737: THEN
5738: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5739: lc_mod_name,
5740: 'Getting BOM labor lines from service codes');
5741: END IF;
5742: -- bugfix 3468680, vkjain

Line 5776: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

5772: -- THEN
5773: -- Csd_Gen_Utility_Pvt.dump_mle_lines_tbl_type(l_labor_lines_tbl);
5774: -- END IF;
5775:
5776: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5777: THEN
5778: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5779: lc_mod_name,
5780: 'labor line count = ' || l_labor_lines_tbl.COUNT);

Line 5778: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

5774: -- END IF;
5775:
5776: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5777: THEN
5778: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5779: lc_mod_name,
5780: 'labor line count = ' || l_labor_lines_tbl.COUNT);
5781: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5782: lc_mod_name,

Line 5781: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

5777: THEN
5778: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5779: lc_mod_name,
5780: 'labor line count = ' || l_labor_lines_tbl.COUNT);
5781: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5782: lc_mod_name,
5783: 'Calling Convert_To_Est_Lines');
5784: END IF;
5785: Convert_To_Est_Lines(p_api_version => 1.0,

Line 5823: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

5819: -- bugfix 3543135, vkjain.
5820: -- IF (NVL(x_est_lines_tbl.count, 0) <= 0) THEN
5821: IF (l_No_Eligible_Lines)
5822: THEN
5823: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5824: THEN
5825: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5826: lc_mod_name,
5827: 'no estimate lines available to autogenerate from BOM');

Line 5825: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

5821: IF (l_No_Eligible_Lines)
5822: THEN
5823: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5824: THEN
5825: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5826: lc_mod_name,
5827: 'no estimate lines available to autogenerate from BOM');
5828: END IF;
5829: RAISE CSD_EST_NO_AUTOGEN;

Line 5832: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)

5828: END IF;
5829: RAISE CSD_EST_NO_AUTOGEN;
5830: END IF;
5831:
5832: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
5833: THEN
5834: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5835: lc_mod_name || '.out_parameter',
5836: 'x_warning_flag: ' || x_warning_flag);

Line 5834: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5830: END IF;
5831:
5832: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
5833: THEN
5834: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5835: lc_mod_name || '.out_parameter',
5836: 'x_warning_flag: ' || x_warning_flag);
5837: END IF;
5838: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

Line 5838: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

5834: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5835: lc_mod_name || '.out_parameter',
5836: 'x_warning_flag: ' || x_warning_flag);
5837: END IF;
5838: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5839: THEN
5840: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5841: lc_mod_name || '.END',
5842: 'Leaving CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_BOM');

Line 5840: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

5836: 'x_warning_flag: ' || x_warning_flag);
5837: END IF;
5838: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5839: THEN
5840: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5841: lc_mod_name || '.END',
5842: 'Leaving CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_BOM');
5843: END IF;
5844:

Line 5863: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)

5859: WHEN CSD_EST_NO_AUTOGEN THEN
5860: x_warning_flag := Fnd_Api.G_TRUE;
5861:
5862: -- save message in fnd stack
5863: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
5864: THEN
5865: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5866: lc_mod_name,
5867: 'Adding message CSD_EST_NO_AUTOGEN to FND_MSG stack');

Line 5865: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5861:
5862: -- save message in fnd stack
5863: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
5864: THEN
5865: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5866: lc_mod_name,
5867: 'Adding message CSD_EST_NO_AUTOGEN to FND_MSG stack');
5868: END IF;
5869: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NO_AUTOGEN');

Line 5875: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)

5871: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5872: p_data => x_msg_data);
5873:
5874: -- save message in debug log
5875: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5876: THEN
5877: Fnd_Log.STRING(Fnd_Log.Level_Exception,
5878: lc_mod_name,
5879: 'No estimate lines autogenerated');

Line 5877: Fnd_Log.STRING(Fnd_Log.Level_Exception,

5873:
5874: -- save message in debug log
5875: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5876: THEN
5877: Fnd_Log.STRING(Fnd_Log.Level_Exception,
5878: lc_mod_name,
5879: 'No estimate lines autogenerated');
5880: END IF;
5881: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 5888: if (Fnd_Log.Level_Statement>= Fnd_Log.G_Current_Runtime_Level) then

5884:
5885: /*
5886: -- TO DO: Add seeded err message
5887: -- save message in fnd stack
5888: if (Fnd_Log.Level_Statement>= Fnd_Log.G_Current_Runtime_Level) then
5889: FND_LOG.STRING(Fnd_Log.Level_Statement, lc_mod_name,
5890: 'Adding message err_name to FND_MSG stack');
5891: end if;
5892: FND_MESSAGE.SET_NAME('CSD','err_name');

Line 5889: FND_LOG.STRING(Fnd_Log.Level_Statement, lc_mod_name,

5885: /*
5886: -- TO DO: Add seeded err message
5887: -- save message in fnd stack
5888: if (Fnd_Log.Level_Statement>= Fnd_Log.G_Current_Runtime_Level) then
5889: FND_LOG.STRING(Fnd_Log.Level_Statement, lc_mod_name,
5890: 'Adding message err_name to FND_MSG stack');
5891: end if;
5892: FND_MESSAGE.SET_NAME('CSD','err_name');
5893: FND_MESSAGE.SET_TOKEN('toke_name', 'token_value');

Line 5900: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)

5896: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5897: p_data => x_msg_data);
5898:
5899: -- save message in debug log
5900: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5901: THEN
5902: Fnd_Log.STRING(Fnd_Log.Level_Exception,
5903: lc_mod_name,
5904: 'EXC_ERROR[' || x_msg_data || ']');

Line 5902: Fnd_Log.STRING(Fnd_Log.Level_Exception,

5898:
5899: -- save message in debug log
5900: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5901: THEN
5902: Fnd_Log.STRING(Fnd_Log.Level_Exception,
5903: lc_mod_name,
5904: 'EXC_ERROR[' || x_msg_data || ']');
5905: END IF;
5906:

Line 5914: IF (Fnd_Log.Level_Statement >=

5910:
5911: -- save message in fnd stack
5912: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5913: THEN
5914: IF (Fnd_Log.Level_Statement >=
5915: Fnd_Log.G_Current_Runtime_Level)
5916: THEN
5917: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5918: lc_mod_name,

Line 5915: Fnd_Log.G_Current_Runtime_Level)

5911: -- save message in fnd stack
5912: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5913: THEN
5914: IF (Fnd_Log.Level_Statement >=
5915: Fnd_Log.G_Current_Runtime_Level)
5916: THEN
5917: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5918: lc_mod_name,
5919: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 5917: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5913: THEN
5914: IF (Fnd_Log.Level_Statement >=
5915: Fnd_Log.G_Current_Runtime_Level)
5916: THEN
5917: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5918: lc_mod_name,
5919: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5920: END IF;
5921: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);

Line 5927: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)

5923: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5924: p_data => x_msg_data);
5925:
5926: -- save message in debug log
5927: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5928: THEN
5929: Fnd_Log.STRING(Fnd_Log.Level_Exception,
5930: lc_mod_name,
5931: 'EXC_UNEXPECTED_ERROR[' || x_msg_data || ']');

Line 5929: Fnd_Log.STRING(Fnd_Log.Level_Exception,

5925:
5926: -- save message in debug log
5927: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5928: THEN
5929: Fnd_Log.STRING(Fnd_Log.Level_Exception,
5930: lc_mod_name,
5931: 'EXC_UNEXPECTED_ERROR[' || x_msg_data || ']');
5932: END IF;
5933:

Line 5939: IF (Fnd_Log.Level_Statement >=

5935: ROLLBACK TO Get_Estimates_From_BOM;
5936: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5937: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5938: THEN
5939: IF (Fnd_Log.Level_Statement >=
5940: Fnd_Log.G_Current_Runtime_Level)
5941: THEN
5942: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5943: lc_mod_name,

Line 5940: Fnd_Log.G_Current_Runtime_Level)

5936: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5937: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5938: THEN
5939: IF (Fnd_Log.Level_Statement >=
5940: Fnd_Log.G_Current_Runtime_Level)
5941: THEN
5942: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5943: lc_mod_name,
5944: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 5942: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5938: THEN
5939: IF (Fnd_Log.Level_Statement >=
5940: Fnd_Log.G_Current_Runtime_Level)
5941: THEN
5942: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5943: lc_mod_name,
5944: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5945: END IF;
5946: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);

Line 5952: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)

5948: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5949: p_data => x_msg_data);
5950:
5951: -- save message in debug log
5952: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5953: THEN
5954: -- create a seeded message
5955: Fnd_Log.STRING(Fnd_Log.Level_Exception,
5956: lc_mod_name,

Line 5955: Fnd_Log.STRING(Fnd_Log.Level_Exception,

5951: -- save message in debug log
5952: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5953: THEN
5954: -- create a seeded message
5955: Fnd_Log.STRING(Fnd_Log.Level_Exception,
5956: lc_mod_name,
5957: 'SQL Message[' || SQLERRM || ']');
5958: END IF;
5959: END Get_Estimates_From_BOM;

Line 5999: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;

5995: p_MLE_lines_tbl IN MLE_LINES_TBL_TYPE,
5996: x_est_lines_tbl IN OUT NOCOPY REPAIR_ESTIMATE_LINE_TBL,
5997: x_warning_flag OUT NOCOPY VARCHAR2) IS
5998: -- CONSTANTS --
5999: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
6000: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
6001: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
6002: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
6003: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;

Line 6000: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;

5996: x_est_lines_tbl IN OUT NOCOPY REPAIR_ESTIMATE_LINE_TBL,
5997: x_warning_flag OUT NOCOPY VARCHAR2) IS
5998: -- CONSTANTS --
5999: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
6000: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
6001: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
6002: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
6003: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
6004: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;

Line 6001: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;

5997: x_warning_flag OUT NOCOPY VARCHAR2) IS
5998: -- CONSTANTS --
5999: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
6000: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
6001: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
6002: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
6003: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
6004: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
6005: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;

Line 6002: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;

5998: -- CONSTANTS --
5999: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
6000: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
6001: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
6002: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
6003: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
6004: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
6005: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
6006: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.convert_to_est_lines';

Line 6003: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;

5999: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
6000: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
6001: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
6002: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
6003: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
6004: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
6005: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
6006: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.convert_to_est_lines';
6007: lc_api_name CONSTANT VARCHAR2(30) := 'Convert_To_Est_Lines';

Line 6004: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;

6000: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
6001: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
6002: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
6003: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
6004: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
6005: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
6006: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.convert_to_est_lines';
6007: lc_api_name CONSTANT VARCHAR2(30) := 'Convert_To_Est_Lines';
6008: lc_api_version CONSTANT NUMBER := 1.0;

Line 6005: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;

6001: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
6002: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
6003: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
6004: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
6005: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
6006: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.convert_to_est_lines';
6007: lc_api_name CONSTANT VARCHAR2(30) := 'Convert_To_Est_Lines';
6008: lc_api_version CONSTANT NUMBER := 1.0;
6009:

Line 6064: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

6060: THEN
6061: Fnd_Msg_Pub.initialize;
6062: END IF;
6063:
6064: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
6065: THEN
6066: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6067: lc_mod_name || '.BEGIN',
6068: 'Entering CSD_REPAIR_ESTIMATE_PVT.Convert_To_Est_Lines');

Line 6066: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

6062: END IF;
6063:
6064: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
6065: THEN
6066: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6067: lc_mod_name || '.BEGIN',
6068: 'Entering CSD_REPAIR_ESTIMATE_PVT.Convert_To_Est_Lines');
6069: END IF;
6070: -- log parameters

Line 6071: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)

6067: lc_mod_name || '.BEGIN',
6068: 'Entering CSD_REPAIR_ESTIMATE_PVT.Convert_To_Est_Lines');
6069: END IF;
6070: -- log parameters
6071: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
6072: THEN
6073: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6074: lc_mod_name || '.parameter_logging',
6075: 'p_api_version: ' || p_api_version);

Line 6073: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6069: END IF;
6070: -- log parameters
6071: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
6072: THEN
6073: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6074: lc_mod_name || '.parameter_logging',
6075: 'p_api_version: ' || p_api_version);
6076: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6077: lc_mod_name || '.parameter_logging',

Line 6076: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6072: THEN
6073: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6074: lc_mod_name || '.parameter_logging',
6075: 'p_api_version: ' || p_api_version);
6076: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6077: lc_mod_name || '.parameter_logging',
6078: 'p_commit: ' || p_commit);
6079: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6080: lc_mod_name || '.parameter_logging',

Line 6079: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6075: 'p_api_version: ' || p_api_version);
6076: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6077: lc_mod_name || '.parameter_logging',
6078: 'p_commit: ' || p_commit);
6079: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6080: lc_mod_name || '.parameter_logging',
6081: 'p_init_msg_list: ' || p_init_msg_list);
6082: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6083: lc_mod_name || '.parameter_logging',

Line 6082: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6078: 'p_commit: ' || p_commit);
6079: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6080: lc_mod_name || '.parameter_logging',
6081: 'p_init_msg_list: ' || p_init_msg_list);
6082: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6083: lc_mod_name || '.parameter_logging',
6084: 'p_validation_level: ' || p_validation_level);
6085: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6086: lc_mod_name || '.parameter_logging',

Line 6085: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6081: 'p_init_msg_list: ' || p_init_msg_list);
6082: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6083: lc_mod_name || '.parameter_logging',
6084: 'p_validation_level: ' || p_validation_level);
6085: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6086: lc_mod_name || '.parameter_logging',
6087: 'p_repair_line_id: ' || p_repair_line_id);
6088: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6089: lc_mod_name || '.parameter_logging',

Line 6088: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6084: 'p_validation_level: ' || p_validation_level);
6085: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6086: lc_mod_name || '.parameter_logging',
6087: 'p_repair_line_id: ' || p_repair_line_id);
6088: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6089: lc_mod_name || '.parameter_logging',
6090: 'p_estimate_id: ' || p_estimate_id);
6091: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6092: lc_mod_name || '.parameter_logging',

Line 6091: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6087: 'p_repair_line_id: ' || p_repair_line_id);
6088: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6089: lc_mod_name || '.parameter_logging',
6090: 'p_estimate_id: ' || p_estimate_id);
6091: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6092: lc_mod_name || '.parameter_logging',
6093: 'p_repair_type_id: ' || p_repair_type_id);
6094: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6095: lc_mod_name || '.parameter_logging',

Line 6094: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6090: 'p_estimate_id: ' || p_estimate_id);
6091: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6092: lc_mod_name || '.parameter_logging',
6093: 'p_repair_type_id: ' || p_repair_type_id);
6094: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6095: lc_mod_name || '.parameter_logging',
6096: 'p_business_process_id: ' ||
6097: p_business_process_id);
6098: Fnd_Log.STRING(Fnd_Log.Level_Statement,

Line 6098: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6094: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6095: lc_mod_name || '.parameter_logging',
6096: 'p_business_process_id: ' ||
6097: p_business_process_id);
6098: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6099: lc_mod_name || '.parameter_logging',
6100: 'p_currency_code: ' || p_currency_code);
6101: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6102: lc_mod_name || '.parameter_logging',

Line 6101: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6097: p_business_process_id);
6098: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6099: lc_mod_name || '.parameter_logging',
6100: 'p_currency_code: ' || p_currency_code);
6101: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6102: lc_mod_name || '.parameter_logging',
6103: 'p_incident_id: ' || p_incident_id);
6104: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6105: lc_mod_name || '.parameter_logging',

Line 6104: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6100: 'p_currency_code: ' || p_currency_code);
6101: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6102: lc_mod_name || '.parameter_logging',
6103: 'p_incident_id: ' || p_incident_id);
6104: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6105: lc_mod_name || '.parameter_logging',
6106: 'p_organization_id: ' || p_organization_id);
6107: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6108: lc_mod_name || '.parameter_logging',

Line 6107: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6103: 'p_incident_id: ' || p_incident_id);
6104: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6105: lc_mod_name || '.parameter_logging',
6106: 'p_organization_id: ' || p_organization_id);
6107: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6108: lc_mod_name || '.parameter_logging',
6109: 'p_price_list_id: ' || p_price_list_id);
6110: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6111: lc_mod_name || '.parameter_logging',

Line 6110: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6106: 'p_organization_id: ' || p_organization_id);
6107: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6108: lc_mod_name || '.parameter_logging',
6109: 'p_price_list_id: ' || p_price_list_id);
6110: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6111: lc_mod_name || '.parameter_logging',
6112: 'p_contract_line_id: ' || p_contract_line_id);
6113: END IF;
6114:

Line 6131: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

6127: l_numRows := p_MLE_lines_tbl.COUNT;
6128: FOR i IN 1 .. l_numRows
6129: LOOP
6130: l_error := FALSE;
6131: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
6132: THEN
6133: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6134: lc_mod_name,
6135: 'Processing MLE line ' || i);

Line 6133: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

6129: LOOP
6130: l_error := FALSE;
6131: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
6132: THEN
6133: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6134: lc_mod_name,
6135: 'Processing MLE line ' || i);
6136: END IF;
6137:

Line 6146: IF (Fnd_Log.Level_Procedure >=

6142: -- get the selling price of the item
6143: -- if no selling price, then we cannot determine charge, so
6144: -- log a warning.
6145: BEGIN
6146: IF (Fnd_Log.Level_Procedure >=
6147: Fnd_Log.G_Current_Runtime_Level)
6148: THEN
6149: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6150: lc_mod_name,

Line 6147: Fnd_Log.G_Current_Runtime_Level)

6143: -- if no selling price, then we cannot determine charge, so
6144: -- log a warning.
6145: BEGIN
6146: IF (Fnd_Log.Level_Procedure >=
6147: Fnd_Log.G_Current_Runtime_Level)
6148: THEN
6149: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6150: lc_mod_name,
6151: 'Calling CSD_PROCESS_UTIL.get_charge_selling_price');

Line 6149: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

6145: BEGIN
6146: IF (Fnd_Log.Level_Procedure >=
6147: Fnd_Log.G_Current_Runtime_Level)
6148: THEN
6149: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6150: lc_mod_name,
6151: 'Calling CSD_PROCESS_UTIL.get_charge_selling_price');
6152: END IF;
6153:

Line 6167: IF (Fnd_Log.Level_Procedure >=

6163: x_selling_price => l_selling_price,
6164: x_return_status => l_return_status,
6165: x_msg_count => l_msg_count,
6166: x_msg_data => l_msg_data);
6167: IF (Fnd_Log.Level_Procedure >=
6168: Fnd_Log.G_Current_Runtime_Level)
6169: THEN
6170: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6171: lc_mod_name,

Line 6168: Fnd_Log.G_Current_Runtime_Level)

6164: x_return_status => l_return_status,
6165: x_msg_count => l_msg_count,
6166: x_msg_data => l_msg_data);
6167: IF (Fnd_Log.Level_Procedure >=
6168: Fnd_Log.G_Current_Runtime_Level)
6169: THEN
6170: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6171: lc_mod_name,
6172: 'Returned from CSD_PROCESS_UTIL.get_charge_selling_price');

Line 6170: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

6166: x_msg_data => l_msg_data);
6167: IF (Fnd_Log.Level_Procedure >=
6168: Fnd_Log.G_Current_Runtime_Level)
6169: THEN
6170: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6171: lc_mod_name,
6172: 'Returned from CSD_PROCESS_UTIL.get_charge_selling_price');
6173: END IF;
6174: IF (Fnd_Log.Level_Statement >=

Line 6174: IF (Fnd_Log.Level_Statement >=

6170: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6171: lc_mod_name,
6172: 'Returned from CSD_PROCESS_UTIL.get_charge_selling_price');
6173: END IF;
6174: IF (Fnd_Log.Level_Statement >=
6175: Fnd_Log.G_Current_Runtime_Level)
6176: THEN
6177: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6178: lc_mod_name,

Line 6175: Fnd_Log.G_Current_Runtime_Level)

6171: lc_mod_name,
6172: 'Returned from CSD_PROCESS_UTIL.get_charge_selling_price');
6173: END IF;
6174: IF (Fnd_Log.Level_Statement >=
6175: Fnd_Log.G_Current_Runtime_Level)
6176: THEN
6177: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6178: lc_mod_name,
6179: 'l_selling_price = ' || l_selling_price);

Line 6177: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6173: END IF;
6174: IF (Fnd_Log.Level_Statement >=
6175: Fnd_Log.G_Current_Runtime_Level)
6176: THEN
6177: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6178: lc_mod_name,
6179: 'l_selling_price = ' || l_selling_price);
6180: END IF;
6181: EXCEPTION

Line 6184: IF (Fnd_Log.Level_Procedure >=

6180: END IF;
6181: EXCEPTION
6182: WHEN Fnd_Api.G_EXC_ERROR THEN
6183: l_return_status := Fnd_Api.G_RET_STS_ERROR;
6184: IF (Fnd_Log.Level_Procedure >=
6185: Fnd_Log.G_Current_Runtime_Level)
6186: THEN
6187: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6188: lc_mod_name,

Line 6185: Fnd_Log.G_Current_Runtime_Level)

6181: EXCEPTION
6182: WHEN Fnd_Api.G_EXC_ERROR THEN
6183: l_return_status := Fnd_Api.G_RET_STS_ERROR;
6184: IF (Fnd_Log.Level_Procedure >=
6185: Fnd_Log.G_Current_Runtime_Level)
6186: THEN
6187: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6188: lc_mod_name,
6189: 'Exception FND_API.G_EXC_ERROR occurred in CSD_PROCESS_UTIL.get_charge_selling_price');

Line 6187: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

6183: l_return_status := Fnd_Api.G_RET_STS_ERROR;
6184: IF (Fnd_Log.Level_Procedure >=
6185: Fnd_Log.G_Current_Runtime_Level)
6186: THEN
6187: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6188: lc_mod_name,
6189: 'Exception FND_API.G_EXC_ERROR occurred in CSD_PROCESS_UTIL.get_charge_selling_price');
6190: END IF;
6191: WHEN OTHERS THEN

Line 6193: IF (Fnd_Log.Level_Procedure >=

6189: 'Exception FND_API.G_EXC_ERROR occurred in CSD_PROCESS_UTIL.get_charge_selling_price');
6190: END IF;
6191: WHEN OTHERS THEN
6192: l_return_status := Fnd_Api.G_RET_STS_ERROR;
6193: IF (Fnd_Log.Level_Procedure >=
6194: Fnd_Log.G_Current_Runtime_Level)
6195: THEN
6196: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6197: lc_mod_name,

Line 6194: Fnd_Log.G_Current_Runtime_Level)

6190: END IF;
6191: WHEN OTHERS THEN
6192: l_return_status := Fnd_Api.G_RET_STS_ERROR;
6193: IF (Fnd_Log.Level_Procedure >=
6194: Fnd_Log.G_Current_Runtime_Level)
6195: THEN
6196: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6197: lc_mod_name,
6198: 'Exception OTHERS occurred in CSD_PROCESS_UTIL.get_charge_selling_price');

Line 6196: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

6192: l_return_status := Fnd_Api.G_RET_STS_ERROR;
6193: IF (Fnd_Log.Level_Procedure >=
6194: Fnd_Log.G_Current_Runtime_Level)
6195: THEN
6196: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6197: lc_mod_name,
6198: 'Exception OTHERS occurred in CSD_PROCESS_UTIL.get_charge_selling_price');
6199: END IF;
6200: END;

Line 6205: IF (Fnd_Log.Level_Statement >=

6201:
6202: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS) OR
6203: (l_selling_price IS NULL)
6204: THEN
6205: IF (Fnd_Log.Level_Statement >=
6206: Fnd_Log.G_Current_Runtime_Level)
6207: THEN
6208: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6209: lc_mod_name,

Line 6206: Fnd_Log.G_Current_Runtime_Level)

6202: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS) OR
6203: (l_selling_price IS NULL)
6204: THEN
6205: IF (Fnd_Log.Level_Statement >=
6206: Fnd_Log.G_Current_Runtime_Level)
6207: THEN
6208: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6209: lc_mod_name,
6210: 'Adding message CSD_EST_NOPRICE_ITEM_UOM to FND_MSG stack');

Line 6208: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6204: THEN
6205: IF (Fnd_Log.Level_Statement >=
6206: Fnd_Log.G_Current_Runtime_Level)
6207: THEN
6208: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6209: lc_mod_name,
6210: 'Adding message CSD_EST_NOPRICE_ITEM_UOM to FND_MSG stack');
6211: END IF;
6212: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NOPRICE_ITEM_UOM');

Line 6221: IF (Fnd_Log.Level_Procedure >=

6217: WHERE list_header_id = p_price_list_id;
6218: EXCEPTION
6219: WHEN NO_DATA_FOUND THEN
6220: l_price_list_name := p_price_list_id;
6221: IF (Fnd_Log.Level_Procedure >=
6222: Fnd_Log.G_Current_Runtime_Level)
6223: THEN
6224: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6225: lc_mod_name,

Line 6222: Fnd_Log.G_Current_Runtime_Level)

6218: EXCEPTION
6219: WHEN NO_DATA_FOUND THEN
6220: l_price_list_name := p_price_list_id;
6221: IF (Fnd_Log.Level_Procedure >=
6222: Fnd_Log.G_Current_Runtime_Level)
6223: THEN
6224: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6225: lc_mod_name,
6226: 'Exception NO_DATA_FOUND occurred while querying for price list name');

Line 6224: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

6220: l_price_list_name := p_price_list_id;
6221: IF (Fnd_Log.Level_Procedure >=
6222: Fnd_Log.G_Current_Runtime_Level)
6223: THEN
6224: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6225: lc_mod_name,
6226: 'Exception NO_DATA_FOUND occurred while querying for price list name');
6227: END IF;
6228: WHEN OTHERS THEN

Line 6230: IF (Fnd_Log.Level_Procedure >=

6226: 'Exception NO_DATA_FOUND occurred while querying for price list name');
6227: END IF;
6228: WHEN OTHERS THEN
6229: l_price_list_name := p_price_list_id;
6230: IF (Fnd_Log.Level_Procedure >=
6231: Fnd_Log.G_Current_Runtime_Level)
6232: THEN
6233: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6234: lc_mod_name,

Line 6231: Fnd_Log.G_Current_Runtime_Level)

6227: END IF;
6228: WHEN OTHERS THEN
6229: l_price_list_name := p_price_list_id;
6230: IF (Fnd_Log.Level_Procedure >=
6231: Fnd_Log.G_Current_Runtime_Level)
6232: THEN
6233: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6234: lc_mod_name,
6235: 'Exception OTHERS occurred while querying for price list name');

Line 6233: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

6229: l_price_list_name := p_price_list_id;
6230: IF (Fnd_Log.Level_Procedure >=
6231: Fnd_Log.G_Current_Runtime_Level)
6232: THEN
6233: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6234: lc_mod_name,
6235: 'Exception OTHERS occurred while querying for price list name');
6236: END IF;
6237: END;

Line 6243: IF (Fnd_Log.Level_Statement >=

6239: Fnd_Message.SET_TOKEN('PRICELIST', l_price_list_name);
6240: Fnd_Message.SET_TOKEN('UOM', p_MLE_lines_tbl(i).uom);
6241: Fnd_Msg_Pub.ADD;
6242: l_error := TRUE;
6243: IF (Fnd_Log.Level_Statement >=
6244: Fnd_Log.G_Current_Runtime_Level)
6245: THEN
6246: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6247: lc_mod_name,

Line 6244: Fnd_Log.G_Current_Runtime_Level)

6240: Fnd_Message.SET_TOKEN('UOM', p_MLE_lines_tbl(i).uom);
6241: Fnd_Msg_Pub.ADD;
6242: l_error := TRUE;
6243: IF (Fnd_Log.Level_Statement >=
6244: Fnd_Log.G_Current_Runtime_Level)
6245: THEN
6246: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6247: lc_mod_name,
6248: 'Unable to get price for item-uom combination in pricelist ' ||

Line 6246: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6242: l_error := TRUE;
6243: IF (Fnd_Log.Level_Statement >=
6244: Fnd_Log.G_Current_Runtime_Level)
6245: THEN
6246: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6247: lc_mod_name,
6248: 'Unable to get price for item-uom combination in pricelist ' ||
6249: p_price_list_id);
6250: END IF;

Line 6254: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

6250: END IF;
6251: END IF;
6252:
6253: -- check txn billing type
6254: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
6255: THEN
6256: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6257: lc_mod_name,
6258: 'Checking for required txn billing type id');

Line 6256: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

6252:
6253: -- check txn billing type
6254: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
6255: THEN
6256: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6257: lc_mod_name,
6258: 'Checking for required txn billing type id');
6259: END IF;
6260: IF (p_MLE_lines_tbl(i).txn_billing_type_id IS NULL)

Line 6262: IF (Fnd_Log.Level_Statement >=

6258: 'Checking for required txn billing type id');
6259: END IF;
6260: IF (p_MLE_lines_tbl(i).txn_billing_type_id IS NULL)
6261: THEN
6262: IF (Fnd_Log.Level_Statement >=
6263: Fnd_Log.G_Current_Runtime_Level)
6264: THEN
6265: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6266: lc_mod_name,

Line 6263: Fnd_Log.G_Current_Runtime_Level)

6259: END IF;
6260: IF (p_MLE_lines_tbl(i).txn_billing_type_id IS NULL)
6261: THEN
6262: IF (Fnd_Log.Level_Statement >=
6263: Fnd_Log.G_Current_Runtime_Level)
6264: THEN
6265: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6266: lc_mod_name,
6267: 'Adding message CSD_EST_NO_ITEM_SAR to FND_MSG stack');

Line 6265: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6261: THEN
6262: IF (Fnd_Log.Level_Statement >=
6263: Fnd_Log.G_Current_Runtime_Level)
6264: THEN
6265: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6266: lc_mod_name,
6267: 'Adding message CSD_EST_NO_ITEM_SAR to FND_MSG stack');
6268: END IF;
6269: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NO_ITEM_SAR');

Line 6273: IF (Fnd_Log.Level_Statement >=

6269: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NO_ITEM_SAR');
6270: Fnd_Message.SET_TOKEN('ITEM', p_MLE_lines_tbl(i).item_name);
6271: Fnd_Msg_Pub.ADD;
6272: l_error := TRUE;
6273: IF (Fnd_Log.Level_Statement >=
6274: Fnd_Log.G_Current_Runtime_Level)
6275: THEN
6276: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6277: lc_mod_name,

Line 6274: Fnd_Log.G_Current_Runtime_Level)

6270: Fnd_Message.SET_TOKEN('ITEM', p_MLE_lines_tbl(i).item_name);
6271: Fnd_Msg_Pub.ADD;
6272: l_error := TRUE;
6273: IF (Fnd_Log.Level_Statement >=
6274: Fnd_Log.G_Current_Runtime_Level)
6275: THEN
6276: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6277: lc_mod_name,
6278: 'Error - txn_billing_type_id is null');

Line 6276: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6272: l_error := TRUE;
6273: IF (Fnd_Log.Level_Statement >=
6274: Fnd_Log.G_Current_Runtime_Level)
6275: THEN
6276: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6277: lc_mod_name,
6278: 'Error - txn_billing_type_id is null');
6279: ELSE
6280: IF (Fnd_Log.Level_Procedure >=

Line 6280: IF (Fnd_Log.Level_Procedure >=

6276: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6277: lc_mod_name,
6278: 'Error - txn_billing_type_id is null');
6279: ELSE
6280: IF (Fnd_Log.Level_Procedure >=
6281: Fnd_Log.G_Current_Runtime_Level)
6282: THEN
6283: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6284: lc_mod_name,

Line 6281: Fnd_Log.G_Current_Runtime_Level)

6277: lc_mod_name,
6278: 'Error - txn_billing_type_id is null');
6279: ELSE
6280: IF (Fnd_Log.Level_Procedure >=
6281: Fnd_Log.G_Current_Runtime_Level)
6282: THEN
6283: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6284: lc_mod_name,
6285: 'Txn billing type id is available');

Line 6283: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

6279: ELSE
6280: IF (Fnd_Log.Level_Procedure >=
6281: Fnd_Log.G_Current_Runtime_Level)
6282: THEN
6283: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6284: lc_mod_name,
6285: 'Txn billing type id is available');
6286: END IF;
6287: END IF;

Line 6297: IF (Fnd_Log.Level_Procedure >=

6293: l_curRow := x_est_lines_tbl.COUNT + 1;
6294:
6295: -- default no_charge if it is set up in charges
6296: -- this is probably a rare case
6297: IF (Fnd_Log.Level_Procedure >=
6298: Fnd_Log.G_Current_Runtime_Level)
6299: THEN
6300: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6301: lc_mod_name,

Line 6298: Fnd_Log.G_Current_Runtime_Level)

6294:
6295: -- default no_charge if it is set up in charges
6296: -- this is probably a rare case
6297: IF (Fnd_Log.Level_Procedure >=
6298: Fnd_Log.G_Current_Runtime_Level)
6299: THEN
6300: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6301: lc_mod_name,
6302: 'Getting no charge flag to determine extended price');

Line 6300: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

6296: -- this is probably a rare case
6297: IF (Fnd_Log.Level_Procedure >=
6298: Fnd_Log.G_Current_Runtime_Level)
6299: THEN
6300: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6301: lc_mod_name,
6302: 'Getting no charge flag to determine extended price');
6303: END IF;
6304: l_no_charge_flag := Csd_Process_Util.Get_No_Chg_Flag(p_MLE_lines_tbl(i)

Line 6315: IF (Fnd_Log.Level_Statement >=

6311: -- bugfix 3468680 vkjain. Using the price from the Pricing Engine API.
6312: l_ext_price := NVL(p_MLE_lines_tbl(i).quantity, 0) *
6313: l_selling_price;
6314: END IF;
6315: IF (Fnd_Log.Level_Statement >=
6316: Fnd_Log.G_Current_Runtime_Level)
6317: THEN
6318: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6319: lc_mod_name,

Line 6316: Fnd_Log.G_Current_Runtime_Level)

6312: l_ext_price := NVL(p_MLE_lines_tbl(i).quantity, 0) *
6313: l_selling_price;
6314: END IF;
6315: IF (Fnd_Log.Level_Statement >=
6316: Fnd_Log.G_Current_Runtime_Level)
6317: THEN
6318: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6319: lc_mod_name,
6320: 'l_no_charge_flag = ' ||

Line 6318: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6314: END IF;
6315: IF (Fnd_Log.Level_Statement >=
6316: Fnd_Log.G_Current_Runtime_Level)
6317: THEN
6318: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6319: lc_mod_name,
6320: 'l_no_charge_flag = ' ||
6321: l_no_charge_flag);
6322: Fnd_Log.STRING(Fnd_Log.Level_Statement,

Line 6322: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6318: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6319: lc_mod_name,
6320: 'l_no_charge_flag = ' ||
6321: l_no_charge_flag);
6322: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6323: lc_mod_name,
6324: 'l_ext_price = ' || l_ext_price);
6325: END IF;
6326:

Line 6338: IF (Fnd_Log.Level_Procedure >=

6334: (p_business_process_id IS NOT NULL) AND
6335: (NVL(l_no_charge_flag, 'N') = 'N')
6336: THEN
6337: BEGIN
6338: IF (Fnd_Log.Level_Procedure >=
6339: Fnd_Log.G_Current_Runtime_Level)
6340: THEN
6341: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6342: lc_mod_name,

Line 6339: Fnd_Log.G_Current_Runtime_Level)

6335: (NVL(l_no_charge_flag, 'N') = 'N')
6336: THEN
6337: BEGIN
6338: IF (Fnd_Log.Level_Procedure >=
6339: Fnd_Log.G_Current_Runtime_Level)
6340: THEN
6341: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6342: lc_mod_name,
6343: 'Calling CSD_CHARGE_LINE_UTIL.Get_CoverageInfo');

Line 6341: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

6337: BEGIN
6338: IF (Fnd_Log.Level_Procedure >=
6339: Fnd_Log.G_Current_Runtime_Level)
6340: THEN
6341: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6342: lc_mod_name,
6343: 'Calling CSD_CHARGE_LINE_UTIL.Get_CoverageInfo');
6344: END IF;
6345: Csd_Charge_Line_Util.Get_CoverageInfo(p_contract_line_id => p_contract_line_id,

Line 6358: IF (Fnd_Log.Level_Statement >=

6354: x_coverage_id => x_est_lines_tbl(l_curRow)
6355: .coverage_id,
6356: x_coverage_txn_group_id => x_est_lines_tbl(l_curRow)
6357: .coverage_txn_group_id);
6358: IF (Fnd_Log.Level_Statement >=
6359: Fnd_Log.G_Current_Runtime_Level)
6360: THEN
6361: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6362: lc_mod_name,

Line 6359: Fnd_Log.G_Current_Runtime_Level)

6355: .coverage_id,
6356: x_coverage_txn_group_id => x_est_lines_tbl(l_curRow)
6357: .coverage_txn_group_id);
6358: IF (Fnd_Log.Level_Statement >=
6359: Fnd_Log.G_Current_Runtime_Level)
6360: THEN
6361: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6362: lc_mod_name,
6363: 'x_contract_id = ' ||

Line 6361: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6357: .coverage_txn_group_id);
6358: IF (Fnd_Log.Level_Statement >=
6359: Fnd_Log.G_Current_Runtime_Level)
6360: THEN
6361: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6362: lc_mod_name,
6363: 'x_contract_id = ' ||
6364: x_est_lines_tbl(l_curRow)
6365: .contract_id);

Line 6366: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6362: lc_mod_name,
6363: 'x_contract_id = ' ||
6364: x_est_lines_tbl(l_curRow)
6365: .contract_id);
6366: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6367: lc_mod_name,
6368: 'x_contract_number = ' ||
6369: x_est_lines_tbl(l_curRow)
6370: .contract_number);

Line 6371: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6367: lc_mod_name,
6368: 'x_contract_number = ' ||
6369: x_est_lines_tbl(l_curRow)
6370: .contract_number);
6371: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6372: lc_mod_name,
6373: 'x_coverage_id = ' ||
6374: x_est_lines_tbl(l_curRow)
6375: .coverage_id);

Line 6376: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6372: lc_mod_name,
6373: 'x_coverage_id = ' ||
6374: x_est_lines_tbl(l_curRow)
6375: .coverage_id);
6376: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6377: lc_mod_name,
6378: 'x_coverage_txn_group_id = ' ||
6379: x_est_lines_tbl(l_curRow)
6380: .coverage_txn_group_id);

Line 6396: IF (Fnd_Log.Level_Procedure >=

6392: l_error := TRUE;
6393: END IF;
6394:
6395: BEGIN
6396: IF (Fnd_Log.Level_Procedure >=
6397: Fnd_Log.G_Current_Runtime_Level)
6398: THEN
6399: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6400: lc_mod_name,

Line 6397: Fnd_Log.G_Current_Runtime_Level)

6393: END IF;
6394:
6395: BEGIN
6396: IF (Fnd_Log.Level_Procedure >=
6397: Fnd_Log.G_Current_Runtime_Level)
6398: THEN
6399: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6400: lc_mod_name,
6401: 'Calling CSD_CHARGE_LINE_UTIL.get_discountedprice');

Line 6399: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

6395: BEGIN
6396: IF (Fnd_Log.Level_Procedure >=
6397: Fnd_Log.G_Current_Runtime_Level)
6398: THEN
6399: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6400: lc_mod_name,
6401: 'Calling CSD_CHARGE_LINE_UTIL.get_discountedprice');
6402: END IF;
6403: Csd_Charge_Line_Util.GET_DISCOUNTEDPRICE(p_api_version => 1.0,

Line 6418: IF (Fnd_Log.Level_Statement >=

6414: .after_warranty_cost,
6415: x_return_status => l_return_status,
6416: x_msg_count => l_msg_count,
6417: x_msg_data => l_msg_data);
6418: IF (Fnd_Log.Level_Statement >=
6419: Fnd_Log.G_Current_Runtime_Level)
6420: THEN
6421: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6422: lc_mod_name,

Line 6419: Fnd_Log.G_Current_Runtime_Level)

6415: x_return_status => l_return_status,
6416: x_msg_count => l_msg_count,
6417: x_msg_data => l_msg_data);
6418: IF (Fnd_Log.Level_Statement >=
6419: Fnd_Log.G_Current_Runtime_Level)
6420: THEN
6421: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6422: lc_mod_name,
6423: 'x_discounted_price = ' ||

Line 6421: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6417: x_msg_data => l_msg_data);
6418: IF (Fnd_Log.Level_Statement >=
6419: Fnd_Log.G_Current_Runtime_Level)
6420: THEN
6421: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6422: lc_mod_name,
6423: 'x_discounted_price = ' ||
6424: x_est_lines_tbl(l_curRow)
6425: .after_warranty_cost);

Line 6435: IF (Fnd_Log.Level_Statement >=

6431: l_return_status := Fnd_Api.G_RET_STS_ERROR;
6432: END;
6433: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS)
6434: THEN
6435: IF (Fnd_Log.Level_Statement >=
6436: Fnd_Log.G_Current_Runtime_Level)
6437: THEN
6438: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6439: lc_mod_name,

Line 6436: Fnd_Log.G_Current_Runtime_Level)

6432: END;
6433: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS)
6434: THEN
6435: IF (Fnd_Log.Level_Statement >=
6436: Fnd_Log.G_Current_Runtime_Level)
6437: THEN
6438: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6439: lc_mod_name,
6440: 'Adding message CSD_EST_ESTIMATED_CHARGE_ERR to FND_MSG stack');

Line 6438: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6434: THEN
6435: IF (Fnd_Log.Level_Statement >=
6436: Fnd_Log.G_Current_Runtime_Level)
6437: THEN
6438: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6439: lc_mod_name,
6440: 'Adding message CSD_EST_ESTIMATED_CHARGE_ERR to FND_MSG stack');
6441: END IF;
6442: Fnd_Message.SET_NAME('CSD',

Line 6467: IF (Fnd_Log.Level_Procedure >=

6463: x_est_lines_tbl(l_curRow).resource_id := p_MLE_lines_tbl(i)
6464: .resource_id;
6465:
6466: BEGIN
6467: IF (Fnd_Log.Level_Procedure >=
6468: Fnd_Log.G_Current_Runtime_Level)
6469: THEN
6470: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6471: lc_mod_name,

Line 6468: Fnd_Log.G_Current_Runtime_Level)

6464: .resource_id;
6465:
6466: BEGIN
6467: IF (Fnd_Log.Level_Procedure >=
6468: Fnd_Log.G_Current_Runtime_Level)
6469: THEN
6470: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6471: lc_mod_name,
6472: 'Calling CSD_COST_ANALYSIS_PVT.arcs in forms/US/CSDREPLN.fmb

Line 6470: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

6466: BEGIN
6467: IF (Fnd_Log.Level_Procedure >=
6468: Fnd_Log.G_Current_Runtime_Level)
6469: THEN
6470: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6471: lc_mod_name,
6472: 'Calling CSD_COST_ANALYSIS_PVT.arcs in forms/US/CSDREPLN.fmb
6473: ItemCost');
6474: END IF;

Line 6501: IF (Fnd_Log.Level_Statement >=

6497: p_currency_code => p_currency_code,
6498: p_chg_line_uom_code => p_MLE_lines_tbl(i).uom, --sangigup 3356020
6499: x_item_cost => x_est_lines_tbl(l_curRow)
6500: .item_cost);
6501: IF (Fnd_Log.Level_Statement >=
6502: Fnd_Log.G_Current_Runtime_Level)
6503: THEN
6504: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6505: lc_mod_name,

Line 6502: Fnd_Log.G_Current_Runtime_Level)

6498: p_chg_line_uom_code => p_MLE_lines_tbl(i).uom, --sangigup 3356020
6499: x_item_cost => x_est_lines_tbl(l_curRow)
6500: .item_cost);
6501: IF (Fnd_Log.Level_Statement >=
6502: Fnd_Log.G_Current_Runtime_Level)
6503: THEN
6504: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6505: lc_mod_name,
6506: 'x_item_cost = ' ||

Line 6504: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6500: .item_cost);
6501: IF (Fnd_Log.Level_Statement >=
6502: Fnd_Log.G_Current_Runtime_Level)
6503: THEN
6504: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6505: lc_mod_name,
6506: 'x_item_cost = ' ||
6507: x_est_lines_tbl(l_curRow).item_cost);
6508: END IF;

Line 6523: -- if (Fnd_Log.Level_Statement>= Fnd_Log.G_Current_Runtime_Level) then

6519: --
6520: -- TO DO: give warning message that cost could not be determined?
6521: -- x_warning_flag := FND_API.G_TRUE;
6522: -- x_return_status := FND_API.G_RET_STS_ERROR;
6523: -- if (Fnd_Log.Level_Statement>= Fnd_Log.G_Current_Runtime_Level) then
6524: -- FND_LOG.STRING(Fnd_Log.Level_Statement, lc_mod_name,
6525: -- 'Adding message CSD_EST_ESTIMATED_CHARGE_ERR to FND_MSG stack');
6526: -- end if;
6527: -- FND_MESSAGE.SET_NAME('CSD','CSD_EST_ESTIMATED_CHARGE_ERR');

Line 6524: -- FND_LOG.STRING(Fnd_Log.Level_Statement, lc_mod_name,

6520: -- TO DO: give warning message that cost could not be determined?
6521: -- x_warning_flag := FND_API.G_TRUE;
6522: -- x_return_status := FND_API.G_RET_STS_ERROR;
6523: -- if (Fnd_Log.Level_Statement>= Fnd_Log.G_Current_Runtime_Level) then
6524: -- FND_LOG.STRING(Fnd_Log.Level_Statement, lc_mod_name,
6525: -- 'Adding message CSD_EST_ESTIMATED_CHARGE_ERR to FND_MSG stack');
6526: -- end if;
6527: -- FND_MESSAGE.SET_NAME('CSD','CSD_EST_ESTIMATED_CHARGE_ERR');
6528: -- FND_MESSAGE.SET_TOKEN('CONTRACT_NUMBER',x_est_lines_tbl(l_curRow).contract_number);

Line 6534: IF (Fnd_Log.Level_Procedure >=

6530: -- l_error := TRUE;
6531: END IF;
6532:
6533: -- set transaction type (Material, labor, expense)
6534: IF (Fnd_Log.Level_Procedure >=
6535: Fnd_Log.G_Current_Runtime_Level)
6536: THEN
6537: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6538: lc_mod_name,

Line 6535: Fnd_Log.G_Current_Runtime_Level)

6531: END IF;
6532:
6533: -- set transaction type (Material, labor, expense)
6534: IF (Fnd_Log.Level_Procedure >=
6535: Fnd_Log.G_Current_Runtime_Level)
6536: THEN
6537: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6538: lc_mod_name,
6539: 'Getting transaction type id');

Line 6537: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

6533: -- set transaction type (Material, labor, expense)
6534: IF (Fnd_Log.Level_Procedure >=
6535: Fnd_Log.G_Current_Runtime_Level)
6536: THEN
6537: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6538: lc_mod_name,
6539: 'Getting transaction type id');
6540: END IF;
6541: OPEN c_transaction_type(p_MLE_lines_tbl(i)

Line 6624: IF (Fnd_Log.Level_Procedure >=

6620: -- since the above section could potentially set l_error=TRUE as well.
6621: IF (l_error = TRUE)
6622: THEN
6623: x_warning_flag := Fnd_Api.G_TRUE;
6624: IF (Fnd_Log.Level_Procedure >=
6625: Fnd_Log.G_Current_Runtime_Level)
6626: THEN
6627: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6628: lc_mod_name,

Line 6625: Fnd_Log.G_Current_Runtime_Level)

6621: IF (l_error = TRUE)
6622: THEN
6623: x_warning_flag := Fnd_Api.G_TRUE;
6624: IF (Fnd_Log.Level_Procedure >=
6625: Fnd_Log.G_Current_Runtime_Level)
6626: THEN
6627: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6628: lc_mod_name,
6629: 'Calling CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');

Line 6627: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

6623: x_warning_flag := Fnd_Api.G_TRUE;
6624: IF (Fnd_Log.Level_Procedure >=
6625: Fnd_Log.G_Current_Runtime_Level)
6626: THEN
6627: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6628: lc_mod_name,
6629: 'Calling CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
6630: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6631: lc_mod_name,

Line 6630: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

6626: THEN
6627: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6628: lc_mod_name,
6629: 'Calling CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
6630: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6631: lc_mod_name,
6632: 'Number of messages in stack: ' ||
6633: Fnd_Msg_Pub.count_msg);
6634: END IF;

Line 6652: IF (Fnd_Log.Level_Procedure >=

6648: IF NOT (l_return_status = Fnd_Api.G_RET_STS_SUCCESS)
6649: THEN
6650: RAISE Fnd_Api.G_EXC_ERROR;
6651: END IF;
6652: IF (Fnd_Log.Level_Procedure >=
6653: Fnd_Log.G_Current_Runtime_Level)
6654: THEN
6655: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6656: lc_mod_name,

Line 6653: Fnd_Log.G_Current_Runtime_Level)

6649: THEN
6650: RAISE Fnd_Api.G_EXC_ERROR;
6651: END IF;
6652: IF (Fnd_Log.Level_Procedure >=
6653: Fnd_Log.G_Current_Runtime_Level)
6654: THEN
6655: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6656: lc_mod_name,
6657: 'Returned from CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');

Line 6655: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

6651: END IF;
6652: IF (Fnd_Log.Level_Procedure >=
6653: Fnd_Log.G_Current_Runtime_Level)
6654: THEN
6655: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6656: lc_mod_name,
6657: 'Returned from CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
6658: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6659: lc_mod_name,

Line 6658: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

6654: THEN
6655: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6656: lc_mod_name,
6657: 'Returned from CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
6658: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6659: lc_mod_name,
6660: 'Number of messages in stack: ' ||
6661: Fnd_Msg_Pub.count_msg);
6662: END IF;

Line 6666: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)

6662: END IF;
6663: END IF;
6664: END LOOP;
6665:
6666: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
6667: THEN
6668: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6669: lc_mod_name || '.out_parameter',
6670: 'x_warning_flag: ' || x_warning_flag);

Line 6668: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6664: END LOOP;
6665:
6666: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
6667: THEN
6668: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6669: lc_mod_name || '.out_parameter',
6670: 'x_warning_flag: ' || x_warning_flag);
6671: END IF;
6672: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

Line 6672: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

6668: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6669: lc_mod_name || '.out_parameter',
6670: 'x_warning_flag: ' || x_warning_flag);
6671: END IF;
6672: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
6673: THEN
6674: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6675: lc_mod_name || '.END',
6676: 'Leaving CSD_REPAIR_ESTIMATE_PVT.Convert_To_Est_Lines');

Line 6674: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

6670: 'x_warning_flag: ' || x_warning_flag);
6671: END IF;
6672: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
6673: THEN
6674: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6675: lc_mod_name || '.END',
6676: 'Leaving CSD_REPAIR_ESTIMATE_PVT.Convert_To_Est_Lines');
6677: END IF;
6678:

Line 6700: if (Fnd_Log.Level_Statement>= Fnd_Log.G_Current_Runtime_Level) then

6696:
6697: /*
6698: -- TO DO: Add seeded err message
6699: -- save message in fnd stack
6700: if (Fnd_Log.Level_Statement>= Fnd_Log.G_Current_Runtime_Level) then
6701: FND_LOG.STRING(Fnd_Log.Level_Statement, lc_mod_name,
6702: 'Adding message err_name to FND_MSG stack');
6703: end if;
6704: FND_MESSAGE.SET_NAME('CSD','err_name');

Line 6701: FND_LOG.STRING(Fnd_Log.Level_Statement, lc_mod_name,

6697: /*
6698: -- TO DO: Add seeded err message
6699: -- save message in fnd stack
6700: if (Fnd_Log.Level_Statement>= Fnd_Log.G_Current_Runtime_Level) then
6701: FND_LOG.STRING(Fnd_Log.Level_Statement, lc_mod_name,
6702: 'Adding message err_name to FND_MSG stack');
6703: end if;
6704: FND_MESSAGE.SET_NAME('CSD','err_name');
6705: FND_MESSAGE.SET_TOKEN('toke_name', 'token_value');

Line 6712: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)

6708: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6709: p_data => x_msg_data);
6710:
6711: -- save message in debug log
6712: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
6713: THEN
6714: Fnd_Log.STRING(Fnd_Log.Level_Exception,
6715: lc_mod_name,
6716: 'EXC_ERROR[' || x_msg_data || ']');

Line 6714: Fnd_Log.STRING(Fnd_Log.Level_Exception,

6710:
6711: -- save message in debug log
6712: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
6713: THEN
6714: Fnd_Log.STRING(Fnd_Log.Level_Exception,
6715: lc_mod_name,
6716: 'EXC_ERROR[' || x_msg_data || ']');
6717: END IF;
6718: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 6725: IF (Fnd_Log.Level_Statement >=

6721:
6722: -- save message in fnd stack
6723: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
6724: THEN
6725: IF (Fnd_Log.Level_Statement >=
6726: Fnd_Log.G_Current_Runtime_Level)
6727: THEN
6728: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6729: lc_mod_name,

Line 6726: Fnd_Log.G_Current_Runtime_Level)

6722: -- save message in fnd stack
6723: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
6724: THEN
6725: IF (Fnd_Log.Level_Statement >=
6726: Fnd_Log.G_Current_Runtime_Level)
6727: THEN
6728: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6729: lc_mod_name,
6730: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 6728: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6724: THEN
6725: IF (Fnd_Log.Level_Statement >=
6726: Fnd_Log.G_Current_Runtime_Level)
6727: THEN
6728: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6729: lc_mod_name,
6730: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
6731: END IF;
6732: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);

Line 6738: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)

6734: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6735: p_data => x_msg_data);
6736:
6737: -- save message in debug log
6738: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
6739: THEN
6740: Fnd_Log.STRING(Fnd_Log.Level_Exception,
6741: lc_mod_name,
6742: 'EXC_UNEXPECTED_ERROR[' || x_msg_data || ']');

Line 6740: Fnd_Log.STRING(Fnd_Log.Level_Exception,

6736:
6737: -- save message in debug log
6738: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
6739: THEN
6740: Fnd_Log.STRING(Fnd_Log.Level_Exception,
6741: lc_mod_name,
6742: 'EXC_UNEXPECTED_ERROR[' || x_msg_data || ']');
6743: END IF;
6744: WHEN OTHERS THEN

Line 6751: IF (Fnd_Log.Level_Statement >=

6747:
6748: -- save message in fnd stack
6749: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
6750: THEN
6751: IF (Fnd_Log.Level_Statement >=
6752: Fnd_Log.G_Current_Runtime_Level)
6753: THEN
6754: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6755: lc_mod_name,

Line 6752: Fnd_Log.G_Current_Runtime_Level)

6748: -- save message in fnd stack
6749: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
6750: THEN
6751: IF (Fnd_Log.Level_Statement >=
6752: Fnd_Log.G_Current_Runtime_Level)
6753: THEN
6754: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6755: lc_mod_name,
6756: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 6754: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6750: THEN
6751: IF (Fnd_Log.Level_Statement >=
6752: Fnd_Log.G_Current_Runtime_Level)
6753: THEN
6754: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6755: lc_mod_name,
6756: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
6757: END IF;
6758: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);

Line 6764: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)

6760: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6761: p_data => x_msg_data);
6762:
6763: -- save message in debug log
6764: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
6765: THEN
6766: -- create a seeded message
6767: Fnd_Log.STRING(Fnd_Log.Level_Exception,
6768: lc_mod_name,

Line 6767: Fnd_Log.STRING(Fnd_Log.Level_Exception,

6763: -- save message in debug log
6764: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
6765: THEN
6766: -- create a seeded message
6767: Fnd_Log.STRING(Fnd_Log.Level_Exception,
6768: lc_mod_name,
6769: 'SQL Message[' || SQLERRM || ']');
6770: END IF;
6771: END Convert_To_Est_Lines;

Line 6816: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level)

6812: l_estimate_hdr_rec Csd_Repair_Estimate_Pub.ESTIMATE_HDR_REC;
6813: l_est_hdr_pvt_rec Csd_Repair_Estimate_Pvt.REPAIR_ESTIMATE_REC;
6814: BEGIN
6815:
6816: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level)
6817: THEN
6818: Fnd_Log.STRING(Fnd_Log.level_procedure,
6819: 'csd.plsql.csd_repair_Estimate_pvt.create_estimate_header.begin',
6820: 'Entering create_estimate_header');

Line 6818: Fnd_Log.STRING(Fnd_Log.level_procedure,

6814: BEGIN
6815:
6816: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level)
6817: THEN
6818: Fnd_Log.STRING(Fnd_Log.level_procedure,
6819: 'csd.plsql.csd_repair_Estimate_pvt.create_estimate_header.begin',
6820: 'Entering create_estimate_header');
6821: END IF;
6822: -- Standard Start of API savepoint

Line 6931: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level)

6927: THEN
6928: COMMIT WORK;
6929: END IF;
6930:
6931: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level)
6932: THEN
6933: Fnd_Log.STRING(Fnd_Log.level_procedure,
6934: 'csd.plsql.csd_repair_Estimate_pvt.create_estimate_header.end',
6935: 'Leaving create_estimate_header');

Line 6933: Fnd_Log.STRING(Fnd_Log.level_procedure,

6929: END IF;
6930:
6931: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level)
6932: THEN
6933: Fnd_Log.STRING(Fnd_Log.level_procedure,
6934: 'csd.plsql.csd_repair_Estimate_pvt.create_estimate_header.end',
6935: 'Leaving create_estimate_header');
6936: END IF;
6937:

Line 6947: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)

6943: x_return_status := Fnd_Api.G_RET_STS_ERROR;
6944: ROLLBACK TO create_estimate_header_pvt;
6945: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6946: p_data => x_msg_data);
6947: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
6948: THEN
6949: Fnd_Log.STRING(Fnd_Log.level_error,
6950: 'csd.plsql.csd_repair_estimate_pvt.create_estimate_header',
6951: 'EXC_ERROR[' || x_msg_data || ']');

Line 6949: Fnd_Log.STRING(Fnd_Log.level_error,

6945: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6946: p_data => x_msg_data);
6947: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
6948: THEN
6949: Fnd_Log.STRING(Fnd_Log.level_error,
6950: 'csd.plsql.csd_repair_estimate_pvt.create_estimate_header',
6951: 'EXC_ERROR[' || x_msg_data || ']');
6952: END IF;
6953: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 6958: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)

6954: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6955: ROLLBACK TO create_estimate_header_pvt;
6956: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6957: p_data => x_msg_data);
6958: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
6959: THEN
6960: Fnd_Log.STRING(Fnd_Log.level_exception,
6961: 'csd.plsql.csd_repair_estimate_pvt.create_estimate_header',
6962: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');

Line 6960: Fnd_Log.STRING(Fnd_Log.level_exception,

6956: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6957: p_data => x_msg_data);
6958: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
6959: THEN
6960: Fnd_Log.STRING(Fnd_Log.level_exception,
6961: 'csd.plsql.csd_repair_estimate_pvt.create_estimate_header',
6962: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');
6963: END IF;
6964: WHEN OTHERS THEN

Line 6973: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)

6969: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
6970: END IF;
6971: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6972: p_data => x_msg_data);
6973: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
6974: THEN
6975: Fnd_Log.STRING(Fnd_Log.level_exception,
6976: 'csd.plsql.csd_repair_estimate_pvt.create_estimate_header',
6977: 'SQL MEssage[' || SQLERRM || ']');

Line 6975: Fnd_Log.STRING(Fnd_Log.level_exception,

6971: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6972: p_data => x_msg_data);
6973: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
6974: THEN
6975: Fnd_Log.STRING(Fnd_Log.level_exception,
6976: 'csd.plsql.csd_repair_estimate_pvt.create_estimate_header',
6977: 'SQL MEssage[' || SQLERRM || ']');
6978: END IF;
6979:

Line 7039: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

7035:
7036: debug('Start of estimate line creation for estimate id[=' ||
7037: p_estimate_line_rec.repair_estimate_id || ']');
7038:
7039: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
7040: THEN
7041: fnd_log.STRING(fnd_log.level_procedure,
7042: 'csd.plsql.csd_repair_estimate_pvt.create_estimate_line.begin',
7043: 'Entering create_estimate_line');

Line 7041: fnd_log.STRING(fnd_log.level_procedure,

7037: p_estimate_line_rec.repair_estimate_id || ']');
7038:
7039: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
7040: THEN
7041: fnd_log.STRING(fnd_log.level_procedure,
7042: 'csd.plsql.csd_repair_estimate_pvt.create_estimate_line.begin',
7043: 'Entering create_estimate_line');
7044: END IF;
7045:

Line 7087: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

7083: -- Standard call to get message count and IF count is get message info.
7084: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7085: p_data => x_msg_data);
7086:
7087: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
7088: THEN
7089: fnd_log.STRING(fnd_log.level_procedure,
7090: 'csd.plsql.csd_repair_estimate_pvt.create_estimate_line.end',
7091: 'leaving create_estimate_line');

Line 7089: fnd_log.STRING(fnd_log.level_procedure,

7085: p_data => x_msg_data);
7086:
7087: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
7088: THEN
7089: fnd_log.STRING(fnd_log.level_procedure,
7090: 'csd.plsql.csd_repair_estimate_pvt.create_estimate_line.end',
7091: 'leaving create_estimate_line');
7092: END IF;
7093: EXCEPTION

Line 7099: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)

7095: x_return_status := Fnd_Api.G_RET_STS_ERROR;
7096: ROLLBACK TO CREATE_ESTIMATE_LINE_PVT;
7097: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7098: p_data => x_msg_data);
7099: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
7100: THEN
7101: Fnd_Log.STRING(Fnd_Log.level_error,
7102: 'csd.plsql.csd_repair_estimate_pvt.create_estimate_line',
7103: 'EXC_ERROR[' || x_msg_data || ']');

Line 7101: Fnd_Log.STRING(Fnd_Log.level_error,

7097: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7098: p_data => x_msg_data);
7099: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
7100: THEN
7101: Fnd_Log.STRING(Fnd_Log.level_error,
7102: 'csd.plsql.csd_repair_estimate_pvt.create_estimate_line',
7103: 'EXC_ERROR[' || x_msg_data || ']');
7104: END IF;
7105:

Line 7111: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)

7107: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
7108: ROLLBACK TO CREATE_ESTIMATE_LINE_PVT;
7109: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7110: p_data => x_msg_data);
7111: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
7112: THEN
7113: Fnd_Log.STRING(Fnd_Log.level_exception,
7114: 'csd.plsql.csd_repair_estimate_pvt.create_estimate_line',
7115: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');

Line 7113: Fnd_Log.STRING(Fnd_Log.level_exception,

7109: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7110: p_data => x_msg_data);
7111: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
7112: THEN
7113: Fnd_Log.STRING(Fnd_Log.level_exception,
7114: 'csd.plsql.csd_repair_estimate_pvt.create_estimate_line',
7115: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');
7116: END IF;
7117: WHEN OTHERS THEN

Line 7126: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)

7122: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7123: END IF;
7124: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7125: p_data => x_msg_data);
7126: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
7127: THEN
7128: Fnd_Log.STRING(Fnd_Log.level_exception,
7129: 'csd.plsql.csd_repair_estimate_pvt.create_estimate_line',
7130: 'SQL MEssage[' || SQLERRM || ']');

Line 7128: Fnd_Log.STRING(Fnd_Log.level_exception,

7124: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7125: p_data => x_msg_data);
7126: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
7127: THEN
7128: Fnd_Log.STRING(Fnd_Log.level_exception,
7129: 'csd.plsql.csd_repair_estimate_pvt.create_estimate_line',
7130: 'SQL MEssage[' || SQLERRM || ']');
7131: END IF;
7132:

Line 7225: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

7221:
7222: debug('Start of update estimate header for estimate id[=' ||
7223: p_estimate_hdr_rec.repair_estimate_id || ']');
7224:
7225: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
7226: THEN
7227: fnd_log.STRING(fnd_log.level_procedure,
7228: 'csd.plsql.csd_repair_estimate_pvt.update_estimate_header.begin',
7229: 'Entering update_estimate_header');

Line 7227: fnd_log.STRING(fnd_log.level_procedure,

7223: p_estimate_hdr_rec.repair_estimate_id || ']');
7224:
7225: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
7226: THEN
7227: fnd_log.STRING(fnd_log.level_procedure,
7228: 'csd.plsql.csd_repair_estimate_pvt.update_estimate_header.begin',
7229: 'Entering update_estimate_header');
7230: END IF;
7231:

Line 7361: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

7357: -- Standard call to get message count and IF count is get message info.
7358: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7359: p_data => x_msg_data);
7360:
7361: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
7362: THEN
7363: fnd_log.STRING(fnd_log.level_procedure,
7364: 'csd.plsql.csd_repair_estimate_pvt.update_estimate_header.end',
7365: 'leaving update_estimate_header');

Line 7363: fnd_log.STRING(fnd_log.level_procedure,

7359: p_data => x_msg_data);
7360:
7361: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
7362: THEN
7363: fnd_log.STRING(fnd_log.level_procedure,
7364: 'csd.plsql.csd_repair_estimate_pvt.update_estimate_header.end',
7365: 'leaving update_estimate_header');
7366: END IF;
7367: EXCEPTION

Line 7373: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)

7369: x_return_status := Fnd_Api.G_RET_STS_ERROR;
7370: ROLLBACK TO UPDATE_ESTIMATE_HEADER_PVT;
7371: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7372: p_data => x_msg_data);
7373: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
7374: THEN
7375: Fnd_Log.STRING(Fnd_Log.level_error,
7376: 'csd.plsql.csd_repair_estimate_pvt.update_estimate_header',
7377: 'EXC_ERROR[' || x_msg_data || ']');

Line 7375: Fnd_Log.STRING(Fnd_Log.level_error,

7371: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7372: p_data => x_msg_data);
7373: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
7374: THEN
7375: Fnd_Log.STRING(Fnd_Log.level_error,
7376: 'csd.plsql.csd_repair_estimate_pvt.update_estimate_header',
7377: 'EXC_ERROR[' || x_msg_data || ']');
7378: END IF;
7379:

Line 7385: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)

7381: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
7382: ROLLBACK TO UPDATE_ESTIMATE_HEADER_PVT;
7383: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7384: p_data => x_msg_data);
7385: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
7386: THEN
7387: Fnd_Log.STRING(Fnd_Log.level_exception,
7388: 'csd.plsql.csd_repair_estimate_pvt.update_estimate_header',
7389: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');

Line 7387: Fnd_Log.STRING(Fnd_Log.level_exception,

7383: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7384: p_data => x_msg_data);
7385: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
7386: THEN
7387: Fnd_Log.STRING(Fnd_Log.level_exception,
7388: 'csd.plsql.csd_repair_estimate_pvt.update_estimate_header',
7389: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');
7390: END IF;
7391: WHEN OTHERS THEN

Line 7400: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)

7396: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7397: END IF;
7398: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7399: p_data => x_msg_data);
7400: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
7401: THEN
7402: Fnd_Log.STRING(Fnd_Log.level_exception,
7403: 'csd.plsql.csd_repair_estimate_pvt.update_estimate_header',
7404: 'SQL MEssage[' || SQLERRM || ']');

Line 7402: Fnd_Log.STRING(Fnd_Log.level_exception,

7398: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7399: p_data => x_msg_data);
7400: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
7401: THEN
7402: Fnd_Log.STRING(Fnd_Log.level_exception,
7403: 'csd.plsql.csd_repair_estimate_pvt.update_estimate_header',
7404: 'SQL MEssage[' || SQLERRM || ']');
7405: END IF;
7406: