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

Line 62: l_return_status := FND_API.G_RET_STS_ERROR;

58: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
59: , p_message_name => 'EGO_CATGRP_ALREADY_EXISTS'
60: , p_token_tbl => l_token_tbl
61: );
62: l_return_status := FND_API.G_RET_STS_ERROR;
63: ELSIF l_return_status = EGO_Globals.G_RECORD_NOT_FOUND AND
64: EGO_Globals.G_Catalog_Group_Rec.transaction_type IN
65: (EGO_Globals.G_OPR_UPDATE, EGO_Globals.G_OPR_DELETE)
66: THEN

Line 77: l_return_status := FND_API.G_RET_STS_ERROR;

73: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
74: , p_message_name => 'EGO_CATGRP_DOESNOT_EXIST'
75: , p_token_tbl => l_token_tbl
76: );
77: l_return_status := FND_API.G_RET_STS_ERROR;
78: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR
79: THEN
80: Error_Handler.Add_Error_Token
81: ( x_Mesg_token_tbl => l_Mesg_Token_Tbl

Line 78: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR

74: , p_message_name => 'EGO_CATGRP_DOESNOT_EXIST'
75: , p_token_tbl => l_token_tbl
76: );
77: l_return_status := FND_API.G_RET_STS_ERROR;
78: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR
79: THEN
80: Error_Handler.Add_Error_Token
81: ( x_Mesg_token_tbl => l_Mesg_Token_Tbl
82: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 90: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

86: 'Unexpected error while existence verification of ' ||
87: 'Catalog Group '|| EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name
88: , p_token_tbl => l_token_tbl
89: );
90: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
91: ELSE
92:
93: /* Assign the relevant transaction type for SYNC operations */
94:

Line 104: l_return_status := FND_API.G_RET_STS_SUCCESS;

100: EGO_Globals.G_Old_Catalog_Group_Rec.transaction_type :=
101: EGO_Globals.G_OPR_CREATE;
102: END IF;
103: END IF;
104: l_return_status := FND_API.G_RET_STS_SUCCESS;
105:
106: END IF;
107:
108: x_return_status := l_return_status;

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

122: ( x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
123: , x_return_status OUT NOCOPY VARCHAR2
124: )
125: IS
126: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
127: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
128: l_token_tbl Error_Handler.Token_Tbl_Type;
129:
130: BEGIN

Line 164: x_return_status := FND_API.G_RET_STS_SUCCESS;

160: l_parent_inactive_date DATE;
161:
162: BEGIN
163:
164: x_return_status := FND_API.G_RET_STS_SUCCESS;
165:
166: IF (EGO_Globals.G_Catalog_Group_Rec.catalog_group_id =
167: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id
168: )

Line 170: x_return_status := FND_API.G_RET_STS_ERROR;

166: IF (EGO_Globals.G_Catalog_Group_Rec.catalog_group_id =
167: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id
168: )
169: THEN
170: x_return_status := FND_API.G_RET_STS_ERROR;
171: Error_Handler.Add_Error_Token
172: ( p_message_name => 'EGO_CATALOG_ID_SAMEAS_PARENT'
173: , p_application_id => 'EGO'
174: , x_mesg_token_tbl => l_mesg_token_tbl

Line 179: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id <> FND_API.G_MISS_NUM

175: );
176: END IF;
177:
178: IF EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id IS NOT NULL AND
179: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id <> FND_API.G_MISS_NUM
180: THEN
181:
182: BEGIN
183: SELECT inactive_date INTO l_parent_inactive_date FROM mtl_item_catalog_groups_b

Line 186: x_return_status := FND_API.G_RET_STS_ERROR;

182: BEGIN
183: SELECT inactive_date INTO l_parent_inactive_date FROM mtl_item_catalog_groups_b
184: WHERE item_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id;
185: EXCEPTION WHEN OTHERS THEN
186: x_return_status := FND_API.G_RET_STS_ERROR;
187: Error_Handler.Add_Error_Token
188: ( p_message_name => 'EGO_CG_PARENT_NOT_FOUND'
189: , p_application_id => 'EGO'
190: , x_mesg_token_tbl => l_mesg_token_tbl

Line 197: EGO_Globals.G_Catalog_Group_Rec.inactive_date <> FND_API.G_MISS_DATE

193:
194: END IF;
195:
196: IF EGO_Globals.G_Catalog_Group_Rec.inactive_date IS NOT NULL AND
197: EGO_Globals.G_Catalog_Group_Rec.inactive_date <> FND_API.G_MISS_DATE
198: THEN
199:
200: IF trunc(EGO_Globals.G_Catalog_Group_Rec.inactive_date) <>
201: trunc(nvl(EGO_Globals.G_Old_Catalog_Group_Rec.inactive_date,

Line 209: x_return_status := FND_API.G_RET_STS_ERROR;

205: /* Inactive date should be greater than the current date */
206:
207: IF trunc(EGO_Globals.G_Catalog_Group_Rec.inactive_date) < trunc(SYSDATE)
208: THEN
209: x_return_status := FND_API.G_RET_STS_ERROR;
210: Error_Handler.Add_Error_Token
211: ( p_message_name => 'EGO_CG_ENDDATE_LESS_CURRDATE'
212: , p_application_id => 'EGO'
213: , x_mesg_token_tbl => l_mesg_token_tbl

Line 222: x_return_status := FND_API.G_RET_STS_ERROR;

218:
219: IF nvl(l_parent_inactive_date,EGO_Globals.G_Catalog_Group_Rec.inactive_date) <
220: EGO_Globals.G_Catalog_Group_Rec.inactive_date
221: THEN
222: x_return_status := FND_API.G_RET_STS_ERROR;
223: Error_Handler.Add_Error_Token
224: ( p_message_name => 'EGO_CG_ENDDATE_GREAT_PARENTDT'
225: , p_application_id => 'EGO'
226: , x_mesg_token_tbl => l_mesg_token_tbl

Line 232: ELSIF EGO_Globals.G_Catalog_Group_Rec.inactive_date = FND_API.G_MISS_DATE

228: END IF;
229:
230: END IF;
231:
232: ELSIF EGO_Globals.G_Catalog_Group_Rec.inactive_date = FND_API.G_MISS_DATE
233: THEN
234: /* Cannot nullify the end date for a cg when it's parent has one */
235:
236: IF l_parent_inactive_date is NOT NULL

Line 238: x_return_status := FND_API.G_RET_STS_ERROR;

234: /* Cannot nullify the end date for a cg when it's parent has one */
235:
236: IF l_parent_inactive_date is NOT NULL
237: THEN
238: x_return_status := FND_API.G_RET_STS_ERROR;
239: Error_Handler.Add_Error_Token
240: ( p_message_name => 'EGO_CG_PARENT_HAS_ENDDATE'
241: , p_application_id => 'EGO'
242: , x_mesg_token_tbl => l_mesg_token_tbl

Line 268: x_return_status := FND_API.G_RET_STS_SUCCESS;

264: IS
265: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
266: l_Token_Tbl Error_Handler.Token_Tbl_Type;
267: BEGIN
268: x_return_status := FND_API.G_RET_STS_SUCCESS;
269:
270:
271: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
272:

Line 288: l_return_status VARCHAR2(3) := FND_API.G_RET_STS_SUCCESS;

284: ( x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
285: , x_return_status OUT NOCOPY VARCHAR2
286: )
287: IS
288: l_return_status VARCHAR2(3) := FND_API.G_RET_STS_SUCCESS;
289: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
290: l_Token_Tbl Error_Handler.Token_Tbl_Type;
291: l_ccid NUMBER;
292: BEGIN

Line 321: l_return_status := FND_API.G_RET_STS_ERROR;

317: Error_Handler.Add_Error_Token
318: ( p_message_text => 'Error in Check Entity : Catalog group name is '||EGO_Globals.G_Catalog_Group_Rec.Catalog_group_name||'/'||SQLERRM
319: , x_mesg_token_tbl => l_mesg_token_tbl
320: );
321: l_return_status := FND_API.G_RET_STS_ERROR;
322:
323: END;
324:
325: IF l_ccid IS NOT NULL

Line 338: l_return_status := FND_API.G_RET_STS_ERROR;

334: ( p_message_name => 'EGO_CATALOG_ALREADY_EXISTS'
335: , p_application_id => 'EGO'
336: , x_mesg_token_tbl => l_mesg_token_tbl
337: );
338: l_return_status := FND_API.G_RET_STS_ERROR;
339: END IF;
340: END IF;
341:
342: x_return_status := l_return_status;

Line 357: x_return_status := FND_API.G_RET_STS_SUCCESS;

353: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
354: l_dummy VARCHAR2(1);
355: BEGIN
356:
357: x_return_status := FND_API.G_RET_STS_SUCCESS;
358:
359: /* Check if there are any items exist for this catalog group */
360:
361: BEGIN

Line 373: x_return_status := FND_API.G_RET_STS_ERROR;

369: ( p_message_name => 'EGO_CATALOG_HAS_ITEMS'
370: , p_application_id => 'EGO'
371: , x_mesg_token_tbl => x_mesg_token_tbl
372: );
373: x_return_status := FND_API.G_RET_STS_ERROR;
374:
375: Return;
376:
377: EXCEPTION WHEN NO_DATA_FOUND

Line 387: x_return_status := FND_API.G_RET_STS_ERROR;

383: Error_Handler.Add_Error_Token
384: ( p_message_text => 'Error in Check Entity Delete : Catalog group name is '||EGO_Globals.G_Catalog_Group_Rec.Catalog_group_name||'/'||SQLERRM
385: , x_mesg_token_tbl => x_mesg_token_tbl
386: );
387: x_return_status := FND_API.G_RET_STS_ERROR;
388:
389: Return;
390: END;
391:

Line 407: x_return_status := FND_API.G_RET_STS_ERROR;

403: ( p_message_name => 'EGO_CATALOG_IS_PARENT'
404: , p_application_id => 'EGO'
405: , x_mesg_token_tbl => x_mesg_token_tbl
406: );
407: x_return_status := FND_API.G_RET_STS_ERROR;
408:
409: Return;
410:
411: EXCEPTION WHEN NO_DATA_FOUND

Line 421: x_return_status := FND_API.G_RET_STS_ERROR;

417: Error_Handler.Add_Error_Token
418: ( p_message_text => 'Error in Check Entity Delete : Catalog group name is '||EGO_Globals.G_Catalog_Group_Rec.Catalog_group_name||'/'||SQLERRM
419: , x_mesg_token_tbl => x_mesg_token_tbl
420: );
421: x_return_status := FND_API.G_RET_STS_ERROR;
422:
423: Return;
424: END;
425: