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_PUB_WS_ICC dependencies on EGO_PUBLICATION_BATCH_GT

Line 1998: - handling update of EGO_PUBLICATION_BATCH_GT seperately differently than AG,VS using a IF-ELSE condition.

1994: At a later point in time (post 12.2), review the feasibility of merging this procedure
1995: with EGO_PUB_WS_UTIL.Write_Errors_ToBatFwk().
1996: It can be done by changing the code of EGO_PUB_WS_UTIL.Write_Errors_ToBatFwk() to handle
1997: - CURSOR c_pub_ws_entities changes
1998: - handling update of EGO_PUBLICATION_BATCH_GT seperately differently than AG,VS using a IF-ELSE condition.
1999: - in ODI pkg EGO_SYNCICCDETAILS , procedure Write_Errors_ToBatFwk() make a call to the procedure in EGO_PUB_WS_UTIL
2000: */
2001:
2002: /* Algorithm of Write_Errors_ToBatFwk in EGO_PUB_WS_UTIL

Line 2142: -- Get all entities of EGO_PUBLICATION_BATCH_GT

2138: WHERE SESSION_ID = l_session_id
2139: AND INPUT_ID = l_input_id
2140: AND SYSTEM_CODE = l_system_code;
2141:
2142: -- Get all entities of EGO_PUBLICATION_BATCH_GT
2143: CURSOR c_pub_bat_gt(l_batch_id NUMBER)
2144: IS
2145: SELECT BATCH_ID,
2146: PK1_VALUE,

Line 2154: FROM EGO_PUBLICATION_BATCH_GT

2150: PK5_VALUE,
2151: SYSTEM_CODE,
2152: STATUS,
2153: MESSAGE
2154: FROM EGO_PUBLICATION_BATCH_GT
2155: WHERE BATCH_ID = l_batch_id;
2156:
2157: BEGIN
2158: L_PROC_NAME := ' Write_Errors_ToBatFwk=> ';

Line 2220: INSERT INTO EGO_PUBLICATION_BATCH_GT

2216: LOOP
2217: --debug(L_PROC_NAME||' entered first For Loop on c_pub_ws_entities, ');
2218:
2219: --debug(L_PROC_NAME||' ent.pk1_value: ' || to_char(ent.pk1_value));
2220: INSERT INTO EGO_PUBLICATION_BATCH_GT
2221: (BATCH_ID,
2222: BATCH_ENTITY_OBJECT_ID,
2223: PK1_VALUE,
2224: PK2_VALUE,

Line 2274: INSERT INTO EGO_PUBLICATION_BATCH_GT

2270: LOOP
2271: --debug(L_PROC_NAME||' entered second For Loop on c_pub_ws_entities ');
2272: --debug(L_PROC_NAME||'ent.pk1_value: ' || to_char(ent.pk1_value));
2273:
2274: INSERT INTO EGO_PUBLICATION_BATCH_GT
2275: (BATCH_ID,
2276: BATCH_ENTITY_OBJECT_ID,
2277: PK1_VALUE,
2278: PK2_VALUE,

Line 2333: INSERT INTO EGO_PUBLICATION_BATCH_GT

2329: LOOP
2330: --debug(L_PROC_NAME||' entered third For Loop on c_pub_ws_entities ');
2331: --debug('ent.pk1_value: ' || to_char(ent.pk1_value));
2332:
2333: INSERT INTO EGO_PUBLICATION_BATCH_GT
2334: ( BATCH_ID,
2335: BATCH_ENTITY_OBJECT_ID,
2336: PK1_VALUE,
2337: PK2_VALUE,

Line 2473: UPDATE EGO_PUBLICATION_BATCH_GT

2469: --debug(L_PROC_NAME||' ip.PARAM_NAME: '||ip.PARAM_NAME||' ip.PK2_VALUE: '||To_Char(ip.PK2_VALUE));
2470: IF ( (ip.PARAM_NAME=G_ENTITY_TYPE_ICC) AND (ip.PK2_VALUE IS NULL) ) THEN
2471:
2472: --debug(L_PROC_NAME||' entered if on param_name=ICC AND PK2_VALUE IS NULL - first time');
2473: UPDATE EGO_PUBLICATION_BATCH_GT
2474: SET STATUS = 'F', MESSAGE = l_message
2475: WHERE BATCH_ID = l_batch_id
2476: AND PK1_VALUE = ip.PK1_VALUE
2477: AND SYSTEM_CODE = ip.SYSTEM_CODE;

Line 2482: UPDATE EGO_PUBLICATION_BATCH_GT

2478:
2479: ELSE /* if (ip.param_name <> G_ENTITY_ICC) OR (ip.param_name=G_ENTITY_ICC AND ip.PK2_VALUE is not NULL) */
2480:
2481: --debug(L_PROC_NAME||' entered if on param_name<>ICC or PK2_VALUE IS not NULL - first time');
2482: UPDATE EGO_PUBLICATION_BATCH_GT
2483: SET STATUS = 'F', MESSAGE = l_message
2484: WHERE BATCH_ID = l_batch_id
2485: AND PK1_VALUE = ip.PK1_VALUE
2486: AND NVL(PK2_VALUE,'pk2_value') = NVL(ip.PK2_VALUE,'pk2_value')

Line 2519: UPDATE EGO_PUBLICATION_BATCH_GT

2515: --debug(L_PROC_NAME||'ip.SYSTEM_CODE: ' || to_char(ip.SYSTEM_CODE));
2516:
2517: IF ( (ip.PARAM_NAME=G_ENTITY_TYPE_ICC) AND (ip.PK2_VALUE IS NULL) ) THEN
2518: --debug(L_PROC_NAME||' entered if on param_name=ICC AND PK2_VALUE IS NULL - second time');
2519: UPDATE EGO_PUBLICATION_BATCH_GT
2520: SET STATUS = 'F', MESSAGE = l_message
2521: WHERE BATCH_ID = l_batch_id
2522: AND PK1_VALUE = ip.PK1_VALUE
2523: AND SYSTEM_CODE = ip.SYSTEM_CODE;

Line 2528: UPDATE EGO_PUBLICATION_BATCH_GT

2524:
2525: ELSE /* if (ip.param_name <> G_ENTITY_ICC) OR (ip.param_name=G_ENTITY_ICC AND ip.PK2_VALUE is not NULL) */
2526:
2527: --debug(L_PROC_NAME||' entered if on param_name<>ICC or PK2_VALUE IS not NULL - second time');
2528: UPDATE EGO_PUBLICATION_BATCH_GT
2529: SET STATUS = 'F', MESSAGE = l_message
2530: WHERE BATCH_ID = l_batch_id
2531: AND PK1_VALUE = ip.PK1_VALUE
2532: AND NVL(PK2_VALUE,'pk2_value') = NVL(ip.PK2_VALUE,'pk2_value')

Line 2566: UPDATE EGO_PUBLICATION_BATCH_GT

2562: --debug(L_PROC_NAME||' ip.PARAM_NAME: '||ip.PARAM_NAME||' ip.PK2_VALUE: '||To_Char(ip.PK2_VALUE));
2563: IF ( (ip.PARAM_NAME=G_ENTITY_TYPE_ICC) AND (ip.PK2_VALUE IS NULL) ) THEN
2564: --debug(L_PROC_NAME||' entered if on param_name=ICC AND PK2_VALUE IS NULL - third time');
2565:
2566: UPDATE EGO_PUBLICATION_BATCH_GT
2567: SET STATUS = 'W', MESSAGE = l_message
2568: WHERE BATCH_ID = l_batch_id
2569: AND PK1_VALUE = ip.PK1_VALUE
2570: AND SYSTEM_CODE = ip.SYSTEM_CODE;

Line 2578: UPDATE EGO_PUBLICATION_BATCH_GT

2574:
2575: /* ip.PK2_VALUE is not null implies ICC Ver record.
2576: Ideally, this else condition should never be reached
2577: since ICC Ver record can only have an Error msg not Warning*/
2578: UPDATE EGO_PUBLICATION_BATCH_GT
2579: SET STATUS = 'W', MESSAGE = l_message
2580: WHERE BATCH_ID = l_batch_id
2581: AND PK1_VALUE = ip.PK1_VALUE
2582: AND NVL(PK2_VALUE,'pk2_value') = NVL(ip.PK2_VALUE,'pk2_value')