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.IBE_DSP_SECTION_GRP dependencies on FND_API

Line 59: x_return_status := FND_API.G_RET_STS_SUCCESS;

55:
56: l_cursor := DBMS_SQL.open_cursor;
57: BEGIN
58: DBMS_SQL.parse(l_cursor, p_sql_stmt, DBMS_SQL.NATIVE);
59: x_return_status := FND_API.G_RET_STS_SUCCESS;
60: DBMS_SQL.close_cursor(l_cursor);
61: EXCEPTION
62: WHEN OTHERS THEN
63: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

Line 69: x_return_status := FND_API.G_RET_STS_ERROR;

65: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
66: FND_MESSAGE.Set_Token('REASON', SQLERRM);
67: FND_MSG_PUB.Add;
68:
69: x_return_status := FND_API.G_RET_STS_ERROR;
70: DBMS_SQL.close_cursor(l_cursor);
71: END;
72:
73: END Is_SQL_Valid;

Line 130: (x_section_id = FND_API.G_MISS_NUM))

126:
127: -- Primary key validation check
128: x_section_id := p_section_id;
129: IF ((x_section_id IS NULL) OR
130: (x_section_id = FND_API.G_MISS_NUM))
131: THEN
132: OPEN c2;
133: FETCH c2 INTO x_section_id;
134: CLOSE c2;

Line 178: decode(p_access_name, FND_API.G_MISS_CHAR, NULL, p_access_name),

174: VALUES
175: (
176: x_section_id,
177: p_object_version_number,
178: decode(p_access_name, FND_API.G_MISS_CHAR, NULL, p_access_name),
179: p_start_date_active,
180: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),
181: p_section_type_code,
182: p_status_code,

Line 180: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),

176: x_section_id,
177: p_object_version_number,
178: decode(p_access_name, FND_API.G_MISS_CHAR, NULL, p_access_name),
179: p_start_date_active,
180: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),
181: p_section_type_code,
182: p_status_code,
183: decode(p_display_context_id, FND_API.G_MISS_NUM,NULL,p_display_context_id),
184: decode(p_deliverable_id, FND_API.G_MISS_NUM, NULL, p_deliverable_id),

Line 183: decode(p_display_context_id, FND_API.G_MISS_NUM,NULL,p_display_context_id),

179: p_start_date_active,
180: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),
181: p_section_type_code,
182: p_status_code,
183: decode(p_display_context_id, FND_API.G_MISS_NUM,NULL,p_display_context_id),
184: decode(p_deliverable_id, FND_API.G_MISS_NUM, NULL, p_deliverable_id),
185: decode(p_available_in_all_sites_flag, FND_API.G_MISS_CHAR, 'Y', NULL, 'Y',
186: p_available_in_all_sites_flag),
187: decode(p_auto_placement_rule, FND_API.G_MISS_CHAR, NULL,

Line 184: decode(p_deliverable_id, FND_API.G_MISS_NUM, NULL, p_deliverable_id),

180: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),
181: p_section_type_code,
182: p_status_code,
183: decode(p_display_context_id, FND_API.G_MISS_NUM,NULL,p_display_context_id),
184: decode(p_deliverable_id, FND_API.G_MISS_NUM, NULL, p_deliverable_id),
185: decode(p_available_in_all_sites_flag, FND_API.G_MISS_CHAR, 'Y', NULL, 'Y',
186: p_available_in_all_sites_flag),
187: decode(p_auto_placement_rule, FND_API.G_MISS_CHAR, NULL,
188: p_auto_placement_rule),

Line 185: decode(p_available_in_all_sites_flag, FND_API.G_MISS_CHAR, 'Y', NULL, 'Y',

181: p_section_type_code,
182: p_status_code,
183: decode(p_display_context_id, FND_API.G_MISS_NUM,NULL,p_display_context_id),
184: decode(p_deliverable_id, FND_API.G_MISS_NUM, NULL, p_deliverable_id),
185: decode(p_available_in_all_sites_flag, FND_API.G_MISS_CHAR, 'Y', NULL, 'Y',
186: p_available_in_all_sites_flag),
187: decode(p_auto_placement_rule, FND_API.G_MISS_CHAR, NULL,
188: p_auto_placement_rule),
189: decode(p_order_by_clause, FND_API.G_MISS_CHAR, NULL, p_order_by_clause),

Line 187: decode(p_auto_placement_rule, FND_API.G_MISS_CHAR, NULL,

183: decode(p_display_context_id, FND_API.G_MISS_NUM,NULL,p_display_context_id),
184: decode(p_deliverable_id, FND_API.G_MISS_NUM, NULL, p_deliverable_id),
185: decode(p_available_in_all_sites_flag, FND_API.G_MISS_CHAR, 'Y', NULL, 'Y',
186: p_available_in_all_sites_flag),
187: decode(p_auto_placement_rule, FND_API.G_MISS_CHAR, NULL,
188: p_auto_placement_rule),
189: decode(p_order_by_clause, FND_API.G_MISS_CHAR, NULL, p_order_by_clause),
190: decode(p_attribute_category, FND_API.G_MISS_CHAR, NULL,p_attribute_category),
191: decode(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),

Line 189: decode(p_order_by_clause, FND_API.G_MISS_CHAR, NULL, p_order_by_clause),

185: decode(p_available_in_all_sites_flag, FND_API.G_MISS_CHAR, 'Y', NULL, 'Y',
186: p_available_in_all_sites_flag),
187: decode(p_auto_placement_rule, FND_API.G_MISS_CHAR, NULL,
188: p_auto_placement_rule),
189: decode(p_order_by_clause, FND_API.G_MISS_CHAR, NULL, p_order_by_clause),
190: decode(p_attribute_category, FND_API.G_MISS_CHAR, NULL,p_attribute_category),
191: decode(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
192: decode(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
193: decode(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),

Line 190: decode(p_attribute_category, FND_API.G_MISS_CHAR, NULL,p_attribute_category),

186: p_available_in_all_sites_flag),
187: decode(p_auto_placement_rule, FND_API.G_MISS_CHAR, NULL,
188: p_auto_placement_rule),
189: decode(p_order_by_clause, FND_API.G_MISS_CHAR, NULL, p_order_by_clause),
190: decode(p_attribute_category, FND_API.G_MISS_CHAR, NULL,p_attribute_category),
191: decode(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
192: decode(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
193: decode(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
194: decode(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),

Line 191: decode(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),

187: decode(p_auto_placement_rule, FND_API.G_MISS_CHAR, NULL,
188: p_auto_placement_rule),
189: decode(p_order_by_clause, FND_API.G_MISS_CHAR, NULL, p_order_by_clause),
190: decode(p_attribute_category, FND_API.G_MISS_CHAR, NULL,p_attribute_category),
191: decode(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
192: decode(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
193: decode(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
194: decode(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
195: decode(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),

Line 192: decode(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),

188: p_auto_placement_rule),
189: decode(p_order_by_clause, FND_API.G_MISS_CHAR, NULL, p_order_by_clause),
190: decode(p_attribute_category, FND_API.G_MISS_CHAR, NULL,p_attribute_category),
191: decode(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
192: decode(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
193: decode(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
194: decode(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
195: decode(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
196: decode(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),

Line 193: decode(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),

189: decode(p_order_by_clause, FND_API.G_MISS_CHAR, NULL, p_order_by_clause),
190: decode(p_attribute_category, FND_API.G_MISS_CHAR, NULL,p_attribute_category),
191: decode(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
192: decode(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
193: decode(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
194: decode(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
195: decode(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
196: decode(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
197: decode(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),

Line 194: decode(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),

190: decode(p_attribute_category, FND_API.G_MISS_CHAR, NULL,p_attribute_category),
191: decode(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
192: decode(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
193: decode(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
194: decode(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
195: decode(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
196: decode(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
197: decode(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
198: decode(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),

Line 195: decode(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),

191: decode(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
192: decode(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
193: decode(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
194: decode(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
195: decode(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
196: decode(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
197: decode(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
198: decode(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
199: decode(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),

Line 196: decode(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),

192: decode(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
193: decode(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
194: decode(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
195: decode(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
196: decode(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
197: decode(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
198: decode(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
199: decode(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
200: decode(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),

Line 197: decode(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),

193: decode(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
194: decode(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
195: decode(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
196: decode(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
197: decode(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
198: decode(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
199: decode(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
200: decode(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
201: decode(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),

Line 198: decode(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),

194: decode(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
195: decode(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
196: decode(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
197: decode(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
198: decode(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
199: decode(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
200: decode(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
201: decode(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
202: decode(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),

Line 199: decode(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),

195: decode(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
196: decode(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
197: decode(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
198: decode(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
199: decode(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
200: decode(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
201: decode(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
202: decode(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
203: decode(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),

Line 200: decode(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),

196: decode(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
197: decode(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
198: decode(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
199: decode(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
200: decode(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
201: decode(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
202: decode(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
203: decode(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
204: decode(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),

Line 201: decode(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),

197: decode(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
198: decode(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
199: decode(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
200: decode(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
201: decode(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
202: decode(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
203: decode(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
204: decode(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
205: decode(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),

Line 202: decode(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),

198: decode(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
199: decode(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
200: decode(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
201: decode(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
202: decode(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
203: decode(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
204: decode(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
205: decode(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
206: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,

Line 203: decode(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),

199: decode(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
200: decode(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
201: decode(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
202: decode(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
203: decode(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
204: decode(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
205: decode(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
206: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
207: p_creation_date),

Line 204: decode(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),

200: decode(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
201: decode(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
202: decode(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
203: decode(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
204: decode(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
205: decode(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
206: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
207: p_creation_date),
208: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

Line 205: decode(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),

201: decode(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
202: decode(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
203: decode(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
204: decode(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
205: decode(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
206: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
207: p_creation_date),
208: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
209: NULL, FND_GLOBAL.user_id, p_created_by),

Line 206: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,

202: decode(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
203: decode(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
204: decode(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
205: decode(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
206: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
207: p_creation_date),
208: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
209: NULL, FND_GLOBAL.user_id, p_created_by),
210: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,

Line 208: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

204: decode(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
205: decode(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
206: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
207: p_creation_date),
208: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
209: NULL, FND_GLOBAL.user_id, p_created_by),
210: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
211: p_last_update_date),
212: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

Line 210: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,

206: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
207: p_creation_date),
208: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
209: NULL, FND_GLOBAL.user_id, p_created_by),
210: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
211: p_last_update_date),
212: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
213: NULL, FND_GLOBAL.user_id, p_last_updated_by),
214: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,

Line 212: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

208: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
209: NULL, FND_GLOBAL.user_id, p_created_by),
210: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
211: p_last_update_date),
212: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
213: NULL, FND_GLOBAL.user_id, p_last_updated_by),
214: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
215: NULL, FND_GLOBAL.login_id, p_last_update_login)
216: );

Line 214: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,

210: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
211: p_last_update_date),
212: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
213: NULL, FND_GLOBAL.user_id, p_last_updated_by),
214: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
215: NULL, FND_GLOBAL.login_id, p_last_update_login)
216: );
217:
218: OPEN c;

Line 245: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,

241: language,
242: source_lang
243: )
244: SELECT
245: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
246: NULL, FND_GLOBAL.login_id, p_last_update_login),
247: p_display_name,
248: decode(p_description,FND_API.G_MISS_CHAR, NULL, p_description),
249: decode(p_long_description, FND_API.G_MISS_CHAR, NULL, p_long_description),

Line 248: decode(p_description,FND_API.G_MISS_CHAR, NULL, p_description),

244: SELECT
245: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
246: NULL, FND_GLOBAL.login_id, p_last_update_login),
247: p_display_name,
248: decode(p_description,FND_API.G_MISS_CHAR, NULL, p_description),
249: decode(p_long_description, FND_API.G_MISS_CHAR, NULL, p_long_description),
250: decode(p_keywords, FND_API.G_MISS_CHAR, NULL, p_keywords),
251: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
252: NULL, FND_GLOBAL.user_id, p_last_updated_by),

Line 249: decode(p_long_description, FND_API.G_MISS_CHAR, NULL, p_long_description),

245: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
246: NULL, FND_GLOBAL.login_id, p_last_update_login),
247: p_display_name,
248: decode(p_description,FND_API.G_MISS_CHAR, NULL, p_description),
249: decode(p_long_description, FND_API.G_MISS_CHAR, NULL, p_long_description),
250: decode(p_keywords, FND_API.G_MISS_CHAR, NULL, p_keywords),
251: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
252: NULL, FND_GLOBAL.user_id, p_last_updated_by),
253: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,

Line 250: decode(p_keywords, FND_API.G_MISS_CHAR, NULL, p_keywords),

246: NULL, FND_GLOBAL.login_id, p_last_update_login),
247: p_display_name,
248: decode(p_description,FND_API.G_MISS_CHAR, NULL, p_description),
249: decode(p_long_description, FND_API.G_MISS_CHAR, NULL, p_long_description),
250: decode(p_keywords, FND_API.G_MISS_CHAR, NULL, p_keywords),
251: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
252: NULL, FND_GLOBAL.user_id, p_last_updated_by),
253: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
254: NULL, sysdate, p_last_update_date),

Line 251: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

247: p_display_name,
248: decode(p_description,FND_API.G_MISS_CHAR, NULL, p_description),
249: decode(p_long_description, FND_API.G_MISS_CHAR, NULL, p_long_description),
250: decode(p_keywords, FND_API.G_MISS_CHAR, NULL, p_keywords),
251: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
252: NULL, FND_GLOBAL.user_id, p_last_updated_by),
253: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
254: NULL, sysdate, p_last_update_date),
255: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate,

Line 253: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,

249: decode(p_long_description, FND_API.G_MISS_CHAR, NULL, p_long_description),
250: decode(p_keywords, FND_API.G_MISS_CHAR, NULL, p_keywords),
251: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
252: NULL, FND_GLOBAL.user_id, p_last_updated_by),
253: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
254: NULL, sysdate, p_last_update_date),
255: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate,
256: NULL, sysdate, p_creation_date),
257: x_section_id,

Line 255: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate,

251: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
252: NULL, FND_GLOBAL.user_id, p_last_updated_by),
253: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
254: NULL, sysdate, p_last_update_date),
255: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate,
256: NULL, sysdate, p_creation_date),
257: x_section_id,
258: p_object_version_number,
259: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

Line 259: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

255: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate,
256: NULL, sysdate, p_creation_date),
257: x_section_id,
258: p_object_version_number,
259: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
260: NULL, FND_GLOBAL.user_id, p_created_by),
261: L.language_code,
262: USERENV('LANG')
263: FROM fnd_languages L

Line 289: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,

285:
286: PROCEDURE update_row
287: (
288: p_section_id IN NUMBER,
289: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
290: p_access_name IN VARCHAR2,
291: p_start_date_active IN DATE,
292: p_end_date_active IN DATE,
293: p_section_type_code IN VARCHAR2,

Line 330: access_name = decode(p_access_name, FND_API.G_MISS_CHAR,

326:
327: -- update base
328: UPDATE ibe_dsp_sections_b SET
329: object_version_number = object_version_number + 1,
330: access_name = decode(p_access_name, FND_API.G_MISS_CHAR,
331: access_name, p_access_name),
332: start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE,
333: start_date_active, p_start_date_active),
334: end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,

Line 332: start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE,

328: UPDATE ibe_dsp_sections_b SET
329: object_version_number = object_version_number + 1,
330: access_name = decode(p_access_name, FND_API.G_MISS_CHAR,
331: access_name, p_access_name),
332: start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE,
333: start_date_active, p_start_date_active),
334: end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,
335: end_date_active, p_end_date_active),
336: section_type_code = decode(p_section_type_code, FND_API.G_MISS_CHAR,

Line 334: end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,

330: access_name = decode(p_access_name, FND_API.G_MISS_CHAR,
331: access_name, p_access_name),
332: start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE,
333: start_date_active, p_start_date_active),
334: end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,
335: end_date_active, p_end_date_active),
336: section_type_code = decode(p_section_type_code, FND_API.G_MISS_CHAR,
337: section_type_code, p_section_type_code),
338: status_code = decode(p_status_code, FND_API.G_MISS_CHAR,

Line 336: section_type_code = decode(p_section_type_code, FND_API.G_MISS_CHAR,

332: start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE,
333: start_date_active, p_start_date_active),
334: end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,
335: end_date_active, p_end_date_active),
336: section_type_code = decode(p_section_type_code, FND_API.G_MISS_CHAR,
337: section_type_code, p_section_type_code),
338: status_code = decode(p_status_code, FND_API.G_MISS_CHAR,
339: status_code, p_status_code),
340: display_context_id = decode(p_display_context_id, FND_API.G_MISS_NUM,

Line 338: status_code = decode(p_status_code, FND_API.G_MISS_CHAR,

334: end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,
335: end_date_active, p_end_date_active),
336: section_type_code = decode(p_section_type_code, FND_API.G_MISS_CHAR,
337: section_type_code, p_section_type_code),
338: status_code = decode(p_status_code, FND_API.G_MISS_CHAR,
339: status_code, p_status_code),
340: display_context_id = decode(p_display_context_id, FND_API.G_MISS_NUM,
341: display_context_id, p_display_context_id),
342: deliverable_id = decode(p_deliverable_id, FND_API.G_MISS_NUM,

Line 340: display_context_id = decode(p_display_context_id, FND_API.G_MISS_NUM,

336: section_type_code = decode(p_section_type_code, FND_API.G_MISS_CHAR,
337: section_type_code, p_section_type_code),
338: status_code = decode(p_status_code, FND_API.G_MISS_CHAR,
339: status_code, p_status_code),
340: display_context_id = decode(p_display_context_id, FND_API.G_MISS_NUM,
341: display_context_id, p_display_context_id),
342: deliverable_id = decode(p_deliverable_id, FND_API.G_MISS_NUM,
343: deliverable_id, p_deliverable_id),
344: available_in_all_sites_flag =

Line 342: deliverable_id = decode(p_deliverable_id, FND_API.G_MISS_NUM,

338: status_code = decode(p_status_code, FND_API.G_MISS_CHAR,
339: status_code, p_status_code),
340: display_context_id = decode(p_display_context_id, FND_API.G_MISS_NUM,
341: display_context_id, p_display_context_id),
342: deliverable_id = decode(p_deliverable_id, FND_API.G_MISS_NUM,
343: deliverable_id, p_deliverable_id),
344: available_in_all_sites_flag =
345: decode(p_available_in_all_sites_flag, FND_API.G_MISS_CHAR,
346: available_in_all_sites_flag, p_available_in_all_sites_flag),

Line 345: decode(p_available_in_all_sites_flag, FND_API.G_MISS_CHAR,

341: display_context_id, p_display_context_id),
342: deliverable_id = decode(p_deliverable_id, FND_API.G_MISS_NUM,
343: deliverable_id, p_deliverable_id),
344: available_in_all_sites_flag =
345: decode(p_available_in_all_sites_flag, FND_API.G_MISS_CHAR,
346: available_in_all_sites_flag, p_available_in_all_sites_flag),
347: auto_placement_rule = decode(p_auto_placement_rule, FND_API.G_MISS_CHAR,
348: auto_placement_rule, p_auto_placement_rule),
349: order_by_clause = decode(p_order_by_clause, FND_API.G_MISS_CHAR,

Line 347: auto_placement_rule = decode(p_auto_placement_rule, FND_API.G_MISS_CHAR,

343: deliverable_id, p_deliverable_id),
344: available_in_all_sites_flag =
345: decode(p_available_in_all_sites_flag, FND_API.G_MISS_CHAR,
346: available_in_all_sites_flag, p_available_in_all_sites_flag),
347: auto_placement_rule = decode(p_auto_placement_rule, FND_API.G_MISS_CHAR,
348: auto_placement_rule, p_auto_placement_rule),
349: order_by_clause = decode(p_order_by_clause, FND_API.G_MISS_CHAR,
350: order_by_clause, p_order_by_clause),
351: attribute_category = decode(p_attribute_category, FND_API.G_MISS_CHAR,

Line 349: order_by_clause = decode(p_order_by_clause, FND_API.G_MISS_CHAR,

345: decode(p_available_in_all_sites_flag, FND_API.G_MISS_CHAR,
346: available_in_all_sites_flag, p_available_in_all_sites_flag),
347: auto_placement_rule = decode(p_auto_placement_rule, FND_API.G_MISS_CHAR,
348: auto_placement_rule, p_auto_placement_rule),
349: order_by_clause = decode(p_order_by_clause, FND_API.G_MISS_CHAR,
350: order_by_clause, p_order_by_clause),
351: attribute_category = decode(p_attribute_category, FND_API.G_MISS_CHAR,
352: attribute_category, p_attribute_category),
353: attribute1 = decode(p_attribute1, FND_API.G_MISS_CHAR,

Line 351: attribute_category = decode(p_attribute_category, FND_API.G_MISS_CHAR,

347: auto_placement_rule = decode(p_auto_placement_rule, FND_API.G_MISS_CHAR,
348: auto_placement_rule, p_auto_placement_rule),
349: order_by_clause = decode(p_order_by_clause, FND_API.G_MISS_CHAR,
350: order_by_clause, p_order_by_clause),
351: attribute_category = decode(p_attribute_category, FND_API.G_MISS_CHAR,
352: attribute_category, p_attribute_category),
353: attribute1 = decode(p_attribute1, FND_API.G_MISS_CHAR,
354: attribute1, p_attribute1),
355: attribute2 = decode(p_attribute2, FND_API.G_MISS_CHAR,

Line 353: attribute1 = decode(p_attribute1, FND_API.G_MISS_CHAR,

349: order_by_clause = decode(p_order_by_clause, FND_API.G_MISS_CHAR,
350: order_by_clause, p_order_by_clause),
351: attribute_category = decode(p_attribute_category, FND_API.G_MISS_CHAR,
352: attribute_category, p_attribute_category),
353: attribute1 = decode(p_attribute1, FND_API.G_MISS_CHAR,
354: attribute1, p_attribute1),
355: attribute2 = decode(p_attribute2, FND_API.G_MISS_CHAR,
356: attribute2, p_attribute2),
357: attribute3 = decode(p_attribute3, FND_API.G_MISS_CHAR,

Line 355: attribute2 = decode(p_attribute2, FND_API.G_MISS_CHAR,

351: attribute_category = decode(p_attribute_category, FND_API.G_MISS_CHAR,
352: attribute_category, p_attribute_category),
353: attribute1 = decode(p_attribute1, FND_API.G_MISS_CHAR,
354: attribute1, p_attribute1),
355: attribute2 = decode(p_attribute2, FND_API.G_MISS_CHAR,
356: attribute2, p_attribute2),
357: attribute3 = decode(p_attribute3, FND_API.G_MISS_CHAR,
358: attribute3, p_attribute3),
359: attribute4 = decode(p_attribute4, FND_API.G_MISS_CHAR,

Line 357: attribute3 = decode(p_attribute3, FND_API.G_MISS_CHAR,

353: attribute1 = decode(p_attribute1, FND_API.G_MISS_CHAR,
354: attribute1, p_attribute1),
355: attribute2 = decode(p_attribute2, FND_API.G_MISS_CHAR,
356: attribute2, p_attribute2),
357: attribute3 = decode(p_attribute3, FND_API.G_MISS_CHAR,
358: attribute3, p_attribute3),
359: attribute4 = decode(p_attribute4, FND_API.G_MISS_CHAR,
360: attribute4, p_attribute4),
361: attribute5 = decode(p_attribute5, FND_API.G_MISS_CHAR,

Line 359: attribute4 = decode(p_attribute4, FND_API.G_MISS_CHAR,

355: attribute2 = decode(p_attribute2, FND_API.G_MISS_CHAR,
356: attribute2, p_attribute2),
357: attribute3 = decode(p_attribute3, FND_API.G_MISS_CHAR,
358: attribute3, p_attribute3),
359: attribute4 = decode(p_attribute4, FND_API.G_MISS_CHAR,
360: attribute4, p_attribute4),
361: attribute5 = decode(p_attribute5, FND_API.G_MISS_CHAR,
362: attribute5, p_attribute5),
363: attribute6 = decode(p_attribute6, FND_API.G_MISS_CHAR,

Line 361: attribute5 = decode(p_attribute5, FND_API.G_MISS_CHAR,

357: attribute3 = decode(p_attribute3, FND_API.G_MISS_CHAR,
358: attribute3, p_attribute3),
359: attribute4 = decode(p_attribute4, FND_API.G_MISS_CHAR,
360: attribute4, p_attribute4),
361: attribute5 = decode(p_attribute5, FND_API.G_MISS_CHAR,
362: attribute5, p_attribute5),
363: attribute6 = decode(p_attribute6, FND_API.G_MISS_CHAR,
364: attribute6, p_attribute6),
365: attribute7 = decode(p_attribute7, FND_API.G_MISS_CHAR,

Line 363: attribute6 = decode(p_attribute6, FND_API.G_MISS_CHAR,

359: attribute4 = decode(p_attribute4, FND_API.G_MISS_CHAR,
360: attribute4, p_attribute4),
361: attribute5 = decode(p_attribute5, FND_API.G_MISS_CHAR,
362: attribute5, p_attribute5),
363: attribute6 = decode(p_attribute6, FND_API.G_MISS_CHAR,
364: attribute6, p_attribute6),
365: attribute7 = decode(p_attribute7, FND_API.G_MISS_CHAR,
366: attribute7, p_attribute7),
367: attribute8 = decode(p_attribute8, FND_API.G_MISS_CHAR,

Line 365: attribute7 = decode(p_attribute7, FND_API.G_MISS_CHAR,

361: attribute5 = decode(p_attribute5, FND_API.G_MISS_CHAR,
362: attribute5, p_attribute5),
363: attribute6 = decode(p_attribute6, FND_API.G_MISS_CHAR,
364: attribute6, p_attribute6),
365: attribute7 = decode(p_attribute7, FND_API.G_MISS_CHAR,
366: attribute7, p_attribute7),
367: attribute8 = decode(p_attribute8, FND_API.G_MISS_CHAR,
368: attribute8, p_attribute8),
369: attribute9 = decode(p_attribute9, FND_API.G_MISS_CHAR,

Line 367: attribute8 = decode(p_attribute8, FND_API.G_MISS_CHAR,

363: attribute6 = decode(p_attribute6, FND_API.G_MISS_CHAR,
364: attribute6, p_attribute6),
365: attribute7 = decode(p_attribute7, FND_API.G_MISS_CHAR,
366: attribute7, p_attribute7),
367: attribute8 = decode(p_attribute8, FND_API.G_MISS_CHAR,
368: attribute8, p_attribute8),
369: attribute9 = decode(p_attribute9, FND_API.G_MISS_CHAR,
370: attribute9, p_attribute9),
371: attribute10 = decode(p_attribute10, FND_API.G_MISS_CHAR,

Line 369: attribute9 = decode(p_attribute9, FND_API.G_MISS_CHAR,

365: attribute7 = decode(p_attribute7, FND_API.G_MISS_CHAR,
366: attribute7, p_attribute7),
367: attribute8 = decode(p_attribute8, FND_API.G_MISS_CHAR,
368: attribute8, p_attribute8),
369: attribute9 = decode(p_attribute9, FND_API.G_MISS_CHAR,
370: attribute9, p_attribute9),
371: attribute10 = decode(p_attribute10, FND_API.G_MISS_CHAR,
372: attribute10, p_attribute10),
373: attribute11 = decode(p_attribute11, FND_API.G_MISS_CHAR,

Line 371: attribute10 = decode(p_attribute10, FND_API.G_MISS_CHAR,

367: attribute8 = decode(p_attribute8, FND_API.G_MISS_CHAR,
368: attribute8, p_attribute8),
369: attribute9 = decode(p_attribute9, FND_API.G_MISS_CHAR,
370: attribute9, p_attribute9),
371: attribute10 = decode(p_attribute10, FND_API.G_MISS_CHAR,
372: attribute10, p_attribute10),
373: attribute11 = decode(p_attribute11, FND_API.G_MISS_CHAR,
374: attribute11, p_attribute11),
375: attribute12 = decode(p_attribute12, FND_API.G_MISS_CHAR,

Line 373: attribute11 = decode(p_attribute11, FND_API.G_MISS_CHAR,

369: attribute9 = decode(p_attribute9, FND_API.G_MISS_CHAR,
370: attribute9, p_attribute9),
371: attribute10 = decode(p_attribute10, FND_API.G_MISS_CHAR,
372: attribute10, p_attribute10),
373: attribute11 = decode(p_attribute11, FND_API.G_MISS_CHAR,
374: attribute11, p_attribute11),
375: attribute12 = decode(p_attribute12, FND_API.G_MISS_CHAR,
376: attribute12, p_attribute12),
377: attribute13 = decode(p_attribute13, FND_API.G_MISS_CHAR,

Line 375: attribute12 = decode(p_attribute12, FND_API.G_MISS_CHAR,

371: attribute10 = decode(p_attribute10, FND_API.G_MISS_CHAR,
372: attribute10, p_attribute10),
373: attribute11 = decode(p_attribute11, FND_API.G_MISS_CHAR,
374: attribute11, p_attribute11),
375: attribute12 = decode(p_attribute12, FND_API.G_MISS_CHAR,
376: attribute12, p_attribute12),
377: attribute13 = decode(p_attribute13, FND_API.G_MISS_CHAR,
378: attribute13, p_attribute13),
379: attribute14 = decode(p_attribute14, FND_API.G_MISS_CHAR,

Line 377: attribute13 = decode(p_attribute13, FND_API.G_MISS_CHAR,

373: attribute11 = decode(p_attribute11, FND_API.G_MISS_CHAR,
374: attribute11, p_attribute11),
375: attribute12 = decode(p_attribute12, FND_API.G_MISS_CHAR,
376: attribute12, p_attribute12),
377: attribute13 = decode(p_attribute13, FND_API.G_MISS_CHAR,
378: attribute13, p_attribute13),
379: attribute14 = decode(p_attribute14, FND_API.G_MISS_CHAR,
380: attribute14, p_attribute14),
381: attribute15 = decode(p_attribute15, FND_API.G_MISS_CHAR,

Line 379: attribute14 = decode(p_attribute14, FND_API.G_MISS_CHAR,

375: attribute12 = decode(p_attribute12, FND_API.G_MISS_CHAR,
376: attribute12, p_attribute12),
377: attribute13 = decode(p_attribute13, FND_API.G_MISS_CHAR,
378: attribute13, p_attribute13),
379: attribute14 = decode(p_attribute14, FND_API.G_MISS_CHAR,
380: attribute14, p_attribute14),
381: attribute15 = decode(p_attribute15, FND_API.G_MISS_CHAR,
382: attribute15, p_attribute15),
383: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,

Line 381: attribute15 = decode(p_attribute15, FND_API.G_MISS_CHAR,

377: attribute13 = decode(p_attribute13, FND_API.G_MISS_CHAR,
378: attribute13, p_attribute13),
379: attribute14 = decode(p_attribute14, FND_API.G_MISS_CHAR,
380: attribute14, p_attribute14),
381: attribute15 = decode(p_attribute15, FND_API.G_MISS_CHAR,
382: attribute15, p_attribute15),
383: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
384: NULL, sysdate, p_last_update_date),
385: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,

Line 383: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,

379: attribute14 = decode(p_attribute14, FND_API.G_MISS_CHAR,
380: attribute14, p_attribute14),
381: attribute15 = decode(p_attribute15, FND_API.G_MISS_CHAR,
382: attribute15, p_attribute15),
383: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
384: NULL, sysdate, p_last_update_date),
385: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
386: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
387: p_last_updated_by),

Line 385: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,

381: attribute15 = decode(p_attribute15, FND_API.G_MISS_CHAR,
382: attribute15, p_attribute15),
383: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
384: NULL, sysdate, p_last_update_date),
385: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
386: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
387: p_last_updated_by),
388: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
389: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,

Line 388: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,

384: NULL, sysdate, p_last_update_date),
385: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
386: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
387: p_last_updated_by),
388: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
389: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
390: p_last_update_login)
391: WHERE section_id = p_section_id
392: AND object_version_number = decode(p_object_version_number,

Line 393: FND_API.G_MISS_NUM,

389: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
390: p_last_update_login)
391: WHERE section_id = p_section_id
392: AND object_version_number = decode(p_object_version_number,
393: FND_API.G_MISS_NUM,
394: object_version_number,
395: p_object_version_number);
396:
397:

Line 404: display_name = decode(p_display_name, FND_API.G_MISS_CHAR,

400: END IF;
401:
402: UPDATE ibe_dsp_sections_tl SET
403: object_version_number = object_version_number + 1,
404: display_name = decode(p_display_name, FND_API.G_MISS_CHAR,
405: display_name, p_display_name),
406: description = decode(p_description, FND_API.G_MISS_CHAR,
407: description, p_description),
408: long_description = decode(p_long_description, FND_API.G_MISS_CHAR,

Line 406: description = decode(p_description, FND_API.G_MISS_CHAR,

402: UPDATE ibe_dsp_sections_tl SET
403: object_version_number = object_version_number + 1,
404: display_name = decode(p_display_name, FND_API.G_MISS_CHAR,
405: display_name, p_display_name),
406: description = decode(p_description, FND_API.G_MISS_CHAR,
407: description, p_description),
408: long_description = decode(p_long_description, FND_API.G_MISS_CHAR,
409: long_description, p_long_description),
410: keywords = decode(p_keywords, FND_API.G_MISS_CHAR, keywords, p_keywords),

Line 408: long_description = decode(p_long_description, FND_API.G_MISS_CHAR,

404: display_name = decode(p_display_name, FND_API.G_MISS_CHAR,
405: display_name, p_display_name),
406: description = decode(p_description, FND_API.G_MISS_CHAR,
407: description, p_description),
408: long_description = decode(p_long_description, FND_API.G_MISS_CHAR,
409: long_description, p_long_description),
410: keywords = decode(p_keywords, FND_API.G_MISS_CHAR, keywords, p_keywords),
411: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
412: NULL, sysdate, p_last_update_date),

Line 410: keywords = decode(p_keywords, FND_API.G_MISS_CHAR, keywords, p_keywords),

406: description = decode(p_description, FND_API.G_MISS_CHAR,
407: description, p_description),
408: long_description = decode(p_long_description, FND_API.G_MISS_CHAR,
409: long_description, p_long_description),
410: keywords = decode(p_keywords, FND_API.G_MISS_CHAR, keywords, p_keywords),
411: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
412: NULL, sysdate, p_last_update_date),
413: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
414: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,

Line 411: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,

407: description, p_description),
408: long_description = decode(p_long_description, FND_API.G_MISS_CHAR,
409: long_description, p_long_description),
410: keywords = decode(p_keywords, FND_API.G_MISS_CHAR, keywords, p_keywords),
411: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
412: NULL, sysdate, p_last_update_date),
413: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
414: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
415: p_last_updated_by),

Line 413: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,

409: long_description, p_long_description),
410: keywords = decode(p_keywords, FND_API.G_MISS_CHAR, keywords, p_keywords),
411: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
412: NULL, sysdate, p_last_update_date),
413: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
414: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
415: p_last_updated_by),
416: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
417: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,

Line 416: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,

412: NULL, sysdate, p_last_update_date),
413: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
414: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
415: p_last_updated_by),
416: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
417: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
418: p_last_update_login),
419: source_lang = USERENV('LANG')
420: WHERE section_id = p_section_id

Line 422: -- FND_API.G_MISS_NUM,

418: p_last_update_login),
419: source_lang = USERENV('LANG')
420: WHERE section_id = p_section_id
421: -- AND object_version_number = decode(p_object_version_number,
422: -- FND_API.G_MISS_NUM,
423: -- object_version_number,
424: -- p_object_version_number)
425: AND USERENV('LANG') IN (language, source_lang);
426:

Line 467: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,

463: PROCEDURE load_row
464: (
465: p_owner IN VARCHAR2,
466: p_section_id IN NUMBER,
467: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
468: p_access_name IN VARCHAR2,
469: p_start_date_active IN DATE,
470: p_end_date_active IN DATE,
471: p_section_type_code IN VARCHAR2,

Line 523: (p_object_version_number <> FND_API.G_MISS_NUM))

519: from ibe_dsp_sections_b
520: where SECTION_ID = p_section_id;
521:
522: IF ((p_object_version_number IS NOT NULL) AND
523: (p_object_version_number <> FND_API.G_MISS_NUM))
524: THEN
525: l_object_version_number := p_object_version_number;
526: END IF;
527:

Line 641: -- x_return_status = FND_API.G_RET_STS_SUCCESS, if the section is duplicate

637: -- PROCEDURE Check_Duplicate_Entry()
638: --*****************************************************************************
639:
640: --
641: -- x_return_status = FND_API.G_RET_STS_SUCCESS, if the section is duplicate
642: -- x_return_status = FND_API.G_RET_STS_ERROR, if the section is not duplicate
643: --
644: -- p_section_id is set to NULL by default for create section
645: --

Line 642: -- x_return_status = FND_API.G_RET_STS_ERROR, if the section is not duplicate

638: --*****************************************************************************
639:
640: --
641: -- x_return_status = FND_API.G_RET_STS_SUCCESS, if the section is duplicate
642: -- x_return_status = FND_API.G_RET_STS_ERROR, if the section is not duplicate
643: --
644: -- p_section_id is set to NULL by default for create section
645: --
646: --

Line 648: -- When creating sections, the p_section_id should be FND_API.G_MISS_NUM, and

644: -- p_section_id is set to NULL by default for create section
645: --
646: --
647: -- This procedure is used by both when creating and updating sections
648: -- When creating sections, the p_section_id should be FND_API.G_MISS_NUM, and
649: -- when updating sections, the p_section_id should be not FND_API.G_MISS_NUM
650: --
651: PROCEDURE Check_Duplicate_Entry
652: (

Line 649: -- when updating sections, the p_section_id should be not FND_API.G_MISS_NUM

645: --
646: --
647: -- This procedure is used by both when creating and updating sections
648: -- When creating sections, the p_section_id should be FND_API.G_MISS_NUM, and
649: -- when updating sections, the p_section_id should be not FND_API.G_MISS_NUM
650: --
651: PROCEDURE Check_Duplicate_Entry
652: (
653: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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

649: -- when updating sections, the p_section_id should be not FND_API.G_MISS_NUM
650: --
651: PROCEDURE Check_Duplicate_Entry
652: (
653: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
654: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
655: p_access_name IN VARCHAR2,
656: p_display_name IN VARCHAR2,
657: x_return_status OUT NOCOPY VARCHAR2,

Line 654: p_section_id IN NUMBER := FND_API.G_MISS_NUM,

650: --
651: PROCEDURE Check_Duplicate_Entry
652: (
653: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
654: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
655: p_access_name IN VARCHAR2,
656: p_display_name IN VARCHAR2,
657: x_return_status OUT NOCOPY VARCHAR2,
658: x_msg_count OUT NOCOPY NUMBER,

Line 688: l_in_section_id := FND_API.G_MISS_NUM;

684:
685: -- To prevent comparison condition disasters with NULL
686: IF(l_in_section_id IS NULL) THEN
687: -- l_in_section_id will be NULL only if Creating Section
688: l_in_section_id := FND_API.G_MISS_NUM;
689: END IF;
690:
691: -- Initialize message list if p_init_msg_list is set to TRUE.
692: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 692: IF FND_API.to_Boolean(p_init_msg_list) THEN

688: l_in_section_id := FND_API.G_MISS_NUM;
689: END IF;
690:
691: -- Initialize message list if p_init_msg_list is set to TRUE.
692: IF FND_API.to_Boolean(p_init_msg_list) THEN
693: FND_MSG_PUB.initialize;
694: END IF;
695:
696: -- Initialize API return status to error, i.e, its not duplicate

Line 697: x_return_status := FND_API.G_RET_STS_ERROR;

693: FND_MSG_PUB.initialize;
694: END IF;
695:
696: -- Initialize API return status to error, i.e, its not duplicate
697: x_return_status := FND_API.G_RET_STS_ERROR;
698:
699: -- Check duplicate access_name
700: IF ((p_access_name IS NOT NULL) AND
701: (p_access_name <> FND_API.G_MISS_CHAR))

Line 701: (p_access_name <> FND_API.G_MISS_CHAR))

697: x_return_status := FND_API.G_RET_STS_ERROR;
698:
699: -- Check duplicate access_name
700: IF ((p_access_name IS NOT NULL) AND
701: (p_access_name <> FND_API.G_MISS_CHAR))
702: THEN
703:
704: OPEN c1(p_access_name);
705: FETCH c1 INTO l_tmp_section_id;

Line 709: IF (l_in_section_id = FND_API.G_MISS_NUM) THEN

705: FETCH c1 INTO l_tmp_section_id;
706: IF (c1%FOUND) THEN
707:
708: CLOSE c1;
709: IF (l_in_section_id = FND_API.G_MISS_NUM) THEN
710: -- For Create Section
711: IF (l_tmp_section_id IS NOT NULL) THEN
712: -- found duplicate
713: RAISE FND_API.G_EXC_ERROR;

Line 713: RAISE FND_API.G_EXC_ERROR;

709: IF (l_in_section_id = FND_API.G_MISS_NUM) THEN
710: -- For Create Section
711: IF (l_tmp_section_id IS NOT NULL) THEN
712: -- found duplicate
713: RAISE FND_API.G_EXC_ERROR;
714: END IF;
715: ELSE
716: -- For Update Section
717: IF (l_tmp_section_id <> l_in_section_id) THEN

Line 719: RAISE FND_API.G_EXC_ERROR;

715: ELSE
716: -- For Update Section
717: IF (l_tmp_section_id <> l_in_section_id) THEN
718: -- found duplicate
719: RAISE FND_API.G_EXC_ERROR;
720: END IF;
721: END IF;
722: ELSE
723: -- not duplicate

Line 733: -- (p_display_name <> FND_API.G_MISS_CHAR))

729:
730: -- Check duplicate display_name
731: -- Commented out as we can have sections with duplicate section names
732: -- IF ((p_display_name IS NOT NULL) AND
733: -- (p_display_name <> FND_API.G_MISS_CHAR))
734: -- THEN
735: --
736: -- -- If Update Section, add the following string to WHERE clause
737: -- IF(l_in_section_id <> FND_API.G_MISS_NUM) THEN

Line 737: -- IF(l_in_section_id <> FND_API.G_MISS_NUM) THEN

733: -- (p_display_name <> FND_API.G_MISS_CHAR))
734: -- THEN
735: --
736: -- -- If Update Section, add the following string to WHERE clause
737: -- IF(l_in_section_id <> FND_API.G_MISS_NUM) THEN
738: -- l_tmp_sql_str := ' AND language = USERENV(''LANG''))';
739: -- END IF;
740: --
741: -- OPEN c2(p_display_name, l_tmp_sql_str);

Line 746: -- IF (l_in_section_id = FND_API.G_MISS_NUM) THEN

742: -- FETCH c2 INTO l_tmp_section_id;
743: -- IF (c2%FOUND) THEN
744: --
745: -- CLOSE c2;
746: -- IF (l_in_section_id = FND_API.G_MISS_NUM) THEN
747: -- -- For Create Section
748: -- IF (l_tmp_section_id IS NOT NULL) THEN
749: -- -- found duplicate
750: -- RAISE FND_API.G_EXC_ERROR;

Line 750: -- RAISE FND_API.G_EXC_ERROR;

746: -- IF (l_in_section_id = FND_API.G_MISS_NUM) THEN
747: -- -- For Create Section
748: -- IF (l_tmp_section_id IS NOT NULL) THEN
749: -- -- found duplicate
750: -- RAISE FND_API.G_EXC_ERROR;
751: -- END IF;
752: -- ELSE
753: -- -- For Update Section
754: -- IF (l_tmp_section_id <> l_in_section_id) THEN

Line 756: -- RAISE FND_API.G_EXC_ERROR;

752: -- ELSE
753: -- -- For Update Section
754: -- IF (l_tmp_section_id <> l_in_section_id) THEN
755: -- -- found duplicate
756: -- RAISE FND_API.G_EXC_ERROR;
757: -- END IF;
758: -- END IF;
759: -- ELSE
760: -- -- not duplicate

Line 769: WHEN FND_API.G_EXC_ERROR THEN

765: -- END IF;
766:
767: EXCEPTION
768:
769: WHEN FND_API.G_EXC_ERROR THEN
770: x_return_status := FND_API.G_RET_STS_SUCCESS; -- found duplicate
771: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
772: p_data => x_msg_data,
773: p_encoded => 'F');

Line 770: x_return_status := FND_API.G_RET_STS_SUCCESS; -- found duplicate

766:
767: EXCEPTION
768:
769: WHEN FND_API.G_EXC_ERROR THEN
770: x_return_status := FND_API.G_RET_STS_SUCCESS; -- found duplicate
771: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
772: p_data => x_msg_data,
773: p_encoded => 'F');
774:

Line 775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

771: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
772: p_data => x_msg_data,
773: p_encoded => 'F');
774:
775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
777: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
778: p_data => x_msg_data,
779: p_encoded => 'F');

Line 776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

772: p_data => x_msg_data,
773: p_encoded => 'F');
774:
775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
777: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
778: p_data => x_msg_data,
779: p_encoded => 'F');
780:

Line 788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

784: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
785: FND_MESSAGE.Set_Token('REASON', SQLERRM);
786: FND_MSG_PUB.Add;
787:
788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
789:
790: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
791: THEN
792: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

Line 805: -- IF x_return_status := FND_API.G_RET_STS_ERROR, then invalid

801:
802: --*****************************************************************************
803: -- PROCEDURE Validate_Create()
804: --*****************************************************************************
805: -- IF x_return_status := FND_API.G_RET_STS_ERROR, then invalid
806: -- IF x_return_status := FND_API.G_RET_STS_SUCCESS, then valid
807:
808: PROCEDURE Validate_Create
809: (

Line 806: -- IF x_return_status := FND_API.G_RET_STS_SUCCESS, then valid

802: --*****************************************************************************
803: -- PROCEDURE Validate_Create()
804: --*****************************************************************************
805: -- IF x_return_status := FND_API.G_RET_STS_ERROR, then invalid
806: -- IF x_return_status := FND_API.G_RET_STS_SUCCESS, then valid
807:
808: PROCEDURE Validate_Create
809: (
810: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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

806: -- IF x_return_status := FND_API.G_RET_STS_SUCCESS, then valid
807:
808: PROCEDURE Validate_Create
809: (
810: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
811: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
812: p_access_name IN VARCHAR2,
813: p_start_date_active IN DATE,
814: p_end_date_active IN DATE,

Line 811: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

807:
808: PROCEDURE Validate_Create
809: (
810: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
811: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
812: p_access_name IN VARCHAR2,
813: p_start_date_active IN DATE,
814: p_end_date_active IN DATE,
815: p_section_type_code IN VARCHAR2,

Line 867: IF FND_API.to_Boolean(p_init_msg_list) THEN

863:
864: BEGIN
865:
866: -- Initialize message list if p_init_msg_list is set to TRUE.
867: IF FND_API.to_Boolean(p_init_msg_list) THEN
868: FND_MSG_PUB.initialize;
869: END IF;
870:
871: -- Initialize API return status to success

Line 872: x_return_status := FND_API.G_RET_STS_SUCCESS;

868: FND_MSG_PUB.initialize;
869: END IF;
870:
871: -- Initialize API return status to success
872: x_return_status := FND_API.G_RET_STS_SUCCESS;
873:
874: --
875: -- Check null values for required fields
876: --

Line 879: (p_display_name = FND_API.G_MISS_CHAR))

875: -- Check null values for required fields
876: --
877: -- display_name
878: IF ((p_display_name IS NULL) OR
879: (p_display_name = FND_API.G_MISS_CHAR))
880: THEN
881: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_INVALID_DSP_NAME');
882: FND_MSG_PUB.Add;
883: RAISE FND_API.G_EXC_ERROR;

Line 883: RAISE FND_API.G_EXC_ERROR;

879: (p_display_name = FND_API.G_MISS_CHAR))
880: THEN
881: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_INVALID_DSP_NAME');
882: FND_MSG_PUB.Add;
883: RAISE FND_API.G_EXC_ERROR;
884: END IF;
885:
886: -- section_type_code
887: IF ((p_section_type_code IS NULL) OR

Line 888: (p_section_type_code = FND_API.G_MISS_CHAR))

884: END IF;
885:
886: -- section_type_code
887: IF ((p_section_type_code IS NULL) OR
888: (p_section_type_code = FND_API.G_MISS_CHAR))
889: THEN
890: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_INVALID_SCT_TYPE');
891: FND_MSG_PUB.Add;
892: RAISE FND_API.G_EXC_ERROR;

Line 892: RAISE FND_API.G_EXC_ERROR;

888: (p_section_type_code = FND_API.G_MISS_CHAR))
889: THEN
890: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_INVALID_SCT_TYPE');
891: FND_MSG_PUB.Add;
892: RAISE FND_API.G_EXC_ERROR;
893: END IF;
894:
895: -- status_code
896: IF ((p_status_code IS NULL) OR

Line 897: (p_status_code = FND_API.G_MISS_CHAR))

893: END IF;
894:
895: -- status_code
896: IF ((p_status_code IS NULL) OR
897: (p_status_code = FND_API.G_MISS_CHAR))
898: THEN
899: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_INVALID_STATUS');
900: FND_MSG_PUB.Add;
901: RAISE FND_API.G_EXC_ERROR;

Line 901: RAISE FND_API.G_EXC_ERROR;

897: (p_status_code = FND_API.G_MISS_CHAR))
898: THEN
899: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_INVALID_STATUS');
900: FND_MSG_PUB.Add;
901: RAISE FND_API.G_EXC_ERROR;
902: END IF;
903:
904: -- start_date_active
905: IF ((p_start_date_active IS NULL) OR

Line 906: (p_start_date_active = FND_API.G_MISS_DATE))

902: END IF;
903:
904: -- start_date_active
905: IF ((p_start_date_active IS NULL) OR
906: (p_start_date_active = FND_API.G_MISS_DATE))
907: THEN
908: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_INVALID_START_DATE');
909: FND_MSG_PUB.Add;
910: RAISE FND_API.G_EXC_ERROR;

Line 910: RAISE FND_API.G_EXC_ERROR;

906: (p_start_date_active = FND_API.G_MISS_DATE))
907: THEN
908: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_INVALID_START_DATE');
909: FND_MSG_PUB.Add;
910: RAISE FND_API.G_EXC_ERROR;
911: END IF;
912:
913: --
914: -- non-null field validation

Line 918: (p_available_in_all_sites_flag <> FND_API.G_MISS_CHAR))

914: -- non-null field validation
915: --
916: -- p_available_in_all_sites_flag
917: IF ((p_available_in_all_sites_flag IS NOT NULL) AND
918: (p_available_in_all_sites_flag <> FND_API.G_MISS_CHAR))
919: THEN
920: IF(p_available_in_all_sites_flag <> 'Y' AND
921: p_available_in_all_sites_flag <> 'N')
922: THEN

Line 925: RAISE FND_API.G_EXC_ERROR;

921: p_available_in_all_sites_flag <> 'N')
922: THEN
923: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_INVALID_AVL_FLAG');
924: FND_MSG_PUB.Add;
925: RAISE FND_API.G_EXC_ERROR;
926: END IF;
927: END IF;
928:
929: -- p_auto_placement_rule

Line 931: (p_auto_placement_rule <> FND_API.G_MISS_CHAR))

927: END IF;
928:
929: -- p_auto_placement_rule
930: IF ((p_auto_placement_rule IS NOT NULL) AND
931: (p_auto_placement_rule <> FND_API.G_MISS_CHAR))
932: THEN
933: Is_SQL_Valid
934: (
935: p_auto_placement_rule,

Line 939: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

935: p_auto_placement_rule,
936: x_return_status
937: );
938:
939: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
940: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
941: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
942: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_INVALID_AUTO_PLACE');
943: FND_MESSAGE.Set_Token('AUTO_PLACEMENT_RULE', p_auto_placement_rule);

Line 940: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

936: x_return_status
937: );
938:
939: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
940: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
941: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
942: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_INVALID_AUTO_PLACE');
943: FND_MESSAGE.Set_Token('AUTO_PLACEMENT_RULE', p_auto_placement_rule);
944: FND_MSG_PUB.Add;

Line 941: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

937: );
938:
939: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
940: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
941: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
942: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_INVALID_AUTO_PLACE');
943: FND_MESSAGE.Set_Token('AUTO_PLACEMENT_RULE', p_auto_placement_rule);
944: FND_MSG_PUB.Add;
945: RAISE FND_API.G_EXC_ERROR;

Line 945: RAISE FND_API.G_EXC_ERROR;

941: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
942: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_INVALID_AUTO_PLACE');
943: FND_MESSAGE.Set_Token('AUTO_PLACEMENT_RULE', p_auto_placement_rule);
944: FND_MSG_PUB.Add;
945: RAISE FND_API.G_EXC_ERROR;
946: END IF;
947:
948: END IF;
949:

Line 952: (p_order_by_clause <> FND_API.G_MISS_CHAR))

948: END IF;
949:
950: -- p_order_by_clause
951: IF ((p_order_by_clause IS NOT NULL) AND
952: (p_order_by_clause <> FND_API.G_MISS_CHAR))
953: THEN
954: Is_SQL_Valid
955: (
956: 'SELECT rowid FROM mtl_system_items_vl WHERE rownum < 1 '

Line 961: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

957: || ' ORDER BY ' || p_order_by_clause,
958: x_return_status
959: );
960:
961: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
963: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
964: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_INVALID_ORDER_BY');
965: FND_MESSAGE.Set_Token('ORDER_BY_CLAUSE', p_order_by_clause);

Line 962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

958: x_return_status
959: );
960:
961: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
963: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
964: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_INVALID_ORDER_BY');
965: FND_MESSAGE.Set_Token('ORDER_BY_CLAUSE', p_order_by_clause);
966: FND_MSG_PUB.Add;

Line 963: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

959: );
960:
961: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
963: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
964: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_INVALID_ORDER_BY');
965: FND_MESSAGE.Set_Token('ORDER_BY_CLAUSE', p_order_by_clause);
966: FND_MSG_PUB.Add;
967: RAISE FND_API.G_EXC_ERROR;

Line 967: RAISE FND_API.G_EXC_ERROR;

963: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
964: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_INVALID_ORDER_BY');
965: FND_MESSAGE.Set_Token('ORDER_BY_CLAUSE', p_order_by_clause);
966: FND_MSG_PUB.Add;
967: RAISE FND_API.G_EXC_ERROR;
968: END IF;
969:
970: END IF;
971:

Line 973: Check_Duplicate_Entry(p_init_msg_list => FND_API.G_FALSE,

969:
970: END IF;
971:
972: -- Validate if the section is duplicate
973: Check_Duplicate_Entry(p_init_msg_list => FND_API.G_FALSE,
974: p_section_id => FND_API.G_MISS_NUM,
975: p_access_name => p_access_name,
976: p_display_name => p_display_name,
977: x_return_status => l_return_status,

Line 974: p_section_id => FND_API.G_MISS_NUM,

970: END IF;
971:
972: -- Validate if the section is duplicate
973: Check_Duplicate_Entry(p_init_msg_list => FND_API.G_FALSE,
974: p_section_id => FND_API.G_MISS_NUM,
975: p_access_name => p_access_name,
976: p_display_name => p_display_name,
977: x_return_status => l_return_status,
978: x_msg_count => l_msg_count,

Line 981: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

977: x_return_status => l_return_status,
978: x_msg_count => l_msg_count,
979: x_msg_data => l_msg_data);
980:
981: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
983: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
984: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_DUPLICATE_SECT');
985: FND_MSG_PUB.Add;

Line 982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

978: x_msg_count => l_msg_count,
979: x_msg_data => l_msg_data);
980:
981: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
983: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
984: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_DUPLICATE_SECT');
985: FND_MSG_PUB.Add;
986: RAISE FND_API.G_EXC_ERROR; -- duplicate section

Line 983: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

979: x_msg_data => l_msg_data);
980:
981: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
983: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
984: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_DUPLICATE_SECT');
985: FND_MSG_PUB.Add;
986: RAISE FND_API.G_EXC_ERROR; -- duplicate section
987: END IF;

Line 986: RAISE FND_API.G_EXC_ERROR; -- duplicate section

982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
983: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
984: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_DUPLICATE_SECT');
985: FND_MSG_PUB.Add;
986: RAISE FND_API.G_EXC_ERROR; -- duplicate section
987: END IF;
988:
989: --
990: -- Foreign key integrity constraint check

Line 994: (p_display_context_id <> FND_API.G_MISS_NUM))

990: -- Foreign key integrity constraint check
991: --
992: -- display context id
993: IF ((p_display_context_id IS NOT NULL) AND
994: (p_display_context_id <> FND_API.G_MISS_NUM))
995: THEN
996: BEGIN
997: SELECT context_id INTO l_display_context_id FROM ibe_dsp_context_b
998: WHERE context_id = p_display_context_id;

Line 1004: RAISE FND_API.G_EXC_ERROR;

1000: WHEN NO_DATA_FOUND THEN
1001: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_DSP_CTX');
1002: FND_MESSAGE.Set_Token('DISPLAY_CONTEXT', p_display_context_id);
1003: FND_MSG_PUB.Add;
1004: RAISE FND_API.G_EXC_ERROR;
1005: WHEN OTHERS THEN
1006: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1007: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1008: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

Line 1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1010: FND_MSG_PUB.Add;
1011:
1012: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_GET_DSP_CTX');
1013: FND_MSG_PUB.Add;
1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1015: END;
1016: END IF;
1017:
1018: -- deliverable id

Line 1020: (p_deliverable_id <> FND_API.G_MISS_NUM))

1016: END IF;
1017:
1018: -- deliverable id
1019: IF ((p_deliverable_id IS NOT NULL) AND
1020: (p_deliverable_id <> FND_API.G_MISS_NUM))
1021: THEN
1022: BEGIN
1023: SELECT item_id INTO l_deliverable_id FROM jtf_amv_items_b
1024: WHERE item_id = p_deliverable_id;

Line 1030: RAISE FND_API.G_EXC_ERROR;

1026: WHEN NO_DATA_FOUND THEN
1027: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_DLVRBL');
1028: FND_MESSAGE.Set_Token('DELIVERABLE', p_deliverable_id);
1029: FND_MSG_PUB.Add;
1030: RAISE FND_API.G_EXC_ERROR;
1031: WHEN OTHERS THEN
1032: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1033: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1034: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

Line 1040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1036: FND_MSG_PUB.Add;
1037:
1038: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_GET_DLVRBL');
1039: FND_MSG_PUB.Add;
1040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1041: END;
1042: END IF;
1043:
1044: -- section type code

Line 1056: RAISE FND_API.G_EXC_ERROR;

1052: WHEN NO_DATA_FOUND THEN
1053: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_SCT_TYPE');
1054: FND_MESSAGE.Set_Token('SECTION_TYPE', p_section_type_code);
1055: FND_MSG_PUB.Add;
1056: RAISE FND_API.G_EXC_ERROR;
1057: WHEN OTHERS THEN
1058: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1059: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1060: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

Line 1066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1062: FND_MSG_PUB.Add;
1063:
1064: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_GET_SCT_TYPE');
1065: FND_MSG_PUB.Add;
1066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1067: END;
1068:
1069: -- status code
1070: -- note that p_status_code won't be NULL due to previous checks

Line 1078: RAISE FND_API.G_EXC_ERROR;

1074: CLOSE c3;
1075: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_STATUS');
1076: FND_MESSAGE.Set_Token('STATUS', p_status_code);
1077: FND_MSG_PUB.Add;
1078: RAISE FND_API.G_EXC_ERROR;
1079: END IF;
1080: CLOSE c3;
1081:
1082: EXCEPTION

Line 1084: WHEN FND_API.G_EXC_ERROR THEN

1080: CLOSE c3;
1081:
1082: EXCEPTION
1083:
1084: WHEN FND_API.G_EXC_ERROR THEN
1085: x_return_status := FND_API.G_RET_STS_ERROR;
1086: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1087: p_data => x_msg_data,
1088: p_encoded => 'F');

Line 1085: x_return_status := FND_API.G_RET_STS_ERROR;

1081:
1082: EXCEPTION
1083:
1084: WHEN FND_API.G_EXC_ERROR THEN
1085: x_return_status := FND_API.G_RET_STS_ERROR;
1086: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1087: p_data => x_msg_data,
1088: p_encoded => 'F');
1089:

Line 1090: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1086: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1087: p_data => x_msg_data,
1088: p_encoded => 'F');
1089:
1090: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1092: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1093: p_data => x_msg_data,
1094: p_encoded => 'F');

Line 1091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1087: p_data => x_msg_data,
1088: p_encoded => 'F');
1089:
1090: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1092: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1093: p_data => x_msg_data,
1094: p_encoded => 'F');
1095:

Line 1103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1099: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1100: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1101: FND_MSG_PUB.Add;
1102:
1103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1104:
1105: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1106: THEN
1107: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

Line 1120: -- IF x_return_status := FND_API.G_RET_STS_ERROR, then invalid

1116:
1117: --*****************************************************************************
1118: -- PROCEDURE Validate_Update()
1119: --*****************************************************************************
1120: -- IF x_return_status := FND_API.G_RET_STS_ERROR, then invalid
1121: -- IF x_return_status := FND_API.G_RET_STS_SUCCESS, then valid
1122:
1123: PROCEDURE Validate_Update
1124: (

Line 1121: -- IF x_return_status := FND_API.G_RET_STS_SUCCESS, then valid

1117: --*****************************************************************************
1118: -- PROCEDURE Validate_Update()
1119: --*****************************************************************************
1120: -- IF x_return_status := FND_API.G_RET_STS_ERROR, then invalid
1121: -- IF x_return_status := FND_API.G_RET_STS_SUCCESS, then valid
1122:
1123: PROCEDURE Validate_Update
1124: (
1125: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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

1121: -- IF x_return_status := FND_API.G_RET_STS_SUCCESS, then valid
1122:
1123: PROCEDURE Validate_Update
1124: (
1125: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1126: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1127: p_section_id IN NUMBER,
1128: p_object_version_number IN NUMBER,
1129: p_access_name IN VARCHAR2,

Line 1126: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1122:
1123: PROCEDURE Validate_Update
1124: (
1125: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1126: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1127: p_section_id IN NUMBER,
1128: p_object_version_number IN NUMBER,
1129: p_access_name IN VARCHAR2,
1130: p_start_date_active IN DATE,

Line 1184: IF FND_API.to_Boolean(p_init_msg_list) THEN

1180:
1181: BEGIN
1182:
1183: -- Initialize message list if p_init_msg_list is set to TRUE.
1184: IF FND_API.to_Boolean(p_init_msg_list) THEN
1185: FND_MSG_PUB.initialize;
1186: END IF;
1187:
1188: -- Initialize API return status to success

Line 1189: x_return_status := FND_API.G_RET_STS_SUCCESS;

1185: FND_MSG_PUB.initialize;
1186: END IF;
1187:
1188: -- Initialize API return status to success
1189: x_return_status := FND_API.G_RET_STS_SUCCESS;
1190:
1191: --
1192: -- Check null values for required fields
1193: --

Line 1198: RAISE FND_API.G_EXC_ERROR;

1194: -- section_id
1195: IF (p_section_id IS NULL) THEN
1196: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NULL_SCT_ID');
1197: FND_MSG_PUB.Add;
1198: RAISE FND_API.G_EXC_ERROR;
1199: END IF;
1200:
1201: -- display_name
1202: IF (p_display_name IS NULL) THEN

Line 1205: RAISE FND_API.G_EXC_ERROR;

1201: -- display_name
1202: IF (p_display_name IS NULL) THEN
1203: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NULL_DSP_NAME');
1204: FND_MSG_PUB.Add;
1205: RAISE FND_API.G_EXC_ERROR;
1206: END IF;
1207:
1208: -- section_type_code
1209: IF (p_section_type_code IS NULL) THEN

Line 1212: RAISE FND_API.G_EXC_ERROR;

1208: -- section_type_code
1209: IF (p_section_type_code IS NULL) THEN
1210: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NULL_SCT_TYPE');
1211: FND_MSG_PUB.Add;
1212: RAISE FND_API.G_EXC_ERROR;
1213: END IF;
1214:
1215: -- status_code
1216: IF (p_status_code IS NULL) THEN

Line 1219: RAISE FND_API.G_EXC_ERROR;

1215: -- status_code
1216: IF (p_status_code IS NULL) THEN
1217: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NULL_STATUS');
1218: FND_MSG_PUB.Add;
1219: RAISE FND_API.G_EXC_ERROR;
1220: END IF;
1221:
1222: -- start_date_active
1223: IF (p_start_date_active IS NULL) THEN

Line 1226: RAISE FND_API.G_EXC_ERROR;

1222: -- start_date_active
1223: IF (p_start_date_active IS NULL) THEN
1224: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NULL_START_DATE');
1225: FND_MSG_PUB.Add;
1226: RAISE FND_API.G_EXC_ERROR;
1227: END IF;
1228:
1229: -- non-null field validation
1230: IF ((p_available_in_all_sites_flag IS NOT NULL) AND

Line 1231: (p_available_in_all_sites_flag <> FND_API.G_MISS_CHAR))

1227: END IF;
1228:
1229: -- non-null field validation
1230: IF ((p_available_in_all_sites_flag IS NOT NULL) AND
1231: (p_available_in_all_sites_flag <> FND_API.G_MISS_CHAR))
1232: THEN
1233: IF(p_available_in_all_sites_flag <> 'Y' AND
1234: p_available_in_all_sites_flag <> 'N')
1235: THEN

Line 1238: RAISE FND_API.G_EXC_ERROR;

1234: p_available_in_all_sites_flag <> 'N')
1235: THEN
1236: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_INVALID_AVL_FLAG');
1237: FND_MSG_PUB.Add;
1238: RAISE FND_API.G_EXC_ERROR;
1239: END IF;
1240: END IF;
1241:
1242: -- p_auto_placement_rule

Line 1244: (p_auto_placement_rule <> FND_API.G_MISS_CHAR))

1240: END IF;
1241:
1242: -- p_auto_placement_rule
1243: IF ((p_auto_placement_rule IS NOT NULL) AND
1244: (p_auto_placement_rule <> FND_API.G_MISS_CHAR))
1245: THEN
1246: Is_SQL_Valid
1247: (
1248: p_auto_placement_rule,

Line 1252: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1248: p_auto_placement_rule,
1249: x_return_status
1250: );
1251:
1252: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1254: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1255: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_INVALID_AUTO_PLACE');
1256: FND_MESSAGE.Set_Token('AUTO_PLACEMENT_RULE', p_auto_placement_rule);

Line 1253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1249: x_return_status
1250: );
1251:
1252: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1254: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1255: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_INVALID_AUTO_PLACE');
1256: FND_MESSAGE.Set_Token('AUTO_PLACEMENT_RULE', p_auto_placement_rule);
1257: FND_MSG_PUB.Add;

Line 1254: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

1250: );
1251:
1252: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1254: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1255: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_INVALID_AUTO_PLACE');
1256: FND_MESSAGE.Set_Token('AUTO_PLACEMENT_RULE', p_auto_placement_rule);
1257: FND_MSG_PUB.Add;
1258: RAISE FND_API.G_EXC_ERROR;

Line 1258: RAISE FND_API.G_EXC_ERROR;

1254: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1255: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_INVALID_AUTO_PLACE');
1256: FND_MESSAGE.Set_Token('AUTO_PLACEMENT_RULE', p_auto_placement_rule);
1257: FND_MSG_PUB.Add;
1258: RAISE FND_API.G_EXC_ERROR;
1259: END IF;
1260:
1261: END IF;
1262:

Line 1265: (p_order_by_clause <> FND_API.G_MISS_CHAR))

1261: END IF;
1262:
1263: -- p_order_by_clause
1264: IF ((p_order_by_clause IS NOT NULL) AND
1265: (p_order_by_clause <> FND_API.G_MISS_CHAR))
1266: THEN
1267: Is_SQL_Valid
1268: (
1269: 'SELECT rowid FROM mtl_system_items_vl WHERE rownum < 1 '

Line 1274: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1270: || ' ORDER BY ' || p_order_by_clause,
1271: x_return_status
1272: );
1273:
1274: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1276: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1277: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_INVALID_ORDER_BY');
1278: FND_MESSAGE.Set_Token('ORDER_BY_CLAUSE', p_order_by_clause);

Line 1275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1271: x_return_status
1272: );
1273:
1274: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1276: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1277: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_INVALID_ORDER_BY');
1278: FND_MESSAGE.Set_Token('ORDER_BY_CLAUSE', p_order_by_clause);
1279: FND_MSG_PUB.Add;

Line 1276: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

1272: );
1273:
1274: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1276: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1277: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_INVALID_ORDER_BY');
1278: FND_MESSAGE.Set_Token('ORDER_BY_CLAUSE', p_order_by_clause);
1279: FND_MSG_PUB.Add;
1280: RAISE FND_API.G_EXC_ERROR;

Line 1280: RAISE FND_API.G_EXC_ERROR;

1276: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1277: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_INVALID_ORDER_BY');
1278: FND_MESSAGE.Set_Token('ORDER_BY_CLAUSE', p_order_by_clause);
1279: FND_MSG_PUB.Add;
1280: RAISE FND_API.G_EXC_ERROR;
1281: END IF;
1282:
1283: END IF;
1284:

Line 1287: Check_Duplicate_Entry(p_init_msg_list => FND_API.G_FALSE,

1283: END IF;
1284:
1285: -- Validate if the (unique) fields to be updated doesn't already exist
1286: -- for some other section
1287: Check_Duplicate_Entry(p_init_msg_list => FND_API.G_FALSE,
1288: p_section_id => p_section_id,
1289: p_access_name => p_access_name,
1290: p_display_name => p_display_name,
1291: x_return_status => l_return_status,

Line 1295: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1291: x_return_status => l_return_status,
1292: x_msg_count => l_msg_count,
1293: x_msg_data => l_msg_data);
1294:
1295: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1297: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1298: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_DUPLICATE_SECT');
1299: FND_MSG_PUB.Add;

Line 1296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1292: x_msg_count => l_msg_count,
1293: x_msg_data => l_msg_data);
1294:
1295: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1297: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1298: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_DUPLICATE_SECT');
1299: FND_MSG_PUB.Add;
1300: RAISE FND_API.G_EXC_ERROR; -- duplicate fields

Line 1297: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1293: x_msg_data => l_msg_data);
1294:
1295: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1297: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1298: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_DUPLICATE_SECT');
1299: FND_MSG_PUB.Add;
1300: RAISE FND_API.G_EXC_ERROR; -- duplicate fields
1301: END IF;

Line 1300: RAISE FND_API.G_EXC_ERROR; -- duplicate fields

1296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1297: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1298: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_DUPLICATE_SECT');
1299: FND_MSG_PUB.Add;
1300: RAISE FND_API.G_EXC_ERROR; -- duplicate fields
1301: END IF;
1302:
1303: --
1304: -- Foreign key integrity constraint check

Line 1308: (p_display_context_id <> FND_API.G_MISS_NUM))

1304: -- Foreign key integrity constraint check
1305: --
1306: -- display context id
1307: IF ((p_display_context_id IS NOT NULL) AND
1308: (p_display_context_id <> FND_API.G_MISS_NUM))
1309: THEN
1310: BEGIN
1311: SELECT context_id INTO l_display_context_id FROM ibe_dsp_context_b
1312: WHERE context_id = p_display_context_id;

Line 1318: RAISE FND_API.G_EXC_ERROR;

1314: WHEN NO_DATA_FOUND THEN
1315: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_DSP_CTX');
1316: FND_MESSAGE.Set_Token('DISPLAY_CONTEXT', p_display_context_id);
1317: FND_MSG_PUB.Add;
1318: RAISE FND_API.G_EXC_ERROR;
1319: WHEN OTHERS THEN
1320: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1321: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1322: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

Line 1328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1324: FND_MSG_PUB.Add;
1325:
1326: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_GET_DSP_CTX');
1327: FND_MSG_PUB.Add;
1328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1329: END;
1330: END IF;
1331:
1332: -- deliverable id

Line 1334: (p_deliverable_id <> FND_API.G_MISS_NUM))

1330: END IF;
1331:
1332: -- deliverable id
1333: IF ((p_deliverable_id IS NOT NULL) AND
1334: (p_deliverable_id <> FND_API.G_MISS_NUM))
1335: THEN
1336: BEGIN
1337: SELECT item_id INTO l_deliverable_id FROM jtf_amv_items_b
1338: WHERE item_id = p_deliverable_id;

Line 1344: RAISE FND_API.G_EXC_ERROR;

1340: WHEN NO_DATA_FOUND THEN
1341: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_DLVRBL');
1342: FND_MESSAGE.Set_Token('DELIVERABLE', p_deliverable_id);
1343: FND_MSG_PUB.Add;
1344: RAISE FND_API.G_EXC_ERROR;
1345: WHEN OTHERS THEN
1346: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1347: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1348: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

Line 1354: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1350: FND_MSG_PUB.Add;
1351:
1352: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_GET_DLVRBL');
1353: FND_MSG_PUB.Add;
1354: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1355: END;
1356: END IF;
1357:
1358: -- section type code

Line 1360: IF (p_section_type_code <> FND_API.G_MISS_CHAR) THEN

1356: END IF;
1357:
1358: -- section type code
1359: -- note that p_section_type_code won't be NULL due to previous checks
1360: IF (p_section_type_code <> FND_API.G_MISS_CHAR) THEN
1361: BEGIN
1362: SELECT lookup_code INTO l_tmp_str FROM fnd_lookup_values
1363: WHERE lookup_type = 'IBE_SECTION_TYPE' AND
1364: lookup_code = p_section_type_code AND

Line 1371: RAISE FND_API.G_EXC_ERROR;

1367: WHEN NO_DATA_FOUND THEN
1368: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_SCT_TYPE');
1369: FND_MESSAGE.Set_Token('SECTION_TYPE', p_section_type_code);
1370: FND_MSG_PUB.Add;
1371: RAISE FND_API.G_EXC_ERROR;
1372: WHEN OTHERS THEN
1373: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1374: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1375: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

Line 1381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1377: FND_MSG_PUB.Add;
1378:
1379: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_GET_SCT_TYPE');
1380: FND_MSG_PUB.Add;
1381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1382: END;
1383: END IF;
1384:
1385: -- status code

Line 1387: IF (p_status_code <> FND_API.G_MISS_CHAR) THEN

1383: END IF;
1384:
1385: -- status code
1386: -- note that p_status_code won't be NULL due to previous checks
1387: IF (p_status_code <> FND_API.G_MISS_CHAR) THEN
1388: OPEN c3(p_status_code);
1389: FETCH c3 INTO l_tmp_str;
1390: IF (c3%NOTFOUND) THEN
1391: CLOSE c3;

Line 1395: RAISE FND_API.G_EXC_ERROR;

1391: CLOSE c3;
1392: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_STATUS');
1393: FND_MESSAGE.Set_Token('STATUS', p_status_code);
1394: FND_MSG_PUB.Add;
1395: RAISE FND_API.G_EXC_ERROR;
1396: END IF;
1397: CLOSE c3;
1398: END IF;
1399:

Line 1402: WHEN FND_API.G_EXC_ERROR THEN

1398: END IF;
1399:
1400: EXCEPTION
1401:
1402: WHEN FND_API.G_EXC_ERROR THEN
1403: x_return_status := FND_API.G_RET_STS_ERROR;
1404: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1405: p_data => x_msg_data,
1406: p_encoded => 'F');

Line 1403: x_return_status := FND_API.G_RET_STS_ERROR;

1399:
1400: EXCEPTION
1401:
1402: WHEN FND_API.G_EXC_ERROR THEN
1403: x_return_status := FND_API.G_RET_STS_ERROR;
1404: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1405: p_data => x_msg_data,
1406: p_encoded => 'F');
1407:

Line 1408: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1404: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1405: p_data => x_msg_data,
1406: p_encoded => 'F');
1407:
1408: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1410: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1411: p_data => x_msg_data,
1412: p_encoded => 'F');

Line 1409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1405: p_data => x_msg_data,
1406: p_encoded => 'F');
1407:
1408: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1410: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1411: p_data => x_msg_data,
1412: p_encoded => 'F');
1413:

Line 1421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1417: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1418: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1419: FND_MSG_PUB.Add;
1420:
1421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1422:
1423: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1424: THEN
1425: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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

1437:
1438: PROCEDURE Create_Section
1439: (
1440: p_api_version IN NUMBER,
1441: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1442: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1443: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1444: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1445: p_start_date_active IN DATE,

Line 1442: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1438: PROCEDURE Create_Section
1439: (
1440: p_api_version IN NUMBER,
1441: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1442: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1443: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1444: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1445: p_start_date_active IN DATE,
1446: p_end_date_active IN DATE := FND_API.G_MISS_DATE,

Line 1443: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1439: (
1440: p_api_version IN NUMBER,
1441: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1442: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1443: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1444: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1445: p_start_date_active IN DATE,
1446: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
1447: p_section_type_code IN VARCHAR2,

Line 1444: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

1440: p_api_version IN NUMBER,
1441: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1442: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1443: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1444: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1445: p_start_date_active IN DATE,
1446: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
1447: p_section_type_code IN VARCHAR2,
1448: p_status_code IN VARCHAR2,

Line 1446: p_end_date_active IN DATE := FND_API.G_MISS_DATE,

1442: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1443: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1444: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1445: p_start_date_active IN DATE,
1446: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
1447: p_section_type_code IN VARCHAR2,
1448: p_status_code IN VARCHAR2,
1449: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
1450: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,

Line 1449: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,

1445: p_start_date_active IN DATE,
1446: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
1447: p_section_type_code IN VARCHAR2,
1448: p_status_code IN VARCHAR2,
1449: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
1450: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
1451: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1452: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
1453: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1450: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,

1446: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
1447: p_section_type_code IN VARCHAR2,
1448: p_status_code IN VARCHAR2,
1449: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
1450: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
1451: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1452: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
1453: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
1454: p_display_name IN VARCHAR2,

Line 1451: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

1447: p_section_type_code IN VARCHAR2,
1448: p_status_code IN VARCHAR2,
1449: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
1450: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
1451: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1452: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
1453: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
1454: p_display_name IN VARCHAR2,
1455: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1452: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,

1448: p_status_code IN VARCHAR2,
1449: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
1450: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
1451: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1452: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
1453: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
1454: p_display_name IN VARCHAR2,
1455: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1456: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1453: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,

1449: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
1450: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
1451: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1452: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
1453: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
1454: p_display_name IN VARCHAR2,
1455: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1456: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1457: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1455: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

1451: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1452: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
1453: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
1454: p_display_name IN VARCHAR2,
1455: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1456: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1457: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
1458: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
1459: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1456: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

1452: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
1453: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
1454: p_display_name IN VARCHAR2,
1455: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1456: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1457: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
1458: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
1459: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1460: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1457: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,

1453: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
1454: p_display_name IN VARCHAR2,
1455: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1456: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1457: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
1458: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
1459: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1460: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1461: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1458: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

1454: p_display_name IN VARCHAR2,
1455: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1456: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1457: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
1458: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
1459: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1460: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1461: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1462: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1459: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1455: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1456: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1457: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
1458: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
1459: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1460: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1461: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1462: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1463: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1460: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1456: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1457: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
1458: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
1459: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1460: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1461: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1462: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1463: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1464: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1461: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1457: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
1458: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
1459: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1460: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1461: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1462: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1463: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1464: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1465: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1462: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1458: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
1459: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1460: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1461: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1462: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1463: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1464: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1465: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1466: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1463: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1459: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1460: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1461: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1462: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1463: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1464: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1465: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1466: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1467: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1464: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1460: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1461: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1462: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1463: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1464: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1465: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1466: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1467: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1468: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1465: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1461: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1462: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1463: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1464: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1465: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1466: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1467: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1468: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1469: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1466: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1462: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1463: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1464: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1465: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1466: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1467: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1468: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1469: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1470: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1467: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1463: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1464: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1465: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1466: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1467: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1468: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1469: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1470: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1471: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1468: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1464: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1465: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1466: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1467: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1468: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1469: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1470: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1471: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1472: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1469: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1465: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1466: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1467: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1468: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1469: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1470: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1471: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1472: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1473: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1470: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1466: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1467: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1468: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1469: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1470: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1471: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1472: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1473: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1474: x_section_id OUT NOCOPY NUMBER,

Line 1471: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1467: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1468: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1469: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1470: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1471: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1472: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1473: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1474: x_section_id OUT NOCOPY NUMBER,
1475: x_return_status OUT NOCOPY VARCHAR2,

Line 1472: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1468: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1469: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1470: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1471: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1472: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1473: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1474: x_section_id OUT NOCOPY NUMBER,
1475: x_return_status OUT NOCOPY VARCHAR2,
1476: x_msg_count OUT NOCOPY NUMBER,

Line 1473: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1469: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1470: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1471: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1472: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1473: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1474: x_section_id OUT NOCOPY NUMBER,
1475: x_return_status OUT NOCOPY VARCHAR2,
1476: x_msg_count OUT NOCOPY NUMBER,
1477: x_msg_data OUT NOCOPY VARCHAR2

Line 1495: IF NOT FND_API.Compatible_API_Call(l_api_version,

1491: -- Standard Start of API savepoint
1492: SAVEPOINT CREATE_SECTION_GRP;
1493:
1494: -- Standard call to check for call compatibility.
1495: IF NOT FND_API.Compatible_API_Call(l_api_version,
1496: p_api_version,
1497: l_api_name,
1498: G_PKG_NAME)
1499: THEN

Line 1500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1496: p_api_version,
1497: l_api_name,
1498: G_PKG_NAME)
1499: THEN
1500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1501: END IF;
1502:
1503: -- Initialize message list if p_init_msg_list is set to TRUE.
1504: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1504: IF FND_API.to_Boolean(p_init_msg_list) THEN

1500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1501: END IF;
1502:
1503: -- Initialize message list if p_init_msg_list is set to TRUE.
1504: IF FND_API.to_Boolean(p_init_msg_list) THEN
1505: FND_MSG_PUB.initialize;
1506: END IF;
1507:
1508: -- Initialize API return status to success

Line 1509: x_return_status := FND_API.G_RET_STS_SUCCESS;

1505: FND_MSG_PUB.initialize;
1506: END IF;
1507:
1508: -- Initialize API return status to success
1509: x_return_status := FND_API.G_RET_STS_SUCCESS;
1510:
1511: -- API body
1512: -- CALL FLOW :
1513: -- 1. Check if section is valid

Line 1522: p_init_msg_list => FND_API.G_FALSE,

1518: -- 1. Check if section is valid
1519: --
1520: Validate_Create
1521: (
1522: p_init_msg_list => FND_API.G_FALSE,
1523: p_validation_level => p_validation_level,
1524: p_access_name => p_access_name,
1525: p_start_date_active => p_start_date_active,
1526: p_end_date_active => p_end_date_active,

Line 1559: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1555: x_msg_count => l_msg_count,
1556: x_msg_data => l_msg_data
1557: );
1558:
1559: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1561: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1562: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_INVALID_CREATE');
1563: FND_MSG_PUB.Add;

Line 1560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1556: x_msg_data => l_msg_data
1557: );
1558:
1559: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1561: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1562: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_INVALID_CREATE');
1563: FND_MSG_PUB.Add;
1564: RAISE FND_API.G_EXC_ERROR; -- invalid section

Line 1561: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1557: );
1558:
1559: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1561: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1562: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_INVALID_CREATE');
1563: FND_MSG_PUB.Add;
1564: RAISE FND_API.G_EXC_ERROR; -- invalid section
1565: END IF;

Line 1564: RAISE FND_API.G_EXC_ERROR; -- invalid section

1560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1561: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1562: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_INVALID_CREATE');
1563: FND_MSG_PUB.Add;
1564: RAISE FND_API.G_EXC_ERROR; -- invalid section
1565: END IF;
1566:
1567: --
1568: -- 2. Insert row with query data into query table

Line 1573: FND_API.G_MISS_NUM,

1569: --
1570: BEGIN
1571: insert_row
1572: (
1573: FND_API.G_MISS_NUM,
1574: l_object_version_number,
1575: p_access_name,
1576: p_start_date_active,
1577: p_end_date_active,

Line 1617: RAISE FND_API.G_EXC_ERROR;

1613: EXCEPTION
1614: WHEN NO_DATA_FOUND THEN
1615: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_INSERT_FAIL');
1616: FND_MSG_PUB.Add;
1617: RAISE FND_API.G_EXC_ERROR;
1618: WHEN OTHERS THEN
1619: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1620: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1621: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

Line 1627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1623: FND_MSG_PUB.Add;
1624:
1625: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_INSERT_FAIL');
1626: FND_MSG_PUB.Add;
1627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1628: END;
1629:
1630: --
1631: -- End of main API body.

Line 1634: IF (FND_API.To_Boolean(p_commit)) THEN

1630: --
1631: -- End of main API body.
1632:
1633: -- Standard check of p_commit.
1634: IF (FND_API.To_Boolean(p_commit)) THEN
1635: COMMIT WORK;
1636: END IF;
1637:
1638: -- Standard call to get message count and if count is 1, get message info.

Line 1645: WHEN FND_API.G_EXC_ERROR THEN

1641: p_encoded => 'F');
1642:
1643: EXCEPTION
1644:
1645: WHEN FND_API.G_EXC_ERROR THEN
1646: ROLLBACK TO CREATE_SECTION_GRP;
1647: x_return_status := FND_API.G_RET_STS_ERROR;
1648: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1649: p_data => x_msg_data,

Line 1647: x_return_status := FND_API.G_RET_STS_ERROR;

1643: EXCEPTION
1644:
1645: WHEN FND_API.G_EXC_ERROR THEN
1646: ROLLBACK TO CREATE_SECTION_GRP;
1647: x_return_status := FND_API.G_RET_STS_ERROR;
1648: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1649: p_data => x_msg_data,
1650: p_encoded => 'F');
1651:

Line 1652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1648: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1649: p_data => x_msg_data,
1650: p_encoded => 'F');
1651:
1652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1653: ROLLBACK TO CREATE_SECTION_GRP;
1654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1655: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1656: p_data => x_msg_data,

Line 1654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1650: p_encoded => 'F');
1651:
1652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1653: ROLLBACK TO CREATE_SECTION_GRP;
1654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1655: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1656: p_data => x_msg_data,
1657: p_encoded => 'F');
1658:

Line 1668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1664: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1665: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1666: FND_MSG_PUB.Add;
1667:
1668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1669:
1670: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1671: THEN
1672: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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

1680:
1681: PROCEDURE Update_Section
1682: (
1683: p_api_version IN NUMBER,
1684: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1685: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1686: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1687: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
1688: p_object_version_number IN NUMBER,

Line 1685: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1681: PROCEDURE Update_Section
1682: (
1683: p_api_version IN NUMBER,
1684: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1685: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1686: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1687: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
1688: p_object_version_number IN NUMBER,
1689: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1686: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1682: (
1683: p_api_version IN NUMBER,
1684: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1685: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1686: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1687: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
1688: p_object_version_number IN NUMBER,
1689: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1690: p_start_date_active IN DATE := FND_API.G_MISS_DATE,

Line 1687: p_section_id IN NUMBER := FND_API.G_MISS_NUM,

1683: p_api_version IN NUMBER,
1684: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1685: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1686: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1687: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
1688: p_object_version_number IN NUMBER,
1689: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1690: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
1691: p_end_date_active IN DATE := FND_API.G_MISS_DATE,

Line 1689: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

1685: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1686: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1687: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
1688: p_object_version_number IN NUMBER,
1689: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1690: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
1691: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
1692: p_section_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1693: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1690: p_start_date_active IN DATE := FND_API.G_MISS_DATE,

1686: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1687: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
1688: p_object_version_number IN NUMBER,
1689: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1690: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
1691: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
1692: p_section_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1693: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1694: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,

Line 1691: p_end_date_active IN DATE := FND_API.G_MISS_DATE,

1687: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
1688: p_object_version_number IN NUMBER,
1689: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1690: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
1691: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
1692: p_section_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1693: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1694: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
1695: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,

Line 1692: p_section_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

1688: p_object_version_number IN NUMBER,
1689: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1690: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
1691: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
1692: p_section_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1693: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1694: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
1695: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
1696: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1693: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

1689: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1690: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
1691: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
1692: p_section_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1693: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1694: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
1695: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
1696: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1697: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1694: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,

1690: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
1691: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
1692: p_section_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1693: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1694: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
1695: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
1696: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1697: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
1698: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1695: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,

1691: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
1692: p_section_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1693: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1694: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
1695: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
1696: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1697: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
1698: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
1699: p_display_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1696: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

1692: p_section_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1693: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1694: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
1695: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
1696: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1697: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
1698: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
1699: p_display_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1700: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1697: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,

1693: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1694: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
1695: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
1696: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1697: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
1698: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
1699: p_display_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1700: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1701: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1698: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,

1694: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
1695: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
1696: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1697: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
1698: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
1699: p_display_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1700: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1701: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1702: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1699: p_display_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

1695: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
1696: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1697: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
1698: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
1699: p_display_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1700: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1701: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1702: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
1703: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1700: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

1696: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1697: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
1698: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
1699: p_display_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1700: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1701: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1702: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
1703: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
1704: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1701: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

1697: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
1698: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
1699: p_display_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1700: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1701: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1702: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
1703: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
1704: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1705: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1702: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,

1698: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
1699: p_display_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1700: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1701: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1702: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
1703: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
1704: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1705: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1706: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1703: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

1699: p_display_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1700: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1701: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1702: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
1703: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
1704: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1705: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1706: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1707: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1704: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1700: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1701: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1702: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
1703: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
1704: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1705: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1706: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1707: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1708: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1705: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1701: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1702: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
1703: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
1704: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1705: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1706: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1707: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1708: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1709: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1706: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1702: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
1703: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
1704: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1705: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1706: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1707: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1708: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1709: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1710: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1707: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1703: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
1704: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1705: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1706: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1707: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1708: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1709: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1710: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1711: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1708: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1704: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1705: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1706: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1707: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1708: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1709: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1710: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1711: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1712: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1709: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1705: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1706: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1707: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1708: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1709: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1710: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1711: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1712: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1713: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1710: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1706: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1707: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1708: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1709: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1710: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1711: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1712: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1713: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1714: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1711: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1707: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1708: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1709: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1710: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1711: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1712: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1713: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1714: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1715: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1712: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1708: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1709: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1710: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1711: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1712: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1713: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1714: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1715: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1716: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1713: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1709: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1710: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1711: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1712: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1713: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1714: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1715: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1716: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1717: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1714: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1710: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1711: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1712: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1713: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1714: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1715: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1716: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1717: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1718: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1715: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1711: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1712: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1713: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1714: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1715: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1716: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1717: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1718: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1719: x_return_status OUT NOCOPY VARCHAR2,

Line 1716: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1712: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1713: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1714: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1715: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1716: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1717: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1718: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1719: x_return_status OUT NOCOPY VARCHAR2,
1720: x_msg_count OUT NOCOPY NUMBER,

Line 1717: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1713: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1714: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1715: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1716: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1717: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1718: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1719: x_return_status OUT NOCOPY VARCHAR2,
1720: x_msg_count OUT NOCOPY NUMBER,
1721: x_msg_data OUT NOCOPY VARCHAR2

Line 1718: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

1714: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1715: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1716: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1717: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1718: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1719: x_return_status OUT NOCOPY VARCHAR2,
1720: x_msg_count OUT NOCOPY NUMBER,
1721: x_msg_data OUT NOCOPY VARCHAR2
1722: )

Line 1738: IF NOT FND_API.Compatible_API_Call(l_api_version,

1734: -- Standard Start of API savepoint
1735: SAVEPOINT UPDATE_SECTION_GRP;
1736:
1737: -- Standard call to check for call compatibility.
1738: IF NOT FND_API.Compatible_API_Call(l_api_version,
1739: p_api_version,
1740: l_api_name,
1741: G_PKG_NAME)
1742: THEN

Line 1743: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1739: p_api_version,
1740: l_api_name,
1741: G_PKG_NAME)
1742: THEN
1743: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1744: END IF;
1745:
1746: -- Initialize message list if p_init_msg_list is set to TRUE.
1747: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1747: IF FND_API.to_Boolean(p_init_msg_list) THEN

1743: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1744: END IF;
1745:
1746: -- Initialize message list if p_init_msg_list is set to TRUE.
1747: IF FND_API.to_Boolean(p_init_msg_list) THEN
1748: FND_MSG_PUB.initialize;
1749: END IF;
1750:
1751: -- Initialize API return status to success

Line 1752: x_return_status := FND_API.G_RET_STS_SUCCESS;

1748: FND_MSG_PUB.initialize;
1749: END IF;
1750:
1751: -- Initialize API return status to success
1752: x_return_status := FND_API.G_RET_STS_SUCCESS;
1753:
1754: -- API body
1755: -- CALL FLOW :
1756: -- 1. Check if either section_id or access_name is specified

Line 1761: (p_section_id <> FND_API.G_MISS_NUM))

1757: -- 2. Update row with section data into section table
1758:
1759: -- 1. Check if either section_id or access_name is specified
1760: IF ((p_section_id IS NOT NULL) AND
1761: (p_section_id <> FND_API.G_MISS_NUM))
1762: THEN
1763: l_section_id := p_section_id; -- section_id specified, continue
1764: ELSIF ((p_access_name IS NOT NULL) AND
1765: (p_access_name <> FND_API.G_MISS_CHAR))

Line 1765: (p_access_name <> FND_API.G_MISS_CHAR))

1761: (p_section_id <> FND_API.G_MISS_NUM))
1762: THEN
1763: l_section_id := p_section_id; -- section_id specified, continue
1764: ELSIF ((p_access_name IS NOT NULL) AND
1765: (p_access_name <> FND_API.G_MISS_CHAR))
1766: THEN
1767: -- If access_name specified and section_id is not specified, then
1768: -- query for section id
1769: BEGIN

Line 1777: RAISE FND_API.G_EXC_ERROR;

1773: WHEN NO_DATA_FOUND THEN
1774: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_SCT_ACSS_NAME');
1775: FND_MESSAGE.Set_Token('ACCESS_NAME', p_access_name);
1776: FND_MSG_PUB.Add;
1777: RAISE FND_API.G_EXC_ERROR;
1778: WHEN OTHERS THEN
1779: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1780: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1781: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

Line 1788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1784:
1785: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_GET_SCT_ACSS_NAME');
1786: FND_MESSAGE.Set_Token('ACCESS_NAME', p_access_name);
1787: FND_MSG_PUB.Add;
1788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1789: END;
1790: ELSE
1791: -- neither section_id nor access_name is specified
1792: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_ID_OR_ACSS');

Line 1794: RAISE FND_API.G_EXC_ERROR;

1790: ELSE
1791: -- neither section_id nor access_name is specified
1792: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_ID_OR_ACSS');
1793: FND_MSG_PUB.Add;
1794: RAISE FND_API.G_EXC_ERROR;
1795: END IF;
1796:
1797:
1798: --

Line 1803: p_init_msg_list => FND_API.G_FALSE,

1799: -- 1. Validate the input data
1800: --
1801: Validate_Update
1802: (
1803: p_init_msg_list => FND_API.G_FALSE,
1804: p_validation_level => p_validation_level,
1805: p_section_id => l_section_id,
1806: p_object_version_number => p_object_version_number,
1807: p_access_name => p_access_name,

Line 1842: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1838: x_msg_count => l_msg_count,
1839: x_msg_data => l_msg_data
1840: );
1841:
1842: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1844: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1845: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_INVALID_CREATE');
1846: FND_MSG_PUB.Add;

Line 1843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1839: x_msg_data => l_msg_data
1840: );
1841:
1842: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1844: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1845: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_INVALID_CREATE');
1846: FND_MSG_PUB.Add;
1847: RAISE FND_API.G_EXC_ERROR; -- invalid section

Line 1844: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1840: );
1841:
1842: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1844: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1845: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_INVALID_CREATE');
1846: FND_MSG_PUB.Add;
1847: RAISE FND_API.G_EXC_ERROR; -- invalid section
1848: END IF;

Line 1847: RAISE FND_API.G_EXC_ERROR; -- invalid section

1843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1844: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1845: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_INVALID_CREATE');
1846: FND_MSG_PUB.Add;
1847: RAISE FND_API.G_EXC_ERROR; -- invalid section
1848: END IF;
1849:
1850: -- 2. update row with section data into section table
1851: BEGIN

Line 1894: RAISE FND_API.G_EXC_ERROR;

1890: EXCEPTION
1891: WHEN NO_DATA_FOUND THEN
1892: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_UPDATE_FAIL');
1893: FND_MSG_PUB.Add;
1894: RAISE FND_API.G_EXC_ERROR;
1895: WHEN OTHERS THEN
1896: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1897: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1898: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

Line 1904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1900: FND_MSG_PUB.Add;
1901:
1902: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_UPDATE_FAIL');
1903: FND_MSG_PUB.Add;
1904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1905: END;
1906:
1907: --
1908: -- End of main API body.

Line 1911: IF (FND_API.To_Boolean(p_commit)) THEN

1907: --
1908: -- End of main API body.
1909:
1910: -- Standard check of p_commit.
1911: IF (FND_API.To_Boolean(p_commit)) THEN
1912: COMMIT WORK;
1913: END IF;
1914:
1915: -- Standard call to get message count and if count is 1, get message info.

Line 1922: WHEN FND_API.G_EXC_ERROR THEN

1918: p_encoded => 'F');
1919:
1920: EXCEPTION
1921:
1922: WHEN FND_API.G_EXC_ERROR THEN
1923: ROLLBACK TO UPDATE_SECTION_GRP;
1924: x_return_status := FND_API.G_RET_STS_ERROR;
1925: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1926: p_data => x_msg_data,

Line 1924: x_return_status := FND_API.G_RET_STS_ERROR;

1920: EXCEPTION
1921:
1922: WHEN FND_API.G_EXC_ERROR THEN
1923: ROLLBACK TO UPDATE_SECTION_GRP;
1924: x_return_status := FND_API.G_RET_STS_ERROR;
1925: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1926: p_data => x_msg_data,
1927: p_encoded => 'F');
1928:

Line 1929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1925: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1926: p_data => x_msg_data,
1927: p_encoded => 'F');
1928:
1929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1930: ROLLBACK TO UPDATE_SECTION_GRP;
1931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1932: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1933: p_data => x_msg_data,

Line 1931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1927: p_encoded => 'F');
1928:
1929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1930: ROLLBACK TO UPDATE_SECTION_GRP;
1931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1932: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1933: p_data => x_msg_data,
1934: p_encoded => 'F');
1935:

Line 1945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1941: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1942: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1943: FND_MSG_PUB.Add;
1944:
1945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1946:
1947: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1948: THEN
1949: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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

1957:
1958: PROCEDURE Delete_Section
1959: (
1960: p_api_version IN NUMBER,
1961: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1962: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1963: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1964: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
1965: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1962: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1958: PROCEDURE Delete_Section
1959: (
1960: p_api_version IN NUMBER,
1961: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1962: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1963: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1964: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
1965: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1966: x_return_status OUT NOCOPY VARCHAR2,

Line 1963: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1959: (
1960: p_api_version IN NUMBER,
1961: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1962: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1963: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1964: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
1965: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1966: x_return_status OUT NOCOPY VARCHAR2,
1967: x_msg_count OUT NOCOPY NUMBER,

Line 1964: p_section_id IN NUMBER := FND_API.G_MISS_NUM,

1960: p_api_version IN NUMBER,
1961: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1962: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1963: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1964: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
1965: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1966: x_return_status OUT NOCOPY VARCHAR2,
1967: x_msg_count OUT NOCOPY NUMBER,
1968: x_msg_data OUT NOCOPY VARCHAR2

Line 1965: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

1961: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1962: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1963: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1964: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
1965: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1966: x_return_status OUT NOCOPY VARCHAR2,
1967: x_msg_count OUT NOCOPY NUMBER,
1968: x_msg_data OUT NOCOPY VARCHAR2
1969: )

Line 1994: IF NOT FND_API.Compatible_API_Call(l_api_version,

1990: -- Standard Start of API savepoint
1991: SAVEPOINT DELETE_SECTION_GRP;
1992:
1993: -- Standard call to check for call compatibility.
1994: IF NOT FND_API.Compatible_API_Call(l_api_version,
1995: p_api_version,
1996: l_api_name,
1997: G_PKG_NAME)
1998: THEN

Line 1999: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1995: p_api_version,
1996: l_api_name,
1997: G_PKG_NAME)
1998: THEN
1999: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2000: END IF;
2001:
2002: -- Initialize message list if p_init_msg_list is set to TRUE.
2003: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 2003: IF FND_API.to_Boolean(p_init_msg_list) THEN

1999: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2000: END IF;
2001:
2002: -- Initialize message list if p_init_msg_list is set to TRUE.
2003: IF FND_API.to_Boolean(p_init_msg_list) THEN
2004: FND_MSG_PUB.initialize;
2005: END IF;
2006:
2007: -- Initialize API return status to success

Line 2008: x_return_status := FND_API.G_RET_STS_SUCCESS;

2004: FND_MSG_PUB.initialize;
2005: END IF;
2006:
2007: -- Initialize API return status to success
2008: x_return_status := FND_API.G_RET_STS_SUCCESS;
2009:
2010: -- CALL FLOW
2011: -- 1. If section_id specified, delete all references for section id
2012: -- 2. If access_name specified and section_id is not specified, then

Line 2017: (p_section_id <> FND_API.G_MISS_NUM))

2013: -- query for section id and delete all references
2014:
2015: -- 1. If section_id specified, delete all references for section id
2016: IF ((p_section_id IS NOT NULL) AND
2017: (p_section_id <> FND_API.G_MISS_NUM))
2018: THEN
2019: l_section_id := p_section_id; -- section_id specified, continue
2020: ELSIF ((p_access_name IS NOT NULL) AND
2021: (p_access_name <> FND_API.G_MISS_CHAR))

Line 2021: (p_access_name <> FND_API.G_MISS_CHAR))

2017: (p_section_id <> FND_API.G_MISS_NUM))
2018: THEN
2019: l_section_id := p_section_id; -- section_id specified, continue
2020: ELSIF ((p_access_name IS NOT NULL) AND
2021: (p_access_name <> FND_API.G_MISS_CHAR))
2022: THEN
2023: -- 2. If access_name specified and section_id is not specified, then
2024: -- query for section id and delete all references
2025: BEGIN

Line 2033: RAISE FND_API.G_EXC_ERROR;

2029: WHEN NO_DATA_FOUND THEN
2030: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_SCT_ACSS_NAME');
2031: FND_MESSAGE.Set_Token('ACCESS_NAME', p_access_name);
2032: FND_MSG_PUB.Add;
2033: RAISE FND_API.G_EXC_ERROR;
2034: WHEN OTHERS THEN
2035: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2036: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
2037: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

Line 2044: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2040:
2041: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_SCT_ACSS_NAME');
2042: FND_MESSAGE.Set_Token('ACCESS_NAME', p_access_name);
2043: FND_MSG_PUB.Add;
2044: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2045: END;
2046: ELSE
2047: -- neither section_id nor access_name is specified, therefore cannot delete
2048: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_ID_OR_ACSS');

Line 2050: RAISE FND_API.G_EXC_ERROR;

2046: ELSE
2047: -- neither section_id nor access_name is specified, therefore cannot delete
2048: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_ID_OR_ACSS');
2049: FND_MSG_PUB.Add;
2050: RAISE FND_API.G_EXC_ERROR;
2051: END IF;
2052:
2053: --
2054: -- Delete references from other tables

Line 2066: RAISE FND_API.G_EXC_ERROR;

2062: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_MSITE_REF');
2063: FND_MESSAGE.Set_Token('SECTION_ID', l_section_id);
2064: FND_MESSAGE.Set_Token('MINI_SITE_ID', l_mini_site_id);
2065: FND_MSG_PUB.Add;
2066: RAISE FND_API.G_EXC_ERROR;
2067: END IF;
2068:
2069: -- delete from ibe_dsp_msite_sct_sects table
2070: FOR r1 in c1(l_section_id) LOOP

Line 2075: p_init_msg_list => FND_API.G_FALSE,

2071:
2072: IBE_DSP_MSITE_SCT_SECT_PVT.Delete_MSite_Section_Section
2073: (
2074: p_api_version => p_api_version,
2075: p_init_msg_list => FND_API.G_FALSE,
2076: p_commit => FND_API.G_FALSE,
2077: p_validation_level => p_validation_level,
2078: p_mini_site_section_section_id => r1.mini_site_section_section_id,
2079: p_mini_site_id => FND_API.G_MISS_NUM,

Line 2076: p_commit => FND_API.G_FALSE,

2072: IBE_DSP_MSITE_SCT_SECT_PVT.Delete_MSite_Section_Section
2073: (
2074: p_api_version => p_api_version,
2075: p_init_msg_list => FND_API.G_FALSE,
2076: p_commit => FND_API.G_FALSE,
2077: p_validation_level => p_validation_level,
2078: p_mini_site_section_section_id => r1.mini_site_section_section_id,
2079: p_mini_site_id => FND_API.G_MISS_NUM,
2080: p_parent_section_id => FND_API.G_MISS_NUM,

Line 2079: p_mini_site_id => FND_API.G_MISS_NUM,

2075: p_init_msg_list => FND_API.G_FALSE,
2076: p_commit => FND_API.G_FALSE,
2077: p_validation_level => p_validation_level,
2078: p_mini_site_section_section_id => r1.mini_site_section_section_id,
2079: p_mini_site_id => FND_API.G_MISS_NUM,
2080: p_parent_section_id => FND_API.G_MISS_NUM,
2081: p_child_section_id => FND_API.G_MISS_NUM,
2082: x_return_status => x_return_status,
2083: x_msg_count => x_msg_count,

Line 2080: p_parent_section_id => FND_API.G_MISS_NUM,

2076: p_commit => FND_API.G_FALSE,
2077: p_validation_level => p_validation_level,
2078: p_mini_site_section_section_id => r1.mini_site_section_section_id,
2079: p_mini_site_id => FND_API.G_MISS_NUM,
2080: p_parent_section_id => FND_API.G_MISS_NUM,
2081: p_child_section_id => FND_API.G_MISS_NUM,
2082: x_return_status => x_return_status,
2083: x_msg_count => x_msg_count,
2084: x_msg_data => x_msg_data

Line 2081: p_child_section_id => FND_API.G_MISS_NUM,

2077: p_validation_level => p_validation_level,
2078: p_mini_site_section_section_id => r1.mini_site_section_section_id,
2079: p_mini_site_id => FND_API.G_MISS_NUM,
2080: p_parent_section_id => FND_API.G_MISS_NUM,
2081: p_child_section_id => FND_API.G_MISS_NUM,
2082: x_return_status => x_return_status,
2083: x_msg_count => x_msg_count,
2084: x_msg_data => x_msg_data
2085: );

Line 2087: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

2083: x_msg_count => x_msg_count,
2084: x_msg_data => x_msg_data
2085: );
2086:
2087: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2088: RAISE FND_API.G_EXC_ERROR;
2089: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2091: END IF;

Line 2088: RAISE FND_API.G_EXC_ERROR;

2084: x_msg_data => x_msg_data
2085: );
2086:
2087: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2088: RAISE FND_API.G_EXC_ERROR;
2089: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2091: END IF;
2092:

Line 2089: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2085: );
2086:
2087: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2088: RAISE FND_API.G_EXC_ERROR;
2089: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2091: END IF;
2092:
2093: END LOOP;

Line 2090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2086:
2087: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2088: RAISE FND_API.G_EXC_ERROR;
2089: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2091: END IF;
2092:
2093: END LOOP;
2094:

Line 2101: p_init_msg_list => FND_API.G_FALSE,

2097:
2098: IBE_DSP_SECTION_ITEM_PVT.Delete_Section_Item
2099: (
2100: p_api_version => p_api_version,
2101: p_init_msg_list => FND_API.G_FALSE,
2102: p_commit => FND_API.G_FALSE,
2103: p_validation_level => p_validation_level,
2104: p_call_from_trigger => FALSE,
2105: p_section_item_id => r2.section_item_id,

Line 2102: p_commit => FND_API.G_FALSE,

2098: IBE_DSP_SECTION_ITEM_PVT.Delete_Section_Item
2099: (
2100: p_api_version => p_api_version,
2101: p_init_msg_list => FND_API.G_FALSE,
2102: p_commit => FND_API.G_FALSE,
2103: p_validation_level => p_validation_level,
2104: p_call_from_trigger => FALSE,
2105: p_section_item_id => r2.section_item_id,
2106: p_section_id => FND_API.G_MISS_NUM,

Line 2106: p_section_id => FND_API.G_MISS_NUM,

2102: p_commit => FND_API.G_FALSE,
2103: p_validation_level => p_validation_level,
2104: p_call_from_trigger => FALSE,
2105: p_section_item_id => r2.section_item_id,
2106: p_section_id => FND_API.G_MISS_NUM,
2107: p_inventory_item_id => FND_API.G_MISS_NUM,
2108: p_organization_id => FND_API.G_MISS_NUM,
2109: x_return_status => x_return_status,
2110: x_msg_count => x_msg_count,

Line 2107: p_inventory_item_id => FND_API.G_MISS_NUM,

2103: p_validation_level => p_validation_level,
2104: p_call_from_trigger => FALSE,
2105: p_section_item_id => r2.section_item_id,
2106: p_section_id => FND_API.G_MISS_NUM,
2107: p_inventory_item_id => FND_API.G_MISS_NUM,
2108: p_organization_id => FND_API.G_MISS_NUM,
2109: x_return_status => x_return_status,
2110: x_msg_count => x_msg_count,
2111: x_msg_data => x_msg_data

Line 2108: p_organization_id => FND_API.G_MISS_NUM,

2104: p_call_from_trigger => FALSE,
2105: p_section_item_id => r2.section_item_id,
2106: p_section_id => FND_API.G_MISS_NUM,
2107: p_inventory_item_id => FND_API.G_MISS_NUM,
2108: p_organization_id => FND_API.G_MISS_NUM,
2109: x_return_status => x_return_status,
2110: x_msg_count => x_msg_count,
2111: x_msg_data => x_msg_data
2112: );

Line 2114: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

2110: x_msg_count => x_msg_count,
2111: x_msg_data => x_msg_data
2112: );
2113:
2114: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2115: RAISE FND_API.G_EXC_ERROR;
2116: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2118: END IF;

Line 2115: RAISE FND_API.G_EXC_ERROR;

2111: x_msg_data => x_msg_data
2112: );
2113:
2114: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2115: RAISE FND_API.G_EXC_ERROR;
2116: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2118: END IF;
2119:

Line 2116: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2112: );
2113:
2114: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2115: RAISE FND_API.G_EXC_ERROR;
2116: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2118: END IF;
2119:
2120: END LOOP;

Line 2117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2113:
2114: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2115: RAISE FND_API.G_EXC_ERROR;
2116: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2118: END IF;
2119:
2120: END LOOP;
2121:

Line 2136: WHEN FND_API.G_EXC_ERROR THEN

2132: delete_row(l_section_id);
2133:
2134: EXCEPTION
2135:
2136: WHEN FND_API.G_EXC_ERROR THEN
2137: ROLLBACK TO DELETE_SECTION_GRP;
2138: x_return_status := FND_API.G_RET_STS_ERROR;
2139: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2140: p_data => x_msg_data,

Line 2138: x_return_status := FND_API.G_RET_STS_ERROR;

2134: EXCEPTION
2135:
2136: WHEN FND_API.G_EXC_ERROR THEN
2137: ROLLBACK TO DELETE_SECTION_GRP;
2138: x_return_status := FND_API.G_RET_STS_ERROR;
2139: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2140: p_data => x_msg_data,
2141: p_encoded => 'F');
2142:

Line 2143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2139: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2140: p_data => x_msg_data,
2141: p_encoded => 'F');
2142:
2143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2144: ROLLBACK TO DELETE_SECTION_GRP;
2145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2146: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2147: p_data => x_msg_data,

Line 2145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2141: p_encoded => 'F');
2142:
2143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2144: ROLLBACK TO DELETE_SECTION_GRP;
2145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2146: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2147: p_data => x_msg_data,
2148: p_encoded => 'F');
2149:

Line 2159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2155: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2156: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2157: FND_MSG_PUB.Add;
2158:
2159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2160:
2161: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
2162: THEN
2163: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

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

2171:
2172: PROCEDURE Update_Dsp_Context_To_Null
2173: (
2174: p_api_version IN NUMBER,
2175: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2176: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2177: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2178: p_display_context_id IN NUMBER,
2179: x_return_status OUT NOCOPY VARCHAR2,

Line 2176: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2172: PROCEDURE Update_Dsp_Context_To_Null
2173: (
2174: p_api_version IN NUMBER,
2175: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2176: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2177: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2178: p_display_context_id IN NUMBER,
2179: x_return_status OUT NOCOPY VARCHAR2,
2180: x_msg_count OUT NOCOPY NUMBER,

Line 2177: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2173: (
2174: p_api_version IN NUMBER,
2175: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2176: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2177: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2178: p_display_context_id IN NUMBER,
2179: x_return_status OUT NOCOPY VARCHAR2,
2180: x_msg_count OUT NOCOPY NUMBER,
2181: x_msg_data OUT NOCOPY VARCHAR2

Line 2195: IF NOT FND_API.Compatible_API_Call(l_api_version,

2191: -- Standard Start of API savepoint
2192: SAVEPOINT UPDATE_DSP_CONTEXT_TO_NULL_GRP;
2193:
2194: -- Standard call to check for call compatibility.
2195: IF NOT FND_API.Compatible_API_Call(l_api_version,
2196: p_api_version,
2197: l_api_name,
2198: G_PKG_NAME)
2199: THEN

Line 2200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2196: p_api_version,
2197: l_api_name,
2198: G_PKG_NAME)
2199: THEN
2200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2201: END IF;
2202:
2203: -- Initialize message list if p_init_msg_list is set to TRUE.
2204: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 2204: IF FND_API.to_Boolean(p_init_msg_list) THEN

2200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2201: END IF;
2202:
2203: -- Initialize message list if p_init_msg_list is set to TRUE.
2204: IF FND_API.to_Boolean(p_init_msg_list) THEN
2205: FND_MSG_PUB.initialize;
2206: END IF;
2207:
2208: -- Initialize API return status to success

Line 2209: x_return_status := FND_API.G_RET_STS_SUCCESS;

2205: FND_MSG_PUB.initialize;
2206: END IF;
2207:
2208: -- Initialize API return status to success
2209: x_return_status := FND_API.G_RET_STS_SUCCESS;
2210:
2211: -- API body
2212: -- CALL FLOW :
2213: -- 1. Update all rows with display_context_id set to null and

Line 2226: IF (FND_API.To_Boolean(p_commit)) THEN

2222: --
2223: -- End of main API body.
2224:
2225: -- Standard check of p_commit.
2226: IF (FND_API.To_Boolean(p_commit)) THEN
2227: COMMIT WORK;
2228: END IF;
2229:
2230: -- Standard call to get message count and if count is 1, get message info.

Line 2237: WHEN FND_API.G_EXC_ERROR THEN

2233: p_encoded => 'F');
2234:
2235: EXCEPTION
2236:
2237: WHEN FND_API.G_EXC_ERROR THEN
2238: ROLLBACK TO UPDATE_DSP_CONTEXT_TO_NULL_GRP;
2239: x_return_status := FND_API.G_RET_STS_ERROR;
2240: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2241: p_data => x_msg_data,

Line 2239: x_return_status := FND_API.G_RET_STS_ERROR;

2235: EXCEPTION
2236:
2237: WHEN FND_API.G_EXC_ERROR THEN
2238: ROLLBACK TO UPDATE_DSP_CONTEXT_TO_NULL_GRP;
2239: x_return_status := FND_API.G_RET_STS_ERROR;
2240: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2241: p_data => x_msg_data,
2242: p_encoded => 'F');
2243:

Line 2244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2240: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2241: p_data => x_msg_data,
2242: p_encoded => 'F');
2243:
2244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2245: ROLLBACK TO UPDATE_DSP_CONTEXT_TO_NULL_GRP;
2246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2247: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2248: p_data => x_msg_data,

Line 2246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2242: p_encoded => 'F');
2243:
2244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2245: ROLLBACK TO UPDATE_DSP_CONTEXT_TO_NULL_GRP;
2246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2247: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2248: p_data => x_msg_data,
2249: p_encoded => 'F');
2250:

Line 2260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2256: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2257: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2258: FND_MSG_PUB.Add;
2259:
2260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2261:
2262: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2263: THEN
2264: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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

2272:
2273: PROCEDURE Update_Deliverable_To_Null
2274: (
2275: p_api_version IN NUMBER,
2276: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2277: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2278: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2279: p_deliverable_id IN NUMBER,
2280: x_return_status OUT NOCOPY VARCHAR2,

Line 2277: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2273: PROCEDURE Update_Deliverable_To_Null
2274: (
2275: p_api_version IN NUMBER,
2276: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2277: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2278: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2279: p_deliverable_id IN NUMBER,
2280: x_return_status OUT NOCOPY VARCHAR2,
2281: x_msg_count OUT NOCOPY NUMBER,

Line 2278: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2274: (
2275: p_api_version IN NUMBER,
2276: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2277: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2278: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2279: p_deliverable_id IN NUMBER,
2280: x_return_status OUT NOCOPY VARCHAR2,
2281: x_msg_count OUT NOCOPY NUMBER,
2282: x_msg_data OUT NOCOPY VARCHAR2

Line 2296: IF NOT FND_API.Compatible_API_Call(l_api_version,

2292: -- Standard Start of API savepoint
2293: SAVEPOINT UPDATE_DELIVERABLE_TO_NULL_GRP;
2294:
2295: -- Standard call to check for call compatibility.
2296: IF NOT FND_API.Compatible_API_Call(l_api_version,
2297: p_api_version,
2298: l_api_name,
2299: G_PKG_NAME)
2300: THEN

Line 2301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2297: p_api_version,
2298: l_api_name,
2299: G_PKG_NAME)
2300: THEN
2301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2302: END IF;
2303:
2304: -- Initialize message list if p_init_msg_list is set to TRUE.
2305: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 2305: IF FND_API.to_Boolean(p_init_msg_list) THEN

2301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2302: END IF;
2303:
2304: -- Initialize message list if p_init_msg_list is set to TRUE.
2305: IF FND_API.to_Boolean(p_init_msg_list) THEN
2306: FND_MSG_PUB.initialize;
2307: END IF;
2308:
2309: -- Initialize API return status to success

Line 2310: x_return_status := FND_API.G_RET_STS_SUCCESS;

2306: FND_MSG_PUB.initialize;
2307: END IF;
2308:
2309: -- Initialize API return status to success
2310: x_return_status := FND_API.G_RET_STS_SUCCESS;
2311:
2312: -- API body
2313: -- CALL FLOW :
2314: -- 1. Update all rows with deliverable_id set to null and

Line 2327: IF (FND_API.To_Boolean(p_commit)) THEN

2323: --
2324: -- End of main API body.
2325:
2326: -- Standard check of p_commit.
2327: IF (FND_API.To_Boolean(p_commit)) THEN
2328: COMMIT WORK;
2329: END IF;
2330:
2331: -- Standard call to get message count and if count is 1, get message info.

Line 2338: WHEN FND_API.G_EXC_ERROR THEN

2334: p_encoded => 'F');
2335:
2336: EXCEPTION
2337:
2338: WHEN FND_API.G_EXC_ERROR THEN
2339: ROLLBACK TO UPDATE_DELIVERABLE_TO_NULL_GRP;
2340: x_return_status := FND_API.G_RET_STS_ERROR;
2341: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2342: p_data => x_msg_data,

Line 2340: x_return_status := FND_API.G_RET_STS_ERROR;

2336: EXCEPTION
2337:
2338: WHEN FND_API.G_EXC_ERROR THEN
2339: ROLLBACK TO UPDATE_DELIVERABLE_TO_NULL_GRP;
2340: x_return_status := FND_API.G_RET_STS_ERROR;
2341: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2342: p_data => x_msg_data,
2343: p_encoded => 'F');
2344:

Line 2345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2341: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2342: p_data => x_msg_data,
2343: p_encoded => 'F');
2344:
2345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2346: ROLLBACK TO UPDATE_DELIVERABLE_TO_NULL_GRP;
2347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2348: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2349: p_data => x_msg_data,

Line 2347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2343: p_encoded => 'F');
2344:
2345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2346: ROLLBACK TO UPDATE_DELIVERABLE_TO_NULL_GRP;
2347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2348: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2349: p_data => x_msg_data,
2350: p_encoded => 'F');
2351:

Line 2361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2357: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2358: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2359: FND_MSG_PUB.Add;
2360:
2361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2362:
2363: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2364: THEN
2365: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

Line 2511: P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM,

2507: P_DESCRIPTION IN VARCHAR2,
2508: P_LONG_DESCRIPTION IN VARCHAR2,
2509: P_KEYWORDS IN VARCHAR2,
2510: P_OWNER IN VARCHAR2,
2511: P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
2512: P_ACCESS_NAME IN VARCHAR2,
2513: P_START_DATE_ACTIVE IN VARCHAR2,--IN DATE,
2514: P_END_DATE_ACTIVE IN VARCHAR2,-- IN DATE,
2515: P_SECTION_TYPE_CODE IN VARCHAR2,