DBA Data[Home] [Help]

APPS.CSTPPIPV dependencies on FND_CONCURRENT

Line 200: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_err_msg);

196: fnd_message.set_name('GMF', 'GMF_PROCESS_ORG_ERROR');
197: fnd_message.set_token('ORGCODE', l_organization_code);
198: l_err_msg := FND_MESSAGE.Get;
199: l_err_msg := substrb('CSTPIPVB : ' || l_err_msg,1,240);
200: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_err_msg);
201: fnd_file.put_line(fnd_file.log,l_err_msg);
202: RETURN;
203: END IF;
204:

Line 298: FROM fnd_concurrent_requests fcr

294:
295: BEGIN
296: SELECT fcr.request_id
297: INTO l_dummy
298: FROM fnd_concurrent_requests fcr
299: WHERE program_application_id = 702
300: AND concurrent_program_id = l_conc_program_id
301: AND phase_code IN ('I','P','R')
302: AND argument1 = TO_CHAR(p_organization_id)

Line 635: CONC_STATUS := FND_CONCURRENT.

631: l_err_msg := SUBSTR(l_err_msg,1,240);
632: FND_FILE.PUT_LINE(fnd_file.log,SUBSTR(l_err_code
633: ||' '
634: ||l_err_msg,1,240));
635: CONC_STATUS := FND_CONCURRENT.
636: SET_COMPLETION_STATUS('ERROR',l_err_msg);
637:
638:
639: WHEN CST_NO_AVG_ORG THEN

Line 653: CONC_STATUS := FND_CONCURRENT.

649: fnd_message.set_name('BOM', 'CST_NO_AVG_ORG');
650: l_err_msg := fnd_message.get;
651: l_err_msg := SUBSTR(l_err_msg,1,240);
652: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);
653: CONC_STATUS := FND_CONCURRENT.
654: SET_COMPLETION_STATUS('ERROR',l_err_msg);
655:
656:
657: WHEN CST_PROCESS_ERROR THEN

Line 663: CONC_STATUS := FND_CONCURRENT.

659: l_err_num := l_err_num;
660: l_err_code := l_err_code;
661: l_err_msg := SUBSTR(l_err_msg,1,240);
662: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);
663: CONC_STATUS := FND_CONCURRENT.
664: SET_COMPLETION_STATUS('ERROR',l_err_msg);
665:
666:
667: WHEN OTHERS THEN

Line 676: CONC_STATUS := FND_CONCURRENT.

672: || to_char(l_stmt_num)
673: || '): '
674: ||SQLERRM,1,240);
675: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);
676: CONC_STATUS := FND_CONCURRENT.
677: SET_COMPLETION_STATUS('ERROR',l_err_msg);
678:
679:
680: END trf_invoice_to_inventory;

Line 988: FROM fnd_concurrent_requests fcr

984:
985: BEGIN
986: SELECT fcr.request_id
987: INTO l_dummy
988: FROM fnd_concurrent_requests fcr
989: WHERE program_application_id = 702
990: AND concurrent_program_id = l_conc_program_id
991: AND phase_code IN ('I','P','R')
992: AND argument2 = TO_CHAR(p_organization_id)

Line 1369: CONC_STATUS := FND_CONCURRENT.

1365: l_err_msg := SUBSTR(l_err_msg,1,240);
1366: FND_FILE.PUT_LINE(fnd_file.log,SUBSTR(l_err_code
1367: ||' '
1368: ||l_err_msg,1,240));
1369: CONC_STATUS := FND_CONCURRENT.
1370: SET_COMPLETION_STATUS('ERROR',l_err_msg);
1371:
1372: WHEN CST_PROCESS_ERROR THEN
1373: ROLLBACK;

Line 1379: CONC_STATUS := FND_CONCURRENT.

1375: l_err_num := l_err_num;
1376: l_err_code := l_err_code;
1377: l_err_msg := SUBSTR(l_err_msg,1,240);
1378: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);
1379: CONC_STATUS := FND_CONCURRENT.
1380: SET_COMPLETION_STATUS('ERROR',l_err_msg);
1381:
1382: WHEN OTHERS THEN
1383: ROLLBACK;

Line 1392: CONC_STATUS := FND_CONCURRENT.

1388: || to_char(l_stmt_num)
1389: || '): '
1390: ||SQLERRM,1,240);
1391: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);
1392: CONC_STATUS := FND_CONCURRENT.
1393: SET_COMPLETION_STATUS('ERROR',l_err_msg);
1394: END trf_invoice_to_wip;
1395:
1396: PROCEDURE trf_invoice_to_wip(

Line 1455: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_err_msg);

1451: fnd_message.set_name('GMF', 'GMF_PROCESS_ORG_ERROR');
1452: fnd_message.set_token('ORGCODE', l_organization_code);
1453: l_err_msg := FND_MESSAGE.Get;
1454: l_err_msg := substrb('CSTPIPVB : ' || l_err_msg,1,240);
1455: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_err_msg);
1456: fnd_file.put_line(fnd_file.log,l_err_msg);
1457: RETURN;
1458: END IF;
1459:

Line 1507: CONC_STATUS := FND_CONCURRENT.

1503: || to_char(l_stmt_num)
1504: || '): '
1505: ||SQLERRM,1,240);
1506: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);
1507: CONC_STATUS := FND_CONCURRENT.
1508: SET_COMPLETION_STATUS('ERROR',l_err_msg);
1509: END trf_invoice_to_wip;
1510:
1511: /*---------------------------------------------------------------------------*