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

Line 83: decode( p_PROFILE_ID, FND_API.G_MISS_NUM, NULL, p_PROFILE_ID),

79: LAST_UPDATED_BY,
80: LAST_UPDATE_LOGIN
81: ) VALUES (
82: x_PERZ_DDF_ID,
83: decode( p_PROFILE_ID, FND_API.G_MISS_NUM, NULL, p_PROFILE_ID),
84: decode( p_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_APPLICATION_ID),
85: decode( p_PERZ_DDF_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_PERZ_DDF_CONTEXT),
86: decode( p_GUI_OBJECT_NAME, FND_API.G_MISS_CHAR, NULL, p_GUI_OBJECT_NAME),
87: decode( p_GUI_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_GUI_OBJECT_ID),

Line 84: decode( p_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_APPLICATION_ID),

80: LAST_UPDATE_LOGIN
81: ) VALUES (
82: x_PERZ_DDF_ID,
83: decode( p_PROFILE_ID, FND_API.G_MISS_NUM, NULL, p_PROFILE_ID),
84: decode( p_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_APPLICATION_ID),
85: decode( p_PERZ_DDF_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_PERZ_DDF_CONTEXT),
86: decode( p_GUI_OBJECT_NAME, FND_API.G_MISS_CHAR, NULL, p_GUI_OBJECT_NAME),
87: decode( p_GUI_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_GUI_OBJECT_ID),
88: decode( p_DDF_VALUE, FND_API.G_MISS_CHAR, NULL, p_DDF_VALUE),

Line 85: decode( p_PERZ_DDF_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_PERZ_DDF_CONTEXT),

81: ) VALUES (
82: x_PERZ_DDF_ID,
83: decode( p_PROFILE_ID, FND_API.G_MISS_NUM, NULL, p_PROFILE_ID),
84: decode( p_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_APPLICATION_ID),
85: decode( p_PERZ_DDF_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_PERZ_DDF_CONTEXT),
86: decode( p_GUI_OBJECT_NAME, FND_API.G_MISS_CHAR, NULL, p_GUI_OBJECT_NAME),
87: decode( p_GUI_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_GUI_OBJECT_ID),
88: decode( p_DDF_VALUE, FND_API.G_MISS_CHAR, NULL, p_DDF_VALUE),
89: decode( p_DDF_VALUE_TYPE, FND_API.G_MISS_CHAR, NULL, p_DDF_VALUE_TYPE),

Line 86: decode( p_GUI_OBJECT_NAME, FND_API.G_MISS_CHAR, NULL, p_GUI_OBJECT_NAME),

82: x_PERZ_DDF_ID,
83: decode( p_PROFILE_ID, FND_API.G_MISS_NUM, NULL, p_PROFILE_ID),
84: decode( p_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_APPLICATION_ID),
85: decode( p_PERZ_DDF_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_PERZ_DDF_CONTEXT),
86: decode( p_GUI_OBJECT_NAME, FND_API.G_MISS_CHAR, NULL, p_GUI_OBJECT_NAME),
87: decode( p_GUI_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_GUI_OBJECT_ID),
88: decode( p_DDF_VALUE, FND_API.G_MISS_CHAR, NULL, p_DDF_VALUE),
89: decode( p_DDF_VALUE_TYPE, FND_API.G_MISS_CHAR, NULL, p_DDF_VALUE_TYPE),
90: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, 1, p_OBJECT_VERSION_NUMBER),

Line 87: decode( p_GUI_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_GUI_OBJECT_ID),

83: decode( p_PROFILE_ID, FND_API.G_MISS_NUM, NULL, p_PROFILE_ID),
84: decode( p_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_APPLICATION_ID),
85: decode( p_PERZ_DDF_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_PERZ_DDF_CONTEXT),
86: decode( p_GUI_OBJECT_NAME, FND_API.G_MISS_CHAR, NULL, p_GUI_OBJECT_NAME),
87: decode( p_GUI_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_GUI_OBJECT_ID),
88: decode( p_DDF_VALUE, FND_API.G_MISS_CHAR, NULL, p_DDF_VALUE),
89: decode( p_DDF_VALUE_TYPE, FND_API.G_MISS_CHAR, NULL, p_DDF_VALUE_TYPE),
90: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, 1, p_OBJECT_VERSION_NUMBER),
91: FND_GLOBAL.USER_ID, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID

Line 88: decode( p_DDF_VALUE, FND_API.G_MISS_CHAR, NULL, p_DDF_VALUE),

84: decode( p_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_APPLICATION_ID),
85: decode( p_PERZ_DDF_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_PERZ_DDF_CONTEXT),
86: decode( p_GUI_OBJECT_NAME, FND_API.G_MISS_CHAR, NULL, p_GUI_OBJECT_NAME),
87: decode( p_GUI_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_GUI_OBJECT_ID),
88: decode( p_DDF_VALUE, FND_API.G_MISS_CHAR, NULL, p_DDF_VALUE),
89: decode( p_DDF_VALUE_TYPE, FND_API.G_MISS_CHAR, NULL, p_DDF_VALUE_TYPE),
90: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, 1, p_OBJECT_VERSION_NUMBER),
91: FND_GLOBAL.USER_ID, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID
92: );

Line 89: decode( p_DDF_VALUE_TYPE, FND_API.G_MISS_CHAR, NULL, p_DDF_VALUE_TYPE),

85: decode( p_PERZ_DDF_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_PERZ_DDF_CONTEXT),
86: decode( p_GUI_OBJECT_NAME, FND_API.G_MISS_CHAR, NULL, p_GUI_OBJECT_NAME),
87: decode( p_GUI_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_GUI_OBJECT_ID),
88: decode( p_DDF_VALUE, FND_API.G_MISS_CHAR, NULL, p_DDF_VALUE),
89: decode( p_DDF_VALUE_TYPE, FND_API.G_MISS_CHAR, NULL, p_DDF_VALUE_TYPE),
90: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, 1, p_OBJECT_VERSION_NUMBER),
91: FND_GLOBAL.USER_ID, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID
92: );
93: End insert_jtf_perz_data_default;

Line 90: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, 1, p_OBJECT_VERSION_NUMBER),

86: decode( p_GUI_OBJECT_NAME, FND_API.G_MISS_CHAR, NULL, p_GUI_OBJECT_NAME),
87: decode( p_GUI_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_GUI_OBJECT_ID),
88: decode( p_DDF_VALUE, FND_API.G_MISS_CHAR, NULL, p_DDF_VALUE),
89: decode( p_DDF_VALUE_TYPE, FND_API.G_MISS_CHAR, NULL, p_DDF_VALUE_TYPE),
90: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, 1, p_OBJECT_VERSION_NUMBER),
91: FND_GLOBAL.USER_ID, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID
92: );
93: End insert_jtf_perz_data_default;
94: -- ****************************************************************************

Line 112: -- PROFILE_ID = decode( p_PROFILE_ID, FND_API.G_MISS_NUM, PROFILE_ID, p_PROFILE_ID),

108: l_object_version_number NUMBER := p_OBJECT_VERSION_NUMBER;
109: BEGIN
110: Update JTF_PERZ_DATA_DEFAULT
111: SET
112: -- PROFILE_ID = decode( p_PROFILE_ID, FND_API.G_MISS_NUM, PROFILE_ID, p_PROFILE_ID),
113: -- APPLICATION_ID = decode( p_APPLICATION_ID, FND_API.G_MISS_NUM, APPLICATION_ID, p_APPLICATION_ID),
114: -- PERZ_DDF_CONTEXT = decode( p_PERZ_DDF_CONTEXT, FND_API.G_MISS_CHAR, PERZ_DDF_CONTEXT, p_PERZ_DDF_CONTEXT),
115: -- GUI_OBJECT_NAME = decode( p_GUI_OBJECT_NAME, FND_API.G_MISS_CHAR, GUI_OBJECT_NAME, p_GUI_OBJECT_NAME),
116: -- GUI_OBJECT_ID = decode( p_GUI_OBJECT_ID, FND_API.G_MISS_NUM, GUI_OBJECT_ID, p_GUI_OBJECT_ID),

Line 113: -- APPLICATION_ID = decode( p_APPLICATION_ID, FND_API.G_MISS_NUM, APPLICATION_ID, p_APPLICATION_ID),

109: BEGIN
110: Update JTF_PERZ_DATA_DEFAULT
111: SET
112: -- PROFILE_ID = decode( p_PROFILE_ID, FND_API.G_MISS_NUM, PROFILE_ID, p_PROFILE_ID),
113: -- APPLICATION_ID = decode( p_APPLICATION_ID, FND_API.G_MISS_NUM, APPLICATION_ID, p_APPLICATION_ID),
114: -- PERZ_DDF_CONTEXT = decode( p_PERZ_DDF_CONTEXT, FND_API.G_MISS_CHAR, PERZ_DDF_CONTEXT, p_PERZ_DDF_CONTEXT),
115: -- GUI_OBJECT_NAME = decode( p_GUI_OBJECT_NAME, FND_API.G_MISS_CHAR, GUI_OBJECT_NAME, p_GUI_OBJECT_NAME),
116: -- GUI_OBJECT_ID = decode( p_GUI_OBJECT_ID, FND_API.G_MISS_NUM, GUI_OBJECT_ID, p_GUI_OBJECT_ID),
117: PERZ_DDF_VALUE = decode( p_DDF_VALUE, FND_API.G_MISS_CHAR, PERZ_DDF_VALUE, p_DDF_VALUE),

Line 114: -- PERZ_DDF_CONTEXT = decode( p_PERZ_DDF_CONTEXT, FND_API.G_MISS_CHAR, PERZ_DDF_CONTEXT, p_PERZ_DDF_CONTEXT),

110: Update JTF_PERZ_DATA_DEFAULT
111: SET
112: -- PROFILE_ID = decode( p_PROFILE_ID, FND_API.G_MISS_NUM, PROFILE_ID, p_PROFILE_ID),
113: -- APPLICATION_ID = decode( p_APPLICATION_ID, FND_API.G_MISS_NUM, APPLICATION_ID, p_APPLICATION_ID),
114: -- PERZ_DDF_CONTEXT = decode( p_PERZ_DDF_CONTEXT, FND_API.G_MISS_CHAR, PERZ_DDF_CONTEXT, p_PERZ_DDF_CONTEXT),
115: -- GUI_OBJECT_NAME = decode( p_GUI_OBJECT_NAME, FND_API.G_MISS_CHAR, GUI_OBJECT_NAME, p_GUI_OBJECT_NAME),
116: -- GUI_OBJECT_ID = decode( p_GUI_OBJECT_ID, FND_API.G_MISS_NUM, GUI_OBJECT_ID, p_GUI_OBJECT_ID),
117: PERZ_DDF_VALUE = decode( p_DDF_VALUE, FND_API.G_MISS_CHAR, PERZ_DDF_VALUE, p_DDF_VALUE),
118: PERZ_DDF_VALUE_TYPE = decode( p_DDF_VALUE_TYPE, FND_API.G_MISS_CHAR, PERZ_DDF_VALUE_TYPE, p_DDF_VALUE_TYPE),

Line 115: -- GUI_OBJECT_NAME = decode( p_GUI_OBJECT_NAME, FND_API.G_MISS_CHAR, GUI_OBJECT_NAME, p_GUI_OBJECT_NAME),

111: SET
112: -- PROFILE_ID = decode( p_PROFILE_ID, FND_API.G_MISS_NUM, PROFILE_ID, p_PROFILE_ID),
113: -- APPLICATION_ID = decode( p_APPLICATION_ID, FND_API.G_MISS_NUM, APPLICATION_ID, p_APPLICATION_ID),
114: -- PERZ_DDF_CONTEXT = decode( p_PERZ_DDF_CONTEXT, FND_API.G_MISS_CHAR, PERZ_DDF_CONTEXT, p_PERZ_DDF_CONTEXT),
115: -- GUI_OBJECT_NAME = decode( p_GUI_OBJECT_NAME, FND_API.G_MISS_CHAR, GUI_OBJECT_NAME, p_GUI_OBJECT_NAME),
116: -- GUI_OBJECT_ID = decode( p_GUI_OBJECT_ID, FND_API.G_MISS_NUM, GUI_OBJECT_ID, p_GUI_OBJECT_ID),
117: PERZ_DDF_VALUE = decode( p_DDF_VALUE, FND_API.G_MISS_CHAR, PERZ_DDF_VALUE, p_DDF_VALUE),
118: PERZ_DDF_VALUE_TYPE = decode( p_DDF_VALUE_TYPE, FND_API.G_MISS_CHAR, PERZ_DDF_VALUE_TYPE, p_DDF_VALUE_TYPE),
119: OBJECT_VERSION_NUMBER = decode (p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,

Line 116: -- GUI_OBJECT_ID = decode( p_GUI_OBJECT_ID, FND_API.G_MISS_NUM, GUI_OBJECT_ID, p_GUI_OBJECT_ID),

112: -- PROFILE_ID = decode( p_PROFILE_ID, FND_API.G_MISS_NUM, PROFILE_ID, p_PROFILE_ID),
113: -- APPLICATION_ID = decode( p_APPLICATION_ID, FND_API.G_MISS_NUM, APPLICATION_ID, p_APPLICATION_ID),
114: -- PERZ_DDF_CONTEXT = decode( p_PERZ_DDF_CONTEXT, FND_API.G_MISS_CHAR, PERZ_DDF_CONTEXT, p_PERZ_DDF_CONTEXT),
115: -- GUI_OBJECT_NAME = decode( p_GUI_OBJECT_NAME, FND_API.G_MISS_CHAR, GUI_OBJECT_NAME, p_GUI_OBJECT_NAME),
116: -- GUI_OBJECT_ID = decode( p_GUI_OBJECT_ID, FND_API.G_MISS_NUM, GUI_OBJECT_ID, p_GUI_OBJECT_ID),
117: PERZ_DDF_VALUE = decode( p_DDF_VALUE, FND_API.G_MISS_CHAR, PERZ_DDF_VALUE, p_DDF_VALUE),
118: PERZ_DDF_VALUE_TYPE = decode( p_DDF_VALUE_TYPE, FND_API.G_MISS_CHAR, PERZ_DDF_VALUE_TYPE, p_DDF_VALUE_TYPE),
119: OBJECT_VERSION_NUMBER = decode (p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,
120: OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER+1),

Line 117: PERZ_DDF_VALUE = decode( p_DDF_VALUE, FND_API.G_MISS_CHAR, PERZ_DDF_VALUE, p_DDF_VALUE),

113: -- APPLICATION_ID = decode( p_APPLICATION_ID, FND_API.G_MISS_NUM, APPLICATION_ID, p_APPLICATION_ID),
114: -- PERZ_DDF_CONTEXT = decode( p_PERZ_DDF_CONTEXT, FND_API.G_MISS_CHAR, PERZ_DDF_CONTEXT, p_PERZ_DDF_CONTEXT),
115: -- GUI_OBJECT_NAME = decode( p_GUI_OBJECT_NAME, FND_API.G_MISS_CHAR, GUI_OBJECT_NAME, p_GUI_OBJECT_NAME),
116: -- GUI_OBJECT_ID = decode( p_GUI_OBJECT_ID, FND_API.G_MISS_NUM, GUI_OBJECT_ID, p_GUI_OBJECT_ID),
117: PERZ_DDF_VALUE = decode( p_DDF_VALUE, FND_API.G_MISS_CHAR, PERZ_DDF_VALUE, p_DDF_VALUE),
118: PERZ_DDF_VALUE_TYPE = decode( p_DDF_VALUE_TYPE, FND_API.G_MISS_CHAR, PERZ_DDF_VALUE_TYPE, p_DDF_VALUE_TYPE),
119: OBJECT_VERSION_NUMBER = decode (p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,
120: OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER+1),
121: LAST_UPDATE_DATE = SYSDATE,

Line 118: PERZ_DDF_VALUE_TYPE = decode( p_DDF_VALUE_TYPE, FND_API.G_MISS_CHAR, PERZ_DDF_VALUE_TYPE, p_DDF_VALUE_TYPE),

114: -- PERZ_DDF_CONTEXT = decode( p_PERZ_DDF_CONTEXT, FND_API.G_MISS_CHAR, PERZ_DDF_CONTEXT, p_PERZ_DDF_CONTEXT),
115: -- GUI_OBJECT_NAME = decode( p_GUI_OBJECT_NAME, FND_API.G_MISS_CHAR, GUI_OBJECT_NAME, p_GUI_OBJECT_NAME),
116: -- GUI_OBJECT_ID = decode( p_GUI_OBJECT_ID, FND_API.G_MISS_NUM, GUI_OBJECT_ID, p_GUI_OBJECT_ID),
117: PERZ_DDF_VALUE = decode( p_DDF_VALUE, FND_API.G_MISS_CHAR, PERZ_DDF_VALUE, p_DDF_VALUE),
118: PERZ_DDF_VALUE_TYPE = decode( p_DDF_VALUE_TYPE, FND_API.G_MISS_CHAR, PERZ_DDF_VALUE_TYPE, p_DDF_VALUE_TYPE),
119: OBJECT_VERSION_NUMBER = decode (p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,
120: OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER+1),
121: LAST_UPDATE_DATE = SYSDATE,
122: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

Line 119: OBJECT_VERSION_NUMBER = decode (p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,

115: -- GUI_OBJECT_NAME = decode( p_GUI_OBJECT_NAME, FND_API.G_MISS_CHAR, GUI_OBJECT_NAME, p_GUI_OBJECT_NAME),
116: -- GUI_OBJECT_ID = decode( p_GUI_OBJECT_ID, FND_API.G_MISS_NUM, GUI_OBJECT_ID, p_GUI_OBJECT_ID),
117: PERZ_DDF_VALUE = decode( p_DDF_VALUE, FND_API.G_MISS_CHAR, PERZ_DDF_VALUE, p_DDF_VALUE),
118: PERZ_DDF_VALUE_TYPE = decode( p_DDF_VALUE_TYPE, FND_API.G_MISS_CHAR, PERZ_DDF_VALUE_TYPE, p_DDF_VALUE_TYPE),
119: OBJECT_VERSION_NUMBER = decode (p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,
120: OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER+1),
121: LAST_UPDATE_DATE = SYSDATE,
122: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
123: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID

Line 221: ( p_PROFILE_ID <> FND_API.G_MISS_NUM)) AND

217:
218: BEGIN
219:
220: if ((( p_PROFILE_ID is NOT NULL) AND
221: ( p_PROFILE_ID <> FND_API.G_MISS_NUM)) AND
222: ((p_APPLICATION_ID is NOT NULL) AND
223: ( p_APPLICATION_ID <> FND_API.G_MISS_NUM))) then
224:
225: if ((p_GUI_OBJECT_ID is NOT NULL) AND

Line 223: ( p_APPLICATION_ID <> FND_API.G_MISS_NUM))) then

219:
220: if ((( p_PROFILE_ID is NOT NULL) AND
221: ( p_PROFILE_ID <> FND_API.G_MISS_NUM)) AND
222: ((p_APPLICATION_ID is NOT NULL) AND
223: ( p_APPLICATION_ID <> FND_API.G_MISS_NUM))) then
224:
225: if ((p_GUI_OBJECT_ID is NOT NULL) AND
226: (p_GUI_OBJECT_ID <>FND_API.G_MISS_NUM)) then
227: if (((p_PERZ_DDF_CONTEXT is NOT NULL) AND

Line 226: (p_GUI_OBJECT_ID <>FND_API.G_MISS_NUM)) then

222: ((p_APPLICATION_ID is NOT NULL) AND
223: ( p_APPLICATION_ID <> FND_API.G_MISS_NUM))) then
224:
225: if ((p_GUI_OBJECT_ID is NOT NULL) AND
226: (p_GUI_OBJECT_ID <>FND_API.G_MISS_NUM)) then
227: if (((p_PERZ_DDF_CONTEXT is NOT NULL) AND
228: (p_PERZ_DDF_CONTEXT <> FND_API.G_MISS_CHAR))) then
229:
230: l_ddf_out_rec_temp := NULL;

Line 228: (p_PERZ_DDF_CONTEXT <> FND_API.G_MISS_CHAR))) then

224:
225: if ((p_GUI_OBJECT_ID is NOT NULL) AND
226: (p_GUI_OBJECT_ID <>FND_API.G_MISS_NUM)) then
227: if (((p_PERZ_DDF_CONTEXT is NOT NULL) AND
228: (p_PERZ_DDF_CONTEXT <> FND_API.G_MISS_CHAR))) then
229:
230: l_ddf_out_rec_temp := NULL;
231: l_count := 1;
232: open c_get_ddf_paoc (p_profile_id , p_application_id ,

Line 258: x_return_status := FND_API.G_TRUE;

254: l_count := l_count +1;
255: END IF;
256: END LOOP;
257: close c_get_ddf_paoc;
258: x_return_status := FND_API.G_TRUE;
259: else
260:
261: l_ddf_out_rec_temp := NULL;
262: l_count := 1;

Line 289: x_return_status := FND_API.G_TRUE;

285: l_count := l_count +1;
286: END IF;
287: END LOOP;
288: close c_get_ddf_pao;
289: x_return_status := FND_API.G_TRUE;
290: end if;
291:
292: elsif ((p_GUI_OBJECT_NAME is NOT NULL) AND
293: (p_GUI_OBJECT_NAME <>FND_API.G_MISS_CHAR)) then

Line 293: (p_GUI_OBJECT_NAME <>FND_API.G_MISS_CHAR)) then

289: x_return_status := FND_API.G_TRUE;
290: end if;
291:
292: elsif ((p_GUI_OBJECT_NAME is NOT NULL) AND
293: (p_GUI_OBJECT_NAME <>FND_API.G_MISS_CHAR)) then
294: if (((p_PERZ_DDF_CONTEXT is NOT NULL) AND
295: (p_PERZ_DDF_CONTEXT <> FND_API.G_MISS_CHAR))) then
296: l_count := 1;
297: l_ddf_out_rec_temp := NULL;

Line 295: (p_PERZ_DDF_CONTEXT <> FND_API.G_MISS_CHAR))) then

291:
292: elsif ((p_GUI_OBJECT_NAME is NOT NULL) AND
293: (p_GUI_OBJECT_NAME <>FND_API.G_MISS_CHAR)) then
294: if (((p_PERZ_DDF_CONTEXT is NOT NULL) AND
295: (p_PERZ_DDF_CONTEXT <> FND_API.G_MISS_CHAR))) then
296: l_count := 1;
297: l_ddf_out_rec_temp := NULL;
298: open c_get_ddf_panc (p_profile_id , p_application_id ,
299: p_gui_object_name , p_perz_ddf_context ) ;

Line 324: x_return_status := FND_API.G_TRUE;

320: l_count := l_count +1;
321: END IF;
322: END LOOP;
323: close c_get_ddf_panc ;
324: x_return_status := FND_API.G_TRUE;
325: else
326: l_count := 1;
327: open c_get_ddf_pan (p_profile_id ,
328: p_application_id ,

Line 354: x_return_status := FND_API.G_TRUE;

350: l_count := l_count +1;
351: END IF;
352: END LOOP;
353: close c_get_ddf_pan;
354: x_return_status := FND_API.G_TRUE;
355: end if;
356: else
357: x_return_status := FND_API.G_FALSE;
358: end if;

Line 357: x_return_status := FND_API.G_FALSE;

353: close c_get_ddf_pan;
354: x_return_status := FND_API.G_TRUE;
355: end if;
356: else
357: x_return_status := FND_API.G_FALSE;
358: end if;
359: else
360: x_return_status := FND_API.G_FALSE;
361: end if;

Line 360: x_return_status := FND_API.G_FALSE;

356: else
357: x_return_status := FND_API.G_FALSE;
358: end if;
359: else
360: x_return_status := FND_API.G_FALSE;
361: end if;
362:
363:
364: END Get_ddf;

Line 404: (x_PERZ_DDF_ID <> FND_API.G_MISS_NUM)) then

400:
401: BEGIN
402:
403: if ((x_PERZ_DDF_ID is NOT NULL) AND
404: (x_PERZ_DDF_ID <> FND_API.G_MISS_NUM)) then
405:
406: select PERZ_DATA_DEFAULT_ID, OBJECT_VERSION_NUMBER
407: into l_perz_ddf_id, x_OBJECT_VERSION_NUMBER
408: from JTF_PERZ_DATA_DEFAULT

Line 416: ( p_PROFILE_ID <> FND_API.G_MISS_NUM)) AND

412: RAISE NO_DATA_FOUND;
413: End If;
414:
415: elsif ((( p_PROFILE_ID is NOT NULL) AND
416: ( p_PROFILE_ID <> FND_API.G_MISS_NUM)) AND
417: ((p_APPLICATION_ID is NOT NULL) AND
418: ( p_APPLICATION_ID <> FND_API.G_MISS_NUM)) AND
419: ((p_PERZ_DDF_CONTEXT is NOT NULL) AND
420: ( p_PERZ_DDF_CONTEXT <> FND_API.G_MISS_CHAR))) then

Line 418: ( p_APPLICATION_ID <> FND_API.G_MISS_NUM)) AND

414:
415: elsif ((( p_PROFILE_ID is NOT NULL) AND
416: ( p_PROFILE_ID <> FND_API.G_MISS_NUM)) AND
417: ((p_APPLICATION_ID is NOT NULL) AND
418: ( p_APPLICATION_ID <> FND_API.G_MISS_NUM)) AND
419: ((p_PERZ_DDF_CONTEXT is NOT NULL) AND
420: ( p_PERZ_DDF_CONTEXT <> FND_API.G_MISS_CHAR))) then
421:
422: if ((p_GUI_OBJECT_ID is NOT NULL) AND

Line 420: ( p_PERZ_DDF_CONTEXT <> FND_API.G_MISS_CHAR))) then

416: ( p_PROFILE_ID <> FND_API.G_MISS_NUM)) AND
417: ((p_APPLICATION_ID is NOT NULL) AND
418: ( p_APPLICATION_ID <> FND_API.G_MISS_NUM)) AND
419: ((p_PERZ_DDF_CONTEXT is NOT NULL) AND
420: ( p_PERZ_DDF_CONTEXT <> FND_API.G_MISS_CHAR))) then
421:
422: if ((p_GUI_OBJECT_ID is NOT NULL) AND
423: (p_GUI_OBJECT_ID <>FND_API.G_MISS_NUM)) then
424: BEGIN

Line 423: (p_GUI_OBJECT_ID <>FND_API.G_MISS_NUM)) then

419: ((p_PERZ_DDF_CONTEXT is NOT NULL) AND
420: ( p_PERZ_DDF_CONTEXT <> FND_API.G_MISS_CHAR))) then
421:
422: if ((p_GUI_OBJECT_ID is NOT NULL) AND
423: (p_GUI_OBJECT_ID <>FND_API.G_MISS_NUM)) then
424: BEGIN
425: select PERZ_DATA_DEFAULT_ID, OBJECT_VERSION_NUMBER
426: into l_perz_ddf_id, x_OBJECT_VERSION_NUMBER
427: from JTF_PERZ_DATA_DEFAULT

Line 445: (p_GUI_OBJECT_NAME <> FND_API.G_MISS_CHAR)) THEN

441:
442: END;
443: else
444: if ((p_GUI_OBJECT_NAME is NOT NULL) AND
445: (p_GUI_OBJECT_NAME <> FND_API.G_MISS_CHAR)) THEN
446: BEGIN
447: select PERZ_DATA_DEFAULT_ID, OBJECT_VERSION_NUMBER
448: into l_perz_ddf_id, x_OBJECT_VERSION_NUMBER
449: from JTF_PERZ_DATA_DEFAULT

Line 467: RAISE FND_API.G_EXC_ERROR;

463:
464: END;
465:
466: else
467: RAISE FND_API.G_EXC_ERROR;
468: End If;
469: End If;
470:
471: else

Line 472: RAISE FND_API.G_EXC_ERROR;

468: End If;
469: End If;
470:
471: else
472: RAISE FND_API.G_EXC_ERROR;
473:
474: end if;
475:
476: END Check_ddf;

Line 581: -- IF NOT FND_API.Compatible_API_Call (

577: -- Standard Start of API savepoint
578: SAVEPOINT CREATE_PERZ_DDF_PVT;
579:
580: -- Standard call to check for call compatibility.
581: -- IF NOT FND_API.Compatible_API_Call (
582: -- l_api_version_number,
583: -- p_api_version_number,
584: -- l_api_name,
585: -- G_PKG_NAME)

Line 587: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

583: -- p_api_version_number,
584: -- l_api_name,
585: -- G_PKG_NAME)
586: -- THEN
587: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
588: -- END IF;
589:
590: -- Initialize message list if p_init_msg_list is set to TRUE.
591: IF FND_API.to_Boolean( p_init_msg_list )

Line 591: IF FND_API.to_Boolean( p_init_msg_list )

587: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
588: -- END IF;
589:
590: -- Initialize message list if p_init_msg_list is set to TRUE.
591: IF FND_API.to_Boolean( p_init_msg_list )
592: THEN
593: FND_MSG_PUB.initialize;
594: END IF;
595:

Line 597: x_return_status := FND_API.G_RET_STS_SUCCESS;

593: FND_MSG_PUB.initialize;
594: END IF;
595:
596: -- Initialize API return status to success
597: x_return_status := FND_API.G_RET_STS_SUCCESS;
598:
599: -- Create_data_default implementation
600:
601: --1. Check if the profile exists. This check will be done

Line 608: l_return_status := FND_API.G_TRUE;

604: -- client and not on the server.
605:
606: l_profile_id := p_profile_id;
607: l_profile_name := p_profile_name;
608: l_return_status := FND_API.G_TRUE;
609:
610: JTF_PERZ_PROFILE_PVT.check_profile_duplicates(
611: l_profile_name,
612: l_return_status,

Line 619: if (l_return_status = FND_API.G_FALSE) then

615:
616:
617: -- If profile does not exists, raise an error and exit
618:
619: if (l_return_status = FND_API.G_FALSE) then
620: RAISE FND_API.G_EXC_ERROR;
621: end if;
622:
623: --2 Calling the insert table handler

Line 620: RAISE FND_API.G_EXC_ERROR;

616:
617: -- If profile does not exists, raise an error and exit
618:
619: if (l_return_status = FND_API.G_FALSE) then
620: RAISE FND_API.G_EXC_ERROR;
621: end if;
622:
623: --2 Calling the insert table handler
624: l_object_version_number := 1;

Line 638: OR (l_perz_ddf_id = FND_API.G_MISS_NUM)) then

634: l_object_version_number
635: );
636:
637: if (( l_perz_ddf_id is NULL)
638: OR (l_perz_ddf_id = FND_API.G_MISS_NUM)) then
639: RAISE FND_API.G_EXC_ERROR;
640: else
641: x_perz_ddf_id := l_perz_ddf_id;
642: end if;

Line 639: RAISE FND_API.G_EXC_ERROR;

635: );
636:
637: if (( l_perz_ddf_id is NULL)
638: OR (l_perz_ddf_id = FND_API.G_MISS_NUM)) then
639: RAISE FND_API.G_EXC_ERROR;
640: else
641: x_perz_ddf_id := l_perz_ddf_id;
642: end if;
643:

Line 651: IF FND_API.To_Boolean ( p_commit )

647: --
648: -- 7. Commit the whole thing
649:
650: -- Standard check of p_commit.
651: IF FND_API.To_Boolean ( p_commit )
652: THEN
653: COMMIT WORK;
654: END IF;
655:

Line 667: WHEN FND_API.G_EXC_ERROR THEN

663:
664:
665: EXCEPTION
666:
667: WHEN FND_API.G_EXC_ERROR THEN
668:
669: ROLLBACK TO CREATE_PERZ_DDF_PVT;
670: x_return_status := FND_API.G_RET_STS_ERROR ;
671:

Line 670: x_return_status := FND_API.G_RET_STS_ERROR ;

666:
667: WHEN FND_API.G_EXC_ERROR THEN
668:
669: ROLLBACK TO CREATE_PERZ_DDF_PVT;
670: x_return_status := FND_API.G_RET_STS_ERROR ;
671:
672: FND_MSG_PUB.Count_And_Get
673: ( p_count => x_msg_count,
674: p_data => x_msg_data

Line 682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

678: THEN
679: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
680: END IF;
681:
682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
683:
684: ROLLBACK TO CREATE_PERZ_DDF_PVT;
685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
686:

Line 685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

681:
682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
683:
684: ROLLBACK TO CREATE_PERZ_DDF_PVT;
685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
686:
687: FND_MSG_PUB.Count_And_Get
688: ( p_count => x_msg_count,
689: p_data => x_msg_data

Line 700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

696:
697: WHEN OTHERS THEN
698:
699: ROLLBACK TO CREATE_PERZ_DDF_PVT;
700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
701:
702: FND_MSG_PUB.Count_And_Get
703: ( p_count => x_msg_count,
704: p_data => x_msg_data

Line 810: -- IF NOT FND_API.Compatible_API_Call (

806: -- Standard Start of API savepoint
807: SAVEPOINT UPDATE_PERZ_DDF_PVT;
808:
809: -- Standard call to check for call compatibility.
810: -- IF NOT FND_API.Compatible_API_Call (
811: -- l_api_version_number,
812: -- p_api_version_number,
813: -- l_api_name,
814: -- G_PKG_NAME)

Line 816: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

812: -- p_api_version_number,
813: -- l_api_name,
814: -- G_PKG_NAME)
815: -- THEN
816: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
817: -- END IF;
818:
819: -- Initialize message list if p_init_msg_list is set to TRUE.
820: IF FND_API.to_Boolean( p_init_msg_list )

Line 820: IF FND_API.to_Boolean( p_init_msg_list )

816: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
817: -- END IF;
818:
819: -- Initialize message list if p_init_msg_list is set to TRUE.
820: IF FND_API.to_Boolean( p_init_msg_list )
821: THEN
822: FND_MSG_PUB.initialize;
823: END IF;
824:

Line 826: x_return_status := FND_API.G_RET_STS_SUCCESS;

822: FND_MSG_PUB.initialize;
823: END IF;
824:
825: -- Initialize API return status to success
826: x_return_status := FND_API.G_RET_STS_SUCCESS;
827:
828: -- update_data_default implementation
829: --1. Check if the profile exists. This check will be done
830: -- irrespective of whether the user had provided the id or not.

Line 836: l_return_status := FND_API.G_TRUE;

832: -- client and not on the server.
833:
834: l_profile_id := p_profile_id;
835: l_profile_name := p_profile_name;
836: l_return_status := FND_API.G_TRUE;
837:
838: JTF_PERZ_PROFILE_PVT.check_profile_duplicates(
839: l_profile_name,
840: l_return_status,

Line 847: if (l_return_status = FND_API.G_FALSE) then

843:
844:
845: -- If profile does not exists, raise an error and exit
846:
847: if (l_return_status = FND_API.G_FALSE) then
848: RAISE FND_API.G_EXC_ERROR;
849: end if;
850:
851: --2. Check if DDF exists in the DB.

Line 848: RAISE FND_API.G_EXC_ERROR;

844:
845: -- If profile does not exists, raise an error and exit
846:
847: if (l_return_status = FND_API.G_FALSE) then
848: RAISE FND_API.G_EXC_ERROR;
849: end if;
850:
851: --2. Check if DDF exists in the DB.
852: -- This must be done to obtain the perz_ddf_id. Other wise,

Line 867: OR (l_perz_ddf_id = FND_API.G_MISS_NUM)) then

863: l_OBJECT_VERSION_NUMBER
864: );
865:
866: if (( l_perz_ddf_id is NULL)
867: OR (l_perz_ddf_id = FND_API.G_MISS_NUM)) then
868: RAISE FND_API.G_EXC_ERROR;
869: else
870:
871: --3. Call the update handler

Line 868: RAISE FND_API.G_EXC_ERROR;

864: );
865:
866: if (( l_perz_ddf_id is NULL)
867: OR (l_perz_ddf_id = FND_API.G_MISS_NUM)) then
868: RAISE FND_API.G_EXC_ERROR;
869: else
870:
871: --3. Call the update handler
872:

Line 886: OR (l_perz_ddf_id = FND_API.G_MISS_NUM)) then

882: l_OBJECT_VERSION_NUMBER
883: );
884:
885: if (( l_perz_ddf_id is NULL)
886: OR (l_perz_ddf_id = FND_API.G_MISS_NUM)) then
887: RAISE FND_API.G_EXC_ERROR;
888: else
889: x_perz_ddf_id := l_perz_ddf_id;
890: end if;

Line 887: RAISE FND_API.G_EXC_ERROR;

883: );
884:
885: if (( l_perz_ddf_id is NULL)
886: OR (l_perz_ddf_id = FND_API.G_MISS_NUM)) then
887: RAISE FND_API.G_EXC_ERROR;
888: else
889: x_perz_ddf_id := l_perz_ddf_id;
890: end if;
891:

Line 901: IF FND_API.To_Boolean ( p_commit )

897: --
898: -- 7. Commit the whole thing
899:
900: -- Standard check of p_commit.
901: IF FND_API.To_Boolean ( p_commit )
902: THEN
903: COMMIT WORK;
904: END IF;
905:

Line 917: WHEN FND_API.G_EXC_ERROR THEN

913:
914:
915: EXCEPTION
916:
917: WHEN FND_API.G_EXC_ERROR THEN
918:
919: ROLLBACK TO UPDATE_PERZ_DDF_PVT;
920: x_return_status := FND_API.G_RET_STS_ERROR ;
921:

Line 920: x_return_status := FND_API.G_RET_STS_ERROR ;

916:
917: WHEN FND_API.G_EXC_ERROR THEN
918:
919: ROLLBACK TO UPDATE_PERZ_DDF_PVT;
920: x_return_status := FND_API.G_RET_STS_ERROR ;
921:
922: FND_MSG_PUB.Count_And_Get
923: ( p_count => x_msg_count,
924: p_data => x_msg_data

Line 932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

928: THEN
929: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
930: END IF;
931:
932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
933:
934: ROLLBACK TO UPDATE_PERZ_DDF_PVT;
935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
936:

Line 935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

931:
932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
933:
934: ROLLBACK TO UPDATE_PERZ_DDF_PVT;
935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
936:
937: FND_MSG_PUB.Count_And_Get
938: ( p_count => x_msg_count,
939: p_data => x_msg_data

Line 950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

946:
947: WHEN OTHERS THEN
948:
949: ROLLBACK TO UPDATE_PERZ_DDF_PVT;
950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
951:
952: FND_MSG_PUB.Count_And_Get
953: ( p_count => x_msg_count,
954: p_data => x_msg_data

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

1012: -- *****************************************************************************
1013: --
1014: PROCEDURE save_data_default
1015: ( p_api_version_number IN NUMBER,
1016: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1017: p_commit IN VARCHAR := FND_API.G_FALSE,
1018:
1019: p_application_id IN NUMBER,
1020:

Line 1017: p_commit IN VARCHAR := FND_API.G_FALSE,

1013: --
1014: PROCEDURE save_data_default
1015: ( p_api_version_number IN NUMBER,
1016: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1017: p_commit IN VARCHAR := FND_API.G_FALSE,
1018:
1019: p_application_id IN NUMBER,
1020:
1021: p_profile_id IN NUMBER,

Line 1054: l_return_status VARCHAR2(240) := FND_API.G_TRUE;

1050: l_profile_type VARCHAR2(30) := p_profile_type;
1051: l_profile_attrib JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE
1052: := p_profile_attrib;
1053: l_perz_ddf_id NUMBER := p_perz_ddf_id;
1054: l_return_status VARCHAR2(240) := FND_API.G_TRUE;
1055: l_commit VARCHAR2(1) := FND_API.G_TRUE;
1056: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
1057: l_object_version_number NUMBER := NULL;
1058:

Line 1055: l_commit VARCHAR2(1) := FND_API.G_TRUE;

1051: l_profile_attrib JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE
1052: := p_profile_attrib;
1053: l_perz_ddf_id NUMBER := p_perz_ddf_id;
1054: l_return_status VARCHAR2(240) := FND_API.G_TRUE;
1055: l_commit VARCHAR2(1) := FND_API.G_TRUE;
1056: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
1057: l_object_version_number NUMBER := NULL;
1058:
1059: BEGIN

Line 1056: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;

1052: := p_profile_attrib;
1053: l_perz_ddf_id NUMBER := p_perz_ddf_id;
1054: l_return_status VARCHAR2(240) := FND_API.G_TRUE;
1055: l_commit VARCHAR2(1) := FND_API.G_TRUE;
1056: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
1057: l_object_version_number NUMBER := NULL;
1058:
1059: BEGIN
1060:

Line 1075: -- IF NOT FND_API.Compatible_API_Call (

1071: -- Standard Start of API savepoint
1072: SAVEPOINT SAVE_PERZ_DDF_PVT;
1073:
1074: -- Standard call to check for call compatibility.
1075: -- IF NOT FND_API.Compatible_API_Call (
1076: -- l_api_version_number,
1077: -- p_api_version_number,
1078: -- l_api_name,
1079: -- G_PKG_NAME)

Line 1081: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1077: -- p_api_version_number,
1078: -- l_api_name,
1079: -- G_PKG_NAME)
1080: -- THEN
1081: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1082: -- END IF;
1083:
1084: -- Initialize message list if p_init_msg_list is set to TRUE.
1085: IF FND_API.to_Boolean( p_init_msg_list )

Line 1085: IF FND_API.to_Boolean( p_init_msg_list )

1081: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1082: -- END IF;
1083:
1084: -- Initialize message list if p_init_msg_list is set to TRUE.
1085: IF FND_API.to_Boolean( p_init_msg_list )
1086: THEN
1087: FND_MSG_PUB.initialize;
1088: END IF;
1089:

Line 1091: x_return_status := FND_API.G_RET_STS_SUCCESS;

1087: FND_MSG_PUB.initialize;
1088: END IF;
1089:
1090: -- Initialize API return status to success
1091: x_return_status := FND_API.G_RET_STS_SUCCESS;
1092:
1093: -- save_data_default implementation
1094: --1. Check if the profile exists. This check will be done
1095: -- irrespective of whether the user had provided the id or not.

Line 1103: l_return_status := FND_API.G_TRUE;

1099:
1100: l_profile_id := p_profile_id;
1101: l_profile_name := p_profile_name;
1102: l_profile_type := p_profile_type;
1103: l_return_status := FND_API.G_TRUE;
1104:
1105: JTF_PERZ_PROFILE_PVT.check_profile_duplicates(
1106: l_profile_name,
1107: l_return_status,

Line 1114: if (l_return_status = FND_API.G_FALSE) then

1110:
1111:
1112: -- If profile does not exists, call create_profile()
1113:
1114: if (l_return_status = FND_API.G_FALSE) then
1115:
1116:
1117: l_return_status := FND_API.G_RET_STS_SUCCESS;
1118: l_commit := FND_API.G_FALSE;

Line 1117: l_return_status := FND_API.G_RET_STS_SUCCESS;

1113:
1114: if (l_return_status = FND_API.G_FALSE) then
1115:
1116:
1117: l_return_status := FND_API.G_RET_STS_SUCCESS;
1118: l_commit := FND_API.G_FALSE;
1119: l_profile_id := p_profile_id;
1120:
1121: JTF_PERZ_PROFILE_PVT.Create_Profile(

Line 1118: l_commit := FND_API.G_FALSE;

1114: if (l_return_status = FND_API.G_FALSE) then
1115:
1116:
1117: l_return_status := FND_API.G_RET_STS_SUCCESS;
1118: l_commit := FND_API.G_FALSE;
1119: l_profile_id := p_profile_id;
1120:
1121: JTF_PERZ_PROFILE_PVT.Create_Profile(
1122: p_api_version_number => l_api_version_number,

Line 1136: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

1132: x_msg_count => x_msg_count,
1133: x_msg_data => x_msg_data
1134: );
1135: --dbms_output.put_line('profile return status '||l_return_status);
1136: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1137:
1138: RAISE FND_API.G_EXC_ERROR;
1139: end if;
1140: end if;

Line 1138: RAISE FND_API.G_EXC_ERROR;

1134: );
1135: --dbms_output.put_line('profile return status '||l_return_status);
1136: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1137:
1138: RAISE FND_API.G_EXC_ERROR;
1139: end if;
1140: end if;
1141:
1142:

Line 1161: OR (l_perz_ddf_id = FND_API.G_MISS_NUM)) then

1157: l_OBJECT_VERSION_NUMBER
1158: );
1159:
1160: if (( l_perz_ddf_id is NULL)
1161: OR (l_perz_ddf_id = FND_API.G_MISS_NUM)) then
1162:
1163: --3. If DDF does not exist, create it
1164:
1165: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1165: l_return_status := FND_API.G_RET_STS_SUCCESS;

1161: OR (l_perz_ddf_id = FND_API.G_MISS_NUM)) then
1162:
1163: --3. If DDF does not exist, create it
1164:
1165: l_return_status := FND_API.G_RET_STS_SUCCESS;
1166: l_commit := FND_API.G_FALSE;
1167: l_profile_name := NULL;
1168:
1169: create_data_default

Line 1166: l_commit := FND_API.G_FALSE;

1162:
1163: --3. If DDF does not exist, create it
1164:
1165: l_return_status := FND_API.G_RET_STS_SUCCESS;
1166: l_commit := FND_API.G_FALSE;
1167: l_profile_name := NULL;
1168:
1169: create_data_default
1170: (

Line 1193: l_return_status := FND_API.G_RET_STS_SUCCESS;

1189: else
1190:
1191: --3. If DDF exists, update it
1192:
1193: l_return_status := FND_API.G_RET_STS_SUCCESS;
1194: l_commit := FND_API.G_FALSE;
1195: l_profile_name := NULL;
1196:
1197: update_data_default

Line 1194: l_commit := FND_API.G_FALSE;

1190:
1191: --3. If DDF exists, update it
1192:
1193: l_return_status := FND_API.G_RET_STS_SUCCESS;
1194: l_commit := FND_API.G_FALSE;
1195: l_profile_name := NULL;
1196:
1197: update_data_default
1198: (

Line 1224: IF FND_API.To_Boolean ( p_commit )

1220: --
1221: -- 7. Commit the whole thing
1222:
1223: -- Standard check of p_commit.
1224: IF FND_API.To_Boolean ( p_commit )
1225: THEN
1226: COMMIT WORK;
1227: END IF;
1228:

Line 1240: WHEN FND_API.G_EXC_ERROR THEN

1236:
1237:
1238: EXCEPTION
1239:
1240: WHEN FND_API.G_EXC_ERROR THEN
1241:
1242: ROLLBACK TO SAVE_PERZ_DDF_PVT;
1243: x_return_status := FND_API.G_RET_STS_ERROR ;
1244:

Line 1243: x_return_status := FND_API.G_RET_STS_ERROR ;

1239:
1240: WHEN FND_API.G_EXC_ERROR THEN
1241:
1242: ROLLBACK TO SAVE_PERZ_DDF_PVT;
1243: x_return_status := FND_API.G_RET_STS_ERROR ;
1244:
1245: FND_MSG_PUB.Count_And_Get
1246: ( p_count => x_msg_count,
1247: p_data => x_msg_data

Line 1255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1251: THEN
1252: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1253: END IF;
1254:
1255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1256:
1257: ROLLBACK TO SAVE_PERZ_DDF_PVT;
1258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1259:

Line 1258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1254:
1255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1256:
1257: ROLLBACK TO SAVE_PERZ_DDF_PVT;
1258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1259:
1260: FND_MSG_PUB.Count_And_Get
1261: ( p_count => x_msg_count,
1262: p_data => x_msg_data

Line 1273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1269:
1270: WHEN OTHERS THEN
1271:
1272: ROLLBACK TO SAVE_PERZ_DDF_PVT;
1273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1274:
1275: FND_MSG_PUB.Count_And_Get
1276: ( p_count => x_msg_count,
1277: p_data => x_msg_data

Line 1380: -- IF NOT FND_API.Compatible_API_Call (

1376:
1377: -- ******* get_data_default Standard Begins ********
1378:
1379: -- Standard call to check for call compatibility.
1380: -- IF NOT FND_API.Compatible_API_Call (
1381: -- l_api_version_number,
1382: -- p_api_version_number,
1383: -- l_api_name,
1384: -- G_PKG_NAME)

Line 1386: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1382: -- p_api_version_number,
1383: -- l_api_name,
1384: -- G_PKG_NAME)
1385: -- THEN
1386: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1387: -- END IF;
1388:
1389: -- Initialize message list if p_init_msg_list is set to TRUE.
1390: IF FND_API.to_Boolean( p_init_msg_list )

Line 1390: IF FND_API.to_Boolean( p_init_msg_list )

1386: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1387: -- END IF;
1388:
1389: -- Initialize message list if p_init_msg_list is set to TRUE.
1390: IF FND_API.to_Boolean( p_init_msg_list )
1391: THEN
1392: FND_MSG_PUB.initialize;
1393: END IF;
1394:

Line 1396: x_return_status := FND_API.G_RET_STS_SUCCESS;

1392: FND_MSG_PUB.initialize;
1393: END IF;
1394:
1395: -- Initialize API return status to success
1396: x_return_status := FND_API.G_RET_STS_SUCCESS;
1397:
1398: -- get_data_default implementation
1399:
1400: --1. Check if the profile exists. This check will be done

Line 1407: l_return_status := FND_API.G_TRUE;

1403: -- client and not on the server.
1404:
1405: l_profile_id := p_profile_id;
1406: l_profile_name := p_profile_name;
1407: l_return_status := FND_API.G_TRUE;
1408:
1409: JTF_PERZ_PROFILE_PVT.check_profile_duplicates(
1410: l_profile_name,
1411: l_return_status,

Line 1418: if (l_return_status = FND_API.G_FALSE) then

1414:
1415:
1416: -- If profile does not exists, raise an error and exit
1417:
1418: if (l_return_status = FND_API.G_FALSE) then
1419: RAISE FND_API.G_EXC_ERROR;
1420: end if;
1421:
1422: -- get ddf

Line 1419: RAISE FND_API.G_EXC_ERROR;

1415:
1416: -- If profile does not exists, raise an error and exit
1417:
1418: if (l_return_status = FND_API.G_FALSE) then
1419: RAISE FND_API.G_EXC_ERROR;
1420: end if;
1421:
1422: -- get ddf
1423:

Line 1425: l_return_status := FND_API.G_TRUE;

1421:
1422: -- get ddf
1423:
1424: l_perz_ddf_id := p_perz_ddf_id;
1425: l_return_status := FND_API.G_TRUE;
1426: l_ddf_out_tbl := x_ddf_out_tbl;
1427:
1428:
1429: get_ddf(

Line 1442: if (l_return_status = FND_API.G_FALSE) then

1438: l_ddf_out_tbl,
1439: l_return_status
1440: );
1441:
1442: if (l_return_status = FND_API.G_FALSE) then
1443: RAISE FND_API.G_EXC_ERROR;
1444: end if;
1445: x_ddf_out_tbl := l_ddf_out_tbl;
1446:

Line 1443: RAISE FND_API.G_EXC_ERROR;

1439: l_return_status
1440: );
1441:
1442: if (l_return_status = FND_API.G_FALSE) then
1443: RAISE FND_API.G_EXC_ERROR;
1444: end if;
1445: x_ddf_out_tbl := l_ddf_out_tbl;
1446:
1447: EXCEPTION

Line 1449: WHEN FND_API.G_EXC_ERROR THEN

1445: x_ddf_out_tbl := l_ddf_out_tbl;
1446:
1447: EXCEPTION
1448:
1449: WHEN FND_API.G_EXC_ERROR THEN
1450:
1451: x_return_status := FND_API.G_RET_STS_ERROR ;
1452:
1453: FND_MSG_PUB.Count_And_Get

Line 1451: x_return_status := FND_API.G_RET_STS_ERROR ;

1447: EXCEPTION
1448:
1449: WHEN FND_API.G_EXC_ERROR THEN
1450:
1451: x_return_status := FND_API.G_RET_STS_ERROR ;
1452:
1453: FND_MSG_PUB.Count_And_Get
1454: ( p_count => x_msg_count,
1455: p_data => x_msg_data

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

1496: -- *****************************************************************************
1497:
1498: PROCEDURE delete_data_default
1499: ( p_api_version_number IN NUMBER,
1500: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1501: p_commit IN VARCHAR := FND_API.G_FALSE,
1502:
1503: p_application_id IN NUMBER,
1504: p_profile_id IN NUMBER,

Line 1501: p_commit IN VARCHAR := FND_API.G_FALSE,

1497:
1498: PROCEDURE delete_data_default
1499: ( p_api_version_number IN NUMBER,
1500: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1501: p_commit IN VARCHAR := FND_API.G_FALSE,
1502:
1503: p_application_id IN NUMBER,
1504: p_profile_id IN NUMBER,
1505: p_perz_ddf_id IN NUMBER,

Line 1525: -- IF NOT FND_API.Compatible_API_Call (

1521: -- Standard Start of API savepoint
1522: SAVEPOINT DELETE_PERZ_DDF_PVT;
1523:
1524: -- Standard call to check for call compatibility.
1525: -- IF NOT FND_API.Compatible_API_Call (
1526: -- l_api_version_number,
1527: -- p_api_version_number,
1528: -- l_api_name,
1529: -- G_PKG_NAME)

Line 1531: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1527: -- p_api_version_number,
1528: -- l_api_name,
1529: -- G_PKG_NAME)
1530: -- THEN
1531: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1532: -- END IF;
1533:
1534: -- Initialize message list if p_init_msg_list is set to TRUE.
1535: IF FND_API.to_Boolean( p_init_msg_list )

Line 1535: IF FND_API.to_Boolean( p_init_msg_list )

1531: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1532: -- END IF;
1533:
1534: -- Initialize message list if p_init_msg_list is set to TRUE.
1535: IF FND_API.to_Boolean( p_init_msg_list )
1536: THEN
1537: FND_MSG_PUB.initialize;
1538: END IF;
1539:

Line 1541: x_return_status := FND_API.G_RET_STS_SUCCESS;

1537: FND_MSG_PUB.initialize;
1538: END IF;
1539:
1540: -- Initialize API return status to success
1541: x_return_status := FND_API.G_RET_STS_SUCCESS;
1542:
1543: if ((p_perz_ddf_id is not null)
1544: AND (p_perz_ddf_id <> FND_API.G_MISS_NUM)) then
1545: -- Call delete_row()

Line 1544: AND (p_perz_ddf_id <> FND_API.G_MISS_NUM)) then

1540: -- Initialize API return status to success
1541: x_return_status := FND_API.G_RET_STS_SUCCESS;
1542:
1543: if ((p_perz_ddf_id is not null)
1544: AND (p_perz_ddf_id <> FND_API.G_MISS_NUM)) then
1545: -- Call delete_row()
1546:
1547: delete_jtf_perz_data_default( p_perz_ddf_id);
1548: else

Line 1549: RAISE FND_API.G_EXC_ERROR;

1545: -- Call delete_row()
1546:
1547: delete_jtf_perz_data_default( p_perz_ddf_id);
1548: else
1549: RAISE FND_API.G_EXC_ERROR;
1550:
1551: end if;
1552: -- ******** Standard Ends ***********
1553: --

Line 1559: IF FND_API.To_Boolean ( p_commit )

1555: --
1556: -- 7. Commit the whole thing
1557:
1558: -- Standard check of p_commit.
1559: IF FND_API.To_Boolean ( p_commit )
1560: THEN
1561: COMMIT WORK;
1562: END IF;
1563:

Line 1575: WHEN FND_API.G_EXC_ERROR THEN

1571:
1572:
1573: EXCEPTION
1574:
1575: WHEN FND_API.G_EXC_ERROR THEN
1576:
1577: ROLLBACK TO DELETE_PERZ_DDF_PVT;
1578: x_return_status := FND_API.G_RET_STS_ERROR ;
1579:

Line 1578: x_return_status := FND_API.G_RET_STS_ERROR ;

1574:
1575: WHEN FND_API.G_EXC_ERROR THEN
1576:
1577: ROLLBACK TO DELETE_PERZ_DDF_PVT;
1578: x_return_status := FND_API.G_RET_STS_ERROR ;
1579:
1580: FND_MSG_PUB.Count_And_Get
1581: ( p_count => x_msg_count,
1582: p_data => x_msg_data

Line 1590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1586: THEN
1587: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1588: END IF;
1589:
1590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1591:
1592: ROLLBACK TO DELETE_PERZ_DDF_PVT;
1593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1594:

Line 1593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1589:
1590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1591:
1592: ROLLBACK TO DELETE_PERZ_DDF_PVT;
1593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1594:
1595: FND_MSG_PUB.Count_And_Get
1596: ( p_count => x_msg_count,
1597: p_data => x_msg_data

Line 1608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1604:
1605: WHEN OTHERS THEN
1606:
1607: ROLLBACK TO DELETE_PERZ_DDF_PVT;
1608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1609:
1610: FND_MSG_PUB.Count_And_Get
1611: ( p_count => x_msg_count,
1612: p_data => x_msg_data