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

Line 61: If (px_PERZ_DATA_ID IS NULL) OR (px_PERZ_DATA_ID = FND_API.G_MISS_NUM) then

57:
58: IS
59: CURSOR C2 IS SELECT JTF_PERZ_DATA_S.nextval FROM sys.dual;
60: BEGIN
61: If (px_PERZ_DATA_ID IS NULL) OR (px_PERZ_DATA_ID = FND_API.G_MISS_NUM) then
62: OPEN C2;
63: FETCH C2 INTO px_PERZ_DATA_ID;
64: CLOSE C2;
65: End If;

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

76: LAST_UPDATED_BY,
77: LAST_UPDATE_LOGIN
78: ) VALUES (
79: px_PERZ_DATA_ID,
80: decode( p_PROFILE_ID, FND_API.G_MISS_NUM, NULL, p_PROFILE_ID),
81: decode( p_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_APPLICATION_ID),
82: decode( p_PERZ_DATA_NAME, FND_API.G_MISS_CHAR, NULL, p_PERZ_DATA_NAME),
83: decode( p_PERZ_DATA_TYPE, FND_API.G_MISS_CHAR, NULL, p_PERZ_DATA_TYPE),
84: decode( p_PERZ_DATA_DESC, FND_API.G_MISS_CHAR, NULL, p_PERZ_DATA_DESC),

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

77: LAST_UPDATE_LOGIN
78: ) VALUES (
79: px_PERZ_DATA_ID,
80: decode( p_PROFILE_ID, FND_API.G_MISS_NUM, NULL, p_PROFILE_ID),
81: decode( p_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_APPLICATION_ID),
82: decode( p_PERZ_DATA_NAME, FND_API.G_MISS_CHAR, NULL, p_PERZ_DATA_NAME),
83: decode( p_PERZ_DATA_TYPE, FND_API.G_MISS_CHAR, NULL, p_PERZ_DATA_TYPE),
84: decode( p_PERZ_DATA_DESC, FND_API.G_MISS_CHAR, NULL, p_PERZ_DATA_DESC),
85: 1, G_USER_ID, SYSDATE, G_USER_ID, G_LOGIN_ID);

Line 82: decode( p_PERZ_DATA_NAME, FND_API.G_MISS_CHAR, NULL, p_PERZ_DATA_NAME),

78: ) VALUES (
79: px_PERZ_DATA_ID,
80: decode( p_PROFILE_ID, FND_API.G_MISS_NUM, NULL, p_PROFILE_ID),
81: decode( p_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_APPLICATION_ID),
82: decode( p_PERZ_DATA_NAME, FND_API.G_MISS_CHAR, NULL, p_PERZ_DATA_NAME),
83: decode( p_PERZ_DATA_TYPE, FND_API.G_MISS_CHAR, NULL, p_PERZ_DATA_TYPE),
84: decode( p_PERZ_DATA_DESC, FND_API.G_MISS_CHAR, NULL, p_PERZ_DATA_DESC),
85: 1, G_USER_ID, SYSDATE, G_USER_ID, G_LOGIN_ID);
86: End insert_jtf_perz_data;

Line 83: decode( p_PERZ_DATA_TYPE, FND_API.G_MISS_CHAR, NULL, p_PERZ_DATA_TYPE),

79: px_PERZ_DATA_ID,
80: decode( p_PROFILE_ID, FND_API.G_MISS_NUM, NULL, p_PROFILE_ID),
81: decode( p_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_APPLICATION_ID),
82: decode( p_PERZ_DATA_NAME, FND_API.G_MISS_CHAR, NULL, p_PERZ_DATA_NAME),
83: decode( p_PERZ_DATA_TYPE, FND_API.G_MISS_CHAR, NULL, p_PERZ_DATA_TYPE),
84: decode( p_PERZ_DATA_DESC, FND_API.G_MISS_CHAR, NULL, p_PERZ_DATA_DESC),
85: 1, G_USER_ID, SYSDATE, G_USER_ID, G_LOGIN_ID);
86: End insert_jtf_perz_data;
87:

Line 84: decode( p_PERZ_DATA_DESC, FND_API.G_MISS_CHAR, NULL, p_PERZ_DATA_DESC),

80: decode( p_PROFILE_ID, FND_API.G_MISS_NUM, NULL, p_PROFILE_ID),
81: decode( p_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_APPLICATION_ID),
82: decode( p_PERZ_DATA_NAME, FND_API.G_MISS_CHAR, NULL, p_PERZ_DATA_NAME),
83: decode( p_PERZ_DATA_TYPE, FND_API.G_MISS_CHAR, NULL, p_PERZ_DATA_TYPE),
84: decode( p_PERZ_DATA_DESC, FND_API.G_MISS_CHAR, NULL, p_PERZ_DATA_DESC),
85: 1, G_USER_ID, SYSDATE, G_USER_ID, G_LOGIN_ID);
86: End insert_jtf_perz_data;
87:
88: -- *****************************************************************************

Line 100: If (px_PERZ_DATA_ATTRIB_ID IS NULL) OR (px_PERZ_DATA_ATTRIB_ID = FND_API.G_MISS_NUM) then

96:
97: IS
98: CURSOR C2 IS SELECT JTF_PERZ_DATA_ATTRIBUTES_S.nextval FROM sys.dual;
99: BEGIN
100: If (px_PERZ_DATA_ATTRIB_ID IS NULL) OR (px_PERZ_DATA_ATTRIB_ID = FND_API.G_MISS_NUM) then
101: OPEN C2;
102: FETCH C2 INTO px_PERZ_DATA_ATTRIB_ID;
103: CLOSE C2;
104: End If;

Line 118: decode( p_PERZ_DATA_ID, FND_API.G_MISS_NUM, NULL, p_PERZ_DATA_ID),

114: LAST_UPDATED_BY,
115: LAST_UPDATE_LOGIN
116: ) VALUES (
117: px_PERZ_DATA_ATTRIB_ID,
118: decode( p_PERZ_DATA_ID, FND_API.G_MISS_NUM, NULL, p_PERZ_DATA_ID),
119: decode( p_ATTRIBUTE_NAME, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_NAME),
120: decode( p_ATTRIBUTE_TYPE, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_TYPE),
121: decode( p_ATTRIBUTE_VALUE, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_VALUE),
122: decode( p_ATTRIBUTE_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CONTEXT),

Line 119: decode( p_ATTRIBUTE_NAME, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_NAME),

115: LAST_UPDATE_LOGIN
116: ) VALUES (
117: px_PERZ_DATA_ATTRIB_ID,
118: decode( p_PERZ_DATA_ID, FND_API.G_MISS_NUM, NULL, p_PERZ_DATA_ID),
119: decode( p_ATTRIBUTE_NAME, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_NAME),
120: decode( p_ATTRIBUTE_TYPE, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_TYPE),
121: decode( p_ATTRIBUTE_VALUE, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_VALUE),
122: decode( p_ATTRIBUTE_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CONTEXT),
123: G_USER_ID, SYSDATE, G_USER_ID, G_LOGIN_ID );

Line 120: decode( p_ATTRIBUTE_TYPE, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_TYPE),

116: ) VALUES (
117: px_PERZ_DATA_ATTRIB_ID,
118: decode( p_PERZ_DATA_ID, FND_API.G_MISS_NUM, NULL, p_PERZ_DATA_ID),
119: decode( p_ATTRIBUTE_NAME, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_NAME),
120: decode( p_ATTRIBUTE_TYPE, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_TYPE),
121: decode( p_ATTRIBUTE_VALUE, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_VALUE),
122: decode( p_ATTRIBUTE_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CONTEXT),
123: G_USER_ID, SYSDATE, G_USER_ID, G_LOGIN_ID );
124:

Line 121: decode( p_ATTRIBUTE_VALUE, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_VALUE),

117: px_PERZ_DATA_ATTRIB_ID,
118: decode( p_PERZ_DATA_ID, FND_API.G_MISS_NUM, NULL, p_PERZ_DATA_ID),
119: decode( p_ATTRIBUTE_NAME, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_NAME),
120: decode( p_ATTRIBUTE_TYPE, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_TYPE),
121: decode( p_ATTRIBUTE_VALUE, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_VALUE),
122: decode( p_ATTRIBUTE_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CONTEXT),
123: G_USER_ID, SYSDATE, G_USER_ID, G_LOGIN_ID );
124:
125: End insert_jtf_perz_data_attrib;

Line 122: decode( p_ATTRIBUTE_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CONTEXT),

118: decode( p_PERZ_DATA_ID, FND_API.G_MISS_NUM, NULL, p_PERZ_DATA_ID),
119: decode( p_ATTRIBUTE_NAME, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_NAME),
120: decode( p_ATTRIBUTE_TYPE, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_TYPE),
121: decode( p_ATTRIBUTE_VALUE, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_VALUE),
122: decode( p_ATTRIBUTE_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CONTEXT),
123: G_USER_ID, SYSDATE, G_USER_ID, G_LOGIN_ID );
124:
125: End insert_jtf_perz_data_attrib;
126:

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

138: IS
139: BEGIN
140: Update JTF_PERZ_DATA
141: SET
142: PROFILE_ID = decode( p_PROFILE_ID, FND_API.G_MISS_NUM, PROFILE_ID, p_PROFILE_ID),
143: APPLICATION_ID = decode( p_APPLICATION_ID, FND_API.G_MISS_NUM, APPLICATION_ID, p_APPLICATION_ID),
144: PERZ_DATA_NAME = decode( p_PERZ_DATA_NAME, FND_API.G_MISS_CHAR, PERZ_DATA_NAME, p_PERZ_DATA_NAME),
145: PERZ_DATA_TYPE = decode( p_PERZ_DATA_TYPE, FND_API.G_MISS_CHAR, PERZ_DATA_TYPE, p_PERZ_DATA_TYPE),
146: PERZ_DATA_DESC = decode( p_PERZ_DATA_DESC, FND_API.G_MISS_CHAR, PERZ_DATA_DESC, p_PERZ_DATA_DESC),

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

139: BEGIN
140: Update JTF_PERZ_DATA
141: SET
142: PROFILE_ID = decode( p_PROFILE_ID, FND_API.G_MISS_NUM, PROFILE_ID, p_PROFILE_ID),
143: APPLICATION_ID = decode( p_APPLICATION_ID, FND_API.G_MISS_NUM, APPLICATION_ID, p_APPLICATION_ID),
144: PERZ_DATA_NAME = decode( p_PERZ_DATA_NAME, FND_API.G_MISS_CHAR, PERZ_DATA_NAME, p_PERZ_DATA_NAME),
145: PERZ_DATA_TYPE = decode( p_PERZ_DATA_TYPE, FND_API.G_MISS_CHAR, PERZ_DATA_TYPE, p_PERZ_DATA_TYPE),
146: PERZ_DATA_DESC = decode( p_PERZ_DATA_DESC, FND_API.G_MISS_CHAR, PERZ_DATA_DESC, p_PERZ_DATA_DESC),
147: OBJECT_VERSION_NUMBER = decode (p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,

Line 144: PERZ_DATA_NAME = decode( p_PERZ_DATA_NAME, FND_API.G_MISS_CHAR, PERZ_DATA_NAME, p_PERZ_DATA_NAME),

140: Update JTF_PERZ_DATA
141: SET
142: PROFILE_ID = decode( p_PROFILE_ID, FND_API.G_MISS_NUM, PROFILE_ID, p_PROFILE_ID),
143: APPLICATION_ID = decode( p_APPLICATION_ID, FND_API.G_MISS_NUM, APPLICATION_ID, p_APPLICATION_ID),
144: PERZ_DATA_NAME = decode( p_PERZ_DATA_NAME, FND_API.G_MISS_CHAR, PERZ_DATA_NAME, p_PERZ_DATA_NAME),
145: PERZ_DATA_TYPE = decode( p_PERZ_DATA_TYPE, FND_API.G_MISS_CHAR, PERZ_DATA_TYPE, p_PERZ_DATA_TYPE),
146: PERZ_DATA_DESC = decode( p_PERZ_DATA_DESC, FND_API.G_MISS_CHAR, PERZ_DATA_DESC, p_PERZ_DATA_DESC),
147: OBJECT_VERSION_NUMBER = decode (p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,
148: OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER+1),

Line 145: PERZ_DATA_TYPE = decode( p_PERZ_DATA_TYPE, FND_API.G_MISS_CHAR, PERZ_DATA_TYPE, p_PERZ_DATA_TYPE),

141: SET
142: PROFILE_ID = decode( p_PROFILE_ID, FND_API.G_MISS_NUM, PROFILE_ID, p_PROFILE_ID),
143: APPLICATION_ID = decode( p_APPLICATION_ID, FND_API.G_MISS_NUM, APPLICATION_ID, p_APPLICATION_ID),
144: PERZ_DATA_NAME = decode( p_PERZ_DATA_NAME, FND_API.G_MISS_CHAR, PERZ_DATA_NAME, p_PERZ_DATA_NAME),
145: PERZ_DATA_TYPE = decode( p_PERZ_DATA_TYPE, FND_API.G_MISS_CHAR, PERZ_DATA_TYPE, p_PERZ_DATA_TYPE),
146: PERZ_DATA_DESC = decode( p_PERZ_DATA_DESC, FND_API.G_MISS_CHAR, PERZ_DATA_DESC, p_PERZ_DATA_DESC),
147: OBJECT_VERSION_NUMBER = decode (p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,
148: OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER+1),
149: LAST_UPDATE_DATE = SYSDATE,

Line 146: PERZ_DATA_DESC = decode( p_PERZ_DATA_DESC, FND_API.G_MISS_CHAR, PERZ_DATA_DESC, p_PERZ_DATA_DESC),

142: PROFILE_ID = decode( p_PROFILE_ID, FND_API.G_MISS_NUM, PROFILE_ID, p_PROFILE_ID),
143: APPLICATION_ID = decode( p_APPLICATION_ID, FND_API.G_MISS_NUM, APPLICATION_ID, p_APPLICATION_ID),
144: PERZ_DATA_NAME = decode( p_PERZ_DATA_NAME, FND_API.G_MISS_CHAR, PERZ_DATA_NAME, p_PERZ_DATA_NAME),
145: PERZ_DATA_TYPE = decode( p_PERZ_DATA_TYPE, FND_API.G_MISS_CHAR, PERZ_DATA_TYPE, p_PERZ_DATA_TYPE),
146: PERZ_DATA_DESC = decode( p_PERZ_DATA_DESC, FND_API.G_MISS_CHAR, PERZ_DATA_DESC, p_PERZ_DATA_DESC),
147: OBJECT_VERSION_NUMBER = decode (p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,
148: OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER+1),
149: LAST_UPDATE_DATE = SYSDATE,
150: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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

143: APPLICATION_ID = decode( p_APPLICATION_ID, FND_API.G_MISS_NUM, APPLICATION_ID, p_APPLICATION_ID),
144: PERZ_DATA_NAME = decode( p_PERZ_DATA_NAME, FND_API.G_MISS_CHAR, PERZ_DATA_NAME, p_PERZ_DATA_NAME),
145: PERZ_DATA_TYPE = decode( p_PERZ_DATA_TYPE, FND_API.G_MISS_CHAR, PERZ_DATA_TYPE, p_PERZ_DATA_TYPE),
146: PERZ_DATA_DESC = decode( p_PERZ_DATA_DESC, FND_API.G_MISS_CHAR, PERZ_DATA_DESC, p_PERZ_DATA_DESC),
147: OBJECT_VERSION_NUMBER = decode (p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,
148: OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER+1),
149: LAST_UPDATE_DATE = SYSDATE,
150: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
151: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID

Line 182: (p_perz_data_name <> FND_API.G_MISS_CHAR)) THEN

178:
179: --dbms_output.put_line(p_perz_data_name);
180:
181: IF ((p_perz_data_name IS NOT NULL) AND
182: (p_perz_data_name <> FND_API.G_MISS_CHAR)) THEN
183:
184:
185: -- SMATTEGU Enhancement #1165283 BEGINS
186:

Line 187: if (p_perz_data_type <> FND_API.G_MISS_CHAR) THEN

183:
184:
185: -- SMATTEGU Enhancement #1165283 BEGINS
186:
187: if (p_perz_data_type <> FND_API.G_MISS_CHAR) THEN
188:
189: SELECT perz_data_id, object_version_number
190: INTO x_perz_data_id, x_object_version_number
191: FROM jtf_perz_data

Line 211: x_return_status := FND_API.G_TRUE;

207:
208: -- SMATTEGU Enhancement #1165283 ENDS
209:
210: if (x_perz_data_id IS NOT NULL) then
211: x_return_status := FND_API.G_TRUE;
212: else
213: x_return_status := FND_API.G_FALSE;
214: end if;
215:

Line 213: x_return_status := FND_API.G_FALSE;

209:
210: if (x_perz_data_id IS NOT NULL) then
211: x_return_status := FND_API.G_TRUE;
212: else
213: x_return_status := FND_API.G_FALSE;
214: end if;
215:
216: ELSE
217: IF ((x_perz_data_id IS NOT NULL) AND

Line 218: (x_perz_data_id <> FND_API.G_MISS_NUM)) THEN

214: end if;
215:
216: ELSE
217: IF ((x_perz_data_id IS NOT NULL) AND
218: (x_perz_data_id <> FND_API.G_MISS_NUM)) THEN
219:
220: SELECT perz_data_id, object_version_number
221: INTO l_temp_id, x_object_version_number
222: from jtf_perz_data

Line 226: x_return_status := FND_API.G_TRUE;

222: from jtf_perz_data
223: where perz_data_id = x_perz_data_id;
224:
225: if (l_temp_id IS NOT NULL) then
226: x_return_status := FND_API.G_TRUE;
227: else
228: x_return_status := FND_API.G_FALSE;
229: end if;
230:

Line 228: x_return_status := FND_API.G_FALSE;

224:
225: if (l_temp_id IS NOT NULL) then
226: x_return_status := FND_API.G_TRUE;
227: else
228: x_return_status := FND_API.G_FALSE;
229: end if;
230:
231: END IF;
232: END IF;

Line 237: x_return_status := FND_API.G_FALSE;

233:
234: EXCEPTION
235:
236: WHEN NO_DATA_FOUND THEN
237: x_return_status := FND_API.G_FALSE;
238:
239: END check_perz_data;
240: -- *****************************************************************************
241: -- *****************************************************************************

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

250: -- *****************************************************************************
251:
252: PROCEDURE Save_Perz_Data
253: ( p_api_version_number IN NUMBER,
254: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
255: p_commit IN VARCHAR := FND_API.G_FALSE,
256:
257: p_application_id IN NUMBER,
258: p_profile_id IN NUMBER,

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

251:
252: PROCEDURE Save_Perz_Data
253: ( p_api_version_number IN NUMBER,
254: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
255: p_commit IN VARCHAR := FND_API.G_FALSE,
256:
257: p_application_id IN NUMBER,
258: p_profile_id IN NUMBER,
259: p_profile_name IN VARCHAR2,

Line 281: l_return_status VARCHAR2(240) := FND_API.G_RET_STS_SUCCESS;

277: l_api_name CONSTANT VARCHAR2(30) := 'Save PerzData';
278: l_api_version_number NUMBER := p_api_version_number;
279:
280: --******** Save_Perz_Data local variable for implementation *****
281: l_return_status VARCHAR2(240) := FND_API.G_RET_STS_SUCCESS;
282: l_perz_data_id NUMBER := p_perz_data_id;
283: l_PERZ_DATA_ATTRIB_ID NUMBER := NULL;
284: l_profile_id NUMBER;
285: l_is_duplicate VARCHAR2(1) := FND_API.G_FALSE;

Line 285: l_is_duplicate VARCHAR2(1) := FND_API.G_FALSE;

281: l_return_status VARCHAR2(240) := FND_API.G_RET_STS_SUCCESS;
282: l_perz_data_id NUMBER := p_perz_data_id;
283: l_PERZ_DATA_ATTRIB_ID NUMBER := NULL;
284: l_profile_id NUMBER;
285: l_is_duplicate VARCHAR2(1) := FND_API.G_FALSE;
286: l_profile_attrib JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE
287: := p_profile_attrib;
288: l_profile_name VARCHAR2(60) := p_profile_name;
289: l_commit VARCHAR2(1) := FND_API.G_FALSE;

Line 289: l_commit VARCHAR2(1) := FND_API.G_FALSE;

285: l_is_duplicate VARCHAR2(1) := FND_API.G_FALSE;
286: l_profile_attrib JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE
287: := p_profile_attrib;
288: l_profile_name VARCHAR2(60) := p_profile_name;
289: l_commit VARCHAR2(1) := FND_API.G_FALSE;
290: l_object_version_number NUMBER :=NULL;
291:
292: BEGIN
293: -- ******* Standard Begins ********

Line 299: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)

295: -- Standard Start of API savepoint
296: SAVEPOINT SAVE_PERZ_DATA_PVT;
297:
298: -- -- Standard call to check for call compatibility.
299: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
300: -- THEN
301: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
302: -- END IF;
303:

Line 301: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

297:
298: -- -- Standard call to check for call compatibility.
299: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
300: -- THEN
301: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
302: -- END IF;
303:
304: -- Initialize message list if p_init_msg_list is set to TRUE.
305: IF FND_API.to_Boolean( p_init_msg_list )

Line 305: IF FND_API.to_Boolean( p_init_msg_list )

301: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
302: -- END IF;
303:
304: -- Initialize message list if p_init_msg_list is set to TRUE.
305: IF FND_API.to_Boolean( p_init_msg_list )
306: THEN
307: FND_MSG_PUB.initialize;
308: END IF;
309:

Line 311: x_return_status := FND_API.G_RET_STS_SUCCESS;

307: FND_MSG_PUB.initialize;
308: END IF;
309:
310: -- Initialize API return status to success
311: x_return_status := FND_API.G_RET_STS_SUCCESS;
312:
313:
314: -- CALL FLOW :
315: -- 1. Check for profile, if not existing create profile.

Line 327: (p_profile_id <> FND_API.G_MISS_NUM)) then

323:
324:
325: --dbms_output.put_line('before chk profile ');
326: if ((p_profile_id IS NOT NULL) AND
327: (p_profile_id <> FND_API.G_MISS_NUM)) then
328: l_profile_id := p_profile_id;
329: else
330: l_profile_id := NULL;
331: end if;

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

339: --dbms_output.put_line('aft chk profile, profileId:'||l_profile_id);
340:
341: -- 1.1 if profile is not available, create profile
342:
343: if (l_return_status = FND_API.G_FALSE) then
344:
345: l_return_status := FND_API.G_RET_STS_SUCCESS;
346: l_commit := FND_API.G_FALSE;
347:

Line 345: l_return_status := FND_API.G_RET_STS_SUCCESS;

341: -- 1.1 if profile is not available, create profile
342:
343: if (l_return_status = FND_API.G_FALSE) then
344:
345: l_return_status := FND_API.G_RET_STS_SUCCESS;
346: l_commit := FND_API.G_FALSE;
347:
348: l_profile_id := p_profile_id;
349:

Line 346: l_commit := FND_API.G_FALSE;

342:
343: if (l_return_status = FND_API.G_FALSE) then
344:
345: l_return_status := FND_API.G_RET_STS_SUCCESS;
346: l_commit := FND_API.G_FALSE;
347:
348: l_profile_id := p_profile_id;
349:
350: --dbms_output.put_line('before create profile ');

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

361: x_msg_count => x_msg_count,
362: x_msg_data => x_msg_data
363: );
364:
365: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
366: RAISE FND_API.G_EXC_ERROR;
367: end if;
368: --dbms_output.put_line('aft chk profile, profileId:'||l_profile_id);
369: end if;

Line 366: RAISE FND_API.G_EXC_ERROR;

362: x_msg_data => x_msg_data
363: );
364:
365: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
366: RAISE FND_API.G_EXC_ERROR;
367: end if;
368: --dbms_output.put_line('aft chk profile, profileId:'||l_profile_id);
369: end if;
370:

Line 386: l_commit := FND_API.G_FALSE;

382: l_perz_data_id,
383: l_object_version_number);
384:
385: --dbms_output.put_line(' l_duplicate ' || l_is_duplicate);
386: l_commit := FND_API.G_FALSE;
387:
388: IF (FND_API.To_Boolean(l_is_duplicate)) THEN
389:
390: --dbms_output.put_line('stop 3');

Line 388: IF (FND_API.To_Boolean(l_is_duplicate)) THEN

384:
385: --dbms_output.put_line(' l_duplicate ' || l_is_duplicate);
386: l_commit := FND_API.G_FALSE;
387:
388: IF (FND_API.To_Boolean(l_is_duplicate)) THEN
389:
390: --dbms_output.put_line('stop 3');
391: -- Call update_perz_data
392: Update_Perz_Data

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

444: --
445: -- End of main API body.
446:
447: -- Standard check of p_commit.
448: IF (FND_API.To_Boolean(p_commit)) THEN
449: COMMIT WORK;
450: END IF;
451:
452: -- Standard call to get message count and if count is 1, get message info.

Line 458: WHEN FND_API.G_EXC_ERROR THEN

454: p_data => x_msg_data );
455:
456: EXCEPTION
457:
458: WHEN FND_API.G_EXC_ERROR THEN
459: --dbms_output.put_line('stop 4 ');
460:
461: ROLLBACK TO SAVE_PERZ_DATA_PVT;
462: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 462: x_return_status := FND_API.G_RET_STS_ERROR ;

458: WHEN FND_API.G_EXC_ERROR THEN
459: --dbms_output.put_line('stop 4 ');
460:
461: ROLLBACK TO SAVE_PERZ_DATA_PVT;
462: x_return_status := FND_API.G_RET_STS_ERROR ;
463:
464: FND_MSG_PUB.Count_And_Get
465: ( p_count => x_msg_count,
466: p_data => x_msg_data );

Line 468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

464: FND_MSG_PUB.Count_And_Get
465: ( p_count => x_msg_count,
466: p_data => x_msg_data );
467:
468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
469: --dbms_output.put_line('stop 5 ');
470: ROLLBACK TO SAVE_PERZ_DATA_PVT;
471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
472: FND_MSG_PUB.Count_And_Get

Line 471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

467:
468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
469: --dbms_output.put_line('stop 5 ');
470: ROLLBACK TO SAVE_PERZ_DATA_PVT;
471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
472: FND_MSG_PUB.Count_And_Get
473: ( p_count => x_msg_count,
474: p_data => x_msg_data );
475:

Line 480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

476:
477: WHEN OTHERS THEN
478: --dbms_output.put_line('stop 5 ');
479: ROLLBACK TO SAVE_PERZ_DATA_PVT;
480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
481:
482: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
483: THEN
484: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

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

497:
498:
499: PROCEDURE Create_Perz_Data
500: ( p_api_version_number IN NUMBER,
501: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
502: p_commit IN VARCHAR := FND_API.G_FALSE,
503:
504: p_application_id IN NUMBER,
505: p_profile_id IN NUMBER,

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

498:
499: PROCEDURE Create_Perz_Data
500: ( p_api_version_number IN NUMBER,
501: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
502: p_commit IN VARCHAR := FND_API.G_FALSE,
503:
504: p_application_id IN NUMBER,
505: p_profile_id IN NUMBER,
506: p_profile_name IN VARCHAR2,

Line 526: l_is_duplicate VARCHAR2(1) := FND_API.G_FALSE;

522:
523: -- ******* Create_Perz_Data Local Variables ********
524: l_perz_data_id NUMBER := p_perz_data_id;
525: l_PERZ_DATA_ATTRIB_ID NUMBER := NULL;
526: l_is_duplicate VARCHAR2(1) := FND_API.G_FALSE;
527: l_curr_row NUMBER := NULL;
528: l_object_version_number NUMBER := NULL;
529:
530:

Line 538: -- IF NOT FND_API.Compatible_API_Call

534: -- Standard Start of API savepoint
535: SAVEPOINT CREATE_PERZ_DATA_PVT;
536:
537: -- -- Standard call to check for call compatibility.
538: -- IF NOT FND_API.Compatible_API_Call
539: -- ( l_api_version_number,
540: -- p_api_version_number, l_api_name, G_PKG_NAME)
541: -- THEN
542: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 542: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

538: -- IF NOT FND_API.Compatible_API_Call
539: -- ( l_api_version_number,
540: -- p_api_version_number, l_api_name, G_PKG_NAME)
541: -- THEN
542: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
543: -- END IF;
544:
545: -- Initialize message list if p_init_msg_list is set to TRUE.
546: IF FND_API.to_Boolean( p_init_msg_list )

Line 546: IF FND_API.to_Boolean( p_init_msg_list )

542: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
543: -- END IF;
544:
545: -- Initialize message list if p_init_msg_list is set to TRUE.
546: IF FND_API.to_Boolean( p_init_msg_list )
547: THEN
548: FND_MSG_PUB.initialize;
549: END IF;
550:

Line 552: x_return_status := FND_API.G_RET_STS_SUCCESS;

548: FND_MSG_PUB.initialize;
549: END IF;
550:
551: -- Initialize API return status to success
552: x_return_status := FND_API.G_RET_STS_SUCCESS;
553:
554:
555: -- CALL FLOW :
556: -- 1. check if duplicate exists if TRUE, return error

Line 578: IF (FND_API.To_Boolean(l_is_duplicate)) THEN

574: l_object_version_number);
575:
576: --dbms_output.put_line(' l_duplicate ' || l_is_duplicate);
577:
578: IF (FND_API.To_Boolean(l_is_duplicate)) THEN
579: x_return_status := FND_API.G_RET_STS_ERROR ;
580: RAISE FND_API.G_EXC_ERROR;
581: END IF;
582:

Line 579: x_return_status := FND_API.G_RET_STS_ERROR ;

575:
576: --dbms_output.put_line(' l_duplicate ' || l_is_duplicate);
577:
578: IF (FND_API.To_Boolean(l_is_duplicate)) THEN
579: x_return_status := FND_API.G_RET_STS_ERROR ;
580: RAISE FND_API.G_EXC_ERROR;
581: END IF;
582:
583: insert_jtf_perz_data(

Line 580: RAISE FND_API.G_EXC_ERROR;

576: --dbms_output.put_line(' l_duplicate ' || l_is_duplicate);
577:
578: IF (FND_API.To_Boolean(l_is_duplicate)) THEN
579: x_return_status := FND_API.G_RET_STS_ERROR ;
580: RAISE FND_API.G_EXC_ERROR;
581: END IF;
582:
583: insert_jtf_perz_data(
584: l_perz_data_id,

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

622: --
623: -- End of main API body.
624:
625: -- Standard check of p_commit.
626: IF (FND_API.To_Boolean(p_commit)) THEN
627: COMMIT WORK;
628: END IF;
629:
630: -- Standard call to get message count and if count is 1, get message info.

Line 636: WHEN FND_API.G_EXC_ERROR THEN

632: p_data => x_msg_data );
633:
634: EXCEPTION
635:
636: WHEN FND_API.G_EXC_ERROR THEN
637: --dbms_output.put_line('stop 1 ');
638:
639: ROLLBACK TO CREATE_PERZ_DATA_PVT;
640: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 640: x_return_status := FND_API.G_RET_STS_ERROR ;

636: WHEN FND_API.G_EXC_ERROR THEN
637: --dbms_output.put_line('stop 1 ');
638:
639: ROLLBACK TO CREATE_PERZ_DATA_PVT;
640: x_return_status := FND_API.G_RET_STS_ERROR ;
641:
642: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
643: p_data => x_msg_data );
644:

Line 645: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

641:
642: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
643: p_data => x_msg_data );
644:
645: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
646: --dbms_output.put_line('stop 2 ');
647: ROLLBACK TO CREATE_PERZ_DATA_PVT;
648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
649:

Line 648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

644:
645: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
646: --dbms_output.put_line('stop 2 ');
647: ROLLBACK TO CREATE_PERZ_DATA_PVT;
648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
649:
650: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
651: p_data => x_msg_data );
652:

Line 656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

652:
653: WHEN OTHERS THEN
654: --dbms_output.put_line('stop 3 ');
655: ROLLBACK TO CREATE_PERZ_DATA_PVT;
656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
657:
658: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
659: THEN
660: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

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

669:
670:
671: PROCEDURE Get_Perz_Data
672: ( p_api_version_number IN NUMBER,
673: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
674:
675: p_application_id IN NUMBER,
676: p_profile_id IN NUMBER,
677: p_profile_name IN VARCHAR2,

Line 724: -- IF NOT FND_API.Compatible_API_Call

720: BEGIN
721: -- ******* Standard Begins ********
722:
723: -- -- Standard call to check for call compatibility.
724: -- IF NOT FND_API.Compatible_API_Call
725: -- ( l_api_version_number,
726: -- p_api_version_number, l_api_name, G_PKG_NAME)
727: -- THEN
728: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 728: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

724: -- IF NOT FND_API.Compatible_API_Call
725: -- ( l_api_version_number,
726: -- p_api_version_number, l_api_name, G_PKG_NAME)
727: -- THEN
728: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
729: -- END IF;
730:
731: -- Initialize message list if p_init_msg_list is set to TRUE.
732: IF FND_API.to_Boolean( p_init_msg_list )

Line 732: IF FND_API.to_Boolean( p_init_msg_list )

728: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
729: -- END IF;
730:
731: -- Initialize message list if p_init_msg_list is set to TRUE.
732: IF FND_API.to_Boolean( p_init_msg_list )
733: THEN
734: FND_MSG_PUB.initialize;
735: END IF;
736:

Line 738: x_return_status := FND_API.G_RET_STS_SUCCESS;

734: FND_MSG_PUB.initialize;
735: END IF;
736:
737: -- Initialize API return status to success
738: x_return_status := FND_API.G_RET_STS_SUCCESS;
739:
740: --1. CAll Get_Perz_Data_Summary
741: --2. If the out table has mor ethan one row rasie error
742: -- else get attributes for given perz data id.

Line 765: if ( x_return_status = FND_API.G_RET_STS_SUCCESS) then

761: );
762:
763: --dbms_output.put_line('Summary API return status:'||x_return_status );
764: --dbms_output.put_line('# Summary API returned:'||l_data_out_tbl.count );
765: if ( x_return_status = FND_API.G_RET_STS_SUCCESS) then
766:
767: l_count := l_data_out_tbl.count;
768: if ( l_count = 1) then
769: x_perz_data_id := l_data_out_tbl(l_count).perz_data_id;

Line 809: x_return_status := FND_API.G_RET_STS_SUCCESS;

805:
806: END IF;
807: END LOOP;
808: CLOSE C_Get_Perz_Data;
809: x_return_status := FND_API.G_RET_STS_SUCCESS;
810:
811: else
812: -- Currently, this API supports only One PerzData Object
813: -- If there are more than one retrieved then, this results in an error

Line 817: RAISE FND_API.G_EXC_ERROR;

813: -- If there are more than one retrieved then, this results in an error
814: -- This is a limitation because of Java Layer cannot support more than
815: -- one PerzData.
816:
817: RAISE FND_API.G_EXC_ERROR;
818: end if;
819: end if;
820:
821:

Line 829: WHEN FND_API.G_EXC_ERROR THEN

825: p_data => x_msg_data );
826:
827: EXCEPTION
828:
829: WHEN FND_API.G_EXC_ERROR THEN
830:
831: x_return_status := FND_API.G_RET_STS_ERROR ;
832:
833: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 831: x_return_status := FND_API.G_RET_STS_ERROR ;

827: EXCEPTION
828:
829: WHEN FND_API.G_EXC_ERROR THEN
830:
831: x_return_status := FND_API.G_RET_STS_ERROR ;
832:
833: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
834: p_data => x_msg_data );
835:

Line 836: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

832:
833: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
834: p_data => x_msg_data );
835:
836: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
837:
838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
839:
840: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

834: p_data => x_msg_data );
835:
836: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
837:
838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
839:
840: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
841: p_data => x_msg_data );
842:

Line 845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

841: p_data => x_msg_data );
842:
843: WHEN OTHERS THEN
844:
845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
846:
847: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
848: THEN
849: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

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

858: -- *****************************************************************************
859:
860: PROCEDURE Get_Perz_Data_Summary
861: ( p_api_version_number IN NUMBER,
862: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
863:
864: p_application_id IN NUMBER,
865: p_profile_id IN NUMBER,
866: p_profile_name IN VARCHAR2,

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

881:
882: -- ******* Get_Perz_Data_Summary Local Variables ********
883: l_profile_id NUMBER := p_profile_id;
884: l_profile_name VARCHAR2(60):= p_profile_name;
885: l_return_status VARCHAR2(240):= FND_API.G_TRUE;
886: l_count NUMBER := NULL;
887:
888: -- Temporary Variables
889: -- SMATTEGU Enhancement #1181062 Begin

Line 954: -- IF NOT FND_API.Compatible_API_Call

950: BEGIN
951: -- ******* Standard Begins ********
952:
953: -- -- Standard call to check for call compatibility.
954: -- IF NOT FND_API.Compatible_API_Call
955: -- ( l_api_version_number,
956: -- p_api_version_number, l_api_name, G_PKG_NAME)
957: -- THEN
958: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 958: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

954: -- IF NOT FND_API.Compatible_API_Call
955: -- ( l_api_version_number,
956: -- p_api_version_number, l_api_name, G_PKG_NAME)
957: -- THEN
958: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
959: -- END IF;
960:
961: -- Initialize message list if p_init_msg_list is set to TRUE.
962: IF FND_API.to_Boolean( p_init_msg_list )

Line 962: IF FND_API.to_Boolean( p_init_msg_list )

958: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
959: -- END IF;
960:
961: -- Initialize message list if p_init_msg_list is set to TRUE.
962: IF FND_API.to_Boolean( p_init_msg_list )
963: THEN
964: FND_MSG_PUB.initialize;
965: END IF;
966:

Line 968: x_return_status := FND_API.G_RET_STS_SUCCESS;

964: FND_MSG_PUB.initialize;
965: END IF;
966:
967: -- Initialize API return status to success
968: x_return_status := FND_API.G_RET_STS_SUCCESS;
969:
970:
971: if ((p_perz_data_id IS NOT NULL) AND
972: (p_perz_data_id <> FND_API.G_MISS_NUM)) then

Line 972: (p_perz_data_id <> FND_API.G_MISS_NUM)) then

968: x_return_status := FND_API.G_RET_STS_SUCCESS;
969:
970:
971: if ((p_perz_data_id IS NOT NULL) AND
972: (p_perz_data_id <> FND_API.G_MISS_NUM)) then
973: l_perz_data_temp_rec := NULL;
974: /*
975: l_perz_data_id_temp := NULL;
976: l_profile_id_temp := NULL;

Line 1006: x_return_status := FND_API.G_RET_STS_SUCCESS;

1002: l_count := l_count + 1;
1003: END IF;
1004: END LOOP;
1005: CLOSE C_Get_Perz_Summary_pzdid;
1006: x_return_status := FND_API.G_RET_STS_SUCCESS;
1007:
1008: else
1009:
1010: l_profile_id := p_profile_id;

Line 1012: l_return_status := FND_API.G_TRUE;

1008: else
1009:
1010: l_profile_id := p_profile_id;
1011: l_profile_name := p_profile_name;
1012: l_return_status := FND_API.G_TRUE;
1013:
1014: JTF_PERZ_PROFILE_PVT.check_profile_duplicates(
1015: l_profile_name,
1016: l_return_status,

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

1019:
1020:
1021: -- If profile does not exists, raise an error and exit
1022:
1023: if (l_return_status = FND_API.G_FALSE) then
1024: RAISE FND_API.G_EXC_ERROR;
1025: end if;
1026:
1027: if (((l_profile_id IS NOT NULL) AND

Line 1024: RAISE FND_API.G_EXC_ERROR;

1020:
1021: -- If profile does not exists, raise an error and exit
1022:
1023: if (l_return_status = FND_API.G_FALSE) then
1024: RAISE FND_API.G_EXC_ERROR;
1025: end if;
1026:
1027: if (((l_profile_id IS NOT NULL) AND
1028: (l_profile_id <> FND_API.G_MISS_NUM)) AND

Line 1028: (l_profile_id <> FND_API.G_MISS_NUM)) AND

1024: RAISE FND_API.G_EXC_ERROR;
1025: end if;
1026:
1027: if (((l_profile_id IS NOT NULL) AND
1028: (l_profile_id <> FND_API.G_MISS_NUM)) AND
1029: ((p_application_id IS NOT NULL) AND
1030: (p_application_id <> FND_API.G_MISS_NUM))) then
1031:
1032: if ((p_perz_data_name IS NOT NULL) AND

Line 1030: (p_application_id <> FND_API.G_MISS_NUM))) then

1026:
1027: if (((l_profile_id IS NOT NULL) AND
1028: (l_profile_id <> FND_API.G_MISS_NUM)) AND
1029: ((p_application_id IS NOT NULL) AND
1030: (p_application_id <> FND_API.G_MISS_NUM))) then
1031:
1032: if ((p_perz_data_name IS NOT NULL) AND
1033: (p_perz_data_name <> FND_API.G_MISS_CHAR)) then
1034:

Line 1033: (p_perz_data_name <> FND_API.G_MISS_CHAR)) then

1029: ((p_application_id IS NOT NULL) AND
1030: (p_application_id <> FND_API.G_MISS_NUM))) then
1031:
1032: if ((p_perz_data_name IS NOT NULL) AND
1033: (p_perz_data_name <> FND_API.G_MISS_CHAR)) then
1034:
1035: -- SMATTEGU Enhancement #1165283 BEGINS
1036:
1037: if ((p_perz_data_type IS NOT NULL) AND

Line 1038: (p_perz_data_type <> FND_API.G_MISS_CHAR)) then

1034:
1035: -- SMATTEGU Enhancement #1165283 BEGINS
1036:
1037: if ((p_perz_data_type IS NOT NULL) AND
1038: (p_perz_data_type <> FND_API.G_MISS_CHAR)) then
1039:
1040: l_perz_data_temp_rec := NULL;
1041: /*
1042: l_perz_data_id_temp := NULL;

Line 1073: x_return_status := FND_API.G_RET_STS_SUCCESS;

1069: l_count := l_count + 1;
1070: END IF;
1071: END LOOP;
1072: CLOSE C_Get_Perz_Summary_pzdnt ;
1073: x_return_status := FND_API.G_RET_STS_SUCCESS;
1074: else
1075: l_perz_data_temp_rec := NULL;
1076: /*
1077:

Line 1108: x_return_status := FND_API.G_RET_STS_SUCCESS;

1104: l_count := l_count + 1;
1105: END IF;
1106: END LOOP;
1107: CLOSE C_Get_Perz_Summary_pzdn ;
1108: x_return_status := FND_API.G_RET_STS_SUCCESS;
1109: end if;
1110:
1111: -- SMATTEGU Enhancement #1165283 ENDS
1112:

Line 1114: (p_perz_data_type <> FND_API.G_MISS_CHAR)) then

1110:
1111: -- SMATTEGU Enhancement #1165283 ENDS
1112:
1113: elsif((p_perz_data_type IS NOT NULL) AND
1114: (p_perz_data_type <> FND_API.G_MISS_CHAR)) then
1115: l_perz_data_temp_rec := NULL;
1116: /*
1117: l_perz_data_id_temp := NULL;
1118: l_perz_data_name_temp := NULL;

Line 1147: x_return_status := FND_API.G_RET_STS_SUCCESS;

1143: l_count := l_count + 1;
1144: END IF;
1145: END LOOP;
1146: CLOSE C_Get_Perz_Summary_pzdt ;
1147: x_return_status := FND_API.G_RET_STS_SUCCESS;
1148:
1149: else
1150: l_perz_data_temp_rec := NULL;
1151: /*

Line 1181: x_return_status := FND_API.G_RET_STS_SUCCESS;

1177: l_count := l_count + 1;
1178: END IF;
1179: END LOOP;
1180: CLOSE C_Get_Perz_Summary;
1181: x_return_status := FND_API.G_RET_STS_SUCCESS;
1182: end if;
1183: end if;
1184: end if;
1185:

Line 1195: WHEN FND_API.G_EXC_ERROR THEN

1191: p_data => x_msg_data );
1192:
1193: EXCEPTION
1194:
1195: WHEN FND_API.G_EXC_ERROR THEN
1196:
1197: x_return_status := FND_API.G_RET_STS_ERROR ;
1198:
1199: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 1197: x_return_status := FND_API.G_RET_STS_ERROR ;

1193: EXCEPTION
1194:
1195: WHEN FND_API.G_EXC_ERROR THEN
1196:
1197: x_return_status := FND_API.G_RET_STS_ERROR ;
1198:
1199: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1200: p_data => x_msg_data );
1201:

Line 1202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1198:
1199: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1200: p_data => x_msg_data );
1201:
1202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1203:
1204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1205:
1206: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 1204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1200: p_data => x_msg_data );
1201:
1202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1203:
1204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1205:
1206: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1207: p_data => x_msg_data );
1208:

Line 1211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1207: p_data => x_msg_data );
1208:
1209: WHEN OTHERS THEN
1210:
1211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1212:
1213: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1214: THEN
1215: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

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

1225:
1226:
1227: PROCEDURE Update_Perz_Data
1228: ( p_api_version_number IN NUMBER,
1229: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1230: p_commit IN VARCHAR := FND_API.G_FALSE,
1231:
1232: p_application_id IN NUMBER,
1233: p_profile_id IN NUMBER,

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

1226:
1227: PROCEDURE Update_Perz_Data
1228: ( p_api_version_number IN NUMBER,
1229: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1230: p_commit IN VARCHAR := FND_API.G_FALSE,
1231:
1232: p_application_id IN NUMBER,
1233: p_profile_id IN NUMBER,
1234:

Line 1255: l_is_duplicate VARCHAR2(1) := FND_API.G_FALSE;

1251:
1252: -- ******* Update_Perz_Data Local Variables ********
1253: l_perz_data_id NUMBER := p_perz_data_id;
1254: l_PERZ_DATA_ATTRIB_ID NUMBER := NULL;
1255: l_is_duplicate VARCHAR2(1) := FND_API.G_FALSE;
1256: l_curr_row NUMBER := NULL;
1257: l_object_version_number NUMBER := NULL;
1258:
1259:

Line 1267: -- IF NOT FND_API.Compatible_API_Call

1263: -- Standard Start of API savepoint
1264: SAVEPOINT UPDATE_PERZ_DATA_PVT;
1265:
1266: -- -- Standard call to check for call compatibility.
1267: -- IF NOT FND_API.Compatible_API_Call
1268: -- ( l_api_version_number,
1269: -- p_api_version_number, l_api_name, G_PKG_NAME)
1270: -- THEN
1271: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1271: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1267: -- IF NOT FND_API.Compatible_API_Call
1268: -- ( l_api_version_number,
1269: -- p_api_version_number, l_api_name, G_PKG_NAME)
1270: -- THEN
1271: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1272: -- END IF;
1273:
1274: -- Initialize message list if p_init_msg_list is set to TRUE.
1275: IF FND_API.to_Boolean( p_init_msg_list )

Line 1275: IF FND_API.to_Boolean( p_init_msg_list )

1271: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1272: -- END IF;
1273:
1274: -- Initialize message list if p_init_msg_list is set to TRUE.
1275: IF FND_API.to_Boolean( p_init_msg_list )
1276: THEN
1277: FND_MSG_PUB.initialize;
1278: END IF;
1279:

Line 1281: x_return_status := FND_API.G_RET_STS_SUCCESS;

1277: FND_MSG_PUB.initialize;
1278: END IF;
1279:
1280: -- Initialize API return status to success
1281: x_return_status := FND_API.G_RET_STS_SUCCESS;
1282:
1283:
1284: -- CALL FLOW
1285: -- 1. Select Perz Data ID from database

Line 1306: IF (FND_API.To_Boolean(l_is_duplicate)) THEN

1302: l_perz_data_id,
1303: l_object_version_number
1304: );
1305:
1306: IF (FND_API.To_Boolean(l_is_duplicate)) THEN
1307: -- 2. Delete all the attributes for that Perz Data ID
1308:
1309: DELETE FROM JTF_PERZ_DATA_ATTRIB WHERE
1310: PERZ_DATA_ID = l_perz_data_id;

Line 1340: x_return_status := FND_API.G_RET_STS_ERROR ;

1336: END LOOP;
1337: END IF;
1338: ELSE
1339: -- the perz data id does not exist
1340: x_return_status := FND_API.G_RET_STS_ERROR ;
1341: RAISE FND_API.G_EXC_ERROR;
1342: END IF;
1343:
1344:

Line 1341: RAISE FND_API.G_EXC_ERROR;

1337: END IF;
1338: ELSE
1339: -- the perz data id does not exist
1340: x_return_status := FND_API.G_RET_STS_ERROR ;
1341: RAISE FND_API.G_EXC_ERROR;
1342: END IF;
1343:
1344:
1345: -- copying ID to output.

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

1351: --
1352: -- End of main API body.
1353:
1354: -- Standard check of p_commit.
1355: IF (FND_API.To_Boolean(p_commit)) THEN
1356: COMMIT WORK;
1357: END IF;
1358:
1359: -- Standard call to get message count and if count is 1, get message info.

Line 1365: WHEN FND_API.G_EXC_ERROR THEN

1361: p_data => x_msg_data );
1362:
1363: EXCEPTION
1364:
1365: WHEN FND_API.G_EXC_ERROR THEN
1366:
1367: ROLLBACK TO UPDATE_PERZ_DATA_PVT;
1368: x_return_status := FND_API.G_RET_STS_ERROR ;
1369:

Line 1368: x_return_status := FND_API.G_RET_STS_ERROR ;

1364:
1365: WHEN FND_API.G_EXC_ERROR THEN
1366:
1367: ROLLBACK TO UPDATE_PERZ_DATA_PVT;
1368: x_return_status := FND_API.G_RET_STS_ERROR ;
1369:
1370: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1371: p_data => x_msg_data );
1372:

Line 1373: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1369:
1370: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1371: p_data => x_msg_data );
1372:
1373: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1374: ROLLBACK TO UPDATE_PERZ_DATA_PVT;
1375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1376:
1377: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 1375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1371: p_data => x_msg_data );
1372:
1373: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1374: ROLLBACK TO UPDATE_PERZ_DATA_PVT;
1375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1376:
1377: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1378: p_data => x_msg_data );
1379:

Line 1382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1378: p_data => x_msg_data );
1379:
1380: WHEN OTHERS THEN
1381: ROLLBACK TO UPDATE_PERZ_DATA_PVT;
1382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1383:
1384: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1385: THEN
1386: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

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

1394: -- *****************************************************************************
1395:
1396: PROCEDURE Delete_Perz_Data
1397: ( p_api_version_number IN NUMBER,
1398: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1399: p_commit IN VARCHAR := FND_API.G_FALSE,
1400:
1401: p_application_id IN NUMBER,
1402: p_profile_id IN NUMBER,

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

1395:
1396: PROCEDURE Delete_Perz_Data
1397: ( p_api_version_number IN NUMBER,
1398: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1399: p_commit IN VARCHAR := FND_API.G_FALSE,
1400:
1401: p_application_id IN NUMBER,
1402: p_profile_id IN NUMBER,
1403: p_perz_data_id IN NUMBER,

Line 1424: -- IF NOT FND_API.Compatible_API_Call

1420: -- Standard Start of API savepoint
1421: SAVEPOINT DELETE_PERZ_DATA_PVT;
1422:
1423: -- -- Standard call to check for call compatibility.
1424: -- IF NOT FND_API.Compatible_API_Call
1425: -- ( l_api_version_number,
1426: -- p_api_version_number, l_api_name, G_PKG_NAME)
1427: -- THEN
1428: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1428: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1424: -- IF NOT FND_API.Compatible_API_Call
1425: -- ( l_api_version_number,
1426: -- p_api_version_number, l_api_name, G_PKG_NAME)
1427: -- THEN
1428: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1429: -- END IF;
1430:
1431: -- Initialize message list if p_init_msg_list is set to TRUE.
1432: IF FND_API.to_Boolean( p_init_msg_list )

Line 1432: IF FND_API.to_Boolean( p_init_msg_list )

1428: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1429: -- END IF;
1430:
1431: -- Initialize message list if p_init_msg_list is set to TRUE.
1432: IF FND_API.to_Boolean( p_init_msg_list )
1433: THEN
1434: FND_MSG_PUB.initialize;
1435: END IF;
1436:

Line 1438: x_return_status := FND_API.G_RET_STS_SUCCESS;

1434: FND_MSG_PUB.initialize;
1435: END IF;
1436:
1437: -- Initialize API return status to success
1438: x_return_status := FND_API.G_RET_STS_SUCCESS;
1439:
1440:
1441: -- CALL FLOW
1442: --1 Delete all the attributes

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

1452: --
1453: -- End of main API body.
1454:
1455: -- Standard check of p_commit.
1456: IF (FND_API.To_Boolean(p_commit)) THEN
1457: COMMIT WORK;
1458: END IF;
1459:
1460: -- Standard call to get message count and if count is 1, get message info.

Line 1466: WHEN FND_API.G_EXC_ERROR THEN

1462: p_data => x_msg_data );
1463:
1464: EXCEPTION
1465:
1466: WHEN FND_API.G_EXC_ERROR THEN
1467:
1468: ROLLBACK TO DELETE_PERZ_DATA_PVT;
1469: x_return_status := FND_API.G_RET_STS_ERROR ;
1470:

Line 1469: x_return_status := FND_API.G_RET_STS_ERROR ;

1465:
1466: WHEN FND_API.G_EXC_ERROR THEN
1467:
1468: ROLLBACK TO DELETE_PERZ_DATA_PVT;
1469: x_return_status := FND_API.G_RET_STS_ERROR ;
1470:
1471: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1472: p_data => x_msg_data );
1473:

Line 1474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1470:
1471: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1472: p_data => x_msg_data );
1473:
1474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1475: ROLLBACK TO DELETE_PERZ_DATA_PVT;
1476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1477:
1478: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 1476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1472: p_data => x_msg_data );
1473:
1474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1475: ROLLBACK TO DELETE_PERZ_DATA_PVT;
1476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1477:
1478: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1479: p_data => x_msg_data );
1480:

Line 1483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1479: p_data => x_msg_data );
1480:
1481: WHEN OTHERS THEN
1482: ROLLBACK TO DELETE_PERZ_DATA_PVT;
1483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1484:
1485: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1486: THEN
1487: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );