DBA Data[Home] [Help]

APPS.ZX_API_PUB dependencies on FND_GLOBAL

Line 1384: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN

1380: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
1381: END IF;
1382:
1383: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
1384: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN
1385: FND_FILE.put_line(which => FND_FILE.LOG
1386: ,buff => 'Transfer_Mode: '||G_DATA_TRANSFER_MODE);
1387: FND_FILE.put_line(which => FND_FILE.LOG
1388: ,buff => 'ZX_API_PUB.Calculate.Statistics Start Time:'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));

Line 1427: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN

1423: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
1424: END IF;
1425:
1426: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
1427: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN
1428: FND_FILE.put_line(which => FND_FILE.LOG
1429: ,buff => 'Exception FND_API.G_EXC_ERROR : Transfer_Mode: '||G_DATA_TRANSFER_MODE);
1430: FND_FILE.put_line(which => FND_FILE.LOG
1431: ,buff => 'ZX_API_PUB.Calculate.Statistics Start Time:'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));

Line 1474: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN

1470: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
1471: END IF;
1472:
1473: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
1474: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN
1475: FND_FILE.put_line(which => FND_FILE.LOG
1476: ,buff => 'Exception FND_API.G_EXC_UNEXPECTED_ERROR : Transfer_Mode: '||G_DATA_TRANSFER_MODE);
1477: FND_FILE.put_line(which => FND_FILE.LOG
1478: ,buff => 'ZX_API_PUB.Calculate.Statistics Start Time:'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));

Line 1515: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN

1511: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Total Time :'|| l_total_time);
1512: END IF;
1513:
1514: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
1515: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN
1516: FND_FILE.put_line(which => FND_FILE.LOG
1517: ,buff => 'Exception OTHERS : Transfer_Mode: '||G_DATA_TRANSFER_MODE);
1518: FND_FILE.put_line(which => FND_FILE.LOG
1519: ,buff => 'ZX_API_PUB.Calculate.Statistics Start Time:'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));

Line 2234: IF fnd_global.conc_request_id <> -1 THEN

2230: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||' Statistics','End Time :'||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
2231: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||' Statistics','Total Time :'|| l_total_time);
2232: END IF;
2233:
2234: IF fnd_global.conc_request_id <> -1 THEN
2235: FND_FILE.put_line(which => FND_FILE.LOG
2236: ,buff => 'Transfer_Mode: '||G_DATA_TRANSFER_MODE);
2237: FND_FILE.put_line(which => FND_FILE.LOG
2238: ,buff => 'ZX_API_PUB.CALCULATE.Statistics Start Time:'

Line 2278: IF fnd_global.conc_request_id <> -1 THEN

2274: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','End Time :'||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
2275: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Total Time :'|| l_total_time);
2276: END IF;
2277:
2278: IF fnd_global.conc_request_id <> -1 THEN
2279: FND_FILE.put_line(which => FND_FILE.LOG
2280: ,buff => 'ZX_API_PUB.CALCULATE.Exception FND_API.G_EXC_ERROR Transfer_Mode: '||G_DATA_TRANSFER_MODE);
2281: FND_FILE.put_line(which => FND_FILE.LOG
2282: ,buff => 'ZX_API_PUB.CALCULATE.Statistics Start Time:'

Line 2321: IF fnd_global.conc_request_id <> -1 THEN

2317: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','End Time :'||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
2318: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Total Time :'|| l_total_time);
2319: END IF;
2320:
2321: IF fnd_global.conc_request_id <> -1 THEN
2322: FND_FILE.put_line(which => FND_FILE.LOG
2323: ,buff => 'ZX_API_PUB.CALCULATE.Exception FND_API.G_EXC_UNEXPECTED_ERROR Transfer_Mode: '||G_DATA_TRANSFER_MODE);
2324: FND_FILE.put_line(which => FND_FILE.LOG
2325: ,buff => 'ZX_API_PUB.CALCULATE.Statistics Start Time:'

Line 2361: IF fnd_global.conc_request_id <> -1 THEN

2357: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','End Time :'||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
2358: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Total Time :'|| l_total_time);
2359: END IF;
2360:
2361: IF fnd_global.conc_request_id <> -1 THEN
2362: FND_FILE.put_line(which => FND_FILE.LOG
2363: ,buff => 'ZX_API_PUB.CALCULATE.Exception OTHERS Transfer_Mode: '||G_DATA_TRANSFER_MODE);
2364: FND_FILE.put_line(which => FND_FILE.LOG
2365: ,buff => 'ZX_API_PUB.CALCULATE.Statistics Start Time:'

Line 2777: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN

2773: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_TAX_LINK_GT :'||l_dummy_number);
2774: END IF;
2775:
2776: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
2777: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN
2778: FND_FILE.put_line(which => FND_FILE.LOG
2779: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics Start Time:' ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
2780: FND_FILE.put_line(which => FND_FILE.LOG
2781: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics End Time:' ||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));

Line 2829: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN

2825: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_TAX_LINK_GT :'||l_dummy_number);
2826: END IF;
2827:
2828: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
2829: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN
2830: FND_FILE.put_line(which => FND_FILE.LOG
2831: ,buff => 'ZX_API_PUB.import_document_with_tax.Exception FND_API.G_EXC_ERROR');
2832: FND_FILE.put_line(which => FND_FILE.LOG
2833: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics Start Time:' ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));

Line 2893: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN

2889: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_TAX_LINK_GT :'||l_dummy_number);
2890: END IF;
2891:
2892: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
2893: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN
2894: FND_FILE.put_line(which => FND_FILE.LOG
2895: ,buff => 'ZX_API_PUB.import_document_with_tax.Exception FND_API.G_EXC_UNEXPECTED_ERROR');
2896: FND_FILE.put_line(which => FND_FILE.LOG
2897: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics Start Time:' ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));

Line 2952: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN

2948: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_TAX_LINK_GT :'||l_dummy_number);
2949: END IF;
2950:
2951: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
2952: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN
2953: FND_FILE.put_line(which => FND_FILE.LOG
2954: ,buff => 'ZX_API_PUB.import_document_with_tax.Exception OTHERS');
2955: FND_FILE.put_line(which => FND_FILE.LOG
2956: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics Start Time:' ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));

Line 5888: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN

5884: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
5885: END IF;
5886:
5887: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
5888: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN
5889: FND_FILE.put_line(which => FND_FILE.LOG
5890: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics Start Time:'
5891: ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
5892: FND_FILE.put_line(which => FND_FILE.LOG

Line 5933: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN

5929: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
5930: END IF;
5931:
5932: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
5933: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN
5934: FND_FILE.put_line(which => FND_FILE.LOG
5935: ,buff => 'ZX_API_PUB.Determine_recovery.Exception FND_API.G_EXC_ERROR');
5936:
5937: FND_FILE.put_line(which => FND_FILE.LOG

Line 5992: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN

5988: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
5989: END IF;
5990:
5991: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
5992: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN
5993: FND_FILE.put_line(which => FND_FILE.LOG
5994: ,buff => 'ZX_API_PUB.Determine_recovery.Exception FND_API.G_EXC_ERROR');
5995: FND_FILE.put_line(which => FND_FILE.LOG
5996: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics Start Time:'

Line 6045: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN

6041: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
6042: END IF;
6043:
6044: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
6045: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN
6046: FND_FILE.put_line(which => FND_FILE.LOG
6047: ,buff => 'ZX_API_PUB.Determine_recovery.Exception OTHERS');
6048: FND_FILE.put_line(which => FND_FILE.LOG
6049: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics Start Time:'

Line 11706: LAST_UPDATED_BY = fnd_global.user_id,

11702: 'COPY_AND_CREATE','UPDATE',
11703: LINE_LEVEL_ACTION),
11704: TAX_PROCESSING_COMPLETED_FLAG = 'N',
11705: LAST_UPDATE_DATE = sysdate,
11706: LAST_UPDATED_BY = fnd_global.user_id,
11707: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
11708: WHERE APPLICATION_ID = p_hdr_det_factors_rec.APPLICATION_ID
11709: AND ENTITY_CODE = p_hdr_det_factors_rec.ENTITY_CODE
11710: AND EVENT_CLASS_CODE = p_hdr_det_factors_rec.EVENT_CLASS_CODE

Line 11707: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

11703: LINE_LEVEL_ACTION),
11704: TAX_PROCESSING_COMPLETED_FLAG = 'N',
11705: LAST_UPDATE_DATE = sysdate,
11706: LAST_UPDATED_BY = fnd_global.user_id,
11707: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
11708: WHERE APPLICATION_ID = p_hdr_det_factors_rec.APPLICATION_ID
11709: AND ENTITY_CODE = p_hdr_det_factors_rec.ENTITY_CODE
11710: AND EVENT_CLASS_CODE = p_hdr_det_factors_rec.EVENT_CLASS_CODE
11711: AND TRX_ID = p_hdr_det_factors_rec.TRX_ID;

Line 12049: LAST_UPDATED_BY = fnd_global.user_id,

12045: 'SYNCHRONIZE','UPDATE',
12046: LINE_LEVEL_ACTION),
12047: TAX_PROCESSING_COMPLETED_FLAG = 'N',
12048: LAST_UPDATE_DATE = sysdate,
12049: LAST_UPDATED_BY = fnd_global.user_id,
12050: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
12051: WHERE APPLICATION_ID = p_hdr_det_factors_rec.APPLICATION_ID
12052: AND ENTITY_CODE = p_hdr_det_factors_rec.ENTITY_CODE
12053: AND EVENT_CLASS_CODE = p_hdr_det_factors_rec.EVENT_CLASS_CODE

Line 12050: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

12046: LINE_LEVEL_ACTION),
12047: TAX_PROCESSING_COMPLETED_FLAG = 'N',
12048: LAST_UPDATE_DATE = sysdate,
12049: LAST_UPDATED_BY = fnd_global.user_id,
12050: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
12051: WHERE APPLICATION_ID = p_hdr_det_factors_rec.APPLICATION_ID
12052: AND ENTITY_CODE = p_hdr_det_factors_rec.ENTITY_CODE
12053: AND EVENT_CLASS_CODE = p_hdr_det_factors_rec.EVENT_CLASS_CODE
12054: AND TRX_ID = p_hdr_det_factors_rec.TRX_ID;