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

Line 23: p_commit IN VARCHAR2 := fnd_api.g_false,

19: --+=================================================================+
20:
21: PROCEDURE create_location(
22: p_api_version IN NUMBER ,
23: p_commit IN VARCHAR2 := fnd_api.g_false,
24: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
25: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
26: p_country IN VARCHAR2,
27: p_address1 IN VARCHAR2,

Line 24: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

20:
21: PROCEDURE create_location(
22: p_api_version IN NUMBER ,
23: p_commit IN VARCHAR2 := fnd_api.g_false,
24: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
25: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
26: p_country IN VARCHAR2,
27: p_address1 IN VARCHAR2,
28: p_address2 IN VARCHAR2,

Line 25: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

21: PROCEDURE create_location(
22: p_api_version IN NUMBER ,
23: p_commit IN VARCHAR2 := fnd_api.g_false,
24: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
25: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
26: p_country IN VARCHAR2,
27: p_address1 IN VARCHAR2,
28: p_address2 IN VARCHAR2,
29: p_address3 IN VARCHAR2,

Line 59: IF NOT fnd_api.compatible_api_call ( l_api_version,

55: BEGIN
56: SAVEPOINT create_location_pvt;
57:
58: -- standard call to check for call compatibility.
59: IF NOT fnd_api.compatible_api_call ( l_api_version,
60: p_api_version,
61: l_api_name,
62: g_pkg_name)
63: THEN

Line 64: RAISE fnd_api.g_exc_unexpected_error;

60: p_api_version,
61: l_api_name,
62: g_pkg_name)
63: THEN
64: RAISE fnd_api.g_exc_unexpected_error;
65: END IF;
66:
67:
68: -- initialize message list if p_init_msg_list is set to true.

Line 69: IF fnd_api.to_boolean( p_init_msg_list )

65: END IF;
66:
67:
68: -- initialize message list if p_init_msg_list is set to true.
69: IF fnd_api.to_boolean( p_init_msg_list )
70: THEN
71: fnd_msg_pub.initialize;
72: END IF;
73:

Line 75: x_return_status := fnd_api.g_ret_sts_success;

71: fnd_msg_pub.initialize;
72: END IF;
73:
74: -- initialize api return status to success
75: x_return_status := fnd_api.g_ret_sts_success;
76:
77: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
78: -- if debug_level = 1 then dump the procedure name
79: IF (l_debug_level > 0) THEN

Line 122: l_location_rec.clli_code <> FND_API.G_MISS_CHAR THEN

118:
119: -- Now call the stored program
120:
121: IF l_location_rec.clli_code IS NOT NULL AND
122: l_location_rec.clli_code <> FND_API.G_MISS_CHAR THEN
123: BEGIN
124: SELECT 'x'
125: INTO l_dummy
126: FROM hz_locations

Line 132: RAISE fnd_api.g_exc_error;

128:
129: fnd_message.set_name('CSI', 'CSI_DUPLICATE_CLLI_CODE');
130: fnd_message.set_token('PARAMETER',l_location_rec.clli_code);
131: fnd_msg_pub.add;
132: RAISE fnd_api.g_exc_error;
133: EXCEPTION
134: WHEN TOO_MANY_ROWS THEN
135: fnd_message.set_name('CSI', 'CSI_DUPLICATE_CLLI_CODE');
136: fnd_message.set_token('PARAMETER',l_location_rec.clli_code);

Line 138: RAISE fnd_api.g_exc_error;

134: WHEN TOO_MANY_ROWS THEN
135: fnd_message.set_name('CSI', 'CSI_DUPLICATE_CLLI_CODE');
136: fnd_message.set_token('PARAMETER',l_location_rec.clli_code);
137: fnd_msg_pub.add;
138: RAISE fnd_api.g_exc_error;
139: WHEN NO_DATA_FOUND THEN
140: NULL;
141: END;
142: END IF;

Line 151: IF fnd_api.to_boolean( p_commit )

147: ,x_return_status => x_return_status
148: ,x_msg_count => x_msg_count
149: ,x_msg_data => x_msg_data);
150:
151: IF fnd_api.to_boolean( p_commit )
152: THEN
153: COMMIT WORK;
154: END IF;
155:

Line 163: WHEN fnd_api.g_exc_error THEN

159: p_data => x_msg_data
160: );
161:
162: EXCEPTION
163: WHEN fnd_api.g_exc_error THEN
164: ROLLBACK TO create_location_pvt;
165: x_return_status := fnd_api.g_ret_sts_error ;
166: fnd_msg_pub.count_and_get
167: (p_count => x_msg_count ,

Line 165: x_return_status := fnd_api.g_ret_sts_error ;

161:
162: EXCEPTION
163: WHEN fnd_api.g_exc_error THEN
164: ROLLBACK TO create_location_pvt;
165: x_return_status := fnd_api.g_ret_sts_error ;
166: fnd_msg_pub.count_and_get
167: (p_count => x_msg_count ,
168: p_data => x_msg_data
169: );

Line 181: p_commit IN VARCHAR2 := fnd_api.g_false,

177: --+=================================================================+
178:
179: PROCEDURE update_location(
180: p_api_version IN NUMBER,
181: p_commit IN VARCHAR2 := fnd_api.g_false,
182: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
183: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
184: p_location_id IN NUMBER,
185: p_country IN VARCHAR2,

Line 182: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

178:
179: PROCEDURE update_location(
180: p_api_version IN NUMBER,
181: p_commit IN VARCHAR2 := fnd_api.g_false,
182: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
183: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
184: p_location_id IN NUMBER,
185: p_country IN VARCHAR2,
186: p_address1 IN VARCHAR2,

Line 183: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

179: PROCEDURE update_location(
180: p_api_version IN NUMBER,
181: p_commit IN VARCHAR2 := fnd_api.g_false,
182: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
183: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
184: p_location_id IN NUMBER,
185: p_country IN VARCHAR2,
186: p_address1 IN VARCHAR2,
187: p_address2 IN VARCHAR2,

Line 218: IF NOT fnd_api.compatible_api_call ( l_api_version,

214:
215: SAVEPOINT update_location_pvt;
216:
217: -- standard call TO check FOR call compatibility.
218: IF NOT fnd_api.compatible_api_call ( l_api_version,
219: p_api_version,
220: l_api_name,
221: g_pkg_name)
222: THEN

Line 223: RAISE fnd_api.g_exc_unexpected_error;

219: p_api_version,
220: l_api_name,
221: g_pkg_name)
222: THEN
223: RAISE fnd_api.g_exc_unexpected_error;
224: END IF;
225:
226:
227: -- initialize message list IF p_init_msg_list IS set TO true.

Line 228: IF fnd_api.to_boolean( p_init_msg_list )

224: END IF;
225:
226:
227: -- initialize message list IF p_init_msg_list IS set TO true.
228: IF fnd_api.to_boolean( p_init_msg_list )
229: THEN
230: fnd_msg_pub.initialize;
231: END IF;
232:

Line 234: x_return_status := fnd_api.g_ret_sts_success;

230: fnd_msg_pub.initialize;
231: END IF;
232:
233: -- initialize api return status to success
234: x_return_status := fnd_api.g_ret_sts_success;
235:
236: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
237: -- if debug_level = 1 then dump the procedure name
238: IF (l_debug_level > 0) THEN

Line 285: p_location_id = FND_API.G_MISS_NUM THEN

281:
282:
283:
284: IF p_location_id IS NULL OR
285: p_location_id = FND_API.G_MISS_NUM THEN
286: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
287: FND_MESSAGE.SET_TOKEN('COLUMN', 'location id');
288: FND_MSG_PUB.ADD;
289: RAISE FND_API.G_EXC_ERROR;

Line 289: RAISE FND_API.G_EXC_ERROR;

285: p_location_id = FND_API.G_MISS_NUM THEN
286: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
287: FND_MESSAGE.SET_TOKEN('COLUMN', 'location id');
288: FND_MSG_PUB.ADD;
289: RAISE FND_API.G_EXC_ERROR;
290: END IF;
291:
292: BEGIN
293: SELECT object_version_number

Line 303: RAISE FND_API.G_EXC_ERROR;

299: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
300: FND_MESSAGE.SET_TOKEN('RECORD', 'location');
301: FND_MESSAGE.SET_TOKEN('VALUE', to_char(l_location_rec.location_id));
302: FND_MSG_PUB.ADD;
303: RAISE FND_API.G_EXC_ERROR;
304: END;
305:
306: IF l_location_rec.clli_code IS NOT NULL AND
307: l_location_rec.clli_code <> FND_API.G_MISS_CHAR THEN

Line 307: l_location_rec.clli_code <> FND_API.G_MISS_CHAR THEN

303: RAISE FND_API.G_EXC_ERROR;
304: END;
305:
306: IF l_location_rec.clli_code IS NOT NULL AND
307: l_location_rec.clli_code <> FND_API.G_MISS_CHAR THEN
308: BEGIN
309: SELECT 'x'
310: INTO l_dummy
311: FROM hz_locations

Line 317: RAISE fnd_api.g_exc_error;

313: AND location_id <> l_location_rec.location_id;
314: fnd_message.set_name('CSI', 'CSI_DUPLICATE_CLLI_CODE');
315: fnd_message.set_token('PARAMETER',l_location_rec.clli_code);
316: fnd_msg_pub.add;
317: RAISE fnd_api.g_exc_error;
318: EXCEPTION
319: WHEN TOO_MANY_ROWS THEN
320: fnd_message.set_name('CSI', 'CSI_DUPLICATE_CLLI_CODE');
321: fnd_message.set_token('PARAMETER',l_location_rec.clli_code);

Line 323: RAISE fnd_api.g_exc_error;

319: WHEN TOO_MANY_ROWS THEN
320: fnd_message.set_name('CSI', 'CSI_DUPLICATE_CLLI_CODE');
321: fnd_message.set_token('PARAMETER',l_location_rec.clli_code);
322: fnd_msg_pub.add;
323: RAISE fnd_api.g_exc_error;
324: WHEN NO_DATA_FOUND THEN
325: NULL;
326: END;
327: END IF;

Line 341: IF fnd_api.to_boolean( p_commit )

337: );
338:
339:
340:
341: IF fnd_api.to_boolean( p_commit )
342: THEN
343: COMMIT WORK;
344: END IF;
345:

Line 353: WHEN fnd_api.g_exc_error THEN

349: p_data => x_msg_data
350: );
351:
352: EXCEPTION
353: WHEN fnd_api.g_exc_error THEN
354: ROLLBACK TO update_location_pvt;
355: x_return_status := fnd_api.g_ret_sts_error ;
356: fnd_msg_pub.count_and_get
357: (p_count => x_msg_count ,

Line 355: x_return_status := fnd_api.g_ret_sts_error ;

351:
352: EXCEPTION
353: WHEN fnd_api.g_exc_error THEN
354: ROLLBACK TO update_location_pvt;
355: x_return_status := fnd_api.g_ret_sts_error ;
356: fnd_msg_pub.count_and_get
357: (p_count => x_msg_count ,
358: p_data => x_msg_data
359: );