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

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

13: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=
14: QP_Attr_Map_PUB.G_MISS_SSC_REC
15: )
16: IS
17: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: BEGIN
19:
20: -- Check required attributes.
21:

Line 25: l_return_status := FND_API.G_RET_STS_ERROR;

21:
22: IF p_SSC_rec.pte_source_system_id IS NULL
23: THEN
24:
25: l_return_status := FND_API.G_RET_STS_ERROR;
26:
27: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
28: THEN
29:

Line 45: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

41:
42:
43: -- Return Error if a required attribute is missing.
44:
45: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
46:
47: RAISE FND_API.G_EXC_ERROR;
48:
49: END IF;

Line 47: RAISE FND_API.G_EXC_ERROR;

43: -- Return Error if a required attribute is missing.
44:
45: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
46:
47: RAISE FND_API.G_EXC_ERROR;
48:
49: END IF;
50:
51: --

Line 67: WHEN FND_API.G_EXC_ERROR THEN

63: x_return_status := l_return_status;
64:
65: EXCEPTION
66:
67: WHEN FND_API.G_EXC_ERROR THEN
68:
69: x_return_status := FND_API.G_RET_STS_ERROR;
70:
71: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 69: x_return_status := FND_API.G_RET_STS_ERROR;

65: EXCEPTION
66:
67: WHEN FND_API.G_EXC_ERROR THEN
68:
69: x_return_status := FND_API.G_RET_STS_ERROR;
70:
71: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
72:
73: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 71: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

67: WHEN FND_API.G_EXC_ERROR THEN
68:
69: x_return_status := FND_API.G_RET_STS_ERROR;
70:
71: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
72:
73: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
74:
75: WHEN OTHERS THEN

Line 73: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

69: x_return_status := FND_API.G_RET_STS_ERROR;
70:
71: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
72:
73: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
74:
75: WHEN OTHERS THEN
76:
77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

73: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
74:
75: WHEN OTHERS THEN
76:
77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
78:
79: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
80: THEN
81: OE_MSG_PUB.Add_Exc_Msg

Line 100: x_return_status := FND_API.G_RET_STS_SUCCESS;

96: )
97: IS
98: BEGIN
99:
100: x_return_status := FND_API.G_RET_STS_SUCCESS;
101:
102: -- Validate SSC attributes
103:
104: IF p_SSC_rec.application_short_name IS NOT NULL AND

Line 110: x_return_status := FND_API.G_RET_STS_ERROR;

106: p_old_SSC_rec.application_short_name OR
107: p_old_SSC_rec.application_short_name IS NULL )
108: THEN
109: IF NOT QP_Validate.Application_Short_Name(p_SSC_rec.application_short_name) THEN
110: x_return_status := FND_API.G_RET_STS_ERROR;
111: END IF;
112: END IF;
113:
114: IF p_SSC_rec.created_by IS NOT NULL AND

Line 120: x_return_status := FND_API.G_RET_STS_ERROR;

116: p_old_SSC_rec.created_by OR
117: p_old_SSC_rec.created_by IS NULL )
118: THEN
119: IF NOT QP_Validate.Created_By(p_SSC_rec.created_by) THEN
120: x_return_status := FND_API.G_RET_STS_ERROR;
121: END IF;
122: END IF;
123:
124: IF p_SSC_rec.creation_date IS NOT NULL AND

Line 130: x_return_status := FND_API.G_RET_STS_ERROR;

126: p_old_SSC_rec.creation_date OR
127: p_old_SSC_rec.creation_date IS NULL )
128: THEN
129: IF NOT QP_Validate.Creation_Date(p_SSC_rec.creation_date) THEN
130: x_return_status := FND_API.G_RET_STS_ERROR;
131: END IF;
132: END IF;
133:
134: IF p_SSC_rec.enabled_flag IS NOT NULL AND

Line 140: x_return_status := FND_API.G_RET_STS_ERROR;

136: p_old_SSC_rec.enabled_flag OR
137: p_old_SSC_rec.enabled_flag IS NULL )
138: THEN
139: IF NOT QP_Validate.Enabled(p_SSC_rec.enabled_flag) THEN
140: x_return_status := FND_API.G_RET_STS_ERROR;
141: END IF;
142: END IF;
143:
144: IF p_SSC_rec.last_updated_by IS NOT NULL AND

Line 150: x_return_status := FND_API.G_RET_STS_ERROR;

146: p_old_SSC_rec.last_updated_by OR
147: p_old_SSC_rec.last_updated_by IS NULL )
148: THEN
149: IF NOT QP_Validate.Last_Updated_By(p_SSC_rec.last_updated_by) THEN
150: x_return_status := FND_API.G_RET_STS_ERROR;
151: END IF;
152: END IF;
153:
154: IF p_SSC_rec.last_update_date IS NOT NULL AND

Line 160: x_return_status := FND_API.G_RET_STS_ERROR;

156: p_old_SSC_rec.last_update_date OR
157: p_old_SSC_rec.last_update_date IS NULL )
158: THEN
159: IF NOT QP_Validate.Last_Update_Date(p_SSC_rec.last_update_date) THEN
160: x_return_status := FND_API.G_RET_STS_ERROR;
161: END IF;
162: END IF;
163:
164: IF p_SSC_rec.last_update_login IS NOT NULL AND

Line 170: x_return_status := FND_API.G_RET_STS_ERROR;

166: p_old_SSC_rec.last_update_login OR
167: p_old_SSC_rec.last_update_login IS NULL )
168: THEN
169: IF NOT QP_Validate.Last_Update_Login(p_SSC_rec.last_update_login) THEN
170: x_return_status := FND_API.G_RET_STS_ERROR;
171: END IF;
172: END IF;
173:
174: IF p_SSC_rec.program_application_id IS NOT NULL AND

Line 180: x_return_status := FND_API.G_RET_STS_ERROR;

176: p_old_SSC_rec.program_application_id OR
177: p_old_SSC_rec.program_application_id IS NULL )
178: THEN
179: IF NOT QP_Validate.Program_Application(p_SSC_rec.program_application_id) THEN
180: x_return_status := FND_API.G_RET_STS_ERROR;
181: END IF;
182: END IF;
183:
184: IF p_SSC_rec.program_id IS NOT NULL AND

Line 190: x_return_status := FND_API.G_RET_STS_ERROR;

186: p_old_SSC_rec.program_id OR
187: p_old_SSC_rec.program_id IS NULL )
188: THEN
189: IF NOT QP_Validate.Program(p_SSC_rec.program_id) THEN
190: x_return_status := FND_API.G_RET_STS_ERROR;
191: END IF;
192: END IF;
193:
194: IF p_SSC_rec.program_update_date IS NOT NULL AND

Line 200: x_return_status := FND_API.G_RET_STS_ERROR;

196: p_old_SSC_rec.program_update_date OR
197: p_old_SSC_rec.program_update_date IS NULL )
198: THEN
199: IF NOT QP_Validate.Program_Update_Date(p_SSC_rec.program_update_date) THEN
200: x_return_status := FND_API.G_RET_STS_ERROR;
201: END IF;
202: END IF;
203:
204: IF p_SSC_rec.pte_code IS NOT NULL AND

Line 210: x_return_status := FND_API.G_RET_STS_ERROR;

206: p_old_SSC_rec.pte_code OR
207: p_old_SSC_rec.pte_code IS NULL )
208: THEN
209: IF NOT QP_Validate.Pte(p_SSC_rec.pte_code) THEN
210: x_return_status := FND_API.G_RET_STS_ERROR;
211: END IF;
212: END IF;
213:
214: IF p_SSC_rec.pte_source_system_id IS NOT NULL AND

Line 220: x_return_status := FND_API.G_RET_STS_ERROR;

216: p_old_SSC_rec.pte_source_system_id OR
217: p_old_SSC_rec.pte_source_system_id IS NULL )
218: THEN
219: IF NOT QP_Validate.Pte_Source_System(p_SSC_rec.pte_source_system_id) THEN
220: x_return_status := FND_API.G_RET_STS_ERROR;
221: END IF;
222: END IF;
223:
224: IF (p_SSC_rec.attribute1 IS NOT NULL AND

Line 362: x_return_status := FND_API.G_RET_STS_ERROR;

358:
359: -- Validate descriptive flexfield.
360:
361: IF NOT QP_Validate.Desc_Flex( 'SSC' ) THEN
362: x_return_status := FND_API.G_RET_STS_ERROR;
363: END IF;
364:
365: END IF;
366:

Line 371: WHEN FND_API.G_EXC_ERROR THEN

367: -- Done validating attributes
368:
369: EXCEPTION
370:
371: WHEN FND_API.G_EXC_ERROR THEN
372:
373: x_return_status := FND_API.G_RET_STS_ERROR;
374:
375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 373: x_return_status := FND_API.G_RET_STS_ERROR;

369: EXCEPTION
370:
371: WHEN FND_API.G_EXC_ERROR THEN
372:
373: x_return_status := FND_API.G_RET_STS_ERROR;
374:
375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
376:
377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

371: WHEN FND_API.G_EXC_ERROR THEN
372:
373: x_return_status := FND_API.G_RET_STS_ERROR;
374:
375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
376:
377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
378:
379: WHEN OTHERS THEN

Line 377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

373: x_return_status := FND_API.G_RET_STS_ERROR;
374:
375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
376:
377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
378:
379: WHEN OTHERS THEN
380:
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
378:
379: WHEN OTHERS THEN
380:
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
382:
383: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
384: THEN
385: OE_MSG_PUB.Add_Exc_Msg

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

396: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
397: , p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
398: )
399: IS
400: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
401: dummy varchar2(1);
402: BEGIN
403:
404: -- Validate entity delete.

Line 412: l_return_status := FND_API.G_RET_STS_ERROR;

408: from qp_list_headers_b
409: where nvl(pte_code,'x') = nvl(p_SSC_rec.pte_code,'y') and
410: nvl(source_system_code,'x') = nvl(p_SSC_rec.application_short_name,'y') and
411: rownum = 1;
412: l_return_status := FND_API.G_RET_STS_ERROR;
413: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_DELETE_SOURCE');
414: OE_MSG_PUB.Add;
415: raise fnd_api.g_exc_error;
416: -- Done.

Line 415: raise fnd_api.g_exc_error;

411: rownum = 1;
412: l_return_status := FND_API.G_RET_STS_ERROR;
413: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_DELETE_SOURCE');
414: OE_MSG_PUB.Add;
415: raise fnd_api.g_exc_error;
416: -- Done.
417: exception
418: when no_data_found then
419: null;

Line 426: WHEN FND_API.G_EXC_ERROR THEN

422: x_return_status := l_return_status;
423:
424: EXCEPTION
425:
426: WHEN FND_API.G_EXC_ERROR THEN
427:
428: x_return_status := FND_API.G_RET_STS_ERROR;
429:
430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 428: x_return_status := FND_API.G_RET_STS_ERROR;

424: EXCEPTION
425:
426: WHEN FND_API.G_EXC_ERROR THEN
427:
428: x_return_status := FND_API.G_RET_STS_ERROR;
429:
430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
431:
432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

426: WHEN FND_API.G_EXC_ERROR THEN
427:
428: x_return_status := FND_API.G_RET_STS_ERROR;
429:
430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
431:
432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
433:
434: WHEN OTHERS THEN

Line 432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

428: x_return_status := FND_API.G_RET_STS_ERROR;
429:
430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
431:
432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
433:
434: WHEN OTHERS THEN
435:
436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
433:
434: WHEN OTHERS THEN
435:
436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
437:
438: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
439: THEN
440: OE_MSG_PUB.Add_Exc_Msg