DBA Data[Home] [Help]

APPS.HZ_PARTY_STAGE_SHADOW dependencies on FND_MSG_PUB

Line 911: FND_MSG_PUB.initialize;

907: outandlog('Start Time ' || TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
908: outandlog('NEWLINE');
909:
910:
911: FND_MSG_PUB.initialize;
912:
913:
914: IF l_command = 'STAGE_ALL_DATA' THEN
915: BEGIN

Line 1467: FND_MSG_PUB.initialize;

1463: log('This worker stages all parties whose party_id/10 produces a remainder equal to the worker number ');
1464: log('');
1465: log('Stage Parties begin');
1466:
1467: FND_MSG_PUB.initialize;
1468: HZ_TRANS_PKG.set_staging_context('Y');
1469:
1470: SELECT SYSDATE INTO l_startdate FROM DUAL;
1471:

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

2218: l(' WHEN OTHERS THEN');
2219: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MAP_PROC_ERROR'');');
2220: l(' FND_MESSAGE.SET_TOKEN(''PROC'' ,''' || p_proc_name||''');');
2221: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
2222: l(' FND_MSG_PUB.ADD;');
2223: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
2224:
2225: l('END;');
2226:

Line 2232: FND_MSG_PUB.ADD;

2228: WHEN OTHERS THEN
2229: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
2230: FND_MESSAGE.SET_TOKEN('PROC' ,'generate_transform_proc');
2231: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2232: FND_MSG_PUB.ADD;
2233: RAISE FND_API.G_EXC_ERROR;
2234: END;
2235:
2236: PROCEDURE generate_declarations IS

Line 4521: FND_MSG_PUB.ADD;

4517: FND_MESSAGE.SET_TOKEN('PROC' ,l_procedure);
4518: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_entity);
4519: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attribute);
4520: FND_MESSAGE.SET_TOKEN('TRANS' ,l_trans_name);
4521: FND_MSG_PUB.ADD;
4522: END;
4523: END LOOP;
4524: FOR FUNCS IN (SELECT custom_attribute_procedure, ENTITY_NAME, ATTRIBUTE_NAME
4525: FROM HZ_TRANS_ATTRIBUTES_VL a

Line 4547: FND_MSG_PUB.ADD;

4543: FND_MESSAGE.SET_NAME('AR', 'HZ_CUSTOM_PROC_ERROR1');
4544: FND_MESSAGE.SET_TOKEN('PROC' ,l_procedure);
4545: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_entity);
4546: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attribute);
4547: FND_MSG_PUB.ADD;
4548: END;
4549: END LOOP;
4550: EXCEPTION
4551: WHEN OTHERS THEN

Line 4611: FND_MSG_PUB.Reset;

4607: RETURN VARCHAR2 IS
4608:
4609: l_msg_data VARCHAR2(2000);
4610: BEGIN
4611: FND_MSG_PUB.Reset;
4612:
4613: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
4614: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
4615: END LOOP;

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

4609: l_msg_data VARCHAR2(2000);
4610: BEGIN
4611: FND_MSG_PUB.Reset;
4612:
4613: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
4614: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
4615: END LOOP;
4616: IF (SQLERRM IS NOT NULL) THEN
4617: l_msg_data := l_msg_data || SQLERRM;

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

4610: BEGIN
4611: FND_MSG_PUB.Reset;
4612:
4613: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
4614: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
4615: END LOOP;
4616: IF (SQLERRM IS NOT NULL) THEN
4617: l_msg_data := l_msg_data || SQLERRM;
4618: END IF;