eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_MC_PATH_POSITION_PUB dependencies on FND_API

Line 28: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

24: -- End of Comments
25: -------------------------------------------------------------------------------------------
26: PROCEDURE Create_Position_ID (
27: p_api_version IN NUMBER,
28: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
29: p_commit IN VARCHAR2 := FND_API.G_FALSE,
30: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
31: p_path_position_tbl IN AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type,
32: p_position_ref_meaning IN VARCHAR2,

Line 29: p_commit IN VARCHAR2 := FND_API.G_FALSE,

25: -------------------------------------------------------------------------------------------
26: PROCEDURE Create_Position_ID (
27: p_api_version IN NUMBER,
28: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
29: p_commit IN VARCHAR2 := FND_API.G_FALSE,
30: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
31: p_path_position_tbl IN AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type,
32: p_position_ref_meaning IN VARCHAR2,
33: p_position_ref_code IN VARCHAR2,

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

26: PROCEDURE Create_Position_ID (
27: p_api_version IN NUMBER,
28: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
29: p_commit IN VARCHAR2 := FND_API.G_FALSE,
30: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
31: p_path_position_tbl IN AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type,
32: p_position_ref_meaning IN VARCHAR2,
33: p_position_ref_code IN VARCHAR2,
34: x_position_id OUT NOCOPY NUMBER,

Line 57: x_return_status := FND_API.G_RET_STS_SUCCESS;

53: -- Standard start of API savepoint
54: SAVEPOINT Create_Position_ID_Pub;
55:
56: -- Initialize Procedure return status to success
57: x_return_status := FND_API.G_RET_STS_SUCCESS;
58:
59: -- Standard call to check for call compatibility
60: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
61: l_api_name, G_PKG_NAME) THEN

Line 60: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

56: -- Initialize Procedure return status to success
57: x_return_status := FND_API.G_RET_STS_SUCCESS;
58:
59: -- Standard call to check for call compatibility
60: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
61: l_api_name, G_PKG_NAME) THEN
62: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
63: END IF;
64:

Line 62: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

58:
59: -- Standard call to check for call compatibility
60: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
61: l_api_name, G_PKG_NAME) THEN
62: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
63: END IF;
64:
65: -- Initialize message list if p_init_msg_list is set to TRUE
66: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 66: IF FND_API.To_Boolean(p_init_msg_list) THEN

62: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
63: END IF;
64:
65: -- Initialize message list if p_init_msg_list is set to TRUE
66: IF FND_API.To_Boolean(p_init_msg_list) THEN
67: FND_MSG_PUB.Initialize;
68: END IF;
69:
70: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 80: RAISE FND_API.G_EXC_ERROR;

76: IF (p_path_position_tbl.COUNT < 1) THEN
77: -- input is NULL
78: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PATH_POS_TBL_NULL');
79: FND_MSG_PUB.ADD;
80: RAISE FND_API.G_EXC_ERROR;
81: END IF;
82:
83: -- call Convert_Path_Pos_Values_to_Id
84: Convert_Path_Pos_Values_to_Id(l_path_position_tbl);

Line 94: p_commit => FND_API.G_FALSE, -- Pass false and commit at the end if needed

90: -- call the private API
91: AHL_MC_PATH_POSITION_PVT.Create_Position_ID(
92: p_api_version => p_api_version,
93: p_init_msg_list => p_init_msg_list,
94: p_commit => FND_API.G_FALSE, -- Pass false and commit at the end if needed
95: p_validation_level => p_validation_level,
96: p_path_position_tbl => l_path_position_tbl,
97: p_position_ref_meaning => FND_API.G_MISS_CHAR, -- This Public API is not to be used for copying. Hence passing G_MISS
98: p_position_ref_code => FND_API.G_MISS_CHAR, -- This Public API is not to be used for copying. Hence passing G_MISS

Line 97: p_position_ref_meaning => FND_API.G_MISS_CHAR, -- This Public API is not to be used for copying. Hence passing G_MISS

93: p_init_msg_list => p_init_msg_list,
94: p_commit => FND_API.G_FALSE, -- Pass false and commit at the end if needed
95: p_validation_level => p_validation_level,
96: p_path_position_tbl => l_path_position_tbl,
97: p_position_ref_meaning => FND_API.G_MISS_CHAR, -- This Public API is not to be used for copying. Hence passing G_MISS
98: p_position_ref_code => FND_API.G_MISS_CHAR, -- This Public API is not to be used for copying. Hence passing G_MISS
99: x_position_id => x_position_id,
100: x_return_status => x_return_status,
101: x_msg_count => x_msg_count,

Line 98: p_position_ref_code => FND_API.G_MISS_CHAR, -- This Public API is not to be used for copying. Hence passing G_MISS

94: p_commit => FND_API.G_FALSE, -- Pass false and commit at the end if needed
95: p_validation_level => p_validation_level,
96: p_path_position_tbl => l_path_position_tbl,
97: p_position_ref_meaning => FND_API.G_MISS_CHAR, -- This Public API is not to be used for copying. Hence passing G_MISS
98: p_position_ref_code => FND_API.G_MISS_CHAR, -- This Public API is not to be used for copying. Hence passing G_MISS
99: x_position_id => x_position_id,
100: x_return_status => x_return_status,
101: x_msg_count => x_msg_count,
102: x_msg_data => x_msg_data

Line 106: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

102: x_msg_data => x_msg_data
103: );
104:
105: -- check for the return status
106: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
107: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
108: FND_LOG.string(FND_LOG.level_statement, l_full_name,
109: 'Raising exception with x_return_status = ' || x_return_status);
110: END IF;

Line 111: RAISE FND_API.G_EXC_ERROR;

107: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
108: FND_LOG.string(FND_LOG.level_statement, l_full_name,
109: 'Raising exception with x_return_status = ' || x_return_status);
110: END IF;
111: RAISE FND_API.G_EXC_ERROR;
112: END IF;
113:
114: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
115: FND_LOG.string(FND_LOG.level_statement, l_full_name, 'AHL_MC_PATH_POSITION_PVT.Create_Position_ID returned x_return_status as ' || x_return_status);

Line 119: IF FND_API.TO_BOOLEAN(p_commit) THEN

115: FND_LOG.string(FND_LOG.level_statement, l_full_name, 'AHL_MC_PATH_POSITION_PVT.Create_Position_ID returned x_return_status as ' || x_return_status);
116: END IF;
117:
118: -- Standard check of p_commit
119: IF FND_API.TO_BOOLEAN(p_commit) THEN
120: COMMIT WORK;
121: END IF;
122:
123: -- Standard call to get message count and if count is 1, get message info

Line 127: p_encoded => FND_API.G_FALSE

123: -- Standard call to get message count and if count is 1, get message info
124: FND_MSG_PUB.Count_And_Get
125: ( p_count => x_msg_count,
126: p_data => x_msg_data,
127: p_encoded => FND_API.G_FALSE
128: );
129:
130: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
131: FND_LOG.string(FND_LOG.level_procedure, l_full_name || '.end', 'End of the API');

Line 135: WHEN FND_API.G_EXC_ERROR THEN

131: FND_LOG.string(FND_LOG.level_procedure, l_full_name || '.end', 'End of the API');
132: END IF;
133:
134: EXCEPTION
135: WHEN FND_API.G_EXC_ERROR THEN
136: Rollback to Create_Position_ID_Pub;
137: x_return_status := FND_API.G_RET_STS_ERROR;
138: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
139: p_data => x_msg_data,

Line 137: x_return_status := FND_API.G_RET_STS_ERROR;

133:
134: EXCEPTION
135: WHEN FND_API.G_EXC_ERROR THEN
136: Rollback to Create_Position_ID_Pub;
137: x_return_status := FND_API.G_RET_STS_ERROR;
138: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
139: p_data => x_msg_data,
140: p_encoded => fnd_api.g_false);
141:

Line 140: p_encoded => fnd_api.g_false);

136: Rollback to Create_Position_ID_Pub;
137: x_return_status := FND_API.G_RET_STS_ERROR;
138: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
139: p_data => x_msg_data,
140: p_encoded => fnd_api.g_false);
141:
142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
143: Rollback to Create_Position_ID_Pub;
144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

138: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
139: p_data => x_msg_data,
140: p_encoded => fnd_api.g_false);
141:
142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
143: Rollback to Create_Position_ID_Pub;
144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
145: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
146: p_data => x_msg_data,

Line 144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

140: p_encoded => fnd_api.g_false);
141:
142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
143: Rollback to Create_Position_ID_Pub;
144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
145: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
146: p_data => x_msg_data,
147: p_encoded => fnd_api.g_false);
148:

Line 147: p_encoded => fnd_api.g_false);

143: Rollback to Create_Position_ID_Pub;
144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
145: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
146: p_data => x_msg_data,
147: p_encoded => fnd_api.g_false);
148:
149: WHEN OTHERS THEN
150: Rollback to Create_Position_ID_Pub;
151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

147: p_encoded => fnd_api.g_false);
148:
149: WHEN OTHERS THEN
150: Rollback to Create_Position_ID_Pub;
151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
152: FND_MSG_PUB.Add_Exc_Msg( p_pkg_name => G_PKG_NAME,
153: p_procedure_name => l_api_name,
154: p_error_text => SQLERRM);
155: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 157: p_encoded => FND_API.G_FALSE);

153: p_procedure_name => l_api_name,
154: p_error_text => SQLERRM);
155: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
156: p_data => x_msg_data,
157: p_encoded => FND_API.G_FALSE);
158:
159: END Create_Position_ID;
160:
161: -----------------------------------------------------------------------------------------------

Line 318: RAISE FND_API.G_EXC_ERROR;

314: END IF;
315:
316: -- raise the exception if some error occurred
317: IF (l_validation_failed_flag = 'Y') THEN
318: RAISE FND_API.G_EXC_ERROR;
319: END IF;
320: END LOOP;
321:
322: -- return changed record