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 3103: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;

3099:
3100: PROCEDURE get_total_estimated_charge(p_repair_line_id IN NUMBER,
3101: x_estimated_charge OUT NOCOPY NUMBER,
3102: x_return_status OUT NOCOPY VARCHAR2) IS
3103: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
3104: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
3105: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3106: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
3107: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;

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

3100: PROCEDURE get_total_estimated_charge(p_repair_line_id IN NUMBER,
3101: x_estimated_charge OUT NOCOPY NUMBER,
3102: x_return_status OUT NOCOPY VARCHAR2) IS
3103: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
3104: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
3105: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3106: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
3107: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
3108: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;

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

3101: x_estimated_charge OUT NOCOPY NUMBER,
3102: x_return_status OUT NOCOPY VARCHAR2) IS
3103: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
3104: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
3105: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3106: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
3107: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
3108: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
3109: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;

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

3102: x_return_status OUT NOCOPY VARCHAR2) IS
3103: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
3104: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
3105: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3106: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
3107: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
3108: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
3109: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
3110: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.get_total_estimated_charge';

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

3103: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
3104: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
3105: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3106: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
3107: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
3108: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
3109: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
3110: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.get_total_estimated_charge';
3111: BEGIN

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

3104: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
3105: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3106: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
3107: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
3108: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
3109: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
3110: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.get_total_estimated_charge';
3111: BEGIN
3112: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

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

3105: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3106: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
3107: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
3108: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
3109: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
3110: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.get_total_estimated_charge';
3111: BEGIN
3112: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3113: THEN

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

3108: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
3109: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
3110: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.get_total_estimated_charge';
3111: BEGIN
3112: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3113: THEN
3114: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3115: lc_mod_name || '.BEGIN',
3116: 'Entered get_total_estimated_charge');

Line 3114: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3110: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.get_total_estimated_charge';
3111: BEGIN
3112: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3113: THEN
3114: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3115: lc_mod_name || '.BEGIN',
3116: 'Entered get_total_estimated_charge');
3117: END IF;
3118:

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

3123: FROM csd_repair_estimate_lines_v
3124: WHERE repair_line_id = p_repair_line_id
3125: AND billing_type IN ('M', 'L', 'E');
3126:
3127: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
3128: THEN
3129: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3130: lc_mod_name || 'out_parameter',
3131: 'x_estimated_charge: ' || x_estimated_charge);

Line 3129: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3125: AND billing_type IN ('M', 'L', 'E');
3126:
3127: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
3128: THEN
3129: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3130: lc_mod_name || 'out_parameter',
3131: 'x_estimated_charge: ' || x_estimated_charge);
3132: END IF;
3133: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

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

3129: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3130: lc_mod_name || 'out_parameter',
3131: 'x_estimated_charge: ' || x_estimated_charge);
3132: END IF;
3133: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3134: THEN
3135: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3136: lc_mod_name || '.END',
3137: 'Leaving get_total_estimated_charge');

Line 3135: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3131: 'x_estimated_charge: ' || x_estimated_charge);
3132: END IF;
3133: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3134: THEN
3135: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3136: lc_mod_name || '.END',
3137: 'Leaving get_total_estimated_charge');
3138: END IF;
3139: EXCEPTION

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

3179: p_inventory_item_id IN NUMBER, -- required
3180: p_organization_id IN NUMBER, -- required
3181: x_warning_flag OUT NOCOPY VARCHAR2) IS
3182: -- CONSTANTS --
3183: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
3184: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
3185: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3186: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
3187: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;

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

3180: p_organization_id IN NUMBER, -- required
3181: x_warning_flag OUT NOCOPY VARCHAR2) IS
3182: -- CONSTANTS --
3183: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
3184: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
3185: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3186: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
3187: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
3188: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;

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

3181: x_warning_flag OUT NOCOPY VARCHAR2) IS
3182: -- CONSTANTS --
3183: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
3184: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
3185: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3186: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
3187: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
3188: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
3189: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;

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

3182: -- CONSTANTS --
3183: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
3184: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
3185: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3186: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
3187: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
3188: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
3189: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
3190: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.autocreate_estimate_lines';

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

3183: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
3184: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
3185: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3186: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
3187: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
3188: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
3189: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
3190: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.autocreate_estimate_lines';
3191: lc_api_name CONSTANT VARCHAR2(30) := 'Autocreate_Estimate_Lines';

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

3184: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
3185: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3186: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
3187: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
3188: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
3189: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
3190: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.autocreate_estimate_lines';
3191: lc_api_name CONSTANT VARCHAR2(30) := 'Autocreate_Estimate_Lines';
3192: lc_api_version CONSTANT NUMBER := 1.0;

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

3185: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
3186: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
3187: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
3188: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
3189: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
3190: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.autocreate_estimate_lines';
3191: lc_api_name CONSTANT VARCHAR2(30) := 'Autocreate_Estimate_Lines';
3192: lc_api_version CONSTANT NUMBER := 1.0;
3193:

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

3247: THEN
3248: Fnd_Msg_Pub.initialize;
3249: END IF;
3250:
3251: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3252: THEN
3253: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3254: lc_mod_name || '.BEGIN',
3255: 'Entered Autocreate_Estimate_Lines');

Line 3253: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3249: END IF;
3250:
3251: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3252: THEN
3253: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3254: lc_mod_name || '.BEGIN',
3255: 'Entered Autocreate_Estimate_Lines');
3256: END IF;
3257:

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

3255: 'Entered Autocreate_Estimate_Lines');
3256: END IF;
3257:
3258: -- log parameters
3259: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
3260: THEN
3261: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3262: lc_mod_name || '.parameter_logging',
3263: 'p_api_version: ' || p_api_version);

Line 3261: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3257:
3258: -- log parameters
3259: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
3260: THEN
3261: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3262: lc_mod_name || '.parameter_logging',
3263: 'p_api_version: ' || p_api_version);
3264: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3265: lc_mod_name || '.parameter_logging',

Line 3264: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3260: THEN
3261: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3262: lc_mod_name || '.parameter_logging',
3263: 'p_api_version: ' || p_api_version);
3264: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3265: lc_mod_name || '.parameter_logging',
3266: 'p_commit: ' || p_commit);
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_api_version: ' || p_api_version);
3264: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3265: lc_mod_name || '.parameter_logging',
3266: 'p_commit: ' || p_commit);
3267: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3268: lc_mod_name || '.parameter_logging',
3269: 'p_init_msg_list: ' || p_init_msg_list);
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_commit: ' || p_commit);
3267: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3268: lc_mod_name || '.parameter_logging',
3269: 'p_init_msg_list: ' || p_init_msg_list);
3270: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3271: lc_mod_name || '.parameter_logging',
3272: 'p_validation_level: ' || p_validation_level);
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_init_msg_list: ' || p_init_msg_list);
3270: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3271: lc_mod_name || '.parameter_logging',
3272: 'p_validation_level: ' || p_validation_level);
3273: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3274: lc_mod_name || '.parameter_logging',
3275: 'p_repair_line_id: ' || p_repair_line_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_validation_level: ' || p_validation_level);
3273: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3274: lc_mod_name || '.parameter_logging',
3275: 'p_repair_line_id: ' || p_repair_line_id);
3276: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3277: lc_mod_name || '.parameter_logging',
3278: 'p_estimate_id: ' || p_estimate_id);
3279: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3280: lc_mod_name || '.parameter_logging',

Line 3279: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3275: 'p_repair_line_id: ' || p_repair_line_id);
3276: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3277: lc_mod_name || '.parameter_logging',
3278: 'p_estimate_id: ' || p_estimate_id);
3279: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3280: lc_mod_name || '.parameter_logging',
3281: 'p_repair_type_id: ' || p_repair_type_id);
3282: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3283: lc_mod_name || '.parameter_logging',

Line 3282: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3278: 'p_estimate_id: ' || p_estimate_id);
3279: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3280: lc_mod_name || '.parameter_logging',
3281: 'p_repair_type_id: ' || p_repair_type_id);
3282: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3283: lc_mod_name || '.parameter_logging',
3284: 'p_business_process_id: ' ||
3285: p_business_process_id);
3286: Fnd_Log.STRING(Fnd_Log.Level_Statement,

Line 3286: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3282: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3283: lc_mod_name || '.parameter_logging',
3284: 'p_business_process_id: ' ||
3285: p_business_process_id);
3286: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3287: lc_mod_name || '.parameter_logging',
3288: 'p_currency_code: ' || p_currency_code);
3289: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3290: lc_mod_name || '.parameter_logging',

Line 3289: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3285: p_business_process_id);
3286: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3287: lc_mod_name || '.parameter_logging',
3288: 'p_currency_code: ' || p_currency_code);
3289: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3290: lc_mod_name || '.parameter_logging',
3291: 'p_incident_id: ' || p_incident_id);
3292: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3293: lc_mod_name || '.parameter_logging',

Line 3292: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3288: 'p_currency_code: ' || p_currency_code);
3289: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3290: lc_mod_name || '.parameter_logging',
3291: 'p_incident_id: ' || p_incident_id);
3292: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3293: lc_mod_name || '.parameter_logging',
3294: 'p_repair_mode: ' || p_repair_mode);
3295: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3296: lc_mod_name || '.parameter_logging',

Line 3295: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3291: 'p_incident_id: ' || p_incident_id);
3292: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3293: lc_mod_name || '.parameter_logging',
3294: 'p_repair_mode: ' || p_repair_mode);
3295: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3296: lc_mod_name || '.parameter_logging',
3297: 'p_inventory_item_id: ' || p_inventory_item_id);
3298: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3299: lc_mod_name || '.parameter_logging',

Line 3298: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3294: 'p_repair_mode: ' || p_repair_mode);
3295: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3296: lc_mod_name || '.parameter_logging',
3297: 'p_inventory_item_id: ' || p_inventory_item_id);
3298: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3299: lc_mod_name || '.parameter_logging',
3300: 'p_organization_id: ' || p_organization_id);
3301: END IF;
3302:

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

3310: -- initialize the warning flag
3311: x_warning_flag := Fnd_Api.G_FALSE;
3312:
3313: -- Check the required parameters
3314: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3315: THEN
3316: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3317: lc_mod_name,
3318: 'Checking required parameters');

Line 3316: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3312:
3313: -- Check the required parameters
3314: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3315: THEN
3316: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3317: lc_mod_name,
3318: 'Checking required parameters');
3319: END IF;
3320:

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

3354: p_param_name => 'ORGANIZATION_ID',
3355: p_api_name => lc_api_name);
3356:
3357: -- Check number of service codes to get mle lines for
3358: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3359: THEN
3360: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3361: lc_mod_name,
3362: 'Counting the number of service codes to apply');

Line 3360: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3356:
3357: -- Check number of service codes to get mle lines for
3358: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3359: THEN
3360: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3361: lc_mod_name,
3362: 'Counting the number of service codes to apply');
3363: END IF;
3364: BEGIN

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

3374: WHEN OTHERS THEN
3375: l_num_service_codes := 0;
3376: END;
3377:
3378: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
3379: THEN
3380: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3381: lc_mod_name,
3382: 'l_num_service_codes: ' || l_num_service_codes);

Line 3380: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3376: END;
3377:
3378: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
3379: THEN
3380: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3381: lc_mod_name,
3382: 'l_num_service_codes: ' || l_num_service_codes);
3383: END IF;
3384:

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

3396: END IF;
3397: END IF;
3398:
3399: -- Get default Contract.
3400: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3401: THEN
3402: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3403: lc_mod_name,
3404: 'Calling CSD_CHARGE_LINE_UTIL.Get_DefaultContract');

Line 3402: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3398:
3399: -- Get default Contract.
3400: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3401: THEN
3402: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3403: lc_mod_name,
3404: 'Calling CSD_CHARGE_LINE_UTIL.Get_DefaultContract');
3405: END IF;
3406:

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

3405: END IF;
3406:
3407: l_default_contract_line_id := Csd_Charge_Line_Util.Get_DefaultContract(p_repair_line_id);
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_DefaultContract');
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_DefaultContract');
3415: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3416: lc_mod_name,
3417: 'l_default_contract_line_id = ' ||
3418: l_default_contract_line_id);
3419: -- log the next call

Line 3420: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3416: lc_mod_name,
3417: 'l_default_contract_line_id = ' ||
3418: l_default_contract_line_id);
3419: -- log the next call
3420: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3421: lc_mod_name,
3422: 'calling CSD_CHARGE_LINE_UTIL.Get_RO_PriceList');
3423: END IF;
3424:

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

3427: THEN
3428: RAISE CSD_EST_DEF_PL;
3429: END IF;
3430:
3431: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3432: THEN
3433: -- log results from previous call
3434: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3435: lc_mod_name,

Line 3434: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3430:
3431: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3432: THEN
3433: -- log results from previous call
3434: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3435: lc_mod_name,
3436: 'Returned from CSD_CHARGE_LINE_UTIL.Get_RO_PriceList');
3437: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3438: lc_mod_name,

Line 3437: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3433: -- log results from previous call
3434: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3435: lc_mod_name,
3436: 'Returned from CSD_CHARGE_LINE_UTIL.Get_RO_PriceList');
3437: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3438: lc_mod_name,
3439: 'l_default_price_list_id = ' ||
3440: l_default_price_list_id);
3441: -- log the next call

Line 3442: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3438: lc_mod_name,
3439: 'l_default_price_list_id = ' ||
3440: l_default_price_list_id);
3441: -- log the next call
3442: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3443: lc_mod_name,
3444: 'Calling CSD_GEN_ERRMSGS_PVT.purge_entity_msgs');
3445: END IF;
3446:

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

3459: p_source_entity_id2 => NULL,
3460: x_return_status => l_return_status,
3461: x_msg_count => l_msg_count,
3462: x_msg_data => l_msg_data);
3463: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3464: THEN
3465: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3466: lc_mod_name,
3467: 'Returned from CSD_GEN_ERRMSGS_PVT.purge_entity_msgs');

Line 3465: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3461: x_msg_count => l_msg_count,
3462: x_msg_data => l_msg_data);
3463: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3464: THEN
3465: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3466: lc_mod_name,
3467: 'Returned from CSD_GEN_ERRMSGS_PVT.purge_entity_msgs');
3468: END IF;
3469: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS)

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

3473:
3474: -- Now, get info for estimate lines into l_est_lines_tbl
3475: IF p_repair_mode = 'TASK'
3476: THEN
3477: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3478: THEN
3479: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3480: lc_mod_name,
3481: 'Calling CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_Task');

Line 3479: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3475: IF p_repair_mode = 'TASK'
3476: THEN
3477: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3478: THEN
3479: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3480: lc_mod_name,
3481: 'Calling CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_Task');
3482: END IF;
3483: Get_Estimates_From_Task(p_api_version => 1.0,

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

3499: p_price_list_id => l_default_price_list_id,
3500: p_contract_line_id => l_default_contract_line_id,
3501: x_est_lines_tbl => l_est_lines_tbl,
3502: x_warning_flag => l_warning_flag);
3503: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3504: THEN
3505: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3506: lc_mod_name,
3507: 'Returned from CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_Task');

Line 3505: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3501: x_est_lines_tbl => l_est_lines_tbl,
3502: x_warning_flag => l_warning_flag);
3503: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3504: THEN
3505: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3506: lc_mod_name,
3507: 'Returned from CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_Task');
3508: END IF;
3509: ELSIF p_repair_mode = 'WIP'

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

3507: 'Returned from CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_Task');
3508: END IF;
3509: ELSIF p_repair_mode = 'WIP'
3510: THEN
3511: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3512: THEN
3513: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3514: lc_mod_name,
3515: 'Calling CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_BOM');

Line 3513: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3509: ELSIF p_repair_mode = 'WIP'
3510: THEN
3511: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3512: THEN
3513: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3514: lc_mod_name,
3515: 'Calling CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_BOM');
3516: END IF;
3517: Get_Estimates_From_BOM(p_api_version => 1.0,

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

3533: p_price_list_id => l_default_price_list_id,
3534: p_contract_line_id => l_default_contract_line_id,
3535: x_est_lines_tbl => l_est_lines_tbl,
3536: x_warning_flag => l_warning_flag);
3537: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3538: THEN
3539: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3540: lc_mod_name,
3541: 'Returned from CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_BOM');

Line 3539: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3535: x_est_lines_tbl => l_est_lines_tbl,
3536: x_warning_flag => l_warning_flag);
3537: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3538: THEN
3539: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3540: lc_mod_name,
3541: 'Returned from CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_BOM');
3542: END IF;
3543: ELSE

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

3540: lc_mod_name,
3541: 'Returned from CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_BOM');
3542: END IF;
3543: ELSE
3544: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
3545: THEN
3546: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3547: lc_mod_name,
3548: 'Unknown Repair Mode: ' || p_repair_mode);

Line 3546: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3542: END IF;
3543: ELSE
3544: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
3545: THEN
3546: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3547: lc_mod_name,
3548: 'Unknown Repair Mode: ' || p_repair_mode);
3549: END IF;
3550: RAISE CSD_EST_INAPPL_MODE;

Line 3563: IF (Fnd_Log.Level_Procedure >=

3559: -- before attempting to create estimate lines
3560: IF (l_warning_flag = Fnd_Api.G_TRUE)
3561: THEN
3562: x_warning_flag := l_warning_flag;
3563: IF (Fnd_Log.Level_Procedure >=
3564: Fnd_Log.G_Current_Runtime_Level)
3565: THEN
3566: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3567: lc_mod_name,

Line 3564: Fnd_Log.G_Current_Runtime_Level)

3560: IF (l_warning_flag = Fnd_Api.G_TRUE)
3561: THEN
3562: x_warning_flag := l_warning_flag;
3563: IF (Fnd_Log.Level_Procedure >=
3564: Fnd_Log.G_Current_Runtime_Level)
3565: THEN
3566: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3567: lc_mod_name,
3568: 'Calling CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');

Line 3566: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3562: x_warning_flag := l_warning_flag;
3563: IF (Fnd_Log.Level_Procedure >=
3564: Fnd_Log.G_Current_Runtime_Level)
3565: THEN
3566: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3567: lc_mod_name,
3568: 'Calling CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
3569: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3570: lc_mod_name,

Line 3569: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3565: THEN
3566: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3567: lc_mod_name,
3568: 'Calling CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
3569: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3570: lc_mod_name,
3571: 'Number of messages in stack: ' ||
3572: Fnd_Msg_Pub.count_msg);
3573: END IF;

Line 3589: IF (Fnd_Log.Level_Procedure >=

3585: IF NOT (l_return_status = Fnd_Api.G_RET_STS_SUCCESS)
3586: THEN
3587: RAISE Fnd_Api.G_EXC_ERROR;
3588: END IF;
3589: IF (Fnd_Log.Level_Procedure >=
3590: Fnd_Log.G_Current_Runtime_Level)
3591: THEN
3592: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3593: lc_mod_name,

Line 3590: Fnd_Log.G_Current_Runtime_Level)

3586: THEN
3587: RAISE Fnd_Api.G_EXC_ERROR;
3588: END IF;
3589: IF (Fnd_Log.Level_Procedure >=
3590: Fnd_Log.G_Current_Runtime_Level)
3591: THEN
3592: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3593: lc_mod_name,
3594: 'Returned from CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');

Line 3592: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3588: END IF;
3589: IF (Fnd_Log.Level_Procedure >=
3590: Fnd_Log.G_Current_Runtime_Level)
3591: THEN
3592: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3593: lc_mod_name,
3594: 'Returned from CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
3595: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3596: lc_mod_name,

Line 3595: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3591: THEN
3592: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3593: lc_mod_name,
3594: 'Returned from CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
3595: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3596: lc_mod_name,
3597: 'Number of messages in stack: ' ||
3598: Fnd_Msg_Pub.count_msg);
3599: END IF;

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

3598: Fnd_Msg_Pub.count_msg);
3599: END IF;
3600: END IF;
3601:
3602: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
3603: THEN
3604: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3605: lc_mod_name,
3606: 'Creating repair estimate lines');

Line 3604: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3600: END IF;
3601:
3602: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
3603: THEN
3604: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3605: lc_mod_name,
3606: 'Creating repair estimate lines');
3607: END IF;
3608:

Line 3619: IF (Fnd_Log.Level_Statement >=

3615:
3616: FOR i IN 1 .. l_est_lines_tbl.COUNT
3617: LOOP
3618: BEGIN
3619: IF (Fnd_Log.Level_Statement >=
3620: Fnd_Log.G_Current_Runtime_Level)
3621: THEN
3622: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3623: lc_mod_name,

Line 3620: Fnd_Log.G_Current_Runtime_Level)

3616: FOR i IN 1 .. l_est_lines_tbl.COUNT
3617: LOOP
3618: BEGIN
3619: IF (Fnd_Log.Level_Statement >=
3620: Fnd_Log.G_Current_Runtime_Level)
3621: THEN
3622: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3623: lc_mod_name,
3624: 'Calling create_repair_estimate_lines for line ' || i);

Line 3622: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3618: BEGIN
3619: IF (Fnd_Log.Level_Statement >=
3620: Fnd_Log.G_Current_Runtime_Level)
3621: THEN
3622: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3623: lc_mod_name,
3624: 'Calling create_repair_estimate_lines for line ' || i);
3625: END IF;
3626: --bug#11902612

Line 3646: IF (Fnd_Log.Level_Statement >=

3642: WHEN OTHERS THEN
3643: l_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3644: END;
3645:
3646: IF (Fnd_Log.Level_Statement >=
3647: Fnd_Log.G_Current_Runtime_Level)
3648: THEN
3649: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3650: lc_mod_name,

Line 3647: Fnd_Log.G_Current_Runtime_Level)

3643: l_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3644: END;
3645:
3646: IF (Fnd_Log.Level_Statement >=
3647: Fnd_Log.G_Current_Runtime_Level)
3648: THEN
3649: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3650: lc_mod_name,
3651: 'x_estimate_line_rec = ' ||

Line 3649: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3645:
3646: IF (Fnd_Log.Level_Statement >=
3647: Fnd_Log.G_Current_Runtime_Level)
3648: THEN
3649: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3650: lc_mod_name,
3651: 'x_estimate_line_rec = ' ||
3652: TO_CHAR(l_est_lines_tbl(i)
3653: .repair_estimate_line_id));

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

3650: lc_mod_name,
3651: 'x_estimate_line_rec = ' ||
3652: TO_CHAR(l_est_lines_tbl(i)
3653: .repair_estimate_line_id));
3654: -- FND_LOG.STRING(Fnd_Log.Level_Procedure, lc_mod_name,
3655: -- 'x_return_status = '||l_return_status);
3656: END IF;
3657:
3658: -- If SC have been applied to create estimate lines successfully,

Line 3670: IF (Fnd_Log.Level_Statement >=

3666: NVL(l_est_lines_tbl(i).RO_SERVICE_CODE_ID, -999)) AND
3667: (l_est_lines_tbl(i).RO_SERVICE_CODE_ID IS NOT NULL)
3668: THEN
3669:
3670: IF (Fnd_Log.Level_Statement >=
3671: Fnd_Log.G_Current_Runtime_Level)
3672: THEN
3673: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3674: lc_mod_name,

Line 3671: Fnd_Log.G_Current_Runtime_Level)

3667: (l_est_lines_tbl(i).RO_SERVICE_CODE_ID IS NOT NULL)
3668: THEN
3669:
3670: IF (Fnd_Log.Level_Statement >=
3671: Fnd_Log.G_Current_Runtime_Level)
3672: THEN
3673: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3674: lc_mod_name,
3675: 'l_prev_ro_sc_id = ' ||

Line 3673: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3669:
3670: IF (Fnd_Log.Level_Statement >=
3671: Fnd_Log.G_Current_Runtime_Level)
3672: THEN
3673: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3674: lc_mod_name,
3675: 'l_prev_ro_sc_id = ' ||
3676: TO_CHAR(l_prev_ro_sc_id));
3677: Fnd_Log.STRING(Fnd_Log.Level_Statement,

Line 3677: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3673: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3674: lc_mod_name,
3675: 'l_prev_ro_sc_id = ' ||
3676: TO_CHAR(l_prev_ro_sc_id));
3677: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3678: lc_mod_name,
3679: 'l_est_lines_tbl(i).RO_SERVICE_CODE_ID = ' ||
3680: TO_CHAR(l_est_lines_tbl(i)
3681: .RO_SERVICE_CODE_ID));

Line 3693: IF (Fnd_Log.Level_Procedure >=

3689: FETCH c_ro_sc_obj_version
3690: INTO l_ro_sc_rec_type.object_version_number;
3691: CLOSE c_ro_sc_obj_version;
3692:
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: INTO l_ro_sc_rec_type.object_version_number;
3691: CLOSE c_ro_sc_obj_version;
3692:
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_RO_SERVICE_CODES_PVT.Update_RO_Service_Code');

Line 3696: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3692:
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_RO_SERVICE_CODES_PVT.Update_RO_Service_Code');
3699: END IF;
3700: Csd_Ro_Service_Codes_Pvt.Update_RO_Service_Code(p_api_version => 1.0,

Line 3717: IF (Fnd_Log.Level_Statement >=

3713: .RO_SERVICE_CODE_ID;
3714: ELSE
3715: -- not able to update csd_ro_service_codes table to set as applied to est
3716: x_warning_flag := Fnd_Api.G_TRUE;
3717: IF (Fnd_Log.Level_Statement >=
3718: Fnd_Log.G_Current_Runtime_Level)
3719: THEN
3720: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3721: lc_mod_name,

Line 3718: Fnd_Log.G_Current_Runtime_Level)

3714: ELSE
3715: -- not able to update csd_ro_service_codes table to set as applied to est
3716: x_warning_flag := Fnd_Api.G_TRUE;
3717: IF (Fnd_Log.Level_Statement >=
3718: Fnd_Log.G_Current_Runtime_Level)
3719: THEN
3720: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3721: lc_mod_name,
3722: 'Adding message CSD_EST_SC_APPLIED_ERR to FND_MSG stack');

Line 3720: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3716: x_warning_flag := Fnd_Api.G_TRUE;
3717: IF (Fnd_Log.Level_Statement >=
3718: Fnd_Log.G_Current_Runtime_Level)
3719: THEN
3720: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3721: lc_mod_name,
3722: 'Adding message CSD_EST_SC_APPLIED_ERR to FND_MSG stack');
3723: END IF;
3724: Fnd_Message.SET_NAME('CSD',

Line 3727: IF (Fnd_Log.Level_Procedure >=

3723: END IF;
3724: Fnd_Message.SET_NAME('CSD',
3725: 'CSD_EST_SC_APPLIED_ERR');
3726: Fnd_Msg_Pub.ADD;
3727: IF (Fnd_Log.Level_Procedure >=
3728: Fnd_Log.G_Current_Runtime_Level)
3729: THEN
3730: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3731: lc_mod_name,

Line 3728: Fnd_Log.G_Current_Runtime_Level)

3724: Fnd_Message.SET_NAME('CSD',
3725: 'CSD_EST_SC_APPLIED_ERR');
3726: Fnd_Msg_Pub.ADD;
3727: IF (Fnd_Log.Level_Procedure >=
3728: Fnd_Log.G_Current_Runtime_Level)
3729: THEN
3730: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3731: lc_mod_name,
3732: 'Calling CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');

Line 3730: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3726: Fnd_Msg_Pub.ADD;
3727: IF (Fnd_Log.Level_Procedure >=
3728: Fnd_Log.G_Current_Runtime_Level)
3729: THEN
3730: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3731: lc_mod_name,
3732: 'Calling CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
3733: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3734: lc_mod_name,

Line 3733: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3729: THEN
3730: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3731: lc_mod_name,
3732: 'Calling CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
3733: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3734: lc_mod_name,
3735: 'Number of messages in stack: ' ||
3736: Fnd_Msg_Pub.count_msg);
3737: END IF;

Line 3756: IF (Fnd_Log.Level_Procedure >=

3752: (l_return_status = Fnd_Api.G_RET_STS_SUCCESS)
3753: THEN
3754: RAISE Fnd_Api.G_EXC_ERROR;
3755: END IF;
3756: IF (Fnd_Log.Level_Procedure >=
3757: Fnd_Log.G_Current_Runtime_Level)
3758: THEN
3759: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3760: lc_mod_name,

Line 3757: Fnd_Log.G_Current_Runtime_Level)

3753: THEN
3754: RAISE Fnd_Api.G_EXC_ERROR;
3755: END IF;
3756: IF (Fnd_Log.Level_Procedure >=
3757: Fnd_Log.G_Current_Runtime_Level)
3758: THEN
3759: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3760: lc_mod_name,
3761: 'Returned from CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');

Line 3759: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3755: END IF;
3756: IF (Fnd_Log.Level_Procedure >=
3757: Fnd_Log.G_Current_Runtime_Level)
3758: THEN
3759: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3760: lc_mod_name,
3761: 'Returned from CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
3762: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3763: lc_mod_name,

Line 3762: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3758: THEN
3759: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3760: lc_mod_name,
3761: 'Returned from CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
3762: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3763: lc_mod_name,
3764: 'Number of messages in stack: ' ||
3765: Fnd_Msg_Pub.count_msg);
3766: END IF;

Line 3772: IF (Fnd_Log.Level_Procedure >=

3768: END IF;
3769: ELSE
3770: -- not able to create repair estimate line from record in table
3771: -- log a warning and save the error messages.
3772: IF (Fnd_Log.Level_Procedure >=
3773: Fnd_Log.G_Current_Runtime_Level)
3774: THEN
3775: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3776: lc_mod_name,

Line 3773: Fnd_Log.G_Current_Runtime_Level)

3769: ELSE
3770: -- not able to create repair estimate line from record in table
3771: -- log a warning and save the error messages.
3772: IF (Fnd_Log.Level_Procedure >=
3773: Fnd_Log.G_Current_Runtime_Level)
3774: THEN
3775: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3776: lc_mod_name,
3777: 'Unable to create repair estimate line for index ' || i);

Line 3775: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3771: -- log a warning and save the error messages.
3772: IF (Fnd_Log.Level_Procedure >=
3773: Fnd_Log.G_Current_Runtime_Level)
3774: THEN
3775: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3776: lc_mod_name,
3777: 'Unable to create repair estimate line for index ' || i);
3778: END IF;
3779:

Line 3798: IF (Fnd_Log.Level_Statement >=

3794: l_item_name := TO_CHAR(l_est_lines_tbl(i)
3795: .inventory_item_id);
3796: END;
3797:
3798: IF (Fnd_Log.Level_Statement >=
3799: Fnd_Log.G_Current_Runtime_Level)
3800: THEN
3801: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3802: lc_mod_name,

Line 3799: Fnd_Log.G_Current_Runtime_Level)

3795: .inventory_item_id);
3796: END;
3797:
3798: IF (Fnd_Log.Level_Statement >=
3799: Fnd_Log.G_Current_Runtime_Level)
3800: THEN
3801: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3802: lc_mod_name,
3803: 'Adding message CSD_EST_LINE_CREATED_ERR to FND_MSG stack');

Line 3801: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3797:
3798: IF (Fnd_Log.Level_Statement >=
3799: Fnd_Log.G_Current_Runtime_Level)
3800: THEN
3801: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3802: lc_mod_name,
3803: 'Adding message CSD_EST_LINE_CREATED_ERR to FND_MSG stack');
3804: END IF;
3805: Fnd_Message.SET_NAME('CSD', 'CSD_EST_LINE_CREATED_ERR');

Line 3808: IF (Fnd_Log.Level_Procedure >=

3804: END IF;
3805: Fnd_Message.SET_NAME('CSD', 'CSD_EST_LINE_CREATED_ERR');
3806: Fnd_Message.SET_TOKEN('ITEM', l_item_name);
3807: Fnd_Msg_Pub.ADD;
3808: IF (Fnd_Log.Level_Procedure >=
3809: Fnd_Log.G_Current_Runtime_Level)
3810: THEN
3811: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3812: lc_mod_name,

Line 3809: Fnd_Log.G_Current_Runtime_Level)

3805: Fnd_Message.SET_NAME('CSD', 'CSD_EST_LINE_CREATED_ERR');
3806: Fnd_Message.SET_TOKEN('ITEM', l_item_name);
3807: Fnd_Msg_Pub.ADD;
3808: IF (Fnd_Log.Level_Procedure >=
3809: Fnd_Log.G_Current_Runtime_Level)
3810: THEN
3811: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3812: lc_mod_name,
3813: 'Calling CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');

Line 3811: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3807: Fnd_Msg_Pub.ADD;
3808: IF (Fnd_Log.Level_Procedure >=
3809: Fnd_Log.G_Current_Runtime_Level)
3810: THEN
3811: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3812: lc_mod_name,
3813: 'Calling CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
3814: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3815: lc_mod_name,

Line 3814: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3810: THEN
3811: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3812: lc_mod_name,
3813: 'Calling CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
3814: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3815: lc_mod_name,
3816: 'Number of messages in stack: ' ||
3817: Fnd_Msg_Pub.count_msg);
3818: END IF;

Line 3836: IF (Fnd_Log.Level_Procedure >=

3832: IF NOT (l_return_status = Fnd_Api.G_RET_STS_SUCCESS)
3833: THEN
3834: RAISE Fnd_Api.G_EXC_ERROR;
3835: END IF;
3836: IF (Fnd_Log.Level_Procedure >=
3837: Fnd_Log.G_Current_Runtime_Level)
3838: THEN
3839: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3840: lc_mod_name,

Line 3837: Fnd_Log.G_Current_Runtime_Level)

3833: THEN
3834: RAISE Fnd_Api.G_EXC_ERROR;
3835: END IF;
3836: IF (Fnd_Log.Level_Procedure >=
3837: Fnd_Log.G_Current_Runtime_Level)
3838: THEN
3839: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3840: lc_mod_name,
3841: 'Returned from CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');

Line 3839: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3835: END IF;
3836: IF (Fnd_Log.Level_Procedure >=
3837: Fnd_Log.G_Current_Runtime_Level)
3838: THEN
3839: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3840: lc_mod_name,
3841: 'Returned from CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
3842: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3843: lc_mod_name,

Line 3842: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3838: THEN
3839: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3840: lc_mod_name,
3841: 'Returned from CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
3842: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3843: lc_mod_name,
3844: 'Number of messages in stack: ' ||
3845: Fnd_Msg_Pub.count_msg);
3846: END IF;

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

3861: -- Standard call to get message count and IF count is get message info.
3862: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3863: p_data => x_msg_data);
3864:
3865: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
3866: THEN
3867: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3868: lc_mod_name || '.out_parameter',
3869: 'x_warning_flag: ' || x_warning_flag);

Line 3867: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3863: p_data => x_msg_data);
3864:
3865: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
3866: THEN
3867: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3868: lc_mod_name || '.out_parameter',
3869: 'x_warning_flag: ' || x_warning_flag);
3870: END IF;
3871:

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

3868: lc_mod_name || '.out_parameter',
3869: 'x_warning_flag: ' || x_warning_flag);
3870: END IF;
3871:
3872: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3873: THEN
3874: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3875: lc_mod_name || '.END',
3876: 'Leaving Autocreate_Estimate_Lines');

Line 3874: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

3870: END IF;
3871:
3872: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3873: THEN
3874: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3875: lc_mod_name || '.END',
3876: 'Leaving Autocreate_Estimate_Lines');
3877: END IF;
3878:

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

3883: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3884: x_warning_flag := Fnd_Api.G_FALSE;
3885:
3886: -- save message in fnd stack
3887: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
3888: THEN
3889: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3890: lc_mod_name,
3891: 'Adding message CSD_EST_SC_NO_APPL to FND_MSG stack');

Line 3889: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3885:
3886: -- save message in fnd stack
3887: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
3888: THEN
3889: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3890: lc_mod_name,
3891: 'Adding message CSD_EST_SC_NO_APPL to FND_MSG stack');
3892: END IF;
3893: Fnd_Message.SET_NAME('CSD', 'CSD_EST_SC_NO_APPL');

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

3895: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3896: p_data => x_msg_data);
3897:
3898: -- save message in debug log
3899: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
3900: THEN
3901: Fnd_Log.STRING(Fnd_Log.Level_Exception,
3902: lc_mod_name,
3903: 'No service codes found to apply');

Line 3901: Fnd_Log.STRING(Fnd_Log.Level_Exception,

3897:
3898: -- save message in debug log
3899: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
3900: THEN
3901: Fnd_Log.STRING(Fnd_Log.Level_Exception,
3902: lc_mod_name,
3903: 'No service codes found to apply');
3904: END IF;
3905: WHEN CSD_EST_DEF_PL THEN

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

3908: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3909: x_warning_flag := Fnd_Api.G_FALSE;
3910:
3911: -- save message in fnd stack
3912: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
3913: THEN
3914: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3915: lc_mod_name,
3916: 'Adding message CSD_EST_NO_DEF_PL to FND_MSG stack');

Line 3914: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3910:
3911: -- save message in fnd stack
3912: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
3913: THEN
3914: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3915: lc_mod_name,
3916: 'Adding message CSD_EST_NO_DEF_PL to FND_MSG stack');
3917: END IF;
3918: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NO_DEF_PL');

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

3920: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3921: p_data => x_msg_data);
3922:
3923: -- save message in debug log
3924: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
3925: THEN
3926: Fnd_Log.STRING(Fnd_Log.Level_Exception,
3927: lc_mod_name,
3928: 'Unable to determine default pricelist');

Line 3926: Fnd_Log.STRING(Fnd_Log.Level_Exception,

3922:
3923: -- save message in debug log
3924: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
3925: THEN
3926: Fnd_Log.STRING(Fnd_Log.Level_Exception,
3927: lc_mod_name,
3928: 'Unable to determine default pricelist');
3929: END IF;
3930:

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

3934: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3935: x_warning_flag := Fnd_Api.G_FALSE;
3936:
3937: -- save message in fnd stack
3938: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
3939: THEN
3940: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3941: lc_mod_name,
3942: 'Adding message CSD_EST_INAPPL_MODE to FND_MSG stack');

Line 3940: Fnd_Log.STRING(Fnd_Log.Level_Statement,

3936:
3937: -- save message in fnd stack
3938: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
3939: THEN
3940: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3941: lc_mod_name,
3942: 'Adding message CSD_EST_INAPPL_MODE to FND_MSG stack');
3943: END IF;
3944: DECLARE

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

3959: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3960: p_data => x_msg_data);
3961:
3962: -- save message in debug log
3963: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
3964: THEN
3965: Fnd_Log.STRING(Fnd_Log.Level_Exception,
3966: lc_mod_name,
3967: 'Cannot apply service code for repair mode');

Line 3965: Fnd_Log.STRING(Fnd_Log.Level_Exception,

3961:
3962: -- save message in debug log
3963: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
3964: THEN
3965: Fnd_Log.STRING(Fnd_Log.Level_Exception,
3966: lc_mod_name,
3967: 'Cannot apply service code for repair mode');
3968: END IF;
3969: WHEN Fnd_Api.G_EXC_ERROR THEN

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

3972:
3973: /*
3974: -- TO DO: Add seeded err message
3975: -- save message in fnd stack
3976: if (Fnd_Log.Level_Statement>= Fnd_Log.G_Current_Runtime_Level) then
3977: FND_LOG.STRING(Fnd_Log.Level_Statement, lc_mod_name,
3978: 'Adding message err_name to FND_MSG stack');
3979: end if;
3980: FND_MESSAGE.SET_NAME('CSD','err_name');

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

3973: /*
3974: -- TO DO: Add seeded err message
3975: -- save message in fnd stack
3976: if (Fnd_Log.Level_Statement>= Fnd_Log.G_Current_Runtime_Level) then
3977: FND_LOG.STRING(Fnd_Log.Level_Statement, lc_mod_name,
3978: 'Adding message err_name to FND_MSG stack');
3979: end if;
3980: FND_MESSAGE.SET_NAME('CSD','err_name');
3981: FND_MESSAGE.SET_TOKEN('toke_name', 'token_value');

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

3984: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3985: p_data => x_msg_data);
3986:
3987: -- save message in debug log
3988: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
3989: THEN
3990: Fnd_Log.STRING(Fnd_Log.Level_Exception,
3991: lc_mod_name,
3992: 'EXC_ERROR[' || x_msg_data || ']');

Line 3990: Fnd_Log.STRING(Fnd_Log.Level_Exception,

3986:
3987: -- save message in debug log
3988: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
3989: THEN
3990: Fnd_Log.STRING(Fnd_Log.Level_Exception,
3991: lc_mod_name,
3992: 'EXC_ERROR[' || x_msg_data || ']');
3993: END IF;
3994: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 4001: IF (Fnd_Log.Level_Statement >=

3997:
3998: -- save message in fnd stack
3999: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
4000: THEN
4001: IF (Fnd_Log.Level_Statement >=
4002: Fnd_Log.G_Current_Runtime_Level)
4003: THEN
4004: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4005: lc_mod_name,

Line 4002: Fnd_Log.G_Current_Runtime_Level)

3998: -- save message in fnd stack
3999: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
4000: THEN
4001: IF (Fnd_Log.Level_Statement >=
4002: Fnd_Log.G_Current_Runtime_Level)
4003: THEN
4004: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4005: lc_mod_name,
4006: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 4004: Fnd_Log.STRING(Fnd_Log.Level_Statement,

4000: THEN
4001: IF (Fnd_Log.Level_Statement >=
4002: Fnd_Log.G_Current_Runtime_Level)
4003: THEN
4004: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4005: lc_mod_name,
4006: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
4007: END IF;
4008: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);

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

4010: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
4011: p_data => x_msg_data);
4012:
4013: -- save message in debug log
4014: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
4015: THEN
4016: Fnd_Log.STRING(Fnd_Log.Level_Exception,
4017: lc_mod_name,
4018: 'EXC_UNEXPECTED_ERROR[' || x_msg_data || ']');

Line 4016: Fnd_Log.STRING(Fnd_Log.Level_Exception,

4012:
4013: -- save message in debug log
4014: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
4015: THEN
4016: Fnd_Log.STRING(Fnd_Log.Level_Exception,
4017: lc_mod_name,
4018: 'EXC_UNEXPECTED_ERROR[' || x_msg_data || ']');
4019: END IF;
4020: WHEN OTHERS THEN

Line 4027: IF (Fnd_Log.Level_Statement >=

4023:
4024: -- save message in fnd stack
4025: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
4026: THEN
4027: IF (Fnd_Log.Level_Statement >=
4028: Fnd_Log.G_Current_Runtime_Level)
4029: THEN
4030: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4031: lc_mod_name,

Line 4028: Fnd_Log.G_Current_Runtime_Level)

4024: -- save message in fnd stack
4025: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
4026: THEN
4027: IF (Fnd_Log.Level_Statement >=
4028: Fnd_Log.G_Current_Runtime_Level)
4029: THEN
4030: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4031: lc_mod_name,
4032: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 4030: Fnd_Log.STRING(Fnd_Log.Level_Statement,

4026: THEN
4027: IF (Fnd_Log.Level_Statement >=
4028: Fnd_Log.G_Current_Runtime_Level)
4029: THEN
4030: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4031: lc_mod_name,
4032: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
4033: END IF;
4034: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);

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

4036: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
4037: p_data => x_msg_data);
4038:
4039: -- save message in debug log
4040: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
4041: THEN
4042: -- create a seeded message
4043: Fnd_Log.STRING(Fnd_Log.Level_Exception,
4044: lc_mod_name,

Line 4043: Fnd_Log.STRING(Fnd_Log.Level_Exception,

4039: -- save message in debug log
4040: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
4041: THEN
4042: -- create a seeded message
4043: Fnd_Log.STRING(Fnd_Log.Level_Exception,
4044: lc_mod_name,
4045: 'SQL Message[' || SQLERRM || ']');
4046: END IF;
4047:

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

4081: p_contract_line_id IN NUMBER,
4082: x_est_lines_tbl OUT NOCOPY CSD_REPAIR_ESTIMATE_PVT.REPAIR_ESTIMATE_LINE_TBL,
4083: x_warning_flag OUT NOCOPY VARCHAR2) IS
4084: -- CONSTANTS --
4085: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
4086: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
4087: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
4088: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
4089: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;

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

4082: x_est_lines_tbl OUT NOCOPY CSD_REPAIR_ESTIMATE_PVT.REPAIR_ESTIMATE_LINE_TBL,
4083: x_warning_flag OUT NOCOPY VARCHAR2) IS
4084: -- CONSTANTS --
4085: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
4086: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
4087: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
4088: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
4089: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
4090: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;

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

4083: x_warning_flag OUT NOCOPY VARCHAR2) IS
4084: -- CONSTANTS --
4085: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
4086: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
4087: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
4088: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
4089: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
4090: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
4091: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;

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

4084: -- CONSTANTS --
4085: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
4086: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
4087: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
4088: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
4089: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
4090: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
4091: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
4092: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.get_estimates_from_task';

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

4085: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
4086: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
4087: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
4088: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
4089: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
4090: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
4091: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
4092: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.get_estimates_from_task';
4093: lc_api_name CONSTANT VARCHAR2(30) := 'Get_Estimates_From_Task';

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

4086: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
4087: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
4088: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
4089: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
4090: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
4091: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
4092: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.get_estimates_from_task';
4093: lc_api_name CONSTANT VARCHAR2(30) := 'Get_Estimates_From_Task';
4094: lc_api_version CONSTANT NUMBER := 1.0;

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

4087: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
4088: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
4089: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
4090: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
4091: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
4092: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.get_estimates_from_task';
4093: lc_api_name CONSTANT VARCHAR2(30) := 'Get_Estimates_From_Task';
4094: lc_api_version CONSTANT NUMBER := 1.0;
4095:

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

4668:
4669: --
4670: -- Begin API Body
4671: --
4672: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
4673: THEN
4674: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4675: lc_mod_name || '.BEGIN',
4676: 'Entering CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_Task');

Line 4674: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

4670: -- Begin API Body
4671: --
4672: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
4673: THEN
4674: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4675: lc_mod_name || '.BEGIN',
4676: 'Entering CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_Task');
4677: END IF;
4678: -- log parameters

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

4675: lc_mod_name || '.BEGIN',
4676: 'Entering CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_Task');
4677: END IF;
4678: -- log parameters
4679: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
4680: THEN
4681: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4682: lc_mod_name || '.parameter_logging',
4683: 'p_api_version: ' || p_api_version);

Line 4681: Fnd_Log.STRING(Fnd_Log.Level_Statement,

4677: END IF;
4678: -- log parameters
4679: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
4680: THEN
4681: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4682: lc_mod_name || '.parameter_logging',
4683: 'p_api_version: ' || p_api_version);
4684: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4685: lc_mod_name || '.parameter_logging',

Line 4684: Fnd_Log.STRING(Fnd_Log.Level_Statement,

4680: THEN
4681: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4682: lc_mod_name || '.parameter_logging',
4683: 'p_api_version: ' || p_api_version);
4684: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4685: lc_mod_name || '.parameter_logging',
4686: 'p_commit: ' || p_commit);
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_api_version: ' || p_api_version);
4684: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4685: lc_mod_name || '.parameter_logging',
4686: 'p_commit: ' || p_commit);
4687: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4688: lc_mod_name || '.parameter_logging',
4689: 'p_init_msg_list: ' || p_init_msg_list);
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_commit: ' || p_commit);
4687: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4688: lc_mod_name || '.parameter_logging',
4689: 'p_init_msg_list: ' || p_init_msg_list);
4690: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4691: lc_mod_name || '.parameter_logging',
4692: 'p_validation_level: ' || p_validation_level);
4693: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4694: lc_mod_name || '.parameter_logging',

Line 4693: Fnd_Log.STRING(Fnd_Log.Level_Statement,

4689: 'p_init_msg_list: ' || p_init_msg_list);
4690: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4691: lc_mod_name || '.parameter_logging',
4692: 'p_validation_level: ' || p_validation_level);
4693: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4694: lc_mod_name || '.parameter_logging',
4695: 'p_repair_line_id: ' || p_repair_line_id);
4696: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4697: lc_mod_name || '.parameter_logging',

Line 4696: Fnd_Log.STRING(Fnd_Log.Level_Statement,

4692: 'p_validation_level: ' || p_validation_level);
4693: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4694: lc_mod_name || '.parameter_logging',
4695: 'p_repair_line_id: ' || p_repair_line_id);
4696: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4697: lc_mod_name || '.parameter_logging',
4698: 'p_estimate_id: ' || p_estimate_id);
4699: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4700: lc_mod_name || '.parameter_logging',

Line 4699: Fnd_Log.STRING(Fnd_Log.Level_Statement,

4695: 'p_repair_line_id: ' || p_repair_line_id);
4696: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4697: lc_mod_name || '.parameter_logging',
4698: 'p_estimate_id: ' || p_estimate_id);
4699: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4700: lc_mod_name || '.parameter_logging',
4701: 'p_repair_type_id: ' || p_repair_type_id);
4702: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4703: lc_mod_name || '.parameter_logging',

Line 4702: Fnd_Log.STRING(Fnd_Log.Level_Statement,

4698: 'p_estimate_id: ' || p_estimate_id);
4699: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4700: lc_mod_name || '.parameter_logging',
4701: 'p_repair_type_id: ' || p_repair_type_id);
4702: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4703: lc_mod_name || '.parameter_logging',
4704: 'p_business_process_id: ' ||
4705: p_business_process_id);
4706: Fnd_Log.STRING(Fnd_Log.Level_Statement,

Line 4706: Fnd_Log.STRING(Fnd_Log.Level_Statement,

4702: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4703: lc_mod_name || '.parameter_logging',
4704: 'p_business_process_id: ' ||
4705: p_business_process_id);
4706: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4707: lc_mod_name || '.parameter_logging',
4708: 'p_currency_code: ' || p_currency_code);
4709: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4710: lc_mod_name || '.parameter_logging',

Line 4709: Fnd_Log.STRING(Fnd_Log.Level_Statement,

4705: p_business_process_id);
4706: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4707: lc_mod_name || '.parameter_logging',
4708: 'p_currency_code: ' || p_currency_code);
4709: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4710: lc_mod_name || '.parameter_logging',
4711: 'p_incident_id: ' || p_incident_id);
4712: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4713: lc_mod_name || '.parameter_logging',

Line 4712: Fnd_Log.STRING(Fnd_Log.Level_Statement,

4708: 'p_currency_code: ' || p_currency_code);
4709: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4710: lc_mod_name || '.parameter_logging',
4711: 'p_incident_id: ' || p_incident_id);
4712: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4713: lc_mod_name || '.parameter_logging',
4714: 'p_repair_mode: ' || p_repair_mode);
4715: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4716: lc_mod_name || '.parameter_logging',

Line 4715: Fnd_Log.STRING(Fnd_Log.Level_Statement,

4711: 'p_incident_id: ' || p_incident_id);
4712: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4713: lc_mod_name || '.parameter_logging',
4714: 'p_repair_mode: ' || p_repair_mode);
4715: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4716: lc_mod_name || '.parameter_logging',
4717: 'p_inventory_item_id: ' || p_inventory_item_id);
4718: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4719: lc_mod_name || '.parameter_logging',

Line 4718: Fnd_Log.STRING(Fnd_Log.Level_Statement,

4714: 'p_repair_mode: ' || p_repair_mode);
4715: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4716: lc_mod_name || '.parameter_logging',
4717: 'p_inventory_item_id: ' || p_inventory_item_id);
4718: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4719: lc_mod_name || '.parameter_logging',
4720: 'p_organization_id: ' || p_organization_id);
4721: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4722: lc_mod_name || '.parameter_logging',

Line 4721: Fnd_Log.STRING(Fnd_Log.Level_Statement,

4717: 'p_inventory_item_id: ' || p_inventory_item_id);
4718: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4719: lc_mod_name || '.parameter_logging',
4720: 'p_organization_id: ' || p_organization_id);
4721: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4722: lc_mod_name || '.parameter_logging',
4723: 'p_price_list_id: ' || p_price_list_id);
4724: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4725: lc_mod_name || '.parameter_logging',

Line 4724: Fnd_Log.STRING(Fnd_Log.Level_Statement,

4720: 'p_organization_id: ' || p_organization_id);
4721: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4722: lc_mod_name || '.parameter_logging',
4723: 'p_price_list_id: ' || p_price_list_id);
4724: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4725: lc_mod_name || '.parameter_logging',
4726: 'p_contract_line_id: ' || p_contract_line_id);
4727: END IF;
4728:

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

4736: -- get threshold for tasks - to be used when determining manual vs rollup qty
4737: l_task_threshold := TO_NUMBER(NVL(Fnd_Profile.value('CSP_PROD_TASK_HIST_RULE'),
4738: '0'));
4739:
4740: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
4741: THEN
4742: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4743: lc_mod_name,
4744: 'l_labor_inventory_item_id = ' ||

Line 4742: Fnd_Log.STRING(Fnd_Log.Level_Statement,

4738: '0'));
4739:
4740: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
4741: THEN
4742: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4743: lc_mod_name,
4744: 'l_labor_inventory_item_id = ' ||
4745: l_labor_inventory_item_id);
4746: Fnd_Log.STRING(Fnd_Log.Level_Statement,

Line 4746: Fnd_Log.STRING(Fnd_Log.Level_Statement,

4742: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4743: lc_mod_name,
4744: 'l_labor_inventory_item_id = ' ||
4745: l_labor_inventory_item_id);
4746: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4747: lc_mod_name,
4748: 'l_use_tasks_from_sol = ' ||
4749: l_use_tasks_from_sol);
4750: Fnd_Log.STRING(Fnd_Log.Level_Statement,

Line 4750: Fnd_Log.STRING(Fnd_Log.Level_Statement,

4746: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4747: lc_mod_name,
4748: 'l_use_tasks_from_sol = ' ||
4749: l_use_tasks_from_sol);
4750: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4751: lc_mod_name,
4752: 'l_task_threshold = ' || l_task_threshold);
4753: END IF;
4754:

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

4757: --
4758: DECLARE
4759: l_count NUMBER := 0;
4760: BEGIN
4761: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
4762: THEN
4763: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4764: lc_mod_name,
4765: 'Getting task material lines from service codes');

Line 4763: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

4759: l_count NUMBER := 0;
4760: BEGIN
4761: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
4762: THEN
4763: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4764: lc_mod_name,
4765: 'Getting task material lines from service codes');
4766: END IF;
4767: -- bugfix 3468680, vkjain

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

4793: END IF;
4794: END LOOP;
4795: END;
4796:
4797: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
4798: THEN
4799: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4800: lc_mod_name,
4801: 'material line count = ' ||

Line 4799: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

4795: END;
4796:
4797: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
4798: THEN
4799: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4800: lc_mod_name,
4801: 'material line count = ' ||
4802: l_materials_from_sc_tbl.COUNT);
4803: END IF;

Line 4846: IF (Fnd_Log.Level_Procedure >=

4842: THEN
4843: DECLARE
4844: l_count NUMBER := 0;
4845: BEGIN
4846: IF (Fnd_Log.Level_Procedure >=
4847: Fnd_Log.G_Current_Runtime_Level)
4848: THEN
4849: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4850: lc_mod_name,

Line 4847: Fnd_Log.G_Current_Runtime_Level)

4843: DECLARE
4844: l_count NUMBER := 0;
4845: BEGIN
4846: IF (Fnd_Log.Level_Procedure >=
4847: Fnd_Log.G_Current_Runtime_Level)
4848: THEN
4849: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4850: lc_mod_name,
4851: 'Getting task labor lines from service codes');

Line 4849: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

4845: BEGIN
4846: IF (Fnd_Log.Level_Procedure >=
4847: Fnd_Log.G_Current_Runtime_Level)
4848: THEN
4849: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4850: lc_mod_name,
4851: 'Getting task labor lines from service codes');
4852: END IF;
4853: -- bugfix 3468680, vkjain

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

4870: l_labor_from_sc_tbl(l_count).ro_service_code_id := r1.ro_service_code_id;
4871: END LOOP;
4872: END;
4873:
4874: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
4875: THEN
4876: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4877: lc_mod_name,
4878: 'labor line count = ' ||

Line 4876: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

4872: END;
4873:
4874: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
4875: THEN
4876: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4877: lc_mod_name,
4878: 'labor line count = ' ||
4879: l_labor_from_sc_tbl.COUNT);
4880: END IF;

Line 4931: IF (Fnd_Log.Level_Procedure >=

4927: l_return_status VARCHAR2(1);
4928: l_msg_count NUMBER;
4929: l_msg_data VARCHAR2(2000);
4930: BEGIN
4931: IF (Fnd_Log.Level_Procedure >=
4932: Fnd_Log.G_Current_Runtime_Level)
4933: THEN
4934: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4935: lc_mod_name,

Line 4932: Fnd_Log.G_Current_Runtime_Level)

4928: l_msg_count NUMBER;
4929: l_msg_data VARCHAR2(2000);
4930: BEGIN
4931: IF (Fnd_Log.Level_Procedure >=
4932: Fnd_Log.G_Current_Runtime_Level)
4933: THEN
4934: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4935: lc_mod_name,
4936: 'Getting all solution tasks with no product template');

Line 4934: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

4930: BEGIN
4931: IF (Fnd_Log.Level_Procedure >=
4932: Fnd_Log.G_Current_Runtime_Level)
4933: THEN
4934: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4935: lc_mod_name,
4936: 'Getting all solution tasks with no product template');
4937: END IF;
4938: FOR r1 IN c_sol_tasks_no_prod(p_repair_line_id)

Line 4941: IF (Fnd_Log.Level_Statement >=

4937: END IF;
4938: FOR r1 IN c_sol_tasks_no_prod(p_repair_line_id)
4939: LOOP
4940: x_warning_flag := Fnd_Api.G_TRUE;
4941: IF (Fnd_Log.Level_Statement >=
4942: Fnd_Log.G_Current_Runtime_Level)
4943: THEN
4944: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4945: lc_mod_name,

Line 4942: Fnd_Log.G_Current_Runtime_Level)

4938: FOR r1 IN c_sol_tasks_no_prod(p_repair_line_id)
4939: LOOP
4940: x_warning_flag := Fnd_Api.G_TRUE;
4941: IF (Fnd_Log.Level_Statement >=
4942: Fnd_Log.G_Current_Runtime_Level)
4943: THEN
4944: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4945: lc_mod_name,
4946: 'Adding message CSD_EST_SOL_TASK_NO_PROD to FND_MSG stack');

Line 4944: Fnd_Log.STRING(Fnd_Log.Level_Statement,

4940: x_warning_flag := Fnd_Api.G_TRUE;
4941: IF (Fnd_Log.Level_Statement >=
4942: Fnd_Log.G_Current_Runtime_Level)
4943: THEN
4944: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4945: lc_mod_name,
4946: 'Adding message CSD_EST_SOL_TASK_NO_PROD to FND_MSG stack');
4947: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4948: lc_mod_name,

Line 4947: Fnd_Log.STRING(Fnd_Log.Level_Statement,

4943: THEN
4944: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4945: lc_mod_name,
4946: 'Adding message CSD_EST_SOL_TASK_NO_PROD to FND_MSG stack');
4947: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4948: lc_mod_name,
4949: 'no task template for task group id ' ||
4950: r1.task_group_id);
4951: END IF;

Line 4956: IF (Fnd_Log.Level_Procedure >=

4952: Fnd_Message.SET_NAME('CSD', 'CSD_EST_SOL_TASK_NO_PROD');
4953: Fnd_Message.SET_TOKEN('GROUP_ID', r1.task_group_id);
4954: Fnd_Message.SET_TOKEN('GROUP_NAME', r1.task_group_name);
4955: Fnd_Msg_Pub.ADD;
4956: IF (Fnd_Log.Level_Procedure >=
4957: Fnd_Log.G_Current_Runtime_Level)
4958: THEN
4959: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4960: lc_mod_name,

Line 4957: Fnd_Log.G_Current_Runtime_Level)

4953: Fnd_Message.SET_TOKEN('GROUP_ID', r1.task_group_id);
4954: Fnd_Message.SET_TOKEN('GROUP_NAME', r1.task_group_name);
4955: Fnd_Msg_Pub.ADD;
4956: IF (Fnd_Log.Level_Procedure >=
4957: Fnd_Log.G_Current_Runtime_Level)
4958: THEN
4959: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4960: lc_mod_name,
4961: 'Calling CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');

Line 4959: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

4955: Fnd_Msg_Pub.ADD;
4956: IF (Fnd_Log.Level_Procedure >=
4957: Fnd_Log.G_Current_Runtime_Level)
4958: THEN
4959: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4960: lc_mod_name,
4961: 'Calling CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
4962: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4963: lc_mod_name,

Line 4962: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

4958: THEN
4959: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4960: lc_mod_name,
4961: 'Calling CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
4962: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4963: lc_mod_name,
4964: 'Number of messages in stack: ' ||
4965: Fnd_Msg_Pub.count_msg);
4966: END IF;

Line 4982: IF (Fnd_Log.Level_Procedure >=

4978: IF NOT (l_return_status = Fnd_Api.G_RET_STS_SUCCESS)
4979: THEN
4980: RAISE Fnd_Api.G_EXC_ERROR;
4981: END IF;
4982: IF (Fnd_Log.Level_Procedure >=
4983: Fnd_Log.G_Current_Runtime_Level)
4984: THEN
4985: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4986: lc_mod_name,

Line 4983: Fnd_Log.G_Current_Runtime_Level)

4979: THEN
4980: RAISE Fnd_Api.G_EXC_ERROR;
4981: END IF;
4982: IF (Fnd_Log.Level_Procedure >=
4983: Fnd_Log.G_Current_Runtime_Level)
4984: THEN
4985: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4986: lc_mod_name,
4987: 'Returned from CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');

Line 4985: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

4981: END IF;
4982: IF (Fnd_Log.Level_Procedure >=
4983: Fnd_Log.G_Current_Runtime_Level)
4984: THEN
4985: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4986: lc_mod_name,
4987: 'Returned from CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
4988: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4989: lc_mod_name,

Line 4988: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

4984: THEN
4985: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4986: lc_mod_name,
4987: 'Returned from CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
4988: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4989: lc_mod_name,
4990: 'Number of messages in stack: ' ||
4991: Fnd_Msg_Pub.count_msg);
4992: END IF;

Line 5002: IF (Fnd_Log.Level_Procedure >=

4998: --
4999: DECLARE
5000: l_count NUMBER := 0;
5001: BEGIN
5002: IF (Fnd_Log.Level_Procedure >=
5003: Fnd_Log.G_Current_Runtime_Level)
5004: THEN
5005: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5006: lc_mod_name,

Line 5003: Fnd_Log.G_Current_Runtime_Level)

4999: DECLARE
5000: l_count NUMBER := 0;
5001: BEGIN
5002: IF (Fnd_Log.Level_Procedure >=
5003: Fnd_Log.G_Current_Runtime_Level)
5004: THEN
5005: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5006: lc_mod_name,
5007: 'Getting task material lines from solutions');

Line 5005: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

5001: BEGIN
5002: IF (Fnd_Log.Level_Procedure >=
5003: Fnd_Log.G_Current_Runtime_Level)
5004: THEN
5005: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5006: lc_mod_name,
5007: 'Getting task material lines from solutions');
5008: END IF;
5009: FOR r1 IN c_material_lines_from_sol(p_repair_line_id,

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

5037: END IF;
5038: END LOOP;
5039: END;
5040:
5041: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5042: THEN
5043: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5044: lc_mod_name,
5045: 'material line count = ' ||

Line 5043: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

5039: END;
5040:
5041: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5042: THEN
5043: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5044: lc_mod_name,
5045: 'material line count = ' ||
5046: l_materials_from_sol_tbl.COUNT);
5047: END IF;

Line 5092: IF (Fnd_Log.Level_Procedure >=

5088: THEN
5089: DECLARE
5090: l_count NUMBER := 0;
5091: BEGIN
5092: IF (Fnd_Log.Level_Procedure >=
5093: Fnd_Log.G_Current_Runtime_Level)
5094: THEN
5095: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5096: lc_mod_name,

Line 5093: Fnd_Log.G_Current_Runtime_Level)

5089: DECLARE
5090: l_count NUMBER := 0;
5091: BEGIN
5092: IF (Fnd_Log.Level_Procedure >=
5093: Fnd_Log.G_Current_Runtime_Level)
5094: THEN
5095: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5096: lc_mod_name,
5097: 'Getting task labor lines from solutions');

Line 5095: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

5091: BEGIN
5092: IF (Fnd_Log.Level_Procedure >=
5093: Fnd_Log.G_Current_Runtime_Level)
5094: THEN
5095: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5096: lc_mod_name,
5097: 'Getting task labor lines from solutions');
5098: END IF;
5099: FOR r1 IN c_labor_lines_from_sol(p_repair_line_id,

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

5117: l_labor_from_sol_tbl(l_count).ro_service_code_id := r1.ro_service_code_id;
5118: END LOOP;
5119: END;
5120:
5121: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5122: THEN
5123: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5124: lc_mod_name,
5125: 'labor line count = ' ||

Line 5123: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

5119: END;
5120:
5121: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5122: THEN
5123: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5124: lc_mod_name,
5125: 'labor line count = ' ||
5126: l_labor_from_sol_tbl.COUNT);
5127: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

Line 5127: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

5123: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5124: lc_mod_name,
5125: 'labor line count = ' ||
5126: l_labor_from_sol_tbl.COUNT);
5127: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5128: lc_mod_name,
5129: 'Calling Convert_To_Est_Lines');
5130: END IF;
5131: IF (l_labor_from_sol_tbl.COUNT > 0)

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

5166: -- bugfix 3543135, vkjain.
5167: -- IF (x_est_lines_tbl.count <= 0) THEN
5168: IF (l_No_Eligible_Lines)
5169: THEN
5170: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5171: THEN
5172: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5173: lc_mod_name,
5174: 'no estimate lines available to autogenerate from tasks');

Line 5172: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

5168: IF (l_No_Eligible_Lines)
5169: THEN
5170: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5171: THEN
5172: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5173: lc_mod_name,
5174: 'no estimate lines available to autogenerate from tasks');
5175: END IF;
5176: RAISE CSD_EST_NO_AUTOGEN;

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

5175: END IF;
5176: RAISE CSD_EST_NO_AUTOGEN;
5177: END IF;
5178:
5179: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
5180: THEN
5181: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5182: lc_mod_name || '.out_parameter',
5183: 'x_warning_flag: ' || x_warning_flag);

Line 5181: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5177: END IF;
5178:
5179: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
5180: THEN
5181: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5182: lc_mod_name || '.out_parameter',
5183: 'x_warning_flag: ' || x_warning_flag);
5184: END IF;
5185: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

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

5181: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5182: lc_mod_name || '.out_parameter',
5183: 'x_warning_flag: ' || x_warning_flag);
5184: END IF;
5185: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5186: THEN
5187: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5188: lc_mod_name || '.END',
5189: 'Leaving CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_Task');

Line 5187: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

5183: 'x_warning_flag: ' || x_warning_flag);
5184: END IF;
5185: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5186: THEN
5187: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5188: lc_mod_name || '.END',
5189: 'Leaving CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_Task');
5190: END IF;
5191: --

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

5205: WHEN CSD_EST_NO_AUTOGEN THEN
5206: x_warning_flag := Fnd_Api.G_TRUE;
5207:
5208: -- save message in fnd stack
5209: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
5210: THEN
5211: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5212: lc_mod_name,
5213: 'Adding message CSD_EST_NO_AUTOGEN to FND_MSG stack');

Line 5211: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5207:
5208: -- save message in fnd stack
5209: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
5210: THEN
5211: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5212: lc_mod_name,
5213: 'Adding message CSD_EST_NO_AUTOGEN to FND_MSG stack');
5214: END IF;
5215: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NO_AUTOGEN');

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

5217: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5218: p_data => x_msg_data);
5219:
5220: -- save message in debug log
5221: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5222: THEN
5223: Fnd_Log.STRING(Fnd_Log.Level_Exception,
5224: lc_mod_name,
5225: 'No estimate lines autogenerated');

Line 5223: Fnd_Log.STRING(Fnd_Log.Level_Exception,

5219:
5220: -- save message in debug log
5221: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5222: THEN
5223: Fnd_Log.STRING(Fnd_Log.Level_Exception,
5224: lc_mod_name,
5225: 'No estimate lines autogenerated');
5226: END IF;
5227:

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

5231:
5232: /*
5233: -- TO DO: Add seeded err message
5234: -- save message in fnd stack
5235: if (Fnd_Log.Level_Statement>= Fnd_Log.G_Current_Runtime_Level) then
5236: FND_LOG.STRING(Fnd_Log.Level_Statement, lc_mod_name,
5237: 'Adding message ERR_NAME to FND_MSG stack');
5238: end if;
5239: FND_MESSAGE.SET_NAME('CSD','err_name');

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

5232: /*
5233: -- TO DO: Add seeded err message
5234: -- save message in fnd stack
5235: if (Fnd_Log.Level_Statement>= Fnd_Log.G_Current_Runtime_Level) then
5236: FND_LOG.STRING(Fnd_Log.Level_Statement, lc_mod_name,
5237: 'Adding message ERR_NAME to FND_MSG stack');
5238: end if;
5239: FND_MESSAGE.SET_NAME('CSD','err_name');
5240: FND_MESSAGE.SET_TOKEN('toke_name', 'token_value');

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

5243: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5244: p_data => x_msg_data);
5245:
5246: -- save message in debug log
5247: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5248: THEN
5249: Fnd_Log.STRING(Fnd_Log.Level_Exception,
5250: lc_mod_name,
5251: 'EXC_ERROR[' || x_msg_data || ']');

Line 5249: Fnd_Log.STRING(Fnd_Log.Level_Exception,

5245:
5246: -- save message in debug log
5247: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5248: THEN
5249: Fnd_Log.STRING(Fnd_Log.Level_Exception,
5250: lc_mod_name,
5251: 'EXC_ERROR[' || x_msg_data || ']');
5252: END IF;
5253:

Line 5261: IF (Fnd_Log.Level_Statement >=

5257:
5258: -- save message in fnd stack
5259: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5260: THEN
5261: IF (Fnd_Log.Level_Statement >=
5262: Fnd_Log.G_Current_Runtime_Level)
5263: THEN
5264: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5265: lc_mod_name,

Line 5262: Fnd_Log.G_Current_Runtime_Level)

5258: -- save message in fnd stack
5259: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5260: THEN
5261: IF (Fnd_Log.Level_Statement >=
5262: Fnd_Log.G_Current_Runtime_Level)
5263: THEN
5264: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5265: lc_mod_name,
5266: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 5264: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5260: THEN
5261: IF (Fnd_Log.Level_Statement >=
5262: Fnd_Log.G_Current_Runtime_Level)
5263: THEN
5264: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5265: lc_mod_name,
5266: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5267: END IF;
5268: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);

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

5270: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5271: p_data => x_msg_data);
5272:
5273: -- save message in debug log
5274: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5275: THEN
5276: Fnd_Log.STRING(Fnd_Log.Level_Exception,
5277: lc_mod_name,
5278: 'EXC_UNEXPECTED_ERROR[' || x_msg_data || ']');

Line 5276: Fnd_Log.STRING(Fnd_Log.Level_Exception,

5272:
5273: -- save message in debug log
5274: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5275: THEN
5276: Fnd_Log.STRING(Fnd_Log.Level_Exception,
5277: lc_mod_name,
5278: 'EXC_UNEXPECTED_ERROR[' || x_msg_data || ']');
5279: END IF;
5280:

Line 5288: IF (Fnd_Log.Level_Statement >=

5284:
5285: -- save message in fnd stack
5286: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5287: THEN
5288: IF (Fnd_Log.Level_Statement >=
5289: Fnd_Log.G_Current_Runtime_Level)
5290: THEN
5291: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5292: lc_mod_name,

Line 5289: Fnd_Log.G_Current_Runtime_Level)

5285: -- save message in fnd stack
5286: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5287: THEN
5288: IF (Fnd_Log.Level_Statement >=
5289: Fnd_Log.G_Current_Runtime_Level)
5290: THEN
5291: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5292: lc_mod_name,
5293: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 5291: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5287: THEN
5288: IF (Fnd_Log.Level_Statement >=
5289: Fnd_Log.G_Current_Runtime_Level)
5290: THEN
5291: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5292: lc_mod_name,
5293: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5294: END IF;
5295: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);

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

5297: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5298: p_data => x_msg_data);
5299:
5300: -- save message in debug log
5301: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5302: THEN
5303: -- create a seeded message
5304: Fnd_Log.STRING(Fnd_Log.Level_Exception,
5305: lc_mod_name,

Line 5304: Fnd_Log.STRING(Fnd_Log.Level_Exception,

5300: -- save message in debug log
5301: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5302: THEN
5303: -- create a seeded message
5304: Fnd_Log.STRING(Fnd_Log.Level_Exception,
5305: lc_mod_name,
5306: 'SQL Message[' || SQLERRM || ']');
5307: END IF;
5308: END Get_Estimates_From_Task;

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

5342: x_est_lines_tbl OUT NOCOPY CSD_REPAIR_ESTIMATE_PVT.REPAIR_ESTIMATE_LINE_TBL,
5343: x_warning_flag OUT NOCOPY VARCHAR2) IS
5344:
5345: -- CONSTANTS --
5346: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
5347: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
5348: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
5349: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
5350: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;

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

5343: x_warning_flag OUT NOCOPY VARCHAR2) IS
5344:
5345: -- CONSTANTS --
5346: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
5347: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
5348: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
5349: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
5350: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
5351: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;

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

5344:
5345: -- CONSTANTS --
5346: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
5347: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
5348: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
5349: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
5350: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
5351: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
5352: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;

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

5345: -- CONSTANTS --
5346: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
5347: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
5348: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
5349: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
5350: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
5351: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
5352: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
5353: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.get_estimates_from_bom';

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

5346: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
5347: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
5348: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
5349: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
5350: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
5351: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
5352: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
5353: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.get_estimates_from_bom';
5354: lc_api_name CONSTANT VARCHAR2(30) := 'Get_Estimates_From_BOM';

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

5347: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
5348: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
5349: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
5350: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
5351: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
5352: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
5353: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.get_estimates_from_bom';
5354: lc_api_name CONSTANT VARCHAR2(30) := 'Get_Estimates_From_BOM';
5355: lc_api_version CONSTANT NUMBER := 1.0;

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

5348: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
5349: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
5350: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
5351: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
5352: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
5353: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.get_estimates_from_bom';
5354: lc_api_name CONSTANT VARCHAR2(30) := 'Get_Estimates_From_BOM';
5355: lc_api_version CONSTANT NUMBER := 1.0;
5356:

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

5604: THEN
5605: Fnd_Msg_Pub.initialize;
5606: END IF;
5607:
5608: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5609: THEN
5610: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5611: lc_mod_name || '.BEGIN',
5612: 'Entering CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_BOM');

Line 5610: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

5606: END IF;
5607:
5608: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5609: THEN
5610: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5611: lc_mod_name || '.BEGIN',
5612: 'Entering CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_BOM');
5613: END IF;
5614: -- log parameters

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

5611: lc_mod_name || '.BEGIN',
5612: 'Entering CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_BOM');
5613: END IF;
5614: -- log parameters
5615: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
5616: THEN
5617: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5618: lc_mod_name || '.parameter_logging',
5619: 'p_api_version: ' || p_api_version);

Line 5617: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5613: END IF;
5614: -- log parameters
5615: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
5616: THEN
5617: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5618: lc_mod_name || '.parameter_logging',
5619: 'p_api_version: ' || p_api_version);
5620: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5621: lc_mod_name || '.parameter_logging',

Line 5620: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5616: THEN
5617: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5618: lc_mod_name || '.parameter_logging',
5619: 'p_api_version: ' || p_api_version);
5620: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5621: lc_mod_name || '.parameter_logging',
5622: 'p_commit: ' || p_commit);
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_api_version: ' || p_api_version);
5620: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5621: lc_mod_name || '.parameter_logging',
5622: 'p_commit: ' || p_commit);
5623: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5624: lc_mod_name || '.parameter_logging',
5625: 'p_init_msg_list: ' || p_init_msg_list);
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_commit: ' || p_commit);
5623: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5624: lc_mod_name || '.parameter_logging',
5625: 'p_init_msg_list: ' || p_init_msg_list);
5626: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5627: lc_mod_name || '.parameter_logging',
5628: 'p_validation_level: ' || p_validation_level);
5629: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5630: lc_mod_name || '.parameter_logging',

Line 5629: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5625: 'p_init_msg_list: ' || p_init_msg_list);
5626: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5627: lc_mod_name || '.parameter_logging',
5628: 'p_validation_level: ' || p_validation_level);
5629: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5630: lc_mod_name || '.parameter_logging',
5631: 'p_repair_line_id: ' || p_repair_line_id);
5632: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5633: lc_mod_name || '.parameter_logging',

Line 5632: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5628: 'p_validation_level: ' || p_validation_level);
5629: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5630: lc_mod_name || '.parameter_logging',
5631: 'p_repair_line_id: ' || p_repair_line_id);
5632: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5633: lc_mod_name || '.parameter_logging',
5634: 'p_estimate_id: ' || p_estimate_id);
5635: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5636: lc_mod_name || '.parameter_logging',

Line 5635: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5631: 'p_repair_line_id: ' || p_repair_line_id);
5632: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5633: lc_mod_name || '.parameter_logging',
5634: 'p_estimate_id: ' || p_estimate_id);
5635: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5636: lc_mod_name || '.parameter_logging',
5637: 'p_repair_type_id: ' || p_repair_type_id);
5638: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5639: lc_mod_name || '.parameter_logging',

Line 5638: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5634: 'p_estimate_id: ' || p_estimate_id);
5635: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5636: lc_mod_name || '.parameter_logging',
5637: 'p_repair_type_id: ' || p_repair_type_id);
5638: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5639: lc_mod_name || '.parameter_logging',
5640: 'p_business_process_id: ' ||
5641: p_business_process_id);
5642: Fnd_Log.STRING(Fnd_Log.Level_Statement,

Line 5642: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5638: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5639: lc_mod_name || '.parameter_logging',
5640: 'p_business_process_id: ' ||
5641: p_business_process_id);
5642: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5643: lc_mod_name || '.parameter_logging',
5644: 'p_currency_code: ' || p_currency_code);
5645: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5646: lc_mod_name || '.parameter_logging',

Line 5645: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5641: p_business_process_id);
5642: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5643: lc_mod_name || '.parameter_logging',
5644: 'p_currency_code: ' || p_currency_code);
5645: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5646: lc_mod_name || '.parameter_logging',
5647: 'p_incident_id: ' || p_incident_id);
5648: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5649: lc_mod_name || '.parameter_logging',

Line 5648: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5644: 'p_currency_code: ' || p_currency_code);
5645: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5646: lc_mod_name || '.parameter_logging',
5647: 'p_incident_id: ' || p_incident_id);
5648: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5649: lc_mod_name || '.parameter_logging',
5650: 'p_repair_mode: ' || p_repair_mode);
5651: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5652: lc_mod_name || '.parameter_logging',

Line 5651: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5647: 'p_incident_id: ' || p_incident_id);
5648: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5649: lc_mod_name || '.parameter_logging',
5650: 'p_repair_mode: ' || p_repair_mode);
5651: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5652: lc_mod_name || '.parameter_logging',
5653: 'p_inventory_item_id: ' || p_inventory_item_id);
5654: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5655: lc_mod_name || '.parameter_logging',

Line 5654: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5650: 'p_repair_mode: ' || p_repair_mode);
5651: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5652: lc_mod_name || '.parameter_logging',
5653: 'p_inventory_item_id: ' || p_inventory_item_id);
5654: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5655: lc_mod_name || '.parameter_logging',
5656: 'p_organization_id: ' || p_organization_id);
5657: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5658: lc_mod_name || '.parameter_logging',

Line 5657: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5653: 'p_inventory_item_id: ' || p_inventory_item_id);
5654: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5655: lc_mod_name || '.parameter_logging',
5656: 'p_organization_id: ' || p_organization_id);
5657: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5658: lc_mod_name || '.parameter_logging',
5659: 'p_price_list_id: ' || p_price_list_id);
5660: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5661: lc_mod_name || '.parameter_logging',

Line 5660: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5656: 'p_organization_id: ' || p_organization_id);
5657: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5658: lc_mod_name || '.parameter_logging',
5659: 'p_price_list_id: ' || p_price_list_id);
5660: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5661: lc_mod_name || '.parameter_logging',
5662: 'p_contract_line_id: ' || p_contract_line_id);
5663: END IF;
5664:

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

5677: --
5678: DECLARE
5679: l_count NUMBER := 0;
5680: BEGIN
5681: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5682: THEN
5683: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5684: lc_mod_name,
5685: 'Getting BOM material lines from service codes');

Line 5683: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

5679: l_count NUMBER := 0;
5680: BEGIN
5681: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5682: THEN
5683: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5684: lc_mod_name,
5685: 'Getting BOM material lines from service codes');
5686: END IF;
5687: -- Bugfix 3468680, vkjain

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

5715: -- THEN
5716: -- Csd_Gen_Utility_Pvt.dump_mle_lines_tbl_type(l_material_lines_tbl);
5717: -- END IF;
5718:
5719: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5720: THEN
5721: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5722: lc_mod_name,
5723: 'material line count = ' ||

Line 5721: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

5717: -- END IF;
5718:
5719: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5720: THEN
5721: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5722: lc_mod_name,
5723: 'material line count = ' ||
5724: l_material_lines_tbl.COUNT);
5725: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

Line 5725: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

5721: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5722: lc_mod_name,
5723: 'material line count = ' ||
5724: l_material_lines_tbl.COUNT);
5725: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5726: lc_mod_name,
5727: 'Calling Convert_To_Est_Lines');
5728: END IF;
5729:

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

5766: --
5767: DECLARE
5768: l_count NUMBER := 0;
5769: BEGIN
5770: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5771: THEN
5772: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5773: lc_mod_name,
5774: 'Getting BOM labor lines from service codes');

Line 5772: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

5768: l_count NUMBER := 0;
5769: BEGIN
5770: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5771: THEN
5772: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5773: lc_mod_name,
5774: 'Getting BOM labor lines from service codes');
5775: END IF;
5776: -- bugfix 3468680, vkjain

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

5806: -- THEN
5807: -- Csd_Gen_Utility_Pvt.dump_mle_lines_tbl_type(l_labor_lines_tbl);
5808: -- END IF;
5809:
5810: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5811: THEN
5812: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5813: lc_mod_name,
5814: 'labor line count = ' || l_labor_lines_tbl.COUNT);

Line 5812: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

5808: -- END IF;
5809:
5810: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5811: THEN
5812: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5813: lc_mod_name,
5814: 'labor line count = ' || l_labor_lines_tbl.COUNT);
5815: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5816: lc_mod_name,

Line 5815: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

5811: THEN
5812: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5813: lc_mod_name,
5814: 'labor line count = ' || l_labor_lines_tbl.COUNT);
5815: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5816: lc_mod_name,
5817: 'Calling Convert_To_Est_Lines');
5818: END IF;
5819: Convert_To_Est_Lines(p_api_version => 1.0,

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

5853: -- bugfix 3543135, vkjain.
5854: -- IF (NVL(x_est_lines_tbl.count, 0) <= 0) THEN
5855: IF (l_No_Eligible_Lines)
5856: THEN
5857: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5858: THEN
5859: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5860: lc_mod_name,
5861: 'no estimate lines available to autogenerate from BOM');

Line 5859: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

5855: IF (l_No_Eligible_Lines)
5856: THEN
5857: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5858: THEN
5859: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5860: lc_mod_name,
5861: 'no estimate lines available to autogenerate from BOM');
5862: END IF;
5863: RAISE CSD_EST_NO_AUTOGEN;

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

5862: END IF;
5863: RAISE CSD_EST_NO_AUTOGEN;
5864: END IF;
5865:
5866: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
5867: THEN
5868: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5869: lc_mod_name || '.out_parameter',
5870: 'x_warning_flag: ' || x_warning_flag);

Line 5868: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5864: END IF;
5865:
5866: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
5867: THEN
5868: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5869: lc_mod_name || '.out_parameter',
5870: 'x_warning_flag: ' || x_warning_flag);
5871: END IF;
5872: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

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

5868: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5869: lc_mod_name || '.out_parameter',
5870: 'x_warning_flag: ' || x_warning_flag);
5871: END IF;
5872: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5873: THEN
5874: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5875: lc_mod_name || '.END',
5876: 'Leaving CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_BOM');

Line 5874: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

5870: 'x_warning_flag: ' || x_warning_flag);
5871: END IF;
5872: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5873: THEN
5874: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5875: lc_mod_name || '.END',
5876: 'Leaving CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_BOM');
5877: END IF;
5878:

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

5893: WHEN CSD_EST_NO_AUTOGEN THEN
5894: x_warning_flag := Fnd_Api.G_TRUE;
5895:
5896: -- save message in fnd stack
5897: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
5898: THEN
5899: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5900: lc_mod_name,
5901: 'Adding message CSD_EST_NO_AUTOGEN to FND_MSG stack');

Line 5899: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5895:
5896: -- save message in fnd stack
5897: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
5898: THEN
5899: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5900: lc_mod_name,
5901: 'Adding message CSD_EST_NO_AUTOGEN to FND_MSG stack');
5902: END IF;
5903: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NO_AUTOGEN');

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

5905: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5906: p_data => x_msg_data);
5907:
5908: -- save message in debug log
5909: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5910: THEN
5911: Fnd_Log.STRING(Fnd_Log.Level_Exception,
5912: lc_mod_name,
5913: 'No estimate lines autogenerated');

Line 5911: Fnd_Log.STRING(Fnd_Log.Level_Exception,

5907:
5908: -- save message in debug log
5909: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5910: THEN
5911: Fnd_Log.STRING(Fnd_Log.Level_Exception,
5912: lc_mod_name,
5913: 'No estimate lines autogenerated');
5914: END IF;
5915: WHEN Fnd_Api.G_EXC_ERROR THEN

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

5918:
5919: /*
5920: -- TO DO: Add seeded err message
5921: -- save message in fnd stack
5922: if (Fnd_Log.Level_Statement>= Fnd_Log.G_Current_Runtime_Level) then
5923: FND_LOG.STRING(Fnd_Log.Level_Statement, lc_mod_name,
5924: 'Adding message err_name to FND_MSG stack');
5925: end if;
5926: FND_MESSAGE.SET_NAME('CSD','err_name');

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

5919: /*
5920: -- TO DO: Add seeded err message
5921: -- save message in fnd stack
5922: if (Fnd_Log.Level_Statement>= Fnd_Log.G_Current_Runtime_Level) then
5923: FND_LOG.STRING(Fnd_Log.Level_Statement, lc_mod_name,
5924: 'Adding message err_name to FND_MSG stack');
5925: end if;
5926: FND_MESSAGE.SET_NAME('CSD','err_name');
5927: FND_MESSAGE.SET_TOKEN('toke_name', 'token_value');

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

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

Line 5936: Fnd_Log.STRING(Fnd_Log.Level_Exception,

5932:
5933: -- save message in debug log
5934: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5935: THEN
5936: Fnd_Log.STRING(Fnd_Log.Level_Exception,
5937: lc_mod_name,
5938: 'EXC_ERROR[' || x_msg_data || ']');
5939: END IF;
5940:

Line 5948: IF (Fnd_Log.Level_Statement >=

5944:
5945: -- save message in fnd stack
5946: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5947: THEN
5948: IF (Fnd_Log.Level_Statement >=
5949: Fnd_Log.G_Current_Runtime_Level)
5950: THEN
5951: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5952: lc_mod_name,

Line 5949: Fnd_Log.G_Current_Runtime_Level)

5945: -- save message in fnd stack
5946: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5947: THEN
5948: IF (Fnd_Log.Level_Statement >=
5949: Fnd_Log.G_Current_Runtime_Level)
5950: THEN
5951: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5952: lc_mod_name,
5953: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 5951: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5947: THEN
5948: IF (Fnd_Log.Level_Statement >=
5949: Fnd_Log.G_Current_Runtime_Level)
5950: THEN
5951: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5952: lc_mod_name,
5953: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5954: END IF;
5955: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);

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

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

Line 5963: Fnd_Log.STRING(Fnd_Log.Level_Exception,

5959:
5960: -- save message in debug log
5961: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5962: THEN
5963: Fnd_Log.STRING(Fnd_Log.Level_Exception,
5964: lc_mod_name,
5965: 'EXC_UNEXPECTED_ERROR[' || x_msg_data || ']');
5966: END IF;
5967:

Line 5973: IF (Fnd_Log.Level_Statement >=

5969: ROLLBACK TO Get_Estimates_From_BOM;
5970: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5971: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5972: THEN
5973: IF (Fnd_Log.Level_Statement >=
5974: Fnd_Log.G_Current_Runtime_Level)
5975: THEN
5976: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5977: lc_mod_name,

Line 5974: Fnd_Log.G_Current_Runtime_Level)

5970: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5971: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5972: THEN
5973: IF (Fnd_Log.Level_Statement >=
5974: Fnd_Log.G_Current_Runtime_Level)
5975: THEN
5976: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5977: lc_mod_name,
5978: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 5976: Fnd_Log.STRING(Fnd_Log.Level_Statement,

5972: THEN
5973: IF (Fnd_Log.Level_Statement >=
5974: Fnd_Log.G_Current_Runtime_Level)
5975: THEN
5976: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5977: lc_mod_name,
5978: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5979: END IF;
5980: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);

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

5982: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5983: p_data => x_msg_data);
5984:
5985: -- save message in debug log
5986: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5987: THEN
5988: -- create a seeded message
5989: Fnd_Log.STRING(Fnd_Log.Level_Exception,
5990: lc_mod_name,

Line 5989: Fnd_Log.STRING(Fnd_Log.Level_Exception,

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

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

6029: p_MLE_lines_tbl IN MLE_LINES_TBL_TYPE,
6030: x_est_lines_tbl IN OUT NOCOPY REPAIR_ESTIMATE_LINE_TBL,
6031: x_warning_flag OUT NOCOPY VARCHAR2) IS
6032: -- CONSTANTS --
6033: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
6034: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
6035: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
6036: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
6037: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;

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

6030: x_est_lines_tbl IN OUT NOCOPY REPAIR_ESTIMATE_LINE_TBL,
6031: x_warning_flag OUT NOCOPY VARCHAR2) IS
6032: -- CONSTANTS --
6033: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
6034: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
6035: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
6036: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
6037: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
6038: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;

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

6031: x_warning_flag OUT NOCOPY VARCHAR2) IS
6032: -- CONSTANTS --
6033: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
6034: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
6035: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
6036: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
6037: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
6038: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
6039: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;

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

6032: -- CONSTANTS --
6033: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
6034: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
6035: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
6036: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
6037: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
6038: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
6039: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
6040: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.convert_to_est_lines';

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

6033: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
6034: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
6035: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
6036: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
6037: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
6038: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
6039: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
6040: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.convert_to_est_lines';
6041: lc_api_name CONSTANT VARCHAR2(30) := 'Convert_To_Est_Lines';

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

6034: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;
6035: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
6036: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
6037: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
6038: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
6039: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
6040: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.convert_to_est_lines';
6041: lc_api_name CONSTANT VARCHAR2(30) := 'Convert_To_Est_Lines';
6042: lc_api_version CONSTANT NUMBER := 1.0;

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

6035: lc_proc_level CONSTANT NUMBER := Fnd_Log.LEVEL_PROCEDURE;
6036: lc_event_level CONSTANT NUMBER := Fnd_Log.LEVEL_EVENT;
6037: lc_excep_level CONSTANT NUMBER := Fnd_Log.LEVEL_EXCEPTION;
6038: lc_error_level CONSTANT NUMBER := Fnd_Log.LEVEL_ERROR;
6039: lc_unexp_level CONSTANT NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
6040: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.convert_to_est_lines';
6041: lc_api_name CONSTANT VARCHAR2(30) := 'Convert_To_Est_Lines';
6042: lc_api_version CONSTANT NUMBER := 1.0;
6043:

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

6094: THEN
6095: Fnd_Msg_Pub.initialize;
6096: END IF;
6097:
6098: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
6099: THEN
6100: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6101: lc_mod_name || '.BEGIN',
6102: 'Entering CSD_REPAIR_ESTIMATE_PVT.Convert_To_Est_Lines');

Line 6100: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

6096: END IF;
6097:
6098: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
6099: THEN
6100: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6101: lc_mod_name || '.BEGIN',
6102: 'Entering CSD_REPAIR_ESTIMATE_PVT.Convert_To_Est_Lines');
6103: END IF;
6104: -- log parameters

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

6101: lc_mod_name || '.BEGIN',
6102: 'Entering CSD_REPAIR_ESTIMATE_PVT.Convert_To_Est_Lines');
6103: END IF;
6104: -- log parameters
6105: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
6106: THEN
6107: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6108: lc_mod_name || '.parameter_logging',
6109: 'p_api_version: ' || p_api_version);

Line 6107: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6103: END IF;
6104: -- log parameters
6105: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
6106: THEN
6107: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6108: lc_mod_name || '.parameter_logging',
6109: 'p_api_version: ' || p_api_version);
6110: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6111: lc_mod_name || '.parameter_logging',

Line 6110: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6106: THEN
6107: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6108: lc_mod_name || '.parameter_logging',
6109: 'p_api_version: ' || p_api_version);
6110: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6111: lc_mod_name || '.parameter_logging',
6112: 'p_commit: ' || p_commit);
6113: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6114: lc_mod_name || '.parameter_logging',

Line 6113: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6109: 'p_api_version: ' || p_api_version);
6110: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6111: lc_mod_name || '.parameter_logging',
6112: 'p_commit: ' || p_commit);
6113: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6114: lc_mod_name || '.parameter_logging',
6115: 'p_init_msg_list: ' || p_init_msg_list);
6116: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6117: lc_mod_name || '.parameter_logging',

Line 6116: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6112: 'p_commit: ' || p_commit);
6113: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6114: lc_mod_name || '.parameter_logging',
6115: 'p_init_msg_list: ' || p_init_msg_list);
6116: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6117: lc_mod_name || '.parameter_logging',
6118: 'p_validation_level: ' || p_validation_level);
6119: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6120: lc_mod_name || '.parameter_logging',

Line 6119: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6115: 'p_init_msg_list: ' || p_init_msg_list);
6116: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6117: lc_mod_name || '.parameter_logging',
6118: 'p_validation_level: ' || p_validation_level);
6119: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6120: lc_mod_name || '.parameter_logging',
6121: 'p_repair_line_id: ' || p_repair_line_id);
6122: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6123: lc_mod_name || '.parameter_logging',

Line 6122: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6118: 'p_validation_level: ' || p_validation_level);
6119: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6120: lc_mod_name || '.parameter_logging',
6121: 'p_repair_line_id: ' || p_repair_line_id);
6122: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6123: lc_mod_name || '.parameter_logging',
6124: 'p_estimate_id: ' || p_estimate_id);
6125: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6126: lc_mod_name || '.parameter_logging',

Line 6125: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6121: 'p_repair_line_id: ' || p_repair_line_id);
6122: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6123: lc_mod_name || '.parameter_logging',
6124: 'p_estimate_id: ' || p_estimate_id);
6125: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6126: lc_mod_name || '.parameter_logging',
6127: 'p_repair_type_id: ' || p_repair_type_id);
6128: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6129: lc_mod_name || '.parameter_logging',

Line 6128: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6124: 'p_estimate_id: ' || p_estimate_id);
6125: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6126: lc_mod_name || '.parameter_logging',
6127: 'p_repair_type_id: ' || p_repair_type_id);
6128: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6129: lc_mod_name || '.parameter_logging',
6130: 'p_business_process_id: ' ||
6131: p_business_process_id);
6132: Fnd_Log.STRING(Fnd_Log.Level_Statement,

Line 6132: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6128: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6129: lc_mod_name || '.parameter_logging',
6130: 'p_business_process_id: ' ||
6131: p_business_process_id);
6132: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6133: lc_mod_name || '.parameter_logging',
6134: 'p_currency_code: ' || p_currency_code);
6135: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6136: lc_mod_name || '.parameter_logging',

Line 6135: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6131: p_business_process_id);
6132: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6133: lc_mod_name || '.parameter_logging',
6134: 'p_currency_code: ' || p_currency_code);
6135: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6136: lc_mod_name || '.parameter_logging',
6137: 'p_incident_id: ' || p_incident_id);
6138: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6139: lc_mod_name || '.parameter_logging',

Line 6138: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6134: 'p_currency_code: ' || p_currency_code);
6135: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6136: lc_mod_name || '.parameter_logging',
6137: 'p_incident_id: ' || p_incident_id);
6138: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6139: lc_mod_name || '.parameter_logging',
6140: 'p_organization_id: ' || p_organization_id);
6141: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6142: lc_mod_name || '.parameter_logging',

Line 6141: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6137: 'p_incident_id: ' || p_incident_id);
6138: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6139: lc_mod_name || '.parameter_logging',
6140: 'p_organization_id: ' || p_organization_id);
6141: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6142: lc_mod_name || '.parameter_logging',
6143: 'p_price_list_id: ' || p_price_list_id);
6144: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6145: lc_mod_name || '.parameter_logging',

Line 6144: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6140: 'p_organization_id: ' || p_organization_id);
6141: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6142: lc_mod_name || '.parameter_logging',
6143: 'p_price_list_id: ' || p_price_list_id);
6144: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6145: lc_mod_name || '.parameter_logging',
6146: 'p_contract_line_id: ' || p_contract_line_id);
6147: END IF;
6148:

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

6161: l_numRows := p_MLE_lines_tbl.COUNT;
6162: FOR i IN 1 .. l_numRows
6163: LOOP
6164: l_error := FALSE;
6165: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
6166: THEN
6167: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6168: lc_mod_name,
6169: 'Processing MLE line ' || i);

Line 6167: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

6163: LOOP
6164: l_error := FALSE;
6165: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
6166: THEN
6167: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6168: lc_mod_name,
6169: 'Processing MLE line ' || i);
6170: END IF;
6171:

Line 6180: IF (Fnd_Log.Level_Procedure >=

6176: -- get the selling price of the item
6177: -- if no selling price, then we cannot determine charge, so
6178: -- log a warning.
6179: BEGIN
6180: IF (Fnd_Log.Level_Procedure >=
6181: Fnd_Log.G_Current_Runtime_Level)
6182: THEN
6183: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6184: lc_mod_name,

Line 6181: Fnd_Log.G_Current_Runtime_Level)

6177: -- if no selling price, then we cannot determine charge, so
6178: -- log a warning.
6179: BEGIN
6180: IF (Fnd_Log.Level_Procedure >=
6181: Fnd_Log.G_Current_Runtime_Level)
6182: THEN
6183: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6184: lc_mod_name,
6185: 'Calling CSD_PROCESS_UTIL.get_charge_selling_price');

Line 6183: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

6179: BEGIN
6180: IF (Fnd_Log.Level_Procedure >=
6181: Fnd_Log.G_Current_Runtime_Level)
6182: THEN
6183: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6184: lc_mod_name,
6185: 'Calling CSD_PROCESS_UTIL.get_charge_selling_price');
6186: END IF;
6187:

Line 6201: IF (Fnd_Log.Level_Procedure >=

6197: x_selling_price => l_selling_price,
6198: x_return_status => l_return_status,
6199: x_msg_count => l_msg_count,
6200: x_msg_data => l_msg_data);
6201: IF (Fnd_Log.Level_Procedure >=
6202: Fnd_Log.G_Current_Runtime_Level)
6203: THEN
6204: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6205: lc_mod_name,

Line 6202: Fnd_Log.G_Current_Runtime_Level)

6198: x_return_status => l_return_status,
6199: x_msg_count => l_msg_count,
6200: x_msg_data => l_msg_data);
6201: IF (Fnd_Log.Level_Procedure >=
6202: Fnd_Log.G_Current_Runtime_Level)
6203: THEN
6204: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6205: lc_mod_name,
6206: 'Returned from CSD_PROCESS_UTIL.get_charge_selling_price');

Line 6204: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

6200: x_msg_data => l_msg_data);
6201: IF (Fnd_Log.Level_Procedure >=
6202: Fnd_Log.G_Current_Runtime_Level)
6203: THEN
6204: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6205: lc_mod_name,
6206: 'Returned from CSD_PROCESS_UTIL.get_charge_selling_price');
6207: END IF;
6208: IF (Fnd_Log.Level_Statement >=

Line 6208: IF (Fnd_Log.Level_Statement >=

6204: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6205: lc_mod_name,
6206: 'Returned from CSD_PROCESS_UTIL.get_charge_selling_price');
6207: END IF;
6208: IF (Fnd_Log.Level_Statement >=
6209: Fnd_Log.G_Current_Runtime_Level)
6210: THEN
6211: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6212: lc_mod_name,

Line 6209: Fnd_Log.G_Current_Runtime_Level)

6205: lc_mod_name,
6206: 'Returned from CSD_PROCESS_UTIL.get_charge_selling_price');
6207: END IF;
6208: IF (Fnd_Log.Level_Statement >=
6209: Fnd_Log.G_Current_Runtime_Level)
6210: THEN
6211: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6212: lc_mod_name,
6213: 'l_selling_price = ' || l_selling_price);

Line 6211: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6207: END IF;
6208: IF (Fnd_Log.Level_Statement >=
6209: Fnd_Log.G_Current_Runtime_Level)
6210: THEN
6211: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6212: lc_mod_name,
6213: 'l_selling_price = ' || l_selling_price);
6214: END IF;
6215: EXCEPTION

Line 6218: IF (Fnd_Log.Level_Procedure >=

6214: END IF;
6215: EXCEPTION
6216: WHEN Fnd_Api.G_EXC_ERROR THEN
6217: l_return_status := Fnd_Api.G_RET_STS_ERROR;
6218: IF (Fnd_Log.Level_Procedure >=
6219: Fnd_Log.G_Current_Runtime_Level)
6220: THEN
6221: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6222: lc_mod_name,

Line 6219: Fnd_Log.G_Current_Runtime_Level)

6215: EXCEPTION
6216: WHEN Fnd_Api.G_EXC_ERROR THEN
6217: l_return_status := Fnd_Api.G_RET_STS_ERROR;
6218: IF (Fnd_Log.Level_Procedure >=
6219: Fnd_Log.G_Current_Runtime_Level)
6220: THEN
6221: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6222: lc_mod_name,
6223: 'Exception FND_API.G_EXC_ERROR occurred in CSD_PROCESS_UTIL.get_charge_selling_price');

Line 6221: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

6217: l_return_status := Fnd_Api.G_RET_STS_ERROR;
6218: IF (Fnd_Log.Level_Procedure >=
6219: Fnd_Log.G_Current_Runtime_Level)
6220: THEN
6221: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6222: lc_mod_name,
6223: 'Exception FND_API.G_EXC_ERROR occurred in CSD_PROCESS_UTIL.get_charge_selling_price');
6224: END IF;
6225: WHEN OTHERS THEN

Line 6227: IF (Fnd_Log.Level_Procedure >=

6223: 'Exception FND_API.G_EXC_ERROR occurred in CSD_PROCESS_UTIL.get_charge_selling_price');
6224: END IF;
6225: WHEN OTHERS THEN
6226: l_return_status := Fnd_Api.G_RET_STS_ERROR;
6227: IF (Fnd_Log.Level_Procedure >=
6228: Fnd_Log.G_Current_Runtime_Level)
6229: THEN
6230: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6231: lc_mod_name,

Line 6228: Fnd_Log.G_Current_Runtime_Level)

6224: END IF;
6225: WHEN OTHERS THEN
6226: l_return_status := Fnd_Api.G_RET_STS_ERROR;
6227: IF (Fnd_Log.Level_Procedure >=
6228: Fnd_Log.G_Current_Runtime_Level)
6229: THEN
6230: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6231: lc_mod_name,
6232: 'Exception OTHERS occurred in CSD_PROCESS_UTIL.get_charge_selling_price');

Line 6230: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

6226: l_return_status := Fnd_Api.G_RET_STS_ERROR;
6227: IF (Fnd_Log.Level_Procedure >=
6228: Fnd_Log.G_Current_Runtime_Level)
6229: THEN
6230: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6231: lc_mod_name,
6232: 'Exception OTHERS occurred in CSD_PROCESS_UTIL.get_charge_selling_price');
6233: END IF;
6234: END;

Line 6239: IF (Fnd_Log.Level_Statement >=

6235:
6236: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS) OR
6237: (l_selling_price IS NULL)
6238: THEN
6239: IF (Fnd_Log.Level_Statement >=
6240: Fnd_Log.G_Current_Runtime_Level)
6241: THEN
6242: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6243: lc_mod_name,

Line 6240: Fnd_Log.G_Current_Runtime_Level)

6236: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS) OR
6237: (l_selling_price IS NULL)
6238: THEN
6239: IF (Fnd_Log.Level_Statement >=
6240: Fnd_Log.G_Current_Runtime_Level)
6241: THEN
6242: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6243: lc_mod_name,
6244: 'Adding message CSD_EST_NOPRICE_ITEM_UOM to FND_MSG stack');

Line 6242: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6238: THEN
6239: IF (Fnd_Log.Level_Statement >=
6240: Fnd_Log.G_Current_Runtime_Level)
6241: THEN
6242: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6243: lc_mod_name,
6244: 'Adding message CSD_EST_NOPRICE_ITEM_UOM to FND_MSG stack');
6245: END IF;
6246: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NOPRICE_ITEM_UOM');

Line 6255: IF (Fnd_Log.Level_Procedure >=

6251: WHERE list_header_id = p_price_list_id;
6252: EXCEPTION
6253: WHEN NO_DATA_FOUND THEN
6254: l_price_list_name := p_price_list_id;
6255: IF (Fnd_Log.Level_Procedure >=
6256: Fnd_Log.G_Current_Runtime_Level)
6257: THEN
6258: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6259: lc_mod_name,

Line 6256: Fnd_Log.G_Current_Runtime_Level)

6252: EXCEPTION
6253: WHEN NO_DATA_FOUND THEN
6254: l_price_list_name := p_price_list_id;
6255: IF (Fnd_Log.Level_Procedure >=
6256: Fnd_Log.G_Current_Runtime_Level)
6257: THEN
6258: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6259: lc_mod_name,
6260: 'Exception NO_DATA_FOUND occurred while querying for price list name');

Line 6258: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

6254: l_price_list_name := p_price_list_id;
6255: IF (Fnd_Log.Level_Procedure >=
6256: Fnd_Log.G_Current_Runtime_Level)
6257: THEN
6258: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6259: lc_mod_name,
6260: 'Exception NO_DATA_FOUND occurred while querying for price list name');
6261: END IF;
6262: WHEN OTHERS THEN

Line 6264: IF (Fnd_Log.Level_Procedure >=

6260: 'Exception NO_DATA_FOUND occurred while querying for price list name');
6261: END IF;
6262: WHEN OTHERS THEN
6263: l_price_list_name := p_price_list_id;
6264: IF (Fnd_Log.Level_Procedure >=
6265: Fnd_Log.G_Current_Runtime_Level)
6266: THEN
6267: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6268: lc_mod_name,

Line 6265: Fnd_Log.G_Current_Runtime_Level)

6261: END IF;
6262: WHEN OTHERS THEN
6263: l_price_list_name := p_price_list_id;
6264: IF (Fnd_Log.Level_Procedure >=
6265: Fnd_Log.G_Current_Runtime_Level)
6266: THEN
6267: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6268: lc_mod_name,
6269: 'Exception OTHERS occurred while querying for price list name');

Line 6267: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

6263: l_price_list_name := p_price_list_id;
6264: IF (Fnd_Log.Level_Procedure >=
6265: Fnd_Log.G_Current_Runtime_Level)
6266: THEN
6267: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6268: lc_mod_name,
6269: 'Exception OTHERS occurred while querying for price list name');
6270: END IF;
6271: END;

Line 6277: IF (Fnd_Log.Level_Statement >=

6273: Fnd_Message.SET_TOKEN('PRICELIST', l_price_list_name);
6274: Fnd_Message.SET_TOKEN('UOM', p_MLE_lines_tbl(i).uom);
6275: Fnd_Msg_Pub.ADD;
6276: l_error := TRUE;
6277: IF (Fnd_Log.Level_Statement >=
6278: Fnd_Log.G_Current_Runtime_Level)
6279: THEN
6280: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6281: lc_mod_name,

Line 6278: Fnd_Log.G_Current_Runtime_Level)

6274: Fnd_Message.SET_TOKEN('UOM', p_MLE_lines_tbl(i).uom);
6275: Fnd_Msg_Pub.ADD;
6276: l_error := TRUE;
6277: IF (Fnd_Log.Level_Statement >=
6278: Fnd_Log.G_Current_Runtime_Level)
6279: THEN
6280: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6281: lc_mod_name,
6282: 'Unable to get price for item-uom combination in pricelist ' ||

Line 6280: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6276: l_error := TRUE;
6277: IF (Fnd_Log.Level_Statement >=
6278: Fnd_Log.G_Current_Runtime_Level)
6279: THEN
6280: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6281: lc_mod_name,
6282: 'Unable to get price for item-uom combination in pricelist ' ||
6283: p_price_list_id);
6284: END IF;

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

6284: END IF;
6285: END IF;
6286:
6287: -- check txn billing type
6288: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
6289: THEN
6290: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6291: lc_mod_name,
6292: 'Checking for required txn billing type id');

Line 6290: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

6286:
6287: -- check txn billing type
6288: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
6289: THEN
6290: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6291: lc_mod_name,
6292: 'Checking for required txn billing type id');
6293: END IF;
6294: IF (p_MLE_lines_tbl(i).txn_billing_type_id IS NULL)

Line 6296: IF (Fnd_Log.Level_Statement >=

6292: 'Checking for required txn billing type id');
6293: END IF;
6294: IF (p_MLE_lines_tbl(i).txn_billing_type_id IS NULL)
6295: THEN
6296: IF (Fnd_Log.Level_Statement >=
6297: Fnd_Log.G_Current_Runtime_Level)
6298: THEN
6299: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6300: lc_mod_name,

Line 6297: Fnd_Log.G_Current_Runtime_Level)

6293: END IF;
6294: IF (p_MLE_lines_tbl(i).txn_billing_type_id IS NULL)
6295: THEN
6296: IF (Fnd_Log.Level_Statement >=
6297: Fnd_Log.G_Current_Runtime_Level)
6298: THEN
6299: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6300: lc_mod_name,
6301: 'Adding message CSD_EST_NO_ITEM_SAR to FND_MSG stack');

Line 6299: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6295: THEN
6296: IF (Fnd_Log.Level_Statement >=
6297: Fnd_Log.G_Current_Runtime_Level)
6298: THEN
6299: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6300: lc_mod_name,
6301: 'Adding message CSD_EST_NO_ITEM_SAR to FND_MSG stack');
6302: END IF;
6303: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NO_ITEM_SAR');

Line 6307: IF (Fnd_Log.Level_Statement >=

6303: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NO_ITEM_SAR');
6304: Fnd_Message.SET_TOKEN('ITEM', p_MLE_lines_tbl(i).item_name);
6305: Fnd_Msg_Pub.ADD;
6306: l_error := TRUE;
6307: IF (Fnd_Log.Level_Statement >=
6308: Fnd_Log.G_Current_Runtime_Level)
6309: THEN
6310: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6311: lc_mod_name,

Line 6308: Fnd_Log.G_Current_Runtime_Level)

6304: Fnd_Message.SET_TOKEN('ITEM', p_MLE_lines_tbl(i).item_name);
6305: Fnd_Msg_Pub.ADD;
6306: l_error := TRUE;
6307: IF (Fnd_Log.Level_Statement >=
6308: Fnd_Log.G_Current_Runtime_Level)
6309: THEN
6310: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6311: lc_mod_name,
6312: 'Error - txn_billing_type_id is null');

Line 6310: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6306: l_error := TRUE;
6307: IF (Fnd_Log.Level_Statement >=
6308: Fnd_Log.G_Current_Runtime_Level)
6309: THEN
6310: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6311: lc_mod_name,
6312: 'Error - txn_billing_type_id is null');
6313: ELSE
6314: IF (Fnd_Log.Level_Procedure >=

Line 6314: IF (Fnd_Log.Level_Procedure >=

6310: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6311: lc_mod_name,
6312: 'Error - txn_billing_type_id is null');
6313: ELSE
6314: IF (Fnd_Log.Level_Procedure >=
6315: Fnd_Log.G_Current_Runtime_Level)
6316: THEN
6317: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6318: lc_mod_name,

Line 6315: Fnd_Log.G_Current_Runtime_Level)

6311: lc_mod_name,
6312: 'Error - txn_billing_type_id is null');
6313: ELSE
6314: IF (Fnd_Log.Level_Procedure >=
6315: Fnd_Log.G_Current_Runtime_Level)
6316: THEN
6317: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6318: lc_mod_name,
6319: 'Txn billing type id is available');

Line 6317: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

6313: ELSE
6314: IF (Fnd_Log.Level_Procedure >=
6315: Fnd_Log.G_Current_Runtime_Level)
6316: THEN
6317: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6318: lc_mod_name,
6319: 'Txn billing type id is available');
6320: END IF;
6321: END IF;

Line 6331: IF (Fnd_Log.Level_Procedure >=

6327: l_curRow := x_est_lines_tbl.COUNT + 1;
6328:
6329: -- default no_charge if it is set up in charges
6330: -- this is probably a rare case
6331: IF (Fnd_Log.Level_Procedure >=
6332: Fnd_Log.G_Current_Runtime_Level)
6333: THEN
6334: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6335: lc_mod_name,

Line 6332: Fnd_Log.G_Current_Runtime_Level)

6328:
6329: -- default no_charge if it is set up in charges
6330: -- this is probably a rare case
6331: IF (Fnd_Log.Level_Procedure >=
6332: Fnd_Log.G_Current_Runtime_Level)
6333: THEN
6334: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6335: lc_mod_name,
6336: 'Getting no charge flag to determine extended price');

Line 6334: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

6330: -- this is probably a rare case
6331: IF (Fnd_Log.Level_Procedure >=
6332: Fnd_Log.G_Current_Runtime_Level)
6333: THEN
6334: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6335: lc_mod_name,
6336: 'Getting no charge flag to determine extended price');
6337: END IF;
6338: l_no_charge_flag := Csd_Process_Util.Get_No_Chg_Flag(p_MLE_lines_tbl(i)

Line 6349: IF (Fnd_Log.Level_Statement >=

6345: -- bugfix 3468680 vkjain. Using the price from the Pricing Engine API.
6346: l_ext_price := NVL(p_MLE_lines_tbl(i).quantity, 0) *
6347: l_selling_price;
6348: END IF;
6349: IF (Fnd_Log.Level_Statement >=
6350: Fnd_Log.G_Current_Runtime_Level)
6351: THEN
6352: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6353: lc_mod_name,

Line 6350: Fnd_Log.G_Current_Runtime_Level)

6346: l_ext_price := NVL(p_MLE_lines_tbl(i).quantity, 0) *
6347: l_selling_price;
6348: END IF;
6349: IF (Fnd_Log.Level_Statement >=
6350: Fnd_Log.G_Current_Runtime_Level)
6351: THEN
6352: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6353: lc_mod_name,
6354: 'l_no_charge_flag = ' ||

Line 6352: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6348: END IF;
6349: IF (Fnd_Log.Level_Statement >=
6350: Fnd_Log.G_Current_Runtime_Level)
6351: THEN
6352: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6353: lc_mod_name,
6354: 'l_no_charge_flag = ' ||
6355: l_no_charge_flag);
6356: Fnd_Log.STRING(Fnd_Log.Level_Statement,

Line 6356: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6352: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6353: lc_mod_name,
6354: 'l_no_charge_flag = ' ||
6355: l_no_charge_flag);
6356: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6357: lc_mod_name,
6358: 'l_ext_price = ' || l_ext_price);
6359: END IF;
6360:

Line 6372: IF (Fnd_Log.Level_Procedure >=

6368: (p_business_process_id IS NOT NULL) AND
6369: (NVL(l_no_charge_flag, 'N') = 'N')
6370: THEN
6371: BEGIN
6372: IF (Fnd_Log.Level_Procedure >=
6373: Fnd_Log.G_Current_Runtime_Level)
6374: THEN
6375: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6376: lc_mod_name,

Line 6373: Fnd_Log.G_Current_Runtime_Level)

6369: (NVL(l_no_charge_flag, 'N') = 'N')
6370: THEN
6371: BEGIN
6372: IF (Fnd_Log.Level_Procedure >=
6373: Fnd_Log.G_Current_Runtime_Level)
6374: THEN
6375: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6376: lc_mod_name,
6377: 'Calling CSD_CHARGE_LINE_UTIL.Get_CoverageInfo');

Line 6375: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

6371: BEGIN
6372: IF (Fnd_Log.Level_Procedure >=
6373: Fnd_Log.G_Current_Runtime_Level)
6374: THEN
6375: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6376: lc_mod_name,
6377: 'Calling CSD_CHARGE_LINE_UTIL.Get_CoverageInfo');
6378: END IF;
6379: Csd_Charge_Line_Util.Get_CoverageInfo(p_contract_line_id => p_contract_line_id,

Line 6392: IF (Fnd_Log.Level_Statement >=

6388: x_coverage_id => x_est_lines_tbl(l_curRow)
6389: .coverage_id,
6390: x_coverage_txn_group_id => x_est_lines_tbl(l_curRow)
6391: .coverage_txn_group_id);
6392: IF (Fnd_Log.Level_Statement >=
6393: Fnd_Log.G_Current_Runtime_Level)
6394: THEN
6395: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6396: lc_mod_name,

Line 6393: Fnd_Log.G_Current_Runtime_Level)

6389: .coverage_id,
6390: x_coverage_txn_group_id => x_est_lines_tbl(l_curRow)
6391: .coverage_txn_group_id);
6392: IF (Fnd_Log.Level_Statement >=
6393: Fnd_Log.G_Current_Runtime_Level)
6394: THEN
6395: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6396: lc_mod_name,
6397: 'x_contract_id = ' ||

Line 6395: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6391: .coverage_txn_group_id);
6392: IF (Fnd_Log.Level_Statement >=
6393: Fnd_Log.G_Current_Runtime_Level)
6394: THEN
6395: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6396: lc_mod_name,
6397: 'x_contract_id = ' ||
6398: x_est_lines_tbl(l_curRow)
6399: .contract_id);

Line 6400: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6396: lc_mod_name,
6397: 'x_contract_id = ' ||
6398: x_est_lines_tbl(l_curRow)
6399: .contract_id);
6400: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6401: lc_mod_name,
6402: 'x_contract_number = ' ||
6403: x_est_lines_tbl(l_curRow)
6404: .contract_number);

Line 6405: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6401: lc_mod_name,
6402: 'x_contract_number = ' ||
6403: x_est_lines_tbl(l_curRow)
6404: .contract_number);
6405: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6406: lc_mod_name,
6407: 'x_coverage_id = ' ||
6408: x_est_lines_tbl(l_curRow)
6409: .coverage_id);

Line 6410: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6406: lc_mod_name,
6407: 'x_coverage_id = ' ||
6408: x_est_lines_tbl(l_curRow)
6409: .coverage_id);
6410: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6411: lc_mod_name,
6412: 'x_coverage_txn_group_id = ' ||
6413: x_est_lines_tbl(l_curRow)
6414: .coverage_txn_group_id);

Line 6430: IF (Fnd_Log.Level_Procedure >=

6426: l_error := TRUE;
6427: END IF;
6428:
6429: BEGIN
6430: IF (Fnd_Log.Level_Procedure >=
6431: Fnd_Log.G_Current_Runtime_Level)
6432: THEN
6433: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6434: lc_mod_name,

Line 6431: Fnd_Log.G_Current_Runtime_Level)

6427: END IF;
6428:
6429: BEGIN
6430: IF (Fnd_Log.Level_Procedure >=
6431: Fnd_Log.G_Current_Runtime_Level)
6432: THEN
6433: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6434: lc_mod_name,
6435: 'Calling CSD_CHARGE_LINE_UTIL.get_discountedprice');

Line 6433: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

6429: BEGIN
6430: IF (Fnd_Log.Level_Procedure >=
6431: Fnd_Log.G_Current_Runtime_Level)
6432: THEN
6433: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6434: lc_mod_name,
6435: 'Calling CSD_CHARGE_LINE_UTIL.get_discountedprice');
6436: END IF;
6437: Csd_Charge_Line_Util.GET_DISCOUNTEDPRICE(p_api_version => 1.0,

Line 6452: IF (Fnd_Log.Level_Statement >=

6448: .after_warranty_cost,
6449: x_return_status => l_return_status,
6450: x_msg_count => l_msg_count,
6451: x_msg_data => l_msg_data);
6452: IF (Fnd_Log.Level_Statement >=
6453: Fnd_Log.G_Current_Runtime_Level)
6454: THEN
6455: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6456: lc_mod_name,

Line 6453: Fnd_Log.G_Current_Runtime_Level)

6449: x_return_status => l_return_status,
6450: x_msg_count => l_msg_count,
6451: x_msg_data => l_msg_data);
6452: IF (Fnd_Log.Level_Statement >=
6453: Fnd_Log.G_Current_Runtime_Level)
6454: THEN
6455: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6456: lc_mod_name,
6457: 'x_discounted_price = ' ||

Line 6455: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6451: x_msg_data => l_msg_data);
6452: IF (Fnd_Log.Level_Statement >=
6453: Fnd_Log.G_Current_Runtime_Level)
6454: THEN
6455: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6456: lc_mod_name,
6457: 'x_discounted_price = ' ||
6458: x_est_lines_tbl(l_curRow)
6459: .after_warranty_cost);

Line 6469: IF (Fnd_Log.Level_Statement >=

6465: l_return_status := Fnd_Api.G_RET_STS_ERROR;
6466: END;
6467: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS)
6468: THEN
6469: IF (Fnd_Log.Level_Statement >=
6470: Fnd_Log.G_Current_Runtime_Level)
6471: THEN
6472: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6473: lc_mod_name,

Line 6470: Fnd_Log.G_Current_Runtime_Level)

6466: END;
6467: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS)
6468: THEN
6469: IF (Fnd_Log.Level_Statement >=
6470: Fnd_Log.G_Current_Runtime_Level)
6471: THEN
6472: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6473: lc_mod_name,
6474: 'Adding message CSD_EST_ESTIMATED_CHARGE_ERR to FND_MSG stack');

Line 6472: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6468: THEN
6469: IF (Fnd_Log.Level_Statement >=
6470: Fnd_Log.G_Current_Runtime_Level)
6471: THEN
6472: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6473: lc_mod_name,
6474: 'Adding message CSD_EST_ESTIMATED_CHARGE_ERR to FND_MSG stack');
6475: END IF;
6476: Fnd_Message.SET_NAME('CSD',

Line 6501: IF (Fnd_Log.Level_Procedure >=

6497: x_est_lines_tbl(l_curRow).resource_id := p_MLE_lines_tbl(i)
6498: .resource_id;
6499:
6500: BEGIN
6501: IF (Fnd_Log.Level_Procedure >=
6502: Fnd_Log.G_Current_Runtime_Level)
6503: THEN
6504: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6505: lc_mod_name,

Line 6502: Fnd_Log.G_Current_Runtime_Level)

6498: .resource_id;
6499:
6500: BEGIN
6501: IF (Fnd_Log.Level_Procedure >=
6502: Fnd_Log.G_Current_Runtime_Level)
6503: THEN
6504: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6505: lc_mod_name,
6506: 'Calling CSD_COST_ANALYSIS_PVT.arcs in forms/US/CSDREPLN.fmb

Line 6504: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

6500: BEGIN
6501: IF (Fnd_Log.Level_Procedure >=
6502: Fnd_Log.G_Current_Runtime_Level)
6503: THEN
6504: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6505: lc_mod_name,
6506: 'Calling CSD_COST_ANALYSIS_PVT.arcs in forms/US/CSDREPLN.fmb
6507: ItemCost');
6508: END IF;

Line 6535: IF (Fnd_Log.Level_Statement >=

6531: p_currency_code => p_currency_code,
6532: p_chg_line_uom_code => p_MLE_lines_tbl(i).uom, --sangigup 3356020
6533: x_item_cost => x_est_lines_tbl(l_curRow)
6534: .item_cost);
6535: IF (Fnd_Log.Level_Statement >=
6536: Fnd_Log.G_Current_Runtime_Level)
6537: THEN
6538: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6539: lc_mod_name,

Line 6536: Fnd_Log.G_Current_Runtime_Level)

6532: p_chg_line_uom_code => p_MLE_lines_tbl(i).uom, --sangigup 3356020
6533: x_item_cost => x_est_lines_tbl(l_curRow)
6534: .item_cost);
6535: IF (Fnd_Log.Level_Statement >=
6536: Fnd_Log.G_Current_Runtime_Level)
6537: THEN
6538: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6539: lc_mod_name,
6540: 'x_item_cost = ' ||

Line 6538: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6534: .item_cost);
6535: IF (Fnd_Log.Level_Statement >=
6536: Fnd_Log.G_Current_Runtime_Level)
6537: THEN
6538: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6539: lc_mod_name,
6540: 'x_item_cost = ' ||
6541: x_est_lines_tbl(l_curRow).item_cost);
6542: END IF;

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

6553: --
6554: -- TO DO: give warning message that cost could not be determined?
6555: -- x_warning_flag := FND_API.G_TRUE;
6556: -- x_return_status := FND_API.G_RET_STS_ERROR;
6557: -- if (Fnd_Log.Level_Statement>= Fnd_Log.G_Current_Runtime_Level) then
6558: -- FND_LOG.STRING(Fnd_Log.Level_Statement, lc_mod_name,
6559: -- 'Adding message CSD_EST_ESTIMATED_CHARGE_ERR to FND_MSG stack');
6560: -- end if;
6561: -- FND_MESSAGE.SET_NAME('CSD','CSD_EST_ESTIMATED_CHARGE_ERR');

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

6554: -- TO DO: give warning message that cost could not be determined?
6555: -- x_warning_flag := FND_API.G_TRUE;
6556: -- x_return_status := FND_API.G_RET_STS_ERROR;
6557: -- if (Fnd_Log.Level_Statement>= Fnd_Log.G_Current_Runtime_Level) then
6558: -- FND_LOG.STRING(Fnd_Log.Level_Statement, lc_mod_name,
6559: -- 'Adding message CSD_EST_ESTIMATED_CHARGE_ERR to FND_MSG stack');
6560: -- end if;
6561: -- FND_MESSAGE.SET_NAME('CSD','CSD_EST_ESTIMATED_CHARGE_ERR');
6562: -- FND_MESSAGE.SET_TOKEN('CONTRACT_NUMBER',x_est_lines_tbl(l_curRow).contract_number);

Line 6568: IF (Fnd_Log.Level_Procedure >=

6564: -- l_error := TRUE;
6565: END IF;
6566:
6567: -- set transaction type (Material, labor, expense)
6568: IF (Fnd_Log.Level_Procedure >=
6569: Fnd_Log.G_Current_Runtime_Level)
6570: THEN
6571: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6572: lc_mod_name,

Line 6569: Fnd_Log.G_Current_Runtime_Level)

6565: END IF;
6566:
6567: -- set transaction type (Material, labor, expense)
6568: IF (Fnd_Log.Level_Procedure >=
6569: Fnd_Log.G_Current_Runtime_Level)
6570: THEN
6571: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6572: lc_mod_name,
6573: 'Getting transaction type id');

Line 6571: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

6567: -- set transaction type (Material, labor, expense)
6568: IF (Fnd_Log.Level_Procedure >=
6569: Fnd_Log.G_Current_Runtime_Level)
6570: THEN
6571: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6572: lc_mod_name,
6573: 'Getting transaction type id');
6574: END IF;
6575: OPEN c_transaction_type(p_MLE_lines_tbl(i)

Line 6658: IF (Fnd_Log.Level_Procedure >=

6654: -- since the above section could potentially set l_error=TRUE as well.
6655: IF (l_error = TRUE)
6656: THEN
6657: x_warning_flag := Fnd_Api.G_TRUE;
6658: IF (Fnd_Log.Level_Procedure >=
6659: Fnd_Log.G_Current_Runtime_Level)
6660: THEN
6661: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6662: lc_mod_name,

Line 6659: Fnd_Log.G_Current_Runtime_Level)

6655: IF (l_error = TRUE)
6656: THEN
6657: x_warning_flag := Fnd_Api.G_TRUE;
6658: IF (Fnd_Log.Level_Procedure >=
6659: Fnd_Log.G_Current_Runtime_Level)
6660: THEN
6661: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6662: lc_mod_name,
6663: 'Calling CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');

Line 6661: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

6657: x_warning_flag := Fnd_Api.G_TRUE;
6658: IF (Fnd_Log.Level_Procedure >=
6659: Fnd_Log.G_Current_Runtime_Level)
6660: THEN
6661: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6662: lc_mod_name,
6663: 'Calling CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
6664: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6665: lc_mod_name,

Line 6664: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

6660: THEN
6661: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6662: lc_mod_name,
6663: 'Calling CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
6664: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6665: lc_mod_name,
6666: 'Number of messages in stack: ' ||
6667: Fnd_Msg_Pub.count_msg);
6668: END IF;

Line 6686: IF (Fnd_Log.Level_Procedure >=

6682: IF NOT (l_return_status = Fnd_Api.G_RET_STS_SUCCESS)
6683: THEN
6684: RAISE Fnd_Api.G_EXC_ERROR;
6685: END IF;
6686: IF (Fnd_Log.Level_Procedure >=
6687: Fnd_Log.G_Current_Runtime_Level)
6688: THEN
6689: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6690: lc_mod_name,

Line 6687: Fnd_Log.G_Current_Runtime_Level)

6683: THEN
6684: RAISE Fnd_Api.G_EXC_ERROR;
6685: END IF;
6686: IF (Fnd_Log.Level_Procedure >=
6687: Fnd_Log.G_Current_Runtime_Level)
6688: THEN
6689: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6690: lc_mod_name,
6691: 'Returned from CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');

Line 6689: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

6685: END IF;
6686: IF (Fnd_Log.Level_Procedure >=
6687: Fnd_Log.G_Current_Runtime_Level)
6688: THEN
6689: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6690: lc_mod_name,
6691: 'Returned from CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
6692: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6693: lc_mod_name,

Line 6692: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

6688: THEN
6689: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6690: lc_mod_name,
6691: 'Returned from CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
6692: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6693: lc_mod_name,
6694: 'Number of messages in stack: ' ||
6695: Fnd_Msg_Pub.count_msg);
6696: END IF;

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

6696: END IF;
6697: END IF;
6698: END LOOP;
6699:
6700: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
6701: THEN
6702: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6703: lc_mod_name || '.out_parameter',
6704: 'x_warning_flag: ' || x_warning_flag);

Line 6702: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6698: END LOOP;
6699:
6700: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
6701: THEN
6702: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6703: lc_mod_name || '.out_parameter',
6704: 'x_warning_flag: ' || x_warning_flag);
6705: END IF;
6706: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

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

6702: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6703: lc_mod_name || '.out_parameter',
6704: 'x_warning_flag: ' || x_warning_flag);
6705: END IF;
6706: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
6707: THEN
6708: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6709: lc_mod_name || '.END',
6710: 'Leaving CSD_REPAIR_ESTIMATE_PVT.Convert_To_Est_Lines');

Line 6708: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

6704: 'x_warning_flag: ' || x_warning_flag);
6705: END IF;
6706: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
6707: THEN
6708: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6709: lc_mod_name || '.END',
6710: 'Leaving CSD_REPAIR_ESTIMATE_PVT.Convert_To_Est_Lines');
6711: END IF;
6712:

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

6730:
6731: /*
6732: -- TO DO: Add seeded err message
6733: -- save message in fnd stack
6734: if (Fnd_Log.Level_Statement>= Fnd_Log.G_Current_Runtime_Level) then
6735: FND_LOG.STRING(Fnd_Log.Level_Statement, lc_mod_name,
6736: 'Adding message err_name to FND_MSG stack');
6737: end if;
6738: FND_MESSAGE.SET_NAME('CSD','err_name');

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

6731: /*
6732: -- TO DO: Add seeded err message
6733: -- save message in fnd stack
6734: if (Fnd_Log.Level_Statement>= Fnd_Log.G_Current_Runtime_Level) then
6735: FND_LOG.STRING(Fnd_Log.Level_Statement, lc_mod_name,
6736: 'Adding message err_name to FND_MSG stack');
6737: end if;
6738: FND_MESSAGE.SET_NAME('CSD','err_name');
6739: FND_MESSAGE.SET_TOKEN('toke_name', 'token_value');

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

6742: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6743: p_data => x_msg_data);
6744:
6745: -- save message in debug log
6746: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
6747: THEN
6748: Fnd_Log.STRING(Fnd_Log.Level_Exception,
6749: lc_mod_name,
6750: 'EXC_ERROR[' || x_msg_data || ']');

Line 6748: Fnd_Log.STRING(Fnd_Log.Level_Exception,

6744:
6745: -- save message in debug log
6746: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
6747: THEN
6748: Fnd_Log.STRING(Fnd_Log.Level_Exception,
6749: lc_mod_name,
6750: 'EXC_ERROR[' || x_msg_data || ']');
6751: END IF;
6752: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 6759: IF (Fnd_Log.Level_Statement >=

6755:
6756: -- save message in fnd stack
6757: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
6758: THEN
6759: IF (Fnd_Log.Level_Statement >=
6760: Fnd_Log.G_Current_Runtime_Level)
6761: THEN
6762: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6763: lc_mod_name,

Line 6760: Fnd_Log.G_Current_Runtime_Level)

6756: -- save message in fnd stack
6757: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
6758: THEN
6759: IF (Fnd_Log.Level_Statement >=
6760: Fnd_Log.G_Current_Runtime_Level)
6761: THEN
6762: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6763: lc_mod_name,
6764: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 6762: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6758: THEN
6759: IF (Fnd_Log.Level_Statement >=
6760: Fnd_Log.G_Current_Runtime_Level)
6761: THEN
6762: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6763: lc_mod_name,
6764: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
6765: END IF;
6766: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);

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

6768: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6769: p_data => x_msg_data);
6770:
6771: -- save message in debug log
6772: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
6773: THEN
6774: Fnd_Log.STRING(Fnd_Log.Level_Exception,
6775: lc_mod_name,
6776: 'EXC_UNEXPECTED_ERROR[' || x_msg_data || ']');

Line 6774: Fnd_Log.STRING(Fnd_Log.Level_Exception,

6770:
6771: -- save message in debug log
6772: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
6773: THEN
6774: Fnd_Log.STRING(Fnd_Log.Level_Exception,
6775: lc_mod_name,
6776: 'EXC_UNEXPECTED_ERROR[' || x_msg_data || ']');
6777: END IF;
6778: WHEN OTHERS THEN

Line 6785: IF (Fnd_Log.Level_Statement >=

6781:
6782: -- save message in fnd stack
6783: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
6784: THEN
6785: IF (Fnd_Log.Level_Statement >=
6786: Fnd_Log.G_Current_Runtime_Level)
6787: THEN
6788: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6789: lc_mod_name,

Line 6786: Fnd_Log.G_Current_Runtime_Level)

6782: -- save message in fnd stack
6783: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
6784: THEN
6785: IF (Fnd_Log.Level_Statement >=
6786: Fnd_Log.G_Current_Runtime_Level)
6787: THEN
6788: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6789: lc_mod_name,
6790: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 6788: Fnd_Log.STRING(Fnd_Log.Level_Statement,

6784: THEN
6785: IF (Fnd_Log.Level_Statement >=
6786: Fnd_Log.G_Current_Runtime_Level)
6787: THEN
6788: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6789: lc_mod_name,
6790: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
6791: END IF;
6792: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);

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

6794: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6795: p_data => x_msg_data);
6796:
6797: -- save message in debug log
6798: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
6799: THEN
6800: -- create a seeded message
6801: Fnd_Log.STRING(Fnd_Log.Level_Exception,
6802: lc_mod_name,

Line 6801: Fnd_Log.STRING(Fnd_Log.Level_Exception,

6797: -- save message in debug log
6798: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
6799: THEN
6800: -- create a seeded message
6801: Fnd_Log.STRING(Fnd_Log.Level_Exception,
6802: lc_mod_name,
6803: 'SQL Message[' || SQLERRM || ']');
6804: END IF;
6805: END Convert_To_Est_Lines;

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

6846: l_estimate_hdr_rec Csd_Repair_Estimate_Pub.ESTIMATE_HDR_REC;
6847: l_est_hdr_pvt_rec Csd_Repair_Estimate_Pvt.REPAIR_ESTIMATE_REC;
6848: BEGIN
6849:
6850: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level)
6851: THEN
6852: Fnd_Log.STRING(Fnd_Log.level_procedure,
6853: 'csd.plsql.csd_repair_Estimate_pvt.create_estimate_header.begin',
6854: 'Entering create_estimate_header');

Line 6852: Fnd_Log.STRING(Fnd_Log.level_procedure,

6848: BEGIN
6849:
6850: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level)
6851: THEN
6852: Fnd_Log.STRING(Fnd_Log.level_procedure,
6853: 'csd.plsql.csd_repair_Estimate_pvt.create_estimate_header.begin',
6854: 'Entering create_estimate_header');
6855: END IF;
6856: -- Standard Start of API savepoint

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

6961: THEN
6962: COMMIT WORK;
6963: END IF;
6964:
6965: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level)
6966: THEN
6967: Fnd_Log.STRING(Fnd_Log.level_procedure,
6968: 'csd.plsql.csd_repair_Estimate_pvt.create_estimate_header.end',
6969: 'Leaving create_estimate_header');

Line 6967: Fnd_Log.STRING(Fnd_Log.level_procedure,

6963: END IF;
6964:
6965: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level)
6966: THEN
6967: Fnd_Log.STRING(Fnd_Log.level_procedure,
6968: 'csd.plsql.csd_repair_Estimate_pvt.create_estimate_header.end',
6969: 'Leaving create_estimate_header');
6970: END IF;
6971:

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

6977: x_return_status := Fnd_Api.G_RET_STS_ERROR;
6978: ROLLBACK TO create_estimate_header_pvt;
6979: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6980: p_data => x_msg_data);
6981: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
6982: THEN
6983: Fnd_Log.STRING(Fnd_Log.level_error,
6984: 'csd.plsql.csd_repair_estimate_pvt.create_estimate_header',
6985: 'EXC_ERROR[' || x_msg_data || ']');

Line 6983: Fnd_Log.STRING(Fnd_Log.level_error,

6979: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6980: p_data => x_msg_data);
6981: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
6982: THEN
6983: Fnd_Log.STRING(Fnd_Log.level_error,
6984: 'csd.plsql.csd_repair_estimate_pvt.create_estimate_header',
6985: 'EXC_ERROR[' || x_msg_data || ']');
6986: END IF;
6987: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

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

6988: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6989: ROLLBACK TO create_estimate_header_pvt;
6990: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6991: p_data => x_msg_data);
6992: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
6993: THEN
6994: Fnd_Log.STRING(Fnd_Log.level_exception,
6995: 'csd.plsql.csd_repair_estimate_pvt.create_estimate_header',
6996: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');

Line 6994: Fnd_Log.STRING(Fnd_Log.level_exception,

6990: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6991: p_data => x_msg_data);
6992: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
6993: THEN
6994: Fnd_Log.STRING(Fnd_Log.level_exception,
6995: 'csd.plsql.csd_repair_estimate_pvt.create_estimate_header',
6996: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');
6997: END IF;
6998: WHEN OTHERS THEN

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

7003: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7004: END IF;
7005: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7006: p_data => x_msg_data);
7007: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
7008: THEN
7009: Fnd_Log.STRING(Fnd_Log.level_exception,
7010: 'csd.plsql.csd_repair_estimate_pvt.create_estimate_header',
7011: 'SQL MEssage[' || SQLERRM || ']');

Line 7009: Fnd_Log.STRING(Fnd_Log.level_exception,

7005: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7006: p_data => x_msg_data);
7007: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
7008: THEN
7009: Fnd_Log.STRING(Fnd_Log.level_exception,
7010: 'csd.plsql.csd_repair_estimate_pvt.create_estimate_header',
7011: 'SQL MEssage[' || SQLERRM || ']');
7012: END IF;
7013:

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

7069:
7070: debug('Start of estimate line creation for estimate id[=' ||
7071: p_estimate_line_rec.repair_estimate_id || ']');
7072:
7073: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
7074: THEN
7075: fnd_log.STRING(fnd_log.level_procedure,
7076: 'csd.plsql.csd_repair_estimate_pvt.create_estimate_line.begin',
7077: 'Entering create_estimate_line');

Line 7075: fnd_log.STRING(fnd_log.level_procedure,

7071: p_estimate_line_rec.repair_estimate_id || ']');
7072:
7073: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
7074: THEN
7075: fnd_log.STRING(fnd_log.level_procedure,
7076: 'csd.plsql.csd_repair_estimate_pvt.create_estimate_line.begin',
7077: 'Entering create_estimate_line');
7078: END IF;
7079:

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

7120: -- Standard call to get message count and IF count is get message info.
7121: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7122: p_data => x_msg_data);
7123:
7124: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
7125: THEN
7126: fnd_log.STRING(fnd_log.level_procedure,
7127: 'csd.plsql.csd_repair_estimate_pvt.create_estimate_line.end',
7128: 'leaving create_estimate_line');

Line 7126: fnd_log.STRING(fnd_log.level_procedure,

7122: p_data => x_msg_data);
7123:
7124: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
7125: THEN
7126: fnd_log.STRING(fnd_log.level_procedure,
7127: 'csd.plsql.csd_repair_estimate_pvt.create_estimate_line.end',
7128: 'leaving create_estimate_line');
7129: END IF;
7130: EXCEPTION

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

7132: x_return_status := Fnd_Api.G_RET_STS_ERROR;
7133: ROLLBACK TO CREATE_ESTIMATE_LINE_PVT;
7134: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7135: p_data => x_msg_data);
7136: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
7137: THEN
7138: Fnd_Log.STRING(Fnd_Log.level_error,
7139: 'csd.plsql.csd_repair_estimate_pvt.create_estimate_line',
7140: 'EXC_ERROR[' || x_msg_data || ']');

Line 7138: Fnd_Log.STRING(Fnd_Log.level_error,

7134: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7135: p_data => x_msg_data);
7136: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
7137: THEN
7138: Fnd_Log.STRING(Fnd_Log.level_error,
7139: 'csd.plsql.csd_repair_estimate_pvt.create_estimate_line',
7140: 'EXC_ERROR[' || x_msg_data || ']');
7141: END IF;
7142:

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

7144: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
7145: ROLLBACK TO CREATE_ESTIMATE_LINE_PVT;
7146: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7147: p_data => x_msg_data);
7148: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
7149: THEN
7150: Fnd_Log.STRING(Fnd_Log.level_exception,
7151: 'csd.plsql.csd_repair_estimate_pvt.create_estimate_line',
7152: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');

Line 7150: Fnd_Log.STRING(Fnd_Log.level_exception,

7146: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7147: p_data => x_msg_data);
7148: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
7149: THEN
7150: Fnd_Log.STRING(Fnd_Log.level_exception,
7151: 'csd.plsql.csd_repair_estimate_pvt.create_estimate_line',
7152: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');
7153: END IF;
7154: WHEN OTHERS THEN

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

7159: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7160: END IF;
7161: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7162: p_data => x_msg_data);
7163: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
7164: THEN
7165: Fnd_Log.STRING(Fnd_Log.level_exception,
7166: 'csd.plsql.csd_repair_estimate_pvt.create_estimate_line',
7167: 'SQL MEssage[' || SQLERRM || ']');

Line 7165: Fnd_Log.STRING(Fnd_Log.level_exception,

7161: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7162: p_data => x_msg_data);
7163: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
7164: THEN
7165: Fnd_Log.STRING(Fnd_Log.level_exception,
7166: 'csd.plsql.csd_repair_estimate_pvt.create_estimate_line',
7167: 'SQL MEssage[' || SQLERRM || ']');
7168: END IF;
7169:

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

7259:
7260: debug('Start of update estimate header for estimate id[=' ||
7261: p_estimate_hdr_rec.repair_estimate_id || ']');
7262:
7263: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
7264: THEN
7265: fnd_log.STRING(fnd_log.level_procedure,
7266: 'csd.plsql.csd_repair_estimate_pvt.update_estimate_header.begin',
7267: 'Entering update_estimate_header');

Line 7265: fnd_log.STRING(fnd_log.level_procedure,

7261: p_estimate_hdr_rec.repair_estimate_id || ']');
7262:
7263: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
7264: THEN
7265: fnd_log.STRING(fnd_log.level_procedure,
7266: 'csd.plsql.csd_repair_estimate_pvt.update_estimate_header.begin',
7267: 'Entering update_estimate_header');
7268: END IF;
7269:

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

7411: -- Standard call to get message count and IF count is get message info.
7412: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7413: p_data => x_msg_data);
7414:
7415: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
7416: THEN
7417: fnd_log.STRING(fnd_log.level_procedure,
7418: 'csd.plsql.csd_repair_estimate_pvt.update_estimate_header.end',
7419: 'leaving update_estimate_header');

Line 7417: fnd_log.STRING(fnd_log.level_procedure,

7413: p_data => x_msg_data);
7414:
7415: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
7416: THEN
7417: fnd_log.STRING(fnd_log.level_procedure,
7418: 'csd.plsql.csd_repair_estimate_pvt.update_estimate_header.end',
7419: 'leaving update_estimate_header');
7420: END IF;
7421: EXCEPTION

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

7423: x_return_status := Fnd_Api.G_RET_STS_ERROR;
7424: ROLLBACK TO UPDATE_ESTIMATE_HEADER_PVT;
7425: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7426: p_data => x_msg_data);
7427: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
7428: THEN
7429: Fnd_Log.STRING(Fnd_Log.level_error,
7430: 'csd.plsql.csd_repair_estimate_pvt.update_estimate_header',
7431: 'EXC_ERROR[' || x_msg_data || ']');

Line 7429: Fnd_Log.STRING(Fnd_Log.level_error,

7425: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7426: p_data => x_msg_data);
7427: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
7428: THEN
7429: Fnd_Log.STRING(Fnd_Log.level_error,
7430: 'csd.plsql.csd_repair_estimate_pvt.update_estimate_header',
7431: 'EXC_ERROR[' || x_msg_data || ']');
7432: END IF;
7433:

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

7435: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
7436: ROLLBACK TO UPDATE_ESTIMATE_HEADER_PVT;
7437: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7438: p_data => x_msg_data);
7439: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
7440: THEN
7441: Fnd_Log.STRING(Fnd_Log.level_exception,
7442: 'csd.plsql.csd_repair_estimate_pvt.update_estimate_header',
7443: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');

Line 7441: Fnd_Log.STRING(Fnd_Log.level_exception,

7437: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7438: p_data => x_msg_data);
7439: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
7440: THEN
7441: Fnd_Log.STRING(Fnd_Log.level_exception,
7442: 'csd.plsql.csd_repair_estimate_pvt.update_estimate_header',
7443: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');
7444: END IF;
7445: WHEN OTHERS THEN

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

7450: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7451: END IF;
7452: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7453: p_data => x_msg_data);
7454: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
7455: THEN
7456: Fnd_Log.STRING(Fnd_Log.level_exception,
7457: 'csd.plsql.csd_repair_estimate_pvt.update_estimate_header',
7458: 'SQL MEssage[' || SQLERRM || ']');

Line 7456: Fnd_Log.STRING(Fnd_Log.level_exception,

7452: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7453: p_data => x_msg_data);
7454: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
7455: THEN
7456: Fnd_Log.STRING(Fnd_Log.level_exception,
7457: 'csd.plsql.csd_repair_estimate_pvt.update_estimate_header',
7458: 'SQL MEssage[' || SQLERRM || ']');
7459: END IF;
7460:

Line 7520: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

7516: p_organization_id IN NUMBER,
7517: x_warning_flag OUT NOCOPY VARCHAR2 ) IS
7518:
7519: -- Constants --
7520: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7521: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
7522: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7523: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
7524: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

Line 7521: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

7517: x_warning_flag OUT NOCOPY VARCHAR2 ) IS
7518:
7519: -- Constants --
7520: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7521: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
7522: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7523: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
7524: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
7525: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

Line 7522: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

7518:
7519: -- Constants --
7520: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7521: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
7522: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7523: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
7524: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
7525: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7526: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

Line 7523: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

7519: -- Constants --
7520: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7521: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
7522: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7523: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
7524: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
7525: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7526: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7527: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.import_estimates_from_wip';

Line 7524: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

7520: lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7521: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
7522: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7523: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
7524: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
7525: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7526: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7527: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.import_estimates_from_wip';
7528: lc_api_name CONSTANT VARCHAR2(30) := 'IMPORT_ESTIMATES_FROM_WIP';

Line 7525: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

7521: lc_stat_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
7522: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7523: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
7524: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
7525: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7526: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7527: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.import_estimates_from_wip';
7528: lc_api_name CONSTANT VARCHAR2(30) := 'IMPORT_ESTIMATES_FROM_WIP';
7529: lc_api_version CONSTANT NUMBER := 1.0;

Line 7526: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

7522: lc_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7523: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
7524: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
7525: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7526: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7527: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.import_estimates_from_wip';
7528: lc_api_name CONSTANT VARCHAR2(30) := 'IMPORT_ESTIMATES_FROM_WIP';
7529: lc_api_version CONSTANT NUMBER := 1.0;
7530:

Line 7834: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.BEGIN',

7830: END IF;
7831:
7832: -- logging
7833: if (lc_proc_level >= lc_debug_level) then
7834: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.BEGIN',
7835: 'Entering csd_repair_estimate_pvt.import_estimates_from_wip');
7836: end if;
7837:
7838: -- log parameters

Line 7840: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

7836: end if;
7837:
7838: -- log parameters
7839: if (lc_stat_level >= lc_debug_level) then
7840: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
7841: 'p_api_version: ' || p_api_version);
7842: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
7843: 'p_commit: ' || p_commit);
7844: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

Line 7842: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

7838: -- log parameters
7839: if (lc_stat_level >= lc_debug_level) then
7840: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
7841: 'p_api_version: ' || p_api_version);
7842: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
7843: 'p_commit: ' || p_commit);
7844: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
7845: 'p_init_msg_list: ' || p_init_msg_list);
7846: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

Line 7844: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

7840: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
7841: 'p_api_version: ' || p_api_version);
7842: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
7843: 'p_commit: ' || p_commit);
7844: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
7845: 'p_init_msg_list: ' || p_init_msg_list);
7846: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
7847: 'p_validation_level: ' || p_validation_level);
7848: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

Line 7846: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

7842: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
7843: 'p_commit: ' || p_commit);
7844: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
7845: 'p_init_msg_list: ' || p_init_msg_list);
7846: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
7847: 'p_validation_level: ' || p_validation_level);
7848: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
7849: 'p_repair_line_id: ' || p_repair_line_id);
7850: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

Line 7848: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

7844: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
7845: 'p_init_msg_list: ' || p_init_msg_list);
7846: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
7847: 'p_validation_level: ' || p_validation_level);
7848: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
7849: 'p_repair_line_id: ' || p_repair_line_id);
7850: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
7851: 'p_repair_estimate_id: ' || p_repair_estimate_id);
7852: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

Line 7850: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

7846: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
7847: 'p_validation_level: ' || p_validation_level);
7848: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
7849: 'p_repair_line_id: ' || p_repair_line_id);
7850: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
7851: 'p_repair_estimate_id: ' || p_repair_estimate_id);
7852: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
7853: 'p_repair_type_id: ' || p_repair_type_id);
7854: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

Line 7852: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

7848: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
7849: 'p_repair_line_id: ' || p_repair_line_id);
7850: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
7851: 'p_repair_estimate_id: ' || p_repair_estimate_id);
7852: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
7853: 'p_repair_type_id: ' || p_repair_type_id);
7854: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
7855: 'p_business_process_id: ' || p_business_process_id);
7856: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

Line 7854: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

7850: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
7851: 'p_repair_estimate_id: ' || p_repair_estimate_id);
7852: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
7853: 'p_repair_type_id: ' || p_repair_type_id);
7854: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
7855: 'p_business_process_id: ' || p_business_process_id);
7856: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
7857: 'p_currency_code: ' || p_currency_code);
7858: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

Line 7856: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

7852: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
7853: 'p_repair_type_id: ' || p_repair_type_id);
7854: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
7855: 'p_business_process_id: ' || p_business_process_id);
7856: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
7857: 'p_currency_code: ' || p_currency_code);
7858: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
7859: 'p_incident_id: ' || p_incident_id);
7860: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

Line 7858: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

7854: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
7855: 'p_business_process_id: ' || p_business_process_id);
7856: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
7857: 'p_currency_code: ' || p_currency_code);
7858: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
7859: 'p_incident_id: ' || p_incident_id);
7860: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
7861: 'p_organization_id: ' || p_organization_id);
7862: end if;

Line 7860: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',

7856: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
7857: 'p_currency_code: ' || p_currency_code);
7858: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
7859: 'p_incident_id: ' || p_incident_id);
7860: FND_LOG.STRING(lc_stat_level, lc_mod_name || '.parameter_logging',
7861: 'p_organization_id: ' || p_organization_id);
7862: end if;
7863:
7864: -- Initialize API return status to success

Line 7875: FND_LOG.STRING(lc_proc_level, lc_mod_name,

7871: x_warning_flag := FND_API.G_FALSE;
7872:
7873: -- Validate mandatory input parameters.
7874: if (lc_proc_level >= lc_debug_level) then
7875: FND_LOG.STRING(lc_proc_level, lc_mod_name,
7876: 'Calling CSD_PROCESS_UTIL.Check_Reqd_Param for p_repair_line_id');
7877: end if;
7878: CSD_PROCESS_UTIL.Check_Reqd_Param
7879: ( p_param_value => p_repair_line_id,

Line 7884: FND_LOG.STRING(lc_proc_level, lc_mod_name,

7880: p_param_name => 'REPAIR_LINE_ID',
7881: p_api_name => lc_api_name);
7882:
7883: if (lc_proc_level >= lc_debug_level) then
7884: FND_LOG.STRING(lc_proc_level, lc_mod_name,
7885: 'Calling CSD_PROCESS_UTIL.Check_Reqd_Param for p_repair_type_id');
7886: end if;
7887:
7888: CSD_PROCESS_UTIL.Check_Reqd_Param

Line 7894: FND_LOG.STRING(lc_proc_level, lc_mod_name,

7890: p_param_name => 'REPAIR_TYPE_ID',
7891: p_api_name => lc_api_name);
7892:
7893: if (lc_proc_level >= lc_debug_level) then
7894: FND_LOG.STRING(lc_proc_level, lc_mod_name,
7895: 'Calling CSD_PROCESS_UTIL.Check_Reqd_Param for p_business_process_id');
7896: end if;
7897:
7898: CSD_PROCESS_UTIL.Check_Reqd_Param

Line 7904: FND_LOG.STRING(lc_proc_level, lc_mod_name,

7900: p_param_name => 'BUSINESS_PROCESS_ID',
7901: p_api_name => lc_api_name);
7902:
7903: if (lc_proc_level >= lc_debug_level) then
7904: FND_LOG.STRING(lc_proc_level, lc_mod_name,
7905: 'Calling CSD_PROCESS_UTIL.Check_Reqd_Param for p_currency_code');
7906: end if;
7907:
7908: CSD_PROCESS_UTIL.Check_Reqd_Param

Line 7914: FND_LOG.STRING(lc_proc_level, lc_mod_name,

7910: p_param_name => 'CURRENCY_CODE',
7911: p_api_name => lc_api_name);
7912:
7913: if (lc_proc_level >= lc_debug_level) then
7914: FND_LOG.STRING(lc_proc_level, lc_mod_name,
7915: 'Calling CSD_PROCESS_UTIL.Check_Reqd_Param for p_incident_id');
7916: end if;
7917:
7918: CSD_PROCESS_UTIL.Check_Reqd_Param

Line 7924: FND_LOG.STRING(lc_proc_level, lc_mod_name,

7920: p_param_name => 'INCIDENT_ID',
7921: p_api_name => lc_api_name);
7922:
7923: if (lc_proc_level >= lc_debug_level) then
7924: FND_LOG.STRING(lc_proc_level, lc_mod_name,
7925: 'Calling CSD_PROCESS_UTIL.Check_Reqd_Param for p_organization_id');
7926: end if;
7927:
7928: CSD_PROCESS_UTIL.Check_Reqd_Param

Line 7934: FND_LOG.STRING(lc_stat_level, lc_mod_name,

7930: p_param_name => 'ORGANIZATION_ID',
7931: p_api_name => lc_api_name);
7932:
7933: if (lc_stat_level >= lc_debug_level) then
7934: FND_LOG.STRING(lc_stat_level, lc_mod_name,
7935: 'Done checking required params');
7936: end if;
7937:
7938: -- We make API calls to get default contract and price list

Line 7944: FND_LOG.STRING(lc_proc_level, lc_mod_name,

7940: -- and the pricelist will together make sense. So we do not
7941: -- unnecessarily validate them.
7942:
7943: if (lc_proc_level >= lc_debug_level) then
7944: FND_LOG.STRING(lc_proc_level, lc_mod_name,
7945: 'Calling CSD_CHARGE_LINE_UTIL.Get_DefaultContract');
7946: end if;
7947:
7948: -- Get default Contract.

Line 7952: FND_LOG.STRING(lc_proc_level, lc_mod_name,

7948: -- Get default Contract.
7949: l_default_contract_line_id := CSD_CHARGE_LINE_UTIL.Get_DefaultContract( p_repair_line_id );
7950:
7951: if (lc_proc_level >= lc_debug_level) then
7952: FND_LOG.STRING(lc_proc_level, lc_mod_name,
7953: 'Returned from CSD_CHARGE_LINE_UTIL.Get_DefaultContract. '
7954: || 'l_default_contract_line_id = ' || l_default_contract_line_id);
7955: end if;
7956:

Line 7958: FND_LOG.STRING(lc_proc_level, lc_mod_name,

7954: || 'l_default_contract_line_id = ' || l_default_contract_line_id);
7955: end if;
7956:
7957: if (lc_proc_level >= lc_debug_level) then
7958: FND_LOG.STRING(lc_proc_level, lc_mod_name,
7959: 'Calling CSD_CHARGE_LINE_UTIL.Get_RO_PriceList');
7960: end if;
7961:
7962: -- Get default pricelist for the repair order.

Line 7966: FND_LOG.STRING(lc_proc_level, lc_mod_name,

7962: -- Get default pricelist for the repair order.
7963: l_default_price_list_hdr_id := CSD_CHARGE_LINE_UTIL.Get_RO_PriceList(p_repair_line_id);
7964:
7965: if (lc_proc_level >= lc_debug_level) then
7966: FND_LOG.STRING(lc_proc_level, lc_mod_name,
7967: 'Returned from CSD_CHARGE_LINE_UTIL.Get_RO_PriceList. '
7968: || 'l_default_price_list_hdr_id = ' ||l_default_price_list_hdr_id);
7969: end if;
7970:

Line 7973: FND_LOG.STRING(lc_proc_level, lc_mod_name,

7969: end if;
7970:
7971: IF ( l_default_price_list_hdr_id IS NULL ) THEN
7972: if (lc_proc_level >= lc_debug_level) then
7973: FND_LOG.STRING(lc_proc_level, lc_mod_name,
7974: 'Unable to determine default price list for the repair order.');
7975: end if;
7976: -- Unable to determine default pricelist
7977: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_DEFAULT_PL_IMPORT');

Line 7987: FND_LOG.STRING(lc_stat_level, lc_mod_name,

7983:
7984: -- Log info messages for all the wip jobs that are shared with other
7985: -- repair orders.
7986: if (lc_stat_level >= lc_debug_level) then
7987: FND_LOG.STRING(lc_stat_level, lc_mod_name,
7988: 'Begin LOOP through c_ineligible_WIP_Jobs');
7989: end if;
7990:
7991: FOR inelgible_WIP_rec IN c_ineligible_WIP_Jobs LOOP

Line 7993: FND_LOG.STRING(lc_stat_level, lc_mod_name,

7989: end if;
7990:
7991: FOR inelgible_WIP_rec IN c_ineligible_WIP_Jobs LOOP
7992: IF (lc_stat_level >= lc_debug_level) then
7993: FND_LOG.STRING(lc_stat_level, lc_mod_name,
7994: 'The WIP job ' || inelgible_WIP_rec.JOB_NAME || 'is shared across Repair Orders'
7995: || '. It is not imported');
7996: END IF;
7997: -- Add an INFO message indicating whether the job will not be imported.

Line 8008: FND_LOG.STRING(lc_stat_level, lc_mod_name,

8004:
8005: END LOOP; -- c_ineligible_WIP_Jobs cursor
8006:
8007: if (lc_stat_level >= lc_debug_level) then
8008: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8009: 'End LOOP c_ineligible_WIP_Jobs');
8010: end if;
8011:
8012: if (p_repair_estimate_id is not null) then

Line 8015: FND_LOG.STRING(lc_stat_level, lc_mod_name,

8011:
8012: if (p_repair_estimate_id is not null) then
8013: l_repair_estimate_id := p_repair_estimate_id;
8014: if (lc_stat_level >= lc_debug_level) then
8015: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8016: 'Estimate header passed in. l_repair_estimate_id='||l_repair_estimate_id);
8017: end if;
8018: else
8019: -- estimate header was not specified, so need to get it or create it

Line 8026: FND_LOG.STRING(lc_stat_level, lc_mod_name,

8022: into l_repair_estimate_id, l_repair_estimate_status, l_repair_estimate_status_name;
8023: close c_cur_repair_estimate_info;
8024:
8025: if (lc_stat_level >= lc_debug_level) then
8026: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8027: 'Estimate header not passed in. Queried repair_estimate_id='||l_repair_estimate_id);
8028: end if;
8029: IF (l_repair_estimate_id is null) THEN
8030: -- required fields

Line 8036: FND_LOG.STRING(lc_stat_level, lc_mod_name,'Calling CREATE_REPAIR_ESTIMATE');

8032: l_repair_estimate_rec.estimate_date := sysdate;
8033: l_repair_estimate_rec.estimate_status := 'DRAFT'; -- lookup type CSD_ESTIMATE_STATUS (hardcode for now)
8034:
8035: if (lc_stat_level >= lc_debug_level) then
8036: FND_LOG.STRING(lc_stat_level, lc_mod_name,'Calling CREATE_REPAIR_ESTIMATE');
8037: end if;
8038: CREATE_REPAIR_ESTIMATE(p_api_version =>1.0,
8039: p_commit => Fnd_Api.g_false,
8040: p_init_msg_list => Fnd_Api.g_false,

Line 8049: FND_LOG.STRING(lc_proc_level, lc_mod_name,

8045: x_msg_count => x_msg_count,
8046: x_msg_data => x_msg_data);
8047: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
8048: if (lc_proc_level >= lc_debug_level) then
8049: FND_LOG.STRING(lc_proc_level, lc_mod_name,
8050: 'Unable to create repair estimate header for repair_line_id ' || p_repair_line_id);
8051: end if;
8052: RAISE FND_API.G_EXC_ERROR;
8053: END IF;

Line 8058: FND_LOG.STRING(lc_proc_level, lc_mod_name,

8054: -- swai: create_repair_estimate doesn't actually return header id in x_estimate_id,
8055: -- so get it from the record instead.
8056: l_repair_estimate_id := l_repair_estimate_rec.repair_estimate_id;
8057: if (lc_proc_level >= lc_debug_level) then
8058: FND_LOG.STRING(lc_proc_level, lc_mod_name,
8059: 'CREATE_REPAIR_ESTIMATE returned l_repair_estimate_id='||l_repair_estimate_id);
8060: end if;
8061: ELSE
8062: IF (l_repair_estimate_status <> 'NEW') THEN

Line 8065: FND_LOG.STRING(lc_proc_level, lc_mod_name,

8061: ELSE
8062: IF (l_repair_estimate_status <> 'NEW') THEN
8063: -- only estimates in new status can be regenerated
8064: if (lc_proc_level >= lc_debug_level) then
8065: FND_LOG.STRING(lc_proc_level, lc_mod_name,
8066: 'Estimate header status is not NEW. Status =' || l_repair_estimate_status);
8067: end if;
8068: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_GEN_EST_STATUS_ERR');
8069: FND_MESSAGE.set_token( 'STATUS', l_repair_estimate_status_name);

Line 8084: FND_LOG.STRING(lc_stat_level, lc_mod_name,'Calling UPDATE_REPAIR_ESTIMATE');

8080: from csd_repair_estimate
8081: where repair_estimate_id = l_repair_estimate_id;
8082:
8083: if (lc_stat_level >= lc_debug_level) then
8084: FND_LOG.STRING(lc_stat_level, lc_mod_name,'Calling UPDATE_REPAIR_ESTIMATE');
8085: end if;
8086: UPDATE_REPAIR_ESTIMATE(p_api_version =>1.0,
8087: p_commit => Fnd_Api.g_false,
8088: p_init_msg_list => Fnd_Api.g_false,

Line 8096: FND_LOG.STRING(lc_proc_level, lc_mod_name,

8092: x_msg_count => x_msg_count,
8093: x_msg_data => x_msg_data);
8094: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
8095: if (lc_proc_level >= lc_debug_level) then
8096: FND_LOG.STRING(lc_proc_level, lc_mod_name,
8097: 'Unable to update repair estimate header for repair_line_id ' || p_repair_line_id);
8098: end if;
8099: RAISE FND_API.G_EXC_ERROR;
8100: END IF;

Line 8102: FND_LOG.STRING(lc_proc_level, lc_mod_name,

8098: end if;
8099: RAISE FND_API.G_EXC_ERROR;
8100: END IF;
8101: if (lc_proc_level >= lc_debug_level) then
8102: FND_LOG.STRING(lc_proc_level, lc_mod_name,
8103: 'UPDATE_REPAIR_ESTIMATE returned l_repair_estimate_id='||l_repair_estimate_id);
8104: end if;
8105:
8106: -- Now delete any existing estimate lines so that the estimate can be regenerated

Line 8109: FND_LOG.STRING(lc_stat_level, lc_mod_name,'Calling DELETE_REPAIR_ESTIMATE_LINES');

8105:
8106: -- Now delete any existing estimate lines so that the estimate can be regenerated
8107: FOR curr_est_line_rec IN c_estimate_lines(l_repair_estimate_id) LOOP
8108: if (lc_stat_level >= lc_debug_level) then
8109: FND_LOG.STRING(lc_stat_level, lc_mod_name,'Calling DELETE_REPAIR_ESTIMATE_LINES');
8110: end if;
8111: DELETE_REPAIR_ESTIMATE_LINES(p_api_version =>1.0,
8112: p_commit => Fnd_Api.g_false,
8113: p_init_msg_list => Fnd_Api.g_false,

Line 8121: FND_LOG.STRING(lc_proc_level, lc_mod_name,

8117: x_msg_count => x_msg_count,
8118: x_msg_data => x_msg_data);
8119: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
8120: if (lc_proc_level >= lc_debug_level) then
8121: FND_LOG.STRING(lc_proc_level, lc_mod_name,
8122: 'Unable to delete repair estimate line ' || curr_est_line_rec.repair_estimate_line_id);
8123: end if;
8124: RAISE FND_API.G_EXC_ERROR;
8125: END IF;

Line 8127: FND_LOG.STRING(lc_proc_level, lc_mod_name,

8123: end if;
8124: RAISE FND_API.G_EXC_ERROR;
8125: END IF;
8126: if (lc_proc_level >= lc_debug_level) then
8127: FND_LOG.STRING(lc_proc_level, lc_mod_name,
8128: 'Returned from DELETE_REPAIR_ESTIMATE_LINES');
8129: end if;
8130: END LOOP;
8131: END IF;

Line 8141: FND_LOG.STRING(lc_stat_level, lc_mod_name,

8137: -- The idea is that if we get into an error while processing
8138: -- a WIP Job, we skip that one, log a ERROR message and
8139: -- continue with next WIP job.
8140: if (lc_stat_level >= lc_debug_level) then
8141: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8142: 'Begin LOOP through c_eligible_WIP_Jobs');
8143: end if;
8144:
8145: FOR curr_WIP_job_rec IN c_eligible_WIP_Jobs LOOP

Line 8149: FND_LOG.STRING(lc_stat_level, lc_mod_name,

8145: FOR curr_WIP_job_rec IN c_eligible_WIP_Jobs LOOP
8146: l_wip_count := l_wip_count + 1;
8147:
8148: if (lc_stat_level >= lc_debug_level) then
8149: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8150: 'WIP count (l_wip_count) is = ' || l_wip_count);
8151: end if;
8152:
8153: DECLARE

Line 8163: FND_LOG.STRING(lc_stat_level, lc_mod_name,

8159:
8160: BEGIN
8161:
8162: if (lc_stat_level >= lc_debug_level) then
8163: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8164: 'Inside the BLOCK for processing one WIP job at a time.');
8165: end if;
8166:
8167: /****** Processing the Material transactions specific data - START *********/

Line 8170: FND_LOG.STRING(lc_stat_level, lc_mod_name,

8166:
8167: /****** Processing the Material transactions specific data - START *********/
8168:
8169: if (lc_stat_level >= lc_debug_level) then
8170: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8171: 'Start: Processing material transactions for the WIP job - ' || curr_WIP_job_rec.JOB_NAME);
8172: end if;
8173:
8174:

Line 8184: FND_LOG.STRING(lc_stat_level, lc_mod_name,

8180:
8181: IF ((nvl(fnd_profile.value('CSD_IMPORT_WIP_MTL_TO_ESTIMATES'),'NONE') in ('TRANS', 'ALL'))) THEN
8182: if (nvl(fnd_profile.value('CSD_IMPORT_WIP_TO_ESTIMATES_NET_QTY'),'Y') = 'N') THEN
8183: if (lc_stat_level >= lc_debug_level) then
8184: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8185: 'Begin: loop through the cursor c_est_lines_from_materials1.');
8186: end if;
8187: FOR Estimates_rec IN c_est_lines_from_materials1( curr_WIP_job_rec.wip_entity_id,
8188: curr_WIP_job_rec.inventory_item_id) LOOP

Line 8192: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'count='||l_Count);

8188: curr_WIP_job_rec.inventory_item_id) LOOP
8189: if (Estimates_rec.quantity > 0) then
8190: l_count := l_count + 1;
8191: if (lc_stat_level >= lc_debug_level) then
8192: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'count='||l_Count);
8193: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'inventory_item_id='||Estimates_rec.inventory_item_id);
8194: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'quantity='||Estimates_rec.quantity);
8195: end if;
8196: l_estimate_lines_tbl( l_count ).inventory_item_id := Estimates_rec.inventory_item_id;

Line 8193: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'inventory_item_id='||Estimates_rec.inventory_item_id);

8189: if (Estimates_rec.quantity > 0) then
8190: l_count := l_count + 1;
8191: if (lc_stat_level >= lc_debug_level) then
8192: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'count='||l_Count);
8193: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'inventory_item_id='||Estimates_rec.inventory_item_id);
8194: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'quantity='||Estimates_rec.quantity);
8195: end if;
8196: l_estimate_lines_tbl( l_count ).inventory_item_id := Estimates_rec.inventory_item_id;
8197: l_estimate_lines_tbl( l_count ).unit_of_measure_code := Estimates_rec.uom;

Line 8194: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'quantity='||Estimates_rec.quantity);

8190: l_count := l_count + 1;
8191: if (lc_stat_level >= lc_debug_level) then
8192: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'count='||l_Count);
8193: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'inventory_item_id='||Estimates_rec.inventory_item_id);
8194: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'quantity='||Estimates_rec.quantity);
8195: end if;
8196: l_estimate_lines_tbl( l_count ).inventory_item_id := Estimates_rec.inventory_item_id;
8197: l_estimate_lines_tbl( l_count ).unit_of_measure_code := Estimates_rec.uom;
8198: l_estimate_lines_tbl( l_count ).estimate_quantity := Estimates_rec.quantity;

Line 8216: FND_LOG.STRING(lc_stat_level, lc_mod_name,

8212: l_estimate_lines_tbl( l_count ).charge_line_type := G_CHARGE_LINE_TYPE_ESTIMATE;
8213: end if;
8214: END LOOP;
8215: if (lc_stat_level >= lc_debug_level) then
8216: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8217: 'End: loop through the cursor c_est_lines_from_materials1.');
8218: end if;
8219: else
8220: if (lc_stat_level >= lc_debug_level) then

Line 8221: FND_LOG.STRING(lc_stat_level, lc_mod_name,

8217: 'End: loop through the cursor c_est_lines_from_materials1.');
8218: end if;
8219: else
8220: if (lc_stat_level >= lc_debug_level) then
8221: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8222: 'Begin: loop through the cursor c_est_lines_from_materials.');
8223: end if;
8224: FOR Estimates_rec IN c_est_lines_from_materials( curr_WIP_job_rec.wip_entity_id,
8225: curr_WIP_job_rec.inventory_item_id) LOOP

Line 8229: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'count='||l_Count);

8225: curr_WIP_job_rec.inventory_item_id) LOOP
8226: if (Estimates_rec.quantity > 0) then
8227: l_count := l_count + 1;
8228: if (lc_stat_level >= lc_debug_level) then
8229: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'count='||l_Count);
8230: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'inventory_item_id='||Estimates_rec.inventory_item_id);
8231: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'quantity='||Estimates_rec.quantity);
8232: end if;
8233: l_estimate_lines_tbl( l_count ).inventory_item_id := Estimates_rec.inventory_item_id;

Line 8230: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'inventory_item_id='||Estimates_rec.inventory_item_id);

8226: if (Estimates_rec.quantity > 0) then
8227: l_count := l_count + 1;
8228: if (lc_stat_level >= lc_debug_level) then
8229: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'count='||l_Count);
8230: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'inventory_item_id='||Estimates_rec.inventory_item_id);
8231: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'quantity='||Estimates_rec.quantity);
8232: end if;
8233: l_estimate_lines_tbl( l_count ).inventory_item_id := Estimates_rec.inventory_item_id;
8234: l_estimate_lines_tbl( l_count ).unit_of_measure_code := Estimates_rec.uom;

Line 8231: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'quantity='||Estimates_rec.quantity);

8227: l_count := l_count + 1;
8228: if (lc_stat_level >= lc_debug_level) then
8229: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'count='||l_Count);
8230: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'inventory_item_id='||Estimates_rec.inventory_item_id);
8231: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'quantity='||Estimates_rec.quantity);
8232: end if;
8233: l_estimate_lines_tbl( l_count ).inventory_item_id := Estimates_rec.inventory_item_id;
8234: l_estimate_lines_tbl( l_count ).unit_of_measure_code := Estimates_rec.uom;
8235: l_estimate_lines_tbl( l_count ).estimate_quantity := Estimates_rec.quantity;

Line 8253: FND_LOG.STRING(lc_stat_level, lc_mod_name,

8249: l_estimate_lines_tbl( l_count ).charge_line_type := G_CHARGE_LINE_TYPE_ESTIMATE;
8250: end if;
8251: END LOOP;
8252: if (lc_stat_level >= lc_debug_level) then
8253: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8254: 'End: loop through the cursor c_est_lines_from_materials.');
8255: end if;
8256: end if;
8257: END IF;

Line 8261: FND_LOG.STRING(lc_stat_level, lc_mod_name,

8257: END IF;
8258:
8259: IF ((nvl(fnd_profile.value('CSD_IMPORT_WIP_MTL_TO_ESTIMATES'),'NONE') in ('UNTRANS', 'ALL'))) THEN
8260: if (lc_stat_level >= lc_debug_level) then
8261: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8262: 'Begin: loop through the cursor c_est_lines_from_material_reqs.');
8263: end if;
8264: FOR Estimates_rec IN c_est_lines_from_material_reqs( curr_WIP_job_rec.wip_entity_id,
8265: curr_WIP_job_rec.inventory_item_id) LOOP

Line 8269: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'count='||l_Count);

8265: curr_WIP_job_rec.inventory_item_id) LOOP
8266: if (Estimates_rec.quantity > 0) then
8267: l_count := l_count + 1;
8268: if (lc_stat_level >= lc_debug_level) then
8269: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'count='||l_Count);
8270: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'inventory_item_id='||Estimates_rec.inventory_item_id);
8271: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'quantity='||Estimates_rec.quantity);
8272: end if;
8273: l_estimate_lines_tbl( l_count ).inventory_item_id := Estimates_rec.inventory_item_id;

Line 8270: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'inventory_item_id='||Estimates_rec.inventory_item_id);

8266: if (Estimates_rec.quantity > 0) then
8267: l_count := l_count + 1;
8268: if (lc_stat_level >= lc_debug_level) then
8269: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'count='||l_Count);
8270: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'inventory_item_id='||Estimates_rec.inventory_item_id);
8271: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'quantity='||Estimates_rec.quantity);
8272: end if;
8273: l_estimate_lines_tbl( l_count ).inventory_item_id := Estimates_rec.inventory_item_id;
8274: l_estimate_lines_tbl( l_count ).unit_of_measure_code := Estimates_rec.uom;

Line 8271: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'quantity='||Estimates_rec.quantity);

8267: l_count := l_count + 1;
8268: if (lc_stat_level >= lc_debug_level) then
8269: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'count='||l_Count);
8270: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'inventory_item_id='||Estimates_rec.inventory_item_id);
8271: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'quantity='||Estimates_rec.quantity);
8272: end if;
8273: l_estimate_lines_tbl( l_count ).inventory_item_id := Estimates_rec.inventory_item_id;
8274: l_estimate_lines_tbl( l_count ).unit_of_measure_code := Estimates_rec.uom;
8275: l_estimate_lines_tbl( l_count ).estimate_quantity := Estimates_rec.quantity;

Line 8293: FND_LOG.STRING(lc_stat_level, lc_mod_name,

8289: l_estimate_lines_tbl( l_count ).charge_line_type := G_CHARGE_LINE_TYPE_ESTIMATE;
8290: end if;
8291: END LOOP;
8292: if (lc_stat_level >= lc_debug_level) then
8293: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8294: 'End: loop through the cursor c_est_lines_from_material_reqs.');
8295: end if;
8296: END IF;
8297: END;

Line 8300: FND_LOG.STRING(lc_stat_level, lc_mod_name,

8296: END IF;
8297: END;
8298:
8299: if (lc_stat_level >= lc_debug_level) then
8300: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8301: 'End: Processing material transactions for the WIP job - ' || curr_WIP_job_rec.JOB_NAME);
8302: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8303: 'Estimate line count = ' || l_estimate_lines_tbl.COUNT);
8304: end if;

Line 8302: FND_LOG.STRING(lc_stat_level, lc_mod_name,

8298:
8299: if (lc_stat_level >= lc_debug_level) then
8300: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8301: 'End: Processing material transactions for the WIP job - ' || curr_WIP_job_rec.JOB_NAME);
8302: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8303: 'Estimate line count = ' || l_estimate_lines_tbl.COUNT);
8304: end if;
8305:
8306: /****** Processing the Material transactions specific data - END *********/

Line 8313: FND_LOG.STRING(lc_stat_level, lc_mod_name,

8309:
8310: /****** Processing the Resource/WIP transactions specific data - START *********/
8311:
8312: if (lc_stat_level >= lc_debug_level) then
8313: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8314: 'Start: Processing Resource/WIP transactions for the WIP job - ' || curr_WIP_job_rec.JOB_NAME);
8315: end if;
8316: -- Now, we process the WIP transaction lines (for resources) for all
8317: -- the WIP jobs. Getting the table for all the lines.

Line 8323: FND_LOG.STRING(lc_stat_level, lc_mod_name,

8319: l_count NUMBER := l_estimate_lines_tbl.count; -- append to the materials in the table
8320: BEGIN
8321: IF ((nvl(fnd_profile.value('CSD_IMPORT_WIP_RES_TO_ESTIMATES'),'NONE') in ('TRANS', 'ALL'))) THEN
8322: if (lc_stat_level >= lc_debug_level) then
8323: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8324: 'Begin: loop through the cursor c_est_lines_from_resources.');
8325: end if;
8326: FOR Estimates_rec IN c_est_lines_from_resources( curr_WIP_job_rec.wip_entity_id) LOOP
8327: if (Estimates_rec.quantity > 0) then

Line 8330: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'count='||l_Count);

8326: FOR Estimates_rec IN c_est_lines_from_resources( curr_WIP_job_rec.wip_entity_id) LOOP
8327: if (Estimates_rec.quantity > 0) then
8328: l_count := l_count + 1;
8329: if (lc_stat_level >= lc_debug_level) then
8330: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'count='||l_Count);
8331: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'inventory_item_id='||Estimates_rec.inventory_item_id);
8332: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'quantity='||Estimates_rec.quantity);
8333: end if;
8334: l_estimate_lines_tbl( l_count ).inventory_item_id := Estimates_rec.inventory_item_id;

Line 8331: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'inventory_item_id='||Estimates_rec.inventory_item_id);

8327: if (Estimates_rec.quantity > 0) then
8328: l_count := l_count + 1;
8329: if (lc_stat_level >= lc_debug_level) then
8330: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'count='||l_Count);
8331: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'inventory_item_id='||Estimates_rec.inventory_item_id);
8332: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'quantity='||Estimates_rec.quantity);
8333: end if;
8334: l_estimate_lines_tbl( l_count ).inventory_item_id := Estimates_rec.inventory_item_id;
8335: l_estimate_lines_tbl( l_count ).unit_of_measure_code := Estimates_rec.uom;

Line 8332: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'quantity='||Estimates_rec.quantity);

8328: l_count := l_count + 1;
8329: if (lc_stat_level >= lc_debug_level) then
8330: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'count='||l_Count);
8331: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'inventory_item_id='||Estimates_rec.inventory_item_id);
8332: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'quantity='||Estimates_rec.quantity);
8333: end if;
8334: l_estimate_lines_tbl( l_count ).inventory_item_id := Estimates_rec.inventory_item_id;
8335: l_estimate_lines_tbl( l_count ).unit_of_measure_code := Estimates_rec.uom;
8336: l_estimate_lines_tbl( l_count ).estimate_quantity := Estimates_rec.quantity;

Line 8355: FND_LOG.STRING(lc_stat_level, lc_mod_name,

8351: l_estimate_lines_tbl( l_count ).resource_id := Estimates_rec.resource_id;
8352: end if;
8353: END LOOP;
8354: if (lc_stat_level >= lc_debug_level) then
8355: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8356: 'End: loop through the cursor c_est_lines_from_resources.');
8357: end if;
8358: END IF;
8359:

Line 8362: FND_LOG.STRING(lc_stat_level, lc_mod_name,

8358: END IF;
8359:
8360: IF ((nvl(fnd_profile.value('CSD_IMPORT_WIP_RES_TO_ESTIMATES'),'NONE') in ('UNTRANS', 'ALL'))) THEN
8361: if (lc_stat_level >= lc_debug_level) then
8362: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8363: 'Begin: loop through the cursor c_est_lines_from_resource_reqs.');
8364: end if;
8365: FOR Estimates_rec IN c_est_lines_from_resource_reqs( curr_WIP_job_rec.wip_entity_id) LOOP
8366: if (Estimates_rec.quantity > 0) then

Line 8369: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'count='||l_Count);

8365: FOR Estimates_rec IN c_est_lines_from_resource_reqs( curr_WIP_job_rec.wip_entity_id) LOOP
8366: if (Estimates_rec.quantity > 0) then
8367: l_count := l_count + 1;
8368: if (lc_stat_level >= lc_debug_level) then
8369: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'count='||l_Count);
8370: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'inventory_item_id='||Estimates_rec.inventory_item_id);
8371: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'quantity='||Estimates_rec.quantity);
8372: end if;
8373: l_estimate_lines_tbl( l_count ).inventory_item_id := Estimates_rec.inventory_item_id;

Line 8370: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'inventory_item_id='||Estimates_rec.inventory_item_id);

8366: if (Estimates_rec.quantity > 0) then
8367: l_count := l_count + 1;
8368: if (lc_stat_level >= lc_debug_level) then
8369: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'count='||l_Count);
8370: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'inventory_item_id='||Estimates_rec.inventory_item_id);
8371: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'quantity='||Estimates_rec.quantity);
8372: end if;
8373: l_estimate_lines_tbl( l_count ).inventory_item_id := Estimates_rec.inventory_item_id;
8374: l_estimate_lines_tbl( l_count ).unit_of_measure_code := Estimates_rec.uom;

Line 8371: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'quantity='||Estimates_rec.quantity);

8367: l_count := l_count + 1;
8368: if (lc_stat_level >= lc_debug_level) then
8369: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'count='||l_Count);
8370: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'inventory_item_id='||Estimates_rec.inventory_item_id);
8371: FND_LOG.STRING(lc_stat_level, lc_mod_name, 'quantity='||Estimates_rec.quantity);
8372: end if;
8373: l_estimate_lines_tbl( l_count ).inventory_item_id := Estimates_rec.inventory_item_id;
8374: l_estimate_lines_tbl( l_count ).unit_of_measure_code := Estimates_rec.uom;
8375: l_estimate_lines_tbl( l_count ).estimate_quantity := Estimates_rec.quantity;

Line 8394: FND_LOG.STRING(lc_stat_level, lc_mod_name,

8390: l_estimate_lines_tbl( l_count ).resource_id := Estimates_rec.resource_id;
8391: end if;
8392: END LOOP;
8393: if (lc_stat_level >= lc_debug_level) then
8394: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8395: 'End: loop through the cursor c_est_lines_from_resource_reqs.');
8396: end if;
8397: END IF;
8398: END;

Line 8401: FND_LOG.STRING(lc_stat_level, lc_mod_name,

8397: END IF;
8398: END;
8399:
8400: if (lc_stat_level >= lc_debug_level) then
8401: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8402: 'END: Processing Resource/WIP transactions for the WIP job - ' || curr_WIP_job_rec.JOB_NAME);
8403: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8404: 'Estimate line count = ' || l_estimate_lines_tbl.COUNT);
8405: end if;

Line 8403: FND_LOG.STRING(lc_stat_level, lc_mod_name,

8399:
8400: if (lc_stat_level >= lc_debug_level) then
8401: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8402: 'END: Processing Resource/WIP transactions for the WIP job - ' || curr_WIP_job_rec.JOB_NAME);
8403: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8404: 'Estimate line count = ' || l_estimate_lines_tbl.COUNT);
8405: end if;
8406:
8407: /****** Processing the Resource/WIP transactions specific data - END *********/

Line 8434: FND_LOG.STRING(lc_stat_level, lc_mod_name,

8430: l_estimate_lines_tbl( i ).purchase_order_num := l_default_po_number ;
8431: end if;
8432:
8433: if (lc_stat_level >= lc_debug_level) then
8434: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8435: 'Calling procedure CSD_REPAIR_ESTIMATE_PVT.create_repair_estimate_lines');
8436: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8437: 'index = ' || TO_CHAR( i ));
8438: end if;

Line 8436: FND_LOG.STRING(lc_stat_level, lc_mod_name,

8432:
8433: if (lc_stat_level >= lc_debug_level) then
8434: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8435: 'Calling procedure CSD_REPAIR_ESTIMATE_PVT.create_repair_estimate_lines');
8436: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8437: 'index = ' || TO_CHAR( i ));
8438: end if;
8439: CSD_REPAIR_ESTIMATE_PVT.create_repair_estimate_lines( p_api_version => 1.0,
8440: p_commit => FND_API.G_FALSE,

Line 8451: FND_LOG.STRING(lc_proc_level, lc_mod_name,

8447: x_msg_data => l_msg_data );
8448:
8449: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
8450: if (lc_proc_level >= lc_debug_level) then
8451: FND_LOG.STRING(lc_proc_level, lc_mod_name,
8452: 'Unable to create repair estimate lines for index = ' || i);
8453: end if;
8454: -- swai: do not raise exception. Flag as warning and process the next line.
8455: -- RAISE FND_API.G_EXC_ERROR;

Line 8465: FND_LOG.STRING(lc_proc_level, lc_mod_name,

8461: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
8462: ELSE
8463: l_total_estimates_lines := l_total_estimates_lines +1;
8464: if (lc_proc_level >= lc_debug_level) then
8465: FND_LOG.STRING(lc_proc_level, lc_mod_name,
8466: 'Estimate line created:' || l_estimate_lines_tbl( i ).repair_estimate_line_id);
8467: end if;
8468: END IF;
8469: EXCEPTION

Line 8481: FND_LOG.STRING(lc_proc_level, lc_mod_name,

8477: END;
8478: END LOOP;
8479:
8480: if (lc_proc_level >= lc_debug_level) then
8481: FND_LOG.STRING(lc_proc_level, lc_mod_name,
8482: 'End of loop for creating estimate lines. l_Estimates_count = ' || l_Estimates_count);
8483: end if;
8484:
8485: IF ( x_warning_flag <> FND_API.G_FALSE ) THEN

Line 8493: FND_LOG.STRING(lc_stat_level, lc_mod_name,

8489: FND_MESSAGE.set_token( 'JOB_NAME', curr_WIP_job_rec.JOB_NAME );
8490: FND_MESSAGE.set_token( 'ESTIMATE_LINE_COUNT', l_Estimates_count );
8491: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_INFORMATION_MSG );
8492: if (lc_stat_level >= lc_debug_level) then
8493: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8494: 'Debrief lines import for the WIP Job ' || curr_WIP_job_rec.JOB_NAME
8495: || ' completed with warnings. l_Estimates_count = ' || l_Estimates_count);
8496: end if;
8497: END IF;

Line 8518: FND_LOG.STRING(lc_proc_level, lc_mod_name,

8514: ROLLBACK TO curr_wip_job_sp;
8515: x_warning_flag := FND_API.G_TRUE;
8516:
8517: if (lc_proc_level >= lc_debug_level) then
8518: FND_LOG.STRING(lc_proc_level, lc_mod_name,
8519: 'Encountered an OTHERS error while creating a repair estimate lines ' ||
8520: 'for the WIP Job ' || curr_WIP_job_rec.JOB_NAME ||
8521: '. SQLCODE = ' || SQLCODE || '. SQLERRM = ' || SQLERRM);
8522: end if;

Line 8538: FND_LOG.STRING(lc_stat_level, lc_mod_name,

8534: END;
8535: END LOOP; -- for cursor c_eligible_WIP_Jobs
8536:
8537: if (lc_stat_level >= lc_debug_level) then
8538: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8539: 'End LOOP c_eligible_WIP_Jobs');
8540: end if;
8541:
8542: IF( l_wip_count <= 0 ) THEN

Line 8576: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.END',

8572: END IF;
8573:
8574: -- logging
8575: if (lc_proc_level >= lc_debug_level) then
8576: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.END',
8577: 'Leaving CSD_REPAIR_ESTIMATE_PVT.IMPORT_ESTIMATES_FROM_WIP');
8578: end if;
8579:
8580: EXCEPTION

Line 8589: FND_LOG.STRING(lc_excep_level, lc_mod_name,

8585: p_data => x_msg_data );
8586:
8587: -- save message in debug log
8588: IF (lc_excep_level >= lc_debug_level) THEN
8589: FND_LOG.STRING(lc_excep_level, lc_mod_name,
8590: 'EXC_ERROR['||x_msg_data||']');
8591: END IF;
8592:
8593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 8601: FND_LOG.STRING(lc_excep_level, lc_mod_name,

8597: p_data => x_msg_data );
8598:
8599: -- save message in debug log
8600: IF (lc_excep_level >= lc_debug_level) THEN
8601: FND_LOG.STRING(lc_excep_level, lc_mod_name,
8602: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
8603: END IF;
8604:
8605: WHEN OTHERS THEN

Line 8615: FND_LOG.STRING(lc_excep_level, lc_mod_name,

8611: END IF;
8612:
8613: -- save message in debug log
8614: IF (lc_excep_level >= lc_debug_level) THEN
8615: FND_LOG.STRING(lc_excep_level, lc_mod_name,
8616: 'WHEN OTHERS THEN. SQL Message['||SQLERRM||']');
8617: END IF;
8618:
8619: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_WIP_IMPORT_OTHERS');