DBA Data[Home] [Help]

APPS.HZ_GEOGRAPHY_PUB dependencies on FND_API

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

89: *
90: * ARGUMENTS
91: * IN:
92: * p_init_msg_list Initialize message stack if it is set to
93: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
94: * p_master_relation_rec Geography type record.
95: * IN/OUT:
96: * OUT:
97: * x_relationship_id Returns relationship_id for the relationship created.

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

95: * IN/OUT:
96: * OUT:
97: * x_relationship_id Returns relationship_id for the relationship created.
98: * x_return_status Return status after the call. The status can
99: * be FND_API.G_RET_STS_SUCCESS (success),
100: * FND_API.G_RET_STS_ERROR (error),
101: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
102: * x_msg_count Number of messages in message stack.
103: * x_msg_data Message text if x_msg_count is 1.

Line 100: * FND_API.G_RET_STS_ERROR (error),

96: * OUT:
97: * x_relationship_id Returns relationship_id for the relationship created.
98: * x_return_status Return status after the call. The status can
99: * be FND_API.G_RET_STS_SUCCESS (success),
100: * FND_API.G_RET_STS_ERROR (error),
101: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
102: * x_msg_count Number of messages in message stack.
103: * x_msg_data Message text if x_msg_count is 1.
104: *

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

97: * x_relationship_id Returns relationship_id for the relationship created.
98: * x_return_status Return status after the call. The status can
99: * be FND_API.G_RET_STS_SUCCESS (success),
100: * FND_API.G_RET_STS_ERROR (error),
101: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
102: * x_msg_count Number of messages in message stack.
103: * x_msg_data Message text if x_msg_count is 1.
104: *
105: * NOTES

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

109: *
110: */
111:
112: PROCEDURE create_master_relation (
113: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
114: p_master_relation_rec IN MASTER_RELATION_REC_TYPE,
115: x_relationship_id OUT NOCOPY NUMBER,
116: x_return_status OUT NOCOPY VARCHAR2,
117: x_msg_count OUT NOCOPY NUMBER,

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

129: *
130: * ARGUMENTS
131: * IN:
132: * p_init_msg_list Initialize message stack if it is set to
133: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
134: * p_master_relation_rec Geography type record.
135: * p_object_version_number Object version number of the row
136: * IN/OUT:
137: * OUT:

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

136: * IN/OUT:
137: * OUT:
138: *
139: * x_return_status Return status after the call. The status can
140: * be FND_API.G_RET_STS_SUCCESS (success),
141: * FND_API.G_RET_STS_ERROR (error),
142: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
143: * x_msg_count Number of messages in message stack.
144: * x_msg_data Message text if x_msg_count is 1.

Line 141: * FND_API.G_RET_STS_ERROR (error),

137: * OUT:
138: *
139: * x_return_status Return status after the call. The status can
140: * be FND_API.G_RET_STS_SUCCESS (success),
141: * FND_API.G_RET_STS_ERROR (error),
142: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
143: * x_msg_count Number of messages in message stack.
144: * x_msg_data Message text if x_msg_count is 1.
145: *

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

138: *
139: * x_return_status Return status after the call. The status can
140: * be FND_API.G_RET_STS_SUCCESS (success),
141: * FND_API.G_RET_STS_ERROR (error),
142: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
143: * x_msg_count Number of messages in message stack.
144: * x_msg_data Message text if x_msg_count is 1.
145: *
146: * NOTES

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

150: *
151: */
152:
153: PROCEDURE update_relationship (
154: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
155: p_relationship_id IN NUMBER,
156: p_status IN VARCHAR2,
157: p_object_version_number IN OUT NOCOPY NUMBER,
158: x_return_status OUT NOCOPY VARCHAR2,

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

170: *
171: * ARGUMENTS
172: * IN:
173: * p_init_msg_list Initialize message stack if it is set to
174: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
175: * p_geo_identifier_rec Geo_identifier type record.
176: * IN/OUT:
177: * OUT:
178: *

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

176: * IN/OUT:
177: * OUT:
178: *
179: * x_return_status Return status after the call. The status can
180: * be FND_API.G_RET_STS_SUCCESS (success),
181: * FND_API.G_RET_STS_ERROR (error),
182: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
183: * x_msg_count Number of messages in message stack.
184: * x_msg_data Message text if x_msg_count is 1.

Line 181: * FND_API.G_RET_STS_ERROR (error),

177: * OUT:
178: *
179: * x_return_status Return status after the call. The status can
180: * be FND_API.G_RET_STS_SUCCESS (success),
181: * FND_API.G_RET_STS_ERROR (error),
182: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
183: * x_msg_count Number of messages in message stack.
184: * x_msg_data Message text if x_msg_count is 1.
185: *

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

178: *
179: * x_return_status Return status after the call. The status can
180: * be FND_API.G_RET_STS_SUCCESS (success),
181: * FND_API.G_RET_STS_ERROR (error),
182: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
183: * x_msg_count Number of messages in message stack.
184: * x_msg_data Message text if x_msg_count is 1.
185: *
186: * NOTES

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

190: *
191: */
192:
193: PROCEDURE create_geo_identifier(
194: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
195: p_geo_identifier_rec IN GEO_IDENTIFIER_REC_TYPE,
196: x_return_status OUT NOCOPY VARCHAR2,
197: x_msg_count OUT NOCOPY NUMBER,
198: x_msg_data OUT NOCOPY VARCHAR2

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

208: *
209: * ARGUMENTS
210: * IN:
211: * p_init_msg_list Initialize message stack if it is set to
212: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
213: * p_geo_identifier_rec Geo_identifier type record.
214: *
215: * IN/OUT:
216: * p_object_version_number

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

218: *
219: * x_cp_request_id Concurrent Program Request Id, whenever CP
220: * to update denormalized data gets kicked off.
221: * x_return_status Return status after the call. The status can
222: * be FND_API.G_RET_STS_SUCCESS (success),
223: * FND_API.G_RET_STS_ERROR (error),
224: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
225: * x_msg_count Number of messages in message stack.
226: * x_msg_data Message text if x_msg_count is 1.

Line 223: * FND_API.G_RET_STS_ERROR (error),

219: * x_cp_request_id Concurrent Program Request Id, whenever CP
220: * to update denormalized data gets kicked off.
221: * x_return_status Return status after the call. The status can
222: * be FND_API.G_RET_STS_SUCCESS (success),
223: * FND_API.G_RET_STS_ERROR (error),
224: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
225: * x_msg_count Number of messages in message stack.
226: * x_msg_data Message text if x_msg_count is 1.
227: *

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

220: * to update denormalized data gets kicked off.
221: * x_return_status Return status after the call. The status can
222: * be FND_API.G_RET_STS_SUCCESS (success),
223: * FND_API.G_RET_STS_ERROR (error),
224: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
225: * x_msg_count Number of messages in message stack.
226: * x_msg_data Message text if x_msg_count is 1.
227: *
228: * NOTES

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

233: * for Bug 457886
234: *
235: */
236: PROCEDURE update_geo_identifier (
237: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
238: p_geo_identifier_rec IN GEO_IDENTIFIER_REC_TYPE,
239: p_object_version_number IN OUT NOCOPY NUMBER,
240: x_cp_request_id OUT NOCOPY NUMBER,
241: x_return_status OUT NOCOPY VARCHAR2,

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

253: *
254: * ARGUMENTS
255: * IN:
256: * p_init_msg_list Initialize message stack if it is set to
257: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
258: * p_geography_id geography id
259: * p_identifier_type
260: * p_identifier_subtype
261: * p_identifier_value

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

262: *
263: * OUT:
264: *
265: * x_return_status Return status after the call. The status can
266: * be FND_API.G_RET_STS_SUCCESS (success),
267: * FND_API.G_RET_STS_ERROR (error),
268: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
269: * x_msg_count Number of messages in message stack.
270: * x_msg_data Message text if x_msg_count is 1.

Line 267: * FND_API.G_RET_STS_ERROR (error),

263: * OUT:
264: *
265: * x_return_status Return status after the call. The status can
266: * be FND_API.G_RET_STS_SUCCESS (success),
267: * FND_API.G_RET_STS_ERROR (error),
268: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
269: * x_msg_count Number of messages in message stack.
270: * x_msg_data Message text if x_msg_count is 1.
271: *

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

264: *
265: * x_return_status Return status after the call. The status can
266: * be FND_API.G_RET_STS_SUCCESS (success),
267: * FND_API.G_RET_STS_ERROR (error),
268: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
269: * x_msg_count Number of messages in message stack.
270: * x_msg_data Message text if x_msg_count is 1.
271: *
272: * NOTES

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

276: *
277: */
278:
279: PROCEDURE delete_geo_identifier(
280: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
281: p_geography_id IN NUMBER,
282: p_identifier_type IN VARCHAR2,
283: p_identifier_subtype IN VARCHAR2,
284: p_identifier_value IN VARCHAR2,

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

299: *
300: * ARGUMENTS
301: * IN:
302: * p_init_msg_list Initialize message stack if it is set to
303: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
304: * p_master_geography_rec Master Geography type record.
305: * IN/OUT:
306: * OUT:
307: *

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

306: * OUT:
307: *
308: * x_geography_id Return ID of the geography being created.
309: * x_return_status Return status after the call. The status can
310: * be FND_API.G_RET_STS_SUCCESS (success),
311: * FND_API.G_RET_STS_ERROR (error),
312: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
313: * x_msg_count Number of messages in message stack.
314: * x_msg_data Message text if x_msg_count is 1.

Line 311: * FND_API.G_RET_STS_ERROR (error),

307: *
308: * x_geography_id Return ID of the geography being created.
309: * x_return_status Return status after the call. The status can
310: * be FND_API.G_RET_STS_SUCCESS (success),
311: * FND_API.G_RET_STS_ERROR (error),
312: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
313: * x_msg_count Number of messages in message stack.
314: * x_msg_data Message text if x_msg_count is 1.
315: *

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

308: * x_geography_id Return ID of the geography being created.
309: * x_return_status Return status after the call. The status can
310: * be FND_API.G_RET_STS_SUCCESS (success),
311: * FND_API.G_RET_STS_ERROR (error),
312: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
313: * x_msg_count Number of messages in message stack.
314: * x_msg_data Message text if x_msg_count is 1.
315: *
316: * NOTES

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

320: *
321: */
322:
323: PROCEDURE create_master_geography(
324: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
325: p_master_geography_rec IN MASTER_GEOGRAPHY_REC_TYPE,
326: x_geography_id OUT NOCOPY NUMBER,
327: x_return_status OUT NOCOPY VARCHAR2,
328: x_msg_count OUT NOCOPY NUMBER,

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

339: *
340: * ARGUMENTS
341: * IN:
342: * p_init_msg_list Initialize message stack if it is set to
343: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
344: * p_master_geography_rec Master Geography type record.
345: *
346: * IN/OUT:
347: * p_object_version_number

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

347: * p_object_version_number
348: * OUT:
349: *
350: * x_return_status Return status after the call. The status can
351: * be FND_API.G_RET_STS_SUCCESS (success),
352: * FND_API.G_RET_STS_ERROR (error),
353: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
354: * x_msg_count Number of messages in message stack.
355: * x_msg_data Message text if x_msg_count is 1.

Line 352: * FND_API.G_RET_STS_ERROR (error),

348: * OUT:
349: *
350: * x_return_status Return status after the call. The status can
351: * be FND_API.G_RET_STS_SUCCESS (success),
352: * FND_API.G_RET_STS_ERROR (error),
353: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
354: * x_msg_count Number of messages in message stack.
355: * x_msg_data Message text if x_msg_count is 1.
356: *

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

349: *
350: * x_return_status Return status after the call. The status can
351: * be FND_API.G_RET_STS_SUCCESS (success),
352: * FND_API.G_RET_STS_ERROR (error),
353: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
354: * x_msg_count Number of messages in message stack.
355: * x_msg_data Message text if x_msg_count is 1.
356: *
357: * NOTES

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

360: * 12-12-2002 Rekha Nalluri o Created.
361: *
362: */
363: PROCEDURE update_geography (
364: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
365: p_geography_id IN NUMBER,
366: p_end_date IN DATE,
367: p_geometry IN MDSYS.SDO_GEOMETRY,
368: p_timezone_code IN VARCHAR2,

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

382: *
383: * ARGUMENTS
384: * IN:
385: * p_init_msg_list Initialize message stack if it is set to
386: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
387: * p_geography_range_rec Geography range type record.
388: * IN/OUT:
389: * OUT:
390: *

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

388: * IN/OUT:
389: * OUT:
390: *
391: * x_return_status Return status after the call. The status can
392: * be FND_API.G_RET_STS_SUCCESS (success),
393: * FND_API.G_RET_STS_ERROR (error),
394: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
395: * x_msg_count Number of messages in message stack.
396: * x_msg_data Message text if x_msg_count is 1.

Line 393: * FND_API.G_RET_STS_ERROR (error),

389: * OUT:
390: *
391: * x_return_status Return status after the call. The status can
392: * be FND_API.G_RET_STS_SUCCESS (success),
393: * FND_API.G_RET_STS_ERROR (error),
394: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
395: * x_msg_count Number of messages in message stack.
396: * x_msg_data Message text if x_msg_count is 1.
397: *

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

390: *
391: * x_return_status Return status after the call. The status can
392: * be FND_API.G_RET_STS_SUCCESS (success),
393: * FND_API.G_RET_STS_ERROR (error),
394: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
395: * x_msg_count Number of messages in message stack.
396: * x_msg_data Message text if x_msg_count is 1.
397: *
398: * NOTES

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

402: *
403: */
404:
405: PROCEDURE create_geography_range(
406: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
407: p_geography_range_rec IN GEOGRAPHY_RANGE_REC_TYPE,
408: x_return_status OUT NOCOPY VARCHAR2,
409: x_msg_count OUT NOCOPY NUMBER,
410: x_msg_data OUT NOCOPY VARCHAR2

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

421: *
422: * ARGUMENTS
423: * IN:
424: * p_init_msg_list Initialize message stack if it is set to
425: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
426: * geography_id
427: * geography_from
428: * start_date
429: * end_date

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

432: * p_object_version_number
433: * OUT:
434: *
435: * x_return_status Return status after the call. The status can
436: * be FND_API.G_RET_STS_SUCCESS (success),
437: * FND_API.G_RET_STS_ERROR (error),
438: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
439: * x_msg_count Number of messages in message stack.
440: * x_msg_data Message text if x_msg_count is 1.

Line 437: * FND_API.G_RET_STS_ERROR (error),

433: * OUT:
434: *
435: * x_return_status Return status after the call. The status can
436: * be FND_API.G_RET_STS_SUCCESS (success),
437: * FND_API.G_RET_STS_ERROR (error),
438: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
439: * x_msg_count Number of messages in message stack.
440: * x_msg_data Message text if x_msg_count is 1.
441: *

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

434: *
435: * x_return_status Return status after the call. The status can
436: * be FND_API.G_RET_STS_SUCCESS (success),
437: * FND_API.G_RET_STS_ERROR (error),
438: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
439: * x_msg_count Number of messages in message stack.
440: * x_msg_data Message text if x_msg_count is 1.
441: *
442: * NOTES

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

445: * 01-23-2003 Rekha Nalluri o Created.
446: *
447: */
448: PROCEDURE update_geography_range (
449: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
450: p_geography_id IN NUMBER,
451: p_geography_from IN VARCHAR2,
452: p_start_date IN DATE,
453: p_end_date IN DATE,

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

468: *
469: * ARGUMENTS
470: * IN:
471: * p_init_msg_list Initialize message stack if it is set to
472: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
473: * p_geography_id
474: * p_zone_relation_tbl Zone relation table of records.
475: * IN/OUT:
476: * OUT:

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

475: * IN/OUT:
476: * OUT:
477: *
478: * x_return_status Return status after the call. The status can
479: * be FND_API.G_RET_STS_SUCCESS (success),
480: * FND_API.G_RET_STS_ERROR (error),
481: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
482: * x_msg_count Number of messages in message stack.
483: * x_msg_data Message text if x_msg_count is 1.

Line 480: * FND_API.G_RET_STS_ERROR (error),

476: * OUT:
477: *
478: * x_return_status Return status after the call. The status can
479: * be FND_API.G_RET_STS_SUCCESS (success),
480: * FND_API.G_RET_STS_ERROR (error),
481: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
482: * x_msg_count Number of messages in message stack.
483: * x_msg_data Message text if x_msg_count is 1.
484: *

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

477: *
478: * x_return_status Return status after the call. The status can
479: * be FND_API.G_RET_STS_SUCCESS (success),
480: * FND_API.G_RET_STS_ERROR (error),
481: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
482: * x_msg_count Number of messages in message stack.
483: * x_msg_data Message text if x_msg_count is 1.
484: *
485: * NOTES

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

489: *
490: */
491:
492: PROCEDURE create_zone_relation(
493: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
494: p_geography_id IN NUMBER,
495: p_zone_relation_tbl IN ZONE_RELATION_TBL_TYPE,
496: p_created_by_module IN VARCHAR2,
497: p_application_id IN NUMBER,

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

511: *
512: * ARGUMENTS
513: * IN:
514: * p_init_msg_list Initialize message stack if it is set to
515: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
516: * p_zone_type
517: * p_zone_name
518: * p_zone_code
519: * p_start_date

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

528: *
529: * OUT:
530: * x_return_status
531: * Return status after the call. The status can
532: * be FND_API.G_RET_STS_SUCCESS (success),
533: * FND_API.G_RET_STS_ERROR (error),
534: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
535: * x_msg_count Number of messages in message stack.
536: * x_msg_data Message text if x_msg_count is 1.

Line 533: * FND_API.G_RET_STS_ERROR (error),

529: * OUT:
530: * x_return_status
531: * Return status after the call. The status can
532: * be FND_API.G_RET_STS_SUCCESS (success),
533: * FND_API.G_RET_STS_ERROR (error),
534: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
535: * x_msg_count Number of messages in message stack.
536: * x_msg_data Message text if x_msg_count is 1.
537: *

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

530: * x_return_status
531: * Return status after the call. The status can
532: * be FND_API.G_RET_STS_SUCCESS (success),
533: * FND_API.G_RET_STS_ERROR (error),
534: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
535: * x_msg_count Number of messages in message stack.
536: * x_msg_data Message text if x_msg_count is 1.
537: *
538: * NOTES

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

542: *
543: */
544:
545: PROCEDURE create_zone(
546: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
547: p_zone_type IN VARCHAR2,
548: p_zone_name IN VARCHAR2,
549: p_zone_code IN VARCHAR2,
550: p_zone_code_type IN VARCHAR2,