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

Line 94: x_return_status := FND_API.G_RET_STS_ERROR;

90: IF p_column_value <= 0 THEN
91: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_GREATER_THAN_ZERO' );
92: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
93: FND_MSG_PUB.ADD;
94: x_return_status := FND_API.G_RET_STS_ERROR;
95: END IF;
96:
97: END check_greater_than_zero;
98:

Line 110: DECODE ( p_update_field_rec.start_date_active, null, start_date_active, fnd_api.g_miss_date, null, p_update_field_rec.start_date_active),

106: style_fmt_locale_id,
107: style_format_code,
108: language_code,
109: territory_code,
110: DECODE ( p_update_field_rec.start_date_active, null, start_date_active, fnd_api.g_miss_date, null, p_update_field_rec.start_date_active),
111: DECODE ( p_update_field_rec.end_date_active, null, end_date_active, fnd_api.g_miss_date, null, p_update_field_rec.end_date_active)
112: INTO
113: x_updated_rec.style_fmt_locale_id,
114: x_updated_rec.style_format_code,

Line 111: DECODE ( p_update_field_rec.end_date_active, null, end_date_active, fnd_api.g_miss_date, null, p_update_field_rec.end_date_active)

107: style_format_code,
108: language_code,
109: territory_code,
110: DECODE ( p_update_field_rec.start_date_active, null, start_date_active, fnd_api.g_miss_date, null, p_update_field_rec.start_date_active),
111: DECODE ( p_update_field_rec.end_date_active, null, end_date_active, fnd_api.g_miss_date, null, p_update_field_rec.end_date_active)
112: INTO
113: x_updated_rec.style_fmt_locale_id,
114: x_updated_rec.style_format_code,
115: x_updated_rec.language_code,

Line 138: DECODE ( p_update_field_rec.line_number, null, b.line_number, fnd_api.g_miss_num, null, p_update_field_rec.line_number),

134: b.style_format_code,
135: b.variation_number,
136: b.attribute_code,
137: b.attribute_application_id,
138: DECODE ( p_update_field_rec.line_number, null, b.line_number, fnd_api.g_miss_num, null, p_update_field_rec.line_number),
139: DECODE ( p_update_field_rec.position, null, b.position, fnd_api.g_miss_num, null, p_update_field_rec.position),
140: DECODE ( p_update_field_rec.mandatory_flag, null, b.mandatory_flag, fnd_api.g_miss_char, null, p_update_field_rec.mandatory_flag),
141: DECODE ( p_update_field_rec.use_initial_flag, null, b.use_initial_flag, fnd_api.g_miss_char, null, p_update_field_rec.use_initial_flag),
142: DECODE ( p_update_field_rec.uppercase_flag, null, b.uppercase_flag, fnd_api.g_miss_char, null, p_update_field_rec.uppercase_flag),

Line 139: DECODE ( p_update_field_rec.position, null, b.position, fnd_api.g_miss_num, null, p_update_field_rec.position),

135: b.variation_number,
136: b.attribute_code,
137: b.attribute_application_id,
138: DECODE ( p_update_field_rec.line_number, null, b.line_number, fnd_api.g_miss_num, null, p_update_field_rec.line_number),
139: DECODE ( p_update_field_rec.position, null, b.position, fnd_api.g_miss_num, null, p_update_field_rec.position),
140: DECODE ( p_update_field_rec.mandatory_flag, null, b.mandatory_flag, fnd_api.g_miss_char, null, p_update_field_rec.mandatory_flag),
141: DECODE ( p_update_field_rec.use_initial_flag, null, b.use_initial_flag, fnd_api.g_miss_char, null, p_update_field_rec.use_initial_flag),
142: DECODE ( p_update_field_rec.uppercase_flag, null, b.uppercase_flag, fnd_api.g_miss_char, null, p_update_field_rec.uppercase_flag),
143: DECODE ( p_update_field_rec.transform_function, null, b.transform_function, fnd_api.g_miss_char, null, p_update_field_rec.transform_function),

Line 140: DECODE ( p_update_field_rec.mandatory_flag, null, b.mandatory_flag, fnd_api.g_miss_char, null, p_update_field_rec.mandatory_flag),

136: b.attribute_code,
137: b.attribute_application_id,
138: DECODE ( p_update_field_rec.line_number, null, b.line_number, fnd_api.g_miss_num, null, p_update_field_rec.line_number),
139: DECODE ( p_update_field_rec.position, null, b.position, fnd_api.g_miss_num, null, p_update_field_rec.position),
140: DECODE ( p_update_field_rec.mandatory_flag, null, b.mandatory_flag, fnd_api.g_miss_char, null, p_update_field_rec.mandatory_flag),
141: DECODE ( p_update_field_rec.use_initial_flag, null, b.use_initial_flag, fnd_api.g_miss_char, null, p_update_field_rec.use_initial_flag),
142: DECODE ( p_update_field_rec.uppercase_flag, null, b.uppercase_flag, fnd_api.g_miss_char, null, p_update_field_rec.uppercase_flag),
143: DECODE ( p_update_field_rec.transform_function, null, b.transform_function, fnd_api.g_miss_char, null, p_update_field_rec.transform_function),
144: DECODE ( p_update_field_rec.delimiter_before, null, b.delimiter_before, fnd_api.g_miss_char, null, p_update_field_rec.delimiter_before),

Line 141: DECODE ( p_update_field_rec.use_initial_flag, null, b.use_initial_flag, fnd_api.g_miss_char, null, p_update_field_rec.use_initial_flag),

137: b.attribute_application_id,
138: DECODE ( p_update_field_rec.line_number, null, b.line_number, fnd_api.g_miss_num, null, p_update_field_rec.line_number),
139: DECODE ( p_update_field_rec.position, null, b.position, fnd_api.g_miss_num, null, p_update_field_rec.position),
140: DECODE ( p_update_field_rec.mandatory_flag, null, b.mandatory_flag, fnd_api.g_miss_char, null, p_update_field_rec.mandatory_flag),
141: DECODE ( p_update_field_rec.use_initial_flag, null, b.use_initial_flag, fnd_api.g_miss_char, null, p_update_field_rec.use_initial_flag),
142: DECODE ( p_update_field_rec.uppercase_flag, null, b.uppercase_flag, fnd_api.g_miss_char, null, p_update_field_rec.uppercase_flag),
143: DECODE ( p_update_field_rec.transform_function, null, b.transform_function, fnd_api.g_miss_char, null, p_update_field_rec.transform_function),
144: DECODE ( p_update_field_rec.delimiter_before, null, b.delimiter_before, fnd_api.g_miss_char, null, p_update_field_rec.delimiter_before),
145: DECODE ( p_update_field_rec.delimiter_after, null, b.delimiter_after, fnd_api.g_miss_char, null, p_update_field_rec.delimiter_after),

Line 142: DECODE ( p_update_field_rec.uppercase_flag, null, b.uppercase_flag, fnd_api.g_miss_char, null, p_update_field_rec.uppercase_flag),

138: DECODE ( p_update_field_rec.line_number, null, b.line_number, fnd_api.g_miss_num, null, p_update_field_rec.line_number),
139: DECODE ( p_update_field_rec.position, null, b.position, fnd_api.g_miss_num, null, p_update_field_rec.position),
140: DECODE ( p_update_field_rec.mandatory_flag, null, b.mandatory_flag, fnd_api.g_miss_char, null, p_update_field_rec.mandatory_flag),
141: DECODE ( p_update_field_rec.use_initial_flag, null, b.use_initial_flag, fnd_api.g_miss_char, null, p_update_field_rec.use_initial_flag),
142: DECODE ( p_update_field_rec.uppercase_flag, null, b.uppercase_flag, fnd_api.g_miss_char, null, p_update_field_rec.uppercase_flag),
143: DECODE ( p_update_field_rec.transform_function, null, b.transform_function, fnd_api.g_miss_char, null, p_update_field_rec.transform_function),
144: DECODE ( p_update_field_rec.delimiter_before, null, b.delimiter_before, fnd_api.g_miss_char, null, p_update_field_rec.delimiter_before),
145: DECODE ( p_update_field_rec.delimiter_after, null, b.delimiter_after, fnd_api.g_miss_char, null, p_update_field_rec.delimiter_after),
146: DECODE ( p_update_field_rec.blank_lines_before, null, b.blank_lines_before, fnd_api.g_miss_num, null, p_update_field_rec.blank_lines_before),

Line 143: DECODE ( p_update_field_rec.transform_function, null, b.transform_function, fnd_api.g_miss_char, null, p_update_field_rec.transform_function),

139: DECODE ( p_update_field_rec.position, null, b.position, fnd_api.g_miss_num, null, p_update_field_rec.position),
140: DECODE ( p_update_field_rec.mandatory_flag, null, b.mandatory_flag, fnd_api.g_miss_char, null, p_update_field_rec.mandatory_flag),
141: DECODE ( p_update_field_rec.use_initial_flag, null, b.use_initial_flag, fnd_api.g_miss_char, null, p_update_field_rec.use_initial_flag),
142: DECODE ( p_update_field_rec.uppercase_flag, null, b.uppercase_flag, fnd_api.g_miss_char, null, p_update_field_rec.uppercase_flag),
143: DECODE ( p_update_field_rec.transform_function, null, b.transform_function, fnd_api.g_miss_char, null, p_update_field_rec.transform_function),
144: DECODE ( p_update_field_rec.delimiter_before, null, b.delimiter_before, fnd_api.g_miss_char, null, p_update_field_rec.delimiter_before),
145: DECODE ( p_update_field_rec.delimiter_after, null, b.delimiter_after, fnd_api.g_miss_char, null, p_update_field_rec.delimiter_after),
146: DECODE ( p_update_field_rec.blank_lines_before, null, b.blank_lines_before, fnd_api.g_miss_num, null, p_update_field_rec.blank_lines_before),
147: DECODE ( p_update_field_rec.blank_lines_after, null, b.blank_lines_after, fnd_api.g_miss_num, null, p_update_field_rec.blank_lines_after),

Line 144: DECODE ( p_update_field_rec.delimiter_before, null, b.delimiter_before, fnd_api.g_miss_char, null, p_update_field_rec.delimiter_before),

140: DECODE ( p_update_field_rec.mandatory_flag, null, b.mandatory_flag, fnd_api.g_miss_char, null, p_update_field_rec.mandatory_flag),
141: DECODE ( p_update_field_rec.use_initial_flag, null, b.use_initial_flag, fnd_api.g_miss_char, null, p_update_field_rec.use_initial_flag),
142: DECODE ( p_update_field_rec.uppercase_flag, null, b.uppercase_flag, fnd_api.g_miss_char, null, p_update_field_rec.uppercase_flag),
143: DECODE ( p_update_field_rec.transform_function, null, b.transform_function, fnd_api.g_miss_char, null, p_update_field_rec.transform_function),
144: DECODE ( p_update_field_rec.delimiter_before, null, b.delimiter_before, fnd_api.g_miss_char, null, p_update_field_rec.delimiter_before),
145: DECODE ( p_update_field_rec.delimiter_after, null, b.delimiter_after, fnd_api.g_miss_char, null, p_update_field_rec.delimiter_after),
146: DECODE ( p_update_field_rec.blank_lines_before, null, b.blank_lines_before, fnd_api.g_miss_num, null, p_update_field_rec.blank_lines_before),
147: DECODE ( p_update_field_rec.blank_lines_after, null, b.blank_lines_after, fnd_api.g_miss_num, null, p_update_field_rec.blank_lines_after),
148: DECODE ( p_update_field_rec.prompt, null, t.prompt, fnd_api.g_miss_char, null, p_update_field_rec.prompt),

Line 145: DECODE ( p_update_field_rec.delimiter_after, null, b.delimiter_after, fnd_api.g_miss_char, null, p_update_field_rec.delimiter_after),

141: DECODE ( p_update_field_rec.use_initial_flag, null, b.use_initial_flag, fnd_api.g_miss_char, null, p_update_field_rec.use_initial_flag),
142: DECODE ( p_update_field_rec.uppercase_flag, null, b.uppercase_flag, fnd_api.g_miss_char, null, p_update_field_rec.uppercase_flag),
143: DECODE ( p_update_field_rec.transform_function, null, b.transform_function, fnd_api.g_miss_char, null, p_update_field_rec.transform_function),
144: DECODE ( p_update_field_rec.delimiter_before, null, b.delimiter_before, fnd_api.g_miss_char, null, p_update_field_rec.delimiter_before),
145: DECODE ( p_update_field_rec.delimiter_after, null, b.delimiter_after, fnd_api.g_miss_char, null, p_update_field_rec.delimiter_after),
146: DECODE ( p_update_field_rec.blank_lines_before, null, b.blank_lines_before, fnd_api.g_miss_num, null, p_update_field_rec.blank_lines_before),
147: DECODE ( p_update_field_rec.blank_lines_after, null, b.blank_lines_after, fnd_api.g_miss_num, null, p_update_field_rec.blank_lines_after),
148: DECODE ( p_update_field_rec.prompt, null, t.prompt, fnd_api.g_miss_char, null, p_update_field_rec.prompt),
149: DECODE ( p_update_field_rec.start_date_active, null, b.start_date_active, fnd_api.g_miss_date, null, p_update_field_rec.start_date_active),

Line 146: DECODE ( p_update_field_rec.blank_lines_before, null, b.blank_lines_before, fnd_api.g_miss_num, null, p_update_field_rec.blank_lines_before),

142: DECODE ( p_update_field_rec.uppercase_flag, null, b.uppercase_flag, fnd_api.g_miss_char, null, p_update_field_rec.uppercase_flag),
143: DECODE ( p_update_field_rec.transform_function, null, b.transform_function, fnd_api.g_miss_char, null, p_update_field_rec.transform_function),
144: DECODE ( p_update_field_rec.delimiter_before, null, b.delimiter_before, fnd_api.g_miss_char, null, p_update_field_rec.delimiter_before),
145: DECODE ( p_update_field_rec.delimiter_after, null, b.delimiter_after, fnd_api.g_miss_char, null, p_update_field_rec.delimiter_after),
146: DECODE ( p_update_field_rec.blank_lines_before, null, b.blank_lines_before, fnd_api.g_miss_num, null, p_update_field_rec.blank_lines_before),
147: DECODE ( p_update_field_rec.blank_lines_after, null, b.blank_lines_after, fnd_api.g_miss_num, null, p_update_field_rec.blank_lines_after),
148: DECODE ( p_update_field_rec.prompt, null, t.prompt, fnd_api.g_miss_char, null, p_update_field_rec.prompt),
149: DECODE ( p_update_field_rec.start_date_active, null, b.start_date_active, fnd_api.g_miss_date, null, p_update_field_rec.start_date_active),
150: DECODE ( p_update_field_rec.end_date_active, null, b.end_date_active, fnd_api.g_miss_date, null, p_update_field_rec.end_date_active)

Line 147: DECODE ( p_update_field_rec.blank_lines_after, null, b.blank_lines_after, fnd_api.g_miss_num, null, p_update_field_rec.blank_lines_after),

143: DECODE ( p_update_field_rec.transform_function, null, b.transform_function, fnd_api.g_miss_char, null, p_update_field_rec.transform_function),
144: DECODE ( p_update_field_rec.delimiter_before, null, b.delimiter_before, fnd_api.g_miss_char, null, p_update_field_rec.delimiter_before),
145: DECODE ( p_update_field_rec.delimiter_after, null, b.delimiter_after, fnd_api.g_miss_char, null, p_update_field_rec.delimiter_after),
146: DECODE ( p_update_field_rec.blank_lines_before, null, b.blank_lines_before, fnd_api.g_miss_num, null, p_update_field_rec.blank_lines_before),
147: DECODE ( p_update_field_rec.blank_lines_after, null, b.blank_lines_after, fnd_api.g_miss_num, null, p_update_field_rec.blank_lines_after),
148: DECODE ( p_update_field_rec.prompt, null, t.prompt, fnd_api.g_miss_char, null, p_update_field_rec.prompt),
149: DECODE ( p_update_field_rec.start_date_active, null, b.start_date_active, fnd_api.g_miss_date, null, p_update_field_rec.start_date_active),
150: DECODE ( p_update_field_rec.end_date_active, null, b.end_date_active, fnd_api.g_miss_date, null, p_update_field_rec.end_date_active)
151: INTO

Line 148: DECODE ( p_update_field_rec.prompt, null, t.prompt, fnd_api.g_miss_char, null, p_update_field_rec.prompt),

144: DECODE ( p_update_field_rec.delimiter_before, null, b.delimiter_before, fnd_api.g_miss_char, null, p_update_field_rec.delimiter_before),
145: DECODE ( p_update_field_rec.delimiter_after, null, b.delimiter_after, fnd_api.g_miss_char, null, p_update_field_rec.delimiter_after),
146: DECODE ( p_update_field_rec.blank_lines_before, null, b.blank_lines_before, fnd_api.g_miss_num, null, p_update_field_rec.blank_lines_before),
147: DECODE ( p_update_field_rec.blank_lines_after, null, b.blank_lines_after, fnd_api.g_miss_num, null, p_update_field_rec.blank_lines_after),
148: DECODE ( p_update_field_rec.prompt, null, t.prompt, fnd_api.g_miss_char, null, p_update_field_rec.prompt),
149: DECODE ( p_update_field_rec.start_date_active, null, b.start_date_active, fnd_api.g_miss_date, null, p_update_field_rec.start_date_active),
150: DECODE ( p_update_field_rec.end_date_active, null, b.end_date_active, fnd_api.g_miss_date, null, p_update_field_rec.end_date_active)
151: INTO
152: x_updated_rec.style_fmt_layout_id,

Line 149: DECODE ( p_update_field_rec.start_date_active, null, b.start_date_active, fnd_api.g_miss_date, null, p_update_field_rec.start_date_active),

145: DECODE ( p_update_field_rec.delimiter_after, null, b.delimiter_after, fnd_api.g_miss_char, null, p_update_field_rec.delimiter_after),
146: DECODE ( p_update_field_rec.blank_lines_before, null, b.blank_lines_before, fnd_api.g_miss_num, null, p_update_field_rec.blank_lines_before),
147: DECODE ( p_update_field_rec.blank_lines_after, null, b.blank_lines_after, fnd_api.g_miss_num, null, p_update_field_rec.blank_lines_after),
148: DECODE ( p_update_field_rec.prompt, null, t.prompt, fnd_api.g_miss_char, null, p_update_field_rec.prompt),
149: DECODE ( p_update_field_rec.start_date_active, null, b.start_date_active, fnd_api.g_miss_date, null, p_update_field_rec.start_date_active),
150: DECODE ( p_update_field_rec.end_date_active, null, b.end_date_active, fnd_api.g_miss_date, null, p_update_field_rec.end_date_active)
151: INTO
152: x_updated_rec.style_fmt_layout_id,
153: x_updated_rec.style_format_code,

Line 150: DECODE ( p_update_field_rec.end_date_active, null, b.end_date_active, fnd_api.g_miss_date, null, p_update_field_rec.end_date_active)

146: DECODE ( p_update_field_rec.blank_lines_before, null, b.blank_lines_before, fnd_api.g_miss_num, null, p_update_field_rec.blank_lines_before),
147: DECODE ( p_update_field_rec.blank_lines_after, null, b.blank_lines_after, fnd_api.g_miss_num, null, p_update_field_rec.blank_lines_after),
148: DECODE ( p_update_field_rec.prompt, null, t.prompt, fnd_api.g_miss_char, null, p_update_field_rec.prompt),
149: DECODE ( p_update_field_rec.start_date_active, null, b.start_date_active, fnd_api.g_miss_date, null, p_update_field_rec.start_date_active),
150: DECODE ( p_update_field_rec.end_date_active, null, b.end_date_active, fnd_api.g_miss_date, null, p_update_field_rec.end_date_active)
151: INTO
152: x_updated_rec.style_fmt_layout_id,
153: x_updated_rec.style_format_code,
154: x_updated_rec.variation_number,

Line 202: -- be FND_API.G_RET_STS_SUCCESS (success),

198: -- p_style_rec Style record.
199: -- p_rowid Rowid of the record (used only in update mode).
200: -- IN/OUT:
201: -- x_return_status Return status after the call. The status can
202: -- be FND_API.G_RET_STS_SUCCESS (success),
203: -- FND_API.G_RET_STS_ERROR (error),
204: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
205: --
206: -- NOTES

Line 203: -- FND_API.G_RET_STS_ERROR (error),

199: -- p_rowid Rowid of the record (used only in update mode).
200: -- IN/OUT:
201: -- x_return_status Return status after the call. The status can
202: -- be FND_API.G_RET_STS_SUCCESS (success),
203: -- FND_API.G_RET_STS_ERROR (error),
204: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
205: --
206: -- NOTES
207: --

Line 204: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

200: -- IN/OUT:
201: -- x_return_status Return status after the call. The status can
202: -- be FND_API.G_RET_STS_SUCCESS (success),
203: -- FND_API.G_RET_STS_ERROR (error),
204: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
205: --
206: -- NOTES
207: --
208: -- MODIFICATION HISTORY

Line 303: x_return_status := FND_API.G_RET_STS_ERROR;

299:
300: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
301: FND_MESSAGE.SET_TOKEN('COLUMN', 'style_code');
302: FND_MSG_PUB.ADD;
303: x_return_status := FND_API.G_RET_STS_ERROR;
304:
305: EXCEPTION
306: WHEN NO_DATA_FOUND THEN
307: NULL;

Line 359: p_style_rec.database_object_name <> fnd_api.g_miss_char

355:
356: -- database_object_name has foreign key fnd_tables.table_name
357: IF p_style_rec.database_object_name IS NOT NULL
358: AND
359: p_style_rec.database_object_name <> fnd_api.g_miss_char
360: THEN
361: BEGIN
362:
363: SELECT 'Y'

Line 375: x_return_status := fnd_api.g_ret_sts_error;

371: fnd_message.set_token('FK', 'database_object_name');
372: fnd_message.set_token('COLUMN', 'table_name');
373: fnd_message.set_token('TABLE', 'fnd_tables');
374: fnd_msg_pub.add;
375: x_return_status := fnd_api.g_ret_sts_error;
376: END;
377:
378: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
379: hz_utility_v2pub.debug(p_message=>'database_object_name has foreign key fnd_tables.table_name. ' ||

Line 436: x_return_status := FND_API.G_RET_STS_ERROR;

432: and language = userenv('LANG');
433:
434: FND_MESSAGE.SET_NAME('AR', 'HZ_STYLE_NAME_DUP');
435: FND_MSG_PUB.ADD;
436: x_return_status := FND_API.G_RET_STS_ERROR;
437:
438: EXCEPTION
439: WHEN NO_DATA_FOUND THEN
440: NULL;

Line 480: -- be FND_API.G_RET_STS_SUCCESS (success),

476: -- p_style_format_rec Style Format record.
477: -- p_rowid Rowid of the record (used only in update mode).
478: -- IN/OUT:
479: -- x_return_status Return status after the call. The status can
480: -- be FND_API.G_RET_STS_SUCCESS (success),
481: -- FND_API.G_RET_STS_ERROR (error),
482: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
483: --
484: -- NOTES

Line 481: -- FND_API.G_RET_STS_ERROR (error),

477: -- p_rowid Rowid of the record (used only in update mode).
478: -- IN/OUT:
479: -- x_return_status Return status after the call. The status can
480: -- be FND_API.G_RET_STS_SUCCESS (success),
481: -- FND_API.G_RET_STS_ERROR (error),
482: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
483: --
484: -- NOTES
485: --

Line 482: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

478: -- IN/OUT:
479: -- x_return_status Return status after the call. The status can
480: -- be FND_API.G_RET_STS_SUCCESS (success),
481: -- FND_API.G_RET_STS_ERROR (error),
482: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
483: --
484: -- NOTES
485: --
486: -- MODIFICATION HISTORY

Line 585: x_return_status := FND_API.G_RET_STS_ERROR;

581:
582: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
583: FND_MESSAGE.SET_TOKEN('COLUMN', 'style_format_code');
584: FND_MSG_PUB.ADD;
585: x_return_status := FND_API.G_RET_STS_ERROR;
586:
587: EXCEPTION
588: WHEN NO_DATA_FOUND THEN
589: NULL;

Line 645: p_style_format_rec.style_code <> fnd_api.g_miss_CHAR

641: IF p_create_update_flag = 'C'
642: AND
643: p_style_format_rec.style_code IS NOT NULL
644: AND
645: p_style_format_rec.style_code <> fnd_api.g_miss_CHAR
646: THEN
647: BEGIN
648: SELECT 'Y'
649: INTO l_dummy

Line 659: x_return_status := fnd_api.g_ret_sts_error;

655: fnd_message.set_token('FK', 'style_code');
656: fnd_message.set_token('COLUMN', 'style_code');
657: fnd_message.set_token('TABLE', 'hz_styles_b');
658: fnd_msg_pub.add;
659: x_return_status := fnd_api.g_ret_sts_error;
660: END;
661:
662: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
663: hz_utility_v2pub.debug(p_message=>'style_code is foreign key of hz_styles_b. ' ||

Line 728: x_return_status := fnd_api.g_ret_sts_error;

724: l_default_flag = 'Y'
725: THEN
726: fnd_message.set_name('AR', 'HZ_STL_FMT_FLAG_NOT_Y_TO_N');
727: fnd_msg_pub.add;
728: x_return_status := fnd_api.g_ret_sts_error;
729:
730: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
731: hz_utility_v2pub.debug(p_message=>'default_flag cannot be set from Yes to No. ' ||
732: 'x_return_status = ' || x_return_status,

Line 788: x_return_status := FND_API.G_RET_STS_ERROR;

784: and language = userenv('LANG');
785:
786: FND_MESSAGE.SET_NAME('AR', 'HZ_STYLE_FMT_NAME_DUP');
787: FND_MSG_PUB.ADD;
788: x_return_status := FND_API.G_RET_STS_ERROR;
789:
790: EXCEPTION
791: WHEN NO_DATA_FOUND THEN
792: NULL;

Line 833: -- be FND_API.G_RET_STS_SUCCESS (success),

829: -- p_style_fmt_locale_rec Style Locale record.
830: -- p_rowid Rowid of the record (used only in update mode).
831: -- IN/OUT:
832: -- x_return_status Return status after the call. The status can
833: -- be FND_API.G_RET_STS_SUCCESS (success),
834: -- FND_API.G_RET_STS_ERROR (error),
835: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
836: --
837: -- NOTES

Line 834: -- FND_API.G_RET_STS_ERROR (error),

830: -- p_rowid Rowid of the record (used only in update mode).
831: -- IN/OUT:
832: -- x_return_status Return status after the call. The status can
833: -- be FND_API.G_RET_STS_SUCCESS (success),
834: -- FND_API.G_RET_STS_ERROR (error),
835: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
836: --
837: -- NOTES
838: --

Line 835: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

831: -- IN/OUT:
832: -- x_return_status Return status after the call. The status can
833: -- be FND_API.G_RET_STS_SUCCESS (success),
834: -- FND_API.G_RET_STS_ERROR (error),
835: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
836: --
837: -- NOTES
838: --
839: -- MODIFICATION HISTORY

Line 909: p_style_fmt_locale_rec.style_fmt_locale_id <> fnd_api.g_miss_num

905: -- from sequence by table handler.
906:
907: IF p_create_update_flag = 'C' THEN
908: IF p_style_fmt_locale_rec.style_fmt_locale_id IS NOT NULL AND
909: p_style_fmt_locale_rec.style_fmt_locale_id <> fnd_api.g_miss_num
910: THEN
911: OPEN c_dup (p_style_fmt_locale_rec.style_fmt_locale_id);
912: FETCH c_dup INTO l_dummy;
913: -- key is not unique, push an error onto the stack.

Line 918: x_return_status := fnd_api.g_ret_sts_error;

914: IF NVL(c_dup%FOUND, FALSE) THEN
915: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
916: fnd_message.set_token('COLUMN', 'style_fmt_locale_id');
917: fnd_msg_pub.add;
918: x_return_status := fnd_api.g_ret_sts_error;
919: END IF;
920: CLOSE c_dup;
921: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
922: hz_utility_v2pub.debug(p_message=>'check that style_fmt_locale_id is unique during creation. ' ||

Line 984: p_style_fmt_locale_rec.style_format_code <> fnd_api.g_miss_CHAR

980: IF p_create_update_flag = 'C'
981: AND
982: p_style_fmt_locale_rec.style_format_code IS NOT NULL
983: AND
984: p_style_fmt_locale_rec.style_format_code <> fnd_api.g_miss_CHAR
985: THEN
986: BEGIN
987: SELECT 'Y'
988: INTO l_dummy

Line 998: x_return_status := fnd_api.g_ret_sts_error;

994: fnd_message.set_token('FK', 'style_format_code');
995: fnd_message.set_token('COLUMN', 'style_format_code');
996: fnd_message.set_token('TABLE', 'hz_style_formats_b');
997: fnd_msg_pub.add;
998: x_return_status := fnd_api.g_ret_sts_error;
999: END;
1000: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1001: hz_utility_v2pub.debug(p_message=>'style_format_code is foreign key of hz_style_formats_b. ' ||
1002: 'x_return_status = ' || x_return_status,

Line 1038: p_style_fmt_locale_rec.language_code <> fnd_api.g_miss_CHAR

1034: IF p_create_update_flag = 'C'
1035: AND
1036: p_style_fmt_locale_rec.language_code IS NOT NULL
1037: AND
1038: p_style_fmt_locale_rec.language_code <> fnd_api.g_miss_CHAR
1039: THEN
1040: BEGIN
1041: SELECT 'Y'
1042: INTO l_dummy

Line 1052: x_return_status := fnd_api.g_ret_sts_error;

1048: fnd_message.set_token('FK', 'language_code');
1049: fnd_message.set_token('COLUMN', 'language_code');
1050: fnd_message.set_token('TABLE', 'fnd_languages');
1051: fnd_msg_pub.add;
1052: x_return_status := fnd_api.g_ret_sts_error;
1053: END;
1054: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1055: hz_utility_v2pub.debug(p_message=>'language_code is foreign key of fnd_languages. ' ||
1056: 'x_return_status = ' || x_return_status,

Line 1092: p_style_fmt_locale_rec.territory_code <> fnd_api.g_miss_CHAR

1088: IF p_create_update_flag = 'C'
1089: AND
1090: p_style_fmt_locale_rec.territory_code IS NOT NULL
1091: AND
1092: p_style_fmt_locale_rec.territory_code <> fnd_api.g_miss_CHAR
1093: THEN
1094: BEGIN
1095: SELECT 'Y'
1096: INTO l_dummy

Line 1106: x_return_status := fnd_api.g_ret_sts_error;

1102: fnd_message.set_token('FK', 'territory_code');
1103: fnd_message.set_token('COLUMN', 'territory_code');
1104: fnd_message.set_token('TABLE', 'fnd_territories');
1105: fnd_msg_pub.add;
1106: x_return_status := fnd_api.g_ret_sts_error;
1107: END;
1108: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1109: hz_utility_v2pub.debug(p_message=>'territory_code is foreign key of fnd_territories. ' ||
1110: 'x_return_status = ' || x_return_status,

Line 1123: (p_style_fmt_locale_rec.language_code <> fnd_api.g_miss_char) OR

1119:
1120: -- Either language_code or territory_code must have a value
1121: IF p_create_update_flag = 'C' AND
1122: not ((p_style_fmt_locale_rec.language_code IS NOT NULL AND
1123: (p_style_fmt_locale_rec.language_code <> fnd_api.g_miss_char) OR
1124: (p_style_fmt_locale_rec.territory_code IS NOT NULL ) AND
1125: p_style_fmt_locale_rec.territory_code <> fnd_api.g_miss_char ) )
1126: THEN
1127: FND_MESSAGE.SET_NAME('AR', 'HZ_STL_FMT_LOC_MISSING_COLUMN');

Line 1125: p_style_fmt_locale_rec.territory_code <> fnd_api.g_miss_char ) )

1121: IF p_create_update_flag = 'C' AND
1122: not ((p_style_fmt_locale_rec.language_code IS NOT NULL AND
1123: (p_style_fmt_locale_rec.language_code <> fnd_api.g_miss_char) OR
1124: (p_style_fmt_locale_rec.territory_code IS NOT NULL ) AND
1125: p_style_fmt_locale_rec.territory_code <> fnd_api.g_miss_char ) )
1126: THEN
1127: FND_MESSAGE.SET_NAME('AR', 'HZ_STL_FMT_LOC_MISSING_COLUMN');
1128: FND_MSG_PUB.ADD;
1129: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1129: x_return_status := FND_API.G_RET_STS_ERROR;

1125: p_style_fmt_locale_rec.territory_code <> fnd_api.g_miss_char ) )
1126: THEN
1127: FND_MESSAGE.SET_NAME('AR', 'HZ_STL_FMT_LOC_MISSING_COLUMN');
1128: FND_MSG_PUB.ADD;
1129: x_return_status := FND_API.G_RET_STS_ERROR;
1130:
1131: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1132: hz_utility_v2pub.debug(p_message=>'Either language_code or territory_code must have a value. ' ||
1133: 'x_return_status = ' || x_return_status,

Line 1184: p_style_fmt_locale_rec.end_date_active <> fnd_api.g_miss_date AND

1180:
1181: -- end_date_active must be null or greater than start date
1182: IF (p_create_update_flag = 'C') THEN
1183: IF p_style_fmt_locale_rec.end_date_active IS NOT NULL AND
1184: p_style_fmt_locale_rec.end_date_active <> fnd_api.g_miss_date AND
1185: p_style_fmt_locale_rec.end_date_active < p_style_fmt_locale_rec.start_date_active
1186: THEN
1187: fnd_message.set_name('AR', 'HZ_API_START_DATE_GREATER');
1188: fnd_msg_pub.add;

Line 1189: x_return_status := fnd_api.g_ret_sts_error;

1185: p_style_fmt_locale_rec.end_date_active < p_style_fmt_locale_rec.start_date_active
1186: THEN
1187: fnd_message.set_name('AR', 'HZ_API_START_DATE_GREATER');
1188: fnd_msg_pub.add;
1189: x_return_status := fnd_api.g_ret_sts_error;
1190: END IF;
1191: ELSIF (p_create_update_flag = 'U') THEN
1192: -- old start_date_active, end_date_active has been selected from table
1193: -- and put into l_start_date_active, l_end_date_active

Line 1195: IF p_style_fmt_locale_rec.start_date_active <> fnd_api.g_miss_date

1191: ELSIF (p_create_update_flag = 'U') THEN
1192: -- old start_date_active, end_date_active has been selected from table
1193: -- and put into l_start_date_active, l_end_date_active
1194:
1195: IF p_style_fmt_locale_rec.start_date_active <> fnd_api.g_miss_date
1196: AND p_style_fmt_locale_rec.start_date_active is not null
1197: THEN
1198: l_start_date_active := p_style_fmt_locale_rec.start_date_active;
1199: END IF;

Line 1201: IF p_style_fmt_locale_rec.end_date_active = fnd_api.g_miss_date

1197: THEN
1198: l_start_date_active := p_style_fmt_locale_rec.start_date_active;
1199: END IF;
1200:
1201: IF p_style_fmt_locale_rec.end_date_active = fnd_api.g_miss_date
1202: THEN
1203: l_end_date_active := null;
1204: ELSIF p_style_fmt_locale_rec.end_date_active IS NOT NULL THEN
1205: l_end_date_active := p_style_fmt_locale_rec.end_date_active;

Line 1213: x_return_status := fnd_api.g_ret_sts_error;

1209: AND l_end_date_active < l_start_date_active
1210: THEN
1211: fnd_message.set_name('AR', 'HZ_API_START_DATE_GREATER');
1212: fnd_msg_pub.add;
1213: x_return_status := fnd_api.g_ret_sts_error;
1214: END IF;
1215: END IF;
1216: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1217: hz_utility_v2pub.debug(p_message=>'end_date_active must be null or greater than start date. ' ||

Line 1239: decode(language_code, null, fnd_api.g_miss_char, language_code) = NVL( p_style_fmt_locale_rec.language_code, fnd_api.g_miss_char) AND

1235: BEGIN
1236: select style_fmt_locale_id into l_dup_style_fmt_locale_id
1237: from HZ_STYLE_FMT_LOCALES
1238: where style_format_code = p_style_fmt_locale_rec.style_format_code AND
1239: decode(language_code, null, fnd_api.g_miss_char, language_code) = NVL( p_style_fmt_locale_rec.language_code, fnd_api.g_miss_char) AND
1240: decode(territory_code, null, fnd_api.g_miss_char, territory_code) = NVL(p_style_fmt_locale_rec.territory_code, fnd_api.g_miss_char) AND
1241: NOT ( ( p_style_fmt_locale_rec.end_date_active is not null and
1242: p_style_fmt_locale_rec.end_date_active <> fnd_api.g_miss_date and
1243: p_style_fmt_locale_rec.end_date_active < start_date_active ) OR

Line 1240: decode(territory_code, null, fnd_api.g_miss_char, territory_code) = NVL(p_style_fmt_locale_rec.territory_code, fnd_api.g_miss_char) AND

1236: select style_fmt_locale_id into l_dup_style_fmt_locale_id
1237: from HZ_STYLE_FMT_LOCALES
1238: where style_format_code = p_style_fmt_locale_rec.style_format_code AND
1239: decode(language_code, null, fnd_api.g_miss_char, language_code) = NVL( p_style_fmt_locale_rec.language_code, fnd_api.g_miss_char) AND
1240: decode(territory_code, null, fnd_api.g_miss_char, territory_code) = NVL(p_style_fmt_locale_rec.territory_code, fnd_api.g_miss_char) AND
1241: NOT ( ( p_style_fmt_locale_rec.end_date_active is not null and
1242: p_style_fmt_locale_rec.end_date_active <> fnd_api.g_miss_date and
1243: p_style_fmt_locale_rec.end_date_active < start_date_active ) OR
1244: ( end_date_active is not null and

Line 1242: p_style_fmt_locale_rec.end_date_active <> fnd_api.g_miss_date and

1238: where style_format_code = p_style_fmt_locale_rec.style_format_code AND
1239: decode(language_code, null, fnd_api.g_miss_char, language_code) = NVL( p_style_fmt_locale_rec.language_code, fnd_api.g_miss_char) AND
1240: decode(territory_code, null, fnd_api.g_miss_char, territory_code) = NVL(p_style_fmt_locale_rec.territory_code, fnd_api.g_miss_char) AND
1241: NOT ( ( p_style_fmt_locale_rec.end_date_active is not null and
1242: p_style_fmt_locale_rec.end_date_active <> fnd_api.g_miss_date and
1243: p_style_fmt_locale_rec.end_date_active < start_date_active ) OR
1244: ( end_date_active is not null and
1245: p_style_fmt_locale_rec.start_date_active > end_date_active )) AND
1246: rownum =1;

Line 1250: x_return_status := FND_API.G_RET_STS_ERROR;

1246: rownum =1;
1247:
1248: FND_MESSAGE.SET_NAME('AR', 'HZ_STYLE_LOC_DUPLICATE_RECORD');
1249: FND_MSG_PUB.ADD;
1250: x_return_status := FND_API.G_RET_STS_ERROR;
1251:
1252: EXCEPTION
1253: WHEN NO_DATA_FOUND THEN
1254: NULL;

Line 1278: decode(language_code, null, fnd_api.g_miss_char, language_code) = NVL( l_updated_stl_fmt_rec.language_code, fnd_api.g_miss_char) AND

1274: select style_fmt_locale_id into l_dup_style_fmt_locale_id
1275: from HZ_STYLE_FMT_LOCALES
1276: where style_fmt_locale_id <> l_updated_stl_fmt_rec.style_fmt_locale_id AND
1277: style_format_code = l_updated_stl_fmt_rec.style_format_code AND
1278: decode(language_code, null, fnd_api.g_miss_char, language_code) = NVL( l_updated_stl_fmt_rec.language_code, fnd_api.g_miss_char) AND
1279: decode(territory_code, null, fnd_api.g_miss_char, territory_code) = NVL(l_updated_stl_fmt_rec.territory_code, fnd_api.g_miss_char) AND
1280: NOT ( ( l_updated_stl_fmt_rec.end_date_active is not null and
1281: l_updated_stl_fmt_rec.end_date_active < start_date_active ) OR
1282: ( end_date_active is not null and

Line 1279: decode(territory_code, null, fnd_api.g_miss_char, territory_code) = NVL(l_updated_stl_fmt_rec.territory_code, fnd_api.g_miss_char) AND

1275: from HZ_STYLE_FMT_LOCALES
1276: where style_fmt_locale_id <> l_updated_stl_fmt_rec.style_fmt_locale_id AND
1277: style_format_code = l_updated_stl_fmt_rec.style_format_code AND
1278: decode(language_code, null, fnd_api.g_miss_char, language_code) = NVL( l_updated_stl_fmt_rec.language_code, fnd_api.g_miss_char) AND
1279: decode(territory_code, null, fnd_api.g_miss_char, territory_code) = NVL(l_updated_stl_fmt_rec.territory_code, fnd_api.g_miss_char) AND
1280: NOT ( ( l_updated_stl_fmt_rec.end_date_active is not null and
1281: l_updated_stl_fmt_rec.end_date_active < start_date_active ) OR
1282: ( end_date_active is not null and
1283: l_updated_stl_fmt_rec.start_date_active > end_date_active )) AND

Line 1293: x_return_status := FND_API.G_RET_STS_ERROR;

1289: FND_MESSAGE.SET_TOKEN( 'ID', to_char(l_dup_style_fmt_locale_id) );
1290: FND_MESSAGE.SET_TOKEN( 'ALLCOLUMNS', 'style_format_code, language_code, territory_code validation' );
1291:
1292: FND_MSG_PUB.ADD;
1293: x_return_status := FND_API.G_RET_STS_ERROR;
1294:
1295: EXCEPTION
1296: WHEN NO_DATA_FOUND THEN
1297: NULL;

Line 1339: -- be FND_API.G_RET_STS_SUCCESS (success),

1335: -- p_style_fmt_variation_rec Style Locale record.
1336: -- p_rowid Rowid of the record (used only in update mode).
1337: -- IN/OUT:
1338: -- x_return_status Return status after the call. The status can
1339: -- be FND_API.G_RET_STS_SUCCESS (success),
1340: -- FND_API.G_RET_STS_ERROR (error),
1341: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1342: --
1343: -- NOTES

Line 1340: -- FND_API.G_RET_STS_ERROR (error),

1336: -- p_rowid Rowid of the record (used only in update mode).
1337: -- IN/OUT:
1338: -- x_return_status Return status after the call. The status can
1339: -- be FND_API.G_RET_STS_SUCCESS (success),
1340: -- FND_API.G_RET_STS_ERROR (error),
1341: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1342: --
1343: -- NOTES
1344: --

Line 1341: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

1337: -- IN/OUT:
1338: -- x_return_status Return status after the call. The status can
1339: -- be FND_API.G_RET_STS_SUCCESS (success),
1340: -- FND_API.G_RET_STS_ERROR (error),
1341: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1342: --
1343: -- NOTES
1344: --
1345: -- MODIFICATION HISTORY

Line 1441: p_style_fmt_variation_rec.style_format_code <> fnd_api.g_miss_CHAR

1437: IF p_create_update_flag = 'C'
1438: AND
1439: p_style_fmt_variation_rec.style_format_code IS NOT NULL
1440: AND
1441: p_style_fmt_variation_rec.style_format_code <> fnd_api.g_miss_CHAR
1442: THEN
1443: BEGIN
1444: SELECT 'Y'
1445: INTO l_dummy

Line 1455: x_return_status := fnd_api.g_ret_sts_error;

1451: fnd_message.set_token('FK', 'style_format_code');
1452: fnd_message.set_token('COLUMN', 'style_format_code');
1453: fnd_message.set_token('TABLE', 'hz_style_formats_b');
1454: fnd_msg_pub.add;
1455: x_return_status := fnd_api.g_ret_sts_error;
1456: END;
1457: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1458: hz_utility_v2pub.debug(p_message=>'style_format_code is foreign key of hz_style_formats_b. ' ||
1459: 'x_return_status = ' || x_return_status,

Line 1515: x_return_status := FND_API.G_RET_STS_ERROR;

1511: and style_format_code = p_style_fmt_variation_rec.style_format_code;
1512:
1513: FND_MESSAGE.SET_NAME('AR', 'HZ_VARIATION_NO_DUP');
1514: FND_MSG_PUB.ADD;
1515: x_return_status := FND_API.G_RET_STS_ERROR;
1516:
1517: EXCEPTION
1518: WHEN NO_DATA_FOUND THEN
1519: NULL;

Line 1582: x_return_status := FND_API.G_RET_STS_ERROR;

1578: and style_format_code = p_style_fmt_variation_rec.style_format_code;
1579:
1580: FND_MESSAGE.SET_NAME('AR', 'HZ_VARIATION_RANK_DUP');
1581: FND_MSG_PUB.ADD;
1582: x_return_status := FND_API.G_RET_STS_ERROR;
1583:
1584: EXCEPTION
1585: WHEN NO_DATA_FOUND THEN
1586: NULL;

Line 1618: p_style_fmt_variation_rec.variation_rank <> fnd_api.g_miss_num AND

1614: IF (p_create_update_flag = 'C' AND
1615: p_style_fmt_variation_rec.variation_rank is not null ) OR
1616: (p_create_update_flag = 'U' AND
1617: p_style_fmt_variation_rec.variation_rank is not null AND
1618: p_style_fmt_variation_rec.variation_rank <> fnd_api.g_miss_num AND
1619: p_style_fmt_variation_rec.variation_rank <> l_variation_rank)
1620: THEN
1621: check_greater_than_zero (
1622: p_column => 'variation_rank',

Line 1676: p_style_fmt_variation_rec.end_date_active <> fnd_api.g_miss_date AND

1672:
1673: -- end_date_active must be null or greater than start date
1674: IF (p_create_update_flag = 'C') THEN
1675: IF p_style_fmt_variation_rec.end_date_active IS NOT NULL AND
1676: p_style_fmt_variation_rec.end_date_active <> fnd_api.g_miss_date AND
1677: p_style_fmt_variation_rec.end_date_active < p_style_fmt_variation_rec.start_date_active
1678: THEN
1679: fnd_message.set_name('AR', 'HZ_API_START_DATE_GREATER');
1680: fnd_msg_pub.add;

Line 1681: x_return_status := fnd_api.g_ret_sts_error;

1677: p_style_fmt_variation_rec.end_date_active < p_style_fmt_variation_rec.start_date_active
1678: THEN
1679: fnd_message.set_name('AR', 'HZ_API_START_DATE_GREATER');
1680: fnd_msg_pub.add;
1681: x_return_status := fnd_api.g_ret_sts_error;
1682: END IF;
1683: ELSIF (p_create_update_flag = 'U') THEN
1684: -- old start_date_active, end_date_active has been selected from table
1685: -- and put into l_start_date_active, l_end_date_active

Line 1687: IF p_style_fmt_variation_rec.start_date_active <> fnd_api.g_miss_date

1683: ELSIF (p_create_update_flag = 'U') THEN
1684: -- old start_date_active, end_date_active has been selected from table
1685: -- and put into l_start_date_active, l_end_date_active
1686:
1687: IF p_style_fmt_variation_rec.start_date_active <> fnd_api.g_miss_date
1688: AND p_style_fmt_variation_rec.start_date_active is not null
1689: THEN
1690: l_start_date_active := p_style_fmt_variation_rec.start_date_active;
1691: END IF;

Line 1693: IF p_style_fmt_variation_rec.end_date_active = fnd_api.g_miss_date

1689: THEN
1690: l_start_date_active := p_style_fmt_variation_rec.start_date_active;
1691: END IF;
1692:
1693: IF p_style_fmt_variation_rec.end_date_active = fnd_api.g_miss_date
1694: THEN
1695: l_end_date_active := null;
1696: ELSIF p_style_fmt_variation_rec.end_date_active IS NOT NULL THEN
1697: l_end_date_active := p_style_fmt_variation_rec.end_date_active;

Line 1705: x_return_status := fnd_api.g_ret_sts_error;

1701: AND l_end_date_active < l_start_date_active
1702: THEN
1703: fnd_message.set_name('AR', 'HZ_API_START_DATE_GREATER');
1704: fnd_msg_pub.add;
1705: x_return_status := fnd_api.g_ret_sts_error;
1706: END IF;
1707: END IF;
1708:
1709: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1746: -- be FND_API.G_RET_STS_SUCCESS (success),

1742: -- p_style_fmt_layout_rec Style Locale record.
1743: -- p_rowid Rowid of the record (used only in update mode).
1744: -- IN/OUT:
1745: -- x_return_status Return status after the call. The status can
1746: -- be FND_API.G_RET_STS_SUCCESS (success),
1747: -- FND_API.G_RET_STS_ERROR (error),
1748: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1749: --
1750: -- NOTES

Line 1747: -- FND_API.G_RET_STS_ERROR (error),

1743: -- p_rowid Rowid of the record (used only in update mode).
1744: -- IN/OUT:
1745: -- x_return_status Return status after the call. The status can
1746: -- be FND_API.G_RET_STS_SUCCESS (success),
1747: -- FND_API.G_RET_STS_ERROR (error),
1748: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1749: --
1750: -- NOTES
1751: --

Line 1748: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

1744: -- IN/OUT:
1745: -- x_return_status Return status after the call. The status can
1746: -- be FND_API.G_RET_STS_SUCCESS (success),
1747: -- FND_API.G_RET_STS_ERROR (error),
1748: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1749: --
1750: -- NOTES
1751: --
1752: -- MODIFICATION HISTORY

Line 1855: p_style_fmt_layout_rec.style_fmt_layout_id <> fnd_api.g_miss_num

1851: -- from sequence by table handler.
1852:
1853: IF p_create_update_flag = 'C' THEN
1854: IF p_style_fmt_layout_rec.style_fmt_layout_id IS NOT NULL AND
1855: p_style_fmt_layout_rec.style_fmt_layout_id <> fnd_api.g_miss_num
1856: THEN
1857: OPEN c_dup (p_style_fmt_layout_rec.style_fmt_layout_id);
1858: FETCH c_dup INTO l_dummy;
1859: -- key is not unique, push an error onto the stack.

Line 1864: x_return_status := fnd_api.g_ret_sts_error;

1860: IF NVL(c_dup%FOUND, FALSE) THEN
1861: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
1862: fnd_message.set_token('COLUMN', 'style_fmt_layout_id');
1863: fnd_msg_pub.add;
1864: x_return_status := fnd_api.g_ret_sts_error;
1865: END IF;
1866: CLOSE c_dup;
1867: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1868: hz_utility_v2pub.debug(p_message=>'check that style_fmt_layout_id is unique during creation. ' ||

Line 1986: p_style_fmt_layout_rec.style_format_code <> fnd_api.g_miss_CHAR AND

1982: -- Do not need to check during update because style_format_code is
1983: -- non-updateable.
1984: IF p_create_update_flag = 'C' AND
1985: p_style_fmt_layout_rec.style_format_code IS NOT NULL AND
1986: p_style_fmt_layout_rec.style_format_code <> fnd_api.g_miss_CHAR AND
1987: p_style_fmt_layout_rec.variation_number IS NOT NULL AND
1988: p_style_fmt_layout_rec.variation_number <> fnd_api.g_miss_num
1989:
1990: THEN

Line 1988: p_style_fmt_layout_rec.variation_number <> fnd_api.g_miss_num

1984: IF p_create_update_flag = 'C' AND
1985: p_style_fmt_layout_rec.style_format_code IS NOT NULL AND
1986: p_style_fmt_layout_rec.style_format_code <> fnd_api.g_miss_CHAR AND
1987: p_style_fmt_layout_rec.variation_number IS NOT NULL AND
1988: p_style_fmt_layout_rec.variation_number <> fnd_api.g_miss_num
1989:
1990: THEN
1991: BEGIN
1992: SELECT 'Y'

Line 2008: fnd_api.g_miss_date, to_date('12/31/4712','MM/DD/YYYY'), p_style_fmt_layout_rec.end_date_active)

2004: variation_number = p_style_fmt_layout_rec.variation_number AND
2005: p_style_fmt_layout_rec.start_date_active
2006: BETWEEN start_date_active AND NVL(end_date_active, to_date('12/31/4712','MM/DD/YYYY')) AND
2007: (decode(p_style_fmt_layout_rec.end_date_active, null, to_date('12/31/4712','MM/DD/YYYY'),
2008: fnd_api.g_miss_date, to_date('12/31/4712','MM/DD/YYYY'), p_style_fmt_layout_rec.end_date_active)
2009: BETWEEN start_date_active
2010: AND NVL(end_date_active, to_date('12/31/4712','MM/DD/YYYY')));
2011:
2012: EXCEPTION

Line 2016: x_return_status := fnd_api.g_ret_sts_error;

2012: EXCEPTION
2013: WHEN NO_DATA_FOUND THEN
2014: fnd_message.set_name('AR', 'HZ_LYT_INVALID_START_END_DATE');
2015: fnd_msg_pub.add;
2016: x_return_status := fnd_api.g_ret_sts_error;
2017: END;
2018: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2019: hz_utility_v2pub.debug(p_message=>'Start date and end date should be within the time range of the corresponding style format variation.' ||
2020: 'x_return_status = ' || x_return_status,

Line 2030: x_return_status := fnd_api.g_ret_sts_error;

2026: WHEN NO_DATA_FOUND THEN
2027: fnd_message.set_name('AR', 'HZ_INVALID_FMT_CODE_VAR_NO');
2028: fnd_message.set_token('VARNUM', p_style_fmt_layout_rec.variation_number);
2029: fnd_msg_pub.add;
2030: x_return_status := fnd_api.g_ret_sts_error;
2031: END;
2032: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2033: hz_utility_v2pub.debug(p_message=>'style_format_code and variation_number are foreign key of table hz_style_fmt_variations .' ||
2034: 'x_return_status = ' || x_return_status,

Line 2040: x_return_status = fnd_api.g_ret_sts_success

2036: p_msg_level=>fnd_log.level_statement);
2037: END IF;
2038:
2039: ELSIF p_create_update_flag = 'U' AND
2040: x_return_status = fnd_api.g_ret_sts_success
2041: THEN
2042: BEGIN
2043: SELECT 'Y'
2044: INTO l_dummy

Line 2051: fnd_api.g_miss_date, to_date('12/31/4712','MM/DD/YYYY'), l_updated_stl_fmt_layout_rec.end_date_active)

2047: variation_number = l_updated_stl_fmt_layout_rec.variation_number AND
2048: l_updated_stl_fmt_layout_rec.start_date_active BETWEEN start_date_active
2049: AND NVL(end_date_active, to_date('12/31/4712','MM/DD/YYYY')) AND
2050: (decode(l_updated_stl_fmt_layout_rec.end_date_active, null, to_date('12/31/4712','MM/DD/YYYY'),
2051: fnd_api.g_miss_date, to_date('12/31/4712','MM/DD/YYYY'), l_updated_stl_fmt_layout_rec.end_date_active)
2052: BETWEEN start_date_active
2053: AND NVL(end_date_active, to_date('12/31/4712','MM/DD/YYYY')));
2054:
2055: EXCEPTION

Line 2059: x_return_status := fnd_api.g_ret_sts_error;

2055: EXCEPTION
2056: WHEN NO_DATA_FOUND THEN
2057: fnd_message.set_name('AR', 'HZ_LYT_INVALID_START_END_DATE');
2058: fnd_msg_pub.add;
2059: x_return_status := fnd_api.g_ret_sts_error;
2060: END;
2061: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2062: hz_utility_v2pub.debug(p_message=>'Start date and end date should be within the time range of the corresponding style format variation.' ||
2063: 'x_return_status = ' || x_return_status,

Line 2153: IF x_return_status = fnd_api.g_ret_sts_success AND

2149: -----------------------------------------------------
2150: -- combination of attribute_code, variation_number is foreign key of ak_attributes
2151: -- Do not need to check during update because attribute_code is
2152: -- non-updateable.
2153: IF x_return_status = fnd_api.g_ret_sts_success AND
2154: p_create_update_flag = 'C' AND
2155: p_style_fmt_layout_rec.attribute_code IS NOT NULL AND
2156: p_style_fmt_layout_rec.attribute_code <> fnd_api.g_miss_CHAR
2157: -- p_style_fmt_layout_rec.attribute_application_id IS NOT NULL AND

Line 2156: p_style_fmt_layout_rec.attribute_code <> fnd_api.g_miss_CHAR

2152: -- non-updateable.
2153: IF x_return_status = fnd_api.g_ret_sts_success AND
2154: p_create_update_flag = 'C' AND
2155: p_style_fmt_layout_rec.attribute_code IS NOT NULL AND
2156: p_style_fmt_layout_rec.attribute_code <> fnd_api.g_miss_CHAR
2157: -- p_style_fmt_layout_rec.attribute_application_id IS NOT NULL AND
2158: -- p_style_fmt_layout_rec.attribute_application_id <> fnd_api.g_miss_num
2159: THEN
2160: BEGIN

Line 2158: -- p_style_fmt_layout_rec.attribute_application_id <> fnd_api.g_miss_num

2154: p_create_update_flag = 'C' AND
2155: p_style_fmt_layout_rec.attribute_code IS NOT NULL AND
2156: p_style_fmt_layout_rec.attribute_code <> fnd_api.g_miss_CHAR
2157: -- p_style_fmt_layout_rec.attribute_application_id IS NOT NULL AND
2158: -- p_style_fmt_layout_rec.attribute_application_id <> fnd_api.g_miss_num
2159: THEN
2160: BEGIN
2161: SELECT database_object_name
2162: INTO l_database_object_name

Line 2181: x_return_status := fnd_api.g_ret_sts_error;

2177: fnd_message.set_name('AR', 'HZ_INVALID_ATTR_APPID');
2178: fnd_message.SET_TOKEN('ATTRIBUTE_CODE',p_style_fmt_layout_rec.attribute_code);
2179: fnd_message.SET_TOKEN('TABLE',l_database_object_name);
2180: fnd_msg_pub.add;
2181: x_return_status := fnd_api.g_ret_sts_error;
2182: END;
2183: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2184: hz_utility_v2pub.debug(p_message=>'the ATTRIBUTE_CODE' || p_style_fmt_layout_rec.attribute_code ||
2185: 'does not exist in table specified in ' || l_database_object_name ||

Line 2214: p_style_fmt_layout_rec.end_date_active <> fnd_api.g_miss_date and

2210: variation_number = p_style_fmt_layout_rec.variation_number AND
2211: attribute_code = p_style_fmt_layout_rec.attribute_code AND
2212: attribute_application_id = p_style_fmt_layout_rec.attribute_application_id AND
2213: NOT ( ( p_style_fmt_layout_rec.end_date_active is not null and
2214: p_style_fmt_layout_rec.end_date_active <> fnd_api.g_miss_date and
2215: p_style_fmt_layout_rec.end_date_active < start_date_active ) OR
2216: ( end_date_active is not null and
2217: p_style_fmt_layout_rec.start_date_active > end_date_active )) AND
2218: rownum =1;

Line 2222: x_return_status := FND_API.G_RET_STS_ERROR;

2218: rownum =1;
2219:
2220: FND_MESSAGE.SET_NAME('AR', 'HZ_LAYOUT_ATTR_APPID_DUP');
2221: FND_MSG_PUB.ADD;
2222: x_return_status := FND_API.G_RET_STS_ERROR;
2223:
2224: EXCEPTION
2225: WHEN NO_DATA_FOUND THEN
2226: NULL;

Line 2257: x_return_status := FND_API.G_RET_STS_ERROR;

2253: rownum =1;
2254:
2255: FND_MESSAGE.SET_NAME('AR', 'HZ_LAYOUT_ATTR_APPID_DUP');
2256: FND_MSG_PUB.ADD;
2257: x_return_status := FND_API.G_RET_STS_ERROR;
2258:
2259: EXCEPTION
2260: WHEN NO_DATA_FOUND THEN
2261: NULL;

Line 2294: p_style_fmt_layout_rec.line_number <> fnd_api.g_miss_num

2290: END IF;
2291:
2292: -- line_number should be > 0
2293: IF p_style_fmt_layout_rec.line_number is not null AND
2294: p_style_fmt_layout_rec.line_number <> fnd_api.g_miss_num
2295: THEN
2296: check_greater_than_zero (
2297: p_column => 'line_number',
2298: p_column_value => p_style_fmt_layout_rec.line_number,

Line 2344: p_style_fmt_layout_rec.position <> fnd_api.g_miss_num

2340: END IF;
2341:
2342: -- position should be > 0
2343: IF p_style_fmt_layout_rec.position is not null AND
2344: p_style_fmt_layout_rec.position <> fnd_api.g_miss_num
2345: THEN
2346: check_greater_than_zero (
2347: p_column => 'position',
2348: p_column_value => p_style_fmt_layout_rec.position,

Line 2395: p_style_fmt_layout_rec.end_date_active <> fnd_api.g_miss_date and

2391: variation_number = p_style_fmt_layout_rec.variation_number AND
2392: line_number = p_style_fmt_layout_rec.line_number AND
2393: position = p_style_fmt_layout_rec.position AND
2394: NOT ( ( p_style_fmt_layout_rec.end_date_active is not null and
2395: p_style_fmt_layout_rec.end_date_active <> fnd_api.g_miss_date and
2396: p_style_fmt_layout_rec.end_date_active < start_date_active ) OR
2397: ( end_date_active is not null and
2398: p_style_fmt_layout_rec.start_date_active > end_date_active )) AND
2399: rownum =1;

Line 2403: x_return_status := FND_API.G_RET_STS_ERROR;

2399: rownum =1;
2400:
2401: FND_MESSAGE.SET_NAME('AR', 'HZ_LAYOUT_LINE_POSITION_DUP');
2402: FND_MSG_PUB.ADD;
2403: x_return_status := FND_API.G_RET_STS_ERROR;
2404:
2405: EXCEPTION
2406: WHEN NO_DATA_FOUND THEN
2407: NULL;

Line 2438: x_return_status := FND_API.G_RET_STS_ERROR;

2434: rownum =1;
2435:
2436: FND_MESSAGE.SET_NAME('AR', 'HZ_LAYOUT_LINE_POSITION_DUP');
2437: FND_MSG_PUB.ADD;
2438: x_return_status := FND_API.G_RET_STS_ERROR;
2439:
2440: EXCEPTION
2441: WHEN NO_DATA_FOUND THEN
2442: NULL;

Line 2610: p_style_fmt_layout_rec.blank_lines_after <> fnd_api.g_miss_num

2606: -- validate blank_lines_before
2607: ------------------------------------
2608:
2609: IF p_style_fmt_layout_rec.blank_lines_after is not null AND
2610: p_style_fmt_layout_rec.blank_lines_after <> fnd_api.g_miss_num
2611: THEN
2612: check_greater_than_zero (
2613: p_column => 'blank_lines_after',
2614: p_column_value => p_style_fmt_layout_rec.blank_lines_after,

Line 2628: p_style_fmt_layout_rec.blank_lines_before <> fnd_api.g_miss_num

2624: ------------------------------------
2625: -- validate blank_lines_after
2626: ------------------------------------
2627: IF p_style_fmt_layout_rec.blank_lines_before is not null AND
2628: p_style_fmt_layout_rec.blank_lines_before <> fnd_api.g_miss_num
2629: THEN
2630: check_greater_than_zero (
2631: p_column => 'blank_lines_before',
2632: p_column_value => p_style_fmt_layout_rec.blank_lines_before,

Line 2686: p_style_fmt_layout_rec.end_date_active <> fnd_api.g_miss_date AND

2682:
2683: -- end_date_active must be null or greater than start date
2684: IF (p_create_update_flag = 'C') THEN
2685: IF p_style_fmt_layout_rec.end_date_active IS NOT NULL AND
2686: p_style_fmt_layout_rec.end_date_active <> fnd_api.g_miss_date AND
2687: p_style_fmt_layout_rec.end_date_active < p_style_fmt_layout_rec.start_date_active
2688: THEN
2689: fnd_message.set_name('AR', 'HZ_API_START_DATE_GREATER');
2690: fnd_msg_pub.add;

Line 2691: x_return_status := fnd_api.g_ret_sts_error;

2687: p_style_fmt_layout_rec.end_date_active < p_style_fmt_layout_rec.start_date_active
2688: THEN
2689: fnd_message.set_name('AR', 'HZ_API_START_DATE_GREATER');
2690: fnd_msg_pub.add;
2691: x_return_status := fnd_api.g_ret_sts_error;
2692: END IF;
2693: ELSIF (p_create_update_flag = 'U') THEN
2694: -- old start_date_active, end_date_active has been selected from table
2695: -- and put into l_start_date_active, l_end_date_active

Line 2697: IF p_style_fmt_layout_rec.start_date_active <> fnd_api.g_miss_date

2693: ELSIF (p_create_update_flag = 'U') THEN
2694: -- old start_date_active, end_date_active has been selected from table
2695: -- and put into l_start_date_active, l_end_date_active
2696:
2697: IF p_style_fmt_layout_rec.start_date_active <> fnd_api.g_miss_date
2698: AND p_style_fmt_layout_rec.start_date_active is not null
2699: THEN
2700: l_start_date_active := p_style_fmt_layout_rec.start_date_active;
2701: END IF;

Line 2703: IF p_style_fmt_layout_rec.end_date_active = fnd_api.g_miss_date

2699: THEN
2700: l_start_date_active := p_style_fmt_layout_rec.start_date_active;
2701: END IF;
2702:
2703: IF p_style_fmt_layout_rec.end_date_active = fnd_api.g_miss_date
2704: THEN
2705: l_end_date_active := null;
2706: ELSIF p_style_fmt_layout_rec.end_date_active IS NOT NULL THEN
2707: l_end_date_active := p_style_fmt_layout_rec.end_date_active;

Line 2715: x_return_status := fnd_api.g_ret_sts_error;

2711: AND l_end_date_active < l_start_date_active
2712: THEN
2713: fnd_message.set_name('AR', 'HZ_API_START_DATE_GREATER');
2714: fnd_msg_pub.add;
2715: x_return_status := fnd_api.g_ret_sts_error;
2716: END IF;
2717: END IF;
2718: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2719: hz_utility_v2pub.debug(p_message=>'end_date_active must be null or greater than start date. ' ||