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

Line 66: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

62: END Set_Message;
63:
64:
65: PROCEDURE Validate_OBJECT_VERSION_NUMBER (
66: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
67: P_Validation_mode IN VARCHAR2,
68: P_OBJECT_VERSION_NUMBER IN NUMBER,
69: X_Return_Status OUT NOCOPY VARCHAR2,
70: X_Msg_Count OUT NOCOPY NUMBER,

Line 77: IF FND_API.to_Boolean( p_init_msg_list )

73: IS
74: BEGIN
75:
76: -- Initialize message list if p_init_msg_list is set to TRUE.
77: IF FND_API.to_Boolean( p_init_msg_list )
78: THEN
79: FND_MSG_PUB.initialize;
80: END IF;
81:

Line 84: x_return_status := FND_API.G_RET_STS_SUCCESS;

80: END IF;
81:
82:
83: -- Initialize API return status to SUCCESS
84: x_return_status := FND_API.G_RET_STS_SUCCESS;
85:
86: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
87: THEN
88: -- IF p_OBJECT_VERSION_NUMBER is not NULL and p_OBJECT_VERSION_NUMBER <> G_MISS_NUM

Line 90: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

86: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
87: THEN
88: -- IF p_OBJECT_VERSION_NUMBER is not NULL and p_OBJECT_VERSION_NUMBER <> G_MISS_NUM
89: -- verify if data is valid
90: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
91: NULL;
92: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
93: THEN
94: -- validate NOT NULL column

Line 96: IF(p_OBJECT_VERSION_NUMBER is NULL or p_OBJECT_VERSION_NUMBER = FND_API.G_MISS_NUM)

92: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
93: THEN
94: -- validate NOT NULL column
95:
96: IF(p_OBJECT_VERSION_NUMBER is NULL or p_OBJECT_VERSION_NUMBER = FND_API.G_MISS_NUM)
97: THEN
98: IF (AS_DEBUG_HIGH_ON) THEN
99:
100: AS_UTILITY_PVT.Debug_Message('ERROR', 'Private entyrout API: -Violate NOT NULL constraint(OBJECT_VERSION_NUMBER)');

Line 102: x_return_status := FND_API.G_RET_STS_ERROR;

98: IF (AS_DEBUG_HIGH_ON) THEN
99:
100: AS_UTILITY_PVT.Debug_Message('ERROR', 'Private entyrout API: -Violate NOT NULL constraint(OBJECT_VERSION_NUMBER)');
101: END IF;
102: x_return_status := FND_API.G_RET_STS_ERROR;
103: END IF;
104:
105: END IF;
106:

Line 118: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

114: END Validate_OBJECT_VERSION_NUMBER;
115:
116:
117: PROCEDURE Validate_lookup (
118: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
119: P_Validation_mode IN VARCHAR2,
120: P_TABLE_NAME IN VARCHAR2,
121: P_COLUMN_NAME IN VARCHAR2,
122: P_LOOKUP_TYPE IN VARCHAR2,

Line 142: IF FND_API.to_Boolean( p_init_msg_list )

138: l_val VARCHAR2(1);
139: BEGIN
140:
141: -- Initialize message list if p_init_msg_list is set to TRUE.
142: IF FND_API.to_Boolean( p_init_msg_list )
143: THEN
144: FND_MSG_PUB.initialize;
145: END IF;
146:

Line 149: x_return_status := FND_API.G_RET_STS_SUCCESS;

145: END IF;
146:
147:
148: -- Initialize API return status to SUCCESS
149: x_return_status := FND_API.G_RET_STS_SUCCESS;
150:
151: IF (p_lookup_type is NOT NULL
152: AND p_lookup_type <> FND_API.G_MISS_CHAR)
153: THEN

Line 152: AND p_lookup_type <> FND_API.G_MISS_CHAR)

148: -- Initialize API return status to SUCCESS
149: x_return_status := FND_API.G_RET_STS_SUCCESS;
150:
151: IF (p_lookup_type is NOT NULL
152: AND p_lookup_type <> FND_API.G_MISS_CHAR)
153: THEN
154: OPEN C_Lookup_Exists ( p_lookup_code, p_lookup_type);
155: FETCH C_Lookup_Exists into l_val;
156:

Line 171: x_return_status := FND_API.G_RET_STS_ERROR;

167: p_token3_value => p_lookup_type,
168: p_token4 => 'LOOKUP_CODE',
169: p_token4_value => p_LOOKUP_CODE );
170:
171: x_return_status := FND_API.G_RET_STS_ERROR;
172: END IF;
173: CLOSE C_Lookup_Exists;
174: END IF;
175:

Line 186: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

182: END Validate_Lookup;
183:
184:
185: PROCEDURE Validate_PROCESS_RULE_ID (
186: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
187: P_Validation_mode IN VARCHAR2,
188: P_PROCESS_RULE_ID IN NUMBER,
189: X_Return_Status OUT NOCOPY VARCHAR2,
190: X_Msg_Count OUT NOCOPY NUMBER,

Line 204: IF FND_API.to_Boolean( p_init_msg_list )

200:
201: BEGIN
202:
203: -- Initialize message list if p_init_msg_list is set to TRUE.
204: IF FND_API.to_Boolean( p_init_msg_list )
205: THEN
206: FND_MSG_PUB.initialize;
207: END IF;
208:

Line 211: x_return_status := FND_API.G_RET_STS_SUCCESS;

207: END IF;
208:
209:
210: -- Initialize API return status to SUCCESS
211: x_return_status := FND_API.G_RET_STS_SUCCESS;
212:
213: -- validate NOT NULL column
214: IF(p_PROCESS_RULE_ID is NULL)
215: THEN

Line 220: x_return_status := FND_API.G_RET_STS_ERROR;

216: IF (AS_DEBUG_HIGH_ON) THEN
217:
218: AS_UTILITY_PVT.Debug_Message('ERROR', 'Private entyattmap API: -Violate NOT NULL constraint(PROCESS_RULE_ID)');
219: END IF;
220: x_return_status := FND_API.G_RET_STS_ERROR;
221: END IF;
222:
223: OPEN C_Process_Rule_Id_Exists (p_process_rule_id);
224: FETCH C_Process_Rule_Id_Exists into l_val;

Line 236: x_return_status := FND_API.G_RET_STS_ERROR;

232: p_token1_value => 'PROCESS_RULE_ID',
233: p_token2 => 'VALUE',
234: p_token2_value => p_process_rule_id );
235:
236: x_return_status := FND_API.G_RET_STS_ERROR;
237: END IF;
238: CLOSE C_Process_Rule_Id_Exists;
239:
240: -- Standard call to get message count and if count is 1, get message info.

Line 250: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

246: END Validate_PROCESS_RULE_ID;
247:
248:
249: PROCEDURE Validate_ATTRIBUTE_ID (
250: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
251: P_Validation_mode IN VARCHAR2,
252: P_ATTRIBUTE_ID IN NUMBER,
253: X_Return_Status OUT NOCOPY VARCHAR2,
254: X_Msg_Count OUT NOCOPY NUMBER,

Line 268: IF FND_API.to_Boolean( p_init_msg_list )

264:
265: BEGIN
266:
267: -- Initialize message list if p_init_msg_list is set to TRUE.
268: IF FND_API.to_Boolean( p_init_msg_list )
269: THEN
270: FND_MSG_PUB.initialize;
271: END IF;
272:

Line 275: x_return_status := FND_API.G_RET_STS_SUCCESS;

271: END IF;
272:
273:
274: -- Initialize API return status to SUCCESS
275: x_return_status := FND_API.G_RET_STS_SUCCESS;
276:
277: -- validate NOT NULL column
278: IF(p_ATTRIBUTE_ID is NULL)
279: THEN

Line 285: x_return_status := FND_API.G_RET_STS_ERROR;

281:
282: AS_UTILITY_PVT.Debug_Message('ERROR',
283: 'Private entyattmap API: -Violate NOT NULL constraint(ATTRIBUTE_ID)');
284: END IF;
285: x_return_status := FND_API.G_RET_STS_ERROR;
286: END IF;
287:
288: OPEN C_attribute_id_Exists (p_attribute_id);
289: FETCH C_attribute_id_Exists into l_val;

Line 299: x_return_status := FND_API.G_RET_STS_ERROR;

295: p_msg_name => 'API_INVALID_ID',
296: p_token1 => 'ATTRIBUTE_ID',
297: p_token1_value => p_attribute_id );
298:
299: x_return_status := FND_API.G_RET_STS_ERROR;
300: END IF;
301: CLOSE C_attribute_id_Exists;
302:
303: -- Standard call to get message count and if count is 1, get message info.

Line 313: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

309: END Validate_ATTRIBUTE_ID;
310:
311:
312: PROCEDURE Validate_operator (
313: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
314: P_Validation_mode IN VARCHAR2,
315: P_TABLE_NAME IN VARCHAR2,
316: P_COLUMN_NAME IN VARCHAR2,
317: P_ATTRIBUTE_ID IN NUMBER,

Line 334: IF FND_API.to_Boolean( p_init_msg_list )

330:
331: BEGIN
332:
333: -- Initialize message list if p_init_msg_list is set to TRUE.
334: IF FND_API.to_Boolean( p_init_msg_list )
335: THEN
336: FND_MSG_PUB.initialize;
337: END IF;
338:

Line 340: x_return_status := FND_API.G_RET_STS_SUCCESS;

336: FND_MSG_PUB.initialize;
337: END IF;
338:
339: -- Initialize API return status to SUCCESS
340: x_return_status := FND_API.G_RET_STS_SUCCESS;
341:
342: -- validate NOT NULL column
343: IF(p_ATTRIBUTE_ID is NULL)
344: THEN

Line 350: x_return_status := FND_API.G_RET_STS_ERROR;

346:
347: AS_UTILITY_PVT.Debug_Message('ERROR',
348: 'Private entyattmap API: -Violate NOT NULL constraint(ATTRIBUTE_ID)');
349: END IF;
350: x_return_status := FND_API.G_RET_STS_ERROR;
351: END IF;
352:
353: OPEN c_get_attr_type (p_attribute_id);
354: FETCH c_get_attr_type into l_return_type;

Line 364: x_return_status := FND_API.G_RET_STS_ERROR;

360: p_msg_name => 'API_INVALID_ID',
361: p_token1 => 'ATTRIBUTE_ID',
362: p_token1_value => p_attribute_id );
363:
364: x_return_status := FND_API.G_RET_STS_ERROR;
365: END IF;
366: CLOSE c_get_attr_type;
367:
368: if l_return_type in ('CURRENCY', 'DATE', 'NUMBER') then

Line 371: p_init_msg_list => FND_API.G_FALSE,

367:
368: if l_return_type in ('CURRENCY', 'DATE', 'NUMBER') then
369:
370: pv_common_checks_pvt.Validate_Lookup(
371: p_init_msg_list => FND_API.G_FALSE,
372: p_validation_mode => p_validation_mode,
373: p_TABLE_NAME => p_table_name,
374: p_COLUMN_NAME => p_column_name,
375: p_LOOKUP_TYPE => 'PV_NUM_DATE_OPERATOR',

Line 384: p_init_msg_list => FND_API.G_FALSE,

380:
381: elsif l_return_type in ('NULL_CHECK') then
382:
383: pv_common_checks_pvt.Validate_Lookup(
384: p_init_msg_list => FND_API.G_FALSE,
385: p_validation_mode => p_validation_mode,
386: p_TABLE_NAME => p_table_name,
387: p_COLUMN_NAME => p_column_name,
388: p_LOOKUP_TYPE => 'PV_EXIST_OPERATOR',

Line 397: p_init_msg_list => FND_API.G_FALSE,

393:
394: elsif l_return_type in ('STRING') then
395:
396: pv_common_checks_pvt.Validate_Lookup(
397: p_init_msg_list => FND_API.G_FALSE,
398: p_validation_mode => p_validation_mode,
399: p_TABLE_NAME => p_table_name,
400: p_COLUMN_NAME => p_column_name,
401: p_LOOKUP_TYPE => 'PV_TEXT_OPERATOR',

Line 412: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

408: -- throw invalid return type error
409: null;
410: end if;
411:
412: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
413: raise FND_API.G_EXC_ERROR;
414: END IF;
415:
416: -- Standard call to get message count and if count is 1, get message info.

Line 413: raise FND_API.G_EXC_ERROR;

409: null;
410: end if;
411:
412: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
413: raise FND_API.G_EXC_ERROR;
414: END IF;
415:
416: -- Standard call to get message count and if count is 1, get message info.
417: FND_MSG_PUB.Count_And_Get

Line 426: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

422: END Validate_OPERATOR;
423:
424:
425: PROCEDURE Validate_FLAG (
426: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
427: P_Validation_mode IN VARCHAR2,
428: P_FLAG IN VARCHAR2,
429: X_Return_Status OUT NOCOPY VARCHAR2,
430: X_Msg_Count OUT NOCOPY NUMBER,

Line 437: IF FND_API.to_Boolean( p_init_msg_list )

433: IS
434: BEGIN
435:
436: -- Initialize message list if p_init_msg_list is set to TRUE.
437: IF FND_API.to_Boolean( p_init_msg_list )
438: THEN
439: FND_MSG_PUB.initialize;
440: END IF;
441:

Line 443: x_return_status := FND_API.G_RET_STS_SUCCESS;

439: FND_MSG_PUB.initialize;
440: END IF;
441:
442: -- Initialize API return status to SUCCESS
443: x_return_status := FND_API.G_RET_STS_SUCCESS;
444:
445: IF p_FLAG is not NULL and p_FLAG <> FND_API.G_MISS_CHAR then
446: if p_FLAG not in ('Y', 'N') THEN
447:

Line 445: IF p_FLAG is not NULL and p_FLAG <> FND_API.G_MISS_CHAR then

441:
442: -- Initialize API return status to SUCCESS
443: x_return_status := FND_API.G_RET_STS_SUCCESS;
444:
445: IF p_FLAG is not NULL and p_FLAG <> FND_API.G_MISS_CHAR then
446: if p_FLAG not in ('Y', 'N') THEN
447:
448: AS_UTILITY_PVT.Set_Message(
449: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 454: x_return_status := FND_API.G_RET_STS_ERROR;

450: p_msg_name => 'API_INVALID_FLAG',
451: p_token1 => 'FLAG',
452: p_token1_value => p_flag );
453:
454: x_return_status := FND_API.G_RET_STS_ERROR;
455: end if;
456: END IF;
457:
458: -- Standard call to get message count and if count is 1, get message info.