55: -- Initialize API return status to success
56:
57: p_return_status := FND_API.G_RET_STS_SUCCESS;
58:
59: l_return_stat := FND_PROFILE.SAVE(X_NAME =>'ICX_DAYS_NEEDED_BY',
60: X_VALUE => p_days_needed_by,
61: X_LEVEL_NAME =>'USER',
62: X_LEVEL_VALUE => p_user_id);
63:
67: fnd_msg_pub.Add;
68: raise FND_API.G_EXC_ERROR;
69: end if;
70:
71: l_return_stat := FND_PROFILE.SAVE(X_NAME =>'ICX_REQ_DEFAULT_TEMPLATE',
72: X_VALUE => p_req_default_template,
73: X_LEVEL_NAME =>'USER',
74: X_LEVEL_VALUE => p_user_id);
75:
79: fnd_msg_pub.Add;
80: raise FND_API.G_EXC_ERROR;
81: end if;
82:
83: l_return_stat := FND_PROFILE.SAVE(X_NAME =>'ICX_REQ_OVERRIDE_REQUESTOR_CODE',
84: X_VALUE => p_req_override_req_code,
85: X_LEVEL_NAME =>'USER',
86: X_LEVEL_VALUE => p_user_id);
87:
91: fnd_msg_pub.Add;
92: raise FND_API.G_EXC_ERROR;
93: end if;
94:
95: l_return_stat := FND_PROFILE.SAVE(X_NAME =>'ICX_REQ_OVERRIDE_LOCATION_FLAG',
96: X_VALUE => p_req_override_loc_flag,
97: X_LEVEL_NAME =>'USER',
98: X_LEVEL_VALUE => p_user_id);
99:
229: -- DAYS_NEEDED_BY
230: -- ************
231: if p_days_needed_by <> FND_API.G_MISS_NUM
232: then
233: l_return_stat := FND_PROFILE.SAVE(X_NAME =>'ICX_DAYS_NEEDED_BY',
234: X_VALUE => p_days_needed_by,
235: X_LEVEL_NAME =>'USER',
236: X_LEVEL_VALUE => p_user_id);
237:
246: -- REQ_DEFAULT_TEMPLATE
247: -- ************
248: if p_req_default_template <> FND_API.G_MISS_CHAR
249: then
250: l_return_stat := FND_PROFILE.SAVE(X_NAME =>'ICX_REQ_DEFAULT_TEMPLATE',
251: X_VALUE => p_req_default_template,
252: X_LEVEL_NAME =>'USER',
253: X_LEVEL_VALUE => p_user_id);
254:
263: -- REQ_OVERRIDE_LOC_FLAG
264: -- ************
265: if p_req_override_loc_flag <> FND_API.G_MISS_CHAR
266: then
267: l_return_stat := FND_PROFILE.SAVE(X_NAME =>'ICX_REQ_OVERRIDE_LOCATION_FLAG',
268: X_VALUE => p_req_override_loc_flag,
269: X_LEVEL_NAME =>'USER',
270: X_LEVEL_VALUE => p_user_id);
271:
280: -- REQ_OVERRIDE_REQ_CODE
281: -- ************
282: if p_req_override_req_code <> FND_API.G_MISS_CHAR
283: then
284: l_return_stat := FND_PROFILE.SAVE(X_NAME =>'ICX_REQ_OVERRIDE_REQUESTOR_CODE',
285: X_VALUE => p_req_override_req_code,
286: X_LEVEL_NAME =>'USER',
287: X_LEVEL_VALUE => p_user_id);
288:
414:
415: p_return_status := FND_API.G_RET_STS_SUCCESS;
416:
417:
418: l_return_stat := FND_PROFILE.SAVE(X_NAME =>'ICX_DAYS_NEEDED_BY',
419: X_VALUE => '',
420: X_LEVEL_NAME =>'USER',
421: X_LEVEL_VALUE => p_user_id);
422:
426: fnd_msg_pub.Add;
427: raise FND_API.G_EXC_ERROR;
428: end if;
429:
430: l_return_stat := FND_PROFILE.SAVE(X_NAME =>'ICX_REQ_DEFAULT_TEMPLATE',
431: X_VALUE => '',
432: X_LEVEL_NAME =>'USER',
433: X_LEVEL_VALUE => p_user_id);
434:
438: fnd_msg_pub.Add;
439: raise FND_API.G_EXC_ERROR;
440: end if;
441:
442: l_return_stat := FND_PROFILE.SAVE(X_NAME =>'ICX_REQ_OVERRIDE_REQUESTOR_CODE',
443: X_VALUE => '',
444: X_LEVEL_NAME =>'USER',
445: X_LEVEL_VALUE => p_user_id);
446:
450: fnd_msg_pub.Add;
451: raise FND_API.G_EXC_ERROR;
452: end if;
453:
454: l_return_stat := FND_PROFILE.SAVE(X_NAME =>'ICX_REQ_OVERRIDE_LOCATION_FLAG',
455: X_VALUE => '',
456: X_LEVEL_NAME =>'USER',
457: X_LEVEL_VALUE => p_user_id);
458: