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_PUB dependencies on CSD_REPAIR_ESTIMATE_PUB

Line 1: Package BODY Csd_Repair_Estimate_Pub AS

1: Package BODY Csd_Repair_Estimate_Pub AS
2: /* $Header: csdpestb.pls 120.3 2005/08/02 14:48:23 vparvath noship $ */
3: /*#
4: * This is the public interface for managing a repair estimate. It allows
5: * creation/updation of repair estimate headers and lines for a repair order.

Line 17: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_REPAIR_ESTIMATE_PUB';

13: -- ---------------------------------------------------------
14: -- Define global variables
15: -- ---------------------------------------------------------
16:
17: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_REPAIR_ESTIMATE_PUB';
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdpestb.pls';
19:
20: /*--------------------------------------------------*/
21: /* procedure name: create_estimate_header */

Line 46: p_estimate_hdr_rec IN Csd_Repair_Estimate_Pub.ESTIMATE_HDR_REC,

42: p_init_msg_list IN VARCHAR2,
43: x_return_status OUT NOCOPY VARCHAR2,
44: x_msg_count OUT NOCOPY NUMBER,
45: x_msg_data OUT NOCOPY VARCHAR2,
46: p_estimate_hdr_rec IN Csd_Repair_Estimate_Pub.ESTIMATE_HDR_REC,
47: x_estimate_hdr_id OUT NOCOPY NUMBER) IS
48:
49: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_ESTIMATE_HEADER';
50: l_api_version CONSTANT NUMBER := 1.0;

Line 111: 'csd.plsql.csd_repair_estimate_pub.create_estimate_header',

107:
108: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
109: THEN
110: Fnd_Log.STRING(Fnd_Log.level_error,
111: 'csd.plsql.csd_repair_estimate_pub.create_estimate_header',
112: 'EXC_ERROR[' || x_msg_data || ']');
113: END IF;
114: WHEN Fnd_Api.g_exc_unexpected_error THEN
115: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

Line 123: 'csd.plsql.csd_repair_estimate_pub.create_estimate_header',

119:
120: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
121: THEN
122: Fnd_Log.STRING(Fnd_Log.level_exception,
123: 'csd.plsql.csd_repair_estimate_pub.create_estimate_header',
124: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');
125: END IF;
126: WHEN OTHERS THEN
127: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

Line 141: 'csd.plsql.csd_repair_estimate_pub.create_estimate_header',

137:
138: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
139: THEN
140: Fnd_Log.STRING(Fnd_Log.level_exception,
141: 'csd.plsql.csd_repair_estimate_pub.create_estimate_header',
142: 'SQL MEssage[' || SQLERRM || ']');
143: END IF;
144: END CREATE_ESTIMATE_HEADER;
145:

Line 172: p_estimate_hdr_rec IN Csd_Repair_Estimate_Pub.ESTIMATE_HDR_REC,

168: p_init_msg_list IN VARCHAR2,
169: x_return_status OUT NOCOPY VARCHAR2,
170: x_msg_count OUT NOCOPY NUMBER,
171: x_msg_data OUT NOCOPY VARCHAR2,
172: p_estimate_hdr_rec IN Csd_Repair_Estimate_Pub.ESTIMATE_HDR_REC,
173: x_object_version_number OUT NOCOPY NUMBER) IS
174: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ESTIMATE_HEADER';
175: l_api_version CONSTANT NUMBER := 1.0;
176:

Line 237: 'csd.plsql.csd_repair_estimate_pub.update_estimate_header',

233:
234: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
235: THEN
236: Fnd_Log.STRING(Fnd_Log.level_error,
237: 'csd.plsql.csd_repair_estimate_pub.update_estimate_header',
238: 'EXC_ERROR[' || x_msg_data || ']');
239: END IF;
240: WHEN Fnd_Api.g_exc_unexpected_error THEN
241: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

Line 249: 'csd.plsql.csd_repair_estimate_pub.update_estimate_header',

245:
246: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
247: THEN
248: Fnd_Log.STRING(Fnd_Log.level_exception,
249: 'csd.plsql.csd_repair_estimate_pub.update_estimate_header',
250: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');
251: END IF;
252: WHEN OTHERS THEN
253: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

Line 267: 'csd.plsql.csd_repair_estimate_pub.update_estimate_header',

263:
264: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
265: THEN
266: Fnd_Log.STRING(Fnd_Log.level_exception,
267: 'csd.plsql.csd_repair_estimate_pub.update_estimate_header',
268: 'SQL MEssage[' || SQLERRM || ']');
269: END IF;
270: END update_estimate_header;
271:

Line 298: p_estimate_line_rec IN Csd_Repair_Estimate_Pub.ESTIMATE_LINE_REC,

294: p_init_msg_list IN VARCHAR2,
295: x_return_status OUT NOCOPY VARCHAR2,
296: x_msg_count OUT NOCOPY NUMBER,
297: x_msg_data OUT NOCOPY VARCHAR2,
298: p_estimate_line_rec IN Csd_Repair_Estimate_Pub.ESTIMATE_LINE_REC,
299: x_estimate_line_id OUT NOCOPY NUMBER)
300:
301: IS
302:

Line 365: 'csd.plsql.csd_repair_estimate_pub.create_estimate_line',

361:
362: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
363: THEN
364: Fnd_Log.STRING(Fnd_Log.level_error,
365: 'csd.plsql.csd_repair_estimate_pub.create_estimate_line',
366: 'EXC_ERROR[' || x_msg_data || ']');
367: END IF;
368: WHEN Fnd_Api.g_exc_unexpected_error THEN
369: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

Line 377: 'csd.plsql.csd_repair_estimate_pub.create_estimate_line',

373:
374: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
375: THEN
376: Fnd_Log.STRING(Fnd_Log.level_exception,
377: 'csd.plsql.csd_repair_estimate_pub.create_estimate_line',
378: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');
379: END IF;
380: WHEN OTHERS THEN
381: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

Line 395: 'csd.plsql.csd_repair_estimate_pub.create_estimate_line',

391:
392: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
393: THEN
394: Fnd_Log.STRING(Fnd_Log.level_exception,
395: 'csd.plsql.csd_repair_estimate_pub.create_estimate_line',
396: 'SQL MEssage[' || SQLERRM || ']');
397: END IF;
398: END create_estimate_line;
399:

Line 426: p_estimate_line_rec IN Csd_Repair_Estimate_Pub.ESTIMATE_LINE_REC,

422: p_commit IN VARCHAR2,
423: x_return_status OUT NOCOPY VARCHAR2,
424: x_msg_count OUT NOCOPY NUMBER,
425: x_msg_data OUT NOCOPY VARCHAR2,
426: p_estimate_line_rec IN Csd_Repair_Estimate_Pub.ESTIMATE_LINE_REC,
427: x_object_version_number OUT NOCOPY NUMBER)
428:
429: IS
430:

Line 493: 'csd.plsql.csd_repair_estimate_pub.update_estimate_line',

489:
490: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
491: THEN
492: Fnd_Log.STRING(Fnd_Log.level_error,
493: 'csd.plsql.csd_repair_estimate_pub.update_estimate_line',
494: 'EXC_ERROR[' || x_msg_data || ']');
495: END IF;
496: WHEN Fnd_Api.g_exc_unexpected_error THEN
497: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

Line 505: 'csd.plsql.csd_repair_estimate_pub.update_estimate_line',

501:
502: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
503: THEN
504: Fnd_Log.STRING(Fnd_Log.level_exception,
505: 'csd.plsql.csd_repair_estimate_pub.update_estimate_line',
506: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');
507: END IF;
508: WHEN OTHERS THEN
509: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

Line 523: 'csd.plsql.csd_repair_estimate_pub.update_estimate_line',

519:
520: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
521: THEN
522: Fnd_Log.STRING(Fnd_Log.level_exception,
523: 'csd.plsql.csd_repair_estimate_pub.update_estimate_line',
524: 'SQL MEssage[' || SQLERRM || ']');
525: END IF;
526: END update_estimate_line;
527:

Line 528: END Csd_Repair_Estimate_Pub;

524: 'SQL MEssage[' || SQLERRM || ']');
525: END IF;
526: END update_estimate_line;
527:
528: END Csd_Repair_Estimate_Pub;