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 2461: WHEN FND_API.G_EXC_ERROR THEN

2457: END IF;
2458: --End of Bug No : 4292425
2459:
2460: EXCEPTION
2461: WHEN FND_API.G_EXC_ERROR THEN
2462: outandlog('Error: Aborting staging');
2463: retcode := 2;
2464: errbuf := errbuf || logerror || SQLERRM;
2465: FND_FILE.close;

Line 2466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2462: outandlog('Error: Aborting staging');
2463: retcode := 2;
2464: errbuf := errbuf || logerror || SQLERRM;
2465: FND_FILE.close;
2466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2467: outandlog('Error: Aborting staging');
2468: retcode := 2;
2469: errbuf := errbuf || logerror || SQLERRM;
2470: FND_FILE.close;

Line 2985: WHEN FND_API.G_EXC_ERROR THEN

2981: log('Concurrent Program Execution completed ');
2982: log('End Time : '|| TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
2983:
2984: EXCEPTION
2985: WHEN FND_API.G_EXC_ERROR THEN
2986: outandlog('Error: Aborting staging ' || FND_MESSAGE.GET);
2987: retcode := 2;
2988: errbuf := errbuf || logerror;
2989: FND_FILE.close;

Line 2990: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2986: outandlog('Error: Aborting staging ' || FND_MESSAGE.GET);
2987: retcode := 2;
2988: errbuf := errbuf || logerror;
2989: FND_FILE.close;
2990: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2991: outandlog('Error: Aborting staging ' || FND_MESSAGE.GET);
2992: retcode := 2;
2993: errbuf := errbuf || logerror;
2994: FND_FILE.close;

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_req1);
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_req1);
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_req1);
3172: FND_MSG_PUB.ADD;
3173: RAISE FND_API.G_EXC_ERROR;
3174: END IF;
3175: END IF;
3176: IF l_req2 <> 1 THEN
3177: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req2),

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_req2);
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_req2);
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_req2);
3187: FND_MSG_PUB.ADD;
3188: RAISE FND_API.G_EXC_ERROR;
3189: END IF;
3190: END IF;
3191: IF l_req3 <> 1 THEN
3192: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req3),

Line 3198: RAISE FND_API.G_EXC_ERROR;

3194: IF dphase <> 'COMPLETE' THEN
3195: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3196: FND_MESSAGE.SET_TOKEN('ID' ,l_req3);
3197: FND_MSG_PUB.ADD;
3198: RAISE FND_API.G_EXC_ERROR;
3199: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3200: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3201: FND_MESSAGE.SET_TOKEN('ID' ,l_req3);
3202: FND_MSG_PUB.ADD;

Line 3203: RAISE FND_API.G_EXC_ERROR;

3199: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3200: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3201: FND_MESSAGE.SET_TOKEN('ID' ,l_req3);
3202: FND_MSG_PUB.ADD;
3203: RAISE FND_API.G_EXC_ERROR;
3204: END IF;
3205: END IF;
3206: IF l_req4 <> 1 THEN
3207: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req4),

Line 3213: RAISE FND_API.G_EXC_ERROR;

3209: IF dphase <> 'COMPLETE' THEN
3210: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3211: FND_MESSAGE.SET_TOKEN('ID' ,l_req3);
3212: FND_MSG_PUB.ADD;
3213: RAISE FND_API.G_EXC_ERROR;
3214: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3215: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3216: FND_MESSAGE.SET_TOKEN('ID' ,l_req4);
3217: FND_MSG_PUB.ADD;

Line 3218: RAISE FND_API.G_EXC_ERROR;

3214: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3215: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3216: FND_MESSAGE.SET_TOKEN('ID' ,l_req4);
3217: FND_MSG_PUB.ADD;
3218: RAISE FND_API.G_EXC_ERROR;
3219: END IF;
3220: END IF;
3221: IF l_req5 <> 1 THEN
3222: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req5),

Line 3228: RAISE FND_API.G_EXC_ERROR;

3224: IF dphase <> 'COMPLETE' THEN
3225: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3226: FND_MESSAGE.SET_TOKEN('ID' ,l_req4);
3227: FND_MSG_PUB.ADD;
3228: RAISE FND_API.G_EXC_ERROR;
3229: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3230: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3231: FND_MESSAGE.SET_TOKEN('ID' ,l_req5);
3232: FND_MSG_PUB.ADD;

Line 3233: RAISE FND_API.G_EXC_ERROR;

3229: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3230: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3231: FND_MESSAGE.SET_TOKEN('ID' ,l_req5);
3232: FND_MSG_PUB.ADD;
3233: RAISE FND_API.G_EXC_ERROR;
3234: END IF;
3235: END IF;
3236: IF l_req6 <> 1 THEN
3237: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req6),

Line 3243: RAISE FND_API.G_EXC_ERROR;

3239: IF dphase <> 'COMPLETE' THEN
3240: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3241: FND_MESSAGE.SET_TOKEN('ID' ,l_req5);
3242: FND_MSG_PUB.ADD;
3243: RAISE FND_API.G_EXC_ERROR;
3244: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3245: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3246: FND_MESSAGE.SET_TOKEN('ID' ,l_req6);
3247: FND_MSG_PUB.ADD;

Line 3248: RAISE FND_API.G_EXC_ERROR;

3244: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3245: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3246: FND_MESSAGE.SET_TOKEN('ID' ,l_req6);
3247: FND_MSG_PUB.ADD;
3248: RAISE FND_API.G_EXC_ERROR;
3249: END IF;
3250: END IF;
3251: IF l_req7 <> 1 THEN
3252: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req7),

Line 3258: RAISE FND_API.G_EXC_ERROR;

3254: IF dphase <> 'COMPLETE' THEN
3255: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3256: FND_MESSAGE.SET_TOKEN('ID' ,l_req6);
3257: FND_MSG_PUB.ADD;
3258: RAISE FND_API.G_EXC_ERROR;
3259: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3260: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3261: FND_MESSAGE.SET_TOKEN('ID' ,l_req7);
3262: FND_MSG_PUB.ADD;

Line 3263: RAISE FND_API.G_EXC_ERROR;

3259: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3260: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3261: FND_MESSAGE.SET_TOKEN('ID' ,l_req7);
3262: FND_MSG_PUB.ADD;
3263: RAISE FND_API.G_EXC_ERROR;
3264: END IF;
3265: END IF;
3266: IF l_req8 <> 1 THEN
3267: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req8),

Line 3273: RAISE FND_API.G_EXC_ERROR;

3269: IF dphase <> 'COMPLETE' THEN
3270: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3271: FND_MESSAGE.SET_TOKEN('ID' ,l_req8);
3272: FND_MSG_PUB.ADD;
3273: RAISE FND_API.G_EXC_ERROR;
3274: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3275: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3276: FND_MESSAGE.SET_TOKEN('ID' ,l_req8);
3277: FND_MSG_PUB.ADD;

Line 3278: RAISE FND_API.G_EXC_ERROR;

3274: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3275: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3276: FND_MESSAGE.SET_TOKEN('ID' ,l_req8);
3277: FND_MSG_PUB.ADD;
3278: RAISE FND_API.G_EXC_ERROR;
3279: END IF;
3280: END IF;
3281: IF l_req9 <> 1 THEN
3282: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req9),

Line 3288: RAISE FND_API.G_EXC_ERROR;

3284: IF dphase <> 'COMPLETE' THEN
3285: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3286: FND_MESSAGE.SET_TOKEN('ID' ,l_req9);
3287: FND_MSG_PUB.ADD;
3288: RAISE FND_API.G_EXC_ERROR;
3289: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3290: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3291: FND_MESSAGE.SET_TOKEN('ID' ,l_req9);
3292: FND_MSG_PUB.ADD;

Line 3293: RAISE FND_API.G_EXC_ERROR;

3289: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3290: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3291: FND_MESSAGE.SET_TOKEN('ID' ,l_req9);
3292: FND_MSG_PUB.ADD;
3293: RAISE FND_API.G_EXC_ERROR;
3294: END IF;
3295: END IF;
3296: IF l_req10 <> 1 THEN
3297: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req10),

Line 3303: RAISE FND_API.G_EXC_ERROR;

3299: IF dphase <> 'COMPLETE' THEN
3300: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3301: FND_MESSAGE.SET_TOKEN('ID' ,l_req10);
3302: FND_MSG_PUB.ADD;
3303: RAISE FND_API.G_EXC_ERROR;
3304: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3305: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3306: FND_MESSAGE.SET_TOKEN('ID' ,l_req10);
3307: FND_MSG_PUB.ADD;

Line 3308: RAISE FND_API.G_EXC_ERROR;

3304: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3305: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3306: FND_MESSAGE.SET_TOKEN('ID' ,l_req10);
3307: FND_MSG_PUB.ADD;
3308: RAISE FND_API.G_EXC_ERROR;
3309: END IF;
3310: END IF;
3311: EXCEPTION
3312: WHEN FND_API.G_EXC_ERROR THEN

Line 3312: WHEN FND_API.G_EXC_ERROR THEN

3308: RAISE FND_API.G_EXC_ERROR;
3309: END IF;
3310: END IF;
3311: EXCEPTION
3312: WHEN FND_API.G_EXC_ERROR THEN
3313: RAISE FND_API.G_EXC_ERROR;
3314: WHEN OTHERS THEN
3315: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
3316: FND_MESSAGE.SET_TOKEN('PROC' ,'Index Creation Worker Completion Check');

Line 3313: RAISE FND_API.G_EXC_ERROR;

3309: END IF;
3310: END IF;
3311: EXCEPTION
3312: WHEN FND_API.G_EXC_ERROR THEN
3313: RAISE FND_API.G_EXC_ERROR;
3314: WHEN OTHERS THEN
3315: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
3316: FND_MESSAGE.SET_TOKEN('PROC' ,'Index Creation Worker Completion Check');
3317: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 3319: RAISE FND_API.G_EXC_ERROR;

3315: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
3316: FND_MESSAGE.SET_TOKEN('PROC' ,'Index Creation Worker Completion Check');
3317: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3318: FND_MSG_PUB.ADD;
3319: RAISE FND_API.G_EXC_ERROR;
3320: END;
3321:
3322: COMMIT;
3323: log('Workers have completed successfully');

Line 4078: WHEN FND_API.G_EXC_ERROR THEN

4074: log('Concurrent Program Execution completed ');
4075: log('End Time : '|| TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
4076:
4077: EXCEPTION
4078: WHEN FND_API.G_EXC_ERROR THEN
4079: outandlog('Error: ' || FND_MESSAGE.GET);
4080: log('Error ' || SQLERRM);
4081: retcode := 2;
4082: errbuf := errbuf || logerror;

Line 4085: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4081: retcode := 2;
4082: errbuf := errbuf || logerror;
4083: outandlog('Aborting concurrent program execution');
4084: FND_FILE.close;
4085: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4086: outandlog('Error: ' || FND_MESSAGE.GET);
4087: log('Error ' || SQLERRM);
4088: retcode := 2;
4089: errbuf := errbuf || logerror;

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

4224: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MAP_PROC_ERROR'');');
4225: l(' FND_MESSAGE.SET_TOKEN(''PROC'' ,''' || p_proc_name||''');');
4226: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
4227: l(' FND_MSG_PUB.ADD;');
4228: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
4229:
4230: l('END;');
4231:
4232: EXCEPTION

Line 4238: RAISE FND_API.G_EXC_ERROR;

4234: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
4235: FND_MESSAGE.SET_TOKEN('PROC' ,'generate_transform_proc');
4236: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4237: FND_MSG_PUB.ADD;
4238: RAISE FND_API.G_EXC_ERROR;
4239: END;
4240:
4241: PROCEDURE generate_declarations IS
4242:

Line 11662: RAISE FND_API.G_EXC_ERROR;

11658: END LOOP;
11659: EXCEPTION
11660: WHEN OTHERS THEN
11661: dbms_sql.close_cursor(c);
11662: RAISE FND_API.G_EXC_ERROR;
11663: END ;
11664:
11665:
11666:

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

11719: BEGIN
11720: FND_MSG_PUB.Reset;
11721:
11722: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
11723: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
11724: END LOOP;
11725: IF (SQLERRM IS NOT NULL) THEN
11726: l_msg_data := l_msg_data || SQLERRM;
11727: END IF;