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

Line 2443: WHEN FND_API.G_EXC_ERROR THEN

2439: END IF;
2440: --End of Bug No : 4292425
2441:
2442: EXCEPTION
2443: WHEN FND_API.G_EXC_ERROR THEN
2444: outandlog('Error: Aborting staging');
2445: retcode := 2;
2446: errbuf := errbuf || logerror || SQLERRM;
2447: FND_FILE.close;

Line 2448: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2444: outandlog('Error: Aborting staging');
2445: retcode := 2;
2446: errbuf := errbuf || logerror || SQLERRM;
2447: FND_FILE.close;
2448: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2449: outandlog('Error: Aborting staging');
2450: retcode := 2;
2451: errbuf := errbuf || logerror || SQLERRM;
2452: FND_FILE.close;

Line 2870: WHEN FND_API.G_EXC_ERROR THEN

2866: log('Concurrent Program Execution completed ');
2867: log('End Time : '|| TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
2868:
2869: EXCEPTION
2870: WHEN FND_API.G_EXC_ERROR THEN
2871: outandlog('Error: Aborting staging ' || FND_MESSAGE.GET);
2872: retcode := 2;
2873: errbuf := errbuf || logerror;
2874: FND_FILE.close;

Line 2875: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2871: outandlog('Error: Aborting staging ' || FND_MESSAGE.GET);
2872: retcode := 2;
2873: errbuf := errbuf || logerror;
2874: FND_FILE.close;
2875: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2876: outandlog('Error: Aborting staging ' || FND_MESSAGE.GET);
2877: retcode := 2;
2878: errbuf := errbuf || logerror;
2879: FND_FILE.close;

Line 3048: RAISE FND_API.G_EXC_ERROR;

3044: IF dphase <> 'COMPLETE' THEN
3045: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3046: FND_MESSAGE.SET_TOKEN('ID' ,l_req1);
3047: FND_MSG_PUB.ADD;
3048: RAISE FND_API.G_EXC_ERROR;
3049: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3050: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3051: FND_MESSAGE.SET_TOKEN('ID' ,l_req1);
3052: FND_MSG_PUB.ADD;

Line 3053: RAISE FND_API.G_EXC_ERROR;

3049: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3050: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3051: FND_MESSAGE.SET_TOKEN('ID' ,l_req1);
3052: FND_MSG_PUB.ADD;
3053: RAISE FND_API.G_EXC_ERROR;
3054: END IF;
3055: END IF;
3056: IF l_req2 <> 1 THEN
3057: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req2),

Line 3063: RAISE FND_API.G_EXC_ERROR;

3059: IF dphase <> 'COMPLETE' THEN
3060: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3061: FND_MESSAGE.SET_TOKEN('ID' ,l_req2);
3062: FND_MSG_PUB.ADD;
3063: RAISE FND_API.G_EXC_ERROR;
3064: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3065: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3066: FND_MESSAGE.SET_TOKEN('ID' ,l_req2);
3067: FND_MSG_PUB.ADD;

Line 3068: RAISE FND_API.G_EXC_ERROR;

3064: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3065: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3066: FND_MESSAGE.SET_TOKEN('ID' ,l_req2);
3067: FND_MSG_PUB.ADD;
3068: RAISE FND_API.G_EXC_ERROR;
3069: END IF;
3070: END IF;
3071: IF l_req3 <> 1 THEN
3072: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req3),

Line 3078: RAISE FND_API.G_EXC_ERROR;

3074: IF dphase <> 'COMPLETE' THEN
3075: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3076: FND_MESSAGE.SET_TOKEN('ID' ,l_req3);
3077: FND_MSG_PUB.ADD;
3078: RAISE FND_API.G_EXC_ERROR;
3079: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3080: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3081: FND_MESSAGE.SET_TOKEN('ID' ,l_req3);
3082: FND_MSG_PUB.ADD;

Line 3083: RAISE FND_API.G_EXC_ERROR;

3079: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3080: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3081: FND_MESSAGE.SET_TOKEN('ID' ,l_req3);
3082: FND_MSG_PUB.ADD;
3083: RAISE FND_API.G_EXC_ERROR;
3084: END IF;
3085: END IF;
3086: IF l_req4 <> 1 THEN
3087: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req4),

Line 3093: RAISE FND_API.G_EXC_ERROR;

3089: IF dphase <> 'COMPLETE' THEN
3090: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3091: FND_MESSAGE.SET_TOKEN('ID' ,l_req3);
3092: FND_MSG_PUB.ADD;
3093: RAISE FND_API.G_EXC_ERROR;
3094: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3095: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3096: FND_MESSAGE.SET_TOKEN('ID' ,l_req4);
3097: FND_MSG_PUB.ADD;

Line 3098: RAISE FND_API.G_EXC_ERROR;

3094: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3095: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3096: FND_MESSAGE.SET_TOKEN('ID' ,l_req4);
3097: FND_MSG_PUB.ADD;
3098: RAISE FND_API.G_EXC_ERROR;
3099: END IF;
3100: END IF;
3101: IF l_req5 <> 1 THEN
3102: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req5),

Line 3108: RAISE FND_API.G_EXC_ERROR;

3104: IF dphase <> 'COMPLETE' THEN
3105: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3106: FND_MESSAGE.SET_TOKEN('ID' ,l_req4);
3107: FND_MSG_PUB.ADD;
3108: RAISE FND_API.G_EXC_ERROR;
3109: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3110: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3111: FND_MESSAGE.SET_TOKEN('ID' ,l_req5);
3112: FND_MSG_PUB.ADD;

Line 3113: RAISE FND_API.G_EXC_ERROR;

3109: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3110: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3111: FND_MESSAGE.SET_TOKEN('ID' ,l_req5);
3112: FND_MSG_PUB.ADD;
3113: RAISE FND_API.G_EXC_ERROR;
3114: END IF;
3115: END IF;
3116: IF l_req6 <> 1 THEN
3117: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req6),

Line 3123: RAISE FND_API.G_EXC_ERROR;

3119: IF dphase <> 'COMPLETE' THEN
3120: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3121: FND_MESSAGE.SET_TOKEN('ID' ,l_req5);
3122: FND_MSG_PUB.ADD;
3123: RAISE FND_API.G_EXC_ERROR;
3124: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3125: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3126: FND_MESSAGE.SET_TOKEN('ID' ,l_req6);
3127: FND_MSG_PUB.ADD;

Line 3128: RAISE FND_API.G_EXC_ERROR;

3124: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3125: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3126: FND_MESSAGE.SET_TOKEN('ID' ,l_req6);
3127: FND_MSG_PUB.ADD;
3128: RAISE FND_API.G_EXC_ERROR;
3129: END IF;
3130: END IF;
3131: IF l_req7 <> 1 THEN
3132: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req7),

Line 3138: RAISE FND_API.G_EXC_ERROR;

3134: IF dphase <> 'COMPLETE' THEN
3135: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3136: FND_MESSAGE.SET_TOKEN('ID' ,l_req6);
3137: FND_MSG_PUB.ADD;
3138: RAISE FND_API.G_EXC_ERROR;
3139: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3140: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3141: FND_MESSAGE.SET_TOKEN('ID' ,l_req7);
3142: FND_MSG_PUB.ADD;

Line 3143: RAISE FND_API.G_EXC_ERROR;

3139: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3140: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3141: FND_MESSAGE.SET_TOKEN('ID' ,l_req7);
3142: FND_MSG_PUB.ADD;
3143: RAISE FND_API.G_EXC_ERROR;
3144: END IF;
3145: END IF;
3146: IF l_req8 <> 1 THEN
3147: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req8),

Line 3153: RAISE FND_API.G_EXC_ERROR;

3149: IF dphase <> 'COMPLETE' THEN
3150: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3151: FND_MESSAGE.SET_TOKEN('ID' ,l_req8);
3152: FND_MSG_PUB.ADD;
3153: RAISE FND_API.G_EXC_ERROR;
3154: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3155: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3156: FND_MESSAGE.SET_TOKEN('ID' ,l_req8);
3157: FND_MSG_PUB.ADD;

Line 3158: RAISE FND_API.G_EXC_ERROR;

3154: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3155: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3156: FND_MESSAGE.SET_TOKEN('ID' ,l_req8);
3157: FND_MSG_PUB.ADD;
3158: RAISE FND_API.G_EXC_ERROR;
3159: END IF;
3160: END IF;
3161: IF l_req9 <> 1 THEN
3162: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req9),

Line 3168: RAISE FND_API.G_EXC_ERROR;

3164: IF dphase <> 'COMPLETE' THEN
3165: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3166: FND_MESSAGE.SET_TOKEN('ID' ,l_req9);
3167: FND_MSG_PUB.ADD;
3168: RAISE FND_API.G_EXC_ERROR;
3169: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3170: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3171: FND_MESSAGE.SET_TOKEN('ID' ,l_req9);
3172: FND_MSG_PUB.ADD;

Line 3173: RAISE FND_API.G_EXC_ERROR;

3169: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3170: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3171: FND_MESSAGE.SET_TOKEN('ID' ,l_req9);
3172: FND_MSG_PUB.ADD;
3173: RAISE FND_API.G_EXC_ERROR;
3174: END IF;
3175: END IF;
3176: IF l_req10 <> 1 THEN
3177: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req10),

Line 3183: RAISE FND_API.G_EXC_ERROR;

3179: IF dphase <> 'COMPLETE' THEN
3180: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3181: FND_MESSAGE.SET_TOKEN('ID' ,l_req10);
3182: FND_MSG_PUB.ADD;
3183: RAISE FND_API.G_EXC_ERROR;
3184: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3185: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3186: FND_MESSAGE.SET_TOKEN('ID' ,l_req10);
3187: FND_MSG_PUB.ADD;

Line 3188: RAISE FND_API.G_EXC_ERROR;

3184: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3185: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3186: FND_MESSAGE.SET_TOKEN('ID' ,l_req10);
3187: FND_MSG_PUB.ADD;
3188: RAISE FND_API.G_EXC_ERROR;
3189: END IF;
3190: END IF;
3191: EXCEPTION
3192: WHEN FND_API.G_EXC_ERROR THEN

Line 3192: WHEN FND_API.G_EXC_ERROR THEN

3188: RAISE FND_API.G_EXC_ERROR;
3189: END IF;
3190: END IF;
3191: EXCEPTION
3192: WHEN FND_API.G_EXC_ERROR THEN
3193: RAISE FND_API.G_EXC_ERROR;
3194: WHEN OTHERS THEN
3195: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
3196: FND_MESSAGE.SET_TOKEN('PROC' ,'Index Creation Worker Completion Check');

Line 3193: RAISE FND_API.G_EXC_ERROR;

3189: END IF;
3190: END IF;
3191: EXCEPTION
3192: WHEN FND_API.G_EXC_ERROR THEN
3193: RAISE FND_API.G_EXC_ERROR;
3194: WHEN OTHERS THEN
3195: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
3196: FND_MESSAGE.SET_TOKEN('PROC' ,'Index Creation Worker Completion Check');
3197: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 3199: RAISE FND_API.G_EXC_ERROR;

3195: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
3196: FND_MESSAGE.SET_TOKEN('PROC' ,'Index Creation Worker Completion Check');
3197: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3198: FND_MSG_PUB.ADD;
3199: RAISE FND_API.G_EXC_ERROR;
3200: END;
3201:
3202: COMMIT;
3203: log('Workers have completed successfully');

Line 3950: WHEN FND_API.G_EXC_ERROR THEN

3946: log('Concurrent Program Execution completed ');
3947: log('End Time : '|| TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
3948:
3949: EXCEPTION
3950: WHEN FND_API.G_EXC_ERROR THEN
3951: outandlog('Error: ' || FND_MESSAGE.GET);
3952: log('Error ' || SQLERRM);
3953: retcode := 2;
3954: errbuf := errbuf || logerror;

Line 3957: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3953: retcode := 2;
3954: errbuf := errbuf || logerror;
3955: outandlog('Aborting concurrent program execution');
3956: FND_FILE.close;
3957: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3958: outandlog('Error: ' || FND_MESSAGE.GET);
3959: log('Error ' || SQLERRM);
3960: retcode := 2;
3961: errbuf := errbuf || logerror;

Line 4100: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

4096: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MAP_PROC_ERROR'');');
4097: l(' FND_MESSAGE.SET_TOKEN(''PROC'' ,''' || p_proc_name||''');');
4098: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
4099: l(' FND_MSG_PUB.ADD;');
4100: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
4101:
4102: l('END;');
4103:
4104: EXCEPTION

Line 4110: RAISE FND_API.G_EXC_ERROR;

4106: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
4107: FND_MESSAGE.SET_TOKEN('PROC' ,'generate_transform_proc');
4108: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4109: FND_MSG_PUB.ADD;
4110: RAISE FND_API.G_EXC_ERROR;
4111: END;
4112:
4113: PROCEDURE generate_declarations IS
4114:

Line 11508: RAISE FND_API.G_EXC_ERROR;

11504: END LOOP;
11505: EXCEPTION
11506: WHEN OTHERS THEN
11507: dbms_sql.close_cursor(c);
11508: RAISE FND_API.G_EXC_ERROR;
11509: END ;
11510:
11511:
11512:

Line 11569: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );

11565: BEGIN
11566: FND_MSG_PUB.Reset;
11567:
11568: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
11569: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
11570: END LOOP;
11571: IF (SQLERRM IS NOT NULL) THEN
11572: l_msg_data := l_msg_data || SQLERRM;
11573: END IF;