DBA Data[Home] [Help]

APPS.HZ_PARTY_STAGE dependencies on FND_MSG_PUB

Line 1365: FND_MSG_PUB.initialize;

1361: outandlog('NEWLINE');
1362:
1363: l_command:=p_command;
1364: l_continue:=nvl(p_continue,'N');
1365: FND_MSG_PUB.initialize;
1366:
1367: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_index_owner);
1368:
1369: IF l_command = 'ESTIMATE_SIZE' THEN

Line 2534: FND_MSG_PUB.initialize;

2530:
2531: log('');
2532: log('Stage Parties begin');
2533:
2534: FND_MSG_PUB.initialize;
2535: HZ_TRANS_PKG.set_staging_context('Y');
2536: IF p_command='STAGE_ALL_DATA' THEN
2537:
2538: SELECT SYSDATE INTO l_startdate FROM DUAL;

Line 3047: FND_MSG_PUB.ADD;

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

Line 3052: 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;
3053: RAISE FND_API.G_EXC_ERROR;
3054: END IF;
3055: END IF;
3056: IF l_req2 <> 1 THEN

Line 3062: FND_MSG_PUB.ADD;

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

Line 3067: 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;
3068: RAISE FND_API.G_EXC_ERROR;
3069: END IF;
3070: END IF;
3071: IF l_req3 <> 1 THEN

Line 3077: FND_MSG_PUB.ADD;

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

Line 3082: 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;
3083: RAISE FND_API.G_EXC_ERROR;
3084: END IF;
3085: END IF;
3086: IF l_req4 <> 1 THEN

Line 3092: FND_MSG_PUB.ADD;

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

Line 3097: 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;
3098: RAISE FND_API.G_EXC_ERROR;
3099: END IF;
3100: END IF;
3101: IF l_req5 <> 1 THEN

Line 3107: FND_MSG_PUB.ADD;

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

Line 3112: 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;
3113: RAISE FND_API.G_EXC_ERROR;
3114: END IF;
3115: END IF;
3116: IF l_req6 <> 1 THEN

Line 3122: FND_MSG_PUB.ADD;

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

Line 3127: 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;
3128: RAISE FND_API.G_EXC_ERROR;
3129: END IF;
3130: END IF;
3131: IF l_req7 <> 1 THEN

Line 3137: FND_MSG_PUB.ADD;

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

Line 3142: 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;
3143: RAISE FND_API.G_EXC_ERROR;
3144: END IF;
3145: END IF;
3146: IF l_req8 <> 1 THEN

Line 3152: FND_MSG_PUB.ADD;

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

Line 3157: 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;
3158: RAISE FND_API.G_EXC_ERROR;
3159: END IF;
3160: END IF;
3161: IF l_req9 <> 1 THEN

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_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);

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_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

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_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);

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_req10);
3187: FND_MSG_PUB.ADD;
3188: RAISE FND_API.G_EXC_ERROR;
3189: END IF;
3190: END IF;
3191: EXCEPTION

Line 3198: FND_MSG_PUB.ADD;

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);
3198: FND_MSG_PUB.ADD;
3199: RAISE FND_API.G_EXC_ERROR;
3200: END;
3201:
3202: COMMIT;

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

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

Line 4109: FND_MSG_PUB.ADD;

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

Line 11476: FND_MSG_PUB.ADD;

11472: FND_MESSAGE.SET_TOKEN('PROC' ,l_procedure);
11473: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_entity);
11474: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attribute);
11475: FND_MESSAGE.SET_TOKEN('TRANS' ,l_trans_name);
11476: FND_MSG_PUB.ADD;
11477: END;
11478: END LOOP;
11479: FOR FUNCS IN (SELECT custom_attribute_procedure, ENTITY_NAME, ATTRIBUTE_NAME
11480: FROM HZ_TRANS_ATTRIBUTES_VL a

Line 11502: FND_MSG_PUB.ADD;

11498: FND_MESSAGE.SET_NAME('AR', 'HZ_CUSTOM_PROC_ERROR1');
11499: FND_MESSAGE.SET_TOKEN('PROC' ,l_procedure);
11500: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_entity);
11501: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attribute);
11502: FND_MSG_PUB.ADD;
11503: END;
11504: END LOOP;
11505: EXCEPTION
11506: WHEN OTHERS THEN

Line 11566: FND_MSG_PUB.Reset;

11562: RETURN VARCHAR2 IS
11563:
11564: l_msg_data VARCHAR2(2000);
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;

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

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

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;