DBA Data[Home] [Help]

APPS.HZ_PARTY_STAGE_SHADOW dependencies on FND_API

Line 1384: WHEN FND_API.G_EXC_ERROR THEN

1380: outandlog('Concurrent Program Execution completed ');
1381: outandlog('End Time : '|| TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
1382:
1383: EXCEPTION
1384: WHEN FND_API.G_EXC_ERROR THEN
1385: outandlog('Error: Aborting staging');
1386: retcode := 2;
1387: errbuf := errbuf || logerror || SQLERRM;
1388: FND_FILE.close;

Line 1389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1385: outandlog('Error: Aborting staging');
1386: retcode := 2;
1387: errbuf := errbuf || logerror || SQLERRM;
1388: FND_FILE.close;
1389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1390: outandlog('Error: Aborting staging');
1391: retcode := 2;
1392: errbuf := errbuf || logerror || SQLERRM;
1393: FND_FILE.close;

Line 1612: WHEN FND_API.G_EXC_ERROR THEN

1608: log('Concurrent Program Execution completed ');
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;

Line 1617: WHEN FND_API.G_EXC_UNEXPECTED_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
1618: outandlog('Error: Aborting staging ' || FND_MESSAGE.GET);
1619: retcode := 2;
1620: errbuf := errbuf || logerror;
1621: FND_FILE.close;

Line 2073: WHEN FND_API.G_EXC_ERROR THEN

2069: log('Concurrent Program Execution completed ');
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;

Line 2080: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2076: retcode := 2;
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;

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

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

Line 2233: RAISE FND_API.G_EXC_ERROR;

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
2237:

Line 4553: RAISE FND_API.G_EXC_ERROR;

4549: END LOOP;
4550: EXCEPTION
4551: WHEN OTHERS THEN
4552: dbms_sql.close_cursor(c);
4553: RAISE FND_API.G_EXC_ERROR;
4554: END ;
4555:
4556:
4557:

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;