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_GEOGRAPHY_STRUCTURE_PUB dependencies on FND_API

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

60: *
61: * ARGUMENTS
62: * IN:
63: * p_init_msg_list Initialize message stack if it is set to
64: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
65: * p_geography_type_rec Geography type record.
66: * IN/OUT:
67: * OUT:
68: * x_return_status Return status after the call. The status can

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

65: * p_geography_type_rec Geography type record.
66: * IN/OUT:
67: * OUT:
68: * x_return_status Return status after the call. The status can
69: * be FND_API.G_RET_STS_SUCCESS (success),
70: * FND_API.G_RET_STS_ERROR (error),
71: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
72: * x_msg_count Number of messages in message stack.
73: * x_msg_data Message text if x_msg_count is 1.

Line 70: * FND_API.G_RET_STS_ERROR (error),

66: * IN/OUT:
67: * OUT:
68: * x_return_status Return status after the call. The status can
69: * be FND_API.G_RET_STS_SUCCESS (success),
70: * FND_API.G_RET_STS_ERROR (error),
71: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
72: * x_msg_count Number of messages in message stack.
73: * x_msg_data Message text if x_msg_count is 1.
74: *

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

67: * OUT:
68: * x_return_status Return status after the call. The status can
69: * be FND_API.G_RET_STS_SUCCESS (success),
70: * FND_API.G_RET_STS_ERROR (error),
71: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
72: * x_msg_count Number of messages in message stack.
73: * x_msg_data Message text if x_msg_count is 1.
74: *
75: * NOTES

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

80: *
81: */
82:
83: PROCEDURE create_geography_type (
84: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
85: p_geography_type_rec IN GEOGRAPHY_TYPE_REC_TYPE,
86: x_return_status OUT NOCOPY VARCHAR2,
87: x_msg_count OUT NOCOPY NUMBER,
88: x_msg_data OUT NOCOPY VARCHAR2

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

98: *
99: * ARGUMENTS
100: * IN:
101: * p_init_msg_list Initialize message stack if it is set to
102: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
103: * p_geo_structure_rec Geography structure type record.
104:
105: * IN/OUT:
106: * OUT:

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

104:
105: * IN/OUT:
106: * OUT:
107: * x_return_status Return status after the call. The status can
108: * be FND_API.G_RET_STS_SUCCESS (success),
109: * FND_API.G_RET_STS_ERROR (error),
110: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
111: * x_msg_count Number of messages in message stack.
112: * x_msg_data Message text if x_msg_count is 1.

Line 109: * FND_API.G_RET_STS_ERROR (error),

105: * IN/OUT:
106: * OUT:
107: * x_return_status Return status after the call. The status can
108: * be FND_API.G_RET_STS_SUCCESS (success),
109: * FND_API.G_RET_STS_ERROR (error),
110: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
111: * x_msg_count Number of messages in message stack.
112: * x_msg_data Message text if x_msg_count is 1.
113: *

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

106: * OUT:
107: * x_return_status Return status after the call. The status can
108: * be FND_API.G_RET_STS_SUCCESS (success),
109: * FND_API.G_RET_STS_ERROR (error),
110: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
111: * x_msg_count Number of messages in message stack.
112: * x_msg_data Message text if x_msg_count is 1.
113: *
114: * NOTES

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

120: */
121:
122:
123: PROCEDURE create_geo_structure(
124: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
125: p_geo_structure_rec IN GEO_STRUCTURE_REC_TYPE,
126: x_return_status OUT NOCOPY VARCHAR2,
127: x_msg_count OUT NOCOPY NUMBER,
128: x_msg_data OUT NOCOPY VARCHAR2

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

140: *
141: * ARGUMENTS
142: * IN:
143: * p_init_msg_list Initialize message stack if it is set to
144: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
145: * p_geo_structure_rec Geography structure type record.
146:
147: * IN/OUT:
148: * p_object_version_number object version number of the row being updated

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

147: * IN/OUT:
148: * p_object_version_number object version number of the row being updated
149: * OUT:
150: * x_return_status Return status after the call. The status can
151: * be FND_API.G_RET_STS_SUCCESS (success),
152: * FND_API.G_RET_STS_ERROR (error),
153: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
154: * x_msg_count Number of messages in message stack.
155: * x_msg_data Message text if x_msg_count is 1.

Line 152: * FND_API.G_RET_STS_ERROR (error),

148: * p_object_version_number object version number of the row being updated
149: * OUT:
150: * x_return_status Return status after the call. The status can
151: * be FND_API.G_RET_STS_SUCCESS (success),
152: * FND_API.G_RET_STS_ERROR (error),
153: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
154: * x_msg_count Number of messages in message stack.
155: * x_msg_data Message text if x_msg_count is 1.
156: *

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

149: * OUT:
150: * x_return_status Return status after the call. The status can
151: * be FND_API.G_RET_STS_SUCCESS (success),
152: * FND_API.G_RET_STS_ERROR (error),
153: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
154: * x_msg_count Number of messages in message stack.
155: * x_msg_data Message text if x_msg_count is 1.
156: *
157: * NOTES

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

162: *
163: */
164:
165: /*PROCEDURE update_geo_structure(
166: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
167: p_geography_id IN NUMBER,
168: p_geography_type IN VARCHAR2,
169: p_parent_geography_type IN VARCHAR2,
170: p_geography_element_column IN VARCHAR2,

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

185: *
186: * ARGUMENTS
187: * IN:
188: * p_init_msg_list Initialize message stack if it is set to
189: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
190: * p_geo_structure_rec Geography structure type record.
191:
192: * IN/OUT:
193: *

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

192: * IN/OUT:
193: *
194: * OUT:
195: * x_return_status Return status after the call. The status can
196: * be FND_API.G_RET_STS_SUCCESS (success),
197: * FND_API.G_RET_STS_ERROR (error),
198: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
199: * x_msg_count Number of messages in message stack.
200: * x_msg_data Message text if x_msg_count is 1.

Line 197: * FND_API.G_RET_STS_ERROR (error),

193: *
194: * OUT:
195: * x_return_status Return status after the call. The status can
196: * be FND_API.G_RET_STS_SUCCESS (success),
197: * FND_API.G_RET_STS_ERROR (error),
198: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
199: * x_msg_count Number of messages in message stack.
200: * x_msg_data Message text if x_msg_count is 1.
201: *

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

194: * OUT:
195: * x_return_status Return status after the call. The status can
196: * be FND_API.G_RET_STS_SUCCESS (success),
197: * FND_API.G_RET_STS_ERROR (error),
198: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
199: * x_msg_count Number of messages in message stack.
200: * x_msg_data Message text if x_msg_count is 1.
201: *
202: * NOTES

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

207: *
208: */
209:
210: PROCEDURE delete_geo_structure(
211: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
212: p_geography_id IN NUMBER,
213: p_geography_type IN VARCHAR2,
214: p_parent_geography_type IN VARCHAR2,
215: x_return_status OUT NOCOPY VARCHAR2,

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

229: *
230: * ARGUMENTS
231: * IN:
232: * p_init_msg_list Initialize message stack if it is set to
233: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
234: * p_geography_rel_type_rec Geography Relationship type record.
235: * IN/OUT:
236: * OUT:
237: * x_return_status Return status after the call. The status can

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

234: * p_geography_rel_type_rec Geography Relationship type record.
235: * IN/OUT:
236: * OUT:
237: * x_return_status Return status after the call. The status can
238: * be FND_API.G_RET_STS_SUCCESS (success),
239: * FND_API.G_RET_STS_ERROR (error),
240: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
241: * x_msg_count Number of messages in message stack.
242: * x_msg_data Message text if x_msg_count is 1.

Line 239: * FND_API.G_RET_STS_ERROR (error),

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

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

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

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

249: *
250: */
251:
252: PROCEDURE create_geo_rel_type(
253: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
254: p_geo_rel_type_rec IN GEO_REL_TYPE_REC_TYPE,
255: x_relationship_type_id OUT NOCOPY NUMBER,
256: x_return_status OUT NOCOPY VARCHAR2,
257: x_msg_count OUT NOCOPY NUMBER,

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

269: *
270: * ARGUMENTS
271: * IN:
272: * p_init_msg_list Initialize message stack if it is set to
273: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
274: * p_geography_rel_type_rec Geography Relationship type record.
275: * IN/OUT:
276: * p_object_version_number object version number of the row being updated
277: * OUT:

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

275: * IN/OUT:
276: * p_object_version_number object version number of the row being updated
277: * OUT:
278: * x_return_status Return status after the call. The status can
279: * be FND_API.G_RET_STS_SUCCESS (success),
280: * FND_API.G_RET_STS_ERROR (error),
281: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
282: * x_msg_count Number of messages in message stack.
283: * x_msg_data Message text if x_msg_count is 1.

Line 280: * FND_API.G_RET_STS_ERROR (error),

276: * p_object_version_number object version number of the row being updated
277: * OUT:
278: * x_return_status Return status after the call. The status can
279: * be FND_API.G_RET_STS_SUCCESS (success),
280: * FND_API.G_RET_STS_ERROR (error),
281: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
282: * x_msg_count Number of messages in message stack.
283: * x_msg_data Message text if x_msg_count is 1.
284: *

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

277: * OUT:
278: * x_return_status Return status after the call. The status can
279: * be FND_API.G_RET_STS_SUCCESS (success),
280: * FND_API.G_RET_STS_ERROR (error),
281: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
282: * x_msg_count Number of messages in message stack.
283: * x_msg_data Message text if x_msg_count is 1.
284: *
285: * NOTES

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

293: /* Made it as private procedure as there is no need to call this explicitly
294: * Make this public as it is required from Create/Update Zone API
295: */
296: PROCEDURE update_geo_rel_type(
297: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
298: p_relationship_type_id IN NUMBER,
299: p_status IN VARCHAR2,
300: p_object_version_number IN OUT NOCOPY NUMBER,
301: x_return_status OUT NOCOPY VARCHAR2,

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

313: *
314: * ARGUMENTS
315: * IN:
316: * p_init_msg_list Initialize message stack if it is set to
317: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
318: * p_zone_type_rec Zone_type type record.
319: * IN/OUT:
320: * OUT:
321: *

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

319: * IN/OUT:
320: * OUT:
321: *
322: * x_return_status Return status after the call. The status can
323: * be FND_API.G_RET_STS_SUCCESS (success),
324: * FND_API.G_RET_STS_ERROR (error),
325: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
326: * x_msg_count Number of messages in message stack.
327: * x_msg_data Message text if x_msg_count is 1.

Line 324: * FND_API.G_RET_STS_ERROR (error),

320: * OUT:
321: *
322: * x_return_status Return status after the call. The status can
323: * be FND_API.G_RET_STS_SUCCESS (success),
324: * FND_API.G_RET_STS_ERROR (error),
325: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
326: * x_msg_count Number of messages in message stack.
327: * x_msg_data Message text if x_msg_count is 1.
328: *

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

321: *
322: * x_return_status Return status after the call. The status can
323: * be FND_API.G_RET_STS_SUCCESS (success),
324: * FND_API.G_RET_STS_ERROR (error),
325: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
326: * x_msg_count Number of messages in message stack.
327: * x_msg_data Message text if x_msg_count is 1.
328: *
329: * NOTES

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

333: *
334: */
335:
336: PROCEDURE create_zone_type(
337: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
338: p_zone_type_rec IN ZONE_TYPE_REC_TYPE,
339: x_return_status OUT NOCOPY VARCHAR2,
340: x_msg_count OUT NOCOPY NUMBER,
341: x_msg_data OUT NOCOPY VARCHAR2

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

353: *
354: * ARGUMENTS
355: * IN:
356: * p_init_msg_list Initialize message stack if it is set to
357: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
358: * p_geographytype Geography type.
359: * p_limited_by_geography_id
360: * p_postal_code_range_flag
361: * IN/OUT:

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

361: * IN/OUT:
362: * p_object_version_number object version number of the row being updated
363: * OUT:
364: * x_return_status Return status after the call. The status can
365: * be FND_API.G_RET_STS_SUCCESS (success),
366: * FND_API.G_RET_STS_ERROR (error),
367: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
368: * x_msg_count Number of messages in message stack.
369: * x_msg_data Message text if x_msg_count is 1.

Line 366: * FND_API.G_RET_STS_ERROR (error),

362: * p_object_version_number object version number of the row being updated
363: * OUT:
364: * x_return_status Return status after the call. The status can
365: * be FND_API.G_RET_STS_SUCCESS (success),
366: * FND_API.G_RET_STS_ERROR (error),
367: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
368: * x_msg_count Number of messages in message stack.
369: * x_msg_data Message text if x_msg_count is 1.
370: *

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

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

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

376: *
377: */
378:
379: PROCEDURE update_zone_type(
380: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
381: p_zone_type_rec IN ZONE_TYPE_REC_TYPE,
382: p_object_version_number IN OUT NOCOPY NUMBER,
383: x_return_status OUT NOCOPY VARCHAR2,
384: x_msg_count OUT NOCOPY NUMBER,