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

Line 18: mdsys.sdo_geometry(fnd_api.g_miss_num,

14: -- declaration of record type
15: --------------------------------------
16:
17: hz_geometry_default CONSTANT mdsys.sdo_geometry :=
18: mdsys.sdo_geometry(fnd_api.g_miss_num,
19: fnd_api.g_miss_num, NULL, NULL, NULL);
20: geometry_status_code_default CONSTANT VARCHAR2(30) := 'DIRTY';
21:
22: -- Bug 2197181:: Added the constant for Mix-N-Match project to reduce the dependencies.

Line 19: fnd_api.g_miss_num, NULL, NULL, NULL);

15: --------------------------------------
16:
17: hz_geometry_default CONSTANT mdsys.sdo_geometry :=
18: mdsys.sdo_geometry(fnd_api.g_miss_num,
19: fnd_api.g_miss_num, NULL, NULL, NULL);
20: geometry_status_code_default CONSTANT VARCHAR2(30) := 'DIRTY';
21:
22: -- Bug 2197181:: Added the constant for Mix-N-Match project to reduce the dependencies.
23:

Line 111: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

107: *
108: * ARGUMENTS
109: * IN:
110: * p_init_msg_list Initialize message stack if it is set to
111: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
112: * p_location_rec Location record.
113: * IN/OUT:
114: * OUT:
115: * x_location_id Location ID.

Line 117: * be FND_API.G_RET_STS_SUCCESS (success),

113: * IN/OUT:
114: * OUT:
115: * x_location_id Location ID.
116: * x_return_status Return status after the call. The status can
117: * be FND_API.G_RET_STS_SUCCESS (success),
118: * FND_API.G_RET_STS_ERROR (error),
119: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
120: * x_msg_count Number of messages in message stack.
121: * x_msg_data Message text if x_msg_count is 1.

Line 118: * FND_API.G_RET_STS_ERROR (error),

114: * OUT:
115: * x_location_id Location ID.
116: * x_return_status Return status after the call. The status can
117: * be FND_API.G_RET_STS_SUCCESS (success),
118: * FND_API.G_RET_STS_ERROR (error),
119: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
120: * x_msg_count Number of messages in message stack.
121: * x_msg_data Message text if x_msg_count is 1.
122: *

Line 119: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

115: * x_location_id Location ID.
116: * x_return_status Return status after the call. The status can
117: * be FND_API.G_RET_STS_SUCCESS (success),
118: * FND_API.G_RET_STS_ERROR (error),
119: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
120: * x_msg_count Number of messages in message stack.
121: * x_msg_data Message text if x_msg_count is 1.
122: *
123: * NOTES

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

145: * @rep:businessevent oracle.apps.ar.hz.Location.create
146: * @rep:doccd 120hztig.pdf Location APIs, Oracle Trading Community Architecture Technical Implementation Guide
147: */
148: PROCEDURE create_location (
149: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
150: p_location_rec IN LOCATION_REC_TYPE,
151: x_location_id OUT NOCOPY NUMBER,
152: x_return_status OUT NOCOPY VARCHAR2,
153: x_msg_count OUT NOCOPY NUMBER,

Line 168: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

164: *
165: * ARGUMENTS
166: * IN:
167: * p_init_msg_list Initialize message stack if it is set to
168: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
169: * p_location_rec Location record.
170: * p_do_addr_val Do address validation if 'Y'
171: * IN/OUT:
172: * OUT:

Line 177: * be FND_API.G_RET_STS_SUCCESS (success),

173: * x_location_id Location ID.
174: * x_addr_val_status Address validation status based on address validation level.
175: * x_addr_warn_msg Warning message if x_addr_val_status is 'W'
176: * x_return_status Return status after the call. The status can
177: * be FND_API.G_RET_STS_SUCCESS (success),
178: * FND_API.G_RET_STS_ERROR (error),
179: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
180: * x_msg_count Number of messages in message stack.
181: * x_msg_data Message text if x_msg_count is 1.

Line 178: * FND_API.G_RET_STS_ERROR (error),

174: * x_addr_val_status Address validation status based on address validation level.
175: * x_addr_warn_msg Warning message if x_addr_val_status is 'W'
176: * x_return_status Return status after the call. The status can
177: * be FND_API.G_RET_STS_SUCCESS (success),
178: * FND_API.G_RET_STS_ERROR (error),
179: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
180: * x_msg_count Number of messages in message stack.
181: * x_msg_data Message text if x_msg_count is 1.
182: *

Line 179: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

175: * x_addr_warn_msg Warning message if x_addr_val_status is 'W'
176: * x_return_status Return status after the call. The status can
177: * be FND_API.G_RET_STS_SUCCESS (success),
178: * FND_API.G_RET_STS_ERROR (error),
179: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
180: * x_msg_count Number of messages in message stack.
181: * x_msg_data Message text if x_msg_count is 1.
182: *
183: * NOTES

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

209: * @rep:displayname Create Location
210: * @rep:businessevent oracle.apps.ar.hz.Location.create
211: */
212: PROCEDURE create_location (
213: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
214: p_location_rec IN LOCATION_REC_TYPE,
215: p_do_addr_val IN VARCHAR2,
216: x_location_id OUT NOCOPY NUMBER,
217: x_addr_val_status OUT NOCOPY VARCHAR2,

Line 235: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

231: *
232: * ARGUMENTS
233: * IN:
234: * p_init_msg_list Initialize message stack if it is set to
235: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
236: * p_location_rec Location record.
237: * IN/OUT:
238: * p_object_version_number Used for locking the being updated record.
239: * OUT:

Line 241: * be FND_API.G_RET_STS_SUCCESS (success),

237: * IN/OUT:
238: * p_object_version_number Used for locking the being updated record.
239: * OUT:
240: * x_return_status Return status after the call. The status can
241: * be FND_API.G_RET_STS_SUCCESS (success),
242: * FND_API.G_RET_STS_ERROR (error),
243: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
244: * x_msg_count Number of messages in message stack.
245: * x_msg_data Message text if x_msg_count is 1.

Line 242: * FND_API.G_RET_STS_ERROR (error),

238: * p_object_version_number Used for locking the being updated record.
239: * OUT:
240: * x_return_status Return status after the call. The status can
241: * be FND_API.G_RET_STS_SUCCESS (success),
242: * FND_API.G_RET_STS_ERROR (error),
243: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
244: * x_msg_count Number of messages in message stack.
245: * x_msg_data Message text if x_msg_count is 1.
246: *

Line 243: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

239: * OUT:
240: * x_return_status Return status after the call. The status can
241: * be FND_API.G_RET_STS_SUCCESS (success),
242: * FND_API.G_RET_STS_ERROR (error),
243: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
244: * x_msg_count Number of messages in message stack.
245: * x_msg_data Message text if x_msg_count is 1.
246: *
247: * NOTES

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

270: * @rep:businessevent oracle.apps.ar.hz.Location.update
271: * @rep:doccd 120hztig.pdf Location APIs, Oracle Trading Community Architecture Technical Implementation Guide
272: */
273: PROCEDURE update_location (
274: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
275: p_location_rec IN LOCATION_REC_TYPE,
276: p_object_version_number IN OUT NOCOPY NUMBER,
277: x_return_status OUT NOCOPY VARCHAR2,
278: x_msg_count OUT NOCOPY NUMBER,

Line 293: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

289: *
290: * ARGUMENTS
291: * IN:
292: * p_init_msg_list Initialize message stack if it is set to
293: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
294: * p_location_rec Location record.
295: * p_do_addr_val Do address validation if 'Y'
296: * IN/OUT:
297: * p_object_version_number Used for locking the being updated record.

Line 302: * be FND_API.G_RET_STS_SUCCESS (success),

298: * OUT:
299: * x_addr_val_status Address validation status based on address validation level.
300: * x_addr_warn_msg Warning message if x_addr_val_status is 'W'
301: * x_return_status Return status after the call. The status can
302: * be FND_API.G_RET_STS_SUCCESS (success),
303: * FND_API.G_RET_STS_ERROR (error),
304: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
305: * x_msg_count Number of messages in message stack.
306: * x_msg_data Message text if x_msg_count is 1.

Line 303: * FND_API.G_RET_STS_ERROR (error),

299: * x_addr_val_status Address validation status based on address validation level.
300: * x_addr_warn_msg Warning message if x_addr_val_status is 'W'
301: * x_return_status Return status after the call. The status can
302: * be FND_API.G_RET_STS_SUCCESS (success),
303: * FND_API.G_RET_STS_ERROR (error),
304: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
305: * x_msg_count Number of messages in message stack.
306: * x_msg_data Message text if x_msg_count is 1.
307: *

Line 304: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

300: * x_addr_warn_msg Warning message if x_addr_val_status is 'W'
301: * x_return_status Return status after the call. The status can
302: * be FND_API.G_RET_STS_SUCCESS (success),
303: * FND_API.G_RET_STS_ERROR (error),
304: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
305: * x_msg_count Number of messages in message stack.
306: * x_msg_data Message text if x_msg_count is 1.
307: *
308: * NOTES

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

336: * @rep:businessevent oracle.apps.ar.hz.Location.update
337: */
338:
339: PROCEDURE update_location (
340: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
341: p_location_rec IN LOCATION_REC_TYPE,
342: p_do_addr_val IN VARCHAR2,
343: p_object_version_number IN OUT NOCOPY NUMBER,
344: x_addr_val_status OUT NOCOPY VARCHAR2,

Line 362: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

358: *
359: * ARGUMENTS
360: * IN:
361: * p_init_msg_list Initialize message stack if it is set to
362: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
363: * p_location_id Location ID.
364: * IN/OUT:
365: * OUT:
366: * x_location_rec Location record.

Line 368: * be FND_API.G_RET_STS_SUCCESS (success),

364: * IN/OUT:
365: * OUT:
366: * x_location_rec Location record.
367: * x_return_status Return status after the call. The status can
368: * be FND_API.G_RET_STS_SUCCESS (success),
369: * FND_API.G_RET_STS_ERROR (error),
370: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
371: * x_msg_count Number of messages in message stack.
372: * x_msg_data Message text if x_msg_count is 1.

Line 369: * FND_API.G_RET_STS_ERROR (error),

365: * OUT:
366: * x_location_rec Location record.
367: * x_return_status Return status after the call. The status can
368: * be FND_API.G_RET_STS_SUCCESS (success),
369: * FND_API.G_RET_STS_ERROR (error),
370: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
371: * x_msg_count Number of messages in message stack.
372: * x_msg_data Message text if x_msg_count is 1.
373: *

Line 370: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

366: * x_location_rec Location record.
367: * x_return_status Return status after the call. The status can
368: * be FND_API.G_RET_STS_SUCCESS (success),
369: * FND_API.G_RET_STS_ERROR (error),
370: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
371: * x_msg_count Number of messages in message stack.
372: * x_msg_data Message text if x_msg_count is 1.
373: *
374: * NOTES

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

379: *
380: */
381:
382: PROCEDURE get_location_rec(
383: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
384: p_location_id IN NUMBER,
385: x_location_rec OUT NOCOPY LOCATION_REC_TYPE,
386: x_return_status OUT NOCOPY VARCHAR2,
387: x_msg_count OUT NOCOPY NUMBER,