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.AHL_REPAIR_CATEGORIES_PVT dependencies on FND_API

Line 23: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

19:
20: PROCEDURE PROCESS_REPAIR_CATEGORIES
21: (
22: p_api_version IN NUMBER,
23: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
24: p_commit IN VARCHAR2 := FND_API.G_TRUE,
25: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
26: p_default IN VARCHAR2 := FND_API.G_FALSE,
27: p_module_type IN VARCHAR2 := NULL,

Line 24: p_commit IN VARCHAR2 := FND_API.G_TRUE,

20: PROCEDURE PROCESS_REPAIR_CATEGORIES
21: (
22: p_api_version IN NUMBER,
23: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
24: p_commit IN VARCHAR2 := FND_API.G_TRUE,
25: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
26: p_default IN VARCHAR2 := FND_API.G_FALSE,
27: p_module_type IN VARCHAR2 := NULL,
28: x_return_status OUT NOCOPY VARCHAR2,

Line 25: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

21: (
22: p_api_version IN NUMBER,
23: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
24: p_commit IN VARCHAR2 := FND_API.G_TRUE,
25: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
26: p_default IN VARCHAR2 := FND_API.G_FALSE,
27: p_module_type IN VARCHAR2 := NULL,
28: x_return_status OUT NOCOPY VARCHAR2,
29: x_msg_count OUT NOCOPY NUMBER,

Line 26: p_default IN VARCHAR2 := FND_API.G_FALSE,

22: p_api_version IN NUMBER,
23: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
24: p_commit IN VARCHAR2 := FND_API.G_TRUE,
25: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
26: p_default IN VARCHAR2 := FND_API.G_FALSE,
27: p_module_type IN VARCHAR2 := NULL,
28: x_return_status OUT NOCOPY VARCHAR2,
29: x_msg_count OUT NOCOPY NUMBER,
30: x_msg_data OUT NOCOPY VARCHAR2,

Line 106: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,p_api_version,l_api_name,G_PKG_NAME)

102: -- Standard Start of API savepoint
103: SAVEPOINT process_repair_categories_sp;
104:
105: -- Standard call to check for call compatibility.
106: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,p_api_version,l_api_name,G_PKG_NAME)
107: THEN
108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
109: END IF;
110:

Line 108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

104:
105: -- Standard call to check for call compatibility.
106: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,p_api_version,l_api_name,G_PKG_NAME)
107: THEN
108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
109: END IF;
110:
111: -- Initialize message list if p_init_msg_list is set to TRUE.
112: IF FND_API.to_boolean(p_init_msg_list)

Line 112: IF FND_API.to_boolean(p_init_msg_list)

108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
109: END IF;
110:
111: -- Initialize message list if p_init_msg_list is set to TRUE.
112: IF FND_API.to_boolean(p_init_msg_list)
113: THEN
114: FND_MSG_PUB.initialize;
115: END IF;
116:

Line 118: x_return_status := FND_API.G_RET_STS_SUCCESS;

114: FND_MSG_PUB.initialize;
115: END IF;
116:
117: -- Initialize API return status to success
118: x_return_status := FND_API.G_RET_STS_SUCCESS;
119:
120: IF p_x_repair_category_tbl.count > 0
121: THEN
122: -- The first loop will perform all common validations + delete the records

Line 132: RAISE FND_API.G_EXC_ERROR;

128: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_COM_INVALID_DML');
129: FND_MESSAGE.SET_TOKEN('FIELD', p_x_repair_category_tbl(i).dml_operation);
130: FND_MESSAGE.SET_TOKEN('RECORD', p_x_repair_category_tbl(i).incident_urgency_name||' - '||p_x_repair_category_tbl(i).repair_time);
131: FND_MSG_PUB.ADD;
132: RAISE FND_API.G_EXC_ERROR;
133: END IF;
134:
135: IF (p_x_repair_category_tbl(i).DML_OPERATION = 'D')
136: THEN

Line 167: RAISE FND_API.G_EXC_ERROR;

163: -- Check error message stack
164: x_msg_count := FND_MSG_PUB.count_msg;
165: IF x_msg_count > 0
166: THEN
167: RAISE FND_API.G_EXC_ERROR;
168: END IF;
169: END IF;
170: END LOOP;
171:

Line 185: IF (p_x_repair_category_tbl(i).incident_urgency_name IS NOT NULL AND p_x_repair_category_tbl(i).incident_urgency_name <> FND_API.G_MISS_CHAR)

181: p_x_repair_category_tbl(i).object_version_number
182: );
183:
184: -- Resolve sr urgency name and id, perform mandatory validations
185: IF (p_x_repair_category_tbl(i).incident_urgency_name IS NOT NULL AND p_x_repair_category_tbl(i).incident_urgency_name <> FND_API.G_MISS_CHAR)
186: THEN
187: OPEN get_srurg_id_from_name (p_x_repair_category_tbl(i).incident_urgency_name);
188: FETCH get_srurg_id_from_name INTO p_x_repair_category_tbl(i).incident_urgency_id;
189: IF (get_srurg_id_from_name%NOTFOUND)

Line 196: ELSIF (p_x_repair_category_tbl(i).incident_urgency_id IS NOT NULL AND p_x_repair_category_tbl(i).incident_urgency_id <> FND_API.G_MISS_NUM)

192: FND_MESSAGE.SET_TOKEN('SRNAME', p_x_repair_category_tbl(i).incident_urgency_name);
193: FND_MSG_PUB.ADD;
194: END IF;
195: CLOSE get_srurg_id_from_name;
196: ELSIF (p_x_repair_category_tbl(i).incident_urgency_id IS NOT NULL AND p_x_repair_category_tbl(i).incident_urgency_id <> FND_API.G_MISS_NUM)
197: THEN
198: OPEN check_srurg_exists (p_x_repair_category_tbl(i).incident_urgency_id);
199: FETCH check_srurg_exists INTO p_x_repair_category_tbl(i).incident_urgency_name;
200: IF (check_srurg_exists%NOTFOUND)

Line 205: RAISE FND_API.G_EXC_ERROR;

201: THEN
202: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_MEL_CDL_SRURG_INV');
203: FND_MESSAGE.SET_TOKEN('SRNAME', p_x_repair_category_tbl(i).incident_urgency_id);
204: FND_MSG_PUB.ADD;
205: RAISE FND_API.G_EXC_ERROR;
206: END IF;
207: CLOSE check_srurg_exists;
208: ELSE
209: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_MEL_CDL_SRURG_MAND');

Line 250: RAISE FND_API.G_EXC_ERROR;

246: -- Check error message stack
247: x_msg_count := FND_MSG_PUB.count_msg;
248: IF x_msg_count > 0
249: THEN
250: RAISE FND_API.G_EXC_ERROR;
251: END IF;
252:
253: -- Default values for update
254: p_x_repair_category_tbl(i).object_version_number := p_x_repair_category_tbl(i).object_version_number + 1;

Line 300: IF (p_x_repair_category_tbl(i).incident_urgency_name IS NOT NULL AND p_x_repair_category_tbl(i).incident_urgency_name <> FND_API.G_MISS_CHAR)

296: IF (p_x_repair_category_tbl(i).dml_operation = 'C')
297: THEN
298:
299: -- Resolve sr urgency name and id, perform mandatory validations
300: IF (p_x_repair_category_tbl(i).incident_urgency_name IS NOT NULL AND p_x_repair_category_tbl(i).incident_urgency_name <> FND_API.G_MISS_CHAR)
301: THEN
302: OPEN get_srurg_id_from_name (p_x_repair_category_tbl(i).incident_urgency_name);
303: FETCH get_srurg_id_from_name INTO p_x_repair_category_tbl(i).incident_urgency_id;
304: IF (get_srurg_id_from_name%NOTFOUND)

Line 311: ELSIF (p_x_repair_category_tbl(i).incident_urgency_id IS NOT NULL AND p_x_repair_category_tbl(i).incident_urgency_id <> FND_API.G_MISS_NUM)

307: FND_MESSAGE.SET_TOKEN('SRNAME', p_x_repair_category_tbl(i).incident_urgency_name);
308: FND_MSG_PUB.ADD;
309: END IF;
310: CLOSE get_srurg_id_from_name;
311: ELSIF (p_x_repair_category_tbl(i).incident_urgency_id IS NOT NULL AND p_x_repair_category_tbl(i).incident_urgency_id <> FND_API.G_MISS_NUM)
312: THEN
313: OPEN check_srurg_exists (p_x_repair_category_tbl(i).incident_urgency_id);
314: FETCH check_srurg_exists INTO p_x_repair_category_tbl(i).incident_urgency_name;
315: IF (check_srurg_exists%NOTFOUND)

Line 320: RAISE FND_API.G_EXC_ERROR;

316: THEN
317: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_MEL_CDL_SRURG_INV');
318: FND_MESSAGE.SET_TOKEN('SRNAME', p_x_repair_category_tbl(i).incident_urgency_id);
319: FND_MSG_PUB.ADD;
320: RAISE FND_API.G_EXC_ERROR;
321: END IF;
322: CLOSE check_srurg_exists;
323: ELSE
324: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_MEL_CDL_SRURG_MAND');

Line 365: RAISE FND_API.G_EXC_ERROR;

361: -- Check error message stack
362: x_msg_count := FND_MSG_PUB.count_msg;
363: IF x_msg_count > 0
364: THEN
365: RAISE FND_API.G_EXC_ERROR;
366: END IF;
367:
368: -- Default values for create
369: IF (p_x_repair_category_tbl(i).repair_category_id IS NULL OR p_x_repair_category_tbl(i).repair_category_id = FND_API.G_MISS_NUM)

Line 369: IF (p_x_repair_category_tbl(i).repair_category_id IS NULL OR p_x_repair_category_tbl(i).repair_category_id = FND_API.G_MISS_NUM)

365: RAISE FND_API.G_EXC_ERROR;
366: END IF;
367:
368: -- Default values for create
369: IF (p_x_repair_category_tbl(i).repair_category_id IS NULL OR p_x_repair_category_tbl(i).repair_category_id = FND_API.G_MISS_NUM)
370: THEN
371: select ahl_repair_categories_s.nextval into p_x_repair_category_tbl(i).repair_category_id from dual;
372: END IF;
373: p_x_repair_category_tbl(i).object_version_number := 1;

Line 449: RAISE FND_API.G_EXC_ERROR;

445: -- Check error message stack at completing proc
446: x_msg_count := FND_MSG_PUB.count_msg;
447: IF x_msg_count > 0
448: THEN
449: RAISE FND_API.G_EXC_ERROR;
450: END IF;
451:
452: -- Commit if required to do so
453: IF FND_API.TO_BOOLEAN (p_commit)

Line 453: IF FND_API.TO_BOOLEAN (p_commit)

449: RAISE FND_API.G_EXC_ERROR;
450: END IF;
451:
452: -- Commit if required to do so
453: IF FND_API.TO_BOOLEAN (p_commit)
454: THEN
455: COMMIT WORK;
456: END IF;
457:

Line 463: p_encoded => FND_API.G_FALSE

459: FND_MSG_PUB.count_and_get
460: (
461: p_count => x_msg_count,
462: p_data => x_msg_data,
463: p_encoded => FND_API.G_FALSE
464: );
465:
466: EXCEPTION
467: WHEN FND_API.G_EXC_ERROR THEN

Line 467: WHEN FND_API.G_EXC_ERROR THEN

463: p_encoded => FND_API.G_FALSE
464: );
465:
466: EXCEPTION
467: WHEN FND_API.G_EXC_ERROR THEN
468: x_return_status := FND_API.G_RET_STS_ERROR;
469: Rollback to process_repair_categories_sp;
470: FND_MSG_PUB.count_and_get
471: (

Line 468: x_return_status := FND_API.G_RET_STS_ERROR;

464: );
465:
466: EXCEPTION
467: WHEN FND_API.G_EXC_ERROR THEN
468: x_return_status := FND_API.G_RET_STS_ERROR;
469: Rollback to process_repair_categories_sp;
470: FND_MSG_PUB.count_and_get
471: (
472: p_count => x_msg_count,

Line 474: p_encoded => FND_API.G_FALSE

470: FND_MSG_PUB.count_and_get
471: (
472: p_count => x_msg_count,
473: p_data => x_msg_data,
474: p_encoded => FND_API.G_FALSE
475: );
476:
477: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 477: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

473: p_data => x_msg_data,
474: p_encoded => FND_API.G_FALSE
475: );
476:
477: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
479: Rollback to process_repair_categories_sp;
480: FND_MSG_PUB.count_and_get
481: (

Line 478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

474: p_encoded => FND_API.G_FALSE
475: );
476:
477: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
479: Rollback to process_repair_categories_sp;
480: FND_MSG_PUB.count_and_get
481: (
482: p_count => x_msg_count,

Line 484: p_encoded => FND_API.G_FALSE

480: FND_MSG_PUB.count_and_get
481: (
482: p_count => x_msg_count,
483: p_data => x_msg_data,
484: p_encoded => FND_API.G_FALSE
485: );
486:
487: WHEN OTHERS THEN
488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

484: p_encoded => FND_API.G_FALSE
485: );
486:
487: WHEN OTHERS THEN
488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
489: Rollback to process_repair_categories_sp;
490: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
491: THEN
492: FND_MSG_PUB.add_exc_msg

Line 503: p_encoded => FND_API.G_FALSE

499: FND_MSG_PUB.count_and_get
500: (
501: p_count => x_msg_count,
502: p_data => x_msg_data,
503: p_encoded => FND_API.G_FALSE
504: );
505: END PROCESS_REPAIR_CATEGORIES;
506:
507: ---------------------------

Line 536: RAISE FND_API.G_EXC_ERROR;

532: THEN
533: CLOSE check_rep_cat_exists;
534: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_REPCAT_NOTFOUND');
535: FND_MSG_PUB.ADD;
536: RAISE FND_API.G_EXC_ERROR;
537: ELSIF (p_object_ver_num <> l_dummy_number)
538: THEN
539: CLOSE check_rep_cat_exists;
540: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_COM_RECORD_CHANGED');

Line 542: RAISE FND_API.G_EXC_ERROR;

538: THEN
539: CLOSE check_rep_cat_exists;
540: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_COM_RECORD_CHANGED');
541: FND_MSG_PUB.ADD;
542: RAISE FND_API.G_EXC_ERROR;
543: END IF;
544: CLOSE check_rep_cat_exists;
545:
546: END VALIDATE_REP_CAT_EXISTS;