DBA Data[Home] [Help]

APPS.HZ_PARTY_STAGE dependencies on FND_MSG_PUB

Line 1377: FND_MSG_PUB.initialize;

1373: outandlog('NEWLINE');
1374:
1375: l_command:=p_command;
1376: l_continue:=nvl(p_continue,'N');
1377: FND_MSG_PUB.initialize;
1378:
1379: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_index_owner);
1380:
1381: IF l_command = 'ESTIMATE_SIZE' THEN

Line 2565: FND_MSG_PUB.initialize;

2561:
2562: log('');
2563: log('Stage Parties begin');
2564:
2565: FND_MSG_PUB.initialize;
2566: HZ_TRANS_PKG.set_staging_context('Y');
2567: IF p_command='STAGE_ALL_DATA' THEN
2568:
2569: SELECT SYSDATE INTO l_startdate FROM DUAL;

Line 3167: FND_MSG_PUB.ADD;

3163: 30, 144000, uphase, ustatus, dphase, dstatus, message);
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);

Line 3172: 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;
3173: RAISE FND_API.G_EXC_ERROR;
3174: END IF;
3175: END IF;
3176: IF l_req2 <> 1 THEN

Line 3182: FND_MSG_PUB.ADD;

3178: 30, 144000, uphase, ustatus, dphase, dstatus, message);
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);

Line 3187: 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;
3188: RAISE FND_API.G_EXC_ERROR;
3189: END IF;
3190: END IF;
3191: IF l_req3 <> 1 THEN

Line 3197: FND_MSG_PUB.ADD;

3193: 30, 144000, uphase, ustatus, dphase, dstatus, message);
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);

Line 3202: 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;
3203: RAISE FND_API.G_EXC_ERROR;
3204: END IF;
3205: END IF;
3206: IF l_req4 <> 1 THEN

Line 3212: FND_MSG_PUB.ADD;

3208: 30, 144000, uphase, ustatus, dphase, dstatus, message);
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);

Line 3217: 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;
3218: RAISE FND_API.G_EXC_ERROR;
3219: END IF;
3220: END IF;
3221: IF l_req5 <> 1 THEN

Line 3227: FND_MSG_PUB.ADD;

3223: 30, 144000, uphase, ustatus, dphase, dstatus, message);
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);

Line 3232: 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;
3233: RAISE FND_API.G_EXC_ERROR;
3234: END IF;
3235: END IF;
3236: IF l_req6 <> 1 THEN

Line 3242: FND_MSG_PUB.ADD;

3238: 30, 144000, uphase, ustatus, dphase, dstatus, message);
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);

Line 3247: 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;
3248: RAISE FND_API.G_EXC_ERROR;
3249: END IF;
3250: END IF;
3251: IF l_req7 <> 1 THEN

Line 3257: FND_MSG_PUB.ADD;

3253: 30, 144000, uphase, ustatus, dphase, dstatus, message);
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);

Line 3262: 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;
3263: RAISE FND_API.G_EXC_ERROR;
3264: END IF;
3265: END IF;
3266: IF l_req8 <> 1 THEN

Line 3272: FND_MSG_PUB.ADD;

3268: 30, 144000, uphase, ustatus, dphase, dstatus, message);
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);

Line 3277: 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;
3278: RAISE FND_API.G_EXC_ERROR;
3279: END IF;
3280: END IF;
3281: IF l_req9 <> 1 THEN

Line 3287: FND_MSG_PUB.ADD;

3283: 30, 144000, uphase, ustatus, dphase, dstatus, message);
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);

Line 3292: 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;
3293: RAISE FND_API.G_EXC_ERROR;
3294: END IF;
3295: END IF;
3296: IF l_req10 <> 1 THEN

Line 3302: FND_MSG_PUB.ADD;

3298: 30, 144000, uphase, ustatus, dphase, dstatus, message);
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);

Line 3307: 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;
3308: RAISE FND_API.G_EXC_ERROR;
3309: END IF;
3310: END IF;
3311: EXCEPTION

Line 3318: FND_MSG_PUB.ADD;

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);
3318: FND_MSG_PUB.ADD;
3319: RAISE FND_API.G_EXC_ERROR;
3320: END;
3321:
3322: COMMIT;

Line 4227: l(' FND_MSG_PUB.ADD;');

4223: l(' WHEN OTHERS THEN');
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:

Line 4237: FND_MSG_PUB.ADD;

4233: WHEN OTHERS THEN
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

Line 11630: FND_MSG_PUB.ADD;

11626: FND_MESSAGE.SET_TOKEN('PROC' ,l_procedure);
11627: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_entity);
11628: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attribute);
11629: FND_MESSAGE.SET_TOKEN('TRANS' ,l_trans_name);
11630: FND_MSG_PUB.ADD;
11631: END;
11632: END LOOP;
11633: FOR FUNCS IN (SELECT custom_attribute_procedure, ENTITY_NAME, ATTRIBUTE_NAME
11634: FROM HZ_TRANS_ATTRIBUTES_VL a

Line 11656: FND_MSG_PUB.ADD;

11652: FND_MESSAGE.SET_NAME('AR', 'HZ_CUSTOM_PROC_ERROR1');
11653: FND_MESSAGE.SET_TOKEN('PROC' ,l_procedure);
11654: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_entity);
11655: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attribute);
11656: FND_MSG_PUB.ADD;
11657: END;
11658: END LOOP;
11659: EXCEPTION
11660: WHEN OTHERS THEN

Line 11720: FND_MSG_PUB.Reset;

11716: RETURN VARCHAR2 IS
11717:
11718: l_msg_data VARCHAR2(2000);
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;

Line 11722: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

11718: l_msg_data VARCHAR2(2000);
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;

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;