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

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

12: *
13: * ARGUMENTS
14: * IN:
15: * p_init_msg_list Initialize message stack if it is set to
16: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
17: * p_master_relation_rec Geography type record.
18: * IN/OUT:
19: * OUT:
20: * x_relationship_id Returns relationship_id for the relationship created.

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

18: * IN/OUT:
19: * OUT:
20: * x_relationship_id Returns relationship_id for the relationship created.
21: * x_return_status Return status after the call. The status can
22: * be FND_API.G_RET_STS_SUCCESS (success),
23: * FND_API.G_RET_STS_ERROR (error),
24: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
25: * x_msg_count Number of messages in message stack.
26: * x_msg_data Message text if x_msg_count is 1.

Line 23: * FND_API.G_RET_STS_ERROR (error),

19: * OUT:
20: * x_relationship_id Returns relationship_id for the relationship created.
21: * x_return_status Return status after the call. The status can
22: * be FND_API.G_RET_STS_SUCCESS (success),
23: * FND_API.G_RET_STS_ERROR (error),
24: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
25: * x_msg_count Number of messages in message stack.
26: * x_msg_data Message text if x_msg_count is 1.
27: *

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

20: * x_relationship_id Returns relationship_id for the relationship created.
21: * x_return_status Return status after the call. The status can
22: * be FND_API.G_RET_STS_SUCCESS (success),
23: * FND_API.G_RET_STS_ERROR (error),
24: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
25: * x_msg_count Number of messages in message stack.
26: * x_msg_data Message text if x_msg_count is 1.
27: *
28: * NOTES

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

32: *
33: */
34:
35: PROCEDURE create_master_relation (
36: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
37: p_master_relation_rec IN MASTER_RELATION_REC_TYPE,
38: x_relationship_id OUT NOCOPY NUMBER,
39: x_return_status OUT NOCOPY VARCHAR2,
40: x_msg_count OUT NOCOPY NUMBER,

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

71: *
72: * ARGUMENTS
73: * IN:
74: * p_init_msg_list Initialize message stack if it is set to
75: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
76: * p_master_relation_rec Geography type record.
77: * p_object_version_number Object version number of the row
78: * IN/OUT:
79: * OUT:

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

78: * IN/OUT:
79: * OUT:
80: *
81: * x_return_status Return status after the call. The status can
82: * be FND_API.G_RET_STS_SUCCESS (success),
83: * FND_API.G_RET_STS_ERROR (error),
84: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
85: * x_msg_count Number of messages in message stack.
86: * x_msg_data Message text if x_msg_count is 1.

Line 83: * FND_API.G_RET_STS_ERROR (error),

79: * OUT:
80: *
81: * x_return_status Return status after the call. The status can
82: * be FND_API.G_RET_STS_SUCCESS (success),
83: * FND_API.G_RET_STS_ERROR (error),
84: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
85: * x_msg_count Number of messages in message stack.
86: * x_msg_data Message text if x_msg_count is 1.
87: *

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

80: *
81: * x_return_status Return status after the call. The status can
82: * be FND_API.G_RET_STS_SUCCESS (success),
83: * FND_API.G_RET_STS_ERROR (error),
84: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
85: * x_msg_count Number of messages in message stack.
86: * x_msg_data Message text if x_msg_count is 1.
87: *
88: * NOTES

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

92: *
93: */
94:
95: PROCEDURE update_relationship (
96: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
97: p_relationship_id IN NUMBER,
98: p_status IN VARCHAR2,
99: p_object_version_number IN OUT NOCOPY NUMBER,
100: x_return_status OUT NOCOPY VARCHAR2,

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

124: *
125: * ARGUMENTS
126: * IN:
127: * p_init_msg_list Initialize message stack if it is set to
128: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
129: * p_geo_identifier_rec Geo_identifier type record.
130: * IN/OUT:
131: * OUT:
132: *

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

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

Line 135: * FND_API.G_RET_STS_ERROR (error),

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

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

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

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

144: *
145: */
146:
147: PROCEDURE create_geo_identifier(
148: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
149: p_geo_identifier_rec IN GEO_IDENTIFIER_REC_TYPE,
150: x_return_status OUT NOCOPY VARCHAR2,
151: x_msg_count OUT NOCOPY NUMBER,
152: x_msg_data OUT NOCOPY VARCHAR2

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

184: *
185: * ARGUMENTS
186: * IN:
187: * p_init_msg_list Initialize message stack if it is set to
188: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
189: * p_geo_identifier_rec Geo_identifier type record.
190: *
191: * IN/OUT:
192: * p_object_version_number

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

193: * OUT:
194: * x_cp_request_id Concurrent Program Request Id,whenever CP
195: * to update denormalized data gets kicked off.
196: * x_return_status Return status after the call. The status can
197: * be FND_API.G_RET_STS_SUCCESS (success),
198: * FND_API.G_RET_STS_ERROR (error),
199: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
200: * x_msg_count Number of messages in message stack.
201: * x_msg_data Message text if x_msg_count is 1.

Line 198: * FND_API.G_RET_STS_ERROR (error),

194: * x_cp_request_id Concurrent Program Request Id,whenever CP
195: * to update denormalized data gets kicked off.
196: * x_return_status Return status after the call. The status can
197: * be FND_API.G_RET_STS_SUCCESS (success),
198: * FND_API.G_RET_STS_ERROR (error),
199: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
200: * x_msg_count Number of messages in message stack.
201: * x_msg_data Message text if x_msg_count is 1.
202: *

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

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

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

207: * 26-OCT-2005 Idris Ali o Bug 4578867 Added parameter x_cp_request_id.
208: *
209: */
210: PROCEDURE update_geo_identifier (
211: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
212: p_geo_identifier_rec IN GEO_IDENTIFIER_REC_TYPE,
213: p_object_version_number IN OUT NOCOPY NUMBER,
214: x_cp_request_id OUT NOCOPY NUMBER, --Bug 4578867
215: x_return_status OUT NOCOPY VARCHAR2,

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

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

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

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

Line 268: * FND_API.G_RET_STS_ERROR (error),

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

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

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

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

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

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

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

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

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

Line 326: * FND_API.G_RET_STS_ERROR (error),

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

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

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

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

335: *
336: */
337:
338: PROCEDURE create_master_geography(
339: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
340: p_master_geography_rec IN MASTER_GEOGRAPHY_REC_TYPE,
341: p_parent_geography_id IN PARENT_GEOGRAPHY_TBL_TYPE,
342: x_geography_id OUT NOCOPY NUMBER,
343: x_return_status OUT NOCOPY VARCHAR2,

Line 359: IF l_master_geography_rec.start_date = fnd_api.g_miss_date or l_master_geography_rec.start_date is null THEN

355: l_master_geography_rec.geography_type := p_master_geography_rec.geography_type;
356: l_master_geography_rec.geography_name := p_master_geography_rec.geography_name;
357: l_master_geography_rec.geography_code := p_master_geography_rec.geography_code;
358: l_master_geography_rec.geography_code_type := p_master_geography_rec.geography_code_type;
359: IF l_master_geography_rec.start_date = fnd_api.g_miss_date or l_master_geography_rec.start_date is null THEN
360: l_master_geography_rec.start_date :=sysdate;
361: END IF;
362: IF l_master_geography_rec.end_date = fnd_api.g_miss_date or l_master_geography_rec.end_date is null THEN
363: l_master_geography_rec.end_date := to_date('31-12-4712','DD-MM-YYYY');

Line 362: IF l_master_geography_rec.end_date = fnd_api.g_miss_date or l_master_geography_rec.end_date is null THEN

358: l_master_geography_rec.geography_code_type := p_master_geography_rec.geography_code_type;
359: IF l_master_geography_rec.start_date = fnd_api.g_miss_date or l_master_geography_rec.start_date is null THEN
360: l_master_geography_rec.start_date :=sysdate;
361: END IF;
362: IF l_master_geography_rec.end_date = fnd_api.g_miss_date or l_master_geography_rec.end_date is null THEN
363: l_master_geography_rec.end_date := to_date('31-12-4712','DD-MM-YYYY');
364: END IF;
365: l_master_geography_rec.geo_data_provider := p_master_geography_rec.geo_data_provider;
366: l_master_geography_rec.language_code := p_master_geography_rec.language_code;

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

390: *
391: * ARGUMENTS
392: * IN:
393: * p_init_msg_list Initialize message stack if it is set to
394: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
395: * p_master_geography_rec Master Geography type record.
396: *
397: * IN/OUT:
398: * p_object_version_number

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

398: * p_object_version_number
399: * OUT:
400: *
401: * x_return_status Return status after the call. The status can
402: * be FND_API.G_RET_STS_SUCCESS (success),
403: * FND_API.G_RET_STS_ERROR (error),
404: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
405: * x_msg_count Number of messages in message stack.
406: * x_msg_data Message text if x_msg_count is 1.

Line 403: * FND_API.G_RET_STS_ERROR (error),

399: * OUT:
400: *
401: * x_return_status Return status after the call. The status can
402: * be FND_API.G_RET_STS_SUCCESS (success),
403: * FND_API.G_RET_STS_ERROR (error),
404: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
405: * x_msg_count Number of messages in message stack.
406: * x_msg_data Message text if x_msg_count is 1.
407: *

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

400: *
401: * x_return_status Return status after the call. The status can
402: * be FND_API.G_RET_STS_SUCCESS (success),
403: * FND_API.G_RET_STS_ERROR (error),
404: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
405: * x_msg_count Number of messages in message stack.
406: * x_msg_data Message text if x_msg_count is 1.
407: *
408: * NOTES

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

411: * 06-20-2005 Kate Shan o Created.
412: *
413: */
414: PROCEDURE update_geography (
415: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
416: p_geography_id IN NUMBER,
417: p_end_date IN DATE,
418: p_timezone_code IN VARCHAR2,
419: p_object_version_number IN OUT NOCOPY NUMBER,

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

447: *
448: * ARGUMENTS
449: * IN:
450: * p_init_msg_list Initialize message stack if it is set to
451: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
452: * p_geography_range_rec Geography range type record.
453: * IN/OUT:
454: * OUT:
455: *

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

453: * IN/OUT:
454: * OUT:
455: *
456: * x_return_status Return status after the call. The status can
457: * be FND_API.G_RET_STS_SUCCESS (success),
458: * FND_API.G_RET_STS_ERROR (error),
459: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
460: * x_msg_count Number of messages in message stack.
461: * x_msg_data Message text if x_msg_count is 1.

Line 458: * FND_API.G_RET_STS_ERROR (error),

454: * OUT:
455: *
456: * x_return_status Return status after the call. The status can
457: * be FND_API.G_RET_STS_SUCCESS (success),
458: * FND_API.G_RET_STS_ERROR (error),
459: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
460: * x_msg_count Number of messages in message stack.
461: * x_msg_data Message text if x_msg_count is 1.
462: *

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

455: *
456: * x_return_status Return status after the call. The status can
457: * be FND_API.G_RET_STS_SUCCESS (success),
458: * FND_API.G_RET_STS_ERROR (error),
459: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
460: * x_msg_count Number of messages in message stack.
461: * x_msg_data Message text if x_msg_count is 1.
462: *
463: * NOTES

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

467: *
468: */
469:
470: PROCEDURE create_geography_range(
471: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
472: p_geography_range_rec IN GEOGRAPHY_RANGE_REC_TYPE,
473: x_return_status OUT NOCOPY VARCHAR2,
474: x_msg_count OUT NOCOPY NUMBER,
475: x_msg_data OUT NOCOPY VARCHAR2

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

510: *
511: * ARGUMENTS
512: * IN:
513: * p_init_msg_list Initialize message stack if it is set to
514: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
515: * geography_id
516: * geography_from
517: * start_date
518: * end_date

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

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

Line 526: * FND_API.G_RET_STS_ERROR (error),

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

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

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

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

534: * 06-20-2005 Kate Shan o Created.
535: *
536: */
537: PROCEDURE update_geography_range (
538: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
539: p_geography_id IN NUMBER,
540: p_geography_from IN VARCHAR2,
541: p_start_date IN DATE,
542: p_end_date IN DATE,

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

570: *
571: * ARGUMENTS
572: * IN:
573: * p_init_msg_list Initialize message stack if it is set to
574: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
575: * p_geography_id
576: * p_zone_relation_tbl Zone relation table of records.
577: * IN/OUT:
578: * OUT:

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

577: * IN/OUT:
578: * OUT:
579: *
580: * x_return_status Return status after the call. The status can
581: * be FND_API.G_RET_STS_SUCCESS (success),
582: * FND_API.G_RET_STS_ERROR (error),
583: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
584: * x_msg_count Number of messages in message stack.
585: * x_msg_data Message text if x_msg_count is 1.

Line 582: * FND_API.G_RET_STS_ERROR (error),

578: * OUT:
579: *
580: * x_return_status Return status after the call. The status can
581: * be FND_API.G_RET_STS_SUCCESS (success),
582: * FND_API.G_RET_STS_ERROR (error),
583: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
584: * x_msg_count Number of messages in message stack.
585: * x_msg_data Message text if x_msg_count is 1.
586: *

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

579: *
580: * x_return_status Return status after the call. The status can
581: * be FND_API.G_RET_STS_SUCCESS (success),
582: * FND_API.G_RET_STS_ERROR (error),
583: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
584: * x_msg_count Number of messages in message stack.
585: * x_msg_data Message text if x_msg_count is 1.
586: *
587: * NOTES

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

594: *
595: */
596:
597: PROCEDURE create_zone_relation(
598: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
599: p_geography_id IN NUMBER,
600: p_zone_relation_tbl IN ZONE_RELATION_TBL_TYPE,
601: p_created_by_module IN VARCHAR2,
602: p_application_id IN NUMBER,

Line 617: IF p_zone_relation_tbl(i).start_date = fnd_api.g_miss_date or p_zone_relation_tbl(i).start_date is null or

613: l_zone_relation_tbl(i).geography_to := p_zone_relation_tbl(i).geography_to;
614: l_zone_relation_tbl(i).identifier_type := p_zone_relation_tbl(i).identifier_type;
615: l_zone_relation_tbl(i).geography_type := p_zone_relation_tbl(i).geography_type;
616:
617: IF p_zone_relation_tbl(i).start_date = fnd_api.g_miss_date or p_zone_relation_tbl(i).start_date is null or
618: p_zone_relation_tbl(i).start_date = to_date(null)
619: THEN
620: l_zone_relation_tbl(i).start_date :=sysdate;
621: ELSE

Line 624: IF p_zone_relation_tbl(i).end_date = fnd_api.g_miss_date or p_zone_relation_tbl(i).end_date is null

620: l_zone_relation_tbl(i).start_date :=sysdate;
621: ELSE
622: l_zone_relation_tbl(i).start_date := p_zone_relation_tbl(i).start_date;
623: END IF;
624: IF p_zone_relation_tbl(i).end_date = fnd_api.g_miss_date or p_zone_relation_tbl(i).end_date is null
625: THEN
626: l_zone_relation_tbl(i).end_date := to_date('31-12-4712','DD-MM-YYYY');
627: ELSE
628: l_zone_relation_tbl(i).end_date := p_zone_relation_tbl(i).end_date;

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

653: *
654: * ARGUMENTS
655: * IN:
656: * p_init_msg_list Initialize message stack if it is set to
657: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
658: * p_zone_type
659: * p_zone_name
660: * p_zone_code
661: * p_start_date

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

669: *
670: * OUT:
671: * x_return_status
672: * Return status after the call. The status can
673: * be FND_API.G_RET_STS_SUCCESS (success),
674: * FND_API.G_RET_STS_ERROR (error),
675: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
676: * x_msg_count Number of messages in message stack.
677: * x_msg_data Message text if x_msg_count is 1.

Line 674: * FND_API.G_RET_STS_ERROR (error),

670: * OUT:
671: * x_return_status
672: * Return status after the call. The status can
673: * be FND_API.G_RET_STS_SUCCESS (success),
674: * FND_API.G_RET_STS_ERROR (error),
675: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
676: * x_msg_count Number of messages in message stack.
677: * x_msg_data Message text if x_msg_count is 1.
678: *

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

671: * x_return_status
672: * Return status after the call. The status can
673: * be FND_API.G_RET_STS_SUCCESS (success),
674: * FND_API.G_RET_STS_ERROR (error),
675: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
676: * x_msg_count Number of messages in message stack.
677: * x_msg_data Message text if x_msg_count is 1.
678: *
679: * NOTES

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

686: *
687: */
688:
689: PROCEDURE create_zone(
690: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
691: p_zone_type IN VARCHAR2,
692: p_zone_name IN VARCHAR2,
693: p_zone_code IN VARCHAR2,
694: p_zone_code_type IN VARCHAR2,

Line 719: IF p_zone_relation_tbl(i).start_date = fnd_api.g_miss_date or p_zone_relation_tbl(i).start_date is null OR --Bug 4684003

715: l_zone_relation_tbl(i).geography_to := p_zone_relation_tbl(i).geography_to;
716: l_zone_relation_tbl(i).identifier_type := p_zone_relation_tbl(i).identifier_type;
717: l_zone_relation_tbl(i).geography_type := p_zone_relation_tbl(i).geography_type;
718:
719: IF p_zone_relation_tbl(i).start_date = fnd_api.g_miss_date or p_zone_relation_tbl(i).start_date is null OR --Bug 4684003
720: p_zone_relation_tbl(i).start_date = to_date(NULL) THEN
721: l_zone_relation_tbl(i).start_date :=sysdate;
722: ELSE
723: l_zone_relation_tbl(i).start_date := p_zone_relation_tbl(i).start_date;

Line 725: IF p_zone_relation_tbl(i).end_date = fnd_api.g_miss_date or p_zone_relation_tbl(i).end_date is null THEN

721: l_zone_relation_tbl(i).start_date :=sysdate;
722: ELSE
723: l_zone_relation_tbl(i).start_date := p_zone_relation_tbl(i).start_date;
724: END IF;
725: IF p_zone_relation_tbl(i).end_date = fnd_api.g_miss_date or p_zone_relation_tbl(i).end_date is null THEN
726: l_zone_relation_tbl(i).end_date := to_date('31-12-4712','DD-MM-YYYY');
727: ELSE
728: l_zone_relation_tbl(i).end_date := p_zone_relation_tbl(i).end_date;
729: END IF;