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 EGO_GLOBALS

Line 49: IF l_return_status = EGO_Globals.G_RECORD_FOUND AND

45: , x_return_status => l_return_status
46: );
47: Error_Handler.Write_Debug('Query Row Returned with : ' || l_return_status);
48:
49: IF l_return_status = EGO_Globals.G_RECORD_FOUND AND
50: EGO_Globals.G_Catalog_Group_Rec.transaction_type = EGO_Globals.G_OPR_CREATE
51: THEN
52: l_token_tbl(1).token_name := 'CATALOG_GROUP_NAME';
53: l_token_tbl(1).token_value :=

Line 50: EGO_Globals.G_Catalog_Group_Rec.transaction_type = EGO_Globals.G_OPR_CREATE

46: );
47: Error_Handler.Write_Debug('Query Row Returned with : ' || l_return_status);
48:
49: IF l_return_status = EGO_Globals.G_RECORD_FOUND AND
50: EGO_Globals.G_Catalog_Group_Rec.transaction_type = EGO_Globals.G_OPR_CREATE
51: THEN
52: l_token_tbl(1).token_name := 'CATALOG_GROUP_NAME';
53: l_token_tbl(1).token_value :=
54: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name;

Line 54: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name;

50: EGO_Globals.G_Catalog_Group_Rec.transaction_type = EGO_Globals.G_OPR_CREATE
51: THEN
52: l_token_tbl(1).token_name := 'CATALOG_GROUP_NAME';
53: l_token_tbl(1).token_value :=
54: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name;
55: Error_Handler.Add_Error_Token
56: ( x_Mesg_token_tbl => l_Mesg_Token_Tbl
57: , p_application_id => 'EGO'
58: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 63: ELSIF l_return_status = EGO_Globals.G_RECORD_NOT_FOUND AND

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
67: l_token_tbl(1).token_name := 'CATALOG_GROUP_NAME';

Line 64: EGO_Globals.G_Catalog_Group_Rec.transaction_type IN

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
67: l_token_tbl(1).token_name := 'CATALOG_GROUP_NAME';
68: l_token_tbl(1).token_value :=

Line 65: (EGO_Globals.G_OPR_UPDATE, EGO_Globals.G_OPR_DELETE)

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
67: l_token_tbl(1).token_name := 'CATALOG_GROUP_NAME';
68: l_token_tbl(1).token_value :=
69: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name;

Line 69: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name;

65: (EGO_Globals.G_OPR_UPDATE, EGO_Globals.G_OPR_DELETE)
66: THEN
67: l_token_tbl(1).token_name := 'CATALOG_GROUP_NAME';
68: l_token_tbl(1).token_value :=
69: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name;
70: Error_Handler.Add_Error_Token
71: ( x_Mesg_token_tbl => l_Mesg_Token_Tbl
72: , p_application_id => 'EGO'
73: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 87: 'Catalog Group '|| EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name

83: , p_message_name => NULL
84: , p_application_id => 'EGO'
85: , p_message_text =>
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

Line 95: IF EGO_Globals.G_Catalog_Group_Rec.transaction_type = 'SYNC' THEN

91: ELSE
92:
93: /* Assign the relevant transaction type for SYNC operations */
94:
95: IF EGO_Globals.G_Catalog_Group_Rec.transaction_type = 'SYNC' THEN
96: IF l_return_status = EGO_Globals.G_RECORD_FOUND THEN
97: EGO_Globals.G_Old_Catalog_Group_Rec.transaction_type :=
98: EGO_Globals.G_OPR_UPDATE;
99: ELSE

Line 96: IF l_return_status = EGO_Globals.G_RECORD_FOUND THEN

92:
93: /* Assign the relevant transaction type for SYNC operations */
94:
95: IF EGO_Globals.G_Catalog_Group_Rec.transaction_type = 'SYNC' THEN
96: IF l_return_status = EGO_Globals.G_RECORD_FOUND THEN
97: EGO_Globals.G_Old_Catalog_Group_Rec.transaction_type :=
98: EGO_Globals.G_OPR_UPDATE;
99: ELSE
100: EGO_Globals.G_Old_Catalog_Group_Rec.transaction_type :=

Line 97: EGO_Globals.G_Old_Catalog_Group_Rec.transaction_type :=

93: /* Assign the relevant transaction type for SYNC operations */
94:
95: IF EGO_Globals.G_Catalog_Group_Rec.transaction_type = 'SYNC' THEN
96: IF l_return_status = EGO_Globals.G_RECORD_FOUND THEN
97: EGO_Globals.G_Old_Catalog_Group_Rec.transaction_type :=
98: EGO_Globals.G_OPR_UPDATE;
99: ELSE
100: EGO_Globals.G_Old_Catalog_Group_Rec.transaction_type :=
101: EGO_Globals.G_OPR_CREATE;

Line 98: EGO_Globals.G_OPR_UPDATE;

94:
95: IF EGO_Globals.G_Catalog_Group_Rec.transaction_type = 'SYNC' THEN
96: IF l_return_status = EGO_Globals.G_RECORD_FOUND THEN
97: EGO_Globals.G_Old_Catalog_Group_Rec.transaction_type :=
98: EGO_Globals.G_OPR_UPDATE;
99: ELSE
100: EGO_Globals.G_Old_Catalog_Group_Rec.transaction_type :=
101: EGO_Globals.G_OPR_CREATE;
102: END IF;

Line 100: EGO_Globals.G_Old_Catalog_Group_Rec.transaction_type :=

96: IF l_return_status = EGO_Globals.G_RECORD_FOUND THEN
97: EGO_Globals.G_Old_Catalog_Group_Rec.transaction_type :=
98: EGO_Globals.G_OPR_UPDATE;
99: ELSE
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;

Line 101: EGO_Globals.G_OPR_CREATE;

97: EGO_Globals.G_Old_Catalog_Group_Rec.transaction_type :=
98: EGO_Globals.G_OPR_UPDATE;
99: ELSE
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:

Line 166: IF (EGO_Globals.G_Catalog_Group_Rec.catalog_group_id =

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: )
169: THEN
170: x_return_status := FND_API.G_RET_STS_ERROR;

Line 167: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id

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: )
169: THEN
170: x_return_status := FND_API.G_RET_STS_ERROR;
171: Error_Handler.Add_Error_Token

Line 178: IF EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id IS NOT NULL AND

174: , x_mesg_token_tbl => l_mesg_token_tbl
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

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 184: WHERE item_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id;

180: THEN
181:
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'

Line 196: IF EGO_Globals.G_Catalog_Group_Rec.inactive_date IS NOT NULL AND

192: END;
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) <>

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 200: IF trunc(EGO_Globals.G_Catalog_Group_Rec.inactive_date) <>

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,
202: EGO_Globals.G_Catalog_Group_Rec.inactive_date))
203: THEN
204:

Line 201: trunc(nvl(EGO_Globals.G_Old_Catalog_Group_Rec.inactive_date,

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,
202: EGO_Globals.G_Catalog_Group_Rec.inactive_date))
203: THEN
204:
205: /* Inactive date should be greater than the current date */

Line 202: EGO_Globals.G_Catalog_Group_Rec.inactive_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,
202: EGO_Globals.G_Catalog_Group_Rec.inactive_date))
203: THEN
204:
205: /* Inactive date should be greater than the current date */
206:

Line 207: IF trunc(EGO_Globals.G_Catalog_Group_Rec.inactive_date) < trunc(SYSDATE)

203: THEN
204:
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'

Line 219: IF nvl(l_parent_inactive_date,EGO_Globals.G_Catalog_Group_Rec.inactive_date) <

215: END IF;
216:
217: /* Incative date cannnot be greater than the parent's inactive date */
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

Line 220: EGO_Globals.G_Catalog_Group_Rec.inactive_date

216:
217: /* Incative date cannnot be greater than the parent's inactive date */
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'

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 296: (p_catalog_group_name =>EGO_Globals.G_Catalog_Group_Rec.catalog_group_name

292: BEGIN
293:
294: /*
295: l_ccid := EGO_ItemCat_Val_To_Id.Get_Catalog_Group_Id
296: (p_catalog_group_name =>EGO_Globals.G_Catalog_Group_Rec.catalog_group_name
297: , p_operation => 'FIND_COMBINATION');
298: */
299:
300: -- Work around to check the duplicate segment values since the FLEX API fails to

Line 310: 101,MICG.item_catalog_group_id,NULL) )) = upper(EGO_Globals.G_Catalog_Group_Rec.catalog_group_name);

306: INTO l_ccid
307: FROM mtl_item_catalog_groups MICG
308: WHERE upper(decode(MICG.item_catalog_group_id, NULL, NULL,
309: FND_FLEX_SERVER.GET_KFV_CONCAT_SEGS_BY_CCID('COMPACT',401,'MICG',
310: 101,MICG.item_catalog_group_id,NULL) )) = upper(EGO_Globals.G_Catalog_Group_Rec.catalog_group_name);
311:
312: EXCEPTION WHEN NO_DATA_FOUND THEN
313: l_ccid := NULL;
314:

Line 318: ( p_message_text => 'Error in Check Entity : Catalog group name is '||EGO_Globals.G_Catalog_Group_Rec.Catalog_group_name||'/'||SQLERRM

314:
315: WHEN OTHERS THEN
316: l_ccid := NULL;
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:

Line 327: IF ( EGO_Globals.G_Catalog_Group_Rec.Transaction_Type = EGO_Globals.G_OPR_CREATE )

323: END;
324:
325: IF l_ccid IS NOT NULL
326: THEN
327: IF ( EGO_Globals.G_Catalog_Group_Rec.Transaction_Type = EGO_Globals.G_OPR_CREATE )
328: OR
329: ( EGO_Globals.G_Catalog_Group_Rec.Transaction_Type = EGO_Globals.G_OPR_UPDATE AND
330: EGO_Globals.G_Catalog_Group_Rec.Catalog_group_id <> l_ccid )
331: THEN

Line 329: ( EGO_Globals.G_Catalog_Group_Rec.Transaction_Type = EGO_Globals.G_OPR_UPDATE AND

325: IF l_ccid IS NOT NULL
326: THEN
327: IF ( EGO_Globals.G_Catalog_Group_Rec.Transaction_Type = EGO_Globals.G_OPR_CREATE )
328: OR
329: ( EGO_Globals.G_Catalog_Group_Rec.Transaction_Type = EGO_Globals.G_OPR_UPDATE AND
330: EGO_Globals.G_Catalog_Group_Rec.Catalog_group_id <> l_ccid )
331: THEN
332: -- dbms_output.put_line('Duplicate error in : '||EGO_Globals.G_Catalog_Group_Rec.Transaction_Type);
333: Error_Handler.Add_Error_Token

Line 330: EGO_Globals.G_Catalog_Group_Rec.Catalog_group_id <> l_ccid )

326: THEN
327: IF ( EGO_Globals.G_Catalog_Group_Rec.Transaction_Type = EGO_Globals.G_OPR_CREATE )
328: OR
329: ( EGO_Globals.G_Catalog_Group_Rec.Transaction_Type = EGO_Globals.G_OPR_UPDATE AND
330: EGO_Globals.G_Catalog_Group_Rec.Catalog_group_id <> l_ccid )
331: THEN
332: -- dbms_output.put_line('Duplicate error in : '||EGO_Globals.G_Catalog_Group_Rec.Transaction_Type);
333: Error_Handler.Add_Error_Token
334: ( p_message_name => 'EGO_CATALOG_ALREADY_EXISTS'

Line 332: -- dbms_output.put_line('Duplicate error in : '||EGO_Globals.G_Catalog_Group_Rec.Transaction_Type);

328: OR
329: ( EGO_Globals.G_Catalog_Group_Rec.Transaction_Type = EGO_Globals.G_OPR_UPDATE AND
330: EGO_Globals.G_Catalog_Group_Rec.Catalog_group_id <> l_ccid )
331: THEN
332: -- dbms_output.put_line('Duplicate error in : '||EGO_Globals.G_Catalog_Group_Rec.Transaction_Type);
333: Error_Handler.Add_Error_Token
334: ( p_message_name => 'EGO_CATALOG_ALREADY_EXISTS'
335: , p_application_id => 'EGO'
336: , x_mesg_token_tbl => l_mesg_token_tbl

Line 366: WHERE item_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.Catalog_group_id);

362:
363: -- dbms_output.put_line('Checking for items during delete');
364:
365: SELECT 'x' INTO l_dummy FROM dual WHERE EXISTS (SELECT null FROM mtl_system_items_b
366: WHERE item_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.Catalog_group_id);
367:
368: Error_Handler.Add_Error_Token
369: ( p_message_name => 'EGO_CATALOG_HAS_ITEMS'
370: , p_application_id => 'EGO'

Line 384: ( p_message_text => 'Error in Check Entity Delete : Catalog group name is '||EGO_Globals.G_Catalog_Group_Rec.Catalog_group_name||'/'||SQLERRM

380:
381: WHEN OTHERS
382: THEN
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:

Line 398: WHERE parent_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.Catalog_group_id);

394: BEGIN
395: -- dbms_output.put_line('Checking for parent catalog group during delete');
396:
397: SELECT 'x' INTO l_dummy FROM dual WHERE EXISTS (SELECT null FROM mtl_item_catalog_groups_b
398: WHERE parent_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.Catalog_group_id);
399:
400: -- dbms_output.put_line('Found parent catalog group during delete');
401:
402: Error_Handler.Add_Error_Token

Line 418: ( p_message_text => 'Error in Check Entity Delete : Catalog group name is '||EGO_Globals.G_Catalog_Group_Rec.Catalog_group_name||'/'||SQLERRM

414:
415: WHEN OTHERS
416: THEN
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: