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 CSD_REPAIR_ESTIMATE_PVT

Line 1: Package BODY Csd_Repair_Estimate_Pvt AS

1: Package BODY Csd_Repair_Estimate_Pvt AS
2: /* $Header: csdvestb.pls 120.13.12010000.2 2008/09/04 10:00:34 subhat ship $ */
3:
4: -- ---------------------------------------------------------
5: -- Define global variables

Line 8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_REPAIR_ESTIMATE_PVT';

4: -- ---------------------------------------------------------
5: -- Define global variables
6: -- ---------------------------------------------------------
7:
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_REPAIR_ESTIMATE_PVT';
9: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdvestb.pls';
10: g_debug NUMBER := Csd_Gen_Utility_Pvt.g_debug_level;
11: ----Begin change for 3931317, wrpper aPI forward port
12:

Line 524: Csd_Gen_Utility_Pvt.ADD('CSD_REPAIR_ESTIMATE_PVT.UPDATE_RO_GROUP_ESTIMATE Update Group RO call');

520: END IF;
521:
522: IF (g_debug > 0)
523: THEN
524: Csd_Gen_Utility_Pvt.ADD('CSD_REPAIR_ESTIMATE_PVT.UPDATE_RO_GROUP_ESTIMATE Update Group RO call');
525: END IF;
526:
527: Csd_Repair_Groups_Pvt.UPDATE_REPAIR_GROUPS(p_api_version => 1.0,
528: p_commit => 'F',

Line 538: Csd_Gen_Utility_Pvt.ADD('CSD_REPAIR_ESTIMATE_PVT.UPDATE_RO_GROUP_ESTIMATE UPDATE_REPAIR_GROUPS :' ||

534: x_msg_data => l_msg_data);
535:
536: IF (g_debug > 0)
537: THEN
538: Csd_Gen_Utility_Pvt.ADD('CSD_REPAIR_ESTIMATE_PVT.UPDATE_RO_GROUP_ESTIMATE UPDATE_REPAIR_GROUPS :' ||
539: x_return_status);
540: END IF;
541:
542: IF l_return_status <> 'S'

Line 1385: x_estimate_line_rec IN OUT NOCOPY CSD_REPAIR_ESTIMATE_PVT.REPAIR_ESTIMATE_LINE_REC,

1381: PROCEDURE CREATE_REPAIR_ESTIMATE_LINES(p_api_version IN NUMBER,
1382: p_commit IN VARCHAR2 := Fnd_Api.g_false,
1383: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
1384: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
1385: x_estimate_line_rec IN OUT NOCOPY CSD_REPAIR_ESTIMATE_PVT.REPAIR_ESTIMATE_LINE_REC,
1386: x_estimate_line_id OUT NOCOPY NUMBER,
1387: x_return_status OUT NOCOPY VARCHAR2,
1388: x_msg_count OUT NOCOPY NUMBER,
1389: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 1938: x_estimate_line_rec IN OUT NOCOPY CSD_REPAIR_ESTIMATE_PVT.REPAIR_ESTIMATE_LINE_REC,

1934: PROCEDURE UPDATE_REPAIR_ESTIMATE_LINES(p_api_version IN NUMBER,
1935: p_commit IN VARCHAR2 := Fnd_Api.g_false,
1936: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
1937: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
1938: x_estimate_line_rec IN OUT NOCOPY CSD_REPAIR_ESTIMATE_PVT.REPAIR_ESTIMATE_LINE_REC,
1939: x_return_status OUT NOCOPY VARCHAR2,
1940: x_msg_count OUT NOCOPY NUMBER,
1941: x_msg_data OUT NOCOPY VARCHAR2) IS
1942:

Line 3099: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.get_total_estimated_charge';

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

Line 3179: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.autocreate_estimate_lines';

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

Line 3188: l_est_lines_tbl CSD_REPAIR_ESTIMATE_PVT.REPAIR_ESTIMATE_LINE_TBL;

3184: l_default_contract_line_id NUMBER := NULL;
3185: l_default_price_list_id NUMBER := NULL;
3186: l_num_service_codes NUMBER := 0;
3187: l_contract_validated BOOLEAN;
3188: l_est_lines_tbl CSD_REPAIR_ESTIMATE_PVT.REPAIR_ESTIMATE_LINE_TBL;
3189: l_return_status VARCHAR2(1);
3190: l_msg_count NUMBER;
3191: l_msg_data VARCHAR2(200);
3192: l_estimate_line_id NUMBER;

Line 3459: 'Calling CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_Task');

3455: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3456: THEN
3457: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3458: lc_mod_name,
3459: 'Calling CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_Task');
3460: END IF;
3461: Get_Estimates_From_Task(p_api_version => 1.0,
3462: p_commit => p_commit,
3463: p_init_msg_list => Fnd_Api.G_FALSE,

Line 3485: 'Returned from CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_Task');

3481: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3482: THEN
3483: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3484: lc_mod_name,
3485: 'Returned from CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_Task');
3486: END IF;
3487: ELSIF p_repair_mode = 'WIP'
3488: THEN
3489: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)

Line 3493: 'Calling CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_BOM');

3489: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3490: THEN
3491: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3492: lc_mod_name,
3493: 'Calling CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_BOM');
3494: END IF;
3495: Get_Estimates_From_BOM(p_api_version => 1.0,
3496: p_commit => p_commit,
3497: p_init_msg_list => Fnd_Api.G_FALSE,

Line 3519: 'Returned from CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_BOM');

3515: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3516: THEN
3517: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3518: lc_mod_name,
3519: 'Returned from CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_BOM');
3520: END IF;
3521: ELSE
3522: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
3523: THEN

Line 4048: x_est_lines_tbl OUT NOCOPY CSD_REPAIR_ESTIMATE_PVT.REPAIR_ESTIMATE_LINE_TBL,

4044: p_inventory_item_id IN NUMBER,
4045: p_organization_id IN NUMBER,
4046: p_price_list_id IN NUMBER,
4047: p_contract_line_id IN NUMBER,
4048: x_est_lines_tbl OUT NOCOPY CSD_REPAIR_ESTIMATE_PVT.REPAIR_ESTIMATE_LINE_TBL,
4049: x_warning_flag OUT NOCOPY VARCHAR2) IS
4050: -- CONSTANTS --
4051: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
4052: lc_stat_level CONSTANT NUMBER := Fnd_Log.LEVEL_STATEMENT;

Line 4058: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.get_estimates_from_task';

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

Line 4642: 'Entering CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_Task');

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

Line 5155: 'Leaving CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_Task');

5151: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5152: THEN
5153: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5154: lc_mod_name || '.END',
5155: 'Leaving CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_Task');
5156: END IF;
5157: --
5158: -- End API Body
5159: --

Line 5308: x_est_lines_tbl OUT NOCOPY CSD_REPAIR_ESTIMATE_PVT.REPAIR_ESTIMATE_LINE_TBL,

5304: p_inventory_item_id IN NUMBER,
5305: p_organization_id IN NUMBER,
5306: p_price_list_id IN NUMBER,
5307: p_contract_line_id IN NUMBER,
5308: x_est_lines_tbl OUT NOCOPY CSD_REPAIR_ESTIMATE_PVT.REPAIR_ESTIMATE_LINE_TBL,
5309: x_warning_flag OUT NOCOPY VARCHAR2) IS
5310:
5311: -- CONSTANTS --
5312: lc_debug_level CONSTANT NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;

Line 5319: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.get_estimates_from_bom';

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

Line 5578: 'Entering CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_BOM');

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

Line 5842: 'Leaving CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_BOM');

5838: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5839: THEN
5840: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
5841: lc_mod_name || '.END',
5842: 'Leaving CSD_REPAIR_ESTIMATE_PVT.Get_Estimates_From_BOM');
5843: END IF;
5844:
5845: --
5846: -- End API Body

Line 6006: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repair_estimate_pvt.convert_to_est_lines';

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

Line 6068: 'Entering CSD_REPAIR_ESTIMATE_PVT.Convert_To_Est_Lines');

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

Line 6676: 'Leaving CSD_REPAIR_ESTIMATE_PVT.Convert_To_Est_Lines');

6672: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
6673: THEN
6674: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6675: lc_mod_name || '.END',
6676: 'Leaving CSD_REPAIR_ESTIMATE_PVT.Convert_To_Est_Lines');
6677: END IF;
6678:
6679: --
6680: -- End API Body

Line 6813: l_est_hdr_pvt_rec Csd_Repair_Estimate_Pvt.REPAIR_ESTIMATE_REC;

6809: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_ESTIMATE_HEADER';
6810: l_api_version CONSTANT NUMBER := 1.0;
6811:
6812: l_estimate_hdr_rec Csd_Repair_Estimate_Pub.ESTIMATE_HDR_REC;
6813: l_est_hdr_pvt_rec Csd_Repair_Estimate_Pvt.REPAIR_ESTIMATE_REC;
6814: BEGIN
6815:
6816: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level)
6817: THEN

Line 6819: 'csd.plsql.csd_repair_Estimate_pvt.create_estimate_header.begin',

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

Line 6906: Csd_Repair_Estimate_Pvt.create_repair_estimate(p_api_version => 1.0,

6902: debug('creating estimate header');
6903:
6904: csd_estimate_utils_pvt.COPY_TO_EST_HDR_REC(l_estimate_hdr_rec,
6905: l_est_hdr_pvt_rec);
6906: Csd_Repair_Estimate_Pvt.create_repair_estimate(p_api_version => 1.0,
6907: p_commit => Fnd_Api.G_FALSE,
6908: p_init_msg_list => Fnd_Api.G_FALSE,
6909: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
6910: x_estimate_rec => l_est_hdr_pvt_rec,

Line 6934: 'csd.plsql.csd_repair_Estimate_pvt.create_estimate_header.end',

6930:
6931: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level)
6932: THEN
6933: Fnd_Log.STRING(Fnd_Log.level_procedure,
6934: 'csd.plsql.csd_repair_Estimate_pvt.create_estimate_header.end',
6935: 'Leaving create_estimate_header');
6936: END IF;
6937:
6938: -- Standard call to get message count and IF count is get message info.

Line 6950: 'csd.plsql.csd_repair_estimate_pvt.create_estimate_header',

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

Line 6961: 'csd.plsql.csd_repair_estimate_pvt.create_estimate_header',

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

Line 6976: 'csd.plsql.csd_repair_estimate_pvt.create_estimate_header',

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

Line 7010: l_est_pvt_line_rec CSD_REPAIR_ESTIMATE_PVT.REPAIR_ESTIMATE_LINE_REC;

7006: l_api_version CONSTANT NUMBER := 1.0;
7007: l_no_charge_flag VARCHAR2(10);
7008: l_contract_line_id NUMBER;
7009:
7010: l_est_pvt_line_rec CSD_REPAIR_ESTIMATE_PVT.REPAIR_ESTIMATE_LINE_REC;
7011: l_estimate_line_rec Csd_Repair_Estimate_Pub.ESTIMATE_LINE_REC;
7012:
7013: BEGIN
7014:

Line 7042: 'csd.plsql.csd_repair_estimate_pvt.create_estimate_line.begin',

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

Line 7090: 'csd.plsql.csd_repair_estimate_pvt.create_estimate_line.end',

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

Line 7102: 'csd.plsql.csd_repair_estimate_pvt.create_estimate_line',

7098: p_data => x_msg_data);
7099: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
7100: THEN
7101: Fnd_Log.STRING(Fnd_Log.level_error,
7102: 'csd.plsql.csd_repair_estimate_pvt.create_estimate_line',
7103: 'EXC_ERROR[' || x_msg_data || ']');
7104: END IF;
7105:
7106: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 7114: 'csd.plsql.csd_repair_estimate_pvt.create_estimate_line',

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

Line 7129: 'csd.plsql.csd_repair_estimate_pvt.create_estimate_line',

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

Line 7159: l_est_pvt_hdr_Rec CSD_REPAIR_ESTIMATE_PVT.REPAIR_ESTIMATE_REC;

7155: l_msg_Data VARCHAR2(2000);
7156: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ESTIMATE_HEADER';
7157: l_api_version CONSTANT NUMBER := 1.0;
7158:
7159: l_est_pvt_hdr_Rec CSD_REPAIR_ESTIMATE_PVT.REPAIR_ESTIMATE_REC;
7160: l_estimate_hdr_rec Csd_Repair_Estimate_Pub.ESTIMATE_HDR_REC;
7161:
7162: l_est_status_changed BOOLEAN;
7163: l_est_hdr_id NUMBER;

Line 7228: 'csd.plsql.csd_repair_estimate_pvt.update_estimate_header.begin',

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

Line 7332: Csd_Repair_Estimate_Pvt.update_repair_estimate(p_api_version => 1.0,

7328:
7329: csd_estimate_utils_pvt.COPY_TO_EST_HDR_REC_UPD(l_estimate_hdr_rec,
7330: l_est_pvt_hdr_rec);
7331:
7332: Csd_Repair_Estimate_Pvt.update_repair_estimate(p_api_version => 1.0,
7333: p_commit => Fnd_Api.G_FALSE,
7334: p_init_msg_list => Fnd_Api.G_FALSE,
7335: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
7336: x_estimate_rec => l_est_pvt_hdr_rec,

Line 7364: 'csd.plsql.csd_repair_estimate_pvt.update_estimate_header.end',

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

Line 7376: 'csd.plsql.csd_repair_estimate_pvt.update_estimate_header',

7372: p_data => x_msg_data);
7373: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
7374: THEN
7375: Fnd_Log.STRING(Fnd_Log.level_error,
7376: 'csd.plsql.csd_repair_estimate_pvt.update_estimate_header',
7377: 'EXC_ERROR[' || x_msg_data || ']');
7378: END IF;
7379:
7380: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 7388: 'csd.plsql.csd_repair_estimate_pvt.update_estimate_header',

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

Line 7403: 'csd.plsql.csd_repair_estimate_pvt.update_estimate_header',

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

Line 7430: END Csd_Repair_Estimate_Pvt;

7426: BEGIN
7427: NULL;
7428: END UPDATE_ESTIMATE_LINE;
7429:
7430: END Csd_Repair_Estimate_Pvt;