DBA Data[Home] [Help]

APPS.HZ_GEOGRAPHY_PUB_UIW dependencies on FND_API

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

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

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

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

Line 97: * FND_API.G_RET_STS_ERROR (error),

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

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

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

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

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

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

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

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

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

Line 138: * FND_API.G_RET_STS_ERROR (error),

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

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

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

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

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

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

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

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

173: * IN/OUT:
174: * OUT:
175: *
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: * OUT:
175: *
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: *
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 191: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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

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

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

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

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

Line 219: * FND_API.G_RET_STS_ERROR (error),

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

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

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

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

228: * 26-OCT-2005 Idris Ali o Bug 4578867 Added parameter x_cp_request_id.
229: *
230: */
231: PROCEDURE update_geo_identifier (
232: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
233: p_geo_identifier_rec IN GEO_IDENTIFIER_REC_TYPE,
234: p_object_version_number IN OUT NOCOPY NUMBER,
235: x_cp_request_id OUT NOCOPY NUMBER, -- Bug 4578867
236: x_return_status OUT NOCOPY VARCHAR2,

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

248: *
249: * ARGUMENTS
250: * IN:
251: * p_init_msg_list Initialize message stack if it is set to
252: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
253: * p_geography_id geography id
254: * p_identifier_type
255: * p_identifier_subtype
256: * p_identifier_value

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

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

Line 262: * FND_API.G_RET_STS_ERROR (error),

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

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

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

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

271: *
272: */
273:
274: PROCEDURE delete_geo_identifier(
275: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
276: p_geography_id IN NUMBER,
277: p_identifier_type IN VARCHAR2,
278: p_identifier_subtype IN VARCHAR2,
279: p_identifier_value IN VARCHAR2,

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

294: *
295: * ARGUMENTS
296: * IN:
297: * p_init_msg_list Initialize message stack if it is set to
298: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
299: * p_master_geography_rec Master Geography type record.
300: * IN/OUT:
301: * OUT:
302: *

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

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

Line 306: * FND_API.G_RET_STS_ERROR (error),

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

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

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

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

315: *
316: */
317:
318: PROCEDURE create_master_geography(
319: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
320: p_master_geography_rec IN MASTER_GEOGRAPHY_REC_TYPE,
321: p_parent_geography_id IN PARENT_GEOGRAPHY_TBL_TYPE,
322: x_geography_id OUT NOCOPY NUMBER,
323: x_return_status OUT NOCOPY VARCHAR2,

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

335: *
336: * ARGUMENTS
337: * IN:
338: * p_init_msg_list Initialize message stack if it is set to
339: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
340: * p_master_geography_rec Master Geography type record.
341: *
342: * IN/OUT:
343: * p_object_version_number

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

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

Line 348: * FND_API.G_RET_STS_ERROR (error),

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

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

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

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

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

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

378: *
379: * ARGUMENTS
380: * IN:
381: * p_init_msg_list Initialize message stack if it is set to
382: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
383: * p_geography_range_rec Geography range type record.
384: * IN/OUT:
385: * OUT:
386: *

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

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

Line 389: * FND_API.G_RET_STS_ERROR (error),

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

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

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

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

398: *
399: */
400:
401: PROCEDURE create_geography_range(
402: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
403: p_geography_range_rec IN GEOGRAPHY_RANGE_REC_TYPE,
404: x_return_status OUT NOCOPY VARCHAR2,
405: x_msg_count OUT NOCOPY NUMBER,
406: x_msg_data OUT NOCOPY VARCHAR2

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

417: *
418: * ARGUMENTS
419: * IN:
420: * p_init_msg_list Initialize message stack if it is set to
421: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
422: * geography_id
423: * geography_from
424: * start_date
425: * end_date

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

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

Line 433: * FND_API.G_RET_STS_ERROR (error),

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

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

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

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

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

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

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

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

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

Line 476: * FND_API.G_RET_STS_ERROR (error),

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

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

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

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

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

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

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

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

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

Line 530: * FND_API.G_RET_STS_ERROR (error),

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

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

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

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

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