eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMS_AWARD_DIST_ENG dependencies on PA_CC_UTILS

Line 1166: pa_cc_utils.set_curr_function('PROC_INSERT_TRANS');

1162: p_user_id NUMBER,
1163: p_xface_id NUMBER ) IS
1164: count_new_rec NUMBER ;
1165: BEGIN
1166: pa_cc_utils.set_curr_function('PROC_INSERT_TRANS');
1167:
1168: UPDATE GMS_DISTRIBUTION_DETAILS
1169: SET remarks = to_char(PA_TXN_INTERFACE_S.nextval)
1170: WHERE document_header_id = p_xface_id

Line 1174: pa_cc_utils.log_message(' Generated new txn_interface_id :'||to_char(SQL%ROWCOUNT));

1170: WHERE document_header_id = p_xface_id
1171: AND document_type = 'EXP'
1172: AND distribution_number > 1 ;
1173:
1174: pa_cc_utils.log_message(' Generated new txn_interface_id :'||to_char(SQL%ROWCOUNT));
1175: -- 3466152
1176: -- import process award distributions doesn't work when batch name is not supplied.
1177: -- addaed transaction source in the where clause to have better performance.
1178: --

Line 1241: pa_cc_utils.log_message(' GMS Transactions inserted :'||to_char(SQL%ROWCOUNT));

1237: AND GTN.distribution_number > 1
1238: AND GTN.document_distribution_id = TXN.TXN_INTERFACE_ID ;
1239:
1240: count_new_rec := SQL%ROWCOUNT ;
1241: pa_cc_utils.log_message(' GMS Transactions inserted :'||to_char(SQL%ROWCOUNT));
1242:
1243: -- 3466152
1244: -- import process award distributions doesn't work when batch name is not supplied.
1245: -- addaed transaction source in the where clause to have better performance.

Line 1465: pa_cc_utils.log_message(' PA Transactions inserted :'||to_char(SQL%ROWCOUNT));

1461: AND GTN.distribution_number > 1
1462: AND GTN.document_distribution_id = TXN.TXN_INTERFACE_ID ;
1463:
1464: count_new_rec := SQL%ROWCOUNT ;
1465: pa_cc_utils.log_message(' PA Transactions inserted :'||to_char(SQL%ROWCOUNT));
1466: DELETE from GMS_DISTRIBUTION_DETAILS
1467: where document_header_id = p_xface_id ;
1468:
1469: pa_cc_utils.log_message(' No of GMS_DISTRIBUTION_DETAILS records deleted :'||to_char(SQL%ROWCOUNT));

Line 1469: pa_cc_utils.log_message(' No of GMS_DISTRIBUTION_DETAILS records deleted :'||to_char(SQL%ROWCOUNT));

1465: pa_cc_utils.log_message(' PA Transactions inserted :'||to_char(SQL%ROWCOUNT));
1466: DELETE from GMS_DISTRIBUTION_DETAILS
1467: where document_header_id = p_xface_id ;
1468:
1469: pa_cc_utils.log_message(' No of GMS_DISTRIBUTION_DETAILS records deleted :'||to_char(SQL%ROWCOUNT));
1470: DELETE from GMS_DISTRIBUTIONS
1471: where document_header_id = p_xface_id ;
1472: pa_cc_utils.log_message(' No of GMS_DISTRIBUTIONS records deleted :'||to_char(SQL%ROWCOUNT));
1473: pa_cc_utils.reset_curr_function;

Line 1472: pa_cc_utils.log_message(' No of GMS_DISTRIBUTIONS records deleted :'||to_char(SQL%ROWCOUNT));

1468:
1469: pa_cc_utils.log_message(' No of GMS_DISTRIBUTION_DETAILS records deleted :'||to_char(SQL%ROWCOUNT));
1470: DELETE from GMS_DISTRIBUTIONS
1471: where document_header_id = p_xface_id ;
1472: pa_cc_utils.log_message(' No of GMS_DISTRIBUTIONS records deleted :'||to_char(SQL%ROWCOUNT));
1473: pa_cc_utils.reset_curr_function;
1474: EXCEPTION
1475: When others then
1476: pa_cc_utils.log_message(' ERROR :'||SQLERRM);

Line 1473: pa_cc_utils.reset_curr_function;

1469: pa_cc_utils.log_message(' No of GMS_DISTRIBUTION_DETAILS records deleted :'||to_char(SQL%ROWCOUNT));
1470: DELETE from GMS_DISTRIBUTIONS
1471: where document_header_id = p_xface_id ;
1472: pa_cc_utils.log_message(' No of GMS_DISTRIBUTIONS records deleted :'||to_char(SQL%ROWCOUNT));
1473: pa_cc_utils.reset_curr_function;
1474: EXCEPTION
1475: When others then
1476: pa_cc_utils.log_message(' ERROR :'||SQLERRM);
1477: pa_cc_utils.reset_curr_function;

Line 1476: pa_cc_utils.log_message(' ERROR :'||SQLERRM);

1472: pa_cc_utils.log_message(' No of GMS_DISTRIBUTIONS records deleted :'||to_char(SQL%ROWCOUNT));
1473: pa_cc_utils.reset_curr_function;
1474: EXCEPTION
1475: When others then
1476: pa_cc_utils.log_message(' ERROR :'||SQLERRM);
1477: pa_cc_utils.reset_curr_function;
1478: RAISE ;
1479: END PROC_INSERT_TRANS ;
1480:

Line 1477: pa_cc_utils.reset_curr_function;

1473: pa_cc_utils.reset_curr_function;
1474: EXCEPTION
1475: When others then
1476: pa_cc_utils.log_message(' ERROR :'||SQLERRM);
1477: pa_cc_utils.reset_curr_function;
1478: RAISE ;
1479: END PROC_INSERT_TRANS ;
1480:
1481: -- ============

Line 1487: pa_cc_utils.set_curr_function('Award Distribution lockCntrlRec');

1483: , batch VARCHAR2
1484: , etypeclasscode VARCHAR2 ) RETURN NUMBER IS
1485: dummy NUMBER ;
1486: BEGIN
1487: pa_cc_utils.set_curr_function('Award Distribution lockCntrlRec');
1488:
1489: pa_cc_utils.log_message('Trying to get lock for record in xface ctrl:'||
1490: ' transaction source ='||trx_source||
1491: ' batch = '||batch||

Line 1489: pa_cc_utils.log_message('Trying to get lock for record in xface ctrl:'||

1485: dummy NUMBER ;
1486: BEGIN
1487: pa_cc_utils.set_curr_function('Award Distribution lockCntrlRec');
1488:
1489: pa_cc_utils.log_message('Trying to get lock for record in xface ctrl:'||
1490: ' transaction source ='||trx_source||
1491: ' batch = '||batch||
1492: ' sys link = '||etypeclasscode, 1);
1493: SELECT 1

Line 1502: pa_cc_utils.log_message('Got lock for record',1);

1498: AND system_linkage_function = etypeclasscode
1499: AND status = 'PENDING'
1500: FOR UPDATE OF status NOWAIT;
1501:
1502: pa_cc_utils.log_message('Got lock for record',1);
1503: pa_cc_utils.log_message('Updated interface id/status on pa_transaction_xface_control',1);
1504: pa_cc_utils.reset_curr_function;
1505:
1506: RETURN 0;

Line 1503: pa_cc_utils.log_message('Updated interface id/status on pa_transaction_xface_control',1);

1499: AND status = 'PENDING'
1500: FOR UPDATE OF status NOWAIT;
1501:
1502: pa_cc_utils.log_message('Got lock for record',1);
1503: pa_cc_utils.log_message('Updated interface id/status on pa_transaction_xface_control',1);
1504: pa_cc_utils.reset_curr_function;
1505:
1506: RETURN 0;
1507: EXCEPTION

Line 1504: pa_cc_utils.reset_curr_function;

1500: FOR UPDATE OF status NOWAIT;
1501:
1502: pa_cc_utils.log_message('Got lock for record',1);
1503: pa_cc_utils.log_message('Updated interface id/status on pa_transaction_xface_control',1);
1504: pa_cc_utils.reset_curr_function;
1505:
1506: RETURN 0;
1507: EXCEPTION
1508: WHEN RESOURCE_BUSY THEN

Line 1509: pa_cc_utils.log_message('Cannot get lock',1);

1505:
1506: RETURN 0;
1507: EXCEPTION
1508: WHEN RESOURCE_BUSY THEN
1509: pa_cc_utils.log_message('Cannot get lock',1);
1510: pa_cc_utils.reset_curr_function;
1511: RETURN -1;
1512: END lockCntrlRec;
1513:

Line 1510: pa_cc_utils.reset_curr_function;

1506: RETURN 0;
1507: EXCEPTION
1508: WHEN RESOURCE_BUSY THEN
1509: pa_cc_utils.log_message('Cannot get lock',1);
1510: pa_cc_utils.reset_curr_function;
1511: RETURN -1;
1512: END lockCntrlRec;
1513:
1514:

Line 1529: pa_cc_utils.set_curr_function('Award Distribution GET_DIST_AWARD_ID');

1525: PROCEDURE GET_DIST_AWARD_ID( p_default_dist_award_id out NOCOPY NUMBER,
1526: p_default_dist_award_number out NOCOPY varchar2,
1527: p_status out NOCOPY varchar2) IS
1528: BEGIN
1529: pa_cc_utils.set_curr_function('Award Distribution GET_DIST_AWARD_ID');
1530:
1531: SELECT default_dist_award_id,
1532: default_dist_award_number -- Bug 3221039
1533: INTO p_default_dist_award_id,

Line 1538: pa_cc_utils.log_message('Award Distribution default_dist_award_id='||to_char(p_default_dist_award_id));

1534: p_default_dist_award_number -- Bug 3221039
1535: FROM GMS_IMPLEMENTATIONS
1536: WHERE AWARD_DISTRIBUTION_OPTION = 'Y' ;
1537:
1538: pa_cc_utils.log_message('Award Distribution default_dist_award_id='||to_char(p_default_dist_award_id));
1539: pa_cc_utils.reset_curr_function;
1540:
1541: --return x_dummy ;
1542: EXCEPTION

Line 1539: pa_cc_utils.reset_curr_function;

1535: FROM GMS_IMPLEMENTATIONS
1536: WHERE AWARD_DISTRIBUTION_OPTION = 'Y' ;
1537:
1538: pa_cc_utils.log_message('Award Distribution default_dist_award_id='||to_char(p_default_dist_award_id));
1539: pa_cc_utils.reset_curr_function;
1540:
1541: --return x_dummy ;
1542: EXCEPTION
1543: when no_data_found then

Line 1545: pa_cc_utils.log_message('Award Distribution default_dist_award_id not enabled.****');

1541: --return x_dummy ;
1542: EXCEPTION
1543: when no_data_found then
1544: p_status := 'NO_DATA_FOUND' ;
1545: pa_cc_utils.log_message('Award Distribution default_dist_award_id not enabled.****');
1546: pa_cc_utils.reset_curr_function;
1547: --return -1 ;
1548: END GET_DIST_AWARD_ID ;
1549: -- ==== End of GET_DIST_AWARD_ID ==================================

Line 1546: pa_cc_utils.reset_curr_function;

1542: EXCEPTION
1543: when no_data_found then
1544: p_status := 'NO_DATA_FOUND' ;
1545: pa_cc_utils.log_message('Award Distribution default_dist_award_id not enabled.****');
1546: pa_cc_utils.reset_curr_function;
1547: --return -1 ;
1548: END GET_DIST_AWARD_ID ;
1549: -- ==== End of GET_DIST_AWARD_ID ==================================
1550:

Line 1811: pa_cc_utils.set_curr_function('PRE_IMPORT');

1807: x_record_found := 0 ;
1808: l_project_id_last := 0 ;
1809: l_task_id_last := 0 ;
1810:
1811: pa_cc_utils.set_curr_function('PRE_IMPORT');
1812: pa_cc_utils.log_message('Start Grants Accounting Pre Import for award Distributions.'||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
1813:
1814: -- Bug 3221039 : Modified the call to procedure from function
1815: --x_default_dist_award_id := get_dist_award_id(x_status) ;

Line 1812: pa_cc_utils.log_message('Start Grants Accounting Pre Import for award Distributions.'||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));

1808: l_project_id_last := 0 ;
1809: l_task_id_last := 0 ;
1810:
1811: pa_cc_utils.set_curr_function('PRE_IMPORT');
1812: pa_cc_utils.log_message('Start Grants Accounting Pre Import for award Distributions.'||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
1813:
1814: -- Bug 3221039 : Modified the call to procedure from function
1815: --x_default_dist_award_id := get_dist_award_id(x_status) ;
1816: get_dist_award_id(x_default_dist_award_id,l_default_dist_award_number,x_status);

Line 1826: pa_cc_utils.log_message('Award Distribution not enabled, pre-import Exit.');

1822: -- to continue further.
1823: -- =====================================================
1824:
1825: IF x_status is not NULL THEN
1826: pa_cc_utils.log_message('Award Distribution not enabled, pre-import Exit.');
1827: pa_cc_utils.reset_curr_function;
1828: return ;
1829: END IF ;
1830:

Line 1827: pa_cc_utils.reset_curr_function;

1823: -- =====================================================
1824:
1825: IF x_status is not NULL THEN
1826: pa_cc_utils.log_message('Award Distribution not enabled, pre-import Exit.');
1827: pa_cc_utils.reset_curr_function;
1828: return ;
1829: END IF ;
1830:
1831: x_record_found := 0 ;

Line 1845: pa_cc_utils.log_message(eachGroup.batch_name||' : All records rejected because of :'||'LOCK_'||eachGroup.batch_name||'_FAILED');

1841:
1842: dummy := lockCntrlRec( eachGroup.transaction_source , eachGroup.batch_name
1843: , eachGroup.system_linkage_function );
1844: IF ( dummy <> 0 ) THEN
1845: pa_cc_utils.log_message(eachGroup.batch_name||' : All records rejected because of :'||'LOCK_'||eachGroup.batch_name||'_FAILED');
1846:
1847: UPDATE pa_transaction_interface
1848: SET transaction_rejection_code = 'LOCK_'||eachGroup.batch_name||'_FAILED'
1849: , transaction_status_code = 'PR'

Line 1854: pa_cc_utils.log_message(eachGroup.batch_name||' : Rejected Count :'||to_char(SQL%ROWCOUNT));

1850: WHERE transaction_source = eachGroup.transaction_source
1851: AND batch_name = eachGroup.batch_name
1852: AND transaction_status_code = 'P';
1853:
1854: pa_cc_utils.log_message(eachGroup.batch_name||' : Rejected Count :'||to_char(SQL%ROWCOUNT));
1855:
1856: END IF ;
1857: -- =======End of LOCK CHECK ********
1858:

Line 1862: pa_cc_utils.log_message('Fetch Records for :'||eachGroup.transaction_source||','||eachGroup.batch_name||','

1858:
1859:
1860: OPEN TrxRecs( eachGroup.transaction_source , eachGroup.batch_name , eachGroup.system_linkage_function );
1861:
1862: pa_cc_utils.log_message('Fetch Records for :'||eachGroup.transaction_source||','||eachGroup.batch_name||','
1863: ||eachGroup.system_linkage_function ) ;
1864:
1865: FIRST_RECORD := TRUE ;
1866:

Line 1907: pa_cc_utils.log_message('Zero Records Fetched',1);

1903: l_task_number := TrxRec.task_number ;
1904: l_project_number := TrxRec.Project_number ;
1905:
1906: IF ( TrxRecs%ROWCOUNT = 0 ) THEN
1907: pa_cc_utils.log_message('Zero Records Fetched',1);
1908: EXIT expenditures ;
1909: ELSIF ( TrxRecs%NOTFOUND ) THEN
1910: pa_cc_utils.log_message('Last Record fetched',1);
1911: EXIT expenditures ;

Line 1910: pa_cc_utils.log_message('Last Record fetched',1);

1906: IF ( TrxRecs%ROWCOUNT = 0 ) THEN
1907: pa_cc_utils.log_message('Zero Records Fetched',1);
1908: EXIT expenditures ;
1909: ELSIF ( TrxRecs%NOTFOUND ) THEN
1910: pa_cc_utils.log_message('Last Record fetched',1);
1911: EXIT expenditures ;
1912: END IF;
1913: --
1914: -- bug : 3628820 perf issue in gmsawdeb.pls

Line 1920: pa_cc_utils.log_message('GMS: Pre_import open c_project_number.');

1916: --
1917: IF l_project_number is NULL and l_project_id is NOT NULL THEN
1918:
1919: IF l_project_id_last <> l_project_id THEN
1920: pa_cc_utils.log_message('GMS: Pre_import open c_project_number.');
1921: open c_project_number ;
1922: fetch c_project_number into l_project_number ;
1923: close c_project_number ;
1924:

Line 1950: pa_cc_utils.log_message('GMS: Pre_import open c_project_id.');

1946: IF l_project_number is not NULL and l_project_id is NULL THEN
1947: IF l_project_number_last <> l_project_number OR
1948: l_project_number_last is NULL THEN
1949:
1950: pa_cc_utils.log_message('GMS: Pre_import open c_project_id.');
1951: open c_project_id ;
1952: fetch c_project_id into l_project_id ;
1953: close c_project_id ;
1954:

Line 1986: pa_cc_utils.log_message('GMS: Pre_import open c_task_number.');

1982: IF l_task_number is NULL and l_task_id is NOT NULL THEN
1983: IF l_task_id_last <> l_task_id OR
1984: l_task_id_last is NULL THEN
1985:
1986: pa_cc_utils.log_message('GMS: Pre_import open c_task_number.');
1987: open c_task_number ;
1988: fetch c_task_number into l_task_number ;
1989: close c_task_number ;
1990:

Line 2008: pa_cc_utils.log_message('GMS: Pre_import open c_task_id.');

2004: IF l_task_number is not NULL and l_task_id is NULL THEN
2005: IF l_task_number_last <> l_task_number OR
2006: l_task_number_last is NULL THEN
2007:
2008: pa_cc_utils.log_message('GMS: Pre_import open c_task_id.');
2009: open c_task_id ;
2010: fetch c_task_id into l_task_id ;
2011: close c_task_id ;
2012: -- 5169675

Line 2061: pa_cc_utils.log_message('GMS: Pre_import l_project_id :'|| l_project_id);

2057: -- bug:5131439 TRANSACTION IMORT FAILED WITH PA_EXP_INV_PJTK FOR LEGITIMATE
2058: --x_status := NULL ;
2059: --
2060:
2061: pa_cc_utils.log_message('GMS: Pre_import l_project_id :'|| l_project_id);
2062: pa_cc_utils.log_message('GMS: Pre_import l_project_id_last :'|| l_project_id_last);
2063: pa_cc_utils.log_message('GMS: Pre_import l_project_number :'|| l_project_number);
2064: pa_cc_utils.log_message('GMS: Pre_import l_project_id_last :'|| l_project_number_last);
2065:

Line 2062: pa_cc_utils.log_message('GMS: Pre_import l_project_id_last :'|| l_project_id_last);

2058: --x_status := NULL ;
2059: --
2060:
2061: pa_cc_utils.log_message('GMS: Pre_import l_project_id :'|| l_project_id);
2062: pa_cc_utils.log_message('GMS: Pre_import l_project_id_last :'|| l_project_id_last);
2063: pa_cc_utils.log_message('GMS: Pre_import l_project_number :'|| l_project_number);
2064: pa_cc_utils.log_message('GMS: Pre_import l_project_id_last :'|| l_project_number_last);
2065:
2066: pa_cc_utils.log_message('GMS: Pre_import l_task_id :'|| l_task_id);

Line 2063: pa_cc_utils.log_message('GMS: Pre_import l_project_number :'|| l_project_number);

2059: --
2060:
2061: pa_cc_utils.log_message('GMS: Pre_import l_project_id :'|| l_project_id);
2062: pa_cc_utils.log_message('GMS: Pre_import l_project_id_last :'|| l_project_id_last);
2063: pa_cc_utils.log_message('GMS: Pre_import l_project_number :'|| l_project_number);
2064: pa_cc_utils.log_message('GMS: Pre_import l_project_id_last :'|| l_project_number_last);
2065:
2066: pa_cc_utils.log_message('GMS: Pre_import l_task_id :'|| l_task_id);
2067: pa_cc_utils.log_message('GMS: Pre_import l_task_id_last :'|| l_task_id_last);

Line 2064: pa_cc_utils.log_message('GMS: Pre_import l_project_id_last :'|| l_project_number_last);

2060:
2061: pa_cc_utils.log_message('GMS: Pre_import l_project_id :'|| l_project_id);
2062: pa_cc_utils.log_message('GMS: Pre_import l_project_id_last :'|| l_project_id_last);
2063: pa_cc_utils.log_message('GMS: Pre_import l_project_number :'|| l_project_number);
2064: pa_cc_utils.log_message('GMS: Pre_import l_project_id_last :'|| l_project_number_last);
2065:
2066: pa_cc_utils.log_message('GMS: Pre_import l_task_id :'|| l_task_id);
2067: pa_cc_utils.log_message('GMS: Pre_import l_task_id_last :'|| l_task_id_last);
2068: pa_cc_utils.log_message('GMS: Pre_import l_task_number :'|| l_task_number);

Line 2066: pa_cc_utils.log_message('GMS: Pre_import l_task_id :'|| l_task_id);

2062: pa_cc_utils.log_message('GMS: Pre_import l_project_id_last :'|| l_project_id_last);
2063: pa_cc_utils.log_message('GMS: Pre_import l_project_number :'|| l_project_number);
2064: pa_cc_utils.log_message('GMS: Pre_import l_project_id_last :'|| l_project_number_last);
2065:
2066: pa_cc_utils.log_message('GMS: Pre_import l_task_id :'|| l_task_id);
2067: pa_cc_utils.log_message('GMS: Pre_import l_task_id_last :'|| l_task_id_last);
2068: pa_cc_utils.log_message('GMS: Pre_import l_task_number :'|| l_task_number);
2069: pa_cc_utils.log_message('GMS: Pre_import l_task_number_last :'|| l_task_number_last);
2070: --

Line 2067: pa_cc_utils.log_message('GMS: Pre_import l_task_id_last :'|| l_task_id_last);

2063: pa_cc_utils.log_message('GMS: Pre_import l_project_number :'|| l_project_number);
2064: pa_cc_utils.log_message('GMS: Pre_import l_project_id_last :'|| l_project_number_last);
2065:
2066: pa_cc_utils.log_message('GMS: Pre_import l_task_id :'|| l_task_id);
2067: pa_cc_utils.log_message('GMS: Pre_import l_task_id_last :'|| l_task_id_last);
2068: pa_cc_utils.log_message('GMS: Pre_import l_task_number :'|| l_task_number);
2069: pa_cc_utils.log_message('GMS: Pre_import l_task_number_last :'|| l_task_number_last);
2070: --
2071: -- bug : 3628820 perf issue in gmsawdeb.pls

Line 2068: pa_cc_utils.log_message('GMS: Pre_import l_task_number :'|| l_task_number);

2064: pa_cc_utils.log_message('GMS: Pre_import l_project_id_last :'|| l_project_number_last);
2065:
2066: pa_cc_utils.log_message('GMS: Pre_import l_task_id :'|| l_task_id);
2067: pa_cc_utils.log_message('GMS: Pre_import l_task_id_last :'|| l_task_id_last);
2068: pa_cc_utils.log_message('GMS: Pre_import l_task_number :'|| l_task_number);
2069: pa_cc_utils.log_message('GMS: Pre_import l_task_number_last :'|| l_task_number_last);
2070: --
2071: -- bug : 3628820 perf issue in gmsawdeb.pls
2072: -- FTS on pa_projects and pa_tasks table.

Line 2069: pa_cc_utils.log_message('GMS: Pre_import l_task_number_last :'|| l_task_number_last);

2065:
2066: pa_cc_utils.log_message('GMS: Pre_import l_task_id :'|| l_task_id);
2067: pa_cc_utils.log_message('GMS: Pre_import l_task_id_last :'|| l_task_id_last);
2068: pa_cc_utils.log_message('GMS: Pre_import l_task_number :'|| l_task_number);
2069: pa_cc_utils.log_message('GMS: Pre_import l_task_number_last :'|| l_task_number_last);
2070: --
2071: -- bug : 3628820 perf issue in gmsawdeb.pls
2072: -- FTS on pa_projects and pa_tasks table.
2073: --

Line 2082: pa_cc_utils.log_message(pa_debug.G_err_stage);

2078:
2079: IF X_status is NULL THEN
2080: pa_debug.G_err_stage := 'CAlling ValidateOrgId';
2081:
2082: pa_cc_utils.log_message(pa_debug.G_err_stage);
2083:
2084: PA_TRX_IMPORT.ValidateOrgId(TrxRec.org_id,X_org_status );
2085: END IF ;
2086: IF ( X_org_status IS NOT NULL ) THEN

Line 2092: pa_cc_utils.log_message(pa_debug.G_err_stage);

2088: X_status := X_org_status;
2089: ELSE
2090: -- org id is not null. continue with other validations
2091: pa_debug.G_err_stage := 'CAlling ValidateItem';
2092: pa_cc_utils.log_message(pa_debug.G_err_stage);
2093: l_emporg_id := NULL ;
2094: l_empjob_id := NULL ;
2095:
2096: IF NVL(l_emp_org_oride, 'N') = 'N' AND

Line 2190: pa_cc_utils.reset_curr_function;

2186: , TrxRec.person_type
2187: , TrxRec.po_price_type
2188: );
2189:
2190: pa_cc_utils.reset_curr_function;
2191:
2192: END IF ;
2193:
2194: IF ( X_status IS NOT NULL ) THEN

Line 2198: pa_cc_utils.log_message(pa_debug.G_err_stage);

2194: IF ( X_status IS NOT NULL ) THEN
2195:
2196: pa_debug.G_err_stage := 'Updating txn interface table for txn'||
2197: ' rejected by validateitem';
2198: pa_cc_utils.log_message(pa_debug.G_err_stage);
2199:
2200: UPDATE pa_transaction_interface
2201: SET transaction_rejection_code = X_status ,
2202: interface_id = P_xface_id ,

Line 2206: pa_cc_utils.reset_curr_function;

2202: interface_id = P_xface_id ,
2203: transaction_status_code = 'PR'
2204: WHERE CURRENT OF TrxRecs;
2205:
2206: pa_cc_utils.reset_curr_function;
2207: ELSE
2208: -- =================================================
2209: -- Identify the record for distribution.
2210: -- ================================================

Line 2325: pa_cc_utils.log_message('Insert record into gms_distributions :'||to_char(count_rec));

2321: SYSDATE
2322: ) ;
2323: END LOOP ;
2324:
2325: pa_cc_utils.log_message('Insert record into gms_distributions :'||to_char(count_rec));
2326: -- =====================================
2327: -- There is nothing to distribute.
2328: -- =====================================
2329: IF x_record_found = 0 THEN

Line 2330: pa_cc_utils.reset_curr_function;

2326: -- =====================================
2327: -- There is nothing to distribute.
2328: -- =====================================
2329: IF x_record_found = 0 THEN
2330: pa_cc_utils.reset_curr_function;
2331: pa_cc_utils.log_message('Nothing found for distributions -PRE_IMPORT EXIT');
2332: return ;
2333: END IF ;
2334: -- =================================================

Line 2331: pa_cc_utils.log_message('Nothing found for distributions -PRE_IMPORT EXIT');

2327: -- There is nothing to distribute.
2328: -- =====================================
2329: IF x_record_found = 0 THEN
2330: pa_cc_utils.reset_curr_function;
2331: pa_cc_utils.log_message('Nothing found for distributions -PRE_IMPORT EXIT');
2332: return ;
2333: END IF ;
2334: -- =================================================
2335: -- Distribute records using FAB engine.

Line 2337: pa_cc_utils.log_message('Start gms_award_dist_eng.proc_distribute_records '||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));

2333: END IF ;
2334: -- =================================================
2335: -- Distribute records using FAB engine.
2336: -- =================================================
2337: pa_cc_utils.log_message('Start gms_award_dist_eng.proc_distribute_records '||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
2338:
2339: gms_award_dist_eng.proc_distribute_records(p_xface_id,
2340: 'EXP',
2341: x_accepted,

Line 2343: pa_cc_utils.log_message('End gms_award_dist_eng.proc_distribute_records '||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));

2339: gms_award_dist_eng.proc_distribute_records(p_xface_id,
2340: 'EXP',
2341: x_accepted,
2342: x_rejected ) ;
2343: pa_cc_utils.log_message('End gms_award_dist_eng.proc_distribute_records '||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
2344: -- ==================================================
2345: -- Update 1st distribution into IMPORT tables.
2346: -- ==================================================
2347: -- 3466152

Line 2374: pa_cc_utils.log_message('Update award_id in gms_transaction_interface_all count :'||to_char(SQL%ROWCOUNT));

2370: where C.document_header_id = P_xface_id
2371: and C.distribution_number= 1
2372: and C.document_type = 'EXP' );
2373:
2374: pa_cc_utils.log_message('Update award_id in gms_transaction_interface_all count :'||to_char(SQL%ROWCOUNT));
2375:
2376: -- 3466152
2377: -- import process award distributions doesn't work when batch name is not supplied.
2378: -- removed batch name criteria . Its not needed since txn_interface_id is available.

Line 2403: pa_cc_utils.log_message('Update ( quantity, raw_cost ) in pa_transaction_interface_all count :'||

2399: WHERE C.document_header_id = P_xface_id
2400: and C.distribution_number= 1
2401: and C.document_type = 'EXP' );
2402:
2403: pa_cc_utils.log_message('Update ( quantity, raw_cost ) in pa_transaction_interface_all count :'||
2404: to_char(SQL%ROWCOUNT));
2405: -- 3466152
2406: -- import process award distributions doesn't work when batch name is not supplied.
2407: -- removed batch name criteria . Its not needed since txn_interface_id is available.

Line 2426: pa_cc_utils.log_message('Update distribution recject in pa_transaction_interface_all count :'||to_char(SQL%ROWCOUNT));

2422: WHERE B.document_header_id = P_Xface_id
2423: and B.document_type = 'EXP'
2424: and NVL(B.dist_status,'X') <> 'FABA' ) ;
2425:
2426: pa_cc_utils.log_message('Update distribution recject in pa_transaction_interface_all count :'||to_char(SQL%ROWCOUNT));
2427: -- ===================================================================
2428: -- Insert distributed records into PA_transaction_interface_all and
2429: -- gms_transaction_interface_all. Update the count in
2430: -- pa_transaction_xface_ctrl_all

Line 2436: pa_cc_utils.log_message('END Grants Accounting Pre Import for award Distributions.'||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));

2432: PROC_INSERT_TRANS( P_transaction_source,
2433: p_batch ,
2434: p_user_id ,
2435: p_xface_id ) ;
2436: pa_cc_utils.log_message('END Grants Accounting Pre Import for award Distributions.'||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
2437: pa_cc_utils.reset_curr_function;
2438: EXCEPTION
2439: When OTHERS THEN
2440:

Line 2437: pa_cc_utils.reset_curr_function;

2433: p_batch ,
2434: p_user_id ,
2435: p_xface_id ) ;
2436: pa_cc_utils.log_message('END Grants Accounting Pre Import for award Distributions.'||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
2437: pa_cc_utils.reset_curr_function;
2438: EXCEPTION
2439: When OTHERS THEN
2440:
2441: IF TrxRecs%Isopen THEN

Line 2445: pa_cc_utils.log_message('ERROR Grants Accounting Pre Import for award Distributions.'||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));

2441: IF TrxRecs%Isopen THEN
2442: Close TrxRecs ;
2443: END IF ;
2444:
2445: pa_cc_utils.log_message('ERROR Grants Accounting Pre Import for award Distributions.'||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
2446: pa_cc_utils.log_message('PLSQL ERROR Occured :'||SQLERRM);
2447: pa_cc_utils.reset_curr_function;
2448: ROLLBACK ;
2449: raise_application_error( -20000, SQLERRM ) ;

Line 2446: pa_cc_utils.log_message('PLSQL ERROR Occured :'||SQLERRM);

2442: Close TrxRecs ;
2443: END IF ;
2444:
2445: pa_cc_utils.log_message('ERROR Grants Accounting Pre Import for award Distributions.'||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
2446: pa_cc_utils.log_message('PLSQL ERROR Occured :'||SQLERRM);
2447: pa_cc_utils.reset_curr_function;
2448: ROLLBACK ;
2449: raise_application_error( -20000, SQLERRM ) ;
2450: RAISE ;

Line 2447: pa_cc_utils.reset_curr_function;

2443: END IF ;
2444:
2445: pa_cc_utils.log_message('ERROR Grants Accounting Pre Import for award Distributions.'||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
2446: pa_cc_utils.log_message('PLSQL ERROR Occured :'||SQLERRM);
2447: pa_cc_utils.reset_curr_function;
2448: ROLLBACK ;
2449: raise_application_error( -20000, SQLERRM ) ;
2450: RAISE ;
2451: END PRE_IMPORT ;