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

Line 47: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

43: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
44: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
45: )
46: IS
47: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
48:
49: l_qualifier_rule_id NUMBER;
50: BEGIN
51:

Line 60: l_return_status := FND_API.G_RET_STS_ERROR;

56:
57: IF p_QUALIFIER_RULES_rec.qualifier_rule_id IS NULL
58: THEN
59:
60: l_return_status := FND_API.G_RET_STS_ERROR;
61:
62: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
63: THEN
64:

Line 79: l_return_status := FND_API.G_RET_STS_ERROR;

75:
76: IF p_QUALIFIER_RULES_rec.name IS NULL
77: THEN
78:
79: l_return_status := FND_API.G_RET_STS_ERROR;
80:
81: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
82: THEN
83:

Line 100: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

96:
97:
98: -- Return Error if a required attribute is missing.
99:
100: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
101:
102: RAISE FND_API.G_EXC_ERROR;
103:
104: END IF;

Line 102: RAISE FND_API.G_EXC_ERROR;

98: -- Return Error if a required attribute is missing.
99:
100: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
101:
102: RAISE FND_API.G_EXC_ERROR;
103:
104: END IF;
105:
106: --

Line 121: l_return_status := FND_API.G_RET_STS_ERROR;

117:
118: If Check_Duplicate_Name(p_QUALIFIER_RULES_rec.name,
119: p_QUALIFIER_RULES_rec.qualifier_rule_id) Then
120:
121: l_return_status := FND_API.G_RET_STS_ERROR;
122:
123: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
124: THEN
125: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_ATTRIBUTE');

Line 134: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

130:
131: --dbms_output.put_line('status of dup is ' ||l_return_status);
132:
133:
134: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
135:
136: RAISE FND_API.G_EXC_ERROR;
137:
138: END IF;

Line 136: RAISE FND_API.G_EXC_ERROR;

132:
133:
134: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
135:
136: RAISE FND_API.G_EXC_ERROR;
137:
138: END IF;
139:
140:

Line 150: WHEN FND_API.G_EXC_ERROR THEN

146: --dbms_output.put_line('status of entity validation is ' ||x_return_status);
147:
148: EXCEPTION
149:
150: WHEN FND_API.G_EXC_ERROR THEN
151:
152: x_return_status := FND_API.G_RET_STS_ERROR;
153:
154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 152: x_return_status := FND_API.G_RET_STS_ERROR;

148: EXCEPTION
149:
150: WHEN FND_API.G_EXC_ERROR THEN
151:
152: x_return_status := FND_API.G_RET_STS_ERROR;
153:
154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
155:
156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

150: WHEN FND_API.G_EXC_ERROR THEN
151:
152: x_return_status := FND_API.G_RET_STS_ERROR;
153:
154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
155:
156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
157:
158: WHEN OTHERS THEN

Line 156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

152: x_return_status := FND_API.G_RET_STS_ERROR;
153:
154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
155:
156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
157:
158: WHEN OTHERS THEN
159:
160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
157:
158: WHEN OTHERS THEN
159:
160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
161:
162: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
163: THEN
164: OE_MSG_PUB.Add_Exc_Msg

Line 183: x_return_status := FND_API.G_RET_STS_SUCCESS;

179: )
180: IS
181: BEGIN
182:
183: x_return_status := FND_API.G_RET_STS_SUCCESS;
184:
185: -- Validate QUALIFIER_RULES attributes
186:
187: --dbms_output.put_line('created_by ');

Line 195: x_return_status := FND_API.G_RET_STS_ERROR;

191: p_old_QUALIFIER_RULES_rec.created_by OR
192: p_old_QUALIFIER_RULES_rec.created_by IS NULL )
193: THEN
194: IF NOT QP_Validate.Created_By(p_QUALIFIER_RULES_rec.created_by) THEN
195: x_return_status := FND_API.G_RET_STS_ERROR;
196: END IF;
197: END IF;
198:
199:

Line 211: x_return_status := FND_API.G_RET_STS_ERROR;

207: p_old_QUALIFIER_RULES_rec.creation_date OR
208: p_old_QUALIFIER_RULES_rec.creation_date IS NULL )
209: THEN
210: IF NOT QP_Validate.Creation_Date(p_QUALIFIER_RULES_rec.creation_date) THEN
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: END IF;
213: END IF;
214:
215:

Line 227: x_return_status := FND_API.G_RET_STS_ERROR;

223: p_old_QUALIFIER_RULES_rec.description OR
224: p_old_QUALIFIER_RULES_rec.description IS NULL )
225: THEN
226: IF NOT QP_Validate.Description(p_QUALIFIER_RULES_rec.description) THEN
227: x_return_status := FND_API.G_RET_STS_ERROR;
228: END IF;
229: END IF;
230:
231:

Line 245: x_return_status := FND_API.G_RET_STS_ERROR;

241: p_old_QUALIFIER_RULES_rec.last_updated_by OR
242: p_old_QUALIFIER_RULES_rec.last_updated_by IS NULL )
243: THEN
244: IF NOT QP_Validate.Last_Updated_By(p_QUALIFIER_RULES_rec.last_updated_by) THEN
245: x_return_status := FND_API.G_RET_STS_ERROR;
246: END IF;
247: END IF;
248:
249:

Line 264: x_return_status := FND_API.G_RET_STS_ERROR;

260: p_old_QUALIFIER_RULES_rec.last_update_date OR
261: p_old_QUALIFIER_RULES_rec.last_update_date IS NULL )
262: THEN
263: IF NOT QP_Validate.Last_Update_Date(p_QUALIFIER_RULES_rec.last_update_date) THEN
264: x_return_status := FND_API.G_RET_STS_ERROR;
265: END IF;
266: END IF;
267:
268: --dbms_output.put_line('status is '||x_return_status);

Line 279: x_return_status := FND_API.G_RET_STS_ERROR;

275: p_old_QUALIFIER_RULES_rec.last_update_login OR
276: p_old_QUALIFIER_RULES_rec.last_update_login IS NULL )
277: THEN
278: IF NOT QP_Validate.Last_Update_Login(p_QUALIFIER_RULES_rec.last_update_login) THEN
279: x_return_status := FND_API.G_RET_STS_ERROR;
280: END IF;
281: END IF;
282:
283: --dbms_output.put_line('status is '||x_return_status);

Line 294: x_return_status := FND_API.G_RET_STS_ERROR;

290: p_old_QUALIFIER_RULES_rec.name OR
291: p_old_QUALIFIER_RULES_rec.name IS NULL )
292: THEN
293: IF NOT QP_Validate.Name(p_QUALIFIER_RULES_rec.name) THEN
294: x_return_status := FND_API.G_RET_STS_ERROR;
295: END IF;
296: END IF;
297:
298: --dbms_output.put_line('status is '||x_return_status);

Line 310: x_return_status := FND_API.G_RET_STS_ERROR;

306: p_old_QUALIFIER_RULES_rec.program_application_id OR
307: p_old_QUALIFIER_RULES_rec.program_application_id IS NULL )
308: THEN
309: IF NOT QP_Validate.Program_Application(p_QUALIFIER_RULES_rec.program_application_id) THEN
310: x_return_status := FND_API.G_RET_STS_ERROR;
311: END IF;
312: END IF;
313:
314:

Line 327: x_return_status := FND_API.G_RET_STS_ERROR;

323: p_old_QUALIFIER_RULES_rec.program_id OR
324: p_old_QUALIFIER_RULES_rec.program_id IS NULL )
325: THEN
326: IF NOT QP_Validate.Program(p_QUALIFIER_RULES_rec.program_id) THEN
327: x_return_status := FND_API.G_RET_STS_ERROR;
328: END IF;
329: END IF;
330:
331:

Line 343: x_return_status := FND_API.G_RET_STS_ERROR;

339: p_old_QUALIFIER_RULES_rec.program_update_date OR
340: p_old_QUALIFIER_RULES_rec.program_update_date IS NULL )
341: THEN
342: IF NOT QP_Validate.Program_Update_Date(p_QUALIFIER_RULES_rec.program_update_date) THEN
343: x_return_status := FND_API.G_RET_STS_ERROR;
344: END IF;
345: END IF;
346:
347:

Line 359: x_return_status := FND_API.G_RET_STS_ERROR;

355: p_old_QUALIFIER_RULES_rec.qualifier_rule_id OR
356: p_old_QUALIFIER_RULES_rec.qualifier_rule_id IS NULL )
357: THEN
358: IF NOT QP_Validate.Qualifier_Rule(p_QUALIFIER_RULES_rec.qualifier_rule_id) THEN
359: x_return_status := FND_API.G_RET_STS_ERROR;
360: END IF;
361: END IF;
362:
363:

Line 375: x_return_status := FND_API.G_RET_STS_ERROR;

371: p_old_QUALIFIER_RULES_rec.request_id OR
372: p_old_QUALIFIER_RULES_rec.request_id IS NULL )
373: THEN
374: IF NOT QP_Validate.Request(p_QUALIFIER_RULES_rec.request_id) THEN
375: x_return_status := FND_API.G_RET_STS_ERROR;
376: END IF;
377: END IF;
378:
379:

Line 526: x_return_status := FND_API.G_RET_STS_ERROR;

522:
523:
524:
525: IF NOT QP_Validate.Desc_Flex( 'QP_QUALIFIER_RULES' ) THEN
526: x_return_status := FND_API.G_RET_STS_ERROR;
527: END IF;
528:
529:
530: --dbms_output.put_line('status is '||x_return_status);

Line 539: WHEN FND_API.G_EXC_ERROR THEN

535: -- Done validating attributes
536:
537: EXCEPTION
538:
539: WHEN FND_API.G_EXC_ERROR THEN
540:
541: x_return_status := FND_API.G_RET_STS_ERROR;
542:
543: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 541: x_return_status := FND_API.G_RET_STS_ERROR;

537: EXCEPTION
538:
539: WHEN FND_API.G_EXC_ERROR THEN
540:
541: x_return_status := FND_API.G_RET_STS_ERROR;
542:
543: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
544:
545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 543: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

539: WHEN FND_API.G_EXC_ERROR THEN
540:
541: x_return_status := FND_API.G_RET_STS_ERROR;
542:
543: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
544:
545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
546:
547: WHEN OTHERS THEN

Line 545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

541: x_return_status := FND_API.G_RET_STS_ERROR;
542:
543: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
544:
545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
546:
547: WHEN OTHERS THEN
548:
549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
546:
547: WHEN OTHERS THEN
548:
549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
550:
551: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
552: THEN
553: OE_MSG_PUB.Add_Exc_Msg

Line 568: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

564: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
565: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
566: )
567: IS
568: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
569: BEGIN
570:
571: -- Validate entity delete.
572:

Line 581: WHEN FND_API.G_EXC_ERROR THEN

577: x_return_status := l_return_status;
578:
579: EXCEPTION
580:
581: WHEN FND_API.G_EXC_ERROR THEN
582:
583: x_return_status := FND_API.G_RET_STS_ERROR;
584:
585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 583: x_return_status := FND_API.G_RET_STS_ERROR;

579: EXCEPTION
580:
581: WHEN FND_API.G_EXC_ERROR THEN
582:
583: x_return_status := FND_API.G_RET_STS_ERROR;
584:
585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
586:
587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

581: WHEN FND_API.G_EXC_ERROR THEN
582:
583: x_return_status := FND_API.G_RET_STS_ERROR;
584:
585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
586:
587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
588:
589: WHEN OTHERS THEN

Line 587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

583: x_return_status := FND_API.G_RET_STS_ERROR;
584:
585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
586:
587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
588:
589: WHEN OTHERS THEN
590:
591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
588:
589: WHEN OTHERS THEN
590:
591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
592:
593: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
594: THEN
595: OE_MSG_PUB.Add_Exc_Msg