15: -- --------------------------------------------------------------------------
16:
17: PROCEDURE log_exception
18: (p_api_version IN NUMBER,
19: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
20: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
21: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
22: x_return_status OUT NOCOPY VARCHAR2,
23: x_msg_count OUT NOCOPY NUMBER,
16:
17: PROCEDURE log_exception
18: (p_api_version IN NUMBER,
19: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
20: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
21: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
22: x_return_status OUT NOCOPY VARCHAR2,
23: x_msg_count OUT NOCOPY NUMBER,
24: x_msg_data OUT NOCOPY VARCHAR2,
17: PROCEDURE log_exception
18: (p_api_version IN NUMBER,
19: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
20: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
21: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
22: x_return_status OUT NOCOPY VARCHAR2,
23: x_msg_count OUT NOCOPY NUMBER,
24: x_msg_data OUT NOCOPY VARCHAR2,
25: x_exception_id IN OUT NOCOPY NUMBER,
24: x_msg_data OUT NOCOPY VARCHAR2,
25: x_exception_id IN OUT NOCOPY NUMBER,
26:
27: -- exception_location_id is a required field, assign it to
28: -- FND_API.G_MISS_NUM for insert, NULL for update
29: p_exception_location_id IN NUMBER,
30:
31: -- logged_at_location_id is a required field, assign it to
32: -- FND_API.G_MISS_NUM for insert, NULL for update
28: -- FND_API.G_MISS_NUM for insert, NULL for update
29: p_exception_location_id IN NUMBER,
30:
31: -- logged_at_location_id is a required field, assign it to
32: -- FND_API.G_MISS_NUM for insert, NULL for update
33: p_logged_at_location_id IN NUMBER,
34:
35: p_logging_entity IN VARCHAR2 DEFAULT NULL,
36: p_logging_entity_id IN NUMBER DEFAULT NULL,
101: -- --------------------------------------------------------------------------
102: -- Procedure: Change_ Status
103: -- Description: If the p_old_status matches the current exception status,
104: -- this procedure will change the status in two ways:
105: -- 1)if p_set_default_status = FND_API.G_TRUE (i.e. 'T'),
106: -- then it sets the exception to default status
107: -- 2)if p_set_default_status is missing, it sets the
108: -- exception to x_new_status
109: --
111:
112:
113: PROCEDURE change_status
114: (p_api_version IN NUMBER,
115: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
116: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
117: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
118: x_return_status OUT NOCOPY VARCHAR2,
119: x_msg_count OUT NOCOPY NUMBER,
112:
113: PROCEDURE change_status
114: (p_api_version IN NUMBER,
115: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
116: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
117: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
118: x_return_status OUT NOCOPY VARCHAR2,
119: x_msg_count OUT NOCOPY NUMBER,
120: x_msg_data OUT NOCOPY VARCHAR2,
113: PROCEDURE change_status
114: (p_api_version IN NUMBER,
115: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
116: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
117: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
118: x_return_status OUT NOCOPY VARCHAR2,
119: x_msg_count OUT NOCOPY NUMBER,
120: x_msg_data OUT NOCOPY VARCHAR2,
121: p_exception_id IN NUMBER,
119: x_msg_count OUT NOCOPY NUMBER,
120: x_msg_data OUT NOCOPY VARCHAR2,
121: p_exception_id IN NUMBER,
122: p_old_status IN VARCHAR2,
123: p_set_default_status IN VARCHAR2 DEFAULT FND_API.G_FALSE,
124: x_new_status IN OUT NOCOPY VARCHAR2
125: );
126:
127:
311: -- --------------------------------------------------------------------------
312:
313: PROCEDURE Purge
314: (p_api_version IN NUMBER,
315: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
316: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
317: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
318: x_return_status OUT NOCOPY VARCHAR2,
319: x_msg_count OUT NOCOPY NUMBER,
312:
313: PROCEDURE Purge
314: (p_api_version IN NUMBER,
315: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
316: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
317: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
318: x_return_status OUT NOCOPY VARCHAR2,
319: x_msg_count OUT NOCOPY NUMBER,
320: x_msg_data OUT NOCOPY VARCHAR2,
313: PROCEDURE Purge
314: (p_api_version IN NUMBER,
315: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
316: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
317: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
318: x_return_status OUT NOCOPY VARCHAR2,
319: x_msg_count OUT NOCOPY NUMBER,
320: x_msg_data OUT NOCOPY VARCHAR2,
321: p_request_id IN NUMBER DEFAULT NULL,
374:
375: PROCEDURE Check_Exceptions (
376: -- Standard parameters
377: p_api_version IN NUMBER,
378: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
379: x_return_status OUT NOCOPY VARCHAR2,
380: x_msg_count OUT NOCOPY NUMBER,
381: x_msg_data OUT NOCOPY VARCHAR2,
382:
411:
412: PROCEDURE Close_Exceptions (
413: -- Standard parameters
414: p_api_version IN NUMBER,
415: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
416: x_return_status OUT NOCOPY VARCHAR2,
417: x_msg_count OUT NOCOPY NUMBER,
418: x_msg_data OUT NOCOPY VARCHAR2,
419: