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

Line 59: DECODE( p_QUERY_TYPE, Fnd_Api.G_MISS_CHAR, QUERY_TYPE, p_QUERY_TYPE),

55: BEGIN
56: UPDATE JTF_PERZ_QUERY
57: SET
58: QUERY_TYPE =
59: DECODE( p_QUERY_TYPE, Fnd_Api.G_MISS_CHAR, QUERY_TYPE, p_QUERY_TYPE),
60: QUERY_DESCRIPTION =
61: DECODE( p_QUERY_DESCRIPTION, Fnd_Api.G_MISS_CHAR, QUERY_DESCRIPTION,
62: p_QUERY_DESCRIPTION),
63: QUERY_DATA_SOURCE =

Line 61: DECODE( p_QUERY_DESCRIPTION, Fnd_Api.G_MISS_CHAR, QUERY_DESCRIPTION,

57: SET
58: QUERY_TYPE =
59: DECODE( p_QUERY_TYPE, Fnd_Api.G_MISS_CHAR, QUERY_TYPE, p_QUERY_TYPE),
60: QUERY_DESCRIPTION =
61: DECODE( p_QUERY_DESCRIPTION, Fnd_Api.G_MISS_CHAR, QUERY_DESCRIPTION,
62: p_QUERY_DESCRIPTION),
63: QUERY_DATA_SOURCE =
64: DECODE( p_QUERY_DATA_SOURCE, Fnd_Api.G_MISS_CHAR, QUERY_DATA_SOURCE,
65: p_QUERY_DATA_SOURCE),

Line 64: DECODE( p_QUERY_DATA_SOURCE, Fnd_Api.G_MISS_CHAR, QUERY_DATA_SOURCE,

60: QUERY_DESCRIPTION =
61: DECODE( p_QUERY_DESCRIPTION, Fnd_Api.G_MISS_CHAR, QUERY_DESCRIPTION,
62: p_QUERY_DESCRIPTION),
63: QUERY_DATA_SOURCE =
64: DECODE( p_QUERY_DATA_SOURCE, Fnd_Api.G_MISS_CHAR, QUERY_DATA_SOURCE,
65: p_QUERY_DATA_SOURCE),
66: OBJECT_VERSION_NUMBER =
67: DECODE (p_OBJECT_VERSION_NUMBER, Fnd_Api.G_MISS_NUM,
68: OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER+1),

Line 67: DECODE (p_OBJECT_VERSION_NUMBER, Fnd_Api.G_MISS_NUM,

63: QUERY_DATA_SOURCE =
64: DECODE( p_QUERY_DATA_SOURCE, Fnd_Api.G_MISS_CHAR, QUERY_DATA_SOURCE,
65: p_QUERY_DATA_SOURCE),
66: OBJECT_VERSION_NUMBER =
67: DECODE (p_OBJECT_VERSION_NUMBER, Fnd_Api.G_MISS_NUM,
68: OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER+1),
69: LAST_UPDATE_DATE = SYSDATE,
70: LAST_UPDATED_BY = Fnd_Global.USER_ID,
71: LAST_UPDATE_LOGIN = Fnd_Global.CONC_LOGIN_ID

Line 101: (x_QUERY_ID = Fnd_Api.G_MISS_NUM)) THEN

97: CURSOR C2 IS SELECT JTF_PERZ_QUERY_S.NEXTVAL FROM sys.dual;
98:
99: BEGIN
100: IF ((x_QUERY_ID IS NULL) OR
101: (x_QUERY_ID = Fnd_Api.G_MISS_NUM)) THEN
102: OPEN C2;
103: FETCH C2 INTO x_QUERY_ID;
104: CLOSE C2;
105: END IF;

Line 122: DECODE( x_PROFILE_ID, Fnd_Api.G_MISS_NUM, NULL ,x_PROFILE_ID ),

118: LAST_UPDATE_LOGIN
119: ) VALUES
120: (
121: x_QUERY_ID,
122: DECODE( x_PROFILE_ID, Fnd_Api.G_MISS_NUM, NULL ,x_PROFILE_ID ),
123: DECODE( x_APPLICATION_ID, Fnd_Api.G_MISS_NUM, NULL ,x_APPLICATION_ID ),
124: DECODE( x_QUERY_NAME, Fnd_Api.G_MISS_CHAR, NULL ,x_QUERY_NAME ),
125: DECODE( x_QUERY_TYPE, Fnd_Api.G_MISS_CHAR, NULL ,x_QUERY_TYPE ),
126: DECODE( x_QUERY_DESCRIPTION, Fnd_Api.G_MISS_CHAR, NULL ,x_QUERY_DESCRIPTION ),

Line 123: DECODE( x_APPLICATION_ID, Fnd_Api.G_MISS_NUM, NULL ,x_APPLICATION_ID ),

119: ) VALUES
120: (
121: x_QUERY_ID,
122: DECODE( x_PROFILE_ID, Fnd_Api.G_MISS_NUM, NULL ,x_PROFILE_ID ),
123: DECODE( x_APPLICATION_ID, Fnd_Api.G_MISS_NUM, NULL ,x_APPLICATION_ID ),
124: DECODE( x_QUERY_NAME, Fnd_Api.G_MISS_CHAR, NULL ,x_QUERY_NAME ),
125: DECODE( x_QUERY_TYPE, Fnd_Api.G_MISS_CHAR, NULL ,x_QUERY_TYPE ),
126: DECODE( x_QUERY_DESCRIPTION, Fnd_Api.G_MISS_CHAR, NULL ,x_QUERY_DESCRIPTION ),
127: DECODE( x_QUERY_DATA_SOURCE, Fnd_Api.G_MISS_CHAR, NULL ,x_QUERY_DATA_SOURCE ),

Line 124: DECODE( x_QUERY_NAME, Fnd_Api.G_MISS_CHAR, NULL ,x_QUERY_NAME ),

120: (
121: x_QUERY_ID,
122: DECODE( x_PROFILE_ID, Fnd_Api.G_MISS_NUM, NULL ,x_PROFILE_ID ),
123: DECODE( x_APPLICATION_ID, Fnd_Api.G_MISS_NUM, NULL ,x_APPLICATION_ID ),
124: DECODE( x_QUERY_NAME, Fnd_Api.G_MISS_CHAR, NULL ,x_QUERY_NAME ),
125: DECODE( x_QUERY_TYPE, Fnd_Api.G_MISS_CHAR, NULL ,x_QUERY_TYPE ),
126: DECODE( x_QUERY_DESCRIPTION, Fnd_Api.G_MISS_CHAR, NULL ,x_QUERY_DESCRIPTION ),
127: DECODE( x_QUERY_DATA_SOURCE, Fnd_Api.G_MISS_CHAR, NULL ,x_QUERY_DATA_SOURCE ),
128: 1, G_USER_ID, SYSDATE, G_USER_ID, G_LOGIN_ID);

Line 125: DECODE( x_QUERY_TYPE, Fnd_Api.G_MISS_CHAR, NULL ,x_QUERY_TYPE ),

121: x_QUERY_ID,
122: DECODE( x_PROFILE_ID, Fnd_Api.G_MISS_NUM, NULL ,x_PROFILE_ID ),
123: DECODE( x_APPLICATION_ID, Fnd_Api.G_MISS_NUM, NULL ,x_APPLICATION_ID ),
124: DECODE( x_QUERY_NAME, Fnd_Api.G_MISS_CHAR, NULL ,x_QUERY_NAME ),
125: DECODE( x_QUERY_TYPE, Fnd_Api.G_MISS_CHAR, NULL ,x_QUERY_TYPE ),
126: DECODE( x_QUERY_DESCRIPTION, Fnd_Api.G_MISS_CHAR, NULL ,x_QUERY_DESCRIPTION ),
127: DECODE( x_QUERY_DATA_SOURCE, Fnd_Api.G_MISS_CHAR, NULL ,x_QUERY_DATA_SOURCE ),
128: 1, G_USER_ID, SYSDATE, G_USER_ID, G_LOGIN_ID);
129: OPEN C;

Line 126: DECODE( x_QUERY_DESCRIPTION, Fnd_Api.G_MISS_CHAR, NULL ,x_QUERY_DESCRIPTION ),

122: DECODE( x_PROFILE_ID, Fnd_Api.G_MISS_NUM, NULL ,x_PROFILE_ID ),
123: DECODE( x_APPLICATION_ID, Fnd_Api.G_MISS_NUM, NULL ,x_APPLICATION_ID ),
124: DECODE( x_QUERY_NAME, Fnd_Api.G_MISS_CHAR, NULL ,x_QUERY_NAME ),
125: DECODE( x_QUERY_TYPE, Fnd_Api.G_MISS_CHAR, NULL ,x_QUERY_TYPE ),
126: DECODE( x_QUERY_DESCRIPTION, Fnd_Api.G_MISS_CHAR, NULL ,x_QUERY_DESCRIPTION ),
127: DECODE( x_QUERY_DATA_SOURCE, Fnd_Api.G_MISS_CHAR, NULL ,x_QUERY_DATA_SOURCE ),
128: 1, G_USER_ID, SYSDATE, G_USER_ID, G_LOGIN_ID);
129: OPEN C;
130: FETCH C INTO x_Rowid;

Line 127: DECODE( x_QUERY_DATA_SOURCE, Fnd_Api.G_MISS_CHAR, NULL ,x_QUERY_DATA_SOURCE ),

123: DECODE( x_APPLICATION_ID, Fnd_Api.G_MISS_NUM, NULL ,x_APPLICATION_ID ),
124: DECODE( x_QUERY_NAME, Fnd_Api.G_MISS_CHAR, NULL ,x_QUERY_NAME ),
125: DECODE( x_QUERY_TYPE, Fnd_Api.G_MISS_CHAR, NULL ,x_QUERY_TYPE ),
126: DECODE( x_QUERY_DESCRIPTION, Fnd_Api.G_MISS_CHAR, NULL ,x_QUERY_DESCRIPTION ),
127: DECODE( x_QUERY_DATA_SOURCE, Fnd_Api.G_MISS_CHAR, NULL ,x_QUERY_DATA_SOURCE ),
128: 1, G_USER_ID, SYSDATE, G_USER_ID, G_LOGIN_ID);
129: OPEN C;
130: FETCH C INTO x_Rowid;
131: IF (C%NOTFOUND) THEN

Line 173: DECODE( x_PARAMETER_NAME, Fnd_Api.G_MISS_CHAR, NULL ,x_PARAMETER_NAME ),

169: LAST_UPDATE_LOGIN
170: ) VALUES (
171: x_QUERY_ORDER_BY_ID,
172: x_QUERY_ID,
173: DECODE( x_PARAMETER_NAME, Fnd_Api.G_MISS_CHAR, NULL ,x_PARAMETER_NAME ),
174: DECODE( x_ACND_DCND_FLAG, Fnd_Api.G_MISS_CHAR, NULL ,x_ACND_DCND_FLAG ),
175: DECODE( x_PARAMETER_SEQUENCE, Fnd_Api.G_MISS_NUM, NULL ,x_PARAMETER_SEQUENCE ),
176: G_USER_ID, SYSDATE, G_USER_ID, G_LOGIN_ID
177: );

Line 174: DECODE( x_ACND_DCND_FLAG, Fnd_Api.G_MISS_CHAR, NULL ,x_ACND_DCND_FLAG ),

170: ) VALUES (
171: x_QUERY_ORDER_BY_ID,
172: x_QUERY_ID,
173: DECODE( x_PARAMETER_NAME, Fnd_Api.G_MISS_CHAR, NULL ,x_PARAMETER_NAME ),
174: DECODE( x_ACND_DCND_FLAG, Fnd_Api.G_MISS_CHAR, NULL ,x_ACND_DCND_FLAG ),
175: DECODE( x_PARAMETER_SEQUENCE, Fnd_Api.G_MISS_NUM, NULL ,x_PARAMETER_SEQUENCE ),
176: G_USER_ID, SYSDATE, G_USER_ID, G_LOGIN_ID
177: );
178: OPEN C;

Line 175: DECODE( x_PARAMETER_SEQUENCE, Fnd_Api.G_MISS_NUM, NULL ,x_PARAMETER_SEQUENCE ),

171: x_QUERY_ORDER_BY_ID,
172: x_QUERY_ID,
173: DECODE( x_PARAMETER_NAME, Fnd_Api.G_MISS_CHAR, NULL ,x_PARAMETER_NAME ),
174: DECODE( x_ACND_DCND_FLAG, Fnd_Api.G_MISS_CHAR, NULL ,x_ACND_DCND_FLAG ),
175: DECODE( x_PARAMETER_SEQUENCE, Fnd_Api.G_MISS_NUM, NULL ,x_PARAMETER_SEQUENCE ),
176: G_USER_ID, SYSDATE, G_USER_ID, G_LOGIN_ID
177: );
178: OPEN C;
179: FETCH C INTO x_Rowid;

Line 207: (X_Query_Raw_Sql_ID = Fnd_Api.G_MISS_NUM ))THEN

203: CURSOR C2 IS SELECT JTF_PERZ_QUERY_RAW_SQL_s.NEXTVAL FROM sys.dual;
204:
205: BEGIN
206: IF ((X_Query_Raw_Sql_ID IS NULL) OR
207: (X_Query_Raw_Sql_ID = Fnd_Api.G_MISS_NUM ))THEN
208: OPEN C2;
209: FETCH C2 INTO X_Query_Raw_Sql_ID;
210: CLOSE C2;
211: END IF;

Line 228: DECODE( x_SELECT_STRING, Fnd_Api.G_MISS_CHAR, NULL ,x_SELECT_STRING ),

224: LAST_UPDATE_LOGIN
225: ) VALUES (
226: x_QUERY_RAW_SQL_ID,
227: x_QUERY_ID,
228: DECODE( x_SELECT_STRING, Fnd_Api.G_MISS_CHAR, NULL ,x_SELECT_STRING ),
229: DECODE( x_FROM_STRING, Fnd_Api.G_MISS_CHAR, NULL ,x_FROM_STRING ),
230: DECODE( x_WHERE_STRING, Fnd_Api.G_MISS_CHAR, NULL ,x_WHERE_STRING ),
231: DECODE( x_ORDER_BY_STRING, Fnd_Api.G_MISS_CHAR, NULL ,x_ORDER_BY_STRING ),
232: DECODE( x_GROUP_BY_STRING, Fnd_Api.G_MISS_CHAR, NULL ,x_GROUP_BY_STRING ),

Line 229: DECODE( x_FROM_STRING, Fnd_Api.G_MISS_CHAR, NULL ,x_FROM_STRING ),

225: ) VALUES (
226: x_QUERY_RAW_SQL_ID,
227: x_QUERY_ID,
228: DECODE( x_SELECT_STRING, Fnd_Api.G_MISS_CHAR, NULL ,x_SELECT_STRING ),
229: DECODE( x_FROM_STRING, Fnd_Api.G_MISS_CHAR, NULL ,x_FROM_STRING ),
230: DECODE( x_WHERE_STRING, Fnd_Api.G_MISS_CHAR, NULL ,x_WHERE_STRING ),
231: DECODE( x_ORDER_BY_STRING, Fnd_Api.G_MISS_CHAR, NULL ,x_ORDER_BY_STRING ),
232: DECODE( x_GROUP_BY_STRING, Fnd_Api.G_MISS_CHAR, NULL ,x_GROUP_BY_STRING ),
233: DECODE( x_HAVING_STRING, Fnd_Api.G_MISS_CHAR, NULL ,x_HAVING_STRING ),

Line 230: DECODE( x_WHERE_STRING, Fnd_Api.G_MISS_CHAR, NULL ,x_WHERE_STRING ),

226: x_QUERY_RAW_SQL_ID,
227: x_QUERY_ID,
228: DECODE( x_SELECT_STRING, Fnd_Api.G_MISS_CHAR, NULL ,x_SELECT_STRING ),
229: DECODE( x_FROM_STRING, Fnd_Api.G_MISS_CHAR, NULL ,x_FROM_STRING ),
230: DECODE( x_WHERE_STRING, Fnd_Api.G_MISS_CHAR, NULL ,x_WHERE_STRING ),
231: DECODE( x_ORDER_BY_STRING, Fnd_Api.G_MISS_CHAR, NULL ,x_ORDER_BY_STRING ),
232: DECODE( x_GROUP_BY_STRING, Fnd_Api.G_MISS_CHAR, NULL ,x_GROUP_BY_STRING ),
233: DECODE( x_HAVING_STRING, Fnd_Api.G_MISS_CHAR, NULL ,x_HAVING_STRING ),
234: G_USER_ID, SYSDATE, G_USER_ID, G_LOGIN_ID

Line 231: DECODE( x_ORDER_BY_STRING, Fnd_Api.G_MISS_CHAR, NULL ,x_ORDER_BY_STRING ),

227: x_QUERY_ID,
228: DECODE( x_SELECT_STRING, Fnd_Api.G_MISS_CHAR, NULL ,x_SELECT_STRING ),
229: DECODE( x_FROM_STRING, Fnd_Api.G_MISS_CHAR, NULL ,x_FROM_STRING ),
230: DECODE( x_WHERE_STRING, Fnd_Api.G_MISS_CHAR, NULL ,x_WHERE_STRING ),
231: DECODE( x_ORDER_BY_STRING, Fnd_Api.G_MISS_CHAR, NULL ,x_ORDER_BY_STRING ),
232: DECODE( x_GROUP_BY_STRING, Fnd_Api.G_MISS_CHAR, NULL ,x_GROUP_BY_STRING ),
233: DECODE( x_HAVING_STRING, Fnd_Api.G_MISS_CHAR, NULL ,x_HAVING_STRING ),
234: G_USER_ID, SYSDATE, G_USER_ID, G_LOGIN_ID
235: );

Line 232: DECODE( x_GROUP_BY_STRING, Fnd_Api.G_MISS_CHAR, NULL ,x_GROUP_BY_STRING ),

228: DECODE( x_SELECT_STRING, Fnd_Api.G_MISS_CHAR, NULL ,x_SELECT_STRING ),
229: DECODE( x_FROM_STRING, Fnd_Api.G_MISS_CHAR, NULL ,x_FROM_STRING ),
230: DECODE( x_WHERE_STRING, Fnd_Api.G_MISS_CHAR, NULL ,x_WHERE_STRING ),
231: DECODE( x_ORDER_BY_STRING, Fnd_Api.G_MISS_CHAR, NULL ,x_ORDER_BY_STRING ),
232: DECODE( x_GROUP_BY_STRING, Fnd_Api.G_MISS_CHAR, NULL ,x_GROUP_BY_STRING ),
233: DECODE( x_HAVING_STRING, Fnd_Api.G_MISS_CHAR, NULL ,x_HAVING_STRING ),
234: G_USER_ID, SYSDATE, G_USER_ID, G_LOGIN_ID
235: );
236: OPEN C;

Line 233: DECODE( x_HAVING_STRING, Fnd_Api.G_MISS_CHAR, NULL ,x_HAVING_STRING ),

229: DECODE( x_FROM_STRING, Fnd_Api.G_MISS_CHAR, NULL ,x_FROM_STRING ),
230: DECODE( x_WHERE_STRING, Fnd_Api.G_MISS_CHAR, NULL ,x_WHERE_STRING ),
231: DECODE( x_ORDER_BY_STRING, Fnd_Api.G_MISS_CHAR, NULL ,x_ORDER_BY_STRING ),
232: DECODE( x_GROUP_BY_STRING, Fnd_Api.G_MISS_CHAR, NULL ,x_GROUP_BY_STRING ),
233: DECODE( x_HAVING_STRING, Fnd_Api.G_MISS_CHAR, NULL ,x_HAVING_STRING ),
234: G_USER_ID, SYSDATE, G_USER_ID, G_LOGIN_ID
235: );
236: OPEN C;
237: FETCH C INTO x_Rowid;

Line 260: (X_query_param_id = Fnd_Api.G_MISS_NUM)) THEN

256: WHERE query_param_id = X_query_param_id;
257: CURSOR C2 IS SELECT JTF_PERZ_QUERY_PARAM_s.NEXTVAL FROM sys.dual;
258: BEGIN
259: IF ((X_query_param_id IS NULL) OR
260: (X_query_param_id = Fnd_Api.G_MISS_NUM)) THEN
261: OPEN C2;
262: FETCH C2 INTO X_query_param_id;
263: CLOSE C2;
264: END IF;

Line 280: DECODE( x_PARAMETER_NAME, Fnd_Api.G_MISS_CHAR, NULL ,x_PARAMETER_NAME ),

276: LAST_UPDATE_LOGIN
277: ) VALUES (
278: x_QUERY_PARAM_ID,
279: x_QUERY_ID,
280: DECODE( x_PARAMETER_NAME, Fnd_Api.G_MISS_CHAR, NULL ,x_PARAMETER_NAME ),
281: DECODE( x_PARAMETER_TYPE, Fnd_Api.G_MISS_CHAR, NULL ,x_PARAMETER_TYPE ),
282: DECODE( x_PARAMETER_VALUE, Fnd_Api.G_MISS_CHAR, NULL ,x_PARAMETER_VALUE ),
283: DECODE( x_PARAMETER_CONDITION, Fnd_Api.G_MISS_CHAR, NULL ,x_PARAMETER_CONDITION ),
284: DECODE( x_PARAMETER_SEQUENCE, Fnd_Api.G_MISS_CHAR, NULL ,x_PARAMETER_SEQUENCE ),

Line 281: DECODE( x_PARAMETER_TYPE, Fnd_Api.G_MISS_CHAR, NULL ,x_PARAMETER_TYPE ),

277: ) VALUES (
278: x_QUERY_PARAM_ID,
279: x_QUERY_ID,
280: DECODE( x_PARAMETER_NAME, Fnd_Api.G_MISS_CHAR, NULL ,x_PARAMETER_NAME ),
281: DECODE( x_PARAMETER_TYPE, Fnd_Api.G_MISS_CHAR, NULL ,x_PARAMETER_TYPE ),
282: DECODE( x_PARAMETER_VALUE, Fnd_Api.G_MISS_CHAR, NULL ,x_PARAMETER_VALUE ),
283: DECODE( x_PARAMETER_CONDITION, Fnd_Api.G_MISS_CHAR, NULL ,x_PARAMETER_CONDITION ),
284: DECODE( x_PARAMETER_SEQUENCE, Fnd_Api.G_MISS_CHAR, NULL ,x_PARAMETER_SEQUENCE ),
285: G_USER_ID, SYSDATE, G_USER_ID, G_LOGIN_ID

Line 282: DECODE( x_PARAMETER_VALUE, Fnd_Api.G_MISS_CHAR, NULL ,x_PARAMETER_VALUE ),

278: x_QUERY_PARAM_ID,
279: x_QUERY_ID,
280: DECODE( x_PARAMETER_NAME, Fnd_Api.G_MISS_CHAR, NULL ,x_PARAMETER_NAME ),
281: DECODE( x_PARAMETER_TYPE, Fnd_Api.G_MISS_CHAR, NULL ,x_PARAMETER_TYPE ),
282: DECODE( x_PARAMETER_VALUE, Fnd_Api.G_MISS_CHAR, NULL ,x_PARAMETER_VALUE ),
283: DECODE( x_PARAMETER_CONDITION, Fnd_Api.G_MISS_CHAR, NULL ,x_PARAMETER_CONDITION ),
284: DECODE( x_PARAMETER_SEQUENCE, Fnd_Api.G_MISS_CHAR, NULL ,x_PARAMETER_SEQUENCE ),
285: G_USER_ID, SYSDATE, G_USER_ID, G_LOGIN_ID
286: );

Line 283: DECODE( x_PARAMETER_CONDITION, Fnd_Api.G_MISS_CHAR, NULL ,x_PARAMETER_CONDITION ),

279: x_QUERY_ID,
280: DECODE( x_PARAMETER_NAME, Fnd_Api.G_MISS_CHAR, NULL ,x_PARAMETER_NAME ),
281: DECODE( x_PARAMETER_TYPE, Fnd_Api.G_MISS_CHAR, NULL ,x_PARAMETER_TYPE ),
282: DECODE( x_PARAMETER_VALUE, Fnd_Api.G_MISS_CHAR, NULL ,x_PARAMETER_VALUE ),
283: DECODE( x_PARAMETER_CONDITION, Fnd_Api.G_MISS_CHAR, NULL ,x_PARAMETER_CONDITION ),
284: DECODE( x_PARAMETER_SEQUENCE, Fnd_Api.G_MISS_CHAR, NULL ,x_PARAMETER_SEQUENCE ),
285: G_USER_ID, SYSDATE, G_USER_ID, G_LOGIN_ID
286: );
287: OPEN C;

Line 284: DECODE( x_PARAMETER_SEQUENCE, Fnd_Api.G_MISS_CHAR, NULL ,x_PARAMETER_SEQUENCE ),

280: DECODE( x_PARAMETER_NAME, Fnd_Api.G_MISS_CHAR, NULL ,x_PARAMETER_NAME ),
281: DECODE( x_PARAMETER_TYPE, Fnd_Api.G_MISS_CHAR, NULL ,x_PARAMETER_TYPE ),
282: DECODE( x_PARAMETER_VALUE, Fnd_Api.G_MISS_CHAR, NULL ,x_PARAMETER_VALUE ),
283: DECODE( x_PARAMETER_CONDITION, Fnd_Api.G_MISS_CHAR, NULL ,x_PARAMETER_CONDITION ),
284: DECODE( x_PARAMETER_SEQUENCE, Fnd_Api.G_MISS_CHAR, NULL ,x_PARAMETER_SEQUENCE ),
285: G_USER_ID, SYSDATE, G_USER_ID, G_LOGIN_ID
286: );
287: OPEN C;
288: FETCH C INTO x_Rowid;

Line 328: IF ( ((p_query_name IS NOT NULL) AND (p_query_name <> Fnd_Api.G_MISS_CHAR)) AND

324: l_temp_id NUMBER := NULL;
325:
326: BEGIN
327:
328: IF ( ((p_query_name IS NOT NULL) AND (p_query_name <> Fnd_Api.G_MISS_CHAR)) AND
329: ((p_query_type IS NOT NULL) AND (p_query_type <> Fnd_Api.G_MISS_CHAR)) ) THEN
330:
331: --IF (p_query_name IS NOT NULL) then
332:

Line 329: ((p_query_type IS NOT NULL) AND (p_query_type <> Fnd_Api.G_MISS_CHAR)) ) THEN

325:
326: BEGIN
327:
328: IF ( ((p_query_name IS NOT NULL) AND (p_query_name <> Fnd_Api.G_MISS_CHAR)) AND
329: ((p_query_type IS NOT NULL) AND (p_query_type <> Fnd_Api.G_MISS_CHAR)) ) THEN
330:
331: --IF (p_query_name IS NOT NULL) then
332:
333: SELECT query_id, object_version_number

Line 342: x_return_status := Fnd_Api.G_TRUE;

338: application_id = p_application_id AND
339: profile_id = p_profile_id;
340:
341: IF (x_query_id IS NOT NULL) THEN
342: x_return_status := Fnd_Api.G_TRUE;
343: ELSE
344: x_return_status := Fnd_Api.G_FALSE;
345: END IF;
346:

Line 344: x_return_status := Fnd_Api.G_FALSE;

340:
341: IF (x_query_id IS NOT NULL) THEN
342: x_return_status := Fnd_Api.G_TRUE;
343: ELSE
344: x_return_status := Fnd_Api.G_FALSE;
345: END IF;
346:
347:
348: -- ELSIF (((p_query_name IS NOT NULL) OR

Line 349: -- (p_query_name <> Fnd_Api.G_MISS_CHAR)) AND

345: END IF;
346:
347:
348: -- ELSIF (((p_query_name IS NOT NULL) OR
349: -- (p_query_name <> Fnd_Api.G_MISS_CHAR)) AND
350: -- ((x_query_id IS NULL) OR
351: -- (x_query_id = Fnd_Api.G_MISS_NUM)))THEN
352: --
353: -- SELECT query_id, object_version_number

Line 351: -- (x_query_id = Fnd_Api.G_MISS_NUM)))THEN

347:
348: -- ELSIF (((p_query_name IS NOT NULL) OR
349: -- (p_query_name <> Fnd_Api.G_MISS_CHAR)) AND
350: -- ((x_query_id IS NULL) OR
351: -- (x_query_id = Fnd_Api.G_MISS_NUM)))THEN
352: --
353: -- SELECT query_id, object_version_number
354: -- INTO x_query_id , x_object_version_number
355: -- FROM JTF_PERZ_QUERY

Line 361: -- x_return_status := Fnd_Api.G_TRUE;

357: -- application_id = p_application_id AND
358: -- profile_id = p_profile_id;
359: --
360: -- IF (x_query_id IS NOT NULL) THEN
361: -- x_return_status := Fnd_Api.G_TRUE;
362: -- ELSE
363: -- x_return_status := Fnd_Api.G_FALSE;
364: -- END IF;
365: --

Line 363: -- x_return_status := Fnd_Api.G_FALSE;

359: --
360: -- IF (x_query_id IS NOT NULL) THEN
361: -- x_return_status := Fnd_Api.G_TRUE;
362: -- ELSE
363: -- x_return_status := Fnd_Api.G_FALSE;
364: -- END IF;
365: --
366: -- ELSIF (((x_query_id IS NOT NULL) OR (x_query_id <> Fnd_Api.G_MISS_NUM)) AND
367: -- ((p_query_name IS NULL) OR (p_query_name = Fnd_Api.G_MISS_CHAR))) THEN

Line 366: -- ELSIF (((x_query_id IS NOT NULL) OR (x_query_id <> Fnd_Api.G_MISS_NUM)) AND

362: -- ELSE
363: -- x_return_status := Fnd_Api.G_FALSE;
364: -- END IF;
365: --
366: -- ELSIF (((x_query_id IS NOT NULL) OR (x_query_id <> Fnd_Api.G_MISS_NUM)) AND
367: -- ((p_query_name IS NULL) OR (p_query_name = Fnd_Api.G_MISS_CHAR))) THEN
368: --
369: -- SELECT Query_id, object_version_number
370: -- INTO l_temp_id , x_object_version_number

Line 367: -- ((p_query_name IS NULL) OR (p_query_name = Fnd_Api.G_MISS_CHAR))) THEN

363: -- x_return_status := Fnd_Api.G_FALSE;
364: -- END IF;
365: --
366: -- ELSIF (((x_query_id IS NOT NULL) OR (x_query_id <> Fnd_Api.G_MISS_NUM)) AND
367: -- ((p_query_name IS NULL) OR (p_query_name = Fnd_Api.G_MISS_CHAR))) THEN
368: --
369: -- SELECT Query_id, object_version_number
370: -- INTO l_temp_id , x_object_version_number
371: -- FROM JTF_PERZ_QUERY

Line 375: -- x_return_status := Fnd_Api.G_TRUE;

371: -- FROM JTF_PERZ_QUERY
372: -- WHERE query_id = x_query_id;
373: --
374: -- IF (l_temp_id IS NOT NULL) THEN
375: -- x_return_status := Fnd_Api.G_TRUE;
376: -- x_query_id := l_temp_id;
377: -- ELSE
378: -- x_return_status := Fnd_Api.G_FALSE;
379: -- END IF;

Line 378: -- x_return_status := Fnd_Api.G_FALSE;

374: -- IF (l_temp_id IS NOT NULL) THEN
375: -- x_return_status := Fnd_Api.G_TRUE;
376: -- x_query_id := l_temp_id;
377: -- ELSE
378: -- x_return_status := Fnd_Api.G_FALSE;
379: -- END IF;
380: --
381: -- ELSIF (((p_query_name IS NOT NULL) OR (p_query_name <> Fnd_Api.G_MISS_CHAR)) AND
382: -- ((x_query_id IS NOT NULL) OR (x_query_id <> Fnd_Api.G_MISS_NUM))) THEN

Line 381: -- ELSIF (((p_query_name IS NOT NULL) OR (p_query_name <> Fnd_Api.G_MISS_CHAR)) AND

377: -- ELSE
378: -- x_return_status := Fnd_Api.G_FALSE;
379: -- END IF;
380: --
381: -- ELSIF (((p_query_name IS NOT NULL) OR (p_query_name <> Fnd_Api.G_MISS_CHAR)) AND
382: -- ((x_query_id IS NOT NULL) OR (x_query_id <> Fnd_Api.G_MISS_NUM))) THEN
383: --
384: -- SELECT Query_id, object_version_number
385: -- INTO l_temp_id , x_object_version_number

Line 382: -- ((x_query_id IS NOT NULL) OR (x_query_id <> Fnd_Api.G_MISS_NUM))) THEN

378: -- x_return_status := Fnd_Api.G_FALSE;
379: -- END IF;
380: --
381: -- ELSIF (((p_query_name IS NOT NULL) OR (p_query_name <> Fnd_Api.G_MISS_CHAR)) AND
382: -- ((x_query_id IS NOT NULL) OR (x_query_id <> Fnd_Api.G_MISS_NUM))) THEN
383: --
384: -- SELECT Query_id, object_version_number
385: -- INTO l_temp_id , x_object_version_number
386: -- FROM JTF_PERZ_QUERY

Line 390: -- x_return_status := Fnd_Api.G_TRUE;

386: -- FROM JTF_PERZ_QUERY
387: -- WHERE query_id = x_query_id;
388: --
389: -- IF (l_temp_id IS NOT NULL) THEN
390: -- x_return_status := Fnd_Api.G_TRUE;
391: -- x_query_id := l_temp_id;
392: -- ELSE
393: -- x_return_status := Fnd_Api.G_FALSE;
394: -- END IF;

Line 393: -- x_return_status := Fnd_Api.G_FALSE;

389: -- IF (l_temp_id IS NOT NULL) THEN
390: -- x_return_status := Fnd_Api.G_TRUE;
391: -- x_query_id := l_temp_id;
392: -- ELSE
393: -- x_return_status := Fnd_Api.G_FALSE;
394: -- END IF;
395:
396: ELSE
397: x_return_status := Fnd_Api.G_FALSE;

Line 397: x_return_status := Fnd_Api.G_FALSE;

393: -- x_return_status := Fnd_Api.G_FALSE;
394: -- END IF;
395:
396: ELSE
397: x_return_status := Fnd_Api.G_FALSE;
398:
399: END IF;
400:
401: EXCEPTION

Line 403: x_return_status := Fnd_Api.G_FALSE;

399: END IF;
400:
401: EXCEPTION
402: WHEN NO_DATA_FOUND THEN
403: x_return_status := Fnd_Api.G_FALSE;
404: WHEN OTHERS THEN
405: x_return_status := Fnd_Api.G_FALSE;
406: END check_query_duplicates;
407:

Line 405: x_return_status := Fnd_Api.G_FALSE;

401: EXCEPTION
402: WHEN NO_DATA_FOUND THEN
403: x_return_status := Fnd_Api.G_FALSE;
404: WHEN OTHERS THEN
405: x_return_status := Fnd_Api.G_FALSE;
406: END check_query_duplicates;
407:
408: -- ****************************************************************************
409: --******************************************************************************

Line 413: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,

409: --******************************************************************************
410:
411: PROCEDURE Create_Perz_Query
412: ( p_api_version_number IN NUMBER,
413: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
414: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
415:
416: p_application_id IN NUMBER,
417: p_profile_id IN NUMBER,

Line 414: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,

410:
411: PROCEDURE Create_Perz_Query
412: ( p_api_version_number IN NUMBER,
413: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
414: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
415:
416: p_application_id IN NUMBER,
417: p_profile_id IN NUMBER,
418: p_profile_name IN VARCHAR2,

Line 444: l_return_status VARCHAR2(240) := Fnd_Api.G_RET_STS_SUCCESS;

440:
441: l_any_errors BOOLEAN := FALSE;
442: l_any_row_errors BOOLEAN := FALSE;
443: l_rowid ROWID;
444: l_return_status VARCHAR2(240) := Fnd_Api.G_RET_STS_SUCCESS;
445: l_api_name CONSTANT VARCHAR2(30) := 'Create Perz Query';
446: l_curr_row NUMBER := NULL;
447: l_query_name VARCHAR2(60) := p_query_name;
448:

Line 458: l_is_duplicate VARCHAR2(1) := Fnd_Api.G_FALSE;

454: l_query_order_by_id NUMBER;
455: l_query_param_id NUMBER;
456: l_Query_Raw_Sql_ID NUMBER;
457: l_profile_attrib_id NUMBER;
458: l_is_duplicate VARCHAR2(1) := Fnd_Api.G_FALSE;
459: l_object_version_number NUMBER :=NULL;
460:
461: BEGIN
462: -- ******* Standard Begins ********

Line 468: -- IF NOT FND_API.Compatible_API_Call (

464: -- Standard Start of API savepoint
465: SAVEPOINT CREATE_PERZ_QUERY_PVT;
466:
467: -- -- Standard call to check for call compatibility.
468: -- IF NOT FND_API.Compatible_API_Call (
469: -- l_api_version_number,
470: -- p_api_version_number,
471: -- l_api_name,
472: -- G_PKG_NAME)

Line 474: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

470: -- p_api_version_number,
471: -- l_api_name,
472: -- G_PKG_NAME)
473: -- THEN
474: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
475: -- END IF;
476:
477: -- Initialize message list if p_init_msg_list is set to TRUE.
478: IF Fnd_Api.to_Boolean( p_init_msg_list )

Line 478: IF Fnd_Api.to_Boolean( p_init_msg_list )

474: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
475: -- END IF;
476:
477: -- Initialize message list if p_init_msg_list is set to TRUE.
478: IF Fnd_Api.to_Boolean( p_init_msg_list )
479: THEN
480: Fnd_Msg_Pub.initialize;
481: END IF;
482:

Line 484: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

480: Fnd_Msg_Pub.initialize;
481: END IF;
482:
483: -- Initialize API return status to success
484: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
485:
486:
487: -- CALL FLOW :
488: -- 1. check if duplicate exists if TRUE, return error

Line 510: IF (Fnd_Api.To_Boolean(l_is_duplicate)) THEN

506: l_query_id,
507: l_object_version_number
508: );
509:
510: IF (Fnd_Api.To_Boolean(l_is_duplicate)) THEN
511: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
512: RAISE Fnd_Api.G_EXC_ERROR;
513: END IF;
514:

Line 511: x_return_status := Fnd_Api.G_RET_STS_ERROR ;

507: l_object_version_number
508: );
509:
510: IF (Fnd_Api.To_Boolean(l_is_duplicate)) THEN
511: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
512: RAISE Fnd_Api.G_EXC_ERROR;
513: END IF;
514:
515: -- 3. insert row with query data into query table

Line 512: RAISE Fnd_Api.G_EXC_ERROR;

508: );
509:
510: IF (Fnd_Api.To_Boolean(l_is_duplicate)) THEN
511: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
512: RAISE Fnd_Api.G_EXC_ERROR;
513: END IF;
514:
515: -- 3. insert row with query data into query table
516:

Line 602: IF (Fnd_Api.To_Boolean(p_commit)) THEN

598: --
599: -- End of main API body.
600:
601: -- Standard check of p_commit.
602: IF (Fnd_Api.To_Boolean(p_commit)) THEN
603: COMMIT WORK;
604: END IF;
605:
606: -- Standard call to get message count and if count is 1, get message info.

Line 612: WHEN Fnd_Api.G_EXC_ERROR THEN

608: p_count => x_msg_count,
609: p_data => x_msg_data );
610:
611: EXCEPTION
612: WHEN Fnd_Api.G_EXC_ERROR THEN
613: ROLLBACK TO CREATE_PERZ_QUERY_PVT;
614: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
615:
616: Fnd_Msg_Pub.Count_And_Get(

Line 614: x_return_status := Fnd_Api.G_RET_STS_ERROR ;

610:
611: EXCEPTION
612: WHEN Fnd_Api.G_EXC_ERROR THEN
613: ROLLBACK TO CREATE_PERZ_QUERY_PVT;
614: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
615:
616: Fnd_Msg_Pub.Count_And_Get(
617: p_count => x_msg_count,
618: p_data => x_msg_data );

Line 620: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

616: Fnd_Msg_Pub.Count_And_Get(
617: p_count => x_msg_count,
618: p_data => x_msg_data );
619:
620: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
621: ROLLBACK TO CREATE_PERZ_QUERY_PVT;
622: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
623: --x_return_status := SQLCODE||SUBSTR(SQLERRM,1,100);
624:

Line 622: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;

618: p_data => x_msg_data );
619:
620: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
621: ROLLBACK TO CREATE_PERZ_QUERY_PVT;
622: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
623: --x_return_status := SQLCODE||SUBSTR(SQLERRM,1,100);
624:
625: Fnd_Msg_Pub.Count_And_Get(
626: p_count => x_msg_count,

Line 631: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;

627: p_data => x_msg_data );
628:
629: WHEN OTHERS THEN
630: ROLLBACK TO CREATE_PERZ_QUERY_PVT;
631: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
632:
633: --x_return_status := SQLCODE||SUBSTR(SQLERRM,1,100);
634: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
635: THEN

Line 648: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,

644:
645: --******************************************************************************
646: PROCEDURE Update_Perz_Query
647: ( p_api_version_number IN NUMBER,
648: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
649: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
650:
651: p_application_id IN NUMBER,
652: p_profile_id IN NUMBER,

Line 649: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,

645: --******************************************************************************
646: PROCEDURE Update_Perz_Query
647: ( p_api_version_number IN NUMBER,
648: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
649: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
650:
651: p_application_id IN NUMBER,
652: p_profile_id IN NUMBER,
653:

Line 681: l_return_status VARCHAR2(240) := Fnd_Api.G_RET_STS_SUCCESS;

677: l_any_errors BOOLEAN := FALSE;
678: l_any_row_errors BOOLEAN := FALSE;
679: l_found_flag BOOLEAN := FALSE;
680: l_rowid ROWID;
681: l_return_status VARCHAR2(240) := Fnd_Api.G_RET_STS_SUCCESS;
682: l_api_name CONSTANT VARCHAR2(30) := 'Update Perz Query';
683:
684: l_count NUMBER := NULL;
685: l_msg_count NUMBER := NULL;

Line 690: l_duplicate VARCHAR2(240) := Fnd_Api.G_FALSE;

686: l_msg_data VARCHAR2(200) := NULL;
687: l_count_1 NUMBER := NULL;
688: l_curr_row NUMBER := NULL;
689:
690: l_duplicate VARCHAR2(240) := Fnd_Api.G_FALSE;
691: l_query_name VARCHAR2(60) := p_query_name;
692:
693: -- Variables for ids
694: l_query_string VARCHAR2(1) := NULL;

Line 702: l_is_duplicate VARCHAR2(1) := Fnd_Api.G_FALSE;

698: l_Query_Order_By_ID NUMBER;
699: l_query_param_id NUMBER;
700: l_Query_Raw_Sql_ID NUMBER;
701: l_profile_attrib_id NUMBER;
702: l_is_duplicate VARCHAR2(1) := Fnd_Api.G_FALSE;
703: l_profile_name VARCHAR2(30) := NULL;
704: l_object_version_number NUMBER :=NULL;
705:
706: BEGIN

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

708: -- Standard Start of API savepoint
709: SAVEPOINT UPDATE_PERZ_QUERY_PVT;
710:
711: -- -- Standard call to check for call compatibility.
712: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
713: -- THEN
714: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
715: -- END IF;
716:

Line 714: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

710:
711: -- -- Standard call to check for call compatibility.
712: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
713: -- THEN
714: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
715: -- END IF;
716:
717: -- Initialize message list if p_init_msg_list is set to TRUE.
718: IF Fnd_Api.to_Boolean( p_init_msg_list )

Line 718: IF Fnd_Api.to_Boolean( p_init_msg_list )

714: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
715: -- END IF;
716:
717: -- Initialize message list if p_init_msg_list is set to TRUE.
718: IF Fnd_Api.to_Boolean( p_init_msg_list )
719: THEN
720: Fnd_Msg_Pub.initialize;
721: END IF;
722:

Line 724: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

720: Fnd_Msg_Pub.initialize;
721: END IF;
722:
723: -- Initialize API return status to success
724: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
725:
726:
727: -- CALL FLOW
728: -- 1. Select query ID from databe

Line 749: IF (Fnd_Api.To_Boolean(l_is_duplicate)) THEN

745: l_query_id,
746: l_object_version_number);
747:
748:
749: IF (Fnd_Api.To_Boolean(l_is_duplicate)) THEN
750:
751: -- 2. Delete all parmeter table entries for this query_id
752:
753: DELETE FROM JTF_PERZ_QUERY_PARAM WHERE QUERY_ID = l_query_id;

Line 826: x_return_status := Fnd_Api.G_RET_STS_ERROR ;

822: END IF;
823: x_query_id := l_query_id;
824:
825: ELSE
826: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
827: RAISE Fnd_Api.G_EXC_ERROR;
828: END IF;
829:
830: EXCEPTION

Line 827: RAISE Fnd_Api.G_EXC_ERROR;

823: x_query_id := l_query_id;
824:
825: ELSE
826: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
827: RAISE Fnd_Api.G_EXC_ERROR;
828: END IF;
829:
830: EXCEPTION
831:

Line 832: WHEN Fnd_Api.G_EXC_ERROR THEN

828: END IF;
829:
830: EXCEPTION
831:
832: WHEN Fnd_Api.G_EXC_ERROR THEN
833: -- dbms_output.put_line('stop 1 ');
834:
835: ROLLBACK TO UPDATE_PERZ_QUERY_PVT;
836: --x_return_status := FND_API.G_RET_STS_ERROR ;

Line 836: --x_return_status := FND_API.G_RET_STS_ERROR ;

832: WHEN Fnd_Api.G_EXC_ERROR THEN
833: -- dbms_output.put_line('stop 1 ');
834:
835: ROLLBACK TO UPDATE_PERZ_QUERY_PVT;
836: --x_return_status := FND_API.G_RET_STS_ERROR ;
837: x_return_status := SQLCODE||SUBSTR(SQLERRM,1,100);
838:
839: Fnd_Msg_Pub.Count_And_Get(
840: p_count => x_msg_count,

Line 843: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

839: Fnd_Msg_Pub.Count_And_Get(
840: p_count => x_msg_count,
841: p_data => x_msg_data );
842:
843: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
844: -- dbms_output.put_line('stop 2 ');
845: ROLLBACK TO UPDATE_PERZ_QUERY_PVT;
846: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
847:

Line 846: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;

842:
843: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
844: -- dbms_output.put_line('stop 2 ');
845: ROLLBACK TO UPDATE_PERZ_QUERY_PVT;
846: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
847:
848: Fnd_Msg_Pub.Count_And_Get(
849: p_count => x_msg_count,
850: p_data => x_msg_data );

Line 855: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;

851:
852: WHEN OTHERS THEN
853: -- dbms_output.put_line('stop 3 ');
854: ROLLBACK TO UPDATE_PERZ_QUERY_PVT;
855: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
856: --x_return_status := SQLCODE||SUBSTR(SQLERRM,1,100);
857:
858: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
859: THEN

Line 871: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,

867: END update_perz_query;
868: --******************************************************************************
869: PROCEDURE Delete_Perz_Query
870: ( p_api_version_number IN NUMBER,
871: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
872: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
873:
874: p_application_id IN NUMBER,
875: p_profile_id IN NUMBER,

Line 872: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,

868: --******************************************************************************
869: PROCEDURE Delete_Perz_Query
870: ( p_api_version_number IN NUMBER,
871: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
872: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
873:
874: p_application_id IN NUMBER,
875: p_profile_id IN NUMBER,
876: p_query_id IN NUMBER,

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

886: -- Standard Start of API savepoint
887: SAVEPOINT DELETE_PERZ_QUERY_PVT;
888:
889: -- -- Standard call to check for call compatibility.
890: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
891: -- THEN
892: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
893: -- END IF;
894:

Line 892: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

888:
889: -- -- Standard call to check for call compatibility.
890: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
891: -- THEN
892: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
893: -- END IF;
894:
895: -- Initialize message list if p_init_msg_list is set to TRUE.
896: IF Fnd_Api.to_Boolean( p_init_msg_list )

Line 896: IF Fnd_Api.to_Boolean( p_init_msg_list )

892: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
893: -- END IF;
894:
895: -- Initialize message list if p_init_msg_list is set to TRUE.
896: IF Fnd_Api.to_Boolean( p_init_msg_list )
897: THEN
898: Fnd_Msg_Pub.initialize;
899: END IF;
900:

Line 902: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

898: Fnd_Msg_Pub.initialize;
899: END IF;
900:
901: -- Initialize API return status to success
902: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
903:
904:
905: -- CALL FLOW
906: -- 1. Select query ID from databe

Line 942: WHEN Fnd_Api.G_EXC_ERROR THEN

938: DELETE FROM JTF_PERZ_QUERY WHERE QUERY_ID = l_query_id;
939:
940: EXCEPTION
941:
942: WHEN Fnd_Api.G_EXC_ERROR THEN
943: --dbms_output.put_line('stop 1 ');
944:
945: ROLLBACK TO DELETE_PERZ_QUERY_PVT;
946: x_return_status := Fnd_Api.G_RET_STS_ERROR ;

Line 946: x_return_status := Fnd_Api.G_RET_STS_ERROR ;

942: WHEN Fnd_Api.G_EXC_ERROR THEN
943: --dbms_output.put_line('stop 1 ');
944:
945: ROLLBACK TO DELETE_PERZ_QUERY_PVT;
946: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
947:
948: Fnd_Msg_Pub.Count_And_Get( p_count => x_msg_count,
949: p_data => x_msg_data );
950:

Line 951: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

947:
948: Fnd_Msg_Pub.Count_And_Get( p_count => x_msg_count,
949: p_data => x_msg_data );
950:
951: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
952: --dbms_output.put_line('stop 2 ');
953: ROLLBACK TO DELETE_PERZ_QUERY_PVT;
954: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
955:

Line 954: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;

950:
951: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
952: --dbms_output.put_line('stop 2 ');
953: ROLLBACK TO DELETE_PERZ_QUERY_PVT;
954: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
955:
956: Fnd_Msg_Pub.Count_And_Get( p_count => x_msg_count,
957: p_data => x_msg_data );
958:

Line 962: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;

958:
959: WHEN OTHERS THEN
960: --dbms_output.put_line('stop 3 ');
961: ROLLBACK TO DELETE_PERZ_QUERY_PVT;
962: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
963:
964: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
965: THEN
966: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME, l_api_name );

Line 979: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,

975: --******************************************************************************
976:
977: PROCEDURE Get_Perz_Query_Summary
978: ( p_api_version_number IN NUMBER,
979: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
980:
981: p_application_id IN NUMBER,
982: p_profile_id IN NUMBER,
983: p_profile_name IN VARCHAR2,

Line 1002: l_return_status VARCHAR2(240) := Fnd_Api.G_RET_STS_SUCCESS;

998: l_any_errors BOOLEAN := FALSE;
999: l_any_row_errors BOOLEAN := FALSE;
1000: l_found_flag BOOLEAN := FALSE;
1001: l_rowid ROWID;
1002: l_return_status VARCHAR2(240) := Fnd_Api.G_RET_STS_SUCCESS;
1003: l_api_name CONSTANT VARCHAR2(30) := 'Get Perz Query Summary';
1004:
1005: l_count NUMBER := 0;
1006: l_msg_count NUMBER := NULL;

Line 1011: l_duplicate VARCHAR2(240) := Fnd_Api.G_FALSE;

1007: l_msg_data VARCHAR2(200) := NULL;
1008: l_count_1 NUMBER := NULL;
1009: l_curr_row NUMBER := NULL;
1010:
1011: l_duplicate VARCHAR2(240) := Fnd_Api.G_FALSE;
1012: l_query_name VARCHAR2(100) := p_query_name;
1013:
1014: -- Variables for ids
1015: l_query_string VARCHAR2(1) := NULL;

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

1067: BEGIN
1068: -- ******* Standard Begins ********
1069:
1070: -- -- Standard call to check for call compatibility.
1071: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
1072: -- THEN
1073: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1074: -- END IF;
1075:

Line 1073: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1069:
1070: -- -- Standard call to check for call compatibility.
1071: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
1072: -- THEN
1073: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1074: -- END IF;
1075:
1076: -- Initialize message list if p_init_msg_list is set to TRUE.
1077: IF Fnd_Api.to_Boolean( p_init_msg_list )

Line 1077: IF Fnd_Api.to_Boolean( p_init_msg_list )

1073: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1074: -- END IF;
1075:
1076: -- Initialize message list if p_init_msg_list is set to TRUE.
1077: IF Fnd_Api.to_Boolean( p_init_msg_list )
1078: THEN
1079: Fnd_Msg_Pub.initialize;
1080: END IF;
1081: -- Initialize API return status to success

Line 1082: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1078: THEN
1079: Fnd_Msg_Pub.initialize;
1080: END IF;
1081: -- Initialize API return status to success
1082: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1083:
1084:
1085: IF ((p_query_id IS NOT NULL) AND
1086: (p_query_id <> Fnd_Api.G_MISS_NUM)) THEN

Line 1086: (p_query_id <> Fnd_Api.G_MISS_NUM)) THEN

1082: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1083:
1084:
1085: IF ((p_query_id IS NOT NULL) AND
1086: (p_query_id <> Fnd_Api.G_MISS_NUM)) THEN
1087:
1088: l_count := 1;
1089: OPEN C_Get_Query_Summary_qid(p_query_id);
1090: LOOP

Line 1117: l_return_status := Fnd_Api.G_TRUE;

1113:
1114: ELSE
1115: l_profile_id := p_profile_id;
1116: l_profile_name := p_profile_name;
1117: l_return_status := Fnd_Api.G_TRUE;
1118:
1119: IF ( l_profile_id IS NULL ) THEN
1120: JTF_PERZ_PROFILE_PVT.check_profile_duplicates(l_profile_name,
1121: l_return_status,

Line 1126: IF (l_return_status = Fnd_Api.G_FALSE) THEN

1122: l_profile_id);
1123:
1124: -- If profile does not exists, raise an error and exit
1125:
1126: IF (l_return_status = Fnd_Api.G_FALSE) THEN
1127: RAISE Fnd_Api.G_EXC_ERROR;
1128: END IF;
1129: END IF;
1130:

Line 1127: RAISE Fnd_Api.G_EXC_ERROR;

1123:
1124: -- If profile does not exists, raise an error and exit
1125:
1126: IF (l_return_status = Fnd_Api.G_FALSE) THEN
1127: RAISE Fnd_Api.G_EXC_ERROR;
1128: END IF;
1129: END IF;
1130:
1131: IF (((l_profile_id IS NOT NULL) AND

Line 1132: (l_profile_id <> Fnd_Api.G_MISS_NUM)) AND

1128: END IF;
1129: END IF;
1130:
1131: IF (((l_profile_id IS NOT NULL) AND
1132: (l_profile_id <> Fnd_Api.G_MISS_NUM)) AND
1133: ((p_application_id IS NOT NULL) AND
1134: (p_application_id <> Fnd_Api.G_MISS_NUM))) THEN
1135:
1136: IF((p_query_name IS NOT NULL) AND (p_query_name <> Fnd_Api.G_MISS_CHAR)

Line 1134: (p_application_id <> Fnd_Api.G_MISS_NUM))) THEN

1130:
1131: IF (((l_profile_id IS NOT NULL) AND
1132: (l_profile_id <> Fnd_Api.G_MISS_NUM)) AND
1133: ((p_application_id IS NOT NULL) AND
1134: (p_application_id <> Fnd_Api.G_MISS_NUM))) THEN
1135:
1136: IF((p_query_name IS NOT NULL) AND (p_query_name <> Fnd_Api.G_MISS_CHAR)
1137: AND (p_query_type IS NOT NULL) AND (p_query_type <> Fnd_Api.G_MISS_CHAR)) THEN
1138: /* if query name and type was given */

Line 1136: IF((p_query_name IS NOT NULL) AND (p_query_name <> Fnd_Api.G_MISS_CHAR)

1132: (l_profile_id <> Fnd_Api.G_MISS_NUM)) AND
1133: ((p_application_id IS NOT NULL) AND
1134: (p_application_id <> Fnd_Api.G_MISS_NUM))) THEN
1135:
1136: IF((p_query_name IS NOT NULL) AND (p_query_name <> Fnd_Api.G_MISS_CHAR)
1137: AND (p_query_type IS NOT NULL) AND (p_query_type <> Fnd_Api.G_MISS_CHAR)) THEN
1138: /* if query name and type was given */
1139: l_count := 1;
1140: OPEN C_Get_Query_Summary_qnmty(p_query_name,p_query_type,

Line 1137: AND (p_query_type IS NOT NULL) AND (p_query_type <> Fnd_Api.G_MISS_CHAR)) THEN

1133: ((p_application_id IS NOT NULL) AND
1134: (p_application_id <> Fnd_Api.G_MISS_NUM))) THEN
1135:
1136: IF((p_query_name IS NOT NULL) AND (p_query_name <> Fnd_Api.G_MISS_CHAR)
1137: AND (p_query_type IS NOT NULL) AND (p_query_type <> Fnd_Api.G_MISS_CHAR)) THEN
1138: /* if query name and type was given */
1139: l_count := 1;
1140: OPEN C_Get_Query_Summary_qnmty(p_query_name,p_query_type,
1141: l_profile_id, p_application_id);

Line 1170: (p_query_name <> Fnd_Api.G_MISS_CHAR)) THEN

1166: RETURN;
1167: END IF; -- end for name and type
1168:
1169: IF((p_query_name IS NOT NULL) AND
1170: (p_query_name <> Fnd_Api.G_MISS_CHAR)) THEN
1171: /* if query name was given */
1172: l_count := 1;
1173: OPEN C_Get_Query_Summary_qnm(p_query_name,
1174: l_profile_id, p_application_id);

Line 1203: (p_query_type <> Fnd_Api.G_MISS_CHAR)) THEN

1199: RETURN;
1200: END IF; -- end for name
1201:
1202: IF((p_query_type IS NOT NULL) AND
1203: (p_query_type <> Fnd_Api.G_MISS_CHAR)) THEN
1204: /* if query type was given */
1205: l_count := 1;
1206: OPEN C_Get_Query_Summary_qty(p_query_type,
1207: l_profile_id, p_application_id);

Line 1268: WHEN Fnd_Api.G_EXC_ERROR THEN

1264: END IF; -- endif for query id
1265:
1266: EXCEPTION
1267:
1268: WHEN Fnd_Api.G_EXC_ERROR THEN
1269: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
1270:
1271: Fnd_Msg_Pub.Count_And_Get( p_count => x_msg_count,
1272: p_data => x_msg_data );

Line 1269: x_return_status := Fnd_Api.G_RET_STS_ERROR ;

1265:
1266: EXCEPTION
1267:
1268: WHEN Fnd_Api.G_EXC_ERROR THEN
1269: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
1270:
1271: Fnd_Msg_Pub.Count_And_Get( p_count => x_msg_count,
1272: p_data => x_msg_data );
1273:

Line 1274: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

1270:
1271: Fnd_Msg_Pub.Count_And_Get( p_count => x_msg_count,
1272: p_data => x_msg_data );
1273:
1274: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1275: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
1276:
1277: Fnd_Msg_Pub.Count_And_Get( p_count => x_msg_count,
1278: p_data => x_msg_data );

Line 1275: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;

1271: Fnd_Msg_Pub.Count_And_Get( p_count => x_msg_count,
1272: p_data => x_msg_data );
1273:
1274: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1275: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
1276:
1277: Fnd_Msg_Pub.Count_And_Get( p_count => x_msg_count,
1278: p_data => x_msg_data );
1279:

Line 1281: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;

1277: Fnd_Msg_Pub.Count_And_Get( p_count => x_msg_count,
1278: p_data => x_msg_data );
1279:
1280: WHEN OTHERS THEN
1281: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
1282:
1283: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
1284: THEN
1285: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME, l_api_name );

Line 1300: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,

1296:
1297:
1298: PROCEDURE Get_Perz_Query
1299: ( p_api_version_number IN NUMBER,
1300: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
1301:
1302: p_application_id IN NUMBER,
1303: p_profile_id IN NUMBER,
1304: p_profile_name IN VARCHAR2,

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

1366: BEGIN
1367: -- ******* Standard Begins ********
1368:
1369: -- -- Standard call to check for call compatibility.
1370: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
1371: -- THEN
1372: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1373: -- END IF;
1374:

Line 1372: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1368:
1369: -- -- Standard call to check for call compatibility.
1370: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
1371: -- THEN
1372: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1373: -- END IF;
1374:
1375: -- Initialize message list if p_init_msg_list is set to TRUE.
1376: IF Fnd_Api.to_Boolean( p_init_msg_list )

Line 1376: IF Fnd_Api.to_Boolean( p_init_msg_list )

1372: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1373: -- END IF;
1374:
1375: -- Initialize message list if p_init_msg_list is set to TRUE.
1376: IF Fnd_Api.to_Boolean( p_init_msg_list )
1377: THEN
1378: Fnd_Msg_Pub.initialize;
1379: END IF;
1380:

Line 1382: x_return_status := Fnd_Api.G_RET_STS_SUCCESS ;

1378: Fnd_Msg_Pub.initialize;
1379: END IF;
1380:
1381: -- Initialize API return status to success
1382: x_return_status := Fnd_Api.G_RET_STS_SUCCESS ;
1383:
1384:
1385: -- ******* Get_Perz_Query Execution Plan ********
1386: -- execution steps

Line 1530: RAISE Fnd_Api.G_EXC_ERROR;

1526:
1527: ELSE
1528: --2. If Sucessfdul and QUERY OUT TABLE returns more than one record,
1529: -- raise exception if error
1530: RAISE Fnd_Api.G_EXC_ERROR;
1531: END IF;
1532:
1533: EXCEPTION
1534:

Line 1535: WHEN Fnd_Api.G_EXC_ERROR THEN

1531: END IF;
1532:
1533: EXCEPTION
1534:
1535: WHEN Fnd_Api.G_EXC_ERROR THEN
1536: -- dbms_output.put_line('stop 1 ');
1537: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
1538:
1539: Fnd_Msg_Pub.Count_And_Get

Line 1537: x_return_status := Fnd_Api.G_RET_STS_ERROR ;

1533: EXCEPTION
1534:
1535: WHEN Fnd_Api.G_EXC_ERROR THEN
1536: -- dbms_output.put_line('stop 1 ');
1537: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
1538:
1539: Fnd_Msg_Pub.Count_And_Get
1540: ( p_count => x_msg_count,
1541: p_data => x_msg_data );

Line 1544: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

1540: ( p_count => x_msg_count,
1541: p_data => x_msg_data );
1542:
1543:
1544: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1545: --dbms_output.put_line('stop 2 ');
1546: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
1547:
1548: Fnd_Msg_Pub.Count_And_Get

Line 1546: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;

1542:
1543:
1544: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1545: --dbms_output.put_line('stop 2 ');
1546: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
1547:
1548: Fnd_Msg_Pub.Count_And_Get
1549: ( p_count => x_msg_count,
1550: p_data => x_msg_data );

Line 1555: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;

1551:
1552:
1553: WHEN OTHERS THEN
1554: --dbms_output.put_line('stop 3 ');
1555: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
1556:
1557: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
1558: THEN
1559: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME, l_api_name );

Line 1573: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,

1569: END Get_Perz_Query;
1570: --******************************************************************************
1571: PROCEDURE Save_Perz_Query
1572: ( p_api_version_number IN NUMBER,
1573: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
1574: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
1575: p_application_id IN NUMBER,
1576: p_profile_id IN NUMBER,
1577: p_profile_name IN VARCHAR2,

Line 1574: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,

1570: --******************************************************************************
1571: PROCEDURE Save_Perz_Query
1572: ( p_api_version_number IN NUMBER,
1573: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
1574: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
1575: p_application_id IN NUMBER,
1576: p_profile_id IN NUMBER,
1577: p_profile_name IN VARCHAR2,
1578: p_profile_type IN VARCHAR2,

Line 1602: l_return_status VARCHAR2(240) := Fnd_Api.G_RET_STS_SUCCESS;

1598: l_api_version_number NUMBER := p_api_version_number;
1599:
1600: -- ******* Save_Perz_Query Local Variables ********
1601:
1602: l_return_status VARCHAR2(240) := Fnd_Api.G_RET_STS_SUCCESS;
1603: l_query_id NUMBER;
1604: l_profile_id NUMBER;
1605: l_is_duplicate VARCHAR2(1) := Fnd_Api.G_FALSE;
1606:

Line 1605: l_is_duplicate VARCHAR2(1) := Fnd_Api.G_FALSE;

1601:
1602: l_return_status VARCHAR2(240) := Fnd_Api.G_RET_STS_SUCCESS;
1603: l_query_id NUMBER;
1604: l_profile_id NUMBER;
1605: l_is_duplicate VARCHAR2(1) := Fnd_Api.G_FALSE;
1606:
1607:
1608: l_profile_attrib Jtf_Perz_Profile_Pub.PROFILE_ATTRIB_TBL_TYPE
1609: := p_profile_attrib;

Line 1612: l_commit VARCHAR2(1) := Fnd_Api.G_TRUE;

1608: l_profile_attrib Jtf_Perz_Profile_Pub.PROFILE_ATTRIB_TBL_TYPE
1609: := p_profile_attrib;
1610: l_profile_name VARCHAR2(60) := p_profile_name;
1611:
1612: l_commit VARCHAR2(1) := Fnd_Api.G_TRUE;
1613: l_object_version_number NUMBER :=NULL;
1614:
1615:
1616:

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

1620: -- Standard Start of API savepoint
1621: SAVEPOINT SAVE_PERZ_QUERY_PVT;
1622:
1623: -- -- Standard call to check for call compatibility.
1624: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
1625: -- THEN
1626: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1627: -- END IF;
1628:

Line 1626: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1622:
1623: -- -- Standard call to check for call compatibility.
1624: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
1625: -- THEN
1626: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1627: -- END IF;
1628:
1629: -- Initialize message list if p_init_msg_list is set to TRUE.
1630: IF Fnd_Api.to_Boolean( p_init_msg_list )

Line 1630: IF Fnd_Api.to_Boolean( p_init_msg_list )

1626: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1627: -- END IF;
1628:
1629: -- Initialize message list if p_init_msg_list is set to TRUE.
1630: IF Fnd_Api.to_Boolean( p_init_msg_list )
1631: THEN
1632: Fnd_Msg_Pub.initialize;
1633: END IF;
1634:

Line 1636: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1632: Fnd_Msg_Pub.initialize;
1633: END IF;
1634:
1635: -- Initialize API return status to success
1636: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1637:
1638:
1639: -- CALL FLOW :
1640: -- 1. Check for profile, if not existing create profile.

Line 1658: IF (l_return_status = Fnd_Api.G_FALSE) THEN

1654: -- dbms_output.put_line('profile id is:'||l_profile_id);
1655:
1656: -- 1.1 if profile is not available, create profile
1657:
1658: IF (l_return_status = Fnd_Api.G_FALSE) THEN
1659:
1660: l_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1661: l_commit := Fnd_Api.G_FALSE;
1662: l_profile_id := p_profile_id;

Line 1660: l_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1656: -- 1.1 if profile is not available, create profile
1657:
1658: IF (l_return_status = Fnd_Api.G_FALSE) THEN
1659:
1660: l_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1661: l_commit := Fnd_Api.G_FALSE;
1662: l_profile_id := p_profile_id;
1663:
1664: Jtf_Perz_Profile_Pvt.Create_Profile(

Line 1661: l_commit := Fnd_Api.G_FALSE;

1657:
1658: IF (l_return_status = Fnd_Api.G_FALSE) THEN
1659:
1660: l_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1661: l_commit := Fnd_Api.G_FALSE;
1662: l_profile_id := p_profile_id;
1663:
1664: Jtf_Perz_Profile_Pvt.Create_Profile(
1665: p_api_version_number => l_api_version_number,

Line 1678: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS) THEN

1674: x_msg_count => x_msg_count,
1675: x_msg_data => x_msg_data
1676: );
1677:
1678: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS) THEN
1679: RAISE Fnd_Api.G_EXC_ERROR;
1680: END IF;
1681: -- dbms_output.put_line('2 profile id is:'||l_profile_id);
1682: END IF;

Line 1679: RAISE Fnd_Api.G_EXC_ERROR;

1675: x_msg_data => x_msg_data
1676: );
1677:
1678: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS) THEN
1679: RAISE Fnd_Api.G_EXC_ERROR;
1680: END IF;
1681: -- dbms_output.put_line('2 profile id is:'||l_profile_id);
1682: END IF;
1683:

Line 1700: l_commit := Fnd_Api.G_FALSE;

1696: l_object_version_number
1697: );
1698:
1699:
1700: l_commit := Fnd_Api.G_FALSE;
1701: IF (Fnd_Api.To_Boolean(l_is_duplicate)) THEN
1702: --dbms_output.put_line(' duplicate query exists!'||l_query_id);
1703: -- dbms_output.put_line(' duplicate query exists, profile id is:'||l_profile_id);
1704: -- Call update_perz_query

Line 1701: IF (Fnd_Api.To_Boolean(l_is_duplicate)) THEN

1697: );
1698:
1699:
1700: l_commit := Fnd_Api.G_FALSE;
1701: IF (Fnd_Api.To_Boolean(l_is_duplicate)) THEN
1702: --dbms_output.put_line(' duplicate query exists!'||l_query_id);
1703: -- dbms_output.put_line(' duplicate query exists, profile id is:'||l_profile_id);
1704: -- Call update_perz_query
1705:

Line 1766: IF (Fnd_Api.To_Boolean(p_commit)) THEN

1762: --
1763: -- End of main API body.
1764:
1765: -- Standard check of p_commit.
1766: IF (Fnd_Api.To_Boolean(p_commit)) THEN
1767: COMMIT WORK;
1768: END IF;
1769:
1770: -- Standard call to get message count and if count is 1, get message info.

Line 1776: WHEN Fnd_Api.G_EXC_ERROR THEN

1772: p_data => x_msg_data );
1773:
1774: EXCEPTION
1775:
1776: WHEN Fnd_Api.G_EXC_ERROR THEN
1777: -- dbms_output.put_line('stop 1 ');
1778:
1779: ROLLBACK TO SAVE_PERZ_QUERY_PVT;
1780: x_return_status := Fnd_Api.G_RET_STS_ERROR ;

Line 1780: x_return_status := Fnd_Api.G_RET_STS_ERROR ;

1776: WHEN Fnd_Api.G_EXC_ERROR THEN
1777: -- dbms_output.put_line('stop 1 ');
1778:
1779: ROLLBACK TO SAVE_PERZ_QUERY_PVT;
1780: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
1781:
1782: Fnd_Msg_Pub.Count_And_Get
1783: ( p_count => x_msg_count,
1784: p_data => x_msg_data );

Line 1786: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

1782: Fnd_Msg_Pub.Count_And_Get
1783: ( p_count => x_msg_count,
1784: p_data => x_msg_data );
1785:
1786: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1787: -- dbms_output.put_line('stop 2 ');
1788: ROLLBACK TO SAVE_PERZ_QUERY_PVT;
1789: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
1790: Fnd_Msg_Pub.Count_And_Get

Line 1789: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;

1785:
1786: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1787: -- dbms_output.put_line('stop 2 ');
1788: ROLLBACK TO SAVE_PERZ_QUERY_PVT;
1789: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
1790: Fnd_Msg_Pub.Count_And_Get
1791: ( p_count => x_msg_count,
1792: p_data => x_msg_data );
1793:

Line 1798: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;

1794:
1795: WHEN OTHERS THEN
1796: -- dbms_output.put_line('stop 3 ');
1797: ROLLBACK TO SAVE_PERZ_QUERY_PVT;
1798: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
1799:
1800: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
1801: THEN
1802: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME, l_api_name );