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

Line 52: x_return_status := FND_API.G_RET_STS_SUCCESS;

48: l_new_msg_data VARCHAR2(2000);
49: -- added for bug: 4537865
50:
51: BEGIN
52: x_return_status := FND_API.G_RET_STS_SUCCESS;
53:
54: -- Get value map definition type.
55: SELECT value_map_def_type
56: INTO l_value_map_def_type

Line 92: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

88: debug('l_id = '|| l_id);
89: debug('x_return_status = '|| x_return_status);
90:
91: -- Raise the error if the id/name validation is failed.
92: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
93: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
94: ,p_msg_name => x_msg_data);
95: RAISE FND_API.G_EXC_ERROR;
96: -- Put the validated mapping data in a local pl/sql table.

Line 95: RAISE FND_API.G_EXC_ERROR;

91: -- Raise the error if the id/name validation is failed.
92: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
93: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
94: ,p_msg_name => x_msg_data);
95: RAISE FND_API.G_EXC_ERROR;
96: -- Put the validated mapping data in a local pl/sql table.
97: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
98: l_source_value_arr(v_1) := p_source_value_arr(j);
99: l_dest_value_arr(v_1) := p_dest_value_arr(j);

Line 97: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

93: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
94: ,p_msg_name => x_msg_data);
95: RAISE FND_API.G_EXC_ERROR;
96: -- Put the validated mapping data in a local pl/sql table.
97: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
98: l_source_value_arr(v_1) := p_source_value_arr(j);
99: l_dest_value_arr(v_1) := p_dest_value_arr(j);
100: l_source_value_pk1_arr(v_1) := p_source_value_pk1_arr(j);
101: l_source_value_pk2_arr(v_1) := p_source_value_pk2_arr(j);

Line 115: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

111: END IF;
112: END IF;
113: END LOOP;
114:
115: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
116: -- Update record version number in header table PA_VALUE_MAP_DEFS.
117: PA_VALUE_MAP_DEF_PKG.update_row(p_value_map_def_id => p_value_map_def_id,
118: p_record_version_number => p_record_version_number,
119: x_return_status => x_return_status,

Line 126: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

122: debug('After update_row');
123: END IF;
124:
125: -- Delete all the value map records identified by p_value_map_def_id.
126: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
127: debug('Before delete_rows');
128: PA_VALUE_MAPS_PKG.delete_rows(p_value_map_def_id => p_value_map_def_id,
129: p_value_map_def_type => l_value_map_def_type,
130: p_probability_list_id => p_probability_list_id,

Line 138: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

134: debug('After delete_rows');
135: END IF;
136:
137: -- Insert the new value map records.
138: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
139: debug('l_dest_value_arr.COUNT = '||l_dest_value_arr.COUNT);
140: IF l_dest_value_arr.COUNT > 0 THEN
141: debug('Before insert_rows');
142: PA_VALUE_MAPS_PKG.insert_rows (

Line 164: WHEN FND_API.G_EXC_ERROR THEN

160: debug('After insert_rows');
161: END IF;
162:
163: EXCEPTION
164: WHEN FND_API.G_EXC_ERROR THEN
165: x_return_status := FND_API.G_RET_STS_ERROR;
166: x_msg_count := FND_MSG_PUB.Count_Msg;
167: IF x_msg_count = 1 THEN
168: pa_interface_utils_pub.get_messages

Line 165: x_return_status := FND_API.G_RET_STS_ERROR;

161: END IF;
162:
163: EXCEPTION
164: WHEN FND_API.G_EXC_ERROR THEN
165: x_return_status := FND_API.G_RET_STS_ERROR;
166: x_msg_count := FND_MSG_PUB.Count_Msg;
167: IF x_msg_count = 1 THEN
168: pa_interface_utils_pub.get_messages
169: (p_encoded => FND_API.G_TRUE,

Line 169: (p_encoded => FND_API.G_TRUE,

165: x_return_status := FND_API.G_RET_STS_ERROR;
166: x_msg_count := FND_MSG_PUB.Count_Msg;
167: IF x_msg_count = 1 THEN
168: pa_interface_utils_pub.get_messages
169: (p_encoded => FND_API.G_TRUE,
170: p_msg_index => 1,
171: p_msg_count => x_msg_count,
172: p_msg_data => x_msg_data,
173: -- p_data => x_msg_data, * Commented for Bug: 4537865

Line 181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

177: x_msg_data := l_new_msg_data;
178: -- added for bug: 4537865
179: END IF;
180: WHEN OTHERS THEN
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_MAPPING_PVT',
183: p_procedure_name => 'save_value_maps');
184: raise;
185:

Line 236: x_return_status := FND_API.G_RET_STS_SUCCESS;

232: OR map.source_value_pk5 IS NULL);
233:
234:
235: BEGIN
236: x_return_status := FND_API.G_RET_STS_SUCCESS;
237:
238: x_dest_value := NULL;
239: x_dest_value_pk1 := NULL;
240: x_dest_value_pk2 := NULL;

Line 271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

267:
268:
269: EXCEPTION
270: WHEN OTHERS THEN
271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
272: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_MAPPING_PVT',
273: p_procedure_name => 'get_dest_values');
274: raise;
275: