1: PACKAGE BODY QP_Validate_Ssc AS
2: /* $Header: QPXLSSCB.pls 120.1 2005/06/08 21:44:40 appldev $ */
3:
4: -- Global constant holding the package name
5:
2: /* $Header: QPXLSSCB.pls 120.1 2005/06/08 21:44:40 appldev $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Validate_Ssc';
7:
8: -- Procedure Entity
9:
10: PROCEDURE Entity
105: ( p_SSC_rec.application_short_name <>
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:
115: ( p_SSC_rec.created_by <>
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:
125: ( p_SSC_rec.creation_date <>
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:
135: ( p_SSC_rec.enabled_flag <>
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:
145: ( p_SSC_rec.last_updated_by <>
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:
155: ( p_SSC_rec.last_update_date <>
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:
165: ( p_SSC_rec.last_update_login <>
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:
175: ( p_SSC_rec.program_application_id <>
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:
185: ( p_SSC_rec.program_id <>
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:
195: ( p_SSC_rec.program_update_date <>
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:
205: ( p_SSC_rec.pte_code <>
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:
215: ( p_SSC_rec.pte_source_system_id <>
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:
357: */
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;
444: END IF;
445:
446: END Entity_Delete;
447:
448: END QP_Validate_Ssc;