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

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

24: -- Version Initial version number = 1.0
25: -- History Current version number = 1.0
26: --=======================================================
27: procedure UPDATE_OBJECT (
28: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
29: p_api_version_number IN NUMBER,
30: p_init_msg_tbl IN BOOLEAN := FALSE,
31: p_msg_count OUT NOCOPY NUMBER,
32: p_msg_data OUT NOCOPY VARCHAR2,

Line 35: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

31: p_msg_count OUT NOCOPY NUMBER,
32: p_msg_data OUT NOCOPY VARCHAR2,
33: p_return_status OUT NOCOPY VARCHAR2,
34: p_database_object_name IN VARCHAR2,
35: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
38: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 36: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

32: p_msg_data OUT NOCOPY VARCHAR2,
33: p_return_status OUT NOCOPY VARCHAR2,
34: p_database_object_name IN VARCHAR2,
35: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
38: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 37: p_application_id IN NUMBER := FND_API.G_MISS_NUM,

33: p_return_status OUT NOCOPY VARCHAR2,
34: p_database_object_name IN VARCHAR2,
35: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
38: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 38: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

34: p_database_object_name IN VARCHAR2,
35: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
38: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 39: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

35: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
38: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 40: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

36: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
38: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 41: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

37: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
38: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 42: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

38: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 43: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

39: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 44: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

40: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 45: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

41: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 46: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

42: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 47: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

43: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 48: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

44: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 49: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

45: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 50: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

46: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 51: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

47: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 52: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

48: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 53: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

49: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 54: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

50: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 55: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

51: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 56: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

52: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
60: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 57: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

53: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
60: p_creation_date IN DATE := FND_API.G_MISS_DATE,
61: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 58: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

54: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
60: p_creation_date IN DATE := FND_API.G_MISS_DATE,
61: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
62: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

Line 59: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

55: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
60: p_creation_date IN DATE := FND_API.G_MISS_DATE,
61: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
62: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
63: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

Line 60: p_creation_date IN DATE := FND_API.G_MISS_DATE,

56: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
60: p_creation_date IN DATE := FND_API.G_MISS_DATE,
61: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
62: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
63: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
64: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

Line 61: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

57: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
60: p_creation_date IN DATE := FND_API.G_MISS_DATE,
61: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
62: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
63: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
64: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
65: p_pass IN NUMBER,

Line 62: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

58: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
60: p_creation_date IN DATE := FND_API.G_MISS_DATE,
61: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
62: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
63: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
64: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
65: p_pass IN NUMBER,
66: p_copy_redo_flag IN OUT NOCOPY BOOLEAN

Line 63: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

59: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
60: p_creation_date IN DATE := FND_API.G_MISS_DATE,
61: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
62: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
63: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
64: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
65: p_pass IN NUMBER,
66: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
67: ) is

Line 64: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

60: p_creation_date IN DATE := FND_API.G_MISS_DATE,
61: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
62: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
63: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
64: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
65: p_pass IN NUMBER,
66: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
67: ) is
68: cursor l_get_row_csr (lang_parm varchar2) is

Line 92: IF NOT FND_API.Compatible_API_Call (

88: l_last_updated_by number;
89: l_return_status varchar2(1);
90: l_file_version number;
91: begin
92: IF NOT FND_API.Compatible_API_Call (
93: l_api_version_number, p_api_version_number, l_api_name,
94: G_PKG_NAME) then
95: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
96: return;

Line 95: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

91: begin
92: IF NOT FND_API.Compatible_API_Call (
93: l_api_version_number, p_api_version_number, l_api_name,
94: G_PKG_NAME) then
95: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
96: return;
97: END IF;
98:
99: -- Initialize the message table if requested.

Line 120: raise FND_API.G_EXC_ERROR;

116: FND_MSG_PUB.Add;
117: end if;
118: -- dbms_output.put_line(l_api_name || 'Error - Row does not exist');
119: close l_get_row_csr;
120: raise FND_API.G_EXC_ERROR;
121: end if;
122: close l_get_row_csr;
123:
124: --** retrieve ak_objects_tl row if it exists **

Line 133: raise FND_API.G_EXC_ERROR;

129: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DOES_NOT_EXIST');
130: FND_MSG_PUB.Add;
131: end if;
132: close l_get_tl_row_csr;
133: raise FND_API.G_EXC_ERROR;
134: end if;
135: close l_get_tl_row_csr;
136:
137: --** validate table columns passed in **

Line 138: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then

134: end if;
135: close l_get_tl_row_csr;
136:
137: --** validate table columns passed in **
138: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then
139: if not AK_OBJECT_PVT.VALIDATE_OBJECT(
140: p_validation_level => p_validation_level,
141: p_api_version_number => 1.0,
142: p_return_status => l_return_status,

Line 158: raise FND_API.G_EXC_ERROR;

154: ) then
155: if (p_pass = 1) then
156: p_copy_redo_flag := TRUE;
157: else
158: raise FND_API.G_EXC_ERROR;
159: end if;
160: end if;
161: end if;
162:

Line 166: if (p_primary_key_name <> FND_API.G_MISS_CHAR) or

162:
163: --** Load record to be updated to the database **
164: --** - first load nullable columns **
165:
166: if (p_primary_key_name <> FND_API.G_MISS_CHAR) or
167: (p_primary_key_name is null) then
168: l_objects_rec.primary_key_name := p_primary_key_name;
169: end if;
170: if (p_defaulting_api_pkg <> FND_API.G_MISS_CHAR) or

Line 170: if (p_defaulting_api_pkg <> FND_API.G_MISS_CHAR) or

166: if (p_primary_key_name <> FND_API.G_MISS_CHAR) or
167: (p_primary_key_name is null) then
168: l_objects_rec.primary_key_name := p_primary_key_name;
169: end if;
170: if (p_defaulting_api_pkg <> FND_API.G_MISS_CHAR) or
171: (p_defaulting_api_pkg is null) then
172: l_objects_rec.defaulting_api_pkg := p_defaulting_api_pkg;
173: end if;
174: if (p_defaulting_api_proc <> FND_API.G_MISS_CHAR) or

Line 174: if (p_defaulting_api_proc <> FND_API.G_MISS_CHAR) or

170: if (p_defaulting_api_pkg <> FND_API.G_MISS_CHAR) or
171: (p_defaulting_api_pkg is null) then
172: l_objects_rec.defaulting_api_pkg := p_defaulting_api_pkg;
173: end if;
174: if (p_defaulting_api_proc <> FND_API.G_MISS_CHAR) or
175: (p_defaulting_api_proc is null) then
176: l_objects_rec.defaulting_api_proc := p_defaulting_api_proc;
177: end if;
178: if (p_validation_api_pkg <> FND_API.G_MISS_CHAR) or

Line 178: if (p_validation_api_pkg <> FND_API.G_MISS_CHAR) or

174: if (p_defaulting_api_proc <> FND_API.G_MISS_CHAR) or
175: (p_defaulting_api_proc is null) then
176: l_objects_rec.defaulting_api_proc := p_defaulting_api_proc;
177: end if;
178: if (p_validation_api_pkg <> FND_API.G_MISS_CHAR) or
179: (p_validation_api_pkg is null) then
180: l_objects_rec.validation_api_pkg := p_validation_api_pkg;
181: end if;
182: if (p_validation_api_proc <> FND_API.G_MISS_CHAR) or

Line 182: if (p_validation_api_proc <> FND_API.G_MISS_CHAR) or

178: if (p_validation_api_pkg <> FND_API.G_MISS_CHAR) or
179: (p_validation_api_pkg is null) then
180: l_objects_rec.validation_api_pkg := p_validation_api_pkg;
181: end if;
182: if (p_validation_api_proc <> FND_API.G_MISS_CHAR) or
183: (p_validation_api_proc is null) then
184: l_objects_rec.validation_api_proc := p_validation_api_proc;
185: end if;
186: if (p_attribute_category <> FND_API.G_MISS_CHAR) or

Line 186: if (p_attribute_category <> FND_API.G_MISS_CHAR) or

182: if (p_validation_api_proc <> FND_API.G_MISS_CHAR) or
183: (p_validation_api_proc is null) then
184: l_objects_rec.validation_api_proc := p_validation_api_proc;
185: end if;
186: if (p_attribute_category <> FND_API.G_MISS_CHAR) or
187: (p_attribute_category is null) then
188: l_objects_rec.attribute_category := p_attribute_category;
189: end if;
190: if (p_attribute1 <> FND_API.G_MISS_CHAR) or

Line 190: if (p_attribute1 <> FND_API.G_MISS_CHAR) or

186: if (p_attribute_category <> FND_API.G_MISS_CHAR) or
187: (p_attribute_category is null) then
188: l_objects_rec.attribute_category := p_attribute_category;
189: end if;
190: if (p_attribute1 <> FND_API.G_MISS_CHAR) or
191: (p_attribute1 is null) then
192: l_objects_rec.attribute1 := p_attribute1;
193: end if;
194: if (p_attribute2 <> FND_API.G_MISS_CHAR) or

Line 194: if (p_attribute2 <> FND_API.G_MISS_CHAR) or

190: if (p_attribute1 <> FND_API.G_MISS_CHAR) or
191: (p_attribute1 is null) then
192: l_objects_rec.attribute1 := p_attribute1;
193: end if;
194: if (p_attribute2 <> FND_API.G_MISS_CHAR) or
195: (p_attribute2 is null) then
196: l_objects_rec.attribute2 := p_attribute2;
197: end if;
198: if (p_attribute3 <> FND_API.G_MISS_CHAR) or

Line 198: if (p_attribute3 <> FND_API.G_MISS_CHAR) or

194: if (p_attribute2 <> FND_API.G_MISS_CHAR) or
195: (p_attribute2 is null) then
196: l_objects_rec.attribute2 := p_attribute2;
197: end if;
198: if (p_attribute3 <> FND_API.G_MISS_CHAR) or
199: (p_attribute3 is null) then
200: l_objects_rec.attribute3 := p_attribute3;
201: end if;
202: if (p_attribute4 <> FND_API.G_MISS_CHAR) or

Line 202: if (p_attribute4 <> FND_API.G_MISS_CHAR) or

198: if (p_attribute3 <> FND_API.G_MISS_CHAR) or
199: (p_attribute3 is null) then
200: l_objects_rec.attribute3 := p_attribute3;
201: end if;
202: if (p_attribute4 <> FND_API.G_MISS_CHAR) or
203: (p_attribute4 is null) then
204: l_objects_rec.attribute4 := p_attribute4;
205: end if;
206: if (p_attribute5 <> FND_API.G_MISS_CHAR) or

Line 206: if (p_attribute5 <> FND_API.G_MISS_CHAR) or

202: if (p_attribute4 <> FND_API.G_MISS_CHAR) or
203: (p_attribute4 is null) then
204: l_objects_rec.attribute4 := p_attribute4;
205: end if;
206: if (p_attribute5 <> FND_API.G_MISS_CHAR) or
207: (p_attribute5 is null) then
208: l_objects_rec.attribute5 := p_attribute5;
209: end if;
210: if (p_attribute6 <> FND_API.G_MISS_CHAR) or

Line 210: if (p_attribute6 <> FND_API.G_MISS_CHAR) or

206: if (p_attribute5 <> FND_API.G_MISS_CHAR) or
207: (p_attribute5 is null) then
208: l_objects_rec.attribute5 := p_attribute5;
209: end if;
210: if (p_attribute6 <> FND_API.G_MISS_CHAR) or
211: (p_attribute6 is null) then
212: l_objects_rec.attribute6 := p_attribute6;
213: end if;
214: if (p_attribute7 <> FND_API.G_MISS_CHAR) or

Line 214: if (p_attribute7 <> FND_API.G_MISS_CHAR) or

210: if (p_attribute6 <> FND_API.G_MISS_CHAR) or
211: (p_attribute6 is null) then
212: l_objects_rec.attribute6 := p_attribute6;
213: end if;
214: if (p_attribute7 <> FND_API.G_MISS_CHAR) or
215: (p_attribute7 is null) then
216: l_objects_rec.attribute7 := p_attribute7;
217: end if;
218: if (p_attribute8 <> FND_API.G_MISS_CHAR) or

Line 218: if (p_attribute8 <> FND_API.G_MISS_CHAR) or

214: if (p_attribute7 <> FND_API.G_MISS_CHAR) or
215: (p_attribute7 is null) then
216: l_objects_rec.attribute7 := p_attribute7;
217: end if;
218: if (p_attribute8 <> FND_API.G_MISS_CHAR) or
219: (p_attribute8 is null) then
220: l_objects_rec.attribute8 := p_attribute8;
221: end if;
222: if (p_attribute9 <> FND_API.G_MISS_CHAR) or

Line 222: if (p_attribute9 <> FND_API.G_MISS_CHAR) or

218: if (p_attribute8 <> FND_API.G_MISS_CHAR) or
219: (p_attribute8 is null) then
220: l_objects_rec.attribute8 := p_attribute8;
221: end if;
222: if (p_attribute9 <> FND_API.G_MISS_CHAR) or
223: (p_attribute9 is null) then
224: l_objects_rec.attribute9 := p_attribute9;
225: end if;
226: if (p_attribute10 <> FND_API.G_MISS_CHAR) or

Line 226: if (p_attribute10 <> FND_API.G_MISS_CHAR) or

222: if (p_attribute9 <> FND_API.G_MISS_CHAR) or
223: (p_attribute9 is null) then
224: l_objects_rec.attribute9 := p_attribute9;
225: end if;
226: if (p_attribute10 <> FND_API.G_MISS_CHAR) or
227: (p_attribute10 is null) then
228: l_objects_rec.attribute10 := p_attribute10;
229: end if;
230: if (p_attribute11 <> FND_API.G_MISS_CHAR) or

Line 230: if (p_attribute11 <> FND_API.G_MISS_CHAR) or

226: if (p_attribute10 <> FND_API.G_MISS_CHAR) or
227: (p_attribute10 is null) then
228: l_objects_rec.attribute10 := p_attribute10;
229: end if;
230: if (p_attribute11 <> FND_API.G_MISS_CHAR) or
231: (p_attribute11 is null) then
232: l_objects_rec.attribute11 := p_attribute11;
233: end if;
234: if (p_attribute12 <> FND_API.G_MISS_CHAR) or

Line 234: if (p_attribute12 <> FND_API.G_MISS_CHAR) or

230: if (p_attribute11 <> FND_API.G_MISS_CHAR) or
231: (p_attribute11 is null) then
232: l_objects_rec.attribute11 := p_attribute11;
233: end if;
234: if (p_attribute12 <> FND_API.G_MISS_CHAR) or
235: (p_attribute12 is null) then
236: l_objects_rec.attribute12 := p_attribute12;
237: end if;
238: if (p_attribute13 <> FND_API.G_MISS_CHAR) or

Line 238: if (p_attribute13 <> FND_API.G_MISS_CHAR) or

234: if (p_attribute12 <> FND_API.G_MISS_CHAR) or
235: (p_attribute12 is null) then
236: l_objects_rec.attribute12 := p_attribute12;
237: end if;
238: if (p_attribute13 <> FND_API.G_MISS_CHAR) or
239: (p_attribute13 is null) then
240: l_objects_rec.attribute13 := p_attribute13;
241: end if;
242: if (p_attribute14 <> FND_API.G_MISS_CHAR) or

Line 242: if (p_attribute14 <> FND_API.G_MISS_CHAR) or

238: if (p_attribute13 <> FND_API.G_MISS_CHAR) or
239: (p_attribute13 is null) then
240: l_objects_rec.attribute13 := p_attribute13;
241: end if;
242: if (p_attribute14 <> FND_API.G_MISS_CHAR) or
243: (p_attribute14 is null) then
244: l_objects_rec.attribute14 := p_attribute14;
245: end if;
246: if (p_attribute15 <> FND_API.G_MISS_CHAR) or

Line 246: if (p_attribute15 <> FND_API.G_MISS_CHAR) or

242: if (p_attribute14 <> FND_API.G_MISS_CHAR) or
243: (p_attribute14 is null) then
244: l_objects_rec.attribute14 := p_attribute14;
245: end if;
246: if (p_attribute15 <> FND_API.G_MISS_CHAR) or
247: (p_attribute15 is null) then
248: l_objects_rec.attribute15 := p_attribute15;
249: end if;
250: if (p_name <> FND_API.G_MISS_CHAR) or

Line 250: if (p_name <> FND_API.G_MISS_CHAR) or

246: if (p_attribute15 <> FND_API.G_MISS_CHAR) or
247: (p_attribute15 is null) then
248: l_objects_rec.attribute15 := p_attribute15;
249: end if;
250: if (p_name <> FND_API.G_MISS_CHAR) or
251: (p_name is null) then
252: l_objects_tl_rec.name := p_name;
253: end if;
254: if (p_description <> FND_API.G_MISS_CHAR) or

Line 254: if (p_description <> FND_API.G_MISS_CHAR) or

250: if (p_name <> FND_API.G_MISS_CHAR) or
251: (p_name is null) then
252: l_objects_tl_rec.name := p_name;
253: end if;
254: if (p_description <> FND_API.G_MISS_CHAR) or
255: (p_description is null) then
256: l_objects_tl_rec.description := p_description;
257: end if;
258:

Line 261: if (p_application_id <> FND_API.G_MISS_NUM) then

257: end if;
258:
259: --** - next, load non-null columns **
260:
261: if (p_application_id <> FND_API.G_MISS_NUM) then
262: l_objects_rec.application_id := p_application_id;
263: end if;
264:
265: if (p_created_by <> FND_API.G_MISS_NUM) then

Line 265: if (p_created_by <> FND_API.G_MISS_NUM) then

261: if (p_application_id <> FND_API.G_MISS_NUM) then
262: l_objects_rec.application_id := p_application_id;
263: end if;
264:
265: if (p_created_by <> FND_API.G_MISS_NUM) then
266: l_created_by := p_created_by;
267: end if;
268:
269: if (p_creation_date <> FND_API.G_MISS_DATE) then

Line 269: if (p_creation_date <> FND_API.G_MISS_DATE) then

265: if (p_created_by <> FND_API.G_MISS_NUM) then
266: l_created_by := p_created_by;
267: end if;
268:
269: if (p_creation_date <> FND_API.G_MISS_DATE) then
270: l_creation_date := p_creation_date;
271: end if;
272:
273: if (p_last_updated_by <> FND_API.G_MISS_NUM) then

Line 273: if (p_last_updated_by <> FND_API.G_MISS_NUM) then

269: if (p_creation_date <> FND_API.G_MISS_DATE) then
270: l_creation_date := p_creation_date;
271: end if;
272:
273: if (p_last_updated_by <> FND_API.G_MISS_NUM) then
274: l_last_updated_by := p_last_updated_by;
275: end if;
276:
277: if (p_last_update_date <> FND_API.G_MISS_DATE) then

Line 277: if (p_last_update_date <> FND_API.G_MISS_DATE) then

273: if (p_last_updated_by <> FND_API.G_MISS_NUM) then
274: l_last_updated_by := p_last_updated_by;
275: end if;
276:
277: if (p_last_update_date <> FND_API.G_MISS_DATE) then
278: l_last_update_date := p_last_update_date;
279: end if;
280:
281: if (p_last_update_login <> FND_API.G_MISS_NUM) then

Line 281: if (p_last_update_login <> FND_API.G_MISS_NUM) then

277: if (p_last_update_date <> FND_API.G_MISS_DATE) then
278: l_last_update_date := p_last_update_date;
279: end if;
280:
281: if (p_last_update_login <> FND_API.G_MISS_NUM) then
282: l_last_update_login := p_last_update_login;
283: end if;
284:
285: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

Line 328: raise FND_API.G_EXC_ERROR;

324: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
325: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_UPDATE_FAILED');
326: FND_MSG_PUB.Add;
327: end if;
328: raise FND_API.G_EXC_ERROR;
329: end if;
330:
331: update AK_OBJECTS_TL set
332: NAME = l_objects_tl_rec.name,

Line 345: raise FND_API.G_EXC_ERROR;

341: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
342: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_UPDATE_FAILED');
343: FND_MSG_PUB.Add;
344: end if;
345: raise FND_API.G_EXC_ERROR;
346: end if;
347:
348: -- /** commit the update **/
349: -- commit;

Line 358: p_return_status := FND_API.G_RET_STS_SUCCESS;

354: FND_MSG_PUB.Add;
355: end if;
356:
357: end if;
358: p_return_status := FND_API.G_RET_STS_SUCCESS;
359:
360: FND_MSG_PUB.Count_And_Get (
361: p_count => p_msg_count,
362: p_data => p_msg_data);

Line 371: p_return_status := FND_API.G_RET_STS_ERROR;

367: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_VALUE_ERROR');
368: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name );
369: FND_MSG_PUB.Add;
370: end if;
371: p_return_status := FND_API.G_RET_STS_ERROR;
372: rollback to start_update_object;
373: FND_MSG_PUB.Count_And_Get (
374: p_count => p_msg_count,
375: p_data => p_msg_data);

Line 376: WHEN FND_API.G_EXC_ERROR THEN

372: rollback to start_update_object;
373: FND_MSG_PUB.Count_And_Get (
374: p_count => p_msg_count,
375: p_data => p_msg_data);
376: WHEN FND_API.G_EXC_ERROR THEN
377: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
378: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_UPDATED');
379: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name );
380: FND_MSG_PUB.Add;

Line 382: p_return_status := FND_API.G_RET_STS_ERROR;

378: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_UPDATED');
379: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name );
380: FND_MSG_PUB.Add;
381: end if;
382: p_return_status := FND_API.G_RET_STS_ERROR;
383: rollback to start_update_object;
384: FND_MSG_PUB.Count_And_Get (
385: p_count => p_msg_count,
386: p_data => p_msg_data);

Line 388: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

384: FND_MSG_PUB.Count_And_Get (
385: p_count => p_msg_count,
386: p_data => p_msg_data);
387: WHEN OTHERS THEN
388: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
389: rollback to start_update_object;
390: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
391: SUBSTR (SQLERRM, 1, 240) );
392: FND_MSG_PUB.Count_And_Get (

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

417: -- Version Initial version number = 1.0
418: -- History Current version number = 1.0
419: --=======================================================
420: procedure UPDATE_ATTRIBUTE (
421: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
422: p_api_version_number IN NUMBER,
423: p_init_msg_tbl IN BOOLEAN := FALSE,
424: p_msg_count OUT NOCOPY NUMBER,
425: p_msg_data OUT NOCOPY VARCHAR2,

Line 430: p_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

426: p_return_status OUT NOCOPY VARCHAR2,
427: p_database_object_name IN VARCHAR2,
428: p_attribute_application_id IN NUMBER,
429: p_attribute_code IN VARCHAR2,
430: p_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
431: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
432: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
433: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
434: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 431: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,

427: p_database_object_name IN VARCHAR2,
428: p_attribute_application_id IN NUMBER,
429: p_attribute_code IN VARCHAR2,
430: p_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
431: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
432: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
433: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
434: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
435: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 432: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,

428: p_attribute_application_id IN NUMBER,
429: p_attribute_code IN VARCHAR2,
430: p_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
431: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
432: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
433: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
434: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
435: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 433: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,

429: p_attribute_code IN VARCHAR2,
430: p_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
431: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
432: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
433: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
434: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
435: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
437: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 434: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,

430: p_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
431: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
432: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
433: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
434: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
435: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
437: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
438: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 435: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,

431: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
432: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
433: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
434: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
435: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
437: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
438: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
439: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 436: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,

432: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
433: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
434: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
435: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
437: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
438: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
439: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
440: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 437: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

433: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
434: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
435: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
437: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
438: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
439: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
440: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
441: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 438: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

434: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
435: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
437: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
438: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
439: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
440: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
441: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
442: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 439: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

435: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
437: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
438: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
439: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
440: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
441: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
442: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,

Line 440: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

436: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
437: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
438: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
439: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
440: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
441: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
442: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
444: p_default_value_date IN DATE := FND_API.G_MISS_DATE,

Line 441: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

437: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
438: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
439: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
440: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
441: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
442: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
444: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
445: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,

Line 442: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

438: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
439: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
440: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
441: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
442: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
444: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
445: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
446: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 443: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,

439: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
440: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
441: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
442: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
444: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
445: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
446: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 444: p_default_value_date IN DATE := FND_API.G_MISS_DATE,

440: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
441: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
442: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
444: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
445: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
446: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,

Line 445: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,

441: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
442: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
444: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
445: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
446: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
449: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 446: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

442: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
443: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
444: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
445: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
446: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
449: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
450: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 447: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

443: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
444: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
445: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
446: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
449: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
450: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
451: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 448: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,

444: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
445: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
446: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
449: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
450: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
451: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 449: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

445: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
446: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
449: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
450: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
451: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 450: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

446: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
449: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
450: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
451: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 451: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

447: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
449: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
450: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
451: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 452: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

448: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
449: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
450: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
451: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 453: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

449: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
450: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
451: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
457: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 454: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

450: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
451: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
457: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
458: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 455: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

451: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
457: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
458: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
459: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 456: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

452: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
457: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
458: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
459: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
460: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 457: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

453: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
457: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
458: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
459: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
460: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 458: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

454: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
457: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
458: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
459: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
460: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 459: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

455: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
457: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
458: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
459: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
460: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 460: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

456: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
457: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
458: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
459: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
460: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 461: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

457: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
458: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
459: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
460: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
465: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 462: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

458: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
459: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
460: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
465: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
466: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 463: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

459: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
460: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
465: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
466: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
467: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 464: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

460: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
465: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
466: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
467: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
468: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 465: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

461: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
465: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
466: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
467: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
468: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
469: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 466: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

462: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
465: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
466: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
467: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
468: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
469: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
470: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 467: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

463: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
465: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
466: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
467: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
468: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
469: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
470: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
471: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 468: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

464: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
465: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
466: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
467: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
468: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
469: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
470: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
471: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
472: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 469: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

465: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
466: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
467: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
468: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
469: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
470: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
471: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
472: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
473: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 470: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,

466: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
467: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
468: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
469: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
470: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
471: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
472: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
473: p_creation_date IN DATE := FND_API.G_MISS_DATE,
474: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 471: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,

467: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
468: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
469: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
470: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
471: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
472: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
473: p_creation_date IN DATE := FND_API.G_MISS_DATE,
474: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
475: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

Line 472: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

468: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
469: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
470: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
471: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
472: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
473: p_creation_date IN DATE := FND_API.G_MISS_DATE,
474: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
475: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
476: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

Line 473: p_creation_date IN DATE := FND_API.G_MISS_DATE,

469: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
470: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
471: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
472: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
473: p_creation_date IN DATE := FND_API.G_MISS_DATE,
474: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
475: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
476: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
477: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

Line 474: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

470: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
471: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
472: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
473: p_creation_date IN DATE := FND_API.G_MISS_DATE,
474: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
475: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
476: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
477: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
478: p_pass IN NUMBER,

Line 475: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

471: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
472: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
473: p_creation_date IN DATE := FND_API.G_MISS_DATE,
474: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
475: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
476: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
477: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
478: p_pass IN NUMBER,
479: p_copy_redo_flag IN OUT NOCOPY BOOLEAN

Line 476: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

472: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
473: p_creation_date IN DATE := FND_API.G_MISS_DATE,
474: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
475: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
476: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
477: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
478: p_pass IN NUMBER,
479: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
480: ) is

Line 477: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

473: p_creation_date IN DATE := FND_API.G_MISS_DATE,
474: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
475: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
476: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
477: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
478: p_pass IN NUMBER,
479: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
480: ) is
481: cursor l_get_row_csr is

Line 511: IF NOT FND_API.Compatible_API_Call (

507: l_last_updated_by number;
508: l_return_status varchar2(1);
509: l_file_version number;
510: begin
511: IF NOT FND_API.Compatible_API_Call (
512: l_api_version_number, p_api_version_number, l_api_name,
513: G_PKG_NAME) then
514: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
515: return;

Line 514: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

510: begin
511: IF NOT FND_API.Compatible_API_Call (
512: l_api_version_number, p_api_version_number, l_api_name,
513: G_PKG_NAME) then
514: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
515: return;
516: END IF;
517:
518: -- Initialize the message table if requested.

Line 539: raise FND_API.G_EXC_ERROR;

535: FND_MSG_PUB.Add;
536: end if;
537: -- dbms_output.put_line(l_api_name || 'Error - Row does not exist');
538: close l_get_row_csr;
539: raise FND_API.G_EXC_ERROR;
540: end if;
541: close l_get_row_csr;
542:
543: --** retrieve ak_object_attributes_tl row if it exists **

Line 553: raise FND_API.G_EXC_ERROR;

549: FND_MSG_PUB.Add;
550: end if;
551: -- dbms_output.put_line(l_api_name || 'Error - TL Row does not exist');
552: close l_get_tl_row_csr;
553: raise FND_API.G_EXC_ERROR;
554: end if;
555: close l_get_tl_row_csr;
556:
557: --** validate table columns passed in **

Line 558: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then

554: end if;
555: close l_get_tl_row_csr;
556:
557: --** validate table columns passed in **
558: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then
559: if not AK_OBJECT_PVT.VALIDATE_ATTRIBUTE (
560: p_validation_level => p_validation_level,
561: p_api_version_number => 1.0,
562: p_return_status => l_return_status,

Line 599: raise FND_API.G_EXC_ERROR;

595: -- Do not raise an error if it's the first pass
596: if (p_pass = 1) then
597: p_copy_redo_flag := TRUE;
598: else
599: raise FND_API.G_EXC_ERROR;
600: end if; -- /* if p_pass */
601: end if;
602: end if;
603:

Line 607: if (p_column_name <> FND_API.G_MISS_CHAR) or

603:
604: --** Load record to be updated to the database **
605: --** - first load nullable columns **
606:
607: if (p_column_name <> FND_API.G_MISS_CHAR) or
608: (p_column_name is null) then
609: l_attributes_rec.column_name := p_column_name;
610: end if;
611: if (p_data_storage_type <> FND_API.G_MISS_CHAR) or

Line 611: if (p_data_storage_type <> FND_API.G_MISS_CHAR) or

607: if (p_column_name <> FND_API.G_MISS_CHAR) or
608: (p_column_name is null) then
609: l_attributes_rec.column_name := p_column_name;
610: end if;
611: if (p_data_storage_type <> FND_API.G_MISS_CHAR) or
612: (p_data_storage_type is null) then
613: l_attributes_rec.data_storage_type := p_data_storage_type;
614: end if;
615: if (p_table_name <> FND_API.G_MISS_CHAR) or

Line 615: if (p_table_name <> FND_API.G_MISS_CHAR) or

611: if (p_data_storage_type <> FND_API.G_MISS_CHAR) or
612: (p_data_storage_type is null) then
613: l_attributes_rec.data_storage_type := p_data_storage_type;
614: end if;
615: if (p_table_name <> FND_API.G_MISS_CHAR) or
616: (p_table_name is null) then
617: l_attributes_rec.table_name := p_table_name;
618: end if;
619: if (p_base_table_column_name <> FND_API.G_MISS_CHAR) or

Line 619: if (p_base_table_column_name <> FND_API.G_MISS_CHAR) or

615: if (p_table_name <> FND_API.G_MISS_CHAR) or
616: (p_table_name is null) then
617: l_attributes_rec.table_name := p_table_name;
618: end if;
619: if (p_base_table_column_name <> FND_API.G_MISS_CHAR) or
620: (p_base_table_column_name is null) then
621: l_attributes_rec.base_table_column_name := p_base_table_column_name;
622: end if;
623: if (p_default_value_varchar2 <> FND_API.G_MISS_CHAR) or

Line 623: if (p_default_value_varchar2 <> FND_API.G_MISS_CHAR) or

619: if (p_base_table_column_name <> FND_API.G_MISS_CHAR) or
620: (p_base_table_column_name is null) then
621: l_attributes_rec.base_table_column_name := p_base_table_column_name;
622: end if;
623: if (p_default_value_varchar2 <> FND_API.G_MISS_CHAR) or
624: (p_default_value_varchar2 is null) then
625: l_attributes_rec.default_value_varchar2 := p_default_value_varchar2;
626: end if;
627: if (p_default_value_number <> FND_API.G_MISS_NUM) or

Line 627: if (p_default_value_number <> FND_API.G_MISS_NUM) or

623: if (p_default_value_varchar2 <> FND_API.G_MISS_CHAR) or
624: (p_default_value_varchar2 is null) then
625: l_attributes_rec.default_value_varchar2 := p_default_value_varchar2;
626: end if;
627: if (p_default_value_number <> FND_API.G_MISS_NUM) or
628: (p_default_value_number is null) then
629: l_attributes_rec.default_value_number := p_default_value_number;
630: end if;
631: if (p_default_value_date <> FND_API.G_MISS_DATE) or

Line 631: if (p_default_value_date <> FND_API.G_MISS_DATE) or

627: if (p_default_value_number <> FND_API.G_MISS_NUM) or
628: (p_default_value_number is null) then
629: l_attributes_rec.default_value_number := p_default_value_number;
630: end if;
631: if (p_default_value_date <> FND_API.G_MISS_DATE) or
632: (p_default_value_date is null) then
633: l_attributes_rec.default_value_date := p_default_value_date;
634: end if;
635: if (p_lov_region_application_id <> FND_API.G_MISS_NUM) or

Line 635: if (p_lov_region_application_id <> FND_API.G_MISS_NUM) or

631: if (p_default_value_date <> FND_API.G_MISS_DATE) or
632: (p_default_value_date is null) then
633: l_attributes_rec.default_value_date := p_default_value_date;
634: end if;
635: if (p_lov_region_application_id <> FND_API.G_MISS_NUM) or
636: (p_lov_region_application_id is null) then
637: l_attributes_rec.lov_region_application_id := p_lov_region_application_id;
638: end if;
639: if (p_lov_region_code <> FND_API.G_MISS_CHAR) or

Line 639: if (p_lov_region_code <> FND_API.G_MISS_CHAR) or

635: if (p_lov_region_application_id <> FND_API.G_MISS_NUM) or
636: (p_lov_region_application_id is null) then
637: l_attributes_rec.lov_region_application_id := p_lov_region_application_id;
638: end if;
639: if (p_lov_region_code <> FND_API.G_MISS_CHAR) or
640: (p_lov_region_code is null) then
641: l_attributes_rec.lov_region_code := p_lov_region_code;
642: end if;
643: if (p_lov_foreign_key_name <> FND_API.G_MISS_CHAR) or

Line 643: if (p_lov_foreign_key_name <> FND_API.G_MISS_CHAR) or

639: if (p_lov_region_code <> FND_API.G_MISS_CHAR) or
640: (p_lov_region_code is null) then
641: l_attributes_rec.lov_region_code := p_lov_region_code;
642: end if;
643: if (p_lov_foreign_key_name <> FND_API.G_MISS_CHAR) or
644: (p_lov_foreign_key_name is null) then
645: l_attributes_rec.lov_foreign_key_name := p_lov_foreign_key_name;
646: end if;
647: if (p_lov_attribute_application_id <> FND_API.G_MISS_NUM) or

Line 647: if (p_lov_attribute_application_id <> FND_API.G_MISS_NUM) or

643: if (p_lov_foreign_key_name <> FND_API.G_MISS_CHAR) or
644: (p_lov_foreign_key_name is null) then
645: l_attributes_rec.lov_foreign_key_name := p_lov_foreign_key_name;
646: end if;
647: if (p_lov_attribute_application_id <> FND_API.G_MISS_NUM) or
648: (p_lov_attribute_application_id is null) then
649: l_attributes_rec.lov_attribute_application_id :=
650: p_lov_attribute_application_id;
651: end if;

Line 652: if (p_lov_attribute_code <> FND_API.G_MISS_CHAR) or

648: (p_lov_attribute_application_id is null) then
649: l_attributes_rec.lov_attribute_application_id :=
650: p_lov_attribute_application_id;
651: end if;
652: if (p_lov_attribute_code <> FND_API.G_MISS_CHAR) or
653: (p_lov_attribute_code is null) then
654: l_attributes_rec.lov_attribute_code := p_lov_attribute_code;
655: end if;
656: if (p_defaulting_api_pkg <> FND_API.G_MISS_CHAR) or

Line 656: if (p_defaulting_api_pkg <> FND_API.G_MISS_CHAR) or

652: if (p_lov_attribute_code <> FND_API.G_MISS_CHAR) or
653: (p_lov_attribute_code is null) then
654: l_attributes_rec.lov_attribute_code := p_lov_attribute_code;
655: end if;
656: if (p_defaulting_api_pkg <> FND_API.G_MISS_CHAR) or
657: (p_defaulting_api_pkg is null) then
658: l_attributes_rec.defaulting_api_pkg := p_defaulting_api_pkg;
659: end if;
660: if (p_defaulting_api_proc <> FND_API.G_MISS_CHAR) or

Line 660: if (p_defaulting_api_proc <> FND_API.G_MISS_CHAR) or

656: if (p_defaulting_api_pkg <> FND_API.G_MISS_CHAR) or
657: (p_defaulting_api_pkg is null) then
658: l_attributes_rec.defaulting_api_pkg := p_defaulting_api_pkg;
659: end if;
660: if (p_defaulting_api_proc <> FND_API.G_MISS_CHAR) or
661: (p_defaulting_api_proc is null) then
662: l_attributes_rec.defaulting_api_proc := p_defaulting_api_proc;
663: end if;
664: if (p_validation_api_pkg <> FND_API.G_MISS_CHAR) or

Line 664: if (p_validation_api_pkg <> FND_API.G_MISS_CHAR) or

660: if (p_defaulting_api_proc <> FND_API.G_MISS_CHAR) or
661: (p_defaulting_api_proc is null) then
662: l_attributes_rec.defaulting_api_proc := p_defaulting_api_proc;
663: end if;
664: if (p_validation_api_pkg <> FND_API.G_MISS_CHAR) or
665: (p_validation_api_pkg is null) then
666: l_attributes_rec.validation_api_pkg := p_validation_api_pkg;
667: end if;
668: if (p_validation_api_proc <> FND_API.G_MISS_CHAR) or

Line 668: if (p_validation_api_proc <> FND_API.G_MISS_CHAR) or

664: if (p_validation_api_pkg <> FND_API.G_MISS_CHAR) or
665: (p_validation_api_pkg is null) then
666: l_attributes_rec.validation_api_pkg := p_validation_api_pkg;
667: end if;
668: if (p_validation_api_proc <> FND_API.G_MISS_CHAR) or
669: (p_validation_api_proc is null) then
670: l_attributes_rec.validation_api_proc := p_validation_api_proc;
671: end if;
672: if (p_attribute_category <> FND_API.G_MISS_CHAR) or

Line 672: if (p_attribute_category <> FND_API.G_MISS_CHAR) or

668: if (p_validation_api_proc <> FND_API.G_MISS_CHAR) or
669: (p_validation_api_proc is null) then
670: l_attributes_rec.validation_api_proc := p_validation_api_proc;
671: end if;
672: if (p_attribute_category <> FND_API.G_MISS_CHAR) or
673: (p_attribute_category is null) then
674: l_attributes_rec.attribute_category := p_attribute_category;
675: end if;
676: if (p_attribute1 <> FND_API.G_MISS_CHAR) or

Line 676: if (p_attribute1 <> FND_API.G_MISS_CHAR) or

672: if (p_attribute_category <> FND_API.G_MISS_CHAR) or
673: (p_attribute_category is null) then
674: l_attributes_rec.attribute_category := p_attribute_category;
675: end if;
676: if (p_attribute1 <> FND_API.G_MISS_CHAR) or
677: (p_attribute1 is null) then
678: l_attributes_rec.attribute1 := p_attribute1;
679: end if;
680: if (p_attribute2 <> FND_API.G_MISS_CHAR) or

Line 680: if (p_attribute2 <> FND_API.G_MISS_CHAR) or

676: if (p_attribute1 <> FND_API.G_MISS_CHAR) or
677: (p_attribute1 is null) then
678: l_attributes_rec.attribute1 := p_attribute1;
679: end if;
680: if (p_attribute2 <> FND_API.G_MISS_CHAR) or
681: (p_attribute2 is null) then
682: l_attributes_rec.attribute2 := p_attribute2;
683: end if;
684: if (p_attribute3 <> FND_API.G_MISS_CHAR) or

Line 684: if (p_attribute3 <> FND_API.G_MISS_CHAR) or

680: if (p_attribute2 <> FND_API.G_MISS_CHAR) or
681: (p_attribute2 is null) then
682: l_attributes_rec.attribute2 := p_attribute2;
683: end if;
684: if (p_attribute3 <> FND_API.G_MISS_CHAR) or
685: (p_attribute3 is null) then
686: l_attributes_rec.attribute3 := p_attribute3;
687: end if;
688: if (p_attribute4 <> FND_API.G_MISS_CHAR) or

Line 688: if (p_attribute4 <> FND_API.G_MISS_CHAR) or

684: if (p_attribute3 <> FND_API.G_MISS_CHAR) or
685: (p_attribute3 is null) then
686: l_attributes_rec.attribute3 := p_attribute3;
687: end if;
688: if (p_attribute4 <> FND_API.G_MISS_CHAR) or
689: (p_attribute4 is null) then
690: l_attributes_rec.attribute4 := p_attribute4;
691: end if;
692: if (p_attribute5 <> FND_API.G_MISS_CHAR) or

Line 692: if (p_attribute5 <> FND_API.G_MISS_CHAR) or

688: if (p_attribute4 <> FND_API.G_MISS_CHAR) or
689: (p_attribute4 is null) then
690: l_attributes_rec.attribute4 := p_attribute4;
691: end if;
692: if (p_attribute5 <> FND_API.G_MISS_CHAR) or
693: (p_attribute5 is null) then
694: l_attributes_rec.attribute5 := p_attribute5;
695: end if;
696: if (p_attribute6 <> FND_API.G_MISS_CHAR) or

Line 696: if (p_attribute6 <> FND_API.G_MISS_CHAR) or

692: if (p_attribute5 <> FND_API.G_MISS_CHAR) or
693: (p_attribute5 is null) then
694: l_attributes_rec.attribute5 := p_attribute5;
695: end if;
696: if (p_attribute6 <> FND_API.G_MISS_CHAR) or
697: (p_attribute6 is null) then
698: l_attributes_rec.attribute6 := p_attribute6;
699: end if;
700: if (p_attribute7 <> FND_API.G_MISS_CHAR) or

Line 700: if (p_attribute7 <> FND_API.G_MISS_CHAR) or

696: if (p_attribute6 <> FND_API.G_MISS_CHAR) or
697: (p_attribute6 is null) then
698: l_attributes_rec.attribute6 := p_attribute6;
699: end if;
700: if (p_attribute7 <> FND_API.G_MISS_CHAR) or
701: (p_attribute7 is null) then
702: l_attributes_rec.attribute7 := p_attribute7;
703: end if;
704: if (p_attribute8 <> FND_API.G_MISS_CHAR) or

Line 704: if (p_attribute8 <> FND_API.G_MISS_CHAR) or

700: if (p_attribute7 <> FND_API.G_MISS_CHAR) or
701: (p_attribute7 is null) then
702: l_attributes_rec.attribute7 := p_attribute7;
703: end if;
704: if (p_attribute8 <> FND_API.G_MISS_CHAR) or
705: (p_attribute8 is null) then
706: l_attributes_rec.attribute8 := p_attribute8;
707: end if;
708: if (p_attribute9 <> FND_API.G_MISS_CHAR) or

Line 708: if (p_attribute9 <> FND_API.G_MISS_CHAR) or

704: if (p_attribute8 <> FND_API.G_MISS_CHAR) or
705: (p_attribute8 is null) then
706: l_attributes_rec.attribute8 := p_attribute8;
707: end if;
708: if (p_attribute9 <> FND_API.G_MISS_CHAR) or
709: (p_attribute9 is null) then
710: l_attributes_rec.attribute9 := p_attribute9;
711: end if;
712: if (p_attribute10 <> FND_API.G_MISS_CHAR) or

Line 712: if (p_attribute10 <> FND_API.G_MISS_CHAR) or

708: if (p_attribute9 <> FND_API.G_MISS_CHAR) or
709: (p_attribute9 is null) then
710: l_attributes_rec.attribute9 := p_attribute9;
711: end if;
712: if (p_attribute10 <> FND_API.G_MISS_CHAR) or
713: (p_attribute10 is null) then
714: l_attributes_rec.attribute10 := p_attribute10;
715: end if;
716: if (p_attribute11 <> FND_API.G_MISS_CHAR) or

Line 716: if (p_attribute11 <> FND_API.G_MISS_CHAR) or

712: if (p_attribute10 <> FND_API.G_MISS_CHAR) or
713: (p_attribute10 is null) then
714: l_attributes_rec.attribute10 := p_attribute10;
715: end if;
716: if (p_attribute11 <> FND_API.G_MISS_CHAR) or
717: (p_attribute11 is null) then
718: l_attributes_rec.attribute11 := p_attribute11;
719: end if;
720: if (p_attribute12 <> FND_API.G_MISS_CHAR) or

Line 720: if (p_attribute12 <> FND_API.G_MISS_CHAR) or

716: if (p_attribute11 <> FND_API.G_MISS_CHAR) or
717: (p_attribute11 is null) then
718: l_attributes_rec.attribute11 := p_attribute11;
719: end if;
720: if (p_attribute12 <> FND_API.G_MISS_CHAR) or
721: (p_attribute12 is null) then
722: l_attributes_rec.attribute12 := p_attribute12;
723: end if;
724: if (p_attribute13 <> FND_API.G_MISS_CHAR) or

Line 724: if (p_attribute13 <> FND_API.G_MISS_CHAR) or

720: if (p_attribute12 <> FND_API.G_MISS_CHAR) or
721: (p_attribute12 is null) then
722: l_attributes_rec.attribute12 := p_attribute12;
723: end if;
724: if (p_attribute13 <> FND_API.G_MISS_CHAR) or
725: (p_attribute13 is null) then
726: l_attributes_rec.attribute13 := p_attribute13;
727: end if;
728: if (p_attribute14 <> FND_API.G_MISS_CHAR) or

Line 728: if (p_attribute14 <> FND_API.G_MISS_CHAR) or

724: if (p_attribute13 <> FND_API.G_MISS_CHAR) or
725: (p_attribute13 is null) then
726: l_attributes_rec.attribute13 := p_attribute13;
727: end if;
728: if (p_attribute14 <> FND_API.G_MISS_CHAR) or
729: (p_attribute14 is null) then
730: l_attributes_rec.attribute14 := p_attribute14;
731: end if;
732: if (p_attribute15 <> FND_API.G_MISS_CHAR) or

Line 732: if (p_attribute15 <> FND_API.G_MISS_CHAR) or

728: if (p_attribute14 <> FND_API.G_MISS_CHAR) or
729: (p_attribute14 is null) then
730: l_attributes_rec.attribute14 := p_attribute14;
731: end if;
732: if (p_attribute15 <> FND_API.G_MISS_CHAR) or
733: (p_attribute15 is null) then
734: l_attributes_rec.attribute15 := p_attribute15;
735: end if;
736: if (p_attribute_label_long <> FND_API.G_MISS_CHAR) or

Line 736: if (p_attribute_label_long <> FND_API.G_MISS_CHAR) or

732: if (p_attribute15 <> FND_API.G_MISS_CHAR) or
733: (p_attribute15 is null) then
734: l_attributes_rec.attribute15 := p_attribute15;
735: end if;
736: if (p_attribute_label_long <> FND_API.G_MISS_CHAR) or
737: (p_attribute_label_long is null) then
738: l_attributes_tl_rec.attribute_label_long := p_attribute_label_long;
739: end if;
740: if (p_attribute_label_short <> FND_API.G_MISS_CHAR) or

Line 740: if (p_attribute_label_short <> FND_API.G_MISS_CHAR) or

736: if (p_attribute_label_long <> FND_API.G_MISS_CHAR) or
737: (p_attribute_label_long is null) then
738: l_attributes_tl_rec.attribute_label_long := p_attribute_label_long;
739: end if;
740: if (p_attribute_label_short <> FND_API.G_MISS_CHAR) or
741: (p_attribute_label_short is null) then
742: l_attributes_tl_rec.attribute_label_short := p_attribute_label_short;
743: end if;
744:

Line 747: if (p_attribute_label_length <> FND_API.G_MISS_NUM) then

743: end if;
744:
745: --** - next, load non-null columns **
746:
747: if (p_attribute_label_length <> FND_API.G_MISS_NUM) then
748: l_attributes_rec.attribute_label_length := p_attribute_label_length;
749: end if;
750: if (p_display_value_length <> FND_API.G_MISS_NUM) then
751: l_attributes_rec.display_value_length := p_display_value_length;

Line 750: if (p_display_value_length <> FND_API.G_MISS_NUM) then

746:
747: if (p_attribute_label_length <> FND_API.G_MISS_NUM) then
748: l_attributes_rec.attribute_label_length := p_attribute_label_length;
749: end if;
750: if (p_display_value_length <> FND_API.G_MISS_NUM) then
751: l_attributes_rec.display_value_length := p_display_value_length;
752: end if;
753: if (p_bold <> FND_API.G_MISS_CHAR) then
754: l_attributes_rec.bold := p_bold;

Line 753: if (p_bold <> FND_API.G_MISS_CHAR) then

749: end if;
750: if (p_display_value_length <> FND_API.G_MISS_NUM) then
751: l_attributes_rec.display_value_length := p_display_value_length;
752: end if;
753: if (p_bold <> FND_API.G_MISS_CHAR) then
754: l_attributes_rec.bold := p_bold;
755: end if;
756: if (p_italic <> FND_API.G_MISS_CHAR) then
757: l_attributes_rec.italic := p_italic;

Line 756: if (p_italic <> FND_API.G_MISS_CHAR) then

752: end if;
753: if (p_bold <> FND_API.G_MISS_CHAR) then
754: l_attributes_rec.bold := p_bold;
755: end if;
756: if (p_italic <> FND_API.G_MISS_CHAR) then
757: l_attributes_rec.italic := p_italic;
758: end if;
759: if (p_vertical_alignment <> FND_API.G_MISS_CHAR) then
760: l_attributes_rec.vertical_alignment := p_vertical_alignment;

Line 759: if (p_vertical_alignment <> FND_API.G_MISS_CHAR) then

755: end if;
756: if (p_italic <> FND_API.G_MISS_CHAR) then
757: l_attributes_rec.italic := p_italic;
758: end if;
759: if (p_vertical_alignment <> FND_API.G_MISS_CHAR) then
760: l_attributes_rec.vertical_alignment := p_vertical_alignment;
761: end if;
762: if (p_horizontal_alignment <> FND_API.G_MISS_CHAR) then
763: l_attributes_rec.horizontal_alignment := p_horizontal_alignment;

Line 762: if (p_horizontal_alignment <> FND_API.G_MISS_CHAR) then

758: end if;
759: if (p_vertical_alignment <> FND_API.G_MISS_CHAR) then
760: l_attributes_rec.vertical_alignment := p_vertical_alignment;
761: end if;
762: if (p_horizontal_alignment <> FND_API.G_MISS_CHAR) then
763: l_attributes_rec.horizontal_alignment := p_horizontal_alignment;
764: end if;
765: if (p_data_source_type <> FND_API.G_MISS_CHAR) then
766: l_attributes_rec.data_source_type := p_data_source_type;

Line 765: if (p_data_source_type <> FND_API.G_MISS_CHAR) then

761: end if;
762: if (p_horizontal_alignment <> FND_API.G_MISS_CHAR) then
763: l_attributes_rec.horizontal_alignment := p_horizontal_alignment;
764: end if;
765: if (p_data_source_type <> FND_API.G_MISS_CHAR) then
766: l_attributes_rec.data_source_type := p_data_source_type;
767: end if;
768: if (p_required_flag <> FND_API.G_MISS_CHAR) then
769: l_attributes_rec.required_flag := p_required_flag;

Line 768: if (p_required_flag <> FND_API.G_MISS_CHAR) then

764: end if;
765: if (p_data_source_type <> FND_API.G_MISS_CHAR) then
766: l_attributes_rec.data_source_type := p_data_source_type;
767: end if;
768: if (p_required_flag <> FND_API.G_MISS_CHAR) then
769: l_attributes_rec.required_flag := p_required_flag;
770: end if;
771:
772: if (p_created_by <> FND_API.G_MISS_NUM) then

Line 772: if (p_created_by <> FND_API.G_MISS_NUM) then

768: if (p_required_flag <> FND_API.G_MISS_CHAR) then
769: l_attributes_rec.required_flag := p_required_flag;
770: end if;
771:
772: if (p_created_by <> FND_API.G_MISS_NUM) then
773: l_created_by := p_created_by;
774: end if;
775: if (p_creation_date <> FND_API.G_MISS_DATE) then
776: l_creation_date := p_creation_date;

Line 775: if (p_creation_date <> FND_API.G_MISS_DATE) then

771:
772: if (p_created_by <> FND_API.G_MISS_NUM) then
773: l_created_by := p_created_by;
774: end if;
775: if (p_creation_date <> FND_API.G_MISS_DATE) then
776: l_creation_date := p_creation_date;
777: end if;
778: if (p_last_updated_by <> FND_API.G_MISS_NUM) then
779: l_last_updated_by := p_last_updated_by;

Line 778: if (p_last_updated_by <> FND_API.G_MISS_NUM) then

774: end if;
775: if (p_creation_date <> FND_API.G_MISS_DATE) then
776: l_creation_date := p_creation_date;
777: end if;
778: if (p_last_updated_by <> FND_API.G_MISS_NUM) then
779: l_last_updated_by := p_last_updated_by;
780: end if;
781: if (p_last_update_date <> FND_API.G_MISS_DATE) then
782: l_last_update_date := p_last_update_date;

Line 781: if (p_last_update_date <> FND_API.G_MISS_DATE) then

777: end if;
778: if (p_last_updated_by <> FND_API.G_MISS_NUM) then
779: l_last_updated_by := p_last_updated_by;
780: end if;
781: if (p_last_update_date <> FND_API.G_MISS_DATE) then
782: l_last_update_date := p_last_update_date;
783: end if;
784: if (p_last_update_login <> FND_API.G_MISS_NUM) then
785: l_last_update_login := p_last_update_login;

Line 784: if (p_last_update_login <> FND_API.G_MISS_NUM) then

780: end if;
781: if (p_last_update_date <> FND_API.G_MISS_DATE) then
782: l_last_update_date := p_last_update_date;
783: end if;
784: if (p_last_update_login <> FND_API.G_MISS_NUM) then
785: l_last_update_login := p_last_update_login;
786: end if;
787:
788: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

Line 853: raise FND_API.G_EXC_ERROR;

849: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_UPDATE_FAILED');
850: FND_MSG_PUB.Add;
851: end if;
852: -- dbms_output.put_line('Row does not exist during update');
853: raise FND_API.G_EXC_ERROR;
854: end if;
855:
856: update AK_OBJECT_ATTRIBUTES_TL set
857: ATTRIBUTE_LABEL_LONG = l_attributes_tl_rec.attribute_label_long,

Line 873: raise FND_API.G_EXC_ERROR;

869: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_UPDATE_FAILED');
870: FND_MSG_PUB.Add;
871: end if;
872: -- dbms_output.put_line('TL Row does not exist during update');
873: raise FND_API.G_EXC_ERROR;
874: end if;
875:
876: -- /** commit the update **/
877: -- commit;

Line 888: p_return_status := FND_API.G_RET_STS_SUCCESS;

884: FND_MSG_PUB.Add;
885: end if;
886:
887: end if;
888: p_return_status := FND_API.G_RET_STS_SUCCESS;
889:
890: FND_MSG_PUB.Count_And_Get (
891: p_count => p_msg_count,
892: p_data => p_msg_data);

Line 904: p_return_status := FND_API.G_RET_STS_ERROR;

900: ' ' || p_attribute_code );
901: FND_MSG_PUB.Add;
902: end if;
903: rollback to start_update_attribute;
904: p_return_status := FND_API.G_RET_STS_ERROR;
905: FND_MSG_PUB.Count_And_Get (
906: p_count => p_msg_count,
907: p_data => p_msg_data);
908: WHEN FND_API.G_EXC_ERROR THEN

Line 908: WHEN FND_API.G_EXC_ERROR THEN

904: p_return_status := FND_API.G_RET_STS_ERROR;
905: FND_MSG_PUB.Count_And_Get (
906: p_count => p_msg_count,
907: p_data => p_msg_data);
908: WHEN FND_API.G_EXC_ERROR THEN
909: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
910: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_NOT_UPDATED');
911: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
912: ' ' || to_char(p_attribute_application_id) ||

Line 919: p_return_status := FND_API.G_RET_STS_ERROR;

915: end if;
916: --dbms_output.put_line('OA Key: '||p_database_object_name ||
917: -- ' ' || to_char(p_attribute_application_id) ||
918: -- ' ' || p_attribute_code );
919: p_return_status := FND_API.G_RET_STS_ERROR;
920: rollback to start_update_attribute;
921: FND_MSG_PUB.Count_And_Get (
922: p_count => p_msg_count,
923: p_data => p_msg_data);

Line 928: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

924: WHEN OTHERS THEN
925: --dbms_output.put_line('OA Key: '||p_database_object_name ||
926: -- ' ' || to_char(p_attribute_application_id) ||
927: --- ' ' || p_attribute_code );
928: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
929: rollback to start_update_attribute;
930: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
931: SUBSTR (SQLERRM, 1, 240) );
932: FND_MSG_PUB.Count_And_Get (

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

958: -- Version Initial version number = 1.0
959: -- History Current version number = 1.0
960: --=======================================================
961: procedure UPDATE_ATTRIBUTE_NAVIGATION (
962: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
963: p_api_version_number IN NUMBER,
964: p_init_msg_tbl IN BOOLEAN := FALSE,
965: p_msg_count OUT NOCOPY NUMBER,
966: p_msg_data OUT NOCOPY VARCHAR2,

Line 974: p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,

970: p_attribute_code IN VARCHAR2,
971: p_value_varchar2 IN VARCHAR2,
972: p_value_date IN DATE,
973: p_value_number IN NUMBER,
974: p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
975: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
976: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
977: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
978: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 975: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

971: p_value_varchar2 IN VARCHAR2,
972: p_value_date IN DATE,
973: p_value_number IN NUMBER,
974: p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
975: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
976: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
977: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
978: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
979: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 976: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

972: p_value_date IN DATE,
973: p_value_number IN NUMBER,
974: p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
975: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
976: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
977: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
978: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
979: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
980: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 977: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

973: p_value_number IN NUMBER,
974: p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
975: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
976: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
977: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
978: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
979: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
980: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
981: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 978: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

974: p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
975: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
976: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
977: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
978: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
979: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
980: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
981: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
982: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 979: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

975: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
976: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
977: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
978: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
979: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
980: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
981: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
982: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
983: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 980: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

976: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
977: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
978: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
979: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
980: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
981: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
982: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
983: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
984: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 981: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

977: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
978: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
979: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
980: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
981: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
982: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
983: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
984: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
985: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 982: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

978: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
979: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
980: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
981: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
982: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
983: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
984: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
985: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
986: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 983: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

979: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
980: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
981: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
982: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
983: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
984: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
985: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
986: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
987: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 984: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

980: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
981: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
982: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
983: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
984: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
985: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
986: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
987: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
988: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 985: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

981: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
982: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
983: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
984: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
985: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
986: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
987: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
988: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
989: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 986: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

982: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
983: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
984: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
985: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
986: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
987: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
988: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
989: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
990: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 987: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

983: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
984: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
985: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
986: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
987: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
988: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
989: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
990: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
991: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 988: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

984: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
985: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
986: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
987: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
988: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
989: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
990: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
991: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
992: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 989: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

985: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
986: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
987: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
988: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
989: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
990: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
991: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
992: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
993: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 990: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

986: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
987: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
988: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
989: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
990: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
991: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
992: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
993: p_creation_date IN DATE := FND_API.G_MISS_DATE,
994: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 991: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

987: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
988: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
989: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
990: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
991: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
992: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
993: p_creation_date IN DATE := FND_API.G_MISS_DATE,
994: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
995: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

Line 992: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

988: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
989: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
990: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
991: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
992: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
993: p_creation_date IN DATE := FND_API.G_MISS_DATE,
994: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
995: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
996: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

Line 993: p_creation_date IN DATE := FND_API.G_MISS_DATE,

989: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
990: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
991: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
992: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
993: p_creation_date IN DATE := FND_API.G_MISS_DATE,
994: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
995: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
996: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
997: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

Line 994: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

990: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
991: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
992: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
993: p_creation_date IN DATE := FND_API.G_MISS_DATE,
994: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
995: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
996: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
997: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
998: p_pass IN NUMBER,

Line 995: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

991: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
992: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
993: p_creation_date IN DATE := FND_API.G_MISS_DATE,
994: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
995: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
996: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
997: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
998: p_pass IN NUMBER,
999: p_copy_redo_flag IN OUT NOCOPY BOOLEAN

Line 996: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

992: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
993: p_creation_date IN DATE := FND_API.G_MISS_DATE,
994: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
995: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
996: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
997: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
998: p_pass IN NUMBER,
999: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
1000: ) is

Line 997: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

993: p_creation_date IN DATE := FND_API.G_MISS_DATE,
994: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
995: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
996: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
997: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
998: p_pass IN NUMBER,
999: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
1000: ) is
1001: cursor l_get_row_1_csr is

Line 1044: IF NOT FND_API.Compatible_API_Call (

1040: l_last_updated_by number;
1041: l_return_status varchar2(1);
1042: l_file_version number;
1043: begin
1044: IF NOT FND_API.Compatible_API_Call (
1045: l_api_version_number, p_api_version_number, l_api_name,
1046: G_PKG_NAME) then
1047: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1048: return;

Line 1047: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1043: begin
1044: IF NOT FND_API.Compatible_API_Call (
1045: l_api_version_number, p_api_version_number, l_api_name,
1046: G_PKG_NAME) then
1047: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1048: return;
1049: END IF;
1050:
1051: -- Initialize the message table if requested.

Line 1076: raise FND_API.G_EXC_ERROR;

1072: FND_MESSAGE.SET_NAME('AK','AK_ONE_VALUE_ONLY');
1073: FND_MSG_PUB.Add;
1074: end if;
1075: -- dbms_output.put_line('One and only one value field must be non-null');
1076: raise FND_API.G_EXC_ERROR;
1077: end if;
1078:
1079: --** retrieve ak_object_attribute_navigation row if it exists **
1080: if (p_value_varchar2 is not null) then

Line 1090: raise FND_API.G_EXC_ERROR;

1086: FND_MESSAGE.SET_NAME('AK','AK_NAV_DOES_NOT_EXIST');
1087: FND_MSG_PUB.Add;
1088: end if;
1089: -- dbms_output.put_line(l_api_name || 'Error - Row does not exist');
1090: raise FND_API.G_EXC_ERROR;
1091: end if;
1092: close l_get_row_1_csr;
1093: elsif (p_value_date is not null) then
1094: open l_get_row_2_csr;

Line 1103: raise FND_API.G_EXC_ERROR;

1099: FND_MESSAGE.SET_NAME('AK','AK_NAV_DOES_NOT_EXIST');
1100: FND_MSG_PUB.Add;
1101: end if;
1102: -- dbms_output.put_line(l_api_name || 'Error - Row does not exist');
1103: raise FND_API.G_EXC_ERROR;
1104: end if;
1105: close l_get_row_2_csr;
1106: elsif (p_value_number is not null) then
1107: open l_get_row_3_csr;

Line 1116: raise FND_API.G_EXC_ERROR;

1112: FND_MESSAGE.SET_NAME('AK','AK_NAV_DOES_NOT_EXIST');
1113: FND_MSG_PUB.Add;
1114: end if;
1115: -- dbms_output.put_line(l_api_name || 'Error - Row does not exist');
1116: raise FND_API.G_EXC_ERROR;
1117: end if;
1118: close l_get_row_3_csr;
1119: end if;
1120:

Line 1122: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then

1118: close l_get_row_3_csr;
1119: end if;
1120:
1121: --** validate table columns passed in **
1122: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then
1123: if not AK_OBJECT_PVT.VALIDATE_ATTRIBUTE_NAVIGATION (
1124: p_validation_level => p_validation_level,
1125: p_api_version_number => 1.0,
1126: p_return_status => l_return_status,

Line 1143: raise FND_API.G_EXC_ERROR;

1139: -- Do not raise an error if it's the first pass
1140: if (p_pass = 1) then
1141: p_copy_redo_flag := TRUE;
1142: else
1143: raise FND_API.G_EXC_ERROR;
1144: end if; -- /* if p_pass */
1145: end if;
1146: end if;
1147:

Line 1151: if (p_to_region_appl_id <> FND_API.G_MISS_NUM) then

1147:
1148: --** Load record to be updated to the database **
1149: --** - load non-null columns **
1150:
1151: if (p_to_region_appl_id <> FND_API.G_MISS_NUM) then
1152: l_navigation_rec.to_region_appl_id := p_to_region_appl_id;
1153: end if;
1154: if (p_to_region_code <> FND_API.G_MISS_CHAR) then
1155: l_navigation_rec.to_region_code := p_to_region_code;

Line 1154: if (p_to_region_code <> FND_API.G_MISS_CHAR) then

1150:
1151: if (p_to_region_appl_id <> FND_API.G_MISS_NUM) then
1152: l_navigation_rec.to_region_appl_id := p_to_region_appl_id;
1153: end if;
1154: if (p_to_region_code <> FND_API.G_MISS_CHAR) then
1155: l_navigation_rec.to_region_code := p_to_region_code;
1156: end if;
1157:
1158: if (p_attribute_category <> FND_API.G_MISS_CHAR) or

Line 1158: if (p_attribute_category <> FND_API.G_MISS_CHAR) or

1154: if (p_to_region_code <> FND_API.G_MISS_CHAR) then
1155: l_navigation_rec.to_region_code := p_to_region_code;
1156: end if;
1157:
1158: if (p_attribute_category <> FND_API.G_MISS_CHAR) or
1159: (p_attribute_category is null) then
1160: l_navigation_rec.attribute_category := p_attribute_category;
1161: end if;
1162: if (p_attribute1 <> FND_API.G_MISS_CHAR) or

Line 1162: if (p_attribute1 <> FND_API.G_MISS_CHAR) or

1158: if (p_attribute_category <> FND_API.G_MISS_CHAR) or
1159: (p_attribute_category is null) then
1160: l_navigation_rec.attribute_category := p_attribute_category;
1161: end if;
1162: if (p_attribute1 <> FND_API.G_MISS_CHAR) or
1163: (p_attribute1 is null) then
1164: l_navigation_rec.attribute1 := p_attribute1;
1165: end if;
1166: if (p_attribute2 <> FND_API.G_MISS_CHAR) or

Line 1166: if (p_attribute2 <> FND_API.G_MISS_CHAR) or

1162: if (p_attribute1 <> FND_API.G_MISS_CHAR) or
1163: (p_attribute1 is null) then
1164: l_navigation_rec.attribute1 := p_attribute1;
1165: end if;
1166: if (p_attribute2 <> FND_API.G_MISS_CHAR) or
1167: (p_attribute2 is null) then
1168: l_navigation_rec.attribute2 := p_attribute2;
1169: end if;
1170: if (p_attribute3 <> FND_API.G_MISS_CHAR) or

Line 1170: if (p_attribute3 <> FND_API.G_MISS_CHAR) or

1166: if (p_attribute2 <> FND_API.G_MISS_CHAR) or
1167: (p_attribute2 is null) then
1168: l_navigation_rec.attribute2 := p_attribute2;
1169: end if;
1170: if (p_attribute3 <> FND_API.G_MISS_CHAR) or
1171: (p_attribute3 is null) then
1172: l_navigation_rec.attribute3 := p_attribute3;
1173: end if;
1174: if (p_attribute4 <> FND_API.G_MISS_CHAR) or

Line 1174: if (p_attribute4 <> FND_API.G_MISS_CHAR) or

1170: if (p_attribute3 <> FND_API.G_MISS_CHAR) or
1171: (p_attribute3 is null) then
1172: l_navigation_rec.attribute3 := p_attribute3;
1173: end if;
1174: if (p_attribute4 <> FND_API.G_MISS_CHAR) or
1175: (p_attribute4 is null) then
1176: l_navigation_rec.attribute4 := p_attribute4;
1177: end if;
1178: if (p_attribute5 <> FND_API.G_MISS_CHAR) or

Line 1178: if (p_attribute5 <> FND_API.G_MISS_CHAR) or

1174: if (p_attribute4 <> FND_API.G_MISS_CHAR) or
1175: (p_attribute4 is null) then
1176: l_navigation_rec.attribute4 := p_attribute4;
1177: end if;
1178: if (p_attribute5 <> FND_API.G_MISS_CHAR) or
1179: (p_attribute5 is null) then
1180: l_navigation_rec.attribute5 := p_attribute5;
1181: end if;
1182: if (p_attribute6 <> FND_API.G_MISS_CHAR) or

Line 1182: if (p_attribute6 <> FND_API.G_MISS_CHAR) or

1178: if (p_attribute5 <> FND_API.G_MISS_CHAR) or
1179: (p_attribute5 is null) then
1180: l_navigation_rec.attribute5 := p_attribute5;
1181: end if;
1182: if (p_attribute6 <> FND_API.G_MISS_CHAR) or
1183: (p_attribute6 is null) then
1184: l_navigation_rec.attribute6 := p_attribute6;
1185: end if;
1186: if (p_attribute7 <> FND_API.G_MISS_CHAR) or

Line 1186: if (p_attribute7 <> FND_API.G_MISS_CHAR) or

1182: if (p_attribute6 <> FND_API.G_MISS_CHAR) or
1183: (p_attribute6 is null) then
1184: l_navigation_rec.attribute6 := p_attribute6;
1185: end if;
1186: if (p_attribute7 <> FND_API.G_MISS_CHAR) or
1187: (p_attribute7 is null) then
1188: l_navigation_rec.attribute7 := p_attribute7;
1189: end if;
1190: if (p_attribute8 <> FND_API.G_MISS_CHAR) or

Line 1190: if (p_attribute8 <> FND_API.G_MISS_CHAR) or

1186: if (p_attribute7 <> FND_API.G_MISS_CHAR) or
1187: (p_attribute7 is null) then
1188: l_navigation_rec.attribute7 := p_attribute7;
1189: end if;
1190: if (p_attribute8 <> FND_API.G_MISS_CHAR) or
1191: (p_attribute8 is null) then
1192: l_navigation_rec.attribute8 := p_attribute8;
1193: end if;
1194: if (p_attribute9 <> FND_API.G_MISS_CHAR) or

Line 1194: if (p_attribute9 <> FND_API.G_MISS_CHAR) or

1190: if (p_attribute8 <> FND_API.G_MISS_CHAR) or
1191: (p_attribute8 is null) then
1192: l_navigation_rec.attribute8 := p_attribute8;
1193: end if;
1194: if (p_attribute9 <> FND_API.G_MISS_CHAR) or
1195: (p_attribute9 is null) then
1196: l_navigation_rec.attribute9 := p_attribute9;
1197: end if;
1198: if (p_attribute10 <> FND_API.G_MISS_CHAR) or

Line 1198: if (p_attribute10 <> FND_API.G_MISS_CHAR) or

1194: if (p_attribute9 <> FND_API.G_MISS_CHAR) or
1195: (p_attribute9 is null) then
1196: l_navigation_rec.attribute9 := p_attribute9;
1197: end if;
1198: if (p_attribute10 <> FND_API.G_MISS_CHAR) or
1199: (p_attribute10 is null) then
1200: l_navigation_rec.attribute10 := p_attribute10;
1201: end if;
1202: if (p_attribute11 <> FND_API.G_MISS_CHAR) or

Line 1202: if (p_attribute11 <> FND_API.G_MISS_CHAR) or

1198: if (p_attribute10 <> FND_API.G_MISS_CHAR) or
1199: (p_attribute10 is null) then
1200: l_navigation_rec.attribute10 := p_attribute10;
1201: end if;
1202: if (p_attribute11 <> FND_API.G_MISS_CHAR) or
1203: (p_attribute11 is null) then
1204: l_navigation_rec.attribute11 := p_attribute11;
1205: end if;
1206: if (p_attribute12 <> FND_API.G_MISS_CHAR) or

Line 1206: if (p_attribute12 <> FND_API.G_MISS_CHAR) or

1202: if (p_attribute11 <> FND_API.G_MISS_CHAR) or
1203: (p_attribute11 is null) then
1204: l_navigation_rec.attribute11 := p_attribute11;
1205: end if;
1206: if (p_attribute12 <> FND_API.G_MISS_CHAR) or
1207: (p_attribute12 is null) then
1208: l_navigation_rec.attribute12 := p_attribute12;
1209: end if;
1210: if (p_attribute13 <> FND_API.G_MISS_CHAR) or

Line 1210: if (p_attribute13 <> FND_API.G_MISS_CHAR) or

1206: if (p_attribute12 <> FND_API.G_MISS_CHAR) or
1207: (p_attribute12 is null) then
1208: l_navigation_rec.attribute12 := p_attribute12;
1209: end if;
1210: if (p_attribute13 <> FND_API.G_MISS_CHAR) or
1211: (p_attribute13 is null) then
1212: l_navigation_rec.attribute13 := p_attribute13;
1213: end if;
1214: if (p_attribute14 <> FND_API.G_MISS_CHAR) or

Line 1214: if (p_attribute14 <> FND_API.G_MISS_CHAR) or

1210: if (p_attribute13 <> FND_API.G_MISS_CHAR) or
1211: (p_attribute13 is null) then
1212: l_navigation_rec.attribute13 := p_attribute13;
1213: end if;
1214: if (p_attribute14 <> FND_API.G_MISS_CHAR) or
1215: (p_attribute14 is null) then
1216: l_navigation_rec.attribute14 := p_attribute14;
1217: end if;
1218: if (p_attribute15 <> FND_API.G_MISS_CHAR) or

Line 1218: if (p_attribute15 <> FND_API.G_MISS_CHAR) or

1214: if (p_attribute14 <> FND_API.G_MISS_CHAR) or
1215: (p_attribute14 is null) then
1216: l_navigation_rec.attribute14 := p_attribute14;
1217: end if;
1218: if (p_attribute15 <> FND_API.G_MISS_CHAR) or
1219: (p_attribute15 is null) then
1220: l_navigation_rec.attribute15 := p_attribute15;
1221: end if;
1222:

Line 1223: if (p_created_by <> FND_API.G_MISS_NUM) then

1219: (p_attribute15 is null) then
1220: l_navigation_rec.attribute15 := p_attribute15;
1221: end if;
1222:
1223: if (p_created_by <> FND_API.G_MISS_NUM) then
1224: l_created_by := p_created_by;
1225: end if;
1226: if (p_creation_date <> FND_API.G_MISS_DATE) then
1227: l_creation_date := p_creation_date;

Line 1226: if (p_creation_date <> FND_API.G_MISS_DATE) then

1222:
1223: if (p_created_by <> FND_API.G_MISS_NUM) then
1224: l_created_by := p_created_by;
1225: end if;
1226: if (p_creation_date <> FND_API.G_MISS_DATE) then
1227: l_creation_date := p_creation_date;
1228: end if;
1229: if (p_last_updated_by <> FND_API.G_MISS_NUM) then
1230: l_last_updated_by := p_last_updated_by;

Line 1229: if (p_last_updated_by <> FND_API.G_MISS_NUM) then

1225: end if;
1226: if (p_creation_date <> FND_API.G_MISS_DATE) then
1227: l_creation_date := p_creation_date;
1228: end if;
1229: if (p_last_updated_by <> FND_API.G_MISS_NUM) then
1230: l_last_updated_by := p_last_updated_by;
1231: end if;
1232: if (p_last_update_date <> FND_API.G_MISS_DATE) then
1233: l_last_update_date := p_last_update_date;

Line 1232: if (p_last_update_date <> FND_API.G_MISS_DATE) then

1228: end if;
1229: if (p_last_updated_by <> FND_API.G_MISS_NUM) then
1230: l_last_updated_by := p_last_updated_by;
1231: end if;
1232: if (p_last_update_date <> FND_API.G_MISS_DATE) then
1233: l_last_update_date := p_last_update_date;
1234: end if;
1235: if (p_last_update_login <> FND_API.G_MISS_NUM) then
1236: l_last_update_login := p_last_update_login;

Line 1235: if (p_last_update_login <> FND_API.G_MISS_NUM) then

1231: end if;
1232: if (p_last_update_date <> FND_API.G_MISS_DATE) then
1233: l_last_update_date := p_last_update_date;
1234: end if;
1235: if (p_last_update_login <> FND_API.G_MISS_NUM) then
1236: l_last_update_login := p_last_update_login;
1237: end if;
1238:
1239: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

Line 1312: raise FND_API.G_EXC_ERROR;

1308: FND_MESSAGE.SET_NAME('AK','AK_NAV_UPDATE_FAILED');
1309: FND_MSG_PUB.Add;
1310: end if;
1311: -- dbms_output.put_line('Row does not exist during update');
1312: raise FND_API.G_EXC_ERROR;
1313: end if;
1314:
1315: -- /** commit the update **/
1316: -- commit;

Line 1329: p_return_status := FND_API.G_RET_STS_SUCCESS;

1325: FND_MSG_PUB.Add;
1326: end if;
1327:
1328: end if;
1329: p_return_status := FND_API.G_RET_STS_SUCCESS;
1330:
1331: FND_MSG_PUB.Count_And_Get (
1332: p_count => p_msg_count,
1333: p_data => p_msg_data);

Line 1348: p_return_status := FND_API.G_RET_STS_ERROR;

1344: FND_MSG_PUB.Add;
1345: end if;
1346: -- dbms_output.put_line('Value error occurred in ' || l_api_name);
1347: rollback to start_update_navigation;
1348: p_return_status := FND_API.G_RET_STS_ERROR;
1349: FND_MSG_PUB.Count_And_Get (
1350: p_count => p_msg_count,
1351: p_data => p_msg_data);
1352: WHEN FND_API.G_EXC_ERROR THEN

Line 1352: WHEN FND_API.G_EXC_ERROR THEN

1348: p_return_status := FND_API.G_RET_STS_ERROR;
1349: FND_MSG_PUB.Count_And_Get (
1350: p_count => p_msg_count,
1351: p_data => p_msg_data);
1352: WHEN FND_API.G_EXC_ERROR THEN
1353: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1354: FND_MESSAGE.SET_NAME('AK','AK_NAV_NOT_UPDATED');
1355: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
1356: ' ' || to_char(p_attribute_application_id) ||

Line 1362: p_return_status := FND_API.G_RET_STS_ERROR;

1358: to_char(p_value_date) ||
1359: to_char(p_value_number) );
1360: FND_MSG_PUB.Add;
1361: end if;
1362: p_return_status := FND_API.G_RET_STS_ERROR;
1363: rollback to start_update_navigation;
1364: FND_MSG_PUB.Count_And_Get (
1365: p_count => p_msg_count,
1366: p_data => p_msg_data);

Line 1368: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1364: FND_MSG_PUB.Count_And_Get (
1365: p_count => p_msg_count,
1366: p_data => p_msg_data);
1367: WHEN OTHERS THEN
1368: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1369: rollback to start_update_navigation;
1370: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
1371: SUBSTR (SQLERRM, 1, 240) );
1372: FND_MSG_PUB.Count_And_Get (

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

1398: -- Version Initial version number = 1.0
1399: -- History Current version number = 1.0
1400: --=======================================================
1401: procedure UPDATE_ATTRIBUTE_VALUE (
1402: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1403: p_api_version_number IN NUMBER,
1404: p_init_msg_tbl IN BOOLEAN := FALSE,
1405: p_msg_count OUT NOCOPY NUMBER,
1406: p_msg_data OUT NOCOPY VARCHAR2,

Line 1412: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1408: p_database_object_name IN VARCHAR2,
1409: p_attribute_application_id IN NUMBER,
1410: p_attribute_code IN VARCHAR2,
1411: p_key_value1 IN VARCHAR2,
1412: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1413: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1414: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1415: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1416: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1413: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1409: p_attribute_application_id IN NUMBER,
1410: p_attribute_code IN VARCHAR2,
1411: p_key_value1 IN VARCHAR2,
1412: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1413: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1414: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1415: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1416: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1417: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1414: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1410: p_attribute_code IN VARCHAR2,
1411: p_key_value1 IN VARCHAR2,
1412: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1413: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1414: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1415: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1416: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1417: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1418: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1415: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1411: p_key_value1 IN VARCHAR2,
1412: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1413: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1414: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1415: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1416: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1417: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1418: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1419: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1416: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1412: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1413: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1414: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1415: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1416: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1417: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1418: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1419: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1420: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1417: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1413: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1414: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1415: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1416: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1417: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1418: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1419: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1420: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1421: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1418: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1414: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1415: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1416: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1417: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1418: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1419: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1420: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1421: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1422: p_value_date IN DATE := FND_API.G_MISS_DATE,

Line 1419: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1415: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1416: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1417: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1418: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1419: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1420: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1421: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1422: p_value_date IN DATE := FND_API.G_MISS_DATE,
1423: p_value_number IN NUMBER := FND_API.G_MISS_NUM,

Line 1420: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1416: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1417: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1418: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1419: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1420: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1421: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1422: p_value_date IN DATE := FND_API.G_MISS_DATE,
1423: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
1424: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 1421: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1417: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1418: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1419: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1420: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1421: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1422: p_value_date IN DATE := FND_API.G_MISS_DATE,
1423: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
1424: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1425: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 1422: p_value_date IN DATE := FND_API.G_MISS_DATE,

1418: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1419: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1420: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1421: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1422: p_value_date IN DATE := FND_API.G_MISS_DATE,
1423: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
1424: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1425: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1426: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 1423: p_value_number IN NUMBER := FND_API.G_MISS_NUM,

1419: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1420: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1421: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1422: p_value_date IN DATE := FND_API.G_MISS_DATE,
1423: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
1424: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1425: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1426: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1427: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

Line 1424: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

1420: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1421: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1422: p_value_date IN DATE := FND_API.G_MISS_DATE,
1423: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
1424: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1425: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1426: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1427: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1428: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

Line 1425: p_creation_date IN DATE := FND_API.G_MISS_DATE,

1421: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1422: p_value_date IN DATE := FND_API.G_MISS_DATE,
1423: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
1424: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1425: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1426: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1427: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1428: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
1429: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE

Line 1426: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

1422: p_value_date IN DATE := FND_API.G_MISS_DATE,
1423: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
1424: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1425: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1426: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1427: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1428: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
1429: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE
1430: ) is

Line 1427: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

1423: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
1424: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1425: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1426: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1427: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1428: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
1429: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE
1430: ) is
1431: l_api_version_number CONSTANT number := 1.0;

Line 1428: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

1424: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1425: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1426: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1427: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1428: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
1429: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE
1430: ) is
1431: l_api_version_number CONSTANT number := 1.0;
1432: l_api_name CONSTANT varchar2(30) := 'Update_Attribute_Value';

Line 1429: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE

1425: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1426: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1427: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1428: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
1429: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE
1430: ) is
1431: l_api_version_number CONSTANT number := 1.0;
1432: l_api_name CONSTANT varchar2(30) := 'Update_Attribute_Value';
1433: l_created_by number;

Line 1456: IF NOT FND_API.Compatible_API_Call (

1452: l_value_varchar2 VARCHAR2(240);
1453: l_value_date DATE;
1454: l_value_number NUMBER;
1455: begin
1456: IF NOT FND_API.Compatible_API_Call (
1457: l_api_version_number, p_api_version_number, l_api_name,
1458: G_PKG_NAME) then
1459: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1460: return;

Line 1459: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1455: begin
1456: IF NOT FND_API.Compatible_API_Call (
1457: l_api_version_number, p_api_version_number, l_api_name,
1458: G_PKG_NAME) then
1459: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1460: return;
1461: END IF;
1462:
1463: -- Initialize the message table if requested.

Line 1473: if (p_key_value2 is not null and p_key_value2 <> FND_API.G_MISS_CHAR) then

1469: savepoint start_update_value;
1470:
1471: -- load the optional key values to be used to query the database.
1472: --
1473: if (p_key_value2 is not null and p_key_value2 <> FND_API.G_MISS_CHAR) then
1474: l_key_value2 := p_key_value2;
1475: end if;
1476: if (p_key_value3 is not null and p_key_value3 <> FND_API.G_MISS_CHAR) then
1477: l_key_value3 := p_key_value3;

Line 1476: if (p_key_value3 is not null and p_key_value3 <> FND_API.G_MISS_CHAR) then

1472: --
1473: if (p_key_value2 is not null and p_key_value2 <> FND_API.G_MISS_CHAR) then
1474: l_key_value2 := p_key_value2;
1475: end if;
1476: if (p_key_value3 is not null and p_key_value3 <> FND_API.G_MISS_CHAR) then
1477: l_key_value3 := p_key_value3;
1478: end if;
1479: if (p_key_value4 is not null and p_key_value4 <> FND_API.G_MISS_CHAR) then
1480: l_key_value4 := p_key_value4;

Line 1479: if (p_key_value4 is not null and p_key_value4 <> FND_API.G_MISS_CHAR) then

1475: end if;
1476: if (p_key_value3 is not null and p_key_value3 <> FND_API.G_MISS_CHAR) then
1477: l_key_value3 := p_key_value3;
1478: end if;
1479: if (p_key_value4 is not null and p_key_value4 <> FND_API.G_MISS_CHAR) then
1480: l_key_value4 := p_key_value4;
1481: end if;
1482: if (p_key_value5 is not null and p_key_value5 <> FND_API.G_MISS_CHAR) then
1483: l_key_value5 := p_key_value5;

Line 1482: if (p_key_value5 is not null and p_key_value5 <> FND_API.G_MISS_CHAR) then

1478: end if;
1479: if (p_key_value4 is not null and p_key_value4 <> FND_API.G_MISS_CHAR) then
1480: l_key_value4 := p_key_value4;
1481: end if;
1482: if (p_key_value5 is not null and p_key_value5 <> FND_API.G_MISS_CHAR) then
1483: l_key_value5 := p_key_value5;
1484: end if;
1485: if (p_key_value6 is not null and p_key_value6 <> FND_API.G_MISS_CHAR) then
1486: l_key_value6 := p_key_value6;

Line 1485: if (p_key_value6 is not null and p_key_value6 <> FND_API.G_MISS_CHAR) then

1481: end if;
1482: if (p_key_value5 is not null and p_key_value5 <> FND_API.G_MISS_CHAR) then
1483: l_key_value5 := p_key_value5;
1484: end if;
1485: if (p_key_value6 is not null and p_key_value6 <> FND_API.G_MISS_CHAR) then
1486: l_key_value6 := p_key_value6;
1487: end if;
1488: if (p_key_value7 is not null and p_key_value7 <> FND_API.G_MISS_CHAR) then
1489: l_key_value7 := p_key_value7;

Line 1488: if (p_key_value7 is not null and p_key_value7 <> FND_API.G_MISS_CHAR) then

1484: end if;
1485: if (p_key_value6 is not null and p_key_value6 <> FND_API.G_MISS_CHAR) then
1486: l_key_value6 := p_key_value6;
1487: end if;
1488: if (p_key_value7 is not null and p_key_value7 <> FND_API.G_MISS_CHAR) then
1489: l_key_value7 := p_key_value7;
1490: end if;
1491: if (p_key_value8 is not null and p_key_value8 <> FND_API.G_MISS_CHAR) then
1492: l_key_value8 := p_key_value8;

Line 1491: if (p_key_value8 is not null and p_key_value8 <> FND_API.G_MISS_CHAR) then

1487: end if;
1488: if (p_key_value7 is not null and p_key_value7 <> FND_API.G_MISS_CHAR) then
1489: l_key_value7 := p_key_value7;
1490: end if;
1491: if (p_key_value8 is not null and p_key_value8 <> FND_API.G_MISS_CHAR) then
1492: l_key_value8 := p_key_value8;
1493: end if;
1494: if (p_key_value9 is not null and p_key_value9 <> FND_API.G_MISS_CHAR) then
1495: l_key_value9 := p_key_value9;

Line 1494: if (p_key_value9 is not null and p_key_value9 <> FND_API.G_MISS_CHAR) then

1490: end if;
1491: if (p_key_value8 is not null and p_key_value8 <> FND_API.G_MISS_CHAR) then
1492: l_key_value8 := p_key_value8;
1493: end if;
1494: if (p_key_value9 is not null and p_key_value9 <> FND_API.G_MISS_CHAR) then
1495: l_key_value9 := p_key_value9;
1496: end if;
1497: if (p_key_value10 is not null and p_key_value10 <> FND_API.G_MISS_CHAR) then
1498: l_key_value10 := p_key_value10;

Line 1497: if (p_key_value10 is not null and p_key_value10 <> FND_API.G_MISS_CHAR) then

1493: end if;
1494: if (p_key_value9 is not null and p_key_value9 <> FND_API.G_MISS_CHAR) then
1495: l_key_value9 := p_key_value9;
1496: end if;
1497: if (p_key_value10 is not null and p_key_value10 <> FND_API.G_MISS_CHAR) then
1498: l_key_value10 := p_key_value10;
1499: end if;
1500:
1501: --

Line 1606: raise FND_API.G_EXC_ERROR;

1602: end if;
1603: --dbms_output.put_line(l_api_name || 'Error - Row does not exist');
1604: --close l_get_row_csr;
1605: dbms_sql.close_cursor(l_sql_csr);
1606: raise FND_API.G_EXC_ERROR;
1607: end if;
1608: dbms_sql.close_cursor(l_sql_csr);
1609:
1610: --** validate table columns passed in **

Line 1611: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then

1607: end if;
1608: dbms_sql.close_cursor(l_sql_csr);
1609:
1610: --** validate table columns passed in **
1611: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then
1612: if not ak_object_pvt.validate_attribute_value (
1613: p_validation_level => p_validation_level,
1614: p_api_version_number => 1.0,
1615: p_return_status => l_return_status,

Line 1635: raise FND_API.G_EXC_ERROR;

1631: p_value_number => p_value_number,
1632: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE
1633: ) then
1634: -- dbms_output.put_line(l_api_name || ' validation failed');
1635: raise FND_API.G_EXC_ERROR;
1636: end if;
1637: end if;
1638:
1639: --** Load record to be updated to the database **

Line 1642: if (p_value_varchar2 <> FND_API.G_MISS_CHAR) or

1638:
1639: --** Load record to be updated to the database **
1640: --** - first load nullable columns **
1641:
1642: if (p_value_varchar2 <> FND_API.G_MISS_CHAR) or
1643: (p_value_varchar2 is null) then
1644: l_value_varchar2 := p_value_varchar2;
1645: end if;
1646: if (p_value_date <> FND_API.G_MISS_DATE) or

Line 1646: if (p_value_date <> FND_API.G_MISS_DATE) or

1642: if (p_value_varchar2 <> FND_API.G_MISS_CHAR) or
1643: (p_value_varchar2 is null) then
1644: l_value_varchar2 := p_value_varchar2;
1645: end if;
1646: if (p_value_date <> FND_API.G_MISS_DATE) or
1647: (p_value_date is null) then
1648: l_value_date := p_value_date;
1649: end if;
1650: if (p_value_number <> FND_API.G_MISS_NUM) or

Line 1650: if (p_value_number <> FND_API.G_MISS_NUM) or

1646: if (p_value_date <> FND_API.G_MISS_DATE) or
1647: (p_value_date is null) then
1648: l_value_date := p_value_date;
1649: end if;
1650: if (p_value_number <> FND_API.G_MISS_NUM) or
1651: (p_value_number is null) then
1652: l_value_number := p_value_number;
1653: end if;
1654:

Line 1731: raise FND_API.G_EXC_ERROR;

1727: FND_MSG_PUB.Add;
1728: end if;
1729: --dbms_output.put_line('Row does not exist during update');
1730: dbms_sql.close_cursor(l_sql_csr);
1731: raise FND_API.G_EXC_ERROR;
1732: end if;
1733: dbms_sql.close_cursor(l_sql_csr);
1734:
1735: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN

Line 1754: p_return_status := FND_API.G_RET_STS_SUCCESS;

1750: ' ' || l_key_value10);
1751: FND_MSG_PUB.Add;
1752: end if;
1753:
1754: p_return_status := FND_API.G_RET_STS_SUCCESS;
1755:
1756: FND_MSG_PUB.Count_And_Get (
1757: p_count => p_msg_count,
1758: p_data => p_msg_data);

Line 1782: p_return_status := FND_API.G_RET_STS_ERROR;

1778: FND_MSG_PUB.Add;
1779: end if;
1780: --dbms_output.put_line('Value error occurred in ' || l_api_name);
1781: rollback to start_update_value;
1782: p_return_status := FND_API.G_RET_STS_ERROR;
1783: FND_MSG_PUB.Count_And_Get (
1784: p_count => p_msg_count,
1785: p_data => p_msg_data);
1786: WHEN FND_API.G_EXC_ERROR THEN

Line 1786: WHEN FND_API.G_EXC_ERROR THEN

1782: p_return_status := FND_API.G_RET_STS_ERROR;
1783: FND_MSG_PUB.Count_And_Get (
1784: p_count => p_msg_count,
1785: p_data => p_msg_data);
1786: WHEN FND_API.G_EXC_ERROR THEN
1787: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1788: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_UPDATED');
1789: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
1790: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||

Line 1805: p_return_status := FND_API.G_RET_STS_ERROR;

1801: ' ' || l_key_value9 ||
1802: ' ' || l_key_value10);
1803: FND_MSG_PUB.Add;
1804: end if;
1805: p_return_status := FND_API.G_RET_STS_ERROR;
1806: rollback to start_update_value;
1807: FND_MSG_PUB.Count_And_Get (
1808: p_count => p_msg_count,
1809: p_data => p_msg_data);

Line 1811: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1807: FND_MSG_PUB.Count_And_Get (
1808: p_count => p_msg_count,
1809: p_data => p_msg_data);
1810: WHEN OTHERS THEN
1811: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1812: rollback to start_update_value;
1813: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
1814: SUBSTR (SQLERRM, 1, 240) );
1815: FND_MSG_PUB.Count_And_Get (

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

1867: -- Version Initial version number = 1.0
1868: -- History Current version number = 1.0
1869: --=======================================================
1870: procedure UPLOAD_OBJECT (
1871: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1872: p_api_version_number IN NUMBER,
1873: p_return_status OUT NOCOPY VARCHAR2,
1874: p_index IN OUT NOCOPY NUMBER,
1875: p_loader_timestamp IN DATE,

Line 1876: p_line_num IN NUMBER := FND_API.G_MISS_NUM,

1872: p_api_version_number IN NUMBER,
1873: p_return_status OUT NOCOPY VARCHAR2,
1874: p_index IN OUT NOCOPY NUMBER,
1875: p_loader_timestamp IN DATE,
1876: p_line_num IN NUMBER := FND_API.G_MISS_NUM,
1877: p_buffer IN AK_ON_OBJECTS_PUB.Buffer_Type,
1878: p_line_num_out OUT NOCOPY NUMBER,
1879: p_buffer_out OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,
1880: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp,

Line 1931: IF NOT FND_API.Compatible_API_Call (

1927: l_user_id2 NUMBER;
1928: l_update1 DATE;
1929: l_update2 DATE;
1930: begin
1931: IF NOT FND_API.Compatible_API_Call (
1932: l_api_version_number, p_api_version_number, l_api_name,
1933: G_PKG_NAME) then
1934: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1935: return;

Line 1934: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1930: begin
1931: IF NOT FND_API.Compatible_API_Call (
1932: l_api_version_number, p_api_version_number, l_api_name,
1933: G_PKG_NAME) then
1934: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1935: return;
1936: END IF;
1937:
1938: -- dbms_output.put_line('Started object upload: ' ||

Line 1953: if (p_loader_timestamp <> FND_API.G_MISS_DATE) then

1949: -- the tokens 'BEGIN OBJECT' has already been parsed. Set initial
1950: -- buffer to 'BEGIN OBJECT' before reading the next line from the
1951: -- file. Otherwise, set initial buffer to null.
1952: --
1953: if (p_loader_timestamp <> FND_API.G_MISS_DATE) then
1954: l_buffer := 'BEGIN OBJECT ' || p_buffer;
1955: else
1956: l_buffer := null;
1957: end if;

Line 1959: if (p_line_num = FND_API.G_MISS_NUM) then

1955: else
1956: l_buffer := null;
1957: end if;
1958:
1959: if (p_line_num = FND_API.G_MISS_NUM) then
1960: l_line_num := 0;
1961: else
1962: l_line_num := p_line_num;
1963: end if;

Line 1974: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

1970: p_lines_read => l_lines_read,
1971: p_eof_flag => l_eof_flag,
1972: p_upl_loader_cur => p_upl_loader_cur
1973: );
1974: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1975: (l_return_status = FND_API.G_RET_STS_ERROR) then
1976: --dbms_output.put_line('Error from UPLOAD_OBJECT after READ_LINE');
1977: RAISE FND_API.G_EXC_ERROR;
1978: end if;

Line 1975: (l_return_status = FND_API.G_RET_STS_ERROR) then

1971: p_eof_flag => l_eof_flag,
1972: p_upl_loader_cur => p_upl_loader_cur
1973: );
1974: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1975: (l_return_status = FND_API.G_RET_STS_ERROR) then
1976: --dbms_output.put_line('Error from UPLOAD_OBJECT after READ_LINE');
1977: RAISE FND_API.G_EXC_ERROR;
1978: end if;
1979: l_line_num := l_line_num + l_lines_read;

Line 1977: RAISE FND_API.G_EXC_ERROR;

1973: );
1974: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1975: (l_return_status = FND_API.G_RET_STS_ERROR) then
1976: --dbms_output.put_line('Error from UPLOAD_OBJECT after READ_LINE');
1977: RAISE FND_API.G_EXC_ERROR;
1978: end if;
1979: l_line_num := l_line_num + l_lines_read;
1980: --
1981: -- trim leading spaces and discard comment lines

Line 1997: raise FND_API.G_EXC_ERROR;

1993: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1994: FND_MESSAGE.SET_NAME('AK','AK_EMPTY_BUFFER');
1995: FND_MSG_PUB.Add;
1996: end if;
1997: raise FND_API.G_EXC_ERROR;
1998: end if;
1999:
2000: -- Read tokens from file, one at a time
2001:

Line 2012: if (l_return_status = FND_API.G_RET_STS_ERROR) or

2008: p_token => l_token
2009: );
2010:
2011: --dbms_output.put_line(' State:' || to_char(l_state) || ' Token:' || l_token);
2012: if (l_return_status = FND_API.G_RET_STS_ERROR) or
2013: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
2014: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2015: FND_MESSAGE.SET_NAME('AK','AK_GET_TOKEN_ERROR');
2016: FND_MSG_PUB.Add;

Line 2013: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

2009: );
2010:
2011: --dbms_output.put_line(' State:' || to_char(l_state) || ' Token:' || l_token);
2012: if (l_return_status = FND_API.G_RET_STS_ERROR) or
2013: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
2014: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2015: FND_MESSAGE.SET_NAME('AK','AK_GET_TOKEN_ERROR');
2016: FND_MSG_PUB.Add;
2017: end if;

Line 2019: raise FND_API.G_EXC_ERROR;

2015: FND_MESSAGE.SET_NAME('AK','AK_GET_TOKEN_ERROR');
2016: FND_MSG_PUB.Add;
2017: end if;
2018: --dbms_output.put_line(l_api_name || 'Error parsing buffer');
2019: raise FND_API.G_EXC_ERROR;
2020: end if;
2021:
2022: --**** OBJECT processing (states 0 - 19) ****
2023:

Line 2038: raise FND_API.G_EXC_ERROR;

2034: FND_MESSAGE.SET_TOKEN('EXPECTED','BEGIN');
2035: FND_MSG_PUB.Add;
2036: end if;
2037: --dbms_output.put_line('Expecting BEGIN');
2038: raise FND_API.G_EXC_ERROR;
2039: end if;
2040: elsif (l_state = 1) then
2041: if (l_token = 'OBJECT') then
2042: l_state := 2;

Line 2064: raise FND_API.G_EXC_ERROR;

2060: FND_MESSAGE.SET_TOKEN('EXPECTED','DATABASE_OBJECT_NAME');
2061: FND_MSG_PUB.Add;
2062: end if;
2063: --dbms_output.put_line('Expecting database object name');
2064: raise FND_API.G_EXC_ERROR;
2065: end if;
2066: elsif (l_state = 10) then
2067: if (l_token = 'BEGIN') then
2068: l_state := 13;

Line 2131: raise FND_API.G_EXC_ERROR;

2127: FND_MESSAGE.SET_TOKEN('EXPECTED','OBJECT');
2128: FND_MSG_PUB.Add;
2129: end if;
2130: --dbms_output.put_line('Expecting object column name');
2131: raise FND_API.G_EXC_ERROR;
2132: end if;
2133: end if;
2134: elsif (l_state = 11) then
2135: if (l_token = '=') then

Line 2145: raise FND_API.G_EXC_ERROR;

2141: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2142: FND_MESSAGE.SET_TOKEN('EXPECTED','=');
2143: FND_MSG_PUB.Add;
2144: end if;
2145: raise FND_API.G_EXC_ERROR;
2146: end if;
2147: elsif (l_state = 12) then
2148: l_value_count := 1;
2149: if (l_column = 'NAME') then

Line 2220: raise FND_API.G_EXC_ERROR;

2216: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2217: FND_MSG_PUB.Add;
2218: end if;
2219: --dbms_output.put_line('Expecting ' || l_column || ' value');
2220: raise FND_API.G_EXC_ERROR;
2221: end if;
2222: l_state := 10;
2223: elsif (l_state = 13) then
2224: if (l_token = 'OBJECT_ATTRIBUTE') then

Line 2241: raise FND_API.G_EXC_ERROR;

2237: FND_MSG_PUB.Add;
2238: end if;
2239: --dbms_output.put_line('Expecting OBJECT_ATTRIBUTE, UNIQUE_KEY, or ' ||
2240: -- 'FOREIGN_KEY');
2241: raise FND_API.G_EXC_ERROR;
2242: end if;
2243: elsif (l_state = 19) then
2244: if (l_token = 'OBJECT') then
2245: l_state := 0;

Line 2256: raise FND_API.G_EXC_ERROR;

2252: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2253: FND_MESSAGE.SET_TOKEN('EXPECTED', 'OBJECT');
2254: FND_MSG_PUB.Add;
2255: end if;
2256: raise FND_API.G_EXC_ERROR;
2257: end if;
2258:
2259: --**** OBJECT_ATTRIBUTE processing (states 100 - 119) ****
2260:

Line 2276: raise FND_API.G_EXC_ERROR;

2272: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPLICATION_ID');
2273: FND_MSG_PUB.Add;
2274: end if;
2275: --dbms_output.put_line('Expecting attribute application ID');
2276: raise FND_API.G_EXC_ERROR;
2277: end if;
2278: elsif (l_state = 101) then
2279: if (l_token is not null) then
2280: l_attribute_rec.attribute_code := l_token;

Line 2292: raise FND_API.G_EXC_ERROR;

2288: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');
2289: FND_MSG_PUB.Add;
2290: end if;
2291: --dbms_output.put_line('Expecting attribute code');
2292: raise FND_API.G_EXC_ERROR;
2293: end if;
2294: elsif (l_state = 110) then
2295: if (l_token = 'BEGIN') then
2296: l_state := 113;

Line 2374: raise FND_API.G_EXC_ERROR;

2370: end if;
2371: FND_MESSAGE.SET_TOKEN('EXPECTED','OBJECT_ATTRIBUTE');
2372: FND_MSG_PUB.Add;
2373: end if;
2374: raise FND_API.G_EXC_ERROR;
2375: end if;
2376: end if;
2377: elsif (l_state = 111) then
2378: if (l_token = '=') then

Line 2389: raise FND_API.G_EXC_ERROR;

2385: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
2386: FND_MSG_PUB.Add;
2387: --dbms_output.put_line('Error: Expected = ');
2388: end if;
2389: raise FND_API.G_EXC_ERROR;
2390: end if;
2391: elsif (l_state = 112) then
2392: l_value_count := 1;
2393: if (l_column = 'COLUMN_NAME') then

Line 2542: raise FND_API.G_EXC_ERROR;

2538: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2539: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2540: FND_MSG_PUB.Add;
2541: end if;
2542: raise FND_API.G_EXC_ERROR;
2543: end if;
2544: elsif (l_state = 113) then
2545: if (l_token = 'ATTRIBUTE_VALUE') then
2546: l_state := 120;

Line 2558: raise FND_API.G_EXC_ERROR;

2554: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE_VALUE, ' ||
2555: 'ATTRIBUTE_NAVIGATION');
2556: FND_MSG_PUB.Add;
2557: end if;
2558: raise FND_API.G_EXC_ERROR;
2559: end if;
2560: elsif (l_state = 114) then
2561: if (l_column = 'LOV_REGION') then
2562: l_attribute_rec.lov_region_code := l_token;

Line 2573: raise FND_API.G_EXC_ERROR;

2569: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2570: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2571: FND_MSG_PUB.Add;
2572: end if;
2573: raise FND_API.G_EXC_ERROR;
2574: end if;
2575: l_state := 110;
2576: elsif (l_state = 119) then
2577: if (l_token = 'OBJECT_ATTRIBUTE') then

Line 2593: raise FND_API.G_EXC_ERROR;

2589: FND_MESSAGE.SET_TOKEN('EXPECTED', 'OBJECT_ATTRIBUTE');
2590: FND_MSG_PUB.Add;
2591: end if;
2592: --dbms_output.put_line('Expecting OBJECT_ATTRIBUTE');
2593: raise FND_API.G_EXC_ERROR;
2594: end if;
2595:
2596: --**** ATTRIBUTE_VALUE processing (states 120 - 139) ****
2597:

Line 2613: raise FND_API.G_EXC_ERROR;

2609: FND_MESSAGE.SET_TOKEN('EXPECTED', 'key_value1');
2610: FND_MSG_PUB.Add;
2611: end if;
2612: --dbms_output.put_line('Expecting key_value1');
2613: raise FND_API.G_EXC_ERROR;
2614: end if;
2615: elsif (l_state = 121) then
2616: l_attribute_value_rec.key_value2 := l_token;
2617: l_state := 122;

Line 2677: raise FND_API.G_EXC_ERROR;

2673: end if;
2674: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE_VALUE');
2675: FND_MSG_PUB.Add;
2676: end if;
2677: raise FND_API.G_EXC_ERROR;
2678: end if;
2679: end if;
2680: elsif (l_state = 131) then
2681: if (l_token = '=') then

Line 2691: raise FND_API.G_EXC_ERROR;

2687: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2688: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
2689: FND_MSG_PUB.Add;
2690: end if;
2691: raise FND_API.G_EXC_ERROR;
2692: end if;
2693: elsif (l_state = 132) then
2694: l_value_count := 1;
2695: if (l_column = 'VALUE') then

Line 2705: raise FND_API.G_EXC_ERROR;

2701: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2702: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2703: FND_MSG_PUB.Add;
2704: end if;
2705: raise FND_API.G_EXC_ERROR;
2706: end if;
2707: l_state := 134;
2708: elsif (l_state = 134) then
2709: if (l_column = 'VALUE') then

Line 2720: raise FND_API.G_EXC_ERROR;

2716: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2717: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2718: FND_MSG_PUB.Add;
2719: end if;
2720: raise FND_API.G_EXC_ERROR;
2721: end if;
2722: l_state := 135;
2723: elsif (l_state = 135) then
2724: if (l_column = 'VALUE') then

Line 2734: raise FND_API.G_EXC_ERROR;

2730: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2731: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2732: FND_MSG_PUB.Add;
2733: end if;
2734: raise FND_API.G_EXC_ERROR;
2735: end if;
2736: l_state := 130;
2737: elsif (l_state = 139) then
2738: if (l_token = 'ATTRIBUTE_VALUE') then

Line 2758: raise FND_API.G_EXC_ERROR;

2754: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_VALUE');
2755: FND_MSG_PUB.Add;
2756: end if;
2757: --dbms_output.put_line('Expecting ATTRIBUTE_VALUE');
2758: raise FND_API.G_EXC_ERROR;
2759: end if;
2760:
2761: --**** ATTRIBUTE_NAVIGATION processing (states 140 - 159) ****
2762:

Line 2835: raise FND_API.G_EXC_ERROR;

2831: end if;
2832: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE_NAVIGATION');
2833: FND_MSG_PUB.Add;
2834: end if;
2835: raise FND_API.G_EXC_ERROR;
2836: end if;
2837: end if;
2838: elsif (l_state = 151) then
2839: if (l_token = '=') then

Line 2849: raise FND_API.G_EXC_ERROR;

2845: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2846: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
2847: FND_MSG_PUB.Add;
2848: end if;
2849: raise FND_API.G_EXC_ERROR;
2850: end if;
2851: elsif (l_state = 152) then
2852: l_value_count := 1;
2853: if (l_column = 'TO_REGION') then

Line 2933: raise FND_API.G_EXC_ERROR;

2929: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2930: FND_MSG_PUB.Add;
2931: end if;
2932: --dbms_output.put_line('Expecting ' || l_column || ' value');
2933: raise FND_API.G_EXC_ERROR;
2934: end if;
2935: elsif (l_state = 154) then
2936: if (l_column = 'TO_REGION') then
2937: l_navigation_rec.to_region_code := l_token;

Line 2947: raise FND_API.G_EXC_ERROR;

2943: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2944: FND_MSG_PUB.Add;
2945: end if;
2946: --dbms_output.put_line('Expecting ' || l_column || ' value');
2947: raise FND_API.G_EXC_ERROR;
2948: end if;
2949: l_state := 150;
2950: elsif (l_state = 159) then
2951: if (l_token = 'ATTRIBUTE_NAVIGATION') then

Line 2970: raise FND_API.G_EXC_ERROR;

2966: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_NAVIGATION');
2967: FND_MSG_PUB.Add;
2968: end if;
2969: --dbms_output.put_line('Expecting ATTRIBUTE_NAVIGATION');
2970: raise FND_API.G_EXC_ERROR;
2971: end if;
2972:
2973: --**** UNIQUE_KEY processing (states 200 - 219) ****
2974:

Line 2991: raise FND_API.G_EXC_ERROR;

2987: FND_MESSAGE.SET_TOKEN('EXPECTED', 'UNIQUE_KEY_NAME');
2988: FND_MSG_PUB.Add;
2989: end if;
2990: --dbms_output.put_line('Expecting unique_key_name');
2991: raise FND_API.G_EXC_ERROR;
2992: end if;
2993: elsif (l_state = 210) then
2994: if (l_token = 'END') then
2995: l_state := 219;

Line 3051: raise FND_API.G_EXC_ERROR;

3047: end if;
3048: FND_MESSAGE.SET_TOKEN('EXPECTED','UNIQUE_KEY');
3049: FND_MSG_PUB.Add;
3050: end if;
3051: raise FND_API.G_EXC_ERROR;
3052: end if;
3053: end if;
3054: elsif (l_state = 211) then
3055: if (l_token = '=') then

Line 3065: raise FND_API.G_EXC_ERROR;

3061: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3062: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
3063: FND_MSG_PUB.Add;
3064: end if;
3065: raise FND_API.G_EXC_ERROR;
3066: end if;
3067: elsif (l_state = 212) then
3068: l_value_count := 1;
3069: if (l_column = 'APPLICATION_ID') then

Line 3126: raise FND_API.G_EXC_ERROR;

3122: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
3123: FND_MSG_PUB.Add;
3124: end if;
3125: --dbms_output.put_line('Expecting ' || l_column || ' value');
3126: raise FND_API.G_EXC_ERROR;
3127: end if;
3128: l_state := 210;
3129: elsif (l_state = 213) then
3130: if (l_token = 'UNIQUE_KEY_COLUMN') then

Line 3141: raise FND_API.G_EXC_ERROR;

3137: FND_MESSAGE.SET_TOKEN('EXPECTED', 'UNIQUE_KEY_COLUMN');
3138: FND_MSG_PUB.Add;
3139: end if;
3140: --dbms_output.put_line('Expecting UNIQUE_KEY_COLUMN');
3141: raise FND_API.G_EXC_ERROR;
3142: end if;
3143: elsif (l_state = 219) then
3144: if (l_token = 'UNIQUE_KEY') then
3145: l_value_count := null;

Line 3159: raise FND_API.G_EXC_ERROR;

3155: FND_MESSAGE.SET_TOKEN('EXPECTED', 'UNIQUE_KEY');
3156: FND_MSG_PUB.Add;
3157: end if;
3158: --dbms_output.put_line('Expecting UNIQUE_KEY');
3159: raise FND_API.G_EXC_ERROR;
3160: end if;
3161:
3162: --**** UNIQUE_KEY_COLUMN processing (states 220 - 239) ****
3163:

Line 3178: raise FND_API.G_EXC_ERROR;

3174: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3175: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPLICATION_ID');
3176: FND_MSG_PUB.Add;
3177: end if;
3178: raise FND_API.G_EXC_ERROR;
3179: end if;
3180: elsif (l_state = 221) then
3181: if (l_token is not null) then
3182: l_unique_key_column_rec.attribute_code := l_token;

Line 3193: raise FND_API.G_EXC_ERROR;

3189: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3190: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');
3191: FND_MSG_PUB.Add;
3192: end if;
3193: raise FND_API.G_EXC_ERROR;
3194: end if;
3195: elsif (l_state = 230) then
3196: if (l_token = 'END') then
3197: l_state := 239;

Line 3251: raise FND_API.G_EXC_ERROR;

3247: end if;
3248: FND_MESSAGE.SET_TOKEN('EXPECTED','UNIQUE_KEY_COLUMN');
3249: FND_MSG_PUB.Add;
3250: end if;
3251: raise FND_API.G_EXC_ERROR;
3252: end if;
3253: end if;
3254: elsif (l_state = 231) then
3255: if (l_token = '=') then

Line 3265: raise FND_API.G_EXC_ERROR;

3261: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3262: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
3263: FND_MSG_PUB.Add;
3264: end if;
3265: raise FND_API.G_EXC_ERROR;
3266: end if;
3267: elsif (l_state = 232) then
3268: l_value_count := 1;
3269: if (l_column = 'UNIQUE_KEY_SEQUENCE') then

Line 3326: raise FND_API.G_EXC_ERROR;

3322: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
3323: FND_MSG_PUB.Add;
3324: end if;
3325: --dbms_output.put_line('Expecting ' || l_column || ' value');
3326: raise FND_API.G_EXC_ERROR;
3327: end if;
3328: l_state := 230;
3329: elsif (l_state = 239) then
3330: if (l_token = 'UNIQUE_KEY_COLUMN') then

Line 3347: raise FND_API.G_EXC_ERROR;

3343: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3344: FND_MESSAGE.SET_TOKEN('EXPECTED', 'UNIQUE_KEY_COLUMN');
3345: FND_MSG_PUB.Add;
3346: end if;
3347: raise FND_API.G_EXC_ERROR;
3348: end if;
3349:
3350: --**** FOREIGN_KEY processing (states 300 - 319) ****
3351: elsif (l_state = 300) then

Line 3366: raise FND_API.G_EXC_ERROR;

3362: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3363: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FOREIGN_KEY_NAME');
3364: FND_MSG_PUB.Add;
3365: end if;
3366: raise FND_API.G_EXC_ERROR;
3367: end if;
3368: elsif (l_state = 310) then
3369: if (l_token = 'END') then
3370: l_state := 319;

Line 3431: raise FND_API.G_EXC_ERROR;

3427: end if;
3428: FND_MESSAGE.SET_TOKEN('EXPECTED','FOREIGN_KEY');
3429: FND_MSG_PUB.Add;
3430: end if;
3431: raise FND_API.G_EXC_ERROR;
3432: end if;
3433: end if;
3434: elsif (l_state = 311) then
3435: if (l_token = '=') then

Line 3445: raise FND_API.G_EXC_ERROR;

3441: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3442: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
3443: FND_MSG_PUB.Add;
3444: end if;
3445: raise FND_API.G_EXC_ERROR;
3446: end if;
3447: elsif (l_state = 312) then
3448: l_value_count := 1;
3449: if (l_column = 'APPLICATION_ID') then

Line 3515: raise FND_API.G_EXC_ERROR;

3511: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3512: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');
3513: FND_MSG_PUB.Add;
3514: end if;
3515: raise FND_API.G_EXC_ERROR;
3516: end if;
3517: l_state := 310;
3518: elsif (l_state = 313) then
3519: if (l_token = 'FOREIGN_KEY_COLUMN') then

Line 3529: raise FND_API.G_EXC_ERROR;

3525: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3526: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FOREIGN_KEY_COLUMN');
3527: FND_MSG_PUB.Add;
3528: end if;
3529: raise FND_API.G_EXC_ERROR;
3530: end if;
3531: elsif (l_state = 319) then
3532: if (l_token = 'FOREIGN_KEY') then
3533: l_value_count := null;

Line 3547: raise FND_API.G_EXC_ERROR;

3543: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3544: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FOREIGN_KEY');
3545: FND_MSG_PUB.Add;
3546: end if;
3547: raise FND_API.G_EXC_ERROR;
3548: end if;
3549:
3550: --**** FOREIGN_KEY_COLUMN processing (states 320 - 339) ****
3551: elsif (l_state = 320) then

Line 3565: raise FND_API.G_EXC_ERROR;

3561: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3562: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPLICATION_ID');
3563: FND_MSG_PUB.Add;
3564: end if;
3565: raise FND_API.G_EXC_ERROR;
3566: end if;
3567: elsif (l_state = 321) then
3568: if (l_token is not null) then
3569: l_foreign_key_column_rec.attribute_code := l_token;

Line 3580: raise FND_API.G_EXC_ERROR;

3576: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3577: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');
3578: FND_MSG_PUB.Add;
3579: end if;
3580: raise FND_API.G_EXC_ERROR;
3581: end if;
3582: elsif (l_state = 330) then
3583: if (l_token = 'END') then
3584: l_state := 339;

Line 3637: raise FND_API.G_EXC_ERROR;

3633: end if;
3634: FND_MESSAGE.SET_TOKEN('EXPECTED','FOREIGN_KEY_COLUMN');
3635: FND_MSG_PUB.Add;
3636: end if;
3637: raise FND_API.G_EXC_ERROR;
3638: end if;
3639: end if;
3640: elsif (l_state = 331) then
3641: if (l_token = '=') then

Line 3651: raise FND_API.G_EXC_ERROR;

3647: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3648: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
3649: FND_MSG_PUB.Add;
3650: end if;
3651: raise FND_API.G_EXC_ERROR;
3652: end if;
3653: elsif (l_state = 332) then
3654: l_value_count := 1;
3655: if (l_column = 'FOREIGN_KEY_SEQUENCE') then

Line 3711: raise FND_API.G_EXC_ERROR;

3707: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3708: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
3709: FND_MSG_PUB.Add;
3710: end if;
3711: raise FND_API.G_EXC_ERROR;
3712: end if;
3713: l_state := 330;
3714: elsif (l_state = 339) then
3715: if (l_token = 'FOREIGN_KEY_COLUMN') then

Line 3732: raise FND_API.G_EXC_ERROR;

3728: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3729: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FOREIGN_KEY_COLUMN');
3730: FND_MSG_PUB.Add;
3731: end if;
3732: raise FND_API.G_EXC_ERROR;
3733: end if;
3734:
3735: end if; /* if l_state = ... */
3736:

Line 3752: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

3748: p_lines_read => l_lines_read,
3749: p_eof_flag => l_eof_flag,
3750: p_upl_loader_cur => p_upl_loader_cur
3751: );
3752: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
3753: (l_return_status = FND_API.G_RET_STS_ERROR) then
3754: RAISE FND_API.G_EXC_ERROR;
3755: end if;
3756: l_line_num := l_line_num + l_lines_read;

Line 3753: (l_return_status = FND_API.G_RET_STS_ERROR) then

3749: p_eof_flag => l_eof_flag,
3750: p_upl_loader_cur => p_upl_loader_cur
3751: );
3752: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
3753: (l_return_status = FND_API.G_RET_STS_ERROR) then
3754: RAISE FND_API.G_EXC_ERROR;
3755: end if;
3756: l_line_num := l_line_num + l_lines_read;
3757: --

Line 3754: RAISE FND_API.G_EXC_ERROR;

3750: p_upl_loader_cur => p_upl_loader_cur
3751: );
3752: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
3753: (l_return_status = FND_API.G_RET_STS_ERROR) then
3754: RAISE FND_API.G_EXC_ERROR;
3755: end if;
3756: l_line_num := l_line_num + l_lines_read;
3757: --
3758: -- trim leading spaces and discard comment lines

Line 3782: raise FND_API.G_EXC_ERROR;

3778: FND_MESSAGE.SET_TOKEN('TOKEN','END OF FILE');
3779: FND_MESSAGE.SET_TOKEN('EXPECTED',null);
3780: FND_MSG_PUB.Add;
3781: end if;
3782: raise FND_API.G_EXC_ERROR;
3783: end if;
3784:
3785: --
3786: -- Insert or update all objects to the database

Line 3961: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

3957: );
3958: end if; -- /* if OBJECT_EXISTS */
3959: --
3960: -- If API call returns with an error status, upload aborts
3961: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
3962: (l_return_status = FND_API.G_RET_STS_ERROR) then
3963: RAISE FND_API.G_EXC_ERROR;
3964: end if; -- /* if l_return_status */
3965: --

Line 3962: (l_return_status = FND_API.G_RET_STS_ERROR) then

3958: end if; -- /* if OBJECT_EXISTS */
3959: --
3960: -- If API call returns with an error status, upload aborts
3961: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
3962: (l_return_status = FND_API.G_RET_STS_ERROR) then
3963: RAISE FND_API.G_EXC_ERROR;
3964: end if; -- /* if l_return_status */
3965: --
3966: -- if validation fails, then this record should go to second pass

Line 3963: RAISE FND_API.G_EXC_ERROR;

3959: --
3960: -- If API call returns with an error status, upload aborts
3961: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
3962: (l_return_status = FND_API.G_RET_STS_ERROR) then
3963: RAISE FND_API.G_EXC_ERROR;
3964: end if; -- /* if l_return_status */
3965: --
3966: -- if validation fails, then this record should go to second pass
3967: if (l_copy_redo_flag) then

Line 4274: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

4270: );
4271: end if; -- /* if ATTRIBUTE_EXISTS */
4272: --
4273: -- If API call returns with an error status, upload aborts
4274: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
4275: (l_return_status = FND_API.G_RET_STS_ERROR) then
4276: RAISE FND_API.G_EXC_ERROR;
4277: end if; -- /* if l_return_status */
4278: --

Line 4275: (l_return_status = FND_API.G_RET_STS_ERROR) then

4271: end if; -- /* if ATTRIBUTE_EXISTS */
4272: --
4273: -- If API call returns with an error status, upload aborts
4274: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
4275: (l_return_status = FND_API.G_RET_STS_ERROR) then
4276: RAISE FND_API.G_EXC_ERROR;
4277: end if; -- /* if l_return_status */
4278: --
4279: -- if validation fails, then this record should go to second pass

Line 4276: RAISE FND_API.G_EXC_ERROR;

4272: --
4273: -- If API call returns with an error status, upload aborts
4274: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
4275: (l_return_status = FND_API.G_RET_STS_ERROR) then
4276: RAISE FND_API.G_EXC_ERROR;
4277: end if; -- /* if l_return_status */
4278: --
4279: -- if validation fails, then this record should go to second pass
4280: if (l_copy_redo_flag) then

Line 4462: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

4458: );
4459: end if; -- /* if ATTRIBUTE_NAVIGATION_EXISTS */
4460: --
4461: -- If API call returns with an error status, upload aborts
4462: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
4463: (l_return_status = FND_API.G_RET_STS_ERROR) then
4464: RAISE FND_API.G_EXC_ERROR;
4465: end if; -- /* if l_return_status */
4466: --

Line 4463: (l_return_status = FND_API.G_RET_STS_ERROR) then

4459: end if; -- /* if ATTRIBUTE_NAVIGATION_EXISTS */
4460: --
4461: -- If API call returns with an error status, upload aborts
4462: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
4463: (l_return_status = FND_API.G_RET_STS_ERROR) then
4464: RAISE FND_API.G_EXC_ERROR;
4465: end if; -- /* if l_return_status */
4466: --
4467: -- if validation fails, then this record should go to second pass

Line 4464: RAISE FND_API.G_EXC_ERROR;

4460: --
4461: -- If API call returns with an error status, upload aborts
4462: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
4463: (l_return_status = FND_API.G_RET_STS_ERROR) then
4464: RAISE FND_API.G_EXC_ERROR;
4465: end if; -- /* if l_return_status */
4466: --
4467: -- if validation fails, then this record should go to second pass
4468: if (l_copy_redo_flag) then

Line 4572: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

4568: p_loader_timestamp => p_loader_timestamp);
4569: end if; -- /* if ATTRIBUTE_VALUE_EXISTS */
4570: --
4571: -- If API call returns with an error status, upload aborts
4572: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
4573: (l_return_status = FND_API.G_RET_STS_ERROR) then
4574: RAISE FND_API.G_EXC_ERROR;
4575: end if; -- /* if l_return_status */
4576: end if;

Line 4573: (l_return_status = FND_API.G_RET_STS_ERROR) then

4569: end if; -- /* if ATTRIBUTE_VALUE_EXISTS */
4570: --
4571: -- If API call returns with an error status, upload aborts
4572: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
4573: (l_return_status = FND_API.G_RET_STS_ERROR) then
4574: RAISE FND_API.G_EXC_ERROR;
4575: end if; -- /* if l_return_status */
4576: end if;
4577: end loop;

Line 4574: RAISE FND_API.G_EXC_ERROR;

4570: --
4571: -- If API call returns with an error status, upload aborts
4572: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
4573: (l_return_status = FND_API.G_RET_STS_ERROR) then
4574: RAISE FND_API.G_EXC_ERROR;
4575: end if; -- /* if l_return_status */
4576: end if;
4577: end loop;
4578: end if;

Line 4752: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

4748: );
4749: end if; -- /* if UNIQUE_KEY_EXISTS */
4750: --
4751: -- If API call returns with an error status, upload aborts
4752: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
4753: (l_return_status = FND_API.G_RET_STS_ERROR) then
4754: RAISE FND_API.G_EXC_ERROR;
4755: end if; -- /* if l_return_status */
4756: --

Line 4753: (l_return_status = FND_API.G_RET_STS_ERROR) then

4749: end if; -- /* if UNIQUE_KEY_EXISTS */
4750: --
4751: -- If API call returns with an error status, upload aborts
4752: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
4753: (l_return_status = FND_API.G_RET_STS_ERROR) then
4754: RAISE FND_API.G_EXC_ERROR;
4755: end if; -- /* if l_return_status */
4756: --
4757: -- if validation fails, then this record should go to second pass

Line 4754: RAISE FND_API.G_EXC_ERROR;

4750: --
4751: -- If API call returns with an error status, upload aborts
4752: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
4753: (l_return_status = FND_API.G_RET_STS_ERROR) then
4754: RAISE FND_API.G_EXC_ERROR;
4755: end if; -- /* if l_return_status */
4756: --
4757: -- if validation fails, then this record should go to second pass
4758: if (l_copy_redo_flag) then

Line 4928: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

4924: );
4925: end if; -- /* if UNIQUE_KEY_COLUMN_EXISTS */
4926: --
4927: -- If API call returns with an error status, upload aborts
4928: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
4929: (l_return_status = FND_API.G_RET_STS_ERROR) then
4930: RAISE FND_API.G_EXC_ERROR;
4931: end if; -- /* if l_return_status */
4932: --

Line 4929: (l_return_status = FND_API.G_RET_STS_ERROR) then

4925: end if; -- /* if UNIQUE_KEY_COLUMN_EXISTS */
4926: --
4927: -- If API call returns with an error status, upload aborts
4928: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
4929: (l_return_status = FND_API.G_RET_STS_ERROR) then
4930: RAISE FND_API.G_EXC_ERROR;
4931: end if; -- /* if l_return_status */
4932: --
4933: -- if validation fails, then this record should go to second pass

Line 4930: RAISE FND_API.G_EXC_ERROR;

4926: --
4927: -- If API call returns with an error status, upload aborts
4928: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
4929: (l_return_status = FND_API.G_RET_STS_ERROR) then
4930: RAISE FND_API.G_EXC_ERROR;
4931: end if; -- /* if l_return_status */
4932: --
4933: -- if validation fails, then this record should go to second pass
4934: if (l_copy_redo_flag) then

Line 5156: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

5152: );
5153: end if; -- /* if FOREIGN_KEY_EXISTS */
5154: --
5155: -- If API call returns with an error status, upload aborts
5156: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
5157: (l_return_status = FND_API.G_RET_STS_ERROR) then
5158: RAISE FND_API.G_EXC_ERROR;
5159: end if; -- /* if l_return_status */
5160: --

Line 5157: (l_return_status = FND_API.G_RET_STS_ERROR) then

5153: end if; -- /* if FOREIGN_KEY_EXISTS */
5154: --
5155: -- If API call returns with an error status, upload aborts
5156: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
5157: (l_return_status = FND_API.G_RET_STS_ERROR) then
5158: RAISE FND_API.G_EXC_ERROR;
5159: end if; -- /* if l_return_status */
5160: --
5161: -- if validation fails, then this record should go to second pass

Line 5158: RAISE FND_API.G_EXC_ERROR;

5154: --
5155: -- If API call returns with an error status, upload aborts
5156: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
5157: (l_return_status = FND_API.G_RET_STS_ERROR) then
5158: RAISE FND_API.G_EXC_ERROR;
5159: end if; -- /* if l_return_status */
5160: --
5161: -- if validation fails, then this record should go to second pass
5162: if (l_copy_redo_flag) then

Line 5334: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

5330: );
5331: end if; -- /* if FOREIGN_KEY_COLUMN_EXISTS */
5332: --
5333: -- If API call returns with an error status, upload aborts
5334: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
5335: (l_return_status = FND_API.G_RET_STS_ERROR) then
5336: RAISE FND_API.G_EXC_ERROR;
5337: end if; -- /* if l_return_status */
5338: --

Line 5335: (l_return_status = FND_API.G_RET_STS_ERROR) then

5331: end if; -- /* if FOREIGN_KEY_COLUMN_EXISTS */
5332: --
5333: -- If API call returns with an error status, upload aborts
5334: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
5335: (l_return_status = FND_API.G_RET_STS_ERROR) then
5336: RAISE FND_API.G_EXC_ERROR;
5337: end if; -- /* if l_return_status */
5338: --
5339: -- if validation fails, then this record should go to second pass

Line 5336: RAISE FND_API.G_EXC_ERROR;

5332: --
5333: -- If API call returns with an error status, upload aborts
5334: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
5335: (l_return_status = FND_API.G_RET_STS_ERROR) then
5336: RAISE FND_API.G_EXC_ERROR;
5337: end if; -- /* if l_return_status */
5338: --
5339: -- if validation fails, then this record should go to second pass
5340: if (l_copy_redo_flag) then

Line 5353: p_return_status := FND_API.G_RET_STS_SUCCESS;

5349: -- Load line number of the last file line processed
5350: --
5351: p_line_num_out := l_line_num;
5352:
5353: p_return_status := FND_API.G_RET_STS_SUCCESS;
5354:
5355: -- dbms_output.put_line('Leaving object upload: ' ||
5356: -- to_char(sysdate, 'MON-DD HH24:MI:SS'));
5357:

Line 5361: WHEN FND_API.G_EXC_ERROR THEN

5357:
5358:
5359:
5360: EXCEPTION
5361: WHEN FND_API.G_EXC_ERROR THEN
5362: p_return_status := FND_API.G_RET_STS_ERROR;
5363: WHEN VALUE_ERROR THEN
5364: p_return_status := FND_API.G_RET_STS_ERROR;
5365: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_VALUE_ERROR');

Line 5362: p_return_status := FND_API.G_RET_STS_ERROR;

5358:
5359:
5360: EXCEPTION
5361: WHEN FND_API.G_EXC_ERROR THEN
5362: p_return_status := FND_API.G_RET_STS_ERROR;
5363: WHEN VALUE_ERROR THEN
5364: p_return_status := FND_API.G_RET_STS_ERROR;
5365: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_VALUE_ERROR');
5366: FND_MESSAGE.SET_TOKEN('KEY',l_object_rec.database_object_name);

Line 5364: p_return_status := FND_API.G_RET_STS_ERROR;

5360: EXCEPTION
5361: WHEN FND_API.G_EXC_ERROR THEN
5362: p_return_status := FND_API.G_RET_STS_ERROR;
5363: WHEN VALUE_ERROR THEN
5364: p_return_status := FND_API.G_RET_STS_ERROR;
5365: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_VALUE_ERROR');
5366: FND_MESSAGE.SET_TOKEN('KEY',l_object_rec.database_object_name);
5367: FND_MSG_PUB.Add;
5368: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

Line 5372: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5368: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5369: SUBSTR (SQLERRM, 1, 240)||': '||l_column||'='||l_token );
5370: FND_MSG_PUB.Add;
5371: WHEN OTHERS THEN
5372: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5373: --dbms_output.put_line('UPLOAD_OBJECT l_line_num '||to_char(l_line_num));
5374: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5375: SUBSTR (SQLERRM, 1, 240) );
5376: FND_MSG_PUB.Add;