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

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

13: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
14: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_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_Contract_rec.pricing_contract_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 Contract attributes
103:
104: IF p_Contract_rec.agreement_id IS NOT NULL AND

Line 110: x_return_status := FND_API.G_RET_STS_ERROR;

106: p_old_Contract_rec.agreement_id OR
107: p_old_Contract_rec.agreement_id IS NULL )
108: THEN
109: IF NOT OE_Validate_Attr.Agreement(p_Contract_rec.agreement_id) THEN
110: x_return_status := FND_API.G_RET_STS_ERROR;
111: END IF;
112: END IF;
113:
114: IF p_Contract_rec.created_by IS NOT NULL AND

Line 120: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 130: x_return_status := FND_API.G_RET_STS_ERROR;

126: p_old_Contract_rec.creation_date OR
127: p_old_Contract_rec.creation_date IS NULL )
128: THEN
129: IF NOT OE_Validate_Attr.Creation_Date(p_Contract_rec.creation_date) THEN
130: x_return_status := FND_API.G_RET_STS_ERROR;
131: END IF;
132: END IF;
133:
134: IF p_Contract_rec.discount_id IS NOT NULL AND

Line 140: x_return_status := FND_API.G_RET_STS_ERROR;

136: p_old_Contract_rec.discount_id OR
137: p_old_Contract_rec.discount_id IS NULL )
138: THEN
139: IF NOT OE_Validate_Attr.Discount(p_Contract_rec.discount_id) THEN
140: x_return_status := FND_API.G_RET_STS_ERROR;
141: END IF;
142: END IF;
143:
144: IF p_Contract_rec.last_updated_by IS NOT NULL AND

Line 150: x_return_status := FND_API.G_RET_STS_ERROR;

146: p_old_Contract_rec.last_updated_by OR
147: p_old_Contract_rec.last_updated_by IS NULL )
148: THEN
149: IF NOT OE_Validate_Attr.Last_Updated_By(p_Contract_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_Contract_rec.last_update_date IS NOT NULL AND

Line 160: x_return_status := FND_API.G_RET_STS_ERROR;

156: p_old_Contract_rec.last_update_date OR
157: p_old_Contract_rec.last_update_date IS NULL )
158: THEN
159: IF NOT OE_Validate_Attr.Last_Update_Date(p_Contract_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_Contract_rec.last_update_login IS NOT NULL AND

Line 170: x_return_status := FND_API.G_RET_STS_ERROR;

166: p_old_Contract_rec.last_update_login OR
167: p_old_Contract_rec.last_update_login IS NULL )
168: THEN
169: IF NOT OE_Validate_Attr.Last_Update_Login(p_Contract_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_Contract_rec.price_list_id IS NOT NULL AND

Line 180: x_return_status := FND_API.G_RET_STS_ERROR;

176: p_old_Contract_rec.price_list_id OR
177: p_old_Contract_rec.price_list_id IS NULL )
178: THEN
179: IF NOT OE_Validate_Attr.Price_List(p_Contract_rec.price_list_id) THEN
180: x_return_status := FND_API.G_RET_STS_ERROR;
181: END IF;
182: END IF;
183:
184: IF p_Contract_rec.pricing_contract_id IS NOT NULL AND

Line 190: x_return_status := FND_API.G_RET_STS_ERROR;

186: p_old_Contract_rec.pricing_contract_id OR
187: p_old_Contract_rec.pricing_contract_id IS NULL )
188: THEN
189: IF NOT OE_Validate_Attr.Pricing_Contract(p_Contract_rec.pricing_contract_id) THEN
190: x_return_status := FND_API.G_RET_STS_ERROR;
191: END IF;
192: END IF;
193:
194: IF (p_Contract_rec.attribute1 IS NOT NULL AND

Line 332: x_return_status := FND_API.G_RET_STS_ERROR;

328:
329: -- Validate descriptive flexfield.
330:
331: IF NOT OE_Validate_Attr.Desc_Flex( 'CONTRACT' ) THEN
332: x_return_status := FND_API.G_RET_STS_ERROR;
333: END IF;
334:
335: END IF;
336:

Line 341: WHEN FND_API.G_EXC_ERROR THEN

337: -- Done validating attributes
338:
339: EXCEPTION
340:
341: WHEN FND_API.G_EXC_ERROR THEN
342:
343: x_return_status := FND_API.G_RET_STS_ERROR;
344:
345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 343: x_return_status := FND_API.G_RET_STS_ERROR;

339: EXCEPTION
340:
341: WHEN FND_API.G_EXC_ERROR THEN
342:
343: x_return_status := FND_API.G_RET_STS_ERROR;
344:
345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
346:
347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

341: WHEN FND_API.G_EXC_ERROR THEN
342:
343: x_return_status := FND_API.G_RET_STS_ERROR;
344:
345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
346:
347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
348:
349: WHEN OTHERS THEN

Line 347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

343: x_return_status := FND_API.G_RET_STS_ERROR;
344:
345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
346:
347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
348:
349: WHEN OTHERS THEN
350:
351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
348:
349: WHEN OTHERS THEN
350:
351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
352:
353: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
354: THEN
355: OE_MSG_PUB.Add_Exc_Msg

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

366: ( x_return_status OUT VARCHAR2
367: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
368: )
369: IS
370: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
371: BEGIN
372:
373: -- Validate entity delete.
374:

Line 383: WHEN FND_API.G_EXC_ERROR THEN

379: x_return_status := l_return_status;
380:
381: EXCEPTION
382:
383: WHEN FND_API.G_EXC_ERROR THEN
384:
385: x_return_status := FND_API.G_RET_STS_ERROR;
386:
387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 385: x_return_status := FND_API.G_RET_STS_ERROR;

381: EXCEPTION
382:
383: WHEN FND_API.G_EXC_ERROR THEN
384:
385: x_return_status := FND_API.G_RET_STS_ERROR;
386:
387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
388:
389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

383: WHEN FND_API.G_EXC_ERROR THEN
384:
385: x_return_status := FND_API.G_RET_STS_ERROR;
386:
387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
388:
389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
390:
391: WHEN OTHERS THEN

Line 389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

385: x_return_status := FND_API.G_RET_STS_ERROR;
386:
387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
388:
389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
390:
391: WHEN OTHERS THEN
392:
393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
390:
391: WHEN OTHERS THEN
392:
393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
394:
395: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
396: THEN
397: OE_MSG_PUB.Add_Exc_Msg