DBA Data[Home] [Help]

APPS.HZ_PARTY_STAGE_SHADOW dependencies on FND_MESSAGE

Line 1041: log(fnd_message.get);

1037: to_char(sysdate,'DD-MON-YY HH:MI:SS'),
1038: TRUE, to_char(l_num_workers), TO_CHAR(I), l_command,l_continue);
1039: IF l_sub_requests(i) = 0 THEN
1040: log('Error submitting worker ' || i);
1041: log(fnd_message.get);
1042: ELSE
1043: log('Submitted request for Worker ' || TO_CHAR(I) );
1044: log('Request ID : ' || l_sub_requests(i));
1045: END IF;

Line 1315: log(fnd_message.get);

1311: 'DQM Create Index On Thin Tables', to_char(sysdate,'DD-MON-YY HH:MI:SS'),
1312: TRUE, l_command, l_idx_mem, l_num_prll, l_index);
1313: IF l_req_id = 0 THEN
1314: log('Error submitting request');
1315: log(fnd_message.get);
1316: ELSE
1317: log('Submitted request ID for '||l_index||': ' || l_req_id );
1318: log('Request ID : ' || l_req_id);
1319: END IF;

Line 1395: log(fnd_message.get);

1391: retcode := 2;
1392: errbuf := errbuf || logerror || SQLERRM;
1393: FND_FILE.close;
1394: WHEN OTHERS THEN
1395: log(fnd_message.get);
1396: outandlog('Error: Aborting staging');
1397: outandlog(SQLERRM);
1398: retcode := 2;
1399: errbuf := errbuf || logerror || SQLERRM;

Line 1613: outandlog('Error: Aborting staging ' || FND_MESSAGE.GET);

1609: log('End Time : '|| TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
1610:
1611: EXCEPTION
1612: WHEN FND_API.G_EXC_ERROR THEN
1613: outandlog('Error: Aborting staging ' || FND_MESSAGE.GET);
1614: retcode := 2;
1615: errbuf := errbuf || logerror;
1616: FND_FILE.close;
1617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1618: outandlog('Error: Aborting staging ' || FND_MESSAGE.GET);

1614: retcode := 2;
1615: errbuf := errbuf || logerror;
1616: FND_FILE.close;
1617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1618: outandlog('Error: Aborting staging ' || FND_MESSAGE.GET);
1619: retcode := 2;
1620: errbuf := errbuf || logerror;
1621: FND_FILE.close;
1622: WHEN OTHERS THEN

Line 2074: outandlog('Error: ' || FND_MESSAGE.GET);

2070: log('End Time : '|| TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
2071:
2072: EXCEPTION
2073: WHEN FND_API.G_EXC_ERROR THEN
2074: outandlog('Error: ' || FND_MESSAGE.GET);
2075: log('Error ' || SQLERRM);
2076: retcode := 2;
2077: errbuf := errbuf || logerror;
2078: outandlog('Aborting concurrent program execution');

Line 2081: outandlog('Error: ' || FND_MESSAGE.GET);

2077: errbuf := errbuf || logerror;
2078: outandlog('Aborting concurrent program execution');
2079: FND_FILE.close;
2080: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2081: outandlog('Error: ' || FND_MESSAGE.GET);
2082: log('Error ' || SQLERRM);
2083: retcode := 2;
2084: errbuf := errbuf || logerror;
2085: outandlog('Aborting concurrent program execution');

Line 2088: outandlog('Error: ' || FND_MESSAGE.GET);

2084: errbuf := errbuf || logerror;
2085: outandlog('Aborting concurrent program execution');
2086: FND_FILE.close;
2087: WHEN OTHERS THEN
2088: outandlog('Error: ' || FND_MESSAGE.GET);
2089: log('SQL Error ' || SQLERRM);
2090: retcode := 2;
2091: errbuf := errbuf || logerror || SQLERRM;
2092: outandlog('Aborting concurrent program execution');

Line 2219: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MAP_PROC_ERROR'');');

2215:
2216: l(' RETURN l_stage_rec;');
2217: l('EXCEPTION');
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;');

Line 2220: l(' FND_MESSAGE.SET_TOKEN(''PROC'' ,''' || p_proc_name||''');');

2216: l(' RETURN l_stage_rec;');
2217: l('EXCEPTION');
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:

Line 2221: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');

2217: l('EXCEPTION');
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;');

Line 2229: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');

2225: l('END;');
2226:
2227: EXCEPTION
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;

Line 2230: FND_MESSAGE.SET_TOKEN('PROC' ,'generate_transform_proc');

2226:
2227: EXCEPTION
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;

Line 2231: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

2227: EXCEPTION
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:

Line 4516: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANS_PROC_ERROR1');

4512: '(:attrval,:lang,:attr,:entity) from dual';
4513: dbms_sql.parse(c,l_sql,2);
4514: dbms_sql.close_cursor(c);
4515: EXCEPTION WHEN OTHERS THEN
4516: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANS_PROC_ERROR1');
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);

Line 4517: FND_MESSAGE.SET_TOKEN('PROC' ,l_procedure);

4513: dbms_sql.parse(c,l_sql,2);
4514: dbms_sql.close_cursor(c);
4515: EXCEPTION WHEN OTHERS THEN
4516: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANS_PROC_ERROR1');
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;

Line 4518: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_entity);

4514: dbms_sql.close_cursor(c);
4515: EXCEPTION WHEN OTHERS THEN
4516: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANS_PROC_ERROR1');
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;

Line 4519: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attribute);

4515: EXCEPTION WHEN OTHERS THEN
4516: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANS_PROC_ERROR1');
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;

Line 4520: FND_MESSAGE.SET_TOKEN('TRANS' ,l_trans_name);

4516: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANS_PROC_ERROR1');
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

Line 4543: FND_MESSAGE.SET_NAME('AR', 'HZ_CUSTOM_PROC_ERROR1');

4539: '(:record_id,:entity,:attr) from dual';
4540: dbms_sql.parse(c,l_sql,2);
4541: dbms_sql.close_cursor(c);
4542: EXCEPTION WHEN OTHERS THEN
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;

Line 4544: FND_MESSAGE.SET_TOKEN('PROC' ,l_procedure);

4540: dbms_sql.parse(c,l_sql,2);
4541: dbms_sql.close_cursor(c);
4542: EXCEPTION WHEN OTHERS THEN
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;

Line 4545: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_entity);

4541: dbms_sql.close_cursor(c);
4542: EXCEPTION WHEN OTHERS THEN
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;

Line 4546: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attribute);

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