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 659: CONC_STATUS := FND_CONCURRENT.

655: l_err_msg := SUBSTR(l_err_msg,1,240);
656: FND_FILE.PUT_LINE(fnd_file.log,SUBSTR(l_err_code
657: ||' '
658: ||l_err_msg,1,240));
659: CONC_STATUS := FND_CONCURRENT.
660: SET_COMPLETION_STATUS('ERROR',l_err_msg);
661:
662:
663: WHEN CST_NO_AVG_ORG THEN

Line 677: CONC_STATUS := FND_CONCURRENT.

673: fnd_message.set_name('BOM', 'CST_NO_AVG_ORG');
674: l_err_msg := fnd_message.get;
675: l_err_msg := SUBSTR(l_err_msg,1,240);
676: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);
677: CONC_STATUS := FND_CONCURRENT.
678: SET_COMPLETION_STATUS('ERROR',l_err_msg);
679:
680:
681: WHEN CST_PROCESS_ERROR THEN

Line 687: CONC_STATUS := FND_CONCURRENT.

683: l_err_num := l_err_num;
684: l_err_code := l_err_code;
685: l_err_msg := SUBSTR(l_err_msg,1,240);
686: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);
687: CONC_STATUS := FND_CONCURRENT.
688: SET_COMPLETION_STATUS('ERROR',l_err_msg);
689:
690:
691: WHEN OTHERS THEN

Line 700: CONC_STATUS := FND_CONCURRENT.

696: || to_char(l_stmt_num)
697: || '): '
698: ||SQLERRM,1,240);
699: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);
700: CONC_STATUS := FND_CONCURRENT.
701: SET_COMPLETION_STATUS('ERROR',l_err_msg);
702:
703:
704: END trf_invoice_to_inventory;

Line 1012: FROM fnd_concurrent_requests fcr

1008:
1009: BEGIN
1010: SELECT fcr.request_id
1011: INTO l_dummy
1012: FROM fnd_concurrent_requests fcr
1013: WHERE program_application_id = 702
1014: AND concurrent_program_id = l_conc_program_id
1015: AND phase_code IN ('I','P','R')
1016: AND argument2 = TO_CHAR(p_organization_id)

Line 1415: CONC_STATUS := FND_CONCURRENT.

1411: l_err_msg := SUBSTR(l_err_msg,1,240);
1412: FND_FILE.PUT_LINE(fnd_file.log,SUBSTR(l_err_code
1413: ||' '
1414: ||l_err_msg,1,240));
1415: CONC_STATUS := FND_CONCURRENT.
1416: SET_COMPLETION_STATUS('ERROR',l_err_msg);
1417:
1418: WHEN CST_PROCESS_ERROR THEN
1419: ROLLBACK;

Line 1425: CONC_STATUS := FND_CONCURRENT.

1421: l_err_num := l_err_num;
1422: l_err_code := l_err_code;
1423: l_err_msg := SUBSTR(l_err_msg,1,240);
1424: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);
1425: CONC_STATUS := FND_CONCURRENT.
1426: SET_COMPLETION_STATUS('ERROR',l_err_msg);
1427:
1428: WHEN OTHERS THEN
1429: ROLLBACK;

Line 1438: CONC_STATUS := FND_CONCURRENT.

1434: || to_char(l_stmt_num)
1435: || '): '
1436: ||SQLERRM,1,240);
1437: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);
1438: CONC_STATUS := FND_CONCURRENT.
1439: SET_COMPLETION_STATUS('ERROR',l_err_msg);
1440: END trf_invoice_to_wip;
1441:
1442: PROCEDURE trf_invoice_to_wip(

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

1497: fnd_message.set_name('GMF', 'GMF_PROCESS_ORG_ERROR');
1498: fnd_message.set_token('ORGCODE', l_organization_code);
1499: l_err_msg := FND_MESSAGE.Get;
1500: l_err_msg := substrb('CSTPIPVB : ' || l_err_msg,1,240);
1501: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_err_msg);
1502: fnd_file.put_line(fnd_file.log,l_err_msg);
1503: RETURN;
1504: END IF;
1505:

Line 1553: CONC_STATUS := FND_CONCURRENT.

1549: || to_char(l_stmt_num)
1550: || '): '
1551: ||SQLERRM,1,240);
1552: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);
1553: CONC_STATUS := FND_CONCURRENT.
1554: SET_COMPLETION_STATUS('ERROR',l_err_msg);
1555: END trf_invoice_to_wip;
1556:
1557: /*---------------------------------------------------------------------------*