DBA Data[Home] [Help]

APPS.PV_TERR_ASSIGN_PUB dependencies on FND_CONCURRENT

Line 5766: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);

5762: ROLLBACK TO Assign_Channel_Team_Pvt;
5763: --RETCODE := FND_API.G_RET_STS_ERROR;
5764: l_err_mesg := 'SQLCODE ' || to_char(SQLCODE) || ' SQLERRM ' || substr(SQLERRM, 1, 100);
5765: --ERRBUF := l_err_mesg ;
5766: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);
5767: Write_log (1, l_err_mesg);
5768:
5769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5770: ROLLBACK TO Assign_Channel_Team_Pvt;

Line 5774: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);

5770: ROLLBACK TO Assign_Channel_Team_Pvt;
5771: --RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
5772: l_err_mesg := 'SQLCODE ' || to_char(SQLCODE) || ' SQLERRM ' || substr(SQLERRM, 1, 100);
5773: --ERRBUF := l_err_mesg ;
5774: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);
5775: Write_log (1, l_err_mesg);
5776:
5777: WHEN OTHERS THEN
5778: ROLLBACK TO Assign_Channel_Team_Pvt;

Line 5782: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);

5778: ROLLBACK TO Assign_Channel_Team_Pvt;
5779: --RETCODE := '2';
5780: l_err_mesg := 'SQLCODE ' || to_char(SQLCODE) || ' SQLERRM ' || substr(SQLERRM, 1, 100);
5781: --ERRBUF := l_err_mesg ;
5782: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);
5783: Write_log (1, l_err_mesg);
5784:
5785: END do_Channel_Team_Assignment;
5786:

Line 5944: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', SQLERRM);

5940: x_error_count => l_partner_err_cnt);
5941:
5942: IF (l_partner_err_cnt > 0) THEN
5943: RETCODE := FND_API.G_RET_STS_ERROR;
5944: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', SQLERRM);
5945: END IF;
5946:
5947:
5948:

Line 6027: l_wait_status := FND_CONCURRENT.WAIT_FOR_REQUEST (

6023: --Wait for children to finish
6024: FOR child_idx IN 1 .. l_request_id_tbl.count
6025: LOOP
6026:
6027: l_wait_status := FND_CONCURRENT.WAIT_FOR_REQUEST (
6028: request_id => l_request_id_tbl(child_idx),
6029: phase => x_phase,
6030: status => x_status,
6031: dev_phase => x_dev_phase,

Line 6072: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);

6068: ROLLBACK TO Assign_Channel_Team_Pvt;
6069: RETCODE := FND_API.G_RET_STS_ERROR;
6070: l_err_mesg := 'SQLCODE ' || to_char(SQLCODE) || ' SQLERRM ' || substr(SQLERRM, 1, 100);
6071: ERRBUF := l_err_mesg ;
6072: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);
6073: Write_log (1, l_err_mesg);
6074:
6075: END Assign_Channel_Team;
6076:

Line 6486: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', SQLERRM);

6482: Write_log (1, substrb(fnd_message.get, 1, 1000));
6483:
6484: IF (l_partner_err_cnt > 0) THEN
6485: RETCODE := FND_API.G_RET_STS_ERROR;
6486: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', SQLERRM);
6487: END IF;
6488:
6489:
6490: COMMIT;

Line 6501: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);

6497: ROLLBACK TO Process_Sub_Territories_Pvt;
6498: RETCODE := FND_API.G_RET_STS_ERROR;
6499: l_err_mesg := 'SQLCODE ' || to_char(SQLCODE) || ' SQLERRM ' || substr(SQLERRM, 1, 100);
6500: ERRBUF := l_err_mesg ;
6501: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);
6502: Write_log (1, l_err_mesg);
6503:
6504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6505: IF l_batch_partners_csr%ISOPEN THEN

Line 6512: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);

6508: ROLLBACK TO Process_Sub_Territories_Pvt;
6509: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
6510: l_err_mesg := 'SQLCODE ' || to_char(SQLCODE) || ' SQLERRM ' || substr(SQLERRM, 1, 100);
6511: ERRBUF := l_err_mesg ;
6512: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);
6513: Write_log (1, l_err_mesg);
6514:
6515: WHEN OTHERS THEN
6516: IF l_batch_partners_csr%ISOPEN THEN

Line 6524: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);

6520: ROLLBACK TO Process_Sub_Territories_Pvt;
6521: RETCODE := '2';
6522: l_err_mesg := 'SQLCODE ' || to_char(SQLCODE) || ' SQLERRM ' || substr(SQLERRM, 1, 100);
6523: ERRBUF := l_err_mesg ;
6524: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);
6525: Write_log (1, l_err_mesg);
6526:
6527: END Process_Sub_Territories;
6528: